1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2002, week 3 2 50 41_Re: Compilation problem with xlc compiler31_Ramakrishnan Chandraseharapuram41_Ramakrishnan_Chandraseharapuram@USSWI.COM31_Tue, 15 Jan 2002 11:36:36 +0530451_ISO-8859-1 I am trying it on an AIX platform.......the error message is "export file ???.exp cannot be found"



-----Original Message----- From: James Campbell [mailto:jacampbell@ACSLINK.NET.AU] Sent: Tuesday, January 15, 2002 7:01 AM To: DB2-L@RYCI.COM Subject: Re: Compilation problem with xlc compiler



What platform (OS/390, OS/390 USS, NT, HP-UX etc) what C compiler (not sure what "xlc" is); what error messages? [...] 53 26 48_Switching between multiple db2 instances in UNIX16_Chintala S Kumar19_chintala@IN.IBM.COM31_Tue, 15 Jan 2002 11:57:30 +0530632_us-ascii Hi List, May be the question is trivial ! How to switch between multiple db2 instances in UNIX? In which diretory we can see the details of instances in UNIX?

Thanks & Best Regards, Surendar ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

IBM Global Services India Pvt Ltd, "The Presidency", #1, St. Mark's Road Bangalore - INDIA - 560 001 Phone: 91-80-2244056 Ext: 372 91-80-5252602 (Res) Mail id: chintala@in.ibm.com [...] 80 180 80_Re: Anybody know where I can get an online graphical picture of t he c at & Dir?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 15 Jan 2002 06:31:03 -0000674_iso-8859-1 Thanks to all those that replied .. we have one now.

Excellent site ...

Leslie

-----Original Message----- From: Bednarz, Michael [mailto:Michael.Bednarz@CA.COM] Sent: Monday, January 14, 2002 4:04 PM To: DB2-L@RYCI.COM Subject: Re: Anybody know where I can get an online graphical picture of t he c at & Dir?



Try this



http://www.ca.com/products/posters.htm



Michael Bednarz Computer Associates FSG Consultant tel: +49 (0)211 5306 295 fax: +49 (0)211 5306 200 mobile: +49 (0)170 85 38 576 mailto:michael.bednarzr@ca.com [...] 261 24 43_ASYNCHORNOUS WRITE ENGINE WITH ADDRESS SPAN17_jennifer jennifer22_jenni_jeni@HOTMAIL.COM31_Tue, 15 Jan 2002 06:47:13 +0000476_- Hello All Masters , I have a interesting question for you all. The question is regarding WRITE ENGINES OF DB2 related to buffer pool. How is the relation defined for ASYNCHORNOUS WRITE ENGINES WITH ADDRESS SPAN.lIKE HOW MANY PAGES ARE THERE FRO ADDRESS SPAN. HOW IT AFFECTS THE IMTH,DWQT AND VWDQT PARAMETER FOR BUFFER POOL. Hope these are simple questions for you all. For me it is a ocean of doubts. Waiting for your responses with giving thanks in advance. Jennifer [...] 286 97 25_Re: Parallel Load Problem17_jennifer jennifer22_jenni_jeni@HOTMAIL.COM31_Tue, 15 Jan 2002 06:53:15 +0000327_- Hello Dash , Hope you wont mind but the syntax you gave is only for version 7 I suppose. Mike has asked only for version 5.I tried today morning and itgave me probelm. When I checked the Manual today the exact syntax I got from IBM manual but it is only for version 7. Can you give your clarification on these. Jennifer [...] 384 16 44_Rue V. Pham/IRM/DST/US is out of the office.0_21_RVPham@DSTSYSTEMS.COM31_Tue, 15 Jan 2002 01:04:32 -0600439_us-ascii I will be out of the office starting 01/14/2002 and will not return until 01/21/2002.

Please contact Todd Carmichael 435-4925 or Tracy Hutton while I'm away for immediate attentions

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 401 21 22_Re: Bind Option: Owner15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 15 Jan 2002 01:19:12 -0600335_- Melissa

From previous threads I know you are using external security. I'm not familiar with that, so I can only give some hints where the error might occur from.

1. If the owner is different from the programmer's id, he has to have bindagent authority granted by the owner. What is the appropriate RACF authority? [...] 423 70 22_Re: Bind Option: Owner18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Tue, 15 Jan 2002 12:56:49 +0530609_- Melissa,

Pg 114 & 115 of Admin guide ver 7 speak about diff object creation and ownership scenarios.

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

Hi list,

In the same vein could someone elucidate the previliges of CREATOR vis-a-vis the OWNER's. The latter part of following stmt appearing in the admin guide stumped me.. ********* Ownership of an object carries with it a set of related privileges over the object. An ID can own an object it creates, or it can create an object to be owned by another ID. ********* Any help would be appreciated. [...] 494 16 40_Sarah Ellis/UK/IBM is out of the office.11_Sarah Ellis17_sellis@UK.IBM.COM31_Tue, 15 Jan 2002 07:42:09 +0000474_us-ascii I will be out of the office starting January 14, 2002 and will not return until January 17, 2002.

I will respond to your message when I return. Alternatively please contact my colleague Ian Cook (ian_cook@uk.ibm.com)

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 511 35 37_Re: Load problem with 'format unload'16_Norbert Thiebaud23_norbert@INFOTELCORP.COM31_Tue, 15 Jan 2002 09:14:46 +0100605_iso-8859-1 Raymond,

DSNTIAUL may be space consuming, especially if you have varchars

The OBID is in byte 4 and 5 of your 6 byte header.

Norbert



Date: Tue, 15 Jan 2002 09:27:43 +1300 From: Raymond Bell Subject: Re: Load problem with 'format unload'

Cheers, Phil. Thanks for the confirmation. I was going to edit the unload file but I wasn't sure where in the first 6 bytes the OBID was. In the end, as most of the file was character data, I just shifted it left 6 characters, knocked up some load cards a la DSNTIAUL and loaded them back [...] 547 204 48_Re: Memory leaks after migrating to OS/390 V2.1023_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 15 Jan 2002 08:38:08 -0000610_iso-8859-1 Hi all

I have just noticed that John Campbell will be giving a Storage Mgt presentation at the European (and I assume US) IBM tech conference this March ...

http://www-3.ibm.com/services/learning/conf/europe/DB2_IMS/db2_ims.pdf

all those that requested my rexx will receive it tomorrow as I have a visitor in from IBM San Jose today.

best regards

Les

-----Original Message----- From: Jeremiah Eden [mailto:JEREMIAH.EDEN@RADIOSHACK.COM] Sent: Monday, January 07, 2002 9:58 PM To: DB2-L@RYCI.COM Subject: Re: Memory leaks after migrating to OS/390 V2.10 [...] 752 39 51_Re : Drain lock waits during application processing27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Tue, 15 Jan 2002 09:11:23 -0000417_iso-8859-1 Mike, I assume by "free reports", you're referring to the canned reports that MXG provides. I moved away from these as the version(s) of these as installed here at NatWest do not support the full SMF breakdown of class 3 suspension details as generated by DB2 v6 class 3 accounting trace - specifically waits for service task switching. The same is true of the version on Omegamon/DB2 installed here. [...] 792 74 25_Re: Parallel Load Problem12_sushant dash23_dash_dba@REDIFFMAIL.COM31_Tue, 15 Jan 2002 10:04:51 -0000500_iso-8859-1 Yes Jennifer What I wrote is regarding the Versio 7 of db2. I would get back again. Dash

On Tue, 15 Jan 2002 jennifer jennifer wrote : > Hello Dash , Hope you wont mind but the syntax you gave > is only for version > 7 I suppose. Mike has asked only for version 5.I tried > today morning and > itgave me probelm. When I checked the Manual today the > exact syntax I got > from IBM manual but it is only for version 7. Can you > give your > clarification on these. > Jennifer > [...] 867 65 35_Re: SQL QUESTIONS WITH EXPLAIN INFO22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 15 Jan 2002 15:55:24 +0530543_- Dash,

What Terry wanted to point out is, in your 2nd query the sequential prefetch is not shown in the explain. And if your data is such that it needs to be scanned sequentially(for better performance) then DB2 will use dynamic prefetch (which is less efficient than sequential prefetch). If DB2 is not using dynamic prefetch but using random I/O due to some reasons for accessing the data for anything (Join in your case) then it may be death by Random I/O (explored by Michael Hannan) depending on the number of pages scanned. [...] 933 27 48_Re: Memory leaks after migrating to OS/390 V2.1023_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 15 Jan 2002 10:28:29 -0000698_- I refer to my previous mail .. the JC storage mgt presentation was last MArch ..





best regards

Leslie



********************************************************************** The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only. [...] 961 89 51_Re : Drain lock waits during application processing27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Tue, 15 Jan 2002 10:28:25 -0000346_iso-8859-1 Humble apologies guys. The claim request count is not zero - must have been browsing the wrong report or something.

The drain request count is zero however. Is this not inconsistent with a drain lock wait time of up 170 ms per transaction ? Surely for a process to be waiting for a drain lock, it must have requested one ? [...] 1051 53 31_Re: sqlcode - SQL1403N -UDB DB220_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Tue, 15 Jan 2002 11:34:19 +0100479_iso-8859-1 Hi ROger,

I think that SQL1403N is about userid or passwd incorrect. I also think you should find a lot about this message on the DB2 tech note page, even with possible solution... if I remember well it's possible that the user is defined in the 2k domain but also locally and DB2 is looking to the wrong one... however you should look there to get more informations: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/techlib. d2w/report [...] 1105 65 37_Re: new to os390 DB2 - more questions26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Tue, 15 Jan 2002 03:07:10 -0800409_iso-8859-1 I don't think you need more than 1 database and I would highly recommend 1 table per tablespace or your going to have problems when you need to recover tables. The ONLY time I would ever put more than one table/tablespace is if they are small code tables.(for instance one table with the state abbreviations and 1 table with days of the week abbreviations) This is by no means a BIG database. [...] 1171 229 16_Re: Memory Leaks23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 15 Jan 2002 11:15:26 -0000344_- Hi

what is your region size set to for DBM1? 0M? 0k? other ???

just interested ...

In addition do you have ifcid 225 on ? this will tell you where your storage is being allocated ...

get back to me by private mail if you want.

(by the way rexx for storage will be out tomorrow to all those that asked) [...] 1401 140 55_Re: Re : Drain lock waits during application processing14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 15 Jan 2002 11:42:15 -0000420_iso-8859-1 Not so.

Waiting for a drain lock means someone ELSE has one and whatever YOU want to do, you are prevented from doing so by the drain.

So, something else has drained an object and you are waiting for IT to release the drain lock

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 [...] 1542 148 98_>> I would highly recommend 1 table per tablespace << (was AW: ne w to os390 DB2 - more questions)12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 15 Jan 2002 12:57:37 +0100383_iso-8859-1 >>>>I would highly recommend 1 table per tablespace <<<<

