1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2001, week 4 2 46 40_Re: Setting DB2 Connection pooling parms12_Myron Miller22_myronwmiller@YAHOO.COM31_Sun, 22 Jul 2001 04:20:15 -0700451_us-ascii You can set them two ways, either with commands thru the CLP or thru Control Center and Configure.

CLP - DB2 UPDATE DBM CFG USING NUM_POOLAGENTS 20 DB2 UPDATE DBM CFG USING NUM_INITAGENTS 10

or use Control Center - right click on instance and get pulldown - click on CONFIGURE. It comes up with several tab settings. Click on APPLICATIONS. Then just highlight and change the values for the variables you want and click ok. [...] 49 16 43_Alan M Reed/OR1/AEPIN is out of the office.11_Alan M Reed14_amreed@AEP.COM31_Sun, 22 Jul 2001 07:26:41 -0400471_us-ascii I will be out of the office starting 07/22/2001 and will not return until 07/25/2001.

I will respond to your message when I return. For DBA help contact Bill Satkowski at 8-700-2282 or Calvin Gormly at 8-700-2470.

================================================ 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. 66 107 62_Re: Data conversion error while loading with doubt by jennifer12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 22 Jul 2001 19:52:05 +0200336_Windows-1252 Hi, Sorry, it looks like my memory failed me. I can't find any reference to dec(31) in PL1. It means you'll to use COBOL or (if PL1 is a must) play around with fixed bin(31) or float :-(

Isaac Yassin DBMS & IT Consultant IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 yassini@bezeqint.net [...] 174 24 26_Re: Rollfordward conundrum11_Grant Allen22_grant@TOWERSOFT.COM.AU31_Mon, 23 Jul 2001 09:43:02 +1000569_- Gert van der Kooij[SMTP:geko@WANADOO.NL] wrote: > > ----- Original Message ----- > > From: "Grant Allen" > > Newsgroups: bit.listserv.db2-l> > To: > > Sent: Friday, July 20, 2001 3:58 AM> > Subject: Rollfordward conundrum> > > > > > > Hi all,> > >> > > For some strange reason (I call it "masochism"), I'm playing around> with> > > some disaster recovery scenarios, and I think I've got a conceptual> > problem> > > with rollforward (or at least some of the commands).> > >> > > I've got a db for which I took a backup at [...] 199 75 26_Re: Rollfordward conundrum24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Sun, 22 Jul 2001 20:47:35 -0700348_us-ascii I haven't seen this whole thread (and what I have is hard to read), but I think the problem is that you took an online backup while using LOG RETAIN recovery. If that's true, you must roll forward when restoring this backup to the point that the last in-flight LUW that was active during the backup completes. Here's a crude picture: [...] 275 27 14_Hex convertion26_=?iso-8859-1?q?DB2=20DBA?=19_db2ibm@YAHOO.COM.AU31_Mon, 23 Jul 2001 15:57:18 +1000495_iso-8859-1 Does anyone know how to convert the following hex value to a date and time?

B62C58D89BCDD351

I know the value converts to 01-07-23 07:15:45 , but I just don't know how this product gets that result.

A REXX solution to this would be great.

TIA

_____________________________________________________________________________ http://messenger.yahoo.com.au - Yahoo! Messenger - Voice chat, mail alerts, stock quotes and favourite news and lots more! [...] 303 55 18_Re: Hex convertion16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 23 Jul 2001 12:23:23 +0530707_- I tried ....

SELECT TIMESTAMP(X'B62C58D89BCDD351') FROM SYSIBM.SYSDUMMY1 and got the result as...

COL1 -------------------------- 2001-07-22-21.16.06.510813



The result i got differs from yours..., it gives me timestamp as ....2001-07-22-21.16.06.510813.

Regards Sanjeev



> -----Original Message----- > From: DB2 DBA [SMTP:db2ibm@YAHOO.COM.AU] > Sent: Monday, July 23, 2001 11:27 AM > To: DB2-L@RYCI.COM > Subject: Hex convertion > > Does anyone know how to convert the following hex > value to a date and time? > > B62C58D89BCDD351 > > I know the value converts to 01-07-23 07:15:45 , but I > just don't know how this product gets that result. > > A [...] 359 65 18_Re: Hex convertion0_24_markus.schaub@SYSTOR.COM31_Mon, 23 Jul 2001 08:59:33 +0200449_us-ascii on os/390 you can try the following

1. convert the hex-string into a char-string 2. use the timestampt build-in function with the char-string as input to derive the timestamp e.g. select timestamp(char-string) from sysibm.sysdummy1

regards markus







DB2 DBA cc: Sent by: DB2 Subject: [DB2-L] Hex convertion Data Base Discussion List [...] 425 69 18_Re: Hex convertion14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Mon, 23 Jul 2001 09:04:27 +0200127_iso-8859-1 Hi,

by using the TIMESTAMP-function on the hex-term you might be able to get the desired result, e.g.

495 36 26_Limiting values in Columns10_Joan Green22_Joan.Green@BOIMAIL.COM31_Mon, 23 Jul 2001 10:15:32 +0100718_us-ascii Many thanks to all for your prompt and useful replies - I must try READING the manual :-)

Best Regards,



Joan Green







******************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately at MailManager@psir.ie and delete this E-mail from your system. Thank you. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted. For this reason, where the communication is by email, the Bank of [...] 532 25 59_Bad Performance with BigDecimal variables in SQLJ programs.18_Jose Ramon Vazquez17_jrvazquez@ATCA.ES31_Mon, 23 Jul 2001 03:47:41 -0500495_- I'm testing a JAVA program coded with SQLJ (DB2 v 7.2 - ADK & DB2 Connect - with Windows 2000) to access data in DB2 v 5.1 OS/390. The table has columns defined DECIMAL (p,q) and I has variables defined in my program with BigDecimal, the problem is that after the process of precompile (SQLJ command) and customize (DB2PROFC command) I get a .bnd file with the variables defined like DECIMAL with a precision of 31 digits and thus my DBRM don't choose de apropiate Index of my DB2 table. [...] 558 78 27_Re: compare dsntiaul output15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM30_Thu, 5 Jul 2001 10:21:51 +1000416_- Hi Eric,

I'd like to suggest a good index would be the clustering index on each table, if you can't fit the directives on one line you could use the PARM('SQL') option of DSNTIAUL to order the selected columns by cluster index sequence (as Pohlig referred to).

If you unload the data using the same DSNTIAUL SQL you'll then be able to compare two data files easily, and they should be the same. [...] 637 58 14_AW: WEPR state11_Martin Balz23_Martin.Balz@HVBINFO.COM30_Fri, 6 Jul 2001 12:13:14 +0200455_iso-8859-1 Hi,

we encountered a WEPR on a DSNDB07 TableSpace, a few minutes after Msg DSNB224I (I/O-Error during Write) for this Space. The WEPR-Status was resolved by STOP / START Command, but I think this may only work for the Sort/Work-Tablespaces. (???)

