1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l March 2000, week 3 2 52 31_Re: Naming Standards/Suggestion22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Wed, 15 Mar 2000 05:15:34 +0000468_ISO-8859-1 Can I suggest you ask the DB2EUG as they are mostly using DB2 AIX ...

I am sure you will get some answers here .. but you will get a lot more from the DB2EUG.

http://people.mn.mediaone.net/scottrmcleod

regards

Les



______________________________ Reply Separator _________________________________ Subject: Naming Standards/Suggestion Author: Db2 Dba at Internet Date: 3/14/00 5:29 PM [...] 55 64 45_Re: Migrating QMF user objects using DSNTIAUL0_24_Ray.Price@DRESDNERKB.COM31_Wed, 15 Mar 2000 06:44:34 -0000668_- I did something like this using a REXX to generate and run the QMF EXPORT (and IMPORT) commands.

Have a nice day.

Ray Price DBA Dresdner Kleinwort Benson London.



-----Original Message----- From: JTonchick@AOL.COM [SMTP:JTonchick@AOL.COM] Sent: Tuesday, March 14, 2000 9:58 PM To: DB2-L@RYCI.COM Subject: Migrating QMF user objects using DSNTIAUL

We are in the process of moving datacenters. We need to "extract" QMF saved queries, forms, and procedures from one system to another. Using the QMF Export command would be a laborious task. Since QMF is just an application to DB2, would it be feasible to use DSNTIAUL to select [...] 120 53 14_Re: DB2 UDB/NT11_Alfred Moos21_moos@FH-HEIDELBERG.DE31_Wed, 15 Mar 2000 08:57:22 +0100586_iso-8859-1 Dear Michael,

I run it in stand-alone-mode on a 128 MB RAM/ 333 Mega-Cyle-machine with very satisfactory response time. At my university I have a 512 MB-machine. My 30 students work in parallel on their tables in in the catalog with also very satisfactory response time.

Cheers Alfred

Michael Bancale schrieb:

> I give up... I have been searching the IBM site for the machine requirements > for a DB2 UDB 6.1 on an NT workstation and I can't seem to find it. Would > someone please let me know what type of base Windows NT machine I should > [...] 174 248 32_Unable to run DB2 UDB on my PC !27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM31_Wed, 15 Mar 2000 13:51:02 +0530374_iso-8859-1 Hi !

Yesterday, I successfully installed DB2 UDB V6 Personal Edition on my Personal Computer. However on running first steps, when I try to create the sample database, it returns an error "Could Not Create Sample Database" and returns to the First Steps menu. The Control Centre returns an JDBC Error Socket opening ..etc and it also refuses to open. [...] 423 32 14_CLI 0129 error14_Rajesh Shewani22_rajeshs@DOMINOMAIL.COM29_Wed, 15 Mar 2000 09:11:25 PST423_iso-8859-1 Hi!,

we are building an application with HTML as front end, Java servlets as the middle tier and DB2 UDB 6.1 on NT as the back end database. JDBC-ODBC driver is being used.

While retrieving data from the database we get the foll error, SQLState:S1014 Message:[IBM][CLI Driver] CLI0129E No more handles, and only 32 records are displayed. The exact applications works perfectly with MS Access. [...] 456 71 44_DSNREXX - Updating using indicator varialbes9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 15 Mar 2000 09:42:12 +0000639_us-ascii Hi, Im having problems with the REXX/DB2 (DSNREXX) interface again when updating nullable fields with indicator variables. Ive copied the example code from the REXX Language Support manual (p15) and running it as follows,

/* rexx */ ssid = 'DB2C' address tso "SUBCOM DSNREXX" /* Host cmd environment available ? */ if rc then /* No. Then make it available */ s_rc = rxsubcom('ADD','DSNREXX','DSNREXX') /* Add to DSNREXX to */ /* command table */ address dsnrexx "CONNECT" ssid /* Connect to DB2 */ SQLSTMT="UPDATE DSN8410.EMP " , "SET WORKDEPT = ? ?" HVWORKDEPT='000' INDWORKDEPT=-1 "EXECSQL DECLARE C1 CURSOR FOR S1" [...] 528 115 35_Re: who can update production data?16_Michael McMorrow25_michael.g.mcmorrow@AIB.IE31_Wed, 15 Mar 2000 11:08:57 -0000577_ISO-8859-1 Another slant on this is the difference between 'doing data' and 'doing sql analysis'. A personal bugbear of mine which I've raised here a couple of times. If developers put together an ad-hoc query and don't have authority to run it then they also don't have the authority to 'explain' it in advance. Ditto, if DBA don't have authority to run the query then DBA also don't have the authority to Q/A it in advance. The process you design for 'who does what' needs to clamber over this restriction in some way. The separation of authorities to 'explain' a query [...] 644 73 55_Re: Switch to large tablespace - anything to watch for?24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM31_Wed, 15 Mar 2000 22:48:34 +1100375_us-ascii Paul,

Is your Tablespace partition already compressed ? If not you can potentially get long term relief by altering the Tablespace partition to be compressed and then REORG the PARTITION.

Another option depending on the number of partitions you have defined, is to alter the tablespace to be VCAT defined, where you can have up to 4Gb partitions. [...] 718 50 45_Re: Migrating QMF user objects using DSNTIAUL9_A. Bohacz22_abohacz@OZEMAIL.COM.AU31_Wed, 15 Mar 2000 23:39:18 +1100318_iso-8859-1 Have used both approaches to migrate QMF objects between QMF's i.e. export/import and unload/load. Unload & Load worked okay for us when:

(a) not altering any QMF objects between the unload and load phases (b) source and target QMF's are the same version and make use of the same exit routines. [...] 769 88 48_Re: DSNREXX - Updating using indicator varialbes15_Filip Van Parys24_filip.vanparys@SIDMAR.BE31_Wed, 15 Mar 2000 07:46:23 -0600648_- Hello Andy,

please check PTF UQ39753. It solves the problem with the indicator variables. You only have to put one '?' in the update query.

Filip Van Parys - Sidmar nv Belgium



On Wed, 15 Mar 2000 09:42:12 +0000, Andy Hunt wrote:

>Hi, >Im having problems with the REXX/DB2 (DSNREXX) interface again when updating >nullable fields with indicator variables. Ive copied the example code from the >REXX Language Support manual (p15) and running it as follows, > >/* rexx */ >ssid = 'DB2C' >address tso "SUBCOM DSNREXX" /* Host cmd environment available ? */ >if rc then /* [...] 858 89 24_Re: Update with subquery20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 15 Mar 2000 08:56:15 -0500653_us-ascii Wow.. Never thought of that before.

Thanks > -----Original Message----- > From: Birk, Tim [SMTP:BirkT@DIEBOLD.COM] > Sent: Tuesday, March 14, 2000 5:00 PM > To: DB2-L@RYCI.COM > Subject: Re: Update with subquery > > Actually you can convert a character to integer like this: > INTEGER(DECIMAL(SUBSTR(VAR10,5,8),8,0)) > > -----Original Message----- > From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] > Sent: Tuesday, March 14, 2000 4:23 PM > To: DB2-L@RYCI.COM > Subject: Re: Update with subquery > > > Question #1 : Is it possible to use subquery for this update . > Ans: No. you can't use it. Probably, you should consider [...] 948 146 55_Re: DB2 Major Weakness: Who can update production data?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 16 Mar 2000 01:37:48 +1000331_us-ascii Michael,

I can't agree more. Its an incredible weakness in DB2 that you can't explain the access path for an SQL unless you have authority to run the SQL, including DELETEs and UPDATEs which have access paths to be checked. Even on SELECT it is a severe problem. I hope Roger Miller reads this and takes note. [...] 1095 103 24_Re: Update with subquery14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 16 Mar 2000 01:41:35 +1000724_us-ascii I think it was DB2 V4 where CHAR to DECIMAL first became available. I remember looking at the change bars in the SQL manual.

From: Michael Hannan

>From: "Pillay, Venkat (PCA)" >Subject: Re: Update with subquery >To: DB2-L@RYCI.COM > >Wow.. Never thought of that before. > >Thanks >> -----Original Message----- >> From: Birk, Tim [SMTP:BirkT@DIEBOLD.COM] >> Sent: Tuesday, March 14, 2000 5:00 PM >> To: DB2-L@RYCI.COM >> Subject: Re: Update with subquery >> >> Actually you can convert a character to integer like this: >> INTEGER(DECIMAL(SUBSTR(VAR10,5,8),8,0)) >> >> -----Original Message----- >> From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] >> Sent: Tuesday, [...] 1199 45 36_Re: Unable to run DB2 UDB on my PC !14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Wed, 15 Mar 2000 07:10:30 -0800404_iso-8859-1 Deepak, I am guessing that you are running on Win 98. On my Win 98 machine in order to run control center I have to do the following - Open a DB2 command window Enter the following command - db2jstrt 7000 (This will start the db2 java server on port 7000) then I enter the following command - db2cc 7000 (This starts the control center and allows it to communicate with the java server). [...] 1245 36 35_Re: who can update production data?0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 15 Mar 2000 09:38:58 -0600688_us-ascii Good point, and I agree with your "wish list". We get around that issue by migrating production stats to our development environments. That way when developers do explains they should get valid output.











Michael McMorrow on 2000/03/15 05:08:57 AM Subject: Re: who can update production data?

Another slant on this is the difference between 'doing data' and 'doing sql analysis'. A personal bugbear of mine which I've raised here a couple of times. If developers put together an ad-hoc query and don't have authority to run it then they also don't have the authority to 'explain' it in advance. [...] 1282 30 34_db2 start failure - bsds timestamp11_D. Williams17_dale@METRONET.COM31_Wed, 15 Mar 2000 09:55:21 -0600701_iso-8859-1 Being somewhat new to MVS/db2, can anyone advise what's all-of-a-sudden going on with db2 here and how to resolve it. This is from a very small development machine/environment that's been working without problem.



- 09.42.28 STC02348 DSNY001I - SUBSYSTEM STARTING - 09.42.31 STC02348 DSNJ120I - DUAL BSDS DATA SETS HAVE UNEQUAL - TIMESTAMPS, SYSTEM BSDS1= 0.073 15:22:18.89,BSDS2= 0.073 - 15:22:38.67, UTILITY BSDS1= 97.016 11:13:24.95,BSDS2= 97.016 11:13:24.95 - 09.42.32 STC02348 DSNJ119I - BOOTSTRAP ACCESS INITIALIZATION PROCESSING FAILED *09.42.32 STC02348 *DSNV086E - DB2 ABNORMAL TERMINATION REASON=00E80084 00- 09.42.36 DSN3104I - DSN3EC0X - TERMINATION COMPLETE [...] 1313 63 36_Re: Unable to run DB2 UDB on my PC !15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Wed, 15 Mar 2000 11:00:56 -0500546_iso-8859-1 Deepak,

Try creating a DBADMIN user account (I assume you're using some flavor of Windoze) and sign on using that account. I've been playing with UDB V6 under Win98 and this seems to be the fastest way to go.

There is documentation in the manual that comes with the CD that explains how to turn off SYSADM authorization using the Control Center, but after I did this I still received various authorization errors when I tried to start the DB2 instance. Perhaps someone else on the list knows how to get around this. [...] 1377 23 38_Re: db2 start failure - bsds timestamp14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 15 Mar 2000 17:05:53 +0100571_us-ascii Delete/define BSDS VSAM who have the oldest timestamp, then copy the newest BSDS in the

redefined BSDS with a REPRO VSAM (they are KSDS). Then restart DB2. You can use MODEL

in DEFINE CLUSTER. You can find define cluster in member DSNTIJIN in SDSNSAMP library.

Regards Max Scarpa Data & System admin

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 1401 16 17_DB2 exit for RACF10_Greg Retus16_gretus@PHEAA.ORG31_Wed, 15 Mar 2000 11:05:35 -0500328_us-ascii We have recently turned on RACF for DB2. One major problem we are having is the DB2 exit keeps abending...about once a week. The only way to recover the exit is to recycle DB2 and we cannot do that until the weekend in some of our subsystems. Does anyone have any info as to what may be causing the exit to abend? [...] 1418 28 21_Re: DB2 exit for RACF14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Wed, 15 Mar 2000 08:37:27 -0800385_iso-8859-1 I would reccomend that you follow basic diagnostic guidelines, gather a dump, logrec, etc and call the IBM support center. As the exit is defined as a user exit, I don't know if they provide support but the least you should do is give them a call and see. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 1447 205 41_Re: DB2 CONNECT PE holding locks forever.0_14_dcreed@CSC.COM31_Wed, 15 Mar 2000 10:30:49 -0600397_us-ascii First off, thanks to all the responses so far. I would like to eliminate or clarify points in hopes of getting to the root of the problem.

Suggestions thus far and my response to them.

*1) Suggestion: SET: CMTSTAT=value IDTHTOIN=value Short Response: I agree and they are. Longer Response: CMTSTAT=INACTIVE and IDTHTOIN=(#secs). In my case the #SEC is set pretty high. [...] 1653 63 38_Re: db2 start failure - bsds timestamp0_14_dcreed@CSC.COM31_Wed, 15 Mar 2000 10:34:13 -0600558_us-ascii Was it possible that someone updated the BSDS (such as adding TCPIP pgm dsnju003) and only specified a single dd SYSUT1 instead of both dd's as needed?

//SYSUT1 DD DSN=ssid.BSDS01,DISP=OLD //SYSUT2 DD DSN=ssid.BSDS02,DISP=OLD

If so rerun the update to both.

Regards Danny















dale@metronet.com on 03/15/2000 09:55:21 AM

Please respond to DB2-L@ryci.com

To: DB2-L@ryci.com cc: (bcc: Daniel S Creed/GIS/CSC) Subject: db2 start failure - bsds timestamp [...] 1717 138 48_Re: DSNREXX - Updating using indicator varialbes9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 15 Mar 2000 16:40:54 +0000417_us-ascii Filip, Thanks for the info. Ive applied UQ39753 and this appears to work with one positional parameter (i.e. ?) as you stated.

Interestingly, I get a RC(-1) from the "EXECSQL PREPARE S1 FROM :SQLSTMT" even though it gives an SQLCODE = 0.

Many Thanks, Andy Hunt - Scottish And Southern Energy







Filip Van Parys on 15/03/2000 13:46:23 [...] 1856 250 41_Re: DB2 CONNECT PE holding locks forever.13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 15 Mar 2000 11:03:16 -0600437_US-ASCII Hello Danny, Binding plans and or packages during peak hours has always resulted in catalog contention problems for us. You can try running them in an address space that is dispatched higher that your normal batch address spaces, this helps, especially when CPU is approaching 100% or run them off hours (yeah right). As far as your third party vendor product not committing, I would try to address this problem ASAP. Kurt [...] 2107 306 29_Re: Possible trivia question?16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Wed, 15 Mar 2000 12:21:25 -0500326_- We had that happen here some time back. I wasn't the primary DBA to work on that, but as I remember, The whole table had to be repartitioned to insure all data would fit into a partition -- as well as insuring there was still growth room.

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee [...] 2414 61 21_FW: DB2 Connect Error18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Wed, 15 Mar 2000 11:22:55 -0500625_iso-8859-1 I'm gonna try to send this again. My email administrator said the address was not correct. If this did post already then I'm sorry.

Thanks:



Steve Whittaker DB2/DBA Carolina Power & Light Mail stop: CPB 17A4 - Raleigh Email: stephen.whittaker@cplc.com Phone: (919) 546-7267

> -----Original Message----- > From: Whittaker, Stephen > Sent: Wednesday, March 15, 2000 7:02 AM > To: DB2-L@RYCI.COM > Subject: DB2 Connect Error > > Could use some help/info here if anyone has seen this error. > I've got a 'user/client' telling me that when he tries to log on to DB2 > Connect he > gets [...] 2476 33 55_Re: DB2 Major Weakness: Who can update production data?9_Tony Mann19_tmann@UTILICORP.COM31_Wed, 15 Mar 2000 12:44:04 -0600487_- There are a couple of possible solutions (though certainly the onus really rests with IBM).

1. CA/Platinum's Plan Analyser. All developers and some users in my shop are able to run explains against production, or re-explain production packages, while they certainly do not have any update authority. Plan Analyser lets them adopt the table owner id, explain the query, report the access paths, then rollback the explain. It works very well - when I can get them to use it! [...] 2510 112 36_Re: Unable to run DB2 UDB on my PC !15_Aniruddha Garud24_Aniruddha.Garud@WCOM.COM31_Wed, 15 Mar 2000 14:09:22 -0500459_- Deepak,

I have faced similar problems.

There could be a few possibilities why this is not working :

1) The port you have started your java may not be matching with the one on which you are starting the control center. so when you give 'db2jstrt 7000' command, the other one should be 'db2cc 7000'. The default port is 6789. Also check that there is no instance (of db2jstrt) running on your PC (which could be on some other port). [...] 2623 73 52_DB2 Connect vs Merant performance and case studies ?15_Macleod, Robert23_Robert.Macleod@ICBC.COM31_Wed, 15 Mar 2000 11:18:02 -0800434_iso-8859-1 A couple of questions re: DB2 Connect. This is for DB2 V5 OS/390

Does anyone now of any recent comparison reports between DB2 Connect and Merant ? I have tried Gartner but could not find anything.

Does anyone have any case studies implementing DB2 Connect ? Lockwood Lyon did a presentation at IDUG last year on Client/Server Connectivity to DB2 OS/390... but they were SNA, and I am looking for TCP/IP. [...] 2697 30 45_nulls and an applicable / inapplicable status32_=?iso-8859-1?q?Judi=20Westcott?=23_judi_westcott@YAHOO.COM31_Wed, 15 Mar 2000 11:24:05 -0800487_iso-8859-1 Hello all. Please forgive me if this has been asked before however I have been away from DB/2 for a few years and am just back now.

I think I read recently somewhere (of course in looking for it again, I cannot find it) that DB2 Version 6 for OS/390 will include an identifier for nulls that will identify if the null is null and applicable, or null and inapplicable. Has anyone else heard of this? Is this true? If it is, does anyone know where it is documented? [...] 2728 26 30_read trace (ifcid = 6) mystery0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 15 Mar 2000 13:50:51 -0600565_us-ascii I am using a read trace (ifcid=6) to check out the size of my bufferpools. By analyzing the output of this, I can see how many rereads that I have and this helps tremendously with knowing whether a given bufferpool is too large or too small.

There is one mystery that I have encountered in looking at the output from this trace. I have seen some rereads of a given page that occur very quickly (like within seconds) in a very large bufferpool. When I look at the trace records for these, the authorization ID is always "SYSOPR". Apparently DB2 [...] 2755 56 34_Re: read trace (ifcid = 6) mystery20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 15 Mar 2000 15:13:05 -0500344_us-ascii Check the DBID, OBID to find out which tablespace/indexspace the page belongs to. Instead of looking at authorization id look for ACE token to find out which transaction did that. The ACE will be same as shown in the accounting report. If you have correlation header attached to the trace then that will also tell you who did it. [...] 2812 39 30_read trace (ifcid = 6) mystery14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 15 Mar 2000 15:20:46 -0500549_ISO-8859-1 the id of SYSOPR is what DB2 uses when it runs a prefetch.... so all asynch I/O runs under sysopr.

Regards, Joel |======================================================= | Joel Goldstein | Responsive Systems Company |======================================================= | WEB Site | www.responsivesystems.com |======================================================= | Buffer Pool Tool for DB2 & DASD/Xpert for DB2 | >>> The Answers for your performance problems <<< |======================================================= [...] 2852 20 27_Re: Fallback from DB2 ver.614_Jens P. Hansen24_jens.peter.hansen@PBS.DK31_Wed, 15 Mar 2000 21:14:26 +0100344_us-ascii I just succeded in fallback from ver. 6 on OS390 for my first TEST-DB2, after applying PTF's on ver. 5 for PQ34199 ( ver. 5 could not start )

Procedure just includes making ver.5 of SDSNLOAD, SDSNEXIT( including DSNZPARM) and SDXRRESL aviable for DB2.

Jens Hansen

*** all disclaimers u can think of apply *** [...] 2873 81 45_Re: Migrating QMF user objects using DSNTIAUL14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 15 Mar 2000 20:26:15 -0000395_- Like Ray,

I had to resort to the same REXX trick some years ago. The DB2 tables behind QMF have some LONG VARCHAR columns (or they did!), and DSNTIAUL doesn't (or didn't) support those!!

Of course, things may have changed since my middle-agesmemories of DB2 (Did I see Mike Holmans a few eMails back saying "when we converted to Type 2 indexes several YEARS ago"..........) [...] 2955 33 34_Re: read trace (ifcid = 6) mystery14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 15 Mar 2000 15:25:02 -0500276_ISO-8859-1 Since ACE's are re-used at a high rate, you can only use it to point to an application in the same small timeframe as the I/O (and even that's a maybe). Generally, it's only useful to use the ACE to match the 6/7 records in a start/end I/O pair. Regards, Joel [...] 2989 61 8_CLI1060E10_Wang.James24_Wang.James@AAA-CALIF.COM31_Wed, 15 Mar 2000 12:54:59 -0800316_us-ascii Did anyone experience CLI1060E from DB2 Connect?

We are running DB2/OS390 V5.1 and DB2 Connect V5.2 on NT platform. Network connectivity is TCPIP.

James Wang Sr. Systems Programmer Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com 3051 30 11_DB2 Connect0_24_Munwar.Malik@ACS-GSG.COM31_Wed, 15 Mar 2000 16:17:16 -0500479_US-ASCII Hi:

I have just installed UDB (EE) 5.2 on NT 4.0. My OS390 is at 2.4 and DB2 on OS390 is version 5.

I am trying to set up DB2 Connect via CCA but having problems. The error code I got SQLSTATE=08001.

Questions:

1) What do I need on OS390 (os390 open edition running) ? 2) Ports setting in TCP/ip on os390? 3) DDF setting on DB2 for OS390? 4) SYSibm.sysluname or ipname etc ???????? catalog table setting? 5) Or any thing else?????????// [...] 3082 20 21_ReportSmith with DB2?16_Staci Stephenson28_staci_stephenson@ACS-INC.COM31_Wed, 15 Mar 2000 15:17:45 -0600434_US-ASCII Is anyone using ReportSmith with DB2 for OS/390? If so, what are you using for ODBC access?

Thanks, Staci Stephenson Affiliated Computer Services Database Systems (214)841-6441

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 3103 49 21_Re: DB2 exit for RACF0_22_BILL_GALLAGHER@PHL.COM31_Wed, 15 Mar 2000 16:33:54 -0500333_us-ascii Greg,

We ran into similar problems last summer when we turned on the exit. Turns out that the problem was related to CICS thread reuse, which was crashing the exit for a S0C4. You may want to refer to APAR PQ23197 to determine if it is applicable to you.

Bill Gallagher, DBA Phoenix Home Life Enfield, CT [...] 3153 149 24_Re: Update with subquery13_Crowley, Paul21_CrowleP@DIVINVEST.COM31_Wed, 15 Mar 2000 15:34:45 -0600616_iso-8859-1 Hello All,

We are trying something similar to below and are getting a similar error message. We are DB2/os 390 v51.

Our SQL is: Update tda.max_eff_dt set max_eff_dt = (select max(eff_dt) from tda.unit_value)

Our error message says "SQL error at or before MAX line 2 position 26 We are using a different table in subselect. The Application guide says you can replace a column value with any of following: A column value A constant A null value Contents of host variable (special register or the result of an expression) We were hoping DB2 would consider the BIF value returned as [...] 3303 194 24_Re: Update with subquery0_19_Tim.Lowe@STPAUL.COM31_Wed, 15 Mar 2000 15:51:55 -0600419_us-ascii Paul, From what I understand, in order to use an update statement with a set equal to a subselect, you would need DB2 V6 for OS/390 with PTFs UQ37262 and UQ37245 (apar #s PQ30383 and PQ31272).

Thanks, Tim













"Crowley, Paul" on 03/15/2000 03:34:45 PM

Please respond to DB2 Data Base Discussion List [...] 3498 47 15_Re: DB2 Connect13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 15 Mar 2000 16:08:17 -0600454_US-ASCII I would suggest reading the following books. DB2 Connect User's Guide, DB2 Connectivity supplement and IBM Redbook "Wow DRDA supports TCP/IP" HTH Kurt





>>> 03/15/00 03:17PM >>> Hi:

I have just installed UDB (EE) 5.2 on NT 4.0. My OS390 is at 2.4 and DB2 on OS390 is version 5.

I am trying to set up DB2 Connect via CCA but having problems. The error code I got SQLSTATE=08001. [...] 3546 34 12_Re: CLI1060E12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Wed, 15 Mar 2000 16:31:09 -0600523_iso-8859-1 We did. We got current with db2 connect maintenance and also went into our db2cli.ini and put QUERYTIMEOUTINTERVAL=0 in our db2cli.ini in the [common] section.



-----Original Message----- From: Wang.James [mailto:Wang.James@AAA-CALIF.COM] Sent: Wednesday, March 15, 2000 2:55 PM To: DB2-L@RYCI.COM Subject: CLI1060E





Did anyone experience CLI1060E from DB2 Connect?

We are running DB2/OS390 V5.1 and DB2 Connect V5.2 on NT platform. Network connectivity is TCPIP. [...] 3581 1170 53_Register Now for the Midwest Database Tools Fair 200012_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Wed, 15 Mar 2000 18:52:49 -0600704_iso-8859-1 MIDWEST DATABASE TOOLS FAIR 2000 - THURSDAY, APRIL 6, 2000 Join the Midwest Database Users Group (M_DUG) Thursday, April 6th for a day of information and technology gathering with exhibits and technical presentations on database, data warehousing and information engineering. Computer Associates, BMC Software, Compuware, CDB Software, InfoTel, NIMS Associates, Responsive Systems, Candle Corporation, Database GUYS, IBM, Princeton Softech, Titanium group and Network Appliance will be among the exhibitors. Attendance is FREE if you are a member of a Regional User Group, $30 for non-members and luncheon is included if registration is received before March 31st. A registration form is [...] 4752 15 14_DB2 Compaction17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM31_Wed, 15 Mar 2000 17:28:58 -0800383_us-ascii Does anyone know if you have to change the DB2 installation parameter for compaction if you add IDRC to your tape drives?

TIA

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4768 60 38_Re: db2 start failure - bsds timestamp15_Shaun Z Lombard36_Shaun.Z.Lombard@TRANSPORT.QLD.GOV.AU31_Thu, 16 Mar 2000 12:03:53 +1000493_us-ascii An easier way to do this is to just issue the -RECOVER BSDS command.

Shaun







Massimo Scarpa on 16/03/2000 02:05:53

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Shaun Z Lombard/CorpServ/qdot/au) Subject: Re: db2 start failure - bsds timestamp







Delete/define BSDS VSAM who have the oldest timestamp, then copy the newest BSDS in the [...] 4829 20 25_I have error CLI0129 too.7_sompong17_sompong@SCB.CO.TH31_Thu, 16 Mar 2000 10:26:17 +0700453_Windows-874 Hi. I've got error code CLI0129 when running application build with Visual-age. It acceses database at server using DB2 Server V.2.12 on OS/2 and DB2 CAE V.5.2. on WIN95.

Thank. Somporng Aoon.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4850 74 17_Re: db2/cs V5 AIX7_revadee18_revadeev@SCB.CO.TH31_Thu, 16 Mar 2000 10:52:12 +0700428_ISO-8859-1 Hi, shirley. You must backup full db first and use restore database command as redirect that can resize your tablespace from 2 Gb to 1 Gb.

restore database A from /.... to /...... into A redirect ;

set tablespace containers for 3 using (device '/dev/rdsk/.......' size(page), device '/dev/rdsk/......' size);



set tablespace containers for 4 using (device '/dev/rdsk/........' size); [...] 4925 72 28_Question regarding IRLM lock14_Johnson, Tracy22_TJohnson@GUIDEMAIL.COM31_Wed, 15 Mar 2000 14:07:17 -0600367_iso-8859-1 Hello. I'm in need of a little assistance debugging an IRLM Lock error. We are DB2 for OS390 v5.1 in a non-data sharing environment. I had two IC jobs running (DBDLY023 & DBDLY044), and one Runstats job (DBWKY600). There also was a batch SQL running (VAUDY029) at the same time, that was inserting data into the same tables as referenced by DBDLY044. [...] 4998 95 38_Re: db2 start failure - bsds timestamp14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 16 Mar 2000 08:46:05 +0100329_us-ascii It'll be hard if DB2 doesn't work.

-RECOVER BSDS is a DB2 command to use if DB2 is up and one BSDS is deallocated by an

active DB2 if an I/O error occurs. -RECOVER BSDS is used after a delete/define of failing BSDS

(DB2 dellocates BSDS if fails).

Regards Max Scarpa Data & System Admin. [...] 5094 9 34_Re: read trace (ifcid = 6) mystery14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 16 Mar 2000 09:02:31 +0100244_-

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5104 32 18_DDF not behaving !10_Robert Ord21_robertord@HOTMAIL.COM29_Thu, 16 Mar 2000 09:30:51 GMT605_- We are currently running DB2 V5.1 on OS/390 2.06 and connecting DB2Connect 5.2 clients via DB2Connect 5.2 Enterprise edition running on an NT4 SP5 server using TCPIP. The user PC's are running Business Objects

We have two problems;

1) DDF on the mainframe consuming huge amounts of cpu even when no remote queries are running causing the mainframe to slow drastically. Initially we thought the problem was runaway queries, in some cases this was true. We introduced an rlimit on the mainframe to chop queries after 1 minutes cpu, but the problem persists without any queries running. [...] 5137 28 46_Running multiple DB2's on a single OS/390 lpar13_Dave Bargeron29_dave.bargeron@LLOYDSTSB.CO.UK31_Thu, 16 Mar 2000 05:03:37 -0600338_- Fellow Helpers,

We currently run 3 dev DB2 enironments on a single OS/390 Lpar, with 2 Prod environments on another separate lpar. The DB2 systems share a single set of DB2 libraries (SDSNLOAD/LINK in linklist/LLA) on a particular Lpar; steplibing to separate DSNEXIT libs. Any CICS/IMS connection steplibs to the SDSNLOAD. [...] 5166 17 31_BPXK_SETIBMOPT_TRANSPORT OS/39013_Schluter John24_john.schluter@DATA.SJ.SE31_Thu, 16 Mar 2000 05:54:35 -0600438_- Where do we use this to set the TCPIP stack for DB2? Is it a parm for the DDF procedure start?

Thanks in advance!

/John Schluter Swedish State Railways Information Systems Division

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5184 37 7_SIGNOFF17_Roberto Rodrigues28_roberto.rodrigues@OSI.COM.BR31_Thu, 16 Mar 2000 09:20:46 -030018_iso-8859-1 SIGNOFF 5222 36 44_INDUG spring conference (Indiana) on 3/23/0011_Hilton Tina15_HiltonT@TCE.COM31_Thu, 16 Mar 2000 07:36:12 -0500595_iso-8859-1 The Indiana DB2 User Group will be holding it's spring conference on Thursday, March 23rd in Indianapolis. Candle Corporation is the sponsor and the agenda is:

8:00 - 8:45 Coffee, Donuts 8:45 - 9:00 Opening Remarks 9:00 - 10:15 DB2, MVS And e-Business: New Performance Challenges 10:15 - 10:30 Break 10:30 - 11:45 DB2, MVS And e-Business: New Performance Challenges 11:45 - 12:45 Lunch 12:45 - 2:00 A Look At DB2 Statistics And Performance Traces 2:00 - 2:15 Break 2:15 - : 3:30 DB2 Application Performance Analysis: Asking The Right Questions 3:30 - 3:45 Closing Remarks [...] 5259 109 50_Re: Running multiple DB2's on a single OS/390 lpar15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 16 Mar 2000 08:19:04 -0500557_iso-8859-1 Hi Dave,

We run three subsystems on one LPAR within our environment.

When I invoke getting into these subsystems, I use an logon PROC which calls a CLIST which invokes other various CLISTS which each of them allocates the correct libraries once I make a subsystem selection off my main ISPF panel. We keep each DB2 subsystems separate as far as libraries and maintenance upgrades so one doesn't affect the other. This is similar to our QMF environments too and third party vendor products (BMC and Candle's Omegamon products). [...] 5369 41 50_Re: Running multiple DB2's on a single OS/390 lpar9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM31_Thu, 16 Mar 2000 13:31:43 -0000388_us-ascii Dave,

if you want to maintain completely separate DB2 systems, the first thing you must do is to remove SDSNLOAD from the LINKLIST. Inevitably, you will get a rash of CSV003A and S806 errors for a period of time.

The only common library should be SDSNLINK - this is the ERLY code which is loaded into the MVS nucleus, so only one copy can exist per MVS image. [...] 5411 58 50_Re: Running multiple DB2's on a single OS/390 lpar0_14_mtdage@ATT.NET31_Thu, 16 Mar 2000 13:42:50 +0000491_- Hi Dave,

This is how we have our DB2 environment setup.

We have 5 DB2 subsystem on a single OS/390 LPAR. We copy SDSNLOAD and SDSNEXIT to each of the DB2 subsystem pds, (dssa.dsnload, dssb.dsnload, ...etc) and steplib each pds to each DB2 subsystem. We have our own CLIST that requires our users to input a DB2 subsystem they want to connect when they use DB2I or QMF or BMC and that CLIST takes the input and plugs in the correct dsnload to use (dssa or dssb or dssc). [...] 5470 54 41_Re: DB2 CONNECT PE holding locks forever.11_Gary Martin22_Gary_Martin@BCBSME.COM31_Thu, 16 Mar 2000 08:23:09 -0500543_us-ascii Danny,

Our experience would support your suggestion #4 listed below. We also run EDIFY applications, as well as PowerBuilder apps running on win98 desktops accessing DB2/OS390 5.1 via DB2ConnectEE 5.2. In both cases, we have pressed developers to address long running threads that hold locks by issuing COMMITs. That seems to be a challenge in these GUI development environments - this is a constant struggle in our shop. I, too, am unclear as to why the COMMITs are required, but I can't argue with the apparant results. [...] 5525 61 39_Domino 5.0.2a & DECS connect to DB2 5.113_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Thu, 16 Mar 2000 08:51:25 -0500538_US-ASCII We are trying to connect Domino DECS residing on the OS/390 V2.8 server to DB2 UDB V5.1 for OS/390. We get an error with reason code 00f30006. I have pasted the full error message and the IBM explanation of that error message at the end of this post.

We initially installed the Lotus Domino and Notes product on the OS/390 server. Then we installed the ODBC components for DB2 UDB V5.1 for OS/390. After installing the ODBC components we applied maintenance specifically UQ28225 which addresses the following points: [...] 5587 105 42_Balt./Wash. DB2 Users' Group--Bonnie Baker0_19_valeriet@US.IBM.COM31_Thu, 16 Mar 2000 08:57:32 -0500666_us-ascii SPECIAL DB2 COURSE WITH BONNIE BAKER Sponsored by the Baltimore/Washington DB2 Users' Group

When? Wednesday, June 14, 2000

When? Sheraton Columbia Inn, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Who? Bonnie Baker is an internationally-recognized DB2 educator, consultant, and application architect. She has over 18 years of information systems experience, concentrated in DB2 for OS/390. While Bonnie spends much of her time performing design reviews and performance tuning consulting engagements, she is best known for creating and presenting a series of DB2 seminars entitled, "Things I Wish They'd Told Me 8 Years Ago." [...] 5693 163 50_Re: Running multiple DB2's on a single OS/390 lpar11_Cole, Randy30_Randy.Cole@GENERALCASUALTY.COM31_Thu, 16 Mar 2000 07:51:52 -0600578_iso-8859-1 Susan,

I noticed your response to Dave because I have the same question/situation as Dave does right now. Just a follow-up question to your reply to Dave--we are thinking about doing the exact same thing as what you are doing. My dilemma is this--how do I allocate a different STEPLIB when the user chooses a different subsystem? For example, if the user wants to use DB2T they need the LOGON PROC's steplib pointing to DSN=SYS4.DSN510.SDSNEXIT.T. If the user chooses DB2P, the LOGON PROC's steplib should point to DD DISP=SHR,DSN=SYS4.DSN510.SDSNEXIT.P. [...] 5857 15 34_Re: read trace (ifcid = 6) mystery14_Susan Birgeles25_Susan.Birgeles@ALLTEL.COM31_Thu, 16 Mar 2000 08:58:00 -0600487_us-ascii ================================================ To change your subscription options or to cancel your subscription visit the DB2 -L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached a t DB2-L-REQUEST@RYCI.COM.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5873 138 50_Re: Running multiple DB2's on a single OS/390 lpar13_Dave Bargeron29_Dave.Bargeron@LLOYDSTSB.CO.UK31_Thu, 16 Mar 2000 14:02:56 -0000678_iso-8859-1 Cheers, Susan. Thats the kind of answer I was looking for. Dave

-----Original Message----- From: Loria, Susan C. [mailto:Susan_C_Loria@TVRATINGS.COM] Sent: 16 March 2000 13:19 To: DB2-L@RYCI.COM Subject: Re: Running multiple DB2's on a single OS/390 lpar



Hi Dave,

We run three subsystems on one LPAR within our environment.

When I invoke getting into these subsystems, I use an logon PROC which calls a CLIST which invokes other various CLISTS which each of them allocates the correct libraries once I make a subsystem selection off my main ISPF panel. We keep each DB2 subsystems separate as far as libraries and maintenance [...] 6012 66 50_Re: Running multiple DB2's on a single OS/390 lpar0_17_JTonchick@AOL.COM29_Thu, 16 Mar 2000 09:17:37 EST612_US-ASCII Dave,

I have always used a separate set of libraries for each of my DB2 or IMS subsystems. I do not use any of the SDSNLOAD or RESLIB datasets in the linklist. I found that it complicates the way I perform maintenance and upgrades to software and individual systems.

To make things easier for the application programmers, I provide JCL procedures that accept the subsystem id as part of the proc. This then steplibs the appropriate subsystem libraries. For TSO, clists or REXX perform similar functions. This way, I keep the libraries unallocated except for active tasks, And for TSO [...] 6079 197 50_Re: Running multiple DB2's on a single OS/390 lpar15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 16 Mar 2000 09:40:02 -0500449_us-ascii Randy, a real short answer for steplib is if you are running under ISPF use libdef of the load libraries to ISPLLIB (the ispf load library) for each subsystem. That is what we do here. HTH Bob Lawrence DBA Boscov's Dept Stores

-----Original Message----- From: Cole, Randy [SMTP:Randy.Cole@GENERALCASUALTY.COM] Sent: Thursday, March 16, 2000 8:52 AM To: DB2-L@RYCI.COM Subject: Re: Running multiple DB2's on a single OS/390 lpar [...] 6277 97 50_Re: Running multiple DB2's on a single OS/390 lpar13_Dave Bargeron29_Dave.Bargeron@LLOYDSTSB.CO.UK31_Thu, 16 Mar 2000 14:43:21 -0000532_iso-8859-1 Very useful esp the TSO bit...Thanks

-----Original Message----- From: JTonchick@AOL.COM [mailto:JTonchick@AOL.COM] Sent: 16 March 2000 14:18 To: DB2-L@RYCI.COM Subject: Re: Running multiple DB2's on a single OS/390 lpar



Dave,

I have always used a separate set of libraries for each of my DB2 or IMS subsystems. I do not use any of the SDSNLOAD or RESLIB datasets in the linklist. I found that it complicates the way I perform maintenance and upgrades to software and individual systems. [...] 6375 92 32_Re: Question regarding IRLM lock19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 16 Mar 2000 09:01:15 -0600589_ISO-8859-1 Tracy, There is a internal serialization table used by DB2 Utilities where these "locks" are kept. I've been bit by same thing. Don't know if its related to running out of active log space.

HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and [...] 6468 56 35_AW: BPXK_SETIBMOPT_TRANSPORT OS/39016_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 16 Mar 2000 16:19:54 +0100502_iso-8859-1 quoted from the IBM Cforum --------------------------------------

OMVS has added a new DD JOB step to allow a DB2 subsystem to associat with a specific TCP/IP stack. Refer to APAR OW40460 for details.

With that apar, you would add something like AFFSTEP:

SYS1.PROCLIB(DB2PROC) //AFFSTEP EXEC,PGM=BPXTCAFF,PARM=tcpname //DB2STEP EXEC,PGM=DB2,PARM='DB2s parms' //DB2DATA DD DSN=...

Regards, Kurt Daverman OS/390 Tcp/ip Development ---------------------------- [...] 6525 39 24_FW: DB2 Connect and ODBC13_Tierney, Mark20_mtierney@FIRSTAM.COM31_Thu, 16 Mar 2000 10:32:57 -0600536_- > -----Original Message----- > From: Tierney, Mark > Sent: Thursday, March 16, 2000 10:29 AM > To: 'DB2LIST' > Subject: DB2 Connect and ODBC > > Greetings.... > > Not being an ODBC type person and new to DB2 Connect I am curious about > users access to DB2 from "off the shelf" ODBC compliant products. Has > anyone done anything with DB2 Connect-EE and ODBC access from outside ones > own LAN/WAN? If so, how does the ODBC client see/get to the DSN supported > by DB2 Connect-EE (DB2 5.1)? > > Any help or info would be greatly [...] 6565 20 19_DB2 Connect and ADO13_Gia Villaluna32_Gia.Villaluna@BERGENBRUNSWIG.COM31_Thu, 16 Mar 2000 10:15:49 -0600404_- We are attempting to convert our VB 5.0 Application database from SQL Server to DB2 - Using DB2 Connect. However, we are also using ADO 2.0 . We are trying to test a very simple connection and recordset retrieval appl., to sample the process if it is even possible, but we could not get to work. Does Anyone have any experience in using ADO and DB2 Connect and provide some tips to make it work ? [...] 6586 50 55_Re: Switch to large tablespace - anything to watch for?11_James Drewe20_James.Drewe@AEXP.COM31_Thu, 16 Mar 2000 10:00:17 -0700365_- Max

I just wanted to add one additional note on large tablespaces. I have in production several large tablespaces of 248 partitions each. We started taking SVC dumps when an application did a four way join involving large tablespaces (don ,t worry, it was indexed!). It turned out that any join of large tables greater than two would cause the abend. [...] 6637 14 22_Archives of ListServer0_20_bjnigh@HOUSEHOLD.COM31_Thu, 16 Mar 2000 09:29:12 -0800437_us-ascii Is there a way to get back to something that was sent thru the listserver? I was interested in a past post that talked about the DB2 catalog and the need for keeping the catalog reorged.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6652 22 15_isolation level13_Embar, Satish21_Satish.Embar@NIKE.COM31_Thu, 16 Mar 2000 09:42:43 -0800513_us-ascii Hi!

I have a quick question. I have a plan bound with Isolation level RR which consists of five packages each bound with Isolation CS.

Could someone kindly tell me what Isolation will finally prevail when the plan is running ?

Thanks. satish

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6675 27 26_Re: Archives of ListServer10_Leo Flores23_leoflores@EARTHLINK.NET31_Thu, 16 Mar 2000 10:14:19 -0800675_us-ascii For Post's Archives -------> http://jupiter.ryci.com/archives/db2-l.html

For Documents -------------> http://jupiter.ryci.com/archives/db2-l-documents.html

HTH Leo Flores

bjnigh@HOUSEHOLD.COM wrote:

> Is there a way to get back to something that was sent thru the listserver? I > was interested in a past post > that talked about the DB2 catalog and the need for keeping the catalog reorged. > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...] 6703 367 46_Re: Balt./Wash. DB2 Users' Group--Bonnie Baker16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Thu, 16 Mar 2000 13:25:15 -0500680_iso-8859-1 For those of us who have a problem convincing our companies to let us attend many meetings, conferences, etc -- is there a place where we can get printed copies of Bonnie Baker's information?

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: valeriet@US.IBM.COM [SMTP:valeriet@US.IBM.COM] > Sent: Thursday, March 16, 2000 8:58 AM > To: DB2-L@RYCI.COM > Subject: Balt./Wash. DB2 Users' Group--Bonnie Baker > > SPECIAL DB2 COURSE WITH BONNIE BAKER > Sponsored by the Baltimore/Washington DB2 Users' Group > > When? > Wednesday, June 14, 2000 > > When? > Sheraton Columbia Inn, 10207 Wincopin [...] 7071 59 50_Re: Running multiple DB2's on a single OS/390 lpar24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Thu, 16 Mar 2000 14:06:16 -0500380_- Dave,

You may want to chk the archives as this topic was discussed heavily about a month ago. There were many interesting ideas presented.

As for my shop, I keep our 6 subsystems (all in one lpar) isolated from each other with separate libs, with the exception of ERLY code which is used at the highest level installed across the lpar. Nothing is linklisted. [...] 7131 24 18_Re: DB2 Compaction12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 16 Mar 2000 13:00:00 -0500504_- Make sure you test your archiving. There was a problem with DB2 a long time ago when we first did this. We ended up turning on compaction for the archives in order for them to work. You probably won't have this problem, since it was (I think) in DB2 3.1, but you should consider checking it anyway if you are archiving to tape. >>> DB2-L@RYCI.COM@inter2 03/15/00 07:26PM >>> Does anyone know if you have to change the DB2 installation parameter for compaction if you add IDRC to your tape drives? [...] 7156 40 26_Re: Archives of ListServer24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Thu, 16 Mar 2000 14:32:47 -0500783_- Are the archives available from before the move to the current "ryci" list server? They were of great help.

Dave

-----Original Message----- From: Leo Flores Sent: Thursday, March 16, 2000 11:14 AM To: DB2-L@RYCI.COM Subject: Re: Archives of ListServer

For Post's Archives -------> http://jupiter.ryci.com/archives/db2-l.html

For Documents -------------> http://jupiter.ryci.com/archives/db2-l-documents.html

HTH Leo Flores

bjnigh@HOUSEHOLD.COM wrote:

> Is there a way to get back to something that was sent thru the listserver? I > was interested in a past post > that talked about the DB2 catalog and the need for keeping the catalog reorged. > > ================================================ > To change your subscription [...] 7197 20 21_db2 for unix question12_Pablo Lucero18_plucero@TTI.COM.AR31_Thu, 16 Mar 2000 17:03:09 -0300299_iso-8859-1 Hi, all Sorry if I send this again, but as I got no answers I try again. May be somebody from the lab is listening... We have a request to provide a RDBMS with a multithreaded architecture. Do you know if DB2 (in UNIX environments) fulfill this requirement? Thanks all, Pablo Lucero [...] 7218 28 41_Re: DB2 CONNECT PE holding locks forever.12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Fri, 17 Mar 2000 09:16:44 +1300463_us-ascii Danny,

Something that might help. To get idle DDF threads to die automatically after the IDTHTOIN interval you need to specify CMTSTAT=ACTIVE. The timeout interval only applies to idle, active threads. Check out the exact wording in the Installation Guide, pg. 2-202/203. Not sure why your inactive threads still hold locks - haven't been following that aspect too closely I'm afraid - but this at least will kill them automatically for you. [...] 7247 53 26_Re: Archives of ListServer10_Leo Flores23_leoflores@EARTHLINK.NET31_Thu, 16 Mar 2000 12:29:38 -0800699_us-ascii I agree, but I don't believe they will be copied to this list server. You can ask the list owners at

DB2-L FAQ -------------> http://www.ryci.com/db2-l/

HTH Leo Flores

Gendron, Dave (Exchange) wrote:

> Are the archives available from before the move to the current "ryci" list server? They were of great help. > > Dave > > -----Original Message----- > From: Leo Flores > Sent: Thursday, March 16, 2000 11:14 AM > To: DB2-L@RYCI.COM > Subject: Re: Archives of ListServer > > For Post's Archives -------> http://jupiter.ryci.com/archives/db2-l.html > > For Documents -------------> http://jupiter.ryci.com/archives/db2-l-documents.html > > HTH > Leo Flores > [...] 7301 61 26_Re: Archives of ListServer16_Swinski, Kenneth32_KSwinski@INTERNAL.MASSMUTUAL.COM31_Thu, 16 Mar 2000 15:32:10 -0500724_us-ascii They are also kept at -----> http://www.deja.com/usenet/

> -----Original Message----- > From: Gendron, Dave (Exchange) [SMTP:Dave.Gendron@COASTALCORP.COM] > Sent: Thursday, March 16, 2000 2:33 PM > To: DB2-L@RYCI.COM > Subject: Re: Archives of ListServer > > Are the archives available from before the move to the current "ryci" list > server? They were of great help. > > Dave > > -----Original Message----- > From: Leo Flores > Sent: Thursday, March 16, 2000 11:14 AM > To: DB2-L@RYCI.COM > Subject: Re: Archives of ListServer > > For Post's Archives -------> http://jupiter.ryci.com/archives/db2-l.html > > For Documents -------------> > http://jupiter.ryci.com/archives/db2-l-documents.html > > HTH [...] 7363 62 53_Re: Archives of ListServer - other OS/390 ListServer.10_Leo Flores23_leoflores@EARTHLINK.NET31_Thu, 16 Mar 2000 13:04:19 -0800769_us-ascii Yes, try "Subscribe to Mainframe Related Discussion Groups" at http://www.nauticom.net/www/softwise/mfdisc.htm

I counted 26 different different discussion groups there.

HTH Leo Flores

b.friel@pecorp.com wrote:

> Do you know of any other useful OS/390 List Servers (CICS, MVS, languages, > JCL) ? > > Who would be a good contact to get subscriber information ? > > Thanks in advance. > Brendan > > ---------- > From: Leo Flores [SMTP:leoflores@EARTHLINK.NET] > Sent: Thursday, March 16, 2000 12:14 PM > To: DB2-L@RYCI.COM > Subject: Re: Archives of ListServer > > For Post's Archives -------> > http://jupiter.ryci.com/archives/db2-l.html > > For Documents -------------> > http://jupiter.ryci.com/archives/db2-l-documents.html [...] 7426 117 32_Re: Question regarding IRLM lock11_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 16 Mar 2000 13:29:30 PST606_- FYI, You might want to call IBM support on this one. We had the same error message a couple of months ago and IBM had a couple of PTFs relating to this error that they recommended we put on. Sorry I do not have them. Regards, Rick Creech

>From: "DAVIS, RICK (SBCSI)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Question regarding IRLM lock >Date: Thu, 16 Mar 2000 09:01:15 -0600 > >Tracy, > There is a internal serialization table used by DB2 Utilities >where >these "locks" are kept. I've been bit by same thing. Don't [...] 7544 21 16_DB2 V6 Utilities16_Marcelo Silveira22_mardb2ques@HOTMAIL.COM29_Thu, 16 Mar 2000 21:57:05 GMT572_- Hi everyone,

I'd like to know if someone who is already using DB2 UDB for OS/390 V6 has noticed any real improvement in DB2 Utilities, mainly in elapsed times.

I appreciate your attention,

Marcelo. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 7566 47 110_Repost: Call for Presentation for 2000 IDUG Asia-Pacific Conferen ce - 15 -17 November in Melbourne, Australia13_Morrill, John12_JohnM@VP.NET31_Thu, 16 Mar 2000 16:31:14 -0700735_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

If you are interested in delivering a technical presentation at the 6th Annual IDUG Asia Pacific Conference, 15-17 November 2000 in Melbourne, Australia, visit http:// www.idug.org and fill out the 2000 Asia Pacific Call for Presentations. Abstracts will be accepted until 21 April. Those who are selected to deliver presentations [...] 7614 61 56_Repost: DB2 Wins SIIA Award for Best Enterprise Software13_Morrill, John12_JohnM@VP.NET31_Thu, 16 Mar 2000 16:31:14 -0700722_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

IBM's DB2 has won the Software & Information Industry Association's (SIIA) Codie Award for "Enterprise Software / Best Product". The awards were announced at the SIIA InfoSoft Summit May 11-14 in San Diego. The Codie Award promotes and commemorates the advancement of the software and information industry. It goes to [...] 7676 41 19_Re: isolation level11_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 16 Mar 2000 17:43:08 CST685_- Statement isolation(if any) overrides the package and the package isolation leve (if different from plan) overrides the plan. So you will run with CS.

Suresh

>From: "Embar, Satish" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: isolation level >Date: Thu, 16 Mar 2000 09:42:43 -0800 > >Hi! > > I have a quick question. I have a plan bound with Isolation level >RR >which consists of five packages each bound with Isolation CS. > > Could someone kindly tell me what Isolation will finally prevail >when the plan is running ? > >Thanks. >satish > >================================================ >To [...] 7718 55 18_Oracle or Informix6_RandyS27_RandyS@EMPLOYMENTTRENDS.COM31_Thu, 16 Mar 2000 16:11:57 -0800129_iso-8859-1 Does anyone know of similar Listserves for Oracle and/or Informix?

Thanks,

Randy





7774 33 46_Re: Balt./Wash. DB2 Users' Group--Bonnie Baker12_Jim Harrison12_jimh@QIS.NET31_Thu, 16 Mar 2000 14:27:10 -0500625_us-ascii Somebody posted this address a few days ago. There are links to several of Bonnie's articles which closely parallel her presentations. It looks like most of them are in DB2 Magazine. http://www.multimania.com/db2usa/earticle.htm

The printed materials that accompany her presentations are actually not much use by themselves. They are mostly just high level talking points on which she expands on in class. If your company won't let you go anywhere, why not have Bonnie visit you instead. We had her in for two days earlier this month and she's coming back for two more days in April. Highly recommended! [...] 7808 21 33_function to get last day of month17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Thu, 16 Mar 2000 18:45:19 PST334_- Hi Folks,

we are using DB2 V4. i wanted to get last day of month in the current date, is there any function in db2 v4 to get last day month, if not how do i get last day of month.

Thanks in advance Ravi ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com [...] 7830 30 49_Re: nulls and an applicable / inapplicable status13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 16 Mar 2000 22:14:36 -0500628_iso-8859-1 Hi Judi, Looks to me like you've not had any response to this question.

I suspect that might be because no one else has heard those terms regarding nulls. I have never seen or heard "applicable" applied to nulls. Columns can be defined as Null, Not Null, or Not Null with default. Unless you have some other recollections about what applicable/inapplicable status might mean, I can only guess you might be thinking of Null Indicators which are host variables which must accompany nullable column retrievals(or other results which might return null result--such as the SUM column function). But these have [...] 7861 85 37_Re: function to get last day of month0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 17 Mar 2000 11:38:10 +0800416_us-ascii Ravi,

I'm not sure if there's a function in V4, but you can do it in SQL (but it's not pretty!):

select current date ,DATE(SUBSTR(CHAR(current date),1,3)||'01'||SUBSTR(CHAR(current date),6,5)) +1 month - 1 day from sysibm.systables where name = 'SYSTABLES'

1 2 ---------- ---------- 03/17/2000 03/31/2000

You may have to change the SUBSTR etc depending on your date format. [...] 7947 51 37_Re: function to get last day of month11_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 16 Mar 2000 21:43:08 CST373_- No such function that I am aware of in V4. You might try:

SELECT CURRENT DATE - DAY(CURRENT DATE) DAYS + 1 DAY + 1 MONTH - 1 DAY FROM SYSIBM.SYSDUMMY1

The order is VERY important. Example:

today is 2000-03-16. Subtract 16 gets you Feb 29th, adding 1 gets you March 1st, adding 1 month gets you April 1st and then subtract 1 gets you March 31st. [...] 7999 21 55_Re: Switch to large tablespace - anything to watch for?9_Paul Yuen16_pyuen@GIO.COM.AU31_Fri, 17 Mar 2000 14:43:48 +1000380_us-ascii Hi all, I'd like to thank everyone for the response. It's decided we'll use the large tablespace, and I'll definetly keep an eye on our home-grown dba tools. And yes the tablespace is compressed already, and this particular table will only be updated offline so we should be ok when if we decide to upgrade to V6 and take advantage of the DSSIZE. Thanks again, Paul [...] 8021 68 37_Re: function to get last day of month14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Fri, 17 Mar 2000 13:44:05 +1000403_us-ascii Ravi, I'm sure there are easier ways, but I just had a play with the following in QMF and it seems to work.

SELECT DATE(SUBSTR(A,1,3)||SUBSTR(A,5,3)||SUBSTR(A,9,4)) - 1 DAY FROM ( SELECT '01.'|| CHAR(DECIMAL(MONTH(CURRENT DATE + 1 MONTH),2,0))|| CHAR(DECIMAL(YEAR(CURRENT DATE + 1 MONTH),4,0)) AS A FROM SYSIBM.SYSDUMMY1) AS YEAR_TABLE

Some permutation of that should be OK. [...] 8090 95 29_Re: Possible trivia question?15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 16 Mar 2000 16:49:44 -0600688_us-ascii Another piece of trivia.

The Annn suffix stems from the old VSAM KSDS KEYRANGE dataset catalog entries (logically dividing a physical entity/dataset would build uncatalog Annn suffix appended to the primary dataset name). Keyrange datasets were designed to provide disproportionate number of I/Os against each keyrange (partition in DB2-talk).

Jim Lewandowski



Randall Ibbott wrote: > > What happens when a PARTITIONED tablespace (say 17-32 partitions) breaks > the 2GIG limit - if the 'A00x' qualifier is the partition number, what is > the name of the second dataset? This is something we were wondering when > doing some partitioning recently [...] 8186 21 37_Automate logs & image copies archival16_Eric Ng Yew Heng22_ngyh@PUBLICBANK.COM.MY31_Fri, 17 Mar 2000 14:53:50 +0800525_us-ascii My shop is using UDB V6.1 on NT.

Is there anybody out there have some smart ways/procedures to archive away, or even delete away the old archive logs as well as old image copies?

Since we do not have ADSM, is there a way to automate it ?

Eric Ng



================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 8208 27 15_DB2 IFCID (185)13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Fri, 17 Mar 2000 12:40:11 +0530552_us-ascii hi !!

I have a query !! The IFCIF 185 is for support for Data propagation . We want to start this feature and capture the data for propagation. I have modified the Db2 installation panels for DPROP support . I also have turned on trace class 6 . (monitor) . I have defined certain tables for Data capture. We have an applciation which is written for reading IFCID 185 and capture the chages. But now once I define the table for data capture changes, it gives a '0C4' abend thru spufi. and abnormal termination of task. It does not [...] 8236 83 41_Re: Automate logs & image copies archival0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 17 Mar 2000 15:47:05 +0800570_us-ascii Eric,

There is a shareware product called ZDel98 which is fairly versatile and can be configured to delete files older than x days etc. It is also very cheap. It may help with what you are trying to achieve. Have a look at this URL:

http://members.aol.com/pjsoftware

You can use several ways to automate it (use the DB2 script centre to run a batch file etc) but the simplest on NT is the AT scheduler that comes with NT. There is an improved version called WinAT which I think(?) is in the NT Resource Kit - otherwise search the Net. [...] 8320 64 99_=?iso-8859-1?q?R=E9f?= =?us-ascii?q?=2E_=3A_?= =?us-ascii?q?Automate?= logs & image copies archival14_Denzil Coalter26_denzil.coalter@UNICIBLE.CH31_Fri, 17 Mar 2000 08:53:34 +0100376_iso-8859-1 Check the archives as this has already been discussed but basically you could install the UDB supplied user exit which can archive the active logs once they have been closed. You can change the user exit specifying the directory to place the archive logs. Then you can create a script file to periodically scan the archive directory deleting unnecessary logs. [...] 8385 24 55_Re: Switch to large tablespace - anything to watch for?14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 17 Mar 2000 08:54:21 +0100566_us-ascii Thanks for infos.

Our large tablespace is an historical DB and we have (until now !!) no complex join. But I don't

exclude that in future there will be the need to perform more complicated research to provide

information to marketing people. So I'm warned now !

Regards

Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 8410 191 50_Re: Running multiple DB2's on a single OS/390 lpar14_Tom Decabooter27_Tom.Decabooter@HONDA-EU.COM31_Fri, 17 Mar 2000 08:55:06 +0100424_us-ascii We are having 1 lpar with 2 (production) DB2 systems and 1 lpar with 4 DB2 systems (test and development). I will focus on the production systems for the text below. They are called DB2S (operational) and DB2I (information warehouse).

Our DB2 libraries are called DB2.V5R1M0.SDSN* and SYS1.DB2.V5R1M0.SDSN* for linklist. The SDSNEXIT is a seperate library for each DB2 called 'db2ssid.V5R1M0.SDSNEXIT'. [...] 8602 35 34_Performance problem - DB2 v4 OS3909_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Fri, 17 Mar 2000 10:37:33 -0000391_ISO-8859-1 Problem:

I have a delete where current of cursor statement which seems to be scanning the whole table to perform the delete.

I am assuming it is this statement which is causing the scan as the only other statements affecting this table in the CICS program are an insert and a select cursor. The select is using 4 columns from an index and fetching 1 or 2 rows. [...] 8638 127 40_FW: Fai girare qsta lettera per favore..13_Tomassi, Aldo20_Aldo_Tomassi@BMC.COM31_Fri, 17 Mar 2000 05:02:22 -0600559_ISO-8859-1 Ragazzi fatelo ..... per favore ! ciao Aldo.

> >03 Marzo 2000 > > > >Caro Lettore, forse tu puoi aiutarmi! > >Mi chiamo Daniele Brandani e ho una figlia di 2 anni di eta'che si chiama > >Lucia. In Ottobre 1999 abbiamo scoperto che Lucia ha un cancro, si tratta > >piu'precisamente di un "endocarcinoma surrenalico secernente",una forma > >molto rara nei bambini.Purtroppo dopo due operazioni e la chemioterapia > >fatta (si tratta di un ciclo con Mitotane associato a > >Etoposide, Doxorubicin e Cisplatino) non abbiamo avuto il minimo [...] 8766 47 38_Re: db2 start failure - bsds timestamp14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 17 Mar 2000 11:29:46 -0000354_- Or better still,

Do a BSDS print of BOTH BSDSs to see what each of them thinks is the highest RBA and in which active log. THEN use DSN1LOGP to make sure that you have BOTH (or at least ONE) of those RBA ranges available.

THEN copy the correct BSDS over the top of the incorrect one AFTER taking an IDCAMS REPRO backup of them BOTH. [...] 8814 34 29_DB2 Connect PE / 10038 error.18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Fri, 17 Mar 2000 06:35:53 -0500608_iso-8859-1 Let me see if I can post this again and see if anyone might be able to help with this error msg. Has anyone encountered this using DB2 Connect PE?? I cannot find any info related to a '10038' error code. Would appreciate any help. Thank-You:

>>Error msg: IBM CLI Drive(db2) SQL30081N A communication error has been detected. Communications protocol being used: 'TCP/IP'. Communications API being used: 'SOCKETS'. Location where the error was detected: "". Communications function detecting the error. "recv". Protocol specific error code(s): "10038" ,"*","*". SQLSTATE=08001 (#-30081) [...] 8849 26 38_Re: db2 start failure - bsds timestamp14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 17 Mar 2000 13:08:18 +0100393_us-ascii That's correct procedure for production. I restarted many and many times TEST systems with

corrupted BSDS without any problem. Ok I always renamed the wrong BSDS before creation of

a new one (who knows ? Never delete a critical VSAM dataset, just rename it).

But, just a curiosity, which version of DB2 caused the problem (i think v 2.3) and was the problem [...] 8876 114 22_Re: DDF not behaving !11_Nancy Reile24_Nancy.E.Reile@AM.PNU.COM31_Fri, 17 Mar 2000 08:20:49 -0500364_ISO-8859-1 Rob,

This is very timely for us since we just had a meeting with an application developer to discuss open thread problems with one of his applications. We've already checked out the other suggestions from the list like idle thread timeout limit, issuing commits ... We've found that in many cases it depends on how the application is coded. [...] 8991 48 50_Re: Running multiple DB2's on a single OS/390 lpar12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Fri, 17 Mar 2000 07:27:00 -0500590_- At our site: Each DB2 subsystem has a dsnexit and dsnload. Normally, we have a separate logon proc for Development, QA and production environments. The procs have the oldest environment (Dev, QA,Prod) dsnexit, dsnload and dsqload (QMF) in ISPLLIB. We use a separate Logon Proc when we do maint. DB2s are removed from normal procs and put into this proc as maint. is applied. Use of the normal procs resumes when all DB2s have the new maint. Recently, we purchased a product from Tone Software called Dynastep. It is suppose to give us dynamic steplibs. We have several products that [...] 9040 153 32_Re: Question regarding IRLM lock14_Johnson, Tracy22_TJohnson@GUIDEMAIL.COM31_Fri, 17 Mar 2000 07:22:23 -0600560_iso-8859-1 Thanks for your replies. I've put a call into IBM and will try & post a solution, once available.

Tracy Johnson

-----Original Message----- From: rick creech [mailto:ykcirc@HOTMAIL.COM] Sent: Thursday, March 16, 2000 3:30 PM To: DB2-L@RYCI.COM Subject: Re: Question regarding IRLM lock

FYI, You might want to call IBM support on this one. We had the same error message a couple of months ago and IBM had a couple of PTFs relating to this error that they recommended we put on. Sorry I do not have them. Regards, Rick Creech [...] 9194 138 53_Repost: "DB2 Jumpstart!" Classes (North America only)13_Morrill, John12_JohnM@VP.NET31_Fri, 17 Mar 2000 06:44:27 -0700667_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties (USA and Canada),

Below is an announcement about a course offered by IBM and RYC, Inc. to help you get started with DB2 Universal Database for Windows NT. Full details and registration information can be found at: http://www.ryci.com/ryc/JumpStartDB2.htm [...] 9333 41 38_Re: db2 start failure - bsds timestamp14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 17 Mar 2000 13:53:36 -0000613_- Hi Max,

It was Operator Error. They moved my active logs and one BSDS without shutting down DB2. So DB2 continues to write to the old locations, but the ICF catalog contained the NEW ones. Next shutdown and restart, DB2 got MIGHTY confused!!

Phil G

> -----Original Message----- > From: Massimo Scarpa [SMTP:mscarpa@CESVE.IT] > Sent: Friday, March 17, 2000 12:08 PM > To: DB2-L@RYCI.COM > Subject: Re: db2 start failure - bsds timestamp > > That's correct procedure for production. I restarted many and many times TEST > systems with > > corrupted BSDS without any problem. Ok I always [...] 9375 53 49_Re: nulls and an applicable / inapplicable status15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Fri, 17 Mar 2000 09:10:18 -0500425_us-ascii I believe this concept was in an article by C J DATE in Database Programming and Design. I no longer have my copies of this magazine to find the reference.

HTH Bob Lawrence DBA Boscov's Dept Stores

-----Original Message----- From: Seibert, Dave [SMTP:Dave_Seibert@COMPUWARE.COM] Sent: Thursday, March 16, 2000 10:15 PM To: DB2-L@RYCI.COM Subject: Re: nulls and an applicable / inapplicable status [...] 9429 56 38_Re: Performance problem - DB2 v4 OS39015_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Fri, 17 Mar 2000 09:20:48 -0500442_us-ascii Jim I believe for update of any column in the table will work HTH Bob Lawrence DBA Boscov's Dept STores

-----Original Message----- From: Jim Leask [SMTP:jim.leask@RS-COMPONENTS.COM] Sent: Friday, March 17, 2000 5:38 AM To: DB2-L@RYCI.COM Subject: Performance problem - DB2 v4 OS390

Problem:

I have a delete where current of cursor statement which seems to be scanning the whole table to perform the delete. [...] 9486 33 38_Re: db2 start failure - bsds timestamp14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 17 Mar 2000 15:22:24 +0100374_us-ascii A really mess !!! I agree !! But this is something outside DB2 itself, resembling a system crash

(lato sensu) instead a DB2 out-of-sync or I/O problem. But it happens !!!

But I'm wondering how they could move BSDS AND active logs while DB2 was running.

The ICF catalog entry is locked when a subsystem is running and using a catalog file. [...] 9520 21 38_Re: Performance problem - DB2 v4 OS39014_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Fri, 17 Mar 2000 09:32:17 -0500397_us-ascii Do you have a Foreign Key defined on the table in question that is self referencing (i.e. FK defined on COLE referencing PRIMARY KEY COLA with DELETE CASCADE) and no index defined on COLE? This type of situation as well as any child tables that reference the table in question and don't have indexes defined for the foreign key will suffer the tablespace scan on the DELETE CASCADE. [...] 9542 13 12_DB2 Training12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Fri, 17 Mar 2000 08:34:00 -0500397_- Does anybody know if the instructors at the non IBM training centers, for example Availant in Austin, Tx., are IBM instructors?

Thanks in advance.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9556 53 20_Re: DB2 V6 Utilities20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 17 Mar 2000 09:44:26 -0500351_us-ascii The biggest improvement that I have observed is parallel index build. I loaded a table of over 1 k row size and 10 million rows with 6 indexes. I used the SORTNUM and SORTKEYS to build the indexes in parallel as subtasks. There was a tremendous improvement in the elapsed time due the parallel subtasks however CPU was the price to pay. [...] 9610 21 31_-138 on Substr function on V6.10_18_DB2DBAinTX@AOL.COM29_Fri, 17 Mar 2000 10:07:55 EST539_US-ASCII I am running a query on sysibm.syscolumns table. In the select statement, I am getting a -138 on an expression SUBSTR(DEFAULTVALUE,1,254).

Is anybody else getting this? Or this is a PTF to address this?

SELECT SUBSTR(DEFAULTVALUE,1,254) from SYSIBM.SYSCOLUMNS;

Thanks

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9632 97 33_Problem dropping table in DSNDB0413_Burgess, Greg20_Greg.Burgess@SSA.GOV31_Fri, 17 Mar 2000 10:02:56 -0500271_iso-8859-1 We have tried unsuccessfully to drop a database in DSNDB04, receiving the error message below. Has anybody encountered this problem? Thanks for any information.





---------+---------+---------+---------+---------+---------+---------+------ 9730 35 35_Re: -138 on Substr function on V6.120_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 17 Mar 2000 10:21:59 -0500648_us-ascii It works well for me in both V5 as well as V6.

> -----Original Message----- > From: DB2DBAinTX@AOL.COM [SMTP:DB2DBAinTX@AOL.COM] > Sent: Friday, March 17, 2000 10:08 AM > To: DB2-L@RYCI.COM > Subject: -138 on Substr function on V6.1 > > I am running a query on sysibm.syscolumns table. In the select statement, > I > am getting a -138 on an expression SUBSTR(DEFAULTVALUE,1,254). > > Is anybody else getting this? > Or this is a PTF to address this? > > SELECT SUBSTR(DEFAULTVALUE,1,254) from SYSIBM.SYSCOLUMNS; > > Thanks > > ================================================ > To change your subscription options or to cancel [...] 9766 30 35_sql5048 cataloging db2 6.1 database0_25_Pierre.Evans@AUTOZONE.COM31_Fri, 17 Mar 2000 09:29:47 -0600465_us-ascii Greetings all, I've beeen encountering the following error when I attempt to connect to a db2 v6 database on MVS, catalogued from a udb instance on aix.

SQL5048N The release level of the database client is not supported by the release level of the database server. Explanation: Database clients can only access database servers with a release level which is in the range of one level lower than the client to two levels higher than the client. [...] 9797 43 19_Re: DB2 IFCID (185)20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 17 Mar 2000 10:27:01 -0500567_us-ascii Have done this long time ago. Can't remember exactly but had no problem with data capture in those days.

> -----Original Message----- > From: Viswanathan N [SMTP:Viswanathan.N@POWAIMAIL.LTITL.COM] > Sent: Friday, March 17, 2000 2:10 AM > To: DB2-L@RYCI.COM > Subject: DB2 IFCID (185) > > hi !! > > I have a query !! The IFCIF 185 is for support for Data propagation . > We want to start this feature and capture the data for propagation. I have > modified the Db2 installation panels for DPROP support . I also have > turned > on trace class 6 . [...] 9841 43 32_DB2 OS390 Stored Procedure Error15_Morris, Deborah20_DMorris@UNCH.UNC.EDU31_Fri, 17 Mar 2000 10:38:54 -0500518_iso-8859-1 I am getting the following errors when attempting to execute a DB2 OS390 Stored Procedure:

- calling program (cobol batch) returns a sqlcode = -965 (stored procedure terminated abnormally) on call to a db2 stored procedure (SPRADRS1)

- DB2 Stored Procedure Address Space displays a DSNX966I message as follows:

DSNX966I DSNX9SER Stored Procedure SPRADRS1 failed LE/370. CEEPIPI ENCLAVE RC = 3000, Feedback Information = IGZ0037 SSN = DB22 PROC = DB22SPAS ASID = 0066 WLM_ENV = ' ' [...] 9885 115 37_Re: Problem dropping table in DSNDB0412_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Fri, 17 Mar 2000 09:43:00 -0500602_- Looks like your catalog and directory are out of sync. Call IBM they will probably tell you to run: REPAIR DBD TEST, DIAGNOSE then depending on the results REBUILD

//UTIL EXEC DSNUPROC,SYSTEM=DB??,UID='REPR',UTPROC='', // LIB='DB2.DB??.DSNLOAD' //* //DSNUPROC.SYSIN DD * REPAIR DBD TEST DATABASE xxxxxxx //

No warantee, either implied or explicit, included.



>>> DB2-L@RYCI.COM@inter2 03/17/00 09:02AM >>> We have tried unsuccessfully to drop a database in DSNDB04, receiving the error message below. Has anybody encountered this problem? Thanks for any information. [...] 10001 61 55_Re: DB2 Major Weakness: Who can update production data?14_Ulf-Otto Cihak23_UlfCihak@COMPUSERVE.COM31_Fri, 17 Mar 2000 10:48:05 -0500412_ISO-8859-1 (I assume this thread is about explain against production data.)

You can also copy DSNTEP2 under a different name, and change it so that it can only EXPLAIN. This is very easy to achieve if you take a look at this program, because all possible SQL statements are taxatively checked out . Then you can bind it with DYNAMICRULES BIND as a Sysadm and everyone can explain against production. [...] 10063 20 33_*Help* MTS/DTC and DB2 for OS/39014_Bernie OConnor26_Bernie.OConnor@ANIXTER.COM31_Fri, 17 Mar 2000 09:51:08 -0600410_- Colleagues --

Anixter's B2B team has been developing a VB/COM application using MTS with transactional control to talk with DB2 Stored Procedures. Our proof of concept worked very well. Now we are finding that calls to DB2 Stored Procedures do not quite finish -- there is a point at which DTC is waiting on DB2 and DB2 is waiting on something We are not sure if DB2 is, in turn, waiting on DTC. [...] 10084 45 36_Re: DB2 OS390 Stored Procedure Error12_Jim Harrison12_jimh@QIS.NET31_Fri, 17 Mar 2000 10:56:17 -0500634_us-ascii Anything in the CEEDUMP output? That will usually help you narrow things down some. Program displays are also helpful as your debugging options are pretty limited with SPs.

At 10:38 AM 3/17/00 -0500, Morris, Deborah wrote: > I am getting the following errors when attempting to execute a DB2 OS390 >Stored Procedure: > > - calling program (cobol batch) returns a sqlcode = -965 (stored >procedure terminated abnormally) on call to a db2 stored procedure >(SPRADRS1) > > - DB2 Stored Procedure Address Space displays a DSNX966I message as >follows: > > DSNX966I DSNX9SER Stored Procedure SPRADRS1 failed LE/370. > [...] 10130 57 37_Re: function to get last day of month10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Fri, 17 Mar 2000 09:52:56 -0600363_- Here are couple of ways to get last day of the month with SQL.

select case days(current date) - 7 * integer (days(current date) / 7 ) when 0 then 'sunday' when 1 then 'monday' when 2 then 'tuesday' when 3 then 'wedday' when 4 then 'thursday' when 5 then 'friday' when 6 then 'saturday' END CASE from sysibm.sysdummy1; DB2 V4 may not have sysdummy1; [...] 10188 42 35_Re: -138 on Substr function on V6.114_Stevens, Wayne21_Wayne_Stevens@BMC.COM31_Fri, 17 Mar 2000 09:57:23 -0600443_ISO-8859-1 There is an APAR PQ27251 that addresses the -138. The APAR description is INCORRECT OUTPUT SQLCODE -138 INCORRECTLY. The PTF is UQ30942 and is on the 9906 put tape.

Wayne Stevens BMC Software, Inc. wayne_stevens@bmc.com





-----Original Message----- From: DB2DBAinTX@AOL.COM [mailto:DB2DBAinTX@AOL.COM] Sent: Friday, March 17, 2000 9:08 AM To: DB2-L@RYCI.COM Subject: -138 on Substr function on V6.1 [...] 10231 59 19_Re: DB2 IFCID (185)10_Mike Paris14_MPARIS@TUC.COM31_Fri, 17 Mar 2000 09:46:39 -0600604_US-ASCII What release of DPROP are you running?

>>> venkat_pillay@ML.COM 03/17 9:27 AM >>> Have done this long time ago. Can't remember exactly but had no problem with data capture in those days.

> -----Original Message----- > From: Viswanathan N [SMTP:Viswanathan.N@POWAIMAIL.LTITL.COM] > Sent: Friday, March 17, 2000 2:10 AM > To: DB2-L@RYCI.COM > Subject: DB2 IFCID (185) > > hi !! > > I have a query !! The IFCIF 185 is for support for Data propagation . > We want to start this feature and capture the data for propagation. I have > modified the Db2 installation panels for DPROP [...] 10291 76 36_Re: DB2 OS390 Stored Procedure Error15_Morris, Deborah20_DMorris@UNCH.UNC.EDU31_Fri, 17 Mar 2000 11:00:46 -0500409_iso-8859-1 I've got a request in to our systems folks to get this statement added to the Stored Procedure Address Space Proc. So, hopefully that will lead me to the real problem.

Thanks ...

Deborah A. Morris Supervisor DataBase Administration UNC Health Care System 2nd Floor Carr Mill Mall Carrboro, NC 27510

(919) 966-2197 (voice) (919) 966-2110 (fax) mailto: dmorris@unch.unc.edu [...] 10368 66 37_Re: DB2 Connect & Password Encryption10_Park, Stan17_SPark@STATE.NM.US31_Fri, 17 Mar 2000 09:05:02 -0700315_iso-8859-1 Robert, Thanks for posting the fix on this. It works! One question - we are not aware of any way to make Encryption thru Connect/DDF mandatory (DB2 V5.1 OS390 refuses all Non-encrypted connects). Are you aware of any way to do this? We use ACF2 here. Thanks, Stan Park DBA State of New Mexico - USA [...] 10435 18 27_Conversion from VSAM to DB28_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Fri, 17 Mar 2000 10:05:53 -0600458_us-ascii I am looking for a tool to convert VSAM to DB2. I would like to know its advantages and disadvantages. Could somebody share the experiences in using any of this products. Thanks in advance.

Rgds Bejoy

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 10454 46 31_Re: Conversion from VSAM to DB212_Davis, Diane22_DDavis@COR.STATE.PA.US31_Fri, 17 Mar 2000 11:17:15 -0500302_iso-8859-1 Bejoy, Our organization, The Pennsylvania Department of Corrections, is planning to convert from VSAM to DB2. There is an IBM Redbook called How to get to DB2 from VSE/VSAM Using DB2 VSAM Transparency for VSE/ESA. I don't know if this would match your system, but it is what we've got. [...] 10501 19 14_TCPIP/CICS/DB212_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Fri, 17 Mar 2000 10:21:00 -0500395_- We have a new vendor app. and I have a question about the way TCPIP, CICS and DB2 authorizations work together. A display thread of CICS threads shows that all of the AUTHids are the Top Secret ACID of the CICS address space.

Is there somewhere, either in TCPIP, CICS or Top Secret where the AUTH id of the actual user is passed on to DB2? Does the signon exit have to be changed? [...] 10521 51 38_Re: Performance problem - DB2 v4 OS3909_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Fri, 17 Mar 2000 16:37:27 -0000591_ISO-8859-1 Sorry all, problem was found.

After SQL capture was corrected it became clear that it was the delete on the parent table which was causing the problem. No suitable index (correct columns in the wrong order) on the child table for the DELETE RESTRICT check.

Jim.

> -----Original Message----- > From: Jim Leask > Sent: 17 March 2000 10:38 > To: DB2-L Listserv Posts (E-mail) > Subject: Performance problem - DB2 v4 OS390 > > Problem: > > I have a delete where current of cursor statement which seems to be > scanning the whole table to perform the delete. [...] 10573 67 9_Batch SQL11_Mayo Arthur19_Arthur.Mayo@IRS.GOV31_Fri, 17 Mar 2000 11:41:49 -0500326_iso-8859-1 I'm running a batch job to get a count of the number of rows on a table

RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) - 000016 LIB('DB2.DSNA.RUNLIB.LOAD') PARM('SQL')

It will place the result in SYSREC00. My question is: Is there any way to convert COUNT(*) to CHAR on the SQL statement ?

Thanks

10641 26 31_Re: Conversion from VSAM to DB212_Roger Miller19_millerrl@US.IBM.COM31_Fri, 17 Mar 2000 10:35:07 -0600456_- About 8 years ago we had a guide with specifics about migration, but it's out or date and out of print. I could not find one. The Software Migration Project Office may have an old copy. http://www.ibm.com/solutions/softwaremigration/

They probably have some proposals for other conversions and may help with an estimate on yours. There is also a generic red book, GG24-4445, Planning for Conversion to the DB2 Family: Methodology & Practice. [...] 10668 30 13_Re: Batch SQL11_White, Mary28_Mary_White@FDLES.STATE.FL.US31_Fri, 17 Mar 2000 11:48:46 -0500436_iso-8859-1 Yes, add the function DIGITS(COUNT(*)). This will give you character data.

-----Original Message----- From: Mayo Arthur [mailto:Arthur.Mayo@IRS.GOV] Sent: Friday, March 17, 2000 11:42 AM To: DB2-L@RYCI.COM Subject: Batch SQL





I'm running a batch job to get a count of the number of rows on a table

RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) - 000016 LIB('DB2.DSNA.RUNLIB.LOAD') PARM('SQL') [...] 10699 87 60_Re: Repost: DB2 Wins SIIA Award for Best Enterprise Software12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 17 Mar 2000 19:23:17 +0200639_x-user-defined ??????

The awards were announced at the SIIA InfoSoft Summit May 11-14 in San Diego.

WERE or WILL BE ????

Isaac Yassin





"Morrill, John" wrote: > > Greetings! > > Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If > you would like to join his list, you can e-mail him at dbswift@us.ibm.com. > Not all posting to DB2 Interested Parties are re-posted here. > > Cheers! > > J. Michael Morrill > Chief DB2-L List Owner > ================================================= > > Dear DB2 Interested Parties, > > IBM's DB2 has won the Software & [...] 10787 11 4_CIIS15_Robin Woolyhand22_woolyhr@NATIONWIDE.COM31_Fri, 17 Mar 2000 11:21:20 -0600327_- Is anyone using a product from IBM called CIIS and can you tell me how you like it?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 10799 43 18_Re: TCPIP/CICS/DB20_23_Mike_Levine@TEKHELP.NET31_Fri, 17 Mar 2000 13:15:05 -0500312_us-ascii Hi,

There is a TCP/IP CICS Sockets manual that describes what you have to do. Basically it involves coding the TCP/IP CICS sockets security exit to strip off the logon id and pass it in a parm list. I don't have the manual #. The CICS RCT also has to be changed to specify AUTH=USERID. HTH. [...] 10843 132 60_Re: Repost: DB2 Wins SIIA Award for Best Enterprise Software0_19_Tim.Lowe@STPAUL.COM31_Fri, 17 Mar 2000 12:21:51 -0600578_us-ascii If you follow the URL link that was included, you will see that the orginal email should have said that is was MARCH 11-14, 2000 in San Diego.

Thanks, Tim













Isaac Yassin on 03/17/2000 11:23:17 AM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Tim Lowe/sfm/spc)





Subject: Re: Repost: DB2 Wins SIIA Award for Best Enterprise Software [...] 10976 38 37_Re: *Help* MTS/DTC and DB2 for OS/39012_Jim Harrison12_jimh@QIS.NET31_Fri, 17 Mar 2000 13:58:04 -0500573_us-ascii We're headed down the same or similar path. Although the docs say Connect 5.2 will work, we went ahead and installed 6.1. We just got it up and running yesterday and hopefully will be able to do some testing next week.

At 09:51 AM 3/17/00 -0600, Bernie OConnor wrote: >Colleagues -- > > Anixter's B2B team has been developing a VB/COM application using MTS > with transactional control to talk with DB2 Stored Procedures. Our proof > of concept worked very well. Now we are finding that calls to DB2 Stored > Procedures do not quite finish -- there is [...] 11015 30 36_Re: DB2 OS390 Stored Procedure Error12_Jim Harrison12_jimh@QIS.NET31_Fri, 17 Mar 2000 14:00:40 -0500588_us-ascii Hmmmmm. I could have sworn LE allocated that DD dynamically - maybe it's a compile or LE runtime option. I never see it in IOF until I abend. Same goes for displays. The output DD is not their until I actually display something.

At 11:00 AM 3/17/00 -0500, Morris, Deborah wrote: >I've got a request in to our systems folks to get this statement added to >the Stored >Procedure Address Space Proc. So, hopefully that will lead me to the real >problem. > >Thanks ... > >Deborah A. Morris >Supervisor DataBase Administration >UNC Health Care System >2nd Floor Carr Mill [...] 11046 27 41_Stored prodecure calling CICS and Datacom13_Henry Fogwill17_fogwill.h@GHC.ORG31_Fri, 17 Mar 2000 11:14:12 -0800280_- Hi,

Out of my questions you will realize I know nothing about DB2. We just ordered DB2 and I am trying to get a hold on some basic ideas.

I would like to know if a stored procedure can call a program in CICS or do a call to Datacom to read the Dcom database. [...] 11074 100 18_SQL -208 on DB2 V527_Radonjic, Bora (Consultant)23_BRadonjic@ACNIELSEN.COM31_Fri, 17 Mar 2000 13:26:25 -0600533_- Hi list members

I have this query that troubles me: SELECT AA, BB FROM Table WHERE .... ORDER BY CC I am getting ---------+---------+---------+---------+---------+---------+---------+------ ---+ DSNT408I SQLCODE = -208, ERROR: THE ORDER BY CLAUSE IS INVALID BECAUSE COLUMN CC IS NOT PART OF THE RESULT TABLE.

Query works fine in test subsystem, but in production won't run. Both subsystems are DB2 V5 but may be on different put levels. Has anyone experienced something similar, is there specific APAR for this? [...] 11175 54 45_Re: Stored prodecure calling CICS and Datacom10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Fri, 17 Mar 2000 13:29:50 -0600375_- What a co-incidence. Yes, you can.

Just now I am testing EXCI (from our DB2 SPs) to run already existing CICS programs (Sybase RSPs). The CICS program is executing successfully. But I have some issues to resolve with RRSF & WLM in combination with EXCI regarding UOW (i think).

But in general I donot have any problem invoking CICS Program from DB2 SPs. [...] 11230 126 22_Re: SQL -208 on DB2 V50_26_dawn.kastelic@HIGHMARK.COM31_Fri, 17 Mar 2000 14:34:37 -0500287_us-ascii Yes - I experienced this same exact problem just this week only to discover that are test and production subsystems were on different put levels for V5. Our systems group is working on synching up test and production but I am not sure if there is a specific APAR for this. [...] 11357 83 37_Re: *Help* MTS/DTC and DB2 for OS/3900_19_Tim.Lowe@STPAUL.COM31_Fri, 17 Mar 2000 13:58:04 -0600412_us-ascii Bernie, I don't know if our problems are the same, but we also have a VB application using MTS and DB2 OS/390 that has had some problems.

One problem was that "transactions" in MTS were split up into multiple parallel threads in DB2 which contended against one another, resulting in timeouts and deadlocks. (It has been over a year, but I think that MTS called this "connection pooling" ??) [...] 11441 123 22_Re: SQL -208 on DB2 V50_19_Tim.Lowe@STPAUL.COM31_Fri, 17 Mar 2000 14:05:36 -0600394_us-ascii Check to see if PTF UQ31706/ APAR PQ23778 has been implemented in your test system, but not in your production system . This provides the capability in DB2 V5 for OS/390 to "order by" columns that are not in the result set.

Thanks, Tim













"Radonjic, Bora (Consultant)" on 03/17/2000 01:26:25 PM [...] 11565 53 7_DB2 UDB13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Fri, 17 Mar 2000 15:23:10 -0500307_us-ascii I have just loaded for the first time DB2 UDB ver 6.1 on solaris. I then loaded the Windows NT client. I am running Windows NT v4.0 servpack 5

When I go into the CCA I get the following:

SQL 5001N "Administ" does not have the authority to change the database configuration file. [...] 11619 39 11_Re: DB2 UDB14_Jones, Peter J18_pjones2@LEHMAN.COM31_Fri, 17 Mar 2000 15:26:04 -0500459_- Jimmy,

The User ID has to be 8 characters or less. You can't use the NT Administrator id.

Peter J. Jones Lehman Brothers



-----Original Message----- From: Jimmy Willett [SMTP:Jimmy.Willett@NCMAIL.NET] Sent: Friday, March 17, 2000 3:23 PM To: DB2-L@RYCI.COM Subject: DB2 UDB

I have just loaded for the first time DB2 UDB ver 6.1 on solaris. I then loaded the Windows NT client. I am running Windows NT v4.0 servpack 5 [...] 11659 30 11_Re: DB2 UDB13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 17 Mar 2000 14:24:33 -0600335_US-ASCII Jim, Your admin ID must be 8 characters or less. Kurt

>>> Jimmy Willett 03/17/00 02:23PM >>> I have just loaded for the first time DB2 UDB ver 6.1 on solaris. I then loaded the Windows NT client. I am running Windows NT v4.0 servpack 5

When I go into the CCA I get the following: [...] 11690 54 45_Re: Stored prodecure calling CICS and Datacom0_15_leon@CA.IBM.COM31_Fri, 17 Mar 2000 15:38:22 -0500323_us-ascii You can call CICS from stored procedures. Maybe someone else will answer your Datacom question. You should be able to do it. If you can't call it directly then you might be able to call APPC or MQ to get in ot your Dcom database.

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com [...] 11745 64 11_Re: DB2 UDB0_15_leon@CA.IBM.COM31_Fri, 17 Mar 2000 15:40:44 -0500397_us-ascii I am sure that all of you will be happy to hear that this limitation has been removed in V7.1 of DB2 UDB for Windows NT, UNIX, and OS/2 and DB2 Connect.

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com



"Jones, Peter J" on 03/17/2000 03:26:04 PM

Please respond to DB2 Data Base Discussion List [...] 11810 33 27_DB2 OS390 Stored Procedures15_Morris, Deborah20_DMorris@UNCH.UNC.EDU31_Fri, 17 Mar 2000 16:18:19 -0500382_iso-8859-1 We are trying to get DB2 OS390 Stored Procedures (DB2 version 5, using DB2-established stored procedures) going at our institution and have a client application executing on a OS/2 middle tier using "C" code and DDCS level 2.3.

We would like to have this client call DB2 OS390 Stored Procedures that will return both small (<32k) and large (>32) result sets. [...] 11844 45 31_Re: DB2 OS390 Stored Procedures12_Jim Harrison12_jimh@QIS.NET31_Fri, 17 Mar 2000 16:54:15 -0500528_us-ascii I am interested in knowing the answer to this question as well. (And I'm not picking on you today - you just happen to be involved in the same things I am at the moment) We have a VB program invoking a SP going thru a DDCS gateway (don't know the release) and he is unable to retrieve *any* result set. He says the SP is definitely executing on the mainframe, but he gets nothing back. I guess it could be a coding error, but we are beginning to suspect that the older release on the gateway doesn't support this. [...] 11890 119 32_Re: Hardware compression (again)24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Fri, 17 Mar 2000 15:53:25 -0600601_iso-8859-1 Jim,

I agree that creating a benchmark is a non-trivial exercise. Along with some of the other suggestions, I'd suggest a good benchmark would also have the benchmark table in it's own exclusive buffer pool (and the table should fit entirely into this bufferpool). Thus, before you run a benchmark you could "pre-scan" the table into the buffer pool and thus eliminate any buffer pool I/O (and I/O related CPU time) from complicating your benchmark. Of course, you'd want to have as big a table as you can get (without breaking the bufferpool size). I'd use STATIC sql too; and [...] 12010 151 22_Re: SQL -208 on DB2 V516_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Fri, 17 Mar 2000 16:59:50 -0500644_- Columns in the select list must also be in the order by clause. If you look up the error message, it will tell you this!

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Radonjic, Bora (Consultant) [SMTP:BRadonjic@ACNIELSEN.COM] > Sent: Friday, March 17, 2000 2:26 PM > To: DB2-L@RYCI.COM > Subject: SQL -208 on DB2 V5 > Sensitivity: Personal > > Hi list members > > I have this query that troubles me: > SELECT AA, BB > FROM Table > WHERE .... > ORDER BY CC > I am getting > ---------+---------+---------+---------+---------+---------+---------+---- > -----+ > [...] 12162 160 22_Re: SQL -208 on DB2 V516_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Fri, 17 Mar 2000 17:01:48 -0500602_- Now that I said that wrong, -- it should have read:

Columns in the order by clause must also be in the select list. If you look up the error message, it will tell you this!



Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Radonjic, Bora (Consultant) [SMTP:BRadonjic@ACNIELSEN.COM] > Sent: Friday, March 17, 2000 2:26 PM > To: DB2-L@RYCI.COM > Subject: SQL -208 on DB2 V5 > Sensitivity: Personal > > Hi list members > > I have this query that troubles me: > SELECT AA, BB > FROM Table > WHERE .... > ORDER [...] 12323 142 22_Re: SQL -208 on DB2 V515_Zander, Barb J.19_bzander@STATE.ND.US31_Fri, 17 Mar 2000 16:02:35 -0600467_iso-8859-1 PTF number UQ31706 removes the restriction of having to select the column you use in an order by clause.

-----Original Message----- From: Milligan, Andrea [mailto:Andrea_Milligan@BCBST.COM] Sent: Friday, March 17, 2000 4:00 PM To: DB2-L@RYCI.COM Subject: Re: SQL -208 on DB2 V5 Sensitivity: Personal





Columns in the select list must also be in the order by clause. If you look up the error message, it will tell you this! [...] 12466 68 22_Re: SQL -208 on DB2 V520_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 17 Mar 2000 17:03:34 -0500348_us-ascii There has been lately an APAR which lifts this restriction. Which means you are allowed to choose a column in the ORDER BY clause without selecting the column in the SELECT list.

If the SQL is working in test but not working in production then something is missing. I guess Tim Lowe has mentioned few APAR in his earlier mail. [...] 12535 35 21_Buffer Pool Hit Ratio15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Fri, 17 Mar 2000 14:03:47 -0800425_iso-8859-1 Given the following information from a Buffer pool report for a specific plan what is the calculation for the buffer pool hit ratio? TIA



Getpage Requests = 42225 Page Updates = 0 Prefetch Pg Reads = 40810 Hiperpool Writes = 0 BP Hit Percentage = 0%

Failed Getpage Requests = 0 Seq Prefetch Requests = 0 Prefetch Pg in Hiperpool= 1223 Failed Hiperpool Writes = 0 HP Hit Percentage = 100% [...] 12571 158 22_Re: SQL -208 on DB2 V510_Jiang Tong30_jiang@INTREPID.CDG-HARGRAY.COM31_Fri, 17 Mar 2000 16:01:19 -0600473_us-ascii

At least in UDB 6.1(AIX) columns in the order by clause DO NOT have to be in the select list. I tried it just now.

Jiang Tong Communcations Data Group













"Milligan, Andrea" on 03/17/2000 04:01:48 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Jiang Tong/mbsgroup/CDG) Subject: Re: SQL -208 on DB2 V5 [...] 12730 57 31_Re: DB2 OS390 Stored Procedures0_15_leon@CA.IBM.COM31_Fri, 17 Mar 2000 17:09:36 -0500438_us-ascii My memory is failing me here. I don't think DDCS V2.3 had support for Stored Procedures especially those that return result sets. I strongly recomend that you upgrade to V6.1 of DB2 Connect.

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com



"Morris, Deborah" on 03/17/2000 04:18:19 PM

Please respond to DB2 Data Base Discussion List [...] 12788 20 47_Connect ->Distributed Unit of Work/Federated DB10_Park, Stan17_SPark@STATE.NM.US31_Fri, 17 Mar 2000 15:36:27 -0700258_iso-8859-1 Would like to use Connect PE V6.1 on NT to access DB2 V5.1 OS390 and UDB V6.1 on NT with one SQL statement. Is there a way I can do this (have been unsuccessful) or do we need to use Connect EE?

Stan Park DBA State of New Mexico - USA [...] 12809 69 25_Re: Buffer Pool Hit Ratio17_Hynes, Kenneth J.17_khynes@TRIGON.COM31_Fri, 17 Mar 2000 17:39:04 -0500319_- Sandi,

Joel Goldstein or Michael Hannon can explain the "fine points" to you, but here's your basic answer.

1 - ((SIO) + (PF+LPF+DYPF PG)) / GP or 1 - ((13775) + (40810+0+1585))/ 42225 * 100 approx 30% (I did this on the back of a piece of paper so I'm not running out to multiple decimal levels). [...] 12879 238 22_Re: SQL -208 on DB2 V516_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Fri, 17 Mar 2000 17:47:58 -0500639_- So I saw after I sent my reply. I have forwarded the info to my systems person to get us "fixed"! Thanks!!

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Zander, Barb J. [SMTP:bzander@STATE.ND.US] > Sent: Friday, March 17, 2000 5:03 PM > To: DB2-L@RYCI.COM > Subject: Re: SQL -208 on DB2 V5 > Sensitivity: Personal > > PTF number UQ31706 removes the restriction of having to select the column > you use in > an order by clause. > > -----Original Message----- > From: Milligan, Andrea [mailto:Andrea_Milligan@BCBST.COM] > Sent: Friday, March 17, 2000 4:00 [...] 13118 252 22_Re: SQL -208 on DB2 V516_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Fri, 17 Mar 2000 17:51:49 -0500555_- The e-mail specified V5, but as I have found, there is a PTF to fix that, too.

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Jiang Tong [SMTP:jiang@INTREPID.CDG-HARGRAY.COM] > Sent: Friday, March 17, 2000 5:01 PM > To: DB2-L@RYCI.COM > Subject: Re: SQL -208 on DB2 V5 > > > At least in UDB 6.1(AIX) columns in the order by clause DO NOT have to be > in the > select list. I tried it just now. > > Jiang Tong > Communcations Data Group > > > > > > > > "Milligan, Andrea" [...] 13371 90 25_Re: Buffer Pool Hit Ratio15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Fri, 17 Mar 2000 15:05:06 -0800376_iso-8859-1 Thanks Ken What I'm finding confusing is whether Seq, Dynamic and List prefetch requests is a count of requests or pages and if the Prefetch Pg Reads number (40810) is the sum of pages read for all prefetch activity. I'm not finding a clear answer in the manual. I also thought that the BP Hit Percentage was the Buffer Pool Hit Ratio. Am I missing something? [...] 13462 46 51_Re: Connect ->Distributed Unit of Work/Federated DB0_15_leon@CA.IBM.COM31_Fri, 17 Mar 2000 18:35:23 -0500421_us-ascii You will have to wait just a touch longer until we announce version 7.1 of DB2 Connect. You will not be disappointed!

If you are thinking distributed join then you have to think about using DB2 Connect Enterprise Edition and NOT Personal Edition.

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com



"Park, Stan" on 03/17/2000 05:36:27 PM [...] 13509 67 32_Re: Hardware compression (again)15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Fri, 17 Mar 2000 17:40:43 -0600566_ISO-8859-1 Richard proposes a very interesting test, even if it is not in the realm of the real world. It would be a worst case possible scenario.

If you think about real world cases, most every table has one or more indexes associated with it because you can not tolerate the overhead of finding rows by passing over all the data. It does not matter whether it is compressed or not. Indexes are not compressed, type 2 non-leaf page entries may be truncated, but they are not compressed. Indexes are where you try to do most of your selection 'work' and [...] 13577 61 25_Re: Buffer Pool Hit Ratio14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Fri, 17 Mar 2000 21:16:27 -0500472_ISO-8859-1 Sandi, As you said in your reply to Ken (who provided the correct formula), the fields in this report are extremely confusing.

What product is this from?

Just as some simple explanation of the issues, using any type of prefetch, there is a prefetch request - if none of the pages are in the pool, then it causes a prefetch I/O. The I/O will read anywhere from 1 to 32 pages... only the ones that are not in the pool. Same for LP and DynPref. [...] 13639 92 19_Re: DB2 IFCID (185)13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Sat, 18 Mar 2000 08:13:53 +0530422_us-ascii hi !! I am not having DPROP . I am writting my own ...... !! All the exits etc. But can anybody give a glimse of the exit scenario just to confirm my ideas . And I might get some hints for the 0c4 problem. Actually I have a feeling that until the exit is ready to accept the information , DB2 will not allow any inserts into the change data tables. but it should not abend , it should give some valid error. [...] 13732 25 32_Batch and online window co-exist25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG29_Sat, 18 Mar 2000 04:12:45 GMT524_us-ascii Hi,

One of customers is currently having online hours from 7am to 6pm and after which we have the batch window. As the batch window is not enough we are asked to explore into alternatives. Some of the options that were proposed where to go row level locking, do data replication and propagation. Like to know from the group what are the suggesstions you have. Our database is about 150 gb with aroud 400k transaction per day and heavy updating batch jobs. We are on v4 and are planning v5 upgrade soon. [...] 13758 87 35_Re: Ways to generate Surrogate Keys14_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Fri, 17 Mar 2000 22:28:07 -0800325_- ID Column support that is very similar to the DB2 for OS/390 implementation will appear in the next release of DB2 UDB for Unix/NT/OS/2 very shortly.

Unfortunately, this new feature will not initially be delivered in the EEE version, so the other techniques that have been discussed will have to be examined... [...] 13846 45 32_Re: Hardware compression (again)12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Sat, 18 Mar 2000 12:47:15 +0200593_x-user-defined Hi,

Just to clarify few things:

Machine commands on os/390 hardware (or 360 / 370 before that) can be splitted into the following two groups:

1. Interruptable.

2. NonInterruptable.

Most commands are "NonInterruptable" which means when the hardware starts to execute them then it'll finish the execution of the command before returning control.

However some commands are "Interruptable" which means that their execution can be stopped in the middle and be resumed later on (either from point of interruption or from the beginning). [...] 13892 46 65_DB2 OS/390 package bind for JAVA/SQLJ program running in MVS/UNIX17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM31_Sat, 18 Mar 2000 10:44:01 -0500390_- Has anyone out there been able to use a package bind for a JAVA/SQLJ program running in MVS/UNIX (DB2 OS/390)?

I've been able to bind the DBRM (created by the sqlj/db2profc commands) directly into a PLAN, referenced in DB2SQLJPLANNAME and this executes fine. When I bind the DBRM into a collection id and run with the PLAN name containing this collection id, it doesn't work. [...] 13939 96 69_Re: DB2 OS/390 package bind for JAVA/SQLJ program running in MVS/UNIX14_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Sat, 18 Mar 2000 10:36:30 -0800399_- Hi Gary.

We've has this working as part of some recent Redbook work with Java stored procedures on DB2 for OS/390.

Are you using the Java PACKAGE statement in your program? If so, we found you need to have the package bound into a collection with the same name as the Java package, otherwise the package isn't found (whether its in another collection bound to the plan or not). [...] 14036 12 36_Re: Batch and online window co-exist10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Sat, 18 Mar 2000 20:21:36 -0500413_- As with everything else in DB2, "it depends". What are you really trying to accomplish? Must your batch and online processing remain seperate? Why not let you batch window run into your online? Image copy with shrlevel change works just fine. Going to v5 and v6 would probably help. Each release runs faster and provides more functionality. How about data sharing? If this is an alternative wait until v5. [...] 14049 44 49_Re: nulls and an applicable / inapplicable status14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sun, 19 Mar 2000 10:59:58 +1100391_iso-8859-1 Chris Date was (probably still is) anti-nulls. He argued that the only reason for having nulls was because of an unnormalised database design. In expanding on this he introduced this concept to show what would happen if one tried to implement nulls properly. This leads to an unmanageable 4-valued logic - which requires 4294967552 different operators to implement properly. [...] 14094 92 45_Re: Stored procedure calling CICS and Datacom24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM31_Sun, 19 Mar 2000 22:35:58 +1100409_iso-8859-1 Interesting that the EXCI interface is becoming topical.

We recently implemented a couple of stored procedures that call CICS transactions through the EXCI interface.

A couple of things to note:

1. Using CICS 4.1 we were forced to use SYNC-ON-RETURN (not correct syntax) functionality, so that the CICS transaction runs as a separate unit of work to the stored procedure. [...] 14187 73 37_Re: function to get last day of month17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Sun, 19 Mar 2000 12:09:53 PST596_- hi suresh,

Thank you very much, it works fine.

ravi

>From: Suresh Sane >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: function to get last day of month >Date: Thu, 16 Mar 2000 21:43:08 CST > >No such function that I am aware of in V4. You might try: > >SELECT CURRENT DATE - DAY(CURRENT DATE) DAYS >+ 1 DAY + 1 MONTH - 1 DAY >FROM SYSIBM.SYSDUMMY1 > >The order is VERY important. Example: > >today is 2000-03-16. Subtract 16 gets you Feb 29th, adding 1 gets you >March >1st, adding 1 month gets you [...] 14261 109 37_Re: function to get last day of month14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Sun, 19 Mar 2000 14:20:55 -0500404_iso-8859-1 Don't do the unnecessary call for object access inside DB2 to do what can be done in a set statement (which is greatly extended even more so in V6). For example, if correct since done quickly, but this should give you the same result:

Date of the last day of current month: EXEC SQL SET :month-last-day = DATE(SUBSTR(CHAR(CURRENT_DATE,ISO),1,8) || ‘01’) + 1 MONTH - 1 DAY END-EXEC [...] 14371 72 71_PeopleSoft Performance Class for DB2 for OS/390 - Dallas 4/17-4/18/200013_BRIAN HOLROYD31_BRIAN_HOLROYD@DB-CONSULTING.COM31_Sun, 19 Mar 2000 15:18:59 -080089_iso-8859-1 Details of this class can be found at http://www.db-consulting.com/seminar.htm 14444 188 36_Re: Batch and online window co-exist11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Mon, 20 Mar 2000 14:33:24 +1100589_- At a previous site we ran quite a few batch jobs alongside online. Our transaction rate was 60-70 trans/sec, and some of the batch jobs did a large number of updates. The database size was only 40 GB, i.e. at lot more opportunity for contention!

The most important point is your commit frequency. Ours was table-driven, by batch program. We could adjust both the elapsed time and the number of rows updated between commits. For some programs we turned the frequency right down, e.g. a commit every second, or even after every update (or rather, set of related updates). This [...] 14633 47 36_Re: Batch and online window co-exist10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Mon, 20 Mar 2000 04:28:27 GMT545_us-ascii Hi Venkatesh, As u mentioned ur batch window is not enough and may be u are not able to increase the window due to ur online transaction.The only thing u can do is to tune ur batch applications so that u can run more number of batch jobs in less amount of time.As it was mentioned is one of the answers avoiding deadlocks and timeouts by deciding the commit frquency for the application is very important for doing this so that most of the failure can be avoided.One more thing u can do is identify ur batch applications which can [...] 14681 19 18_Performance Matrix9_SrinivasG17_SRINIVASG@INF.COM31_Mon, 20 Mar 2000 13:54:26 +0530394_iso-8859-1 Hi,

Can anyone provide me with a performance Matrix of DB2 vs Oracle vs SqlServer ? This is urgent.

Thanks & Regards Srinivas G

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14701 37 32_BIND is IDEL; Is there any PTF ?10_ajay kumar19_db2v5r1@HOTMAIL.COM29_Mon, 20 Mar 2000 15:38:29 IST292_- Hi

We are using BD2 V5R1, OS 390 V2/R4.

The problem is During BIND, the job is simply idle for more than 25 mts, it is not coming out? I checked DB2 THREAD status,Only one thread was found its BIND job and it was active.

The Bind JOB never completed or timed out. [...] 14739 48 56_Re: DB2 Connect vs Merant performance and case studies ?14_Richard Bourke25_Richard.Bourke@MERANT.COM31_Mon, 20 Mar 2000 12:22:36 +0100635_- Robert, as you see, I'm from Merant. We can certainly provide contact to existing customers to give their performance experiences. Generally, os/390 shops want to perform their own benchmarks in their own environment. A question, we have two products that can do this type of connectivity - SequeLink ODBC Edition, which uses its own server process on os/390, or Connect Premium for DB2, which goes via DDF, and is available for test download. Either could provide performance advantages, depending on things like: -Network topology -sql usage (ad-hoc reporting or repeated use of a limited number of sql statements) -front end [...] 14788 50 36_Re: BIND is IDEL; Is there any PTF ?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 20 Mar 2000 07:13:58 -0600569_iso-8859-1 Ajay, DB2 for OS/390 V5. Is the return code 00E30083? If so, I had a similar problem. See Archives for Dec 1999, week 1 for partial answer and work-around. I had to change the PLAN name.

HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at [...] 14839 20 50_null indicators and applicable versus inapplicable32_=?iso-8859-1?q?Judi=20Westcott?=23_judi_westcott@YAHOO.COM31_Mon, 20 Mar 2000 06:22:02 -0800465_iso-8859-1 Hi all again.

Thank you Dave, Robert, and James for replying.

__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14860 34 50_null indicators and applicable versus inapplicable32_=?iso-8859-1?q?Judi=20Westcott?=23_judi_westcott@YAHOO.COM31_Mon, 20 Mar 2000 06:32:34 -0800574_iso-8859-1 Hi all again.

Thank you Dave, Robert, and James for replying. I did not word my first message very well. I apologize. I am really looking for change in functionality of the null indicator. Currently it only indicates if the data in the field is 'valid' or if it should be ignored and is null. However as James example indicates, what I'm really looking for is the ability to indicate the field is relevant but not yet filled in (applicable but not yet available), or it is not relevant (inapplicable). James example of first born birth date is a good [...] 14895 52 45_Re: Stored prodecure calling CICS and Datacom12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Mon, 20 Mar 2000 09:49:18 -0500540_us-ascii Hi Henry, I see you got replies for the stored procedure to CICS but nothing for the stored procedure to Datacom. We are basically in the same situation but the response from CA was basically, 'if you have done it, you are the first'. It seems that Datacom needs a transaction manager of some sort to handle online queries. Our attempts to statically link the URT into the program only got us S0C1's. CA said that Datacom 10 will support stored procedures but I'm not sure whether they mean internal Datacom ones or DB2 ones. [...] 14948 18 16_DB2-L Set nomail18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Mon, 20 Mar 2000 09:54:51 -0500409_iso-8859-1 DB2-L SET NOMAIL

Steve Whittaker DB2/DBA Carolina Power & Light Mail stop: CPB 17A4 - Raleigh Email: stephen.whittaker@cplc.com Phone: (919) 546-7267

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14967 69 36_Re: Batch and online window co-exist14_John P Shipley24_jpshiple@DUKE-ENERGY.COM31_Mon, 20 Mar 2000 10:05:12 -0500568_us-ascii Hi, One additional suggestion I would make is to talk to the developers about running some of the critical batch streams in "parallel". If you can either split the input files into pieces or split the main driving cursor into pieces and run them concurrently (commit logic is also critical here), then your throughput could be increase at night. A word of caution: Be careful not to exceed the CPU capacity or stress the I/O sub-system by running too many at one time. This has helped us a great deal in the recent past. Also I would suggest looking for [...] 15037 109 35_Re: ERwin support for V6 for OS390?13_Thomas, Janis19_Janis.Thomas@CA.COM31_Mon, 20 Mar 2000 10:09:22 -0500477_iso-8859-1 I am posting the below reply on behalf of someone else......

Greetings,

My name is David Geada. I am the Business Manager responsible for the Enterprise Modeling Suite of products and my responsibilities include setting the strategic direction for ERwin and its sister products. I'd like to provide an update to the email that was posted on March 2, 2000 by Flemming Peterson from CA Denmark relating to our plans for supporting the DB2 platform. [...] 15147 37 15_tournament sort17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Mon, 20 Mar 2000 15:03:42 +0000507_US-ASCII Hi

I want to know what "tournament sort" is?. I came across this when going through some literature on RDS?.

Thanks in advance.

Nagaraj



This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...] 15185 19 33_RACF/DB2 External Security Module11_Marc Manuel25_EP-SG-SI.INFOTEL@ELF-P.FR31_Mon, 20 Mar 2000 17:42:16 +0100392_iso-8859-1 I tried to schedule the RACF/DB2 External Security Module by assembling and linkink SYS1.SAMPLIB(IRRàXACS) into DSNSEXIT(DSN@XACS) When I start DB2, all messages are OK. I didn't define anything in RACF, I just activate two classes : DSNADM and MDSNDB. Since I did that, every program had a big increase of cpu-time !!! I wonder what DB2 is doing in that kind of situation... [...] 15205 69 19_Re: tournament sort14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 21 Mar 2000 03:55:00 +1000545_us-ascii Nagaraj,

DB2 Sort operates in phases and is quite different to external DFSORT. In the first phase DB2 places sort records and keys into nodes in a binary tree structure imitating a tennis tournament tree. Of two competing nodes in the tree, the one with lower sort key wins the competion and rises to next level to compete with another key. The winner overall pops out the top and forms the first item in a sort run. the process continues to build sorted runs. Each run has a limited size based on size of tornanment tree. [...] 15275 55 19_Re: tournament sort11_Suresh Sane21_data_arch@HOTMAIL.COM29_Mon, 20 Mar 2000 11:00:08 CST597_- Look it up in a book by Knuth - it provides an anlysis of vrious sort methods. I can dig it up in my archives if you need it.

Suresh

>From: Nagaraj Pudukotai >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: tournament sort >Date: Mon, 20 Mar 2000 15:03:42 +0000 > > Hi > > I want to know what "tournament sort" is?. I came across this > when going through some literature on RDS?. > > Thanks in advance. > > Nagaraj > > >This message contains confidential information and is intended only >for the individual [...] 15331 64 27_Re: global temporary tables12_Steve Thomas29_sherpa@HORNST.FREESERVE.CO.UK31_Mon, 20 Mar 2000 17:59:46 -0000542_iso-8859-1 I was doing some research the other day and came across PQ32670, one of the new DB2 V6 features in the v6apar web page. It rang a bell, and looking back a couple of weeks I came across the attached. I know this has been resolved by declaring the global temporary table outside of the program, but this APAR allows you to declare a global temporary table in a program. It gets treated exactly the same as a standard GTT, but there's no definition in the catalog. At the moment, I'm not sure why you would use these rather than [...] 15396 61 25_Re: Buffer Pool Hit Ratio15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Mon, 20 Mar 2000 10:23:44 -0800428_iso-8859-1 The product is Omegamon II to DB2 V300 The report is Accounting Buffer Pool Activity

-----Original Message----- From: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM] Sent: Friday, March 17, 2000 6:16 PM To: DB2-L@RYCI.COM Subject: Re: Buffer Pool Hit Ratio



Sandi, As you said in your reply to Ken (who provided the correct formula), the fields in this report are extremely confusing. [...] 15458 20 23_location vs. generic lu10_Tom Taylor17_ttaylor@CHUBB.COM31_Mon, 20 Mar 2000 14:04:46 -0500506_us-ascii Hi all

Can someone clarify the differences between using the LOCATION NAME vs. the GENERIC LU NAME in a data sharing environment.

We do not use db2 to db2. We only have distributed connections via db2 connect up to db2 for 0S/390.

Tom

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 15479 27 30_MS-SqlServer to UDB conversion14_Tom Decabooter27_Tom.Decabooter@HONDA-EU.COM31_Mon, 20 Mar 2000 20:12:45 +0100367_us-ascii Hello,

We are investigating the conversion of an MS-SqlServer application to DB2 UDB on WinNT. As a first step we would like to convert the database to DB2, and leave the programs on SqlServer.

Does anyone know if this is possible and how it can be done ?

Are there any tools that can help converting the programs and/or database ? [...] 15507 102 27_Re: global temporary tables14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Mon, 20 Mar 2000 13:32:05 -0500489_iso-8859-1 Steve,

Briefly, Global Temp Tables and Declared Temp Tables have very little in common. GTTs everyone knows about. But Declared Temp Tables are 'declared', not 'created', in the program as needed, can have indexes on them, can be updated/deleted, and last until thread is finished. GTT have no indexes and are for UOW and have to be 'created' ahead of time. Also, new workfiles for them rather than 07. Rather than repeating, the APAR documention is quite thorough. [...] 15610 50 27_Re: location vs. generic lu11_rick creech18_ykcirc@HOTMAIL.COM29_Mon, 20 Mar 2000 11:36:30 PST542_- FYI, Location is the Relational db name. It is always the same for each member of a datasharing group. If you use VTAM generic LU names then that is also the same for each member I believe, and then VTAM decides which member it will route the connection to. You can use data sharing without generic vtam lu names, which means that each member of the group will have its own lu name. Of course, this means there will be no dynamic routing, but each remote connection will request the member to which it wishes to connect. I am somewhat [...] 15661 21 12_WINLOGON.EXE12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Mon, 20 Mar 2000 13:49:02 -0600508_iso-8859-1 When I try to install fixpak3 for UDB V6.1 on one of our NT boxes (it worked on three other systems OK) I receive the following error: DB2 is currently running and locked by the following process(es) winlogon.exe (PID=39) Click No to exit setup (Recommended) Click Yes to shutdown these processes and continue with install. If I reply Yes, the NT system reboots, if I reply NO and try to manually stop the winlogon.exe process it stays I don't have authority to stop it. Any recommendations? [...] 15683 13 16_Re: WINLOGON.EXE12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Mon, 20 Mar 2000 13:52:25 -0600344_us-ascii De-install and reinstall with the same user id and password as the sys admin for that NT box.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 15697 45 29_Code/Valid Value Table Design0_18_damcon2@US.IBM.COM31_Mon, 20 Mar 2000 15:08:15 -0500420_us-ascii Hi All,

I'm wanting to get opinions on how to handle code/valid value table design...

Is it better to have just one table, doing a lookup via a trigger where the value exists by the correct type? or Is it better to have multiple tables with RI validating by value alone?

Both methods keep the validation process in the database and in one place for consistency and reusability, but... [...] 15743 29 20_FW: Communication DB12_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Mon, 20 Mar 2000 15:49:39 -0500561_iso-8859-1 > -----Original Message----- > From: Andy Wheeler > Sent: Monday, March 20, 2000 1:41 PM > To: 'db2-l@ryci.com_' > Subject: Communication DB > > Is anyone successfully using the communication db to transfer data between > db2 systems. I have a test and production db2 in one lpar and would like > to bring data from production down to the test system on a regular basis. > I have set up the appropriate entries in the tables (IPNAMES, LOCATION, > USERNAMES) but the entries in IPNAMES are not found. I am OS390, DB2 V5, > put tape 9902 (Yeah, I [...] 15773 35 13_db2 and racf.12_Tim Lochmann23_Tim_Lochmann@MAY-CO.COM31_Mon, 20 Mar 2000 15:13:07 -0600575_us-ascii In the process of migrating between db2 internal security and racf. Finding two problems area that would appreciate help on.

1) SYSOPR and SYSADM do not appear to be working correctly within RACF. I have them defined, I have users connected as groups with READ access to the profiles and the classes all refreshed. When users attempt to terminate a utility, they get a message not authorized. No error appears in the syslog, which leads me to believe that racf is returning a 4. I have to believe I am missing something in the way of a profile or entry, [...] 15809 22 12_Vsam Extents16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Mon, 20 Mar 2000 16:35:28 -0500411_iso-8859-1 Hey Folks... We're running into a problem when we extend our underlying VSAM files. It seems that our OS catalog gets into a loop when we see a data set extend (over 200 extents). Refresh my memory, did the amount of extents increase with DB2 V5 or is this a function of OS/390 2.7 (DFP)? I thoughtthat the max amount of extents was 119. In any case, has anyone run into this problem? Thanks... [...] 15832 81 16_Re: Vsam Extents11_White, Mary28_Mary_White@FDLES.STATE.FL.US31_Mon, 20 Mar 2000 16:48:25 -0500318_iso-8859-1 If DFSMS is involved, the 119 extent limit is per volume not dataset. The extents now can go to 255 (or 251 if you exclude the last 4 extents) per dataset.



From the DFSMS/MVS Version 1 Release 4 Book:

2.1.1.1 Data Set Size © Copyright IBM Corp. 1979, 1997 Topic lines 1 to 8 of 8 [...] 15914 62 49_Disaster recovery scenario - without image copies13_Steve Tennant21_Steve.Tennant@HDS.COM31_Tue, 21 Mar 2000 08:49:44 +1100526_iso-8859-1 G'Day mentors,

I have a client site that is not willing/able to completely quiesce their system, ,(they have IMS as well as DB2 and other things). For reasons that are too complex to enter into in this message, the current disaster recovery method is to take an XRC copy of all dasd and dump it to tape. This copy is restored at the remote site and at the point of disaster DB2 (and others) comes up, performs all of its rollbacks etc and the inflights are bombed, blah blah...so far all as per normal. [...] 15977 25 20_DB2 Data Replication15_Michael Bancale21_mbancale@TXFB-INS.COM31_Mon, 20 Mar 2000 16:19:06 -0600297_iso-8859-1 We are developing web applications to access data from DB2/OS 390. My question is, what is the normal usage out there. Do you use DB2 UDB and Data Prop to move data from DB2 OS/390 to the UDB platform or do you have the firewall setup with such security to get to DB2 OS/390 data? [...] 16003 33 41_Where can I get DB2 Version information ?13_Myoungsoo Huh18_huhm@FARMERS.CO.NZ31_Tue, 21 Mar 2000 10:20:02 +1200289_us-ascii Hi,all.. One of my programmer want to get DB2 version information in his DDF program. His program has two diffrent routine in one program, one for DB2 V3, one for V4. He want to check where he's SQL running , in V3 or V4 , before it branch to DB2 version dependent routine . [...] 16037 12 16_Re: Vsam Extents12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Mon, 20 Mar 2000 16:27:06 -0600299_us-ascii The max extents for RVA anyway are now upto 251.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 16050 14 69_Thanks for help regarding MTS/DB2 Connect/OS390 DB2 Stored Procedures14_Bernie OConnor26_Bernie.OConnor@ANIXTER.COM31_Mon, 20 Mar 2000 16:28:54 -0600320_- Thanks to Leon for providing a testfix for DB2 Connect which cleared up our problems with MTS waiting on a response from DB2 after executing DB2 Stored Procedures. We are doing stress testing now, but after 3800 executions we have had no problems with the testfix.

Bernie O'Connor ....just my opinions.... [...] 16065 56 45_Re: Where can I get DB2 Version information ?14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Mon, 20 Mar 2000 14:38:42 -0800378_iso-8859-1 One method I have used in the past (this will require select auth on the system catalog) is to code a singleton select against certain columns in various catalog tables. For example, data sharing came out in DB2 V4. If you issue the following statement:

SELECT GBPCACHE FROM SYSIBM.SYSTABLEPART WHERE DBNAME='DSNDB06' AND TSNAME='SYSDBASE' AND PARITION=0 [...] 16122 85 45_Re: Where can I get DB2 Version information ?0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 20 Mar 2000 16:31:07 -0600437_us-ascii I asked this question a while ago. I don't think any of the answers will help you. Here are the various answers I got

---A---- >>> 11/18 1:19 PM >>> The version information is included in the member, DSNHDECP. This is in your exit library. Look for the DECP literal once you are in the member. For version 5, this will show as DECP510. For version 4, it's DECP410, etc. Hope this helps. Sue. [...] 16208 81 45_Re: Where can I get DB2 Version information ?14_Bistricer, Avi20_BistricerA@CONED.COM31_Mon, 20 Mar 2000 17:41:53 -0500573_- In each db2, create a table with the ssid and the version + other info. Avi Bistricer, DBA 212.460.6695



-----Original Message----- From: Wayne Driscoll [SMTP:wdriscoll@QUEST.COM] Sent: Monday, March 20, 2000 5:39 PM To: DB2-L@RYCI.COM Subject: Re: Where can I get DB2 Version information ?

One method I have used in the past (this will require select auth on the system catalog) is to code a singleton select against certain columns in various catalog tables. For example, data sharing came out in DB2 V4. If you issue the following statement: [...] 16290 68 24_Re: FW: Communication DB12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 20 Mar 2000 16:33:00 -0500437_- Here is some doc, we have from a while back: DB2 DDF procedure: See Chapter 3 of Install Guide.

Define VTAM Logical Names for Each DB2. Insert info into DDF tables. Example follows.

Copy DIST proc from 'DSNSAMP(DSNTIJMV)' to YOUR PROCLIB Change DSNZPARMs: CONDBAT, MAXDBAT to some number (read doc) and DDF from NO to AUTO. Bring Down DB2 Run change log inventory to add entry for each VTAM connection. Start up DB2 [...] 16359 18 53_FW: Disaster recovery scenario - without image copies13_Steve Tennant21_Steve.Tennant@HDS.COM31_Tue, 21 Mar 2000 11:34:32 +1100424_iso-8859-1 Not replying to my own message, just wanted to add that I have equally uncomfortable thoughts about the other method of zapping the BSDS and registering the logs, it seems to be not doing things the way DB2 was was intended but please feel free to convince me.

BTW If Randy Ebersole is watching, I am the same person who chatted with you about this in Brisbane, as you can see I am still bothered :-) [...] 16378 226 33_Re: Code/Valid Value Table Design11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Tue, 21 Mar 2000 14:12:11 +1100581_- Jay,

personally I would go for RI. The main reason is that we ran into problems with triggers about a year ago - DB2 ground to a halt. We added four triggers to the database (fairly simple validation triggers - in more than 90% of the cases the WHEN clause was not satisfied), and memory usage went through the roof. The validations invoked some built-in functions - this may have contributed to the situation. Also, the machine was quite heavily used - we ran at over 1000 concurrent connections at the time, although only around 20 connections were actually active [...] 16605 55 45_Re: Where can I get DB2 Version information ?14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 21 Mar 2000 16:06:49 +1100662_iso-8859-1 EXEC SQL CONNECT END-EXEC and use the contents of SQLERRP (in SQLCA).

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au

-----Original Message----- From: Myoungsoo Huh [mailto:huhm@FARMERS.CO.NZ] Sent: Tuesday, March 21, 2000 8:20 AM To: DB2-L@RYCI.COM Subject: Where can I get DB2 Version information ?



Hi,all.. One of my programmer want to get DB2 version information in his DDF program. His program has two diffrent routine in one program, one for DB2 V3, one for V4. He want to check where he's SQL running , in V3 or V4 , before it branch to [...] 16661 117 37_Re: function to get last day of month14_Peter Backlund15_pbacklu@IBM.NET31_Tue, 21 Mar 2000 08:08:59 +0100581_iso-8859-1 Richard,

In DB2 for OS/390 V5 and earlier, the SET operation can only be used with Special Registers, not expressions. In DB2 UDB for OS/390 V6 expressions can be used.

Best regards,

Peter

Richard Yevich wrote:

> Don't do the unnecessary call for object access inside DB2 to do what can be > done in a set statement (which is greatly extended even more so in V6). For > example, if correct since done quickly, but this should give you the same > result: > > Date of the last day of current month: > EXEC SQL > SET :month-last-day [...] 16779 386 33_Re: Code/Valid Value Table Design14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 21 Mar 2000 01:36:35 -0500598_iso-8859-1 RE: Code/Valid Value Table DesignUlrich,

I hope you don't mind if I strongly disagree. The reason is that declarative RI is for defined parent child relationships, not a short cut for edit checking against code, decode, and reference tables. Including all those tables in RI build ridiculous RI trees that put a burden on backup and recovery procedures. Bury all the code etc tables, in one or more segmented tablespaces, or a one or more table-of-tables, in one buffer pool sized to hold approximately 80% of the tables, set the VPSEQT to 0, if V6, set to FIFO, killing all [...] 17166 241 37_Re: function to get last day of month14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 21 Mar 2000 01:36:39 -0500587_iso-8859-1 Peter,

I'm sorry but I thought that's what I said. Also, in answering I try to keep to the current release on each platform. So I apologize if the answer was misleading.

So: SELECT DATE(SUBSTR(CHAR(CURRENT_DATE,ISO),1,8) || ‘01’) + 1 MONTH - 1 DAY FROM SYSIBM.SYSDUMMY1 for everything V5 and lower as well as the other answer for V6 and Vnext. Regards, Richard +===+===+===+===+====+ Richard_Yevich@YLAssoc.com "DB2 High Performance Design and Tuning", Prentice Hall, May 2000 "DB2 Answers", Osborne, 1999 DB2 Performance Journal, Quarterly www.YLAssoc.com [...] 17408 44 33_Net.Data and Stored procedures !!13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Tue, 21 Mar 2000 13:34:41 +0530553_us-ascii Hi !!

A Typical problem!! AIX ( V4.3) , C language and UDB (V 5.0) calling it from NET.DATA (V 2.0.8 )

The steps which i followed for writing stored procedure

1. In C language ( on AIX) had written stored procedure which is not having MAIN . 2. Had pre-compiled it using db2 prep command it is generating .c and .bnd files. 3. Then compiling it using cc -c command . It gives .o file 4. By executing ld command it generates one shared object file. 5. Had set entry point same as function name within program. 6. After [...] 17453 47 35_Stored Procedure call from Net.Data13_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM31_Tue, 21 Mar 2000 13:33:08 +0530559_us-ascii Hi All

We have written stored procedure on

AIX ( V4.3) , C language and UDB (V 5.0) calling it from NET.DATA (V 2.0.8 )

The steps which i followed for writing stored procedure

1. In C language ( on AIX) had written stored procedure which is not having MAIN . 2. Had pre-compiled it using db2 prep command it is generating .c and .bnd files. 3. Then compiling it using cc -c command . It gives .o file 4. By executing ld command it generates one shared object file. 5. Had set entry point same as function name within [...] 17501 29 41_Where can I get DB2 Version Information ?13_Paul Fletcher22_plfletcher@HOTMAIL.COM29_Tue, 21 Mar 2000 09:33:20 GMT323_- The DB2 version can be accessed when you use call attach.

The 4th parameter of the CONNECT call is the RIBPTR, after the call this contains the address of a control block which has information about the DB2 release.

The assembler macro for this control block is in the sdsnsamp library member DSNDRIB. [...] 17531 52 38_Re: db2 start failure - bsds timestamp14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 21 Mar 2000 11:04:12 -0000326_- Hi Max,

Not recent history, but may still be relevant.

We had multiple MVSs running with shared DASD and shared ICF catalogs. To reduce file allocation time, we chose NOT to propagate dataset enques across systems (after all, the DB2 datasets were only ever going to be accessed from the SAME MVS image). [...] 17584 34 38_Re: db2 start failure - bsds timestamp14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 21 Mar 2000 12:27:17 +0100332_us-ascii Nice shot !!!

Now it's clear how it happened. It was clear that there was not any ENQ/RESERVE on BCS

record to avoid delete !! And the BSDS names were equal I suppose (in my shop I realize if I

deletete prodxx.bsds instead of testxx.bsds), is it correct ? . It's a rare problem, but who knows...? [...] 17619 23 62_Conversion Segmented/Simple tablespace to Partition tablespace10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Tue, 21 Mar 2000 13:32:29 GMT330_us-ascii Hi all, Is there any tool available in the market to convert simple/segmented tablespace to partition tablespace ?. I want to know what all things installations do for this conversion because down time is the issue which might stop many places to adopt some high time consuming methods.

Hope to get comments. [...] 17643 27 38_Increasing the size of the active logs13_Michael Fleck19_m.fleck@MAIL.LVR.DE31_Tue, 21 Mar 2000 15:06:36 +0100595_US-ASCII Hi list members,

we're planning to increase the size of the DB2 active logs in our production system.

Are there any guidelines, special caveats, tips or tricks in doing this.

Thanks in advance, Michael



Landschaftsverband Rheinland Datenbank- und Ressourcenmanagement Ottoplatz 2, 50679 Koeln Tel: 0221/809/2826

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 17671 18 0_10_young huyi21_young_hui@HOTMAIL.COM29_Tue, 21 Mar 2000 06:09:15 PST354_- hi, folks I CODING A PROGRAM USING THE C/VSE IN THE VSE/ESA 2.3, DURING THE COMPILE THE CHARACTER IN THE SOURCE PROGRAM "["AND "]" CAN NOT BE TRANSLATE. MAY BE A CODE PAGE PROBLEM ,CAN ANY ONE HELP ME FIX THE PROBLEM. THANKS IN ADVANCE! ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com [...] 17690 42 42_Re: Increasing the size of the active logs14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 21 Mar 2000 15:17:40 +0100308_us-ascii A part of the post I sent some months ago on the argument:

******** Pay attention !!

If logs are of an old version of DB2 (say a migration from v 2.3 to 3 to 4 and so on without a

redefine of all logs) your REPRO may terminate with an error. It happened some time ago when [...] 17733 55 45_Re: Where can I get DB2 Version information ?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 21 Mar 2000 09:24:15 -0500577_us-ascii I am listing two ways I do it.

1. Search LLE & CDE chain to find DSNHDECP entry point and release info at offset of 16 bytes. 2. Run a command -DIS GROUP and you get release info as the output.

Regards Venkat Pillay

> -----Original Message----- > From: Myoungsoo Huh [SMTP:huhm@FARMERS.CO.NZ] > Sent: Monday, March 20, 2000 5:20 PM > To: DB2-L@RYCI.COM > Subject: Where can I get DB2 Version information ? > > Hi,all.. > One of my programmer want to get DB2 version information > in his DDF program. > His program has two diffrent routine in [...] 17789 58 33_Re: Brackets for C Compiler Issue15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Tue, 21 Mar 2000 09:26:00 -0500306_iso-8859-1 This may be the wrong newsgroup for this issue.

However OS/390 has issues with conversion of the bracket characters too and I wrote an excerpt in an e-mail to them which I'm sending you to our developers about where the issue and solution is documented - you might to read up on it: [...] 17848 49 66_Re: Conversion Segmented/Simple tablespace to Partition tablespace14_Hans Dingerdis21_dingerdis@SIONELL.COM31_Tue, 21 Mar 2000 15:25:07 +0100514_iso-8859-1 Hi Sanjeev, You have to unload and reload the data, so the fastests tools available are from BMC. If you don't want to check for e.g. implicit dropped views use ChangeManager, again from ... I do not work there but i love the speed. Regards Hans



----- Original Message ----- From: "Sanjeev .." Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, March 21, 2000 2:32 PM Subject: Conversion Segmented/Simple tablespace to Partition tablespace [...] 17898 65 66_Re: Conversion Segmented/Simple tablespace to Partition tablespace14_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Tue, 21 Mar 2000 09:38:54 -0500677_us-ascii We are running DB2 V5 and we use the following procedure to partition/re-partition tablespaces with minimal down time by using the RENAME TABLE function and BMC's LogMaster:

Create the partitioned tablespace and table with a temporary name (i.e. tbqual.tbname_new). Unload current table. Load partitioned table (tbqual.tbname_new), RUNSTATS, IC, etc. Start current table ACCESS(RO). Run BMC's LogMaster to create MIGRATE SQL for changes made to current table from the beginning time of Step 2 until the time Step 4 is executed. Apply MIGRATE SQL to new table. Rename current table to tbqual.tbname_old. Rename new table tbqual.tbname_new to tbqual.tbname. [...] 17964 82 40_Re: Conversion Segmented/Simple tablespa10_Ron Graham23_rgraham@CDBSOFTWARE.COM31_Tue, 21 Mar 2000 08:48:33 -0600629_ISO-8859-1 Hi Sanjeev,

Our CDB/RePart product will convert from a simple or segmented tablespace to partitioned tablespace. You tell CDB/RePart how many partitions you want and it will automatically determine the required limitkeys and generate the DDL for the partitioned tablespace. CDB/RePart will also unload the simple or segmented tablespace and then load the new partitioned tablespace. If you want to keep the same tablespace name, CDB/RePart currently requires you to DROP the simple or segmented tablespace and CREATE the new partitioned tablespace (you can use the DDL generated by CDB/RePart to do this). [...] 18047 67 45_SV: Where can I get DB2 Version information ?0_19_Sven.Heidorn@CSN.SE31_Tue, 21 Mar 2000 16:21:36 +0100575_ISO-8859-1 Myoungsoo,

the info you see in the command center is equivalent to the information you get in the SQLERRP field of the SQLCA after a successful CONNECT. The information has the form pppvvrrm, where ppp identifies the product, DSN is DB2 for MVS, SQL is DB2 UDB. The rest is the version, release and modification level id. In your case the field would contain "DSN03010". The SQLERRP field of the SQLCA should contain this information regardless of which platform you issue the CONNECT statement from. Check the documentation for the CONNECT statement. [...] 18115 31 33_Remedy for List Prefetch problems9_Sally Mir15_smir@BCBSGA.COM31_Tue, 21 Mar 2000 10:23:01 -0500384_us-ascii I'd like you esteemed list members to offer your opinions, please! We are having poor performance due to an inordinate number (thousands daily) of RID pool failures on our most heavily-used table. I'd like to turn off list prefetch for a certain set of statements. This table already has four indexes, but I know that if I add one more, I can eliminate the need for LP. [...] 18147 41 20_Re: '[' in mainframe20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 21 Mar 2000 10:41:27 -0500336_us-ascii Once I was running Java script from MVS server and my script was giving me hard time no matter what I do. Then I viewed the source thru web browser and saw that '[' & ']' were getting converted to some junk characters. Putting X'AD' and X'BD' solved my script problem and they were shown as '[' and ']' on my web browser. [...] 18189 14 15_SYSTABAUTH help13_Toppins, Mike19_MToppins@UNIPAC.COM31_Tue, 21 Mar 2000 08:42:22 -0700408_iso-8859-1 Some how, we have several entries in SYSTABAUTH where PUBLIC is the GRANTOR. How does one go about REVOKE-ing these privileges as they are no longer valid?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18204 24 37_Re: Remedy for List Prefetch problems0_31_truman.g.brown@BELLATLANTIC.COM31_Tue, 21 Mar 2000 10:56:20 -0500344_us-ascii Sally,

Yeah, it depends. Is it a performance issue? Are the RID failures and resulting scans causing the users to complain or impacting other processes in the subsystem? How many rows/pages in the tablespace? How much CRUD activity will be index entry create related? How much will it expand your reorg maintenance window? [...] 18229 11 0_0_26_sandy.kordick@ZURICHUS.COM31_Tue, 21 Mar 2000 09:47:26 -0600267_us-ascii db2-l set nomail

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18241 15 19_Re: SYSTABAUTH help0_19_Tim.Lowe@STPAUL.COM31_Tue, 21 Mar 2000 10:24:05 -0600415_us-ascii Mike, See the DB2 V5 admin guide, page 3-34, "examples of granting and revoking privileges" for details of how the "GRANTOR" can be "PUBLIC" for rows in SYSTABAUTH.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18257 43 26_New CINCINNATI Users Group15_Lyle Kelly-LH-117_kelly.lh.1@PG.COM31_Tue, 21 Mar 2000 11:25:25 -0500504_us-ascii To DB2 practitioners in the "Greater Cincinnati" Ohio-Kentucky-Indiana USA area:

We are reviving the local DB2 users group (an IDUG Regional Users Group). Please be sure that your organization is represented at our FREE premiere meeting:

Greater Cincinnati DB2 Users Group Premiere Meeting Tuesday, April 4, 2000 1:00-4:00 pm Ohio Casualty Group, 9450 Seward Road, Fairfield, Ohio Guest Speaker: BONNIE BAKER Highlights of "Things I Wish I Knew ..." Using DB2/OS390 Version 6 [...] 18301 30 19_Re: SYSTABAUTH help13_Toppins, Mike19_MToppins@UNIPAC.COM31_Tue, 21 Mar 2000 09:27:03 -0700457_iso-8859-1 Sorry, should have mentioned that we're still on V4 (V5 box just arrived yesterday!).

-----Original Message----- From: Tim.Lowe@STPAUL.COM [mailto:Tim.Lowe@STPAUL.COM] Sent: Tuesday, March 21, 2000 9:24 AM To: DB2-L@RYCI.COM Subject: Re: SYSTABAUTH help



Mike, See the DB2 V5 admin guide, page 3-34, "examples of granting and revoking privileges" for details of how the "GRANTOR" can be "PUBLIC" for rows in SYSTABAUTH. [...] 18332 21 51_South Florida Database Users Group- All Day meeting0_20_John_Lendman@FPL.COM31_Tue, 21 Mar 2000 11:32:27 -0500318_us-ascii The normal yearly event will not happen this year. This is for those who might be wondering what happen to this event.

The board was extremely busy with REAL work and could not pull it together.

The board will try for an event in 3rd or 4th quarter.

Thank You John Lendman President [...] 18354 104 19_Re: SYSTABAUTH help0_19_Tim.Lowe@STPAUL.COM31_Tue, 21 Mar 2000 11:07:24 -0600605_us-ascii Mike, This has not changed since V4, but I no longer have any old V4 manuals. From my V5 manual:

The holding of other privileges can depend on privileges granted to PUBLIC. Then, GRANTOR is listed as PUBLIC, as in the following examples:

USER1 creates a table and grants ALL PRIVILEGES on it to PUBLIC. USER2 then creates a view on the table. In the catalog table SYSIBM.SYSTABAUTH, GRANTOR is PUBLIC and GRANTEE is USER2. Creating the view requires the SELECT privilege, held by PUBLIC. If PUBLIC loses the privilege, the view is dropped unless the privilege was also granted [...] 18459 127 19_Re: SYSTABAUTH help13_Toppins, Mike19_MToppins@UNIPAC.COM31_Tue, 21 Mar 2000 10:10:45 -0700482_iso-8859-1 That's what I needed. Thanks.

-----Original Message----- From: Tim.Lowe@STPAUL.COM [mailto:Tim.Lowe@STPAUL.COM] Sent: Tuesday, March 21, 2000 10:07 AM To: DB2-L@RYCI.COM Subject: Re: SYSTABAUTH help



Mike, This has not changed since V4, but I no longer have any old V4 manuals. From my V5 manual:

The holding of other privileges can depend on privileges granted to PUBLIC. Then, GRANTOR is listed as PUBLIC, as in the following examples: [...] 18587 71 37_Re: Remedy for List Prefetch problems14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 21 Mar 2000 11:46:32 -0500539_iso-8859-1 Sally,

First, what type of RDS failures? There are 3 distinct types. Second, are you on version 5 and do you have the PTF enabled for Index Screening with List Prefetch?

If the failures are on RDS Limit Exceeded, and there are other non-matching columns on the index in the failing SQL, that PTF becomes mandatory and should eliminate the problem. If the PTF is on, then the there is probably a discrepancy between the statics in the catalog and the actual cardinality of the matching key columns in the SQL. [...] 18659 41 24_Re: [ and ] presentation12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 21 Mar 2000 19:58:28 +0200637_x-user-defined Hi,

It is code page problem and/or ISPF presentation problem if working under P-COM. Meanwhile try ??( for [ and ??) for ] - worked for us in C.

Isaac Yassin

young huyi wrote: > > hi, folks > I CODING A PROGRAM USING THE C/VSE IN THE VSE/ESA 2.3, > DURING THE COMPILE THE CHARACTER IN THE SOURCE PROGRAM "["AND "]" > CAN NOT BE TRANSLATE. MAY BE A CODE PAGE PROBLEM ,CAN ANY ONE HELP > ME FIX THE PROBLEM. > THANKS IN ADVANCE! > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com > > ================================================ > [...] 18701 47 7_DB2 UDB13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Tue, 21 Mar 2000 13:06:36 -0500307_us-ascii I am using DB2 EE on Solaris with Windows NT client. On the solaris each time I enter a command such as "db2" i get following SQL10007N Message " -1390 Could not be retrieved. Reason code: "05".

I cannot find the message in any of my Messages and Codes manuals. Any help. thanks in advance.. 18749 31 11_Re: DB2 UDB12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 21 Mar 2000 13:11:17 -0500544_us-ascii Not sure where you are looking, but this is what I have:-

Reason code 05 - LC_CTYPE is set to a locale which the database does not support. Correct it and try again.

Is that any use to you?

Martin.

Jimmy Willett wrote:

> I am using DB2 EE on Solaris with Windows NT client. > On the solaris each time I enter a command such as "db2" > i get following > SQL10007N Message " -1390 Could not be retrieved. Reason code: "05". > > I cannot find the message in any of my Messages and Codes manuals. > [...] 18781 58 11_Re: DB2 UDB13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 21 Mar 2000 12:17:10 -0600628_US-ASCII Jim, Here is the message from the messages reference.

SQL10007N Message "" could not be retrieved. Reason code: "". Cause: The requested message could not be retrieved from the message file. Reason code is one of the following:

The environment variable "DB2INSTANCE" is either not set, or is set to an invalid instance. Correct it and try again. The message file was found, but the file could not be opened because of permissions. Check the file permissions of the files under the message directory. The message file could not be found. Either the file does not exist, or [...] 18840 36 8_Question14_subrata mondal25_subratamondal@HOTMAIL.COM29_Tue, 21 Mar 2000 18:35:49 GMT283_- Hi all.,

I have a simple sql which gives me an output in column form

it gives me 4 data in 1 column. 1996 1997 1998 1999 [...] 18937 23 18_Re: DB2PM QUESTION15_Wayne Arrington33_WAYNE.ARRINGTON@CUSTOMS.TREAS.GOV31_Tue, 21 Mar 2000 14:03:24 -0500622_US-ASCII ______________________________ Reply Separator _________________________________ Subject: DB2PM QUESTION Author: WAYNE ARRINGTON at NDC-PO8 Date: 3/21/00 12:12 PM



Can one DB2PM monitor be installed on a LPAR that monitors multiple DB2 subsystems? And if it can be accomplished can someone point me to the appropriate manual.

Thank for the assistance

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18961 16 31_Db2Connect Version announcement14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Tue, 21 Mar 2000 11:36:23 -0800451_us-ascii Any word about when Ver 7 will be announced. I'm curious about the new functionality. I need to upgrade and am trying to determine if the wait for functionality will be appropriate in my case. TIA Roy

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18978 18 35_Re: Db2Connect Version announcement13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 21 Mar 2000 14:53:50 -0500463_iso-8859-1 unfounded rumor has it in the summer timeframe

But I wonder if one of the Toronto participants might say....

David Seibert Compuware Corporation File-AID product planner Dave.Seibert@Compuware.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18997 59 33_Remedy for List Prefetch problems14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 22 Mar 2000 07:32:58 +1000350_us-ascii Sally,

Its sounds like you are proposing an 'Index Only' index as a solution to List Prefetch. Does it have heavily updated columns which will be Delete/Insert for an index? I tend to agree that List Prefetch will not be so good if you are experiencing failures and fall back to TS scan. Or is it List prefetch in a Hybrid Join? [...] 19057 24 33_SET RETURN CODE IF TABLE IS EMPTY11_Robert Gray15_rgray23@CSC.COM31_Tue, 21 Mar 2000 15:19:07 -0500525_us-ascii Is there anyone alreadyWe have a table that inserts are made to throughout part of the month. At the end of the month all the rows are deleted. The table could remain empty for several days before they start inserting new rows again. An IMAGCOPY is taken nightly. We would like to test if the table is empty, then not take the IMAGCOPY if it is empty. What can I run that will determine if the table is empty, and then give me a return code that I can test on, before executing IMAGCOPY? I know I could write a [...] 19082 16 37_Re: SET RETURN CODE IF TABLE IS EMPTY0_31_truman.g.brown@BELLATLANTIC.COM31_Tue, 21 Mar 2000 15:44:53 -0500509_us-ascii When the new "record number" is available in your subsystems you could read record one and if your get a +100 then there's probably nobody home (assuming an ACTIVE record one would never be deleted under other circumstances, which might be a bad assumption).

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19099 29 11_DB2 User Id15_Antonio Ramalho20_aramalho@HOTMAIL.COM29_Tue, 21 Mar 2000 17:41:42 EST447_- Hi,

I have the following situation in our company (DB2 5.1 and RACF 2.4) :

In order to access the DB2 databases it was created 2 users: one to access test databases and the other to access production databases. So, these users are public!

The question is: May I grant the DB2 privileges to individuals user ids instead of using public users? I have already heard about Secondary Id. Is it work? If so, how can I do it? [...] 19129 31 33_Re: Brackets for C Compiler Issue0_24_db46@DAIMLERCHRYSLER.COM31_Tue, 21 Mar 2000 15:52:02 -0500501_iso-8859-1 As you know, the C compiler does not accept the normal 3278 left and right brackets '[' and ']'. To get around this we have used the trigraph sequences of ??( and ??). I thought this was a little bit awkward, so I tried to set rumba for APL (ALT BACKSPACE), but it didn't work. What does work in ISPF edit is setting the hex code to AD (left bracket) and BD (right bracket). Now this will show up as Ý & ¨ if you have your terminal type set to normal 3278. But if you set it to 3278A, [...] 19161 58 37_Re: SET RETURN CODE IF TABLE IS EMPTY20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 21 Mar 2000 16:04:40 -0500335_us-ascii One option I could suggest is to use new features of imagecopy "CHANGELIMIT" & "REPORTONLY". The REPORTONLY option just sets the return code of 1,2 or 3 based on your criteria, looking at the spacemap's "page modified bits". You could set up your imagecopy job so as to run or not to run based on the above return codes. [...] 19220 470 37_Re: Remedy for List Prefetch problems9_Sally Mir15_smir@BCBSGA.COM31_Tue, 21 Mar 2000 16:15:29 -0500 19691 45 15_Re: DB2 User Id12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Tue, 21 Mar 2000 15:16:54 -0600434_iso-8859-1 We grant to racf groups in DB2 then connect uers to the groups in racf. Different groups have different security and access to different tables, views, etc.

-----Original Message----- From: Antonio Ramalho [mailto:aramalho@HOTMAIL.COM] Sent: Tuesday, March 21, 2000 4:42 PM To: DB2-L@RYCI.COM Subject: DB2 User Id



Hi,

I have the following situation in our company (DB2 5.1 and RACF 2.4) : [...] 19737 22 22_Re: Performance Matrix12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Wed, 22 Mar 2000 10:15:50 +1300415_us-ascii DBMS Rating ---------------------------------- DB2 Good Oracle Bad SQL Server Bad

Sorry, couldn't resist. ;o)





Raymond 'DB2 Bigot' Bell

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19760 61 37_Re: Remedy for List Prefetch problems12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Tue, 21 Mar 2000 15:17:26 -0600322_iso-8859-1 Sally:

Do you know if you have hybrid joins participating in the RID failures? If you do then you should examine the entries on the list from Mike McMorrow at Allied Irish Bank. These can be more significant than just the RID failures. If this is the case I suggest you email Mr. McMorrow directly. [...] 19822 326 37_Re: Remedy for List Prefetch problems20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 21 Mar 2000 16:47:26 -0500428_iso-8859-1 Sally

Looking at the SQL, I could guess that it is written for scrolling logic. Multi-index access or wrong access path for this kind of SQLs are common nuisance. With the earlier version of DB2, I used to recommend dynamic SQLs for better performance as the dynamic SQLs know the values of the host variables and can decide better access path if RUNSTAT is properly run or catalog is properly populated. [...] 20149 32 18_DB2 trigger Syntax15_Schroeder, Rick26_Rick.Schroeder@BESTBUY.COM31_Tue, 21 Mar 2000 15:37:55 -0600495_- > Does anyone know if its possible within a trigger to set a transitional > value equal to a value selected from another table ? > > For example : > > CREATE TRIGGER NEXTKEY > NO CASCADE BEFORE INSERT ON TABLE1 > REFERENCING NEW AS NKEY > FOR EACH ROW MODE DB2SQL > BEGIN ATOMIC > SET NKEY.KEY_VALUE = ( > SELECT NEXT_KEY FROM KEYTABLE) ; > UPDATE KEYTABLE SET NEXT_KEY = NEXT_KEY + 1; > END# > > > I'm trying to do this because the new ROWID column can't be used in > indexes, or in RI. [...] 20182 336 37_Re: Remedy for List Prefetch problems9_Sally Mir15_smir@BCBSGA.COM31_Tue, 21 Mar 2000 16:58:54 -0500468_us-ascii Thanks, Venkat, for your response. Unfortunately this is vendor code, so changing the SQL is out of the question. Also unfortunately, these plans are bound with DBRMs instead of packages, and contain a large number of DBRMs in each plan, so REOPT(VARS) would kill us. I do wish we could convert to the use of packages, but the fellow who installs this product here is not too keen on the idea.... Maybe in the future, but it's not possible at this time. [...] 20519 76 22_Re: DB2 trigger Syntax14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 21 Mar 2000 16:10:27 -0500585_iso-8859-1 Not implemented in OS/390 but IBM would love to hear if people really want this facility.

Can only do following: SET NKEY.KEY_VALUE = VALUES(func()); and then in the func, do the select. Messy but...

But if you really want next key, use IDENTITY columns. See APAR.

Also, about the ROWID and indexes? It is a recommended method for random clustering keys for partitioning. Also, they recommend indexes on it as a backup for RAD failures. I also believe that you can key existing generated rowids through an unload/reload, with GENERATED BY DEFAULT. [...] 20596 84 37_Re: SET RETURN CODE IF TABLE IS EMPTY11_Robert Gray15_rgray23@CSC.COM31_Tue, 21 Mar 2000 17:39:43 -0500454_us-ascii Venkat,

Thanks for the suggestion. I have tried the "CHANGELIMIT" & "REPORTONLY". Like you say, I get at least one empty imagcopy. We are currently on version 5.



Bob Gray









venkat_pillay@ml.com on 03/21/2000 04:04:40 PM

Please respond to DB2-L@ryci.com

To: DB2-L@ryci.com cc: (bcc: Robert S Gray/COGG/SUBCONTRACTOR/CSC) Subject: Re: SET RETURN CODE IF TABLE IS EMPTY [...] 20681 24 33_RACF/DB2 External Security Module11_Marc Manuel25_EP-SG-SI.INFOTEL@ELF-P.FR31_Tue, 21 Mar 2000 17:13:49 +0100441_iso-8859-1 I tried to schedule the RACF/DB2 External Security Module by assembling and linkink SYS1.SAMPLIB(IRRàXACS) into DSNSEXIT(DSN@XACS) When I start DB2, all messages are OK. I didn't define anything in RACF, I just activate two classes : DSNADM and MDSNDB. Since I did that, every program launched by somebody which is not install sysadm had a big increase of cpu-time !!! I wonder what DB2 is doing in that kind of situation... [...] 20706 31 57_DB2 Communication Server 5.0, DB2 Connect 6.1, MVS DB2 V50_16_dumoore@NMSU.EDU31_Tue, 21 Mar 2000 18:04:00 -0700459_US-ASCII Hello,

I am trying to establishe a distributed connection to MVS DB2 V5 through a gateway on AIX 4.3 using DB2 Communication Server V5.0 and DB2 Connect 6.1 Enterprise Edition with an ethernet adapter card. I currently have this same setup running through a different AIX box with a token ring adapter. I was wondering where I can get a detailed description of the difference in parameter values that the different adapter cards require. [...] 20738 87 33_Re: Brackets for C Compiler Issue13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Wed, 22 Mar 2000 08:26:39 +0530426_us-ascii For the "[" brackets you can specify "??(" for "[" and "??)" for "]" . it will work . We do it this way . regards Vishy









"Loria, Susan C." on 03/21/2000 07:56:00 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Viswanathan N/LTITL)

Subject: Re: Brackets for C Compiler Issue [...] 20826 69 24_Re: "Flattening a table"11_Suresh Sane21_data_arch@HOTMAIL.COM29_Tue, 21 Mar 2000 22:08:36 CST498_- Hi Subrata:

What you are describing is a cross-tab function that can be done in other dbms's (Oracle, I think) as well as in QMF using the ACROSS function. To do this in sql is quite tricky and long-winded. First create a "matrix table" consisting of: 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 You can then issue sum(your col * boolean01),sum(yor col * boolean02) etc. Use of such a technique is actually a case in my next IDUG presentation. Send me an email if you want the details (it is too [...] 20896 86 24_Re: "Flattening a table"18_Kishore Babu Kolla20_KishoreB@INTERRA.COM31_Wed, 22 Mar 2000 09:51:10 +0530599_iso-8859-1 hi suresh, Please send u r article on cross-tab function. with regards & thanks kishore babu

-----Original Message----- From: Suresh Sane [mailto:data_arch@HOTMAIL.COM] Sent: Wednesday, March 22, 2000 9:39 AM To: DB2-L@RYCI.COM Subject: Re: "Flattening a table"



Hi Subrata:

What you are describing is a cross-tab function that can be done in other dbms's (Oracle, I think) as well as in QMF using the ACROSS function. To do this in sql is quite tricky and long-winded. First create a "matrix table" consisting of: 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 You can [...] 20983 467 37_Re: Remedy for List Prefetch problems10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 22 Mar 2000 04:19:34 GMT561_iso-8859-1 Hi Sally, I am still not able to understand why do u have such a poor cluster ratio.May be i am not clear with the data provided by u but i can find that explicit clustering index is not mentioned and none of the indexes have got cluster ratio more than 74 %.Ur index design looks good because if u make DB2C$BSS.EYPID1161532519U as an explicit clustering index then cluster ratio of all the indexes will be atleast 99%(ideal condition after reorg) and insert also will forced on the basis of the clustering key and at any point of time cluster [...] 21451 113 24_Re: "Flattening a table"0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 21 Mar 2000 22:41:22 -0600485_us-ascii would you consider posting it to the documents site/list

1. Send the document in an email as an attachment to the address, DB2-L-DOCUMENTS@RYCI.COM You will receive a response from the db2-l-documents listserv stating that you must confirm that the document originated from your address. Please reply back to that email, including the letters OK in the body of your email (uppercase OK is not necessary, lowercase OK will work as well). [...] 21565 21 31_Image Copy before Online Reorg.10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 22 Mar 2000 06:03:50 GMT524_us-ascii Hi all, I want to know how many of u prefer to take image copy before going for online reorg and why.I do not find any reason for loss of data in case of online reorg ,so no need of image copy before online reorg.

Hope to get comments .

Regards

Sanjeev

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