1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2000, week 5
2 18 22_foreign key defination12_Rakesh Kumar21_rakesh457@HOTMAIL.COM29_Mon, 29 May 2000 08:05:00 GMT538_- Hi list , Can a table have both foreign key and primary key ? And my second question is can the foreign key contain null value ?
Rakesh Kumar ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21 93 69_Re: DB2 V7.1 Beta connect problems, anybody else testing this thi ng?14_Arendt, Volker28_arendt@WIWI.UNI-WUPPERTAL.DE31_Mon, 29 May 2000 10:33:45 +0200737_iso-8859-1 Hello Dylan,
where do i find the beta-version of DB2 7.1?
With kindest regards
Volker Arendt ------------------------------------------------------------------------ Volker Arendt mailto:arendt@wiwi.uni-wuppertal.de Gaußstr. 20 Tel : +49(202)4392448 42097 Wuppertal, Germany Fax: +49(202)4392448 University of Wuppertal - Department of Economics (FB 6) ------------------------------------------------------------------------
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Dylan Vanderhoof Sent: Samstag, 27. Mai 2000 22:48 To: DB2-L@RYCI.COM Subject: DB2 V7.1 Beta connect problems, anybody else testing this thing? [...]
115 41 26_Re: foreign key defination14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Mon, 29 May 2000 10:51:12 +0100668_us-ascii Rakesh,
the answer to both your questions is yes
Regards Ruediger Kurtz
Rakesh Kumar schrieb: > > Hi list , > Can a table have both foreign key and primary key ? And my second > question is can the foreign key contain null value ? > > Rakesh Kumar > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
157 34 26_Re: foreign key defination17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Mon, 29 May 2000 14:20:45 +0500691_- Hello, The answer is YES to both your questions.
VIJAY
> -----Original Message----- > From: Rakesh Kumar [SMTP:rakesh457@HOTMAIL.COM] > Sent: Monday, May 29, 2000 1:35 PM > To: DB2-L@RYCI.COM > Subject: foreign key defination > > Hi list , > Can a table have both foreign key and primary key ? And my second > question is can the foreign key contain null value ? > > Rakesh Kumar > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L [...]
192 130 69_Re: DB2 V7.1 Beta connect problems, anybody else testing this thi ng?16_Dylan Vanderhoof20_DylanV@SEMAPHORE.COM31_Mon, 29 May 2000 03:43:16 -0700754_iso-8859-1 www.software.ibm.com =)
Go to the DB2 section, there's a link for registering to download the beta code or have it sent via CD.
-Dylan
---------------------------------------------------------------------------- ------------------- Dylan C. Vanderhoof Internal Software Developer Semaphore Corporation
"Programmers are useful tools to turn caffeine into source code." -- Unknown ---------------------------------------------------------------------------- -------------------
-----Original Message----- From: Arendt, Volker [mailto:arendt@WIWI.UNI-WUPPERTAL.DE] Sent: Monday, May 29, 2000 1:34 AM To: DB2-L@RYCI.COM Subject: Re: DB2 V7.1 Beta connect problems, anybody else testing this thi ng? [...]
323 150 70_Re: DB2 V7.1 Beta connect problems, anybody else test ing this thi ng?14_Arendt, Volker28_arendt@WIWI.UNI-WUPPERTAL.DE31_Mon, 29 May 2000 14:58:46 +0200448_iso-8859-1 Thanks a lot.
Volker
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Dylan Vanderhoof Sent: Montag, 29. Mai 2000 12:43 To: DB2-L@RYCI.COM Subject: Re: DB2 V7.1 Beta connect problems, anybody else testing this thi ng?
www.software.ibm.com =)
Go to the DB2 section, there's a link for registering to download the beta code or have it sent via CD. [...]
474 34 20_Changing bufferpools18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Mon, 29 May 2000 15:25:47 -0400597_iso-8859-1 I'm stuck! I altered BufferPool BP7 to be allocated at 6000 (4K) pages and used the -alter bufferpool command. It seemed to work just fine.(command was -alter bufferpool(bp7) vpsize(6000) vpseqt(98) Then I did the -alter database DSNDB07 bufferpool BP7 and that seemed to work just fine. Got good completion codes from both stmts. Now the question: 'How come DSNDB07 is NOT using BP7?? When I do a -dis bufferpool(bp7) detail it tell me the 'allocation is 0'. When I look at the sysibm.sysdatabase and select on DSNDB07 it tells me the BPOOL is 'BP7'. Guess I'm confused as to why [...]
509 84 24_FW: Changing bufferpools18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Mon, 29 May 2000 15:46:11 -0400369_iso-8859-1 I thought I would include this cut & paste. Its from my -dis bufferpool(bp7) detail I thought I would see the 'ALLOCATED =' stmt to be 6000 but its at '0'?? Thanks:
DSNB401I -PR30 BUFFERPOOL NAME BP7, BUFFERPOOL ID 7, USE COUNT 0
DSNB402I -PR30 VIRTUAL BUFFERPOOL SIZE = 6000 BUFFERS
ALLOCATED = 0 TO BE DELETED = 0 [...]
594 121 28_Re: FW: Changing bufferpools15_Toine Michielse18_vndobtm@US.IBM.COM31_Mon, 29 May 2000 22:36:39 +0100403_us-ascii Hello Steve,
You have to alter the bpool of the tablespaces that are defined in DSNDB07 and stop/start them. The new bufferpool definition will take effect at the next allocation.
Regards,
Toine Michielse DB2 for OS/390 Technical Specialist Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...]
716 15 28_Re: FW: Changing bufferpools26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Mon, 29 May 2000 16:26:52 -0500372_- Think I cut mine out of the DSNTIJTM job in NEW.SDSNSAMP Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
732 67 42_Re: partition on the month of the db2 date14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 30 May 2000 14:12:39 +1000282_iso-8859-1 Vishy,
Are the trace records hitting the buffer, or is the buffer not getting full enough to trigger the ECB? One way to find out is to add a timer to your WAIT - so you'll be woken up every, say, 5 seconds. Your READA will pick up whatever is in the buffer. [...]
800 68 30_How do I quiesce a tablespace?0_13_imm.it@DSG.DK31_Tue, 30 May 2000 09:56:17 +0100366_us-ascii Hello list.
We are running DB2 UDB EEE v5.2fp12 on AIX v4.2.1.0. Yesterday one of our load-operations abended and left a tablespace in an inaccessible state and now it is impossible to backup the database.
I tried the following to remedy the situation:
db2_all db2 list tablespaces show detail
The tablespace in error shows [...]
869 69 24_Re: Changing bufferpools0_27_jim.leask@RS-COMPONENTS.COM31_Tue, 30 May 2000 09:47:09 +0100329_iso-8859-1 Steve,
When a new buffer pool is created DB2 will not collect statistics for it unless it was present at DB2 start up time (I believe). Next time you stop/start DB2 you will see the statistics.
If you have a monitor that shows which datasets are in BP7 your DSNDB07 datasets should be listed there. [...]
939 108 24_Re: Changing bufferpools0_19_mike.holmans@BT.COM31_Tue, 30 May 2000 11:31:38 +0100373_- Have you actually tried running something which uses DSNDB07? We had a similar situation last week when setting up a new data sharing member, and it didn't show anything as allocated until we ran something which needed the bufferpool, when numbers magically appeared in response to a -DIS BP. As I said, it was a different situation, so this may not apply to yours. [...]
1048 148 24_Re: Changing bufferpools18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Tue, 30 May 2000 06:52:39 -0400568_iso-8859-1 Mike: Thanks. I did run some 'order by's' and I also have a Bufferpool Tool that I can use to run against this particular subsystem. I ran the bufferpool tool and it does show DSNDB07 using the new BP7 bufferpool. My confusion is that the -dis bufferpool(bp7) detail command does not show me any 'allocation'. It stills show's as '0' in the detail report. One thought was that the next time DB2 was stopped and started that this 'allocation' would show up. We have an IPL of this particular subsystem scheduled for this coming weekend so I guess I can [...]
1197 23 36_Copy from FIC with CONCURRENT Option0_23_duerr_jacobsg@WESTLB.DE31_Tue, 30 May 2000 13:07:30 +0100406_us-ascii Hello DB2-list,
I have the following question concerning DB2 V5.1 on OS/390:
Formerly I copied on demand from DB2 FIC with DSN1COPY to a different DB2 (450 TS). Now there is the need to implement DB2 FIC with the CONCURRENT Option. As I've read, I can't use these copies for DSN1COPY. Does there exist any software/utility which can apply data from this source to a target DB2? [...]
1221 87 34_Re: How do I quiesce a tablespace?17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Tue, 30 May 2000 16:53:22 +0500602_- Hello, By saying 'inaccessible state' are you referring to the pending flags for the tablespace after you run the load??
VIJAY
> -----Original Message----- > From: imm.it@DSG.DK [SMTP:imm.it@DSG.DK] > Sent: Tuesday, May 30, 2000 2:26 PM > To: DB2-L@RYCI.COM > Subject: How do I quiesce a tablespace? > > Hello list. > > We are running DB2 UDB EEE v5.2fp12 on AIX v4.2.1.0. Yesterday one of our > load-operations abended and left a tablespace in an inaccessible state and > now > it is impossible to backup the database. > > I tried the following to remedy the situation: > [...]
1309 25 27_FUNCTION IDENTITY_VAL_LOCAL19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 30 May 2000 07:04:24 -0500632_ISO-8859-1 Hi all, Has anyone used the subject function yet? Please share the results, experiences. TIA, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is [...]
1335 137 34_Re: How do I quiesce a tablespace?0_13_imm.it@DSG.DK31_Tue, 30 May 2000 14:14:19 +0100496_iso-8859-1
Hello Vijay
Thank you for the reply.
Yes, I want to reset the EXCLUSIVE state to NORMAL. I believe it is possible without restarting the load, but maybe I am wrong?
Best regards Ib-Michael
Vijay Subramanyam - 30-05-2000 12:53:22
Besvar venligst til DB2 Data Base Discussion List
Til: DB2-L@RYCI.COM cc: (bcc: Ib-Michael Martinsen/EDB/Dansk Supermarked) [...]
1473 172 24_Re: Changing bufferpools11_Danny Davis16_DTDAVIS@PCMH.COM31_Tue, 30 May 2000 08:20:20 -0400613_US-ASCII After doing your alter, you need to stop and start DSNDB07.
>>> "Whittaker, Stephen" 05/30/00 06:52AM >>> Mike: Thanks. I did run some 'order by's' and I also have a Bufferpool Tool that I can use to run against this particular subsystem. I ran the bufferpool tool and it does show DSNDB07 using the new BP7 bufferpool. My confusion is that the -dis bufferpool(bp7) detail command does not show me any 'allocation'. It stills show's as '0' in the detail report. One thought was that the next time DB2 was stopped and started that this 'allocation' would show up. [...]
1646 14 57_Re: DB2-L Digest - 29 May 2000 to 30 May 2000 (#2000-158)12_Peter Faller27_peter.faller@PRUDENTIAL.COM31_Tue, 30 May 2000 08:23:17 -0400353_us-ascii Bufferpool problem to Steve Whittaker Try stopping and starting the tablespace you put in bufferpool 7
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1661 123 31_Re: ESS/Shark DASD expectations4_IBM116_IBM1@UBIL.COM.TR31_Tue, 30 May 2000 15:26:34 +0300595_- hello rick,
today's information from our ibm sales rep. is that unexpectedly SNAPSHOT will be available next week (1 or 2 months before the date we expected it), therefore customers who have already ordered it will be receiving it within the next 2 weeks.
good news for once, uh?
ciao!
Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@ubil.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...]
1785 16 19_Datajoiner Question18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 30 May 2000 08:33:34 -0400452_- Has any connected Datajoiner 2.1.1 to a UDB V6.1 database? If so, what is the syntax you used for the CREATE SERVER MAPPING command?
Peter J. Krawetzky Aetna, Inc. DataBase Administrator (860) 273-0301
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1802 100 36_Re: RES: DB2 Log records recovery !!4_IBM116_IBM1@UBIL.COM.TR31_Tue, 30 May 2000 15:47:06 +0300725_- did I ask for a copy already?
if not, please send one to aurora.dellanno@sistinf.it
ciao!
Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@ubil.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced.
> -----Original Message----- > From: Roland Chua [SMTP:rolandchua@SINGAPOREEXCHANGE.COM] > Sent: Thursday, May 25, 2000 9:25 AM > To: DB2-L@RYCI.COM > Subject: Re: RES: DB2 Log records recovery !! > > Please send me a copy too. e-mail address : > rolandchua@singaporeexchange.com > Thanks > > Roland > > > > > Walter De Assis [...]
1903 184 30_Re: Priced Utility Features V74_IBM116_IBM1@UBIL.COM.TR31_Tue, 30 May 2000 16:04:53 +0300366_iso-8859-9 hello,
just one simple question to the fellow IBMers who might know: when is the final decision going to be made? until that time comes, I might just decide to sign off the list since just about every-other message on this list is some very interesting (but in my PERSONAL AND MEANINGLESS opinion totally useless for the time being) rethoric. [...]
2088 54 34_Re: How do I quiesce a tablespace?17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Tue, 30 May 2000 18:30:59 +0500582_iso-8859-1 Hello,
It is better to investigate why the LOAD abended & RELOAD the data. It is not advisable to reset flags until u know the data that u have loaded is perfectly fine regarding the RI. You can reset the pending flags without re-starting the load.
VIJAY
> -----Original Message----- > From: imm.it@DSG.DK [SMTP:imm.it@DSG.DK] > Sent: Tuesday, May 30, 2000 6:44 PM > To: DB2-L@RYCI.COM > Subject: Re: How do I quiesce a tablespace? > > > Hello Vijay > > Thank you for the reply. > > Yes, I want to reset the EXCLUSIVE state to NORMAL. I believe [...]
2143 47 37_Re: Managing the Logical Unit of Work19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 30 May 2000 08:05:29 -0500591_ISO-8859-1 James, MQSeries, CICS and DB2 are all RRSAF capable, thus, two phase commit is available. Don't know of a way to achieve two phase commit across all the products you mentioned. Are you replicating to SQL Server? HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender [...]
2191 30 19_DSNTIAUL - DSNT496I13_Glenn Andrews16_gandrew3@CSC.COM31_Tue, 30 May 2000 08:57:59 -0400341_us-ascii I am trying to unload all of our tables using DSNTIAUL. Only one table is not working. This table has 313 columns which is the most of any tables. It has three VARCHAR columns at the end of the table but some of the other tables also have multiple VARCHAR columns at the end. The DSNTIAUL program shows the following messages: [...]
2222 286 51_Repost: New Records for Lawson Benchmarks Using DB213_Morrill, John12_JohnM@VP.NET31_Tue, 30 May 2000 07:11:32 -0600777_- Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Interested Parties,
On May 11, 2000, IBM announced that Lawson's enterprise e-business solutions showed extremely high data throughput and transacation performance running with DB2 Universal Database on the copper-based RS/6000 models M80 and S80. The Lawson benchmarks simulated payroll production and accounts payable performance. The test scenarios represented typical payroll and accounts [...]
2509 124 36_Re: RES: DB2 Log records recovery !!17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Tue, 30 May 2000 18:36:22 +0500676_- I am interested too..Please send it to 'vijay.subramanyam@hpsblr.soft.net'.
VIJAY
> -----Original Message----- > From: IBM1 [SMTP:IBM1@UBIL.COM.TR] > Sent: Tuesday, May 30, 2000 6:17 PM > To: DB2-L@RYCI.COM > Subject: Re: RES: DB2 Log records recovery !! > > did I ask for a copy already? > > if not, please send one to aurora.dellanno@sistinf.it > > ciao! > > Aurora Dell'Anno > Systems Engineer > IBM Software Support > e-mail: > ibm1@ubil.com.tr > aurora.dellanno@sistinf.it > _____________________________________________ > No trees were killed in the sending of this message. However - a large > number of electrons were terribly inconvenienced. > > [...]
2634 75 31_Re: ESS/Shark DASD expectations19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 30 May 2000 08:13:38 -0500584_ISO-8859-1 Hi Jim, Ah, I see, a "bird" in the bufferpool is worth two in the Shark's cache! However, that "bird" has got to be in the bufferpool. If it isn't, its gotta be the Shark's cache, else, good old-fashioned I/O (albeit faster, hehe).
Best Regards, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this [...]
2710 65 23_Re: DSNTIAUL - DSNT496I19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 30 May 2000 08:24:23 -0500582_ISO-8859-1 Glenn, If any of the columns in the problem source table were ALTERed on, make sure a REORG has been done since then before trying to DSN1COPY from an image copy of it.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete [...]
2776 60 42_Re: partition on the month of the db2 date20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 30 May 2000 09:33:45 -0400443_us-ascii Vishy
>>> Now I use the post ECB method<<< You mean, you wait on ECB !!
- Did you check your trace has started properly and you don't have qualifier on. - Your IFCA is points to right OP destination during READA.
-----Original Message----- From: Viswanathan N [SMTP:Viswanathan.N@POWAIMAIL.LTITL.COM] Sent: Sunday, May 28, 2000 11:27 PM To: DB2-L@RYCI.COM Subject: Re: partition on the month of the db2 date [...]
2837 102 34_Re: How do I quiesce a tablespace?0_13_imm.it@DSG.DK31_Tue, 30 May 2000 15:37:49 +0100373_iso-8859-1 Hello again
I was told from other side (the DB2 email user group) that I could try to quiesce the table-space as the same user who did the load-operation. That did the trick.
Of course I really should investigate why the load abended and check the RI, but the RI aspect is not that important at the moment as the tables are or can be rebuilt. [...]
2940 61 23_Re: DSNTIAUL - DSNT496I20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 30 May 2000 09:40:49 -0400498_us-ascii Glenn, Are you using any new datatype valid for version 6 but unloading using prior version of DSNTIAUL ?
For example:- ROWID, LOB, LOCATOR etc are new datatypes. But if you use old version of DSNTIAUL , then those datatypes will not be recognized.
In other words, check the version mismatch.
-Venkat
-----Original Message----- From: Glenn Andrews [SMTP:gandrew3@CSC.COM] Sent: Tuesday, May 30, 2000 8:58 AM To: DB2-L@RYCI.COM Subject: DSNTIAUL - DSNT496I [...]
3002 19 30_data manager threshold reached10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 30 May 2000 09:53:39 -0400314_us-ascii Hi all
I've noticed that BP7 (workfile) is hitting Data manager threshold at night during our batch cycle A LOT . I have bp7 set to 15,000 virtual and 2000 hiper. I really can't increase virtual because I'll be hitting the 2gig limit. Should I increase Hiper at night to ease the batch cycle? [...]
3022 48 34_Re: data manager threshold reached20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 30 May 2000 09:53:31 -0400538_us-ascii Hiperpool on work database is only for pages those are re-referenced. But if you are hitting DM threshold, which means that you have unavailable pages hitting 95% mark. The unavailable pages are pages those are not written to DASD yet + pages which are currently read. Increasing hiperpool will not solve your problem because of two reasons 1. Hiperpool cache only clean pages (means already written to DASD) 2. Pages have to be brought to VP to be read (regardless of the fact that they are brought from hiperpool or DASD) [...]
3071 48 34_Re: data manager threshold reached22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 30 May 2000 10:04:05 -0400329_- What are the values for DWQT & VDWQT for BP7? Lowering these thresholds should reduce the number of unavailable pages. Updated pages can not be written to the Hiperpool. I believe once a page has been written its eligible to be placed in the Hiperpool.
Also, examine the SQL that is causing the high DSNDB07 usage. [...]
3120 159 31_Re: ESS/Shark DASD expectations0_27_jim.leask@RS-COMPONENTS.COM31_Tue, 30 May 2000 15:00:50 +0100644_iso-8859-1 Hi Aurora
Is this actually SNAPSHOT, or is it an improved FLASHCOPY?
I suppose what I am really asking is - Has a virtual architecture been deployed on ESS?
Ta, Jim.
-----Original Message----- From: IBM1 [mailto:IBM1@UBIL.COM.TR] Sent: 30 May 2000 13:27 To: DB2-L@RYCI.COM Subject: Re: ESS/Shark DASD expectations
hello rick,
today's information from our ibm sales rep. is that unexpectedly SNAPSHOT will be available next week (1 or 2 months before the date we expected it), therefore customers who have already ordered it will be receiving it within the next 2 weeks. [...]
3280 200 31_Re: ESS/Shark DASD expectations4_IBM116_IBM1@UBIL.COM.TR31_Tue, 30 May 2000 17:10:10 +0300378_iso-8859-9 it is actually SNAPSHOT. we run on Shark too, and have been anxiously waiting for this announcement for MONTHS.
Until last week, the latest news we had from the sales rep. was that we would be releasing the product at the end of june or end of july 2000, the news of next week's date are fresh from the chicken's bum... ooops from the sales dept. of IBM! [...]
3481 96 34_Re: data manager threshold reached10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 30 May 2000 11:02:51 -0400447_us-ascii Venkat
I currently have dwqt and vdwqt set to 80% for the online systems during the day. I think I'm going to have automation lower the thresholds before the batch run and then raise then back again for online. I'm also thinking about adjusting the size of the pool
Thanks
Tom
"Pillay, Venkat (PCA)" on 05/30/2000 09:53:31 AM [...]
3578 20 33_Who controls DB2 authorizations ?0_22_Thomas_Abbott@HESC.COM31_Tue, 30 May 2000 10:56:18 -0400658_us-ascii Currently the internal security of DB2 is controlled by the Data Administration Bureau. We work with our Information Protection Office (Security) to establish RACF groups to which our DBA's then grant necessary authorizations. A recent finding by our auditing group concludes with the recommendation to move the DB2 security to the Information Protection Office. Although we are not completely opposed to this recommendation, we do have concerns. The issues are now being debated. In an effort to bolster my stand that DBA's should control DB2 security, I'd like to poll the Listserv group. Who controls DB2 authorizations in your organization [...]
3599 81 20_Changing bufferpools10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Tue, 30 May 2000 08:10:06 -0700828_us-ascii Did you verify that DSNDB07 is in fact defined as using bufferpool BP7?
Also a sort must be in progress for any pages to be used in the DSNDB07 bufferpool.
---------+---------+---------+---------+---------+---------+---------+------ ---+ SELECT CREATOR, DBNAME, NAME, BPOOL, SEGSIZE, CLOSERULE, LOCKRULE, NTABLES, NACTIVE, STATSTIME FROM SYSIBM.SYSTABLESPACE WHERE DBNAME = 'DSNDB07' ORDER BY CREATOR, DBNAME, NAME; ---------+---------+---------+---------+---------+---------+---------+------ ---+ CREATOR DBNAME NAME BPOOL SEGSIZE CLOSERULE LOCKRULE NTABLES ---------+---------+---------+---------+---------+---------+---------+------ ---+ SPGDB2 DSNDB07 DSN32K01 BP32K 0 N A 0 SPGDB2 DSNDB07 DSN4K01 BP1 0 N A 0 SPGDB2 DSNDB07 DSN4K02 BP1 0 N A 0 SPGDB2 DSNDB07 DSN4K03 BP1 0 N A 0 DSNE610I NUMBER [...]
3681 40 37_Re: Who controls DB2 authorizations ?18_Teegarden, Stephen22_Teegarden@AEGONUSA.COM31_Tue, 30 May 2000 10:12:02 -0500677_- DBA does the DB2 Grants here.
Steve Teegarden, DBA AEGON USA 319-398-8066
> -----Original Message----- > From: Thomas_Abbott@HESC.COM [SMTP:Thomas_Abbott@HESC.COM] > Sent: Tuesday, May 30, 2000 9:56 AM > To: DB2-L@RYCI.COM > Subject: Who controls DB2 authorizations ? > > Currently the internal security of DB2 is controlled by the Data > Administration Bureau. We work with our Information Protection Office > (Security) to establish RACF groups to which our DBA's then grant > necessary > authorizations. A recent finding by our auditing group concludes with the > recommendation to move the DB2 security to the Information Protection > Office. Although [...]
3722 67 37_AW: Who controls DB2 authorizations ?12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 30 May 2000 17:20:10 +0200797_iso-8859-1 Thomas,
The access to the DB subsystems in our shop are RACF-controlled.
Access to the objects in a specific DB2 subsystem (e.g. tables, views and so on) is controlled by the DB2 subsystem himself (via GRANT/REVOKE-DDL).
HTH.
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...]
3790 75 37_Re: Who controls DB2 authorizations ?0_22_BILL_GALLAGHER@PHL.COM31_Tue, 30 May 2000 11:20:58 -0400355_us-ascii We're currently in the process of migrating the responsibility of administering DB2 security from the DBA's to our Information Security team. We're doing this by converting all of our DB2 security administration to from native DB2 to RACF administration, one application at a time. (Unfortunately, it's going much slower that we had hoped). [...]
3866 22 21_DSNCLI Module missing9_SrinivasG17_SRINIVASG@INF.COM31_Tue, 30 May 2000 20:49:55 +0530308_- Hi All,
I had installed DB2 V6.1 on OS/390 a few days back. But the DSNCLI module is missing. I had also installed DB2 V5.1 three times and do not recollect doing anything special for receiving the DSNCLI module . I did a CBPDO install for V6.1 where as a server pack install for the DB2 V5.1. [...]
3889 56 37_Re: Who controls DB2 authorizations ?12_John Cameron26_JCameron@MSI-INSURANCE.COM31_Tue, 30 May 2000 10:18:09 -0500810_us-ascii DBA grants to RACF group. RACF administrator adds/deletes users from individual groups.
John Cameron jcameron@msi-insurance.com
Thomas_Abbott @HESC.COM To: DB2-L@RYCI.COM Sent by: DB2 cc: Data Base Subject: Who controls DB2 authorizations ? Discussion List
05/30/00 09:56 AM Please respond to DB2 Data Base Discussion List
Currently the internal security of DB2 is controlled by the Data Administration Bureau. We work with our Information Protection Office (Security) to establish RACF groups to which our DBA's then grant necessary authorizations. A recent finding by our auditing group concludes with the recommendation to move the DB2 security to the Information Protection Office. [...]
3946 42 37_Re: Who controls DB2 authorizations ?10_Greg Retus16_gretus@PHEAA.ORG31_Tue, 30 May 2000 11:23:15 -0400747_us-ascii In our shop, the security staff does this function. We are fortunate enough to have DB2 staff that are also in favor of this.
Thomas_Abbott@HESC.COM on 05/30/2000 10:56:18 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Greg Retus/PHEAA)
Subject: Who controls DB2 authorizations ?
Currently the internal security of DB2 is controlled by the Data Administration Bureau. We work with our Information Protection Office (Security) to establish RACF groups to which our DBA's then grant necessary authorizations. A recent finding by our auditing group concludes with the recommendation to move the DB2 security to [...]
3989 12 22_SoftBase DataBase Rely13_peggy donovan22_peggy.donovan@SSMB.COM31_Tue, 30 May 2000 10:16:13 -0500411_- Does anyone on this list use this product for DB2? I would appreciate any comments and information you can share about implementation, functionality, reliability, etc.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4002 50 37_Re: Who controls DB2 authorizations ?12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Tue, 30 May 2000 10:33:40 -0500352_- We have two levels of DBA's here. The application DBA's assign authorities in the test environments, the technical support DBA's (SYSADM) assign authorities in production and test (when needed). All authorities are granted to secondary authids. The seconday authids are maintained by Info Protection Services with the aid of Tech Support DBA's. [...]
4053 88 37_Re: Who controls DB2 authorizations ?0_18_mebert@AMADEUS.NET31_Tue, 30 May 2000 17:31:40 +01001689_us-ascii It's the same in our shop.
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
From: John Cameron on 30/05/2000 15:18 GMT
Please respond to DB2 Data Base Discussion List
|---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |To: | |---------> >---------------------------------------------------------------------------> |DB2-L@RYCI.COM | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> |cc: | |---------> >---------------------------------------------------------------------------> | (bcc: Michael Ebert/MUC/AMADEUS) | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |Subject: | |---------> >---------------------------------------------------------------------------> |Re: Who controls DB2 [...]
4142 62 25_Re: DSNCLI Module missing0_19_Tim.Lowe@STPAUL.COM31_Tue, 30 May 2000 10:33:30 -0500816_us-ascii DSNCLI is the DB2 attach for CICS, and it was moved to CICS a few years ago (was it CICS 4.1 ?). Check your CICS libraries.
SrinivasG on 05/30/2000 10:19:55 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: DSNCLI Module missing
Hi All,
I had installed DB2 V6.1 on OS/390 a few days back. But the DSNCLI module is missing. I had also installed DB2 V5.1 three times and do not recollect doing anything special for receiving the DSNCLI module . I did a CBPDO install for V6.1 where as [...]
4205 91 37_Re: Who controls DB2 authorizations ?14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Tue, 30 May 2000 11:46:16 -0400471_us-ascii First - an answer - At my current location the DBA staff performs the security function through DB2 grants and revokes. At my last employer the RACF Security group administered access to DB2 using Platinum's (CA) RC-Secure.
Now, A couple questions : Bill (Gallagher) - 1) Are you going to remove all of the DB2 authorizations from the catalog once the transition is complete ? 2) Have you had ANY problems using RACF as your DB2 security interface ? [...]
4297 23 25_Re: DSNCLI Module missing9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM31_Tue, 30 May 2000 17:05:33 +0100382_us-ascii I thought that IBM said it was no longer going to ship this module with DB2 from V7 onwards. There was an APAR for CICS/TS 1.3 because it was not part of the original product shipment, but it was added later. (I don't have the APAR number to hand)
The DSNCLI shipped with DB2 was the pre CICS V4 version, and it should no longer have been used with CICS V4 on. [...]
4321 31 16_OMEGAMON FOR DB20_49_PRAKASH_UPRETI/ITS_-_Tata_Steel@LOT.TATASTEEL.COM29_Tue, 30 May 2000 10:18:04 GMT541_us-ascii Dear list members can anyone throw some light on taking SMF dump for type 100 and 102(for statistics report) and then sorting that dump. Why at all the sort is required?? what should be the values for SORT FIELDS and INCLUDE COND for Omegamon's extractor program to read that dump properly to make a load statement ?. For accounting report(type 101 for taking SMF dump) the value we are using for SORT FIELDS and INCLUDE COND are as follows: SORT FIELDS=(11,4,CH,A,7,4,CH,A) INCLUDE COND=(6,1,CH,EQ,X'64', OR ,6,1,CH,EQ,X'65', [...]
4353 49 23_Re: Datajoiner Question0_23_sjtoeniskoetter@AEP.COM31_Tue, 30 May 2000 12:04:51 -0400381_us-ascii This is a server mapping statement from Datajoiner on AIX to DB2 UDB V6.1 on AIX.
create server mapping from xxxx to node yyyy database zzzz type db2/6000 version 6.1 protocol "db2ra" authid "userid" password "password";
Where xxxx is my arbitrary server mapping name, yyyy is the DB2 V6.1 node I have cataloged, and zzzz is the DB2 V6.1 database name. [...]
4403 41 54_Global temporary table in a subselect used with update11_Arne Nilsen18_Arne.Nilsen@SDS.NO31_Tue, 30 May 2000 18:08:00 +0200401_- Hi;
I think you all need a break from the utility-discussion.
The following INSERT-sql inserts 6 rows in a glob.temp.table in the initialization of the program.I need some good hints why the SELECT-sql gives me the expected answer (6 rows), but the UPDATE-sql gives me SQLCODE 100 and no updated rows:
INSERT INTO TEMPTAB1 SELECT DISTINCT COL1 FROM TAB1 WHERE STATUS = '0' [...]
4445 58 58_Re: Global temporary table in a subselect used with update20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 30 May 2000 12:14:15 -0400587_us-ascii Was there any commit in between SELECT and UPDATE ?
-----Original Message----- From: Arne Nilsen [SMTP:Arne.Nilsen@SDS.NO] Sent: Tuesday, May 30, 2000 12:08 PM To: DB2-L@RYCI.COM Subject: Global temporary table in a subselect used with update
Hi;
I think you all need a break from the utility-discussion.
The following INSERT-sql inserts 6 rows in a glob.temp.table in the initialization of the program.I need some good hints why the SELECT-sql gives me the expected answer (6 rows), but the UPDATE-sql gives me SQLCODE 100 and no updated rows: [...]
4504 91 58_Re: Global temporary table in a subselect used with update0_19_Tim.Lowe@STPAUL.COM31_Tue, 30 May 2000 11:20:19 -0500308_us-ascii Hello Arne, This same problem was just discussed on this list a few weeks ago. How current are you on maintenance? There are several PTFs for global temporary tables and subselects. APAR PQ31008 / DB2 V5 PTF UQ36283 may be a match to your problem. It closed 10/19/99. Do you have this applied? [...]
4596 188 37_Re: Who controls DB2 authorizations ?0_22_BILL_GALLAGHER@PHL.COM31_Tue, 30 May 2000 12:48:37 -0400620_us-ascii Bill,
Here's some answers to your questions/rumors from our experiences here at PHL:
Ideally, we would like to remove all the authorizations from the DB2 catalog once the conversion is complete, just to make sure our eggs are kept only in one basket to reduce/eliminate confusion (as unlikely as that seems). However, we cannot do that just yet because we are finding that the RACF interface is not entirely stable and does tend to abend on occasion (without warning and without any error or informational messages!.) So what we've done is to implement a way of synchronizing the DB2 catalog [...]
4785 90 31_Re: ESS/Shark DASD expectations11_Uros Majcen18_uros.majcen@MRI.SI31_Tue, 30 May 2000 19:06:18 +0200478_ISO-8859-1 -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of DAVIS, RICK (SBCSI) Sent: Tuesday, May 30, 2000 3:14 PM To: DB2-L@RYCI.COM Subject: Re: ESS/Shark DASD expectations
Hi Jim, Ah, I see, a "bird" in the bufferpool is worth two in the Shark's cache! However, that "bird" has got to be in the bufferpool. If it isn't, its gotta be the Shark's cache, else, good old-fashioned I/O (albeit faster, hehe). [...]
4876 18 11_Re: DSNWDMP9_Colin Fay13_cfay2@CSC.COM31_Tue, 30 May 2000 14:29:21 -0400487_us-ascii Hi,
Can someone provide me with JCL and control statements to run DSNWDMP . I dont have the DB2 diagnositcs Guide which describes it and it isn't available online. This utility gives current storage utilization.
Thank You.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4895 30 13_-194 SQL code15_Zander, Barb J.19_bzander@STATE.ND.US31_Tue, 30 May 2000 13:30:55 -0500357_iso-8859-1 I am trying to install SQL Procedures on DB2 UDB for OS/390 V6. There are 3 IVP jobs that need to be run(DSNTEJ63, DSNTEJ64, and DSNTEJ65). I get DSNTEJ63 and DSNTEJ64 to run just fine, but DSNTEJ65 gets a -194 sqlcode. Any ideas as to what this is? I cannot find it in the manuals and as of yet have not received an answer from IBM either. [...]
4926 214 37_Re: Who controls DB2 authorizations ?10_Greg Retus16_gretus@PHEAA.ORG31_Tue, 30 May 2000 14:34:12 -0400465_us-ascii The apar you identify is only half the fix(the cics half)...the other half for db2 is PQ28029. In addition, CICS APAR PQ36624 can also cause the exit to abend. IBM has not yet produced a final PTF version of this fix. We also found DB2 APAR PQ38512. This describes a problem where users of the DB2/RACF exit can run out of storage in the DB2 (DBM1) address space. We think this bit us once or twice. This is very new so there is no published fix yet. [...]
5141 25 31_Informatica vs Visual Warehouse12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 30 May 2000 11:48:06 -0700377_us-ascii We're picking a new data warehouse tool for SAP reporting as well as use with other, existing data (IMS, DB2, SQL-Server). We're committed to AIX/UDB as the platform. I am aware that Visual Warehouse is morphing in UDB V7 + other products. Any major comments, pro or con, from folks using either of these? If you really want to rant, you can contact me off-line. [...]
5167 70 31_Re: ESS/Shark DASD expectations12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 30 May 2000 21:33:22 +0200535_x-user-defined Hi Jim, We have HDS7700E - 4GB cache, ALL of it is NVS. Isaac Yassin
Jim Lewandowski wrote: > > Time to ramble on about ESS, DASD in general. Hit the ol' delete key if > you don't wish to read. > > Shark is "better" than other DASD vendors BEST/latest products in only 1 > respect; MVS IOS code has been rewritten to take advantage of parallel > UCBs/volumes (2 I/Os for the same MVS volume are NO longer queued within > MVS, that queueing, if any, is now moved to the controller). The only > thing you need [...]
5238 24 15_Utility Pricing13_Toppins, Mike19_MToppins@UNIPAC.COM31_Tue, 30 May 2000 12:47:23 -0600525_iso-8859-1 Couldn't help it ...
From the IBM documents ...
IBM defines core utilities as those that you must have to maintain your data. These include utilities such as LOAD, COPY, REORG, RUNSTATS and RECOVER. The best-of-breed utilities available in DB2 Universal Database for OS/390 ensure the highest level of data integrity, performance, availability, function and value. Since the core utilities are included at no extra charge with your base DB2 license, IBM offers the most cost-effective solution. [...]
5263 454 11_Re: DSNWDMP22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 30 May 2000 14:49:59 -0400695_iso-8859-1 4.1.2 Printing Dumps
DB2 supports IPCS under both MVS/ESA and MVS/XA. It is recommended that IPCS be used for versatility.
The DB2 dump formatter routine, DSNWDPRD, is invoked by IPCS with:
DB2 VERBEXIT DSNWDMP
Figure 40 contains sample JCL for printing and formatting a dump through IPCS. These JCL samples illustrate the appropriate parameters for formatting SVC, stand-alone, and dynamic dumps. The DSNWDMP control statement shown in the examples causes the DB2 dump formatter (DSNWDPRD) to be invoked and defines the DB2 control block structures to be formatted. For more information about the DSNWDMP control statement, see "Formatting Dumps" in [...]
5718 22 22_ETI vs Informix/Ardent0_19_RTurpen@WOODMEN.COM31_Tue, 30 May 2000 13:57:20 -0500315_us-ascii We are setting up a data warehouse with DB2 for OS/390 as the database platform. Does anyone have experience or comments regarding ETI Extract versus Informix/Ardent DataStage for ETL software? Is there anything else we should look at that will run well when the source and target are both on OS/390? [...]
5741 92 34_Re: data manager threshold reached12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 30 May 2000 21:42:24 +0200555_x-user-defined Hi, Try VDWQT(40)DWQT(70) for the night and monitor it to see how it goes. Isaac Yassin
Tom Taylor wrote: > > Venkat > > I currently have dwqt and vdwqt set to 80% for the online systems during the > day. I think I'm going to have automation lower the thresholds before the batch > run and then raise then back again for online. I'm also thinking about > adjusting the size of the pool > > Thanks > > Tom > > "Pillay, Venkat (PCA)" on 05/30/2000 09:53:31 AM > > Please respond to DB2 Data Base Discussion [...]
5834 19 25_Re: DSNCLI Module missing0_23_pjackson@SUMMITBANK.COM31_Tue, 30 May 2000 14:29:03 +0000434_us-ascii Hi,
I agree.
I checked the Version 5 libraries and DSNCLI is present.
It is not in the Version 6 library, however it is present in the CICS/TS load library (1.3).
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5854 30 28_Applying DB2 ESO maintenance15_Jeffery A Price17_jprice@IPALCO.COM31_Tue, 30 May 2000 15:04:44 -0500565_us-ascii Hello,
I hope I can simplify this process for you, and maybe someone else can simplify it even more. I start by making a backup of all SMPE, target zone, and dlib zone. Next, I receive, apply check the PTFs (bypassing SYSTEMHOLDs of ACTION, DOC, DEP). Then, I look to see how many PTFs will go on if I can resolve HOLDERRORs (by APPLY CHECKING with BYPASS HOLDERROR option), as opposed to how many will go on without resolving HOLDERRORs. If I can install 80%-90% of PTFs without having to delve into a long research or waiting process, then I [...]
5885 79 22_Hiperpool in DSNDB07 ?10_Max Scarpa16_mocion@INWIND.IT31_Tue, 30 May 2000 21:54:23 +0200336_iso-8859-1 Hi all
We are starting to tune our bufferpools with new VBPs and hiperpools. But I've a doubt.
I read in an article that it isn't useful to create an hiperpool with the bufferpool containing Dsndb07
workfiles 'coz the pages are marked 'in-use' so they are not migrated to hiperpool. But in a recent [...]
5965 61 32_Re: Information Engineering (IE)12_Davis, Diane22_DDavis@COR.STATE.PA.US31_Tue, 30 May 2000 16:15:18 -0400385_iso-8859-1 Rick, I didn't see any answers to this, and I don't know how much use this message would be to the list, but I tried getting James Martin's book _Information Engineering_, which costs $100 and is a skimpy little pamphlet that is the first of a trilogy. IE seems to have come out of CASE theory, as far as this embarrassing (in front of my boss) dinky publication says. [...]
6027 18 26_Re: Hiperpool in DSNDB07 ?0_31_truman.g.brown@BELLATLANTIC.COM31_Tue, 30 May 2000 16:21:08 -0400352_us-ascii We are currently using hiperpools for DSNDB07 dedicated VBPs in two different subsystems. Both of them have a hiperpool read-to- write ratio of over 21%, which is indeed effective for these particular subsystems where we're maxing out storage for the DBM1 address space with VBPs, SORTPOOL, RID pool, etc..
Your milage may vary... [...]
6046 152 26_Re: Hiperpool in DSNDB07 ?14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 30 May 2000 16:44:14 -0400594_iso-8859-1 Both true. When you have large results set, and once dirty pages have been externalized and read back in, hiperpools can benefit DSNDB07. HOWEVER, that is the exception not the rule. Best is to set up DSNDB07 according to all guidelines, 90-95% sequential to start, high VDWQT and DWQT (say between 60% and 90%), and perhaps a hiperpool from same size to double. Then measure. If you can get 10% of the pages read back in from the hiperpool, then you probably have one of those situations were hiperpools work behind DSNDB07. Warehouses, large result sets and reread large temp [...]
6199 62 26_Re: Hiperpool in DSNDB07 ?15_Toine Michielse18_vndobtm@US.IBM.COM31_Tue, 30 May 2000 23:46:08 +0100508_us-ascii Hello Max,
Whenever pages are written to DASD because one of the thresholds ((V)DWQT) is tripped, those pages become eligable to move to the hiperpool. Subsequent read (merge of the workfiles) would then get the page from the hiperpool. This can be useful in situation where sorts can not complete in virtual bufferpool only and virtual storage is not 'unlimited'. Have seen some good results at sites that implemented hiperpool for the bufferpool containing the sort/workfile database. [...]
6262 71 108_IBM's Universal Database server presentations at the June 8th meeting of the Los Angeles Area DB2 User Group16_Palmer, Ronald B29_Ronald.Palmer@WEST.BOEING.COM31_Tue, 30 May 2000 15:42:27 -0700588_- The topics to be presented at the June 8th meeting of the Los Angeles Area DB2 User Group (LAADB2UG) will be centered on IBM's Universal Database server on all available platforms. If you are anywhere near the Southern California area, plan on dropping in. Check the "June Meeting Information" link on the web site http://www.laadb2ug.org/ for more details. If you have questions, send a note directly to me at RonPalmer@laadb2ug.org (I sometimes get a little behind in viewing the newsgroup messages) or you can contact the LAADB2UG president, Tom Glass, at TomGlass@laadb2ug.org [...]
6334 35 24_SYSLGRNX cleanup on DROP28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 30 May 2000 16:55:21 PDT468_- For those of you that care about the history, I found the original APAR on this on V2R2 from 4/87, closed SUG, PL10102. If rollback was a concern, it doesn't make sense to me that SYSCOPY is handled one way and SYSLGRNG (SYSLGRNX) another. I'll keep looking at this.
PL10102:
ERROR DESCRIPTION: AFTER DROPPING A TABLESPACE, RELATED RECORDS IN SYSLGRNG ARE NOT DELETED. SINCE THERE IS NO WAY TO ACCESS THESE RECORDS, THERE IS NO NEED TO KEEP THEM. [...]
6370 122 33_Re: How do I quiesce a tablespace0_13_imm.it@DSG.DK31_Wed, 31 May 2000 07:47:12 +0100492_iso-8859-1 Hello list.
I am sorry if you get this message twice. I am resending it because the L-Soft list server told me that the mail was rejected because it has already been sent before. However I have not received an acknowledgement of the first message.
Hello again
I was told from other side (the DB2 email user group) that I could try to quiesce the table-space as the same user who did the load-operation. That did the trick. [...]
6493 31 16_OMEGAMON FOR DB20_49_PRAKASH_UPRETI/ITS_-_Tata_Steel@LOT.TATASTEEL.COM29_Wed, 31 May 2000 09:13:23 GMT541_us-ascii Dear list members can anyone throw some light on taking SMF dump for type 100 and 102(for statistics report) and then sorting that dump. Why at all the sort is required?? what should be the values for SORT FIELDS and INCLUDE COND for Omegamon's extractor program to read that dump properly to make a load statement ?. For accounting report(type 101 for taking SMF dump) the value we are using for SORT FIELDS and INCLUDE COND are as follows: SORT FIELDS=(11,4,CH,A,7,4,CH,A) INCLUDE COND=(6,1,CH,EQ,X'64', OR ,6,1,CH,EQ,X'65', [...]
6525 133 26_Re: Hiperpool in DSNDB07 ?13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Wed, 31 May 2000 11:23:00 +0100543_iso-8859-1 Folks over the years I have always found you can never tell how any particular system will perform. You have to take each threshold and work it out for each system. Yes there are certain 'recommended' type values for (V)DWQT etc. but these are only a reasonable starting point. As far as using a hiperpool with DSNDB07 I have found benefit in allocating a small (500 or 1000 pages in my case) to complement the VP. In one of our two main DB2 subsystems, both run on CMOS processors, I have a VP of 8500 for DSNDB07 and a small [...]
6659 24 50_Exporting RMM Control Dataset to DB2 for reporting15_Jeffery A Price17_jprice@IPALCO.COM31_Wed, 31 May 2000 07:08:58 -0500572_us-ascii Hello all,
Just a shot in the dark, but I was wondering if anyone uses any 3rd party or in-house-developed software to load the RMM Control Dataset into DB2 table(s) for reporting purposes.
Thanks In Advance,
Jeffery A. Price Engineer Indianapolis Power and Light Co. (317) 261-5010 jprice@ipalco.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6684 49 16_PQ30684 Problems13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Wed, 31 May 2000 08:36:37 -0400288_US-ASCII Hi all,
We are in the process of migrating from DB2 UDB for OS/390 V5 to DB2 UDB for OS/390 V6 . We are trying to apply maintenance for fallback and coexistence support. We have run into a problem trying to apply APAR PQ30684 in PTF UQ40803 to DB2 UDB for OS/390 V5. [...]
6734 39 24_Extracting data for test18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Wed, 31 May 2000 09:05:52 -0400556_iso-8859-1 Hello List, We are an OS/390 DB2 V4 (V5 in a month if all goes well) shop. I am looking for a product to be used by applications programming areas to extract a subset of data from a production DB2 subsystem to be loaded in their test DB2 subsystem. They need to be able extract a couple of policies (were are an insurance co) with all related data and keep RI intact. "Move for DB2" from Princeton has been recommended. It appears CA's "Data Navigator" (formerly Platinum's) is an option. I was hoping to review three before deciding but I [...]
6774 74 28_Re: Extracting data for test12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 31 May 2000 06:22:47 PDT522_- Peter,
I have used Navigator in the past and there are some 'gotcha's' to watch for. If you have SYSTEM defined RI, the tool is EASY to set up and run. If you are using APPLICaTION RI, then you will need to define the relationships FIRST, then run the tool. Performance was an issue, depending on the quantity of data and the number of tables in the RI. It is a tool where READING the manual is a GOOD idea in order to get good performance. It is a little cumbersome to set up, but once done, apps can rerun [...]
6849 63 28_Re: Extracting data for test13_Thomas, Janis19_Janis.Thomas@CA.COM31_Wed, 31 May 2000 09:26:36 -0400392_iso-8859-1 I wanted to mention RC/Extract, which is a new product from Computer Associates that will eventually replace Data Navigator. RC/Extract is designed to easily move small & large amounts of RI intact data. The product is also integrated with RC/Migrator to move objects and related RI data within one execution. If anyone would like more information, please contact me offline. [...]
6913 58 28_Re: Extracting data for test12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Wed, 31 May 2000 08:23:38 -0500267_iso-8859-1 We use QMF for Windows for all of our adhoc query needs and to export data. The end-user can export it within QMF for Windows or use the access or excel plug ins to download the data. We connect to DB2/390 v5 now but prior to that we connected to v4. [...]
6972 61 28_Re: Extracting data for test12_Rompot, Kurt26_kurt.rompot@INGRAMBOOK.COM31_Wed, 31 May 2000 08:28:18 -0500669_iso-8859-1 Pete,
You might add File-Aid/RDX from Compuware. I don't have any experience with it but it appears similar in functionality to the others on your list.
Kurt Rompot Ingram Book Company
-----Original Message----- From: Bourgoine, Peter A [mailto:Peter.A.Bourgoine@JPFINANCIAL.COM] Sent: Wednesday, May 31, 2000 8:06 AM To: DB2-L@RYCI.COM Subject: Extracting data for test
Hello List, We are an OS/390 DB2 V4 (V5 in a month if all goes well) shop. I am looking for a product to be used by applications programming areas to extract a subset of data from a production DB2 subsystem to be loaded in their test DB2 [...]
7034 46 28_Re: Extracting data for test13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Wed, 31 May 2000 08:30:06 -0500529_us-ascii We use File-Aid RDX from Compuware. The programmers like it and they can even define RI that is not in the database, but may be in the applications.
"Bourgoine, Peter A" wrote:
> Hello List, > We are an OS/390 DB2 V4 (V5 in a month if all goes well) shop. > I am looking for a product to be used by applications programming areas to > extract a subset of data from a production DB2 subsystem to be loaded in > their test DB2 subsystem. They need to be able extract a couple of policies > (were are an [...]
7081 15 21_compare/update schema13_Bruce Jackson25_bjackson@NETPLEXGROUP.COM31_Wed, 31 May 2000 08:12:31 -0500433_- Is there a utility available to compare two database structures (tables, columns, views, indexes, etc.), and display the differences? Or even better, to synch the structures automatically? We have a test system that has changes made fairly frequently, but we have to retain the data on the production system when the changes are rolled out. I can find a lot of ways to move data, but nothing to compare and/or update schemas. [...]
7097 58 28_Re: Extracting data for test16_Peddycoart, Judy22_peddycoa@UILLINOIS.EDU31_Wed, 31 May 2000 08:43:52 -0500500_iso-8859-1 At my previous position, we used Princeton's Move for DB2; and it was an excellent tool for moving subsets of data. It provided a great deal of flexibility in terms of selecting the data, as well as allowing you to "massage" the data before you loaded it. We used the ability to massage the data extensively for some of our Y2K testing. It will use system RI if it was defined to DB2, or allow you to establish your own. As a vendor, we found Princeton to be responsive to our needs. [...]
7156 73 20_Re: ASCII In DB2/39016_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Wed, 31 May 2000 09:57:42 -0400326_iso-8859-1 Hey Leslie... I think I need to change a tablespace/table to allow the insertion of ASCII data. It looks like this product is inserting it that way, but when we try to display, we don't get anything. So, I'm hoping that if I alter the tablespace/table to a CCSID of ASCII, then we'll see the correct results.. [...]
7230 19 21_compare/update schema17_Andreas Constanti24_andreas.constanti@AGI.CH31_Wed, 31 May 2000 16:00:31 +0100535_us-ascii Bruce,
We use RC/Compare (an add-on to RC/Migrator) from Platinum - ahh, excuse me CA. It does what you want. It's powerful, a little awkward to use and compares with many objects in large catalogs can take a long time (especially when views are involved).
Regards, Andy
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
7250 82 22_DB2 Hang, Or is it NT?14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 31 May 2000 10:18:00 -0400524_iso-8859-1 We have been having some problems with DB2 UDB EE v6.1 Win NT (FP3F) on NT Server 4.0 (SP6) locking up during peak periods. We have done extensive tuning and do not see any DB2 thresholds being hit or for that fact, any error messages in the db2diag.log or in the NT log prior to the lockup. By lockup, I mean DB2 stops responding and a db2 list applications command hangs. I am aware of the max threads setting in AIX that has to be raised from the default of 40 when running DB2 UDB EEE on AIX. I remember [...]
7333 105 20_Re: ASCII In DB2/39014_Maxfield, John21_John_Maxfield@BMC.COM31_Wed, 31 May 2000 09:28:39 -0500386_ISO-8859-1 Michael,
If I understand you correctly, you application is inserting ASCII data into DB2 tables on DB2/390.
You can change the encoding scheme of your target (i.e., tablespace) to ASCII, but you still may not get the results you are expecting. If the source (i.e., inserted data) is ASCII, DB2 needs to know how to handle the conversion during the insert. [...]
7439 28 29_Platinum utilities vs. IBM V616_Alison Pelletier26_alison_pelletier@YAHOO.COM31_Wed, 31 May 2000 07:22:08 -0700477_us-ascii Hello Everyone.
Do any of you have results/conclusions on benchmarks or experiences/opinions on Platinum reorg., load, unload, image copy versus IBM V6 OS/390 reorg., load, unload, image copy as far as elapsed time is concerned?
TIA,
Alison Pelletier, DBA Discover Financial Services
__________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ [...]
7468 66 28_Re: Extracting data for test12_Mckay, Wayne24_Wayne.Mckay@ATCOITEK.COM31_Wed, 31 May 2000 08:38:22 -0600493_- We use Move For DB2 from Princeton Softech. It follows the DB2 RI paths or allows you to define application RI if needed. The developers use it to extract single or a small number of accounts. DBA also uses it to create subset test databases in which case millions of rows all RI related need to be extracted. The Move tool has some unique performance features and algorithms which make this possible. It maintains internal key lists and then makes optimum use of an access to a table. [...]
7535 38 25_Re: compare/update schema19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Wed, 31 May 2000 10:34:26 EDT316_us-ascii Hi,
We have been using BMC Change Manager for the last four years and are very happy with it. It makes synchronization of databases very easy and you can also generate reports which tell you the differences.
Platinum tools can also do the same thing. We evaluated both and went with BMC. [...]
7574 55 26_Re: DB2 Hang, Or is it NT?10_Mike Paris14_MPARIS@TUC.COM31_Wed, 31 May 2000 09:46:14 -0500511_US-ASCII Phillip,
We had a similar problem in AIX during peak transaction periods that was caused by a bug in the page cleaners segment of the engine. We used the ps aux command to list machine resources by consumption and found the page cleaners at the top of the list, I do not know if there is a similar NT command. Only way out of the situation was to crash DB2 then restart, until we received a patch. We are currently waiting for a fixpack that relates to this problem before moving to DB2V6. [...]
7630 48 28_Re: Extracting data for test9_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 31 May 2000 09:15:23 -0600551_us-ascii RC/Extract - Computer Associates Move/Access/Compare - Princeton Softech File-Aid RDX - Compuware
"Bourgoine, Peter A" wrote: > > Hello List, > We are an OS/390 DB2 V4 (V5 in a month if all goes well) shop. > I am looking for a product to be used by applications programming areas to > extract a subset of data from a production DB2 subsystem to be loaded in > their test DB2 subsystem. They need to be able extract a couple of policies > (were are an insurance co) with all related data and keep RI intact. "Move > for DB2" from [...]
7679 43 26_Re: DB2 Hang, Or is it NT?0_22_rmadan@CYVEILLANCE.COM31_Wed, 31 May 2000 11:20:16 -0400494_iso-8859-1 Hi Phillip,
We have had this problem with NT in 5.2. Do you have any large files...for example what is the size of your backup file...are you doing db backups or tablespace backups.........what is your setting for DB2_NTNOCACHE......what is your setting for page cleaners?
regards, rakesh
-----Original Message----- From: Philip Gunning [mailto:pgunning@BOSCOVS.COM] Sent: Wednesday, May 31, 2000 10:18 AM To: DB2-L@RYCI.COM Subject: DB2 Hang, Or is it NT? [...]
7723 156 56_Re: DB2 Connect Licensing - 'Concurrent User' definition12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 31 May 2000 08:20:51 -0700491_us-ascii Yes, there definitely doesn't seem to be a consistent approach from IBM reps on this issue. My client asked their IBM rep about how many licenses they'd need with 300 web users but only 5-10 actually connected to DB2 at any given time. And they were told 300 licenses since any user that could possibly have a web browser open (or excell or access or whatever) is technically a "concurrent" user. Obviously there's quite a difference in price between 5-10 users and 300 users. [...]
7880 669 32_Repost: IDUG A Big Hit in Dallas13_Morrill, John12_JohnM@VP.NET31_Wed, 31 May 2000 09:26:09 -0600603_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Interested Parties,
From my perspective, the 12th Annual IDUG North American conference May 14-19 in Dallas was really great. Of course, anytime DB2 fanatics gather in one place, I am overwhelmed with joy. :-) [...]
8550 142 75_Repost: Useful Web Site: "IBM DB2 Universal Database for OS/390 U tilities"13_Morrill, John12_JohnM@VP.NET31_Wed, 31 May 2000 09:26:10 -0600717_- Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Interested Parties,
In case you haven't been there for awhile (if ever), I thought some of you might be interested in the following Web site summarizing the DB2 UDB for OS/390 utilities as of Version 6. Check out "IBM DB2 Universal Database for OS/390 Utilities" at http://www-4.ibm.com/software/data/db2/os390/v6facts/db2utils.html [...]
8693 19 18_bind-package-error15_Raghu Tarigonda29_rtarigo@NOTES.MNET.USWEST.COM31_Wed, 31 May 2000 09:37:50 -0600428_us-ascii Hai
I am getting a sql error -805 (80N) when binding a package.Share your expertise if any body has got the same error.I would appreciate your help.
Thanks. Raghu.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
8713 18 36_DB2 Recovery Tool Sample ISPF Panels20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 31 May 2000 12:03:43 EDT395_US-ASCII Hello (Joe - The Joe from Australia) who send me a email Off-list yesterday requesting the sample ISPF Panels of the DB2 Recovery Tool. I am not sure if I emailed the ISPF Panels to you and I lost your email so I do not have your email address. So if you did not get the panels, drop me a note so I can send them to your email address Off-list as an attachment. Thanks, Ed. Benoit [...]
8732 33 32_User Defined Functions/RRS woes.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Wed, 31 May 2000 09:20:32 -0700330_iso-8859-1 Well I'm trying to get the DB2v6 UD Functions to work. Its been a long road. I've got the WLM setup and just installed the RRS (using the steps in the RedBook Getting Started with DB2 Stored Procedures). Now when WLM tries to start the WLM addresspace (DSNTWLM) and attach to the RRS I get the following messages. [...]
8766 38 22_Re: bind-package-error11_Suresh Sane21_data_arch@HOTMAIL.COM29_Wed, 31 May 2000 11:30:01 CDT732_- Are you using the COPY sub-option (the package you are copying from does not exist?)
Suresh
>From: Raghu Tarigonda >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: bind-package-error >Date: Wed, 31 May 2000 09:37:50 -0600 > >Hai > > I am getting a sql error -805 (80N) when binding a package.Share your >expertise if any body has got the >same error.I would appreciate your help. > >Thanks. >Raghu. > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can >be reached at DB2-L-REQUEST@RYCI.COM. [...]
8805 83 32_Re: Information Engineering (IE)12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 31 May 2000 19:11:47 +0200553_x-user-defined Hi, As learnt from very old similar experience we use, for years now, the method of checking the books we want at a university library and then decide.
Isaac Yassin
"Davis, Diane" wrote: > > Rick, > I didn't see any answers to this, and I don't know how much use this message > would be to the list, but I tried getting James Martin's book _Information > Engineering_, which costs $100 and is a skimpy little pamphlet that is the > first of a trilogy. IE seems to have come out of CASE theory, as far as this > [...]
8889 57 22_Re: bind-package-error19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Wed, 31 May 2000 12:35:56 EDT471_us-ascii Raghu,
It is also possible that you recently moved to a new version of DB2 and your JCL is still pointing to the old DB2 dataset (check - Joblib/Steplib/Library).
Hope this helps.
Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: "Suresh Sane" , on 05/31/2000 12:30 PM: Are you using the COPY sub-option (the package you are copying from does not exist?) [...]
8947 159 26_Re: Hiperpool in DSNDB07 ?12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 31 May 2000 19:22:32 +0200548_x-user-defined Hi, You need to take into account your whole memory usage and type of machine. Old BiPolar - you are limited in real memory and the rest is expanded storage (means you can use it for Hiper). CMOS machines - you are limited by OS/390 to 2GB so any real memory above 2GB per LPAR should be configured as expanded. Your DB2 subsystem can't take more then 1.6GB for storage, so if you are near the limit and need memory - Hiper is the solution (in expanded storage). Next question - what happens with your other tasks on the system [...]
9107 62 22_Re: bind-package-error0_19_Tim.Lowe@STPAUL.COM31_Wed, 31 May 2000 11:46:32 -0500714_us-ascii Hello Raghu, Can you supply the entire error message that you get when you bind the package?
Thanks, Tim
Raghu Tarigonda on 05/31/2000 10:37:50 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: bind-package-error
Hai
I am getting a sql error -805 (80N) when binding a package.Share your expertise if any body has got the same error.I would appreciate your help. [...]
9170 73 22_Re: bind-package-error17_Nagaraj Pudukotai26_Nagaraj.Pudukotai@UBSW.COM31_Wed, 31 May 2000 17:41:13 +0100787_- Did you get this on bind?. I thought it can happen only at run time.
______________________________ Reply Separator _________________________________ Subject: Re: bind-package-error Author: data.arch (data_arch@HOTMAIL.COM) at unix,mime Date: 31/05/00 17:30
Are you using the COPY sub-option (the package you are copying from does not exist?)
Suresh
>From: Raghu Tarigonda >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: bind-package-error >Date: Wed, 31 May 2000 09:37:50 -0600 > >Hai > > I am getting a sql error -805 (80N) when binding a package.Share your >expertise if any body has got the >same error.I would appreciate your help. > >Thanks. [...]
9244 104 22_Re: bind-package-error11_Mayo Arthur19_Arthur.Mayo@IRS.GOV31_Wed, 31 May 2000 12:48:51 -0400507_iso-8859-1 Raghu, are you running in a remote region ? The -805 we get around here are caused by not binding in the remote subsystem also.
HTH
-----Original Message----- From: Raghu Tarigonda [mailto:rtarigo@NOTES.MNET.USWEST.COM] Sent: Wednesday, May 31, 2000 11:38 AM To: DB2-L@RYCI.COM Subject: bind-package-error
Hai
I am getting a sql error -805 (80N) when binding a package.Share your expertise if any body has got the same error.I would appreciate your help. [...]
9349 49 22_Re: bind-package-error41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Wed, 31 May 2000 14:25:41 -0300357_iso-8859-1 I would verify:
- if the program was compiled in the same library that is informed in the JCL for execution; - if you are executing a production program with a test package (or vice-versa); - if your CICS application has received a NEW version; - if you have a CICS program which calls another. If true, try to compile and bind both. [...]
9399 71 20_Re: PQ30684 Problems0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Wed, 31 May 2000 12:36:16 -0500699_us-ascii You can fix this problem by modifying the INCLUDE in step DSNTIZQ from ADSNLOAD to SDSNLOAD.
Burgess Evans on 05/31/2000 07:36:37 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Shan Leatherman/MO/americancentury) Subject: PQ30684 Problems
Hi all,
We are in the process of migrating from DB2 UDB for OS/390 V5 to DB2 UDB for OS/390 V6 . We are trying to apply maintenance for fallback and coexistence support. We have run into a problem trying to apply APAR PQ30684 in PTF UQ40803 to DB2 UDB for OS/390 V5. [...]
9471 35 12_rexx for db210_Tom Taylor17_ttaylor@CHUBB.COM31_Wed, 31 May 2000 13:51:17 -0400550_us-ascii Hi all
Just installed rexx for db2 on a v51 system. I'm trying to test with the following rexx exec:
/* REXX */ TRACE ?I 'SUBCOM DSNREXX' IF RC THEN S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX') ADDRESS DSNREXX "CONNECT DB2M" SQL1='SELECT LUNAME FROM SYSIBM.LUNAMES' ADDRESS DSNREXX "EXECSQL DECLARE C1 CURSOR FOR S1" ADDRESS DSNREXX "EXECSQL PREPARE S1 FROM :SQL1" ADDRESS DSNREXX "EXECSQL OPEN C1" ADDRESS DSNREXX "FETCH C1 INTO :LUN" SAY LUN ADDRESS DSNREXX "DISCONNECT" S_RC = RXSUBCOM('DELETE','DSNREXX','DSNREXX') EXIT [...]
9507 178 56_Re: DB2 Connect Licensing - 'Concurrent User' definition15_Belfield, Al G.15_AGBELFI@TWA.COM31_Wed, 31 May 2000 12:44:04 -0500348_iso-8859-1 I've just realised that I should have written "(given that all 500 will be switched on and 'in' the application at the same time)?" rather than "(given that all 100 will be switched on and 'in' the application at the same time)?"
which will probably influence the answer..... (I put it down to 'Friday after lunch doldrums') [...]
9686 58 16_Re: rexx for db220_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 31 May 2000 13:50:59 -0400416_us-ascii You missed EXECSQL before FETCH.
ADDRESS DSNREXX "EXECSQL FETCH C1 INTO :LUN"
This should work Regards, Venkat Pillay
-----Original Message----- From: Tom Taylor [SMTP:ttaylor@CHUBB.COM] Sent: Wednesday, May 31, 2000 1:51 PM To: DB2-L@RYCI.COM Subject: rexx for db2
Hi all
Just installed rexx for db2 on a v51 system. I'm trying to test with the following rexx exec: [...]
9745 37 18_JDBC Type 2 Driver13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Wed, 31 May 2000 14:06:19 -0400568_US-ASCII Hi All,
We are still inexperienced in the world of JAVA and have had trouble connecting to DB2 through JDBC. We have migrated one DB2 UDB for OS/390 subsystem to V6. We also installed and configured the SQLJDBC Type 2 driver on that subsystem.
We are now trying two things: 1. Use Websphere 1.2 for OS/390 to talk to DB2 using a Websphere JDBC sample application. This failed with a 500 error code and the error log said a Resource 2. Because of the first problem, we are now trying to compile a JDBC sample application shipped with DB2 to [...]
9783 79 40_Re: Extracting data for test - THANK YOU18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Wed, 31 May 2000 14:09:38 -0400498_iso-8859-1 I received several responses, leads and info. I even got a call from a vendor. They're watching! My thanks to those who took the time to respond.
Pete
Peter Bourgoine - DBA Data Resource Management Jefferson Pilot Financial 1 Granite Place Concord, NH 03301 603-226-5906 603-226-4212 (fax)
-----Original Message----- From: Rob Crane [mailto:racrane@CONCENTRIC.NET] Sent: Wednesday, May 31, 2000 11:15 AM To: DB2-L@RYCI.COM Subject: Re: Extracting data for test [...]
9863 225 26_Re: Hiperpool in DSNDB07 ?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 31 May 2000 14:29:59 -0400296_iso-8859-1 Is it 2GB per address space or per LPAR ? Due 32bit addressing, 2GB is limit per address space.
I thought in CMOS the memory is configurable. To configure it as REAL or EXPANDED is up to MVS SYSPROG. If CICS,IMS & STC etc. needs more REAL then it is possible to configure. [...]
10089 21 34_WLM stored procedures -444 SQLCODE9_Joe Smith18_JSmith0763@AOL.COM29_Wed, 31 May 2000 14:47:31 EDT454_US-ASCII We are implmenting WLM stored procedures and are incurring the sqlcode -444.
HAs anybody come across this error before in implementing the above?
We believe that our set up is corrrect in that we have set UP WLM and RRS as well as updating sysprocedures table with correct information i.e: APPL_ENV, LOADMOd columns with WLM appl environment and MVS load module from WLMstarted task JCL. Any suggestions would be appreciated. [...]
10111 71 36_Re: User Defined Functions/RRS woes.11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Wed, 31 May 2000 13:59:47 -0500501_us-ascii Reason Code=00F30013
Explanation: The requester is not authorized to connect to this DB2 subsystem. This condition might indicate an attempted security violation.
This reason code is issued by the following CSECT: DSN3AUCN
System Action: The connection request is denied.
User Response: Verify that you have specified the correct RACF authorization ID. If necessary, request authorization to access the DB2 subsystem from your security administrator. [...]
10183 64 38_Re: WLM stored procedures -444 SQLCODE11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Wed, 31 May 2000 14:20:17 -0500486_us-ascii DB2 UDB for OS/390 V6 Messages and Codes:
-444 USER PROGRAM name COULD NOT BE FOUND
| Explanation: DB2 received an SQL CALL statement for a stored procedure or | an SQL statement containing an invocation of a user-defined function, and | found the row in the SYSIBM.SYSROUTINES catalog table associated with the requested procedure name. However, the MVS load module identified in the | EXTERNAL_NAME column of the SYSIBM.SYSROUTINES row could not be found. [...]
10248 105 20_Re: PQ30684 Problems13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Wed, 31 May 2000 15:36:44 -0400467_US-ASCII Thank you's to Shan Leatherman and Bob Yoder.
We overlooked the include step DSNTIZQ.
We are going to remove it and reapply the fix tomorrow.
Thank you again for your help,
Burgess Evans, DBA Auditor of State of Ohio bmevans@auditor.state.oh.us
>>> Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM 05/31/00 01:36PM >>> You can fix this problem by modifying the INCLUDE in step DSNTIZQ from ADSNLOAD to SDSNLOAD. [...]
10354 23 27_removal of SYSADM from DBAs14_Enser, Matthew27_Matthew.Enser@USA.XEROX.COM31_Wed, 31 May 2000 15:31:45 -0400412_iso-8859-1 Due to recent security audits, our DBA group has been tasked with researching the impact(s) of removing SYSADM authority from our ID's. Has anyone gone through this, and if so what issues or concerns have come up? (I know there are a lot of "it depends...") We have talked about the use of secondary auth id's, so if anyone has any information about implementing those, it would also be helpful. [...]
10378 59 31_Re: removal of SYSADM from DBAs11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 31 May 2000 13:00:31 PDT535_- I recently went through this exercize and did basically the following:
1. Made all grants that I wanted DBAs to have to a racf group id of which each dba was made a member. 2. Granted DBADM of all application databases to the racf id. 3. Granted PACKADM to the racf id. 4. Granted some of the auths (but not all) such as BINDADD that come with SYSCNTL to the racf id. 5. Revoked SYSADM one dba at a time avoiding cascading revokes by using the method of changing zparms to add them as install sysadm just for the revoke, [...]
10438 41 31_Re: removal of SYSADM from DBAs0_21_william.poston@DB.COM31_Wed, 31 May 2000 15:00:18 -0600763_us-ascii Be carefull of the cascade effect of security id's
---------------------------------------- Message History ----------------------------------------
From: Matthew.Enser@usa.xerox.com on 05/31/2000 07:31 PM GMT
Please respond to DB2-L@ryci.com
To: DB2-L@ryci.com cc: Subject: removal of SYSADM from DBAs
Due to recent security audits, our DBA group has been tasked with researching the impact(s) of removing SYSADM authority from our ID's. Has anyone gone through this, and if so what issues or concerns have come up? (I know there are a lot of "it depends...") We have talked about the use of secondary auth id's, so if anyone has any information about implementing those, it would [...]
10480 63 38_Re: WLM stored procedures -444 SQLCODE13_OConner, John26_John.OConner@COURTS.WA.GOV31_Wed, 31 May 2000 13:04:54 -0700790_iso-8859-1 Joe,
Is your load module accessible from the WLM startup proc? We added a steplib to the proc for the load library that contained the load module for the stored procedure. Like this:
//************************************************************* //* JCL FOR RUNNING THE WLM-ESTABLISHED STORED PROCEDURES //* ADDRESS SPACE //* RGN -- THE MVS REGION SIZE FOR THE ADDRESS SPACE. //* DB2SSN -- THE DB2 SUBSYSTEM NAME. //* NUMTCB -- THE NUMBER OF TCBS USED TO PROCESS //* END USER REQUESTS. //* APPLENV -- THE MVS WLM APPLICATION ENVIRONMENT //* SUPPORTED BY THIS JCL PROCEDURE. //* //************************************************************* //DB2DWLM PROC RGN=0K,APPLENV=XXXXXXXX,DB2SSN=DB2D,NUMTCB=8 //IEFPROC EXEC PGM=DSNX9WLM,REGION=&RGN,TIME=NOLIMIT, // [...]
10544 82 29_Hiperpool in DSNDB07 - Thanks10_Max Scarpa16_mocion@INWIND.IT31_Wed, 31 May 2000 22:07:54 +0200315_iso-8859-1
I found and read again the article about hiperpools with DSNDB07 and the answer was clear.
Some years ago I used HP with DSNDB07 but HP ratio was verrry low, so I thought that was
due to 'in - use' pages. And it was correct, because we never (more or less) reached the (V)DWQT [...]
10627 46 27_R: SYSLGRNX cleanup on DROP10_Max Scarpa16_mocion@INWIND.IT31_Wed, 31 May 2000 22:09:12 +020098_iso-8859-1 Good shot !!! This is about Paleo-DB2.....
Thank a lot Dan !!!
Max Scarpa
10674 96 36_Re: User Defined Functions/RRS woes.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Wed, 31 May 2000 13:22:48 -0700478_iso-8859-1 I did look up the 00F0013 message in the Messages and Code but still a little perplexed. The M&C states its a DB2 auth problem but from the concol message text it looks like the issue is with RRS not a DB2 subsystem. The M&C mentions looking in the syslog for RACF message, I found none. I do have two profiles set up under RACF General Resource Profiles. Two generic profiles, DSN*.* with owner DB2 for the WLM address spaces, and RRS.* with owner DB2 for RRS. [...]
10771 89 38_Re: WLM stored procedures -444 SQLCODE11_Suresh Sane21_data_arch@HOTMAIL.COM29_Wed, 31 May 2000 16:16:00 CDT653_- Is it possible the loadlib has recently gone into extents (if a pds)? This is a known problem since os/390 does not recognize the modules located in the extent until the SP address space itself is stopped and started.
HTH.
Suresh
>From: "OConner, John" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: WLM stored procedures -444 SQLCODE >Date: Wed, 31 May 2000 13:04:54 -0700 > >Joe, > >Is your load module accessible from the WLM startup proc? We added a >steplib to the proc for the load library that contained the load module for >the stored [...]
10861 123 36_Re: User Defined Functions/RRS woes.22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 31 May 2000 17:24:17 -0400661_- I've not installed DB2 WLM SPs & RRS but I'll guess that the authid (userid?) associated with the DSNTWLM address space is not authorized to connect to the DB2 subsystem.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: Cliff Boley[SMTP:Maurice.C.BOLEY@ODOT.STATE.OR.US] > Sent: Wednesday, May 31, 2000 4:22 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] User Defined Functions/RRS woes. > > I did look up the 00F0013 message in the Messages and Code but still a > little > perplexed. The M&C states its a DB2 auth problem but from the concol > message text it looks like the [...]
10985 27 21_DB2 PM Online Monitor23_Lee, Kenneth (Exchange)14_kmlee@BEAR.COM31_Wed, 31 May 2000 17:44:49 -0400569_- Hi all, Can I please have a feedback on DB2 PM Online Monitor(V6) compared to OEMs(TMON, Omegamon...)? We are serious about replacing other tools with DB2 PM Online Monitor.
Thanks, Ken
>
*********************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. *********************************************************************** [...]
11013 68 26_Re: Hiperpool in DSNDB07 ?11_Jon Nolting18_nolting@AMDAHL.COM31_Wed, 31 May 2000 14:46:33 -0700473_us-ascii For the current batch of machines out on the market from all vendors, 31-bit addressing limits the amount of real storage an operating system instance can use to 2G. This means that an SCP running on a basic mode machine or in a partition/domain can have at most 2G real storage. That operating system instance can have additional expanded storage. Within the operating system, however, the virtual addressing limits continue to stop at 2G per address space. [...]
11082 15 25_Re: DB2 PM Online Monitor26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Wed, 31 May 2000 17:18:53 -0500385_- Please include decision criteria and if applicable weighting factors. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11098 45 31_Re: removal of SYSADM from DBAs9_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 31 May 2000 17:00:31 -0600354_us-ascii One limitation is the creation of views on objects the DBADM ID does not explicitly own, in the past this was usually the reason DBA's were granted SYSADM instead of just DBADM/PACKADM. I believe in V7 of DB2 for OS390 they have give DBADM the authority to create views so that would get you out of the requirement of DBA's needing SYSADM. [...]
11144 54 26_CREATE TRIGGER hangs Spufi12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 31 May 2000 18:08:24 -0500410_us-ascii Hello.
I'm trying to re-create a trigger on a table I recently dropped and re-added. The trigger is simple:
SET CURRENT SQLID = 'DBATEST':
CREATE TRIGGER FIISBCO1 NO CASCADE BEFORE INSERT ON FIT_SUBC_OBJ_RULES REFERENCING NEW AS NROW FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC SET NROW.CREATE_TIMESTAMP = CURRENT TIMESTAMP, NROW.UPDATE_TIMESTAMP = CURRENT TIMESTAMP; END : [...]
11199 46 25_Re: DSNCLI Module missing14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 1 Jun 2000 11:43:02 +1000483_iso-8859-1 DB2 V6 with CICS up to TS 1.3 is a problem because they each expect the other to ship it.
We found a copy in CICS.ADFHMOD (which CICS uses to link into its modules).
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au -----Original Message----- From: SrinivasG [mailto:SRINIVASG@INF.COM] Sent: Wednesday, May 31, 2000 1:20 AM To: DB2-L@RYCI.COM Subject: DSNCLI Module missing [...]
11246 116 26_Re: DB2 Hang, Or is it NT?11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Thu, 1 Jun 2000 12:34:20 +1000585_- Philip,
we had a similar problem a while ago and noticed that we had forgotten to increase the maxappls parameter from its NT default value of 20 ... Maxappls is documented in the admin guide.
Cheers, Ulrich
> -----Original Message----- > From: Philip Gunning [SMTP:pgunning@BOSCOVS.COM] > Sent: Thursday, June 01, 2000 12:18 AM > To: DB2-L@RYCI.COM > Subject: DB2 Hang, Or is it NT? > > We have been having some problems with DB2 UDB EE v6.1 Win NT (FP3F) on NT > Server 4.0 (SP6) locking up during peak periods. We have done extensive > tuning and do not [...]
11363 152 36_Re: User Defined Functions/RRS woes.13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Thu, 1 Jun 2000 08:11:32 +0530389_us-ascii Actually its a pity ... IBM talks about RRS but there a quite a few problems in it. we were trying to do a lot of things in RRS specially w.r.t secondary authentication / thread management and context switching. But there were always hurdles on the way in the form of PTFs and APARS ... The intial releases that we buy can be say it to be the beta version of the product :-) [...]
11516 18 36_Re: Removing a Quiesce Update in UDB7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Wed, 31 May 2000 22:04:50 -0500318_- I am having the same problem with Quiesced Update on one of the tablespaces.
I did try to reset it but it has not worked. I forced off everyone off the database, stopped, and restarted it. But the tablespace is still in Quiesced Update state.
Is there anyway to find out who put it in that state? [...]
11535 36 22_Re: bind-package-error17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET30_Thu, 1 Jun 2000 09:46:58 +0500656_- Hello Raghu, Are you sure you got -805 while binding a package?? Usually we get -805 while executing the application program.
VIJAY
> -----Original Message----- > From: Raghu Tarigonda [SMTP:rtarigo@NOTES.MNET.USWEST.COM] > Sent: Wednesday, May 31, 2000 9:08 PM > To: DB2-L@RYCI.COM > Subject: bind-package-error > > Hai > > I am getting a sql error -805 (80N) when binding a package.Share your > expertise if any body has got the > same error.I would appreciate your help. > > Thanks. > Raghu. > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L [...]
11572 27 35_Commiting within a Stored Procedure12_Raymond Bell20_raymondb@NZ1.IBM.COM30_Thu, 1 Jun 2000 16:28:05 +1200574_us-ascii Colleagues,
A quick question: I believe it's not possible to issue commit statements from within a stored procedure if the process calling the procedure is a CICS transaction. Is this true?
DB2 for OS/390 V5 (about 9910) CICS 4.1 OS/390 2.6
Cheers,
Raymond Bell DB2 DBA blah blah blah...
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.