1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2003, week 1 2 34 32_Dominic Li is out of the office.10_Dominic Li21_dominicli@HSBC.COM.HK30_Wed, 1 Oct 2003 14:14:56 +0800646_us-ascii I will be out of the office from 10/01/2003 until 10/06/2003.

For any urgent matters, please send your mail to Alice Cheng (Alice Y Y Cheng) or my boss Fung Kam Yiu (Kam Yiu K Y Fung).



Thanks & Regards, Dominic







********************************************************************** This E-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return E-mail. [...] 37 138 46_Re: Create Index statement - Copy No parameter25_Sorensen Henrik (KAFC 21)33_henrik.sorensen@CREDIT-SUISSE.COM30_Wed, 1 Oct 2003 09:33:50 +0200626_ISO-8859-1 Hi,

Can DB2 schedule the Copy and Recovery to run in parallel over the whole sysplex or just within a single member ?



Henrik -----Original Message----- From: Isaac Yassin [mailto:yassini@BEZEQINT.NET] Sent: Tuesday, September 30, 2003 8:41 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Create Index statement - Copy No parameter



Hi, We copy to dasd. Recovery is fast, don't have the times here - will check tomorrow. For big tables (118M rows - 8 disks data, 12 disk indexes) it helps. Copy & recover in parallel - works superb (ever seen 150 subtasks in parallel ? :-) ) [...] 176 24 46_Re: Create Index statement - Copy No parameter10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 1 Oct 2003 10:41:40 +0200483_us-ascii Hi Isaac, how is it ? Ready for Nice ?

Having enough disks....but not all DB2ers are so rich (me first !). Anyway in EVERY shop there's a lot of wasted space...the problem is to find it !

Anyway sometimes a general system-wide review of the production procedure works (enlarging active log size, tuning I/O subsystem, moving applications to other DB2s,using DASDs advanced features,using (sic) 3rd part tools, reviewing WLM service classes... and so on). [...] 201 88 15_CLI under DSN ?14_VAN ROYEN Dirk12_dvr@CIPAL.BE30_Wed, 1 Oct 2003 10:52:00 +0200360_iso-8859-1 Hi Listers,

I received a question from one of our developpers to find out, if there is any possibility to run CLI programs under control of DSN (the DB2-TSO batch command processor). In my opinion there's no way to do this. Following the IBM manuals, the only possible connections are CAF or RRSAF. Any help or suggestions are welcome . [...] 290 18 23_Re: Recover TS question33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE30_Wed, 1 Oct 2003 04:44:20 -0500531_- On Tue, 30 Sep 2003 09:10:42 -0700, Leblanc, Francis C - CNF wrote:

>and all associated indexes will be recovered.

Francis

The above sentence is not true. The indexes will not be recovered as Michael pointed out: They needn'd.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 309 22 35_EOS: DB2 V7 UDB for non-OS390 / zOS14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 1 Oct 2003 19:59:48 +1000633_US-ASCII http://www.ibm.com/isource/cgi-bin/goto?it=usa_annred&on=903-185

support ends 30 Sept 2004. (I'm not sure if _every_ V7 product is ending, but it looks like most are.)

There's a bucket load of other service and hardware support ending announcements. Check them out at http://www.ibm.com/isource/cgi-bin/goto?it=usa_annred&on=C03-050

James Campbell

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 332 47 57_Re: Changing EBCDIC codepage from one release to the next14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 1 Oct 2003 19:59:48 +1000319_US-ASCII If you have no characters in character column of any row of any table that are not identical in the two CCSIDs, then you might be OK not unloading/loading.

If not you might have a nasty surprise if you don't do some conversion. Might be as simple as reading every row and converting as necessary . [...] 380 129 24_Re: Real Time Statistics23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 1 Oct 2003 11:12:29 +0100512_- yes I think JC has sent this out to all the sites he knows.

interesting about SP230 ...

Les

-----Original Message----- From: Jeremiah Eden [mailto:JEREMIAH.EDEN@RADIOSHACK.COM] Sent: Tuesday, September 30, 2003 7:36 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Real Time Statistics



I'm sorry I did not to respond to the thread, but I was out sick for a week. APAR PQ78832 was opened to fix the problem now instead of some later release, and should be out next month. [...] 510 166 42_Re: Can DB2 handle reading encrypted data?14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Wed, 1 Oct 2003 11:40:52 +0100380_iso-8859-1 Which edition and version of DB2 are we talking about here?

Marcus Davage CEng MBCS IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration for UNIX, Linux, Windows and OS/2 DB2 UDB V7.1 Database Administration for OS/390 'The views expressed are my own and do not necessarily represent the views or policy of my employer, Lloyds TSB Bank plc.' [...] 677 94 57_Re: Changing EBCDIC codepage from one release to the next13_Jodi Murawski27_Jodi.Murawski@METAVANTE.COM30_Wed, 1 Oct 2003 06:11:15 -0500436_us-ascii You need to be careful with this. The CCSID is stored in SYSTABLESPACE, SYSDATABASE, and SYSPARMS catalog tables in Version 6. The system CCSID is defined in the DSNHDECP module by the person who performs your system installs. It is a problem to have different CCSID's in a subsystem. If you have IBM ETR support, I would recommend going to them for suggestions on how you can do this without causing any negative impact. [...] 772 43 18_pm - dest name sr16_Daniel15_bufes@YAHOO.COM30_Wed, 1 Oct 2003 06:31:27 -0500339_- Hi, just tried record trace using DB2 Performance Monitor. Does anyone know what DEST NAME SR1 means? Manual only mentions GTF, SMF, RES and OPN.



DEST NAME SMF SEQNO 7579 RECS WRITTEN 7579 NOT ACTIVE ERRORS 0 QWSBOTH1 0 QWSBOTH3 0

DEST NAME RES SEQNO 0 RECS WRITTEN 0 NOT ACTIVE ERRORS 0 QWSBOTH1 0 QWSBOTH3 0 [...] 816 13 30_Re: Reliable Replication tools10_Lee Hayden18_Lee_hayden@CSX.COM30_Wed, 1 Oct 2003 07:16:59 -0500262_- We have Striva to replicate from DB2 Z/OS to Oracle (Solaris and AIX). This tool uses the BMC EDP DB2 log reader (Striva bought that from BMC) and is quite efficient. We replaced IBM's DPROP and saw a 90% reduction in CPU. It has been a good tool for us. [...] 830 31 22_Re: pm - dest name sr110_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 1 Oct 2003 15:36:31 +0200462_us-ascii From member DSNWMSGS in SDSNSAMP:



1) GTF - GENERALIZED TRACE FACILITY 2) SMF - SYSTEM MANAGEMENT FACILITIES 3) RES - RESIDENT TRACE TABLE (NOT ACCUMULATED) 4) SRV - RESERVED FOR INTERNAL USE 5) SR1 - INTERNAL SPECIAL ACCOUNTING DESTINATION USED TO CALCULATE OPTIONAL DELTA TIMINGS 6) SR2 - INTERNAL SPECIAL DESTINATION FOR IFI READS USED TO RETURN DATA TO THE APPLICATION 7) OPN - SPECIAL DESTINATION FOR IFI READA BUFFERED RECORDS. [...] 862 16 21_apar text conventions6_Daniel15_bufes@YAHOO.COM30_Wed, 1 Oct 2003 08:33:51 -0500469_- Hi, I'm pretty sure I've read a document on text conventions for writing (and searching) APARs. It described formalities, e.g. keywords, abbreviations used, etc. Anyone knows a document like that? Thanks, Daniel

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 879 41 39_Re: Migrate to UDB on NT from Mainframe14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Wed, 1 Oct 2003 09:40:42 -0400553_ISO-8859-1 Your potential problem areas are CPU usage/access/consumption, and the I/O subsystem in terms of bandwidth. A`data warehouse implies lots of data access, large object scans, etc, etc. You'll need several physical (not logical) disks to spread the I/O workload. How many concurrent users are you planning for?

Regards, Joel



Message text written by DB2 Data Base Discussion List >Has anyone done any kind of write up on justification in migrating from Mainframe DB2 / Cobol environment to DB2 UDB on Windows NT/2000. [...] 921 40 37_RECOVERY TORBA/TOCOPY Dataset vol-ser26_SUBSCRIBE DB2-L Ravi Reddy20_ravi.reddy@PS.GE.COM30_Wed, 1 Oct 2003 09:52:36 -0400486_ISO-8859-1 Hi All,

DB2 V6 OS/390.

If the image copy dataset is off the MVS Catalog, is there anyway to specify the vol-ser during recovery if i want to recover to a quisce point taken after the image copy ? ( Can i use RECOVER TORBA and specify vol-ser information )

I understand that i can use RECOVERY TOCOPY , wherein i could specify volser information. But using TOCOPY i cannot recover to the quisce point taken after the image copies are done. [...] 962 80 41_Re: RECOVERY TORBA/TOCOPY Dataset vol-ser14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 1 Oct 2003 14:50:06 +0100397_iso-8859-1 If the volser and devicetype in SYSCOPY are blank then the dataset MUST be cataloged in the MVS catalog.

If there are only a few, then just recatalog them.

If there are a LOT you might want to investigate methods of changing the way the copies are registered in SYSCOPY. If the devicetype and volser are NOT blank, then DFB2 will use them in its dynamic allocations. [...] 1043 47 22_Re: pm - dest name sr16_Daniel15_bufes@YAHOO.COM30_Wed, 1 Oct 2003 08:49:05 -0500565_- On Wed, 1 Oct 2003 15:36:31 +0200, Max Scarpa wrote:

>From member DSNWMSGS in SDSNSAMP: > > > 1) GTF - GENERALIZED TRACE FACILITY > 2) SMF - SYSTEM MANAGEMENT FACILITIES > 3) RES - RESIDENT TRACE TABLE (NOT ACCUMULATED) > 4) SRV - RESERVED FOR INTERNAL USE > 5) SR1 - INTERNAL SPECIAL ACCOUNTING DESTINATION > USED TO CALCULATE OPTIONAL DELTA TIMINGS > 6) SR2 - INTERNAL SPECIAL DESTINATION FOR IFI READS > USED TO RETURN DATA TO THE APPLICATION > 7) OPN - SPECIAL DESTINATION FOR IFI READA BUFFERED > RECORDS. > >Do you have SAP ? [...] 1091 32 25_Re: apar text conventions14_Dingman, Randy25_RGDingman@AAAMICHIGAN.COM30_Wed, 1 Oct 2003 09:58:40 -0400453_iso-8859-1 DB2 Diagnosis Guide and Reference

-----Original Message----- From: Daniel [mailto:bufes@YAHOO.COM] Sent: Wednesday, October 01, 2003 9:34 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: apar text conventions



Hi, I'm pretty sure I've read a document on text conventions for writing (and searching) APARs. It described formalities, e.g. keywords, abbreviations used, etc. Anyone knows a document like that? Thanks, Daniel [...] 1124 104 14_Re: DDFs Again0_16_khampto1@TXU.COM30_Wed, 1 Oct 2003 09:36:49 -0500540_us-ascii Hi Carol, I am no expert on this, but I do know a little about our WLM setup here. For you to have these threads show up as SStype = DDF, your WLM must have some kind of default WLM group already set up, which includes all DB2 threads from DDF. In the WLM definitions menu (here we get into it by running a TSO clist IWMARIN0) , there is an option for Classification Rules, where you will probably find SStype=DDF. Within that you can set up rules to separate threads into different service classes based on the DB2 subsystem [...] 1229 60 34_Re: Stored Procedures/OS390/DB2 V712_Myron Miller22_Myron.Miller@BMWNA.COM30_Wed, 1 Oct 2003 10:44:25 -0400643_iso-8859-1 Peter, Scott Here's a test SQL Stored procedure we've used for some time. Its got 30,400 as a long varchar. Its been working for over two years.

CREATE PROCEDURE TESTZU.PARAMET ( OUT var1 varchar(30400) ) LANGUAGE SQL MODIFIES SQL DATA COLLID BMW WLM ENVIRONMENT DSNTSZU ASUTIME NO LIMIT RUN OPTIONS 'NOTEST(ALL,*,,VADTCPIP&170.34.205.44:*)' ------------------------------------------------------------------------ -- SQL Stored Procedure ------------------------------------------------------------------------ P1: BEGIN -- Declare variables DECLARE ENDTABLE INT DEFAULT 0; DECLARE var1_TMP varchar(30400) DEFAULT ' '; [...] 1290 93 34_Re: Stored Procedures/OS390/DB2 V718_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Wed, 1 Oct 2003 10:53:36 -0400429_US-ASCII You really don't have a LONG VARCHAR defined. What you have is a VARCHAR datatype with 30,400 bytes. There's a difference in what DB2 can handle in SQL stored procedures. We found that defining a VARCHAR will also work but on the midrange environment, we hit a limit for 4000 bytes. IBM is still looking into the PMR. I have a feeling it's either a parameter constraint that is not obvious, a memory issue or both. [...] 1384 31 25_Orphaned Storage from SMS13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM30_Wed, 1 Oct 2003 10:10:54 -0500533_us-ascii FYI. Last set of additional symptoms were just added to this SMS HIPER APAR. You might want to get your OS SYSPROG to put this on.

APAR Identifier ...... OA03201 Last Changed ........ 03/10/01 . . .

DFSMSdfp SMS VTOC Data Set Services calls SMS Configuration Services to obtain configuration information and does not freemain the area of storage aquired on its behalf. This area generally houses the IGDBCD control block. sp230 key5 ADDITION SYMPTOMS: Diag code 04034336 can also result in this scenario. [...] 1416 132 39_Re: Migrate to UDB on NT from Mainframe7_twalker17_twalker@AST-I.COM30_Wed, 1 Oct 2003 10:13:45 -0500672_iso-8859-1 Is the potential problem as far as CPUusage/access/consumption, and the I/O subsystem in terms of bandwidth is on NT or OS390 ?

We will be having around 100 concurrent users using COGNOS for drill throughs.



"Joel Goldstein" wrote in message news:200310010940_MC3-1-50E4-71BE@compuserve.com... Your potential problem areas are CPU usage/access/consumption, and the I/O subsystem in terms of bandwidth. A`data warehouse implies lots of data access, large object scans, etc, etc. You'll need several physical (not logical) disks to spread the I/O workload. How many concurrent users are you planning for? [...] 1549 112 24_Re: Real Time Statistics10_Rick Miles25_rick.miles@CUNAMUTUAL.COM30_Wed, 1 Oct 2003 09:26:19 -0500454_US-ASCII Isaac, When you stated that you will not be using RTS, are you saying that you have turned off, or disabled RTS? If so, how did you do that? I understood that once you enabled it, there was no way to disable it. Thanks, Rick







