1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2002, week 4 2 41 41_AW: Software Symposium 2002 Agenda posted12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 22 Apr 2002 08:45:29 +0200550_iso-8859-1 Thanks for pointing this out, Roger.

See you in Vienna.



With kind regards - mit freundlichen Gruessen, Georg H. Peter

-----Ursprüngliche Nachricht----- Von: Roger Miller [mailto:millerrl@US.IBM.COM] Gesendet am: Samstag, 20. April 2002 21:11 An: DB2-L@RYCI.COM Betreff: Software Symposium 2002 Agenda posted

The agenda for the Software Symposium 2002 to be held in Vienna, Austria, June 10 - 14 is posted on the web now. There are pdf files for the WebSphere, Data Management, & Tivoli tracks now. [...] 44 16 49_George Koegel/Rochester/IBM is out of the office.13_George Koegel18_gkoegel@US.IBM.COM31_Mon, 22 Apr 2002 02:49:00 -0400467_us-ascii I will be out of the office starting April 22, 2002 and will not return until April 23, 2002.

If DBDC Performance support is needed Immediately, Please contact my Backup Brian Beahan or my Manager Lauren Pauli

================================================ 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. 61 121 82_Re: Coolgen 4.1A and/or Oracle Transparent Gateway 4.01.1 - DB2 V 7 co mpatibility13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Mon, 22 Apr 2002 17:22:45 +1000497_iso-8859-1 I guess that CG 4.1 will 'work' with V7 but it will most definitely not exploit _any_ V7 features. You may need to check on things like type-2 indexes as V7 now disallows them, but if you are defaulting then that may be ok.

Regards,

Steve T

-----Original Message----- From: Raymond Bell [mailto:rbell@NZ1.IBM.COM] Sent: Monday, 22 April 2002 7:43 AM To: DB2-L@RYCI.COM Subject: Re: Coolgen 4.1A and/or Oracle Transparent Gateway 4.01.1 - DB2 V7 co mpatibility [...] 183 93 18_Re: DB2 DBA Wanted14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Mon, 22 Apr 2002 08:59:57 +0100608_iso-8859-1 >Urgent requirement for a DBA with strong experience in DB2 for OS/390. This >position is in the North East.

North-East what? Maine? Scunthorpe? Cairns? Vladivostok?



----------------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...] 277 193 33_Dallas DB2 Forum meeting tomorrow12_Robert Brock28_brock@KRYPTON-CONSULTING.COM31_Mon, 22 Apr 2002 03:01:17 -0500528_iso-8859-1 DB2 Forum - The Southwest DB2 Users Group. Visit our webpage at: http://www.db2forum.com

Come to the 2nd Quarter DB2 Forum Meeting. DB2 Forum would like to thank CDB Software Inc.for sponsoring this meeting.

Date: Tuesday April 23rd, 2002

Registration & Continental Breakfast: 8:00 A.M. - 9:00 A.M

Meeting: 9:00 A.M. - 12:30 P.M.

Meeting Location: Crowne Plaza North Dallas (formerly the Harvey Hotel) In the Chinaberry Room 14315 Midway Road Addison, Texas 75001 972-980-8877 [...] 471 207 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 22 Apr 2002 11:07:22 +0100460_iso-8859-1 Interesting Michael,

but HOW DOES IT KNOW?

For example, what if I have a tablespace that is currently "live" with "J" instance datasets, but I have some "I" instance datasets lying around. How on earth can DSN1COPY know which to use.....

Unless...... It must use the instance node of the SYSUT2 that you supply to derive the instance nodes for all the other partitions. That would explain why they all have to be the same. [...] 679 186 59_Re: Database Transfer from one DB server to other DB server12_Saima Jelani26_sjelani@ISB.COMSATS.NET.PK31_Mon, 22 Apr 2002 16:59:48 +0500345_iso-8859-1 Hello

u said to use set schema command to the old, but i dont fine any such command , can u plz tell me the exact commad which i should use afer creting and before restorring database sql. and also do i need to crete the user of old too too on the new system because it is not already present there. i m using NT platform [...] 866 19 50_Re: Migration from DB2 V5 to V7 on OS/390 platform13_Judi Westcott23_judi_westcott@YAHOO.COM31_Mon, 22 Apr 2002 05:47:25 -0500529_- Thank you for the information.

My apologies for the mistake in the original note, I'm was thinking one thing and trying to type another. Never works for me :-) I meant to say we do not run a SYSPLEX environment.

Sorry for the confusion.

Best regards, Judi Westcott

================================================ 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. 886 128 81_Re: Coolgen 4.1A and/or Oracle Transparent Gateway 4.01.1 - DB2 V7 co mpatibility14_Harvey Puckett19_hpuckett@GTA.GA.GOV31_Mon, 22 Apr 2002 07:59:26 -0400409_us-ascii Yeah, we had the unsupported O 7.3.4 clients as well and delayed our OTG 8.1.7 upgrade until all clients were upgraded ... else you knock them down ...

//harvey

-----Original Message----- From: Raymond Bell [mailto:rbell@NZ1.IBM.COM] Sent: Sunday, April 21, 2002 5:43 PM To: DB2-L@RYCI.COM Subject: Re: Coolgen 4.1A and/or Oracle Transparent Gateway 4.01.1 - DB2 V7 co mpatibility [...] 1015 31 27_Syspackage ran out of space22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Mon, 22 Apr 2002 09:03:50 -0300402_iso-8859-1 Hello,

Our SYSPKAGE ran out of space in a production subsystem. I suppose I need to issue an ALTER TABLESPACE followed by a REORG TABLESPACE on both DSNDB06.SYSPKAGE and DSNDB01.SPT01 (associated directory tablespace). Which are the drawbacks associated to this procedure during on-line processing (i.e. downtime, locks, etc.)?

Any information will be highly appreciated. [...] 1047 53 33_Control Center 'Connection' error16_Anand Sundaresan25_Anand.Sundaresan@UBSW.COM31_Mon, 22 Apr 2002 13:55:03 +0100558_US-ASCII Hi

I am using the DB2 Control Center on Windows NT and using this to connect to UDB 6.1 Databases on Sun Solaris. I am able to list tables and manage them from the CC. Its only that when I want to see the 'connections' or 'show monitors', I am getting this problem displayed as a window. I looked at the ODBC Settings and they are correct, reinstalled db2 many times and restarted the JDBC Applet Server services but to no avail. This problem persists. The Services are fine and I cannot see anything wrong with the installation either. [...] 1101 45 19_Re: REVOKE BINDAUTH10_James Kwan19_jamesdb2kwan@CS.COM31_Mon, 22 Apr 2002 08:17:07 -0500617_iso-8859-1 Su,

May be he is using a second auth id?

Regards,

James Kwan IBM Certified Solutions Expert ----- Original Message ----- From: "Su Arun" Newsgroups: bit.listserv.db2-l To: Sent: Saturday, April 20, 2002 6:50 PM Subject: REVOKE BINDAUTH



> Hi Listers, > > I have a situation where the user bound a plan some time in 2000 with > SYSPLAN table showing an entry . But when I try to query the SYSPLANAUTH > table now , I cannot see his entry in the GRANTOR/GRANTEE column with > BINDADD . > Is it because of his BINDADD is being [...] 1147 39 11_Admin tools9_Martin V.17_MVirta@OLGC.ON.CA31_Mon, 22 Apr 2002 09:16:45 -0400296_us-ascii Hello,

Is anyone here using 3rd party admin tools like Embarcadero's DBArtisan to manage DB2 UDB?

We currently use DBArtisan for Sybase and MS SQL Server and like it a lot. Are there any other "enterprise class" tools out there that we should be looking at?



1187 227 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY15_Murley, Michael22_Michael_Murley@BMC.COM31_Mon, 22 Apr 2002 08:33:43 -0500561_iso-8859-1 Yes, it uses the DSN in SYSUT2 to derive the DSNs for all the rest, it seems.

-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: April 22, 2002 5:07 AM To: DB2-L@RYCI.COM Subject: Re: Restore TS with a Full Copy not referenced in SYSCOPY



Interesting Michael,

but HOW DOES IT KNOW?

For example, what if I have a tablespace that is currently "live" with "J" instance datasets, but I have some "I" instance datasets lying around. How on earth can DSN1COPY know which to use..... [...] 1415 16 53_Tara-Mae Richards/ID/CitiStreet is out of the office.17_Tara-Mae Richards30_TRichards@CITISTREETONLINE.COM31_Mon, 22 Apr 2002 00:47:06 -0400435_us-ascii I will be out of the office from 04/20/2002 until 04/29/2002.

I will respond to your message when I return.

If it is an emergency, please email Don Pegg with the details.

================================================ 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. 1432 61 31_Re: Syspackage ran out of space16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 22 Apr 2002 09:36:26 -0400384_iso-8859-1 First FREE all obsolete pacakges. Identify by something like:

SELECT COLLID, NAME, VERSION FROM SYSIBM.SYSPACKAGE A WHERE TIMESTAMP < (SELECT MAX(TIMESTAMP) FROM SYSIBM.SYSPACKAGE B WHERE A.COLLID = B.COLLID AND A.NAME = B.NAME);

You might also want to make the tablespace larger. Rename it, IDCAMS DEFINE a larger version, DSN1COPY from renamed to new. [...] 1494 42 31_Re: Syspackage ran out of space7_DB2 DBA21_db2_dba@BELLSOUTH.NET31_Mon, 22 Apr 2002 09:38:03 -0400625_ISO-8859-1 You could also issue a FREE on some older versions of packages. > > From: Claudio Meluzzi Mendes > Date: 2002/04/22 Mon AM 08:03:50 EDT > To: DB2-L@RYCI.COM > Subject: Syspackage ran out of space > > Hello, > > Our SYSPKAGE ran out of space in a production subsystem. I suppose I need to > issue an ALTER TABLESPACE followed by a REORG TABLESPACE on both > DSNDB06.SYSPKAGE and DSNDB01.SPT01 (associated directory tablespace). Which > are the drawbacks associated to this procedure during on-line processing > (i.e. downtime, locks, etc.)? > > Any information will be highly appreciated. [...] 1537 65 31_Re: Syspackage ran out of space23_Tello Najera Juan Pablo26_jp.tello@BBVA.BANCOMER.COM31_Mon, 22 Apr 2002 08:41:08 -0500560_iso-8859-1 It is not an alter what you need to do. Because they are system tables they are not allocated using DB2 Services like Stogroups. They are allocated when DB2 Subsystem is installed. What you have to do is Image copy Tablespace, STOP tablespace, STOP Indexes, Delete Define VSAM Dataset including indexes if they increased their size also. Then recover TS to present and then rebuild the indexes. Then You are all set. The problem is the window that you need to do this, it might take half an hour maybe but in that time no body would be able to [...] 1603 101 46_Re: connecting to distributed data base system10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Mon, 22 Apr 2002 07:53:19 -0600592_iso-8859-1 Hi Raymond, Thanks for your reply. After I entered location name on SPUFI, I got information from remote DB2.

Grace -----Original Message----- From: Raymond Bell [mailto:rbell@NZ1.IBM.COM] Sent: Sunday, April 21, 2002 3:45 PM To: DB2-L@RYCI.COM Subject: Re: connecting to distributed data base system



Grace,

If you want to query one subsystem from another, you could go into QMF and 'Select * from ssid.Sysibm.Sysdatabase' and see what happens. Or, in SPUFI, you could give the ssid at the '10 Connection Location' field and try to connect there. [...] 1705 187 31_Re: Syspackage ran out of space14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 22 Apr 2002 15:04:25 +0100394_iso-8859-1 Hi Claudio,

If only it were that simple!!

Unfortunately, the directory and catalog ate all VCAT defined and not STOGROUP defined.

The official solution to this is:

0. Take an image copy of the tablespace 1. Run REORG UNLOAD PAUSE 2. Delete and define a larger tablespace 3. Run REORG UNLOAD CONTINUE

However, there are quicker (better?) ways. [...] 1893 59 31_Re: Syspackage ran out of space9_Dave Will26_david.e.e.will@VERIZON.COM31_Mon, 22 Apr 2002 09:51:35 -0400808_us-ascii Claudio,

Did anyone check to see if there is an unreasonable number of versions being maintained in SYSPAKAGE?

Dave







Claudio Meluzzi Mendes @RYCI.COM> on 04/22/2002 09:03:50 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Syspackage ran out of space



Hello,

