1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l March 2000, week 4 2 592 33_Re: Code/Valid Value Table Design11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Wed, 22 Mar 2000 17:35:45 +1100577_iso-8859-1 Richard,

I am aware that RI for code tables is often regarded as a no-no, and initially I tended to agree with that. However, several discussions at previous sites have convinced me that this is not nearly as black-and-white as I had thought. I may be painting myself into a corner here because this may come across as a strong defence for RI for code tables whereas in reality I am fairly ambivalent about that, and I know that there are significant arguments against using RI for code tables, but let me concentrate here on the arguments FOR (maybe to [...] 595 88 11_Re: DB2 UDB14_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Tue, 21 Mar 2000 22:40:19 -0800538_- Jimmy,

This usually happens if you forget to get your various environment variables. There should be a script called "db2profile" within your SQLLIB directory that you need to run before issuing any DB2 commands...

regards,

Julian



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

Julian Stuhler DB2 Specialist, IBM Gold Consultant Triton Consulting

E-mail: julian.stuhler@triton.co.uk Web: http://www.triton.co.uk Mobile: +44 (0)7768 446927 Office Tel: +44 (0)1603 693517 Office Fax: +44 (0)1603 693531 [...] 684 50 37_Re: SET RETURN CODE IF TABLE IS EMPTY14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 22 Mar 2000 08:51:01 +0100303_us-ascii A trivial method I used many years ago is to insert in the JCL a step executing a stupid REXX

before the copy step. The REXX execute a SELECT COUNT(*) : if count=0 the return code ISPF

variable, ZISPFRC, is set to a strange RC, say 69, if count > 0 then ZISPFRC = 0. ZISPFRC [...] 735 24 22_Re: Performance Matrix14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 22 Mar 2000 08:57:47 +0100350_us-ascii From many infos I have (I work a little with ORACLE 8i)

DB2 Robust, scalable, but with few nice features. With S/390 is stable.

ORACLE: Nice features, medium-robust, but UNIX OS made the system weak and very administrator-enemy. Have you never used VI after editing an UNIX file with ISPF ?

SQL Server: Who knows ? [...] 760 93 36_Re: Batch and online window co-exist14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 22 Mar 2000 09:01:40 -0000550_- In agreement with most of what has gone before, it is probably easier to squeeze your batch to task less time than it is to make it co-exist with on-line. Assuming that you still have SOME batch window time, I suggest the following.

TUNE the worst SQL you have in your batch to speed it up (if you can't find the worst SQL have a look at Detector or Apptune). Consider running batch streams in parallel Where you have a single stream updating tables, LOCK THE TABLES. The more locks you take the longer things will run. Tune batch jobs [...] 854 32 4_IRLM14_Teddy C. Morfe24_tcmorfe@SOLIDBANK.COM.PH31_Wed, 22 Mar 2000 03:11:36 -0600591_- Hi !

This error :

DSNT501I - DSNILMCL RESOURCE UNAVAILABLE CORRELATION-ID=PIXM2551 CONNECTION-ID=BATCH LUW-ID=* REASON 00C90092 TYPE 00000905 NAME IRLM

I just want to know what is the right way to tackle this problem. I am running a batch kob that will delete lots of rows, about a thousand records, but this error occurs and rollbacks, so my move is to decreased the number of rows to be deleted to say 700 per submission with this amount of records the job will be successful. But is there I can do so I wont encounter this error while deleting a higher number [...] 887 328 24_re - DB2 Connect and ADO24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM31_Wed, 22 Mar 2000 20:50:17 +1100537_iso-8859-1 GIA,

I worked on an internet enabling application late last year that was built with VB/ADO and made calls to DB2 V5, COBOL stored procedures on OS/390.

The code below has input and output parameters a well as returning a result set from the stored procedure. One thing that took up a while to work out is that you must close the result set before the output variables are set. We only found out that closing the result set was mandatory after carefully reading sample programs supplied with DB2 UDB on NT. [...] 1216 72 8_Re: IRLM10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 22 Mar 2000 10:05:27 GMT591_us-ascii Hi Teddy, I think u are getting -904 in ur application, check with ur tablespace locks parameters ...like locksize and lockmax.Try acquiring the less number of locks in ur application by deciding the commit frequency and do more frequent commits.If u think u are scanning the whole tablespace for deletion of the records u mentioned .Try working with the LOCK TABLE in ur application or use locksize tablespace for the tablespace u are using. U are running out of virtual storage scenario for the IRLM.i do not think use of PC=YES will help.PC=NO is ok for performance reason. [...] 1289 54 8_Re: IRLM12_Gulin Atabek24_Gulin.Atabek@TCMB.GOV.TR31_Wed, 22 Mar 2000 11:40:43 +0200397_iso-8859-9 Hi, It seems your IRLM has been exhausted with so many locks. You may alter your tablespace with LOCKSIZE ANY in order to gain lock escalation and then reduce the number of locks.

Hope this helps, Gulin Atabek.

-----Original Message----- From: Teddy C. Morfe [mailto:tcmorfe@SOLIDBANK.COM.PH] Sent: Wednesday, March 22, 2000 11:12 AM To: DB2-L@RYCI.COM Subject: IRLM [...] 1344 166 36_Insert VARCHAR longer than 255 bytes5_Pearl17_panidak@SCB.CO.TH31_Wed, 22 Mar 2000 17:27:12 +0700326_windows-874 Hi List, I used QMF or SPUFI for insert into Table contained one VARCHAR(1024) column on DB2 V5 for OS/390. Data value is longer than 255 bytes (assume 400 bytes). DB2 didn't insert data and return error. How do I insert this data by QMF or SPUFI?

Note: I can insert this data when I used COBOL-SQL program. 1511 14 13_DB2 Replidata0_29_Joseph_Esposito@PUTNAMINV.COM31_Wed, 22 Mar 2000 08:10:07 -0500349_us-ascii Is anyone using REPLIDATA from IBM.

http://www-4.ibm.com/software/data/replidata/about.html

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 1526 48 35_Re: Image Copy before Online Reorg.11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 22 Mar 2000 05:47:30 PST460_- Hi,

I set up a set of online reorgs at a particular company and looked at it the same way that you do: no need for an extra image copy before reorg because of the ease of simply terminating the reorg in case of failure. No recoveries are required because the shadow datasets are actually being reorged. These reorgs have been running for a year, and a few of the jobs have failed for various reasons, and of course a recovery was never required. [...] 1575 58 8_Re: IRLM11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 22 Mar 2000 06:01:17 PST310_- fyi, You might want to get familiar with the command: f irlmproc,status,stor in order to see what is going on with irlm storage usage. Also, if there are no concurrency requirements, you can alter the tablespace to locksize table before the job, and only one lock will be taken.

hth, Rick Creech [...] 1634 69 8_Re: IRLM12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 22 Mar 2000 06:03:43 PST519_- Teddy:

I had the same problem before and what we did was change the PC=NO to PC=YES. A lot books and manuals recommend that if you want to get a good IRLM performance you to have to use PC=NO but you can change it and you won't see any difference. But something is better make a deeply research and find out if your batch application is holding a lot of pages and that why you are getting that kind of error. You can also commit often and it can help you to free resources more frecuently. But it seem to [...] 1704 41 19_Re: [DB2 Replidata]13_Harold Ramsey25_haroldramsey@NETSCAPE.NET29_Wed, 22 Mar 2000 06:07:11 PST414_US-ASCII Hi Joseph, I have been on a project that has been implementing this product between to large OS/390 SYSPLEX operations since April of 1999. If you have any questions are want some information please contact me at:

jay@tpmq-experts.com

The client I have been working for is the U.S. Postal Service.

Thanks. Joseph_Esposito@PUTNAMINV.COM wrote: Is anyone using REPLIDATA from IBM. [...] 1746 115 35_Re: Image Copy before Online Reorg.0_18_mebert@AMADEUS.NET31_Wed, 22 Mar 2000 15:10:22 +0100424_us-ascii One thing I have noticed, if you TERM an OLR in the SWITCH phase, you end up with the unreorged original Tablespace... in COPY PENDING status.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany







From: rick creech on 22/03/2000 13:47 GMT

Please respond to DB2 Data Base Discussion List [...] 1862 107 33_Re: Brackets for C Compiler Issue22_Lindsay, William (GES)24_WLindsay@EXCHANGE.ML.COM31_Wed, 22 Mar 2000 09:12:28 -0500433_iso-8859-1 Another way...

#define LEFT_BRACE x'AD' #define RIGHT_BRACE x'BD'

Bill

-----Original Message----- From: Viswanathan N [mailto:Viswanathan.N@POWAIMAIL.LTITL.COM] Sent: Tuesday, March 21, 2000 9:57 PM To: DB2-L@RYCI.COM Subject: Re: Brackets for C Compiler Issue



For the "[" brackets you can specify "??(" for "[" and "??)" for "]" . it will work . We do it this way . regards Vishy [...] 1970 57 32_V6 Data Sharing Naming Standards22_Kennedy, Tom - Cendant23_Tom.Kennedy@CENDANT.COM31_Wed, 22 Mar 2000 09:03:20 -0500338_iso-8859-1 In DB2 v5.1 it is "recommended" that group names for DB2 data sharing not begin with the letters A through I. Has anyone heard of this becoming a requirement for v6.1? Is there anybody who has implemented data sharing with DB2 v5.1 using a group name that begins with the letters A through I? Thanks in advance for your replies 2028 20 41_Re : Insert VARCHAR longer than 255 bytes10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 22 Mar 2000 14:22:23 GMT521_us-ascii Hi , In QMF using PF8 to add the data in the specified table.U edit the table and then press PF5 when ur cursor is at the column which is defined as VARCHAR.U will get additional menu to insert the value upto the total length of the column.

Regards

Sanjeev

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 2049 229 33_Re: Code/Valid Value Table Design19_Lisa Westcott-Dryer29_Lisa_Westcott-Dryer@AMWAY.COM31_Wed, 22 Mar 2000 09:30:35 -0500343_big5

Ok I'm kind of timid to discuss this topic but here is my two cents (sense) worth. Is there more to consider that performace? The "it depends" phrase I think really applies. Seems there are costs and benefits to choices. And for this discussion, my focus is on shared (re-used) data not one time departmentally focused data. [...] 2279 41 36_Re: V6 Data Sharing Naming Standards11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 22 Mar 2000 06:35:16 PST510_- FYI,

From the version 6 Dat Sharing Guide: To avoid names that IBM uses for its XCF groups, do not begin with the letters A-I unless the first three characters are DSN. Do not use the string SYS as the first three characters, and do not use the string UNDESIG as your group name. I implemented 3 data sharing systems in version 5 in which all of the group names started with the letters DSN with no problems. As a matter of fact, I would recommend doing so since 'DSN' has been reserved for DB2. [...] 2321 254 33_Re: Code/Valid Value Table Design14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 22 Mar 2000 15:43:04 +01004610_us-ascii It's a new Klingon or Imperial code ? Damn, I need C-3PO !!!!! ;-)))

(see below.....)

Max Scarpa









Lisa Westcott-Dryer il 22/03/2000 15.30.35

Per favore, rispondere per DB2 Data Base Discussion List

Per: DB2-L@RYCI.COM Cc: (ccr: Massimo Scarpa/CESVE)

Oggetto: Re: Code/Valid Value Table Design





DQpPayBJJ20ga2luZCBvZiB0aW1pZCB0byBkaXNjdXNzIHRoaXMgdG9waWMgYnV0IGhlcmUgaXMg bXkgdHdvIGNlbnRzIChzZW5zZSkNCndvcnRoLiAgSXMgdGhlcmUgbW9yZSB0byBjb25zaWRlciB0 aGF0IHBlcmZvcm1hY2U/ICBUaGUgIml0IGRlcGVuZHMiIHBocmFzZQ0KSSB0aGluayByZWFsbHkg YXBwbGllcy4gICBTZWVtcyB0aGVyZSBhcmUgY29zdHMgYW5kIGJlbmVmaXRzIHRvIGNob2ljZXMu DQpBbmQgZm9yIHRoaXMgZGlzY3Vzc2lvbiwgbXkgZm9jdXMgaXMgb24gc2hhcmVkIChyZS11c2Vk KSBkYXRhIG5vdCBvbmUgdGltZQ0KZGVwYXJ0bWVudGFsbHkgZm9jdXNlZCBkYXRhLg0KDQozIFdh eXMgb2YgZW5mb3JjaW5nIEJ1c2luZXNzIFJ1bGVzIHdpdGggdGhlaXIgdHJhZGUgb2Zmcy4NCjEu IHdpdGhpbiB0aGUgZGF0YWJhc2UNCiAgIElmIHlvdSBuZXZlciBldmVyIGV2ZXIgd2FudCB0aGlz IHJ1bGUgYnJva2VuLCB0aGlzIGNoaWxkIHBhcmVudGxlc3MsDQogICB0aGlzIGRlcGVuZGVudCB3 aXRob3V0IGluZGVwZW5kZW50Li4uIHRoZW4gZW5mb3JjZSB0aGUgUkkgaW4gdGhlDQogICBkYXRh YmFzZS4gIENvc3QgaXMgaW4gcGVyZm9ybWFuY2UgLSBiZW5lZml0IGlzIGluIGNvbnNpc3RlbmN5 LiAoSSB0aGluaw0KICAgdGhpcyB1c3VhbGx5IHRyYW5zbGF0ZXMgdG8gJCBsb3N0LCBvcmRlcnMs IGN1c3RvbWVycyBldGMuKQ0KDQoyLiB3aXRoIHRyaWdnZXJzDQogICBTaW1pbGFyIHRvIHdpdGhp biB0aGUgZGF0YWJhc2UgKGNhdXNlIGl0IGlzKSBleGNlcHQgeW91IG5lZWQgImlmIiBsb2dpYw0K ICAgYXMgd2VsbCwgYW5kIGFnYWluIGZvciBpZiB5b3UgbmV2ZXIgZXZlciB3YW50IHRoZSBydWxl IGJyb2tlbiwgdGhpcw0KICAgY2hpbGQgcGFyZW50bGVzcywgZXRjLiAgQ29zdCBpcyBpbiBwZXJm b3JtYW5jZSBhbmQgY29kaW5nIC0gYmVuZWZpdCBpcw0KICAgaW4gY29uc2lzdGVuY3kuDQoNCjMu IHdpdGggY3VzdG9tIGNvZGUNCiAgIElmIHlvdSBkb24ndCBjYXJlIGlmIHRoZSBydWxlIGlzIGJy b2tlbiBub3cgYW5kIHRoZW4sIG9yIGlmIHRoZSBjaGlsZA0KICAgZ29lcyBwYXJlbnRsZXNzIG9u Y2UgaW4gYSB3aGlsZSBvciBhZC1ob2MgcmVhZC1vbmx5IGlzIHRoZSB1c2Ugb2YgeW91cg0KICAg ZGF0YSwgdGhlbiBlbmZvcmNlIGl0IGluIGN1c3RvbSBjb2RlLiAgQ29zdCBpcyBpbiB0aGUgbXVs dGlwbGUgbW9kdWxlcw0KICAgdGhhdCBtYXkgYmUgY29kZWQgYW5kIG1haW50YWluZWQsIG1vZHVs ZXMgY29kZWQgZGlmZmVyZW50bHkgZGVwZW5kaW5nIG9uDQogICB0aGUga25vd2xlZGdlIG9mIHRo ZSBwcm9ncmFtbWVyL2RlcHQuLCBob3cgYmlnIGFuZCB3aGF0IGlzIHRoZSBkeW5hbWljDQogICBv ZiB0aGUgY29kaW5nIHN0YWZmLCBldGMuIHRoaXMgY2FuIGdpdmUgd2F5IHRvIGluY29uc2lzdGVu Y3kuIEluIGFuDQogICB1bnN0cnVjdHVyZWQgSVMgZW52aXJvbm1lbnQgaXQgY291bGQgYmUgYSBk b3duZmFsbCBvciBiaWdnZXIgY29zdCB0aGFuIGENCiAgIGJpdCBvZiBzbG93bmVzcyAtIGJlbmVm aXRzIGluIGZsZXhpYmlsaXR5IGluIHdoYXQgcnVsZSBlbmZvcmNlZCB3aGVyZS4NCg0KSSBkb24n dCBwcmV0ZW5kIHRvIGJlIGEga25vdyBpdCBhbGwuDQoNCkxpc2ENCg0KDQoNCg0KDQoiS1VITixV bHJpY2giIDx1bHJpY2gua3VobkBFTVBMT1lNRU5UTkFUSU9OQUwuQ09NLkFVPkBSWUNJLkNPTT4g b24NCjAzLzIyLzIwMDAgMDE6MzU6NDUgQU0NCg0KUGxlYXNlIHJlc3BvbmQgdG8gREIyIERhdGEg QmFzZSBEaXNjdXNzaW9uIExpc3QgPERCMi1MQFJZQ0kuQ09NPg0KDQpTZW50IGJ5OiAgREIyIERh dGEgQmFzZSBEaXNjdXNzaW9uIExpc3QgPERCMi1MQFJZQ0kuQ09NPg0KDQoNClRvOiAgIERCMi1M QFJZQ0kuQ09NDQpjYzoNCg0KU3ViamVjdDogIFJlOiBDb2RlL1ZhbGlkIFZhbHVlIFRhYmxlIERl c2lnbg0KDQoNCg0KDQpSaWNoYXJkLA0KDQpJIGFtIGF3YXJlIHRoYXQgUkkgZm9yIGNvZGUgdGFi bGVzIGlzIG9mdGVuIHJlZ2FyZGVkIGFzIGEgbm8tbm8sIGFuZA0KaW5pdGlhbGx5IEkgdGVuZGVk IHRvIGFncmVlIHdpdGggdGhhdC4/IEhvd2V2ZXIsIHNldmVyYWwgZGlzY3Vzc2lvbnMgYXQNCnBy ZXZpb3VzIHNpdGVzIGhhdmUgY29udmluY2VkIG1lIHRoYXQgdGhpcyBpcyBub3QgbmVhcmx5IGFz IGJsYWNrLWFuZC13aGl0ZQ0KYXMgSSBoYWQgdGhvdWdodC4/IEkgbWF5IGJlIHBhaW50aW5nIG15 c2VsZiBpbnRvIGEgY29ybmVyIGhlcmUgYmVjYXVzZSB0aGlzDQptYXkgY29tZSBhY3Jvc3MgYXMg YSBzdHJvbmcgZGVmZW5jZSBmb3IgUkkgZm9yIGNvZGUgdGFibGVzIHdoZXJlYXMgaW4NCnJlYWxp dHkgSSBhbSBmYWlybHkgYW1iaXZhbGVudCBhYm91dCB0aGF0LCBhbmQgSSBrbm93IHRoYXQgdGhl cmUgYXJlDQpzaWduaWZpY2FudCBhcmd1bWVudHMgYWdhaW5zdCB1c2luZyBSSSBmb3IgY29kZSB0 YWJsZXMsIGJ1dCBsZXQgbWUNCmNvbmNlbnRyYXRlIGhlcmUgb24gdGhlIGFyZ3VtZW50cyBGT1Ig KG1heWJlIHRvIGdldCBhIHdpZGVyIGRpc2N1c3Npb24NCmdvaW5nPyk7IHNvIGhlcmUgZ29lcy4u Lg0KDQpJIGNlcnRhaW5seSBhZ3JlZSB0aGF0IHBoeXNpY2FsIEkvTyBmb3IgY29kZSB0YWJsZXMg c2hvdWxkIGJlIHJlZHVjZWQgdG8gYQ0KbWluaW11bSwgdGhlcmVmb3JlIHB1dCB0aGVtIGluIHRo ZWlyIG93biBidWZmZXJwb29sIHdoaWNoIGNhbiBob2xkIG1vc3Qgb3INCmFsbCBvZiB0aGUgZGF0 YSAoYW5kLCBtb3JlIGltcG9ydGFudGx5LCB0aGUgcHJpbWFyeSBpbmRleGVzIHNpbmNlIHRoZSB0 YWJsZQ0KZGF0YSB1c3VhbGx5IGRvZXMgbm90IGdldCBhY2Nlc3NlZCBkdXJpbmcgdmFsaWRhdGlv bikuPyBIb3dldmVyLCB0aGlzIGhhcw0Kbm90aGluZyB0byBkbyB3aXRoIFJJLCBpdCBhcHBsaWVz IG5vIG1hdHRlciB3aGljaCBtZXRob2Qgb2YgdmFsaWRhdGlvbiB5b3UNCnVzZSAtIFJJLCB0cmln Z2Vycywgc3RvcmVkIHByb2NlZHVyZXMsIG9yIHN0cmFpZ2h0IGFwcGxpY2F0aW9uIGxvZ2ljLg0K DQpJIGhhdmUgc2VlbiBjYXNlcyB3aGVyZSBhcHBsaWNhdGlvbnMgd2VudCB0byBwaWVjZXMgYmVj [...] 2576 28 36_Re: V6 Data Sharing Naming Standards8_Long, Ed15_Ed.Long@FMR.COM31_Wed, 22 Mar 2000 09:43:58 -0500576_- All of our group names start with a "D". I've never heard of this as an issue before.

> -----Original Message----- > From: Kennedy, Tom - Cendant [SMTP:Tom.Kennedy@CENDANT.COM] > Sent: Wednesday, March 22, 2000 9:03 AM > To: DB2-L@RYCI.COM > Subject: V6 Data Sharing Naming Standards > > In DB2 v5.1 it is "recommended" that group names for DB2 data > sharing not begin with the letters A through I. Has anyone heard of this > becoming a requirement for v6.1? Is there anybody who has implemented data > sharing with DB2 v5.1 using a group name that begins with [...] 2605 426 37_Re: Remedy for List Prefetch problems20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 22 Mar 2000 09:36:47 -0500589_iso-8859-1 Hello Sanjeev

I may be in a little bit of disagreement with you on the following points.

1. Clustering and multi-index access : The clustering is important when there is a data page access but multi-index access, first collects the RID and does an union or intersection and then sorts the RID. There is no data page access until this point hence clusterratio is not of importance till this juncture. Next the list prefetch uses sorted RID list and goes to datapage. Since the RID is already sorted and list-prefetch can access any 32 pages in a range of 150, [...] 3032 45 33_Re: Code/Valid Value Table Design19_Lisa Westcott-Dryer29_Lisa_Westcott-Dryer@AMWAY.COM31_Wed, 22 Mar 2000 09:59:07 -0500412_us-ascii I did get an error when trying to send my note. Here is it again.

Ok I'm kind of timid to discuss this topic but here is my two cents (sense) worth. Is there more to consider that performace? The "it depends" phrase I think really applies. Seems there are costs and benefits to choices. And for this discussion, my focus is on shared (re-used) data not one time departmentally focused data. [...] 3078 67 19_Re: [DB2 Replidata]10_DANIEL CYR19_DCYR@EMAIL.USPS.GOV31_Wed, 22 Mar 2000 09:58:15 -0600648_iso-8859-1 Hi Jay,

I also could answer any replication DB2 questions about IBM's RepliData. I handle the DB2 DBA tasks. I installed the product a couple of times for the US Postal Service.

Dan







______________________________ Reply Separator _________________________________ Subject: Re: [DB2 Replidata] Author: owner-db2-l@RYCI.COM at INTERNET Date: 03/22/2000 9:29 AM



Hi Joseph, I have been on a project that has been implementing this product between to large OS/390 SYSPLEX operations since April of 1999. If you have any questions are want some information please contact me at: [...] 3146 53 36_Re: V6 Data Sharing Naming Standards0_23_Mike_Levine@TEKHELP.NET31_Wed, 22 Mar 2000 10:48:40 -0500612_us-ascii Hi,

It is also recommended that the group name be the same as the existing (i.e., first member) DB2 subsystem (to avoide JCL changes) which in many cases begins with 'D'. We use DBP1 which works fine.

Regards,

Michael Levine Premier Data Services, Inc.





> In DB2 v5.1 it is "recommended" that group names for DB2 data >sharing not begin with the letters A through I. Has anyone heard of this >becoming a requirement for v6.1? Is there anybody who has implemented data >sharing with DB2 v5.1 using a group name that begins with the letters A >through I? > [...] 3200 29 36_Re: V6 Data Sharing Naming Standards20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 22 Mar 2000 10:49:19 -0500592_us-ascii We use group name starting with G even in V6 and this has not been any problem so far. Not using A-I is only "recommendation" not a requirement.

> -----Original Message----- > From: Kennedy, Tom - Cendant [SMTP:Tom.Kennedy@CENDANT.COM] > Sent: Wednesday, March 22, 2000 9:03 AM > To: DB2-L@RYCI.COM > Subject: V6 Data Sharing Naming Standards > > In DB2 v5.1 it is "recommended" that group names for DB2 data > sharing not begin with the letters A through I. Has anyone heard of this > becoming a requirement for v6.1? Is there anybody who has implemented data > sharing [...] 3230 31 62_(Fwd) DB2 Communication Server 5.0, DB2 Connect 6.1, MVS DB2 V0_16_dumoore@NMSU.EDU31_Wed, 22 Mar 2000 08:55:42 -0700458_US-ASCII Hello,

I am trying to establish a distributed connection to MVS DB2 V5 through a gateway on AIX 4.3 using DB2 Communication Server V5.0 and DB2 Connect 6.1 Enterprise Edition with an ethernet adapter card. I currently have this same setup running through a different AIX box with a token ring adapter. I was wondering where I can get a detailed description of the difference in parameter values that the different adapter cards require. [...] 3262 26 36_Re: V6 Data Sharing Naming Standards10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Wed, 22 Mar 2000 11:27:14 -0500666_- I just attended the data sharing implementation class last week and going to the recovery class next week. The A thru I restriction is for IBM future use.



On Wed, 22 Mar 2000 09:03:20 -0500 "Kennedy, Tom - Cendant" wrote:









V6 Data Sharing Naming Standards







In DB2 v5.1 it is "recommended" that group names for DB2 data sharing not begin with the letters A through I. Has anyone heard of this becoming a requirement for v6.1? Is there anybody who has implemented data sharing with DB2 v5.1 using a group name that begins with the letters A through I? [...] 3289 90 8_Re: IRLM16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Wed, 22 Mar 2000 09:48:03 -0700557_- You could also try REORG with DISCARD if you're at the right release and maintenance level. Or you could do an unload of the rows to keep and the LOAD REPLACE. Both will help in managing a large volume of deletes.

Duane

> -----Original Message----- > From: HARBRY ARIZA [SMTP:harbry_a@HOTMAIL.COM] > Sent: Wednesday, March 22, 2000 7:04 AM > To: DB2-L@RYCI.COM > Subject: Re: IRLM > > Teddy: > > I had the same problem before and what we did was change the PC=NO to > PC=YES. A lot books and manuals recommend that if you want to get a [...] 3380 19 8_contract10_Fritz Rapp21_FritzRapp@T-ONLINE.DE31_Wed, 22 Mar 2000 18:19:51 +0000520_us-ascii Hi everybody, I'm not quite shure if I'm offending netiquette - hope it's not so. I'm a freelancer DB2-DBA and right now looking for a project in southern Germany. My address is fritzrapp@t-online.de, so if anybody is interested feel free to mail me. regards Fritz Rapp

================================================ 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. 3400 33 35_DB2 Connect Upgrades and Monitoring12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Wed, 22 Mar 2000 13:41:02 -0500435_iso-8859-1 Hello,

I was curious about how shops using DB2 Connect EE handle upgrades and monitoring. In production, we are using DB2 Connect EE V6.1 (no fixpacks) to connect to UDB for OS/390 . I am testing Fixpack3 in the development environment. I am specifically interested in the following:

1. How often do you upgrade the clients? Any problems with backleveled clients accessing a server with fixpacks applied? [...] 3434 30 14_AD HOC QUERIES12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 22 Mar 2000 10:45:57 PST588_- Hi Fellas:



Lately ,I've been doing perfomance activities and I found that AD HOC queries are killing my db2 subsystem. The majority of those queries are executed using QMF and almost all the queries force db2 to get the data through tablespace scan. I would like to hear if anybody knows about a third party product or any recommendation that could help me to collect information about what column on some tables are the most frecuently used and with that information I can create a new indexes to avoid , in some cases to execute tablespace scan. Thanks in advance [...] 3465 43 29_DB2 CAE on Windows NT problem10_Elaine Lee18_Elaine.Lee@WDR.COM31_Wed, 22 Mar 2000 13:38:04 -0500413_US-ASCII I am having a problem configuring the Client-to-Server Communications on the client workstation using the Client Configuration Assistant. When I try to catalog the remote database I get:

SQL1092N "userid" does not have the authority to perform the requested command.

My userid belongs to the local Administrators group on the workstation, which should give me SYSADM authority in DB2. [...] 3509 23 18_Re: AD HOC QUERIES0_29_STANLEY_GOODWIN@MECH.DISA.MIL31_Wed, 22 Mar 2000 13:51:42 -0500528_us-ascii Try looking at a product called 'QMF HPO',

It has a QMF montior in it and some other intresting options, CAll you local IBM rep to get more details.



Stan Goodwin DAC MBG DB2 Support

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 3533 19 28_Question: Cloning subsystems15_Wayne Arrington33_WAYNE.ARRINGTON@CUSTOMS.TREAS.GOV31_Wed, 22 Mar 2000 13:53:04 -0500513_US-ASCII We're a new DB2 site and we have a question for the group. The system programmer are attempting to setup a second DB2 subsystem. Is there quick way to clone the subsystem ..... or must they install the product from ground zero?



thanks for the help

================================================ 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. 3553 69 18_Re: AD HOC QUERIES12_HEPP SHERY C17_schepp@SRPNET.COM31_Wed, 22 Mar 2000 11:49:17 -0700543_ISO-8859-1 CA - Platinum Detector can help you capture the poor performing queries (and the sql) so you can explain it to determine better access paths.



Regards,



Shery Hepp SRP Sr. Database Adminstrator Information Services



(602)236-2650 pager (602)275-2508(8035) Dreams-we don't see things as they are, we see things as we are..... Success is getting what you want.....Happiness is wanting what you have...... "The question is not whether we will die, but how we will live." * Joan Borysenko [...] 3623 94 18_Re: AD HOC QUERIES9_Don Alden26_Don.Alden@PKSIS.LEVEL3.COM31_Wed, 22 Mar 2000 12:07:53 -0700380_iso-8859-1 A good way to run run SQL queries against a DB2 Production environment is to use a DB2 Uncommitted Read. This process uses a DB2 "dirty read" and does not incur any Locks. Use the following format ..

SELECT A, B, C from Prod.table with UR

Good Luck, Don Alden DB2/IMS DBA Phone:(480) 775-5474 Pager: (888) 610-8507 E-Mail: Don.Alden@pksis.level3.com [...] 3718 45 32_Re: Question: Cloning subsystems0_23_Mike_Levine@TEKHELP.NET31_Wed, 22 Mar 2000 14:18:50 -0500584_us-ascii Hi Wayne,

You only have to do the DB2 SMP/E work once but each new subsystem will have to be generated separately. By generated I mean you should go through the DB2 installation CLIST and run the jobs that are created. Then any program products that you have for DB2 (QMF, etc.) would need to be reinstalled in the DB2 subsystem (again, the SMP/E work is done only once). If you are also cloning application databases you have other choices where third party products like CA/Platinum, BMC, etc. that would help make that process simpler and faster. You may also [...] 3764 53 33_Re: DB2 CAE on Windows NT problem12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 22 Mar 2000 13:17:00 -0500457_- We are testing this now...and update dbm cfg using catalog_noauth yes seems to work for us. However, I don't know enough about this yet to say what security you are giving up/affecting.

No warrantee included. >>> DB2-L@RYCI.COM@inter2 03/22/00 12:38PM >>> I am having a problem configuring the Client-to-Server Communications on the client workstation using the Client Configuration Assistant. When I try to catalog the remote database I get: [...] 3818 60 18_Re: AD HOC QUERIES19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 22 Mar 2000 13:16:33 -0600582_iso-8859-1 Harbry, You've received many good suggestions so far. One more is if you are using the Resource Limit Facility (RLF)? RLF can be used to limit the CPU time available to complete a query for dynamic SQL.

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 [...] 3879 104 33_Re: DB2 CAE on Windows NT problem12_Chris Miller24_Chris_Miller@PAYLESS.COM31_Wed, 22 Mar 2000 13:19:28 -0600639_us-ascii Platform: CAE on NT

Elaine, I think I may have some info that might be helpful regarding your NT cataloging problem. We experienced the same problems a year or so ago when we began working with Windows NT clients. Here's my understanding of how the process works:

(1) DB2 considers the act of cataloging nodes, databases, etc an "administrative" function. The DB2 client software utilizes the OS's security system to determine if the current user has the authority to catalog databases. "Real" operating systems (not Win95/98) do not have a real security system. Consequently, anybody can catalog anything on a [...] 3984 52 32_Re: Question: Cloning subsystems12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 22 Mar 2000 11:24:56 PST493_- Wayne:

I did it many times following the next steps:

1. Execute the archive log command to force db2 make an archive log. 2. Stop the db2 subsystem. 3. Execute a dfdss job to copy and rename the new db2 datasets(directory,catalog and user tables). 4. Change DSNZPARM specifying the new catalog (vcat) to be used by your new db2 subsystem. 5.Start your db2 subsystem. 6.Now if db2 is up , you must alter the storage group for all your new db2 user tablespaces and indexes. [...] 4037 117 18_Re: AD HOC QUERIES11_Eric Robida22_Eric_Robida@BCBSME.COM31_Wed, 22 Mar 2000 14:21:11 -0500512_us-ascii This only applies if the user does not care that the results may not be 100% accurate.







Don Alden on 03/22/2000 02:07:53 PM

To: DB2-L@RYCI.COM cc: (bcc: Eric Robida/BCBSME) Subject: Re: AD HOC QUERIES







A good way to run run SQL queries against a DB2 Production environment is to use a DB2 Uncommitted Read. This process uses a DB2 "dirty read" and does not incur any Locks. Use the following format .. [...] 4155 90 33_Re: DB2 CAE on Windows NT problem15_Craig Wahlmeier27_cwahlmeier@DATA-TRONICS.COM31_Wed, 22 Mar 2000 13:52:12 -0600581_iso-8859-1 Elaine,

I get this question a lot! You must be logged on LOCALLY as an administrator. NOT to your domain but to the local machine. Plus your userid must be a member of the sysadm group that you have defined locally on the client machine. (Yes this is stupid.) Now, you said that "My userid belongs to the local Administrators group on the workstation, which should give me SYSADM authority in DB2." Ok, I don't know if you are implying that administrators is defined as your local sysadm group, or if you think that by default administrators would have that [...] 4246 22 11_Control DB216_Gary L. Sakamoto17_garys2@US.IBM.COM31_Wed, 22 Mar 2000 14:37:36 -0500479_us-ascii Does anyone have a phone number or website address for the product 'Control DB2', by KCI. Have been trying to get in touch with them, but the only phone number we have is to the marketing reps home. Thanks for any help you may have.



Gary L. Sakamoto - IBM Global Services (DB2 Support) 1630 Long Pond Rd., Rochester, NY 14626 External phone 716-720-7845 T/L 451-7845 Profs - GARYS2@PKMFGVM4 Lotus Notes - GARYS2@IBMUSM01 Internet - GARYS2@US.IBM.COM [...] 4269 31 45_VB calling stored procedures with Row Results12_John Cameron26_JCameron@MSI-INSURANCE.COM31_Wed, 22 Mar 2000 14:09:28 -0600533_us-ascii We are currently using stored procedures in Visual Basic applications using the parmlist for returning data to the client. We started looking into using Row Results and we're not finding any information on how it should be set up ? In VB, calling the stored procedure opens the cursor, leaving the fetches up to the client. Do we need to call another program on the mainframe to fetch the rows, or is there a way to fetch from VB ? If anybody out there has experience with this, I would certainly appreciate some tips. [...] 4301 378 49_April 7th Meeting DELAWARE VALLEY DB2 USERS GROUP18_Mulligan, Thomas J30_Thomas.Mulligan@PHL.BOEING.COM31_Wed, 22 Mar 2000 15:49:51 -0500629_iso-8859-1 DELAWARE VALLEY DB2 USERS GROUP

____________________________________________________________________________ _

MEETING DATE: Friday, April 7th, 2000 LOCATION: HOLIDAY INN PHILADELPHIA AIRPORT STARTING TIME: 9:00 AM REGISTRATION: 8:30 AM - 9:00 AM COST: ADVANCE REGISTRATION: MEMBERS $30, NON-MEMBERS $40 WALK IN REGISTRATION: MEMBERS $50, NON-MEMBERS $60 ____________________________________________________________________________ _

AGENDA

09:00 - 09:15 Opening Remarks Rachel Murawski, Chairperson DVDUG ____________________________________________________________________________ _ [...] 4680 25 11_Re: UDB2 V70_22_Rohn.Solecki@MTS.MB.CA31_Wed, 22 Mar 2000 15:36:18 -0600627_us-ascii This may not be an official announcement, but I think it is reasonably reliable. The Mar 3 issue of Computing Canada (at http://www.plesman.com) in the article "Major database updates add fuel to competition" report that "IBM Corp. will unveil DB2 Universal Database V. 7 in the summer".

The features mentioned are: "DB2 V 7.0 will have a 64-bit engine for higher performance, said Brett MacIntyre, director of the Toronto lab. It will also support for XML and for the PSM language, allowing the development of stored procedures. Log size will increase to 32 GB so it can handle long-running transactions. [...] 4706 25 6_DB2 V612_Silvia Motta21_silviamotta@YAHOO.COM31_Wed, 22 Mar 2000 13:50:17 -0800376_us-ascii Hello dba's, I need to convince my boss to buy Db2 v6 on OS/390. But him ask me for advantage over V5. I peek up from same articles the generals advantages. Can you help me ???

Thanks very much, silvia.



__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com [...] 4732 42 40_What's wrong with my partitioning keys ?13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Wed, 22 Mar 2000 21:58:26 +0000449_us-ascii I've got a table with two columns in the key -

COL1 CHAR(3) COL2 CHAR(17)

I need to partition on these columns using the following key ranges (quotes are to show the position of spaces) -

'MAP' ' 99999999999999999' : part 1 'NB ' ' 50000000000 ' : part 2 'NB ' ' 55000000000 ' : part 3 'NB ' ' 60000000000 ' : part 4 'OB ' ' 50000000000 ' : part 5 'OB ' ' 60000000000 ' : part 6 'PAS' 'ZZZZZZZZZZZZZZZZZ' : part 7 [...] 4775 68 44_Re: What's wrong with my partitioning keys ?11_Suresh Sane21_data_arch@HOTMAIL.COM29_Wed, 22 Mar 2000 16:56:51 CST609_- A couple of guesses ...

1. The index is defined DESCENDING on col2 - in this case the first part will match all keys for a given col1. 2. Are you missing a comma between the 2 values?

Suresh

>From: Philip Nelson >Reply-To: Philip Nelson >To: DB2-L@RYCI.COM >Subject: What's wrong with my partitioning keys ? >Date: Wed, 22 Mar 2000 21:58:26 +0000 > >I've got a table with two columns in the key - > >COL1 CHAR(3) >COL2 CHAR(17) > >I need to partition on these columns using the following key ranges (quotes >are to show the position [...] 4844 477 3_Job15_Mohammed Nayeem21_db2udbxpert@YAHOO.COM31_Wed, 22 Mar 2000 15:32:02 -0800375_us-ascii Hi

I am certified DB2 UDB DBA and have more than six years experience in s/w developemnt, Support and Administration. I am looking for suitable position in USA and if you have any vacancy is available based on my skills,experience & qualification then plz call me at (612) 220 - 5121. I am staying in Minneapolis. Enclosed attachment contains my resume. [...] 5322 479 31_Looking for DB2 UDB opportunity15_Mohammed Nayeem21_db2udbxpert@YAHOO.COM31_Wed, 22 Mar 2000 15:35:20 -0800375_us-ascii Hi

I am certified DB2 UDB DBA and have more than six years experience in s/w developemnt, Support and Administration. I am looking for suitable position in USA and if you have any vacancy is available based on my skills,experience & qualification then plz call me at (612) 220 - 5121. I am staying in Minneapolis. Enclosed attachment contains my resume. [...] 5802 370 37_Re: Remedy for List Prefetch problems14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 23 Mar 2000 10:38:18 +1000604_us-ascii Sally,

The SQL is really awful. You won't be able to tune it properly without some adjustment. e.g. add logically redundant boolean term predicate: AND PROCEMPL <= :WDET_PROCEMPL

Multi-index access is normally not good for scrolling reposition or restart repositioning. For large amount of data is likely cause of RID Pool problems. However without it, your SQL must scan a large amount of unnecessary rows where PROCEMPL > :WDET_PROCEMPL (not required) because the SQL has not been written right. The extra redundant scanning may still be better than the Multi-index access. [...] 6173 34 43_What can speed up a MAX(column) selection ?13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Thu, 23 Mar 2000 00:26:15 +0000465_us-ascii I'm tuning an application, and have identified that the following statement is problematic -

SELECT MAX(PHM_NUMBER) INTO :hostvariable FROM T0040POLHLDR_MEMBR;

PHM_NUMBER is the unique index supporting the primary key on the table. The table has about 1.5 million rows.

When I watch the job running in the monitor I see the number of fetches on the cursor it is processing pause, and the statement identified is always the above. [...] 6208 45 10_Re: DB2 V69_SrinivasG17_SRINIVASG@INF.COM31_Thu, 23 Mar 2000 08:35:28 +0530488_iso-8859-1 Hi, Check out the site www-4.ibm.com/software/data/db2/os390

It has lots of info on DB2 V6 for OS/390

Srini

-----Original Message----- From: Silvia Motta [mailto:silviamotta@YAHOO.COM] Sent: Thursday, March 23, 2000 3:20 AM To: DB2-L@RYCI.COM Subject: DB2 V6



Hello dba's, I need to convince my boss to buy Db2 v6 on OS/390. But him ask me for advantage over V5. I peek up from same articles the generals advantages. Can you help me ??? [...] 6254 50 40_Re: Insert VARCHAR longer than 255 bytes14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 23 Mar 2000 14:27:36 +1100452_iso-8859-1 Unfortunately, my response to people saying "I'm getting an error and how can I fix it?" is to ask "what error?" DB2, depending on the circumstances, can produce any of literally hundreds of errors. In future, when asking this type of question please produce the actual error messages. I know that SPUFI produces a nicely formatted dump of the SQLCA; unfortunately QMF sometimes is a bit clever, but still produces some error messages. [...] 6305 187 37_Re: Remedy for List Prefetch problems10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 23 Mar 2000 04:11:31 GMT575_us-ascii Hi Venkat, Good points but still more clarifications required.What if cluster ratio is poor ,RID union or intersection is done and for the result RIDs data is still scattered because as i understand RID intersection /union in the multiple index access doesn't sort the RIDs with the same intention as it does in the list prefetch ,it does the sorting only to either remove the duplicates or merge the RIDs.As u mentioned in the next stage list prefetch takes the sorted RIDs but if the data is clustered then RID sort in the order of data for the list prefetch [...] 6493 69 47_Re: What can speed up a MAX(column) selection ?11_Suresh Sane21_data_arch@HOTMAIL.COM29_Wed, 22 Mar 2000 23:22:53 CST336_- Philip:

Have you considered creating a DESCENDING index by phone number? This should be used and lead to an I1 (one-fetch) index scan since only the first leaf pages needs to be accessed. This could be in place of or inaddition to the ASC index you must currently have leading to an index w/ matchcols = 0 type of access. [...] 6563 81 47_Re: What can speed up a MAX(column) selection ?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 23 Mar 2000 05:26:04 GMT567_us-ascii Hi Philip Nelson, As far as the MAX or MIN in the indexeable columns are concerned it should be satisfied with either direct index lookup or index only access.Look at the total number of pages and levels in ur index.We had a discussion in the list about 7 months ago about ascending index satisfying the MIN function with direct index lookup and descending index MIN function.The only problem is that whenever i look at the index structure it looks opposite to me. I think Micheal or Venkat will be able to clarify my doubt as well.The only thing i can [...] 6645 17 47_Re: What can speed up a MAX(column) selection ?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 23 Mar 2000 05:43:27 GMT360_us-ascii I am sorry, i should have told one fetch access instead of direct index lookup.

Regards

Sanjeev

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6663 22 48_Where does DB2 record the status of tablespaces?12_Gary Darvill20_garydarv@AU1.IBM.COM31_Thu, 23 Mar 2000 14:46:28 +1100500_us-ascii Where does DB2 record the status of tablespaces?

Gary Darvill Senior Performance Analyst Performance & Tuning, Brisbane Enterprise Services, IBMGSA

Phone: 07 3887 8127 Mobile: 0417 076 469 Fax: 07 3211 9196 e-mail: garydarv@au1.ibm.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. 6686 49 52_Re: Where does DB2 record the status of tablespaces?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 23 Mar 2000 06:07:54 GMT505_us-ascii I think it is DBD of the database for that tablespace.

Regards

Sanjeev









Gary Darvill @RYCI.COM> on 03/23/2000 09:16:28 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Where does DB2 record the status of tablespaces?



Where does DB2 record the status of tablespaces? [...] 6736 39 52_Re: Where does DB2 record the status of tablespaces?15_Jones, Scott A.15_scjones@CSW.COM31_Thu, 23 Mar 2000 00:36:12 -0600611_- As I recall this is recorded somewhere in a "in-memory" table? I don' t believe you have access to this information execept via the -DIS DB(XXXX) SPACE(*) DB2 command. I could be very wrong though.

> ---------- > From: Gary Darvill[SMTP:garydarv@AU1.IBM.COM] > Reply To: DB2 Data Base Discussion List > Sent: Wednesday, March 22, 2000 9:46 PM > To: DB2-L@RYCI.COM > Subject: Where does DB2 record the status of tablespaces? > > Where does DB2 record the status of tablespaces? > > Gary Darvill > Senior Performance Analyst > Performance & Tuning, Brisbane > Enterprise Services, IBMGSA > > Phone: [...] 6776 18 31_Transaction Recovery - Really??12_Mark Crosset20_mcrosset@HOTMAIL.COM29_Thu, 23 Mar 2000 02:11:22 EST581_- Does anyone have experience with BMC's high speed transaction recovery? Is it really possible to remove a single transaction while maintaining the integrity of all the others? Any opinions or experience appreciated.

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6795 19 16_Re: Parallel SQL12_Mark Crosset20_mcrosset@HOTMAIL.COM29_Thu, 23 Mar 2000 02:28:15 EST357_- The conversations so far have been on splitting up the batch SQL jobs into multiple jobs in order to get parallelism. Is that the only way? I really don't like touch jobs that work well, except for performance. I will be force to weigh the cost of bad performance against allowing applications to make changes and probably errors in production jobs. [...] 6815 50 37_Re: [Transaction Recovery - Really??]9_Jo K.Nash17_jo.k.nash@USA.NET29_Thu, 23 Mar 2000 02:33:38 EST384_US-ASCII Mark,

Welcome back. Hope the trip was good...

To answer your second question, yes transaction recovery is possible. I've been writing sql that undoes a previous sql error for awhile. It takes a little time and effort, but it's doable. No experience with BMC's high speed trans recovery, I saw a got blurb (marketing fluff stuff you know). See you at IDUG. [...] 6866 26 10_Re: DB2 V614_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 23 Mar 2000 09:09:05 +0100308_us-ascii I had the same problem, too !!!

Once I tryed to convince my boss (where i worked 1 year ago) him that we can store our statement of accounts in pics, we can offer some services via WEB, we can use triggers & Java , rebalancing partitions etc.. He said: too expensive for some nice toys. [...] 6893 23 53_Using QMFCI for better performance of Dynamic SQL....19_Karthik Subramaniam26_karthik.subramaniam@DB.COM31_Thu, 23 Mar 2000 18:01:38 +0530614_us-ascii Hello, Can somebody throw some light on how to invoke the QMFCI inside an application program involving CICS and COBOL in an OS/390 environment. Thanks and Regards. __________________________________ Karthik Subramaniam Deutsche Software India Ltd. Raheja Towers 26-27, M.G. Road, Bangalore 560005. Tel : 91-80-5596314 Ext: 588 ___________________________________

================================================ 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. 6917 52 41_Omegamon Historical Stats - Summarisation9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Thu, 23 Mar 2000 12:55:32 +0000423_us-ascii Hi, Im wanting to use the Omegamon (V4) on-line historical data collector (H2) logs as source to the Summariser utility to load the target DB2 historical tables. I want the Summariser utility to populate the '......._SUMHOUR' tables (i.e. input data is summarised for 1 hour periods). When an H2 log becomes full, it will, - switch to another H2 log - immediately initiate a job to summarise the full H2 log. [...] 6970 29 42_INC / EXC indicator settings in CA-ProEdit16_Ruane, Paul (P.)16_pruane1@FORD.COM31_Thu, 23 Mar 2000 08:51:34 -0500572_iso-8859-1 Does anyone know what causes the INC / EXC field on the CA-ProEdit query parms browse/edit screen to be set to I for some users but not for others? Is this a profile setting?

Regards

Paul Ruane

European Customer Information Systems Ford Motor Company

+44 (0)1268 704075







===============================================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. 7000 59 23_The famous SQLCODE -90113_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Thu, 23 Mar 2000 08:59:49 -0500442_us-ascii I haven't seen this one before. I will rarely get a SQLCODE -901 during program execution ("Unsuccessful execution caused by a system error that does not preclude the successful execution of subsequent SQL statements") -- but this is the first time I got it during a BIND. I have taken a production Cobol program and am doing a Precompile / Compile / Linkedit / Bind. No errors during Precompile or Compile. BUT, the bind says: [...] 7060 17 8_DSNTIAUL12_Greg P Mucha24_Greg_P_Mucha@CARADON.COM31_Thu, 23 Mar 2000 14:18:30 +0000408_us-ascii Is there any way to run a batch query of DELETES and force commits every so often, or I am forced to write a program to do this???

Thanks,

Greg

================================================ 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. 7078 14 27_Re: The famous SQLCODE -90114_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 23 Mar 2000 15:21:33 +0100332_us-ascii Are you using a 3rd party product for bind or as an help bind ?

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. 7093 78 27_Re: The famous SQLCODE -90111_White, Mary28_Mary_White@FDLES.STATE.FL.US31_Thu, 23 Mar 2000 09:23:29 -0500443_iso-8859-1 Below is an excerpt from the DB2 Messages manual that might apply:

"The error might occur if the length of the SQL statement is less than 0, or is greater than the DB2 maximum length for a statement."

Could your statement be too long?

-----Original Message----- From: Lockwood Lyon [mailto:Lockwood_Lyon@AMWAY.COM] Sent: Thursday, March 23, 2000 9:00 AM To: DB2-L@RYCI.COM Subject: The famous SQLCODE -901 [...] 7172 33 12_Re: DSNTIAUL14_Arnold, Mark S20_Mark.Arnold@BNSF.COM31_Thu, 23 Mar 2000 08:23:46 -0600458_iso-8859-1 You can do a commit after each delete statement. Is that what you want, or are you wanting to commit while doing the delete?



-----Original Message----- From: Greg P Mucha [mailto:Greg_P_Mucha@CARADON.COM] Sent: Thursday, March 23, 2000 8:19 AM To: DB2-L@RYCI.COM Subject: DSNTIAUL



Is there any way to run a batch query of DELETES and force commits every so often, or I am forced to write a program to do this??? [...] 7206 37 12_Re: DSNTIAUL19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 23 Mar 2000 08:26:48 -0600619_iso-8859-1 Greg, If your problem is that you're exceeding max locks, add a LOCK TABLE statement. 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 [...] 7244 158 12_Re: DSNTIAUL9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Thu, 23 Mar 2000 14:28:07 -0000491_iso-8859-1 Greg,

If you have QMF then you could amend the instructions below to suit. These instructions are used by developers at our site to break up large DMLs.

Good luck, Jim.



Procedure

Determine the Query required and the Source of the Data E.g.

Query Required

INSERT INTO P.POPPPT (PO_NBR, PO_AMEND_NBR, REPRINT_USER_ID, INVTRY_CONTROLLER, REPRINT_IND,NEXT_ACTION_TIME, SUPLR_ACCT_NBR ) VALUES('&1', '&2', '&3', '&4', '&5','&6'); [...] 7403 27 45_Reverse engineering an E-R model from DB2 V6.13_Brendan Friel18_b.friel@PECORP.COM31_Thu, 23 Mar 2000 08:46:55 -0600377_iso-8859-1 I'm currently looking at a DB2 database that was basically cloned from a set of VSAM files. It looks like the tables were set up to correspond to the files without much of a data modeling effort.

Is there any way I can use the DB2 catalog information to produce an E-R model or similar information to show what the relationships are between the tables ? [...] 7431 90 12_Re: DSNTIAUL12_Greg P Mucha24_Greg_P_Mucha@CARADON.COM31_Thu, 23 Mar 2000 14:54:10 +0000389_us-ascii Thanks for your reply, Mark.

I'm doing something as simple as DELETE FROM TABLE.TBLNAME; or DELETE FROM TABLE.TBLNAME WHERE TBLKEY NOT IN ('x1', 'x2',....'xn').

What happened last night was that DB2 started asking for cartridges to back stuff up until they ran out of cartridges. So the Operators cancelled the whole friggin' partition and created a REAL mess. [...] 7522 49 35_Re: Db2Connect Version announcement0_15_leon@CA.IBM.COM31_Thu, 23 Mar 2000 15:40:16 -0500445_us-ascii You know if I were to announce the date I would be take out the back and shot by some "IBM Legal" execution squad. However, you can count on DB2 Connect V7.1 being announced very very soon. I will not tell you exact day but I can tell you that announcement date is set to be several days before Lenin's (you know the guy that screwed several nations with his ideas of taking away from the rich and giving it to the poor) birthday. [...] 7572 12 49_Re: Reverse engineering an E-R model from DB2 V6.15_Lyle Kelly-LH-117_kelly.lh.1@PG.COM31_Thu, 23 Mar 2000 10:02:36 -0500292_us-ascii Bachman tools used to be able to do that.

================================================ 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. 7585 115 12_Re: DSNTIAUL8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Thu, 23 Mar 2000 09:06:51 -0600461_us-ascii If you need only to delete data and are in V6, you can use REORG with DISCARD option. It will be fast and easy. Thanks Bejoy







From: Greg P Mucha on 03/23/2000 08:54 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Bejoy Kurian/MDSC/MAYCO)

Subject: Re: DSNTIAUL







Thanks for your reply, Mark. [...] 7701 80 49_Re: Reverse engineering an E-R model from DB2 V6.11_Mayo Arthur19_Arthur.Mayo@IRS.GOV31_Thu, 23 Mar 2000 10:12:02 -0500536_iso-8859-1 Is Bachman still around ?

-----Original Message----- From: Lyle Kelly-LH-1 [mailto:kelly.lh.1@PG.COM] Sent: Thursday, March 23, 2000 10:03 AM To: DB2-L@RYCI.COM Subject: Re: Reverse engineering an E-R model from DB2 V6.



Bachman tools used to be able to do that.

================================================ 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. 7782 53 49_SV: Reverse engineering an E-R model from DB2 V6.0_19_Sven.Heidorn@CSN.SE31_Thu, 23 Mar 2000 16:16:19 +0100600_ISO-8859-1 Brendan,

you will probably need some tool like ERwin or S - Designor. Both of the above can reverse engineer from the database.

Sven Hedorn

> -----Ursprungligt meddelande----- > Från: b.friel@PECORP.COM [SMTP:b.friel@PECORP.COM] > Skickat: den 23 mars 2000 15:56 > Till: DB2-L@RYCI.COM > Ämne: Reverse engineering an E-R model from DB2 V6. > > I'm currently looking at a DB2 database that was basically cloned from a > set > of VSAM files. > It looks like the tables were set up to correspond to the files without > much > of a data modeling effort. > > Is there [...] 7836 50 49_Re: Reverse engineering an E-R model from DB2 V6.13_Ricardo Gomes30_ricardo.gomes@MELLO-IMPERIO.PT31_Thu, 23 Mar 2000 15:36:11 -0000355_iso-8859-1 Hi Brendan

Bachman/DBA (v4.20 is the one we currently have dated from October 1994) is just what you need for that purpose. It's quite a neat tool.

Should you need further information on it, please contact me.

(There are also other tools besides physical model ones, such as Bachman/Analyst that work pretty well too) [...] 7887 81 33_Re: DB2 CAE on Windows NT problem0_15_leon@CA.IBM.COM31_Thu, 23 Mar 2000 16:05:11 -0500271_us-ascii You are not really giving up anything on Windows NT. What you are doing is allowing any id on your WIndows NT machine to issue CATALOG commands. If you are like 99.99% of the users out there you are the only one who ever logs on to your Windows NT machine. [...] 7969 39 49_Re: Reverse engineering an E-R model from DB2 V6.15_Johnson, Steven23_X2SJOHNS@SOUTHERNCO.COM31_Thu, 23 Mar 2000 09:20:43 -0600672_- It became Cayenne. The tools were Groundworks and Terrain.

Steven Johnson Applications DBA



> -----Original Message----- > From: Mayo Arthur [SMTP:Arthur.Mayo@IRS.GOV] > Sent: Thursday, March 23, 2000 10:12 AM > To: DB2-L@RYCI.COM > Subject: Re: Reverse engineering an E-R model from DB2 V6. > > Is Bachman still around ? > > -----Original Message----- > From: Lyle Kelly-LH-1 [ ] > Sent: Thursday, March 23, 2000 10:03 AM > To: DB2-L@RYCI.COM > Subject: Re: Reverse engineering an E-R model from DB2 V6. > > > Bachman tools used to be able to do that. > > ================================================ > To change [...] 8009 245 37_Re: Remedy for List Prefetch problems20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 23 Mar 2000 10:14:37 -0500628_iso-8859-1 Sanjeev

The list prefetch is a must for multi-index access. The list -prefetch always work on RID-list which is sorted in ascending order. The list-prefetch can cut down I/Os drastically if it can find most pages in clusters of 150 page ranges. If it can't then list-prefetch may be expensive compared to sync i/o (comparing 1 page is brought through list-prefetch vs. 1 page brought through sync i/o). This implies that if cluster-ratio is extremely bad such that qualifying pages are separated beyond 150 page-distance than list-prefetch is not going to help. If cluster ratio is tolerable or very good [...] 8255 167 12_Re: DSNTIAUL12_Greg P Mucha24_Greg_P_Mucha@CARADON.COM31_Thu, 23 Mar 2000 15:25:57 +0000294_us-ascii Bejoy ---

I'm not a DBA....I don't have those manuals. And with the attitude of some of the folks in charge, if I start doing REORG's without knowing EXACTLY what I am doing, they are liable to yank MORE priviledges away from me.

Do you have some JCL I can look at? [...] 8423 71 49_Re: Reverse engineering an E-R model from DB2 V6.21_Christopher T Everett24_cteveret@DUKE-ENERGY.COM31_Thu, 23 Mar 2000 10:31:58 -0500412_us-ascii Brendan:

If you have a tool like ERwin or Embarcadero ER/Studio then you can use it to reverse engineer AS LONG AS RI has been defined to the catalog. If not, you are outta luck. You will have to build up the relationships on your own by looking at the key names and investigating the data to match up relationships. We had to do this on a project here(using ERwin) and found it easiest to: [...] 8495 53 35_Re: Transaction Recovery - Really??12_HEPP SHERY C17_schepp@SRPNET.COM31_Thu, 23 Mar 2000 08:32:38 -0700580_ISO-8859-1 Mark- we have bmc's recover plus and change accum for db2. Not sure if this is the same product you're talking about or not. I would gladly discuss further with you if they are the same.

Regards,



Shery Hepp SRP Sr. Database Adminstrator Information Services



(602)236-2650 pager (602)275-2508(8035) Dreams-we don't see things as they are, we see things as we are..... Success is getting what you want.....Happiness is wanting what you have...... "The question is not whether we will die, but how we will live." * Joan Borysenko [...] 8549 69 49_Re: Reverse engineering an E-R model from DB2 V6.12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 23 Mar 2000 15:32:00 -0000399_- Bachman was bought by Cayenne and renamed Groundworks/Terrain, Cayenne was bought by Stirling who urgently wanted to discuss us looking at ERwin as Terrain/Groundworks was now 'functionally stabilised' (ie. no further enhancements, fixes, etc.), then Stirling was bought by CA, who I think are going to run with ERwin, which is supposed to have the funtionality, but we have'nt tried it yet. [...] 8619 203 130_Repost: White Paper: "Business Intelligence Scalability for Real Workloads - The IBM S/390 Workload Manager" by Winter Corporation13_Morrill, John12_JohnM@VP.NET31_Thu, 23 Mar 2000 08:36:31 -0700724_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,

A new white paper, "Business Intelligence Scalability for Real Workloads - The IBM S/390 Workload Manager", written by database consultants, Richard Winter and Judith Davis, and published by the Winter Corporation, is now available. I'd be happy to send you the .pdf file (1006 Kbytes) per your request, or you [...] 8823 97 58_Repost: NEW! DB2 UDB for OS/390 Stored Procedures Web Site13_Morrill, John12_JohnM@VP.NET31_Thu, 23 Mar 2000 08:36:30 -0700482_- 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,

(Resending this with the correct URL...sorry for the error in previous note.) [...] 8921 211 12_Re: DSNTIAUL8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Thu, 23 Mar 2000 09:34:15 -0600841_us-ascii Greg,

This JCL works fine for me. Thanks

//REORG EXEC DSNUPROC,SYSTEM=DB2T,UID='REORGTST',UTPROC='' //SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR //SORTOUT DD UNIT=SYSDA,SPACE=(CYL,(5,1),,,ROUND) //SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(5,1),,,ROUND) //SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(5,1),,,ROUND) //SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(5,1),,,ROUND) //SORTWK04 DD UNIT=SYSDA,SPACE=(CYL,(5,1),,,ROUND) //DSNTRACE DD SYSOUT=* //SYSUT1 DD UNIT=SYSDA,SPACE=(CYL,(5,5),,,ROUND) //SYSPUNCH DD DSN=HLQ.O.PUNCH2,DISP=SHR, // UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE) //SYSREC DD DSN=HLQ.O.UNLD2,DISP=SHR, // UNIT=SYSDA,SPACE=(CYL,(5,5),RLSE) //DISCAR1 DD DSN=HLQ.O.DISC2,DISP=SHR, // UNIT=SYSDA,SPACE=(CYL,(5,5),RLSE) //SYSIN DD * REORG TABLESPACE OSWTD.TSRSTOSL DISCARD FROM TABLE CREATOR.TABLENAME WHEN (COLUMN1=???) DISCARDDN DISCAR1 [...] 9133 42 12_Re: DSNTIAUL16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Thu, 23 Mar 2000 07:46:00 -0800371_iso-8859-1 The answer to your question is: No, you cannot perform COMMITS during a single DELETE statement. The simplest way around it is to break down the data into smaller chunks and run multiple DELETE statements with COMMITS in between.

Tony Provenzola Nike Database Services x Phone * (503) 532-0772 Fax * (503) 532-1041 Email * Tony.Provenzola@nike.com [...] 9176 47 7_DB2 UDB11_Emrah GUVEN28_emrah.guven@PAMUKBANK.COM.TR31_Thu, 23 Mar 2000 17:08:09 +0200126_ISO-8859-9 Hi dear colleagues, Is this list , only for DB2 running on Mainframe ? Can we join about DB2 UDB ? regards mr guven 9224 61 38_DB2 UDB 6.1 on NT or AIX TPC-C Results14_Philip Gunning20_pgunning@BOSCOVS.COM31_Thu, 23 Mar 2000 10:52:03 -0500405_iso-8859-1 I'm sure many of you have seen the recent Microsoft ads in ComputerWorld, etc claiming to have set a new TPC-C record in SQL SERVER 2000 on all platforms. Does anyone know of the latest DB2 UDB V6.1 TPC-C result or if one is in the works? Thanks, Phil

Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS Assoc List Owner 9286 79 27_Re: The famous SQLCODE -90113_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 23 Mar 2000 09:50:00 -0600397_US-ASCII Hello Lockwood, I have seem many -901's in my time, testing new DB2 maintenance. It was usually caused when ZPARM OJPERFEH=YES. There are many fixes for this problem, check IBMLINK. You did not say what release of DB2 you were on, all my finding were on V5. If this is the case set OJPERFEH=NO and rebind. (temporary fix) Also I've seen some when DEGREE(ANY) was specified. HTH Kurt [...] 9366 20 49_Re: Reverse engineering an E-R model from DB2 V6.0_29_STANLEY_GOODWIN@MECH.DISA.MIL31_Thu, 23 Mar 2000 11:02:26 -0500426_us-ascii I don' think so, DO you have Platinum's log analyzer.



Stan Goodwin DAC MBG DB2 Support

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9387 110 52_Re: Where does DB2 record the status of tablespaces?15_Stovall, Martin16_MStovall@USG.COM31_Thu, 23 Mar 2000 10:05:12 -0600431_- I believe DB2 records the status in SYSLGRNX catalog tablespace

-----Original Message----- From: Gary Darvill [SMTP:garydarv@AU1.IBM.COM] Sent: Wednesday, March 22, 2000 9:46 PM To: DB2-L@RYCI.COM Subject: Where does DB2 record the status of tablespaces?

Where does DB2 record the status of tablespaces?

Gary Darvill Senior Performance Analyst Performance & Tuning, Brisbane Enterprise Services, IBMGSA [...] 9498 13 14_English Wizard12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Thu, 23 Mar 2000 10:35:34 -0600347_iso-8859-1 Is anyone familiar with English Wizard query tool and has anyone used it connected to DB2/390?

================================================ 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. 9512 517 37_Re: Remedy for List Prefetch problems10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 23 Mar 2000 16:53:00 GMT535_iso-8859-1 Hi Venkat, Some very nice explaination from ur side.Skipping the RID intersection for less than or equal to 32 RID list is something new to me.It means it is decided at the run time.One more thing is new to me is 150 pages range effect on the list prefetch performance.But i think with bad cluster ratio u still mean less than 80%. Still , once i had found that using OPTIMIZE FOR 20 ROW in one of my query(thinking 20 rows will be shown on the screen) was showing the List prefetch in explain but when i changed it to [...] 10030 103 27_Re: The famous SQLCODE -90119_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 23 Mar 2000 11:17:05 -0600625_iso-8859-1 Lockwood, APAR PQ22368 appears to be a direct hit on your problem. 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." [...] 10134 27 42_Re: DB2 UDB 6.1 on NT or AIX TPC-C Results13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Thu, 23 Mar 2000 12:22:12 -0500754_big5

Interested parties can visit:

http://www.tpc.org/

to get descriptions of the various benchmarks and the latest results.

-- LL







Philip Gunning @RYCI.COM> on 03/23/2000 10:52:03 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: DB2 UDB 6.1 on NT or AIX TPC-C Results





I'm sure many of you have seen the recent Microsoft ads in?ComputerWorld, etc claiming to have set a new TPC-C record in SQL SERVER 2000 on all platforms.? Does anyone know of the latest DB2 UDB V6.1 TPC-C result or if one is in the [...] 10162 33 11_Re: DB2 UDB12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 23 Mar 2000 20:01:46 +0200239_x-user-defined Hi, All DB2 platforms are accepted here.

Isaac Yassin

> Emrah GUVEN wrote: > > Hi dear colleagues, > Is this list , only for DB2 running on Mainframe ? Can we join about DB2 UDB ? > > regards > mr guven

10196 64 42_Re: DB2 UDB 6.1 on NT or AIX TPC-C Results14_Philip Gunning20_pgunning@BOSCOVS.COM31_Thu, 23 Mar 2000 13:08:47 -0500508_big5 Lockwood, I was certainly aware of the TPC site, I guess I should have restated the question, "Does anyone know what IBM is doing about it? Thanks, Phil Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS

----- Original Message ----- From: Lockwood Lyon Newsgroups: bit.listserv.db2-l To: Sent: Thursday, March 23, 2000 12:22 PM Subject: Re: DB2 UDB 6.1 on NT or AIX TPC-C Results [...] 10261 31 10_Re: DB2 V612_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 23 Mar 2000 12:05:00 -0500306_- How about telling him that eventually DB2 V5 will not be supported.

>>> DB2-L@RYCI.COM@inter2 03/22/00 03:50PM >>> Hello dba's, I need to convince my boss to buy Db2 v6 on OS/390. But him ask me for advantage over V5. I peek up from same articles the generals advantages. Can you help me ??? [...] 10293 29 24_DBV5 Optimizer Decisions15_Fred Occhipinti23_Fred_Occhipinti@FPL.COM31_Thu, 23 Mar 2000 13:23:51 -0500623_us-ascii The last few weeks I have been working on response time problems in our production CICS region. In the process I found two tables that were not indexed properly, so I copied them down to our acceptance region, and rebound the program in particular that was causing a reponse time bottleneck. Much to my surprise, the acceptance region optimizer chose a different index path than the production region. After this happened, I figured, okay, maybe the allocations of the tablespaces, reorg status, runstats, etc (I'm just a DBA trainee). Anyway, by the time I finished everything, the production and acceptance [...] 10323 54 42_Re: DB2 UDB 6.1 on NT or AIX TPC-C Results12_Jim Herrmann12_b3d@CUOL.NET31_Thu, 23 Mar 2000 12:26:37 -0600560_iso-8859-1 The results at tpc.org do not have any DB2 results. It only has MS-SQL Sever, Oracle, Sybase, and Infomix. The top performer, that Phillip was referring to, was SQL Server running Windoze 2000 on a 96 CPU Compaq Proliant costing 4.3 Million dollars. However, nowhere can I find how DB2 UDB would run on the same platform, or any other platform for that matter. That's what I would like to see. Lets compare apples to apples. In fact, where is the DB2 apple? The DB2 UDB page says that DB2 is #1 in benchmark performance, but this appears to be [...] 10378 62 28_Re: DBV5 Optimizer Decisions0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 23 Mar 2000 12:29:39 -0600455_us-ascii When you moved down to acceptance, you don't mention if you added the 'correct' indexes'. Assuming you didn't, are trying to recreate productiuon in acceptance before trying fix, here are a couple of ideas.

- How did you get the runstats on the tables in acceptance? Running Runstats util, or copying runstats from prod? If you did not copy them from prod, they may be different (assuming prod table has not been re-org'ed recently). [...] 10441 90 28_Re: DBV5 Optimizer Decisions15_Fred Occhipinti23_Fred_Occhipinti@FPL.COM31_Thu, 23 Mar 2000 13:44:40 -0500446_us-ascii The two tables that were joined had just been reorged/runstated in production a couple of days before during regular maintenance. I made a point to match both tables. Probably I should have copied the runstats from production, but I would think that a whole lot could not happen in 2 days, especially since 1 of the days were a weekend. The indexes were matched in both tables in acceptance and production before I loaded the data. [...] 10532 77 34_Repost: DB2 Ready for Windows 200013_Morrill, John12_JohnM@VP.NET31_Thu, 23 Mar 2000 11:49:01 -0700775_- 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,

Possibly surprising to some, IBM DB2 and Microsoft Windows 2000 engineers worked closely for some time to ensure DB2 was available and exploitive of Windows 2000 upon it's release. DB2 also meets every "Designed for Microsoft BackOffice" logo requirement. For information about DB2 Universal Database for Windows, go to http://www-4.ibm.com/software/data/db2/udb/udb-nt/ [...] 10610 96 28_Re: DBV5 Optimizer Decisions0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 23 Mar 2000 12:54:12 -0600350_us-ascii Here is a list of things to consider that Richard Yevich posted some time ago.

Things that affect Access Path: Any differences in any of the following could cause access path changes and there appear to be some differences from what you said.

The optimizer will make use of the following in order to build this best plan: [...] 10707 51 28_Re: DBV5 Optimizer Decisions16_Schuchard, Peter34_Peter.Schuchard@STARWOODHOTELS.COM31_Thu, 23 Mar 2000 14:12:04 -0500457_iso-8859-1 Ran into a similar problem and it turned out that the only difference of significance was nlevels in prod was 4 and it qa 3. Why db2 would consider that statistic meaningful enough to make a difference is beyond me because it definately made the wrong choice.

-----Original Message----- From: Fred Occhipinti [mailto:Fred_Occhipinti@FPL.COM] Sent: Thursday, March 23, 2000 1:24 PM To: DB2-L@RYCI.COM Subject: DBV5 Optimizer Decisions [...] 10759 25 32_DB2 UDB V6.1 Memory Requirements12_James Bilbro19_MR.DATABASE@HEB.COM31_Thu, 23 Mar 2000 14:30:57 -0600650_- Greetings!

Can anyone provide me with (or direct me to) information about memory requirements for DB2 UDB V6.1 on UNIX, relating to large numbers of concurrent connections? In the Version 6 for UNIX Quick Beginnings manual, on page 3, Table 1 provides information for 5, 10, 25, and 50 Concurrent Connections. I need numbers for 100, 200, and 300 concurrent connections - just "ballpark" estimates for capacity planning purposes on a Sun/Solaris platform. I've tried extrapolation, using the data in the table, but the incremental memory requirements (per connection) do not appear to be linear. I've searched the online documentation, [...] 10785 15 39_Data Sharing Error message notification14_Waterman, Fred22_FWaterman@AEGONUSA.COM31_Thu, 23 Mar 2000 14:17:18 -0600415_- I would like to automate DB2V5 data sharing error message notification. Does anyone have a list, source or table of messages currently being used?

Thanks in advance

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 10801 15 22_DB2 UDB Control Center10_Nash Gupta19_nashgupt@US.IBM.COM31_Thu, 23 Mar 2000 14:33:19 -0600354_- Hello List!

Need information to fire control center from under UDB 6.1 on AIX ...

Thanks! - Nash

================================================ 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. 10817 61 12_Re: DSNTIAUL11_Kwan, James18_James_Kwan@BMC.COM31_Thu, 23 Mar 2000 15:04:22 -0600434_iso-8859-1 Do you mean DSNTIAD instead of DSNTIAUL? DSNTIAUL is an unload program unless they have changed it. If you are doing a mass delete, may be you should also consider unload/load or use delete option during reorg.

James Kwan My opinions only.

-----Original Message----- From: Provenzola, Tony [mailto:Tony.Provenzola@NIKE.COM] Sent: Thursday, March 23, 2000 9:46 AM To: DB2-L@RYCI.COM Subject: Re: DSNTIAUL [...] 10879 91 12_Re: DSNTIAUL20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 23 Mar 2000 16:12:00 -0500548_us-ascii DSNTIAUL can run UPDATE or DELETE sql when PARM('SQL') is specified.

One fellow I know used to update production data using this. He moved an unload job to production which crossed every QA stage because it is unload what else you could do, other than unloading ?

He had access to control card library. He used to update tables at will using DSNTIAUL job. His intention was not too bad, he only wanted to correct the data corrupted by few programs but he wanted to by-pass all authorization process in-order to do that. [...] 10971 39 26_Re: DB2 UDB Control Center14_Philip Gunning20_pgunning@BOSCOVS.COM31_Thu, 23 Mar 2000 16:20:36 -0500429_iso-8859-1 Nash, You can administer AIX instances via DB2 Control Center on Win 95/98/NT/2000. Phil

Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS

----- Original Message ----- From: Nash Gupta Newsgroups: bit.listserv.db2-l To: Sent: Thursday, March 23, 2000 3:33 PM Subject: DB2 UDB Control Center [...] 11011 68 40_Re: Insert VARCHAR longer than 255 bytes14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 24 Mar 2000 09:51:35 +1000667_us-ascii James,

Aren't you being a bit tough? Pearl indicated that DB2 didn't like the length over 255 and we have had this one on the Listserv before. I agree with the general principal of questioners providing proper information.

Michael Hannan

>From: James Campbell >Subject: Re: Insert VARCHAR longer than 255 bytes >To: DB2-L@RYCI.COM > >Unfortunately, my response to people saying "I'm getting an error and how >can I fix it?" is to ask "what error?" DB2, depending on the circumstances, >can produce any of literally hundreds of errors. In future, when asking >this type of question please produce the [...] 11080 32 47_Re: What can speed up a MAX(column) selection ?12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Fri, 24 Mar 2000 12:14:48 +1300496_us-ascii Phil,

Hope you don't mind being called 'Phil'. The trick always used to be to create an index on the column you wanted max for specifying DESC as the order. So, only one I/O operation is required to get the max value, 'cause it's the first in the index. Yes, I know this means you have two indexes on the same column. No, I don't know if you could kill the other index. If the column is used for zeroing in on a particular value (which seems to be your case), then probably. [...] 11113 104 47_Re: What can speed up a MAX(column) selection ?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 24 Mar 2000 10:24:00 +1000433_us-ascii Sanjeev,

I normally wouldn't answer this question because others will handle well, and I knew Venkat would definitely answer. You made a slight slip. Should have said Descending index is for MAX function rather than for MIN.

On the other topic, 3 indexes with same clusterratio may have totally different clustering sequence. Increasing one to 100% by reorg will not increase all of them the same amount. [...] 11218 54 31_DSNTIAUL to generate data fixes14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 24 Mar 2000 10:24:06 +1000315_us-ascii Greg,

For Data Fixes that need either UPDATEs, DELETEs, or INSERTs, we use a technique of building a SELECT query that generates the fix statements run in DSNTIAUL. The generated UPDATEs (or DELETEs) may supply the full key to act on just one row, or sometimes may act on small groups of rows. [...] 11273 119 32_Repost: DB2 Skills Announcements13_Morrill, John12_JohnM@VP.NET31_Thu, 23 Mar 2000 16:35:37 -0700515_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,

FYI, below are some DB2 UDB for UNIX, Windows, OS/2 certification-related items for your information. [...] 11393 275 37_Re: Remedy for List Prefetch problems14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 24 Mar 2000 10:37:30 +1000636_us-ascii Venkat,

A good description of List Prefetch. Just one little technical correction to: "This implies that if cluster-ratio is extremely bad such that qualifying pages are separated beyond 150 page-distance than list-prefetch is not going to help"

It may not help much if the qualifying data ROWs (rather than pages) are separated beyond 150 pages. Could have groups of qualifying rows on same page, but pages spread widely. In this case List Prefetch could still help to reduce total no. if index did not group the rows similarly. This is particularly possible with Index Screening on List Prefetch coming in [...] 11669 31 66_Setting up DB2 Connect v6 on Aix 4.3 Gateway with Ethernet Adapter0_16_dumoore@NMSU.EDU31_Thu, 23 Mar 2000 16:33:23 -0700458_US-ASCII Hello,

I am trying to establish a distributed connection to MVS DB2 V5 through a gateway on AIX 4.3 using DB2 Communication Server V5.0 and DB2 Connect 6.1 Enterprise Edition with an ethernet adapter card. I currently have this same setup running through a different AIX box with a token ring adapter. I was wondering where I can get a detailed description of the difference in parameter values that the different adapter cards require. [...] 11701 37 10_Re: DB2 V612_Jim Harrison12_jimh@QIS.NET31_Thu, 23 Mar 2000 13:41:59 -0500816_us-ascii I just finished the Version 6 Transition class and there is a *lot*. Try this address:

http://www2.ibmlink.ibm.com/cgi-bin/master?xh=MFZwkFkHVBIoan0USenGnN9332&request=announcements&parms=U%5f299%2d154&xfr=N

At 01:50 PM 3/22/00 -0800, Silvia Motta wrote: >Hello dba's, > I need to convince my boss to buy Db2 v6 on OS/390. >But him ask me for advantage over V5. I peek up from >same articles the generals advantages. >Can you help me ??? > >Thanks very much, >silvia. > > >__________________________________________________ >Do You Yahoo!? >Talk to your friends online with Yahoo! Messenger. >http://im.yahoo.com > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage at http://www.ryci.com/db2-l. [...] 11739 154 47_Re: What can speed up a MAX(column) selection ?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Fri, 24 Mar 2000 04:05:50 GMT570_us-ascii Yes Micheal/Venkat , It was a slip in writing.So the for MAX ,descending index and for MIN ascending index .I also say this because i have read in many books but Why i wrote "whenever i look at the index structure it looks opposite to me" is because of this :-- Root page of the ascending index contain set of key values and pointers to the corresponding non-leaf pages.It keeps the maximum key value for their corresponding non-leaf page.So, what i think the last key value in the root page is the maximum value for the key.Similarly, in descending index [...] 11894 66 32_Deleting where current of cursor12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Fri, 24 Mar 2000 17:09:05 +1300572_us-ascii Greetings all,

Here's a wee puzzle for all you DB2 coders out there in programming land. First off, DB2 for OS/390 V5, 9910-ish, Cobol II. We have a simple RI structure with two tables. Let's call them Parent and Child. The tables hold search result rows from user's queries. For every search, one row will be inserted into Parent (giving search id, date of search, other bits of crap, etc.) and between 0 and N rows inserted into Child, depending on how many result rows the search had. The RI rule is Cascade, and a daily process sweeps through the [...] 11961 115 36_Re: Deleting where current of cursor23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Fri, 24 Mar 2000 05:06:47 -0000678_iso-8859-1 is it possible to do a lock table for both tables when running the deletion of old records????

Andrew Puddy



-----Original Message----- From: Raymond Bell [mailto:raymondb@NZ1.IBM.COM] Sent: Friday, 24 March 2000 14:09 To: DB2-L@RYCI.COM Subject: Deleting where current of cursor



Greetings all,

Here's a wee puzzle for all you DB2 coders out there in programming land. First off, DB2 for OS/390 V5, 9910-ish, Cobol II. We have a simple RI structure with two tables. Let's call them Parent and Child. The tables hold search result rows from user's queries. For every search, one row will be inserted into Parent (giving [...] 12077 21 28_Good admin books for DB2 udb25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG29_Fri, 24 Mar 2000 06:09:53 GMT365_us-ascii Hi,

Can somebody suggest good db admin for DB2 UDB v6. I am expecting the book to have the basic concepts, the admin of the db server (like starting a installation/ starting an instance/ defining objects etc) and addressing some performance topics. Also appreciate if anybody can refer some redbooks which details on db admin on AIX and Hp ux. [...] 12099 107 36_Re: Deleting where current of cursor10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Fri, 24 Mar 2000 06:30:27 GMT533_us-ascii Hi Raymond Bell, With the help of information given by u i can guess few things, which may not be correct as well... : 1) Check ur program logic.It might be repositioning the cursor. I get a feeling that after deleting the child table records u are going for fetch and for the last parent record u are not able to delete because fetch would have given sqlcode 100. 2) Check that u do not have any WHERE CLAUSE in delete query with WHERE CURRENT OF , i think its value might cause problem. I have not checked whether it [...] 12207 199 36_Re: DB2 UDB V6.1 Memory Requirements11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Fri, 24 Mar 2000 18:13:32 +1100319_- James,

I don't have the Version 6 for UNIX Quick Beginnings manual here, so I cannot cross-check that table, but the Version 5 Administration Guide has some information on it in Appendix C. (It does not seem to be in the V6 Admin Guide any more, I assume it has migrated to the Quick Beginnings manuals.) [...] 12407 82 10_Re: DB2 V614_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 24 Mar 2000 17:55:09 +1100559_iso-8859-1 Silvia,



You said you have a "need to convince your boss". Do you really mean "need"? This implies that you already have already identified how V6 will benefit your organisation. And now you want to convince your boss about those benefits.

However the rest of your question implies that the real reason for wanting V6 is something else - improving your personal expertise, for example - and you are trying to justify this. Perhaps "I _want_ to convince my boss to buy Db2 v6 on OS/390" is more accurate? [...] 12490 207 36_Re: Deleting where current of cursor0_18_mebert@AMADEUS.NET31_Fri, 24 Mar 2000 09:39:52 +0100435_us-ascii Hi Mr. B,

look at the SQL Reference, p.333 "DECLARE Cursor...WITH HOLD". It appears to me that the positioning on the current row is lost when you do a COMMIT:

...Afterwards, an initial FETCH statement is required before a positioned update or delete statement can be executed. After the initial FETCH, the cursor is positioned on the row following the one it was positioned on before the commit operation. [...] 12698 176 10_Re: DB2 V60_18_mebert@AMADEUS.NET31_Fri, 24 Mar 2000 10:07:07 +0100583_us-ascii James,



Sorry but you're touching a nerve... I have to disagree. Just a few weeks after coming to my current company, I managed to improve a SAS reporting program (nothing to do with DB2, I just noticed it, and love SAS). It used about 9000 CPU-seconds daily, I could cut this to 6000, by replacing 10 lines of the original code with 20 of mine. This would save more than 1 M CPU-seconds a year, 1% of the total power of the 4-CPU machine. I gave detailed instructions, hinting that much larger savings were probably possible by looking [...] 12875 37 47_Re: What can speed up a MAX(column) selection ?25_Srinivas vani challapalli26_challapalli_vs@HOTMAIL.COM31_Fri, 24 Mar 2000 02:54:17 -0600389_- Hi, Sanjeev

I am not a DBA, Recently i Read this information. I hope this helps.

Column functions of MIN and MAX can be satisfied by one fetch-index access. To do this

MIN function requries a ASC index. MAX function requires a DESC index.

Minimum value - fist value on first leaf page of ASC index. Max value - last value on last leaf page of ASC index. [...] 12913 41 12_SQL-Question14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Fri, 24 Mar 2000 10:52:02 +0100400_us-ascii Hi everyone out there,

perhaps I'm just too plain dumb but I have difficulties in coding SQL in order to solve the following problem:

We have one table where we're encountering the following situation:

COL_A contains a certain value, say 'OKAY', COL_B may contain this very same value but with some other data, say 'SEN OKAY' or may contain totally different data. [...] 12955 74 47_Re: What can speed up a MAX(column) selection ?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Fri, 24 Mar 2000 09:55:21 GMT514_us-ascii Hi Srinivas, I have also posted the same paragraph what u have posted some 7 months ago in this list .It is mentioned in the books "INDEX USAGE FOR PERFORMANCE " from website http://www.GabrielleDB2.com ,but i was in confusion that time as well.If the descending index are stored and processed like ascending after doing exclusive Oring in the index values then the index values are changed and it has to do the Oring again to return that value. I think i am not able to visualize the whole stuffs . [...] 13030 107 12_Re: DSNTIAUL14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Fri, 24 Mar 2000 11:03:28 +0100566_us-ascii Just being nosey:

will RI be taken into account or do you have to run checks afterwards ? So far we prefer to unload the 'good' data and run load replace afterwards. Ruediger Kurtz

Kurian B schrieb: > > If you need only to delete data and are in V6, you can use REORG with DISCARD > option. It will be fast and easy. > Thanks > Bejoy > > From: Greg P Mucha on 03/23/2000 08:54 AM > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: (bcc: Bejoy Kurian/MDSC/MAYCO) > [...] 13138 51 42_Re: DB2 UDB 6.1 on NT or AIX TPC-C Results12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Fri, 24 Mar 2000 10:04:00 -0000560_- TPC benchmarks can be withdrawn by the submittors and it looks like vendors remove their benchmarks as soon as they are losing the race. I recall DB2 UDB dominating it a while ago. I'm not sure if members of TPC get to look at a history of results, but its too expensive to join just for that. Typically, results are submitted on software that is still in Beta eg. SQL Server 2000 on Windows 2000. It is often the hardware vendors who submit results rather than the database vendors, also, the configuration not what people would normally use, eg. RAID [...] 13190 26 26_datetime on event monitor.17_suthep thampranee18_suthepth@SCB.CO.TH31_Fri, 24 Mar 2000 17:36:55 +0700529_Windows-874 Dear all,

My database on DB2 V.5.2 on Solaris. I had created event monitor on Solaris and I opened it on my PC that install DB2 V5.2 (Personel Edition). I very strange that why data&time in my event monitor (analyze via db2eva on my PC) is not correct. ( But if I see db2evmon on Solaris, it is correct. ) For instance, I created 24/3/2000 but in my event (PC) show 23/3/2000 and time is not correct too. Inspite of current date&time from database(Solaris) and my system (PC) is right. I don't know why?. [...] 13217 87 16_Re: SQL-Question10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Fri, 24 Mar 2000 10:33:52 GMT394_us-ascii Hi, I think it can be done for a particular table or column.I do not know the generalized solution. Suppose the length of COL_A is char(4) and COL_B is char(8) .Find out all continuous possible position of length of COL_A in COL_B. Something like (specific to COL_A and COL_B data length mentioned above) substr(COL_B,1,4), substr(COL_B,2,4), substr(COL_B,3,4), substr(COL_B,4,4) [...] 13305 144 16_Re: SQL-Question0_18_mebert@AMADEUS.NET31_Fri, 24 Mar 2000 11:53:16 +0100479_us-ascii What is needed here is a POS or INDEX function, which alas seems to be missing in V5 on OS/390, according to the SQL Ref. If you really need to do this with SQL (it would be trivial using COBOL, REXX, SAS), then try something like this:

SELECT other_cols FROM ( SELECT LENGTH(STRIP(COL_A)) AS N ,STRIP(COL_A) AS CA ,COL_B||' ' AS CB ,other_cols FROM Table WHERE COL_A='value' ) T WHERE SUBSTR(CB, 1, N)=CA OR SUBSTR(CB, 2, N)=CA ..... OR SUBSTR(CB, m, N)=CA [...] 13450 47 30_AW: datetime on event monitor.0_20_mark.nicholls@TUI.DE31_Fri, 24 Mar 2000 13:57:04 +0100458_iso-8859-1 I think you will find that the time is not local but Coordinated Universal Time (UTC) aka. Greenwich Mean Time(GMT), this accounts for the difference you are seeing. hth

Mark Nicholls DB2 UDB Certified DBA

-----Urspr?ngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]Im Auftrag von suthep thampranee Gesendet am: Freitag, 24. M?rz 2000 11:37 An: DB2-L@RYCI.COM Betreff: datetime on event monitor. [...] 13498 78 27_Re: The famous SQLCODE -90113_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Fri, 24 Mar 2000 08:23:56 -0500357_us-ascii My thanks to all who responded on this issue. Indeed, as a few pointed out, this is a bug related to outer joins for which there are outstanding fixes. Rather than apply PTFs/maintenance, we elected to set OJPERFEH=NO in the ZPARMs for the subsystem. 'Suddenly', the program binds successfully.

