1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2000, week 2 2 133 47_Re: Advice on Order of keys in clustering index7_Sanjeev19_Sanjeev@INTERRA.COM30_Thu, 8 Jun 2000 11:06:06 +0530588_iso-8859-1 Hi Gina, I agree with points made by Suresh but do think that little bit of discussion is required for the point # 3. First of all creating index in the order mentioned by Suresh and corresponding addition of the new index depending on the requirements is always a valid point.As you mentioned the situation of your batch applications requirements, it might require new index with different order of the columns. Suresh, does the same clustering on all the join tables matter if the cluster ratio of all the indexes(used) are 100%.I think DB2 will not be affected by this [...] 136 467 47_Re: Advice on Order of keys in clustering index11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Thu, 8 Jun 2000 15:41:49 +1000639_ISO-8859-1 Sanjeev,

yes, the clustering sequence of related tables certainly matters - unless all your data accesses are completely random. DB2 can use prefetch much more effectively if all joined tables are clustered in the same way. Have a look at some of Michael Hannan's previous contributions.

Cheers, Ulrich

> -----Original Message----- > From: Sanjeev [SMTP:Sanjeev@INTERRA.COM] > Sent: Thursday, June 08, 2000 3:36 PM > To: DB2-L@RYCI.COM > Subject: Re: Advice on Order of keys in clustering index > > Hi Gina, > I agree with points made by Suresh but do think that little bit of > discussion is required [...] 604 1078 17_Re: Quiesce Point11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Thu, 8 Jun 2000 16:10:36 +1000557_ISO-8859-1 Can I try a clarification here? As far as I can see, Craig is talking about recovery - full stop - whereas Venkat is talking about point-in-time recovery. Both are right - for normal recovery it is irrelevant whether you have a quiesce after the backup or not because DB2 will read the log past that point anyway, right to the end. For point-in-time recovery you would normally want to recover to a consistent point - hence the quiesce. So in regard to the original question, if there is a chance that you might ever want to use that backup [...] 1683 60 19_SV: signal sqlstate0_19_Sven.Heidorn@CSN.SE30_Thu, 8 Jun 2000 08:56:27 +0200508_ISO-8859-1 Ben,

if you are on OS/390 the following applies.

SIGNAL SQLSTATE The SIGNAL SQLSTATE statement is used to signal an error.It causes an error to be returned with the specified SQLSTATE and error description. Invocation This statement can only be used in the triggered action of a trigger.

Also, in the redbook: Developing Cross-Platform DB2 Stored Procedures, on page 27, it says Important: The Signal and Resignal statements are not yet supported on the OS/390 platform. [...] 1744 100 16_SV: UDF Question0_19_Sven.Heidorn@CSN.SE30_Thu, 8 Jun 2000 09:10:49 +0200663_ISO-8859-1 James, at least for SP's the # of parameters are recorded in column PARM_COUNT in SYSROUTINES, and the actual parameters are recorded in SYSPARMS. Since the parameters are in the CREATE PROCEDURE statement it should not matter in what language the SP is written.

Sven Heidorn

> -----Ursprungligt meddelande----- > Från: James.Campbell@HANCORP.COM.AU [SMTP:James.Campbell@HANCORP.COM.AU] > Skickat: den 8 juni 2000 04:18 > Till: DB2-L@RYCI.COM > Ämne: Re: UDF Question > > Bejoy > > A 'separate lib' from what? Do you have separate libraries from batch > programs and CICS/IMS programs? Probably. So have one for stuff running > in > [...] 1845 164 16_Re: UDF Question14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 8 Jun 2000 18:19:50 +1000368_iso-8859-1 Sven,

and when you are in a running SP, just how do you know which row in SYSROUTINES is applicable to the invokation? You get the procedure-name/udf-specific-name from the parameter list. But how do you know if it is in the 3rd, 5th, 7th ... parameter - which depends on there being 0, 1, 2 ... user parameters (plus a return value for a UDF)? [...] 2010 66 21_Re: TS Status changes7_Sanjeev19_Sanjeev@INTERRA.COM30_Thu, 8 Jun 2000 14:49:43 +0530456_iso-8859-1 Hi Rohn, I do not find any problem in any of the two cases mentioned by you. We can use runstat with shrlevel reference in RW mode but it allows only read access to the data.

But i would like to ask : 1) Why the tablespace was put into Utility Only access ? , Does Alter table do that ..? I do not think so. 2) Did your DBA issue START DB(xxxxx) SPACE(xxxxx) ACCESS(RW) for bringing it into RW status (However, i find no other way). [...] 2077 100 69_Re: droping of DB2 Catalog and directory tables - SYSUTIL and SYSLGRN0_18_mebert@AMADEUS.NET30_Thu, 8 Jun 2000 12:25:40 +0100544_us-ascii These TSs were replaced by SYSUTILX and SYSLGRNX (I think one in V3, the other in V4). If you want to be careful (a good idea in this case), STOP the TSs and their indexes (unfortunately I don't know what they are named; the indexes on the NEW TSs are DSNLLX01/02 and DSNLUX01/02); then HMIGRATE the VSAM datasets. If, after one or two weeks, nobody complains, no jobs fall over and they are still migrated, nobody is using them and you can delete them (I think you can't DROP them as they are not recorded in the Catalog). I did [...] 2178 19 69_Re: droping of DB2 Catalog and directory tables - SYSUTIL and SYSLGRN18_Rajesh Kumar Sinha24_rksinx@LOT.TATASTEEL.COM28_Thu, 8 Jun 2000 10:18:45 GMT497_us-ascii No dropping of these two tables(sysutil * syslgrn) would not affect your running environment. Then also it is recommended to take backup and do it in test environment first. And after successful execution do it in production.

Thanks Rajesh

================================================ 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. 2198 26 17_Re: Quiesce Point9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM30_Thu, 8 Jun 2000 11:44:27 +0100575_us-ascii Folks,

the discussion so far has overlooked what I think is the most important part of the debate. The QUIESCE utility is the only realistic method for establishing an application-wide point of consistency. This is pretty essential in a disaster recovery.

In DB2 V2 days, if you tried to run a SHRLEVEL REFERENCE image copy and couldn't lock the tablespace, the object was left in Copy Pending mode. I'm not sure if this is still the case. Instead, you would run QUIESCE which left the object RW if it could not take an exclusive tablespace lock. [...] 2225 116 44_Re: Backup strategy for 1000s of tablespaces13_Wulff, Torben20_Torben_Wulff@BMC.COM30_Thu, 8 Jun 2000 05:34:21 -0500649_ISO-8859-1 Adrian -

There could be several possibilities to improve the COPY PLUS performance. The first thing I would look at is moving the small or empty copies from tape to disk. My guess is that a lot of the time is spent in allocating the datasets on the tape.

COPY PLUS has the options to do that like this: //SYSIN DD * OUTPUT DISKOUT UNIT SYSDA SPACE TRK DSNAME SAPCOPY.SMALL.&TS.D&DATE.T&TIME OUTPUT TAPEOUT UNIT CART DSNAME SAPCOPY.BIG.&TS.D&DATE.T&TIME COPY APPLICATION SAPR3 FULL YES RESETMOD NO COPYDDN(DISKOUT) BIGDDN(TAPEOUT) The decision to use COPYDDN or BIGDDN is taken based on the installation option OUTSIZE, [...] 2342 10 28_Bennefits of Moving a System10_Bill Brown25_bill_brown@SPRINGMAIL.COM30_Thu, 8 Jun 2000 07:42:13 -0400419_- In our environment we have multiple coppies of a system in each DB2. We keep them seperate by naming conventions of the objects. We have just completed a project where we moved a copy of the system of of our production DB2. Now we are trying to document the benefits of this move to upper mgmt. Any help would be greatly appreciated. We ar looking for things like reduced memory required, reduced edm pool, etc. [...] 2353 34 69_Re: droping of DB2 Catalog and directory tables - SYSUTIL and SYSLGRN11_John Rosser24_jhrosser@DUKE-ENERGY.COM30_Thu, 8 Jun 2000 07:02:04 -0500422_- Don't drop SYSUTIL. From V5 Diagnosis Guide:

7.3.5 SYSIBM.SYSUTIL Table

The SYSUTIL table stores status information about DB2 utilities that are active or stopped. Each record is uniquely identified by the utility identifier. Each row of the table contains the information for one utility execution step. When the utility completes running, the corresponding entries in the SYSUTIL table are deleted. [...] 2388 80 30_Re: Catch 22 on Stogroup Auths14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US30_Thu, 8 Jun 2000 08:19:06 -0400311_us-ascii Hi Cliff,

I believe the authorization you are seeing is the one automagically created when you define an object. Is the Creator of the stogroup the ID you did the SET Current too ?? - If so the privilege cannot be revoked without deleting or recreating the object with a different creator. [...] 2469 19 27_DB2 Connect V6.1 On Solaris10_Tim Miller21_tmiller@TELCORDIA.COM30_Thu, 8 Jun 2000 08:12:44 -0400440_us-ascii I have a trial license install for DB2 UDB V6.1on solaris 2.7, I received my new software, how do I update the license? Please send email to tmiller@telcordia.com.

Thanks,

Tim

================================================ 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. 2489 304 17_Re: Quiesce Point12_craig patton21_prgpatton@HOTMAIL.COM28_Thu, 8 Jun 2000 05:42:47 PDT646_- Pillay, You are correct. I should have considered the TOCOPY only, for which a CHANGE copy should NOT be used and a quiesce after the copy WOULD give you a point of consistency to which you could recover. Craig

>From: "Pillay, Venkat (PCA)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Quiesce Point >Date: Wed, 7 Jun 2000 16:23:17 -0400 > >That is not correct. > >RECOVER TOCOPY will not do LOGAPPLY. It is kind of equivalent of DB2 doing >REPRO from imagecopy to VSAM. >RECOVER TORBA/TOLRSN/TOLOGPOINT would do LOGAPPLY >RECOVER LOGONLY checks the header page [...] 2794 16 46_Re: Reorganizing all Partitions simulatneously14_Michael Vanner19_mvanner@CANTIRE.COM30_Thu, 8 Jun 2000 08:44:19 -0400375_us-ascii Why not drop the npi, reorg the tablespaces in parallel and recreate the npi.

Michael Vanner Canadian Tire Corp. Ltd.

================================================ 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. 2811 52 17_Re: Quiesce Point19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 8 Jun 2000 07:57:20 -0500534_iso-8859-1 bjnigh, Jeez . . . some discussion huh? How you Image Copy is determined on how you need to RECOVER! If your Recovery will be full forward use COPY SHRLEVEL CHANGE. Most companies attempt full forward recoveries to the end of the archive logs at a disaster recovery site. Setting up for a point-in-time recovery requires planning ahead of time. Consider a Payroll run where all input tables must have all activity against them stopped first. Tossing around QUIESCEs, before or after Image Copies, doesn't handle this. [...] 2864 49 44_Re: Backup strategy for 1000s of tablespaces19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 8 Jun 2000 08:04:30 -0500610_iso-8859-1 Hi Dennis, HEY PEOPLESOFT, SAP you guys LISTENING? Had to deal with PeopleSoft when they were down around 300 or so tables. . . ~!@#$%^&*()_+:( If enough people complain, maybe they will fix this situation, (sure, right)!

Best Regards, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the [...] 2914 49 44_Re: Backup strategy for 1000s of tablespaces13_Adrian Savory24_adrian.savory@ZURICH.COM30_Thu, 8 Jun 2000 14:08:24 +0100572_us-ascii Thanks for all the replies - some very useful information. I followed up the lead on being able to condense unused tables into multi-table tablespaces. Here's what I found in the SAP R/3 DBA Guide for rel.4.5b:

R/3 includes a mass processing tool. To access it, call transaction SE14 and choose DB requests - mass processing. There is also a DB2/390-specific report that prepares table storage parameters and subsequently enters them for mass processing. To access the report: 1. Call transaction SE38 and specify program RSDB2MAS. 2. Choose execute. [...] 2964 310 17_Re: Quiesce Point15_Murley, Michael22_Michael_Murley@BMC.COM30_Thu, 8 Jun 2000 08:47:24 -0500494_ISO-8859-1 Sanjeev,

Recovery to the START_RBA of a shrlevel change copy must not use that copy since it may include updates beyond its START_RBA. It should try to use the previous image copy. Recovery to such an inconsistent point is, of course, not something you generally want to do.



Michael Murley BMC

-----Original Message----- From: Sanjeev [mailto:Sanjeev@INTERRA.COM] Sent: Thursday, June 08, 2000 12:04 AM To: DB2-L@RYCI.COM Subject: Re: Quiesce Point [...] 3275 101 17_Re: Quiesce Point20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 8 Jun 2000 09:53:43 -0400581_us-ascii Rick

You are right. RECOVERY as a whole needs a good planning and tossing around the QUIESCE here and there is not the complete answer. But original question was PLANTINUM takes a QUIESCE as part of imagecopy job and does IBM imagecopy need that too.

I don't know how PLATINUM imagecopy works. But I have seen most of the vendors have much faster utility than IBM and they try to read the underlying VSAM directly instead of going to the bufferpool. That is one of the reasons that on certain occasions it becomes important for them to issue QUIESCE to [...] 3377 66 70_Re: droping of DB2 Catalog and directory tables - SYSUTIL and SYS LGRN23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Thu, 8 Jun 2000 09:59:43 -0400630_- This has to be a documentation error. We have dropped SYSIBM.SYSUTIL several months ago and haven't had any problem.

Sanjay

> -----Original Message----- > From: John Rosser [SMTP:jhrosser@DUKE-ENERGY.COM] > Sent: Thursday, June 08, 2000 8:02 AM > To: DB2-L@RYCI.COM > Subject: Re: droping of DB2 Catalog and directory tables - SYSUTIL > and SYSLGRN > > Don't drop SYSUTIL. > From V5 Diagnosis Guide: > > 7.3.5 SYSIBM.SYSUTIL Table > > The SYSUTIL table stores status information about DB2 utilities that are > active or stopped. Each record is uniquely identified by the utility > identifier. Each row of the [...] 3444 81 21_Re: TS Status changes0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 8 Jun 2000 09:01:05 -0500430_us-ascii Thanks Sanjeev