Our SYSPKAGE ran out of space in a production subsystem. I suppose I need to issue an ALTER TABLESPACE followed by a REORG TABLESPACE on both DSNDB06.SYSPKAGE and DSNDB01.SPT01 (associated directory tablespace). Which are the drawbacks associated to this procedure during on-line processing (i.e. downtime, locks, [...] 1953 42 15_Re: Admin tools16_Fennell, Michael23_Michael.Fennell@FMR.COM31_Mon, 22 Apr 2002 10:06:16 -0400314_- Martin,

I have used this product for DB2 and it works well. It is faster and friendlier than control center. The only drawback that I could see is that the monitoring function was not as robust as it is for Oracle and probably Sybase.

Mike Fennell Database Services 508-787-9120 PIN # 2128845 [...] 1996 17 26_Load with CSV on OS/390 v712_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Mon, 22 Apr 2002 09:29:18 -0500396_us-ascii Will the LOAD utility work with a CSV file on UDB 7.1 for OS/390? I am not finding anything saying it will.

Thanks in advance.

Buzz

================================================ 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. 2014 54 18_Re: DB2 DBA Wanted14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Mon, 22 Apr 2002 10:22:16 -0400329_iso-8859-1 This posting reminds me of a Yaacov Smirnoff story. For those who do NOT know Yaacov Smirnoff, he's a Russina comedien who came to the USA some years back, and made a bit of a "splash" on TV, for a while. He has a line about life in the USA, that goes: "What a country..." (spoken with a thick Russian accent...) [...] 2069 46 19_Re: REVOKE BINDAUTH12_leila rahimi21_lshosaini@HOTMAIL.COM31_Mon, 22 Apr 2002 14:42:46 +0000602_- Hi s Hi su. you are right,but BINDADD is in sysuserauth table...but when revoke,that row will be delete...i though if i print log ,for this OBID ,i'll find any thing,but it wasn't clear....if u have enough time,you can do this. bye. leila >From: Su Arun >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: REVOKE BINDAUTH >Date: Sat, 20 Apr 2002 18:50:03 -0500 > >Hi Listers, > >I have a situation where the user bound a plan some time in 2000 with >SYSPLAN table showing an entry . But when I try to query the SYSPLANAUTH >table now [...] 2116 27 31_Re: Syspackage ran out of space22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Mon, 22 Apr 2002 11:55:39 -0300473_iso-8859-1 RE: [DB2-L] Syspackage ran out of spaceHi Phil and list fellows,

Our support personnel managed to use the DFDSS for consolidating the file into a single extent and the procedure was quite fast.

Thank you all for your fast and accurate answers.

Claudio **************************************** Claudio Meluzzi Mendes BANCO BEG S.A. Goiania - Goias - BRAZIL claudio@beg.com.br cmeluzzi@uol.com.br **************************************** [...] 2144 114 46_Re: connecting to distributed data base system10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Mon, 22 Apr 2002 08:58:59 -0600635_iso-8859-1 Raymond, After I tested under SPUFI, I was trying to test it under batch job with DSNTEP2. I got error message :

DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME CUCDDB2..DSN@EP2L.1681F6BA075F4BDC NOT FOUND IN PLAN DSNTEP71. REASON 02

I believe I need to BIND something, but not quite sure how to do it. I got the original bind statement from the SDSNSAMP: BIND PACKAGE (DSNTEP2) MEMBER(DSN@EP2L) + CURRENTDATA(NO) ACT(REP) ISO(CS) ENCODING(EBCDIC) BIND PLAN(DSNTEP71) PKLIST(DSNTEP2.*) + CURRENTDATA(NO) ACT(REP) ISO(CS) ENCODING(EBCDIC) SQLRULES(DB2) Do I need do anything on the target DB2 system? [...] 2259 73 15_Re: Admin tools14_Bill Gallagher28_BILL.GALLAGHER@PHOENIXWM.COM31_Mon, 22 Apr 2002 10:59:50 -0400510_us-ascii We have used DBArtisan for SQL Server and UDB, and feel that it is a decent product for doing small, simple administrative tasks. But it just wasn't robust enough for us to handle any larger scale, complex database schema changes, so we looked for another product. We ended up with BMC Patrol "Change Manager", which I very strongly endorse, it is a great product. Since we were already experienced with the mainframe BMC toolset for managing DB2 on OS/390, it was a very easy transition for us. [...] 2333 150 31_Re: Syspackage ran out of space15_Patrick Hignett33_Patrick.Hignett@MORGANSTANLEY.COM31_Mon, 22 Apr 2002 15:52:15 +0100541_us-ascii Can't you just do a listcat addvol?????

"Grainger, Phil" wrote:

> > > Hi Claudio, > > If only it were that simple!! > > Unfortunately, the directory and catalog ate all VCAT defined and not > STOGROUP defined. > > The official solution to this is: > > 0. Take an image copy of the tablespace > 1. Run REORG UNLOAD PAUSE > 2. Delete and define a larger tablespace > 3. Run REORG UNLOAD CONTINUE > > However, there are quicker (better?) ways. > > For example, if your pageset is in multiple extents, use DFDSS to > [...] 2484 74 18_Re: DB2 DBA Wanted16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 22 Apr 2002 11:06:21 -0400653_iso-8859-1 'Visa sponsorship' requires a lot of paperwork and legal obligations that not all employers can afford or support.

Regards, eric pearson





-----Original Message----- From: Shaul Bergfeld [mailto:sbergfeld@TACT.COM] Sent: Monday, April 22, 2002 10:22 AM To: DB2-L@RYCI.COM Subject: Re: DB2 DBA Wanted



This posting reminds me of a Yaacov Smirnoff story. For those who do NOT know Yaacov Smirnoff, he's a Russina comedien who came to the USA some years back, and made a bit of a "splash" on TV, for a while. He has a line about life in the USA, that goes: "What a country..." (spoken with a thick [...] 2559 101 18_Re: DB2 DBA Wanted14_Harvey Puckett19_hpuckett@GTA.GA.GOV31_Mon, 22 Apr 2002 11:24:04 -0400526_us-ascii ... good point. I am an immigrant myself from the coalfields of Appalachia ... we are all immigrants aren't we, and sponsorship is not the issue, technical ability is ... in America. Almost enough to bring out the Allie Fox in me!

Am I the only one this bothers, or is there something intrinsically offensive in these "headhunters" exploiting our chalktalk with there inane "probes" most of which are to build resume base ... IF WE WANT A JOB, THEN WE WILL ASK FOR A JOB, ELSE GOTO [...] 2661 33 54_Re: How to know the current "CURRENT RULES" register ?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 22 Apr 2002 11:29:25 -0400647_iso-8859-1 Hello Christophe, You can query the special register with:

SELECT CURRENT RULES FROM SYSIBM.SYSDUMMY1

COL1 ---- DB2

or in a program, Set :hostvarForRules = Current Rules

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@compuware.com





The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...] 2695 128 18_Re: DB2 DBA Wanted16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 22 Apr 2002 11:34:28 -0400429_iso-8859-1 Harvey,

Many of us are in imminent jeopardy of job loss due to outsourcing, downsizing, dumbsizing, the client/server fad, bankruptcies, and a lot of other reasons. We welcome *any* potential job leads, with this forum being as good a place as any. I have received some good leads from headhunters posting in this group. Alas, none have turned into employment. However, they were definitely welcome leads. [...] 2824 85 18_Re: DB2 DBA Wanted15_Russell Collins21_russell@ECTAUSTIN.COM31_Mon, 22 Apr 2002 10:57:45 -0700555_iso-8859-1 I think you are way off with these comments. I don't think you would be offended at a company if it chooses not to offer a 401k plan or a Health Care package. If you didn't like those terms, you wouldn't apply for the positions. Another thing that bothers me about these statements is the fact that "immigrants" feel as though the United States owes them something (IE a Visa Sponsorship). The US doesn't have to give immigrants anything just like the US doesn't just give it's own citizens anything. If I were to try and get some kind of [...] 2910 27 20_Re: DB2 DBA Wanted ?10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 22 Apr 2002 17:53:07 +0200387_us-ascii Hi estimeed listers

I know my ignorance, like some math limits, tends to infinite or, from another point of view, my knowledge is the same of

a singing amoeba. So please can someone explain to a poor devil what 'VISA sponsorship' is ?

A credit card sponsorship ? A new type of diet coke ? A new version ORACLE ? A new cure for hair loosers (please say [...] 2938 55 20_Re: DB2 DBA Wanted ?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 22 Apr 2002 12:05:15 -0400393_iso-8859-1 This usually applies to a type of visa called 'H1-B'. A set of employees identifed by US Congressweasels are exempted from the usual immigration regulations and subjected to much less stringent ones. Many large employers think H1-B is wonderful because it puts the principle of supply and demand strongly in favor of the employer. Many employees hate H1-B for the same reason. [...] 2994 109 24_Re: [Re: DB2 DBA Wanted]12_GENE TILELLI16_geetee52@USA.NET31_Mon, 22 Apr 2002 12:07:03 -0400584_ISO-8859-1 There are legitimate reasons that sponsorship is not a valid/desirable option for some jobs.

- some positions come in contact with data that by law is not allowed to be handled by non-citizens. - the expense of sponsorship is prohibitive... and in today's business climate, is an expense that those paying the bills would like to avoid (like TRAINING and travel, etc.) - the job market is tighter than it's been in the recent past... and in my opinion it is not a terrible thing for employers to be looking to give preference to U.S. citizens before we look to [...] 3104 145 18_Re: DB2 DBA Wanted15_Russell Collins21_russell@ECTAUSTIN.COM31_Mon, 22 Apr 2002 11:34:32 -0700687_iso-8859-1 I agree, these networking opportunities are welcome in my opinion.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Pearson, Eric L, Sent: Monday, April 22, 2002 8:34 AM To: DB2-L@RYCI.COM Subject: Re: DB2 DBA Wanted



Harvey,

Many of us are in imminent jeopardy of job loss due to outsourcing, downsizing, dumbsizing, the client/server fad, bankruptcies, and a lot of other reasons. We welcome *any* potential job leads, with this forum being as good a place as any. I have received some good leads from headhunters posting in this group. Alas, none have turned into employment. However, they [...] 3250 33 18_Re: DB2 DBA Wanted14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Mon, 22 Apr 2002 11:29:01 -0500317_iso-8859-1 Eric,

excuse me for being cynical (its my best trait), but could the reason that none of these 'good leads' has turned into employment be that there was no real job on offer. It is a common ploy used by recruitment companies to build up stocks of potential candidates to sell to their clients. [...] 3284 27 18_Re: DB2 DBA Wanted14_Allen, Susan A24_susan.a.allen@BOEING.COM31_Mon, 22 Apr 2002 09:29:54 -0700356_iso-8859-1 At minimum such trolls should offer a salary range - I see the same sorts of trash on the tech newsgroups (at least this one did pertain to the topic group)

Susan A

-----Original Message----- From: Harvey Puckett [mailto:hpuckett@GTA.GA.GOV] Sent: Monday, April 22, 2002 8:24 AM To: DB2-L@RYCI.COM Subject: Re: DB2 DBA Wanted [...] 3312 25 18_Re: DB2 DBA Wanted10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 22 Apr 2002 18:33:58 +0200380_us-ascii Hi Eric

I whole-heartedly agree with you, in the area where I work, due to outsourcing, ORACLEizing, UNIXizing,downsizing, and

many others -ing there's the risk of job losses (the top song is : 'loss is in the air...') as well. So every job opportunity (ok

mainly in the US until now but you never can tell ) might be useful in the next future. [...] 3338 18 18_Re: DB2 DBA Wanted0_26_truman.g.brown@VERIZON.COM31_Mon, 22 Apr 2002 13:07:06 -0400376_us-ascii People that post broadcast position openings on professional lists are not "head hunters", they are resume mailing mills. Or if not, at least they are asking you to do their job for them.

The true head hunters that I know never advertise in any way; they don't need to. Instead, they maintain company and people contacts and know their markets very well. [...] 3357 204 46_Re: DB2 tablespace size - or why run STOSPACE?0_19_mike.holmans@BT.COM31_Mon, 22 Apr 2002 18:07:48 +0100596_ISO-8859-1 Hi Marty,

"Since you probably run both [STOSPACE and RUNSTATS]"?

Is that a logical inference from the fact that Grace found differences, or based on an expectation that people will generally run both STOSPACE and RUNSTATS?

I'm asking because we don't run STOSPACE on any of our systems (at least, not that I know of), and I haven't felt that my life has been negatively affected in any way, so either STOSPACE is pretty useless or I don't know what I'm missing. I know some people who at least used to run it quite regularly, and I've always vaguely presumed [...] 3562 55 18_Re: DB2 DBA Wanted16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 22 Apr 2002 13:08:36 -0400454_iso-8859-1 In at least one of the cases the job was very real as I already new about the position and saw it get filled. In another case it was unfeasable because the employer (a tobacco company) had zero smoke-free workplace areas.

Regards, eric pearson





-----Original Message----- From: Clayton, Colin [mailto:Colin_Clayton@BMC.COM] Sent: Monday, April 22, 2002 12:29 PM To: DB2-L@RYCI.COM Subject: Re: DB2 DBA Wanted [...] 3618 67 37_Re: Control Center 'Connection' error16_Anand Sundaresan25_Anand.Sundaresan@UBSW.COM31_Mon, 22 Apr 2002 18:31:29 +0100636_US-ASCII Hi

Can anybody help

regards



-----Original Message----- From: Sundaresan, Anand Sent: 22 April 2002 13:55 To: DB2-L Subject: Control Center 'Connection' error



Hi

I am using the DB2 Control Center on Windows NT and using this to connect to UDB 6.1 Databases on Sun Solaris. I am able to list tables and manage them from the CC. Its only that when I want to see the 'connections' or 'show monitors', I am getting this problem displayed as a window. I looked at the ODBC Settings and they are correct, reinstalled db2 many times and restarted the JDBC Applet Server services [...] 3686 39 18_Re: DB2 DBA Wanted16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 22 Apr 2002 13:31:32 -0400582_iso-8859-1 Kathryn Sears posted a *very* real job to this group about a month ago. I verified the job by seeing it on the emoloyer's website.

Regards, eric pearson





-----Original Message----- From: truman.g.brown@VERIZON.COM [mailto:truman.g.brown@VERIZON.COM] Sent: Monday, April 22, 2002 1:07 PM To: DB2-L@RYCI.COM Subject: Re: DB2 DBA Wanted



People that post broadcast position openings on professional lists are not "head hunters", they are resume mailing mills. Or if not, at least they are asking you to do their job for them. [...] 3726 245 46_Re: DB2 tablespace size - or why run STOSPACE?13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Mon, 22 Apr 2002 13:46:00 -0400381_iso-8859-1 I believe that the updating the space columes of the tables was added to RUNSTATS when with DB2 version 5 ( I could be wrong, and accept that so it does not need to be pointed out to me).

Generally we here do RUNSTATS weekly and STOSPACE daily. We like the SPACE information for our DB2 "health check" jobs where we report on STOGROUPS getting low on space. [...] 3972 95 37_Re: Control Center 'Connection' error23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Mon, 22 Apr 2002 19:58:53 +0100417_- What version of the JDBC are you using?

we had major problems with 1.2 (I think) and then moved on a release and all was ok ..

have you called IBM?

Les

-----Original Message----- From: Anand Sundaresan [mailto:Anand.Sundaresan@UBSW.COM] Sent: Monday, April 22, 2002 6:31 PM To: DB2-L@RYCI.COM Subject: Re: Control Center 'Connection' error



Hi

Can anybody help [...] 4068 23 20_High cpu in IEAVRT058_Ron Root24_ron.root@CPA.STATE.TX.US31_Mon, 22 Apr 2002 14:17:21 -0500325_iso-8859-1 I am using Strobe to monitor DB2 V6. Some of our batch jobs show up to 60% of the cpu in IEAVRT05 (timer services), a module in extended common (AXSQISQL), and an unknown module in the private area. We have been unable to track down what is causing it. Most batch jobs show little or no cpu in these modules. [...] 4092 17 21_DSNZPARM MODIFICATION11_Barnes, Don16_Barnes@AAFES.COM31_Mon, 22 Apr 2002 14:27:09 -0500345_iso-8859-1 Can DSNZPARMS be modified without updating the boot strap. In DB2 version seven it states that you can change subsystem parameters without stopping DB2. How can this be done without an update to the bootstrap and is module DSNHDECP affected? The parm in question is NUMLKTS which the manual states that it can be updated online. [...] 4110 45 25_Re: DSNZPARM MODIFICATION16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 22 Apr 2002 16:05:34 -0400394_iso-8859-1 Reassemble and link DSNZPARM with the changes. Refresh LLA if DSNZPARM lives there. Then issue command: -SET SYSPARM LOAD(yourzparmname) DSNHDECP is not involved. No need to do anything to BSDS.

