1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2001, week 4
2 57 49_PROVIDE UDF (USER DEFINE TUNCTION) SAMPLE PROGRAM19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW31_Wed, 23 May 2001 02:43:40 +0800287_big5 DEAL ALL : I use OS/390 and DB2 v6 environmet , and try to UDF (user define function) can someone provide sample program (use COBOL language) for client and stored procedure because DB2 application programming and sql guide book have no provide sample program
thank S .Y TANG
60 27 20_Test - Please delete11_Alfred Moos21_moos@FH-HEIDELBERG.DE31_Tue, 22 May 2001 08:26:47 +020039_iso-8859-1 Test, please delete.
88 56 47_Re: One more : SQL Performance Problem - Solved13_Patric Becker25_Patric_Becker@SIS-WEST.DE31_Tue, 22 May 2001 01:11:39 -0500334_ISO-8859-1 Thanks to everyone who posted an idea to solve the performance problem. I tried all the solutions and the following SQL performs best (so that´s why I don´t post all the statistics, because I think it´s not necessary any more).
Regards
Patric
The problem seems to be solved by the following SQL : [...]
145 16 25_Re: DSNT212I BIND PACKAGE13_Thomas Schulz20_thomas.schulz@SVI.DE31_Tue, 22 May 2001 01:59:03 -0500436_- I think we solved th problem.
TLV is the owner off the tables. We defined TLV in RACF as User with permit *. We did add USER=TLV to the Jobcard in the JCL. Bind package was successfull.
================================================ 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.
162 73 30_Re: DB2 V6 & Oracle Gateway V411_Hayden, Lee18_Lee_Hayden@CSX.COM31_Tue, 22 May 2001 08:11:22 -0400552_iso-8859-1 Andy,
We are using
"Oracle Transparent Gateway for DB2 on MVS: Release 4.0.1.1.1"
on DB2 V6 @ 0010 on OS/390 2.9 in test and production. Mostly for DB2 to Oracle Replication.
-----Original Message----- From: Andy Hunt [mailto:Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK] Sent: Monday, May 21, 2001 5:13 AM Subject: DB2 V6 & Oracle Gateway V4
Hi, Is anybody out there using Oracle Gateway 4.0.1.1.0 (I think I've got the right number of maintenance levels there) to access OS390 DB2 V6 ? [...]
236 198 21_Re: Design Guidelines15_MAHSOUN, KHALID29_kmahsoun@SAUDIAIRLINES.COM.SA31_Tue, 22 May 2001 15:08:15 +0300580_ISO-8859-1
> -----Original Message----- > From: Cianci, Nick [SMTP:Nick.Cianci@TEAM.TELSTRA.COM] > Sent: 22 May, 2001 04:01 Õ > To: DB2-L@RYCI.COM > Subject: Re: Design Guidelines > > Thanks Robert! > > ... and above all thanks Chuck, for your contribution to DB2 over the > years. > If there was a DB2 Hall of Fame, you'd be one of the people I'd vote to > have > in there! > > Cheers, > Nick Cianci > DB2 DBA - CCRI Project > 5th Floor (South) 484 StKilda Rd MELBOURNE 3004 > * (+613) 9865-8354 > (+61) 0408-64 06 01 > * MailTo:Nick.Cianci@team.telstra.com [...]
435 93 37_Re: One more : SQL Performace Problem18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Tue, 22 May 2001 18:23:18 +0500544_- > Terry > Though this problem for Patric is solved now, I am curious about how you > could conclude that TABLEA would be the last table in the join sequence?. > > > Thank you very much > Regards > Nagaraj > > -----Original Message----- > From: Terry Purcell [SMTP:Terry_Purcell@YLASSOC.COM] > Sent: Monday, May 21, 2001 6:07 PM > To: DB2-L@RYCI.COM > Subject: Re: One more : SQL Performace Problem > > Patric, > > You may have got a poor response from Nagaraj's query due to a poor > table > join sequence, and it may actually introduce [...]
529 53 54_Real World SQL: Advanced Coding and Performance Tuning12_Susan Lawson24_susan_lawson@YLASSOC.COM31_Tue, 22 May 2001 08:53:55 -0500405_iso-8859-1 You have seen him on DB2-L - now see him in action! SQL expert Terry Purcell is starting his US/Canada summer tour in June.
Real World SQL: Advanced Coding and Performance Tuning - By Terry Purcell, YL&A
June 11-12 Dallas, TX June 13-14 Little Rock, AK June 28-29 Los Angeles, CA July 12-13 Toronto, Canada July 23-24 Pittsburgh, PA July 25-26 Newark, NJ Aug 23-24 Tampa, FL [...]
583 105 58_Re: Real World SQL: Advanced Coding and Performance Tuning12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Tue, 22 May 2001 10:09:26 -0400455_iso-8859-1 They say New England is lovely in the summer (got to be better than Tampa) - any plans for "the tour" to head up this way before it gets too cold?
Regards,
Gregg Sawyer
"Susan Lawson" @RYCI.COM> on 05/22/2001 09:53:55 AM
Please respond to "DB2 Data Base Discussion List"
Sent by: "DB2 Data Base Discussion List" [...]
689 34 53_Re: PROVIDE UDF (USER DEFINE TUNCTION) SAMPLE PROGRAM14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Tue, 22 May 2001 09:19:21 -0500399_big5 Look in the file SAMPLIB that installs with DB2. It has samples of everything, and many UDFs. Check with you DBA for exact name in your system. Regards, Richard
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of ´ö½Ò ªø Sent: Tuesday, May 22, 2001 1:44 PM To: DB2-L@RYCI.COM Subject: PROVIDE UDF (USER DEFINE TUNCTION) SAMPLE PROGRAM [...]
724 30 40_DB2 OS/390 Hardware Compression Overhead14_Michael Vanner19_mvanner@CANTIRE.COM31_Tue, 22 May 2001 10:24:18 -0400395_us-ascii Every year or so I encounter a "consultant" that suggests to improve performance and reduce CPU usage we should stop using compression. Everything I've been told on performance courses and seminars at IDUG was that for large tables compression is desirable from a dasd and resource usage (better bang for your bufferpool, since data is compressed/expanded outside the bufferpool). [...]
755 84 44_Re: DB2 OS/390 Hardware Compression Overhead13_Adrian Savory27_Adrian.Savory@WORKTHING.COM31_Tue, 22 May 2001 15:40:52 +0100474_iso-8859-1 Well this consultant begs to differ! In the right circumstances the use of compression is an excellent way to get more data in your bufferpools and reduce I/O overhead (which in turn can reduce CPU). Two ROTs that I use to determine whether to use compression:
1. Don't compress volatile data. The cost of inserts and updates can be prohibitive. 2. Don't compress data that is scanned. Decompressing all rows in a large table can be expensive on CPU. [...]
840 24 44_Re: DB2 OS/390 Hardware Compression Overhead16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Tue, 22 May 2001 10:44:43 -0400474_us-ascii Michael,
I have seen IO bound processes that definitely have had elapsed time improvements by using compression. We do a lot of compression at this company, and we use a charge-back process to applications for their cpu consumption. The managers complain very loudly when anything changes that affects the cpu consumption of their transactions/processes. No noticeable cpu consumption has been a result of compression, at least that we have identified. [...]
865 60 44_Re: DB2 OS/390 Hardware Compression Overhead16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 22 May 2001 10:44:26 -0400369_iso-8859-1 Michael,
I do not have the exact numbers handy. However I have done this study in the past. In every case, there was no significant CPU difference. In a few cases, the reduced CPU requirement for driving I/O actually reduced the total CPU need.
Of course, this only applies if you have the hardware compression assist on your CEC. [...]
926 33 26_MQ And DB2 V7.1 running XA14_Timothy Miller17_njironman@USA.NET29_Tue, 22 May 2001 10:51:57 EDT323_US-ASCII Hello All,
I am trying to Call DB2 UDB V7.1 from MQ using XA interface, I am getting an error saying that the AX libraries could not be load.
I have given the user mqm connect authority and add "MQ" to the DBM CFG for TP_MON_NAME, does anyone have this working?
Any help would be great!! [...]
960 42 44_Re: DB2 OS/390 Hardware Compression Overhead10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 22 May 2001 16:53:09 +0200412_us-ascii There are many topics dealing with DB2 HW compression (even in the list), a redbook (DB2 for OS/390 and data
compression) and many proceedings (www.share.org).
Someone says that it's good, someone else says that it's bad, someone says you've a increase in CPU usage of
70000%, someone else (IBM :-)) says that the increase is 0.000000001 nanopicofurlongsecond of CPU, the same [...]
1003 42 44_Re: DB2 OS/390 Hardware Compression Overhead13_Hanne Lyssand10_han@VPS.NO31_Tue, 22 May 2001 16:57:18 +0200544_us-ascii Hallo!
I have never done a exact study, but in me old company we had the same eksperiense both with IMS and DB2. We didn't get the expected raise in CPU and the elapsed time went down.
Last year I hade my first problem with compress in DB2. When i investegated it was not the compress it self, who gave me trouble, but the accesspath changed. I don't know if I hit a bug. The access path changed back when I revoke the compress. (I was a little bit angry because I hade argumented strongly for more use of compress, [...]
1046 27 44_Re: DB2 OS/390 Hardware Compression Overhead9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM31_Tue, 22 May 2001 16:00:39 +0100683_us-ascii Wotcha,
When compression was initially introduced in DB2/MVS Version 3, there was a Redbook that included some measurements of compression in different workloads. Its an oldie, but a goodie and its called DB2 Version 3 Performance Topics GG24-4284-00.
http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006 bb65f/5cc4541ad2f926c38525659d002a575e?OpenDocument
Stan Hoey Circle Computer Group UK
================================================ 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.
1074 44 53_Stored procedures and RRSAF - Authorization problems.17_Massimo Biancucci30_Massimo.Biancucci@T-SYSTEMS.IT31_Tue, 22 May 2001 16:57:36 +0100376_us-ascii What's the authorizations needed for a user from a client to run a SP with EXTERNAL_SECURITY flag = "Y" ?
If i try to run the SP, it's OK but I'm a SYSADM etc.
From the client I obtain a sqlcode -981 RC 00C12216. The problem, from the trace, is on the package (of the SP) allocation, it doesn't work an the WLM managed address space doesn't start. [...]
1119 188 45_Re: dynamic query performance problem with V617_Panicker, Lethika26_LPanicker@FSSA.STATE.IN.US31_Tue, 22 May 2001 10:46:39 -0500524_iso-8859-1 Hi Tina,
here is my error.........
The following error occured: [IBM][CLI Driver][DB2] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "recv". Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001 Unable to process Request. Try Again! If problem continues please contact system administrator! [...]
1308 36 29_Outstanding Job Opportunities10_Andy Stein22_jbak2009@AMERITECH.NET31_Mon, 21 May 2001 11:07:54 -0500672_us-ascii Hi Everyone, I apologize in advance for any inconvenience I may cause. My name is Andy Stein and I am a Technical Recruiter representing a premier software company. I am aggressively recruiting talented consultants and software pros experienced in DB2, Oracle and Informix on multiple platforms and operating systems. This recently formed new division, the Services Group will provide consulting and implementation services around their product line. We are primarily seeking consultants, architects and DBA's with extensive knowledge ofDB2 in an IBM Z/OS environment. Consultants will be based out of home offices when not traveling, and will report to the [...]
1345 60 33_Re: Outstanding Job Opportunities10_Ta, Khuong14_kta@COMSYS.COM31_Tue, 22 May 2001 13:48:47 -0400382_iso-8859-1 Andy - I am a recruiter too and I was thinking of sending an email out - but I didn't know if there would be any negative responses based on the mail-list "rules" of not soliciting. How has the response been?
Khuong Ta Technical Recruiter COMSYS ITS 800.926.6797 x3654 kta@comsys.com Please visit our website at: http://www.comsys.com [...]
1406 85 33_Re: Outstanding Job Opportunities18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 22 May 2001 14:09:46 -0400529_iso-8859-1 Well there hasn't been any responses to these 2 emails YET but I'm sure this last one will kick some off! :-) Come on folks, I thought we'd be reading some flames by now. :-)
--Steve....
Steve Whittaker DB2/DBA Progress Energy, Inc. Mail stop:OHS 10- Raleigh Email: stephen.whittaker@pgnmail.com Phone: (919) 546-7267
-----Original Message----- From: Ta, Khuong [mailto:kta@COMSYS.COM] Sent: Tuesday, May 22, 2001 1:49 PM To: DB2-L@RYCI.COM Subject: Re: Outstanding Job Opportunities [...]
1492 208 33_Re: Outstanding Job Opportunities23_McKinnon, Neal (Dallas)28_Neal.Dallas.McKinnon@FMR.COM31_Tue, 22 May 2001 14:12:49 -0400357_iso-8859-1 From the DB2-L WEB site....
List Topics
This list is intended for the discussion of IBM's DB2 family of Data Base Products and other products that support the design, development and maintenance of DB2 databases and systems. Related topics such as the function of a DB2 DBA, DB2 development standards and SQL are also welcome. [...]
1701 82 44_Re: DB2 OS/390 Hardware Compression Overhead13_Olson, Carlos14_COlson@QRS.COM31_Tue, 22 May 2001 11:16:24 -0700422_iso-8859-1 I just implemented hardware compression on a 75 million row 16 partition tablespace this last Thursday. I was able to get from 58 - 69% DB2 pages saved depending on the partition. I cut and pasted some stats (averages per SQL) from CA's Detector on a weekly program that did about 8 million fetches and updates to rows in this now compressed tablespace. The before and after compression numbers are below: [...]
1784 90 33_Re: Outstanding Job Opportunities15_Gary Fahrlander28_gary.fahrlander@ZURICHNA.COM31_Tue, 22 May 2001 13:21:19 -0500420_us-ascii I'm not a list manager but... the only rule is that you request direct responses to yourself. Kind of like if you had sent your message directly to jbak2009@ameritech.net instead of the list. Thanks for your cooperation.
"Ta, Khuong" @RYCI.COM> on 05/22/2001 12:48:47 PM
Please respond to DB2 Data Base Discussion List [...]
1875 16 12_Re: Settings11_Jeff Kalman15_jkalman@CSC.COM31_Tue, 22 May 2001 15:10:39 -0400409_us-ascii Hi everyone, I am on vacation for a week and would not like to receive any emails from the list. How can I change the settings to accomplish this?
TIA.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1892 115 44_Re: DB2 OS/390 Hardware Compression Overhead12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 22 May 2001 22:21:35 +0200296_iso-8859-1 Hi, In most cases I realized benefits from using compression in DB2. I've put numbers in the list, and if you'll search the arcives you'll find a lot about it. The very small increase in CPU is more then compensated by the reduction in elapsed times, BP/HP usage & I/O reduction. [...]
2008 16 47_Kimberlee Little/IT/SEARS is out of the office.10_Kim Little17_klittle@SEARS.COM31_Tue, 22 May 2001 15:06:43 -0500497_us-ascii I will be out of the office from 05/22/2001 until 05/29/2001.
I will respond to your message when I return. If an immediate response is necessary, please contact Pam Harris (PHARRI1) or the Logistics DB2 pager at 1-800-759-8888 PIN 7270526
================================================ 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.
2025 27 33_DB2 UDB Different Versions on AIX0_25_DBird@KEMPERINSURANCE.COM31_Tue, 22 May 2001 15:10:44 -0500368_us-ascii I have an AIX system with UDB v6 and V7 installed. I've migrated the DAS and an Instance to v7. They other instances I left at v6. I updated the file links on AIX to point to v7 instead of v6. The v7 instance works fine, I'm having trouble execute DB2 commands against the v6 instances. Whenever I execute a db2 command in one of the v6 instances I get: [...]
2053 76 37_Re: DB2 UDB Different Versions on AIX19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Tue, 22 May 2001 13:45:29 -0700316_- Sounds similar to a problem we posted a couple of weeks ago.
What we found was:
Both V6 and V7 installed. New instance created and converted to V7. DAS converted to V7. Developer instance left at V6. The AIX file link was created in /usr/lib/libdb2.a pointing to the V6 install path (libdb2.a). [...]
2130 18 16_Re: QMF Question14_William Poston21_william.poston@DB.COM31_Tue, 22 May 2001 15:52:14 -0600132_us-ascii How can I save a proc , form or query in QMF under another's users userid? Is there a QMF sysadm privilege?
2149 51 24_Re: QMF Question (Reply)0_28_michael.d.ockenfels@WCOM.COM31_Tue, 22 May 2001 16:14:15 -0500450_us-ascii You have to set your current sqlid to that user's ID first.
William Poston To: DB2-L@RYCI.COM Subject: Re: QMF Question
05/22/01 04:52 PM Please respond to DB2 Data Base Discussion List
How can I save a proc , form or query in QMF under another's users userid? Is there a QMF sysadm privilege?
2201 28 48_UDB DB2 Project Mgr +UDB DB2 Migration Tech Lead10_Ta, Khuong14_kta@COMSYS.COM31_Tue, 22 May 2001 17:39:05 -0400436_iso-8859-1 Hi All -
Based on my previous email - I would like to let you all know I have an opportunity about a UDB Migration effort going on. Its a long term contract 12-18 months, in a Sun (clustering) environment, and its in Northern Virginia. If you would be interested, I would be happy to provide you with more information (just email me - not the dist. list :-)) and we can go through all the "job recruiting" hoops! [...]
2230 41 16_Re: QMF Question10_Shery Hepp17_schepp@SRPNET.COM31_Tue, 22 May 2001 14:58:45 -0700435_iso-8859-1 William- you should be able to save it under your userid with the (share=yes option specified. They can them display it using your ownerid.objectname and then issue the save themselves. (at least it used to work that way- ) Good luck- hth
Shery
-----Original Message----- From: William Poston [mailto:william.poston@DB.COM] Sent: Tuesday, May 22, 2001 2:52 PM To: DB2-L@RYCI.COM Subject: Re: QMF Question [...]
2272 122 44_Re: DB2 OS/390 Hardware Compression Overhead10_Moden, Jim17_jim.moden@EDS.COM31_Tue, 22 May 2001 17:16:11 -0500450_iso-8859-1 Good afternoon everyone.
Here are some of the factors we believe should be analyzed when considering whether or not to use data compression in DB2 applications.
Does the CPU support hardware data compression? Hardware data compression is much more efficient than software emulation to support data compression. Increases in CPU overhead can be as high as 50% when software emulation is used to support data compression. [...]
2395 116 37_Re: One more : SQL Performace Problem13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 22 May 2001 17:15:36 -0500396_iso-8859-1 Nagaraj,
>From the solution I proposed below, the non-correlated subquery is executed first (as are all non-correlated subqueries unless transformed to a join). Therefore the join of TABLEB to itself will be performed and materialized; and the result set used to probe into TABLEA via CUSTNO. This assumes the V6 indexable non-correlated subquery feature (or V5 via APAR). [...]
2512 116 16_Re: QMF Question10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Tue, 22 May 2001 17:35:13 -0500430_iso-8859-1 William,
If you are sysadm, you can set your id to anyone else's id & do a simple save query as, save proc as name. Or if they (queries, etc.) already exist under someone else's id you can update them to be under any id you want them to belong to This is really handy when someone leaves and had a bunch of cool queries you don't want to lose. Do a draw of q.object_directory & check out the coll info..... [...]
2629 153 16_Re: QMF Question12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 22 May 2001 18:36:36 -0400558_US-ASCII You have several options. First Option uses secondary auth groups 1) Save your proc,query,from with SHARE=YES 2) run query SET CURRENT SQLID = 'newgroup' 3) List proc,form,query for shared userid. 4) Display each save proc,query,form 1 at a time and save it. It will now be owned by 'newgroup'
Second option requires update against QMF tables. This is more for an administrator who wants to change lots of procs, queries, and forms. Use SQL to update Q.OBJECT_DIRECTORY and set OWNER = 'newgroup' RESTRICTED = 'N' to make public [...]
2783 34 42_Repeatable Reads from DB2 CONNECT clients.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 22 May 2001 16:08:27 -0700432_iso-8859-1 Hi all, I've been watching the threads coming from clients via DB2 connect to my DB2/OS390. Most all have an isolation of RR. I'm assuming this is a default for most applications. We has a problem with a client's Brio job that held up a nightly production job because if its RR locks. Our users are really taking a liking to DB2 connect and I for see more problems with dynamic SQL causing problems with production. [...]
2818 21 40_Intermediate Commits in Stored Procedure8_K.Balaji19_K.Balaji@TARGET.COM31_Tue, 22 May 2001 19:35:20 -0500465_iso-8859-1 Hi all, I understand that IBM did not support intermediate commits in stored procedure on MVS platform and allowed application program to handle it. What I dont understand is that how can I issue an intermediate commit for a unit of work in store procedure. And how this is handled in mainframe client code as well as in then client call which comes thro NEON driver. Any help on this will be greatly appreciated. Regards Balaji Ph # (510) 727-3259 [...]
2840 227 45_Re: dynamic query performance problem with V615_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM31_Wed, 23 May 2001 12:09:18 +1000691_iso-8859-1 Lethika,
Some years back when our application was unstable I believe we used to get this message when our Gateway Server was down.
regards, Steve Mallett
> -----Original Message----- > From: Panicker, Lethika [SMTP:LPanicker@FSSA.STATE.IN.US] > Sent: Wednesday, May 23, 2001 1:47 AM > To: DB2-L@RYCI.COM > Subject: Re: dynamic query performance problem with V6 > > Hi Tina, > > here is my error......... > > > > The following error occured: [IBM][CLI Driver][DB2] SQL30081N A > communication error has been detected. Communication protocol being used: > "TCP/IP". Communication API being used: "SOCKETS". Location where the > error > was [...]
3068 47 32_Re: DB2 Connect and Windows 20000_15_leon@CA.IBM.COM31_Wed, 23 May 2001 00:56:05 -0400508_us-ascii DB2 Client Application Enabler (CAE) V6.1 and DB2 Run-Time Client V7.1 support Windows 2000.
Leon Katsnelson Product Manager, DB2 Application Development and DB2 Connect mailto:leon@ca.ibm.com
Kirk Hampton @RYCI.COM> on 05/16/2001 02:26:50 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: DB2 Connect and Windows 2000 [...]
3116 36 24_Stored Procedures in DB213_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Wed, 23 May 2001 10:18:48 +0500561_iso-8859-1 Hello list members,
We are doing a migration from Oracle to DB2 7.1 on AIX and are planning to migrate some of the triggers to stored procedures due to the limitations of BEFORE triggers in DB2. I had a query regarding the rights. I wanted to know if there is any specific authority to be given to execute in stored procedures in DB2 or is it that any user has a right to execute the stored procedure provided the proper authorities are available to the users for the tables used in the stored procedure. I would appreciate it if someone [...]
3153 217 30_Re: SQL Statement Optimization13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 23 May 2001 01:09:08 -0500446_iso-8859-1 Nick/Loren,
The UNION has actually split out the non-boolean term predicate: ( PAY_STATUS = 'E' OR ( PY_PAY_HEADER.ACCOUNT_ID = 0 AND PAY_STATUS = 'F' )) into separate boolean terms so that single index access could be achieved for these predicates (hence the need for the index). Non-boolean term predicates cannot match columns in a single index (but can screen), and can only match columns in a multi-index access path. [...]
3371 47 21_CPU Time for DB2 Load8_apkjha x18_apkjha@HOTMAIL.COM31_Wed, 23 May 2001 06:14:31 -0000402_- Hello List,
I am trying to make a DB2 (DB2 for OS/390 V6) load more efficient; my main focus is to reduce the cost (CPU time) rather then elapsed time.
The load scenario is as follows:
The table contains 240 partitions. Every day 5 partitions are loaded (replacing the oldest partitions using Load-replace on partition level; each partition contains approx. 900 000 record. [...]
3419 33 10_wait times18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Wed, 23 May 2001 12:19:54 +0500532_- Dear listers
I use Mainview monitor. In one of the traces I see that NOT ACCOUNTED wait time is very high (35 % of the elapsed time of the job). The elapsed time was about 4 hours The DBA investigated this and says that for the first two hours the program was not getting enough CPU, and the next two hours it was getting CPU but the DASD disconnect time was high because of cache misses. I thought the DASD disconnect time would reflect as I/O wait time in DB2 trace and not under NOT ACCOUNTED wait time. Can anyone [...]
3453 41 21_DB2 VSAM sizing limit14_Peacock Julian31_Julian_Peacock@LONDONELEC.CO.UK31_Wed, 23 May 2001 08:52:24 +0100570_iso-8859-1 Fellow DB2ers,
DB2 v5 (OS/390) possesses VSAM sizing limits, which are dependant upon such things as the number of partitions allocated, and whether the object is defined as being large. How do I determine whether an object is close to broaching the DB2 VSAM limit. For instance, if I have a non-large 60 partitioned object (therefore, has a max size of 1 GB), what statistics do I use to formulate its size in relation to this threshold? Do I use the number of active pages multiplied by 4K, or do I use the 'Data Set List Utility' ISPF panel to [...]
3495 140 52_Re: Number of checkpoints [it was: DSNR035I Message]0_20_vpacheco@AMADEUS.NET31_Wed, 23 May 2001 10:00:29 +0200564_us-ascii Thanks for the replies I had to my original question.
I agree that not COMMIT frequently is very dangerous and might have nasty impacts like the one we had. Since this warning message - DSNR035I - was seen in our site (must confess that it come with SAP), we have been alerting the Developers for the risk it represents. So far I did not manage to make my arguments to count more than the pressure they have to deliver their program. It might be different now that it impacted the availability of a Production environment... I waiting to see. [...]
3636 66 14_Re: wait times16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 23 May 2001 13:51:16 +0530551_- Nagaraj,
Looks to me as well it will not go to 'NOT ACCOUNTED'. I can't tell for sure that it will go to I/O wait time but it has no where else to go. Not accounted time is basically: 1) MVS paging 2) Processor wait time 3) On DB2 requester systems,the amount of time waiting for requests to be |returned from either VTAM or TCP/IP,including time spent on the network and time spent handling the request in the target or server systems. 4)Time spent waiting for parallel tasks to complete (when query parallelism is |used for the query) [...]
3703 73 44_Re: DB2 OS/390 Hardware Compression Overhead11_Tiscali LAN27_adriancollett@TISCALINET.IT31_Wed, 23 May 2001 10:26:36 +0200459_iso-8859-1 Michael,
There is a redbook on Data Compression in DB2.
Chapter 4.3 highlights several processing scenarios and the effects off compression.
Some of them demonstrate that turning on compression TRIPLES CPU consumption. Some of them demonstrate that turning on compression has NO EFFECT on CPU consumption.
I have performed similar "real world" benchmarks and have come to exactly the same conclusions - IT DEPENDS. [...]
3777 46 14_Re: wait times10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 23 May 2001 10:35:18 +0200340_us-ascii Yes the I/O wait time is reflected in class 3 wait counters (in-DB2 wait).
Take a look at class 2 (in DB2 time): if class 2 elapsed time is high but class 2 TCB time and class 3 wait time are low, examine the NOT ACCOUNT field . If this field is high it means that wait time is not occurring in DB2 but in the S390 OS. [...]
3824 44 19_SAP & DB2 on OS/39011_Klaas Brant14_KBrant@KBCE.NL31_Wed, 23 May 2001 11:04:24 +0200586_iso-8859-1 KBCE is looking for SAP users who use DB2 for OS/390 as their database. This is not a sales pitch, we want to get into discussion with SAP users.
We get the impression that the large amount of objects is giving the people responsible for DB2 a hard time to get this environment under control. How to do backup/reorg/recovery/resize/runstats/monitor growth etc.? We created, on demand of one of our customers, a simple but effective tool to do these DBA tasks in an automated or semi-automated fashion. It was build with a SAP environment in mind and has a lot of [...]
3869 78 14_Re: wait times18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Wed, 23 May 2001 14:33:09 +0500500_- Thanks Max for your reply. I will have to go by my DBAs word on the wait being attributed to CPU not being available. I saw quite a lot of page-ins for I/O in that bufferpool (but I was not sure if paging was to expanded storage or to disk, BTW how to get that information from Mainview MVS monitor?) and I told him that it could be the cause. But he says there was not much of paging and there was a contention for CPU. 3390-3 SEQCACHE is set to YES here. You said that it cache misses could [...]
3948 55 53_Re: PROVIDE UDF (USER DEFINE TUNCTION) SAMPLE PROGRAM19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW31_Thu, 24 May 2001 05:52:16 +0800525_big5 Thank You I know dsn610.sdsnsamp have many sample udf program , but coding program use c and c++ language , because I use COBOL language , so I don't understand sample program . Can You provide cobol sample program or tell me someone have experience e-mail address thank you S Y TANG ----- Original Message ----- From: Richard Yevich Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, May 22, 2001 10:19 PM Subject: Re: PROVIDE UDF (USER DEFINE TUNCTION) SAMPLE PROGRAM [...]
4004 133 16_Re: QMF Question0_27_jim.leask@RS-COMPONENTS.COM31_Wed, 23 May 2001 10:37:46 +0100642_iso-8859-1 Whenever I have done this I have also updated q.object_data and for completeness q.object_remarks.
Jim.
-----Original Message----- From: Missy Case [mailto:Missy.Case@FIRSTDATACORP.COM] Sent: 22 May 2001 23:35 To: DB2-L@RYCI.COM Subject: Re: QMF Question
William,
If you are sysadm, you can set your id to anyone else's id & do a simple save query as, save proc as name. Or if they (queries, etc.) already exist under someone else's id you can update them to be under any id you want them to belong to This is really handy when someone leaves and had a bunch of cool queries you don't want [...]
4138 39 14_Re: wait times10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 23 May 2001 11:40:01 +0200360_us-ascii If page-ins/(monitor period time) is > 100 /sec it may be because there's a lack of storage.
You can see the causes of the delays of that job while it's running from Mainview for MVS (if you have it) >> CMF monitor
online >> JOBS >>> (select your batch job) >>> delay reasons. Here are listed the main reasons for delays: CPU, ENQ, [...]
4178 38 44_Re: DB2 OS/390 Hardware Compression Overhead13_Patric Becker25_Patric_Becker@SIS-WEST.DE31_Wed, 23 May 2001 04:18:51 -0500528_ISO-8859-1 Michael,
in our shop we use COMPRESS YES for Tablespaces > 100 Pages, and there is no negative effect known because of COMPRESS YES. In some cases, we saw a reduction of 90% of DASD space for tablespaces, but this should be the exceptional case. Beacause of compression, DB2 has to do less I/Os and you´ve to consider a decrease of Bufferpool / Hiperpool usage. There is also a decrease of used space for image copies. Furthermore you´ll possibly see a small reduction of CPU usage for GETPAGEs and I/Os. [...]
4217 26 32_A method with Identity and rowid14_Craig McKellar26_craig.mckellar@BIGPOND.COM31_Wed, 23 May 2001 22:13:08 +1000596_us-ascii There was an email posted that was dealing with getting duplicate rows (-803) on a column defined as identity. I was interested in the problem as we are using identity for generating primary keys and for partitioning. I have found the following approach best addresses some of the concerns. 1.Always define the column as generate by default. This way allows for loads and table changes to keep the current values. 2. If the column is for partitioning only, create a view of the table without the identitiy( or rowid) column. This way your applications will never see the column and [...]
4244 67 46_Re: Repeatable Reads from DB2 CONNECT clients.12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 23 May 2001 05:25:35 -0700644_us-ascii Cliff, Its coming from settings in DB2CLI.INI on the client machine (or the server if you're using a gateway). There's a field called TXNISOLATION. TXNISOLATION=1 or TXNISOLATION=2 will do what you want.
Another way to set the field is to go into the Client Configuration Assistant and go to Properties for your connection name. Then Settings. Then go to the TRANSACTION button. At the bottom of the various TRANSACTION fields will be TXNISOLATION field. It'll show read uncommitted, read committed, repeatable read, etc. Set it to either Read Committed (CS) or Read UNCOMMITTED (UR) and your problems with RR will [...]
4312 22 17_from os/390 to NT17_Bartolucci Silvia25_S.Bartolucci@FONDIARIA.IT31_Wed, 23 May 2001 14:27:18 +0200256_- Can anyone tell me a way to see from a COBOL program running on OS/390 a database on NT ?? I have on OS/390 DB2 v5 and on NT different kinds of database. I'd like to find a way from COBOL to read a database on a server NT.
Bye Silvia [...]
4335 18 57_Re: Stored procedures and RRSAF - Authorization problems.12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Wed, 23 May 2001 07:22:26 -0500434_- The statement: "The RACF ID and group name that you select must have authority to run the Recoverable Resource Manager attachment facility (RRSAF) application programs."
Means to me that you will need at least a RACF profile in Class DSNR. EX. for subsytem DB2P, you will need a profile of DB2P.RRSAF and the RACF ID or group will need read access to that profile. This of course is assuming you have Class DSNR active. [...]
4354 71 25_Re: DB2 VSAM sizing limit15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 23 May 2001 07:42:19 -0500356_iso-8859-1 Hi, Julian, In the past someone on the list mentioned using the high-used RBA as a method for determining how "full" a tablespace was. I would think that using the high-allocated RBA would be useful for determining whether you are close to the limit or not. You get this by executing a LISTCAT command against the underlying VSAM data set. [...]
4426 39 21_Re: from os/390 to NT12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 23 May 2001 05:45:46 -0700524_us-ascii Set up the connectivity from your OS/390 system to the NT database via the various DB2 tables (redbooks or admin guide has details) and just do a CONNECT TO DATABASE SQL statement. --- Bartolucci Silvia wrote: > Can anyone tell me a way to see from a COBOL program running on > OS/390 a > database on NT ?? > I have on OS/390 DB2 v5 and on NT different kinds of database. > I'd like to find a way from COBOL to read a database on a server NT. > > > Bye Silvia > > Silvia Bartolucci [...]
4466 62 28_Re: Stored Procedures in DB212_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 23 May 2001 05:46:38 -0700540_us-ascii You need to grant EXECUTE on the Stored procedure just like you'd grant execute on a package. --- "Swamy, Ritesh" wrote: > Hello list members, > > We are doing a migration from Oracle to DB2 7.1 on AIX and are > planning to > migrate some of the triggers to stored procedures due to the > limitations of > BEFORE triggers in DB2. I had a query regarding the rights. I wanted > to know > if there is any specific authority to be given to execute in stored > procedures in DB2 or is it that any [...]
4529 68 21_Re: from os/390 to NT15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Wed, 23 May 2001 14:54:14 +0200406_iso-8859-1 Just my two cents..
If this is possible you should do a remote display or something using control center or DB2 look, this would require some connection with tehe NT. Maybe an FTP session could help.. But to me it sounds like you need an ETL kind of software. This kind of software ususally resides on UNIX or NT. Using this on NT you'll be able to get some data towards the OS/390. [...]
4598 58 23_Re: SAP & DB2 on OS/39014_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Wed, 23 May 2001 07:55:36 -0500474_iso-8859-1 TTX in Chicago has SAP on DB2 OS/390. I know of others as well. But, would like to take this off-line. Please call me at 312-984-3890.
-----Original Message----- From: Klaas Brant [mailto:KBrant@KBCE.NL] Sent: Wednesday, May 23, 2001 4:04 AM To: DB2-L@RYCI.COM Subject: SAP & DB2 on OS/390
KBCE is looking for SAP users who use DB2 for OS/390 as their database. This is not a sales pitch, we want to get into discussion with SAP users. [...]
4657 31 44_Re: DB2 OS/390 Hardware Compression Overhead14_Michael Vanner19_mvanner@CANTIRE.COM31_Wed, 23 May 2001 09:01:06 -0400554_us-ascii Thanks for the responses to my post on compression.
The environment is OS/390 2.6 going to 2.10 (Q3-2001), currently running DB2 V5.1 going to V7.1 in Q1-2002 (production). The current processors are twin R54s in a sysplex. The DB2 system is data sharing (one on each cpc).
The application based upon what I can ascertain will be batch with a large number of random reads (one part of the application includes 800,000 selects under cursor for a 50,000,000 row table). There will be occasional on-line (client-server) updates. [...]
4689 18 36_Re: A method with Identity and rowid15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 23 May 2001 08:00:39 -0500385_- Craig
>2. If the column is for partitioning only, create a view of the table >without the identitiy( or rowid) column. This way your applications will >never see the column and cannot update it without going to the base >table.
I don't understand, why this method can only by used for partitioning. I think I can use it for any table with identity column as well. [...]
4708 28 36_Re: A method with Identity and rowid14_Craig McKellar26_craig.mckellar@BIGPOND.COM31_Thu, 24 May 2001 00:03:58 +1000557_us-ascii Youre right Walter, you could but the problem is if the application references the column later then maybe a view would not help.
Walter Janissen wrote:
> Craig > > >2. If the column is for partitioning only, create a view of the table > >without the identitiy( or rowid) column. This way your applications will > >never see the column and cannot update it without going to the base > >table. > > I don't understand, why this method can only by used for partitioning. I > think I can use it for any table with identity column as [...]
4737 21 34_DB2 Addressing beyond 2Gigs memory12_Brian Picard26_brian_picard@ALTAVISTA.COM31_Wed, 23 May 2001 08:32:16 -0500540_- Hi, This is in reference to Akira Shibamanya's IDUG presentation where he discussed the capabilities of DB2 addressing beyond the 2 GB. In the 64 bit Z architecture, if we move virtual pools to dataspaces, is it possible to byte address the contents in the buffer?. How does the data xfr take place if it is not byte addressable?. Currently data has to be moved from ESTOR to CSTOR in order to address. How does Z OS handle this?. Another curious question is, as we have 16 Mb line, do we also have a 2GB line and anything above the [...]
4759 21 32_VIRUS in response to DB2-L posts16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 23 May 2001 10:23:38 -0400466_iso-8859-1 Beware! I have been sent at least three virus attempts from someone alleging to be Kent Collins in response to posts here. Be cautious.
regards,
eric pearson NS ITO Database Support
================================================ 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.
4781 104 36_Re: VIRUS in response to DB2-L posts14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 23 May 2001 07:47:21 -0700422_iso-8859-1 Eric, Thanks for letting us know. We have antivirus software installed and I will followup on this. Phil
-----Original Message----- From: Pearson, Eric L, To: DB2-L@RYCI.COM Sent: 5/23/01 7:23 AM Subject: VIRUS in response to DB2-L posts
Beware! I have been sent at least three virus attempts from someone alleging to be Kent Collins in response to posts here. Be cautious. [...]
4886 58 36_Re: VIRUS in response to DB2-L posts18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Wed, 23 May 2001 11:10:59 -0400499_iso-8859-1 Thanks..I wondered who this guy was..I got 2 attempts by him but our anti-virus software caught it and kicked it out...
Steve Whittaker DB2/DBA Progress Energy, Inc. Mail stop:OHS 10- Raleigh Email: stephen.whittaker@pgnmail.com Phone: (919) 546-7267
-----Original Message----- From: Philip Gunning [mailto:Philip.Gunning@QUEST.COM] Sent: Wednesday, May 23, 2001 10:47 AM To: DB2-L@RYCI.COM Subject: Re: VIRUS in response to DB2-L posts [...]
4945 27 21_Collecting Statistics0_26_mmetcalf@NOTES.STATE.NE.US31_Wed, 23 May 2001 10:12:37 -0500586_us-ascii We currently use CA (Platinum) Database Analyzer (aka PDA) to collect our statistics and create our reorg jobstreams. PDA consumes a huge percentage of our processor for each job and eventually stops all other batch jobs from executing until it finishes. This is not acceptable to our MVS systems staff. We have to single thread these stats jobs because of this problem. I am looking at alternatives for our PDA stats jobs and am seeking ideas from other shops. I know I can run Runstats but that doesn't build the reorg jobstream for us. We would manually have to create [...]
4973 69 36_Re: VIRUS in response to DB2-L posts12_Susan Lawson22_lawson_susan@YAHOO.COM31_Wed, 23 May 2001 08:13:11 -0700401_us-ascii Phil,
Problem is this e-mail is going directly to the person who submits to DB2-L.
It will be a response your message that you sent to DB2-L with a note to 'Take a look at the attachment'. Outlook will not let you view the attachement because it is invalid, but if not everyone should delete it when it comes in. It is title something like 'Sorry_About_Yesterday.doc.pic.' [...]
5043 157 38_Re: DB2 Addressing beyond 2Gigs memory14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 23 May 2001 16:13:45 +0100263_iso-8859-1 Easy question first.
Yes there IS a 2Gb line (seems to be called the BAR as opposed to the LINE).
So 16 bit is all below the LINE 31 bit can be above or below the LINE but must be below the BAR 64 bit is all the way (to the "TOP"??) [...]
5201 59 38_Re: DB2 Addressing beyond 2Gigs memory22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 23 May 2001 11:21:54 -0400625_iso-8859-1 Check out Akiko Hoshikawa's NA IDUG presentation "E9 - Performance beyond 2GB Real"
I believe there is no such thing as ESTOR in the z/Series architecture. All memory is CSTOR.
Pages pass through a "TRANSFER POOL" (I forget the exact terminology & I don't have the session CD-ROM with me) when they are transferred between the virtual pool & the data space buffer pool. Much discussion center around the 16MB capacity of the "TRANSFER POOL". The "TRANSFER POOL" lives in the xxxxDBM1 address space. Many thought it was too small. The recommendation was to request a larger capacity through your [...]
5261 94 60_Storing a codes versus storing the data in tables. OO-Design13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Wed, 23 May 2001 10:29:35 -0500343_iso-8859-1 Hi,
My question. Do sites store CODES in a table for simple data elements, or do you store the actual value. By simple codes I mean values like Y or N (Yes/No). Do you store a code which represents Yes or the actual value? We are not talking about using codes, just when to store the code in the table versus the value. [...]
5356 21 17_UDB DB2 Vs ORACLE18_Ghose, Roger (MTO)25_Roger.Ghose@MTO.GOV.ON.CA31_Wed, 23 May 2001 11:29:51 -0400374_iso-8859-1 Hi Everyone, Has anybody done any study/comparison between the two products UDB DB2 and Oracle. The criteria could be anything from performance, price, ease of use, maintenance, tools etc. I would appreciate it kindly if you could send me some facts on making your choice. I have been given this assignment to work on and your help will be much appreciated. [...]
5378 73 25_Re: Collecting Statistics13_Adrian Savory27_Adrian.Savory@WORKTHING.COM31_Wed, 23 May 2001 16:35:01 +0100354_iso-8859-1 Michelle,
I'm a bit rusty on PDA but I do remember there are various options for collecting stats, some are heavy on resources, others no so. Also, another gotcha that catches a lot of people out with PDA is that you do not have to collect statistics every time you want to generate something (though I think this is the default). [...]
5452 27 19_Rollback required ?0_26_JCameron@MSI-INSURANCE.COM31_Wed, 23 May 2001 10:37:16 -0500454_us-ascii We are experimenting with Lotus calling an OS390 DB2 stored procedure. It abended and now all attempts to call the procedure result in an SQLCODE of -965 and an SQLSTATE of 51021 (rollback required). According to the manual, correct the problem and issue a -START PROCEDURE to activate it. That doesn't do anything. We are running WLM in goal mode, so I also tried refreshing the WLM address space. Again nothing. Still get the same error. [...]
5480 111 36_Re: VIRUS in response to DB2-L posts13_Morrill, John12_JohnM@VP.NET31_Wed, 23 May 2001 09:48:38 -0600423_- Greetings Susan!
Thank you for confirming what I suspected. I was just in the middle of sending an e-mail to those who has received the virus when your message came in.
Everyone, what is going on is that someone is "spoofing" the list. The virus are not being sent to DB2-L and distributed to the subscribers. Instead someone is subscribed to this list and is sending the virus to everyone that posts. [...]
5592 116 36_Re: VIRUS in response to DB2-L posts15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 23 May 2001 10:56:11 -0500775_iso-8859-1 I got it, too. It was sent directly to me. The Internet headers are as follows, if that is any help. It looks like the Microsoft software came from Western Europe, I suspect.
Received: from wf.net (odin.wf.net [64.57.224.7]) by doamail01.doa.state.wi.us with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id KTWDX36R; Wed, 23 May 2001 10:42:06 -0500 Received: (qmail 17383 invoked from network); 23 May 2001 10:41:59 -0500 Received: from pm1-8.decatur.wf.net (HELO y8000x9986) (64.57.225.23) by odin.wf.net with SMTP; 23 May 2001 10:41:59 -0500 Message-ID: <06fb01c0e39f$52d0e160$65ea3940@i2.com> From: "Kent Collins" To: Subject: Re: Re: DB2 VSAM sizing limit MIME-Version: 1.0 [...]
5709 161 25_Re: Collecting Statistics14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 23 May 2001 16:56:15 +0100390_iso-8859-1 Hi Michelle,
There are lots of things you can do to PDA to tune both the collection of statistics and the generation of jobs. In some ways, PDA is a little like DB2. If you set it up to do so, it will use all the resources that are available to get the job done in the shortest time possible. Of course, also like DB2 this is not always the right thing to let it do! [...]
5871 63 21_Re: UDB DB2 Vs ORACLE12_Susan Lawson22_lawson_susan@YAHOO.COM31_Wed, 23 May 2001 09:00:53 -0700595_us-ascii Roger,
We have one you can download from our site.
Go to www.ylassoc.com and it is on the front page.
If you need more information we have a Part II to this also.
Regards, Susan Lawson YL&A --- "Ghose, Roger (MTO)" wrote: > Hi Everyone, > Has anybody done any > study/comparison between the two > products UDB DB2 and Oracle. The criteria could be > anything from > performance, price, ease of use, maintenance, tools > etc. I would appreciate > it kindly if you could send me some facts on making > your choice. I have been [...]
5935 95 36_Re: VIRUS in response to DB2-L posts15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 23 May 2001 11:02:30 -0500459_iso-8859-1 The name of the file is New_Napster_Site.DOC.scr and it contains the virus, W32/BadTrans@MM. It was intercepted by our anti-virus software.
Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services
"When you are courting a nice girl an hour seems like a second. When you sit on a red-hot cinder a second seems like an hour. That's relativity." -Albert Einstein On relativity [...]
6031 156 21_Re: UDB DB2 Vs ORACLE11_Emery, Matt19_matt.emery@JNLI.COM31_Wed, 23 May 2001 12:05:54 -0400512_iso-8859-1 We did a comparison and it came down to price. At the time Oracle priced themselves out of contention so we went with DB2/UDB. I understand that Oracle pricing may have changed since then (3 years ago).
Matthew J. Emery Jackson National Life Insurance Company Technology Department - Database Administrator voice: 517-367-3715 fax: 517-706-5506 pager: 517-794-3504 email: Matt.Emery@jnli.com e-page: 5177943504@myairmail.com [...]
6188 161 12_Re: Settings11_Emery, Matt19_matt.emery@JNLI.COM31_Wed, 23 May 2001 12:06:32 -0400537_iso-8859-1 To stop getting the db2 list emails: send set db2-l nomail --> in the body of the email with nothing else (no signature, phone numbers, etc.) --> subject can be left blank to listserv@ryci.com
Matthew J. Emery Jackson National Life Insurance Company Technology Department - Database Administrator voice: 517-367-3715 fax: 517-706-5506 pager: 517-794-3504 email: Matt.Emery@jnli.com e-page: 5177943504@myairmail.com [...]
6350 79 25_Re: Collecting Statistics64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Wed, 23 May 2001 11:16:01 -0500617_ISO-8859-1 Hi Michelle.
CDB's approach to reorg/copy automation does not involve a preprocessor step to collect statistics, which in turn determines which reorgs (or copies) need to be run, which in turn creates utility JCL, that may have to be manually verified, that will be run sometime in the future.
CDB's philosophy for automation is simply to submit the reorg/copy and then, based on your criteria, (as granular as you want to get), let the utility decide if the reorg/copy needs to be run. In essence, CDB lets you get "under the hood of the reorg/copy" to determine dynamically what needs [...]
6430 117 36_Re: VIRUS in response to DB2-L posts16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 23 May 2001 12:24:14 -0400541_iso-8859-1 Linda, He also sent it out under several other filenames. Some are .scr, some are .bmp, some are .txt
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Wednesday, May 23, 2001 12:03 PM To: DB2-L@RYCI.COM Subject: Re: VIRUS in response to DB2-L posts
The name of the file is New_Napster_Site.DOC.scr and it contains the virus, W32/BadTrans@MM. It was intercepted by our anti-virus software. [...]
6548 39 26_Need info on DB2 variables14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Wed, 23 May 2001 12:44:12 -0400400_iso-8859-1 Hi List,
I have a couple of questions.
1. Can someone tell me where I can find information about DB2 profile variables and other variables like: DB2COMM, SVCENAME, NNAME, TPNAME, DB2_PARALLEL_IO, DB2_STRIPED_CONTAINERS etc. - things which can be set by the db2set command.
If there is a particular reference or guide where I can find this info, I can read it up. [...]
6588 44 21_Re: UDB DB2 Vs ORACLE11_Pavan Borra26_pavan.borra@PRUDENTIAL.COM31_Wed, 23 May 2001 12:43:13 -0400771_us-ascii Check this article !! It'll give you a nice comparison !!
http://www.intelligententerprise.com/000929/feat1.shtml
"Ghose, Roger (MTO)" Wednesday May 23, 2001 11:29 AM
Please respond to DB2 Data Base Discussion List To: DB2-L@RYCI.COM cc: (bcc: Pavan Borra/O&S/Prudential) Subject: UDB DB2 Vs ORACLE
Hi Everyone, Has anybody done any study/comparison between the two products UDB DB2 and Oracle. The criteria could be anything from performance, price, ease of use, maintenance, tools etc. I would appreciate it kindly if you could send me some facts on making your choice. I have been given this assignment to work on and your help will [...]
6633 137 36_Re: VIRUS in response to DB2-L posts15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 23 May 2001 11:45:41 -0500480_iso-8859-1 Hi, Eric, I found the virus definition on the Symmantec web site. It does come in several different file names.
Thanks for the info,
Linda
-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Wednesday, May 23, 2001 11:24 AM To: DB2-L@RYCI.COM Subject: Re: VIRUS in response to DB2-L posts
Linda, He also sent it out under several other filenames. Some are .scr, some are .bmp, some are .txt [...]
6771 60 30_Re: Need info on DB2 variables18_Gert van der Kooij15_geko@WANADOO.NL31_Wed, 23 May 2001 19:24:13 +0200654_iso-8859-1 Hi,
You can find it an appendix of the Administration Guide.
----- Original Message ----- From: "Sinha, Abhijit" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, May 23, 2001 6:44 PM Subject: Need info on DB2 variables
> Hi List, > > I have a couple of questions. > > 1. > Can someone tell me where I can find information about DB2 profile variables > and other variables like: > DB2COMM, SVCENAME, NNAME, TPNAME, DB2_PARALLEL_IO, DB2_STRIPED_CONTAINERS > etc. - things which can be set by the db2set command. > > If there is a particular reference or guide where I [...]
6832 230 30_Re: Need info on DB2 variables12_Randy Wilson22_Randy_Wilson@BCBST.COM31_Wed, 23 May 2001 13:31:38 -0400641_iso-8859-1 Hi Sinha, Try this IBM site... and use it to search for the parms and you should find what you need. http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/techlib. d2w/report
My understanding of how the multipage allocation works, is... under the default 'NO' setting, when a page is needed in a filesystem to insert more data... udb will allocated one page for additional space... this may be fine if you add records at a very slow rate because when that page is allocated it requires some overhead within db2 and aix... if many inserts are being done, then a lot of time will be spent allocating pages [...]
7063 66 32_VIRUS in response to DB2-L posts13_Morrill, John12_JohnM@VP.NET31_Wed, 23 May 2001 11:36:47 -06002856_- Greetings!
I found Kent Collins in our subscriber list and I am disabling his account. After this message is posted, the spend of virus should stop. Let me know if it does not.
Cheers!
J. Michael Morrill Chief List Owner
begin 600 winmail.dat M>)\^(AT1`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<` M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`06``P`.````T0<%`!<` M"P`D`"\``P!5`0$@@`,`#@```-$'!0`7``L`)@`<``,`1`$!"8`!`"$````W M-3DT.31%03(X1#(Q1C1!.$0V,3%%,#(R-C9%04$X10`U!P$$@`$`(@```"!6 M25)54R!I;B!R97-P;VYS92!T;R!$0C(M3"!P;W-T``&`""`&``````#`````````1@````!4A0```0````0````Y+C``"P`" M@`@@!@``````P````````$8`````!H4````````#``.`""`&``````#````` M````1@`````!A0````````L`!(`((`8``````,````````!&``````.%```` M````"P`%@`@@!@``````P````````$8`````#H4````````#``:`""`&```` M``#`````````1@`````0A0````````,`!X`((`8``````,````````!&```` M`!&%`````````P`)@`@@!@``````P````````$8`````&(4````````"`0D0 M`0```&@!``!D`0``$0(``$Q:1G5AY.%[`P`*`')C<&L&]`9B!V M:7)U!"!SFF@(8&P>L"#@;W`B\(9,%"`CL2!K;F\'X.<&D!^0!4!D;P>1)W`B MX;L*XQW60R4`!)`=?$HB\-9-#>`3X&4#($T%L`40+Q]`*28(D"6@3"#23W<6 M;@20'9I]+@`>`'```0```"(````@5DE255,@:6X@/Z]O``!``#D`$(+U\*[CP`$#`/$_"00` M`!X`,4`!````!@```$I/2$Y-`````P`:0``````>`#!``0````8```!*3TA. M30````,`&4```````P#]/^0$```#`"8```````,`-@```````P"`$/____\" M`4<``0```#D```!C/553.V$](#MP/59A;G1A9V4@4&]I;G0[;#U%6%!/4TE4 M24].+3`Q,#4R,S$W,S8T-UHM.3$Q-0`````"`?D_`0```$T`````````W*=` MR,!"$!JTN0@`*R_A@@$`````````+T\]5D%.5$%'12!03TE.5"]/53U64$Y% M5"]#3CU214-)4$E%3E13+T-./4I/2$Y-`````!X`^#\!````#@```$UO`#A``0````8```!*3TA.30````(!^S\!````30`````` M``#'!O M``@0`0```&4```!'4D5%5$E.1U-)1D]53D1+14Y40T], M3$E.4TE.3U524U5"4T-224)%4DQ)4U1!3D1)04U$25-!0DQ)3D=(25-!0T-/ M54Y4049415)42$E334534T%'14E34$]35$5$+%1(15-0``````(!?P`!```` M-````#PW.#=!,C4Y-S%$-T9$1C0T0C0W,S(Y03DW0D4T040T-C'!O
I found Kent Collins in our subscriber list and I am disabling his account. After this message is posted, the spend of virus should stop. Let me know if it does not.
Cheers!
J. Michael Morrill Chief List Owner
7188 16 30_Re: Need info on DB2 variables14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Wed, 23 May 2001 13:56:47 -0400380_iso-8859-1 Thanks you all for your responses.
Found info on the DB2 variables in Appendix D of Administration Guide.
Abhijit
================================================ 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.
7205 70 21_Re: UDB DB2 Vs ORACLE12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 23 May 2001 11:04:45 -0700683_us-ascii Yeh, it has. Much Much more expensive. :=) --- "Emery, Matt" wrote: > We did a comparison and it came down to price. At the time Oracle > priced > themselves out of contention so we went with DB2/UDB. I understand > that > Oracle pricing may have changed since then (3 years ago). > > Matthew J. Emery > Jackson National Life Insurance Company > Technology Department - Database Administrator > voice: 517-367-3715 > fax: 517-706-5506 > pager: 517-794-3504 > email: Matt.Emery@jnli.com > e-page: 5177943504@myairmail.com > > > -----Original Message----- > From: Ghose, Roger (MTO) > [...]
7276 24 17_Index Size Limits11_Moore, Tony15_TMoore@IKON.COM31_Wed, 23 May 2001 13:58:18 -0400582_iso-8859-1 Yo Listers, I've been looking in the DB2/OS390 manuals (V4 and V6) for a maximum space limit on non-partitioned indexes and not had much luck. Therefore, my assumption is that the limit can be calculated as the maximum primary quantity size allowed + (maximum secondary quantity allowed * 118). According to the manuals, the max primary quantity is 4,194,304 1K blocks (4Gig) and the max secondary quantity that can be used is 131,068 1K blocks (130M - roughly). That would make the maximum size available for an index to be 4G + (130M * 118) which would come up to [...]
7301 60 21_Re: Index Size Limits34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Wed, 23 May 2001 14:20:26 -0400336_us-ascii The size of index space is dependent on tablespace size. Here are few examples:
Tablepspace upto 16 parts limit: 4G per part index limit:4G per part (partitioned index) Tablespace upto 32 parts limit: 2G index limit:2G per part Tablespace upto 64 parts limit:1G per part index limit:1G per part (partitioned index) [...]
7362 17 36_Re: IDUG Conference (Migration Tool)12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 23 May 2001 13:41:37 -0500511_- I think this was the one I mentioned at IDUG. The IBM DB2 V7.2 Sybase Migration Toolkit was released last week. This is a beta and covers DB2 for UNIX and Windows V7.2.
URL : http://www.ibm.com/software/data/db2/migration/mtk/
Roger Miller, DB2 for z/OS
================================================ 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.
7380 16 75_Insert of upper and lower case data and making that data stored u pper case14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Wed, 23 May 2001 14:04:48 -0500511_iso-8859-1 I'm on DB2 v5 OS/390 and I'm inserting or updating a column which is a combination of upper/lower case. I would like that data stored as just upper case. Is there a column attribute that can force this translation. Like CCSID, EBCDIC ASCII or something else?
================================================ 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.
7397 25 30_Index header & directory pages16_Sharon Zitterman24_Sharon.Zitterman@TRW.COM31_Wed, 23 May 2001 15:42:28 -0400379_US-ASCII We are in the process of applying several PTFs. One of the PTFs says
"An invalid index directory page pointer in its header page caused the index descriptor (IXD) being built incorrectly."
In the above statement,
a) What is an index directory page?
b) What is an index header page? Are multiple index header pages possible for an index? [...]
7423 60 21_Re: Index Size Limits14_Richard Yevich17_ryevich@YAHOO.COM31_Wed, 23 May 2001 12:55:18 -0700602_us-ascii As of V6. Depends on size/type of the partitioned tablespace. If of the very large variety, 16TB, and NPI using piecesize, then 16TB. That would be 254 pieces of 64GB each. Check the administration manual for more information on this.
--- "Moore, Tony" wrote: > Yo Listers, > I've been looking in the DB2/OS390 manuals (V4 and V6) for a > maximum space > limit on non-partitioned indexes and not had much luck. Therefore, > my > assumption is that the limit can be calculated as the maximum > primary > quantity size allowed + (maximum secondary quantity allowed [...]
7484 22 31_DB2 Client code for DB2 Connect22_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM31_Wed, 23 May 2001 13:20:48 -0700399_iso-8859-1 Gurus, Just curious to know, how shops that have implemented DB2 Connect Enterprise edition are rolling out the DB2 Client code to the clients. In our shop we use a product called Wininstall to allow clients to automatically run an install. Now the question is do I need everything that DB2 Client "Typical" stipulates or can I prune it down to few things only by the Custom option. [...]
7507 78 21_Re: Index Size Limits13_Daley, Norman18_NDaley@CINERGY.COM31_Wed, 23 May 2001 15:23:09 -0500599_iso-8859-1 Tony, For nonpartitioned, which I think is what you asked, 32 datasets of 2GB each for V5. See DB2 for OS/390 V5 Admin Guide, page 2-70.
Norm Daley Cinergy
-----Original Message----- From: Richard Yevich [mailto:ryevich@YAHOO.COM] Sent: Wednesday, May 23, 2001 3:55 PM To: DB2-L@RYCI.COM Subject: Re: Index Size Limits
As of V6. Depends on size/type of the partitioned tablespace. If of the very large variety, 16TB, and NPI using piecesize, then 16TB. That would be 254 pieces of 64GB each. Check the administration manual for more information on this. [...]
7586 23 61_Is there a quick way to tell which column is causing an -406?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Wed, 23 May 2001 16:33:06 -0400
7610 87 46_Re: Repeatable Reads from DB2 CONNECT clients.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Wed, 23 May 2001 13:41:26 -0700454_iso-8859-1 Myron, Thanks for the help. I set the ini and CCA but still showing RR. I'm beginning to think it may be a problem with the TMONDB monitor report showing the wrong isolation. I'm going to chase that lead for a while. thanks again, cliff:-)
-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Wednesday, May 23, 2001 5:26 AM To: DB2-L@RYCI.COM Subject: Re: Repeatable Reads from DB2 CONNECT clients. [...]
7698 53 44_Re: Intermediate Commits in Stored Procedure14_Richard Yevich17_ryevich@YAHOO.COM31_Wed, 23 May 2001 14:34:54 -0700553_us-ascii COMMITs are allowed in stored procedures with DB2 on OS/390 and z/OS as of Version 7.
--- "K.Balaji" wrote: > Hi all, > I understand that IBM did not support intermediate commits in > stored > procedure on MVS platform and allowed application program to handle > it. What > I dont understand is that how can I issue an intermediate commit > for a unit > of work in store procedure. And how this is handled in mainframe > client code > as well as in then client call which comes thro NEON driver. Any > help on [...]
7752 40 79_Re: Insert of upper and lower case data and making that data stored u pper case11_Bikash Paul19_bikash_db@YAHOO.COM31_Wed, 23 May 2001 15:41:33 -0700550_us-ascii Hi, In Version 5, There is no colume function to convert the case. And i dont think, there could be any global setting to so the same. Only way to do that as i see use EDITPROC or FIELDPROC for the table.
Thanks and regards, Bikash
--- "Zobjeck, A. J." wrote: > I'm on DB2 v5 OS/390 and I'm inserting or updating a column which > is a > combination of upper/lower case. I would like that data stored as > just upper > case. Is there a column attribute that can force this translation. > Like > CCSID, [...]
7793 53 23_Re: Rollback required ?11_Bikash Paul19_bikash_db@YAHOO.COM31_Wed, 23 May 2001 16:06:45 -0700311_us-ascii Hi, I faced this problem couple of times. Sometimes, i do a STOP PROCEDURE with ACTION(REJECT) and then START it again to activate. And it works.
If i does not help, then WLM address space could be bounced to sort it out.. I dont have any answer as such. But this is what, i used to do it. [...]
7847 71 57_Re: Stored procedures and RRSAF - Authorization problems.11_Bikash Paul19_bikash_db@YAHOO.COM31_Wed, 23 May 2001 16:27:58 -0700292_us-ascii Hi, I am not sure if you are using RACF checking for DB2. RACF class for DB2 is DSNR. There might have some optional profile defintion called .RRSAF. If the users do not READ access on the profile, can not use RRSAF services which is by WLM managed stored procedure. [...]
7919 82 25_Re: DB2 VSAM sizing limit11_Bikash Paul19_bikash_db@YAHOO.COM31_Wed, 23 May 2001 16:42:35 -0700447_us-ascii Hi, We used to similar things to check whether the table is 80% full (Of allocated space). We used to do LISTCAT on the VSAM dataset and used HI-U-RBA data to find it out. This given me, the no of bytes and i can convert it accordingly.
I dont think, you should use no of active pages. As all the allocated pages might not be used. There has to be consideration for FREEPAGES which is not included in the "no of active page". [...]
8002 113 21_Re: Index Size Limits14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 23 May 2001 19:11:54 -0500526_iso-8859-1 As I recall, in V5, for an NPI on a LARGE TS, the limit was not 64GB but 512GB. For a non-LARGE, it was 64GB for an NPI. In V6 the limits were raised.
Regards, Richard
Richard Yevich - Principal Yevich Lawson & Assoc. Inc. (YL&A) IBM DB2 and Sysplex Gold Consultant IBM Certified Solutions Expert: DB2 V7.1 Database Administration for OS/390 Richard_Yevich@YLAssoc.com 1-888-246-5049/1-217-744-0000 http://www.YLAssoc.com -- DB2 Performance Journal http://www.db2-symposium.com -- DB2 Symposiums [...]
8116 93 25_Re: CPU Time for DB2 Load11_Bikash Paul19_bikash_db@YAHOO.COM31_Wed, 23 May 2001 17:18:59 -0700343_us-ascii Hi, I think the better approach could be 1) Dropping the table 2) Creating it new 3) Loading data Obviously, you need a keep image copy of the table. Recovery mechanism would be DSN1COPY from the imagecopy in case of failure.
This way, We can eliminate the cost of deleting rows from the table. I think , it is very high. [...]
8210 106 46_Re: Repeatable Reads from DB2 CONNECT clients.23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Thu, 24 May 2001 00:53:50 -0000342_iso-8859-1 another option is to check the application and ensure that it commits frequently as all locks are released on the commit. If the thread uses dynamic SQL then a RR lock is on dsndb06 database until a commit is performed. We do a commit even if there is nothing to commit. ie on read transactions. and the problem is minimised. [...]
8317 51 34_Re: Index header & directory pages12_Susan Lawson24_susan_lawson@YLASSOC.COM31_Wed, 23 May 2001 20:07:07 -0500385_us-ascii Sharon,
Your best source for information regarding what is contained on an index directory and index header page can be found in Chapter 25 in the IBM DB2 Diagnostics Guide. There also is an excellent presentation by Chris Skelnik called 'Pageing all DBA's' that was given at both IDUG and the IBM Tech conference that goes into the details regarding these pages. [...]
8369 66 25_Re: DB2 VSAM sizing limit15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 24 May 2001 08:58:18 +1000377_- Julian,
I seem to remember helping in the development of queries to do just that, for our good friends at aMaDEUS. Damn, should have kept a copy. I seem to remember it was a 4-union query, two each for TSs and IXs but I can't remember why. Perhaps the good Dr. E might feel able to share this query with you, assuming he's allowed to. Michael, are you listening? [...]
8436 89 21_Re: Index Size Limits15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 24 May 2001 09:51:47 +1000501_- Venkat,
What you say is right (I think) but Tony was specifically asking about non-partitioning indexes. Partitioning indexes inherit the DSSIZE properties from their TS, so no prob there with 1TB indexes (perish the thought). In the SQL manual NPIs can be created with PIECESIZE 64G if the TS they're on says DSSIZE 64G. However it doesn't say (or rather, I can't find it saying) that they also inherit the EA characteristics of the 'owning' TS. I would assume so, but it's not stated. [...]
8526 24 21_QMF VER 2.0 RELEASE 40_24_ujjwal@LOT.TATASTEEL.COM31_Thu, 24 May 2001 10:23:06 +0530434_us-ascii Hi List , Is QMF Version 2 Release 4 compatible with DB2 V6 ?. We are at present in DB2 V5 R1 and QMF Ver 2 Rel 4. As far as I know QMF Version 2 Release 4 is out of Support and out of Service. The only release being supported is QMF 3.3 and QMF 6.1 which is what was just released.Do We need to get someone from QMF support to find out if we can migrate from 2.4 to 6.1 or 3.3. Any help will be appreciated. Thank You. [...]
8551 119 69_Re: Storing a codes versus storing the data in tablesOO-Design E t Al14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 23 May 2001 22:13:24 -0700568_- Glenn, I supported an application that was being developed in Powerbuilder and the developer thought he was a DBA. That's what this sounds like to me. In my situation, it all started as a result of RAD sessions with the user w/o a DA or DBA present, and no written requirements. We fought the fight and followed normal logical design principles, in our case we tried to get and stay at Third Normal Form (TNF), not fith as most text books indicate, most companies have trouble just getting to 3NF. We looked at denormalization when we needed to for performance [...]
8671 15 41_Don Lee/Boulder/IBM is out of the office.7_Don Lee16_dblee@US.IBM.COM31_Thu, 24 May 2001 00:36:54 -0600393_us-ascii I will be out of the office starting May 24, 2001 and will not return until May 29, 2001.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
8687 124 30_Fwd: Re: CPU Time for DB2 Load8_apkjha x18_apkjha@HOTMAIL.COM31_Thu, 24 May 2001 06:51:10 -0000577_- Hi,
Thanks for your reply.
I am not that convinced that deleting the table and reloading it will be more efficient. This would imply that I have to load 240 Million records every day and rebuilding the index for all that data. (Today I am only loading 4,5 million records every day). My estimates tells me that this will consume considerably more CPU. Since I am using load replace on partition level the delete time (at least not on the table space level) should not be an issue (VSAM Delete/Define). For the indexes I guess it's another issue. I haven't [...]
8812 111 25_Re: DB2 VSAM sizing limit15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 24 May 2001 07:08:39 -0500386_iso-8859-1 I think that you are correct. I seem to remember now that once, even though I allocated space over the VSAM limit, (I had forgotten that a 35 partition tablespace can only have 1 gig per partition if it is not defined as large or DSSIZE was not specified.)the number of pages actually used was less. I found that by the high-used RBA and dividing the bytes down to gig. [...]
8924 34 32_DB2 | WINDOWS | VERSIONS | SIZES0_22_rmadan@CYVEILLANCE.COM31_Thu, 24 May 2001 08:16:00 -0400719_iso-8859-1 Folks,
Of those of you in the UDB windows environment. I was wondering what the db sizes,versions and EE or EEE were running. Just need to get a lay of land for management.
thanks in anticipation of your response.
rakesh
Rakesh Madan Senior Database Administrator http://www.cyveillance.com Cyveillance(Minding your business on the Net) For additional information or to attend a FREE Executive Cyber Seminar, visit . "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 [...]
8959 19 15_UDB DB Packages18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 24 May 2001 08:26:43 -0400522_iso-8859-1 I just spent about 1 hour trying to find information on the packages shipped with UDB V7.x for Solaris to no avail. Does anyone know where I can find out what package(s) is/are executed for dynamic SQL for the environment above?
Thanks!
Peter J. Krawetzky
================================================ 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.
8979 109 46_Re: Repeatable Reads from DB2 CONNECT clients.27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Thu, 24 May 2001 07:45:39 -0500469_iso-8859-1 At my previous job, we used StarQuest products instead of DB2 Connect but TMON/DB2 also showed RR instead of CS. I know I talked to both StarQuest and Landmark, and one of them (I don't remember which) figured out that it was using CS but reporting RR. Unfortunately, I can't remember the details, but I do remember that the explanation made sense. Maybe something about it was reporting at the plan level and since there wasn't one it defaulted to RR? [...]
9089 128 65_Re: Is there a quick way to tell which column is causing an -406?17_Polley, Mike (M.)16_mpolley@FORD.COM31_Thu, 24 May 2001 08:51:52 -0400445_iso-8859-1 Carlton, I'm not sure if this is the quick way, and you probably already thought of this, but, I would binarily run the sql until I determined what field was causing the problem. That is: run half, next half, etc... HTH -----Original Message----- From: Carlton Enuda [mailto:carltonenuda@HOTMAIL.COM] Sent: Wednesday, May 23, 2001 4:33 PM To: DB2-L@RYCI.COM Subject: Is there a quick way to tell which column is causing an -406? [...]
9218 31 17_The Virus is Back15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 24 May 2001 08:09:31 -0500485_iso-8859-1 I just got an email from kathryn sears [ksears@dpconsultants.com] after I posted on the list. This might be a legitimate person (?). Perhaps her workstation is infected? It came with a cut and paste of my posting along with a statement to take a look at the attachment. The virus is still W32/BadTrans@MM. This virus will mail itself to all unanswered email. Perhaps some members of the list are infected with this virus and should have their workstations checked out. [...]
9250 33 57_UDB Script Centre vs Windows Task Scheduler vs AT command17_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Thu, 24 May 2001 23:11:47 +1000476_us-ascii Hi I am trying to get some of my housekeeping jobs scheduled using the UDB Script Centre or Windows Task Scheduler or AT command in an NT environment and am having lots of problems.
The jobs I am scheduling are written in REXX and I want them to run even if no one is logged on.. I have been able to get all to work on occassions but for some reason when the tasks are run nothing happens. I hava a feeling that they are getting in the way of each other. [...]
9284 129 25_Re: CPU Time for DB2 Load15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Thu, 24 May 2001 08:19:45 -0500586_us-ascii If you were not using SORTKEYS in the load card for building indexes in parallel , then try using this option in load card.
Ex: Load log no sortkeys into table part nn replace ...... ----- Forwarded by Mohammed Nayeem/MoMedicaid/US on 05/24/01 08:18 AM ----- |--------+-----------------------> | | Bikash Paul | | | | | | | | | 05/23/01 | | | 07:18 PM | | | Please | | | respond to | | | DB2 Data Base| | | Discussion | | | List | | | | |--------+-----------------------> >--------------------------------------------------------| | | | [...]
9414 56 21_Re: The Virus is Back16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 24 May 2001 09:23:31 -0400486_iso-8859-1 Kathryn is for real. She is one of the more ethical recruiters. If she sent a virus I bet she had no idea she was doing so.
BTW did you know foot-and-mouth disease is the only virus not spread via Microsoft Outlook?
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Thursday, May 24, 2001 9:10 AM To: DB2-L@RYCI.COM Subject: The Virus is Back [...]
9471 71 21_Re: The Virus is Back14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Thu, 24 May 2001 08:32:07 -0500436_iso-8859-1 All we can do, and will do is to prevent outgoing email, from postings, to the infected subscribers. Hopefully, this will eventually wind its way down.
When anyone posts to the list, your original email id is also on the mail to all subscribers. Anyone with this virus will have that email replied to, with the virus attached. As long as we can get the infected subscribers off the valid list, we should be okay. [...]
9543 49 36_Re: Dynamic SQL and CPU usage report10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 24 May 2001 09:54:55 -0400418_us-ascii Roger
I'm interested in the storage usage of dynamic sql. Our subsystem is closing in on the 2 gig line (v5) , with small BP's. Is there anyway to capture/determine/report the amount of storage dynamic sql uses.
Tom
Roger Miller @RYCI.COM> on 05/20/2001 04:03:53 PM
Please respond to DB2 Data Base Discussion List [...]
9593 96 21_Re: The Virus is Back13_Larry Hubbard29_Larry_Hubbard@CMS.STATE.IL.US31_Thu, 24 May 2001 09:21:00 -0500438_us-ascii Isn't that supposed to be covered in the next release from Microsoft, code-named "Outbreak".
Larry Hubbard CMS-BCCS-ISD Tel. 217-785-8848 Fax. 217-782-8126
"Pearson, Eric L," To: DB2-L@RYCI.COM Subject: Re: The Virus is Back Sent by: DB2 Data Base Discussion List
05/24/01 08:23 AM Please respond to DB2 Data Base Discussion List [...]
9690 189 34_Re: Fwd: Re: CPU Time for DB2 Load11_Bikash Paul19_bikash_db@YAHOO.COM31_Thu, 24 May 2001 07:35:37 -0700466_us-ascii Hi, I am sorry for getting it wrong.. I got that "table is loaded once in five day INSTEAD OF the fact that 5 partition is loaded everyday". In that case, dropping table is not an idea at all.
Just another thought, Are u loading with LOG NO option. This should save some CPU time at least. After loading is complete, if successful, then start the partition. Obviously we need to have keep the IC ready to facilitate recovery in case of failure. [...]
9880 27 21_Re: The Virus is Back15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Thu, 24 May 2001 10:30:22 -0400438_iso-8859-1 I thought that one was supposed to handle e-bola and e-coli ;)
-----Original Message----- From: Larry Hubbard [mailto:Larry_Hubbard@CMS.STATE.IL.US] Sent: Thursday, May 24, 2001 10:21 AM To: DB2-L@RYCI.COM Subject: Re: The Virus is Back
Isn't that supposed to be covered in the next release from Microsoft, code-named "Outbreak".
Larry Hubbard CMS-BCCS-ISD Tel. 217-785-8848 Fax. 217-782-8126 [...]
9908 26 29_Moving data from NT to OS/39014_Lunn, Margaret31_Margaret.Lunn@MORGANSTANLEY.COM31_Thu, 24 May 2001 10:29:29 -0400349_iso-8859-1 I have a DB2 table on a Windows NT server that I would like to re-create in DB2 on OS/390. The existing table contains data that I need to move to the new table on the mainframe, but with the differences in data movement utilities and file formats between the two platforms, I can't figure out how to do it. Any suggestions? Thanks! [...]
9935 51 21_Re: The Virus is Back0_22_rmadan@CYVEILLANCE.COM31_Thu, 24 May 2001 11:07:12 -0400591_iso-8859-1 Got the same from her it was identical
> -----Original Message----- > From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] > Sent: Thursday, May 24, 2001 9:10 AM > To: DB2-L@RYCI.COM > Subject: The Virus is Back > > > I just got an email from kathryn sears > [ksears@dpconsultants.com] after I > posted on the list. This might be a legitimate person (?). > Perhaps her > workstation is infected? It came with a cut and paste of my > posting along > with a statement to take a look at the attachment. The virus is still > W32/BadTrans@MM. This virus will mail [...]
9987 30 14_DB2 SUBSYSTEMS10_Fred Hanes17_f_hanes@YAHOO.COM31_Thu, 24 May 2001 08:06:19 -0700378_us-ascii All,
I need some quick help here ... If anyone can tell me the Pros and Cons of having another DB2 subsystem on the same Box if wanting to process the same(duplicate) tables with a different range of data IE: process half of your customers 1- 10,000,000 on one subsystem and 10,000,001 thuu the end on another all this of course is production data >>>>???? [...]
10018 131 46_Re: Repeatable Reads from DB2 CONNECT clients.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 24 May 2001 08:19:55 -0700285_iso-8859-1 Tina, That's what its looking like from here. I rebound some packages to UR but Tmon showed the plan's isolation of CS. With UR I guess I can check to see it the thread took any locks to check if it really was UR, for everything else I'll have to go on faith. cliff:-) [...]
10150 47 33_Re: Moving data from NT to OS/39019_Jagadesh Kuppuswamy23_Jkuppuswamy@BOSCOVS.COM31_Thu, 24 May 2001 11:10:18 -0400615_iso-8859-1 You can export the data to a ixf file and then import the data into the table on os/390.
Thanks jag
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Lunn, Margaret Sent: Thursday, May 24, 2001 10:29 AM To: DB2-L@RYCI.COM Subject: Moving data from NT to OS/390
I have a DB2 table on a Windows NT server that I would like to re-create in DB2 on OS/390. The existing table contains data that I need to move to the new table on the mainframe, but with the differences in data movement utilities and file formats between the [...]
10198 132 46_Re: Repeatable Reads from DB2 CONNECT clients.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 24 May 2001 08:28:08 -0700411_iso-8859-1 Andrew, Good advice, unfortunately with the advent of client server and client software like MS access able to connect to DB2, applications are out of the hands of professional programmers (at least here at ODOT) and in the hands of Joe user. Looks like our jobs have switched from control to containment. Hopefully in future IBM will give us more tools (RLF etc.) to control user apps/threads. [...]
10331 59 18_Re: DB2 SUBSYSTEMS15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 24 May 2001 10:39:33 -0500344_iso-8859-1 Hi, Fred, If you are trying to balance a workload then that is what data-sharing is for. The set-up you are proposing sounds like it would be very difficult to maintain, if you can really make it work at all.
Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services [...]
10391 53 18_Re: DB2 SUBSYSTEMS11_Bikash Paul19_bikash_db@YAHOO.COM31_Thu, 24 May 2001 08:47:54 -0700345_us-ascii Hi, I dont think, this is going to help. Instead configure one subsystem well(Bufferpool tuning, Sort Workfile tuning, Partition the data, Spread data across multiple volumes to reduce I/O contention).
However, if you really want to do that and platform is OS/390, then you can implement Data Sharing over parallel Sysplex. [...]
10445 71 18_Re: DB2 SUBSYSTEMS10_Raghu Kota21_raghukota@HOTMAIL.COM31_Thu, 24 May 2001 15:58:26 -0000675_- Yeah I think the is parallel Sysplex.
Raghu.
>From: Bikash Paul >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: DB2 SUBSYSTEMS >Date: Thu, 24 May 2001 08:47:54 -0700 > >Hi, >I dont think, this is going to help. Instead configure one subsystem >well(Bufferpool tuning, Sort Workfile tuning, Partition the data, >Spread data across multiple volumes to reduce I/O contention). > >However, if you really want to do that and platform is OS/390, then >you can implement Data Sharing over parallel Sysplex. > >Regards, >Bikash >--- Fred Hanes wrote: > > All, > > > > [...]
10517 71 18_Re: DB2 SUBSYSTEMS10_Raghu Kota21_raghukota@HOTMAIL.COM31_Thu, 24 May 2001 15:58:39 -0000680_- Yeah I think the answer is parallel Sysplex.
Raghu.
>From: Bikash Paul >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: DB2 SUBSYSTEMS >Date: Thu, 24 May 2001 08:47:54 -0700 > >Hi, >I dont think, this is going to help. Instead configure one subsystem >well(Bufferpool tuning, Sort Workfile tuning, Partition the data, >Spread data across multiple volumes to reduce I/O contention). > >However, if you really want to do that and platform is OS/390, then >you can implement Data Sharing over parallel Sysplex. > >Regards, >Bikash >--- Fred Hanes wrote: > > All, > > > [...]
10589 214 39_Fwd: Re: Fwd: Re: CPU Time for DB2 Load8_apkjha x18_apkjha@HOTMAIL.COM31_Thu, 24 May 2001 16:11:31 -0000392_- Hi,
I am using LOG NO, and I am taking and IC after the load (Since I am terminating the load after building the primary index I can't do an inline Copy).
I guess the difference between a "normal" secondary and a secondary index of a partioned table is that the you have logical partitions on the latter, and you are able to do a rebuild index on the logical partitions. [...]
10804 32 21_Re: The Virus is Back13_Morrill, John12_JohnM@VP.NET31_Thu, 24 May 2001 10:18:23 -0600527_iso-8859-1 Greetings!
It would appear that that those who would spread virus have change tactics. From the behavior we have observed, it would appear that this virus creates an auto-reply that automatically replies with a virus to anyone who sends mail to an infected mail box.
By using the auto-reply, it tries to make the mail look legitimate. Also, by using this method, the virus spends slower and therefore does not cause the sudden spike in network traffic that will alert administrators to the virus. [...]
10837 147 30_Fwd: Re: CPU Time for DB2 Load8_apkjha x18_apkjha@HOTMAIL.COM31_Thu, 24 May 2001 16:17:05 -0000616_- I have tried both with and without sortkeys. Sortkeys reduces elapse time, but it will also increase CPU time slightly. My main concern at the moment is to reduce CPU rather then elapse time. /Kjell >From: Mohammed Nayeem >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: CPU Time for DB2 Load >Date: Thu, 24 May 2001 08:19:45 -0500 > >If you were not using SORTKEYS in the load card for building indexes in >parallel then try using this option in load card. > >Ex: >Load log no sortkeys into table part nn replace ...... >----- Forwarded [...]
10985 114 21_Re: Index Size Limits11_Moore, Tony15_TMoore@IKON.COM31_Thu, 24 May 2001 12:34:14 -0400373_iso-8859-1 Thanks to all for the info. Does anyone know if the 32/2Gig dataset limit applies to V4 as well? That is the release I'm running on. I was hoping to match up the subject area on page 2-70 of the V5 Admin Guide with the V4 manual, but the HTML format of the V5 manual doesn't give page numbers and trying to pull it up in PDF format gives me a blank window. [...]
11100 22 14_PARAMDEG Zparm10_Will DeLeo19_wildeleo@US.IBM.COM31_Thu, 24 May 2001 11:30:25 -0500563_- I know this is a very general question, but... Do you have any recomendations for what PARAMDEG should be valued at?
We are a seven way datasharing DB2 v5 shop. Our lpars are usually running close to 100%. We have had times where parallel quries have spiked CPU and caused our CICS regions to go short on storage. The user comunity does not want us to turn off parallelism totaly, so we thought we could at least limit the maximum number of parallel threads per originating task by usiing the PARAMDEG zparm. We are trying to deterimne a good value [...]
11123 100 21_Re: The Virus is Back14_Campbell White20_cwhite@REVEALNET.COM31_Thu, 24 May 2001 12:58:27 -0400704_us-ascii There is a non-Outlook, virus-free alternative to this problem.
A little less than a year ago, the DB2 Pipeline was formed to encourage the free exchange of technical information among DB2 professionals worldwide. For those of you who are unfamiliar with this site, here's a link: http://www.revealnet.com/Pipelines/pipelines.htm
Does anyone remember the old Compuserve Forums? You had a nicely organized community with threaded "Conferences" that organized and archived discussions by areas of interest. These forums were also moderated by a host of volunteer SYSOPS who controlled the quality of the message traffic and scrubbed abusive posts. You could also download white [...]
11224 23 24_SQL statement terminator21_Jelena Vladisavljevic15_molten@EUNET.YU31_Thu, 24 May 2001 20:21:30 +0200516_koi8-r Hi, I work with DB2 UDB V5.2 for Win NT and I need make trigger with begin atomic- end part.I change in Tool settings statement terminator to #,but in Command center I got SQL0104N An unexpected token "" was found following "". Expected tokens may include: "" when I try create trigger example from CREATE TRIGGER statement (SQL References). Then I change DB2OPTINS in -td# and now I can from CLP execute this example but I need that i Command Center. Can anyone help me? Jelena [...]
11248 52 18_Re: DB2 SUBSYSTEMS12_Chad Breiner23_chadbreiner@HOTMAIL.COM31_Thu, 24 May 2001 17:46:23 -0000595_- This sounds like a perfect canidate for Data Sharing. This allows 2 or more LPAR's to process what appears to be one database. If you split them up into 2 databases and ever need to get data from both, then you have the added overhead of DDF.
Chad Breiner
>From: Fred Hanes >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DB2 SUBSYSTEMS >Date: Thu, 24 May 2001 08:06:19 -0700 > >All, > > I need some quick help here ... If anyone can tell me >the Pros and Cons of having another DB2 subsystem on >the same [...]
11301 194 57_Re: Stored procedures and RRSAF - Authorization problems.14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Thu, 24 May 2001 13:35:52 -0400554_iso-8859-1 There is a RACF resource class .RRSAF, but the only "user" that needs authorization to it is the WLM-managed Stored Procedures address space. This is what the passage you quoted from the Redbook about "the RACF ID and Group Name you select..." is actually referring to -- the WLM Stored Procedure address space being authorized to run the RRSAF programs. If you are able to execute the stored procedure successfully as SYSADM (the ssidWLM address space starts), you are not having a problem with the .RRSAF profile. [...]
11496 50 18_Re: PARAMDEG Zparm12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 24 May 2001 13:39:07 -0400370_us-ascii At IDUG a presentation i went to it was suggested that it be 1 to 2 times the number of processors. We have set ours at 2x's. Parallel was getting out of hand so we throttled it back.
Will DeLeo @RYCI.COM> on 05/24/2001 12:30:25 PM
Please respond to DB2 Data Base Discussion List [...]
11547 72 44_Sorry about the virus!- It was unintentional13_kathryn sears24_ksears@DPCONSULTANTS.COM31_Thu, 24 May 2001 13:50:07 -0400564_iso-8859-1 Everyone- I am SO sorry- and thanks for defending me-- My network administrator does not know how it got past our virus protection, but as soon as I opened my email this morning, I could tell something was VERY wrong- it sent emails out to various people that have emailed me recently-- By the way, anybody who sent me emails between late afternoon yesterday and late morning today, send them again- most of them were altered by the virus (the name of the sender was changed to my own name). Again, so sorry for spreading this thing around; I hope [...]
11620 35 21_Re: Index Size Limits14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Thu, 24 May 2001 12:52:02 -0500469_iso-8859-1 > Thanks to all for the info. Does anyone know if the 32/2Gig dataset limit > applies to V4 as well?
Yes.
> manual, but the HTML format of the V5 manual doesn't give page numbers and > trying to pull it up in PDF format gives me a blank window.
Go to the Adobe Web Site (www.adobe.com) and get the current 4.0 or 5.0 free PDF Reader. When you are down-leveled with the PDF reader, you get the blank window and other strange errors. [...]
11656 145 35_Re: The Virus is Back and much more14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Thu, 24 May 2001 13:00:15 -0500386_iso-8859-1 The DB2-L ListServe will be mirrored to a NewsGroup, organized by thread, and part of the DB2-L ListServe support within the next month. At that time, there will be a ListServe, a NewsGroup, Digests, and archives to fully support the DB2 Community, free, and without vendor influence.
Messages will be able to be posted to either the ListServer or the NewsGroup. [...]
11802 81 9_The Virus13_kathryn sears24_ksears@DPCONSULTANTS.COM31_Thu, 24 May 2001 14:02:35 -0400345_iso-8859-1 Thanks, Eric- My computer is feeling much better now-- I appreciate your taking up for me-- When we had to shut my system down, I just knew that when I got back into my email, I would have a lot of unhappy people getting in touch with me! Our anti-virus is really good at catching those things usually, but not his time. Kathryn [...]
11884 55 40_Migrate from CA-Datacom to DB2 questions12_Deb Thornton23_Deb.Thornton@ANTHEM.COM31_Thu, 24 May 2001 11:53:24 -0600576_iso-8859-1 I would like to hear from anyone who has been involved in migrating from CA-Datacom to DB2 (or vice versa). We are currently using Datacom on OS-390 and are considering converting to DB2. By the end of this year, we are expecting to double the volume of data on our database. By the end of 2002, we expect to double again. For example, we have numerous tables with 2+ million entries. We estimate that these tables will have 9 million entries by the end of 2002. There are concerns that the increased volume will significantly impact data access and therefore [...]
11940 68 18_Re: DB2 SUBSYSTEMS0_19_Tim.Lowe@STPAUL.COM31_Thu, 24 May 2001 13:26:06 -0500390_us-ascii Fred, Is there some reason that you cannot just use 2 jobs on the same subsystem to each process half of the data?
Thanks, Tim
Fred Hanes cc: Sent by: DB2 Subject: DB2 SUBSYSTEMS Data Base Discussion List
05/24/2001 10:06 AM Please respond to DB2 Data Base Discussion List [...]
12009 100 18_Re: DB2 SUBSYSTEMS10_Fred Hanes17_f_hanes@YAHOO.COM31_Thu, 24 May 2001 11:43:08 -0700301_us-ascii Users just want to see what the pros and cons are of Having Multi-pul subsystems on the same Lpar..
this is High activity data On line and Batch, Average number of Rows per table is over 100,000,000 with up to 124 partitions. 12 databases and all the garbage that goes with it... [...]
12110 110 13_Re: The Virus15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 24 May 2001 13:58:06 -0500506_iso-8859-1 Hi, Kathryn, This virus is very new, April of this year. Not all the anti-virus companies had it on their web sites yet. I found it on Symantec and McAfee but no others that I looked at.
Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services
"When you are courting a nice girl an hour seems like a second. When you sit on a red-hot cinder a second seems like an hour. That's relativity." -Albert Einstein On relativity [...]
12221 18 54_S04E and /or Return Code 8 on Call Attach in OS/390 V712_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Thu, 24 May 2001 14:12:33 -0500461_iso-8859-1 We are interested in exchanging information with anyone using OS/390 V7 DB2 where they are experiencing an S04E during a Bind or a return code 8 when attempting a call attach.
Gerald Hodge 281-265-3004
================================================ 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.
12240 17 28_Re: DB2 V6 maintenance level12_Joe Hartmann25_jhartman@MAIL.STATE.MO.US31_Thu, 24 May 2001 14:07:28 -0500297_- We are at Put 0012 and have been at this level for 3+ months and have had no problems. I just received Put 0104 today and plan on putting this on our test system next week and production in couple of months.
Joe Hartmann State of Missouri State Data Center jhartman@mail.state.mo.us [...]
12258 47 58_Re: S04E and /or Return Code 8 on Call Attach in OS/390 V716_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 24 May 2001 15:32:25 -0400392_iso-8859-1 We got RC=8 on Call Attach when we upgraded. The REASON CODE was 00C10831. The reason was that the CAF module in SDSNLOAD in the STEPLIB of the subsys was V7, the user job had no STEPLIB or JOBLIB, and was therefore getting its CAF module from a V5 library which was in LLA. Adding //STEPLIB DD DISP=SHR,DSN=???? where ???? was the name of the V7 SDSNLOAD solved the problem. [...]
12306 91 46_Re: [Migrate from CA-Datacom to DB2 questions]13_Larry Findley17_llfindley@USA.NET29_Thu, 24 May 2001 14:28:20 CDT660_US-ASCII Hi Deb,
I will offer two sites:
http://www.longgrasssystems.com.au
http://www.isi.com.au
They market a set of products that are specifically for migration from DATACOM to DB2. _______
I spent 8 years at a company that used DATACOM and is now in the process of migrating to DB2. Among the reasons were the ability to connect to diverse DBMS's on various platforms, the greater availability of developers, and the consensus that DB2 is a much more robust product. They were using both COBOL and CA-DATACOM for development. You didn't mention which language your shop is using. Neither one should be a problem for [...]
12398 44 28_Re: SQL statement terminator9_Wu, James13_jwu@KRAFT.COM31_Thu, 24 May 2001 14:55:05 -0500717_koi8-r I know how to fix the problem in SPUFI: you have to change the default option 'SQL terminator' from ';' to '#'.
James Wu:-)
(847)646-5548 jwu@kraft.com
-----Original Message----- From: Jelena Vladisavljevic [mailto:molten@eunet.yu] Sent: Thursday, May 24, 2001 1:22 PM To: DB2-L@RYCI.COM Subject: SQL statement terminator
Hi, I work with DB2 UDB V5.2 for Win NT and I need make trigger with begin atomic- end part.I change in Tool settings statement terminator to #,but in Command center I got SQL0104N An unexpected token "" was found following "". Expected tokens may include: "" when I try create trigger example from CREATE [...]
12443 22 20_SYNC I/O & ASYNC I/O23_Vivekananthan Ettiappan18_vivdb2@HOTMAIL.COM31_Thu, 24 May 2001 21:18:27 +0100579_- Dear group,
Can some one explain what is SYNCHRONOUS READ/WRITE and ASYCHRONOUS READ/WRITE?.. Also the corresponding I/O wait times?.
Advanced thanks,
Regards, Vivek. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12466 151 18_Re: DB2 SUBSYSTEMS0_19_Tim.Lowe@STPAUL.COM31_Thu, 24 May 2001 15:24:05 -0500462_us-ascii Fred, Someone may contradict me, but I don't see ANY benefit of using a second subsystem on the same Lpar to process half of your data. Likewise, data sharing on the same Lpar would provide no benefit. (there are cases in data sharing recovery where this would be necessary for a short time, but not permanently.) If you are on the same lpar, then the best solution is probably to just run 2 jobs at the same time to each process half of the data. [...]
12618 85 85_Re: 2-tier access to DB2 for update without giving users direct u pdate authority ...8_K.Balaji19_K.Balaji@TARGET.COM31_Thu, 24 May 2001 15:32:36 -0500373_iso-8859-1 Andy, Nice to talk to you again. My question is do we have static sql support for other sql's we right from ASP? Thanks
-----Original Message----- From: Andy Seuffert [mailto:aseuffert@NEONSYS.COM] Sent: Wednesday, May 02, 2001 7:34 AM To: DB2-L@RYCI.COM Subject: Re: 2-tier access to DB2 for update without giving users direct u pdate authority ... [...]
12704 70 58_Re: S04E and /or Return Code 8 on Call Attach in OS/390 V712_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Thu, 24 May 2001 15:37:21 -0500355_iso-8859-1 I agree about the steplib and the mismatch that can occur. We have had several people check for that, but I'll check again. This happens only with certian DBRMs and not others. We can not distingish the DBRMs that work form the ones that have the problem.
When we find this I'll post it, even if it means admitting I did something. [...]
12775 55 24_Re: SYNC I/O & ASYNC I/O11_Bikash Paul19_bikash_db@YAHOO.COM31_Thu, 24 May 2001 13:38:53 -0700272_us-ascii Hi, If I/O is done asynchously (READ into BP /WRITE from BP), then the process does not wait for I/O to be completed. To minimise wait time for SQL operation, it is good if we can avoid synchronous I/O (As it makes the process wait for I/O to be completed). [...]
12831 186 18_Re: DB2 SUBSYSTEMS11_Bikash Paul19_bikash_db@YAHOO.COM31_Thu, 24 May 2001 13:45:04 -0700420_us-ascii Hi, I completely agree with you, tim. I just mentioned data sharing as talk of using two DB2 subsystems were going on. I strongly feel that the big tables should be partitioned and 2 jobs/even more no of jobs can run in parallel to process the table data without no/minimum contention. If partitioning key is choosen well and Data is distributed across multiple DASD devices having separate channel paths. [...]
13018 119 38_Re: DB2 Addressing beyond 2Gigs memory12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Thu, 24 May 2001 15:52:07 -0500388_iso-8859-1 An interesting question ...
First, Z/OS will address more than 2GB via its 64 bit addressing architecture. However, the fine print is always the catch.
There are now three levels of memory to be concerned about -- the two dividing lines are the 16MB "Line" and the 2GB "BAR". So you have "below the line", "between the line and the bar" and "above the bar". [...]
13138 20 20_DB2 Stored Procedure15_Louis.Commodore26_Louis.Commodore@TARGET.COM31_Thu, 24 May 2001 15:38:56 -0500378_iso-8859-1 Dear Group I understand that IBM does not support Intermediate commits in stored procedures for MVS system in Version 5 and allowed application program to issue commit/rollback or depending on commit_on_return parameter. I have a requirement where I am going to process quite a few records and I want to commit at intermediate points. How can this be achieved ? [...]
13159 64 21_Collecting Statistics10_Alan Smith25_alancsmith@BTINTERNET.COM31_Thu, 24 May 2001 22:47:21 +0100564_us-ascii Yes, I've found that CPU usage for these jobs is absolutely enormous, even if you specify 'fast' collection, which doesn't look in the bufferpools. We run collects once a week and then reorgs during the week. If something gets reorged, there is a collection step after it to collect stats just for that object. You can add other conditions into a PDA table to make it look at runstats or something else instead - this is a bit of assembler. Haven't tried this. My personal view is that the time I spend frigging about with PDA, I could've created my [...]
13224 53 16_DB2 Table Design17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Thu, 24 May 2001 17:11:31 -0700584_us-ascii I have a question regarding the best alternatives for designing a table(s) with the following characteristics:
Account_number RSK_1 to RSK_28 ColA_1 to ColA_28 ColB_1 to ColB_28 ColC_1 to ColC_28 . . ColJ_1 to ColJ_28
As you can see there will be 28 iterations each for columns A through J and RSK. Each iteration will contain a new value that is updated quarterly with 1 being the latest and 28 being the oldest (7 years worth of info). This will result in every quarter all the values shifting over by one, i.e. value in 28 will be replaced by the value [...]
13278 46 19_Re: UDB DB Packages10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 25 May 2001 10:40:36 +1000636_us-ascii Peter,
I am not sure if this is what u r looking for, but in the "Installing and Using DB2 Clients for Solaris' manual, there is a Binding Database Utilities section, where there is some infm abt the packages used. Check the foll. site if needed.
http://www-4.ibm.com/cgi-bin/db2www/library/document.d2w/report? uid=UNKNOWN&pwd=&search_type=SIMPLE&r_host=UNKNOWN&last_page=sqlj50043.h tml&fn=sqlj50061.html#HDRBINDLST
Cheers, Kals
-----Original Message----- From: Krawetzky, Peter J [SMTP:KrawetzkyPJ@AETNA.COM] Sent: Thursday, May 24, 2001 10:27 PM To: DB2-L@RYCI.COM Subject: UDB DB Packages [...]
13325 158 53_Re: PROVIDE UDF (USER DEFINE TUNCTION) SAMPLE PROGRAM10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 25 May 2001 11:42:45 +1000420_us-ascii Tang,
Here is a simple UDF which accepts a CHAR input parameter and returns a CHAR result. U can execute the UDF using
SELECT MYUDF('xxx') from sysibm.SYSDUMMY1
where 'xxx' is any input. The o/p from the query will be 'ABC'.
U can execute any SQLs (including call SPs) from within the UDF.
The App. Pgm Guide has an example of the code in the UDF's section. (Chapt 4.3). [...]
13484 17 9_mergecopy8_21cn.com15_yanjsn@21CN.COM31_Fri, 25 May 2001 09:46:22 +0800348_GB2312 If I have 3 incremental image copy 1,2,3, can I merge 1 & 2 only?
Thank you
Jason Yan
================================================ 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.
13502 103 20_Re: DB2 Table Design11_Bikash Paul19_bikash_db@YAHOO.COM31_Thu, 24 May 2001 21:28:56 -0700391_us-ascii Hi, Just i thought that ,
May be , you can have a table like as follows 1) Account_number 2) Year 3) Quater 4) Rsk 5) COLA ...... ...... 12) COLJ
For a given account and a year, there will be 4 rows and for 7 years, 28 rows.
There is no need to push the data across colums. Once a quater data ages more than 7 years, a row for an account will get deleted. [...]
13606 12 4_test15_Priyanka Deswal19_prdeswal@IN.IBM.COM31_Fri, 25 May 2001 10:01:48 +0530255_us-ascii test
================================================ 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.
13619 14 53_William L Exline/GL/KSC/KeyCorp is out of the office.11_Bill Exline28_William_L_Exline@KEYBANK.COM31_Fri, 25 May 2001 01:02:15 -0400365_us-ascii I will be out of the office from 05/24/2001 until 05/29/2001.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
13634 187 18_Re: DB2 SUBSYSTEMS9_Ray Price18_Ray.Price@DRKW.COM31_Fri, 25 May 2001 06:45:30 +0100334_iso-8859-1 Well, I may be wrong here, but if you run Data Sharing on two LPAR's doesn't that allow you to increase DB2 availability, as you can close the two DB2 sub-systems independently, and even upgrade versions, without losing service.
Not applicable in this case, I know, but interesting for people looking for 24x7. [...]
13822 23 39_Order By Clause as a variable parameter8_K.Balaji19_K.Balaji@TARGET.COM31_Fri, 25 May 2001 01:22:39 -0500319_iso-8859-1 Hi all, We have a requirement where depending on the columns clicked by the user in the report screens the rows will by that column. (For example our mails can be arranged either in data or subject etc). For this actually we are issuing different SQLs just by changing the Order By clause for each SQL. [...]
13846 25 24_Re: SYNC I/O & ASYNC I/O10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 25 May 2001 08:29:54 +0200546_us-ascii Hi...
There's a quite good article by Bonnie Baker in db2mag explaining this topic:
http://www.db2mag.com/db_area/archives/1999/q3/prog.shtml
As usual Bonnie Baker describes very clearly the concept. I'd like to be so clear as she is....
HTH
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.
13872 43 43_Re: Order By Clause as a variable parameter16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 25 May 2001 12:20:45 +0530572_- You have to code the dynamic sql for that. It looks best as per your requirement.
Regards Sanjeev
> -----Original Message----- > From: K.Balaji [SMTP:K.Balaji@TARGET.COM] > Sent: Friday, May 25, 2001 11:53 AM > To: DB2-L@RYCI.COM > Subject: Order By Clause as a variable parameter > > Hi all, > We have a requirement where depending on the columns clicked by the user > in > the report screens the rows will by that column. (For example our mails > can > be arranged either in data or subject etc). For this actually we are > issuing > different SQLs [...]
13916 30 64_Re: Stored procedures and RRSAF - Authorization problems Thanks.17_Massimo Biancucci30_Massimo.Biancucci@T-SYSTEMS.IT31_Fri, 25 May 2001 08:45:06 +0100466_us-ascii Tnx to all folks who answer !
Anyway the main reason of my unsuccesully trying was a missing refresh from RACF guy.
Massimo Biancucci Technical Engineering Mainframe Technical Support-database T-Systems Italia debis IT Services Italia S.p.A. Via degli Ontani, 25 36100 - Vicenza (VI) Phone: +39 0444558110 Fax: +39 0444558232 Mobile: +39 3482558906 e-mail: Massimo.Biancucci@t-systems.it Internet: http://www.t-systems.it [...]
13947 55 43_Re: Order By Clause as a variable parameter15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Fri, 25 May 2001 16:42:29 +1000466_- Once upon a time I reluctantly forced a developer to code 20 SQL statements, each identical to each other except for the 'order by' clause, because I didn't want my perfect 'static SQL only' environment sullied by such things. It seemed at the time, and even more so now, that the better - or at least alternative - way would have been to build the SQL statement dynamically based on what the user has said their returned row order is, prepare it and run it. [...]
14003 70 43_Re: Order By Clause as a variable parameter11_Roland Chua18_rolandchua@SGX.COM31_Fri, 25 May 2001 15:03:01 +0800689_us-ascii I think you might want to consider coding using Dynamic SQL.
"K.Balaji" cc: Sent by: DB2 Subject: Order By Clause as a variable Data Base parameter Discussion List
25/05/2001 02:22 PM Please respond to DB2 Data Base Discussion List
Hi all, We have a requirement where depending on the columns clicked by the user in the report screens the rows will by that column. (For example our mails can be arranged either in data or subject etc). For this actually we are issuing different SQLs just by changing the Order By clause for each [...]
14074 51 61_Re: UDB Script Centre vs Windows Task Scheduler vs AT command11_Phil Button18_BUTTONP@UK.IBM.COM31_Fri, 25 May 2001 09:15:57 +0100314_us-ascii Hi Richard
It could be some form of contention, but one thing that I've had problems with on NT is permissions - remember that anything run under AT will run under SYSTEM user which will have different file access permissions than your own userid. Other schedulers tend to have similar rules. [...]
14126 55 18_Re: Reuse of Space0_18_mebert@AMADEUS.NET31_Fri, 25 May 2001 10:52:43 +0200575_us-ascii Hello Mike,
from recent experience with a similar design I found out that DB2 will reuse the free space in the tablespace, but not in the ascending sequence index. This means your TS will grow to the size needed to store 90 days of data, but the index will continue growing. Further findings: the data will remain highly clustered (you will essentially have two chunks of sorted data). So if you do an Index REORG every month, it would be about 35% bigger than strictly required, but that's not a big amount, and you'd have very well organised data with [...]
14182 72 61_Re: UDB Script Centre vs Windows Task Scheduler vs AT command12_rl_cotterill24_rl_cotterill@BIGPOND.COM31_Fri, 25 May 2001 19:07:50 +1000310_us-ascii Phil, Thanks for the reply. It is even getting worse.
The tasks appear to run bu do not execute. I am running a .BAT file which runs a REXX.
Where it is getting worse is that at work I can get the AT and TASK Scheduler working but not the UDB SCHEDULER. At home it is the opposite. [...]
14255 18 18_Re: DB2 SUBSYSTEMS13_Thomas Schulz20_thomas.schulz@SVI.DE31_Fri, 25 May 2001 05:54:21 -0500464_- Hi fred
i think the best will be a partitioned Tablesspace with your customer table in it. With the partitioned Index you can seperate your e.G. Customer number from 0 to 100000 and 1000001 to ......
Thomas
================================================ 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.
14274 21 13_Re: mergecopy13_Thomas Schulz20_thomas.schulz@SVI.DE31_Fri, 25 May 2001 06:01:34 -0500372_- Hi Jason
yes, you can
mergecopy tablespace db.ts copyddn (copy1,copy2) newcopy no
should work
thomas
================================================ 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.
14296 47 18_Re: DB2 SUBSYSTEMS10_Fred Hanes17_f_hanes@YAHOO.COM31_Fri, 25 May 2001 05:02:41 -0700601_us-ascii The database (12) of them currently have 12 to 45 table spaces with up to 124 partitions each clustered fully indexed.
We just want to nnow if using multipul Production subsystems would (I know it would) increase performance at what cost
CPU cost goes up but does thru-put go up/////
--- Thomas Schulz wrote: > Hi fred > > i think the best will be a partitioned Tablesspace > with your customer table in it. > With the partitioned Index you can seperate your > e.G. > Customer number from 0 to 100000 and 1000001 to > ...... > [...]
14344 66 20_Re: DB2 Table Design17_Polley, Mike (M.)16_mpolley@FORD.COM31_Fri, 25 May 2001 08:04:39 -0400412_iso-8859-1 This is just another idea to ponder or maybe provoke some other solution: You could add a sequence number, and each quarter add +1 followed by the insert of the new row with seq# 1. Deleting unused rows would be simple. HTH
-----Original Message----- From: Charles Jambrosic [mailto:CJambrosic@CSIHOME.COM] Sent: Thursday, May 24, 2001 8:12 PM To: DB2-L@RYCI.COM Subject: DB2 Table Design [...]
14411 163 35_Re: The Virus is Back and much more11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Fri, 25 May 2001 08:24:34 -0400398_iso-8859-1 Richard,
Have you considered one of the bulletin board systems ? I use and moderate on www.mvshelp.com and find that format very useful. I don't think they are too much trouble to set up. I also like to able to follow the "thread" of a discussion. I do use Newsgroups and that is better than email but some ISPs (and some employer companies) do not support/allow newsgroups. [...]
14575 113 18_Re: DB2 SUBSYSTEMS0_19_Tim.Lowe@STPAUL.COM31_Fri, 25 May 2001 08:31:43 -0500405_us-ascii Fred, How do you "know" that multiple production subsystems would increase performance?
What is the problem that you are trying to solve? And, what are you thinking of doing with multiple subsystems that would increase performance? If both subsystems are run on the same lpar, how do you think that you would increase performance? (wouldn't they just compete for the same resources?) [...]
14689 91 15_0C4 in USS/Java12_David Booher22_David.Booher@QUEST.COM31_Fri, 25 May 2001 06:50:28 -0700454_iso-8859-1 I am running 2.10 with Java 1.1.8.
In the setup, you are instructed to run a script called db2genJDBC in preparation to use Java Stored Procedures. When java is called from this script [or any script] and 0C4 abend occurs and the following console messages are produced:
+CEE0374C CONDITION = CEE3204S TOKEN = 00030C84 59C3C5C5 00000000 768 WHILE RUNNING PROGRAM scanThread WHICH STARTS AT 0953AB30 AT THE TIME OF INTERRUPT [...]
14781 96 43_Re: Order By Clause as a variable parameter0_26_JCameron@MSI-INSURANCE.COM31_Fri, 25 May 2001 08:47:37 -0500549_us-ascii We had a programmer create a global temporary table of about 20 columns all defined as CHAR(50). He populated each column in order by the way the user requested them, then selected from the global temp table always ordering by 1,2,3 ....
It worked for him.
JCameron@msi-insurance.com 651.631.7188
"Bell, Raymond W" cc: Sent by: DB2 Data Base Subject: Re: Order By Clause as a variable parameter Discussion List [...]
14878 106 46_Re: [Migrate from CA-Datacom to DB2 questions]15_Gary Fahrlander28_gary.fahrlander@ZURICHNA.COM31_Fri, 25 May 2001 09:45:49 -0500425_us-ascii I am also interested in migration from CA-Datacom to DB2 products. Has anyone got further information besides the two links listed below? If you are a vendor, thanks in advance for responding off-list. If you are a conversion survivor I'd like to know how the experience went.
The Answer to the Great Question Of....Life, the Universe and Everything....Is....Forty-two. Hitch Hiker's Guide to the Galaxy [...]
14985 28 19_DB2 Connect Problem18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Fri, 25 May 2001 10:50:20 -0400507_iso-8859-1 Was wondering if anyone else has noticed this situation.
We are running stored procedures on OS/390 (DB2 v6.1) via the stored procedure builder successfully with the correct results being returned. What we have noticed is the connections are maintaining shared locks on both the tablespace and the table that was queried in the stored procedure. These locks are maintained for approximately 10 minutes before they disappear. Once and a while they will go into a "disconnected" state. [...]
15014 27 13_Re: mergecopy8_21cn.com15_yanjsn@21CN.COM31_Fri, 25 May 2001 23:20:16 +0800493_GB2312 Isn't COPYDDN the output dataset? what I want to do is merge the increamental image copy 1 & 2 from 1 2 3
Rgds,
Jason
>Hi Jason > >yes, you can > >mergecopy tablespace db.ts >copyddn (copy1,copy2) >newcopy no > >should work
================================================ 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.
15042 60 23_Re: DB2 Connect Problem12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Fri, 25 May 2001 11:09:22 -0400492_us-ascii Discussed on list recently.
If your implementation is similar to ours, you should try defining your stored procedures with COMMIT ON RETURN; you will probably find it advantageous to code all cursors as WITH HOLD in this case, otherwise no result set(s)...
Gregg Sawyer
"Krawetzky, Peter J" @RYCI.COM> on 05/25/2001 10:50:20 AM
Please respond to "DB2 Data Base Discussion List" [...]
15103 81 58_Re: S04E and /or Return Code 8 on Call Attach in OS/390 V714_Philip Gunning23_pgunning@GUNNINGTSI.COM31_Fri, 25 May 2001 11:04:32 -0500557_us-ascii Gerald, Saw you at IDUG but did not have a chance to say hi. I tried to talk to all listserv members when I recognized a name or saw a brown ribbon. Cheers! Phil > >From: Gerald Hodge >Date: Thu, 24 May 2001 15:37:21 -0500 >To: DB2-L@RYCI.COM >Subject: Re: S04E and /or Return Code 8 on Call Attach in OS/390 V7 > >I agree about the steplib and the mismatch that can occur. We have had >several people check for that, but I'll check again. This happens only with >certian DBRMs and not others. We can not distingish the [...]
15185 196 35_Re: The Virus is Back and much more14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Fri, 25 May 2001 12:06:52 -0500483_iso-8859-1 Yes, considering Internet BB as well as NewsGroup. If we can extend and mirror to all 3, that will be done.
Regards, Richard
Richard Yevich - Principal Yevich Lawson & Assoc. Inc. (YL&A) IBM DB2 and Sysplex Gold Consultant IBM Certified Solutions Expert: DB2 V7.1 Database Administration for OS/390 Richard_Yevich@YLAssoc.com 1-888-246-5049/1-217-744-0000 http://www.YLAssoc.com -- DB2 Performance Journal http://www.db2-symposium.com -- DB2 Symposiums [...]
15382 201 34_NYC DB2 TRIDEX Meeting - June 21st11_Gerri Lloyd17_glloyd@US.IBM.COM31_Fri, 25 May 2001 13:18:14 -0400393_iso-8859-1 Dear Tridex Members,
Please distribute the meeting notice to other people in your company who may wish to attend. We will not be mailing out a flier for this and future meetings due to the time and cost associated with direct mailing.
Thanks, Nate
TRIDEX Tridex Quarterly User Group Meetings DON'T JUST KEEP UP - STAY AHEAD! All Meetings are FREE. [...]
15584 33 35_"bad unique index flag" on nickname14_Lunn, Margaret31_Margaret.Lunn@MORGANSTANLEY.COM31_Fri, 25 May 2001 13:51:59 -0400463_iso-8859-1 Has anyone else had a problem creating federated nicknames on tables with "unique where not null" indexes? We get this error:
DB21034E The command was processed as an SQL statement because it was not a valid Command Line processor command. During SQL processing it returned: SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "bad unique index flag".) SQLSTATE=58004 [...]
15618 34 21_Index with LPL Status13_Moss, William15_MossW@AETNA.COM31_Fri, 25 May 2001 14:28:34 -0400656_iso-8859-1 We recently had an index with an LPL status as shown below.
DSNB250E *DB3E DSNKUNR2 A PAGE RANGE WAS ADDED TO THE LOGICAL PAGE LIST DATABASE NAME=DSE2P000 SPACE NAME=XE2A0016 DATA SET NUMBER=1 PAGE RANGE X'00000000' TO X'FFFFFFFF' START LRSN=X'B5E3109F035B' END LRSN=X'B5E3109F035B' START RBA=X'08B89F0F8B77'
Does the PAGE RANGE X'00000000' TO X'FFFFFFFF' mean that the entire index needs to be rebuilt ? We initially did a Start on the index and waited and waited for a completion message, but never got one. After waiting two hours, we rebuilt the index, which resolved the LPL status. Should we have done the rebuild first [...]
15653 118 17_job opportunities17_Charlene Saunders33_csaunders@PALLADIANCONSULTING.COM31_Fri, 25 May 2001 11:37:25 -0700606_iso-8859-1 Dear Colleagues, Palladian Consulting, a company built on foundations of teamwork, industry knowledge, dedication & discipline and a leader in RDBMS consulting is currently seeking to hire a team of six professionals to work on a long-term contract in Texas. The team will consist of one (1) Project Manager, one (1) Project Leader and four (4) consultants. Consultant must have programming knowledge and experience with DB2, Cobol, TSO, JCL and CICS. Experience in maintaining and supporting production applications with a background in governmental accounting systems is greatly desired. [...]
15772 103 38_JDJ Reader's Choice Awards 2001 Survey13_Morrill, John12_JohnM@VP.NET31_Fri, 25 May 2001 14:12:21 -0600493_- Friends,
As a follow-up to my bulletin in March, below, Java Developer's Journal's fourth annual Readers' Choice Awards poll will close on May 31, 2001. If you haven't voted yet, please do so now. Thanks!
Regards, Mike
Dear DB2 Interested Parties,
Java Developer's Journal (JDJ) is currently conducting an online survey for their "2001 Reader's Choice Awards". "Best Enterprise Database" (a new category this year) is category 18 (of 23 categories). [...]
15876 163 25_Re: Update statement help8_K.Balaji19_K.Balaji@TARGET.COM31_Fri, 25 May 2001 15:05:59 -0500380_iso-8859-1 Hi all, I was trying to issue the following update sql to update a column of one row to the column of another row. But this is giving error. I am not sure whether we can execute this sql in DB2 Version 5.
UPDATE SYSIBM.SYSPROCEDURES SET PARMLIST = (SELECT PARMLIST FROM SYSIBM.SYSPROCEDURES WHERE PROCEDURE = 'procedure01') WHERE PROCEDURE = 'procedure01'; [...]
16040 216 25_Re: Update statement help11_Moore, Tony15_TMoore@IKON.COM31_Fri, 25 May 2001 16:46:41 -0400412_iso-8859-1 Balaji, I tried this (just for kicks) in V4 and found it does not work there either. I went to the SQL Reference manual for V4, V5 and V6 and found that the SET clause does not accept a subselect until V6.
HTH, Tony Moore
-----Original Message----- From: K.Balaji [mailto:K.Balaji@TARGET.COM] Sent: Friday, May 25, 2001 4:06 PM To: DB2-L@RYCI.COM Subject: Re: Update statement help [...]
16257 180 25_Re: Update statement help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Fri, 25 May 2001 15:51:22 -0500385_iso-8859-1 K. Balaji,
Firstly, SET clause contains a subquery of which the capability was introduced in V6 (I do not recall a V5 APAR because this was introduced in the May 200 Refresh).
Secondly the UPDATE is self-referencing, which is not allowed until V7. The SQL you sent also attempts to update the PARMLIST with the same parmlist, which I assume to be a typo. [...]
16438 33 24_Left Outer Join Question13_Dana Maxfield23_DMaxfie@DOA.STATE.LA.US31_Fri, 25 May 2001 16:09:45 -0500375_iso-8859-1 My question is this, in DB2 6.1 the following statement works for a full outer join and a right outer join. When I try it with a left outer join the right column values are returned null. What could cause this?
SELECT T1.one, T1.two, T1.three, T2.four, T2.five FROM T1 left OUTER JOIN T2 ON T1.one = T2.one AND T1.two = T2.two AND T1.three = T2.three; [...]
16472 17 36_Re: Dynamic SQL and CPU usage report6_Chenny39_solaiyappan_chenniappan@MAIL.AMSINC.COM31_Fri, 25 May 2001 16:01:46 -0500438_- Roger,
Thanks for your input and I requested our system folks to apply the corresponding PTF's as you suggested in your previous mail.
Chenny DB2/Oracle DBA U.S.Dept of Agriculture
================================================ 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.
16490 202 25_Re: Update statement help8_K.Balaji19_K.Balaji@TARGET.COM31_Fri, 25 May 2001 16:40:10 -0500465_iso-8859-1 Hi Terry/Tony,
I thought so. It may not be there in V5. But still I wanted to confirm this. V5 manuals have listed upto expressions but not sub-select.
Global temp table - that suggestion looks good.
Thanks for you quick reply.
Regards Balaji
-----Original Message----- From: Terry Purcell [mailto:Terry_Purcell@YLASSOC.COM] Sent: Friday, May 25, 2001 1:51 PM To: DB2-L@RYCI.COM Subject: Re: Update statement help [...]
16693 36 18_Re: PARAMDEG Zparm12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 25 May 2001 17:21:11 -0500626_- Here is some motherhood and some information that is probably new.
The first key for parallelism is having the resources (cpu, memory, IO) to provide better response. You indicated that the cpu and storage resources are tight. The design point for parallelism is large queries where the response times can be shortened. In general, plans that should be running with subsecond response time are not suited to parallel processing. Do you have the needed resources? Are you reducing the elapsed times? If you don't have resources, then you can make the situation worse, adding in some overhead without getting much [...]
16730 14 58_Re: S04E and /or Return Code 8 on Call Attach in OS/390 V712_Roger Miller19_millerrl@US.IBM.COM31_Fri, 25 May 2001 17:45:48 -0500438_- What's the abend reason code? Without that, the search criteria gets too many hits. With it, maybe I can pay you back for my free ride to IDUG from the airport.
Roger Miller, DB2 for z/OS
================================================ 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.
16745 20 24_Re: DB2 Stored Procedure12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 25 May 2001 18:10:38 -0500376_- COMMIT in a stored procedure is part of V7. With V6, there is a construct called a savepoint - that does allow rollback to specific points. Savepoints are not COMMITs in the sense of releasing locks. Your wording confused me "intermediate commits". COMMIT in a stored procedure commits everything in the unit of work - client changes, changes in stored procedures, ... [...]
16766 20 20_Re: DB2 Table Design12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 25 May 2001 18:18:51 -0500421_- Here are a couple of thoughts. It looks as though those records will be fixed length. Having all 7 years will mean much longer records and will slow down the reading and updating. If the nightly inquiries are mostly for the four quarters, then that's probably a good design. If you almost always need four quarters of data, then this denormalization is typical, rather than having a separate row for each quarter. [...]
16787 15 44_Pamela Harris/IT/SEARS is out of the office.0_17_pharri1@SEARS.COM31_Sat, 26 May 2001 02:10:19 -0500451_us-ascii I will be out of the office from 05/25/2001 until 05/29/2001.
For DB2 page PIN # 7270526, for informix/sqlserver page PIN # 7270525, for network/netfinity print page 18007598352, PIN # 7271038.
================================================ 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.
16803 44 30_Error Handling in DB2 Triggers13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Sat, 26 May 2001 18:05:56 +0500760_- Dear List Members,
I am migrating some Oracle Triggers to DB2 and wanted to know if it is possible to have error handling in the DB2 Triggers. for example I have a very simple trigger from Oracle. Could you please suggest how could I do the same in DB2.
create or replace trigger tub_cp_organization before update on CP_ORGANIZATION for each row declare l_num number(10); l_mes varchar2(100); begin -- check for not valid id if not (checks_pack_v30.Is_Signed_ID_OK(:new.cpor_id, l_num, l_mes)) then raise_application_error(-l_num, Get_Message_Text(to_char(l_num))); end if; begin :new.last_update := Time_Conversions.Convert_To_GMT(sysdate); exception when others then raise_application_error(-20028, Get_Message_Text('20028')); end; end; [...]
16848 69 28_Re: Left Outer Join Question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sat, 26 May 2001 11:11:45 -0500336_iso-8859-1 Dana,
Unless I am reading your problem incorrectly, the LEFT OUTER JOIN is functioning correctly. In your example, all rows from the left table, T1, will be returned. Those rows which have a match on the three join columns in the right table, T2, will be returned. Unmatched rows in T2 will be padded with NULLs. [...]
16918 24 7_segsize12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Sat, 26 May 2001 14:03:46 -0500616_iso-8859-1 Is there some guidance on segsize? I searched the archives and found Roger Miller's email quoting DonHaderle "If it's large, it should be partitioned. If not, it should be segmented." We have done that.....
However, I was explaining a performance problem to someone (two large tables joined together to another small table - the two large tables joined together get good performance but when the third small table is added to the query - it is slow, runstats are good and explain shows nothing unusual) and they suggested that my small table had an incorrect segsize integer. TIA, Louise Reid [...]
16943 100 25_Re: Index with LPL Status15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Sat, 26 May 2001 22:34:11 +0100568_us-ascii Hi Bill,
The Messages and Codes manual suggests using either a '-START DATABASE(dbname) SPACENAM(tsname)' or using the RECOVER or LOAD Utilities, depending on the type of object involved.
Being young and reckless, I'd have recovered the INDEX, as a matter of course (obviously, circumstances permitting...).
I can't find any specific reference to the page range (v5 Manual, though...), seems reasonable to assume that, in your example, this value represents the whole INDEX (as opposed to a specific range of pages in a tablespace). [...]
17044 58 11_Re: segsize13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sat, 26 May 2001 16:47:36 -0500364_iso-8859-1 Louise,
With regard to SQL performance tuning, the last thing I would look at would be the SEGSIZE. It is more likely to do with poor table join sequence, different clustering between tables, non-indexed or index screening predicates doing the majority of filtering etc.
Explain usually does not show anything unusual anyway......... [...]
17103 78 43_Re: Order By Clause as a variable parameter25_Robinson, Peter [IBM GSA]33_Peter.J.Robinson@TEAM.TELSTRA.COM31_Mon, 28 May 2001 11:08:00 +1000493_- Hmm, never tried this and it's only a half-formed idea at the moment.
You might be able to build, through a case statement, an extra field to do the order by. It would be a sort-of-dynamic version of the static ones because by changing the value of a host variable, you could change which columns get populated into the extra column, thereby changing the sort key. It may not perform as required because of the final sort, but may be ok depending on the size of your result set. [...]
17182 24 56_Shan Leatherman/MO/americancentury is out of the office.0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Sun, 27 May 2001 21:24:41 -0500493_us-ascii I will be out of the office from 05/21/2001 until 05/29/2001.
I will be in a class at the Marriott Monday - Wednesday and out of the office the remainder of the week. I will be on vacation on Sunday(my normal work day) and Monday is a holiday so I won't be returning til next Tuesday 5/29/01. I will check messages early each morning, so if your answer can wait a day I'll respond by the next day. If you need TSI support, contact Dave Maine(DMA) or send a message to *DB [...]
17207 15 52_Terry Gawlas/ISG/CORP/Highmark is out of the office.12_Terry Gawlas25_terry.gawlas@HIGHMARK.COM31_Mon, 28 May 2001 01:09:41 -0400386_us-ascii I will be out of the office starting 05/25/2001 and will not return until 05/29/2001.
I will be out of the office 5/25 and 5/28.
================================================ 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.
17223 27 53_Ganesh Seetharaman/gseeth1/DFSI is out of the office.18_Ganesh Seetharaman39_ganeshseetharaman@DISCOVERFINANCIAL.COM31_Mon, 28 May 2001 01:22:14 -0500348_us-ascii I will be out of the office starting 05/26/2001 and will not return until 06/03/2001.
I will be out of Office from 05/28/01 to 06/03/01.
In case of Emergency or On site Issues, you can contact Concerned Secondary DBA's :
Jang Lee x1281 - Debt Manager/ Collections Atwal Sukhmel X1190 - NCS Raimond X3561 - Falcon [...]
17251 28 25_Re: Index with LPL Status10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 28 May 2001 10:10:57 +0200494_us-ascii Hi Bill.....
Take a look at APAR:
PQ30839 (This is a V6 APAR).
There's an APAR:
PQ02084
dealing with your error, but it's a very old APAR and it's for V4 & V5.
HTH
Max Scarpa DB2 Sysprog
================================================ 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.
17280 56 19_DSNREXX performance12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 28 May 2001 11:48:39 +0200414_iso-8859-1 Hi,
We have many REXX programs that access DB2. Usually we use our "home grown" program to do it. When DSNREXX was introduced we started to check it in order to decide when & where it can replace our "home grown" program.
The results were interesting:
In SELECT statements (which are about 90% of SQL for what we use REXX-DB2) the DSNREXX is a horrible performer, for example: [...]
17337 89 25_AW: Collecting Statistics12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Mon, 28 May 2001 11:01:03 +0200576_iso-8859-1 Hi Michelle,
sorry for jumping in late here, but I was out of the office last week. Collecting statistics with a regular scan means that PDA also makes consistency checks (many lines of code through the CPU). To see the results of these checks, have a look at the Log Reporting. As Alan already mentioned, you can reduce time when you chose the fast scan option, which avoids the consistency checks. Performance gains vs. regular scan when the number of pages is greater than 10000. Space map scan is faster than fast scan, but you lose some of the PDA [...]
17427 28 25_Re: Update statement help16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 28 May 2001 17:25:14 +0530464_- Is there something wrong with the actual update statement or i am missing something. I am recoding it....i.e copy/paste from Balaji's mail
UPDATE SYSIBM.SYSPROCEDURES SET PARMLIST = (SELECT PARMLIST FROM SYSIBM.SYSPROCEDURES WHERE PROCEDURE = 'procedure01') WHERE PROCEDURE = 'procedure01';
It updates the PARMLIST for 'procedure01' with the value which is there for 'procedure01' . It seems we should have some different PROCEDURE somewhere. [...]
17456 127 43_Re: Order By Clause as a variable parameter12_Deluca, Fred27_Fred.Deluca@CCRA-ADRC.GC.CA31_Mon, 28 May 2001 09:59:41 -0400699_iso-8859-1 Just to add to the half-formed idea, you could add a case statement to the original case statement in the following fashion to get ascending or descending depending on a host variable :hv2...
Select Date, Subject, ... morecolumns...., case :hv when "DATE" then case :hv2 when "DESC" then x'FFFFFFFF' - hex(char(Date)) else char(Date) when "SUBJECT" then case :hv2 when "DESC" then x'FFFFFFFF' - hex(Subject) else Subject when "SUBJECT-DATE" then case :hv2 when "DESC" then x'FFFFFFFF' - hex(concat(Subject,char(Date))) else concat(Subject,char(Date)) when etc.. case :hv2 when "DESC" then x'FFFFFFFF' - hex(etc...) else etc... else "Aaargh - this shouldn't happen :-)" end as [...]
17584 20 15_Job Opportunity10_jack zhang20_zhang918@HOTMAIL.COM31_Mon, 28 May 2001 14:53:11 -0000595_- Hi folks: One financial business company in Canada iso a experienced db2 DBA with some programming experiences, please submit your resume to this account. Thanks! Jack Zhang Market Dept. BrightView Corp. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17605 54 41_how to recover the BSDS(emergency!!!!!!!)5_larry17_elibs@NETEASE.COM31_Tue, 29 May 2001 23:35:55 +0800256_gb2312 Hi,list: I have encountered a problem that my db2 on OS390 can not be started.The reason is that the dual BSDS datasets are destroyed by my collegue.Since I don't want to reinstall my DB2, Can someone help me?
Thanks in advanced Larry
17660 73 45_Re: how to recover the BSDS(emergency!!!!!!!)11_Brian Lynch19_Brian.Lynch@TRW.COM31_Mon, 28 May 2001 12:48:13 -0400514_US-ASCII If you have a copy of the Admin guide (I'm looking at version 6), in Chapter 4-7 Recovery Scenarios is a guide for Recovering the BSDS from a backup copy.
You need to know how to hexadecimal math to make this work. good luck.
>>> elibs@NETEASE.COM 05/29/01 09:35AM >>>
Hi,list: I have encountered a problem that my db2 on OS390 can not be started.The reason is that the dual BSDS datasets are destroyed by my collegue.Since I don't want to reinstall my DB2, Can someone help me? [...]
17734 31 58_Re: S04E and /or Return Code 8 on Call Attach in OS/390 V712_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Mon, 28 May 2001 12:35:03 -0500426_iso-8859-1 -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Roger Miller Sent: Friday, May 25, 2001 5:46 PM To: DB2-L@RYCI.COM Subject: Re: S04E and /or Return Code 8 on Call Attach in OS/390 V7
What's the abend reason code? Without that, the search criteria gets too many hits. With it, maybe I can pay you back for my free ride to IDUG from the airport. [...]
17766 57 45_Re: how to recover the BSDS(emergency!!!!!!!)20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Mon, 28 May 2001 14:45:29 EDT532_US-ASCII Hi Larry, To recover both BSDS there is a step by step recovery procedure in the DB2 System Admin. manual. You must: 1. Find the last archive message on MVS syslog 2. Rename or Delete both BSDS 3. Define Both BSDS - Your samplib have a job to define these. 4. Copy the BSDS from the last archive tape to newly define BSDS - Using label=1 from the archive message in step 1. 5. Make any changes that have taken place since the last archive - Like (new Active logs, changed passwords Etc. Etc. Their is a Tool that will [...]
17824 60 34_Re: Error Handling in DB2 Triggers14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 28 May 2001 19:21:47 -0500617_- The only way is to call a Stored Procedure from the trigger. The SP can set an error SQLSTATE (38yxx, y <> '5') which will be passed back to the application.
James Campbell
On Sat, 26 May 2001 18:05:56 +0500, Swamy, Ritesh wrote:
>Dear List Members, > >I am migrating some Oracle Triggers to DB2 and wanted to know if it is >possible to have error handling in the DB2 Triggers. for example I have a >very simple trigger from Oracle. Could you please suggest how could I do the >same in DB2. > >create or replace trigger tub_cp_organization [...]