1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2003, week 5
2 15 19_DB2PM -File Dataset17_Db2System Process17_db2sysc@YAHOO.COM31_Mon, 29 Sep 2003 01:27:51 -0500538_- All:<br><br>I would like to use the FILE option of the batch reporting for Accounting General. I used the ISPF (Create and execute reporting commands option) to compose the JCL. What parameters shld I specify to allocate the dataset for ACFILDD1 ( like LRECL,RECFM,BLOCKSIZE etc)?<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
18 71 37_Re: auto starting DAS, DB2 UDB on AIX14_Martin Flavell18_mflavell@I-TCS.COM31_Mon, 29 Sep 2003 08:08:06 +0100386_US-ASCII The following is a quote from the operations doc I wrote for my current site<br><br>2 Database Start-up<br><br>This should be a completely automatic process, requiring no user intervention to set up or run.<br><br>AIX uses the script /etc/inittab to run its initialisation routines. One of the lines in here refers to DB2, and causes the initialisation to run /etc/rc.db2 [...]
90 38 21_DB2 Z/Os Reorg SQL???23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Mon, 29 Sep 2003 11:38:47 +0100358_iso-8859-1 Just a generic and quick question :<br><br>Does anybody have one (or maybe two) piece's) of SQL they run to tell them what tablespaces & Indexes need reorging?<br><br>We do and I would be interested in comparing this to others (those willing to share it with me that is).<br><br>We use the usual, leafdist, farroffpos, clustering etc etc ... [...]
129 79 25_Re: DB2 Z/Os Reorg SQL???14_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM31_Mon, 29 Sep 2003 11:59:43 +0100671_US-ASCII Leslie,<br><br>For INDEXES, which are much more important than tablespaces in general:<br><br>If (FREEPAGE=0 AND LEAFDIST>NLEAF) or (FREEPAGE>0 AND LEAFDIST>200) or (LEAFFAR>1) Then REORG INDEX ...<br><br>My $0.02<br><br>Andy Lankester<br><br>> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of > Pendlebury-Bowe, Leslie > Sent: 29 September 2003 11:39 > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: DB2 Z/Os Reorg SQL??? > > > Just a generic and quick question : > > Does anybody have one (or maybe two) piece's) of SQL they run > to tell them what tablespaces & Indexes need reorging? > > We [...]
209 25 30_Stored Procedures/OS390/DB2 V713_Hodgin, Scott19_shodgin@SCFBINS.COM31_Mon, 29 Sep 2003 07:48:41 -0400450_iso-8859-1 We're OS390 and DB2 V7.<br><br>I want to pass big chunks of XML between a web application and an OS390/DB2 V7 Cobol stored procedure. I have been successful in passing multiple 4000 byte parameters, but I'd like to pass one big parameter. It seems that the Varchar ends at 4095. Does anyone have an example of passing bigger chunks of data to a stored procedure. (CLOBS?). I'm not storing the data in a table. I just want to pass it. [...]
235 75 25_Re: DB2 Z/Os Reorg SQL???14_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM31_Mon, 29 Sep 2003 13:12:47 +0100632_US-ASCII Another thought on indexes:<br><br>If the REALTIME STATISTICS number of levels > RUNSTATS NLEVEL and the RTS CARDF <1.1 * RUNSTATS CARDF then REORG INDEX<br><br>Sorry - just off on hols. I'll let others do the SQLification.<br><br>Andy Lankester<br><br>> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of > Pendlebury-Bowe, Leslie > Sent: 29 September 2003 11:39 > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: DB2 Z/Os Reorg SQL??? > > > Just a generic and quick question : > > Does anybody have one (or maybe two) piece's) of SQL they run > to tell them [...]
311 25 24_Re: IFCID 225 for DB2 V610_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 29 Sep 2003 15:15:10 +0200408_us-ascii Hi Martin & all lister<br><br>Yes there's a quite recent PTF (25/09/2003 APAR UQ78804 (V6) and UQ78805 (V7)) that fix a big problem that causes<br><br>DB2 to crash (for a trace......ugh !). I had the confirmation that the APAR is correct but still doesn't work with GTF or, better,<br><br>I'm not able to work with it. I'm trying some other trick, we'll see if it works. I'll let you know..... [...]
337 109 39_Message in DIAGLOG (AIX on DB UDB V7.2)0_23_db2admin@JULIUSBAER.COM31_Mon, 29 Sep 2003 15:49:22 +0200458_iso-8859-1 Hi List<br><br>I have here a msg in the diaglog (see botton) and I can't find any hint on what "The interrupt has been received" is telling me or if any action is needed.<br><br>Thanks for any help ! Peter<br><br>2003-09-29-14.16.59.727849 Instance:ondemand Node:000 PID:131348(db2agent (A003SPRD)) Appid:*LOCAL.ondemand.030929103809 relation_data_serv sqlrl_sysTablesRead Probe:25 Database:A003SPRD DIA1003C The interrupt has been received. [...]
447 134 45_Re: Starting DAS automatically at AIX startup12_Bill Beckner16_Bbeckner@ICC.EDU31_Mon, 29 Sep 2003 08:10:14 -0500531_- We experience the same problem when we first started using DB2 5.2 under AIX. The installation/configuration utilities neglected to put an entry in the /etc/inittab file. Here is the line we had to add at the end of the file:<br><br>db:2:once:/etc/rc.db2 > /dev/console 2>&1 # Autostart DB2 Services<br><br>HTH!!!<br><br>-----Original Message----- From: McBride, Catherine [mailto:CMcbride@KABLE.COM] Sent: Friday, September 26, 2003 3:33 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Starting DAS automatically at AIX startup [...]
582 44 24_Re: IFCID 225 for DB2 V611_Mark Ediger22_MEDIGER@TRANSUNION.COM31_Mon, 29 Sep 2003 09:03:44 -0500365_US-ASCII Max,<br><br>Are you sure you are starting Statistics trace Class 6? And are you running it for the full time of your statistics interval?<br><br><br><br><br><br>>>> mscarpa@CESVE.IT 9/29/2003 8:15:10 AM >>> Hi Martin & all lister<br><br>Yes there's a quite recent PTF (25/09/2003 APAR UQ78804 (V6) and UQ78805 (V7)) that fix a big problem that causes [...]
627 146 45_Re: Starting DAS automatically at AIX startup14_Nelson, Philip34_Philip.Nelson@SCOTTISHWIDOWS.CO.UK31_Mon, 29 Sep 2003 15:04:10 +0100374_iso-8859-1 This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should notify the sender immediately by telephone on 0131-655-6789 and must delete the original E-Mail without taking a copy. If you are not the addressee you must not copy, distribute, disclose or use any of the information in any way. [...]
774 197 43_Re: Message in DIAGLOG (AIX on DB UDB V7.2)14_Nelson, Philip34_Philip.Nelson@SCOTTISHWIDOWS.CO.UK31_Mon, 29 Sep 2003 15:27:06 +0100374_iso-8859-1 This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should notify the sender immediately by telephone on 0131-655-6789 and must delete the original E-Mail without taking a copy. If you are not the addressee you must not copy, distribute, disclose or use any of the information in any way. [...]
972 51 30_Re: Questions for LOAD experts12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US31_Mon, 29 Sep 2003 08:34:47 -0500508_US-ASCII Is it possible to take a backup of the empty tables and then restore them to their empty state instead of deleting them each time?<br><br><br><br>>>> Nam_Wu@PEOPLESOFT.COM 09/26/03 06:40PM >>> Thanks to everyone who replied to my inquiry earlier.<br><br>I re-ran the LOAD REPLACE using the REUSE option, as suggested, and it went from 7 hours to 2.5 hours in deleting 13K tables worth of data. (I ran many tests against partitioned tablespaces, segmented tablespaces, and simple tablespaces. ) [...]
1024 21 30_Re: Questions for LOAD experts9_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 29 Sep 2003 10:30:42 -0500387_- If you took this approach you would have to make sure you did a REPAIR on the LEVELID to avoid done-level detection catching you and you would have to rebuild the logical parts of the NPIs.<br><br>A LOAD REPLACE REUSE whould be pretty fast on the tablespace partition and the partition of the partitioning index but you are going to have to deal with the NPIs one way or another. [...]
1046 15 52_Utilities on TS started for UT run (really) faster ?17_Christophe Radier17_c300501@YAHOO.COM31_Mon, 29 Sep 2003 10:35:28 -0500526_- Hi all,<br><br>I've read somewhere that Utilities run faster on Tablespaces started with "UT" status. Can you explain why ? I just see that it maybe simplier for DB2 to handle concurrency when the TS is started UT but don't think that it can really make a difference .<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1062 134 12_Re: DSNX@XAC14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Mon, 29 Sep 2003 11:05:21 -0500597_us-ascii If DSNX@XAC is installed, DB2 will only check the SYS*AUTH tables if DSNX@XAC returns a value of 4 from an access check. If the exit is able to either allow or deny access, the tables will NOT be checked. In my opinion, once the RACF tables have been populated, I would stop using grants, and even consider doing revokes of authorities. At a minimum, I would suggest that you reduce select authority to the SYS*AUTH tables so your users won't see that they "should" have access, since it is in SYS*AUTH. Wayne Driscoll Sr. Software Developer Quest Software wdriscoll@quest.com NOTE: [...]
1197 60 24_Re: Survey - Active Logs0_19_csutfin@AMSOUTH.COM31_Mon, 29 Sep 2003 10:57:30 -0500347_us-ascii One more for your survey:<br><br>1. Our production logs are 1170 cylinders dual. 2. We have 12 active log files 3. Archive to 3490 (VTS) local and 3590 remote.<br><br>We archive log files anywhere from 20 to 60 times daily depending on day of the week<br><br>Carol Sutfin Corporate DBA AmSouth Bank (205)261-5214 csutfin@amsouth.com [...]
1258 35 24_Re: Survey - Active Logs11_ANGOT HARRY18_harry.angot@CDN.FR31_Mon, 29 Sep 2003 18:28:11 +0200696_- Hi gurus,<br><br>I have a flat file (ASCII) that will be used for SYSREC for loading, there is Varchar zone in the table to be loaded. In the syspunch how can I tell to DB2 that it's a VARCHAR zone ?<br><br>What would you do ?<br><br>Thanks for your response .<br><br>Regards<br><br>Harry<br><br><br><br>---------------------------------------------------- Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et etablis a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite.Tout message electronique est susceptible d'alteration. Le CREDIT DU NORD et ses filiales declinent toute responsabilite au titre de [...]
1294 231 24_Re: Survey - Active Logs22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 29 Sep 2003 11:37:46 -0500515_iso-8859-1 <br><br>If the input data is just characters (without the 2 byte VARCHAR header), you can use something like this...<br><br>VARCHAR_COL_NAME POSITION( 1 ) CHAR EXTERNAL(200)<br><br>HTH,<br><br>Venkatesh Mokshagundam Database Administrator Corporate Systems, Amarillo, TX 79102 Ph: 806-337-3374 Fax: 806-345-2736<br><br>-----Original Message----- From: ANGOT HARRY [mailto:harry.angot@CDN.FR] Sent: Monday, September 29, 2003 11:28 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Survey - Active Logs [...]
1526 26 42_Create Index statement - Copy No parameter14_ian Mccullough30_ian.mccullough@UK.EXPERIAN.COM31_Mon, 29 Sep 2003 11:32:29 -0500329_- Hello,<br><br>Minor question with V6<br><br>One of the options on the create index statements is COPY YES/NO with NO being the default. I understand there is always pros and cons for each parameter. Now if I create indexes with COPY YES regardless of wether I intend to image copy them or not then what are the overheads. [...]
1553 26 26_Reliable Replication tools22_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM31_Mon, 29 Sep 2003 09:52:19 -0700351_iso-8859-1 Listers, I am posting this again, since the first time I posted close to the weekend. Just checking what replication tools are in vogue for data transfer between Oracle and DB2 ...Anybody who has been using Datajoiner for replication between DB2 and Oracle , can you please share your experiences with me ? Anybody used STRIVA tools ? [...]
1580 51 56_Re: Utilities on TS started for UT run (really) faster ?12_michael bell24_mbell11@WORLDNET.ATT.NET31_Mon, 29 Sep 2003 12:13:53 -0500369_iso-8859-1 I can only think of one issue that might affect SHRLEVEL CHANGE utilities - DB2 has to lock/unlock the page for each access and might have to wait for an update process to commit. Everything else I have seen from the utilities would not make any difference. Of course, START ACCESS (UT) negates any locking considerations and user access to the tables. [...]
1632 25 46_Re: Create Index statement - Copy No parameter9_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 29 Sep 2003 12:22:31 -0500523_- When you specify COPY YES for an index DB2 will keep track of the log ranges where change activity is occuring on the index. This is stored in the SYSLGRNX tablespace so if you enable COPY YES for all your indexes but never image copy any so are wasting space in SYSGLRNX. You may need to run MODIFY RECOVERY more often to clean out old log range information and you may have to reorganize SYSLGRNX more often. All this without the benefit of restoring copies much faster than rebuilding them by scanning the table. [...]
1658 25 55_Connecting to two DB2 subsystems from one COBOL program11_General Tso16_tzs61x@YAHOO.COM31_Mon, 29 Sep 2003 11:13:38 -0700406_us-ascii To listers: We have a need to write a COBOL program to connect to a DB2 subsystem, doing some SELECTs, then connect to another DB2 subsystem doing some UPDATEs. Is there any sample Cobol code available? We are z/OS DB2 version 7. Thanks for help<br><br><br><br>__________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [...]
1684 45 59_Re: Connecting to two DB2 subsystems from one COBOL program15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Mon, 29 Sep 2003 14:24:16 -0400483_us-ascii We have done this using EZTrieve Plus, or any dynamically compiled program, but I don't think Static Cobol can do it.<br><br>You could try creating a dynamic Cobol program to do it - I've never tried.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of General Tso Sent: Monday, September 29, 2003 2:14 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Connecting to two DB2 subsystems from one COBOL program [...]
1730 14 59_Re: Connecting to two DB2 subsystems from one COBOL program9_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 29 Sep 2003 13:43:32 -0500454_- You will need to use the Call Attach or RRS Attach to connect to the first db2, desconnect, then connect to second DB2. Look at DSN8CC in DSN710.SDSNSAMP.<br><br>Jim Ruddy DB2 for z/OS Development<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1745 22 56_Re: Utilities on TS started for UT run (really) faster ?9_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 29 Sep 2003 13:49:49 -0500430_- Of course starting an object UT then specifying SHRLEVEL CHANGE will not result in the availability you hope for.<br><br>Starting a object UT before a utility causes the wait for draining of users to occur before the utility rather than as part of utility initialization. Probably actually costs more resources to do it this way than just let the utility do it and you have to remember to set back to RW after the utility. [...]
1768 79 59_Re: Connecting to two DB2 subsystems from one COBOL program12_michael bell24_mbell11@WORLDNET.ATT.NET31_Mon, 29 Sep 2003 13:59:23 -0500591_Windows-1252 see chapter 6.7 of db2 application programming guide Chapter 6-7. Programming for the call attachment facility (CAF) Your basic control logic would be Connect to DB2 using plan name SQL stuff Disconnect from DB2 connect to next DB2 using same/different plan name SQL stuff on this DB2 disconnect from DB2 The manual has examples of connect/disconnect code for COBOL You will have to bind the program on every DB2 subsystem you will run on. If you use static sql and the table names are different or don't exist on one or other subsystem, you will have have issues with the [...]
1848 48 59_Re: Connecting to two DB2 subsystems from one COBOL program14_Manas Dasgupta22_dasgupta@BELLSOUTH.NET31_Mon, 29 Sep 2003 14:59:45 -0400306_iso-8859-1 Couple of options: 1. Use 3 part names and or alias. 2. Use CONNECT to explicitily connect to remote DB2 Remember to BIND your packages to remote DB2s and include them in the plan. Now that DB2 can use DRDA with 3 part names (rather than private protocol), option 1 may be more attractive. [...]
1897 16 59_Re: Connecting to two DB2 subsystems from one COBOL program0_26_truman.g.brown@VERIZON.COM31_Mon, 29 Sep 2003 15:05:38 -0400420_us-ascii Why not run the COBOL program "bound" to one "local" subsystem and use DDF to get from the "local" subsystem to the "remote" (2nd) subsystem?<br><br>George<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1914 101 8_DB2 V8.117_Nicholas A Aronne19_naaronne@US.IBM.COM31_Mon, 29 Sep 2003 15:11:08 -0400317_US-ASCII Would anyone happen to know where I might be able to get a DB2 V8.1 poster?<br><br><br><br><br><br><br><br><br><br>Nicholas A. Aronne DB2 UDB DBA naaronne@us.ibm.com<br><br>299-300 Long Meadow Road P.O. Box 700 Sterling Forest, NY 10979 Phone: (845) 759-7095 T/L 8-248-7095 Pager/PIN#: 800-759-8888 (1135426)
2016 41 59_Re: Connecting to two DB2 subsystems from one COBOL program14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Mon, 29 Sep 2003 21:07:42 +0200399_- If you can run your programm under a TSO batch session (IJKEFT01), you can issue EXEC SQL CONNECT TO :subsys (static SQL) without problems. But you need to have the same package (same timestamp etc.) on every subsystem (different qualifiers are possible), and you need to have a plan, which has all the relevant collections of all the subsystems in its packlist. This is called DRDA CONNECT. [...]
2058 41 30_Re: Reliable Replication tools8_Ron Root24_ron.root@CPA.STATE.TX.US31_Mon, 29 Sep 2003 15:08:31 -0500656_iso-8859-1 FYI. Informatica just purchased STRIVA.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Ramesh Balasubramanyan Sent: Monday, September 29, 2003 11:52 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Reliable Replication tools<br><br><br><br>Listers, I am posting this again, since the first time I posted close to the weekend. Just checking what replication tools are in vogue for data transfer between Oracle and DB2 ...Anybody who has been using Datajoiner for replication between DB2 and Oracle , can you please share your experiences with me ? Anybody used STRIVA tools ? [...]
2100 235 12_Re: DB2 V8.116_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 29 Sep 2003 16:22:13 -0400464_iso-8859-1 BMC has a nice DB2 UDB 8 poster<br><br><br><br><br><br><br><br>Tel: +1 905 803 8600 Toll Free: +1 800 348 8299 Fax: +1 905 803 8603 Quebec: +1 877-281-1888 Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 V7 Database Administration<br><br>robert.galambos@compuware.com <mailto:robert.galambos@compuware.com><br><br>Compuware Canada <file:///C:/Canada.gif><br><br>Service is our best product [...]
2336 34 30_Re: Reliable Replication tools26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Mon, 29 Sep 2003 15:38:41 -0500561_- Might want to peek at www.alebra.com and see what you think or if there are others using it, what they think. Some pretty good "white papers" on the site too....<br><br>> Listers, I am posting this again, since the first time I posted close to the weekend. > Just checking what replication tools are in vogue for data transfer between Oracle and DB2 ...Anybody who has been using Datajoiner > for replication between DB2 and Oracle , can you please share your experiences with me ? Anybody used STRIVA tools ? > > We having been using CA's Infopump, now [...]
2371 22 38_Can DB2 handle reading encrypted data?16_Shelly R Rockett25_Shelly_Rockett@MAY-CO.COM31_Mon, 29 Sep 2003 15:22:57 -0500487_us-ascii Is there something that I can do to allow DB2 to read and decipher encrypted data.<br><br><br><br>Thanks in advance.<br><br>Shelly Rockett May Department Stores Database Analyst 314-342-6800/x3215 SHELLY_ROCKETT@MAY-CO.COM<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2394 45 92_Re: Connecting =?ISO-8859-1?B?oHRvIHR3byBEQjIgc3Vic3lzdGVtcyBmcm9tIG9uZSBDT0JPTCBwcm9ncmFt?=0_18_IWANT2BEME@AOL.COM31_Mon, 29 Sep 2003 22:30:17 -0400309_iso-8859-1 Manas wrote:<br><br>"1. Use 3 part names and or alias. 2. Use CONNECT to explicitily connect to remote DB2 Remember to BIND your packages to remote DB2s and include them in the plan. Now that DB2 can use DRDA with 3 part names (rather than private protocol), option 1 may be more attractive." [...]
2440 15 34_Re: Stored Procedures/OS390/DB2 V70_18_IWANT2BEME@AOL.COM31_Mon, 29 Sep 2003 22:35:45 -0400358_iso-8859-1 How about large VARCHAR parameters? Watch you max SQL statement size though.<br><br>Jacquie<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2456 71 24_Re: IFCID 225 for DB2 V623_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 30 Sep 2003 06:22:44 +0100437_- we're using 225 (class 6) well here. Have been for a year or so now ... (V7), and we do not have UQ78805 applied.<br><br>not only do we review it in stats reports, but we see the data in our history DB ...<br><br>best regards<br><br>Leslie<br><br>-----Original Message----- From: Mark Ediger [mailto:MEDIGER@TRANSUNION.COM] Sent: Monday, September 29, 2003 3:04 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: IFCID 225 for DB2 V6 [...]
2528 114 24_Re: IFCID 225 for DB2 V613_Martin Packer24_martin_packer@UK.IBM.COM31_Tue, 30 Sep 2003 07:41:43 +0100475_us-ascii Given yours is a SAP shop I should think your graphs have interesting shapes. :-)<br><br>Cheers, Martin<br><br>Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584)<br><br><br><br><br><br>"Pendlebury-Bowe, Leslie" <Leslie.Pendlebury-Bowe@E To: DB2-L@LISTSERV.YLASSOC.COM U.SONY.COM> cc: Sent by: DB2 Data Base Subject: Re: IFCID 225 for DB2 V6 Discussion List <DB2-L@LISTSERV.YLASSOC.C OM> [...]
2643 100 46_Re: Create Index statement - Copy No parameter13_Michael Ebert18_mebert@AMADEUS.NET31_Tue, 30 Sep 2003 09:47:19 +0200585_us-ascii I don't think there's an urgent need for additional reorgs of SYSLGRNX. After all, the ability to reorg this TS was only introduced somewhere in the V5 lifetime, One advantage of specifying COPY YES is that utility activity against the index is recorded in SYSCOPY - so you know when you last ran REORG on an index, to cite an example. For that reason, I consider specifying COPY YES for NPIs (for non-NPIs, I simply assume that the index got reorged when the TS/partition was reorged, i.e. no separate REORG INDEX). In my opinion, image copying indexes makes sense only [...]
2744 68 56_Re: Utilities on TS started for UT run (really) faster ?13_Michael Ebert18_mebert@AMADEUS.NET31_Tue, 30 Sep 2003 09:52:55 +0200634_us-ascii The point of having SHRLEVEL CHANGE is that it does NOT wait for COMMIT. Except for very specialized cases, I only use SHRLEVEL CHANGE utilities for maximum availability. I would not even consider using UT mode anywhere.<br><br>Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany<br><br><br><br><br><br>I can only think of one issue that might affect SHRLEVEL CHANGE utilities - DB2 has to lock/unlock the page for each access and might have to wait for an update process to commit. Everything else I have seen from the utilities would not make any difference. Of course, START [...]
2813 37 34_Re: Stored Procedures/OS390/DB2 V713_Hodgin, Scott19_shodgin@SCFBINS.COM31_Tue, 30 Sep 2003 08:12:53 -0400352_iso-8859-1 I've tried numerous combinations of Long Varchar, CLOB, etc, but none of them seem to work. I can send 4095 using Varchar, but when I try anything larger, I get something about incorrect number of parameters. I can seem to find a way to send more the 4095 bytes in a single parameter to a Cobol stored procedure from a web application. [...]
2851 68 34_Re: Stored Procedures/OS390/DB2 V718_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 30 Sep 2003 08:23:56 -0400325_US-ASCII If you are attempting to use long varchar with SQL stored procedures, it's not supported. I am running into this situation with SQL stored procedures on Unix. Have a PMR opened with IBM because I can't go over 4000 bytes. Maybe one day IBM will release a product that supports all datatypes. One can only hope! [...]
2920 54 34_Re: Stored Procedures/OS390/DB2 V714_Dingman, Randy25_RGDingman@AAAMICHIGAN.COM31_Tue, 30 Sep 2003 08:17:51 -0400646_iso-8859-1 Went through this about 3 years ago . . .<br><br>It was something on the client end, in our case a Java setting. I'll look through my notes.<br><br>-----Original Message----- From: Hodgin, Scott [mailto:shodgin@SCFBINS.COM] Sent: Tuesday, September 30, 2003 8:13 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Stored Procedures/OS390/DB2 V7<br><br><br><br>I've tried numerous combinations of Long Varchar, CLOB, etc, but none of them seem to work. I can send 4095 using Varchar, but when I try anything larger, I get something about incorrect number of parameters. I can seem to find a way to send more the 4095 bytes in a single [...]
2975 45 30_Re: Reliable Replication tools10_CEI, Bruno30_Bruno.CEI@ANDOVER.SEMA.SLB.COM31_Tue, 30 Sep 2003 15:33:05 +0100469_iso-8859-1 I have seen STRIVA woriking, altough my understanding is that it acts as a gateway to run SQL against DB2.<br><br>So probably you are in the same situation as with CA's tool. With STRIVA it was associated with Informatica products on the distributed end.<br><br>Bruno<br><br>-----Original Message----- From: Ramesh Balasubramanyan [mailto:RAMBAL@SAIF.COM] Sent: 29 September 2003 17:52 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Reliable Replication tools [...]
3021 140 24_Re: IFCID 225 for DB2 V623_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 30 Sep 2003 15:41:43 +0100366_- yep .. up / down / up / down / up / bang :-)<br><br>-----Original Message----- From: Martin Packer [mailto:martin_packer@UK.IBM.COM] Sent: Tuesday, September 30, 2003 7:42 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: IFCID 225 for DB2 V6<br><br><br><br>Given yours is a SAP shop I should think your graphs have interesting shapes. :-)<br><br>Cheers, Martin [...]
3162 17 46_Re: Create Index statement - Copy No parameter9_Jim Ruddy18_jaruddy@US.IBM.COM31_Tue, 30 Sep 2003 09:54:54 -0500545_- In V6 when we implemented parallel index build for REBUILD as well as recovering from an image copy of an index our benchmarks showed that recover from copy was faster the bigger the index grew.<br><br>Small indexes are about as fast either way.<br><br>Jim Ruddy DB2 for z/OS Development<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
3180 75 46_Re: Create Index statement - Copy No parameter13_Michael Ebert18_mebert@AMADEUS.NET31_Tue, 30 Sep 2003 17:36:14 +0200535_us-ascii In a benchmark environment this may be true - i.e. if the image copy is on disk, and the necessary archive datasets are on disks, and there is only a small amount of logs to process, and there is no significant other logging activity. I know how long a simple HSM recall can take - I guess few indexes can't be rebuilt in that time. We've had cases where the recovery of a small OLTP TS from an IC taken yesterday took hours because 20 1000-CYL archive logs had to be recalled and processed (only a minuscule part of the [...]
3256 68 46_Re: Create Index statement - Copy No parameter15_Toine Michielse25_antoine.michielse@UBS.COM31_Tue, 30 Sep 2003 17:44:17 +0200596_iso-8859-1 Hello Michael,<br><br>I hope waiting hours for recovery of a small tablespace is an overstatement. If not, I would suggest reviewing backup/recovery strategy. As well as optimizing all components that play a role in recovery. Unless of course, availability requirements are not that high.<br><br>Best regards, Toine Michielse -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Michael Ebert Sent: Tuesday, September 30, 2003 5:36 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Create Index statement - Copy No parameter [...]
3325 51 19_Recover TS question16_Kane, Kenneth M.20_Kenneth.Kane@UBS.COM31_Tue, 30 Sep 2003 11:53:52 -0400490_iso-8859-1 I would appreciate hearing from anyone who can definitively tell me to what point a TS is recovered using the IBM utility with a simple 'RECOVER TABLESPACE' control card.. no TORBA, no TOCOPY, no bells or whistles. We have a 3 pointed discussion active , one says to the last full copy, one says to last synchpoint or commit, one says to last Quiesce. Also, when this was run against the TS, the indexes were not flagged as Rebuild Pending.. should they have been? (DB2 V6) [...]
3377 14 23_Re: Recover TS question9_Jim Ruddy18_jaruddy@US.IBM.COM31_Tue, 30 Sep 2003 11:01:55 -0500399_- RECOVER TABLESPACE (no bells, nowhistles) will recover the tablespace to the current point in time.<br><br>Jim Ruddy DB2 for z/OS Development<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
3392 143 46_Re: Create Index statement - Copy No parameter13_Michael Ebert18_mebert@AMADEUS.NET31_Tue, 30 Sep 2003 18:07:45 +0200525_us-ascii 1. You have a TS that gets updated every few seconds (or minutes) so it very rarely pseudo-closes. 2. You have a DB2 that generates about 2 x 15 GB of logs - around 20 archive logs/day. Because of 1, you have to recall and read all of them. 3. The CPU is usually 100% busy (especially when things tend to go wrong). 4. The TS is already IC'd daily (actually twice a day, once before a batch that takes out old data and once after). 5. The log apply process, being I/O-intensive, is slow and has to contend with [...]
3536 67 23_Re: Recover TS question24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 30 Sep 2003 09:10:42 -0700478_- If you do not specify anything on the recover statement, then recovery proceeds to the most recent commit/sync point for the tablespace. All tables in the tablespace, and all associated indexes will be recovered. The indexes will not (and should not) be flagged as rebuild pending.<br><br>-----Original Message----- From: Kane, Kenneth M. [mailto:Kenneth.Kane@UBS.COM] Sent: Tuesday, September 30, 2003 8:54 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Recover TS question [...]
3604 56 23_Re: Recover TS question13_Michael Ebert18_mebert@AMADEUS.NET31_Tue, 30 Sep 2003 18:13:44 +0200377_us-ascii .... and if nothing has damaged the indexes as well, they are already at the current PIT, so there's no need to rebuild (or recover) them.<br><br>Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany<br><br><br><br><br><br>RECOVER TABLESPACE (no bells, nowhistles) will recover the tablespace to the current point in time. [...]
3661 183 46_Re: Create Index statement - Copy No parameter16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Tue, 30 Sep 2003 09:19:29 -0700493_iso-8859-1 If you're recovering the TS as well as the index, then the logs will have to be recalled anyway.<br><br><br><br>Tony Provenzola Nike Database Services x Venturi Technology Partners, Consulting Phone * 503-532-0772 Fax * 503-532-3223 Email * Tony.Provenzola@nike.com<br><br>-----Original Message----- From: Michael Ebert [mailto:mebert@AMADEUS.NET] Sent: Tuesday, September 30, 2003 8:36 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Create Index statement - Copy No parameter [...]
3845 109 46_Re: Create Index statement - Copy No parameter15_Toine Michielse25_antoine.michielse@UBS.COM31_Tue, 30 Sep 2003 18:34:52 +0200288_iso-8859-1 Well one thing could be to invest in a DASD pool for the archives to fit within the IC frequency so that the recall you identified a s a major point of delay be avoided. Second, CPU usually at 100% busy is a bit 'iffy' to me..<br><br>Oh yes... there is no free lunch..... [...]
3955 104 12_Re: DB2 V8.112_Phil Gunning20_pgunning@COMCAST.NET31_Tue, 30 Sep 2003 13:15:16 -0400447_iso-8859-1 Hmm... not sure where you get it but it depends what you are looking for....IBM has a nice one on the DB2 Engine, processes and storage model. Then some vendors have DB2 Catalog posters...Quest for one, not sure about the others...I'm sure they will be available at the upcoming IDUG Europe and Tech Conference......and after your post maybe one of the vendors will contact you offline to tell you how you can get a poster... Phil [...]
4060 121 46_Re: Create Index statement - Copy No parameter12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 30 Sep 2003 20:40:33 +0200534_- Hi, We copy to dasd. Recovery is fast, don't have the times here - will check tomorrow. For big tables (118M rows - 8 disks data, 12 disk indexes) it helps. Copy & recover in parallel - works superb (ever seen 150 subtasks in parallel ? :-) )<br><br>Isaac Yassin<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Toine Michielse Sent: Tuesday, September 30, 2003 6:35 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Create Index statement - Copy No parameter [...]
4182 66 30_REORG with UNLOAD DISCARD v7.19_Dan Diehl29_ddiehl2@HARLEYSVILLEGROUP.COM31_Tue, 30 Sep 2003 13:45:04 -0500462_- I needed to discard unneeded rows from a table. My WHEN clause was not giving me the results I expected.<br><br>Original when clause - did NOT work:<br><br>WHEN ((ERROR_CODE_TXT = 'DV006') AND (INPUT_VALUE1_TXT= ' ') AND (POPULATION_INFO_ID = 0) ) DISCARDDDN(IDISC1) resulted in 0 discards.<br><br>This statement:<br><br>SELECT COUNT(*) FROM DSNP.PROD.ERROR_MESSAGE_LOG WHERE ERROR_CODE_TXT = 'DV006' AND INPUT_VALUE1_TXT= ' ' AND POPULATION_INFO_ID = 0; [...]
4249 103 24_Re: Real Time Statistics13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Tue, 30 Sep 2003 13:35:55 -0500278_- I'm sorry I did not to respond to the thread, but I was out sick for a week. APAR PQ78832 was opened to fix the problem now instead of some later release, and should be out next month.<br><br>I got this from John Campbell. I don't think he would mind me posting it here. [...]
4353 14 34_Re: REORG with UNLOAD DISCARD v7.19_Jim Ruddy18_jaruddy@US.IBM.COM31_Tue, 30 Sep 2003 14:52:36 -0500394_- See if you have APAR PQ77231 applied. It fixes a problem similar to what you are experiencing.<br><br>Jim Ruddy DB2 for z/OS Development<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
4368 85 46_Re: Create Index statement - Copy No parameter13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 30 Sep 2003 16:00:29 -0500509_iso-8859-1 The one thing about this topic that has me scratching my head and going "Hmmm..." is from looking at a recent apar (PQ69266). The PTF for this appears to provide an additional benefit to "COPY YES" indexes for online reorg during the log apply phase. I don't know if it's enough of a benefit to justify the overhead and it's probably too early to tell, but I do think it's a consideration (and we have definitely noticed some inconsistent runtimes of online reorg due to the log apply phase). [...]
4454 97 46_Re: Create Index statement - Copy No parameter13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 30 Sep 2003 16:00:29 -0500509_iso-8859-1 The one thing about this topic that has me scratching my head and going "Hmmm..." is from looking at a recent apar (PQ69266). The PTF for this appears to provide an additional benefit to "COPY YES" indexes for online reorg during the log apply phase. I don't know if it's enough of a benefit to justify the overhead and it's probably too early to tell, but I do think it's a consideration (and we have definitely noticed some inconsistent runtimes of online reorg due to the log apply phase). [...]
4552 82 35_Migrate to UDB on NT from Mainframe7_twalker17_twalker@AST-I.COM31_Tue, 30 Sep 2003 17:10:25 -0500398_iso-8859-1 Has anyone done any kind of write up on justification in migrating from Mainframe DB2 / Cobol environment to DB2 UDB on Windows NT/2000.<br><br>We are currently using Mainframe DB2/ COBOL / JCL on Mainframe. It is a Data warehouse.<br><br>We have COGNOS for BI, DATASTAGE for code generation on NT Looking at possibilities to move the data warehouse to UDB /DATASTAGE/COGNOS on NT. [...]
4635 130 53_Changing EBCDIC codepage from one release to the next12_Roy Reynolds24_royr@UCLINK.BERKELEY.EDU31_Tue, 30 Sep 2003 15:32:07 -0700629_us-ascii What is the conventional wisdom about changing from EBCDIC codepage 37 (DB2 V6) to codepage 1140 while migrating to ZOS DB2 Version 7?<br><br>Would it be necessary to unload and reload user data specifying the new codepage to ensure no glitches?<br><br>Comments please.<br><br><br><br><br><br>Roy Reynolds<br><br>UC Berkeley<br><br><br><br><br><br><br><br><br><br><br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
4766 64 16_-805 on DSNATBLS11_Robert Ball24_roball@WOOLWORTHS.COM.AU31_Tue, 30 Sep 2003 18:36:35 -0500660_- We have applied APAR PQ72453 for the new JDBC stored procedures but we are getting the following error messages on the requestor (DB2 Conect 8.1) - host is DB2 V6.1 on OS/390 V2.10<br><br>com.wm.app.b2b.server.serviceException;[ART.114.205] Adapter Runtime (Metadata): Unable to lookup the resource domain values [ADA.1.318] Cannot get the list of catalogs." (38112/-443) [IBM][CLI Driver][DB2] SQL0443N Routine "SQLTABLES" (specific name"SQLTABLES") has returned an error SQLSTATE with diagnostic text "SQLCODE=-805 AUWWIS01WIS3DB23.". SQLSTATE=38112 on tables.catalogName [Ljava.lang.String;@f5cce java.lang.Exception:Adapter values are not available [...]
4831 13 47_Richard Strong/MAN/Candle is out of the office.14_Richard Strong25_Richard_Strong@CANDLE.COM30_Wed, 1 Oct 2003 01:00:53 +0100350_us-ascii I will be out of the office starting 30/09/2003 and will not return until 31/10/2003.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
4845 21 12_cancellation17_Robert J. Milonas20_XRJMBOB@NETSCAPE.NET31_Tue, 30 Sep 2003 22:10:08 -0400694_iso-8859-1 Please cancel my subscription<br><br>__________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397<br><br>Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
4867 11 20_Re: -805 on DSNATBLS11_Robert Ball24_roball@WOOLWORTHS.COM.AU31_Tue, 30 Sep 2003 23:40:14 -0500392_- When I downloaded UQ79254 from the support centre, I only received part of the file. I ordered the PTF again and everything is OK now.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.