1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2002, week 1 2 16 49_Robert Seay/MCIG/USA/Zurich is out of the office.11_Robert Seay24_robert.seay@ZURICHNA.COM30_Fri, 1 Feb 2002 03:09:58 -0500479_us-ascii I will be out of the office from 02/01/2002 until 02/05/2002.

I will respond to your message when I return. If your message requires a response before I return, please forward it to Vincent Miller or John Gray. Thank you!

================================================ 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. 19 73 45_Re: Diagnostic data directory path in UDB EEE12_John Nayberg13_jna@DMDATA.DK30_Fri, 1 Feb 2002 09:31:49 +0100587_us-ascii Hello Mark.



You allmost said it yourself.

On physical node 1: /db2logs/db2dump On physical node 2: /db2logs/db2dump ... On physical node 6: /db2logs/db2dump

i.e. local filesystems with the same name on every physical node.

And DIAGPATH=/db2log/db2dump



Med venlig hilsen / Kind regards

John Nayberg jna@dmdata.dk DMdata a/s







"Baskerville, Mark {PBSG}" @RYCI.COM> on 31-01-2002 22:32:55

Please respond to DB2 Data Base Discussion List [...] 93 176 17_Antwort: Re: WLM?25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE30_Fri, 1 Feb 2002 09:50:30 +0100364_iso-8859-1 Or, there is a way of avoiding Stored Procedures.

If you're at least on IMS V6 (and you should be since V5 is out of support since the end of last year), AND you have IMS Connect as well, then you can access IMS directly.

Otherwise, as correctly pointed out by Pius, you must use stored procedures and therefore WLM will be involved. [...] 270 97 12_Re: DSN1COMP11_Mike Turner29_Michael_Turner@COMPUSERVE.COM30_Fri, 1 Feb 2002 04:30:00 -0500389_ISO-8859-1 For a partitioned tablespace you need to specify the parameter NUMPARTS(n) where n is the number of partitions. For a non-4K page size tablespace you need to specify PAGESIZE(nK). so if your tablespace is in a 16K page size partitioned tablespace with 32 partitions, you must specify:

//STEP1 EXEC PGM=DSN1COMP,PARM='PAGESIZE(16K),NUMPARTS(32),any other parameters' [...] 368 105 30_Antwort: Re: Antwort: Re: WLM?25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE30_Fri, 1 Feb 2002 11:08:10 +0100437_iso-8859-1 Dougie,

thanks for your input.

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 [...] 474 21 24_Re: BMC catalog manager.14_Clayton, Colin21_Colin_Clayton@BMC.COM30_Fri, 1 Feb 2002 04:17:59 -0600328_iso-8859-1 Hi Sibi,

I think you should check which version you are running. You say it is 6.2.01, but the plan you refer to is 6.1.02.

Type 'ENVI' from the command line (within Catalog Manager) and you will see what version you are running, along with the plan names that you will need execute privileges on. [...] 496 40 17_Re: SET INTEGRITY11_Hamar, Bela22_Bela.Hamar@VARETIS.COM30_Fri, 1 Feb 2002 12:53:48 +0100365_us-ascii Hi Stephen,

we do the following:

1. get the list of all the tables being in check pending state 2. if the list is empty: goto 5 3. SET INTEGRITY for all tables in the list 4. go to 1 5. ready

In Step 3 we receive error messages for the child tables where the parent table is in check pending state too, but we simply ignore them. [...] 537 129 30_Re: Antwort: EDM pool shortage14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Fri, 1 Feb 2002 13:33:12 -0000350_iso-8859-1 Daniel,

Aurora is absolutely right (and in my opinion is also up there with the "real gurus"). Our 3rd party software application came with 7000 or so packages bound DEGREE(ANY). We rebound them DEGREE(1) and our EDM pool halved in usage. Performance improved, too, as our sadly missed colleague Richard Yevich also intimated. [...] 667 39 15_Re: DB2 V5 & V716_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Fri, 1 Feb 2002 08:43:09 -0500412_iso-8859-1 Yes. We have one LPAR where one subsys was V5, one was V7 for a few weeks.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Toppins, Smike [mailto:smike.toppins@GWL.COM] Sent: Thursday, January 31, 2002 3:52 PM To: DB2-L@RYCI.COM Subject: DB2 V5 & V7



Can a DB2 V5 subsystem co-exist with a V7 subsystem as it is being installed? [...] 707 112 21_Re: bufferpool paging12_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM30_Fri, 1 Feb 2002 09:04:22 -0500785_us-ascii Thank you very much for your valuable comments.







Joel Goldstein on 01/31/2002 06:21:57 PM



Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc: (bcc: Amit Agarwal/FIS)





Subject: Re: bufferpool paging











Pls see coments under statements preceeded by +++++ Regards, Joel

Message text written by DB2 Data Base Discussion List >1> As I understand from you and Joel , paging will not be zero at any shop because the first time the page is brought in the bufferpool counts as one page-in I/o. This leads me to believe that unless I see a value in rate/sec, there [...] 820 49 38_How do you say.....Off topic - thanks.10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 1 Feb 2002 15:29:15 +0100574_us-ascii Hi estimeed listers

Thank you very much for your replies. I apprecietd them, really ! I prefere 'scaling effect' because it explains, in my opinion, what I'm trying to describe.

When I was at the university I learned that every model of a big 'structure' (for instance of a dam and his basin), even if extremly accurate in (small) scale and with the same materials, couldn't describe the behaviour of a real dam simply because the real dam is bigger and this fact is not only a trivial 'effect multiplier' , ie if any measurement is X in a model [...] 870 44 21_UDB stored procedures0_24_db46@DAIMLERCHRYSLER.COM30_Fri, 1 Feb 2002 10:03:19 -0500340_us-ascii We are presently starting to use UDB stored procedures and our DBA is new to this area. I am able to use the DB2 client to compile stored procedures, but cannot run them and get a -10013 error code.

We can bring up and view the SP's, but when I click SQL Stored Procedures Build Options, this happens (same error code) [...] 915 30 43_Re: What is Release 613 for DB2 for OS/390?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Fri, 1 Feb 2002 09:12:00 -0500292_- I asked the same ? to IBM, this is what they said: DB2 R613 has also been referred to as DB2 LE. It's basically DB2 R610 with JDB6613 (Base LE) installed.

>>> DB2 Data Base Discussion List 01/31/02 03:40PM >>> Reviewing an APAR on IBMLink, the following PTF List was displayed: [...] 946 105 20_Re: Buffer Pool Tool14_Laredo, Andrew19_Andy_Laredo@BMC.COM30_Fri, 1 Feb 2002 09:28:52 -0600453_iso-8859-1 This is better than Dallas and Knots Landing reruns. We should thank IBM for "getting" into the tools business.

Andy

-----Original Message----- From: Raymond Bell [mailto:rbell@NZ1.IBM.COM] Sent: Thursday, January 31, 2002 19:05 To: DB2-L@RYCI.COM Subject: Re: Buffer Pool Tool



Hey Joel,

The beating of bushes is not required. I appreciate your straight answers and commentary, as I'm sure others do. [...] 1052 63 25_Re: UDB stored procedures18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Fri, 1 Feb 2002 10:30:17 -0500621_- I think you included screen shots but they don't come through on this list.

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



-----Original Message----- From: db46@DAIMLERCHRYSLER.COM [mailto:db46@DAIMLERCHRYSLER.COM] Sent: Friday, February 01, 2002 10:03 AM To: DB2-L@RYCI.COM Subject: UDB stored procedures



We are presently starting to use UDB stored procedures and our DBA is new to this area. I am able to use the DB2 client to compile stored procedures, but cannot run them and get a -10013 error code. [...] 1116 73 30_Re: DB2 Monitor Switches (AIX)23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Fri, 1 Feb 2002 15:37:30 -0000626_iso-8859-1 John

we have them on aswell.

regards

Les

-----Original Message----- From: Curran, John F [mailto:john.f.curran@UK.FID-INTL.COM] Sent: Wednesday, January 30, 2002 10:55 AM To: DB2-L@RYCI.COM Subject: DB2 Monitor Switches (AIX)



Hi

I have been reading an article in the DB2 Magazine written by Scott Hayes with regard to monitor switches.

In the article he says it is a good ideas to switch all monitor switches on, my thoughts is would this cause a performance overhead and if so how much. In my Mainframe you had to be cautious with turning on monitors. [...] 1190 65 9_Re: DSMAX14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Fri, 1 Feb 2002 11:03:57 -0500665_iso-8859-1 Steve:

This is what we get from TMON :

+----------------------- DATASET/DRAIN STATISTICS -----------------------+ , ,DATASETS OPENED :, 4462, ,MIGRATED DATASET ENCOUNTERD:, 0, ,DATASETS CURRENTLY OPEN :, 4069, ,DATASET RECALL TIMEOUTS :, 0, ,MAXIMUM DATASETS OPEN :, 4069, ,PAGESET OPEN DELAYS :, 0, ,ZPARM MAXIMUM DATASETS OPEN :, 6000, ,PAGESET OPEN FAILURES :, 0, ,CONVERTED TO READ ONLY STATE :, 3119, ,DATASET DRAIN REQUESTS :, 0, ,DATASETS OPEN BUT NOT IN USE :, 3873, ,DATASET DRAINS SUCCESSFUL :, 0, ,PAGESETS OPEN BUT NOT IN USE :, 0, ,DATASET DRAINS UNSUCCESSFUL:, 0, ,MAX DATASETS OPEN, NOT IN USE :, 3901, ,DATASETS CLOSED [...] 1256 20 27_V 7.1 Utility Load question14_Edward P. Long19_RDHM99A@PRODIGY.NET30_Fri, 1 Feb 2002 11:06:26 -0500504_- I am working with the OS/390 V7.1 utilities, specifically the new IBM Unload and load. Unload is fine, although a little pricey on the cpu consumption. Listdef and Templates work ok. Load doesn't support LISTDEF; I need to reload 300+ tables. I don't have RC/Migrator so my choices look grim; code by hand or generate myself. Also, the templates generated by Unload specify OLD,CATLG,CATLG for the input dataset. I don't want to override all of them but will have to. Any suggestions or comments. [...] 1277 80 14_working tables10_Grace Chen22_gchen@CUCENTRAL-AB.COM30_Fri, 1 Feb 2002 09:09:02 -0700444_iso-8859-1 Hi List, We have an application need two sets of working tables which are loaded from VSAM files everyday and need keep data in tables for couple of days. A COBOL program is doing the loading. We don't want DB2 to do the logging and don't want DB2 to put these tables in pending copy status after loading. Is it any way we can tell DB2 to stop logging fro these tables and don't put these tables in copy pending status? Thanks! [...] 1358 47 24_Re: BMC catalog manager.15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Fri, 1 Feb 2002 11:19:24 -0500530_iso-8859-1 Thanks, the plans are

ACT621DM ACT621DL ACT621DU ACT621DK ACT621DH ACT621DE

I have access on this. Again I have sysadm access on this subsystem.

Thanks...sibi



-----Original Message----- From: Clayton, Colin [mailto:Colin_Clayton@BMC.COM] Sent: Friday, February 01, 2002 04:18 AM To: DB2-L@RYCI.COM Subject: Re: BMC catalog manager.



Hi Sibi,

I think you should check which version you are running. You say it is 6.2.01, but the plan you refer to is 6.1.02. [...] 1406 51 18_IDENTITY_VAL_LOCAL19_Feargal FitzPatrick31_Feargal.Fitzpatrick@BOIMAIL.COM30_Fri, 1 Feb 2002 16:34:32 +0000525_us-ascii DB2 v6 for OS/390. We have a table with the Primary Key column defined as INTEGER GENERATED BY DEFAULT AS IDENTITY.

INSERT statements are run against the table, using DB2 Connect v7, to add new rows letting DB2 assign the Primary Key value.

We have a requirement to retrieve the value assigned directly after the INSERT statement has completed. The approach we're trying to progress is : INSERT INTO TABLE (column2, column3 .. columnN) VALUES (value2, value3, valueN); VALUES IDENTITY_VAL_LOCAL() [...] 1458 28 24_Re: BMC Catalog manager.14_Clayton, Colin21_Colin_Clayton@BMC.COM30_Fri, 1 Feb 2002 10:43:58 -0600581_iso-8859-1 Hi Balaji,

I'm not sure you mean 'BMC Platinum'. Platinum is now CA and BMC is still BMC, or did I miss the merger announcement ?

Which one do you have ?

On your second point, I can't speak for CA/Platinum, but I would assume that they also do not build index DDL 'automatically'. The reason is that there is no automatic way for any tool to determine what an index should look like. There are decisions about key columns, ordering of columns, sequence of key columns, uniqueness, freespace, size and placement that no tool is going to be able [...] 1487 99 30_Re: DB2 Monitor Switches (AIX)16_Fennell, Michael23_Michael.Fennell@FMR.COM30_Fri, 1 Feb 2002 11:44:35 -0500490_iso-8859-1 Folks,

The monitoring switches do not add that much overhead. I agree that they should be left on especially in production environments. If you find that the overhead is too expensive for all switches, you can set only the ones of interest (ie locks, etc..).

-----Original Message----- From: Pendlebury-Bowe, Leslie [mailto:Leslie.Pendlebury-Bowe@EU.SONY.COM] Sent: Friday, February 01, 2002 10:38 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Monitor Switches (AIX) [...] 1587 56 31_Re: V 7.1 Utility Load question12_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM30_Fri, 1 Feb 2002 11:48:24 -0500804_us-ascii Interesting. We have similar jobs here and currently we use RC/Migrator. I thought IBM has a replacement for RC/migrator in V7.

All opinions are my own...







"Edward P. Long" on 02/01/2002 11:06:26 AM



Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc: (bcc: Amit Agarwal/FIS)





Subject: V 7.1 Utility Load question











I am working with the OS/390 V7.1 utilities, specifically the new IBM Unload and load. Unload is fine, although a little pricey on the cpu consumption. Listdef and Templates work ok. Load doesn't support LISTDEF; I need to reload 300+ tables. I don't have RC/Migrator [...] 1644 17 22_DB2 Version in a LPAR.8_Harish G24_hari_gangadhar@YAHOO.COM30_Fri, 1 Feb 2002 10:50:11 -0600435_- Esteemed List,

Is there a way to find out the DB2 version available in a particular LPAR. Are there any REXX or CLIST based methods available.

Thanks and Regards,

Harish.

================================================ 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. 1662 21 26_DB2 Connect Authentication12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Fri, 1 Feb 2002 10:50:00 -0500438_- We are evaluating DB2 Connect... We have: DB2 Connect PE 7.2 FP4 on windows CLIENT. DB2 Connect EE 7.2 FP3 on UNIX Accessing data on OS/390

What entry do I need on the CLIENT if the EE gateway on the UNIX server has AUTHENTICATION=DCS? Will AUTHENTICATION=SERVER work? CCA will not create an entry with DCS. Attempting to create security with HOST or AS/400 auth. will not produce an AUTHENTICATION entry in the DB catalog. [...] 1684 78 31_Re: V 7.1 Utility Load question14_Edward P. Long19_RDHM99A@PRODIGY.NET30_Fri, 1 Feb 2002 12:10:57 -0500293_- The DBA tool appears to not have a 'strategy' concept like PDA at least for jcl generation purposes. The only other feature I have found is this LISTDEF/TEMPLATE deal. I also discovered that the IBM Unload cannot unload a blob or blob base table. So much for being ahead of BMC and CA. [...] 1763 81 22_Re: IDENTITY_VAL_LOCAL0_19_Tim.Lowe@STPAUL.COM30_Fri, 1 Feb 2002 11:13:00 -0600588_us-ascii After the insert is successfully done, have you tried a select statement like this: SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1;







Feargal FitzPatrick cc: Sent by: DB2 Data Base Subject: IDENTITY_VAL_LOCAL Discussion List



02/01/2002 10:34 AM Please respond to DB2 Data Base Discussion List











DB2 v6 for OS/390. We have a table with the Primary Key column defined as INTEGER GENERATED BY DEFAULT AS IDENTITY. [...] 1845 47 18_Re: working tables15_Andersen, Cindy18_candersen@FNNI.COM30_Fri, 1 Feb 2002 11:13:24 -0600578_us-ascii Yes. Use LOG NO NOCOPYPEND on the LOAD statement.

Cindy

> -----Original Message----- > From: Grace Chen [SMTP:gchen@CUCENTRAL-AB.COM] > Sent: Friday, February 01, 2002 10:09 AM > To: DB2-L@RYCI.COM > Subject: working tables > > Hi List, > We have an application need two sets of working tables which are loaded > from VSAM files everyday and need keep data in tables for couple of days. > A COBOL program is doing the loading. We don't want DB2 to do the logging > and don't want DB2 to put these tables in pending copy status after > loading. Is it [...] 1893 21 89_Is there are any methodology to find out which packages are actually executed by a plan ?13_Brendan Friel28_Brendan_Friel@NOTES.NTRS.COM30_Fri, 1 Feb 2002 11:19:29 -0600535_us-ascii Is there are any methodology to find out which packages are actually executed by a plan ? I have access to Platinum, BMC, FileAid for DB2 and IBM utilities.

We want to move our binds from wildcard to specifically referencing only the packages that are used.

TIA, Brendan

================================================ 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. 1915 26 51_Bruce C Crosby/GL/KSC/KeyCorp is out of the office.12_Bruce Crosby26_Bruce_C_Crosby@KEYBANK.COM30_Fri, 1 Feb 2002 12:21:16 -0500697_us-ascii I will be out of the office from 02/01/2002 until 02/11/2002.

I will respond to your message when I return. If you need a response sooner contact Jim Szabo or Bob Vargo ================================================== This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain [...] 1942 81 18_Script Line Length23_Muruganandam Sambasivam33_muruganandam.sambasivam@WIPRO.COM30_Fri, 1 Feb 2002 22:46:18 +0530455_US-ASCII Hi All,

I'm working in DB2 UDB7.2 on windows 2000 platform.

I have two problems while creating Tables and Loading Data thru Script Center.

1. Whatever script file i run, the system expects script, to be in a single line, rather a structured one. 2. And also it is not taking more than 1024 bytes in a single line. But my requirement goes beyond 1024 bytes for a single line. Because i've more columns in a single table. [...] 2024 28 32_DEAD LOCK Problem - Help Listers12_Subha Sivaji22_subha_sivaji@YAHOO.COM30_Fri, 1 Feb 2002 11:11:15 -0600298_- Hi Listers,

I have a deadlock situation ( OS/390) when two programs reads a table indexed on KEY ( Composite ). I have identified the program causing the dead lock using MSTR log .

Now I also have identified , both programs are using Index scan which is the way it has to be . [...] 2053 33 18_Re: working tables13_Patric Becker25_Patric_Becker@SIS-WEST.DE30_Fri, 1 Feb 2002 11:18:20 -0600322_ISO-8859-1 Hello Grace !

If you´re running DB2 Version 7 for DB2 for OS/390 and z/OS, there might be a solution : LOAD RESUME YES LOG NO NOCOPYPEND. But if you want to use this solution, you´ve to change your COBOL application from INSERT INTO TABLE to WRITE dataset, which can then be used as input for load. [...] 2087 44 26_Re: DB2 Version in a LPAR.0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 1 Feb 2002 11:38:05 -0600608_us-ascii issue a Display Group (-dis group) DB2 command to get following display

DSN7100I ) DSN7GCMD *** BEGIN DISPLAY OF GROUP(........) GROUP LEVEL(...) GROUP ATTACH NAME(....) -------------------------------------------------------------------- DB2 DB2 SYSTEM IRLM MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- --- -------- ---- -------- ........ 0 DB2 ) ACTIVE 510 SYs RLMa DB2iRLM -------------------------------------------------------------------- *** END DISPLAY OF GROUP(........) DSN9022I ) DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION *** [...] 2132 137 94_Re: Is there are any methodology to find out which packages are a ctually executed by a plan ?16_Bednarz, Michael22_Michael.Bednarz@CA.COM30_Fri, 1 Feb 2002 17:46:03 -0000513_iso-8859-1 I guess DETECTOR from CA(PLATINUM) could do this.



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: Brendan Friel [mailto:Brendan_Friel@NOTES.NTRS.COM] Sent: Freitag, 1. Februar 2002 18:19 To: DB2-L@RYCI.COM Subject: Is there are any methodology to find out which packages are actually executed by a plan ? [...] 2270 98 45_Re: Diagnostic data directory path in UDB EEE24_Baskerville, Mark {PBSG}26_mark.baskerville@PEPSI.COM30_Fri, 1 Feb 2002 12:50:37 -0500361_iso-8859-1 Thanks John. We will probably go this route. My concern was how these would perform in a fail over (High Availability) scenario. Apparently, DB2 will write to the file on the server acting as the fail over machine, so we would see the nodes from the host machine, as well as the failed node for the time during which the system has failed over. [...] 2369 33 12_DB2 Versions18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM30_Fri, 1 Feb 2002 13:00:54 -0500446_iso-8859-1 Does anyone have the link that I can look up to see when: (or if you know these dates).

1) DB2 Version 5 for OS/390 goes off of support.

2) DB2 Version 6 for OS/390 goes off support (I know this might not be out there yet).

3) DB2 Version 7, when did this go GA & generally how long after a GA does the prior release become unsupported?? (I thought I heard at one time it was something like 18 to 22 months). [...] 2403 28 21_UDB Stored Procedures0_24_db46@DAIMLERCHRYSLER.COM30_Fri, 1 Feb 2002 13:03:09 -0500660_us-ascii How can I find the configuration parameters for our UDB database?

Dean









****************************************************************************

The information contained in this transmission, which may be confidential and proprietary, is only for the intended recipients. Unauthorized use is strictly prohibited. If you receive this transmission in error, please notify me immediately by telephone or electronic mail and confirm that you deleted this transmission and the reply from your electronic mail system. **************************************************************************** [...] 2432 169 16_Re: DB2 Versions21_Powers, Carol A - CNF20_Powers.Carol@CNF.COM30_Fri, 1 Feb 2002 10:28:50 -0800595_- This information is on IBMLink which is available on the web at http://www.ibmlink.ibm.com Choose 'Sales Manual' and put in the product number (5655-DB2 V5, 5645-DB2 V6, 5675-DB2 V7) and it will display what they call the 'Product Lifecycle' which contains all the dates you want to know. DB2 V5 end of support date is listed there as 12/31/2002. There is no end of service date listed for DB2 V6, which means that it hasn't been announced yet. DB2 V7 was generally available on 3/30/2001. There will be an announcement letter (also available on IBMLink) published when end of support is [...] 2602 62 36_Re: DEAD LOCK Problem - Help Listers16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM30_Fri, 1 Feb 2002 11:39:12 -0700367_us-ascii Subha,

I guess I'm confused about the scenario you described and the locking problems. If you have two read only applications accessing the same object, why are they deadlocking in the first place? Are there updates being done by either of these two applications which might explain the deadlocks?

Regards, Jeff L'Italien American Express [...] 2665 53 26_Re: DB2 Version in a LPAR.11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Fri, 1 Feb 2002 12:18:24 -0600367_us-ascii /-SSID DIS LOCATION(*) DETAIL

This will give you the level of all subsystems connected to an LPAR! You could then go to the different LPAR and tell there level... : )







Harish G cc: Sent by: DB2 Subject: DB2 Version in a LPAR. Data Base Discussion List [...] 2719 96 16_Re: DB2 Versions12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Fri, 1 Feb 2002 12:35:23 -0600358_iso-8859-1 The dates are as follows: V3: GA 12-1993 Marketing Withdrawal 2 2000 End of Service 3-2001 V4: GA 11-1995 Marketing Withdrawal 12-2001 End of Service 12-2001 V5: GA 6-1997 Marketing Withdrawal 12-2001 End of Service 12-2002 V6: GA 6-1999 Marketing Withdrawal 6 -2002 End of Service ? V7: GA March 2001 Marketing Withdrawal ? End of Service ? [...] 2816 71 36_Re: DEAD LOCK Problem - Help Listers0_20_John_Lendman@FPL.COM30_Fri, 1 Feb 2002 13:36:36 -0500468_us-ascii The thing that will help you the most is in taking commits as often as you can. And yes if you "rebuild" or change and index you must run runstats to pick up the new stats for the optimizer.

John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413





"Subha Sivaji" cc: Sent by: "DB2 Subject: DEAD LOCK Problem - Help Listers Data Base Discussion List" [...] 2888 49 36_Re: DEAD LOCK Problem - Help Listers16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Fri, 1 Feb 2002 13:43:35 -0500492_iso-8859-1 COMMIT is your best bet.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Subha Sivaji [mailto:subha_sivaji@YAHOO.COM] Sent: Friday, February 01, 2002 12:11 PM To: DB2-L@RYCI.COM Subject: DEAD LOCK Problem - Help Listers



Hi Listers,

I have a deadlock situation ( OS/390) when two programs reads a table indexed on KEY ( Composite ). I have identified the program causing the dead lock using MSTR log . [...] 2938 60 36_Re: DEAD LOCK Problem - Help Listers11_Todd Martin15_tm9us@YAHOO.COM30_Fri, 1 Feb 2002 10:46:10 -0800559_us-ascii Subha,

I dont understand one thing ,when your applications does ONLY reads then why you are getting deadlock .Can you give us some more details like what the application does ???

Todd

--- Subha Sivaji wrote: > Hi Listers, > > I have a deadlock situation ( OS/390) when two > programs reads a table > indexed on KEY ( Composite ). I have identified the > program causing the > dead lock using MSTR log . > > Now I also have identified , both programs are using > Index scan which is > the way it has [...] 2999 68 25_Re: UDB Stored Procedures11_Judy Kibler21_judith.kibler@TRW.COM30_Fri, 1 Feb 2002 13:00:03 -0600635_us-ascii Hi Dean,

You can execute:

db2 get db cfg for db - for the database configuration parms db2 get dbm cfg - for the database manager configuration parms

Hope that helps! Judy







db46@DAIMLERCHRYSLER.COM on 02/01/2002 12:03:09 PM

Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc: (bcc: Judy Kibler/Nashville)





Subject: UDB Stored Procedures















How can I find the configuration parameters for our UDB database? [...] 3068 91 18_Re: working tables0_21_BudGreenman@ONGOV.NET30_Fri, 1 Feb 2002 14:12:15 -0500668_iso-8859-1 you can do the samet hing with v6 - i have





Patric Becker cc: Sent by: DB2 Data Subject: Re: working tables Base Discussion List



02/01/2002 12:18 PM Please respond to DB2 Data Base Discussion List











Hello Grace !

If you´re running DB2 Version 7 for DB2 for OS/390 and z/OS, there might be a solution : LOAD RESUME YES LOG NO NOCOPYPEND. But if you want to use this solution, you´ve to change your COBOL application from INSERT INTO TABLE to WRITE dataset, which can then be used as input for load. [...] 3160 49 16_Re: DB2 Versions14_MIKE FRIEDRICH27_RDBA002@REVENUE.STATE.IL.US30_Fri, 1 Feb 2002 13:18:30 -0600455_US-ASCII Website for OS/390 Availability is:

http://www-4.ibm.com/software/data/db2/os390/availsum.html





>>> "Whittaker, Stephen" 02/01/02 12:00PM >>> Does anyone have the link that I can look up to see when: (or if you know these dates).

1) DB2 Version 5 for OS/390 goes off of support.

2) DB2 Version 6 for OS/390 goes off support (I know this might not be out there yet). [...] 3210 70 36_Re: DEAD LOCK Problem - Help Listers0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 1 Feb 2002 13:31:35 -0600358_us-ascii - What DB2 version and OS?

