1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2005, week 4 2 35 61_[DB2 Z.OS V7.1] Compiler sor cobol stored procedure under WLM17_SALVADORI Etienne17_esalvadori@GMF.FR31_Fri, 22 Jul 2005 11:04:06 +0200366_- Dear Lister, I am developping (w. DB2 V7.1) Stored procedures which runs under WLM. I get no error if the cobol SP was compiled with Cobol EE [5655-G53 IBM Enterprise COBOL for z/OS 3.3.0] and a proper Linkedit. But, if i use Cobol 2 compiler (5668-958 IBM VS COBOL II Release 4.0 09/15/92) the compile succeed but i encounter the following error at runtime: [...] 38 107 31_Unloading unicode data from HPU14_Dheeraj Kaubal26_dheerajkakubal@YAHOO.CO.IN31_Fri, 22 Jul 2005 11:45:00 +0100448_iso-8859-1

Hi all,

Currently we are facing problems with unloading data from unicode table using HPU. We tried using HPU 2.1 and 2.2 with different PTF levels (HPU V2.2 with PTF level PK05817,UK04678 and HPU V2.1 with PTF level UQ97085) but no PTF level is supporting all the scenarios listed below. Could any one help us in finding the proper PTF level of HPU version 2.1 or 2.2 which will support all the following scenarios? [...] 146 18 65_Re: [DB2 Z.OS V7.1] Compiler sor cobol stored procedure under WLM33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Fri, 22 Jul 2005 06:33:25 -0500763_- Etienne

According to the (old) redbook called "Getting Started with DB2 Stored Procedures: Give Them a Call through the Network" on page 35:

Although you can use the VS COBOL II compiler fro DB2 client applications, you cannot use it to compile stored procedures

--------------------------------------------------------------------------------- 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 165 95 31_Re: using trigger to enforce RI12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US31_Fri, 22 Jul 2005 08:19:17 -0400491_us-ascii John -

How about this... CREATE TRIGGER VALIDID NO CASCADE BEFORE INSERT ON OWNER.TEST_TRIGGER REFERENCING NEW AS NEW_ROW FOR EACH ROW MODE DB2SQL when new_row.id_rssd = (select id_rssd from OWNER.CUT_ATTRIBUTES WHERE ID_RSSD = NEW_row.ID_RSSD);

I'm looking at some of the triggers we've created and we use the existence or non-existence of a data returned from a select in the when clause. We typically then insert or delete another table, but this should work. [...] 261 44 28_DB2 Version 7 BUILD2 inquiry11_Greuter, Al18_Al.Greuter@SSA.GOV31_Fri, 22 Jul 2005 09:07:35 -0400557_- Listers:

Preface: I have never had a need to run a reorg using the SHRLEVEL option.

I have an 80+ million row table with a partitioned Primary Key and a NPI. Previously whenever I would execute a reorg at the part level (not an online reorg) I would incur a very long BUILD2 phase. So, whenever I reorg this table at the part level, I drop the NPI, run the necessary reorg and then recreate and rebuild the NPI. However I recently executed on our test system a reorg of just specific partitions without dropping the NPI and was shocked [...] 306 78 32_Re: DB2 Version 7 BUILD2 inquiry14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 22 Jul 2005 14:24:33 +0100501_us-ascii I think for a SHRLEVEL NONE reorg (the default) ALL indexes are rebuilt including NPIs



Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Greuter, Al Sent: 22 July 2005 14:08 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Version 7 BUILD2 inquiry [...] 385 98 32_Re: DB2 Version 7 BUILD2 inquiry10_Tee, Chris21_Chris.Tee@EU.SONY.COM31_Fri, 22 Jul 2005 14:31:33 +0100551_- Al

There is no BUILD2 phase in a SHRLEVEL NONE reorg.

Chris

-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: Friday, July 22, 2005 2:25 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Version 7 BUILD2 inquiry



I think for a SHRLEVEL NONE reorg (the default) ALL indexes are rebuilt including NPIs



Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 484 120 32_Re: DB2 Version 7 BUILD2 inquiry11_Greuter, Al18_Al.Greuter@SSA.GOV31_Fri, 22 Jul 2005 09:34:35 -0400471_- Chris,

Did this change when Version 7 was installed?



Thanks,

Al Greuter Lockheed Martin DB2 Database Administrator (410) 496-9547

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Tee, Chris Sent: Friday, July 22, 2005 9:32 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Version 7 BUILD2 inquiry

Al

There is no BUILD2 phase in a SHRLEVEL NONE reorg. [...] 605 139 32_Re: DB2 Version 7 BUILD2 inquiry10_Tee, Chris21_Chris.Tee@EU.SONY.COM31_Fri, 22 Jul 2005 14:43:20 +0100659_- No, I think it was the same in V6

Chris

-----Original Message----- From: Greuter, Al [mailto:Al.Greuter@SSA.GOV] Sent: Friday, July 22, 2005 2:35 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Version 7 BUILD2 inquiry



Chris,

Did this change when Version 7 was installed?



Thanks,

Al Greuter Lockheed Martin DB2 Database Administrator (410) 496-9547

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Tee, Chris Sent: Friday, July 22, 2005 9:32 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Version 7 BUILD2 inquiry [...] 745 36 29_Multiple CCSID's for DB2 Z/OS0_17_sjvagnier@AEP.COM31_Fri, 22 Jul 2005 09:51:29 -0400425_US-ASCII I'm going to try to explain the problem (opportunity).

I have a request to be able to print a report in output of CCSID 284 (Spanish). This report currently prints as CCSID of 37 (English). The default CCSID in the Zparms is 37. All data in this DB2 environment is stored as CCSID 37. The report to be generated as CCSID 284 would also need to be saved into a table for further referencing as CSSID 284. [...] 782 76 33_Re: Multiple CCSID's for DB2 Z/OS9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 22 Jul 2005 09:32:59 -0500367_windows-1250 You have several possible answers 1. setup a DB2 subsystem with ccsid = 284 2. setup a unicode table (best long term answer) 3. setup unicode table and translate unicode to 284 in the application 4. define all the char columns as for bit data and store ccsid 284 data in a subsystem that runs as ccsid 37 (Very BAD idea - I know but it would work). [...] 859 18 26_DSNUTILB with UNLOAD PAUSE10_Ivan Krnic18_ikmrb@ALLSTATE.COM31_Fri, 22 Jul 2005 09:40:51 -0500728_- If a run DSNUTILB reorg with UNLOAD PAUSE option, it will end normally showing active utility for the current phase. What do I have to do in order to restart DSNUTILB, continuing with RELOAD phase ? Which parts in JCL and control statements need to be modified ?

Regards,

Ivan

--------------------------------------------------------------------------------- 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 [...] 878 129 33_Re: Multiple CCSID's for DB2 Z/OS0_17_sjvagnier@AEP.COM31_Fri, 22 Jul 2005 10:54:49 -0400555_US-ASCII Thanks Mike for the suggestions. Since we are planning to go to DB2 V8 soon, I'll choose option #2.

Regards,

**************************************** Steve Vagnier American Electric Power Database Administration One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-716-3677 Audinet: 200-3677







Mike Bell cc: Sent by: DB2 Data Subject: Re: [DB2-L] Multiple CCSID's for DB2 Z/OS Base Discussion List [...] 1008 68 31_Re: using trigger to enforce RI10_Dave Churn19_davechurn@GMAIL.COM31_Fri, 22 Jul 2005 08:19:31 -0500498_ISO-8859-1 John,

Kals solution looks good. You may want to substitute NEW_ROW for NEW in the existence check query.

Could you share the reasons why you don't want to use traditional RI? Our company uses DB2 RI on a majority of our tables. I am looking for alternative views on the topic.

I did a study for an IDUG presentation that found RI enforced by a trigger to be significantly more expensive that DB2 declarative RI. Significantly equals 2 to 3 times more CPU time. [...] 1077 19 26_DSNUTILB with UNLOAD PAUSE14_Mark McCormack27_mamccormack@STATESTREET.COM31_Fri, 22 Jul 2005 15:40:09 -0400377_US-ASCII To restart REORG .. UNLOAD PAUSE after successful completion of the unload phase: 1. use the same JCL 2. use the same reorg utility control stmt, no changes allowed 3. use RESTART or RESTART(PHASE) in the third position of the parm to dsnutilb example 1: EXEC PGM=DSNUTILB,PARM='ssid,utilid,RESTART' example 2: EXEC PGM=DSNUTILB,PARM='ssid,utilid,RESTART(PHASE)' [...] 1097 61 33_Re: Multiple CCSID's for DB2 Z/OS0_18_IWANT2BEME@AOL.COM29_Fri, 22 Jul 2005 18:40:58 EDT352_US-ASCII If the reports, or data for the reports, is already created in the CCSID that is needed, then the data can be stored in columns as FOR BIT DATA. That way you could have both types of reports in the same table. No translations would happen when it was being retrieved. The table can be defined as an EBCDIC table or whatever your norm is. [...] 1159 50 32_Re: DB2 Version 7 BUILD2 inquiry10_Alan Smith20_alancsmith@GMAIL.COM31_Sat, 23 Jul 2005 02:11:58 -0500577_- There's no BUILD2 phase with SHRLEVEL NONE, but the update of the logical partitions of the NPIs still has to be done, presumably in the BUILD phase.

Alan Smith

On Fri, 22 Jul 2005 09:07:35 -0400, Greuter, Al wrote:

>Listers: > >Preface: I have never had a need to run a reorg using the SHRLEVEL option. > >I have an 80+ million row table with a partitioned Primary Key and a NPI. >Previously whenever I would execute a reorg at the part level (not an online >reorg) I would incur a very long BUILD2 phase. So, whenever I reorg [...] 1210 28 33_Re: Multiple CCSID's for DB2 Z/OS33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Sat, 23 Jul 2005 12:45:30 +0200448_iso-8859-1 You can create unicode databases/tablespace/tables in V7.

Roland

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of sjvagnier@AEP.COM Sent: Friday, July 22, 2005 4:55 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Multiple CCSID's for DB2 Z/OS



Thanks Mike for the suggestions. Since we are planning to go to DB2 V8 soon, I'll choose option #2. [...] 1239 162 32_Re: DB2 Version 7 BUILD2 inquiry12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 23 Jul 2005 17:19:45 +0200554_us-ascii Hi,

V5 introduced the OLR .

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Tee, Chris Sent: Friday, July 22, 2005 3:43 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Version 7 BUILD2 inquiry

No, I think it was the same in V6

Chris