1 - JCL is generated by DBA-Xpert ... (i.e. in this job step #8 is Alter tables, next step is UT status, Image Copy, Quiesce, Runstats, RW status, Rebinds 2 - Yes, a DBA entered the Start command on the command line.









Sanjeev @RYCI.COM> on 2000/06/08 04:19:43 AM

Please respond to DB2 Data Base Discussion List [...] 3526 71 30_Re: Catch 22 on Stogroup Auths12_Carol Sutfin19_csutfin@AMSOUTH.COM30_Thu, 8 Jun 2000 09:17:22 -0500505_- Cliff, This is the authorization that resulted from the creation of the STOGROUP. The only way to remove the owner is to DROP the Stogroup and define it again. I am doing the same thing right now.

What I do to resolve the problem is to create a new STOGROUP (using the proper authority) that has the same attributes as the one I am trying to fix. Then I ALTER the objects using the original Stogroup to use the new one. After all use of the Stogroup is changed I then DROP the original one. [...] 3598 106 17_Re: Quiesce Point16_Peddycoart, Judy22_peddycoa@UILLINOIS.EDU30_Thu, 8 Jun 2000 09:30:00 -0500364_iso-8859-1 Okay, I know we're all tired of hearing about this particular thread, but I just have to put in my two cents worth! I agree with Rick that it depends on how you want to recover and what you're trying to accomplish with the image copy. If you're copying the tablespaces to facilitate full forward recovery, then you probably don't need the quiesce. [...] 3705 117 30_Re: Catch 22 on Stogroup Auths15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 8 Jun 2000 09:34:31 -0500357_iso-8859-1 Wouldn't you also have to reorganize the objects so that they actually use the new stogroup? If the VCAT were different the data set name wouldn't pick up the new VCAT for the high-level qualifier until after a reorganization had occurred. I am not sure how that would work if the VCAT were the same. Perhaps a reorg would not be necessary. [...] 3823 17 12_DDF HELP !!!14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 8 Jun 2000 10:41:49 -0400390_- Hi,

I need to configure DDF asap. Is the location name the DB2 subsystem name or the DNS name for the IP stack. Please advise. Thanks, Dean

================================================ 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. 3841 128 21_Re: TS Status changes15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 8 Jun 2000 09:42:34 -0500340_iso-8859-1 I would think that unless you are not updating the new columns on the old rows within the table that you would have wanted to include a reorganization after the alter in order to reallocate the space for the rows. In my experience updating new columns on old rows when a reorg has not occurred results in inconsistent data. [...] 3970 41 16_Re: DDF HELP !!!12_tim malamphy20_timalamphy@YAHOO.COM30_Thu, 8 Jun 2000 07:55:56 -0700399_us-ascii I believe you want to use the location name (as specified in the BSDS of the DB2 subsystem you're trying to connect to) which may or may not be the same as the DB2 subsystem name on OS/390 DB2. Dump the BSDS and look for the DDF record. If you're trying to connect to a UDB system, it's the Database name , as opposed to the Instance name. The IP address goes into sysibm.ipnames. Tim [...] 4012 42 16_Re: DDF HELP !!!14_Philip Gunning20_pgunning@BOSCOVS.COM30_Thu, 8 Jun 2000 11:01:20 -0400357_iso-8859-1 The location name is the vtam applid that you have defined. It is what appears in the BSDS. Phil

Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Soutions Expert -- DB2 UDB V6 Database Administration IBM Certified Solutions Expert -- DB2 UDB Application Development Assoc List Owner -- DB2-L [...] 4055 43 31_Re: DB2 Connect V6.1 On Solaris19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Thu, 8 Jun 2000 08:05:22 -0700352_- Depending on which tools are available on the Solaris platform, you may have the GUI License "Nodelock Administration Tool" and definitely should have the command db2licm. Both are for license administration. They should allow importing the license nodelock file from your "authorized" software CD into the installed software license directory. [...] 4099 61 16_Re: DDF HELP !!!18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM30_Thu, 8 Jun 2000 11:12:12 -0400352_iso-8859-1 Try to keep the loc luname and ssid the same to avoid confusion (especially for the applications group who have to remember ssid/location to code in their pgms). You probably don't have control over what the VTAM guys do but you may be able to influence them! You define what is in the BSDS with the following in the "JUZ" install job: [...] 4161 51 16_Re: DDF HELP !!!15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 8 Jun 2000 10:16:45 -0500568_iso-8859-1 It seems logical to me that if you have not configured DDF yet you won't find the location name in the BSDS. I believe that the location name and the luname in the locations table work together to make it possible for various DB2 subsystems to "talk" to each other. In our configuration (We are on OS/390.)the luname is the VTAM APPLID for the DDF region. The location name is a naming standard that we created which consists of NETWINFO_**** where **** is the four letter subsystem identifier. I am not aware of any other place where this is defined. [...] 4213 78 16_Re: DDF HELP !!!14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 8 Jun 2000 11:18:06 -0400576_- Is the password necessary ?

> -----Original Message----- > From: Bourgoine, Peter A [SMTP:Peter.A.Bourgoine@JPFINANCIAL.COM] > Sent: Thursday, June 08, 2000 11:12 AM > To: DB2-L@RYCI.COM > Subject: Re: DDF HELP !!! > > Try to keep the loc luname and ssid the same to avoid confusion > (especially > for the applications group who have to remember ssid/location to code in > their pgms). You probably don't have control over what the VTAM guys do > but > you may be able to influence them! You define what is in the BSDS with the > following in the "JUZ" install [...] 4292 94 19_Re: signal sqlstate8_Rob Lake20_robert.lake@CONTI.DE30_Thu, 8 Jun 2000 10:06:40 -0500537_- Hi,

You can achieve the same effect by using the DB2SQL parameter style and setting the SQLSTATE and SQL diagnostic string arguments prior to returning from the procedure/function.

For example in a MAIN stored procedure written in C, the following code fragment would set the SQLSTATE and diagnostic string :

int main progeg1(int argc, char *argv[]) . . . if (nullind_for_input_parm_1 < 0) { strcpy(argv[7],"38I00"); strcpy(argv[10],"ERROR: INPUT_PARM IS NULL"); return; } . . . The procedure is defined as : [...] 4387 219 47_Re: Advice on Order of keys in clustering index11_Suresh Sane21_data_arch@HOTMAIL.COM28_Thu, 8 Jun 2000 10:20:36 CDT558_- A few comments on the issues raised by Sanjiv & Ulrich:

1. Clustering of joined tables: The point Sanjiv makes (if the cluserratio is 100%, does it matter that it is not defined as clustering?) - I agree. However when a second bank is added, it will NOT remain 100% and the right clustering index is the only way to assure a high clusterratio which impacts not only prefetch but also the elimination of a getpages (next row already on same page). So, to re-iterate - design for not just 1 bank but many (mergers, acquisitions, splits etc etc). [...] 4607 68 33_TSO/ISPF/Rexx Support for DB2/39014_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Thu, 8 Jun 2000 15:41:35 +0100558_iso-8859-1 I've tried running the following Rexx...

/* Rexx */ trace i 'subcom dsnrexx' if rc then src=rxsubcom('add','dsnrexx','dsnrexx') address dsnrexx 'connect db2t' 'disconnect' src=rxsubcom('delete','dsnrexx','dsnrexx') Return

and I get the following results...

3 *-* 'subcom dsnrexx' >L> "subcom dsnrexx" +++ RC(1) +++ 4 *-* if rc >V> "1" *-* then 5 *-* src=rxsubcom('add','dsnrexx','dsnrexx') >L> "add" >L> "dsnrexx" >L> "dsnrexx" 5 +++ src=rxsubcom('add','dsnrexx','dsnrexx') Error running PRAWF, line 5: Routine not found [...] 4676 31 34_Carriage return character in a SQL15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Thu, 8 Jun 2000 11:28:08 -0400440_iso-8859-1 To all,

Another question from me. Can we generate a carriage return character in the SQL.

E.g. -- Select 'ACDEFG' concat concat '123435353' from sysibm.sysdummy1

The result of this query should be ACDEFG 123435353

Please let me know if anybody knows the answer.

Thanks Sibimon Philip 972-813-5517 - Office 972-417-3597 - Residence E-mail - SPhilip@CSXLINES.COM [...] 4708 116 16_Re: DDF HELP !!!18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM30_Thu, 8 Jun 2000 11:31:20 -0400462_iso-8859-1 Yup. The password and the luname are defined in the VTAM lib SYS1.VTAMLST. Something like this:

APPLDBGT VBUILD TYPE=APPL DBGT APPL AUTH=(ACQ),APPC=YES,DMINWNL=125, * DMINWNR=125,DSESLIM=250,MODETAB=DDCSMODE, * PARSESS=YES,PRTCT=DDCSDBGT,SECACPT=ALREADYV,SRBEXIT=YES,* VERIFY=NONE,VPACING=8,AUTOSES=1, * ATNLOSS=ALL,SYNCLVL=SYNCPT I'm not VTAM so I can't explain it all to you but the password you use is found in the parm: PRTCT=DDCSDBGT [...] 4825 28 16_Re: DDF HELP !!!12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 8 Jun 2000 10:33:00 -0400430_- The location name is a name you make up. It should reflect the location of your organization as well as the Subsystem name. This will identify your DB2 to your organization in case other sites that communicate with you via DDF have the same subsystem name. We have a distinct location name containing the Organization, Location and DB2 subsystem name. Example: IBMNYDB@@. >>> DB2-L@RYCI.COM@inter2 06/08/00 09:41AM >>> Hi, [...] 4854 26 45_newbie question: How to set restricted access14_Ruth Gramolini26_rgramolini@TAX.STATE.VT.US30_Thu, 8 Jun 2000 11:33:12 -0400279_iso-8859-1 Hello, I am a new member of this list. I am mostly and Oracle DBA but I also support and IPFS application on DB2. We would like to know if these is a way to restrict access to a DB2 database? We would like something that acts like "restricted session" in Oracle. [...] 4881 135 16_Re: DDF HELP !!!14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 8 Jun 2000 11:47:51 -0400709_- I'm not VTAM either ! We don't have that PRTCT coded in our appl definition.

> -----Original Message----- > From: Bourgoine, Peter A [SMTP:Peter.A.Bourgoine@JPFINANCIAL.COM] > Sent: Thursday, June 08, 2000 11:31 AM > To: DB2-L@RYCI.COM > Subject: Re: DDF HELP !!! > > Yup. The password and the luname are defined in the VTAM lib > SYS1.VTAMLST. > Something like this: > > APPLDBGT VBUILD TYPE=APPL > DBGT APPL AUTH=(ACQ),APPC=YES,DMINWNL=125, * > DMINWNR=125,DSESLIM=250,MODETAB=DDCSMODE, * > PARSESS=YES,PRTCT=DDCSDBGT,SECACPT=ALREADYV,SRBEXIT=YES,* > VERIFY=NONE,VPACING=8,AUTOSES=1, * > ATNLOSS=ALL,SYNCLVL=SYNCPT > I'm not VTAM so I can't explain it all to you but the password you use is > [...] 5017 179 16_Re: DDF HELP !!!12_tim malamphy20_timalamphy@YAHOO.COM30_Thu, 8 Jun 2000 08:58:13 -0700548_us-ascii if it's not coded in VTAM or your current DDF record in the BSDS then I don't think you have to worry about it. Tim --- Dean Montevago wrote: > I'm not VTAM either ! We don't have that PRTCT coded > in our appl definition. > > > -----Original Message----- > > From: Bourgoine, Peter A > [SMTP:Peter.A.Bourgoine@JPFINANCIAL.COM] > > Sent: Thursday, June 08, 2000 11:31 AM > > To: DB2-L@RYCI.COM > > Subject: Re: DDF HELP !!! > > > > Yup. The password and the luname are defined in > the VTAM lib > > SYS1.VTAMLST. [...] 5197 41 23_qmf edit table question0_23_edie.richardson@SRS.GOV30_Thu, 8 Jun 2000 12:01:32 -0400456_us-ascii I'm using QMF to edit values in a table. The table has a column that has packed data in it that is nullible. Everytime I return a row that has data in the packed column and try to PF8, I get an error and exitted out of the editor. It also will not let me edit the packed column thru QMF. Does anyone know how I can edit this packed column using the QMF table editor? And of course, I let someone use my "Using QMF" manual so I can't find it. [...] 5239 67 13_DDF HELP !!!!14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 8 Jun 2000 12:10:40 -0400607_- I tried to start DDF and received the following:

DSNL519I # DSNLILNR TCP/IP SERVICES AVAILABLE 657 FOR DOMAIN mvstech.10.in-addr.arpa AND PORT 446 DSNL015I # VTAM SETLOGON FAILED RTNCD='10'X FDBK2='19'X DSNL004I # DDF START COMPLETE 659 LOCATION APPLDB2S LU VNSNET.APPLDB2S GENERICLU VNSNET.GENLU DOMAIN mvstech.10.in-addr.arpa TCPPORT 446 RESPORT 5020 Can anyone shed some light on the possible cause of the VTAM logon failure. As far as th domain name the MVSTECH portion is correct but the rest is garbage, anybody know where it comes from ? Do I have something coded incorrectly. TIA Dean [...] 5307 32 42_Reorganizing all Partitions simulatneously13_Matheny, Bill25_bill.matheny@EXPERIAN.COM30_Thu, 8 Jun 2000 09:32:29 -0700440_- Loren,

I'd suggest reorganizing the entire tablespace in a single reorg. That way, the NPI will be rebuilt instead of updated. The main consideration in doing so is whether or not you are able to live with the elongated switch time (2-3 second per data or index cluster, which in your case would work out to almost a minute). You may also have to consider the work datasets required if your partitions are particularly large. [...] 5340 106 17_Re: DDF HELP !!!!15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 8 Jun 2000 11:34:58 -0500501_iso-8859-1 This might be a stupid question but do you have the DB2 DDF region defined to VTAM? From what I understand it has to be defined in VTAM regardless of whether you use TCP/IP or not.

Linda Billings Enterprise Systems Programmer Wisconsin Department of Administration Info-Tech Services

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in. we're computer professionals. We cause accidents." - Nathaniel Borenstein [...] 5447 129 17_Re: DDF HELP !!!!14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 8 Jun 2000 12:39:05 -0400602_iso-8859-1 There are no stupid questions. Are you saying I need DB2DIST (the address space name) defined to VTAM ??

> -----Original Message----- > From: Billings, Linda [SMTP:linda.billings@DOA.STATE.WI.US] > Sent: Thursday, June 08, 2000 12:35 PM > To: DB2-L@RYCI.COM > Subject: Re: DDF HELP !!!! > Sensitivity: Personal > > This might be a stupid question but do you have the DB2 DDF region defined > to VTAM? From what I understand it has to be defined in VTAM regardless > of > whether you use TCP/IP or not. > > Linda Billings > Enterprise Systems Programmer > Wisconsin Department of [...] 5577 91 37_Re: TSO/ISPF/Rexx Support for DB2/39011_rick creech18_ykcirc@HOTMAIL.COM28_Thu, 8 Jun 2000 09:41:12 PDT696_- If you are at version 5, there is a separate install process (albeit very simple) for DSNREXX: it has its own program directory. hth, Rick Creech



>From: "Davage, Marcus" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: TSO/ISPF/Rexx Support for DB2/390 >Date: Thu, 8 Jun 2000 15:41:35 +0100 > >I've tried running the following Rexx... > > /* Rexx */ > trace i > 'subcom dsnrexx' > if rc then > src=rxsubcom('add','dsnrexx','dsnrexx') > address dsnrexx > 'connect db2t' > 'disconnect' > src=rxsubcom('delete','dsnrexx','dsnrexx') > Return > >and I get the following results... > > 3 *-* 'subcom dsnrexx' [...] 5669 191 17_Re: DDF HELP !!!!15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 8 Jun 2000 11:45:06 -0500453_iso-8859-1 I suspect so. I have never done this before but I saw something about that in the Installation Guide. You might check there.

Linda Billings Enterprise Systems Programmer Wisconsin Department of Administration Info-Tech Services



"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in. we're computer professionals. We cause accidents." - Nathaniel Borenstein [...] 5861 197 17_Re: DDF HELP !!!!15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 8 Jun 2000 11:53:50 -0500364_iso-8859-1 Here is the paragraph from the Install Guide

3.3.1 Enabling TCP/IP communication

".... If you do not use VTAM to communicate with remote sites, you still must define VTAM to DB2 as described in "Chapter 3-2. Connecting Systems with VTAM" in topic 3.2 because DB2 TCP/IP communications uses NETID and LUNAME to identify units of work. [...] 6059 23 13_Smart Restart19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 8 Jun 2000 12:02:46 -0500616_iso-8859-1 Hi all, What's the latest on talks between IBM and the Smart Restart folks? Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is [...] 6083 52 49_Re: newbie question: How to set restricted access9_Ted Pesta18_tpesta@AMQUEST.COM30_Thu, 8 Jun 2000 13:11:07 -0400668_iso-8859-1 Ruth,

The closest you can get is to start DB2 in access mode MAINT.

-START DB2,PARM(DSNZPAR1),ACCESS(MAINT)

This will allow only SYSADM and SYSOPR users to logon.

HTH, Ted Pesta AmQUEST, Inc.

-----Original Message----- From: Ruth Gramolini [mailto:rgramolini@TAX.STATE.VT.US] Sent: Thursday, June 08, 2000 11:33 AM To: DB2-L@RYCI.COM Subject: newbie question: How to set restricted access

Hello, I am a new member of this list. I am mostly and Oracle DBA but I also support and IPFS application on DB2. We would like to know if these is a way to restrict access to a DB2 database? We would like something that [...] 6136 139 37_Re: TSO/ISPF/Rexx Support for DB2/39013_Brendan Friel18_b.friel@PECORP.COM30_Thu, 8 Jun 2000 12:11:56 -0500353_- Three part question :

Is there any additional licensing cost involved with installing REXX support under V5 ? Is the installation something that would involve a lot of effort on the part of our system programmers, DBAs ? If it was in place, how hard is it for developers who already know DB2 and REXX to pick up how to use the interface ? [...] 6276 81 49_Re: newbie question: How to set restricted access0_17_sjvagnier@AEP.COM30_Thu, 8 Jun 2000 13:21:44 -0400493_us-ascii Hi Ruth, I believe INSTALL SYSADM and INSTALL SYSOPR have access. SYSADM and SYSOPR would not have access under maint mode.

Hope this helps... Steve American Electric Power









Ted Pesta on 06/08/2000 01:11:07 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Stephen J Vagnier/OR1/AEPIN)

Subject: Re: newbie question: How to set restricted access [...] 6358 90 19_Re: signal sqlstate13_OConner, John26_John.OConner@COURTS.WA.GOV30_Thu, 8 Jun 2000 10:25:33 -0700466_iso-8859-1 SIGNAL SQLSTATE works for us in triggers. We're on DB2 V6.1, OS/390 2.7.

John O'Conner DB2 DBA Office of the administrator for the courts (360) 705-5210 Mailto:john.oconner@courts.wa.gov



-----Original Message----- From: Sven.Heidorn@CSN.SE [mailto:Sven.Heidorn@CSN.SE] Sent: Wednesday, June 07, 2000 11:56 PM To: DB2-L@RYCI.COM Subject: SV: signal sqlstate



Ben,

if you are on OS/390 the following applies. [...] 6449 70 49_Re: newbie question: How to set restricted access14_Ruth Gramolini26_rgramolini@TAX.STATE.VT.US30_Thu, 8 Jun 2000 13:24:30 -0400670_iso-8859-1 Thanks, that's just what I needed. Ruth ----- Original Message ----- From: Ted Pesta Newsgroups: bit.listserv.db2-l To: Sent: Thursday, June 08, 2000 1:11 PM Subject: Re: newbie question: How to set restricted access



> Ruth, > > The closest you can get is to start DB2 in access mode MAINT. > > -START DB2,PARM(DSNZPAR1),ACCESS(MAINT) > > This will allow only SYSADM and SYSOPR users to logon. > > HTH, > Ted Pesta > AmQUEST, Inc. > > -----Original Message----- > From: Ruth Gramolini [mailto:rgramolini@TAX.STATE.VT.US] > Sent: Thursday, June 08, 2000 11:33 AM > To: DB2-L@RYCI.COM > Subject: newbie [...] 6520 85 38_Re: Carriage return character in a SQL0_23_sjtoeniskoetter@AEP.COM30_Thu, 8 Jun 2000 14:12:20 -0400508_us-ascii If you're on DB2 Unix, Linux, OS/2 or NT use chr(10) for the carriage return:

--------------------------- Command entered ---------------------------- Select 'ACDEFG' concat chr(10) concat '123435353' from sysibm.sysdummy1

------------------------------------------------------------------------

1 ---------------- ACDEFG 123435353

1 record(s) selected.





If you're trying to do this on DB2 OS/390, the only way I know to do it is using unions: [...] 6606 24 24_DB2 Abnormal Termination41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR30_Thu, 8 Jun 2000 15:16:07 -0300397_iso-8859-1 Which are the implications of an IPL without stopping DB2 properly, i.e. without issuing a STOP DB2 command? I have found the following message after our last IPL :

DSNV086E @ DB2 ABNORMAL TERMINATION REASON=00E30078

After the restart there was no thread in indoubt, inflight or inabort state, however, I am wondering if there are other issues related to that error. [...] 6631 316 17_Re: Quiesce Point16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM30_Thu, 8 Jun 2000 09:55:18 -0700526_iso-8859-1 The column name START_RBA in SYSIBM.SYSCOPY can be misleading. The RBA stored in this column has different meanings for different functions. For a LOAD or REORG, it's the RBA before the start of the LOAD utility or RELOAD phase, and before any data is changed. For in Image Copy (ICTYPE I or F), it's "the starting point for all updates since the image copy was taken". In other words, it's the RBA at the end of the Image Copy. So, recovering to the START_RBA of an Image Copy is similar to a RECOVER TOCOPY. [...] 6948 41 19_DDF HELP !!! PLEASE14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 8 Jun 2000 14:34:56 -0400478_- I know I'm being a pain but I really need to try and get this going. This is what I have done so far:

In VTAM: DB2SAPPL VBUILD TYPE=APPL APPLDB2S APPL AUTH=(ACQ),APPC=YES,VPACING=2,EAS=509,PARSESS=YES, X ATNLOSS=ALL,MODETAB=DB2MODES,AUTOSES=1,DSESLIM=50, X DMINWNL=25,DMINWNR=25,SECACPT=ALREADYV, X SRBEXIT=YES,SYNCLVL=SYNCPT

In SYSIBM.SYSLOCATIONS LOCATION - DSNS LINKNAME - APPLDB2S

In SYSIBM.IPNAMES LINKNAME - APPLDB2S IPADDR - mvstech.vnsny.org [...] 6990 59 23_Re: DDF HELP !!! PLEASE13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Thu, 8 Jun 2000 13:43:27 -0500500_US-ASCII Dean, look in the IBM Redbook "WOW DB2 SUPPORTS TCP/IP" it tells you how to set up TCP/IP in OE. Kurt

>>> DMonteva@VNSNY.ORG 06/08/00 01:34PM >>> I know I'm being a pain but I really need to try and get this going. This is what I have done so far:

In VTAM: DB2SAPPL VBUILD TYPE=APPL APPLDB2S APPL AUTH=(ACQ),APPC=YES,VPACING=2,EAS=509,PARSESS=YES, X ATNLOSS=ALL,MODETAB=DB2MODES,AUTOSES=1,DSESLIM=50, X DMINWNL=25,DMINWNR=25,SECACPT=ALREADYV, X SRBEXIT=YES,SYNCLVL=SYNCPT [...] 7050 364 65_Registration of SHRLEVEL CHANGE Image copies (was: Quiesce Point)15_Murley, Michael22_Michael_Murley@BMC.COM30_Thu, 8 Jun 2000 14:30:44 -0500473_ISO-8859-1 Tony,

I agree with you that the column name START_RBA can be misleading for the various ictypes in SYSIBM.SYSCOPY (especially in data sharing, when it is not an RBA at all but an LRSN !).

But the START_RBA value for any image copy represents the point on the log before which no log records are required to effect forward recovery using that copy. Since updates can proceed during a shrlevel change copy, it must be registered near its start. [...] 7415 362 17_Re: Quiesce Point22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM30_Thu, 8 Jun 2000 12:32:09 -0700597_iso-8859-1 If I would have seen you earlier I would have aimed for you.. Hope I didn't startle you by honking... :o))

> -----Original Message----- > From: Provenzola, Tony [SMTP:Tony.Provenzola@NIKE.COM] > Sent: Thursday, June 08, 2000 9:55 AM > To: DB2-L@RYCI.COM > Subject: Re: Quiesce Point > > The column name START_RBA in SYSIBM.SYSCOPY can be misleading. The RBA > stored in this column has different meanings for different functions. For > a > LOAD or REORG, it's the RBA before the start of the LOAD utility or RELOAD > phase, and before any data is changed. For in Image Copy [...] 7778 107 38_Re: Carriage return character in a SQL15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Thu, 8 Jun 2000 15:36:46 -0400438_iso-8859-1 Sorry. I should have mentioned this. This is on OS/390 Version 2.6 with DB2 V5.1.

Thanks Sibimon Philip





-----Original Message----- From: sjtoeniskoetter@AEP.COM [mailto:sjtoeniskoetter@AEP.COM] Sent: Thursday, June 08, 2000 1:12 PM To: DB2-L@RYCI.COM Subject: Re: Carriage return character in a SQL



If you're on DB2 Unix, Linux, OS/2 or NT use chr(10) for the carriage return: [...] 7886 69 28_Re: DB2 Abnormal Termination19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 8 Jun 2000 14:41:56 -0500396_iso-8859-1 Claudio, DB2 OS390 V5. Termination code 00E30078 = DB2 is abended when IRLM is terminated before DB2 is terminated. An entry is written to SYS1.LOGREC. Based on your description, you shouldn't have any data integrity issues. Sounds like any threads that may have been active at the time were resolved by DB2 during restart. DB2 is pretty tolerant about being "rudely" terminated. [...] 7956 391 70_Re: Registration of SHRLEVEL CHANGE Image copies (was: Quiesce Po int)16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM30_Thu, 8 Jun 2000 12:57:08 -0700384_iso-8859-1 You're right. I had tested using a SHRLEVEL REFERENCE, and when I recovered to START_RBA, it used the Image Copy created at that time. But when I ran a SHRLEVEL CHANGE and recovered to START_RBA, it used the prior Image Copy.

Tony Provenzola Nike Database Services BEST Consulting * Phone: (503) 532-0772 * Fax: (503) 532-2618 * Email: Tony.Provenzola@nike.com [...] 8348 233 17_Re: DDF HELP !!!!12_tim malamphy20_timalamphy@YAHOO.COM30_Thu, 8 Jun 2000 12:58:06 -0700390_us-ascii Linda is correct that you need to define the LU to VTAM (even using TCP) and you need to activate the LU with a v net,,,id='vtamlst member',act You had the VTAM lu definition in an earlier message, but I've emptied my mailbox so can't include it here. The 'vtamlst member' is the member in (usually) SYS1.VTAMLST that contains the lu definition. You're getting closer anyway. [...] 8582 386 70_Re: Registration of SHRLEVEL CHANGE Image copies (was: Quiesce Po int)15_Murley, Michael22_Michael_Murley@BMC.COM30_Thu, 8 Jun 2000 15:02:46 -0500439_ISO-8859-1 A correction to the scenario I posted a few minutes ago is shown below. Page 1000 is the one that would reflect an update after the START_RBA if you used TOCOPY.

The main point is still the same.

-----Original Message----- From: Murley, Michael [mailto:Michael_Murley@bmc.com] Sent: Thursday, June 08, 2000 2:31 PM To: DB2-L@RYCI.COM Subject: Registration of SHRLEVEL CHANGE Image copies (was: Quiesce Point) [...] 8969 246 17_Re: DDF HELP !!!!14_Dean Montevago18_DMonteva@VNSNY.ORG30_Thu, 8 Jun 2000 16:03:22 -0400581_iso-8859-1 so close yet so far......

> -----Original Message----- > From: tim malamphy [SMTP:timalamphy@YAHOO.COM] > Sent: Thursday, June 08, 2000 3:58 PM > To: DB2-L@RYCI.COM > Subject: Re: DDF HELP !!!! > > Linda is correct that you need to define the LU to > VTAM (even using TCP) and you need to activate the LU > with a v net,,,id='vtamlst member',act > You had the VTAM lu definition in an earlier message, > but I've emptied my mailbox so can't include it here. > The 'vtamlst member' is the member in (usually) > SYS1.VTAMLST that contains the lu definition. > [...] 9216 43 44_Re: Backup strategy for 1000s of tablespaces11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Thu, 8 Jun 2000 14:15:31 -0700444_iso-8859-1 7000 tables for SAP yikes!! What did they do, model to 5th normal form and then implement?? I'd like to see that data model when it comes out. SAP hasn't published a data model because they're embarrassed.

cliff;-)



-----Original Message----- From: Dennis Raher [mailto:Dennis_Raher@COMPUSERVE.COM] Sent: Wednesday, June 07, 2000 5:36 PM To: DB2-L@RYCI.COM Subject: Backup strategy for 1000s of tablespaces [...] 9260 126 38_Re: Carriage return character in a SQL11_Burch, Todd18_Todd_Burch@BMC.COM30_Thu, 8 Jun 2000 16:32:58 -0500496_ISO-8859-1 The carraige return character on the mainframe is either X'05' or X'15', but mostly likely X'15'. This is from memory (which I'm starting to lose). I lost my "green card" a few years back. Principles of Operation should list it properly though. (I've lost that too) :-)

Todd Burch.

-----Original Message----- From: Philip, Sibimon [mailto:SPhilip@CSXLINES.COM] Sent: Thursday, June 08, 2000 2:37 PM To: DB2-L@RYCI.COM Subject: Re: Carriage return character in a SQL [...] 9387 31 44_Re: Backup strategy for 1000s of tablespaces12_Raymond Bell20_raymondb@NZ1.IBM.COM30_Fri, 9 Jun 2000 09:52:10 +1200360_us-ascii Adrian,

Firstly, my condolences on running SAP. Not that I think the product is carp (spot the deliberate spelling mistake) because I've never used it. It just seems that the people at SAP haven't really thought out some of the DB2-related issues too well. I'm basing this on the number of SAP-related problems you guys seem to be having. [...] 9419 78 28_Re: DB2 Abnormal Termination11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Thu, 8 Jun 2000 15:21:35 -0700528_iso-8859-1 Starting a IPL without stopping DB2 sound pretty brutal and risky to me. I'd grab a stick and have a little talk with your operators about IPL procedures. In our shop DB2 is one of the last task to be stopped. We make sure all the addresspace with threads to DB2 are stopped first (ie. batch pgms, TSO, CICS, etc.) and don't start a IPL until DB2 has stopped. I've told the operators to be patient because sometime DB2 takes a while to stop and to call me it they thinks its taking to long. In the past I've had [...] 9498 26 16_DB2 Partitioning12_Pat Darienzo27_pdarienzo@KEYSPANENERGY.COM30_Thu, 8 Jun 2000 18:27:36 -0500506_- Pretty standard question here: We have a ten year old DB2 database with over 100 tables that were defined similarly with ten partitions and range in volume from 2-12 million rows. We anticipate it may need to triple in size.

Because the partitioning was done on a one-byte character field (currently using A-J), we are essentially limited to 36 partitions. In addition, the data distribution was designed to encourage a crude, but effective, version of query parallellism and reduce locking. [...] 9525 16 22_24 x 7 Backup/Recovery0_20_bjnigh@HOUSEHOLD.COM30_Thu, 8 Jun 2000 17:04:50 -0700493_us-ascii I am still confused as to how others take backups and prepare for disaster recovery when a DB2 application has to be available for the users 24 by 7. Any suggestions?

Thanks for all the prior comments about quiesce and shrlevel change.

================================================ 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. 9542 21 26_Re: 24 x 7 Backup/Recovery20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM28_Thu, 8 Jun 2000 20:39:37 EDT627_US-ASCII If you are interested in a Tool that will Simplfy and Automate the generations of the Jobstream JCL and CNTL to recover your BSDS (also create NEWLOG/DELETE Active Logs cards, Condition Restart Control Record), Catalog and Directory. It will also automate the generations of the Jobstream to recover your User Tablespaces at your Disaster Recovery Site (TOCOPY, TORBA, TablespaceSET TOCOPY/TORBA) using the same method it do at your Local Site. Type in only One Tablespace and it will display all tablespaces Quiesed in the group with RBA numbers and Timestamp and you just Pick and Chose. For sample ISPF Panels [...] 9564 51 26_Re: 24 x 7 Backup/Recovery13_Martin Kenney25_martin.kenney@RAILINC.COM30_Thu, 8 Jun 2000 21:27:11 -0400558_us-ascii We take image copies with a SHRLEVEL CHANGE and then take a quiesce point for a point in time recovery. Generally in regards to disaster recovery we will recover from the last full image copy and apply all of the logs to the most recent point prior to the disaster. Copying your archive logs to DASD will greatly speed up recovering from logs as multiple recovers can read from an archive log on DASD but not on tape. This procedure is documented in the DB2 for OS/390 Version 5 Administration Guide page 4-195 step 6. I hope this answers your [...] 9616 14 16_DB2 DBA position12_Wallace Shah21_upajobs@BELLSOUTH.NET30_Thu, 8 Jun 2000 20:34:57 -0500308_- Will a company have difficulty filling a position if they are looking for 3 years experience and offering between 70-80k. This particular company has been searching for some time and it seems people shy away due to salary issues. What is a realistic salary for someone with this amount of experience. [...] 9631 168 37_Re: TSO/ISPF/Rexx Support for DB2/39011_rick creech18_ykcirc@HOTMAIL.COM28_Thu, 8 Jun 2000 18:52:36 PDT697_- I could be wrong, but I think there is no additional cost. Read about rexx usage and see the program directory at the following site: http://www-4.ibm.com/software/data/db2/os390/v5books.html

hth, Rick Creech



>From: Brendan Friel >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: TSO/ISPF/Rexx Support for DB2/390 >Date: Thu, 8 Jun 2000 12:11:56 -0500 > >Three part question : > >Is there any additional licensing cost involved with installing REXX >support >under V5 ? >Is the installation something that would involve a lot of effort on the >part >of our system programmers, DBAs ? >If it was in place, [...] 9800 23 21_Re: TS Status changes7_Sanjeev19_Sanjeev@INTERRA.COM30_Fri, 9 Jun 2000 09:56:34 +0530429_iso-8859-1 Hi Rohn, Got all the informations.After the table is altered and put into UT status(by DBA-Xpert JCL) i presume you have not executed the other steps in JCL generated by DBA-Xpert ,instead you submitted runstat with shrlevel reference after changing the status to RW.