- are you talking about 2 batch programs, or 2 online transactions? (I'm guessing 2 batch programs.)

- How is that Tablespace LOCKSIZE define? If it is PAGE, that could be a problem if the two applications are trying to insert/update rows onto the same data page. (We had that problem a long time ago.) [...] 3281 105 18_Re: Bufferpooltool14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 1 Feb 2002 13:33:57 -0600409_iso-8859-1 With all due respect to Joel, there is another excellent alternative for DB2

pool tuning. BMC Software's Pool Advisor provides intelligent automation of DB2 pool management (buffer, EDM, sort). Pool Advisor can automatically make

pool changes based on resource utilization BUT by default it only makes recommendations - and these recommendation can be reviewed by the DBA before [...] 3387 66 36_Re: DEAD LOCK Problem - Help Listers11_David Nance16_DWNance@FHSC.COM30_Fri, 1 Feb 2002 14:36:26 -0500501_US-ASCII Subha, What is your isolation level and or your locksize? As someone already mentioned if both programs are reading the table you should not have a problem. We have some tables that are being read by more than a hundred programs at the same time, but we manage our locksize an isolation levels accordingly. I don't see how rebuilding the index will really be any help at all, unless its to give the applications more matching columns, which still doesn't help the deadlocking condition. [...] 3454 21 7_Pgsteal17_Vandreese, Tami S27_Tami.Vandreese@LANDSEND.COM30_Fri, 1 Feb 2002 13:26:13 -0600434_iso-8859-1 We are at DB2/OS390 V6. We have a decision support system that runs a number of queries against large tables using cpu parallelism. These queries are doing mostly sequential processing and constantly overwriting what is in the buffer so we get little reuse. Would there be any benefit in changing the the PGSTEAL parameter on the bufferpools for the partitioned tablespaces to use FIFO rather than the default of LRU? [...] 3476 96 22_Re: IDENTITY_VAL_LOCAL12_Gross, Chuck18_cgross@MILL-IS.COM30_Fri, 1 Feb 2002 14:40:44 -0500394_us-ascii Feargal,

I would like to verify my understanding of the problem. Does the following scenario accurately depict what you are trying to do:

1. you insert a record allowing DB2 to generate the primary key 2. no commit has been issued following the commit 3. you wish to select the uncommitted row that has just been inserted to determine the key value assigned by DB2. [...] 3573 76 18_Re: working tables0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 1 Feb 2002 13:46:57 -0600384_iso-8859-1 V6 OS390 LOAD also has NOCOPYPEND option. It also has an option to do IC at same time as LOAD.

In V5 or under, if you ***really*** don't want the logging and IC, do the LOAD LOG NO, TS will be copy pending, then issue -START ... ACCESS(FORCE) to clear the copy pending. Granted, ACCESS(FORCE) is not a good idea in production, but it is an option in this case. [...] 3650 52 16_Re: DB2 Versions11_Mark Ediger22_MEDIGER@TRANSUNION.COM30_Fri, 1 Feb 2002 14:12:06 -0600413_US-ASCII http://www-3.ibm.com/software/data/db2/os390/availsum.html

Mark Ediger Acxiom Corp.



>>> stephen.whittaker@PGNMAIL.COM 02/01/02 12:00PM >>> Does anyone have the link that I can look up to see when: (or if you know these dates).

1) DB2 Version 5 for OS/390 goes off of support.

2) DB2 Version 6 for OS/390 goes off support (I know this might not be out there yet). [...] 3703 24 3_SAP12_Toni LeTempt23_tletemp@OIR.STATE.SC.US30_Fri, 1 Feb 2002 15:13:07 -0500334_US-ASCII We are in the process of implementing a three tier SAP R/3 4.6c system using AIX for the application and DB2 OS390 v 6 for the database. We are just about to bring up development. This is my first exposure to SAP. I was wondering if anyone had any good reference materials to recommend. It would be greatly appreciated! [...] 3728 25 7_IPREFIX14_Vijay Pappadam26_vijaypappadam@NETSCAPE.NET30_Fri, 1 Feb 2002 15:16:33 -0500283_iso-8859-1 Hello,

Can somebody please explain to me what the purpose of this column is in DB2V7? I have read the manuals, and understand that it's either 'I' or 'J' and specifies the instance qualifier in the dataset name - but what's it really used for?

Thanks, Vijay. 3754 80 18_Re: working tables11_David Nance16_DWNance@FHSC.COM30_Fri, 1 Feb 2002 15:38:00 -0500567_US-ASCII The other way, only suggesting since these are defined as working tables, would be to run repair object and set it to nocopypend.

>>> Rohn.Solecki@MTS.MB.CA 02/01/02 02:46PM >>> V6 OS390 LOAD also has NOCOPYPEND option. It also has an option to do IC at same time as LOAD.

In V5 or under, if you ***really*** don't want the logging and IC, do the LOAD LOG NO, TS will be copy pending, then issue -START ... ACCESS(FORCE) to clear the copy pending. Granted, ACCESS(FORCE) is not a good idea in production, but it is an option in this case. [...] 3835 137 18_Re: Bufferpooltool12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Fri, 1 Feb 2002 14:49:06 -0600466_iso-8859-1 Craig:

I believe that Joel is referring to your feature that automatically adjusts the Buffer Pool sizes. If I am correct BMC does this through an alter command. Such a command would invalidate all the pages in the Buffer Pool and cause the pool to be rebuilt. Frequent use of the feature or just unfortunate timing, could result in a temporary disruption of service. I am not aware of an automatic feature in the Responsive System's product. [...] 3973 72 11_Re: IPREFIX0_19_Tim.Lowe@STPAUL.COM30_Fri, 1 Feb 2002 14:53:45 -0600494_us-ascii Vijay, It is for online reorg FASTSWITCH. (see the V7 Release Planning guide, page 12) Instead of renaming the datasets, online reorg can just change this column. (depending on a zparm) So, your datasets switch to/from: hlq.DSNDBC.dbname.name.I0001.A001 to/from: hlq.DSNDBC.dbname.name.J0001.A001

Thanks, Tim





Vijay Pappadam cc: Sent by: DB2 Data Subject: IPREFIX Base Discussion List [...] 4046 42 25_Re: UDB Stored Procedures16_Fennell, Michael23_Michael.Fennell@FMR.COM30_Fri, 1 Feb 2002 16:01:14 -0500873_- db2 get dbm cfg

-----Original Message----- From: db46@DAIMLERCHRYSLER.COM [mailto:db46@DAIMLERCHRYSLER.COM] Sent: Friday, February 01, 2002 1:03 PM To: DB2-L@RYCI.COM Subject: UDB Stored Procedures



How can I find the configuration parameters for our UDB database?

Dean









****************************************************************************

The information contained in this transmission, which may be confidential and proprietary, is only for the intended recipients. Unauthorized use is strictly prohibited. If you receive this transmission in error, please notify me immediately by telephone or electronic mail and confirm that you deleted this transmission and the reply from your electronic mail system. **************************************************************************** [...] 4089 205 18_Re: Bufferpooltool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 1 Feb 2002 16:56:32 -0500446_ISO-8859-1 Craig, Naturally, all vendors promote different opinions. I come from a systems tuning perspective, and have been tuning various types of systems for almost 4 decades, and DB2 systems for 16 years.

So, when we start tuning pools, after the really simple basics, without the ability to PREDICT, there is no way to determine whether making a pool bigger will really help unless your pool is rediculously small to start with. [...] 4295 23 49_Newbie question about DB2 OS/390 stored procedure18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM30_Fri, 1 Feb 2002 17:06:40 -0500545_iso-8859-1 I'm trying to execute my first stored procedure and receive a -471 with 00E79006. The DB2 SPAS has this message: DSNX962I DSNX9SER THE LE/370 CEEPIPI SERVICE RETURNED AN UNEXPECTED RETURN CODE '0000000C'X FOR FUNCTION ADD_ENTRY SSN= DSND PROC= DSNDSPAS ASID= 007D WLM_ENV= Here is the COBOL information from a compile: PP 5668-958 IBM VS COBOL II Release 4.0 09/15/92 I don't know how to determine the release of LE/370 we are using. Does anyone have any suggestions for debugging this? Thank you! Deborah Gresham SCANA Services [...] 4319 91 18_Re: Bufferpooltool14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 1 Feb 2002 16:10:20 -0600586_iso-8859-1 Gerald:

If that is indeed what Joel is referring to I would like to ask for verification of this. We have conducted tests here at BMC that show that all buffer pages are not invalidated when an alter bufferpool command is issued. Indeed, pool increases have no discernible negative effect. Of course, when you alter a buffer pool to reduce the size of that pool, the pages that have been removed will be "invalidated" as they are flushed from the LRU queue. For example, reducing a pool in size from 10,000 pages to 9,000 pages represents a 1,000 page reduction. [...] 4411 50 25_Re: UDB Stored Procedures0_26_Steve.Westfall@EQUIFAX.COM30_Fri, 1 Feb 2002 16:09:35 -0600573_us-ascii And "db2 get db cfg for







"Fennell, Michael" To: DB2-L@RYCI.COM Subject: Re: UDB Stored Procedures Sent by: DB2 Data Base Discussion List



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









db2 get dbm cfg

-----Original Message----- From: db46@DAIMLERCHRYSLER.COM [mailto:db46@DAIMLERCHRYSLER.COM] Sent: Friday, February 01, 2002 1:03 PM To: DB2-L@RYCI.COM Subject: UDB Stored Procedures [...] 4462 54 7_AW: SAP16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE30_Fri, 1 Feb 2002 23:26:53 +0100664_ISO-8859-1 There are some very nice redbooks www.redbooks.ibm.com I also recommend to apply new service for DB2 V6

Use the DEFINE(NO) option during installation to save a lot of space among other handling problems

There is a seperate listserver for SAP DB2 mailto:listserver@listserv.cai.com

Roland

> -----Ursprüngliche Nachricht----- > Von: Toni LeTempt [SMTP:tletemp@OIR.STATE.SC.US] > Gesendet am: Freitag, 1. Februar 2002 21:13 > An: DB2-L@RYCI.COM > Betreff: SAP > > We are in the process of implementing a three tier SAP R/3 4.6c system > using AIX for the application and DB2 OS390 v 6 for the database. We are > just about [...] 4517 177 18_Re: Bufferpooltool15_Sniderman, Karl21_ksniderman@BCBSOK.COM30_Fri, 1 Feb 2002 16:58:32 -0600579_iso-8859-1 Craig and Joel: Please do NOT take a conversation like this off-line. It is a marvelous learning tool for those of us who haven't been doing tuning for long times. Karl

-----Original Message----- From: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM] Sent: Friday, February 01, 2002 3:57 PM To: DB2-L@RYCI.COM Subject: Re: Bufferpooltool



Craig, Naturally, all vendors promote different opinions. I come from a systems tuning perspective, and have been tuning various types of systems for almost 4 decades, and DB2 systems for 16 years. [...] 4695 185 18_Re: Bufferpooltool0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 1 Feb 2002 17:03:32 -0600443_us-ascii I for one, vote ***please*** don't take it off line! I think this discussion is GREAT learning opportunity for all of us. Two knowledgeable sources (another way of saying 'experts') discussing differing/oposing viewpoints and providing examples. Great stuff!!!

Just call me greedy for knowledge Rohn









Joel Goldstein @RYCI.COM> on 2002/02/01 03:56:32 PM [...] 4881 147 18_Re: Bufferpooltool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 1 Feb 2002 18:19:24 -0500602_ISO-8859-1 Craig, Interesting that your results are contrary to everything I've seen running against real workloads in the field, Perhaps there's also some type of load effect that amplifies the impact (maybe the lru queues must be fully populated), but I see this happening when pool sizes are increased, not only decreased. How about a relatively consistent I/O rate of 66 for a pool , and having it spike to over 100/sec immediately after the size is increased, then settle back down to 41/sec? Similar effects on altering (increasing sizes) on other pools in the same system. This is just one [...] 5029 49 53_Re: Newbie question about DB2 OS/390 stored procedure0_16_khampto1@TXU.COM30_Fri, 1 Feb 2002 17:31:08 -0600503_us-ascii Hi Deborah, I believe that DB2 stored procedures do not support the old COBOL II compiler you are using, it requires a minimum of COBOL for MVS ( the LE/370 COBOL compiler).













"GRESHAM, DEBORAH B" on 02/01/2002 04:06:40 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Kirk Hampton/BIZSRV/TXU) Subject: Newbie question about DB2 OS/390 stored procedure [...] 5079 49 53_Re: Newbie question about DB2 OS/390 stored procedure13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM30_Fri, 1 Feb 2002 17:22:40 -0600480_iso-8859-1 Deborah, you are running the wrong version of the Cobol compiler. You need to use a compiler which supports LE/3790. You need to use either the Cobol for MVS or Cobol for OS/390 Compiler.

thanks,

Andy Seuffert NEON Systems, Inc.





-----Original Message----- From: GRESHAM, DEBORAH B [mailto:DGRESHAM@SCANA.COM] Sent: Friday, February 01, 2002 4:07 PM To: DB2-L@RYCI.COM Subject: Newbie question about DB2 OS/390 stored procedure [...] 5129 213 18_Re: Bufferpooltool23_Tello Najera Juan Pablo26_jp.tello@BBVA.BANCOMER.COM30_Fri, 1 Feb 2002 17:37:23 -0600495_iso-8859-1 I agree with Rohn, Please let us take the opportunity to learn more about your kowledge and your experience with this matter.

Regards



Juan Pablo Tello N. DB2 Specialist BBVA Bancomer Mexico City e-mail: jp.tello@bbva.bancomer.com









-----Mensaje original----- De: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Enviado el: Viernes, 01 de Febrero de 2002 05:04 p.m. Para: DB2-L@RYCI.COM Asunto: Re: Bufferpooltool [...] 5343 72 53_Re: Newbie question about DB2 OS/390 stored procedure0_19_Tim.Lowe@STPAUL.COM30_Fri, 1 Feb 2002 17:45:52 -0600499_us-ascii Deborah, You need to compile your stored procedure with IBM COBOL, not Cobol II. See the redbook, "Getting Started with Stored Procedures, Give Them a Call through the Network". In my old hardcopy, this is on page 35: "Althought you can use the VS COBOL II compiler for DB2 client applications, you cannot use it to compile stored procedures. To compile stored procedures written in COBOL, you must use the IBM SAA AD/Cycle COBOL/370 Version 1 Release 1 compiler, or a later version." [...] 5416 159 18_Re: Bufferpooltool13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Fri, 1 Feb 2002 16:12:35 -0800498_iso-8859-1 Joel,

As per DB2 command reference:

Contracting an Active Virtual Buffer Pool: If you use ALTER BUFFERPOOL to contract the size of an active virtual buffer pool, DB2 contracts the pool by marking active buffers as "to be deleted," which means they are not reusable to satisfy other page requests. However, the virtual storage might not be freed immediately. A system administrator can determine the status of the buffer pool by issuing the DISPLAY BUFFERPOOL command. [...] 5576 74 38_Re: Closed dataset still held by DBM1?64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM30_Fri, 1 Feb 2002 18:42:00 -0600385_ISO-8859-1 Ok. (I don't follow "QED"?? What's that?) I ran another test today, similar to yours.

I think that the end result of this discussion is that 1) I have learned that there is a form of the -STOP DB command that is synchronous, and that 2) the Command Reference is incomplete, vague, perhaps even incorrect in its description of the behavior of how -STOP DB works. [...] 5651 78 15_DSNUTILS -805 ?13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Fri, 1 Feb 2002 18:38:04 -0600307_US-ASCII Greetings, DB2 V6.1.2 OS/390 2.9 I know the DISTSERV planname is for distributed server threads using DRDA access. It is not a bound plan. Has anyone out there experienced this ?. I'm trying to run a OS/390 utility from the Control Center. MS W2K V7.2 Fixpak 5. JOBLOG from WLM PROC follows : [...] 5730 62 18_Re: Bufferpooltool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 1 Feb 2002 20:11:43 -0500582_ISO-8859-1 Ashish, Yes, this is obvious, it's published, and everyone knows this. The other observed issue is the high I/O rate when a pool is increased. There is no logical reason for it to happen, but it does. Maybe it's by mis-design, or a slight coding bug, than real intent.

The second issue, regarding any performance tests that fall into a "benchmark" flavor, is that they be realistically sized to provide both reliability and consistency. So, if you are going to access data for a test, how large is your set of data, how are you accessing it, and the locality [...] 5793 34 40_Platinum Database Analyzer Help needed!!11_Linda Ayeni22_lindaayeni@HOTMAIL.COM30_Fri, 1 Feb 2002 19:07:43 -0700368_- Hello Listers,

I am just getting into using Platinum Database Analyzer to create my DB2 Utilities(IC, REORG,RUNSTATS, etc). I will like to automate this processes but I am having problem generating the correct JCL and objects. In the first place, symbolic variables is not substituting, and second, I cannot seem to get the correct model to work for me. [...] 5828 181 18_Re: Bufferpooltool16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Fri, 1 Feb 2002 21:32:33 -0500578_us-ascii please do not take this offline this ia reality check and much appreciated







Joel Goldstein on 02/01/2002 04:56:32 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: Bufferpooltool





Craig, Naturally, all vendors promote different opinions. I come from a systems tuning perspective, and have been tuning various types of systems for almost 4 decades, and DB2 systems for 16 years. [...] 6010 143 18_Re: Bufferpooltool16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Fri, 1 Feb 2002 21:36:13 -0500743_us-ascii see max scarpa's recent entry on test vs production - scaling.







Joel Goldstein on 02/01/2002 06:19:24 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: Bufferpooltool





Craig, Interesting that your results are contrary to everything I've seen running against real workloads in the field, Perhaps there's also some type of load effect that amplifies the impact (maybe the lru queues must be fully populated), but I see this happening when pool sizes are increased, not only decreased. How about a relatively consistent I/O rate of 66 for a pool [...] 6154 151 18_Re: Bufferpooltool12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Fri, 1 Feb 2002 22:35:57 -0600561_iso-8859-1 Craig:

This is a most interesting reply. I am in Europe for a week or two, but will try to set up a test case based on your information when I return. This would mean a test during the third week of February. A few questions...

Are more statistics available? Am I correct that we are measuring just one Buffer Pool that has been altered? If so does it contain multiple Tablespaces? Indexes? Is there more than one table in each Tablespace. Do we know the locality of reference for the pages touched. I would interpret this to be a [...] 6306 172 25_Re: UDB stored procedures0_24_db46@DAIMLERCHRYSLER.COM30_Fri, 1 Feb 2002 12:34:25 -0500423_iso-8859-1 Obviously. Will include the text for the help of the list.

For the first one we are getting:

[IBM]{CLI Driver}{DB2/6000] SQL10013N The specified library "/home/inaxbd8/sqllig/function/db2psmdr" could not be loaded SQLCODE -10013

The second on is simply a blank build options panel in stored procedure builder

The third is showing the successful execution and building of the SP. [...] 6479 26 11_Re: AW: SAP20_SUBSCRIBE DB2-L Ravi19_dbadb2udb@YAHOO.COM30_Fri, 1 Feb 2002 23:52:50 -0600423_- Hi,

Theres a REDBOOK named ' IBM DB2 for AIX and SAP R/3 Administration Guide'

The redbook number is SG24-4871-00

Can find this in ibm redbooks website.

Now, isn't this the right book for you ? It covers AIX-DB2-SAP in one go !!!

I just took up the project as AIX / DB2 DBA for SAP based ERP solution . Even i am pretty new to SAP world...any one in the list with SAP on DB2 UDB ? [...] 6506 119 22_Re: IDENTITY_VAL_LOCAL12_Isaac Yassin20_yassini@BEZEQINT.NET30_Sat, 2 Feb 2002 10:26:15 +0200529_ISO-8859-1 Hi,

1. EXEC SQL VALUES IDENTITY_VAL_LOCAL() INTO :YOUR_HOST_VAR END-EXEC. 2. If you want to use MAX, and you are on V6, better have a DESCENDING index on that column.



Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net ----- Original Message ----- From: "Gross, Chuck" Newsgroups: bit.listserv.db2-l To: Sent: Friday, February 01, 2002 9:40 PM Subject: Re: IDENTITY_VAL_LOCAL [...] 6626 47 44_Re: Platinum Database Analyzer Help needed!!10_Alan Smith25_alancsmith@BTINTERNET.COM30_Sat, 2 Feb 2002 08:32:52 +0000318_US-ASCII Linda, If you place an 'S' (for submit) against the extract procedure, it generates a job which you can copy into the library for your job scheduler. Getting the right job name and member name is not so easy, so you may have to do some post-processing. e-mail me direct with more details if you want to. [...] 6674 73 11_User rights23_Muruganandam Sambasivam33_muruganandam.sambasivam@WIPRO.COM30_Sat, 2 Feb 2002 14:33:26 +0530418_iso-8859-1 Hi,

I'm working in DB2 UDB7.2 on windows 2000 platform.

I have problem in assigning user rights.

I assign rights thru Database Authorities option. I've added a user and given rights for him.

But when the user tries to access the Tables, it gives an error, "undefined name" Whenever the user access the Tables, the system expects the SCHEMA thru which the Table was created. [...] 6748 56 22_Re: IDENTITY_VAL_LOCAL14_Peter Backlund21_pbacklu@ATTGLOBAL.NET30_Sat, 2 Feb 2002 10:52:11 +0100 6805 25 49_Loading probelm with Date field specified as NULL17_jennifer jennifer22_jenni_jeni@HOTMAIL.COM30_Sat, 2 Feb 2002 12:20:34 +0000524_- Hi All experts, here I m facing a probelm and desperately needed a help. The table has a date field which is NULLABLE. I got conversion error for that. I tried with NULLIF'?' also but got the same probelm. Then I checked the INPUT file and enquired the field. The field has space in that position. Is there any possiblity that I could load the data in to table even if space is there.I have the manual but could not get any successful answer or I could not understand. Could any one help me out ? Thanking you all in [...] 6831 103 53_Re: Loading probelm with Date field specified as NULL12_Sanjay Singh24_Sanjay.Singh@BOIMAIL.COM30_Sat, 2 Feb 2002 07:09:56 -0600474_us-ascii Hi jennifer,

I think so you have to remove date discrption colum from syspunch file if it is coming throughout null in date field ..

otherwise you have to break file into two file in which one have date value is populated and other with nulls value so at the time uploading you have to upload first file(date field populated) with date field mention in syspunch and for other file(nulls in date field) you have to remove date field from syspunch [...] 6935 44 53_Re: Loading probelm with Date field specified as NULL12_Isaac Yassin20_yassini@BEZEQINT.NET30_Sat, 2 Feb 2002 15:33:42 +0200444_windows-1255 Hi, You were there already - use NULLIF ' ' (blank) on the correct columns in you input file. If you can find why it got blanks - it's a bonus for next time . Isaac Yassin yassini@bezeqint.net ----- Original Message ----- From: "jennifer jennifer" Newsgroups: bit.listserv.db2-l To: Sent: Saturday, February 02, 2002 2:20 PM Subject: Loading probelm with Date field specified as NULL [...] 6980 27 11_Re: AW: SAP12_John Janssen19_john.janssen@ABP.NL30_Sun, 3 Feb 2002 09:37:32 +0100544_iso-8859-1 Ravi, Are you running DB2 UDB on OS/390 or on AIX. Usually there is a db-layer on OS/390 and application-servers on AIX. Essentially is also what SAP-release and what DB2-release you are running, it differs a lot. Have a look at the redbooks SAP R/3 on DB2 for OS/390: Database Administration Experiences sap 4.5a, db2 5.1 aix 4.3.1: SG24-2078-01 SAP R/3 on DB2 for OS/390: Disaster Recovery sap 4.0b, db2 5.1 aix 4.3.1. : SG24-5343-00 Maybe there are newer releases of these books , the last two numbers should be higher then. [...] 7008 46 29_Distributed DB2 and Fixpack 514_Peter Backlund21_pbacklu@ATTGLOBAL.NET30_Sun, 3 Feb 2002 11:59:37 +0100 7055 18 39_Good tools for application programmers?8_helenctu28_helenctu@UCLINK.BERKELEY.EDU30_Sun, 3 Feb 2002 11:06:20 -0800419_ISO-8859-1 Would you please share your experiences, good or bad, on third party tools for application programmers on DB2 for OS/390?

Thank you in advance.

Helen Tu

================================================ 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. 7074 64 53_4th DB2 Symposium in the Netherlands 17-19 April 200211_Klaas Brant14_KBrant@KBCE.NL30_Sun, 3 Feb 2002 20:51:51 +0100355_us-ascii >>> DB2 Symposium 2002 Europe - 17-19 April 2002 <<< >>> See www.db2-symposium.com for all the details <<<

Dear DB2 professionals,

At the roots of DB2 Symposium: Veldhoven in The Netherlands, where Susan Lawson, Richard Yevich and Klaas Brant launched in 1999 the db2 symposium idea, we will have our 4th DB2 Symposium Europe. [...] 7139 25 38_Re: Closed dataset still held by DBM1?12_Raymond Bell17_rbell@NZ1.IBM.COM30_Mon, 4 Feb 2002 10:41:09 +1300466_us-ascii Todd,

Hmmm. Looks like nothing's ever as simple as one thinks. So DSN commands can be synch or asynch (I get tired of writing the whole word, both mentally and digitally) depending on how you invoke them. Interesting. Having always only ever used 'batch TSO' to issue DSN commands I'd always assumed they were always synch and, as presumably you've always used the IFI, you assumed they were always asynch. Something learnt on both sides, then. [...] 7165 74 38_Re: Closed dataset still held by DBM1?14_Grainger, Phil20_Phil.Grainger@CA.COM30_Mon, 4 Feb 2002 00:33:07 -0000341_iso-8859-1 I'm not sure that IFI commands count as "issued from batch" as you are presumably connected through CAF. DSN from IKJEFTxx in a batch job IS batch though........

That's probably why ISVs (like CAs Batch processor) need to loop through waiting for the STOP to take effect. CAF connect does NOT equal batch connect..... [...] 7240 104 71_Press Release: DGI Appoints DB2 Expert Philip Gunning to Vice President14_Pam Greenfield28_pgreenfi@BREAKTHROUGHDB2.COM30_Sun, 3 Feb 2002 23:14:33 -0600460_ISO-8859-1 FOR IMMEDIATE RELEASE

DGI Appoints DB2 Expert Philip Gunning to Vice President

Rochester, NY – (February 4, 2002) – DGI announced today that it has hired Philip Gunning as Vice President of its Professional Services Division. As a recognized industry expert on IBM DB2* Universal Database for Linux, UNIX, and Windows, Gunning will apply his years of industry expertise to deliver DGI and DB2 UDB product training and consulting. [...] 7345 19 59_Derez D. Lusk/Household International is out of the office.13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM30_Mon, 4 Feb 2002 01:02:21 -0600541_us-ascii I will be out of the office starting 02/03/2002 and will not return until 02/09/2002.

I will be out of the office today . please call 847-824-2871 and leave detailed message or via HOUSEMAIL - page EMPZ59 Any critical issues Please notify Mars Primary Support HTSMARS - via Housemail

================================================ 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. 7365 56 11_Re: IPREFIX22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM30_Mon, 4 Feb 2002 13:25:07 +0530476_- Vijay,

