I am attempting to tune a DB2 batch job. While this job is > running, (I am using Omegamon to monitor the execution), I see two thread > connections between DB2 and the batch job. The CORRID, AUTHID and CONNID are the > same for both of these threads. I also see separate DB2 Accounting records for > these two threads. My [...] 3857 57 27_Re: DB2 Connection Question19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Fri, 16 Jun 2000 10:11:16 EDT636_us-ascii Pillay/John,

The same thing happens with TMON. When we run a program with degree(any) sometimes an open cursor can trigger off multiple threads. In our case, we saw 10 threads, which I assume are for the 10 partitions into which the table has been split.

Regards,

Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: "Pillay, Venkat (PCA)" , on 06/16/2000 10:06 AM: When your program is bound with degree any then each degree will cut an accounting record. That may be the reason you are seeing two threads. I would suggest [...] 3915 49 19_Re: DB2 Performance19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Fri, 16 Jun 2000 10:20:29 EDT591_us-ascii Charles,

We went from MVS 5 something to OS390 2.7 (I think) and our DB2 (V4 at the time) for some of the programs went to the dogs. On doing an explain, we noticed that all previous I-O parallelism accesses now displayed CP parallelism. Some which had no parallelism and, in fact, used the unique index previously also decided to select CP parallelism. CPU consumption also shot up and some of the batch jobs, inexplicably and unpredictably, hung after running for some time. We were forced to bind everything with DEGEE(1) after which both these symptoms disappeared. [...] 3965 56 41_DB2 Connection Question (additional info)10_John Irwin18_jirwin@COREDCS.COM31_Fri, 16 Jun 2000 09:48:05 -0500349_iso-8859-1 I want to thank anyone who has sent a suggestion for my original question. I must add some additional information, NONE of the Tablespaces used by this process are partitioned. It is my understanding that I can not get/have any parallelism if the Tablespace is not partitioned. I would appreciate any other ideas/information. Thanks. John 4022 25 15_DB2 Performance15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 16 Jun 2000 09:52:10 -0500499_iso-8859-1 Concerning the rumor that DB2 runs slowly under OS/390 2.8, we are upgrading to 2.8 this weekend. Is there anything to that rumor? Has anyone had any bad experiences?

TIA,

Linda Billings Enterprise Systems Programmer Wisconsin Department of Administration Info-Tech Services

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in. we're computer professionals. We cause accidents." - Nathaniel Borenstein [...] 4048 32 45_Re: DB2 Connection Question (additional info)15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 16 Jun 2000 09:56:04 -0500681_iso-8859-1 Hi, John,

What version of DB2 are you running? In V5 the tablespace had to be partitioned but not for V6.

Linda

-----Original Message----- From: John Irwin [mailto:jirwin@COREDCS.COM] Sent: Friday, June 16, 2000 9:48 AM To: DB2-L@RYCI.COM Subject: DB2 Connection Question (additional info)

I want to thank anyone who has sent a suggestion for my original question. I must add some additional information, NONE of the Tablespaces used by this process are partitioned. It is my understanding that I can not get/have any parallelism if the Tablespace is not partitioned. I would appreciate any other ideas/information. Thanks. John [...] 4081 28 42_end users power off, queries keeps running16_Robert Blackwell31_robert.blackwell@PIEDMONTNG.COM31_Fri, 16 Jun 2000 10:59:05 -0400584_us-ascii We have users of query tools that connect to DB2 for OS/390 V5 via DB2 Connect who will power off their terminals to stop a long running query, but the query continues to run in DB2. Then user starts another session and submits the same or a similar query which compounds the problem. Eventually, once the CICS users are impacted enough to raise a red flag, the DBAs or sysprogs will cancel these lost-in-space queries via Omeg/DB2. We were evaluating several query tools recently, and this problem was consistent across all the query tools that used DB2 Connect to get [...] 4110 31 45_Re: DB2 Connection Question (additional info)20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 16 Jun 2000 11:03:30 -0400398_us-ascii How are you running your batch program? Under TMP or it is call attach?

In other words what is the CONNID? Also if you could see the ACE token for both the threads, are they same or different?

-----Original Message----- From: John Irwin [SMTP:jirwin@COREDCS.COM] Sent: Friday, June 16, 2000 10:48 AM To: DB2-L@RYCI.COM Subject: DB2 Connection Question (additional info) [...] 4142 157 42_Can Someone help me Debug and SQL error???15_Joel Zigelstein20_jzigel1@HALLMARK.COM31_Fri, 16 Jun 2000 10:05:32 -05001210_- Hi all ...

I've been of for 5 weeks and my brain is a little rusty ! I can't seem to see what's wrong based on the error. If ya can see it .. please drop me a note!