So the final point is that i do not see any problem in changing the status to RW from UT.Let us see if others have to say something else. [...] 9824 63 9_DB2 & SMS5_ricci20_ricci@MS14.HINET.NET30_Fri, 9 Jun 2000 13:13:25 +0800354_big5 Dear all : DB2 system Catalog and Directory tablespace should be managed by SMS ?

I am a storage admintrator in a banking IT center. The DB2 DBA team asked DB2 all tablespace put in SMS control. I am wonder is there any consideration ? (Mangement,performance,Storage group...etc.)

Any answer will appreciate.



RICCI HSIAO 9888 74 44_Re: Backup strategy for 1000s of tablespaces23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Fri, 9 Jun 2000 06:28:15 +0100316_iso-8859-1 ....well and DBA worth his money should want a datamodel at the start of a project .. i've been asking SAP for a year now .. and only recenlty I find out there isn't one.

and all the RI is in the app .. so that poggers you aswell. not that I like RI in DB2 .. but then that is another matter. [...] 9963 54 46_Re: Reorganizing all Partitions simulatneously14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU30_Fri, 9 Jun 2000 11:41:24 +1000576_us-ascii Michael, If your going to do this don't forget to rebind all the invalidated packages that were using it and check that the access paths haven't changed.

Paul.

---------------------- Forwarded by Paul A Redhead/CorpServ/qdot/au on 09/06/2000 11:38 ---------------------------



Michael Vanner on 08/06/2000 22:44:19

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Paul A Redhead/CorpServ/qdot/au) Subject: Re: Reorganizing all Partitions simulatneously [...] 10018 79 47_Re: Advice on Order of keys in clustering index15_Douwe van Sluis20_d.b.vansluis@KPN.COM30_Fri, 9 Jun 2000 07:41:07 +0200367_- Hi Gina,

Make sure that, if there are more than 2 keys in the index and the cardinality of the firstkeycard is very low (or even 1), you generate statistics for the rest of the index keys. This will help DB2 determine the best accespath and especially how to deal with prefetching. If you always access the tables by the full key than this is no issue. [...] 10098 119 13_Re: DB2 & SMS25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG30_Fri, 9 Jun 2000 13:59:54 +0800466_iso-8859-1



Hi,

There is an IBM red book on this topic. Book id is SG245462. You will find it useful and so will your DBA.

Regards







(Embedded image moved DB2 Data Base Discussion List to file: (Tel: ) pic31556.pcx) 09/06/2000 01:13 PM







Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: bcc: Subject: DB2 & SMS [...] 10218 68 28_Re: DB2 Abnormal Termination4_IBM116_IBM1@UBIL.COM.TR30_Fri, 9 Jun 2000 09:59:06 +0300579_iso-8859-9 although not in a OS/390 system, we had Catalog bit-map allocation table corruption following this, just 2 weeks ago (it's been a nightmare zapping the catalog...).

since it's a freak problem, it might be advisable to perform a health-check if you get a chance!

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@ubil.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...] 10287 22 26_Re: 24 x 7 Backup/Recovery9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM30_Fri, 9 Jun 2000 08:35:38 +0100395_us-ascii There is an old Redbook which deals with this subject. I can't find it on my Redbooks CDs, but the number is GG24-3601 and it might still be available to order. There is also a new book which I have just found on the Redbooks website www.redbooks.ibm.com called. DB2 UDB for OS/390 and Continuous Availability , SG24-5486-00. I haven't read it but it seems to cover what you want. [...] 10310 45 66_droping of DB2 Catalog and directory tables - SYSUTIL and SYSLGRNG28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM28_Fri, 9 Jun 2000 00:42:22 PDT439_- Don't lump these two ideas together. The evolution of SYSLGRNG and SYSUTIL are *NOT* the same situation. First, you need to make sure when you are talking about TABLESPACES (and therefore VSAM datasets) and when you are talking about TABLES.

There is one table, SYSLGRNX, in tablespace DSNDB01.SYSLGRNX. The old table, SYSIBM.SYSLGRNG, in tablespace DSNDB01.SYSLGRNG is obsolete, as is its VSAM dataset (in recent releases). [...] 10356 212 37_Re: TSO/ISPF/Rexx Support for DB2/3909_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Fri, 9 Jun 2000 08:58:38 +0100310_us-ascii There is no additional licensing cost. It is a simple product to install (using SMPE). Developers will find it a relatively easy interface to use although (in my view) the examples in the REXX Language Support document could be better . The use of cursors for non-set processing is a little odd. [...] 10569 136 30_Re: Catch 22 on Stogroup Auths12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Fri, 9 Jun 2000 08:59:00 +0100310_iso-8859-1 I seem to recall that changing VCAT's is a bit tricky because DB2 'forgets' the old one so it tries to drop and recreate the new one. I would advise caution.

Colin Allen ---------- From: Billings, Linda To: DB2-L@RYCI.COM Subject: Re: Catch 22 on Stogroup Auths Date: 08 June 2000 15:34 [...] 10706 191 37_Re: TSO/ISPF/Rexx Support for DB2/39012_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Fri, 9 Jun 2000 09:20:00 +0100517_iso-8859-1 Yes, IBM are throwing in lots of goodies free of charge these days, REXX support, visual explain, estimator, control centre, enhanced utilities (oops)

;-)

Colin Allen. ---------- From: rick creech To: DB2-L@RYCI.COM Subject: Re: TSO/ISPF/Rexx Support for DB2/390 Date: 09 June 2000 02:52

I could be wrong, but I think there is no additional cost. Read about rexx usage and see the program directory at the following site: http://www-4.ibm.com/software/data/db2/os390/v5books.html [...] 10898 183 30_Re: Catch 22 on Stogroup Auths9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Fri, 9 Jun 2000 09:21:41 +0100446_us-ascii Procedures about changing the hlq (i.e. VCAT of stogroup) can be found in the Systems Admin Guide: 2.12.10.3.2 Changing User Managed Objects to Use the New Qualifier. 2.12.10.3.3 Changing DB2-Managed Objects to use the New Qualifier.

Used these procedures yesterday. Kind Regards, Andy Hunt - Scottish And Southern Energy







"Allen, Colin" on 09/06/2000 08:59:00 [...] 11082 57 48_BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 9 Jun 2000 11:10:05 +0200747_iso-8859-1 Hello list, need you help:

The following message occurs during a simple bind package: DSN BIND PACKAGE (PKEWTB15) OWNER(EWT15) QUALIFIER(EWT15) MEMBER(E180043) VALIDATE(BIND) ISOLATION(CS) RELEASE(COMMIT) EXPLAIN(NO) DSNX200I -DB2T BIND SQL ERROR USING EWT15 AUTHORITY PLAN=(NOT APPLICABLE) DBRM=E180043 STATEMENT=24108 SQL CODE=-151 TOKENS=EWT15.DEW23.DEW23_AGS CSECT NAME=DSNXOOP RDS CODE=-400

The background and the reasons why we don't unterstand this -151: 1. The DB2 for OS/390 Version 4 subsystem DB2T exists. 2. The collection named PKEWTB15 with a owner EWT15 exists (found in SYSPACKAGE). 3. This owner has the right to bind packages in this collection. 4. A table DEW23 exists with a creator EWT15. Inside [...] 11140 41 37_Re: TSO/ISPF/Rexx Support for DB2/39014_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Fri, 9 Jun 2000 10:07:39 +0100384_iso-8859-1 Thanks to Rick Creech for your link to IBM's site: http://www-4.ibm.com/software/data/db2/os390/v5books.html - I've now got the FMID info.

Thanks also to Andy Hunt for the APAR info too. I have already looked for DSNREXX using ISRFIND, and haven't found it. The worrying thing is the "Routine not found" message when I call rxsubcom('add','dsnrexx','dsnrexx'). [...] 11182 75 44_Re: Backup strategy for 1000s of tablespaces13_Adrian Savory24_adrian.savory@ZURICH.COM30_Fri, 9 Jun 2000 10:43:31 +0100604_us-ascii Raymond,

This might surprise you but I actually enjoy working with SAP (sad I know!). It forces you to look at problems in a slightly different way, which means you end up understanding a bit more about DB2.

I agree with you about SAP's 'immaturity' for DB2, but things have improved significantly in the last year. The ironic thing is that the problem I am experiencing with managing so many DB2 objects was brought about by SAP's positioning to run R/3 more efficiently on DB2. When it was first ported from Oracle nearly everything was in multi-table tablespaces. From one [...] 11258 143 52_Re: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE0_18_mebert@AMADEUS.NET30_Fri, 9 Jun 2000 11:57:46 +0100349_us-ascii What is the full SQL statement (UPDATE...) causing the error? Are you sure EWT15.DEW23 is not a view? If it is, what is the full definition? If it is a SELECT *, was column DEW23_AGS added to the base table after the view definition?

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 11402 15 43_Advice on Order of keys in clustering index12_Fertaki Gina20_GFertaki@EUROBANK.GR30_Fri, 9 Jun 2000 12:59:16 +0300318_ISO-8859-7 Thank you for all your answers.

Best regards, Gina Fertaki

================================================ 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. 11418 67 26_Re: 24 x 7 Backup/Recovery13_Adrian Savory24_adrian.savory@ZURICH.COM30_Fri, 9 Jun 2000 11:00:47 +0100329_us-ascii If you are talking about 'real' 24*7 then you have no window for SHRLEVEL REFERENCE copies, snapshots or anything else that interferes with the system availability. If you are dealing with a large and busy application I would include QUIESCE within that category, as the QUIESCE can be too disruptive, or time out. [...] 11486 111 26_Re: 24 x 7 Backup/Recovery14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Fri, 9 Jun 2000 11:32:11 +0100546_iso-8859-1 A RECOVER to a point in time would be cool! We have a batch suite which updates many tables. Should the batch fail at any time, we would like to recover to a certain point, depending on where/when/other criteria. It's not feasible to image copy before each suite, and recover to that, nor to quiesce each table and recover to that, so we quiesce an empty tablespace to get an RBA at the beginning of the suite, and recover to that. It works, but if we could recover to a timestamp before the start of execution, that'd be better. [...] 11598 385 17_Re: Quiesce Point12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Fri, 9 Jun 2000 13:40:16 +0200555_x-user-defined Hi, Similar but not the same. TOCOPY - only the backup file is used. STARTRBA - DB2 peeks at the logs. (If they're migrated to tape - you get a mount request for it).

Isaac Yassin

"Killen, Martin W - CNF" wrote: > > If I would have seen you earlier I would have aimed for you.. Hope I didn't > startle you by honking... :o)) > > > -----Original Message----- > > From: Provenzola, Tony [SMTP:Tony.Provenzola@NIKE.COM] > > Sent: Thursday, June 08, 2000 9:55 AM > > To: DB2-L@RYCI.COM > > Subject: Re: Quiesce Point > > > > [...] 11984 134 52_AW: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 9 Jun 2000 12:46:50 +0200349_iso-8859-1 Dr. Ebert, here are the answers following to your questions: >>> Are you sure EWT15.DEW23 is not a view? YES. >>> If it is, what is the full definition? See above. >>> If it is a SELECT * - NO., >>> was column DEW23_AGS added to the base table after the view definition? No. Like I said it it is a little bit mysterious............. [...] 12119 121 56_Re: AW: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE0_18_mebert@AMADEUS.NET30_Fri, 9 Jun 2000 12:55:59 +0100387_us-ascii Now only the answer to my first question is missing; I put it first because it was the most important... The tricky part now is probably identifying the right statement. I assume the STMTNO refers to the precompiler output line number?? (I don't do static SQL programs).

MfG, ME.





From: "Peter, Georg" on 09/06/2000 10:46 GMT [...] 12241 17 32_Convert DDL DB2/OS390 to UDB/AIX0_23_duerr_jacobsg@WESTLB.DE30_Fri, 9 Jun 2000 13:17:00 +0100428_us-ascii Hello,

I'm looking for a way to convert DB2-DDL from DB2 on OS/390 to UDB on AIX. Does someone of you has a nice REXX, QMF-Proc etc. for this need?

Thank you Guido

================================================ 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. 12259 74 44_Re: Backup strategy for 1000s of tablespaces13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Thu, 8 Jun 2000 20:45:27 -0500455_iso-8859-1 I was at IDUG2000 Dallas, TX and a similar discussion came up in the SIG for ERPs which I attended. One suggestion was to use SNAPSHOT if you have RVAs if you got it. Should only takes seconds/few minutes for that. Our shop has used SNAPSHOTed for non-DB2 purposes and it runs like magic. Also, I think IBM maybe looking at some "answers" to help in this type of user requirement. But I do not recall much more without referring to notes. [...] 12334 30 20_Re: DB2 DBA position11_Bill Tucker22_BTUCKER@CCGROUPNET.COM30_Fri, 9 Jun 2000 07:55:46 -0400480_US-ASCII The salary is in line (and even to the top of the range) with the experience level. Bill Tucker

>>> Wallace Shah 06/08/00 09:34PM >>> Will a company have difficulty filling a position if they are looking for 3 years experience and offering between 70-80k. This particular company has been searching for some time and it seems people shy away due to salary issues. What is a realistic salary for someone with this amount of experience. [...] 12365 28 37_table structure changes - how often ?18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM30_Fri, 9 Jun 2000 07:57:44 -0400374_iso-8859-1 What is the impact of table structure changes at your shop? How often do you make them? We're curious about how others handle these because we are spending a lot of time and effort doing table changes. I suppose we are now paying the price for insufficient database design, but surely we're not the only shop that didn't get everything right the first time. [...] 12394 62 41_Re: table structure changes - how often ?9_Jim Leask27_jim.leask@RS-COMPONENTS.COM30_Fri, 9 Jun 2000 12:59:52 +0100428_iso-8859-1 DEVL - initial development STST - system test USER - user/integration test

FNCL - separate test area for critical or complex projects

Currently 4 but there are moves afoot for a training environment as well.

Jim.

-----Original Message----- From: GRESHAM, DEBORAH B [mailto:DGRESHAM@SCANA.COM] Sent: 09 June 2000 12:58 To: DB2-L@RYCI.COM Subject: table structure changes - how often ? [...] 12457 74 13_Re: DB2 & SMS0_17_sjvagnier@AEP.COM30_Fri, 9 Jun 2000 08:18:54 -0400482_us-ascii



Hi Ricci,

NO, I would not let SMS manage the DB2 System Catalog and Directory Tablespaces due to potential performance issues. We use SMS to manage application objects only.

Regards... Steve Vagnier









ricci @RYCI.COM> on 06/09/2000 01:13:25 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 12532 34 20_Re: DB2 DBA position11_Tina Hilton21_Tina.Hilton@BMSUS.COM30_Fri, 9 Jun 2000 07:16:22 -0500586_- You also need to take into consideration the location. Salaries tend to be higher where the cost of living is higher (or at least they should be!), so there can be no blanket statements about what is an appropriate salary.

> -----Original Message----- > From: Bill Tucker [SMTP:BTUCKER@CCGROUPNET.COM] > Sent: Friday, June 09, 2000 6:56 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 DBA position > > The salary is in line (and even to the top of the range) with the > experience > level. > Bill Tucker > > >>> Wallace Shah 06/08/00 09:34PM >>> > Will [...] 12567 55 20_Re: DB2 DBA position23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Fri, 9 Jun 2000 08:33:30 -0400611_- It really depends on the geographic location and the other benefits company offers

Sanjay

> -----Original Message----- > From: Bill Tucker [SMTP:BTUCKER@CCGROUPNET.COM] > Sent: Friday, June 09, 2000 7:56 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 DBA position > > The salary is in line (and even to the top of the range) with the > experience > level. > Bill Tucker > > >>> Wallace Shah 06/08/00 09:34PM >>> > Will a company have difficulty filling a position if they are looking for > 3 > years experience and offering between 70-80k. This particular company has > [...] 12623 60 52_Re: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM30_Fri, 9 Jun 2000 08:35:10 -0400668_gb2312

If applicable, also verify that there are no Synonyms or Aliases for the table (for this Auth-Id).

-- Lockwood Lyon Amway Corporation





Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE



What is the full SQL statement (UPDATE...) causing the error? Are you sure EWT15.DEW23 is not a view? If it is, what is the full definition? If it is a SELECT *, was column DEW23_AGS added to the base table after the view definition? [...] 12684 43 20_Re: DB2 DBA position12_craig patton21_prgpatton@HOTMAIL.COM28_Fri, 9 Jun 2000 05:50:18 PDT352_- Wallace,

It depends (of course) on where you are located. That DOES seem to be the average price range, but I doubt that it is enough to intice someone away from another company (where they already make that amount). AND it appears that there is a shortage of qualified DBAs so the prices are going to have to go up to get some movement. [...] 12728 62 13_AW: DB2 & SMS12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 9 Jun 2000 14:50:59 +0200382_iso-8859-1 Steve, I agree with you.

In our IT centers MOST of the application objects are sms managed.

Some application objects are not sms managed, e.g. a resident registration & information system, a police application and so on.

But Catalog and directory are strictly not sms managed. The reason: 1. performance 2. performance 3. performance and so on. [...] 12791 146 52_Re: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 9 Jun 2000 07:52:16 -0500600_gb2312 Hi Georg, As follow up to Lockwood's suggestion I'd also take a look at SYSTABAUTH and SYSCOLAUTH to see if any games are being played.

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other [...] 12938 217 37_Re: TSO/ISPF/Rexx Support for DB2/39019_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 9 Jun 2000 07:54:54 -0500599_iso-8859-1 jeeeeeeeeeeeeeeeeeeeezzzzzzzzzzzzzzzzz

Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 13156 145 26_Re: 24 x 7 Backup/Recovery19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 9 Jun 2000 07:58:56 -0500630_iso-8859-1 Marcus, The assumption to your comment would be that NO onlines were updating the same tables while the "batch suite" was running.

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, [...] 13302 65 20_Re: DB2 DBA position13_penny andrews19_pzandrews@YAHOO.COM30_Fri, 9 Jun 2000 06:03:19 -0700636_us-ascii Esteemed List...

Here is a good salary survey which might help.



http://www.datamasters.com/survey.html



Penny --- Tina Hilton wrote: > You also need to take into consideration the > location. Salaries tend to be > higher where the cost of living is higher (or at > least they should be!), so > there can be no blanket statements about what is an > appropriate salary. > > > -----Original Message----- > > From: Bill Tucker [SMTP:BTUCKER@CCGROUPNET.COM] > > Sent: Friday, June 09, 2000 6:56 AM > > To: DB2-L@RYCI.COM > > Subject: Re: DB2 DBA position > > > > The [...] 13368 182 26_Re: 24 x 7 Backup/Recovery14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Fri, 9 Jun 2000 14:03:13 +0100683_iso-8859-1 Correct!

Marcus

-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: 09 June 2000 13:59 To: DB2-L@RYCI.COM Subject: Re: 24 x 7 Backup/Recovery



Marcus, The assumption to your comment would be that NO onlines were updating the same tables while the "batch suite" was running.

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this [...] 13551 94 37_Re: TSO/ISPF/Rexx Support for DB2/39010_Tom Taylor17_ttaylor@CHUBB.COM30_Fri, 9 Jun 2000 09:16:41 -0400447_us-ascii Marcus

After the "APPLY" is completed you will notice that 'RXSUBCOM" module is in '???.SDSNLOAD' and has a ALIAS of DSNREXX.

When you run the REXX example in the book (some of them are wrong by the way) you must be steplibed or linklisted to the SDSNLOAD library.

Also... After the execution of a rexx statement and you get "'RC(-1)"... I believe this indicates that there is a 'REXX' error and not a DB2 error [...] 13646 34 20_Re: DB2 DBA position12_Mike O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV30_Fri, 9 Jun 2000 09:03:28 -0400722_US-ASCII That would be OK for someplace in the boonies. Anything near a metropolitan area (within 50 miles) would demand more.

Good starting place... needs perks and incentives too.



______________________________ Reply Separator _________________________________ Subject: DB2 DBA position Author: "DB2 Data Base Discussion List" at smtplink Date: 6/8/00 9:34 PM



Will a company have difficulty filling a position if they are looking for 3 years experience and offering between 70-80k. This particular company has been searching for some time and it seems people shy away due to salary issues. What is a realistic salary for someone with this amount of experience. [...] 13681 154 52_Re: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Fri, 9 Jun 2000 08:14:36 -0500569_gb2312 One other suggestion -- before digging too deep, it might be worth your time to pull the update statement in question out of the program and try running it in SPUFI (or QMF, etc). This will at least take the bind out of the picture and verify it's really an issue with the SQL statement/table. In the past I've spent quite awhile researching a problem with an SQL statement only to suddenly discover "Ohhh, it's THAT statement..." (or THAT table, program, DBRMLIB, etc). At least verify that you are getting the error on the statement you think you are. If [...] 13836 34 20_Re: DB2 DBA position12_Jim Harrison12_jimh@QIS.NET30_Fri, 9 Jun 2000 09:27:02 -0400655_us-ascii Even though your reply address says treasury.gov, you're obviously not a fed. That range is pretty much the top end for feds, unless you get a lobotomy and go into management.

At 09:03 AM 6/9/00 -0400, Mike O'Neill wrote: > That would be OK for someplace in the boonies. Anything near a > metropolitan area (within 50 miles) would demand more. > > Good starting place... needs perks and incentives too. > > >______________________________ Reply Separator >_________________________________ >Subject: DB2 DBA position >Author: "DB2 Data Base Discussion List" at smtplink >Date: 6/8/00 9:34 PM > > >Will a company have [...] 13871 102 13_Re: DB2 & SMS9_Jim Leask27_jim.leask@RS-COMPONENTS.COM30_Fri, 9 Jun 2000 14:19:18 +0100460_iso-8859-1 We SMS manage the Catalog and Directory (and all other DB2 datasets) but the ACS rules within SMS place the tablespaces on a volume of their own and the indexes on another volume of their own.

All application tablespaces are targeted to another set of volumes and the indexes are targeted to yet another set of volumes. And also coded is a few dataset level exceptions for datasets which have caused us performance problems in the past. [...] 13974 85 13_Re: DB2 & SMS12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Fri, 9 Jun 2000 08:28:17 -0500372_iso-8859-1 Georg, What process do you utilize to exclude the catalog and directory? We are just now starting to implement SMS and would very much appreciate any direction/assistance you can give us.

john

-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Friday, June 09, 2000 7:51 AM To: DB2-L@RYCI.COM Subject: AW: DB2 & SMS [...] 14060 98 17_Re: AW: DB2 & SMS22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 9 Jun 2000 09:38:28 -0400371_iso-8859-1 Typically DFSMS is involved while creating new data sets or adding extents to existing data sets.

It has been my experience that once a DB2 subsystem has "stabilized" as far as the size and location of the directory/catalog data sets there isn't much, if any, data set creation/extents activity. How does DFSMS cause poor performance in this case? [...] 14159 45 8_cics/db213_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET30_Fri, 9 Jun 2000 09:44:26 -0400144_us-ascii Since db2 does not allow commits in cics...(or maybe other way around)... does cics syncpoint force a commit in db2????

thanks.. 14205 37 12_Re: cics/db219_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 9 Jun 2000 08:49:12 -0500564_iso-8859-1 yes

Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 14243 26 19_Monitoring Datasets12_Mike O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV30_Fri, 9 Jun 2000 09:47:47 -0400420_US-ASCII Hi,

We are new to DB2, and are trying to set up some automated warnings about dataset performance, such as when extents are taken, the number of extents, and percent full on databases. Where is information kept on database file extents, and percent full?

I've looked through the DB2 catalog, and can't find this information, yet the DB2 Admin tools product provides it (manually) in a query. [...] 14270 17 6_Thanks14_Dean Montevago18_DMonteva@VNSNY.ORG30_Fri, 9 Jun 2000 09:55:52 -0400503_- To all those who responded to my pleas for DDF help, thank you. It still doesn't work, I have PMR's open with IBM. I've gone over the install doc quite a few times, everything looks ok, but it's still broke !!!

Thanks for your help and suggestions Dean

================================================ 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. 14288 159 17_Re: AW: DB2 & SMS0_17_sjvagnier@AEP.COM30_Fri, 9 Jun 2000 10:02:05 -0400590_us-ascii