Do be wary of this if you are runnuing non-IBM tools or utilities as some of them chase control block chains. Ask your vendor whether their SW can cope with the ZPARM refresh. [...] 4156 51 24_Re: High cpu in IEAVRT0512_Bajew, Andre25_Andre.Bajew@COMPUWARE.COM31_Mon, 22 Apr 2002 16:14:43 -0400389_iso-8859-1 Hello Ron,

the axsqisql doesn't ring a bell but on ieavrt05, what DB2 trace classes do you have active for that plan and what does the measurement look like without the traces active?

Andre

-----Original Message----- From: Ron Root [mailto:ron.root@CPA.STATE.TX.US] Sent: Monday, April 22, 2002 2:17 PM To: DB2-L@RYCI.COM Subject: High cpu in IEAVRT05 [...] 4208 51 25_Re: DSNZPARM MODIFICATION23_Tello Najera Juan Pablo26_jp.tello@BBVA.BANCOMER.COM31_Mon, 22 Apr 2002 15:21:32 -0500398_iso-8859-1 DSNZPARMS are not stored on Boot Strap. Maybe you are looking into DSNTIJUZ job that makes a Boot Strap update but this only for migration or installation process. When you need to update any ZPARM Parm, then you can edit DSNTIJUZ job and change the value you want to change, then save the member, then delete the lines after the step DSNTIZL, submit the job and cancel the member. [...] 4260 14 55_automated updates to DB2 for OS/390 through DB2 Connect12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Mon, 22 Apr 2002 15:00:39 -0500294_- We have a customer that is planning to use DB2 Connect to update and retrieve data from DB2 for OS/390 on a schedule. We are looking for methods being used to automate this kind of application. What is used to submit the SQL commands on a schedule? Any suggestions would be helpful. TIA [...] 4275 45 19_Shortcut for DB2 PM0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 22 Apr 2002 15:51:53 -0500330_us-ascii Hello,

I tried this question on IBM-Main but got no responses. Any thoughts?

When I type: TSO EXEC 'DGO.V6R1M0.SDGOSAMP(DGOJINIT)' from (seemingly) any command line in TSO, I am placed into a DB2 PM menu panal.

I am trying to put this in a Rexx exec called DB2PM so I can simply type TSO DB2PM. [...] 4321 66 18_Re: DB2 DBA Wanted14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM31_Mon, 22 Apr 2002 15:49:43 -0500416_us-ascii I'm sorry, but as a blanket statement about recruiters this is simply untrue. I know good recruiters who have real DB2 positions to fill who would like to tell the professional DB2 community about them. What better place to do so than on the DB2-L list, provided they observe the explicit guidelines regarding this, as stated on the DB2-L FAQ at http://www.ryci.com/DB2-L. Under "List Topics" it says: [...] 4388 34 72_Looking for feedback on SMS groups, extended addressability, DB2 objects17_Doreen D. Rowland28_db2nm@NORTHWESTERNMUTUAL.COM31_Mon, 22 Apr 2002 15:55:52 -0500451_ISO-8859-1 We are starting to use >4G objects in some applications. We are following up and implementing all technical requirements that are needed to support EA.

Our question is to those members of the DB2 community who are currently and actively using objects >4G and DB2 V6 or V7 in production. Actually, any information from any member with knowledge they can pass on for the following subject would be greatly appreciated. Thank you! [...] 4423 38 22_-913 / Timeout problem0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 22 Apr 2002 16:08:34 -0500369_us-ascii Hello, OS 390 V6.1 here.

When volumn gets to high (whatever that means) I get scads of -913/00C9008E timeouts on our most critical control table. Here are the specifics:

1 row per page. (Via MAXROWS 1, 12 rows in the entire table.)

Relatively isolated bufferpool with tablespace and index, with a 99.8% hit rate. (According to DB2PM) [...] 4462 46 47_PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!12_Susan Lawson24_susan_lawson@YLASSOC.COM31_Mon, 22 Apr 2002 16:53:53 -0500332_us-ascii Hello all,

Please read this message and take note of the changes, otherwise you will lose access to DB2-L.

On Wednesday, April 24th at 6pm CST until 9pm CST the DB2-L list server will be unaccessible as we are switching to a new server. YL&A and the list owners will be performing tests during the time. [...] 4509 76 76_Re: Looking for feedback on SMS groups, extended addressability, DB2 objects12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 23 Apr 2002 09:44:48 +1200612_us-ascii Hi Doreen,

I did some testing on large objects at my last client. Have a look in the Archives for about a year ago, posts from me (try raymond.bell@team.telstra.com) looking for DSSIZE.

We don't use large objects here, but going from memory (always dodgy) you definitely don't want to mix large and non-large datasets. Something to do with how they're addressed - sorry, don't remember. We did create a separate SMS management (I think) class that governed only those datasets that would be 'large'. I think we specified 'dssize 32' and had only a handful of hiccups, mainly when the [...] 4586 70 23_Re: Shortcut for DB2 PM10_Ben Dissen22_Ben.Dissen@NEONSYS.COM31_Mon, 22 Apr 2002 16:56:12 -0500606_iso-8859-1 I would try:

ADDRESS ISPEXEC "SELECT CMD(EXEC 'DGO.V6R1M0.SDGOSAMP(DGOJINIT)')"

-- Binyamin Dissen



-----Original Message----- From: Steve_Grimes@AISMAIL.WUSTL.EDU [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Monday, April 22, 2002 3:52 PM To: DB2-L@RYCI.COM Subject: [DB2-L] Shortcut for DB2 PM



Hello,

I tried this question on IBM-Main but got no responses. Any thoughts?

When I type: TSO EXEC 'DGO.V6R1M0.SDGOSAMP(DGOJINIT)' from (seemingly) any command line in TSO, I am placed into a DB2 PM menu panal. [...] 4657 15 27_Certification (514 and 516)3_V K18_tech@GBRONLINE.COM31_Mon, 22 Apr 2002 17:03:12 -0500446_iso-8859-1 Thank you group for your suggestions and advices regarding DB2 FAMILY FUNDAMENTALS exam, I passed it succesfully. I am planning to take 514 and 516, any suggestions and book's recommendations ?

================================================ 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. 4673 36 18_Re: DB2 DBA Wanted12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 23 Apr 2002 10:18:02 +1200602_us-ascii Personally I liked Marcus' response. Seeing 'North East' I thought I might apply. I've always fancied a job in Korea. Or is it for Japan? Um, Taiwan? Unless Vladivostock (sp?) was on the money. Hmmm, maybe a few more details might get the response desired.

Being a rotten Johannes Foreigner for a good part of my life has meant I've become fairly familiar with the hoops, often small, soaked in petrol and blazing away like a solar flare, that various countries' immigration officials force candidates to jump through. I can only imagine the hoops aren't any larger and cooler for [...] 4710 166 37_Dallas DB2 Forum - last minute change12_Robert Brock28_brock@KRYPTON-CONSULTING.COM31_Mon, 22 Apr 2002 17:31:24 -0500427_iso-8859-1 A last minute update for the meeting, CDB Software will not be participating in our meeting tomorrow. Instead Judy Ruby-Brown from IBM has graciously agreed to do a second presentation. The topic will be an advanced DB2 Disaster Recovery presentation. Judy is a leading expert on the subject and I'm sure you will find the information very useful. Sorry for the last minute change. I hope to see you all there. [...] 4877 180 76_Re: Looking for feedback on SMS groups, extended addressability, DB2 objects13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Mon, 22 Apr 2002 15:40:41 -0700296_iso-8859-1 The former Platinum utilities do not support EA datasets. We had originally turned EA on an existing SMS pool, but new datasets < 4Gb that landed in that pool also got the EA attribute and could not be processed by Rapid Reorg, etc. We now have our EA datasets in their own pool. [...] 5058 65 23_Re: Shortcut for DB2 PM23_Puddy, Andrew (CALBRIS)36_Andrew.Puddy@COMALCO.RIOTINTO.COM.AU31_Tue, 23 Apr 2002 08:52:13 +1000566_iso-8859-1 Put in a concatenated clist EXEC 'DGO.V6R1M0.SDGOSAMP(DGOJINIT)' and it should be able to be run of the form TSO XXX

-----Original Message----- From: Steve_Grimes@AISMAIL.WUSTL.EDU [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Tuesday, 23 April 2002 6:52 To: DB2-L@RYCI.COM Subject: Shortcut for DB2 PM



Hello,

I tried this question on IBM-Main but got no responses. Any thoughts?

When I type: TSO EXEC 'DGO.V6R1M0.SDGOSAMP(DGOJINIT)' from (seemingly) any command line in TSO, I am placed into a DB2 PM menu panal. [...] 5124 53 59_Re: automated updates to DB2 for OS/390 through DB2 Connect9_Eric Kwai18_Eric_Kwai@DTCC.COM31_Mon, 22 Apr 2002 17:58:22 -0500346_- Richard: For both Unix and Windows client, you can create your sql statements in a script file named test1.sql as follows:

connect to sample user xxxx using xxxxx; select count(*) from sysibm.systables; update table1 .... commit; terminate connect reset

You can use the command to execute --> db2 -tvf test1.sql -z test1.out [...] 5178 76 23_Re: Shortcut for DB2 PM11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Mon, 22 Apr 2002 16:48:00 -0500498_us-ascii Try:

TSO %DB2PM

This will tell OS/390 that you want a CLIST or REXX not a load module!







Steve_Grimes@AISMAIL .WUSTL.EDU To: DB2-L@RYCI.COM Sent by: DB2 Data cc: Base Discussion List Subject: Shortcut for DB2 PM



04/22/02 03:51 PM Please respond to DB2 Data Base Discussion List











Hello,

I tried this question on IBM-Main but got no responses. Any thoughts? [...] 5255 15 47_Thomas G Taylor/ChubbMail is out of the office.10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 23 Apr 2002 01:05:02 -0400389_us-ascii I will be out of the office starting 04/22/2002 and will not return until 04/26/2002.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5271 140 46_Re: connecting to distributed data base system14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 23 Apr 2002 15:43:34 +1000367_US-ASCII Grace

1) you need to bind the package at the remote location: BIND PACKAGE(CUDDB2.DSNTEP2) .... 2) you need to tell your local plan where the package is on the remote system. The hard way to do this is to add CONNECT TO CUDDB2; SET CURRENT PACKAGESET = 'DSNTEP2'; before SELECT * FROM ....; which will select from the table on the remote system. [...] 5412 68 26_Re: -913 / Timeout problem14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 23 Apr 2002 15:43:35 +1000597_US-ASCII Steve,

Some thoughts:

- does the SP return the results of the FETCH/UPDATE to the caller? That is, is the application actually reliant on the SP results, or does the application just need the SP to have worked? If the latter, move the SP call to immediately before the COMMIT/SYNCPOINT.

- can you ignore failed txns? That is, can you move the SP call to the first thing in the txn (returning something), do a commit, do normal processing, then do something to clean up the situation immediately before the final syncpoint. This may require copying data to a row [...] 5481 45 26_Re: Strange join sequence?12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU31_Tue, 23 Apr 2002 09:13:37 +0200515_US-ASCII James, Peter, many thanks for your answers.

I wasn't aware that my solution is not an "official way" of tuning, but I had read the administration guide and tried the official ways before digging deeper. I had to add the "fake" operators on all conditions on table C to obtain the join sequence I wanted with another big disadvantage, I then had a tablespace scan on that table. Using OR 0 <> 0 on only the one condition gave me the join sequence with index access and the performance I wanted. [...] 5527 45 76_Re: Looking for feedback on SMS groups, extended addressability, DB2 objects10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 23 Apr 2002 09:41:29 +0200376_us-ascii Hi Doreen

I'm facing the same problem and in few weeks I'll migrate a LARGE user tablespace that reached the 4 Gb limit (with error 00C90099, never seen before).

What I want to do (as I'm the DASD manager so I can do what I want :-)) is to separate LARGE TSs n their own storage group, using a DATACLASS with EA attributes set to on + DSSIZE 8 Gb. [...] 5573 71 25_Re: DSNZPARM MODIFICATION0_18_mebert@AMADEUS.NET31_Tue, 23 Apr 2002 09:48:54 +0200595_us-ascii I have no specific V7 experience (yet), but this question is not restricted to DB2. Many programs store parameters in data-only load modules, that get loaded when you start the program and then reside in memory. Sometimes a parm might require extensive setup (e.g. it might require a memory array - control block - with appropriate size to be allocated and initialised). In other cases it is simply a constant that gets referenced more or less frequently. In the latter case, there is no problem in updating it Online, i.e. you simply change the memory contents where it is stored [...] 5645 36 46_Re: DB2 tablespace size - or why run STOSPACE?10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 23 Apr 2002 10:02:39 +0200384_us-ascii Hi Mike

I NEVER run STOSPACE. It's an utility (even if it's not a macho utility) and I don't like to add more infos to catalog when I can obtain space infos from SMS reports or IDCAMS LISTCAT. I don't like to run query that I don't need. And sometimes results are wrong as far as I can hear. I found that HI-USED and HI-ALLOC is good enough to obtain space data. [...] 5682 28 23_Partitioning key update11_Ball Robert24_roball@WOOLWORTHS.COM.AU31_Tue, 23 Apr 2002 18:27:31 +1000593_- DB2 UDB for OS/390 V610. We want to update a column which is part of the key in a partitioning index but the catalog details for this column in SYSIBM.SYSCOLUMNS are preventing it (UPDATE = N). We have PARTKEYU=YES in our DSNZPARM but this doesn't seem to do much for existing tables, APAR PQ16946 states : NOTICE regarding EXISTING TABLES: Updating partitioning keys will now be allowed for tables created AFTER application of this APAR. Existing tables must be re-created after application of this APAR. The table was defined under DB2 V4 and has not been dropped or recreated since. [...] 5711 40 68_Ang: [DB2-L] automated updates to DB2 for OS/390 through DB2 Connect14_Lennart Henang25_lennart.henang@FOLKSAM.SE31_Tue, 23 Apr 2002 11:36:18 +0200641_iso-8859-1

If you're running on Unix box, the simplest solution is to develop some scripts that you run on a cron schedule. (Cron is a standard Unix feature).