By the way: DSNB224I showed CSW-Status=X'0C40', meaning that DB2 wrote the wrong Record Length to the Cluster (At least that's what our HW-People say...) I am still wondering... [...] 696 21 18_db2split problems?20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Mon, 23 Jul 2001 12:44:41 +0200488_iso-8859-1 Hi everyone, I'm now working with UDB EEE v7.1 , new to the EEE system. I was told by one of the Dba of the team I just joined that they are having troubles with db2split when it comes to split tables larger than 2 Gigs, it seems the db2split start trunating the generated file at 2.1 Gigs . The system is quite big so no problems wre found in any other case working with large table or file. Does anyone know of db2split problem? Thank you in advance Fabrizio Napolitano [...] 718 170 33_Re: Timeout or deadlock on insert0_19_Tim.Lowe@STPAUL.COM31_Mon, 23 Jul 2001 07:48:45 -0500492_us-ascii Shery, I don't understand. I had thought that we had shown that you could get a timeout (or deadlock) on an insert for several different reasons: Duplicate key on uncommitted row IRLM storage full pseudo-deleted row cleanup Have you decided that none of these could have occurred?

Thanks, Tim





Shery Hepp cc: Sent by: DB2 Subject: Re: Timeout or deadlock on insert Data Base Discussion List [...] 889 35 10_Triggers..14_Peacock Julian31_Julian_Peacock@LONDONELEC.CO.UK31_Mon, 23 Jul 2001 14:03:38 +0100633_iso-8859-1 Fellow DB2'ers,

We are about to upgrade to DB2 ver 6, in order to utilise the Trigger feature. Are there any sites, information or white papers detailing people's experiences and problems that they have encountered whilst implementing Triggers?



Julian Peacock London Electricity U.K.



********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. [...] 925 23 45_db2 connect control center admin. OS390 TOOL?15_Neff, Stephen R16_NeffSR@STATE.GOV31_Mon, 23 Jul 2001 09:14:50 -0400551_iso-8859-1 Hello, I have installed db2 connect personnel edition v7 on an Win NT machine. I can connect to the OS390 mainframe. The control center shows a Systems folder which show the OS390 system. When I click on the OS390 system I get a Systems folder. This is as far as I can go. I would like to view through the control center the databases and tables on the OS390 system. The OS390 system is V6 and I am using a TCP/IP connection through DRDA. I only have the connect v7 personnel edition installed. Should I install other db2 pc products? [...] 949 217 33_Re: Timeout or deadlock on insert15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Mon, 23 Jul 2001 15:23:24 +0200387_iso-8859-1 Shery,

Just my two cents.. The way your tablespace was created, if it's done with locksize=page and lockmax=1 and there's more than one user working on this table, the might be inserting into the same page, this will give a -911.

Kind regards,

Jaap Slot



tel: 0031 (0)30 215 2220 mob: 0031 (0)6 5374 0167 mailto:J.P.Slot@rf.rabobank.nl [...] 1167 54 49_Re: db2 connect control center admin. OS390 TOOL?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Mon, 23 Jul 2001 14:22:44 +0100446_ISO-8859-1 hi have you installed the stored procedures on the host 390 db2? have you run through the installation docs for 390 associated with the pc tools? I am about to do this today/tomorrow and may have some more pointers for you .. regards Les

-----Original Message----- From: Neff, Stephen R [mailto:NeffSR@STATE.GOV] Sent: Monday, July 23, 2001 2:15 PM To: DB2-L@RYCI.COM Subject: db2 connect control center admin. OS390 TOOL? [...] 1222 23 8_STOGROUP41_=?iso-8859-1?Q?Serdar_Sabri_=D6ZKUBULAY?=29_serdar.ozkubulay@AKNET.COM.TR31_Mon, 23 Jul 2001 16:26:38 +0300298_iso-8859-1 Hi all,

I want to ask DB2's VOLUME usage sequence algorithm if there are more than one VOLUME in a STOGROUP. After reorganization of some tablespaces, the datasets of it may move from one VOLUME to the other. In some cases this is an unwanted situation for us, can you help? [...] 1246 72 49_Re: db2 connect control center admin. OS390 TOOL?15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Mon, 23 Jul 2001 15:26:37 +0200356_iso-8859-1 Stephen,

Is it the first time DB2 Connect v7 is used? If that's the case you shoul use a user with SYSADM rights on the OS/390. With taht user ypu'll be able do do the intitial bind for the new DB2 Connect. Afterwards, the new packages will be in place and entrance with a 'normal' user with access onto the OS/390 will be possible. [...] 1319 80 14_Re: Triggers..15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Mon, 23 Jul 2001 15:28:35 +0200720_iso-8859-1 Julian,

Why do you want to use the triggers in DB2? Isn't the Referential Integrity giving you enough security?

Just curious..

Kind regards,



Jaap Slot,

mailto:J.P.Slot@rf.rabobank.nl











-----Original Message----- From: Peacock Julian [mailto:Julian_Peacock@LONDONELEC.CO.UK] Sent: Monday, July 23, 2001 3:04 PM To: DB2-L@RYCI.COM Subject: Triggers..



Fellow DB2'ers,

We are about to upgrade to DB2 ver 6, in order to utilise the Trigger feature. Are there any sites, information or white papers detailing people's experiences and problems that they have encountered whilst implementing Triggers? [...] 1400 15 50_Stig Kongshammer - U0053/SDC is out of the office.16_Stig Kongshammer10_sko@SDC.DK31_Mon, 23 Jul 2001 15:21:46 +0200365_us-ascii I will be out of the office from 23-07-2001 until 13-08-2001.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 1416 25 22_Re: Insert next seq_no12_Joe DeCastro14_JoeFDC@AOL.COM29_Mon, 23 Jul 2001 09:20:48 EDT412_ISO-8859-1 Tim,

I ran into the same problem a few weeks ago (OS/390 2.6, DB2 V6). My SQLCA looked as follows:

SQLCODE = -20100 SQLERRM = 1 -104 42601 SQLERRP = DSNHPARS SQLSTATE = 56059

APAR PQ40099/PTF UQ46798 fixed the problem for us. There is a note in the APAR about removing an existing APAR. The sysprog that applied this fix isn't here so I can't ask him if he removed anything. [...] 1442 20 28_Datacom to DB2 Justification9_Bob Crail15_r.crail@ATT.NET31_Mon, 23 Jul 2001 13:35:16 +0000204_- Has anyone gone thru a justification process regarding converting from DATACOM to DB2. I am looking for hard reasons (performance, financial, support,etc), not emotional reactions to CA.



1463 109 49_Re: db2 connect control center admin. OS390 TOOL?12_David Booher22_David.Booher@QUEST.COM31_Mon, 23 Jul 2001 06:37:33 -0700325_iso-8859-1 Hello, Stephen

Make sure you have the Control Center enablement installed on the OS/390 side. The installation proc used to install this is DSNTIJCC. If it is not present in your SDSNSAMP, then you need to install the FMID. As far as I know, this is a no-charge item.

Dave Booher Quest Software [...] 1573 51 12_Re: STOGROUP23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Mon, 23 Jul 2001 14:46:23 +0100530_ISO-8859-1 Hi can you not use REUSE parm?

Les

-----Original Message----- From: Serdar Sabri ÖZKUBULAY [mailto:serdar.ozkubulay@AKNET.COM.TR] Sent: Monday, July 23, 2001 2:27 PM To: DB2-L@RYCI.COM Subject: STOGROUP



Hi all,

I want to ask DB2's VOLUME usage sequence algorithm if there are more than one VOLUME in a STOGROUP. After reorganization of some tablespaces, the datasets of it may move from one VOLUME to the other. In some cases this is an unwanted situation for us, can you help? [...] 1625 22 25_Re: System & HP Hit ratio6_Chenny39_solaiyappan_chenniappan@MAIL.AMSINC.COM31_Mon, 23 Jul 2001 08:49:24 -0500605_- Joel,

>>Async_page_read is total number of pages read by all asynch read activity

Does it mean, the async_page_read count includes pages read/moved asynchronously from HP to BP using MVPG/Data mover facility (or) only the pages read from DASD due to SEQ+DYN+LST prefetch activity ?

Thanks for your previous response.

Chenniappan USDA

================================================ 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. 1648 139 49_Re: db2 connect control center admin. OS390 TOOL?14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Mon, 23 Jul 2001 10:07:51 -0400435_iso-8859-1 All,

I am Steve's former DB2 Sysprog. I did run DSNTIJCC on all DB2s at his site when I migrated to DB2 V6, so the jobs are in the SDSNSAMP libraries for each DB2 and the packages are created on every subsystem. I did not grant the DBAs access to the packages at the time, because there wasn't yet a requirement to do so. Is the package authorization the only thing he would need on the OS390 side in this case? [...] 1788 84 18_Re: Hex convertion13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Mon, 23 Jul 2001 07:49:01 -0600729_- OK. now I'm confused.

could some one tell me how this works

SELECT TIMESTAMP(X'B62C58D89BCDD351') ,HEX(TIMESTAMP('2001-07-22-21.16.06.510813')) ,HEX(TIMESTAMP(X'B62C58D89BCDD351')) FROM SYSIBM.SYSDUMMY1



COL1 COL2 COL3 -------------------------- -------------------- -------------------- 2001-07-22-21.16.06.510813 20010722211606510813 20010722211606510813









-----Original Message----- From: S, Sanjeev (CTS) [mailto:SSanjeev@CAL.COGNIZANT.COM] Sent: Monday, July 23, 2001 12:53 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Hex convertion



I tried ....

SELECT TIMESTAMP(X'B62C58D89BCDD351') FROM SYSIBM.SYSDUMMY1 and got the result as... [...] 1873 17 14_Re: Triggers..12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 23 Jul 2001 09:26:54 -0500421_us-ascii Hello,

The DB2 UDB Server for OS/390 Version 6 Technical Update Redbook is very good. Also, the archives of this list reflect many 1st hand experiences.

Stg

================================================ 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. 1891 100 14_Re: Triggers..16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Mon, 23 Jul 2001 15:29:26 +0100536_us-ascii Hi Julian,

for starters, you can find some useful hints in the following redbook:

DB2 UDB Server for OS/390 Version 6 Technical Update, SG24-6108-00

you can try and download it from www.redbooks.ibm.com

there is some interesting stuff on thriggers, however it's a bit generic if you want to go in depth.

BUT, there is a good presentation from Phil Grainger that you can download from http://www.gseukdb2.org.uk/ (go and see under Tech Info and look for "Triggers: What, How and When?"). [...] 1992 40 14_Re: Triggers..16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Mon, 23 Jul 2001 15:37:28 +0100435_us-ascii Julian,

I also forgot that there are a few interesting articles published on DB2mag, you can look them up at http://www.db2mag.com



Ciao!

Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.

Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com

1 Archipelago Lyon Way Frimley Camberley Surrey GU16 7ER UK [...] 2033 111 14_Re: Triggers..14_Peacock Julian31_Julian_Peacock@LONDONELEC.CO.UK31_Mon, 23 Jul 2001 15:51:42 +0100406_iso-8859-1 We need the ability for a new business process to update our DB2 system, and then have these changes reflected in our Data Warehouse. I do not know the specifics since this project is still in its design stage.



Julian

-----Original Message----- From: Slot, JP (Jaap) [mailto:J.P.Slot@RF.RABOBANK.NL] Sent: 23 July 2001 14:29 To: DB2-L@RYCI.COM Subject: Re: Triggers.. [...] 2145 23 30_LOB utilities - access methods9_Rob Crane22_racrane@CONCENTRIC.NET31_Mon, 23 Jul 2001 09:11:51 -0600394_us-ascii Any one using LOBs have preferred methods/procedures for unloading/loading CLOBs greater than 32K? For the most part wanting the ability to take a CLOB from production and reproduce it in test. Separate LPARs/Subsystems, no shared dasd, etc.

Any relief with zOS and 64 bit processing? Any vendors (including IBM) have any plans for a LOB unload/load utility in the future? [...] 2169 23 28_Stored Procedures and DB2 V611_Hayden, Lee18_Lee_Hayden@CSX.COM31_Mon, 23 Jul 2001 11:15:23 -0400610_iso-8859-1 Group,

I posted to the Documents site a complete (SP, caller, JCL, DDL, etc) simple WLM stored procedure based on one of the COBOL examples in the Application Programming and SQL Guide.

It is handy to have something simple like this to test WLM implementation.

See July 2001,

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 2193 53 34_Re: LOB utilities - access methods14_Hickman, Mindy29_Mindy.Hickman@DOA.STATE.WI.US31_Mon, 23 Jul 2001 10:53:12 -0500378_iso-8859-1 We've had luck using DSN1COPY as long as the CLOB doesn't go over 2G. The data gets corrupted when it goes to a second volume. We do have an open problem with IBM on this.

As far as utilities, we use CDB and have been told that they're next release will handle unloading/loading CLOBs. I've asked about size and they said that they would handle any size. [...] 2247 190 33_Re: Timeout or deadlock on insert10_Shery Hepp17_schepp@SRPNET.COM31_Mon, 23 Jul 2001 09:25:28 -0700289_iso-8859-1 Tim- you are correct- after further investigation and talking it over with the application lead- it looks like this is clearly a case of poor design in that we can have two different units of work processing the same data. We will be looking at a redesign of this process. [...] 2438 34 20_DB2 Version question18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Mon, 23 Jul 2001 13:42:26 -0400534_iso-8859-1 I know this is probably a nit-picky question but its alwaysbugged me.

Right now we are upgrading to DB2 Version 6. Now all the IBM manuals I have refer to this as DB2 Version 6 and NO release numbers. My question; I've seen people refer to DB2 V6 as DB2 Version 6.2 etc. Where is the .(point) 2 coming from? I thought DB2 V6 was just plain ole DB2 V6. Or if there are different releases for DB2 V6 how does one go about finding that out? Basically I've been telling our DB2 clients that we are upgrading to DB2 [...] 2473 45 17_db2 and mq series29_Sherri Sterling DIGEST NOMIME29_Sherri.Sterling@BPD.TREAS.GOV31_Mon, 23 Jul 2001 13:44:50 -0400511_us-ascii We are trying to get mq series to work with UDB/NT version 7.2. This does not work, mq series will not log to it's version 7.2 database. We were told we had to back off of version 7.2 and go to version 6. I find this hard to believe that IBM would recommend this considering UDB version 6 will not be supported much longer. I was wondering if any one on the list was having this problem or if this log database, MSQIMDB, could be moved to the mainframe and MQSI will still be able to log to it on [...] 2519 44 26_UDB v7.1 upgrade questions22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Mon, 23 Jul 2001 11:18:36 -0700461_- Dear list,

We were in the process of upgrading to V7.2 from V6.1. The software was installed and we performed the instance migration. Unfortunately the SDK was not installed. The developers could not use the prep command. We had the software guys install the SDK and we are still getting the exact same error. It is acting like it is not recognizing that the SDK has been loaded. The Error we are getting both before and after the SDK install is: [...] 2564 55 24_Re: DB2 Version question11_David Nance16_DWNance@FHSC.COM31_Mon, 23 Jul 2001 14:30:19 -0400371_US-ASCII Steve, I believe you are probably in the OS/390 world, where DB2 V6 is DB2 V6, however in the DB2 mid-range world DB2 V6 does come in other flavors, with fixpacks.

Dave Nance First Health Services, Corp. (804)527-6841

>>> stephen.whittaker@PGNMAIL.COM 07/23/01 01:42PM >>> I know this is probably a nit-picky question but its alwaysbugged me. [...] 2620 101 24_Re: DB2 Version question11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Mon, 23 Jul 2001 13:32:42 -0500520_iso-8859-1 -DIS LOCATION DETAIL

The PRDID, which identifies the database product at the location in the form nnnvvrrm:

- nnn - identifies the database product - vv - product version - rr - product release - m - product modification level.

When I did on our system I get the following: PRDID DSN06011







"Whittaker, Stephen" cc: Sent by: DB2 Data Subject: DB2 Version question Base Discussion List [...] 2722 78 30_Re: UDB v7.1 upgrade questions12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 23 Jul 2001 11:38:49 -0700576_us-ascii Hi Marty- I usually panic at this point, until I remember to "update the instance" after putting on software fixes. And don't forget the administation server either.

tim --- "Killen, Martin W - CNF" wrote: > Dear list, > > We were in the process of upgrading to V7.2 from > V6.1. The software was > installed and we performed the instance migration. > Unfortunately the SDK > was not installed. The developers could not use the > prep command. We had > the software guys install the SDK and we are still > getting the exact same > [...] 2801 34 25_Re: System & HP Hit ratio14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Mon, 23 Jul 2001 14:47:17 -0400351_ISO-8859-1 I don't include these, since they are not read from dasd. My goal for BP tuning to eliminate physical I/O. HP page moves are Mcs vs Ms for a physical I/O to dasd.

Regards, Joel

Message text written by DB2 Data Base Discussion List >Joel,

>>Async_page_read is total number of pages read by all asynch read activity [...] 2836 40 35_DB2 Satellite Edition / Replication12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US31_Mon, 23 Jul 2001 13:51:43 -0500543_US-ASCII We are in planning / implementation stage of project that will use 400+ laptops running DB2 Satellite Edition with 1 way and 2 way replication.

We have been referencing the DB2 Redbook "IBM Replication Solutions for Pervasive Computing" It is a pretty good reference.

Anyone from the list have some other references that we should read? Anyone with 'been there, done that' experience, please contact us offline. I would like to give you a call and discuss any problems you had with your approach (so we may avoid). [...] 2877 71 30_Re: UDB v7.1 upgrade questions16_Ian D. Bjorhovde20_ianbjor@CEPHALAD.COM31_Mon, 23 Jul 2001 11:59:20 -0700679_Windows-1252 Martin,

After installing the SDK, you should run 'db2iupdt' to refresh the links.

Good luck,

Ian



----- Original Message ----- From: "Killen, Martin W - CNF" Newsgroups: bit.listserv.db2-l To: Sent: Monday, July 23, 2001 11:18 AM Subject: UDB v7.1 upgrade questions



> Dear list, > > We were in the process of upgrading to V7.2 from V6.1. The software was > installed and we performed the instance migration. Unfortunately the SDK > was not installed. The developers could not use the prep command. We had > the software guys install the SDK and we are still getting the [...] 2949 101 30_Re: UDB v7.1 upgrade questions22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Mon, 23 Jul 2001 12:14:58 -0700644_- Thanks for all the responses.. We were having a senior moment.. We will run the db2iupdt and merrily click along.. Thanks again..

Marty Killen SR DB2 DBA CNF INC. 503-450-2681 e-mail- killen.martin@cnf.com



"Kind words can be short and easy, but their echoes are truly endless" Mother Theresa

> -----Original Message----- > From: tim malamphy [SMTP:timalamphy@YAHOO.COM] > Sent: Monday, July 23, 2001 11:39 AM > To: DB2-L@RYCI.COM > Subject: Re: UDB v7.1 upgrade questions > > Hi Marty- > I usually panic at this point, until I remember to > "update the instance" after putting on software fixes. > And don't [...] 3051 21 22_private vs shared sort14_Michele Payton18_paytonm@US.IBM.COM31_Mon, 23 Jul 2001 13:52:55 -0600332_us-ascii Esteemed list,

I am new to DB2 and am working on a plan to tune a database that is currently in development. In my research, I have found that memory allocation for sorts is important. They talk about private and shared sorts, but do not explicitly define what the differences are. Can someone tell me? Thanks. [...] 3073 107 18_Re: Hex convertion13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Tue, 24 Jul 2001 06:26:57 +1000474_iso-8859-1 Yes,

The argument in the first is considered as a STCK value. See your POPS for the format if necessary. The result in the second and third is presented as timestamps are stored internally in DB2 (Check the AG about p. 1200).

Greg Farquhar

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Daniel Turner Sent: Monday, July 23, 2001 11:49 PM To: DB2-L@RYCI.COM Subject: Re: Hex convertion [...] 3181 137 24_Re: DB2 Connect EE setup10_Vinson Lee19_vlee@SDCCD.CC.CA.US31_Mon, 23 Jul 2001 14:33:19 -0700387_iso-8859-1 Thanks to all who replied and tried to help on our DB2 Connect EE problem. It turns out there was a problem with the NT machine Server Service causing the DB2 Administration Services not to start. After the NT machine was rebuilt and current fix patches applied, we were able to start the DB2 services and define the necessary connections from the client to the gateway. [...] 3319 41 14_Re: Triggers..12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Tue, 24 Jul 2001 08:54:05 +1000364_- Julian, suggest that from a practical side of things that you keep your maintenance up. I've noticed a few little "niggly" type problems, and one that hit us here (APAR # PQ47009) to do with compressed TableSpaces.

But then again Outer joins had 1 or 2 little problems when it was first released; and now you wouldn't want to be around without them. [...] 3361 16 46_Offtopic: Anyone using Dharma Relational Link?12_Roy Reynolds15_royr@INCYTE.COM31_Mon, 23 Jul 2001 16:05:49 -0700351_us-ascii Is there anyone willing to tell me about their experiences with this product? Thanks in advance, 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. 3378 118 26_Re: private vs shared sort14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Mon, 23 Jul 2001 16:23:37 -0700485_iso-8859-1 A private sort is allocated out of agent private memory. It is used when using EE without parallelism enabled. Shared sorts used shared memory and are used when parallelism has been enabled. Sortheap is a soft limit on private sorts (once exceeded the database mgr will continue to allocate memory but in smaller quantities) and a hard limit for shared sorts based on sheapthres setting, which governs the amount of concurrent shared sorting that can be done. HTH Phil [...] 3497 80 27_DB2 V7.2 NULL w/ C Compiler19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Mon, 23 Jul 2001 16:24:15 -0700348_- Upgrading the development environment from DB2 V6.1 FP? to V7.1 FP3, with AIX 4.3.3 and IBM Visual Age C V5.0.1 (if I read the lslpp correctly).

The V7 PREP generated uncompilable NULL values in translated embedded SQL statements. I.e. where the C pre-compile put in 0, the DB2 pre-compiler changed it to NULL, which is invalid to C. [...] 3578 214 33_Re: Timeout or deadlock on insert17_jennifer jennifer22_jenni_jeni@HOTMAIL.COM31_Mon, 23 Jul 2001 23:45:05 +0000637_- Hi All Jennifer here and saw all these communication. Here i do have doubt and could all of you clear this concept like IRLM storage full. Duplicate key on Uncommited row. How the insert affects this.

Thanks in advance.



>From: Shery Hepp >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Timeout or deadlock on insert >Date: Mon, 23 Jul 2001 09:25:28 -0700 > >Tim- you are correct- after further investigation and talking it over with >the application lead- it looks like this is clearly a case of poor design >in >that we can have two different [...] 3793 24 36_LOCKS ACQUIRED DURING MODIFY UTILITY28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Mon, 23 Jul 2001 17:28:25 PDT389_- The book is correct. MODIFY sets UTRW for the tablespace and any related indexes. No locking is performed on the user object, only on SYSCOPY and its related indexes. I can't explain what you are seeing.

We have seen MODIFY concurrency issues and deadlocks in the past but always with respect to SYSCOPY not user objects. The MODIFY performance APAR helps this a great deal: [...] 3818 66 40_Re: LOCKS ACQUIRED DURING MODIFY UTILITY21_Anthony L. Ciabattoni25_ACiabattoni@CHECKFREE.COM31_Mon, 23 Jul 2001 21:04:36 -0400549_us-ascii We seen in the past timeouts on user objects. From what I understand that at some point during the modify process the utility attempts to get an exclusive lock at the database level. So all threads that attempt to access the tables that are in that database will timeout as the modify utility attempts to get the exclusive lock at the database level. When this happened to us we experienced hundreds of timeouts on the database that the modify utility was running in a very short time. I hope my 2 cents helps shed some light on this. [...] 3885 59 18_Re: Hex convertion14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 23 Jul 2001 21:09:22 -0500327_- db2ibm,

The discrepancy might be because B62C58D89BCDD351 is the contents of the system clock (or, more accurately, the result of a STCK instruction in 31 bit mode) which is maintained at local time + 10 hours. (For example, the system clock is on GMT and you are in Hawaii.) Not sure about the other 21 seconds. [...] 3945 76 18_Re: Hex convertion25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Mon, 23 Jul 2001 22:01:51 -0500626_iso-8859-1 Leap seconds offset. From CVTLSO currently 21. ----- Original Message ----- From: "James Campbell" Newsgroups: bit.listserv.db2-l To: Sent: Monday, July 23, 2001 9:09 PM Subject: Re: Hex convertion



> db2ibm, > > The discrepancy might be because B62C58D89BCDD351 is the contents of the > system clock (or, more accurately, the result of a STCK instruction in 31 > bit mode) which is maintained at local time + 10 hours. (For example, the > system clock is on GMT and you are in Hawaii.) Not sure about the other 21 > seconds. > > James Campbell > > > [...] 4022 60 24_Re: DB2 Version question15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 24 Jul 2001 10:06:00 +1000371_- Hi Steve,

Someone's already responded but, as far as I know, DB2 for MVS (and later OS/390 and, I guess, z/OS) hasn't had a release portion to the name since V3. I believe it goes 1.1, 1.2, 1.3 (the first version I had the pleasure to work with, albeit for a week), 2.1, 2.2, 2.3, 3, 4, 5, 6, 7. The .whatever stuff tends to be the 'little' DB2s out there. [...] 4083 15 41_Debra Kopecky/PCSHS is out of the office.13_Debra Kopecky23_Debra.Kopecky@PCSHS.COM31_Mon, 23 Jul 2001 23:31:32 -0700417_us-ascii I will be out of the office starting 07/23/2001 and will not return until 07/24/2001.

Contact Sharon Fields, Ben Richardson or Myron Perlmutter for 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. 4099 60 30_Incremental Image Copy Hazard.32_Atalay Tanis (Garanti Teknoloji)22_AtalayT@GARANTI.COM.TR31_Tue, 24 Jul 2001 10:18:20 +0300279_ISO-8859-9 Hi listers. Those using DB2 UDB for Os390 V6 - please check the APAR PQ47449. It has not a fix developed yet, but the APAR text explains how incremental image copies may hazard your data. Take your precatuions.

... Atalay Tanis Garanti Teknoloji Istanbul/Turkey 4160 22 20_DB2 for AIX Question14_Curran, John F29_john.f.curran@UK.FID-INTL.COM31_Tue, 24 Jul 2001 10:41:40 +0100488_iso-8859-1 Hi

Does any body know what is the command/procedure is to force the archive of a active log on demand in the AIX world.

Thanks..

John Curran

Infrastructure Planning & Consultancy Fidelity Investments Limited

================================================ 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. 4183 56 24_Re: DB2 for AIX Question9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Tue, 24 Jul 2001 11:11:02 +0100554_us-ascii John,

The command is ARCHIVE LOG, but you have to be on V7.2.

Chris









"Curran, John F" cc: Sent by: DB2 Data Subject: [DB2-L] DB2 for AIX Question Base Discussion List



24/07/01 10:41 Please respond to DB2 Data Base Discussion List











Hi

Does any body know what is the command/procedure is to force the archive of a active log on demand in the AIX world. [...] 4240 44 36_LOCKS ACQUIRED DURING MODIFY UTILITY13_LANGLEY MOIRA28_MOIRA.LANGLEY@FORTISBANK.COM31_Tue, 24 Jul 2001 12:08:59 +0200575_- Jeff It might be worth checking whether you have one of the fixes for APAR PQ32063 (UQ41273 UQ41274 or UQ41275 depending on DB2 version) on your system. The text for this APAR includes the following comment MODIFY utility was changed so that if and when it sets a table space into COPY PENDING, subsequent update activity will not be allowed until the copy pending state is cleared. Note: as a result of this fix there now exists a small possibility of contention with the target object (the object that is being MODIFY'd) and other utilities or updaters which try to [...] 4285 56 24_AW: -DIS LOCATION DETAIL12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 24 Jul 2001 12:37:39 +0200668_iso-8859-1 Hi Jeff,

whe are running DB2 for OS/390 V5 and when I did -DIS LOCATION DETAIL I got the following:

DSNL200I - DISPLAY LOCATION REPORT FOLLOWS- DISPLAY LOCATION NO LOCATION FOUND DISPLAY LOCATION REPORT COMPLETE ***********

Somewhat wrong in our installation ?

With kind regards - mit freundlichen Grüssen, Georg H. Peter ---------------------------------------------------------------------- Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did. So throw off the bowlines, sail away from the safe harbor, catch the trade winds in your sails. Explore. Dream. (Mark Twain) [...] 4342 86 24_Re: -DIS LOCATION DETAIL18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 24 Jul 2001 06:45:10 -0400517_iso-8859-1 Jeff: Did you check your DB2I DEFAULTS before you did the -dis location detail ?? You'll want to make sure your pointed to the right DB2 NAME (subsystem)

HTH...

--Steve....

Steve Whittaker DB2/DBA Progress Energy, Inc. Mail stop:OHS 10- Raleigh Email: stephen.whittaker@pgnmail.com Phone: (919) 546-7267



-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Tuesday, July 24, 2001 6:38 AM To: DB2-L@RYCI.COM Subject: AW: -DIS LOCATION DETAIL [...] 4429 23 24_Re: -DIS LOCATION DETAIL13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 24 Jul 2001 08:10:06 -0400585_iso-8859-1 Guten Morgen Georg,

Do you have DDF setup for the subsystem on which you're issuing the -DISPLAY LOCATION command?

I would expect to see the messages you're getting when there are no remote DB2s defined to that subsystem.

David Seibert Compuware Corporation File-AID Product Architect 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. 4453 44 24_Re: -DIS LOCATION DETAIL12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Tue, 24 Jul 2001 09:08:02 -0500323_iso-8859-1 We too are running V5, and receive the same message when we issue the -DIS LOCATION DETAIL command. We do have DDF set up, multiple MVS as well as UDB DB2 subsystems are accessed and also access this subsystem. Does anyone know if this is restricted to V5 only? I'd like to find the answer to this as well. [...] 4498 44 18_SECQTY and extents11_DBA Support21_dbasupport@WILLIS.COM31_Tue, 24 Jul 2001 15:14:31 +0100313_us-ascii Hi

We have a few tablespaces in 30+ extents which we were not too worried about, but we now have some over 100 extents, and one is at 215 extents. We have recently gone to DB2 V6.1, so this may be connected.

We are on OS/390 V2R6, and we use Stogroups. We do not have SMS switched on. [...] 4543 18 53_Documention for DB2 Java Stored Procedures (COMPJAVA)13_Waldo Tumanut52_Waldo_Tumanut/MO/americancentury@AMERICANCENTURY.COM31_Tue, 24 Jul 2001 09:02:18 -0500542_- I'm looking for documention on implementing DB2 v6 Java Stored Procedures -- from installation of software components; configuring DB2, CICS, TSO (for preparing programs); and program preparation. What do you recommend? Are there online documents available?

Thanks for the help.

Waldo

================================================ 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. 4562 35 45_Calling stored procedures from within Cobol .15_tom plasschaert22_tom.plasschaert@NBB.BE31_Tue, 24 Jul 2001 16:26:01 +0200346_iso-8859-1 Is someone aware of any restrictions in DB2 v 5 when calling a stored procedure with parameter lenght >256 bytes from within COBOL ? "Problem detected at CALL of a stored procedure in a COBOL-program. The length of the passed parameter seems to be restricted. Linkage defined : 1200 bytes. Data returned after CALL : 256 bytes. " [...] 4598 81 24_Re: -DIS LOCATION DETAIL0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 24 Jul 2001 09:37:15 -0500413_us-ascii I was interested in the question and answer too. I had basically the same problem that others have reported. There was no version info about the local DB2 subsystem, but there was info about the remote DB2 subsystem we have.

DSNL200I " DISPLAY LOCATION REPORT FOLLOWS- LOCATION PRDID LINKNAME REQUESTERS SERVERS CONVS gxxx4010 TxxxS01 0 9 9 xxxxxxx_DBD2DBP3 DSN06010 DxxxDBP3 0 0 2 [...] 4680 26 39_Upper case of DB2 table data in DB2 V5.0_24_ujjwal@LOT.TATASTEEL.COM31_Tue, 24 Jul 2001 18:48:02 +0530529_us-ascii Repeating this again because I did not have any response the first time .

ALL, I have a case where I got data from Lotus Notes into DB2 thru Lotus Pump .Now most of the data pumped into DB2 has lowercase .I have tried to Unload the data and convert all the data to uppercase in the sequential file and then Load it again.It worked for many tables but for some it did not work .It was giving a message Data Conversion error for a particular numeric field. Could anyone tell me any other way of doing this ? I [...] 4707 93 22_Re: SECQTY and extents0_19_Tim.Lowe@STPAUL.COM31_Tue, 24 Jul 2001 09:43:40 -0500565_us-ascii Phil, Do you have a product like Stop/X37 that could be reducing your secondary extent requests to the available space? Normally, each extent request should be satisfied by up to 5 extents. So, I could easily see a 107 cylinder request occasionally being satisfied by 5 extents, one of which might be a single cylinder. But, this should be very rare. However, I know that Stop/X37 used to have a a feature that did exactly what you describe. The new SECQTYI column does not get filled in until you alter an existing object in V6, it sounds like it is [...] 4801 35 13_SQL CODE -91915_Janardhan Ragam16_sragam@YAHOO.COM31_Tue, 24 Jul 2001 07:48:51 -0700327_us-ascii Hi All,

Has anybody encountered sqlcode -919 when running a cics transaction that tries to insert/delete records on a table defined on db2 for aix? The same program when run in batch on s390 works just fine. Also inserts/deletes from spufi works fine. Its only occurring when program is invoked from cics. [...] 4837 17 28_Re: Timestamp as primary key14_William Poston21_william.poston@DB.COM31_Tue, 24 Jul 2001 10:01:02 -0600115_us-ascii I don't remember but isn't there some down side to using timestamp as a primary key in DB2



4855 40 57_Re: Documention for DB2 Java Stored Procedures (COMPJAVA)18_Jean-Jacques Borie18_jjborie@TEKORA.COM31_Tue, 24 Jul 2001 16:56:04 +0200680_iso-8859-1 DB2 Java Stored Procedures Redbook : SG24-5945-00 ISBN: 0-7384-1877-3

Jean-Jacques Borie Directeur recherche et développement www.tekora.com "Changez votre conception des sites web" jjborie@tekora.com +33 (0) 1 55 00 10 03 +33 (0) 6 60 19 95 24 17, place de la résistance 92130 Issy les moulineaux France

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If [...] 4896 60 49_Re: Calling stored procedures from within Cobol .13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Tue, 24 Jul 2001 11:11:17 -0400677_iso-8859-1 If my memory serves me correctly, Fixed length parameter max is 255. Variable length can be 32K.

Dave Kenski

-----Original Message----- From: tom plasschaert [mailto:tom.plasschaert@NBB.BE] Sent: Tuesday, July 24, 2001 10:26 AM To: DB2-L@RYCI.COM Subject: Calling stored procedures from within Cobol .



Is someone aware of any restrictions in DB2 v 5 when calling a stored procedure with parameter lenght >256 bytes from within COBOL ? "Problem detected at CALL of a stored procedure in a COBOL-program. The length of the passed parameter seems to be restricted. Linkage defined : 1200 bytes. Data returned after CALL : 256 bytes. " [...] 4957 22 47_Migration from DB2 for OS/390 V5 to V7 (repost)12_Bob LaCerais28_Bob_LaCerais@TAX.STATE.NY.US31_Tue, 24 Jul 2001 11:12:05 -0400427_us-ascii Has anyone gone directly from DB2 for OS/390 Version 5 to Version 7? If so, what were your experiences?

We're considering dong this. Does anyone know any good reasons why we shouldn't?



(I originally posted these questions late last Friday afternoon. I suspect that I got minimal response because my email was swept away with a lot of other weekend stuff. Thanks, Eric, I got your response.) [...] 4980 33 28_Re: Timestamp as primary key0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 24 Jul 2001 10:13:54 -0500502_us-ascii If you use local time, not GMT, there is a problem with Daylight savings time in the FALL. Clock 'falls' back an hour, potentially causing overlapping timestamps.









William Poston @RYCI.COM> on 2001/07/24 11:01:02 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Re: Timestamp as primary key [...] 5014 25 8_rexx/db215_Dorinda Peachey22_dorinda@ARCHES.UGA.EDU31_Tue, 24 Jul 2001 11:16:34 -0400587_US-ASCII Can someone help me find this document?

In Appendix C of DB2 UDB Server for 0S/390 Version 6 Technical Update (SG24-6108-00) it says to see REXX Language Support (rexxv6.pdf). That is the PDF I am looking for.

thanks dorinda



Dorinda Peachey Senior Systems Support University of Georgia Athens, Georgia 30602

================================================ 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. 5040 57 57_Re: Documention for DB2 Java Stored Procedures (COMPJAVA)15_Benjamin Reches33_Benjamin.Reches@MORGANSTANLEY.COM31_Tue, 24 Jul 2001 11:17:08 -0400624_us-ascii the DB2 Java Stored Procedures REDBOOK

Waldo Tumanut wrote:

> I'm looking for documention on implementing DB2 v6 Java Stored Procedures -- > from installation of software components; configuring DB2, CICS, TSO (for > preparing programs); and program preparation. What do you recommend? Are > there online documents available? > > Thanks for the help. > > Waldo > > ================================================ > 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. 5098 74 22_Re: SECQTY and extents19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 24 Jul 2001 10:24:08 -0500558_iso-8859-1 quick guess -- if it isn't stop x37, it was originally nnnn by 720 and someone changed it. Confirm this by looking at the size of the last extent -- if its 107 cyls that's your answer . . .

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 [...] 5173 91 49_Re: Calling stored procedures from within Cobol .15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Tue, 24 Jul 2001 17:36:29 +0200575_iso-8859-1 Tom,

Is the column you request a character or varchar. Char is more limited. Just my first thought, I don't have any documentation available.

Kind regards,

Jaap Slot,

Data Service Center Rabobank ICT

tel: 030 215 2220 fax: 030 215 3003 mob: 06 5374 0167 mailto:J.P.Slot@rf.rabobank.nl











-----Original Message----- From: tom plasschaert [mailto:tom.plasschaert@NBB.BE] Sent: Tuesday, July 24, 2001 4:26 PM To: DB2-L@RYCI.COM Subject: Calling stored procedures from within Cobol . [...] 5265 47 28_Re: Timestamp as primary key17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Tue, 24 Jul 2001 10:37:03 -0500371_us-ascii Yes, to make sure that the timestamp is 100 percent unique you have to make the timestamp bit data. You cannot use an index with bit data. You can create the index but it won't use it.





From: William Poston @RYCI.COM on 07/24/2001 11:01 AM

Please respond to DB2 Data Base Discussion List [...] 5313 53 12_Re: rexx/db215_Robert lawrence21_rlawrence@BOSCOVS.COM31_Tue, 24 Jul 2001 11:38:31 -0400630_iso-8859-1 Dorinda, I believe the information in this document is now contained in the V6 application programming guide,

HTH Bob Lawrence DBA Boscov's Dept Stores LLc





> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Dorinda Peachey > Sent: Tuesday, July 24, 2001 11:17 AM > To: DB2-L@RYCI.COM > Subject: rexx/db2 > > > Can someone help me find this document? > > In Appendix C of DB2 UDB Server for 0S/390 Version 6 Technical Update > (SG24-6108-00) it says to see REXX Language Support (rexxv6.pdf). That is > the PDF I am looking for. > [...] 5367 13 32_Remove a column without dropping12_Aditya Narra31_Aditya.Narra@NYCBOE.NYCENET.EDU31_Tue, 24 Jul 2001 11:37:00 -0400420_- Hi All, I have added a column to a table and now I would like to remove that very particular column.Is there any way I can do it without droppping the table. 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. 5381 40 28_Re: Timestamp as primary key17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Tue, 24 Jul 2001 10:32:31 -0500364_iso-8859-1 I don't know if anyone has responded to this one, but one problem I can think of is transaction arrival rate, is it too fast to allow timestamp to be uniquely generated?

-----Original Message----- From: William Poston [mailto:william.poston@DB.COM] Sent: Tuesday, July 24, 2001 11:01 To: DB2-L@RYCI.COM Subject: Re: Timestamp as primary key [...] 5422 143 49_Re: Calling stored procedures from within Cobol .15_Janardhan Ragam16_sragam@YAHOO.COM31_Tue, 24 Jul 2001 08:56:00 -0700342_us-ascii One more thing to look for...if it's a varchar column make sure that the host variable in the cobol program is defined at level 49.

The level number 49 is exclusively used to indicate a varying length character string and DB2 will not recognize any other level number as a component of a varying length character string. [...] 5566 97 28_Re: Timestamp as primary key15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Tue, 24 Jul 2001 18:06:18 +0200457_iso-8859-1 Besides that,

It depends what platform you're on. I do remember a discussion about timestamp in an UNIX environment, they're supposed to overflow in the near future (2010 or something?). For OS/390 you won't have that problem until the year 10000.;-)

Kind regards,

Jaap Slot,

Data Service Center Rabobank ICT

tel: 0031 30 215 2220 fax: 0031 30 215 3003 mob: 0031 6 5374 0167 mailto:J.P.Slot@rf.rabobank.nl [...] 5664 90 49_Re: Calling stored procedures from within Cobol .15_tom plasschaert22_tom.plasschaert@NBB.BE31_Tue, 24 Jul 2001 18:08:15 +0200370_iso-8859-1 Sorry,

Yes, you need this part of information . The parameter is defined as varchar(32706) . Someone has an idea ?

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] On Behalf Of Kenski, David Sent: dinsdag 24 juli 2001 17:11 To: DB2-L@RYCI.COM Subject: Re: Calling stored procedures from within Cobol . [...] 5755 61 28_Re: Timestamp as primary key12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 24 Jul 2001 19:05:37 +0200290_iso-8859-1 Hi, If you have multiple CPU machine and multiple inserting tasks/transactions you may get duplicates as well. I had it happen as back as 1989-90 on a 400J machine. If it's a must to use timestsamp as PK (or unique key) then you need to have a retry logic on duplicate key. [...] 5817 19 32_Stored Procedure WLM Environment16_sylvie Vuittenez24_sylvie.vuittenez@NOOS.FR31_Tue, 24 Jul 2001 11:00:59 -0500420_- Hello I have a stored procedure executed in a WLM environment. WLM is in compatibility mode. My procedure is defined with option RESIDENT YES. If I compile and link a new module associated with my procedure, must I stop and start the WLM address space with the MVS command CANCEL then START. In a development environment, the programmers dont'have the authority for such commands. Thank you for your help. Sylvie [...] 5837 48 28_Re: Timestamp as primary key25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Tue, 24 Jul 2001 11:17:54 -0500662_iso-8859-1 Nah, DB/2 uses GMT only. ----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, July 24, 2001 10:13 AM Subject: Re: Timestamp as primary key



> If you use local time, not GMT, there is a problem with Daylight savings > time in the FALL. Clock 'falls' back an hour, potentially causing > overlapping timestamps. > > > > > > William Poston @RYCI.COM> on 2001/07/24 11:01:02 AM > > Please respond to DB2 Data Base Discussion List > > Sent by: DB2 Data Base Discussion List > > > To: DB2-L@RYCI.COM > cc: > [...] 5886 12 17_Re: SQL CODE -91911_Mike Fatula17_mfatula@PHEAA.ORG31_Tue, 24 Jul 2001 12:43:21 -0400305_us-ascii Is the Client DBM parameter TP_MON_NAME equal to CICS?

================================================ 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. 5899 27 28_Re: Timestamp as primary key15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Tue, 24 Jul 2001 18:48:37 +0200423_us-ascii That has to be pretty darned fast inserts. I did an exercise once, I think in 1996, on how many instructions (assembler) you had to do this. Really can't recall how I calculated it specifically - had to do with MIPS etc. I think you had something like 200 instructions ( on our hardware back then). I'd guess that it's probably quite a few more instructions now, as I guess MIPS have increased significantly. [...] 5927 48 36_Re: Stored Procedure WLM Environment12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 24 Jul 2001 10:37:19 -0700646_us-ascii You've just run into some of the problems with RESIDENT YES and WLM Compatibility mode. You must use the MVS CANCEL/START commands to refresh the address space.

RESIDENT NO would alleviate this to most extents. Why do you need RESIDENT YES in test/development?

If you're in GOAL MODE, there's an MVS command WLM,REFRESH that must be issued. For stored procedures built with the DB2 connect stored procedure builder and FP3, this command will be issued automatically as part of the build process. --- sylvie Vuittenez wrote: > Hello > I have a stored procedure executed in a WLM environment. [...] 5976 168 49_Re: Calling stored procedures from within Cobol .12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 24 Jul 2001 10:41:22 -0700638_us-ascii Plus don't forget the length variable must be a 49 level as well.

01 OUTPUT-PARM-LIST. 49 PARMLEN PIC S9(4) USAGE COMP. 49 PARMTXT PIC X(32000).

PROCEDURE DIVISION USING INPUT-PARM-LIST, OUTPUT-PARM-LIST.



And the SP must set PARMLEN.



--- Janardhan Ragam wrote: > One more thing to look for...if it's a varchar column > make sure that the host variable in the cobol program > is defined at level 49. > > The level number 49 is exclusively used to indicate a > varying length character string and DB2 will not > recognize any other level number as a component of [...] 6145 36 24_DB2 V6 with ACF2 for DB218_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 24 Jul 2001 13:44:52 -0400291_iso-8859-1 We could use a little info here if anyone has had this problem. My systems programmer asked if I'd post his question to our group to see if anyone could help. They are dealing with another of our DB2 OS/390's that uses ACF. We would appreciate any tips. Here's his question: [...] 6182 122 24_Re: -DIS LOCATION DETAIL0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Tue, 24 Jul 2001 12:45:28 -0500271_us-ascii We're on V6. I 'm afraid I can't answer your V5 question. I looked in my V5 command manual and looks like it should work for you. as long as you have either Display privilege or Sysopr, Sysctrl or Sysadm authority. As it is, I have a question on this too.. [...] 6305 119 28_Re: Timestamp as primary key25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Tue, 24 Jul 2001 12:46:08 -0500579_iso-8859-1 The 64 bit clock rolls on 2041. We should be converted to the 128 bit clock by then. From POPs: 3. A program using the clock value as a time-of-day and calendar indication must be consistent with the programming support under which the program is to be executed. If the programming support uses the standard epoch, bit 0 of the clock remains one through the years 1972-2041. (Bit 0 turned on at 11:56:53.685248 (UTC) May 11, 1971.) Ordinarily, testing bit 0 for a one is sufficient to determine if the clock value is in the standard epoch. ----- Original Message [...] 6425 44 28_Re: DB2 V6 with ACF2 for DB210_Bob Riehle19_bob.riehle@WAMU.NET31_Tue, 24 Jul 2001 11:12:08 -0700537_us-ascii Hi Steve, What type of acf/db2 problems are you having? We have DB2 V6 with ACF2 running OK.



"Whittaker, Stephen" wrote:

> We could use a little info here if anyone has had this problem. > My systems programmer asked if I'd post his question to our group to see if > anyone could > help. They are dealing with another of our DB2 OS/390's that uses ACF. We > would appreciate > any tips. > Here's his question: > > >>Please put a question out to the forum - ask if anyone is running DB2 V6 > with ACF2 [...] 6470 76 28_Re: Timestamp as primary key18_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Tue, 24 Jul 2001 20:16:11 +0200650_us-ascii Hi, You can use a timestamp as primary key, but check always for a -803(duplicates). Just use row_id generated always, you can use it also as an partitiong key.

Gerrit

Rohn.Solecki@MTS.MB.CA wrote:

> If you use local time, not GMT, there is a problem with Daylight savings > time in the FALL. Clock 'falls' back an hour, potentially causing > overlapping timestamps. > > William Poston @RYCI.COM> on 2001/07/24 11:01:02 AM > > Please respond to DB2 Data Base Discussion List > > Sent by: DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: > Subject: [...] 6547 143 24_Re: -DIS LOCATION DETAIL12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Tue, 24 Jul 2001 13:18:46 -0500506_iso-8859-1 For all of you data sharing experts, is there a parameter that is set which indicates whether a subsystem is a server or requestor that might be showing up as a version/release number in Shan's email below?

just offering a wag, john

-----Original Message----- From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM [mailto:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] Sent: Tuesday, July 24, 2001 12:45 PM To: DB2-L@RYCI.COM Subject: Re: -DIS LOCATION DETAIL [...] 6691 37 47_DB2 Connect PE V7.1 & PowerBuilder 7.0 question12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 24 Jul 2001 13:24:46 -0500489_us-ascii Hello, OS/390 V2R10, DB2 6.1 here!

We've just installed DB2 connect version 7.1 and love it except for one "significant" problem. Our PowerBuilder database painter is stumbling with the following messages:

Catalog tables could not be created and are not available for use.

and, when we try to open the table folder,

SQLSTATE = S0022 [IBM][CLI Driver][DB2] SQL0206N "'DBAPROD','SYSIBM'" is not valid in the context where it is used. SQLSTATE=42703 [...] 6729 70 28_Re: DB2 V6 with ACF2 for DB216_Pranav M. Sampat21_PSampat@PACIFICEX.COM31_Tue, 24 Jul 2001 11:31:06 -0700312_iso-8859-1 Stephen, We run DB2 with ACF2. We had no problems configuring it. The DSN3@ATH and DSN3@SGN are supplied alongwith ACF and need to be link-edited into SDSNEXIT Our Environment details - S/390 V2R7 DB2 V6 on S/390 ACF2 6.3 (I also works fine with 6.2)

What are the probems you are facing ? [...] 6800 73 28_Re: DB2 V6 with ACF2 for DB218_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 24 Jul 2001 14:36:07 -0400441_iso-8859-1 Here's the type of problem they are having:

>>No one other than install SYSADM can use it, that's all! So if you ain't an install SYSADM, pick up your marbles and go home. When they deactivated ACF2 for DB2, anyone could get to it and use SPUFI, batch TEP2, etc<<





Steve Whittaker DB2/DBA Progress Energy, Inc. Mail stop:OHS 10- Raleigh Email: stephen.whittaker@pgnmail.com Phone: (919) 546-7267 [...] 6874 40 25_Binding from USS on S/39014_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 24 Jul 2001 12:05:56 -0700446_us-ascii

Has anyone or does anyone know how to issue a BIND from USS on S/390?







Regards, Richard +---+---+---+---+ IBM DB2 and Sysplex Gold Consultant IBM Certified Solutions Expert: DB2 V7 Database Administration OS/390 richard_yevich@ylassoc.com YL&A -- www.ylassoc.com



--------------------------------- Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger 6915 18 16_db2 data sharing10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 24 Jul 2001 15:10:02 -0400418_us-ascii Hi all

Does anyone have a feeling for the advantages and/or dis-advantages of running 2 members of a data sharing group on the same MVS lpar?



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. 6934 13 23_00F30055 from WEBServer16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Tue, 24 Jul 2001 12:15:00 -0700260_- We are just starting to use Webspher appl. server on OS390 and are getting 00F30055 errors after a awhile connecting to DB2 V6 on OS390. Is there some parm in WAS we have to set lower or is WAS not releasing threads as it should? WAS is 3.02 I am told. [...] 6948 125 28_Re: DB2 V6 with ACF2 for DB214_Crichton, Jean21_jcrichton@FEDDATA.COM31_Tue, 24 Jul 2001 15:17:32 -0400522_iso-8859-1 Steve,

Is this a new install of DB2 V6 or did you migrate from V5??? Your problem might be with the DSN3@ATH and DSN3@SGN exits, as Pranav suggested. If you migrated from V5, then check to make sure the exits got copied from the V5 SDSNEXIT to the V6 SDSNEXIT (I did this to myself once!!!). Can you tell us more about the ACF2/DB2 configuration? What kinds of error messages are you getting? I know this isn't much help, but this is a situation where we can't know too much about your environment. [...] 7074 65 20_Re: db2 data sharing0_19_Tim.Lowe@STPAUL.COM31_Tue, 24 Jul 2001 14:26:57 -0500536_us-ascii Tom, Assuming that you are talking about running 2 members of the same data sharing group on the same lpar, then I would say that this is something that should be planned for in case of an major problem with the lpar that it normally runs on. This is done to release locks when the lpar that it normally runs on cannot be restarted, but after this would be immediately brought down. (By the way, this is what the new restart(light) is for with DB2 V7 for OS/390.) Other than this, I cannot think of any other reason to do [...] 7140 55 38_DB2 OS/390 Unload format File into UDB12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Tue, 24 Jul 2001 15:44:45 -0400553_iso-8859-1 Hello list,

We have a request to load a DB2 OS390 Unload format file into a PC database (either using UDB or SQL Server). The problem is that the file contains character, integer and packed decimal values, so we have to FTP the file as binary to the PC platform. Which of course leaves all the character fields in EBCDIC and the numerics in a not so easily read format. The input file comes from an external source and CANNOT be formatted in any other way. The idea here is to transfer the file from an external mainframe that we [...] 7196 55 55_Re: Switching current database partition in DB2 UDB EEE13_Daniel Rieger25_Daniel.Rieger@T-ONLINE.DE31_Tue, 24 Jul 2001 21:36:08 +0200530_us-ascii Hi Steve,

for Question 1, there are 2 options: a) export DB2NODE=nodenumber db2 terminate <- don't forget db2 list applicattions b) db2_all "<<+nodenum
for question 2: db2_all is still required. It reads the db2nodes.cfg and starts a rsh for every db partition, even if it is on the same physical machine. db2_all works on partition level, rah on physical machine level. rah a the command to every physical machine running one or more partition of the current attached instance. [...] 7252 121 20_Re: db2 data sharing14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Tue, 24 Jul 2001 12:50:41 -0700571_iso-8859-1 Tom, In a normal case, this should be avoided. When a DB2 attach comes in with the Group Attach Name, DB2 will connect to the FIRST subsystem in the chain that is available. What this means is that the ONLY way to get applications to connect to both subsystems is to have them attach using the member, not group name. Also, if you are using CPU parallelism, having two members on the same LPAR will increase the chances of a run-away SQL request locking up the LPAR. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com (630) 836-4005 [...] 7374 18 75_Can DB2 generate a sequential number that can be used to make a key unique?8_Dan Alex16_dalex@US.IBM.COM31_Tue, 24 Jul 2001 15:49:55 -0400281_us-ascii Create a table where 4 columns are needed to make a key unique. Can DB2 generate a sequential value for column 4? This would then make the key unique. What do we have to do to make it work. I heard that there is a way for DB2 to generate a unique value for a column. [...] 7393 15 20_Re: db2 data sharing11_Ruth Sutlic24_ruth.sutlic@DILLARDS.COM31_Tue, 24 Jul 2001 14:45:42 -0500421_- Hi Tom, We have our test db2 datasharing environment setup on one lPAR. It's a two member data sharing group with v5 and v7. Our product setup is not setup this way.