-----Original Message----- From: Greuter, Al [mailto:Al.Greuter@SSA.GOV] Sent: Friday, July 22, 2005 2:35 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Version 7 BUILD2 inquiry [...] 1402 46 24_Re: Control Center hangs11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 23 Jul 2005 13:24:55 -0500293_- I had similar problems when beta testing Version 8 (stinger). I got around it by starting another tool, say task center or journal, and then starting Control Center from there. That was beta though and I haven't seen it since V8 went GA. We're at fixpak 8 which has been pretty stable. [...] 1449 63 58_Re: DB2 group id not picked when using Developement Center11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 23 Jul 2005 13:37:59 -0500380_ISO-8859-1 We have similar quirks with Dev Center running against DB2 on z/OS. Usually they're fixed by a newer fixpak or we find temporary workarounds. We just found one yesterday in fp8 that is resolved by fp9. A numeric input parm is getting a 49 value instead of 0, when it follows a varchar (250) parm. It's not always easy/wise to upgrade to a new fixpak to fix these. [...] 1513 54 26_Re: Saving ROLLedBACK data11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 23 Jul 2005 13:48:31 -0500274_- We've done it 3 different ways:

1. Displays or calls to CEEMOUT in the SP

2. EXCI call to CICS which is sync on return so it's committed even if the SP's thread is rolled back (CICS could write it to a file, insert to a table, put message to MQ, etc.). [...] 1568 45 33_Re: Multiple CCSID's for DB2 Z/OS0_18_IWANT2BEME@AOL.COM29_Sat, 23 Jul 2005 15:12:23 EDT660_US-ASCII Yes, you can create UNICODE database tables with DB2 V7. There are restrictions about how they can be used. For example, they can not be joined with an EBCDIC table.

Jacquie

--------------------------------------------------------------------------------- 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 1614 62 31_Max remote connection (CONDBAT)12_Hamid Alvani22_alvani@DPI2.DPI.NET.IR31_Sun, 24 Jul 2005 07:27:10 +0430751_iso-8859-1 Hi All; With OS/390 and DB2 V7.1 we can have up to 150 000 distributed threads connect to a DB2 server at the same time according to DB2 Administration Guide book.My question is: Is there any restriction in storage allocation for this number of connection? Thanks HAMID

--------------------------------------------------------------------------------- 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 1677 124 39_DB2 V8 LATCH CONTENTION & MQ Backups...17_Charles Valentine15_VALENCH@AOL.COM29_Sun, 24 Jul 2005 13:44:24 EDT575_US-ASCII We recently upgraded our East Coast (2-way Data Sharing) environment to: DB2 V8 at RSU-0505 + Hipers. CICS/DB2 & regular Batch workload seems to be running fine but we have one Real Time Rating Application that runs approx. 120 Batch Jos per L-Par which waits for data to come in via MQ & at 5 minute intervals, does inserts to DB2 tables. Applications Group is complaining that their MQ's are getting "backed up" and that overall performance is running slower in Version 8 than in our East Coast V7 Real Time Rating Application. I've opened Pmr with IBM & has [...] 1802 71 35_Re: Opinions: UDB/Linux vs. UDB/AIX4_Phil22_pgunning@GUNNINGTS.COM31_Sun, 24 Jul 2005 22:27:02 -0400560_us-ascii There is not one answer to your question. DB2 runs well on both AIX and Linux. In your current environment you are running a robust OS (VSE) with a mature support organization in-place. Does your company have Linux/UNIX experience on the staff? DB2 UDB is different from DB2/VSE. Linux and AIX are of course quite different than VSE. So you will have to acquire new DB2 UDB skills. Since you will be going to AIX or Linux, you will need to develop those skills (or someone else in the organization) and as a DB2 UDB DBA you will need proficiency [...] 1874 379 30_Re: UDB (windows) memory usage4_Phil22_pgunning@GUNNINGTS.COM31_Sun, 24 Jul 2005 22:41:11 -0400571_us-ascii VG, with 32bit addressability, the virtual address space on Windows is limited to 4GB. Of that the Windows OS gets 2GB and DB2 gets 2GB. Of the 2GB left for DB2, what's left over after the DB2 kernel gets what it needs is approx. 1.75GB. Of the 1.75GB, all database shared memory comes out of this, not just bufferpools. So you were overallocating bufferpools and/or other shared memory areas. More RAM would not help that problem. I'd concentrate on tuning SQL and maybe you wouldn't need to make the buffer pools as big. If OS paging, then more RAM would [...] 2254 67 27_z/os v7 Declared GTT & -6010_28_steve.tennant@CUSTOMS.GOV.AU31_Mon, 25 Jul 2005 18:22:30 +1000353_iso-8859-1 Hi folks,

I have a developer who has written a program with a DGTT. His logic is...

CREATE ..... INSERT... PROCESS ..... DELETE .... etc End of (CICS) transaction

Now when he runs this t/x a second time he gets a -601(duplicate) on the create. If we check the catlog, sure enough there is one. Next he tried this... [...] 2322 54 65_Re: [DB2 Z.OS V7.1] Compiler sor cobol stored procedure under WLM17_SALVADORI Etienne17_esalvadori@GMF.FR31_Mon, 25 Jul 2005 10:25:14 +0200414_iso-8859-1 Thanks Walter, I very glad to read this.

Etienne Salvadori

AZUR-GMF . SGBD Levallois . ISM 01-49-64-37-73



-----Message d'origine----- De : DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] De la part de Walter Janißen Envoyé : vendredi 22 juillet 2005 13:33 À : DB2-L@WWW.IDUGDB2-L.ORG Objet : Re: [DB2 Z.OS V7.1] Compiler sor cobol stored procedure under WLM [...] 2377 101 31_Re: z/os v7 Declared GTT & -60110_Tee, Chris21_Chris.Tee@EU.SONY.COM31_Mon, 25 Jul 2005 09:27:57 +0100453_iso-8859-1 Steve

Have a look at APAR PQ36123, sounds like it may be your problem

Chris Tee DB2 DBA Infrastructure Services & SAP Solutions (iS3) Information Systems Europe SONY Europe Tel: +44 (0) 1256 82 8342



-----Original Message----- From: steve.tennant@CUSTOMS.GOV.AU [mailto:steve.tennant@CUSTOMS.GOV.AU] Sent: Monday, July 25, 2005 9:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] z/os v7 Declared GTT & -601 [...] 2479 120 31_Re: z/os v7 Declared GTT & -60117_SALVADORI Etienne17_esalvadori@GMF.FR31_Mon, 25 Jul 2005 10:31:45 +0200425_iso-8859-1 Hello, Do you know if there is a COMMIT (explicit or implicit) between the two runs ? Etienne Salvadori

AZUR-GMF . SGBD Levallois . ISM 01-49-64-37-73



-----Message d'origine----- De : DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] De la part de steve.tennant@CUSTOMS.GOV.AU Envoyé : lundi 25 juillet 2005 10:23 À : DB2-L@WWW.IDUGDB2-L.ORG Objet : z/os v7 Declared GTT & -601 [...] 2600 95 31_Re: z/os v7 Declared GTT & -60110_Tee, Chris21_Chris.Tee@EU.SONY.COM31_Mon, 25 Jul 2005 09:35:16 +0100508_iso-8859-1 Steve

You could also try putting the DROP at the end of the txn

Chris

-----Original Message----- From: steve.tennant@CUSTOMS.GOV.AU [mailto:steve.tennant@CUSTOMS.GOV.AU] Sent: Monday, July 25, 2005 9:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] z/os v7 Declared GTT & -601



Hi folks,

I have a developer who has written a program with a DGTT. His logic is...

CREATE ..... INSERT... PROCESS ..... DELETE .... etc End of (CICS) transaction [...] 2696 64 46_Auto-increment column for multiple key columns12_Selim Balcik24_selim.balcik@TCMB.GOV.TR31_Mon, 25 Jul 2005 03:53:41 -0500334_- Hi,

I am trying to create a table having three columns as primary key. And I want one of these columns to be an auto-increment column which starts from the beginning for each different value combinations of the other two primary columns. For example:

PRJYIL PRJBRM PRJNO Key1 Key2 Key3(autoinc) A X 1 A X 2 A X 3 [...] 2761 194 31_Re: z/os v7 Declared GTT & -6016_ducduc17_ndt.db2@GMAIL.COM31_Mon, 25 Jul 2005 11:18:15 +0200433_ISO-8859-1 SQLCODE601 received on a DECLARE GLOBAL TEMPORARY TABLE statement after repeatedly running the same application process while using CICS/IMS thread reuse, and the application process did not previously define a declared temporary table with the same table name during this run. Also, the application process does not explicitly drop the table using the DROP TABLE statement before the application process terminates. [...] 2956 99 50_Re: Auto-increment column for multiple key columns14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 25 Jul 2005 10:34:11 +0100409_us-ascii Your trigger solution is logically flawed anyway (I'm afraid).

You could get two people inserting a row at the "same time" and they could then get the same "max +1" value unless you somehow serialized the SELECT MAX().



Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 3056 31 12_SQLCODE -33214_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE31_Mon, 25 Jul 2005 11:49:51 +0200336_us-ascii Hello DB2 list,

last weekend we migrated the first of our DB2 subsystems to V8, and now we get SQLCODE -332 when accessing a particular table. This is a very old table, created in 1999. I checked the catalog, but I could see no differences between this tables and others from the same period, but without problems. [...] 3088 105 16_Re: SQLCODE -3324_Peri19_peri.ncst@GMAIL.COM31_Mon, 25 Jul 2005 15:27:16 +0530629_ISO-8859-1 Can you attach the more information which db2diag.log file contains. It might help find more information on the code page conversion. One quick task you could possibly do is to check if you are being hit by APAR *IY59411* http://www-1.ibm.com/support/docview.wss?uid=swg1IY59411

On 7/25/05, Bernd Oppolzer wrote: > > Hello DB2 list, > > last weekend we migrated the first of our DB2 subsystems to V8, and now we > get > SQLCODE -332 when accessing a particular table. This is a very old table, > created in 1999. I checked the catalog, but I could see no differences > between [...] 3194 74 28_Re: AW: [DB2-L] SQLCODE -33214_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE31_Mon, 25 Jul 2005 12:18:50 +0200726_iso-8859-1 They are all zero, the ENCODING_SCHEME is 'E'. There is no difference between the problem TS and the others from the same period, which work.

Thank you, regards

Bernd





Am Montag, 25. Juli 2005 11:54 schrieb Peter, Georg: > Hello Bernd, > > did you check the SBCS_CCSID, DBCS_CCSID and MIXED_CCSID of the tablespace > where the "old table" is in ? > > With kind regards - mit freundlichen Gruessen, > Georg H. Peter c/o > ------------------------------------------------------------------- > Datenzentrale Baden-Wuerttemberg > Knowledge Center Database Systems > Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe > e:mail G.Peter@dzbw.de > Phone 0049-711-8108-271 > [...] 3269 65 16_Re: SQLCODE -33214_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE31_Mon, 25 Jul 2005 12:24:09 +0200434_iso-8859-1 I only have the information from the SQLCA, that is:

SQLCODE -332 Character conversion between CCSID 65534 to 273 requested by DSNXROHB is not supported SQLSTATE 57017 SQLERRP = DSNXEASC SQLERRD = -100 0 0 -1 0 0

273 is EBCDIC, I guess, that is because the application runs on the mainframe. Don't know where CCSID 65534 comes from. We get the same error when accessing the table by program or by SPUFI. [...] 3335 17 39_No inline copy with LOAD REPLACE PART ?15_Daniel Cremieux17_c300501@YAHOO.COM31_Mon, 25 Jul 2005 07:34:11 -0500310_- Dear colleagues , Looking at the syntax diagram for LOAD , i don't see any way to use the the inline copy feature with Load replace part : The COPY keyword is associated with the REPLACE keyword at the tablespace level , so it seems to be impossible to have an Inline copy of the partition replaced ... [...] 3353 51 43_Re: No inline copy with LOAD REPLACE PART ?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 25 Jul 2005 13:55:49 +0100572_us-ascii The COPY specification block also appears in the INTO TABLE syntax diagram (page 192 in the v8 utility guide, I don't have the v7 one to hand)



Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Daniel Cremieux Sent: 25 July 2005 13:34 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] No inline copy with LOAD REPLACE PART ? [...] 3405 61 32_Fwd: SQLCODE -332 problem solved14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE31_Mon, 25 Jul 2005 15:24:33 +0200508_iso-8859-1 Hello DB2 list,

the problem table had FOREIGNKEY = M (mixed) in the catalog table SYSCOLUMNS; we don't know, why and how.

We solved the problem by creating a new table, unloading and reloading the data, switching the view definition and rebind of the application.

There are some (a handful) of other tables with FOREIGNKEY = M (which is an error in our environment), but none of them had this problem. Maybe the problem appears only in combination with a VARCHAR column. [...] 3467 24 32_UDB LUW timeout - Can't remember13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Mon, 25 Jul 2005 10:13:22 -0400311_iso-8859-1 Hi list,

I'm UDB LUW 8.2.2. A while back I set some parameter to timeout any queries running more than 30 seconds. I need to increase this, but I cannot remember where this parameter is and whether it is at the instance level or database level. It's not the lock timeout I'm looking for. [...] 3492 49 36_Re: UDB LUW timeout - Can't remember0_28_David.Stritzinger@ALTRIA.COM31_Mon, 25 Jul 2005 11:24:05 -0400521_- Scott,

Are you using the DB2 governor to do this? If you are then there should be a configuration file in the instance owner sqllib directory. If you are not using the governor, then I would be interested in knowing what parameter you are using also.

Dave S.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hodgin, Scott Sent: Monday, July 25, 2005 10:13 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] UDB LUW timeout - Can't remember [...] 3542 71 36_Re: UDB LUW timeout - Can't remember13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Mon, 25 Jul 2005 11:28:55 -0400653_iso-8859-1 Dave,

