1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2009, week 4
2 180 9_DDF again15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM31_Tue, 21 Jul 2009 18:32:28 -0600535_utf-8 Got DDF working. Issue had something to do with security. I'm neither the systems person who installed it, nor the security person, so I'm not sure what all the issues were.
Anyway, here is what I get now when I start DDF:
DSNL021I - START DDF COMMAND ACCEPTED DSNL003I - DDF IS STARTING DSNL519I - DSNLILNR TCP/IP SERVICES AVAILABLE 267 FOR DOMAIN zosd.fb AND PORT 446 DSNL004I - DDF START COMPLETE 268 LOCATION ZOSD LU -NONE GENERICLU -NONE DOMAIN zosd.fb TCPPORT 446 SECPORT 448 RESPORT 450 IPNAME ZOSDDB21 [...]
183 80 57_FW: DB2 Select problem with LIKE - What am I doing wrong?13_David Chapman24_David.Chapman@IAG.COM.AU31_Wed, 22 Jul 2009 11:36:55 +1000544_us-ascii _______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________
Hi Ed,
You are missing brackets!
Your SELECT says get me any row from SYSIBM.SYSTABLES that has a name that starts with the prefix or it is a table or view.
Change the predicates to: WHERE NAME LIKE ? AND TYPE IN ('T','V') [...]
264 26 45_Re: SDSNEXIT on the LINK list it to small ...11_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Wed, 22 Jul 2009 06:38:09 +0000400_utf-8 Hello, thanks to all for your replays. I think I'll use two-library solution recommended by James. It seems like an elegant solution that requires only minor changes in DB2 /DSNTIJUZ JCL and APF and recycling DB2 afterwards. Regards, Nenad
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
291 261 13_Re: DDF again11_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Wed, 22 Jul 2009 08:28:13 +0000405_utf-8 Hello, will try to clarify at least some of your doubts :
Our DB2 systems use table SYSIBM.IPNAMES (in combination with SYSIBM.LOCATIONS) solely for defining remote DB2 z/OS locations. I.e. for inter-DB2 TCP communication. As far as I'm aware it has nothing to do with local DDF configuration. DDF configuration problems are often related to missing/erroneous RACF/VTAM definitions .... [...]
553 88 33_upgrade db2 to 9.1 error sql0204n11_Diana Nagel16_dknagel@BEPC.COM31_Wed, 22 Jul 2009 08:31:18 -0500330_us-ascii I just finished upgrading 5 different test regions to db2 9.1 and had problems in one. I thought I had all the prep work down....although I am somewhat concerned that I missed something. The reason I say that is I went to drop an old database now...and I get this error message. I just can't get rid of old objects. [...]
642 106 37_Re: upgrade db2 to 9.1 error sql0204n10_Todd Burch17_toddburch@MAC.COM31_Wed, 22 Jul 2009 11:42:36 -0500522_WINDOWS-1252 I just searched RETAIN for this error on a DROP DATABASE and didn't find any hits. I'd suggest opening a PMR.
Todd
On Jul 22, 2009, at 8:31 AM, Diana Nagel wrote:
I just finished upgrading 5 different test regions to db2 9.1 and had problems in one. I thought I had all the prep work down….although I am somewhat concerned that I missed something. The reason I say that is I went to drop an old database now…and I get this error message. I just can’t get rid of old objects. [...]
749 37 35_Joan S Elliott is out of the office0_26_joan.s.elliott@US.HSBC.COM31_Wed, 22 Jul 2009 22:03:23 -0400582_US-ASCII I will be out of the office starting 07/22/2009 and will not return until 07/23/2009.
Please contact Victor Hedrick, Scott Holm, or Bruce Longfield
----------------------------------------- ****************************************************************** This E-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return E-mail. [...]
787 50 21_SQLCODE=395, TOKEN=2634_SUBSCRIBE DB2-L Tejas V Jadhav_IBM17_tejasvj@GMAIL.COM31_Thu, 23 Jul 2009 08:29:34 +0000308_utf-8 Hi -
Below is warning msg +395 , TOKEN = 26 , i get when i try to RE-bind. From DB2 ADMIN (when i see plan tables for below Package : LMSCCR- Ttables which are pickedup are already present in correct creators) still i get 'TABLE MISSING' token. Please can give some ideas to resolve this ? [...]
838 107 25_Re: SQLCODE=395, TOKEN=2612_Travis, John25_john.travis@CAPGEMINI.COM31_Thu, 23 Jul 2009 10:17:40 +0100599_us-ascii Tejas,
SQLCODE +395 REASON 26 :-
+395 USER SPECIFIED OPTIMIZATION HINTS ARE INVALID (REASON CODE =
reason-code). THE OPTIMIZATION HINTS ARE IGNORED.
Explanation: The optimization hints specified for this query are invalid.
Areason-code in the following table can help identify why the hints were
invalid:
reason-code Description
26 A table is missing.
You are Re-binding using an old optimization hint that references a table that no longer exists. Bind without using an optimization hint. [...]
946 145 25_Re: SQLCODE=395, TOKEN=2611_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Thu, 23 Jul 2009 09:56:29 +0000359_UTF-8 Not sure which DB2 version you are running but we stopped using many of our op hints after migration to V8 and V9 due to improved DB2 optimizer that begun to pick correct access paths by its self. OSC runstats suggestions are especially helpful....
On Thu, 23 Jul 2009 10:17:40 +0100, Travis, John wrote: [...]
1092 24 25_Re: SQLCODE=395, TOKEN=2634_SUBSCRIBE DB2-L Tejas V Jadhav_IBM17_tejasvj@GMAIL.COM31_Thu, 23 Jul 2009 10:27:21 +0000535_utf-8 I am talking about DB2 V8 for z/OS.
About v9 we are already aware about this, we'll be migrating to V9 by Nov- 2009.
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
1117 31 25_Re: SQLCODE=395, TOKEN=2634_SUBSCRIBE DB2-L Tejas V Jadhav_IBM17_tejasvj@GMAIL.COM31_Thu, 23 Jul 2009 10:31:07 +0000631_utf-8 Hi -
No. of Tables used by package are 4 and i've already mentioned they all are existing. Also , OPTHINT given the as LMSCCR (which is a package name.).
Thank You, Tejas Jadhav HSBC GLT z/DB2 DBA.
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
1149 53 25_Re: SQLCODE=395, TOKEN=2611_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Thu, 23 Jul 2009 11:20:07 +0000718_utf-8 Have you tried to rebind the package by using DSN command processor (outside Admin tool) ?
On Thu, 23 Jul 2009 10:31:07 +0000, SUBSCRIBE DB2-L Tejas V Jadhav_IBM wrote:
>Hi - > >No. of Tables used by package are 4 and i've already mentioned they all are >existing. Also , OPTHINT given the as LMSCCR (which is a package >name.). > > >Thank You, >Tejas Jadhav >HSBC GLT >z/DB2 DBA. > >_________________________________________________________ ____________ > >* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * > >_________________________________________________________ ____________ > >IDUG Europe Attendee Testimonial- >"This was definitely the best [...]
1203 20 25_Re: SQLCODE=395, TOKEN=2634_SUBSCRIBE DB2-L Tejas V Jadhav_IBM17_tejasvj@GMAIL.COM31_Thu, 23 Jul 2009 12:00:00 +0000475_utf-8 i've tried either way it's not working (in and out admin tool).
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
1224 74 25_Re: SQLCODE=395, TOKEN=2611_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Thu, 23 Jul 2009 12:59:31 +0000593_utf-8 Next thing I would do is to check if all avaialble DB2 V8 maintenance dealing with similar issues(SQLCODE395) is applied. If so, you could consider raising a PMR ....
On Thu, 23 Jul 2009 08:29:34 +0000, SUBSCRIBE DB2-L Tejas V Jadhav_IBM wrote:
>Hi - > >Below is warning msg +395 , TOKEN = 26 , i get when i try to RE-bind. From >DB2 ADMIN (when i see plan tables for below Package : LMSCCR- Ttables >which are pickedup are already present in correct creators) still i get 'TABLE >MISSING' token. Please can give some ideas to resolve this [...]
1299 52 42_Checkpoint/Restart Products for Batch Jobs13_Ricky Jackson19_rijackson@GEICO.COM31_Thu, 23 Jul 2009 12:54:25 +0000355_utf-8 We currently use the Checkpoint/Restart facility in IMS for our DB2 and IMS batch jobs. As we are gradually moving away from IMS and converting our applications to CICS and DB2, we are looking at products to replace the batch Checkpoint/Restart capabilities currently provided by IMS. We are looking at three products as possible replacements: [...]
1352 62 27_Re: [ADMIN] NOMAIL Settings17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Thu, 23 Jul 2009 16:06:25 +0100349_utf-8 Yup I tried that, don't work.
I get a digest instead, which is my OLD settings... :-)
It does mean that I only delete one email a day, of course!
Aurora Emanuela Dell'Anno CA Sr Engineering Services Architect Tel: Â Â Â Â +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com [...]
1415 130 61_Modifying DSNWZP to run in a WLM-managed stored address space14_Renzo razzetti24_renzo.razzetti@GMAIL.COM31_Thu, 23 Jul 2009 14:57:20 -0300522_ISO-8859-1 Hello
Actually my customer is in DB2 V7. And he has defined the DSNWZP as follow
CREATE PROCEDURE SYSPROC.DSNWZP (OUT P10 VARCHAR(32000) FOR SBCS DATA CCSID EBCDIC ) EXTERNAL NAME 'DSNWZP' LANGUAGE ASSEMBLE PARAMETER STYLE GENERAL NOT DETERMINISTIC FENCED CALLED ON NULL INPUT MODIFIES SQL DATA NO DBINFO COLLID DSNWZP NO WLM ENVIRONMENT ASUTIME NO LIMIT STAY RESIDENT NO PROGRAM TYPE MAIN SECURITY DB2 INHERIT SPECIAL REGISTERS RUN OPTIONS 'TRAP(ON),TERMTHDAC(UADUMP)' COMMIT ON RETURN NO ; [...]
1546 46 53_db2 udb luw 9.1 - Migrate & REORG syscatspace tables?13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Thu, 23 Jul 2009 19:52:25 +0000387_utf-8 I am currently in the planning stage of a migration from db2 v8.2 to v9.1, and I am looking into my options for a REORG of the DB2 catalog tables as part of the migration plan. I'm an old z/os guy and not yet very familair with UDB
We do not have a process in place to REORG the db2 catalog tables, and I would appreciate input / references on the following questions: [...]
1593 53 55_[DB2 z/OS] Using IBM automation tool to drive utilities14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Thu, 23 Jul 2009 15:52:27 -0400399_us-ascii Dear esteemed list,
We're moving into real-time statistics, as well as implementation of automation to selectively execute utilities, especially COPY.
As I understand the process, the IBM automation tool and/or assorted stored procedures can generate the appropriate INCLUDE and/or LISTDEF statements based on criteria provided (DB and TS profile, utility profile, etc.) [...]
1647 101 59_Re: [DB2 z/OS] Using IBM automation tool to drive utilities14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 23 Jul 2009 16:10:27 -0400400_us-ascii Lock,
Are you talking about the IBM DB2 Automation Tool product? It builds the utilities, too, not just the LISTDEFs. I believe I recall that it controls the execution as well, if needed.
I'll note that I did not find it particularly easy to use, but that is probably from the product's complexity (which is necessary to provide the flexibility that the market requires). [...]
1749 89 65_Re: Modifying DSNWZP to run in a WLM-managed stored address space9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 23 Jul 2009 15:47:31 -0500503_iso-8859-1 Only thing I can think of is that DSNTIJSG is sort of optional. IE sample tables, lots of stored procedures for admin tool and stuff. I always run it but there may be shops that don't.
Mike HLS Technologies
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Renzo razzetti Sent: Thursday, July 23, 2009 12:57 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Modifying DSNWZP to run in a WLM-managed stored address space [...]
1839 38 57_Re: db2 udb luw 9.1 - Migrate & REORG syscatspace tables?12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Thu, 23 Jul 2009 22:49:32 +0000379_- 1) Yes and on a regular basis 2) 1 stmt per table or do all with reorgchk or use the reorg sp 3)No
Hth pg ------Original Message------ From: Jack Campbell Sender: DB2 Data Base Discussion List To: DB2-L@WWW.IDUGDB2-L.ORG ReplyTo: DB2 Database Discussion list at IDUG Subject: [DB2-L] db2 udb luw 9.1 - Migrate & REORG syscatspace tables? Sent: Jul 23, 2009 2:52 PM [...]
1878 118 30_Indexability of UCASE Function0_26_barbara.j.nigh@US.HSBC.COM31_Thu, 23 Jul 2009 19:20:24 -0400488_US-ASCII For DB2 z/OS, is it possible for DB2 to use an index on a column that is being used by the UCASE function such as the example below:
WHERE UCASE(COLUMNA) LIKE '30008692%' ORDER BY COLUMNA FOR FETCH ONLY
In other words, would an index on COLUMNA help the query at all...
Barbara J Nigh CONSULTANT DATABASE MGMT | HSBC Technology Services (HTS) 1441 Schilling Place Salinas, CA 93901 ______________________________________________________ [...]
1997 28 57_Re: db2 udb luw 9.1 - Migrate & REORG syscatspace tables?13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Fri, 24 Jul 2009 00:28:13 +0000654_utf-8 Phil
thanks for the quick response......will plan on REORG during migration (and aim to add regular reorg's later)
Regards
Jack
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- “The main reason for my attendance at IDUG - Europe was general training and rekindling enthusiasm. I took away more knowledge and enthusiasm – IDUG did the job!" _____________________________________________________________________
2026 44 34_Re: Indexability of UCASE Function13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Fri, 24 Jul 2009 00:37:16 +0000307_utf-8 Barabara
It depends on what version of DB2 z/os you are running
db2 z/os v 8 - no can't index the query as there is no column which contains the upper case value of "columnA"
db2 z/os v9 - allows for indexing of an expression - so you could create an index on ucase(columnA) [...]
2071 24 57_Re: db2 udb luw 9.1 - Migrate & REORG syscatspace tables?16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU31_Fri, 24 Jul 2009 08:55:10 +0800334_utf-8 Just wondering if there is a particular reason you are only migrating to 9.1, rather than 9.5? V9.5 has been out for quite a while, and even 9.7 went GA a month or so ago - although that might be a little too bleeding-edge yet.
We did an 8.2 -> 9.5 migration a few months ago, very smooth and well worth the effort. [...]
2096 85 65_Re: Modifying DSNWZP to run in a WLM-managed stored address space11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Fri, 24 Jul 2009 06:44:32 +0000632_UTF-8 If you don't convert DSNWZP nothing would happen except it probably won't work on V8. But you can always recreate it at anytime before or after migration ....
On Thu, 23 Jul 2009 14:57:20 -0300, Renzo razzetti wrote:
>Hello > >Actually my customer is in DB2 V7. And he has defined the DSNWZP as follow > >CREATE PROCEDURE SYSPROC.DSNWZP > (OUT P10 VARCHAR(32000) FOR SBCS DATA CCSID EBCDIC ) > EXTERNAL NAME 'DSNWZP' > LANGUAGE ASSEMBLE PARAMETER STYLE GENERAL NOT DETERMINISTIC > FENCED CALLED ON NULL INPUT MODIFIES SQL DATA NO DBINFO > COLLID DSNWZP NO WLM ENVIRONMENT ASUTIME [...]
2182 285 65_Re: Modifying DSNWZP to run in a WLM-managed stored address space11_Mike Turner19_mike.turner@GMX.COM31_Fri, 24 Jul 2009 11:19:08 +0100580_iso-8859-1 Hi Renzo
I think the MUST is an overstatement. If you run the DSNTIJSG the drop and recreate will sort the problem. However, if you do not run DSNTIJSG, then you must convert to WLM before migrating. Version 7 allows you to create DSNWZP as WLM-controlled, but you have to use a different module name (DSNWZPR) and specify the WLM environment. The DSNTIJNF job ALTERs this module name back to DSNWZP, which is the correct name for V8. Note that the ALTER assumes that the procedure is already WLM-controlled because it does not specify the WLM environment. [...]
2468 31 28_DB2 z/OS Tablespace Recovery3_Ray23_ray.williams@UNITED.COM31_Fri, 24 Jul 2009 13:07:29 +0000403_utf-8 this seems like a very basic question but . . . .
We need to ensure that all of our tables have been recovered using RECOVER TABLSPACE . I thought I would just look in SYSCOPY and see a value in ICTYPE but there isn't one for non point in time reocoveries . . . only for Point in Time Recoveries (ICTYPE=P). Where can I find that a non point in time RECOVERY was performed ? [...]
2500 38 32_Re: DB2 z/OS Tablespace Recovery13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 24 Jul 2009 15:26:06 +0200422_utf-8 Ray,
Interesting question, identifying 'to current' recoveries, but not directly related to the 'did we recover all the TSs in our DB' point. Whatever; that's down to some clever SQL joining Syscopy rows with the entries in Systablepart for the given DB.
With DB2 9 there's a new ICTYPE of E that is for recoveries 'to current'. But to be honest I don't know how you'd verify that prior to DB2 9. [...]
2539 35 32_Re: DB2 z/OS Tablespace Recovery3_Ray23_ray.williams@UNITED.COM31_Fri, 24 Jul 2009 14:04:41 +0000515_utf-8 Raymond, thanks for the reply. I've been doing DB2 since 1.3 and this is the first time I've had to answer this question. It seemed like there should be a short answer using SYSCOPY, which you have pointed out that V9 finally has it. Anyway - yes we need to verify that all DBs were recovered at our Business Resumption Site. We have another technique, not as straightforward as SQL, that will look at the create date from the cluster and compare it to the date we recover at the Disaster Recovery site. [...]
2575 521 34_Re: Indexability of UCASE Function15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Fri, 24 Jul 2009 10:22:30 -0400292_us-ascii Hi Barbara,
With DB2 V8 you are out of luck. However, with DB2 9 for z/OS you can create an index using an expression. Are you up on DB2 9 yet?
Just a note, your example below does not make sense. Why are you trying to UCASE on a string that contains all numbers? [...]
3097 593 34_Re: Indexability of UCASE Function15_Gaston, Raymond17_GastonRay@ORU.COM31_Fri, 24 Jul 2009 11:00:31 -0400552_us-ascii Troy ... I think the wildcard character "%" may turn out to represent non-numeric characters.
- Ray Gaston
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Coleman, Troy L Sent: Friday, July 24, 2009 10:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Indexability of UCASE Function
Hi Barbara,
With DB2 V8 you are out of luck. However, with DB2 9 for z/OS you can create an index using an expression. Are you up on DB2 9 yet? [...]
3691 383 34_Re: Indexability of UCASE Function14_Steurs Patrick21_Patrick.Steurs@NBB.BE31_Fri, 24 Jul 2009 17:06:05 +0200690_us-ascii Does not make sense.
Patrick Steurs
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gaston, Raymond Sent: vrijdag 24 juli 2009 17:01 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Indexability of UCASE Function
Troy ... I think the wildcard character "%" may turn out to represent non-numeric characters.
- Ray Gaston
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Coleman, Troy L Sent: Friday, July 24, 2009 10:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Indexability of UCASE Function [...]
4075 37 57_Re: db2 udb luw 9.1 - Migrate & REORG syscatspace tables?13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Fri, 24 Jul 2009 15:55:50 +0000433_utf-8 I tried some test REORG's on SYSIBM.SYSTABLES on my current db2 v8.2 system - my offline reorg works fine, however my inplace fails with the following error.....
reorg table SYSIBM.SYSTABLES inplace allow write access
SQL0270N Function not supported (Reason code = "54"). SQLSTATE=42997
*the only limitations on inplace reorg appear to be no type1 indexes, and no extended indexes (whatever that is)? [...]
4113 33 57_Re: db2 udb luw 9.1 - Migrate & REORG syscatspace tables?13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Fri, 24 Jul 2009 15:57:41 +0000476_utf-8 Greg,
we are migrating to v9.1 to sync-up the versions across mutliple servers, so we can have a single maintenance level.....
there are other pieces of software in the mix, and I want to get to one single "version image" and then move forward to db2 9.5 (or 9.7) from there
Regards
Jack
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
4147 653 34_Re: Indexability of UCASE Function12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 24 Jul 2009 19:04:23 +0300553_UTF-8 Hi,
A work-around for V8 is to add another column to the table, and fill it with UCASE(columna) on Insert/Update (can be done by a Before Trigger) and have an index defined on it.
However – it adds some complexity and some overhead and regular LOAD does not fire triggers.
Isaac Yassin
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Coleman, Troy L Sent: Friday, July 24, 2009 5:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Indexability of UCASE Function [...]
4801 53 11_DRDA trace?15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM31_Fri, 24 Jul 2009 10:50:29 -0600305_us-ascii Is there a way to do a formatted trace of the DRDA TCP/IP dataflow? We can do a TCP/IP trace, and this gives us formatted TCP/IP information, but the "payload" which contains the DRDA information is unformatted. I can muddle my way through it, but to have it formatted would be even better. [...]
4855 118 59_Re: [DB2 z/OS] Using IBM automation tool to drive utilities16_Mark Labby - AES21_mlabby@AESSUCCESS.ORG31_Fri, 24 Jul 2009 14:16:55 -0400
4974 36 38_Kuhr, Richard L. is out of the office.0_13_RLKUHR@UP.COM31_Fri, 24 Jul 2009 20:46:29 -0500636_US-ASCII I will be out of the office starting 07/24/2009 and will not return until 08/03/2009.
I will respond to your message when I return. If this is an emergency please contact Computer Scheduling.
**
This message and any attachments contain information from Union Pacific which may be confidential and/or privileged. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited by law. If you receive this message in error, please contact the sender immediately and delete the message and any attachments. [...]
5011 56 73_AUTO: Andrew Butcher/HAV/SSE is out of the office. (returning 03/08/2009)0_38_Andrew.Butcher@SCOTTISH-SOUTHERN.CO.UK31_Sat, 25 Jul 2009 04:00:20 +0100387_us-ascii I am out of the office until 03/08/2009.
I will respond to your message when I return. In the meantime, if it is important then please forward your Email to my colleague Steve Spurgin or contact him on Ext. 44988.
Note: This is an automated response to your message "DB2-L Digest - 24 Jul 2009 to 25 Jul 2009 (#2009-216)" sent on 25/07/2009 02:00:01. [...]
5068 47 45_Mike Dupuis/Ontario/IBM is out of the office.11_Mike Dupuis18_mdupuis@CA.IBM.COM31_Sat, 25 Jul 2009 04:09:41 -0400304_US-ASCII
I will be out of the office starting 07/24/2009 and will not return until 08/04/2009.
I will respond to your message when I return. If this is an urgent matter please call the Heldesk and ask that an IGS DB2 support person be paged. For less urgent matters pls email SLCDB2. [...]
5116 71 32_Re: DB2 z/OS Tablespace Recovery0_22_DB2information@AOL.COM29_Sat, 25 Jul 2009 07:51:28 EDT318_US-ASCII Ray, The GENDB2 software product give you an option to create a record that will show the type of recovery Forward, TOCOPY, TORBA with RBA number, Timestamp, and user who submitted the recovery job. Nice to have but do not tell the EDP Auditors because they would have a field day with that information. [...]
5188 64 45_Locking question - z/OS V8 compatability mode9_Ken Paris20_kenparis17@GMAIL.COM31_Sat, 25 Jul 2009 14:03:57 +0000336_UTF-8 We are running in z/OS V8 compatability mode.
We have an email table in the database - when you want to send an email, you add a new row (table uses row level locks).
We have a started task which runs once a minute - it is java code which calls a sql stored procedure which looks for unsent rows in this table. [...]
5253 276 36_Online Reorg limitations DB2 9.1 LUW12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Sat, 25 Jul 2009 12:16:40 -0400705_us-ascii Jack, these cannot be done with online reorg:
SYSIBM.SYSTABLES, SYSIBM.SYSSEQUENCES, SYSIBM.SYSDBAUTH, SYSIBM.SYSROUTINEAUTH
Also there are a few other limitations like MDC, tables in append mode, tables with LOB/CLOBs, etc.
Phil
Phil Gunning
IBM Data Champion
www.gunningts.com
Twitter:@db2luw
See us at IDUG Europe, 5-9 Oct, 2009 Rome, Italy
Database Industry Analyst
DB2 Consulting, Books on DB2, Outsourcing, Education, Remote Support
http://it.toolbox.com/blogs/db2-for-luw
DB2 9.7 Early Access Program -- [...]
5530 280 29_DB2 9.1 LUW REORG Limitations12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Sat, 25 Jul 2009 12:18:28 -0400721_us-ascii Jack, these cannot be done with online reorg:
SYSIBM.SYSTABLES, SYSIBM.SYSSEQUENCES, SYSIBM.SYSDBAUTH, SYSIBM.SYSROUTINEAUTH
Also there are a few other limitations like MDC, tables in append mode, tables with LOB/CLOBs, etc.
Phil
Phil Gunning
IBM Data Champion
www.gunningts.com
Twitter:@db2luw
See us at IDUG Europe, 5-9 Oct, 2009 Rome, Italy
Database Industry Analyst
DB2 Consulting, Books on DB2, Outsourcing, Education, Remote Support
http://it.toolbox.com/blogs/db2-for-luw
DB2 9.7 Early Access Program -- [...]
5811 80 73_AUTO: Ashvin Amin/Dallas/IBM is out of the office. (returning 07/27/2009)11_Ashvin Amin17_ashvin@US.IBM.COM31_Sat, 25 Jul 2009 22:03:09 -0600479_US-ASCII
I am out of the office until 07/27/2009.
I will be out of the office on Vacation until July 27. I will repsond to your messages upon my return.
If you need immediate assistance, please contact Jack Mason at .... masonja@us.ibm.com or my manager, Maureen Kinard at ...mkinard@us.ibm.com
Note: This is an automated response to your message "DB2-L Digest - 25 Jul 2009 to 26 Jul 2009 (#2009-217)" sent on 7/25/09 19:00:03. [...]
5892 80 49_Re: Locking question - z/OS V8 compatability mode14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 26 Jul 2009 22:12:47 +1000349_US-ASCII Something must be wrong-ish for the SP, with a SELECT ... WITH CS/RS/RR, to read an uncommitted row. Are you certain that something isn't changing it to UR?
No, (pre V9) DB2 will not ignore uncommited rows. It will either - read the row if WITH UR is specified - wait for the insert (in the case) to be COMMITed or ROLLed BACK. [...]
5973 12 57_SV: [DB2-L] Locking question - z/OS V8 compatability mode13_Hanne Lyssand20_Hanne.Lyssand@VPS.NO31_Mon, 27 Jul 2009 10:34:51 +020065_utf-8 There is a zparm: SKIPUNCI NO/YES
Best regards Hanne
5986 28 44_Paul P Packham/GIS/CSC is out of the office.14_Paul P Packham16_ppackham@CSC.COM31_Mon, 27 Jul 2009 10:06:05 +0100356_US-ASCII I will be out of the office starting 27/07/2009 and will not return until 03/08/2009.
I'm on Leave, returning 3rd August. For urgent queries please contact Mick Graley on +44(0)1246214871, otherwise I will respond when I return. For a Union query please contact Colin W Walker or any of the other reps. Colin's number is 01246 21 4699 [...]
6015 89 49_Re: Locking question - z/OS V8 compatability mode14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Mon, 27 Jul 2009 09:23:47 -0400556_us-ascii Ken,
Call me crazy (pause for hysterical laughter), but this doesn't make sense. The Isolation Level should strictly control what you can access with SQL; using WITH CS or WITH RR should make it impossible to read data that is not committed.
So, based on the info in your e-mail, I'd say that the "another program ... adding rows" is doing Commits, either explicitly or implicitly. Is this application a distributed app? Does it connect using a driver with AUTOCOMMIT set on? Does it INSERT a row, then Commit, then do UPDATEs? [...]
6105 60 50_Duplicates in Unique index: v8 (NFM);z/os 1.7; MVS12_Mary Parsons27_dmsdb2_worthing@YAHOO.CO.UK31_Mon, 27 Jul 2009 13:47:57 +0000572_utf-8 Hi all
Any one else had this problem?
We have a table with 150 million rows in a segmented tablespace with one unique clustering index. The table was last reorgd Nov 2008 and is regularly processed with inserts and updates via a COBOL program with a Plan.
We have just started to look at partitioning this table, and found that the unloaded data has 4 million more rows than the index. We can trace this back to a run in April where the job outlist shows 6 million rows added, but the index runstats show 2million. The syslog confirms that [...]
6166 60 54_Re: Duplicates in Unique index: v8 (NFM);z/os 1.7; MVS15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Mon, 27 Jul 2009 09:58:29 -0400546_utf-8 I've run into this when loads are used. I was at one customer site that had operations try to run the load after it had failed. They ran the load multiple times then finally called the DBA's for help.
I'm thinking your best option at this point is to unload the data, sort out the duplicates then reload. I would load the duplicates into another temporary table so you can query it to get an idea if you need to update the current rows with data from the duplicate rows. Do you have a create timestamp and last update timestamp [...]
6227 22 54_Re: Duplicates in Unique index: v8 (NFM);z/os 1.7; MVS12_Mary Parsons27_dmsdb2_worthing@YAHOO.CO.UK31_Mon, 27 Jul 2009 14:10:20 +0000696_utf-8 Thanks, Troy. We do have an update date for each run, so will use that to get it sorted. Odd thing is that this problem has come from COBOL.
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "I had my first experience with certifications (and passed)! I learned a lot about DB2 version 9 (LUW) that hopefully will enable me to convince management a timely migration will be of benefit for the business." _____________________________________________________________________
6250 39 54_Re: Duplicates in Unique index: v8 (NFM);z/os 1.7; MVS15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Mon, 27 Jul 2009 10:25:26 -0400418_utf-8 Are you sure you have not run some loads.. I guess if you look at the dates for the duplicates you can see when it occurred. I would really be surprised if it was really from the COBOL program. If that is the case you will need to open a PMR with IBM. But first do your home work and check the dates on the duplicates and see if you had any utilities running around that time that may have had some issues. [...]
6290 88 54_Re: Duplicates in Unique index: v8 (NFM);z/os 1.7; MVS9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 27 Jul 2009 09:55:42 -0500354_US-ASCII You might also look at the datasets for the index - I think I remember some issues with creating a new dataset and then forgetting that it exists. That is the only scenario I can think of for normal COBOL processing and loosing index records. I strongly suggest opening a PMR with IBM Even though you may not be able to recreate the issue. [...]
6379 36 49_Re: Locking question - z/OS V8 compatability mode13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Mon, 27 Jul 2009 16:25:40 +0000439_utf-8 Ken,
what SQL are you running to select/update the row, what are the WHERE predicates. It could be that the WHERE predicate is qualifying the rows inserted (but not yet committed).....so your select waits for the commit....
One option might be to add and insert-timestamp column. Then only select rows where insert_timestamp < current time? so anything added after the time you start your select will be ignored?? [...]
6416 83 15_db2 v9 redbooks8_duam lee20_duam_lee@HOTMAIL.COM31_Mon, 27 Jul 2009 19:00:33 +0000588_ks_c_5601-1987
Greetings,
Can any one point me to the latest improvement for DPSI in V9. I am looking at the IBM site and not getting a redbook site for V9. I am getting more on V8 than V9. Please provide me the links you have.
I heard that with V9 the latest development has come like if I have DPSI earlier like C2,c3,c4 and c5 and partitioned index is on c1 the program's access path through DPSI c2,c3,c4 has to scan thorugh all the partitions. We have to supply the vales of c1 for the queries to scan the limited partition [...]
6500 234 35_[JOB] Optim Opportunity in Montreal12_Kimberly May28_kim.may@THEFILLMOREGROUP.COM31_Mon, 27 Jul 2009 16:17:47 -0400362_us-ascii I am searching for someone with legacy Princeton Softech skills to support a data masking project in Montreal. I need someone *local* to Montreal who is comfortable leading a consulting and implementation effort AND who speaks both French and English. If you are interested and qualified please contact me off-list at kim.may@thefillmoregroup.com. [...]
6735 60 26_DB2 for z/OS V9 - 00C5010313_Irwin Deutsch28_ideutsch@PRINCESSCRUISES.COM31_Mon, 27 Jul 2009 15:48:14 -0700472_US-ASCII Hi,
I get a 00C50103 error on our DR system, when SPUFI tries to connect with DB2 V9, that 'looks like' it came up ok. Also CICS can't connect; it thinks DB2 is not active. Some things work, like database display commands.
Any ideas will be much appreciated!
Thanks,
Irwin
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
6796 27 21_Database Cleanup List25_SUBSCRIBE DB2-L Anonymous17_mairecj@YAHOO.COM31_Mon, 27 Jul 2009 22:53:35 +0000316_utf-8 I need to drop an obsolete database in a Version 8 database. Anyone have a checklist of items easy to overlook? Does a DROP DATABASE clean up all components in a cascade fashion - tablespaces, indexes, views, stats - or does each component have to be removed explicitly and separately? Thanks in advance! [...]
6824 62 30_Re: DB2 for z/OS V9 - 00C501039_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 27 Jul 2009 18:26:52 -0500416_US-ASCII DSN requires specific authorization in parmlib - sounds like it doesn't have it on your DR system Could be any number of things library name, logon proc, vol=ser=
My guess would be something related to RUN PROGRAM
I would start by trying to run a sample DSNTIAD with just set current sqlid = If it fails, it is easier to diagnose - if it suceeds, then most likely a tso logon proc issue. [...]
6887 65 25_Re: Database Cleanup List13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Mon, 27 Jul 2009 21:14:12 -0400601_UTF-8 Hello ,
What is your platform? Guessing from some of your prior anonymous posts, I'd say z/OS.
Do you have a DBA tool?
If you DBA XPERT for DB2 from Compuware or a competitor product, you can generate a list of tasks that will be executed to accomplish the DROP DATABASE. This allows you to review the list and take action where appropriate. If you don't you can get some of that information querying SYSPLANDEP, SYSPACKDEP, and if you're a glutton for punishment, parsing SYSSTMT, SYSPACKSTMT, and SYSVIEWS. It's a big job and that's why products are built to provide [...]
6953 108 25_Re: Database Cleanup List0_17_jtonchick@AOL.COM31_Mon, 27 Jul 2009 22:36:28 -0400443_us-ascii Yes, the DROP DATABASE does remove all objects under it, but doing it in one command can cause another problem.? Due to the relationships to other objects like SYSCOPY, SYSSTATS, SYSHIST the volume of locks needed could exceed your locking capability.? For this reason, I suggest that you DROP objects in reverse order , from the bottom up.? Group several DROP statements (5 - 10) then add a COMMIT.? End with the DROP DATABASE. [...]
7062 145 19_Re: db2 v9 redbooks16_Robert Catterall21_rfcatterall@GMAIL.COM31_Mon, 27 Jul 2009 23:46:24 -0400407_ISO-8859-1 The DPSI-related enhancements to which you refer are described in the IBM red book titled "DB2 9 for z/OS Performance Topics" (see section 2.4, "Optimization for a complex query"). Here's a link to the document:
http://www.redbooks.ibm.com/abstracts/sg247473.html?Open
You might also want to check out the "DB2 9 for z/OS Technical Overview" red book. The url for that one is: [...]
7208 26 54_Re: Duplicates in Unique index: v8 (NFM);z/os 1.7; MVS12_Mary Parsons27_dmsdb2_worthing@YAHOO.CO.UK31_Tue, 28 Jul 2009 07:46:18 +0000592_UTF-8 Troy/Mike
Thanks for your good suggestions. We'll continue to dig through the syslog & see what else we can find.
Mary
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "The clear and high level technical information of some of the sessions makes the conference a value for the money." _____________________________________________________________________
7235 30 25_Re: Database Cleanup List16_mocion@libero.it16_mocion@LIBERO.IT31_Tue, 28 Jul 2009 10:47:23 +0200401_ISO-8859-1 A cleanup of all SYSCOPY records (ICs) via MODIFY should be done as well before any tablespace DROP (it seems to me nothing changed in DB2 last version for this issue). Assuming you're in z/OS.
Anyway it's better to build the structure of that DB and dropping object from lower level to higher. Consider some plan/packages could include different tables in different databases. [...]
7266 44 25_Re: Database Cleanup List14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 28 Jul 2009 21:05:55 +1000598_US-ASCII One other thing, to add the other suggestions: Use IDCAMS to delete the VSAM objects before dropping the indexes and tablespaces.
The SQL DROPs run a lot, lot faster
James Campbell
On 27 Jul 2009 at 22:53, SUBSCRIBE DB2-L Anonymous wrote:
> I need to drop an obsolete database in a Version 8 database. Anyone have > a checklist of items easy to overlook? Does a DROP DATABASE clean up > all components in a cascade fashion - tablespaces, indexes, views, stats - or > does each component have to be removed explicitly and separately? > Thanks in advance! > [...]
7311 78 54_Re: Duplicates in Unique index: v8 (NFM);z/os 1.7; MVS14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 28 Jul 2009 21:05:55 +1000548_US-ASCII And, let me guess, you are wondering how you can get rid [**] of those pesky duplicates. Somewhat easy with James' un-patented method:
1) add a row-id column to the table. Unlike every other type of added column a row-id will give a unique value for every row - which is actually generated as the row is read and maps to a different set of values from row- ids generated when a row is inserted. 2) you can now identify duplicates with SQL like: SELECT ... FROM TAB TA WHERE EXISTS (SELECT 1 FROM TAB TB WHERE keys.TA = keys.TB [...]
7390 45 53_Re: *****SPAM***** [DB2-L] DB2 for z/OS V9 - 00C5010314_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 28 Jul 2009 21:05:55 +1000550_US-ASCII Not easy to work through, but you have run a DSN trace, haven't you?
//DSNTRACE DD SYSOUT=* details documented in Diagnosis Guide and Reference
James Campbell
On 27 Jul 2009 at 15:48, Irwin Deutsch wrote:
> > > Hi, > > I get a 00C50103 error on our DR system, when SPUFI tries to connect with DB2 V9, that 'looks > like' it came up ok. Also CICS can't connect; it thinks DB2 is not active. Some things work, like > database display commands. > > Any ideas will be much appreciated! > > > Thanks, > > Irwin > [...]
7436 72 17_Code page dilemma11_Vasko Tomas23_tomas.vasko@GENERALI.AT31_Tue, 28 Jul 2009 14:12:54 +0000620_utf-8 Hello Listers,
we have a 20 year old mainframe application (using CICS and DB2, written in PL1) that uses WMA 3270 terminal emulation. Our DSNZPARM EBCDIC code page setting is 273 - germany. As long as the emulation terminal conversion file is set to 'germany', the application runs fine.
Though we're having troubles now: A clone of this application is used by our eastern european colleagues, and they are using the same DB2 as we do, with the same code page setting. For displaying their latin2 letters, they use the terminal conversion file 'isolt2'. With this setting, they generate EBCDIC [...]
7509 72 25_Re: Database Cleanup List17_Janes, Ray {PBSG}18_ray.janes@PBSG.COM31_Tue, 28 Jul 2009 09:55:28 -0500530_us-ascii Consider issuing a -sto db (name) space(allspaces) and also a -sto db(name). Let that sit for some period of time. Week, month, quarter. That way some dynamic SQL or some other application that happens to use it, will be found. Remember to also clean up all test environments. Ray
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of James Campbell Sent: Tuesday, July 28, 2009 6:06 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Database Cleanup List [...]
7582 70 21_Re: Code page dilemma13_Mertens, Bart18_bart.mertens@CZ.NL31_Tue, 28 Jul 2009 16:49:04 +0200723_utf-8 Hi Vasco,
How's UCS set up? -> /d uni, all
And sysstrings? SELECT inccsid, outccsid FROM sysibm.sysstrings where inccsid in (273,870)
Kind regards, Bart Mertens
-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Vasko Tomas Verzonden: dinsdag 28 juli 2009 16:13 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: [DB2-L] Code page dilemma
Hello Listers,
we have a 20 year old mainframe application (using CICS and DB2, written in PL1) that uses WMA 3270 terminal emulation. Our DSNZPARM EBCDIC code page setting is 273 - germany. As long as the emulation terminal conversion file is set to 'germany', the application runs fine. [...]
7653 32 20_CA DB2 Utilities r1216_Mark Labby - AES21_mlabby@AESSUCCESS.ORG31_Tue, 28 Jul 2009 11:48:18 -0400
7686 207 25_Re: Database Cleanup List14_Wayne Driscoll18_wdrisco@US.IBM.COM31_Tue, 28 Jul 2009 11:13:51 -0500462_US-ASCII One drawback to this approach is that when you let DB2 delete the VSAM clusters, the actual deletes don't get processed until COMMIT processing. If the UOW fails 2/3's of the way into it, and you deleted the VSAM clusters the DB2 catalog definitions will point to the objects, but the real data will be gone. If you try this option, you will want to make sure that nothing will impeded the drops, such as a table with RESTRICT ON DROP or the like. [...]
7894 26 21_Re: Code page dilemma11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 28 Jul 2009 16:37:08 +0000595_- >How's UCS set up? -> /d uni, all
It's actually: /d uni,all
No space after the ','
- Too busy driving to stop for gas!
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "The clear and high level technical information of some of the sessions makes the conference a value for the money." _____________________________________________________________________
7921 38 25_Re: Database Cleanup List13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Tue, 28 Jul 2009 17:13:17 +0000375_utf-8 You will also need to review UTILITIES......copy, reorg, load....etc. And any automation you may have added for the utilities using OEM toolsets.
I prefer the option of issuing a STOP on all the affected tablespaces, and leaving to "settle" for some period. That way if you miss some critical application, you can easily jut start the tablespaces again.... [...]
7960 54 53_Re: *****SPAM***** [DB2-L] DB2 for z/OS V9 - 00C5010313_Irwin Deutsch28_ideutsch@PRINCESSCRUISES.COM31_Tue, 28 Jul 2009 10:49:40 -0700330_US-ASCII Thanks for the responses here. Problem solved. The DB2 subsystem definitions were 'too high' in the list, which probably means it preceded JES2. Once we changed the order of the two SSN members DB2 worked like a charm. Googling '00C50103' I came up with an old listserv discussion (for V5), which led to the answer. [...]
8015 92 25_Re: Database Cleanup List14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 29 Jul 2009 08:18:29 +1000336_US-ASCII Sorry, I don't see what the problem is.
It doesn't need the DROP to fail, for whatever reason - the catalog definitions are pointing to clusters (objects) that don't exist even before the DROP starts. DB2 doesn't have a problem with this.
James Campbell
On 28 Jul 2009 at 11:13, Wayne Driscoll wrote: [...]
8108 99 25_Re: Database Cleanup List0_17_jtonchick@AOL.COM31_Tue, 28 Jul 2009 18:23:41 -0400371_us-ascii Max, running MODIFY prior to the DROP is not necessary.? The DROP also removes entries in both SYSCOPY & SYSLGRNX.? But in following the intent of my original reply, reducing locking overhead, running the MODIFY before the DROP will remove the need to perform the SYSCOPY/SYSLGRNX clean up and thus reduce the number of locks taken during the DROP process. [...]
8208 146 25_Re: Database Cleanup List0_17_jtonchick@AOL.COM31_Tue, 28 Jul 2009 18:29:01 -0400304_us-ascii While this may speed the DROP process, using IDCAMS to clean up the physical datasets is dangerous.? You need to be very, very carefull tracing the object to the STOGROUP to find the correct VCAT.? Let DB2 do this.? DB2 created the physical datasets, so let DB2 find them and delete them.? [...]