A long time ago when we were first implementing SMS, I had this same discussion with IBM's DB2 support. At the time, IBM recommended not to let SMS control the DB2 Catalog and directory. I know that since that time, SMS has improved in it's handling of dataset's, I just elected to continue to not let SMS handle the DB2 Catalog and Directory datasets. Why ??? Because as a Systems Administrator, I am in more control of where I want the Catalog and Directory datasets to reside on which volumes instead of having to interface with the DASD Administrators all [...] 14448 138 37_Re: TSO/ISPF/Rexx Support for DB2/39014_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Fri, 9 Jun 2000 15:00:48 +0100435_iso-8859-1 Thanks Tom, that's precisely what I needed to know... ...now it's up to the sysprogs...

Marcus

-----Original Message----- From: Tom Taylor [mailto:ttaylor@CHUBB.COM] Sent: 09 June 2000 14:17 To: DB2-L@RYCI.COM Subject: Re: TSO/ISPF/Rexx Support for DB2/390



Marcus

After the "APPLY" is completed you will notice that 'RXSUBCOM" module is in '???.SDSNLOAD' and has a ALIAS of DSNREXX. [...] 14587 31 52_Re: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE16_Friemel, Norbert24_Friemel@RRZ-KARLSRUHE.DE30_Fri, 9 Jun 2000 16:13:53 +0200578_iso-8859-1 > Any idea why this simple Bind Package runs into a SQLCODE -151 ? >

... aah, that application! ;-))

Column DEW23_AGS is part of the primary key (and part of a foreign key) and the search-condition selects more then one row (specifies only 1 column of the 5-column primary key)

From SC26-3270-00 (DB2 for MVS/ESA V4 SQL Reference): The search condition is applied to each row of the table or view and the updated rows are those for which the result of the search-condition is true. If a column to be updated is part of a primary key, [...] 14619 55 41_Re: table structure changes - how often ?19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Fri, 9 Jun 2000 10:02:02 EDT527_us-ascii Hi,

Over the last four years we have designed, developed, implemented and are now maintaining an application that has had its fair share of table structure changes. We have two levels of impact analysis. On the one hand we have Change Man (a software migration tool), which runs an audit that tells us which programs are affected by the changed DCLGEN. On the other hand we use BMCDB2 Change manager, which has an Analysis component that tells us which packages could be affected by the change on a table. [...] 14675 55 52_Re: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM30_Fri, 9 Jun 2000 10:24:15 -0400454_us-ascii Wow! I am impressed. How on earth did you remember/find that?!

-- Lockwood Lyon Amway Corp





Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE



> Any idea why this simple Bind Package runs into a SQLCODE -151 ? > [...] 14731 29 12_Re: cics/db220_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 9 Jun 2000 10:25:10 -0400493_iso-8859-1 Sure... CICS is coordinator in two-phase commit. DB2 COMMITS are not allowed. CICS SYNCPOINT is needed.

CICS SYNCPOINT forces commit across other resource managers like DB2, CICS etc.

-----Original Message----- From: Jimmy Willett [SMTP:Jimmy.Willett@NCMAIL.NET] Sent: Friday, June 09, 2000 9:44 AM To: DB2-L@RYCI.COM Subject: cics/db2

Since db2 does not allow commits in cics...(or maybe other way around)... does cics syncpoint force a commit in db2???? [...] 14761 33 15_AST's & locking17_Patricia Candella21_pcandella@METLIFE.COM30_Fri, 9 Jun 2000 10:30:58 -0400469_us-ascii List, UDB V6 / Unix

We have created our first AST over table objects in a data warehouse; it was created using the "data initially deferred refresh deferred" options. When we run the Refresh Table statement, the process locks people out that need to get the system table information. If we try to kill their locked threads, DB2 stops all processes, including the refresh table statement. We then have to stop db2, and restart in order to clean up. [...] 14795 56 23_Re: Monitoring Datasets20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 9 Jun 2000 10:31:09 -0400568_us-ascii Most of the folks who don't have 3rd party products usually write CLIST or REXX to do LISTCAT on underlying vsam to get this information. We load this into DB2 table and it is available in our intranet web.

Lately IBM has introduced a new IFCID 258 along with STATISTICAL traces. This trace record is cut every time a vsam lds takes an extent. It provides current extent, # of volumes, size before extent , size after extent, max size allowed for that dataset, max extent allowed for that dataset etc etc. You can have your own routine to monitor [...] 14852 34 14_SQL -904 Error10_ajay kumar19_db2v5r1@HOTMAIL.COM28_Fri, 9 Jun 2000 20:04:51 IST504_- Hi,

I defined a New storage group and XXXXX with VCAT value as RNDCAT and assigned a SMS volume to the group and created RNDCAT alias

I defined a Test database YYYYY , using XXXXX storage group. While creating a Tablespace, it abended with -904 sql error.

the SQL error detail :

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D70025, TYPE OF RESOURCE 00000220, AND RESOURCE NAME RNDCAT.DSNDBC.YYYYY.tsname.I0001.A001 [...] 14887 67 18_Re: SQL -904 Error9_Jim Leask27_jim.leask@RS-COMPONENTS.COM30_Fri, 9 Jun 2000 15:39:12 +0100439_iso-8859-1 Hi Karthik,

There should be extra messages prior to this one in your syslog which will give more clues, but I usually get this when I create a stogroup as SMS managed but the dataset name according to SMS is not included in its ACS routines or vice-versa.

Jim.

-----Original Message----- From: ajay kumar [mailto:db2v5r1@HOTMAIL.COM] Sent: 09 June 2000 21:05 To: DB2-L@RYCI.COM Subject: SQL -904 Error [...] 14955 47 18_Re: SQL -904 Error22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM30_Fri, 9 Jun 2000 07:45:11 -0700546_- Are you sure you have enough room on your volume to create your dataset?

> -----Original Message----- > From: ajay kumar [SMTP:db2v5r1@HOTMAIL.COM] > Sent: Friday, June 09, 2000 1:05 PM > To: DB2-L@RYCI.COM > Subject: SQL -904 Error > > Hi, > > I defined a New storage group and XXXXX with VCAT value as RNDCAT and > assigned a SMS volume to the group and created RNDCAT alias > > I defined a Test database YYYYY , using XXXXX storage group. > While creating a Tablespace, it abended with -904 sql error. > > the SQL error detail : [...] 15003 73 18_Re: SQL -904 Error12_John Cameron26_JCameron@MSI-INSURANCE.COM30_Fri, 9 Jun 2000 09:44:29 -0500419_us-ascii The way security is set up here, I would need to have our RACF administrator grant DB2 the ability to create/update datasets starting with RNDCAT as the high-level qualifier ... could that be it ?

John Cameron jcameron@msi-insurance.com





ajay kumar cc: Sent by: DB2 Subject: SQL -904 Error Data Base Discussion List [...] 15077 35 26_Stored Procedures Language11_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US30_Fri, 9 Jun 2000 10:01:17 -0500540_- Greetings List:

We have heard that there is a stored procedure language that you can write stored procedures in. Our understanding is that this language can be substituted for other languages that might alternatively be used like C or COBOL. We have also heard that this stored procedure language can be back leveled into version 5 by applying certain PTFs. Does anyone know of a publication that might cover this new language? Or even if the information I cited above is correct? I appreciate any information you can supply. [...] 15113 23 12_DB2 V5 to V60_29_STANLEY_GOODWIN@MECH.DISA.MIL30_Fri, 9 Jun 2000 11:04:23 -0400558_us-ascii For those people out there that have migrated to V6, I am interested in knowing if you actually saw any improvements in the way of Query performance, CPU reduction, utility etc.



Thanks. Stan Goodwin DAC MBG DB2 Support

Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335

================================================ 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. 15137 218 37_Re: TSO/ISPF/Rexx Support for DB2/39011_rick creech18_ykcirc@HOTMAIL.COM28_Fri, 9 Jun 2000 08:09:26 PDT540_- Here is a sample rexx that may be useful for you if you are just getting started: /* THIS IS A DB2 REXX FOR FETCHING ROWS FROM A CURSOR*/ PARSE ARG SSID "SUBCOM DSNREXX" IF RC THEN S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX') /* */ /* CONNECT TO THE DB2 SUB-SYSTEM */ /* */ ADDRESS DSNREXX "CONNECT" SSID IF SQLCODE ¬= 0 THEN SAY 'ADDRESS FAILED' OUTNAME = 'Z' OUTNO = 'ZZZ' /* */ /* SET UP THE SQL STATEMENT */ /* */ SQLSTMT = , 'SELECT DEPTNAME,DEPTNO' , 'FROM CFC6847.TABLE01 ORDER BY DEPTNAME' /* */ /* DECLARE THE CURSOR */ /* */ [...] 15356 60 30_Re: Stored Procedures Language22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 9 Jun 2000 11:33:10 -0400735_- Go to http://www-4.ibm.com/software/data/db2/os390/

Go to Download & select SQL Procedures & Stored Procedure Builder





Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com

> ---------- > From: Clark, Tony[SMTP:Tony.Clark@TWC.STATE.TX.US] > Sent: Friday, June 09, 2000 11:01 AM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Stored Procedures Language > > Greetings List: > > We have heard that there is a stored procedure language that you can write > stored procedures in. Our > understanding is that this language can be substituted for other languages > that might alternatively be used like C > or COBOL. We have also heard that this stored procedure language can [...] 15417 97 41_Re: table structure changes - how often ?13_OConner, John26_John.OConner@COURTS.WA.GOV30_Fri, 9 Jun 2000 08:59:13 -0700374_iso-8859-1 The DBA's maintain 9 copies of our database structure (there are also a few copies that the developers have). These are:

in Production subsystem > Production > Volume testing > 2 for Training (post implementation)

in Development subsystem > Staging for Production > Test for production fixes > Development > 2 for Training (pre-implementation) [...] 15515 69 20_Re: DB2 DBA position13_Samuel, David26_David_Samuel@COMPUWARE.COM30_Fri, 9 Jun 2000 11:57:15 -0400627_iso-8859-1 A visit to www.salary.com should tell you how much is appropriate for your region of the country.





David R. Samuel Compuware Corporation Systems Engineer 510.768.5449





-----Original Message----- From: Tina Hilton [mailto:Tina.Hilton@BMSUS.COM] Sent: Friday, June 09, 2000 5:16 AM To: DB2-L@RYCI.COM Subject: Re: DB2 DBA position



You also need to take into consideration the location. Salaries tend to be higher where the cost of living is higher (or at least they should be!), so there can be no blanket statements about what is an appropriate salary. [...] 15585 88 70_Re: droping of DB2 Catalog and directory tables - SYSUTIL and SYSLGRNG12_tim malamphy20_timalamphy@YAHOO.COM30_Fri, 9 Jun 2000 09:13:07 -0700615_us-ascii When I looked at my VSAM datasets, I didn't see the tablespace names show up...When I selected * from sysibm.systables, I didn't find any references to sysutil or syslgrng. I thought that was because I'd dropped them. D'OH... I forgot they'd never show up because they're in DSNB01. Tim --- "Dan Courter (1-408-463-3870)" wrote: > Don't lump these two ideas together. The evolution > of SYSLGRNG and > SYSUTIL are *NOT* the same situation. First, you > need to make sure when > you are talking about TABLESPACES (and therefore > VSAM datasets) and > when you are talking [...] 15674 119 18_Re: SQL -904 Error12_troy Coleman20_Troy.Coleman@UAL.COM30_Fri, 9 Jun 2000 11:39:41 -0500353_- You should check with your resource management group. This is usually caused by either your primary allocation being larger than a volume, or you cannot find a hole large enough to allocate the primary on any packs in your storage pool. To get around this you will need to reduce the size of your primary and increase the size of your secondary. [...] 15794 61 16_Re: UDF Question11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Fri, 9 Jun 2000 10:28:50 -0700436_iso-8859-1 Kurian, Well I finally got the beast working and I'll share what I can. I'm putting the functions and stored proc in the same lib but then we don't have many of ether. I've STEPLIBed that lib in the WLM proc. Where you but them would depend on your shop and its standards and security practices, they're like any other program. Your could steplib them in the WLM or put their lib in the linklist, whatever work for you. [...] 15856 73 23_qmf edit table question0_23_edie.richardson@SRS.GOV30_Fri, 9 Jun 2000 14:56:44 -0400598_us-ascii ----- Forwarded by Edie Richardson/WSRC/Srs on 06/09/00 02:56 PM -----



Edie Richardson



06/08/00 12:01 PM



To: DB2-L@RYCI.COM cc: Subject: qmf edit table question

I'm using QMF to edit values in a table. The table has a column that has packed data in it that is nullible. Everytime I return a row that has data in the packed column and try to PF8, I get an error and exitted out of the editor. It also will not let me edit the packed column thru QMF. Does anyone know how I can edit this packed column using the QMF table editor? And [...] 15930 62 18_Re: SQL -904 Error13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Fri, 9 Jun 2000 14:08:10 -0500393_iso-8859-1 Review the console log and look for a message at the same time. Then follow through on the IDCAMS/VSAM message.

-----Original Message----- From: Killen, Martin W - CNF [mailto:Killen.Martin@CNF.COM] Sent: Friday, June 09, 2000 9:45 AM To: DB2-L@RYCI.COM Subject: Re: SQL -904 Error



Are you sure you have enough room on your volume to create your dataset? [...] 15993 76 30_Re: Stored Procedures Language13_Barry T Klutz21_barrytk@IX.NETCOM.COM30_Fri, 9 Jun 2000 16:05:33 -0400470_iso-8859-1 Tony, Yes with Version 6 there is a feature called SQL Procedure; there has been discussions about this being retro-fitted to V5, but I'm not sure about that. It is SQL 3 level standardization and does need the LE/370 services; especially the OS/390 LE/370 Services 1.5 or higher and/of course MVS C pre-compile/pre-linkedit and runtime C libraries process is needed........ This IBM Web Site or the Red Book: This a great web site to check it out...... [...] 16070 51 30_Re: Stored Procedures Language15_Belfield, Al G.15_AGBELFI@TWA.COM30_Fri, 9 Jun 2000 15:36:46 -0500744_iso-8859-1 Redbook SG24-5485-00 'Developing Cross-Platform DB2 Stored Procedures : SQL Procedures and the DB2 Stored Procedure Builder' is available on the website www.redbooks.ibm.com

-----Original Message----- From: Clark, Tony [mailto:Tony.Clark@TWC.STATE.TX.US] Sent: Friday, June 09, 2000 10:01 AM To: DB2-L@RYCI.COM Subject: Stored Procedures Language



Greetings List:

We have heard that there is a stored procedure language that you can write stored procedures in. Our understanding is that this language can be substituted for other languages that might alternatively be used like C or COBOL. We have also heard that this stored procedure language can be back leveled into version 5 by applying certain [...] 16122 130 44_Re: Backup strategy for 1000s of tablespaces15_Andrea Milligan25_Andrea_Milligan@BCBST.COM30_Fri, 9 Jun 2000 16:45:53 -0400299_iso-8859-1 Not bad, but Peoplesoft HRMS and Financials has 8,250 tables. I have the HRMS data model. It weighs about 10 pounds and the larges pieces of paper are 3' by 6'. All are 3' tall, some only 3' wide. The print on them is small enouth that I need a magnifing glass even with my glasses. [...] 16253 80 53_Central PA DB2 Users Group Meeting Agenda - June 29th10_Cathy Peck23_cathy.peck@HIGHMARK.COM30_Fri, 9 Jun 2000 18:43:55 -0400313_us-ascii Below is the agenda for the June 29th Central PA DB2 Users Group Meeting. It can also be found on our website: http://www.db2parug.org. As usual, the event is FREE to anyone who would like to attend.

If you would like to register, drop me an email or call.

Hope to seeya on the 29th!! [...] 16334 28 28_DB2 stored procedure from PB22_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM30_Fri, 9 Jun 2000 17:15:34 -0700417_- Hello Folks, I need some help executing a DB2(v5.1) Stored procedure from power builder (6.5) using Db2 connect v6. I get an error on the "Connect using SQLCA" PB statement...saying "SQLCA.database" its not set. Can some kind folks come forward and enlighten me on what SQLCA transaction object parms need to be set for ODBC connection to DB2 ?. I have gone thru the documentation (PB) and some connect notes. [...] 16363 176 44_Re: Backup strategy for 1000s of tablespaces16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Fri, 9 Jun 2000 20:50:41 -0400618_us-ascii



Great, but now what do you do with it besides building a bookcase.?

How do you get the maximum performance from a system that is built for everybody? What percentage of 8250 tables do you actually use on a regular basis?

The basic question still stands What tables are reference, what are high usage.? What are the backup/recovery strategies for the highly important parts of this system .? Any good backup/recovery strategy addresses the needs of the application not just the fact that there are 1000's of tables. Has anyone broken this down to logical units of work .? Is [...] 16540 129 57_Re: Central PA DB2 Users Group Meeting Agenda - June 29th15_Campbell, James23_james.campbell@CSFB.COM30_Fri, 9 Jun 2000 22:58:14 -0400589_iso-8859-1 Where exactly is this?

How would I get there? jim...





> -----Original Message----- > From: Cathy Peck [SMTP:cathy.peck@HIGHMARK.COM] > Sent: Friday, June 09, 2000 6:44 PM > To: DB2-L@RYCI.COM > Subject: Central PA DB2 Users Group Meeting Agenda - June 29th > > Below is the agenda for the June 29th Central PA DB2 Users Group Meeting. > It can also be found on our website: http://www.db2parug.org. > As usual, the event is FREE to anyone who would like to attend. > > If you would like to register, drop me an email or call. > > Hope to seeya [...] 16670 154 57_Re: Central PA DB2 Users Group Meeting Agenda - June 29th19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM30_Fri, 9 Jun 2000 23:25:36 -0400506_iso-8859-1 It's in Camp Hill PA, which is near Harrisburg PA & Mechanicsburg PA.





Mike Piontkowski mailto:michael_piontkowski@compuserve.com



-----Original Message----- From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of Campbell, James Sent: Friday, June 09, 2000 22:58 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Central PA DB2 Users Group Meeting Agenda - June 29th





Where exactly is this?

How would I get there? jim... [...] 16825 36 35_DB2 connectivity through Visual Age20_Baskaran Subramaniam27_subramaniam.baskaran@DB.COM31_Sat, 10 Jun 2000 18:07:34 +0530413_us-ascii CROSS POSTING... IF YOU HAVE RECEIVED MULTIPLE COPIES , PLS IGNORE

Hello Listusers

We are an OS/390 site with DB2 v6. We get connected to OS/390 using P-COM, which is running on Windows-NT. Now we require to get connected to the DB2 from a Java applet using IBM's Visual Age. We have the professional edition of Visual Age with which we are unable to get connected to the DB2 on host. [...] 16862 29 29_Subject: Re: DB2 DBA position13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Sat, 10 Jun 2000 14:44:44 -0700370_- You might find it valuable to read session 15 from the recent Share.

OS/390 skills are becomming very difficult to find and the worst is yet to come, (depending on your point of view). I guess you could say you will have to pay more and more to get a vetran and if not, then be ready for large business losses because you wanted to bring in someone cheap. [...] 16892 62 18_Salary information12_Wallace Shah21_upajobs@BELLSOUTH.NET31_Sat, 10 Jun 2000 20:55:34 -0700381_iso-8859-1 Wallace Shah Sr. Account Manager Universal Placement Agency Charlotte, NC 28216 1-877-499-4417

Dear List,

Thanks for all of the good feedback given to me regarding the salary of the position in Charlotte. It was really good to go back to the client with the information. There now may be room for some re-evaluation. Thanks again to everyone who responded. 16955 13 70_Re: droping of DB2 Catalog and directory tables - SYSUTIL and SYSLGRNG11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Mon, 12 Jun 2000 08:06:17 +0800277_us-ascii Thanks for all the answer.

================================================ 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. 16969 55 45_Gabrielle's book including V6 from amazon.com15_Gabrielle_Assoc29_Gabrielle_Assoc@EMAIL.MSN.COM31_Sun, 11 Jun 2000 19:52:52 -0700509_- Amazon.com has 67 books in stock. However, they will not sell them because the last 2 digits of ISBN number 0966846001 was changed to 1X in ink. They require that a sticker be placed on over the ISBN number. They said they would return the books in April ago so that I can put the sticker on the book and return them to Amazon. I have not received the books. They refuse to put the sticker on the books themselves to save the time of them shipping the books to me and then I have to ship the book back [...] 17025 166 90_Re: Backup strategy for 1000s of tablespaces No known viruses detected in attached PC File13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 12 Jun 2000 09:54:40 +0100578_us-ascii

Actually it's 7,500 tablespaces, not tables. There are 16,741 tables!!! And that's without any significant tailoring. Just how useful a data model would be I don't know. Have you found any use for your data model, apart from perhaps being a footrest, doorstop etc.?

Adrian Savory ACSIS Limited







Andrea Milligan cc: (bcc: Adrian Savory/ZI/England/Zurich) Subject: Re: Backup strategy for 1000s of 09/06/00 21:45 tablespaces Please respond to DB2 Data Base Discussion List [...] 17192 210 44_Re: Backup strategy for 1000s of tablespaces13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 12 Jun 2000 09:59:42 +0100525_us-ascii

The recommendation from SAP is that the backup everything and recover everything. The problem is that SAP does things under the covers and uses tables the you would not expect it to use by just looking at the SQL.

Adrian Savory ACSIS Limited







"Thomas E. Faglon" To: DB2-L@RYCI.COM Subject: Re: Backup strategy for 1000s of tablespaces 10/06/00 01:50 Please respond to DB2 Data Base Discussion List [...] 17403 122 38_Re: Carriage return character in a SQL22_Lindsay, William (BIS)24_WLindsay@EXCHANGE.ML.COM31_Mon, 12 Jun 2000 07:16:13 -0400610_iso-8859-1 I believe NT should be CONCAT CHR(13) CHR(10) for the CRLF

-----Original Message----- From: Philip, Sibimon [mailto:SPhilip@CSXLINES.COM] Sent: Thursday, June 08, 2000 3:37 PM To: DB2-L@RYCI.COM Subject: Re: Carriage return character in a SQL



Sorry. I should have mentioned this. This is on OS/390 Version 2.6 with DB2 V5.1.

Thanks Sibimon Philip





-----Original Message----- From: sjtoeniskoetter@AEP.COM [mailto:sjtoeniskoetter@AEP.COM] Sent: Thursday, June 08, 2000 1:12 PM To: DB2-L@RYCI.COM Subject: Re: Carriage return character in a SQL [...] 17526 19 75_Central PA DB2 Users Group Meeting - Directions/Location are on the website10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Mon, 12 Jun 2000 07:22:02 -0400469_us-ascii Thks Mike for responding to Jim's question on where in Central PA the meeting is being held.

If anyone needs specific directions to the building, check out our RUG website: http://www.db2parug.org

Seeya!!

================================================ 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. 17546 172 44_Re: Backup strategy for 1000s of tablespaces19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 12 Jun 2000 06:49:07 -0500432_iso-8859-1 SAP, PEOPLESOFT you LISTENING!!!!!!!

It is ridiculous to have to install and needlessly backup 17,000+ plus tables in however many tablespaces when you may need only a few. If SAP and PEOPLESOFT can't identify which tables go with which purchasable function(s) it would seem to me to cause great concern about the caliber of the product! SAP, PEOPLESOFT, its after 10 PM, do you know where your tables are??? [...] 17719 59 20_Surprising Optimizer14_Peter Backlund15_pbacklu@IBM.NET31_Mon, 12 Jun 2000 14:16:39 +0200 17779 181 26_Re: 24 x 7 Backup/Recovery15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 12 Jun 2000 09:13:16 -0500373_iso-8859-1 Hi, Marcus!

You can recover to a point in time near where your batch job bombed if a log switch occurred near the time that you want to recover to. Print your BSDS using DSNJU004 and find a time that a log switch occurred near the time that your program abended. An end RBA point is given there. Recover to that RBA. It is not exact but it is close. [...] 17961 132 56_Re: AW: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 12 Jun 2000 09:41:13 -0500521_iso-8859-1 Yes, the STMTNO does refer to the numbers assigned in the modified source code, that is, source code created during the precompile process. This is according to my notes from one of Bonnie Baker's famous lecture series.

Linda Billings Enterprise Systems Programmer Wisconsin Department of Administration

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in. we're computer professionals. We cause accidents." - Nathaniel Borenstein [...] 18094 111 91_Re: Backup strategy for 1000s of tablespaces No known viruses det ected in attached PC File11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 12 Jun 2000 08:21:23 -0700631_iso-8859-1 I heard God's data model for the entire universe has only 12,286 tables!! cliff;-)