SELECT STORE.STORE_NUMBER, STORE.STORE_NAME, STORE.STORE_ID, STORE_LOCATION.LOCATION_NAME AS STORE_LOCATION_NAME, STORE_PROVINCE.GST_RATE AS STORE_GST_RATE, STORE_PROVINCE.QST_RATE AS STORE_QST_RATE, STORE_PROVINCE.HST_RATE AS STORE_HST_RATE, LEASE.LEASE_END_DATE, LEASE.LEASE_ID, LEASE.MINIMUM_RENT, LEASE.LEASE_TYPE, LEASE.PERCENTAGE_OF_SALE, LEASE.VENDOR_NUMBER, LANDLORD.LANDLORD_ID, LANDLORD.LANDLORD_NAME, LANDLORD.LOCATION_ID, LOCATION.LOCATION_NAME, LOCATION.UNIT_NUMBER, LOCATION.LOCATION_ADDRESS, LOCATION.LOCATION_CITY, LOCATION.POSTAL_CODE, PROVINCE.PROVINCE_SHORE, VW_MONTHLY_RENT_PA.YEAR_OF_INVOICE, VW_MONTHLY_RENT_PA.MONTH_OF_INVOICE, VW_MONTHLY_RENT_PA.TOTAL_MONTHLY_PAYM, VW_SALES.PERIOD_SALES, ROUND(VW_SALES.PERIOD_SALES * LEASE.PERCENTAGE_OF_SALE/100,2) AS RENT, (CASE WHEN LEASE.LEASE_TYPE = 'Cummulative' THEN (CASE WHEN ROUND((VW_SALES.PERIOD_SALES * LEASE.PERCENTAGE_OF_SALE/100,2) - (CASE WHEN MONTH(EFFECTIVE_DATE)>3 THEN LEASE.MINIMUM_RENT ELSE (LEASE.MINIMUM_RENT + INCREASE.RENT_INCREASE_AMOU) [...] 4300 54 45_Re: DB2 Connection Question (additional info)10_John Irwin18_jirwin@COREDCS.COM31_Fri, 16 Jun 2000 10:21:42 -0500668_iso-8859-1 Linda, They are running DB2 V5. Thanks. John

----- Original Message ----- From: "Billings, Linda" Newsgroups: bit.listserv.db2-l To: Sent: Friday, June 16, 2000 9:56 AM Subject: Re: DB2 Connection Question (additional info)

> Hi, John, > > What version of DB2 are you running? In V5 the tablespace had to be > partitioned but not for V6. > > Linda > > -----Original Message----- > From: John Irwin [mailto:jirwin@COREDCS.COM] > Sent: Friday, June 16, 2000 9:48 AM > To: DB2-L@RYCI.COM > Subject: DB2 Connection Question (additional info) > > > I want to thank anyone who has sent [...] 4355 46 19_Re: DB2 Performance11_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 16 Jun 2000 08:34:52 PDT677_- The company where I am runs DB2 version 5.1 and os/390 v. 2.8. No related problems that I know of. Regards, Rick Creech

>From: "Billings, Linda" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DB2 Performance >Date: Fri, 16 Jun 2000 09:52:10 -0500 > >Concerning the rumor that DB2 runs slowly under OS/390 2.8, we are >upgrading >to 2.8 this weekend. Is there anything to that rumor? Has anyone had any >bad experiences? > >TIA, > >Linda Billings >Enterprise Systems Programmer >Wisconsin Department of Administration >Info-Tech Services > >"The most likely way for the world to be [...] 4402 192 46_Re: Can Someone help me Debug and SQL error???13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Fri, 16 Jun 2000 11:34:33 -0400344_us-ascii Joel:

Let us know what version of DB2 you are using, what platform, and what interface you are using to run the SQL statement.

For example, if this is SPUFI against DB2 for OS/390, verify that all of your SQL statement text occurs in columns 1 thru 72 of the input dataset; stuff in column 73 and beyond is ignored. [...] 4595 177 46_Re: Can Someone help me Debug and SQL error???19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Fri, 16 Jun 2000 11:36:52 EDT430_us-ascii Joel,

I think there should be a ')' before that ',' because the firsrt argument for the rounding function begin with an open parenthesis and needs a closing parenthisis before passing the second argument.

HTH.

Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: "Joel Zigelstein" , on 06/16/2000 11:05 AM: Hi all ... [...] 4773 185 46_Re: Can Someone help me Debug and SQL error???13_Horacio Villa17_hvilla@TTI.COM.AR31_Fri, 16 Jun 2000 12:42:42 -0300471_iso-8859-1 Joel,

you have ROUND((VW_SALES.PERIOD_SALES * LEASE.PERCENTAGE_OF_SALE/100,2) two left parenthesis are following ROUND, so the ',' is not valid. Regards, Horacio Villa TTI S.A. Buenos Aires - Argentina

-----Mensaje original----- De: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]En nombre de Joel Zigelstein Enviado el: Viernes 16 de Junio de 2000 12:06 Para: DB2-L@RYCI.COM Asunto: Can Someone help me Debug and SQL error??? [...] 4959 30 46_Re: Can Someone help me Debug and SQL error???11_Kevin Davis18_kevin.davis@DB.COM31_Fri, 16 Jun 2000 10:41:29 -0600580_us-ascii I think the ) should be removed.

LEASE.PERCENTAGE_OF_SALE/100,2) - (CASE WHEN MONTH(EFFECTIVE_DATE)>3 THEN LEASE.MINIMUM_RENT ELSE (LEASE.MINIMUM_RENT + INCREASE.RENT_INCREASE_AMOU) END) Remove this)

Kevin Davis Sr. Systems Analyst DB2 DBA Deutsche Financial Services 314-523-3742 Kevin.Davis@db.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. 4990 179 46_Re: Can Someone help me Debug and SQL error???9_Mark Ruhe19_Mark.Ruhe@QUEST.COM31_Fri, 16 Jun 2000 08:42:45 -0700568_iso-8859-1 Joel, On first glance the problem seems to point to "ROUND((VW_SALES.PERIOD_SALES * LEASE.PERCENTAGE_OF_SALE/100,2)". I looks like you've added one too many "(" following the ROUND function. The first encounter of ROUND function for "ROUND(VW_SALES.PERIOD_SALES * LEASE.PERCENTAGE_OF_SALE/100,2) AS RENT," looks correct. The others all contain an extra "(".

-----Original Message----- From: Joel Zigelstein [mailto:jzigel1@HALLMARK.COM] Sent: Friday, June 16, 2000 10:06 AM To: DB2-L@RYCI.COM Subject: Can Someone help me Debug and SQL error??? [...] 5170 53 45_Re: DB2 Connection Question (additional info)10_John Irwin18_jirwin@COREDCS.COM31_Fri, 16 Jun 2000 10:54:13 -0500497_iso-8859-1 Pillay, 1) This job is using DB2 Call Attach. 2) I know that both threads were running under the same ASID, but I am not sure that this is the ACE token (I am not sure what this token is). 3) I should mention that this is DB2 V5. Thanks for the help. John ----- Original Message ----- From: "Pillay, Venkat (PCA)" Newsgroups: bit.listserv.db2-l To: Sent: Friday, June 16, 2000 10:03 AM Subject: Re: DB2 Connection Question (additional info) [...] 5224 182 46_Re: Can Someone help me Debug and SQL error???15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Fri, 16 Jun 2000 11:58:06 -0400454_us-ascii Check your parentheses paring. You are probably missing a ) somewhere in your statement. My eyes were spinning trying to match them up. Are there supposed to be 2 ( at each round clause or only 1 ( Bob Lawrence DBA Boscov's Dept Stores Inc

-----Original Message----- From: Joel Zigelstein [SMTP:jzigel1@HALLMARK.COM] Sent: Friday, June 16, 2000 11:06 AM To: DB2-L@RYCI.COM Subject: Can Someone help me Debug and SQL error??? [...] 5407 58 7_UDB SPB15_Sherri Sterling29_sherri.sterling@BPD.TREAS.GOV31_Fri, 16 Jun 2000 12:05:16 -0400452_us-ascii We have a programmer using visual age stored procedure option. This brings up the UDB stored procedure builder and builds a store procedure. Then when this stored procedure is executed connecting to the os/390, we get the following message:

Connections to DB2 OS/390 are not supported for this release. Please select another database management system name or please click Help to see what database managerment systems we support. [...] 5466 89 45_Re: DB2 Connection Question (additional info)20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 16 Jun 2000 13:15:35 -0400567_us-ascii John

It is quite possible that two threads are created while your program runs using implicit connection and PLANs are available with the same name as DBRM name. The ASID will be same because they both are running under the same address space but DB2 assigns different ACE token for different thread. But when parallelism is used there is only one ACE is available in the trace headers for all the accounting records. That is the reason I am asking for ACE token but I am not sure if Omegamon will provide you that value. I would suggest you use [...] 5556 47 31_32K page tablespace question(s)15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 16 Jun 2000 12:58:49 -0500326_iso-8859-1 I have several 32K tablespaces allocated. These tablespaces store imaging objects (through OAM) that are, on average, 50K in size. Each of these documents use 2.07 rows (pages) to store an image. These tablespaces are partitioned so there is a clustering index. I have freepage set to 8 with pctfree set to 0. [...] 5604 59 33_Re: Reorg DB2 Catalog & Directory24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Fri, 16 Jun 2000 13:35:23 -0500534_- Pius,

Did you see the section below from the v51 Utility Guide & Ref? Perhaps this will answer your question.

Dave

-------------------------------------------------------------------------------------------------------------------------------------------------- Phases for Reorganizing the Catalog and Directory: REORG TABLESPACE processes certain catalog and directory table spaces differently from other table spaces; it does not execute the build and sort phases for the following table spaces: [...] 5664 75 16_NULLs in indexes13_OConner, John26_John.OConner@COURTS.WA.GOV31_Fri, 16 Jun 2000 17:20:00 -0700710_iso-8859-1 We discovered an anomaly we think should be reported as a bug. Here are two sql statements that differ only in the choice of COLUMNS in the result set. But one returns zero rows, and the other returns one row!!

=== Example 1 - zero rows returned === SELECT PAD_TYP_CD FROM PAD, AD WHERE PAD_PER_TK = X'1BD8AAE0B6FD0014' AND PAD_TYP_CD = 'MAI' AND PAD_END_EFF_TS IS NULL AND AD_TK = PAD_AD_TK ; ---------+---------+---------+---------+---------+---------+ PAD_TYP_CD ---------+---------+---------+---------+---------+---------+ DSNE610I NUMBER OF ROWS DISPLAYED IS 0 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100 ============================================================ [...] 5740 33 24_SYSCOPY ENTRIES QUESTION12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Fri, 16 Jun 2000 20:42:47 -0400570_ISO-8859-1 Mark,

You described exactly what is happening and your guess is correct that the load does not specify the partition in question. Your description of the results to SYSCOPY are right on target. I find it incredible that IBM has the load utility working like this. While it is definitely easier to code it this way, it is definitely not functionally the correct way. It is equivalent to DB2 setting the change bit on all tablespace pages when a row is inserted into one. I wonder if the third party utilities also do this. I will have to look into [...] 5774 102 20_Re: NULLs in indexes11_Suresh Sane21_data_arch@HOTMAIL.COM29_Fri, 16 Jun 2000 23:27:12 CDT357_- It is certainly reasonable to expect the same answer regardless of the access path. Before jumping to conclusions, however - is the ts & ix consistent? Have you a run a check? Was a LOAD followed by an access(force) done at any point? If the same problem persists after recovering (rebuilding) the index then yes it looks like a bug. But not before. [...] 5877 252 43_Re: Bad Container Path - UDB EE V6.1 on AIX14_Trevor Deadman23_jenny@VMA.TABNSW.COM.AU31_Sun, 18 Jun 2000 18:02:30 +1000450_iso-8859-1 Pierre, When I look at the db2diag.log , there is not much information can tell, it only show that "Container '/dev/rlv0' is not of specified type , Is it because /dev/rlv0 is raw logical device ? if yes , how we can define the raw device for db2? We are using DB2 UDB EE V6.1 on RS/6000 H70 box to handle the data warehouse .. That's why we try to use DEVICE for better performance .. it's for production.. any input will help us .. [...] 6130 340 61_Re: Bad Container Path / DB2 EE V6.1 / Solution & Performance11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Sun, 18 Jun 2000 14:15:05 -0400459_iso-8859-1 Never under estimate the importance of getting names right... in life and with DB2.

Also, the numbers don't add up...

Jenny Huang indicated: > 1. create logical volume: mklv -y rlv0 rootvg 30 > 2. chmod 777 /dev/rlv0

#1 says make a logical volume of type jfs on the rootvg volume group having 30 partitions. We don't know, from info provided, what the PPsize is for the volume group. ... but we have 30 partitions. [...] 6471 33 46_Re: end users power off, queries keeps running12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 19 Jun 2000 10:00:57 +1200590_us-ascii Robert,

Unfortunately I think you might be right, in that it's just something you have to suck up, although I'm quite keen to be proven wrong. We have 2 similar problems here. One is that query users (BO, actually) walk away from their PCs after a successful query and stay connected. This also happens with Control Center (sp.), Command Center (again, not my spelling), etc. This can be - and is - fixed by making the threads active and timing them out. Our other problem was long-running queries that the end-user tires of waiting for and cancels the front-end appl. [...] 6505 16 96_Per-Erik Svennberg/P001890/Nordbanken =?iso-8859-1?q?=E4r?= inte =?iso-8859-1?q?p=E5?= kontoret.15_Pelle Svennberg24_per-erik.svennberg@NB.SE29_Mon, 19 Jun 2000 07:16:50 GMT337_iso-8859-1 Jag är borta från kontoret från 2000-06-19 till 2000-06-26.

har semester (välförtjänt) ===============================================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. 6522 191 60_Re: Bad Container Path / DB2 EE V6.1 /Solution & Performance11_Jenny Huang23_jenny@VMA.TABNSW.COM.AU31_Mon, 19 Jun 2000 18:02:05 +1000560_us-ascii Scott, Thanks for the title , it is much better than mine.. Thank you so much for quick response.. it really help us.. Sure , we are not using rootvg for the production..

Actually We are struggling to implement ONE Tetabyte data warehouse on AIX box ( with 3 CPU ,2G Memory, and 38 disk each with 36G).. I have read the perfomance tuning about how to define the tablespace .. it should gain better performance to separate the data and index on separate disks.. we are using RAID disks, and our unix administrator group the 38 disks into 5 [...] 6714 55 23_Re: NOT CATLG 2 PROBLEM13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Mon, 19 Jun 2000 09:24:00 +0100376_- Dennis

oh yes it definately happens!

I've fallen foul of that one not so long ago and had to use DSN1COPY to get the dataset back.

If you have to use DSN1COPY don't forget to keep the SEGSIZE to same!!

Ian McDonald DB2 DBA Abbey National ---------- From: Dennis Raher To: DB2-L@RYCI.COM Subject: NOT CATLG 2 PROBLEM Date: 15 June 2000 00:50 [...] 6770 24 14_Catalog Reorgs9_Ian Smith18_ismith2@UK.IBM.COM31_Mon, 19 Jun 2000 09:15:57 +0100352_us-ascii ------------------------------------------------------------------------ List,

I want to set up a series of jobs to reorg the catalog (DB2 OS/390 v5.1), My question is can any reorgs on the catalog be run in parallel ? I assume that SYSCOPY must be done stand alone (all other reorgs must update it), but beyond that I'm not sure. [...] 6795 109 18_Re: Catalog Reorgs0_18_mebert@AMADEUS.NET31_Mon, 19 Jun 2000 10:45:19 +0100484_us-ascii Hi Ian,

since the Cat/Dir probably won't be spread across a dozen disk volumes, it's not worth it. You'll only get I/O-contention. SYSCOPY does not have to stand alone (DB2 allows concurrent updates of a table). Only SYSUTILX requires that no other utility runs in the subsystem. See also the numerous emails regarding Cat/Dir reorgs in the archives (mostly around 6 months ago I think) and the JCL I posted on the DB2-L-Documents Listserver as a starting point. [...] 6905 44 21_Starting db2 on Linux11_Daniel Adam15_dadam@GRATEX.SK31_Mon, 19 Jun 2000 05:18:09 -0500686_- Hi all, I installed DB2 6.1 on Linux. I want to start it ( db2start ), but the command hangs - does not return to the prompt. db2diag.log file :

-------------------------- 2000-06-19-11.24.06.700353 Instance:inst01 Node:000 PID:2323(db2star2) Appid:none oper_system_services licRequestAccess Probe:1

SQL8006W The product "DB2 Enterprise Edition" does not have a valid license key installed. If you have licensed this product, please ensure the license key is properly installed. If a license key is not installed, this product will be enabled for a "60" day evaluation period. USE OF THE PRODUCT FOR THE EVALUATION PERIOD CONSTITUTES ACCEPTANCE OF THE TERMS OF THE [...] 6950 23 17_ddf stopping hung18_Campidoglio, Elena29_E.Campidoglio@CEDACRIOVEST.IT31_Mon, 19 Jun 2000 13:31:43 +0200581_- Hi everybody, we have our production ddf (db2 5.1) that hung on saturday afternoon following a stop command (during our weekly saving chain)without any error message. Until that moment on, any start/stop ddf command replies ddf is stopping, but we think is hung.

Any suggestion ?????

My thanks and best regards

Elena

================================================ 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. 6974 74 25_Re: Starting db2 on Linux14_James R. Brown25_brownjr@CI.RICHMOND.VA.US31_Mon, 19 Jun 2000 07:51:36 -0400501_iso-8859-1 Daniel, If you're using RedHat linux 6.1 or higher, there is a fixpack (3 I think) that may correct this. RedHat changed the way they were doing dynamic links (or calls) with their 6.1 code. I experienced the same problem trying to use the Developers edition on RH 6.2. I did not have any luck applying the fixpack, though. After I downloaded and applied the fixpack, it appeared as though no products were installed. Maybe the fixpack must be applied to a "regular" licensed install? [...] 7049 78 25_Re: Starting db2 on Linux14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Mon, 19 Jun 2000 08:02:43 -0400360_iso-8859-1 If you are using Redhat 6.1 or Mandrake look at http://www.db2mag.com/spring00/ziko1.shtml. I had the same problem and instead of applying the fixpack I simply downloaded db2sysc as suggested in the article and that took care of the problem. I could not run db2iupdt after downloading db2sysc but dropping and recreating the instance fixed it. [...] 7128 49 23_Re: NOT CATLG 2 PROBLEM16_Friemel, Norbert24_Friemel@RRZ-KARLSRUHE.DE31_Mon, 19 Jun 2000 14:07:53 +0200571_iso-8859-1 > and using the wrong file in subsequent steps. This is what > would happen if > you used a disk dataset instead of tape, so why sholdn't the > system provide

Not exactly. With 'CATLG_ERR FAILJOB(NO)' (default) the job is failed _only_ if - the dataset is SMS-managed or - there is only 1 eligible disk (e.g. VOL=SER=......) and a dataset with the same name resides on this disk If the dataset is not SMS-managed and there is more than 1 volume available (no VOL=SER=) or the dataset is not on the disk (orphaned catalog record), the job continues [...] 7178 51 21_Re: ddf stopping hung19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 19 Jun 2000 07:45:23 -0500628_iso-8859-1 Elena, VARY the luname for DDF for that DB2 subsystem offline. 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." [...] 7230 29 87_DB2 OS/390 V5.1 Archiving Active Logs. What is optimal size to put on single 3490 tape?0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Mon, 19 Jun 2000 08:49:52 -0400548_us-ascii Hi,

We would like to increase the size of our active logs from 825 cylinders to something larger that would still fit on one (1) 3490 tape. System folks tell us that at least 2 GB uncompressed data could fit onto a tape. We have been running tests where we increased our active logs to 2400 cylinders (2400 cyl * 15 trks/cyl * 49152 bytes/trk = 1.77 GB) yet every single time this goes to 2 - 3 tapes. Our DSNZPARMS are set as BLKSIZE=28672, ALCUNIT = BLK. We eventually decreased to 1200 cylinders for the active log size and [...] 7260 42 21_Re: ddf stopping hung16_Elmer Valenzuela18_elmer@KFUPM.EDU.SA31_Mon, 19 Jun 2000 15:51:16 -0300431_iso-8859-1 This occurred to me twice before. Unfortunately, we had to do an IPL in both occassions. In our case, we tried to do an inact on the major node which had the ddf lu but to no avail. Even doing a stop ddf mode(force) did not work. There was a suggestion posted here before that cancelling IRLM might help. Although I haven't tried that. You may want to check the archive as there were a couple of suggestions given. [...] 7303 42 21_Re: ddf stopping hung16_Elmer Valenzuela18_elmer@KFUPM.EDU.SA31_Mon, 19 Jun 2000 15:51:29 -0300431_iso-8859-1 This occurred to us twice before. Unfortunately, we had to do an IPL in both occassions. In our case, we tried to do an inact on the major node which had the ddf lu but to no avail. Even doing a stop ddf mode(force) did not work. There was a suggestion posted here before that cancelling IRLM might help. Although I haven't tried that. You may want to check the archive as there were a couple of suggestions given. [...] 7346 80 21_Re: ddf stopping hung14_Philip Gunning18_pgunning@PHEAA.ORG31_Mon, 19 Jun 2000 09:07:45 -0400300_us-ascii Elena, It is always good to issue a display thread(*) command when DDF is not coming down. If you have distributed applications, you will have to cancel threads to get it down. Maybe you did this, I'm not sure from your message, but DDF will not come down with threads active. HTH Phil [...] 7427 77 21_Re: ddf stopping hung18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Mon, 19 Jun 2000 09:12:58 -0400426_iso-8859-1 We have had situations where "someone" issued a stop DB2 without canceling the dist threads first. DB2 will sit and wait. If you try to canc the threads after the stop command, DB2 says it's stopping and doesn't act on the canc thread command... and DB2 will sit and wait. In situations where this occurs we have had to cancel the IRLM. That will bring DB2 down. Not graceful, not nice but better than an IPL. [...] 7505 108 21_Re: ddf stopping hung4_IBM116_IBM1@UBIL.COM.TR31_Mon, 19 Jun 2000 16:20:23 +0300434_- was there not a long issue about this whole thing about 3 months ago on the list? check the archives and I am sure you will find it!

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@ubil.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...] 7614 168 90_Re: DB2 OS/390 V5.1 Archiving Active Logs. What is optimal size toput on single 3490 tape?8_Bob Byrd14_BBYRD@PCMH.COM31_Mon, 19 Jun 2000 09:24:01 -0400429_US-ASCII We went through this awhile back and found that 1167 cyls can to near tape capacity for our 810mb tapes (uncompressed). Yes, if compression is used, a larger log file can be used. But we decided not to compress because of possible exposure during recovery. If your 3490 tape drives are like ours then hardware compression is being used. Unless you specify compression in zparms the archive to tape is uncompressed. [...] 7783 24 46_Re: end users power off, queries keeps running13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Mon, 19 Jun 2000 08:12:37 -0500528_- My memory is a little fuzzy, but we had this same problem when we were testing DB2 Connect to see if we wanted to purchase it. We were DB2 OS390 V5.1 and DB2 Connect PE V6 and using IP. I can't remember what OS390 level we were at.

We had several threads connected from DB2 Connect to OS/390 DB2. We would deliberately cancel out of the application and then check to see if the thread was still attached....and it was. I talked to IBM about this problem and they told me to look into IP fixes. Our IP person found [...] 7808 61 30_Re: VisualInfo V2.3 and UDB V612_Kirk Hampton16_khampto1@TXU.COM31_Mon, 19 Jun 2000 09:20:59 -0500623_us-ascii I think I ran into the same problem with a different OAM application, OnDemand/390. It does not matter which DB2 version. It is caused by having the SDSNLOAD library, which contains the DSNALI module, concatenated in a STEPLIB with any other library (probably VisualInfo in your case) which is not APF-authorized. This makes all the libs in the concatenation non-APF-authorized, which apparently causes OAM to issue this bogus (in my opinion) error message. On our test LPAR, I was able to prove this by making our OnDemand library temporarily APF-authorized, and the error went away. Not wanting to have any [...] 7870 80 11_Re: UDB SPB0_15_leon@CA.IBM.COM31_Mon, 19 Jun 2000 10:26:53 -0400680_us-ascii

You will want to get DB2 Connect V7.1 to use Stored Procedure Builder with DB2 for OS/390.

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

Sherri Sterling on 06/16/2000 12:05:16 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: UDB SPB

We have a programmer using visual age stored procedure option. This brings up the UDB stored procedure builder and builds a store procedure. Then when this stored procedure is executed connecting to the os/390, we get the following message: [...] 7951 18 16_Mixed data = YES10_Tom Taylor17_ttaylor@CHUBB.COM31_Mon, 19 Jun 2000 10:54:42 -0400446_us-ascii Hi all

I recieved a request for DBCS to be implemented. Has anyone changed from mixed data NO to mixed data YES? Are there any gotchas? Can DBCS be used against existing tables?

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. 7970 118 21_AW: ddf stopping hung12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 19 Jun 2000 16:55:17 +0200433_iso-8859-1 >>>> cancel the IRLM. That will bring DB2 down.

Sounds a little bit the hard way, or ???? Is there no other way in such a situation ?

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r

-----Ursprüngliche Nachricht----- Von: Bourgoine, Peter A [mailto:Peter.A.Bourgoine@JPFINANCIAL.COM] Gesendet am: Montag, 19. Juni 2000 15:13 An: DB2-L@RYCI.COM Betreff: Re: ddf stopping hung [...] 8089 33 36_Image processing [in V5 for OS/390?]13_Michalik, Ken19_kmichalik@KRAFT.COM31_Mon, 19 Jun 2000 10:11:08 -0500571_- We have an application that wants to do this in some database engine. I've been told to investigate DB2 capabilities. It seems that V6 was just meant for this with its BLOBs, but we won't be there for 3-5 months.

Without thinking about it, it looks like table(s) in 32K buffer pool storing a series 1 or more of variable length rows containing bit data per object instance that has to be mashed together by the application and fed to some software that will create an image from it, and a separate table containing the text/numeric attributes of the object [...] 8123 23 40_Re: Image processing [in V5 for OS/390?]13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Mon, 19 Jun 2000 11:18:08 -0400595_iso-8859-1 An IBM showcase : http://www.hermitage.ru/fcgi-bin/db2www/browse.mac/category?selLang=English

Allows the use of shape and colour specifications in image retrieval (DB2-driven, natch).

Gregg

-----Original Message----- From: Michalik, Ken [mailto:kmichalik@KRAFT.COM] Sent: Monday, June 19, 2000 11:11 AM To: DB2-L@RYCI.COM

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 8147 157 21_Re: ddf stopping hung18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Mon, 19 Jun 2000 11:23:46 -0400269_iso-8859-1 I don't know of any other way to do it. It's hard on DB2 but we have been successful (lucky) bringing DB2 down when were in the DDF/dis thread/stop DB2 quandary. The best thing, of course, is to be sure you have no dist threads when you issue the stop. [...] 8305 24 7_DSNTIAR14_Mark McCormack27_mamccormack@STATESTREET.COM31_Mon, 19 Jun 2000 11:05:07 -0400354_US-ASCII Are there any restrictions on programs which can call subroutine DSNTIAR ? For example, can it be called from a program invoked from a CICS transaction, or can it be called from a stored procedure ?

I have read the material on DSNTIAR in the Application Programming and SQL Guide, and it does not appear that there are restrictions. [...] 8330 21 11_Re: DSNTIAR13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Mon, 19 Jun 2000 11:37:08 -0400592_iso-8859-1 Check your DB2 manuals for reference to DSNTIAC - specifically, "If your CICS application requires CICS storage handling, you must use the subroutine DSNTIAC instead of DSNTIAR."

Gregg

-----Original Message----- From: Mark McCormack [mailto:mamccormack@STATESTREET.COM] Sent: Monday, June 19, 2000 11:05 AM To: DB2-L@RYCI.COM

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 8352 18 41_Re: DB2-l Archives >was ddf stopping hung13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 19 Jun 2000 12:48:18 -0400458_iso-8859-1 >>Question 2: >>I'm new to the listserv. Where are the archives? http://jupiter.ryci.com/archives/db2-l.html

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. 8371 73 41_Stored Procedure Builder with UDB 6.1 ???12_Randy Wilson22_Randy_Wilson@BCBST.COM31_Mon, 19 Jun 2000 12:54:27 -0400505_iso-8859-1 Hello list, I'm reading the DB2 UDB v6.1 for Unix certification guide and on page 940 there is a reference to a graphical application to aid in rapid development of stored procedures called the Stored Procedures Builder(SPB) ... yet, I find no reference to this in my UDB manuals or an option to select the SPB from any of my other client tools. Any Idea where SPB lives? ... or if it's really included with v6.1 for AIX TIA, Randy Wilson BlueCross BlueShield of Tennessee, Inc. DRM , ext. 3675 8445 43 26_moving active log datasets0_33_charles.t.schopf@BELLATLANTIC.COM31_Mon, 19 Jun 2000 12:57:26 -0400478_us-ascii Hi,

I need to change the placement of my active log datasets and I have a process question. Currently our active log datasets are placed like this:

PACK01 PACK02 PACK03 DS01 DS04 DS07 DS02 DS05 DS08 DS03 DS06 DS09

All of the datasets are sized at 1100 cyls each. We got into this situation because our SMG team insisted that dataset placement was not important due to hardware technology. I would like to change the dataset placement to this: [...] 8489 75 30_Re: moving active log datasets13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Mon, 19 Jun 2000 10:12:58 -0700426_iso-8859-1 Hi!

I don't think you need to change anything in BSDS for that. ADRDSSU is just fine but probably you will have to bring down DB2 as active logs remain allocated to DB2 exclusively.

Ashish.

-----Original Message----- From: charles.t.schopf@BELLATLANTIC.COM [SMTP:charles.t.schopf@BELLATLANTIC.COM] Sent: Monday, June 19, 2000 9:57 AM To: DB2-L@RYCI.COM Subject: moving active log datasets [...] 8565 60 92_Re: DB2 OS/390 V5.1 Archiving Active Logs. What is optimal size t o put on single 3490 tape?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 19 Jun 2000 08:42:55 -0500606_iso-8859-1 Hi Ed, Your problem may be incorrect BLKSIZE. If your active logs are on 3390 logical devices then the BLKSIZE should be 24576. This would account for the wasted tape.

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 [...] 8626 85 30_Re: moving active log datasets23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Mon, 19 Jun 2000 13:40:00 -0400327_- Chuck,

I have moved active log datasets using ADRDSSU. DB2 has to be down for that. I had done this to separate LOGCOPY1 & 2 from same volume. I am just curious, how is the new setup any better than the current one ? I can see some performance improvement during log switch. Is there anything else I am missing ? [...] 8712 83 30_Re: moving active log datasets10_Beck, Norm18_Norm.Beck@NIKE.COM31_Mon, 19 Jun 2000 10:45:22 -0700495_us-ascii Chuck,

It looks like you are trying to move the logs so that DB2 will not be offloading one and using another on the same volume. There is more involved though just the name of the log file. There is no requirement that DB2 uses DS02 when DS01 is full. I just took a quick look at some of our subsystems and with 5 logs, they are used in order: 1, 2, 4, 5, 3. In another, with 10 logs, they are used in order: 1, 5, 6, 7, 8, 9, 10, 2, 4, 3. Then, to even further complicate [...] 8796 74 30_Re: moving active log datasets12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Mon, 19 Jun 2000 10:49:08 PDT325_- Charles:

You're right. You must bring db2 down and then execute ADRDSSU to move your active log's to those volumes and the order that you want to. You have to keep in mind bypass acs routines if you on your site use SMS to relocate the dataset where you really want. This way you won't have any problem at all. [...] 8871 100 45_Re: Stored Procedure Builder with UDB 6.1 ???0_25_pierre.evans@AUTOZONE.COM31_Mon, 19 Jun 2000 13:30:35 -0500339_us-ascii

Randy, The Stored Procedure Builder referred to in the Certification Guide does indeed exist in v6.1- it resides on the client side. I've performed several rudimentary tests using the SPB on my winnt pc connected to a UDB EEE v6.1 Data Warehouse on AIX. Look on the Programs panel, listed under 'DB2 for Windows NT'. [...] 8972 119 30_Re: moving active log datasets0_33_charles.t.schopf@BELLATLANTIC.COM31_Mon, 19 Jun 2000 14:39:10 -0400577_us-ascii Thanks for all of your responses. For those of you that had questions regarding the benefit of what I am trying to accomplish, I didn't paint the entire picture. So let me do so now...

We have always used dual logging and we have always kept the logcopy1 datasets on their own packs and the logcopy2 datasets on their own packs. With our current configuration we are running into DASD contention (boy was SMG surprised but I wasn't) whenever a log switch is performed that involves datasets on the same DASD volume. For example, when DS01 is active and it [...] 9092 85 19_Re: DB2 Performance17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM31_Tue, 20 Jun 2000 12:06:04 -0700342_us-ascii Hi Leslie,

Yes we do use RMF but we only implemented 2.8 recently and as of yet there is no DB2 on the lpar. People have heard that there were performance problems with DB2 on OS/390 2.8 and we are attempting to verify this.

If you have any rmf comparison data we would definitely be interested as to the results. [...] 9178 116 19_Re: DB2 Performance0_33_charles.t.schopf@BELLATLANTIC.COM31_Mon, 19 Jun 2000 15:13:22 -0400678_us-ascii What release of DB2 are we talking about?

Chuck

"Charles Jambrosic" on 06/20/2000 03:06:04 PM

Please respond to "DB2 Data Base Discussion List"

To: DB2-L@RYCI.COM

cc: (bcc: CHARLES T. SCHOPF/EMPL/PA/Bell-Atl)

Subject: Re: DB2 Performance

Hi Leslie,

Yes we do use RMF but we only implemented 2.8 recently and as of yet there is no DB2 on the lpar. People have heard that there were performance problems with DB2 on OS/390 2.8 and we are attempting to verify this. [...] 9295 143 19_Re: DB2 Performance17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM31_Tue, 20 Jun 2000 12:23:30 -0700594_us-ascii We would be using V5.1 for now but we didn't hear if the problems were attributed to any specific DB2 version.

charles.t.schopf@BELLATLANTIC.COM on 06/19/2000 12:13:22 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Charles Jambrosic/CSI)

Subject: Re: DB2 Performance

What release of DB2 are we talking about?

Chuck

"Charles Jambrosic" on 06/20/2000 03:06:04 PM [...] 9439 157 30_Re: moving active log datasets11_rick creech18_ykcirc@HOTMAIL.COM29_Mon, 19 Jun 2000 12:27:32 PDT440_- DB2 will use the logs in the order that they are defined, irrespective of the names. You can delete logs and re-create them in the correct order. Of course, you may wish to keep the log data, which will require some additional work of copying log data and updating he BSDS. Information about exactly how to re-create log datasets can be found in DB2 manuals - a similar process can to be done for resizing the logs. hth, Rick Creech [...] 9597 85 45_Re: Stored Procedure Builder with UDB 6.1 ???0_15_leon@CA.IBM.COM31_Mon, 19 Jun 2000 16:31:25 -0400433_us-ascii

Randy, in v6.1 Stored Procedure Builder is installed on Windows workstations only and is not installed on AIX. This means that you need to use Windows 95, 98, NT, or 2000 as your development workstation (AIX will still be your database server).

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

Randy Wilson on 06/19/2000 12:54:27 PM [...] 9683 110 45_Re: Stored Procedure Builder with UDB 6.1 ???12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 19 Jun 2000 13:47:25 -0700576_us-ascii I sure can't find any reference to building stored procedures in my 6.1 online doc, nor can I find it going down the Start--->Programs--->DB2 for Win NT path. From where do you launch it? Tim --- leon@CA.IBM.COM wrote: > > > Randy, in v6.1 Stored Procedure Builder is installed > on Windows > workstations only and is not installed on AIX. This > means that you need to > use Windows 95, 98, NT, or 2000 as your development > workstation (AIX will > still be your database server). > > Leon Katsnelson, DB2 Connect Development Manager > mailto:leon@ca.ibm.com > [...] 9794 20 7_UQ3840512_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Mon, 19 Jun 2000 16:31:06 -0500496_iso-8859-1 Is anyone having issues with UQ38405? It is supposed to be providing support for the Identity Column. Is seems to have altered the behavior of DSNHPC, effecting the manor in which it is loaded.

Gerald Hodge HLS Technologies 888-494-9019

================================================ 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. 9815 32 29_DB2 UDB Performance with BLOB11_Wang, Jason23_jason.wang@CHECKSOL.COM31_Mon, 19 Jun 2000 16:39:52 -0500393_iso-8859-1 Hi all,

I am currently conduct a DB2 UDB 6.1 performance test on an OS390 2.7 system. We have defined a base DB2 table with a BLOB column of 49152 bytes. Then from our DB2 appl program, we are writing out a buffer data repeatedly to load 5000 rows of data into the table (commit rate 100 rows/per commit). The best number I can come up with is about 49 rows per second. [...] 9848 27 11_Re: UQ3840513_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 19 Jun 2000 17:46:59 -0400394_iso-8859-1 Hello Gerald,

I believe I'm one of the original interested parties for UQ38405. I had a couple problems open with IBM trying to use the "overriding user value" clause, and then using the Identity clause.

UQ38405 was the PTF resolving the above problems.

We've had UQ38405 on for a few weeks on our beta machine and haven't run into any Precompile problems. [...] 9876 151 21_Re: ddf stopping hung19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 19 Jun 2000 10:31:50 -0500629_iso-8859-1 Georg, I don't know of any better way. I have stopped DB2 by canceling aaaaIRLM many times without problems thus far.

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, [...] 10028 128 20_Re: NULLs in indexes13_OConner, John26_John.OConner@COURTS.WA.GOV31_Mon, 19 Jun 2000 15:05:34 -0700566_iso-8859-1 Thanks Suresh, I just opened a PMR with IBM on this. The tables that I am currently using for testing, are not the same tables where the problem originally occurred. My test tables are copies of the original tables. And I did a dsntiaul/load of the data to the new tables, so the load would have rebuilt the indexes. Just to be sure, I also tried testing after reorging the tables. I also performed CHECK INDEX and found no errors. Still the two queries below produce the results indicated below. (When the problem was first reported to me, we tried [...] 10157 52 28_DB2 Program Execute in CICS.17_Armando Zaporteza25_azaporte@CI.PHOENIX.AZ.US31_Mon, 19 Jun 2000 15:18:20 -0700454_US-ASCII Hello List,

I have scenario that I would like to run through the group and hopefully to get some answers to tell my boss what's really happening behind the scenes or How the connection/tie is done.

Given: Program = ABC100 = DB2, CICS Online Program

ABC100T = ABC.DBRMLIB.DATA

ABC100T = PLAN/MEMBER name

1. Program Compiled/Linked using the above information, Load module = ABC100 in TEST.LOADLIB. [...] 10210 75 32_Re: DB2 Program Execute in CICS.13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Mon, 19 Jun 2000 15:24:24 -0700427_iso-8859-1 Through the RCT. You can either tie the transaction to the plan by defining an entry thread or code a generic exit so that plan name is a ' derived ' one ; it is all there in RCT.

Ashish.

-----Original Message----- From: Armando Zaporteza [SMTP:azaporte@CI.PHOENIX.AZ.US] Sent: Monday, June 19, 2000 3:18 PM To: DB2-L@RYCI.COM Subject: DB2 Program Execute in CICS. [...] 10286 96 32_Re: DB2 Program Execute in CICS.17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Tue, 20 Jun 2000 00:29:30 +0200564_us-ascii Yes, if you are running CICS just to 4.3; in CICS TS You have to define a DB2ENTRY (in CSD using CEDA), generic or specific, depend ...

HTH Alessandro

>Through the RCT. You can either tie the transaction to the plan by defining >an entry thread or code a generic exit so that plan name is a ' derived ' >one ; it is all there in RCT. > >Ashish. > > > > > > -----Original Message----- > From: Armando Zaporteza [SMTP:azaporte@CI.PHOENIX.AZ.US] > Sent: Monday, June 19, 2000 3:18 PM > To: DB2-L@RYCI.COM > Subject: DB2 Program Execute in [...] 10383 124 32_Re: DB2 Program Execute in CICS.17_Armando Zaporteza25_azaporte@CI.PHOENIX.AZ.US31_Mon, 19 Jun 2000 15:48:33 -0700391_US-ASCII HTH, Ashish;

Thanks a lot for the quick response. It's still cloudy/unclear at this end.

I Used SQL BIND PLAN with ADD RETAIN(This is a new Plan), Was able to test the program successfully.

Still, if I'm understanding what your saying Defining DB2entry and CEDA, HOW did my plan got into RCT? or when was the connection happened between CICS and the Plan? [...] 10508 178 32_Re: DB2 Program Execute in CICS.13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Mon, 19 Jun 2000 16:16:03 -0700472_iso-8859-1 As I said, for transactions and plans not explicitly defined in RCT, plan name is derived dynamically at the transaction run time from the program name. This is done using an exit (which you could find under the TYPE=POOL entry in your RCT).

The resolution of plan name takes place when first SQL is encountered while your CICS transaction is executing. A thread (DB2-CICS) is formed at this point as a means of communication between DB2 and CICS . [...] 10687 157 32_Re: DB2 Program Execute in CICS.13_Frank Irizawa19_frank@LECCOTECH.COM31_Mon, 19 Jun 2000 16:16:50 -0700419_iso-8859-1 The "CICS Attach" interface does the cross-memory communication with the DB2 address space. DB2 has the Plan info, so when the CICS/DB2 program executes (EXEC SQL) in the CICS address space, the CICS Attach creates a thread with DB2 to associate the plan with the CICS program.

Regards,

Frank Irizawa Principal Systems Engineer LECCO Technology, Inc. 415 438-2387 http://www.leccotech.com [...] 10845 134 45_Re: Stored Procedure Builder with UDB 6.1 ???0_15_leon@CA.IBM.COM31_Mon, 19 Jun 2000 19:38:57 -0400494_us-ascii When you were installing your DB2 software on Windows NT, did you choose to install DB2 SDK or something like that? Do you have sqllib\bin\db2spb.exe on your machine?

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

tim malamphy on 06/19/2000 04:47:25 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Re: Stored Procedure Builder with UDB 6.1 ??? [...] 10980 61 32_Re: DB2 Program Execute in CICS.7_Sanjeev19_Sanjeev@INTERRA.COM31_Tue, 20 Jun 2000 08:57:27 +0530565_iso-8859-1 Ashish , I totally agree with the point you made about the exit routines which does the dynamic plan selection and after that the thread is established with DB2. Still i would like to clarify some points below : 1) When the exit routine is actually invoked ??. I believe tried at SYNCHPOINT and if it is not there then at first SQL call...(may be wrong). 2) Resolution of plan name takes place when first SQL is encountered, it seems this indicates that plan name selection is done at the first SQL encountered.I just want to think about an example [...] 11042 20 20_R: ddf stopping hung18_Campidoglio, Elena29_E.Campidoglio@CEDACRIOVEST.IT31_Tue, 20 Jun 2000 08:54:53 +0200254_- Thank you to all who replied to my question. Last night, we decided to stop db2 (as a matter of fact we had to cancel it) and then restart it. Everything went on ok . Probably there is some maintenance we need to put on, now I'll check it better. [...] 11063 23 38_Control Center - Add System won't work11_Daniel Adam15_dadam@GRATEX.SK31_Tue, 20 Jun 2000 02:05:17 -0500299_- Hi all, DB2 UDB 6.1 on WinNT 4.0 sp6a In Control Center, right click on Systems - Add. Nothing happens and CC hangs. I have to kill it and restart service "DB2 JDBC Applet Service - Control Center" in order to run CC again. Other cc functions seem to work fine - viewing local databases etc. [...] 11087 20 24_Diff between UDB and DB212_Elster Gomes19_elsterg@HOTMAIL.COM29_Tue, 20 Jun 2000 01:47:30 PDT485_- Hi all