I think it might have been a config file, but I cannot remember what the file is called or where it is located.

Scott

-----Original Message----- From: David.Stritzinger@ALTRIA.COM [mailto:David.Stritzinger@ALTRIA.COM] Sent: Monday, July 25, 2005 11:24 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] UDB LUW timeout - Can't remember



Scott,

Are you using the DB2 governor to do this? If you are then there should be a configuration file in the instance owner sqllib directory. If you are not using the governor, then I would be interested in knowing what parameter you are using also. [...] 3614 22 50_Re: Auto-increment column for multiple key columns12_Selim Balcik24_selim.balcik@TCMB.GOV.TR31_Mon, 25 Jul 2005 10:27:46 -0500373_- Hi,

We used MySql during the primary stages of our project and it was working beautifully for the auto-increment function in table creation. So we have developed some amount of code with that functionality which we do not want to change abruptly.

If we assume that "concurrent entry" is not our problem, how could we solve that CREATE TRIGGER problem? [...] 3637 108 36_Re: UDB LUW timeout - Can't remember0_28_David.Stritzinger@ALTRIA.COM31_Mon, 25 Jul 2005 11:36:03 -0400396_- Scott

If it is the governor, the file can be called anything you want, with the default location being the sqllib directory. I will assume for now, that it is the governor and that you are running on a Unix / AIX box. It these assumptions are true ( or to check out if you are using the governor) do a ps -ef|gep db2gov . Here is what I get back ( oh yea, I am running PDF option). [...] 3746 132 36_Re: UDB LUW timeout - Can't remember13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Mon, 25 Jul 2005 12:57:44 -0400291_iso-8859-1 Dave,

Thanks for the response. I don't think this what I am looking for. Also, I'm on Windows. I think what I am looking for is some kind of CLI timeout parameter, but again, I can't remember what it was. I've been doing a bunch of Google searches, but no luck yet... [...] 3879 67 82_[z/OS v7] Unable to drop FK - 00E70005 - (RDS) subcomponent internal inconsistency14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Mon, 25 Jul 2005 12:21:19 -0500428_US-ASCII I am trying to drop a foreign key and DB2 will not do the drop, got SPUFI, Catalog Manager and a distributed connection to abend - I finally got a reason code when trying it in batch:

00E70005: A relational data system (RDS) subcomponent internal inconsistency was detected.

scary.....

I am doing some further research, but if someone knows the resolution to this, please let me know. thanks, [...] 3947 77 86_Re: [z/OS v7] Unable to drop FK - 00E70005 - (RDS) subcomponent internal inconsistency9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 25 Jul 2005 12:47:09 -0500369_windows-1250 I would start by opening a incident with IBM. It usually means that the DBD and the catalog are not consistent. If you don't mind the possibilitiy of completely stopping the access to all the tables in the DBD, you can try REPAIR utility.

REPAIR DBD DIAGNOSE DATABASE insert your dbname here - will just report the differences between the two. [...] 4025 168 36_Re: UDB LUW timeout - Can't remember10_Jeff Glenn32_jglenn@ENTERTAINMENTPARTNERS.COM31_Mon, 25 Jul 2005 12:17:01 -0700639_us-ascii Hi Scott. I believe the parameter you are looking for is QUERYTIMEOUTINTERVAL.

Jeff



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hodgin, Scott Sent: Monday, July 25, 2005 9:58 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] UDB LUW timeout - Can't remember

Dave,

Thanks for the response. I don't think this what I am looking for. Also, I'm on Windows. I think what I am looking for is some kind of CLI timeout parameter, but again, I can't remember what it was. I've been doing a bunch of Google searches, but no luck yet... [...] 4194 275 86_Re: [z/OS v7] Unable to drop FK - 00E70005 - (RDS) subcomponent internal inconsistency14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Mon, 25 Jul 2005 14:31:10 -0500295_US-ASCII Thanks Mike, So that no-one else wastes time on this for me, by the time I got the job set up and the OK from Apps to stop the DB (luckily in development), a DBA had dropped the tablespace.

So I never got to play with my new toy for the day - maybe next time. thanks again. [...] 4470 112 36_Re: UDB LUW timeout - Can't remember4_Phil22_pgunning@GUNNINGTS.COM31_Mon, 25 Jul 2005 15:48:23 -0400579_us-ascii It would have been specified in the governor config file, using the uowtime option. There is also a new option in V8.2.2 called Lock Wait Mode, which is a new option available to applications in DB2 UDB for Linux, UNIX and Windows V8.2. An Application can specify an individual lock wait mode strategy that will cause the application to take one of the following actions when it cannot obtain a lock: .Return and SQLCODE or SQLSTATE .Wait indefinitely for a lock .Wait a specified amount of time for a lock .Use value of locktimeout DB CFG parameter .The lock wait [...] 4583 137 50_Re: Auto-increment column for multiple key columns11_Hardy, Dale14_DHardy@MIB.COM31_Mon, 25 Jul 2005 16:13:58 -0400501_us-ascii If concurrency is not an issue, you could Redefine the PRJNO column as smallint default 32767 And then define the trigger as

CREATE TRIGGER RAUTINC AFTER INSERT ON BIEPRYN.TPROJEFORM REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN (N.PRJNO = 32767) BEGIN ATOMIC UPDATE RAUTINC SET PRJNO = (SELECT COALESCE(MAX(PRJNO),0) + 1 FROM TPROJEFORM WHERE PRJYIL = N.PRJYIL AND PRJBRM = N.PRJBRM AND PRJNO < 32767 ) WHERE PRJYIL = N.PRJYIL AND PRJBRM = N.PRJBRM AND PRJNO = 32767 ; END; [...] 4721 34 45_UDB DB2 V8.2 on AIX . Installation question..7_Hanh Vu20_udbdba2004@YAHOO.COM31_Mon, 25 Jul 2005 13:52:29 -0700402_iso-8859-1 We're currently running UDB V7.2GA and we're planning to install UDB V8.2 soon... so that we can migrate it off the unsupported version of UDB.. Question:

Can we install UDB V8.2 on the same server UDB V7 currenlty rund on without bringing down UDB DB2 V7?

We also noticed that the SW on V7 is in /usr/lpp and in V8 will be in /usr/opt... So that should be Okay, correct? [...] 4756 68 49_Re: UDB DB2 V8.2 on AIX . Installation question..14_swamy kanathur24_swamy_kanathur@YAHOO.COM31_Mon, 25 Jul 2005 14:13:26 -0700573_iso-8859-1 You should be fine. On Unix and Linux you can run 7.2 and 8.2 at the same time.

7.2 installs in the /usr/lpp dir

8.2 installs in the /usr/opt dir

You should have no problems

SK

--- Hanh Vu wrote:

> We're currently running UDB V7.2GA and we're > planning to install UDB V8.2 soon... so that we can > migrate it off the unsupported version of UDB.. > Question: > > Can we install UDB V8.2 on the same server UDB V7 > currenlty rund on without bringing down UDB DB2 V7? > > We also noticed that [...] 4825 154 36_Re: UDB LUW timeout - Can't remember3_tom15_tom@SATX.RR.COM31_Mon, 25 Jul 2005 19:11:34 -0500634_iso-8859-1 I believe that the setting you are looking for is set on the client side in the cli.cfg. ----- Original Message ----- From: "Phil" Newsgroups: bit.listserv.db2-l To: Sent: Monday, July 25, 2005 2:48 PM Subject: Re: [DB2-L] UDB LUW timeout - Can't remember



> It would have been specified in the governor config file, using the uowtime > option. There is also a new option in V8.2.2 called Lock Wait Mode, which is > a new option available to applications in DB2 UDB for Linux, UNIX and > Windows V8.2. An Application can specify an individual lock wait [...] 4980 126 31_Re: z/os v7 Declared GTT & -6010_28_steve.tennant@CUSTOMS.GOV.AU31_Tue, 26 Jul 2005 10:48:47 +1000480_iso-8859-1 Thanks everyone for the replies. This APAR appears to be a direct hit but...... The developer had coded a CREATE instead of a DECLARE. You think after a quarter of a century I'd have learnt to check their code before annoying you guys.

Thanks again,

Steve T