-----Original Message----- From: Adrian Savory [mailto:adrian.savory@ZURICH.COM] Sent: Monday, June 12, 2000 1:55 AM To: DB2-L@RYCI.COM Subject: Re: Backup strategy for 1000s of tablespaces No known viruses detected in attached PC File





Actually it's 7,500 tablespaces, not tables. There are 16,741 tables!!! And that's without any significant tailoring. Just how useful a data model would be I don't know. Have you found any use for your data model, apart from perhaps being a footrest, doorstop etc.? [...] 18206 47 0_12_Mabel Blanco21_MMabbell@NETSCAPE.NET29_Mon, 12 Jun 2000 11:30:12 EDT699_US-ASCII Hello Listusers

We are running DB2 V5 in OS/390 and we got this messages in the DBM1 address spaces when we were running the batch production.



IEA705I ERROR DURING GETMAIN SYS CODE = 878-0C DSNDBM1 DSNDBM1 00 IEA705I 00F72100 00AC9E88 00AC9E88 00E17600 00002000 IEA995I SYMPTOM DUMP OUTPUT SYSTEM COMPLETION CODE=878 REASON CODE=0000000C TIME=04.20.43 SEQ=15865 CPU=0000 ASID=0059 PSW AT TIME OF ERROR 070C1000 8154ED54 ILC 2 INTC 0D NO ACTIVE MODULE FOUND NAME=UNKNOWN DATA AT PSW 0154ED4E - 9B9418F8 0A0D98DC D0088910 GPR 0-3 8154ED42 84878000 00000000 00F72100 GPR 4-7 7FF16000 00000005 00000004 00000878 GPR 8-11 0000000C 0154E220 08F2A140 08F5CDCD GPR 12-15 [...] 18254 33 34_Resultsets From Stored Procedures.12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Mon, 12 Jun 2000 11:59:52 -0400557_us-ascii I am using ColdFusion to access a stored procedure in DB2 (OS/390). The stored procedure returns normal variables and a result set.

The stored procedure is returning the normal variables but not the result set.

The SQL code that comes back is +464 which the book says that too many result sets are being returned. As I am only returning one result set so I seem to have a limit of zero. Further, the book gives two options for the error. The first one is that the SYSPROCEDURE entry is too low but this one isn't the case as and [...] 18288 46 34_DB2 Developer's Guide - V6 Edition14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Mon, 12 Jun 2000 11:00:26 -0500581_ISO-8859-1 Just a quick note to let everyone know that the 4th edition of my book, DB2 Developer's Guide, is now available. The book was published in early May 2000 and is now up to date for Version 6 of DB2 for OS/390. New chapters have been added covering user-defined functions and distinct types, triggers, and object/relational and LOBs. Additionally, the entire contents of the book have been edited and modified to ensure V6 compatibility. And, once again, the book is in hard cover instead of soft cover (with no price hike - the list price is still $59.99). The book [...] 18335 63 0_13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 12 Jun 2000 11:02:16 -0500703_US-ASCII Hello Mabel, Check Informational apars II04309 and II10817 and verify you have the necessary storage creep ptf's applied. HTH Kurt

>>> MMabbell@NETSCAPE.NET 06/12/00 10:30AM >>> Hello Listusers

We are running DB2 V5 in OS/390 and we got this messages in the DBM1 address spaces when we were running the batch production.



IEA705I ERROR DURING GETMAIN SYS CODE = 878-0C DSNDBM1 DSNDBM1 00 IEA705I 00F72100 00AC9E88 00AC9E88 00E17600 00002000 IEA995I SYMPTOM DUMP OUTPUT SYSTEM COMPLETION CODE=878 REASON CODE=0000000C TIME=04.20.43 SEQ=15865 CPU=0000 ASID=0059 PSW AT TIME OF ERROR 070C1000 8154ED54 ILC 2 INTC 0D NO ACTIVE MODULE FOUND NAME=UNKNOWN DATA AT PSW [...] 18399 68 38_Re: DB2 Developer's Guide - V6 Edition12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Mon, 12 Jun 2000 11:18:09 -0500437_iso-8859-1 just a quick note back Craig, I paid the full price of $59 and it was softcover! But it's great to hear that the next version is out, I'll make sure I pick it up.

Best Regards, John Vernon Teacher Retirement System 512-391-2273

-----Original Message----- From: Mullins, Craig [mailto:Craig_Mullins@BMC.COM] Sent: Monday, June 12, 2000 11:00 AM To: DB2-L@RYCI.COM Subject: DB2 Developer's Guide - V6 Edition [...] 18468 28 24_DB2 V4 - end of support?15_Miller, Dale E.15_dmiller@UGI.COM31_Mon, 12 Jun 2000 12:12:22 -0400427_us-ascii We are running DB2 V4 on OS/390. Does anyone know when V4 is going off support? We checked the IBM website and could not find a date. If you could point me to the specific site, as well, that would be appreciated. Thanks!

-------- //-- Dale Miller //-- UGI Utilities, Inc. 225 Morgantown Rd. P.O. Box 13009 Reading, PA 19612-3009 //-- Email: dmiller@ugi.com //-- Voice: 610-736-5435 //-- Fax: 610-736-5447 [...] 18497 89 38_Re: DB2 Developer's Guide - V6 Edition15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Mon, 12 Jun 2000 12:39:11 -0400472_iso-8859-1 Just to let everyone know, I ordered it through Amazon.com, pd $48 including S&H and its hardcover. It's already helped me in researching solutions to a problem.

My thanks to Mr. Mullins and his team contributors to producing it.

Susan Loria x2754

-----Original Message----- From: Vernon, John [mailto:John.Vernon@TRS.STATE.TX.US] Sent: Monday, June 12, 2000 12:18 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Developer's Guide - V6 Edition [...] 18587 186 44_SIRDUG Meeting on June 23rd in Charlotte, NC11_Paul Turpin22_pault704@EARTHLINK.NET31_Mon, 12 Jun 2000 11:21:47 -0500612_ISO-8859-1 SIRDUG June 23rd, 2000 Meeting Announcement ============================================================ Southeastern Inter-Relational Database Users' Group (SIRDUG) http://users.vnet.net/sirdug

WHEN? Friday June 23, 2000

WHERE? Charlotte Marriott Executive Park 5700 Westpark Dr. Chanrlotte NC (704) 527-9650

COST? $30

SIRDUG 2000 Contact List ======================== Tink Tysor, Royal & SunAlliance President Bayard_Tysor@RSAUSA.com (704) 522-2481

Sandra A Sparks, Public Service Co. of NC Secretary "SANDRA A SPARKS" SANDRA.SPARKS@prodigy.net (704) 834-650 [...] 18774 90 38_Re: DB2 Developer's Guide - V6 Edition20_Johnson, Bill (GLIC)18_bjo23@ALLSTATE.COM31_Mon, 12 Jun 2000 12:15:14 -0500570_- I received the new edition last week and it is hard cover and was discounted through amazon for $48($52 with shipping) Excellent resource. Bill Johnson DBA Allstate Insurance Co.

> -----Original Message----- > From: Vernon, John [SMTP:John.Vernon@TRS.STATE.TX.US] > Sent: Monday, June 12, 2000 12:18 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Developer's Guide - V6 Edition > > just a quick note back Craig, > I paid the full price of $59 and it was softcover! > But it's great to hear that the next version is out, I'll make sure I pick > it up. > > Best [...] 18865 43 25_DB2 Developer's Guide, V413_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Mon, 12 Jun 2000 13:44:33 -040083_us-ascii Where did you see it on Amazon.com for 48.00??? All I see is 59.95. thanks 18909 17 37_DB2 Developers Guide - Fourth Edition14_Patriquin, Tim21_Tim_Patriquin@BMC.COM31_Mon, 12 Jun 2000 12:56:58 -0500500_ISO-8859-1 Craig's book can also be found at www.bookpool.com, though it is currently out of stock. Their price is $37.50. Here's the URL to Craig's book: http://www.bookpool.com/.x/kcitmrn3f4/ss/1?qs=mullins&Go.x=13&Go.y=8.

Tim Patriquin BMC Software

================================================ 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. 18927 91 24_Re: Surprising Optimizer15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 12 Jun 2000 13:05:21 -0500314_iso-8859-1 Perhaps the specification of nulls for the second query makes the predicate a stage 2 predicate. If that is the case then it would not use the index. The data manager (stage 1) is the index manager. Anything that makes a predicate a stage 2 predicate (RDS) will cause DB2 to not look at the index. [...] 19019 44 29_Re: DB2 Developer's Guide, V419_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 12 Jun 2000 13:04:49 -0500635_iso-8859-1 See bn.com 1 $41.99 DB2 Developer's Guide Within 24 Hrs -------------- $41.99 Net Product $0.00 Gift Wrap $0.00 Tax $4.29 Shipping -------------- $46.28 Total Order Price $46.28 CreditCard

Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. [...] 19064 68 0_12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 12 Jun 2000 21:01:17 +0200327_x-user-defined Hi, Look (together with your friendly sysprog) at the definitions of CSA in sys1.parmlib(iefsys??). Should have two numbers, eg: CSA=(n1,n2), n1 is for csa, n2 is for ecsa. Should be something like (3500,40000) (example only!!!) it looks like you are too short on n2 and too high on n1.

Isaac Yassin [...] 19133 95 24_Re: Surprising Optimizer9_Mark Ruhe19_Mark.Ruhe@QUEST.COM31_Mon, 12 Jun 2000 11:24:54 -0700406_iso-8859-1 The reason your seeing this is "col > '' " is not the same as "col in not null". Your assuming the '' is null which it isn't. It is simply a empty string on in this case a column in a row with a empty string.





-----Original Message----- From: Peter Backlund [mailto:pbacklu@IBM.NET] Sent: Monday, June 12, 2000 7:17 AM To: DB2-L@RYCI.COM Subject: Surprising Optimizer [...] 19229 99 19_Re: 4 GB partitions13_Olson, Carlos14_COlson@QRS.COM31_Mon, 12 Jun 2000 11:20:00 -0700359_iso-8859-1 David,

A partition can grown to 4GB without being defined as LARGE if NUMPARTS < 17. We have a partitioned tablespace (with less than 17 parts), with several partitions over 2GB. The LARGE option was not available in DB2V4. We have since migrated to DB2V6 (this last weekend).

Carlos Olson Database Administrator QRS Corporation [...] 19329 25 29_Re: DB2 Developer's Guide, V420_Johnson, Bill (GLIC)18_bjo23@ALLSTATE.COM31_Mon, 12 Jun 2000 13:14:45 -0500430_- 2 weeks ago when I ordered it, the price was $48. I see that it is now $59.95. Bill Johnson DBA Allstate Insurance Co.

> -----Original Message----- > From: Jimmy Willett [SMTP:Jimmy.Willett@NCMAIL.NET] > Sent: Monday, June 12, 2000 1:45 PM > To: DB2-L@RYCI.COM > Subject: DB2 Developer's Guide, V4 > > Where did you see it on Amazon.com for 48.00??? > All I see is 59.95. > thanks << File: Card for Jimmy Willett >> [...] 19355 28 8_DSN1COPY41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Mon, 12 Jun 2000 16:00:00 -0300415_iso-8859-1 Dear list,

A table had its structure altered with ALTER TABLE and no reorg was executed after. Many copies of that tablespace were made to tape. Is it possible to recover data from tape by using DSN1COPY? I have tried and DSN1COPY return code was 00. A SELECT COUNT(*) has returned the correct number of lines in that table, however, a SELECT * returns an error 00C90101 (inconsistent data). [...] 19384 60 29_Re: DB2 Developer's Guide, V411_Jim Keohane19_jimkeo@LOCKSTAR.COM31_Mon, 12 Jun 2000 15:09:32 -0400553_us-ascii FATBRAIN.COM has it for 4 cents less.... {smile}

DB2 Developer's Guide, Fourth Edition By Mullins, Craig

Online Price: $41.95 Softcover 30% off list (you save $18.04)





List Price: $59.99 1672 Pages Published by Sams Date Published: 05/2000 ISBN: 0672318288

DAVIS, RICK (SBCSI) wrote:

> See bn.com > 1 $41.99 DB2 Developer's Guide Within 24 Hrs > -------------- > $41.99 Net Product > $0.00 Gift Wrap > $0.00 Tax > $4.29 Shipping > -------------- > $46.28 Total Order Price > $46.28 CreditCard > 19445 72 12_Re: DSN1COPY12_HEPP SHERY C17_schepp@SRPNET.COM31_Mon, 12 Jun 2000 12:11:27 -0700599_ISO-8859-1 Claudio- you need to run the recover index utility for this tablespace to rebuild the indexes. If the utility fails then your dsn1copy didn't work. If the jobs completes normally you should be set.



Regards,



Shery Hepp SRP Sr. Database Adminstrator Information Services



(602)236-2650 pager (602)275-2508(8035) Dreams-we don't see things as they are, we see things as we are..... Success is getting what you want.....Happiness is wanting what you have...... "The question is not whether we will die, but how we will live." * Joan Borysenko [...] 19518 56 12_Re: DSN1COPY12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Mon, 12 Jun 2000 14:15:12 -0500428_- Claudio:

You don't say what environment you are in. If you are running on MVS or OS390 "Did you remember to RECOVER any indexes"???. If the answer is yes, try running Check Data and CHeck Index.?

Carol Sutfin AmSouth Bank NA.







Cl udio Meluzzi Mendes on 06/12/2000 02:00:00 PM



Please respond to DB2 Data Base Discussion List [...] 19575 83 29_Re: DB2 Developer's Guide, V418_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Mon, 12 Jun 2000 15:14:42 -0400475_iso-8859-1 Geez with all this info flyin back and forth about the cost, I think I'll just wait until the 'video' comes out!!!! :-)





Steve Whittaker DB2/DBA Carolina Power & Light Mail stop: CPB 17A4 - Raleigh Email: stephen.whittaker@cplc.com Phone: (919) 546-7267



-----Original Message----- From: Jim Keohane [mailto:jimkeo@LOCKSTAR.COM] Sent: Monday, June 12, 2000 3:10 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Developer's Guide, V4 [...] 19659 59 12_Re: DSN1COPY18_Satkowski, William18_wsatkowski@CSW.COM31_Mon, 12 Jun 2000 14:23:39 -0500704_iso-8859-1 The table is useable from the dsn1copy. I had to use platinums unload from the copy and then load.

Bill Satkowski Data Base Consultant Wsatkowski@csw.com 918-594-2282



---------- From: Cláudio Meluzzi Mendes [SMTP:P000002@BEG.COM.BR] Sent: Monday, June 12, 2000 2:00 PM To: DB2-L@RYCI.COM Subject: DSN1COPY Importance: High

Dear list,

A table had its structure altered with ALTER TABLE and no reorg was executed after. Many copies of that tablespace were made to tape. Is it possible to recover data from tape by using DSN1COPY? I have tried and DSN1COPY return code was 00. A SELECT COUNT(*) has returned the correct number [...] 19719 26 31_how to find the size of a table14_Ruth Gramolini26_rgramolini@TAX.STATE.VT.US31_Mon, 12 Jun 2000 15:15:36 -0400461_iso-8859-1 I would like to know the sql to find the size of a DB2 table. For those of you who also administer Oracle databases, the command would be: select sum(blocks*db_block_size) from dba_extents where segment_name='table_name'.

I know if Oracle can do it, DB2 can do it. Any help would be appreciated.

Thanks in advance, Ruth B. Gramolini ORACLE & DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 rgramolini@tax.state.vt.us [...] 19746 84 12_Re: DSN1COPY13_Purnima Patel18_ppatel@METLIFE.COM31_Mon, 12 Jun 2000 15:33:12 -0400521_iso-8859-1





Common problem , you must have done a DSN1COPY without stopping the tablespace .These are the steps for this is

1. stop db,tablespace 2. dsn1copy 3. start db,tablespace 4. recover all indexes.

That should be it.







"Cláudio Meluzzi Mendes" on 06/12/2000 03:00:00 PM

Please respond to "DB2 Data Base Discussion List"

To: DB2-L@RYCI.COM cc: (bcc: Purnima Patel/Bsg/MetLife/US) Subject: DSN1COPY 19831 66 12_Re: DSN1COPY19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 12 Jun 2000 14:32:32 -0500609_iso-8859-1 Claudio, From memory here so check it out, but I think you must REORG the table first, then DSN1COPY, then rebuild index(es) or DSN1COPY them too.

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any [...] 19898 45 35_Re: how to find the size of a table12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Mon, 12 Jun 2000 12:44:36 PDT665_- Ruth:

You can use a SELECT (NACTIVE*4096) FROM SYSIBM.SYSTABLESCE WHERE NAME = 'TSNAME' AND DBNAME = ' DATABASE NAME'. NACTIVE means the number of active pages in the tablespace.

>From: Ruth Gramolini >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: how to find the size of a table >Date: Mon, 12 Jun 2000 15:15:36 -0400 > >I would like to know the sql to find the size of a DB2 table. For those of >you who also administer Oracle databases, the command would be: >select sum(blocks*db_block_size) from dba_extents >where segment_name='table_name'. > >I know if Oracle can do [...] 19944 63 35_Re: how to find the size of a table15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 12 Jun 2000 14:47:48 -0500601_iso-8859-1 If you are talking about DB2 on OS/390 then there are two tables in the DB2 catalog which may contain the amount of storage by a tablespace in kilobytes. Both SYSIBM.SYSTABLESPACE and SYSIBM.SYSTABLEPART contain a SPACE column, which, according to the SQL manual, contains the ".....Number of kilobytes of DASD storage allocated to the table space partition, as determined by the last execution of the STOSPACE or RUNSTATS utility. The value is 0 if STOSPACE or RUNSTATS has not been run. The value is updated by STOSPACE if the table space is related to a storage group. The value is [...] 20008 28 35_Re: how to find the size of a table13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Mon, 12 Jun 2000 15:48:35 -0400513_iso-8859-1 I assume that this assumes that one is using 4K pages rather than 32K - or am ME a double-ASS fool?

Gregg

-----Original Message----- From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] Sent: Monday, June 12, 2000 3:45 PM To: DB2-L@RYCI.COM Subject: Re: how to find the size of a table



Ruth:

You can use a SELECT (NACTIVE*4096) FROM SYSIBM.SYSTABLESCE WHERE NAME = 'TSNAME' AND DBNAME = ' DATABASE NAME'. NACTIVE means the number of active pages in the tablespace. [...] 20037 51 35_Re: how to find the size of a table15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 12 Jun 2000 14:57:53 -0500427_iso-8859-1 Good question! I have been bitten by that myself. Will multiplying by NACTIVE give the total actual space formatted by DB2 or pages that contain rows? Also, I ran into a problem where I estimated space to be used for a group of tables but didn't calculate the DASD overhead. My estimations were correct as far as DB2 was concerned but when my customer got their DASD bill they fell off their collective chairs. [...] 20089 65 12_Re: DSN1COPY15_Murley, Michael22_Michael_Murley@BMC.COM31_Mon, 12 Jun 2000 15:01:26 -0500480_ISO-8859-1 Claudio,

I'm assuming that the ALTER TABLE added a column. If so, try this:

1. Drop the target table. 2. Re-create the target table with all but the last column defined. 3. Alter the target table to add the last column. 4. DSN1COPY from the image copy 5. Rebuild the indexes

Even if the last column was not the only one added, this should work. The alter causes a field in the DBD (OBDREVLF) to indicate that variable length rows might exist. [...] 20155 150 12_Re: DSN1COPY0_19_Tim.Lowe@STPAUL.COM31_Mon, 12 Jun 2000 15:14:50 -0500603_us-ascii Claudio/Rick, I would have thought that if the table had been altered to add a column, that you would instead have wanted to ensure that a reorg did NOT occur between the copy and now.

Otherwise, the reorg would change the table definition in the DBD from variable-length (the alter addcolumns would have changed it to variable) to fixed-length. Then, the DSN1COPY would put the data back out as variable-length, and you would abend. If a reorg HAD occurred, then in order to avoid this problem, you might be better off to create another tablespace/table that looked exactly as the [...] 20306 63 12_Re: DSN1COPY41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Mon, 12 Jun 2000 17:20:31 -0300561_iso-8859-1 Ok, being more specific, our DB2 is V5.1 OS/390. I have stopped the tablespace, executed DSN1COPY, started the tablespace and recovered its indexes. I have used parms OBIDXLAT, RESET with DBID, PSID and OBID translation.

The error 00C90101 points to an inconsistent tablespace page. I suppose the VSAM file has records with two different sizes due to an ALTER TABLE issued a long time ago, without a subsequent REORG. I am affraid it is not possible to recover because of the different record sizes encountered when DB2 reads data pages. [...] 20370 206 35_Re: how to find the size of a table0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 12 Jun 2000 15:19:26 -0500451_iso-8859-1 We have had a couple of discussions about DB2 size vs 3390 size. Below is a summary of those discussions with a (text) chart listing assumptions, calculations and resulting values comparing various methods of measuring allocations: DB2 (4K pages), OS390 tracks, cylinders, byte, Mega Bytes and Giga Bytes.

Once you figure out how much space is used in DB2, i.e. DB2 pages, you can use the chart below to convert to 3390 tracks. [...] 20577 84 12_Re: DSN1COPY19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Mon, 12 Jun 2000 16:28:12 EDT661_ISO-8859-1 Claudio,

Did you try dropping the Index and then doing the 'Select *' ?

As somebody else pointed out, try to define another table with the old definition of the table and then try the DSN1COPY.

Once I had a problem because the segsize was different.

HTH.

Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: "Cláudio Meluzzi Mendes" , on 06/12/2000 4:20 PM: Ok, being more specific, our DB2 is V5.1 OS/390. I have stopped the tablespace, executed DSN1COPY, started the tablespace and recovered its indexes. I have used parms OBIDXLAT, [...] 20662 15 29_Re: DB2 Developer's Guide, V423_Rakesh Sud 562-627-574813_RSUD@AARP.ORG31_Mon, 12 Jun 2000 17:07:40 -0400305_US-ASCII Try BOOKPOOL.COM it is even cheaper there.

RSUD

================================================ 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. 20678 29 25_Binding Stored Procedures15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK31_Mon, 12 Jun 2000 22:12:41 +0100473_iso-8859-1 I am looking to see if someone can assist in a small discussion we are having.

Does the package for a stored procedure have to be bound into the application plan?

Platform is DB2 V6 for OS/390 and the language for both stored procedure and application is Cobol and/or PL/1 mixed.

Our understanding from the documentation is that it does not, however, we get a -805 if it is not in the application plan or a collection referenced by it. [...] 20708 96 12_Re: DSN1COPY41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Mon, 12 Jun 2000 18:18:33 -0300311_iso-8859-1 I have executed the steps Michael wrote, but I when rebuilding the indexes I got a 00C9021C abend, which means that "A row was encountered that is not represented by a record OBD in the database descriptor (DBD)." After dropping the indexes a SELECT * or SELECT COUNT(*) did not return any row. [...] 20805 59 29_Re: Binding Stored Procedures0_24_lightsey@ITS.STATE.MS.US31_Mon, 12 Jun 2000 16:35:21 -0500340_us-ascii If the application is executing on the same local machine as the DB2, then the packages for the SPs do have to be included in the application plan. If the application is on a remote machine ( different physically or on a different LPAR on the same physical box ) then the SP packages are not included in the application plan. [...] 20865 37 29_Re: DB2 Developer's Guide, V414_subrata mondal25_subratamondal@HOTMAIL.COM29_Mon, 12 Jun 2000 23:35:59 GMT670_- Try www.addall.com and compare the price with shipping to anyone in the world. It takes care of listers outside US too.

Cheers

Subrata



>From: Rakesh Sud 562-627-5748 >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: DB2 Developer's Guide, V4 >Date: Mon, 12 Jun 2000 17:07:40 -0400 > >Try BOOKPOOL.COM it is even cheaper there. > >RSUD > >================================================ >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. [...] 20903 161 12_Re: DSN1COPY11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Tue, 13 Jun 2000 08:27:22 +0800508_iso-8859-1 After you had altered a column to a table, you must run reorg on the table space b4 you run DSN1COPY. (Please refer to Utility Guide and Reference - DSN1COPY : Altering a Table before Running DSN1COPY (page: 3-45.)). Your Select count(*) had no problem because DB2 used index to do the count. If you select all the columns except the alter columns, you should not encounter any problem. So my suggestion is : Unload the data without the alter columns and load back the data with replace yes. [...] 21065 90 43_Balt./Wash. DB2 Users' Group - Bonnie Baker0_19_valeriet@US.IBM.COM31_Mon, 12 Jun 2000 12:58:14 -0400663_us-ascii SPECIAL DB2 COURSE WITH BONNIE BAKER Sponsored by the Baltimore/Washington DB2 Users' Group