Would like to know the differences between UDB and DB2

Regds Elster

________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 11108 38 16_Re: V6 Red books15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK31_Tue, 20 Jun 2000 09:54:55 +0100401_iso-8859-1 Hi Rob, The -01 version I find on the IBM Book Library has a date of March 1998 and is the one I have (i.e. it covers DB2 V4 & 5 for MVS). I still haven't managed to find anything more current. Thanks Keith

----- Original Message ----- From: Rob Crane To: Keith Phimister Sent: 15 June 2000 22:57 Subject: V6 Red books [...] 11147 34 42_Re: Control Center - Add System won't work11_Daniel Adam15_dadam@GRATEX.SK31_Tue, 20 Jun 2000 04:30:14 -0500559_- It was indeed ODBC version problem. Installing MS DAC 2.5 cured it. I love this game. D.

On Tue, 20 Jun 2000 02:05:17 -0500, Daniel Adam wrote:

>Hi all, >DB2 UDB 6.1 on WinNT 4.0 sp6a >In Control Center, right click on Systems - Add. Nothing happens and CC >hangs. I have to kill it and restart service "DB2 JDBC Applet Service - >Control Center" in order to run CC again. >Other cc functions seem to work fine - viewing local databases etc. > >Has anyone experienced this ? How to get by ? >During installation I got 2 [...] 11182 106 68_Central PA DB2 Users Group Meeting Agenda - June 29th - Registration10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Tue, 20 Jun 2000 07:04:31 -0400450_us-ascii Please drop me an email if you are planning to attend the FREE meeting. Below is the complete agenda. Tks! Seeya

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