As Tim pointed out, from V7 online reorg doesn't rename the dataset. DB2 updates the catalog table for dataset name. The 5th qualifier, if it starts from I, it will be changed to J and vice versa. DB2 as usual creates the shadow datasets and by updating the catalog, it makes the same dataset as active dataset(instead of renaming it and deleting the current one). Online reorg has become faster than what it was till V6 due to this FASTSWITCH mechanism. [...] 7422 54 18_Re: working tables22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM30_Mon, 4 Feb 2002 13:30:39 +0530375_- Instead of having the cobol program, write a JCL. First step of JCL will copy the VSAM content into a temporary sequential dataset and 2nd step will use LOAD with LOG NO (with NOCOPYPEND if you have V7) using sequential dataset as input.If you are below V7, you may use START ACCESS (FORCE) or take the image copy depending on priorities and criticality of your data. [...] 7477 20 36_serious messages to be highlighted ?7_Eric Ng22_ngyh@PUBLICBANK.COM.MY30_Mon, 4 Feb 2002 01:56:59 -0600550_- Our shop intends to highlight important DB2 error messages on the console. Eg.

DSNP001I csect - data-set-name IS WITHIN nk BYTES OF AVAILABLE SPACE.

Anybody has a list of the serious messages to be highlighed on the console ?

Your help is very much appreciated.

Regards, Eric Ng

================================================ 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. 7498 109 33_Re: Distributed DB2 and Fixpack 50_23_db2admin@JULIUSBAER.COM30_Mon, 4 Feb 2002 10:01:02 +0100565_us-ascii Hi Peter

I ran into big problems applying Fixpack 5 with an application using/developed in JAVA. I had to go back to a previous Fixpack and .... the appilcation works fine again !

Peter Horner

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

Peter Horner, ISDD Bank Julius Baer & Co. Ltd. Hohlstrasse 602, CH-8010 Zurich, Switzerland Telephone +41 (1) 437 44 04, Fax +41 (1) 437 44 75 www.juliusbaer.com ----------------------------------------------------------------------------------- [...] 7608 46 24_re. IDENTITY_VAL_LOCAL()19_Feargal FitzPatrick31_Feargal.Fitzpatrick@BOIMAIL.COM30_Mon, 4 Feb 2002 09:14:01 +0000368_us-ascii Thank you for replies received to my query posted Friday 01-Feb.

The singleton SELECT on SYSIBM.SYSDUMMY1 is my preferred option - thanks to Tim Lowe.

The other suggestions involved host variables and changing the isolation level. As this needs to run in a DB2 Connect environment, those suggestions would be trickier to implement. Regards [...] 7655 136 18_Re: working tables14_Peter Backlund21_pbacklu@ATTGLOBAL.NET30_Mon, 4 Feb 2002 10:27:27 +0100606_IBM850 Just a quick comment.

There is no need to use the "dangerous" START ACCESS(FORCE) It is much safer to use REPAIR SET NOCOPYPEND

Peter

S, Sanjeev (Cognizant) wrote:

>Instead of having the cobol program, write a JCL. First step of JCL will >copy the VSAM content into a temporary sequential dataset and 2nd step will >use LOAD with LOG NO (with NOCOPYPEND if you have V7) using sequential >dataset as input.If you are below V7, you may use START ACCESS (FORCE) or >take the image copy depending on priorities and criticality of your data. > >This approach is valid if [...] 7792 18 93_Re: Is there are any methodology to find out which packages are actually executed by a plan ?15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Mon, 4 Feb 2002 03:54:49 -0600521_- As far as I know, there is no safe way, to find out, which plan executes which packages, if you have bound your plans with collid.*. You can turn on accounting class 7 and then use a tool like candle extractor to load the SMS-records into a db2 table and query these tables. But in this case, you can only say, which packages a plan has actually executed, but you can't say if these packages are all a certain plan will ever execute. So you can put all these package into the PKLIST and wait for -805 and than add [...] 7811 31 28_To find record given the RID14_"Sajad Javid".23_sajad@CHENNAI.TCS.CO.IN30_Mon, 4 Feb 2002 15:58:37 +0530463_us-ascii Hi, How can I find the contents of the row using the RID value in the DSNT501I message

For eg

DSNT501I @Z DSNILMCL RESOURCE UNAVAILABLE CORRELATION-ID=ENTRIO010002 CONNECTION-ID=CICSR1 LUW-ID=* REASON 00C9008E TYPE 00000304 NAME DB2DB1 .OITTS .X'000591' '.X'0E'

from the message we understand that the resource is a ROW. How do I find out the contents of the ROW Do I have to use DSN1PRNT , if yes how do I interpret the output [...] 7843 122 38_Re: Closed dataset still held by DBM1?9_Chris Tee23_chris.tee@UK.ZURICH.COM30_Mon, 4 Feb 2002 10:58:04 +0000470_us-ascii Quod erat demonstrandum - That which was to have been proved

Must be something that all old maths teachers learnt as that was my maths teacher's favourite saying as well!

Chris









Todd Burch ******************************************* To: DB2-L@RYCI.COM ********** cc: Sent by: DB2 Data Base Discussion List Subject: Re: [DB2-L] Closed dataset still held by DBM1? [...] 7966 36 19_add_months function11_Daniel Adam16_dadam@GRATEX.COM30_Mon, 4 Feb 2002 05:21:15 -0600630_- Hi list, This is DB2 V7.1 on OS/390 v2r10. something weird - don't believe we are the first to stumble on it, but didn't find it posted anywhere yet.

SELECT ADD_MONTHS(CURRENT DATE,2) FROM SYSIBM.SYSDUMMY1

SQLCODE : -180 DSNTIAR CODE : 0

DSNT408I SQLCODE = -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE IS INVALID DSNT418I SQLSTATE = 22007 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRLET SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -6805 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFE56B' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION [...] 8003 37 21_Re: EDM pool shortage11_Daniel Adam16_dadam@GRATEX.COM30_Mon, 4 Feb 2002 05:24:24 -0600595_- On Wed, 30 Jan 2002 18:32:37 -0600, Daniel Adam wrote:

btw, this is on DB2 v7.1 on fairly recent os/390 v2r10.



>Hi, >We have a stored procedure that has several nested calls ( of other stored >procedures ) build in it. These calls execute in a cycle hundreads of times. >When this procedure is executed, we get EDM pool full message: > >DSNT500I - DSNGEPLC RESOURCE UNAVAILABLE 055 > REASON 00C90089 > TYPE 00000600 > NAME > >Using DB2 Perf. monitor I verified that it is the packages that completely >fill out out EDM pool. All of those packages [...] 8041 77 23_Re: add_months function13_BL.Tink Tysor16_tink@BLTYSOR.COM30_Mon, 4 Feb 2002 04:25:46 -0800588_us-ascii Daniel,

Won't

CURRENT DATE + :MonthCount MONTHS

work where :MonthCount is a host variable?

Tink --- Daniel Adam wrote: > Hi list, > This is DB2 V7.1 on OS/390 v2r10. > something weird - don't believe we are the first to > stumble on it, but > didn't find it posted anywhere yet. > > SELECT ADD_MONTHS(CURRENT DATE,2) FROM > SYSIBM.SYSDUMMY1 > > SQLCODE : -180 DSNTIAR > CODE : 0 > > DSNT408I SQLCODE = -180, ERROR: THE DATE, TIME, OR > TIMESTAMP VALUE IS > INVALID > DSNT418I SQLSTATE = 22007 SQLSTATE RETURN > CODE > DSNT415I [...] 8119 154 23_Re: add_months function0_24_Sridhar_Kondusamy@I2.COM30_Mon, 4 Feb 2002 17:54:53 +0530466_us-ascii Hi Daniel

When I tried issuing the same command in AIX 4.3.3 , DB2 7.2 installation I got the following error message



db2 => SELECT ADD_MONTHS(CURRENT DATE,2) FROM SYSIBM.SYSDUMMY1 SQL0440N No function by the name "ADD_MONTHS" having compatible arguments was found in the function path. SQLSTATE=42884

I dont think the error message which you got is the right one or could be ADD_MONTHS is not supported in AIX environment [...] 8274 152 8_Re: WLM?9_Chu, Pius14_ChuP@CONED.COM30_Mon, 4 Feb 2002 08:57:52 -0500407_iso-8859-1 Hi Dean, RRS is required and must be active to run DB2 WLM stored procedure. In order to run the DB2 stored procedure under the WLM address space, your program must be linkedit with "DSNRLI", which is the DB2/RRS call attached (RRSAF). As a matter of fact, if you don't have RRS running when you bring up the DB2 WLM stored procedure address space, you will fail with the following message: [...] 8427 53 25_DSN1COPY a partitioned TS15_Martin Granwehr26_Martin.Granwehr@HELSANA.CH30_Mon, 4 Feb 2002 13:47:27 +0100572_US-ASCII Like Don Cross last week we did some testing with a 'Recovery of an accidentally dropped table', but we tried his scenario with a partitioned TS. (We are running DB2 V6 on OS/390 V2.10).



Here's our scenario: 1. We dropped a partitioned TS without an actual image copy and without record the DBID, PSID, OBID (like it could happen in real life). 2. We recreated the objects (incl. VSAM DELETE/DEFINE of all the datasets). 3. We got the "old" DBID, PSID and OBID out of the last IC (DSN1PRNT) and the new ones from catalog. 4. We stopped the TS [...] 8481 92 53_Re: Newbie question about DB2 OS/390 stored procedure18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM30_Mon, 4 Feb 2002 09:04:45 -0500468_iso-8859-1 Thanks for the help. I've had three replies all indicating the same thing, which I'll try next. And I really appreciate your indicating the references. I like to do the research but sometimes don't know where to start! Thanks again, Deborah

-----Original Message----- From: Tim.Lowe@STPAUL.COM [mailto:Tim.Lowe@STPAUL.COM] Sent: Friday, February 01, 2002 6:46 PM To: DB2-L@RYCI.COM Subject: Re: Newbie question about DB2 OS/390 stored procedure [...] 8574 56 44_Re: Platinum Database Analyzer Help needed!!16_Fennell, Michael23_Michael.Fennell@FMR.COM30_Mon, 4 Feb 2002 09:15:00 -0500624_- If you want - give me a call I should be able to help you

Mike Fennell Database Services 508-787-9120 PIN # 2128845



> -----Original Message----- > From: Linda Ayeni [SMTP:lindaayeni@HOTMAIL.COM] > Sent: Friday, February 01, 2002 9:08 PM > To: DB2-L@RYCI.COM > Subject: Platinum Database Analyzer Help needed!! > > Hello Listers, > > I am just getting into using Platinum Database Analyzer to create my DB2 > Utilities(IC, REORG,RUNSTATS, etc). I will like to automate this processes > but I am having problem generating the correct JCL and objects. In the > first > place, symbolic variables is [...] 8631 167 8_Re: WLM?14_Dean Montevago18_DMonteva@VNSNY.ORG30_Mon, 4 Feb 2002 09:48:24 -0500627_iso-8859-1 Thanks Pius, I thought if you were doing CAF you didn't need it.



-----Original Message----- From: Chu, Pius [mailto:ChuP@CONED.COM] Sent: Monday, February 04, 2002 8:58 AM To: DB2-L@RYCI.COM Subject: Re: WLM?



Hi Dean, RRS is required and must be active to run DB2 WLM stored procedure. In order to run the DB2 stored procedure under the WLM address space, your program must be linkedit with "DSNRLI", which is the DB2/RRS call attached (RRSAF). As a matter of fact, if you don't have RRS running when you bring up the DB2 WLM stored procedure address space, you will fail with the [...] 8799 23 15_Identity Column12_Mathur, Anil29_AMathur@HARLEYSVILLEGROUP.COM30_Mon, 4 Feb 2002 09:41:24 -0500321_- Hi List,

We are DB2 V7.1 on OS/390 V2R10. I am trying to Alter the definition of an Identity column in a table but have not got any success. I don't know if this is possible on OS/390. Does anyone know if this can be done and what is the syntax or a fix is needed to make this happen. Thanks for your help. [...] 8823 82 29_Re: DSN1COPY a partitioned TS23_Tello Najera Juan Pablo26_jp.tello@BBVA.BANCOMER.COM30_Mon, 4 Feb 2002 09:02:48 -0600491_iso-8859-1 Hi all: I think this is a bug in the DSN1COPY util. My first gues would be look in the APAR Database or open a Problem with IBM and give them all the information you have. This weekend I tried to do a BRS test, and recovering DBD01 I had a message of a resource unavailable, I tried what the manual says but I couldn't recover, so I opened a problem with IBM and they gave me 2 PTF's. After applying, the recover went OK. So what I recomend is to ask IBM to see the problem. [...] 8906 71 29_Re: DSN1COPY a partitioned TS11_Robert Jans26_robert.jans@ALBERTSONS.COM30_Mon, 4 Feb 2002 07:33:30 -0800476_- Hi, Martin. Just a silly question. The tablespace doesn't happen to be to be define as LARGE or with a DSSIZE of 4G, does it? That would mean you would need to add either the dssize or large parameter..........



Robert Jans Albertson's Inc (Standard Disclaimers Apply)

-----Original Message----- From: Martin Granwehr [mailto:Martin.Granwehr@HELSANA.CH] Sent: Monday, February 04, 2002 5:47 AM To: DB2-L@RYCI.COM Subject: DSN1COPY a partitioned TS [...] 8978 57 15_Re: User rights14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Mon, 4 Feb 2002 10:34:12 -0500464_iso-8859-1 Set CURRENT SCHEMA to 'ADMIN' using the following command:

set current schema = 'ADMIN';

Manas.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Muruganandam Sambasivam Sent: Saturday, February 02, 2002 4:03 AM To: DB2-L@RYCI.COM Subject: User rights



Hi,

I'm working in DB2 UDB7.2 on windows 2000 platform.

I have problem in assigning user rights. [...] 9036 19 93_Re: Is there are any methodology to find out which packages are actually executed by a plan ?13_Brendan Friel28_Brendan_Friel@NOTES.NTRS.COM30_Mon, 4 Feb 2002 09:47:14 -0600449_us-ascii Thanks for the response.

With all the arguments about how many DB2 bufferpools can you tweak on the edge of a needle I'm disappointed we don't have a response from IBM.

Thanks, Brendan

================================================ 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. 9056 20 0_15_Dorinda Peachey22_dorinda@ARCHES.UGA.EDU30_Mon, 4 Feb 2002 10:48:02 -0500466_US-ASCII Hi,

Is it possible to send basic sql from a Unix box to update a DB2 table? If so, how can this be done? Are other products needed to get this done?

thanks, Dorinda Peachey

University of Georgia

================================================ 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. 9077 46 48_Splitting a table with a large number of columns12_McKown, John22_JMckown@HEALTHAXIS.COM30_Mon, 4 Feb 2002 09:49:31 -0600541_- Just another curiousity question. Suppose I have a table which would normally contain about 20 columns which would add up to around 12K. Also suppose that of the 20 columns, only 5, totalling about 2K, are really active. The other 15 are rarely used. Would it be a good idea to split this table into two tables. One would consist of the 5 columns, the second with the other 15 (actually 16 since the second table would need to contain the same PRIMARY KEY as the first table). My thought is that it could be a good idea because doing [...] 9124 17 11_Re: AW: SAP12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 4 Feb 2002 09:40:19 -0600395_- There are too many Redbooks - 42 - when I sent out to ibm.com/redbooks and put in a search for SAP. If you qualify by the platform and look at the latest books - say 2000 and 2001, then there are still half a dozen books. For some of the platforms there are books in the standard library for the specific release levels too. This topic is covered well at conferences like IDUG and Share. [...] 9142 70 44_Re: Platinum Database Analyzer Help needed!!0_20_Jones.H@GRAINGER.COM30_Mon, 4 Feb 2002 09:48:00 -0500557_- Getting PDA to generate jobs to be executed through a scheduler is a very complex and aggravating prospect. But the result can be quite good. PDA has quite a bit of capacity for customization. But you have to understand the product thoroughly and apply some ingenuity. I am not about to describe the way my shop does it, because I, frankly, don't know. Every time I have to change or create something I have to haul out all of the documentation and relearn the process. It involves a lot of generate-this-and-copy-this-part-here-and-that-part-there. [...] 9213 40 0_13_Helen Johnson25_helen_johnson@RAC.RAY.COM30_Mon, 4 Feb 2002 10:14:32 -0600591_iso-8859-1 Is the DB2 on Unix or the mainframe?

> -----Original Message----- > From: Dorinda Peachey [mailto:dorinda@ARCHES.UGA.EDU] > Sent: Monday, February 04, 2002 9:48 AM > To: DB2-L@RYCI.COM > Subject: > > > Hi, > > Is it possible to send basic sql from a Unix box to update a > DB2 table? > If so, how can this be done? Are other products needed to get > this done? > > thanks, > Dorinda Peachey > > University of Georgia > > ================================================ > To change your subscription options or to cancel your > subscription visit the DB2-L webpage at [...] 9254 19 56_Shan Leatherman/MO/americancentury is out of the office.0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Mon, 4 Feb 2002 10:03:27 -0600547_us-ascii I will be out of the office starting 01/30/2002 and will not return until 02/05/2002.

If you need additional assistance, send a message to *DB or if you need immediate assistance page the primary DBA on call at (816) 292-5449 or contact the help desk (816) 340-4250.

Shan Leatherman

================================================ 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. 9274 25 16_Re: DB2 Versions12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 4 Feb 2002 10:21:22 -0600548_- We tried to make this information easy to find. It's on the main DB2 for z/OS and OS/390 page, under resources as DB2 Availability Summary. The second place to look is on the Support page, and it's there, under End of services dates.

As for the length of service, the year 2000 provided a lot of distortion, with much longer time in service than usual. If you want a rough rule of thumb, from general availability (GA) to end of service is around five years. Those who pick up a version in the first year after GA are early adopters. [...] 9300 21 36_Re: DEAD LOCK Problem - Help Listers12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 4 Feb 2002 10:32:11 -0600512_- As others are pointing out, there are many possibilities, depending upon the details for your situation. The Improving Concurrency chapter of the Administration Guide includes many suggestions for improvements and some detailed diagnosis techniques with the general discussion. Here are some of the subtopics from the V7 book, but others are similar. Basic recommendations to promote concurrency Lock tuning Claims and drains for concurrency control Monitoring of DB2 locking Deadlock detection scenarios [...] 9322 16 43_Jim Teng's DB2 Tech Conference Presentation10_Myles Reed21_MYLES.REED@NSCORP.COM30_Mon, 4 Feb 2002 10:42:00 -0600526_- I understand that Jim Teng did a presentation at the last DB2 Technical Conference that dealt with the Automation of DB2 Utilities for DB2 V7.1.

It is my understanding that the automation was accomplished using templates.

Does anyone have a copy of this presentation ?

================================================ 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. 9339 13 43_Jim Teng's DB2 Tech Conference Presentation10_Myles Reed21_MYLES.REED@NSCORP.COM30_Mon, 4 Feb 2002 10:42:00 -0600469_- I understand that Jim Teng did a presentation at the last DB2 Technical Conference that dealt with the Automation of DB2 Utilities for DB2 V7.1.

It is my understanding that the autimation was accomplished using the new

================================================ 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. 9353 19 16_Previous Record?16_Herbold, John W.26_JWHERBOLD@ARKBLUECROSS.COM30_Mon, 4 Feb 2002 10:56:15 -0600529_- Is it possible to subtract two dates, one from the previous record in an SQL statement in DB2 (os390 version 6)? I thought I remembered something about it, but I am not sure if it was in version 6 or 7 or future versions.

Thanks in advance!

John Herbold IS Specialist/DBA

================================================ 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. 9373 114 44_Re: Platinum Database Analyzer Help needed!!23_Tello Najera Juan Pablo26_jp.tello@BBVA.BANCOMER.COM30_Mon, 4 Feb 2002 10:57:53 -0600474_iso-8859-1 Every thing that Hayden have told is correct. I would like to add if you want to take out the "manual" proces of taking aout the PTIPT DD *, you may build an edit macro and after the jcl is generated, then use this edit macro in the next step, to build the "PTIPPT DD DISP=SHR,DSN=somepdsyoucreate(MEMBERNAME)" so this automates the jcl generation process and everything you have to do is add the automatic submission of the JCL via your scheduler like CA7. [...] 9488 18 21_Re: EDM pool shortage12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 4 Feb 2002 10:52:07 -0600505_- Tuning the EDM pool is the section of the Administration Guide that I'd suggest. A full pool can indicate that the space has become too small or that storage should be managed better or that commits should be more frequent or that there is a problem. For Version 7, the chapter is 27, the second section, titled "Tuning the EDM pool". It's only about 4 pages, and the DB2 PM (or equivalent) statistics report provides the evidence, especially if you have an older one, where the pool was adequate. [...] 9507 20 52_Re: Splitting a table with a large number of columns13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Mon, 4 Feb 2002 11:21:14 -0600543_- Although I haven't yet tried anything like that but I believe that this can be done by using triggers on BOTH the tables which can propogate the insert / delete to the other table, update off course can't be codependent. The data inserted on the "other" table would by necessity have to be default values as I don't see how any real values can be passed to the trigger. Moreover I don't see much benefit in having a table full of default values. Probably it would be better not to insert such dummy rows at all and the applications can [...] 9528 40 32_Re: High CPU in DBM1, CICS waits13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM30_Mon, 4 Feb 2002 11:57:22 -0600537_iso-8859-1 Second time around. Most of you probably have this problem and don't realize it unless you are monitoring the system very carefully. It not only affects CICS transactions, but all DB2 transactions as well. It is relational to the number of DBM1 datasets open and the frequency of your interval for SMF type 30, or your default interval. Can you bounce this off of you MVS SYSPROs and see what is set up for either the DB2 subsystem or STCs, and if you have DDCON set to Yes or No? Also, if any have it set to No, what if [...] 9569 26 37_DB2 AIX to DB2 OS/390 via DB2 Connect14_Runyon, Evelyn28_Runyon.Evelyn@CORP.SYSCO.COM30_Mon, 4 Feb 2002 12:03:21 -0600539_iso-8859-1 > We noticed our DSNDIST using up to 65% CPU when an AIX program accessed > DB2 OS/390 V5, direct access, i.e. one SELECT for every record read in > AIX. Our DB2 Connect is V7.1. > > We have the Data Warehouse (we're a new user) on the AIX. Data is > extracted from several AS400's nationawide, into AIX. And an AIX program > processes these data by adding information extracted from DB2 OS/390. On > my monitor (Landmark), I saw threads being reused, but looking at thread > history, there was one record for every 1 or 2 [...] 9596 60 32_Re: High CPU in DBM1, CICS waits16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Mon, 4 Feb 2002 13:12:39 -0500687_iso-8859-1 We have DDCONS=NO on all LPARs. No problems using this.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Jeremiah Eden [mailto:JEREMIAH.EDEN@RADIOSHACK.COM] Sent: Monday, February 04, 2002 12:57 PM To: DB2-L@RYCI.COM Subject: Re: High CPU in DBM1, CICS waits



Second time around. Most of you probably have this problem and don't realize it unless you are monitoring the system very carefully. It not only affects CICS transactions, but all DB2 transactions as well. It is relational to the number of DBM1 datasets open and the frequency of your interval for SMF type 30, or your default interval. Can you [...] 9657 13 5_Makro17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Mon, 4 Feb 2002 12:23:33 -0600353_us-ascii Anyone out there in db2 land ever work with a system called Makro? It is owned by a company called I2.

================================================ 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. 9671 16 43_Jim Teng's DB2 Tech Conference Presentation10_Myles Reed21_myles.reed@NSCORP.COM30_Mon, 4 Feb 2002 12:07:23 -0600541_- I understand that Jim Teng did a presentation at the last DB2 Technical Conference that dealt with the Automation of DB2 Utilities for DB2 V7.1.

It is my understanding that the automation was accomplished using the new template feature.

Does anyone have a copy of this presentation ?

================================================ 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. 9688 119 52_Re: Splitting a table with a large number of columns15_Jackson Reavill18_damcon2@US.IBM.COM30_Mon, 4 Feb 2002 13:32:42 -0500473_us-ascii Hi John,

I'm probably missing something, but the first thing that comes to mind is that you could actually be adding extra overhead. This would be due to either always having to join the two tables to pull back all of the data or always having to do an existence check to see if the less utilized data is populated. But maybe you have some way of knowing up-front whether or not you need the second row. If that's the case then I could see it helping. [...] 9808 76 47_Re: Jim Teng's DB2 Tech Conference Presentation0_19_Tim.Lowe@STPAUL.COM30_Mon, 4 Feb 2002 13:01:31 -0600609_us-ascii Myles, There was a DB2 Tech Conference presentation titled "Automation of Copy/Reorg Tasks" by Dave Schwartz and Andy Youniss, M46. But, it was about the DB2 Automation Tool, not templates. Jim Ruddy had a couple of presentations on DB2 utilities, M43 was "DB2 for z/os and OS/390 Utility Work Ahead" and M44 was "DB2 for z/os and OS/390 LOAD and UNLOAD utility enhancements". I don't remember a Jim Teng presentation on "Automation of DB2 utilities for DB2 V7.1" Jim Ruddy's M43 presentation had a couple of slides on the DB2 V7 template/listdef features. Perhaps you have your Jim's mixed up? [...] 9885 25 11_Re: Pgsteal12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 4 Feb 2002 12:28:57 -0600553_- Re you seeing latch contention? The classic advice is

1) In most cases, keep the default, LRU. 2) Use FIFO for buffer pools that have no I/O; that is, the table space or index remains in the buffer pool. Because all the pages are there, there is no need to pay the additional cost of a more complicated page management algorithm. 3) Keep objects that can benefit from the FIFO algorithm in different buffer pools from those that benefit from the LRU algorithm. See options for PGSTEAL in ALTER BUFFERPOOL command in DB2 Command Reference. [...] 9911 20 20_Re: Previous Record?12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 4 Feb 2002 12:45:33 -0600430_- Date arithmetic started back in V1R3. I think you'll want to start with the section in the SQL Reference titled Date Arithmetic or Subtracting Dates. The result of subtracting one date from another is a date duration - not exactly a date. Sometimes you need to to use some of the many built-in functions to get what you want, such as DAYS. In my V5 paper copy, this is chapter 3, Language Elements, section on Expressions. [...] 9932 15 32_Re: High CPU in DBM1, CICS waits12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 4 Feb 2002 12:52:57 -0600539_- Consolidation or DDCONS is one part of the problem. The second is that most customers are setting SMF STC(NODETAIL) to avoid the periodic processing for started tasks. An active DB2 could have hundreds of thousands of allocations over a period of a week or two.

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. 9948 49 19_Re: Identity Column10_Mathai Joy22_mathaijoydb2@YAHOO.COM30_Mon, 4 Feb 2002 11:10:13 -0800537_us-ascii Try This syntax.

alter table AGENT_TBL alter AGENT_IDPK restart with 9999;

Hope this will help you.

Mathai Joy --- "Mathur, Anil" wrote: > Hi List, > > We are DB2 V7.1 on OS/390 V2R10. I am > trying to Alter the > definition of an Identity column in a table but have > not got any success. I don't know if this > is possible on OS/390. > Does anyone know if this can be done and what > is the syntax or a fix is needed to make > this happen. Thanks for > your help. > > [...] 9998 59 47_Re: Jim Teng's DB2 Tech Conference Presentation10_James Kwan19_JamesDB2Kwan@CS.COM28_Mon, 4 Feb 2002 14:20:03 EST601_US-ASCII I think I have a copy somewhere however I don't know if there is any legal issue to distribute. May be you should ask IBMers to send you a copy.

James Kwan IBM Certified Solutions Expert...

In a message dated 2/4/02 11:30:26 AM Central Standard Time, MYLES.REED@NSCORP.COM writes:



> I understand that Jim Teng did a presentation at the last DB2 Technical > Conference that dealt with the Automation of DB2 Utilities for DB2 V7.1. > > It is my understanding that the automation was accomplished using > templates. > > Does anyone have a copy of this presentation ? 10058 36 28_Re: Creating SQL statements.10_Mathai Joy22_mathaijoydb2@YAHOO.COM30_Mon, 4 Feb 2002 11:32:03 -0800386_us-ascii I am running udb on NT. I am trying to create SQL statemens just like the following statements. alter table WIP_AGENT alter AGENT_IDPK restart with 576;

The number 576 is the output from the another SQL statement like Select max (AGENT_IDPK) from WIP_AGENT;

Is anyway I can combine this sql statements into one script or atleast replace 576 with max number. [...] 10095 26 50_DPROP on S/390 - CCD tables through Control Center16_Frank E. Giguere13_giguef@NU.COM30_Mon, 4 Feb 2002 14:10:13 -0500401_us-ascii Hi Everyone,

I'm looking for anyone with experience creating CCD target tables in S/390 DPROP. I'm looking to create Complete/non-Condensed CCD tables without any luck. The manual recommends that you use Data Joiner to create these target types (which we don't have), and says that they can be created through Control Center, but not directly (of course it doesn't tell you how). [...] 10122 57 19_Re: Identity Column12_Isaac Yassin20_yassini@BEZEQINT.NET30_Mon, 4 Feb 2002 21:28:14 +0200313_windows-1255 Hi, If you want to change column attribute on OS/390 you can only change length of a varchar field, as the manual says :

Alters the definition of a column. Only the length attribute of an existing column

with a VARCHAR data type can be changed. A column cannot be altered if it is [...] 10180 47 22_Data Joiner Connection12_Mark Buzzard21_Mark_Buzzard@ARIC.COM30_Mon, 4 Feb 2002 14:26:37 -0600363_us-ascii Hi,

I am trying to establish a connection from DB2 to IBM's Data Joiner (DJ) product. This will be a bridge to propogate data from DB2 v7.1 s/390 to SQL Server. Here is what I am trying to do:

DB2 [DSN8710.DEPT] --- (1) --> DJ database called HOLD -------> DJ alias of Sql Server Table in HOLD --- (2) ---> Sql Server Table [dbo.DEPT] [...] 10228 34 32_Re: High CPU in DBM1, CICS waits13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM30_Mon, 4 Feb 2002 15:01:45 -0600302_iso-8859-1 Thanks Eric and Roger. We have looked at both options. DDCON and NODETAIL. Setting DDCON to No would cause a lot more SMF records to be cut, so STC(NODETAIL) seems to be a better candidate. The fact that you say other customers have this set gives us a warmer feeling about doing this. [...] 10263 39 19_Re: Identity Column14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Tue, 5 Feb 2002 19:11:15 +1000561_US-ASCII On DB2 for other platforms, this became available at V7.2 (or was it fp4? can't remember). So, the answer is "it'll happen in the future, sometime".

Look in the archives, various work-arounds have been suggested. None elegant.

James Campbell

On 4 Feb 2002 at 9:41, Mathur, Anil wrote:

> Hi List, > > We are DB2 V7.1 on OS/390 V2R10. I am trying to Alter the > definition of an Identity column in a table but have > not got any success. I don't know if this is possible on OS/390. > Does anyone know if this can be done [...] 10303 51 32_Re: To find record given the RID14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Tue, 5 Feb 2002 19:11:16 +1000429_US-ASCII 1) make sure that the page has been written back to its vsam cluster (eg QUIESCE TABLESPACE DB2DB1.OITTS WRITE YES)

2) use DSN1PRNT to print page x'000591'.

3) hope that the row at id x'0e' has not changed in the meantime.

But, does it really matter? Have a look at the accompanying message and ask yourself "why is that program holding a lock on _any_ row for longer than the timeout period?" [...] 10355 180 8_Re: WLM?14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Tue, 5 Feb 2002 19:11:17 +1000547_US-ASCII You can't run CAF in a WLM SPAS - you can only use CAF (ie link DSNALI into your load module) for stored procedures in a DB2 SPAS.

James Campbell

On 4 Feb 2002 at 9:48, Dean Montevago wrote:

> Thanks Pius, I thought if you were doing CAF you didn't need it. > > > -----Original Message----- > From: Chu, Pius [mailto:ChuP@CONED.COM] > Sent: Monday, February 04, 2002 8:58 AM > To: DB2-L@RYCI.COM > Subject: Re: WLM? > > > Hi Dean, > RRS is required and must be active to run DB2 WLM stored procedure. In order > [...] 10536 67 40_Re: serious messages to be highlighted ?10_Missy Case28_Missy.Case@FIRSTDATACORP.COM30_Mon, 4 Feb 2002 15:46:45 -0600347_us-ascii Eric, These are the ones we started with. If course, you may want more, we just wanted to get started in the process. We set up a pageout for some of the touchier messages. YMMV

(Embedded image moved to file: pic24152.pcx) Missy Case IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 FDR PFDBA 701-275-6358 [...] 10604 27 47_Re: Jim Teng's DB2 Tech Conference Presentation10_Myles Reed21_myles.reed@NSCORP.COM30_Mon, 4 Feb 2002 16:20:16 -0600390_- I've talked to Roger Miller.

He sent me to the DB2 Tech Conference Web site but all of the details of the conference have been removed.

He also pointed me to : ibm.com/software/db2os390 Click on Support. Click on Technical Presentations

but I didn't find it.

Does your copy of this presentation give Jim Teng's email address so I can ask him for a copy ? [...] 10632 50 28_IBM/CDB/BMC Online Reorgs???16_Charles Valentin15_VALENCH@AOL.COM28_Mon, 4 Feb 2002 18:49:56 EST405_US-ASCII Dear Fellow Listserv Members,

We're currently testing IBM and CDB Software "Online Reorgs" & now the DBA's are looking to include BMC Online Reorgs in their test mix. Can anyone tell me "IF" the BMC Online Reorg Feature (separate license) is still required for this? I know that BMC requires the Reorg Plus AND XBM (Extended Buffer Manager) products, but unsure of the other product. [...] 10683 36 19_SQL CODE ERROR -18095_=?iso-8859-1?Q?PedroSC_-_Representa=E7=F5es_e_Servi=E7os_Unipessoal=2C_Ld?= =?iso-8859-1?Q?a.?=21_pedrosc69@HOTMAIL.COM30_Tue, 5 Feb 2002 00:14:47 -0000551_iso-8859-1 Hi all

I have a program that format a timestamp and a date field from a host-variable in a table. This program is working since begin last year. Last December we change our DB2 to V6. Today I need to make a master compile but I had a problem. SQL CODE ERROR -180 when he format the date field from the host-variable. I test with Smartest and the problem are the same. The host-variable was a field at working like this ex:=> 04 W22-DATA-ANO PIC X(10) <=. I change this field to another level ex:=> 01 W22-DATA-ANO PIC X(10) <=, [...] 10720 96 47_Re: Jim Teng's DB2 Tech Conference Presentation0_19_Tim.Lowe@STPAUL.COM30_Mon, 4 Feb 2002 18:17:01 -0600373_us-ascii Myles, According to my Conference Agenda(and the CD) from the last DB2 Tech conference, the 2 conference presentations that Jim Teng gave were: M16, "Using V7 Real-Time Statistics to assist DBA managing DB2 for Os/390", & M42, "DB2 for OS/390: A Fast and Non-disruptive Backup/Recovery Solution".

Neither of which sounds like what you are looking for. [...] 10817 18 22_Message in the DB2 log14_Robert Collins15_kcollins@WF.NET28_Tue, 5 Feb 2002 00:54:41 GMT393_iso-8859-1 Anybody got some information regarding this message in the DB2 log?

oper_system_services sqloSetFileAccessMode Probe:36

Thanks

================================================ 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. 10836 115 32_Re: IBM/CDB/BMC Online Reorgs???13_Bright, Randy20_Randy_Bright@BMC.COM30_Mon, 4 Feb 2002 20:48:42 -0600450_iso-8859-1 A separate license is no longer required for the Online feature of Reorg Plus for DB2. Licenses for Reorg Plus for DB2 and the Snapshot Upgrade Feature (SUF) of Extended Buffer Manager (XBM) are required. A full license for XBM is not required. With one installation of SUF, you will activate "online" features of several BMC DB2 products including (but not limited to) Unload Plus for DB2, Check Plus for DB2, and Copy Plus for DB2. [...] 10952 63 23_Re: SQL CODE ERROR -18011_Suresh Sane21_data_arch@HOTMAIL.COM30_Mon, 4 Feb 2002 23:56:39 -0600337_- Pedro,

I am not aware of any change with V6 in this area. Is it possible that the host is now at a level further down (i.e. used to be at up to 2nd level in the structure, is now at third level)? Host vars at such a level are not allowed - only at level 1 or 2 (regardless of what they are called in cobol e.g. 01 and 05). [...] 11016 19 69_To compare production data and the data restored at the disaster site34_Zalina Abdul Rahman/ITNOC/PBB/PBBG24_zalina@PUBLICBANK.COM.MY30_Tue, 5 Feb 2002 14:09:48 +0800492_us-ascii I would like to know if there is any tools that can compare the data restored at the disaster site against the data at production site.

Preferable : to compare 2 image copy datasets, (disaster site vs production site)

Thank You

================================================ 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. 11036 18 49_To compare production data and disaster site data34_Zalina Abdul Rahman/ITNOC/PBB/PBBG24_zalina@PUBLICBANK.COM.MY30_Tue, 5 Feb 2002 14:19:58 +0800489_us-ascii I would like to know if there is any tool that can compare the data restored at the disaster site against the data at production site

Preferable : to compare 2 image copy datasets (disaster site vs production site)

Thank You

================================================ 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. 11055 48 47_Re: Jim Teng's DB2 Tech Conference Presentation14_Peter Backlund21_pbacklu@ATTGLOBAL.NET30_Tue, 5 Feb 2002 07:35:18 +0100 11104 104 23_Re: SQL CODE ERROR -1809_Andy Hunt33_andy.hunt@SCOTTISH-SOUTHERN.CO.UK30_Tue, 5 Feb 2002 08:35:34 +0000490_iso-8859-1



Pedro, I think you are hitting the same problem that we hit. Check to see if you have a name specified before any REDEFINES incorporating W22-DATA-ANO.

If this is blank you get the SQLCODE -180.

UQ60888/PQ53359 resolves the problem.

Kind Regards, Andy Hunt - Scottish And Southern Energy











"PedroSC - Representações e Serviços Unipessoal, Lda." on 05/02/2002 00:14:47 [...] 11209 183 56_Antwort: Re: Jim Teng's DB2 Tech Conference Presentation25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE30_Tue, 5 Feb 2002 09:36:35 +0100433_iso-8859-1 Myles,

the e-mail address for J.Z. (James) Teng is jteng@us.ibm.com.

You can find the e-mail addresses of any IBM employee from the website http://whois.ibm.com/

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 [...] 11393 50 9_CDB reorg13_Raja Ram Balu19_rajaram.balu@BT.COM30_Tue, 5 Feb 2002 11:20:38 -0000392_iso-8859-1 We are currently using CDB Re-org.

After the complete data is loaded I have tried to ALTER the table with COMPRESS YES option.

The RBA usage is as follows

-42024960 -38305792

Space allocation: 780 tracks

I did a CDB Reorg with alloc parameter as USED. The RBA usage is as follows

38338560 15859712

Space allocation: 760 tracks [...] 11444 54 28_Re: Creating SQL statements.14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 6 Feb 2002 09:52:12 +1000477_US-ASCII The best I can think of is to write a REXX routine to do the "Select max (AGENT_IDPK) from WIP_AGENT" bit and construct an alter table from the result.

But I'm not sure I would see that as a very long term solution. I recall seeing a statement that REXX support was stabalised at V5, and might be withdrawn in a future version. As an OS/390 sort of person I couldn't help but notice the irony in that in the OS/390 world REXX support was only added at V5! [...] 11499 18 13_Re: CDB reorg14_Clayton, Colin21_Colin_Clayton@BMC.COM30_Tue, 5 Feb 2002 05:59:03 -0600394_iso-8859-1 Raja Ram,

I'd be interested to know what happens if you run it again (& again).

Perhaps you can get 100% savings !

Colin

================================================ 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. 11518 126 39_Antwort: Re: Antwort: EDM pool shortage25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE30_Tue, 5 Feb 2002 14:04:45 +0100423_iso-8859-1 Marcus,

thank you for your kindness, but now I am confused...

I thought that to be a guru you had to be minimum 5"5' tall - and I definitely do not get to that ;-)

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 [...] 11645 51 54_Re: DPROP on S/390 - CCD tables through Control Center11_rick creech18_ykcirc@HOTMAIL.COM30_Tue, 5 Feb 2002 07:03:26 -0600673_- Hi,

You can download the piece of datajoiner that you need from the ibm website. I recommend that you do so.

Regards,

Rick Creech



>From: "Frank E. Giguere" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DPROP on S/390 - CCD tables through Control Center >Date: Mon, 4 Feb 2002 14:10:13 -0500 > >Hi Everyone, > >I'm looking for anyone with experience creating CCD target tables in S/390 >DPROP. I'm looking to create Complete/non-Condensed CCD tables without any >luck. The manual recommends that you use Data Joiner to create these target >types (which we don't have), and [...] 11697 202 47_Antwort: Re: Closed dataset still held by DBM1?25_Aurora Emanuela Dell'Anno23_Aurora.DellAnno@SSKM.DE30_Tue, 5 Feb 2002 14:19:56 +0100424_iso-8859-1 Another version of QED is actually QUESTION EVERYTHING DONE...

quite appropriate I should think... ;-)))

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 [...] 11900 52 23_Re: JDBC Type 4 Drivers12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Tue, 5 Feb 2002 08:53:45 -0500327_us-ascii > Hi Everyone, I read where IBM will not have Type 4 Drivers until mid-2002.

> Is that still true? Also, could someone explain or point me in the right

> direction where i can find what's the differience between a type 4 driver

> and a type 2? I believe DB2 Version 6/OS390 came as a Type 2. [...] 11953 82 54_Re: DPROP on S/390 - CCD tables through Control Center16_Frank E. Giguere13_giguef@NU.COM30_Tue, 5 Feb 2002 08:51:31 -0500522_us-ascii Rick,

Is this a temporary licensing thing (like 30 or 60 days)?.................

Frank





rick creech cc: (bcc: Frank Giguere/NUS) Subject: Re: DPROP on S/390 - CCD tables through Control Center

02/05/2002 08:03 AM Please respond to DB2 Data Base Discussion List











Hi,

You can download the piece of datajoiner that you need from the ibm website. I recommend that you do so. [...] 12036 21 37_Peoplesoft Student Administration/DB213_Julie Johnson23_Julie.Johnson@UCONN.EDU30_Tue, 5 Feb 2002 08:55:44 -0500496_us-ascii Hi,

If anyone is running Peoplesoft Student Administration and using DB2, could you share the version of DB2 you are running and also the platform you are running on?

Thanks very much!

Julie Johnson University of Connecticut

================================================ 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. 12058 109 54_Re: DPROP on S/390 - CCD tables through Control Center11_rick creech18_ykcirc@HOTMAIL.COM30_Tue, 5 Feb 2002 08:21:54 -0600621_- No, last time I checked it was always free of charge.

Rick



>From: "Frank E. Giguere" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: DPROP on S/390 - CCD tables through Control Center >Date: Tue, 5 Feb 2002 08:51:31 -0500 > >Rick, > >Is this a temporary licensing thing (like 30 or 60 days)?................. > >Frank > > > > rick creech > > cc: (bcc: Frank >Giguere/NUS) > Subject: Re: DPROP on >S/390 - CCD tables through Control > Center > > 02/05/2002 08:03 AM > Please respond to > DB2 [...] 12168 83 28_Re: Creating SQL statements.12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US30_Tue, 5 Feb 2002 08:51:46 -0600585_US-ASCII Try writing your SELECT statement that formats your ALTER statement and then PIPE it to a file. Then execute the file.

Something like this:

Select 'alter table WIP_AGENT alter AGENT_IDPK restart with ('||digits(Select max (AGENT_IDPK) from WIP_AGENT))||';'; >sqlfile.txt

Then execute the sqlfile

db2 -tvf sqlfile.txt -z outfile.txt

Notice the concatenation ( || ) and you must convert numeric fields into characters ( using DIGITS, in this example). If you wanted to generate this statement from the CATALOG, I can help with that also. [...] 12252 90 32_Re: IBM/CDB/BMC Online Reorgs???12_Moulder, Tom19_Tom_Moulder@BMC.COM30_Tue, 5 Feb 2002 08:53:14 -0600476_iso-8859-1 There is no separate Online Reorg Feature. Also, all that is required is the Snapshot Upgrade Feature (a portion of XBM, but not the full product) to go along with Reorg Plus for DB2.

Tom Moulder BMC Software, Inc. my opinions and just so happens my employers this time ...

-----Original Message----- From: Charles Valentin [mailto:VALENCH@AOL.COM] Sent: Monday, February 04, 2002 5:50 PM To: DB2-L@RYCI.COM Subject: IBM/CDB/BMC Online Reorgs??? [...] 12343 40 43_Re: MSSqlserver conversion to DB2 utilities12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US30_Tue, 5 Feb 2002 08:54:44 -0600592_US-ASCII Have you considered DTS, Data Transformation Services?

I believe it is delivered with SQL Server 7 or 2000. It allows the transfer of data from one ODBC source to another ODBC source.

If you don't find it under DTS, then look for Import/Export utility.

doug

>>> rsharpe@AMHERST1.COM 01/30/02 11:14AM >>> Hi

I was wondering if there are any tools from IBM or others that I could use to convert a MSSQLSERVER 2000 database to DB2, my company has finally had it with MS sqlserver and want a real DB. The problem is I have to do this at little or [...] 12384 26 15_alter data type17_ravi kumar hassan18_ravibh@HOTMAIL.COM30_Tue, 5 Feb 2002 08:57:54 -0600328_- Hi Folks,

We are using DB2 V6 on OS390. we have some tables in test region. now they want to change the data type from Decimal to Char & lenght of column in one table. do we have features to alter the data type and length in db2 v6. because i never did this before. if anyone know about the syntax... let me know. [...] 12411 15 34_DB2 Connect ODBC password question9_Don Cross20_Don.Cross@TC.FAA.GOV30_Tue, 5 Feb 2002 10:01:51 -0500305_us-ascii We are running v6 on os390v2.9.

Our users are being prompted several times for their id,password even when opening only one table. We do not want to hardcode user,password in the ODBC driver. Does anyone know what to do so that they only have to type their password once per session? [...] 12427 65 43_Re: MSSqlserver conversion to DB2 utilities15_Sharpe, Richard20_rsharpe@AMHERST1.COM30_Tue, 5 Feb 2002 10:08:11 -0500546_iso-8859-1 Doug

First off THANKS for responding and yes I explored that path and it will be a good one to use to keep the DB2 database in sync with SQLserver until cutover. What I was looking and for and found through a previous email on this list was to use the DB2 migration kit from IBM, it gets the schema (tables, views, indexes) migrated over (note: you need to double check all the column names etc as DB2 has a smaller name limitation on the columns then does SQLserver and will truncate the name) and makes an attempt on the [...] 12493 49 30_Re: Antwort: EDM pool shortage11_Daniel Adam16_dadam@GRATEX.COM30_Tue, 5 Feb 2002 09:11:13 -0600516_- Hi Aurora, thanks for the hints. My comments are below.

On Thu, 31 Jan 2002 11:06:49 +0100, Aurora Emanuela Dell'Anno wrote:

>Daniel, > >With packages, if RELEASE(COMMIT) is used, the the use counts of the DBDs >are decreased by one. If space is needed in the EDM pool, a DBD can be >freed only when its use count reaches zero. Food for thought? We tried our call when there was no activity on the db2. I monitored EDM pool usage and dbd were not causing the problems. [...] 12543 128 13_Re: CDB REORG64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM30_Tue, 5 Feb 2002 09:31:01 -0600488_ISO-8859-1 Hi Raja.

When you use +ALLO(USED) as an allocation strategy, (one of several allocation strategies available) CDB/Auto-Reorg gets the amount of space actually used by the object at the start of the REORG.

For the first run, the actual space must have been less than the current allocation, therefore the allocation values were "downsized". Then, as REORG ran, rows were compressed for the first time. That left the tablespace with an over allocated dataset. [...] 12672 61 19_Re: alter data type11_David Nance16_DWNance@FHSC.COM30_Tue, 5 Feb 2002 10:36:40 -0500608_US-ASCII Kumar, The syntax is pretty straight-forward, its just a little long. It goes something like this:

unload data from table x

drop table x

create table x (cols)

create index for table x

load data to table x

runstats

rebind

>>> ravibh@HOTMAIL.COM 02/05/02 09:57AM >>> Hi Folks,

We are using DB2 V6 on OS390. we have some tables in test region. now they want to change the data type from Decimal to Char & lenght of column in one table. do we have features to alter the data type and length in db2 v6. because i never did this before. [...] 12734 157 19_Re: alter data type16_Bednarz, Michael22_Michael.Bednarz@CA.COM30_Tue, 5 Feb 2002 15:45:14 -0000335_iso-8859-1 Hi Kumar, as far as I know you have to unload the data ; drop the table; create the table with the new columne-format and then load the table.



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 [...] 12892 60 11_Re: Pgsteal17_Vandreese, Tami S27_Tami.Vandreese@LANDSEND.COM30_Tue, 5 Feb 2002 09:48:13 -0600586_iso-8859-1 Thanks for the info. Actually I'm not seeing any specific problems with the bufferpool. We were investigating a longer runtimes with a job after V6 was implemented and I was just reviewing how the buffers were being used. All of the documentation I've found addresses bufferpool usage from the perspective of getting reuse out of the pages, but if nothing is going to remain in the buffer would this advice still hold? I have a memory of being told once long ago that the page stealing algorithm for the VPPSEQT part of the bufferpool used MRU under the assumption that [...] 12953 40 19_Re: alter data type7_DB2 DBA21_db2_dba@BELLSOUTH.NET30_Tue, 5 Feb 2002 10:50:09 -0500534_ISO-8859-1 your syntax will consist of: DROP TABLE...... CREATE TABLE.... > > From: ravi kumar hassan > Date: 2002/02/05 Tue AM 09:57:54 EST > To: DB2-L@RYCI.COM > Subject: alter data type > > Hi Folks, > > We are using DB2 V6 on OS390. we have some tables in test region. now they > want to change the data type from Decimal to Char & lenght of column in one > table. do we have features to alter the data type and length in db2 v6. > because i never did this before. if anyone know about the syntax... let [...] 12994 14 19_Re: alter data type15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Tue, 5 Feb 2002 09:19:20 -0600434_- Kumar

There are no feature in DB2 V6 to accomplish that. You only can increase the length of a varchar-column. Either you do it by hand or you have a third vendor tool to support you.

================================================ 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. 13009 26 93_Re: Is there are any methodology to find out which packages are actually executed by a plan ?12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 5 Feb 2002 09:44:45 -0600559_- Others have made all of the points that I would. Once you do not manage the application structure and choose options we discourage, there is no easy way to fix a broken Humpty-Dumpty. In computer science speak, the problem is NP complete.

On the point about IBM, it appears that you may not understand. I try to help out here on the forum, but this is strictly volunteer work for IBMers. We speak for ourselves, not for IBM. This is not an official work assignment. When I'm travelling or working until I fall asleep at my desk, then this forum [...] 13036 91 26_Re: Data Joiner Connection0_23_sjtoeniskoetter@AEP.COM30_Tue, 5 Feb 2002 11:02:39 -0500306_us-ascii Mark,

You're taking the correct path using UDB as a gateway from DB2 to Datajoiner.

All you need to do to connect UDB to DJ is go into your UDB instance, catalog the node where DJ resides, and catalog the DJ database. Then use the alias name in UDB as the location name in DB2. [...] 13128 106 32_Re: IBM/CDB/BMC Online Reorgs???14_Grainger, Phil20_Phil.Grainger@CA.COM30_Tue, 5 Feb 2002 16:09:06 -0000404_iso-8859-1 Charles,

Not sure whether you'd even appreciate this note, but CA Rapid Reorg also has the "on-line" component bundles in and, unlike BMC there are NO other pieces to buy (and we're still significantly faster than IBM!)

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 [...] 13235 156 19_Re: alter data type14_Grainger, Phil20_Phil.Grainger@CA.COM30_Tue, 5 Feb 2002 16:13:55 -0000436_iso-8859-1 ....and don't forget the GRANTs ....and if you are in a multi table simple tablespace you might want to figure in a REORG as well, ....and of course if the column you are changing is part of a partitioning key, then you have to drop the TABLESPACE as well ....oh, and were there any TRIGGERS on the table, better put them back AND in the right order ....what about LOB columns - do we have to worry about any aux tables [...] 13392 36 38_Re: DB2 Connect ODBC password question12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 5 Feb 2002 08:22:29 -0800571_us-ascii What type of program (s) are you running? Somehow you must be issuing a disconnect to the ODBC driver. This is what forces a reissuance of the password challenge.

Can you explain the process a little fuller? --- Don Cross wrote: > We are running v6 on os390v2.9. > > Our users are being prompted several times for their id,password even > when opening only one table. We do not want to hardcode user,password > in the ODBC driver. > Does anyone know what to do so that they only have to type their > password once per session? [...] 13429 21 23_Re: add_months function12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 5 Feb 2002 09:57:01 -0600505_- A date duration could also be used as a host variable, as in this paste from the SQL Reference:

Date duration A date duration represents a number of years, months, and days expressed as a DECIMAL(8,0) number. To be properly interpreted, the number must have the format yyyymmdd, where yyyy represents the number of years, mm the number of months, and dd the number of days. The result of subtracting one DATE value from another, as in the expression HIREDATE -BIRTHDATE, is a date duration. [...] 13451 63 38_Re: DB2 Connect ODBC password question13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM30_Tue, 5 Feb 2002 10:11:23 -0600414_iso-8859-1 Don, the caching of userid and password is not the function of the ODBC driver. It is up to the application to properly pass the userid and password when calling SQLDriverConnect or SQLConnect. The userid and password must be specified in 1 of 3 ways:

1)Within the ODBC datasource 2)In the connection string when calling SQLDriverCOnnect or SQLConnect. 3) When prompted by SQLDriverConnect. [...] 13515 139 26_Re: Data Joiner Connection12_Mark Buzzard21_Mark_Buzzard@ARIC.COM30_Tue, 5 Feb 2002 10:35:31 -0600522_us-ascii I opened an ETR and recieved the same reply. I am pretty new to DB2/Data Joiner on NT. My background is DB2 OS/390. I created a node on the UDB instance but was getting a security violation SQL30081 when I tried to connect to the DJ database.

I thought it may be because of the DJ being installed with a local admin id. I uninstalled DJ and reinstalled it on the same network admin id that I use for UDB. Now I cannot get either the local or network admin id to work with the DJ database. My start or [...] 13655 28 13_ESS "problem"0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Tue, 5 Feb 2002 10:33:15 -0600567_us-ascii We have just recently moved our DB2 DASD farm to ESS (shark). Performance generally looks good (online transaction elapsed times were reduced by 35%). However, we noticed that whenever a delete is done on large datasets, the elapsed time of the delete is much longer than it was when we were on our previous DASD (RVA) farm. In fact, the time it takes to delete now has a linear relationship with the size of the dataset being deleted! A dataset that is about 1GB takes about 30 to 60 seconds to delete. Our MVS performance people are looking into this [...] 13684 16 30_Re: Antwort: EDM pool shortage10_Max Scarpa16_mscarpa@CESVE.IT30_Tue, 5 Feb 2002 17:47:27 +0100350_us-ascii Any Dynamic Statement caching ?? If yes what MAXKEEPD value ?