-- Lockwood Lyon Amway Corp 616.787.1068 [...] 13577 101 36_Re: Deleting where current of cursor19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 24 Mar 2000 07:29:34 -0600511_iso-8859-1 Raymond, If the parent table cursor is built WITH HOLD, and if its not being closed accidentally when the child cursor is closed, its escaped me why its not working. Another issue is the cost of the commit processing vs concurrency gain. Was LOCKSIZE ANY and LOCK ESCALATION ever tested or used? Seems to me that if the bulk of the UOWs can complete with less than NUMLKUS or NUMLKTS, that would be the way to go. If not, I'd commit after every x child rows deleted rather than after every row. [...] 13679 76 42_Re: DB2 UDB 6.1 on NT or AIX TPC-C Results14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 24 Mar 2000 09:09:31 -0500304_iso-8859-1 Colin, I agree with what you are saying, but IT Managers (who may or may not be IT literate, many are not) tend to react to what they see in the IT literature, causing people who work where the rubber meets the road extra grief justifying what doesn't need to be justified. Regards, Phil [...] 13756 236 36_Re: Deleting where current of cursor11_White, Mary28_Mary_White@FDLES.STATE.FL.US31_Fri, 24 Mar 2000 09:12:12 -0500377_iso-8859-1 Below is an excerpt from the DB2 Application Programming and SQL Guide:

4.2.5.1.6 The Effect of WITH HOLD for a Cursor

© Copyright IBM Corp. 1983, 1997 Topic lines 1 to 16 of 35



For a cursor defined as WITH HOLD, the cursor position is maintained past

a commit point. Hence, locks and claims needed to maintain that position [...] 13993 209 47_Re: What can speed up a MAX(column) selection ?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sat, 25 Mar 2000 01:20:53 +1000355_us-ascii Sanjeev,

You are not correct in your assumptions about what is stored in the non-leaf pages of type 2 indexes. There is good reading in the IDUG presentations of Christina Lee and Bob Lyle (Santa Teresa Lab).

From memory, the root page does not, in general, contain the MAX value of lower pages being pointed to by each entry. [...] 14203 131 47_Re: What can speed up a MAX(column) selection ?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 24 Mar 2000 09:30:40 -0500347_iso-8859-1 Oops.. I was a little busy yesterday and I missed few mails.

Thanks Michael, also for correcting the list-prefetch description. I haven't tested index-screening with list-prefetch in V6, I will measure the improvement once I get some time. We have lots of query that would be benefited from index-screening & list-prefetch. [...] 14335 297 10_Re: DB2 V612_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 24 Mar 2000 06:36:55 -0800545_us-ascii Michael, I have to disagree with what you're saying. I understand part of my reply is off topic but "you touched a nerve". A) The BMW sale of Rover to Alchemy was not a matter of "Prestige". It was entirely a case of Stockholder value and dollars(Euros) and cents. A company the size of BMW cannot afford to forever bleed Euros trying to salvage something. At some point they must cut their losses. Consider also that BMW also sold Land Rover (which was making money) basically to generate income to offset all of the Rover costs. [...] 14633 157 16_Re: SQL-Question14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Fri, 24 Mar 2000 15:44:47 +0100568_us-ascii Thanks Sanjeev & Dr. Ebert,