Below is the agenda for the June 29th Central PA DB2 Users Group Meeting. It can also be found on our website: http://www.db2parug.org. As usual, the event is FREE to anyone who would like to attend. [...] 11289 49 32_DB2 vs WLM For Stored Procedures15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK31_Tue, 20 Jun 2000 12:19:32 +0100269_iso-8859-1 Does anyone know of any good papers or reference material about the relative merits of DB2 versus WLM stored procedure address spaces. I am looking for a plain English, middle to high level discussion on why one should be used against the other.

Keith 11339 33 28_Re: Diff between UDB and DB218_Rajesh Kumar Sinha24_rksinx@LOT.TATASTEEL.COM29_Tue, 20 Jun 2000 11:31:29 GMT625_us-ascii Pls specify, you would like to know difference between OS390/UDB or UDB on NT/UNIX. DB2 V6 is launched as UDB on OS390. Concepts of I/O, logging, Bufferpool handling, Hyper pool handling are same. The biggest advantages with UDB would be following :- Control centre for DB administration Replication support Dynamically change checkpoint frequency Large virtual storage 8KB and 16 KB page size Tracker site for disaster recovery. BLOB & CLOB support Better integration of DB2 and work load manager Stored procedure can call another stored procedure. Triggers JDBC support Web development support using Net.data [...] 11373 28 38_DB2 OS/390 V6.1 Archiving Active Logs.0_29_paul.packham@POSTOFFICE.CO.UK31_Tue, 20 Jun 2000 12:56:43 +0000559_us-ascii Hi ,

We have just started to change our strategy and are starting to archive to DASD rather than tape. So far its working OK, but we are having some serious discussions with our storage guys about the optimum size to have our active logs (therefore our archive logs) to ensure that the disk space we archive to is used to its maximum. The archive DASD pool is SMS managed. How do we best manage these disks to ensure we don't get fragmentation. This could happen for example after a -ARCHIVE LOG command was issued and the active was not [...] 11402 185 21_Re: ddf stopping hung11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Tue, 20 Jun 2000 07:05:11 -0500596_iso-8859-1 How about doing a stop db2 mode(force) before cancelling IRLM? That would be less destructive.

Tina

> -----Original Message----- > From: Bourgoine, Peter A [SMTP:Peter.A.Bourgoine@JPFINANCIAL.COM] > Sent: Monday, June 19, 2000 10:24 AM > To: DB2-L@RYCI.COM > Subject: Re: ddf stopping hung > > I don't know of any other way to do it. It's hard on DB2 but we have been > successful (lucky) bringing DB2 down when were in the DDF/dis thread/stop > DB2 quandary. The best thing, of course, is to be sure you have no dist > threads when you issue the stop. > > Question [...] 11588 32 73_Re: Central PA DB2 Users Group Meeting Agenda - June 29th - Regis tration15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Tue, 20 Jun 2000 08:30:03 -0400484_iso-8859-1 Cathy,

I plan on attending the June 29th meeting. Then I'm off to be back the rebel invasion ;)

Bill Blaney

-----Original Message----- From: Cathy Peck [mailto:cathy.peck@HIGHMARK.COM] Sent: Tuesday, June 20, 2000 7:05 AM To: DB2-L@RYCI.COM Subject: Central PA DB2 Users Group Meeting Agenda - June 29th - Registration

Please drop me an email if you are planning to attend the FREE meeting. Below is the complete agenda. Tks! Seeya [...] 11621 24 13_EXIT IRR@XACS12_Mabel Blanco21_MMabbell@NETSCAPE.NET31_Tue, 20 Jun 2000 08:49:59 -0400385_us-ascii Hi listusers!

Has anyone of you done a conversion from DB2 internal security to RACF using the exist IRR@XACS ? I would like to know your experiencies about this. Any input in this regard would be a great help.

Thanks in advance.

Mabel

---------- Get your own FREE, personal Netscape Webmail account today at http://home.netscape.com/webmail/ [...] 11646 27 23_FIC's DISASTER/RECOVERY34_=?iso-8859-1?Q?Gra=E7a_Fernandes?=22_graca.fernandes@CGD.PT31_Tue, 20 Jun 2000 14:24:16 +0100552_iso-8859-1 Hello all:

We're setting up a backup site for disaster recovery with a DB2 environment. The FIC's are catalogued and are one cartridges. We'd like to copy them (after they're made) to other cartridges to take to the backup site. We'de also like them to have the same name in both sites (the Dsname is registred in the DB2 catalog), but associated with different cartridges (the replicated cartridge set has a different range). Does anyone know a procedure to acomplish this? Even if this take a third-party application to do it. [...] 11674 138 20_Re: NULLs in indexes10_Greg Jonas21_gjonas@CP-DEMO.CP.NET31_Tue, 20 Jun 2000 06:26:32 -0700326_- We have had similar problems at our site, but all have thus far been linked to parallelism and have only occurred with partitioned tablespaces. If we turn off parallelism, we get correct results.

Are you running with DEGREE(ANY)? If so, it would be interesting to see if you get the same results with DEGREE(1). [...] 11813 209 21_Re: ddf stopping hung18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Tue, 20 Jun 2000 09:49:23 -0400348_iso-8859-1 Hi Tina, Canceling the IRLM is done when we have issued a stop and, for some reason like we didn't kill dist threads, DB2 is not coming down. At that point it's too late. If you issue a stop/force DB2 will respond with stop already in process. If DB2 appears to be hung and you haven't issued a stop, stop/force could be an option. [...] 12023 41 27_Re: FIC's DISASTER/RECOVERY11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 20 Jun 2000 09:56:15 -0400657_ISO-8859-1 If you are on DB2 for OS/390, why not use the RECOVERYDDN parameter of the Copy utility to create your remote site copies at the same time as the local site copies?

Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner

Message text written by DB2 Data Base Discussion List >Hello all:

We're setting up a backup site for disaster recovery with a DB2 = environment. The FIC's are catalogued and are one cartridges. We'd like to copy them = (after they're made) to other cartridges to take to the backup site. We'de also like them to have the same name [...] 12065 52 27_Re: FIC's DISASTER/RECOVERY20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 20 Jun 2000 10:18:46 -0400435_iso-8859-1 If you don't want to use RECOVERDDN option along with the main copy then I could suggest BMC COPY PLUS. Copy plus has COPY IMAGECOPY option. This takes an imagecopy as input and generates another copy along with an entry in the SYSIBM.SYSCOPY.