In the windows environment, there is a built-in similar functionality - but not as useful and versatile as cron. Therefore there are many software packages available that will do the same work as cron. Look in download.com to find a "task scheduler". One example I've been using is Windows Scheduler to be found at http://www.splinterware.com/products/wincron.htm. Another example (I haven't tested it) is WinCron that can be found on http://www.wincron.co.uk/. [...] 5752 52 23_Parititioning key value6_GV DBA16_gv_db2@YAHOO.COM31_Tue, 23 Apr 2002 03:11:47 -0700399_us-ascii

Hi Dear Listers,

Here one of our user has a requirement that a tablespace to be partitioned based on the 11th character of a char(12) field.

Ex: There is 12 character field POLICY_NO in a table.

Now can we partition this table(space) based on 11th character of POLICY_NO? ("0" & "5" should go to partition 1, "1" & "6" should go to partition 2 and so on). [...] 5805 49 46_Re: connecting to distributed data base system14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Tue, 23 Apr 2002 11:06:24 +0200455_- Hello,

I don't know, if someone answered already to this.

For remote access with DSNTEP2, you have to have the same package (DSN@EP2L) at the remote and at the local site, with the same timestamps.

So you would have to do a BIND on the remote subsys with the same DBRM. Or, you could use the BIND with keyword COPY to copy the package from the local subsys to the remote subsys. Please read the manuals for the correct syntax. [...] 5855 70 27_AW: Partitioning key update41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Tue, 23 Apr 2002 12:46:36 +0200478_iso-8859-1 Hi Robert,

we're still on V5 and yet I'm pretty certain that the APAR still applies only to tablespaces created after the introduction of this APAR; you are aware however that you might get into serious trouble when allowing updates on partitioning keys? We set PARTKEYU to SAME and haven't had any trouble since. You might want to check the archives for more details. Search for CDRN in the title of the message and you'll find the problems we once had. [...] 5926 74 27_Re: Parititioning key value11_David Nance16_DWNance@FHSC.COM31_Tue, 23 Apr 2002 07:43:25 -0400557_US-ASCII GV, I don't know of any way to do it without adding of another column. Why would/does it concern your customer that the column is being added? The only time they would be affected by the addition is in the process that does the initial insert. Though, there is a problem with your proposed partitioning scheme. Here it is straight from the SQL Reference book Create Index section. "The highest value of the key in any partition must be lower than the highest value of the key in the next partition". In other words, if you define the value on [...] 6001 78 24_Re: High cpu in IEAVRT058_Ron Root24_ron.root@CPA.STATE.TX.US31_Tue, 23 Apr 2002 07:18:44 -0500464_iso-8859-1 Andre, We are running with accounting traces because of our monitor. It has been suggested this may be the issue. I am in the process of running benchmarks with & without the accounting traces.

Thanks for the suggestion.

Ron

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Bajew, Andre Sent: Monday, April 22, 2002 3:15 PM To: DB2-L@RYCI.COM Subject: Re: High cpu in IEAVRT05 [...] 6080 38 27_Re: Parititioning key value14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Tue, 23 Apr 2002 07:25:53 -0500613_iso-8859-1 GV,

why is your user concerning himself with how the data is partitioned ?

Partitioning is a physical design consideration, usually implemented to allow parallelism, speed up utilities or physically spread the data across devices. This is typically a decision made by the application developer and the DBA.

In my experience, the choice of partitioning key has usually been based on balancing the partition sizes and not related to any meaning in the key - I would suggest going back to the logical design to see why the 11th digit of 12 has a meaning all by itself. Should it [...] 6119 69 26_Re: Partitioning key value14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 23 Apr 2002 14:18:37 +0100335_iso-8859-1 If you are on V6 or later, then you WILL need a "partitioning" column, but this could be populated by an AFTER INSERT trigger making the process totally application transparent.

As David points out, your partitioning column will have to contain values "1" through "5" and be allocated by the trigger accordingly [...] 6189 37 31_Re: Certification (514 and 516)13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 23 Apr 2002 08:21:26 -0500637_iso-8859-1 I'd suggest the certification books: DB2 Universal Database for OS/390 Version 7.1 Certification Guide by Yevich & Lawson and DB2 Universal Database 7.1 Database Adminstration Certification Guide by Baklarz & Wong. Both can be found at Barnes & Noble, Amazon, etc.

> -----Original Message----- > From: V K [mailto:tech@GBRONLINE.COM] > Sent: Monday, April 22, 2002 5:03 PM > To: DB2-L@RYCI.COM > Subject: Certification (514 and 516) > > > Thank you group for your suggestions and advices regarding DB2 FAMILY > FUNDAMENTALS exam, I passed it succesfully. I am planning to > take 514 and > 516, any suggestions and [...] 6227 121 27_Re: Parititioning key value15_Shields Michael28_ShieldsMichael@JOHNDEERE.COM31_Tue, 23 Apr 2002 08:28:57 -0500553_iso-8859-1 I'm wondering why you're partitioning. Is it for size of the db or volume (number of inserts) or both? We were going to partition one of our tables to help with multi-threading... basically preventing the hot-spot insert at the end of the table, but our DBAs weren't crazy about the idea due to maintenence concerns/specialization of jobs, etc. Via weekly reorgs and free space settings we will be able to use the following strategy to serve the purpose of inserting to different physical areas of the db. Cluster Index on (Col1, Col2). [...] 6349 61 76_Re: Looking for feedback on SMS groups, extended addressability, DB2 objects11_James Drewe20_james.drewe@AEXP.COM31_Tue, 23 Apr 2002 08:01:58 -0700405_iso-8859-1 Doreen

We are on DB2 OS/390 Version 6 and are just starting to use >4G objects in test. They won't be entering production until probably September. I discussed the issue with our storage management group and they are using SMS/ACS routines based on the dataset mask I provided to isolate the disk pools. The reason they gave to isolate EA datasets was efficiencies in disk storage. [...] 6411 97 23_Re: Shortcut for DB2 PM0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 23 Apr 2002 10:23:58 -0500465_us-ascii Hello.

This worked! (When I gave it a different name. It seems something is already out there under "DB2PM" that gives me blank lines.)

Thanks. (For all of the other suggestions as well.)

Stg







Ben Dissen @RYCI.COM> on 04/22/2002 04:56:12 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 6509 31 26_Re: -913 / Timeout problem0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 23 Apr 2002 10:33:55 -0500405_us-ascii Hello James,

Thank you for your insight. Here are the answers to your questions:

>>- does the SP return the results of the FETCH/UPDATE to the caller?

Yes.

>> - can you ignore failed txns?

Nope. It provides the key we use to store the records created by the process that called the SP. But I can code "retry" logic in the SP. (I'm luke-warm on that idea.) [...] 6541 13 30_Re: Load with CSV on OS/390 v712_Roger Miller19_millerrl@US.IBM.COM31_Tue, 23 Apr 2002 10:14:30 -0500371_- As usual, we say what we do, and not what we don't. For comma separated values, we don't yet.

Roger Miller, DB2 for z/OS

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6555 17 24_Re: High cpu in IEAVRT0512_Roger Miller19_millerrl@US.IBM.COM31_Tue, 23 Apr 2002 10:27:26 -0500303_- Do you have SMF type 89 recording on? If so, turn it off. To paste from the Administration Guide:

If you have very light DB2 usage and you are using Measured Usage, then you need the SMF 89 records. In other situations, be sure that SMF 89 records are not recorded to avoid this overhead. [...] 6573 25 26_Re: -913 / Timeout problem12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 23 Apr 2002 10:49:26 -0500508_- V7 has had the function for a year and the ability to COMMIT in a stored procedure is not in a V6 APAR.

For your hot spot, what percentage of the time is it locked? Sometimes I've used nominal figures, such as average transaction time of 200 ms, with a lock hold time of about 100 ms. If five trans get this one lock in a second, then the lock hold time is about 500 ms or 50% of the time, you will be seeing lock suspensions. That elongates the transaction and lock hold time, and we are on a [...] 6599 43 26_Re: -913 / Timeout problem7_DB2 DBA21_db2_dba@BELLSOUTH.NET31_Tue, 23 Apr 2002 12:18:51 -0400616_ISO-8859-1 The use of "control tables" brings a few words like deadlock, timeout, contention and bottlenect to mind. They usually work fine as long as your environment does not get stressed. Have you considered using an identity column to get your number assigned. This would even eliminate the stored procedure if its only purpose is providing the application with the next number. > > From: Steve_Grimes@AISMAIL.WUSTL.EDU > Date: 2002/04/23 Tue AM 11:33:55 EDT > To: DB2-L@RYCI.COM > Subject: Re: -913 / Timeout problem > > Hello James, > > Thank you for your insight. Here are the answers to your questions: [...] 6643 68 44_Enhance release MTK - Conversion Tool to DB213_Martin Spratt18_sprattm@US.IBM.COM31_Tue, 23 Apr 2002 11:19:57 -0500434_iso-8859-1 DB2 COMMUNITY ANNOUNCEMENT:

The third public beta release of the IBM DB2 Migration Toolkit is now available!

http://www.ibm.com/software/data/db2/migration/mtk/

IBM internal users, you can ensure you have the latest version by clicking 'About' in the Help menu. If the build number is not 020326.1724, you'll want to get this update.

The refresh contains the following additional features: [...] 6712 56 50_Using LDAP (IBM Secure Way) with DB2 UDB EE on AIX20_Sitaram Vijay kartik21_vijaykartik@YAHOO.COM31_Tue, 23 Apr 2002 09:32:23 -0700371_us-ascii Hi all:

This is a setup using LDAP authentication for DB2 UDB databases which is new to me. I am confused and not certain on what needs to be done on Box A and Box B to get authentication go through LDAP.

AIX Box A: IBM Secure Way, DB2 UDB EE Server. AIX Box B: IBM Secure Way Client, DB2 UDB EE Server installed with instances and databases. [...] 6769 46 30_Re: Load with CSV on OS/390 v714_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Tue, 23 Apr 2002 18:33:48 +0200389_- I am working on a program that can load CSV-Files into DB2 (and ORACLE) tables. The basic idea is as follows:

you specify an insert/update/delete statement with host variables in it. This statement is dynamically prepared and the host variables are filled with the contents of the CSV file. You can specify, which position of the CSV file corresponds to which host variable. [...] 6816 44 50_Reorg utility options (SORTDATA NOSYSREC SORTKEYS)14_Mark McCormack27_mamccormack@STATESTREET.COM31_Tue, 23 Apr 2002 12:56:00 -0400562_us-ascii Christophe,

You might be cautious about SORTDATA, NOSYSREC, and SORTKEYS on big tablespaces (and the definition of big will vary from one installation to another).

disclaimer: I am currently a user of the IBM reorg utility. You indicate that you use Platinum. I assume they are similar in this area.

SORTDATA allows the unload operation to go quicker. On a really large tablespace (many rows, long row length), there is a possibility that you may not be able to handle such a big sort. I recommend you use it if you can. I do. [...] 6861 32 76_Re: Looking for feedback on SMS groups, extended addressability, DB2 objects0_19_Tim.Lowe@STPAUL.COM31_Tue, 23 Apr 2002 12:00:23 -0500420_us-ascii James, One of the things mentioned at the last DB2 Technical conference for the next DB2 release was more support for SMS constructs in DB2 objects. I took that to mean support in stogroups for SMS dataclas, mgmtclas and storclas. So, I have hope that they may already be looking at fixing the problem that you describe. But, nobody knows what will eventually emerge until it gets to general availability. [...] 6894 50 46_Re: DB2 tablespace size - or why run STOSPACE?13_Davis, Ronald17_DavisRo@CONED.COM31_Tue, 23 Apr 2002 13:01:30 -0400587_iso-8859-1 Max - can I get a copy of that Rexx exec?

-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: Tuesday, April 23, 2002 4:03 AM To: DB2-L@RYCI.COM Subject: Re: DB2 tablespace size - or why run STOSPACE?



Hi Mike

I NEVER run STOSPACE. It's an utility (even if it's not a macho utility) and I don't like to add more infos to catalog when I can obtain space infos from SMS reports or IDCAMS LISTCAT. I don't like to run query that I don't need. And sometimes results are wrong as far as I can hear. I found that HI-USED and [...] 6945 47 26_Re: -913 / Timeout problem14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Tue, 23 Apr 2002 18:51:42 +0200310_- With DB2 versions prior to 6, you don't have identity columns. Our approach is as follows: we do an UPDATE

UPDATE ttable SET number = number + 1 WHERE key = 'key-of-number';

immediately followed by a select to retrieve the number and then commit. So there is no (long) lock on the ttable. [...] 6993 21 29_DB2v6 on z800 box and ZOS 1.311_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 23 Apr 2002 10:27:59 -0700536_iso-8859-1 Hi all, we are in the process of buying a z800 box (2066-001) and looking to go to zos 1.3 (1.4?).

Does anyone have any interesting tails to tell about DB2v6 running on a z800 or zos?? Also any of your peripheral DB2 products ie. Platinum, Tmondb etc.?

thanks, cliff:-)

================================================ 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. 7015 42 24_Re: High cpu in IEAVRT058_Ron Root24_ron.root@CPA.STATE.TX.US31_Tue, 23 Apr 2002 13:57:58 -0500430_iso-8859-1 Roger, Thanks for the information. Yes, we are recording type 89 records.

Ron Root

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Roger Miller Sent: Tuesday, April 23, 2002 10:27 AM To: DB2-L@RYCI.COM Subject: Re: High cpu in IEAVRT05



Do you have SMF type 89 recording on? If so, turn it off. To paste from the Administration Guide: [...] 7058 41 33_Re: DB2v6 on z800 box and ZOS 1.314_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 23 Apr 2002 15:41:51 -0400334_ISO-8859-1 Cliff,

There aren't any problems running on a Z800 machine. However, depending on what you are planning to run.... may be an issue on this specific machine. It has only ONE CPU engine. If you have a busy workload, you may have contention for the CPU.

Amdahl's Law - All processors wait at the same speed [...] 7100 116 26_Re: high service wait time16_Alison Pelletier17_ap84098@YAHOO.COM31_Tue, 23 Apr 2002 12:52:43 -0700571_us-ascii Dr. Ebert,

Thank you very much for your reply. I will check ZPARMS. This is vendor product and yes, I agree, reorg every night IS excessive. I plan to remedy that. The TS that is inserted/updated with this trans. is 50K cyl. with 128 partitions. The part./cluster key is NOT seq., which I believe could be helpful with no freespace, but I have to look at rest of SQL to make sure clustering can change. Freespace is 22%. Commits are taking place at end of trans. which avg. 1.25 inserts/updates per trans. It is bound w/release commit, if that gives [...] 7217 44 26_Re: -913 / Timeout problem0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 23 Apr 2002 15:09:08 -0500589_us-ascii Hello,

Thank you again for the suggestions.