Jeremiah Eden To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Real Time Statistics Sent by: DB2 Data Base Discussion List [...] 1662 142 24_Re: Real Time Statistics13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM30_Wed, 1 Oct 2003 10:36:21 -0500410_us-ascii I would think that STATHIST=NONE would do it, but if I remember right from playing around with it 2 years ago, if the History Tablespaces are stopped, that will do. I could be wrong after all this time.

-----Original Message----- From: Rick Miles [mailto:rick.miles@CUNAMUTUAL.COM] Sent: Wednesday, October 01, 2003 9:26 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Real Time Statistics [...] 1805 37 21_Re: Replication tools15_Neff, Stephen R16_NeffSR@STATE.GOV30_Wed, 1 Oct 2003 11:52:47 -0400722_iso-8859-1 Hi We use Data Joiner and Data Propagator. However this relies on DB2 tables with control information. Once the control information is defined replication tasks run and are either programs or triggers.





-----Original Message----- From: Ramesh Balasubramanyan [mailto:RAMBAL@SAIF.COM] Sent: Friday, September 26, 2003 11:20 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Replication tools



Listers, Just checking what replication tools are in vogue for data transfer between Oracle and DB2 ... We having been using CA's Infopump, now called data transformer for the past 7 years. We are looking for a product with less maintenance overhead (Since it is SQL based, we have to [...] 1843 225 39_Re: Migrate to UDB on NT from Mainframe18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Wed, 1 Oct 2003 11:58:38 -0400319_US-ASCII

A more appropriate question to ask it what version of UDB will you be using? Pre-Version 8 would probably require the EEE version which supports datawarehouses, star schemas, etc. Version 8 has both EE and EEE in the base software product but you need a license key to use the functions of "EEE". [...] 2069 22 13_zero divide??14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US30_Wed, 1 Oct 2003 11:55:56 -0400415_iso-8859-1 I'm running into problems in a Peoplesoft script with dividing two decimal values with different precision, scale values. I'm getting a -802 (zero divide) error when trying to execute the following statement. Can someone help??



Works: SELECT CAST(1.36 AS DECIMAL(20,8)) / CAST(.86 AS DECIMAL(17,3))

Doesn't work: SELECT CAST(1.36 AS DECIMAL(20,8)) / CAST(.86 AS DECIMAL(18,3)) [...] 2092 48 17_Re: zero divide??7_db2_dba21_db2_dba@BELLSOUTH.NET30_Wed, 1 Oct 2003 11:30:46 -0500551_- a -802 is not just a zero divide error: -802 EXCEPTION ERROR exception-type HAS OCCURRED DURING operation-type OPERATION ON data-type DATA, POSITION position-number

Explanation: An exception error has occurred in the processing of an SQL arithmetic function or arithmetic expression. This error may be indicated by exception-type. Possible values for exception-type are FIXED POINT OVERFLOW, DECIMAL OVERFLOW, ZERO DIVIDE, DIVIDE EXCEPTION, EXPONENT OVERFLOW, or OUT OF RANGE. The exception error occurred in one of the following areas: [...] 2141 48 17_Re: zero divide??12_Jim Steelman23_Jim.Steelman@PFSFHQ.COM30_Wed, 1 Oct 2003 12:52:50 -0400539_iso-8859-1 As I suspect you are running the script outside of PeopleSoft, try adding "SET CURRENT PRECISION = ‘D31,6’".

This helped us when building some views under SPUFI instead of from the PeopleSoft AppDesigner tool.

Jim Steelman Lead Engineer Primerica Financial Services 770-564-7716

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Melissa Rogers Sent: Wednesday, October 01, 2003 11:56 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: zero divide?? [...] 2190 62 17_Re: zero divide??14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US30_Wed, 1 Oct 2003 12:59:13 -0400486_iso-8859-1 Yes, we are running outside of Peoplesoft. I did try the set statement because it is something we also use for creation of PS views but it didn't work. Thanks

-----Original Message----- From: Jim Steelman [mailto:Jim.Steelman@PFSFHQ.COM] Sent: Wednesday, October 01, 2003 12:53 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: zero divide??



As I suspect you are running the script outside of PeopleSoft, try adding "SET CURRENT PRECISION = 'D31,6'". [...] 2253 12 25_Re: apar text conventions14_Linda Hagedorn25_linda.hagedorn@EXCITE.COM30_Wed, 1 Oct 2003 12:06:20 -0500358_- The keyword standards for DB2 APARS are also documented in Info Apars II03953, II03560, and II07428.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 2266 25 45_Bufferpool Tool & BMC Pool Advisor Comparison16_Galluzzo, Lori A21_lori.galluzzo@EDS.COM30_Wed, 1 Oct 2003 13:10:39 -0500493_iso-8859-1 Dear List, One of our accounts is evaluating both Bufferpool Tool (Responsive Systems) & BMC Pool Advisor for the pro's & con's of their bufferpool monitoring capabilities. Any information would be greatly appreciated in helping us with this comparison.

Thanks in Advance!

Lori Ann Galluzzo IBM DB2 V7 Certified Specialist & Solutions Expert EDS - Metavance Infrastructure Team * phone: +01-717-975-5482 (8-428) * mailto:lori.galluzzo@eds.com pager: 877-881-1368 [...] 2292 70 39_Re: Migrate to UDB on NT from Mainframe12_Phil Gunning20_pgunning@COMCAST.NET30_Wed, 1 Oct 2003 14:34:32 -0400452_us-ascii Tim, I have moved several OLTP and DW applications and have some clients who have moved mixed applications from z/OS to NT very successfully. There are a few SQL differences but these should be rare. For more info on that, refer to the IBM DB2 Developer domain, there are a few articles on this, and the Redbook regarding Cross-Platform SQL. Is this truly a data warehouse or is it a mixed environment, (a combination of OLTP and BI/DW)? [...] 2363 71 17_Re: zero divide??12_Le BD Nguyen20_lnguyen@AHOLDUSA.COM30_Wed, 1 Oct 2003 14:34:45 -0400320_US-ASCII Melissa,

I don't know why you would need to convert the number to decimal format before the division. Why can't you code the select as: SELECT 1.36 / .86 ...? You can try to use float instead of decimal to avoid the overflow situation, ie. SELECT DECIMAL( (FLOAT (1.36) / FLOAT(0.86)), 20, 8 ) .... [...] 2435 92 17_Re: zero divide??14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US30_Wed, 1 Oct 2003 14:51:14 -0400431_iso-8859-1 When I run the query in SPUFI, I do get the correct value of 1.581395.

As far as why would we need to convert the number, it's a peoplesoft script so I'm not sure why they do it this way.

Thanks for the input.



-----Original Message----- From: Le BD Nguyen [mailto:lnguyen@AHOLDUSA.COM] Sent: Wednesday, October 01, 2003 2:35 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: zero divide?? [...] 2528 156 24_Re: Real Time Statistics12_Isaac Yassin20_yassini@BEZEQINT.NET30_Wed, 1 Oct 2003 22:04:31 +0200396_- Hi, RTS Tablespaces are stopped. You may get DSNI035I message for that. Sorry for being late - getting ready for IDUG next week.

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Jeremiah Eden Sent: Wednesday, October 01, 2003 5:36 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Real Time Statistics [...] 2685 45 19_Re: CLI under DSN ?14_Wayne Driscoll24_wayne.driscoll@QUEST.COM30_Wed, 1 Oct 2003 14:07:10 -0500512_us-ascii I've never tried it, but it MAY be possible to do this by using a NULL SQLConnect call, similar to the method that can be used in CAF and RRSAF. Wayne Driscoll Sr. Software Developer Quest Software wdriscoll@quest.com NOTE: All opinions are strictly my own.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of VAN ROYEN Dirk Sent: Wednesday, October 01, 2003 3:52 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: [DB2-L] CLI under DSN ? [...] 2731 40 46_Re: Create Index statement - Copy No parameter12_Isaac Yassin20_yassini@BEZEQINT.NET30_Wed, 1 Oct 2003 22:09:07 +0200373_- Hi Max, We used an old box for that ...

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Max Scarpa Sent: Wednesday, October 01, 2003 10:42 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Create Index statement - Copy No parameter

Hi Isaac, how is it ? Ready for Nice ? [...] 2772 30 33_Update of Partitioning Key Column12_John Bucaria16_JBUCARIA@PCH.COM30_Wed, 1 Oct 2003 16:26:42 -0400393_US-ASCII Hello Folks,

Back in1999 when we were running Version 5.1 of DB2 for OS/390, there was an APAR/PTF (PQ16946/UQ20575) which permitted the update of a partitioning key value. At the time, we elected not to apply the patch and thus not allow this type of processing. However, I just assumed that this patch would eventually be rolled forward into subsequent releases of DB2. [...] 2803 84 37_Re: Update of Partitioning Key Column0_16_khampto1@TXU.COM30_Wed, 1 Oct 2003 15:37:21 -0500517_us-ascii Hi John, I believe this is now controlled by a ZPARM in v6.1 and higher, look at your setting for PARTKEYU, if it is NO, that's why you got -151.

Kirk Hampton DB2 OS/390 Sysprog IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 TXU Business Services Dallas, Texas







John Bucaria cc: Sent by: DB2 Data Subject: Update of Partitioning Key Column Base Discussion List [...] 2888 162 24_Re: Real Time Statistics11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM30_Wed, 1 Oct 2003 13:48:08 -0500448_iso-8859-1 Statistics history is not the same as real time statistics.

I re-read the manuals on real time statistics because I didn't want them enabled when I upgrade due to all the problems that have been reported. It doesn't look like that's possible, though. The admin guide says DB2 is always gathering statistics. You can stop it from externalizing them into the RTS tables (in database DSNRTSDB) by stopping the database, though. [...] 3051 17 43_John Campbell1/UK/IBM is out of the office.14_John Campbell119_CAMPBELJ@UK.IBM.COM30_Wed, 1 Oct 2003 21:39:55 +0100528_us-ascii I will be out of the office starting September 26, 2003 and will not return until October 6, 2003.

I am out of the office on business in USA until Monday 6th October. I will be checking email during this period, but there may be a little delay in replying.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 3069 106 37_Re: Update of Partitioning Key Column12_John Bucaria16_JBUCARIA@PCH.COM30_Wed, 1 Oct 2003 16:53:32 -0400374_US-ASCII Hi Kirk,

Unfortunately, this ZPARM is set to "Yes". So what do you think, now? None of the other reasons for getting a "-151" seem to apply here.

John

>>> khampto1@TXU.COM 10/01/03 04:37PM >>> Hi John, I believe this is now controlled by a ZPARM in v6.1 and higher, look at your setting for PARTKEYU, if it is NO, that's why you got -151. [...] 3176 138 37_Re: Update of Partitioning Key Column14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 1 Oct 2003 22:00:07 +0100574_iso-8859-1 The table(space) also has to be created AFTER the fix became available on your subsystem

Hope it's a small table!!

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





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of John Bucaria Sent: Wednesday, October 01, 2003 9:54 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: [DB2-L] Update of Partitioning Key Column [...] 3315 145 37_Re: Update of Partitioning Key Column12_John Bucaria16_JBUCARIA@PCH.COM30_Wed, 1 Oct 2003 17:14:14 -0400355_US-ASCII Thanks, Phil. I think you may have hit it on the head. But now I have another question. RC/Query is indicating: DATE CREATED: 01-01-0001 Why is this date displayed instead of the actual create date?

>>> Phil.Grainger@CA.COM 10/01/03 05:00PM >>> The table(space) also has to be created AFTER the fix became available on your subsystem [...] 3461 137 37_Re: Update of Partitioning Key Column14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 1 Oct 2003 22:15:20 +0100596_iso-8859-1 Bad news John,