-----Original Message----- From: Graça Fernandes [SMTP:graca.fernandes@CGD.PT] Sent: Tuesday, June 20, 2000 9:24 AM To: DB2-L@RYCI.COM Subject: FIC's DISASTER/RECOVERY [...] 12118 71 36_Re: DB2 vs WLM For Stored Procedures12_Kirk Hampton16_khampto1@TXU.COM31_Tue, 20 Jun 2000 09:21:46 -0500569_us-ascii

I don't have a reference handy, but based on what we have experienced at our shop and what I have seen presented at IDUG and the IBM Tech Conferences, there should be no question that WLM- managed stored procedure address spaces is the only way to go for a long-term solution. All of the new capabilities and enhancements are being made there. I believe that Java stored procedures require it. Purely the fact that it was the only way to place different stored procedures into separate address spaces was sufficient for us to go with WLM. [...] 12190 37 18_downloading db2 v74_IBM116_IBM1@UBIL.COM.TR31_Tue, 20 Jun 2000 17:58:14 +0300313_- hello list,

I may be a bit thick, but this adternoon I spent almost 1 hour trying to download db2/pc v. 7 from the ibm site.

my real and true problem is I COULD NOT FIND THE START DOWNLOAD button. I just kept on clicking on all sorts of links and switching back and forth among 4-5 pages.... [...] 12228 22 31_Re: ESS/Shark DASD expectations18_16_ibm1@UBIL.COM.TR31_Tue, 20 Jun 2000 09:48:04 -0500452_- well that's it, it is finally out!!!

I am afraid I did say one wrong thing, it is a VERY TRUMPED UP Flashcopy (and not Snapshot as I had asserted in my last mail), but it is out, and being delivered to customers "while we are reading this".

plese do not take the sentence in inverted commas too literally. fact is, the NEW Flashcopy for ESS/Shark was finally released on 16 June and deliveries will be completed within July, next. [...] 12251 166 45_Re: Stored Procedure Builder with UDB 6.1 ???12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 20 Jun 2000 08:22:32 -0700622_us-ascii Couldn't find db2spb.exe anywhere. Guess I need to re-install and pay attention this time. Thanks for the tip. --- leon@CA.IBM.COM wrote: > When you were installing your DB2 software on > Windows NT, did you choose to > install DB2 SDK or something like that? Do you have > sqllib\bin\db2spb.exe > on your machine? > > Leon Katsnelson, DB2 Connect Development Manager > mailto:leon@ca.ibm.com > > > tim malamphy on 06/19/2000 > 04:47:25 PM > > Please respond to DB2 Data Base Discussion List > > > To: DB2-L@RYCI.COM > cc: > Subject: Re: Stored Procedure Builder with [...] 12418 34 50_Managing Linux DB2 from WinNT using Control Center11_Daniel Adam15_dadam@GRATEX.SK31_Tue, 20 Jun 2000 10:22:28 -0500452_- Hi all, I'm using Control Center (CC) from WinNT to manage DB2 on Linux. I encounter following problems:

1.) Right click on instance name, select Applications -> CC hangs. On Linux, following is written into db2diag.log:

2000-06-20-15.45.37.411192 Instance:inst01 Node:000 PID:7129(db2genp) Appid: base_sys_utilities sqlecgen_getproinfo Probe:13 DIA7500E Error encountered in the Generator. Return code from "caProIfInit" was "1". [...] 12453 115 32_Re: DB2 Program Execute in CICS.13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Tue, 20 Jun 2000 08:40:49 -0700559_iso-8859-1 Sanjeev,

Hi ! Your second point can easily be checked by executing transaction through CEDF. I don't have access to CICS here ; if you do, please verify and let me know the results.

Whether or not a thread is formed at SYNCHPOINT , I believe is of academic interest (though still worth to clarify) . The real reason , I think why SYNCHPOINT can be coded at the beginning of each program is because if this program is 'called' by some other program , and both programs are bound to their own plans and because a plan is allocated [...] 12569 171 20_Re: NULLs in indexes13_OConner, John26_John.OConner@COURTS.WA.GOV31_Tue, 20 Jun 2000 08:49:05 -0700550_iso-8859-1 Thanks Greg, right on target! Did you report this to Ibm? If so, what was the response? The use of parallelism shouldn't change the result set, should it?

-----Original Message----- From: Greg Jonas [mailto:gjonas@CP-DEMO.CP.NET] Sent: Tuesday, June 20, 2000 6:27 AM To: DB2-L@RYCI.COM Subject: Re: NULLs in indexes

We have had similar problems at our site, but all have thus far been linked to parallelism and have only occurred with partitioned tablespaces. If we turn off parallelism, we get correct results. [...] 12741 55 17_Re: EXIT IRR@XACS11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Tue, 20 Jun 2000 09:52:43 -0500328_us-ascii Hi, Mabel we have converted to RACF Security (OS/390 2.6, DB2 6.1). RACF can not handle "all" DB2 commands. What RACF can not handle is documented in the RACF books. We use the following exit and are pleased with RACF security: DSNX@XAC TITLE 'RACF/DB2 External Security Module - Symbols'

Good Luck!... : ) [...] 12797 53 31_Re: ESS/Shark DASD expectations9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Tue, 20 Jun 2000 16:56:26 +0100492_iso-8859-1 Definitely interested.

Thanks, Jim.

-----Original Message----- From: [mailto:ibm1@UBIL.COM.TR] Sent: 20 June 2000 15:48 To: DB2-L@RYCI.COM Subject: Re: ESS/Shark DASD expectations

well that's it, it is finally out!!!

I am afraid I did say one wrong thing, it is a VERY TRUMPED UP Flashcopy (and not Snapshot as I had asserted in my last mail), but it is out, and being delivered to customers "while we are reading this". [...] 12851 19 31_v6 pre-reqs and or v5 put level10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 20 Jun 2000 12:56:53 -0400432_us-ascii Hi all

Should I roll up to a put level and included v6 pre-reqs or put on v6 pre-reqs and just what is needed to support them

Which put level is recommended

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. 12871 91 45_Re: Stored Procedure Builder with UDB 6.1 ???12_Randy Wilson22_Randy_Wilson@BCBST.COM31_Tue, 20 Jun 2000 13:01:32 -0400423_iso-8859-1 Thanx all for the response to my question and giving me places to look and ... I've found it finally... it's in the SDK for UDBv6.1 ... doesn't come with the administration or runtime clients. I downloaded the SDK from IBM, installed it, and it has it in there... I've also seen reference stating that Visual Age Java , and MS Visual Studio also have the capability to create stored procedures graphically. [...] 12963 99 45_Re: Stored Procedure Builder with UDB 6.1 ???0_15_leon@CA.IBM.COM31_Tue, 20 Jun 2000 13:21:25 -0400446_us-ascii

>I've also seen reference stating that Visual Age Java , >and MS Visual Studio also have the capability to >create stored procedures graphically.

I think what you saw are references to the fact that DB2 Stored Procedure Builder hooks itself in to both Microsoft Visual Studio and IBM VisualAge for Java. This allows application programmers to do entire development without leaving their favorite environment. [...] 13063 48 11_Re: UQ3840512_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Tue, 20 Jun 2000 12:28:09 -0500562_iso-8859-1 The error was found and is attributed to user error in implementing the fix.

Thank you for your response.

GSH

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Seibert, Dave Sent: Monday, June 19, 2000 4:47 PM To: DB2-L@RYCI.COM Subject: Re: UQ38405

Hello Gerald,

I believe I'm one of the original interested parties for UQ38405. I had a couple problems open with IBM trying to use the "overriding user value" clause, and then using the Identity clause. [...] 13112 56 22_Re: downloading db2 v714_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Tue, 20 Jun 2000 14:00:19 -0400578_iso-8859-1 try http://www6.software.ibm.com/dl/db2pde/db2pde-p

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > IBM1 > Sent: Tuesday, June 20, 2000 10:58 AM > To: DB2-L@RYCI.COM > Subject: downloading db2 v7 > > > hello list, > > I may be a bit thick, but this adternoon I spent almost 1 hour trying to > download db2/pc v. 7 from the ibm site. > > my real and true problem is I COULD NOT FIND THE START DOWNLOAD button. I > just kept on clicking on all sorts of links and switching back and forth > among 4-5 [...] 13169 54 35_Re: v6 pre-reqs and or v5 put level0_17_sjvagnier@AEP.COM31_Tue, 20 Jun 2000 14:00:42 -0400341_us-ascii Hello Tom,

I rolled up to Putlevel 9912 and included V6 pre-reqs. The upgrade to V6 went very smoothly without any problems. Putlevel 9912 maybe an overkill, but I would at least be at Putlevel 9910. Look at APAR II12343, II11442, and also the PSP bucket.

Hope this helps... Steve Vagnier American Electric Power [...] 13224 73 20_Re: Mixed data = YES16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Tue, 20 Jun 2000 11:57:14 -0700475_iso-8859-1 Some reprints from an earlier discussion of the same topic:

1. CHAR-type columns are defined with 'FOR SBCS DATA', 'FOR MIXED DATA', or 'FOR BIT DATA'. This sets a flag in the FOREIGNKEY column of SYSCOLUMNS. The 'FOR BIT DATA' is necessary for any CHAR-type column that could contain binary data, otherwise if it happens to contain a shift-out or shift-in value in the binary string (hex '0E' or '0F'), you could get an SQL error (like -113 or -191). [...] 13298 14 24_AS400 DB2 V4/5 Date/Time14_Karen Grantham25_kgrantham@CUSTOM-EDGE.COM31_Tue, 20 Jun 2000 14:01:40 -0500462_us-ascii Is there a non-programming method to populate a field with date/time stamp? The issue is to build delta decks of data inserted/changed based on these fields, and the fields will not be used by any other program.

================================================ 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. 13313 38 28_Re: AS400 DB2 V4/5 Date/Time13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Tue, 20 Jun 2000 15:21:30 -0400466_iso-8859-1 I'm not sure if I'm answering the right question, but :

If you define a column with a type TIMESTAMP and attribute NOT NULL WITH DEFAULT, DB2 will create the timestamp value for each row automatically as it is inserted.

Does this help?

Gregg Sawyer

-----Original Message----- From: Karen Grantham [mailto:kgrantham@CUSTOM-EDGE.COM] Sent: Tuesday, June 20, 2000 3:02 PM To: DB2-L@RYCI.COM Subject: AS400 DB2 V4/5 Date/Time [...] 13352 266 60_Re: Bad Container Path / DB2 EE V6.1 /Solution & Performance11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 20 Jun 2000 15:23:59 -0400417_us-ascii Jenny,

Sounds like an awful lot of data for 4 CPUs. Using a 30GB / CPU rule of thumb, I'd put your data warehouse on DB2 EEE with 10 Nodes, each node having 4 CPUs, 40 CPUs total. That aside, let's make the most of what you have.

