1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2006, week 2
2 98 48_Re: DB2 for Z/Os Version 8 Thread Resource Usage12_Roger Miller19_millerrl@US.IBM.COM30_Sun, 8 Oct 2006 14:12:07 -0500741_- For virtual storage, the best summary of the situation is the John Campbell presentations. Here is a pdf and an mp3. http://www.ibm.com/support/docview.wss?rs=64&context=SSEPEK&uid=swg27006985 ftp://ftp.software.ibm.com/software/data/db2zos/DB2VSTORprez.pdf ftp://ftp.software.ibm.com/software/data/db2zos/DB2VSTOR.zip
I hope you have Omegamon or DB2 Performance Expert or DB2 Performance Monitor. The formatting for the IFCID 0225 record includes a calculation for the amount of storage per thread and also the maximum number of threads which can be supported. See slide 13 in the presentation. http://www.ibm.com/software/tivoli/products/omegamon-xe-db2-peex-zos/ http://www.ibm.com/software/data/db2imstools/db2tools/db2pe/ [...]
101 118 40_Re: DB2 Utilities and IBM Z9 ZIIP engine12_Roger Miller19_millerrl@US.IBM.COM30_Sun, 8 Oct 2006 15:06:54 -0500581_ISO-8859-1 I'd suggest that you reduce the trust level for whereever you are get that hearsay and rumors. IBM worked with other vendors through the program, and those who have performance monitors should have product changes out, similar to those in Omegamon, DB2 PM, ... They'd need to work with the System z division for using a zIIP, get the work done, and you could get the improvements. We've already seen announcements. http://www.bmc.com/BMC/News/CDA/hou_PressRelease_detail_intl/0,3824,1231429 3_0_45642649,00.html http://www3.ca.com/press/PressRelease.aspx?CID=81799 [...]
220 158 46_Low DSNTIAUL and SPUFI Execution BP0 Hit Ratio13_Douglas Hecht22_dhecht@DSS.STATE.LA.US30_Sun, 8 Oct 2006 16:24:58 -0500358_- Up until last week, the average bufferpool hit ratio in BP0 for a 24-hour period has been very high (95 to 100%). Now it is between 20 and 30% in both the PM Accounting and Statistics Reports.
Only the V7 Catalog and Dictionary Tables reside in BP0. The BP definitions are shown below, including the DWQT and VDWQT values (zero in both cases.) [...]
379 71 45_(Fwd) (Fwd) Re: [DB2-L] recover dropped table14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Mon, 9 Oct 2006 12:18:53 +1000392_US-ASCII In case you haven't realised it, you don't need to know the OBID of the dropped table before starting this. You generate ID translations of the database, pageset and known (ie undropped) tables. When you run DSN1COPY it will die when it hits the ID of the dropped table - because it wasn't specified: but it tells you the ID (*). You can then rerun DSN1COPY with that extra ID. [...]
451 445 36_Re: Monitoring JDBC on the mainframe17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV30_Mon, 9 Oct 2006 07:34:44 -0500529_us-ascii
Have you looked at OA17619: THREAD HISTORY ZHTCALL DYNAMIC SQL STATEMENT FROM WRONG THREAD?
Rich Gugel State of Wisconsin Department of Administration DB2 Systems Programmer
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hugh Lapham Sent: Friday, October 06, 2006 1:52 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Monitoring JDBC on the mainframe [...]
897 322 61_[ADMIN]: Reminder the CODE PLACE 'archive' & Subject Headings16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM30_Mon, 9 Oct 2006 09:32:55 -0400487_iso-8859-1
I want to drop you a line to remind everyone that
1) If you ware looking for any code/tips/etc. IDUG has created the 'CODE PLACE' area/web page within the WWW.IDUG.ORG web site. This is a replacement for the old listserv DB2-l-documents. I have been entering a number of different 'Timbits' (for those who know Tim Hortons (a mostly Canadian donut shop) ) already. We have tried to get as much information from the old listserv as we could get. [...]
1220 146 72_Re: db2 V.7 : calling a CICS+COBOL program from a COBOL Stored procedure23_Parvathavardhini Kannan19_pkannan@INAUTIX.COM30_Mon, 9 Oct 2006 19:22:03 +0530476_US-ASCII Hi all,
Thanks for all the information. We referred to all the manuals & now we feel we can use DSNACICS for calling our CICS transaction. But we are getting errors when we try to compile/bind the stored procedure.
We are not sure of how the parameters can be declared.
The DB2 administration Guide provides a Example of DSNACICS invocation but it is PL/I example. Can some one tell us how this example looks like when translated to COBOL ? [...]
1367 22 23_table recovery - thanks17_Mariusz Stakowski20_stakowskim@PROKOM.PL30_Mon, 9 Oct 2006 09:00:26 -0500337_- Hello list,
Thank you very much for the help. We will try the method using OBID translation. As for recovery software limitations - it was limit imposed on number of OBIDs in OBIDXLAT list. It was maximum 500 OBIDs. But not so long ago it was increased to 1000 by APAR PK05758. I have learned about this APAR this morning. [...]
1390 21 72_Re: db2 V.7 : calling a CICS+COBOL program from a COBOL Stored procedure17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV30_Mon, 9 Oct 2006 09:19:26 -0500643_us-ascii Take a look at SG24-7083-00 Stored propcedures through the call and beyond
Rich Gugel State of Wisconsin Department of Administration DB2 Systems Programmer
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
1412 23 27_db2 authentication over PAM25_SUBSCRIBE DB2-L dave dave28_vishalsaibaba@REDIFFMAIL.COM30_Mon, 9 Oct 2006 09:35:20 -0500537_- Hi All..
I have just build up the new db2 server and after building up i come to knew that i have to configure the db2 to authenticate over the PAM. I am not able to connect remotely to the db2 server because of the authentication issues over the PAM. I have contacted the IBM SUPPORT for this and the advise from the IBM SUPPORT is that you have to write a security plugins to authenticate over the PAM. Can Please someone has experiance over this PAM AUTHENTICATION . Is there any PAM security plugins are out on the web [...]
1436 33 58_DB2 LUW V8 Checking for DBADM inside a trigger or function12_Erick Wodarz22_ewodarz@LOGISYS911.COM30_Mon, 9 Oct 2006 14:37:19 -0500578_- Hello List, I have been tasked with preventing updates to a table based on one of the columns values. This would be much easier to implement with a trigger signaling an SQLSTATE than in the application, but I need to allow the instance owner (or someone with DBADM) to update this table. Is there an easy way to do this in the trigger or a sql procedure/function? The only solution I could think of was to check the CURRENT USER register against the tabschema in the syscat.tables table (there are multiple databases with mulitple instance/schema names, so I can't refer [...]
1470 71 62_Re: DB2 LUW V8 Checking for DBADM inside a trigger or function31_Owens, Craig, CTR, OASD(HA)/TMA27_Craig.Owens.ctr@TMA.OSD.MIL30_Mon, 9 Oct 2006 14:58:49 -0600363_US-ASCII Erick,
Wouldn't the database instance owner and anyone with DBADM already contain the necessary authorization to update this table? Then with more strict grant update permissions on the table/view, other users would receive a -551 SQLCODE. Of course, the application would need to catch the SQL exception and deliver the appropriate message. [...]
1542 95 63_Re: DB2 LUW V8 Checking for DBADM inside a trigger or fun ction12_Erick Wodarz22_ewodarz@LOGISYS911.COM30_Mon, 9 Oct 2006 15:07:09 -0600616_iso-8859-1 Hi Craig, Sorry I wasn't very clear. Everyone should be able to delete/insert/update the table, except when the ReportStatus column, is 'P' for 'PROCESSED'. Non-Admin's should not be able to modify these records, but Admin's (who will have DBADMIN authority) should be able to modify any record.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Owens, Craig, CTR, OASD(HA)/TMA Sent: Monday, October 09, 2006 14:59 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 LUW V8 Checking for DBADM inside a trigger or function [...]
1638 140 63_Re: DB2 LUW V8 Checking for DBADM inside a trigger or fun ction31_Owens, Craig, CTR, OASD(HA)/TMA27_Craig.Owens.ctr@TMA.OSD.MIL30_Mon, 9 Oct 2006 15:24:09 -0600376_US-ASCII Erick,
A few options that I see...
1) I presume that the DBADMIN group you mention is the DB2 permission granted at the database level. If so, then your application can request an update via a stored proc which would interrogate the sysibm.sysdbauth table to see if the CURRENT USER has DBADM authority when updates to Processed rows is requested. [...]
1779 96 63_Re: DB2 LUW V8 Checking for DBADM inside a trigger or fun ction14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 10 Oct 2006 10:57:58 +1000611_US-ASCII What about creating a view on the table with ReportStatus <> 'P'; everyone has SIUD access to this view. Everyone has select access to the base table; only admins have IUD access.
Who sets ReportStatus = 'P'? Maybe the view MUST not have WITH CHECK OPTION.
James Campbell
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of Erick Wodarz > Sent: Monday, October 09, 2006 3:07 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] DB2 LUW V8 Checking for DBADM inside a trigger or > fun ction > > > Hi Craig, > Sorry [...]
1876 16 40_Re: Odd characters for jobnames in V8 CM12_Raymond Bell22_raymond.bell@LANDG.COM31_Tue, 10 Oct 2006 05:41:22 -0500680_- OK, so no one else has an issue with 8-character userids with the pound symbol in them under DB2 V8, eh? Just us lucky sods. OK, fine, just thought I'd ask.
Raymond Bell Database Administrator
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
1893 14 40_Re: DB2 Utilities and IBM Z9 ZIIP engine14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Tue, 10 Oct 2006 06:21:35 -0500535_US-ASCII Roger, thank you for such a detailed explanation. Mark.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
1908 232 51_Compuware October 2006 Technical Spotlight Sessions17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Tue, 10 Oct 2006 13:39:22 +0100389_us-ascii Hi All,
please find below the October schedule for Spotlight Sessions, for all you Compuware users/customers out there.
Remember, our customers are required to register for FrontLine to access these sessions, today's 10th October Spotlight (at 4 pm CET) is a great opportunity to register and gain an insight and understanding of how FrontLine can benefit you. [...]
2141 35 55_Re: Compuware October 2006 Technical Spotlight Sessions10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Tue, 10 Oct 2006 14:42:59 +0200155_US-ASCII Posso venire anch'io ??
Ciao bea
Max Scarpa
---------------------------------------------------------------------------------
2177 13 48_Re: Interruption of Long Running Queries by User13_Wolfgang Hini39_wolfgang.hini@HIPERFORMANCE-SOFTWARE.DE31_Tue, 10 Oct 2006 07:49:18 -0500568_- Thank you Bart. I just tested it this DB2 Version 8 for zOS and its wonderfull.
Wolfgang
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
2191 160 38_[z/OS] Exciting bit of SQL for the day13_Bell, Raymond22_raymond.bell@LANDG.COM31_Tue, 10 Oct 2006 15:05:49 +0100337_iso-8859-1 OK, all you pound disbelievers. This one's for any of you on DB2 for z/OS V8, preferably CM but I suspect it doesn't matter, on any CCSID other than 37 and 500.
Try running the following SQL and see how far you get. Choose your SQL processor of choice - I like QMF and SPUFI, and get a different failure for each: [...]
2352 185 42_Re: [z/OS] Exciting bit of SQL for the day13_Richard Fazio21_rfazio@TRANSUNION.COM31_Tue, 10 Oct 2006 09:14:07 -0500441_ISO-8859-1 Rather than trying to get a £ to work in your SQL....I think it would be easier to simply convert to a different monetary unit.
I know "$" works well. I'm not too sure about the Euro...I would expect a similar state of fubar.
faz
Rich Fazio Information Architecture
TransUnion, LLC Marketing Services, 8th Floor 555 West Adams St. Chicago, IL 60661 Phone (312) 985-3270 Fax (312) 466-6453 [...]
2538 419 42_Re: [z/OS] Exciting bit of SQL for the day13_Bell, Raymond22_raymond.bell@LANDG.COM31_Tue, 10 Oct 2006 15:28:15 +0100593_iso-8859-1 Believe it or not, $ is fine. Although at 1.85 to the pound that's debatable...
I get this from QMF:
QUERY MESSAGES: ëBt is not a valid authorization ID.
And from SPUFI:
DSNT408I SQLCODE = -553, ERROR: ëBt...... SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION IDS DSNT418I SQLSTATE = 42503 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXOSPR SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF9C' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION [...]
2958 111 54_Converting a segmented tablespace to partitioned table11_Horn Stefan30_stefan.horn@BRITISH-ENERGY.COM31_Tue, 10 Oct 2006 15:23:03 +0100311_us-ascii Hi
I am currently running in DB2 V8 new function mode, and have the need to convert one of my large tables to table partitioning so that it can grow past 64gb, it all looks fairly straight forward.. Does anyone have any experience of doing this and if so what I might need to look out for. [...]
3070 275 59_Re: Converting a segmented tablespace to partitioned tabl e13_Bell, Raymond22_raymond.bell@LANDG.COM31_Tue, 10 Oct 2006 15:39:26 +0100436_iso-8859-1 British Energy? V8 NFM? CCSID 285 perchance? Tried the SET CURRENT SQLID='S£100000' SQL statement? Go on - you know you want to...
Raymond Bell Database Administrator
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Horn Stefan Sent: 10 October 2006 15:23 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Converting a segmented tablespace to partitioned table [...]
3346 123 63_Re: DB2 LUW V8 Checking for DBADM inside a trigger or fun ction12_Erick Wodarz22_ewodarz@LOGISYS911.COM31_Tue, 10 Oct 2006 09:03:19 -0600560_iso-8859-1 Hi James, Adding a view would require changing too much in the app. The SQL I came up with that should work in all cases AFAIK would be
SELECT grantee from syscat.dbauth where dbadmauth='Y' and grantee=USER;
Thanks for the help.
Erick
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of James Campbell Sent: Monday, October 09, 2006 18:58 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 LUW V8 Checking for DBADM inside a trigger or fun ction [...]
3470 331 42_Re: [z/OS] Exciting bit of SQL for the day13_Bell, Raymond22_raymond.bell@LANDG.COM31_Tue, 10 Oct 2006 16:07:41 +0100404_windows-1257 It means somewhere your SQLID is being converted to Unicode, which is taking the odd symbol (£, or $ in your case) and making it two bytes - as some Unicode characters are - which then makes the value too large for an 8-byte SQLID host variable. Cool, huh?
If you don't use funny characters you'll be OK. But if you do, have a look at PTF PK17422 - might get you out of the poo. [...]
3802 17 26_DB2V8 on ZOS increase cost12_Marty Kenney24_marty.kenney@RAILINC.COM31_Tue, 10 Oct 2006 10:16:21 -0500425_- Our outsource provider has indicated that the licensing has dramatically increased from DB2V7 to DB2V8 and they will be charging our company an additional $350,000 per year when the version 8 tape is ordered.
Has anyone else heard of this large of an increase?
It is going to be nearly impossible to justify the upgrade and stop our management from there plans to move from mainframe/DB2 to UNIX/Oracle. [...]
3820 68 30_Re: DB2V8 on ZOS increase cost35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 10 Oct 2006 11:39:04 -0400581_iso-8859-1 Marty,
The additional costs are always relative to the size of your machine - but one might wonder if your outsourcer is adding a chunk on top of the higher cost from IBM. It should not be too difficult to find out how much the IBM differential really is.
I'm sure your management is convinced that the Oracle solution is less expensive - but nobody has (that I have ever seen) ever proven that cost to be less. Only the initial estimates are lower. Oracle will never guarantee that the full implementation cost and operation costs will be even close [...]
3889 59 30_Re: DB2V8 on ZOS increase cost11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Tue, 10 Oct 2006 10:43:13 -0500464_us-ascii Marty
It's really hard to tell you whether this is excessive or not without a context. The increase that I have seen for V8 costs is approximately 15 - 18 % increase over V7. I would suspect anything larger than that to be quite unusual.
Tom Moulder TREX Associates, Inc. 9728 Delmonico Dr. Keller, Tx. 76248-9559 +1 817 741-5549 Office +1 817 741-5548 Fax +1 682 558-6527 Mobile tom.moulder@trexassociates.com www.t-rex-associates.com [...]
3949 73 30_Re: DB2V8 on ZOS increase cost12_Richards.Bob25_Bob.Richards@SUNTRUST.COM31_Tue, 10 Oct 2006 12:05:00 -0400312_us-ascii We are a fair sized DB2 shop (800-900 DB2 MSUs per month) and those numbers seem way out of whack. We are not at NFM yet and I've seen less than an 8% increase (workload/usage dependent).
Are they trying to fund a zIIP purchase and put it on your tab? Are you running over 1500 MSUs of DB2? [...]
4023 446 30_Re: DB2V8 on ZOS increase cost11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Tue, 10 Oct 2006 11:11:24 -0500760_us-ascii OOPS
I forgot the link
http://searchdatacenter.techtarget.com/originalContent/0,289142,sid80_gci121 4459,00.html?track=NL-576 &ad=563693&asrc=EM_NLT_514124&uid=1718791
Quoting Joel Goldstein --
I'm sure your management is convinced that the Oracle solution is less
expensive - but nobody has
(that I have ever seen) ever proven that cost to be less. Only the initial
estimates are lower.
Oracle will never guarantee that the full implementation cost and operation [...]
4470 39 30_Re: DB2V8 on ZOS increase cost13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Tue, 10 Oct 2006 12:17:23 -0400535_us-ascii This increase in cost is strictly for the licensing.
We run a data sharing environment with a 2064 CPU (around 800 MIPS) and a 2064 CPU (I think around 300 MIPS) As far as I know they are not including a zIIP in this
Marty Kenney Sr. DB2 DBA (919) 651-5211
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Richards.Bob Sent: Tuesday, October 10, 2006 12:05 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V8 on ZOS increase cost [...]
4510 89 30_Re: DB2V8 on ZOS increase cost12_Richards.Bob25_Bob.Richards@SUNTRUST.COM31_Tue, 10 Oct 2006 12:46:02 -0400561_us-ascii zIIP is not supported on z900 machines. So we know they aren't doing that.
Find out *how* they are billing you for DB2. Is it Parallel Sysplex License Charge, Workload License Charge, Variable Workload License Charge, or Measured Usage License Charge? Or black magic?
I have "lpars" running more DB2 MIPS than you have CPU MIPS and my bill on those lpars for DB2 V8 is LESS THAN your projected increase. Granted, because of my machine sizes, I pay less per MSU usage than you do, but that projected increase begs for an explanation. [...]
4600 19 35_Websphere Default Isolation for DB212_Phil Godfrin18_pgodfrin@CHUBB.COM31_Tue, 10 Oct 2006 13:08:43 -0500763_- Greetings,
Does anyone know how to change the default Isolation Level for Websphere DB2 connections? Is there a difference between how you do it in v5 and v6 (of websphere)?
It looks like RR is the default - I'd rather have CS (for obvious reasons)
thanks, phil godfrin
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
4620 393 16_DB2 Forum Oct 129_Bob Brock28_brock@KRYPTON-CONSULTING.COM31_Tue, 10 Oct 2006 14:17:43 -0500467_iso-8859-1
DB2 Forum - The Southwest DB2 Users Group. Visit our webpage at: http://www.db2forum.com
Come to the 4th Quarter DB2 Forum Meeting. DB2 Forum would like to thank ITgain for sponsoring this meeting.
Date: Thursday October 12, 2006
Location: Holiday Inn Select North Dallas
2645 LBJ Freeway
Dallas, TX 75234
Phone - 972.243.3363
Registration & Continental Breakfast: 8:00 A.M. - 9:00 A.M [...]
5014 386 43_Don't miss tomorrow's meeting HOTDUG Oct 119_Bob Brock28_brock@KRYPTON-CONSULTING.COM31_Tue, 10 Oct 2006 14:18:38 -0500435_iso-8859-1 HOTDUG - The Austin DB2 User Group See our meeting announcement at: http://www.krypton-consulting.com/usergroup.htm
Come to the 4th Quarter DB2 Forum Meeting. DB2 Forum would like to thank ITgain for sponsoring this meeting.
Date: Wednesday October 11, 2006
Location: Department of Public Safety (DPS)
Criminal Law Enforcement (CLE) conference room, Building E
5805 North Lamar Blvd. [...]
5401 366 17_DB2 V7 on ZOS 1.616_Proctor, William25_william.proctor@TGSLC.ORG31_Tue, 10 Oct 2006 14:38:14 -0500386_us-ascii Thanks for all replies in advance.
I have run the HealthCheck software for checking your catalog statistics and I've been able to fix all of my problems except the following. I have removed the statistics in SYSIBM.SYSCOLDIST which gets rid of the message but when I rerun RUNSTATS the message returns. What am I not doing to get rid of this error? [...]
5768 274 31_Re: DB2V8 on ZOS increased cost35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 10 Oct 2006 15:41:04 -0400360_iso-8859-1 Tom,
That is a very interesting article, and there have been some similar ones over the last couple of years. However, there are a few analyses and comments by industry people too, that raise a few questions and counterpoints. Oracle is not mentioned in this scenario, and that's where I've heard most of the huge cost over run stories. [...]
6043 166 97_FW: Another BIG Mainframe Bites the Dust (the Samsung conversion off of zSeries from a principal)12_McKown, John29_John.Mckown@HEALTHMARKETS.COM31_Tue, 10 Oct 2006 15:00:16 -0500250_US-ASCII This was posted on the IBM-MAIN about this Samsung conversion. It appears that the workload was suited for a UNIX system and was properly planned and implemented. It is from a person who indicates that he was very involved with this.
6210 310 34_Antwort: [DB2-L] DB2 V7 on ZOS 1.611_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 11 Oct 2006 07:56:16 +0200334_iso-8859-1 Hi Bill!
Strange that you posted this to listserv instead of direct to NEON or us but anyway.....
The first S (Serious) problem is caused by a FREQVAL for the leading column being missing. If you use FREQVAL you *must* also specify FREQVAL NUMCOLS 1 COUNT nnn so simply change you RUNSTATS to look like: [...]
6521 51 25_Re: recover dropped table12_Haak, Enrico19_Enrico_Haak@BMC.COM31_Wed, 11 Oct 2006 08:37:36 +0200436_us-ascii Hi Mariusz,
there are other vendors besides CA who will support this task. Guess who? ;-) If you want to get detailed information, drop me a line
Regards, Enrico
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mariusz Stakowski Sent: Saturday, October 07, 2006 6:56 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] recover dropped table [...]
6573 432 59_Re: Converting a segmented tablespace to partitioned tabl e12_Travis, John25_john.travis@CAPGEMINI.COM31_Wed, 11 Oct 2006 08:25:00 +0100676_iso-8859-1
Raymond,
CCSID 285 fails as expected :-
---------+---------+---------+---------+---------+---------+---------+------ ---+ SET CURRENT SQLID= 'S£100000' ; 00010099 ---------+---------+---------+---------+---------+---------+---------+------ ---+ DSNT408I SQLCODE = -102, ERROR: LITERAL STRING IS TOO LONG. STRING BEGINS
S£100000
John Travis DBA
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond Sent: 10 October 2006 15:39 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Converting a segmented tablespace to partitioned tabl e [...]
7006 51 59_Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for the day11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 11 Oct 2006 09:38:06 +0200399_us-ascii you will be glad to know that the pound sign, the paragraph sign *and* the euro sign all die in V8 NFM in Germany.
Looks like we must change to the Australian Dollar....
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de [...]
7058 86 59_Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for the day11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 11 Oct 2006 09:41:08 +0200593_iso-8859-1 I also just checked in V8 CM and the results are the same...
--SET CURRENT SQLID='S£100000'; 00010004 --SET CURRENT SQLID='S§100000'; 00020005 SET CURRENT SQLID='S€100000'; 00030005 ---------+---------+---------+---------+---------+---------+---------+---------+ DSNT408I SQLCODE = -102, ERROR: LITERAL STRING IS TOO LONG. STRING BEGINS S€100000
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de [...]
7145 289 64_Re: Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for t he day13_Bell, Raymond22_raymond.bell@LANDG.COM31_Wed, 11 Oct 2006 09:18:28 +0100602_iso-8859-1 John, Roy, etc.,
Thanks for confirming what I hoped (kind of) wasn't an isolated problem. It's kinda our own problem for putting these daft characters in userids/jobnames in the first place. Still, nice to know we're not alone.
We do have some alternative solutions - use a different ID, apply 'that' PTF, maybe look at changing the CCSID of the ISV software to match ours (they use 500; we've got 285) - so we're not dead in the water. Although, Roy, you might be soon. If you do convert to Aussie dollars I'll ring up my mates in the RNZ [...]
7435 272 30_Re: DB2V8 on ZOS increase cost13_Michael Ebert18_mebert@AMADEUS.COM31_Wed, 11 Oct 2006 10:21:34 +0200549_US-ASCII Hm, the story is pretty new. It would be nice to know what develops over time. Of course, if they start facing problems, it is unlikely that they are going to make a similar press release about them.
It's good that they never had an outage. If one node goes down, the other will have to run at 120%. And it seems Unix reacts badly to 100% usage of any resource. Our mainframe has been running at 100% CPU for months before the two biggest apps were converted to Unix/Oracle and never had a problem (apart from getting me pretty [...]
7708 61 39_Re: Websphere Default Isolation for DB213_Mertens, Bart18_bart.mertens@CZ.NL31_Wed, 11 Oct 2006 11:12:37 +0200625_us-ascii Phil,
You can set the custom property webSphereDefaultIsolationLevel at the datasource level. Set it to 2 to use cursor stability as the default.
Regards, Bart
-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Phil Godfrin Verzonden: dinsdag 10 oktober 2006 20:09 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: [DB2-L] Websphere Default Isolation for DB2
Greetings,
Does anyone know how to change the default Isolation Level for Websphere DB2 connections? Is there a difference between how you do it in v5 and v6 (of websphere)? [...]
7770 24 41_All stored procedures stopped by 1 abend?13_Peter Verbeek28_peter.verbeek@ATOSORIGIN.COM31_Wed, 11 Oct 2006 04:37:30 -0500321_- Hi, we are running DB2 V7 on z/OS 1.7 and stored procedures in the DB2- established stored procedures address space.
In the last few weeks we encountered some strange (to me) problems. It seems as if 1 abending SP caused ALL SP's to be stopped instead of only the abending SP. We have STORMXAB=0 (default). [...]
7795 97 31_Re: DB2V8 on ZOS increased cost7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 11 Oct 2006 02:52:26 -0700541_iso-8859-1 Interesting discussion.
We have a running joke at our shop; if you need to buy something for a "Z" series system add a zero to the left of the decimal point compared to similar technology on anything else. It tends to work out.
Given that IBM is now a sole supplier for z/OS engines, and the system software that runs on them, and for many of us, the sole supplier of hardware maintenance (we are in Mass. which some don't consider part of the U.S. but I do), IBM has very little incentive to compete on price. [...]
7893 324 65_[OFF] [z/OS] Exciting bit of SQL for t he day - meeting for beer?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 11 Oct 2006 12:50:50 +0200454_iso-8859-1 Hi fellow listers!
Off topic but I would be very interested to know many of you will be attending the GSE UK Conference 2006 "Making IT smarter, simpler" perhaps we could all meet up and SHARE some beers? Just a thought...
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de [...]
8218 121 70_Re: [OFF] [z/OS] Exciting bit of SQL for t he day - meeti ng for beer?13_Bell, Raymond22_raymond.bell@LANDG.COM31_Wed, 11 Oct 2006 12:03:02 +0100564_- I'll be there. It'll be my first time. Ahhhh, bless...
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: 11 October 2006 11:51 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] [OFF] [z/OS] Exciting bit of SQL for t he day - meeting for beer?
Hi fellow listers!
Off topic but I would be very interested to know many of you will be attending the GSE UK Conference 2006 "Making IT smarter, simpler" perhaps we could all meet up and SHARE some beers? Just a thought... [...]
8340 417 64_Re: Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for t he day15_Byron C. Pierce27_byron.pierce@PRUDENTIAL.COM31_Wed, 11 Oct 2006 07:05:07 -0400559_iso-8859-1
I wonder if they are other 'non-Euro' special characters that might translate in a similar fashion ?
Anybody know ?
Byron C. Pierce Prudential Retirement Technology Database Services - H07B Work: 860.534.4222 Mail: Byron.Pierce@Prudential.com
"Bell, Raymond" To DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc Base Discussion List Subject [z/OS] Exciting bit of SQL for t he day [...]
8758 55 81_Antwort: Re: [DB2-L] Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for t he day11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 11 Oct 2006 13:21:25 +0200438_iso-8859-1 basically put any "non-national" character will get this. For example any german umlaut ä,Ä,ü,Ü,ß etc etc pick any one....
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de
---------------------------------------------------------------------------------
8814 283 49_IBM Information on Demand Conference Exhibit note16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Wed, 11 Oct 2006 08:07:06 -0400432_iso-8859-1
Optimize the Value of your Mainframe Investment with Compuware
Please join Compuware at IBM Information on Demand. We will be located at booth 706/720.
.
Stop by our booth to learn how to:
· Manage application performance without increasing overhead
· Prevent exposure of your sensitive data
· Get the most out of DB2 and IMS [...]
9098 438 53_Re: IBM Information on Demand Conference Exhibit note13_Bell, Raymond22_raymond.bell@LANDG.COM31_Wed, 11 Oct 2006 13:11:39 +0100467_iso-8859-1 Robert,
I'm sorry, but which square bracket category should this have come under? I don't seem to have your handy reminder note, er, handy.
Cheers,
Raymond Bell Database Administrator
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galambos, Robert Sent: 11 October 2006 13:07 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IBM Information on Demand Conference Exhibit note [...]
9537 30 60_How to relate DB2 storage groups to SMS storage groups ?????13_javier sotela19_jsotela@HOTMAIL.COM31_Wed, 11 Oct 2006 09:01:14 -0400526_- Hi Everybody:
We are in the process of defining how to work with our new db2. Checking the options that we have, we decide to use all our db2 files under SMS. The question tha we have its how to relate our db2 storage group to our sms storage groups. We test some options, defining a data class in sms and assign it to the the RACF user for the db2 address space, or using naming conventioning assigning a storage class accordind the name prefix of the file, but I'm not sure if this is all the options that ewe [...]
9568 89 53_[z/OS] DESCSTAT question or why is my SPT01 so large?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 11 Oct 2006 15:03:03 +0200556_us-ascii Hi listers!
I have been investigating why our DB2 V8 NF system has such a large SPT01 in comparison with our good old V7. For one collection I picked at random (ok ok its full of static SELECT statements with loads of columns...) in V7 the size was 8.850.249 bytes in V8 the size is 14.679.539 bytes. I also noticed that packages that contain only dynamic SQL or just ROLLBACK and COMMIT have gone from 1424 bytes in V7 to 3344 in V8 (This is the base PKSIZE of course as these packages contain no sections). Now comes the interesting [...]
9658 96 64_Re: How to relate DB2 storage groups to SMS storage groups ?????13_Carol Broyles21_clbroyles55@YAHOO.COM31_Wed, 11 Oct 2006 06:51:42 -0700622_ascii Javier, We define all DB2 stogroups with VOLUMES(*) and let SMS totally manage the disk. We set up our SMS storage groups to put BSDS and active logs in one group, catalog and directory in another group, and all other pagesets in another group. We don't mix data from different DB2 systems. This allows us to use the V8 system backup and system restore features. Carol ----- Original Message ---- From: javier sotela To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, October 11, 2006 9:01:14 AM Subject: [DB2-L] How to relate DB2 storage groups to SMS storage groups ????? Hi Everybody: We are [...]
9755 309 31_Re: DB2V8 on ZOS increased cost11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Wed, 11 Oct 2006 09:09:05 -0500340_us-ascii Quoting Ed Long ---
Given that IBM is now a sole supplier for z/OS engines, and the system software that runs on them, and for many of us, the sole supplier of hardware maintenance (we are in Mass. which some don't consider part of the U.S. but I do), IBM has very little incentive to compete on price. [...]
10065 92 64_Re: How to relate DB2 storage groups to SMS storage groups ?????13_javier sotela19_jsotela@HOTMAIL.COM31_Wed, 11 Oct 2006 10:15:45 -0400649_- Carol:
How you set up SMS to do that ??? Are you using the smsdcfl and smsdcix ???? How you can assign different sms storage group to any different kind of file ???
Thanks.
J. Sotela
>From: Carol Broyles >Reply-To: DB2 Database Discussion list at IDUG >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] How to relate DB2 storage groups to SMS storage groups >????? >Date: Wed, 11 Oct 2006 06:51:42 -0700 > >Javier, > >We define all DB2 stogroups with VOLUMES(*) and let SMS totally manage the >disk. We set up our SMS storage groups to put BSDS and active [...]
10158 193 57_Re: [z/OS] DESCSTAT question or why is my SPT01 so large?13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 11 Oct 2006 09:24:30 -0500479_us-ascii Could moving to 64 bit be playing a part in the increase in size? Is this the first time these packages have been bound under DB2 V8? If so, instructions, addresses, and registers are no longer 31 bit. They have increased (almost doubled) in size so this might explain the increase in the size of your packages. However, if you bound these same plans in CM and you are seeing the increase when you are rebinding them in NFM, then the 64 bit stuff is not the cause. [...]
10352 45 25_Re: recover dropped table0_22_DB2information@AOL.COM29_Wed, 11 Oct 2006 10:38:02 EDT631_US-ASCII Hello, To automate collecting the DBID, PSID, and all OBIDs view: www.recoveryknowledge.com This way generating the JCL and control cards is automated.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
10398 87 64_Re: How to relate DB2 storage groups to SMS storage groups ?????13_Carol Broyles21_clbroyles55@YAHOO.COM31_Wed, 11 Oct 2006 07:40:23 -0700612_ascii Javier, I can't get into the specifics much, since I don't do DASD administration. I know we set up the ACS routines to allocate based on the file name. For example, if the data set name is: hi-level.DSNDBC.DSNDB01.** or hi-level.DSNDBC.DSNDB06.** then the file goes to the catalog/directory stogroup. If the file name is: hi-level.ssid.BSDS*.** or hi-level.ssid.LOGCOPY*.** then the file goes to the stogroup for the logs and BSDS. All the other files go into a storage group based on the hi-level qualifier only. Our systems are set up to use the group attach name as the hi-level qualifier. We put [...]
10486 15 40_Re: DB2 Utilities and IBM Z9 ZIIP engine14_Paul Peplinski24_paul.peplinski@WPSIC.COM31_Wed, 11 Oct 2006 09:36:55 -0500276_- Verifying zIIP eligibility in z/OS DB2 V8 CM. Do you get all right off the bat or does some funcitonality kick in at NFM. In either case where is the reference or is it just common knowledge? All references I see seem dated and do not differentiate between CM and NFM. [...]
10502 236 65_Re: How to relate DB2 storage groups to SMS storage group s ?????11_Horn Stefan30_stefan.horn@BRITISH-ENERGY.COM31_Wed, 11 Oct 2006 15:50:06 +0100395_us-ascii Hi,
we do the same .. note that the storage groups referred to are sms storage groups, its easy to get confused
stef
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Carol Broyles Sent: 11 October 2006 15:40 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] How to relate DB2 storage groups to SMS storage groups ????? [...]
10739 38 40_Re: DB2 Utilities and IBM Z9 ZIIP engine13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 11 Oct 2006 10:24:46 -0500690_us-ascii The zIIP specialty engines can be used by DB2 V8 in Compatibility Mode (CM).
Willie
Paul Peplinski wrote:
>Verifying zIIP eligibility in z/OS DB2 V8 CM. Do you get all right off the >bat or does some funcitonality kick in at NFM. In either case where is the >reference or is it just common knowledge? All references I see seem dated >and do not differentiate between CM and NFM. > >Paul > >--------------------------------------------------------------------------------- >Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The [...]
10778 90 64_Re: How to relate DB2 storage groups to SMS storage groups ?????13_javier sotela19_jsotela@HOTMAIL.COM31_Wed, 11 Oct 2006 12:15:17 -0400658_- Hi Everyone:
Its the people using this technique ?? Carol are you using the parms SMSDCFL and SMSDCIX in the TIJUZ ??? Are the people creating a special user to the db2 address space and assign a SMS Data Class to this user ????
Thanks.
J. Sotela
>From: Carol Broyles >Reply-To: DB2 Database Discussion list at IDUG >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] How to relate DB2 storage groups to SMS storage groups >????? >Date: Wed, 11 Oct 2006 07:40:23 -0700 > >Javier, > >I can't get into the specifics much, since I don't do DASD administration. >I know [...]
10869 266 64_Re: How to relate DB2 storage groups to SMS storage groups ?????13_Michael Ebert18_mebert@AMADEUS.COM31_Wed, 11 Oct 2006 18:37:10 +0200339_US-ASCII We are (well... were) using the same technique as Carol. The two parms you mention are not needed. If I remember correctly, they were for SAP with its huge number of objects with wild names, if you insisted that having tablespaces and indexes on completely separate disks would be important (an Oracle/Unix-leftover really). [...]
11136 162 43_Re: DB2V8 on ZOS increase cost (the answer)13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Wed, 11 Oct 2006 13:11:31 -0400368_us-ascii Our outsource provider had to redo their licensing contract with IBM and DB2 (and many others) software is no longer bundled in their agreement. It is a separate charge.
The very large increase in licensing is because of this new contract with IBM comparing DB2V8 costs under the new agreement, with DB2V7 under the old agreement. [...]
11299 232 43_Re: DB2V8 on ZOS increase cost (the answer)35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 11 Oct 2006 13:31:08 -0400296_iso-8859-1 Look for another outsourcer with better pricing, or deal making capabilities. That much of an increase still does not sound right, no matter how it was packaged, sliced or diced. If you're getting hosed that much just on DB2, how much of a hit are you taking with other products? [...]
11532 24 30_z/OS DB2 V8 CM and DB2 Connect14_Paul Peplinski24_paul.peplinski@WPSIC.COM31_Wed, 11 Oct 2006 12:24:33 -0500361_- I already have an open incident on this but I open it up for DB2-L experiences.
We recently upgraded to V8 CM and now DB2 Connect 8.2 SP0 clients are getting SQL30073N error "0X2114" parameter value "0X0000" is not supported - much like APAR JR21645. That APAR mentions running RDRIOBLK=32K as a circumvention but hat has always been our setting. [...]
11557 50 43_Re: DB2V8 on ZOS increase cost (the answer)13_Kenny Fogarty23_kenny.fogarty@GMAIL.COM31_Wed, 11 Oct 2006 18:41:35 +0100576_ISO-8859-1 Yikes!
Isn't outsourcing great?
Cheers, Kenny
* Kenney, Marty wrote, On 11/10/2006 18:11: > > Our outsource provider had to redo their licensing contract with IBM > and DB2 (and many others) software is no longer bundled in their > agreement. It is a separate charge. > > > > The very large increase in licensing is because of this new contract > with IBM comparing DB2V8 costs under the new agreement, with DB2V7 > under the old agreement. > > > > Hopefully, this is not a direction that IBM is heading for main frame > licensing and our [...]
11608 61 64_Re: How to relate DB2 storage groups to SMS storage groups ?????13_Carol Broyles21_clbroyles55@YAHOO.COM31_Wed, 11 Oct 2006 10:53:00 -0700589_ascii Javier, We are not using SMSDCFL or SMSDCIX in the zparms. We have found with the newer disk that we do not have to separate data and indexes. We also do not assign an SMS data class to the DB2 started task user. We do have a data class with the extend attribute assigned for the DB2 SMS storage groups. Some of our tablespaces need to be created with large DSSIZEs. Carol ----- Original Message ---- From: javier sotela To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, October 11, 2006 12:15:17 PM Subject: Re: [DB2-L] How to relate DB2 storage groups to SMS [...]
11670 371 43_Re: DB2V8 on ZOS increase cost (the answer)12_Richards.Bob25_Bob.Richards@SUNTRUST.COM31_Wed, 11 Oct 2006 14:12:39 -0400491_us-ascii Agreed! As I wrote the other day, I saw my base full cap costs only increase by $7,000 per month, $84,000 per year for quadruple the amount of MIPS.
Bob Richards
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Goldstein - Responsive Systems Sent: Wednesday, October 11, 2006 1:31 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V8 on ZOS increase cost (the answer) [...]
12042 199 57_Re: [z/OS] DESCSTAT question or why is my SPT01 so large?13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 11 Oct 2006 09:24:30 -0500479_us-ascii Could moving to 64 bit be playing a part in the increase in size? Is this the first time these packages have been bound under DB2 V8? If so, instructions, addresses, and registers are no longer 31 bit. They have increased (almost doubled) in size so this might explain the increase in the size of your packages. However, if you bound these same plans in CM and you are seeing the increase when you are rebinding them in NFM, then the 64 bit stuff is not the cause. [...]
12242 97 53_[z/OS] DESCSTAT question or why is my SPT01 so large?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 11 Oct 2006 15:03:03 +0200556_us-ascii Hi listers!
I have been investigating why our DB2 V8 NF system has such a large SPT01 in comparison with our good old V7. For one collection I picked at random (ok ok its full of static SELECT statements with loads of columns...) in V7 the size was 8.850.249 bytes in V8 the size is 14.679.539 bytes. I also noticed that packages that contain only dynamic SQL or just ROLLBACK and COMMIT have gone from 1424 bytes in V7 to 3344 in V8 (This is the base PKSIZE of course as these packages contain no sections). Now comes the interesting [...]
12340 259 53_Re: IBM Information on Demand Conference Exhibit note16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Wed, 11 Oct 2006 14:39:26 -0400471_iso-8859-1 OPPPSSSSS
should have been [ADD] I guess.
you now have permission to beat me up with a wet noodle
SORRY
Robert Galambos
Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration robert.galambos@compuware.com
Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1 877-281-1888 [...]
12600 145 14_Re: DB2 Client16_Grossman, Joanna27_Joanna.Grossman@STATE.VT.US31_Wed, 11 Oct 2006 15:03:34 -0400129_us-ascii I've just started using toad
http://www.quest.com/Toad%5Ffor%5FDB2/
and I like it.
12746 373 43_Re: DB2V8 on ZOS increase cost (the answer)12_Richards.Bob25_Bob.Richards@SUNTRUST.COM31_Wed, 11 Oct 2006 14:12:39 -0400491_us-ascii Agreed! As I wrote the other day, I saw my base full cap costs only increase by $7,000 per month, $84,000 per year for quadruple the amount of MIPS.
Bob Richards
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Goldstein - Responsive Systems Sent: Wednesday, October 11, 2006 1:31 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V8 on ZOS increase cost (the answer) [...]
13120 163 34_Re: z/OS DB2 V8 CM and DB2 Connect13_Robert Tilkes22_TILKESR@NATIONWIDE.COM31_Wed, 11 Oct 2006 15:47:46 -0500344_US-ASCII We are running a DB2 Connect Gateway with 8.2 FP 11 and FP13 we are in the process of migrating to FP13 as a recommendation by IBM in order to go to NFM on 11/4. Our Test gateway is FP13 and our production gateway is FP11. We have been in CM with DB2 V.8 since Jun 2006 with no issues with DB2 Connect. Hope this helps. Good Luck [...]
13284 448 43_Re: DB2V8 on ZOS increase cost (the answer)11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Wed, 11 Oct 2006 18:01:58 -0500387_US-ASCII Marty
I may just make you and others crazy.
I get upset when I see the two extremes associated with any discussion of the MF future. I said earlier that we need to avoid putting our head in the sand. Let's don't just stand up and say there is nothing wrong. However, let's not stand up and say that it is the end of the world. [...]
13733 440 64_Re: Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for t he day0_28_steve.tennant@CUSTOMS.GOV.AU31_Thu, 12 Oct 2006 11:23:23 +1000508_iso-8859-1 Ray, "although I suspect most of Oz wouldn't mind if we did."
Well those of us who work in Canberra would mind a little bit. Of course given a couple of days warning........
Cheers,
Have an Adnams for me.
Regards,
Steve T
-----Original Message----- From: Bell, Raymond [mailto:raymond.bell@LANDG.COM] Sent: Wednesday, 11 October 2006 18:18 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for t he day [...]
14174 36 50_Re: Low DSNTIAUL and SPUFI Execution BP0 Hit Ratio17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Wed, 11 Oct 2006 22:33:12 -0500597_- I/O to sysdbase will increase as the number of Full Prepare increases. SPUFI probably has more chance to execute different SQLs from different authid. Hence the cache miss rate could be higher whereas a business application can be executing the same SQL over and over again. If it prepares using parameter markers then chances of cache hit is more likely. I am not sure what type of access to catalog you are questioning. Is it the access during sql optimization or access in general?. Access during SQL optimization will depend on the input SQL, number of tables referred, predicates etc. [...]
14211 50 31_[z/OS] No Statistics Records...22_Cuneyt Goksu (Usa.net)19_cuneytgoksu@USA.NET31_Thu, 12 Oct 2006 12:30:46 +0300312_iso-8859-9 Hello List,
This is DB2 V7 for z/OS.
Although my Stats and Accnt. Traces are On and Perf. is off, I do not see any records from the SMF output for Stats but there are some for Perf.
I was expecting to see some 100,101 records and no 102 records...
Output of SMF Dump. [...]
14262 415 43_Re: DB2V8 on ZOS increase cost (the answer)3_Les21_db2dba@BTINTERNET.COM31_Thu, 12 Oct 2006 12:34:19 +0100510_windows-1250 Sorry to jump in here, but I am a TCO bigot.
I think Z series has to get with the rest of the world on cost (so IBM need to listen), however, my view is (having worked on nearly all the platforms) there is no more a stable platform than z/OS and its associated software (DB2 etc). Add to this the type of personnel that use the z/OS software in comparison to those Unix equivalents and I know what place I would rather have my mission critical applications, and it is not Unix/Oracle. [...]
14678 145 11_Tables OBID14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Thu, 12 Oct 2006 14:53:15 +0300322_us-ascii Hi listers
After a drop/create a table how can I retrieve the previous OBID of that table in order to use it in a DSN1COPY. I usually run the DSN1COPY with wrong previous OBID and there is the message
DSN1970I DSN1TRAN DATA PAGE CONTAINING OBID 000809 HAS NO MATCHING VALUE IN THE SYSXLAT FILE [...]
14824 39 18_OT - IDUG Homepage12_Rodney Krick15_rk@AFORMATIK.DE31_Thu, 12 Oct 2006 13:51:33 +0200336_US-ASCII
Just to check: is someone outside there able to access www.idug.org with response times under 15 minutes??? It seems that the migration to WebSphere Portal Server didn't work well...
Thanks in advance,
Rodney
---------------------------------------------------------------------------------
14864 226 22_Re: OT - IDUG Homepage14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Thu, 12 Oct 2006 14:59:58 +0300516_us-ascii I've just enter the site in a second
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rodney Krick Sent: Thursday, October 12, 2006 2:52 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] OT - IDUG Homepage
Just to check: is someone outside there able to access www.idug.org with response times under 15 minutes??? It seems that the migration to WebSphere Portal Server didn't work well... [...]
15091 101 35_Antwort: [DB2-L] OT - IDUG Homepage11_Roy Boxwell16_R.Boxwell@SEG.DE31_Thu, 12 Oct 2006 13:56:41 +0200493_us-ascii I was there yesterday and it was fine (not sub-second but ok)
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de
Rodney Krick Gesendet von: DB2 Data Base Discussion List 12.10.2006 13:51 Bitte antworten an DB2 Database Discussion list at IDUG [...]
15193 148 30_AW: [DB2-L] OT - IDUG Homepage19_Weber, Thomas (LDS)23_Thomas.Weber@LDS.NRW.DE31_Thu, 12 Oct 2006 13:58:07 +0200716_US-ASCII Hi Rodney,
within 2 seconds from here.
Regards
Thomas _______________________________________________ Thomas Weber LDS NRW Mauerstr. 51 40476 Duesseldorf Germany phone: +49 211 9449 2545 e-mail: thomas.weber@lds.nrw.de
________________________________
Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Rodney Krick Gesendet: Donnerstag, 12. Oktober 2006 13:52 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: [DB2-L] OT - IDUG Homepage
Just to check: is someone outside there able to access www.idug.org with response times under 15 minutes??? It seems that the migration to WebSphere Portal Server didn't work well... [...]
15342 46 18_OT - IDUG Homepage11_Roy Boxwell16_R.Boxwell@SEG.DE31_Thu, 12 Oct 2006 13:58:23 +0200745_us-ascii yep..really fast, I would suspect your firms network.....
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
15389 125 22_Re: OT - IDUG Homepage23_Hall, Dan (GE Comm Fin)15_Dan.Hall@GE.COM31_Thu, 12 Oct 2006 08:03:16 -0400673_US-ASCII No problems at all. Maybe 2 seconds to load the entire page.
Dan Hall GE Capital Solutions Danbury, CT
T 513.217.5060 E dan.hall@ge.com http://www.ge.com/capitalsolutions/
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rodney Krick Sent: Thursday, October 12, 2006 7:52 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] OT - IDUG Homepage
Just to check: is someone outside there able to access www.idug.org with response times under 15 minutes??? It seems that the migration to WebSphere Portal Server didn't work well... [...]
15515 36 18_OT - IDUG Homepage12_Rodney Krick15_rk@AFORMATIK.DE31_Thu, 12 Oct 2006 14:04:02 +0200216_US-ASCII
Thanks for everyone,
I'll try again when I'm back home with my DSL connection ;-)
Rodney
---------------------------------------------------------------------------------
15552 164 22_Re: OT - IDUG Homepage0_39_ramasubramanian.venkateswaran@WIPRO.COM31_Thu, 12 Oct 2006 17:34:44 +0530732_us-ascii
25 secs
Regards, Ramas ------------------------------------------------
Mail To: Ramasubramanian.venkateswaran@wipro.com Mobile - 94440-35640 VOIP - 832 2169 Direct - 91-44-30691084
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rodney Krick Sent: Thursday, October 12, 2006 5:22 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] OT - IDUG Homepage
Just to check: is someone outside there able to access www.idug.org with response times under 15 minutes??? It seems that the migration to WebSphere Portal Server didn't work well... [...]
15717 190 22_Re: OT - IDUG Homepage11_Gene Renico33_generenico@NORTHWESTERNMUTUAL.COM31_Thu, 12 Oct 2006 07:22:09 -0500494_us-ascii Less than 2 seconds
Gene Renico 1W350 PO Box 3173 Milwaukee WI 53201-3173 generenico@northwesternmutual.com (414) 661-8580 IBM Certified Specialist DB2 UDB V6.1/V7.1 User IBM Certified Database Administrator DB2 UDB V8.1 for z/OS
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rodney Krick Sent: Thursday, October 12, 2006 5:22 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] OT - IDUG Homepage [...]
15908 213 15_Re: Tables OBID11_Horn Stefan30_stefan.horn@BRITISH-ENERGY.COM31_Thu, 12 Oct 2006 14:09:18 +0100504_us-ascii hi,
use dsn1prnt using the icopy as input
stef
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galeos Antonis Sent: 12 October 2006 12:53 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Tables OBID
Hi listers
After a drop/create a table how can I retrieve the previous OBID of that table in order to use it in a DSN1COPY. I usually run the DSN1COPY with wrong previous OBID and there is the message [...]
16122 455 15_Re: Tables OBID11_Ivan Losada22_ivan.losadajuan@BDE.ES31_Thu, 12 Oct 2006 16:34:10 +0200677_us-ascii
... and find PGSOBD in DSN1PRNT output. This is the hexadecimal value of table OBID.
________________________________
De: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Horn Stefan Enviado el: jueves, 12 de octubre de 2006 15:09 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: Re: [DB2-L] Tables OBID
hi,
use dsn1prnt using the icopy as input
stef
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galeos Antonis Sent: 12 October 2006 12:53 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Tables OBID [...]
16578 38 61_Change from SRDF/S to SRDF/A for Continuity of Business (COB)21_Deepak Gujaba Gaikwad24_deepakggaikwad@YAHOO.COM31_Thu, 12 Oct 2006 07:43:21 -0700573_iso-8859-1 Hi All,
We currently have Mainframe COB site within the same city about 50KM away. We have been using synchronous SRDF between the primary and COB site. Considering the recent happenings which could be bring down the city to standstill, we are thinking of relocationg our COB to another city around 1000KM far. Obviously we cannot continue the SRDF/S and looking into the feasibility of exploiting asynchronous SRDF. As a DB2 system programmer/admin who is responsible for the availability of db2 systems, what should be the points to be considered? [...]
16617 82 65_Re: Change from SRDF/S to SRDF/A for Continuity of Business (COB)13_Carol Broyles21_clbroyles55@YAHOO.COM31_Thu, 12 Oct 2006 08:01:02 -0700628_iso-8859-1 We have been using it for three years, with no issues. We have about 30 seconds or less of data loss. It takes us about 1/2 hour to clean up the LPL and GRECPs and start the application running. Carol ----- Original Message ---- From: Deepak Gujaba Gaikwad To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thursday, October 12, 2006 10:43:21 AM Subject: [DB2-L] Change from SRDF/S to SRDF/A for Continuity of Business (COB) Hi All, We currently have Mainframe COB site within the same city about 50KM away. We have been using synchronous SRDF between the primary and COB site. Considering the recent [...]
16700 15 24_DB2 distributed packages12_George Palko16_gpalko@OPERS.ORG31_Thu, 12 Oct 2006 10:21:22 -0500660_- Hello List, Would anyone be able to direct me to a document that describes the various usages and naming conventions of the distributed packages such as SYSSN300.
Thank you, George
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
16716 169 68_Capture and Consolidate Dynamic SQL from the Distributed Environment12_Steve DeGiso16_sdegiso@TACT.COM31_Thu, 12 Oct 2006 11:49:57 -0400546_iso-8859-1 Are your distributed DB2 applications getting larger and larger? Do you really know their impact, and cost to your Enterprise?
Join us online for our Webinar presentation - How EZ-DB2 Captures and Consolidates Dynamic SQL from the Distributed Environment, and helps you dramatically improve your Mainframe DB2 Performance.
Sign up now for a webinar session! http://www.tact.com/software/docs/emailerForm06.html [...]
16886 46 63_Transferring data from MVS DB2 v7 to DB2 8.2 express-c on Linux11_Gary Cowell21_gary.cowell@GMAIL.COM31_Thu, 12 Oct 2006 16:51:29 +0100372_ISO-8859-1 Hello
I'm new to db2 somewhat so please bear with me.
We have some data in about 1000 tables on MVS DB2 v7.
I need to know some ideas of the best way to get this into DB2 8.2 EXPRESS-C on Linux.
Would that be some kind of import/export, I don't think we can do insert into (unix) select * from (mvs) with the express-C product. [...]
16933 48 15_Re: Tables OBID0_22_DB2information@AOL.COM29_Thu, 12 Oct 2006 12:22:40 EDT644_US-ASCII Galeos Antonis This same question came up several days ago, to automate this process view: http://www.recoveryknowledge.com/
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
16982 147 15_Re: Tables OBID9_Ford Wong14_fordie@SHAW.CA31_Thu, 12 Oct 2006 10:37:24 -0600542_us-ascii As Stefan mentions, the only way to extract OBIDs is to use DSN1PRNT and your image copy for input. There are vendor products which will do this for you however.
Here is a sample of using DSN1PRNT:
//* 1. USE THE DSN1PRNT UTILITY TO FIND THE DBID, PSID AND OBID FOR A //* TABLESPACE BY READING AN IMAGE COPY. //* //* FROM THE OUTPUT: //* FROM HEADER PAGE, USE HPGOBID TO DETERMINE DBID AND PSID //* DBID IS THE FIRST TWO BYTES OF HPGOBID //* PSID IS THE LAST TWO BYTES OF HPGOBID //* OBID OF TABLE CAN BE OBTAINED [...]
17130 88 35_Re: [z/OS] No Statistics Records...35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 12 Oct 2006 13:58:33 -0400335_iso-8859-9 What is your Statistics time interval? Should records have been cut in the SMF record time frame you have? Did the SMF dump specify that you wanted 100 records? Have you checked the SMF definitions to see if they allow type 100 records to be cut? Have you done a -dis trace(*) to see that the Stats trace is really on? [...]
17219 40 22_Re: OT - IDUG Homepage10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Thu, 12 Oct 2006 13:54:12 -0400441_iso-8859-1 You have a secure email message waiting for you from Mark Labby at AES/PHEAA with the subject: Re: OT - IDUG Homepage.
How to Retrieve Your Message
To retrieve your message from Mark Labby with the subject: Re: OT - IDUG Homepage, go to: https://securemail.aessuccess.org/messenger/msg?x=d-5137503-JkL6nWJEmTKakSAH
This message will be available until 12/11/2006.
Why You Are Receiving this Email [...]
17260 157 22_Re: OT - IDUG Homepage30_Mark Labby-AES-PHEAA UG Leader21_mlabby@AESSUCCESS.ORG31_Thu, 12 Oct 2006 14:32:47 -0400450_us-ascii Rodney,
I am on the web team, and have been on the site a few times this morning (and most days) and have seen no performance problems. I suspect that you may have firewall issues. If you continue to have access problems, please drop a note to webteam@idug.org so the tech guys can check on their end. The web team is always looking for feedback on the site, so please drop us a note with any comments, problems, or suggestions. [...]
17418 144 28_Re: DB2 distributed packages17_David Stritzinger27_David.Stritzinger@KRAFT.COM31_Thu, 12 Oct 2006 13:47:31 -0500736_- George,
Here are a few places that may help:
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606chun/
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=package+nam ing+convention&uid=swg21223189&loc=en_US&cs=utf-8&lang=en
I know that I had found a better site in the past, but that was 2 laptops and 3 email addresses ago and must not have copied my Explore favorites over to the new laptop.
Dave S.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of George Palko Sent: Thursday, October 12, 2006 11:21 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 distributed packages [...]
17563 35 41_Common practice working db2 with SMS ????13_javier sotela19_jsotela@HOTMAIL.COM31_Thu, 12 Oct 2006 15:00:31 -0400383_- Hi Everyone:
I sent a previous question about db2 and SMS, well I need to find the common practices in db2 with you the experts. We are just starting with our mainframe db2 and we need to learn a lot. I notice that there is a lot of people in this list and I need to find what its the people doing with SMS. I want to know wich of the next optios its the pepole using: [...]
17599 149 43_z/OS v7 - re-use of space from deleted rows12_Kirk Hampton28_khampto1@CAPGEMINIENERGY.COM31_Thu, 12 Oct 2006 14:55:35 -0500418_us-ascii I admit up front that I am attempting to bypass the RTFM step here,
but in the current architecture (ok, v7 is still barely current) under
what conditions will DB2 re-use space on pages vacated by deleted
rows ?
We believe this used to be never for simple tablespaces, but we don't
know if that has changed. The particular table we are interested in is [...]
17749 35 40_DB2 z/OS - Not-in-use Datasets Requested4_Fred18_fredgarx@YAHOO.COM31_Thu, 12 Oct 2006 12:58:44 -0700617_iso-8859-1 All,
In Omegamon for DB2, the classic interface, screen R.K has counts for:
"Not-in-use Datasets Requested"
One of our prod subsystems is averaging about 1500/second for this count. Does anyone know what kind of overhead that is costing? I plan to increase DSMAX to something more reasonable, but I'm curious if I'll be able to measure the difference. Our current DSMAX is 6500 and we have about 8500 datasets in this subsystem. If I remember right DB2 begins the process of "maybe" closing datasets when 90 percent of DSMAX is reached. If we really do use all 8500 datasets does [...]
17785 96 45_Re: Common practice working db2 with SMS ????12_Kirk Hampton28_khampto1@CAPGEMINIENERGY.COM31_Thu, 12 Oct 2006 15:22:30 -0500466_us-ascii Hello Javier,
We have used SMS in conjunction with DB2 for many years now.
It works very well for us.
1) no, never done that.
2) no, have not used those yet.
3) Yes, our ACS routines basically route any dataset which
has a second node of DSNDBC into one of two SMS pools based
on the size of the primary allocation, small datasets in one, [...]
17882 38 22_DB2 DBA position in DC27_DB2 Database Solutions Port26_db2dba_certified@YAHOO.COM31_Thu, 12 Oct 2006 14:06:42 -0700464_iso-8859-1 Hello there, DOJ (Washington DC) is currently looking for a DB2 DBA (zos). This position needs US citizenship to file security clearance. Interested candidates can contact contact@Technovilleusa.com with a word copy of resume.
Thanks
VG 703-430-7393
--------------------------------- Get your email and more, right on the new Yahoo.com
---------------------------------------------------------------------------------
17921 19 34_Re: z/OS DB2 V8 CM and DB2 Connect14_Paul Peplinski24_paul.peplinski@WPSIC.COM31_Thu, 12 Oct 2006 16:08:22 -0500351_- Bob,
Thank you. Your info is timely because we have not upgraded gateway software yet and V8 NFM is right around the corner.
I am being told I should upgrade to V8.2.4 (Fixpack 11) when available, which made me think FP10 + was the only option. You're saying you already have FP11 and FP13 inhouse and FP13 may be needed for NFM. [...]
17941 153 34_Re: z/OS DB2 V8 CM and DB2 Connect13_Robert Tilkes22_TILKESR@NATIONWIDE.COM31_Thu, 12 Oct 2006 16:53:21 -0500315_US-ASCII I am being told by our DB2 Connect support personnel that if you are not on FP12 there is some potential issues with the "executeBatch" command in Java with DB2 v.8 in NFM and IBM is recommending you be at least at FP12 to avoid any issues. Since we were at FP11 we decided to move forward with FP13. [...]
18095 78 67_Re: Transferring data from MVS DB2 v7 to DB2 8.2 express-c on Linux15_nguyen duc tuan17_ndt.db2@GMAIL.COM31_Thu, 12 Oct 2006 23:56:55 +0200592_ISO-8859-1 there is a redbook on how to move data between db2 luw and z/os . "Moving the data across db2 family"
your solution is here http://www.redbooks.ibm.com/abstracts/sg246905.html?Open
Regards
On 10/12/06, Gary Cowell wrote: > > Hello > > I'm new to db2 somewhat so please bear with me. > > We have some data in about 1000 tables on MVS DB2 v7. > > I need to know some ideas of the best way to get this into DB2 8.2EXPRESS-C on Linux. > > Would that be some kind of import/export, I don't think we can do insert > into [...]
18174 192 17_Generate_unique()19_Wasserman, Hirschel27_hirschel.wasserman@ICBC.COM31_Thu, 12 Oct 2006 15:40:04 -0700435_us-ascii Per the manual, to do an insert of row into a table with a unique meaningless (the non triggered way) ...
CREATE TABLE EMP_UPDATE UNIQUE_ID CHAR(13)FOR BIT DATA, EMPNO CHAR(6), TEXT VARCHAR(1000));
And then in the program EXEC SQL INSERT INTO EMP_UPDATE VALUES (GENERATE_UNIQUE(),'000020','Update entry 1...');
EXEC SQL INSERT INTO EMP_UPDATE VALUES (GENERATE_UNIQUE(),'000050','Update entry 2...'); [...]
18367 15 35_Re: [z/OS] No Statistics Records...17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Thu, 12 Oct 2006 17:34:11 -0500713_- Check the IFCIDS for those 102's. More likely it was 172/15x(x being 0 or 1). (Timeout is ifcid 150 or 151 i dont remember off the top). Deadlock / timeout records cut for the stat trace will have a db2 102 (or smf type 102). Regards Venkat
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
18383 309 41_Z/OS DB2 V8 getting -450 from a cobol udf23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 12 Oct 2006 16:17:12 -0700486_us-ascii Well I'm missing something somewhere and my head is getting sore.
I've created a cobol udf that inputs a varchar(17) then outputs varchar(17). I used the linkage section example in chap 15 of the Application programming and SQL guide. When I use dsntep2 to execute the UDF I get a -450. AIso, I have DISPLAYs in the cobol program to show the contents of the linkage fields and it looks like the call is not passing the column contents. Does anyone have any ideas?? [...]
18693 127 42_[MVS] data sharing group buffer pool sizes18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM31_Thu, 12 Oct 2006 20:12:05 -0400557_us-ascii We are planning to enable data sharing and estimating the sizes for group buffer pools seems to be more of an art than science. I've used CFSizer on the internet but recently heard that it overestimates the required storage. Does anyone have any sizes they can share? For example, we are planning for 2-way data sharing and one of the 4K buffer pools is currently 100,000 pages in what will be the originating member. We plan for the second member to use the same local buffer pool sizes. When I input 200000 in CFSizer, with a page size of 4 [...]
18821 58 45_Full system PIT recover. DB2 V7 in OS/390 21013_Horacio Villa17_hvilla@AR.IBM.COM31_Thu, 12 Oct 2006 21:33:42 -0300505_US-ASCII Hi list,
We are planning for a big application software upgrade. It includes many changes to the DB2 schema. There's a requirement to go back to square 0 in case of problems. Full COPY REFERENCE doesn't fit in the window. Is FLASH COPY an option in this case? I see it's for rolling forward, but after all those changes to the tablespaces, I'm not sure I can go back. How do I recover the ICF catalogs? And COPY CONCURRENT? There will be many DROP/CREATE TS and we've never tried it. [...]
18880 14 50_Re: Low DSNTIAUL and SPUFI Execution BP0 Hit Ratio13_Douglas Hecht22_dhecht@DSS.STATE.LA.US31_Thu, 12 Oct 2006 20:16:47 -0500682_- It seems the only way all that IO could be occuring against sysdbase is if the DSNTIAUL statement is being prepared for each table row retrieved. There are 1/2 million rows. This seems unlikely.
Thanks.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
18895 80 45_Re: Z/OS DB2 V8 getting -450 from a cobol udf14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 13 Oct 2006 13:54:11 +1000611_US-ASCII And what's missing here is the LINKAGE SECTION and PROCEDURE DIVISION statements from the COBOL program.
But just looking at the stuff below, it "appears" that the procedure division has the parameters out of sequence.
James Campbell
On 12 Oct 2006 at 16:17, BOLEY Maurice C * Cliff wrote:
> > Well I'm missing something somewhere and my head is getting sore. > I've created a cobol udf that inputs a varchar(17) then outputs varchar(17). > I used the linkage section example in chap 15 of the Application programming and SQL guide. > When I use dsntep2 to execute the [...]
18976 40 45_Re: Common practice working db2 with SMS ????13_Chris Andrews20_andrews_c@UK.IBM.COM31_Fri, 13 Oct 2006 01:40:04 -0500567_- 1. No 2. Yes 3. Yes. 4. ACS can pick up other information such as disk, so I have seen dummy VOLUMES names put in the STOGROUP and this used to place the DB2 objects. Avoids altering the ACS routine for every new dataset name.
The key point is to have a simple set of ACS rotuines for the majority (typically based on size or dataset naming conventions) then only specifically add in exceptions in ACS routines. Talking to storage managers they dislike altering the ACS routines (mistakes and its sysplex wide) and the more complex they become the more [...]
19017 188 44_Re: DB2 z/OS - Not-in-use Datasets Requested13_Michael Ebert18_mebert@AMADEUS.COM31_Fri, 13 Oct 2006 09:31:54 +0200305_US-ASCII I think DSMAX=6500 is more than enough, especially if you've got only 8500 datasets. It is unlikely that your file working set contains more than a few hundred datasets. Having a high DSMAX may cause problems for the storage people, e.g. when trying to DEFRAG disks or move datasets around. [...]
19206 173 49_Re: Full system PIT recover. DB2 V7 in OS/390 21013_Michael Ebert18_mebert@AMADEUS.COM31_Fri, 13 Oct 2006 09:40:39 +0200577_US-ASCII What exactly is "the window"? How big is your DB2 - size, # of datasets? Some options:
1) Do a COPY SHRLEVEL CHANGE of everything. Then make sure the system is quiet, take a QUIESCE of the Cat/Dir. If you want to go back later, to a PIT recovery of everything (starting with Cat/Dir) to that RBA/LRSN (remember to copy/recover indexes or rebuild them). You don't have to recover tables that have not been changed. Preferably put them into RO mode before the QUIESCE. If your assumption was wrong, DB2 will tell you sooner or later, then simply RECOVER the [...]
19380 163 49_Re: Full system PIT recover. DB2 V7 in OS/390 21014_Andy Lankester26_alankester@CDBSOFTWARE.COM31_Fri, 13 Oct 2006 03:34:59 -0500456_windows-1250 FLASHCOPY is the easiest and probably fastest as long as you copy EVERYTHING: data, cat/dir, logs, BSDSs and ICF catalog. Then pack dump the mirror volumes for added safety.
Andy Lankester
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Horacio Villa Sent: Friday, October 13, 2006 1:34 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Full system PIT recover. DB2 V7 in OS/390 210 [...]
19544 430 53_Re: IBM Information on Demand Conference Exhibit note13_Bell, Raymond22_raymond.bell@LANDG.COM31_Fri, 13 Oct 2006 09:32:32 +0100326_iso-8859-1 Hey Robert,
No big deal, my friend. Just thought I'd take the opportunity to stick the knife in - although not too far. After all, it's not really that important not to include a sub-category in the Subject: field. I'm sure we all still managed to work out that it was a vendor announcement without it. [...]
19975 176 64_Re: Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for t he day13_Bell, Raymond22_raymond.bell@LANDG.COM31_Fri, 13 Oct 2006 09:52:53 +0100409_iso-8859-1 3... 2... oh, hang on. Didn't give you enough time. Guess I'll have to abort the launch.
You and others may be interested to know we applied the PTF for PK17422 (APAR UK18142) and although it corrected the 'set current sqlid='normal-7-bytes-plus-a-two-byte-value'' problem that QMF and SPUFI showed our ISV software still doesn't work. We'll carry on our discussions with them on this. [...]
20152 54 49_Re: Full system PIT recover. DB2 V7 in OS/390 21010_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 13 Oct 2006 10:56:43 +0200798_US-ASCII Just an observation, just to wear iron pants..or better kevlar pants
Be sure that you're current with os/390 PTFs for Flashcopy and the HW is supported/tested. Just to justify yourself if something will go wrong using Flashcopy.
Disasters happen (well actually Forrest Gump said another thing I cannot write here).
HTH
Max Scarpa
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest [...]
20207 106 45_Re: Common practice working db2 with SMS ????11_Ivan Losada22_ivan.losadajuan@BDE.ES31_Fri, 13 Oct 2006 11:53:07 +0200520_us-ascii
Hi:
I've been working in various DB2&SMS installations, and common practice is:
1. No. 2. Never use. 3. Use ACS routines to assign DB2 files to SMS storage groups. 4. DB2 storage groups defined with vol('*')
-----Mensaje original----- De: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de javier sotela Enviado el: jueves, 12 de octubre de 2006 21:01 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: [DB2-L] Common practice working db2 with SMS ???? [...]
20314 147 45_Re: Common practice working db2 with SMS ????0_19_mike.holmans@BT.COM31_Fri, 13 Oct 2006 11:41:05 +0100403_iso-8859-1 1 No 2 No 3/4 We agree what SMS storage groups we need with our storage management people, which usually means one for tablespaces and one for indexes, and assign a dummy volid to them, eg #TABLE and #INDEX. We define the DB2 stogroups as having VOLUMES(#TABLE) or VOLUMES(#INDEX), and then the ACS routines are coded to pick up these volsers and do whatever it is that ACS routines do. [...]
20462 79 45_Re: Common practice working db2 with SMS ????13_Bell, Raymond22_raymond.bell@LANDG.COM31_Fri, 13 Oct 2006 12:13:13 +0100364_iso-8859-1 We have a simple method for resolving DASD-related issues. We all head off to the pub, get bladdered, then pick one warrior each to fight for each team's honour. The DBA/Storage Administrator left standing gets to decide the rules. Once their teeth have been put back in. My knuckles still hurt from the last time I managed to get 10GB out of 'em. [...]
20542 115 47_Re: z/OS v7 - re-use of space from deleted rows13_Carol Broyles21_clbroyles55@YAHOO.COM31_Fri, 13 Oct 2006 04:27:12 -0700643_iso-8859-7 Kirk, You are correct in thinking that the partitioned space will act like a simple (not segmented) space. We have to regularly reorg our volatile, partitioned tablespaces to get the space back. I heard that V9 addresses this issue. Carol ----- Original Message ---- From: Kirk Hampton To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thursday, October 12, 2006 3:55:35 PM Subject: [DB2-L] z/OS v7 - re-use of space from deleted rows I admit up front that I am attempting to bypass the RTFM step here, but in the current architecture (ok, v7 is still barely current) under what conditions will DB2 re-use space [...]
20658 22 44_Active DDF threads on CPU constrained system12_Bob Jeandron21_bobjeandron@YAHOO.COM31_Fri, 13 Oct 2006 07:30:35 -0500360_- We have a heavily overloaded system....CPU constrained. We have been adjusting the number of Active DDF threads, MAXDBAT, in an attempt to limit the processes that can run. CMTSTAT=INACTIVE.
My ?: is it better to have a limited number of active threads and have them q, or better to have a high number and avoid the overhead of having any q'ing? [...]
20681 80 48_Re: Active DDF threads on CPU constrained system13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 13 Oct 2006 13:44:52 +0100381_US-ASCII Generally queuing at the door is deemed better than queuing once inside. But I've seen no specific advice for DDF on that.
What is probably more important is to work on the WLM aspects of this - to control the workload.
Martin
Martin Packer Performance Consultant IBM United Kingdom Ltd +44-20-8832-5167 +44-7802-245-584 martin_packer@uk.ibm.com [...]
20762 165 31_[z/OS] V8 NFM - REPAIR VERSIONS10_Bruce, Mae19_Mae.Bruce@OA.MO.GOV31_Fri, 13 Oct 2006 08:03:34 -0500433_us-ascii We have copied a tablespace from one subsystem to another using DSN1COPY. Our source tablespace has a CURRENT_VERSION = 0 and OLDEST_VERSION = 0. The target has CURRENT_VERSION = 1 and OLDEST_VERSION = 1. We ran the REPAIR VERSIONS on the target and assumed that the CURRENT_VERSION would end up being 1 and the OLDEST_VERSION would be set to 0. But CURRENT_VERSION was set to 0 also. Should it not have been set to 1? [...]
20928 450 35_Re: [z/OS] V8 NFM - REPAIR VERSIONS16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Fri, 13 Oct 2006 09:31:41 -0400420_us-ascii Hello Bruce,
Seems like you're starting to have some fun with OSE (Online Schema Evolution).
The reason why your target object has CURRENT_VERSION=1 must be because someone did an:
ALTER TABLE x.y ALTER COLUMN colname SET DATA TYPE "new attribute" (for example extending a CHAR column or changing a SMALLINT to INTEGER or DECIMAL etc.). [...]
21379 116 35_Re: [z/OS] No Statistics Records...22_Cuneyt Goksu (Usa.net)19_cuneytgoksu@USA.NET31_Fri, 13 Oct 2006 16:32:59 +0300560_iso-8859-9 Thank you for all helping online and offline.
The problem was in SMFPARM member. DB2 record types were supressed. I changed the SMFPARM and it worked!
EXITS(IEFU83,IEFU84,IEFU85,IEFACTRT, IEFUSI,IEFUJI,IEFU29),NOINTERVAL,NODETAIL) SUBSYS(STC,TYPE(70,89,100), EXITS(IEFU29,IEFU83,IEFU84,IEFU85,IEFUJP,IEFUSO))
Regards, Cuneyt
-----Original Message----- From: Joel Goldstein - Responsive Systems [mailto:joel@RESPONSIVESYSTEMS.COM] Sent: Thursday, October 12, 2006 8:59 PM Subject: Re: [z/OS] No Statistics Records... [...]
21496 276 35_Re: [z/OS] V8 NFM - REPAIR VERSIONS10_Bruce, Mae19_Mae.Bruce@OA.MO.GOV31_Fri, 13 Oct 2006 08:46:37 -0500353_us-ascii Fun? I don't like your idea of fun.......
How would a reorg on the source object help? It is currently version 0. The system pages in the copied dataset should all reflect version 0, correct? And I don't think I can reorg the target now since my versions are out of sync. I would think I would get the same inconsistent data abend. [...]
21773 379 35_Re: [z/OS] V8 NFM - REPAIR VERSIONS16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Fri, 13 Oct 2006 10:22:59 -0400520_us-ascii Oooops - sorry Mae, I mixed up your source and target, so let me start over:
Source has 0 for both current and oldest version.
Target had 1 for both current and oldest - which tells us a REORG was executed after the column alteration on the target side.
REPAIR VERSION should use the SOURCE versions and update the TARGET catalog with the same versions, so I guess the REPAIR is doing what it's supposed to do (setting both current and oldest to ZERO). [...]
22153 384 28_Re: DB2 distributed packages13_Palko, George16_gpalko@OPERS.ORG31_Fri, 13 Oct 2006 10:23:27 -0400368_iso-8859-1 Thanks Dave!
This information is exactly what we need.
What we are attempting to do is restrict the use of distributed packages that are bound with an isolation level of RR or RS. We are having issues were developers are not specifying an isolation level within our distributed applications, and a default isolation of RS is being taken. [...]
22538 124 64_Re: How to relate DB2 storage groups to SMS storage groups ?????14_Wayne Driscoll25_wdriscoll@JMESOFTWARE.COM31_Fri, 13 Oct 2006 10:26:52 -0400444_us-ascii Speaking as someone who has been involved in DASD management, as well as DB2, I wouldn't use the SMSDCFL and SMSDCIX parms, instead I would leave dataset placement in the hands of the storage people, by using the SMS ACS routines to assign storage group via the dataset name (mainly using the HLQ and the 3rd Qualifier (the database name). Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. [...]
22663 130 70_[AD] Buffer Pool Tool V8.3 with GBP Simulation - at the IOD Conference35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 13 Oct 2006 10:35:20 -0400366_iso-8859-1 Please visit us at booth E606 to learn about the new release of Buffer Pool Tool, the worldwide industry standard for tuning DB2 UDB for z/OS buffer pools. We have extended our leading technology, and the new version can predict the effect of changes to your GBP's.
The full announcement letter is on our website, in the announcement section. [...]
22794 56 48_Re: Active DDF threads on CPU constrained system16_Jeffrey D. Jerry27_Jeff.D.Jerry@WELLSFARGO.COM31_Fri, 13 Oct 2006 09:55:02 -0500593_us-ascii We have been working on this issue for a while now as well. We had a high number (500) set for MAXDBAT and it was causing virtual storage constraint problems when our workload approached this number. In our environment we have a 14 way data sharing environment and the DDF workload was focused on one member. Recently we have been working on using WLM and DB2 Connect's connection pooling mechanism to balance the DDF traffic across the various members. It has been helping and we have reduced the MAXDBAT parameter to protect against our subsystems from crashing due to running [...]
22851 244 35_Re: [z/OS] V8 NFM - REPAIR VERSIONS10_Bruce, Mae19_Mae.Bruce@OA.MO.GOV31_Fri, 13 Oct 2006 10:01:40 -0500453_us-ascii Yes, we are using an image copy as the input.
From the utilities manual, it gives the following formulas for updating the CURRENT_VERSION and OLDEST_VERSION. CURRENT_VERSION = MAX(target.CURRENT_VERSION,source.CURRENT_VERSION) OLDEST_VERSION = MIN(target.OLDEST_VERSION,source.OLDEST_VERSION) That is why I was thinking that the CURRENT_VERSION should have remained at 1. The VERSION on SYSTABLES remained at 1 (which makes sense). [...]
23096 147 45_Re: Common practice working db2 with SMS ????11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Fri, 13 Oct 2006 10:08:08 -0500559_us-ascii I just thought I'd chime in with a V8 consideration. If you plan to use the new utility -- Backup and Restore System -- then you should understand that these utilities invoke Flashcopy at the volume level. Flashcopy uses hardware functions in the shark to quickly create copies of volumes. I keep saying volume over and over again because it is an important consideration when writing any ACS routines. You probably want to have all of your data sets for a DB2 on a localized set of volumes and have a copypool with a similar number of volumes. [...]
23244 339 35_Re: [z/OS] V8 NFM - REPAIR VERSIONS16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Fri, 13 Oct 2006 11:48:37 -0400311_us-ascii I must admit I am a little confused, so I am just guessing here.
The image copy can be done with or without SYSTEMPAGES - so wonder how the REPAIR will handle this when an image copy is used taken without system pages - and the target dataset had system pages prior to the DSN1COPY ....... [...]
23584 15 34_Re: z/OS DB2 V8 CM and DB2 Connect14_Paul Peplinski24_paul.peplinski@WPSIC.COM31_Fri, 13 Oct 2006 10:59:27 -0500589_- Bob,
Thank you. After giving IBM the advice you gave me they are now recommending the same thing.
Paul
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
23600 75 21_Re: Generate_unique()11_Suresh Sane21_data_arch@HOTMAIL.COM31_Fri, 13 Oct 2006 11:38:35 -0500765_- Hirschel,
Can you not use the insert within select feature? Goes something like...
select... final table (insert into...)
Thanks, Suresh
>From: "Wasserman, Hirschel" >Reply-To: DB2 Database Discussion list at IDUG >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: [DB2-L] Generate_unique() >Date: Thu, 12 Oct 2006 15:40:04 -0700 > >Per the manual, to do an insert of row into a table with a unique >meaningless (the non triggered way) ... > >CREATE TABLE EMP_UPDATE > UNIQUE_ID CHAR(13)FOR BIT DATA, > EMPNO CHAR(6), > TEXT VARCHAR(1000)); > >And then in the program >EXEC SQL INSERT INTO EMP_UPDATE >VALUES (GENERATE_UNIQUE(),'000020','Update entry 1...'); > >EXEC SQL INSERT [...]
23676 67 38_Indiana DB2 Users Group Meeting Nov 1412_Matthew Rhea24_matthew_rhea@CONSECO.COM31_Fri, 13 Oct 2006 12:38:28 -0500398_ISO-8859-1 The Indiana DB2 Users Group will have a meeting on Tuesday, November 14 at the Conseco Conference Center in Carmel, IN.
IBM will provide speakers on DB2 V8 for z/OS features and on DB2 9 for LUW.
Here's a draft of the agenda. More details will follow when plans are finalized. Please be sure to pass this information on to others who may not be IDUG or InDUG members. [...]
23744 92 39_Any detailed experience with DSNZSCH ??11_Hugh Lapham26_hugh.lapham@RCMP-GRC.GC.CA31_Fri, 13 Oct 2006 14:02:13 -0400558_US-ASCII Although I've used this many times before casually, I'm now trying to set it up for more regular and intensive use and am running into one tiny problem. The program turns IFCIDS 316/7/8 on at the beginning and off again at the end but as a result it seems that the accumulated statistics are only for the duration of the DSNZSCH execution. I'm thinking that what I probably really want is to turn IFCID 318 on earlier, so that there will be some meaningful accumulation by the time I run DSNZSCH. My first inclination is to simply omit the 318 [...]
23837 59 41_Z/OS DB2 V8 getting -450 from a cobol udf23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 13 Oct 2006 11:14:12 -0700573_us-ascii Never mind. I found the problem, I had the wrong compile parms. arrg.
cliff:-)
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
23897 98 34_DB2 Version 8 upgrade and COBOL II10_David Kelm19_kelm.david@MBCO.COM31_Fri, 13 Oct 2006 14:17:57 -0500322_us-ascii
We are in the process of planning our upgrade from z/os DB2 Version 7 to version 8 and our development center has heard that our COBOL II programs will need to be recompiled for the version 8 upgrade.
I can understand rebinding but I have never known a release upgrade to require a recompile. [...]
23996 66 38_Re: DB2 Version 8 upgrade and COBOL II9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 13 Oct 2006 15:05:21 -0500302_US-ASCII They read it the wrong way. The DB2 precompiler has dropped support for source type of COB2. You do not need to redo the precompile or compile. The existing programs will continue running and work on DB2. When you do need to change the COBOL II modules, you can't use the V8 precompiler. [...]
24063 296 49_Re: Full system PIT recover. DB2 V7 in OS/390 21013_Horacio Villa17_hvilla@AR.IBM.COM31_Fri, 13 Oct 2006 18:54:03 -0300372_US-ASCII Michael,
Thanks for your answer.
"the window" is exactly the time we have to complete all the process.
The DB2-size is some 15.000 tablespace partitions + its indexes.
Point 1) in your answer is exactly what we are trying to avoid.
After the upgrade, there will be a test of the system, updating who knows how many tables. [...]
24360 210 49_Re: Full system PIT recover. DB2 V7 in OS/390 21013_Horacio Villa17_hvilla@AR.IBM.COM31_Fri, 13 Oct 2006 18:56:33 -0300521_US-ASCII Hi Andy,
thanks for the answer. What if it's not possible to recover the ICF catalogs (there's more than one involved)?
Cheers,
Horacio Villa
Andy Lankester Sent by: DB2 Data Base Discussion List 13/10/2006 05:34 Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: [DB2-L] Full system PIT recover. DB2 V7 in OS/390 210 [...]
24571 146 49_Re: Full system PIT recover. DB2 V7 in OS/390 21013_Horacio Villa17_hvilla@AR.IBM.COM31_Fri, 13 Oct 2006 18:57:57 -0300510_US-ASCII Ciao Max,
klevar pants wouldn't be enough if we cannot recover, in case that's the decision....
Thanks for the advice.
Horacio Villa
Max Scarpa Sent by: DB2 Data Base Discussion List 13/10/2006 05:56 Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: [DB2-L] Full system PIT recover. DB2 V7 in OS/390 210 [...]
24718 19 46_Re: [MVS] data sharing group buffer pool sizes17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Fri, 13 Oct 2006 18:11:25 -0500533_- May be Local B.Pool times the number of members * .25 . This equation originated from Dallas systems center. You can use lesser of size as above and the size estimated by CF estimator. With a 400Mb local bufferpool, 200 - 256Mb group bufferpool is really not unreasonable. If your extent of datasharing turns out low or high you can adjust it later. Perhaps you can choose 60 -70% of this as structure initsize while max size is set 200Mb along with allowautoalt. You can change the structure size anytime dynamically. Venkat [...]
24738 262 64_Re: Antwort: Re: [DB2-L] [z/OS] Exciting bit of SQL for t he day14_Thomas, Steven21_Steven_Thomas@BMC.COM31_Sat, 14 Oct 2006 15:30:49 +0100592_iso-8859-1 I believe any character which transforms into a multi-byte Unicode character would have the same problem. That would explain all those we've discussed so far.
Out of interest, if you're still on V7 and have any Creator IDs with one of these characters in it, and if the ID would extend to over 8 bytes when converted to Unicode, then you'll also get a similar problem even in Compat Mode. For example, 'A123456£' is 9 bytes in Unicode, so when it's parsed the Optimizer objects. What's puzzling is you get a message saying Userid 'A123456£' exceeds maximum length of 8 [...]
25001 152 49_Re: Full system PIT recover. DB2 V7 in OS/390 21014_Andy Lankester26_alankester@CDBSOFTWARE.COM31_Sat, 14 Oct 2006 12:27:42 -0500410_windows-1250 Horacio,
You may be OK using a later version of the ICF catalog unless spaces have been dropped/reorged/moved since the PiT point. There may also be some issues with extents. Both of these can be cured by doing a normal 'tocurrent' recover for the affected objects after the system PiT recovery. Equally, objects created AFTER the PiT will have ICF cat entries but no DB2 cat entries. [...]
25154 261 43_Re: Any detailed experience with DSNZSCH ??3_Les21_db2dba@BTINTERNET.COM31_Sat, 14 Oct 2006 20:29:54 +0100391_windows-1250 Hi Hugh I did a lot of work with the program about two years ago directly with the original developer.
From memory we started 318(trigger for 316/317 pairs) everytime DB2 was restarted (via an auto job).
Then when I ran the collection job, or any IFI reader job (SAP has their own, one of the ST transactions I think) everything was well and truly populated. [...]
25416 62 42_Re: Dynamic SQL Isolation Level Monitoring11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 14 Oct 2006 15:20:30 -0500362_- George,
We just recently switched to Omegamon from TMON and noticed that it only captured some, not all of the Dynamic SQL Statements.
I opened a ETR and was told that it only stores the SQL text when it's not already in Dynamic Statement Cache. To be fair, the answer was much more detailed than that but I think this recaps it accurately. [...]
25479 186 26_COALESCE, IFNULL, CASE ...11_Gerard News24_gerard.le.roy@WANADOO.FR31_Sat, 14 Oct 2006 22:40:48 +0200463_us-ascii Hello the List,
Having the table name passed as a parameter, I need to generate in REXX a SELECT to be used by DSNTIAUL
in such a way that the resulting file SYSREC00 contains :
* the actual value in internal format (eg 2 bytes for a SMALLINT column, x bytes for a CHAR or VARCHAR(x), 10 bytes for a DATE column, 1+p/2 bytes for a DECIMAL, .) if the value is NOT NULL * a string of HIGH-VALUE (same length) if the value is NULL [...]
25666 113 36_Re: Monitoring JDBC on the mainframe11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 14 Oct 2006 16:10:58 -0500305_- I attahced me previous post to the wrong thread. It should've gone to this one. The 2 APARS are OA17619 & OA17121. Rich mentioned OA17619, the other is still open:
We just recently switched to Omegamon from TMON and noticed that it only captured some, not all of the Dynamic SQL Statements. [...]
25780 74 65_Re: Change from SRDF/S to SRDF/A for Continuity of Business (COB)11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 14 Oct 2006 16:24:45 -0500442_ISO-8859-1 We just switched to it this year and our experience is the same as Carol's.
So far so good.
Mike Kalena mkalena@bear.com
On Thu, 12 Oct 2006 08:01:02 -0700, Carol Broyles wrote:
>We have been using it for three years, with no issues. We have about 30 seconds or less of data loss. It takes us about 1/2 hour to clean up the LPL and GRECPs and start the application running. [...]
25855 94 47_Re: z/OS v7 - re-use of space from deleted rows14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 15 Oct 2006 12:02:03 +1000516_ISO-8859-1 My understanding from the course I did back when V2.? was the latest and greatest is that DB2 uses the Cluster index to find the page used by the next (prior?) key. DB2 then 1) looks into the space bit map page to see if that page has enough room to fit the page; if so, in it goes 2) if the page doesn't have room, then DB2 looks at the surounding ?? (seq prefetch size?) pages to see if it will fit somewhere nearby; if so in it goes. (and SYSINDEXPART.NEAROFFPOSF gets a kick along) 3) if no near [...]
25950 72 30_Re: COALESCE, IFNULL, CASE ...14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 15 Oct 2006 12:02:04 +1000350_ISO-8859-1 "internal format"? Internal to what? For example a smallint with value +1 has DB2 internal format x'8001'. Is this what you want? or do you want x'0001'. DB2 internal varchar(x) has 2 bytes of length, then bytes of data. Do you want fixed x bytes of data - if so what padding? Do you want bytes of data - if so then what? [...]