I passed the query on to the developpers and it seems to have done the trick; at least I haven't heard anything since then.

Have a nice weekend

Ruediger Kurtz

mebert@AMADEUS.NET schrieb: > > What is needed here is a POS or INDEX function, which alas seems to be missing > in V5 on OS/390, according to the SQL Ref. If you really need to do this with > SQL (it would be trivial using COBOL, REXX, SAS), then try something like this: > > SELECT other_cols > FROM ( > SELECT LENGTH(STRIP(COL_A)) AS N [...] 14791 21 23_Store Procedure Control15_Antonio Ramalho20_aramalho@HOTMAIL.COM29_Fri, 24 Mar 2000 11:57:50 EST542_- Hi everybody,

How can I control which store proc one user can access? The store is called from a Novell workstation.

Any suggestion will be appreciatte

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14813 41 67_Running QMF in Batch and using CALC verb (DB2 v4.1 OS390 QMF v3.2 )9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Fri, 24 Mar 2000 15:03:04 -0000488_iso-8859-1 Problem: I am trying to execute QMF in batch where the form contains a CALCulation. QMF performs these calculations using REXX and returns the following error: MESSAGE NUMBER: DSQ50212 MESSAGE TEXT: REXX is unavailable for evaluation of calculations.

Background: The above Batch QMF runs using EXEC=DSQQMFE. REXX is currently available in the ISPF environment and I can get QMF Batch to run with CALCulations under IKJEFT01 but I prefer the DSQQMFE implementation. [...] 14855 44 49_Re: VB calling stored procedures with Row Results12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Fri, 24 Mar 2000 10:07:26 -0500594_us-ascii Did anyone reply to this question? I may have a similar problem in using a stored procedure called from ColdFusion. Does the ODBC standard allow data sets to be returned via cursors?

Martin Wolff, Global Crossing

John Cameron wrote:

> We are currently using stored procedures in Visual Basic applications using > the > parmlist for returning data to the client. We started looking into using > Row Results and > we're not finding any information on how it should be set up ? In VB, > calling the stored > procedure opens the cursor, leaving the fetches up to [...] 14900 86 49_Re: VB calling stored procedures with Row Results13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Fri, 24 Mar 2000 10:20:36 -0500403_us-ascii We (sort of) do this. We have an InterDev-created application that invokes our stored procedure. It connects via ODBC to our intranet web server (where we installed DB2Connect CAE), thence to our communications server and to DB2 for OS/390 V5. The SP OPEN-s three Cursors, then returns control to the application. The application then uses the appropriate ODBC calls to Fetch the results. [...] 14987 72 49_Re: VB calling stored procedures with Row Results14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 24 Mar 2000 10:30:55 -0500343_iso-8859-1 Chapter 15 of the DB2 Cert Guide V6.1 Third Edition has some info in it that might help you and there are examples off the DB2 home page. I forget the url but you should be able to find them. HTH Phil

Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS [...] 15060 40 130_Central PA RUG - April 5th/6th - DB2 UDB for V6 Migration & DRDA /DB2 Connect Classes - $150 each! - Linda Claussen - Register NOW10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Fri, 24 Mar 2000 10:29:00 -0500418_us-ascii Hi all! I wanted to give everyone a head's up on two upcoming all-day DB2 classes.

WHERE - Camp Hill, PA (Near Harrisburg)

WHEN - April 5th & April 6th

WHO - Linda Claussen

WHAT - DB2 UDB for OS/390 Version 6 - Migration and Implementation - April 5th

- DRDA and DB2 Connect - Putting the pieces of the puzzle together. (DRDA, DB2 Connect, TCP/IP and More) - April 6th [...] 15101 382 10_Re: DB2 V60_18_mebert@AMADEUS.NET31_Fri, 24 Mar 2000 17:33:53 +0100564_us-ascii Hi Myron,

probably I expressed myself too indirectly. It was the original acquisition of Rover that was a prestige move, not the "sale" (that was a frantic bailout): a couple of years ago big was beautiful for a company. As for point#2, well I guess I am just too impatient. Also, if increasing profits is managements main objective, they shouldn't need to be convinced when it's as simple as "one minute work, and save 1 Mio CPU seconds per year, forever". But then, I have never found anyone to give me a money value for a CPU second saved. [...] 15484 109 49_Re: VB calling stored procedures with Row Results20_Laurence M Crouch Jr24_lmcrouch@DUKE-ENERGY.COM31_Fri, 24 Mar 2000 12:02:28 -0500622_us-ascii I haven't followed this closely so if I restate something previously said, sorry.

VB using ADO can place result sets from a stored procedure in a recordset object. For example, if objcom is a command object and objrec is a recordset object, the statement 'Set objrec = objcom.Execute ' will execute the stored procedure, and any result sets can be accessed by looping through the recordset object (objrec in this example). Result sets are processed in the order sent by the stored procedure, i.e, if the stored procedure has multiple 'open cursor with return' statements, multiple result sets will be [...] 15594 80 71_Re: Running QMF in Batch and using CALC verb (DB2 v4.1 OS390 QMF v3.2 )11_White, Mary28_Mary_White@FDLES.STATE.FL.US31_Fri, 24 Mar 2000 12:38:51 -0500782_iso-8859-1 You have to run it under TSO. An example of the JCL is below:

//STEP01 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=QMF320.DSQLOAD,DISP=SHR // DD DSN=DSN410.SDSNEXIT,DISP=SHR // DD DSN=DSN410.SDSNLOAD,DISP=SHR //ADMGGMAP DD DSN=QMF320.DSQMAPE,DISP=SHR //DSQPRINT DD SYSOUT=*,DCB=(RECFM=FBA,LRECL=133,BLKSIZE=1330) //DSQDEBUG DD SYSOUT=*,DCB=(RECFM=FBA,LRECL=121,BLKSIZE=1210) //DSQUDUMP DD SYSOUT=*,DCB=(RECFM=VBA,LRECL=125,BLKSIZE=1632) //DSQSPILL DD DSN=&&SPILL,DISP=(NEW,DELETE), // UNIT=SYSDA,SPACE=(TRK,(100),RLSE), // DCB=(RECFM=F,LRECL=4096,BLKSIZE=4096) //SYSEXEC DD DSN=QMF320.DSQEXECE,DISP=SHR //SYSTSPRT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSQQMFE DSQSMODE=B, - DSQSRUN=XIMAWT.MYTEST_P, - DSQSSUBS=DSNT,DSQSPLAN=QMF320T // [...] 15675 26 73_How can you tell DB2 to stop after the first match in a select Count(*)??16_Christine Sawyer20_cosawyer@HOTMAIL.COM29_Fri, 24 Mar 2000 13:29:30 EST322_- Hi everyone, Could someone advise me how to tell DB2 to end SQL processing upon finding the first match in a " Select Count(*) INTO :WS-COUNT WHERE predicate1 = :HV1 AND predicate1 = :HV2 etc etc. I just want to know if some value(s) exist or not, not how many and I do not want to use exist (not exist) strategy?? [...] 15702 55 77_Re: How can you tell DB2 to stop after the first match in a select Count(*)??14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Fri, 24 Mar 2000 13:48:05 -0500595_iso-8859-1 Try

SELECT '1' into :hv where .... etc. etc

and if SQLCODE = 0 (1 row) or -811 (multiple rows) then the value(s) exist.

Manas.





> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Christine Sawyer > Sent: Friday, March 24, 2000 1:30 PM > To: DB2-L@RYCI.COM > Subject: How can you tell DB2 to stop after the first match in a select > Count(*)?? > > > Hi everyone, > Could someone advise me how to tell DB2 to end SQL processing upon finding > the first match in a " Select Count(*) > [...] 15758 58 29_DB2 CAE on Windows NT problem11_Nancy Reile24_Nancy.E.Reile@AM.PNU.COM31_Thu, 23 Mar 2000 16:09:07 -0500705_ISO-8859-1 Elaine,

We had to issue the following command on the client:

DB2 UPDATE DBM CMG USING CATALOG_NOAUTH YES

we actually put it into our install script.

Nancy

-------------------------------------------------------------------------------- Date: Wed, 22 Mar 2000 13:38:04 -0500 From: Elaine Lee Subject: DB2 CAE on Windows NT problem MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; name="cc:Mail" Content-Transfer-Encoding: 7bit

I am having a problem configuring the Client-to-Server Communications on the client workstation using the Client Configuration Assistant. When I try to catalog the remote database I get: [...] 15817 92 36_Speed table representing a hierarchy14_Mark Phillippi28_mphillippi@SENTRY-DIRECT.COM31_Fri, 24 Mar 2000 14:14:19 -0600350_- We are trying to create a speed table (as discussed in Craig Mullins' fine book: DB2 Developer's Guide Third Edition pp. 122 - 125). We would like to preserve order of the hierarchy within the speed table. I'll give an example using Craig's structures:

123456 | -------- | | 1234 56 | | --------- --- | | | | | 12 3 4 5 6 | --- | | 1 2 [...] 15910 21 29_Max rows vs row level locking0_23_Mike_Levine@TEKHELP.NET31_Fri, 24 Mar 2000 15:29:30 -0500510_us-ascii Hi,

This may be a simple question but which is more efficient: using MAX ROWS 1 with page level locking or row level locking with many rows on the page? Should one method be favored over the other?

TIA, Michael Levine Premier Data Services, Inc.

================================================ 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. 15932 128 40_Re: Speed table representing a hierarchy13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Fri, 24 Mar 2000 15:39:35 -0500443_us-ascii This jogged the old memory a bit. I believe that this type of tree structure was covered by Joe Celko in DBMS Online magazine. The archives are at:

http://204.33.180.114/artin301.html

Joe wrote an article called, "A Look at Trees" in March 1996, which you can find at the above URL. There are also (I think) three follow-on articles in subsequent issues. Check the Celko columns immediately following the 3/96 one. [...] 16061 56 33_Re: Max rows vs row level locking20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 24 Mar 2000 15:39:40 -0500460_us-ascii Mike

There are two issues here.

1. I/O expenses could be drastic with MAXROWS 1 and ROW level locks are preferable.

2. IRLM overheads - 250bytes per lock( I think it is 250, I forgot the exact value) is needed regardless of ROW or PAGE locks. However, I vaguely remember once Richard Yevich was mentioning ROW level locking has more overhead compared to MAXROWS 1 type PAGE locks. I don't have any bench-mark regarding that. [...] 16118 91 33_Re: Max rows vs row level locking16_Richard A Yevich21_ryevich@BELLSOUTH.NET31_Fri, 24 Mar 2000 15:09:45 -0500420_iso-8859-1 VP,

Not overhead but many other issues. A single lock, page or row, is the same. There are situations were ROW level locks can cause problems alleviated by MAXROWS 1 designs. Ineffectual use of ROW level lock can cause both more locks, more CPU, and even more deadlocks. It all "depends" on the use of the data, the indexes involved or not, scanning, and many other design and access constraints. [...] 16210 759 33_Re: Code/Valid Value Table Design16_Richard A Yevich21_ryevich@BELLSOUTH.NET31_Fri, 24 Mar 2000 15:25:32 -0500333_iso-8859-1 RE: Code/Valid Value Table DesignUlrich,

Just one or two comments. Seeing that you are in OZ, a classic example of Table Check Constraints would be the 3 digit state abbreviation for the 6 states in OZ. There are many many fixed and non-volatile codes in system that can be handled by Table Check constraints. [...] 16970 113 33_Re: Max rows vs row level locking20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 24 Mar 2000 16:32:57 -0500590_us-ascii Hi Richard

I am curious to know what are the situations when ROW level locks can cause problem which can be alleviated by MAXROWS 1 and what kind of problems ?

Thanks for the info Regards Venkat Pillay

> -----Original Message----- > From: Richard A Yevich [SMTP:ryevich@BELLSOUTH.NET] > Sent: Friday, March 24, 2000 3:10 PM > To: DB2-L@RYCI.COM > Subject: Re: Max rows vs row level locking > > VP, > > Not overhead but many other issues. A single lock, page or row, is the > same. There are situations were ROW level locks can cause problems > alleviated [...] 17084 91 33_Re: DB2 CAE on Windows NT problem10_Leo Pedron19_lpedron@BOSCOVS.COM31_Fri, 24 Mar 2000 16:47:43 -0500522_iso-8859-1 Just because your userid belongs to the local NT Administrator's group, that does not give you SYSADM in DB2. You need to belong to the SYSADM group as defined in the DBM CFG (SYSADM_GROUP) to be a SYSADM in DB2. You need to logged on as an admin on the domain that you are signed in to. If you are an admin in the local machine domain, then you need to be logged on to the local domain, not the network domain. You are being stopped by NT security, not DB2. Make sure that you are an administrator in the [...] 17176 162 33_Re: Max rows vs row level locking16_Richard A Yevich21_ryevich@BELLSOUTH.NET31_Fri, 24 Mar 2000 16:05:42 -0500471_iso-8859-1 Venkat,

You asked two questions: 1 - Problems --> Ineffectual use of ROW level lock can cause both more locks, more CPU, and even more deadlocks 2 - Situations --> Many

Eg: row level allows for multiple users, with multiple locks, on a single page, which has caused excessive deadlocks when multiple rows per user when being locked, dramatically increasing cost of locking, number of locks, etc. Another: during scanning, similar situation. [...] 17339 70 27_Re: Store Procedure Control14_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Fri, 24 Mar 2000 19:09:55 -0800473_- Hi Antonio.

Where does the stored procedure reside?

1) If its DB2 for OS/390 V5 or V4 and the SP uses static SQL (or dynamic SQL with DYNAMICRULES(BIND) on the SP package), the only authority required (assuming you get through the various connectivity security checks) is execute authority on the package associated with the stored procedure. With dynamic SQL and DYNAMICRULES(RUN) you need suitable access to the underlying tables accessed by the SP. [...] 17410 66 16_Re: SQL-Question8_cmullins23_CMullins@COMPUSERVE.COM31_Sat, 25 Mar 2000 03:07:08 -0500453_ISO-8859-1 If you are using DB2 V6 you can use the LOCATE function as follows:

SELECT columns FROM table WHERE LOCATE(COL_A, COL_B) <> 0

The LOCATE function finds the first value in the second and returns the starting location. If the value is not found, LOCATE will return 0.

Good luck, Craig S. Mullins Director, DB2 Technology Planning BMC Software http://www.craigsmullins.com Craig_Mullins@BMC.com cmullins@compuserve.com [...] 17477 143 33_Re: Max rows vs row level locking14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sun, 26 Mar 2000 01:53:01 +1000382_us-ascii Venkat,

Data Sharing is an area where MAXROWS 1 can be superior to row level locking. If multiple members are updating the same page but different rows with row level locking, as you know page p-locks have to be taken to ensure get latest copy of page from GBP. Also the updated page must be sent back and forward between the members and the Coupling Facility. [...] 17621 126 40_Re: Speed table representing a hierarchy14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sun, 26 Mar 2000 02:10:25 +1000353_us-ascii Mark,

I recently produced a report (in a spreadsheet) showing the hierarchy of R.I. relationships both DB2 maintained and application maintained, from every table downwards (upwards in another report) and in hierarchial sequence and included join predicates from each reln. in a spreadsheet cell for cut and paste into future SQLs. [...] 17748 75 77_Re: How can you tell DB2 to stop after the first match in a select Count(*)??17_Joao Alberto Lima22_joaolima@SENADO.GOV.BR31_Sat, 25 Mar 2000 15:08:32 -0600652_- Hi,

Try this...