For RAID, you need to set the environment variables (info from DB2 Symposium DB2 UDB EE & EEE Performance class, learn more at http://www.db2-symposium.com/): [...] 13619 84 28_Re: AS400 DB2 V4/5 Date/Time14_Karen Grantham25_kgrantham@CUSTOM-EDGE.COM31_Tue, 20 Jun 2000 14:30:55 -0500457_us-ascii Gregg,

Thank you for your reply. That would cover the insert issue, but I'm also in need a 'change' solution. When a field is updated I need a change column to be updated with the timestamp value. Any suggestions on that?

Karen Grantham

"Sawyer, Gregg" on 06/20/2000 02:21:30 PM

Please respond to DB2 Data Base Discussion List [...] 13704 37 28_Re: AS400 DB2 V4/5 Date/Time13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Tue, 20 Jun 2000 15:54:45 -0400326_iso-8859-1 I was afraid you were going to ask that...

Here's a really nasty one - create a tracking row each time you update the master... However, this implies program code, so probably not what you want anyway.

A question for you, before I bark further up the wrong tree - why can't you use program code? [...] 13742 85 28_Re: AS400 DB2 V4/5 Date/Time14_Karen Grantham25_kgrantham@CUSTOM-EDGE.COM31_Tue, 20 Jun 2000 15:05:43 -0500486_us-ascii We are looking for a solution that would minimize programming efforts due to their availability and backlog. The DBA group is attempting to resolve a lengthy data pull for populating a data warehouse without the intervention of the application group. Coding changes are being considered as a last resort. By having fields containing datetime stamps of inserts and changes, the pull would be keyed on those fields and greatly reduce our runtime and implementation efforts. [...] 13828 114 28_Re: AS400 DB2 V4/5 Date/Time18_Sundaresan, Sundar33_Sundar.Sundaresan@SEA.SIEMENS.COM31_Tue, 20 Jun 2000 16:20:54 -0400332_iso-8859-1 Karen Data volume and budget would be considerations in a choice. Possible ideas which might fit the bill are

- Use Inforefiner etc to read the logs and get the deltas

- Unload tables into GDG files and use Comparex or any comparable product to compare with previous day's downloads and get the deltas [...] 13943 108 28_Re: AS400 DB2 V4/5 Date/Time14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Tue, 20 Jun 2000 14:00:10 -0700383_iso-8859-1 Karen, If DB2/AS400 supports triggers, this would be the perfect opprotunity for a trigger to update the time column. However, I've never worked with DB2 on the AS400 (or anything else on the AS400 for that matter) so I don't know if they are supported. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 14052 56 41_data_protection errors in UDB V6 for AIX?0_18_damcon2@US.IBM.COM31_Tue, 20 Jun 2000 17:07:43 -0400518_us-ascii Hello all,

I'm a mainframer lost in the AIX environment of DB2 and unable to find documentation on the following error message that is showing up in the db2diag.log file. We are running DB2 UDB V6.1.0 for AIX.

2000-06-20-16.28.49.610890 Instance:db200001 Node:000

PID:66140(db2cart) Appid:none

data_protection sqlpgart Probe:490

User Exit returned error on ARCHIVE log file S0000087.LOG from /db2/db200001/lo gepmsdb/ for database EPMSDB, error code 28 [...] 14109 28 84_August 8th - Performance Estimation Class - Tim Lenahan - Central PA DB2 Users Group10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Tue, 20 Jun 2000 18:07:56 -0400389_us-ascii If you are interested in Performance Estimation, you might want to consider this class!

Tim Lenahan is coming to Central PA to teach it.

Check out the details on Tim & the course on the Central PA DB2 Users Group webpage at: http://www.db2parug.org

Having Tim teach you Performance Estimation for an entire day for $100 per person is an absolute steal!! [...] 14138 41 28_Re: AS400 DB2 V4/5 Date/Time13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Tue, 20 Jun 2000 18:08:39 -0400375_iso-8859-1 To be honest, if INSERT timestamps aren't good enough, you're in a corner; suggestions so far require either heavyweight software (Inforefiner?, Data Propagator) or bespoke code (image compares, log trolling).

Having said that, adding a new column to the tables and CURRENT TIMESTAMP to all UPDATE statements doesn't appear to be too much of a burden. [...] 14180 142 32_Re: DB2 Program Execute in CICS.17_Armando Zaporteza25_azaporte@CI.PHOENIX.AZ.US31_Tue, 20 Jun 2000 15:19:41 -0700511_US-ASCII Hi all,

Thank you so much for the good info I received. Its a great help.

I have explained to my Boss all the great and logical answers I've received.

At this time, I'll just have to wait for the verdict.

Thanks again.

AZ

______________________________ Reply Separator _________________________________ Subject: Re: DB2 Program Execute in CICS. Author: DB2 Data Base Discussion List at INTERNET-MAIL Date: 6/20/00 8:40 AM [...] 14323 29 51_SQL/DS V3 and DB2 V5 withdrawn from support 1/31/0124_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Tue, 20 Jun 2000 19:44:39 -0700815_us-ascii After January 31, 2001 the only supported versions of DB2 on VSE and VM will be version 6 and the soon-to-arrive version 7. Plan upgrades accordingly.

Regards, Frank

+-------------------------------------+--------------------------------------+ | Frank C. Fillmore, Jr. | Voice/Fax: 410.465.6335 | | The Fillmore Group, Inc. (TFG) | Class registration: 800-TFG-RDBMs | | 3213-A Corporate Court | E-mail: fillmore@ws1.tfg-rdbms.com | | Ellicott City, Maryland 21042-2247 | URL: http://www.thefillmoregroup.com | | USA | | +-------------------------------------+--------------------------------------+ | DB2 Family, Oracle, Client/Server, Distributed Database | | "Relational Database Solutions"(sm) | +----------------------------------------------------------------------------+ [...] 14353 32 40_Problem while Migrating DB2 V5 to DB2 V613_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM31_Wed, 21 Jun 2000 08:42:25 +0530492_us-ascii Hi all,

We are migrating Db2 V5 to DB2 UDB V6 on OS/390. When we ran DSNTIJTC ( CATMAINT utility), it was terminated with REASON=X'00E40601'. After that DB2 subsystem didn't start with version 5 datasets. It only starts in V6.

but we found CATMAINT utility is in STOPPED state. Also DSNDB01 and DSNDB06 database are still in V5 and any operation on these database fails so we are not able to run any utility on these database .The terminate utility doesnot works. [...] 14386 55 28_Re: Diff between UDB and DB27_Sanjeev19_Sanjeev@INTERRA.COM31_Wed, 21 Jun 2000 09:48:20 +0530470_iso-8859-1 I think primarily DB2 is called as UDB because it is available in almost all the platform as it was not earlier. There was a request also came for calling DB2 from V6 as DB2 UDB V6 for "platform name" .

Regards

Sanjeev ================================ -----Original Message----- From: Rajesh Kumar Sinha [mailto:rksinx@LOT.TATASTEEL.COM] Sent: Tuesday, June 20, 2000 5:01 PM To: DB2-L@RYCI.COM Subject: Re: Diff between UDB and DB2 [...] 14442 47 32_Re: DB2 Program Execute in CICS.7_Sanjeev19_Sanjeev@INTERRA.COM31_Wed, 21 Jun 2000 09:51:32 +0530614_iso-8859-1 Hi Ashish, Thanks for your valuable input.I am trying to give this a try and i will let u know the result.

Thanks Again.

Regards

Sanjeev

-----Original Message----- From: Mohan, Ashish [mailto:Ashish.Mohan@NIKE.COM] Sent: Tuesday, June 20, 2000 4:46 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Program Execute in CICS.

As I said, for transactions and plans not explicitly defined in RCT, plan name is derived dynamically at the transaction run time from the program name. This is done using an exit (which you could find under the TYPE=POOL entry in your RCT). [...] 14490 24 29_Partitions in DB2 UDB for Sun18_Thomas Fredriksson23_thfr02@HANDELSBANKEN.SE31_Wed, 21 Jun 2000 09:35:31 +0200468_us-ascii Hello list,

a simple question(?):

How many partitions can you have in a tablespace/table in DB2 UDB for Sun Solaris?

Regards

Thomas Fredriksson Svenska Handelsbanken +46 8 701 36 33

================================================ 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. 14515 24 40_Check SQL Code against company standards18_Blumer Hans-Ulrich32_Hans-Ulrich.Blumer@WINTERTHUR.CH31_Wed, 21 Jun 2000 10:17:47 +0200511_iso-8859-1 In our Company, we think about using a QA-Tool. It should be able to: - check existing SQL Code against rules (pre-set by the tool and set by us) - evaluate new code against the rules - detect SQL coding errors and/or (inhouse) standards violations before applications are moved to production - maybe forecast the applications behavior with higher data volumes Now I wonder: who is already using such a tool and what are your experiences with it? What's the name of the tool? Who is selling it? [...] 14540 26 13_Index rebuild11_K Mahadevan28_kmahadevan@CHENNAI.TCS.CO.IN31_Wed, 21 Jun 2000 14:14:26 +0530344_us-ascii Hi all,

In our project we are dropping and recreating a primary unique clustered index to change it to Descending from Ascending. We are using Platinum RC Migrator for this . After the analysis we got a warning message that the change made to the Primary index will not be reflected in the table .Is this just a warning ?. [...] 14567 61 17_Re: Index rebuild7_Sanjeev19_Sanjeev@INTERRA.COM31_Wed, 21 Jun 2000 14:36:40 +0530526_iso-8859-1 Hi Mahadevan, It looks as the message is from RC Migrator and not from DB2, i am not aware of the message but it might be saying or giving a hint to you to go for reorg. Regarding the 2nd point as this is Clustering index then Reorg ,Runstat and Rebind(may be) is important because in this situation as you have changed the order of the index then DB2 have to do a lot of work in reorg.It will really improve the performance of the queries with this table. The value of the cluster ratio should go to 100% for [...] 14629 18 17_Re: Index rebuild14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Wed, 21 Jun 2000 10:57:15 +0100414_us-ascii If you think that clustering index reflects the order of rows IN THE TABLE it should be a good idea

to execute a tablespace reorg.

Regards Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14648 66 44_AW: Check SQL Code against company standards12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 21 Jun 2000 11:24:35 +0200631_iso-8859-1 Since 1991 we're using a CA (former Platinum) tool called Plan Analyzer to check existing SQL code against rules and evaluate new code against the rules. May be this tool is the right one for you. HTH.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 14715 68 17_Re: Index rebuild10_CEI, Bruno20_Bruno.CEI@SEMA.CO.UK31_Wed, 21 Jun 2000 10:25:59 +0100498_iso-8859-1 Hi Mahadevan,

because you are recreating only the index you are not moving any data in the tablespace. If you don't do a reorg, the data in the tablespace will be in the old clustering order and your index will have a very poor clustering ratio, which has a bad effect on performances. Since you are altering a clustering index, I assume that you want to change the order in which you want data to be stored in the tablespace, therefore a reorg is needed to have it applied. [...] 14784 64 33_Re: Partitions in DB2 UDB for Sun18_Rajesh Kumar Sinha24_rksinx@LOT.TATASTEEL.COM29_Wed, 21 Jun 2000 10:16:23 GMT546_iso-8859-1 Hello Thomas I have worked on AIX, but what I know is instead of table space partition they use term database partition. It is available with UDB EEE only. Database partition could exist on different node group( A named group of one or more database partitions). I am not sure about no of database partition. Purpose of partition tablespace is parallel I/O , which we are achieving through defining more than one containers for a table space and assigning it to different volumes. Concepts of partition key on UDB is as follow :- [...] 14849 48 44_Re: Check SQL Code against company standards11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 21 Jun 2000 04:35:00 PDT392_- We are getting ready to evaluate Patrol SQL Explorer from BMC which is supposed to do the kinds of things you are talking about, for example there is a step that you are to he compile jobs that will check the sql and error off if there are violations of the expert rules database. We are looking at it for os/390; but I do not know what other platforms it may run on. HTH, Rick Creech [...] 14898 127 28_AW: Diff between UDB and DB212_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 21 Jun 2000 13:36:48 +0200359_iso-8859-1 Below is a statement that I received from Mike Swift, Teresa Lab, some time ago. The statement clarifies the "differences" between UDB and DB2. Hope that helps.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ [...] 15026 16 42_Re: DB2 OS/390 V6.1 Archiving Active Logs.12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Wed, 21 Jun 2000 06:39:46 -0500438_- Our production regions have 6 active logs each allocate at 500 cyls. We allocate the archive logs at 500 cyls with a blocksize of 24576, half track allocation on a 3390. They are SMS managed and are migrated to level 1 within 2 hours. Migrating them that soon keeps the SMS pool free and if they are recalled for a recovery, they are at level 1 and is fairly quick for the recall. They go to level 2 the next day. Hope this helps. [...] 15043 19 33_Re: Dataset Creation in Version 612_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Wed, 21 Jun 2000 07:22:49 -0500423_us-ascii I have been told that you can defer creation of a dataset in version 6 until data is loaded into it. The table is created in the catalog but the dataset is defered until it is loaded. Can anyone tell me how this is done? I have look through the manual at the create tablespace and the create table statements and do not see any parameters that might do this. I would appreciate any help from you all. Thanks. [...] 15063 83 33_Re: Dataset Creation in Version 613_Adrian Savory24_adrian.savory@ZURICH.COM31_Wed, 21 Jun 2000 13:27:49 +0100662_us-ascii Dan,

Here's some information I got from an SAP newsletter recently - you might be interested in subscribing to this (email address is at the bottom).

hth,

Adrian

Dear friends of R/3 on S/390,

here is some interesting information for users of R/3 4.6C and later versions:

Starting with release R4.6C the installation and upgrade processes create tablespaces and indexes with the DEFINE=NO option. That means that the underlying data sets are not created until the first row is inserted into the corresponding table. For most R/3 sites a large number of tables remain empty which means that very significant [...] 15147 59 42_Removing SYSADM /Retaining Auth He Granted18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Wed, 21 Jun 2000 08:40:51 -0400334_iso-8859-1 Hi all, We are doing some 'cleanup' of multiple ids on multiple DB2 (OS/390) subsystems. We have found in IBM documentation that we can retire old SYSADMS without losing the authority that that sysadm granted by making him install sysadm and then revoking sysadm authority. He goes away; granted auth stays (per IBM). [...] 15207 46 33_Re: Dataset Creation in Version 613_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 21 Jun 2000 08:47:26 -0400945_iso-8859-1 This function is delivered in v6 via an Apar see http://www-4.ibm.com/software/data/db2/os390/v6apar.html and enter the apar number.

APAR NUMBER: PQ30999

ABSTRACT: PQ30999: NEW FUNCTION - DEFER DEFINE SUPPORT.

ORIGINATING DETAILS: New Function - Defer Define support.

LOCAL FIX AS REPORTED BY ORIGINATOR:

RESPONDER SUMMARY: **************************************************************** * USERS AFFECTED: All DB2 users. * **************************************************************** * PROBLEM DESCRIPTION: DB2 new function support for Defer * * Define data sets. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR provides a new DB2 function to allow users to create table spaces or index spaces with an option to defer the physical creation of underlying VSAM [...] 15254 243 21_Re: ddf stopping hung11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Wed, 21 Jun 2000 07:55:26 -0500582_iso-8859-1 There was a similar thread back in March, and it was mentioned that a STOP DB2 MODE(FORCE) is accepted after a normal stop. Look for the subject "DB2 hangs at shutdown" in early March.

> -----Original Message----- > From: Bourgoine, Peter A [SMTP:Peter.A.Bourgoine@JPFINANCIAL.COM] > Sent: Tuesday, June 20, 2000 8:49 AM > To: DB2-L@RYCI.COM > Subject: Re: ddf stopping hung > > Hi Tina, > Canceling the IRLM is done when we have issued a stop and, for some reason > like we didn't kill dist threads, DB2 is not coming down. At that point > it's too late. If [...] 15498 103 46_Re: Removing SYSADM /Retaining Auth He Granted9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 21 Jun 2000 13:59:14 +0100380_us-ascii Yes you do have to bounce it twice, but you could revoke 2 sysadms in one go (Install SYSADM 1 and Install SYSADM 2) if you have many sysadms to remove. This reduces the number of sub-system bounces. Kind Regards, Andy Hunt - Scottish And Southern Energy

"Bourgoine, Peter A" on 21/06/2000 13:40:51 [...] 15602 280 21_Re: ddf stopping hung12_Kirk Hampton16_khampto1@TXU.COM31_Wed, 21 Jun 2000 08:16:04 -0500477_us-ascii

To everyone who says they "cancel IRLM" : Do you actually use an MVS Cancel command on it, or do you use the modify as recommended in the manual:

F ssssIRLM,ABEND,NODUMP

Tina Hilton on 06/21/2000 07:55:26 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Kirk Hampton/Texas Utilities) Subject: Re: ddf stopping hung [...] 15883 99 46_Re: Removing SYSADM /Retaining Auth He Granted0_17_sjvagnier@AEP.COM31_Wed, 21 Jun 2000 09:20:13 -0400379_us-ascii Hello Peter,