I'm not sure how to determine the "average transaction" and "lock suspension" times. We've had DB2PM up for about a month, and I've been in it about 3 times. Any tips?

As for the IDENT column -- this is a strong contender. When my collegue returns from vacation we'll be taking a serious look at that. We discussed it before, but discounted it for reasons I cannot recall. (Perhaps because we didn't know the "value" and the SP needs to return the value to the calling pgm (in the current design.) The primary [...] 7262 59 24_Re: High cpu in IEAVRT0513_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Tue, 23 Apr 2002 15:29:10 -0500391_iso-8859-1 Sorry, I came it at the tail end of this. We also have monitor and accounting traces going on all our systems. And we are not excluding SMF type89 records. I'm surprised this hasn't been noticed before. We had some IBM performance people on site strobing our DB2 apps several years ago. However, I'm not sure what the relationship between IEAVRT05 and SMF type89 records is. [...] 7322 113 24_Re: High cpu in IEAVRT0512_Bajew, Andre25_Andre.Bajew@COMPUWARE.COM31_Tue, 23 Apr 2002 17:11:11 -0400591_iso-8859-1 Hi Jeremiah,

IBM said it better than I could have. Out of IBMlink:

DB2 Accouting Trace Class 2 will cut an IFCID 121 record when DB2 is entered from an application and an IFCID 122 record when DB2 completes processing and returns control to the calling application. In each case, the IFCID 121 and IFCID 122 records are followed by a call to Timer Supervisor module IEAVRT05 for a timestamp. This results in the High CPU usage seen in IEAVRT05. Specifically, a program executing a large number of SQL statements, either a singleton SELECT (or DML) in a DO LOOP [...] 7436 67 26_Re: -913 / Timeout problem15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 23 Apr 2002 17:46:06 -0400278_- Due to the contention on primary key generation, we used a range for each program. Once the range is over, we go and grab a new range from the original row. This way the number of time we update the original row is every less and we have row level locking on this table. [...] 7504 44 30_Re: Load with CSV on OS/390 v713_Bright, Randy20_Randy_Bright@BMC.COM31_Tue, 23 Apr 2002 16:45:14 -0500393_iso-8859-1 If you have the latest version of LoadPlus for DB2 (V6.1.00) from BMC Software, Inc., it will load data from what is commonly known as a "CSV" or comma delimited file. If you have V5.1.00 of LoadPlus, this feature can be activated by a ZAP if you want. LoadPlus V5.1.00 CSV support will run on V4, V5, and V6 or DB2. LoadPlus V6.1.00 will support CSV on V5, V6, and V7 of DB2. [...] 7549 59 33_Re: DB2v6 on z800 box and ZOS 1.312_Raymond Bell17_rbell@NZ1.IBM.COM31_Wed, 24 Apr 2002 09:47:24 +1200480_us-ascii Hi Cliff,

Saw Joel's note about the potential issue of your z800 having only one CP. We're thinking about upgrading to a z800 box, but apparently one with 4 CPs. The issue that immediately springs to mind is ISV software licence fees. Someone said each engine in this proposed box is around 180 MIPS, which is a bit more than our current box. Someone here is going to look into what, if any, increase in fees we'd be looking at. Might be an issue, might not. [...] 7609 70 76_Re: Looking for feedback on SMS groups, extended addressability, DB2 objects12_Raymond Bell17_rbell@NZ1.IBM.COM31_Wed, 24 Apr 2002 09:51:41 +1200549_us-ascii Hi Jim,

We're not DB2 V6 here, but were at the last site I was at where I had a play with EA-enabled datasets. I'm pretty sure the tablespaces/indexes we had that were large (DSSIZE 32) we stogroup-defined. Like you, I don't like VCAT-defined objects - pain in the arse, esp. for utilities - so I try to avoid them at all cost. I vaguely remember having a separate SMS management (I think) class to govern the datasets, which was filtered by dataset name (not DB2 stogroup), but the TS/IXs themselves were DB2 stogroup defined. [...] 7680 101 52_Fwd: PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!12_Phil Gunning17_db2jock@YAHOO.COM31_Tue, 23 Apr 2002 15:21:53 -0700487_us-ascii Dear Subscribers, I want to inform you of the movement of the list from RYCI.COM to YLASSOC.COM. This move is being made because it is a logical progression and the fact that RYC Inc. will cease to exist. Please refer to Susan's note below. We will strive to make this as smooth a transition as possible. Please be patient if we run into some speed bumps. You can contact me or the other list owners if an outage occurs or if you have questions or problems. Regards, Phil. [...] 7782 86 43_Remote Admin Client to DB2 UDB V7.2 on UNIX0_19_csutfin@AMSOUTH.COM31_Tue, 23 Apr 2002 18:22:05 -0500387_us-ascii I know that some of our UNIX/UDB/EEE guru's can help me here. It's late in the day and I have been attempting to get to my TEST database on UNIX all day. I can get to the production version, no problems.

When I use the CCA to configure the database connection, I get all the way through and get the nice message of "Connection configuration was added successfully". [...] 7869 20 47_Reg Munusamy/PIP/GGEN/GIO is out of the office.12_Reg Munusamy20_rmunusamy@GIO.COM.AU31_Wed, 24 Apr 2002 09:18:37 +1000457_us-ascii I will be out of the office from 04/22/2002 until 04/29/2002.

I will respond to your message when I return.

The content of this e-mail, including attachments is a confidential communication between the sender and the intended addressee. Any unauthorised use of the contents is expressly prohibited. If you have received this e-mail in error please contact the sender immediately and then delete the message and any attachment(s) [...] 7890 40 26_Re: Strange join sequence?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 24 Apr 2002 10:37:50 +1000344_US-ASCII Claude

That recommendation is based on DB2 giving a very small weighting based on the order of tables. There used to be a similar one for the order of predicates in the WHERE clause (even down to repeating desired predicates because DB2 was, then, not smart enough to recognise that the repeated predicate was superflous). [...] 7931 44 26_DB2 Application Conversion14_Randall Ibbott22_randall.ibbott@QBE.COM31_Wed, 24 Apr 2002 10:39:28 +1000564_us-ascii Guys,

We have an OLTP CICS application running on OS/390 that uses a network database (SUPRA) that we want to convert to DB2. One of the requirements to the conversion is (obviously) to reuse of as much application code as possible. The SUPRA database is quite large and a conversion of all the data at once doesn't have much appeal, so we are investigating a staged approach. This raises recovery questions with regard to updates within a single unit of recovery that span SUPRA and DB2 - as DB2 supports two phase commit, but SUPRA doesn't. [...] 7976 75 27_Re: Partitioning key update31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Wed, 24 Apr 2002 02:10:37 +0100603_iso-8859-1 Why not write a generic REXX or any other code to DELETE/INSERT the records if you do not want to drop/recreate the tables.

You need to take the help of SYSIBM.SYSCOLUMNS to take the column names/numbers and data type.

With Best Regards, Sanjeev



--- Ball Robert wrote: > DB2 UDB for OS/390 V610. > We want to update a column which is part of the key > in a partitioning index > but the catalog details for this column in > SYSIBM.SYSCOLUMNS are preventing > it (UPDATE = N). We have PARTKEYU=YES in our > DSNZPARM but this doesn't [...] 8052 34 18_ole db2 connection11_Barry Noble17_bdnoble@YAHOO.COM31_Tue, 23 Apr 2002 18:25:27 -0700389_us-ascii Hello all,

I'm trying to use SQL servers DTS to join a table from SQL Server to a table on DB2 mvs (using db2 connect as the middleware). Has anyone been able to do this. In our case, it appears that all of the mvs data is being selected an sent down to SQL Server where it is doing the join. Unfortunately, the MVS table is very large with 100's of millions of rows. [...] 8087 95 50_Deletes, inserts and reuse of space in a partition9_Ray Janes17_rhjanes@ATTBI.COM31_Tue, 23 Apr 2002 21:22:37 -0500386_iso-8859-1 Hi all, We have a recurring question and have different interpretations of the IBM book. We are Version 7 DB2 on MVS large mainframe, datashareing etc. We are planning on a 254 partitioned tablespace. We will load a partition per night. The old data will be discarded. If we use DB2 Load, will the space be reused if we issue Load Replace Reuse? How about Load Replace? [...] 8183 28 26_MF DB2 SP Display Question12_Kosin, Chuck24_chuck.kosin@EXPERIAN.COM31_Tue, 23 Apr 2002 21:39:11 -0700422_iso-8859-1 At times, the MF DB2 SP display command assigns the value of "-1" to the Active column at our shop. Could anyone explain why?

DSNX940I =DB1E DSNX9DIS DISPLAY PROCEDURE REPORT FOLLOWS - ------- SCHEMA=CUSTMST3 PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV GETDATABYSINPREAM STARTED -1 0 0 0 DSNX9DIS DISPLAY PROCEDURE REPORT COMPLETE DSN9022I =DB1E DSNX9COM '-DISPLAY PROC' NORMAL COMPLETION [...] 8212 72 15_Re: Admin tools9_Ali Akbar25_ali.akbar@CRESSOFT.COM.PK31_Wed, 24 Apr 2002 11:50:49 +0500630_us-ascii





I have tried Embaracadero's DBAstisan and a few others ... But i find BMC SQL-Programmer best in all the departments. Try It !

http://www.bmc.com/solutions/database/sqlprogrammerOOW_1201/













"Martin V." on 04/22/2002 06:16:45 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Ali Akbar/CresSoft)

Subject: Admin tools





Hello,

Is anyone here using 3rd party admin tools like Embarcadero's DBArtisan to manage DB2 UDB? [...] 8285 20 76_Re: Looking for feedback on SMS groups, extended addressability, DB2 objects10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Apr 2002 09:48:40 +0200 8306 100 71_Repeatedly error in Syslog : probe id 1 with error 2055 and alert num 012_Peter Horner27_peter.horner@JULIUSBAER.COM31_Wed, 24 Apr 2002 10:17:40 +0200355_us-ascii Dear List

I run DB2 EE V7.2 Fixpack5 on Solaris 8 on my local machine an Ultra10 and also on an E450 with 4 processors. Repeatedly but not regularly (sometimes once or twice a day) i get the following error message in /var/adm/messages (syslogd) Can you explain where this error message comes from, their meaning and how to avoid it? [...] 8407 56 30_Re: MF DB2 SP Display Question14_Peter Schwarcz23_schwarcz@BIGPOND.NET.AU31_Wed, 24 Apr 2002 19:01:31 +1000412_iso-8859-1 There is an APAR against DB2 Version 6 and 7 that would appear to describe your problem PQ56591

PROBLEM DESCRIPTION: DB2 command -DISPLAY PROCEDURE shows a negative number in the "ACTIVE" or "QUED" columns of the display output.

Check if you have the following PTF's

PTF List: Release 610 : UQ62568 available 02/02/22 (F202 ) Release 710 : UQ62569 available 02/02/22 (F202 ) [...] 8464 173 54_Re: Deletes, inserts and reuse of space in a partition0_18_mebert@AMADEUS.NET31_Wed, 24 Apr 2002 10:58:52 +0200602_us-ascii Hi Ray,

we have a somewhat similar design here. From your specifications, a partition will be around 8GB, which is quite a monster. Let's summarise the options:

SQL DELETE: The operation is logged, so it produces around 8GBs of logging. If you issue a single DELETE ...WHERE IDPART=.., the partition will be unavailable. So you need a SELECT Cursor WITH HOLD FOR UPDATE OF, and issue a DELETE WHERE CURRENT OF... for each row, with COMMITs every few 1000 rows or so - complicated (I haven't looked up the exact syntax). Then the data will be available for other jobs/users. [...] 8638 11 54_Re: How to know the current "CURRENT RULES" register ?17_Christophe Radier17_c300501@YAHOO.COM31_Wed, 24 Apr 2002 04:38:47 -0500263_- Thank you very much

================================================ 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. 8650 41 51_Distributed applications, authorizations and commit19_Calleja Vilar, Juan22_jcallejav@IBERDROLA.ES31_Wed, 24 Apr 2002 13:15:52 +0200403_iso-8859-1 Hello list.

We are developing a Visual Basic distributed application accesing DB2 OS/390 through DB2 Connect. We would like to prevent users from updating tables in DB2, but the application needs to update the data. We think that the solution is grant programs instead of users. The question is: how can we make a Visual Basic STATIC application accessing data in DB2 for OS/390? [...] 8692 24 11_DB2 and WLM15_Thomas Karlsson19_thkar97@HOTMAIL.COM31_Wed, 24 Apr 2002 12:17:12 +0000554_- Hi! ----------- Does it exist any good book(redbook) how you could set up db2 on OS390/ZOS.

Right now we just have it on the STC.

/Thomas





_________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.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. 8717 185 54_Re: Deletes, inserts and reuse of space in a partition0_20_Gerhard.Heiss@RUV.DE31_Wed, 24 Apr 2002 14:27:51 +0200372_iso-8859-1 Hi Ray,

just one more point, in addition to what Dr. Ebert said: be extremely careful to put the REPLACE keyword into the correct position:

LOAD DATA INDDN(SYSREC00) LOG(NO) INTO TABLE yourtable PART x REPLACE is okay. Part x is replaced, the others remain as before, but LOAD DATA INDDN(SYSREC00) LOG(NO) REPLACE INTO TABLE yourtable PART x [...] 8903 16 32_Question on dataset size limits.13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Wed, 24 Apr 2002 07:47:02 -0500582_iso-8859-1 We noticed something on the size of a couple of our partitioned datasets that I wanted to see if anyone could explain... We have a tablespace defined as 254 partitions. It was not defined using the DSSIZE parameter, so my take on the IBM manuals says the dataset should be limited to 4 Gig. However, when I look at one of the partitions in this tablespace it is taking 5,386 cylinders, which according to my calculations comes out to just over 4.2 Gig. After checking the manuals, I found the following statement in the SQL reference (under create tablespace, after [...] 8920 33 55_Re: Distributed applications, authorizations and commit11_Daniel Adam16_dadam@GRATEX.COM31_Wed, 24 Apr 2002 07:03:11 -0500348_ISO-8859-1 Hi,

>We would like to prevent users from updating tables in DB2, but the >application needs to update the data. We think that the solution is grant >programs instead of users. The question is: how can we make a Visual Basic >STATIC application accessing data in DB2 for OS/390?

How about using the stored procedures ? [...] 8954 34 66_Error handling in SQL Stored Procedure, keep sqlcode. DB2 V7 OS39029_H=?ISO-8859-1?Q?=E5kan?= Roll18_hakan.roll@EDS.COM31_Wed, 24 Apr 2002 07:20:28 -0500308_ISO-8859-1 2 questions regarding error handlers:

#1) I would like to have a block of code in a handler without changing value of SQLCODE is that possible?

According to examples in manuals, "IF 1=1" method can be used to have a block of code in a handler, but it destroys value of SQLCODE. [...] 8989 17 36_Re: Question on dataset size limits.14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Wed, 24 Apr 2002 08:05:41 -0500404_iso-8859-1 Mike,

5386 cylinders will equate to 3877920 KB (3.7 GB)- you get approximately 720 KB per cylinder (48 KB per track = 12 4KB pages)

Colin

================================================ 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. 9007 18 15_Re: DB2 and WLM14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Wed, 24 Apr 2002 08:21:46 -0500456_iso-8859-1 Thomas,

have a look at 'OS/390 Workload Manager Implementation and Exploitation' and 'Getting Started with DB2 Stored Procedures:..'. You can find them on http://www.redbooks.ibm.com/

Colin

================================================ 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. 9026 106 33_Re: DB2v6 on z800 box and ZOS 1.312_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Wed, 24 Apr 2002 08:34:54 -0500268_us-ascii We are looking at the z800 as well. From my understanding it ships with 4 CP. However, depending on what level of mips you bought then depends on what number of CPs are activated. I think it is one CP up to 192 mips. They have revised the 180 number up. [...] 9133 58 58_REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!12_Susan Lawson24_susan_lawson@YLASSOC.COM31_Wed, 24 Apr 2002 08:55:11 -0500401_us-ascii Don't forget....this move occurs tonight at 6pm CST. After this you will need to send/receive mails for the list at DB2-L@listserv.ylassoc.com

Regards, Susan Lawson

-----Original Message----- From: Susan Lawson [mailto:susan_lawson@ylassoc.com] Sent: Monday, April 22, 2002 4:54 PM To: DB2 Data Base Discussion List Subject: PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY! [...] 9192 25 75_Re: How to do Error handling in SQL SP when wrong packageset used. V7 OS39029_H=?ISO-8859-1?Q?=E5kan?= Roll18_hakan.roll@EDS.COM31_Wed, 24 Apr 2002 08:23:19 -0500604_ISO-8859-1 Thank you for your answer!

PTF is now applied, and handler user_sqlcode=sqlcode returns -805.

But it does only solve one of my problems, is it possible to have handler calling an error_proc instead of returning a output variable?

When call error-routine in my handler the error-routine does not fiere,

Best Regards Håkan Roll

===============================================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. 9218 95 26_Re: high service wait time0_18_mebert@AMADEUS.NET31_Wed, 24 Apr 2002 16:36:06 +0200634_us-ascii I was thinking that a COMMIT requires the transaction to wait until the log records are written to disk (a Synch I/O). Your Insert/Update rate isn't so high that more than one COMMIT is likely to be processed in one go. 38 ms, as in your case, sounds excessive for modern HW but not drastically so. Check your log datasets: are LOGCOPY1.* and LOGCOPY2.* on different disks (absolutely necessary normally; not sure about PAV), different channels (preferable), and different disk hardware (desirable)? If not, then separating them might halve your wait time. Having successive Log datasets (DS01, DS02,...) on alternating [...] 9314 46 62_Re: REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!0_18_mebert@AMADEUS.NET31_Wed, 24 Apr 2002 16:38:06 +0200252_us-ascii How much is that in UTC?

MfG, ME.





Don't forget....this move occurs tonight at 6pm CST. After this you will need to send/receive mails for the list at DB2-L@listserv.ylassoc.com

Regards, Susan Lawson

9361 90 75_Re: How to do Error handling in SQL SP when wrong packageset used. V7 OS39029_H=?ISO-8859-1?Q?=E5kan?= Roll18_hakan.roll@EDS.COM31_Wed, 24 Apr 2002 09:21:42 -0500471_ISO-8859-1 Thank you for your answer!

PTF is now applied, and handler user_sqlcode=sqlcode returns -805.

But it does only solve one of my problems, is it possible to have handler calling an error_proc instead of returning a output variable?

When call error-routine in my handler the error-routine does not fiere,

Best Regards Håkan Roll



On Fri, 19 Apr 2002 13:55:44 +1000, James Campbell wrote: [...] 9452 13 26_Re: high service wait time0_26_truman.g.brown@VERIZON.COM31_Wed, 24 Apr 2002 10:55:38 -0400332_us-ascii COMMIT requires the log record to be written, not the DB2 object written to disk.

================================================ 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. 9466 53 36_Re: Question on dataset size limits.10_Dale Smock20_Dale.Smock@BMSUS.COM31_Wed, 24 Apr 2002 10:03:06 -0500499_iso-8859-1 Do a Listcat on the vsam dataset and compare the HI-A-RBA value to HI-U-RBA (high allocated rba vs high used rba). Since allocations are rounded up to the next cylinder, there can be a small difference. If it's significant, you are over allocated and wasting cylinders.

Dale Smock BMG

-----Original Message----- From: Vaughan, Mike [mailto:Vaughan.Mike@PRINCIPAL.COM] Sent: Wednesday, April 24, 2002 7:47 AM To: DB2-L@RYCI.COM Subject: Question on dataset size limits. [...] 9520 59 18_Re: DB2 DBA Wanted17_Bruzdzinski, Mike24_Mike.Bruzdzinski@SSA.GOV31_Wed, 24 Apr 2002 11:08:45 -0400546_iso-8859-1 I have to agree wholeheartedly concerning Ms. KAtheryn Sears.

Though my particular experience did not work out, MS. Sears is very professional in her conduct and approach.

Michael Bruzdzinski SSA

-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Monday, April 22, 2002 1:32 PM To: DB2-L@RYCI.COM Subject: Re: DB2 DBA Wanted



Kathryn Sears posted a *very* real job to this group about a month ago. I verified the job by seeing it on the emoloyer's website. [...] 9580 76 62_Re: REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 24 Apr 2002 11:11:21 -0400540_iso-8859-1 I believe that's midnight, or 12:00 am, or 00:00 or 7:30 in Newfoundland.

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@compuware.com









The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. 9657 59 62_Re: REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Wed, 24 Apr 2002 11:07:35 -0400564_us-ascii

http://www.timeanddate.com/







mebert@AMADEUS.NET on 04/24/2002 10:38:06 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!





How much is that in UTC?

MfG, ME.





Don't forget....this move occurs tonight at 6pm CST. After this you will need to send/receive mails for the list at DB2-L@listserv.ylassoc.com [...] 9717 43 26_Re: -913 / Timeout problem0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 24 Apr 2002 10:25:22 -0500451_us-ascii Thanks Sibi!

I'm adding that idea to the list. We do that for other control values -- I'm not sure why I didn't think of it for this one.

Stg







"Philip, Sibimon" @RYCI.COM> on 04/23/2002 04:46:06 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: [...] 9761 39 26_Re: high service wait time0_18_mebert@AMADEUS.NET31_Wed, 24 Apr 2002 17:34:41 +0200137_us-ascii Yes. So?

MfG, ME



COMMIT requires the log record to be written, not the DB2 object written to disk.

9801 38 62_Re: REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!12_Susan Lawson22_lawson_susan@YAHOO.COM31_Wed, 24 Apr 2002 08:45:52 -0700329_us-ascii All,

Please stop subscribing to the new list server. It is not necessary. The current files will be copied this evening during the switch. Any subscribing you do now will be lost during the switch.

Also, please wait until after the switch to do any changes to your profiles or send any test messages. [...] 9840 62 36_Re: Question on dataset size limits.9_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 24 Apr 2002 10:13:47 -0600285_us-ascii Last week we had a similar situation tied to a load job, but did get a DSNP007I, RC=00D70014, extend failed on one partition that was being loaded due to reaching 251 extents. The odd thing is that partition was already over the 4gig limit when it got this extent error. [...] 9903 57 62_Re: REMINIDER- PLEASE READ - URGENT - DB2L - MOVING WEDNESDAY!14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM31_Wed, 24 Apr 2002 11:07:37 -0500319_us-ascii As of early April, the U.S. is mostly on "Daylight Savings Time" until late October, so Susan probably meant CDT instead of CST.

CDT is 5 hours behind GMT. (CST would be 6 hours behind GMT.) The move is therefore scheduled for 23:00 GMT today, or midnight GMT if I'm incorrect about her statement. [...] 9961 44 12_Re: z800 box14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 24 Apr 2002 12:14:48 -0400467_ISO-8859-1 The number of CP engines determines the number of mips, not vice versa. All models that end with a "1" have only one CP. If you have two engines you do not get twice the number of mips. For examle, taking the 001 machine below and adding a CP to make it a 002 machine only increases the mip rating to 350... not 385. The industry average mips (meaningless indicator of processor speed) ratings for the machines are: 0A1 80 0B1 115 0C1 142.5 001 192.5 [...] 10006 38 72_Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Wed, 24 Apr 2002 11:24:01 -0500395_iso-8859-1 Hi,

Was wondering if anybody had implemented a smarter way of doing Runstats based on actual changes happening on the tablespaces. There is any trace which can be activated to find out what had changed and doing runstats for those tablespaces only.Any body has any information How to go about implementing it ? We are at Version 6 and will be moving to Version 7 in June. [...] 10045 60 36_Re: Question on dataset size limits.9_Dave Will26_david.e.e.will@VERIZON.COM31_Wed, 24 Apr 2002 12:29:30 -0400722_us-ascii Mike,

I figure on roughly 5,824 cyls to had 4 Gig of DB2 data.

Dave







"Vaughan, Mike" @RYCI.COM> on 04/24/2002 08:47:02 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Question on dataset size limits.



We noticed something on the size of a couple of our partitioned datasets that I wanted to see if anyone could explain... We have a tablespace defined as 254 partitions. It was not defined using the DSSIZE parameter, so my take on the IBM manuals says the dataset should be limited to [...] 10106 117 36_Re: Question on dataset size limits.19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Wed, 24 Apr 2002 12:45:24 -0400442_iso-8859-1 5735 cylinders is not more than 4 gig. Here is the table I use. It isn't perfect but is fairly accurate.



Volume / Limits Cylinders Tracks Bytes (RBA) KB MB GB 3390 Volume 3,339 50,085 2,461,777,920 2,404,080 2347.73 2.293 1 gig limit 1,457 21,848 1,073,741,824 1,048,576 1024.00 1.000 2 gig limit 2,913 43,695 2,147,483,648 2,097,152 2048.00 2.000 4 gig limit 5,826 87,390 4,294,967,296 4,194,304 4096.00 4.000 [...] 10224 48 55_Re: Distributed applications, authorizations and commit19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM31_Wed, 24 Apr 2002 12:52:38 -0400462_iso-8859-1 You can use DYNAMIC SQL and not give users authorization to the tables. Check out the BIND option DYNAMICRULE. This option is valid for both packages and plans.





Mike Piontkowski

-----Original Message----- From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of Daniel Adam Sent: Wednesday, April 24, 2002 08:03 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Distributed applications, authorizations and commit [...] 10273 94 11_Bind Error.17_Armando Zaporteza29_armando.zaporteza@PHOENIX.GOV31_Wed, 24 Apr 2002 10:07:18 -0700476_us-ascii Hello experts, I need your help in solving the following error. We currently DB2 V6 and latest of CICS version(Trans).

Error received:

DSN S(DSNT) DSN BIND PLAN (WHISTG) MEMBER(WHISTG) ACTION(REPLACE) RETAIN ISOLATION(CS) L XPLAIN(NO) VALIDATE(BIND) QUALIFIER(WFOUCRM) DSNX200I * BIND SQL ERROR USING WCSTEAM AUTHORITY PLAN=WHISTG DBRM=WHISTG STATEMENT=1950 SQLCODE=-204 SQLSTATE=42704 TOKENS=WFOUCRM.ACCOUNT_TABLE CSECT NAME=DSNXOTL RDS CODE=-500 [...] 10368 54 29_Catalog and Directory backups22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Wed, 24 Apr 2002 12:21:28 -0500357_- Dear Listeners,

DB2 V7.1 OS/390 V2.10

I'm using the Job DSNTIJIC to backup my Catalog and Directory daily. Until recently everything was fine. Now, a couple of tables have grown pretty big and the Job requires 2 tapes. The IC dataset of SYSPKAGE spans across volumes. Is this OK or is this going to hurt my recovery, if I ever have to? [...] 10423 135 45_Re: Question on dataset size limits. -updated9_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 24 Apr 2002 11:42:47 -0600337_us-ascii Maybe we need the formula IBM uses?

My formula is based on the following...

I use 56,664 bytes in a track, 15 tracks to a cylinder.

So take # of tracks times 56,664 to get # of bytes.

86025 tracks X 56664 bytes = 4,874,520,600 bytes

Max for 4 gig vsam file: 4 gig = 4,294,967,296 bytes.. [...] 10559 85 76_Re: Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it15_Fred Occhipinti23_Fred_Occhipinti@FPL.COM31_Wed, 24 Apr 2002 13:33:40 -0400523_us-ascii Amit: The best way I have found to get around this is to get the archive log information for each tablespace via utility DNUPROC with 'REPORT RECOVERY TABLESPACE [dbname].[tsname] SUMMARY' This will dump the archive log information for each tablespace. From this report you can extract which tablespaces have archive log activity and run runstats against them. It will give you a much smaller group of tablespaces to do runstats on. Best Regards, Fred Occhipinti DBA Florida Power & Light Juno Beach, Florida [...] 10645 82 15_Re: Bind Error.11_Moore, Tony15_TMoore@IKON.COM31_Wed, 24 Apr 2002 13:36:05 -0400368_iso-8859-1 Armando, The -204 error codes says the tables (WFOUCRM.ACCOUNT_TABLE and WFOUCRM.CUST_NAME_TABLE) doesn't exist on the subsystem you are binding to.

You might wanna check these... 1. You're binding to the correct DB2 subsystem (DSNT) 2. You are using the correct qualifier (WFOUCRM) 3. Check SYSIBM.SYSTABLES in DSNT to ensure the tables exist. [...] 10728 32 25_CPU usage at DB2/390 V7.116_Alison Pelletier17_ap84098@YAHOO.COM31_Wed, 24 Apr 2002 10:51:07 -0700574_us-ascii I've been absent from list for a while, but I found a post on this subject in archives. We also experienced a CPU increase of 5-7% on most all programs when we "upgraded" from V5 DB2 OS/390 to V6. No binds/rebinds had been done. Disappointing..especially since we didn't expect it. If there were others of you that experienced the same, I'd appreciate knowing about it. Also, did any of you on V7 experience a CPU util. increase when you upgraded? We are upgrading soon. I plan to run benchmarks on test subsystem before/after this time before we go prod., so [...] 10761 133 36_Re: Question on dataset size limits.9_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 24 Apr 2002 11:36:57 -0600585_us-ascii Maybe we need the formula IBM uses?

My formula is based on the following...

I was always use 56,664 bytes in a track, 15 tracks to a cylinder.

So take # of tracks times 56,664 to get # of bytes.

86025 tracks X 56664 bytes = 4,874,520,600 bytes

4 gig = 4,000,000,000 bytes





"Jardine, Lawrence J" wrote: > > 5735 cylinders is not more than 4 gig. Here is the table I use. It isn't > perfect but is fairly accurate. > > Volume / Limits Cylinders Tracks Bytes (RBA) KB MB GB > 3390 Volume 3,339 50,085 > 2,461,777,920 [...] 10895 21 8_MetaCube13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM31_Wed, 24 Apr 2002 13:02:33 -0500436_us-ascii Does anyone know if MetaCube will work with DB2 V6 or V7 on any platform flavor or it is still just for Informix? There seems to be nothing definitive other than the product name, Informix MetaCube, on the IBM website. Are there any future plans to make it work with DB2 since IBM now owns both databases? Since we have both databases and are looking to build a DB2 V7 UDB on NT we really would like the answer to be yes. [...] 10917 73 76_Re: Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it10_James Kwan19_jamesdb2kwan@CS.COM31_Wed, 24 Apr 2002 13:04:51 -0500419_iso-8859-1 Amit,

I don't know if there is any 'smarter' way to determine whether your tablespace object need to run stats or not.

Using STOSPACE will give you some indications, however even if the size of your tablespace objects remain the same does not mean you don't need Runstat.

A better way is to use 'Online Stats' which will be available in next version (V8?) to trigger a runstat job. [...] 10991 174 45_Re: Question on dataset size limits. -updated16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 24 Apr 2002 14:04:19 -0400266_iso-8859-1 4GB = 2**32 bytes = 4294967206 bytes 1 4k block = 4096 bytes. 4GB = 1048576 4k blocks. 12 4k blocks fit on a track. DB2 does not put 56,664 bytes of VSAM data on a track. DB2 puts 12*4096 = 49,152 bytes of VSAM data on a track. 4GB=87381+1/3 tracks. [...] 11166 66 45_Re: Question on dataset size limits. -updated0_19_Tim.Lowe@STPAUL.COM31_Wed, 24 Apr 2002 13:10:28 -0500435_us-ascii Rob, I think that you are using the wrong number for the number of bytes per track. Using the IBM 3390 Direct Access Storage Reference Summary, GX26-4577-2: With blocksize of 4096, using "equal length physical records without keys", you get 12 blocks per track, or 49152 bytes per track. And, 49152 * 15 = 737280 bytes per cylinder. (56664 bytes per track does not take into account dasd waste for different blocksizes.) [...] 11233 155 45_Re: Question on dataset size limits. -updated12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 24 Apr 2002 21:11:38 +0200383_iso-8859-1 Hi, DB2 uses only 48kb in track (12 blocks of 4kb). the rest is ibg (inter block gap). Now calculate again :-)) . Isaac Yassin yassini@bezeqint.net ----- Original Message ----- From: "Rob Crane" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, April 24, 2002 7:42 PM Subject: Re: Question on dataset size limits. -updated [...] 11389 61 76_Re: Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Wed, 24 Apr 2002 13:23:58 -0500321_iso-8859-1 I do not work for BMC so this is not an advertisement...