When? Tuesday June 14,2000

Where? Sheraton Columbia Inn, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Who? Bonnie Baker is an internationally-recognized DB2 educator, consultant, and application architect. She has over 18 years of information systems experience, concentrated in DB2 for OS/390. While Bonnie spends much of her time performing design reviews and performance tuning consulting engagements, she is best known for creating and presenting a series of DB2 seminars entitled, "Things I Wish They'd Told Me 8 Years Ago". [...] 21156 22 20_DB2 Connect question10_Vinson Lee19_vlee@SDCCD.CC.CA.US31_Mon, 12 Jun 2000 18:26:37 -0700353_iso-8859-1 We are currently running DB2 for MVS version 4.1 and OS/390 version 2.5 . We are looking into using DB2 Connect personal edition from the PC using TCP/IP. Does anyone know whether an IP connection is possible at our current level of DB2 and MVS. Which versions of the DB2 Connect personal edition software support SNA or TCP/IP or both? [...] 21179 49 24_Re: DB2 Connect question14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 13 Jun 2000 12:01:35 +1000374_iso-8859-1 Vinson,

DB2/MVS V4 - SNA support only DB2/MVS V5 and later - both SNA and TCPIP support DB2 Connect V5.2 and later - both SNA and TCPIP support

So, no, your current software won't support an IP connection to DB2/MVS

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au [...] 21229 93 24_Re: Surprising Optimizer7_Sanjeev19_Sanjeev@INTERRA.COM31_Tue, 13 Jun 2000 11:41:04 +0530560_iso-8859-1 Hi Peter, WHERE KORGNR > '' ,if the string contains spaces then i can say that it is the lowest possible value(in EBCDIC...presuming you have EBCDIC encoding scheme) and DB2 knows that it has to scan all the records in the index as well as the data pages. letters sort before digits in EBCDIC, and after digits in ASCII. Solutions 1) Change the literals with a host variable i.e WHERE KORGNR > :H, this improves the chances of getting index scan. 2) the first query can also be converted into index access by using WHERE KORGNR < NULL( code it [...] 21323 93 36_Online Reorg & Reorg Shrlevel Change5_Pearl17_panidak@SCB.CO.TH31_Tue, 13 Jun 2000 13:53:30 +0700200_windows-874 Hi List, I'm vary confuse about online Reorg and reorg shrlevel change In DB2 V5 for OS/390. Is it the same? Suppose it's difference, what is it difference? Thanks. Pearl DBA - SCB

21417 74 118_AW: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE - The proble m is solved - Thanks to everybody who was involved !12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 13 Jun 2000 08:52:09 +0200680_iso-8859-1 >>>> This restriction (multirow UPDATE of primary key) is removed in V5.

THAT'S IT ! All our IT centers are running DB2 for OS/390 Version 5 except the center where the -151 SQLCODE appears............

Thanks to everybody who helps me !

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 21492 34 40_Re: Online Reorg & Reorg Shrlevel Change7_Sanjeev19_Sanjeev@INTERRA.COM31_Tue, 13 Jun 2000 12:30:37 +0530482_windows-874 Yes, both are same!! REORG with SHRLEVEL REFERENCE / SHRLEVEL CHANGE are Online Reorg.

Regards

Sanjeev

-----Original Message----- From: Pearl [mailto:panidak@SCB.CO.TH] Sent: Tuesday, June 13, 2000 12:24 PM To: DB2-L@RYCI.COM Subject: Online Reorg & Reorg Shrlevel Change



Hi List, I'm vary confuse about online Reorg and reorg shrlevel change In DB2 V5 for OS/390. Is it the same? Suppose it's difference, what is it difference? [...] 21527 316 37_Re: TSO/ISPF/Rexx Support for DB2/3900_18_TOUSSAN@UK.IBM.COM31_Mon, 12 Jun 2000 18:51:40 +0100576_us-ascii



You may find the DB2 V6 Technical Update redbook (currently available as a redpiece) helpful. Although not strictly new with V6, the REXX support is documented in here. The redbook no. is SG24-6108 which you can find from the IBM redbooks web site.

It has a chapter on Language Support including REXX. There is some sample code, documentation of some of what we found were less than completely obvious rules you have to follow and descriptions of the main calls (connect, cursor manipulation, error handling and singleton SQL statements). [...] 21844 15 40_Any DRP-L (Disaster Recovery Plan) Users20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Tue, 13 Jun 2000 04:01:24 EDT403_US-ASCII Hello, Have anyone use listserv DRP-L in the last few days? It seams like it is down. Any one else have a problem trying to reach it? Thanks, Ed. Benoit

================================================ 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. 21860 25 23_Type conversion Problem12_Diwakar Goel32_Diwakar.Goel@VASHIMAIL.LTITL.COM31_Tue, 13 Jun 2000 14:27:29 +0530313_us-ascii Hi All. I have created a UDF, written in C language. which converts a decimal input puts a comma after each three digit. ex. 10000.00 it will be converted into 10,000.00. I am accepting input through the DB2SQL where I am type casting it decimal input into character and returns a character string. [...] 21886 25 23_Type conversion Problem12_Diwakar Goel32_Diwakar.Goel@VASHIMAIL.LTITL.COM31_Tue, 13 Jun 2000 15:50:32 +0530313_us-ascii Hi All. I have created a UDF, written in C language. which converts a decimal input puts a comma after each three digit. ex. 10000.00 it will be converted into 10,000.00. I am accepting input through the DB2SQL where I am type casting it decimal input into character and returns a character string. [...] 21912 50 29_Re: Binding Stored Procedures15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK31_Tue, 13 Jun 2000 12:02:44 +0100436_iso-8859-1 Next Q.

Does this also apply to functions, triggers etc?

Keith

A.

If the application is executing on the same local machine as the DB2, then the packages for the SPs do have to be included in the application plan. If the application is on a remote machine ( different physically or on a different LPAR on the same physical box ) then the SP packages are not included in the application plan. [...] 21963 12 47_Re: Balt./Wash. DB2 Users' Group - Bonnie Baker0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Tue, 13 Jun 2000 07:13:01 -0400296_us-ascii Don't you mean WED, June 14 instead of Tue???

================================================ 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. 21976 56 12_Re: DSN1COPY17_Joao Alberto Lima22_joaolima@SENADO.GOV.BR31_Tue, 13 Jun 2000 06:31:21 -0500319_- Hi Claudio Mendes,

We've had the same problem few times ago. The IBM support was involved and in a meantime we thought to solve creating a new index with all attributes and did a DSNTIAUL with SELECT * (the optimizer choose the index only access). Then we loaded the table with the data. It's was enough. [...] 22033 62 35_Re: how to find the size of a table19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 13 Jun 2000 07:08:07 -0500580_iso-8859-1 Ruth, Another way to get sizing is to use an IDCAMS LISTCAT of the underlying VSAM datasets. It shows HIGH_USED_RBA and HIGH_ALLOC_RBA. In this manner you are not dependent on RUNSTATS or STOSPACE. The values are updated each time DB2 takes an extent, the dataset is CLOSED, and other times I can't remember. To get a decent approx. initial sizing, get a sum of the total bytes, add in any freespace, then divide by 737,280 to get 3390 cylinders. (I realize this will be somewhat short, but this is based on guessing anyway.) See the DB2-L archives for more info. [...] 22096 101 44_Re: Backup strategy for 1000s of tablespaces12_Moreno, Jose19_Jose_Moreno@BMC.COM31_Tue, 13 Jun 2000 07:04:10 -0500600_ISO-8859-1 Adrian,

Copy Plus has optional Snapshot capabilities. You can purchase our Snapshot Upgrade Feature for DB2 and your outage could be reduced to almost nothing (a Quiesce at the beginning). With Copy Plus and the Snapshot, you still have true DB2 Image Copies (registered in Syscopy, incrementals ...). In addition, it will work whatever the hardware you have. It can use the hardware snapshot (RVA/SVA Snapshot, HDS ShadowImage, EMC TimeFinder) or emulate them if such facility is not installed. You then could have both availability for your tables and integrity for your ICs [...] 22198 21 31_Sort/merge destructive read req18_Rajesh Kumar Sinha24_rksinx@LOT.TATASTEEL.COM29_Tue, 13 Jun 2000 12:34:27 GMT331_us-ascii Hi Omegamon table H2STATBP have fields Destructive read and Destructive Read page Dequeue. These fields are related to Sort/merge. Could any one explain what are these fields. I tried this to search in DB2 administration guide, but didn't find any match. I am sure this destructive read is not UR. Thanks in advance. [...] 22220 233 35_Re: how to find the size of a table15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 13 Jun 2000 07:51:56 -0500658_iso-8859-1 Well, said! That is pretty much what I came up with, eventually. I am much better at calculating space now. What is ISM?

Linda

-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Monday, June 12, 2000 3:19 PM To: DB2-L@RYCI.COM Subject: Re: how to find the size of a table

We have had a couple of discussions about DB2 size vs 3390 size. Below is a summary of those discussions with a (text) chart listing assumptions, calculations and resulting values comparing various methods of measuring allocations: DB2 (4K pages), OS390 tracks, cylinders, byte, Mega Bytes and Giga Bytes. [...] 22454 95 43_Balt./Wash. DB2 Users' Group - Bonnie Baker0_19_valeriet@US.IBM.COM31_Tue, 13 Jun 2000 09:00:44 -0400666_us-ascii SPECIAL DB2 COURSE WITH BONNIE BAKER Sponsored by the Baltimore/Washington DB2 Users' Group

When? Wednesday, June 14,2000

Where? Sheraton Columbia Inn, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Who? Bonnie Baker is an internationally-recognized DB2 educator, consultant, and application architect. She has over 18 years of information systems experience, concentrated in DB2 for OS/390. While Bonnie spends much of her time performing design reviews and performance tuning consulting engagements, she is best known for creating and presenting a series of DB2 seminars entitled, "Things I Wish They'd Told Me 8 Years Ago". [...] 22550 118 29_Re: DB2 Developer's Guide, V412_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Tue, 13 Jun 2000 10:14:50 -0400625_iso-8859-1 Take another $10 off.

Always go to a site like http://www.bigbigsavings.com/cgi-bin/php/bycategory.php3?g=7 before buying from B&N and use the online coupons. They only work when you order via the web.

tom

-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Monday, June 12, 2000 2:05 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Developer's Guide, V4



See bn.com 1 $41.99 DB2 Developer's Guide Within 24 Hrs -------------- $41.99 Net Product $0.00 Gift Wrap $0.00 Tax $4.29 Shipping -------------- $46.28 Total Order Price $46.28 CreditCard [...] 22669 64 24_Re: DB2 Connect question16_Swinski, Kenneth32_KSwinski@INTERNAL.MASSMUTUAL.COM31_Tue, 13 Jun 2000 10:44:57 -0400579_us-ascii You also need to be at OS390 ver 2.6 for TCPIP support.

> -----Original Message----- > From: James Campbell [SMTP:James.Campbell@HANCORP.COM.AU] > Sent: Monday, June 12, 2000 10:02 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Connect question > > Vinson, > > DB2/MVS V4 - SNA support only > DB2/MVS V5 and later - both SNA and TCPIP support > DB2 Connect V5.2 and later - both SNA and TCPIP support > > So, no, your current software won't support an IP connection to DB2/MVS > > /* standard disclaimer */ > James Campbell > DBA > Hansen Corporation, Doncaster [...] 22734 183 29_Re: DB2 Developer's Guide, V415_Stovall, Martin16_MStovall@USG.COM31_Tue, 13 Jun 2000 09:54:44 -0500295_iso-8859-1 At Barnes and Nobles nb.com they having a special for father's day and the book is 31.99 after the online coupon. To save $10 off a purchase of USD $30 or more, just enter the discount code "DADSDAY" when you check out. Good for one time at Barnes and Noble's online store only. [...] 22918 10 38_Re: Carriage return character in a SQL0_27_Bud.Greenman@ONONDAGA.NY.US31_Tue, 13 Jun 2000 11:07:43 -0400255_- It is x'15'

================================================ 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. 22929 24 29_Reorg DB2 Catalog & Directory9_Chu, Pius14_ChuP@CONED.COM31_Tue, 13 Jun 2000 11:26:56 -0400420_iso-8859-1 I ran a DB2 V5.1 reorg Catalog & Directory job. Looking at the sysout, some of the indexes were not rebuild, including a few of my own user defined indexes on SYSDBASE. Looking at the manuals, it does not talk about that all indexes belonging to a Catalog & Directory will get rebuild. Should all indexes on the Catalog & Directory tablespace get build when you reorg the Catalog & Directory tablespace? [...] 22954 20 28_Archive Log's Not Cataloging16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Tue, 13 Jun 2000 11:30:50 -0400330_iso-8859-1 We archive to tape. In ZPARM, I have Unit=Tape, Catalog=Yes, but when I look at the archive entries via DSNJU004 , it states that they are uncataloged. Any ideas on how to get the archive tapes to catalog in the future? Thanks...

Michael Dempsey Data Base Administration UNC Health Care System 919.966.4696 [...] 22975 58 12_Re: DSN1COPY14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Tue, 13 Jun 2000 08:46:45 -0700356_iso-8859-1 Claudio, Another quick and dirty way to get around this problem would be to alter the copied table to add another NULLABLE or NOT NULL WITH DEFAULT column to the end of the table. This will set the appropriate bits in the DBD. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 23034 40 21_Tmon/DB2 and SMF data19_GLASER, TOM (SBCSI)21_tg5444@MOMAIL.SBC.COM31_Tue, 13 Jun 2000 10:53:56 -0500561_iso-8859-1 Hi,

Is there anyone extracting SMF data from Tmon/DB2 archived logs on a daily basis? I would like to your thoughts on how this is being done.

I have job TDBFSU being kicked off when a TMDB01, 02, 03, 04 or SP log fills up. This job creates the archived log. I would like to run another step to create the SMF data. Here's my problem: TDBFSU creates archived logs for TMDB01,2,3,4 and SP. Since SP is for Supertrace information, we can skip this file. It seems that only TMDB01 and 02 creates SMF data. Won't the TDBSMF job create [...] 23075 59 32_DB2 OLR - Mapping index Sizing ?14_Robert MacLeod23_robert.macleod@ICBC.COM31_Tue, 13 Jun 2000 10:47:09 -0500664_- DB2 V5 OS/390

INFO : 42,080,432 row table 1 PK Index 2 OTH Indexes nearindref = 7 farindref = 1

Mapping table index was successfully defined with a primary of 29,100 TRKS secondary 2,730 TRKS

The short of the story is the mapping table index ran out of space and couldn't extend

DSNP002I - DSNPDFN1 - DEFINE FAILED FOR DB2P1$.DSNDBC.ICBCIS.MAPCPAYX.I0001.A002. RC=00D70025 CONNECTION-ID=UTILITY, CORRELATION-ID=CPAYRORG, LUW-ID=* DSNP007I - DSNPXTN0 - EXTEND FAILED FOR DB2P1$.DSNDBD.ICBCIS.MAPCPAYX.I0001.A001. RC=00D70025 CONNECTION-ID=UTILITY, CORRELATION-ID=CPAYRORG, CONNECTION-ID=UTILITY, CORRELATION-ID=CPAYRORG, LUW-ID=* [...] 23135 32 35_Partitioning Question (New Posting)21_Patrick M Darienzo Jr27_pdarienzo@KEYSPANENERGY.COM31_Tue, 13 Jun 2000 11:56:41 -0400460_us-ascii I'm looking for some guiding rules of thumb:

We have a ten year old DB2 database (V5) with over 100 tables/tablespaces that were defined similarly. Each has ten partitions and a volume ranging from 2-20 million rows. We anticipate it may need to triple in size.

The data distribution across the partitions was originally designed to encourage a crude, but effective, version of query parallellism and reduce locking under DB2 V2.3. [...] 23168 55 32_Re: Archive Log's Not Cataloging0_17_sjvagnier@AEP.COM31_Tue, 13 Jun 2000 12:04:19 -0400350_us-ascii Hi Michael,

Look at the MVS SYSLOG to see if there are any other messages during an archive offload process for this DB2 environment. My guess is a problem with MVS Catalog failing to catalog the archive tapes using whatever the DSN high level qualifier is.



Hope this Helps.. Steve Vagnier American Electric Power [...] 23224 37 35_Re: how to find the size of a table0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 13 Jun 2000 10:56:49 -0500452_us-ascii ISM is our IBM mainframe service provider (they are now an IBM subsidiary). Around here we use the terms ISM/IBM interchangably, I forgot to change it before sending email out.









"Billings, Linda" @RYCI.COM> on 2000/06/13 07:51:56 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 23262 89 24_Re: DB2 Connect question13_Martin Kenney25_martin.kenney@RAILINC.COM31_Tue, 13 Jun 2000 12:03:16 -0400275_us-ascii We are at OS390 1.3, DB2 V5.1 and have no problems with DB2 connect PE or EE from Windows 98 (PE) or Windows NT (EE) so I don't think OS390 2.6 is a requirement. Our maintenance level for both DB2 and OS390 are both late 1999 so that may be why we can connect. [...] 23352 319 37_Re: TSO/ISPF/Rexx Support for DB2/3900_18_TOUSSAN@UK.IBM.COM31_Mon, 12 Jun 2000 18:51:40 +0100576_us-ascii



You may find the DB2 V6 Technical Update redbook (currently available as a redpiece) helpful. Although not strictly new with V6, the REXX support is documented in here. The redbook no. is SG24-6108 which you can find from the IBM redbooks web site.

It has a chapter on Language Support including REXX. There is some sample code, documentation of some of what we found were less than completely obvious rules you have to follow and descriptions of the main calls (connect, cursor manipulation, error handling and singleton SQL statements). [...] 23672 77 118_AW: BIND PACKAGE RUNS INTO A MYSTERIOUS -151 SQLCODE - The proble m is solved - Thanks to everybody who was involved !12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 13 Jun 2000 08:52:09 +0200680_iso-8859-1 >>>> This restriction (multirow UPDATE of primary key) is removed in V5.

THAT'S IT ! All our IT centers are running DB2 for OS/390 Version 5 except the center where the -151 SQLCODE appears............

Thanks to everybody who helps me !

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 23750 93 36_Online Reorg & Reorg Shrlevel Change5_Pearl17_panidak@SCB.CO.TH31_Tue, 13 Jun 2000 13:53:30 +0700200_windows-874 Hi List, I'm vary confuse about online Reorg and reorg shrlevel change In DB2 V5 for OS/390. Is it the same? Suppose it's difference, what is it difference? Thanks. Pearl DBA - SCB

23844 26 38_Re: Carriage return character in a SQL0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 13 Jun 2000 11:32:17 -0500626_us-ascii what OS and DB2 version. It doesn't work with DB2 V5, OS390 2.8









Bud.Greenman@ONONDAGA.NY.US@RYCI.COM> on 2000/06/13 10:07:43 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List

Subject: Re: Carriage return character in a SQL

It is x'15'

================================================ 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. 23871 13 15_Balt./Wash. DUG0_19_valeriet@US.IBM.COM31_Tue, 13 Jun 2000 12:37:12 -0400333_us-ascii This month's event will be on Wednesday, June 14, 2000. (Sorry about the mistake.)

================================================ 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. 23885 88 36_Re: DB2 OLR - Mapping index Sizing ?0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 13 Jun 2000 11:41:30 -0500430_us-ascii I've had the "00D70025" reason code when the last diskpack in a stogroup did not have enough space for the extent. Since you died on the A001 and A002 files, I would guess that the disk did not have enough contiguous freespace.









Robert MacLeod @RYCI.COM> on 2000/06/13 10:47:09 AM

Please respond to DB2 Data Base Discussion List [...] 23974 56 38_Re: Carriage return character in a SQL15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 13 Jun 2000 12:50:02 -0400452_iso-8859-1 I was running the query in ISQL (SQLserver) window. 1. If I run the query against SQLserver I could use Char(10) to get carriage return. 2. If I run the query against DB2 from ISQL, then I could use X'25' to get a carriage return. I do not know how this works. Some how SQLserver is converting X'25' to carriage return. This was good enough for me 3. We are using DB2 V5.1 on OS/390 2.6. In QMF X'15' does not work in this DB2 version. [...] 24031 24 31_Performance Monitoring & Tuning13_Skelton Brian20_skelton.b@MELLON.COM31_Tue, 13 Jun 2000 12:43:13 -0400301_- I have newly started a DB2 DBA trainee role.

My boss has asked me to look at performance monitoring and tuning . I have looked in the developers edition and the IBM admin guides which are good.

However I was wondering if anyone knew of any good web pages, FAQ etc on the subject. [...] 24056 82 32_Re: Archive Log's Not Cataloging0_20_John_Lendman@FPL.COM31_Tue, 13 Jun 2000 12:51:21 -0400453_us-ascii Also if you are not using a GDG, then once you were catalog the first entry, then next one would get a not catg 2 message. John







sjvagnier@AEP.COM@RYCI.COM> on 06/13/2000 12:04:19 PM

Please respond to "DB2 Data Base Discussion List"

Sent by: "DB2 Data Base Discussion List"



To: DB2-L@RYCI.COM cc:

Subject: Re: Archive Log's Not Cataloging [...] 24139 37 35_Re: Performance Monitoring & Tuning11_Doug Fuerst14_djfirst@LI.NET31_Tue, 13 Jun 2000 13:16:31 -0400613_us-ascii You are going to START at performance as a trainee? Does your manager know anything about DB2?



At 12:43 13-06-00 -0400, you wrote: >I have newly started a DB2 DBA trainee role. > >My boss has asked me to look at performance monitoring and tuning . >I have looked in the developers edition and the IBM admin guides which are >good. > >However I was wondering if anyone knew of any good web pages, FAQ etc on the >subject. > >Any help would be gratefully appreciated. > > >Brian > >================================================ >To change your subscription options or to cancel your [...] 24177 55 35_Re: Performance Monitoring & Tuning12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 13 Jun 2000 20:01:04 +0200522_x-user-defined Hi, First - ask for a course on the subject, there are many good ones. Second - If you have a DB2 monitor at your shop, read its' manual, look at its' screens and reports. Performance is a big subject, don't try to do it all in one day, pick a subject and learn it, then move forward. For starters - try to understand how DB2 works, its' memory usage, disk usage and I/O, SQL syntax. There is a good paper at responsivesystems site - read it. Look at older issues of DB2 Magazine (on the WEB as well). [...] 24233 27 34_Sequential Prefetch & Read Engines14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Tue, 13 Jun 2000 13:18:51 -0400333_iso-8859-1 Recently we have been noticing in our production environment that Sequential Prefetches are being disabled because of no read engine. Questions to which I cannot find any answers in the IBM manuals are:

1. How do I find out how many read engines are available to me?

2. Is it a configurable parameter ? [...] 24261 103 12_Re: DSN1COPY41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Mon, 12 Jun 2000 18:18:33 -0300311_iso-8859-1 I have executed the steps Michael wrote, but I when rebuilding the indexes I got a 00C9021C abend, which means that "A row was encountered that is not represented by a record OBD in the database descriptor (DBD)." After dropping the indexes a SELECT * or SELECT COUNT(*) did not return any row. [...] 24365 36 32_Re: Archive Log's Not Cataloging12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 13 Jun 2000 12:50:00 -0400678_- Does the userid assigned to the DSNMSTR have update access to the catalog? As mentioned before, view SYSLOG and JES output from DSNMSTR. For each archive log you should be seeing something like: 23.54.08 STC00062 DSNJ003I -DB01 DSNJOFF3 FULL ARCHIVE LOG VOLUME ..................................... UNIT=TAPEP, COPY1VOL=203705, VOLSPAN=00, CATLG=YES

This is a reach: Do you have something like DB2PM to view the parms online? Make sure you are using the dsnzparm module with catalog=yes. Check the continuation char in dsntijuz and make sure you are picking up the catalog=yes parm (the default is no). >>> DB2-L@RYCI.COM@inter2 06/13/00 10:30AM >>> We archive to [...] 24402 55 38_Re: Sequential Prefetch & Read Engines15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 13 Jun 2000 13:02:26 -0500413_iso-8859-1 I don't know how many are available but as far as I know it is not a configurable parameter.

Linda Billings Enterprise Systems Programmer Wisconsin Department of Administration Info-Tech Services

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in. we're computer professionals. We cause accidents." - Nathaniel Borenstein [...] 24458 15 38_Re: Sequential Prefetch & Read Engines0_31_truman.g.brown@BELLATLANTIC.COM31_Tue, 13 Jun 2000 14:08:17 -0400371_us-ascii There are 300 read engines per subsystem, and yes, this can be altered, BUT it's not a good idea to do so.

George

================================================ 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. 24474 71 39_Re: Partitioning Question (New Posting)15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 13 Jun 2000 13:18:15 -0500553_iso-8859-1 I have only partitioned one set of tables but the criteria I used was based on the projected size of these tables. The retention period for the data is 100 years and they were 32K tables (Yikes!) so I had to think really big. I didn't want to hit any limits for each partition for a very, very long time. One factor for you would be how many engines would give you optimal response time? Perhaps that is how many partitions you need. For V6 a tablespace doesn't need to be partitioned to take advantage of parallel processing. Then size [...] 24546 50 12_Re: DSN1COPY41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Tue, 13 Jun 2000 15:37:59 -0300355_iso-8859-1 Dear list,

I finally managed to recover data from an altered tablespace using DSN1COPY. Thank you Shery, Carol, Bill, Patel, Rick, Rajeev, Roland, Julian, Joao Alberto, Aurora, Wayne and specially Michael and Tim for your valuable suggestions. For those interested in, a brief summary of the problem and the final solution follows: [...] 24597 47 38_Re: Sequential Prefetch & Read Engines13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 13 Jun 2000 13:48:02 -0500315_US-ASCII You have 300 read engines available to you. There is no configuration parameter. If you are running parallelism and have UQ38747 applied V5 you can set PARAMDEG zparm to limit the degree of parallel streams being executed per thread. Or lower the CTHREAD zparm to limit the concurrent users. HTH Kurt [...] 24645 58 0_11_John Flemal17_jflemal@YAHOO.COM31_Tue, 13 Jun 2000 11:40:50 -0700324_us-ascii Hi, June 13, 2000

My name is John Flemal and I am an IT recruiter in Wisconsin. I have two job opportunities. A Lead Database Analyst and a Database Analyst. The salary is up to $85,000 per year. The position is in Green Bay, Wisconsin. Relocation Assistance is available.

Here is a description: [...] 24704 16 3_RRS0_20_bjnigh@HOUSEHOLD.COM31_Tue, 13 Jun 2000 11:54:11 -0700490_us-ascii What exactly is the Transaction Management and Recoverable Resource Manager Services (RRS)? If we want to call a stored procedure that uses MQ Series to update a UNIX box, it is my understanding that we need RRS. Is RRS installed with DB2?

================================================ 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. 24721 135 47_Stored Procedure Builder Error - Windows UDB V610_Mark Feven19_markfeven@YAHOO.COM31_Tue, 13 Jun 2000 20:04:57 +0100327_iso-8859-1

Hello all,

I'm trying to use the Stored Procedure Builder supplied with UDB for Windows V6.1 to test a Stored Procedure written in C.

My procedure is called CASESRV and is in a schema called MARK.

When I try to run the Stored Procedure via the SP Builder I get the following error: [...] 24857 40 7_Re: RRS20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 13 Jun 2000 15:24:04 -0400507_us-ascii RRS is a new component in OS-390. This provides two-phase commits across resources. DB2, IMS and MQ provide Resource managers for RRS and you could do two phase commit from your program when you call SRRCMIT service of RRS, regardless of stored procedure.

Now the WLM managed stored procedure mandates the use of RRS hence you have to have RRS up and running. RRS is separate and is not part of DB2. If you look at your started tasks in your system you would find "RRS" as one of them. [...] 24898 174 29_Re: DB2 Developer's Guide, V412_Gene Tilelli16_geetee52@USA.NET31_Tue, 13 Jun 2000 15:17:11 -0400351_iso-8859-1 RE: DB2 Developer's Guide, V4Hi All...

I see a fair amount of enthusiasm and endorsement of this book...and for Gabrielle's book(s)...

Seeing these comments has me all ready to order it, but practically speaking, is there really that much information in it that is not found in the set of DB2 manuals that IBM publishes? [...] 25073 76 35_Re: Performance Monitoring & Tuning15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 13 Jun 2000 14:29:08 -0500556_iso-8859-1 Hey, that's as good a place as any to start. When I first started in DB2 they told me that they wanted me to do something with performance. That was all the direction that I got. I had to adlib from there. I started with the buffer pools and then figured out the significance of the various catalog statistics and their bearing on optimal object organization. Not all stats are created equal, you know. Their importance depends on how the table is being accessed. Now I am trying to conquer the access paths. They still confuse me but I am [...] 25150 75 29_Re: DB2 Developer's Guide, V412_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Tue, 13 Jun 2000 14:34:14 -0500569_iso-8859-1 I can't speak for Gabrielle's books (sorry, no negativity implied), but I can wholeheartedly endorse Craig's book. Well written, excellent examples, well thought out, (and he responds to DB2L when you have a question!).

john



Hi All...

I see a fair amount of enthusiasm and endorsement of this book...and for Gabrielle's book(s)...

Seeing these comments has me all ready to order it, but practically speaking, is there really that much information in it that is not found in the set of DB2 manuals that IBM publishes? [...] 25226 12 7_Re: RRS0_20_bjnigh@HOUSEHOLD.COM31_Tue, 13 Jun 2000 13:27:45 -0700305_us-ascii Does RRS come with OS/390 or is it a separate product?

================================================ 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. 25239 183 29_Re: DB2 Developer's Guide, V411_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM31_Tue, 13 Jun 2000 15:30:24 -0500359_us-ascii



Gene, Craig's book has the "IBMese" written into English. There are examples and samples. All in one book. I would guess that 75 percent of the questions you need answered are in the one book. He also breaks out the differences in V4, V5 and I assume V6 in the margins, so you can readily see what has changed. It's a good book. [...] 25423 26 7_Re: RRS20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 13 Jun 2000 16:41:24 -0400540_us-ascii I am not sure about it but I think it is separately priced.

-----Original Message----- From: bjnigh@HOUSEHOLD.COM [SMTP:bjnigh@HOUSEHOLD.COM] Sent: Tuesday, June 13, 2000 4:28 PM To: DB2-L@RYCI.COM Subject: Re: RRS

Does RRS come with OS/390 or is it a separate product?

================================================ 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. [...] 25450 14 7_AW: RRS16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Tue, 13 Jun 2000 22:44:50 +0200283_- It comes with OS/390 base

Roland

================================================ 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. 25465 26 32_Re: Archive Log's Not Cataloging0_17_JTonchick@AOL.COM29_Tue, 13 Jun 2000 16:47:29 EDT540_US-ASCII You might want to check with the folks that manage your tape library software (CA1, TLMS, Zara, etc.). They may have the daily scratch job set up to reuse all tapes with datasets that are not GDG entries.

To test... 1) issue a manual archive command to force an archive. 2) check the MVS catalog to make sure the entry is out there. 3) if it is then wait until the next morning and check again. 4) if it is "gone", the tape management software is deleting the entry out of the MVS catalog and placing the tape into the [...] 25492 14 23_Re: DDF HELP !!! PLEASE9_Joe Smith18_JSmith0763@AOL.COM31_Tue, 13 Jun 2000 16:50:09 -0500502_- Have you updated your BSDS with lOCATION, PORT and RESPORT info? Have VTAM resereved your port numbers, unique to each subsystem, within the profile dataset in TCP/IP? Has the user-id of ddf started task been given authority to utilise unix systems services?