Select 1 from SYSIBM.SYSDUMMY1 into :ws-count where exists (select 1 from tab where predicate1 = :HV1 and predicate1 = :HV2 etc...

Joao Alberto Lima DBA



On Fri, 24 Mar 2000 13:48:05 -0500, Manas Dasgupta wrote:

>Try > >SELECT '1' into :hv >where .... etc. etc > >and if SQLCODE = 0 (1 row) or -811 (multiple rows) then the value(s) exist. > >Manas. > > > >> -----Original Message----- >> From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of >> Christine Sawyer >> Sent: Friday, March 24, 2000 1:30 PM >> To: DB2-L@RYCI.COM >> Subject: How [...] 17824 56 77_Re: How can you tell DB2 to stop after the first match in a select Count(*)??14_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Sun, 26 Mar 2000 02:18:37 -0500429_us-ascii Issue your query as a single row select as follows:

Select 1 INTO :WS-COUNT WHERE predicate1 = :HV1 AND predicate1 = :HV2 etc etc.

DB2 will stop processing the SELECT and issue a -811 when the 2nd row that qualifies is encountered.







Christine Sawyer on 03/24/2000 01:29:30 PM

Please respond to DB2 Data Base Discussion List [...] 17881 34 10_Re: DB2 V614_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sun, 26 Mar 2000 23:45:08 +1000442_iso-8859-1 You are welcome to disagree, Michael. However, since my response was in the specific context of Silvia getting V6, what do you suggest he do?

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au -----Original Message----- From: mebert@AMADEUS.NET [mailto:mebert@AMADEUS.NET] Sent: Friday, March 24, 2000 7:07 PM To: DB2-L@RYCI.COM Subject: Re: DB2 V6 [...] 17916 68 26_Links about DB2 for OS/3906_DB2usa18_db2usa@HOTMAIL.COM31_Sun, 26 Mar 2000 10:41:50 -0600734_ISO-8859-1 Hi,

Here is a non-profit website about DB2 for OS/390 (IBM mainframes): - English : http://www.multimania.com/db2usa/eliendb2.htm - Français : http://www.multimania.com/db2usa/liendb2.htm

Last update on Saturday, March 25th 2000 ========================================

- Links about DB2 for OS/390: http://www.multimania.com/db2usa/eliendb2.htm Analyse de l'incorporation de l'objet-relationnel dans DB2 by M. Hendrickx and F. Ketelslegers.



- Technical papers: http://www.multimania.com/db2usa/earticle.htm March issue of Enterprise Systems Journal includes the following article: Gettting Started with Java and DB2 for OS/390 by P. Abelite et M. Cathcart , ESJ, February 2000 PDF [...] 17985 20 36_Re: Deleting where current of cursor12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 27 Mar 2000 10:54:17 +1200372_us-ascii Yes, it's possible to lock the table prior to the purge (or alter the tablespaces in the batch job to be locksize table/tablespace and then alter it back again) but anything above row locks out concurrent searches from inserting their search results while the batch job does the delete. Not many, granted, but it still happens. So, No, this isn't an option. [...] 18006 44 10_Re: DB2 V614_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 27 Mar 2000 09:43:58 +1000501_iso-8859-1 Of course you won't - unless you have a profit (and loss?) sharing contract.

The point I was making when I wrote "[t]ry to imagine [you] ... have to pay for V6 out of your own pocket ... would you buy it?" is that we often push things that we want to do without the justification that a business wants. By 'imagining' that it's your own money is a way of looking at the proposal in the way that they will see it. If it doesn't make economic sense to you, why should it to them? [...] 18051 56 36_Re: Deleting where current of cursor12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 27 Mar 2000 13:15:48 +1200334_us-ascii Now, don't I feel like a schmuck? Anyone out there - apart from me, evidently - familiar with the old adage, 'RTFM'? Thanks, Dr. E. Your eyes are obviously much better than mine. I saw the reference but completely glossed over it in my mind. Oops. And, MfG is fine. I had to think about WbR. Best regards also, Michael. [...] 18108 38 33_V6 justification, BMW/Rover, etc.12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 27 Mar 2000 12:58:04 +1200489_us-ascii Colleagues,

1) IMHO (gee, aren't these abbreviations great?) BMW should have merged with VW (as Herr. Piech (sp.) offered). VW builds 25s and 45s on - very good - VW platforms, BMW gets part-ownership of Seat, Skoda and VW (I think) and VW gets part-ownership of BMW. VW also gets Land Rover, which probably was a bit too much for the Quandts to swallow. At least Ford actually hands over readies for it. Kinda useful when offsetting losses of DM3b a year from Rover. [...] 18147 66 38_Changing HLQ and issue with HPGVCATN ?23_McLaren, Phil [IBM GSA]29_Phil.McLaren@TEAM.TELSTRA.COM31_Mon, 27 Mar 2000 14:13:53 +1000357_- Dear all,

A scenario I cannot seem to find a definitive answer to.... fairly basic DB2 operational stuff, having recently moved several DB2 managed tablespaces over to new VCATs by :

1. STOP 2. ALTER USING STOGROUP

3. IDCAMS ALTER (linear dsn) NEWNAME OR 3. DFDSS COPY (linear dsn) DELETE [...] 18214 126 49_Re: Fw: Omegamon Historical Stats - Summarisation9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Mon, 27 Mar 2000 07:20:48 +0000596_us-ascii Yes, Ive also tried changing the indexes to non-unique. As you say, the problem is that you then get multiple entries per hour. Annoying thing is that if a DB2 statistics record (Im only interested in statistics data....at the moment) is not cut within an H2 log period then it still inserts a row with field values equal to zero. Therefore, for statistics data Im probably going to load non-summarised data into the DB2 tables and then summarise this at the hourly level ASAP. Thanks for confirming you had similar problems. Kind Regards, Andy Hunt - Scottish And Southern Energy. [...] 18341 65 11_UNSUBSCRIBE26_Uppuluri, Sreenivasa (CTS)25_USreeniv@CHN.CTS-CORP.COM31_Mon, 27 Mar 2000 04:44:12 -0500580_iso-8859-1 UNSUBSCRIBE

Please remove me from the list.

-----Original Message----- From: A. Bohacz [mailto:abohacz@OZEMAIL.COM.AU] Sent: Wednesday, March 15, 2000 6:09 PM To: DB2-L@RYCI.COM Subject: Re: Migrating QMF user objects using DSNTIAUL



Have used both approaches to migrate QMF objects between QMF's i.e. export/import and unload/load. Unload & Load worked okay for us when:

(a) not altering any QMF objects between the unload and load phases (b) source and target QMF's are the same version and make use of the same exit routines. [...] 18407 180 17_UNSUBSCRIBE DB2-L26_Uppuluri, Sreenivasa (CTS)25_USreeniv@CHN.CTS-CORP.COM31_Mon, 27 Mar 2000 15:15:05 +0530538_iso-8859-1



-----Original Message----- From: A. Bohacz [mailto:abohacz@OZEMAIL.COM.AU] Sent: Wednesday, March 15, 2000 6:09 PM To: DB2-L@RYCI.COM Subject: Re: Migrating QMF user objects using DSNTIAUL



Have used both approaches to migrate QMF objects between QMF's i.e. export/import and unload/load. Unload & Load worked okay for us when:

(a) not altering any QMF objects between the unload and load phases (b) source and target QMF's are the same version and make use of the same exit routines. [...] 18588 180 17_UNSUBSCRIBE DB2 L26_Uppuluri, Sreenivasa (CTS)25_USreeniv@CHN.CTS-CORP.COM31_Mon, 27 Mar 2000 15:15:23 +0530538_iso-8859-1



-----Original Message----- From: A. Bohacz [mailto:abohacz@OZEMAIL.COM.AU] Sent: Wednesday, March 15, 2000 6:09 PM To: DB2-L@RYCI.COM Subject: Re: Migrating QMF user objects using DSNTIAUL



Have used both approaches to migrate QMF objects between QMF's i.e. export/import and unload/load. Unload & Load worked okay for us when:

(a) not altering any QMF objects between the unload and load phases (b) source and target QMF's are the same version and make use of the same exit routines. [...] 18769 20 47_Re: What can speed up a MAX(column) selection ?17_suthep thampranee18_suthepth@SCB.CO.TH31_Mon, 27 Mar 2000 17:10:57 +0700432_ISO-8859-1 Hi all In my site, I built the table for keep data from max(col) when program is running. And then the programmers are very happy. Suthep Thampreanee DBA SCB Bank Bangkok,Thailand

================================================ 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. 18790 123 10_Re: DB2 V60_18_mebert@AMADEUS.NET31_Mon, 27 Mar 2000 13:56:38 +0100592_us-ascii I would go with Bob Jeandrons suggestion "tell them that sometime V5 won't be supported anymore" (after all, V7 is announced for this year I think). With every commercial SW, you have the problem of new versions and updates, and it's either "stay current" or sooner or later "forget about support, fixes etc." (this is a management decision that they should have taken when they chose DB2). As for the new features, the only thing where I have felt "I missed THAT" is the INDEXBP clause of the CREATE DATABASE. Many of the others I would consider worthless (Governor), doubtful [...] 18914 43 24_ACTIVE LOG I/O OPERATION12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Mon, 27 Mar 2000 06:05:37 PST594_- Hi Fellas:



I have one doudt about how does db2 write over the active logs and more specific when you specified use two active logs in your db2. In our shop we use dual active logs but my concern came up when I was checking the DB2MSTR using the monitor for mvs in the JOB STEP I/O ANALYSIS section and I saw that all those datasets has diferent Amount of I/O (IO CNT FIELD)as you can see bellow : DATA SET NAME VOLUME IO CNT RFM SYS4DB2L.LOGCOPY1.DS01 DBS000 1104 AM SYS4DB2L.LOGCOPY1.DS02 DBS000 1 AM SYS4DB2L.LOGCOPY1.DS03 DBS000 124004 AM SYS4DB2L.LOGCOPY1.DS04 DBS001 [...] 18958 35 34_Cannot start db2jstrt at boot time15_Massimo Vignone16_vignone@UNIMO.IT31_Mon, 27 Mar 2000 16:05:58 +0200300_us-ascii Hi,

I'm trying to start the applet server on boot time adding the following line to /etc/rc.db2 on my Sun Solaris 7 based workstation

su - db2inst1 -c "db2jstrt"

but the the db2jd daemon doesn't start.

Anyone can help me please?

TIA,

Massimo

18994 16 49_Re: Reverse engineering an E-R model from DB2 V6.0_22_wjmartin@HOUSEHOLD.COM31_Mon, 27 Mar 2000 09:38:39 -0500394_us-ascii Hi Brendan - Assuming you have Platinum Migrator, you can create a migration strategy, transfer the file to your PC, and then reverse engineer it into something like ERWin. If you're unsure about how to use Migrator, the Platinum help desk has always given us great support to help us figure things out, call their 800 number. If you need to contact me offline, please feel free. [...] 19011 81 28_Re: ACTIVE LOG I/O OPERATION12_Sue Janowitz18_SJanowitz@NEFN.COM31_Mon, 27 Mar 2000 10:06:32 -0500478_us-ascii Just to clarify things - the LOGCOPY1 and LOGCOPY2 being used at one time don't have to be for the same DS0x. It depends on the order you add them to the BSDS. It looks like your LOGCOPY1.DS01 and LOGCOPY2.DS02 were active together, because they have the same count, as do LOGCOPY1.DS02 and LOGCOPY2.DS03. Even though that's a little confusing when you look at it (and I've gone to great lengths at times to prevent it here), that's fine as far as DB2 processing. [...] 19093 21 10_Re: DB2 V613_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Mon, 27 Mar 2000 08:15:34 -0700337_- I would suggest that IBM is putting more resources into non-mainframe development. I would suggest that there is less development being done on the mainframe. I would suggest that companies are very focused on web apps. I would suggest that intra and extra nets will be the future. Network centric computing - not legacy systems. [...] 19115 85 28_Re: ACTIVE LOG I/O OPERATION9_Birk, Tim17_BirkT@DIEBOLD.COM31_Mon, 27 Mar 2000 10:28:03 -0500374_iso-8859-1 I would expect write activity to be equal, but there's no reason for rollbacks and recoveries to read from both copies. So I think read activity would account for the discrepancies.

-----Original Message----- From: Sue Janowitz [mailto:SJanowitz@NEFN.COM] Sent: Monday, March 27, 2000 10:07 AM To: DB2-L@RYCI.COM Subject: Re: ACTIVE LOG I/O OPERATION [...] 19201 20 47_Re: What can speed up a MAX(column) selection ?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Mon, 27 Mar 2000 14:53:44 GMT553_us-ascii Thanks to Michael and Venkat for very nice explainations.Now the doubts are clarified and i can recall something about truncated value and insert logic which u mentioned about type 2 index.

Thanks again and i hope i will continue to get more knowledge in this list.

Regards

Sanjeev

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19222 130 28_Re: ACTIVE LOG I/O OPERATION9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Mon, 27 Mar 2000 15:33:09 +0000477_us-ascii I agree that the difference is due to read activity. This may also include 3rd party tools reads (e.g. BMC Logmaster, CA Log Analyser). Also DB2 archiving. Kind Regards, Andy Hunt - Scottish And Southern Energy.







"Birk, Tim" on 27/03/2000 15:28:03

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Re: ACTIVE LOG I/O OPERATION [...] 19353 50 10_SV: DB2 V60_19_Sven.Heidorn@CSN.SE31_Mon, 27 Mar 2000 17:41:56 +0200377_ISO-8859-1 I just couldn't resist adding my opinion to this one

Sven Heidorn

> -----Ursprungligt meddelande----- > Från: Dan.S.Brogdon@AEXP.COM [SMTP:Dan.S.Brogdon@AEXP.COM] > Skickat: den 27 mars 2000 17:21 > Till: DB2-L@RYCI.COM > Ämne: Re: DB2 V6 > > I would suggest that IBM is putting more resources into non-mainframe > development. I would doubt that [...] 19404 44 29_Max rows vs row level locking11_James Drewe20_James.Drewe@AEXP.COM31_Mon, 27 Mar 2000 08:47:41 -0700636_- Mike

You should definately reconsider row locks in a data sharing/sysplex environment. When locking occurs across the coupling facility, the row lock is treated as a page P-lock, thus negating the improved concurrency you originally desired.

Jim Drewe DBA

> -----Original Message----- > From: Mike_Levine@TEKHELP.NET [SMTP:Mike_Levine@TEKHELP.NET] > Sent: Friday, March 24, 2000 3:30 PM > To: DB2-L@RYCI.COM > Subject: Max rows vs row level locking > > Hi, > > This may be a simple question but which is more efficient: > using MAX ROWS 1 with page level locking or row level locking > with many rows on the [...] 19449 62 10_Re: DB2 V60_22_Rohn.Solecki@MTS.MB.CA31_Mon, 27 Mar 2000 09:49:28 -0600539_us-ascii You are welcome to your opinions, since they are based on perspective. How about this point of view. As a relatively new DBA I've been looking for DBA training aimed at DB2 V5 OS 390 for the last year and a half! Since I live and work in the 'boonies' (relatively speaking) I have the following options: - Read a book (Good book Craig M!) - do an internet course (except that my corporate standard PC won't handle the graphics!) - travel 1000 miles to a course or conference, but the company is too cheap to pay for air fare [...] 19512 93 35_Re: Transaction Recovery - Really??15_Murley, Michael22_Michael_Murley@BMC.COM31_Mon, 27 Mar 2000 10:01:28 -0600384_iso-8859-1 Mark,

I realize that your were asking for user experiences and not more information from us (BMC), but I wanted to make a coule of clarifications.

High-Speed Transaction Recovery is a solution that integrates the following products:

- RECOVERY MANAGER for DB2* - RESOLVE LOGMASTER for DB2* - RECOVER PLUS for DB2* - Apply Plus for DB2* for OS/390 [...] 19606 41 32_Re: Good admin books for DB2 udb22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 27 Mar 2000 17:24:50 +0000655_ISO-8859-1 Cert Guide?

Leslie



______________________________ Reply Separator _________________________________ Subject: Good admin books for DB2 udb Author: Srirengan Venkatesh Kumar at Internet Date: 3/24/00 6:09 AM



Hi,

Can somebody suggest good db admin for DB2 UDB v6. I am expecting the book to have the basic concepts, the admin of the db server (like starting a installation/ starting an instance/ defining objects etc) and addressing some performance topics. Also appreciate if anybody can refer some redbooks which details on db admin on AIX and Hp ux. [...] 19648 23 16_Solaris and DB/212_Kevin Arnold31_kevin.n.arnold@US.PWCGLOBAL.COM31_Mon, 27 Mar 2000 09:44:59 -0500635_us-ascii Is anyone using DB/2 on Solaris? Could you EMAIL me offlist? I have some specific questions.

Thanks! Kevin ---------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. [...] 19672 92 10_Re: DB2 V617_Hynes, Kenneth J.17_khynes@TRIGON.COM31_Mon, 27 Mar 2000 11:55:33 -0500481_iso-8859-1 Dan S Brogdon on 2000/03/27 09:15:34 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Rohn Solecki/MTSCommunications/MTS) Subject: Re: DB2 V6

I would suggest that IBM is putting more resources into non-mainframe development. (As Compared to what?) While this may be true they are still putting a substantial amount of effort -- money and people into mainframe solutions. [...] 19765 103 10_FW: DB2 V617_Hynes, Kenneth J.17_khynes@TRIGON.COM31_Mon, 27 Mar 2000 11:57:28 -0500479_iso-8859-1 -----Original Message----- From: Hynes, Kenneth J. Sent: Monday, March 27, 2000 11:56 AM To: 'DB2 Data Base Discussion List' Subject: RE: DB2 V6

Dan S Brogdon > on 2000/03/27 09:15:34 AM

Please respond to DB2 Data Base Discussion List >

To: DB2-L@RYCI.COM cc: (bcc: Rohn Solecki/MTSCommunications/MTS) Subject: Re: DB2 V6 [...] 19869 55 10_Re: DB2 V614_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Mon, 27 Mar 2000 11:06:40 -0500731_iso-8859-1 Dan, (all in fun)

That may be where you are, but here on Planet Earth it is somewhat quite different.

Regards, Richard +===+===+===+===+====+ Richard_Yevich@attglobal.net "DB2 High Performance Design and Tuning", Prentice Hall, May 2000 "DB2 Answers", Osborne, 1999 "DB2 Performance Journal", Quarterly www.YLAssoc.com www.RYCi.com www.DB2-Performance-Journal.com



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Dan S Brogdon > Sent: Monday, March 27, 2000 10:16 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 V6 > > > I would suggest that IBM is putting more resources into non-mainframe > development. > I would suggest that there [...] 19925 36 0_12_Carlton Yuen18_tcyuen@AKAMAIL.COM31_Tue, 28 Mar 2000 01:02:52 +080022_iso-8859-1 unsubscribe 19962 59 39_getting contents of a row using its RID17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Mon, 27 Mar 2000 18:59:32 +0100310_US-ASCII Hi all

I would like to know if its possible to get the row, if I know its RID. If so how?. I want to know what is in the row, pointed to by the RID in the following message

DSNT408I SQLCODE = -532, ERROR: THE RELATIONSHIP SSHD01 RESTRICTS THE DELETION OF ROW WITH RID X'0000000301' [...] 20022 78 43_Re: getting contents of a row using its RID14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Mon, 27 Mar 2000 10:03:41 -0800452_iso-8859-1 About the best you could do would be to use DSN1PRNT to print out the contents of the page that the RID references. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

-----Original Message----- From: Nagaraj Pudukotai [mailto:Nagaraj.Pudukotai@WDR.COM] Sent: Monday, March 27, 2000 12:00 PM To: DB2-L@RYCI.COM Subject: [DB2-L] getting contents of a row using its RID [...] 20101 38 22_Access SQL performance12_Jason Hughes20_Jason.Hughes@TRW.COM31_Mon, 27 Mar 2000 10:16:27 -0800514_US-ASCII Hello everyone. I'm seeking advice on running MS Access 97 written queries against DB2 5.1 on a OS/390 machine. We are using DB2 Connect 5.1 FixPak 11.

I have a couple of reports that run slow, so I turned on the ODBC trace of DB2 Connect to see how the SQL statements were being translated/processed. What I discovered alarmed me. The report's query has a sub-query in the FROM clause. The trace showed me that this sub-query was being executed and the results were being returned to Access. [...] 20140 86 43_Re: getting contents of a row using its RID19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 27 Mar 2000 12:18:06 -0600630_iso-8859-1 Nagaraj, If you have Platinum's Database Analyzer, it has a page display capability. 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 [...] 20227 71 20_Conditional REORG???16_Pantazis Pantazi20_zakis@CYTANET.COM.CY31_Mon, 27 Mar 2000 21:17:40 +0300530_us-ascii

We are using DB2 V4 for OS390, but the problem relies that we want to be able to reorganise the tablespaces according to the ClusterRatio of each tablespace.

We are Reorganising all tablespaces weekly, but recently we have faced a storage problem which does not enable us to run REORG on all tablespaces, and for this reason exactly we want to be able to run REORG with SORTDATA on only a specific number of tablespaces, and that will be defined dynamically through a select on the DB2 system tables. [...] 20299 57 29_Time consuming load processes18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM31_Mon, 27 Mar 2000 13:56:57 -0500596_us-ascii All,

I do appreciate the help from everybody in the last mail I sent out. This was regarding the weekend process where many tables are being unloaded from production and I am loading them in test environments.

I tried out various methods to try and save time. The present process being used is: 1) Unload from production 2) Transfer file from production to test 3) Load all the small tables using the normal process. For the tables with large amounts of data the LOAD UTILITY is terminted after the RELOAD phase and then subsequently I REBUILD the INDEXES in parallel [...] 20357 50 10_Re: DB2 V620_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 27 Mar 2000 13:59:48 -0500452_us-ascii The last I heard was Hitachi wanted to reduce its budget on the mainframes and increase on the Unix. The main reason for that was IBM will not sell them CMOS high-end chips any more.

I am not sure if this can be taken as good news or bad news. It may mean that IBM will have near monopoly on main-frames and may still go for more and more high-end chips. There are divided opinion on this issue and only future can tell the truth. [...] 20408 30 26_Re: Access SQL performance12_Jim Harrison12_jimh@QIS.NET31_Mon, 27 Mar 2000 14:10:39 -0500578_us-ascii Don't know of a DB2 Connect setting but how about using a stored procedure? That's one of the main uses for them - reducing network traffic and doing as much work as possible on the server.

At 10:16 AM 3/27/00 -0800, Jason Hughes wrote:

>Due to the possible data volume of the sub-query and slow network traffic, >I would prefer the sub-query's result set not be transmitted back to the >user's PC. Is there a setting in DB2 Connect or the mainframe DB2 that >will cause the entire query to be within the mainframe? > >I created the Access sub-query [...] 20439 17 26_AW: Access SQL performance16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Mon, 27 Mar 2000 21:20:02 +0200357_- Hi,

Did you turn on dynamic SQL-Caching in your DSNZPAR? Also TCPIP is faster then SNA LU6.2

Roland

================================================ 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. 20457 32 78_Re: How can you tell DB2 to stop after the first match in a selec t Count(*)??13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 27 Mar 2000 14:35:16 -0500424_iso-8859-1 Hi Christine, How about SELECT min(some indexable high-order column*) from ... where ... ----------------- Don't forget when using min you need to deal with a null result.

and why don't you want to use Exist strategy?

((I am one of the subscribers to the theory that it's misleading to encourage programmers to treat -811 sqlcode positively--but that thread's been argued plenty here already)) [...] 20490 72 24_Re: Conditional REORG???19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 27 Mar 2000 13:32:44 -0600598_iso-8859-1 There are at least two vendor's that have products to do what you ask; Platinum (CA) and BMC. Each can react to RUNSTATS info they find, produce the required jobs, and even submit them for processing. While CLUSTERRATIO is important (make sure you are checking for the clustering index only) there are several other things to check for that effect performance. See Admin. Gde. for DB2 V4, bookmanager ref G.9.1, DB2 Cat/Dir reorg. Several tables in these DBs can be reorg'd. See ref G.9.3, Tablespace reorg for how to determine TSs that could benefit from a reorg. And G.9.4, Index [...] 20563 25 31_Access 97 to DB2/MVS Conversion12_Savoie, Alan22_Alan.Savoie@BCBSLA.COM31_Mon, 27 Mar 2000 13:54:07 -0600501_iso-8859-1 I have some Access 97 apps that have outgrown their usefulness in Access and wish to migrate the data to DB2/MVS. I am searching for a reference document so that I can avoid the trial and error method. Or, if it exists, a migration utility that might really speed the conversion. I have done some web searching and have not found information specifically related to Access 97 to DB2/MVS conversions. Does anyone know of a documented step-by-step effective approach to this conversion? [...] 20589 16 10_Re: DB2 V613_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Mon, 27 Mar 2000 13:23:33 -0700366_- Thanks VP,,, I appreciate your thoughts and those are what I seek, rather than egotistical smack - from some other planet.