Ruth

================================================ 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. 7409 76 12_Re: rexx/db212_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 24 Jul 2001 12:37:45 -0400487_US-ASCII Dorinda,

Some other resources for REXX are: http://www-4.ibm.com/software/ad/rexx/ http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IKJ3A310/4.4.

IBM DB2 Manuals: http://www-4.ibm.com/software/data/db2/os390/v7books.html

Do a search on REXX in the following document: Title: DB2 UDB for OS/390 V6 Application Programming and SQL Guide Document http://www.ibm.com/software/data/db2/os390/pdf2/v7/dsnaph10.pdf



Have fun.

Cheers, 7486 42 79_Re: Can DB2 generate a sequential number that can be used to make a key unique?17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Tue, 24 Jul 2001 15:12:29 -0500465_us-ascii Yes it is called the identity column available with version 7.1 on UDB and I think 6 for os390.





From: Dan Alex @RYCI.COM on 07/24/2001 02:49 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Fax to: Subject: Can DB2 generate a sequential number that can be used to make a key unique? [...] 7529 47 79_Re: Can DB2 generate a sequential number that can be used to make a key unique?19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 24 Jul 2001 15:16:51 -0500605_iso-8859-1 Check out Identity columns . . .

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 delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 7577 164 51_Re: DB2 Connect PE V7.1 & PowerBuilder 7.0 question14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Tue, 24 Jul 2001 13:35:30 -0700393_iso-8859-1

Steve, Powerbuilder creates some tables of it's own and this might be a problem related to that. Looks like the error you are getting when opening the database painter is becuase the tables were not created. Or some DML is being executed but columns don't exist, etc. If needed, run an ODBC trace and take a look at it. It might help you identify the problem. HTH Phil [...] 7742 32 39_00C200E1 Reason Code on Imagecopy Abend0_20_Jones.H@GRAINGER.COM31_Tue, 24 Jul 2001 15:36:00 -0500529_- DB2 for OS/390 V 5.1 An imagecopy of a single partition of a tablespace abended with an 00C200E1 reason code (can't open the dataset).

DSNAME=DWW3.DSNDBC.DWD00010.DMS00070.I0001.A002 DSNT500I %P3 DSNUGRAR RESOURCE UNAVAILABLE REASON 00C200E1 TYPE 00000220

This happened twice last night, to partitions of different tablespaces. The last occurrance at this shop was a year ago. In all three cases, repeatedly rerunning the imagecopy or querying in SPUFI eventually opened the dataset and cleared the problem. [...] 7775 27 10_Shark DASD13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 24 Jul 2001 15:54:45 -0500320_iso-8859-1 Hi,

I was told our new Shark DASD does not support SNAPSHOT or compression like the RVA boxes do. They said IBM are discontinuing the line of RVA's and that SNAPSHOT and compression will not be offered in the future.

Does anyone know the full story on this. I know many sites use SNAPSHOT. [...] 7803 56 43_Re: 00C200E1 Reason Code on Imagecopy Abend13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Tue, 24 Jul 2001 14:15:01 -0700349_- check for a system error IEC161I in the jeslog for the db2mstr started task. DB2 had trouble getting the operating system to open the files. look for some operating system messages for what was going on at the time. for example, your DASD people moving things around on the farm. It may not be in an APAR because it may not be a DB2 problem. [...] 7860 68 14_Re: Shark DASD0_19_Tim.Lowe@STPAUL.COM31_Tue, 24 Jul 2001 16:37:29 -0500413_us-ascii Glenn I had heard that Shark uses Flashcopy and STK used Snapshot. And, I have also heard a rumor that the vendors did not talk the same language, so beware what one vendor says about the other vendors equipment.

Good luck, Tim





"Mackey, Glenn" To: DB2-L@RYCI.COM Subject: Shark DASD Sent by: DB2 Data Base Discussion List [...] 7929 16 14_Re: Shark DASD26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Tue, 24 Jul 2001 16:56:58 -0500471_- Most of it's true, but paints a myopic picture. See www.storage.ibm.com. IBM and Hitachi have also signed a joint licensing agreement regarding their DASD. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 7946 41 22_Re: db2split problems?13_Daniel Rieger25_Daniel.Rieger@T-ONLINE.DE31_Tue, 24 Jul 2001 21:48:43 +0200625_us-ascii Hi Fabrizio,

I can't remember that we had problems like this. Did you check: - the ulimits for the user used to run db2split - if you write the split-output to file, is the filesystem 'large-file-enabled' (must be specified when creating the filesystem)

Hope this helps

Daniel Rieger daniel.rieger@systor.com





"Napolitano, Fabrizio" wrote:

> Hi everyone, > I'm now working with UDB EEE v7.1 , new to the EEE system. > I was told by one of the Dba of the team I just joined that they are having > troubles with db2split when it comes to split tables larger than [...] 7988 20 51_Re: DB2 Connect PE V7.1 & PowerBuilder 7.0 question12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 24 Jul 2001 17:09:10 -0500371_us-ascii Thanks Phil.

The PowerBuilder tables do exist. They show up when using DB2 Connect 6.1 and they're also used to drive our data dictionary. However, I would like to do an ODBC trace. I tried once (using the ODBC Trace Options -> Trace ODBC API Calls) but the resulting log file was empty. I guess I need to look for another way to initiate the trace. [...] 8009 41 51_Re: DB2 Connect PE V7.1 & PowerBuilder 7.0 question17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Tue, 24 Jul 2001 17:16:13 -0500646_iso-8859-1 I've run into this before, but have also successfully run the odbc trace, did you give it a file name to use?

-----Original Message----- From: Steve Grimes [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Tuesday, July 24, 2001 17:09 To: DB2-L@RYCI.COM Subject: Re: DB2 Connect PE V7.1 & PowerBuilder 7.0 question



Thanks Phil.

The PowerBuilder tables do exist. They show up when using DB2 Connect 6.1 and they're also used to drive our data dictionary. However, I would like to do an ODBC trace. I tried once (using the ODBC Trace Options -> Trace ODBC API Calls) but the resulting log file was empty. I [...] 8051 92 42_Re: DB2 OS/390 Unload format File into UDB0_24_William_O'Black@FFIC.COM31_Tue, 24 Jul 2001 15:29:15 -0700525_us-ascii Robert, if the source is DB2, could the source company run a DB2 export on AIX or NT instead of an unload? That would handle the conversion for you. If so, you should be able to ftp the file down and do a straight load. If not, I think you're outta luck unless some vendor has a tool that could handle this. You'd probably have to reformat the file into all character fields, ftp it down, and then build your load statements and do the load. Or you could always build a temporary DB2 table on the host, load it [...] 8144 52 22_Re: db2split problems?12_Cook, Nicole19_Nicole_Cook@BMC.COM31_Tue, 24 Jul 2001 17:31:03 -0500548_iso-8859-1 Hi Fabrizio,

If you are on a UNIX system, make sure your file system supports large files sizes (greater than 2GB).

Regards,

Nicole

Nicole Cook DB2 UDB Platform Specialist Product Management bmcsoftware Austin, Texas 512.340.6817 800.841.2031 ncook@bmc.com

Check out what BMC has to offer for DB2 UDB! http://www.bmc.com

-----Original Message----- From: Napolitano, Fabrizio [mailto:fnapolitano@INSIRIO.IT] Sent: Monday, July 23, 2001 5:45 AM To: DB2-L@RYCI.COM Subject: db2split problems? [...] 8197 61 32_Re: Datacom to DB2 Justification22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Tue, 24 Jul 2001 17:55:40 -0500560_- We did a Proof of concept (POC) in our shop almost a year ago, using a Transparency tool. As far as performance, it was almost equal to Datacom or that was what we observed for very limited applications that we had selected for this POC. We were told by the transparency vendors before we began the POC that the performance may reduce. Don't know a whole lot about financials, since I was not involved in that part of the project. If you take the Transparency way, you'll have additional support functions of the Tool and the regular DB2 support, which [...] 8259 113 24_Re: DB2 Version question11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Mon, 23 Jul 2001 13:50:51 -0500484_iso-8859-1 We're on V6.1 on OS/390. When I issue this command, I get:

DSNL200I -CD1T DISPLAY LOCATION REPORT FOLLOWS- LOCATION PRDID LINKNAME REQUESTERS SERVERS CONVS SQL05020 L31FDB2D 0 0 0 DISPLAY LOCATION REPORT COMPLETE

Doesn't make sense. Maybe it doesn't work on OS/390?

Tina

-----Original Message----- From: Jeff Faughn [mailto:Jeff_Faughn@MAY-CO.COM] Sent: July 23, 2001 1:33 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Version question [...] 8373 35 27_Re: 00F30055 from WEBServer13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Wed, 25 Jul 2001 08:54:47 +1000594_iso-8859-1 Are you using connection pooling from your servlet. You should be.

Greg Farquhar



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of JOHN G. MATTHEWS Sent: Wednesday, July 25, 2001 5:15 AM To: DB2-L@RYCI.COM Subject: 00F30055 from WEBServer



We are just starting to use Webspher appl. server on OS390 and are getting 00F30055 errors after a awhile connecting to DB2 V6 on OS390. Is there some parm in WAS we have to set lower or is WAS not releasing threads as it should? WAS is 3.02 I am told. [...] 8409 117 24_Re: -DIS LOCATION DETAIL11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Tue, 24 Jul 2001 07:27:45 -0500385_iso-8859-1 According the DB2 command manual, this will display the product identifier of the remote system. It won't tell you anything about your system. If you don't have DDF enabled, you won't see anything at all.

So basically, if you have DB2A connected to DB2B and you want to know the version of DB2B then you can get that information by issuing this command on DB2A. [...] 8527 32 36_Re: Remove a column without dropping12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 25 Jul 2001 09:03:30 +1000583_- Easy!

Nyet! No! at least not on the big iron yet. Although there are tools around that make things easier, but you are still dropping and recreating if you want to drop a column.

Cheers, Nick Cianci > -----Original Message----- > From: Aditya Narra [SMTP:Aditya.Narra@NYCBOE.NYCENET.EDU] > Sent: Wednesday, July 25, 2001 1:37 AM > To: DB2-L@RYCI.COM > Subject: Remove a column without dropping > > Hi All, > I have added a column to a table and now I would like to remove that > very particular column.Is there any way I can do it without droppping the > table. [...] 8560 23 48_result set defination for cobol Stored procedure17_nagaraju mudhelli18_mudhelli@LYCOS.COM31_Tue, 24 Jul 2001 16:26:05 -0700524_us-ascii Hi, can some one tell me the how to define a result set locator in cobol program. I am calling a cobol stored procedure in my cobol program.

Thank you, Nagaraju





Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/

================================================ 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. 8584 44 79_Re: Can DB2 generate a sequential number that can be used to make a key unique?11_Rick Rogers21_Rick.Rogers@TELUS.COM31_Tue, 24 Jul 2001 17:31:40 -0600403_iso-8859-1 An identity can be used to create a unique number for every row in the table. In other words, it is usually used as the primary key. (PK values like this: 1, 2, 3, ...)

If you were instead looking for a unique number among the grouping of the first three columns of your key, you would have to do so programmatically. (PK values like this: A,B,C,1; A,B,C,2; A,D,E,1; A,D,E,2;...) [...] 8629 118 32_OnLine Reorg - Run out of sortwk14_Johnson, Daryl28_Daryl.Johnson@PACIFICORP.COM31_Tue, 24 Jul 2001 16:43:19 -0700426_iso-8859-1 Input: table space has 500m rows & a part index only, 10 part's REORG TABLESPACE tablespace COPYDDN SYSCOPY SHRLEVEL CHANGE DEADLINE 2001-07-29-21.00.00.000000 MAPPINGTABLE ROMAPDB1.RO_MAP_TB7 MAXRO 300 LONGLOG DRAIN DELAY 1200 TIMEOUT TERM KEEPDICTIONARY SORTDEVT DISK SORTNUM 14

Syncsort message - wer046a sort capacity exceeded

How do I affect the total amount of dasd (cyl/trk) preallocated? [...] 8748 54 36_Re: Remove a column without dropping16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Tue, 24 Jul 2001 19:44:48 -0400549_us-ascii use a view of table prior to adding col.







"Cianci, Nick" on 07/24/2001 07:03:30 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: Remove a column without dropping





Easy!

Nyet! No! at least not on the big iron yet. Although there are tools around that make things easier, but you are still dropping and recreating if you want to drop a column. [...] 8803 61 36_Re: Remove a column without dropping17_Gerry Sturkenboom22_gsturkenboom@LIC.CO.NZ31_Wed, 25 Jul 2001 11:41:14 +1200480_us-ascii Surely it is possible to drop a column in a table without recreating the complete table - this is the 21st century guys!

How about: ALTER TABLE tablename DROP columnname;

No wonder IBM wanted Informix











"Cianci, Nick" on 25/07/2001 11:03:30

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Gerry Sturkenboom/ham/LIC) [...] 8865 79 36_Re: Remove a column without dropping12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 25 Jul 2001 10:15:56 +1000654_- Yes that is a technique to "hide" the column.

... but if you want to drop the column .......

Cheers, Nick Cianci DB2 DBA - CCRI Project 5th Floor (South) 484 StKilda Rd MELBOURNE 3004 * +613) 9865-8354 Work 0408-64 06 01 Mobile * MailTo:Nick.Cianci@team.telstra.com MailTo:NCianci@CPTglobal.com

> -----Original Message----- > From: Thomas E. Faglon [SMTP:tfaglon@TELCORDIA.COM] > Sent: Wednesday, July 25, 2001 9:45 AM > To: DB2-L@RYCI.COM > Subject: Re: Remove a column without dropping > > use a view of table prior to adding col. > > > > > "Cianci, Nick" on 07/24/2001 07:03:30 PM > > Please [...] 8945 133 51_Re: DB2 Connect PE V7.1 & PowerBuilder 7.0 question14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Tue, 24 Jul 2001 18:23:17 -0700442_iso-8859-1 Steve, Add the following to the db2cli.ini file or turn on via the CCA through properties, settings, advanced, service tab. Don't forget to turn it off when done. Phil