================================================ 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. 25507 26 7_Re: RRS12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 13 Jun 2000 16:03:00 -0400445_- There is a redbook at http://www.redbooks.ibm.com/redbooksonline.html Getting started with stored procedures... SG24-4693-01 It contains setup of RRS. >>> DB2-L@RYCI.COM@inter2 06/13/00 01:55PM >>> What exactly is the Transaction Management and Recoverable Resource Manager Services (RRS)? If we want to call a stored procedure that uses MQ Series to update a UNIX box, it is my understanding that we need RRS. Is RRS installed with DB2? [...] 25534 221 24_Re: DB2 Connect question15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Wed, 14 Jun 2000 08:37:33 +1000443_iso-8859-1 Thankfully, that is not the case. We are running DB2 Connect v6.1 to DB2/OS390 v5.1 over IP and use OS/390 v1.3 with the UNIX Services configured as "sockets only"

Regards

Richard Simpson rsimpson@macquarie.com.au

-----Original Message----- From: Swinski, Kenneth [mailto:KSwinski@INTERNAL.MASSMUTUAL.COM] Sent: Wednesday, 14 June 2000 12:45 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 Connect question [...] 25756 18 38_Re: Sequential Prefetch & Read Engines14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 13 Jun 2000 19:38:19 -0400431_ISO-8859-1 DB2 V5 has 300 read engines, V6 has 600. If you are running out of engines, you have a dasd performance problem. Buffer pool tuning can also help this problem.

Regards, Joel

===============================================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. 25775 26 30_DB2/Endevor/Sysplex separation0_14_DPetro@AOL.COM29_Tue, 13 Jun 2000 21:17:32 EDT636_US-ASCII We are in the process of separating our test and production environments into two isolated sysplexes. We use Endevor as our source management tool. Has anyone used Endevor to manage source (compile, pre-compile, link, bind, etc.) on a test sysplex and then somehow migrated the updated libraries to a production sysplex? Optimally, we'd like to have 2 Endevors, 1 on each plex, that are automatically kept in sync, but we're coming to the conclusion that Endevor itself does not provide that functionality. Are there many others out there who have completely segregated their test and production systems (no shared DASD)? [...] 25802 29 17_regarding Recover17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Tue, 13 Jun 2000 19:56:55 PDT287_- Hi Folks,

In our shope we are using DB2 v5. we have two tables in one tablespace. i took a full imagecopy for this tablespace using copy utility. now i want to recover only one table from the imagecopy dataset.so my concern is how do i recover one table in this imagecopy. [...] 25832 63 21_Re: regarding Recover14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 14 Jun 2000 13:55:21 +1000547_iso-8859-1 Kumar,

1) No easy way. But two ways it could be done:

- unload the other table, recover the tablespace, delete all rows for the other table, load resume the unloaded data

- (provided all the data you want to recover is on the image copy) create another tablespace 'just like' the original, DSN1COPY the image copy into it doing appropriate translations, and copy the data for the desired table over. (See the many, many, posts on the use of DSN1COPY to sort of thing to understand what I mean by 'just like'.) [...] 25896 64 37_Links about DB2 for OS/390 (06/14/00)6_DB2usa18_db2usa@HOTMAIL.COM31_Tue, 13 Jun 2000 22:49:03 -0500742_ISO-8859-1 Hi,

Here is a non-profit website about DB2 for OS/390 (IBM mainframes):

- English : http://www.multimania.com/db2usa/eliendb2.htm - Français: http://www.multimania.com/db2usa/liendb2.htm

Last update on Wednesday, June 14th 2000 ========================================

- Links about DB2 for OS/390: http://www.multimania.com/db2usa/eliste.htm Take a look at JDBC, SQLJ and APAR II2343 pages on IBM DB2 for OS/390 website.

- Technical papers: http://www.multimania.com/db2usa/earticle.htm Summer issue of DB2 Mag is available on line: Demystifying "Optimizing for N Rows" by Bonnie Baker, DB2 Mag, Summer 2000. Prefetch and Deferred Write in OS/390 by Robert Catterall, DB2 Mag, Summer 2000. [...] 25961 41 27_Re: Type conversion Problem14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 14 Jun 2000 14:08:13 +1000567_iso-8859-1 how about giving us the SQL for the CREATE FUNCTION?

-----Original Message----- From: Diwakar Goel [mailto:Diwakar.Goel@VASHIMAIL.LTITL.COM] Sent: Tuesday, June 13, 2000 6:57 PM To: DB2-L@RYCI.COM Subject: Type conversion Problem



Hi All. I have created a UDF, written in C language. which converts a decimal input puts a comma after each three digit. ex. 10000.00 it will be converted into 10,000.00. I am accepting input through the DB2SQL where I am type casting it decimal input into character and returns a character string. [...] 26003 93 27_Re: Type conversion Problem12_Diwakar Goel32_Diwakar.Goel@VASHIMAIL.LTITL.COM31_Wed, 14 Jun 2000 10:14:20 +0530573_us-ascii Hello,

This is the function definition void SQL_API_FN grandFormat(SQLUDF_CHAR *in,SQLUDF_CHAR *out)

This is the SQL, create function.

CREATE FUNCTION ESW.TRY(CHAR) RETURNS CHAR DETERMINISTIC NOT FENCED EXTERNAL NAME 'ESW_GrandFormat!grandFormat' LANGUAGE C PARAMETER STYLE DB2SQL NO SQL NO EXTERNAL ACTION

Regards Diwakar















James Campbell on 06/14/2000 10:38:13 AM

Please respond to DB2 Data Base Discussion List [...] 26097 119 27_Re: Type conversion Problem14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 14 Jun 2000 15:27:31 +1000340_iso-8859-1 My reading of the V6 Reference Manual (and I must confess to not having an appreciation of the finer points of non OS/390 DB2, nor of C) is that, as specified, your function is expecting a CHAR(1) to be supplied (1 being the default length for CHAR), and it would need to be at least CHAR(10) to be able to handle 10000.00. [...] 26217 146 27_FW: Type conversion Problem14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 14 Jun 2000 15:43:53 +1000359_iso-8859-1 Diwakar

I have just realised that where you are possibly making your mistake is thinking that DB2 is going to hand your code a nul terminated character string. It isn't. To DB2, a CHAR is a fixed length character string. (Yes, you can use nul terminated strings in SQL, but I don't think you can use them as arguments to UDFs and SPs.) [...] 26364 16 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Wed, 14 Jun 2000 01:00:22 -0500479_us-ascii I will be out of the office starting 06/13/2000 and will not return until 06/19/2000.

I will respond to your message when I return. If this is an emergency, please contact Doug Mullins, Vivek Yeldandi, or Richard Raimond.

================================================ 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. 26381 155 36_Re: DB2 OLR - Mapping index Sizing ?0_18_mebert@AMADEUS.NET31_Wed, 14 Jun 2000 09:46:26 +0100561_us-ascii The mapping index should require 27 bytes per entry (21 bytes for the key columns + 6 bytes RID). This means about 1800 entries per track. Because according to the messages, DB2 tried to allocate a second VSAM file for the index, it means that your index grew to more than 2 GB which should provide enough room for about 78 M keys. Because the mapping table has SOURCE_RID as first col, I would think that the mapping table will be built in the sequence of the original, unreorged tablespace. I.e. if your TS was badly unclustered, the index will [...] 26537 89 29_Re: Binding Stored Procedures15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK31_Wed, 14 Jun 2000 09:54:19 +0100627_iso-8859-1 Next Q.

Does this also apply to functions, triggers etc?

Keith



----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: 12 June 2000 22:35 Subject: Re: Binding Stored Procedures



If the application is executing on the same local machine as the DB2, then the packages for the SPs do have to be included in the application plan. If the application is on a remote machine ( different physically or on a different LPAR on the same physical box ) then the SP packages are not included in the application plan. [...] 26627 100 29_Re: Binding Stored Procedures14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 14 Jun 2000 19:22:47 +1000552_iso-8859-1 Keith,

I've got to ask: when you created the stored procedure, did you specify COLLID? My reading is that if you did, the SP's package wouldn't need to be in the plan's packagelist.

Ditto for functions.

(Our SP/UDF packages are in the same collection as the programs that normally invoke them. So for static sql I am not certain what's happening. But we can invoke UDFs through SPUFI and DSNTEP2 by SETting CURRENT SCHEMA and everything works fine - even though the UDF packages aren't available through the plan.) [...] 26728 28 21_Re: regarding Recover14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Wed, 14 Jun 2000 05:04:13 -0500561_ISO-8859-1 Kumar,

the answer to part 1 of your question is basically 'you can't'.

Rows from both tables are mixed either on the same pages (if non-segmented) or on different pages but still in the same copy VSAM dataset if segmented. The only workaround I could suggest is to create a copy of the tablespace and table structure and use DSN1COPY to dump the image copy dataset into it (remember OBIDXLAT). You could then Unload the table you are interested in, delete the rows from the original table and Load the data unloaded from the copy. [...] 26757 105 33_Re: Reorg DB2 Catalog & Directory0_18_mebert@AMADEUS.NET31_Wed, 14 Jun 2000 12:20:51 +0100434_us-ascii According to the Utilities Guide, p. 2-208, indexes on tablespaces DSNDB06.SYSDBASE, ..SYSDBAUT, ..SYSGROUP, ..SYSPLAN, ..SYSVIEWS, and DSNDB01.DBD01won't be rebuilt, but will be loaded in parallel with the tablespaces. You can add another step for REBUILDing/REORGing the indexes on these TSs after the REORG TS step.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 26863 57 63_Press Release of DB2 Recovery Tool to include Disaster Recovery20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 14 Jun 2000 06:21:51 EDT688_US-ASCII DB2 Recovery Tool Press Release

Recovery Knowledge is please to announce GENDB2 Release 1.1 with all the functions needed to simplify and automate the DB2/MVS Recovery process. This is a Recovery Tool that will display all the different recovery points of a Tablespace by Image Copies, Quiesced RBA, Timestamp, Etc., Etc. It will also simplify and automate the generation of the recovery Jobs JCL and CNTL statement for different type of Tablespace Recoveries (Forward, Tocopy, TORBA Quiesce Point-In-Time, TablespaceSET TORBA Quiesce Point-In-Time). This is accomplished for On-Site as well as Off-Site Disaster Recovery Environments. The user simply PICK and CHOSE [...] 26921 23 29_Re: DB2 Developer's Guide, V414_Philip Gunning18_pgunning@PHEAA.ORG31_Wed, 14 Jun 2000 08:11:25 -0400494_us-ascii Gabirelle's book is an excellent source of information. It goes into more detail than Craigs. Both contain excellent information -- almost nothing that can't be found in the manuals but better orgranized and explained. I would highly recommend both. Phil



Phil Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB V6 IBM Certified Solutions Expert -- DB2 Application Development V6 IBM Certified Advanced Technical Expert -- DB2 UDB DRDA Assoc List Owner DB2-l [...] 26945 124 29_Re: Binding Stored Procedures15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK31_Wed, 14 Jun 2000 12:12:41 +0100451_iso-8859-1 James, No we haven't been using COLLID so there in may lie out problem. We shall turn that around and give it a try and let you know the outcome - it may be a couple of days though with the normal workload etc. Thanks for the reply Keith.

Keith,

I've got to ask: when you created the stored procedure, did you specify COLLID? My reading is that if you did, the SP's package wouldn't need to be in the plan's packagelist. [...] 27070 17 35_Re: Sort/merge destructive read req11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Wed, 14 Jun 2000 07:34:09 -0500548_- Rajesh, Generally these fields are mapped from those in SDSNSAMP(DSNWMSGS). The vendor's manuals should have those fields (Destructive read and Destructive Read page Dequeue). For a guess, Destructive reads is QBSTWDRP. Check out the vendor manuals or call Candle, they can tell you. Regards, John Rosser

================================================ 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. 27088 19 47_Connecting Win NT clients to OS/390 DB2 UDB 5.113_Michael Kiddy27_Michael_Kiddy@MCCORMICK.COM31_Wed, 14 Jun 2000 08:51:28 -0400310_us-ascii Is it necessary to use either DB2 Connect Personal Edition, or Enterprise Edition to connect Win NT clients to OS/390 DB2 UDB 5.1? I am using the latest CAE SW with fixpack 13 and OS/390 DB2 UDB 5.1 that both support TCP/IP. I am getting a generic communication error. Why do I need DB2 Connect? [...] 27108 48 51_Re: Connecting Win NT clients to OS/390 DB2 UDB 5.116_Michael McCarthy18_mmccarthy@DTCC.COM31_Wed, 14 Jun 2000 09:24:05 -0400467_us-ascii Mike,

DB2 Connect is the bridge between a workstation and OS/390 or AS/400 DB2 data. One of the features needed is the codepage conversion it does so the data you receive is readable. For more information, check the DB2 Connect Quick Beginnings book.

-Mike.









Michael Kiddy on 06/14/2000 08:51:28 AM

Please respond to DB2 Data Base Discussion List [...] 27157 64 34_FW: DB2/Endevor/Sysplex separation13_Brendan Friel18_b.friel@PECORP.COM31_Wed, 14 Jun 2000 08:25:06 -0500422_iso-8859-1 I am currently supporting applications where we migrate from test Endevor to production Endevor, but we DO have shared DASD.

I've supported migration from test to non-production in the environment you describe in a non-Endevor environment. We would use NDM (Network Data Manager ?) to ship the updated individual source members source from test to production and then recompile on the prod sysplex. [...] 27222 173 38_Re: Sequential Prefetch & Read Engines12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Wed, 14 Jun 2000 08:43:35 -0500598_iso-8859-1



Manas:





The plot above shows how some of the engine failures can look. Part of the problem is identifying the cause(s) of the problem, so as not to be solving the symptom, but correcting the actual root cause. Usually, the problem has a high positive correlation with I/O queuing. It can be solve by identifying the datasets and separating those in conflict. This separation is now more difficult because of the manner in which DASD is managed. If you put two dataset on separate logical volumes, how separate are they in the physical reality? [...] 27396 76 25_Re: Tmon/DB2 and SMF data12_Sue Janowitz18_SJanowitz@NEFN.COM31_Wed, 14 Jun 2000 09:47:34 -0400356_us-ascii You could create different versions of the TDBFSU job, which you point to in your TDBLFSP member. Then you could have the extra step in the one that TMDB01 and 02 use, and not in the other. (I don't use the SMF data, but have an extra step in the TMDB01 and 02 job to dump the archive log to a weekly log file that I then use for reporting.) [...] 27473 29 11_Emergency !16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Wed, 14 Jun 2000 09:56:38 -0400622_iso-8859-1 Hello fellow DBAs

Group, I have a situation RIGHT NOW. When I terminate a specific utilid I receive DSNU114I UTILITY COMMAND SUBSYSTEM FAILURE REASON 00E40030

I can't find this reason code in the messages and codes for V5.1

What is causing this and how do I resolve it?



Thanks in advance



Thanks,

Steve Cockerill

================================================ 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. 27503 52 38_Re: Sequential Prefetch & Read Engines12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 14 Jun 2000 06:58:09 PDT413_- Manas:



If you are getting No write engine Message it means you must start to do some tunning on your buffer pool. It is nothing to concern about the operating system and the machine capacity. Take a look at DWQT and VDWQT values on those buffer pool you are having this problem. Setting up these values in appropriate way you soon going to get rid or at least minimize quickly your problem. [...] 27556 40 15_Re: Emergency !13_Larry Jardine22_larry.jardine@WCOM.COM31_Wed, 14 Jun 2000 10:00:40 -0400576_iso-8859-1 Here's the message text:

00E40030

Explanation: A -DISPLAY UTILITY or -TERM UTILITY command has failed in the command subsystem.

This abend reason code is issued by the following CSECT: DSNUGCCC

System Action: Command processing is terminated. For -TERM UTILITY, all previous actions taken by the command are backed out.

System Programmer Response: Determine the failing environment. If you suspect an error in DB2, refer to Section 3 of Diagnosis Guide and Reference for information on identifying and reporting the problem. [...] 27597 58 15_Re: Emergency !18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Wed, 14 Jun 2000 10:01:43 -0400316_iso-8859-1 There is a E40030 in the msgs & codes...it basically says your have a termination failure which you already know. There should be more information that you got when you received this error. It says to 'contact your systems programmer' but thats about it in the manual... Is your subsystem 'active'?? [...] 27656 133 15_Re: Emergency !15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 14 Jun 2000 09:02:58 -0500495_iso-8859-1 Hi, Steve,

Does this look like your problem?

APAR NUMBER: PQ12187 RESOLVED AS: PROGRAM ERROR

ABSTRACT: PQ12187: DSN9023I - DSNUGCCC '-TERM UTILITY' ABNORMAL COMPLETION FOR ONLINE REORG WHEN THERE IS NO SHADOW DATASET TO DELETE.

ORIGINATING DETAILS: DSNU114I - DSNUGCCC - UTILITY COMMANDS SUBSYSTEM FAILURE, REASON=X'<00E40030>' DSN9023I - DSNUGCCC '-TERM UTILITY' ABNORMAL COMPLETION for Online REORG utility but there is no shadow dataset to delete. [...] 27790 150 15_Re: Emergency !0_18_mebert@AMADEUS.NET31_Wed, 14 Jun 2000 16:06:46 +0100496_iso-8859-1 4.14 Utilities Reason Codes © Copyright IBM Corp. 1982, 1992 Topic lines 1144 to 1167 of 4986 ================================================================== 00E40030

Explanation: A -DISPLAY UTILITY or -TERM UTILITY command has failed in the command subsystem.

This abend reason code is issued by the following CSECT(s): DSNUGCCC

System Action: Command processing is terminated. For -TERM UTILITY, all previous actions taken by the command are backed out. [...] 27941 12 15_Re: Emergency !13_Joe Abbagnaro25_Joe_Abbagnaro@PRAXAIR.COM31_Wed, 14 Jun 2000 10:08:16 -0400312_us-ascii You can also check DB2 job log for additional error messages.

================================================ 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. 27954 151 15_Re: Emergency !16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Wed, 14 Jun 2000 10:14:19 -0400370_iso-8859-1 Thanks but not sure this is it, The util Id was from a Runstats (make matters worse I don't know when it was run).. In clearing the utilid I received the error. Thanks Steve

-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Wednesday, June 14, 2000 10:03 AM To: DB2-L@RYCI.COM Subject: Re: Emergency ! [...] 28106 26 15_Re: Emergency !14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Wed, 14 Jun 2000 09:20:13 -0500539_ISO-8859-1 Steve,

found a hit in http://techsupport.services.ibm.com/cgi-bin/support/390.support/phuic if your utility is a sharelevel Reference or Change (and DB2 is 5.1). See PQ12187.

Fix is UQ15053

Hope this helps

Colin



Usual weasely disclaimers etc..

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 28133 74 15_Re: Emergency !16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Wed, 14 Jun 2000 10:19:23 -0400541_iso-8859-1 yes it's alive





-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Wednesday, June 14, 2000 10:02 AM To: DB2-L@RYCI.COM Subject: Re: Emergency !



There is a E40030 in the msgs & codes...it basically says your have a termination failure which you already know. There should be more information that you got when you received this error. It says to 'contact your systems programmer' but thats about it in the manual... Is your subsystem 'active'?? [...] 28208 40 15_Re: Emergency !16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Wed, 14 Jun 2000 10:21:34 -0400737_iso-8859-1 Thanks

-----Original Message----- From: Clayton, Colin [mailto:Colin_Clayton@BMC.COM] Sent: Wednesday, June 14, 2000 10:20 AM To: DB2-L@RYCI.COM Subject: Re: Emergency !



Steve,

found a hit in http://techsupport.services.ibm.com/cgi-bin/support/390.support/phuic if your utility is a sharelevel Reference or Change (and DB2 is 5.1). See PQ12187.

Fix is UQ15053

Hope this helps

Colin



Usual weasely disclaimers etc..

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...] 28249 44 15_Re: Emergency !11_Kevin Davis18_kevin.davis@DB.COM31_Wed, 14 Jun 2000 09:02:14 -0600596_us-ascii This is the information for the error.



00E40030

Explanation: A -DISPLAY UTILITY or -TERM UTILITY command has failed in the command subsystem.

This abend reason code is issued by the following CSECT: DSNUGCCC

System Action: Command processing is terminated. For -TERM UTILITY, all previous actions taken by the command are backed out.

System Programmer Response: Determine the failing environment. If you suspect an error in DB2, refer to Section 3 of Diagnosis Guide and Reference for information on identifying and reporting the problem. [...] 28294 73 15_Re: Emergency !16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Wed, 14 Jun 2000 10:25:33 -0400657_iso-8859-1 Yes it's alive but I was moving tables to a new tablespace and they are dropped but now I have this conflict. So I'm missing tables at the moment.

-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Wednesday, June 14, 2000 10:02 AM To: DB2-L@RYCI.COM Subject: Re: Emergency !



There is a E40030 in the msgs & codes...it basically says your have a termination failure which you already know. There should be more information that you got when you received this error. It says to 'contact your systems programmer' but thats about it in the manual... Is your subsystem 'active'?? [...] 28368 19 15_Re: Emergency !10_Ken Koleto23_kkoleto@PAINEWEBBER.COM31_Wed, 14 Jun 2000 10:21:26 -0400527_iso-8859-1 Steve, According to QuickRef, this is a failure in the command subsystem (which you already know) and you need to involve your systems programmer ASAP. (The ASAP mine). No user action is was indicated in the explanation.



Ken



my opinions only...

================================================ 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. 28388 179 15_Re: Emergency !0_18_mebert@AMADEUS.NET31_Wed, 14 Jun 2000 16:32:59 +0100414_iso-8859-1 I've had a quick look in the archives ( http://jupiter.ryci.com/archives/db2-l.html). Did you DROP a tablespace with a STOPped utility, and then tried to TERM the utility? If so, then it looks like you have to stop DB2 and re-initialize SYSUTILX.

MfG, ME.





From: Michael Ebert (ADP/DS/SO) on 14/06/2000 16:06

To: DB2 Data Base Discussion List - [...] 28568 52 15_Re: Emergency !12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 14 Jun 2000 07:38:08 PDT319_- Steve:

Are you a system programmer in your shop? If yes you can fix it executing the instalation job DSNTIJIN to redefine just the SYSUTIL tablespace. Becareful you've got to modify the job to do this. I hope it help you. It happened to me a lot in a previous db2 version and I fix them quickly this way. [...] 28621 134 15_Re: Emergency !15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 14 Jun 2000 09:38:12 -0500376_iso-8859-1 My colleague here has encountered this problem before.

He had to take the utility tablespace offline. Make sure there are no other utilities running. No other utilities other than the offending one can be in the utility tablespace, SYSUTILX.

This is the sledgehammer approach. Be very, very careful!!!

Take the SYSUTILX tablespace offline [...] 28756 31 45_Copying Catalog Statistics between Subsystems0_20_Carl_Nelson@AICI.COM31_Wed, 14 Jun 2000 10:29:10 -0500552_us-ascii I would like to copy some catalog statistics used for access path selection from our production DB2 subsystem down to our QA DB2 subsystem on the same LPAR for selected application databases. This would allow applications tested in the QA subsystem to use production access paths. I thought this topic had been addressed by this group before but I can not find it in the archives or in my own archives. How do other shops copy do this? We are OS/390 v5.1 and have BMC Catalog Manager, BMC Change Manager, & the BMC DASD Manager products. [...] 28788 25 26_VisualInfo V2.3 and UDB V614_Denzil Coalter26_denzil.coalter@UNICIBLE.CH31_Wed, 14 Jun 2000 17:38:32 +0200485_us-ascii We have the following problem:

FRN7756A: The host-based object server received an Object Access Method (OAM) return code = 00000010 and reason code = D8010000. The server was trying to access OAM.

The OAM diagnostic says for Reason Code D8010000 - DB2 Call Attach Facilty E/P DSNALI not found when loaded

We have just installed UDB V6 in this environment and we were wondering if anyone else using the same versions has experienced the same problem? [...] 28814 65 49_Re: Copying Catalog Statistics between Subsystems15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 14 Jun 2000 17:38:47 +0100299_us-ascii Hello Carl,

When I worked as a sysprog we did not have fancy tools.. So I wrote my own little program that would take the appropriate stats from a flat file and updated/inserted the catalog. No big deal, takes a few hours to write if that... The files I created using DSNTIAUL. [...] 28880 72 39_Re: DB2 connectivity through Visual Age0_15_leon@CA.IBM.COM31_Tue, 13 Jun 2000 14:59:57 -0500466_us-ascii You need to get DB2 Connect Enterprise Edition to enable Java Applet support. Java Applets that access DB2 for OS/390 can be developed using any version of VisualAge for Java including Professional Edition.

Important thing to remember is that you will be using what we call "Net JDBC Driver". This is a pure 100% JDBC driver that will communicate to a DB2 Connect Enterprise Edition Server running on Windows NT, UNIX and soon Linux/390 server. [...] 28953 17 51_Re: Connecting Win NT clients to OS/390 DB2 UDB 5.114_Philip Gunning18_pgunning@PHEAA.ORG31_Wed, 14 Jun 2000 11:44:40 -0400355_us-ascii Mike, DB2 Connect implements DRDA which is the protocol DB2 uses and it is also an XOPEN standard. HTH Phil

You can use either DB2 Connect PE or Enterprise Edition. PE on the workstation and EE on a server (gateway). Either way, DB2 for OS/390 and TCPIP on the host and workstation or server needs to be configured properly. HTH Phil [...] 28971 83 21_Re: regarding Recover11_Kwan, James18_James_Kwan@BMC.COM31_Wed, 14 Jun 2000 10:46:54 -0500423_iso-8859-1 Kumar,

Another way is to unload only the table you want from the image copy using product like UNLOAD PLUS and load the data back into the tablespace after you have deleted all old data in the table.

James Kwan

-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Tuesday, June 13, 2000 10:55 PM To: DB2-L@RYCI.COM Subject: Re: regarding Recover [...] 29055 162 49_Re: Copying Catalog Statistics between Subsystems20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 14 Jun 2000 11:47:20 -0400693_iso-8859-1 We use home grown REXX. Alternatively you could use following SQL do this (good for V5, does not copy COLDIST). Run this SQL in SPUFI to generate SQLs for updating catalog.

SELECT ' UPDATE SYSIBM.SYSTABLES SET NPAGES = '||DIGITS(NPAGES)||' , ',1,NAME FROM SYSIBM.SYSTABLES WHERE NAME = 'XXXXXX' AND CREATOR = 'AUTHID' UNION ALL SELECT ' CARDF = ' CONCAT DIGITS(DECIMAL(CARDF,15,0)) ||', ',2,NAME FROM SYSIBM.SYSTABLES WHERE NAME = 'XXXXXX' AND CREATOR = 'AUTHID' UNION ALL SELECT ' PCTROWCOMP = '||DIGITS(PCTROWCOMP)||' , PCTPAGES = '|| DIGITS(PCTPAGES)||', CARD ='||DIGITS(CARD)||' ' ,3,NAME FROM SYSIBM.SYSTABLES WHERE NAME = 'XXXXXX' AND CREATOR = 'AUTHID' UNION ALL [...] 29218 151 15_Re: Emergency !16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Wed, 14 Jun 2000 11:48:29 -0400525_iso-8859-1 Thanks I have IMB on phone, saying the same.. Thanks again Steve

-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Wednesday, June 14, 2000 10:38 AM To: DB2-L@RYCI.COM Subject: Re: Emergency !



My colleague here has encountered this problem before.

He had to take the utility tablespace offline. Make sure there are no other utilities running. No other utilities other than the offending one can be in the utility tablespace, SYSUTILX. [...] 29370 195 57_Correction: Copying Catalog Statistics between Subsystems20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 14 Jun 2000 11:54:07 -0400251_us-ascii I haven't used the SQL for long time and I had it for a customized need. Please delete the line "AND COLCARD > 0" and anything else not needed for your setup. <>

Regards, Venkat Pillay 29566 217 81_Repost: "IBM Ups the Ante With DB2 Version 7 Database" (Dataquest Alert 4 /26/00)13_Morrill, John12_JohnM@VP.NET31_Wed, 14 Jun 2000 10:11:50 -0600713_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

Dataquest recently published a review of DB2 Version 7. This "Dataquest Alert" (April 26, 2000) by Norma Schroder is entitled, "IBM Ups the Ante With DB2 Version 7 Database - IBM recently announced a number of product and marketing innovations for its forthcoming Version 7 of DB2 Universal Database expected [...] 29784 44 51_Re: Connecting Win NT clients to OS/390 DB2 UDB 5.10_15_leon@CA.IBM.COM31_Wed, 14 Jun 2000 12:22:26 -0400718_us-ascii Yes you must use DB2 Connect. DB2 CAE does NOT provide connectivity to DB2 for OS/390..

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com



Michael Kiddy on 06/14/2000 08:51:28 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Connecting Win NT clients to OS/390 DB2 UDB 5.1







Is it necessary to use either DB2 Connect Personal Edition, or Enterprise Edition to connect Win NT clients to OS/390 DB2 UDB 5.1? I am using the latest CAE SW with fixpack 13 and OS/390 DB2 UDB 5.1 that both support TCP/IP. I am getting a generic communication [...] 29829 100 38_Re: Carriage return character in a SQL16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Wed, 14 Jun 2000 09:27:08 -0700513_iso-8859-1 Char(10) x'0A' is LF (Line Feed) in ASCII. Char(13) x'0D' is CR (Carriage Return) in EBCDIC and ASCII. Char(21) x'15' is NL (New Line) in EBCDIC. Char(37) x'25' is LF (Line Feed) in EBCDIC.

Since these are standard EBCDIC and ASCII values, I don't believe that the version of DB2 or OS matters. What matters is whether the source is EBCDIC or ASCII (Mainframe or Micro), whether the target printer is EBCDIC or ASCII (Mainframe or Network printer), and what translation happens in between. [...] 29930 78 38_Re: FW: DB2/Endevor/Sysplex separation12_Roy Brickley20_roy_brickley@APL.COM31_Wed, 14 Jun 2000 09:51:48 -0700661_us-ascii Dave,

This is greatly dependent on your run-time environment in Production. If the Endevor-generated components are run directly from an output library under Endevor control, then you may be looking for an Endevor-to-Endevor transfer between LPARs (for example, JCL is moved within Endevor to Production status to a TYPE with a SOURCE O/P LIBRARY defined to xxx.LIB, and jobs are submitted from xxx.LIB using this Endevor-updated JCL. Compiled objects don't have SOURCE O/P LIBRARY, and rely on an Endevor processor to store the executable output from a link-edit step, and those libraries aren't usually under Endevor control). If you are [...] 30009 17 51_Re: Connecting Win NT clients to OS/390 DB2 UDB 5.113_Michael Kiddy27_Michael_Kiddy@MCCORMICK.COM31_Wed, 14 Jun 2000 13:39:14 -0400415_us-ascii Thanks for your input on resolving the problem with TCP/IP connectivity. I have loaded DB2 Connect PE and am now connecting successfully.

Thanks,

Mike

================================================ 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. 30027 58 49_Re: newbie question: How to set restricted access18_Bourgoine, Peter A33_Peter.A.Bourgoine@JPFINANCIAL.COM31_Wed, 14 Jun 2000 14:36:17 -0400463_iso-8859-1 Ruth, Starting the subsystem with 'maint' will restrict access to all databases in that subsystem. If you want to restrict access to a particular db or tablespace, use the start database command to restrict access to read-only, utility or read-write. Remember that a DB2 subsystem can have many databases. It's a little different than an Oracle instance. If you want to restrict ALL databases then the START DB2 suggested in previous notes works. [...] 30086 45 29_Re: DB2 Developer's Guide, V412_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 14 Jun 2000 21:13:23 +0200610_x-user-defined Hi, I use both and they are really good. Moreover, when traveling I put the CD version (.pdf) of Gabrielle on my thinkpad, this way it is easier to carry...;))

Isaac Yassin





Philip Gunning wrote: > > Gabirelle's book is an excellent source of information. It goes into more > detail than Craigs. Both contain excellent information -- almost nothing that > can't be found in the manuals but better orgranized and explained. I would > highly recommend both. Phil > > Phil Gunning > DB2 DBA > IBM Certified Solutions Expert -- DB2 UDB V6 > IBM Certified Solutions [...] 30132 54 38_Re: Sequential Prefetch & Read Engines12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 14 Jun 2000 21:25:34 +0200315_x-user-defined Hi Manas,

V5 - 300 engines. V6 - 600 engines. Yes -it can be tweaked ny changing a parameter on dsn6sysp macro (if I'm not mistaken with the name), not in the JUZ jcl. I ADVISE AGAINST doing it. Look first at your bufferpools size and VDWQT/DWQT, looks like you are causing that by that. [...] 30187 20 11_DASD price.19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Wed, 14 Jun 2000 14:57:39 EDT441_us-ascii Hi,

Could anyone give me a ballpark figure for what might be the price of 650 GB of DASD ?

TIA.

Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++

================================================ 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. 30208 86 35_Re: how to find the size of a table8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Wed, 14 Jun 2000 14:25:21 -0500747_us-ascii Is this wastage is applicable to RVA?? Thanks Bejoy





From: "Billings, Linda" on 06/12/2000 02:47 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Bejoy Kurian/MDSC/MAYCO)

Subject: Re: how to find the size of a table







If you are talking about DB2 on OS/390 then there are two tables in the DB2 catalog which may contain the amount of storage by a tablespace in kilobytes. Both SYSIBM.SYSTABLESPACE and SYSIBM.SYSTABLEPART contain a SPACE column, which, according to the SQL manual, contains the ".....Number of kilobytes of DASD storage allocated to the table space partition, as [...] 30295 23 15_DB2EUG Listserv14_Philip Gunning18_pgunning@PHEAA.ORG31_Wed, 14 Jun 2000 15:31:54 -0400388_us-ascii I recently changed employment and misplaced the address for the DB2EUG list. Please send it to me if you have it. TIA, Phil







Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB V6 IBM Certified Solutions Expert -- DB2 UDB Application Developemnt V6 IBM Certified Advanced Technical Expert -- DB2 UDB DRDA Assoc List Owner DB2-L [...] 30319 18 19_Re: DB2EUG Listserv13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 14 Jun 2000 15:38:42 -0400500_iso-8859-1 ===== To unsubscribe, send 'unsubscribe' to db2eug-request@lists.best.com For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.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. 30338 73 38_Re: Sequential Prefetch & Read Engines12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 14 Jun 2000 12:41:08 PDT596_- >From: Isaac Yassin >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Sequential Prefetch & Read Engines >Date: Wed, 14 Jun 2000 21:25:34 +0200 > >Hi Manas, > >V5 - 300 engines. >V6 - 600 engines. >Yes -it can be tweaked ny changing a parameter on dsn6sysp macro (if I'm >not >mistaken with the name), not in the JUZ jcl. >I ADVISE AGAINST doing it. >Look first at your bufferpools size and VDWQT/DWQT, looks like you are >causing >that by that. > >Good luck. > >Isaac Yassin > >Manas Dasgupta wrote: > > > > Recently we [...] 30412 17 10_DASD Price13_penny andrews19_pzandrews@YAHOO.COM31_Wed, 14 Jun 2000 12:51:29 -0700421_us-ascii We pay about $360.00 per gigabyte.

__________________________________________________ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE prints! http://photos.yahoo.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. 30430 143 35_Re: how to find the size of a table15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 14 Jun 2000 14:59:42 -0500391_iso-8859-1 I am not sure what you mean by that question. If you mean is it applicable to calculating space using the RBA then I don't know the answer to that question. I do not use that method when calculating space. It seems logical that you would still have to add in the wasted DASD space since the RBA is something internal to VSAM. It would still not know about the DASD overhead. [...] 30574 46 15_Re: DASD price.11_Suresh Sane21_data_arch@HOTMAIL.COM29_Wed, 14 Jun 2000 15:07:03 CDT691_- Rajeev - this depends on purchase v/s lease.

The lease cost number I have used recently (for 3390's) is about:

$0.001 per MB per day

HTH.

Suresh



>From: "Rajeev P. Dhanawade" >Reply-To: rdhanawade@state.de.us >To: DB2-L@RYCI.COM >Subject: DASD price. >Date: Wed, 14 Jun 2000 14:57:39 EDT > >Hi, > >Could anyone give me a ballpark figure for what might be the price of 650 >GB of DASD ? > >TIA. > >Rajeev P Dhanawade >Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage [...] 30621 170 35_Re: how to find the size of a table8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Wed, 14 Jun 2000 15:26:59 -0500326_us-ascii RVA is Ramac Virtual Array, IBM's DASD. Using this we can have 3390 logical drives. My question, Is this DASD wastage is applicable to RVA logical 3390-3? I heard that in RVA logical 3390 , this wasted, unused space doesn't use any of the REAL hard drive disk space in the RVA. Can anybody explain a little bit. [...] 30792 693 35_Re: how to find the size of a table15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Thu, 15 Jun 2000 08:48:37 +1000572_iso-8859-1 Yes, that is correct.

On an RVA only disk that is actually written to consumes space. The RVA takes each file, compresses it, breaks it into 2K chunks and scatters it across the internal drives.

Simply having the disk defined consumes trivial or no space.

This can be seen easily when you allocate 1024 3390-3 on a 420GB RVA. Thats about 3 TB of logical storage backed up by 420 GB of effective storage yet the system does not stop - why ? because no space is consumed by defining drives. It is consumed solely by files on the drives. [...] 31486 50 12_I/O Question8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 14 Jun 2000 16:23:24 -0700456_us-ascii Hi !

Have an I/O question I would like to put to the list. At Vertical Deferred Write Threshold , as per my understanding , a maximum of 128 unavailable pages can be written to Disk per I/O for a data set that exceeded the threshold .

Is the cost of one I/O same irrespective of the number of pages being externalized in that I/O ? In fact, I thought that more the number of pages being externalized in one I /O , better it is. [...] 31537 77 16_Re: I/O Question15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 15 Jun 2000 01:44:05 +0100683_us-ascii Hello Ritu,

I suggest you start by following the thread. Which is quite long.

Regards,

Toine Michielse



ritu zee @RYCI.COM> on 06/15/2000 12:23:24 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: I/O Question





Hi !

Have an I/O question I would like to put to the list. At Vertical Deferred Write Threshold , as per my understanding , a maximum of 128 unavailable pages can be written to Disk per I/O for a data set that exceeded the threshold . [...] 31615 42 24_SYSCOPY ENTRIES QUESTION12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Wed, 14 Jun 2000 19:50:54 -0400461_ISO-8859-1 Hi All,



We have just found what is either a bug or a problem in our load jobs. When we run a load resume yes to load aditional data into a single partition we find that an entry is placed into SYSCOPY for each partition of the table with a Z ICTYPE indicating that every partition has had a load resume yes job run against it, which they have not. Has anyone noticed this and is there a solution. We are on DB2 Ver 5.1 of OS-390. [...] 31658 46 19_NOT CATLG 2 PROBLEM12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Wed, 14 Jun 2000 19:50:55 -0400532_ISO-8859-1 Hi All,

While this isn't specifically a DB2 problem, I was hoping to find out if it's a site specific problem or a system design issue. We are running OS-390 1.3 and when we run a job that creates a tape dataset and that dataset already exists we get the NOT CATLG 2 error, but the return code for the step is still 000. I know this used to be the case, but thought it had been fixed in the current ersion of the operating system. Can anyone either confirm if this is indeed abnormal. I thought for sure that [...] 31705 70 16_Re: I/O Question14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 14 Jun 2000 20:19:41 -0400552_ISO-8859-1 The number of pages that can be scheduled for one I/O engine is 128, but the number of pages per write is normally 32 or less when the write is triggered by VDWQT. The overididing issue is an internal threshold of 150 RBAs, as the maximum range of pages that can be written for one physical write. The intent is to avoid a write spanning more than one cylinder. So, in most systems, you will find that the average pages/write is quite low for your online system. The common range I see across dozens of installations is between 1.5 and [...] 31776 125 23_Re: NOT CATLG 2 PROBLEM25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG31_Thu, 15 Jun 2000 10:06:46 +0800339_us-ascii

Hi Dennis,

I don't understand by the meaning of fix in this context. You are trying to catalog a dataset which is already there and so such message is issued. We are also running the same version you have and my apps hit this problem once a while as they do not delete the previous dataset or do not uncat it. [...] 31902 348 25_Re: DB2 Developer's Guide15_Gabrielle_Assoc29_Gabrielle_Assoc@EMAIL.MSN.COM31_Wed, 14 Jun 2000 21:09:07 -0500455_iso-8859-1 RE: DB2 Developer's Guide, V4If you decide to order Gabrielle's book, please order the second edition of DB2 for OS/390 Development for Performance (over 1,000 pages) book current with V6 features and facilities including new function V6 APARs (several of which are features found in V7 back fitted to V6). It is a more advanced sequel to the earlier book DB2: Design and Development Guide that Addison_Wesley published in three editions. [...] 32251 28 23_Re: NOT CATLG 2 PROBLEM11_Tom Flesher13_TomF@ENET.COM31_Wed, 14 Jun 2000 21:10:06 -0700437_us-ascii Dennis,

It's always been this way.

The jobstep terminates with a normal return code, but the dataset wasn't cataloged, typically because a dataset already existed having the same name.

Usually the new (uncataloged) dataset exists, but was placed on a different volume, giving you the opportunity to recover without having to re-run the job in question. This is presumably better than causing an abend. [...]