The table(space) also has to be created AFTER the fix became available on your subsystem

Hope it's a small table!!

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





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of John Bucaria Sent: Wednesday, October 01, 2003 9:54 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: [DB2-L] Update of Partitioning Key Column [...] 3599 18 37_Re: Update of Partitioning Key Column16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Wed, 1 Oct 2003 17:24:38 -0400413_iso-8859-1 John - if the tablespace was created prior to V5, that is the date used.

Kind regards Steen Rasmussen Computer Associates Senior Consultant

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 3618 177 37_Re: Update of Partitioning Key Column14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 1 Oct 2003 22:25:57 +0100537_iso-8859-1 Presumeably because it was created before creation dates were added to the catalog?

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





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of John Bucaria Sent: Wednesday, October 01, 2003 10:14 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: [DB2-L] Update of Partitioning Key Column [...] 3796 28 37_Re: Update of Partitioning Key Column12_John Bucaria16_JBUCARIA@PCH.COM30_Wed, 1 Oct 2003 17:57:32 -0400490_US-ASCII Thanks, everyone!

>>> Steen.Rasmussen@CA.COM 10/01/03 05:24PM >>> John - if the tablespace was created prior to V5, that is the date used.

Kind regards Steen Rasmussen Computer Associates Senior Consultant

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...] 3825 118 34_Re: Stored Procedures/OS390/DB2 V712_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 1 Oct 2003 15:12:42 -0700527_us-ascii Peter,

I'm confused as to what your problem is. What platforms are you having the problem on? And from what platform are you trying to access that platform. By midrange are you saying AS/400?

This and long varchar works for NT, AIX and OS/390. AS/400 is a radically different beast.

We've used this type of mechanism a lot, especially with JAVA on both Websphere and Weblogic as well as VB code running with IIS. For longer data streams, we've had to go to CLOBs and COBOL stored procedures. [...] 3944 106 17_Re: zero divide??14_Glen Sanderson26_glen.sanderson@SAFEWAY.COM30_Wed, 1 Oct 2003 23:27:15 -0500323_us-ascii Your casting into decimals larger than 15 digits is the problem. DB2 can only handle so many digits for numbers when dividing and truncation can occur before DB2 will divide. Read up on the rules in the SQL Reference guide under Chapter 2, Expressions, Arithmetic with two decimal operands, Decimal division. [...] 4051 40 49_Re: Bufferpool Tool & BMC Pool Advisor Comparison17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM30_Wed, 1 Oct 2003 23:45:56 -0500598_- Buffer Pool Tool: A Sledge hammer; Simple to use. But you need to understand certain basic stuffs. As a FYI, search on the list for Joel Goldstein, you will probably be able to put together your own Bpool tool minus his favorite working set simulation algorithm. For it's capabilities, it does not boast(unlike other available mega budget toolsets in the market which boast that they can dynamically determine what your pool size should be and then get into a lot of unexplained confusions) but really does a good simulation. Extremely great support because you talk to the brain behind the [...] 4092 21 30_Re: Questions for LOAD experts17_Walter Trovijo Jr18_wtrovijo@IG.COM.BR30_Thu, 2 Oct 2003 08:42:31 -0300322_iso-8859-1 My $0.02:

I´ve had performance problems in the past because the ICF catalog was defined as a shared catalog, when it was not needed to. There´s a lot more GRS processing to be done when ICF catalogs are shared. This can make a big difference for this number of datasets.

HTH, Walter Trovijo. [...] 4114 19 53_Changing EBCDIC codepage from one release to the next13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM30_Thu, 2 Oct 2003 06:58:21 -0500480_US-ASCII If you look in Appendix A of the Installation Guide for Version 7 there is a good explanation of the steps necessary to change the codepage.



Kathy Czepiel Grocers Supply kathleenczepiel@grocerybiz.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 4134 100 49_Re: Bufferpool Tool & BMC Pool Advisor Comparison14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Thu, 2 Oct 2003 08:38:37 -0400587_ISO-8859-1 Thanks for the kind comments Venkat. I'm not sure what you are refering to about a DBA Toolset. We have a workstation based graphics and analysis component that is included with the software. Aside from the presentation layer and graphics, this also performs the Cluster Analysis to show the user which objects belong together based on access type and wkset. Aside from simulation pool sizes, BPT also simulates the effect of moving objects into different pools, and/or creating a new pool and taking objects from other single or multiole pools coming into the new pool. [...] 4235 34 16_Logging XMLCLOBs13_Philip Nelson18_teamdba@SCOTDB.COM30_Thu, 2 Oct 2003 13:55:12 +0100413_- Guys,

The next thing I've come across while working with the XML Extender is that the XMLCLOB data type is defined as maximum size 2 gig. The maximum loggable size of a column is 1 gig.

XMLVARCHAR is 3k (too short for our purposes).

We want to take advantage of the XML Extender functionality but also want to log the column. In general we reckon the documents will be less than 100k. [...] 4270 185 17_Re: zero divide??12_Le BD Nguyen20_lnguyen@AHOLDUSA.COM30_Thu, 2 Oct 2003 09:09:53 -0400525_US-ASCII Glen,

Thanks for the information. Here is a excerpt from the SQL Reference manual:

Whether DEC31 or DEC15 is in effect for the operation DEC31 and DEC15 specify the rules to be used when both operands in a decimal operation have precisions of 15 or less. DEC15 specifies the rules which do not allow a precision greater than 15 digits, and DEC31 specifies the rules which allow a precision of up to 31 digits. The rules for DEC31 are always used if either operand has a precision greater than 15. [...] 4456 30 45_LOAD using TEMPLATE, Keeping the TAPE Mounted10_David Bird25_dbird@KEMPERINSURANCE.COM30_Thu, 2 Oct 2003 08:19:12 -0500461_- Using the new UNLOAD Utility with LISTDEF and TEMPLATE, I've unloaded a bunch of tablespaces to CART using STACK.

The load cards refer to a template that references the actual dataset name. So I don't have to specify the unload dataset in the JCL anymore.

The problem is after each load; the TAPE is rewound and mounted again. In the past I used JCL commands to keep the TAPE mounted. I tried using these same commands but I get the error: [...] 4487 133 30_ERWIN, DB2 OS/390, Db2 connect13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM30_Thu, 2 Oct 2003 09:31:52 -0400318_iso-8859-1

A while back, I had installed DB2 UDB on NT on my desktop and Db2 connect came along with it. The licence of DB2 has since expired. When I try to use the client configuration assistant to connect to DB2 OS/390 V5 with Erwin, it comes back with an SQL error which means a invalid licence code . [...] 4621 88 29_Re: [DB2EUG] Logging XMLCLOBs15_Jackson Reavill18_damcon2@US.IBM.COM30_Thu, 2 Oct 2003 10:07:06 -0400477_US-ASCII Hi Phil,

Don't know if 32k is long enough for you, but we were able to get away with just using normal data types such as varchar(32000). These seem to work just as well as the XML data types. There probably is some difference under the covers, but for XML generation and for inserting a whole XML doc into a single column for subsequent use of XPath to perform updates and deletes via XML, they work fine. So if 32k will suffice, just use varchar(32000). [...] 4710 159 34_Re: ERWIN, DB2 OS/390, Db2 connect16_Bhogale, Pushkar24_Bhogale.Pushkar@MBCO.COM30_Thu, 2 Oct 2003 09:25:16 -0500516_iso-8859-1 Hi Amit,

As for using ERwin, you would probably need DB2 connect license, if you are going to create the tables directly on the mainframe using ERwin Generate option. Generally I generate the DDL in a ' .txt' file on Windows and ship it to mainframe using the Smartterm FTP. Since I have to edit the DDL slightly before I create the table (especially for pri/sec quantity), this arrangement works very well. It is a very efficient process, if you are creating lots of tables at the same time. [...] 4870 181 36_Re: Stored Procudure Builder ASUTIME32_Poston, William L (COMFIN, ITSS)21_william.poston@GE.COM30_Thu, 2 Oct 2003 11:04:47 -0400446_iso-8859-1 Does any one know if ASUTIME Can be set as an environment variable in STORED Procedure Builder?

-----Original Message----- From: Isaac Yassin [mailto:yassini@BEZEQINT.NET] Sent: Wednesday, October 01, 2003 3:05 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Real Time Statistics



Hi, RTS Tablespaces are stopped. You may get DSNI035I message for that. Sorry for being late - getting ready for IDUG next week. [...] 5052 65 59_Re: Connecting to two DB2 subsystems from one COBOL program13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Thu, 2 Oct 2003 11:05:19 -0400452_iso-8859-1 Jim,

Are you saying the multiple connects can't be done using the DSN attach?

I have prototype code in which I'm doing the following and having problems.

1 Call storedProcedure 2 do other SQL 3 Connect to Location2 4 do some SQL 5 Call storedProcedure end

I don't see anything I'm doing wrong having read and re-read the Appl pgming & SQL guide. I have also put release and commit as step 2B with no effect. [...] 5118 180 34_Re: ERWIN, DB2 OS/390, Db2 connect13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM30_Thu, 2 Oct 2003 11:32:26 -0400292_iso-8859-1 Hi Pushkar, I was trying to use the reverse engineering option using ERWIN. I do have other options like the RC/Migrator on the mainframe, but I guess this means that without DB2 connect it is not possible to use any windows based data modelling tool to get to the mainframe. [...] 5299 176 34_Re: ERWIN, DB2 OS/390, Db2 connect14_Dingman, Randy25_RGDingman@AAAMICHIGAN.COM30_Thu, 2 Oct 2003 12:05:26 -0400319_iso-8859-1 RC/Migrator can extract the DDL, which can then be ftp'ed (Ascii mode) to the Windows platform. This file can then be reverse engineered in to ErWin. We do it all the time. We are using BMC admin products right now, but used to use RC/Migrator. I doubt that the CA folks have removed that functionality [...] 5476 191 34_Re: ERWIN, DB2 OS/390, Db2 connect16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM30_Thu, 2 Oct 2003 12:11:28 -0400527_iso-8859-1 While I do not how ERWIN works, generally speaking many products use the drivers/ODBC that are included within DB2 connect to facilitate communication between 'it' and DB2.

Unless Erwin supply their own, you will need DB2 connect.











Tel: +1 905 803 8600 Toll Free: +1 800 348 8299 Fax: +1 905 803 8603 Quebec: +1 877-281-1888 Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 V7 Database Administration [...] 5668 21 17_ACTIVATE DATABASE15_Stephen Poulsen36_stephen.r.poulsen@CO.MULTNOMAH.OR.US30_Thu, 2 Oct 2003 11:16:59 -0500596_- After implementing a small Unix DB2/UDB OLTP application in archive log mode with just a few users, we noticed that many small log files were being cut for the application all day long. Apparently when the "last" user disconnects, the database "goes to sleep" and then when the next user connects, the database awakens and a new log is cut. This has lead us to the ACTIVATE DATABASE command which apparently will take care of this problem and may even eliminate a startup overhead that is happening repeatedly. Our questions are, where and when should the ACTIVATE DATABASE and DEACTIVATE [...] 5690 63 21_Re: ACTIVATE DATABASE18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Thu, 2 Oct 2003 12:32:54 -0400398_US-ASCII Your assumptions are correct about the activate database command. It will eliminate the overhead and cost of a connection to the database. Anytime the instance is stopped, you should issue the activate database command. We also use the following sequence when doing an offline backup of our databases: force all users off, deactivate, offline backup, activate. Works pretty smoothly. [...] 5754 48 21_Re: Replication tools11_Rob Barbour22_rbarbour@ESAIGROUP.COM30_Thu, 2 Oct 2003 12:51:38 -0400256_us-ascii HotCopy http://www.esaigroup.com/products/delivery.htm allows you to deliver not only DB2, but IMS, and VSAM data too. It delivers to other s/390s, Unix, NT, etc. Low overhead, immediate or scheduled delivery are some added niceys.



5803 73 21_Re: Replication tools16_Farnsworth, Dave31_DFarnsworth@ASHLEYFURNITURE.COM30_Thu, 2 Oct 2003 12:00:37 -0500618_iso-8859-1 The replication tool we use is called Symbiator from Vision Solutions. We use it to replicate data between DB@, Oracle and SQL Server. It seems to work alright.

Dave

-----Original Message----- From: Rob Barbour [mailto:rbarbour@ESAIGROUP.COM] Sent: Thursday, October 02, 2003 11:52 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Replication tools



HotCopy http://www.esaigroup.com/products/delivery.htm allows you to deliver not only DB2, but IMS, and VSAM data too. It delivers to other s/390s, Unix, NT, etc. Low overhead, immediate or scheduled delivery are some added niceys. 5877 65 21_Re: Replication tools15_Goldberg, Carol26_Carol.Goldberg@ACS-INC.COM30_Thu, 2 Oct 2003 13:21:02 -0400515_iso-8859-1 You might want to check out informatica also.





-----Original Message----- From: Rob Barbour [mailto:rbarbour@ESAIGROUP.COM] Sent: Thursday, October 02, 2003 12:52 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: [DB2-L] Replication tools