CLI TRACE [COMMON] ;Trace=0 sets tracing off Trace=1 TraceFileName=C:\TRACE\CLI9910.TXT



-----Original Message----- From: Steve Grimes To: DB2-L@RYCI.COM Sent: 7/24/01 3:09 PM Subject: Re: DB2 Connect PE V7.1 & PowerBuilder 7.0 question [...] 9079 21 36_LOCKS ACQUIRED DURING MODIFY UTILITY28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 24 Jul 2001 19:06:54 PDT361_- There is a DBD lock (database level) acquired for MODIFY automatically when we set UTRW. I looked into various APARs that may affect utility DBD locking and found these:

PQ43944 - Changed DBD locks from allocation duration to commit duration PQ45609 - Utility DBD locking changes

The later is in PTF build now and should be available soon. [...] 9101 47 57_Re: DB2-L Digest - 24 Jul 2001 to 25 Jul 2001 (#2001-209)37_L-Soft list server at RYCI.COM (1.8d)17_LISTSERV@RYCI.COM31_Wed, 25 Jul 2001 01:15:30 -0500335_- > There are 85 messages totalling 4740 lines in this issue. Unknown command - "THERE". Try HELP.

> Topics of the day: Unknown command - "TOPICS". Try HELP.

> 1. Debra Kopecky/PCSHS is out of the office. Unknown command - "1.". Try HELP.

> 2. Incremental Image Copy Hazard. Unknown command - "2.". Try HELP. [...] 9149 26 36_Re: Remove a column without dropping13_Patric Becker25_Patric_Becker@SIS-WEST.DE31_Wed, 25 Jul 2001 02:20:48 -0500500_ISO-8859-1 Hi !

Your question was also asked at the DB2/IMS Technical Conference 2001 in Hamburg, and the answer was simply "No". The suggestion provided by IBM was "Leave the column in the table and simply ignore it", because too many actions would have to be taken in DB2 to remove the column from the table (think of reorg of data pages, possibly build a new compression dictionary, etc.). But in my opinion it´s a good requirement to IBM´s DB2-Group to implement this new function... [...] 9176 96 14_Re: Shark DASD16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Wed, 25 Jul 2001 09:02:04 +0100496_us-ascii Glenn,

at a previous customer I supported, when still working for Big Blue, we had this selfsame problem...

Snapshot was not supported by ESS, the problem was that there were also terrible problems with availability of Flashcopy, which kept on being pushed to a later date all the time.

I believe Flashcopy is now available for ESS/Shark, would not bet on it but I recall someone on this list saying their shop was "now" successfully using it a few months ago. [...] 9273 41 14_Re: Shark DASD15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Wed, 25 Jul 2001 03:26:29 -0500478_iso-8859-1 I believe FlashCopy only works at the volume level, with dataset level support supposed to be later this year.

Andy Lankester bmcsoftware My opinions are just that

-----Original Message----- From: Aurora Dell'Anno [mailto:Aurora_DellAnno@CANDLE.COM] Sent: 25 July 2001 09:02 To: DB2-L@RYCI.COM Subject: Re: Shark DASD



Glenn,

at a previous customer I supported, when still working for Big Blue, we had this selfsame problem... [...] 9315 28 29_Need Help ASAP, DB2 7.1 on NT11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Wed, 25 Jul 2001 15:39:52 +0700333_- Guys,

We're facing a problem on our DB2 7.1 running on an NT box. We keep facing 'System is Running on Low Virtual Memory' After checking the Task Manager, we found that there were so many 'db2bp' application running, which were using so much amount of the memory. How can we control 'db2bp'? What 'db2bp' really does? [...] 9344 77 22_Re: SECQTY and extents10_CEI, Bruno20_Bruno.CEI@SEMA.CO.UK31_Wed, 25 Jul 2001 09:53:56 +0100552_iso-8859-1 Hi Phil,

Another guess could be CA Fastload. I recall it changing the SECQTY value to 1 record unless some maintenance is applied.

Bruno

-----Original Message----- From: DBA Support [mailto:dbasupport@WILLIS.COM] Sent: 24 July 2001 15:15 To: DB2-L@RYCI.COM Subject: SECQTY and extents



Hi

We have a few tablespaces in 30+ extents which we were not too worried about, but we now have some over 100 extents, and one is at 215 extents. We have recently gone to DB2 V6.1, so this may be connected. [...] 9422 72 42_Re: DB2 OS/390 Unload format File into UDB11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Wed, 25 Jul 2001 11:21:03 +0200469_us-ascii Hi Robert,

I would try the DB2 LOAD utility, something like

LOAD FROM file OF ASC MODIFIED BY RECLEN=rec-len BINARYNUMERICS PACKEDDECIMAL CODEPAGE=x METHOD L ( ... ) INSERT/REPLACE INTO table



where x is the EBCDIC code page number used in the unload file (870/1153/892/893 ... ?) If the unload file really contains only character (CODEPAGE) and packed decimal (PACKEDDECIMAL) and integer (BINARYNUMERICS) data, it might work. [...] 9495 25 0_17_jennifer jennifer22_jenni_jeni@HOTMAIL.COM31_Wed, 25 Jul 2001 09:46:51 +0000520_- Hi All, I have a probelm again while loading. I m looking for the immidiate solution as you know I m a novice in this field and I m getting probelm without experience and I m seeking all you help. The probelm is while loading into table I m gett8ing the probelm. The second column is field is DEC(19,0) and the file is having dec(15,0). I m getting the conversion error. I tried to load through by using the punch card also by mentioning the position. But I get the same probelm. Can any body be help to me asap. [...] 9521 53 0_16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 25 Jul 2001 15:44:23 +0530325_- Jennifer,

Could you tell us what changes you made in the punch card ? The problem is that the next column data is failing in the data conversion as it is mapped to DEC(19,0). If you can unload your data again, try putting DEC(column name, 19,0) in the SELECT query for the column which is defined as DEC(19,0). [...] 9575 31 22_MSQUERY and DB2 OS390.10_Mark Frost23_mark.frost@CITICORP.COM31_Wed, 25 Jul 2001 11:21:15 +0100376_US-ASCII Hi everyone.

Im trying to access DB2 OS390 from Microsoft Query.

I have installed.

DB2 V6 OS390 DB2 Connect V7.1 MSQUERY V8.00



All my ODBC bits look good and the test connections work succesfully.

When I execute MSQUERY however it asks me to select the datasource, which I do, after this the program MSQRY32.EXE dumps. [...] 9607 134 0_0_18_mebert@AMADEUS.NET31_Wed, 25 Jul 2001 12:38:00 +0200587_us-ascii Hi Jennifer,

did you try this in the LOAD statement (I'm assuming DB2 for OS/390, don't know the syntax on LUNO):

Columname POSITION(n:n+7) DEC,

remember that you describe the format of the input data in the LOAD cards, not the DB2 column format. A DEC(15,0) has 8 bytes and thus occupies positions n thru n+7 in the input record. It is not quite clear to me from the Utility Guide whether DB2 recognises the end of the field by itself (it should be possible, from the sign halfbyte). In that case POSITION(n) would be enough. If this doesn't work, it [...] 9742 77 22_Re: db2split problems?20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Wed, 25 Jul 2001 12:26:19 +0200290_iso-8859-1 Hi , thank you every one. Probably I was a bit to short writing my post. However we have no problems of ulimit or Large filesystem enabling. And also we use db2split on its own and not with db2atld. Maybe I got a clue to work on. Thank again and Regards Fabrizio Napolitano [...] 9820 49 25_R: MSQUERY and DB2 OS390.16_Petteno' Massimo27_Petteno.Massimo@GENERALI.IT31_Wed, 25 Jul 2001 13:30:43 +0200140_- I had the same problem on Windows NT. I have solved the problem installing DB2 Connect Version 6.1. Now it works fine. Regards Max

9870 30 0_19_José Ignacio Ossuna16_jiossuna@ATCA.ES31_Wed, 25 Jul 2001 13:20:00 +0200602_iso-8859-1 Hi Jennifer,

You would try this in the LOAD statement :

Columname POSITION (n:m) DECIMAL EXTERNAL,

where n is the initial position and m is the final position of the column within the input data. This is right if your input data has the column not in packed decimal format.

Good Luck











===============================================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. 9901 36 10_DDF status18_Ricardo Lino Gomes20_ricardo.gomes@BCP.PT31_Wed, 25 Jul 2001 12:18:15 +0100437_iso-8859-1 Hello DB2'ers This is a very simple question and I'm pretty new to distributed DB2. I use Data Propagator and the following need just occurred. I issued -START DDF on my DB2. My MSTR started task tells me so if I need to check it...but, How do I do to check if all is alive and well in the land of DDF? Is there a display or similar command to give me that info? (besides issuing D NET,ID=db2identifier,E on the console) [...] 9938 214 24_Re: DB2 Version question14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 25 Jul 2001 12:44:55 +0100374_iso-8859-1 I think it was also shorthand.

Simplistically (although IBM complicated things by having so much new function in the maintenance stream) people started to refer to the V6 RML as V6.2 to differentiate it from the 'original' V6 that had some major issues when it first came out.

Officially, though, there was (on the OS390 platform) only ever V6 [...] 10153 214 22_Re: SECQTY and extents14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 25 Jul 2001 12:45:06 +0100312_iso-8859-1 When Db2 is unable to get the whole secondary allocation on a volume, it goes into "minimal extend" and gets much smaller secondary extents so that things don't come to a complete halt.

Is it likely that your volume does not have 107 free cylinders? (or is the volume highly fragmented??) [...] 10368 66 27_Re: 00F30055 from WEBServer9_Mike Deer20_Michael.Deer@UAL.COM31_Wed, 25 Jul 2001 07:11:27 -0500630_- John -

I guess the question is whether the application is making direct connects to DB2 (as opposed to using thread pooling). Early implementations of the WAS built-in thread pooling were very problematic. Many applications at my shop simply choose either to directly connect to DB2 or to implement an application-managed thread pooling mechanism. If you are convinced that the 00F30055 is not simply due to the DB2 max user limit set too low, be sure the applications are cleaning up the database connections in *all* situations. Its pretty common for servlet programmers to forget to close the database connection [...] 10435 36 52_Re: result set definition for cobol Stored procedure11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 25 Jul 2001 08:25:26 -0400553_iso-8859-1 The example I posted to the documents site includes a locator for a result set. Both the caller and the SP are COBOL. See:



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



-----Original Message----- From: nagaraju mudhelli [mailto:mudhelli@LYCOS.COM] Sent: Tuesday, July 24, 2001 7:26 PM Subject: result set defination for cobol Stored procedure



Hi, can some one tell me the how to define a result set locator in cobol program. I am calling a cobol stored procedure in my cobol program. [...] 10472 34 28_Datacom to DB2 Justification14_Randy Ebersole19_ebersole@US.IBM.COM31_Wed, 25 Jul 2001 08:23:37 -0400499_us-ascii Bob, In regards to a Datacom to DB2 for Os/390 and z/OS, I would consider several things. From the support side of things I would considering exploitation of the newest hardware and software. How quickly will Datacom be changed to exploit the new Z series hardware or the new z/OS operating system. Also, how does Datacom best support the whole e-business world in comparison to DB2. Can Datacom support you ongoing database needs over the next 3 - 5 years is a more general question. [...] 10507 153 49_Re: db2 connect control center admin. OS390 TOOL?15_Neff, Stephen R16_NeffSR@STATE.GOV31_Wed, 25 Jul 2001 09:38:32 -0400735_iso-8859-1 Hello, Thank You for your replies.

It looks like DSNTIJCC has run. I looked in the sysibm.sysroutines table and find DSNACCAV DSNACCMD DSNACCMG DSNACCQC DSNTPSMP DSNUTILS DSNWZP I see where there are runopts parameter entries TRAP(OFF),STACK(,,ANY,) TRAP(OFF),STACK(,,ANY,) TRAP(OFF),STACK(,,ANY,) TRAP(OFF),STACK(,,ANY,) TRAP(OFF),MSGFILE(SYSPRINT) TRAP(OFF) TRAP(ON),TERMTHDAC(UADUMP)

Since I can't find any warning or error messages (when I try to create the OS390 subsystem folder using the PC control center) I am wondering if the runopts parameters suppress messages. The sql reference says RUNOPTS Ś VARCHAR(254) Ś The Language Environment run-time Ś G Ś Ś Ś NOT NULL Ś options to be used for this [...] 10661 53 28_Re: Timestamp as primary key14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 25 Jul 2001 08:42:27 -0500395_- In http://bama.ua.edu/cgi-bin/wa?A2=ind0009&L=ibm-main&P=R97311 Greg Dyck asserted that "[e]very STCK value within a CEC, by architecture, is guaranteed to be unique."

So if you use STCK with a varying offset between local and psuedo-GMT (psuedo because it doesn;t take leap seconds in account), then the STCK timestamp's should be unique.

Now if you have multiple CECs ... [...] 10715 25 53_Documention for DB2 Java Stored Procedures (COMPJAVA)16_Sharon Zitterman24_Sharon.Zitterman@TRW.COM31_Wed, 25 Jul 2001 10:00:21 -0400598_US-ASCII Waldo,

Try this URL. It looks like it might contain what you are looking for.

http://www-1.ibm.com/servers/s390/os390/bkserv/find_books.html

Do a find on JAVA and one of your choices should be DB2 UDB for OS/390 V6 Application Programming Guide and Reference for JAVA.

Hope this helps.

Sharon Zitterman TRW Systems

===============================================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. 10741 27 41_CURRENT SQLID , RACF groups and DB2 exits22_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM31_Wed, 25 Jul 2001 07:45:45 -0700313_iso-8859-1 Hello Gurus, Wonder if I can probe the group a little on this topic. I am faced with the same situation of having to use different qualifiers for the application (Powerbuilder/VB via DB2 Connect) when in different test environments in the same subsystems. (D11 for dev, T11 for Test, P11 for QA). [...] 10769 159 49_Re: db2 connect control center admin. OS390 TOOL?12_David Booher22_David.Booher@QUEST.COM31_Wed, 25 Jul 2001 07:33:07 -0700874_iso-8859-1 Another side note:

You have to add additional DDs [SYSIN/SYSPRINT] in your WLM environment for DSNUTILS to run correctly. Here's a sample one we use:

//************************************************************* //* JCL FOR RUNNING THE WLM-ESTABLISHED STORED PROCEDURES //* ADDRESS SPACE //* RGN -- THE MVS REGION SIZE FOR THE ADDRESS SPACE. //* DB2SSN -- THE DB2 SUBSYSTEM NAME. //* NUMTCB -- THE NUMBER OF TCBS USED TO PROCESS //* END USER REQUESTS. //* APPLENV -- THE MVS WLM APPLICATION ENVIRONMENT //* SUPPORTED BY THIS JCL PROCEDURE. //* //************************************************************* //DSD7WLM PROC RGN=0K,APPLENV=DSD7WLM,DB2SSN=DSD7,NUMTCB=8 //IEFPROC EXEC PGM=DSNX9WLM,REGION=&RGN,TIME=NOLIMIT, // PARM='&DB2SSN,&NUMTCB,&APPLENV' //STEPLIB DD DISP=SHR,DSN=QSM.WRK020.LOADLIB // DD DISP=SHR,DSN=DSN710.RUNLIB.LOAD // [...] 10929 56 14_Re: Shark DASD9_Bob Crail15_r.crail@ATT.NET31_Wed, 25 Jul 2001 15:01:08 +0000318_- I currently have a client that uses the SHARK and utilizes FlashCopy (nightly) to create development files (full copies). It is true that FC is at a volume level, with Data Set level promised. When is anyones guess. It is also true that as often as not it gets 'bumped' off the schedule. BTW we do not FC DB2 'stuff' 10986 76 33_Partition independence - Or Not !14_Adrian Collett27_adriancollett@TISCALINET.IT31_Wed, 25 Jul 2001 17:24:26 +0200431_iso-8859-1 Dear List, Apologies for the length of this but.......

One of my clients has a problem with partition NON-independence:

We had a read-only process which accessed just ONE partition using an NPI. The process did not access any other partition at all. There were no other processes active at the time. We then needed to REBUILD a DIFFERENT PARTITION of the same NPI using: REBUILD INDEX(ixname) PART n. [...] 11063 52 26_Re: MSQUERY and DB2 OS390.13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 25 Jul 2001 10:46:52 -0500347_iso-8859-1 Mark,

What a coincidence. Just wrestling with this myself yesterday. I found DB2 Connect 5.2 client works fine with msquery (msqry32.exe) connecting to the host, but when using DB2 Connect 7.2 client msquery dumps. This behavior is when MS Office 97 is loaded from a fileserver, and Excel is the front end invoking MSQUERY. [...] 11116 30 36_Re: Remove a column without dropping13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Wed, 25 Jul 2001 10:36:14 -0500478_- Surely they know a lot better than I do of what all needs to be done but I'd think that something like the following would be feasible and least disruptive : * When the DROP column command is issued, the column is just marked as unusable (invalidating packages / plans, dropping indexes) while physically remaining in the tablespace ( a la COBOL FILLER ). * During the next reorg, it's finally removed taking care of all the peices. Never mind, it's just a wish Mohammad [...] 11147 42 0_16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Wed, 25 Jul 2001 09:02:15 -0700417_iso-8859-1 Show us your LOAD command. You probably need to modify the field definition for the DEC field in the LOAD command to indicate only DEC(15,0) or DECIMAL EXTERNAL or DECIMAL ZONED ... depending on what is being passed by the program in the file.

-----Original Message----- From: jennifer jennifer [mailto:jenni_jeni@HOTMAIL.COM] Sent: Wednesday, July 25, 2001 2:47 AM To: DB2-L@RYCI.COM Subject: [...] 11190 42 36_Re: Remove a column without dropping64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Wed, 25 Jul 2001 11:17:56 -0600459_ISO-8859-1 With CDB/Autoconvert, a schema change tool, while you cannot drop the column today, you could set it to something insignificant like CHAR(1) and set it to NULL without a drop and recreate of the table.

See http://www.cdbsoftware.com/pdf/cdb_auto_convert.pdf



-----Original Message----- From: Aditya.Narra@NYCBOE.NYCENET.ED Sent: Tuesday, July 24, 2001 10:55 AM To: DB2-L@RYCI.COM Subject: Remove a column without dropping [...] 11233 38 51_Re: DB2 Connect PE V7.1 & PowerBuilder 7.0 question12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 25 Jul 2001 11:48:49 -0500506_us-ascii Got it!

Our sysprog found that the problem was in the DB2CLI.ini file in the SQLLIB folder.

When I installed DB2 Connect V7.1 over Connect v6.1, apparantly the following line resulted:

SCHEMALIST="CURRENT SQLID,'DBAPROD','SYSIBM'"

We corrected this to read:

SCHEMALIST="'DBAPROD','SYSIBM'"

And now things are fine. I have my PB table names and all the other nice features of DB2 Connect V7.1 that I can get without running WLM on the mainframe side. [...] 11272 31 43_Re: 00C200E1 Reason Code on Imagecopy Abend0_20_Jones.H@GRAINGER.COM31_Wed, 25 Jul 2001 12:26:00 -0500412_- Daniel, You are right. The DASD guys were doing volume backups during our batch window which included these volumes. Not a DB2 problem.

Hayden

- - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - Date: Tue, 24 Jul 2001 14:15:01 -0700 From: Daniel Turner Subject: Re: 00C200E1 Reason Code on Imagecopy Abend MIME-Version: 1.0 Content-Type: text/plain [...] 11304 21 45_DSNV086E DB2 Abnormal Termination RC=00E507279_Don Cross20_Don.Cross@TC.FAA.GOV31_Wed, 25 Jul 2001 13:43:12 -0400322_us-ascii We are running os/390 2.9 and DB2 v6. We have applied all the PTFs that apply to the above message. We are trying to load SMF data via tape into DB2 so that Performance Reporter can use it for accounting reports. We get another related message to the above

IEC161I 201-061,DSNDBM1,DSNDBM1,SYS00079,,, [...] 11326 20 4_LDAP17_John Breidenstine31_JBreidenstine@LEGIS.STATE.PA.US31_Wed, 25 Jul 2001 14:51:21 -0400484_iso-8859-1 Hello Listserve,

We have DB2 V6.1 FP8 on AIX.

We would like to enable it for use with LDAP. If anyone out there has done this would you please give me an idea of what we need to do?

Thanks, John L. Breidenstine

================================================ 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. 11347 34 19_SELECT - Joins HELP11_Rosie Porco17_rporco@UOTTAWA.CA31_Wed, 25 Jul 2001 15:12:46 -0400400_us-ascii Hi,

I am trying to get the following Sql to work but am having great dificulty. from each of the joined tables I only want the 1 row that a maximum value in the attribute. Can you help me out please . Thank-you

SELECT P_ID, MAX(S_CD) FROM T1 LEFT OUTER JOIN (( SELECT MAX(H_YR) FROM T2 ) ON T1.P_ID = T2.P_ID INNER JOIN ( SELECT MAX(T_CD) FROM T3 ) ON T2.A_ID = T3.A_ID ) [...] 11382 34 12_Re: cics/db211_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 25 Jul 2001 14:23:43 -0500578_- Yes.



>From: ´ö˝ŇŞř >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: cics/db2 >Date: Fri, 8 Jun 2001 22:56:30 -0500 > >Since db2 does not allow commits in cics...(or maybe other way >around)... >does cics syncpoint force a commit in db2???? > >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. [...] 11417 57 69_Re: Partitioning parent/child should parts & key values be the same ?11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 25 Jul 2001 14:37:30 -0500318_- Robert,

While this is not a requirement, I have always used it as a good starting position. Why are we partitioning to beging with? Parallelism and Partition Independence ought to be 2 key factors. If so, having the same key ranges clearly provides the most benefit. There will be exceptions, of course. [...] 11475 13 13_PolarSentinal12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 25 Jul 2001 14:52:00 -0400367_- Anyone using Polar Sentinel from PolarSoft Limited to monitor DB2 Connect? If so, Please comment.

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. 11489 35 12_Re: cics/db216_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 25 Jul 2001 16:02:13 -0400636_big5 YES.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: A000896@MS.SKH.ORG.TW [mailto:A000896@MS.SKH.ORG.TW] Sent: Friday, June 08, 2001 11:57 PM To: DB2-L@RYCI.COM Subject: cics/db2



Since db2 does not allow commits in cics...(or maybe other way around)... does cics syncpoint force a commit in db2????

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. [...] 11525 184 29_Three Data Sharing Questions?10_Lee Mandel16_DBMSUser@AOL.COM29_Wed, 25 Jul 2001 16:08:32 EDT466_UTF-8 Hi All, I have THREE questions regarding using Data Sharing. Question 1: Using the example below that I got out of the IBM book, because the DB2 I am on is not using Data Sharing Yet. To create the ENDLRSN for the restart, would I subtract 1 from the lowest LRSN A974FBBFD37C? Which would make my ENDLRSN=A974FBBFD37B It appears that is what the manual is telling me. I guess I do not understand why the LOWEST LRSN is being used rather the HIGHEST LRSN. [...] 11710 96 12_Re: cics/db213_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Wed, 25 Jul 2001 15:34:41 -0500867_iso-8859-1 EXEC CICS SYNCPOINT END-EXEC







Suresh Sane To: DB2-L@RYCI.COM Subject: Re: cics/db2 Sent by: DB2 Data Base Discussion List



07/25/2001 02:23 PM Please respond to DB2 Data Base Discussion List











Yes.



>From: ´ö˝ŇŞř >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: cics/db2 >Date: Fri, 8 Jun 2001 22:56:30 -0500 > >Since db2 does not allow commits in cics...(or maybe other way >around)... >does cics syncpoint force a commit in db2???? > >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 [...] 11807 162 49_Re: DSNV086E DB2 Abnormal Termination RC=00E5072713_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 25 Jul 2001 13:45:14 -0700612_iso-8859-1 The message gave return code 201, which has this explanation: . Open detected an Interrupt Recognition condition while opening a data set for input processing. . System Action: Open processing continues. The ACB error flags are set to 76. . Programmer Response: You may continue processing the data set, however, a critical operation was interrupted on this data set and the operation did not complete. Erroneous results could occur. You may wish to run the access method services DIAGNOSE command against the Catalog and VVDS entries associated with this data set to identify possible problems. [...] 11970 148 33_Re: Three Data Sharing Questions?10_Tom Taylor17_ttaylor@CHUBB.COM31_Wed, 25 Jul 2001 16:52:14 -0400724_iso-8859-1 Lee Let's assume you have 2 members of a DS group.

1)You should use the lowest endlrsn OF THE 2 MEMBERS and subtract 1. This will be used by both members in the conditional restart record. This provides a point in time that both members are aware of.