But the BMC DASD Manager V6.1.03 product has the capability that you are searching for, not only will it look for changes, but based upon parms you specify, it will schedule a reorg to run and re-size, etc...very much worth looking in to... [...] 11451 164 45_Re: Question on dataset size limits. -updated10_Dale Smock20_Dale.Smock@BMSUS.COM31_Wed, 24 Apr 2002 13:24:19 -0500402_iso-8859-1 If you are using 4K pagesize with DB2, you get 12 blocks/3390 track or 49,152 bytes/track.

-----Original Message----- From: Rob Crane [mailto:racrane@CONCENTRIC.NET] Sent: Wednesday, April 24, 2002 12:43 PM To: DB2-L@RYCI.COM Subject: Re: Question on dataset size limits. -updated



Maybe we need the formula IBM uses?

My formula is based on the following... [...] 11616 154 45_Re: Question on dataset size limits. -updated0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 24 Apr 2002 13:27:11 -0500304_iso-8859-1 Short answer: The problem is not your math, just your assumptions. As an earlier post said, DB2 does not use all 56,664 bytes on a 3390 track. DB2 writes data in 4kb pages (4096 bytes) and therefore can only fit 12 pages, 12 * 4096 = 49,152 bytes, with approx 5,000 bytes space 'wasted'. [...] 11771 12 36_Re: Question on dataset size limits.0_26_truman.g.brown@VERIZON.COM31_Wed, 24 Apr 2002 14:30:57 -0400326_us-ascii Work from page size and number of pages in a track on your particular DASD.

================================================ 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. 11784 183 45_Re: Question on dataset size limits. -updated9_Dave Will26_david.e.e.will@VERIZON.COM31_Wed, 24 Apr 2002 14:35:32 -0400432_us-ascii Rob,

There is DB2 space and allocated space. DB2 will put 12 4k pages to a track for 48kb/trk or 720kb/cyl. This is why the allocated DASD exceeds the DB2 space.

Dave







Rob Crane @RYCI.COM> on 04/24/2002 01:42:47 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 11968 91 76_Re: Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 24 Apr 2002 21:41:53 +0200368_iso-8859-1 Hi, If you take image copy - look at the report (pct. changed)

Isaac Yassin yassini@bezeqint.net ----- Original Message ----- From: "James Kwan" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, April 24, 2002 8:04 PM Subject: Re: Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it [...] 12060 27 3_DDF16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 24 Apr 2002 14:48:17 -0400415_iso-8859-1 I never saw an answer to a question posted 06DEC2000 by William Poston. This was: For those of you using DDF heavily to communicate between two DB2 subsystems what do you have your RUSIZES and VPACING set to? And I add questions: 1) Have you done anything (if so, what) which improves DDF elapsed time. Specifically, DB2 or VTAM things. We have already done application positioning for Block Fetch. [...] 12088 62 36_Re: Question on dataset size limits.11_Henry Boone16_hboone@GEICO.COM31_Wed, 24 Apr 2002 13:18:53 -0500585_- On Wed, 24 Apr 2002 07:47:02 -0500, Vaughan, Mike wrote:

> We noticed something on the size of a couple of our partitioned datasets that I wanted to see if anyone could explain... We have a tablespace defined as 254 partitions. It was not defined using the DSSIZE parameter, so my take on the IBM manuals says the dataset should be limited to 4 Gig. However, when I look at one of the partitions in this tablespace it is taking 5,386 cylinders, which according to my calculations comes out to just over 4.2 Gig. > After checking the manuals, [...] 12151 14 7_Re: DDF0_26_truman.g.brown@VERIZON.COM31_Wed, 24 Apr 2002 15:08:46 -0400401_us-ascii Low pacing values can add considerable overhead/delay to VTAM; I would suggest a value of 8 or 10 unless your network has lots of transmission errors.

================================================ 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. 12166 180 45_Re: Question on dataset size limits. -updated16_Fennell, Michael23_Michael.Fennell@FMR.COM31_Wed, 24 Apr 2002 15:08:52 -0400569_iso-8859-1 Folks,

Is it not true that 12 - 4k pages fit on 1 track (4096 * 12 = 49152)

Mike Fennell Database Services 508-787-9120 PIN # 2128845



> -----Original Message----- > From: Rob Crane [SMTP:racrane@concentric.net] > Sent: Wednesday, April 24, 2002 1:43 PM > To: DB2-L@RYCI.COM > Subject: Re: Question on dataset size limits. -updated > > Maybe we need the formula IBM uses? > > My formula is based on the following... > > I use 56,664 bytes in a track, 15 tracks to a cylinder. > > So take # of tracks times 56,664 to get # of [...] 12347 45 37_multiple table joins, bad performance8_Carey Fu24_Carey_Fu@CA.CGUGROUP.COM31_Wed, 24 Apr 2002 14:55:17 -0400419_us-ascii Hello,

I have a SQL doing multiple table joins (both inner and outer). The performance is very bad and EXPLAIN shows it is doing table scan in one of the table. It is because of the outer join, I think. I am using DB2 for OS/390 Version 6. I am trying to understand how DB2 handles each join. I don't know where I can find more information on this. Can someone give me advise? Thank you very much! [...] 12393 31 51_DB2 v4.1 compatibility with OS/390 release 2.10 ???18_Michael J McKinney16_mmckinne@CSC.COM31_Wed, 24 Apr 2002 15:11:41 -0400543_us-ascii All,

A few of our clients or still running DB2 v4.1. They are aware of the out of support issues, but are driven by the typical budget issues as well as a few of them still insisting they are getting off the mainframe. Same old story.

In any event, on one particular client where we are still at DB2 v4.1 there is a project underway to upgrade the operating system to OS/390 v2.10. In working with the client on this upgrade we are pushing a two-stage upgrade to v6.1 as we know v5.1 goes out of support at the end [...] 12425 74 76_Re: Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it0_19_Tim.Lowe@STPAUL.COM31_Wed, 24 Apr 2002 14:18:58 -0500449_us-ascii Amit, Once you get to DB2 V7, how about using the new DB2 V7 real-time stats? (See APAR PQ48448/PTF UQ60825.) I have not tried this yet, but I think it was designed for just what you want to do.

Thanks, Tim





"Sinha, Amit" cc: Sent by: DB2 Data Subject: Running RUNSTATS ( DB2 on OS/390) on Base Discussion Tablespaces only when the y need it List [...] 12500 19 19_Catalog Maintenance16_Katie B. Bayford24_kbayford@DHR.STATE.AL.US31_Wed, 24 Apr 2002 14:23:25 -0500479_- Hello,

Our Catalog needs to be reorganized for better performance. Can anyone share their strategy they are using for catalog maintenance?

Any suggestions would be welcome and I thank you in advance.

Regards, Katie

================================================ 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. 12520 201 45_Re: Question on dataset size limits. -updated9_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 24 Apr 2002 13:50:54 -0600324_us-ascii Mental lapse on my part, thanks...

When using 49,152 bytes in a track (12 4K pages), 15 tracks to a cylinder.

So take # of tracks times 49,152 to get # of bytes.

87,375 tracks X 49,152 bytes = 4,294,656,000 bytes (under 4 gig)

Max for 4 gig vsam file: 4 gig = 4,294,967,296 bytes.. [...] 12722 100 15_Re: Bind Error.13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Wed, 24 Apr 2002 12:36:12 -0500499_iso-8859-1 you have a high level qualifer on the table







Armando Zaporteza To: DB2-L@RYCI.COM Subject: Bind Error. Sent by: DB2 Data Base Discussion List



04/24/2002 12:07 PM Please respond to DB2 Data Base Discussion List













