1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2000, week 5
2 15 47_Kimberlee Little/IT/SEARS is out of the office.10_Kim Little17_klittle@SEARS.COM31_Sat, 29 Jul 2000 01:24:34 -0500441_us-ascii I will be out of the office from 07/29/2000 until 08/07/2000.
I will respond to your message when I return. If an immediate response is necessary, please contact Pam Harris (PHARRI1).
================================================ 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.
18 28 32_LE 4093 problem on CICS /DB2 IVP10_john clark20_pak02449@PIXIE.CO.ZA31_Sat, 29 Jul 2000 10:04:30 +0530580_us-ascii Hi everyone,
I have a silly problem in trying to run the CICS COBOL IVP system after a version 6 OS/390 install.
All the steps of the install including particularly the DSNH compile etc portion have gone through with the expected return code, but when trying the D8C transaction we abend immediately after program initiation. The reason code from LE is 03E, but if you look this up you will see that IBM have once again been in a situation where they are confused as to whether they are writing a messages codes manual or cryptic clues for MYST, RIVEN [...]
47 34 29_FW: DB2 Stored procedure help11_sudhakaranr19_sudhakaranr@INF.COM31_Sat, 29 Jul 2000 20:02:13 +0530506_- I'm not sure whether my previous mail reached you. i'm resending this.
Thanks, Sudhakaran R
> Hi , > > We have a requirement where we need to write into a error > log file > from a stored procedure(Cobol - DB2 / DB2 version 5.2) . > > This stored procedure is to be called by a tool (CoolGen ). > > Can we write into a file from the stored procedure? > > If yes, where will i specify the name of the file > that the stored procedure has to write into? > > Thanks, > Sudhakaran [...]
82 88 18_Re: QMF compliancy0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Sat, 29 Jul 2000 10:02:28 -0500406_us-ascii Back when we were checking all our software for compatibility with V6, IBM told us that QMF V3.3 (which is what we are on) is tolerant with DB2 V6 but if you want the exploitable version, they recommend going to QMF V6.1
sjvagnier@AEP.COM on 07/28/2000 09:56:28 AM
Please respond to DB2 Data Base Discussion List [...]
171 62 42_Re: Enforcing uniqueness on partial column14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sun, 30 Jul 2000 13:18:13 +1000341_iso-8859-1 Actually, in V7 the answer will be "yes" - you'll be able to create a unique index on "SUBSTR(col,1,4)". Until then, all you be able to do is - have another column, on which there is a unique index, which contains the first 4 characters; or - (V6, as Larry suggested) use a trigger to fire off a SP which verifies uniqueness [...]
234 129 18_Re: QMF compliancy14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sun, 30 Jul 2000 13:41:05 +1000387_iso-8859-1 Shan
Did they actually say 'exploit'? Just try DRAWing a table (using QMF V6) that contains any of the new datatypes (let alone SELECTing them) and you'll see how non-existant the exploitation is. (ie "Sorry, a system error occurred.")
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au [...]
364 34 13_DB2 Satellite15_Amitabh Akolkar23_oxynet@MAILCITYASIA.COM31_Sun, 30 Jul 2000 10:15:17 +0530362_us-ascii Hi,
I have just joined this list. I wanted to know whether multiple users can connect to a DB2 satellite?
basically we have a distributed database scenario where the databases will be located in various cities in the country. all these databases have to be synchronized with one database i.e. the central database at the head-office. [...]
399 108 19_FW: LOCKPART clause15_MAHSOUN, KHALID29_kmahsoun@SAUDIAIRLINES.COM.SA31_Sun, 30 Jul 2000 08:54:20 +0300402_WINDOWS-1256 Can any one help -----Original Message----- From: ALBAR, HASHIM O Sent: 26 July, 2000 01:05 ã To: MAHSOUN, KHALID Subject: LOCKPART clause
Khalid, What is the deference between LOCKPART YES and LOCKPART NO in the CREATE and ALTER statement for a TABLE SPACE?
According to DB2 V.5 Administration Guide Volume 2 page 5-145 LOCKPART NO is the value you want in most cases. [...]
508 195 18_Re: QMF compliancy0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Sun, 30 Jul 2000 07:48:59 -0500484_us-ascii James, Below is the response from IBM on May 24, 2000 when we asked about compatibility of QMF V3.3. When they indicated to install QMF V6 for exploitation I certainly would have assumed that the draw command you describe should be working. If it isn't, I would report to IBM. I checked other apars for V6 and I don't see the one you describe cited. Thanks for bringing to our attention. The only APAR that showed up in regards to the DRAW was for QMF 3.1 noted below . [...]
704 20 15_QMF for Windows12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Sun, 30 Jul 2000 08:39:03 -0500336_iso-8859-1 Is anyone using SMS to push out new releases of QMF for Windows? We have QMF actually loaded on our local PCs and linked to the windows nt server in order to take advantage of the access and excel plug ins. However in the future we will probably just have them execute off of the server and export from QMF for Windows. [...]
725 57 18_Re: QMF compliancy14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 31 Jul 2000 14:26:17 +1000589_iso-8859-1 Shan,
1) Read, for example, PQ27573 (Date Closed 00/04/18): "LOB and ROWID data types are new in DB2/OS390 V6R1. QMF V6R1 and previous releases do not support these data types."
2) Weep.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au -----Original Message----- From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM [mailto:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] Sent: Sunday, July 30, 2000 10:49 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] QMF compliancy [...]
783 42 15_Re: DB2 Locking7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Mon, 31 Jul 2000 11:39:19 +0530706_iso-8859-1 Have you checked up your ACQUIRE and RELEASE Bind parameters.I believe the starting point should be this and also should be specific to the transactions.
Hope this helps
Regards
Sanjeev
-----Original Message----- From: Charles Jambrosic [mailto:Charles_Jambrosic@CSIHOME.COM] Sent: Saturday, July 29, 2000 2:47 AM To: DB2-L@RYCI.COM Subject: DB2 Locking
We are using LOCK ANY for our segmented tablespaces which is fine for our onlines but not necessarily for our batch. We were going to run alters for our tablespaces specifying locks on the tablespace prior to running batch to see if it would improve performance. Does anyone know of any other [...]
826 78 19_Re: LOCKPART clause7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Mon, 31 Jul 2000 11:53:11 +0530636_windows-1256 Hi , LOCKPART(YES) will lock only the partitions as it is accessed.Other locking procedures will follow as it is there in the Hierarchy of the locks.Depending on the LOCKSIZE parameters it will start from the lowest level and then as the last level escalation in the non-partition tablespace moves it to tablespace lock.In case of the LOCKPART(YES) ,it will be moved to locking only the partitions which are access.In case of LOCKPART(NO) ,it will follow the same procedure as in non-partition tablesapces. I believe not all the applications accesses only single partition at a single run.If the application design is [...]
905 45 43_Re: Problem with program binded DEGREE(ANY)7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Mon, 31 Jul 2000 12:01:37 +0530456_iso-8859-1 Hi Michele, If you are sure that it is query with NOT EXISTS then do you find any chance that DB2 optimizer is rewriting the sql and performing some kind of join to fulfil your requirements.I believe it is very difficult to see the parallelism in query with NOT EXISTS(Can't think about CPU but sure about I/O). Hope to get some more informations from the experts.In the mean time if possible ,please send the sql which you have mentioned. [...]
951 106 42_AW: Enforcing uniqueness on partial column12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 31 Jul 2000 08:41:21 +0200516_iso-8859-1 James, you mention V7. Do you talk about DB2 for OS/390 or a DB2 on another platform ?
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...]
1058 117 27_AW: Data Dictionary Options12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 31 Jul 2000 09:24:13 +0200394_iso-8859-1 Carolyn, we're using the LABEL- and the REMARK(= COMMENT-) columns in SYTABLES and SYSCOLUMNS for documenting our tables and columns. The bad side is we've to do it handish. The good side is that the printed documentation (that we can produce) is a good vehicle when we have to talk/discuss with the users and other people involved in a project. Please see some examples below. [...]
1176 26 51_AW : Steplibraries Concatenated to a CICS - DB2 pgm30_Ramesh Padmanabha, AMB Chennai34_ramesh_padmanabha@MSDC.HCLTECH.COM31_Mon, 31 Jul 2000 13:24:39 +0530533_- Hi,
Can anyone tell me what exactly these libraries contain in detail. I know that they contain DB2 error routines, load module of DCAPNXC. I want more information,
SYS2.SMARTCAF.LOAD ACS11.SMARTCAF.DBP2.LOAD DBSMPP2.DBDC.DSNEXIT SYS2.DBP2.DSNLOAD
Bye Ramesh P
================================================ 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.
1203 68 20_Re: Reorg Procedures13_Hanne Lyssand10_han@VPS.NO31_Mon, 31 Jul 2000 10:16:56 +0200340_us-ascii I have worked in to different companies and served as a production DBA for serveral costomers. I have seen differnt way's of doing reorgs. I have to succestions depending of the type of reorg. I have impemented share level change reorg. We started with shareleve change after migrating to version 5.1, now we use version 6.1. [...]
1272 70 26_FW: [DB2-L] QMF compliancy14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 31 Jul 2000 20:07:56 +1000287_iso-8859-1 I have realised that some might misunderstand who should be wept for - it is the person(s) who were lame brained enough to call QMF V3.4.1 "V6.1" instead! You might notice that the QMF V6.1 manuals don't have a "What's new" section - that would have given the game away. [...]
1343 29 14_DB2 satellite.15_Amitabh Akolkar23_oxynet@MAILCITYASIA.COM31_Mon, 31 Jul 2000 15:50:09 +0530390_us-ascii Hi,
we here have ditributed database scenario where our offices in various cities in the country will their local database (DB2) which will be synchronized with the central database at the head office. we heard of a product called DB2 Satellite which eliminated user intervention in synchronizing data between the central database and the local databases (satellites). [...]
1373 129 46_Re: AW: Enforcing uniqueness on partial column14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 31 Jul 2000 20:30:41 +1000419_iso-8859-1 I am now not sure if I even mean DB2. I can't find the references where I though they were. I suppose you had better forget I said it - until they put it in and I'll take credit for the foresight!
James
-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Monday, July 31, 2000 4:41 PM To: DB2-L@RYCI.COM Subject: [DB2-L] AW: Enforcing uniqueness on partial column [...]
1503 94 38_Re: Users changing their own passwords16_Michael McCarthy18_mmccarthy@DTCC.COM31_Mon, 31 Jul 2000 08:33:08 -0400524_us-ascii Hi,
When connecting from a DB2 client, you can use the change password option of the connect command.
-Mike.
csc266 on 07/28/2000 06:59:51 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Michael McCarthy/DTC) Subject: [DB2-L] Users changing their own passwords
Is there a way to accomplish DB2 password changes with the following constraints [...]
1598 37 23_Quiesce PART n and NPIs14_Adrian Collett27_adriancollett@TISCALINET.IT31_Mon, 31 Jul 2000 14:43:27 +0200382_iso-8859-1 Dear List,
When trying to perform a QUIESCE PART n we receive the following message:-
DSNU306I - Unable to drain writers from indexspace DB.IX.
The indexspace in question is a NON-PARTITIONING INDEX.
In fact, at the same time as the QUIESCE PART n there was another job running which was updating PARTITION y.
I have 2 questions:- [...]
1636 53 20_Re: Reorg Procedures23_Donald W. Woodruff, Jr.30_dwoodruf@CI.NEWPORT-NEWS.VA.US31_Mon, 31 Jul 2000 09:17:03 -0400117_iso-8859-1 I wanted to thank all of those that replied to my questions on DB2 reorg procedures.
Thanks, Donnie
1690 133 19_Re: LOCKPART clause20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 31 Jul 2000 09:54:52 -0400588_iso-8859-1 Hi Sanjeev
LOCKPART YES works not exactly the same way you described it. Consider the following scenario:
When ever application takes locks, it takes page lock (if LOCKSIZE PAGE/ANY) and it also takes Intent locks on the tablespace. Let us say application is just read-only and bound with CS, then it takes S page lock on the page it is reading, while IS on the tablespace. Another application wants to update another page in the same tablespace then that application takes X page lock (if no locks on that page) and IX lock on the tablespace. The IS and IX [...]
1824 36 55_Re: AW : Steplibraries Concatenated to a CICS - DB2 pgm0_17_JTonchick@AOL.COM29_Mon, 31 Jul 2000 10:48:17 EDT337_US-ASCII Ramesh, You may have to ask the systems programmers about the "SMARTCAF" libraries. They look like they are for some vendor product. From the name, I'm guessing that they have to do with DB2's Call Attach Facility (CAF). If they are, then whey thar're in the JCL for CICS is beyond me because CAF is not needed under CICS. [...]
1861 12 43_C++ main pgm, no DB2 calls C++ pgms with DB11_Tom Johnson25_new_to_db2@SPRINGMAIL.COM31_Mon, 31 Jul 2000 10:58:43 -0400542_- DB2 v5 MVS
We have a group of developers that are working in C++. They are taking the approach of using a main program that calls other programs to perform work. Our main progam has no DB2 in it, but the called programs do. As you would expect there is an empty DBRM generated from the main program and it won't bind. Also, we are running the program using TSO attach. My recommendation was to put a simple SET :H = CURRENT TIMESTAMP into the main program. The developers don't like the idea. Are there any alternatives??? TIA. [...]
1874 15 34_RVA snapshots during online reorgs29_Krishna.Srinivasan (Exchange)29_Krishna.Srinivasan@TARGET.COM31_Mon, 31 Jul 2000 09:54:41 -0500404_iso-8859-1 Is RVA shapshot an option to create shadow copies when doing online reorgs? We have DB2 v5.1 with datasharing and RVA disks for storage.
Thanks.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1890 58 36_Re: LE 4093 problem on CICS /DB2 IVP22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 31 Jul 2000 11:22:42 -0400519_iso-8859-1 Make sure your compile & link edit is pointing to the LE libraries.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: john clark [mailto:pak02449@PIXIE.CO.ZA] Sent: Saturday, July 29, 2000 0:35 To: DB2-L@RYCI.COM Subject: [DB2-L] LE 4093 problem on CICS /DB2 IVP
Hi everyone,
I have a silly problem in trying to run the CICS COBOL IVP system after a version 6 OS/390 install. [...]
1949 45 38_Re: RVA snapshots during online reorgs15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Mon, 31 Jul 2000 10:28:29 -0500499_iso-8859-1 As far as I know only the DB2 Concurrent COPY function transaprently exploits the RVA hardware Snapshot to create a dump of the dataset(s). This is supported by DB2 RECOVER but is not a real DB2 IC.
Also as far as I know only BMC Software's REORG PLUS exploits the RVA snapshot capability to do what you suggest - create the initial shadow images which are then reorganised and have updates applied to them. It also works with other DASD Vendors. [...]
1995 24 12_QMF question13_Judi Westcott23_judi_westcott@YAHOO.COM31_Mon, 31 Jul 2000 10:23:56 -0500367_- Hello
Quick question.
We are trying to find a way to get a QMF report to print a final text line even if there are no DB2 rows that satisfy the query.
For instance, the final text line is 'Total rows &count'. If there are no rows found we want 'Total rows 0' to be printed. All we see on the report is Column headings and then *** End *** [...]
2020 133 37_Re: DDF performance problem in DB2 V413_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 31 Jul 2000 10:42:07 -0500456_US-ASCII Myoungsoo, Try rebinding the package with REOPT(VARS) bind option. HTH Kurt
>>> xdbjmsh@HOTMAIL.COM 07/28/00 05:10AM >>> Hi all , This is what I findings after I post DB2 V4 Performance problem , days ago.
After Migration to DB2 V4 , at same time DB2 connect V 5.2 was applied ( or updated ?) with new FIXPACK (?) and rebinded. After that ,I met severe SIO in DB2 V4 especially on DDF thread that submitted through DB2 connect. [...]
2154 152 32_Re: Stored Procedure Performance17_Belfield, Alma G.15_AGBELFI@TWA.COM31_Mon, 31 Jul 2000 10:44:46 -0500463_iso-8859-1 Leon, Do you see similar savings in IMS applications as for CICS applications?
-----Original Message----- From: leon@CA.IBM.COM [mailto:leon@CA.IBM.COM] Sent: Wednesday, July 26, 2000 10:26 AM To: DB2-L@RYCI.COM Subject: Re: Stored Procedure Performance
This is a summary of the thoughts on the stored procedures subject from some of the IBM brightest (no, it is not me, I don't pretend to be in that category ;-) ): [...]
2307 133 37_Re: DDF performance problem in DB2 V413_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 31 Jul 2000 10:46:54 -0500456_US-ASCII Please disregard prior post, reopt(vars) is not available in V4. Sorry Kurt
>>> xdbjmsh@HOTMAIL.COM 07/28/00 05:10AM >>> Hi all , This is what I findings after I post DB2 V4 Performance problem , days ago.
After Migration to DB2 V4 , at same time DB2 connect V 5.2 was applied ( or updated ?) with new FIXPACK (?) and rebinded. After that ,I met severe SIO in DB2 V4 especially on DDF thread that submitted through DB2 connect. [...]
2441 53 42_Re: Enforcing uniqueness on partial column14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Mon, 31 Jul 2000 11:00:08 -0500319_iso-8859-1 As mentioned below an INSERT trigger could be coded to keep the "redundant" column in sync. Keep in mind, however, that when running the LOAD utility on the table none of triggers will not fire. LOAD ignores triggers. Therefore, you will either need to:
1) completely avoid the LOAD utility, or; [...]
2495 29 19_Performance Figures19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 31 Jul 2000 10:53:34 -0500355_iso-8859-1 Hi all and TIA, Does anyone have any performance figures, or know where to find any, on INSERT and UPDATE to the bufferpool and UPDATE misses? I thought sure I saw something in one of the older Redbooks but can't get a hit. I know the figures will vary based on machine type, speed, and I/O subsystem, I'm just looking for approx. values. [...]
2525 30 47_Re: C++ main pgm, no DB2 calls C++ pgms with DB12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 31 Jul 2000 11:06:00 -0400582_- Have you tried just compiling and linking the program without the Precompile and BIND? You should still be able to call it from DSN and use the PLAN that contains the DB2 programs.
No warrantee included.
>>> DB2-L@RYCI.COM@inter2 07/31/00 09:58AM >>> DB2 v5 MVS
We have a group of developers that are working in C++. They are taking the approach of using a main program that calls other programs to perform work. Our main progam has no DB2 in it, but the called programs do. As you would expect there is an empty DBRM generated from the main program and [...]
2556 59 16_Re: QMF question13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Mon, 31 Jul 2000 11:07:51 -0500374_iso-8859-1 In the past to get around this type of situation I've setup a second "dummy" query that just prints what you want the "empty" report to look like (ex - "select 'total rows 0' from sysibm.sysdummy1"), and then execute this query if the "real" query returned 0 rows (identified by "DSQAO_NUM_FETCHED"). I would run a QMF proc that looks something like this... [...]
2616 84 42_Re: Enforcing uniqueness on partial column12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 31 Jul 2000 19:45:07 +0200575_x-user-defined Hi, First - I guess you don't mean "Keep in mind, however, that when running the LOAD utility on the table none of triggers will not fire. " but you mean "Keep in mind, however, that when running the LOAD utility on the table none of triggers will fire. " Second - for LOAD utility, if you specify manually the columns and positions then you can use a new column for the "substr(col,1,4)" by defining its' position correctly: e.g.: LOAD ..... (col1 char(8) pos(1:8), col2 char(4) pos(1:4) .....) etc. This works fine. If my memory serves me right then in [...]
2701 31 16_Conflicting UOWs15_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Mon, 31 Jul 2000 13:08:52 -0400330_us-ascii I am looking to write an exit for a vendor product, in which I will have to code DB2 Inserts and Deletes. The vendor product also does inserts, updates and deletes to those very same tables, but in a different TCB. The vendor product also updates different DB2 tables in the same TCB where my exit is to be invoked. [...]
2733 87 14_R: DB2 Locking17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM31_Mon, 31 Jul 2000 10:20:01 -0700447_us-ascii
I have personally never used the LOCK TABLE statement in a batch job. Would you insert the LOCK TABLE... statement just before the RUN PROGRAM... statement in your SYSTSPRT DD portion of the batch job.
---------------------- Forwarded by Charles Jambrosic/CSI on 07/31/2000 10:15 AM ---------------------------
Fiorese Giampaolo on 07/28/2000 02:29:06 PM [...]
2821 28 26_Help with ASSEMBLER to DB217_Bruzdzinski, Mike24_MIKE.BRUZDZINSKI@SSA.GOV31_Mon, 31 Jul 2000 13:08:02 -0400594_iso-8859-1 We have an existing ASSEMBLER application system that will need to call DB2 (OS/390).
We are running Version 5.
Does anyone have some sample code we can borrow/look at ?
Also are there any 'gotchas' we should be aware of ?
Thanks in advance
Michael Bruzdzinski Social Security Administration
<<...>>
================================================ 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.
2850 59 23_Re: Performance Figures20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 31 Jul 2000 14:15:26 -0400478_us-ascii Rick
Tim Lenahan's IDUG presentation from 1999 has rough estimation on number of instructions needed for various SQLs. I too have some numbers of my own experiments. I have to search my folders for this, once I get it I will e-mail you along with SRM value of my m/c.
-Venkat
-----Original Message----- From: DAVIS, RICK (SBCSI) [SMTP:RD8246@MOMAIL.SBC.COM] Sent: Monday, July 31, 2000 11:54 AM To: DB2-L@RYCI.COM Subject: Performance Figures [...]
2910 227 30_Re: Help with ASSEMBLER to DB215_Toine Michielse18_vndobtm@US.IBM.COM31_Mon, 31 Jul 2000 20:21:44 +0100598_us-ascii
Bruce,
Here's an extremely simple sample... Ask any questions you like.
Regards,
Toine Michielse (See attached file: Russia01.asm)
"Bruzdzinski, Mike" @RYCI.COM> on 07/31/2000 06:08:02 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Help with ASSEMBLER to DB2
We have an existing ASSEMBLER application system that will need to call DB2 (OS/390). [...]
3138 69 30_Re: Help with ASSEMBLER to DB220_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 31 Jul 2000 14:44:37 -0400422_us-ascii Here is one. - YREGS STRG CSECT SAVE (14,12) BALR R10,0 USING *,R10 ST R13,SA+4 LA R13,SA ST R13,SA+8 CATSECT LA R4,CAAREA USING CA,R4 LA R9,DAAREA USING SQLDSECT,R9 EXEC SQL SELECT X ..... BCT R7,CATSECT RETURN1 L R13,SA+4 RETURN (14,12) LTORG SA DS 18F DAAREA DS CL600 SQLCA AREA (ALLOW ROOM TO GROW) CAAREA DS CL200 SQLCA AREA (ALLOW ROOM TO GROW) CA DSECT DSECT FOR SQLCA EXEC SQL INCLUDE SQLCA END STRG [...]
3208 58 20_Re: Conflicting UOWs20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 31 Jul 2000 15:27:42 -0400343_us-ascii Unit of work in other TCB is not a problem. If you are using RRSAF or CAF then create another thread and you can do rollback and updates without affecting the first TCB.
Unit of work in the same TCB could be little bit tricky. Try SAVEPOINT, which is a new option in V6 with APAR PQ30439. There is a redbook on SAVEPOINT. [...]
3267 29 48_New tool for monitoring and managing DB2 Connect0_15_leon@CA.IBM.COM31_Mon, 31 Jul 2000 15:36:55 -0400618_us-ascii Many of you on this list are heavy users of the DB2 Connect products. Most of you have it deployed for mission crytical applications so I don't have to explain the value and the need for operational management and monitoring of your DB2 Connect installation. While DB2 Connect product itself provides Control Center as well as integration with the Windows NT/2000 Performance Monitor for operational performance management there is still a need for more comprehensive approach especialy in the area of integration with systems management frameworks from BMC Patrol, Tivoli, CA Unicenter and HP OpenView. [...]
3297 67 24_DB2 Call Attach Facility0_23_pjackson@SUMMITBANK.COM31_Mon, 31 Jul 2000 15:57:44 -0000627_us-ascii Hello,
I am looking for help in understanding the different modules in the Call Attach facility.
We are attempting to use ENDEVOR for DB2 against our Version 6 subsystem and are receiving the following:
BC1PDBFP: D2B0039I QUALIFIERS, CATALOG:SYSIBM ; FOOTPRINT: EDB2 BC1PHLI2: D2C0004E CAF ERROR R15=00000008 R0=00C10831 BC1PHLI2: CALL=OPEN SUBSYSTEM=DBT3 PLAN=BC1PDBFP D2B0040E SQLCA SQLCODE = -923; (21A PREP CURS2 ) SQLERRMC = SQLERRD = 0 0 0 0 0 SQLWARN = . . . . . . . . . BC1PDBF2: D2C0009C SQL CALL FAILED ERROR SQLCODE = (-0923) PLAN = DBRM = K281565 CALL = PACKGET RETURN AND REASON [...]
3365 17 23_Re: Performance Figures13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Mon, 31 Jul 2000 14:49:01 -0500425_- If anybody knows of a good guide to judging the cost of various DB2 queries, could you register the link at:
http://dmoz.org/Computers/Software/Databases/IBM_DB2/
-HJC
================================================ 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.
3383 109 28_Re: DB2 Call Attach Facility20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 31 Jul 2000 16:18:35 -0400405_iso-8859-1 How does Endevor works? Does it link-edit at every level of migration with correct library or it just moves once link-edited load module to your production? If it is the second case, re-linking may help.
-----Original Message----- From: pjackson@SUMMITBANK.COM [SMTP:pjackson@SUMMITBANK.COM] Sent: Monday, July 31, 2000 11:58 AM To: DB2-L@RYCI.COM Subject: DB2 Call Attach Facility [...]
3493 35 47_Re: C++ main pgm, no DB2 calls C++ pgms with DB13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 31 Jul 2000 16:24:25 -0400318_iso-8859-1 Are you Binding a plan and package for your C++ main program? Is that because you're adhering to company standards? If not, with the TSO attach, as you mentioned you're using, you can supply a different plan name than the program name. You simply supply the Plan(xxxx) parameter on your Run statement. [...]
3529 51 34_(Fwd) (Fwd) Re: LX, NSYSLX - Day 226_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Mon, 31 Jul 2000 17:56:30 -0500525_- ------- Forwarded message follows ------- From: "Edward(Ed) J. Finnell, III " Organization: Seebeck Computer Center To: db2-l@ryci.cim Date sent: Mon, 31 Jul 2000 17:55:15 -0500 Subject: (Fwd) Re: LX, NSYSLX - Day 2 Priority: normal
FYI...from IBM-Main. ------- Forwarded message follows ------- Date sent: Mon, 31 Jul 2000 18:39:15 -0400 Send reply to: IBM Mainframe Discussion List From: gad@US.IBM.COM Subject: Re: LX, NSYSLX - Day 2 To: IBM-MAIN@BAMA.UA.EDU [...]
3581 24 56_Table has an imcomplete table definition..What is wrong?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Mon, 31 Jul 2000 20:59:51 EDT295_- Hi list, I created a tablespace and the associated table. I tried to load the table and received the following: DSNU305I - DSNURWI - TABLE HAS AN INCOMPLETE TABLE DEFINITION I issued a start DB SPACENAM(tablespace) ACCESS(FORCE) and I still could not load my data. What I am doing wrong? [...]
3606 40 60_Re: Table has an imcomplete table definition..What is wrong?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 31 Jul 2000 21:23:07 -0400412_iso-8859-1 Hello again Carlton,
Usually this is caused by the absence of some other object that the table definition requires. If someone put a gun to my glass of beer and made me guess, I'd say you probably created a table with a primary key clause and didn't create the Unique Index required to enforce that primary key. This is a sample scenario which can cause the Incomplete definition message. [...]
3647 84 60_Re: Table has an imcomplete table definition..What is wrong?0_29_Greg.Palgrave@BANKWEST.COM.AU30_Tue, 1 Aug 2000 09:24:00 +0800388_us-ascii A clear case of RTFM.... :)
DSNU305I csect-name - TABLE=table-name HAS AN INCOMPLETE TABLE DEFINITION Explanation: Table 'table-name' does not have an index defined to enforce the uniqueness of its primary key.
Check the details in the Messages & Codes manual.
You specified a PRIMARY KEY on the table, but you have not created the corresponding index. [...]
3732 87 19_Re: LOCKPART clause7_Sanjeev21_Sanjeev@INTERRAIT.COM30_Tue, 1 Aug 2000 10:08:22 +0530612_iso-8859-1 Hi Venkat, Nice set of new informations again from you regarding how the intent lock is managed depending on the LOCKPART parameters.What i described was more related to how the lock escalation takes place depending on the LOCKPART clause and what you described is how the intent lock is taken and then converted to the tablespace/partition lock in case of the lock escalation. I still repeat the same thing, if you can count (depending on your application design) the approximate total number of locks which may be taken in case of the partition tablespace starting from page/row locks and then [...]