-----Original Message----- From: Tee, Chris [mailto:Chris.Tee@EU.SONY.COM] Sent: Monday, 25 July 2005 18:28 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] z/os v7 Declared GTT & -601 [...] 5107 36 50_Re: Auto-increment column for multiple key columns12_Selim Balcik24_selim.balcik@TCMB.GOV.TR31_Tue, 26 Jul 2005 01:15:01 -0500333_- I tried the create statement (and some derivatives of it - eg: I changed the UPDATE RAUTINC... to UPDATE TPROJEFORM...) that you have sent, but it is insisting on the same error. I can not understand why it responses with SQLCODE -104.

I work on DB2 v7 for OS/390. Do you think DB2 behaves different on this mainframe? [...] 5144 31 50_Re: Auto-increment column for multiple key columns12_Selim Balcik24_selim.balcik@TCMB.GOV.TR31_Tue, 26 Jul 2005 02:09:46 -0500322_- Yes, it seems to be okey. I removed "begin atomic...end" block as the reference manual says there is no need for it if there is only one sql statement in the trigger. So the parser is out of the way and the create trigger statement works... I tested the trigger by inserting rows into the table and it is okey too. [...] 5176 32 47_DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION)12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 26 Jul 2005 11:27:19 +0200754_- Collegues,

While strolling through the DSNZPARM's I saw a parameter named EXPLAIN+ (EXTENDED EXPLAIN GENERATION).

What are the goodies if I set this parm to YES (Environment is DB2 for z/OS Version 7) ?

Thanks in advance for any advice you may be able to provide.

With kind regards - mit freundlichen Gruessen, Georg H. Peter c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- [...] 5209 18 53_What is the purpose of LRSN and TYPE in Mapping table24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Tue, 26 Jul 2005 06:44:12 -0500689_- Esteemed Gurus,

Can some one explain to me what purpose the LRSN and the TYPE columns of the mapping table serve.

How are they populated?



As always I am grateful for your time and effort.

--------------------------------------------------------------------------------- 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 5228 25 23_PUNC bit and Page Reorg24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Tue, 26 Jul 2005 07:00:30 -0500324_- Dear Gurus,



During lock avoidance PUNC bit is checked.

WHen does the Punc bit get set?

I understand that the punc bits get reset or set to off when (a) When a page is locked in exclusive mode and no updates are done. (b) WHen more than 25 % of the rows in a page have PUNC bit turned on. [...] 5254 73 65_AW: [DB2-L] What is the purpose of LRSN and TYPE in Mapping table12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 26 Jul 2005 14:22:06 +0200591_iso-8859-1 log record sequence number (LRSN): A 6-byte value that DB2 generates and associates with each log record. The LRSN is contained in the DB2 log record header and tablespace header page. The LRSN replaces the RBA in a data sharing environment, although each member continues to use the RBA for its own logs and BSDS. A number that DB2 generates and associates with each log record. DB2 also uses the LRSN for page versioning. The LRSNs generated by a given DB2 data sharing group form a strictly increasing sequence for each DB2 log and a strictly increasing sequence for each [...] 5328 48 51_Re: DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION)13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 26 Jul 2005 07:40:21 -0500808_us-ascii I would suggest leaving that value unchanged.

Willie My DB2 blog - http://blogs.ittoolbox.com/database/db2zos

Peter, Georg wrote:

>Collegues, > >While strolling through the DSNZPARM's I saw a parameter named EXPLAIN+ >(EXTENDED EXPLAIN GENERATION). > >What are the goodies if I set this parm to YES (Environment is DB2 for z/OS >Version 7) ? > >Thanks in advance for any advice you may be able to provide. > >With kind regards - mit freundlichen Gruessen, >Georg H. Peter c/o >------------------------------------------------------------------- >Datenzentrale Baden-Wuerttemberg >Knowledge Center Database Systems >Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe >e:mail G.Peter@dzbw.de >Phone 0049-711-8108-271 >PC-Fax 004971189696071 >Internet (only in german [...] 5377 49 27_Re: PUNC bit and Page Reorg13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 26 Jul 2005 07:51:14 -0500353_ISO-8859-1 The PUNC bit is set when a row is modified. The Possibly UNCommited (PUNC) bit is used to identify which rows, if any have been changed in a page. If the Commit Log Sequence Number (CLSN) test fails while trying to determine if a lock can be avoided, the PUNC test is performed. If both test fail, then a lock must be taken on the page. [...] 5427 57 51_Re: DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION)12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 26 Jul 2005 08:07:20 -0500541_US-ASCII This sounds like the flag to allow all of the explain tables to be generated. Where in the DSNZPARMs did you find this entry? I checked both our V7 and V8 systems and could not find your wording of (EXTENDED EXPLAIN GENERATION).

Gerald Hodge HLS Technologies, Inc.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter, Georg Sent: Tuesday, July 26, 2005 4:27 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION) [...] 5485 102 59_AW: [DB2-L] DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION)12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 26 Jul 2005 15:13:04 +0200615_iso-8859-1 Gerald,

I have found this within BMC's OPERTUNE DB2 parameter list:

.. EDMPOOL EDM POOL SIZE .. EXPLAIN+ EXTENDED EXPLAIN GENERATION <<<<<< .. EXTRAREQ EXTRA DRDA QUERY BLOCKS

May be it is a feature of Opertune - and not a real DSNZPARM...........

With kind regards - mit freundlichen Gruessen, Georg

-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Gerald Hodge Gesendet: Dienstag, 26. Juli 2005 15:07 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Re: [DB2-L] DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION) [...] 5588 113 43_easy way to delete all datasets in a volume13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Tue, 26 Jul 2005 09:15:33 -0400416_UTF-8 This is not strictly a DB2 question but maybe someone could help.

OS/390

Is there an easy way(JCL) to delete all datasets in a certain volume? I am trying to delete all datasets on a certain volume. The TSO Delete command takes only one * (USERID.*) and has limited function.

I am testing some jobs that creates datasets on a particular volumes, and I need to delete them repeatedly. [...] 5702 196 57_Re: What is the purpose of LRSN and TYPE in Mapping table10_OZGUR OZEN13_oozen@YKB.COM31_Tue, 26 Jul 2005 16:16:36 +0300537_ISO-8859-9 from the link below there is some information about the method for online reorganization,it is a theory but I think is very helpfull for understanding the concepts.

http://www.research.ibm.com/journal/sj/363/sockut.html









Ramachandran Subramanian

Sent by: DB2 Data Base Discussion List 26.07.2005 14:44 Please respond to DB2 Database Discussion list at IDUG



To DB2-L@WWW.IDUGDB2-L.ORG cc [...] 5899 190 51_Re: DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION)14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Tue, 26 Jul 2005 08:19:30 -0500832_US-ASCII Could you give a reason please ?

thanks, Mark.







Willie Favero Sent by: DB2 Data Base Discussion List 07/26/2005 07:40 AM Please respond to wfavero@attglobal.net



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject Re: DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION)











I would suggest leaving that value unchanged.

Willie My DB2 blog - http://blogs.ittoolbox.com/database/db2zos

Peter, Georg wrote:

>Collegues, > >While strolling through the DSNZPARM's I saw a parameter named EXPLAIN+ >(EXTENDED EXPLAIN GENERATION). > >What are the goodies if I set this parm to YES (Environment is DB2 for z/OS >Version 7) ? > >Thanks in advance for any advice you may be able [...] 6090 485 47_Re: easy way to delete all datasets in a volume13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Tue, 26 Jul 2005 09:20:08 -0400594_us-ascii If you have FDR you can use the following:

//ABRDUMP1 EXEC PGM=FDRABR,REGION=1024K

//SYSPRINT DD SYSOUT=*

//SYSPRIN1 DD SYSOUT=*

//SYSUDUMP DD SYSOUT=*

//ABRMAP DD SYSOUT=*

//TAPE1 DD DUMMY

//SYSIN DD *

DUMP TYPE=SCR,BUFNO=MAX,DYNARC,PRINT=ABR,DSNENQ=USE,ONLVOL,

SELTERR=NO,ENQERR=NO

SELECT VOLG=DB2T*,DSN=**





The VOLG= parameter can be a fully qualified volume, or wild carded with the *





Of course you need the RACF authority do delete any data set on the volume. [...] 6576 25 47_Re: easy way to delete all datasets in a volume15_Chris Hoelscher21_choelscher@HUMANA.COM31_Tue, 26 Jul 2005 09:35:32 -0400853_US-ASCII IEFBR14

Chris Hoelscher IDMS & DB2 Database Administrator Humana Inc 502-580-2538 choelscher@humana.com









The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

--------------------------------------------------------------------------------- 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 [...] 6602 77 63_Re: AW: [DB2-L] DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENERATION)12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 26 Jul 2005 08:38:02 -0500482_iso-8859-1 If this is from OPERTUNE then it explains both why I can not find it in the IBM references and what it is.

In V6 and V7 there is an ability to generate data to the "Hidden" Explain tables. This ability was removed in V8. Even if you have them defined, you need to have this parameter in the DSNZPARMs set. So to use it you will require both the parameter in the DSNZPARMs to be set and tables define, which in tern requires the DDL that IBM does not publish. [...] 6680 110 64_Re: AW: [DB2-L] DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENE RATION)10_Tee, Chris21_Chris.Tee@EU.SONY.COM31_Tue, 26 Jul 2005 14:43:30 +0100298_iso-8859-1 Georg

Yes, I think it's an Opertune feature to turn on the population of the extended explain tables. It probably just changes the value of SPRMXPL from 0 to 1. This can be done manually by editing the value of &SPRMXPL in the DSN6SPRC macro. (at your own peril, of course!) [...] 6791 59 8_DSNTPSMP14_Niemiec Robert33_Robert.Niemiec@TELEKOMUNIKACJA.PL31_Tue, 26 Jul 2005 15:37:12 +0200618_iso-8859-2 Hi, I try to build stored procedure with DSNTPSMP. When I submit job DSNTEJ65 I get in step PH065S03 message: * DSNTPSMP has completed with return code 999 * SQL changes have been rolled back

and in the WLM startup PROC for DSNTSPMP I get the message: 1034 *-* address TSO "FREE DDNAME(SYSIN)" /* Test STEPLIB APF status */ +++ RC(-3) +++ *** UNRECOVERABLE ERROR occured at 2005-07-25 15.15.32. DSNTPSMP cannot continue. *** > TSO commands ALLOCATE and FREE are unavailable in the current WLM environment. *** > Assure at least one dataset in the dd:STEPLIB concatenation is not APF-authorized. [...] 6851 19 23_DB2set rc = -4400 error3_lan18_lxw176@HOTMAIL.COM31_Tue, 26 Jul 2005 09:13:32 -0500690_- Hi,