Hello experts, I need your help in solving the following error. We currently DB2 V6 and latest of CICS version(Trans). [...] 12823 78 36_Re: Question on dataset size limits.13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Wed, 24 Apr 2002 14:53:24 -0500479_iso-8859-1 Thanks to everyone for the explanation on this. It appears that the formulas I was working off of were inaccurate (or at least didn't take into account the impact of 4k pages). This definitely explains what I'm seeing (and that what I'm seeing is perfectly normal).

Thanks, Mike. -----Original Message----- From: Henry Boone [mailto:hboone@GEICO.COM] Sent: Wednesday, April 24, 2002 1:19 PM To: DB2-L@RYCI.COM Subject: Re: Question on dataset size limits. [...] 12902 57 23_Re: Catalog Maintenance12_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Wed, 24 Apr 2002 15:55:37 -0400691_us-ascii Read the following:

Utility Guide Db2 Developer's guide Search Db2 list documents site for Dr Ebert's excellent documents on Catalog maintenance.

Amit







"Katie B. Bayford" on 04/24/2002 03:23:25 PM



Please respond to "kbayford@dhr.state.al.us"





To: DB2-L@RYCI.COM

cc: (bcc: Amit Agarwal/FIS)





Subject: Catalog Maintenance











Hello,

Our Catalog needs to be reorganized for better performance. Can anyone share their strategy they are using for catalog maintenance? [...] 12960 14 22_DB2 UDB 7.2 & Fixpak 613_Paul Dobbratz31_Paul.Dobbratz@LIBERTYMUTUAL.COM31_Wed, 24 Apr 2002 14:41:19 -0500469_- For those people who have applied Fix Pak 6 to DB2 UDB version 7.2 for AIX, I am interested in your experiences (both good and bad) with this Fix Pak. Have you run across any problems that I should be aware of?

Thanks.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12975 31 83_Significant increase in SSAS MSTR address space CPU usage after DB2 V7 installation19_Mike Dupuis/OTT/TMG23_Mike.Dupuis@CLARICA.COM31_Wed, 24 Apr 2002 16:19:05 -0400626_us-ascii Hello Listserv,

Has anyone out there had any application performance issues after migrating to DB2 V7 for OS/390.

We migrated from V6 to V7 this past weekend. Since Monday we have experienced performance degradation. Our investigation has revealed a large increase in the amount of CPU consumed by our SSAS MSTR address space. From 9 minutes on average for dayshift last week to 1hr 45minutes per dayshift the last two days. As well we are seeing increases in locking wait times. Our DB2 monitors are not indicating any specific errors. Any thoughts appreciated. We did not have the same occurence [...] 13007 36 7_Re: DDF16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 24 Apr 2002 16:46:09 -0400424_iso-8859-1 Truman, Thanks. We have been using 2 since that is what has been in all the DB2 manuals for several versions. We will try 10 in our QA subsystems in the next few days.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: truman.g.brown@VERIZON.COM [mailto:truman.g.brown@VERIZON.COM] Sent: Wednesday, April 24, 2002 3:09 PM To: DB2-L@RYCI.COM Subject: Re: DDF [...] 13044 27 17_Changes for z/OS?10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Wed, 24 Apr 2002 16:56:10 -0400298_us-ascii We will be converting to z/OS 1.1 next weekend. We currently have DB2v6 running on our production mainframe, a zSeries 900 processor, model 2064. Has anyone been through this change yet? What types of changes should we be considering to our DB2 setup to take advantage of the new OS? [...] 13072 37 47_Selecting data from tables in two UDB databases20_Sitaram Vijay kartik21_vijaykartik@YAHOO.COM31_Wed, 24 Apr 2002 14:11:37 -0700415_us-ascii Dear List Members:

We are trying to SELECT tables from two different databases in a single SELECT statement.

We are using DB2 UDB EE and the databases are on the same instance.

Other than using the Federated approach by using wrapper and nicknames, can we code a select statement in db2 like:

" SELECT db1.tab1.col1, db2.tab1.col2 from db1.schema1.tab1, db2.schema2.tab2 " [...] 13110 26 63_question about coupling facility gbp size and directory entries11_rick creech18_ykcirc@HOTMAIL.COM31_Wed, 24 Apr 2002 21:31:17 +0000403_- Can anyone shed light on the following:

We have coupling facilities with 6 gig each. Somewhere along the line we heard that group bufferpool directory entries must always be below the 2 gig line, and thus total allocations in the coupling facility are kept at 2 gig at this shop. We are at cflevel=10. Does anyone know where this issue is documented and if it has changed with cflevel 10? [...] 13137 15 49_Leon Katsnelson/Toronto/IBM is out of the office.0_15_leon@CA.IBM.COM31_Wed, 24 Apr 2002 17:42:44 -0400397_us-ascii I will be out of the office starting April 24, 2002 and will not return until April 29, 2002.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 13153 30 26_Re: DB2 UDB 7.2 & Fixpak 619_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Wed, 24 Apr 2002 23:00:19 +0100294_us-ascii I've had it running on my laptop for a few weeks now without any complaints : but that is Linux not AIX.

Found a couple of interesting new features in the release notes : the MQ functions are especially interesting to me, but not got a server at that level to try them on. [...] 13184 15 50_Robin P. Kempema/Madison/CMG is out of the office.13_Robin Kempema28_robin.kempema@CUNAMUTUAL.COM31_Wed, 24 Apr 2002 16:51:59 -0500389_us-ascii I will be out of the office starting 04/24/2002 and will not return until 04/30/2002.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 13200 18 32_SQLCODE -471 on UDF ( v6 Os390 )13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Wed, 24 Apr 2002 16:40:03 -0500445_- Hi all We are getting quite a few of these -471's. The manual says that the function timed out before it could be scheduled. We intially suspected the dispatch priority of the WLM address space which we bumped up to be same as other DB2 address spaces but that hasn't helped much. Would anyone please give some pointers to where we can look for a solution. Any parameters to tune in DB2 / WLM / anywhere else ? Thanks in advance Mohammad [...] 13219 54 41_Re: multiple table joins, bad performance31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Wed, 24 Apr 2002 23:22:02 +0100364_iso-8859-1 For your SQL specific question, you need to provide the SQL, EXPLAIN for better explaination by the list members.

For concept of joins, you can go through the Admin Guide and more specifically on Outer Join, Nice paper published by Terry. Look out in the IBM website. You will find just by searching for Terry's full name. It has two parts. [...] 13274 86 76_Re: Running RUNSTATS ( DB2 on OS/390) on Tablespaces only when the y need it31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Wed, 24 Apr 2002 23:24:52 +0100600_iso-8859-1 Looks like _HIST catalog tables in V7 for OS/390 should help you automate the whole process. But it has a little bit of work to do before you can enjoy its usage.

With Best Regards, Sanjeev IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration for OS/390

> -----Original Message----- > From: Sinha, Amit [mailto:Sinha.Amit@MBCO.COM] > Sent: Wednesday, April 24, 2002 11:24 AM > To: DB2-L@RYCI.COM > Subject: Running RUNSTATS ( DB2 on OS/390) on > Tablespaces only when the > y need it > > > Hi, > > Was wondering if anybody had implemented a smarter > way [...] 13361 34 26_Re: high service wait time31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Wed, 24 Apr 2002 23:29:13 +0100566_iso-8859-1 Yes, but if you have more log records written then frequent checkpoints are taken which will write the DB2 objects written to the DISK.

With Best Regards, Sanjeev

--- truman.g.brown@VERIZON.COM wrote: > COMMIT requires the log record to be written, not > the DB2 object written to > disk. > > ================================================ > 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. [...] 13396 77 12_Re: z800 box11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Wed, 24 Apr 2002 15:31:50 -0700559_iso-8859-1 Joel, What are the calculation used to get 350 mips for one engine and 385 for two engines. I can understand that doubling your engines won't double your mips, so how do you pick up the extra 35 mips?

Your mail is timely since we're going to a z800. I've been looking at the order information MSU capacity examples in the v7 announcement 201-054 & 201-050, I can't figure it out. I have a couple more question for you. 1. How are the MSU (millions of services units) calculated? 2. How is the MSU capacity figured, I can understand the [...] 13474 15 50_Robin P. Kempema/Madison/CMG is out of the office.13_Robin Kempema28_robin.kempema@CUNAMUTUAL.COM31_Wed, 24 Apr 2002 15:52:07 -0500403_us-ascii I will be out of the office starting 04/24/2002 and will not return until 04/30/2002.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13490 19 7_Testing12_Susan Lawson24_susan_lawson@YLASSOC.COM31_Wed, 24 Apr 2002 19:29:04 -0500490_iso-8859-1 ******************************************** * Susan Lawson * * DB2 for OS/390 Certified Solutions Expert* * IBM DB2 and S/390 Gold Consultant * * YL&A, Inc * * www.ylassoc.com * ********************************************

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13510 11 11_unsubscribe31_VISHNUKUMAR Mannika Poornachary21_MVishnuk@COVANSYS.COM31_Wed, 24 Apr 2002 13:00:07 -0400267_iso-8859-1

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13522 25 13_Testing Again12_Susan Lawson22_lawson_susan@YAHOO.COM31_Wed, 24 Apr 2002 17:46:35 -0700576_us-ascii Test

===== Susan Lawson DB2 UDB OS/390 & z/OS Certified DBA IBM DB2 and S/390 Gold Consultant YL&A,Inc. Database Performance Professionals www.ylassoc.com

__________________________________________________ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13548 23 4_Test12_Susan Lawson22_lawson_susan@YAHOO.COM31_Wed, 24 Apr 2002 18:00:22 -0700564_us-ascii ===== Susan Lawson DB2 UDB OS/390 & z/OS Certified DBA IBM DB2 and S/390 Gold Consultant YL&A,Inc. Database Performance Professionals www.ylassoc.com

__________________________________________________ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13572 30 8_Re: Test13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 24 Apr 2002 21:35:15 -0400535_iso-8859-1 Looks like we're up and running.

Right?

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@compuware.com













The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...] 13603 69 4_Test10_Paul Riker22_paul_riker@YLASSOC.COM31_Wed, 24 Apr 2002 20:36:19 -0500225_us-ascii Test

Paul Riker Consultant Yevich, Lawson & Associates paul_riker@ylassoc.com



"My girlfriend asked me how long I was going to be gone on this tour. I said 'the whole time'" Steven Wright

13673 64 8_Re: Test16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Wed, 24 Apr 2002 21:52:53 -0400861_iso-8859-1 So it seems



"Service Is Our Best Product"

Robert Galambos Compuware Corp. Of Canada

1-800-348-8299 1-800-447-1662 (quebec) 1-905-803-8603 (fax)





-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: April 24, 2002 9:35 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Test



Looks like we're up and running.

Right?

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@compuware.com













The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error [...] 13738 17 11_Vendor Spam13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Thu, 25 Apr 2002 08:09:06 -0500453_iso-8859-1 I just got an email advertising CA products because:

"You have been referred to me as an attendee in our March 6th Webcast discussing DB2 logs."

Last WEBCAST I sign up for.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13756 12 9_subscribe13_Birla, Ranjan26_Ranjan.Birla@HPSGLOBAL.COM31_Thu, 25 Apr 2002 18:11:41 +0530280_iso-8859-1 Ranjan Birla.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13769 91 30_Note From YL&A Regarding DB2-L10_Paul Riker22_paul_riker@YLASSOC.COM31_Thu, 25 Apr 2002 14:53:26 -0500336_us-ascii Dear DB2-L Listers,

We did complete the switch successfully last night and were back up and running. But as you have noticed, the list is not available, nor is our website.

The unexpected always occurs at the worst times. Our DNS servers got reset and it will take at least 24 hours to make the corrections. [...] 13861 46 8_Re: Test14_Snyder, Kei E.23_kesnyder@SOUTHERNCO.COM31_Wed, 24 Apr 2002 22:06:17 -0500601_- Why am I getting emails from you? Shouldn't it just go to the DB2-L? I've been getting LOTS of email that should have gone to the list.

> -----Original Message----- > From: Seibert, Dave [SMTP:Dave_Seibert@COMPUWARE.COM] > Sent: Wednesday, April 24, 2002 9:35 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: Test > > Looks like we're up and running. > > Right? > > David Seibert > Compuware Corporation File-AID Product Architect > Dave.Seibert@compuware.com > > > > > > > > The contents of this e-mail are intended for the named addressee only. It > contains information that may be [...] 13908 14 9_subscribe12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 25 Apr 2002 13:21:38 -0500311_iso-8859-1 Paul Martin * 763-712-8276 Cell 651-260-2136

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13923 16 11_unsubscribe12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 25 Apr 2002 09:22:33 -0500323_iso-8859-1 test

Paul Martin * 763-712-8276 Cell 651-260-2136

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13940 24 9_subscribe12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 25 Apr 2002 09:33:33 -0500479_iso-8859-1 > -----Original Message----- > From: Martin, Paul > Sent: Thursday, April 25, 2002 9:23 AM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: unsubscribe > > test > > Paul Martin > * 763-712-8276 > Cell 651-260-2136 > >

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13965 22 25_AIX UDB EE V7.2 code base12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 25 Apr 2002 08:18:55 -0500310_iso-8859-1 I have heard that you can get to UDB EE V7.2 either by installing it using the V7.2 CD or installing V7.1 and then installing fixpak3.

If that is true will all of the UDB code be the same? If not anyone know what is different?



Paul Martin * 763-712-8276 Cell 651-260-2136 [...] 13988 16 9_Subscribe18_Eva Molina Jimenez20_evamolina@ES.IBM.COM31_Thu, 25 Apr 2002 15:57:49 +0200353_iso-8859-1 Saludos/ Regards --------------------------------------------------- Eva Molina Jiménez.

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 14005 22 4_test10_CEI, Bruno30_Bruno.CEI@ANDOVER.SEMA.SLB.COM31_Sat, 27 Apr 2002 10:06:53 +0100514_iso-8859-1 ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. [...] 14028 58 88_Re: Significant increase in SSAS MSTR address space CPU usage aft er DB2 V7 installation12_Boone, Henry16_HBoone@GEICO.COM31_Thu, 25 Apr 2002 06:30:29 -0400468_iso-8859-1 Do you use Omegamon for DB2 and if so, do you have the DB2 Object Analysis Facility started? IBM APAR II12697 has more detail.

Henry Boone DB2 SYSTEMS GEICO Insurance Companies (301) 718-5334



-----Original Message----- From: Mike Dupuis/OTT/TMG [mailto:Mike.Dupuis@CLARICA.COM] Sent: Wednesday, April 24, 2002 4:19 PM To: DB2-L@RYCI.COM Subject: Significant increase in SSAS MSTR address space CPU usage after DB2 V7 installation [...] 14087 40 51_Re: Selecting data from tables in two UDB databases13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 26 Apr 2002 07:07:44 -0400347_iso-8859-1 Hi Vigay, >We are trying to SELECT tables from two different >databases in a single SELECT statement.

Why? Are the columns in the 2 tables the same? If not, how do you expect to handle the different data intermingled?

If the columns are the same or at least compatible datatypes, you could perhaps get Union to work. [...] 14128 30 23_TESTING -- still there?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 25 Apr 2002 07:24:07 -0400577_iso-8859-1 Things seemed ok last evening, but no new messages since then.

Anybody out there?

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@compuware.com













The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...] 14159 19 9_Subscribe0_24_ujjwal@LOT.TATASTEEL.COM31_Mon, 29 Apr 2002 09:26:16 +0530480_us-ascii Thanks & Regards UJJAL BHATTACHARYA IBM Global Services, India e-mail - bujjal@in.ibm.com Mobile : 98351 66479 Phone : 91 0657 424478

"An Expert in any subject is a person who has made every possible mistake"

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 14179 32 11_Re: Testing12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Thu, 25 Apr 2002 17:26:20 -0500429_iso-8859-1 when do I find out if I passed? 70% is passing isn't it?

-----Original Message----- From: Susan Lawson To: DB2-L@LISTSERV.YLASSOC.COM Sent: 4/24/2002 7:29 PM Subject: Testing

******************************************** * Susan Lawson * * DB2 for OS/390 Certified Solutions Expert* * IBM DB2 and S/390 Gold Consultant * * YL&A, Inc * * www.ylassoc.com * ******************************************** [...] 14212 58 27_Re: TESTING -- still there?12_Phil Gunning28_pgunning@BREAKTHROUGHDB2.COM31_Mon, 29 Apr 2002 00:13:49 -0400652_- I received your post. So it looks like we are alive. Regards, Phil



> Things seemed ok last evening, but no new messages since then.

Anybody out there?

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@compuware.com













The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...] 14271 33 16_The List is Back12_Phil Gunning28_pgunning@BREAKTHROUGHDB2.COM31_Mon, 29 Apr 2002 00:21:39 -0400550_- Subscribers, It is just after midnight EST 4/29/02. It appears the list is back in operation after the move. Thanks for being patient. We thank the folks at YLA for the hard work. See instructions on subscribing, unsubscribing, and FAQ at http://listserv.ylassoc.com. Cheers! Phil

Associate List Owner DB2-L



<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Philip K. Gunning IBM Certified Advanced Technical Expert -- DB2 DRDA IBM Certified Advanced Technical Expert -- DB2 Clusters 1-877-432-4897 x8 [...] 14305 90 17_Subscribe to DB2L11_Dan Hoffman23_daniel.hoffman@WCOM.COM31_Thu, 25 Apr 2002 12:32:25 -0500563_us-ascii Please put me on the list

thanks, Dan Hoffman RAPIDS LDBA daniel.hoffman@wcom.com v820-7249





Susan Lawson cc: (bcc: Dan Hoffman/CDR/BSM/MCI) Subject: REMINIDER- PLEASE READ - URGENT - DB2L 04/24/02 08:55 - MOVING WEDNESDAY! AM Please respond to DB2 Data Base Discussion List













Don't forget....this move occurs tonight at 6pm CST. After this you will need to send/receive mails for the list at DB2-L@listserv.ylassoc.com [...]