HotCopy http://www.esaigroup.com/products/delivery.htm allows you to deliver not only DB2, but IMS, and VSAM data too. It delivers to other s/390s, Unix, NT, etc. Low overhead, immediate or scheduled delivery are some added niceys. 5943 30 59_Re: Connecting to two DB2 subsystems from one COBOL program9_Jim Ruddy18_jaruddy@US.IBM.COM30_Thu, 2 Oct 2003 12:18:42 -0500320_- There are two very different types of connect. The type I was referring to is the type of connect done by the attaches and you can only be attached to a single DB2 at one time.

The type you were referring to is the SQL CONNECT which connects via DRDA to another DB2. You will already be attached to a DB2. [...] 5974 45 39_DB2 UDB security flaws in DB2 Connect ?10_Vinson Lee19_vlee@SDCCD.CC.CA.US30_Thu, 2 Oct 2003 10:34:52 -0700716_iso-8859-1 I just got the following news from a SEARCHDATABASE.COM newsletter: =========================================================================== ============== The security firm Application Security Inc. reported this week that IBM's DB2 Universal Database and MySQL AB's MySQL open-source database have a total of three vulnerabilities that range from low- to high-risk levels. The first DB2 weakness is a buffer overflow in db2dart. This entails a UDP service used for discovery of DB2 databases on a network. The UDP service is overwhelmed when more than 20 bytes of information are sent. All versions of DB2 are affected, although the risk level is only medium. The fix is [...] 6020 26 21_Identity Column Usage15_Joseph, Michael27_Michael.Joseph@CAREMARK.COM30_Thu, 2 Oct 2003 12:53:07 -0500578_iso-8859-1 Hello List

We are considering using an identity column to relieve contention problems we are having on a one row table that we use to generate a common key value. All looks good on paper but, I was hoping to get some feedback from anyone who has similar experience. Specifically, has anyone used an identity column in like manner to address contention problems and has it helped? Are there any pitfalls you encountered? We are at version 6 soon to migrate to version 7. I have heard that there were some version 6 issues with identity columns but I'm not [...] 6047 65 25_Re: Identity Column Usage12_McKown, John22_JMckown@UICIINSCTR.COM30_Thu, 2 Oct 2003 12:59:34 -0500180_- Joseph, I know that you said you're going to V7. But there is a very nice new feature in V8 called a sequence. It is designed for just this sort of thing.





6113 84 21_Re: Replication tools8_Ron Root24_ron.root@CPA.STATE.TX.US30_Thu, 2 Oct 2003 13:10:25 -0500450_iso-8859-1 Informatica now owns the Striva product that captures changes from IMS, VSAM and DB2 and delivers them to other s/390s, Unix, NT, etc.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Goldberg, Carol Sent: Thursday, October 02, 2003 12:21 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Replication tools



You might want to check out informatica also. [...] 6198 38 29_Triggers issuing an SQL CALL.13_Michalik, Ken19_kmichalik@KRAFT.COM30_Thu, 2 Oct 2003 14:58:59 -0500348_iso-8859-1 I've looked through the available documentation and have come up dry on this one...

When calling a stored procedure from a trigger, it doesn't seem to me that there could be OUT parameters in the parameter signature of the stored procedure, since I can't think of a way to set up a 'host variable' in the trigger body. True? [...] 6237 68 33_Re: Triggers issuing an SQL CALL.10_Price, Ray18_Ray.Price@DRKW.COM30_Thu, 2 Oct 2003 21:23:56 +0100463_- Ken,

You can return an SQLSTATE if you use PARAMETER STYLE DB2SQL. There are examples in the manual.

Ray Price. DBA Dresdner Kleinwort Wasserstein London



-----Original Message----- From: Michalik, Ken [mailto:kmichalik@KRAFT.COM] Sent: 02 October 2003 20:59 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Triggers issuing an SQL CALL.



I've looked through the available documentation and have come up dry on this one... [...] 6306 70 33_Re: Triggers issuing an SQL CALL.12_Bob Galeotti22_bgaleotti@SOFTBASE.COM30_Thu, 2 Oct 2003 16:33:10 -0400773_iso-8859-1 Hi Ken, Check out the slides before and after this link: http://www.share.org/proceedings/sh98/data/S1324.PDF

HTH,

Bob Galeotti, Sales Tech Support SoftBase Systems, Inc. 800.669.7076 x372 bgaleotti@softbase.com http://www.softbase.com/

----- Original Message ----- From: "Michalik, Ken" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, October 02, 2003 3:58 PM Subject: Triggers issuing an SQL CALL.



> I've looked through the available documentation and have come up dry on this > one... > > When calling a stored procedure from a trigger, it doesn't seem to me that > there could be OUT parameters in the parameter signature of the stored > procedure, since I can't [...] 6377 71 33_Re: Triggers issuing an SQL CALL.14_Picou, Michael33_picou.michael@MAIL.DC.STATE.FL.US30_Thu, 2 Oct 2003 16:39:14 -0400403_iso-8859-1 In your SP, in the linkage section, code an 01 level for each passed parm, then code an 01 level parm as pic s9(4)comp. (this is a null indicator) for each passed parm, then code an 01 level parm (I used P-SQLSTATE) as pic x(5) if you encounter an error in the SP, set this parm (P-SQLSTATE) to a 38*** value (I use 38006). The Trigger will pick this up as an error state and roll back. [...] 6449 102 34_Re: REORG with UNLOAD DISCARD v7.113_Horacio Villa17_hvilla@AR.IBM.COM30_Thu, 2 Oct 2003 18:12:23 -0300410_US-ASCII We noticed the same thing with UNLOAD. I think it works if you put the columns in the WHERE clause in ascending colno order. Don't know if there is an APAR.

Horacio Villa







Dan Diehl cc: Sent by: DB2 Data Subject: REORG with UNLOAD DISCARD v7.1 Base Discussion List [...] 6552 63 41_Re: RECOVERY TORBA/TOCOPY Dataset vol-ser14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Fri, 3 Oct 2003 08:11:21 +1000325_US-ASCII I've never tried this, but it occurs to me that since you can provide explicit DD statements for image copy datasets in a recovery, if you provided the appropriate DDs then DB2 might just use what you provided - and not actually look at the OS catalog.

They would still need to be registered in SYSCOPY. [...] 6616 13 34_Re: REORG with UNLOAD DISCARD v7.19_Jim Ruddy18_jaruddy@US.IBM.COM30_Thu, 2 Oct 2003 17:45:35 -0500331_- APAR PQ77231 fixes UNLOAD also.

Jim Ruddy DB2 for z/OS Development

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 6630 24 17_Bufferpool tuning10_Teldb2kals22_teldb2kals@TELSTRA.COM30_Thu, 2 Oct 2003 17:51:07 -0500543_- Hi,

Can somebody provide me tips on determining the initial size of the individual pools when I split an existing bufferpool into multiple pools based on the usage ? I realise that we can tune them further based on continued performance stats, but how do we arrive at an estimate for the initial sizing ? I don't want to cause any immediate performance impact by specifying too small a size for any of the split pools. I couldn't find any guidelines for the initial sizing in the documents/whitepapers I have looked at till now. [...] 6655 47 20_Re: Logging XMLCLOBs12_Cianci, Nick19_nick.cianci@EDS.COM30_Fri, 3 Oct 2003 11:18:11 +1000320_- As an addendum,

I'd be interested to here about the performance impact of logging a Gbyte (Update / Insert / Delete).

We "will" have XML, of circa 100Mbytes, being stored in a CLOB and I am having nightmares every time I think about logging it. Are my fears justified?

Cheers, Nick F. Cianci [...] 6703 47 41_Re: RECOVERY TORBA/TOCOPY Dataset vol-ser11_Lee Mandell16_DBMSUser@AOL.COM28_Thu, 2 Oct 2003 22:01:07 EDT524_US-ASCII Ravi, Their is a tool that will give you a list of syscopy entries about a specified tablespace and you simple pick and chose what dataset and what kind of recovery you wish to use from an ISPF panel. visit:www.recoveryknowledge.com

Hope this help Lee.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 6751 38 22_DB2 Software Libraries16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM30_Thu, 2 Oct 2003 22:43:43 -0700545_us-ascii Hi !!

I had been under the impression that all the DB2 software is installed in SDSNLOAD and SDSNEXIT libraries. However, yesterday I noticed the following among several others like this, which seemed to have some connection to DB2 software code:

SDXXADM ADMBLOAD ADMBLOA2

What are these datasets and what do they contain? If they too contain DB2 software, how does DB2 'know' about them, the same way as DB2 knows about SDSNLOAD and SDSNEXIT datasets as they are mentioned in the DB2 startup JCL for ssnMSTR. [...] 6790 144 12_Re: Holddata16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM30_Thu, 2 Oct 2003 22:46:01 -0700352_us-ascii Hello Mark,

Appreciate your reply. I agree with you that it doesn't matter whether Holddata was received from ESO tapes prior to receiving it from PSP files. But if you read the last paragraph in SMP/E User's guide in section "Example of Processing HOLDDATA" in Chapter 8 (this is also the last paragraph of the chapter), it says: [...] 6935 33 19_DB2 V7 Sqlcode -22812_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Thu, 2 Oct 2003 14:11:59 -0400289_us-ascii Hi All, We migrated our DB2 test subsystems this past weekend. Today a client running from Peoplesoft started receiving Sql Code -228 in a declare cursor that had run fine within DB2 V6. Amy other Peoplesoft shops run into this and if so how did you get around it? TIA, Jeff [...] 6969 16 51_Jerry A Young/USA/StateStreet is out of the office.11_Jerry Young23_jayoung@STATESTREET.COM30_Fri, 3 Oct 2003 02:58:19 -0400492_us-ascii I will be out of the office starting 10/02/2003 and will not return until 10/06/2003.

For EDR support contact Lauren Wong. For DB2 Connect issues contact Alex Frayberg. I will respond to all other requests when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 6986 54 28_Antwort: DB2 V7 Sqlcode -2289_Dirk Pohl19_dirk.pohl@SERCON.DE30_Fri, 3 Oct 2003 08:43:50 +0200622_ISO-8859-1 Am 02.10.2003 20:11:59 schrieb DB2 Data Base Discussion List: > Hi All, > We migrated our DB2 test subsystems this past weekend. Today a client running > from Peoplesoft started receiving Sql Code -228 in a declare cursor that had > run fine within DB2 V6. Amy other Peoplesoft shops run into this and if so how > did you get around it? > TIA, > Jeff ================================================ To change your > subscription options or to cancel your subscription visit the DB2-L webpage at > http://listserv.ylassoc.com. The owners of the list can be reached at > DB2-L-REQUEST@listserv.ylassoc.com. [...] 7041 139 20_Re: Logging XMLCLOBs14_Nelson, Philip34_Philip.Nelson@SCOTTISHWIDOWS.CO.UK30_Fri, 3 Oct 2003 09:29:36 +0100374_iso-8859-1 This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should notify the sender immediately by telephone on 0131-655-6789 and must delete the original E-Mail without taking a copy. If you are not the addressee you must not copy, distribute, disclose or use any of the information in any way. [...] 7181 24 19_CICS vs DB2 Connect12_Bob Jeandron21_bob.jeandron@USDA.GOV30_Fri, 3 Oct 2003 07:24:06 -0500573_- Recently we had consultants in to review a problem app. The app. is java based running on windows web server, calling CICS transactions onto DB2 on ZOS. DB2 V7.1, ZOS 1.2, CICS 2.2. There were problems found with the app., which they addressed. They also made comments, referencing DB2 Connect and its ability to handle thousands of users. It was said that CICS was a much better way to go for our eventual/possible 500,000 users, mostly 2 days a week every 2 weeks. AND, DB2 Connect should not be "turned loose" because it could bring ZOS down. This was disturbing [...] 7206 53 23_Re: DB2 V7 Sqlcode -2280_27_sue.cloutier@CUNAMUTUAL.COM30_Fri, 3 Oct 2003 07:41:48 -0500451_US-ASCII Jeff,

We experienced this same issue with PeopleSoft when we upgraded DB2 to V7. Try adding "PATCH2=6" to your DB2CLI.INI file, it did the trick for us.

Sue Cloutier Database Administration CUNA Mutual Group









Jeff Frazier To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 V7 Sqlcode -228 Sent by: DB2 Data Base Discussion List [...] 7260 61 26_Re: DB2 Software Libraries10_Lisa Bates29_Lisa.Bates@ROCKETSOFTWARE.COM30_Fri, 3 Oct 2003 08:43:28 -0400349_iso-8859-1 Raquel, The SDXX* libs are for the DB2 XML extender, and the SDMB* libs are the image extenders. If you did implement these features, instructions in the config/install for these features would direct you to where and what tasks need those libraries allocated. Using those features to their potential is a non-trivial exercise. Lisa [...] 7322 45 21_Re: Bufferpool tuning14_Dingman, Randy25_RGDingman@AAAMICHIGAN.COM30_Fri, 3 Oct 2003 09:07:25 -0400437_iso-8859-1 Depends entirely upon your memory resources available, and how your pagesets behave (i/o patterns). I would suggest investigating the DISPLAY BUFFERPOOL command in detail. Several people have published white papers and guides including Chuck Hoover of Compuware. You should find this somewhat dated reference material at the Compuware site, I don't know if it has been updated recently. There are several others as well. [...] 7368 13 0_12_Bob Jeandron21_BOB.JEANDRON@USDA.GOV30_Fri, 3 Oct 2003 09:56:17 -0400394_- This message is a Read Receipt Notification