Just an idea

Max Scarpa

================================================ 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. 13701 13 23_Re: add_months function12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 5 Feb 2002 10:28:46 -0600369_- I think Andy Hunt may have posted the problem resolution, with APAR PQ53359. One symptom is SQLCODE -180.

Roger Miller

================================================ 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. 13715 13 11_Re: Pgsteal12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 5 Feb 2002 10:32:11 -0600341_- The MRU for sequential access is still there. FIFO is for some unusual cases.

Roger Miller

================================================ 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. 13729 174 32_Re: IBM/CDB/BMC Online Reorgs???17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM30_Tue, 5 Feb 2002 11:20:44 -0600403_iso-8859-1 I'm replying here for clarity ..

The online feature of BMC Software's REORG PLUS for DB2 does NOT require you to buy any additional products!

It DOES utilize the Snapshot Upgrade Feature of our XBM product but this is INCLUDED with REORG PLUS.

/Begin software plug/ And, we are SIGNIFICANTLY faster than IBM and offer features the others do not! /End Software plug/ [...] 13904 77 19_Re: alter data type10_James Kwan19_JamesDB2Kwan@CS.COM28_Tue, 5 Feb 2002 12:23:30 EST364_US-ASCII In a message dated 2/5/02 9:52:04 AM Central Standard Time, DWNance@FHSC.COM writes:



> > Kumar, > The syntax is pretty straight-forward, its just a little long. It goes > something like this: > > unload data from table x > > drop table x > > create table x (cols) > > create index for table x > > load data to table x > > runstats > > [...] 13982 72 73_Re: To compare production data and the data restored at the disaster site10_James Kwan19_JamesDB2Kwan@CS.COM28_Tue, 5 Feb 2002 12:31:39 EST462_US-ASCII Zalina,

I don't know if there is any third party tools that can do that. One way to do that is to unload actual data (from table/from IC) with same key order to a flat file and use compare the content. This is not easy. What I have done in past was to compare the row count for each table. If they matches, we consider they are the same. This might not be the best way to do it, but it is simple. Your shop might have different requirement. [...] 14055 137 26_Re: Data Joiner Connection13_Leo Conchello17_lconche@QWEST.COM30_Tue, 5 Feb 2002 10:32:24 -0700647_us-ascii I don't remember very well DataJoiner 2.1.1 but I believe you can get to a DB2 prompt. The statement you may be looking for is:

GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED,IMPLICIT_SCHEMA,LOAD ON DATABASE TO USER xxxxxxxx

(You must first issue a CONNECT TO yourdatabase USER db2admin USING password)

Hope this helps!

Leo

Mark Buzzard wrote:

> I opened an ETR and recieved the same reply. I am pretty new to DB2/Data > Joiner on NT. My background is DB2 OS/390. I created a node on the UDB > instance but was getting a security violation SQL30081 when I tried to > connect to the [...] 14193 186 104_Please Consider Contributing to searchDatabase.com Forum: "DB2 vs . Oracle: Which is easier on the DBA?"14_Morrill John M26_MorrillJohnM@JOHNDEERE.COM30_Tue, 5 Feb 2002 11:55:35 -0600678_us-ascii Dear DB2 Interested Parties,

This bulletin is to ask you to consider contributing to searchDatabase.com's "DBA Water Cooler" discussion forum topic "DB2 vs. Oracle: Which is easier on the DBA?" at http://www.databasecentral.com/cgi-bin/UltraBoard/UltraBoard.cgi?action=Read &BID=2&TID=1580&SID=19453

Here's the context for the discussion: A recent "independent" study shows Oracle is easier to manage than DB2. The "study", published by Rauch Associates ( http://www.rauchassociates.com/ ), claims to have independently verified the fact that Oracle requires "48% fewer administrative steps" than DB2 and "56% less time" to perform equivalent tasks. [...] 14380 50 93_Re: Is there are any methodology to find out which packages are actually executed by a plan ?14_Peter Backlund21_pbacklu@ATTGLOBAL.NET30_Tue, 5 Feb 2002 19:11:47 +0100 14431 83 19_Re: alter data type64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM30_Tue, 5 Feb 2002 12:42:26 -0600740_ISO-8859-1 With CDB/Auto-Convert:

ALTER TABLE creator.tablename (DECIMAL_COL CHAR(newlength) )

I wonder why CA wrote RC/Migrator and BMC wrote DB2/Alter too! :-)

Todd.

-----Original Message----- From: Phil.Grainger@CA.COM Sent: Tuesday, February 05, 2002 10:35 AM To: DB2-L@RYCI.COM Subject: Re: alter data type -------------------------------------------------------------------------- -- .....and don't forget the GRANTs .....and if you are in a multi table simple tablespace you might want to figure in a REORG as well, .....and of course if the column you are changing is part of a partitioning key, then you have to drop the TABLESPACE as well .....oh, and were there any TRIGGERS on the table, better [...] 14515 37 18_RRSAF implications12_Henry Daries23_Henry.Daries@BCBSKS.COM30_Tue, 5 Feb 2002 12:53:00 -0500393_- Hi Listers.

I have followed the dialogue about Stored Procedures and WLM. As I understand it from previous postings, one must use RRSAF to run Stored Procedures dynamically. When I mentioned the need for RRS to our MVS Systems person he said that "there are what appear to be significant recovery opportunties with the SYSLOGGER " if we do this and warned me to tread carefully. [...] 14553 14 38_Re: DB2 Connect ODBC password question9_Don Cross20_Don.Cross@TC.FAA.GOV30_Tue, 5 Feb 2002 14:30:59 -0500351_us-ascii Myron,Andy

We are running an MSACCESS forms front end connecting to DB2 as an external table.

================================================ 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. 14568 39 28_automatic: SET CURRENT SQLID24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM30_Tue, 5 Feb 2002 14:20:55 -0600462_- We wanted to automatically SET CURRENT SQLID for a set of users to the same SQLID (by LPAR).

We were considering changing the DSN3@ATH exit so that after calling the ACF2/RACF exit, which returns secondary authid's, we could automatically determine what the CURRENT SQLID should be set to (depending on the secondary authid list ACF2 returned). Thus, security would still do the security function without us having to modify the exit continuously. [...] 14608 86 19_Re: alter data type10_James Kwan19_JamesDB2Kwan@CS.COM28_Tue, 5 Feb 2002 15:43:04 EST582_US-ASCII Another interesting point is if your table has an identity column, depending on how you define the identity column, you might not be able to reload the same value back.

In a message dated 2/5/02 1:31:43 PM Central Standard Time, tburch@CDBSOFTWARE.COM writes:



> .....and don't forget the GRANTs > .....and if you are in a multi table simple tablespace you might want to > figure in a REORG as well, > .....and of course if the column you are changing is part of a > partitioning > key, then you have to drop the TABLESPACE as well > .....oh, and [...] 14695 66 32_Re: High CPU in DBM1, CICS waits13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM30_Tue, 5 Feb 2002 14:58:16 -0600600_iso-8859-1 Well I have been doing more investigation. According, NODETAIL will keep the in storage Type30 subtype4 and subtype5 records from being created, however, this causes the subtype2 and subtype3 records to be written out at each interval. If these two records types are produced for each unit of work, and with an average of 5,000 open datasets in DB2, then we would have approx. 10,000 of these records written out from DB2 at the end of each interval. Sounds like another bottleneck for everything else in the system trying to write out their SMF records. Also, it is my understanding [...] 14762 23 11_Weird -913s14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Tue, 5 Feb 2002 16:06:16 -0500536_iso-8859-1 We have a java servlet program running on AIX (db2 v7.2 connect) and executing a stored procedure on os/390. Right after executing the stored procedure, the java program checks the output variables, one of which is the sqlcode of the last SQL statement in the stored procedure. The sqlcode as seen by the java program is -913. However, I do not see any evidence of -913 or -911 on the db2 master log or TMON Deadlock/Timeout error. Is it possible for DB2 to throw -913 and not put DSNT376I / DSNT501I in the master log? [...] 14786 119 32_Re: automatic: SET CURRENT SQLID10_James Kwan19_JamesDB2Kwan@CS.COM28_Tue, 5 Feb 2002 16:22:48 EST537_US-ASCII Richard,

I am not sure I understand what you want to 100%, but it seems your approach should work. If you want to prefix with Lpar id to distinguish the proper 2nd authid, why not just use A$ABC,,, instead of ABC, XYZ? I see no purpose of keeping 2 sets of authids. For normal user, they will always use their own id eg NORM anyway. Normal user probably does need 2nd authids. Another point is what happened if there are more than 1 subsystem you want to assess in 1 LPAR? How do you determine which one to use? Who [...] 14906 111 22_Re: RRSAF implications0_16_khampto1@TXU.COM30_Tue, 5 Feb 2002 15:25:29 -0600504_us-ascii Hello Henry, I don't quite follow your comment about running stored procedures "dynamically". Unless you mean by this that the address spaces where your stored procedures are executed, are managed dynamically by WLM. What exactly do you mean by applications folk using stored procedures dynamically ? What release of OS/390 are you running there? I assume, of course, that you are not really still running MVS, since you are on DB2 V6, and the minimum required was, I believe, OS/390 v1.3. [...] 15018 25 41_Recover tablespace with IC not in SYSCOPY11_jim keister22_jkeister@ALTAVISTA.NET30_Tue, 5 Feb 2002 16:32:48 -0500244_iso-8859-1 I would like to recover a V6 tablespace using an image copy that is not registered in SYSIBM.SYSCOPY but is cataloged in MVS.

I tried the TOCOPY option, but that now appears to also access SYSCOPY.

Any recommendations?? 15044 30 5_Shark9_Euf Rosal18_eufrosal@YAHOO.COM30_Tue, 5 Feb 2002 13:40:44 -0800508_us-ascii My shop is planning to install Sharks Disk Array using striping. Many of our tables are partitioned. I am wondering if striping will negate the benefit of partitioning. Or, I'd appreciate it if some have implementation experience that they can share. Thank you.







===== Euf Rosal System Administrator Synergy Corp.

__________________________________________________ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com [...] 15075 83 49_SQL stored procedures with list of IN parameters.0_24_db46@DAIMLERCHRYSLER.COM30_Tue, 5 Feb 2002 16:55:54 -0500341_us-ascii Here is a JAVA stored procedure that we would like to change into an SQL stored procedure. The problem is that the 'IN' clause can be variable. Is there an easy way to do this in an SQL SP?

Dean

/** * JDBC Stored Procedure VSW.spAuthConfirm */ package com.dcx.tcc.vs.sp;

import java.sql.*; // JDBC classes [...] 15159 93 45_Re: Recover tablespace with IC not in SYSCOPY14_Wayne Driscoll24_wayne.driscoll@QUEST.COM30_Tue, 5 Feb 2002 14:03:10 -0800402_iso-8859-1 Recover requires that the IC be registered. If not, look at DSN1COPY. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

-----Original Message----- From: jim keister [mailto:jkeister@ALTAVISTA.NET] Sent: Tuesday, February 05, 2002 3:33 PM To: DB2-L@RYCI.COM Subject: [DB2-L] Recover tablespace with IC not in SYSCOPY [...] 15253 36 45_Re: Recover tablespace with IC not in SYSCOPY19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Tue, 5 Feb 2002 22:06:37 +0000715_- DSN1COPY !!!

Recovery TOCOPY always referred to SYSCOPY AFAIR ?

Phil

On Tue, 2002-02-05 at 21:32, jim keister wrote: > I would like to recover a V6 tablespace using an image copy that is not registered in SYSIBM.SYSCOPY but is cataloged in MVS. > > I tried the TOCOPY option, but that now appears to also access SYSCOPY. > > Any recommendations?? > -- > > _______________________________________________ > Sign-up for your own FREE Personalized E-mail at Mail.com > http://www.mail.com/?sr=signup > > Win a ski trip! > http://www.nowcode.com/register.asp?affiliate=1net2phone3a > > ================================================ > To change your subscription options or to cancel your [...] 15290 61 45_Re: Recover tablespace with IC not in SYSCOPY0_19_Tim.Lowe@STPAUL.COM30_Tue, 5 Feb 2002 16:08:49 -0600415_us-ascii Jim, You need to use DSN1COPY in that case. The recover utility has always required the copy to be in sysibm.syscopy.







jim keister cc: Sent by: DB2 Subject: Recover tablespace with IC not in Data Base SYSCOPY Discussion List



02/05/2002 03:32 PM Please respond to DB2 Data Base Discussion List [...] 15352 132 22_Re: RRSAF implications15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Tue, 5 Feb 2002 17:14:43 -0500444_- Thanks , Kirk Hampton . You are right on the point regarding the mainframe. IBM is trying to change the mainframe, but peoples who are supporting the mainframe is not ready to change.

Thanks..sibi All opinion's are mine, not my employer's





-----Original Message----- From: khampto1@TXU.COM [mailto:khampto1@TXU.COM] Sent: Tuesday, February 05, 2002 3:25 PM To: DB2-L@RYCI.COM Subject: Re: RRSAF implications [...] 15485 27 45_Re: Recover tablespace with IC not in SYSCOPY0_22_Rohn.Solecki@MTS.MB.CA30_Tue, 5 Feb 2002 16:15:08 -0600462_us-ascii Have you considered at DSN1COPY. It should do the trick for you.











jim keister @RYCI.COM> on 2002/02/05 03:32:48 PM Subject: Recover tablespace with IC not in SYSCOPY

I would like to recover a V6 tablespace using an image copy that is not registered in SYSIBM.SYSCOPY but is cataloged in MVS.

I tried the TOCOPY option, but that now appears to also access SYSCOPY. [...] 15513 125 32_Re: automatic: SET CURRENT SQLID24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM30_Tue, 5 Feb 2002 16:25:31 -0600543_iso-8859-1 Hi James,

First, thanks for your comments! I'll try to elaborate a bit.

1) "If you want to prefix with Lpar id to distinguish the proper 2nd authid, why not just use A$ABC,,, instead of ABC, XYZ? I see no purpose of keeping 2 sets of authids." ===> Note: the intent is for the exit to strip the A$, B$, etc off any 2nd'ry authid's; so only ACF2 and the exit will see the fake authid's. DB2 should only see the secondary authid's like ABC, XYZ and the exit will use the prefix to identify which, if any, should be [...] 15639 49 45_Re: Recover tablespace with IC not in SYSCOPY13_LOMBARD,Shaun25_shaun.lombard@DEWR.GOV.AU30_Wed, 6 Feb 2002 09:30:15 +1100458_iso-8859-1 DSN1COPY is your only option.

-----Original Message----- From: jim keister [mailto:jkeister@ALTAVISTA.NET] Sent: Wednesday, 6 February 2002 8:33 To: DB2-L@RYCI.COM Subject: Recover tablespace with IC not in SYSCOPY



I would like to recover a V6 tablespace using an image copy that is not registered in SYSIBM.SYSCOPY but is cataloged in MVS.

I tried the TOCOPY option, but that now appears to also access SYSCOPY. [...] 15689 66 32_Re: automatic: SET CURRENT SQLID14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 6 Feb 2002 20:30:26 +1000412_US-ASCII Richard

Well, I once did this sort of processing (although on a RACF system). So I know it works. Logically.

As James Kwan said, the problem is in managing your name space. I presume that you don't have RACF's problem in having people connected to more than 254 secondary-ids. How many DB2 subsystems do you expect to manage - because you're limited to 26 (29?) with your convention. [...] 15756 125 38_Re: DB2 Connect ODBC password question13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM30_Tue, 5 Feb 2002 16:17:49 -0600459_iso-8859-1 Don, you may find this information useful which is from the Jet Database Engine version 3.0 ODBC Connectivity White Paper.

Connection Sharing Jet multiplexes ODBC connections internally as much as possible. After accounting for transaction effects and active statement limits (as described above), Jet shares connections based on connect strings. Two connect strings are considered equal only if both of the following criteria are met: [...] 15882 45 46_Re: Recover table space with IC not in SYSCOPY15_Murley, Michael22_Michael_Murley@BMC.COM30_Tue, 5 Feb 2002 17:07:41 -0600295_iso-8859-1 If you just want to restore the space to that copy, you can use DSN1COPY, as others have already suggested. If the copy has been modified off of SYSIBM.SYSCOPY and you want to use it to recover and apply log, I think you'll need an ISV recover utility.

Michael Murley BMC [...] 15928 226 94_Re: Is there are any methodology to find out which packages are a ctually executed by a plan ?13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU30_Wed, 6 Feb 2002 10:14:42 +1100384_iso-8859-1 I too would like to add my support for Roger and and any other colleagues who chip in. The selfless attitude shown by RM is a practice we all would do well to emulate.

And....

I have noticed, of late, that there are more messages worded with the assumption that this is an IBM sponsored forum. Many of these postings seem to be from new converts to DB2. [...] 16155 30 105_what system catalog will be accessed if executing SELECT and DELETE on a user table in DB2 for OS/390 V6?12_Xiaoxia Liao27_xiaoxia.liao@WEBMETHODS.COM30_Tue, 5 Feb 2002 15:27:56 -0800566_iso-8859-1 Hello:

I am new to DB2 on OS/390. I have read lot of valuable information from this forum which helps me on my work. Thanks.

We wrote a JDBC application to access DB2 using IBM application driver - COM.ibm.db2.jdbc.app.DB2Driver. I don't know how to answer a question that comes from user. The user was asking what DB2 system catalog would be accessed when the JDBC application executing SELECT and DELETE statements using JDBC connection which has underline database default transaction isolation level, REPEATABLE READ in their case. [...] 16186 111 32_Re: automatic: SET CURRENT SQLID24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM30_Tue, 5 Feb 2002 17:46:33 -0600441_iso-8859-1 You're right James,

I really need more information and justification for this request. At this point all I've been looking at is "could this be done"; and that answer seems to be yes. But the question of whether this exit should be written at all or whether there are better ways of handling this are unknown to me at this point. I'm hoping to talk to the requestor Thursday so I can find out what's driving this too. [...] 16298 61 25_DB2 mainframe differences11_Grant Allen22_grant@TOWERSOFT.COM.AU30_Wed, 6 Feb 2002 10:47:07 +1100563_iso-8859-1 Hi all,

I'm struggling with the "DB2 is not DB2" kind of problems, running an app designed for DB2 UDB for "all the other platforms" pointing to mainframe DB2.