Bill, just to through my cents (yes we're in Euro land now) into the discussion:

A simple TS contains one or more tables. But in general only one table should be defined for one simple TS. Thats okay for the moment.

But why not using segmented tablespaces and/or partitioned tablespaces ? [...] 1691 26 37_Re: Load problem with 'format unload'11_Roland Owen20_roland.owen@UBSW.COM31_Tue, 15 Jan 2002 05:28:19 -0600462_- On Tue, 15 Jan 2002 09:27:43 +1300, Raymond Bell wrote:

>Cheers, Phil. Thanks for the confirmation. I was going to edit the unload >file but I wasn't sure where in the first 6 bytes the OBID was. In the >end, as most of the file was character data, I just shifted it left 6 >characters, knocked up some load cards a la DSNTIAUL and loaded them back >in. But, lesson learnt. I'm starting the TS 'ro' and using DSNTIAUL >instead. [...] 1718 51 31_Re: Personal edition question..11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Tue, 15 Jan 2002 13:39:15 +0100371_us-ascii Hi Geek,

PE & PDE (V7.1) are available on Win, OS/2 and Linux.

As far as I know, the shell influences the work with DB2 only if you run the shel scripts shipped with DB2. These are the profile script for the instance owner, and some app. developing scripts (sqlj, profp, profconv, db2profc). Yes, many of them invokes ksh in its first line... [...] 1770 45 47_Re: ASYNCHORNOUS WRITE ENGINE WITH ADDRESS SPAN14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 15 Jan 2002 07:47:42 -0500552_ISO-8859-1 Jennifer, DB2 can write up to 32 pages for a single asynchrouns write (64 for utilities). Internally, it uses a threshold of 150 CIs as the max range for one write... to try to avoid spanning cylinders. (Somewhat irrelevant if you're on raid devices with large cache). The important factor that comes into play is the average pages/write.... when this is a low single digit % like 1.5, or 2.8, etc, then lower the vdwqt to zero. This will force the writes at 40 pages per object to avoid flooding the system with writers at checkpoint. [...] 1816 74 52_Re: Switching between multiple db2 instances in UNIX11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 15 Jan 2002 08:18:03 -0500481_us-ascii Your DB2 UNIX environment is controlled by file $HOME/sqllib/db2profile ... this file defines the PATH for DB2 and other environment variables. When things work correctly, you could have one userid "switch" from instance1 to instance2 to instance3 by using commands:

$ . /home/instance1/sqllib/db2profile $ . /home/instance2/sqllib/db2profile $ . /home/instance3/sqllib/db2profile

The userid may have different db2 security privileges in each instance. [...] 1891 48 39_Re: CREATE TRIGGER AND STORED PROCEDURE14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 16 Jan 2002 11:16:55 +1000596_ISO-8859-1 Well, what is the definition of HSP02.TRIGP1 and what is the format of SKDBA.PERMPRSN.PRS_EMNO ?

James Campbell

On 14 Jan 2002 at 10:02, ´ö½Òªø wrote:

> HI : > Can someone tell me create trigger and call stored procedure error ?? > CREATE TRIGGER TRIGGER3 AFTER > INSERT > ON SKDBA.PERMPRSN > REFERENCING NEW AS N > FOR EACH ROW > MODE DB2SQL > BEGIN ATOMIC > CALL HSP02.TRIGP1 > (N.PRS_EMNO); > END ! > SQLERROR ON CREATE COMMAND, EXECUTE FUNCTION > RESULT OF SQL STATEMENT: > DSNT408I SQLCODE = -20100, ERROR: AN ERROR OCCURRED WHEN BINDING A TRIGGERED SQL [...] 1940 51 52_Re: Switching between multiple db2 instances in UNIX12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 15 Jan 2002 05:19:11 -0800837_us-ascii The db2ilist command will list all the instances.

To switch instances you will need to execute the "db2profile" for that particular instance, and then connect to that new instance. The db2profile is usually in /home/db2instancename/sqllib.



--- Chintala S Kumar wrote: > Hi List, > May be the question is trivial ! How to switch > between multiple db2 > instances in UNIX? In which diretory we can see the > details of instances in > UNIX? > > Thanks & Best Regards, > Surendar > ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > IBM Global Services India Pvt Ltd, > "The Presidency", #1, St. [...] 1992 50 22_Re: Bind Option: Owner14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Tue, 15 Jan 2002 08:31:54 -0500553_iso-8859-1 The owner part is what I am having a problem with. When I do the initial bind as a DBA the creator column of the sysplan table contains my DBA id so I am assuming that I am the owner of the plan. When a programmer performs the bind(replace) the creator in the catalog table now becomes his id. I don't understand how the programmer is able to perform this action given that we have not granted any bind privileges for programmers in RACF. Currently, the only profiles we have created are for execute authority and a catch-all of DB2T.** [...] 2043 31 30_Upgrade from V6 to V7.2 - Unix10_Rudy Betke19_rite.me@BIGFOOT.COM31_Tue, 15 Jan 2002 07:16:16 -0600347_- We are currently running UDB v6.1 on Unix (Solaris), and want to upgrade to v7.2.

The written V7 Install Instructions seem to cater to those who want to do a brand new install, (i.e. create groups, create instances, etc.) But, I already have a couple of instances and databases from my existing v6. I simply want to Upgrade/Migrate. [...] 2075 32 35_Recover tablespace statements order22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Tue, 15 Jan 2002 11:46:59 -0200446_iso-8859-1 Hello,

I need to recover (tocopy option) all tables from a 150 tables database which has one table per tablespace. Which is the best way to query the catalog and get the sequence of recovery so that dependent tables do not receive a check pending status when RECOVER utility is used? Does anybody have a query for that? The report utility will give me the tablespace set for a given tablespace, but not the recovery order. [...] 2108 73 52_Re: Switching between multiple db2 instances in UNIX18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 15 Jan 2002 08:57:46 -0500477_- We set up one id for each instance. That way you don't have to switch between directories to execute the correct db2profile script.

Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2



-----Original Message----- From: tim malamphy [mailto:timalamphy@YAHOO.COM] Sent: Tuesday, January 15, 2002 8:19 AM To: DB2-L@RYCI.COM Subject: Re: Switching between multiple db2 instances in UNIX [...] 2182 85 52_Re: Switching between multiple db2 instances in UNIX15_Jackson Reavill18_damcon2@US.IBM.COM31_Tue, 15 Jan 2002 09:00:08 -0500371_us-ascii Surendar,

I do it by alternating the DB2 profile entry in my .profile file I will execute when signing on. The .profile file should be in your /u// directory. It looks like the following:

. /home/db200001/sqllib/db2profile

There should be one for each instance created. In my case the instance name is db200001.

HTH, Jay [...] 2268 68 52_Re: Switching between multiple db2 instances in UNIX11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Tue, 15 Jan 2002 15:03:05 +0100535_us-ascii Hi Surendar,

I'm not sure of what you think with switching. Most of the DB2 utilities and commands use the environment variable DB2INSTANCE to determine which instance to work with.

One has to take care regarding the DB2 command line processor (CLP), because the back-end process (db2bp) is the process which actually does the work (and is attached to an instance), not the front end (db2). The back-end cannot change its attachment, so if you want it to attach to another instance, you have to restart it. [...] 2337 65 51_Re : Drain lock waits during application processing11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 15 Jan 2002 09:04:46 -0500533_ISO-8859-1 Warwick

Oh well, it was just a thought!

If you are sure that no other transaction/QMF/SPUFI on any member of the data sharing group is updating partitioning keys, then it cannot be that. Your transaction rate makes it highly unlikely that dataset open/close is the source. Also, I do not see how IRLM storage issues could cause a long claim. Certainly, if a long claim were to occur for another reason then it could be delayed while trying to acquire the drain lock if there were IRLM storage problems. [...] 2403 190 46_SYSUTILX INDEX on ICOPY? status after Recovery10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Tue, 15 Jan 2002 07:12:46 -0700308_iso-8859-1 Hi! List, I just recovered SYSUTILX successfully and got REBUILD INDEX(ALL) return code 4. It looks like SYSUTILX is empty. I don't know if it suppose to be empty or not. Why it put INDEX in ICOPY status? Should I just image copy INDEX to resolve ICOPY status or I need to do something else? [...] 2594 43 39_Re: Recover tablespace statements order7_DB2 DBA21_db2_dba@BELLSOUTH.NET31_Tue, 15 Jan 2002 09:17:38 -0500588_ISO-8859-1 for 150 tablespaces you may want to concentrate on where the datasets are positioned on the tapes. assuming you stack image copy datasets. by doing that you will not cause 150 individual tape mounts. > > From: Claudio Meluzzi Mendes > Date: 2002/01/15 Tue AM 08:46:59 EST > To: DB2-L@RYCI.COM > Subject: Recover tablespace statements order > > Hello, > > I need to recover (tocopy option) all tables from a 150 tables database > which has one table per tablespace. Which is the best way to query the > catalog and get the sequence of recovery so that [...] 2638 82 55_Re: Re : Drain lock waits during application processing16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 15 Jan 2002 09:17:55 -0500529_iso-8859-1 Warwick, We need to do what you are attempting. We have one good SAS programmer and one once-was-good-but-forgot-most-of-it (me). Where we are having trouble is getting the SMF record layouts. They are no longer in the manuals. The only place I see them is in a set of many many undercommented assembler macros in .SDSNMACS. Do you have (and if so could you put on the doc site or email me) the record layouts? I already know how to SAS prog for SMF (I have done this for MVS SMF), but the layouts are a problem. [...] 2721 165 37_Re: new to os390 DB2 - more questions12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Tue, 15 Jan 2002 08:39:15 -0600534_iso-8859-1 I agree with Tim on this. You have to consider the locks as well as the size of a DB2. The old answer is always "It Depends". Rule of thumbs are always a good place to start. But then you need to take into considerations the operations, and performance of the system. The best design from a locking standpoint is to put each table in a tablespace in it's own database. One of the big issues with this is on the operations side. How to maintain and support many databases. The rule of thumb for 50 tables in a database [...] 2887 135 55_Re: Re : Drain lock waits during application processing12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 15 Jan 2002 06:54:08 -0800567_us-ascii Might I recommend you look into Merrill's Guide for MXG. In the book, you will get the SAS code for all the SMF record formats. Besides all the other good stuff in the book, just not having to code the input formats in SAS youself is worth the price. Tim --- "Pearson, Eric L," wrote: > Warwick, > We need to do what you are attempting. > We have one good SAS programmer > and one once-was-good-but-forgot-most-of-it (me). > Where we are having trouble is getting the SMF > record layouts. > They are no longer in the manuals. [...] 3023 109 52_Re: Switching between multiple db2 instances in UNIX12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 15 Jan 2002 07:01:21 -0800632_us-ascii True, but you will have to go through logging in to the other instance. I found that more disruptive than other methods, although you'll always know what instance you're connected to. My preference was to to create multiple .profile scripts for each instance needed in the user's home directory...like .profile1 for db2inst1 (doesn't everyone create their first instance with this name), the .profile2 for db2inst2, etc. Of course the "default" instance that the user wants is still just .profile. --- "Krawetzky, Peter J" wrote: > We set up one id for each instance. That way you > don't have [...] 3133 27 20_CA product RC/Secure18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 15 Jan 2002 10:01:33 -0500417_iso-8859-1 Can anyone tell me if they are using this product from CA with DB2 OS/390?? We're currently at DB2 V6 and CA/Platinum P97F (but we're in the process of upgrading to P99F). I can't seem to find any detailed information on the web, ie; white paper, on this. Only hits I have are a couple of blurps that are about 2 pages long. If anyone is using this I'd be interested to know if its beneficial to you. [...] 3161 68 34_Re: Upgrade from V6 to V7.2 - Unix12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 15 Jan 2002 07:09:15 -0800557_us-ascii yes yes yes

It's pretty automagic. Just make sure you back up your databases AND the home directory of the instance owner before you fire it up. I've never had a problem with an upgrade, but paranoia can be a good thing.

Tim --- Rudy Betke wrote: > We are currently running UDB v6.1 on Unix (Solaris), > and want to upgrade to > v7.2. > > The written V7 Install Instructions seem to cater to > those who want to do a > brand new install, (i.e. create groups, create > instances, etc.) But, I > already have [...] 3230 21 29_more newbie clarifications...14_Michele Payton18_paytonm@US.IBM.COM31_Tue, 15 Jan 2002 08:06:55 -0700564_us-ascii Thank you all for your help. It appears from the answers I have received that using one database may be OK depending on how the tables are used. I will have 8 very active tables, some that will be volatile. There is alot of random access activity that will be supplying "real time" statistics to a GUI on a windows box. It is important that the performance for refreshing the GUI statistics is good. Given this information is one database OK? Also, we are using segmented tablespaces, so is it still recommended that I have one tablespace per table? [...] 3252 155 55_Re: Re : Drain lock waits during application processing16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 15 Jan 2002 10:16:31 -0500378_iso-8859-1 The book is good, but very out of date for DB2 SMF. The part that is up to date is priceless.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: tim malamphy [mailto:timalamphy@YAHOO.COM] Sent: Tuesday, January 15, 2002 9:54 AM To: DB2-L@RYCI.COM Subject: Re: Re : Drain lock waits during application processing [...] 3408 46 24_Re: CA product RC/Secure10_Shery Hepp17_schepp@SRPNET.COM31_Tue, 15 Jan 2002 08:21:58 -0700352_iso-8859-1 Steve- We have it here and do use it. If my recall is correct we had some quirky problems with 97F - but they seemed to be fixed in 99D (which is what version we're currently on). Our data security group uses it quite a bit- but it does come in handy for us DBA's too. Is there something specific you're wondering or just general info? [...] 3455 59 24_Re: CA product RC/Secure16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 15 Jan 2002 10:30:39 -0500520_iso-8859-1 We use this for GRANT/REVOKE. Its masking features save a lot of work. If you want details, email me directly and I will send you my phone number. It does a great job of that (lots of grants with minimal typing). It can copy auths from one user to another. It also has an infrastructure which can allow you to group resources into objects and group users into objects of a different sort then administer at the object level. We were never able to make that work to our satisfaction so abandoned its use. [...] 3515 219 72_A seminar with Sheryl Larsen and Computer Associates - Advanced W arning14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 15 Jan 2002 15:35:12 -0000597_iso-8859-1 Team Up for Leading Edge SQL Performance A seminar with Sheryl Larsen and Computer Associates

When?

Monday Feb 4 Italy -Milan Tuesday Feb 5 Switzerland - Zurich Wednesday Feb 6 Germany - Darmstadt Thursday Feb 7 tba Friday Feb 8 Italy - Rome

Why CA and Sheryl?

To approach the crucial topic of DB2 Performances from different standpoints to make it more practical and more complete. Sheryl as a consultant with good experience in Application Development, CA with all the experience as a Software vendor with long experience on performance optimization. [...] 3735 98 38_Re: SQL0104N error through DB2 connect13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 15 Jan 2002 09:34:37 -0600590_iso-8859-1 Carl,

We had an issue with 104's when we upgraded our clients from v5.2 to v7.1. In our case users of Cognos Impromptu were getting the error. NOSCAN=1 is the default. NOSCAN=0 turns it off.

NoScan forces the CLI driver to scan and strip escape clauses. For some applications e.g. Microsoft, Cognos, escape clauses like "{}" are added to the SQL before being passed to the CLI layer. CLI needs to strip them out before sending those SQL to the DB2 engine, otherwise it will be treated as syntax errors. There shouldn't be a big performance issue because it is [...] 3834 73 39_Re: Recover tablespace statements order22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Tue, 15 Jan 2002 13:45:00 -0200416_iso-8859-1 Ok, in the recover job I took care with that. Furthermore, we use virtual tapes so no human interaction is needed for mounting tapes. But I'm concerned about the fact that if the recoveries are done in a wrong sequency, I'll get a high number of tables in check pending status. This is un undesired scenario for me, because I would just like to run the recover job and get the data ready to be used. [...] 3908 121 36_Installing DB2 with Active Directory13_Ray Briggs II12_ray@LSMP.COM31_Tue, 15 Jan 2002 09:48:32 -0600419_iso-8859-1 Hello:

I have been using DB2 for about 6 months on a Windows 2000 Network. My company is considering going to the Window Active Directory Network and I have been testing DB2's interaction with it. With no Active Directory DB2 has been working beautifully the past few months. We then installed Active Directory on the DB2 server and re installed DB2. Everything on the server seems to work fine. [...] 4030 60 28_CA product RC/Secure (Reply)0_28_Michael.D.Ockenfels@WCOM.COM31_Tue, 15 Jan 2002 09:49:34 -0600736_us-ascii We use it.. It's a great tool for managing BULK grants and revokes. For singleton grants/revokes it's not as great.

Mike Ockenfels DB2 DBA Worldcom









"Whittaker, Stephen" cc: (bcc: Mike Ockenfels/CDR/BSM/MCI) Subject: CA product RC/Secure 01/15/02 09:01 AM Please respond to DB2 Data Base Discussion List













Can anyone tell me if they are using this product from CA with DB2 OS/390?? We're currently at DB2 V6 and CA/Platinum P97F (but we're in the process of upgrading to P99F). I can't seem to find any detailed information on the web, ie; white paper, on this. Only hits [...] 4091 41 52_Re: Switching between multiple db2 instances in UNIX12_Chao Terry F20_Terry.F.Chao@IRS.GOV31_Tue, 15 Jan 2002 10:54:56 -0500105_iso-8859-1 Creating database alias pointing to databases in other instances might also be an alternative. 4133 39 55_Re: Re : Drain lock waits during application processing27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Tue, 15 Jan 2002 15:57:24 -0000472_iso-8859-1 Eric, Don't think I can help much there. I'm relying on MXG to build a "Performance Database" (PDB). I can then use SAS to reference whatever field names I'm interested in. I don't actually have to know much about the record layout itself.

One way round this might be as Tim Malamphy suggests, that is "Merrill's Guide for MXG". Alternatively, the DB2 PM documentation contains information which may help - chapter 27 details the accounting fields. [...] 4173 21 44_Datapropagator v7 on Z/OS release 1 w/DB2 V714_Shari A Thayne24_sathayne@DUKE-ENERGY.COM31_Tue, 15 Jan 2002 10:56:02 -0500472_us-ascii Listers:

I am getting ready to install DPROP V7 and was wondering if anyone else out there has done the install and are there any 'gotyas' that I need to watch out for?

Thanks

Shari Thayne Duke Energy

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4195 86 33_Unknown V7 Abend 00C900CF on COPY13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Tue, 15 Jan 2002 11:03:50 -0500430_US-ASCII List,

I've just migrated a DB2 UDB for z/OS and OS/390 Version 6 subsystem to Version 7. CatMaint worked fine (!), everything worked fine ... until Migration Step 24, "Image Copy the Catalog and Directory".

It bombs on the first step, the COPY of DSNDB01.SYSUTILX. Reason Code is x"00C900CF". This must be new: I can't find it in the online/web version of the M&C. Anyway, here's the complete message: [...] 4282 63 33_Re: more newbie clarifications...15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Tue, 15 Jan 2002 10:05:50 -0600583_iso-8859-1 As someone else said one database is probably OK. The number of databases involved doesn't affect performance except for the loading of the DBD in the EDMPOOL. The access to the table itself isn't affected. A database is only a LOGICAL grouping of tablespaces, not a physical one (except for the DBD but forget that for now.). For your volatile tables, I would put each of them in their own tablespace even if segmented. I would put all them each in their own tablespace actually unless if they are small code tables or something like that. Recovery can be difficult [...] 4346 73 33_Re: more newbie clarifications...0_19_Tim.Lowe@STPAUL.COM31_Tue, 15 Jan 2002 10:07:34 -0600571_us-ascii Michele, I have not heard anything from you yet to indicate that you need more than 1 database. Assuming a segmented tablespace, then the issues with having more than 1 table in a tablespace are use of the LOAD REPLACE and RECOVER utilities. (Load replace does a delete/define on the tablespace, purging rows from all tables in the tablespace. Recover is done on a tablespace, not a table.) If you can guarantee that nobody will EVER attempt to do a LOAD REPLACE on one of these tables, AND that all of the tables in this tablespace can always be recovered [...] 4420 14 43_Re: db2 datasharing migration from v5 to v612_Roger Miller19_millerrl@US.IBM.COM31_Tue, 15 Jan 2002 09:48:15 -0600471_- The details for the install process are in the Data Sharing: Planning and Administration book, rather than in the Installation Guide. I looked a week or so ago and did not find a clear pointer.

Roger Miller, DB2 for z/OS

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4435 118 23_Re: DSNTEP2 Compilation20_Vijayababu Sriramulu34_Vijayababu.Sriramulu@IN.EFUNDS.COM31_Tue, 15 Jan 2002 21:50:41 +0530371_us-ascii Hi James,

Thanks for your response.

We specified the following for the SYSIN.

SYSIN DD * Select * from sysibm.systables /* //

Initially when we tried with this, it failed with the following error. Then we allocated a dataset with LRECL 80 and BLOCKSIZE 3120 with FB and then tried again. Still it is failing with the same error. [...] 4554 18 37_Re: new to os390 DB2 - more questions12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 15 Jan 2002 09:54:12 -0600438_- For people who know other relational DBMS, we built the Introduction to DB2 book to introduce the DB2 for z/OS and OS/390 architecture. Jim Wankowski's architecture comparison is useful as well. The library is easy to get from the web, start at ibm.com/software/db2os390 Click on Library, choose the verion and book. The Introduction book is only in V7 and only in html form. It's published, so it can be purchased in book stores. [...] 4573 68 44_More On Installing DB2 with Active Directory13_Ray Briggs II12_ray@LSMP.COM31_Tue, 15 Jan 2002 10:20:46 -0600288_iso-8859-1 Another possible problem is the server machine is part of the DOMAIN LSMP but the client machine is not part of the domain. Could that be the problem? Has anyone gotten DB2 to work on a mixed environment or does it all have to be Active Directory or Non Active Directory. [...] 4642 20 20_Bufferpool Hit Ratio14_Curran, John F29_john.f.curran@UK.FID-INTL.COM31_Tue, 15 Jan 2002 16:31:29 -0000407_iso-8859-1 Hi

Does anybody know the correct calculation for the bufferpool hit ratio in an AIX environment

Thanks in advance



John Curran

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4663 71 55_Re: Re : Drain lock waits during application processing16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 15 Jan 2002 11:28:57 -0500411_iso-8859-1 Thanks for the DB2PM pointer. We use other products to do the DB2PM so I've not visited the DB2PM doc.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: ROBINSON, Warwick, MANU ITI [mailto:Warwick.Robinson@NATWEST.COM] Sent: Tuesday, January 15, 2002 10:57 AM To: DB2-L@RYCI.COM Subject: Re: Re : Drain lock waits during application processing [...] 4735 61 19_Update SQL Question22_Augustine, Jobi M B22524_Jobi.Augustine@CIGNA.COM31_Tue, 15 Jan 2002 11:29:06 -0500411_iso-8859-1 Hi Group,

We have added a new column to a table (CLIENTID in Table1) and it has to be populated from the value in another table (CDS_CLIENT_ID in Table2) . Is there an easy way to Update this other than writing a program !!

The CLIENT_ID in Table1 is the new column that we added and it has to be updated with the corresponding CDS_CLIENT_ID for the matching SIDs from the Table2. [...] 4797 97 34_Re: Upgrade from V6 to V7.2 - Unix15_Janardhan Ragam16_sragam@YAHOO.COM31_Tue, 15 Jan 2002 08:31:34 -0800564_us-ascii for question # 3,

to upgrade your instance and db from v6 to v7 you will have to run db2imigr (for instance migration) followed by "migrate database" (for database migration)

Sai.

--- tim malamphy wrote: > yes > yes > yes > > It's pretty automagic. Just make sure you back up > your databases AND the home directory of the > instance > owner before you fire it up. I've never had a > problem > with an upgrade, but paranoia can be a good thing. > > Tim > --- Rudy Betke wrote: > > We [...] 4895 222 55_Re: Re : Drain lock waits during application processing27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Tue, 15 Jan 2002 16:33:42 -0000501_iso-8859-1 Mmm yes. I understand your point Phil, and I was thinking along these lines for a while. Certainly this would be consistant with the report output, except that in a performance test having (almost) exclusive use of a data sharing group, who is holding the drain locks for which I'm waiting ? Analysis of all users during the test period shows none of them making any drain requests at all. And, the only process showing a non-zero drain lock wait time is my insert (CICS) transaction. [...] 5118 145 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery0_18_mebert@AMADEUS.NET31_Tue, 15 Jan 2002 17:43:17 +0100503_us-ascii Grace

DB2 V6 has the new Index Copy feature (pretty useless, IMHO, except possibly for very big & inactive indexes). Because you cannot do ALTERs on DSNDB01 objects (because they are not in the Catalog), indexes on the Directory TSs have the COPY YES feature by default (so you can Image Copy them if you decide you want to). After REBUILDing or REORGing them, the ICOPY (Informational Copy Pending) state is set. Simply ignore it, or use the REPAIR utility to set them NOCOPYPEND. [...] 5264 47 39_Re: Recover tablespace statements order11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 15 Jan 2002 11:43:34 -0500445_ISO-8859-1 Claudio

If you use RECOVER ... TOCOPY then dependent tablespaces will go CHKP and there is no way you can stop it. To avoid CHKP you must recover related tablespaces to a common Quiesce point using

RECOVER TABLESPACE ts1 TABLESPACE ts2 ... TORBA ...

Regards Mike Turner Email: michael_turner@compuserve.com Web: www.michael-turner.ltd.uk

Message text written by DB2 Data Base Discussion List > Hello, [...] 5312 66 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 15 Jan 2002 11:50:32 -0500629_ISO-8859-1 Grace

Yes, just image copy the indexes to remove the ICOPY status. You can still use the indexes even though they are in ICOPY, so it is not necessary to copy the indexes immediately.

Regards Mike Turner Email: michael_turner@compuserve.com Web: www.michael-turner.ltd.uk

Message text written by DB2 Data Base Discussion List >Hi! List, I just recovered SYSUTILX successfully and got REBUILD INDEX(ALL) return code 4. It looks like SYSUTILX is empty. I don't know if it suppose to be empty or not. Why it put INDEX in ICOPY status? Should I just image copy INDEX to resolve ICOPY status or I [...] 5379 172 37_Re: Unknown V7 Abend 00C900CF on COPY27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Tue, 15 Jan 2002 16:55:25 -0000546_iso-8859-1

Lockwood, Not sure how helpful this URL will be as it refers to v5 object attributes not supported by v6 or 7. Given that you're moving from v6, I'm sceptical that this is the explanation you're looking for.

Good luck anyway.

http://www-1.ibm.com/support/manager.wss?rs=64 &rt=0&org=SW&doc=1030911



Regards, Warwick

Integration Performance Project Direct Dial : 020 7714-5421 ITS: 78003-5421 Mobile : 07980 829270 [...] 5552 88 23_Re: Update SQL Question11_David Nance16_DWNance@FHSC.COM31_Tue, 15 Jan 2002 11:57:06 -0500565_ISO-8859-1 Jobi, The easiest way to do this would be to perform an unload with SQL, then reload the table with the value. The sql would look something like:

select table1.columns ,table2.CDS_CLIENT_ID as client_id from table1 ,table2 where stable1.sid = table2.sid

>>> Jobi.Augustine@CIGNA.COM 01/15/02 11:29AM >>> Hi Group,

We have added a new column to a table (CLIENTID in Table1) and it has to be populated from the value in another table (CDS_CLIENT_ID in Table2) . Is there an easy way to Update this other than writing a program !! [...] 5641 93 41_Re: more newbie clarifications...addendum15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Tue, 15 Jan 2002 11:06:34 -0600538_iso-8859-1 With further reflection I realize that my answer about performance is the typical sysprogs response. Data Modelers out there may be groaning. By the time I may see a troubled application the design has already been done. We have to pull out our bag of tricks to fix it. This doesn't mean that you should do what you want and the sysprogs can fix it. Table design is a murky area for me. I know that there are good rules of practice out there. I just don't know what they are right now. Again, Craig Mullins book can be of [...] 5735 70 39_Re: Recover tablespace statements order22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Tue, 15 Jan 2002 15:18:41 -0200568_iso-8859-1 Thank you Mike. This explains why my RECOVER job does not work without leaving tablespaces with CHKP status.

Regards, Claudio **************************************** Claudio Meluzzi Mendes BEG - Banco do Estado de Goias BRAZIL claudio@beg.com.br cmeluzzi@uol.com.br ****************************************



----- Original Message ----- From: "Mike Turner" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, January 15, 2002 2:43 PM Subject: Re: Recover tablespace statements order [...] 5806 143 34_Re: Upgrade from V6 to V7.2 - Unix11_Judy Kibler21_judith.kibler@TRW.COM31_Tue, 15 Jan 2002 11:21:30 -0600565_us-ascii Rudy,

Like you, I found the Quick Beginnings guide to be a bit ambiguous for those who were performing an upgrade, rather than a new installation. You sort of have to do a little from this chapter, then jump to another chapter, and so on.

I just upgraded from v6 to v7 but on AIX, so I am hesitant to speak to your questions specifically. Although, in Chapter 1 of the Quick Beginnings manual (Planning for Installation...which is not platform specific), I believe it says that if you are going from v6 to v7, you do not have to migrate [...] 5950 20 21_Sytem Temporary Space11_Ed Mullikin17_emullikin@SCU.EDU31_Tue, 15 Jan 2002 09:25:56 -0800549_US-ASCII As anyone added another container to system temporary space with the alter tablespace command DB2 7.2 Unix? Don't believe DB2 will let me. Do all containers of a system temporary space have to be defined at time of creation of tablespace?

Thanks for any help Ed Mullikin Santa Clara University

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5971 57 45_Re: Compilation problem with Stored Procedure31_Ramakrishnan Chandraseharapuram41_Ramakrishnan_Chandraseharapuram@USSWI.COM31_Tue, 15 Jan 2002 23:29:11 +0530424_ISO-8859-1 Hi Group,

I am getting an sqlca.sqlcode = "-180" on EXECUTE. can anyone help me with this? sqlca.sqlstate = 1085573443

SP is written in C and am running it from the SP Builder

Thanks, CP

-----Original Message----- From: James Campbell [mailto:jacampbell@ACSLINK.NET.AU] Sent: Tuesday, January 15, 2002 7:01 AM To: DB2-L@RYCI.COM Subject: Re: Compilation problem with xlc compiler [...] 6029 88 23_Re: Update SQL Question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 15 Jan 2002 12:05:10 -0600437_iso-8859-1 Jobi,

Or even simpler is to run a single update:

UPDATE TABLE1 SET CLIENT_ID = (SELECT CDS_CLIENT_ID FROM TABLE2 WHERE TABLE2.SID = TABLE1.SID)

There's no WHERE clause, so every row gets updated. And the subquery must return a single row (so may need DISTINCT or column function). Next issue is dealing with NULLs if the subquery does not find a match (that will be in another email if you need it). [...] 6118 42 25_Re: Sytem Temporary Space18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 15 Jan 2002 13:16:15 -0500376_- IBM's recommendation for system temp space is SMS. It will use the total amount of space allocated to the filesystem.

We decided to use DMS for temp space. I have added containers without any problems. Are you getting an error message?

Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2 [...] 6161 15 22_bind/execute authority14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Tue, 15 Jan 2002 13:23:47 -0500309_iso-8859-1 I was just read through some of the archives regarding binding and found a statement that someone made stating that granting execute authority on the packages means you have granted the ability to bind it. Is this true? How about for plans? I thought that was what the BIND authority was for. [...] 6177 233 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Tue, 15 Jan 2002 11:27:16 -0700345_iso-8859-1 Hi Michael,

Thanks for your reply. Now I know everything is ok. For resolving

ICOPY status, I used COPY INDEXSPACE to backup the the two indexes that

SYSUTILX has. The job was looking for an archive log which was created long

time ago. I didn't recall(via DFHSM) the archive log back and IC job still [...] 6411 71 45_Re: Compilation problem with Stored Procedure0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 15 Jan 2002 12:54:12 -0600324_iso-8859-1 Take a look at the date string that you are passing to the SQL, it is not in a format that DB2 recognizes.

-180 THE DATE, TIME, OR TIMESTAMP VALUE value IS INVALID

Explanation: The length or string representation of a DATE, TIME, or TIMESTAMP value does not conform to any valid format. [...] 6483 145 23_Re: Update SQL Question22_Augustine, Jobi M B22524_Jobi.Augustine@CIGNA.COM31_Tue, 15 Jan 2002 14:06:07 -0500485_iso-8859-1 Hi Terry,

Thanks for your reply and it is greatly appreciated.

If you could send the next part of your answer to deal with NULLs if the subquery does not find a match will be very helpful.

Thanks to everybody who responded to this question.

Thanks and best regards,

a Jobi Augustine CIGNA Systems - ES IM &T * Tel (860) 226-5466 (6-5466) * Fax (860) 226-5344 (6-5344) * Mail jobi.augustine@cigna.com [...] 6629 37 38_Re: Client to OS390 Connection Problem13_Leo Conchello17_lconche@QWEST.COM31_Tue, 15 Jan 2002 12:19:22 -0700620_us-ascii Hi Fernando,

Did you run successfully the Binds to the Target Database using the Client Configuration Assistant?

Regards,

Leo

Fernando Manching wrote:

> I am trying to connect a NT workstation client to OS390 V.7 and having > difficulty making the connection. When I use DB2 Connect 7.2 through Control > Center or Command Center, it says "connecting to database" but it just hangs. > When I look at the threads in the OS390 side, I see a connection from the > workstation in a create thread status but the connect never completes. Does > anybody have a similar problem? [...] 6667 61 25_Re: Sytem Temporary Space11_Ed Mullikin17_emullikin@SCU.EDU31_Tue, 15 Jan 2002 11:19:31 -0800457_US-ASCII Peter, Receive error msg "SQL0281N cannot be altered with additional containers because it is a system managed table space". Looks like I need to create another system TEMPSPACE2 and specify all the containers at creation time then drop old TEMPSPACE1.

Thanks, ED

>>> KrawetzkyPJ@AETNA.COM 01/15/02 10:16AM >>> IBM's recommendation for system temp space is SMS. It will use the total amount of space allocated to the filesystem. [...] 6729 72 48_Re: Datapropagator v7 on Z/OS release 1 w/DB2 V713_Moss, William15_MossW@AETNA.COM31_Tue, 15 Jan 2002 14:26:55 -0500352_- Shari,

Are you upgrading to Dprop V7 from another version of Dprop or are you installing it for the first time ?

I have successfully upgraded Dprop V6 to Dprop V7 in a DB2 V7 subsystem, but the upgrade is nearly the same as the installation. If you are upgrading, run this SQL to find tables that could have a problem in Dprop V7: [...] 6802 92 45_Re: Compilation problem with Stored Procedure31_Ramakrishnan Chandraseharapuram41_Ramakrishnan_Chandraseharapuram@USSWI.COM31_Wed, 16 Jan 2002 01:08:17 +0530426_ISO-8859-1 the date string is in the correct format......i tried '25/11/2001' and '25-11-2001'.....but now i am getting sqlca.sqlcode = "-181"...???............moreover, it is only when i am passing values to the Stored Procedure that the error occurs.........when the values are hard coded there is no problem.......and i checked the resulting query when the values are passed......i cant find any anomaly there too.... [...] 6895 19 38_Using ADO.net with DB2 Connect - Help!22_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM31_Tue, 15 Jan 2002 11:44:33 -0800384_iso-8859-1 Folks, I am scurrying to respond to my management one way or the other if DB2 Connect will work with ADO.net. About 6 months ago, I got ADO working with 7.2 RTC (run time client) and 7.2 Connect server (for a VB application). The newer ADO.net had some problems. Can somebody please enlighten me if they have newer info on compatibility with ADO.net... Thanks! Ramesh [...] 6915 45 30_bind/execute authority (Reply)0_28_Michael.D.Ockenfels@WCOM.COM31_Tue, 15 Jan 2002 13:43:42 -0600478_us-ascii Package binding and executing can be granted together by granting the PACKADM privilege. Or,. either of the two (bind or execute) can be granted individually Execute-only doesn't imply bind privileges.

Mike Ockenfels Worldcom







Melissa Rogers cc: (bcc: Mike Ockenfels/CDR/BSM/MCI) Subject: bind/execute authority 01/15/02 12:23 PM Please respond to DB2 Data Base Discussion List [...] 6961 28 39_Limit users' access to the DB2 catalog?11_Judy Kibler21_judith.kibler@TRW.COM31_Tue, 15 Jan 2002 13:51:38 -0600527_us-ascii Hello all,

I have created views on some tables in one of our production databases. Next I created an aix id and to that id, I granted select only privileges to those views I created. The purpose of this id and these views is to allow some of our users read-only access to this data via Microsoft Access. They will open an Access database, then use the DB2 ODBC driver to link to the DB2 tables from there. The only id they will be able to do this with is the id I set up and granted select only privileges [...] 6990 77 25_Re: Sytem Temporary Space18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 15 Jan 2002 14:54:44 -0500411_- Yes, that is one solution. What about adding additional space to your filesystem?

Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2 (860) 273-0301



-----Original Message----- From: Ed Mullikin [mailto:emullikin@SCU.EDU] Sent: Tuesday, January 15, 2002 2:20 PM To: DB2-L@RYCI.COM Subject: Re: Sytem Temporary Space [...] 7068 108 23_Re: Update SQL Question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 15 Jan 2002 14:02:03 -0600393_iso-8859-1 Jobi,

If you do get NULLs, then you may want to look at APAR PQ48584. There is a problem in V6 with all rows being set to NULL after the first NULL.

V6 doesn't allow you to put the COALESCE outside the SELECT (I haven't tried this in V7 yet), but non-mainframe does. So to avoid NULLs, you need to code an existance subquery to ensure each row is found, such as: [...] 7177 106 45_Re: Compilation problem with Stored Procedure14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Tue, 15 Jan 2002 14:11:08 -0600693_iso-8859-1 use ccyy-mm-dd

-----Original Message----- From: Ramakrishnan Chandraseharapuram [mailto:Ramakrishnan_Chandraseharapuram@USSWI.COM] Sent: Tuesday, January 15, 2002 1:38 PM To: DB2-L@RYCI.COM Subject: Re: Compilation problem with Stored Procedure



the date string is in the correct format......i tried '25/11/2001' and '25-11-2001'.....but now i am getting sqlca.sqlcode = "-181"...???............moreover, it is only when i am passing values to the Stored Procedure that the error occurs.........when the values are hard coded there is no problem.......and i checked the resulting query when the values are passed......i cant find any anomaly there too.... [...] 7284 134 45_Re: Compilation problem with Stored Procedure0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 15 Jan 2002 14:20:02 -0600415_us-ascii Well, sqlcode -181 still means that DB2 is not happy with the date/time string you are trying to, I presume, insert.

-181 THE STRING REPRESENTATION OF A DATETIME VALUE IS NOT A VALID DATETIME VALUE

Explanation: The string representation of a datetime is not in the acceptable range or is not in the correct format. The proper ranges for datetime values are as follows: [...] 7419 57 43_Re: Limit users' access to the DB2 catalog?18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 15 Jan 2002 15:22:28 -0500328_- If you have limited their access to specific views via the new id, why would it matter if they can see the table names? They won't have select rights, prevents them from connecting the table in Access and seeing the data.

I don't believe there is a way to filter out tables which you don't have select rights too. [...] 7477 145 45_Re: Compilation problem with Stored Procedure13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Tue, 15 Jan 2002 12:32:14 -0800680_us-ascii Hi,

Check and see what is your installation-defined format for String Representations of Dates. If it is USA, then the format is 'mm/dd/yyyy' where you are passing it 'dd/mm/yyyy' which is EUR format. This would explain the -181 as DB2 is interpreting it as month 25.

Tink --- Ramakrishnan Chandraseharapuram wrote: > the date string is in the correct format......i > tried '25/11/2001' and > '25-11-2001'.....but now i am getting sqlca.sqlcode > = > "-181"...???............moreover, it is only when i > am passing values to the > Stored Procedure that the error occurs.........when > the values are hard > [...] 7623 40 15_DCLGEN and LOBs14_Per Callerstal22_per.callerstal@MIPS.SE31_Tue, 15 Jan 2002 14:20:16 -0600303_- Hi all,

I've tried a search on the list but didn't find anything similar.

We are running DB2 6.1 (OS/390), and have a table with a LOB COLX BLOB 50K. The table + table space + LOB tablespace + index for LOB have all been created. We have also successfully loaded the table (space). [...] 7664 53 57_Re: Triggers do not execute stored procedure DB2/V7 OS39029_H=?ISO-8859-1?Q?=E5kan?= Roll18_hakan.roll@EDS.COM31_Tue, 15 Jan 2002 14:30:35 -0600633_ISO-8859-1 Hi Kirk,

Thank you for your help. We have now verified that your first guess were right. After putting "SET CURRENT PACKAGESET" in stored procedure to same as batch program it works OK.

Regards Håkan and Sven

On Thu, 20 Dec 2001 17:38:46 -0600, khampto1@TXU.COM wrote:

>Hi Hakan and Sven, > we have done several stored procedures executed by triggers, and >they are invariably a pain to diagnose. I suspect you will find a problem >either with collection names that the stored procedure package runs under, >being a different collection than the one that the trigger fired under, >or some [...] 7718 91 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 15 Jan 2002 14:54:49 -0600358_us-ascii Because those indexes set to COPY YES. You can as well set to no, just alter that tablespace with COPY NO. You are not required to toke image copy on these indexes , it is just informational copy pending status. Or else you can add a step for image copy on those indexes in the same job, so that next time you will not get same ICOPY statuses. [...] 7810 55 43_Re: Limit users' access to the DB2 catalog?11_David Nance16_DWNance@FHSC.COM31_Tue, 15 Jan 2002 16:18:38 -0500572_US-ASCII Judy, What about a view for systables? That way you define which tables the user sees.

>>> judith.kibler@TRW.COM 01/15/02 02:51PM >>> Hello all,

I have created views on some tables in one of our production databases. Next I created an aix id and to that id, I granted select only privileges to those views I created. The purpose of this id and these views is to allow some of our users read-only access to this data via Microsoft Access. They will open an Access database, then use the DB2 ODBC driver to link to the DB2 tables from there. The [...] 7866 25 17_V6 Index Question25_Cavanaugh, Michael S H05N27_Michael.Cavanaugh@CIGNA.COM31_Tue, 15 Jan 2002 16:30:03 -0500721_us-ascii In DB2 Version 6 (OS390) is there any performance benefit to be had by ordering an index column DESCENDING if SELECT MAX's are to be done against it? Or would it be too miniscule to notice? (Versus ASCENDING of course?) Thanks for any help.

Mike





------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from [...] 7892 73 57_Backup/Recovery questions; Tools and Utilities comparison22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Tue, 15 Jan 2002 15:43:08 -0600522_- Dear listeners,

We're a soon-to-be-DB2 (V7.0 on OS/390) shop. I have the following questions:

1. Backup and Recovery

Currently, we do full volume dumps of all our production volumes using Flashcopy(FC) on Shark. We currently take about an hour to backup 365 volumes onto their FC targets and then dump them onto tapes later. Can we do the same thing when we go to DB2? What are the advantages/disadvantages? Is there anyone doing this? If so, have you encountered any problems during recovery? [...] 7966 51 21_Re: V6 Index Question11_David Nance16_DWNance@FHSC.COM31_Tue, 15 Jan 2002 16:52:13 -0500362_ISO-8859-1 Well, the classic answer "It depends" applies. It will really depend on your index structure, but for the most part, yes it will help. What I mean by your index structure, the column you are doing the max function against, does it have the possibility of a very large number of variables in the column or will it typically be one or two entries? [...] 8018 87 21_Re: V6 Index Question16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Tue, 15 Jan 2002 15:05:05 -0700560_iso-8859-1 Mike,

For the most part there could be a considerable performance benefit of specifying an index column in descending order in the case you cited. Depending on the nature of the MAX function, you may be able to achieve a one fetch index access. Conversely, if the indexed column specified by SELECT MAX(XXX) were in ascending order, then a non-matching index scan would be necessary to return the result set, and depending on the number of leaf pages AND current leafdist value, this could potentially take a substantial amount of time. [...] 8106 59 31_Re: Personal edition question..15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM31_Tue, 15 Jan 2002 14:08:28 -0800283_us-ascii You need to check to see if there is a version of UDB Personal Edition for UNIX. I know that there is a version of UDB Personal Edition for Liniux. The Korn shell is part of UNIX and a version of this shell is part of Linux. IBM is really pushing using UDB with Linux. [...] 8166 74 21_Re: V6 Index Question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 15 Jan 2002 16:25:26 -0600417_us-ascii Michael,

Potentially yes. If you have equals predicates on all preceding columns of the index before the MAX column, then DB2 can perform an index one-fetch, if the column is defined as DESC. In V7, DB2 can perform a I1 fetch for MAX or MIN, ASC or DESC.

Pre-V7, if the column is ASC, then DB2 must scan all values (within the range of preceding equals predicates) until it finds the MAX. [...] 8241 84 43_Re: Limit users' access to the DB2 catalog?11_Judy Kibler21_judith.kibler@TRW.COM31_Tue, 15 Jan 2002 16:45:56 -0600482_us-ascii David,

I thought about that, but how do I get the view that I would create to be what he uses to access the catalog table?

Thanks, Judy







David Nance on 01/15/2002 03:18:38 PM

Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc: (bcc: Judy Kibler/Nashville)





Subject: Re: Limit users' access to the DB2 catalog? [...] 8326 96 43_Re: Limit users' access to the DB2 catalog?11_Judy Kibler21_judith.kibler@TRW.COM31_Tue, 15 Jan 2002 16:48:24 -0600329_us-ascii Peter,

Truth? If they saw it out there, they would want access to everything! This is an OLTP database that we are going to tentatively allow a small number of users access to a small number of tables that they will be using in a decision support fashion. Yikes! That is why I'd like to limit what they see. [...] 8423 32 26_Update vs query subsystems18_Adrian Engelbrecht37_Adrian_Engelbrecht@WESTPACTRUST.CO.NZ31_Wed, 16 Jan 2002 11:46:07 +1300614_us-ascii Some shops are of the opinion that the only way to exclude / control adhoc queries from a production OS390 DB2 subsystem is to create a copy of that region for queries, and refresh the data regularly (with associated overhead and redundancy).

If you have developed a "smarter" way of doing this within one DB2 subsystem, and achieved control of heavy queries, giving priority to production transactions, please let me know how? I am particularly interested to know of ways to allow users to perform their analysis at any time, yet control the amount of resource they consume without impacting [...] 8456 28 46_UDB V7.2 (aix) to DB2 v6 (os/390) connectivity0_24_lightsey@ITS.STATE.MS.US31_Tue, 15 Jan 2002 17:04:34 -0600344_us-ascii Is this do-able ? The db2 on aix is 7.1 with fp3 applied, on os/390 it's v6 with pretty recent maintenance applied ( August 2001 or there-about ). The error message being received is sql5048n on the connect from aix and the db2mstr shows dsnl032i reason=00d3101c.

Surely someone is doing this type connection successfully. [...] 8485 15 17_DSNC STOP problem16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Tue, 15 Jan 2002 15:23:00 -0800384_- We have a CICS transaction(non terminal) with a non-DB2 program calling a DB2 pgm. The DB2 program does a SYNCPOINT before returning to the caller who just waits for TCP/IP input. The problem is that the DSNC STOP command hangs and CICS can't terminate. CICS is CTS 1.3. DB2 is V6. Plan is bound with RELEASE(COMMIT). Pool threads are used. What could be causing this problem? [...] 8501 195 102_Re: >> I would highly recommend 1 table per tablespace << (was AW: ne w to os390 DB2 - more questions)15_Stephen Mallett25_Stephen.Mallett@NT.GOV.AU31_Wed, 16 Jan 2002 09:01:20 +0930563_iso-8859-1 Of course there's always exceptions. The last project I worked on had about 20 tiny code tables defined in a single tablespace and it worked well (so long as Production Support didn't try loading one of them with a LOAD REPLACE ;-). It was originally designed by the Senior DBA as a simple tablespace so that all the data would be accomodated on a single DB2 page (and more importantly required a single Getpage to read all 20 tables into the Buffer Pools). Unless the buffer was flushed all 20 tables, which had a lot of READ activity would stay [...] 8697 67 30_Re: Update vs query subsystems12_Raymond Bell17_rbell@NZ1.IBM.COM31_Wed, 16 Jan 2002 12:32:16 +1300407_us-ascii I'm thinking of a word that starts with B and ends in ollocks. OK, maybe a bit harsh, but I think you can do it with judicious use of Workload Manager, the DB2 (and maybe QMF) Governor and using 'with UR' a lot. WLM's outside my area of expertise but I believe it can be set quite granular(ly?). Admittedly having a common OLTP and MIS subsystem isn't, er, common, but I think it can be done. [...] 8765 69 37_Re: Unknown V7 Abend 00C900CF on COPY12_Steve Howell23_HOWELLS@STGEORGE.COM.AU31_Wed, 16 Jan 2002 10:44:43 +1100383_us-ascii Lockwood,

Have a look at APAR PQ38035/uq51242, this apar introduced the reason code RC00C900CF.

We had this problem in one subsystem and it turned out to be a flag indicating a type 1 index on the directory. Interesting given that we were on V6 and running succesfully. With Ibm's help we executed the necessary utilities and we now don't have a problem. [...] 8835 42 43_Problems invoking a function with a literal10_Ben Dissen22_Ben.Dissen@NEONSYS.COM31_Tue, 15 Jan 2002 18:04:49 -0600570_iso-8859-1 The function is defined as

CREATE FUNCTION FUNC1(CHAR(6))

When invoked as

SELECT FUNC1('123456') FROM table

I get

DSNT408I SQLCODE = -440, ERROR: NO FUNCTION BY THE NAME FUNC1 HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH DSNT418I SQLSTATE = 42884 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXORFN SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF9C' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION [...] 8878 61 37_Re: Load problem with 'format unload'12_Raymond Bell17_rbell@NZ1.IBM.COM31_Wed, 16 Jan 2002 13:41:01 +1300493_us-ascii Hi Roland,

Ideally I wanted to create the table with the OBID from the unloaded file, but I didn't know where to find it (I do now). I checked 'unload external' and it generates some handy-looking cards including, as you say, the OBID.

Thanks for the tip,



Raymond





Roland Owen cc: Sent by: DB2 Subject: Re: Load problem with 'format unload' Data Base Discussion List [...] 8940 170 30_Re: Update vs query subsystems13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 15 Jan 2002 16:47:33 -0800552_iso-8859-1 We're in a similar situation. We're building up a data warehouse which will some day satisfy our users' ad hoc reporting needs, but it's not quite there yet. WLM has not filled the bill for us, because most of our ad hoc queries come in through TSO (PRF), and WLM cannot distinguish normal TSO from a DB2 query that's going to kill online response time. I recently implemented DB2 v6, so I've been playing with the predictive governor in my spare time, but so far I haven't been able to spare much time, and thus haven't got it to work [...] 9111 68 19_Re: DCLGEN and LOBs10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 16 Jan 2002 12:08:50 +1100482_us-ascii Per,

Please have a look at APAR PQ52915. This problem has been fixed.

U can search for problems in the APAR database at http://techsupport.services.ibm.com/server/390.CAPARdb

Cheers, Kals

-----Original Message----- From: Per Callerstal [SMTP:per.callerstal@MIPS.SE] Sent: Wednesday, January 16, 2002 7:20 AM To: DB2-L@RYCI.COM Subject: DCLGEN and LOBs

Hi all,

I've tried a search on the list but didn't find anything similar. [...] 9180 35 24_Re: Bufferpool Hit Ratio14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 15 Jan 2002 20:17:28 -0500388_ISO-8859-1 A "buffer pool" hit ratio calculation should be the same for all environments.

Using OS/390 terminology...

(getpages - (sum of all pages read into the pool))/getpages * 100

Regards, Joel



Message text written by DB2 Data Base Discussion List > Does anybody know the correct calculation for the bufferpool hit ratio in an AIX environment [...] 9216 22 37_Re: Load problem with 'format unload'12_Raymond Bell17_rbell@NZ1.IBM.COM31_Wed, 16 Jan 2002 14:54:22 +1300557_us-ascii Just an update, for whoever's interested. I redid my partitioning testing, putting the Dev TS back to segmented and partitioned it again using Reorg Unload Only instead of DSNTIAUL - works a treat. I also fired off a DSNTIAUL and Reorg Unload Only job for the eventual target table in Prod (cancelling them both well before completion). Of my 11.4m row table, DSNTIAUL unloaded 2m rows in 25 minutes elapsed and 390 seconds CPU, while Reorg Unload Only unloaded 5m rows in 8 minutes elapsed and 160 CPU seconds. Guess which one I'll be using? [...] 9239 56 50_Re: UDB V7.2 (aix) to DB2 v6 (os/390) connectivity15_Janardhan Ragam16_sragam@YAHOO.COM31_Tue, 15 Jan 2002 22:08:54 -0800598_us-ascii Yes.

Sounds like your error is due to incorrect dcs entry on the gateway(per os/390 reason code)? have you verified it?

Sai J Ragam.





--- lightsey@ITS.STATE.MS.US wrote: > Is this do-able ? > The db2 on aix is 7.1 with fp3 applied, on os/390 > it's v6 with pretty > recent maintenance applied ( August 2001 or > there-about ). > The error message being received is sql5048n on the > connect from aix and > the db2mstr shows dsnl032i reason=00d3101c. > > Surely someone is doing this type connection > successfully. > > Thanks, > > Bruce Lightsey > [...] 9296 42 47_Re: Problems invoking a function with a literal14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Wed, 16 Jan 2002 07:34:03 +0100 9339 63 47_Re: Problems invoking a function with a literal10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 16 Jan 2002 18:14:47 +1100308_us-ascii Ben,

When u code the literal, it takes it as a varchar field, and hence ur function is not able to be located. (as ur function is created with a char field)

U can try coding it as substr('123456',1,6) if u find it easier. Or u can define ur function parameter as a varchar field. [...] 9403 53 22_Re: Bind Option: Owner10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 16 Jan 2002 18:33:55 +1100496_us-ascii Melissa,

I am not fully familiar with how RACF security is implemented with respect to DB2. But just to be sure, have u checked up the accesses in the SYSIBM tables ? (PACKAUTH, USERAUTH, PLANAUTH, etc) for any entries in the GRANTEE columns, for the programmer ?



Cheers, Kals

-----Original Message----- From: Melissa Rogers [SMTP:mrogers@NYSTRS.STATE.NY.US] Sent: Wednesday, January 16, 2002 12:32 AM To: DB2-L@RYCI.COM Subject: Re: Bind Option: Owner [...] 9457 100 22_Re: Bind Option: Owner17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Wed, 16 Jan 2002 09:39:58 +0100311_us-ascii Check with yuor RACF Adm about the RACF groups where programmer is in.

If , for example, he's in the group named "groupxx" and there's a DB2 catalog grant to this user (user for DB2 but RACF group fo RACF) he's got the auth.

A single userid could be included in several RACF groups. [...] 9558 91 61_Re: Backup/Recovery questions; Tools and Utilities comparison10_Ali OZTURK27_Ali.OZTURK@PAMUKBANK.COM.TR31_Wed, 16 Jan 2002 11:48:43 +0200454_iso-8859-9 I think, you can not recover db2 objects to current point in time or point in time if you use FC for db2 backup. Did you test this method for recovery ? You should take imagecopy for db2 objects to current point in time recovery. You can start imagecopy with sharelevel change before the batch window.At the starting point for batch window, you can get quiesce point for the objects also. So,you can recover the db2 objects to any point. [...] 9650 120 70_Hot Application Tuning with Horacio Terrizano and Computer Associ ates14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 16 Jan 2002 10:28:49 -0000569_iso-8859-1 By popular demand Computer Associates UK has again started it's DB2 seminar series, the first set of seminars take place in March. DB2 performance is now more than ever at the forefront of most DBA's minds. This is due to the pressure that most DBA's have in trying to get DB2 to handle 24x7 and e-business applications, which means that DB2 is being stretched to its limits and still having to perform as efficiently as ever. During this seminar we look at ways how to get DB2 running more efficiently which translates into "Doing more with the same". [...] 9771 140 39_Re: Recover tablespace statements order14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 16 Jan 2002 10:38:50 -0000469_iso-8859-1 Unless you run the recoveries in ONE recover statement (which you probably don't want to do since it can compromise parallelism, depending on the version of DB2 you are on (unless you are using 3rd party recover utilities)) you will probably always get something in Check pending.

If you are truly 100% sure that you are always recovering the tablespace set to a consistent point, use the REPAIR utility to turn off any "spurious" check pendings [...] 9912 142 37_Re: Load problem with 'format unload'14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 16 Jan 2002 10:54:55 -0000329_iso-8859-1 In case anyone is interested, recently one of our field people had to help with the unload/reload of a 1 billion row table.

CA Fast Unload peaked at 12 seconds per 1,000,000 rows unloaded (just over 5 minutes CPU per 1,000,000)

I wonder if there is still a market for 3rd party fast utilities...... [...] 10055 20 31_Re: Personal edition question..14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 16 Jan 2002 05:05:57 -0600559_- ksh isn't part of, for example, RH's distribution. But pdksh is.

James Campbell

On Tue, 15 Jan 2002 13:39:15 +0100, Hamar, Bela wrote:

>As far as I know, most of the Unix & Linux distributions contain >ksh, but have a look at Red Hat's web page...

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 10076 186 31_Re: Personal edition question..14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 16 Jan 2002 11:45:41 -0000548_iso-8859-1 There is a DB2 UDB PE for Linux, also downloadable from IBM. Korn shell is not available for Linux, however, a public-domain version of it - pksh - is. This will do.

Marcus

-----Original Message----- From: db person [mailto:db2_person@YAHOO.COM] Sent: 15 January 2002 05:49 To: DB2-L@RYCI.COM Subject: Personal edition question..



Hello !

I have UDB Personal Developer's edition (with UDB personal edition, the one available for free donwload on IBM website) installed on my Windows 2000 machine. [...] 10263 69 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery0_18_mebert@AMADEUS.NET31_Wed, 16 Jan 2002 13:16:05 +0100378_us-ascii Hi Grace,

as far as I know, only RECOVER will issue messages about reading archive logs (DB2 will recall them automatically). The COPY utility certainly doesn't need them. Are you sure that the messages were from the COPY step? What was the exact message?

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 10333 148 37_Re: Load problem with 'format unload'16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 16 Jan 2002 07:57:53 -0500411_iso-8859-1 Phil, The unload got 300 seconds CPU per 12 seconds of elapsed? The unload used 100% of 25 processors? 50% of 50 processors? Please explain!



Regards, eric pearson NS ITO Database Support

-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: Wednesday, January 16, 2002 5:55 AM To: DB2-L@RYCI.COM Subject: Re: Load problem with 'format unload' [...] 10482 70 61_Re: Backup/Recovery questions; Tools and Utilities comparison14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Wed, 16 Jan 2002 08:06:54 -0600729_iso-8859-1 I would contact BMC.

-----Original Message----- From: Venkatesh Mokshagundam [mailto:Vmokshagun@CSEDGE.COM] Sent: Tuesday, January 15, 2002 3:43 PM To: DB2-L@RYCI.COM Subject: Backup/Recovery questions; Tools and Utilities comparison



Dear listeners,

We're a soon-to-be-DB2 (V7.0 on OS/390) shop. I have the following questions:

1. Backup and Recovery

Currently, we do full volume dumps of all our production volumes using Flashcopy(FC) on Shark. We currently take about an hour to backup 365 volumes onto their FC targets and then dump them onto tapes later. Can we do the same thing when we go to DB2? What are the advantages/disadvantages? Is there anyone doing this? [...] 10553 155 30_Re: Update vs query subsystems12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 16 Jan 2002 06:09:37 -0800580_us-ascii Raymond- I think all your recommendations are spot on. But when I've tried, they're just not enough. Or maybe my skills just weren't enough. The main impact on OLTP by long running queries that I've seen is the flushing of bufferpools as entire tables are scanned repeatedly. If the 2 different types of users are going after different data, there's not much of a problem keeping the buffers separate. If they're after the same tables, you're in big trouble unless you can keep the whole thing in storage. When I made a copy of the 'problem' tables, and placed them [...] 10709 96 25_Re: Sytem Temporary Space14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Wed, 16 Jan 2002 06:39:59 -0800484_iso-8859-1 Ed, The error message indicates that the TEMPSPACE1 is defined as an SMS tablespace. Only DMS tablespaces can have multiple containers. Your approach below will be required. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

-----Original Message----- From: Ed Mullikin [mailto:emullikin@SCU.EDU] Sent: Tuesday, January 15, 2002 1:20 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Sytem Temporary Space [...] 10806 139 47_Re: Problems invoking a function with a literal14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Wed, 16 Jan 2002 06:44:56 -0800426_iso-8859-1 Ben, I believe that DB2 treats all character literals as VARCHAR columns, as opposed to CHAR. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

-----Original Message----- From: Ben Dissen [mailto:Ben.Dissen@NEONSYS.COM] Sent: Tuesday, January 15, 2002 6:05 PM To: DB2-L@RYCI.COM Subject: [DB2-L] Problems invoking a function with a literal [...] 10946 101 24_Re: Bufferpool Hit Ratio14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Wed, 16 Jan 2002 06:48:11 -0800559_iso-8859-1 John, For DB2 UDB, using data available from the snapshot monitor, use (1 - ((pool_data_p_reads + pool_index_p_reads) / (pool_data_l_reads + pool_index_l_reads))) * 100% This comes from the V7.1 System Monitor Guide and Reference.

Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

-----Original Message----- From: Curran, John F [mailto:john.f.curran@UK.FID-INTL.COM] Sent: Tuesday, January 15, 2002 10:31 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Bufferpool Hit Ratio [...] 11048 92 21_FW: V6 Index Question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 16 Jan 2002 08:54:53 -0600638_us-ascii This one from Tink was meant for the list....but came direct to me.

-----Original Message----- From: BL.Tink Tysor [mailto:tink@bltysor.com] Sent: Tuesday, January 15, 2002 5:00 PM To: Terry_Purcell@ylassoc.com Subject: Re: V6 Index Question



Michael,

To give an example of what Terry just explained, we changed an index from ASC to DESC, and the elapsed time for the job (using the MAX function in a correlated subquery) went from 12-14 hours to 8-10 hours. I did not expect as dramatic an improvement as there was an average of just 5 entries per value. I can only guess that the actual values [...] 11141 99 30_Re: Update vs query subsystems12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 16 Jan 2002 07:21:24 -0800582_us-ascii Cathy, Don't you use multiple "periods" for your TSO users? If so, then as the user uses much much more CPU, their priority goes down down.

Also, you can setup with the RESOURCE LIMIT GOVERNOR some maxes so that a given query cannot take too much time. That way, you cannot get runaway queries. You can set a reasonable upper limit - and can set this by groups of users or individual users. --- "Taddei, Cathy" wrote: > We're in a similar situation. We're building up a data warehouse > which will > some day satisfy our users' ad [...] 11241 73 50_Re: UDB V7.2 (aix) to DB2 v6 (os/390) connectivity12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 16 Jan 2002 07:26:02 -0800427_us-ascii We've got a number of AIX boxes talking to OS/390 successfully. All are FP2a, but FP3 should work the same.

The message 00d3101C is implying that something in your definitions between the AIX box and the mainframe is setup incorrectly.

"00D3101C

Explanation: DB2 has detected an error while processing a connection

request from DDCS. A DB2RA connection request was received from DDCS. [...] 11315 114 50_Re: UDB V7.2 (aix) to DB2 v6 (os/390) connectivity0_24_lightsey@ITS.STATE.MS.US31_Wed, 16 Jan 2002 09:23:13 -0600436_us-ascii So far as I can tell, it is defined correctly - but this is the first time I've tried to set up connectivity between anything other than db2 connect personal edition and the mainframe db2.

my statements were as follows:

db2 catalog tcpip node taxdev remote 10.12.8.9 server 446 ostype mvs db2 catalog database db25t as taxdevdb at node taxdev authentication dcs db2 catalog dcs database taxdevdb as taxdevdb [...] 11430 127 61_Re: Backup/Recovery questions; Tools and Utilities comparison22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Wed, 16 Jan 2002 09:46:14 -0600676_- Ali, thanks for your response.

No, we haven't tested it yet. Pretty soon, we will. I was just wondering if anyone was using Flash copy for backups.

Venkatesh



-----Original Message----- From: Ali OZTURK [mailto:Ali.OZTURK@PAMUKBANK.COM.TR] Sent: Wednesday, January 16, 2002 3:49 AM To: DB2-L@RYCI.COM Subject: Re: Backup/Recovery questions; Tools and Utilities comparison



I think, you can not recover db2 objects to current point in time or point in time if you use FC for db2 backup. Did you test this method for recovery ? You should take imagecopy for db2 objects to current point in time recovery. You can start imagecopy [...] 11558 126 30_Re: Update vs query subsystems11_David Nance16_DWNance@FHSC.COM31_Wed, 16 Jan 2002 10:48:52 -0500541_US-ASCII Another item to be done is bind the plan used by these queries, with isolation of UR. That way you ensure they are not taking unneccessary locks on the database. I always ensure that QMF, SPUFI, and DSNTEP2 are bound UR. If there are any applications using these products that need a higher level of isolation, then it is identified on the individual query(ies). Also, be sure to let everyone know what to expect since there queries are WITH UR that the data could be in the process of being changed as they are looking at it. [...] 11685 69 37_Re: Unknown V7 Abend 00C900CF on COPY0_28_charles.t.schopf@VERIZON.COM31_Wed, 16 Jan 2002 10:53:07 -0500520_iso-8859-1 Lockwood,

If you can get to IBMLINK, there is an information APAR that discusses your situation - II12653. I suggest that you take a look at it.

Chuck Schopf









Lockwood Lyon @RYCI.COM> on 01/15/2002 11:03:50 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Unknown V7 Abend 00C900CF on COPY [...] 11755 19 48_How to cancel thread initiated from Web browser?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Wed, 16 Jan 2002 09:29:00 -0600482_- We have a customer that will have users using a web browser initiating a query that will result in a DB2 thread. They use Cold Fusion to built the SQL and ship it off thru Focus and EDA to DB2. I know they can cancel the thread from a FOCUS or EDA console or we can cancel the thread from DB2. Does anyone know of a way the end user can cancel the request if they think it is taking too long. From what we have seen, the end user can cancel out of the browser and it ends up [...] 11775 16 22_Re: Bind Option: Owner15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 16 Jan 2002 09:49:21 -0600352_- Melissa

If it is a batch job, the default owner is the user-id of the job, or if the keyword user is specified in the jobcard that id. So, I only know the DB2 privilege side, the programmer can only bind a plan, if the userid transferred to DB2 is the owner of the plan or has bind-authority. I don't know if that is of any help for you. [...] 11792 226 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Wed, 16 Jan 2002 09:11:02 -0700428_iso-8859-1 Hi Michael, This is the output: DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = IMAGCOPY

DSNUGUTC - COPY INDEXSPACE DSNDB01.DSNLUX01 COPYDDN COPYLUX1

-DBT1 DSNULOG1 - AN UNSUCCESSFUL COMPLETION OF A LOG READ, REASON=X'00D1032B' DSNUBBID - COPY PROCESSED FOR INDEXSPACE DSNDB01.DSNLUX01

NUMBER OF PAGES=5

AVERAGE PERCENT FREE SPACE PER PAGE = 0.00

PERCENT OF CHANGED PAGES = 0.00 [...] 12019 71 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 16 Jan 2002 11:18:01 -0500573_ISO-8859-1 Grace

The short answer is that I don't know. The following is a guess. I know that the SYSCOPY information for the tablespace SYSUTILX is recorded on the log rather than in SYCOPY and so it seems reasonable that the SYSCOPY information for indexes on SYSUTILX should also be recorded on the log. The RECOVER utility would therefore need to read the log to find this SYSCOPY information. But why is the COPY utility asking for an archive log? Maybe it is looking for the SYSCOPY information for the previous image copy of the index, but I do not know [...] 12091 105 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery0_18_mebert@AMADEUS.NET31_Wed, 16 Jan 2002 18:08:25 +0100381_us-ascii Humm. The Online Messages & Codes Manual I just checked explains the Reason Code 00D1032B as "Log Read Error" (which we know already). It also says "the calling thread is abended" which obviously is not true, as your Copy job completes successfully.

Looks like you found a DB2 bug. I tried to check the APAR database, but it is down ("internal server error"). [...] 12197 238 16_Re: Memory Leaks23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 16 Jan 2002 17:14:41 -0000526_iso-8859-1 all those people that asked for my rexx should now have it.

If you do not let me know on private mail and I'll send you a copy

Les

-----Original Message----- From: Isaac Yassin [mailto:yassini@BEZEQINT.NET] Sent: Saturday, January 12, 2002 10:59 AM To: DB2-L@RYCI.COM Subject: Re: Memory Leaks



Hi Les, Many thanks ! Will check it next Monday. We also applied UQ60221 per IBM suggestion. Didn't help either :-( Sorry you got yourself into a corner because of my question ... [...] 12436 177 47_Re: Problems invoking a function with a literal10_Ben Dissen22_Ben.Dissen@NEONSYS.COM31_Wed, 16 Jan 2002 11:31:53 -0600562_iso-8859-1 How silly of me.

Thanks.

-- Binyamin Dissen

-----Original Message----- From: Peter Backlund [mailto:pbacklu@ATTGLOBAL.NET] Sent: Wednesday, January 16, 2002 12:34 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Problems invoking a function with a literal



Ben,

the literal string is by default VARCHAR

Peter

Ben Dissen wrote:



The function is defined as

CREATE FUNCTION FUNC1(CHAR(6))

When invoked as

SELECT FUNC1('123456') FROM table [...] 12614 139 42_Unknown V7 Abend 00C900CF on COPY - Answer13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Wed, 16 Jan 2002 12:38:47 -0500380_US-ASCII List,

Thanks to all for your responses. We had basically already applied the relevant PTFs and maintenance that some of you mentioned, and were already aware of most of the APARs. Our reading of the materials was that maintenance (specifically, PQ47079/UQ53228) would "tolerate a catalog or directory object having a dataset password". Apparently, it didn't! [...] 12754 139 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Wed, 16 Jan 2002 11:36:33 -0600461_us-ascii Grace,

I have seen this a few weeks ago (db2 v6, os/390) on our production system.

When the page change range RBA on the tablespace is no longer contained in the available active/archive logs. To fix this I did a quick quiesce on the tablespace, then the copy ran fine. This was oh dark thirty something, so I didn't peruse why, just went for the quick fix. IBM can perhaps give you the full blown answer, or you can try my version. [...] 12894 111 74_Re: Hot Application Tuning with Horacio Terrizano and Computer Associ ates0_20_bjnigh@HOUSEHOLD.COM31_Wed, 16 Jan 2002 09:18:00 -0800422_iso-8859-1 Will there be any seminars like this in the US (especially in SF Bay area)?











"Grainger, Phil" To: DB2-L@RYCI.COM Subject: Hot Application Tuning with Sent by: DB2 Data Horacio Terrizano and Computer Associ Base Discussion ates List



01/16/2002 02:28 AM Please respond to DB2 Data Base Discussion List [...] 13006 13 39_Re: Recover tablespace statements order9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 16 Jan 2002 11:28:49 -0600337_- Are all 150 tables tied together wit RI?

Jim Ruddy DB2 for z/OS and OS/390 Development

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 13020 187 50_Re: SYSUTILX INDEX on ICOPY? status after Recovery15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 16 Jan 2002 13:03:19 -0600300_iso-8859-1

I thought this was an interesting question, so I tried a test on DB2 V6. The DB2 Copy utility doesn't complain when I register a cataloged copy of DSNDB01.SYSUTILX with the same data set name as a previous copy. I also tried it on index DSNDB01.DSNLUX01 with the same result. [...] 13208 139 75_Re: Hot Application Tuning with Horacio Terrizano and Computer As soci ates13_Thomas, Janis19_Janis.Thomas@CA.COM31_Wed, 16 Jan 2002 13:59:07 -0500374_iso-8859-1 We are nearing the end of our U.S. seminar schedule which has been taking place over the last several months. The San Francisco seminar was on August 28th & featured Gabrielle Wiorkowski - sorry you missed it. The only U.S. seminars left after today are the following:

January 17th: Houston, TX January 23rd: Charlotte, NC January 30th: Milwaukee, WI [...] 13348 188 30_Re: Update vs query subsystems13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 16 Jan 2002 11:16:45 -0800449_iso-8859-1 We have two TSO periods, and our MVS folks are reluctant to add more (too much overhead, they say), and equally reluctant to change period two's velocity to discretionary (too high a risk that they would fall into period two while trying to resolve a problem, and get shut out of the processor). However, even if we did set limits like this, they would be insufficient to stop a TSO user from wreaking havoc in DB2 most of the time. [...] 13537 26 4_NTEs9_db person20_db2_person@YAHOO.COM31_Wed, 16 Jan 2002 12:09:47 -0800626_us-ascii Hi guys!

Is a UNION/UNION ALL clause not allowed in NTEs in DB2 V5/S390? I received a SQLCODE -199 while doing it and then I substituted UNION with a FULL OUTER JOIN in NTE and it worked.

Sharam Kar.





__________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 13564 27 16_Oracle again....9_db person20_db2_person@YAHOO.COM31_Wed, 16 Jan 2002 12:11:06 -0800457_us-ascii Hey,

I keep seeing this "SAP runs faster on Oracle than IBM's DB2" on virtually all the magzines.... needless to say an advertisement by Oracle. Oh God, why did IBM have to make their test public....and now what are they doing to counter the propaganda?

Gaya guzraa.





__________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ [...] 13592 46 14_COBOL Question9_db person20_db2_person@YAHOO.COM31_Wed, 16 Jan 2002 12:12:38 -0800541_us-ascii This is not a db2 question but i know there are many cobol geeks out there. My question is about the 'select optional' clause in the file-control section. This implies that if the file is not present (let us say when the file is opened in i-o mode), the system 'creates' the file. now how does the system know what attributes (lrecl, recfm, space etc.) to create the file with ? I am getting a file-status of 90 (doesn't help much) at run time. basically i am opening a file (the file refers to a non-exixtant member of a pds; [...] 13639 44 11_OPEN Cursor9_db person20_db2_person@YAHOO.COM31_Wed, 16 Jan 2002 12:14:03 -0800305_us-ascii Is it possible to know the number of records in the 'result set' after the OPEN cursor statement? For some reason, I need to find the number of records that will be returned by a SQL statement and only if the number of records is greater than a specific no., do I need to fetch the records. [...] 13684 64 37_Re: Load problem with 'format unload'12_Raymond Bell17_rbell@NZ1.IBM.COM31_Thu, 17 Jan 2002 09:28:31 +1300409_us-ascii 5 minutes CPU for 1,000,000 rows? I do indeed wonder if there's a market for 3rd party 'fast' utilities... ;o) I assume the 'minutes' should have been 'seconds'. Very impressive. Still, I'm fairly happy with my reorg unload only times for a record length of 225 bytes and, as we don't have any fast utilities, it'll have to do. Certainly beats watching paint dry while DSNTIAUL does it's thing. [...] 13749 153 50_Re: UDB V7.2 (aix) to DB2 v6 (os/390) connectivity12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 16 Jan 2002 12:33:08 -0800560_us-ascii Looking at this and Myron's message indicates to me you're trying to go through DB2 Connect (DDCS is the old name of DB2 CONNECT). So it sounds like you're pointing to a DB2 CONNECT catalog'd alias name. Are you issuing the catalog statements within DB2 Connect correctly? I think you can go directly from AIX to OS390 without Connect if you're using TCP, and have an easier time of it. I'd run some tests, but don't have access to os390 these days. Tim --- lightsey@ITS.STATE.MS.US wrote: > So far as I can tell, it is defined correctly - but > [...] 13903 71 37_Re: Load problem with 'format unload'10_James Kwan19_JamesDB2Kwan@CS.COM29_Wed, 16 Jan 2002 15:35:15 EST600_US-ASCII In a message dated 1/15/02 8:19:10 PM Central Standard Time, rbell@NZ1.IBM.COM writes:



> Just an update, for whoever's interested. I redid my partitioning testing, > putting the Dev TS back to segmented and partitioned it again using Reorg > Unload Only instead of DSNTIAUL - works a treat. I also fired off a > DSNTIAUL and Reorg Unload Only job for the eventual target table in Prod > (cancelling them both well before completion). Of my 11.4m row table, > DSNTIAUL unloaded 2m rows in 25 minutes elapsed and 390 seconds CPU, while > Reorg Unload Only unloaded 5m rows [...] 13975 123 30_Re: Update vs query subsystems15_Jackson Reavill18_damcon2@US.IBM.COM31_Wed, 16 Jan 2002 15:37:59 -0500409_us-ascii Just a thought... Couldn't data sharing be used to alleviate the resource consumption on the production subsystem by executing queries from the warehouse subsystem? Also QMF, Spufi, etc. could be bound with isolation UR to alleviate locking contention.

Regards, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 356-5317, Tie Line 8-697-5317 [...] 14099 73 37_Re: Load problem with 'format unload'10_James Kwan19_JamesDB2Kwan@CS.COM29_Wed, 16 Jan 2002 15:35:15 EST600_us-ascii In a message dated 1/15/02 8:19:10 PM Central Standard Time, rbell@NZ1.IBM.COM writes:



> Just an update, for whoever's interested. I redid my partitioning testing, > putting the Dev TS back to segmented and partitioned it again using Reorg > Unload Only instead of DSNTIAUL - works a treat. I also fired off a > DSNTIAUL and Reorg Unload Only job for the eventual target table in Prod > (cancelling them both well before completion). Of my 11.4m row table, > DSNTIAUL unloaded 2m rows in 25 minutes elapsed and 390 seconds CPU, while > Reorg Unload Only unloaded 5m rows [...] 14173 17 12_IGNOREFIELDS26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Wed, 16 Jan 2002 13:17:46 -0800410_iso-8859-1 Does anyone have a sample job that uses the load utility option IGNOREFIELDS? If not a sample, the correct syntax?

Thanks, Bill Johnson Russell Mellon

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14191 30 16_Backup/ Recovery15_Russell Collins21_russell@ECTAUSTIN.COM31_Wed, 16 Jan 2002 15:47:14 -0600427_iso-8859-1 The situation: Have to V.7 databases running on different boxes. Both boxes are window NT and I am using UDB.

The Question: When I do an offline backup of database XYZ on box A and try a recovery of database XYZ on box B, I get the message:

Database Codepage "xxxx" indicated in the backup image differs from that of the current on-disk database codepage "yyyy". The Restore Operation has failed. [...] 14222 20 33_Datasharing and row Level locking12_Brian Picard26_brian_picard@ALTAVISTA.COM31_Wed, 16 Jan 2002 15:21:30 -0600468_- Hello, We are in the process of designing concurrent parallel processing for a process. 10 concurrent jobs all executing the same program would be initiated and running. We may need to use row level locking on some of the tables. We have two sub systems on a data sharing group. Is there a significant issue with turning on row level locking in a data sharing group. We are ver 7.0 and our sys folks contend that this may not be a viable option. Regards, Brian [...] 14243 87 37_Re: Load problem with 'format unload'12_Raymond Bell17_rbell@NZ1.IBM.COM31_Thu, 17 Jan 2002 10:46:23 +1300439_us-ascii Resending as it was originally rejected as a duplicate. Apologies if it actually snuck (?) through previously.



Raymond ----- Forwarded by Raymond Bell/New Zealand/Contr/IBM on 17/01/02 10:45 -----

Raymond Bell To: DB2 Data Base Discussion List 17/01/02 09:28 cc: From: Raymond Bell/New Zealand/Contr/IBM@IBMNZ Subject: Re: Load problem with 'format unload'(Document link: Raymond Bell) [...] 14331 47 40_Experience With UDB on Various Platforms13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Thu, 17 Jan 2002 08:50:59 +1100594_iso-8859-1 For a colleague.....

To avoid list clog I am happy to accept off-line replies.

> I'm attending a client's Enterprise Architecture > Quarterly Summit. > > On the xxxx Account, we run UDB EEE on an AIX/RS6000 Platform. > > Some questions came up as follows: > > 1. Are there any/many Accounts running UDB EE/EEE on other midrange > platforms such as Sun/Solaris, HP/Unix, etc. and how is it functioning? > > 2. For those accounts using UDB on other midrange platforms: > What versions are being used? > What type of applications are being run (data warehouse, OTLP, [...] 14379 48 37_Re: Load problem with 'format unload'12_Raymond Bell17_rbell@NZ1.IBM.COM31_Thu, 17 Jan 2002 10:47:28 +1300554_us-ascii Only V5 still, James, but with plans to move to V7 hopefully this quarter.



Raymond





James Kwan cc: Sent by: DB2 Subject: Re: Load problem with 'format unload' Data Base Discussion List



17/01/02 09:35 Please respond to DB2 Data Base Discussion List









Raymond

I don't know if you are using V7 or not. If you are, may be you should do another test with IBM Unload to see the difference. [...] 14428 39 18_Re: COBOL Question14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Wed, 16 Jan 2002 16:41:13 -0500427_iso-8859-1 While it's true that a lot of us out here DO know our COBOL, still and all, we also insist on being addressed politely, and calling us "Geeks" does NOT qualify...

-----Original Message----- From: db person [mailto:db2_person@YAHOO.COM] Sent: Wednesday, January 16, 2002 3:13 PM To: DB2-L@RYCI.COM Subject: COBOL Question

This is not a DB2 question but I know there are many Cobol geeks out there. [...] 14468 41 50_Re: UDB V7.2 (aix) to DB2 v6 (os/390) connectivity15_Janardhan Ragam16_sragam@YAHOO.COM31_Wed, 16 Jan 2002 13:55:33 -0800354_us-ascii I had sent these instructions a while back... See if you did the same or try your cataloging again using these instructions:

1) db2 "catalog tcpip node remote server "

You should be able to find the host name and port number in the db2 master log on the mainframe. [...] 14510 66 15_Re: OPEN Cursor23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Wed, 16 Jan 2002 16:55:33 -0500616_ISO-8859-1 Yes, if you use scrollable cursor. Again scrollable cursor is available on DB2 ver 7. Don't know if there are any other ways of getting the same info.

-----Original Message----- From: db person [mailto:db2_person@YAHOO.COM] Sent: Wednesday, January 16, 2002 3:14 PM To: DB2-L@RYCI.COM Subject: OPEN Cursor



Is it possible to know the number of records in the 'result set' after the OPEN cursor statement? For some reason, I need to find the number of records that will be returned by a SQL statement and only if the number of records is greater than a specific no., do I need to [...] 14577 18 37_Re: Datasharing and row Level locking0_26_truman.g.brown@VERIZON.COM31_Wed, 16 Jan 2002 17:20:44 -0500597_us-ascii Quite possibly many more locks, which means more IRLM activity, which also means more coupling facility lock activity (for VBPs with coupling facility counterparts) and possibly more false contention. IMHO row level locking in any environment is the court-of-last-resort used only when necessary to solve on-line concurrency issues.

George

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14596 19 59_Re: UDB V7.2 (aix) to DB2 v6 (os/390) connectivity - SOLVED0_24_lightsey@ITS.STATE.MS.US31_Wed, 16 Jan 2002 16:22:07 -0600411_us-ascii I uncataloged everything I had done and tried it the way that Sai J Ragam suggested - it works !!



Thanks to all who replied,



Bruce

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14616 31 18_Re: COBOL Question14_Allen, Susan A24_susan.a.allen@BOEING.COM31_Wed, 16 Jan 2002 14:23:18 -0800570_iso-8859-1 a better place to get your answer is the newsgroup comp.lang.cobol; ask them nicely and they will help.

you must specify the version of COBOL and your platform when asking such questions.

Susan A



-----Original Message----- From: db person [mailto:db2_person@YAHOO.COM] Sent: Wednesday, January 16, 2002 12:13 PM To: DB2-L@RYCI.COM Subject: COBOL Question



This is not a db2 question but i know there are many cobol geeks out there. My question is about the 'select optional' clause in the file-control section. [...] 14648 21 34_Products - Front end tools for DB28_K.Balaji19_K.Balaji@TARGET.COM31_Wed, 16 Jan 2002 16:52:30 -0600466_iso-8859-1 Hi all, My colleagues are looking to purchase some front end tools for DB2. Basically they are looking for some standard tools like seeing catalogue information and writing some quick sqls from the front end. I understand that some list members should be using some of these front end products. If any of you are interested in sharing your experiences we will really appreciate this. Any suggestions are also welcomed. TIA Balaji Ph # (510) 727-3259 [...] 14670 158 30_Re: Update vs query subsystems13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 16 Jan 2002 15:10:27 -0800617_iso-8859-1 Thanks, David and Jay, for the UR suggestions, I'm going to look into that to improve concurrency. I don't think data sharing would help with this issue, as the different members would still be going after the same physical data. We're also looking at dramatically expanding our use of hiperpools to allay our "death by random I/O" situations. I suppose once these improvements are in place and the predictive governor is finally working, these two types of workloads will coexist better than they do now. However, I believe the conventional wisdom that they should be separated still holds - there's [...] 14829 41 37_Re: Datasharing and row Level locking15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 16 Jan 2002 17:12:18 -0600446_iso-8859-1 I think the main potential problem with row-level locking in data sharing is page-level P locking. Take a look at pp 230 - 231 in the DB2 V610 Data Sharing Planning and Admin Guide. It has a good discussion of this issue.

Michael Murley BMC

-----Original Message----- From: Brian Picard [mailto:brian_picard@ALTAVISTA.COM] Sent: January 16, 2002 3:22 PM To: DB2-L@RYCI.COM Subject: Datasharing and row Level locking [...] 14871 30 19_db2 connect & DB2v513_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Thu, 17 Jan 2002 10:49:04 +1100325_iso-8859-1 G'day,

With help from Myron Miller(thanks Myron) I have been trying, unsuccessfully, to access DB2 on the m/f via Excel.

For some reason when the initial connection is made there is an attempt to use SQL which is not compatible with V5 (namely an RTRIM function). There is no problem using UDB. [...] 14902 30 30_Re: Update vs query subsystems12_Raymond Bell17_rbell@NZ1.IBM.COM31_Thu, 17 Jan 2002 12:45:03 +1300486_us-ascii Jay, Cathy,

Data Sharing might be a good thing to try, actually. I like the suggestion, Jay, especially if your OLTP stuff connects via one subsystem and the MIS stuff via the other. Yes, it's still the same physical data involved, but (if I understand DS correctly which, having never used it, I may not) each subsystem will have its own bufferpools, so long-running MIS queries aren't going to flush data from the OLTP bufferpools 'cause they're different pools. [...] 14933 77 37_Re: Datasharing and row Level locking12_Susan Lawson24_susan_lawson@YLASSOC.COM31_Wed, 16 Jan 2002 17:55:30 -0600546_iso-8859-1 Brian,

Row level locking has a greater negative effect on the coupling facility than page level locking. While it may appear that you would be taking the same 'number' of locks, in a data sharing environment this is a bit different. The locks most people think of are L-locks, the same as those that we use in a non-data sharing environment, but where the problems arise in data sharing, and coupling facility overhead, is with excessive P-locks(physical locks used to control page coherency, not transaction concurrency). [...] 15011 31 40_Another Resource Limit Facility question15_Schaeffer, Dave28_dave.schaeffer@HONEYWELL.COM31_Wed, 16 Jan 2002 17:03:19 -0700450_- I'm trying to stop long running queries from running that are using DB2 connect. This is the -DIS THREAD(*) DETAIL

NAME ST A REQ ID AUTHID PLAN ASID TOKEN SERVER RA * 288 VBDEMO32.EXE XXXXXX DISTSERV 00BE 2455 V437-WORKSTATION=*, USERID=XXXXXXX, APPLICATION NAME=VBDEMO32.EXE V445-SG0.DG013XI0.B7CDC86DF4FA=2455 ACCESSING DATA FOR :DG013XI0 V447--LOCATION SESSID A ST TIME V448-- E9C797CD15077E89 W R2 0201616564700 [...] 15043 28 8_Re: NTEs12_sushant dash23_dash_dba@REDIFFMAIL.COM31_Thu, 17 Jan 2002 00:11:53 -0000254_iso-8859-1 Hi Sharam , what you get is correct. There are no facility for UNION and UNION ALL in VIEWS or NTE till version 6. It is a enhancement in V 7. It would be better if you go through the IBM manuals , where it says the new features for V 7. [...] 15072 23 53_IBM equivalent of Princeton Softech's Compare for DB212_Raymond Bell17_rbell@NZ1.IBM.COM31_Thu, 17 Jan 2002 13:18:42 +1300401_us-ascii Colleagues,

Does anyone know of an IBM product functionally equivalent to Princeton Softech's Compare for DB2? IBM have a product called the DB2 Object Comparison Tool but this compares DDL structures. I believe Compare for DB2 compares table contents, much like ISPF 3.13 does for files.

Any ideas?



Raymond PS. DB2 for OS/390 V5 and V7 support is a prereq. [...] 15096 60 37_Re: Datasharing and row Level locking11_David Nance16_DWNance@FHSC.COM31_Wed, 16 Jan 2002 19:19:02 -0500545_US-ASCII I've always been told to stay away from row level locking no matter what. When I worked for a high volume OLTP system at another company, we had real problems with locking and failures due to those locks. We changed all the tablespaces from locksize any to row and saw an average 20% reduction in response time across the entire application and dead-locks go from well over a thousand a day to around 20 or less per day. We had to ensure that all of the application code had good commit logic and never once had a problem with the [...] 15157 197 30_Re: Update vs query subsystems13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 16 Jan 2002 17:35:42 -0800596_iso-8859-1 Data sharing would not be feasible for us, because of the need for a coupling facility, sysplex timer, second MVS image, etc. I suppose you could isolate TSO from CICS in that way, though there would still be potential conflict, if both regions were interested in the same page it would go to the group buffer pool, then you've shifted your tuning headaches (should I say opportunities?) to another area. However, if we went through all the trouble to implement DB2 data sharing, with all its complexities, we would surely implement CICSplex as well to take advantage of the huge [...] 15355 61 30_Re: Update vs query subsystems12_Raymond Bell17_rbell@NZ1.IBM.COM31_Thu, 17 Jan 2002 15:39:56 +1300487_us-ascii Good points, Cathy. You're evidently much more familiar with data sharing concepts that I am. I'll have to bow out on this one as, to answer your question, I haven't used data sharing to try to isolate workloads. Hope you find your magic bullet.

Cheers,



Raymond





"Taddei, Cathy" cc: Sent by: DB2 Data Subject: Re: Update vs query subsystems Base Discussion List [...] 15417 99 15_Re: OPEN Cursor11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 16 Jan 2002 21:16:05 -0600337_- OK, can this be done without using a count? I think so ...

Create a DTT like original table. Insert into DTT select from original. Check sqlerrd(3). If > some threshold, open the cursor and process else do something else.

Performance? Terrible! Of course, I would NEVER do this for real ...but does avoid the count! [...] 15517 103 61_Re: Backup/Recovery questions; Tools and Utilities comparison12_Robert Brock28_brock@KRYPTON-CONSULTING.COM31_Thu, 17 Jan 2002 00:11:33 -0600630_iso-8859-1 Hi Venkatesh,

Another vendor option you may not be aware of is Infotel. They have a full suite of V7 compatible utility products for DB2 on the mainframe. The IBM High Performance Unload that IBM markets is actually an Infotel product.

As far as the imagecopy issue, I would recommend a combination of MasterCopy and MasterCopySet. MasterCopy brings intelligent automation to the imagecopy process. Without the need for costly runstats a simple batch job can determine the objects that need to be copied most urgently. Respecting the time frame you allow for the copy process it will process as many [...] 15621 21 26_Re: bind/execute authority15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 17 Jan 2002 01:49:48 -0600349_- Melissa

Execute-authority on package-level means you can use that package in the PKLIST-clause of a plan. If you use GRANT EXECUTE ON Collection.* TO authid, that authid can use all packages in that collection in the PKLIST or Collid.*.

To bind a plan you need BIND-authority for that plan or if is a new one BINDADD-Authority. [...] 15643 56 44_No memory available in the application heap.18_Eva Molina Jimenez20_evamolina@ES.IBM.COM31_Thu, 17 Jan 2002 09:45:08 +0100664_iso-8859-1 Hi list, I'm a DB2 newbie, and for the last three days, when I try to perform a LOAD on the database I'm getting this error at db2diag.log:

2002-01-17-05.44.55.580296 Instance:repadmin Node:000 PID:30318(db2agent (REGISTRO)) Appid:3E804155.0A14.020101045042 access_plan_manager sqlra_load_var Probe:20 Database:REGISTRO DIA3601C No memory available in the application heap.

ZRC=FFFFD601

2002-01-17-05.45.47.912080 Instance:repadmin Node:000 PID:30318(db2agent (REGISTRO)) Appid:3E804155.0A14.020101045042 access_plan_manager sqlra_cache_copy_sec Probe:20 Database:REGISTRO DIA3601C No memory available in the application heap. [...] 15700 147 48_Re: No memory available in the application heap.11_David Hayes28_Dave.Hayes@MORGANSTANLEY.COM31_Thu, 17 Jan 2002 09:38:02 +0000351_iso-8859-1 Eva

The problem is probably caused by one of the database configuration parameters being set too low. The application heap size is determined by a parameter called APPLHEAPSZ. If you run the following command you will see what it is currently set to:

db2 get db cfg for dbname

You can then increase it by running: [...] 15848 136 38_Re: Products - Front end tools for DB216_Bednarz, Michael22_Michael.Bednarz@CA.COM31_Thu, 17 Jan 2002 09:51:14 -0000739_iso-8859-1 Hi Question: DB2 on ???(NT, OS/390, ....')?



Michael Bednarz Computer Associates FSG Consultant tel: +49 (0)211 5306 295 fax: +49 (0)211 5306 200 mobile: +49 (0)170 85 38 576 mailto:michael.bednarzr@ca.com







-----Original Message----- From: K.Balaji [mailto:K.Balaji@TARGET.COM] Sent: Mittwoch, 16. Januar 2002 23:53 To: DB2-L@RYCI.COM Subject: Products - Front end tools for DB2



Hi all, My colleagues are looking to purchase some front end tools for DB2. Basically they are looking for some standard tools like seeing catalogue information and writing some quick sqls from the front end. I understand that some list members should be using some of these front end [...] 15985 76 55_Re: Re : Drain lock waits during application processing11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 17 Jan 2002 04:57:45 -0500421_ISO-8859-1 Warwick

Regarding the zero drain request count. I believe this is consistent with a long claim. My understanding is that a long claim, like a short claim will increment the claim request count but will not increment the drain request count. I believe that there is a subtle difference between taking a drain lock and draining a claim class. Draining involves a bit more than taking the drain lock. [...] 16062 52 39_Re: Recover tablespace statements order22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Thu, 17 Jan 2002 08:41:20 -0200586_iso-8859-1 No, there are many tablespace sets and some untied tables. But the main problem I'm facing is the number of CHKP tablespaces left after the recovery process. But I haven't realised that RECOVER TOCOPY would put tablespaces into CHKP anyway. Therefore, I'll have to make a choice: 1) to use TORBA option and recover to a common quiesce point to avoid check pending tablespaces, or 2) run CHECK DATA (on about 60 tables), or 3) run REPAIR (for reseting the check pending status), which I think is a bit too dangerous. I'll probably choose option 2 because the recovery is [...] 16115 61 33_Re: How to copy VSAM LDS to a PS.12_leila rahimi21_lshosaini@HOTMAIL.COM31_Thu, 17 Jan 2002 10:51:02 +0000770_- hi ,you can use DSN1COPY,in follow you can see an example. SYSUT1 is LDs,and SYSUT2 is ps.

//DSNTLOG EXEC PGM=DSN1COPY,PARM='RESET' //STEPLIB DD DSN=DSN610.SDSNLOAD,DISP=SHR //SYSUT1 DD DSN=TESTCAT.DSNDBC.BILLDB.BILLSPC.I0001.A001,DISP=SHR //SYSUT2 DD DSN=SYSPHO.TEST.TEST,DISP=(,CATLG),SPACE=(CYL,(2,2)), // VOL=SER=SYSRS4,UNIT=3390 //SYSPRINT DD SYSOUT=* I hope ,you copy sucessfully. leila. bye.

>From: "Umapathy, Gopalakrishna (Cognizant)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: How to copy VSAM LDS to a PS. >Date: Wed, 9 Jan 2002 14:17:51 +0530 > >Hi everyone, > >This is not a DB2 related, but i am stuck up with this. > >How to copy VSAM LDS to a PS. I tried out [...] 16177 65 20_Re: Backup/ Recovery18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 17 Jan 2002 05:56:20 -0500474_iso-8859-1 There is no way to restore a backup image to different codepages. They must be identical.

We had a similiar situation with Unix. We created one database via the control panel and another through the command line processor on the Unix box. The control panel ended up being one codepage and the CLP was another. So what we ended up doing is creating the database via the control panel instead of CLP. We were then able to complete a redirected restore. [...] 16243 65 44_Re: Another Resource Limit Facility question22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Thu, 17 Jan 2002 08:58:14 -0200471_iso-8859-1 Here our DSNRLST tables have two rows that enforce a time limit for everybody. The first one contains an ASUTIME value and LUNAME=PUBLIC. All others columns are left blank. The second row contains the same ASUTIME value, LUNAME=PUBLIC and RLFFUNC=2. If some userid needs a different, higher ASUTIME, you can insert a row for it, containing AUTHID=userid, ASUTIME, LUNAME=PUBLIC and RLFFUNC=2 (this works for DISTSERV plans). Other columns are left blank. [...] 16309 197 37_Re: Load problem with 'format unload'14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 17 Jan 2002 11:14:40 -0000358_iso-8859-1 Eric,

As someone else pointed out, it should have been CPU seconds and not minutes. Lesson - don't post to db2-l whilst someone is trying to drag you into a meeting!



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 [...] 16507 40 26_Re: bind/execute authority12_leila rahimi21_lshosaini@HOTMAIL.COM31_Thu, 17 Jan 2002 11:42:24 +0000674_- HI,i think that is not true,,,,there is 2 different privilage - bind - execute infact they are more about package(bind,execute,copy,create in..) but about plan is only (bind,execut). if anyone has bind privilage,can bind to a package or a plan. execute privilage means,you can RUN ,whatever was bound before. i hope my mail help you. bye. leila. >From: Melissa Rogers >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: bind/execute authority >Date: Tue, 15 Jan 2002 13:23:47 -0500 > >I was just read through some of the archives regarding binding and found a >statement that someone made stating that [...] 16548 127 70_FW: [DB2-L] Backup/Recovery questions; Tools and Utilities compar ison14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 17 Jan 2002 11:59:09 -0000413_iso-8859-1 -----Original Message----- From: Grainger, Phil Sent: 17 January 2002 10:55 To: 'DB2 Data Base Discussion List' Subject: RE: [DB2-L] Backup/Recovery questions; Tools and Utilities comparison



WHATEVER method you use to backup DB2 data, you can now always rely on a logonly recovery to get you back to the current point in time (assuming you have the right log records available....) [...] 16676 128 15_Re: OPEN Cursor14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 17 Jan 2002 12:21:12 -0000376_iso-8859-1 Hmm

Simple answers ARE sometimes bad ones!!

A COUNT(*) will use a unique index if there is one, an INSERT with subselect will use a tablespace scan.

Guess which will be faster!!

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 [...] 16805 123 23_FW: [DB2-L] OPEN Cursor14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 17 Jan 2002 12:31:21 -0000357_iso-8859-1 -----Original Message----- From: Grainger, Phil Sent: 17 January 2002 12:17 To: 'DB2 Data Base Discussion List' Subject: RE: [DB2-L] OPEN Cursor



but don't forget that for the scrollable cursor to know hoe many rows there are, it has had to fetch them all and park them in a temporary table (this is how scrolling works in V7) [...] 16929 188 82_Antwort: Backup/Recovery questions; Tools and Utilities comparison [Virus checked]25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE31_Thu, 17 Jan 2002 13:37:30 +0100417_iso-8859-1

Hi Venkatesh,

sorry to reply so late but I have changed offices, ordered myself a new hat ;-) and basically my e-mail address has only just been activated...

About Flashcopy, it would help to do a full volume restore but, as already pointed out by other learned colleagues, no PIT recovery, apart from restoring a volume that you're absolutely sure contains what you want and... [...] 17118 100 43_Antwort: Products - Front end tools for DB225_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE31_Thu, 17 Jan 2002 13:38:10 +0100422_iso-8859-1 Balaji,

Candle !DB/Tools could be the stuff for you, if you are talking about a mainframe environment, while we also have other Database management products for the other platforms!

Please do not hesitate to contact me offline, or contact your local friendly Candle Rep., for further information.

HTH.

Ciao!

Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. [...] 17219 96 62_Antwort: IBM equivalent of Princeton Softech's Compare for DB225_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE31_Thu, 17 Jan 2002 13:38:44 +0100444_iso-8859-1 Ray,

what, you mean you've never heard of Candle's !DB/Tools?

ah no, of course, you're asking about an IBM product...

Ciao!

Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.

Office: +49 (0) 89 54554 189 Mobile: +49 (0) 171 674 6930 +44 (0) 7881 818 867 Fax: +49 (0) 89 54554 119 email: aurora_dellanno@candle.com

1 Archipelago Lyon Way Frimley Camberley Surrey GU16 7ER UK [...] 17316 172 24_Antwort: Re: OPEN Cursor25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE31_Thu, 17 Jan 2002 13:39:05 +0100436_iso-8859-1 Of course this is all easy-peasy if you're on DB2 V7 (OS/390)...

IF you are so lucky, then all you need to do is declare a Scrollable Cursor and then execute a FETCH statement (FETCH AFTER will position you just after the last row of the result set).

Then if you have a look at the SQLCA; SQLERRD(1) and SQLERRD(2) (sqlerrd(0) and sqlerrd(1) for C and C++), contain the number of rows in the result table. [...] 17489 14 32_BMC-Unload and -Load towards IBM15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 17 Jan 2002 06:35:53 -0600414_- Hi

Are there any benchmarks which have some numbers about BMC-Load and -Unload compared to the IBM-Load-utility and the Unload-utility. Is BMC faster and how much?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 17504 78 18_Re: COBOL Question10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Thu, 17 Jan 2002 07:24:44 -0600531_iso-8859-1 We had always run into this problem, not with whether the dataset existed or not, but when the dataset had not ever been opened for output. The "optional" clause allowed you to open a file that had never been opened for output (and thus never had anything in it) as I/O even tho there was nothing in it. Opening as input or I/O implies that there should be something in the file. Once it was opened as output and even tho you actually put nothing in it, it was able to be opened as I/O. Not really thought about it [...] 17583 21 48_Re: No memory available in the application heap.18_Eva Molina Jimenez20_evamolina@ES.IBM.COM31_Thu, 17 Jan 2002 14:32:40 +0100466_iso-8859-1 Thank's Dave for your quicky response, I'll try it.

Saludos/ Regards --------------------------------------------------- Eva Molina Jiménez. Automation/Tivoli. IBM Global Services. SPAIN Tlf: +34 91.397.94.18

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 17605 17 34_COBOL programs and DB2 subroutines14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Thu, 17 Jan 2002 08:35:24 -0500425_iso-8859-1 I have a COBOL program (XXX) that does not contain any SQL statements however it calls one (AAA), possibly two (BBB) DB2 COBOL subroutines. How do I go about binding and executing this program (XXX) and subroutine(s) (AAA & BBB). Do I only need to bind the subroutine(s)? If so, what would the JCL look like to execute program (XXX). We are using packages for everything. I really appreciate the help. Thanks [...] 17623 52 23_Re: db2 connect & DB2v516_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 17 Jan 2002 08:40:09 -0500450_iso-8859-1 We did this with DB2 V5 and CAE (5.1 I think). We are now doing this with DB2 V7 and DB2 Connect (7.2 I think). If your DB2 is V5 your DB2 Connect must be 5.x or 6.x if I remember correctly.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Steve Tennant [mailto:steve.tennant@CUSTOMS.GOV.AU] Sent: Wednesday, January 16, 2002 6:49 PM To: DB2-L@RYCI.COM Subject: db2 connect & DB2v5 [...] 17676 234 37_Re: Load problem with 'format unload'16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 17 Jan 2002 08:50:23 -0500572_iso-8859-1 Thanks for the clarification. I was about to start bashing our IBM rep for not telling us about the 50-engine box!



Regards, eric pearson NS ITO Database Support

-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: Thursday, January 17, 2002 6:15 AM To: DB2-L@RYCI.COM Subject: Re: Load problem with 'format unload'



Eric,

As someone else pointed out, it should have been CPU seconds and not minutes. Lesson - don't post to db2-l whilst someone is trying to drag you into a meeting! [...] 17911 35 21_Index SECQTY Question0_29_sflindsey@HIGHLIGHTS-CORP.COM31_Thu, 17 Jan 2002 08:58:18 -0500563_us-ascii I created the following index in V6 MVS: CREATE TYPE 2 UNIQUE INDEX PROD.I1250UP_BILL_HIST ON PROD.T1250_BILL_HIST ( ORD_NBR ,BILL_EFRT_NBR ,BILL_DT ) USING STOGROUP I12500UP PRIQTY 1332000 SECQTY 133200 ERASE NO BUFFERPOOL BP40 CLOSE NO PCTFREE 20; When I check the catalog the SQTY shows up as 32767 which works out to 131068 when multiplied by 4. According to the manual the SECQTY can be as large as 4194304. What gives? I do not think that I am missing anything in the manual but then again maybe I have lost it. Any help would be appreciated. [...] 17947 48 38_Re: COBOL programs and DB2 subroutines16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 17 Jan 2002 09:12:12 -0500528_iso-8859-1 You need one package for each program which contains SQL. You will also need a PLAN. The plan does not need to have the same name as either package. In your case, it might make sense to bind PACKAGES AAA and BBB into COLLECTION ZZZZ for example, then BIND PLAN(XXX) PKLIST (ZZZZ.*). That way your tools (Omegamon, Detector, STROBE, chargeback...) could identify the workload etc as being associated with XXX, and you would not need to worry about whether within a given XXX you first executed sql in AAA or BBB. [...] 17996 22 20_DB2 to Oracle to DB20_21_BudGreenman@ONGOV.NET31_Thu, 17 Jan 2002 09:12:11 -0500341_us-ascii We have a system that needs to communicate between a db2 database on os390 (v6 will be v7 shortly) and Oracle on Linux. Information will be taken from db2 tables and inserted into "transaction" tables to then be transferred to Oracle to be inserted in their "transaction" tables which will then be used to update their tables. [...] 18019 124 30_Re: Update vs query subsystems15_Jackson Reavill18_damcon2@US.IBM.COM31_Thu, 17 Jan 2002 09:15:03 -0500664_us-ascii Cathy and Raymond,

Thanks for your responses. My suggestion stems more from my own curiosity than experience. At a previous shop we successfully used data sharing in a development environment to do stress testing. This enabled us to setup an environment that mimicked production resources without having to duplicate the data. Obviously, this is much different than dealing with adhoc query activity accessing a production online environment, but I've wondered if the same concept could be used successfully there. Where I currently am we do the classic duplication of production data into a warehouse subsystem using either DPropR or nightly [...] 18144 96 20_Re: Backup/ Recovery17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Thu, 17 Jan 2002 08:20:38 -0600363_us-ascii We had a similar problem. The code page that is used is the code page for the pc that you are executing the command on. If you create it on your server through the CLP you will use the code page for the server. If you use the command center or control center on your pc to create the database on your server, the code page for your pc will be used. [...] 18241 57 20_Re: Oracle again....13_Adelino Regio28_adelino.regio@EDINFOR.EDP.PT31_Thu, 17 Jan 2002 14:19:00 +0000728_us-ascii Hi

The main issue is that SAP should put a 'Designed for Oracle' label in every packet...



Adelino Regio











db person @RYCI.COM> on 16-01-2002 20:11:06

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Oracle again....



Hey,

I keep seeing this "SAP runs faster on Oracle than IBM's DB2" on virtually all the magzines.... needless to say an advertisement by Oracle. Oh God, why did IBM have to make their test public....and now what are they doing to counter the propaganda? [...] 18299 66 25_Re: Index SECQTY Question14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 17 Jan 2002 15:41:27 +0100575_iso-8859-1 Hmmmm, I might be wrong, but then again, we set SECQTY usually to a max-size of 129600; the max-size is something like 131K, AFAIK, but as I said, I might be wrong.

sflindsey@HIGHLIGHTS-CORP.COM schrieb: > > I created the following index in V6 MVS: > CREATE TYPE 2 UNIQUE INDEX PROD.I1250UP_BILL_HIST > ON PROD.T1250_BILL_HIST > ( > ORD_NBR > ,BILL_EFRT_NBR > ,BILL_DT > ) > USING STOGROUP I12500UP > PRIQTY 1332000 > SECQTY 133200 > ERASE NO > BUFFERPOOL BP40 > CLOSE NO > PCTFREE 20; > When I check the catalog the SQTY shows up as 32767 which works [...] 18366 46 38_Re: COBOL programs and DB2 subroutines13_Schulz Thomas20_thomas.schulz@SVI.DE31_Thu, 17 Jan 2002 15:41:57 +0100637_us-ascii Hi Melissa,

bind the package AAA and BBB into e.G Collection Test

I suggest XXX is the Main Programm

Bind the Plan XXX

DSN SYSTEM(DB2) BIND PLAN(XXXD) + PKLIST(Test.*) +

Run the Programm XXX

//Step1 EXEC PGM=IKJEFT1B ... ... //SYSTSIN DD * DSN SYSTEM(PDB2) RUN PROGRAM(XXX) PLAN(xxx)



Melissa Rogers schrieb: > > I have a COBOL program (XXX) that does not contain any SQL statements > however it calls one (AAA), possibly two (BBB) DB2 COBOL subroutines. How > do I go about binding and executing this program (XXX) and subroutine(s) > (AAA & BBB). Do I only need to [...] 18413 46 38_Re: COBOL programs and DB2 subroutines13_Schulz Thomas20_thomas.schulz@SVI.DE31_Thu, 17 Jan 2002 15:44:33 +0100645_us-ascii Hi Melissa,

bind the package AAA and BBB into e.G Collection Test

I suggest XXX is the Main Programm

Bind the Plan XXX

DSN SYSTEM(DB2) BIND PLAN(XXXD) + PKLIST(Test.*) +

Run the Programm XXX

//Step1 EXEC PGM=IKJEFT1B ... ... //SYSTSIN DD * DSN SYSTEM(PDB2) RUN PROGRAM(XXX) PLAN(xxx)





Melissa Rogers schrieb: > > I have a COBOL program (XXX) that does not contain any SQL statements > however it calls one (AAA), possibly two (BBB) DB2 COBOL subroutines. How > do I go about binding and executing this program (XXX) and subroutine(s) > (AAA & BBB). Do I only need to [...] 18460 80 25_Re: Index SECQTY Question15_Jackson Reavill18_damcon2@US.IBM.COM31_Thu, 17 Jan 2002 09:45:44 -0500580_us-ascii Scott,

What does SECQTYI on SYSINDEXPART show?

Cheers, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 356-5317, Tie Line 8-697-5317

----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - Bavarian Motor Works -----------------------------------------------------







sflindsey@HIGHLIGHT S-CORP.COM To: DB2-L@RYCI.COM Sent by: DB2 Data cc: Base Discussion Subject: Index SECQTY Question List [...] 18541 77 15_Re: OPEN Cursor14_MIKE FRIEDRICH27_RDBA002@REVENUE.STATE.IL.US31_Thu, 17 Jan 2002 08:56:48 -0600492_US-ASCII You might try the following and depending upon your SQL it could be costly to run.

DECLARE CURSOR CS1 AS SELECT col1, col2, col3,........ FROM TABLE1 WHERE col1 = :HV and col2 = :HV and :HostVariableRowcount < (SELECT COUNT(*) FROM TABLE1 WHERE col1 = :HV and col2 = :HV)



where the "HostVariableRowcount" contains the minimum number of rows you want the cursor to have. If the resulting number of rows does not meet that amount, then no rows are returned. [...] 18619 46 25_Re: Index SECQTY Question13_Schulz Thomas20_thomas.schulz@SVI.DE31_Thu, 17 Jan 2002 16:00:36 +0100561_us-ascii Hey Scott

it looks like the Maximum of 128 MB in Version 5. you are write, in V6 is 4 Giga

sflindsey@HIGHLIGHTS-CORP.COM schrieb: > > I created the following index in V6 MVS: > CREATE TYPE 2 UNIQUE INDEX PROD.I1250UP_BILL_HIST > ON PROD.T1250_BILL_HIST > ( > ORD_NBR > ,BILL_EFRT_NBR > ,BILL_DT > ) > USING STOGROUP I12500UP > PRIQTY 1332000 > SECQTY 133200 > ERASE NO > BUFFERPOOL BP40 > CLOSE NO > PCTFREE 20; > When I check the catalog the SQTY shows up as 32767 which works out to > 131068 when multiplied by 4. According to the [...] 18666 155 25_Re: Index SECQTY Question14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 17 Jan 2002 15:03:03 -0000518_iso-8859-1 Over a certain size, SQTY is not used, SQTYI is used instead. The original catalog definition for secondary quantity was only a smallint!

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: sflindsey@HIGHLIGHTS-CORP.COM [mailto:sflindsey@HIGHLIGHTS-CORP.COM] Sent: 17 January 2002 13:58 To: DB2-L@RYCI.COM Subject: [DB2-L] Index SECQTY Question [...] 18822 41 25_Re: Index SECQTY Question12_TOM DUVERNAY21_Tom.Duvernay@USDA.GOV31_Thu, 17 Jan 2002 08:53:00 -0500589_- that is the Max 130168. if you allocate more than that it allocates it at 131068. >>> DB2 Data Base Discussion List 01/17/02 08:01AM >>> I created the following index in V6 MVS: CREATE TYPE 2 UNIQUE INDEX PROD.I1250UP_BILL_HIST ON PROD.T1250_BILL_HIST ( ORD_NBR ,BILL_EFRT_NBR ,BILL_DT ) USING STOGROUP I12500UP PRIQTY 1332000 SECQTY 133200 ERASE NO BUFFERPOOL BP40 CLOSE NO PCTFREE 20; When I check the catalog the SQTY shows up as 32767 which works out to 131068 when multiplied by 4. According to the manual the SECQTY can be as large as 4194304. What gives? I do not think that [...] 18864 16 15_Re: OPEN Cursor23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 17 Jan 2002 10:07:23 -0500588_us-ascii **************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18881 80 55_Re: Re : Drain lock waits during application processing13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 17 Jan 2002 09:28:29 -0600410_iso-8859-1 One additional comment (that may have already been mentioned -- I haven't been following this one real closely) -- some documentation I have from our vendor tool that we use to process SMF records mentions that QWACAWDR is the drain-lock time for DB2 V5 and below. For V6 you need to use QWAXAWDR. I don't know if you mentioned what version you are on, but this might be something to consider. [...] 18962 145 87_Re: Antwort: Backup/Recovery questions; Tools and Utilities compa rison [Virus checked]16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Thu, 17 Jan 2002 10:13:15 -0500387_iso-8859-1 I guess you can call this a ME TO post With an added bonus. ;-)

Compuware also has A (one) tool (DBAXpert) that does all the DBA administration tasks for DB2. If you want any more information feel free to go to our web site (www.compuware.com) or contact the local Compuware Office (ask for the File-Aid rep.) Of course you can also contact me thru direct e-mail. [...] 19108 61 44_Re: Another Resource Limit Facility question11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Thu, 17 Jan 2002 09:34:47 -0600496_us-ascii DRDA works on package names!







"Schaeffer, Dave" cc: Sent by: DB2 Data Subject: Another Resource Limit Facility Base Discussion List question



01/16/02 06:03 PM Please respond to DB2 Data Base Discussion List











I'm trying to stop long running queries from running that are using DB2 connect. This is the -DIS THREAD(*) DETAIL [...] 19170 43 23_DB2 v 7 UNION IN A VIEW15_Thomas Duvernay21_tom.duvernay@USDA.GOV31_Thu, 17 Jan 2002 09:01:30 -0600566_- We have a warehouse database with numerous tables, one now contains over 1 billion rows. This data is currently using 254 partitions. We are going to redesign next year however we need to use this structure one more year. The table like most is partitoned by time this one being YEAR, MONTH, and ORGANIZATION, which contains data from 1998 -2002. We need to include upcoming 2003 data. Since I have maxed out with 254 partitions, I was thinking of creating a new table with the same layout containing 2003 data and using the new version 7 feature "UNION IN A [...] 19214 58 55_Re: Re : Drain lock waits during application processing27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Thu, 17 Jan 2002 15:38:17 -0000542_iso-8859-1 Thanks Mike, I was beginning to think along similar lines for no better reason than I'd more or less run out of alternatives.

In view of this (and in spite of the transaction throughput), I guess I might have to consider wait time for dataset switch to read-write (from RO) as having given rise to SQL long claims. I'm assuming that the wait time for the dataset status switch will be recorded as part of service wait time. Unfortunately, the SMF stats for service wait times are largely unavailable for this exercise. [...] 19273 165 25_Re: Index SECQTY Question0_29_sflindsey@HIGHLIGHTS-CORP.COM31_Thu, 17 Jan 2002 10:33:43 -0500671_us-ascii

Thanks, Jay and Phil! Forgot that one on the migration to V6. Scott













"Grainger, Phil" on 01/17/2002 10:03:03 AM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Scott F Lindsey/HFC/HFC_Corp)





Subject: Re: Index SECQTY Question















Over a certain size, SQTY is not used, SQTYI is used instead. The original catalog definition for secondary quantity was only a smallint! [...] 19439 147 30_Re: Update vs query subsystems12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 17 Jan 2002 07:34:07 -0800553_us-ascii Only 2 periods for TSO? Yikes! I've never seen that in any well running TSO system. (Anyone out there using just 2 periods). Usually there are 3 and sometimes 4. Per1 is usually really short, and you try to get 80% or so of your transactions to complete here. Per2 is a little longer. You try to get most of the rest of the transactions to finish here. Per3 is for the long-running who knows when/if they're ever going to finish transactions. You can find the logical break points by running cluster analyses on the SMF data. If you still [...] 19587 44 28_FW: JDBC driver to OS/390 V518_Gaston, Raymond J.17_GastonRay@ORU.COM31_Thu, 17 Jan 2002 10:41:48 -0500730_ISO-8859-1 Dear DBList,

A colleague forwarded this question last week. I've seen no responses. I wonder if someone could provide some feedback.

Much appreciated - Ray Gaston =========================================================================== ====================

-----Original Message----- From: Chu, Pius [mailto:ChuP@CONED.COM] Sent: Wednesday, January 09, 2002 10:57 AM To: DB2-L@RYCI.COM Subject: JDBC driver to OS/390 V5



I like to know what are the pros and cons using the 4 types of JDBC drivers to access data in OS/390 DB2 from a difference platform. Can you use SQLJ with any of these JDBC drivers? Any one have any experiences using JDBC type 4 driver from a SUN Solaris [...] 19632 80 44_Re: Another Resource Limit Facility question0_19_csutfin@AMSOUTH.COM31_Thu, 17 Jan 2002 10:07:41 -0600498_us-ascii Dave,

I don't know if this will help you. I had basically the same problem. What I did was to limit the threads based on the LU name because I had multiple LU's and some needed more time than others.

My table entry looks like

LUNAME AD6015SY ASUTIME 986,136 RLFFUNC 2

This limits any thread from the LU to 986,136 service units. Feel free to contact me off-list if you more. I have also done some testing of using predictive governor rather than reactive. [...] 19713 50 42_DB2 udb v7.2/aix - DIAG Message analyzing.12_kishore babu25_kolla_kishore@HOTMAIL.COM31_Thu, 17 Jan 2002 11:11:33 -0500427_- Hi, Our shop is at DB2 UDB v7.2 (fixpak 3) and aix . I am getting following DIAG Warning MESSAGE:

2002-01-15-23.46.57.508658 Instance:dbadminp Node:000 PID:26316(db2agent (SVCLPC)) Appid:*LOCAL.dbadminp.020116044503 data_management sqldEscalateLocks Probe:2 Database:SVCLPC

-- Lock Count, Target : 1849, 924 -- Table (ID) Name : (3;7) LPC .PARTS -- Locks, Request Type : 1846, X -- Result (0 = success): 0 [...] 19764 69 38_Re: COBOL programs and DB2 subroutines14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Thu, 17 Jan 2002 11:22:54 -0500560_iso-8859-1 Please let me know if I'm understanding what you are stating. You bind the two DB2 subroutines into their own package in the same collection. This collection is then placed in the pklist of a plan. The main program is compiled as a normal COBOL program, no bind needed. What I'm confused about is executing the main program. How is the plan associated to the main program when the plan really contains the packages of the DB2 subroutines? Doesn't DB2 look for matching timestamps on the program and plan? Am I just really confusing myself????? [...] 19834 62 38_Re: COBOL programs and DB2 subroutines14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Thu, 17 Jan 2002 11:23:43 -0500648_iso-8859-1 This may be a silly question but how do I know if I'm using CAF or DSN?

-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Thursday, January 17, 2002 9:12 AM To: DB2-L@RYCI.COM Subject: Re: COBOL programs and DB2 subroutines



You need one package for each program which contains SQL. You will also need a PLAN. The plan does not need to have the same name as either package. In your case, it might make sense to bind PACKAGES AAA and BBB into COLLECTION ZZZZ for example, then BIND PLAN(XXX) PKLIST (ZZZZ.*). That way your tools (Omegamon, Detector, STROBE, chargeback...) [...] 19897 16 24_Re: OPEN Cursor - part 223_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 17 Jan 2002 11:40:22 -0500595_us-ascii *********************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19914 34 43_Updating a Column with a Sequence Number...18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Thu, 17 Jan 2002 11:53:10 -0500386_iso-8859-1 Dear List,

I have a 10,000 row OS/390 V5 table that has a integer column (col1). All the values in this column currently contain zeroes. I would like to update this column with incrementing numeric values as follows... (which row gets which sequence number does not matter):

col1 col2 col3 coln 1 jsd kas lasd 2 djkl ;sdl uidua 3 4 5 ioa kakdk . . . 10000 [...] 19949 115 38_Re: COBOL programs and DB2 subroutines16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 17 Jan 2002 12:29:02 -0500504_iso-8859-1 DSN uses 'batch TSO' and looks like:

//CALLTS1 EXEC PGM=IKJEFT01,DYNAMNBR=20 //STEPLIB DD DSN=SYS3.SSSS.SDSNLOAD,DISP=SH //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(SSSS) RUN PROGRAM(ZZZZ) PLAN(ZZZZ) - LIB('SYS3.SSSS.RUNLIB.LOAD') END //SYSPRINT DD SYSOUT=* //SYSIN DD *

and has no 'connection' requirements in your prog and is linkedited with INCLUDE SYSLIB(DSNELI)

CAF looks like: //STEPNAME EXEC PGM=ZZZZ,REGION=6M, // PARM='SSSS,ZZZZ' [...] 20065 20 16_tablename change3_db218_db2_user@YAHOO.COM31_Thu, 17 Jan 2002 12:00:03 -0600289_iso-8859-1 I have a bunch of COBOL programs pointing to Table A. I would like to point it to Table B temporarily for some time interval without making the program changes. So that it should be pointing to Table B when we run the batch process.

Is there anyway I can do that ?. [...] 20086 18 38_Re: COBOL programs and DB2 subroutines12_Jim Harrison17_jharrison@GMX.NET31_Thu, 17 Jan 2002 12:56:19 -0500476_us-ascii Look at your linkedit step. CAF links in DSNALI, RRSAF=DSNRLI. DSN won't have either of these.

At 11:23 AM 01/17/2002 -0500, Melissa Rogers said: >This may be a silly question but how do I know if I'm using CAF or DSN?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 20105 107 38_Re: COBOL programs and DB2 subroutines16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Thu, 17 Jan 2002 10:00:12 -0800352_iso-8859-1 The collection doesn't really matter. What it comes down to is that you create a plan for the main program containing the packages of the DB2 called programs. Then run it as you would a DB2 program.

The plan is associated with the main program by having the same name or having PLAN(xxx) explicitly stated in your run statement. [...] 20213 30 38_Re: COBOL programs and DB2 subroutines12_Jim Harrison17_jharrison@GMX.NET31_Thu, 17 Jan 2002 13:01:03 -0500521_us-ascii Each subprogram gets it's own package. When the subprogram executes and issues a SQL statement, that's when DB2 will compare time stamps (package = program). Think of the packages as special DB2 load modules, which in effect is what they are. When the program (any program) needs DB2 services, it's basically branching over to the corresponding code in the package and then back again when it's done. There is no package for the main program because you issued no SQL and the plan could care less about it. [...] 20244 145 38_Re: COBOL programs and DB2 subroutines14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Thu, 17 Jan 2002 13:10:39 -0500369_iso-8859-1 Thanks. I believe we will be using DSN. So back to the original question, when executing the main program, the run statement will contain the main program name and plan will be the plan that includes the packages created by binding the DB2 subroutine.

For example: DSN SYSTEM(DB2T) RUN PROGRAM(XXXX) PLAN(ZZZZ) - LIB('SYS3.SSSS.RUNLIB.LOAD') END [...] 20390 182 57_Backup/Recovery questions; Tools and Utilities comparison22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Thu, 17 Jan 2002 12:15:49 -0600320_- Thanks, Aurora and every one of you that replied to my questions and as usual, your answers have been extremely helpful!

We're not using Database utility to backup in our current environment. Chances are, we'll have lesser window, not more, when we go to DB2. So, I'm tying to look into all possibilities. [...] 20573 230 13_BMC LOGMASTER16_Juan Pablo Tello22_tellojp@PRODIGY.NET.MX31_Thu, 17 Jan 2002 12:03:18 -0600551_us-ascii

Hi all.

Is anyone out there using BMC LOGMASTER? I'm trying to set up with the product on an on going replication for a set of tables and the product is working fine. BUT I need to set up a process that runs automatically and LOGMASTER doesn't have any automation facility and is error prone in the process of applying the updates in the mirror environment because is difficult to have good control of what has been applied and what is waiting to be applied. If any of you have any suggestions will be really appreciated. [...] 20804 33 18_Re: COBOL Question13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Thu, 17 Jan 2002 11:55:16 -0600323_- The problem does not end with calling others 'Geeks', the signatures used by this person aren't very nice either. Here are a few from his / her different postings ( with nearest English translation ) :

Sudhar Jaa - Clean up your act

Sharam Kar. - Shame on you

Laa Ilaaj - One who can't be cured [...] 20838 18 77_How can this happen? DSNU407I - Data set already used for previous Image copy13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Thu, 17 Jan 2002 13:23:06 -0500 20857 184 38_Re: COBOL programs and DB2 subroutines16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 17 Jan 2002 13:34:14 -0500518_iso-8859-1 There is no 'PLAN TIMESTAMP' involved. There is a consistency token in the LOAD MODULE and in SYSIBM.SYSPACKAGE. When the program (package) first executes SQL, DB2 compares the consistency token in the load module to the one for the package. If SYSIBM.SYSPACKAGE does not have an entry for the package where the COLLID of the package is = to a collection identified in the PKLIST of the PLAN BAND *and* has a consistency token (usually timestamp) = to the one in the load module, you get SQLCODE -805. [...] 21042 42 21_Backup DB2 UDB 5.2 NT34_Luiz Cesar Vinhaes da Costa Junior27_vinhaes@CAIXASEGUROS.COM.BR31_Thu, 17 Jan 2002 16:35:50 -0300558_iso-8859-1 Hi listers

I'm trying to do a backup using the following command

backup database mydata user xxxx using xxxx to h:\copy the h:\copy is placed in other server and I'm receiveing the message.

SQL2036N The path for the file or device "" isnot valid. Cause: The application calling the utility has supplied a source or target path that is not valid. The path or device specified may not exist or is incorrectly specified. Action: Reissue the utility command with a path that represents a correct path or device. [...] 21085 39 20_Re: tablename change11_David Nance16_DWNance@FHSC.COM31_Thu, 17 Jan 2002 13:40:27 -0500334_US-ASCII One way, it would be to get rid of table A, either drop it or create a copy under a different name. Then create an alias or a view for table B. When you want to switch back drop the alias or the view, then recreate table A. Of course, you'll, also, have to take care of all the grants and binding of programs each time. [...] 21125 53 18_Re: COBOL Question14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Thu, 17 Jan 2002 13:34:32 -0500380_iso-8859-1 Hi Mohammad -

Not being fluent in that language (and what language is that, anyhow?) I am going to take your words (and translations) at face value. As such, this calls for an escalation to the attention of the monitors of this list.

Monitors - I call upon you to verify & confirm the veracity of what Mohammad says, and to take appropriate actions. [...] 21179 27 15_Looping DARIs ?16_Victor McDonnell31_victor_mcdonnell@FREDDIEMAC.COM31_Thu, 17 Jan 2002 13:43:21 -0500468_us-ascii Has anyone seen an application that is calling embedded-SQL C subroutines via an SQL-call (ala stored procedure) go off the deep end and write DARI messages to the log.

We have simply that. On AIX, UDB 7.1 EEE, Host C programs calling C subroutines via the SQL call returning (unintelligable) DARI log entries. The subroutines are not created nor catalogued as stored procedures. Yet they intermittently (what else) go looping with DARI messages. [...] 21207 43 20_Re: tablename change13_Olson, Carlos14_COlson@QRS.COM31_Thu, 17 Jan 2002 11:00:05 -0800460_iso-8859-1 * Create table B with the same name as A but with a different qualifier "X".

* Create synonyms with qualifier "X" for all other tables being used by the COBOL programs. * Rebind your programs with QUALIFIER(X).

Carlos Olson Database Administrator QRS Corporation



-----Original Message----- From: db2 [mailto:db2_user@YAHOO.COM] Sent: Thursday, January 17, 2002 10:00 AM To: DB2-L@RYCI.COM Subject: tablename change [...] 21251 117 82_Re: How can this happen? DSNU407I - Data set already used for pre vious Image copy12_Veedu, Manoj18_MVeedu@STATE.NM.US31_Thu, 17 Jan 2002 12:06:17 -0700341_iso-8859-1 From page 331 Db2 certfication Guide ( Richard Yevich, Susan lawson):

"Remember that GDGs are cataloged at the end of a job (not job step). If a job fails, the data set name is already recorded in SYSIBM.SYSCOPY, but not the OS/390 catalog. the next run will result in duplicate names being rejected by COPY utility." [...] 21369 66 25_Re: Backup DB2 UDB 5.2 NT17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Thu, 17 Jan 2002 13:09:46 -0600342_us-ascii DB2 version 5.2 can not be backed up to a network resource. I am having the same problem as well. I know that version 7 can, because that is what we are going to. If your database is too big to store on your local drive, try using db2move to generate the copy that you want. You can specify the target as your network resource. [...] 21436 44 19_Re: Looping DARIs ?13_Debra Roberts14_Debra@MYTA.COM31_Thu, 17 Jan 2002 14:21:40 -0500449_iso-8859-1 Hi Victor- Wish I coud help, but I can't. Good luck!

Debra

-----Original Message----- From: Victor McDonnell [mailto:victor_mcdonnell@FREDDIEMAC.COM] Sent: Thursday, January 17, 2002 1:43 PM To: DB2-L@RYCI.COM Subject: Looping DARIs ?



Has anyone seen an application that is calling embedded-SQL C subroutines via an SQL-call (ala stored procedure) go off the deep end and write DARI messages to the log. [...] 21481 27 12_Memory leaks12_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 17 Jan 2002 21:28:10 +0200378_windows-1255 Hi,

Found the culprit !!!!

Missing PTFs in OS/390 V2.10 , DB2 is NOT to be blamed :-)

Next weekend :-( we'll implement the fixes ( really the system group will do it but we plan to be very close by ...)

Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net [...] 21509 54 16_Re: Memory leaks15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Thu, 17 Jan 2002 13:34:28 -0600394_windows-1255 Which PTFs would those be? I just want to make sure our OSS person has them all on.

Thanks! Linda Billings Project Manager/Enterprise Systems Programmer State of Wisconsin Department of Electronic Government

"Clear writers assume, with a pessimism born of experience, that whatever isn't plainly stated the reader will invariably misconstrue." - John R. Trimble [...] 21564 161 30_Re: Update vs query subsystems13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Thu, 17 Jan 2002 11:37:31 -0800595_iso-8859-1 Hi Tim. Regarding TSO periods, WLM goal mode changed a lot of things. Here is a quote from "WLM Goal Mode Using a QuickStart Service Policy", 1999, Watson & Walker, Inc. --

"Most sites currently use three or four periods for TSO, but after analysis in more detail, you will generally find that second period accounts for a very few transactions and a very small amount of CPU time. In goal mode, it is more important to reduce the number of periods with goals than to try to manage this small amount of work. Sites that have used two [...] 21726 50 16_Re: Memory leaks14_Riedel, Marcia26_MRiedel@TUCSONELECTRIC.COM31_Thu, 17 Jan 2002 12:37:50 -0700591_- Isaac:

What is the PTF for OS/390 2.10? We're going production with it next weekend and I want to be sure it's on.

Thanks, Marcia Riedel Marcia Riedel DBA/SYS PROG mriedel@tucsonelectric.com 520-884-3925

> -----Original Message----- > From: Isaac Yassin [SMTP:yassini@BEZEQINT.NET] > Sent: Thursday, January 17, 2002 12:28 PM > To: DB2-L@RYCI.COM > Subject: Memory leaks > > Hi, > > Found the culprit !!!! > > Missing PTFs in OS/390 V2.10 , > DB2 is NOT to be blamed :-) > > Next weekend :-( we'll implement the fixes ( really the system group will > do it > but [...] 21777 64 16_Re: Memory leaks10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 17 Jan 2002 14:31:24 -0500479_us-ascii Issac

Did I miss something....What are the missing PTF's

Tom





Isaac Yassin cc: Sent by: DB2 Subject: Memory leaks Data Base Discussion List



01/17/02 02:28 PM Please respond to DB2 Data Base Discussion List











Hi,

Found the culprit !!!!

Missing PTFs in OS/390 V2.10 , DB2 is NOT to be blamed :-) [...] 21842 51 16_Re: Memory leaks13_Carl Pizzarro26_carl.pizzarro@HIGHMARK.COM31_Thu, 17 Jan 2002 14:37:59 -0500604_us-ascii Do you know what the PTF numbers are?











Isaac Yassin @RYCI.COM> on 01/17/2002 02:28:10 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Memory leaks

Hi,

Found the culprit !!!!

Missing PTFs in OS/390 V2.10 , DB2 is NOT to be blamed :-)

Next weekend :-( we'll implement the fixes ( really the system group will do it but we plan to be very close by ...) [...] 21894 75 38_Re: Products - Front end tools for DB210_James Kwan19_JamesDB2Kwan@CS.COM29_Thu, 17 Jan 2002 14:41:22 EST317_US-ASCII Hi Balaji

I personally have used Candle's WorkBench, CA' s RC prouducts, and BMC's Catalog Manager. There are others such as IBM and Quest (comig soon). These tools are all similar. Some might offer better functions while others are more ease to use. The bottom line is how much you want to pay. [...] 21970 70 16_Re: Memory leaks0_19_csutfin@AMSOUTH.COM31_Thu, 17 Jan 2002 13:42:20 -0600485_us-ascii Isaac,

The numbers for the PTF's would sure be helpful. We are getting ready to implement V2.10 very soon.

Thanks Carol Sutfin Corporate DBA AmSouth Bank (205)326-5214 Fax:(205)326-5613 csutfin@amsouth.com







Isaac Yassin cc: Sent by: DB2 Subject: Memory leaks Data Base Discussion List



01/17/02 01:28 PM Please respond to DB2 Data Base Discussion List [...] 22041 72 20_Re: tablename change10_James Kwan19_JamesDB2Kwan@CS.COM29_Thu, 17 Jan 2002 14:46:15 EST349_US-ASCII If your table name in your program does not have a qualifier, then you don't have to drop the table. Just created a view/alias and bind it with different qualifier. Bind it again with the original qualifier once you finish.

James Kwan

In a message dated 1/17/02 1:04:05 PM Central Standard Time, DWNance@FHSC.COM writes: [...] 22114 115 47_Re: Updating a Column with a Sequence Number...10_James Kwan19_JamesDB2Kwan@CS.COM29_Thu, 17 Jan 2002 14:54:49 EST295_US-ASCII Ray,

This might not the best way to do it, but it is quite simple. 1) Create a temp table like the original table with one addition Identity columns 2) Insert into this table with select * from the original table 3) Either update or delete/insert back to the original table [...] 22230 97 16_Re: Memory leaks12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 17 Jan 2002 14:55:14 -0500470_us-ascii Isaac, could you tell us what the PTF's are and what level your OS/390 V2.10 is at? Thanks.







Isaac Yassin Sent by: DB2 Data Base Discussion List 01/17/02 02:28 PM Please respond to DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Memory leaks



Hi,

Found the culprit !!!!

Missing PTFs in OS/390 V2.10 , DB2 is NOT to be blamed :-) [...] 22328 55 18_Re: COBOL Question13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Thu, 17 Jan 2002 13:32:42 -0600354_- Hi Shaul As for the signatures used, you can verify my claim by checking the web. I found all these in current week's postings. Probably I should have mentioned earlier, the language is Hindi / Urdu and my renderings can be verified by many on this list ( any North Indian / Pakistani ). It's a really nice place, let's keep it that way. Mohammad [...] 22384 72 28_Re: JDBC driver to OS/390 V514_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 17 Jan 2002 15:02:33 -0500399_iso-8859-1 Ray:

I have not personally benchmarked it but have been told by our IBM representative that it is very slow compared to the Type 2 (app driver). We were looking at Type 4 driver to see if we can eliminate DB2 Connect as DRDA capability is built in Type 4 driver. Heard it somewhere that V8 onwards IBM would supply Type 4 driver - currently only 3rd parties make this driver. [...] 22457 200 38_Re: COBOL programs and DB2 subroutines14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Thu, 17 Jan 2002 15:05:46 -0500698_iso-8859-1 Thanks to everyone for helping me understand this process. Being new to DB2, I've found myself relying on this discussion list!! Many thanks, Melissa

-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Thursday, January 17, 2002 1:34 PM To: DB2-L@RYCI.COM Subject: Re: COBOL programs and DB2 subroutines



There is no 'PLAN TIMESTAMP' involved. There is a consistency token in the LOAD MODULE and in SYSIBM.SYSPACKAGE. When the program (package) first executes SQL, DB2 compares the consistency token in the load module to the one for the package. If SYSIBM.SYSPACKAGE does not have an entry for the package where the COLLID [...] 22658 126 47_Re: Updating a Column with a Sequence Number...18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Thu, 17 Jan 2002 15:23:39 -0500606_iso-8859-1 Thanks James, but I'm not sure that DB2 V5 supports Identity columns (that's the problem). - Ray

-----Original Message----- From: James Kwan [mailto:JamesDB2Kwan@CS.COM] Sent: Thursday, January 17, 2002 2:55 PM To: DB2-L@RYCI.COM Subject: Re: Updating a Column with a Sequence Number...



Ray,

This might not the best way to do it, but it is quite simple. 1) Create a temp table like the original table with one addition Identity columns 2) Insert into this table with select * from the original table 3) Either update or delete/insert back to the original table [...] 22785 159 66_Re: Antwort: IBM equivalent of Princeton Softech's Compare for DB212_Raymond Bell17_rbell@NZ1.IBM.COM31_Fri, 18 Jan 2002 09:29:04 +1300309_iso-8859-1 Ooh, Aurora, I'm deeply hurt. Of course I've heard of the !DB tools. Hmmm, maybe I should get IBM to buy !Candle, then I can suggest them as IBM tools. Must remember to mention it to Lou the next time we play golf (yeah, right).



Raymond PS. Hope you're enjoying München; I did. [...] 22945 33 47_Re: Updating a Column with a Sequence Number...0_19_Tim.Lowe@STPAUL.COM31_Thu, 17 Jan 2002 14:32:05 -0600548_us-ascii Ray, Is there any way that you might be migrating from DB2 V5 to DB2 V6 on OS/390 anytime soon? With DB2 V6 on OS/390, you could use the simple UDF that Mohammad Khan sent in response to the thread last week called "Getting Row number in 'SELECT'". His UDF returns a sequential number every time it is called, and could be used to do what you are asking. For example, the following statement: UPDATE tblname SET col1 = PARISP.SEQ () would set col1 in every row to a unique sequential number, just as you asked. If you are interested, [...] 22979 51 47_Re: Updating a Column with a Sequence Number...18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Thu, 17 Jan 2002 15:47:18 -0500411_ISO-8859-1 Thanks very much Tim... Actually, we'll me migrating from DB2 V5 directly to DB2 V7 later on in 2002. However, for now, I'm still stuck with this V5 "sequence number problem".

- Ray

-----Original Message----- From: Tim.Lowe@STPAUL.COM [mailto:Tim.Lowe@STPAUL.COM] Sent: Thursday, January 17, 2002 3:32 PM To: DB2-L@RYCI.COM Subject: Re: Updating a Column with a Sequence Number... [...] 23031 56 33_Datasharing and row Level locking12_Chris Munson18_cmunson@US.IBM.COM31_Thu, 17 Jan 2002 12:58:59 -0800568_us-ascii Brian, I see that there have already been some good comments on this subject. The only 2 cents worth I thought I would throw in is in regards to your workload type. As previously mentioned, it is the negotiation of page p-locks (required when RLL is used) that are expensive. The actual page p-lock itself is not that expensive. For most OLTP workloads this shouldn't tend to be a problem because of the quantity of rows that are usually updated on-line. It tends to be in the batch world where the problem arises. The less than optimal scenario is when [...] 23088 166 82_Re: How can this happen? DSNU407I - Data set already used for pre vious Image copy0_16_khampto1@TXU.COM31_Thu, 17 Jan 2002 15:29:34 -0600436_us-ascii

One way we minimize the chances of this error is to code DISP=(NEW,CATLG,CATLG) on the output DD for the Image COpy dataset. That way the dataset is still cataloged even if the step abends, and it skips to the next GDG version number upon restart. One other thing would be to code RLSE on the space allocation if you are Image Copying to DASD, so that you do not keep a big,empty dataset in the event of an abend. [...] 23255 28 22_Command Centre problem13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Fri, 18 Jan 2002 08:43:20 +1100387_iso-8859-1 First...UDB V7.2 + FP4

When I enter a couple of commands in the script window separated by ";" all is well.

if I put in some DML (Create/Drop etc) I get an error complaining about the terminator. the only way I can get it to run is to turn off the terminator option, remove the semicolons and rely on carriage-returns. When I do this everything works fine. [...] 23284 56 24_Re: DB2 to Oracle to DB20_16_khampto1@TXU.COM31_Thu, 17 Jan 2002 15:42:43 -0600524_us-ascii I'm not sure if DB2 UDB Personal Edition on Linux has the connectivity code to connect to DB2 on OS/390, but if it does, you would be able to pull the information from DB2 on OS/390 and store it in DB2 on Linux. But Relational Connect does not allow updates into Oracle until Version 8 comes out. So you would be forced to use DataJoiner if you did not want to wait for UDB ver 8. Or you might want to look at Oracle Transparent Gateway for DRDA, which can connect to DB2 on OS/390 similarly to DB2 Connect or [...] 23341 112 80_Re: How can this happen? DSNU407I - Data set already used forprevious Image copy12_Tony Vermeer24_tony.vermeer@SAFEWAY.COM31_Thu, 17 Jan 2002 13:55:50 -0800529_iso-8859-1 There are a couple of ways that I know you can encounter this problem. We used to run into them quite often some time back. One situation that causes this problem is having an imagcopy dataset that has an expiry date that uses date control like EXPDT=98006 (6 days). If this was in a JCL that runs, let's say weekly, the last copy would have been uncatalogued after 6 days passed and when the job runs on the 7th day, it would try to backup the same GDG number as it did the week before. The DB2 and ICF catalogs [...] 23454 20 82_Re: How can this happen? DSNU407I - Data set already used for pre vious Image copy10_Mark Doyle19_mdoyle@JCPENNEY.COM31_Thu, 17 Jan 2002 16:10:20 -0600515_- 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 the reader of this message is not the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you received this in error, please contact the sender and delete the material from any computer. [...] 23475 55 26_Re: Command Centre problem11_Jakobs, Jef18_JJakobs@HARTIC.COM31_Thu, 17 Jan 2002 16:07:01 -0600295_iso-8859-1 I have a feeling that this is a FP4 "feature"

Bumped into it myself too on DB2 UDB 7.1 + FP3 + FP4... (should be equal to DB2 UDB 7.2 + FP4).

Used to be able to run three DML commands that each had a semicolon as their terminating character (on DB2 UDB 7.1 + FP3). [...] 23531 78 38_Re: COBOL programs and DB2 subroutines10_Mark Doyle19_mdoyle@JCPENNEY.COM31_Thu, 17 Jan 2002 16:21:13 -0600569_iso-8859-1

This is a question on a related subject. If a Non-DB2 Cobol program calls 1 or more DB2 stored procedures written in cobol, is there any way (other than passing info through the parm list) to see the results of the SQL in the Stored Procedure? Our program / stored procedures will run in batch, and the developer vaguely remembers that there is a way to allow the stored procedure to write to SYSOUT, but he seems to remember that it required some change to zparms. Has anybody heard of this? Alternately, how else could we get the results from [...] 23610 49 26_Re: Command Centre problem13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 17 Jan 2002 16:26:04 -0600363_US-ASCII Steve, This bug was introduced in Fixpak 4. It also affects the GEN DDL from the Control Center. JR16473 is the apar for this defect. Going to TOOLS and TOOLS settings and unchecking the use termination character field is a temporary fix for this problem. HTH Kurt

>>> steve.tennant@CUSTOMS.GOV.AU 01/17/02 03:43PM >>> First...UDB V7.2 + FP4 [...] 23660 101 38_Re: COBOL programs and DB2 subroutines0_16_khampto1@TXU.COM31_Thu, 17 Jan 2002 16:57:03 -0600493_us-ascii A Non-DB2 program cannot call a DB2 stored procedure, because the stored procedure CALL statement is an SQL verb. So you calling program will have to be a DB2 program and have its package/plan bound.

By "results of the SQL in the Stored Procedure" are you asking whether you can see an SQLCODE ? I do not believe an SQLCODE resulting from a statement executed within the SP will be passed back to the calling program, unless you specifically pass it as a return variable. [...] 23762 123 38_Re: COBOL programs and DB2 subroutines10_Mark Doyle19_mdoyle@JCPENNEY.COM31_Thu, 17 Jan 2002 17:07:14 -0600372_iso-8859-1 Oh . . . did I forget to mention that we're looking for the SQLCODE, etc. for the SQL in the stored procedure (not the results of the SP call) ? ----- Original Message ----- From: "Mark Doyle" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, January 17, 2002 4:21 PM Subject: Re: COBOL programs and DB2 subroutines [...] 23886 15 46_Re: Unknown V7 Abend 00C900CF on COPY - Answer12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jan 2002 17:31:52 -0600267_- That's not how it worked here. If you have PQ47079 on, then there should be no abends. Please do a display MEPL for the modules DSNIPSFI & DSNIPSI to be sure you are running the right level. If they are from that APAR, call service and get us the information. [...] 23902 18 27_Re: DB2 v 7 UNION IN A VIEW12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jan 2002 17:42:52 -0600449_- The best synopsis for UNION in a view on V7 is probably in our Redbooks. If you want the performance aspects, try pages 49 to 60 in SG24-6129 V7 Performance Topics. If you want more explanation of the function, then that would be pages 23 to 37 in SG24-6121 V7 Presentation Guide. You can get the Redbooks from the web either ibm.com/redbooks or the main DB2 for z/OS and OS/390 web page ibm.com/software/db2os390, then Support and Redbooks. [...] 23921 61 26_Re: Command Centre problem13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Fri, 18 Jan 2002 11:25:56 +1100581_iso-8859-1 Thanks Jef and Kurt I'll check out the apar.

BTW any idea if it's fixed if FP5?

Steve T

-----Original Message----- From: Kurt Sahlberg [mailto:Kurt.Sahlberg@EXPERIAN.COM] Sent: Friday, 18 January 2002 9:26 AM To: DB2-L@RYCI.COM Subject: Re: Command Centre problem



Steve, This bug was introduced in Fixpak 4. It also affects the GEN DDL from the Control Center. JR16473 is the apar for this defect. Going to TOOLS and TOOLS settings and unchecking the use termination character field is a temporary fix for this problem. HTH Kurt [...] 23983 34 15_Existence Check24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 17 Jan 2002 16:35:43 -0800446_- Hi Everyone!

We're currently in the process of upgrading our PeopleSoft HRMS application from version 7 to version 8. As part of that process, we've encountered a number of SQL statements similar to the following:

SELECT 'PS_DOES_TABLE_EXIST' FROM PS_TAX_BALANCE WHERE 1 = 0 FOR FETCH ONLY

This looks like it would work fine for small tables, but we have several tables that exceed 20 million rows, mostly compressed. [...] 24018 14 8_Re: NTEs12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jan 2002 17:57:36 -0600477_- OUTER JOIN in DB2 was in Version 4, with big performance improvements in Version 6. UNION and UNION ALL are allowed in Version 7, but not before, for CREATE VIEW, table-specifications and predicates.

Roger Miller, DB2 for z/OS

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 24033 85 26_Re: Command Centre problem13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 17 Jan 2002 19:10:39 -0600492_US-ASCII Hi Steve, I have downloaded Fixpak 5 and it's not on the APAR list. It's still open. I hope it will be in FP6. Kurt





>>> steve.tennant@CUSTOMS.GOV.AU 01/17/02 06:25PM >>> Thanks Jef and Kurt I'll check out the apar.

BTW any idea if it's fixed if FP5?

Steve T

-----Original Message----- From: Kurt Sahlberg [mailto:Kurt.Sahlberg@EXPERIAN.COM] Sent: Friday, 18 January 2002 9:26 AM To: DB2-L@RYCI.COM Subject: Re: Command Centre problem [...] 24119 89 26_Re: Command Centre problem13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Fri, 18 Jan 2002 12:55:47 +1100405_iso-8859-1 Thanks again Kurt, I guess I'd better stop being lazy and go downloading!

-----Original Message----- From: Kurt Sahlberg [mailto:Kurt.Sahlberg@EXPERIAN.COM] Sent: Friday, 18 January 2002 12:11 PM To: DB2-L@RYCI.COM Subject: Re: Command Centre problem



Hi Steve, I have downloaded Fixpak 5 and it's not on the APAR list. It's still open. I hope it will be in FP6. Kurt [...] 24209 54 17_Re.COBOL question9_db person20_db2_person@YAHOO.COM31_Thu, 17 Jan 2002 18:33:41 -0800602_us-ascii Well well....my innocuous mails seem to have bruised many a souls. I am sure my explanation would more than pacify (and amuse) all.

While writing the mails, my wife was standing besides me and mocking me with all the choicest expletives... like 'shame on you'....so many years in DB2 and you don't even know such simple things etc. etc. Uxoriuos, as I am (who is not??), I used all these expletives as my signatures to describe MYSELF. So, these signatures were NOT intended to offend anyone. I was just mocking myself for asking such simple questions...after all those years with [...] 24264 21 20_Re: Oracle again....12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jan 2002 21:14:37 -0600298_- Please talk to an IBM data management person about benchmarketing. Ask them to talk to you about DB2 INFObriefs #45 & 638. DB2 runs SAP faster than anyone. Most of our field people will be going to their meeting next week to celebrate and kick off 2002, but maybe you can catch them Friday. [...] 24286 69 19_Re: Existence Check22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 18 Jan 2002 10:01:49 +0530605_- Fritz,

You are very correct that for big tables this query is going to scan the tablespace which is very costly.Answer to the 2nd question depends on whether you are hitting every rows in the table. All your questions are discussed very often in DB2-L. You can look in the archive for existence checking. There is a very good presentation by Issac Yassin which explains all the good and bad ways for existence checking. Look at the URL :- http://www.quest-pipelines.com/Pipelines/DB2/archives.htm#news9 for presentation title "Existence Checking, Good vs. Bad (April 2001) by Isaac Yassin". [...] 24356 56 13_Datalinks Mgr13_Abi Manoahran23_abi@PROTEOMESYSTEMS.COM31_Thu, 17 Jan 2002 22:06:24 -0600337_- Hi, I am currently setting up a Datalinks server. It is in AIX 5.1 with DB2 7.2 EEE and Dalinks server 7.2 on same server.

I have installed the links manager without any problem. When I setting up file system for then DMLF then I am getting the following error message. I am following the IBM docs as reference to do this. [...] 24413 45 26_Errors in DB2DIAG.LOG file12_Dauncey, Ian18_idauncey@FNB.CO.ZA31_Fri, 18 Jan 2002 07:02:13 +0200466_iso-8859-1 Hi all,

Our system is DB2 UDB version 6.1 running on an AIX platform.

We are receiving the following error in the DB2DIAG.LOG file

2001-10-11-09.29.05.441605 Instance:db2inst1 Node:000 PID:20606(java) Appid: oper_system_services sqlocshr Probe:200 DIA9999E An internal error occurred. Report the following error code : " 18".

Can anyone tell me what is causing this problem or where can I find out what error code '18' is [...] 24459 114 19_Re: Existence Check13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Fri, 18 Jan 2002 00:05:46 -0600392_iso-8859-1 Fritz,

Actually a non-matching index scan will suffice for this access path rather than a tablespace scan since all columns (which is none) can be satisfied by any index. So to answer question 2, the index is not compressed, so there is need to uncompress. Had a tablespace scan been chosen (ie. you selected a data column), then you would need to uncompress each row. [...] 24574 76 21_Re: Re.COBOL question12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 18 Jan 2002 09:38:13 +0200693_iso-8859-1 Hi, Still hiding behind "db person" and "interesting signatures" ???

Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net ----- Original Message ----- From: "db person" Newsgroups: bit.listserv.db2-l To: Sent: Friday, January 18, 2002 4:33 AM Subject: Re.COBOL question



> Well well....my innocuous mails seem to have bruised > many a souls. I am sure my explanation would more than > pacify (and amuse) all. > > While writing the mails, my wife was standing besides > me and mocking me with all the choicest expletives... > like 'shame on [...] 24651 71 47_Re: Updating a Column with a Sequence Number...10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 18 Jan 2002 18:44:31 +1100317_us-ascii Ray,

One quick and dirty way is to unload the data into an Excel spreadsheet (i.e UNLOAD the data into a dataset, download the data into a text file, and open it in Excel). Update the column COL1 in the spreadsheet with increasing nos. Thats very easy in Excel. Then load the data back into DB2. [...] 24723 182 16_Re: Memory leaks12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 18 Jan 2002 09:43:00 +0200439_iso-8859-1 Hi, Sorry - forgot the papers at work ... Will be there on Sunday and mail it. I do apologize again for forgetting them !

Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net ----- Original Message ----- From: Jeff Frazier Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Thursday, January 17, 2002 9:55 PM Subject: Re: Memory leaks [...] 24906 157 38_Re: Products - Front end tools for DB212_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 18 Jan 2002 09:47:40 +0200623_iso-8859-1 Hi, I'm using (different customers) BMC, CA, Candle, IBM (by A-B-C) and while there are some differences, you can live with them all, what's missing (in each) I use REXX to build. The question of price (buying, upgrading,yearly maint. ...) is usually the main factor for the customers.

Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net ----- Original Message ----- From: James Kwan Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Thursday, January 17, 2002 9:41 PM Subject: Re: Products - Front end tools for DB2 [...] 25064 82 68_SEQ UDF function (Was : Updating a Column with a Sequence Number...)10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 18 Jan 2002 18:54:03 +1100344_us-ascii Tim,

I too agree. That was a very neat way to generate row nos. I infact found it useful to generate common querynos for different EXPLAINs of the same program (where the explained querynos vary) so that I can compare the accesspaths easily. (dont ask me why I do that, just thought I wd find a quick use for the function) [...] 25147 23 24_Memory Leaks - apologize12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 18 Jan 2002 09:49:40 +0200527_windows-1255 SORRY - I forgot the paper with all the info. on my desk at work !!!

I'll be there on Sunday and will send !

SORRY AGAIN !

Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 25171 41 20_Re: tablename change22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 18 Jan 2002 14:06:22 +0530341_- If i am not wrong RENAME should work in this case. You need to RENAME Table A to some dummy name and Table B to Table A. Bind the application and you will be able to use Table B as Table A.

There are certain restrictions on RENAME regarding existance of view, synonyms and alias. You can refer thru' the same in Sql Reference. [...] 25213 40 17_Re: BMC LOGMASTER14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Fri, 18 Jan 2002 03:57:46 -0600492_iso-8859-1 Hi Juan,

you don't say exactly what the problem is so I can't help you here, but my suggestion would be to talk to BMC support.

Colin Clayton DB2 Recovery Product Line Coordinator OS/390 & Database Solutions EMEA Customer Support Center

(IBM Certified Solutions Expert - DB2 UDB Database Administration for OS/390)



____________________________________________________________________________ _______________________________________________ [...] 25254 196 67_Re: Antwort: IBM equivalent of Princeton Softech's Compare for DB 210_Alan Johns27_ajohns@PRINCETONSOFTECH.COM31_Fri, 18 Jan 2002 05:45:45 -0500556_iso-8859-1 Hello Raymond. Guess what, I work for Princeton Softech as a techie (don't worry, I'm not a sales type person). I was interested in your comment that Compare works rather like ISPF 3.13. In so far as it is a comparison process I suppose that is correct. However, we designed Compare so that you can use physical and logical data relationships to visualise data changes down through an entire related set on tables in one go, and then zoom in on the ones you are interested in. In other words, track through the data in the same way as your [...] 25451 39 31_How to see the data in an Index15_Durga Vamsidhar22_durga.vamsidhar@DB.COM31_Fri, 18 Jan 2002 11:16:14 +0100283_iso-8859-1 Dear listers,

I would like to ask a question regarding DB2. May be it is some thing not important but I think there may be a way to find out what is the data availavle for an existing index on a table XXX.

If some body knows about this, please help me. [...] 25491 65 16_R: BMC LOGMASTER18_MARCOTULLI ARMANDO26_AMarcotulli@EULERGROUP.COM31_Fri, 18 Jan 2002 12:01:31 +0100490_iso-8859-1 Hi Juan. We did the same some years ago using our scheduler to run a LOGMASTER job every 3 minutes, it worked fine. You have to specify a parameter (I do not remeber exactly which one) to increment automatically the RBA from where every LOGMASTER job has to start.



Armando





-----Messaggio originale----- Da: Juan Pablo Tello [mailto:tellojp@PRODIGY.NET.MX] Inviato: giovedì 17 gennaio 2002 19.03 A: DB2-L@RYCI.COM Oggetto: BMC LOGMASTER [...] 25557 78 35_Re: How to see the data in an Index22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 18 Jan 2002 17:06:06 +0530336_iso-8859-1 Vamsi,

Not sure what is the requirement of finding out the data in index. Index will contain keys for all the columns associated with it. Values for keys will be retrieved from index. So, if tablespace/indexspace is not in restricted state then SELECT 'index columns' FROM TABLE will give you the data available. [...] 25636 23 17_Re: BMC LOGMASTER14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Fri, 18 Jan 2002 05:57:10 -0600388_iso-8859-1 Juan,

I should have mentioned this on the last post. you need to specify LOG MARKS to define a point of consistency for the tablespaces you are migrating data for. You can then refer to these points by relative generation (0, -1 etc) in your LOGSCAN step to generate the migrate SQL file. The process is described in Chapter 7 of the Log Master for DB2 User Guide. [...] 25660 142 55_Re: Re : Drain lock waits during application processing27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Fri, 18 Jan 2002 09:19:12 -0000472_iso-8859-1 Thanks Mike, I'd just this afternoon noticed the QWAX* variable names for the various service wait stats. Unfortunately these seem to pre-date those named QWAC*. However, I hadn't spotted that for drain lock wait, which as you say is the more recent field name. Just tried it and it yields null values using SAS to report from a PDB. Can't tell if this is accurate or not as have encountered similar wrt other fields which Omegamon/DB2 shows as populated. [...] 25803 220 55_Re: Re : Drain lock waits during application processing25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE31_Fri, 18 Jan 2002 13:25:16 +0100308_iso-8859-1 Hi Warwick,

I saw this post the other day but my new e-mail address has been down with a serious cold in the head (due to local temperatures), so I will have a jab a this only now.

Apologies if it's old stuff etc. - I cannot check the archives until they let me surf the net... [...] 26024 14 27_Re: DB2 v 7 UNION IN A VIEW15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 18 Jan 2002 06:55:09 -0600436_- To your second question:

You cannot add partitions without dropping and recreating the entire tablespace. There are a lot of tools on the market, which support you in getting done that.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 26039 86 19_Re: Existence Check17_Anthony Ray Gould17_agould@UAKRON.EDU31_Fri, 18 Jan 2002 08:27:46 -0500504_iso-8859-1 We've encountered the same problem here and our solution was to code the following SQL statement, run, copy the results and run the SQL statements in spufi, WINSQL, etc.

The process is run anytime views need to be recreated in PeopleSoft either in Application Designer or in a Data Mover Script as part of an upgrade. I contacted PeopleSoft about changing the way they determine whether a view needs to be dropped before creating the view but they said it was working as designed. [...] 26126 78 57_Re: IBM equivalent of Princeton Softech's Compare for DB211_Rich Specht28_RSpecht@PRINCETONSOFTECH.COM31_Fri, 18 Jan 2002 09:05:06 -0500569_iso-8859-1 Aurora,

With all due respect to the Candle products, Compare for DB2 address a different problem than !DB/Tools. Compare for DB2 is used during test/QA to analyze the data, not the definition of the objects. Typically, the user will take a Snapshot of an entire set of data the application uses (in perhaps hundreds of tables). Then, after running their test, they will use Compare to analyze the Snapshot against the current set of data. All of the data differences are noted and Compare shows in a parent row that a dependant row has a change. [...] 26205 13 24_Re: DB2 to Oracle to DB213_Waldo Tumanut52_Waldo_Tumanut/MO/americancentury@AMERICANCENTURY.COM31_Fri, 18 Jan 2002 07:52:40 -0600406_- Several ways to do it. Assuming that you just want to do an unload then load, you can "unload" using DB2 Connect on the Linux and load to Oracle using sql loader.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 26219 78 30_Re: Errors in DB2DIAG.LOG file12_kishore babu25_kolla_kishore@HOTMAIL.COM31_Fri, 18 Jan 2002 09:37:23 -0500703_- Hi Ian, Did you get any error following this diag message, LIKE error code with prefix ffff or sqlca or sqlcode ??? or any warning messages . Then we can find out inforamtion from Trouble shooting guide.

Thanks Kishore Kolla



>From: "Dauncey, Ian" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Errors in DB2DIAG.LOG file >Date: Fri, 18 Jan 2002 07:02:13 +0200 > >Hi all, > >Our system is DB2 UDB version 6.1 running on an AIX platform. > >We are receiving the following error in the DB2DIAG.LOG file > >2001-10-11-09.29.05.441605 Instance:db2inst1 Node:000 >PID:20606(java) Appid: >oper_system_services sqlocshr [...] 26298 97 17_Re: Datalinks Mgr12_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 18 Jan 2002 06:09:08 -0800557_us-ascii Looks to me like the userid you are using doesn't have write permissions for file system /test. Tim --- Abi Manoahran wrote: > Hi, > I am currently setting up a Datalinks server. It is > in AIX 5.1 with DB2 7.2 > EEE and Dalinks server 7.2 on same server. > > I have installed the links manager without any > problem. When I setting up > file system for then DMLF then I am getting the > following error message. I > am following the IBM docs as reference to do this. > > /usr/lpp/db2_07_01/instance/dlfmfsmd /test > [...] 26396 49 20_Re: Backup/ Recovery17_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Sat, 19 Jan 2002 01:56:44 +1100338_us-ascii Russell, Are you trying to do the restore from the DB2 Control Center on a different platform

eg database and the backup are for AIX by you are running the Restore via the Control Center on NT.

If you are - use the CC and save then script then run. I had this problem recently and that is how I got around it. [...] 26446 62 30_Re: Errors in DB2DIAG.LOG file17_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Sat, 19 Jan 2002 02:03:43 +1100372_us-ascii Ian, We had this and it was to do with a problem with AIX Shared Memory Segments. There is an easy fix for UDB 7.2 but for 6.1 it is more complicated in that you have to set up a loopback on your local database.

Not sure if your problem but if you are using AIX and people are finding they can't connect or something like that it may be your problem. [...] 26509 23 48_Re: Datapropagator v7 on Z/OS release 1 w/DB2 V715_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 18 Jan 2002 09:02:35 -0600555_- William

I want to digress a little bit. From your reply I conclude that you have some (or much) experience with datapropagator. We are in a big project, in which it will be necessary to migrate a huge amount of data. We want do this in two steps: First initial load all tables in the target system and then replicate all changes with DPROP made after the initial load is done. What do you think about replicating all our tables (capturing of data should ran over a week time frame). Some figures: about 1500 to 1800 tables, dayly updates of [...] 26533 217 55_Re: Re : Drain lock waits during application processing27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Fri, 18 Jan 2002 14:56:55 -0000311_iso-8859-1 Thanks Aurora, That's about where I'd got to as of yesterday afternoon.

Unfortunately, following a note about SMF field names from Mike Vaughan, I'm now a little concerned about the validity of the SMF data cut by DB2 (v6). Difficult to see how this could be in error - am investigating. [...] 26751 112 30_Re: Errors in DB2DIAG.LOG file11_Judy Kibler21_judith.kibler@TRW.COM31_Fri, 18 Jan 2002 09:40:59 -0600763_us-ascii Richard,

I am interested in learning more about the "easy fix for this is on UDB 7.2". Can you point me in the right direction?

Thanks, Judy







Richard Cotterill on 01/18/2002 09:03:43 AM

Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc: (bcc: Judy Kibler/Nashville)





Subject: Re: Errors in DB2DIAG.LOG file















Ian, We had this and it was to do with a problem with AIX Shared Memory Segments. There is an easy fix for UDB 7.2 but for 6.1 it is more complicated in that you have to set up a loopback on your local database. [...] 26864 124 47_Re: Updating a Column with a Sequence Number...18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Fri, 18 Jan 2002 10:45:27 -0500529_iso-8859-1 thanks again James!

-----Original Message----- From: James Kwan [mailto:JamesDB2Kwan@CS.COM] Sent: Thursday, January 17, 2002 2:55 PM To: DB2-L@RYCI.COM Subject: Re: Updating a Column with a Sequence Number...



Ray,

This might not the best way to do it, but it is quite simple. 1) Create a temp table like the original table with one addition Identity columns 2) Insert into this table with select * from the original table 3) Either update or delete/insert back to the original table [...] 26989 47 47_Re: Updating a Column with a Sequence Number...18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Fri, 18 Jan 2002 10:45:57 -0500657_ISO-8859-1 Tim...again thanks!

-----Original Message----- From: Tim.Lowe@STPAUL.COM [mailto:Tim.Lowe@STPAUL.COM] Sent: Thursday, January 17, 2002 3:32 PM To: DB2-L@RYCI.COM Subject: Re: Updating a Column with a Sequence Number...



Ray, Is there any way that you might be migrating from DB2 V5 to DB2 V6 on OS/390 anytime soon? With DB2 V6 on OS/390, you could use the simple UDF that Mohammad Khan sent in response to the thread last week called "Getting Row number in 'SELECT'". His UDF returns a sequential number every time it is called, and could be used to do what you are asking. For example, the following statement: UPDATE [...] 27037 69 21_Re: Re.COBOL question13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Fri, 18 Jan 2002 09:25:30 -0600498_- Hi ( ... don't know what name to use ... ) When you say that signatures describe you, you are normally correct and I conceded as much about two of your signatures ( Laa Ilaj & Gaya Guzra ). But the other two you used are IMPERATIVE sentences and by definition apply to the addressee. As for your 'MAAF KAR', it's whole heartedly accepted. Mohammad PS: BTW don't you think MAAF KIJIYE is more appropriate ! Well I come from Aligarh and we take the difference between AAP and TUM seriously :) [...] 27107 18 47_Identify the user list when database is running5_Subha22_subha_sivaji@YAHOO.COM31_Fri, 18 Jan 2002 09:30:08 -0600305_- Hi List users,

I am having a problem of some one calling me and asking me What happend to the Data , Whenever I take the TS offline for offline utilities to run . Can anyone help me How can I identify the users currenly using the related TS , so that I can ask them to wait till I am done . [...] 27126 225 21_Re: Re.COBOL question13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Fri, 18 Jan 2002 09:15:21 -0800665_iso-8859-1 Uxorious, I am not.

-----Original Message----- From: db person [mailto:db2_person@YAHOO.COM] Sent: Thursday, January 17, 2002 6:34 PM To: DB2-L@RYCI.COM Subject: Re.COBOL question



Well well....my innocuous mails seem to have bruised many a souls. I am sure my explanation would more than pacify (and amuse) all.

While writing the mails, my wife was standing besides me and mocking me with all the choicest expletives... like 'shame on you'....so many years in DB2 and you don't even know such simple things etc. etc. Uxoriuos, as I am (who is not??), I used all these expletives as my signatures to describe MYSELF. So, [...] 27352 37 32_DPROP Subscription Script Create16_Frank E. Giguere13_giguef@NU.COM31_Fri, 18 Jan 2002 12:23:02 -0500514_us-ascii Hello All,

We are installing DPROP onto DB2 (s/390 v.5). I am in the process of creating our first subscription using Control Center (DB2 Connect V7.1). I have had no problem storing (on my C: drive UDB server) the Source Table Registry script, which I have executed successfully. Where we are encountering difficulty is in saving the Subscription Script. I get all the way up to the point where the script is to be stored, type in the path and file name, hit enter, but nothing gets written. [...] 27390 131 72_Re: SEQ UDF function (Was : Updating a Column with a Sequence Number...)0_19_Tim.Lowe@STPAUL.COM31_Fri, 18 Jan 2002 11:37:00 -0600621_us-ascii Kals, How about using a nested table expression like this: Select col1, seq() from (select col1 from table1 group by col1)

By the way, the DB2 Application Programming and SQL Guide, has some very interesting comments about a user-defined function that they called COUNTER that performs exactly the same function. It shows some other peculiar behavior of a UDF like this. The topic is "Recommendations for user-defined function invocation" in chapter 4-3. It seems strange that they did not ship this as one of the "user-defined function samples shipped with DB2" since they have obviously tested it. [...] 27522 17 72_Re: SEQ UDF function (Was : Updating a Column with a Sequence Number...)0_19_Tim.Lowe@STPAUL.COM31_Fri, 18 Jan 2002 11:41:24 -0600403_us-ascii Kals, I am sorry, that should have had one more character at the end. (any character!) Select col1, seq() from (select col1 from table1 group by col1) A

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 27540 194 21_Re: Re.COBOL question14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Fri, 18 Jan 2002 12:58:58 -0500614_iso-8859-1 Here's the definition I picked up from the dictionary for Uxorious:

Excessively submissive or devoted to one's wife.

So, obviously, Cathy, you CANNOT be that...

-----Original Message----- From: Taddei, Cathy [mailto:Cathy.Taddei@PACIFICORP.COM] Sent: Friday, January 18, 2002 12:15 PM To: DB2-L@RYCI.COM Subject: Re: Re.COBOL question





Uxorious, I am not.

-----Original Message----- From: db person [ mailto:db2_person@YAHOO.COM ] Sent: Thursday, January 17, 2002 6:34 PM To: DB2-L@RYCI.COM Subject: Re.COBOL question [...] 27735 30 21_Re: Re.COBOL question13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 18 Jan 2002 14:46:15 -0500442_- While we're providing definitions, Here's why some may not like the term Geek:

From: http://www.m-w.com/cgi-bin/dictionary?geek

Main Entry: geek Pronunciation: 'gEk Function: noun Etymology: probably from English dialect geek, geck fool, from Low German geck, from Middle Low German Date: 1914 1 : a carnival performer often billed as a wild man whose act usually includes biting the head off a live chicken or snake ... [...] 27766 25 19_SQL Advise Facility10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Fri, 18 Jan 2002 13:58:39 -0600437_iso-8859-1 I have run across references to SQL Advise Facility that is part of UDB. Supposedly it is accessible thru the Control Center by clicking with mouse button two on the indexes folder and choosing the Create>Index using Wizard option. But my Create>Index doesn't have a wizard option. I am using UDB V6 on NT. Has anyone used this SQL Advise Facility? Anyone got any ideas as too how to get the wizard option on the Create? [...] 27792 22 23_wierd DB2 query problem18_Terry Higginbotham28_THigginbotham@GROCERYBIZ.COM31_Fri, 18 Jan 2002 13:12:29 -0600559_- we are experiencing a wierd problem. we have a query doing sum(case..) logic against 20 million rows. when we run this query against the 20 million row table (scoping to one monthly period) in one subsytem the results are wrong, when we execute it against another sybsystem with the same data as the scoped but with less overall rows it works. In the erroneos case a 000 sql code is returned. the problems points to the volume of these two tables being different. but since I don't get any sqlcode error it is very interesting. also if I further scope [...] 27815 46 27_Re: wierd DB2 query problem12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 18 Jan 2002 14:35:24 -0600709_- This is strictly a guess, but could you have an "overflow" condition on the sum(...)? I don't know if DB2 indicates an SQL error in this case.

---------------------------------------------------------------------- John McKown Applications and Solutions Team Healthaxis





> -----Original Message----- > From: Terry Higginbotham [SMTP:THigginbotham@GROCERYBIZ.COM] > Sent: Friday, January 18, 2002 1:12 PM > To: DB2-L@RYCI.COM > Subject: wierd DB2 query problem > > we are experiencing a wierd problem. we have a query doing sum(case..) > logic against 20 million rows. when we run this query against the 20 > million row table (scoping to one monthly period) in one subsytem [...] 27862 71 20_Re: tablename change3_db218_db2_user@YAHOO.COM31_Fri, 18 Jan 2002 14:45:25 -0600340_iso-8859-1 I do not want to rename any tables nor do I want to change any programs. Currently my program is pointing to QUALIFIERX.TABLEA. How do I point to QUALIFIERX.TABLEB for a temporary batch process.

As per James kwan , one way is to change the highlevel qualifier in the program. But I do not want to change the program. [...] 27934 54 27_Re: wierd DB2 query problem16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Fri, 18 Jan 2002 13:53:52 -0700486_us-ascii Terry,

By chance is the query being run against a partitioned tablespace AND, is the subsystem which the wrong results are being produced, parallelism enabled?

Regards, Jeff L'Italien American Express





From: "Terry Higginbotham" @RYCI.COM> on 01/18/2002 01:12 PM CST

Please respond to "DB2 Data Base Discussion List"

Sent by: "DB2 Data Base Discussion List" [...] 27989 54 27_Re: wierd DB2 query problem0_26_truman.g.brown@VERIZON.COM31_Fri, 18 Jan 2002 15:58:41 -0500415_us-ascii I assume it's partitioned in both instances; is it possible that your qualifying statement excludes rows in one instance but not in another, e.g., index structures do not vary and data is the same? DB2 version/level the same and no unapplied PTF's on either subsystem? No division involved where the divide DSNZPARM is different (DECDIV3 YES in one and NO in the other)? How large is the discrepancy? [...] 28044 36 17_Create table auth11_David Nance16_DWNance@FHSC.COM31_Fri, 18 Jan 2002 16:01:16 -0500635_US-ASCII Okay, here's a poser for everyone.

Environment OS/390 DB2 V6 using secondary authids

I created a tablespace(DSNDB04.SPACE1) for use by public, they have createtab, load, repair, start, display & stop db. This is for our developers to be able to create their own tables for whatever reason. This works fine and they can create tables to their hearts content, except when they try to use "CREATE TABLE Y LIKE XXX.TABLEB IN DSNDB04.SPACE1" They have select, insert, update, delete on TABLEB through their secondary authid. When they use the like tableb they get a -551 saying they lack neccessary authority on [...] 28081 56 27_Re: wierd DB2 query problem14_Michael Kaplan25_micaelkp@NETVISION.NET.IL31_Fri, 18 Jan 2002 23:09:02 +0100598_windows-1255 Terry,

My feeling is that DB2 is O.K. and you should look for the problem in vendor's area.

It may be a matter of different customization figures taken place in vendor product against your different subsystems. Probably, number overflows.

Michael Kaplan DBA E-mail : micaelkp@netvision.net.il Mobile phone : 058-525276







-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Terry Higginbotham Sent: Friday, January 18, 2002 8:12 PM To: DB2-L@RYCI.COM Subject: wierd DB2 query problem [...] 28138 59 21_Re: Re.COBOL question23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 18 Jan 2002 16:06:11 -0500407_iso-8859-1 I read few articles on Colorado School Shooting a while back. From there, I was under the impression that in USA, Geek is person who is very good at academics in school and hence hated by ones who are obviously not good at it. I believe they are called Jocks (less brain more brawn). So I couldn't understand why someone didn't like being called a GEEK. Its beats being a Jock, doesn't it ? [...] 28198 113 20_Re: tablename change10_Mark Doyle19_mdoyle@JCPENNEY.COM31_Fri, 18 Jan 2002 15:26:09 -0600372_iso-8859-1 If you don't have an explicit owner qualifier in the SQL, you can rebind with a different owner / qualifier parameter. If you do, I think you're out of luck :o(

Mark ----- Original Message ----- From: "db2" Newsgroups: bit.listserv.db2-l To: Sent: Friday, January 18, 2002 2:45 PM Subject: Re: tablename change [...] 28312 23 12_FILE MANAGER14_Database Admin21_db2udbxpert@YAHOO.COM31_Fri, 18 Jan 2002 13:33:50 -0800526_us-ascii Hi,

Can anybody provide method for creating a dataset in FILE-MANAGER using model option ???

Thanks in advance Desi

__________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 28336 50 21_Re: Re.COBOL question12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 18 Jan 2002 15:37:16 -0600451_- Sanjay, I think whether "geek" is considered "bad" varies, depending on the location of the reader. I know that in another list, I used the word "twit" to describe somebody who I thought was talking foolishly. I got jumped on big time by some people not in the US. Here in Texas, that is a rather mild term describing somebody who is thoughtless. Apparently it is much stronger in other parts of the world (indicating a moron IQ or some such). [...] 28387 85 21_Re: Re.COBOL question15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Fri, 18 Jan 2002 15:37:37 -0600343_iso-8859-1 Geek was a derogatory term at first. Many geeks have embraced it now. I think that geeks can call each other geeks and it is OK. If a jock called a geek by that term he/she usually means it as an insult.

Linda Billings Project Manager/Enterprise Systems Programmer State of Wisconsin Department of Electronic Government [...] 28473 81 38_Re: Re.COBOL question -- way off topic14_Allen, Susan A24_susan.a.allen@BOEING.COM31_Fri, 18 Jan 2002 13:43:05 -0800404_iso-8859-1 using the terms Geeks and Jocks It implies that an academic over achiever can not also be athletically gifted. The term you are looking for is Nerd.

enough with the off topic







-----Original Message----- From: Jain, Sanjay (Exchange) [mailto:sanjayjain@BEAR.COM] Sent: Friday, January 18, 2002 1:06 PM To: DB2-L@RYCI.COM Subject: Re: Re.COBOL question [...] 28555 62 21_Re: Create table auth13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Fri, 18 Jan 2002 13:44:54 -0800361_iso-8859-1 It is working 'as designed'. While creating a table

1. the 'current sqlid' should have 'applicable table privilege'. 2. When issuing 'Create table T1 like T2', the 'applicable table privilege' required is a SELECT on table T2.

So, combining the two, the 'current sqlid' should have a SELECT on table T2. That is what is happening. [...] 28618 98 21_Re: Re.COBOL question15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Fri, 18 Jan 2002 15:52:11 -0600371_iso-8859-1 I forgot to mention that jocks are athletes and are not necessarily stupid although many of them don't apply themselves to academics hence the reputation for not being very smart.

Linda

-----Original Message----- From: Billings, Linda Sent: Friday, January 18, 2002 3:38 PM To: 'DB2 Data Base Discussion List' Subject: RE: Re.COBOL question [...] 28717 35 34_YASQ - Yet Another Stupid Question12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 18 Jan 2002 16:07:23 -0600515_- Is there any reason to prefer one of the following SELECT statements over the other?

SELECT col1, col2, ... FROM table1, table2 WHERE table1.col1 = table2.col1 ;

versus

SELECT col1, col2, ... table1 INNER JOIN table2 ON table1.col1 = table2.col1 ;

They should produce the same output, correct? My personal preference is for the second. But that's only because I sometimes want OUTER JOIN, LEFT JOIN, or RIGHT JOIN and remembering one syntax is easier for my poor, limited memory. [...] 28753 158 21_Re: Re.COBOL question13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Fri, 18 Jan 2002 14:23:41 -0800585_iso-8859-1 Hi Sanjay. It sounds like, according to your research, the word "geek" should lose its pejorative connotation once one leaves high school and enters realms where intelligence is considered more valuable than physical prowess. And judging by the way people use the word, it would seem that many share that point of view. I was recently at a group lunch where a lawyer mentioned "geek stuff," meaning something of a technical nature. I would guess that people who use the word in this way were never actually accused of being one when they were young. And when I hear it [...] 28912 20 22_Unload from Flash Copy11_Bruce James20_bruce.james@UCOP.EDU31_Fri, 18 Jan 2002 14:51:31 -0800496_us-ascii Dear List,

Does anybody know how to run a DSNTIAUL unload from an ESS "Flash Copy"? We'd like to be able to "Flash Copy" our DB2 tables and then continue updating them while we unload (back up) the frozen copy.

Thanks,

bruce

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 28933 85 20_Re: tablename change10_James Kwan19_JamesDB2Kwan@CS.COM29_Fri, 18 Jan 2002 18:18:23 EST413_US-ASCII The answer is no. Table/View/Alias owner must be unique. You might have to drop and recreate table with different name as suggested by other people.

I would prefer to change the program since it is a BAD practice to hard code the qualifier in the program. How do you test your programs in different environments (eg TEST, QA etc)? You must have different subsystem for each test environment. [...] 29019 41 27_Re: DB2 v 7 UNION IN A VIEW14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 18 Jan 2002 17:37:53 -0600555_- There has been talk of being able to a partition - after the current last partition. That is, all existing partitions stay in place. As Walter pointed out, it seems that it is not available yet.

You can, however, (in V7) alter the limit keys for one, or more, partitions. After you do the ALTER (INDEX), you run a REORG on the TS for all partitions from the the first partition so altered to the one after (IIRC) the last partition altered. With REORG DISCARD this enables you to discard the contents of the old first partition and move the [...] 29061 99 21_Re: Re.COBOL question14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 19 Jan 2002 22:18:18 +1000521_US-ASCII I think the problem with both "geek" (and "jock") is that they carry an implication that the person concerned is interested in only academic (or, for jocks, sporting) matters - and has no other social skills, interests or friends.

It is the implication of having only one interest in life that is disliked. Geeks know it is not true, so might not mind other geeks calling them "geeks" - because they know that the other person is not trying to make the implication. With a non-geek they do not know. [...] 29161 41 26_Re: Unload from Flash Copy10_Andrew Pan19_andrew.pan@WAMU.NET31_Fri, 18 Jan 2002 16:42:42 -0800436_us-ascii From what I can see, there are a couple of problems. One is that the backup copy is offline and unavailable to DB2. So DSNTIAUL won't be able to read from the tables. Flashopy backups may also contain uncommitted data because of the way they are created. Next, flashopy backups are volume level backups, not DB2 image copies. According to the documentation, V7 unload utility requires genuine DB2 image copies to operate. [...] 29203 18 21_Re: Re.COBOL question26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Fri, 18 Jan 2002 19:26:39 -0600390_- Just to make it worse, an observer once watched Einstein float about in the lake in his little sailing craft, lost the tiller, got hit by the beam, never put the center board down. "Not much of sailor Cap'n?" To which Einstein replied, "no but I did invent serveral transform geometries while drifting around." Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...] 29222 23 42_DSN1COPY dataset problem. Need assistance!13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Fri, 18 Jan 2002 20:52:59 -0500 29246 15 46_Re: DSN1COPY dataset problem. Need assistance!26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Fri, 18 Jan 2002 21:20:10 -0600378_- Have to stop the database OADASSC then start it w/ ACCESS(UT). Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 29262 29 54_How does DB2/UDB handle underscore ch. in data string?10_Umesh Apte19_apteumesh@YAHOO.COM31_Fri, 18 Jan 2002 19:43:33 -0800448_us-ascii Hi all,

I am on DB2/UDB version 7.2

Delete product where product_key like 'ABC_%'

deletes rows with both 'ABC' and 'ABC_SUB' values. Is it an issue with LIKE predicate or db2 treats '_' character as 'any or none'.

Please let me know.

Thanks in advance.

__________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ [...] 29292 179 46_Re: DSN1COPY dataset problem. Need assistance!14_Danny S. Creed19_dcreed@CABLEONE.NET31_Fri, 18 Jan 2002 21:26:29 -0600405_iso-8859-1 DSN1COPY runs outside of DB2's control. You have DISP=OLD which is correct but you must first stop the database spacenam to free it up from the DBM1 address space

-STOP DATABASE(OADASSC) SPACENAM(BG3SO2E1)



From: Carlton Enuda Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Friday, January 18, 2002 7:52 PM Subject: DSN1COPY dataset problem. Need assistance! [...] 29472 16 43_John Campbell1/UK/IBM is out of the office.14_John Campbell119_CAMPBELJ@UK.IBM.COM31_Sat, 19 Jan 2002 08:03:01 +0000458_us-ascii I will be out of the office starting January 19, 2002 and will not return until February 4, 2002.

I will be away in the USA for WB 21st Jan and in Germany for WB 28th Jan. I will be checking my email.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 29489 74 46_Re: DSN1COPY dataset problem. Need assistance!14_Glen Sanderson26_glen.sanderson@SAFEWAY.COM31_Sat, 19 Jan 2002 06:49:02 -0600 29564 50 58_Re: How does DB2/UDB handle underscore ch. in data string?14_Glen Sanderson26_glen.sanderson@SAFEWAY.COM31_Sat, 19 Jan 2002 06:51:52 -0600299_us-ascii The '_' character is the same as the % character except that is only holds one character placement where '%' can hold one or more character placements. So ABC_% and ABC% are equivalent.

However A_C can be ABC, AZC, ADC etc. and A%C can be ABC, AZC, A the whole alphabet C, etc. [...] 29615 39 46_Re: DSN1COPY dataset problem. Need assistance!14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 20 Jan 2002 11:48:35 +1000434_US-ASCII No, just stop it. DSN1COPY does its thing outside DB2 control - so does not need nor use DB2.

The reason it would, however, probably work it that the stop will close the cluster, making it accesible to DSN1COPY. However the start does not actually open the cluster - merely makes it eligible to be opened. Since nothing, running under DB2 control, wants it opened, it will stay closed as far as DB2 is concerned. [...] 29655 67 58_Re: How does DB2/UDB handle underscore ch. in data string?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 20 Jan 2002 11:48:36 +1000332_US-ASCII _ matches exactly one character; % matches _zero_ or more characters.

I doubt if DB2 would delete a row with 'ABC' because there isn't a character after the C. 'ABC ' does, however have a character after the C. If you want to change this - to not delete 'ABC ' - try: where product key like 'ABC~_%' escape '~' [...] 29723 53 21_Re: Re.COBOL question13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Sat, 19 Jan 2002 07:49:03 -0800612_us-ascii Ed,

Queston: What was the boom doing while Einstein was being hit by the beam?

Tink

PS. So sorry, tried to resit but couldn't.



--- "Edward(Ed) J. Finnell, III" wrote: > Just to make it worse, an observer once watched > Einstein float about in the lake > in his little sailing craft, lost the tiller, got > hit by the beam, never put the center > board down. "Not much of sailor Cap'n?" To which > Einstein replied, "no but I did > invent serveral transform geometries while drifting > around." > Edward(Ed) J. Finnell, III > Enterprise [...] 29777 69 38_Re: YASQ - Yet Another Stupid Question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sat, 19 Jan 2002 10:47:13 -0600491_iso-8859-1 John,

The reason you give is one reason prefer the second example also. My other reasons include:

- Is more descriptive. Important when you have a large SQL statement including many tables and NTEs (a small comma is harder to find). - Requires that the join predicates (ON clause) follow each join. Again more descriptive, and means that you are less likely to forget a join predicate, causing a cartesian product. - Cleaner syntax, and easier to read etc etc. [...] 29847 13 38_Re: Client to OS390 Connection Problem17_Fernando Manching17_Kiwibisoy@AOL.COM29_Sat, 19 Jan 2002 13:36:17 EST275_US-ASCII Yes, the binds ran fine.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 29861 49 51_Re: Identify the user list when database is running19_Alekos Papadopoulos13_apapad@NBG.GR31_Sat, 19 Jan 2002 20:39:57 +0200673_iso-8859-7 Try -DIS DATABASE(dbname) SPACENAM(tsname) CLAIMERS

Alekos Papadopoulos M.Sc. System DB Administrator National Bank of Greece





-----Áñ÷éêü ìÞíõìá----- Áðü: Subha [mailto:subha_sivaji@YAHOO.COM] ÁðïóôïëÞ: ÐáñáóêåõÞ, 18 Éáíïõáñßïõ 2002 5:30 ìì Ðñïò: DB2-L@RYCI.COM ÈÝìá: Identify the user list when database is running



Hi List users,

I am having a problem of some one calling me and asking me What happend to the Data , Whenever I take the TS offline for offline utilities to run . Can anyone help me How can I identify the users currenly using the related TS , so that I can ask them to wait till I am done [...] 29911 94 38_Re: YASQ - Yet Another Stupid Question11_Suresh Sane21_data_arch@HOTMAIL.COM31_Sat, 19 Jan 2002 15:22:20 -0600426_- In addition to what Terry has pointed out, I like the INNER JOIN syntax instead of the FROM syntax because it is easy to isolate the "structure predicates" (assuming an equi-join, all real or implied FK relationships) which end up in the ON clause and the "local predicates" which end up in the WHERE. The first are determined by the logical design (ask the DA), the second by the application (ask the Project leader). [...] 30006 16 21_Re: Re.COBOL question26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Sat, 19 Jan 2002 23:22:34 -0600461_- Long ago and far away, I used to have a hobie cat, but then that was California. I also worked for a container company, but never went on a ship. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 30023 86 57_Re: DSN1COPY dataset problem. Need assistance! - pass two13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Sun, 20 Jan 2002 00:16:47 -0500 30110 50 43_PREDICATE TRANSITIVE CLOSURE WITH NTE DOUBT12_sushant dash23_dash_dba@REDIFFMAIL.COM31_Sun, 20 Jan 2002 09:06:21 -0000650_iso-8859-1 Good Day all, I m posting a doubt to be clarified as I could not sense from explain information. I m writing the query and the doubts in the order.

Query- SELECT cust.OID AS OID ,cust.IDTYPE AS IDTYPE ,cust.IDVALUE AS IDVALUE ,pbln.IDVALUE AS PRIMBUSLICNUM ,cust.NAME AS NAME

FROM ( SELECT iip1.OID AS OID ,iid1.IDTYPE AS IDTYPE ,iid1.IDVALUE AS IDVALUE ,inp1.VALUE AS NAME FROM TBIVP28 iip1 ,TBIVP29 iname1 ,TBIVP32 inp1 ,TBIVP21 iid1 WHERE iip1.IPTYPEOID = 2 AND iip1.CUSTOMERSTATUS = 2 AND iip1.OID = iname1.IPOID AND iname1.PRIMARYNAME = 1 AND iname1.OID = inp1.NAMEOID AND inp1.TYPE = 4 AND iip1.OID = iid1.IPOID ) [...] 30161 47 17_ARCHIVE LOG error16_Sharon Zitterman24_Sharon.Zitterman@TRW.COM31_Sun, 20 Jan 2002 06:23:23 -0500410_US-ASCII Dear Listers,

We encountered a problem last month that has not occurred since, but, we have not be able to pinpoint a DB2 related reason.

During our nightly production processing, a batch job issues the -ARCHIVE LOG command to the master console which causes DB2P to archive. The batch job finished with code zero but, bottom of the batch job JCL that failed showed the following - [...] 30209 67 51_Re: Identify the user list when database is running12_Subha Sivaji22_subha_sivaji@YAHOO.COM31_Sun, 20 Jan 2002 06:18:43 -0800624_us-ascii Right on button . Helped me .

With regards, Subha Sivaji.





--- Alekos Papadopoulos wrote: > Try -DIS DATABASE(dbname) SPACENAM(tsname) CLAIMERS > > Alekos Papadopoulos M.Sc. > System DB Administrator > National Bank of Greece > > > > -----Áñ÷éêü ìÞíõìá----- > Áðü: Subha [mailto:subha_sivaji@YAHOO.COM] > ÁðïóôïëÞ: ÐáñáóêåõÞ, 18 Éáíïõáñßïõ 2002 5:30 ìì > Ðñïò: DB2-L@RYCI.COM > ÈÝìá: Identify the user list when database is > running > > > Hi List users, > > I am having a problem of some one calling me and > asking me What happend to > the Data , Whenever I take [...] 30277 32 16_DB2 DBA question9_Mark Reed16_markreed@ONE.NET31_Sun, 20 Jan 2002 10:54:19 -0500459_us-ascii International conglomerate is adding a new DB2 DBA permanent position to its Washington D.C., San Francisco, and L.A. area offices. If you have been laid off or know a DBA that has, these are new open positions.

Responsibilities include all aspects of Database Administration in an OS/390 environment. Considerable opportunities for training and exposure to DB2 UDB, Oracle, and open systems. Participate in numerous e-business projects. [...] 30310 31 32_Memory Leaks - current situation12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 20 Jan 2002 18:58:47 +0200426_windows-1255 Hi all of the interested parties:

The lottery results are:

OW51149 - UW82890 OW50040 - UW81488

APAR: II04309

Sorry - I'm down with the flu :-( Don't read this mail too close :-)

BTW - I found out that SWA was "below" and not "above" ...

Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net [...] 30342 175 46_Re: DSN1COPY dataset problem. Need assistance!14_Danny S. Creed19_dcreed@CABLEONE.NET31_Sun, 20 Jan 2002 13:16:21 -0600375_iso-8859-1 hmmm..resending hit some line limit

I would try (not a guru)

Go back to your original attempt with the database/tablespace stopped. It is not unusual for security to neglect (on purpose) the ability to allocate/write to db2 datasets outside of db2's control.

In order to know what to modify, you need to know what violation you received. [...] 30518 72 21_Re: ARCHIVE LOG error9_fard fard15_bhdb2@YAHOO.COM31_Sun, 20 Jan 2002 11:45:19 -0800572_us-ascii Hi dear

maybe it was about an indoubt task in your system , check it and try to correct it , and otherwise atlast , run DSNJU003 with backout optin

F.Fard --- Sharon Zitterman wrote: > Dear Listers, > > We encountered a problem last month that has not > occurred since, but, we have not be able to pinpoint > a DB2 related reason. > > During our nightly production processing, a batch > job issues the -ARCHIVE LOG command to the master > console which causes DB2P to archive. The batch job > finished with code zero [...] 30591 110 17_Re: Datalinks Mgr13_Abi Monoharan23_abi@PROTEOMESYSTEMS.COM31_Mon, 21 Jan 2002 09:29:13 +1100517_us-ascii Hi Tim, The /test directory got all permissions. ( chmod 777 /test ) and I am running as root to run the command.

Abi

On Saturday 19 January 2002 01:09, you wrote: > Looks to me like the userid you are using doesn't have > write permissions for file system /test. > Tim > > --- Abi Manoahran wrote: > > Hi, > > I am currently setting up a Datalinks server. It is > > in AIX 5.1 with DB2 7.2 > > EEE and Dalinks server 7.2 on same server. > > > > I have installed [...] 30702 16 52_Re: How to cancel thread initiated from Web browser?9_Linda Dba21_linda_dba@HOTMAIL.COM31_Sun, 20 Jan 2002 17:37:40 -0600397_- You can also set the ZPARM IDTHTOIN to an appropriate value to cause idle threads to be automatically cancelled after a set time.

HTH

Linda

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 30719 23 38_Re: YASQ - Yet Another Stupid Question9_Linda Dba21_linda_dba@HOTMAIL.COM31_Sun, 20 Jan 2002 18:16:07 -0600373_- I wonder if there is a problem in the optimizers choice for this case:

An SQL was coded with an INNER join and also a equal(=) predicate on the ON clause using a host variable. The WHERE clause also had an equal(=) predicate on the same table. Even though there was a composite index on both columns, the optimizer would not pick up the col in the ON clause. [...] 30743 64 67_Re: Antwort: IBM equivalent of Princeton Softech's Compare for DB 212_Raymond Bell17_rbell@NZ1.IBM.COM31_Mon, 21 Jan 2002 16:31:25 +1300568_us-ascii Hi Alan (and Rick),

No correction coming from me. I don't know a great deal about this tool (no, really?) but thought I'd use the 3.13 analogy as, like you say, it's kinda like what it does albeit in a far smarter way. I really wanted to differentiate between comparing DDL and comparing data, but I guess anyone suggesting an IBM equivalent must, by definition, know what the tool does. I hope I'm reading your comments correctly and I haven't caused offence. I know my comments on vendor tools have in the past come back to bite me, even though [...] 30808 121 47_Re: PREDICATE TRANSITIVE CLOSURE WITH NTE DOUBT22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 21 Jan 2002 09:59:27 +0530352_iso-8859-1 Dash,

Predicate transitive closure will be applied while joining the materialized result of pbln and cust. The columns for the NTE is ready to be used only when the materialization is done. After materializing pbln only, DB2 is ready with pbln.IPOID. Similarly for the cust. Do you have any specific problems with performance ?? [...] 30930 16 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Mon, 21 Jan 2002 01:02:25 -0600425_us-ascii I will be out of the office starting 01/18/2002 and will not return until 01/22/2002.

In my absence, for data management assistance, please contact Dona Bell at x2822.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 30947 13 40_Bob Treski/Spiegel is out of the office.10_Bob Treski19_Bob_Treski@SPGL.COM31_Mon, 21 Jan 2002 01:26:12 -0600336_us-ascii I will be out of the office starting 01/18/2002 and will not return until 01/22/2002.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 30961 77 38_Re: YASQ - Yet Another Stupid Question0_18_mebert@AMADEUS.NET31_Mon, 21 Jan 2002 09:34:28 +0100355_us-ascii No problem. Expecting the Optimiser to pick this up unaided is a bit too much, especially as the query coding is rather misleading. Write your query like this:

...T1 INNER JOIN T2 ON T1.C1 = T2.C1 WHERE T1.C2 = :HV1 AND T1.C3 = :HV2

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 31039 55 27_Re: wierd DB2 query problem9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Mon, 21 Jan 2002 09:20:55 -0000662_iso-8859-1 It could be parallelism. If this is a program compiled with a degree greater than 1 or ANY, try rebinding with a degree of 1.

Jim.

-----Original Message----- From: Terry Higginbotham [mailto:THigginbotham@GROCERYBIZ.COM] Sent: 18 January 2002 19:12 To: DB2-L@RYCI.COM Subject: wierd DB2 query problem



we are experiencing a wierd problem. we have a query doing sum(case..) logic against 20 million rows. when we run this query against the 20 million row table (scoping to one monthly period) in one subsytem the results are wrong, when we execute it against another sybsystem with the same data as the scoped but with [...] 31095 96 64_Antwort: Re: Re.COBOL question (yes of course it's off-topic :-)25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE31_Mon, 21 Jan 2002 10:29:19 +0100449_iso-8859-1 Canadians knew it before, see Robertson Davies...

Ciao!

Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.

Office: +49 (0) 89 54554 189 Mobile: +49 (0) 171 674 6930 +44 (0) 7881 818 867 Fax: +49 (0) 89 54554 119 email: aurora_dellanno@candle.com

1 Archipelago Lyon Way Frimley Camberley Surrey GU16 7ER UK



* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER [...] 31192 47 21_Re: Re.COBOL question10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 21 Jan 2002 12:07:39 +0100418_us-ascii Hi estimeed listers

I was tring to understand the thread about Geek , but I really really didn't understand if:

1) Geek is a new type of Star Join, the fact table is 'GEEK' and 'JOCK', 'ATHLETIC','NERDS' are other tables in a GEEK schema.

2) It's a new type SQL statement : SELECT * from useless_table where SUM_GEEKS(column)='Einstein' to evaluate the Q.I of a person via DB2 V 69. [...] 31240 37 19_db2 AIX Error 2048N14_Curran, John F29_john.f.curran@UK.FID-INTL.COM31_Mon, 21 Jan 2002 11:28:24 -0000337_iso-8859-1 Hi

Has anybody ever had this error on DB2 7.1 ON AIX

The error message reads

SQL2048N An error occurred while accessing object "SQL PROCEDURE FILES". Reason code: "7".

If so I would be very grateful if you know how I can solve it.

The error occurs when I try to connect to the database [...] 31278 76 33_Clusterratio and Clustering Index13_Michael Fleck14_m.fleck@LVR.DE31_Mon, 21 Jan 2002 14:02:35 +0100496_ISO-8859-1 Hi list members,

I'm running the following SQL against a DB2-subsystem:

SELECT CREATOR , TBNAME , CLUSTERING , CLUSTERED , CLUSTERRATIO FROM SYSIBM.SYSINDEXES WHERE CLUSTERING = 'Y' AND CLUSTERED = 'N' ORDER BY CREATOR, TBNAME;

In the output list there are several clusterratio values '0' . What does this value mean? In some other cases the clusterratio is '100' , the index is defined as clustering index but the index isn't clustered. What does this mean? [...] 31355 13 37_Re: Clusterratio and Clustering Index10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 21 Jan 2002 14:44:16 +0100347_us-ascii Did you try to execute RUNSTATS on indexes with clusterratio='0' ? 0 means no runstats executed.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 31369 145 42_Antwort: Clusterratio and Clustering Index25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE31_Mon, 21 Jan 2002 14:50:20 +0100479_iso-8859-1 Michael,

The meaning of CLUSTERRATIO, for the index partition, is the percentage of rows that are in clustering order. The value is 0 if statistics have not been gathered, therefore a RUNSTATS is your answer there.

HTH.

Ciao!

Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.

Office: +49 (0) 89 54554 189 Mobile: +49 (0) 171 674 6930 +44 (0) 7881 818 867 Fax: +49 (0) 89 54554 119 email: aurora_dellanno@candle.com [...] 31515 135 37_Re: Clusterratio and Clustering Index27_ROBINSON, Warwick, MANU ITI28_Warwick.Robinson@NATWEST.COM31_Mon, 21 Jan 2002 14:09:15 -0000346_iso-8859-1 Michael, A zero value for clusterratio means stats haven't been gathered for this object because RUNSTATS has not been run since the index was created. Mind you, the column is updateable in SYSINDEXES. So, however unlikely, I guess it could have been set to zero manually. I don't think the column is updateable in SYSINDEXSTATS. [...] 31651 105 21_Re: Re.COBOL question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 21 Jan 2002 09:37:43 -0500586_iso-8859-1 I am a DB2 Geek. I am an assembler Geek. If anyone calls me a Cobol Geek, I will be greviously insulted.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Billings, Linda [mailto:Linda.Billings@DEG.STATE.WI.US] Sent: Friday, January 18, 2002 4:38 PM To: DB2-L@RYCI.COM Subject: Re: Re.COBOL question



Geek was a derogatory term at first. Many geeks have embraced it now. I think that geeks can call each other geeks and it is OK. If a jock called a geek by that term he/she usually means it as an insult. [...] 31757 15 38_Re: YASQ - Yet Another Stupid Question7_Linda S21_linda_dba@HOTMAIL.COM31_Mon, 21 Jan 2002 08:43:10 -0600457_- That would have been the best thing to do but unfortunately the SQL comes out of a software package and there is no way to manually change it to put the ON predicate in the WHERE clause. Any thoughts?

Linda

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 31773 62 37_Re: Clusterratio and Clustering Index7_DB2 DBA21_db2_dba@BELLSOUTH.NET31_Mon, 21 Jan 2002 10:13:05 -0500570_ISO-8859-1 In your select list you may want to look at the column CLUSTERRATIOF. > > From: Michael Fleck > Date: 2002/01/21 Mon AM 08:02:35 EST > To: DB2-L@RYCI.COM > Subject: Clusterratio and Clustering Index > > Hi list members, > > I'm running the following SQL against a DB2-subsystem: > > SELECT > CREATOR , > TBNAME , > CLUSTERING , > CLUSTERED , > CLUSTERRATIO > FROM SYSIBM.SYSINDEXES > WHERE CLUSTERING = 'Y' AND CLUSTERED = 'N' > ORDER BY CREATOR, TBNAME; > > In the output list there are several clusterratio values '0' . What does this [...] 31836 28 33_FW: [Fwd: Richard Yevich is gone]15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Mon, 21 Jan 2002 11:19:39 -0600426_iso-8859-1 All I can say is I will miss him. My thoughts and prayers go out to those in his organization.

Chris Blaicher





-------- Original Message -------- Subject: Richard Yevich is gone Date: Sun, 20 Jan 2002 20:05:31 -0500 From: Joel Goldstein

He went back into the hospital yesterday, lapsed into a coma, and passed away tonight in Springfield, IL [...] 31865 59 36_Re: DPROP Subscription Script Create15_Neff, Stephen R16_NeffSR@STATE.GOV31_Mon, 21 Jan 2002 12:36:23 -0500346_iso-8859-1 Hello, I use the tool DJRA to create subscriptions, etc. It is free and downloadable. I have created subscriptions etc.. without having APPLY or Capture running. The only requirement when generating the scripts is to be able to connect and have the appropriate control tables on the server, the target, and the control databases. [...] 31925 88 46_Re: Antwort: Clusterratio and Clustering Index10_James Kwan19_JamesDB2Kwan@CS.COM29_Mon, 21 Jan 2002 12:45:59 EST615_US-ASCII Shouldn't CLUSTERRATIO be -1 if it is not collected?

James Kwan

Certified DB2 Expert



In a message dated 1/21/02 8:09:14 AM Central Standard Time, Aurora.DellAnno@SSKM.DE writes:



> Michael, > > The meaning of CLUSTERRATIO, for the index partition, is the percentage of > rows that are in clustering order. The value is 0 if statistics have not > been gathered, therefore a RUNSTATS is your answer there. > > HTH. > > Ciao! > > Aurora Emanuela Dell'Anno > Systems Engineer > Candle Service Ltd. > > Office: +49 (0) 89 54554 189 > Mobile: +49 (0) 171 674 6930 [...] 32014 51 37_Re: FW: [Fwd: Richard Yevich is gone]17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Mon, 21 Jan 2002 11:58:06 -0600489_us-ascii Wow, I did not even know he was sick!





From: "Blaicher, Chris" @RYCI.COM on 01/21/2002 11:19 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: FW: [Fwd: Richard Yevich is gone]



All I can say is I will miss him. My thoughts and prayers go out to those in his organization. [...] 32066 58 36_DB2 Connect 7.2 for Linux and DB/40013_Eneko Lacunza30_elacunza@MATRIXCONSULTORES.COM31_Mon, 21 Jan 2002 19:16:44 +0100430_ISO-8859-15 Hello all,

I'm trying to connect a Linux box to an AS/400 database, with DB2 Connect 7.2 Personal Edition. After some work, I've managed to connect to the database and make authentication work, but I'm having a bad trouble now:

- After (during?) authentication, I get an SQL30020N error, Reason code 1254 - SQL STATE 58009 . My connection is refused with a clean message if I supply bad login/pass. [...] 32125 75 37_Re: FW: [Fwd: Richard Yevich is gone]10_Raghu Kota21_raghukota@HOTMAIL.COM31_Mon, 21 Jan 2002 18:50:09 +0000654_- Is it true?? Iam shocked!!



>From: Jeremy Schleicher >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: FW: [Fwd: Richard Yevich is gone] >Date: Mon, 21 Jan 2002 11:58:06 -0600 > >Wow, I did not even know he was sick! > > > >From: "Blaicher, Chris" @RYCI.COM on 01/21/2002 > 11:19 AM > >Please respond to DB2 Data Base Discussion List > >Sent by: DB2 Data Base Discussion List > > >To: DB2-L@RYCI.COM >cc: > >Subject: FW: [Fwd: Richard Yevich is gone] > > >All I can say is I will miss him. My thoughts [...] 32201 89 37_Re: FW: [Fwd: Richard Yevich is gone]14_Manish Kothari23_mkothari@DATAMIRROR.COM31_Mon, 21 Jan 2002 14:13:57 -0500757_iso-8859-1 Speechless...

-----Original Message----- From: Raghu Kota [mailto:raghukota@HOTMAIL.COM] Sent: Monday, January 21, 2002 1:50 PM To: DB2-L@RYCI.COM Subject: Re: FW: [Fwd: Richard Yevich is gone]



Is it true?? Iam shocked!!



>From: Jeremy Schleicher >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: FW: [Fwd: Richard Yevich is gone] >Date: Mon, 21 Jan 2002 11:58:06 -0600 > >Wow, I did not even know he was sick! > > > >From: "Blaicher, Chris" @RYCI.COM on 01/21/2002 > 11:19 AM > >Please respond to DB2 Data Base Discussion List > >Sent by: DB2 Data Base Discussion List > > [...] 32291 93 36_Richard Yevich Funeral Arrangements?16_Brookman, Gerald30_gerald.brookman@ATOSORIGIN.COM31_Mon, 21 Jan 2002 14:30:56 -0500606_iso-8859-1 Any official word on Richard Yevich memorial services, funeral arrangements, address to send floral tributes, or e-mail address to send condolences?

I last met Richard in Saint Louis in April, 2001 to attend three (3) days of classes in a hotel meeting room with NO air conditioning. Anyone else would have given up. His enormous detailed knowledge of DB2 and fun style of training made the environmental conditions bearable. I can state with candor that he probably "forgot" more about DB2 than most of us will ever know. I will, for one, miss him explaining the details of all the [...] 32385 85 37_Re: FW: [Fwd: Richard Yevich is gone]13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Mon, 21 Jan 2002 13:31:39 -060083_us-ascii Sadly and unfortunately it is very true. Are prayers are with him.

32471 15 37_Re: FW: [Fwd: Richard Yevich is gone]0_26_truman.g.brown@VERIZON.COM31_Mon, 21 Jan 2002 14:47:29 -0500442_us-ascii "Golden lads and lassies must, as chimney-sweeps, retrun to dust."

RIP, Richard, somewhere where there are no outages, applications are correctly designed, and SQL is properly coded...

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 32487 89 45_Re: [Fwd: Richard Yevich is gone] - Confirmed13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 21 Jan 2002 14:05:18 -0600345_iso-8859-1 DB2 Listserver,

I can confirm that Richard Yevich passed away last night after a brief fight with cancer.

Although the outlook was not promising, it was a shock to us all that he passed so quickly.

He did slip into a coma whilst asleep in his home in Springfield, IL; and passed away soon after in hospital. [...] 32577 22 6_sqlfix17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Mon, 21 Jan 2002 14:08:52 -0600695_us-ascii To the person that was having problems with the command center last week and the statement terminator

|-----+-------------------------------------------------------------------| | JR16| SQL0010N. TERMINATION CHARACTER IS NOT RECOGNIZED IN THE | | 443 | INTERACTIVE TAB IN THE COMMAND CENTER | |-----+-------------------------------------------------------------------|





Is the apar and is available now in fixpack 5

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 32600 26 35_Re: How to see the data in an Index12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 21 Jan 2002 13:50:05 -0600423_- If you want to find out which indexes are available on a table, the DB2 Administration Guide includes a chapter (Chapter 2-10 in V6) on Using the catalog in database design. Here is a paste:

Retrieving catalog information about indexes

To display information about all the indexes of a table, enter a statement like this one: SELECT FROM SYSIBM.SYSINDEXES WHERE TBNAME ='EMP' AND TBCREATOR ='DSN861 '; [...] 32627 157 37_Re: Clusterratio and Clustering Index12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 22 Jan 2002 09:21:42 +1300500_iso-8859-1 Michael,

As others have said, clusterratio of 0 usually means you don't have runstats for the object. Or (agreed, it's unlikely) someone's updated the value. Or maybe the table is empty - not sure what clusterratio you'd get in this case but 0 is just as good as 100. Or you may have a stats-gathering utility that doesn't correctly update the clustered column. Not sure how important the column is these days, actually, but running Runstats will probably make things clearer. [...] 32785 23 50_Shark DASD and table partitioning and/or piecesize19_Michael Robaczewski25_mrobaczewski@CAREMARK.COM31_Mon, 21 Jan 2002 14:03:57 -0600494_- We are looking at moving to Shark DASD storage devices for our DB2 tables and indexes. At the same time we are also considering the partitioning of several large tablespaces with the possible use of 'piecesize' on their non- partitioned indexes as a way to improve performance. There has been a point of discussion raised concerning if partitioning and/or piecesizeing is necessary or useful after a conversion to Shark DASD. Can anyone share their any thoughts or advice on this topic. [...] 32809 121 45_Re: [Fwd: Richard Yevich is gone] - Confirmed16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Mon, 21 Jan 2002 13:38:57 -0700432_us-ascii Terry,

I, along with other members of the computing community am deeply saddened by this loss. As I have only known Richard through his books, and conference sessions, I'm sure that it must be especially difficult for someone like yourself to lose a colleague and friend. My sincere thoughts and prayers go out to Richard's family, and the members of his organization such as yourself in this time of mourning. [...] 32931 67 40_Re: Richard Yevich Funeral Arrangements?17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Mon, 21 Jan 2002 14:39:58 -0600276_iso-8859-1 I too was at that class, it was by far the hottest day of the month that year(I am a from St Louis). It was so hot that at lunch I went a bought a pair of shorts.

I have emailed YLAssoc and asked for any information, but so far have not heard anything. [...] 32999 77 48_Los Angeles Area DB2 User Group February Meeting15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM31_Mon, 21 Jan 2002 13:42:44 -0800308_us-ascii Our February meeting will be held on Thursday February 7th at the Sheraton Cerritos Hotel at 12725 Center Court Drive South. The registration starts at 8:30 AM.

The Sheraton is located at the Shoemaker exit of the 91 Freeway. If you are going East, this is one exit before Knott Avenue. [...] 33077 37 37_Re: FW: [Fwd: Richard Yevich is gone]14_Andy Lankester33_andy.lankester@FR.CDBSOFTWARE.COM31_Mon, 21 Jan 2002 22:45:19 -0000709_us-ascii Goodbye Richard. Go well. Remember forever the bar in Copenhagen.

Andy

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] > On Behalf Of truman.g.brown@VERIZON.COM > Sent: 21 January 2002 19:47 > To: DB2-L@RYCI.COM > Subject: Re: FW: [Fwd: Richard Yevich is gone] > > > "Golden lads and lassies must, as chimney-sweeps, retrun to dust." > > RIP, Richard, somewhere where there are no outages, > applications are correctly designed, and SQL is properly coded... > > ================================================ > To change your subscription options or to cancel your > subscription visit the DB2-L webpage at > http://www.ryci.com/db2-l. [...] 33115 113 46_Re: Antwort: Clusterratio and Clustering Index13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Tue, 22 Jan 2002 09:57:02 +1100496_iso-8859-1 No, it's an odd one. No stats...Clusterratiio=0;

Steve T

-----Original Message----- From: James Kwan [mailto:JamesDB2Kwan@CS.COM] Sent: Tuesday, 22 January 2002 4:46 AM To: DB2-L@RYCI.COM Subject: Re: Antwort: Clusterratio and Clustering Index



Shouldn't CLUSTERRATIO be -1 if it is not collected?

James Kwan

Certified DB2 Expert



In a message dated 1/21/02 8:09:14 AM Central Standard Time, Aurora.DellAnno@SSKM.DE writes: [...] 33229 21 39_FW: DB2 V7 Utilities IBM VS Third Party17_Necessary, Cheryl31_Cheryl.Necessary@INGRAMBOOK.COM31_Mon, 21 Jan 2002 17:49:18 -0600484_iso-8859-1 > We are ready to look at V7 utilities. I remember a while back there was some discussion as to whether or not third party > utilities used the IBM utilities under the covers. I have searched the Archives but I am still not sure. If I go with third > party utilities do I also have to have all or some of the IBM utilities? Any experiences out there you can share? Thanks in > advance for your help. > > Thanks, > Cheryl L. Necessary > MIS DBA > Ingram Book Company > [...] 33251 41 10_Re: sqlfix13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Tue, 22 Jan 2002 10:54:13 +1100450_iso-8859-1 Thanks Jeremy I've just installed FP5 and I can verify that this works (BTW it was the script tab not interactive).

Regards,

Steve t

-----Original Message----- From: Jeremy Schleicher [mailto:Jeremy_Schleicher@MAY-CO.COM] Sent: Tuesday, 22 January 2002 7:09 AM To: DB2-L@RYCI.COM Subject: sqlfix



To the person that was having problems with the command center last week and the statement terminator [...] 33293 119 21_Re: Re.COBOL question13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Tue, 22 Jan 2002 11:31:26 +1100387_iso-8859-1 Does anyone know the site for the certification guide to become a geek?

-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Tuesday, 22 January 2002 1:38 AM To: DB2-L@RYCI.COM Subject: Re: Re.COBOL question



I am a DB2 Geek. I am an assembler Geek. If anyone calls me a Cobol Geek, I will be greviously insulted. [...] 33413 156 21_Re: Re.COBOL question12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 22 Jan 2002 13:59:34 +1300554_us-ascii Have a crack at http://www-4.ibm.com/software/data/db2/skills/cert.html and go from there.



Raymond PS. I also de-head snakes, but I prefer chickens.







Steve Tennant cc: Sent by: DB2 Data Subject: Re: Re.COBOL question Base Discussion List



22/01/02 13:31 Please respond to DB2 Data Base Discussion List









Does anyone know the site for the certification guide to become a geek? [...] 33570 20 51_Re: Richard Yevich Funeral Arrangements? See inside14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Mon, 21 Jan 2002 21:11:27 -0500450_ISO-8859-1 I don't have the address stuff until late tonight or tomorrow morning.

The srevice will be Thyrsday Morning at 10AM in Richmond, VA.

Will send more later..



Joel Goldstein

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 33591 71 35_Re: How to see the data in an Index13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Tue, 22 Jan 2002 12:07:07 +1100445_iso-8859-1 And if you want to know what the data is that is being indexed....?

SELECT SK.* FROM SYSIBM.SYSINDEXES SI, SYSIBM.SYSKEYS SK WHERE SI.TBNAME = 'XXX' AND SI.NAME = SK.IXNAME ORDER BY COLSEQ;

(os390)

Regards,

Steve T

-----Original Message----- From: Durga Vamsidhar [mailto:durga.vamsidhar@DB.COM] Sent: Friday, 18 January 2002 9:16 PM To: DB2-L@RYCI.COM Subject: How to see the data in an Index [...] 33663 25 54_Re: Shark DASD and table partitioning and/or piecesize12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 21 Jan 2002 19:59:50 -0600352_- It depends. It is likely that moving your data to the ESS with PAV and multiple allegiance will reduce the problems for IOSQ times by a big factor, often as much as ten times. For some situations that is a good solution, as long as you continue to monitor the IO response times. It is still possible to overload fast disks with fast processors. [...] 33689 15 36_Re: Memory Leaks - current situation12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 21 Jan 2002 20:21:11 -0600502_- Another major change in DB2 memory that we're working on is PQ55346. The APAR is just closed, so this is likely to be another two or three weeks. The intent of the change is better handling of the critical storage shortages.

Roger Miller, DB2 for z/OS

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 33705 42 30_Delete records using BMC Reorg6_Bala P17_baladb2@YAHOO.COM31_Mon, 21 Jan 2002 19:26:09 -0800381_us-ascii Hi,

I have a table with one of the column defined as DATE data type. The retention period of each record should be one year. I wanted to delete the records whose date is more than one year. My client uses BMC REORG. There is an option in the BMC REORG to mention the SQL in DELETE YES option in REORG. I have used the following SQL in my REORG, but it failed. [...] 33748 25 8_BMC Tool16_Chintala S Kumar19_chintala@IN.IBM.COM31_Tue, 22 Jan 2002 09:28:55 +0530789_us-ascii Hi List, Can you please let me know any information about the BMC Tool?



Thanks & Best Regards, Surendar ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

IBM Global Services India Pvt Ltd, "The Presidency", #1, St. Mark's Road Bangalore - INDIA - 560 001 Phone: 91-80-2244056 Ext: 372 91-80-5252602 (Res) Mail id: chintala@in.ibm.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 33774 77 34_Re: Delete records using BMC Reorg14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Tue, 22 Jan 2002 15:05:25 +1100639_iso-8859-1 Hi,

We don't have BMC reorg, but what about something like:

select * from EC723 where strt_dt > current DATE - 1 YEAR

Regards, Greg Palgrave Database Administrator Unisys West

The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). This information may be subject to legal professional or other privilege or may otherwise be protected by work product immunity or other legal rules. It must not be disclosed to any person without our consent. If you are not the intended recipient, or a person responsible for [...] 33852 73 37_Re: FW: [Fwd: Richard Yevich is gone]0_24_ujjwal@LOT.TATASTEEL.COM31_Tue, 22 Jan 2002 09:47:44 +0530502_us-ascii I am shocked to hear this but I still do not want to believe it.I was attending his seminar in Bangalore two months ago and we all had a very good four sessions with him and probably he and Susan was the first to bring DB2 to India.A person of his calibre who has won seven times IDUG Best Speaker Award will be a great loss to the DB2 World.Last month Susan told me that he is sick but I never thought it would be like this. I am really at a loss of words.My thoughts and prayers go out [...] 33926 104 37_Re: FW: [Fwd: Richard Yevich is gone]20_Mohan, Bezawada (B.)16_bmohan2@FORD.COM31_Mon, 21 Jan 2002 23:34:23 -0500499_iso-8859-1 It is shocking ? it's a great loss to the community...





Mohan Bezawada

-----Original Message----- From: Manish Kothari [mailto:mkothari@DATAMIRROR.COM] Sent: 22 January 2002 00:44 To: DB2-L@RYCI.COM Subject: Re: FW: [Fwd: Richard Yevich is gone]

Speechless...

-----Original Message----- From: Raghu Kota [mailto:raghukota@HOTMAIL.COM] Sent: Monday, January 21, 2002 1:50 PM To: DB2-L@RYCI.COM Subject: Re: FW: [Fwd: Richard Yevich is gone] [...] 34031 34 39_Preparedstatements bind parameters type11_arvind_heda40_arvind_heda@INTERSOLUTIONS.STPN.SOFT.NET31_Tue, 22 Jan 2002 10:22:14 +0530414_iso-8859-1 Hi list members,

While using preparedstatements repeatedly with different parameters, I have observed a strange behaviour with different version of db2 client. can somebaody suggest any explanation for this behaviour.

with 7.1 client:: The prepared stmt is fired repeatedly , each time with new bindings of parameters. But clear parameters was not called explicitly . It worked fine. [...] 34066 15 33_John Ordman is out of the office.0_29_John_Ordman@READERSDIGEST.COM31_Tue, 22 Jan 2002 01:01:47 -0500389_us-ascii I will be out of the office starting 01/21/2002 and will not return until 01/28/2002.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.