1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2005, week 3
2 67 38_Re: DB2 for z/OS: Timestamp Anomaly(?)13_Michael Ebert18_mebert@AMADEUS.NET31_Sun, 10 Jul 2005 12:46:22 +0200450_us-ascii >> To claim that a day ends at 23:59:59.9999 is to claim that a day is less >> than 24 hours long. Clearly a nonsense. ...
>> James Campbell
Not to mathematicians all over the world, who know the difference between a one-sided and a closed set or interval. But the same argument is forwarded by people claiming that Einstein was wrong, because he used differential calculus and the expression 0/0 is clearly a nonsense... [...]
70 393 24_Dallas DB2 Forum meeting12_Robert Brock28_brock@KRYPTON-CONSULTING.COM31_Fri, 15 Jul 2005 01:26:11 -0500495_Windows-1252 DB2 Forum - The Southwest DB2 Users Group. Visit our web-page at: http://www.db2forum.com
Come to the 3rd Quarter DB2 Forum Meeting.
DB2 Forum would like to thank BMC Software for sponsoring this meeting.
Date: Tuesday July 19, 2005
Registration & Continental Breakfast: 8:00 A.M. - 9:00 A.M Meeting: 9:00 A.M. - 12:00 P.M.
Meeting Location: BMC North Dallas Office 18581 North Dallas Parkway, Suite 100 (north of Frankford) Dallas, TX 75287 [...]
464 31 36_Re: Online REORG / Sharelevel Change13_Michael Ebert18_mebert@AMADEUS.NET31_Fri, 15 Jul 2005 09:06:01 +0200471_us-ascii OLR uses SORTDATA SORTKEYS SORTDEVT SYSDA NOSYSREC by default. You only have to specify a SYSREC and SYSUT1 if the tablespace you're reorging does NOT have an explicit clustering index (with V8, having an index, which would then be the implicit clustering index, would be enough). Add a clustering index, or convert an existing index to CLUSTER YES, and you won't need SYSREC any more. In a multi-table TS, it is enough if any table has a clustering index. [...]
496 69 63_[z/OS v7] IBM COPY error allocating dynamic GDG using TEMPLATEs14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Fri, 15 Jul 2005 08:16:56 -0500672_US-ASCII I am generating about 508 image copies using listdef and templates and getting an error which I think is the dynamic allocation of a GDG. I have another job which generates about 87 copies and works just fine - used the JCL to skeleton this second job.
DSNU1015I DSNUGDYN - ERROR ALLOCATING DATA SET DSN=DISSDB2.DSNU.BMCCM73F.BMCBCOL.P00000(+1) CODE=X'035C0002' DSNU1042I DSNUGDYN - START OF IDCAMS MESSAGES IKJ56231I UTILITY DATA SET NOT ALLOCATED, SYSTEM OR INSTALLATION ERROR+ IKJ56231I TEXT UNIT X'0002' CONTAINS INVALID PARAMETER DSNU1043I DSNUGDYN - END OF IDCAMS MESSAGES DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 [...]
566 294 67_Re: [z/OS v7] IBM COPY error allocating dynamic GDG using TEMPLATEs15_Murley, Michael22_Michael_Murley@BMC.COM31_Fri, 15 Jul 2005 09:38:08 -0500344_us-ascii I think this data set name is too long to be a gdg base. It is 36 bytes long. Adding ".G0001V00" would make a 45-byte data set name. Too long by one byte.
If you try to define this base in idcams, you get this message:
IDC3523I GENERATION DATA GROUP NAMES CANNOT EXCEED 35 CHARACTERS [...]
861 24 22_DB2 Collating sequence13_Lee Robertson24_lee_robertson@FSMAIL.NET31_Fri, 15 Jul 2005 10:59:36 -0500526_- Hi,
Db2 v7 AIX 5.1
We are having strange issues with db2 collating. when we do a UNIX sort on fields a (+) sign is sorted before a (-) sign, which I believe is the correct behaviour for ASCII. In db2 we appear to have this in reverse. Is there somthing strange about the collating sequence in db2 and if so what do we need to do. I know that the only way to change this is to re-create the db and I also believe that SYSTEM is the default collating sequence. Reading up, it would appear that IDENTITY may [...]
886 117 37_Re: {Z/OS V7} Trigger format question13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Fri, 15 Jul 2005 13:38:03 -0400391_us-ascii Just tested this and it worked for me, but I needed to use a GTT to get the desired results.
I created four tables MARTY1, MARTY2, MARTY3, and MARTY1, plus a GTT called TEMP_TABLE. All tables have a CHAR(1) column called COL1.
I used value 'A' to trigger an insert into MARTY2 value 'B' to trigger an insert into MARTY3 value 'C' to trigger an insert into MARTY4 [...]
1004 195 67_Re: [z/OS v7] IBM COPY error allocating dynamic GDG using TEMPLATEs14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Fri, 15 Jul 2005 12:43:12 -0500455_UTF-8 thanks Mike, that was it.
fyi: for the archive - in reference to dynamic allocation - there was no message in the system log or in the job log to clarify this, but when I ran an IDCAMS manually, I got this: IDCAMS SYSTEM SERVICES
DEFINE GDG (NAME(DISSDB2.DSNU.BMCUTIL2.BMCXCOPY.P00000) - LIMIT(3) NOEMPTY SCRATCH) IDC3523I GENERATION DATA GROUP NAMES CANNOT EXCEED 35 CHARACTERS IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12 [...]
1200 435 37_Re: {Z/OS V7} Trigger format question11_David Nance16_DWNance@FHSC.COM31_Fri, 15 Jul 2005 11:48:57 -0600493_us-ascii Something to keep in mind...
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Myron Miller Sent: Thursday, July 14, 2005 4:06 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] {Z/OS V7} Trigger format question
One of the DBAs at my client is trying to create an after update trigger with multiple when clauses. He's asked IBM about this and so far has not gotten any answer at all that relates to his question: [...]
1636 50 30_Question to UDB/ Windows gurus27_DB2 Database Solutions Port26_db2dba_certified@YAHOO.COM31_Fri, 15 Jul 2005 12:41:17 -0700379_iso-8859-1
DB2 UDB v8.2 / Windows 2003:
We started with wrong practice of using db2admin (sysadm) everywhere and now we are discouraging that practice. We created several groups and granted necessary previleges to all the groups. We are using sysadm user only on certain tasks like backups etc. We have plans to use sysmant for that. So far everything works. [...]
1687 84 38_GETTING ZPARMS FROM RUNNING DB2 SYSTEM12_Mory Bindler25_Mory.Bindler@GRAINGER.COM31_Fri, 15 Jul 2005 14:45:53 -0500578_US-ASCII Hi listers,
I am a novice DB2 systems person who just subscribed to the list today, so I haven't had a chance to look at the archives yet. Forgive me if this question has been discussed here before.
There seems to be differences between the zparms in my current version of the ...SDSNSAMP library member DSNTIJUZ and the current parms as reported by CA's RC/Query software. Some of the differences may be due to how the values are being reported. I don't think anyone has changed the parms since DB2 V 7.1 was installed last year. Anyway, I found in [...]
1772 183 42_Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Fri, 15 Jul 2005 15:04:25 -0500507_us-ascii Hello Mory,
RC/Query lists ZPARM from the dataset listed on the panel once you get the report displayed. Since you have access to RC/Query - you also have access to option TT from the main menu. This option lists the active ZPARM and also allows you to change any parameter within ZPARM. You can even schedule the changes you describe to be performed e.g. every day at 8pm. using the built-in scheduler. If you have further questions - please do not hesitate to contact me off the list [...]
1956 209 42_Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM15_Carol L Broyles30_carol.broyles@MEADWESTVACO.COM31_Fri, 15 Jul 2005 16:00:59 -0400458_US-ASCII Mory,
See a posting in the Archives on a tool for DSNZPARM Analysis by HLS Technologies. I've used the tool, and it works. Go to www.hlstechnologies.com and select FREEWARE.
Carol
Mory Bindler Sent by: DB2 Data Base Discussion List 07/15/2005 03:45 PM Please respond to DB2 Database Discussion list at IDUG [...]
2166 298 42_Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM12_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Fri, 15 Jul 2005 15:18:28 -0500612_us-ascii You can get this infor from Control Center, assuming you have it and DB2 Connect installed.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mory Bindler Sent: Friday, July 15, 2005 2:46 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM
Hi listers,
I am a novice DB2 systems person who just subscribed to the list today, so I haven't had a chance to look at the archives yet. Forgive me if this question has been discussed here before. [...]
2465 53 38_[DB2v7 z/OS] Max LISTDEF size, anyone?15_Philip Sevetson19_psevetson@GMAIL.COM31_Fri, 15 Jul 2005 16:46:30 -0400381_ISO-8859-1 Does anyone know how many objects can be included in a LISTDEF statement? We're going to 40GB tapes soon and would like to use as few as possible; so, we need to maximize our LISTDEF statement size. All help is gratefully appreciated and (I hope) karmically rewarded. -- --Phil Sevetson IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for OS/390 [...]
2519 189 42_Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Fri, 15 Jul 2005 15:47:49 -0500511_us-ascii
Btw, CA's insight/DB2 help is much better than the RC/Query help.
So if you have Insight, I'd look at the zparms there instead (using option path 1.6.3). Nice thing about Insight is you can put the cursor on a item and press PF1 and get all kinds of information about what that field/number means. Often times, CA uses different label names than IBM does; but in Insight they'll tell you the CA name, the IBM name and where they derived that number from... very useful information. [...]
2709 368 42_Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM12_HEPP SHERY C17_schepp@SRPNET.COM31_Fri, 15 Jul 2005 15:55:02 -0700514_us-ascii
If you have Visual Explain (it's a free download from IBM) you can browse the db2 zparms. You'll need db2 connect though. You should be able to find it out on the download screen on the ibm z/0s db2 website
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mory Bindler Sent: Friday, July 15, 2005 2:46 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM [...]
3078 309 42_Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Fri, 15 Jul 2005 20:20:29 -0500698_us-ascii _____
From: Gerald Hodge [mailto:ghodge@hlstechnologies.com] Sent: Friday, July 15, 2005 8:08 PM To: 'DB2 Database Discussion list at IDUG' Subject: RE: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM
Mory:
There are some differences between what Visual Explain and HLS Describe offer. Both are free. Both use DSNWZP, which is a Store Procedure available in V8 and V7. Both use DB2 Connect. DSNWZP will return any public field from the DSNZPARMs. HLS Describe provides explanations for all the fields returned, while Visual Explain does not. HLS Describe provides the JAVA JAR file that is the desktop program that connects to DB2, [...]
3388 90 37_Re: {Z/OS V7} Trigger format question12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 15 Jul 2005 19:03:42 -0700622_iso-8859-1 Thanks, Marty. That's what I suggested to the DBA as an alternative. He's going to use two triggers as the volume of activity on that table is extremely low and he'd rather not have to create an SP.
Myron
--- "Kenney, Marty" wrote:
> Have you tried having your trigger call a stored procedure and have the > procedure determine what table(s) need to be inserted into? > > -----Original Message----- > From: DB2 Data Base Discussion List on behalf of Myron Miller > Sent: Thu 7/14/2005 4:06 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Cc: > Subject: [DB2-L] {Z/OS V7} [...]
3479 121 37_Re: {Z/OS V7} Trigger format question12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 15 Jul 2005 19:06:48 -0700504_iso-8859-1 According to IBM, they save now that two WHENS are not allowed. Either multiple triggers, SP or UDF is the only option.
What's really interesting is that Susan Lawson published an article that states the following: "----------------------------------------------------------------------- There is a lot of functionality that can be used within a trigger. For example, a CASE _expression can be used in a trigger, but it needs to be nested inside a VALUES statement, as shown here: [...]
3601 445 42_Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM54_Crane, Rob --- Manager Database Administration --- CFS27_rob.crane@FREIGHT.FEDEX.COM31_Sat, 16 Jul 2005 06:49:27 -0600469_us-ascii Since you seem to have CA products....You can also get zparm info from CA's Subsystem Analyzer, under additional options. Are you sure you are looking at the correct DSNSAMP library?
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Humphris,Richard P. Sent: Friday, July 15, 2005 2:48 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] GETTING ZPARMS FROM RUNNING DB2 SYSTEM [...]
4047 193 37_Re: {Z/OS V7} Trigger format question13_Horacio Villa17_hvilla@AR.IBM.COM31_Sat, 16 Jul 2005 12:29:43 -0300414_US-ASCII Try to add a WHEN (search condition) before BEGIN ATOMIC. Something like:
CREATE TRIGGER TRIG1 AFTER UPDATE OF COL1 ON TABLEA REFERENCING NEW AS NEW_A FOR EACH ROW MODE DB2SQL WHEN (NEW_A.COL1 <> ' ') -- (for example) BEGIN ATOMIC VALUES CASE WHEN NEW_A.COL1 = 'X' THEN INSERT INTO TABLEB......etc; INSERT INTO TABLEC......etc; WHEN NEW_A.COL1 = 'Z' THEN INSERT INTO TABLEC......etc; END END; [...]
4241 180 37_Re: {Z/OS V7} Trigger format question13_Horacio Villa17_hvilla@AR.IBM.COM31_Sat, 16 Jul 2005 14:04:00 -0300503_US-ASCII I've found this in the Red Book DB2 for z/OS: Application Programming Topics:
(Embedded image moved to file: pic28973.jpg)
Horacio Villa
Myron Miller cc: Sent by: DB2 Data Subject: Re: [DB2-L] {Z/OS V7} Trigger format question Base Discussion List
15/07/2005 23:06 Please respond to DB2 Database Discussion list at IDUG [...]
4422 57 31_Re: DB2 for z/OS V8 Experiences11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 16 Jul 2005 15:22:28 -0500315_- Our company would be interested in these responses too, so would you post to the list or directly to me too?
We've asked IBM several times for Version 8 references or even just a number of folks that have it up and running but never get a response other than the presentations/articles on their site. [...]
4480 99 63_Re: [z/OS v7] Utility parallel processing with LISTDEF/TEMPLATE11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 16 Jul 2005 15:42:24 -0500327_- Mark,
If you're copying to tapes, you'll also need to include the tapeunits n parameter. Where n is the number of tape drives you want to allocate.
Parrallel copies didn't work until I added this. We use virtual tape, so I removed the STACK keyword too, to allow for faster recovery time. Here's a sample: [...]
4580 18 67_Re: [z/OS v7] IBM COPY error allocating dynamic GDG using TEMPLATEs11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 16 Jul 2005 16:05:19 -0500724_- For our warehouse DBs, we used &PART(3) to shorten the name and avoid this problem. It takes the last 3 numbers of the partition and since we have none larger than 254, still keeps the names unique:
Hope this helps, Mike Kalena mkalena@bear.com
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
4599 57 31_Re: DB2 for z/OS V8 Experiences33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Sat, 16 Jul 2005 23:40:16 +0200564_iso-8859-1 Hi Mike,
just a short reply about our problems or issues.
1. Msys problems fixed with PK02556 2. Conversion from codepage 500 to 273 for four SAP-DB2 subsystem before V8 3. IVP problems (we run all) with DECIMAL=COMMA common setting in europe. 4. CICS CEDF problem with DBRM V8 NFM NEWFUN=YES. PK05933 still open 5. ISV issues 6. 12 months problem. V7 is free for 12 months after ordering V8. After this you have to pay for both. 7. ICLI is not supported for DB2 V8 NFM and SAP 6.20. Install and pay for DB2 Connect. ICLI was free as [...]
4657 182 63_Re: [z/OS v7] Utility parallel processing with LISTDEF/TEMPLATE13_Jim Schaeffer29_jim.schaeffer@EPOSTOFFICE.COM31_Sun, 17 Jul 2005 13:35:27 -0400660_ISO-8859-1 Mark, Mike and all:
We use the following for our image copy jobs to VTS:
TEMPLATE APPLXXVC DSN 'APPL&SS..&LR.50716.T1912.&DB..&TS.' BUFNO 90 RETPD 60 DATACLAS DCVTS UNIT(3490) STACK YES VOLCNT 99 LISTDEF APPLXXTS INCLUDE TABLESPACE APPLDB0*.* INCLUDE TABLESPACE APPLDB1*.* EXCLUDE TABLESPACE APPLDB19.* COPY LIST APPLXXTS COPYDDN(APPLXXVC) PARALLEL 8 TAPEUNITS 8
The DCVTS goes to our VTS. Our rules allow no more than 8 VTS units to be used by a job. The job image copies 185 tablespaces (two of which are about 10gb each) containing about 80 gb of data. The average run time is 20 minutes (the two largest tablespacesare [...]
4840 16 42_Re: GETTING ZPARMS FROM RUNNING DB2 SYSTEM6_ducduc17_ndt.db2@GMAIL.COM31_Mon, 18 Jul 2005 01:41:55 +0200609_ISO-8859-1 "db2 update" archive has a freeware based only on assembler that can regenerate your zparms macro from the current zparm module
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
4857 76 43_Re: Rexx to submit an utility in background10_Rich Fazio21_rfazio@TRANSUNION.COM31_Sun, 17 Jul 2005 23:19:39 -0500319_- I've received several emails outside of the list requesting this sample code. I've sent my collection of samples using Rexx & DB2 in every way that I could think of. I have attempted replying to all, but sometimes email servers filter out my toolkit. If you did not recieve it, please contact me again directly. [...]
4934 20 29_[DB2 V8 CM] Message DSNU1640I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Mon, 18 Jul 2005 04:31:19 -0500362_- Hi
I just got the message:
DSNU1640I DSNUGUTC - Z/OS DFSORT LOAD MODULE NOT LOADED.
when I try to load a table using CA-Batch-Processor. I do not find any documentation regarding this message. Did anyone else get this message and has any description of it.
I already looked at the Messages and Code in the web but to no avail. [...]
4955 73 33_Re: [DB2 V8 CM] Message DSNU1640I13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 18 Jul 2005 10:40:47 +0100323_iso-8859-1 Walter,
DFSort is a prereq for DB2 z/OS V8. You must have it for the utilities to work. You don't have to pay for it but it must be installed. I think DB2-L had a wee discussion about it last week.
As you're in CM I guess it's just a warning. But you'll need to get it before going into ENFM. [...]
5029 16 33_Re: [DB2 V8 CM] Message DSNU1640I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Mon, 18 Jul 2005 04:50:10 -0500699_- Raymond
Well, we have DFSORT for the DB2 utilities. Wenn I ran the load-utility outside CA-BP's, then it works.
And unfortunately it is not a warning, the load doesn't work inside the BP. The jobs ends with RC 8.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
5046 50 33_Re: [DB2 V8 CM] Message DSNU1640I14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 18 Jul 2005 11:12:23 +0100574_iso-8859-1 How are you making the DFSORT library available to DB2? Is it linklisted or steplibed? For now, try adding the DFSORT library to your CA jobs STEPLIB
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Walter Janiίen Sent: 18 July 2005 10:50 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [DB2 V8 CM] Message DSNU1640I [...]
5097 101 58_Re: [Maybe Spam] Re: [DB2-L] [DB2 V8 CM] Message DSNU1640I13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 18 Jul 2005 11:21:22 +0100570_iso-8859-1 Walter,
Sorry, I didn't mean to teach you to suck eggs. You're already much further down the V8 path that we are, so I'll stop there. Incidentally I didn't see your post below until Phil commented on it. Seems I still miss some DB2-L posts. Weird.
Anyway, Phil might be on the right track here. I know of some sites that have put the DFSort library in Link List to make it generally available. I suppose for you it's in your DSNUPROC procedure. It'll need to be available to any jobs that run utilities, so either a steplib/joblib entry or [...]
5199 25 33_Re: [DB2 V8 CM] Message DSNU1640I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Mon, 18 Jul 2005 06:17:28 -0500384_- Phil
We also included the Sort-libraries in our Steplib-concatenation. No success. Our system programmer told me, that we already raised this as a problem to your support group at least in Germany, so I don't know, if you have access to these information.
Beside this problem, I was wondering about the message DB2 issued, bacause I can't find anything about it. [...]
5225 69 33_Re: [DB2 V8 CM] Message DSNU1640I14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 18 Jul 2005 12:30:26 +0100316_iso-8859-1 Hmm
The way this SHOULD work, is that ANY DB2 component now uses DFSORT (and that message you are now seeing was added as part of a recent PTF, by the way).
Any NON DB2 component should continue to be able to use your existing SORT package as before and will NOT be able to use DFSORT. [...]
5295 37 30_Using DSNWZP to look at Zparms13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 18 Jul 2005 12:34:06 +0100530_iso-8859-1 All,
We're z/OS DB2 V7. I'm trying to run DSNWZP to see if it can't be used to grab DSNZPARM information but I'm not having much luck. The SP exists (in a WLM environment we have), the package exists, and the DSNWZP load module exists in a library referred to in the Steplib DD of the WLM STC. But when I call it, either via the Development Centre (sp) - aka the SP Builder - or Visual Explain I get no results. Clicking on the 'Parameters' tab on DC shows the P10 variable but with nothing in it. Strange. [...]
5333 57 34_Re: Using DSNWZP to look at Zparms13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 18 Jul 2005 13:52:45 +0100583_iso-8859-1 All,
Never mind. I discovered, using the Info Centre, that if you use a WLM-managed SP address space for DSNWZP then it's external name must be altered to be DSNWZPR. Which we hadn't done. I've just done it and it works a treat.
Just FYI.
Raymond Bell Database Administrator
> -----Original Message----- > From: Bell, Raymond > Sent: 18 July 2005 12:34 > To: Db2-L (E-mail) > Subject: Using DSNWZP to look at Zparms > > All, > > We're z/OS DB2 V7. I'm trying to run DSNWZP to see if it can't be used to > grab DSNZPARM information [...]
5391 50 34_Re: Using DSNWZP to look at Zparms15_Andersen, Cindy18_candersen@FNNI.COM31_Mon, 18 Jul 2005 08:04:47 -0500501_iso-8859-1 We found when using DSNWZP with Visual Explain & Development Center that we had to GRANT TRACE, MONITOR1, and MONITOR2 to the id the WLM started task ran under. There were security (we're ACF2/DB2) messages in the WLM address space indicating this.
Cindy Andersen
________________________________
From: DB2 Data Base Discussion List on behalf of Bell, Raymond Sent: Mon 7/18/2005 6:34 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Using DSNWZP to look at Zparms [...]
5442 59 42_DB2 V7 on zOS: IDCAMS Parms for BSDS, Logs13_Michael Ebert18_mebert@AMADEUS.NET31_Mon, 18 Jul 2005 16:29:23 +0200605_us-ascii Hi List,
in preparation for our move to Data Sharing (in the DBA playground system), I'm checking on datasets that are not part of my daily business, i.e. BSDSs and LOGCOPYs. I've created backups of them in case I want to redo the whole DS enablement thing. I've noticed something strange: I've created ssid.BSDS01.INDEX with CISIZE(1024), as per the installation job for adding a new DS member. However, when I look at the dataset with LISTC, the CISIZE is given as 1536. How come? Only our oldest existing BSDS, the one for the playground system, actually has CISIZE(1024) in LISTC [...]
5502 147 46_Re: DB2 V7 on zOS: IDCAMS Parms for BSDS, Logs12_Daniel Allen17_DAllen@SERENA.COM31_Mon, 18 Jul 2005 07:36:57 -0700680_us-ascii Are you z/OS 1.3 or higher? If so, VSAM has changed the default index CISIZE.
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Ebert Sent: Monday, July 18, 2005 7:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 V7 on zOS: IDCAMS Parms for BSDS, Logs
Hi List,
in preparation for our move to Data Sharing (in the DBA playground system), I'm checking on datasets that are not part of my daily business, i.e. BSDSs and LOGCOPYs. I've created backups of them in case I want to redo the whole DS enablement thing. I've noticed something strange: I've [...]
5650 145 46_Re: DB2 V7 on zOS: IDCAMS Parms for BSDS, Logs13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 18 Jul 2005 16:02:22 +0100720_iso-8859-1 Any differences aren't my fault, Dr. E. Just thought I'd mention that... ;o)
RB DBA
-----Original Message----- From: Michael Ebert [mailto:mebert@AMADEUS.NET] Sent: 18 July 2005 15:29 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [Maybe Spam][Maybe Spam][Maybe Spam] [DB2-L] DB2 V7 on zOS: IDCAMS Parms for BSDS, Logs
Hi List,
in preparation for our move to Data Sharing (in the DBA playground system), I'm checking on datasets that are not part of my daily business, i.e. BSDSs and LOGCOPYs. I've created backups of them in case I want to redo the whole DS enablement thing. I've noticed something strange: I've created ssid.BSDS01.INDEX with CISIZE(1024), as [...]
5796 37 33_Re: [DB2 V8 CM] Message DSNU1640I12_Roy Cornford19_cornford@US.IBM.COM31_Mon, 18 Jul 2005 11:05:46 -0500466_- I would expect the message to be in the next refresh of Messages and Codes. The closing text of PK04076 should contain some details.
The message text is given below.
Regards, Roy
IBM DB2 for z/OS ==========================================================================
DSNU1640I csect-name - Z/OS DFSORT LOAD MODULE NOT LOADED.
EXPLANATION: The required z/OS DFSORT load module was not located in the system search order. [...]
5834 153 54_AW: [DB2-L] DB2 V7 on zOS: IDCAMS Parms for BSDS, Logs33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Mon, 18 Jul 2005 20:27:55 +0200372_iso-8859-1 Michael,
our oldesd BSDS.INDEX is from 1995 and also have a CISIZE(1536). We run MVS 5.1 at this time. I know for sure as it was the first MVS we installed for this client. Also we start with SMS managed volumes.
Because of the low size for the BSDS I don't believe any of those options will change anything. So stay with given DB2 defaults. [...]
5988 100 12_DB2L SIGNOFF23_LEONARDO VALENTINO CRUZ21_LEONARDO.CRUZ@BBVA.PT31_Mon, 18 Jul 2005 20:29:00 +0100865_iso-8859-1 --- Recebido de POINFOR.UX90825 351.21.3117492 05-07-18 19.29 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> DB2-L@WWW.IDUGDB2-L.ORG
DB2L signoff DISCLAIMER This message is intended exclusively for the named person. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Any views expressed in this [...]
6089 50 4_HELP23_LEONARDO VALENTINO CRUZ21_LEONARDO.CRUZ@BBVA.PT31_Mon, 18 Jul 2005 20:30:00 +0100865_iso-8859-1 --- Recebido de POINFOR.UX90825 351.21.3117492 05-07-18 19.30 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> DB2-L@WWW.IDUGDB2-L.ORG
HELP DISCLAIMER This message is intended exclusively for the named person. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Any views expressed in this message [...]
6140 178 35_DB2 Connect / z/OS DB2 Data Sharing10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Mon, 18 Jul 2005 13:51:48 -0500417_us-ascii Hi all, We have been fighting a problem with a new application (JAVA) that queries data stored in a z/OS DB2 datasharing group. When we start up the second member of the datasharing group the application will begin to get connection errors. We have pretty well narrowed it down to a DB2 thread timeout on one of the members. On looking at the documentation on DB2 Connect Pooling we read where it says: [...]
6319 76 27_Re: Resource Limit messages16_Richard Humphris24_richard.humphris@CNA.COM31_Mon, 18 Jul 2005 14:07:48 -0500316_- I too would like to know if there is anyway to be able to monitor threads that have hit a Resource limit... either thru instrumentation (start trace) and/or via messages. But certainly not by looking at user jobs and/or TSO sessions.
As far as I can tell, DB2 does NOT provide us with this capability. [...]
6396 106 27_Re: Resource Limit messages15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Mon, 18 Jul 2005 15:38:04 -0400326_iso-8859-1 Check with your operations staff and see if there is a message capture program(we use CONTROL products do not know which) will do this. If you have this, then it should not be too difficult (politics aside) to capture and report messages that go to the SYSLOG.
Bob Lawrence DBA Boscov's Dept Stores LLc [...]
6503 30 44_Using DSNACCMD IBM supplied Stored procedure14_Carol Goldberg19_puli@MINDSPRING.COM31_Mon, 18 Jul 2005 19:27:08 -0500567_- I was hoping for some ideas for the listserv.
The goal is to setup a Health Check Page of all our applications.
Because I can connect to multiple db2 sub systems on different machines in one script I was planning on using a rexx script, on a windows server that would call the DB2 supplied stored procedure DSNCCAMD, to issue displays on all objects and utilities. The problem I am currently having is the data is loaded into the SYSPROC.DB2STATUS_TBL table , which is a global temporary table. When I do a select on this table , within the same [...]
6534 28 16_DB2 z/OS Explain35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Tue, 19 Jul 2005 08:44:19 +0200581_iso-8859-1
Good morning everyone out there,
this morning I got a call from one of our application developpers; she asked whether there was a direct connection between the number of service units and the cost factor shown by EXPALIN, because there was a change in the table design and the number of service units decreased from about 5000 to 15, but the cost factor increased slightly from 428 to about 433. She is currently checking whether there was a change in access path, but still I thought I'd ask you as well, since I simply do not know whether there is [...]
6563 16 33_Re: [DB2 V8 CM] Message DSNU1640I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 19 Jul 2005 01:44:41 -0500750_- Roy
I don't know, if you have read the entire thread. We have included the sort- libraries in our steplib-concatenation, but with no success.
I wonder, if the only reason for this message is, that DB2 cannot find the sort-modules or could it be a license-problem?
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
6580 34 33_Re: [DB2 V8 CM] Message DSNU1640I33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Tue, 19 Jul 2005 09:14:17 +0200498_iso-8859-1 Walther,
do you have ICEDFSRT in the SORT load-lib's?
Roland
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Walter Janiίen Sent: Tuesday, July 19, 2005 8:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [DB2 V8 CM] Message DSNU1640I
Roy
I don't know, if you have read the entire thread. We have included the sort- libraries in our steplib-concatenation, but with no success. [...]
6615 39 33_Re: [DB2 V8 CM] Message DSNU1640I10_Tee, Chris21_Chris.Tee@EU.SONY.COM31_Tue, 19 Jul 2005 08:45:27 +0100463_- Walter
Do you have SYS1.SICELINK in your steplib concatenation?
Chris
-----Original Message----- From: Walter Jani?en [mailto:walter.janissen@VICTORIA.DE] Sent: Tuesday, July 19, 2005 7:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [DB2 V8 CM] Message DSNU1640I
Roy
I don't know, if you have read the entire thread. We have included the sort- libraries in our steplib-concatenation, but with no success. [...]
6655 12 33_Re: [DB2 V8 CM] Message DSNU1640I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 19 Jul 2005 03:06:04 -0500551_- Roland
Yes, in SYS1.SICELINK, which I have in my steplib-concatenation.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
6668 37 33_Re: [DB2 V8 CM] Message DSNU1640I10_Tee, Chris21_Chris.Tee@EU.SONY.COM31_Tue, 19 Jul 2005 09:38:03 +0100433_- Walter
You also need SYS1.SORTLPA in the LPA list or linklist. Have a look at informational APAR II14047, it has all the details about setting up DFSORT for DB2 V* if you have another sort product.
Chris
-----Original Message----- From: Walter Jani?en [mailto:walter.janissen@VICTORIA.DE] Sent: Tuesday, July 19, 2005 9:06 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [DB2 V8 CM] Message DSNU1640I [...]
6706 25 33_Re: [DB2 V8 CM] Message DSNU1640I33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Tue, 19 Jul 2005 11:31:08 +0200841_iso-8859-1 APF for this library?
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Walter Janiίen Sent: Tuesday, July 19, 2005 10:06 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [DB2 V8 CM] Message DSNU1640I
Roland
Yes, in SYS1.SICELINK, which I have in my steplib-concatenation.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
6732 79 15_Lock escalation19_Francesco Borgoglio30_Francesco.Borgoglio@CEDACRI.IT31_Tue, 19 Jul 2005 12:10:01 +0200438_US-ASCII Hi all. I have this problem that impacts my db2 performance so much:
' ADM5500W DB2 is performing lock escalation. The total number of locks currently held is "12775", and the target number of locks to hold is "6387" '.
In the db2diag.log i found also:
' ADM10500E Health indicator "Lock Escalation Rate" ("db.lock_escal_rate") breached the "upper" alarm threshold of "10" with value "11" on "database" [...]
6812 174 19_Re: Lock escalation14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Tue, 19 Jul 2005 05:27:17 -0500354_US-ASCII This sounds like a distributed UDB ? First place is to examine the program for lack of commits. Then, is the tablespace locksize per page, per row, per table - this will generate more/less locks. I am afraid I cannot help on UDB parms, but on z/OS you can alter zparms table locks and user locks and each individual tablespace. ciao, Mark. [...]
6987 19 33_Re: [DB2 V8 CM] Message DSNU1640I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 19 Jul 2005 05:34:41 -0500756_- Chris, Roland
SYS1.SORTLPA is in the concatenation as well, and both libraries are APF- authorized.
A side note: If I use a different ISV-tool the load-utilities works, when I put the 2 sort-libraries in the steplib-concatenation (I hope I am allowed to remark this)
But thank you for those hints.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences [...]
7007 123 19_Re: Lock escalation18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 19 Jul 2005 06:49:46 -0400463_us-ascii What is the performance problem? If this is the only application connection, there should be no problems. If you are talking about concurrancy, then this would cause a problem.
You could increase MAXLOCKS in the database configuration parameters to allow a higher percentage of locks per application.
Peter J. Krawetzky, DBA IBM Certified Solution Expert DB2 UDB V7.1 Database Administration for Unix, Windows and OS/2 [...]
7131 75 19_Re: Lock escalation12_Rodney Krick15_rk@AFORMATIK.DE31_Tue, 19 Jul 2005 12:51:58 +0200521_ISO-8859-1
Give a look on the DB2 Problem Determination Tutorial Series at
http://www.ibm.com/software/data/support/pdm/db2tutorials.html
For lock escalation, look at the chapter 6, Performance Problem Determination.
Mit freundlichen Grόίen / Best regards,
Rodney Krick Senior Consultant ____________________________ aformatik Training & Consulting GmbH & Co. KG Tilsiter Str. 8, D-71065 Sindelfingen, Germany Tel.: +49 (0)7031-23 807-0 Fax: +49 (0)7031-23 807-19 [...]
7207 66 33_Re: [DB2 V8 CM] Message DSNU1640I14_Wayne Driscoll34_wdriscoll@WESTERN-METAL-SUPPLY.COM31_Tue, 19 Jul 2005 06:04:51 -0500605_iso-8859-1 Walter, Let me preface this by stating that I haven't worked with the CA product line since I left Platinum in 1999. At that time there were two possible places that the products would load modules from in addition to STEPLIB. The first is the PTILIB concatenation, as Phil Grainger mentioned. The second was from the LOADLIBS section of the PTIPARM SSID member for each DB2 subsystem. You want to add the libraries to both of those places. Also, I would advise contacting the vendors technical support system. You pay maintenance, you should utilize their expertise in these areas. Wayne [...]
7274 74 20_Re: DB2 z/OS Explain12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 19 Jul 2005 07:18:02 -0500328_iso-8859-1 Herr Kurtz:
If the hardware has not changed and the EXPLAIN is done on the same level of DB2, we found the cost estimates to be consistent. Changing either causes differences, but the difference between DB2 Versions is more. For example V8 estimates are dramatically lower than the estimates in V6 or V7. [...]
7349 44 41_V8.2, LUW - Determining referenced tables13_Dan Michaelis25_dcmichaelis@EORIGINAL.COM31_Tue, 19 Jul 2005 07:16:36 -0500639_ISO-8859-1 Folks,
As an application developer upgrading customer databases, I occasionally make an alteration to a table that requires an export/drop/recreate/load methodology. An example of this might be increasing the size of a BLOB/CLOB column in a table to support larger data structures.
In doing so, in theory, I know what constraints reference the table that Im dropping and rebuilding, but in practice, my customers may have altered schema, or other changes may have been made that restrict my ability to do this drop. Im looking for a mechanism through the syscat or sysibm tables that will allow me to know: [...]
7394 104 58_Antwort: [DB2-L] V8.2, LUW - Determining referenced tables12_Rodney Krick15_rk@AFORMATIK.DE31_Tue, 19 Jul 2005 14:36:40 +0200555_ISO-8859-1
Dan,
try looking at the utility db2look, with the option -e. (from "Command Reference") -e Extract DDL statements for database objects. This option can be used in conjunction with the -m option. DDL for the following database objects are extracted when using the -e option: Tables Views Automatic Summary Tables (AST) Aliases Indexes Triggers User defined Distinct Types Primary Key, RI, and CHECK constraints User Defined Structured Types User Defined Functions User defined Methods User defined Transforms [...]
7499 22 33_Re: [DB2 V8 CM] Message DSNU1640I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 19 Jul 2005 07:31:39 -0500312_- Wayne
You hit the nail on the head. A few minutes before, we received this hint from CA.
To get rid of this nasty problem, we raised a problem with CA, but I thought, another source could be a good idea, and the DB2-L is always a good place to get hints or even solutions for some problems. [...]
7522 166 19_Re: Lock escalation14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Tue, 19 Jul 2005 07:52:08 -0500636_ISO-8859-1 Rodney, Is there a z/OS version of these ? thanks, Mark.
Rodney Krick Sent by: DB2 Data Base Discussion List 07/19/2005 05:51 AM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: Lock escalation
Give a look on the DB2 Problem Determination Tutorial Series at
http://www.ibm.com/software/data/support/pdm/db2tutorials.html
For lock escalation, look at the chapter 6, Performance Problem Determination. [...]
7689 18 33_Re: [DB2 V8 CM] Message DSNU1640I12_Roy Cornford19_cornford@US.IBM.COM31_Tue, 19 Jul 2005 07:47:34 -0500677_- Walter,
You are licensed to use DFSORT for DB2, if you have a DB2 V8 license. You might want to double check that you have PQ68263 on your system (it is reasonably old).
Regards, Roy
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
7708 20 25_any comment on this sql ?6_Daniel17_c300501@YAHOO.COM31_Tue, 19 Jul 2005 08:40:08 -0500399_- Dear listers ,
a programmer writes this to avoid having 2 cursors :
select ... from tablea where ... and :hv ='1' union all select ... from tableb where ... and :hv ='2'
I said 'no' and asked him to create 2 dictincts cursors for each situation. was curious to know how db2 handles it , and it seems that db2 chooses the "right path" , do you have any comments on this ? [...]
7729 61 29_Re: any comment on this sql ?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 19 Jul 2005 14:51:55 +0100332_us-ascii I'll probably start a flame war now, but to me this is "clever" SQL (notice that clever has quote marks!)
It's "clever" in the sense that, yes it DOES work, but serves no useful purpose AND (if the statements were more complex than the simple examples) may well to serve to confuse any programmer coming later. [...]
7791 56 29_Re: any comment on this sql ?15_Moschelli Mauro31_mauro.moschelli@SANPAOLOIMI.COM31_Tue, 19 Jul 2005 16:03:02 +0200498_iso-8859-1 The clause :hv = literal is stage 2 so it is evaluated after all other where clauses you omitted in the example. So DB2 in this case simply follows the usual rules for choosing access path. It means that if you have suitable indexes they are used, but DB2 is doing half, if not all, wasted work because both selects will be executed (getpages, IO, predicate evaluation, locks and so on) and then rows of one of them are thrown away because the last clause will never evaluate true. [...]
7848 108 29_Re: any comment on this sql ?9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 19 Jul 2005 09:25:49 -0500541_windows-1250 Since the hv can only have one value, only one of the tables can return data. Item one that is not obvious since :hv = literal, DB2 will examine both tables, qualify all the rows and then not return one of them. This is major performance issue, DB2 will always examine both tables, qualify rows and in general do twice the work to return the data from one table. Since the :hv is controlling the logic, the programmer knows which table has the data required, therefore should issue the correct cursor to retrieve the data. [...]
7957 92 44_DB2 ZOS V7 SYSZVOLS ENQ in MSTR for Archives14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Tue, 19 Jul 2005 08:00:44 -0700433_iso-8859-1
SYSZVOLS and *MSTR
We have an operational issue that manifested its self after mass application of some Operating System Hyper Service.
We recycle DB2 less frequently than once a month.
On June 12 OS Hyper Service was Applied.
Since that time when DB2 allocates old log archives and subsequently deallocates them the SYSZVOLS ENQ for the associated tape volume does not get freed. [...]
8050 66 20_Re: DB2 z/OS Explain0_20_Gerhard.Heiss@RUV.DE31_Tue, 19 Jul 2005 17:05:12 +0200641_iso-8859-1 Ruediger, according to sql-reference, the costfactor (timeron) you get when preparing sql-statements is ...a rough relative estimate of resources required. This value does not reflect an estimate of the time required to execute the SQL statement. After you prepare an SQL statement, you can use this field as an indicator of the relative cost of the prepared SQL statement. For a particular statement, this number can vary with changes to the statistics in the catalog < end snip> It cannot be expressed in terms of cpu seconds or cpu serviceunits, since those depend on the processors of your machine. CPU-Serviceunit [...]
8117 86 46_DB2/ZOS set up Surrogate for SET CURRENT SQLID0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 19 Jul 2005 10:01:31 -0700289_- Hi all, we have a RACF user id that was used to create DB2 objects. The DBA would like to set the sqlid to that userid to create more objects but not have to log on as the original creator.
I tried connecting the DBA's user id as a surrogate but he still gets an auth error. [...]
8204 17 50_Re: DB2/ZOS set up Surrogate for SET CURRENT SQLID12_Roy Cornford19_cornford@US.IBM.COM31_Tue, 19 Jul 2005 12:08:48 -0500675_- Have you considered getting rid of the original userid in RACF and creating a RACF group of the same name. You could then connect one or more users to this group?
Regards, Roy
DB2 for z/OS
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
8222 44 50_Re: DB2/ZOS set up Surrogate for SET CURRENT SQLID0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 19 Jul 2005 10:20:43 -0700492_- Roy, yes but unfortunately the user id is used in other non-db2 processes. I'm not sure what the total impact would be to change it but I'm sure it wouldn't be pretty. I'm looking for a quick easy fix.
thanks, cliff:-)
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Cornford Sent: Tuesday, July 19, 2005 10:09 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2/ZOS set up Surrogate for SET CURRENT SQLID [...]
8267 14 50_Re: DB2/ZOS set up Surrogate for SET CURRENT SQLID12_Roy Cornford19_cornford@US.IBM.COM31_Tue, 19 Jul 2005 12:25:24 -0500612_- I think tweaking you authorisation exit may be the easiest, if not elegant, way forward (it can also be undone easily).
Regards, Roy
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
8282 38 50_Re: DB2/ZOS set up Surrogate for SET CURRENT SQLID0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 19 Jul 2005 10:35:31 -0700493_- Roy, well I've never monkey'd with the auth exit, I guess its time.
thanks, cliff:-)
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Cornford Sent: Tuesday, July 19, 2005 10:25 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2/ZOS set up Surrogate for SET CURRENT SQLID
I think tweaking you authorisation exit may be the easiest, if not elegant, way forward (it can also be undone easily). [...]
8321 159 50_Re: DB2/ZOS set up Surrogate for SET CURRENT SQLID12_McKown, John26_john.mckown@UICIINSCTR.COM31_Tue, 19 Jul 2005 12:28:03 -0500121_us-ascii Is the DBA using USER=PROD on the JOB card? SURROGAT only applies to batch jobs.
8481 69 50_Re: DB2/ZOS set up Surrogate for SET CURRENT SQLID9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 19 Jul 2005 12:49:10 -0500588_windows-1250 The standard answer is to create a RACF group with the same value and assign the group to the DBA. Then the DBA can set current sqlid to the value because it is a valid group. Db2 does NOT understand RACF surrogate processing - it does understand RACF groups.
Mike Bell HLS Technologies -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Maurice.C.BOLEY@ODOT.STATE.OR.US Sent: Tuesday, July 19, 2005 12:02 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2/ZOS set up Surrogate for SET CURRENT SQLID [...]
8551 22 45_local primary ic vs remote primary IC DB2/Zos29_GOODWIN, STANLEY (Contractor)26_GoodwinS.ctr@MECH.DISA.MIL31_Tue, 19 Jul 2005 14:34:26 -0400812_us-ascii Can anyone tell me is there a difference internally in a Local Primary Ic and a Remote Primary IC? Understand there is difference in the SYSCOPY entreis but what about the physical files themselves.
Stan Goodwin DB2 Support Decc Mech dsn 430-4335 outside 1-717-605-4335 Goodwins.ctr@mech.disa.mil Team Email DB2@mech.disa.mil
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
8574 298 43_Press Release - India Firm to market GENDB20_19_DB2Automate@AOL.COM29_Tue, 19 Jul 2005 15:05:22 EDT768_UTF-8 Recovery Knowledge and Axxonet Solutions India announce Distribution Agreement. Recovery Knowledge www.recoveryknowledge.com the developer of GENDB2 software product (which simplifies and automates the DB2 MVS, OS/390, z/OS recovery process Offsite and Onsite) and Axxonet Solutions India www.axxonet.com announce a distribution agreement under which Axxonet Solutions India will market the GENDB2 software in the country of India. Axxonet Solutions is a technology driven, quality conscious company, which aims at providing total customer satisfaction in the fields of Customized Business Applications, Migration and Networking Solutions for small and medium sized organizations. The enhancements to the GENDB2 software product include: DSN1COPY β Using [...]
8873 30 47_Editing DBRM modules to add / change version ID14_Mark McCormack27_mamccormack@STATESTREET.COM31_Tue, 19 Jul 2005 15:48:34 -0400508_US-ASCII We have a vendor package that requires an upgrade. It uses DB2 packages, but the version ID is blanks. To be exact: the version column in sysibm.syspackage for existing packages contains blanks; the version value in the second record of each of the new dbrmlib members is also blanks. That means that we must bind the packages from the new dbrmlib at the same time as the matching program modules are installed. It also means that we must bind everything again if we back out the new programs. [...]
8904 77 51_Re: Editing DBRM modules to add / change version ID14_Toppins, Smike21_smike.toppins@GWL.COM31_Tue, 19 Jul 2005 13:51:21 -0600689_us-ascii I've done this type of editing of DBRMLIB members. It works fine.
SMike Toppins Great-West Life 8525 E. Orchard Road Englewood, CO 80111 smike.toppins@gwl.com
----Statement of Confidentiality----
This e-mail, and any attachments thereto, is intended for the exclusive use of the addressee(s) named herein and may contain information that is privileged or confidential or otherwise legally exempt from disclosure. If you are not a named addressee or an employee or agent responsible for delivering this message to a named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you [...]
8982 126 51_Re: Editing DBRM modules to add / change version ID13_Richard Fazio21_rfazio@TRANSUNION.COM31_Tue, 19 Jul 2005 14:53:21 -0500671_US-ASCII Why not bind into a different collection? Avoid manipulating the DBRM.
Two plans, two collections, two groups of packages. faz
Rich Fazio DB2 OS390 DBA
TransUnion, LLC SSG/Data Services Team, 5th Floor 555 West Adams St. Chicago, IL 60661 Phone (312) 985-3270 Fax (312) 466-8398
Talk to teach - Listen to learn
>>> mamccormack@STATESTREET.COM 2005-07-19 2:48:34 PM >>> We have a vendor package that requires an upgrade. It uses DB2 packages, but the version ID is blanks. To be exact: the version column in sysibm.syspackage for existing packages contains blanks; the version value in the second record of each of [...]
9109 77 51_Re: Editing DBRM modules to add / change version ID13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 19 Jul 2005 14:57:05 -0500436_us-ascii How about just using different collection-id's? Bind the packages for the new release into a new collection and then just include both collections in plan's pklist.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark McCormack Sent: Tuesday, July 19, 2005 2:49 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Editing DBRM modules to add / change version ID [...]
9187 73 51_Re: Editing DBRM modules to add / change version ID14_Seth Bienstock19_sethdb2@COMCAST.NET31_Tue, 19 Jul 2005 20:02:14 +0000422_- Mark,
Not a bad idea, but you might want to consider other alternatives first. If you mess around with the DBRM members, then the vendor COULD turn around and refuse to support you on that basis alone.
Do you know if the application issues a SET CURRENT PACKAGESET call? If not, then perhaps you can fiddle with the package list(s) in the plan(s) in order to still accomplish what you're looking for. [...]
9261 48 51_Re: Editing DBRM modules to add / change version ID33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Tue, 19 Jul 2005 22:44:41 +0200315_iso-8859-1 How would you "edit" the load module to match the Version? Changing might be easier (assume the length remains the same) but adding a Version in a load module is interessting game. Also will you do this always in case of fixes?
I believe different PLANs and different collections is the way. [...]
9310 109 51_Re: Editing DBRM modules to add / change version ID9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 19 Jul 2005 16:20:18 -0500452_iso-8859-1 The version info is always the second record in the DBRM whether a version is specified or not. It is a fixed position with a length of 0 if no version is specified.
I agreee that multiple collections and bind plan to collectiona vs collectionb is the easiest way. Actually I might bind the plan with the new collection first and the old collection second. It would be a lazy way to backout just the load modules for a fallback. [...]
9420 34 51_Re: Editing DBRM modules to add / change version ID33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Tue, 19 Jul 2005 23:25:55 +0200574_iso-8859-1 Yep, but the load module must also contain the Version-ID. The DBRM Version alone wouldn't help
Roland
-----Ursprόngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Mike Bell Gesendet: Dienstag, 19. Juli 2005 23:20 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Re: [DB2-L] Editing DBRM modules to add / change version ID
The version info is always the second record in the DBRM whether a version is specified or not. It is a fixed position with a length of 0 if no version is specified. [...]
9455 161 49_Faster unload from IBM on Version 7 of DB2 on Zos17_Pickett, Mary Ann24_pickettm@DOT.STATE.AL.US31_Tue, 19 Jul 2005 16:40:15 -0500708_us-ascii Does anyone have an example of the new faster unload they would be willing to share?
Thanks,
Mary Ann Pickett
Data Base Administrator
Alabama Department of Transportation
334-242-6035
NOTICE: This communication is not encrypted and may contain privileged or other confidential information. If you are not the intended recipient or believe that you may have received this communication in error, please reply to the sender indicating that fact and delete the copy you received. In addition, you should not print, copy, retransmit, disseminate, or otherwise use the information. THANK YOU. [...]
9617 23 47_Editing DBRM modules to add / change version ID14_Mark McCormack27_mamccormack@STATESTREET.COM31_Tue, 19 Jul 2005 18:01:05 -0400495_US-ASCII SMike, Rich, Mike, Seth, Roland, and Mike,
The programs do not use SET CURRENT PACKAGESET, and we cannot change the vendor's source.code. So that is not a viable option. I propose changing the version id only, not the contoken. I like editing the version id to put in a meaningful value, and I'm glad that someone else has done it. (And it's nice that I didn't have a brain cramp here.) My boss likes the multiple collections variation, so that is probably what we will do. [...]
9641 84 51_Re: Editing DBRM modules to add / change version ID9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 19 Jul 2005 17:08:52 -0500564_iso-8859-1 wrong - The plist in the load module does NOT contain the version - just the CONTOKEN. DB2 does the lookup only with collection, program name, and the contoken. Version information is only used to identify a package for bind/rebind.
Mike Bell HLS Technologies -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schiradin,Roland HG-Dir itb-db/dc Sent: Tuesday, July 19, 2005 4:26 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Editing DBRM modules to add / change version ID [...]
9726 32 51_Re: Editing DBRM modules to add / change version ID33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Wed, 20 Jul 2005 00:26:59 +0200409_iso-8859-1 You're right the version string exists in the load module but isn't used by DB2. Time to sleep.
Roland
-----Ursprόngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Mike Bell Gesendet: Mittwoch, 20. Juli 2005 00:09 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Re: [DB2-L] Editing DBRM modules to add / change version ID [...]
9759 247 49_Re: local primary ic vs remote primary IC DB2/Zos9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Tue, 19 Jul 2005 17:37:05 -0500361_iso-8859-1 I am working with a test database. I am using the load utility to load this database. The load utility failed with media error. We need to apply a PTF to fix this opportunity. After the PTF is applied, can I do some kind of repair to let me reload the data. I am thinking I need to drop and rebuild this tablespace. I am open to any suggestion. [...]
10007 60 51_Re: Editing DBRM modules to add / change version ID14_Seth Bienstock19_sethdb2@COMCAST.NET31_Tue, 19 Jul 2005 22:48:37 +0000384_- To clarify...If the code WAS using a SET CURRENT PACKAGESET, then multiple collections would NOT be an option. Since they do not, then you can.
My reference to modifying the vendor's code was in regards to the DBRM module(s). The DBRM could be viewed as "vendor source code", since THEY are the ones supplying them to you, and you didn't actually prepare them yourself. [...]
10068 133 49_Re: local primary ic vs remote primary IC DB2/Zos9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 19 Jul 2005 18:48:12 -0500295_windows-1250 you are using load replace so all the old data is gone. -term util(your util id) will clear the claims from the old util. You might be able to rerun the load utility at that point if not -start database(dbcpdd) spacenam(rprof) access (force) will clear the rest of the status. [...]
10202 118 30_DB2 zOS V7 migration - rebinds15_Tonia De Marchi20_TDeMarchi@HBF.COM.AU31_Wed, 20 Jul 2005 09:44:58 +0800421_US-ASCII Hi All,
We have recently upgraded DB2 for Z/OS from V6 to V7 put level 0501. Also we have read all the Bind Doc and Hold data information that came with the Server Pac.The upgrade went smooth as however after upgrading our production system we suddenly experienced a few CICS/Cobol/DB2 programs behaving very strangely for eg: cheque amounts doubling, incorrect values being displayed on the screen. [...]
10321 41 34_Re: DB2 zOS V7 migration - rebinds13_Michael Ebert18_mebert@AMADEUS.NET31_Wed, 20 Jul 2005 09:08:51 +0200418_us-ascii Mass rebinds have been discussed a few times over the past years. Generally I do mass rebinds when there is a major amount of PTFs being applied, which used to happen about once a year; an upgrade also comes under this heading. That way existing packages get all benefits from performance improvements (as well as picking up changed statistics) and I might fix problems that exist but never got noticed. [...]
10363 40 49_Re: local primary ic vs remote primary IC DB2/Zos12_Roy Cornford19_cornford@US.IBM.COM31_Wed, 20 Jul 2005 04:55:59 -0500783_- On Tue, 19 Jul 2005 14:34:26 -0400, GOODWIN, STANLEY (Contractor) wrote:
>Can anyone tell me is there a difference internally in a Local Primary >Ic and a Remote Primary IC? Understand there is difference in the >SYSCOPY entreis but what about the physical files themselves. > >Stan Goodwin >DB2 Support Decc Mech >dsn 430-4335 >outside 1-717-605-4335 >Goodwins.ctr@mech.disa.mil >Team Email DB2@mech.disa.mil > >-------------------------------------------------------------------------- ------- >Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List [...]
10404 45 51_Re: Editing DBRM modules to add / change version ID0_20_simon.george@UBS.COM31_Wed, 20 Jul 2005 14:08:49 +0100529_iso-8859-1 We do this day in day out for our JAVA code as the DB2 V7 sqlj translator does not support versions (the V8 one does). Basically we actually use the DBRM consistency token as the version-id. We have a bit of REXX built into our Change Management Tool that post processes the DBRM, reads the consistency token (LINE-1,25,8), converts it from HEX to character and then writes it into the second line where the version-id is (with a length of 16). Its works just fine but the "version" is not exactly user friendly! [...]
10450 226 34_Re: DB2 zOS V7 migration - rebinds16_Burnette, George27_George_Burnette@KYFBINS.COM31_Wed, 20 Jul 2005 09:25:05 -0400401_us-ascii Please verify... Your upgrade was for DB2 V6 to V7 and not your OS - correct ? Were there any upgrades to the OS ?
Thanks, George Burnette
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Tonia De Marchi Sent: Tuesday, July 19, 2005 9:45 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 zOS V7 migration - rebinds [...]
10677 124 34_Re: DB2 zOS V7 migration - rebinds9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 20 Jul 2005 09:24:02 -0500376_windows-1250 This is the first occurance I have heard for a problem with V7. Of course everyone had problems with early V6 and maybe those problems were carried forward.
It is mostly with V8 that IBM is recommending mass rebind. V8 will also do an automatic rebind if the last rebind was V2.3 or prior. It is expected that this will continue to move more current. [...]
10802 21 29_Re: any comment on this sql ?15_Patrick Bossman18_bossman@US.IBM.COM31_Wed, 20 Jul 2005 10:06:27 -0500373_- Hello, Runtime pruning ought to eliminate the leg of the union all that is disqualified. You wouldn't see this in the bind or even REOPT(VARS) explain.
What you could do to test it is stop the tablespace for the table that should not be accessed prior to running the program. If pruning does not occur, you get a -904. If it does, then the SQL will complete. [...]
10824 143 71_Baltimore/Washington DB2 Users' Group Meeting Agenda-September 21, 200514_Henry L Nalven25_henry.nalven@MARRIOTT.COM31_Wed, 20 Jul 2005 10:12:35 -0500515_ISO-8859-1 The Baltimore/Washington DB2 Users' Group Meeting Schedule for September 21, 2005 (Wednesday)
When? Wednesday, September 21, 2005, 9:00 AM-3:30 PM (Registration at 8:30)
Where? Sheraton Columbia Inn, 10207 Wincopin Circle Columbia, MD (410) 730-3900
Meeting Fees: Pre-registered members $20 Pre-registered non-members $30 At-the-door for members $30 At-the-door for non-members $40
To pre-register, please mail the appropriate fee with attendee's and employer's name to: [...]
10968 48 39_Re: DB2 Connect / z/OS DB2 Data Sharing10_Jorg Lueke21_jorg_lueke@EFUNDS.COM31_Wed, 20 Jul 2005 10:38:43 -0500313_- Jim,
You can have al sorts of fun with this types of things based on how you are calling (WAS pooling to Gateway), (WAS pool direct), etc. etc.
If one thread on one member times out that doesn't constitute an outage in my mind. But I am not entirely sure what you are asking or experiencing. [...]
11017 29 71_Mainframe Stored Procedures called from Client/Web front end thru DRDA.13_Brendan Friel28_Brendan_Friel@NOTES.NTRS.COM31_Wed, 20 Jul 2005 10:54:36 -0500549_US-ASCII I'm not sure what is the best approach for an inquiry/ view type process :
A) Have the front end ship in the arguments. Mainframe stores the results in GTTs and returns control. Front end digs through the GTTs to get what it wants. B) Front end ships in arguments - back end queries base tables and ships back a cursor (or cursors) on the base tables using dynamic result sets - no GTTs. C) Front end ships in arguments - back end queries base tables, creates GTTs and ships back a cursor (or cursors) on the GTTs using dynamic [...]
11047 30 23_Z/os to Z/os DB2 access14_Larry Kintisch19_lkint@IX.NETCOM.COM31_Wed, 20 Jul 2005 12:07:02 -0700578_us-ascii HI List, A manager asked me if a z/Os system [say running CICS apps] that did NOT have DB2 installed could directly access DB2 on another z/os system that had DB2 for z/os installed. I said that I didn't think so, but I would check with you folks. In the DB2 for Windows/Unix world we have DB2 Connect that I understand provides that "connect" [DRDA] capability on a system without DB2 installed. Is there something like that [without installing DB2 for z/os plus DDF] for the DB2 world? Is there a work-around: could both systems communicate via MQ Series queues [...]
11078 64 27_Re: Z/os to Z/os DB2 access14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 20 Jul 2005 17:16:02 +0100467_us-ascii The "DB2 Connect" piece of DB2 for z/OS is indeed part of DB2 itself - there is no separately licensable connect piece for z/OS
Your alternatives are things like MQ or anything else that allows you to do remote/distributed program calls to make sure you can do you SQL locally
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
11143 76 75_Re: Mainframe Stored Procedures called from Client/Web front end thru DRDA.12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US31_Wed, 20 Jul 2005 12:23:57 -0400384_us-ascii Brendan -
Not sure that option A will work, as the GTT should "go away" when the SP returns to the client.
In our app (also web based with back end data on the mainframe), we use option C. This works very well for us.
HTH.
Mark
Mark Anzmann Tech Services Manager DHRIS Program - ACS Phone: 410-238-1213 email: manzmann@dhr.state.md.us [...]
11220 39 70_[z/OS v7] Combining 2 subsystems on one LPar with one SDSNEXIT library14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 20 Jul 2005 11:41:41 -0500346_US-ASCII I thought I could do this until we were looking at DSNHDECP, which is not passed to the started task as a parameter (like DSNZPARM). Specifically because DSNHDECP has the SSID in it and unless we can identify separate versions of this to the started task, I am not sure how to make this work. thanks for any feedback. Mark Vickers. [...]
11260 81 27_Re: Z/os to Z/os DB2 access13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 20 Jul 2005 10:08:09 -0700568_us-ascii I just happened to be reading the DB2 v8 program directories the other day. One of them was for "z/OS Application Connectivity to DB2 for z/OS", which I had never heard of before. Its description begins "The purpose of this product is to give connectivity to remote DB2 systems for 390 and z/OS systems (LPARs) that do not have DB2 for z/OS installed," which sounds like what you are looking for. However, after a cursory glance through this pgmdir, I came away with the impression that access is via Java, so your CICS would have to access it through a [...]
11342 96 74_Re: [z/OS v7] Combining 2 subsystems on one LPar with one SDSNEXIT library0_18_iwant2beme@AOL.COM31_Wed, 20 Jul 2005 13:21:56 -0400622_us-ascii My experience of combining information from two DB2 subsystems on different LPARs had been with DB2 stored procedures on each of the LPAR . The stored procedure on the primary LPAR would insert its local subsystem's information into a DTT, then connect to the other LPAR and call a stored procedure which had been remotely bound. The "remote" stored procedure opened a cursor and returned a result set with its subsystem's information. The primary stored procedure then did a fetch, reset the connection, inserted the row into the same DTT, connected again, fetched again,..... repeated until it had all the [...]
11439 237 75_Re: Mainframe Stored Procedures called from Client/Web front end thru DRDA.0_18_iwant2beme@AOL.COM31_Wed, 20 Jul 2005 13:37:35 -0400491_us-ascii It depends.
With A, the result would probably need to be FTP'd or put on MQ for the client. If I'm understanding it correctly, the client doesn't wait for the answer in this senario, so the GTTs wouldn't be there for the client to retrieve.
With B there would be no overhead from using the GTTs. If the base tables can be read "WITH UR", then efficiency would be gained. Otherwise, look at the locking issues to determine if the overhead of the GTTs is worth it. [...]
11677 88 27_Re: Z/os to Z/os DB2 access13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 20 Jul 2005 13:24:21 -0500620_us-ascii Isn't that the Universal Driver (Type 4 Driver) stuff?
Willie
Taddei, Cathy wrote:
>I just happened to be reading the DB2 v8 program directories the other >day. One of them was for "z/OS Application Connectivity to DB2 for >z/OS", which I had never heard of before. Its description begins "The >purpose of this product is to give connectivity to remote DB2 systems >for 390 and z/OS systems (LPARs) that do not have DB2 for z/OS >installed," which sounds like what you are looking for. However, after >a cursory glance through this pgmdir, I came away with the impression >that access [...]
11766 53 27_Re: Z/os to Z/os DB2 access19_Database Consultant32_databaseconsultant@SBCGLOBAL.NET31_Wed, 20 Jul 2005 12:08:17 -0700329_iso-8859-1 If you have CICS on both systems you could route the program to run on another CICS which is connected to DB2. I believe there are several methods using CICS to pull this off. You can use transaction routing to run the program on another box. You can use MQ Series or at one shop I was at we used TCP/IP sockets. [...]
11820 29 22_Saving ROLLedBACK data0_22_sally.mir@WACHOVIA.COM31_Wed, 20 Jul 2005 15:18:06 -0400569_US-ASCII We're looking for a creative solution to this problem. Would appreciate any input from you experts.....
The developer of a stored procedure wants to be able to report upon the parms passed to it from a calling program, but only when the calling program decides to issue a ROLLBACK after returning from the SP. In other words, he wants to be able to track and research the values of the parms used in a failed transaction. He can't insert them into a table, because they would be rolled back by the calling program. He doesn't want to have to write [...]
11850 86 26_Re: Saving ROLLedBACK data15_Byron C. Pierce27_byron.pierce@PRUDENTIAL.COM31_Wed, 20 Jul 2005 15:26:20 -0400556_us-ascii Put the insert into the calling program and insert after rollback.
Byron C. Pierce Prudential Retirement Technology Database Services - H07B Work: 860.534.4222 Cell: 860.712.8223 Mail: Byron.Pierce@Prudential.com
sally.mir@WACHOVI A.COM To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List [DB2-L] Saving ROLLedBACK data
Wed 07/20/2005 03:18 PM
Please respond to DB2 Database Discussion list at IDUG [...]
11937 58 26_Re: Saving ROLLedBACK data13_Rhea, Matthew24_Matthew_Rhea@CONSECO.COM31_Wed, 20 Jul 2005 14:28:11 -0500347_iso-8859-1 At one shop I was in, when the SP received a bad SQL return code, we would issue DISPLAY statements to show what the input and output parms were. We could view the display statements in the SPAS job. I don't see how you could have a DB2 solution (i.e. writing the parms to a table) if your calling program has to issue a rollback. [...]
11996 82 26_Re: Saving ROLLedBACK data14_Seth Bienstock19_sethdb2@COMCAST.NET31_Wed, 20 Jul 2005 19:31:36 +0000476_- Here is one possibility:
1) Insert row into (control?) table ASAP, after you've determined the parms that are ABOUT to be used to call the SP. Immediately issue a COMMIT.
2) Upon return from the SP, if a ROLLBACK is NOT going to be issued, then delete the aforementioned row.
One of the problems is that a failure can occur during any point in the process, and therefore you might not always be capable of updating a 'status' field within the row. [...]
12079 159 26_Re: Saving ROLLedBACK data12_Derez D Lusk24_derez.d.lusk@US.HSBC.COM31_Wed, 20 Jul 2005 14:31:23 -0500305_us-ascii Byron the only way he can do that is if the processed data is saved in a table in working storage and then process that table performing inserts in some type of table to be used for this type of process if DB2 will allow anything after the issue of the sql return code and it's abend state. [...]
12239 111 53_Re: Faster unload from IBM on Version 7 of DB2 on Zos12_Bill Shipley28_william_shipley@VANGUARD.COM31_Wed, 20 Jul 2005 15:49:14 -0400758_US-ASCII Mary Ann, there is the new unload using DSNUTILB sample JCL below. High Performance Unload is one of the new tools IBM is selling, if that is what you are referring to I can also provide sample JCL for that, just let me know.
//JOBCARD //* //STEP1 EXEC PGM=DSNUTILB, // PARM=(DB2SUBSYSTEM,'UTILID'), //* //STEPLIB DD DISP=SHR,DSN=DB2.SDSNEXIT < DB2 SYSTEM PDS // DD DISP=SHR,DSN=DB2.SDSNLOAD < DB2 SYSTEM PDS //ABNLIGNR DD DUMMY //DSSPRINT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //UTPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* UNLOAD TABLESPACE DBNAME.SPACENAM PUNCHDDN SYSPUN UNLDDN SYSREC SHRLEVEL CHANGE ISOLATION UR FROM TABLE OWNER.TABLENAME //*-------------------------------------------------------------------- //* [...]
12351 83 26_Re: Saving ROLLedBACK data12_McKown, John26_john.mckown@UICIINSCTR.COM31_Wed, 20 Jul 2005 14:52:27 -0500602_us-ascii > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of sally.mir@WACHOVIA.COM > Sent: Wednesday, July 20, 2005 2:18 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] Saving ROLLedBACK data > > > We're looking for a creative solution to this problem. Would > appreciate > any input from you experts..... > > The developer of a stored procedure wants to be able to > report upon the > parms passed to it from a calling program, but only when the calling > program decides to issue a ROLLBACK after returning from the > SP. In other [...]
12435 25 89_DB2 database vsam files, are no longer setup for Multi volume Datasets after Z/os upgrade9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Wed, 20 Jul 2005 15:10:16 -0500447_iso-8859-1 We upgraded to Z/OS 1.5 last weekend and did not change DB2 we are on version 7. Then we did a reorg on the DB2 databases. We are getting DB2 space errors, because the DB2 vsam files don't span multiple volumes. When a listcat is performed on the database vsam files, it does not indicate that the vsam dataset is elgible to span multiple volumes. I know that before the upgrade we had DB2 vsam datasets spanning multiple volumes. [...]
12461 54 26_Re: Saving ROLLedBACK data12_Fay, Colin M22_cfay@UNUMPROVIDENT.COM31_Wed, 20 Jul 2005 16:11:49 -0400433_us-ascii We use MQSERIES to write a message that initiates a transactions that adds the data to an error table.
MQ does not roll back , everything else does.
Colin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of sally.mir@WACHOVIA.COM Sent: Wednesday, July 20, 2005 3:18 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Saving ROLLedBACK data [...]
12516 64 27_Re: Z/os to Z/os DB2 access12_Carlos Olson23_Carlos.Olson@INOVIS.COM31_Wed, 20 Jul 2005 13:20:50 -0700558_us-ascii You can use FTP to access DB2 on another z/OS system. Look in the os/390 IP Users Guide v2r8. Chapter 3 is on FTP and has a section entitled "Performing DB2 SQL Queries with FTP". See chapter 14 of the IP Configuration manual on "Step 8: Install the SQL Query Function (Optional) and Access the DB2 Modules". To do SQL queries, you need to bind the EZAFTPMQ Plan used by FTP, grant execute to public, and add SDSNLOAD to LINKLIST. The sample bind job is provided in FTOEBIND member of the hlq.tcpip.SEZAINST data set. I just did this the other [...]
12581 200 26_Re: new redbook on the web7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 20 Jul 2005 13:36:09 -0700569_iso-8859-1 Very interesting discussion. The "Overhead" of logging comes in many forms. I suspect the CPU overhead is no higher than the same order of magnitude Roger alludes to.
I spend about 1/3 of my time on the dark side - or should I say the RED side - and 2/3 with the forces of good. In their world, especially for test support stuff, its common to import a database (Data + structures) using a single utility sequence. The utility does all inserts. In that world, you shut off archiving, do the import, and then reactivate it. No disk space consumed [...]
12782 101 26_Re: Saving ROLLedBACK data12_Kirk Hampton28_khampto1@CAPGEMINIENERGY.COM31_Wed, 20 Jul 2005 15:42:57 -0500389_us-ascii Colin, MQSeries does indeed have a rollback function, and we have seen situations where a failed CICS transaction causes a message to be rolled back and re-appear in a queue. I don't know what platform you are running your MQ on, but you may be lacking some coordination setup between MQ and DB2 and/or CICS that is letting you get away with MQ not rolling back. Be careful. [...]
12884 51 26_Re: Saving ROLLedBACK data12_McKown, John26_john.mckown@UICIINSCTR.COM31_Wed, 20 Jul 2005 15:51:06 -0500458_us-ascii > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kirk Hampton > Sent: Wednesday, July 20, 2005 3:43 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] Saving ROLLedBACK data > >
> John Mckown, > Sally did not specify her environment, but since she mentioned > adding a file to WLM, I am inferring that she in on a z/OS system, not > Unix. > > Kirk Hampton [...]
12936 63 68_[z/OS v7] Is SDSNEXIT shareable to 2 or more subsystems (one LPar) ?14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 20 Jul 2005 16:04:46 -0500384_US-ASCII This is a modified subject line, as the previous one did not seem to catch anyone's attention.
We are planning to do maintenance and migrations by LPar, so I would like to share some load libraries wherever possible.
My plan is to have separate sets of start-up decks for each subsystem, and for easier maintenance, share SDSNLINK, LOAD, RUNLIB & SDXRRESL [...]
13000 167 53_Re: Faster unload from IBM on Version 7 of DB2 on Zos13_Horacio Villa17_hvilla@AR.IBM.COM31_Wed, 20 Jul 2005 18:09:36 -0300676_US-ASCII Bill,
what's this //ABNLIGNR for?
Cheers,
Horacio Villa
Bill Shipley cc: Sent by: DB2 Data Subject: Re: [DB2-L] Faster unload from IBM on Version 7 of DB2 on Zos Base Discussion List
20/07/2005 16:49 Please respond to DB2 Database Discussion list at IDUG
Mary Ann, there is the new unload using DSNUTILB sample JCL below. High Performance Unload is one of the new tools IBM is selling, if that is what you are referring to I can also provide sample JCL for that, just let me know. [...]
13168 43 53_Re: Faster unload from IBM on Version 7 of DB2 on Zos12_McKown, John26_john.mckown@UICIINSCTR.COM31_Wed, 20 Jul 2005 16:16:18 -0500357_us-ascii > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Horacio Villa > Sent: Wednesday, July 20, 2005 4:10 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] Faster unload from IBM on Version 7 of DB2 on Zos > > > Bill, > > what's this //ABNLIGNR for? > > Cheers, > > Horacio Villa [...]
13212 83 34_Bonnie Baker at SIRDUG, Aug. 18-1911_Kathy Lisle19_Kathy.Lisle@ATT.NET31_Wed, 20 Jul 2005 17:26:57 -0400378_ISO-8859-1 *SIRDUG Meeting August 18 & 19, 2005
Featuring: Bonnie Baker * "If only someone had told me . . ."
Come hear 2 new presentations of things Bonnie wishes someone had told HER about DB2 for z/OS. Year after year, our SIRDUG surveys tell us that Bonnie is one of your favorite speakers, so we are delighted to bring her back for her 7th annual visit. [...]
13296 138 72_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsystems (one LPar) ?0_25_LL581@DAIMLERCHRYSLER.COM31_Wed, 20 Jul 2005 17:29:56 -0400606_US-ASCII Mark,
I think you can create as many copies as you want, but DB2 will only look at the one called DSNHDECP :)
As for the general question of doing maintenance by LPAR, what you are allowed to do will depend a lot on your maintenance environment.
Are your multiple DB2s' target libraries created from the same distribution libraries? How many SMP/E zones do you have defined for these two DB2s? Which of the SDSNLINK, SDSNLOAD, SDSNLOD2, and SDSNEXIT will you have in LNKLSTxx member of SYS1.PARMLIB? Do you use IMS and/or CICS? Does your shop allow JOBLIB stmts? Answers [...]
13435 227 26_Re: Saving ROLLedBACK data19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Wed, 20 Jul 2005 16:45:57 -0500478_us-ascii I like your solution. Of course, the problem here is that if there are multiple WLM's how do you insure that calling another stored procedure (to clean up this table) will run in all the WLM address spaces?
Rich Humphris
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Derez D Lusk Sent: Wednesday, July 20, 2005 2:31 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Saving ROLLedBACK data [...]
13663 77 72_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsystems (one LPar) ?9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 20 Jul 2005 16:56:25 -0500306_windows-1250 The only thing that I know the SSID in DECP does is set the default connection subsystem for the automatic connection of Call attach where you replace the DSNHLI with the version in DSNALI. and let the plan name default to the first program that makes a DB2 call. or something like that. [...]
13741 223 26_Re: Saving ROLLedBACK data15_Kumaresh Thimma26_Kumaresh_Thimma@JBHUNT.COM31_Wed, 20 Jul 2005 17:13:11 -0500511_US-ASCII How about this (I know it's ugly) ... 1. Program A calls stored procedure SP1 2. Program A receives bad return code from SP1 and decides to issue ROLLBACK 3. Program A calls a CICS program Program-B through "EXCI" 4. Program A issues ROLLBACK
I guess it will work?
Thanks, KT
Derez D Lusk To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: [DB2-L] Saving ROLLedBACK data [...]
13965 250 26_Re: Saving ROLLedBACK data15_Kumaresh Thimma26_Kumaresh_Thimma@JBHUNT.COM31_Wed, 20 Jul 2005 17:29:27 -0500665_US-ASCII Forgot to add this ...
CICS Program (Program B) inserts error parameters into a DB2 table.
KT
Kumaresh Thimma/Corporate/ JBHunt To DB2 Database Discussion list at 07/20/2005 05:13 IDUG PM cc
Subject Re: [DB2-L] Saving ROLLedBACK data (Document link: Kumaresh Thimma)
How about this (I know it's ugly) ... 1. Program A calls stored procedure SP1 2. Program A receives bad return code from SP1 and decides to issue ROLLBACK 3. Program A calls a CICS program Program-B through "EXCI" 4. Program A issues ROLLBACK [...]
14216 108 72_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsystems (one LPar) ?33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 21 Jul 2005 01:00:42 +0200362_windows-1250 We don't share the SDSNEXIT (different ZPARM settings) but SDSNLOAD,SDSNLOD2 and so on as long as all DB2 subsystem runs with the same servicelevel. In case of new service we create new set of all datasets and roll-out this new service to all other DB2 subsystems
To be very quick to go forword or backward we use symbolic relate alias. [...]
14325 111 72_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsystems (one LPar) ?54_Crane, Rob --- Manager Database Administration --- CFS27_rob.crane@FREIGHT.FEDEX.COM31_Wed, 20 Jul 2005 17:08:48 -0600527_utf-8 You can get around the issues mentioned below(activating new code levels on all subsystems simultaneously) by using an alias/path approach to control how you bring your various "environments" onto the new code level as well as isolating your running libraries from your SMP/E libraries.
Very common at large shops where 10-30 subsystems are upgraded in one evening. This approach has many advantageous for smaller shops as well. Key is to have a well though out install/upgrade plan with ease of use in mind. [...]
14437 93 75_Re: Mainframe Stored Procedures called from Client/Web front end thru DRDA.8_pjfjacks19_pjfjacks@SWBELL.NET31_Wed, 20 Jul 2005 19:58:19 -0500310_us-ascii Option C has worked well for us also via ASP/ASP.NET on front end and DB2 COBOL stored procedure on the mainframe side. Create and populate the GTT in the SP, open a cursor on it and leave it open - front end gets it back as an ADO/ADO.NET recordset.
Phil
Brendan - [...]
14531 59 75_Re: Mainframe Stored Procedures called from Client/Web front end thru DRDA.12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 20 Jul 2005 19:50:06 -0700544_iso-8859-1 Brendan, I'm not sure that A) is feasible with the GTTs being deleted upon end of control.
But both Option B and C are being done by my client. As well as other alternatives. Neither is better. It just depends upon the application and function within the application and business needs. I've got one application that has some stored procedures doing C and some doing B. And some doing a combination of B and C where one SP calls another to get data that is put into a GTT for the first to get and return and join to main [...]
14591 230 37_Re: {Z/OS V7} Trigger format question12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 20 Jul 2005 19:55:36 -0700578_iso-8859-1 Did you actually try something like this? The other DBA was unable to get this example to work either. Same problems as his original issue. If you have a working sample, we'd love to see it.
Thanks
Myron
--- Horacio Villa wrote:
> Try to add a WHEN (search condition) before BEGIN ATOMIC. > Something like: > > CREATE TRIGGER TRIG1 > AFTER UPDATE OF COL1 ON TABLEA > REFERENCING NEW AS NEW_A > FOR EACH ROW > MODE DB2SQL > WHEN (NEW_A.COL1 <> ' ') -- (for example) > BEGIN ATOMIC > VALUES CASE > WHEN NEW_A.COL1 = [...]
14822 116 72_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsystems (one LPar) ?0_20_pmclaren2@CSC.COM.AU31_Thu, 21 Jul 2005 13:57:55 +1000614_US-ASCII I guess this one ultimately depends on the installation (history) and application requirements. There are the cases where one DB2 may require differing DSNHDECP values for CCSID's, date/time and so on. Though most of ours, at client level, have the same values.
There is the case where the WLM_REFRESH (DSNTWR) stored proc looks in DECP for the SSID if not supplied by the caller...and it would retrieve it from the steplib (sdsnexit) of the WLM started task. There may be further considerations with the NEWFUN parm as you progress into V8. We always have one SDSNEXIT per DB2 subsystem, but [...]
14939 55 20_Control Center hangs19_Francesco Borgoglio30_Francesco.Borgoglio@CEDACRI.IT31_Thu, 21 Jul 2005 09:29:36 +0200412_US-ASCII Hi all. I have problem with GUI administration tools of db2. When i run db2cc.bat or db2ca.bat for example, the javaw processes start, but then these processes hang, as they don't reach the necessary quota of memory needed (it seems to me) and nothing happens, the processes are like frozen and the tools don't work. Have you experience about this problem, may anyone help me? Thank you very much. [...]
14995 187 73_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsyste ms (one LPar) ?13_Bell, Raymond22_raymond.bell@LANDG.COM31_Thu, 21 Jul 2005 08:35:50 +0100566_iso-8859-1 Mark,
Your earlier post did catch my attention; I wasn't just ignoring you, honest. Anyway, you've had loads of good responses so far so my further 2p won't matter much. But here it is anyway.
We share ALL our DB2 libraries for every subsystem on any given LPAR - and I hate it. As others have pointed out, it's a problem if you want to stage maintenance/upgrades. Having one subsystem taken out by a problem PTF (or fat fingers during migration) is one thing, but to lose them all? Not good. The flip side is that, when it goes right, [...]
15183 52 73_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsyste ms (one LPar) ?13_Michael Ebert18_mebert@AMADEUS.NET31_Thu, 21 Jul 2005 09:59:52 +0200543_us-ascii We also share all DB2 libraries per Sysplex, and I love it - in fact I instituted it. Actually we have two sets of libraries, a VERA and a VERB (version A & B). One set holds the current, the other the new SW version (after the upgrade, it's the current and the old). Apart from the two DB2.VERx.SDSNxxxx libs, there is an Alias DB2.SDSNxxxx which points to the correct one via a symbol maintained by the zOS systems guys. Once you've installed the new SW, the symbol gets switched, DB2 gets bounced (this may be done at a later [...]
15236 92 98_Re: [Maybe Spam] Re: [DB2-L] [z/OS v7] Is SDSNEXIT shareable to 2 or more subsyste ms (one LPar) ?13_Bell, Raymond22_raymond.bell@LANDG.COM31_Thu, 21 Jul 2005 10:12:07 +0100374_iso-8859-1 Dr E,
You're one up on us. You have the benefits of sharing system libraries (quick, multiple software distribution) with none of the drawbacks (cannot part-push/backout software). I do like the alias approach and have seen it work well, but not here. We just dump the datasets down and hope for the best. Well, maybe not 'hope' but you get the idea. [...]
15329 246 72_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsystems (one LPar) ?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 21 Jul 2005 10:30:25 +0100484_us-ascii DSNHDECP only specifies the DEFAULT subsystem ID to connect to in the event you connect WITHOUT specifying a ssid (normally this is only applicable from CAF or RRSAF connections). Otherwise, provided all the other DSNHDECP settings are the same between all subsystems, by all means share the library.
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
15576 261 73_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsyste ms (one LPar) ?13_Bell, Raymond22_raymond.bell@LANDG.COM31_Thu, 21 Jul 2005 10:36:54 +0100654_iso-8859-1 Ah, it's CAF. Not CLI. Oops. Cheers, Phil.
Raymond Bell Database Administrator
-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: 21 July 2005 10:30 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [z/OS v7] Is SDSNEXIT shareable to 2 or more subsystems (one LPar) ?
DSNHDECP only specifies the DEFAULT subsystem ID to connect to in the event you connect WITHOUT specifying a ssid (normally this is only applicable from CAF or RRSAF connections). Otherwise, provided all the other DSNHDECP settings are the same between all subsystems, by all means share the library. [...]
15838 30 73_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsyste ms (one LPar) ?13_Michael Ebert18_mebert@AMADEUS.NET31_Thu, 21 Jul 2005 11:48:07 +0200473_us-ascii Hi Mr B,
indeed I am. In fact, I'm only doing DB2 part-time now. I've already done my OCA (Oracle certified Amateur - well, they call it Associate, but the next level is Professional) certification. So I spend the other part of my time wondering a) which unix box do I have to be on; b) whether I'm logged in as the right user, and who's changed the password??; c) am I in the right directory, d) now what is the corresponging Oracle user/password.... [...]
15869 62 73_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsyste ms (one LPar) ?13_Bell, Raymond22_raymond.bell@LANDG.COM31_Thu, 21 Jul 2005 11:37:36 +0100318_iso-8859-1 Hmmm, my empathies. I'm going down the Dark Side too, albeit DB2 UDB on NT. Now, which server? Which database? Which userid/password? And which of the 50 windows I've got open is the one I want?!? Aaargh! Bring back z/OS, all is forgiven. If you can't do it in a split-screen session it can't be done. [...]
15932 314 19_Re: Lock escalation19_Francesco Borgoglio30_Francesco.Borgoglio@CEDACRI.IT31_Thu, 21 Jul 2005 13:21:27 +0200452_ISO-8859-1 I think i have circumscribed the problem. A very mussive use of cursor and fetch cursor. Can you give me suggestions for improve performance, when i use cursors? My doubt is also about if heavy use of cursor may produce network decay, could these one be the suspect for the recent time dilation in my procedure? I think so, because one time ago, my apllication server and db server were on the same machine and now have been separeted. [...]
16247 37 73_Re: [z/OS v7] Is SDSNEXIT shareable to 2 or more subsyste ms (one LPar) ?14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Thu, 21 Jul 2005 07:52:53 -0500364_US-ASCII Many thanks for all your responses, I especially appreciate views from both sides of the "shared environment" fence. I have lots to consider and ponder - this is where the procrastinator needs to get squashed so I can move forward. thanks and have a great day, Mark.
---------------------------------------------------------------------------------
16285 24 26_DB2 for Z/OS Scope command4_Mary18_Mary.Friel@IBX.COM31_Thu, 21 Jul 2005 08:25:22 -0500541_- Hi,
I currently have my subsystems set up with command recognition scope set to "S" the recommended default. We do not have data sharing. We were thinking about changing the SCOPE from "S" to "M" to prevent commands from being routed to another lpar. I've read that if you want to use ARM (automatic restart manager), you need to have the SCOPE set to S in IEFSSN00. I changed the SCOPE to an M, ipl'd the system and then tried to force an abend to see what would happen. I tried this with a test system and was surprised that [...]
16310 18 31_Opinions: UDB/Linux vs. UDB/AIX10_M Rosinger19_mrosinger@CCIWS.COM31_Thu, 21 Jul 2005 08:16:30 -0500408_- Greetings! I am a newbie to this list.
We are currently running our production database in DB2/VSE. We are considering porting the database to UDB. We've gotten conflicting advice as to which platform would be best to run UDB - either Linux/SuSe or AIX. The 2 sources that are urging us to use AIX will benefit financially from the transaction, so it seems clear why they are recommending AIX. [...]
16329 175 53_Re: Faster unload from IBM on Version 7 of DB2 on Zos17_Kumar Vaddadi/EIG37_Kumar.Vaddadi@ECONOMICALINSURANCE.COM31_Thu, 21 Jul 2005 09:49:19 -0400626_us-ascii REORG with UNLOAD ONLY option seems faster for me.
************* Thanks & Regards ******************* Vaddadi Shyam Kumar DB2 DBA, Data Management Group The Economical Insurance Group, Waterloo. Reach me @ 519-570-8500 ext 2242 ********************************************************
|---------+------------------------------> | | Bill Shipley | | | | | | Sent by: DB2 Data | | | Base Discussion | | | List | | | | | | | | | | | | 07/20/2005 03:49 PM| | | Please respond to | | | DB2 Database | | | Discussion list at | | | [...]
16505 228 53_Re: Faster unload from IBM on Version 7 of DB2 on Zos12_Bill Shipley28_william_shipley@VANGUARD.COM31_Thu, 21 Jul 2005 09:50:05 -0400440_US-ASCII Horacio, it is an Abend-AID DD that suppresses Abend-AID processing. I should have deleted it, but since it is DUMMY it shouldn't hurt.
Bill Shipley IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for OS/390 The Vanguard Group, Inc. Malvern, PA "The views expressed here are mine and do not reflect the official opinion of my employer or the organization through which the Internet was accessed." [...]
16734 45 26_UDB (windows) memory usage27_DB2 Database Solutions Port26_db2dba_certified@YAHOO.COM31_Thu, 21 Jul 2005 06:53:45 -0700451_iso-8859-1 UDB gurus: Our client had udb v8.2( 9a fix pack) on win2003 which has 3GB RAM. I noticed that it takes a lot of time when we open udb task center. I also noticed a while ago that db2 could not activate bufferpools as 'not enough memory'. After I cut the size of each bufferpool, I could activate all the bufferpools. Does it mean that we need more RAM for bigger bufferpools???. [when I run db2mtrk, it shows 1.6 gb total used memory] [...]
16780 29 49_[DB2 z/OS V7] Format Package SQL from SYSPACKSTMT17_Chris Worthington20_cworthi@AGRIBANK.COM31_Thu, 21 Jul 2005 09:00:20 -0500390_- We have several vendor packages that each include the ability to display package SQL (presumably derived from the STMT column of the SYSPACKSTMT table) in a more "friendly" and easily read format, for example...
a SQL stmt in SYSPACKSTMT may looks like this...SELECT CURRENT TIMESTAMP INTO : H FROM SYSIBM . SYSDUMMY1 .......... .........D.....WW-WORK-AREA.WW- CURRENT-TSTAMP [...]
16810 66 53_Re: [DB2 z/OS V7] Format Package SQL from SYSPACKSTMT14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 21 Jul 2005 15:22:29 +0100471_us-ascii Not sure what you mean by "programmatic access"?
The simplest way would be to display the SQL text in your favourite tool and then just cut and paste it into your favourite execution tool. All being well, said tool will then prompt you for :host_variable data (like CAs ISQL does)
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
16877 78 53_Re: [DB2 z/OS V7] Format Package SQL from SYSPACKSTMT17_Chris Worthington20_cworthi@AGRIBANK.COM31_Thu, 21 Jul 2005 09:28:46 -0500640_- Phil, I would need to access the formatted SQL for display purposes within an ASP application (in-house developed stored procedure documentation tool).
On Thu, 21 Jul 2005 15:22:29 +0100, Grainger, Phil wrote:
>Not sure what you mean by "programmatic access"? > >The simplest way would be to display the SQL text in your favourite tool >and then just cut and paste it into your favourite execution tool. All >being well, said tool will then prompt you for :host_variable data (like >CAs ISQL does) > > >Phil Grainger >Computer Associates >Product Manager, DB2 >Tel: +44 (0)161 928 9334 >Fax: +44 [...]
16956 67 58_[z/OS] in need of training - systems programming (install)14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Thu, 21 Jul 2005 09:55:24 -0500525_US-ASCII I recently attended IBM's CF850 training class - DB2 UDB for z/OS and OS/390 System Administration.
I did not get what I wanted out of it and I am wanting more in depth Systems Programming training. I probably don't know exactly what I need, but from the limited knowledge I have, I think I need SMP/E, hopefully bring up a subsystem from scratch, D.R., more in depth ZParms stuff, Buffer/EDM/RID Pools - the real guts of what I need to learn to be able to really do the job of a DB2 systems programmer. [...]
17024 118 53_Re: [DB2 z/OS V7] Format Package SQL from SYSPACKSTMT14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 21 Jul 2005 16:03:19 +0100594_us-ascii I'm sure there is some REXX lying around somewhere to do this, but are you prepared for the complexities of Unicode conversion when you move to v8??
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Worthington Sent: 21 July 2005 15:29 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [DB2 z/OS V7] Format Package SQL from SYSPACKSTMT [...]
17143 41 62_Re: [z/OS] in need of training - systems programming (install)7_Db2 DBA21_agarwalamit@YAHOO.COM31_Thu, 21 Jul 2005 08:10:15 -0700586_iso-8859-1 I was trying to find out this information as well. I would be interested to know if IBM or other vendors offer a class for the following:
1> Creating subsystems from scratch 2> Upgrading subsystems via SMPE
>>> I did not get what I wanted out of it and I am wanting more in depth Systems Programming training. I probably don't know exactly what I need, but from the limited knowledge I have, I think I need SMP/E, hopefully bring up a subsystem from scratch, D.R., more in depth ZParms stuff, Buffer/EDM/RID Pools - the real guts of what I [...]
17185 92 62_Re: [z/OS] in need of training - systems programming (install)0_17_sjvagnier@AEP.COM31_Thu, 21 Jul 2005 11:20:26 -0400524_US-ASCII Mark, for what it is worth, here is my suggestion of classes that should be taken for systems programming. All of these are IBM classes.
SMPE for Z/OS and OS/390 Workshop DB2 for OS/390 Data Sharing Recovery and Restart (Optionl, only if using Data Sharing) DB2 for OS/390 System Performance and Tuning DB2 UDB for OS/390 Data Sharing Implementation Workshop (optiona, only if going to Data Sharing) DB2 UDB for OS/390 System/Disaster Recovery Workshop DB2 UDB for Z/OS and OS/390 System Administration [...]
17278 88 35_Re: Opinions: UDB/Linux vs. UDB/AIX15_Leon Katsnelson15_leon@CA.IBM.COM31_Thu, 21 Jul 2005 11:45:45 -0400347_US-ASCII DB2 runs great on both Linux and AIX. The 3 main questions that you need to answer for yourself are: how big a database server will this be i.e. how many CPUs are you going to have eventually and what system administration skill (Linux or AIX) do I have or can get easier and cheaper, and am I comfortable with Linux as the platform [...]
17367 123 62_Re: [z/OS] in need of training - systems programming (install)14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Thu, 21 Jul 2005 08:47:25 -0700620_iso-8859-1 Mainframe Systems Programming tends to be a non-trivial task. Some amount of training as well as a lot of practical experience is required.
For product support of DB2 I would recommend the following before attempting to go it alone. SMP/E Training at least 4 weeks over 2 years. At least 2 classes at T+0 years and T+1 year. SMP Practical ... Over 1 year of doing preventive service (4+ cycles) with supervision. over 1 year and 6 applications of corrective service with supervision Vendor problem management of at least 24 issues with supervision DB2 Structure and installation 2+ weeks training [...]
17491 32 54_DB2 group id not picked when using Developement Center15_Basivi Inaganti22_inaganb@NATIONWIDE.COM31_Thu, 21 Jul 2005 12:39:45 -0500397_ISO-8859-1 Hi All, The user id User1 is attached to group1 on Unix/Linux. Group1 got SELECT permission on Tab1. When User1 coded "select * from Tab1" in SQL stored procedure using Development Center and tries to build, it is failing with auth error saying that User1 does not have SELECT permission on table Tab1. He is able to run the same query on Tab1 using command window or other tools. [...]
17524 15 53_Re: Faster unload from IBM on Version 7 of DB2 on Zos9_Jim Ruddy18_jaruddy@US.IBM.COM31_Thu, 21 Jul 2005 13:25:37 -0500729_- REORG UNLOAD ONLY is useful ONLY for reloading back into the exact same tablespace and table. For reloading into another table then you need to use REORG UNLOAD EXTERNAL, UNLOAD, or one of th emany unload products.
Jim Ruddy DB2 for z/OS Development
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
17540 30 54_Continuing saga - RE: Loading data from re-org archive0_25_Dave.Schaeffer@BENDIX.COM31_Thu, 21 Jul 2005 14:31:37 -0400323_us-ascii I'm attempting to load archived DB2 data that that was extracted using the BMC re-org utility about 8 years ago. I ended up writing a REXX utility to convert the decimal data to something that I can use, however I've ran across a problem.
Here is an example of the data that isn't causing me an issue: [...]
17571 54 58_Re: Continuing saga - RE: Loading data from re-org archive17_Travis Bindenagel31_Travis.Bindenagel@EAC-EASCI.ORG31_Thu, 21 Jul 2005 13:46:53 -0500470_us-ascii There are 2 ways....one is to flip all the bits (1's complement): 6 = 00000110 -6 = 11111001
The other is to flip the bits and add 1 (2's complement): -6 = 11111010
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dave.Schaeffer@BENDIX.COM Sent: Thursday, July 21, 2005 1:32 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Continuing saga - RE: Loading data from re-org archive [...]
17626 66 58_Re: Continuing saga - RE: Loading data from re-org archive12_McKown, John26_john.mckown@UICIINSCTR.COM31_Thu, 21 Jul 2005 13:57:35 -0500585_us-ascii > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dave.Schaeffer@BENDIX.COM > Sent: Thursday, July 21, 2005 1:32 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] Continuing saga - RE: Loading data from > re-org archive > > > I'm attempting to load archived DB2 data that that was extracted using > the BMC re-org utility about 8 years ago. I ended up writing a REXX > utility to convert the decimal data to something that I can > use, however > I've ran across a problem. > > Here is an example of the data [...]
17693 132 66_Proliferation of DB2 processes in UDB EXE(LUW) 8.2.2 on Linux IA3213_George Peters22_wombat53@OPTONLINE.NET31_Thu, 21 Jul 2005 14:51:27 -0400490_us-ascii Group I have to present something I have not seen since first becoming familiar with DB2 UDB off-host in all its many incarnations..OS2/ EE DBM, DB2/2, Common Server and now UDB ESE (LUW) V8.2.2 (aka FP 8.1.9a). Linux is SLACKWARE 10.1, not "validated" by IBM, I know, but the kernel is the kernel, and I am not talking about distro package management differences etc. (UDB is RPM-based as are RHEL, SLES, etc, while some distros are not, but this is another discussion.....) [...]
17826 151 70_Re: Proliferation of DB2 processes in UDB EXE(LUW) 8.2.2 on Linux IA3213_George Peters22_wombat53@OPTONLINE.NET31_Thu, 21 Jul 2005 16:28:23 -0400567_iso-8859-1 Of course I am assuming that db2hmon is somehow related to the Health Monitor, and it may not be. It is not a documented process in Snow/Chong DevWorks paper of April 2003 on DB2 UDB processes, and as I mentioned, I had switched Health_mon off (in DBM CFG). It must be something else, perhaps new since publication of that paper? Thanks On Thursday 21 July 2005 02:51 pm, George Peters wrote: > Group > I have to present something I have not seen since first becoming familiar > with DB2 UDB off-host in all its many incarnations..OS2/ EE DBM, DB2/2, [...]
17978 16 53_Re: Faster unload from IBM on Version 7 of DB2 on Zos6_ducduc17_ndt.db2@GMAIL.COM31_Thu, 21 Jul 2005 22:30:51 +0200565_ISO-8859-1 and UNLOAD is faster then REORG UNLOAD external , cf. Redbook V7 performance topics
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
17995 49 30_Re: UDB (windows) memory usage6_ducduc17_ndt.db2@GMAIL.COM31_Thu, 21 Jul 2005 22:35:41 +0200626_ISO-8859-1 try this link "The udb memory model" http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0406qi/
On 7/21/05, DB2 Database Solutions Port wrote: > UDB gurus: > Our client had udb v8.2( 9a fix pack) on win2003 which has 3GB RAM. I > noticed that it takes a lot of time when we open udb task center. I also > noticed a while ago that db2 could not activate bufferpools as 'not enough > memory'. After I cut the size of each bufferpool, I could activate all the > bufferpools. Does it mean that we need more RAM for bigger bufferpools???. > [when I run db2mtrk, it [...]
18045 76 30_Re: UDB (windows) memory usage27_DB2 Database Solutions Port26_db2dba_certified@YAHOO.COM31_Thu, 21 Jul 2005 13:55:52 -0700397_iso-8859-1 I used this memory model and put everything in a spreadsheet. It got instance mem, db shared mem, appl group mem and agent pvt mem categories. When I connect to database and use db2mtrk command, it shows the allocated db shared memory little less than 1.5GB (below the calculated value). If I increase the size of bufferpools, it says 'not enough memory' error. Does IBM support?. [...]
18122 12 29_Re: any comment on this sql ?15_Daniel Cremieux17_c300501@YAHOO.COM31_Thu, 21 Jul 2005 15:58:32 -0500585_- thank you patrick ! i was perplex as the trace shows that only one table is accessed, i have the explanation now
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
18135 55 58_Re: Continuing saga - RE: Loading data from re-org archive14_Wayne Driscoll34_wdriscoll@WESTERN-METAL-SUPPLY.COM31_Thu, 21 Jul 2005 17:35:23 -0500541_us-ascii Dave, The format of data in DB2 is described in the Diagnosis Guide and Reference, which is a licensed manual. You will need to look at that manual. Wayne Driscoll Product Developer Western Metal Supply NOTE: All opinions are strictly my own.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dave.Schaeffer@BENDIX.COM Sent: Thursday, July 21, 2005 1:32 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Continuing saga - RE: Loading data from re-org archive [...]
18191 291 30_Re: UDB (windows) memory usage11_Grant Allen28_Grant.Allen@TOWERSOFT.COM.AU31_Fri, 22 Jul 2005 11:00:34 +1000590_iso-8859-1 A couple of things to consider.
1. Once you approach 1.7(ish) GB for a process under normal circumstances, DB2 plus all the other crap running on the windoze box in user-mode memory will be approaching the normal 2GB limit for all user processes.
2. Have you thought about the /4GT boot.ini switch on win2003 to shift the user/kernel memory boundary from the 2GB level to the 3GB level? Without this, only kernel processes will have access to your highest GB of memory. (i.e. not DB2). You might need to experiment - don't know what happens with this on a box [...]
18483 103 58_Re: Continuing saga - RE: Loading data from re-org archive13_Horacio Villa17_hvilla@AR.IBM.COM31_Thu, 21 Jul 2005 22:21:19 -0300860_KOI8-R
This is in Administration Guide, Appendix1.2.12.8 DB2 codes for numeric data.
DECIMAL Save the high-order hexadecimal digit (sign digit). Shift the number to the left one hexadecimal digit. If the sign digit is X'F', put X'C' in the low-order position. Otherwise, invert all bits in the number and put X'D' in the low-order position. Value Means ... F001 001C (+1) 0FFE 001D (-1)
[...]
18587 37 27_using trigger to enforce RI10_John Lantz20_john.p.lantz@FRB.GOV31_Thu, 21 Jul 2005 21:39:30 -0500288_- I'm trying to create an INSERT trigger on a table that will verify RI. Before a row is inserted, I want to take the value of a column (ID_RSSD in this example) and use it to lookup the value on another table. If I can't find a row on the lookup table, the INSERT should not occur. [...]
18625 68 31_Re: using trigger to enforce RI10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 22 Jul 2005 13:03:45 +1000519_utf-8 Hi John,
Try,
CREATE TRIGGER VALIDID NO CASCADE BEFORE INSERT ON OWNER.TEST_TRIGGER REFERENCING NEW AS NEW_ROW FOR EACH ROW MODE DB2SQL WHEN (NOT EXISTS ( SELECT 1 FROM OWNER.CUT_ATTRIBUTES WHERE ID_RSSD = NEW.ID_RSSD)) BEGIN ATOMIC SIGNAL SQLSTATE '75001' ('ID_RSSD DOES NOT EXISTS'); END$
Regards, Kals
John Lantz Sent by: DB2 Data Base Discussion List 22/07/2005 14:39 Please respond to DB2 Database Discussion list at IDUG [...]