2) here is an example of a log print from 2 members -ACTIVE LOG COPY 1 DATA SETS 0 START RBA/LRSN/TIME END RBA/LRSN/TIME -------------------- -------------------- 0 02D0039BA000 02D009BDEFFF B402DA34B08F B40325D79017 2000.129 15:45:01.1 2000.129 21:23:24.5 0465F471B000 04660A6AAFFF B62FABC65FA1 B62FCA51FFE8 2001.206 12:43:05.9 2001.206 14:59:45.4 1 04660A6AB000 04662063AFFF B62FCA51FFE9 ............ 2001.206 14:59:45.4 ........ .......... [...] 12119 175 49_Re: DSNV086E DB2 Abnormal Termination RC=00E5072714_Crichton, Jean21_jcrichton@FEDDATA.COM31_Wed, 25 Jul 2001 17:00:53 -0400603_iso-8859-1 Don,

The error messages don't indicate that your problem is really related to loading from tape. The RC=00E50727 indicates that the subsystem was in functional recovery processing when a secondary failure occurred, causing the abnormal termination. What you need to do is find out what was happening in DB2 prior to the 00E50727. Run an EREP on SYS1.LOGREC to get the time interval prior to and up to the subsystem termination. Search for errors in DB2 prior to the DSNV086E and look up the reason codes, and use those as search arguments for the APAR database also. If there was [...] 12295 29 29_HELP!! with Stored procedures10_Azam Mirza18_azam00@HOTMAIL.COM31_Wed, 25 Jul 2001 15:54:46 -0500386_- Hi,

I am trying the create SQL stored procedures in Db2 UDB 7.1 on NT. I am having the following problems: 1)How can I return a result set from a stored procedure (returning a cursor) ? 3) Can I implement Multiple cursor returns (multiple result sets) from one stored procedure to an application ? 4) How does the application read these values ? It is a java application. [...] 12325 25 26_DB2 Connect and Top-Secret19_Jack Scharnberg Jr.18_jps460@HOTMAIL.COM31_Wed, 25 Jul 2001 16:02:53 -0500329_- Hi All,

Has anyone on this list had experience using DB2 Connect in a OS/390 Environment with OS/390 DB2 ver. 6 that has Top-SECRET (CA) to manage DB2 security? We are encountering a -440 SQLCODE when trying to call a stored procedure (COBOL) from a PowerBuilder (ver. 6.5) app using DB2 Connect and OS/390 DB2 V6. [...] 12351 51 30_Re: DB2 Connect and Top-Secret17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Wed, 25 Jul 2001 16:26:33 -0500425_iso-8859-1 I've had a little experience with this and binds (program calling a stored procedure). Look at the -440 (SQL messages), it lists several things that can cause this, mine was that I had to include the "path" option on my bind of the calling program - the stored procedure (unqualified sql) I was calling was in a different schema. I know I am not directly answering your question, but I feel the manuals will. [...] 12403 34 30_Re: DB2 Connect and Top-Secret12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 25 Jul 2001 16:29:00 -0400599_- Run a PM audit trace and look for AUTH FAILED. This also should give you the 2ndary AUTHs belonging to the Primary ID. We use the PM online monitor---6. Collect Report Data. Then run a PM reporting job on the resulting collected data.

>>> DB2-L@RYCI.COM@inter2 07/25/01 04:02PM >>> Hi All,

Has anyone on this list had experience using DB2 Connect in a OS/390 Environment with OS/390 DB2 ver. 6 that has Top-SECRET (CA) to manage DB2 security? We are encountering a -440 SQLCODE when trying to call a stored procedure (COBOL) from a PowerBuilder (ver. 6.5) app using DB2 Connect [...] 12438 28 32_Need HELP with Stored procedures10_Azam Mirza18_azam00@HOTMAIL.COM31_Wed, 25 Jul 2001 16:47:12 -0500407_- All, I am trying the create SQL stored procedures in Db2 UDB 7.1 on windowsNT. I need some information before I create stored procedures. My questions are:

1)How can I return a result set(a cursor) from a stored procedure 2) How can I implement Multiple cursor returns (multiple result sets) from one stored procedure? 3) How does the application read these values ? It is a java application. [...] 12467 51 33_Re: Three Data Sharing Questions?20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 25 Jul 2001 17:57:26 EDT376_US-ASCII Tom, Thanks for your quick response and for the example you gave me. That is what I needed a good example. Using your example: Would my ENDLRSN=B62EF3D513C8 after I subtract 1 from the lowest? Also do the DSNJU004 sysprint have the ENDLRSN after the RBA in the ARCHIVE section as it do in the ACTIVE section? I do not have a Data Sharing environment to list it. [...] 12519 31 32_Help with stored procs needed !!10_Azam Mirza18_azam00@HOTMAIL.COM31_Wed, 25 Jul 2001 17:17:54 -0500523_- I apologise if you all are getting this message twice, I had some technical problems trying to post the msg.

All, I am trying the create SQL stored procedures in Db2 UDB 7.1 on windowsNT. I need some information before I create stored procedures. My questions are:

1)How can I return a result set(a cursor) from a stored procedure 2) How can I implement Multiple cursor returns (multiple result sets) from one stored procedure? 3) How does the application read these values ? It is a java application. [...] 12551 40 20_Re: db2 data sharing15_Philippe Herman20_pherman@LANDMARK.COM31_Wed, 25 Jul 2001 18:57:08 -0400329_us-ascii Hi Tom,

Having two member of the same data sharing group in the same patition does not really make sense but is theoriticaly possible (I did it !).

But the data sharing concept is basicaly having multiple DB2 ssid running on different partitions but sharing the same data.

Just a few toughts : [...] 12592 25 29_Re: DB2 Developer's Guide, V414_Charles Heinze22_Programmer1969@AOL.COM29_Wed, 25 Jul 2001 19:57:55 EDT51_US-ASCII Amazon has a used copy for less than that. 12618 22 12_SQL Question12_John Piccoli16_jpiccoli@LOOK.CA31_Wed, 25 Jul 2001 21:19:52 -0400475_us-ascii Is there a way to make the following predicate functional under DB2 for OS/390 V5.1:

where substr(b.conv_dt,7,2) <= (substr(digits(a.mat_dt),7,2) + 3)

b.conv_dt is char(8) a.mat_dt is decimal(8)

John CDS

================================================ 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. 12641 51 17_Re: SQL CODE -9199_Eric Kwai18_Eric_Kwai@DTCC.COM31_Wed, 25 Jul 2001 20:55:48 -0500542_- Sai: I got -919 before going from the client to the host before. The situation was the host DB2 SP abended and somehow it can not rollback ( I forgot why, commit_on_return=y?) . Therefore, the thread was still open in a must rollback stage (The client program was not coded correctly to release the connection in this case.) and the next new transaction connect to the same thread and got the -919. May not be what you are looking for, I'll suggest a sqltrace on the host and turn on the event monitor at the client server to find out [...] 12693 66 16_Re: SQL Question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 25 Jul 2001 23:25:04 -0500620_us-ascii John,

If these are date fields stored as CHAR and DEC, then what you are trying to do gets a little more difficult.

Otherwise, it is simply:

where substr(b.conv_dt,7,2) <= substr(digits(decimal(a.mat_dt + 3,8)),7,2)

Note: I've added the decimal(8) to ensure the datatype does not promote to decimal(9) due to the addition.

If they are dates, you cannot add 3 to a decimal representation of a date, as the 31st day will become the 34th. If they are dates, then I would try converting these to a date datatype within the SQL, then adding 3 days, and finally using the days [...] 12760 88 23_Re: SELECT - Joins HELP13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 25 Jul 2001 23:25:22 -0500486_us-ascii Rosie,

Logically is this what you are after?

SELECT A.P_ID, MAX(A.MAX_S_CD), MAX(D.MAX_H_YR), MAX(D.MAX_T_CD) FROM (SELECT P_ID, MAX(S_CD) AS MAX_S_CD FROM T1 GROUP BY P_ID) AS A LEFT OUTER JOIN ( SELECT B.P_ID, B.A_ID, MAX_H_YR, MAX_T_CD FROM ( SELECT P_ID, A_ID, MAX(H_YR) AS MAX_H_YR FROM T2 GROUP BY P_ID, A_ID) AS B INNER JOIN ( SELECT A_ID, MAX(T_CD) AS MAX_T_CD FROM T3 GROUP BY A_ID) AS C ON B.A_ID = C.A_ID ) AS D ON A.P_ID = D.P_ID GROUP BY A.P_ID [...] 12849 16 47_Frank Yao/CACI/Prudential is out of the office.9_Frank Yao24_frank.yao@PRUDENTIAL.COM31_Thu, 26 Jul 2001 01:01:36 -0400436_us-ascii I will be out of the office starting 07/26/2001 and will not return until 07/30/2001.

If this is an emergency, please contact Eileen Bennett at 716-6451 or Pat Kelly at 716-1559.

================================================ 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. 12866 26 20_Triggers and Explain10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 26 Jul 2001 15:26:26 +1000520_us-ascii Hi,

Is there a way to do an explain on trigger packages ? My problem is to determine the accesspath for some queries within triggers. I notice that the default is EXPLAIN(NO).

TIA.

Cheers, Kals



---------------- Powered by telstra.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. 12893 14 57_Re: DB2-L Digest - 25 Jul 2001 to 26 Jul 2001 (#2001-210)37_L-Soft list server at RYCI.COM (1.8d)17_LISTSERV@RYCI.COM31_Thu, 26 Jul 2001 01:17:59 -0500363_- -> //STEPLIB DD DISP=SHR,DSN=QSM.WRK020.LOADLIB

Missing argument on DD card.

Job "DB2-L" has been purged.

================================================ 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. 12908 63 57_Re: DB2-L Digest - 25 Jul 2001 to 26 Jul 2001 (#2001-210)15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Thu, 26 Jul 2001 09:17:43 +0200540_iso-8859-1 Hello all,

What's happening with the DB2-L? Do you get this messages as well?

Kind regards,

Jaap Slot

Data Service Center Rabobank ICT

tel: 030 215 2220 fax: 030 215 3003 mob: 06 5374 0167 mailto:J.P.Slot@rf.rabobank.nl











-----Original Message----- From: L-Soft list server at RYCI.COM (1.8d) [mailto:LISTSERV@RYCI.COM] Sent: Thursday, July 26, 2001 8:18 AM To: DB2-L@RYCI.COM Subject: Re: DB2-L Digest - 25 Jul 2001 to 26 Jul 2001 (#2001-210) [...] 12972 68 17_Re: PolarSentinal15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Thu, 26 Jul 2001 09:25:04 +0200357_iso-8859-1 Bob,

I'm very interested too. I understand it's part of the BMC Patrol Family now, but I don't know of anyone actually using it. If you happen to find another piece of software which does the same would you please share it with us?



Kind regards,

Jaap Slot

Data Service Center Rabobank ICT The Netherlands [...] 13041 56 24_Re: Triggers and Explain10_CEI, Bruno20_Bruno.CEI@SEMA.CO.UK31_Thu, 26 Jul 2001 09:55:38 +0100467_iso-8859-1 I think that you can rebind the package changing from the default to EXPLAIN(YES).

Bruno

-----Original Message----- From: teldb2kals [mailto:teldb2kals@TELSTRA.COM] Sent: 26 July 2001 06:26 To: DB2-L@RYCI.COM Subject: Triggers and Explain



Hi,

Is there a way to do an explain on trigger packages ? My problem is to determine the accesspath for some queries within triggers. I notice that the default is EXPLAIN(NO). [...] 13098 28 42_Re: Advise needed on DB2 and RACF security13_Hanne Lyssand10_han@VPS.NO31_Thu, 26 Jul 2001 11:08:19 +0200280_us-ascii I am not an expert in this field, and I have never set up the racf definitions. I have just done some grants in DB2 to the racf groups. As I have understood it, you have to give the RACF groups the nessesery privliges in DB2 and so connect users to the racf groups. [...] 13127 53 24_Re: Triggers and Explain10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 26 Jul 2001 19:27:11 +1000572_us-ascii Bruno,

I understand that we can't bindcopy/rebind trigger packages. (I verified it as well).

Cheers, Kals



-----Original Message----- From: CEI, Bruno [SMTP:Bruno.CEI@SEMA.CO.UK] Sent: Thursday, July 26, 2001 6:56 PM To: DB2-L@RYCI.COM Subject: Re: Triggers and Explain

I think that you can rebind the package changing from the default to EXPLAIN(YES).

Bruno

-----Original Message----- From: teldb2kals [mailto:teldb2kals@TELSTRA.COM] Sent: 26 July 2001 06:26 To: DB2-L@RYCI.COM Subject: Triggers and Explain [...] 13181 63 13_Re: DB2 & SMS16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Thu, 26 Jul 2001 11:05:11 +0100442_UTF-8

hey list,

am I the only one who gets messages from the list like this? from taiwan I mean, with no indication of who wrote them, and with loads of messages missing!

Aurora













湯課長 cc: (bcc: Aurora E DellAnno/CAM/Candle) Subject: Re: DB2 & SMS 09/06/2001 04:56 Please respond to DB2 Data Base Discussion List [...] 13245 103 13_Re: DB2 & SMS14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 26 Jul 2001 12:17:32 +0200569_iso-8859-1 Hi,

no, you're not the only one, this morning I received about 50 mails of that kind. I also received a couple of messages mentionen by Jaap earlier on today.

Ruediger

Aurora Dell'Anno schrieb: > > hey list, > > am I the only one who gets messages from the list like this? from taiwan I > mean, with no indication of who wrote them, and with loads of messages > missing! > > Aurora > > > 湯課長 > KH.ORG.TW> cc: (bcc: Aurora E DellAnno/CAM/Candle) > Subject: Re: DB2 & SMS > 09/06/2001 > 04:56 [...] 13349 24 28_Monitoring DB2 on NT servers11_Mohamed Beg19_mohamedb@ABSA.CO.ZA31_Thu, 26 Jul 2001 11:53:24 +0200368_iso-8859-1 Hi.

I am looking for suggestions with regards to monitoring DB2 on an NT platform. I am faced with the following scenario. We want to install DB2 on a 100 servers. These servers are critical to business.

Are there any options besides installing a third party product on the servers. I would really appreciate any comments or suggestions. [...] 13374 17 20_DB2 6.1 OS/390 CLOBs9_Ed Lipson30_Ed_Lipson@LNOTES5.BANKOFNY.COM31_Thu, 26 Jul 2001 06:51:41 -0400420_us-ascii Is anyone using this column data type, over and under 32K length? Any experience with utilities (copy, recover, load, unload, reorg) you care to share?

Thanks, Ed

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 13392 130 24_Re: Triggers and Explain14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 26 Jul 2001 12:00:21 +0100599_iso-8859-1 You can REBIND a trigger package with EXPLAIN(YES)

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



-----Original Message----- From: teldb2kals [mailto:teldb2kals@TELSTRA.COM] Sent: 26 July 2001 06:26 To: DB2-L@RYCI.COM Subject: [DB2-L] Triggers and Explain



Hi,

Is there a way to do an explain on trigger packages ? My problem is to determine the accesspath for some queries within triggers. I notice that the default is EXPLAIN(NO). [...] 13523 226 24_Re: Triggers and Explain14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 26 Jul 2001 12:09:53 +0100633_iso-8859-1 Assuming you are on OS/390 DB2, then you CAN rebind a trigger package

But the command and utility reference manual also says

"To build a package without producing error messages, the package owner must have authorization to execute all SQL statements that are embedded in the package for REBIND TRIGGER PACKAGE. To execute this subcommand, the privilege set of the process must include one of the following authorities: v Ownership of the trigger package v BIND privilege on the trigger package v BINDAGENT privilege from the owner of the trigger package v PACKADM authority on the collection or on all [...] 13750 72 37_User Defined Function program display15_Melvin Demmicks25_melvin_demmicks@YAHOO.COM31_Thu, 26 Jul 2001 04:32:22 -0700564_us-ascii Good morning friends,

I am designing a utility for use on Os/390 which I want to provide for my developers to use to query information about the User Defined Functions we are starting to build. I want to display the UDFs in a list from which the developer or DBA can select them. I am of course planning to show Function Name, and Schema. Since, unlike other DB2 objects, Functions are not unique with Name and Schema, I also want to show information which will identify the function most meaningfully and of course uniquely to the developer. [...] 13823 20 31_SAP with DB2 on OS/390 eg. z/OS13_Thomas Schulz20_thomas.schulz@SVI.DE31_Thu, 26 Jul 2001 06:22:17 -0500505_- Hi all

The company I work for considers using SAP with DB2 on Os/390 Mainframe. We have no experience about SAP and DB2 working together.

Where can I find some information about this topic.

Thanks to all.

Thomas Schulz, DBA, SVI GmbH

================================================ 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. 13844 22 28_DB2 SQL performance analyzer12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Thu, 26 Jul 2001 07:59:25 -0400500_us-ascii As anyone out there used DB2 SQL Performance Analyzer in comparison to CA Plan Analyzer and if so what did you think?



Thanks.. Stan Goodwin DECC MBG DB2 Support

Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335

================================================ 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. 13867 41 33_Re: Need Help ASAP, DB2 7.1 on NT10_John Lantz23_john.lantz@ZURICHNA.COM31_Thu, 26 Jul 2001 07:04:20 -0500569_- On Wed, 25 Jul 2001 15:39:52 +0700, Endy Lambey wrote:

>Guys, > >We're facing a problem on our DB2 7.1 running on an NT box. >We keep facing 'System is Running on Low Virtual Memory' >After checking the Task Manager, we found that there were so many 'db2bp' application running, which were using so much amount of the memory. >How can we control 'db2bp'? What 'db2bp' really does? > >FYI, we only use the NT box as a 'DB2 Warehouse Control Server', which connect to a Database on AIX box. There is no active database on the NT box, [...] 13909 27 35_Re: SAP with DB2 on OS/390 eg. z/OS12_Paul Packham26_paul.packham@CONSIGNIA.COM31_Thu, 26 Jul 2001 13:05:44 +0000633_us-ascii Thomas,

There are sone very good IBM Redbooks on this subject, go to http://publib-b.boulder.ibm.com/Redbooks.nsf/Portals

Also you can find the SAP R/3 on DB2 for OS/390: Planning Guides at http://www-1.ibm.com/servers/s390/os390/bkserv/latest/sapr3.html

Regards, Paul

This email and any attachments are confidential and intended for the addressee only. If you are not the named recipient, you must not use, disclose, reproduce, copy or distribute the contents of this communication. If you have received this in error, please contact the sender and then delete this email from your system. [...] 13937 15 26_What lock during updation.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Thu, 26 Jul 2001 07:18:25 -0500394_- Hi,

I would like to know the type of lock DB2 puts on a page where rows are geting updated. Is it EXCLUSIVE lock or UPDATE lock.

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. 13953 26 43_Data to be converted in Uppercase in DB2 V50_24_ujjwal@LOT.TATASTEEL.COM31_Thu, 26 Jul 2001 18:16:58 +0530542_us-ascii I apologise if you all are getting this message twice, I did not have any response the last time I had send.Could someone clarify ?

ALL, I have a case regarding case where I got data from Lotus Notes into DB2 thru Lotus Pump .Now most of the data pumped into DB2 has lowercase .I have tried to Unload the data and convert all the data to uppercase in the sequential file and then Load it again.It worked for many tables but for some it did not work .It was giving a message Data Conversion error for a particular numeric [...] 13980 24 21_DB2 Stored Procedures13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Thu, 26 Jul 2001 07:52:02 -0500274_- We have a programmer that is trying to write a DB2 Stored Procedure. It works fine when called from a batch program or from CLI. She wants it to work in VB. She is getting a -440.

We have read thru four different red books, but appear to be missing something. [...] 14005 36 30_Re: What lock during updation.16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 26 Jul 2001 18:33:08 +0530612_- It depends what kind of SQL is coded. If it is FOR UPDATE OF then U lock is taken during open/fetch and then converted to X during update otherwise X during update is taken.

HTH Regards Sanjeev

> -----Original Message----- > From: Rajendra Deshpande [SMTP:rajendra_deshpande@HOTMAIL.COM] > Sent: Thursday, July 26, 2001 5:48 PM > To: DB2-L@RYCI.COM > Subject: What lock during updation. > > Hi, > > I would like to know the type of lock DB2 puts on a page where rows are > geting updated. Is it EXCLUSIVE lock or UPDATE lock. > > thanks. > > ================================================ [...] 14042 16 30_Re: What lock during updation.15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Thu, 26 Jul 2001 15:07:35 +0200519_us-ascii Exclusive (X) locks are held when updating, ( IX for Intent exclusive).

Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be those of Sanlam, to whom no liability shall attach whatsoever.

================================================ 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. 14059 14 37_Dropping unique index on primary key.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Thu, 26 Jul 2001 08:47:45 -0500413_- Hi,

Does DB2 allow dropping the unique index on primary key. If so, what are the consequences. I guess duplicate records would then get inserted.What say you all.

================================================ 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. 14074 110 31_FW: DB2 V7.2 NULL w/ C Compiler22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Thu, 26 Jul 2001 06:52:31 -0700402_- Hi Listers,

This is a repost from 2 days ago.. We have not gotten any response's on this problem and it seems a little strange that no one has run into this problem. Any ideas would be appreciated.. TIA.

Marty Killen SR DB2 DBA CNF INC. 503-450-2681 e-mail- killen.martin@cnf.com



"Kind words can be short and easy, but their echoes are truly endless" Mother Theresa [...] 14185 31 43_Re: SECQTY and multiple extents - fixed (?)11_DBA Support21_dbasupport@WILLIS.COM31_Thu, 26 Jul 2001 14:53:15 +0100337_us-ascii Thanks to all of you who replied to to my problem about tablespaces going into many small extents.

It now appears that the problem lies with CA's Fast Load and/or Rapid Reorg. There is a fix for this (APAR LO85830, PTF UCMC087) which is on the P99E tape but not the P99D tape we have got. CA are sending us the fix. [...] 14217 20 22_Db2/Sybase comaparison14_subrata mondal25_subratamondal@HOTMAIL.COM31_Thu, 26 Jul 2001 13:59:33 +0000 14238 29 15_DB2 OLAP Server15_Jardim, Luciano18_LJardim@BANDAG.COM31_Thu, 26 Jul 2001 08:57:21 -0500277_iso-8859-1 We'd like to use Windows NT DB2 OLAP Server V7 to implement our data warehouse and OLAP projects but I am not sure how reliable and effective this tool is. Our data warehouse should reach 100s of Gigabytes in size, most of our data is in the DB2 V6 for OS/390. [...] 14268 23 19_DB2 Connect and CAE16_Martin Berchtold31_Martin.Berchtold@SYSTEMATICS.DE31_Thu, 26 Jul 2001 08:54:03 -0500301_- Hi List,

We would like to implement a Linux system in a VM environment. In the Linux we will install DB2 UDB V7.2. We will access the data via NT/2000 and / or a web server. What kind of connector software is nesessary to make the architectur and the costs as simple(cheap) as possible. [...] 14292 50 30_Re: What lock during updation.14_"Sajad Javid".23_sajad@CHENNAI.TCS.CO.IN31_Thu, 26 Jul 2001 19:19:32 +0530460_us-ascii Hi, During updation the lock will be EXCLUSIVE. Even if there was an UPDATE lock on the table/page the lock gets escalated to EXCLUSIVE during update.

Regards Sajad





Rajendra Deshpande cc: Sent by: DB2 Data Base Subject: What lock during updation. Discussion List



26/07/2001 05:48 PM Please respond to DB2 Data Base Discussion List [...] 14343 52 41_Re: Dropping unique index on primary key.16_Michael McKinney16_mmckinne@CSC.COM31_Thu, 26 Jul 2001 10:09:54 -0400323_us-ascii DB2 does allow you to drop the unique index on a primary key, but your table will be unusable. When you drop the index, DB2 places the tablespace in an incomplete status. It remains in that status until you recreate the index or drop the primary key.

So you have to have an index for your primary key. [...] 14396 21 40_SQLstate error HY010 - OS/390 DB2 access13_Jim McDonnell23_jmcdonnell@PROMENIX.COM31_Thu, 26 Jul 2001 09:12:39 -0500468_- I am accessing an OS/390 DB2 database table from NT using MQSeries. I am using select statements to simply request data - no insert or update. Regardless of the select statement I use, the first 2 records (requests) always work properly. The 3rd record (request) and all subsequent records receive the following error: SQLstate HY010, Native Error Code -99999, Function Sequence Error. I receive the error whether I send the requests individually or as a file. [...] 14418 35 41_Re: Dropping unique index on primary key.16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 26 Jul 2001 20:03:52 +0530681_- If unique key/primary key is defined then dropping the index will mark the table definition as incomplete. If primary/unique key is not defined then dropping the unique index will not enforce the uniqueness.

HTH Regards Sanjeev

> -----Original Message----- > From: Rajendra Deshpande [SMTP:rajendra_deshpande@HOTMAIL.COM] > Sent: Thursday, July 26, 2001 7:18 PM > To: DB2-L@RYCI.COM > Subject: Dropping unique index on primary key. > > Hi, > > Does DB2 allow dropping the unique index on primary key. If so, what are > the consequences. I guess duplicate records would then get inserted.What > say you all. > > ================================================ [...] 14454 37 41_Re: Dropping unique index on primary key.13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 26 Jul 2001 10:32:05 -0400378_iso-8859-1 Hi Rajendra, Yes, you can drop the primary key in DB2 -- at least on OS/390. However, when you do, you get a +625 Sqlcode and the warning that the table has been marked incomplete and the table is unavailable for any DML activity until you remedy the situation. Your alternatives include: 1 Re-creating the primary key or B alter table xxxxxxx drop primary key. [...] 14492 27 27_SQL Stored procedure -HELP!10_Azam Mirza18_azam00@HOTMAIL.COM31_Thu, 26 Jul 2001 09:22:32 -0500332_- Hi, I need some information about creating stored procs on NT. My questions are:

1)How can I return a result set(a cursor) from a stored procedure 2) How can I implement Multiple cursor returns (multiple result sets) from one stored procedure? 3) How does the application read these values ? It is a java application. [...] 14520 99 31_FW: DB2 V7.2 NULL w/ C Compiler22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Thu, 26 Jul 2001 07:50:36 -0700559_- > -----Original Message----- > From: Ohling, Tim R - CNF [SMTP:Ohling.Tim@CNF.COM] > Sent: Monday, July 23, 2001 4:24 PM > To: DB2-L@RYCI.COM > Subject: DB2 V7.2 NULL w/ C Compiler We are re-posting this hoping that someone has run into this and missed the message the first time. It seems like someone would have to have run into this problem if they are running under a similiar environment. We are not sure if we are missing a flag, and environment variable or what. Why would the DB2 pre-compiler pass back NULL in V7 and not in V6? Any help would [...] 14620 77 41_Re: Dropping unique index on primary key.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Thu, 26 Jul 2001 20:23:28 +0530633_- Hi Mike,