================================================ 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. 20606 34 35_Re: Access 97 to DB2/MVS Conversion12_Jason Hughes20_jason.hughes@TRW.COM31_Mon, 27 Mar 2000 14:32:29 -0600665_- Alan, Following is the email text from IBM of an Access to DB2 conversion utility. I have not used it so I cannot rate it for you. Just passing along the information in my archives. Jason Hughes TRW S&ITG

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Scriptoria is a utility developed by Bunker Hill Corp ( http://www.bunkerhill.com/ ), a services provider specializing in migration services from Microsoft Access to enterprise RDBMS products. Bunker Hill's new tool, Scriptoria Standard Edition for DB2, will migrate your Access database (JET engine format) to DB2 UDB. You can then use your Access front-end, Visual Basic application, or any ODBC application [...] 20641 27 35_Re: Access 97 to DB2/MVS Conversion12_Jim Harrison12_jimh@QIS.NET31_Mon, 27 Mar 2000 16:08:21 -0500582_us-ascii I tried it last summer and IIRC I believe it is for non-MVS UDB. I am DLing it again to be sure.

At 02:32 PM 3/27/00 -0600, Jason Hughes wrote: >Alan, >Following is the email text from IBM of an Access to DB2 conversion utility. >I have not used it so I cannot rate it for you. Just passing along the >information in my archives. >Jason Hughes >TRW S&ITG > > >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >Scriptoria is a utility developed by Bunker Hill Corp ( >http://www.bunkerhill.com/ ), >a services provider specializing in migration services from Microsoft Access [...] 20669 28 37_SORTDATA, SORTKEYS and REUSE on Reorg15_Knabach, Mark L20_mark.knabach@EDS.COM31_Mon, 27 Mar 2000 17:35:51 -0500461_iso-8859-1 Hi All,

I am attempting to get better performance from the IBM Reorg Utility (DSNUPROC which executes DSNUTILB). I'm running on OS/390 with DB2 V5 and have specified SORTDATA and SORTKEYS on the REORG control card. I'm finding the job actually runs longer with these parameters verses running with NO LOG UNLOAD CONTINUE specified. I was expecting the opposite. Should I be using additional parameters or more / larger SORTWORK datasets? [...] 20698 41 10_Re: DB2 V614_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Mon, 27 Mar 2000 16:58:10 -0500644_iso-8859-1 Dan,

I guess you just missed the "all in fun" first line!

Regards, Richard

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Dan S Brogdon > Sent: Monday, March 27, 2000 3:24 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 V6 > > > Thanks VP,,, > I appreciate your thoughts and those are what I seek, rather > than egotistical > smack - from > some other planet. > > ================================================ > 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 [...] 20740 49 10_Re: DB2 V60_22_Rohn.Solecki@MTS.MB.CA31_Mon, 27 Mar 2000 17:04:14 -0600398_us-ascii Back to the original statements, and my response. Here is a post to the list from back in January that in effect says that IBM does concentrate (at least in this one area) more on the platforms other than OS390.









Roger Miller on 2000/01/07 01:55:29 PM

Please respond to DB2 Data Base Discussion List [...] 20790 85 39_getting contents of a row using its RID14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 28 Mar 2000 09:54:32 +1000521_us-ascii Nagaraj,

Use DSN1PRNT Utility together with DB2 Diagnosis Manual. Note that there are a list of row pointers at the end of the page, so the RID is just a row number within the page. If you have data compression, making the row very hard to decifer, you may be better of finding the index leaf entry that points to the page so you can see the index key more easily. Looking at the DB2 Log can also be useful when you know exactly what time the event took place as long as an update actually occurred. [...] 20876 77 10_Re: DB2 V622_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 27 Mar 2000 19:21:43 -0500328_- If I remember this thread correctly, then someone commented that as far as a DB2 certification is is concerned; a DB2 certification in the non-OS/390 world is more important than a DB2 certification in the OS/390 world because in general certifications carry more weight in the non-OS/390 world than in the OS/390 world. [...] 20954 94 33_Re: Time consuming load processes11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Tue, 28 Mar 2000 08:36:22 +0800634_us-ascii Have you considered using DSN1COPY utility instead of unload and load?







Kartik Subramanian on 28/03/2000 02:56:57 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: ROLAND CHUA CHONG KEE/DATACEN/IT/SGX) Subject: Time consuming load processes







All,

I do appreciate the help from everybody in the last mail I sent out. This was regarding the weekend process where many tables are being unloaded from production and I am loading them in test environments. [...] 21049 25 21_regarding performance17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Mon, 27 Mar 2000 17:31:25 PST268_- Hi Folks,

i have question on NOT IN and NOT EXISTS in SQL query. which will give better performance between these two. right now i am using NOT EXISTS in the sql query. but i have a doubt if i used NOT IN class in the sql can i get a better performance. [...] 21075 120 42_Re: Changing HLQ and issue with HPGVCATN ?23_McLaren, Phil [IBM GSA]29_Phil.McLaren@TEAM.TELSTRA.COM31_Tue, 28 Mar 2000 11:35:54 +1000540_- > Hi Quang, > > Thanks for the response, I appreciate the ALTER statement cannot update > these values and that reorg/recover will, but I still have the > question.... > > Why, if a dataset is stogroup defined, does DB2 want to store the stogroup > in the header page and does it matter if it is the wrong value? > > > Phil McLaren > Enterprise Services - Application & Production Support. > IBM Global Services Australia > Location: BG10 > Level 10, 40 Creek St, Brisbane, Qld 4000 > ' Ph: +61-7-3887-8152 7 Fax +61-7-3211-9196 > * [...] 21196 76 10_Re: DB2 V611_Jon Nolting18_nolting@AMDAHL.COM31_Mon, 27 Mar 2000 17:42:27 -0800474_us-ascii IBM may like to think they now have a 'near monopoly on mainframes', but Amdahl begs to differ. Unlike Hitachi, Amdahl is now releasing its 4th generation of CMOS processors developed in partnership with Fujitsu. The Millennium family continues the 25 year commitment that Amdahl has toward the S/390 marketplace. Our current 2000C/E processors have broken 2000 MIPs with the 16-way 2000E. Millennium is parallel sysplex capable and supports DB2 data sharing. [...] 21273 22 23_HAVE TO CONVERT INDEX ?17_suthep thampranee18_suthepth@SCB.CO.TH31_Tue, 28 Mar 2000 10:16:58 +0700464_Windows-874 Hi all, IBM officer in Thailand told me that I have to convert all indexes from type 1 to type 2 before migration DB2 version 5 to version 6.Is it true?

Regards Joe Suthep Thampranee DBA SCB Bank,Bangkok

================================================ 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. 21296 16 27_Re: HAVE TO CONVERT INDEX ?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 27 Mar 2000 22:17:44 -0500352_iso-8859-1 Yes.

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 21313 37 27_Re: HAVE TO CONVERT INDEX ?17_suthep thampranee18_suthepth@SCB.CO.TH31_Tue, 28 Mar 2000 10:33:17 +0700626_ISO-8859-1 David, Thank you. (Oh god,it must takes long times to convert.)

TIA Suthep Thampranee DBA SCB Bank

---------- > From: Seibert, Dave > To: DB2-L@RYCI.COM > Subject: Re: HAVE TO CONVERT INDEX ? > Date: 28 ÁÕ¹Ò¤Á 2543 10:17 > > Yes. > > David Seibert > Compuware Corporation File-AID product planner > Dave.Seibert@Compuware.com > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...] 21351 24 27_Re: HAVE TO CONVERT INDEX ?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 27 Mar 2000 22:38:43 -0500396_iso-8859-1 Hi Suthep,

Do you have any tools to ease the pain?

There are several. Our product DBA-XPERT for DB2 will automate this process. I'm sure our friends at BMC, CA, CDB and others probably have products also. They're just probably not as waycool as we are.

Good luck.

David Seibert Compuware Corporation File-AID product planner Dave.Seibert@Compuware.com [...] 21376 65 25_Re: regarding performance10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Tue, 28 Mar 2000 03:53:53 GMT545_us-ascii Ravi, It depends ,but in very few cases u can get good performance from NOT IN .One of those would be very small inner table.One time tablespace scan in NOT IN is better than multiple time tablespace scan in NOT EXISTS, mainly if pages are staying for very less time in the BP(I/O again).But if BP part is ok ,it may not show u the substantial difference.My suggestion would be to let those be NOT EXISTS. NOT IN forms the result set and work on those by putting it in the workfile and NOT EXISTS work on the true/false logic(take [...] 21442 83 24_Re: Conditional REORG???10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Tue, 28 Mar 2000 03:59:57 GMT539_iso-8859-1 Hi , I have written a small C program (as DB2 -REXX interface is not available in our installation) which gives u the report for all the tablespaces and indexes which are eligible to reorg.This is nothing but contains a set of SQLs and prints the report.I also do have an ISPF panels which displays all these and reorg with options can be fired from there which in turns thru rexx submits the JCL. U can write ur own in REXX or C and integrate it with ur current utility.It is mainly the collection of SQLs which is in the [...] 21526 50 27_Re: HAVE TO CONVERT INDEX ?17_suthep thampranee18_suthepth@SCB.CO.TH31_Tue, 28 Mar 2000 13:55:20 +0700585_ISO-8859-1 Hi Davis, Thank you for your idea.But my site have no more budgets to support it.I have to work with index type I more than 2000 indexes.

Thank in advance JOE

Suthep Thampranee DBA SCB Bank,Bangkok

---------- > From: Seibert, Dave > To: DB2-L@RYCI.COM > Subject: Re: HAVE TO CONVERT INDEX ? > Date: 28 ÁÕ¹Ò¤Á 2543 10:38 > > Hi Suthep, > > Do you have any tools to ease the pain? > > There are several. Our product DBA-XPERT for DB2 will automate this process. > I'm sure our friends at BMC, CA, CDB and others probably [...] 21577 39 24_Re: Conditional REORG???14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 28 Mar 2000 09:00:24 +0200365_us-ascii Yes, you can and it's the method we use in our shop (and we save money instead to to make a

present of our $$$ to some of 5 software sisters...).

PDA is too expensive for our installation so we developed a group of stupid REXX to extract the

tablespace/index names to reorg, to generate reorg JCLs and CONTROL-M chains (to submit [...] 21617 33 24_Re: Conditional REORG???14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 28 Mar 2000 09:17:09 +0200405_us-ascii Hi Sanjeev.

May I suggest to try to use IBM DB2WWWX to execute SQL in a REXX ? You need

S/390 (for some UNIX command to extract files), DB2 3.1 or later version (+ you hava to execute

some binds) . The URL is:

http://www.s390.ibm.com/nc/sntc/DB2IMSRX.html

We use it extensively since 1998 and it's nice & FREE !! And i'ts more simple that a C program..... [...] 21651 92 27_Re: HAVE TO CONVERT INDEX ?12_Nurmi, Seppo23_Seppo.Nurmi@RIKSBANK.SE31_Tue, 28 Mar 2000 09:19:30 +0200556_iso-8859-1 Hi Joe, there was a discussion of this subject quite recently on this list, you may find the mails in the archives. Nevertheless, I can recover. I have done the converting, about as many indexes as you have. I used no tools, only SQL to generate ALTER INDEX, and RECOVER INDEX statements. Run alters in batches of a few hundred to not to fill up all your logs at once. Properly prepared it is an easy job for a couple of days at most. REBIND afterwards is recommended. Don't forget to convert the DB2 catalog and directory indexes! That is [...] 21744 105 27_Re: HAVE TO CONVERT INDEX ?17_suthep thampranee18_suthepth@SCB.CO.TH31_Tue, 28 Mar 2000 16:53:02 +0700576_ISO-8859-1 Hi seppo, I will use the way like yours.But my problem is 40% of indexes are migrated and I have to recall data set.

TIA Joe Suthep Thampranee DBA SCB Bank,Bangkok



---------- > From: Nurmi, Seppo > To: DB2-L@RYCI.COM > Subject: Re: HAVE TO CONVERT INDEX ? > Date: 28 ÁÕ¹Ò¤Á 2543 14:19 > > Hi Joe, > there was a discussion of this subject quite recently on this list, you may > find the mails in the archives. > Nevertheless, I can recover. I have done the converting, about as many > indexes as you have. I used [...] 21850 157 27_Re: HAVE TO CONVERT INDEX ?12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Tue, 28 Mar 2000 11:43:00 +0100447_iso-8859-1 I assume this is your development environment and you let DB2 datasets migrate (I would advise against it in Production).

You can issue an HRECALL command using masking in the dataset name the same as in ISPF option 3.4. I would run this under batch TSO to prevent your TSO session being swamped with HSM messages, alternatively, generate a full list using SPF option 3.4, and edit it to provide a list of HRECALL commands. [...] 22008 17 33_Vedr: Re: HAVE TO CONVERT INDEX ?14_Jens P. Hansen24_jens.peter.hansen@PBS.DK31_Tue, 28 Mar 2000 13:23:20 +0100441_us-ascii If you use STOGROUP defined indexes, don't RECALL the migrated index-datasets, just HDELETE them and then REBILD INDEX.

Jens Hansen

*** all disclaimers u can think of apply ***

================================================ 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. 22026 126 41_Re: SORTDATA, SORTKEYS and REUSE on Reorg0_18_mebert@AMADEUS.NET31_Tue, 28 Mar 2000 13:21:29 +0100601_us-ascii Are you talking about CPU time or elapsed time? Comparing the latter is always a tricky business, as it heavily depends on other activity on the system. My feeling is that the combination of parameters should almost always result in less CPU time, and in less elapsed time unless the data is still in good clustering shape (the Utilities Guide mentions 95% Clusterratio), but I have not done measurements. According to the Utilities Guide, using one or two large SORTWKnn/DATAWKnn datasets (the first are for sorting index keys, the second for sorting Data rows - I think the Util Guide [...] 22153 65 14_DB2 UDB on AIX11_Emrah GUVEN28_emrah.guven@PAMUKBANK.COM.TR31_Tue, 28 Mar 2000 14:33:47 +0300393_ISO-8859-9 I beg your pardon and want to ask a question ; Is it possible to "copy the data of a table to one similar other table - with the same structure - , without using export/import utility ( in order to save space & time ) " , i know that it is possible to use "select into ... where ..." clause with DB2 Mainframe but what about with UDB on AIX , is there a similar way of doing ? [...] 22219 34 23_Has anyone found REXX ?24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM31_Tue, 28 Mar 2000 22:24:13 +1000348_iso-8859-1 Hello DB2 people,

Using DB2 UDB V5 for NT Personal Edition a copy of REXX was installed which provided a nice usable programming interface into DB2 on NT. Now that I have installed DB2 UDB V6 for NT Personal Edition, I seem to have lost REXX.

Does anyone know if REXX support has been withdrawn from DB2 UDB V6 on NT? [...] 22254 24 33_Catalog/Directory reorg Questions11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Tue, 28 Mar 2000 08:41:06 -0500467_iso-8859-1 1. What should be monitored or benchmarked that would show some measurement of the performance improvements gained by doing the catalog/directory reorg?

2. We know that IBM recommends that certain related directory tables be reorged if certain catalog tables are reorged. Is the reverse recommended as well? In other words, if we reorg the directory tables because of extents for instance, should we then also reorg the related catalog tables? [...] 22279 60 41_Re: SORTDATA, SORTKEYS and REUSE on Reorg19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 28 Mar 2000 07:48:47 -0600575_iso-8859-1 Hi Mark, If you would please, provide more info. How many rows in table? Is it partitioned? Is there an explicit CLUSTERING index? If so, what is CLUSTERRATIO? What is FAROFFPOS/CARD? Greater than 5 or 10%? How many indexes? Normally using SORTDATA, SORTKEYS, and NOSYSREC (provided you have recover capability) would lead to better performance. After reading several IBM references and DB2-L, the consensus of opinion on SORTWKnn/DATAWKnn datasets is to use just enough datasets to contain the data/index(es). One is preferred provided it can be big enough. [...] 22340 49 24_Re: Conditional REORG???16_Pantazis Pantazi20_zakis@CYTANET.COM.CY31_Tue, 28 Mar 2000 16:44:48 +0300570_us-ascii Yes please, I would be most grateful if you could supply me with some REXX Exec samples. You see I am not very familiar with REXX.

Thanks in advance.

Sent samples to my email if possible.





Massimo Scarpa wrote:

> Hi Sanjeev. > > May I suggest to try to use IBM DB2WWWX to execute SQL in a REXX ? You need > > S/390 (for some UNIX command to extract files), DB2 3.1 or later version (+ you > hava to execute > > some binds) . The URL is: > > http://www.s390.ibm.com/nc/sntc/DB2IMSRX.html > > We use it extensively [...] 22390 248 10_Re: DB2 V611_Eric Robida22_Eric_Robida@BCBSME.COM31_Tue, 28 Mar 2000 08:35:51 -0500526_us-ascii My experience was the opposite. We had a process that was taking over 30 min of CPU daily to create a file. It was DB2 and outside of adding indexes there was little else that could tune the process as it was. I was very familiar with it as I wrote it. Management allowed me to attend IDUG last spring and there I found the answer. I wrote a proposal on the changes that needed to be made and my estimate of the time involved. I also included a conservative estimate of how much CPU we could save and translated [...] 22639 52 37_Re: Catalog/Directory reorg Questions19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 28 Mar 2000 08:24:47 -0600615_iso-8859-1 Hi Lee, DB2 for OS/390 V5. The RUNSTATS on the DB2 CATALOG tablespaces (can't do SYSLGRNX) would normally indicate when a reorg is needed. You cannot do RUNSTATS on the DIRECTORY tablespaces. After a reorg/RUNSTATS, you should see an improvement in the stats. There are only three DIRECTORY tablespaces you can reorg and should be reorged whenever their related CATALOG tablespaces indicate a reorg is needed: DSNDB06.SYSDBASE ==> DSNDB01.DBD01 DSNDB06.SYSPLAN ==> DSNDB01.SCT02 DSNDB06.SYSPKAGE ==> DSNDB01.SPT01 These tablespaces are related by LINKS (see Diagnosis Guide for more info on LINKS). [...] 22692 72 41_Re: SORTDATA, SORTKEYS and REUSE on Reorg20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 28 Mar 2000 09:37:59 -0500346_us-ascii SORTKEYS initiates another subtask to build the index in parallel and specifying "SORDEVT .. SORTNUM n" will ensure that in DB2 V6 your REORG job will have multiple subtask to build the multiple indexes in parallel. However in V5 and especially if you have single clustering index than SORTKEY may not give you any desired benefit. [...] 22765 60 37_Re: Vedr: Re: HAVE TO CONVERT INDEX ?0_19_Tim.Lowe@STPAUL.COM31_Tue, 28 Mar 2000 09:50:12 -0500566_us-ascii The REBUILD INDEX will do an HDELETE if the index dataset is migrated(rather than an HRECALL and DELETE), so a separate HDELETE is really not necessary.

Thanks, Tim













"Jens P. Hansen" on 03/28/2000 07:23:20 AM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

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





Subject: Vedr: Re: HAVE TO CONVERT INDEX ? [...] 22826 14 27_AW: Has anyone found REXX ?16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Tue, 28 Mar 2000 18:33:09 +0200323_- As far as I remember the REXX with V5 work pretty well on V6 too.

Roland

================================================ 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. 22841 54 27_Re: HAVE TO CONVERT INDEX ?14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Tue, 28 Mar 2000 10:40:00 -0600455_iso-8859-1 Hey Dave:

What is "waycool"??? A new virus? Some new user interface from Compuware?

I just couldn't resist the temptation to respond to this one! ;->

And by the way, from the BMC front Change Manager can help convert type 1 to type 2 indexes...

Cheers, Craig S. Mullins Director, DB2 Technology Planning BMC Software http://www.bmc.com Craig_Mullins@bmc.com http://www.craigsmullins.com cmullins@compuserve.com [...] 22896 102 25_Re: regarding performance14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 28 Mar 2000 10:50:42 -0500323_iso-8859-1 Ravi,

In DB2 V6, the optimizer will try to re-write all NOT IN's to NOT EXIST's. There is a set of rules where it cannot of course. You can look at the DB2 V6 manuals on the IBM Web site for all the many details. But there you see the bottom line: as a general rule, NOT EXIST out performs a NOT IN. [...] 22999 29 10_Re: DB2 V612_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 28 Mar 2000 18:57:55 +0200451_x-user-defined Hi, I agree. About 2 years ago I presented a detailed program for tuning with estimation of both time invested and money (hopefully saved). I got a go ahead permission, just had to present weekly reports. The final result was good enough to postpone computer upgrade for nearly a year. Since then we don't have any problems to get permission to invest in tuning and requests for new version move much faster in the "bean counting" dept. 23029 24 33_Re: Time consuming load processes12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 28 Mar 2000 18:58:05 +0200177_x-user-defined Hi,

Assuming you have full image copy you can use DSN1COPY to get the data from them and then rebuild the indexes (in parallel). This would be much faster. 23054 97 18_Re: DB2 UDB on AIX14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 28 Mar 2000 11:01:17 -0500691_ISO-8859-9 DB2 UDB on AIXUse INSERT INTO...SELECT FROM... Regards, Richard +===+===+===+===+====+ Richard_Yevich@attglobal.net www.YLAssoc.com www.RYCi.com www.DB2-Performance-Journal.com



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Emrah GUVEN Sent: Tuesday, March 28, 2000 6:34 AM To: DB2-L@RYCI.COM Subject: DB2 UDB on AIX



I beg your pardon and want to ask a question ; Is it possible to "copy the data of a table to one similar other able - with the same structure - , without using export/import utility in order to save space & time ) " , i know that it is possible to use "select into ... where [...] 23152 53 17_db2UDB on Solaris13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Tue, 28 Mar 2000 12:26:30 -0500505_us-ascii Using DB2UDB on Solaris with windows nt client. On the client I have th control center. I have created a new system, new instance on solaris. When I try to create new database from the control center using the SmartGuide I get SQL1092N "System" does not have authority....

I am logged on using an ID that is part of the nt admin group and also one that is the creator id of the db2 instance on the solaris... I cannot find where the "System" id in the control center is coming from.. [...] 23206 69 27_Re: HAVE TO CONVERT INDEX ?14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Tue, 28 Mar 2000 12:26:46 -0500597_iso-8859-1 Hi Suthep,

No budget - I know exactly where you are coming from ! :-)

Have you ever heard of Xephon ??? - http://www.xephon.com/db2update.html It is a facility where people share REXX's they have developed to automate the performance of tasks related to the DB2 environment. There was a REXX published in the July 1999 issue that to do index conversion and more. It will list indexes in a subsystem and upon selection generates the Alter and Recover index statements in a job automatically. I used it, and it works great. The caveat is you must subscribe in order to [...] 23276 148 27_Re: HAVE TO CONVERT INDEX ?12_Tal Lifshitz20_Tal.Lifshitz@WDR.COM31_Tue, 28 Mar 2000 12:18:02 -0500581_ISO-8859-1 Joe,

Don't forget that you need to recall migrated tablespaces before you recover the indexes. If you are interested, I have a REXX script that generates JCL to convert indexes to type 2 and it handles also the case of migrated or deleted indexes and tablespaces. If a tablespace was migrated, it will restore it. If a tablespace was deleted, it will re-DEFINE the VSAM file and load one of the tables in the tablespace with RESUME NO REPLACE SYSREC DD DUMMY. If an index was migrated, it will DELETE NOSCARTCH and re-DEFINE the VSAM file. Then when all the [...] 23425 54 24_Re: Conditional REORG???23_AITHA, BHEEMSEN (SBCSI)23_B4AITHA@MSG.PACBELL.COM31_Tue, 28 Mar 2000 09:38:01 -0800408_iso-8859-1 Hi Max,

Can you please send your rexx execs to the list so that everybody is benefited.

thanx..

-----Original Message----- From: Massimo Scarpa [mailto:mscarpa@CESVE.IT] Sent: Monday, March 27, 2000 11:17 PM To: DB2-L@RYCI.COM Subject: Re: Conditional REORG???



Hi Sanjeev.

May I suggest to try to use IBM DB2WWWX to execute SQL in a REXX ? You need [...] 23480 25 35_Re: Access 97 to DB2/MVS Conversion12_Jim Harrison12_jimh@QIS.NET31_Tue, 28 Mar 2000 12:24:44 -0500539_us-ascii The software has been updated since I looked at it last, but according to the documentation and my own testing, it still does not support OS/390 or AS400 versions of DB2.

At 04:08 PM 3/27/00 -0500, you wrote: >I tried it last summer and IIRC I believe it is for non-MVS UDB. I am >DLing it again to be sure. > >At 02:32 PM 3/27/00 -0600, Jason Hughes wrote: >>Alan, >>Following is the email text from IBM of an Access to DB2 conversion utility. >>I have not used it so I cannot rate it for you. Just passing along the [...] 23506 63 33_Re: Time consuming load processes18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM31_Tue, 28 Mar 2000 13:02:20 -0500346_us-ascii Isaac & Roland,

I haven't used DSN1COPY so far for this process but will give it a try if it is really going to make a substantial difference as suggested by you.

However, I am still curious to know if it is possible to BUILD INDEXES in parallel during LOAD using the SORTKEYS and SORTDEVT parameter in the load card. [...] 23570 53 53_Why is 'explain' output different from 'bind' output?14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Tue, 28 Mar 2000 13:39:03 -0600605_iso-8859-1 We have a poorly executing CICS program in production, which I'm trying to improve. The statement in question is

SELECT ADDITION_NUM INTO :HV FROM TXRP_ADDN_HEADER WHERE (BEG_AR_KEY_NUM = :HV OR END_AR_KEY_NUM = :HV) AND ADDITION_NUM <> :HV

There is a unique constraint on each of BEG_AR_KEY_NUM and END_AR_KEY_NUM, with non-clustering ascending indexes, about 53% clustered. There is also a non-clustering unique index on ADDITION_NUM + BEG_AR_KEY_NUM, ascending, also about 53% clustered. There are 6713 rows in the table and 360 active rows in the (segmented) tablespace. [...] 23624 34 33_Re: Time consuming load processes12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 28 Mar 2000 21:56:12 +0200563_x-user-defined Hi, As per performance, I use DSN1COPY whenever possible and rebuild indexes after that (in parallel jobs). Sometimes there are always questions of disk space shortage for doing all indexes in parallel. You can do DSN1COPY of indexes as well but then you MUST insure that they and the data are current, you don't want to take data from yesterday imagecopy and index from today.... When there is a need to copy more then 1 TS then I DSN1COPY them as much as I can in parallel and submit the rebuild indexes after each TS has been copied (I use [...] 23659 270 36_Re: HAVE TO CONVERT INDEX ? Xephon??15_Stovall, Martin16_MStovall@USG.COM31_Tue, 28 Mar 2000 14:04:35 -0600684_iso-8859-1 Anyone who subscribes to Xephon DB2 update - is it worth the subscription price??

-----Original Message----- From: William Gannon [SMTP:wgannon@INET-SERVICES.PALMBEACH.K12.FL.US] Sent: Tuesday, March 28, 2000 11:27 AM To: DB2-L@RYCI.COM Subject: Re: HAVE TO CONVERT INDEX ?

Hi Suthep,

No budget - I know exactly where you are coming from ! :-)

Have you ever heard of Xephon ??? - http://www.xephon.com/db2update.html It is a facility where people share REXX's they have developed to automate the performance of tasks related to the DB2 environment. There was a REXX published in the July 1999 issue that to do index conversion and more. It [...] 23930 60 33_Re: Time consuming load processes9_Colin Fay13_cfay2@CSC.COM31_Tue, 28 Mar 2000 16:07:55 -0400725_us-ascii Hi Isaac,

Would you be willling to post your Rexx routines for building the DSN1COPY on the listserv?

Thanks

Colin







yassin@netvision.net.il on 03/28/2000 02:56:12 PM

Please respond to DB2-L@ryci.com

To: DB2-L@ryci.com cc: (bcc: Colin M Fay/TMG/CSC) Subject: Re: Time consuming load processes





Hi, As per performance, I use DSN1COPY whenever possible and rebuild indexes after that (in parallel jobs). Sometimes there are always questions of disk space shortage for doing all indexes in parallel. You can do DSN1COPY of indexes as well but then you MUST insure that they and the data are current, you don't want to take data [...] 23991 48 33_Re: Time consuming load processes12_Bing Alabata25_bing.alabata@MCMASTER.COM31_Tue, 28 Mar 2000 13:58:20 -0600600_us-ascii You can also DSN1COPY the related INDEXes and buffer the LDS VSAM datasets in their associated DD statements.

At 09:56 PM 3/28/00 +0200, you wrote: >Hi, >As per performance, I use DSN1COPY whenever possible and rebuild indexes after >that (in parallel jobs). >Sometimes there are always questions of disk space shortage for doing all >indexes in parallel. >You can do DSN1COPY of indexes as well but then you MUST insure that they and >the data are current, you don't want to take data from yesterday imagecopy and >index from today.... >When there is a need to copy more then 1 [...] 24040 91 57_Re: Why is 'explain' output different from 'bind' output?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 28 Mar 2000 15:09:48 -0500355_us-ascii Few clarification: 1. Which version of DB2 you are at ? 2. You said >>>There are 6713 rows in the table and 360 active rows in the (segmented) tablespace."<<< I guess you meant 6713 rows and 360 active pages !!

3. What is the owner when you did the REBIND and what is the CURRENT SQLID when you did the explain ? Were they the same ? [...] 24132 62 57_FW: Why is 'explain' output different from 'bind' output?14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Tue, 28 Mar 2000 14:09:56 -0600460_iso-8859-1 I answered my own question #1: the reason is that 'explain' is assuming more than one row and the statement isn't....

-----Original Message----- From: Terry McCombs [mailto:tmccomb@sedgwick.gov] Sent: Tuesday, March 28, 2000 1:39 PM To: 'db2-l@ryci.com' Subject: Why is 'explain' output different from 'bind' output?

We have a poorly executing CICS program in production, which I'm trying to improve. The statement in question is [...] 24195 24 12_RPG to COBOL25_Skelton, Terry (corp) USX21_tskelton.inc@MOOG.COM31_Tue, 28 Mar 2000 15:13:11 -0500552_iso-8859-1 Hello, We're doing a large conversion of a company and I'm wondering if anyone from this list has knowledge of a good RPG II to COBOL converter software package to run on an AS400 . TIA, Terry

Terry W. Skelton Database Administrator Moog Inc East Aurora, NY 716-687-4175 tskelton.inc@moog.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. 24220 112 57_Re: Why is 'explain' output different from 'bind' output?14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Tue, 28 Mar 2000 14:17:48 -0600305_us-ascii I should have said this is on OS/390, V5.1. As far as the SQLID, no the owners weren't the same. I did happen to think of and tried the explain again with "OPTIMIZE FOR 1 ROW" and got the same plan the production package is coming up with, so at least I'm happy that DB2's being consistant. [...] 24333 19 16_Re: RPG to COBOL0_31_truman.g.brown@BELLATLANTIC.COM31_Tue, 28 Mar 2000 15:19:41 -0500329_us-ascii I don't want to sound snippy, but it should be fairly easy and quick without a conversion tool (which probably doesn't exist) unless you have a really large number to convert (carpel tunnel syndrome).

RPG II is very straightforward, and COBOL programs to perform the same tasks should be on the simple side. [...] 24353 17 16_Re: RPG to COBOL25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Tue, 28 Mar 2000 14:56:37 -0600477_us-ascii I probably should stay out of this, but on the "main frame" side RPG was reintroduced as part of the FIPS standard for COBOL. That being said there's gillions of Report/Writers-Info Retrieval products that are GUI and WYSIWYG.

================================================ 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. 24371 60 49_Recovery - appreciate feedback on how to do wiser17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Tue, 28 Mar 2000 14:53:29 -0600430_us-ascii I just thought I would share an recent recovery experience with you. I'm always looking for a way to improve our processes so I would appreciate any feedback you may have.

Thanks,

:-)

Jerry Bustamente Lands' End

Scenario:

LARGE tablespace 64 partitions clustering index 3 non-partitioning indexes - user defined, not stogroup 670 million rows spread evenly across partitions no RI [...] 24432 27 16_Archive products22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Tue, 28 Mar 2000 13:15:40 -0800474_- Hi there,

We have been evaluating Princeton Softechs Archive for DB2. At This point in time we would like to know if any of you out there in DB2 land have purchased another vendors archive product and what your experiences with it have been. I'm sure CA, BMC and others have some kind of Archive product. We are looking for ease of use and reasonable cost. We have most of the CA/Platinum suite. Any insight and experiences would be greatly appreciated. TIA.. [...] 24460 109 53_Re: Recovery - appreciate feedback on how to do wiser0_18_damcon2@US.IBM.COM31_Tue, 28 Mar 2000 16:31:26 -0500569_us-ascii Jerry,

Wow!!! I guess commit/restart logic is out of the question!?

Cheers, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 878-3525, Tie Line 8-427-3525 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW -----------------------------------------------------



Gerald Bustamente @RYCI.COM> on 03/28/2000 03:53:29 PM

Please respond to DB2 Data Base Discussion List [...] 24570 114 53_Re: Recovery - appreciate feedback on how to do wiser17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Tue, 28 Mar 2000 15:37:40 -0600716_us-ascii That'd be too easy.

:-)