Your Message : Was Read By : BOB.JEANDRON@usda.gov On : Fri, 3 Oct 2003 8:54:00 -0400

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 7382 33 60_os/390 - monitoring distrib. connections with single uid/pwd6_Daniel15_bufes@YAHOO.COM30_Fri, 3 Oct 2003 08:51:15 -0500572_- Hi, I would like to monitor a (web) application, that is running on Windows, connects through DB2 Connect to DB2/390 using sigle user account. Let's say I would like to know which branch office is currently connected. On a -display thread(*) output I see many connections, but have no idea which one is for which branch office. What I found is that an application can set accounting string (on Windows) using DB2ACCOUNT variable or using sqlesact, so I can set it to a branch office name/id. That's great, but I still can't see that string in -dis thd(*) command - [...] 7416 105 21_Re: ACTIVATE DATABASE14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM30_Fri, 3 Oct 2003 09:40:00 -0500616_us-ascii Sorry to be picky, but ACTIVATE DATABASE does not eliminate the overhead and cost of a connection to the database. What it does eliminate is the additional overhead and cost of that first connection to a database that is not already open, the additional overhead and cost being caused by the need to initialize the database. And ACTIVATE DATABASE will cause the database to remain open even when all applications have disconnected. But there is still an overhead involved in making a database connection to an open database, which is one reason some applications benefit from using connection pooling. [...] 7522 66 23_Re: CICS vs DB2 Connect13_Tom Duerbusch26_DuerbuschT@STLOUISCITY.COM30_Fri, 3 Oct 2003 09:59:37 -0500285_US-ASCII I would think that most of the resources used by DB2 Connect are at its own server (assuming you have a server license and not using individual copies). If the DB2 Connect Server is running on the mainframe, that will eat cycles, just doing the work it is suppose to do. [...] 7589 48 12_Re: Holddata11_Mark Ediger22_MEDIGER@TRANSUNION.COM30_Fri, 3 Oct 2003 10:09:52 -0500629_US-ASCII Hi Raquel,

Good point, in that context. I certainly hope you are not entering the HOLD data by hand, though. You can FTP the latest Extended HOLDS from IBM and receive them directly from the FTP file.

Mark

>>> raquel_rodriguezus@YAHOO.COM 10/3/2003 12:46:01 AM >>> Hello Mark,

Appreciate your reply. I agree with you that it doesn't matter whether Holddata was received from ESO tapes prior to receiving it from PSP files. But if you read the last paragraph in SMP/E User's guide in section "Example of Processing HOLDDATA" in Chapter 8 (this is also the last paragraph of the chapter), [...] 7638 70 64_Re: os/390 - monitoring distrib. connections with single uid/pwd12_tim malamphy20_timalamphy@YAHOO.COM30_Fri, 3 Oct 2003 08:42:10 -0700584_us-ascii the LUWID returned by the -dis thread command can be translated into a real IP address. Would this be useful in identifying a particular branch/location? I sometimes ping the IP address to get a more meaningful domain name when tracking down miscreants. tim --- Daniel wrote: > Hi, > I would like to monitor a (web) application, that is > running on Windows, > connects through DB2 Connect to DB2/390 using sigle > user account. > Let's say I would like to know which branch office > is currently connected. > On a -display thread(*) output I see many [...] 7709 52 21_Sporadic Broken Pages14_Richard Arnold27_richard.arnold@JPMCHASE.COM30_Fri, 3 Oct 2003 10:30:48 -0500724_- Hello,

DB2 V7, put 0211. OS 390 2.10.

DASD is EMC Symmetrix, with DASD mirroring using EMC SRDF; sometimes in adaptive copy, sometimes in semi-synchronous mode.

One of our subsystems has been experiencing sporadic broken pages. Here are the log messages:

23.20.35 STC00429 DSNJ139I -D2D$ LOG OFFLOAD TASK ENDED 23.28.02 STC00429 DSNB224I -D2D$ DSNB1AEX - BUFFER MANAGER I/O ERROR DURING READ DBNAME=DTSDP001 SPACENAME=DTSSDCL0 DATA SET NUMBER=1 PAGE NUMBER=X'00000750' MM ERROR FLAG=X'14' CSW STATUS=X'0C40' SENSE BYTES=X'0000' SEEK ADDRESS=X'0000000069000600' 23.28.02 STC00429 DSNT500I -D2D$ DSNUGRAR RESOURCE UNAVAILABLE REASON 00C200F8 TYPE 00000300 NAME DTSDP001.DTSSDCL0.X'00000750' [...] 7762 85 25_Re: Sporadic Broken Pages14_Grainger, Phil20_Phil.Grainger@CA.COM30_Fri, 3 Oct 2003 16:55:07 +0100543_iso-8859-1 but surely CDB are not reading the data through the buffer manager? Are you sure this isn't a red herring??

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





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Richard Arnold Sent: Friday, October 03, 2003 4:31 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: [DB2-L] Sporadic Broken Pages [...] 7848 103 25_Re: Sporadic Broken Pages0_17_sjvagnier@AEP.COM30_Fri, 3 Oct 2003 11:59:59 -0400316_us-ascii Richard, I would check with CDB Copy vendor just to see if anyone else has reported the same problem. What happens if you correct the broken pages, and use IBM's tool to do the copy for a extended period of time? Do you still have broken pages? This may be a way of ruling out CDB Copy as the culprit. [...] 7952 115 25_Re: Sporadic Broken Pages15_Aurora Dellanno33_Aurora.DellAnno@BANKOFAMERICA.COM30_Fri, 3 Oct 2003 17:10:36 +0100535_- Hello Richard,

I had a look around and I found a few items containing the message DSNUGRAR RESOURCE UNAVAILABLE actually.

The other messages are likely to be misleading, because they depend on whatever program error caused the first one anyway.

All the apars I found had to do with DB2 V7 and image copies, so if I were you I'd call your local friendly IBM Support Centre (yeah never mind whether they've outsourced it to Mars or Saturn's 8th ring, you know what I mean), and get them to get me my ol' fix. [...] 8068 109 64_Re: os/390 - monitoring distrib. connections with single uid/pwd13_Martin Packer24_martin_packer@UK.IBM.COM30_Fri, 3 Oct 2003 17:32:29 +0100442_us-ascii That implies you know how to "unpack" the IP address from LUWID. :-)

And that might not give you enough granularity with some of the complex setups out there.

In my opinion the whole "DDF data in Accounting Trace" area is darned confusing - but I quite like that. :-)

Martin

Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584) [...] 8178 41 21_Re: Bufferpool tuning17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM30_Fri, 3 Oct 2003 12:32:24 -0500439_- It depends on several factors.

Pool characteristic depends on Access pattern and the average no of hot pages (Working size) for an object in the pool.

To start, a very basic dependency is in the number of pages and how much average is the working set size for the objects, the number of such objects in the pool. If you are allocating the pool for spl purposes such as lookups / read only small pagesets it will vary. [...] 8220 160 40_DSNTEJ2U - ALTDATE,ALTTIME,WHEATHER UDFs13_Michael Ebert18_mebert@AMADEUS.NET30_Fri, 3 Oct 2003 20:02:14 +0200675_us-ascii Hi all,

currently I'm migrating our DB2 subsystems to V7. The migration itself seems to be going ok, but I have problems with running DSNTEJ2U - the ALTDATE, ALTTIME and WHEATHER UDFs. The first three SELECTs in step PH01US12 are ok, the 4th gives one type of error:

SELECT DSN8.ALTDATE( '11 November 1918', 'DD MONTH YYYY', 'YYYY/MM/DD' ) FROM SYSIBM.SYSDUMMY1; SQLERROR ON SELECT COMMAND, FETCH FUNCTION RESULT OF SQL STATEMENT: DSNT408I SQLCODE = -450, ERROR: USER-DEFINED FUNCTION OR STORED PROCEDURE ALTDATE, PARAMETER NUMBER 008, OVERLAYED STORAGE BEYOND ITS DECLARED LENGTH DSNT418I SQLSTATE = 39501 SQLSTATE RETURN CODE DSNT415I SQLERRP = [...] 8381 91 41_Datawarehouse on DB2 - mainframe x zlinux19_Luiz Roberto FORONI27_lforoni@CAIXASEGUROS.COM.BR30_Fri, 3 Oct 2003 15:02:28 -0300305_iso-8859-1 Hi listers,

I would like to know what is the best solution: to put a datawarehouse (600 GB) in DB2 OS/390, sharing the machine with my OLTP environment in another LPAR or in DB2 UDB for Linux in Z-Linux in another machine ? What are advantages and disadvantages in both solutions ? [...] 8473 44 23_Seibel 7 and DB2 on ZOS12_John Morford26_John_K_Morford@KEYBANK.COM30_Fri, 3 Oct 2003 14:10:29 -0500539_- Hi,

I have been tasked with creating a new DB2 V7 datasharing group that we will be installing Seibel 7 in. We are brand new to Seibel and I'm wondering how other Seibel 7 users are configured.

Our production DB2 footprint contains several datasharing groups spread across 4 LPARs. The DB2 loadlibs & exit library are defined in the linklist of each ZOS system. We run all of our batch without JOBLIBs. Each DB2 subsystem is defined with a STEPLIB concatenation for DB2 loadlibs, exit lib, and the LE SCEERUN library. [...] 8518 17 36_Steve Westfall is out of the office.14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM30_Fri, 3 Oct 2003 15:41:16 -0400444_us-ascii I will be out of the office starting 10/03/2003 and will not return until 10/06/2003.

(Please ignore. This is just a test of the Out-of-Office agent.)

Steve Westfall

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 8536 23 36_Load with TEMPLATE SYSCOPY STACK YES13_Horacio Villa17_hvilla@AR.IBM.COM30_Fri, 3 Oct 2003 16:45:28 -0300385_US-ASCII Dear list,

I'm running several LOADs in one execution of DSNUTILB, with TEMPLATE SYSCOPY STACK YES at the beginning of SYSIN, then each LOAD with COPYDDN SYSCOPY. But STACK YES doesn't work. It asks for a new tape each time. Has anybody worked this out? I was also forced to put COPYDDN SYSCOPY on each LOAD, I thought that as it was default, it wasn't necessary. [...] 8560 68 40_Re: Load with TEMPLATE SYSCOPY STACK YES12_Orcutt, Tedd16_Orcutt@AAFES.COM30_Fri, 3 Oct 2003 15:14:18 -0500355_iso-8859-1 We encountered several 'bugs' in DB2 z/OS Version 7 IBM utilities. Don't know if the one you are encountering is related to any of them. Some of the fixes produced other bugs, but in the end all was resolved after applying the following:

PTF resolves a duplicate keyword issue with the utilities that was introduced by PTF UQ62321. [...] 8629 124 56_Setting up DB2/OS390 to act as DRDA AR to DB2 UDB on AIX18_Stritzinger, David28_David.Stritzinger@ALTRIA.COM30_Fri, 3 Oct 2003 15:29:53 -0400500_iso-8859-1 List Members,

My environment is DB2 V7.1 on OS/390 2.10 and DB2 UDB 8.1 fixpack 2++ on AIX 5.1. I am trying to set up the environment so that I can go from the mainframe to the AIX server, i.e. set up DB2/OS390 as the DRDA AR. I am using TCP/IP. I have gone through the list achieves and found how some others have set up this to work, I am using the DB2 connect student guide that one of my colleges has from class, and also referencing the Redbook WOW! DRDA Supports TCP/IP. [...] 8754 87 40_Re: Load with TEMPLATE SYSCOPY STACK YES15_Robert Lawrence21_rlawrence@BOSCOVS.COM30_Fri, 3 Oct 2003 16:43:37 -0400643_iso-8859-1 Also PTF UQ73709 which SUPs UQ71961 among others

Bob Lawrence DBA Boscov's Dept Stores LLc





> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Orcutt, Tedd > Sent: Friday, October 03, 2003 4:14 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: Load with TEMPLATE SYSCOPY STACK YES > > > We encountered several 'bugs' in DB2 z/OS Version 7 IBM utilities. Don't know > if the one you are encountering is related to any of them. Some of the fixes > produced other bugs, but in the end all was resolved after applying the following: > [...] 8842 16 51_DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2)10_Bob Tinkle22_bob.tinkle@ACS-INC.COM30_Fri, 3 Oct 2003 15:31:16 -0500524_- Does anyone have DB2 V7 running on a 0S/390 2.10 in 64 bit mode? What about experience with OEMs in same environment

Appreciate any comments as we are moving in this direction pretty quickly due to SERIOUS Central storage constraints/issues.

Bob Tinkle

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 8859 49 20_Re: Logging XMLCLOBs13_Patric Becker25_Patric_Becker@SIS-WEST.DE30_Fri, 3 Oct 2003 16:25:00 -0500534_ISO-8859-1 Nick,

from IBM´s redbook page (search for 'large objects', it´s from the TIPS-document) :