Thank a lot for resolving my doubt. Btw, are you a DB2 DBA. Have a nice day.

thanks, Rajendra Deshpande.





>From: Michael McKinney >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Dropping unique index on primary key. >Date: Thu, 26 Jul 2001 10:09:54 -0400 > >DB2 does allow you to drop the unique index on a primary key, but your >table will be unusable. When you drop the index, DB2 places the tablespace >in an incomplete status. It remains in that status until you recreate the >index or drop the primary key. > >So [...] 14698 51 44_Re: SQLstate error HY010 - OS/390 DB2 access13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 26 Jul 2001 10:03:15 -0500564_iso-8859-1 When I have seen this error and it often requires a new connection to resolve the problem. That usually translates into stop and start the application. It seems that something has got so corrupted that subsequent communication to the database fails or the connect has been lost.

For me, it is often bad data. Used to be sending binary zeros to the OS390 (as predicate values in your case), but I have not had that happen recently. I would check the SDSF log or xxxxMSTR, xxxxDBM1 etc logs and see if there is an error at about the same time [...] 14750 36 22_Hardcoded Owner in EJB8_Gary Rue25_Gary.Rue@MAIL.STATE.KY.US31_Thu, 26 Jul 2001 11:10:22 -0400508_iso-8859-1 Our mode of operation with DB2 on OS/390 has always been to change the owner of a schema in the different environments, omitting the owner in the code and using plans and packages to effect the appropriate owner at execution time.

I'm being told by the programming staff that the owner must be hardcoded within EJB SQL code. This means that as the app moves through the different development and testing environments, the targeted database and components must all have the same owner. [...] 14787 54 41_Re: Dropping unique index on primary key.13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Thu, 26 Jul 2001 09:11:44 -0600422_- from the os390 v6 manual:

Primary keys are required for referential integrity.

CREATE TABLE doesn't require a PK but if you have one.....

A primary key requires a unique index for a table to be "available". Using the schema processor, the unique index is implicity generated.



ALTER TABLE tabname DROP PRIMARY KEY followed by ALTER TABLE tabname ADD PRIMARY KEY (colname,colname) [...] 14842 40 41_Re: Dropping unique index on primary key.17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Thu, 26 Jul 2001 09:27:31 -0500496_us-ascii it deptends on the platform. In the NT world when you defign the primary key it automaticaly creates a primary key index.. Not sure about 390.







Rajendra Deshpande @RYCI.COM> on 07/26/2001 08:47:45 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Dropping unique index on primary key. [...] 14883 47 25_Re: DB2 Stored Procedures10_Shery Hepp17_schepp@SRPNET.COM31_Thu, 26 Jul 2001 08:13:58 -0700378_iso-8859-1 Shauna- I'm having a similiar problem. I'm told you can have the vb app execute a set current path statement before the call to the sp or another option is to issue the call to the stored proc by qualifying the schema.sp.

The two above solutions won't work for my situation so I haven't actually tested them- but this was what IBM advised for resolution. [...] 14931 78 41_Re: Dropping unique index on primary key.15_Janardhan Ragam16_sragam@YAHOO.COM31_Thu, 26 Jul 2001 08:15:12 -0700559_us-ascii On the unix platform, DB2 will not allow you to drop the index that the primary key is dependent on. You will have to drop the primary key in order to drop the dependent index.

Note: If you create an index (unique or duplicate) first and then create the primary key that exactly matches an index definition, db2 will utilize the existing index for the primary key. You will then not be allowed to drop the index without dropping the primary key. However when you drop the primary key, the index will not be dropped. On the other when you [...] 15010 54 25_Re: DB2 Stored Procedures17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Thu, 26 Jul 2001 10:01:14 -0500592_iso-8859-1 We might be running into this in the future, we will be running WEB type applications (calling DB2 stored procedures) and with DDF you get a plan that is built dynamically I'm guessing (though we haven't gotten this far yet, still trying to get the WLM stored procedure address space(s) going) there is some kind of dynamic package created also, and the calling program has to have execute on the stored procedure. I'll find out if my thoughts are correct sometime in the near future (I'll probably watch the threads when the transactions are running). I've also run into the [...] 15065 69 26_Re: Hardcoded Owner in EJB9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Thu, 26 Jul 2001 16:30:55 +0100554_ISO-8859-1 Gary,

Don't know anything about EJB but suprised it forces an owner id to be coded. What is the reason for this?

Jim.

-----Original Message----- From: Gary Rue [mailto:Gary.Rue@MAIL.STATE.KY.US] Sent: 26 July 2001 16:10 To: DB2-L@RYCI.COM Subject: Hardcoded Owner in EJB



Our mode of operation with DB2 on OS/390 has always been to change the owner of a schema in the different environments, omitting the owner in the code and using plans and packages to effect the appropriate owner at execution time. [...] 15135 147 26_Re: Hardcoded Owner in EJB12_Troy Coleman19_Colematr@MEIJER.COM31_Thu, 26 Jul 2001 11:45:53 -0400568_US-ASCII I don't know EJB but I can tell you a design option that may help. This example is how PeopleSoft changes between environments.

You have a table hard coded with the owner name. Like : PS.PSDBOWNER When the user sign's a logical database name used. The first thing the application does is read PS.PSDBOWNER looking for the given database name. Once it is found the application table owner is returned. If the user signing in is not that owner then a SET CURRENT SQLID is performed to the table owner. This means that the common id you sign in with [...] 15283 139 37_Re: Partition independence - Or Not !13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Thu, 26 Jul 2001 08:46:33 -0700568_iso-8859-1 OK, so no one took a stab at it and I am trying. Last I knew, If DB2 must access the nonpartitioning index to process SQL statements, it tries to claim the entire nonpartitioning index. If it cannot get a claim on the entire nonpartitioning index (perhaps because of a drain or an exception state on one or more of the logical partitions), DB2 claims just the logical partitions that it needs to process the SQL. What this means is that the order of events can lead to different activities being allowed to complete. For example, if an SQL application [...] 15423 62 26_Re: Hardcoded Owner in EJB12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 26 Jul 2001 08:47:05 -0700563_us-ascii There is no reason that the owner in the EJB cannot be a parameter that comes from a config file for Websphere. Then it is really easy to move the application from one environment to another just by changing that config parameter. My client is doing this. --- Gary Rue wrote: > Our mode of operation with DB2 on OS/390 has always been to change > the owner > of a schema in the different environments, omitting the owner in the > code > and using plans and packages to effect the appropriate owner at > execution > time. [...] 15486 87 25_Re: DB2 Stored Procedures12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 26 Jul 2001 08:50:18 -0700314_us-ascii Pete, Its much simplier than that. The user coming in from DDF must have execute on the stored procedure. And the stored procedure is a static package just like a standard COBOL bound package.

Lots of the -440s are caused by the application not specifying the correct schema name in the call. [...] 15574 104 31_Re: SQL Stored procedure -HELP!14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Thu, 26 Jul 2001 11:54:45 -0400595_iso-8859-1 Hi Azam,

The following is an example of a SQL SP returning a single ResultSet. One ResultSet corresponds to 1 cursor, so of you have n cursors, change to RESULT SETS n in the CREATE PROCEDURE stmt.

A SQL proc can be easily created, built and registered with DB2 in the Stored Procedure Builder, but you have to make sure you have a C compiler, because the SQL SP is internally converted to C code. Once you have a C compiler in place, make sure you set the path properly. On NT, the path is usually in: \sqllib\function\routine\sr_cpath.bat. [...] 15679 17 73_Re: DB2 OS/390 V6.1: Question on Cursor Declaration and Fetch Sta tements18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Thu, 26 Jul 2001 10:46:12 -0500441_- Hi,

As I know, having fewer host variables than required / truncation of data received in a smaller host variable result in +SQLCODE (<> 100) and flags of related SQLWARNING.

regards.

================================================ 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 20 29_2002 Tech Conference location14_Toppins, Smike21_smike.toppins@GWL.COM31_Thu, 26 Jul 2001 10:13:12 -0600470_- Has the 2002 Tech Conference location been decided yet?



SMike Toppins IBM Certified Solutions Expert, V7.1 DB2 UDB Database Administration for OS/390 and z/OS Great-West Life smike.toppins@gwl.com (303) 737-5094

================================================ 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. 15718 33 34_Disaster Recovery Cat/Dir Recovery10_Lee Mandel16_DBMSUser@AOL.COM29_Thu, 26 Jul 2001 12:19:10 EDT160_US-ASCII Hi All, Do any one recover their Cat/Dir Tablespaces at DR Site using TORBA LOGONLY? Are Forward the only way to recover the CAT/Dir at DR? Thanks, Lee 15752 70 25_Re: DB2 Stored Procedures15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Thu, 26 Jul 2001 12:23:13 -0400443_iso-8859-1 There is some environment variable setting in DB2 connect where you can specify the PATH. Some one had send this earlier. Or you can re-bind the DB2 connect package which execute the db2 stored procedure with PATH you want.

Thanks..sibi

-----Original Message----- From: Okronglis, Pete M [mailto:pete.okronglis@NWA.COM] Sent: Thursday, July 26, 2001 10:01 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Stored Procedures [...] 15823 36 33_Re: 2002 Tech Conference location12_Troy Coleman19_Colematr@MEIJER.COM31_Thu, 26 Jul 2001 12:27:00 -0400715_iso-8859-1 Yes, DB2 & Business Intelligence Technical Conference September 9-12, 2002 Anaheim, CA



Try this URL: http://www-3.ibm.com/services/learning/conf/futureconf.html

>>> smike.toppins@GWL.COM 07/26/01 12:13PM >>> Has the 2002 Tech Conference location been decided yet?



SMike Toppins IBM Certified Solutions Expert, V7.1 DB2 UDB Database Administration for OS/390 and z/OS Great-West Life smike.toppins@gwl.com (303) 737-5094

================================================ 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. [...] 15860 76 33_Re: Three Data Sharing Questions?10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 26 Jul 2001 12:46:56 -0400587_iso-8859-1 Lee

I believe that is correect



here is an example of the archive section

ARCHIVE LOG COPY 1 DATA SETS START RBA/LRSN/TIME END RBA/LRSN/TIME DATE LTIME -------------------- -------------------- -------- ----- 043DE95D0000 043DFF55FFFF 2001.143 8:34 B5E024EBD893 B5E03DC121A8 2001.143 06:39:07.8 2001.143 08:30:13.9

043DFF560000 043E154EFFFF 2001.143 11:03 B5E03DC121A9 B5E05EDC0628 2001.143 08:30:13.9 2001.143 10:58:20.4

043E154F0000 043E2B47FFFF 2001.143 13:33 B5E05EDC0629 B5E0809CAAF0 2001.143 10:58:20.4 2001.143 13:29:20.8 [...] 15937 71 28_Re: Timestamp as primary key11_Jon Nolting25_jrn20@DUTS.CCC.AMDAHL.COM31_Thu, 26 Jul 2001 09:51:10 -0700630_us-ascii If those multiple CECs are in a sysplex of any type (basic or parallel), then they will all be connected to an external timer which provides the same time for all CECs in the sysplex.

At 08:42 AM 7/25/01 -0500, you wrote: >In http://bama.ua.edu/cgi-bin/wa?A2=ind0009&L=ibm-main&P=R97311 Greg Dyck >asserted that "[e]very STCK value within a CEC, by architecture, is >guaranteed to be unique." > >So if you use STCK with a varying offset between local and psuedo-GMT >(psuedo because it doesn;t take leap seconds in account), then the STCK >timestamp's should be unique. > >Now if you have multiple CECs ... > [...] 16009 22 62_Anybody using JAVA under CICS and OS/390 for DB2 applications?14_Greg DiGiorgio29_gdigior@CI.NEWPORT-NEWS.VA.US31_Thu, 26 Jul 2001 13:07:23 -0400367_us-ascii So, is anybody using JAVA under CICS and OS/390 in place of command-level COBOL, SAGA-Natural, PL/I for DB2 applications...maybe with IBM's Visual Age?

If so and you are willing to talk with me offline, I'd certainly appreciate a phone number at which I can contact you.

Thanks, Greg DiGiorgio DB Analyst City of Newport News 757-926-3744 [...] 16032 78 25_Re: DB2 Stored Procedures17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Thu, 26 Jul 2001 11:35:00 -0500383_iso-8859-1 I don't know if you've seen my reply on the original on this. We are going to be executing stored procedures from WEB type applications. I was thinking that a dynamic bind would happen and the package created would need execute on the stored proc. I was hoping that the referenced stored procedure would be unqualified. IBM's answer in this case (to me) is a bummer. [...] 16111 26 24_DB2 SQL Stored Procedure10_Azam Mirza18_azam00@HOTMAIL.COM31_Thu, 26 Jul 2001 12:25:50 -0500328_- I need some information about creating stored procs on NT. My questions are:

1)How can I return a result set(a cursor) from a stored procedure 2) How can I implement Multiple cursor returns (multiple result sets) from one stored procedure? 3) How does the application read these values ? It is a java application. [...] 16138 109 25_Re: DB2 Stored Procedures17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Thu, 26 Jul 2001 12:26:11 -0500583_iso-8859-1 What I'm getting at is not having to qualify stored procedures (just like tables). I would think that SQL that is unqualified is more flexible (for an environment) than qualified SQL.

-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Thursday, July 26, 2001 10:50 To: DB2-L@RYCI.COM Subject: Re: DB2 Stored Procedures



Pete, Its much simplier than that. The user coming in from DDF must have execute on the stored procedure. And the stored procedure is a static package just like a standard COBOL bound package. [...] 16248 104 25_Re: DB2 Stored Procedures12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 26 Jul 2001 10:58:27 -0700580_us-ascii What's the big deal with calling the sp's as &VAR.SPname where &Var is a pre-setup schema name? This works well in WEB type applications. Then all sps and calls to DDF are statically bound with the gains in performance and other things from being statically bound. --- "Okronglis, Pete M" wrote: > I don't know if you've seen my reply on the original on this. We are > going to be executing stored procedures from WEB type applications. > I > was thinking that a dynamic bind would happen and the package created > would need execute on the [...] 16353 16 18_Need information !10_Azam Mirza18_azam00@HOTMAIL.COM31_Thu, 26 Jul 2001 13:11:18 -0500257_- All, I need information about returning a result set from a SQL stored procedure. The DB2 UDB is on NT. I want to know how to return a cursor to an application. I would really appreciate if you can explain in detail as I am new with DB2. thanks Azam [...] 16370 141 25_Re: DB2 Stored Procedures12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 26 Jul 2001 11:23:13 -0700467_us-ascii But it just like tables. In existing plans, you specify an owner that specifies the packages (tables, stored procedures). For dynamic SQL you must specify the qualifier of the table.

For a web environment, you're coming in with dynamic SQL, so other than setting the qualifier in DB2 Connect or similar product (or in websphere), you're issuing dynamic SQL, ie its a call sp rather than a select, but its still dynamic. So what's the difference. [...] 16512 45 66_Re: Anybody using JAVA under CICS and OS/390 for DB2 applications?13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Fri, 27 Jul 2001 04:19:51 +1000453_iso-8859-1 Hello Greg,

Yes, I am using Java under CICS/TS 1.3 and CICS/TS 2.1 with DB2 V6 and V7. Also using MQ, Websphere and VisualAge. We have three apps in production.

Greg Farquhar

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Greg DiGiorgio Sent: Friday, July 27, 2001 3:07 AM To: DB2-L@RYCI.COM Subject: Anybody using JAVA under CICS and OS/390 for DB2 applications? [...] 16558 56 31_Re: SQL Stored procedure -HELP!13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Fri, 27 Jul 2001 04:19:55 +1000335_iso-8859-1 AAM,

The JDBC api allows for mrsp's as long as DB2 Connect Client is V6 or above. That is my experience from VisualAge for Java. I have not been able yet to use SQLJ to call stored procedures from a VisualAge for Java environment on NT to DB2 on OS/390 but I can do it from a Java application running under USS. [...] 16615 35 20_Triggers and Explain15_Conoway, Roslyn28_Roslyn_Conoway@COMPUWARE.COM31_Thu, 26 Jul 2001 14:42:35 -0400509_iso-8859-1 You can explain the trigger package with the REBIND TRIGGER PACKAGE statement, specifying EXPLAIN(YES).

=========================================================================== ===== Date: Thu, 26 Jul 2001 15:26:26 +1000 From: teldb2kals Subject: Triggers and Explain

Hi,

Is there a way to do an explain on trigger packages ? My problem is to determine the accesspath for some queries within triggers. I notice that the default is EXPLAIN(NO). [...] 16651 160 25_Re: DB2 Stored Procedures15_Janardhan Ragam16_sragam@YAHOO.COM31_Thu, 26 Jul 2001 11:43:26 -0700407_us-ascii So why can't you issue the "SET PATH" statement? It does not need any authority to be granted to the user, nor does db2 do any verification as to the existence of the schema etc. If you know the schema that the SP is defined under and you don't want to specify it in the CALL SP stmt, just issue the SET PATH sql command at the beginning of the program. This should take care of your problem. [...] 16812 39 22_Re: Need information !13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Fri, 27 Jul 2001 04:48:53 +1000539_iso-8859-1 Azam,

What are you using ODBC or JDBC.

Greg

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Azam Mirza Sent: Friday, July 27, 2001 4:11 AM To: DB2-L@RYCI.COM Subject: Need information !



All, I need information about returning a result set from a SQL stored procedure. The DB2 UDB is on NT. I want to know how to return a cursor to an application. I would really appreciate if you can explain in detail as I am new with DB2. thanks Azam [...] 16852 17 27_Group Buffer Pool DUPLEXING10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 26 Jul 2001 14:52:13 -0400375_us-ascii Hi all

Does anyone know what the additional overhead is for implementing DUPLEXING in a coupling facility?

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. 16870 83 59_Re: Immediate IMS and DB2 DBA Opportunity in Ft. Lauderdale12_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 26 Jul 2001 21:54:33 +0200448_big5 Deja vue, It's the 4th time I remeber of exactly the same "bargain" ....

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