I received an error as following: DB2SET processing complete, rc = -4400, SQLCODE = 0 after we changed the IP address for the AIX 5.2 machine that has DB2 UDB 7.1 installed. kindly help! Thanks! Lan

--------------------------------------------------------------------------------- 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 6871 170 72_AW: [DB2-L] AW: [DB2-L] DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENE RATION)12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 26 Jul 2005 16:19:11 +0200519_iso-8859-1 >>> I think it's an Opertune feature <<<

I think so, too. Is it possible that someone from BMC can confirm this ?

Regards, Georg ----------------------------------------------------------------------



-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Tee, Chris Gesendet: Dienstag, 26. Juli 2005 15:44 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Re: [DB2-L] AW: [DB2-L] DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENE RATION) [...] 7042 21 19_DB2 solution needed3_lan18_lxw176@HOTMAIL.COM31_Tue, 26 Jul 2005 09:15:13 -0500504_- Hi,

What is the best solution to have a robust/redundant system connecting web server and database for we applications? Here I plan to have two web servers connecting to two DB2 database separately. I want to make sure that when one system (web server + db2 database) disfunctions, the other one can still working correctly. Does DB2 replication or clustering can meet my requirement? Does someone has better solutions? I have DB2 UDB 8.1 installed on AIX machine. Kindly help! Thanks! Lan [...] 7064 59 35_DB2 extents causing 00C90101 errors15_Ferguson, Keena21_KFerguson@COMDATA.COM31_Tue, 26 Jul 2005 09:23:24 -0500446_iso-8859-1 All,

We are having issues with data sets going into extents (since an upgrade to ZOS)... We have an problem open with IBM, but have been blocking dumps due to numerous '04E' errors ... It looks like the striping capabilities with ZOS are causing DB2 problems ... Has any one else had a similar experience ... Does anyone have a resolution ... We are getting the following error: -DB3P DSNKNXT2 DATA IN USE DURING ABEND 219 [...] 7124 108 17_procedure monitor14_Dash, Sushanta21_Sushanta.Dash@FMR.COM31_Tue, 26 Jul 2005 10:56:10 -0400449_us-ascii Hi Everybody,

This is a question for UDB. Trying to co relate the same with db2 on Z/os. As far procedure details needed we go for checking the pacakage details in accounting report so that we get the details.

For Db2 on LUW I want to look at the details of procedure within a session. I have no monitoring tool. What exact steps I need to do. Waiting for your quick reply. Any tricks or methology is highly appreciated. [...] 7233 186 21_Re: procedure monitor14_Dash, Sushanta21_Sushanta.Dash@FMR.COM31_Tue, 26 Jul 2005 11:04:17 -0400612_us-ascii I recalled that snapshot at instance level is available. Can any one refer me the docs I need to look at that so that I can get a quich view of it.



Thanks Sushant Dash

Any comments or statements made in this email are not necessarily those of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity Investments group companies. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you have received this in error, please contact the sender and delete the material [...] 7420 105 23_Re: DB2 solution needed15_Leon Katsnelson15_leon@CA.IBM.COM31_Tue, 26 Jul 2005 11:20:17 -0400704_US-ASCII The best practice for building resilient web applications is to build a cluster of web servers and a separate cluster of database servers. Clustering web servers is very easy and is a very natural thing to do because in general web servers don't contain any state information. A typical web server cluster will involve 2 or more web application servers with some sort of a virtual IP device in front of them. These devices come from pretty much every network vendor out there (eg. CISCO CSS 11500 http://www.cisco.com/en/US/products/hw/contnetw/ps792/ps4949/index.html, BigIP http://www.f5.com/f5products/products/bigip/ltm/). AN alternative is to use a software solution. Popular examples [...] 7526 331 47_Re: easy way to delete all datasets in a volume10_Doyle Mark21_Mark.Doyle@WIN-NA.COM31_Tue, 26 Jul 2005 10:21:36 -0500358_US-ASCII Here is a semi-manual way to do it (assumes you have SDSF, and other considerations):

In 3.4: Option P, Dsname Level = Blank, Volume serial = volume in question. (this puts the dataset list in your TSO session 'job')

In SDSF: Option DA, your TSO session. Type SE next to your TSO userid (puts you into edit for the dataset list). [...] 7858 343 76_Re: AW: [DB2-L] AW: [DB2-L] DSNZPARM EXPLAIN+ (EXTENDED EXPLAIN GENE RATION)13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 26 Jul 2005 10:23:42 -0500446_ISO-8859-1 Yes, it is a feature of Opertune and its purpose is to modify (turn on and off) the HIDDEN DSNZPARM that controls access to, and use of, the HIDDEN EXPLAIN tables. I think the operative word here is hidden. They have not been externalized for a reason. Unless you are extremely familiar with how the DB2 optimizer works, I do not think you should bother with this hidden ZPARM and the hidden EXPLAIN tables should be left hidden. [...] 8202 55 19_Sort BP question???15_Deborah Barrett22_dbarrett@ISS.EBSCO.COM31_Tue, 26 Jul 2005 10:28:40 -0500335_- Hello listmateys, We are on v7 inclusive of PDO0514 plus hipers to mid-April.

My teammate has noticed that our sortwork bufferpool never contracts down to 0 like the other bps, even when there is nothing running, and 3rd party utilities are taken out of the picture. We are seeing this through a regular -dis bp command. [...] 8258 17 45_New Log File Mgmt/TSM ? AIX - somewhat urgent9_Barry Leb17_bjleb@HOTMAIL.COM31_Tue, 26 Jul 2005 11:57:34 -0400320_- Made a bonehead mistake. Upgraded our production system to 64 bit an hour ago, but forgot about the 64 bit TSM client. Is there any way to get DB2 to use the 64 bit client without having to bounce the database server? I really would like to avoid taking another production outage even if it's only for 5 minutes. [...] 8276 144 23_Re: Sort BP question???35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 26 Jul 2005 12:13:00 -0400473_iso-8859-1 Sort BP question???Deborah,

I don't understand what you mean by "contract". Buffer pools do not contract. They are either fully allocated, or not allocated, and they are allocated whenever any object assigned to that pool is in an open status.

Regards, Joel ----- Original Message ----- From: Deborah Barrett Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, July 26, 2005 11:28 AM Subject: [DB2-L] Sort BP question??? [...] 8421 26 64_DB2 V7 z/OS 1.6 Remote DASD Mirroring - Synchronous/Asynchronous17_No Name Available26_dmortens@NOTES.STATE.NE.US31_Tue, 26 Jul 2005 11:25:19 -0500444_US-ASCII I have some questions about mirroring z/OS 1.6 - DB2 V7 data from local to remote storage site (<3 km/1.8 mile over FICON). If cost and distance were not a factor. 1. What are the pro's and con's about using Synchronous and Asynchronous mirroring? 2. It is my understanding if you use synchronous and have a unintended disconnect with remote site you can put your DB2 databases in recovery status. Anyone know if this is correct? [...] 8448 271 47_Re: easy way to delete all datasets in a volume13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Tue, 26 Jul 2005 13:37:22 -0400493_utf-8 Thank you...It helped.

-----Original Message----- From: DB2 Data Base Discussion List on behalf of Doyle Mark Sent: Tue 7/26/2005 11:21 AM To: DB2-L@WWW.IDUGDB2-L.ORG Cc: Subject: Re: [DB2-L] easy way to delete all datasets in a volume



Here is a semi-manual way to do it (assumes you have SDSF, and other considerations):

In 3.4: Option P, Dsname Level = Blank, Volume serial = volume in question. (this puts the dataset list in your TSO session 'job') [...] 8720 49 49_Re: New Log File Mgmt/TSM ? AIX - somewhat urgent0_28_David.Stritzinger@ALTRIA.COM31_Tue, 26 Jul 2005 13:44:54 -0400522_- I have to guess that you are talking about the DSMI_DIR environment variable. Are you using TSM for the archive log USEREXIT or just for backups? If just backups, and I have not tested this so take it for what it is worth, can you put in your backup script an export command to change the DSMI_DIR to point to the 64 bit TSM api bin? I think that may work. Or something a little bit more scary... On my DB2 AIX servers, the only software that uses the TSM api backup software is DB2. Normal file system backups use [...] 8770 88 39_Re: DB2 extents causing 00C90101 errors9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Tue, 26 Jul 2005 13:38:02 -0500413_iso-8859-1 We upgraded to Z/os v.15 and had a similiar problem. DB2 would not extend to another volume. We put on APAR OA07216 and the PTF UA10536





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Ferguson, Keena Sent: Tuesday, July 26, 2005 7:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 extents causing 00C90101 errors [...] 8859 73 49_Re: New Log File Mgmt/TSM ? AIX - somewhat urgent9_Barry Leb17_bjleb@HOTMAIL.COM31_Tue, 26 Jul 2005 14:42:09 -0400631_- Too late. Had to bounce the database, but fortunately it was very quick, 10 seconds, and the app servers didn't miss a beat. Got lucky. By the way, not using USEREXIT, using TSM for log backups as part of the New Log File Management.

>From: David.Stritzinger@ALTRIA.COM >Reply-To: DB2 Database Discussion list at IDUG >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] New Log File Mgmt/TSM ? AIX - somewhat urgent >Date: Tue, 26 Jul 2005 13:44:54 -0400 > >I have to guess that you are talking about the DSMI_DIR environment >variable. Are you using TSM for the archive log USEREXIT or just [...] 8933 16 26_change server's IP address3_lan18_lxw176@HOTMAIL.COM31_Tue, 26 Jul 2005 15:30:08 -0500622_- Hi,

What's the step-by-step instuctions to change DB2 server's IP address? I have DB2 UDB 7.1 installed on AIX 5.2 machine.

Thanks! Lan

--------------------------------------------------------------------------------- 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 8950 57 19_DB2 Z/os reorg ????9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Tue, 26 Jul 2005 16:05:34 -0500429_iso-8859-1 I am trying to do a dynamic

I am testing a dynamic reorg of all the database tables within a database. The problem is that the variable &DB database has no value. I would think that the TEMPLATE BACKUP would allow the &DB variable to be valid. What I would really like to do is to have a template with a separate file for each tablespace being reorged. Has anyone been successful doing this type of thing? [...] 9008 157 23_Re: DB2 Z/os reorg ????12_Theresa Ryan27_Theresa.Ryan@HUNTINGTON.COM31_Tue, 26 Jul 2005 17:24:25 -0400470_iso-8859-1 Dee, Here is an example of how we reorg all tablespaces within a database: dbname