> LOG NO vs LOG YES > LOG NO improves performance in terms of CPU > and I/O time with INSERT and LOAD. This improvement > is only 5% for 1 KB LOBs, but grows to 10% with 30 KB > LOBs, and it will go up with the size of the LOB. > Depending on your application, and your back-up > capabilities, you might be able to avoid the impact > of logging on the LOB and the other concurrent > applications by specifying LOG [...] 8909 65 55_Re: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2)13_Martin Packer24_martin_packer@UK.IBM.COM30_Fri, 3 Oct 2003 22:32:07 +0100370_us-ascii Just thinking back over my past few client engagements...

1 went to 64 bit and exploited Dataspace for their buffer pools (and for Prepared Statement Cache) as they have Virtual Storage constraints. The other one that went to 64 bit stuck with virtual pools as their subsystems aren't that big but they, like you, needed central storage constraint. [...] 8975 145 25_Re: Identity Column Usage13_Fleming, Mark21_MFLEMING@ALLSTATE.COM30_Fri, 3 Oct 2003 16:25:07 -0500585_iso-8859-1 Mike,

I have experience with identity columns. We developed a common stored procedure to handle this for everyone. The concept is this: a table is used for the sequence number, but that table is just a means to an end; and a common stored procedure is used to managed the table. Users wanting a sequence value pass the routine the table name and get in return the next value. Behind the scenes, the procedure inserts a row to the table, uses the identity_val_local() built-in function to retrieve the value, deletes the row, and returns the value to the caller. [...] 9121 76 33_Re: Triggers issuing an SQL CALL.13_Fleming, Mark21_MFLEMING@ALLSTATE.COM30_Fri, 3 Oct 2003 16:29:49 -0500479_iso-8859-1 Ken,

Set up your procedure with PARAMETER STYPE DB2SQL. This give you access to the SQLSTATE. You can set the SQLSTATE to indicate a failure, if you will. You cannot pass parameters from a procedure to a trigger, but you can cause the trigger to fail by making the procedure fail. There are set conventions on what SQLSTATE values can be used, but they seem flexible enough for this purpose. Check out the Application Programming and SQL Guide. Good luck. [...] 9198 13 53_Matthias Inhelder/Australia/IBM is out of the office.17_Matthias Inhelder20_minhelde@AU1.IBM.COM30_Sat, 4 Oct 2003 16:37:10 +1000360_US-ASCII I will be out of the office starting October 4, 2003 and will not return until October 8, 2003.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 9212 196 34_Re: ERWIN, DB2 OS/390, Db2 connect2_ED31_emaddanish@SAUDIAIRLINES.COM.SA30_Sat, 4 Oct 2003 09:52:14 +0300482_ISO-8859-1 ERWIN, DB2 OS/390, Db2 connectDear Amit, As long as I know, YES, you need DB2 Connect in order to let ErWin access DB2 on OS/390.

Regarding DB2 Connect separatley, YES, DB2 Connect comes either alone or bundled within DB2 UDB. Again, as long as I know, for DB2 UDB you must purchase a license, BUT for DB2 Connect you don't have to purchase, DB2 Connect is available for free from IBM. You may download it from IBM's site. That's to the best of my knowledge. [...] 9409 42 5_SMP/E16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM30_Sat, 4 Oct 2003 09:23:48 -0700466_us-ascii Hello!!

I received the following error message while attempting to Apply PTF P1:

"THIS SYSMOD DOES NOT PRE OR SUP U1, THE RMID OF SRC S1 THAT IS CURRENTLY INSTALLED."

Could someone let me know what this error message means? This is what I understand:

PTF P1 that I am installing is trying to replace SRC S1 in the target zone, but per the MCS of P1, it does not SUPersede U1 (U1 being the SYSMOD that last replaced SRC S1). [...] 9452 60 9_Re: SMP/E15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM30_Sat, 4 Oct 2003 19:51:09 +0200381_us-ascii On Sat, 4 Oct 2003 09:23:48 -0700 Raquel Rodriguez wrote:

:> I received the following error message while :>attempting to Apply PTF P1:

:>"THIS SYSMOD DOES NOT PRE OR SUP U1, THE RMID OF SRC :>S1 THAT IS CURRENTLY INSTALLED."

:> Could someone let me know what this error message :>means? This is what I understand: [...] 9513 49 12_Abend E37-0813_Horacio Villa17_hvilla@AR.IBM.COM30_Sat, 4 Oct 2003 16:33:50 -0300714_US-ASCII Hi,

this may be pretty easy, but I can't find the answer. I'm running an online REORG INDEX with SYSIN like this:

TEMPLATE SUX1 UNIT(SYSDA) MAXPRIME(4369) DATACLAS(MULTI) VOLCNT(10) DISP(NEW,DELETE,DELETE) DSN(BKDSPG.&DB..&SN..SUX1)

REORG INDEX LIST LISTATS SHRLEVEL CHANGE MAXRO 10 STATISTICS KEYCARD UPDATE ALL SORTDEVT DBATMP SORTNUM 8 WORKDDN (SUX1)

Then I get the abend:

IEC614I EXTEND FAILED - RC 216, DIAGNOSTIC INFORMATION IS (044E0097) |----------+--------+-----------+----------+----------------------------------| | X'04' | X'4E' | X'00' | X'97' | Requested space exceeds 65535 | | | | | | tracks for a data set type that | | | | | | is limited to 65535 [...] 9563 30 19_CICS vs DB2 Connect13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM30_Mon, 6 Oct 2003 08:06:25 -0500608_US-ASCII Distributed applications that are improperly terminated from the desktop while using DB2 Connect can continue to run from the DB2 Connect server causing the mainframe DDF to really hog cycles. We have seen this happen in our shop more than once and it required that we terminate the thread from the mainframe side. This may be the reason that the consultants were hestitant to recommend that DB2 Connect be "turned loose" for your application. For my two sense, where possible, the simpler the connections between platforms and apps the easier to debug the problem when the phone rings at 2am. [...] 9594 11 16_Re: Abend E37-0822_Naidoo, Rama [IBM GSA]28_Rama.Naidoo@TEAM.TELSTRA.COM30_Mon, 6 Oct 2003 14:15:42 +1000257_us-ascii ================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 9606 107 25_Re: Sporadic Broken Pages12_Simon George20_simon.george@UBS.COM30_Mon, 6 Oct 2003 10:26:36 +0100394_iso-8859-1 Hi,

We've just had a very similar problem on one of our development LPAR's. The codes are not identical but ours was caused by recently applied z/OS maintenance and a incompatibility with the EMC microcode (we also have HDS dasd and that was not affected). The problem was right down at the media manager level and also affected our MQ page datasets on similar hardware. [...] 9714 53 55_Re: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2)14_Richard Arnold27_Richard.Arnold@JPMCHASE.COM30_Mon, 6 Oct 2003 07:21:29 -0500414_us-ascii we are running 64 bit mode.

Our OEMs, IBM Admin tool, DB2 PM, CDB Utilities, and Omegamon for DB2 are running fine. No problems so far (knock on wood).









Bob Tinkle cc: Sent by: DB2 Data Subject: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2) Base Discussion List [...] 9768 37 64_Re: os/390 - monitoring distrib. connections with single uid/pwd6_Daniel15_bufes@YAHOO.COM30_Mon, 6 Oct 2003 08:27:27 -0500514_- On Fri, 3 Oct 2003 17:32:29 +0100, Martin Packer wrote:

>That implies you know how to "unpack" the IP address from LUWID. :-) > >And that might not give you enough granularity with some of the complex >setups out there. > >In my opinion the whole "DDF data in Accounting Trace" area is darned >confusing - but I quite like that. :-) > >Martin > >Martin Packer, MBCS Martin Packer/UK/IBM >020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile >07802-245584) [...] 9806 208 24_Re: Real Time Statistics10_Rick Miles25_rick.miles@CUNAMUTUAL.COM30_Sun, 5 Oct 2003 14:59:12 -0500610_US-ASCII The following is the response from an IBM'er regarding RTS. If there are bugs with this that impact storage management, then I expect you are still impacted from them even after stopping the database...

Hi Rick, The internal in-memory collection process is still active with or without enabling the RTS database. This message is used to indicate that the RTS manager will no longer externalize in-memory stats to the RTS tables. So I guess we could say the message could be a little more specific or clearing, but as I stated in my presentation, the internal stats gathering process never [...] 10015 153 25_Re: Identity Column Usage8_Ron Root24_ron.root@CPA.STATE.TX.US30_Mon, 6 Oct 2003 08:14:15 -0500673_iso-8859-1 Thanks for the great note and great idea, Mark.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Fleming, Mark Sent: Friday, October 03, 2003 4:25 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Identity Column Usage



Mike,

I have experience with identity columns. We developed a common stored procedure to handle this for everyone. The concept is this: a table is used for the sequence number, but that table is just a means to an end; and a common stored procedure is used to managed the table. Users wanting a sequence value pass the routine the table name and get [...] 10169 104 55_Re: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2)15_Aurora Dellanno33_Aurora.DellAnno@BANKOFAMERICA.COM30_Mon, 6 Oct 2003 14:36:47 +0100328_iso-8859-1 Hi Bob,

My $0.0002 worth is that so long as you don't have any base software issues (DB2 in your case) since DB2 V7 does not run in 64 bit mode any utilities using DB2 should be completely... Well not only unaffected but also completely ignorant of the mode in which your OS/390 is running as it happens! [...] 10274 130 23_Re: CICS vs DB2 Connect0_16_khampto1@TXU.COM30_Mon, 6 Oct 2003 08:41:11 -0500573_us-ascii One possible reason for their comments about not "turning loose" DB2 Connect may be that you have insufficient control of your DDF threads in Z/OS Workload Manager. Regardless of what kind of application is driving it, whether it be Java, ASP, C++, VB, or whatever, a DB2 Connect thread comes through DDF, and gets assigned to a pre-emptable SRB in the pool in Z/os known as Enclaves. If you do not create controls in WLM to assign these threads to a service class, they run with the same system priority as their parent task, which is the DDF region itself. [...] 10405 111 55_Re: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2)15_Aurora Dellanno33_Aurora.DellAnno@BANKOFAMERICA.COM30_Mon, 6 Oct 2003 14:43:23 +0100495_iso-8859-1 Well I got a message saying that this posting was rejected so, just in case, here it is again :-)

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





Hi Bob,

My $0.0002 worth is that so long as you don't have any base software issues (DB2 in your case) since DB2 V7 does not run in 64 bit mode any utilities using DB2 should be completely... Well not only unaffected but also completely ignorant of the mode in which your OS/390 is running as it happens! [...] 10517 85 49_Re: Bufferpool Tool & BMC Pool Advisor Comparison23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Sun, 5 Oct 2003 20:55:55 +0100272_- I have to say that I agree with Venkat and can add very little except that I would say the BPool tool is VERY easy to get to grips with.

It takes a small amount of time to install and manage, support is (as Venkat says) first class and the output very good. [...] 10603 34 23_Re: DB2 V7 Sqlcode -22813_Johnny Kruger23_dhspa43@DHS.STATE.IL.US30_Mon, 6 Oct 2003 08:46:03 -0500278_ISO-8859-1 I don’t have an answer but I do have a question.

Last week I ate at Wendy's and ordered fries with my meal. The fries I received were dripping with grease and still frozen in the center. I took them to the counter and the young kid gave me another order. [...] 10638 108 28_Stored Procedures (DSNUTILS)16_Sebastian Welton19_sebastian@WELTON.DE30_Mon, 6 Oct 2003 08:52:56 -0500436_- Good Afternoon, I have a small problem with the stored procedure DSNUTILS and after reading through a number of manuals, etc. I'm going to have to post here.

I have just applied service to 3 subsystems (DB2 UDB V6 on z/OS) to bring them up to the same level as some of the other systems. This was primarily to fix a small problem. When I look at the other, working systems, I see the following when entering -DIS PROC(*): [...] 10747 73 23_Re: DB2 V7 Sqlcode -22815_Aurora Dellanno33_Aurora.DellAnno@BANKOFAMERICA.COM30_Mon, 6 Oct 2003 14:57:01 +0100473_- Well you could file a complaint here:

http://www.my3cents.com/search.cgi?criteria=Wendys

Not necessarily what they read, but at least you're in good company!

That's my very own 3 cents...

Aurora

-----Original Message----- From: Johnny Kruger [mailto:dhspa43@DHS.STATE.IL.US] Sent: 06 October 2003 14:46 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 V7 Sqlcode -228



I don't have an answer but I do have a question. [...] 10821 62 23_Re: DB2 V7 Sqlcode -22812_McKown, John26_john.mckown@UICIINSCTR.COM30_Mon, 6 Oct 2003 08:57:59 -0500549_- > -----Original Message----- > From: Johnny Kruger [mailto:dhspa43@DHS.STATE.IL.US] > Sent: Monday, October 06, 2003 8:46 AM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: DB2 V7 Sqlcode -228 > > > I don't have an answer but I do have a question. > > Last week I ate at Wendy's and ordered fries with my meal. > The fries I received were dripping with grease and still frozen in the > center. I took them to the counter and the young kid gave me > another order. > > The second fries were the same thing! Not cooked, still > white, dripping [...] 10884 46 23_Re: DB2 V7 Sqlcode -22815_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV30_Mon, 6 Oct 2003 10:18:28 -0400574_- Wow! I haven't heard of people having problems with frozen CORE since my days as an IBM 360 Operator. :O