First, when altering a table to add a primary key, it complained that there was no unique index on the column. DB2 on all other platforms implicitly creates this when the PK is defined. Am I right that the os390 version doesn't, so I'll need to handle this before PK declaration (I know it's bad practice to rely on these being in place, but this is a case of working with [...] 16360 56 45_Re: Recover tablespace with IC not in SYSCOPY14_Andy Lankester33_andy.lankester@FR.CDBSOFTWARE.COM30_Tue, 5 Feb 2002 23:55:14 -0000340_us-ascii As has been said - DSN1COPY. BUT:

Must be a FULL, SHRLEVEL REF copy.

Tspace must not have been DROPped/reCREATEd since the IC unless you have been very careful and retained the exact same OBIDs. ALTER TABLEs should not be a problem (I think - shoot me down!)

Good luck!

Andy Lankester CDB Software [...] 16417 34 45_Re: Recover tablespace with IC not in SYSCOPY10_Linda Ball18_linda_ball@BMC.COM30_Tue, 5 Feb 2002 17:21:00 -0600569_- One good question to ask is: why isn't the copy in SYSCOPY? Simply a MODIFY victim or was the table space dropped? Or did the copy never belong to the space but is really a copy of a similarly defined space?

Some RECOVER utilities (BMC's RECOVER PLUS, for example) may be able to use an unregistered copy. (INCOPY is the parameter in RECOVER PLUS.) However, if the copy is not is SYSCOPY because the table space was dropped, you might also need conversion of IDs (which RECOVER PLUS has). (RECOVER PLUS has a DROP RECOVERY [...] 16452 164 32_Re: automatic: SET CURRENT SQLID12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 5 Feb 2002 16:19:26 -0800628_us-ascii I agree with James as to why you really need to do this. Certainly, its technically possible. But? And are you considering the impacts of implimentation of using external security for DB2 rather than DB2s internal security. Many shops are using RACF or ACF2 for the security checking rather than DB2 to have all the security administration in one place and simplify that administration. What happens to this exit if your shop decides to do this? --- "Humphris,Richard P.(NXI)" wrote: > You're right James, > > I really need more information and justification for this request. > At this [...] 16617 51 23_Re: JDBC Type 4 Drivers13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 5 Feb 2002 19:02:33 -0600585_us-ascii Jeff,

Yes, mid-2002 is the aim (as far as I understand).

And try http://java.sun.com/products/jdbc/driverdesc.html. It explains the differences between the drivers.

Regards Terry Purcell Yevich Lawson & Assoc Inc (YL&A) IBM Gold Consultant - DB2 IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 http://www.ylassoc.com

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Jeff Frazier Sent: Tuesday, February 05, 2002 7:54 AM To: DB2-L@RYCI.COM Subject: Re: JDBC Type 4 Drivers [...] 16669 156 46_2nd Notice: SIRDUG Meeting February 15th, 200211_Paul Turpin32_pault@ALUMMAIL.SSB.ROCHESTER.EDU30_Tue, 5 Feb 2002 20:20:37 -0600594_- SIRDUG Meeting February 15th, 2002

Featuring: Robert Catterall - IDUG Speaker's Hall of Fame

SIRDUG is very pleased to announce that the first 2002 SIRDUG meeting on February 15th will feature Robert Catterall of Check Free. Robert will be joined by Dan Alion of Check Solutions, and our president Paul Turpin of Wachovia in an all "User" speakers meeting. After receiving the IDUG Speaker's Hall of Fame award as an IBMer, Robert now works for Check Free, and so he now qualifies as a User Speaker. Robert, Dan and Paul will give us a preview of their 2002 North American [...] 16826 118 32_Re: automatic: SET CURRENT SQLID10_James Kwan19_JamesDB2Kwan@CS.COM28_Wed, 6 Feb 2002 00:59:21 EST593_US-ASCII Richard and James,

I do see some benefit for using this method to manage security. Lets assume L1 is production and L2 is development. With proper package list, you can logically pass all security management to RACF/ACF2 people by using second authid. You JCL or RCT does not have to change from 1 environment to other environment because they are identical (supposely). If the exit is coded to stripe only the first few chars, then they don't even have to main this code. (Provide they only have 26 Lpar). Richard, I would recomment you to review your other db2 security [...] 16945 15 94_Re: Is there are any methodology to find out which packages are a ctually executed by a plan ?12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 5 Feb 2002 23:36:56 -0600469_- I'm sorry for my words. They were sharper than I wanted, and more a reflection of the long hours and another mistake I made earlier. When the half days (12 hours) are not enough, we need to work full days.

Roger Miller

================================================ 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. 16961 27 30_Re: Antwort: EDM pool shortage11_Daniel Adam16_dadam@GRATEX.COM30_Wed, 6 Feb 2002 01:15:33 -0600531_- Hi Max, no dynamic statements. Our EDM is definitely full of package tables. Thanks for the thought... D.

On Tue, 5 Feb 2002 17:47:27 +0100, Max Scarpa wrote:

>Any Dynamic Statement caching ?? If yes what MAXKEEPD value ? > >Just an idea > >Max Scarpa > >================================================ >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. [...] 16989 20 23_Re: JDBC Type 4 Drivers10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 6 Feb 2002 08:51:55 +0100454_us-ascii According Maryela Weihrauch (IBM Java expert from IBM SV Lab) new Type 4 drivers will be available this year,

probably in may or a little bit late.

HTH

Max Scarpa Useless DB2 sysprog

================================================ 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. 17010 69 19_Re: alter data type10_Ali OZTURK27_Ali.OZTURK@PAMUKBANK.COM.TR30_Wed, 6 Feb 2002 10:09:00 +0200637_iso-8859-9 Hi Kumar, You don't do it like this. But there is a easy way to changing data model for this case (if there is no more rows in the table),

1.create another table same as the original table as follows , CREATE TABLE XCPY.table_name LIKE XXXX.table_name; 2. Insert all rows from original table to new table using insert statement, INSERT INTO XCPY.table_name SELECT * FROM XXXX.table_name; 3. do table column change for original table (drop / create) 4. insert all frow from the copied table (created in first step) to newly created table. INSERT INTO XXX.table_name SELECT COL1,COL2,COL3,... DIGITS(COL4), changing [...] 17080 25 17_Re: ESS "problem"10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 6 Feb 2002 09:37:10 +0100329_us-ascii Hi

It happened to me many years ago to find software enqueue on an ICF catalog. In that case we enlarge catalog buffer

but files were VSAM file.

Is your catalog shared among systems ? How many alias point to that catalog ? Is PAV enabled in your ESS ?

Is VVDS ok ? Is catalog index ok ? [...] 17106 26 35_Image copy dataets and there format19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Wed, 6 Feb 2002 10:13:53 +0100263_iso-8859-1 Dear List,

Could somebody please tell me where I can find a description of the layout of an image copy file.

Even better would be the actual file layout. I am particularly interested in the dbid,psid and the obid.

Thanks in advance 17133 19 30_Re: Antwort: EDM pool shortage10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 6 Feb 2002 11:34:15 +0100471_us-ascii ........I'm afraid (if u have EDM POOL FULL events) the only way is to enlarge your EDM pool, trying to test EDM pool

recent enhancements (EDMBFIT) and cleaning up your DBDs running MODIFY

Regard

Max

================================================ 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. 17153 66 45_Help with NT security authentication (resend)19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Wed, 6 Feb 2002 11:28:51 +0000368_- I sent the following on Christmas Eve : I guess I was the only person reading DB2 newsgroups over the festive period. So I'm resending.

==============================================

I'm needing help with getting users able to access a DB2 for NT V5.2 server we're setting up (yes I know it is ancient / out-of-support but we have a good reason). [...] 17220 68 45_Re: Recover tablespace with IC not in SYSCOPY14_Marilyn Millar31_marilyn.millar@SOMERFIELD.CO.UK30_Wed, 6 Feb 2002 11:27:20 -0000436_iso-8859-1 Hi Jim,

run an image copy against the tspace to create unwanted dsn. Copy the former dsn to this one. Catalog and MVS now match.

Recover tocopy works a treat on version 5 !

HTH,

Marilyn

Somerfield plc.

-----Original Message----- From: jim keister [mailto:jkeister@ALTAVISTA.NET] Sent: 05 February 2002 21:33 To: DB2-L@RYCI.COM Subject: Recover tablespace with IC not in SYSCOPY [...] 17289 35 25_DBM1 Storage Rexx - Stats23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 6 Feb 2002 11:44:16 -0000330_iso-8859-1 Everyone that requested the storage rexx should have long (two or three weeks ago) had it by now..

Some stats on the feedback I got are :

1. 56 copies of the rexx sent out

2. Two mails of thanks for sending it out were received by me

3. Three people returned data from their runs of it [...] 17325 46 14_DB2 Connect EE18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM30_Wed, 6 Feb 2002 07:28:08 -0500356_iso-8859-1 For my general knowledge I'm trying to get a grasp on how this DB2 Connect Versions & Fixpacks work and was wondering if anyone out there might be able help shed some light on this for me. (We're currently at DB2 Version 6 OS/390). First here is the setup that we have with DB2 Connect (and don't yell 'cause I didn't create this monster). [...] 17372 93 29_Re: DB2 mainframe differences19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Wed, 6 Feb 2002 12:35:44 +0000557_- Grant,

Answers after your questions.

Phil Nelson ScotDB Limited

On Tue, 2002-02-05 at 23:47, Grant Allen wrote: > Hi all, > > I'm struggling with the "DB2 is not DB2" kind of problems, running an app > designed for DB2 UDB for "all the other platforms" pointing to mainframe > DB2. > > First, when altering a table to add a primary key, it complained that there > was no unique index on the column. DB2 on all other platforms implicitly > creates this when the PK is defined. Am I right that the os390 version > doesn't, so I'll [...] 17466 37 68_Migrating to DB2v6 or 7, do all plans & packages need to be rebound?11_Linda Ayeni22_lindaayeni@HOTMAIL.COM30_Wed, 6 Feb 2002 05:47:15 -0700423_- Hi Listers,

I have a discussion(eh, wager, I get to massage my colleague's shoulder during lunch and in our cafeteria!) with a colleague that after migration, it is not necessary to rebind all plans/packages unless they are invalidated for one reason or another(my considered opinion). My colleague says, yeah we have to. Could any share some light on the migration concerns as it affects Plans and packages. [...] 17504 117 29_Re: DB2 mainframe differences13_BL.Tink Tysor16_tink@BLTYSOR.COM30_Wed, 6 Feb 2002 04:47:26 -0800290_us-ascii Grant,

As you found out, DB2 UDB for z/OS & OS/390 does not automatically create a unique index when you alter a table to define a primary key. All you need to do is follow the alter with a create unique index on the primary key fields, and every thing should be fine. [...] 17622 24 23_Re: JDBC Type 4 Drivers12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Wed, 6 Feb 2002 07:48:22 -050029_us-ascii Thanks Max for info. 17647 100 18_Re: DB2 Connect EE12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 6 Feb 2002 05:03:30 -0800542_us-ascii Stephen, First off, I'd strongly suggest you upgrade your Version 5 DB2 Connect versions. That version has gone off support completely. And V6 will be going this year.

That said, unfortunately you must get a different Fixpack for each version. I don't know what the current fixpack is for V5 (around 15 or 16 I think, but not sure). But each version has its on complete set of fixpacks. Remember that each version has a totally different code base, so it would be logical that fixes to that code base would be different. [...] 17748 17 68_Sqlcode -101, anyone has war stories to share on ways to resolve it?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM30_Wed, 6 Feb 2002 08:05:31 -0500 17766 108 53_Re: SQL stored procedures with list of IN parameters.12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 6 Feb 2002 05:08:30 -0800539_us-ascii Do a prepare before the statement. Then you can have the IN clause be a variable. In other words, make the SQL statement a true dynamic sql statement. Then it works fine. --- db46@DAIMLERCHRYSLER.COM wrote: > Here is a JAVA stored procedure that we would like to change into an > SQL > stored procedure. The problem is that the 'IN' clause can be > variable. Is > there an easy way to do this in an SQL SP? > > Dean > > /** > * JDBC Stored Procedure VSW.spAuthConfirm > */ > package com.dcx.tcc.vs.sp; > > import java.sql.*; [...] 17875 75 18_Re: DB2 Connect EE12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Wed, 6 Feb 2002 07:06:22 -0600553_iso-8859-1 Question 1: If I'm looking at Fixpacks do I need to look at the fixpacks for EACH of these Versions? YES

Question 2: How can I tell before hand what fixpack may or may not have been installed? Enter from the command line (on each system) the command: db2level

Question 3: Lets take DB2 Connect V6.1 for Windows. There is Fixpack 10 out there now. Does that mean if I install fixpack 10 that I will get all the other V6.1 fixpacks included in '10'? ie; Fixpacks 1 thru 9. YES But sometimes for example it won't work -- like [...] 17951 67 18_Re: DB2 Connect EE14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 7 Feb 2002 11:19:53 +1000526_US-ASCII Steve

- Each fixpak is for a specific version - Mostly fixpaks are cumulative, but not always. For example, in V7, fixpak 3 includes all prior fixpaks, but fp4 and later do not include fp3. FP3 brings V7.1 up to V7.2 - with a few ommissions. Consequently before applying fp4 or later, you need V7.1 with fp 3, or V7.2. Details are included in the FixpakReadme included with each (at east the ones I've seen) fixpak. - The FixpakReadme also includes details on how to determine the current version/fixpak. [...] 18019 54 73_Re: To compare production data and the data restored at the disaster site14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 7 Feb 2002 11:19:56 +1000350_US-ASCII James

I've got to say that comparing row counts is not what I would call "rigerous". If all you want to do is compare tables, I would unload them and generate a suitable check sum. Provides some confidence that the contents of the rows are the same.

James Campbell



On 5 Feb 2002 at 12:31, James Kwan wrote: [...] 18074 37 39_Re: Image copy dataets and there format14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 7 Feb 2002 11:19:57 +1000473_US-ASCII Neil

I've always assumed it is a series of 4kb records, each one corresponding to a 4kb page (or part of a page if the pagesize is greater than 4kb). The only thing is that the sequence of records is not necessarily page 0, page 1, page 2 etc. Hence you need to look at the page number in the page header to know which page the record corresponds to. If this is true, the format is documented in the diagnosis guide where it documents the page format. [...] 18112 91 32_Re: automatic: SET CURRENT SQLID14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 7 Feb 2002 11:19:59 +1000605_US-ASCII James

This is exactly the thinking that led me to create the implementation I did. In my defence, this predated BIND QUALIFIER and ALIASes. Fortunately for my reputation the business and its systems no longer exist. (Long story, but was driven by non-IT considerations.)

Having been on both sides, I am now convinced that it is far better to manage qualifiers in a "proper" manner as part of standard migration. If for no other reasons than: - it is common to have two congruet systems/clones living in the same subsystem. Therefore you need to manage, say, dev and test names [...] 18204 52 7_Re: SAP23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 6 Feb 2002 13:46:31 -0000594_- Hi

do you have IBM helping you at all?

I can help but it would take me a year to type everything we have done .. how about I do it offline ?

Les

-----Original Message----- From: Toni LeTempt [mailto:tletemp@OIR.STATE.SC.US] Sent: Friday, February 01, 2002 8:13 PM To: DB2-L@RYCI.COM Subject: SAP



We are in the process of implementing a three tier SAP R/3 4.6c system using AIX for the application and DB2 OS390 v 6 for the database. We are just about to bring up development. This is my first exposure to SAP. I was wondering if anyone had any [...] 18257 19 24_FYI Software withdrawals14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 7 Feb 2002 11:49:49 +1000487_US-ASCII http://www.ibmlink.ibm.com/usalets&parms=H_902-013 announces the withdrawal of several DB2 related products/versions.

Also includes service withdrawal of OS/390 V2.9 from 31 March 2003. Bye bye G4 and below.

James Campbell

================================================ 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. 18277 65 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Feb 2002 08:55:12 -0500348_iso-8859-1 It is not officially 'necessary' to rebind. However, we had so many unexpected SQL errors that we did rebind all packages. The unexpected SQL errors went away.

I am very thankful that I do not work in a shop which uses only two plans. I have never encountered, nor do I expect to, any valid explanation for such foolishness. [...] 18343 43 18_Re: DB2 Connect EE17_Walter Trovijo Jr18_wtrovijo@IG.COM.BR30_Wed, 6 Feb 2002 11:55:22 -0300509_iso-8859-1 Stephen,

> Question 1: If I'm looking at Fixpacks do I need to look at the fixpacks for > EACH of these Versions? And if so does > that mean that I have to install separate Fixpacks for each Version? YES and YES.

> Question 2: How can I tell before hand what fixpack may or may not have been > installed? (Is that possible). Look at readme.txt file under sqllib/bin direcotry. The file header will show fixpack level. Fixpack level info is also recorded in the windows registry. [...] 18387 56 72_Re: Sqlcode -101, anyone has war stories to share on ways to resolve it?15_Fred Occhipinti23_Fred_Occhipinti@FPL.COM30_Wed, 6 Feb 2002 09:00:48 -0500489_us-ascii Carlton: I am no guru, but have dealt with the -101 problem. If someone knows if there is an APAR let us know. Basically a rebind of the package or plan will resolve the -101 problem. No rewrites are necessary. Best Regards, Fred Occhipinti







"Carlton Enuda" cc: Sent by: "DB2 Subject: Sqlcode -101, anyone has war stories Data Base to share on ways to resolve it? Discussion List" [...] 18444 31 22_Compaq servers and DB215_Sharpe, Richard20_rsharpe@AMHERST1.COM30_Wed, 6 Feb 2002 09:05:15 -0500357_iso-8859-1 Hi I was wondering if anyone has any opinions and experience on 2 Compaq servers that my company is considering of using 1. Compaq Prolient 8500 (8 Way with 8 gig memory) and 2. Compaq DL 580 (4 way with 4gig memory). I am mainly interested in how these perform with DB2 Enterprise Edition and if there are any problems or plus's with them. [...] 18476 13 39_Re: Image copy dataets and there format17_Walter Trovijo Jr18_wtrovijo@IG.COM.BR30_Wed, 6 Feb 2002 11:57:11 -0300295_iso-8859-1 It´s all on Diagnosis guide and reference.

================================================ 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. 18490 48 45_Re: Recover tablespace with IC not in SYSCOPY0_25_Ed_Vetock@NAVYFEDERAL.ORG30_Wed, 6 Feb 2002 09:22:24 -0500526_us-ascii You'll have to use DSN1COPY utility







jim keister @RYCI.COM> on 02/05/2002 04:32:48 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Recover tablespace with IC not in SYSCOPY



I would like to recover a V6 tablespace using an image copy that is not registered in SYSIBM.SYSCOPY but is cataloged in MVS. [...] 18539 167 53_Re: SQL stored procedures with list of IN parameters.0_24_db46@DAIMLERCHRYSLER.COM30_Wed, 6 Feb 2002 09:47:00 -0500386_us-ascii Yes, we came up with using a prepare statement.

But the result is really extra work. The reason to use SQL stored procedures is because it ends up being 'static' SQL (SQL code is changed into C code and compiled and bound). So using prepared statements should really be put back into the 'normal' Java code for an application in some common DB level utility level. [...] 18707 98 32_Re: automatic: SET CURRENT SQLID10_James Kwan19_JamesDB2Kwan@CS.COM28_Wed, 6 Feb 2002 09:49:36 EST649_US-ASCII James,

I fully agree with your comments. There are many different ways to approach this. All I want to say is he should fully review the whole strategy before jump into the new implementations.

James Kwan

IBM Certified Solutions Expert...

In a message dated 2/6/02 7:55:36 AM Central Standard Time, jacampbell@ACSLINK.NET.AU writes:



> James > > This is exactly the thinking that led me to create the implementation > I did. In my defence, this predated BIND QUALIFIER and ALIASes. > Fortunately for my reputation the business and its systems no > longer exist. (Long story, but was driven by [...] 18806 39 39_Re: Image copy dataets and there format19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Wed, 6 Feb 2002 15:56:00 +0100552_iso-8859-1 I have looked in there, please give me the page number?

many thanks Neil

-----Original Message----- From: Walter Trovijo Jr [mailto:wtrovijo@IG.COM.BR] Sent: Wednesday, February 06, 2002 3:57 PM To: DB2-L@RYCI.COM Subject: Re: Image copy dataets and there format



It´s all on Diagnosis guide and reference.

================================================ 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 18846 83 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?13_Ealey, Paul M18_paul.ealey@EDS.COM30_Wed, 6 Feb 2002 15:09:40 -0000406_iso-8859-1 I'd be grateful to learn what exactly people think the drawbacks are of this minimalist approach to Plans. It might help us to shape future strategy.

Thanks Paul

-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: 06 February 2002 13:55 To: DB2-L@RYCI.COM Subject: Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound? [...] 18930 71 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Wed, 6 Feb 2002 09:11:00 -0500455_- We migrated from V5 to V6 and did not have to rebind.

>>> DB2 Data Base Discussion List 02/06/02 07:51AM >>> It is not officially 'necessary' to rebind. However, we had so many unexpected SQL errors that we did rebind all packages. The unexpected SQL errors went away.

I am very thankful that I do not work in a shop which uses only two plans. I have never encountered, nor do I expect to, any valid explanation for such foolishness. [...] 19002 46 94_Re: Is there are any methodology to find out which packages are a ctually executed by a plan ?12_Gross, Chuck18_cgross@MILL-IS.COM30_Wed, 6 Feb 2002 10:19:24 -0500561_us-ascii Roger,

I for one (and I am sure the whole group agrees) look forward to your sage advice. Thanks for putting forth the effort.

Warm Regards, Chuck Gross Director; Database Services MillenniuM Information Systems Email: cgross@mill-is.com Work: 703-341-1428 Cell: 614-323-4279



-----Original Message----- From: Roger Miller [mailto:millerrl@US.IBM.COM] Sent: Wednesday, February 06, 2002 12:37 AM To: DB2-L@RYCI.COM Subject: Re: Is there are any methodology to find out which packages are a ctually executed by a plan ? [...] 19049 87 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?23_Tello Najera Juan Pablo26_jp.tello@BBVA.BANCOMER.COM30_Wed, 6 Feb 2002 09:19:51 -0600569_iso-8859-1 My answer is YOU NOT NEED TO REBIND. In my expirience migrating I have never had to rebind any application plan or package after the migration procss esxcept for those that are noted exception in the Installation Guide. I have not migrated to V7, but all the documentation I have read doesn't say that I need to rebind all packages. We are a large shop with more than a 10,000 packages in a datasharing production system, and I migrated many DB2 subsistems many times from V2.3 to V6 and never ever had to rebind all this packages after each migration. [...] 19137 19 52_DB2 OS/390 V6.1 and OMVS (UNIX SYSTEM SERVICES (USS)0_25_Ed_Vetock@NAVYFEDERAL.ORG30_Wed, 6 Feb 2002 10:33:33 -0500422_us-ascii All,

Is there a way to query a DB2 OS/390 table from OMVS (USS)? We cannot seem to find any docs on this subject.

Any help is much appreciated.

R/..Ed

================================================ 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. 19157 140 13_Re: CDB REORG13_Raja Ram Balu19_rajaram.balu@BT.COM30_Wed, 6 Feb 2002 15:29:10 -0000567_ISO-8859-1 Thanks Todd for the reply. I are now in the plan of doing CDB reorg twice to gain both compression and DASD saving.

-----Original Message----- From: Todd Burch ***************************************************** [mailto:tburch@CDBSOFTWARE.COM] Sent: 05 February 2002 15:31 To: DB2-L@RYCI.COM Subject: Re: CDB REORG



Hi Raja.

When you use +ALLO(USED) as an allocation strategy, (one of several allocation strategies available) CDB/Auto-Reorg gets the amount of space actually used by the object at the start of the REORG. [...] 19298 112 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Feb 2002 10:32:12 -0500392_iso-8859-1 Paul,

If you have tools such as CA Detector, having multiple plans (perhaps one per appliction? one per CICS TRANSID?) makes performance research *much* easier. This is especially the case when a CICS transaction can run multiple packages.

It can also make interpreting such things as MICS (and presumably other measurement/chargeback applications) much easier. [...] 19411 84 7_Re: SAP11_rick creech18_ykcirc@HOTMAIL.COM30_Wed, 6 Feb 2002 09:56:07 -0600689_- Hi,

Some material can be found by going to IBM Redbook site and searching on SAP. www.redbooks.ibm.com

Regards,

Rick Creech



>From: "Pendlebury-Bowe, Leslie" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: SAP >Date: Wed, 6 Feb 2002 13:46:31 -0000 > >Hi > >do you have IBM helping you at all? > >I can help but it would take me a year to type everything we have done .. >how about I do it offline ? > >Les > >-----Original Message----- >From: Toni LeTempt [mailto:tletemp@OIR.STATE.SC.US] >Sent: Friday, February 01, 2002 8:13 PM >To: DB2-L@RYCI.COM >Subject: SAP > [...] 19496 116 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Feb 2002 10:56:25 -0500295_iso-8859-1 As a followup: I have been around for every DB2 upgrade from V1 through V5 and V5 to V7. Up until V7 I had to rebind very little (usually nothing) as part of an upgrade. When we went from V5 to V7, we had hundreds of SQL errors (-332 was most common) which were fixed by REBIND. [...] 19613 45 39_Re: Image copy dataets and there format15_Murley, Michael22_Michael_Murley@BMC.COM30_Wed, 6 Feb 2002 10:03:39 -0600370_iso-8859-1 DB2 V6 Diagnosis Guide starting at p. 341 (I just happen to have it out on my desk :-).

-----Original Message----- From: Briggs, N. - Neil - [mailto:N.Briggs@CANON-EUROPA.COM] Sent: February 06, 2002 8:56 AM To: DB2-L@RYCI.COM Subject: Re: Image copy dataets and there format



I have looked in there, please give me the page number? [...] 19659 30 56_AW: DB2 OS/390 V6.1 and OMVS (UNIX SYSTEM SERVICES (USS)16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE30_Wed, 6 Feb 2002 17:16:40 +0100517_iso-8859-1 DB2 V6 base contains JAVA and HPJ samples to be used under USS You may also search the DB2 bookshelf for JDBC or SQLJ

Roland

> -----Ursprüngliche Nachricht----- > Von: Ed_Vetock@NAVYFEDERAL.ORG [SMTP:Ed_Vetock@NAVYFEDERAL.ORG] > Gesendet am: Mittwoch, 6. Februar 2002 16:34 > An: DB2-L@RYCI.COM > Betreff: DB2 OS/390 V6.1 and OMVS (UNIX SYSTEM SERVICES (USS) > > All, > > Is there a way to query a DB2 OS/390 table from OMVS (USS)? We cannot > seem > to find any docs on this subject. > [...] 19690 139 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?13_Ealey, Paul M18_paul.ealey@EDS.COM30_Wed, 6 Feb 2002 16:24:45 -0000371_iso-8859-1 Thanks Eric The application we have to support has been built using one plan for all apps - online and batch. Below this plan are 1500+ packages. We've inherited this and we'd be grateful for any performance monitoring advice. Would CA Detector be useful in this situation?

Are there detailed specific reasons why this is a bad strategy for plans? [...] 19830 26 56_Re: DB2 OS/390 V6.1 and OMVS (UNIX SYSTEM SERVICES (USS)10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 6 Feb 2002 17:36:44 +0100685_us-ascii Try

http://www-1.ibm.com/servers/eserver/zseries/zos/unix/bpxa1toy.html

and in particular

http://www-1.ibm.com/servers/eserver/zseries/zos/unix/bpxa1ty2.html

There's a toolz called execsql and some other stuff to connect DB2 with the Dark Side of S390 (USS).

Beware.....you don't know the power of the Dark Side of USS......

Max Scarpa The Useless from the bright side of the S390...until now

================================================ 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. 19857 38 17_Question on VIews14_Database Admin21_db2udbxpert@YAHOO.COM30_Wed, 6 Feb 2002 08:40:49 -0800332_us-ascii Hi

Is there any way to add virtual column to a view where this column will not exist in the table on which the view is created.

Example :

TABLE 1 has col1, col2 , col3

Created VIEW1 on all columns of TABLE 1

Requirement is to ADD a column X to this view without adding it to TABLE 1 [...] 19896 166 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Feb 2002 11:40:42 -0500487_iso-8859-1 Detector (a *very* valuable tool) will be able to tell you what all the programs/DBRMs are doing inside the one monolithic plan. It will not have a good way of relating these to individual batch jobs and CICS transactions. We have a horrible vendor-supplied application (not IBM) which has one huge plan, no packages, and a gazillion DBRMs. Performance research for it (it is a real hog) is very difficult. Of course anything we do find gets no response from the vendor. [...] 20063 153 71_Re: Migrating to DB2v6 or 7,do all plans & packages need to be rebound?13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM30_Wed, 6 Feb 2002 11:46:05 -0500521_US-ASCII All,

It's possible that you might want to re-bind selected plans/packages on migration to V7.

Why?

It's common for maintenance PTFs to have ++HOLD information that requires re-binding "affected" plans or packages. What maintenance level is your current V6 subsystem at? What level is the "new" V7 system at? If the V7 subsystem "contains" maintenance you haven't applied already to your V6 subsystem, then there may be items that require re-binds for these "fixes" to become effective. [...] 20217 60 29_Re: DB2 mainframe differences17_Vandreese, Tami S27_Tami.Vandreese@LANDSEND.COM30_Wed, 6 Feb 2002 10:49:14 -0600599_iso-8859-1 Grant, Regarding your question about the scalar function below... Not sure what versions you have, but I received a similar error running 7.2 on AIX where a function with {} in it showed syntax errors. This is the fix I found on IBM's site:

SQL0007N appears after upgrading FixPak when query with braces '{}' is issued Applicable version(s): Version 7 Applicable platform(s): Windows NT Abstract: How do I resolve the problem of SQL0007N appearing when I issue a query with dates enclosed in braces '{}' after I have upgraded the FixPak level for DB2 Version 7.1 from 2 to 3? [...] 20278 64 45_Re: Recover tablespace with IC not in SYSCOPY13_Davis, Ronald17_DavisRo@CONED.COM30_Wed, 6 Feb 2002 12:05:52 -0500276_ISO-8859-1 I know everyone is saying DSN1COPY, however, if you have an unload tool it may just unload the imagecopy to a flat file that you can use as input into a DB2 load job. I've used use Platinum's fast unload for this kind of stuff. BMC has an unload tool as well. [...] 20343 90 21_Re: Question on VIews10_James Kwan19_JamesDB2Kwan@CS.COM28_Wed, 6 Feb 2002 12:06:15 EST529_US-ASCII What will be the value for X?

James Kwan

IBM Certified Solutions Expert...

In a message dated 2/6/02 11:04:41 AM Central Standard Time, db2udbxpert@YAHOO.COM writes:



> Hi > > Is there any way to add virtual column to a view where > this column will not exist in the table on which the > view is created. > > Example : > > TABLE 1 has col1, col2 , col3 > > Created VIEW1 on all columns of TABLE 1 > > Requirement is to ADD a column X to this view without > adding it to TABLE 1 > [...] 20434 174 72_Re: Migrating to DB2v6 or 7,do all plans & packages need to be re bound?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Feb 2002 12:05:38 -0500573_iso-8859-1 We did a rebind on everything that 'fit the profile' according to the HOLDDATA. We still got lots of SQL errors. Many were -332. As a result we did collection-level rebinds for all our packages. We also rebound the horrible monolithic vendor-supplied application.



Regards, eric pearson NS ITO Database Support

-----Original Message----- From: Lockwood Lyon [mailto:Lockwood.Lyon@MEIJER.COM] Sent: Wednesday, February 06, 2002 11:46 AM To: DB2-L@RYCI.COM Subject: Re: Migrating to DB2v6 or 7,do all plans & packages need to be rebound? [...] 20609 88 21_Re: Question on VIews10_Mark Doyle19_mdoyle@JCPENNEY.COM30_Wed, 6 Feb 2002 11:11:03 -0600438_iso-8859-1 How about:

CREATE VIEW VIEW1 (col1, col2 , col3, colX) AS Select (col1, col2 , col3, 'literal') from TABLE 1;

Not knowing exactly what you want to do with it, it's hard to be more specific.

Mark

----- Original Message ----- From: "Database Admin" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, February 06, 2002 10:40 AM Subject: Question on VIews [...] 20698 28 17_PeopleSoft on UDB10_James Kwan19_JamesDB2Kwan@CS.COM28_Wed, 6 Feb 2002 12:09:16 EST99_US-ASCII Has anyone implemented PeopleSoft on UDB? Would you like to share your experience?

20727 40 56_Re: DB2 OS/390 V6.1 and OMVS (UNIX SYSTEM SERVICES (USS)13_John Ferguson17_kf0oujf@YAHOO.COM30_Wed, 6 Feb 2002 09:05:19 -0800672_US-ASCII Ed,

Using DB2WWWX it can be done using REXX. If you don't have it, it can be found at http://www.s390.ibm.com/nc/sntc/DB2IMSRX.html.

John Ferguson



On Wed, 6 Feb 2002 10:33:33 -0500 Ed_Vetock@NAVYFEDERAL.ORG wrote:

> All, > > Is there a way to query a DB2 OS/390 table from OMVS (USS)? We cannot seem > to find any docs on this subject. > > Any help is much appreciated. > > R/..Ed > > ================================================ > 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. [...] 20768 63 21_Re: Question on VIews12_Gross, Chuck18_cgross@MILL-IS.COM30_Wed, 6 Feb 2002 12:15:16 -0500463_us-ascii I guess I am confused, where is column X coming from? Is it derived from another column(s)? Is it a literal?

Warm Regards, Chuck Gross Director; Database Services MillenniuM Information Systems Email: cgross@mill-is.com Work: 703-341-1428 Cell: 614-323-4279



-----Original Message----- From: Database Admin [mailto:db2udbxpert@YAHOO.COM] Sent: Wednesday, February 06, 2002 11:41 AM To: DB2-L@RYCI.COM Subject: Question on VIews [...] 20832 28 22_Load LOG YES vs LOG NO14_Jessen Michael27_JessenMichael@JOHNDEERE.COM30_Wed, 6 Feb 2002 11:07:47 -0600448_iso-8859-1 Platform is DB2 V6 on OS/390.

Does anyone have a 'rule of thumb' for when to code LOG NO in a load (and having the tablespace go into COPY pending) vs using the default of LOG YES? 1000 records? 10,000? 100,000? million?

We are trying to avoid the need to create in imagecopy in the middle of processing. Unfortunately, A load occurs near the beginning... at what point will Logging on a Load utility be an issue?.... [...] 20861 46 28_Message from the list owners14_Morrill John M26_MorrillJohnM@JOHNDEERE.COM30_Wed, 6 Feb 2002 11:27:48 -0600580_us-ascii Greetings!

I would like to make a few points regarding a recent discussion and some other questions and comments the list owners have received.

* This is strictly a user operated list. It is not an official IBM support forum. The only support we receive is from Yevich, Lawson & Associates, Inc (YL&A) which generously provides hosting for this list. YL&A does not have any administrative control of the list and does not use this list as either a promotional forum or a support forum. All policy is set by the list owners. YL&A does not own the list. [...] 20908 49 26_Re: Load LOG YES vs LOG NO16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 6 Feb 2002 12:47:15 -0500425_iso-8859-1 My 'rule of thumb' for LOG NO vs LOG YES is: ALWAYS LOG NO. Has been so since V1. Create an inline COPY if you specify REPLACE, create a copy afterwards if not.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Jessen Michael [mailto:JessenMichael@JOHNDEERE.COM] Sent: Wednesday, February 06, 2002 12:08 PM To: DB2-L@RYCI.COM Subject: Load LOG YES vs LOG NO [...] 20958 48 29_[Fwd: Load LOG YES vs LOG NO]14_Glen Sanderson26_glen.sanderson@SAFEWAY.COM30_Wed, 6 Feb 2002 11:55:46 -0600325_us-ascii You can write LOAD...LOG NO NOCOPYPEND to stop the utility from forcing a copy. However be aware that if the utility fails you will have to recover to before the load. If you have an imagecopy before the load with very few changes to the data between that imagecopy and the load, that would be ok for recovery. [...] 21007 27 18_JDBC install DBRMs11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Wed, 6 Feb 2002 09:52:30 -0800338_iso-8859-1 If someone has managed to install JDBC on OS/390, could you FTP/email me the DBRMs created the the db2genJDBC utility.

This would be so much easier than trying to get past the "*** panic: GC: getStaticField failed: °¬Q¬D-x¬Q-rj¬Q¬_9@ " error when I try and run the utility.

i'm so tired...so very tired..... [...] 21035 18 33_Re: [Fwd: Load LOG YES vs LOG NO]0_26_truman.g.brown@VERIZON.COM30_Wed, 6 Feb 2002 13:13:03 -0500370_us-ascii Note that LOAD with LOG YES will cause log write contention with concurrent application CRUD activity and could cause log buffer write waits. Unless there are very few rows to be loaded I would avoid LOG YES and take the image copy. You can be brave and kill the copy pending depending on the criticality of the application and your recovery requirements. [...] 21054 43 48_Bind parameter problem DB2 OS390 V6 ... 00C900A78_Ken Kane15_kkane@UBSPW.COM30_Wed, 6 Feb 2002 13:21:35 -0500405_iso-8859-1 List, Has anyone come across a problem such as this.. A batch plan bound with Acquire (allocate), Release (Deallocate) generates the following upon execution.

DSNT408I SQLCODE = -923, ERROR: CONNECTION NOT ESTABLISHED: DB2 ACCESS, REASON 00C900A7, TYPE 00000800, NAME RCCBD002 DSNT418I SQLSTATE = 57015 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNAET03 SQL PROCEDURE DETECTING ERROR [...] 21098 214 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Wed, 6 Feb 2002 10:55:20 -0800486_iso-8859-1 Hi Linda. You are correct: you do not have to rebind application plans and packages after a DB2 upgrade. We upgraded to version 6 last October and had one SQL error for which we had to rebind the package, but I've never done a mass rebind just because I upgraded. We too have 1 online/ 1 batch plan per application. I was not in on the decision to implement that, but I believe it was done to give the developers flexibility for implementing and/or backing out changes. [...] 21313 32 39_Re: Image copy dataets and there format17_Walter Trovijo Jr18_wtrovijo@IG.COM.BR30_Wed, 6 Feb 2002 17:09:22 -0200463_iso-8859-1 Neil,

It´s on chapter 7 of Diagnosis Guide for v5. Unfortunately I don´t have v6 and v7 diagnosis over here.

Walter.



----- Original Message ----- From: "Briggs, N. - Neil -" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, February 06, 2002 12:56 PM Subject: Re: Image copy dataets and there format



I have looked in there, please give me the page number? [...] 21346 65 33_Re: [Fwd: Load LOG YES vs LOG NO]10_James Kwan19_JamesDB2Kwan@CS.COM28_Wed, 6 Feb 2002 14:12:43 EST598_US-ASCII I did not see the original message. There is a new optin in V7 which allows you to do an online load which might be an alternative to use LOG YES.

James Kwan

IBM Certified Solutions Expert...

In a message dated 2/6/02 12:41:45 PM Central Standard Time, truman.g.brown@VERIZON.COM writes:



> > Note that LOAD with LOG YES will cause log write contention with concurrent > application CRUD activity and could cause log buffer write waits. Unless > there are very few rows to be loaded I would avoid LOG YES and take the > image copy. You can be brave [...] 21412 117 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?12_Isaac Yassin20_yassini@BEZEQINT.NET30_Wed, 6 Feb 2002 21:11:04 +0200577_iso-8859-1 Hi, I never saw a "must rebind all" in the documents - BUT if you will not rebind (with correct statistics) you'll not have the benefit of all new improvements to the optimizer, and of course you should bind what is requested by the APARS thrown into the foray.

Isaac Yassin yassini@bezeqint.net ----- Original Message ----- From: "Pearson, Eric L," Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, February 06, 2002 5:56 PM Subject: Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound? [...] 21530 62 26_Re: Load LOG YES vs LOG NO17_David Eugene Will26_david.e.e.will@VERIZON.COM30_Wed, 6 Feb 2002 14:15:20 -0500513_us-ascii Mike,

Our rule is to always use LOG NO followed by an image copy because we find it to be the fastest way to process. Of course we then start looking for reasons to break that rule. If recovery is a non-issue you can skip the image copy. If you are going to use LOG YES make sure that your active logs are allocated large enough (size / number) so that you won't fill the logs and find yourself waiting for archiving to complete. Because at that point your logging will have become an issue. [...] 21593 89 45_Re: Recover tablespace with IC not in SYSCOPY13_Davis, Ronald17_DavisRo@CONED.COM30_Wed, 6 Feb 2002 14:26:50 -0500556_ISO-8859-1 Marilyn, have you tried this? It sounds good in theory, but I don't see it working. A DB2 image copy has information regarding the obids,psids, and dbids. If the table is dropped and recreated, those ids can change.If they do change, when you go to recover, using that imagecopy, you'll get some of the nastiest DB2 errors you've ever seen. You may even get a heuristic error (joking). If the ids haven't changed, you may be right, it might work (if DB2 doesn't give you a timestamp error), but I wouldn't recommend it as a way to recover. [...] 21683 217 53_Re: SQL stored procedures with list of IN parameters.12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 6 Feb 2002 11:58:51 -0800341_us-ascii True, but personally there are more reasons to use Stored procedures than just being 'static' code. You can actually make the 'dynamic' code coming from JAVA be essentially static if you use some of the features of DB2 connect. It and some of the competitors products have the capability to make the user's dynamic SQL static. [...] 21901 46 26_Re: Load LOG YES vs LOG NO14_Peter Backlund21_pbacklu@ATTGLOBAL.NET30_Wed, 6 Feb 2002 21:07:29 +0100 21948 60 73_Re: To compare production data and the data restored at the disaster site18_Adrian Engelbrecht37_Adrian_Engelbrecht@WESTPACTRUST.CO.NZ30_Thu, 7 Feb 2002 09:09:50 +1300462_us-ascii If you can access both files from one machine, Fileaid compare or option 3.12 or 3.13 will do the compare.







"Zalina Abdul Rahman/ITNOC/PBB/PBBG" on 05/02/2002 19:09:48

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Adrian Engelbrecht/WestpacTrust/NZ) Subject: To compare production data and the data restored at the disaster site [...] 22009 82 26_Re: Load LOG YES vs LOG NO0_19_Tim.Lowe@STPAUL.COM30_Wed, 6 Feb 2002 14:41:21 -0600534_us-ascii Mike, In my opinion, the use of LOG YES in LOAD can depend on a couple of factors, not only your log datasets, but your audience. I have dealt with a lot of programmers in the past few years who don't have any mainframe experience, and will copy whatever exists to accomplish what they want. In that environment, I believe it is best to make sure that all loads are "LOG NO" because the one "tiny litte load" that is the exception may be the one example that the new programmer uses as his example to load a billion row [...] 22092 78 15_DBA Opportunity18_J. Michael Morrill17_john@JMORRILL.NET30_Wed, 6 Feb 2002 12:46:47 -0800299_us-ascii Our client located in Lincoln, NE is looking for an experienced (at least 7 years) DB2 DBA for a year long contract position. This is a system upgrade of a legacy system connected to a Mainframe and local LAN. You would need to make it web enabled and participate in a data migration: [...] 22171 69 39_Re: Image copy dataets and there format16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM30_Wed, 6 Feb 2002 14:15:00 -0700476_iso-8859-1 Neil,

For V6, the chapter number is the same as that of V5 (chapter 7).

Regards, Jeff L'Italien American Express





From: "Walter Trovijo Jr" @RYCI.COM> on 02/06/2002 05:09 PM ZW2

Please respond to "DB2 Data Base Discussion List"

Sent by: "DB2 Data Base Discussion List"



To: DB2-L@RYCI.COM cc: Subject: Re: Image copy dataets and there format [...] 22241 116 26_Re: Load LOG YES vs LOG NO17_David Eugene Will26_david.e.e.will@VERIZON.COM30_Wed, 6 Feb 2002 16:11:20 -0500441_us-ascii Peter,

Good thought, I would have nothing against using the inline copy. In our case (please feel free to laugh at this) the group that does the loading is different from the group who does the image copy (in production that is).

Dave







Peter Backlund @RYCI.COM> on 02/06/2002 03:07:29 PM

Please respond to DB2 Data Base Discussion List [...] 22358 104 29_Re: DB2 mainframe differences12_Raymond Bell17_rbell@NZ1.IBM.COM30_Thu, 7 Feb 2002 10:10:15 +1300435_us-ascii Yo Fuzzy,

You're 100% correct on the first point. You have to explicitly create unique indexes on your primary key columns before making them primary keys. Don't know about the ODBC stuff but I'm sure someone will.



Raymond





Grant Allen cc: Sent by: DB2 Subject: DB2 mainframe differences Data Base Discussion List [...] 22463 57 56_Re: DB2 OS/390 V6.1 and OMVS (UNIX SYSTEM SERVICES (USS)14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 7 Feb 2002 19:16:32 +1000455_US-ASCII Just a warning about this program (which, since it is some years since I tried it, might have now been fixed): it barfs when you try to fetch more than 32767 rows. The ONCODE (it is/was written in PLI) relates to asking for the log of a negative number.

This might be reasonable in terms of its intended use (would you really want to display more than 32767 rows on an HTML page?). But does limit its usefullness in other situations. [...] 22521 53 26_Re: Load LOG YES vs LOG NO14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 7 Feb 2002 19:16:34 +1000307_US-ASCII The point at which LOG YES becomes untenable is when the additional log records (combined with normal log activity) fills all active logs faster than archive can do its thing. When this happens, all active logs become full, and your subsystems stops - until archive clears an active log file. [...] 22575 137 22_Re: RRSAF implications12_Henry Daries23_Henry.Daries@BCBSKS.COM30_Wed, 6 Feb 2002 15:54:00 -0600516_- Hi Kirk, sorry for the misinformation. We are on OS/390 V2.10. As for the dynamic part of my email, I understood that if one wanted to link edit to the Stored Procedure dynamically from different application programs we had to use RRSAF and not CAF. Is this a fact.

We have WLM in goal mode but do not have the WLM address space for Stored Procedures setup yet. My main question revolved around the comment about "significant recovery opportunties with the SYSLOGGER" if we switched from CAF to RRSAF. [...] 22713 90 52_Re: Bind parameter problem DB2 OS390 V6 ... 00C900A713_LOMBARD,Shaun25_shaun.lombard@DEWR.GOV.AU30_Thu, 7 Feb 2002 08:56:33 +1100581_iso-8859-1 Ken,

Looks like there is a fix for this problem. see below.

Item PQ50838



APAR Identifier ...... PQ50838 Last Changed..01/09/06 RC00C900A7 DSNIALLC TYPE0800



Symptom ...... AB RC00C900A7 Status ........... CLOSED PER Severity ................... 2 Date Closed ......... 01/07/30 Component .......... 5740XYR00 Duplicate of ........ Reported Release ......... 610 Fixed Release ............ 999 Component Name 5740 IBM DATABA Special Notice Current Target Date ..01/10/01 Flags SCP ................... Platform ............ [...] 22804 109 39_Re: Image copy dataets and there format0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 6 Feb 2002 16:26:57 -0600556_iso-8859-1 If you are looking to find DBID, PSID, OBID you could also run the IC thru DSN1PRNT. Unfortunately the Utility guide 'sucks' when it comes to explaining the output, lets face it, this text is a cop-out 3.9.4 DSN1PRNT output

+--- Interpreting output ------------------------------------------------+ ¦ One intended use of this utility is to aid in determining and ¦ ¦ correcting system problems. When diagnosing DB2, you might need to ¦ ¦ refer to licensed documentation to interpret output from this utility. ¦ ¦ ¦ [...] 22914 77 21_Re: Question on VIews15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM30_Wed, 6 Feb 2002 16:28:35 -0600406_us-ascii Try this way :

CREATE VIEW VIEW1 AS SELECT A.* , value1 as X FROM TABLE1 A

where Value1 can be any expression or value







Database Admin cc: Sent by: DB2 Subject: Question on VIews Data Base Discussion List



02/06/02 10:40 AM Please respond to DB2 Data Base Discussion List [...] 22992 58 49_Re: Help with NT security authentication (resend)11_Grant Allen22_grant@TOWERSOFT.COM.AU30_Thu, 7 Feb 2002 09:33:27 +1100552_iso-8859-1 Philip Nelson (DBA)[SMTP:teamdba@ATTGLOBAL.NET] wrote: > > I sent the following on Christmas Eve : I guess I was the only person > > reading DB2 newsgroups over the festive period. So I'm resending. [ ... snip ... ]

> > SERVER1 has been added to NT resource domain DOMAINDEV. A local group > > GROUP1 has been added to SERVER1. > > > > User account USER1 have been created under our NT accounts domain > > DOMAINACC. > > > > DOMAINACC is trusted by DOMAINDEV, therefore the user's DOMAINACC NT > > account have been added to the [...] 23051 206 22_Re: RRSAF implications12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 6 Feb 2002 15:02:27 -0800287_us-ascii Henry, I don't think you can link edit to a stored procedure. But you can call it from any type of application program with a standard SQL call just like you'd do a SELECT or INSERT. The stored procedure must always use RRSAF. Its part of the way they are invoked and run. [...] 23258 66 45_Re: Recover tablespace with IC not in SYSCOPY0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 6 Feb 2002 17:17:21 -0600454_us-ascii Well, that is where the "OBIDXLAT" parameter comes in handy. We use it all the time to load production image copies into development, where all the IDs are totally different, so it will work just as well with a production IC of a dropped/recreated production table.











"Davis, Ronald" @RYCI.COM> on 2002/02/06 01:26:50 PM Subject: Re: Recover tablespace with IC not in SYSCOPY [...] 23325 74 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 6 Feb 2002 17:23:21 -0600482_us-ascii When we went from V5 to V6 we didn't bother with rebinds during the upgrade process. Then next day we had a couple of production online programs abended with sqlcode -101's. Then, rather than waiting for more failures we took the shotgun, "what the heck, it's only CPU cyles, right?" approach and rebound everything. At the same time we changed DEGREE(ANY) to DEGREE(1) except where we kne explicitly that it would not cause a problem. Not an elegant solution but ... [...] 23400 33 29_Re: DB2 mainframe differences11_Grant Allen22_grant@TOWERSOFT.COM.AU30_Thu, 7 Feb 2002 10:26:56 +1100820_iso-8859-1 Thanks everyone for the helpful suggestions and info ... very much appreciated.

Ciao Fuzzy :-)

---------------------------------------------------------------------------- "Woo Hoo!" H. Simpson ---------------------------------------------------------------------------- The contents of this post are my opinions only If swallowed seek medical advice

(Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in [...] 23434 28 11_EDM Pool...7_db user20_dbuser75@HOTMAIL.COM30_Wed, 6 Feb 2002 23:38:19 +0000569_- This is regarding Dynamic statement cache in EDM pool. Our monitoring tool shows that a whopping 60 MB (70% of our EDM pool size) is being used by Dynamic statement cache. However, the value of MAXKEEPD (total number of prepared, dynamic SQL statements to save past a commit point.) is only set at 6500. Estimating a maximum size of 2 KB for each prepared statement (though my calculations show size should be lesser than that), the total size of all the dynamic statements should be 6500*2KB = 13MB. Now if the maximum size of all the prepared statements is 13 [...] 23463 187 22_Re: RRSAF implications0_16_khampto1@TXU.COM30_Wed, 6 Feb 2002 18:07:53 -0600552_us-ascii Hi Henry, Your application issues an EXEC SQL CALL spname statement to invoke a stored procedure, you do no link-editing to it at all. It executes in a separate address space from your calling application, and that address space is managed by either DB2 (commonly called the SPAS) or by Workload Mannager (WLM). Either way, your calling applications do not have any interaction with RRS, but the stored procedure itself (a separate load module) must be link-edited to use RRSAF, by including the DSNRLI interface. Hope this clears it up. [...] 23651 200 15_Re: EDM Pool...13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Wed, 6 Feb 2002 16:09:12 -0800601_iso-8859-1 Hi Kumar. According to the installation guide section on MAXKEEPD: "This limit does not affect the storage used by the EDM pool for caching dynamic SQL statements. It applies to copies of prepared SQL statements owned by individual threads in DBM1 working storage."

If you are caching dynamic SQL, it will stay there until it has to be thrown out because the space is needed. Did you specify any storage for EDMDSPAC? This allows you to keep your dynamic cache in a dataspace and provide virtual storage constraint relief for the DBM1 address space. If you are using that, then [...] 23852 157 32_Re: automatic: SET CURRENT SQLID0_16_khampto1@TXU.COM30_Wed, 6 Feb 2002 18:23:42 -0600570_us-ascii Hi Richard, if the whole point of doing the SET CURRENT SQLID is to avoid doing GRANTs to individual userids, there are much easier ways to get it done than what you are proposing. We have run for many years having table owner id = collection id = RACF group name per each application, and that group name is then connected via RACF to individuals as a secondary authid if they need table owner rights. Otherwise, we just grant EXECUTE auth on plans and/or packages, and very limited table privileges if necessary, to another RACF group name, to which all [...] 24010 38 15_Custom Splitter14_Gill, Jerry T.15_JTGill@WEST.COM30_Wed, 6 Feb 2002 17:47:49 -0600558_iso-8859-1 Hi All, I am trying to implement a custom splitter process that across a 9 node EEE environment. Has anyone had any experience along these lines, any sample code that anyone may know about. I am currently looking at 2 functions, the sqlugtpi() and sqlugrpn(), but not being a C master they are a bit cryptic with out example code. The reason's for this are long and very obscure and the autoloader will not work in it's present incarnation. A very brief overview of what we are trying to do is load 8 binary streams of data from 2000+ server [...] 24049 43 24_DB2 Connect Alternatives13_Jodi Murawski27_Jodi.Murawski@METAVANTE.COM30_Wed, 6 Feb 2002 22:19:53 -0600323_us-ascii I am wondering if there are any alternatives to DB2 Connect out there that other vendors might have. We have DB2 Connect installed in our organization, and really like the product. However, the restructuring of the pricing with Version 7 is going to force us to replace it with another product or technology. [...] 24093 21 24_DB2 Connect Alternatives13_Jodi Murawski27_Jodi.Murawski@METAVANTE.COM30_Wed, 6 Feb 2002 23:41:13 -06009_us-ascii 24115 79 28_Re: DB2 Connect Alternatives10_James Kwan19_JamesDB2Kwan@CS.COM28_Thu, 7 Feb 2002 01:33:05 EST672_US-ASCII Jodi, Neon system has a competitive product Shadow Direct. Try www.neonsys.com.

James Kwan

IBM Certified Solutions Expert...





In a message dated 2/6/02 10:57:37 PM Central Standard Time, Jodi.Murawski@METAVANTE.COM writes:



> > > I am wondering if there are any alternatives to DB2 Connect out there that > other vendors might have. We have DB2 Connect installed in our > organization, and really like the product. However, the restructuring of > the pricing with Version 7 is going to force us to replace it with another > product or technology. > > I am interested in hearing about other alternatives, and [...] 24195 46 32_Installing DB2 7.2 on windows nt12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU30_Thu, 7 Feb 2002 08:20:07 +0100444_US-ASCII I'm currently trying to install the DB2 for windows evaluation CD I got at IDUG in Florence. I downloaded the quick beginnings manual from the web and after reading the notes about installation I granted the aditional privileges on NT as indicated in the book and started the installation. I got error messages during the installation and I tried to look up on the web or in the manuals what they mean but I didn't find anything. [...] 24242 128 45_Re: Recover tablespace with IC not in SYSCOPY14_Marilyn Millar31_marilyn.millar@SOMERFIELD.CO.UK30_Thu, 7 Feb 2002 07:27:48 -0000425_iso-8859-1 Hi Ronald,

absolutely - it works! A developer used this method and I was as surprised as you. I tested the procedure before I emailed the list. The tspace had not been dropped. Try it yourself! Regards,

Marilyn

-----Original Message----- From: Davis, Ronald [mailto:DavisRo@CONED.COM] Sent: 06 February 2002 19:27 To: DB2-L@RYCI.COM Subject: Re: Recover tablespace with IC not in SYSCOPY [...] 24371 15 53_Adrian Risi/Australia/Contr/IBM is out of the office.11_Adrian Risi19_adrianr@AU1.IBM.COM30_Thu, 7 Feb 2002 18:50:12 +1100402_us-ascii I will be out of the office starting February 7, 2002 and will not return until February 11, 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. 24387 30 15_Re: EDM Pool...10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 7 Feb 2002 09:02:16 +0100438_us-ascii Hi

MAXKEEPD affect LOCAL cache only, probably you've CACHEDYN set to YES and this

(enabling GLOBAL CACHING in EDM pool) is why you've problem in EDM pool. Setting CACHEDYN=NO will eliminate

global caching in EDM pool but NOT local thread caching if bound with KEEPDYNAMIC(YES). But it depends on your

needs.

See the valuable article by Namik Hrle in IDUG solution Journal, Vol. 8 Number 2 [...] 24418 51 22_AW: JDBC install DBRMs16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE30_Thu, 7 Feb 2002 09:31:57 +0100628_iso-8859-1 This won't work as the db2genJDBC doesn't create the DBRM only. If creates a new DBRM (inlcuding a new token) everytime.

You need to invoke it on your system. What problem to you have with it?

Roland



> -----Ursprüngliche Nachricht----- > Von: Cliff Boley [SMTP:Maurice.C.BOLEY@ODOT.STATE.OR.US] > Gesendet am: Mittwoch, 6. Februar 2002 18:53 > An: DB2-L@RYCI.COM > Betreff: JDBC install DBRMs > > If someone has managed to install JDBC on OS/390, could you FTP/email me > the > DBRMs created the > the db2genJDBC utility. > > This would be so much easier than trying to get past the [...] 24470 103 18_Re: Bufferpooltool23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 7 Feb 2002 09:34:08 -0000414_iso-8859-1 Ruediger

We have looked at BMC's offering of late and do have the bufferpool (Joel's tool) onsite and running as I type.

There were some really good features that the BMC tool offered, however, Joel's product gives me the kind of level of detail that I want. I do believe that future releases (both due this year) of both products will greatly enehance their appeal to our community. [...] 24574 196 73_AW: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?12_Peter, Georg15_G.Peter@DZBW.DE30_Thu, 7 Feb 2002 10:52:02 +0100446_iso-8859-1 You can use Detector or Apptune (this one is from BMC).

With kind regards - mit freundlichen Grüssen, Georg H. Peter ----------------------------------------------------------------------

-----Ursprüngliche Nachricht----- Von: Ealey, Paul M [mailto:paul.ealey@EDS.COM] Gesendet am: Mittwoch, 6. Februar 2002 17:25 An: DB2-L@RYCI.COM Betreff: Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound? [...] 24771 62 26_Re: Load LOG YES vs LOG NO19_Alekos Papadopoulos13_apapad@NBG.GR30_Thu, 7 Feb 2002 14:30:34 +0200418_iso-8859-1 Just a personal rule of thumb:

<1000 rows => LOG YES 1000-10000 rows => it depends. >10000 rows => LOG NO



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





-----Áñ÷éêü ìÞíõìá----- Áðü: Jessen Michael [mailto:JessenMichael@JOHNDEERE.COM] ÁðïóôïëÞ: ÔåôÜñôç, 6 Öåâñïõáñßïõ 2002 7:08 ìì Ðñïò: DB2-L@RYCI.COM ÈÝìá: Load LOG YES vs LOG NO [...] 24834 42 28_Re: DB2 Connect Alternatives11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Thu, 7 Feb 2002 08:12:31 -0500751_iso-8859-1 We are also concerned with DB2 Connect pricing, and are looking at Neon Systems www.neonsys.com and DataDirect http://www.datadirect-technologies.com/





-----Original Message----- From: Jodi Murawski [mailto:Jodi.Murawski@METAVANTE.COM] Sent: Wednesday, February 06, 2002 11:20 PM Subject: DB2 Connect Alternatives





I am wondering if there are any alternatives to DB2 Connect out there that other vendors might have. We have DB2 Connect installed in our organization, and really like the product. However, the restructuring of the pricing with Version 7 is going to force us to replace it with another product or technology. [...] 24877 31 20_Interesting articles12_McKown, John22_JMckown@HEALTHAXIS.COM30_Thu, 7 Feb 2002 07:56:12 -0600486_- Well, at least I thought so:



o Technical article: Bob Lyle talks about SQL OLAP functions in DB2 http://isource.ibm.com/cgi-bin/goto?on=naa5aa0136

o Technical article: Migrating a Microsoft Access 2000 database to DB2 Universal Database 7.2 http://isource.ibm.com/cgi-bin/goto?on=naa5sw0132

o Technical article: Building federated systems with relational connect and database views http://isource.ibm.com/cgi-bin/goto?on=naa5sw0137





24909 31 47_SQLSTATE warning, stored procedures result sets11_Joe Luthman22_jluthma@BGNET.BGSU.EDU30_Thu, 7 Feb 2002 09:01:49 -0500313_us-ascii We're beginning to follow a standard of setting error (38xxx) and warning (01Hxx) SQLSTATE from our stored procedures. Java callers can then expect to detect the error SQLSTATE in the catch block. And the warning SQLSTATE will be used instead of an OUT parm -- to pass messages back to the invoker. [...] 24941 180 73_Re: Migrating to DB2v6 or 7, do all plans & packages need to be r ebound?23_Tello Najera Juan Pablo26_jp.tello@BBVA.BANCOMER.COM30_Thu, 7 Feb 2002 08:38:48 -0600522_iso-8859-1 I agree with Isaac, BUT, what if you have to fallback for any reason? I think that if you do a rebind on all packages and start using all the new improvements of the optimizer and then you need to go back to version 5 or 6, then you will need to rebind again after the fallback to V5 or V6 because this versions doesn´t know about new features in the V7 optimizer. My opinion is DO NOT REBIND unless it is necessary, and after you are sure you are not going to fallback, then start rebinding in a cautious [...] 25122 46 28_Re: DB2 Connect Alternatives9_Mike King17_mlking2@FEDEX.COM30_Thu, 7 Feb 2002 08:33:12 -0600727_us-ascii Which product from Neon in the DataDirect line would replaced db2 connect EE?

"Hayden, Lee" wrote:

> We are also concerned with DB2 Connect pricing, and are looking at Neon > Systems > www.neonsys.com > and DataDirect > http://www.datadirect-technologies.com/ > > > -----Original Message----- > From: Jodi Murawski [mailto:Jodi.Murawski@METAVANTE.COM] > Sent: Wednesday, February 06, 2002 11:20 PM > Subject: DB2 Connect Alternatives > > I am wondering if there are any alternatives to DB2 Connect out there that > other vendors might have. We have DB2 Connect installed in our > organization, and really like the product. However, [...] 25169 29 22_REORG caused poor SQL?12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US30_Thu, 7 Feb 2002 09:09:31 -0600344_US-ASCII Running DB2 UDB EE v7.1 on AIX 4.3.3 We are using DMS with multiple containers spread across multiple logical volumes which reside on ESS Shark.

Recently, we performed a standard REORG in our production system.

We have 1 SQL statement that is actually performing worse and is estimating worse than before the REORG. [...] 25199 67 28_Re: DB2 Connect Alternatives13_Kenski, David25_David.Kenski@MARRIOTT.COM30_Thu, 7 Feb 2002 10:10:48 -0500433_iso-8859-1 I'm not involved with the product pricing side of things here. How is the DB2 Connect pricing being restructured?

Thanks,

Dave Kenski

-----Original Message----- From: Mike King [mailto:mlking2@FEDEX.COM] Sent: Thursday, February 07, 2002 9:33 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect Alternatives



Which product from Neon in the DataDirect line would replaced db2 connect EE? [...] 25267 30 15_Temporary Table12_McKown, John22_JMckown@HEALTHAXIS.COM30_Thu, 7 Feb 2002 09:35:53 -0600551_- Another newbie question. Suppose I have a table which is only read by an application. Suppose futher that the application requires that no other application update any row of the table while it runs. I.e. the application requires a "snapshot". I can think of two ways to do this. 1) Do a "LOCK TABLE" at the beginning of the application. 2) Use a temporary table and copy the required rows from the live table into it. If the application runs quickly, I think that #1 is best (quickly is a relative term, I know). If the application runs for a [...] 25298 66 26_Re: REORG caused poor SQL?19_Shashi B Mannepalli31_sashi_mannepalli@FREDDIEMAC.COM30_Thu, 7 Feb 2002 10:36:46 -0500485_us-ascii After you are done with your REORG...you still need to run RUNSTATS....so that OPTIMIZER will pick up the latest CATALOG information..



Thanks SHASHI B MANNEPALLI DB2 UDB ADMINISTRATION 703-760-2746





DOUG KESTNER cc: Sent by: DB2 Subject: REORG caused poor SQL? Data Base Discussion List



02/07/2002 10:09 AM Please respond to DB2 Data Base Discussion List [...] 25365 47 26_Re: REORG caused poor SQL?18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Thu, 7 Feb 2002 10:54:41 -0500542_- A basic question but did you rerun runstats after the reorg?

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



-----Original Message----- From: DOUG KESTNER [mailto:DHSTS57@DHS.STATE.IL.US] Sent: Thursday, February 07, 2002 10:10 AM To: DB2-L@RYCI.COM Subject: REORG caused poor SQL?



Running DB2 UDB EE v7.1 on AIX 4.3.3 We are using DMS with multiple containers spread across multiple logical volumes which reside on ESS Shark. [...] 25413 94 28_Re: DB2 Connect Alternatives13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Thu, 7 Feb 2002 10:11:39 -0600440_iso-8859-1 Jodi,

We are in the same boat. Named users doesn't make sense, and we use internet/intranet to access DB2 Connect which only leaves a site license (DB2 Connect Unlimited) alternative based on CPU capacity.

We are evaluating Neon's Shadow product, with favorable results. It is a much better product for transactional type applications, and it is a host-based started task, not an intermediary server solution! [...] 25508 64 26_Re: REORG caused poor SQL?20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT30_Thu, 7 Feb 2002 17:22:03 +0100330_iso-8859-1 Hi,

I don't know if I can't really help explaining this but the fact that Stats tables aren't current can really confusing the Optimizer I think... and I would guess it could be somethng about the clusterfactor of the indexes. As everybody else asked: Did you tried gathering new statistics for that table? [...] 25573 84 26_Re: REORG caused poor SQL?15_Russell Collins21_russell@ECTAUSTIN.COM30_Thu, 7 Feb 2002 10:43:21 -0800458_us-ascii Along with the runstats, make sure you do a rebind after the runstats.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Shashi B Mannepalli Sent: Thursday, February 07, 2002 7:37 AM To: DB2-L@RYCI.COM Subject: Re: REORG caused poor SQL?



After you are done with your REORG...you still need to run RUNSTATS....so that OPTIMIZER will pick up the latest CATALOG information.. [...] 25658 42 28_Re: [REORG caused poor SQL?]12_GENE TILELLI16_geetee52@USA.NET28_Thu, 7 Feb 2002 11:35:31 EST446_US-ASCII Did RUNSTATS get run afterwards?





DOUG KESTNER wrote: Running DB2 UDB EE v7.1 on AIX 4.3.3 We are using DMS with multiple containers spread across multiple logical volumes which reside on ESS Shark.

Recently, we performed a standard REORG in our production system.

We have 1 SQL statement that is actually performing worse and is estimating worse than before the REORG. [...] 25701 32 44_Timeout/Deadlock Tracking in UDB environment11_Tim Traxson22_Tim_Traxson@JBHUNT.COM30_Thu, 7 Feb 2002 10:39:43 -0600526_us-ascii Hello list,

I have a need to track timeout/deadlock numbers on a monthly basis on DB2 UDB for NT and AIX and am wanting to know how subscribers to this list accomplish this or would accomplish this if the need were to arise. Is this something that I would have to have a third party tool to accomplish or is there a setting or switch I can enable on the server to write a message to a log file on the server every time there is a timeout /deadlock? Or is this something that is already done as a standard [...] 25734 97 26_Re: REORG caused poor SQL?13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Thu, 7 Feb 2002 11:34:13 -0600544_iso-8859-1 Aside from runstats/rebind/etc, what stats changed with the reorg? One situation where I commonly see performance degredation after a reorg is when the clustering strategy of the table was not well thought out to start with. You start off with a "good" cluster-ratio (from a performance standpoint) just as a function of how the data is added to the table, but then the reorg organizes the rows according to the clustering index, which may be "bad" (for example, clustering on a surrogate key that consists of a random number). [...] 25832 66 48_Re: Timeout/Deadlock Tracking in UDB environment18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Thu, 7 Feb 2002 13:00:36 -0500604_- GET SNAPSHOT FOR DATABASE ON database-name provides you with a deadlock counter. This counter gets reset whenever you deactivate the database or take an offline backup. I have an application that was producing many deadlocks and this is one way to count the number of deadlocks.

A second way is to use the Event Monitor. It is part of the Administration client on your workstation. You can also set it via the server with CREATE EVENT MONITOR command. This will actually trap deadlock information in the event monitor files and you can produce a report using the db2evmon command. Actually [...] 25899 206 28_Re: DB2 Connect Alternatives8_Ron Root24_ron.root@CPA.STATE.TX.US30_Thu, 7 Feb 2002 12:00:52 -0600614_iso-8859-1 I find the recent questions/comments on DB2 Connect interesting. We are fairly heavy users of Neon Shadow. We have web and Powerbuilder applications accessing DB2. We currently have the work spread across 22 Shadow server regions. We are happy with Neon, but on general principals we are always considering alternatives. These comments make me think we may have the right answer already. We use their Dynamic to Static facility to try to make most of the sql static. This is an ongoing manual challenge. The nature of the Web and Powerbuilder applications causes them to generate a huge variety of [...] 26106 51 48_Re: Timeout/Deadlock Tracking in UDB environment15_Manus, Wolfgang22_wolfgang.manus@EDS.COM30_Thu, 7 Feb 2002 17:59:42 -0000664_- Tim,

you can use an event monitor for that. Check Chapter 2 of the System Monitoring Guide and Reference for more details.

Best regards - Wolfgang Manus

-----Original Message----- From: Tim Traxson [mailto:Tim_Traxson@JBHUNT.COM] Sent: Thursday, February 07, 2002 5:40 PM To: DB2-L@RYCI.COM Subject: Timeout/Deadlock Tracking in UDB environment



Hello list,

I have a need to track timeout/deadlock numbers on a monthly basis on DB2 UDB for NT and AIX and am wanting to know how subscribers to this list accomplish this or would accomplish this if the need were to arise. Is this something that I would have to have [...] 26158 17 43_Re: MSSqlserver conversion to DB2 utilities12_Mike Brennan31_michael.brennan@I-STRUCTURE.COM30_Thu, 7 Feb 2002 11:36:46 -0600392_- Have you tried the conversion tool from MANTECH? Here's a link to their product website. http://www.mssc-mantech.com/products/products.html

I've tested their conversion tool from SQL SERVER to DB2 OS/390 and it worked very well. It not only creates the proper DDL but also the load utility jobs for each table. Just curious, what is the reason for converting off of SQL Server? [...] 26176 17 36_Peopesoft HR on DB2 OS/390 Benchmark12_Mehdi Fakhar26_mehdifakhar@WINN-DIXIE.COM30_Thu, 7 Feb 2002 11:56:07 -0600513_- Peoplesoft Version 7.5 Running on DB2 V 6.1 OS/390. Does anyone has actual times for running the paryroll processes? My company will be running payroll for 120,000 employees and we like to know how long it will take when Time and Attendance(T&A) process starts until Check print is completed. Currently we run the above processes for 15,000 employee in a reasonable time frame, but would like to know what to expect for the 120,000. Appreciate any comments even if you run on different platforms than DB2. [...] 26194 25 14_When to REBIND14_Smith, Brent E19_brent.smith@EDS.COM30_Thu, 7 Feb 2002 13:48:16 -0500481_iso-8859-1 Listers,

OS/390 ver 2.9 and DB2 ver 5.1

In searching through the DB2 manual for a problem we are having, it says rebinding all plans isn't necessary after runstats, only if the access path statistics change significantly from the last time the plan was bound...

Is there a simple solution out there to determine if the stats have changed enough to warrent a rebind?? Should everything be rebound after the runstats job and not worry about it?? [...] 26220 76 28_Re: DB2 Connect Alternatives9_Mike King17_mlking2@FEDEX.COM30_Thu, 7 Feb 2002 13:02:24 -0600612_us-ascii Any usage of the internet for connecting clients requires purchase of an unlimited license.

"Kenski, David" wrote:

> I'm not involved with the product pricing side of things here. How is the > DB2 Connect pricing being restructured? > > Thanks, > > Dave Kenski > > -----Original Message----- > From: Mike King [mailto:mlking2@FEDEX.COM] > Sent: Thursday, February 07, 2002 9:33 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Connect Alternatives > > Which product from Neon in the DataDirect line would replaced db2 connect > EE? > > "Hayden, Lee" wrote: > > > We are also concerned with [...] 26297 51 19_Re: Temporary Table13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Thu, 7 Feb 2002 14:04:56 -0500584_iso-8859-1 Hello John,

Here are a few questions to help answer yours.

How big is the table in question? What is driving the requirement that no other application update the table? - if a temporary copy of the table solves the requirement, obviously the real table could be updated while the app. is looking at the copy. Does it just need a consistent view of the data? - would the isolation level Repeatable Read provide what you need? Repeatable Read causes DB2 to hold locks on any pages you touch, rather than releasing them when your cursor moves off the page. [...] 26349 27 28_Re: DB2 Connect Alternatives12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 7 Feb 2002 13:20:00 -0500458_- I understand SAS also has a connectivity product. Anyone have any info on that?

>>> DB2 Data Base Discussion List 02/06/02 10:21PM >>> I am wondering if there are any alternatives to DB2 Connect out there that other vendors might have. We have DB2 Connect installed in our organization, and really like the product. However, the restructuring of the pricing with Version 7 is going to force us to replace it with another product or technology. [...] 26377 35 11_DB2 Connect12_Chris Virnig26_Chris.Virnig@COURTS.WA.GOV30_Thu, 7 Feb 2002 11:28:14 -0800532_iso-8859-1 We have been using a product called StarSQL and StarPipes to provide adhoc query access from our users to our OLTP DB2 database on OS/390. StarPipes is a component which sits on an NT server and acts as a gateway for our connections from our query users. When recently upgrading our StarPipes software we discovered the vendor had removed the licensing and connection limiting part of the software. We had the ability to limit the number of concurrent connections through the gateway. With the new version we can't. [...] 26413 15 11_DSN Command10_Toni Addie26_Toni_Addie@PROGRESSIVE.COM30_Thu, 7 Feb 2002 14:47:49 -0500487_us-ascii Is it possible to execute a DSN SYSTEM command from a COBOL program? I am specifically interested in starting/stoping stored procedures/UDFs and rebinding in a COBOL program. I don't think this can be done, but I just want to make sure.

================================================ 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. 26429 72 36_Re: Installing DB2 7.2 on windows nt18_Gert van der Kooij16_gkooij@XS4ALL.NL30_Thu, 7 Feb 2002 20:52:08 +0100440_iso-8859-1 Hi,

This might be a problem with the NT user specified to run the services under. Check if this user isn't disabled and enter the password again to be sure it's still valid.

Hope this helps

----- Original Message ----- From: "Claude Birtz" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, February 07, 2002 8:20 AM Subject: Installing DB2 7.2 on windows nt [...] 26502 95 36_Re: Installing DB2 7.2 on windows nt17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Thu, 7 Feb 2002 14:15:02 -0600587_us-ascii you should log in to the NT box as an administrator





From: Gert van der Kooij @RYCI.COM on 02/07/2002 01:52 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: Installing DB2 7.2 on windows nt



Hi,

This might be a problem with the NT user specified to run the services under. Check if this user isn't disabled and enter the password again to be sure it's still valid. [...] 26598 14 39_SECURITY HOLES FOUND IN ORACLE SOFTWARE12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 7 Feb 2002 14:11:00 -0500499_- FYI, in the event your site has Oracle.

A security firm has uncovered flaws in Oracle's 9i database, allowing a hacker to access the database server without a user ID or password. http://www.computerworld.com/cwi/story/0,1199,NAV47_STO68105,00.html

================================================ 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. 26613 21 43_DB2 Connect -- Controlling Concurrent Users12_Phil Gunning22_pgunning@EARTHLINK.NET30_Fri, 8 Feb 2002 04:17:48 +0800371_iso-8859-1 Chris, I haven't looked at this in a while but I recall under the db2 licensing component on NT that you could limit the number of concurrent users, either via a hard limit (stop any addl connection attempts) or a soft limit which would issue warning messages. I had it in warning mode. If you check out your install or doc I believe you will find it. HTH Phil 26635 19 18_Re: When to REBIND13_Martin Packer24_martin_packer@UK.IBM.COM30_Thu, 7 Feb 2002 20:31:21 +0000536_us-ascii When you get to Version 7 the Statistics History tables in the Catalog should help you. But I appreciate you're still on Version 5.

Cheers, Martin

Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584)

================================================ 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. 26655 47 28_Re: DB2 Connect Alternatives13_Walter Davies26_wdavies@CO.EL-DORADO.CA.US30_Thu, 7 Feb 2002 12:45:05 -0800657_iso-8859-1 Merant also has a driver that we use with V.B. and mainframe DB2.

Walter ----- Original Message ----- From: "BOB JEANDRON" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, February 07, 2002 10:20 AM Subject: Re: DB2 Connect Alternatives



> I understand SAS also has a connectivity product. Anyone have any info on > that? > > >>> DB2 Data Base Discussion List 02/06/02 10:21PM >>> > I am wondering if there are any alternatives to DB2 Connect out there that > other vendors might have. We have DB2 Connect installed in our > organization, and really like the product. However, [...] 26703 199 72_Re: Migrating to DB2v6 or 7, do all plans & packages need to be rebound?14_Grainger, Phil20_Phil.Grainger@CA.COM30_Thu, 7 Feb 2002 20:48:38 -0000503_iso-8859-1 Like all good DB2 questions, there is not one answer to this apparently simple question.....

"Do I NEED to rebind?" - NO "SHOULD I rebind?" - If you want to take advantage of version specific changes, YES "Is rebinding painless?" - NO, you might bet some 'suboptimal access paths and, unless you are ready to use access path hints, you have no way back to your old access paths so make d**n sure your statistics are what you want them to be "Did I rebind when migrating?" - NEVER [...] 26903 186 71_Re: Migrating to DB2v6 or 7,do all plans & packages need to be rebound?14_Grainger, Phil20_Phil.Grainger@CA.COM30_Thu, 7 Feb 2002 20:48:45 -0000342_iso-8859-1 I'm intrigued that a plan running on V5 that is returning the CORRECT results might suddenly start returning the WRONG results when run on V7 without a rebind...?

Is this true, or is the ++HOLD data saying that a plan bound on THAT version (V7) BEFORE the application of the fix will need to be rebound AFTER the fix?? [...] 27090 164 18_Re: When to REBIND14_Grainger, Phil20_Phil.Grainger@CA.COM30_Thu, 7 Feb 2002 20:53:37 -0000457_iso-8859-1 If only it were that simple!

What if you have a table that is inserted and deleted cyclically. You happen to run RUNSTATS when the table is nearly empty. The statistics may have changed significantly since the time the table was full of data, but would you want to rebind???

My own personal rule of thumb was always "I am rebinding EITHER because my SQL/program has changed" OR "because I am trying to improve my access path". [...] 27255 118 15_Re: DSN Command14_Grainger, Phil20_Phil.Grainger@CA.COM30_Thu, 7 Feb 2002 20:55:05 -0000417_iso-8859-1 You need to code calls to the IFI (Instrumentation Facility Interface) which will allow DB2 commands to be issued.

Unfortunately, I am on the road at the moment and I can't remember which manual to look in, but it's there somewhere.

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 [...] 27374 117 19_Re: Temporary Table12_McKown, John22_JMckown@HEALTHAXIS.COM30_Thu, 7 Feb 2002 14:56:20 -0600549_iso-8859-1 > -----Original Message----- > From: Seibert, Dave [SMTP:Dave_Seibert@COMPUWARE.COM] > Sent: Thursday, February 07, 2002 1:05 PM > To: DB2-L@RYCI.COM > Subject: Re: Temporary Table > > Hello John, > > Here are a few questions to help answer yours. > > How big is the table in question? > At present, the data is in a VSAM file (we don't have DB2 - I'm trying to get a number of reasons why DB2 would be a superior solution). The VSAM file is rather large, but the data to be inspected would only be a subset based on a WHERE clause. [...] 27492 25 43_Re: SECURITY HOLES FOUND IN ORACLE SOFTWARE9_Mike King17_mlking2@FEDEX.COM30_Thu, 7 Feb 2002 14:56:39 -0600566_us-ascii That's a feature.

BOB JEANDRON wrote:

> FYI, in the event your site has Oracle. > > A security firm has uncovered flaws in Oracle's 9i database, allowing a hacker > to access the database server without a user ID or password. > http://www.computerworld.com/cwi/story/0,1199,NAV47_STO68105,00.html > > ================================================ > 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. [...] 27518 23 15_Re: DSN Command0_12_jimh@QIS.NET30_Thu, 7 Feb 2002 16:14:10 -0500345_ISO-8859-1 I would think it should be possible. BMC essentially does that in Catalog Manager when you bind a package with it. Now you've got me curious to the point where I'll have to experiment if I can find the time. Not sure if you'd run into problems if you were already running under DSN, but there are probably work-arounds for that. [...] 27542 26 36_How to catch a connect failure code?10_Shi, Zhong23_Zhong.Shi@INCEPTURE.COM30_Thu, 7 Feb 2002 16:09:32 -0500412_iso-8859-1 Hi, List

Developer has told me that you can not get any error message back if you try to connect from a window program (through odbc) to a UDB database in Aix and the connection is failed. I really doubt about that but I cannot test it. Is this true? If it is not, how can the developer catch the error code? We want to get the connect error code and then exit the application gracefully. [...] 27569 42 15_Re: DSN Command11_David Nance16_DWNance@FHSC.COM30_Thu, 7 Feb 2002 16:50:23 -0500482_US-ASCII There was quite a discussion about this a few months ago. Please take a look at the archives.

>>> jimh@QIS.NET 02/07/02 04:14PM >>> I would think it should be possible. BMC essentially does that in Catalog Manager when you bind a package with it. Now you've got me curious to the point where I'll have to experiment if I can find the time. Not sure if you'd run into problems if you were already running under DSN, but there are probably work-arounds for that. [...] 27612 41 40_Re: How to catch a connect failure code?14_Howland, David20_dhowland@TELERAN.COM30_Thu, 7 Feb 2002 17:04:57 -0500408_iso-8859-1 Hello: I just tested using Brio and an ODBC connection, and it appears to return the error message. The 2 tests were invalid password, SQL1403N and DB is down, SQL30081N. Hope that helps, Dave

-----Original Message----- From: Shi, Zhong [mailto:Zhong.Shi@INCEPTURE.COM] Sent: Thursday, February 07, 2002 4:10 PM To: DB2-L@RYCI.COM Subject: [DB2-L] How to catch a connect failure code? [...] 27654 11 43_Encryption of a DB2 numeric field on OS/39011_Kent Knight14_kentk@ASPG.COM30_Thu, 7 Feb 2002 15:52:40 -0600333_- Are there any products that would allow Encryption of a DB2 field that is a numeric type?

================================================ 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. 27666 142 26_Re: REORG caused poor SQL?15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM30_Thu, 7 Feb 2002 16:30:14 -0600367_us-ascii Why don't u check extents of datasets of tablespace & indexspace and then try to get into one extent by altering alllocations of tablespace & indexe(s) then run REORG with STATISTICS option then finally REBIND corresponding plans/packages. After this if still it performs badly then u might need to alter index definition in support to bad running SQL. [...] 27809 138 26_Re: REORG caused poor SQL?12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US30_Thu, 7 Feb 2002 16:31:59 -0600598_US-ASCII RUNSTATS was definitely ran after the REORG. Actually, runstats is scheduled once a week (whether it needs it or not...) There are no bound programs (seriously), all SQL is dynamic coming from Forte.

I was thinking along the lines that the access path was probably most influenced by the clustered index. It is possible that the clustered index that I currently have, is not the best index to be clustered. But, during the time leading up to needing a REORG, the clustered index had a very low cluster ratio. With this low cluster ratio, the optimizer is possibly not choosing [...] 27948 63 15_Re: DSN Command64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM30_Thu, 7 Feb 2002 16:36:43 -0600495_ISO-8859-1 Hi Toni.

The "DSN" commands, per se, (not to be confused with DB2 commands) are only available under TSO. "DB2" commands are available through IFI.

Perhaps you could call TSO from your batch COBOL program, but that's a whole lotta work and a HUGE pain, and typically plagued with inhibitors.

I wish there WAS an API to the DSN commands, like BIND and FREE, with no dependencies on TSO, as a whole product suite could be wrapped around having that interface. [...] 28012 85 18_Re: When to REBIND12_Higgins John25_HigginsJohn@JOHNDEERE.COM30_Thu, 7 Feb 2002 16:38:12 -0600400_us-ascii The cluster ratio of an index is a key to the optimizer's choice of access path. So is the estimated size of a query's result set.

For large result sets using poorly clustered indexes, the optimizer seems to prefer list prefetch. Smaller result sets and/or better clustering on the index favors index sequential access. A cluster ratio below 80% is considered poorly clustering. [...] 28098 53 15_Re: DB2 Connect13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Thu, 7 Feb 2002 16:46:54 -0600708_iso-8859-1 Chris,

Even without using the pooling functionality you can set the max users parameter. However, requests for service made at the max threshold will fail as opposed to queuing.

Dave





-----Original Message----- From: Chris Virnig [mailto:Chris.Virnig@COURTS.WA.GOV] Sent: Thursday, February 07, 2002 1:28 PM To: DB2-L@RYCI.COM Subject: DB2 Connect



We have been using a product called StarSQL and StarPipes to provide adhoc query access from our users to our OLTP DB2 database on OS/390. StarPipes is a component which sits on an NT server and acts as a gateway for our connections from our query users. When recently upgrading our StarPipes [...] 28152 24 8_Striping14_Frank Fillmore26_frank_fillmore@HOTMAIL.COM30_Thu, 7 Feb 2002 18:08:59 -0500451_- A colleague is running DB2 UDB V6 on AIX. The database was installed with db2_striped_containers registry variable = off. If she changes the registry variable to "on" and a reorg is performed on a tablespace, will the containers be striped for that tablespace?











_________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com [...] 28177 81 15_Re: DB2 Connect13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM30_Thu, 7 Feb 2002 17:38:29 -0600613_iso-8859-1 Chris, I'm guessing that you wish to control the number of users getting into DB2 via the application versus the number of users going through the gateway. You asked about other products, well, Shadow Direct from NEON Systems, where I work, provides the capability to control how many users, which users, which applications, how many connections per user, from what client ip or hostname and numerous other options, can connect to the remote DB2 subsystem and without a separate gateway box. Numbers of users can be controlled either of two ways within the Shadow Server which runs on your OS/390 [...] 28259 13 29_Re: DBM1 Storage Rexx - Stats12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 7 Feb 2002 17:18:57 -0600419_- Please add one to your count of thank yous. I just walked strough storage management with another customer, and the V7 reports are handy too.

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. 28273 17 48_Tammie Pollack/Boulder/IBM is out of the office.14_Tammie Pollack17_tammie@US.IBM.COM30_Thu, 7 Feb 2002 16:56:46 -0700540_us-ascii I will be out of the office starting February 6, 2002 and will not return until February 8, 2002.

I will be away from the office in Education on Feb 6,7,8th. My backup is Madhavi Durgam, durgam@us.ibm.com 303.924.2294 and my team lead is Velma Smith, velma@Us.ibm.com, 303.924.1713.

================================================ 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. 28291 15 45_Randy Krueger/Schneider is out of the office.13_Randy Krueger22_KruegerR@SCHNEIDER.COM30_Thu, 7 Feb 2002 18:01:18 -0600389_us-ascii I will be out of the office starting 02/08/2001 and will not return until 02/11/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. 28307 83 72_Re: Migrating to DB2v6 or 7, do all plans & packages need to be rebound?12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 7 Feb 2002 18:43:39 -0600547_- There is the one answer, "It depends." Sorry, Phil. I could not resist the temptation, and I have a little to add to your good answer. I would say that neither of you wins this bet.

It's clear that you are not forced to rebind. If that were true, the book would need to say so. Sometimes you'll be advised by IBM service people or general fixes to rebind everything. If you are asking for advice, then I think rebinding early makes a lot of sense. A conservative strategy might be to migrate first without rebinding, then to run the [...] 28391 61 18_Re: When to REBIND12_Subha Sivaji22_subha_sivaji@YAHOO.COM30_Thu, 7 Feb 2002 17:08:10 -0800516_us-ascii Hi Brent, Yes , we had the same situation as you . Rebinding all the plans are definitely not advisable , when some of the access path needs to be retained. But to determine which is the best access path either before of after the rebind , same copy can be used to bind in the test environment and the Explain results will help to decide which is the best to retain by performance. It is definitely a difficult task when the number of programs related are relatively large . Hope this helps a little . [...] 28453 27 72_Re: Sqlcode -101, anyone has war stories to share on ways to resolve it?12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 7 Feb 2002 19:17:40 -0600397_- 1. What is your service level for V6?

2. Have you found one or are you thinking there might be one?

There were a couple of APARs in 1999, and maybe in 2000. If you are that far back on service, you will have problems. For example, the big change was APAR PQ21786, and yes, I remember the number. There are slightly larger sizes for V4, V5 and V6. The base for V7 was changed. [...] 28481 44 72_SQLCODE -503: DCLGEN and object columns match but can't bind. Any ideas?11_Linda Ayeni22_lindaayeni@HOTMAIL.COM30_Thu, 7 Feb 2002 19:32:32 -0700308_- Dear List, Has anyone encountered the following bind problem and how it was resolved. Have reviewed the DCLGEN and table columns using platinum and both checked out, but unable to bind. This same user id able to bind other programs in the same test environment. Here is what I get when I try to bind. [...] 28526 175 72_Re: Migrating to DB2v6 or 7, do all plans & packages need to be rebound?14_Edward P. Long19_RDHM99A@PRODIGY.NET30_Thu, 7 Feb 2002 22:27:40 -0500405_- My bet is that the preceding discussion has an interesting unstated assumption; that someone changes DB2 releases, in production, without testing the $(#D$*$ out of it first.

The #2 way to learn more about MONSTER.COM quickly is inadequate, or incomplete, testing.#1 is partnering up with Enron.

Not testing the access paths until two weeks later in production is incomplete testing. [...] 28702 111 77_Re: SQLCODE -503: DCLGEN and object columns match but can't bind . Any ideas?14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU30_Fri, 8 Feb 2002 15:27:06 +1100398_iso-8859-1 I'm not sure why you are concerned with the DCLGEN - my manual says:

-503 A COLUMN CANNOT BE UPDATED BECAUSE IT IS NOT IDENTIFIED IN THE

UPDATE CLAUSE OF THE SELECT STATEMENT OF THE CURSOR





Explanation: The application program attempted to update (using a cursor)

a value in a column of the object table that was not identified in the FOR [...]