TEMPLATE SYSCOPY UNIT ECART RETPD 3 STACK YES DSN HLQ.&DB..&TS..D&DATE..T&TIME. DISP (NEW,KEEP,KEEP) LISTDEF REOTS INCLUDE TABLESPACES DATABASE dbname BASE REORG TABLESPACE LIST REOTS SORTDATA SORTDEVT SYSDA SORTNUM 10 SHRLEVEL CHANGE MAPPINGTABLE SYS.MAP_TABLE STATISTICS TABLE (ALL) INDEX(ALL) FASTSWITCH YES MAXRO 10 DRAIN ALL DRAIN_WAIT 5 DELAY 30 TIMEOUT TERM [...] 9166 23 23_Urgent: SMPE/E Question17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Tue, 26 Jul 2005 18:11:37 -0500575_- Esteemed Listers I am trying to install DB2 PM with a PDO delivery. The receive job (RCVPDO) abends with a B37 on SYSUT1. SYSUT1 is allocated as part of the SMP allocation procedures. I dont have rights to delete the ZONE CSI, re-define and re-start. I want to finish the install quickly without deletes. I am sure there must be a way to override SYSUT1 without re-allocating all SMP datasets. Furthermore, I dont have proper internet connection to search other than a blackberry access. How would I override SYSUT1 in the JCL on receive job? I really thank any quick [...] 9190 65 27_Re: Urgent: SMPE/E Question13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 26 Jul 2005 17:18:23 -0700434_us-ascii If it's a DDDEF, just include a //SYSUT1 DD in your JCL, it will override it. If SYSUT1 is specified in a proc, you have to override it the usual way, //procstep.SYSUT1 DD. HTH, Cathy

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Venkat Srinivasan Sent: Tuesday, July 26, 2005 4:12 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Urgent: SMPE/E Question [...] 9256 54 69_Re: DB2 V7 z/OS 1.6 Remote DASD Mirroring - Synchronous/Asynch ronous13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 27 Jul 2005 01:03:07 GMT572_- Dan:

I don't have any wisdom concerning Synchronous vs. Asynchronous, but I do have a comment you might want to think about.