Bill Blaney (443) 540-4407

> -----Original Message----- > From: Johnny Kruger [mailto:dhspa43@DHS.STATE.IL.US] > Sent: Monday, October 06, 2003 8:46 AM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: DB2 V7 Sqlcode -228 > > > I don't have an answer but I do have a question. > > Last week I ate at Wendy's and ordered fries with my meal. The fries I > received were dripping with grease and still frozen in the center. I > took them to the counter [...] 10931 64 55_Re: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2)12_Simon George20_simon.george@UBS.COM30_Mon, 6 Oct 2003 10:32:54 +0100433_iso-8859-1 We ran V7 on 2.10 for a while but rapidly moved to z/OS 1.2. In general it dug us out of a really big storage problem caused by our JAVA systems. The only issue we had was when we went to enable dataspaces and got hit badly by a problem with bufferpools in multiple dataspaces. There is a fix out there for this (sorry don't know the number but it was discussed on the list a bout a month ago) ensure you have it on. [...] 10996 201 23_Re: DB2 V7 Sqlcode -22812_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Mon, 6 Oct 2003 10:21:43 -0400577_us-ascii All, the number for complaints or issues is : 1-800-443-7266 ext 3015. Jeff







Aurora Dellanno Sent by: DB2 Data Base Discussion List 10/06/03 09:57 AM Please respond to DB2 Data Base Discussion List



To: DB2-L@LISTSERV.YLASSOC.COM cc: Subject: Re: DB2 V7 Sqlcode -228



Well you could file a complaint here:

http://www.my3cents.com/search.cgi?criteria=Wendys

Not necessarily what they read, but at least you're in good company! [...] 11198 155 23_Re: DB2 V7 Sqlcode -22814_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Mon, 6 Oct 2003 15:20:56 +0100558_iso-8859-1 > -----Original Message----- > From: Johnny Kruger [mailto:dhspa43@DHS.STATE.IL.US] > Sent: Monday, October 06, 2003 8:46 AM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: DB2 V7 Sqlcode -228 > > > I don't have an answer but I do have a question. > > Last week I ate at Wendy's and ordered fries with my meal. > The fries I received were dripping with grease and still frozen in the > center. I took them to the counter and the young kid gave me > another order. > > The second fries were the same thing! Not cooked, still > white, dripping [...] 11354 59 55_Re: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2)0_19_csutfin@AMSOUTH.COM30_Mon, 6 Oct 2003 09:36:48 -0500560_us-ascii Yes, Our test system is running with this configuration currently.

The only problem that I have encountered was with CA/Platinum Report Facility. CA has a PTF for that problem.

CA is the only OEM that we have for DB2.

Carol Sutfin Corporate DBA AmSouth Bank (205)261-5214 csutfin@amsouth.com







Bob Tinkle cc: Sent by: DB2 Data Subject: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2) Base Discussion List [...] 11414 190 23_Re: DB2 V7 Sqlcode -22815_Aurora Dellanno33_Aurora.DellAnno@BANKOFAMERICA.COM30_Mon, 6 Oct 2003 15:37:04 +0100428_- hey guys I was having a load of fun seeing the week start on this (un)happy note, but Jeff man, you're the walrus (as kids say nowadays) :-D

-----Original Message----- From: Jeff Frazier [mailto:Jeffrey_Frazier@WENDYS.COM] Sent: 06 October 2003 15:22 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 V7 Sqlcode -228





All, the number for complaints or issues is : 1-800-443-7266 ext 3015. Jeff [...] 11605 148 32_Re: Stored Procedures (DSNUTILS)13_Fleming, Mark21_MFLEMING@ALLSTATE.COM30_Mon, 6 Oct 2003 09:39:28 -0500530_iso-8859-1 Sebastian,

The procedure won't show up in a -DISplay list until it has been invoked. Sure, it's been started, but it's started and hasn't been invoked yet. Once it's invoked it should show up when you do the -DISplay.

Mark Fleming Data Base Administration 847-667-5690 email: mfleming@allstate.com



-----Original Message----- From: Sebastian Welton [mailto:sebastian@WELTON.DE] Sent: Monday, October 06, 2003 8:53 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Stored Procedures (DSNUTILS) [...] 11754 50 17_Websphere and DB214_Martin Flavell18_mflavell@I-TCS.COM30_Mon, 6 Oct 2003 16:01:32 +0100 11805 147 32_Re: Stored Procedures (DSNUTILS)15_Steven Morrison33_steven.morrison@FIRSTDATACORP.COM30_Mon, 6 Oct 2003 10:44:59 -0500398_US-ASCII Did you try running the procedure? Many times a procedure will not show up in a display until it is ran. I think it is something to do with WLM.

Thanks Steve Morrison





Sebastian Welton cc: Sent by: DB2 Data bcc: Base Discussion Subject: Stored Procedures (DSNUTILS) List [...] 11953 34 23_Re: DB2 V7 Sqlcode -22814_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM30_Mon, 6 Oct 2003 17:12:22 +0100571_us-ascii I had the opposite problem: a 360/Model 30 whose 32K of CORE caught fire! Maybe that would have tasted better!

Andy Lankester

> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Blaney, Bill L. > Sent: 06 October 2003 15:18 > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: DB2 V7 Sqlcode -228 > > > Wow! I haven't heard of people having problems with frozen > CORE since my days as an IBM 360 Operator. :O > > Bill Blaney > (443) 540-4407 > > > -----Original Message----- >Snip [...] 11988 197 55_Re: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2)22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM30_Mon, 6 Oct 2003 11:59:44 -0500431_iso-8859-1

We're running DB2 V7 on OS/390 2.10 in 64-Bit mode. No problems so far.

Venkatesh Mokshagundam Database Administrator Corporate Systems, Amarillo, TX 79102 Ph: 806-337-3374 Fax: 806-345-2736

Bob Tinkle cc: Sent by: DB2 Data Subject: DB2 V7 running on 0s390 2.10 in 64 bit (archlevel2) Base Discussion List [...] 12186 66 23_Re: DB2 V7 Sqlcode -22811_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM30_Mon, 6 Oct 2003 12:20:46 -0500495_us-ascii I had a slightly different problem. I had a 360 drown. Took three days to get it back up and running again. The computer center was moved withing a year after that. The cooling towers were on the roof of a 37 story bank tower and the computer room was on the 11th floor. One night a fitting broke on the water line from the roof to the chilled water A/C units. No one knew of the problem until the water came through the floor tiles which were about 2 feet off the concrete floor. [...] 12253 33 54_DB2 V7.1 OS/390 and SQLCode -084 Stored Procedure Call14_Michael Vanner19_mvanner@CANTIRE.COM30_Mon, 6 Oct 2003 16:10:57 -0400433_us-ascii We just finished upgrading from DB2 V5.1 to DB2 V7.1 on OS/390.

One of our systems written in C uses stored procedures. The websphere (on AIX) invoked stored procedures work fine. But the C batch programs running on OS/390 get -084 invoking the stored procedure with code compiled using the DB2 V5.1 precompiler. When the same identical code is precompiled using the DB2 V7.1 precompiler the program works fine. [...] 12287 87 23_Re: DB2 V7 Sqlcode -22812_Myron Miller22_myronwmiller@YAHOO.COM30_Mon, 6 Oct 2003 13:25:25 -0700529_us-ascii Tom, That sounds a lot like my days at Boeing Computer Services. They had a 370 that IBM installed on the 4th floor of a building. The IBM CEs forgot to hook up the chilled water connection under the floor to the computer. Turned the computer on and it was overheating. So they turned up the water flow. Pretty soon they were standing in water. Finally realized that the water wasn't hooked up after their feet were wet. But the water drained down into the next floor and soaked everything. Rained over everything. [...] 12375 49 23_Re: CICS vs DB2 Connect12_Myron Miller22_myronwmiller@YAHOO.COM30_Mon, 6 Oct 2003 13:30:27 -0700367_us-ascii On NT Client Configuration Assistant, there's a panel and parm that you can set that will cause DB2 connect threads that are terminated from the desktop to be terminated on the mainframe. I don't have access to that panel at the moment, but know it works. You can also set some parms using direct commands as well. Again, I don't remember the commands. [...] 12425 141 23_Re: CICS vs DB2 Connect12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Mon, 6 Oct 2003 15:34:00 -0400568_- --Bob, are you saying that 500,000 people will log in and out of this --application --in 2 days ? Yep, that is the pie in the sky here.

>>> DB2 Data Base Discussion List 10/06/2003 8:41:32 AM >>> One possible reason for their comments about not "turning loose" DB2 Connect may be that you have insufficient control of your DDF threads in Z/OS Workload Manager. Regardless of what kind of application is driving it, whether it be Java, ASP, C++, VB, or whatever, a DB2 Connect thread comes through DDF, and gets assigned to a pre-emptable SRB in the pool [...] 12567 122 23_Re: DB2 V7 Sqlcode -22811_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM30_Mon, 6 Oct 2003 15:36:33 -0500377_us-ascii Yeah

I forgot to mention that the 10th floor on down was ruined by the water as well. Seems as though it ran down through all the other floors. Even to the lobby.

Tom Moulder TREX Associates, Inc. www.t-rex-associates.com tom.moulder@trexassociates.com 14019 S. W. Freeway Suite#301-188 Sugar Land, TX. 77478 281-937-9199 Office 832-858-4279 Mobile [...] 12690 65 58_Re: DB2 V7.1 OS/390 and SQLCode -084 Stored Procedure Call12_michael bell24_mbell11@WORLDNET.ATT.NET30_Mon, 6 Oct 2003 15:42:40 -0500482_Windows-1252 Check the generated PLIST for the CALL statement between V5 abd V7. You should find a difference that will make your discussion with IBM go a lot quicker.



Mike Bell HLS Technologies

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Michael Vanner Sent: Monday, October 06, 2003 3:11 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 V7.1 OS/390 and SQLCode -084 Stored Procedure Call [...] 12756 30 23_Re: DB2 V7 Sqlcode -22826_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Mon, 6 Oct 2003 16:29:06 -0500305_- When I was on the West Coast, one of the Utilities built a brand spanking new DP center replete with tranquil Koi pond. One of the long holidays, thanksgiving or Christmas, dang thang froze and burst the basement wall it was adjacent to. Well the CPUs and DASD were in the basement. Gravity works! [...] 12787 18 52_Utilities on TS started for UT run (really) faster ?17_Christophe Radier17_c300501@YAHOO.COM31_Mon, 29 Sep 2003 10:35:28 -0500532_- Hi all,

I've read somewhere that Utilities run faster on Tablespaces started with "UT" status. Can you explain why ? I just see that it maybe simplier for DB2 to handle concurrency when the TS is started UT but don't think that it can really make a difference .

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...] 12806 33 23_Re: DB2 V7 Sqlcode -22814_Allen, Susan A24_susan.a.allen@BOEING.COM30_Mon, 6 Oct 2003 15:06:56 -0700481_iso-8859-1 during the Ash Wednesday Earthquake; one of the Boeing Computer labs was destroyed when the 4 inch water main (in the ceiling) ruptured during the quake = the walls were filled with water and demolition was a mess.

computers are not fond of water





-----Original Message----- From: Tom Moulder [mailto:tom.moulder@TREXASSOCIATES.COM] Sent: Monday, October 06, 2003 1:37 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 V7 Sqlcode -228 [...] 12840 54 23_Re: DB2 V7 Sqlcode -22811_Sinha, Amit19_Sinha.Amit@MBCO.COM30_Mon, 6 Oct 2003 17:26:52 -0500328_iso-8859-1 Very Soon we will have some one from list owners requesting to stop this thread. But just to let you guys know it was fun reading all the emails starting from Wendy's to Boeing....Good start to another exciting DB2 week...

From,

Not Enough experienced DBA to face these situations yet :-) Amit ... [...] 12895 61 23_Re: DB2 V7 Sqlcode -22814_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM30_Mon, 6 Oct 2003 23:28:48 +0100678_US-ASCII It's my (late) fifty-somethingth birthday today. So please let's not get too nostalgic/complacent - a single ****up today can cause orders of magnitude more damage than way back then.

Perspective...

Bonjour/soir from IDUG in Nice. End of thread?

Andy Lankester





> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Allen, Susan A > Sent: 06 October 2003 23:07 > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: DB2 V7 Sqlcode -228 > > > during the Ash Wednesday Earthquake; one of the Boeing > Computer labs was destroyed when the 4 inch water main (in > the [...] 12957 105 46_Re: Create Index statement - Copy No parameter13_Michael Ebert18_mebert@AMADEUS.NET31_Tue, 30 Sep 2003 09:47:19 +0200585_us-ascii I don't think there's an urgent need for additional reorgs of SYSLGRNX. After all, the ability to reorg this TS was only introduced somewhere in the V5 lifetime, One advantage of specifying COPY YES is that utility activity against the index is recorded in SYSCOPY - so you know when you last ran REORG on an index, to cite an example. For that reason, I consider specifying COPY YES for NPIs (for non-NPIs, I simply assume that the index got reorged when the TS/partition was reorged, i.e. no separate REORG INDEX). In my opinion, image copying indexes makes sense only [...] 13063 32 10_32 K pages38_hRdyamadhurOktula satkRtuloppajeppagan27_kakunuri_kireetum@YAHOO.COM30_Mon, 6 Oct 2003 15:28:46 -0700404_us-ascii

List, We want to use 32 K page tables for processing using cobol programs on os/390. If any of you have sample code for creating/maintaing tablespace and any tips/suggestions for using them in an OLTP application, can you please send it to me. Thanks in advance.



--------------------------------- Do you Yahoo!? The New Yahoo! Shopping - with improved product search [...] 13096 28 55_Connecting to two DB2 subsystems from one COBOL program11_General Tso16_tzs61x@YAHOO.COM31_Mon, 29 Sep 2003 11:13:38 -0700406_us-ascii To listers: We have a need to write a COBOL program to connect to a DB2 subsystem, doing some SELECTs, then connect to another DB2 subsystem doing some UPDATEs. Is there any sample Cobol code available? We are z/OS DB2 version 7. Thanks for help



__________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [...] 13125 42 23_Re: CICS vs DB2 Connect12_Phil Gunning20_pgunning@COMCAST.NET30_Mon, 6 Oct 2003 20:00:24 -0400600_us-ascii Hmm... I used DB2 Connect for extensive access to DB2 on mainframe for years without problems, that was even before WLM and enclaves. There is probably something wrong with your setup. Phil

> --- Kathy Czepiel wrote: > > Distributed applications that are improperly terminated from the > > desktop while using DB2 Connect can continue to run from the DB2 > > Connect server causing the mainframe DDF to really hog cycles. We > > have seen this happen in our shop more than once and it required > > that we terminate the thread from the mainframe [...] 13168 76 20_Re: Logging XMLCLOBs12_Cianci, Nick19_nick.cianci@EDS.COM30_Tue, 7 Oct 2003 12:17:22 +1000439_ISO-8859-1 Thanks Patric.

I hadn't seen the figures, but knew that I would not be a happy little DBA. I was visualising long logging queue spikes, if we have to; now I know that this would be an accurate premonition.

There are ways around it for us, but like always it depends on whether Developers are able to listen to reason. Happily there are some good technical people in the development team that know the issues. [...] 13245 96 23_Re: DB2 V7 Sqlcode -22815_Aurora Dellanno33_Aurora.DellAnno@BANKOFAMERICA.COM30_Tue, 7 Oct 2003 10:15:21 +0100554_- Well happy (belated) birthday but what do you mean end of thread?

Are we talking about Boeing the airplane people? I'm gonna start flying only airbus :-S

-----Original Message----- From: Andy Lankester [mailto:andy.lankester@CDBSOFTWARE.COM] Sent: 06 October 2003 23:29 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 V7 Sqlcode -228



It's my (late) fifty-somethingth birthday today. So please let's not get too nostalgic/complacent - a single ****up today can cause orders of magnitude more damage than way back then. [...] 13342 27 32_Re: Stored Procedures (DSNUTILS)16_Sebastian Welton19_sebastian@WELTON.DE30_Tue, 7 Oct 2003 05:11:59 -0500569_- Thanks for the pointers but still no go. After further investigation I noticed that the application environment for one system had the number of TCBs set to 40 and the other only 1, so thats been changed and the policy reactivated.

What I have noticed is that early on in the morning a job, named after the procedure name in the application environment, is automatically run and this references DSNUTILS and this is why I see DSNUTILS in a -DIS PROC(*) permanently on that system. However, what I don't know is how on earth this job is submitted, nada in [...] 13370 47 23_Re: DB2 V7 Sqlcode -22812_McKown, John26_john.mckown@UICIINSCTR.COM30_Tue, 7 Oct 2003 07:53:29 -0500467_- > -----Original Message----- > From: Allen, Susan A [mailto:susan.a.allen@BOEING.COM] > Sent: Monday, October 06, 2003 5:07 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: DB2 V7 Sqlcode -228 > > > during the Ash Wednesday Earthquake; one of the Boeing > Computer labs was destroyed when the 4 inch water main (in > the ceiling) ruptured during the quake = the walls were > filled with water and demolition was a mess. > > computers are not fond of water > [...] 13418 74 23_Re: CICS vs DB2 Connect13_Wolff, Martin31_Martin.Wolff@GLOBALCROSSING.COM30_Tue, 7 Oct 2003 09:26:59 -0400314_iso-8859-1 I've had a look on my Client Configuration Assistant and I don't see any parms for that sort of thing. I would be very grateful if you could find the specifics of this. We use DB2 Connect V7.1 here so it could be a version thing but I would still like to know where you find them so I can be sure. [...] 13493 48 58_getting a thread snapshot - reading ifcid 148 using dsnwli6_Daniel15_bufes@YAHOO.COM30_Tue, 7 Oct 2003 08:29:11 -0500468_- Hi, I would like to get a display thread information out of db2 using instrumentation facility interface (ifi). I call dsnwli from a rexx script, specify "READS" for synchronious reading. Monitor trace is started. What I receive seems like a dis thd information, but I only get 1 record - for the current connection that the very same script is using. I would like to see all the connected threads. Same thing for ifcid 147. Should I try another one? Any idea? [...] 13542 114 23_Re: CICS vs DB2 Connect13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Tue, 7 Oct 2003 08:38:31 -0500455_iso-8859-1 The setting is called "INTERRUPT_ENABLED". The archives have more information on how to set it. For example, take a look at http://listserv.ylassoc.com/cgi/wa.exe?A2=ind0210C&L=DB2-L&P=R5359&I=-3.

Mike. -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Wolff, Martin Sent: Tuesday, October 07, 2003 8:27 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: CICS vs DB2 Connect [...] 13657 63 32_Re: Stored Procedures (DSNUTILS)15_Steven Morrison33_steven.morrison@FIRSTDATACORP.COM30_Tue, 7 Oct 2003 08:20:02 -0500710_US-ASCII It could be schedule though Control Center or being called from some off host application.

Thanks Steve Morrison





Sebastian Welton cc: Sent by: DB2 Data bcc: Base Discussion Subject: Re: Stored Procedures (DSNUTILS) List



10/07/2003 05:11 AM Please respond to DB2 Data Base Discussion List











Thanks for the pointers but still no go. After further investigation I noticed that the application environment for one system had the number of TCBs set to 40 and the other only 1, so thats been changed and the policy reactivated. [...] 13721 25 53_DB2 Connect runaways - previously CICS vs DB2 Connect13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM30_Tue, 7 Oct 2003 09:03:28 -0500538_US-ASCII There may be problems with our setup (AIX R/S 6000 - OS/390 2.10 - DB2 710), but after paying mucho bucks to find it the only recommendation we got was to apply more maintenance and see it that fixes it. Our setting on the AIX is to terminate when the desktop does, but this does not always work. The biggest offender is the freeware trial QMF desktop software. Hit stop from the desktop and the desktop stops, but the mainframe to server thread keeps going at least 50% of the time bringing the lpar to a halt as DDF sucks [...] 13747 45 57_Re: DB2 Connect runaways - previously CICS vs DB2 Connect32_Poston, William L (COMFIN, ITSS)21_william.poston@GE.COM30_Tue, 7 Oct 2003 10:08:51 -0400652_iso-8859-1 Kathy Czepiel I'm confused. How and where did you set this on AIX gateway?

-----Original Message----- From: Kathy Czepiel [mailto:KathleenCzepiel@GROCERYBIZ.COM] Sent: Tuesday, October 07, 2003 9:03 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 Connect runaways - previously CICS vs DB2 Connect



There may be problems with our setup (AIX R/S 6000 - OS/390 2.10 - DB2 710), but after paying mucho bucks to find it the only recommendation we got was to apply more maintenance and see it that fixes it. Our setting on the AIX is to terminate when the desktop does, but this does not always work. The biggest offender [...] 13793 51 25_Re: Sporadic Broken Pages12_Mike Brennan31_michael.brennan@I-STRUCTURE.COM30_Tue, 7 Oct 2003 10:12:07 -0500387_- Here's an explanation of reason code 00C200F8.

Explanation: The buffer manager (BM) subcomponent of DB2 is unable to perform the I/O operation on a data set. A physical I/O error was detected by the buffer manager I/O functions.

This reason code and the data set name are recorded in the cursor table (CT) and made available to the user in the SQLCA or in messages. [...] 13845 19 36_IBM DB2 Query Monitor vs CA Detector7_Do Park19_doparkdba@YAHOO.COM30_Tue, 7 Oct 2003 10:15:16 -0500342_- We have used CA Detector for a couple of years. We will change from it to IBM DB2 Query Monitor. I am testing Query Monitor. It looks like Query Monitor does not have many options, CA Detector has the performance issue. What are cons and pros for two tools? I'd like to hear your opinion about the two tools. Any comments are welcome. [...] 13865 66 62_Re: getting a thread snapshot - reading ifcid 148 using dsnwli14_Wayne Driscoll24_wayne.driscoll@QUEST.COM30_Tue, 7 Oct 2003 10:34:26 -0500322_us-ascii Daniel, I seem to recall that for IFCID 147/148, to get all the records you need to pass in a WQAL area. The structure can contain all zeros except for the length field and the eyecatcher field. Wayne Driscoll Sr. Software Developer Quest Software wdriscoll@quest.com NOTE: All opinions are strictly my own. [...] 13932 78 58_Re: DB2 V7.1 OS/390 and SQLCode -084 Stored Procedure Call14_Michael Vanner19_mvanner@CANTIRE.COM30_Tue, 7 Oct 2003 10:52:17 -0500659_- On Mon, 6 Oct 2003 15:42:40 -0500, michael bell wrote:

>Check the generated PLIST for the CALL statement between V5 abd V7. You >should find a difference that will make your discussion with IBM go a lot >quicker. > > >Mike Bell >HLS Technologies > >-----Original Message----- >From: DB2 Data Base Discussion List >[mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Michael Vanner >Sent: Monday, October 06, 2003 3:11 PM >To: DB2-L@LISTSERV.YLASSOC.COM >Subject: DB2 V7.1 OS/390 and SQLCode -084 Stored Procedure Call > > >We just finished upgrading from DB2 V5.1 to DB2 V7.1 on OS/390. > >One of our systems written in C [...] 14011 80 62_Re: getting a thread snapshot - reading ifcid 148 using dsnwli11_Mark Ediger22_MEDIGER@TRANSUNION.COM30_Tue, 7 Oct 2003 10:58:57 -0500758_US-ASCII Daniel,

Replace the line

QUAL_AREA = X2C(00)

with

QUAL_AREA = SUBSTR('00'X,1,66*4,'00'X) QUAL_AREA = OVERLAY(D2C(LENGTH(QUAL_AREA),2),QUAL_AREA,1) QUAL_AREA = OVERLAY("WQAL",QUAL_AREA,5)



This should work

Mark Ediger





>>> bufes@YAHOO.COM 10/7/2003 8:29:11 AM >>> Hi, I would like to get a display thread information out of db2 using instrumentation facility interface (ifi). I call dsnwli from a rexx script, specify "READS" for synchronious reading. Monitor trace is started. What I receive seems like a dis thd information, but I only get 1 record - for the current connection that the very same script is using. I would like to see all the connected threads. Same thing [...] 14092 20 32_Copy database between subsystems11_Max Byfield33_max.byfield@ALLIANZCORNHILL.CO.UK30_Tue, 7 Oct 2003 11:02:54 -0500443_- Hi DB2-Listers,

I am a new DB2 DBA (came from Oracle). Please advise me on the best way to copy a database from one subsystem to another (DB2 V710, OS/390 2.10). I'm sure that there must be an easy way to do this, but I'm not having much success working it out for myself. With UNLOAD I get all the data, but then how to load it to the other subsystem where the tables are not known? Or is there a better way with COPY/DSN1COPY? [...] 14113 52 36_Re: Copy database between subsystems12_Bob Galeotti22_bgaleotti@SOFTBASE.COM30_Tue, 7 Oct 2003 12:51:02 -0400532_iso-8859-1 Hi Max, Do a search on CREATE LIKE. I think you can build the tables before the load with that command, referencing your source tables.

HTH,

Bob Galeotti, Sales Tech Support SoftBase Systems, Inc. 800.669.7076 x372 bgaleotti@softbase.com http://www.softbase.com/

----- Original Message ----- From: "Max Byfield" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, October 07, 2003 12:02 PM Subject: Copy database between subsystems [...] 14166 45 36_Re: Copy database between subsystems11_Lee Mandell16_DBMSUser@AOL.COM28_Tue, 7 Oct 2003 12:51:29 EDT443_US-ASCII Max, I am sure there are many product that will automate the copy to another DB2 process, but this is only one reference visit:www.recoveryknowledge.com

Hope this help Lee

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 14212 16 34_Re: ERWIN, DB2 OS/390, Db2 connect13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Tue, 7 Oct 2003 14:58:54 -0500536_- The DB2 Connect software is free, but the license is not.

I am sure there are other products on the market that would work just as well as DB2 Connect....but also for a price.

We use ER/Studio and upload our DDL to the OS/390 and import it into BMC Change Manager.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 14229 14 12_(no subject)13_Michael Hsiao21_michael.hsiao@EDS.COM30_Tue, 7 Oct 2003 17:42:29 -0500281_us-ascii DB2-L SET NOMAIL

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.