----- Original Message ----- From: "´ö˝ŇŞř" Newsgroups: bit.listserv.db2-l To: Sent: Saturday, June 09, 2001 5:56 AM Subject: Re: Immediate IMS and DB2 DBA Opportunity in Ft. Lauderdale [...] 16954 22 38_Old Versions of DB2 Connect and DB2 V712_Bruce Crosby26_Bruce_C_Crosby@KEYBANK.COM31_Thu, 26 Jul 2001 13:46:00 -0500590_- We are starting to plan our conversion from DB2 UDB for OS/390 V6 to DB2 OS/390 UDB Server for OS/390 and z/OS V7. Included in our mix of applications are clients that access the OS/390 DB2 databases through DB2 Connect. We have several applications that still use DB2 Connect 2.2 through NetDynamics servers. (The NetDynamics servers that we have do not support a higher version of DB2 Connect) We also have applications that use DB2 Connect V5.2 and V6.1. According to the IBM documentation DB2 Connect V6.1 should work with DB2 V7 on OS/390. Does anyone have any experience using [...] 16977 133 25_Re: DB2 Stored Procedures17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Thu, 26 Jul 2001 13:59:31 -0500589_iso-8859-1 I guess the problem I see is that in many shops (I've been in) have had multiple versions of the same tables, each with a different owner (I'm not saying it's right or wrong but, with the introduction of schemas, schemas?) within the test envirionment (depending on programmers working on the objects, unit testing --> systemwide testing) and in order to have it reflect similarly with stored procedures you would have to have an if statement testing the version you're running in. I would rather resolve the owner issues with bind (or a grant in this case) then require a [...] 17111 14 25_Re: DB2 Stored Procedures13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Thu, 26 Jul 2001 14:00:36 -0500360_- I added her schema to the path for the DB2 Connect packages it was using and it still gets a -440. In the ODBC trace, we noticed that it is trying to query SYSIBM.SYSPROCEDURES (V5) rather than SYSIBM.SYSROUTINES (V6). We are not sure why it is doing that. She is using ADO. At no time does it query SYSIBM.SYSROUTINES before it gets the error message. [...] 17126 36 25_Re: DB2 Stored Procedures17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Thu, 26 Jul 2001 14:30:56 -0500639_iso-8859-1 Just out of curiosity, was there a fallback to version 5 and then a remigrate to version 6?

-----Original Message----- From: Shauna Hadden [mailto:shauna.hadden@BCBSKS.COM] Sent: Thursday, July 26, 2001 14:01 To: DB2-L@RYCI.COM Subject: Re: DB2 Stored Procedures



I added her schema to the path for the DB2 Connect packages it was using and it still gets a -440. In the ODBC trace, we noticed that it is trying to query SYSIBM.SYSPROCEDURES (V5) rather than SYSIBM.SYSROUTINES (V6). We are not sure why it is doing that. She is using ADO. At no time does it query SYSIBM.SYSROUTINES before it gets the [...] 17163 50 25_Re: DB2 Stored Procedures16_Katherine Fowler31_Katherine.Fowler@INBUSINESS.COM31_Thu, 26 Jul 2001 15:24:04 -0400470_iso-8859-1 Our firm has an immediate requirement for a:

DB2/MVS/DBA Minimum 5 years experience designing and implementing physical databases, 1 year contract in Ottawa, Ontario.

If interested please contact myself.

Thanks, Kate

Katherine (Kate) Fowler Recruiter - Systems Integration/Networking InBusiness e-Services Group InBusiness Systems Inc. (613) 761-9436 ext 278 www.inbusiness.com We haven't changed a thing! ...except our name. [...] 17214 158 25_Re: DB2 Stored Procedures12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 26 Jul 2001 12:44:02 -0700603_us-ascii My client has several environments in Test, plus a qc environment and there is nothing in the SPs that reflects the schema/qualifier. We control it thru binds/owners for code that executes plans. And thru dynamic variables for dynamic SQL such as VB/JAVA. No code changes to switch between environments. Just change environment variables. --- "Okronglis, Pete M" wrote: > I guess the problem I see is that in many shops (I've been in) have > had > multiple versions of the same tables, each with a different owner > (I'm > not saying it's right or wrong but, with [...] 17373 144 25_Re: DB2 Stored Procedures10_Shery Hepp17_schepp@SRPNET.COM31_Thu, 26 Jul 2001 12:50:17 -0700472_iso-8859-1 Pete- my sentiments exactly! I want a solution to this that won't require the application code to change by hard coding a schema id on the call or by issuing a set current path. We should be able to control the schema id from the binds to the package.

Shery



-----Original Message----- From: Okronglis, Pete M [mailto:pete.okronglis@NWA.COM] Sent: Thursday, July 26, 2001 12:00 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Stored Procedures [...] 17518 43 42_Re: Old Versions of DB2 Connect and DB2 V713_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Fri, 27 Jul 2001 05:52:05 +1000658_iso-8859-1 5.2 works but I am unsure about 2.2

Greg Farquhar

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Bruce Crosby Sent: Friday, July 27, 2001 4:46 AM To: DB2-L@RYCI.COM Subject: Old Versions of DB2 Connect and DB2 V7



We are starting to plan our conversion from DB2 UDB for OS/390 V6 to DB2 OS/390 UDB Server for OS/390 and z/OS V7. Included in our mix of applications are clients that access the OS/390 DB2 databases through DB2 Connect. We have several applications that still use DB2 Connect 2.2 through NetDynamics servers. (The NetDynamics servers that we have [...] 17562 186 25_Re: DB2 Stored Procedures17_Okronglis, Pete M22_pete.okronglis@NWA.COM31_Thu, 26 Jul 2001 14:58:39 -0500714_iso-8859-1 When you say "no code changes", how are the environment variables set? Is there code to set these?

-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Thursday, July 26, 2001 14:44 To: DB2-L@RYCI.COM Subject: Re: DB2 Stored Procedures



My client has several environments in Test, plus a qc environment and there is nothing in the SPs that reflects the schema/qualifier. We control it thru binds/owners for code that executes plans. And thru dynamic variables for dynamic SQL such as VB/JAVA. No code changes to switch between environments. Just change environment variables. --- "Okronglis, Pete M" wrote: > I guess the [...] 17749 22 19_ENCRYPT function ??14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Thu, 26 Jul 2001 16:06:20 -0400336_iso-8859-1 Hi,

Can anyone tell me how to use the ENCRYPT, DECRYPT, SET ENCRYPTION PASSWORD and GETHINT functions ? These, I believe are built-in functions which are used for encryption and decryption of column-data. I couldn't find them in SQL Reference. Any pointers to where I can read them up would also be very helpful. [...] 17772 212 25_Re: DB2 Stored Procedures12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 26 Jul 2001 13:19:52 -0700615_us-ascii Two ways: 1) Parm file for variable 2) Environment variable set in DB2 Connect

Both totally external to code. So the code doesn't have to change. Just the environment variable or parm file. And we're running with two different parm config files on the same websphere machine so that the users can access two different environments depending upon the URL given. Same code, different backend DB2 Creators - same DB2. --- "Okronglis, Pete M" wrote: > When you say "no code changes", how are the environment variables > set? > Is there code to set these? > > -----Original [...] 17985 23 83_DB2 OS/390 V6.1 : Question on DB2PM Statistics Report (Package Allocation attempts)0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 26 Jul 2001 16:42:06 -0400352_us-ascii To all,

I'm not sure whether I should be concerned or not: In the DB2PM Statistics report under the heading "Plan/Package Processing", the 'package allocation attempts' does not equal 'package allocation successes'. Is this because of caching or do I have a potential problem. I do not see any errors in the start of task (*MSTR). [...] 18009 242 25_Re: DB2 Stored Procedures11_Rick Rogers21_Rick.Rogers@TELUS.COM31_Thu, 26 Jul 2001 15:57:14 -0600360_iso-8859-1 We worked with IBM for about 5 weeks attempting to get the set schema command to properly set the schema for unqualified tables referenced in a SP. They sent us a couple of patches to try to resolve it, but the last one we received before we had to move on in the project was still faulty. We've now qualified the tables referenced in our SPs. [...] 18252 12 16_Private Protocol18_Calvetti, Arthur B30_Arthur.Calvetti@PSS.BOEING.COM31_Thu, 26 Jul 2001 15:21:10 -0700384_- I have an application that uses private protocol (three part name) and wants to use DBPOTOCOL(DRDA). The problem I'm having is that the program accesses tables on the local site that don't exist on the remote, so when we bind the package at the remote site we are getting invalid table names. Does anyone know if it is possible to bind a package using tables that don't exist. [...] 18265 30 20_Re: Private Protocol13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 26 Jul 2001 17:44:14 -0500503_US-ASCII Arthur, You can bind with validate(run) HTH Kurt

>>> Arthur.Calvetti@PSS.BOEING.COM 07/26/01 05:21PM >>> I have an application that uses private protocol (three part name) and wants to use DBPOTOCOL(DRDA). The problem I'm having is that the program accesses tables on the local site that don't exist on the remote, so when we bind the package at the remote site we are getting invalid table names. Does anyone know if it is possible to bind a package using tables that don't exist. [...] 18296 49 16_Nested loop join7_db user20_dbuser75@HOTMAIL.COM31_Thu, 26 Jul 2001 23:10:03 +0000638_- Hello gurus, I have a query like this;

SELECT T1.C1,T1.C2,T1.C3,T2.C1,T2.C2 FROM CUSTOMER_ACCT T1,SERVICE_REQ T2 WHERE T1.C1 = T2.C1 AND T1.C2 = T2.C2;

Table CUSTOMER_ACCT has 100,000 rows Table SERVICE_REQ has 4,000,000 rows

Indexes:

CUSTIX - C1,C2,C3 C1 Cardinality - 58,000 C2 " - 6000 SERVIX - C1,C2 C1 Cardinality - 2,223,000 C2 -10,000





The explain report says CUSTOMER_ACCT joined through Nested loop join with SERVICE_REQUEST.The data access for table CUSTOMER_ACCT is CUSTIX with IXONLY and matchcols 0 where as for SERVICE_REQUEST its SERVIX with IXONLY and matchcols 2. [...] 18346 78 20_Re: Nested loop join24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 26 Jul 2001 16:43:41 -0700598_- Hi Raj!

I believe that you're interpreting it incorrectly. Your where clause only specifies join criteria. So DB2 needs to access all of the rows in the CUSTOMER_ACCT table. Since all of the columns it needs are part of an index, the DB2 optimizer chooses to scan the index instead of the tablespace as the index is probably smaller than the tablespace. Then for each row in the CUSTOMER_ACCT table, it uses the values obtained to access the SERVICE_REQUEST table achieving a 2-column matching index scan. If you were to specify a condition like WHERE T1.C1 = :host-variable, or some [...] 18425 75 20_Re: Nested loop join18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Fri, 27 Jul 2001 05:26:27 +0500628_- Because CUSTOMER_ACCT is accessed first (that's what I could understand from what you have written) it cannot match on any columns on its index (CUSTIX) as there are no local predicates on its columns in the query.

Regards

Nagaraj

> -----Original Message----- > From: db user [SMTP:dbuser75@HOTMAIL.COM] > Sent: Friday, July 27, 2001 4:40 AM > To: DB2-L@RYCI.COM > Subject: Nested loop join > > Hello gurus, > I have a query like this; > > SELECT T1.C1,T1.C2,T1.C3,T2.C1,T2.C2 > FROM CUSTOMER_ACCT T1,SERVICE_REQ T2 > WHERE T1.C1 = T2.C1 > AND T1.C2 = T2.C2; > > Table CUSTOMER_ACCT has 100,000 rows [...] 18501 20 59_Abend S04E R=00E50013 during creation of partitioned index.5_Linda21_linda_dba@HOTMAIL.COM31_Thu, 26 Jul 2001 20:43:57 -0500354_- I am getting the following abend while trying to create a partitioning index on a table.

CEE3250C The system or user abend S04E R=00E50013 was issued. From compile unit DSNTEP2 at entry point DSNTEP2 at compile unit offset +000014AA at address 1CDA5052.

There is no helpful message in MSTR. Any clues on how to resolve this? Thanks, [...] 18522 16 63_Re: Abend S04E R=00E50013 during creation of partitioned index.26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Thu, 26 Jul 2001 21:42:29 -0500434_- Might want to check SYSLOG, the error message says either the TCB was in use or operator issued -stop db2 mode(force). Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18539 67 20_Re: Nested loop join16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 27 Jul 2001 09:43:21 +0530599_- There is nothing to match on CUSTOMER_ACCT index.

HTH Regards Sanjeev



> -----Original Message----- > From: db user [SMTP:dbuser75@HOTMAIL.COM] > Sent: Friday, July 27, 2001 4:40 AM > To: DB2-L@RYCI.COM > Subject: Nested loop join > > Hello gurus, > I have a query like this; > > SELECT T1.C1,T1.C2,T1.C3,T2.C1,T2.C2 > FROM CUSTOMER_ACCT T1,SERVICE_REQ T2 > WHERE T1.C1 = T2.C1 > AND T1.C2 = T2.C2; > > Table CUSTOMER_ACCT has 100,000 rows > Table SERVICE_REQ has 4,000,000 rows > > Indexes: > > CUSTIX - C1,C2,C3 > C1 Cardinality - 58,000 > C2 " - 6000 > SERVIX - C1,C2 [...] 18607 15 54_Charles F Creech/Corp/DukeEnergy is out of the office.16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Fri, 27 Jul 2001 01:01:07 -0400389_us-ascii I will be out of the office starting 07/27/2001 and will not return until 07/30/2001.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18623 80 41_Re: Dropping unique index on primary key.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Fri, 27 Jul 2001 10:34:26 +0530303_- If I drop the primary key without harming the unique index, what happens of the index...does it still stay. And if i have to add a new primary key then I guess the table needs to be purged of its data else there is every possibility of duplicate keys....right?

thanks, Rajendra Deshpande. [...] 18704 114 41_Re: Dropping unique index on primary key.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Fri, 27 Jul 2001 10:41:40 +0530356_- Janardhan,

Are you suggesting that there are 2 ways to create primary key under UNIX! 1. Create index first then define the primary key with matching cols as in the index.

2. Create Primary key first and then an index automatically gets created on the primary key.

And each option has a diff rule for dropping the constituents. [...] 18819 164 41_Re: Dropping unique index on primary key.16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 27 Jul 2001 11:07:21 +0530412_iso-8859-1 DB2 work different under different OS and its best with OS390.

Only thing is schema processor. If schema processor is used, then unique/primary index is automatically created when primary/unique key is defined (any OS). As far as drop is concerned, if index is drop first (till V6) then table definition will be marked as incomplete and can't be used unless primary/unique key is dropped. [...] 18984 46 38_FW: db2 userids - administer authority17_Sundaresan, Anand34_Anand.Sundaresan@BLR.HPSGLOBAL.COM31_Fri, 27 Jul 2001 12:06:34 +0500587_- Hi

Anyone in the list can explain how this can be done

Thanks and Regards Anand

> -----Original Message----- > From: Sundaresan, Anand > Sent: Friday, March 30, 2001 11:03 AM > To: 'askdb2@ca.ibm.com' > Subject: db2 userids - administer authority > > Hi > > I use UDBV6.1 in our Shop. We have IBM MQ Workflow and IBM Content Manager > also.We are working on an Automated workflow system using Content Manager > for document storage and Workflow for routing. > > We have installed client configuration of UDB in all our workstations and > we have a standalone [...] 19031 165 37_Re: Partition independence - Or Not !14_Adrian Collett27_adriancollett@TISCALINET.IT31_Fri, 27 Jul 2001 09:02:33 +0200409_iso-8859-1 Ashish, Thanks for your answer.

I too have read the manual - in fact my problem is not with the SQL taking a claim against the whole of the NPI it is with the REBUILD INDEX PART trying to DRAIN the NPI of CS Claimers whereas as I read the manual(Utility Guide) it should only be trying to drain the NPI of RR Claimers, and thus be able to complete because I have a CS Claim on the npi. [...] 19197 74 38_Re: db2 userids - administer authority16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 27 Jul 2001 13:25:07 +0530399_- Anand,

You have not mentioned the platform so i would assume Windows NT as per the question asked by you. If i have understood your question correctly, adding a user in the NT shows them in the DB2 authorization window and there we need to select what kind of authorizations/previleges we need to grant them. You can grant them using SYSADM for all or DBADM for a particular database. [...] 19272 21 20_Re: Private Protocol22_MŞ José Artigas Cortés17_mjartigas@ATCA.ES31_Fri, 27 Jul 2001 10:03:41 +0200450_iso-8859-1 Yes, you can do BIND ussing the parameter VALIDATE(RUN). So if the table does not exist, the process issues warning messages. But DB2 will check existence again at run time.

Regards

María José ===============================================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. 19294 45 31_Re: Group Buffer Pool DUPLEXING23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 27 Jul 2001 09:24:35 +0100644_- Tom

I take it you mean CPU ... storage can be calculated.....???

Les

-----Original Message----- From: Tom Taylor [mailto:ttaylor@CHUBB.COM] Sent: Thursday, July 26, 2001 7:52 PM To: DB2-L@RYCI.COM Subject: Group Buffer Pool DUPLEXING



Hi all

Does anyone know what the additional overhead is for implementing DUPLEXING in a coupling facility?

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. [...] 19340 105 16_Re: trace syntax16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Fri, 27 Jul 2001 09:14:57 +0100309_us-ascii sorry guys,

could not help re-posting this, I received it yesterday with all of those funny messages and it took me back in life one year or so!!!!! actually 13 months :-)

how the hell did messages from such a long time ago get spat on the list in such an odd manner, I wonders... [...] 19446 107 41_Re: User Defined Function program display14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 27 Jul 2001 03:29:15 -0500395_- Melvin

The only developers who need to know the specific name are those writing code for programs which process two (or more) functions (or overloadings of them). Programmers writing code which invokes the function have no need to know the specific name and, indeed, have no way of using it. (Which is not to say you've got to hide the information - just that they don't need it.) [...] 19554 42 35_Re: FW: DB2 V7.2 NULL w/ C Compiler14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 27 Jul 2001 03:41:08 -0500705_- Tim

You are possibly re-asking in the wrong place. Try: DB2EUG: http://people.mn.mediaone.net/scottrmcleod/index.html news://comp.databases.ibm-db2 both of which are orientated towards DB2 on 'other platforms'

James Campbell

On Thu, 26 Jul 2001 07:50:36 -0700, Killen, Martin W - CNF wrote:

>> -----Original Message----- >> From: Ohling, Tim R - CNF [SMTP:Ohling.Tim@CNF.COM] >> Sent: Monday, July 23, 2001 4:24 PM >> To: DB2-L@RYCI.COM >> Subject: DB2 V7.2 NULL w/ C Compiler >We are re-posting this hoping that someone has run into this and missed the >message the first time. It seems like someone would have to have run into >this problem if [...] 19597 73 25_Re: DB2 Stored Procedures10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 27 Jul 2001 18:59:40 +1000357_us-ascii Hi Shauna,

I had sent this out to the list sometime before. I am not sure if this is what u need, but u can try.

We use VB applications to connect to DB2 v6 on OS390. We just code the foll. string at the end of the connect string. (I am assuming u r making a connection from within the program and that u have a connect string). [...] 19671 76 41_Visual Basic sample BLOB.vbp do not work!16_Petteno' Massimo27_Petteno.Massimo@GENERALI.IT31_Fri, 27 Jul 2001 11:04:19 +0200364_- Hello listers,

I have used the BLOB.vbp Visual Basic sample code supplied with DB2 Connect V6.1 to access sample tables on DB2 V6.1 on OS/390.

It doesn't work!

Could somebody help me please?

TIA Massimo

PS. I had to change the query "SELECT PICTURE ..." into "SELECT BMP_PHOTO ...", the table name and also the WHERE condition! 19748 218 24_Re: Triggers and Explain10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 27 Jul 2001 19:12:23 +1000550_us-ascii Hi Phil,

Thanx for that. That will teach me not to jump onto the list without first Reading The Friendly Manuals. (I normally dont, but yesterday I cdnt look up the manual).

I did face a problem though.(again, I havent yet had a chance to read the manuals). The trigger is created using a sqlid , say MYNAME (which is a RACF group). So, the package gets created under the same collid MYNAME. But I cant rebind it with my userid. (unlike a normal package, for which I can specify MYNAME in the OWNER parameter and get by). [...] 19967 206 37_Re: Partition independence - Or Not !16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 27 Jul 2001 15:15:11 +0530381_iso-8859-1 Adrian,

After my friend Ashish replied to your question and subsequent to your response, i have looked into all the maunals and redbooks mentioned by you and found you are correct in your understanding. As i am not able to try this out and let you know the exact scenario, it would be good if someone tries in other installation and let you know the result. [...] 20174 40 20_Re: Private Protocol16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 27 Jul 2001 07:18:17 -0400490_iso-8859-1 YES. We do this all the time. Use SQLERROR(CONTINUE). Read the messages from the precompiler. If you see SQLCODE -204 this is probably because of the 3.part.names and you can ignore them. Look more closely at the other SQL errors.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Calvetti, Arthur B [mailto:Arthur.Calvetti@PSS.BOEING.COM] Sent: Thursday, July 26, 2001 6:21 PM To: DB2-L@RYCI.COM Subject: Private Protocol [...] 20215 15 18_Latch and lock....18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Fri, 27 Jul 2001 06:25:15 -0500405_- Hi Friends,

I have a vague understanding of the diff latch/locks but would like to have a clear picture of it all. Could any one volunteer.

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. 20231 15 18_Latch and lock....18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Fri, 27 Jul 2001 06:26:04 -0500413_- Hi Friends,

I have a vague understanding of the diff between latch/locks but would like to have a clear picture of it all. Could any one volunteer.

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. 20247 14 21_PCTFREE and FREEPAGE.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Fri, 27 Jul 2001 06:31:13 -0500457_- Hi all,

If a tablespace is defined with a which has a certain amount of free space using PCTREE/FREEPAGE then does a reorg on such tablespace, claim all the free space and render the parameters ineffective.

================================================ 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. 20262 66 25_Re: PCTFREE and FREEPAGE.15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Fri, 27 Jul 2001 14:06:11 +0200617_us-ascii No. In fact, with regular update's, insert's and deletion's, your freespace and pctfree get used ( which is what they're there for, so that's cool). But eventually the "freespace" you've planned for will get used up, and you'll start going into extents.