Having a remote backup site less than 2 miles away probably isn't such a good idea: - What if there's a city-wide power outage, and both sites are without power for an extended period of time? One good Nebraska blizzard could do that to you. - (I know everyone in Lincoln doesn't think it will ever happen) but what if a tornado rips through the downtown area and takes out both computer centers? In both cases, your disaster [...] 9311 20 27_Re: Urgent: SMPE/E Question17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Tue, 26 Jul 2005 21:45:48 -0500709_- The DDDEFs are done. It is not a proc. The issue is in receive step. I have two cases. 1.0 Delete all SMP datasets including the CSI allocation. 2.0 Fix SYSUT1 size by over riding.

I would prefer number 2 so I dont have to spend another day.

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 [...] 9332 166 23_Re: DB2 Z/os reorg ????13_Jim Schaeffer29_jim.schaeffer@EPOSTOFFICE.COM31_Tue, 26 Jul 2005 23:57:48 -0400861_ISO-8859-1 Theresa,

Does your date string "D&DATE..T&TIME" generate a GMT date?

When I use the following:

//*------------------------------------------------------------------* //REORGSTP EXEC PGM=DSNUTILB, // COND=((4,LT,TEMPLATE),(4,LT,PREVIEW)), // PARM='DBP5,SIDPDR10' //* PARM='DBP5,SIDPDR10,RESTART' //SYSIN DD * TEMPLATE ABCDEFPDVC DSN 'ABCD&SS..&LR.&YE(4).&MO.&DA..T&HO.&MI..&DB..&TS.' BUFNO 90 RETPD 35 DATACLAS DCVTS1 UNIT(3490) STACK YES VOLCNT 99 LISTDEF ABCDEFTS INCLUDE TABLESPACE ABCDEF10.* REORG TABLESPACE LIST ABCDEFTS SHRLEVEL REFERENCE LOG NO COPYDDN(ABCDEFVC) SORTDATA NOSYSREC SORTKEYS SORTDEVT SORTWK SORTNUM 5 KEEPDICTIONARY STATISTICS TABLE INDEX UPDATE ALL KEYCARD OFFPOSLIMIT 5 INDREFLIMIT 5 //SYSPRINT DD SYSOUT=* //UTPRINT DD SYSOUT=* //*------------------------------------------------------------------* [...] 9499 219 21_Re: procedure monitor4_Peri19_peri.ncst@GMAIL.COM31_Wed, 27 Jul 2005 12:32:42 +0530590_ISO-8859-1 Yes snapshot would give the necessary information one would usually need. syntax : get snapshot for application agentid **

On 7/26/05, Dash, Sushanta wrote: > > I recalled that snapshot at instance level is available. Can any one refer > me the docs I need to look at that so that I can get a quich view of it. > > ***Thanks* > > *Sushant Dash* > > *Any comments or statements made in this email are not necessarily those > of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity > Investments group [...] 9719 17 43_UDB AIX Multiple Parallel Reorg job sought.13_Ealey, Paul M18_paul.ealey@EDS.COM31_Wed, 27 Jul 2005 09:10:10 +0100600_iso-8859-1 I'm looking for a script which can spawn multiple, parallel jobs to reorg tables/indexes.

Thanks, Paul. EDS, UK

--------------------------------------------------------------------------------- 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 9737 17 26_DB2ADMIN COMPARE Job error17_Mariusz Stakowski20_stakowskim@PROKOM.PL31_Wed, 27 Jul 2005 03:06:46 -0500363_- Hello List, I have run a compare job generated by COMPARE option of DB2ADMIN. It seems that all the tables on my list were taken into account. Hovewer the job abends with code 4038 and in SYSPRINT there is following message: Load Constraint table. primuniq_ct = 003 Does someone know where to look for he reason of this message ? Regards Mariusz Stakowski [...] 9755 45 27_Re: Urgent: SMPE/E Question11_Gugel, Rich26_Rich.Gugel@DOA.STATE.WI.US31_Wed, 27 Jul 2005 07:50:11 -0500505_- Another option is to increase the size allocated for the DD in the zone DDDEF sysut1. This is done by choosing the adiministation option(1), the the defintion option, (1 again) select the zone you want to work with, and then DDDEF option (4)

HTH Rich

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Venkat Srinivasan Sent: Tuesday, July 26, 2005 9:46 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Urgent: SMPE/E Question [...] 9801 301 23_Re: DB2 Z/os reorg ????12_Theresa Ryan27_Theresa.Ryan@HUNTINGTON.COM31_Wed, 27 Jul 2005 09:22:35 -0400560_iso-8859-1 Yes, it does generate GMT date/time.

A reorg I ran at 12:49 yesterday generated copy datasets with the following dataset names: HLQ.dbname.tsname.D2005207.T164958 Julian date and time 4 hours later than actual run time.

I do not know of a way to get actual (non GMT) time.

Sorry! Perhaps others can help with that. Theresa L. Ryan DB2 DBA - Enterprise Database Management Team Huntington National Bank 7 Easton Oval (EA3C22); Columbus, OH 43219 Phone: (614) 331-9957 Cell: (614) 402-0949 Email: Theresa.Ryan@huntington.com [...] 10103 39 24_Second dataset for SPT0116_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Wed, 27 Jul 2005 14:52:12 +0100491_- Can anybody help... I have created a second cluster for the SPT01 tablespace in one of our testing environments, the first cluster name is: vcat.DSNDBC.DSNDB01.SPT01.I0001.A001 and the second cluster is called: vcat.DSNDBC.DSNDB01.SPT01.I0001.A002.

When I attempt to bind a package and the first data set is full I get an unavailable resource message for vcat.DSNDBC.DSNDB01.SPT01.I0001.A001 I would have assumed it would have automatically switched to use the second cluster. [...] 10143 88 28_Re: Second dataset for SPT0114_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 27 Jul 2005 15:06:33 +0100444_us-ascii What reason code do you get for the bind?

You will only get a second dataset when the first exceeds 2Gb. If the first runs out of extents or runs out of freespace on it's current volume(s) before then, you will get a -904 with something like an 00D7xxxx



Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 10232 90 28_Re: Second dataset for SPT019_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 27 Jul 2005 09:11:40 -0500463_windows-1250 Post the actual message and codes. It could be that you are running out of extents on the A001 dataset which will prevent you from ever attempting to use the A002 dataset.



Mike Bell HLS Technologies -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Wallace, Stephen Sent: Wednesday, July 27, 2005 8:52 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Second dataset for SPT01 [...] 10323 262 44_DB2 v7 to v8 migration - application scripts14_David W Nobles26_David.W.Nobles@CGI-AMS.COM31_Wed, 27 Jul 2005 11:45:21 -0400376_us-ascii It is my understanding that IBM has scripts that you can run against application tables to get a heads up on potential issues that might arise after moving from v7 to v8.





I have been unable to location a point of contact and/or link to this information.





Has anyone out there heard of these or better yet, used them? [...] 10586 82 48_Re: DB2 v7 to v8 migration - application scripts0_25_LL581@DAIMLERCHRYSLER.COM31_Wed, 27 Jul 2005 11:50:51 -0400364_US-ASCII David,

I don't know about 'scripts', per se, but there are several SQL statements that can be run against your DB2 V7 Catalog to detect some unsupported objects, catalog inconsistencies, and possible migration issues. They are documented in the DB2 V8 Installation Guide. Check Chapter 8, sections 1 through 4.

Lock Lyon Compuware Corp [...] 10669 126 48_Re: DB2 v7 to v8 migration - application scripts12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Wed, 27 Jul 2005 12:01:14 -0400452_us-ascii Take a look at PQ84421/UQ85439. This adds a job DSNTIJP8 to run against V7 to check for potential problems. HTH, Jeff







David W Nobles Sent by: DB2 Data Base Discussion List 07/27/2005 11:45 AM Please respond to DB2 Database Discussion list at IDUG



To: DB2-L@WWW.IDUGDB2-L.ORG cc: Subject: [DB2-L] DB2 v7 to v8 migration - application scripts [...] 10796 24 35_Mixing 3380s and 3390s Dasd Volumes15_Gaston, Raymond17_GastonRay@ORU.COM31_Wed, 27 Jul 2005 14:24:58 -0400327_iso-8859-1 Dear Db2List:

Our V7 DB2 storage groups are define via SMS with 3380 volume packs (on the mainframe). We are moving to 3390's. Can these new 3390s be defined into the existing 3380 storage groups or do separate groups need be established. I suspect that the packs can not be mixed but I need to be sure. [...] 10821 42 39_Re: Mixing 3380s and 3390s Dasd Volumes12_Roy Cornford19_cornford@US.IBM.COM31_Wed, 27 Jul 2005 13:39:22 -0500686_- Ray,

You cannot mix device types within the same DB2 storage group.



Regards, Roy



On Wed, 27 Jul 2005 14:24:58 -0400, Gaston, Raymond wrote:

>Dear Db2List: > >Our V7 DB2 storage groups are define via SMS with 3380 volume packs (on the mainframe). We are moving to 3390's. Can these new 3390s be defined into the existing 3380 storage groups or do separate groups need be established. I suspect that the packs can not be mixed but I need to be sure. > >Thanks for your response, > >Ray Gaston >DBA/ConEd > >-------------------------------------------------------------------------- ------- >Welcome to the IDUG DB2-L [...] 10864 69 39_Re: Mixing 3380s and 3390s Dasd Volumes15_Gaston, Raymond17_GastonRay@ORU.COM31_Wed, 27 Jul 2005 14:49:11 -0400401_iso-8859-1 Thanks Roy! That's what I had suspected. I'll define a separate stogroup and start reorging the objects over that stogroup.

- Ray

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Roy Cornford Sent: Wednesday, July 27, 2005 2:39 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Mixing 3380s and 3390s Dasd Volumes [...] 10934 86 53_Runstats and REOPT(VARS) - DB2 UDB for z/OS Version 715_Moss, William R15_MossW@AETNA.COM31_Wed, 27 Jul 2005 14:50:15 -0400368_us-ascii Our environment is DB2 UDB for z/OS and OS/390 Version 7 and z/OS 1.06.

I was running the Runstats utility on all of the tablespaces in database and it was causing contention and timeouts in an application program. The package used by the program is bound with REOPT(VARS). The contention was with DSNDB06.SYSSTATS. The syntax of the runstats is: [...] 11021 71 39_Re: Mixing 3380s and 3390s Dasd Volumes9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 27 Jul 2005 14:05:34 -0500427_windows-1250 You can move DB2 datasets with DFDSS or FDR to move them from 3380 geometry to 3390 geometry. Just stop the database and use DFDSS COPY. It is much faster than reorg or recover. If you haven't used DF/DSS before, talk to your storage group.

Also there are 2 restriction on device types. One is SMS not DB2. The DB2 storage group will still specify * for vol=ser but you have to change the ACS routine. [...] 11093 94 27_Re: PUNC bit and Page Reorg20_Bruzdzinski, Michael27_Michael.Bruzdzinski@SSA.GOV31_Wed, 27 Jul 2005 15:47:33 -0400431_- As I read Willie Favero's response, I was reminded that I was supposed to be tracking down any references, especially diagrams, that depict the changes that occur on a page during updates/dletes/inserts/reorgs etc.

I used to have a set that not only had the different physical page layouts, but also had several diagrams that pictorially illustrated what bits got updated and checked while these activities occurred. [...] 11188 105 39_Re: Mixing 3380s and 3390s Dasd Volumes15_Gaston, Raymond17_GastonRay@ORU.COM31_Wed, 27 Jul 2005 15:52:13 -0400595_windows-1250 Thanks Mike... We have IBM Shark 3380/3390s (not actual 3380 / 3390 packs).

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Mike Bell Sent: Wednesday, July 27, 2005 3:06 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Mixing 3380s and 3390s Dasd Volumes



You can move DB2 datasets with DFDSS or FDR to move them from 3380 geometry to 3390 geometry. Just stop the database and use DFDSS COPY. It is much faster than reorg or recover. If you haven't used DF/DSS before, talk to your storage group. [...] 11294 15 57_Moving DB2 dataset to another disk drive (outside of DB2)13_Carlton Enuda24_CarltonEnuda@HOTMAIL.COM31_Wed, 27 Jul 2005 18:17:19 -0500681_- Hello List, I need to move a few hundred DB2 datasets(DB2P.DSNDBD.*) to a specific disk drive outsde of DB2 and was wondering if someone could kindly show me what the IDCAMS/JCL syntax would be?

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 11310 121 39_Re: Mixing 3380s and 3390s Dasd Volumes13_Richard Fazio21_rfazio@TRANSUNION.COM31_Wed, 27 Jul 2005 21:04:22 -0500470_US-ASCII Use EXTREME caution using a disk utility to move between device types.

3380's have 10 blocks per track. 3390's have 12 per track.

Test, test and test again. Run integrity checks on the data and index components. Try reorging spaces too.

If I had to do this again (and I did this about 10 years ago)...I would: Disable new allocations on the old disk Point SMS/Stogroups to new volumes Reorg all the spaces using SHRLEVEL CHANGE reorg. [...] 11432 23 23_Re: DB2 Z/os reorg ????9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 27 Jul 2005 21:26:35 -0500551_- I asked the developer and it appears you have a tablespace called REORG001 in database DSNDB04. It looks like a combination of a code bug and a user error - you should have specified

REORG TABLESPACE LIST REORG001

But, since you specified REORG TABLESPACE REORG001 it was assumed you meant DSNDB04.REORG001 but the code mistakenly did not pass the database name DSNDB04 to the code which expands the the dataset name specified in the TEMPLATE and you got the error saying &DB has no value. Please open a problem with DB2 support. [...] 11456 15 27_Re: PUNC bit and Page Reorg24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Wed, 27 Jul 2005 22:52:10 -0500552_- Hello Sir,

What is page reorg? when does that happen?



Ram

--------------------------------------------------------------------------------- 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 11472 421 48_Re: DB2 v7 to v8 migration - application scripts12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Wed, 27 Jul 2005 23:14:03 -0500454_US-ASCII David:





There are a series of SPUFIs provided as part of IBM's Path Checker product that will identify bound objects for which there are no explains. The SPUFIs will also generate the Path Checker commands that will identify which SQL will not rebind in V7 or V8 and various other items of interest. You should be able to contact a representative of the IBM Tools team to help you out in getting copies of the SPUFIs. [...] 11894 60 27_Re: Urgent: SMPE/E Question19_Michael L. McCawley20_Mike_DBA@HOTMAIL.COM31_Wed, 27 Jul 2005 23:26:36 -0500597_iso-8859-1 Vencat -

What we have here is a failure to communicate.

The DDDEFs contained in the CSI datasets describe the DDCARD definitions for RECEIVE, APPLY, and ACCEPT processing. The SYSUT1 size was specified there when the DDDEF entries were created. Those can be edited with the online SPM/E panels.

Alternately, an explicit DDCARD added to the RECEIVE JCL for the SYSUT1 dataset will override the dynamic DDCARD added by the RECEIVE process. You will need to read the output JCL from the failing job to determine the correct JOBSTEP.PROCSTEP.DDCARD specification. [...] 11955 115 39_Re: Mixing 3380s and 3390s Dasd Volumes13_Michael Ebert18_mebert@AMADEUS.NET31_Thu, 28 Jul 2005 08:43:14 +0200482_us-ascii There are still people using REORG to move datasets?? And if you've got SMS, why are you using DB2 to manage STOGROUPs?

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany





From: "Gaston, Raymond" @IDUGDB2-L.ORG on 27-07-2005 14:49 AST Please respond to DB2 Database Discussion list at IDUG Sent by: DB2 Data Base Discussion List [...] 12071 41 61_Re: Moving DB2 dataset to another disk drive (outside of DB2)14_Seth Bienstock19_SethDB2@COMCAST.NET31_Thu, 28 Jul 2005 05:15:16 -0400345_iso-8859-1 I've done this before for thousands of DB2 datasets across many hundreds of volumes from several DB2 subsystems (DS groups).

The tools I've used were a combination of FDR and SMS (DSS and HSM). I'm sure there are others, perhaps IDCAMS(?). Any of these would certainly be faster than a DB2 REORG or COPY/RECOVER scenario. [...] 12113 39 27_Re: PUNC bit and Page Reorg6_ducduc17_ndt.db2@GMAIL.COM31_Thu, 28 Jul 2005 14:38:23 +0200690_ISO-8859-1 Ramachandran, in my opinion you should read a book like "Introduction to DB2 for Z/OS" or something like that before trying to understand deeper things like PUNC bit ..etc

On 7/28/05, Ramachandran Subramanian wrote: > Hello Sir, > > What is page reorg? when does that happen? > > > Ram > > --------------------------------------------------------------------------------- > 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 [...] 12153 158 37_Re: Anyone running DB2 V5 on Z/OS 1.413_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 28 Jul 2005 08:53:50 -0400542_iso-8859-1 Hi, I found the discussion below and our situation is going to be similar for a few months. I would be interested to know if you still have V5 running on Z/OS 1.4 and had any issues.

Thanks in advance Amit





Date: Sat, 28 May 2005 10:27:11 +1000 Reply-To: DB2 Database Discussion list at IDUG <[log in to unmask]> Sender: DB2 Data Base Discussion List <[log in to unmask]> From: [log in to unmask] Subject: Re: Anyone running DB2 V5 on Z/OS 1.4 Content-type: text/plain; charset=US-ASCII Hi Julie, [...] 12312 82 61_Re: Moving DB2 dataset to another disk drive (outside of DB2)13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 28 Jul 2005 08:57:26 -0400696_iso-8859-1 Hi Carlton, This is what I have used in the past and it has worked great. I have not tested it for multivolume datasets.

Thanks Amit





//DB004T1 JOB (COPYJOB,AA),'COPY AMITX3260',CLASS=P,MSGCLASS=X, // MSGLEVEL=(1,1),REGION=6M,NOTIFY=&SYSUID //* USED TO MOVE DB2 DATASETS //COPY1 EXEC PGM=ADRDSSU,REGION=4096K,PARM='UTILMSG=YES' //SYSPRINT DD SYSOUT=* //SYSIN DD * COPY DS(INC( DSN.DSNDBC.** - )) - LOGINDYNAM((TEST03)) /* INSERT OLD VOLUME */ - OUTDYNAM((DATA20)) /* INSERT NEW VOLUME HERE */ - SPHERE /* ADD BY AMIT MOVE RELATED STU */ - TOL(ENQF) /* TOLERATE ENQ FAILURE */ - DELETE /* SCRATCH IT FROM ORIGINAL */ - ALLX /* COPY EVEN IF DS1LSTAR IS [...] 12395 92 61_Re: Moving DB2 dataset to another disk drive (outside of DB2)13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 28 Jul 2005 09:08:37 -0400370_iso-8859-1 I noticed this email after I sent you the JCL. I have to agree with Seth. I have had problems with multivolume non-DB2 datasets a couple of years back. You have to be careful. If there are only a few multivolume datasets, you could migrate it and then do a recall on a empty volume. When I am moving DB2 datasets, I have done it when DB2 is not running. [...] 12488 150 39_Re: Mixing 3380s and 3390s Dasd Volumes15_Gaston, Raymond17_GastonRay@ORU.COM31_Thu, 28 Jul 2005 09:22:38 -0400297_iso-8859-1 Thanks Faz!

I also have done this almost 10 years ago but then it was with VM and SQL/DS. I think we moved to 3340' from 3330s. We went the "reorg route" not "utility moves". I've never have done it on Z/OS 1.4 and DB2 V7.

Thanks again for the response.

- Ray [...] 12639 191 37_Re: Anyone running DB2 V5 on Z/OS 1.412_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Thu, 28 Jul 2005 08:40:25 -0500366_us-ascii Amit:

We have run V1R5 of DB2 through V1R6 of Z/OS. It is a test system used for finding defects in our software, so it is not exercised very heavily. We have run a series of tests contrasting V5, V6 and V7. There are 32 tests and 17 of them are documented on the download area of our website. We hope to add the others by the end of this year. [...] 12831 25 13_[z/OS] LUW-ID12_Cuneyt GOKSU19_cuneytgoksu@USA.NET31_Thu, 28 Jul 2005 17:26:27 +0300730_ISO-8859-1 All,

In DSNV445I message and other related DDF messages, luwid is there.

I would like to learn the details of this 3-part LUWID, for instance, GA1B00AB.GE08.BD5EF34100D9

What is the meaning of each part ?

Regards, Cuneyt

--------------------------------------------------------------------------------- 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 12857 92 17_Re: [z/OS] LUW-ID12_Ray Williams23_Ray.Williams@UNITED.COM31_Thu, 28 Jul 2005 09:36:21 -0500498_ISO-8859-1 I found this on the net . . . . Hope it helps

DB2 Tip



DSNL030I-DB2B DSNLTSEC DDF PROCESSING FAILURE FOR

LUWID=J56F045C.G422.B6D833AB804D

AUTHID=qhmcdjk, REASON=00D31050



How do I trace the TCP/IP address from this message?



J56F045C =Hex TCP/IP number.

1st byte use the following conversion

G=0, H=1, I=2, J=3, K=4, L=5, M=6, N=7, O=8, P=9

then convert to decimal

35.6F.04.5C = 53.111.4.92 [...] 12950 55 34_Crystal Enterprise edition and DB218_McAuliffe, Stephen35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Thu, 28 Jul 2005 16:10:41 +0100535_us-ascii afternoon all,

I'm after some user experience if you have a moment.

A project has come along where they are looking to use Crystal Enterprise edition to produce reports from a DB2 z/OS V8 database.

Does anyone have any experience of such a set up and how do you handle user security to the reports and hence the data in DB2? Do you have an id for the crystal server which produces the reports, and then anyone has access to those reports, or do you lock things down at the user level within Crystal? [...] 13006 19 27_Re: Urgent: SMPE/E Question17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Thu, 28 Jul 2005 11:16:58 -0500696_- Yes, Mike I did just that the other day and I was able to complete the SMP the same day. All I had to add is to add an explicit sysut1.

While looking at the apply, apply had an explicit sysut1 and I just copied the same. thanks.

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 [...] 13026 72 17_Re: [z/OS] LUW-ID17_SALVADORI Etienne17_esalvadori@GMF.FR31_Thu, 28 Jul 2005 18:26:28 +0200555_iso-8859-1 Hello, You can find a short description of the LUWID usage in le DB2LOG (mainframe at least) in the Administration guide ZOS (i.e. SC26-9931-02).

The LUW-ID consists of a fully-qualified LU network name followed by a period and an LUW instance number. The LU network name consists of a 1- to 8-character network ID, a period, and a 1- to 8-character network LU name. The LUW instance number consists of 12 hexadecimal characters that uniquely identify the unit of work (in facts id identify the thread which can be reusable......). [...] 13099 64 56_zos/db2v7 use a trigger to start a cold fusion program??0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 28 Jul 2005 09:42:15 -0700710_- Hi all, We can go from Cold Fusion to DB2 without any problem but one of our developers ask if it is possible to write a trigger that could start a Cold Fusion app.

I told him I've know idea, do any of you?

thanks, 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 13164 53 28_Load Utility & Index Rebuild0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 28 Jul 2005 12:08:11 -0500309_US-ASCII Hello, DB2 v7.1, z/OS here.

I'm trying to load a large (for us) 12 partition table, (20 million rows or so) with 13 NPI's.

I'm using every scrap of SYSDA and am still blowing up on Sort capacity exceeded.

Is there any way I can defer the index rebuild until after the Load? [...] 13218 358 32_Re: Load Utility & Index Rebuild15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Thu, 28 Jul 2005 12:28:18 -0500444_us-ascii I am no expert on this, but you could drop the indexes, do the load, redefine the indexes and recover them.





The big down-side is I believe that will make it so you have to re-bind everything that goes against that object.





Now for the vendor plug.





With BMC LOADPLUS for DB2(r), you can have LOADPLUS defer the index sorts and have it process them one at a time. [...] 13577 75 32_Re: Load Utility & Index Rebuild9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 28 Jul 2005 12:35:35 -0500530_windows-1250 Not easily - 1. drop the NPI's , then load the base table. 2. create the NPI's with DEFER 3. REBUILD each NPI one at a time.

Cost - This will pass the base table 13 times. You might try building 2 or 3 indexes in each pass.

You might also check that you are actually exceeding sort capacity. REMEMBER - SORTWK files can't go multi-volume but you can have up to 255 sort work files now (had to look at current DFSORT manual - remember that it had changes but not what to). If you have lots of SYSDA [...] 13653 221 32_Re: Load Utility & Index Rebuild14_Zobjeck, A. J.21_Allen_Zobjeck@TTX.COM31_Thu, 28 Jul 2005 12:57:52 -0500402_us-ascii Maybe brake the load into smaller pieces and use LOAD RESUME about first load is done and drop indexes so that you recovery them.





_____

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Steve_Grimes@AISMAIL.WUSTL.EDU Sent: Thursday, July 28, 2005 12:08 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Load Utility & Index Rebuild [...] 13875 353 61_Re: Moving DB2 dataset to another disk drive (outside of DB2)14_David S. Waugh16_dswaugh@LANL.GOV31_Thu, 28 Jul 2005 12:16:48 -0600848_US-ASCII I believe the ALLMULTI parameter will make sure that multi-volume datasets are moved successfully. Here's how I moved data (DB2 and non-DB2 alike) from 3380s to 3390 RAMACs several years ago:

//******************************************************************** //* MOVE DATA FROM 3380 OST005 TO NEW 3390 SYS001 //******************************************************************** //MOVEDEST EXEC PGM=ADRDSSU,COND=(4,LT) //SYSPRINT DD SYSOUT=* //INVOL1 DD VOL=SER=OST005,UNIT=3380,DISP=SHR //OUTVOL1 DD VOL=SER=SYS001,UNIT=3390,DISP=SHR //SYSIN DD * COPY DATASET(INCLUDE(**) - EXCLUDE( - SYS1.VTOC*.**, - SYS1.VVDS*.**, - )) - LOGINDDNAME(INVOL1) - ALLDATA(*) ALLEXCP - ALLMULTI - CANCELERROR - CATALOG - DELETE PURGE - OUTDDNAME(OUTVOL1) - PROCESS(SYS1,UNDEFINEDSORG) - SPHERE - TGTALLOC(SOURCE) - TOL(ENQF) - WAIT(0,0) /* [...] 14229 44 32_Re: Load Utility & Index Rebuild0_18_IWANT2BEME@AOL.COM29_Thu, 28 Jul 2005 14:19:51 EDT645_US-ASCII Are you using the parallel load feature already? This will automatically delay the rebuild phase of building the index until after the data is loaded.

Jacquie

--------------------------------------------------------------------------------- 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 14274 174 32_Re: Load Utility & Index Rebuild13_Richard Fazio21_rfazio@TRANSUNION.COM31_Thu, 28 Jul 2005 14:57:32 -0500409_US-ASCII No matter what solution you come up with, don't forget about your disaster recovery plan.

If you backup/restore tablespaces and rebuild indexes...you need the same plan of rebuilding as part of your DR plan.

----------------------

As for the load/ rebuild. Follow the formulas, do the math, work with the sort vendor/IBM to make sure that your sort allocations are correct. [...] 14449 17 38_Slow Java stored procedure WLM startup13_Waldo Tumanut52_Waldo_Tumanut/MO/americancentury@AMERICANCENTURY.COM31_Thu, 28 Jul 2005 15:34:07 -0500741_- Running DB2 7.1 and Java 1.3 with NUMTCB=8 for stored procedure WLM. I noticed that it takes about 15 seconds from the start of the address space to the first execution of a Java stored procedure. Question: how do I speed that up?

Waldo Tumanut Database Analyst

--------------------------------------------------------------------------------- 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 14467 45 31_Inline column select in DB2/zos13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Thu, 28 Jul 2005 16:48:47 -0400366_iso-8859-1 Hi list,

DB2 v7.2 z/os

I'm having trouble getting the syntax down for something I believe I should be able to do. This is a simple example which should return 2 columns (LOB, EXTRA) both with AU in them. I'm getting a syntax error: An unexpected token "LOB" was found following "". Expected tokens may include: "+ ) - ". SQLSTATE=42601 [...] 14513 93 64_Re: Inline column select in DB2/zos - Question answered, I think13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Thu, 28 Jul 2005 16:57:55 -0400708_iso-8859-1 I found a post about this from last year by Craig Mullins. Looks like this is available in V8



CREATE VIEW XSANPE.TESTVIEW(OFFID,RATING,SNIKOD,SNITEXT) AS SELECT rat.offid, rat.rating, rat.snikod, (SELECT SNINAMN FROM xsanpe.ketsni WHERE SNIKOD = rat.snikod) AS sninamn FROM xsanpe.ketrating rat

The Inline SELECT gives me the error. I don't know why.

QUESTION POSED ON: 23 SEP 2004 QUESTION ANSWERED BY: Craig Mullins The scalar fullselect is not implemented in DB2 for z/OS until Version 8. However, DB2 allows nested table expressions to satisfy the "in-line view" requirement you have. Instead of including the "in-line view" (scalar fullselect) in the column [...] 14607 144 32_Re: Load Utility & Index Rebuild13_Jim Schaeffer29_jim.schaeffer@EPOSTOFFICE.COM31_Thu, 28 Jul 2005 20:45:42 -0400633_ISO-8859-1 Steve,

You did not provide your JCL and utitity control statements. If you were using SORTDEVT ... SORTWORK xxxxxx SORTNUM xxx SORTKEYS ??????????? an under value for the SORTKEYS will result in the sort failure.

I recently had repeated failures loading a large table 148,648,98 rows (2,382,704 pages) with 3 indexes. Initially, the SORTWORK xxxxxx specified 7 volumes (3390-9). The problem Richard mentioned (65K tracks max per volume) keep me from getting more than 29,400 cyl. When I found storage group with 73 volumes, it failed again. I then upped the SORTKEYS and succeeded. This is what I used: [...] 14752 240 37_Re: Anyone running DB2 V5 on Z/OS 1.40_20_pmclaren2@CSC.COM.AU31_Fri, 29 Jul 2005 12:59:09 +1000522_US-ASCII Hi, yes, they are still out there and running several subsystems at V5 on z/OS 1.4 (with the maintenance discussed below). No issues at all. Interesting enough, this is in the E.U. also. They will be going to V7 if/when the 'upgrade red tape' has been cut.

I did subsequently receive an e-mail from someone on this list who had the same scenario and was having some problems - I am not aware of the problem details or the outcome. Unfortunately I deleted the note, so no longer have the persons name. [...]