Yes, you must bounce DB2 twice to complete the changes. However, there is a product from BMC called Opertune that will allow you to dynamically make ZPARM changes on the fly without having to recycle DB2. I used Opertune to remove SYSADM's on several occasions. The product also has several other nice features. Check www.bmc.com if interested. [...] 15983 39 40_Re: Image processing [in V5 for OS/390?]16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Wed, 21 Jun 2000 10:04:06 -0400353_iso-8859-1 Has anyone ever done anything like this? My questions would be, does the image have to be scanned, what data types would the table be made up of? Thanks..

-----Original Message----- From: Sawyer, Gregg [mailto:Gregg_Sawyer@CSX.COM] Sent: June 19, 2000 11:18 AM To: DB2-L@RYCI.COM Subject: Re: Image processing [in V5 for OS/390?] [...] 16023 134 21_Re: ddf stopping hung19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 21 Jun 2000 09:08:28 -0500356_iso-8859-1 Hi Tina, Before I realized there was a modify (F) command available (and there might not have been yrs ago), I first did an MVS end (P), which usually didn't work, and then a cancel (C). I think I remember reading long ago that a cancel command should always be preceded by an end command; might not be true any longer. Regards, Rick Davis [...] 16158 68 44_Re: Problem while Migrating DB2 V5 to DB2 V619_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 21 Jun 2000 09:22:01 -0500296_iso-8859-1 Hi Mayank, The RC reads: "This abend can be issued by either the CATMAINT or the REPAIR DBD utility. The utility terminates and all work up to the time of abend is backed out." I would try to run DSNTIJTC again with a different UTILID and see what happens.

HTH, Rick Davis [...] 16227 32 13_DB2 error msg18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Wed, 21 Jun 2000 10:30:41 -0400413_iso-8859-1 We received this error msg from our TMON for DB2 monitor. For the life of me

I can't find C20110 in the IBM messages and codes manual. We're at DB2 V5. Anybody got any idea of what it means??

Thanks: Here's the text of the TMON error. 10.24.14 DSNT500I -SYST DSNB1OPP RESOURCE UNAVAILABLE * * REASON 00C20110 * * TYPE 00000220 * * NAME DB2SYSTV.DSNDBC.BPTTCSYS.TISECEQN.I0001.A001 * [...] 16260 64 17_Re: DB2 error msg0_17_sjvagnier@AEP.COM31_Wed, 21 Jun 2000 10:39:59 -0400546_us-ascii Stephen, look at APAR PQ37806...

Hope this helps.. Steve Vagnier American Electric Power

"Whittaker, Stephen" @RYCI.COM> on 06/21/2000 10:30:41 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc:

Subject: DB2 error msg

We received this error msg from our TMON for DB2 monitor. For the life of me [...] 16325 93 17_Re: DB2 error msg0_26_jbrahmbh@NOTES.STATE.NE.US31_Wed, 21 Jun 2000 09:32:33 -0500671_us-ascii Here is the error message delail for version 6

DSNT500I DSNT500I csect-name RESOURCE UNAVAILABLE REASON reason TYPE type NAME name Explanation: The requested function requires a resource that is currently unavailable. In conjunction with other messages this message will identify the system action and the action that should be taken by the installation or operator. 'type' and 'name' identify the resource that is currently unavailable. The type code identifies the type, format, and content of the resource named. Operator Response: Note the reason code, the type code, and the name. See the Problem Determination section for an explanation of the [...] 16419 158 17_Re: DB2 error msg0_26_jbrahmbh@NOTES.STATE.NE.US31_Wed, 21 Jun 2000 09:36:59 -0500688_us-ascii Here is the message for verison 4.2

--------------- V=IBM P=DB2 MESSAGES R=V4R2 & PRIOR I=DSNT500I --------------- ********************* Text Below Copyright (c) 2000, IBM ********************* Message Format: DSNT500I csect RESOURCE UNAVAILABLE REASON reason TYPE type NAME name Description: This message indicates that a needed DB2 resource was unavailable. The 'type' and 'name' values in the message identify the type, format, content, and name of the resource. User Action: Use the reason code to diagnose the error. Reason codes appearing in this message are described in "Part 4. Reason Codes" of the DB2 Messages and Codes manual. The table below provides an [...] 16578 35 43_Changed and new SQLSTATES in DB2 for OS/39012_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 21 Jun 2000 17:20:40 +0200287_iso-8859-1 After our migration from DB2 Version 4 to Version 5 it seems that there are changes of SQLSTATES and also new SQLSTATES. Is this true ?

And if the answer is yes: a) where this is documented ? b) Is there a need to rewrite our central SQL error handling routines ? [...] 16614 15 18_DBRM statement no.16_Thirumal Valavan31_thirumal.valavan@PRUDENTIAL.COM31_Wed, 21 Jun 2000 11:19:10 -0400376_us-ascii Hai Is it possible to identify the SQL in the DBRM using a DBRM statement no. Any body please clarify on this issue. Thirumal

================================================ 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. 16630 29 22_Re: DBRM statement no.24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Wed, 21 Jun 2000 08:34:10 -0700661_- The statement number in the DBRM matches the statement number in the output listing of the pre-compile step for the program.

> -----Original Message----- > From: Thirumal Valavan [SMTP:thirumal.valavan@PRUDENTIAL.COM] > Sent: Wednesday, June 21, 2000 8:19 AM > To: DB2-L@RYCI.COM > Subject: DBRM statement no. > > Hai > Is it possible to identify the SQL in the DBRM using a DBRM statement no. > Any body please clarify on this issue. > Thirumal > > ================================================ > 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 [...] 16660 51 47_Re: Changed and new SQLSTATES in DB2 for OS/39011_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 21 Jun 2000 08:35:52 PDT655_- You can find it in the version 6 release guide at this site: http://www-4.ibm.com/software/data/db2/os390/v6books.html under the section 8.2.1: Adjust Application Programs. hth, Rick Creech

>From: "Peter, Georg" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Changed and new SQLSTATES in DB2 for OS/390 >Date: Wed, 21 Jun 2000 17:20:40 +0200 > >After our migration from DB2 Version 4 to Version 5 it seems that there are >changes of SQLSTATES and also new SQLSTATES. >Is this true ? > >And if the answer is yes: >a) where this is documented ? >b) Is there a need to rewrite [...] 16712 82 47_Re: Changed and new SQLSTATES in DB2 for OS/39018_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Wed, 21 Jun 2000 11:44:49 -0400551_iso-8859-1 Install Guide Migration step 23 "Adjust Application Programs pg 2-283 has:

SQLSTATE Changes: Queries that returned SQLCODE '-302' with SQLSTATE '22001', String too long and number too large for target, now return SQLSTATE '22003', Number too large for target, for numeric operations.

SQLCODE '-130' with SQLSTATE '22019' previously returned two conditions: Invalid escape pattern and Invalid occurrence of escape character in pattern of LIKE predicate. The second condition is now reported with SQLSTATE '22025' instead. [...] 16795 116 21_Re: ddf stopping hung18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Wed, 21 Jun 2000 11:47:41 -0400425_iso-8859-1 We have CA-SYSVIEW. We issue a line command "C" cancel the STC.

-----Original Message----- From: Kirk Hampton [mailto:khampto1@TXU.COM] Sent: Wednesday, June 21, 2000 9:16 AM To: DB2-L@RYCI.COM Subject: Re: ddf stopping hung

To everyone who says they "cancel IRLM" : Do you actually use an MVS Cancel command on it, or do you use the modify as recommended in the manual: [...] 16912 51 17_Re: DB2 error msg9_ken Hynes17_khynes@TRIGON.COM31_Wed, 21 Jun 2000 10:50:02 -0500635_- Stephen,

Sometimes maintenance adds codes or codes are "undocumented" for internal problems. There is some information on this under APAR PQ33002

Here's a small some of the descrition that may be of use to you from the APAR:

ERROR DESCRIPTION: For some reason, the HURBA information which is registered in the ICF catalog doesn't represent the real end-of-file. This means that DB2 on open, gets an address which points into pages that reside before the actual end of tablespace. DB2 thereby overwrites the data that has already been inserted in the tablespace. This is later on detected when customer does [...] 16964 44 22_Re: DBRM statement no.12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Wed, 21 Jun 2000 11:23:07 -0500319_iso-8859-1 It depends on what you mean by identify? If you check the mapping macro DSBXDBRM in SDSNMACS there is a reference to the "STATEMENT SECTION" that identifies the source statement number. How are you trying to use this? The source statement number will change as code is added or deleted from the source. [...] 17009 55 28_DB2 CONNECT PERSONAL EDITION15_Pierre Dagenais19_pdagenai@UOTTAWA.CA31_Wed, 21 Jun 2000 12:32:30 -0400366_us-ascii HIi everyone,

I have a quick question on db2 connect personal edition. I have standardized our site with db2 connect personal edition 5.2 fixpack 11.

But recently, the windows 2000 have started to appear on workstations.

1. Will db2 connect personal edition 5.2 fixpack 11 work on windows 2000?

2. If not what version will. [...] 17065 53 22_Re: DBRM statement no.17_Patricia Candella21_pcandella@METLIFE.COM31_Wed, 21 Jun 2000 13:00:03 -0400557_us-ascii You can also find the sql that is associated with the statement number in sysibm.syspackstmt

"Leblanc, Francis C - CNF" on 06/21/2000 11:34:10 AM

Please respond to "DB2 Data Base Discussion List"

To: DB2-L@RYCI.COM cc: (bcc: Patricia Candella/Bsg/MetLife/US) Subject: Re: DBRM statement no.

The statement number in the DBRM matches the statement number in the output listing of the pre-compile step for the program. [...] 17119 18 32_Re: DB2 CONNECT PERSONAL EDITION13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 21 Jun 2000 12:59:35 -0400533_iso-8859-1 You'll probably get the official word from Leon, but I have used DB2 connect 5.2 PE & EE(no fixpacks), DB2 connect 6.1 PE & EE, and DB2 connect 7.1 EE on Win2000 all without problems.

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. 17138 36 31_How to validate MULC statistics14_Johnson, Tracy22_TJohnson@GUIDEMAIL.COM31_Wed, 21 Jun 2000 10:34:22 -0500561_iso-8859-1 We're trying to determine if we can cut our DB2 costs by showing low DB2 usage. We don't have many applications running yet on DB2, but our MULC reports indicate high usage (9 - 10 MSU on the days measured)....too high for price breaks. This is 2 - 3 times more than CICS, which we think has the most usage on our system. It's my understanding that the MSU are measured using Type 89 records. Our MVS person has been to IBM and gotten responses from the MVS ListServer, indicating that DB2 usage is much higher and that's life....but management [...] 17175 133 21_Re: ddf stopping hung13_Brian Triptow24_btriptow@DAS.STATE.UT.US31_Wed, 21 Jun 2000 11:15:47 -0600467_US-ASCII For years I issued the MVS cancel command then began using the F ssssIRLM,ABEND command with the same result. Both work OK.

>>> "Bourgoine, Peter A" June 21, 2000 9:47:41 AM >>> We have CA-SYSVIEW. We issue a line command "C" cancel the STC.

-----Original Message----- From: Kirk Hampton [mailto:khampto1@TXU.COM] Sent: Wednesday, June 21, 2000 9:16 AM To: DB2-L@RYCI.COM Subject: Re: ddf stopping hung [...] 17309 184 20_Re: NULLs in indexes10_Greg Jonas21_gjonas@CP-DEMO.CP.NET31_Wed, 21 Jun 2000 10:44:40 -0700592_- Yes, we have turned this in to IBM, but no response yet.

John, were your tables partitioned?

Greg

On Tue, 20 June 2000, "OConner, John" wrote:

> > Thanks Greg, right on target! Did you report this to Ibm? If so, what was > the response? The use of parallelism shouldn't change the result set, > should it? > > -----Original Message----- > From: Greg Jonas [mailto:gjonas@CP-DEMO.CP.NET] > Sent: Tuesday, June 20, 2000 6:27 AM > To: DB2-L@RYCI.COM > Subject: Re: NULLs in indexes > > > We have had similar problems at our site, but all have thus far [...] 17494 57 44_Re: Problem while Migrating DB2 V5 to DB2 V612_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 21 Jun 2000 20:10:04 +0200301_x-user-defined Hi, Happened to us few times when going from 4 to 5. Solving this by going back was easy as we always had the whole db2 catalog/directory and indexes as well as bsds and active logs copied aside and renamed, so all we needed was to rename. You just need to be prepared in advance. [...] 17552 30 35_Re: How to validate MULC statistics0_17_JTonchick@AOL.COM29_Wed, 21 Jun 2000 14:19:42 EDT527_US-ASCII One thing you have to remember is that DB2 is a database server for ALL access to the data, CICS, IMS/TM, TSO, distributed access, and all forms of batch including utilities. It is an entirely different animal than CICS or IMS/TM which are transaction managers only (notice I did not include IMS/DB which as DBCTL is also a database server). The MULC statistics include DB2's activity as the database server for ALL these applications. So the CICS usage of DB2 is added to the batch jobs and utilities using DB2. [...] 17583 171 22_Re: DBRM statement no.14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Wed, 21 Jun 2000 14:26:51 -0400302_iso-8859-1 Or - Hey Isaac, are you out there ??? .. - you can use the following rexx (written and submitted to the list by Isaac Yassin) to list the contents of the DBRM.

Change the DBRM library name(s) to your site conventions and pass the member name on the execute and your in business. [...] 17755 97 44_Re: Problem while Migrating DB2 V5 to DB2 V60_20_John_Lendman@FPL.COM31_Wed, 21 Jun 2000 14:33:50 -0400344_us-ascii Isaac, on a related subject, what do you use to copy the logs, BSDS and DB2 catalog and directory with? And when you copy them is DB2 down?

I am putting together a roll forward recovery method for SAP and I need to have copies of the LOG, BSDS, DB2 catalog and directory and I would like to do it with out taking DB2 down. [...] 17853 65 91_Re: DB2 OS/390 V5.1 Archiving Active Logs. What is optimal size to put on single 3490 tape?24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Wed, 21 Jun 2000 13:41:56 -0500605_- Ed,

Here is my setup...

zparms:

BLKSIZE=24576 (I have seen this number recommended often) ALCUNIT=CYL (don't believe this is relevant for tape archive) COMPACT=NO (have heard warnings against compacting)

Stated 3490 cartridge uncompressed capacity is 800mb, although I know our tapes actually can contain a bit more than this.

Active log size for typical subsystem is 1111 cyl, and BSDS is 2 cyl. When archived to tape, RMM reports a total of 800,304 kb written to tape (799,920 kb for the log and 384 kb for the BSDS). This is consistent for every full archive. [...] 17919 24 33_Re: Dataset Creation in Version 613_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 21 Jun 2000 15:02:30 -0400353_iso-8859-1 To add to my earlier post(I received the following off-list from a friend at STL)

"I think that the best source for a description of the function is in the new red book, SG24-6108, V6 Technical Update, section 5.2. The V6 books have also been updated, so they include this function if you download them or get the latest CD-ROM." [...] 17944 29 0_11_Mike Fatula17_mfatula@PHEAA.ORG31_Wed, 21 Jun 2000 15:10:46 -0400454_us-ascii Hi.

We are running DB2 5.2 EEE on AIX . We use Microfocus Cobol and are running INT's. A problem arises when monitoring the systems for deadlocks. The programs causing the locks and being locked are always reported as RTS32. RTS32 is the runtime for Microfocus INT's.

If an application snapshot is performed the name of the program is displayed correctly. However when a deadlock snapshot is performed the RTS32 name appears. [...] 17974 20 44_Re: Problem while Migrating DB2 V5 to DB2 V612_Roger Miller19_millerrl@US.IBM.COM31_Wed, 21 Jun 2000 14:00:22 -0500492_- There should be a number of messages from the job to indicate the problem. They could include still having type 1 indexes, passwords, or user-defined indexes on the catalog tables, for instance.

If you are not able to fall back, then the problem is usually that you don't have on the PTFs. Do you have on everything identified in II11442? While you are reading info APARs and checking service, I presume you have checked II12343 and are moving to the recommended service level. [...] 17995 25 24_Re: Store Proc IBM Books12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 21 Jun 2000 14:12:15 -0500383_- There isn't an update for the stored procedure red book yet, but there are several others, such as

Developing Cross-Platform DB2 Stored Procedures: SQL Procedures and the DB2 Stored Procedure Builder, SG24-5485-00

Start at www.ibm.com/redbooks Type DB2 or stored procedure or the book number in the Search and Click Go. The most recent red books are at the top. [...] 18021 178 44_Re: Problem while Migrating DB2 V5 to DB2 V650_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Wed, 21 Jun 2000 15:33:49 -0400919_iso-8859-1 Use adr

//DNXA02 EXEC PGM=ADRDSSU,REGION=4096K //SYSPRINT DD SYSOUT=* //BCKUP1 DD DSN=&NODE..DFDSXA01.BACKUP, // DISP=(NEW,CATLG,UNCATLG), // UNIT=TAPEC,VOL=(,,,99) //* //BCKUP2 DD DSN=&NODE..DFDSXA02.BACKUP, // DISP=(NEW,CATLG,UNCATLG), // UNIT=TAPEC,VOL=(,,,99) //* //SYSIN DD DSN=xxxx.CARDLIB(DNXAPROD),DISP=SHR //*

cardllib member contains the following

DUMP OUTDD(BCKUP1,BCKUP2) OPTIMIZE(3) ALLX SHR - DATASET(INCLUDE(DBTWOP2.LOG*.**, - DBTWOP2.*.DSNCV*.**, - DBTWOP2.*.DSNDDF*.**, - DBTWOP2.*.DSNDB01.**, - DBTWOP2.*.DSNDB04.**, - DBTWOP2.*.DSNDB06.**, - DBTWOP2.*.DSNRGF*.**, - DBTWOP2.*.DSNRL*.**, - DBTWOP2.BSD*.**, - DBTWOP2.DBRM*.**, - DBTWOP2.DSNA*.**, - DBTWOP2.DSNC*.**, - DBTWOP2.DSNE*.**, - DBTWOP2.DSNL*.**, - DBTWOP2.DSNM*.**, - DBTWOP2.DSNP*.**, - DBTWOP2.DSNS*.**, - DBTWOP2.RUNL*.**, - DBTWOP2.SDX*.**, - DB.DISASTER.*, - DBTWOP2.SRC*.**)) - ALLDATA(*) [...] 18200 28 46_Software Withdrawal: DB2 for MVS/ESA Version 412_Roger Miller19_millerrl@US.IBM.COM31_Wed, 21 Jun 2000 14:28:20 -0500360_- The withdrawal from marketing was announced this week for DB2 V4. You can use www.ibm.com/ibmlink or www.ibm.com/isource to get the announcement, but there is not much there.

900-134 20000620 Software Withdrawal: DB2 for MVS/ESA, Version 4 and DB2 PM for MVS/ESA, Version 4

Effective December 1, 2000, IBM will withdraw from marketing ... [...] 18229 19 39_subroutines called by Stored Procedures15_Belfield, Al G.15_AGBELFI@TWA.COM31_Wed, 21 Jun 2000 15:36:14 -0500386_iso-8859-1 Are WITH RETURN cursors supported in subroutines called by the main Stored Procedure program? I've tried it, and the rows are FETCHable in the client that CALLed the Stored Procedure. But I can't find any statement that says it will/should work. I can only find statements that say 'if in a stored procedure, it will return results to the client'. Anyone know for sure? [...] 18249 63 40_Package name in Deadlock Messages - Help11_Suresh Sane21_data_arch@HOTMAIL.COM29_Wed, 21 Jun 2000 16:36:10 CDT777_- Has anyone found a method to obtain the package name(s) of the programs involved in a deadlock/timeout?

Environment: DB2 OS/390 V5, Visual Basic front-end, background CICS transactions both invoking huge number of Cobol Stored Procedures. Landmark's TMON/DB2 monitor.

Here is a typical dsnt37i and the corresponding dsnt501i message:

DSNT375I -DBP1 PLAN=DISTSERV WITH CORRELATION-ID=OPFM04.EXE ------------ (Visual Basic Load Module) CONNECTION-ID=SERVER LUW-ID=GA010326.A107.058021091618=422 THREAD-INFO=WBKW00:*:WBKW00:OPFM04.EXE IS DEADLOCKED WITH PLAN=KCPCICS WITH CORRELATION-ID=GT00MCSR ------------ (CICS thread/transaction) CONNECTION-ID=CICSPMC1 LUW-ID=KCSNET.DBP1LU.B412DE35FDF5=1000 THREAD-INFO=CICSP:*:*:* ON MEMBER DBP1 [...] 18313 247 20_Re: NULLs in indexes13_OConner, John26_John.OConner@COURTS.WA.GOV31_Wed, 21 Jun 2000 14:42:11 -0700525_iso-8859-1 Greg, the tables in question (PAD and AD) are not partitioned. Here are some of the columns from the explain (degree=any, zero rows returned):

+---- ----+---- TNAME ... INDEXONLY ... +---- ----+---- PAD Y AD Y

-+---------+---------+---------+---------+---------+-------- ACCESS_DEGREE ACCESS_PGROUP_ID JOIN_DEGREE JOIN_PGROUP_ID ... -+---------+---------+---------+---------+---------+-------- 3 1 ----------- -------------- 3 1 3 1

-----+---------+ PARALLELISM_MODE -----+---------+ C C [...] 18561 56 20_Re: Mixed data = YES15_Murley, Michael22_Michael_Murley@BMC.COM31_Mon, 19 Jun 2000 10:49:02 -0500489_ISO-8859-1 Tom,

One thing to watch out for is that new CHAR columns will be defined FOR MIXED DATA, unless you explicitly code FOR SBCS DATA or FOR BIT DATA in your DDL. That doesn't usually matter, though, unless you store values in the column that might inadvertently correspond to the DBCS SHIFT-OUT (0x0E) or SHIFT-IN (0x0F) characters. RBA values come to mind. If that happens, DB2 will try to interpret the intervening data as DBCS, probably with undesirable results ~:) [...] 18618 100 45_Re: data_protection errors in UDB V6 for AIX?0_18_damcon2@US.IBM.COM31_Wed, 21 Jun 2000 15:17:34 -0400492_us-ascii Didn't get any responses, but thought I would let you all know what I found out...

The error is being generated because the database configuration parameter USEREXIT has been set to ON since the upgrade to V6. Set this to OFF and messages have stopped. The message itself has to do with the user exit in conjunction with ADSM trying to do cleanup of archived logs. But can't, probably because the system hasn't been setup to do so. The message is harmless, but annoying. [...] 18719 133 56_NT Control Center UID Validation Failure on AIX Instance19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Wed, 21 Jun 2000 15:41:34 -0700551_iso-8859-1 > Running Control Center on NT > New AIX V6.1 FP3 installed and a database configured. > I can attach to the AIX box (ljcqs048) but not to the DB2 instance > (db2dmsi1) or anything below that level. > > The error given by Control Center is an SQL1402N - Unable to authenticate > user due to an unexpected system error. > > Following are the diagnostics we've been able to pick up - they aren't all > from the same attempt so the times won't line up, but the symptoms were > consistent: > > >> db2diag.log under /home/db2inst1/db2dump: [...] 18853 40 32_Re: DB2 CONNECT PERSONAL EDITION10_Park, Stan17_SPark@STATE.NM.US31_Wed, 21 Jun 2000 16:49:54 -0600394_iso-8859-1 Have not tried it on Win2K here but did notice in the Ver 7 Troubleshooting Guide some installation problems with DB2 Connect PE V6 using the SNA stack are discussed.

-----Original Message----- From: Pierre Dagenais [mailto:pdagenai@UOTTAWA.CA] Sent: Wednesday, June 21, 2000 10:33 AM To: DB2-L@RYCI.COM Subject: DB2 CONNECT PERSONAL EDITION

HIi everyone, [...] 18894 26 50_UDB v7 - SQL0647N - How do I stop/start a database20_Pav Kumar-Chatterjee17_pavkc@HOTMAIL.COM29_Wed, 21 Jun 2000 22:45:55 GMT298_- Hi List

I am using UDB 7.1 (downloaded from IBM website) and have created a new buffer pool. When I try and create a tablespace to use this buffer pool, I get a SQL0647N message back, saying that the buffer pool is inactive and can be activated by stopping and starting the database. [...] 18921 50 54_Re: UDB v7 - SQL0647N - How do I stop/start a database13_Sundari Yegna24_Sundari_Yegna@WSIB.ON.CA31_Wed, 21 Jun 2000 19:07:12 -0400501_us-ascii Hi.. If you are connected to the database, then do a db2 terminate first. Then connect to the database and create the tablespace. Bufferpools are activated only once, at the first connect. Sundari

Pav Kumar-Chatterjee on 06/21/2000 06:45:55 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Sundari Yegna/ISD/WCBO) Subject: UDB v7 - SQL0647N - How do I stop/start a database [...] 18972 109 32_Re: DB2 CONNECT PERSONAL EDITION0_15_leon@CA.IBM.COM31_Wed, 21 Jun 2000 19:24:38 -0400435_us-ascii

DB2 Connect V6.1 and V7.1 were tested with Windows 2000 and are fully supported on Windows 2000. DB2 Connect V5.2 may not work on Windows 2000 but it is not supported on this platform.

IBM is pleased to announce that DB2 Connect products have been extensively tested under Windows 2000 with official support beginning with General Availability of Windows 2000 on February 17, 2000. [...] 19082 776 44_Repost: IBM Enterprise Information Portal V713_Morrill, John12_JohnM@VP.NET31_Wed, 21 Jun 2000 17:30:01 -0600594_iso-8859-1 Greetings!

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

Cheers!

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

Dear DB2 Interested Parties,

Today IBM introduced IBM Enterprise Information Portal Version 7, delivering additional functions defined as part of IBM's e-business portal strategy announced in the fall of 1999. [...] 19859 48 53_Repeated failures to install DB2 V6.1 on RedHat Linux16_Dylan Vanderhoof20_DylanV@SEMAPHORE.COM31_Wed, 21 Jun 2000 20:29:02 -0700496_iso-8859-1 Hello All, I'm just wondering if anybody else has experieced this same problem anywhere. I'm attempting to install DB2 Version 6.1 for linux on a server for a customer, after a wonderful success with out own migration to DB2 internally. However, I'm repeated failing to install the software. Initially, it will hang on creation of a Sample Database. However, if I do not create a sample DB, then I get as far as attempting to start the DB2 instance before it hangs with no error. [...] 19908 48 44_Re: Problem while Migrating DB2 V5 to DB2 V613_Myoungsoo Huh18_huhm@FARMERS.CO.NZ31_Thu, 22 Jun 2000 16:37:51 +1200491_us-ascii Please check the output of DSNTIJID and if you find any error on it , rerun DSNTIJID . And run DSNTIJTC with PARM='xxx.xxxx,RESTART'

Hope this will help !

Myoung-soo Huh DB2 DBA Auckland, New Zealand .

>Hi all,

>We are migrating Db2 V5 to DB2 UDB V6 on OS/390. When we ran DSNTIJTC ( >CATMAINT utility), it was terminated with REASON=X'00E40601'. After that DB2 >subsystem didn't start with version 5 datasets. It only starts in V6. [...] 19957 206 44_Re: Problem while Migrating DB2 V5 to DB2 V623_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 22 Jun 2000 05:59:17 +0100659_iso-8859-1 I take it Snap is not available to you?

regards

Les

-----Original Message----- From: Knight, Robert A. (Cameron of Pittsburgh at Alcoa) [mailto:Robert.Knight@ALCOA.COM] Sent: Wednesday, June 21, 2000 8:34 PM To: DB2-L@RYCI.COM Subject: Re: Problem while Migrating DB2 V5 to DB2 V6

Use adr

//DNXA02 EXEC PGM=ADRDSSU,REGION=4096K //SYSPRINT DD SYSOUT=* //BCKUP1 DD DSN=&NODE..DFDSXA01.BACKUP, // DISP=(NEW,CATLG,UNCATLG), // UNIT=TAPEC,VOL=(,,,99) //* //BCKUP2 DD DSN=&NODE..DFDSXA02.BACKUP, // DISP=(NEW,CATLG,UNCATLG), // UNIT=TAPEC,VOL=(,,,99) //* //SYSIN DD DSN=xxxx.CARDLIB(DNXAPROD),DISP=SHR //* [...]