When you reorg, AFAIK, then you re-create the datasets based on your current priqty, and secqty if necessary (typically you want to try and calculate the space, and then alter tablespace's and indexes priqty to ensure that everything will be in one extent), then DB2 loads the data in, creating at that point in time the specified frrepages, [...] 20329 36 25_Re: PCTFREE and FREEPAGE.16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 27 Jul 2001 17:48:29 +0530611_- The space is reclaimed in the reorg but parameters are not made ineffective because it is used each time tablespace is reorged. The values are stored in the catalog table for reorg to refer so that i can reclaim the space each time the tablespace is reorged.

HTH Regards Sanjeev

> -----Original Message----- > From: Rajendra Deshpande [SMTP:rajendra_deshpande@HOTMAIL.COM] > Sent: Friday, July 27, 2001 5:01 PM > To: DB2-L@RYCI.COM > Subject: PCTFREE and FREEPAGE. > > Hi all, > > If a tablespace is defined with a which has a certain amount of free space > using PCTREE/FREEPAGE then does [...] 20366 43 22_Re: Latch and lock....16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 27 Jul 2001 17:51:05 +0530368_- Brief description :--

Latches guarantee consistent state of the pages while locks guarantee consistency, concurrency and integrity. Advantage of latches is it never turns out to deadlocks and timeouts. And it doesn't cost(in terms of CPU) as much as a lock does.

The complete description is there in the redbook for locking in DB2 V4 for MVS/ESA. [...] 20410 39 25_Re: PCTFREE and FREEPAGE.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 27 Jul 2001 08:16:38 -0400505_iso-8859-1 REORG rewrites the data into the space so that the specified PCTFREE and FREEPAGE numbers are honored within the limts of rounding. At *no* time are PCTFREE and FREEPAGE *more* effective than immediately after REORG or LOAD REPLACE RESUME NO.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Rajendra Deshpande [mailto:rajendra_deshpande@HOTMAIL.COM] Sent: Friday, July 27, 2001 7:31 AM To: DB2-L@RYCI.COM Subject: PCTFREE and FREEPAGE. [...] 20450 48 25_Re: PCTFREE and FREEPAGE.9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Fri, 27 Jul 2001 13:15:19 +0100482_us-ascii No. After a reorg, each data page will have pctfree% free and there will be an empty page every freepage pages.

Chris









Rajendra Deshpande cc: Sent by: DB2 Data Base Subject: [DB2-L] PCTFREE and FREEPAGE. Discussion List



27/07/01 12:31 Please respond to DB2 Data Base Discussion List











Hi all, [...] 20499 40 48_Changing OS/390 password via DB2 Connect Clients13_Murat Umurhan25_Murat.Umurhan@TCMB.GOV.TR31_Fri, 27 Jul 2001 15:21:04 +0300418_iso-8859-9 Hello listers,

We have a problem about changing passwords via DB2 Connect clients. Our environment is: Windows 2000 Client ===> Windows 2000 Server ===> OS/390 v2.6.

DB2 Connect Client v6.1 is installed on clients using gateway server(Windows 2000 Server: DB2 Connect EE v6.1 and Microsoft SNA Server v4.0 is installed.

On the OS/390 side DB2 version is v6.1 The zparm EXTSEC=YES. [...] 20540 17 15_database files.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Fri, 27 Jul 2001 07:18:02 -0500544_- Hi all,

DB2 database resides on a collection of VSAM files. I guess these files get allocated during tablespace creation. Could someone involved in such activity explain the whole process which could give a clear perception of DB at the dataset level.

thanks in anticipation of a reply.

================================================ 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. 20558 34 25_Re: PCTFREE and FREEPAGE.15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Fri, 27 Jul 2001 07:20:05 -0500552_iso-8859-1 No, exactly the opposite! It re-establishes the freespace and freepages.

Andy Lankester bmcsoftware My opinions are just that

-----Original Message----- From: Rajendra Deshpande [mailto:rajendra_deshpande@HOTMAIL.COM] Sent: 27 July 2001 12:31 To: DB2-L@RYCI.COM Subject: PCTFREE and FREEPAGE.



Hi all,

If a tablespace is defined with a which has a certain amount of free space using PCTREE/FREEPAGE then does a reorg on such tablespace, claim all the free space and render the parameters ineffective. [...] 20593 231 37_Re: Partition independence - Or Not !14_Adrian Collett27_adriancollett@TISCALINET.IT31_Fri, 27 Jul 2001 14:56:59 +0200500_iso-8859-1 Sanjeev, Thank you for your confirmation of my understanding of the manual - that is exactly what I was looking for. I am also interested in seeing if it happens that way at other sites to see whether I have a maintenance problem.

Thanks,

Adrian.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] On Behalf Of S, Sanjeev (CTS) Sent: 27 July 2001 11:45 To: DB2-L@RYCI.COM Subject: Re: Partition independence - Or Not ! [...] 20825 73 25_Re: PCTFREE and FREEPAGE.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Fri, 27 Jul 2001 18:33:07 +0530667_- Reagan / Sanjeev / Pearson / Chris,

thank you all for your helpful mails.

thanks, Rajendra Deshpande.





>From: Chris Tee >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: PCTFREE and FREEPAGE. >Date: Fri, 27 Jul 2001 13:15:19 +0100 > >No. After a reorg, each data page will have pctfree% free and there will >be an empty page every freepage pages. > >Chris > > > > > > Rajendra Deshpande > TMAIL.COM> cc: > Sent by: DB2 Data Base Subject: [DB2-L] >PCTFREE and FREEPAGE. > Discussion List > > > > [...] 20899 75 0_17_jennifer jennifer22_jenni_jeni@HOTMAIL.COM31_Fri, 27 Jul 2001 13:32:58 +0000512_- HI All I I tried all the suggestions given by you. It seems most of the sugestions given by youy are working fin for me. I tried the suggestion given by Vijay and it is working fine. Other optins also I tried and it is working fine. Yes I m very very thank ful to all the memebers as very quick and immdiate response we are getting. In near future I would ask some thing about the DB2 Performance monitoring. As I had seen Sanjeev, Terry, Rick,Trod , Vijay, others I mean I m unable to write the name are [...] 20975 15 54_general questions about DB2 COBOL setup in CICS TS 1.315_Craig Nicholson27_Marion_C._Nicholson@HUD.GOV31_Fri, 27 Jul 2001 09:32:05 -0400368_us-ascii General question - what definitions need to be in place for a COBOL DB2 program to run in CICS TS 1.3?

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. 20991 143 45_Re: Visual Basic sample BLOB.vbp do not work!13_Jackson, Phil21_PJackson@TXFB-INS.COM31_Fri, 27 Jul 2001 08:49:36 -0500465_iso-8859-1 Hi, Yes, we ran into much the same problem some months ago. If you will go here : http://www-4.ibm.com/software/data/db2/udb/ad/v7/oledb.html You will find that IBM finally admits - this functionlity is NOT SUPPORTED, and the samples shipped WILL NOT WORK. Finding this out took many,many hours of research and asking questions to anyone who whould listen, including IBM Tech Support... [...] 21135 33 22_FAROFFPOS vs FARINDREF10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Fri, 27 Jul 2001 09:16:44 -0500597_- Dear List,

Its Friday afternoon and I think my brain's already reached the weekend. Would somebody care to explain the following: I have a partitoned tablespace (6 parts) with one table in it. This table has a single unique clustering index. After having run RUNSTATS on this tablespace, the Catalog says that all 6 parts have NEAR/FARINDREF values of zero. The cluster ratio is 100%. However, the two smallest parts have high values for FAROFFPOS - in one part its 44036 out of 127930 rows (approx. 34%). If FARINDREF indicates that there are no rows which have been relocated, why [...] 21169 66 38_Java Stored Procedure Error (SQL4306N)13_Eamonn downey23_eamonn_downey@LOTUS.COM31_Fri, 27 Jul 2001 09:35:47 -0500561_- Hi,

I am creating the following Java Stored Procedure on NT and it compiles fine but when I run it I get an error. Any ideas ?



Java Stored Procedure Code -



* JDBC Stored Procedure EDOWNEY.Procedure1 */ import java.sql.*; // JDBC classes

public class Procedure1 { public static void procedure1 ( int var1 ) throws SQLException, Exception { // Get connection to the database Connection con = DriverManager.getConnection("jdbc:default:connection"); PreparedStatement stmt = null; int updateCount = 0; String sql; [...] 21236 33 20_Re: Private Protocol11_David Nance16_DWNance@FHSC.COM31_Fri, 27 Jul 2001 10:04:16 -0400630_US-ASCII Yes, use your normal bind parms on both subsystems with sqlerror(continue) we did this with a few packages at the shop I was at. You not need to use validate(run) unless other portions of your package require that parm.

Dave Nance First Health Services, Corp. (804)527-6841

>>> Arthur.Calvetti@PSS.BOEING.COM 07/26/01 06:21PM >>> I have an application that uses private protocol (three part name) and wants to use DBPOTOCOL(DRDA). The problem I'm having is that the program accesses tables on the local site that don't exist on the remote, so when we bind the package at the remote site we are getting [...] 21270 64 35_Re: FW: DB2 V7.2 NULL w/ C Compiler19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Fri, 27 Jul 2001 08:19:31 -0700685_- The question was posted there originally as well.

Still no answer from anywhere.

Thanks, Tim

> -----Original Message----- > From: James Campbell [SMTP:jacampbell@ACSLINK.NET.AU] > Sent: Friday, July 27, 2001 1:41 AM > To: DB2-L@RYCI.COM > Subject: Re: FW: DB2 V7.2 NULL w/ C Compiler > > Tim > > You are possibly re-asking in the wrong place. Try: > DB2EUG: http://people.mn.mediaone.net/scottrmcleod/index.html > news://comp.databases.ibm-db2 > both of which are orientated towards DB2 on 'other platforms' > > James Campbell > > On Thu, 26 Jul 2001 07:50:36 -0700, Killen, Martin W - CNF > wrote: > > >> -----Original Message----- [...] 21335 184 42_Re: Java Stored Procedure Error (SQL4306N)18_Jean-Jacques Borie18_jjborie@TEKORA.COM31_Fri, 27 Jul 2001 17:25:09 +0200487_iso-8859-1 sql = "UPDATE" + " EDOWNEY.PETER" + " SET NUMERIC_VALUE = numeric_value +1 " + " WHERE" + " (" + " ( EDOWNEY.PETER.DOCID = ? )" + " )"; may be your numeric_value variable in your sql statement is not valid and in fact...



Jean-Jacques Borie Directeur recherche et développement www.tekora.com "Changez votre conception des sites web" jjborie@tekora.com +33 (0) 1 55 00 10 03 +33 (0) 6 60 19 95 24 17, place de la résistance 92130 Issy les moulineaux France [...] 21520 166 26_Re: FAROFFPOS vs FARINDREF0_18_mebert@AMADEUS.NET31_Fri, 27 Jul 2001 17:37:41 +0200582_us-ascii Basically, INDREF means a row has moved from where it originally was, while OFFPOSF means it couldn't be placed where it should be in the first place.

When you update a variable-length row (either with VARCHAR or because the TS is compressed), and the new row doesn't fit onto the page anymore, DB2 will find a place at another page. The original page will contain a pointer to the rest of the row, and the index RID will now "reference it indirectly", via this additional pointer. If your TS is uncompressed and you don't use VARCHARs, then INDREF will always [...] 21687 200 26_Re: FAROFFPOS vs FARINDREF14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 27 Jul 2001 16:44:28 +0100320_iso-8859-1 the INDREF statistics indicate what percentage of rows have been RELOCATED. ie the RIDs still point to the original location of the row, but the row isn't actually there. Instead there is an indirection pointer to the REAL location of the row. NEARINDREF if they are close by, FARINDREF if they are not. [...] 21888 118 26_Re: FAROFFPOS vs FARINDREF19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Fri, 27 Jul 2001 11:09:48 -0500605_ISO-8859-1 Hi Doc, Wow, this is the best write-up on this subject I've seen -- accurate, clear, concise! I hereby nominate you to write the IBM manuals on same subject!

With Respect, 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 delete this message immediately [...] 22007 71 31_Re: Group Buffer Pool DUPLEXING10_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 27 Jul 2001 12:08:11 -0400651_us-ascii yes CPU









"Pendlebury-Bowe, Leslie" @RYCI.COM> on 07/27/2001 04:24:35 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: Group Buffer Pool DUPLEXING



Tom

I take it you mean CPU ... storage can be calculated.....???

Les

-----Original Message----- From: Tom Taylor [mailto:ttaylor@CHUBB.COM] Sent: Thursday, July 26, 2001 7:52 PM To: DB2-L@RYCI.COM Subject: Group Buffer Pool DUPLEXING [...] 22079 24 26_Re: MSQUERY and DB2 OS390.11_Jim Medlock24_jmedlock@ALLIANCESYS.COM31_Fri, 27 Jul 2001 11:13:44 -0500 22104 16 22_Re: Need information !10_Azam Mirza18_azam00@HOTMAIL.COM31_Fri, 27 Jul 2001 11:06:27 -0500435_- I am using JDBC

Greg... I apologise if you have recieved a similiar msg from me earlier. My network is giving me some problem...and that has led to multiple postings

Thanks Azam

================================================ 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. 22121 20 34_Apologise for multiple postings !!10_Azam Mirza18_azam00@HOTMAIL.COM31_Fri, 27 Jul 2001 11:11:27 -0500551_- All, I apologise for my multiple postings of "HELP-SQL stored procedure", "SQL stored procedure-HELP needed" and "Need information".

My network is giving me problems, so I wasn't sure if the message got posted and went ahead and re-posted them.

Sorry for the inconvience ...

Thanks Azam

================================================ 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. 22142 127 28_Re: Timestamp as primary key14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Fri, 27 Jul 2001 09:33:59 -0700411_iso-8859-1 Jon, Even if you have multiple CECs in a syslpex, the STCK instruction will still only get the time from the current system, without blocking other CEC's from issuing the instruction at the same time, thereby getting a dup. The STCK does NOT check the ETR to perform serialization. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 22270 16 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Fri, 27 Jul 2001 11:37:37 -0500447_us-ascii I will be out of the office starting 07/27/2001 and will not return until 07/30/2001.

I will be out of the office for the remainder of the day. I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 22287 129 26_Re: FAROFFPOS vs FARINDREF0_24_William_O'Black@FFIC.COM31_Fri, 27 Jul 2001 09:50:06 -0700310_iso-8859-1 Thanks for the great writeups Dr Ebert and Phil. Another question - why is the cluster ratio still 100% if the faroffpos numbers are so large? I've seen nearoffpos numbers after a reorg and I assumed they were there because of the free page number, but that doesn't explain faroffpos, does it? [...] 22417 42 32_Re: Monitoring DB2 on NT servers13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Fri, 27 Jul 2001 11:49:34 -0500313_- Hi Mohamed You may want to take a look at our monitoring capability within Quest Central for DB2. We are completely client based and do not require any agents to be installed on the servers. You can download a free 30 day trial at WWW.QUEST.COM/DB2.

Jim Wankowski DB2 Product Manager Quest Software [...] 22460 207 49_Re: DSNV086E DB2 Abnormal Termination RC=00E507279_Don Cross20_Don.Cross@TC.FAA.GOV31_Fri, 27 Jul 2001 13:16:34 -0400688_us-ascii ----- Forwarded by Don Cross/ACT-WJHTC on 07/27/01 01:20 PM -----

Don Cross To: Don 07/27/01 01:14 Cross/ACT-WJHTC@ACT-WJHTC PM cc: Subject: Re: DSNV086E DB2 Abnormal Termination RC=00E50727 (Document link: Don Cross)







We ran EREP..no obvious errors in the system..then we ran DIAGNOSE and did find a problem vsam dataset which was a tablespace..this dataset had 0 records and 9 extents..then we noticed the volume was 97% full..the stogroup has 2 volumes in it. Two questions..why would DB2 crash because of space limitations..and why did it not try to use the second volume? BTW..what command displays the defined volumes in a storage [...] 22668 22 34_Experinces Migrating from V5 to V711_Gerri Lloyd17_glloyd@US.IBM.COM31_Fri, 27 Jul 2001 13:34:35 -0400483_us-ascii I am looking for references or experiences of those who have skipped V6 and migrated from V5 to V7. Any feedback would be greatly appreciated.

Gerri Lloyd NY Financial Data Management Software Group / IBM Corporation glloyd@us.ibm.com / Phone: 212-745--6393 (T/L 243-6393)

DB2 info support and publications: http://www.software.ibm.com/data/db2/ DB2 tools: http://www.ibm.com/software/data/db2imstools DB2 NYC TRIDEX User Group: http://www.db2tridex.org/ [...] 22691 15 49_Re: DSNV086E DB2 Abnormal Termination RC=00E5072726_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Fri, 27 Jul 2001 12:46:45 -0500359_- select * from sysibm.sysvolumes order by 1; Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 22707 45 38_Re: Experinces Migrating from V5 to V716_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 27 Jul 2001 14:05:10 -0400421_iso-8859-1 We did this. Zero problems with the IBM softare. Many gotchas with the OEM software. No application changes were needed, but we did need to rebind almost everything.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Gerri Lloyd [mailto:glloyd@US.IBM.COM] Sent: Friday, July 27, 2001 1:35 PM To: DB2-L@RYCI.COM Subject: Experinces Migrating from V5 to V7 [...] 22753 100 26_Re: FAROFFPOS vs FARINDREF0_18_mebert@AMADEUS.NET31_Fri, 27 Jul 2001 20:11:17 +0200387_us-ascii Well, this does give a nice warm glow on the inside just as I'm about to head off for 4 full weeks of summer vacation.... Thanks all, have a nice time

MfG, ME.

From: "DAVIS, RICK (SBCSI)" @RYCI.COM on 27/07/2001 11:09 EST Please respond to DB2 Data Base Discussion List Sent by: DB2 Data Base Discussion List [...] 22854 45 38_Re: Experinces Migrating from V5 to V717_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Fri, 27 Jul 2001 13:04:49 -0500565_us-ascii What platform? We skipped 6 on our NT environment. What do you want to know?







Gerri Lloyd @RYCI.COM> on 07/27/2001 12:34:35 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Experinces Migrating from V5 to V7



I am looking for references or experiences of those who have skipped V6 and migrated from V5 to V7. Any feedback would be greatly appreciated. [...] 22900 19 13_Not Accounted9_Sally Mir22_Sally.Mir@WACHOVIA.COM31_Fri, 27 Jul 2001 14:44:02 -0400503_us-ascii Does anyone know of a definitive list of the events that can contribute to the NOT ACCOUNTED bucket on DB2 PM reports? I'm seeing a lot of not accounted time, and am having a hard time tracking down some possible causes.

Thanks,

Sally Mir

================================================ 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. 22920 27 17_Re: Not Accounted12_Jim Harrison12_jimh@QIS.NET31_Fri, 27 Jul 2001 15:04:37 -0400325_us-ascii Check your CPU utilization for the box. It's probably up near 100%. The way it was explained to me it is when either DB2 and/or your job is not getting CPU cycles. Our box has been maxed out for some time now and I regularly see 80-95% not accounted times. (Luckily we're migrating to a new Z box just for DB2) [...] 22948 42 22_Re: Need information !13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Sat, 28 Jul 2001 05:10:14 +1000613_iso-8859-1 Azam,

See the methods getResultSet and getMoreResults at http://java.sun.com/products/jdk/1.1/docs/api/java.sql.Statement.html

If still confused I shall post a sample.

Greg Farquhar

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Azam Mirza Sent: Saturday, July 28, 2001 2:06 AM To: DB2-L@RYCI.COM Subject: Re: Need information !



I am using JDBC

Greg... I apologise if you have recieved a similiar msg from me earlier. My network is giving me some problem...and that has led to multiple postings [...] 22991 30 27_Group Buffer Pool DUPLEXING12_Chris Munson18_cmunson@US.IBM.COM31_Fri, 27 Jul 2001 12:28:38 -0700573_us-ascii As far as storage is concerned you could make a very strong case that duplexing does not require any additional storage. The reason is that for a properly configured CF you need to have enough room to handle all of the structures from your other CF. This additional room is 'borrowed' for duplexing. This would not be true, however, if you plan to duplex at all times and have 3 CF's. Then the additional storage would be needed. In terms of CPU we have measured 2.1% CPU overhead in our measurements using our IRWW workload (which is very update intensive). [...] 23022 40 17_Re: Not Accounted13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Sat, 28 Jul 2001 05:28:30 +1000529_iso-8859-1 Sally,

Mainly wait for cpu or waiting for paging or swapping.

Greg

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Sally Mir Sent: Saturday, July 28, 2001 4:44 AM To: DB2-L@RYCI.COM Subject: Not Accounted



Does anyone know of a definitive list of the events that can contribute to the NOT ACCOUNTED bucket on DB2 PM reports? I'm seeing a lot of not accounted time, and am having a hard time tracking down some possible causes. [...] 23063 57 17_Re: Not Accounted13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Fri, 27 Jul 2001 12:32:18 -0700491_- The way it was explained to me was its sort of like UFO's. If they knew what they were, they wouldn't be called Unidentified and they don't necessarily mean little green men.

The first suspect is often CPU and you can spend some time disproving that. Generally its time spend by threads waiting for something outside of its own control. It can even be just an accounting anomoly. for example a task goes parallel and the parent thread waits for the daughter threads to finish. [...] 23121 16 30_Data manipulation during load?0_20_Jones.H@GRAINGER.COM31_Fri, 27 Jul 2001 14:54:00 -0500459_- We want to load a 9 byte customer number into a 10 byte character field, appending a zero to the front of the number without using a program.

Is there a way to do this with the load cards?

Hayden Jones

================================================ 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. 23138 41 34_Re: Data manipulation during load?64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Fri, 27 Jul 2001 15:44:52 -0600476_ISO-8859-1 Whose LOAD are you using, and on what platform?

Todd.



-----Original Message----- From: Jones.H@GRAINGER.COM Sent: Friday, July 27, 2001 3:42 PM To: DB2-L@RYCI.COM Subject: Data manipulation during load?



-------------------------------------------------------------------------- -- We want to load a 9 byte customer number into a 10 byte character field, appending a zero to the front of the number without using a program. [...] 23180 40 34_Index access and effect of NLEVELS12_Mehdi Fakhar26_MehdiFakhar@WINN-DIXIE.COM31_Fri, 27 Jul 2001 16:32:22 -0400280_iso-8859-1 We are running DB2 Version 5.1 & 6

We have 2 index on a 16million row table. Index1 is the Unique Clustering index made up of 15 columns. Index2 is a non unique index made up of 13 columns, 12 of which is same as index, but with different order of columns. [...] 23221 37 29_Problem with Decimal Rounding19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Fri, 27 Jul 2001 20:50:34 +0100446_us-ascii We've got a problem with a query / view being affected by DEC(15) rounding.

The fields are -

SALES_PRICE DEC(11,2) PERCENTAGE_FACTOR1 DEC(5,2) PERCENTAGE_FACTOR2 DEC(5,2)

The calculation in the view is -

(SALES_PRICE / 10000) * (PERCENTAGE_FACTOR1 * PERCENTAGE_FACTOR2)

The division by 10000 is because the two PERCENTAGE_FACTOR fields are percent values and its actually two divisions by 100 !!! [...] 23259 20 26_Varchar Byte Interrogation16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Fri, 27 Jul 2001 16:55:40 -0400334_iso-8859-1 Hey Folks... Does anyone know of a function that will interrogate the 2 byte field the precedes a varchar column and return the number of bytes that are actually in that varchar column? I'm trying to determine the largest number of bytes for a varchar defined column.. Thanks....

Michael Dempsey UNC HealthCare [...] 23280 40 30_Re: Varchar Byte Interrogation13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Fri, 27 Jul 2001 14:18:46 -0700519_us-ascii LENGTH()

Thanks. Ashish.

-----Original Message----- From: Dempsey, Michael [SMTP:MDempse@UNCH.UNC.EDU] Sent: Friday, July 27, 2001 1:56 PM To: DB2-L@RYCI.COM Subject: Varchar Byte Interrogation

Hey Folks... Does anyone know of a function that will interrogate the 2 byte field the precedes a varchar column and return the number of bytes that are actually in that varchar column? I'm trying to determine the largest number of bytes for a varchar defined column.. Thanks.... [...] 23321 36 30_Re: Varchar Byte Interrogation24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 27 Jul 2001 14:21:54 -0700660_- Have you tried the LENGTH function as in:

SELECT LENGTH(varchar_col_name)

> -----Original Message----- > From: Dempsey, Michael [SMTP:MDempse@UNCH.UNC.EDU] > Sent: Friday, July 27, 2001 1:56 PM > To: DB2-L@RYCI.COM > Subject: Varchar Byte Interrogation > > Hey Folks... > Does anyone know of a function that will interrogate the 2 byte field > the precedes a varchar column and return the number of bytes that are > actually in that varchar column? I'm trying to determine the largest > number > of bytes for a varchar defined column.. > Thanks.... > > Michael Dempsey > UNC HealthCare > > ================================================ [...] 23358 38 30_Re: Varchar Byte Interrogation15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Fri, 27 Jul 2001 17:26:24 -0400607_iso-8859-1 try length(varfld) function

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Dempsey, Michael > Sent: Friday, July 27, 2001 4:56 PM > To: DB2-L@RYCI.COM > Subject: Varchar Byte Interrogation > > > Hey Folks... > Does anyone know of a function that will interrogate the 2 byte field > the precedes a varchar column and return the number of bytes that are > actually in that varchar column? I'm trying to determine the largest number > of bytes for a varchar defined column.. > Thanks.... > > Michael Dempsey > UNC HealthCare > > [...] 23397 41 49_Temporarary storage allocation failure (00C900A5)8_K.Balaji19_K.Balaji@TARGET.COM31_Fri, 27 Jul 2001 16:33:11 -0500400_iso-8859-1 Hi, I am facing resource problem while I execute my sql in both code & spufi. This sql has 11 joins. Actually there are two tables with a volume of 1000 to 2000 rows which are repeatedly joined in this query. When the sql is executed it says temporary storage is not sufficient to execute the sql. What can I do to overcome this problem? The error codes the spufi gives is as follow: [...] 23439 55 25_Re: DB2 Stored Procedures13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Sat, 28 Jul 2001 10:11:08 +1000662_iso-8859-1 Myron et al,

If interested I have an alternative for Java,WebShere,CICS,DB2 on OS/390. Access is via a browser, applet, servlet, CTG, CICS, DB2. Also MQ triggered background tasks in CICS.

We run several dozen testing groups each with a database copy with their own collection, alias, schema etc.

Most unit development is from NT/VisualAge with a connection to DB2/OS/390. After unit test we run several testing levels and streams, System, Functional, Acceptance, Production etc. Each level has its own set of CICS subsystems and WebSphere environments. So we have n streams of System Test, n streams of Acceptance etc. Each [...] 23495 32 24_Oracle conversion to DB211_John Kruger23_krugerj@ISP.STATE.IL.US31_Fri, 27 Jul 2001 09:22:05 -0500370_us-ascii Greetings fellow practitioners!

Does anyone know of any tools that will unload Oracle tables on the OS/390? Oracle is sooo slooow it takes several days to export (select *) an average row size table containing ONLY 23 million rows. I can almost type faster than that. This must have been designed to keep an Oracle database from being converted. :) [...] 23528 62 53_Re: Temporarary storage allocation failure (00C900A5)13_Olson, Carlos14_COlson@QRS.COM31_Fri, 27 Jul 2001 17:52:34 -0700680_iso-8859-1 You can try to either increase the size of your DSN4Kxx tablespaces or add more of them to DSNDB07 database.

Carlos Olson Database Administrator QRS Corporation



-----Original Message----- From: K.Balaji [mailto:K.Balaji@TARGET.COM] Sent: Friday, July 27, 2001 2:33 PM To: DB2-L@RYCI.COM Subject: Temporarary storage allocation failure (00C900A5)



Hi, I am facing resource problem while I execute my sql in both code & spufi. This sql has 11 joins. Actually there are two tables with a volume of 1000 to 2000 rows which are repeatedly joined in this query. When the sql is executed it says temporary storage is not sufficient to [...] 23591 25 29_V6 upgrade create index fails18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM31_Fri, 27 Jul 2001 21:48:59 -0400478_iso-8859-1 Running DSNTIJSG in upgrade to V6 and get messages

DSNP009I :DSNE THE FOLLOWING ERROR MESSAGES WERE RECEIVED FOR DEFINE CLUSTER ON SYSDSNE.DSNDBC.DSNRLST.DSNARL01.I0001.A001 IGD17219I UNABLE TO CONTINUE DEFINE OF DATA SET SYSDSNE.DSNDBC.DSNRLST.DSNARL01.I0001.A001 IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12

If I use IDCAMS and mimic what I think DB2 is doing, I can create this dataset. We do use SMS. Has anyone seen a problem like this? [...] 23617 42 28_Re: Oracle conversion to DB29_Eric Kwai18_Eric_Kwai@DTCC.COM31_Fri, 27 Jul 2001 20:49:38 -0500569_- John: I know CA has a tool call Fast Unload for Oracle. I do not know if it run on OS390. It may only run on Unix. Hope this helps. Eric On Fri, 27 Jul 2001 09:22:05 -0500, John Kruger wrote:

>Greetings fellow practitioners! > >Does anyone know of any tools that will unload Oracle tables on the OS/390? >Oracle is sooo slooow it takes several days to export (select *) an average >row size table containing ONLY 23 million rows. I can almost type >faster than that. This must have been designed to keep an Oracle >database from [...] 23660 72 33_Re: Problem with Decimal Rounding11_Suresh Sane21_data_arch@HOTMAIL.COM31_Fri, 27 Jul 2001 20:57:56 -0500750_- Phil,

Try doing the calculations to a greater precision by using float. It will be something like:

DECIMAL (FLOAT (your calculations),p,s)

(My syntax may not correct).

HTH.

Suresh

>From: "Philip Nelson (DBA)" >Reply-To: "Philip Nelson (DBA)" >To: DB2-L@RYCI.COM >Subject: Problem with Decimal Rounding >Date: Fri, 27 Jul 2001 20:50:34 +0100 > >We've got a problem with a query / view being affected by DEC(15) rounding. > >The fields are - > >SALES_PRICE DEC(11,2) >PERCENTAGE_FACTOR1 DEC(5,2) >PERCENTAGE_FACTOR2 DEC(5,2) > >The calculation in the view is - > >(SALES_PRICE / 10000) * (PERCENTAGE_FACTOR1 * PERCENTAGE_FACTOR2) > >The division by 10000 [...] 23733 18 33_Re: V6 upgrade create index fails26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Fri, 27 Jul 2001 21:13:02 -0500549_- The RACF user name that you use to run the DB/2 started tasks must have alter to the volumes you're pointing it to. The old way was CLASS FACILITY for $DASDI.vvvvvv (for volume). New way is with DASDVOL, but haven't converted.

Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 23752 78 42_Re: DB2 OS/390 Unload format File into UDB9_Eric Kwai18_Eric_Kwai@DTCC.COM31_Fri, 27 Jul 2001 21:10:30 -0500528_- On Tue, 24 Jul 2001 15:44:45 -0400, Hall, Robert wrote: Hi David:

Assuming this file is not too big :). You may try the following:

1. Load the file into one of your DB2 OS390 table created with the input file format on DB2 390. 2. Login to your UDB Server, connect to DB2 OS390 from your UDB Server 3. export the data from the mainframe and let the export utility do the conversion. 4. Connect to your UDB DB 5. Import the data that you just export from step 3. 6. Have a drink. [...] 23831 17 33_Re: V6 upgrade create index fails26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Fri, 27 Jul 2001 21:16:38 -0500477_- Sorry, I was just about to delete and saw the magic SMS word. We don't use SMS for DB/2, probably need to look at ACS rules for storage group in question.

Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 23849 47 30_Re: Varchar Byte Interrogation18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Sat, 28 Jul 2001 09:23:53 +0530774_- Hi Michael,

This should work..

Select MAX(LENGTH(col_name)) from table.

thanks, Rajendra Deshpande.





>From: "Dempsey, Michael" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Varchar Byte Interrogation >Date: Fri, 27 Jul 2001 16:55:40 -0400 > >Hey Folks... > Does anyone know of a function that will interrogate the 2 byte field >the precedes a varchar column and return the number of bytes that are >actually in that varchar column? I'm trying to determine the largest >number >of bytes for a varchar defined column.. >Thanks.... > >Michael Dempsey >UNC HealthCare > >================================================ >To change your subscription options or to [...] 23897 25 21_I'm out of the office12_Kevin Arnold31_kevin.n.arnold@US.PWCGLOBAL.COM31_Sat, 28 Jul 2001 03:03:33 -0400294_us-ascii This is an automated response, please do not reply.

I've successfully received your email message RE: "DB2-L Digest - 27 Jul 2001 to 28 Jul 2001 (#2001-212)". I am currently out of the office and will return on August 5. I will respond to your message as soon as I return. [...] 23923 73 38_Re: Index access and effect of NLEVELS12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 28 Jul 2001 10:21:01 +0200429_iso-8859-1 Hi, Two reasons for the difference in size: 1. Non-unique vs. unique (it depends on the number of duplicates per key). 2. Different pctfree/freepage. Try to do a runstats with keycard statistics, it may solve your problem without having to "fix" catalog statistics.





Isaac Yassin DBMS & IT Consultant IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 yassini@bezeqint.net [...] 23997 76 53_Re: Temporarary storage allocation failure (00C900A5)15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Sat, 28 Jul 2001 12:00:45 +0200455_us-ascii Increase 4K space, as 1 option. But seriously re-look at the SQL to ensure you have no cartesian products, and that you really need to have the SQL accessing these 2 tables that many times.











"K.Balaji" @RYCI.COM> on 07/27/2001 11:33:11 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...]