damcon2@US.IBM.COM wrote:

> Jerry, > > Wow!!! I guess commit/restart logic is out of the question!? > > Cheers, > Jay > > Jay Reavill > damcon2@us.ibm.com > IBM Global Services > Tampa, Florida > Tel: (813) 878-3525, Tie Line 8-427-3525 > ----------------------------------------------------- > Happiness is not around the corner. > Happiness is the corner. > - BMW > ----------------------------------------------------- > > Gerald Bustamente @RYCI.COM> on 03/28/2000 03:53:29 > PM > > Please respond to DB2 Data Base Discussion List > > Sent by: DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM [...] 24685 50 26_DB2 for OS/390 Tech Forums13_Thomas, Janis19_Janis.Thomas@CA.COM31_Tue, 28 Mar 2000 17:04:55 -0500341_iso-8859-1 Computer Associates has recently announced the 2000 Schedule for our Technology Forums for DB2 for OS/390. This year's North American schedule consists of 48 shows and continues until mid-September. These FREE, 1/2 day, tech-intensive classes offer a world of information on how to keep your DB2 systems on the cutting edge. [...] 24736 207 30_Column Definition in SYSTABLES16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Tue, 28 Mar 2000 17:49:45 -0500506_- This is a question about how DB2 interprets column length in view definitions.

I created a view using the following syntax last night:

CREATE VIEW VIEW1 ( COL1 , COL2 , COL3 , COL4 , COL5 ) AS SELECT C.COL1 , C.COL2 , C.COL3 , C.COL4 , SUM(D.COL5) , FROM TABL1 C , TABL2 D , TABL3 O WHERE C.COL6 = 'A' AND C.COL7 = 'Y' AND C.COL8 <> 'P' AND C.COL1 = ( SELECT COL1 FROM TABL4 WHERE COL9 = D.COL10 AND COL11 = 'CUSTOMER' ) AND C.COL2 = D.COL2 AND O.COL1 = C.COL1 AND D.COL2 = O.COL2 AND [...] 24944 37 11_unsubscribe12_Carlton Yuen18_tcyuen@AKAMAIL.COM31_Wed, 29 Mar 2000 07:10:17 +080043_iso-8859-1 Anyone knows how to unsubcribe ? 24982 118 57_Re: Why is 'explain' output different from 'bind' output?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 29 Mar 2000 09:11:41 +1000326_us-ascii Terry,

I agree with Venkat re checking you are in same environment with same authid so that you ensure the same Catalog stats. for explain.

For separate Explain of the SQL you must replace host variables with question marks.

The other option to OR is UNION or UNION ALL (to avoid DB2 Sort): [...] 25101 22 38_Trap and Analyze Dynamic SQL in Flight0_20_Carl_Nelson@AICI.COM31_Tue, 28 Mar 2000 18:14:32 -0500548_us-ascii We would like to trap dynamic SQL in flight, analyze it, and cancel it if it is projected to be too resource intensive. This sounds like a lead-in for a vendor tool but money is not available at this time. We are OS/390 v4 going v5 and have BMC's Activity Monitor & Opertune. These products did not appear to have this functionality documented in their manuals. I have reviewed the RLF in the Admin Guide and the QMF governor in the QMF manual but neither appear to trap upfront and stop SQL before it expends a lot of resources. Can [...] 25124 75 57_FW: Why is 'explain' output different from 'bind' output?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 29 Mar 2000 09:16:26 +1000704_us-ascii I don't understand your own answer. Did you use OPTIMIZE clause? DB2 currently chooses same access path for singleton SELECT as for Cursor.

From: Michael Hannan >From: "McCombs, Terry" >Subject: FW: Why is 'explain' output different from 'bind' output? >To: DB2-L@RYCI.COM > >I answered my own question #1: the reason is that 'explain' is assuming more >than one row and the statement isn't.... > > -----Original Message----- >From: Terry McCombs [mailto:tmccomb@sedgwick.gov] >Sent: Tuesday, March 28, 2000 1:39 PM >To: 'db2-l@ryci.com' >Subject: Why is 'explain' output different from 'bind' output? > >We have a poorly executing CICS program in production, [...] 25200 69 42_Re: Trap and Analyze Dynamic SQL in Flight14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Wed, 29 Mar 2000 09:23:48 +1000535_us-ascii Carl, The only thing I would say is how would you determine that the SQL was going to be "too resource intensive" ? If you can intercept the SQL and dynamically prepare it you can look in the SQLERRD(4) field of the SQLCA to get the TIMERONS value from DB2 (refer SQL REFERENCE). This is supposed to be a "rough relative estimate of resources required". It may be this that your after. The only thing I would say is that I've learned to pay very little heed to this number, as I've seen queries with a low value for this [...] 25270 119 25_Re: NOT IN vs. NOT EXISTS14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 29 Mar 2000 10:25:56 +1000430_us-ascii Ravi,

'It depends' (sometimes).

Correlated NOT EXISTS is usually recommended over Non-corellated NOT IN. In fact I believe DB2 V6 has internal rewrite from NOT IN to NOT EXISTS in some cases.

The first thing I do with internal rewrite, is work out how to disable it. If I wanted a NOT EXISTS I would have coded it! Internal Rewrite is more for SQL writers with weaker performance understanding. [...] 25390 90 42_Re: Trap and Analyze Dynamic SQL in Flight14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 29 Mar 2000 10:34:17 +1000376_us-ascii I believe IBM are introducing the predictive governer.

I agree with Paul that Timerons are extremely misleading for complex SQLs (more than 1 table). Single table SQLs are probably not too bad provided no range predicates with host variables and no skewed data distributions and clusterratios not too optimistic. Too many ifs and buts so forget timerons! [...] 25481 59 34_Application-based locations in DDF9_jim.szabo22_jim.szabo@MCIWORLD.COM31_Tue, 28 Mar 2000 19:53:35 -0500631_iso-8859-1 DB2 for OS/390 V5

Want to know if it is possible to define application-based locations in DDF.



Here is our scenario:

We have a two-tiered application that issues explicit CONNECT TO statements to the DDF location defined as DB2 subsystem where the data is. This information is stored on the client in a configuration file, to allow the connection location to be changed to allow a small number of clients to connect to, say, a test DB2 subsystem rather than the production one. However, once the software is rolled out to the many production clients, the configuration has the explicit [...] 25541 72 93_Repost: REMINDER: IDUG No. American Conference - Discounted Early Registration Until April 1413_Morrill, John12_JohnM@VP.NET31_Tue, 28 Mar 2000 18:01:49 -0700559_- 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,

Please find below a reminder bulletin from IDUG about the upcoming North American conference. I hope to see you at the conference...Be there or be square! [...] 25614 27 71_JDBC to DB2/OS390 from and EJB on Webshere for NT - How to config ure ?15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Wed, 29 Mar 2000 11:09:09 +1000300_iso-8859-1 What is the best way to do this ?

I happen to have UDB EE v5.2 for NT on the websphere box so simply went in and defined my DB2 v5.1 for OS/390 system as a 'database' via the Client Configuration Assistant and then the Websphere EJB just used the local JDBC driver to connect. [...] 25642 116 36_Re: HAVE TO CONVERT INDEX ? Xephon??17_suthep thampranee18_suthepth@SCB.CO.TH31_Wed, 29 Mar 2000 08:49:35 +0700541_ISO-8859-1 Hi all, Thank you all of your kindness. TIA JOE Suthep Thampranee DBA SCB Bank



---------- From: Stovall, Martin To: DB2-L@RYCI.COM Subject: Re: HAVE TO CONVERT INDEX ? Xephon?? Date: 29 ÁÕ¹Ò¤Á 2543 3:04

Anyone who subscribes to Xephon DB2 update - is it worth the subscription price??

-----Original Message----- From: William Gannon [SMTP:wgannon@INET-SERVICES.PALMBEACH.K12.FL.US] Sent: Tuesday, March 28, 2000 11:27 AM To: DB2-L@RYCI.COM Subject: Re: HAVE TO CONVERT INDEX ? [...] 25759 114 38_Re: Application-based locations in DDF23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Wed, 29 Mar 2000 02:46:38 +0100355_iso-8859-1 It would be easier to pick up the connect to variable from an ini file. and then issue the connect to (the ini file db2 subsystem name) then you only need to change the ini file of the application to get it to connect to another DB2 subsystem. This is how we get programs to connect to different databases for test user prod environments. [...] 25874 20 40_migrate DB2 NT to DB2 AIX (same version)14_Romeo B Titong26_rbtitong@ACISYSTEMS.COM.PH31_Wed, 29 Mar 2000 10:34:20 +0800449_us-ascii Hi all!

In migrating DB2 from NT to AIX, do i have to backup my DB2 NT and restore it to DB2 AIX? is this the proper procedure? if not, is there a better solution?

thanks!

Romeo

================================================ 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. 25895 135 44_Re: migrate DB2 NT to DB2 AIX (same version)11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Wed, 29 Mar 2000 13:37:19 +1000559_- Romeo,

unfortunately you cannot use a backup taken in one operating system to restore into a different operating system. You will actually have to recreate all your objects "manually" in AIX. If you don't have the original DDL any more, the db2look command (with the -e option) can help you recreate the objects (except for triggers and UDFs). You will then need to export all tables from NT and import or load them into AIX. Load is much more efficient than import if you have large tables, but it can also do a lot more damage if it runs into [...] 26031 74 57_Re: Why is 'explain' output different from 'bind' output?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 29 Mar 2000 03:12:50 GMT402_us-ascii Hi Terry, I just get a feeling that u should check the explian of the SQLs given by Michael and Venkat i.e



SQL-I (Venkat's) if BEG_AR_KEY_NUM is available then SELECT ADDITION_NUM INTO :H FROM ... WHERE BEG_AR_KEY_NUM = :H AND ADDITION_NUM <>:H

if END_AR_KEY_NUM is available then SELECT ADDITION_NUM INTO :H FROM ... WHERE END_AR_KEY_NUM = :H AND ADDITION_NUM <>:H [...] 26106 19 10_Qmf to web15_Somsak Klumklai21_SomsakK@IT.EGAT.OR.TH31_Wed, 29 Mar 2000 12:01:28 +0700461_windows-874 Dear All,

New I use Net.data to retrieve data from db2 and display in web browser. Have anyone try to invoke QMF procedure in Net.data or in other way To display in web browser?

Regards, Somsak

================================================ 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. 26126 854 33_Re: Code/Valid Value Table Design11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Wed, 29 Mar 2000 15:16:36 +1000556_iso-8859-1 Richard,

I am sorry if I offended IBM's sensibilities by using the term "LUNO" - I remember seeing it being used in this discussion group some time ago, and I thought it had a nice ring to it (slightly tongue in cheek) ... I understand IBM Marketing's desire for DB2 to appear to be the same across all platforms, but I would have thought that simply calling it "DB2" was sufficient for that. Anyway, now that UDB no longer just refers to the version of DB2 which runs on Unix, Windows, etc, I think there is a quite legitimate need [...] 26981 122 21_Re: db2UDB on Solaris11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Wed, 29 Mar 2000 15:18:09 +1000617_- Hi Jimmy, Seems like a job for Support.

I usually create databases from the command line. Sounds like you are v6; 'Show Command' button will give you the correct syntax to run.

HTH, Bruce





> -----Original Message----- > From: Jimmy Willett [SMTP:Jimmy.Willett@NCMAIL.NET] > Sent: Wednesday, March 29, 2000 3:27 AM > To: DB2-L@RYCI.COM > Subject: db2UDB on Solaris > > Using DB2UDB on Solaris with windows nt client. > On the client I have th control center. > I have created a new system, new instance on solaris. > When I try to create new database from the control center [...] 27104 84 34_Re: Column Definition in SYSTABLES14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 29 Mar 2000 15:52:55 +1000333_iso-8859-1 Andrea,

Have you put DEC31 on? Then read the SQL Reference definition of the SUM function. Especially the bit that goes: "If the precision of the argument values is greater than 15 or the DEC31 option is in effect, the precision of the result is min(31,P+10), where P is the precision of the argument values." [...] 27189 151 44_Re: migrate DB2 NT to DB2 AIX (same version)14_Romeo B Titong26_rbtitong@ACISYSTEMS.COM.PH31_Wed, 29 Mar 2000 13:49:34 +0800924_us-ascii Thanks for the reply!

I am actually doing the export-import procedure. I was hoping there would be a quicker solution :)

Romeo













"KUHN,Ulrich" on 03/29/2000 11:37:19 AM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Romeo B Titong/Operations/ACISystems)





Subject: Re: migrate DB2 NT to DB2 AIX (same version)

















Romeo,

unfortunately you cannot use a backup taken in one operating system to restore into a different operating system. You will actually have to recreate all your objects "manually" in AIX. If you don't have the original DDL any more, the db2look command (with the -e [...]