1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 2000, week 1 2 67 26_Re: db2set return code -1011_Bruce Allen17_ballen@SPOTON.COM30_Wed, 1 Nov 2000 19:24:34 +1100587_- Hi Tim, rc of -10 is fixed by setting the permisions as documented in the Admin Guide Chap 13 under Establish Environment Variables and the Profile Registry: Setting Environment Variables on UNIX Systems. Well, my rc of -10 was fixed this way.

However, I do know how one could get from the error message to the document. I found the doco by accident. And creating new instances or versions of DB2 leaves you with another manual update. If I remember, running the command as root also returns an error (different error; so maybe some other problem), but the command worked. [...] 70 59 50_Clearing recovery pending flags after LOAD failure19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Wed, 1 Nov 2000 03:49:30 -0600829_us-ascii Sending this to the list for a NIF.

============ START OF COPIED MESSAGE =================

Philip

As discussed I have doubts about whether we needed to rebuild indexes after yesterdays load problems. Would you mind sharing this with the DB2 group ?

LOAD DATA LOG NO INDDN SYSREC00 RESUME YES - INTO TABLE PDB4PJS0.T5080PERS_FNCL_STA - (SOURCE_SYS_EXT_DT POSITION(1) DATE EXTERNAL(10), - DT_ADDED_TO_DWH POSITION(11) DATE EXTERNAL(10) DEFA - SOURCE_SYS_ID POSITION(21) CHAR(10), - PERS_CUST_ID POSITION(31) INTEGER, - GEO_ID POSITION(35) INTEGER, - PERS_FNCL_SNAP_MTH POSITION(39) INTEGER, - PART_NUM POSITION(43) SMALLINT, - FINANCL_ACORN_CAT POSITION(45) CHAR(1), - FINANCL_ACORN_GRP POSITION(46) CHAR(2), - FINANCL_ACORN_TYP POSITION(48) CHAR(2), - NUM_POLICIES POSITION(50) SMALLINT, [...] 130 51 37_Re: Moving Tablespaces to another DB210_John Hardy27_john_j_hardy@CONSULTANT.COM30_Wed, 1 Nov 2000 04:54:13 -0600392_ISO-8859-1 If you don't have BMC....

You have (at least) two options.

DSNTIAUL from one DB and LOAD the other (as you said) This is nice and bulletproof, and very expensive.

DSN1COPY from a Full Image Copy is much quicker, but will require an XLAT for DBID/OBID in this case, and you may encounter problems if you're not careful (search the Archives for more info). [...] 182 60 35_Re: Mirror'd DASD Recovery Scenario11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Wed, 1 Nov 2000 08:02:11 -0500544_iso-8859-1 We too would like any feedback on mirror site recovery and DB2. We feel that for some scenarios (i.e. a hurricane is coming, allowing an orderly shutdown), the mirror will work well. What we are not sure about is the instant failure scenario, such as an explosion at the data center. As near as we can tell we would have to mirror the archive logs (at least as many as you would need to set a conditional restart). We think we would also need some point to recover forward FROM so we also think image copy. We are assuming that [...] 243 24 20_db2 stored procedure12_Rakesh Singh14_rasun@JUNO.COM30_Wed, 1 Nov 2000 05:24:02 -0800343_- hi folks,

I am trying to bind a client to a stored procedure on os390. both client an server reside on mainframe but on different DB2 subsystem .can somebody post a remote bind statement or point me to a site where i can get that

The client has both Plan and package. the servre DB2 stored procedure just has the package. [...] 268 65 24_Re: db2 stored procedure14_Philip Gunning18_pgunning@PHEAA.ORG30_Wed, 1 Nov 2000 08:48:37 -0500304_us-ascii Rakesh, You don't bind the client to the stored procedure. The stored procedure has a stand alone package on the server. You execute it via the call statement. The procedure has to be "defined" to Db2 for OS/390. See Chapter 7 of Application Programming Guide and the Admin Guide. HTH Phil [...] 334 25 24_Re: db2 stored procedure13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 1 Nov 2000 08:54:18 -0500318_iso-8859-1 Hi Rakesh, Like Phil said, you don't BIND any client to any SP. The SP has a package which must be bound in a collection, and if I recall collectly, you specify the collection in the Create procedure (in V6) or in the SYSPROCEDURES entry in v5.

However you do need to grant 2 sets of authority. [...] 360 40 13_Re: DB2 tools16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 1 Nov 2000 09:03:23 -0500322_iso-8859-1 Rush, I've participated in product evaluations at four sites. In every case, Platinum (now CA) products were chosen. I suspsect that two things will steer people in other directions in the future: 1) Platinum was acquired by CA. BMC was not. 2) CDB is selling (at a fair price) some pretty good utilities. [...] 401 88 54_Re: Clearing recovery pending flags after LOAD failure16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 1 Nov 2000 09:10:01 -0500321_iso-8859-1 Phiip, You will first need to fix the 00D70014 (out of space) by increasing the PRIQTY/SECQTY or by moving the object to a different STOGROUP or adding space to the STOGROUP, depending upon why you are out os space. You will have to recover the indexes since they may be out of snych with the tablespace. [...] 490 92 35_Re: Mirror'd DASD Recovery Scenario16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 1 Nov 2000 09:14:58 -0500401_iso-8859-1 We use mirrored DASD for one of our subsystems. We mirror the entire subsystem (except for DSNDB07). Recovery is bulletproof and easy.

We considered mirroring a subset. In that case we would place the 'less critical' databases in a non-mirrored STOGROUP then recover them to the newest available quiesce point (TORBA or TOCOPY) based on what copies/logs were avaialble offsite. [...] 583 100 35_Re: Mirror'd DASD Recovery Scenario14_Thomas, Steven21_Steven_Thomas@BMC.COM30_Wed, 1 Nov 2000 08:42:30 -0600392_iso-8859-1 I've seen this work very well at several sites. As has been mentioned elsewhere, make sure you mirror all system stuff like Catalog, Directory, Bootstraps and active logs, and make sure the archives are available at the remote site - it's best to take one copy to a Unit based at the remote site. If you get a problem, Warmstart DB2 at the remote site and bingo, you're done. [...] 684 21 24_Re: db2 stored procedure16_Michael McCarthy18_mmccarthy@DTCC.COM30_Wed, 1 Nov 2000 09:46:00 -0500604_us-ascii Hi Rasun,

What you need to do on the client side is to BIND the PLAN with a PKLIST of (., ..). This will enable the client program to access the remote stored procedure. DDF must be properly configured for communication between the 2 subsystems.

-Hope this helps,

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. 706 67 39_Re: Column update on key of part. index11_?????? ????24_dimokap@INTERAMERICAN.GR30_Wed, 1 Nov 2000 15:51:11 +0200619_iso-8859-7 I will add something that may help. The ability to update columns participating in a partitioned index is supported only for tables created AFTER the application of this new improvement (through APAR PQ16946).

Popy A. Dimoka Athens > ---------- > From: Thomas_Abbott@HESC.COM[SMTP:Thomas_Abbott@HESC.COM] > Reply To: DB2 Data Base Discussion List > Sent: Τρίτη, 31 Οκτωβρίου 2000 9:28 μμ > To: DB2-L@RYCI.COM > Subject: Column update on key of part. index > > I have a question concerning the update of a column which is > defined > as the key of a partitioned index. We are currently at DB2 V5. [...] 774 78 7_Re: Hi,0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 1 Nov 2000 09:05:16 -0600330_us-ascii No need for a separate product, try DB2 Views!

Add a column to the table to contain a unique user identifier (ie userid). The View selects all col (except userid) WHERE USERID= current user.

Grant users access to the view only, no direct access to the table. Works fine, we've been doing it for years. [...] 853 28 12_UDB question0_24_db46@DAIMLERCHRYSLER.COM30_Wed, 1 Nov 2000 10:05:02 -0500296_us-ascii On our os/390 mainframe for db2 version 5, we can define a primary key and a unique index on the same fields. Now my DBA says that when we tried to do the same thing on a table on our unix server for UDB (db2 version 6), it will not allow it because if references the same columns. [...] 882 38 37_Effect of Reoptvar on Dynamic queries13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM30_Wed, 1 Nov 2000 10:13:41 -0500396_us-ascii Hello List ,

Some questions regarding using a gateway to access DB2 V5 / OS 390 .

The scenario : Many clients use a query writing tool , which connect to DB2 through a gateway . This gateway is bound as a plan , and entry in SYSIBM.SYSPLAN has the following values : Degree = 1 Reoptvar = N Isolation = U The queries are read only , often joining two or more tables . [...] 921 54 16_Re: UDB question13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 1 Nov 2000 10:16:20 -0500368_us-ascii Do not create the table with the primary key, just create the table. Then, create the unique index with the columns which will make up the primary key, ascending or descending as you see fit. Then, alter the table to add the primary key.



Lynne A. Flatley New England Financial (617) 578-4079 (work) (781) 718-0919 (cell) lflatley@nefn.com [...] 976 54 16_Re: UDB question0_15_leon@CA.IBM.COM30_Wed, 1 Nov 2000 10:27:16 -0500436_us-ascii >Is defining a primary key in UDB also work as an index on those columns >defined?

Yes,unlike DB2 for OS/390, defining primary key on a DB2 UDB for UNIX, Windows will automatically create an index.

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



db46@DAIMLERCHRYSLER.COM on 11/01/2000 10:05:02 AM

Please respond to DB2 Data Base Discussion List [...] 1031 70 39_Re: Column update on key of part. index10_Shukla, JR18_JR.Shukla@BNSF.COM30_Wed, 1 Nov 2000 09:30:30 -0600385_iso-8859-7 You may want to check the release level of DB2 in each environment because with DB2 V6 you may update a column in a partitioning index.

JR Shukla jr.shukla@bnsf.com

-----Original Message----- From: ?????? ???? [mailto:dimokap@INTERAMERICAN.GR] Sent: Wednesday, November 01, 2000 7:51 AM To: DB2-L@RYCI.COM Subject: Re: Column update on key of part. index [...] 1102 45 25_Re: db 2 stored procedure12_Rakesh Singh14_rasun@JUNO.COM30_Wed, 1 Nov 2000 10:48:35 -0500286_- hi mike, Thanks for replying. Now i am getting confused The previous message i received from phil and david said i don't need to bind. my client plan with the server package. As they suggested that i can directly give a call and when i do that i get a -805 that is a bind error. [...] 1148 68 39_Re: Column update on key of part. index16_Carol Rentschler20_rentschler.ch@PG.COM30_Wed, 1 Nov 2000 10:35:45 -0500537_Windows-1253

If you can do it in your development environment but not in production and you are at the same DB2 maintenance level, the problem is ....

The PTF/APAR makes it so that you can update partitioning index columns of tables where the partitioning index was created after the PTF/APAR. It did not convert any existing tables or indexes. So for any partitioned table that you want to update one of the columns in the partitioning index, you will have to drop and recreate the partitioning index for the table. [...] 1217 80 16_Re: UDB question0_24_db46@DAIMLERCHRYSLER.COM30_Wed, 1 Nov 2000 10:57:25 -0500584_us-ascii Will I still see them in SYSCAT.INDEXES?

Dean









leon@CA.IBM.COM@RYCI.COM> on 11/01/2000 10:27:16 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: UDB question



>Is defining a primary key in UDB also work as an index on those columns >defined?

Yes,unlike DB2 for OS/390, defining primary key on a DB2 UDB for UNIX, Windows will automatically create an index. [...] 1298 40 59_Help with a member from SDSNSAMP - DSNTIJCC do you have it?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 1 Nov 2000 15:58:17 -0000697_iso-8859-1 Anybody have this ... ?

We do not have the Control Centre SMPE stuff here on site and so do not have the above member ...

can anybody send me this member from their SDSNSAMP ? it is just a stored proc ..

thanks

Les

Leslie Pendlebury-Bowe DB2 DBA OS390 SAP DB2 Certified









********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Sony cannot accept liability for statements made which are clearly the sender's own and not made on behalf of Sony. [...] 1339 50 46_Using only pool threads for each cics region ?0_20_Gerhard.Heiss@RUV.DE30_Wed, 1 Nov 2000 17:06:58 +0100555_iso-8859-1 Hi,

on our production system (DB2 V5, CICS/ESA V4R1) we are currently running 34 cics regions with DB2 access and approx. 230,000 transactions per hour. Some years ago there was a decision to have only pool-threads and keep RCT-definitons equal for each region:

TCB DISPATCHING.(DPMODE) HIGH ROLLBACK.........(ROLBE) YES AUTH=................. SIGNID,*,* TYPE..............(TYPE) POOL TWAIT............(TWAIT) YES ACTIVE LIMIT.....(THRDA) 30 PROTECTED THREADS(THRDS) 0 THREAD MAX.......(THRDM) 40 ACCOUNTING/TRAN.(TOKENE) NO [...] 1390 54 16_DB2 tools -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Wed, 1 Nov 2000 11:04:03 -0500623_US-ASCII Hello Rush,

We had the whole BMC Suite for DB2 and gave it up for Platinum mainly because BMC's maintenance fees were escalating due to our CPU upgrades and Platinum made us a $$ offer we couldn't refuse.

The DBAs here agree that nothing really compares with BMC. Their tools were functional, user friendly and trouble free. Their technical support was UNPARALLELED. We would even occasionally enlist their support for non-BMC related problems and they gladly obliged. If one of their products gave us a problem and they suspected it was caused by some other vendor's software, they would prove [...] 1445 18 18_Re: Available tool11_Jeff Kalman15_jkalman@CSC.COM30_Wed, 1 Nov 2000 11:17:44 -0500414_us-ascii Hi everyone, Is there a tool available to be able to keep DB2/UDB tables on the server in sync with the DB2 tables on the mainframe?

TIA.

Jeff Kalman

================================================ 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. 1464 111 16_Re: UDB question16_Michael McCarthy18_mmccarthy@DTCC.COM30_Wed, 1 Nov 2000 11:19:31 -0500456_us-ascii Dean,

You will still see the index in SYSCAT.INDEXES. The name will be SQL, or something to that effect. If you create the index first, and then alter the primary key onto the table, you can create the index as you see fit, such as name, and bufferpool you would like. Regardless of how the PK index is created, if you have a query, that you believe should use it, make sure RUNSTATS were done it after the key was created. [...] 1576 77 25_Re: db 2 stored procedure16_Michael McCarthy18_mmccarthy@DTCC.COM30_Wed, 1 Nov 2000 11:22:55 -0500700_us-ascii Hi Rasun,

You won't see the stored procedure package on the remote system. does it run successfully?

-Mike.









Rakesh Singh on 11/01/2000 10:48:35 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Michael McCarthy/DTC) Subject: Re: [DB2-L] db 2 stored procedure







hi mike, Thanks for replying. Now i am getting confused The previous message i received from phil and david said i don't need to bind. my client plan with the server package. As they suggested that i can directly give a call and when i do that i get a -805 that is [...] 1654 100 53_Re: Problems introduced with CAE 6.1 using MSAccess??0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Wed, 1 Nov 2000 10:22:07 -0600409_us-ascii Yes, this problem looks like the same one we ran into.

The solution for us was to remove CAE and use DB2 Connect 5.2 fp 6 or FP10 (for your group it may be higher release) for any user using MS Access or MS Query and it should work fine. Appears to be a problem using CAE with DB2 V6. We didn't experience this problem usingh CAE when we were on DB2 V5, only until we migrated to DB2 V6. [...] 1755 78 20_Re: DB2 tools -Reply14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM30_Wed, 1 Nov 2000 10:27:22 -0600544_iso-8859-1 The below reply is a ditto for me but I still have my BMC products. I have the BMC Recovery Manager, Reorg Plus and Copy Plus (which I can utility products). These products are the best! They WORK and BMC supports me like they are part of TTX. I have 2 LPARS one has my legacy environment and the other has SAP (30,000+) tables. I can perform a recovery on my production SAP system at the disaster site in 4 hours. This includes bringing back DB2 (which the BMC Recovery Manager product does with 2 jobs it generates). It's the [...] 1834 81 20_Re: DB2 tools -Reply15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Wed, 1 Nov 2000 10:28:21 -0600540_iso-8859-1 Do you mean that you actually FOUND their tech support! It was a circuitous journey that I took before I did that! After CA acquired Platinum I ended up calling phone numbers that I found on their web site at random and asking whoever answered if they knew what the number for support of the Platinum products was (really, truly!). Every time I called the published number I got dropped through to the default category that is licensing. The person in licensing didn't know what I was talking about hence the random search. [...] 1916 104 16_Re: UDB question22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM30_Wed, 1 Nov 2000 11:30:21 -0500481_iso-8859-1 I think yes. However, DB2 generates the index name. Lynn's method allows gives you more control. You can specify the index name, tablespace, bufferpool for the index.



Mike Piontkowski TP&S Technical Maintenance Voice: 302.886.4612 Fax: 302.886.4749



-----Original Message----- From: db46@DAIMLERCHRYSLER.COM [mailto:db46@DAIMLERCHRYSLER.COM] Sent: Wednesday, November 01, 2000 10:57 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] UDB question [...] 2021 39 62_Repost: New White Paper: "DB2 UDB and Total Cost of Ownership"13_Morrill, John12_JohnM@VP.NET30_Wed, 1 Nov 2000 09:34:55 -0700676_- Dear DB2 Interested Parties,

Database consultant, Richard Yevich (Yevich, Lawson and Associates, Inc., ylassoc.com) has made a new white paper available entitled, "DB2 Universal Database and Total Cost of Ownership (TCO)".

The paper examines some of the advantages of DB2 that have been acknowledged by YL&A clients and DB2 customers in production environments. It shares their experiences, and is a tactical guide to address questions YL&A have received from clients. These experiences focus on the people, technology, and business cost variables of concern to their clients. The paper groups the factors that impact TCO under the areas of Scalability / [...] 2061 182 73_Repost: NEW BOOK: "Data Warehouse Project Management" (Adelman an d Moss)13_Morrill, John12_JohnM@VP.NET30_Wed, 1 Nov 2000 09:39:44 -0700620_- Dear DB2 Interested Parties,

"Data Warehouse Project Management" by Sid Adelman and Larissa Moss (Addison Wesley Professional; ISBN: 0201616351) is now available. It will be of interest to those of you who have been given the assignment of delivering a data warehouse and want to understand the minefields before some of your favorite parts are blown off. It will also be of interest to those who failed miserably as data warehouse project managers...you may want to humbly revisit the many errors that led to your disgraceful dismissal. Finally, it will be of interest to those who succeeded but have not [...] 2244 70 20_Re: DB2 tools -Reply15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Wed, 1 Nov 2000 10:37:37 -0600295_iso-8859-1 AND I forgot to add that when I ordered a recent upgrade I got routed to FOUR (count'em), FOUR different numbers before somebody finally figured out who I should be talking to. I did get my tapes in a timely manner once I finally talked to the right person.

Linda (again) [...] 2315 26 25_Re: db 2 stored procedure13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 1 Nov 2000 11:38:57 -0500396_iso-8859-1 Hello again Rasun,

> i get a -805 that is a bind error.

Yes, -805 says missing or incorrect version of DBRM. In the SQLERRM you should see a dbrm name What's the name there? Can you post your CALL statement?

You do not need a plan for the stored procedure package, but you can ignore it anyway. Having one hurts nothing other than wasting time and resources. [...] 2342 31 21_-904 with RC 00C900960_29_paul.packham@POSTOFFICE.CO.UK30_Wed, 1 Nov 2000 16:38:58 +0000487_us-ascii Hi,

We have hit a problem on DB2 V6.1 (OS/390 2.8) where an application has started getting -904 with RC 00C90096. This process worked OK on V5. The program is failing on an update statement even though there is a 'lock table .....in exclusive mode' coded prior to the update. There are no commits so the lock is not being released. We have been recommended to apply PQ29110/PQ24032. These are already applied. Another suggestion was PQ42241 but this is still open. [...] 2374 13 20_Re: DB2 tools -Reply11_Ioana Masek29_Ioana_Masek@AISMAIL.WUSTL.EDU30_Wed, 1 Nov 2000 10:39:19 -0600305_us-ascii Just curious... What are your opinions about PM? Ioana

================================================ 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. 2388 23 39_Re: Column update on key of part. index16_Carol Rentschler20_rentschler.ch@PG.COM30_Wed, 1 Nov 2000 11:32:40 -0500429_us-ascii Sorry about the previous garbage msg... let's try this again...

If you can do updates in your development environment but not in production and you are at the same DB2 maintenance level, the problem is ....

The PTF/APAR makes it so that you can update partitioning index columns of tables where the partitioning index was created after the PTF/APAR. It did not convert any existing tables or indexes. [...] 2412 113 27_Re: DB2 tools -Reply -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Wed, 1 Nov 2000 11:40:58 -0500413_US-ASCII The secret, Linda, is allying yourself with an account rep (salesman) and impressing upon him/her that any future sales are predicated upon you getting some immediate action. Usually they'll call you back in a few days with a phone number and the name of a support rep who will give you "personalized" attention. This just means they'll at least listen to and record your problem. Then you wait ... [...] 2526 114 50_Re: Using only pool threads for each cics region ?0_26_truman.g.brown@VERIZON.COM30_Wed, 1 Nov 2000 11:47:05 -0500479_us-ascii



Bad performance choice.

Best to define one entry thread per transaction, and for high activity transactions define protected entry threads (reusable) with multiple TCB's (if necessary). Then use TWAIT=POOL and define an appropriate number of pool threads.

Only downside to protected entry threads is that they accumulate SMF accounting records, e.g., the granularity of performance analysis is lost. BUT - no sign on, auth check, etc. [...] 2641 127 39_Re: Column update on key of part. index14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM30_Wed, 1 Nov 2000 08:51:30 -0800504_windows-1253 The drawback to this approach of course is that you cannot drop and recreate a partitioning index by itself, rather you must drop and recreate the tablespace on down. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

-----Original Message----- From: Carol Rentschler [mailto:rentschler.ch@PG.COM] Sent: Wednesday, November 01, 2000 9:36 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Column update on key of part. index [...] 2769 28 27_Re: DB2 tools -Reply -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Wed, 1 Nov 2000 11:49:02 -0500365_US-ASCII We never used DB2 PM. We've had BMC's Activity Monitor but replaced it with Platinum's Detector and Subsystem Analyzer products due to maintenance cost considerations. The Platinum products are OK but the 2 together don't add up to the BMC Activity Monitor. We originally sampled almost all of the available monitors for DB2 and liked BMC's the best. [...] 2798 65 72_DBRMS now - Help with a member from SDSNSAMP - DSNTIJCC do you ha ve it?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 1 Nov 2000 16:50:10 -0000599_iso-8859-1 Anybody have the following DBRMS to go with the attached?

they are :

DSNACCMD DSNACCQC DSNACCAV DSNACCDL

maybe you can zip them up? if nott hen do not worry and just send them unzipped

thanks to Kurt W. Sahlberg for the Stored Proc ...

thanks

Les

> -----Original Message----- > From: Pendlebury-Bowe, Leslie > Sent: Wednesday, November 01, 2000 3:58 PM > To: 'db2list' > Subject: Help with a member from SDSNSAMP - DSNTIJCC do you have it? > > Anybody have this ... ? > > We do not have the Control Centre SMPE stuff here on site and [...] 2864 27 45_CLI Question: Char with For bit data (Urgent)33_Christopher I Schmidt/Houston/IBM18_cschmid@US.IBM.COM30_Wed, 1 Nov 2000 11:09:35 -0600543_us-ascii Hello,

I am trying to read data from a column set as CHAR(13) with For Bit Data (I'm am using Generate_Unique() to get data for this column) into a c++ program using the db2 cli api. Unfortunately I am not having success with getting data out of the table. If I set the c type to SQL_C_CHAR, I get a character string with size 26. If I try to insert that data into a column in another table, I get errors. If I set the c type as SQL_C_BINARY, the variable never changes over multiple fetches. Are there examples somewhere [...] 2892 114 16_Re: UDB question14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM30_Wed, 1 Nov 2000 09:06:26 -0800487_iso-8859-1 Yes, the indexes will appear in SYSCAT.INDEXES. However, they have a SCHEMA of SYSIBM, they cannot be dropped explicitly, rather you have to drop the primary key. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

-----Original Message----- From: db46@DAIMLERCHRYSLER.COM [mailto:db46@DAIMLERCHRYSLER.COM] Sent: Wednesday, November 01, 2000 9:57 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] UDB question [...] 3007 85 25_Re: -904 with RC 00C9009610_Missy Case28_Missy.Case@FIRSTDATACORP.COM30_Wed, 1 Nov 2000 11:19:06 -0600324_us-ascii Paul,

The only odd locking issue we encountered with V6 is a deadlock on the delete/insert into SYSTATS! We had recently changed our catalogs to lockmax 0 to disable lock escalation & they actually changed some back to 'avoid' the problem. It helped once (by chance only) & then reoccurred (of course)! [...] 3093 65 25_Re: -904 with RC 00C9009619_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 1 Nov 2000 11:22:52 -0600343_ISO-8859-1 Hi Paul,

00C90096 = Explanation: The page, row or LOB lock on the page or subpage identified by NAME in message DSNT500I or DSNT501I caused the total number of page, row or LOB locks concurrently held to reach the installation maximum number of page, row or LOB locks (NUMLKUS) allowed for a single agent in the system. [...] 3159 13 51_DB2's XML extender for travel industry integration?13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Wed, 1 Nov 2000 09:35:09 -0800387_- Has anybody used the DB2 XML extender for work with Hospitality Industry Technology Integration Standards partners? (www.hitis.org)

-HJC

================================================ 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. 3173 36 24_DB2 Connect via MSAccess9_Colin Fay13_cfay2@CSC.COM30_Wed, 1 Nov 2000 12:54:38 -0500329_us-ascii Hi,

I am sucessfully connecting to OS/390 Db2 v 5 from Db2Connect v 7.1 on NT using command line processor.

I can sucessfully connect the same through MSAccess as long as I have local NT administrator rights.

Once those rights are removed , when selecting a data source , I get these messages: [...] 3210 110 20_Re: DB2 tools -Reply0_22_BILL_GALLAGHER@PHL.COM30_Wed, 1 Nov 2000 13:32:28 -0500525_us-ascii We've had the same experience. We were a BMC user for about 10 years or so, and the bean counters decided to replace our BMC suite of tools with the "comparable" set of Platinum/CA tools earlier this year. I've not been a very happy camper since then.

Since we made the switch, I have discovered that (a) some of the tasks that I used to be able to perform using the BMC suite of tools now takes on average twice as long (or more) with the Platinum tools; (b) some of the tasks that I used to be able to [...] 3321 16 20_Re: DB2 tools -Reply26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Wed, 1 Nov 2000 12:38:10 -0600435_- If you've got SAS you can get Merrill's stuff for peanuts($1200US) and produce the same(or better) reports. www.mxg.com Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 3338 73 50_Re: Using only pool threads for each cics region ?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 1 Nov 2000 12:38:34 -0600657_ISO-8859-1 George, doesn't using TOKENE=YES help somewhat SMF-wise -- don't recall from memory.

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, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 3412 49 15_Datajoiner View18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Wed, 1 Nov 2000 14:09:29 -0500589_iso-8859-1 Can anyone enlighten me on a question with a View on Datajoiner. We are running DB2 V5 OS/390 using Datajoiner V2 (I think)...

My question is: I create a nickname in Datajoiner on a view that exists on my OS/390 DB2 subsystem: ie: CREATE NICKNAME EG.VIEWNAME FOR SYST.PTTB.VIEWNAME So now I have a nickname down on Datajoiner for this view to be used. Lets say that the application group decides they want to change the context of the OS/390 DB2 view. Either adding more columns to the select or adding inner joins, whatever. The DB2/DBA does his drop and recreates [...] 3462 20 28_Re: DB2 Connect via MSAccess13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Wed, 1 Nov 2000 13:09:23 -0600338_- Admin rights are needed to install and sometimes needed to set up the first datasource. No rights are needed (other than access to the tables/views etc. you are using) on the NT workstation. I assume you are using DB2 Connect PE and not EE.

Are you logging off between attempts.....logging off as self and back on as admin? [...] 3483 80 19_Re: Datajoiner View11_David Ayers24_david.ayers@HIGHMARK.COM30_Wed, 1 Nov 2000 15:12:20 -0500407_us-ascii Steve, if the view changes at the data source you must 1 - drop / recreate the nickname that references the remote view 2 - regrant security on the nickname 3 - (optional) - runstats on the view nickname 4 - rebind packages that use the view nickname

-hth dave









"Whittaker, Stephen" @RYCI.COM> on 11/01/2000 02:09:29 PM [...] 3564 64 84_-181 how to determine what date is in error when multiple dates a re being inserted.15_Neff, Stephen R16_NeffSR@STATE.GOV30_Wed, 1 Nov 2000 15:08:06 -0500416_- Hello,

We have SQL insert statement that has multiple dates to insert into a single row. There are 6. The questions was asked that if a return code of -181 is returned is there a way to know which of the 6 dates caused the error. The application programmer is trying not to code a check on the dates but let DB2 tell it if a date is bad. This is DB2 V5 or V6 on an OS390 platform. Any suggestions? Thank you 3629 69 28_Re: DB2 Connect via MSAccess9_Colin Fay13_cfay2@CSC.COM30_Wed, 1 Nov 2000 15:19:46 -0500591_us-ascii Hi Shauna,

You are right , I am using DB2 Connect PE.

I am logging off and on as self (user-client) and local administrator and get different results.

My data sources are set up as System DSN's .

One thing I notice is that the under the user-client in the settings =>control panel=> odbc sources=> drivers the IBM ODBC DB2 DRIVER entry does not have release number (7.01.00.00 ) and company (IBM) and file (DB2CLI.dll) details filled in , whereas under the adminsitrator id these details appear. It's as if the user-client can not 'see' the driver. [...] 3699 48 89_Re: -181 how to determine what date is in error when multiple dat es a re being inserted.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 1 Nov 2000 14:23:13 -0600625_ISO-8859-1 the column will be identified in SQLCA . . .



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, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 3748 27 15_Curious problem14_subrata mondal25_subratamondal@HOTMAIL.COM28_Wed, 1 Nov 2000 20:40:02 GMT423_- Hi all.,

I have a stored procedure and when i run it my transaction log gets full. Once full I canot do any work.

Can anyone help me what is to be done on my stored procedure so that it does not fill up with transaction Log.

Thanks Subrata

_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. [...] 3776 44 89_Re: -181 how to determine what date is in error when multiple dat es a re being inserted.19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Wed, 1 Nov 2000 12:45:30 -0800567_iso-8859-1 The problem with letting DB2 do this one is that potentially you'll go through 6 bad responses - one for each date. The SQLCA after the -181 will tell you the number of the first column which had the format error. Next time the second, and so on.

Without knowing the architecture (client/server, batch, OLTP?) it's hard to pinpoint a best way, but generally our shop standard is to edit every field possible on input before attempting the database update. That way all errors can be reported/highlighted to the user for correction in one pass. [...] 3821 53 21_UDB V7 PE- windows 9517_Anand Thippeswamy19_Thippesa@MEIJER.COM30_Wed, 1 Nov 2000 15:49:19 -0500301_US-ASCII Hi list, I downloaded UDBV7 Personal Edition for windows 95 version and successfully installed it. I am getting "[IBM][JDBC Driver] CLI0622E Error accessing JDBC administration service extensions." while invoking Control Center or Command Center?. Any ideas..

Regards Anand Meijer Inc. 3875 46 25_Re: -904 with RC 00C9009613_Lisa McClaine26_lisa.mcclaine@BLACKBOX.COM30_Wed, 1 Nov 2000 15:52:07 -0500301_us-ascii Paul,

I assume you meant the OS/390 Tech Suport home page, not the S/390 homepage since you are running OS/390. Can you send me the link for that page? We are upgrading to V6 soon and I'd like to see what you're talking about with the data corruption when using the copy utility. [...] 3922 62 89_Re: -181 how to determine what date is in error when multiple dat es a re being inserted.15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Wed, 1 Nov 2000 16:00:58 -0500413_iso-8859-1 I had the same problem. I could not find out this from SQLCA. What field in SQLCA contains this info?. I checked all of them.

Thanks...sibi

-----Original Message----- From: Ohling, Tim R - CNF [mailto:Ohling.Tim@CNF.COM] Sent: Wednesday, November 01, 2000 02:46 PM To: DB2-L@RYCI.COM Subject: Re: -181 how to determine what date is in error when multiple dat es a re being inserted. [...] 3985 20 28_Re: DB2 Connect via MSAccess13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Wed, 1 Nov 2000 15:04:39 -0600407_- I have Version 7 installed on my workstation. We are in the process of migrating from 6 to 7 and are in the testing stage. I had an administrator sign onto my workstation to install V7 and then they logged off and I logged on. I initially could not get any of my datasources to work so I dropped them (some on purpose and some dropped when I tried to use them the first time). I then recreated them. [...] 4006 106 19_Re: Datajoiner View18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Wed, 1 Nov 2000 16:09:23 -0500480_iso-8859-1 David: Thanks...thats kind of what I figured. I did a quick test and this is exactly what I had to do. I had to drop and recreate the nickname/view down on Datajoiner. Thanks for the info....

Steve Whittaker DB2/DBA Carolina Power & Light (919) 546-7267 Raleigh, NC 27613



-----Original Message----- From: David Ayers [mailto:david.ayers@HIGHMARK.COM] Sent: Wednesday, November 01, 2000 3:12 PM To: DB2-L@RYCI.COM Subject: Re: Datajoiner View [...] 4113 86 89_Re: -181 how to determine what date is in error when multiple dat es a re being inserted.19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Wed, 1 Nov 2000 13:32:48 -0800531_iso-8859-1 It seems to be error specific.

On a -181, I can't find the column reference that I remembered. On a -180, it will show the bad value in SQLERRMC.

Now I want to find the error where it did tell me the column number.

Back to "It Depends"

Tim

-----Original Message----- From: Philip, Sibimon [mailto:SPhilip@CSXLINES.COM] Sent: Wednesday, November 01, 2000 1:01 PM To: DB2-L@RYCI.COM Subject: Re: -181 how to determine what date is in error when multiple dat es a re being inserted. [...] 4200 100 27_FW: Miscellaneous questions13_Doctor, Nadir24_Nadir.Doctor@BGEHOME.COM30_Wed, 1 Nov 2000 17:05:47 -0500406_iso-8859-1 1) This is explained elaborately in the usage notes section for the "activate db" command in the Command Reference manual.

2) I don't see how this can help much - To prevent confusion, I don't use aliases as they could be kept different on various clients.

3) This is recommended to obtain better performance. Yes, one can place such dataypes in a regular tablespace as well. [...] 4301 28 27_BMC Change Manager question15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Thu, 2 Nov 2000 09:36:11 +1100571_- Colleagues,

As there's been a bit of discussion on 3rd party tools just lately, I thought this might be a timely question. Does anyone (un?)fortunate enough to have BMC's Change Manager know how to migrate a selection of tablespaces from one environment to another and specify a global change such that any partitioned tablespaces (and indexes) migrated become segmented? Most of the global change options seem to refer to specific attributes of the migrated objects, or generic name changes. Any clues? And, for extra points, could CA's RC/Migrator do it? [...] 4330 57 25_Re: db 2 stored procedure12_Rakesh Singh14_rasun@JUNO.COM30_Wed, 1 Nov 2000 17:55:04 -0500350_- hi david, Mails are little slow on my end. The call statement looks like this before the call we do a connect statement EXEC SQL CALL :WS-STORPROC (:ws-input-val, :ws-output-val) END-EXEC The sqlerrm shows the plan name of the program i am executing. As i mentioned before there is no plan for the stored procedure but it does have a package. [...] 4388 30 31_Re: BMC Change Manager question15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Thu, 2 Nov 2000 10:07:55 +1100497_- Sorry, I should have said. DB2 for OS/390 V5, BMC Change Manager 5.4.04D (according to the primary panel).



Raymond



> -----Original Message----- > From: Kongable, Richard [SMTP:Richard_Kongable@bmc.com] > Sent: Thursday, 2 November 2000 10:05 am > To: 'Raymond.W.Bell@TEAM.TELSTRA.COM' > Cc: 'DB2-L@RYCI.COM'; 'rkon@ev1.net' > Subject: RE: BMC Change Manager question > > Hi Raymond, > What version of Change Manager are you fortunate enough to enjoy? > > rkon [...] 4419 113 18_Re: Available tool11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Thu, 2 Nov 2000 10:19:46 +1100689_- Jeff,

have a look at "DB2 Data Replication", also called DB2 DataPropagator, previously DPropR; www.ibm.com/software/data/dpropr/.

Cheers, Ulrich

> -----Original Message----- > From: Jeff Kalman [SMTP:jkalman@CSC.COM] > Sent: Thursday, November 02, 2000 3:18 AM > To: DB2-L@RYCI.COM > Subject: Re: Available tool > > Hi everyone, > Is there a tool available to be able to keep DB2/UDB tables on the server > in sync with the DB2 tables on the mainframe? > > TIA. > > Jeff Kalman > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L webpage at http://www.ryci.com/db2-l. The [...] 4533 17 11_Remote bind15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Wed, 1 Nov 2000 18:34:37 -0500509_iso-8859-1 When I do a remote bind from one subsystem to another, if there is any cursor declared in Cobol program with hyphen ( -), I get a syntax error -104 and bind fails. Is there any reason why we cannot use hyphen when we do a remote bind?

thanks....Sibi

================================================ 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. 4551 147 25_FW: Copy utility DATALOSS12_HEPP SHERY C17_schepp@SRPNET.COM30_Wed, 1 Nov 2000 16:34:43 -0700434_ISO-8859-1 For those of you wondering about the earlier note concerning data corruption with the V6 copy utility- just got this from our systems programmer.

-----Original Message----- From: HOLGUIN BETH Sent: Wednesday, November 01, 2000 4:15 PM To: HEPP SHERY C Subject: Copy utility DATALOSS

Top of Form 1 Item PQ41076 Bottom of Form 1 Top of Form 2 <<...>> <<...>> <<...>> <<...>> APAR Identifier ...... PQ41076 [...] 4699 11 21_DSNTEJ6S using PLI V216_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU30_Wed, 1 Nov 2000 15:37:00 -0700384_- The DB2 V6 Install Guide says IVPs DSNTEJ6S/DSNTEJ6P must be installed with PLI for MVS. Has anyone successfully installed them with PLI V2?

================================================ 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. 4711 40 15_Re: Remote bind11_Suresh Sane21_data_arch@HOTMAIL.COM28_Wed, 1 Nov 2000 17:57:55 CST645_- Is it possible the remote system is V6? If so, hyphens are not allowed - need to change them to underscore.

Suresh

>From: "Philip, Sibimon" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Remote bind >Date: Wed, 1 Nov 2000 18:34:37 -0500 > >When I do a remote bind from one subsystem to another, if there is any >cursor declared in Cobol program with hyphen ( -), I get a syntax error >-104 >and bind fails. Is there any reason why we cannot use hyphen when we do a >remote bind? > >thanks....Sibi > >================================================ >To change [...] 4752 14 25_I/O SUSPENSION USERMOD V511_Jones, John29_John.Jones@ANHEUSER-BUSCH.COM30_Wed, 1 Nov 2000 17:08:22 -0600404_- Has anyone tried the Version 5 I/O suspension (split/mirror) usermod for use with RVA snapshots? And how can customers obtain the usermod and its documentation?

================================================ 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. 4767 72 50_Re: Using only pool threads for each cics region ?12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Thu, 2 Nov 2000 11:07:58 +1100514_- Hi dudes, (& Dudettes),

TOKENE ( TOKENI can also be used but "E" is better) is used when you have protected threads on CICS to signal that at the end of a transaction, you close the associated DB2 SMF records and start new ones. Otherwise several CICS transactions will get rolled into the one set of DB2 SMF records. Hence you don't need to loose the DB2 Info. A DB2PM report will also be able to show the extent of your thread reuse (in the SubSytems Services section of the PM Statistics report). [...] 4840 66 25_Re: db 2 stored procedure13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 1 Nov 2000 19:44:53 -0500632_iso-8859-1 Hi Rasun,

The following quote is from Redbook: Getting Started with DB2 Stored Procedures: Give Them a Call through the Network Go to www.redbooks.ibm.com and search for SG24-4693-01 The redbook is very helpful. ------------------ "A stored procedure does not require a plan. You need only bind a package for the stored procedure. If the client program executes in the DB2 on MVS environment, the client program requires a plan, with a database request module (DBRM) bound directly in the plan, or with a package for the program. Figure 68 shows the packages required to invoke a stored procedure. Figure 68. [...] 4907 22 17_New IBM DB2 tools17_Aldrin Jayatilaka19_aldrinj@AU1.IBM.COM30_Thu, 2 Nov 2000 12:08:04 +1100532_us-ascii Those interested,

Is there anyone using the new IBM DB2 tools? How do they compare to other ISV (like BMC, CA) equivalent products? What do you think of them?

regards,

Aldrin Jayatilaka Database Administrator IBM Global Services Australia Phone: 61 2 6124 6107

================================================ 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. 4930 17 50_DB2 OS/390 to Oracle on SUN migration question ...10_Rob Wright17_rwright@LIC.CO.NZ30_Thu, 2 Nov 2000 14:46:02 +1200506_us-ascii Has anyone on the list been involved in the migration of a DB2 subsystem to an Oracle environment? I am interested in any comments, gotchas etc. I would also appreciate any pointers to other lists where I might be able to find an answer.

Thanks Rob

================================================ 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. 4948 53 15_Re: Remote bind25_Robinson, Peter [IBM GSA]33_Peter.J.Robinson@TEAM.TELSTRA.COM30_Thu, 2 Nov 2000 12:54:25 +1100526_- Hi Philip

I recall having this problem way back when we were DB2 V3 so it is an oldie. I did some investigation at the time and found that the syntax checks on the remote bind were slighty different to the pre-compiler. You have found one of the differences that I found back then - there were others but I can't now remember what they were (very dim memories). You need to change all your hyphens to underscores and it will work ok. I'll see if I can dredge up from the dim recesses of my memory what the other [...] 5002 85 31_Re: BMC Change Manager question0_31_greg.palgrave@UNISYSWEST.COM.AU30_Thu, 2 Nov 2000 10:03:29 +0800487_us-ascii Raymond,

You should be able to set up a Migration Profile, and specify in the Change Rules to translate SEGSIZE 0 (which will pick up SIMPLE or PARTITIONED) to SEGSIZE nn. I haven't tried this myself, so you may run into issues with CM doing something dumb like both specify PART and SEGSIZE, and you may have problems with the index . I can't see any option to specifically override the PART clause for TS or IX. If it generates the worklist, check before running. [...] 5088 58 31_Re: BMC Change Manager question15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Thu, 2 Nov 2000 14:52:19 +1100371_- Greg,

Gave it a go. Didn't work. Specified the change rule as you suggested, but didn't make a bean of difference. It completely ignored it. I tried including and excluding migrating the dependent index also, in case that was buggering it up affecting it in some way, but it didn't make any difference; if the index was partitioned, that's how it came out. [...] 5147 23 55_UDB DB2: Sending error messages to NT Event Viewer log.16_Simpson, Freddie16_simpsof1@ANZ.COM30_Thu, 2 Nov 2000 14:53:50 +1100389_iso-8859-1 Hi We are developing a new system on UDB DB2 v6.1. Some of the housekeeping jobs have been automated using REXX. I am trying to work out how I can send error messages produced from the REXX pgms to the NT event viewer - any ideas ?. From the UDB doco (Administrative API reference) I have found 'db2AdminMsgWrite' - however I am not sure how (or if) I can use it in REXX . [...] 5171 22 23_Recover tocopy or torba9_J Sullens21_pleniumcorp@YAHOO.COM30_Wed, 1 Nov 2000 23:03:02 -0600564_- For a database with hundreds of tables, if all the tables are to be recovered to the latest incremental imagecopy(IIC) point, then it seems to me that if a quiesce is done along with the IC, it is much easier to recover torba of the quiesce point for all the tablespaces instead of tocopy of the latest IIC. The advantages are that I would just need to specify one RBA of the quiesce point for all tablespaces and not have to identify and pull out the imagecopy gdg names from the syscopy(potentially specifying an incorrect gdg name and thereby recovering [...] 5194 93 31_Re: BMC Change Manager question14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 2 Nov 2000 17:09:52 +1100492_iso-8859-1 another option, a bit less messy than editing the worklist, is to interrogate the catalog directly and build a set of CDL to emulate the migration.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Thursday, November 02, 2000 2:52 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] BMC Change Manager question [...] 5288 34 28_thanks - dsntijcc all ok now23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 2 Nov 2000 06:08:24 -0000666_iso-8859-1 Thanks for all the help last night with the DSNTIJCC etc ..

Kurt / Rick - thanks for your swift responses ..

all the best

Leslie Pendlebury-Bowe DB2 DBA OS390 SAP DB2 Certified









********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Sony cannot accept liability for statements made which are clearly the sender's own and not made on behalf of Sony. (01) ********************************************************************** [...] 5323 63 41_Re: Effect of Reoptvar on Dynamic queries16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Thu, 2 Nov 2000 12:14:01 +0530674_- Hi Jaydeep,

For dynamic sqls access path is decided at the execution time only but along with that if we are using REOPT VAR as Y and if the prepared SQLs contains some host variables then DB2 will also determine the accesspath during EXECUTE time.

When you specify the bind option REOPT(VARS),DB2 reoptimizes the access path at run time for SQL statements that contain host variables,parameter markers,or special registers.The option REOPT(VARS)has the following effects on dynamic SQL statements: 1) When you specify the option REOPT(VARS),DB2 automatically uses DEFER(PREPARE),which means that DB2 waits to prepare a statement until it encounters an [...] 5387 25 45_Trace R Jones/SS/HouInd is out of the office.11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM30_Thu, 2 Nov 2000 01:00:40 -0600581_us-ascii I will be out of the office from 11/01/2000 until 11/06/2000.

I will respond to your message when I return.

If you need DB2 assistance, please call:

Robert Lagoudis x77874 Terri Romero x75645

If you need Oracle Assistance, please call:

Joey Foushee x5632 Terri Romero x75645 Georgia Carson x5870

================================================ 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. 5413 16 49_Ronald Draper/HWP/DEQ/MODNR is out of the office.13_Ronald Draper28_nrdrapr@MAIL.DNR.STATE.MO.US30_Thu, 2 Nov 2000 01:01:07 -0600389_us-ascii I will be out of the office starting 11/01/2000 and will not return until 11/05/2000.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5430 14 54_Re: DB2 OS/390 to Oracle on SUN migration question ...14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Thu, 2 Nov 2000 09:28:40 +0100334_us-ascii I was not involved but I saw the people working on it. Good luck.

Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5445 34 28_Systems Administration Guide11_?????? ????24_dimokap@INTERAMERICAN.GR30_Thu, 2 Nov 2000 10:11:34 +0200629_- I am making some configuration changes on a DB2 UDB V6 for NT database and i am getting the following message: ---------------------------------------------------------------------------- SQL0291N State transition not allowed on table space. Explanation: An attempt was made to change the state of a table space. Either the new state is not compatible with the current state of the table space, or an attempt was made to turn off a particular state and the table space was not in that state. Details can be found in the system error log and/or the database manager error log. User Response: Table space states change when [...] 5480 52 22_LDAP and DB2 Urgent !!13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Thu, 2 Nov 2000 14:58:37 +0530640_us-ascii hi !! I am facing a problem in starting LDAP with DB2 ... it gives the following error

GLD0040I The value for the 'maxthreads' option is out of range (10, 75000). The GLD0129I The value for the 'maxConnections' option is out of range (1, 2047). Th GLD0130I The value for the 'waitingthreads' option is out of range (10, 75000). GLD2062E The LDAP program will operate in single-server mode. GLD2003I Error code -1 from odbc string: " SQLAllocConnect " . GLD2051I ODBC error, SQL data is: native return code=-99999, SQL state=58004, SSQL message={DB2 for OS/390}{ODBC Driver} SQLSTATE=5 8004 ERRLOC=2:170:9 CAF "CONNECT" [...] 5533 56 26_Re: db2set return code -1012_Travis, John27_John.Travis@CAPGEMINI.CO.UK30_Thu, 2 Nov 2000 09:22:48 -0000676_- Tim,

Try using db2set DB2SYSTEM=sp-f4n3e -g. UDB is finicky about ordering of arguments.



-----Original Message----- From: tim malamphy [mailto:timalamphy@YAHOO.COM] Sent: 31 October 2000 19:24 To: DB2-L@RYCI.COM Subject: db2set return code -10



Esteemed listmembers,

Our AIX box was rebuilt with the incorrect hostname, and DB2 6.1 EE fp5 was installed, and an instance created. I could not get Control Center to connect. I got a DBA0102N message with a -1 rc. Looking at the registry variables, I see that the DB2SYSTEM name is still set to the old, incorrect name. I dropped the instance, then I changed the AIX hostname to [...] 5590 12 57_Re: How can youtell if an index is approaching 100% full?15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Thu, 2 Nov 2000 05:20:45 -0600408_- What's about using the stospace-utility and then using the information of column SPACE in sysindexpart or I think another possibilty is columns NLEAF in SYSINDEXES.

================================================ 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. 5603 73 25_Re: -904 with RC 00C900960_29_paul.packham@POSTOFFICE.CO.UK30_Thu, 2 Nov 2000 11:40:37 +0000549_us-ascii Rick,

This is exactly what I was thinking. I now have a report which was produced from our historical SMF data. It shows what was happening on DB2 v5 & DB2 v6. The data indicates that the lock table statement was executed (qxlock count = 1) on all occasions, however on DB2 v5 it shows that lock escalation occurred (qxalex count = 1) and the program finished successfully, but on v6 this is not happening, and we end up with 00C90096 . I think that the reason escalation is not occurring on v6 is something to do with PQ24032. [...] 5677 21 32_Re: Systems Administration Guide13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Thu, 2 Nov 2000 07:06:38 -0500532_iso-8859-1 Hi Popy, you can find the admin manuals at http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v6pubs.d 2w/admin

I haven't encountered the error you're seeing.

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. 5699 57 15_Re: Remote bind11_David Nance16_DWNance@FHSC.COM30_Thu, 2 Nov 2000 07:19:50 -0500361_US-ASCII We had the same problem on V4 & V5. Always did a manual bind on remote system whenever those couple of programs were moved.

Dave Nance First Health Services, Corp. (804)527-6841

>>> data_arch@HOTMAIL.COM 11/01/00 06:57PM >>> Is it possible the remote system is V6? If so, hyphens are not allowed - need to change them to underscore. [...] 5757 32 25_Re: DSNTEJ6S using PLI V212_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM30_Thu, 2 Nov 2000 07:40:48 -0500341_us-ascii John,

As these jobs are for preparing PL/1 stored procedures, you must have a compiler that supports enclaves. While PL/1 V2 will compile the program successfully, it doesn't create an enclave-able program and the SPAS will not be able to load it. You will get a U3000 (or was it U3003?) abend when you try to run them. [...] 5790 16 28_ER diagram for system tables19_Margaritis Dimitris20_margardi@NOVABANK.GR30_Thu, 2 Nov 2000 14:50:31 +0200338_iso-8859-7 Hi all Where can I found an ER diagram for DB2 system tables?

Regards Dimitris

================================================ 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. 5807 160 31_Re: FW: Miscellaneous questions14_Philip Gunning18_pgunning@PHEAA.ORG30_Thu, 2 Nov 2000 08:05:49 -0500473_us-ascii 1. The activate database command in general causes bufferpools to be allocated, log files to be allocated, and dbheap and initial agent pool to be built. The main purpose for this is to provide fast logons for the first user connecting. If activate db is not used, the above is built at first connect, thus first users experience log connect times. A database activated with the activate database command must be stopped with the deactivate database command. [...] 5968 16 18_Re: Available tool11_Jeff Kalman15_jkalman@CSC.COM30_Thu, 2 Nov 2000 08:02:58 -0500308_us-ascii Ulrich, Thank you for your response.

Regards, Jeff

================================================ 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. 5985 112 20_Re: DB2 tools -Reply16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT30_Thu, 2 Nov 2000 14:58:07 +0100490_us-ascii I am one of the multitude who found themselves having to work with CA/Platinum products, after having ENJOYED the use of BMC's tools, both in my current life as a DB2 person and in my previous one as an IMS syseng.

I agree with all the people who complained about the terrible support you get from CA - was a victim of this myself in a bad case of lowcore overlay due to one of their tools, the fixtest for which was more faulty than the original code (if possible)... [...] 6098 57 27_Re: Recover tocopy or torba19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 2 Nov 2000 08:06:58 -0600584_ISO-8859-1 J, Close -- now consider the following: 1) Was there any activity against the DB during the IICs? 2) Was the DB set read-only during all IICs? 3) If activity was present during the IICs, where's the best point for QUIESCE?

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, [...] 6156 102 27_FW: Miscellaneous questions13_Doctor, Nadir24_Nadir.Doctor@BGEHOME.COM30_Thu, 2 Nov 2000 09:19:19 -0500452_iso-8859-1 Regarding (2): be careful since if a userid is connected to a database in exclusive mode, then another person could logon using the same userid too - what is prevented is other different userids getting connected to the db during this time.

-----Original Message----- From: KUHN,Ulrich [mailto:ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU] Sent: Monday, October 30, 2000 12:01 AM To: DB2-L@RYCI.COM Subject: Re: Miscellaneous questions [...] 6259 23 10_free tools6_teoman22_tkocer@HALKBANK.COM.TR30_Thu, 2 Nov 2000 16:10:27 +0200493_windows-1254 Dear Listers, are there any free(or trial) db2 tools from bmc or platinum? where can i download them? thanks for your helps



R.Teoman KOCER Halkbank BIM System Programmer Tel:90-312-2891116 Web: http://teokocer.homestead.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. 6283 110 89_Re: -181 how to determine what date is in error when multiple dat es a re being inserted.15_Neff, Stephen R16_NeffSR@STATE.GOV30_Thu, 2 Nov 2000 09:26:59 -0500543_- I looked at the description for -180 and -181. Why does db2 decide which error code to assign? Is there any way I can make it choose -180?

thanks

> -----Original Message----- > From: Ohling, Tim R - CNF [SMTP:Ohling.Tim@CNF.COM] > Sent: Wednesday, November 01, 2000 4:34 PM > To: DB2-L@RYCI.COM > Subject: Re: -181 how to determine what date is in error when > multiple dat es a re being inserted. > > It seems to be error specific. > > On a -181, I can't find the column reference that I remembered. > On a -180, it will [...] 6394 22 29_Re: I/O SUSPENSION USERMOD V513_John Arbogast19_arbo@CP-DEMO.CP.NET30_Thu, 2 Nov 2000 06:26:38 -0800617_- We were using it before we went to V6. I believe IBM sent it to us on a tape per our request. We are using the V6 command for our DR plan.

On Wed, 01 November 2000, "Jones, John" wrote:

> > Has anyone tried the Version 5 I/O suspension (split/mirror) usermod for use > with RVA snapshots? And how can customers obtain the usermod and its > documentation? > > ================================================ > 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. [...] 6417 36 26_DB2 packages in production6_DB2usa18_db2usa@HOTMAIL.COM30_Thu, 2 Nov 2000 08:28:46 -0600503_- Hi,

Question (DB2 for OS/390): Do you use DB2 packages in production?

I set up a DB2 packages poll on the website: http://db2usa.hypermart.net/eliendb2.htm

Feel free to vote and check the results. You can send your questions for the next DB2 polls to db2usa3@hotmail.com .

Best regards,

DB2usa.



PS: Previous DB2 polls results:

- DB2 for OS/390: Do you use Data Sharing in production ? (September 2000) Yes: 66 votes 39% No : 103 votes 61% [...] 6454 106 25_Re: -904 with RC 00C9009622_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM30_Thu, 2 Nov 2000 09:29:36 -0500399_iso-8859-1 If there's an index on the table, will a LOCK TABLE also lock the index? If so, then maybe the lock escalation is on the index.

If RI is defined on the table, then maybe the lock escalation is on the parent, grandparent, great-grandparent, child, grandchild, great-grandchild...



Mike Piontkowski TP&S Technical Maintenance Voice: 302.886.4612 Fax: 302.886.4749 [...] 6561 58 30_Re: DB2 packages in production16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 2 Nov 2000 09:31:13 -0500535_iso-8859-1 Except for vendor-supplied software we are 100% pacakges. Greatly eases program installation.

eric pearson ITO DB2 support Eric.Pearson@nscorp.com



-----Original Message----- From: DB2usa [mailto:db2usa@HOTMAIL.COM] Sent: Thursday, November 02, 2000 9:29 AM To: DB2-L@RYCI.COM Subject: DB2 packages in production



Hi,

Question (DB2 for OS/390): Do you use DB2 packages in production?

I set up a DB2 packages poll on the website: http://db2usa.hypermart.net/eliendb2.htm [...] 6620 107 25_Re: -904 with RC 00C9009623_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 2 Nov 2000 15:13:49 -0000684_iso-8859-1 Paul

is this in your SAP system?

Les

-----Original Message----- From: paul.packham@POSTOFFICE.CO.UK [mailto:paul.packham@POSTOFFICE.CO.UK] Sent: Thursday, November 02, 2000 11:41 AM To: DB2-L@RYCI.COM Subject: Re: -904 with RC 00C90096



Rick,

This is exactly what I was thinking. I now have a report which was produced from our historical SMF data. It shows what was happening on DB2 v5 & DB2 v6. The data indicates that the lock table statement was executed (qxlock count = 1) on all occasions, however on DB2 v5 it shows that lock escalation occurred (qxalex count = 1) and the program finished successfully, but on v6 this [...] 6728 37 14_Re: free tools13_Hopf, Charles15_SYSCWH@MBNA.COM30_Thu, 2 Nov 2000 10:18:42 -0500681_us-ascii Free??? from BMC or Platinum????

> -----Original Message----- > From: teoman [SMTP:tkocer@HALKBANK.COM.TR] > Sent: Thursday, November 02, 2000 8:10 AM > To: DB2-L@RYCI.COM > Subject: free tools > > Dear Listers, > are there any free(or trial) db2 tools from bmc or platinum? > where can i download them? > thanks for your helps > > > R.Teoman KOCER > Halkbank BIM > System Programmer > Tel:90-312-2891116 > Web: http://teokocer.homestead.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 [...] 6766 16 25_Re: -904 with RC 00C900960_29_paul.packham@POSTOFFICE.CO.UK30_Thu, 2 Nov 2000 15:27:19 +0000338_us-ascii Les,

No its not a SAP application, just bog-standard cobol.

Regards, Paul

================================================ 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. 6783 57 15_Re: Remote bind15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Thu, 2 Nov 2000 10:30:20 -0500414_- Both production and test use DB2 5.1. When I change the hyphen to underscore it works fine.

Thanks...sibi

-----Original Message----- From: Suresh Sane [mailto:data_arch@HOTMAIL.COM] Sent: Wednesday, November 01, 2000 05:58 PM To: DB2-L@RYCI.COM Subject: Re: Remote bind



Is it possible the remote system is V6? If so, hyphens are not allowed - need to change them to underscore. [...] 6841 115 60_Re: Large Tablespaces Management and Maintenance !!! HOW ???17_Pantazis Pantazis20_zakis@CYTANET.COM.CY30_Thu, 2 Nov 2000 05:30:40 +0200608_US-ASCII We will be implementing the Shark volumes on our Production environment very soon.

From what I have heard the sharks have their own compression of data so is their any need to compress data that will already be compressed?? Or have I misunderstood what I heard???

Your comments would be appreciated

Thanks.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Rohn.Solecki@MTS.MB.CA Sent: Tuesday, 31 October, 2000 5:46 ?? To: DB2-L@RYCI.COM Subject: Re: Large Tablespaces Management and Maintenance !!! HOW ??? [...] 6957 30 13_Grant access.11_Tom Marcano23_marcano_db2@HOTMAIL.COM28_Thu, 2 Nov 2000 15:36:29 GMT353_- Hello all,



I have a master table that has access select to everyone so I need to protect some columns of this table to be queried unless they have the proper security.

Can DB2 protect the access to certain columns using GRANT?, I know we can use view to do it but we need to change a lot programs to get the rigth security. [...] 6988 32 31_AIX Number of Users Limitation?14_Scott Saunders20_ssaunders@SIEBEL.COM30_Thu, 2 Nov 2000 07:41:45 -0800275_iso-8859-1 We have run into what appears to be a snag in AIX administration. We are trying to add 2,000 users all into the same group. Our userids are 5 bytes and have to be separated by a comma. When we add 800 users for the group AIX balks at adding additional users. [...] 7021 28 41_DB2 and WEB Application Security Question18_Gillard, Joseph L.23_gillard.joseph@MAYO.EDU30_Thu, 2 Nov 2000 09:31:17 -0600347_- We have an OS/390 (v2.8) CICS (TS v 1.3) transaction that has now been converted to our Intranet WEB.

As a CICS transaction the user went thru RACF transaction security checking and CICS then connected to DB2 (UDB for OS/390 V5.1).

Now as a WEB application the user connects directly to DB2, and needs RACF connect authority. [...] 7050 55 14_Re: free tools6_teoman22_tkocer@HALKBANK.COM.TR30_Thu, 2 Nov 2000 17:31:51 +0200660_us-ascii yes it is surprising :))))) i just wanted to try my chance i think no chance

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Hopf, Charles Sent: 02 Kasym 2000 Per?embe 17:19 To: DB2-L@RYCI.COM Subject: Re: free tools



Free??? from BMC or Platinum????

> -----Original Message----- > From: teoman [SMTP:tkocer@HALKBANK.COM.TR] > Sent: Thursday, November 02, 2000 8:10 AM > To: DB2-L@RYCI.COM > Subject: free tools > > Dear Listers, > are there any free(or trial) db2 tools from bmc or platinum? > where can i download them? > thanks for your helps > > > R.Teoman KOCER [...] 7106 30 11_RC 00C9009612_Carol Sutfin19_csutfin@AMSOUTH.COM30_Thu, 2 Nov 2000 09:38:07 -0600354_- Since we seem to be on this subject recently:

I would like to get a general idea of the NUMLKUS everyone uses. (along with DB2 Version)

We have a batch run that continually experiences this problem. The programmer sets the UOW count for commit to a lower number and restarts the job. It would be nice to not have the problem at all. [...] 7137 37 32_Re: ER diagram for system tables0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Nov 2000 09:45:15 -0600466_us-ascii Platinum, now part of CA has versions of system catalog online. The old Platinum address was http://www.platinum.com/products/dbms/posters.htm . I am pretty sure it is redirected to the CA site now.









Margaritis Dimitris @RYCI.COM> on 2000/11/02 06:50:31 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 7175 25 35_Re: Mirror'd DASD Recovery Scenario12_Pierre LeBel19_plebel_ca@YAHOO.COM30_Thu, 2 Nov 2000 09:33:34 -0600546_- One year ago we implemented pretty much the same scenario that you want to do. At that time we were DB2 V4 but are now DB2 V5.

We did not mirror all the DASD volumes for the applications tables. When DB2 start on the remote site and has inflight work for the non mirror volumes, it will issue operator messages asking to specify the DASD device name or to reply cancel. When you reply cancel for all the messages. DB2 will start normally and leave the non recovered objects in a defer state (non accessible). All the objects on the [...] 7201 71 17_Re: Grant access.0_22_BILL_GALLAGHER@PHL.COM30_Thu, 2 Nov 2000 10:45:43 -0500423_us-ascii Tom,

The only thing you can specifically grant at a column level is UPDATE authority. I believe in order to do what you are trying to do, views are your ONLY option.

Bill Gallagher, DBA Phoenix Home Life Enfield, CT 06083







Tom Marcano cc: Sent by: DB2 Subject: Grant access. Data Base Discussion List [...] 7273 148 25_Re: -904 with RC 00C900960_29_paul.packham@POSTOFFICE.CO.UK30_Thu, 2 Nov 2000 15:46:38 +0000461_us-ascii Mike,

Thanks for your suggestion, however we have type 2 indexes so latches are taken on the index pages rather than locks. Also I checked and there is no RI defined on this database.

Regards, Paul Packham The Post Office











Please respond to DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: (bcc: Paul Packham/e/POSTOFFICE) Hard Copy To: Hard Copy cc: [...] 7422 63 17_Re: Grant access.15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 2 Nov 2000 09:47:10 -0600557_iso-8859-1 Using a view is the only that I know of to protect access to certain columns on a table. I have never heard of granting access to certain columns. If you don't have the qualifier for the table hardcoded anywhere you could create a view with a different qualifier but the same table name. Then use that different qualifier when binding the package or plan. However, if you are accessing other tables in the same package or plan that have different qualifiers then you will need alias's or synonyms on those tables so that the bind will work. [...] 7486 142 89_Re: -181 how to determine what date is in error when multiple dat es a re being inserted.19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Thu, 2 Nov 2000 07:53:36 -0800630_iso-8859-1 From the examples I've seen of both errors:

-181 is correct format but invalid value (e.g. 2000-00-00-00.00.00.000000) -180 is invalid format (e.g. 2000-01-abcdefg)

Back to my original statement - we edit all dates before handing them to DB2 so we can identify as many errors as possible in one pass.

HTH Tim

> -----Original Message----- > From: Neff, Stephen R [SMTP:NeffSR@STATE.GOV] > Sent: Thursday, November 02, 2000 6:27 AM > To: DB2-L@RYCI.COM > Subject: Re: -181 how to determine what date is in error when > multiple dat es a re being inserted. > > I looked at the description [...] 7629 72 27_Re: Recover tocopy or torba9_J Sullens21_pleniumcorp@YAHOO.COM30_Thu, 2 Nov 2000 09:55:16 -0600608_- Rick,

You are correct the DB will need to be Read only for the whole period during the IIC and immediately following Quiesce. Then the quiesce rba will correspond to the IIC point. Thanks.



On Thu, 2 Nov 2000 08:06:58 -0600, DAVIS, RICK (SBCSI) wrote:

>J, > Close -- now consider the following: >1) Was there any activity against the DB during the IICs? >2) Was the DB set read-only during all IICs? >3) If activity was present during the IICs, where's the best point for >QUIESCE? > >HTH, >Rick Davis > >"This e-mail and any files transmitted with [...] 7702 76 14_Re: free tools11_Kwan, James18_James_Kwan@BMC.COM30_Thu, 2 Nov 2000 09:55:52 -0600329_iso-8859-1 Teoman,

One thing my father taught me is that nothing is free in this world. However I am sure BMC/CA sales person would love to provide you a trial version of their tools. You can visit the web site or contact your sales person. If you need any particular product information you can contact me directly. [...] 7779 47 17_Re: Grant access.9_Rob Crane22_racrane@CONCENTRIC.NET30_Thu, 2 Nov 2000 09:04:37 -0700618_us-ascii You can specify two grants at the column level.

SET CURRENT SQLID = 'SUPERUSER'; GRANT REFERENCES(column-name1, column-name2, etc) ON YOURTABLE TO USERIDA; COMMIT;

SET CURRENT SQLID = 'SUPERUSER'; GRANT UPDATE(column-name1, column-name2, etc.) ON YOURTABLE TO USERIDA; COMMIT;

-Rob

Tom Marcano wrote: > > Hello all, > > I have a master table that has access select to everyone so I need to > protect some columns of this table to be queried unless they have the proper > security. > > Can DB2 protect the access to certain columns using GRANT?, I know we can > use view to do [...] 7827 42 31_Re: BMC Change Manager question0_18_DB2DBAinTX@AOL.COM28_Thu, 2 Nov 2000 11:02:57 EST597_US-ASCII I have been fortunate enough to have BMC Change Manager. The support is outstanding. We have just installed the newest release, 6.2.01E which includes CM/Pilot without an additional charge. Just ran a test on our system to change it from partition to non-partitioned. The DML (CM/Pilot stuff) looks like this: DELETE TABLEPART WHERE PARTITION > 1 AND TSNAME = 'TSNAME' AND DBNAME = 'DB' ; DELETE INDEXPARTS WHERE PARTITION > 1 AND IXNAME = 'IXNAME' AND IXCREATOR = 'CREATOR' ; UPDATE TABLEPART SET PARTITION = 0, SEGSIZE WHERE PARTITION = 1 AND TSNAME = 'TSNAME' AND DBNAME = 'DB' ; [...] 7870 72 35_Re: AIX Number of Users Limitation?14_Karen Grantham25_kgrantham@CUSTOM-EDGE.COM30_Thu, 2 Nov 2000 09:53:46 -0600816_us-ascii When our group limitation is reached, we add a new group. It is unfortunate but the only work around we have found.













Scott Saunders on 11/02/2000 09:41:45 AM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Karen Grantham/CEI)





Subject: AIX Number of Users Limitation?

















We have run into what appears to be a snag in AIX administration. We are trying to add 2,000 users all into the same group. Our userids are 5 bytes and have to be separated by a comma. When we add 800 users for the group AIX balks at adding [...] 7943 28 54_Multi-platform monitoring and catalog management tools0_28_Roy_Bertossi@ABERCROMBIE.COM30_Thu, 2 Nov 2000 11:37:58 -0500405_us-ascii DB2 List,

I've been asked by my boss to get some info on monitoring and catalog management tools for our various DB2 platforms (OS/390, Sun Solaris, AS/400). What we're looking for is a monitor that will watch over all of the platforms and with one central console we can get to any machine. For the catalog management tool, we want one tool that works with all of the various DB2's. [...] 7972 49 32_Re: ER diagram for system tables19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Thu, 2 Nov 2000 11:12:10 EST453_us-ascii Here's the correct link: http://www.cai.com/products/posters/v6_poster.htm

Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: , on 11/02/2000 10:45 AM: Platinum, now part of CA has versions of system catalog online. The old Platinum address was http://www.platinum.com/products/dbms/posters.htm . I am pretty sure it is redirected to the CA site now. [...] 8022 147 60_Re: Large Tablespaces Management and Maintenance !!! HOW ???19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Thu, 2 Nov 2000 08:13:18 -0800454_iso-8859-1 Short answer: Disk hardware compression will save physical space (i.e. it compresses the pages). DB2 still sees the data as uncompressed and has to fetch the same number of pages it would if there were no compression.

DB2 compression gives you more rows per page (assuming good compression), and therefore few page I/O's. I.e. in general it improves disk I/O and bufferpool use. It will work with the hardware compression as well. [...] 8170 178 32_Re: ER diagram for system tables16_Herman, Philippe22_PHILIPPE.HERMAN@CA.COM30_Thu, 2 Nov 2000 16:17:45 -0000548_iso-8859-1 Hi All,

Here is the right url to get the posters for free



http://www.ca.com/products/posters.htm

Philippe HERMAN Technical Consultant COMPUTER ASSOCIATES BELGIUM Tel : +32 (2) 773 28 11 Direct : +32 (2) 773 28 43 Fax : +32 (2) 762 73 59 Mobile : +32 (496) 59 72 79 email : Philippe.Herman@cai.com



-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Thursday, November 02, 2000 4:45 PM To: DB2-L@RYCI.COM Subject: Re: ER diagram for system tables [...] 8349 95 14_Re: free tools14_McCombs, Terry20_tmccomb@SEDGWICK.GOV30_Thu, 2 Nov 2000 10:30:06 -0600467_iso-8859-1 If you are serious about buying tools, I imagine CA and BMC would let you trial their products for a period of time. Both (then) Platinum and BMC were among vendors that allowed us to try their products prior to purchase several years ago.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Kwan, James Sent: Thursday, November 02, 2000 9:56 AM To: DB2-L@RYCI.COM Subject: Re: free tools [...] 8445 89 17_Re: Grant access.14_McCombs, Terry20_tmccomb@SEDGWICK.GOV30_Thu, 2 Nov 2000 10:33:18 -0600282_- If you have at least V5.1, you could rename the base table and create the view (without the columns) having the current name of the base table. Maybe it would less of a job to change the programs/people that need to access the columns, as opposed to the ones that shouldn't. [...] 8535 17 27_Re: Recover tocopy or torba20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM28_Thu, 2 Nov 2000 11:42:48 EST521_US-ASCII Hi Sullens, It is NOT necessary to know or TYPE the DSNAMES of the IC datasets or to know or TYPE the RBA Numbers. This information can be displayed for you on a ISPF panel and you pick and chose by timestamp. See www.recoveryknowledge.bigstep.com and request free info.

================================================ 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. 8553 89 50_Re: Using only pool threads for each cics region ?13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Thu, 2 Nov 2000 10:44:48 -0600632_iso-8859-1 Just a couple comments on this issue -- most of the performance manuals will tell you that protected threads will give you better performance. However, by allowing transactions to default to the pool you are definitely decreasing your maintenance. Look a little closer and you will see that one of the more expensive things you can avoid with protected threads is sign-on (which is why you also see recommendations like using "AUTH=()" to avoid sign-on processing). The other side of this is that by using TOKENE/I for the accounting records, you are forcing signon for every transaction (I've seen [...] 8643 20 59_Re: UDB DB2: Sending error messages to NT Event Viewer log.13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Thu, 2 Nov 2000 08:56:05 -0800345_- > We are developing a new system on UDB DB2 v6.1. Some of the housekeeping > jobs have been automated using REXX.

Why not use NetRexx? http://www2.hursley.ibm.com/netrexx/

Your programs will be very portable and you'll be able to plug in any Java class you like, without retooling your legacy Rexx programmers too severely. [...] 8664 50 24_Platinum and BMC AppTune19_Lisa Westcott-Dryer32_lisa_westcott_dryer@FOREMOST.COM30_Thu, 2 Nov 2000 11:59:47 -0500135_iso-8859-1 Hi there. Can anyone tell me if there is a comparable Platinum tool for the BMC AppTune tool?

thank you, Lisa

8715 23 14_Re: free tools0_17_JTonchick@AOL.COM28_Thu, 2 Nov 2000 12:04:27 EST531_US-ASCII What about the Control Center for DB2 from IBM. It's free. It's part of a no cost feature of DB2 called the DB2 Management Tools package. It installs on OS/390 as a separate FMID, or comes on the DB2 Connect install CD. It originally shipped as part of V6 of OS/390, is included with V7, and can be retrofitted into V5. I learned about it and saw demos at the DB2 conference last month. It'll work for me since I support multiple unique subsystems on separate lpars. I have a call into IBM to see how I can order the [...] 8739 17 58_Re: Multi-platform monitoring and catalog management tools0_17_JTonchick@AOL.COM28_Thu, 2 Nov 2000 12:08:22 EST366_US-ASCII Have you looked at the DB2 Control Center included with DB2 UDB for all platforms?

Jim Tonchick Fiserv, Inc.

================================================ 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. 8757 91 25_Re: -904 with RC 00C900960_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Thu, 2 Nov 2000 11:08:47 -0600559_us-ascii Hi Paul, When we migrated to V6, we too experienced a problem with locking. What we found was that in V6 the new thread reuse was the culprit. Our scenario was that a plan would run that was bound with release (deallocate) which indicates to get rid of locks when the program terminates but if the thread is still active DB2 does not think its done so IS locks remain active at the TS and TB level. With thread reuse , the thread would get reused immediatelyby another thread,(and it can be a completely different plan/package) and the IS locks [...] 8849 50 14_Re: free tools8_Kurian B23_Bejoy_Kurian@MAY-CO.COM30_Thu, 2 Nov 2000 11:13:58 -0600665_us-ascii Do we need seperate DB2 Connect to to work on NT? Thanks Bejoy





From: JTonchick@AOL.COM@RYCI.COM> on 11/02/2000 11:04 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Fax to: Subject: Re: free tools



What about the Control Center for DB2 from IBM. It's free. It's part of a no cost feature of DB2 called the DB2 Management Tools package. It installs on OS/390 as a separate FMID, or comes on the DB2 Connect install CD. It originally shipped as part of V6 of OS/390, is included with V7, [...] 8900 147 50_Re: Using only pool threads for each cics region ?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 2 Nov 2000 11:18:18 -0600520_ISO-8859-1 Hi Mike, et.al., Back around DB2 V4 and CICS V4.1, I let all trans go to the pool unless they demonstrated an arrival rate of 45 secs or less over a period of at least 15 mins (this back in the days when thread timeout was fixed at two, 30 sec periods). I created as many protected threads for those trans as there were per 45 sec period. Never had a chance to study if there really was any performance improvement and I did use TOKENE=YES. The trans that floated up to meet the bar turned out to be the [...] 9048 66 28_Re: Platinum and BMC AppTune14_Philip Gunning18_pgunning@PHEAA.ORG30_Thu, 2 Nov 2000 12:20:07 -0500525_iso-8859-1 Platinum Detector. -- Phil



Phil Gunning DB2 DBA











Lisa Westcott-Dryer cc: Sent by: DB2 Data Base Subject: Platinum and BMC AppTune Discussion List



11/02/00 11:59 AM Please respond to DB2 Data Base Discussion List













Hi there. Can anyone tell me if there is a comparable Platinum tool for the BMC AppTune tool? [...] 9115 76 26_Re: LDAP and DB2 Urgent !!13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Thu, 2 Nov 2000 11:27:38 -0600375_US-ASCII Hello Vishy, I initially had a problem with the CLI ini and resolved it by editing the Dataset in hex and setting the left brackets to X'AD' and the right brackets to X'BD' . Just a thought. HTH Kurt



>>> Viswanathan.N@POWAIMAIL.LTITL.COM 11/02/00 03:28AM >>> hi !! I am facing a problem in starting LDAP with DB2 ... it gives the following error [...] 9192 41 35_Re: Mirror'd DASD Recovery Scenario12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM30_Thu, 2 Nov 2000 12:31:57 -0500553_us-ascii Thanks for your reply Pierre!

Just one question though. Was the DEFER'd state one that could be removed by doing a recover from a backup tape or one where that is not now possible?



Martin.

Pierre LeBel wrote:

> One year ago we implemented pretty much the same scenario that you want to > do. At that time we were DB2 V4 but are now DB2 V5. > > We did not mirror all the DASD volumes for the applications tables. When > DB2 start on the remote site and has inflight work for the non mirror > volumes, it [...] 9234 72 26_Re: LDAP and DB2 Urgent !!13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Thu, 2 Nov 2000 11:37:23 -0600627_US-ASCII Sorry, that's left brackets to X'BD' ] and the right brackets to X'AD' [ Kurt

>>> Viswanathan.N@POWAIMAIL.LTITL.COM 11/02/00 03:28AM >>> hi !! I am facing a problem in starting LDAP with DB2 ... it gives the following error

GLD0040I The value for the 'maxthreads' option is out of range (10, 75000). The GLD0129I The value for the 'maxConnections' option is out of range (1, 2047). Th GLD0130I The value for the 'waitingthreads' option is out of range (10, 75000). GLD2062E The LDAP program will operate in single-server mode. GLD2003I Error code -1 from odbc string: " SQLAllocConnect " . GLD2051I [...] 9307 40 24_Text Extender -104 error10_Mark Savin31_Mark.Savin@SCOOT-TECHNOLOGY.COM30_Thu, 2 Nov 2000 17:41:29 -0000643_iso-8859-1 Dear list,

We're having a problem with DB2 Text Extender running on DB2 v6.1 on AIX. We've defined a text column on a table thus: ----- db2tx "enable text column thesaurus non_descriptor handle h_non_descriptor ccsid 819 language FRENCH indextype linguistic updateindex update" -----

The table has 10000+ rows in it, and when we update the text extender index on the table we get the following error message piped to a log table: ----- DesFunction = DesControl / DesReturnCode = 104 / DesFunction = "function identifier = 00106" / DesReturnCode = 104 / ApiFunction = "function identifier = 00206" / ApiReturnCode [...] 9348 30 44_Installing DB2 7.1 EE ON SOLARIS 2.7 PROBLEM17_Rabindra Senapati21_rsenapati@HOTMAIL.COM28_Thu, 2 Nov 2000 17:52:40 GMT354_- IMEDIATE HELP REQUIRED:

The db2 instance configuration runs long time on db2installer program and too db2 administration configuration runs long time. We need to cancel the installation process(then says failure) and come out from that. Even manual process takes long time too. Other things works fine even it creates the users and groups. [...] 9379 21 22_Peoplesoft data models0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Nov 2000 11:55:11 -0600583_us-ascii FYI: Quite a while back some people asked about data models for Peoplesoft and SAP. In the summer 2000 issue of the CA DB2 and IMS Systems Newsletter, SYSjournal, there is a note that they have data models for Peoplesoft at http:/www.ca.com/products/platinum/appdev/erwin_ps.htm.

HTH Rohn

PS: I haven't looked at them.

================================================ 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. 9401 29 28_Re: Platinum and BMC AppTune9_Rob Crane22_racrane@CONCENTRIC.NET30_Thu, 2 Nov 2000 11:01:41 -0700530_us-ascii CA products you may be intersted in:

Database Analyzer Detector Subsystem Analyzer Insight with 24x7

-Rob

> Lisa Westcott-Dryer wrote: > > Hi there. Can anyone tell me if there is a comparable Platinum > tool for the BMC AppTune tool? > > thank you, > Lisa >

================================================ 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. 9431 38 24_New IBM DB2 tools -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Thu, 2 Nov 2000 12:57:22 -0500443_US-ASCII I didn't know they were available yet. The most I've heard is that they may be available soon as packages with V7, but no specifics about functionality or comparisons to other vendor tools.

Regards, John

>>> aldrinj@AU1.IBM.COM 11/01/00 08:08pm >>> Those interested,

Is there anyone using the new IBM DB2 tools? How do they compare to other ISV (like BMC, CA) equivalent products? What do you think of them? [...] 9470 46 48_Re: Installing DB2 7.1 EE ON SOLARIS 2.7 PROBLEM13_Fletcher, Jim21_jim.fletcher@BSIS.COM30_Thu, 2 Nov 2000 12:58:47 -0500440_iso-8859-1 Be sure to check and set the kernel configuration values for Solaris to the appropriate values documented in the Quick Beginnings Installation Guide. I've seen this problem before when the values were not large enough.

-----Original Message----- From: Rabindra Senapati [mailto:rsenapati@HOTMAIL.COM] Sent: Thursday, November 02, 2000 12:53 PM To: DB2-L@RYCI.COM Subject: Installing DB2 7.1 EE ON SOLARIS 2.7 PROBLEM [...] 9517 21 35_Java and WebSphere to DB2 on OS/39021_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US30_Thu, 2 Nov 2000 13:32:04 -0500418_iso-8859-1 Hi all,

We are in the planning stages of converting a CICS/DB2 application to be Web-enabled. The plan is to write the front-end in Java and access the data in DB2 v5, OS/390 v2.6 via WebSphere installed on an NT server. My question is do I need additional software installed on OS/390 to make this work, such as the Java fmid for OS/390? How will the WebSphere handle a JDBC connection to DB2? [...] 9539 60 39_Re: Java and WebSphere to DB2 on OS/39020_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 2 Nov 2000 13:49:49 -0500513_us-ascii More straight forward root is to install Web Sphere on OS-390/UNIX, and generate servlet using visual age for java or write your own. This needs following components

- Web Application Server (WAS) - HTTP server on OS-390/UNIX - CICS Transaction Gateway (CTG) - is needed if you try to access your existing CICS transaction from an applet, if you are writing servlets then there is need to install CTG but you need to know where the java connectors classes are, in order to set the classpath. [...] 9600 173 52_Re: Date range processing - an idea to pass your way0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Thu, 2 Nov 2000 12:37:06 -0600323_us-ascii Terry - You make good points and certainly, whenever a tuning technique is used, you need to check the validity of using that technique. We are currently at version 6 of DB2, so "in list" processing can use matching index processing. This is probably the most important prerequisite for using this technique. [...] 9774 49 39_Re: Java and WebSphere to DB2 on OS/39017_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT30_Thu, 2 Nov 2000 19:59:11 +0100310_us-ascii Hi Jim, in the next year we do exactly the same thing; first we started using MQ on both NT and OS/390, writing "application code" on OS/390 under CICS; the application code "own" the tables and do the SQL work with DB2. Rapidly we converted the Java class from MQ to ECI, at a very little cost. [...] 9824 62 15_Re: RC 00C9009616_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 2 Nov 2000 13:58:45 -0500591_iso-8859-1 We have our NUMLKUS set at 10,000 (V5, non data-sharing). I feel this is too high. We will definitely reduce it before we implement data sharing - perhaps to 5,000 or even lower.

A good option is to have NUMLKUS lower and have the monolithic update tasks be carefully scheduled and issue LOCK TABLE as required. The problem with a high NUMLKUS is that it applies to every task in the subsystem. One poorly tuned SQL statement or one task with subpar COMMIT logic could seriously impact your concurrency. Even worse is what interactive tasks from DB2 Connect etc could [...] 9887 101 14_Re: free tools14_McCombs, Terry20_tmccomb@SEDGWICK.GOV30_Thu, 2 Nov 2000 10:30:06 -0600467_iso-8859-1 If you are serious about buying tools, I imagine CA and BMC would let you trial their products for a period of time. Both (then) Platinum and BMC were among vendors that allowed us to try their products prior to purchase several years ago.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Kwan, James Sent: Thursday, November 02, 2000 9:56 AM To: DB2-L@RYCI.COM Subject: Re: free tools [...] 9989 23 27_Re: Recover tocopy or torba20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM28_Thu, 2 Nov 2000 11:42:48 EST527_US-ASCII Hi Sullens, It is NOT necessary to know or TYPE the DSNAMES of the IC datasets or to know or TYPE the RBA Numbers. This information can be displayed for you on a ISPF panel and you pick and chose by timestamp. See www.recoveryknowledge.bigstep.com and request free info.

================================================ 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. [...] 10013 38 31_AIX Number of Users Limitation?14_Scott Saunders20_ssaunders@SIEBEL.COM30_Thu, 2 Nov 2000 07:41:45 -0800275_iso-8859-1 We have run into what appears to be a snag in AIX administration. We are trying to add 2,000 users all into the same group. Our userids are 5 bytes and have to be separated by a comma. When we add 800 users for the group AIX balks at adding additional users. [...] 10052 63 35_Re: Mirror'd DASD Recovery Scenario12_Pierre LeBel19_plebel_ca@YAHOO.COM30_Thu, 2 Nov 2000 13:29:29 -0600424_- I'm not sure if I understand your question here. When you will do the start on the object that is defer'd, DB2 will remove the defer'd state and initiate the recovery process using the log file to recover from the inflight work that was cut off. So to answer your question: Yes the DEFER'd state can be removed by doing a recover from a backup tape but I don't really understand why you would want to do that. Pierre [...] 10116 43 32_Re: ER diagram for system tables0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Nov 2000 09:45:15 -0600466_us-ascii Platinum, now part of CA has versions of system catalog online. The old Platinum address was http://www.platinum.com/products/dbms/posters.htm . I am pretty sure it is redirected to the CA site now.









Margaritis Dimitris @RYCI.COM> on 2000/11/02 06:50:31 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 10160 92 15_Re: RC 00C9009611_rick creech18_ykcirc@HOTMAIL.COM28_Thu, 2 Nov 2000 19:37:14 GMT337_- Good point, Eric. In addition I have seen situations where it works well for a few tablespaces that need it, to set LOCKMAX to a higher number so that these few will not have lock escalation taking place. LOCK ESCALATION can be a bad thing if your environment demands greater concurrency for certain tablespaces. Just my opinion, [...] 10253 184 32_Re: ER diagram for system tables16_Herman, Philippe22_PHILIPPE.HERMAN@CA.COM30_Thu, 2 Nov 2000 16:17:45 -0000548_iso-8859-1 Hi All,

Here is the right url to get the posters for free



http://www.ca.com/products/posters.htm

Philippe HERMAN Technical Consultant COMPUTER ASSOCIATES BELGIUM Tel : +32 (2) 773 28 11 Direct : +32 (2) 773 28 43 Fax : +32 (2) 762 73 59 Mobile : +32 (496) 59 72 79 email : Philippe.Herman@cai.com



-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Thursday, November 02, 2000 4:45 PM To: DB2-L@RYCI.COM Subject: Re: ER diagram for system tables [...] 10438 22 25_Re: -904 with RC 00C900960_29_paul.packham@POSTOFFICE.CO.UK30_Thu, 2 Nov 2000 15:27:19 +0000653_us-ascii Les,

No its not a SAP application, just bog-standard cobol.

Regards, Paul

================================================ 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.



--9B095B5ADSN=_01C044DC88685DA000000C13nl?irelay.cmg.nl--

================================================ 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. 10461 16 11_rc=00C9021C0_27_Bud.Greenman@ONONDAGA.NY.US30_Thu, 2 Nov 2000 14:52:04 -0500319_- I received this rc from a reorg unload external. The messages & codes book says : "row was encountered that is not represented by a record OBD in the database descriptor (DBD). " I tried running the repair utility for 'DBD test Database' and it came back with 0 errors. Any ideas on how to correct this? TIA Bud [...] 10478 36 11_RC 00C9009612_Carol Sutfin19_csutfin@AMSOUTH.COM30_Thu, 2 Nov 2000 09:38:07 -0600354_- Since we seem to be on this subject recently:

I would like to get a general idea of the NUMLKUS everyone uses. (along with DB2 Version)

We have a batch run that continually experiences this problem. The programmer sets the UOW count for commit to a lower number and restarts the job. It would be nice to not have the problem at all. [...] 10515 148 89_Re: -181 how to determine what date is in error when multiple dat es a re being inserted.19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Thu, 2 Nov 2000 07:53:36 -0800630_iso-8859-1 From the examples I've seen of both errors:

-181 is correct format but invalid value (e.g. 2000-00-00-00.00.00.000000) -180 is invalid format (e.g. 2000-01-abcdefg)

Back to my original statement - we edit all dates before handing them to DB2 so we can identify as many errors as possible in one pass.

HTH Tim

> -----Original Message----- > From: Neff, Stephen R [SMTP:NeffSR@STATE.GOV] > Sent: Thursday, November 02, 2000 6:27 AM > To: DB2-L@RYCI.COM > Subject: Re: -181 how to determine what date is in error when > multiple dat es a re being inserted. > > I looked at the description [...] 10664 63 15_Re: Remote bind15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Thu, 2 Nov 2000 10:30:20 -0500414_- Both production and test use DB2 5.1. When I change the hyphen to underscore it works fine.

Thanks...sibi

-----Original Message----- From: Suresh Sane [mailto:data_arch@HOTMAIL.COM] Sent: Wednesday, November 01, 2000 05:58 PM To: DB2-L@RYCI.COM Subject: Re: Remote bind



Is it possible the remote system is V6? If so, hyphens are not allowed - need to change them to underscore. [...] 10728 53 17_Re: Grant access.9_Rob Crane22_racrane@CONCENTRIC.NET30_Thu, 2 Nov 2000 09:04:37 -0700618_us-ascii You can specify two grants at the column level.

SET CURRENT SQLID = 'SUPERUSER'; GRANT REFERENCES(column-name1, column-name2, etc) ON YOURTABLE TO USERIDA; COMMIT;

SET CURRENT SQLID = 'SUPERUSER'; GRANT UPDATE(column-name1, column-name2, etc.) ON YOURTABLE TO USERIDA; COMMIT;

-Rob

Tom Marcano wrote: > > Hello all, > > I have a master table that has access select to everyone so I need to > protect some columns of this table to be queried unless they have the proper > security. > > Can DB2 protect the access to certain columns using GRANT?, I know we can > use view to do [...] 10782 95 35_Re: Mirror'd DASD Recovery Scenario12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM30_Thu, 2 Nov 2000 14:55:34 -0500424_us-ascii What I'm hoping for is this:-

1) Have disaster.

2) Start up DB2 on disaster recovery site. Inflight transactions attempt to backout.

3) Transactions that use the mirrored DASD tables are sorted out by DB2 and/or Indoubt stuff resolved manually.

4) Transactions for the other stuff are put in DEFER'd state by the operator cancelling other device mount requests (as you said below). [...] 10878 55 25_Re: db 2 stored procedure12_Rakesh Singh14_rasun@JUNO.COM30_Thu, 2 Nov 2000 15:05:53 -0500340_- hey folks, Just got side tracked as usual. I think i finally figured out why it is not binding the server package with client plan. The owner parameter specified on the bind plan statement does not have bind privileges on the server(stored procedure) package but the funny thing the bind does not abend it is completed successfully. [...] 10934 55 32_Re: ER diagram for system tables19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Thu, 2 Nov 2000 11:12:10 EST453_us-ascii Here's the correct link: http://www.cai.com/products/posters/v6_poster.htm

Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: , on 11/02/2000 10:45 AM: Platinum, now part of CA has versions of system catalog online. The old Platinum address was http://www.platinum.com/products/dbms/posters.htm . I am pretty sure it is redirected to the CA site now. [...] 10990 95 17_Re: Grant access.14_McCombs, Terry20_tmccomb@SEDGWICK.GOV30_Thu, 2 Nov 2000 10:33:18 -0600282_- If you have at least V5.1, you could rename the base table and create the view (without the columns) having the current name of the base table. Maybe it would less of a job to change the programs/people that need to access the columns, as opposed to the ones that shouldn't. [...] 11086 69 17_Re: Grant access.15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 2 Nov 2000 09:47:10 -0600557_iso-8859-1 Using a view is the only that I know of to protect access to certain columns on a table. I have never heard of granting access to certain columns. If you don't have the qualifier for the table hardcoded anywhere you could create a view with a different qualifier but the same table name. Then use that different qualifier when binding the package or plan. However, if you are accessing other tables in the same package or plan that have different qualifiers then you will need alias's or synonyms on those tables so that the bind will work. [...] 11156 121 60_Re: Large Tablespaces Management and Maintenance !!! HOW ???17_Pantazis Pantazis20_zakis@CYTANET.COM.CY30_Thu, 2 Nov 2000 05:30:40 +0200608_US-ASCII We will be implementing the Shark volumes on our Production environment very soon.

From what I have heard the sharks have their own compression of data so is their any need to compress data that will already be compressed?? Or have I misunderstood what I heard???

Your comments would be appreciated

Thanks.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Rohn.Solecki@MTS.MB.CA Sent: Tuesday, 31 October, 2000 5:46 ?? To: DB2-L@RYCI.COM Subject: Re: Large Tablespaces Management and Maintenance !!! HOW ??? [...] 11278 78 27_Re: Recover tocopy or torba9_J Sullens21_pleniumcorp@YAHOO.COM30_Thu, 2 Nov 2000 09:55:16 -0600608_- Rick,

You are correct the DB will need to be Read only for the whole period during the IIC and immediately following Quiesce. Then the quiesce rba will correspond to the IIC point. Thanks.



On Thu, 2 Nov 2000 08:06:58 -0600, DAVIS, RICK (SBCSI) wrote:

>J, > Close -- now consider the following: >1) Was there any activity against the DB during the IICs? >2) Was the DB set read-only during all IICs? >3) If activity was present during the IICs, where's the best point for >QUIESCE? > >HTH, >Rick Davis > >"This e-mail and any files transmitted with [...] 11357 36 13_Grant access.11_Tom Marcano23_marcano_db2@HOTMAIL.COM28_Thu, 2 Nov 2000 15:36:29 GMT353_- Hello all,



I have a master table that has access select to everyone so I need to protect some columns of this table to be queried unless they have the proper security.

Can DB2 protect the access to certain columns using GRANT?, I know we can use view to do it but we need to change a lot programs to get the rigth security. [...] 11394 187 29_Re: FW: Copy utility DATALOSS10_Kathy Culp21_Kathy_Culp@BCBSTX.COM30_Thu, 2 Nov 2000 14:31:15 -0600403_us-ascii APAR PQ39078 also refers to problems with image copy utility. Has anyone experienced these kinds of image copy problems running V6? We are running V6 in test and QA and have not had any problems, yet.









HEPP SHERY C cc: Sent by: DB2 Subject: FW: Copy utility DATALOSS Data Base Discussion List [...] 11582 17 54_Is anyony using the Predictive Governor in Version 6.111_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Thu, 2 Nov 2000 14:41:18 -0600278_us-ascii Is anyone using the Predictive Governor. If so could you provide some examples? The ones in the Admin Guide are not too good. I have gotten it to work on SPUFI but, I can't get it to work with Lotus Approach.. I have called IBM and they were not much help!... : ( [...] 11600 77 17_Re: Grant access.0_22_BILL_GALLAGHER@PHL.COM30_Thu, 2 Nov 2000 10:45:43 -0500423_us-ascii Tom,

The only thing you can specifically grant at a column level is UPDATE authority. I believe in order to do what you are trying to do, views are your ONLY option.

Bill Gallagher, DBA Phoenix Home Life Enfield, CT 06083







Tom Marcano cc: Sent by: DB2 Subject: Grant access. Data Base Discussion List [...] 11678 43 14_Re: free tools13_Hopf, Charles15_SYSCWH@MBNA.COM30_Thu, 2 Nov 2000 10:18:42 -0500681_us-ascii Free??? from BMC or Platinum????

> -----Original Message----- > From: teoman [SMTP:tkocer@HALKBANK.COM.TR] > Sent: Thursday, November 02, 2000 8:10 AM > To: DB2-L@RYCI.COM > Subject: free tools > > Dear Listers, > are there any free(or trial) db2 tools from bmc or platinum? > where can i download them? > thanks for your helps > > > R.Teoman KOCER > Halkbank BIM > System Programmer > Tel:90-312-2891116 > Web: http://teokocer.homestead.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 [...] 11722 153 60_Re: Large Tablespaces Management and Maintenance !!! HOW ???19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Thu, 2 Nov 2000 08:13:18 -0800454_iso-8859-1 Short answer: Disk hardware compression will save physical space (i.e. it compresses the pages). DB2 still sees the data as uncompressed and has to fetch the same number of pages it would if there were no compression.

DB2 compression gives you more rows per page (assuming good compression), and therefore few page I/O's. I.e. in general it improves disk I/O and bufferpool use. It will work with the hardware compression as well. [...] 11876 48 31_Re: BMC Change Manager question0_18_DB2DBAinTX@AOL.COM28_Thu, 2 Nov 2000 11:02:57 EST597_US-ASCII I have been fortunate enough to have BMC Change Manager. The support is outstanding. We have just installed the newest release, 6.2.01E which includes CM/Pilot without an additional charge. Just ran a test on our system to change it from partition to non-partitioned. The DML (CM/Pilot stuff) looks like this: DELETE TABLEPART WHERE PARTITION > 1 AND TSNAME = 'TSNAME' AND DBNAME = 'DB' ; DELETE INDEXPARTS WHERE PARTITION > 1 AND IXNAME = 'IXNAME' AND IXCREATOR = 'CREATOR' ; UPDATE TABLEPART SET PARTITION = 0, SEGSIZE WHERE PARTITION = 1 AND TSNAME = 'TSNAME' AND DBNAME = 'DB' ; [...] 11925 154 25_Re: -904 with RC 00C900960_29_paul.packham@POSTOFFICE.CO.UK30_Thu, 2 Nov 2000 15:46:38 +0000461_us-ascii Mike,

Thanks for your suggestion, however we have type 2 indexes so latches are taken on the index pages rather than locks. Also I checked and there is no RI defined on this database.

Regards, Paul Packham The Post Office











Please respond to DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: (bcc: Paul Packham/e/POSTOFFICE) Hard Copy To: Hard Copy cc: [...] 12080 82 14_Re: free tools11_Kwan, James18_James_Kwan@BMC.COM30_Thu, 2 Nov 2000 09:55:52 -0600329_iso-8859-1 Teoman,

One thing my father taught me is that nothing is free in this world. However I am sure BMC/CA sales person would love to provide you a trial version of their tools. You can visit the web site or contact your sales person. If you need any particular product information you can contact me directly. [...] 12163 34 54_Multi-platform monitoring and catalog management tools0_28_Roy_Bertossi@ABERCROMBIE.COM30_Thu, 2 Nov 2000 11:37:58 -0500405_us-ascii DB2 List,

I've been asked by my boss to get some info on monitoring and catalog management tools for our various DB2 platforms (OS/390, Sun Solaris, AS/400). What we're looking for is a monitor that will watch over all of the platforms and with one central console we can get to any machine. For the catalog management tool, we want one tool that works with all of the various DB2's. [...] 12198 61 14_Re: free tools6_teoman22_tkocer@HALKBANK.COM.TR30_Thu, 2 Nov 2000 17:31:51 +0200660_us-ascii yes it is surprising :))))) i just wanted to try my chance i think no chance

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Hopf, Charles Sent: 02 Kasym 2000 Per?embe 17:19 To: DB2-L@RYCI.COM Subject: Re: free tools



Free??? from BMC or Platinum????

> -----Original Message----- > From: teoman [SMTP:tkocer@HALKBANK.COM.TR] > Sent: Thursday, November 02, 2000 8:10 AM > To: DB2-L@RYCI.COM > Subject: free tools > > Dear Listers, > are there any free(or trial) db2 tools from bmc or platinum? > where can i download them? > thanks for your helps > > > R.Teoman KOCER [...] 12260 113 25_Re: -904 with RC 00C9009623_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 2 Nov 2000 15:13:49 -0000684_iso-8859-1 Paul

is this in your SAP system?

Les

-----Original Message----- From: paul.packham@POSTOFFICE.CO.UK [mailto:paul.packham@POSTOFFICE.CO.UK] Sent: Thursday, November 02, 2000 11:41 AM To: DB2-L@RYCI.COM Subject: Re: -904 with RC 00C90096



Rick,

This is exactly what I was thinking. I now have a report which was produced from our historical SMF data. It shows what was happening on DB2 v5 & DB2 v6. The data indicates that the lock table statement was executed (qxlock count = 1) on all occasions, however on DB2 v5 it shows that lock escalation occurred (qxalex count = 1) and the program finished successfully, but on v6 this [...] 12374 31 35_Re: Mirror'd DASD Recovery Scenario12_Pierre LeBel19_plebel_ca@YAHOO.COM30_Thu, 2 Nov 2000 09:33:34 -0600546_- One year ago we implemented pretty much the same scenario that you want to do. At that time we were DB2 V4 but are now DB2 V5.

We did not mirror all the DASD volumes for the applications tables. When DB2 start on the remote site and has inflight work for the non mirror volumes, it will issue operator messages asking to specify the DASD device name or to reply cancel. When you reply cancel for all the messages. DB2 will start normally and leave the non recovered objects in a defer state (non accessible). All the objects on the [...] 12406 34 41_DB2 and WEB Application Security Question18_Gillard, Joseph L.23_gillard.joseph@MAYO.EDU30_Thu, 2 Nov 2000 09:31:17 -0600347_- We have an OS/390 (v2.8) CICS (TS v 1.3) transaction that has now been converted to our Intranet WEB.

As a CICS transaction the user went thru RACF transaction security checking and CICS then connected to DB2 (UDB for OS/390 V5.1).

Now as a WEB application the user connects directly to DB2, and needs RACF connect authority. [...] 12441 208 29_Re: FW: Copy utility DATALOSS13_Johnson, Bill18_bjo23@ALLSTATE.COM30_Thu, 2 Nov 2000 14:51:30 -0600307_iso-8859-1 We've experienced broken pages caused by full image copy being run a couple of times in the last 6 months and just implemented a fix from IBM last night that is supposed to correct the problem. Check out APAR PQ41076. We are V6 now for over 6 months. Bill Johnson DBA Allstate Insurance Co. [...] 12650 16 20_Abend S0D2 Reason 2219_Michael Robaczewski25_MROBACZEWSKI@CAREMARK.COM30_Thu, 2 Nov 2000 15:25:11 -0600446_- Did any users experience the abend S0D2 reason 22 of DSNMSTR under DB2 OS/390 version 6.1? If this problem was encountered, how widespread was the problem?

Thanks, Michael Robaczewski Caremark Rx

================================================ 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. 12667 56 26_FW: db2set return code -1013_Doctor, Nadir24_Nadir.Doctor@BGEHOME.COM30_Thu, 2 Nov 2000 17:04:00 -0500675_iso-8859-1 Does the db2diag.log file for the db2 instance contain any extra information after this error was obtained ?



-----Original Message----- From: tim malamphy [mailto:timalamphy@YAHOO.COM] Sent: Tuesday, October 31, 2000 2:24 PM To: DB2-L@RYCI.COM Subject: db2set return code -10



Esteemed listmembers,

Our AIX box was rebuilt with the incorrect hostname, and DB2 6.1 EE fp5 was installed, and an instance created. I could not get Control Center to connect. I got a DBA0102N message with a -1 rc. Looking at the registry variables, I see that the DB2SYSTEM name is still set to the old, incorrect name. I dropped the instance, [...] 12724 42 24_Re: Abend S0D2 Reason 2211_Robert Jans21_Jans.Robert@AMSTR.COM30_Thu, 2 Nov 2000 15:11:00 -0700662_- Don't know if it's widespread but we encountered it 2 nights ago and took us till noon yesterday to cleanup the problems. Luckily it was Acceptance.......................



Robert Jans Albertsons, Inc 155 North 400 West Mail Drop 4427 Salt Lake City, UT 84103 (801) 961-3212 jans.robert@albertsons.com

------------------( Forwarded letter 1 follows )--------------------- Date: Thu, 2 Nov 2000 15:25:11 -0600 To: DB2-L@RYCI.COM From: Michael.Robaczewski[MROBACZEWSKI]@CAREMARK.COM Sender: IMCEAX400-c=US+3Ba=+@gcs.alias Reply-To: DB2.Data.Base.Discussion.List[DB2-L]@RYCI.COM Subject: Abend S0D2 Reason 22 [...] 12767 37 30_Recover tocopy or torba -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Thu, 2 Nov 2000 17:19:48 -0500577_US-ASCII It's a standard at our shop for the very reason you mentioned. A quiesce step of all tables copied must follow the image step to simplify recovery.

>>> pleniumcorp@YAHOO.COM 11/02/00 12:03am >>> For a database with hundreds of tables, if all the tables are to be recovered to the latest incremental imagecopy(IIC) point, then it seems to me that if a quiesce is done along with the IC, it is much easier to recover torba of the quiesce point for all the tablespaces instead of tocopy of the latest IIC. The advantages are that I would just need to specify [...] 12805 46 28_Re: Platinum and BMC AppTune9_Don Alden25_Don.Alden@I-STRUCTURE.COM30_Thu, 2 Nov 2000 13:02:03 -0700472_iso-8859-1 Don't forget Plan Analyzer because one can "drill down" to the offending SQL statements (with EXPAINanations) from Detector panels.

Cheers, Don

-----Original Message----- From: Rob Crane [mailto:racrane@concentric.net] Sent: Thursday, November 02, 2000 11:02 AM To: DB2-L@RYCI.COM Subject: Re: Platinum and BMC AppTune



CA products you may be intersted in:

Database Analyzer Detector Subsystem Analyzer Insight with 24x7 [...] 12852 22 12_Column Names0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Nov 2000 16:30:45 -0600485_us-ascii DB2 V6, OS390

Are these names of columns in any of the DB2 system catalog tables: NTYPENAME NTYPESCHEMA

I currently don't have access to the V6 manuals (neither locally or from Web) at this time.



TIA. Rohn

================================================ 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. 12875 29 35_ER diagram for system tables -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Thu, 2 Nov 2000 17:28:58 -0500477_US-ASCII Check this out from the CA website:

http://www.ca.com/products/posters.htm

>>> margardi@NOVABANK.GR 11/02/00 07:50am >>> Hi all Where can I found an ER diagram for DB2 system tables?

Regards Dimitris

================================================ 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. [...] 12905 20 39_Re: Column update on key of part. index11_Bob Trombly19_Bob_Trombly@GAP.COM30_Thu, 2 Nov 2000 14:20:16 -0800280_us-ascii Our shop is running version 5.0 and we had a need to do just such a thing. I understand that there is a PTF which can be applied which will essentially enable such an update. The update is really a delete from the old partition and an insert into the new partition. [...] 12926 58 16_Re: Column Names14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 3 Nov 2000 09:39:18 +1100480_iso-8859-1 No, they are not.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au



-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Friday, November 03, 2000 9:31 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Column Names



DB2 V6, OS390

Are these names of columns in any of the DB2 system catalog tables: NTYPENAME NTYPESCHEMA [...] 12985 32 37_FW: Moving Tablespaces to another DB213_Doctor, Nadir24_Nadir.Doctor@BGEHOME.COM30_Thu, 2 Nov 2000 17:48:08 -0500421_iso-8859-1 The maximum no. of obids in a database is 32767 - If you've reached the limit quickly without there being so many objects therein, using the modify utility + a reorg would assist in reducing the size of the dbd.

-----Original Message----- From: Anand Thippeswamy [mailto:Thippesa@MEIJER.COM] Sent: Tuesday, October 31, 2000 3:38 PM To: DB2-L@RYCI.COM Subject: Re: Moving Tablespaces to another DB2 [...] 13018 44 16_Re: Column Names0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Nov 2000 16:50:38 -0600517_us-ascii Thanks all







James Campbell @RYCI.COM> on 2000/11/02 04:39:18 PM Subject: Re: Column Names

No, they are not.

/* standard disclaimer */ James Campbell James.Campbell@Hancorp.com.au

-----Original Message----- Sent: Friday, November 03, 2000 9:31 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Column Names



DB2 V6, OS390

Are these names of columns in any of the DB2 system catalog tables: NTYPENAME NTYPESCHEMA [...] 13063 60 15_Re: rc=00C9021C14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 3 Nov 2000 09:52:56 +1100324_iso-8859-1 Bud,

How did you get the data into the tablespace? It appears that you used DSN1COPY and did not XLATE _all_ tables in the source tablespace into tables that are valid in the destination tablespace. Use DSN1PRNT to print out the offending row and verify whether or not it should be in the tablespace. [...] 13124 72 16_Re: Column Names16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT30_Thu, 2 Nov 2000 23:53:22 +0100519_us-ascii Rohn,

TYPENAME and TYPESCHEMA (without the N) are in SYSIBM.SYSPARMS - obviously also in SYSCOLUMNS.

Aurora Emanuela Dell'Anno Systems Programmer Sistemi Informativi S.p.A. e-mail: aurora.dellanno@sistinf.it tel. +39 335 7429486

no trees were killed in the sending of this message. however - a large number of electrons were seriously inconvenienced.

*std disclaimer* - my opinions are my own and if they seem ridiculous it may be that my get-up-and-go just got up and went... [...] 13197 61 16_Re: Column Names38_Toine Michielse/Santa Teresa/Contr/IBM18_vndobtm@US.IBM.COM30_Thu, 2 Nov 2000 23:54:34 +0000474_us-ascii Rohn

I assume you mean TYPENAME and TYPESCHEMA (without the N). They are new columns in SYSIBM.SYSCOLUMNS and SYSIBM.SYSPARMS.

TYPESCHEMA CHAR(8) NOT NULL WITH DEFAULT 'SYSIBM ' if COLTYPE is 'DISTINCT ',the schema of the distinct type. Otherwise,the value is 'SYSIBM '.

TYPENAME VARCHAR(18) NOT NULL WITH DEFAULT If COLTYPE is 'DISTINCT ',the name of the distinct type. Otherwise,the value is the same as the value of the COLTYPE column. [...] 13259 66 37_Re: Moving Tablespaces to another DB213_Horton, Libby20_Libby_Horton@BMC.COM30_Thu, 2 Nov 2000 17:10:35 -0600349_iso-8859-1 I believe what Anand is referring to here is the limit on the number of OBIDs that DSN1COPY can translate. This is from the IBM DB2 Universal Database for OS/390 V6 Utility Guide and Ref.:

OBIDXLAT Specifies that OBID translation must be done before the DB2

data set is copied. This parameter requires additional input [...] 13326 60 16_Re: Column Names0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Nov 2000 17:11:59 -0600334_us-ascii The names came from an error message in a 3'rd party product, DBA-Xpert (from Compuware). We are just starting to use the DB2 V6 (OS 390) compatible version of the product (V5.6.2), but we are running it agains DB2 V5. So, it appears to not be handling the version difference very gracefully in this specific situation. [...] 13387 191 50_Re: Using only pool threads for each cics region ?12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Fri, 3 Nov 2000 10:25:24 +1100385_iso-8859-1 Hi, good to see a richness of opinions.

One thing I am interested in though is :- I thought that most of the cost was in the connect, and that there was some "caching" of signon information? Has any body experienced any significant overheads in the sign-on process, and if so does having the application plan granted to public help (reducing the Auth checking)? [...] 13579 230 27_Re: Miscellaneous questions11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Fri, 3 Nov 2000 12:06:13 +1100634_iso-8859-1 You are right, I probably should have made it clearer by saying "no other userIDs can connect...". However, I had assumed that the userid you are using to run those utilities is a very restricted one and not generally available - I'd feel slightly uncomfortable if "normal" users had access to a userid that can run reorgs or other utilities... Cheers, Ulrich > -----Original Message----- > From: Doctor, Nadir [SMTP:Nadir.Doctor@BGEHOME.COM] > Sent: Friday, November 03, 2000 1:19 AM > To: DB2-L@RYCI.COM > Subject: FW: Miscellaneous questions > Regarding (2): be careful since if a userid is connected to a database [...] 13810 41 44_NEODBUG quarterly meeting - November 9, 20009_jim.szabo22_jim.szabo@MCIWORLD.COM30_Thu, 2 Nov 2000 20:19:24 -0500366_iso-8859-1 The Northeast Ohio Database Users Group (NEODBUG) will hold its quarterly meeting on THURSDAY, NOVEMBER 9, 2000, from 9am - 4:30pm, at the Hilton Inn South in Independence, Ohio USA. This meeting's program will consist of the following presentations:

"DB2 Availability Around the Clock (Parts I and II)", by Randy Ebersole of IBM Corporation. [...] 13852 48 20_UDB install problems12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM30_Thu, 2 Nov 2000 21:25:21 -0500579_ISO-8859-1 I have been trying to get UDB 7.1 installed on my windoes 95 system and can't solve the DLL problems. There appears to be a set of DLL's that UDB thinks should be present and either aren't or aren't the corrrect ones:

WS2_32.DLL WS2HELP.DLL KERNEL32.DLL NTDLL.DLL The first three weren't present after the install. I tried downloading them from the web, and even copied some from another windows 95 machine and UDB still isn't happy with them. I could use some help in understanding what these DLL's are and if they are part of the basic 95 system or were [...] 13901 112 26_Re: LDAP and DB2 Urgent !!13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Fri, 3 Nov 2000 08:36:09 +0530320_us-ascii hi I solved the problem .. actually we had a defualt subsytem identifier thru DSNHDECP in the wrong place and it was containing wrong information in the linklist and the correct one was lower down in the linklist .. I just put a step lib to access the correct DSNHDECP module and it worked. ! Thanks Vishy [...] 14014 91 37_Re: Moving Tablespaces to another DB217_Anand Thippeswamy19_thippesa@MEIJER.COM30_Thu, 2 Nov 2000 23:13:41 -0500403_US-ASCII Thanks Libby for clarifying. Got rid of this problem by moving some tables to another tablespace.

Regards Anand Meijer Inc.





>> Libby_Horton@BMC.COM 11/02/00 18:08 PM >>> I believe what Anand is referring to here is the limit on the number of OBIDs that DSN1COPY can translate. This is from the IBM DB2 Universal Database for OS/390 V6 Utility Guide and Ref.: [...] 14106 95 23_Download using DSNTIAUL24_Mahadevan Krishnamoorthy34_mahadevan.krishnamoorthy@WIPRO.COM30_Fri, 3 Nov 2000 11:12:01 +0530314_iso-8859-1 Hi List,

I have a table which have a date column. The table is having only one index and around 100 million rows.The date column in the table is the second key(desc) for the index. Now if I download the data from the table using DSNTIAUL with the date column as a criteria with a range like [...] 14202 114 27_Re: Download using DSNTIAUL0_31_greg.palgrave@UNISYSWEST.COM.AU30_Fri, 3 Nov 2000 14:14:53 +0800336_iso-8859-1 Assuming the explain shows it is actually going to use the index, both queries will have to scan the entire index to build the list of RIDs that qualify. This should take about the same time for each query (but if you're lucky, the second query will find most of the index data in the buffer pool, so cut down the I/O). [...] 14317 76 27_Re: Download using DSNTIAUL16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Fri, 3 Nov 2000 11:44:54 +0530502_- Hi Maha, I would rather say 'IT Depends". We can never say unless until we are very sure about how actually the data is organized.There might be the case that data for one month span is not as organized as data for one year span.Suppose data for one year takes about 100 pages to get accomodated and of those 100 pages only 1st ,6th , 9th ,99th and the 100th page contain data for the month so DB2 may have to go for doing the 5+ synchronous I/Os and for one year DB2 will go for 1 synch. and 2 [...] 14394 28 19_Guidlines on COMMIT21_Li, Chak Lung Dominic19_seddba@HK.SUPER.NET30_Fri, 3 Nov 2000 15:42:17 +0800333_us-ascii Dear all,

I am one of DB2 DBA members, our team would like to have your assistance to provide COMMIT guidelines on batch jobs and online transactions. The purpose is to free locks and improve concurrency.

Please let me have the following input (both batch jobs and online transactions) for our reference: [...] 14423 53 28_AW: Platinum and BMC AppTune12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 3 Nov 2000 08:43:16 +0100627_iso-8859-1 Lisa,

try DETECTOR and if this is not enough you may examine the Plan Analyzer. But be warned: The now CA-owned tools are very, very expensive.............

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 Compentence Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language): http://www.dzbw.de [...] 14477 34 20_Re: DB2 tools -Reply14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Fri, 3 Nov 2000 09:07:36 +0100404_us-ascii I used BMC and Platinum tools, and just now we are migrating from BMC to Platinum tools.

I agree that BMC technical support is better than Platinum, BUT from a point of view of some managers this is not significant, Platinum's tools and utilities are cheaper and BMC's are verrrrry expensive and their requests when you upgrade a machine or you sign a new contract are unacceptable. [...] 14512 97 20_AW: DB2 tools -Reply12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 3 Nov 2000 09:23:15 +0100393_iso-8859-1 Hi Max.

is it really true, that Platinum's (CA's) tools and utilities are cheaper than BMC ???

Our situation: We're just in a fight with CA because they are coming out with horrible licence fees for two Platinum products. CA wants a more than three times higher license fee than we paid before... and then they are a lot more more expensive than BMC............. [...] 14610 19 24_Re: AW: DB2 tools -Reply14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Fri, 3 Nov 2000 09:59:42 +0100455_us-ascii Really ? You're the first person saying that BMC is cheaper than Platinum. Really.

Of course you need to consider the cost of tuning and repairing of news CA/Platinum tools......

Regards MAx

================================================ 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. 14630 38 26_Re: Peoplesoft data models10_Alan Johns26_AlanJ@PRINCETONSOFTECH.COM30_Fri, 3 Nov 2000 04:09:43 -0500579_ISO-8859-1 Hi Rohn. Are you sure the link is correct, as I keep getting page not available?

Alan

-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: 02 November 2000 17:55 To: DB2-L@RYCI.COM Subject: Peoplesoft data models



FYI: Quite a while back some people asked about data models for Peoplesoft and SAP. In the summer 2000 issue of the CA DB2 and IMS Systems Newsletter, SYSjournal, there is a note that they have data models for Peoplesoft at http:/www.ca.com/products/platinum/appdev/erwin_ps.htm. [...] 14669 90 23_Re: Guidlines on COMMIT16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Fri, 3 Nov 2000 04:16:49 -0500632_- Hi A Cheng, Decision of guidelines of COMMIT frequency has got certain factors to look at but every installation have their own set of guidelines depending on the kind of applications, its priority and effect on application and DB2 subsystem performance as a whole.Bind parameters like ACQUIRE and RELEASE with ISOLATION levels. Time taken to ROLLBACK ,affect on the subsequent failures due to timeout or deadlock on other applications due to the high number of records uncommited and locked in one application. Generally, for online applications we are not updating high number of records so there are tendency of commiting [...] 14760 201 50_AW: Using only pool threads for each cics region ?0_20_Gerhard.Heiss@RUV.DE30_Fri, 3 Nov 2000 10:48:01 +0100474_iso-8859-1 Hi Mike,

less maintenace is clearly desirable, but what about the overhead involved in creating and terminating the thread for each transaction? CPU-upgrade is not inexpensive when you consider license-costs for all the nice stuff from BMC etc... Since we dont use protected threads (THRDS=0 always) I would like to get a rough estimate how big this overhead is compared to average 20 millisecond CPU which we have on one of our LPARS(nine X97 CPUs)? [...] 14962 28 28_Fast Unload, which product ?14_Per Callerstal22_per.callerstal@MIPS.SE30_Fri, 3 Nov 2000 05:17:44 -0600429_- Hi,

The DSNTIAUL program we use in production just doesn't cut it anymore. Too much data to unload and too small a window.

Has anyone done any comparison of BMC Unload+ and IBM High performance Unload ?

Interested in: -functionality provided -price ease of use

We need to unload specific columns only, use where clauses, use joins, and preferrably get the result in DSNTIAUL compatible format. [...] 14991 39 32_Re: Fast Unload, which product ?21_Ralf Lopes de Almeida19_ralf@DATAMEC.COM.BR30_Fri, 3 Nov 2000 09:54:40 -0200589_us-ascii What is your DB2 version ?



Per Callerstal wrote:

> Hi, > > The DSNTIAUL program we use in production just doesn't cut it anymore. Too > much data to unload and too small a window. > > Has anyone done any comparison of BMC Unload+ and IBM High performance > Unload ? > > Interested in: > -functionality provided > -price > ease of use > > We need to unload specific columns only, use where clauses, use joins, and > preferrably get the result in DSNTIAUL compatible format. > > Best Regards, > > -Per > > ================================================ [...] 15031 20 46_DB2 UDB for Aix - ER diagram for system tables25_Carlos Eduardo de Miranda25_carlos_e@CCUEC.UNICAMP.BR30_Fri, 3 Nov 2000 10:26:55 -0200422_us-ascii Is there any, for download, ER diagram for system tables of DB2 UDB for Unix/Windows operating system?

Thanks for response,

Carlos DB2 Database Administrator

================================================ 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. 15052 32 50_Re: DB2 UDB for Aix - ER diagram for system tables21_Ralf Lopes de Almeida19_ralf@DATAMEC.COM.BR30_Fri, 3 Nov 2000 10:55:35 -0200696_us-ascii Carlos, existe o produto ERWIN da Platinum (Atualmente CA), que faz engenharia reversa das tabelas do sistema do DB2UDB e gera o diagrama ER.

Carlos, do you know ERWIN ? This software do reverse engeneer and generate ER diagram.

Ralf DB2 Database Administrator



Carlos Eduardo de Miranda wrote:

> Is there any, for download, ER diagram for system tables of DB2 UDB for > Unix/Windows operating system? > > Thanks for response, > > Carlos > DB2 Database Administrator > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The [...] 15085 10 15_Re: rc=00C9021C0_27_Bud.Greenman@ONONDAGA.NY.US30_Fri, 3 Nov 2000 07:55:36 -0500313_- Actually the data was entered by the enduser with a Powerbuilder app.

================================================ 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. 15096 20 14_Re: free tools14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Fri, 3 Nov 2000 14:16:46 +0100486_us-ascii I'm afraid if you want a free tools you have to build them by your own......with REXX/ISPF panels.

And they probably will work better that 3rd party toolz, for your needs. :-)





Regards and cheers Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 15117 68 23_Re: Guidlines on COMMIT16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Fri, 3 Nov 2000 08:15:04 -0500585_iso-8859-1 One answer involves the DSNZPARM parameter IRLMRWT. If the update job holds locks longer than the time specified in IRLMRWT, it can cause other tasks to time out. Another answer involves DSNZPARM values for NUMLKUS and NUMLKTS which you certainly do not want to exceed. Yet another answer involves the 'discomfort level' of online users. How long can an online query wait for access to a page of data before the online user gets angry? We are a shop which has an extremely high update and insert rate. Our general practice (at least where we can get the programmers to [...] 15186 53 24_Re: Guidelines on COMMIT14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM30_Fri, 3 Nov 2000 07:29:33 -0600459_iso-8859-1 I look at every application separately. What I built is a standard for application developers use. With the use of a table that has (jobname, plan, commit frequency) the application then includes a small amount of logic to use this. The frequency is re-read before each commit just incase the frequency changes. I can the tune the commit frequency depending on the system load and no programming changes are needed. This seems to work for me. [...] 15240 222 50_Re: Using only pool threads for each cics region ?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 3 Nov 2000 07:36:25 -0600603_ISO-8859-1 Hi Nick, For CICS trans its common to grant all plans and packages to public and let CICS/RACF worry about security. If memory serves, I believe this gets around signon issues.

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 [...] 15463 96 24_Re: Guidelines on COMMIT16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT30_Fri, 3 Nov 2000 14:53:19 +0100373_us-ascii as already mentioned by our knowledgeable colleagues, it really does DEPEND....

the rule of thumb I have found acceptable (subject to review) in my recent shops was:

- for online processing approx . 1 commit every 70 seconds / 1000 updates - for batch processing we found that an acceptable restart was one commit every 25,000 - 30,000 updates. [...] 15560 76 23_Re: Guidlines on COMMIT15_Patrick Shipley24_jpshiple@DUKE-ENERGY.COM30_Fri, 3 Nov 2000 09:09:47 -0500566_us-ascii With some additions I agree with the notion of using a table driven approach to do commit logic is a good choice. This allows for changing the commit frequency. I would suggest basing the table on job and plan as mentioned before but also including some notion of time so the jobs commit frequency can be different during primetime and when running on a weekend, for example, you might commit less often. Also I would suggest using a combination of time and number of units of work to control when a job or transaction commits and if either the number [...] 15637 128 35_Re: Mirror'd DASD Recovery Scenario12_Pierre LeBel19_plebel_ca@YAHOO.COM30_Fri, 3 Nov 2000 08:17:04 -0600684_- Hi Again Martin. Yes I'm pretty sure you can do step (6). DB2 is expecting a recover on those object so a recover to backup should do the job.

Pierre



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

On Thu, 2 Nov 2000 14:55:34 -0500, MARTIN WOLFF wrote:

>What I'm hoping for is this:- > >1) Have disaster. > >2) Start up DB2 on disaster recovery site. Inflight transactions attempt to backout. > >3) Transactions that use the mirrored DASD tables are sorted out by DB2 and/or > Indoubt stuff resolved manually. > >4) Transactions for the other stuff are put in DEFER'd state by the [...] 15766 12 24_Re: Abend S0D2 Reason 2218_Sandra Lakenburger34_sandra.lakenburger@MAIL.SPRINT.COM30_Fri, 3 Nov 2000 08:37:09 -0600413_- Can you share a little more information on the S0D2 abends that you got? Was there a particular feature of V6 that you were using that you could tie them back to? Thanks

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 15779 20 53_DB2 stored procedure from SQLserver stored procedure.15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Fri, 3 Nov 2000 10:39:42 -0500304_iso-8859-1 Please let me know if anybody know how to call a DB2 (V5.1) stored procedure in OS/390 V2.6 from a SQLserver stored procedure using DB2 connect. Also SQLserver stored procedure needs to be able to receive a result set and error message (If anything goes wrong) from DB2 stored procedure. [...] 15800 233 50_Re: Using only pool threads for each cics region ?13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Fri, 3 Nov 2000 09:35:16 -0600542_iso-8859-1 That was kind of my point -- when I really got down to looking at it, the overhead involved in creating/terminating a thread for each transaction was not nearly as significant as I had expected it to be. In fact, I did not notice any difference (either in transaction response time, or in CPU time used by the regions). I'm sure someone could list off everything that happens when you need to create a thread (and it may be a long list), but I just haven't seen it add up to increased response time or cpu time (so I wouldn't [...] 16034 44 26_Re: Peoplesoft data models0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 3 Nov 2000 09:43:59 -0600397_us-ascii try http://www.ca.com/products/platinum/appdev/erwin_ps.htm

Sorry, first post only had 1 '/' in front of the 'www', other than that error that is the address in the newsletter.

If that doesn't work, try going to www.ca.com then working your way down to the erwin page. Or email the newsletter at sysjournal@ca.com (I don't see a web address for the newsletter itself). [...] 16079 46 16_Request for Help10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM30_Fri, 3 Nov 2000 10:55:48 -0500588_iso-8859-1 Wendy's purchased the "Admin Portfolio" from Platinum a few years back. This included all of the "RC" products (RC Query, RC Migrator, etc.). We received and used the product passwords from Platinum without problem.

Now CA is in the picture.

They gave us new product passwords after a recent CPU upgrade, but did not include a permanent password for RC Compare. CA is saying that RC Compare is not part of the Admin Portfolio, and they want $90,000 before they will give us the permanent password! They are asking us to "prove" that we purchased RC Compare. [...] 16126 60 20_Re: Request for Help9_Rob Crane22_racrane@CONCENTRIC.NET30_Fri, 3 Nov 2000 09:15:39 -0700565_us-ascii Here are a couple things that should help you prove your point. Sorry you are having troubles, hope this helps.

If you still have the old password member tied to the original agreement it would have the password for RC/Compare. During the install there is a panel that asks you to enter in the passwords (basically a long number that does not have much meaning). However if you ran the IVP jobs it would kick out information on each password entered and for what product it represents. The IVP job can be found off the General Facilities menu. [...] 16187 25 24_Re: Abend S0D2 Reason 2211_Robert Jans21_Jans.Robert@AMSTR.COM30_Fri, 3 Nov 2000 08:52:00 -0700597_- The S0D2 we received was during a backout/recover of inflight transaction on a restart after the IRLM was cancelled. ------------------( Forwarded letter 1 follows )--------------------- Date: Fri, 3 Nov 2000 08:37:09 -0600 To: DB2-L@RYCI.COM From: sandra.lakenburger@MAIL.SPRINT.COM Sender: IMCEAX400-c=US+3Ba=+@gcs.alias Reply-To: DB2.Data.Base.Discussion.List[DB2-L]@RYCI.COM Subject: Re: Abend S0D2 Reason 22

Can you share a little more information on the S0D2 abends that you got? Was there a particular feature of V6 that you were using that you could tie them back to? Thanks [...] 16213 19 23_[Fwd: Request for Help]9_Rob Crane22_racrane@CONCENTRIC.NET30_Fri, 3 Nov 2000 09:21:03 -0700356_us-ascii Also, if you do have a temporary password, the product is still fully functional. A lot of big shops that have 50+ CPU's and are constantly upgrading CPU's etc., got in the habbit of getting temporary passwords that ended on the last day of their contract (like 02-28-2004, etc). One advantage to this is CPU ID's did not have to be entered. [...] 16233 65 20_Re: Request for Help15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Fri, 3 Nov 2000 10:21:35 -0600396_iso-8859-1 We have the RC products here and I do remember that though RC/Compare is considered part of RC/Migrator we had to purchase it separately. Good luck! I have had my share of woes in dealing with Platinum. It has gotten worse since CA has assimilated the company.

Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin [...] 16299 29 21_Non-partitioned index18_Edith Throckmorton29_elt900@EMAIL1.DSS.STATE.VA.US30_Fri, 3 Nov 2000 11:37:25 -0500568_iso-8859-1 We have created a non-partitioned index on a 10 partition table using the piecesize parameter. All of the pieces datasets were created in the specified stogroup which has only one disk pack. The NPI allocation was PRIQTY 50976, SECQTY 5136, and PIECESIZE of 16M for a 19 million row table. We have DB2V5 on OS/390. The IBM manuals infer that NPI piece datasets can be placed on separate disk packs. I couldn't find any sample SQL on how to accomplish this and what I tried hasn't worked. I don't know if there is a way to specify multiple stogroups on [...] 16329 141 25_Re: Non-partitioned index0_18_mebert@AMADEUS.NET30_Fri, 3 Nov 2000 17:54:06 +0100507_us-ascii Hi Edith,

with SMS, I think you can have an ACS routine that uses the last datasetname qualifier (.A001, .A002,...) to determine the target volume. However, if you want to change something that is already done, simply move the files to the correct location. Specify the target volume in the OUTDYNAM clause (see example). For moving partitioned TSs, you need to stop/start only the affected partition. For indexes, specify the name of the indexspace (in SYSINDEXES), not the indexname. [...] 16471 20 17_Memo Field in UDB11_Sinha, Amit19_Sinha.Amit@MBCO.COM30_Fri, 3 Nov 2000 11:18:04 -0600474_iso-8859-1 Hi, What's the Equivalent to memo field in UDB ? For Storing paragraphs of information in them. Any experiences ?

The application is in ASP and will be accesing it thru ODBC calls .

Thanks.

AMIT SINHA

================================================ 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. 16492 38 21_Re: Memo Field in UDB13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Fri, 3 Nov 2000 09:15:12 -0800403_us-ascii CLOB

Thanks. Ashish.

-----Original Message----- From: Sinha, Amit [SMTP:Sinha.Amit@MBCO.COM] Sent: Friday, November 03, 2000 9:18 AM To: DB2-L@RYCI.COM Subject: Memo Field in UDB

Hi, What's the Equivalent to memo field in UDB ? For Storing paragraphs of information in them. Any experiences ?

The application is in ASP and will be accesing it thru ODBC calls . [...] 16531 124 60_DB2/OS390 Unload files... 2 part.. need to load into UDB/AIX12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Fri, 3 Nov 2000 12:30:51 -0500557_iso-8859-1 Hello List, I've just been given 2 files to create a table in my UDB/AIX v7.1 database ... these files are the result of an unload operation on a mainframe database(DB2/OS390v5.1), these 2 files came from 1 table , with one file housing the data... the other file contains DDL-like data ... I need to create this same database in UDB/AIX. My question is, how can I use these two files in a load(preferable) or an import script to create the table in my AIX database? Is there a way to do this without having to manually convert the DDL-like [...] 16656 180 64_Re: DB2/OS390 Unload files... 2 part.. need to load into UDB/AIX10_Park, Stan17_SPark@STATE.NM.US30_Fri, 3 Nov 2000 10:38:45 -0700778_iso-8859-1 Check out http://people.mn.mediaone.net/scottrmcleod/eu03000.html for Unix DB2UDB scripts. I have used a modified version of download.ksh -stan

-----Original Message----- From: Randy Wilson [mailto:Randy_Wilson@BCBST.COM] Sent: Friday, November 03, 2000 10:31 AM To: DB2-L@RYCI.COM Subject: DB2/OS390 Unload files... 2 part.. need to load into UDB/AIX Sensitivity: Private





Hello List, I've just been given 2 files to create a table in my UDB/AIX v7.1 database ... these files are the result of an unload operation on a mainframe database(DB2/OS390v5.1), these 2 files came from 1 table , with one file housing the data... the other file contains DDL-like data ... I need to [...] 16837 68 39_Re: Java and WebSphere to DB2 on OS/39021_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US30_Fri, 3 Nov 2000 12:59:38 -0500648_iso-8859-1 Thanx for the response, Venkat and Allessandro. The JDBC -> DB2 Connect -> DDF works well.

Jim



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Alessandro Brezzi Sent: Thursday, November 02, 2000 1:59 PM To: DB2-L@RYCI.COM Subject: Re: Java and WebSphere to DB2 on OS/390



Hi Jim, in the next year we do exactly the same thing; first we started using MQ on both NT and OS/390, writing "application code" on OS/390 under CICS; the application code "own" the tables and do the SQL work with DB2. Rapidly we converted the Java class from MQ to ECI, [...] 16906 23 14_Re: free tools13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Fri, 3 Nov 2000 12:01:15 -0600564_- This Linux culture is coming over here too.



On Thu, 2 Nov 2000 16:10:27 +0200, teoman wrote:

>Dear Listers, >are there any free(or trial) db2 tools from bmc or platinum? >where can i download them? >thanks for your helps > > >R.Teoman KOCER >Halkbank BIM >System Programmer

================================================ 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. 16930 90 26_Re: db2set return code -1012_tim malamphy20_timalamphy@YAHOO.COM30_Fri, 3 Nov 2000 10:09:00 -0800564_us-ascii I've tried this and about every combination of flags I can think of with no luck in changing the DB2SYSTEM name. Nothing's in the diag.log either. Although I was focused on the DB2SYSTEM name, I knew I also didn't have DB2COMM set up after I recreated the instance. Once I fixed that, I was able to connect control center. I can live with this slight naming problem. I've been told DB2 keeps this info somewhere in the lpp filesets, so a reinstall or creative hacking is needed to make the change. Anyway, thanks to all for the help and suggestions. [...] 17021 41 35_Fast Unload, which product ? -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Fri, 3 Nov 2000 13:18:08 -0500413_US-ASCII We had the BMC Unload + and now we have Platinum Fast Unload. Both are excellent in terms of speed and increased funtionality.

>>> per.callerstal@MIPS.SE 11/03/00 06:17am >>> Hi,

The DSNTIAUL program we use in production just doesn't cut it anymore. Too much data to unload and too small a window.

Has anyone done any comparison of BMC Unload+ and IBM High performance Unload ? [...] 17063 23 33_DB2 Connect and Neon ShadowDirect10_Mike Evans28_EVANSMP@CO.MECKLENBURG.NC.US30_Fri, 3 Nov 2000 13:14:21 -0500330_US-ASCII I am interested in hearing from anyone who has experience using both DB2 Connect and Neon's ShadowDirect as a means of connecting to DB2 OS/390. In particular, I'd like to hear about experience with performance and DBA support issues between the two products since one uses DRDA and one does not. Thanks in advance. [...] 17087 20 48_DB2 UDB NT - How to determine what is installed?12_Rompot, Kurt26_kurt.rompot@INGRAMBOOK.COM30_Fri, 3 Nov 2000 12:22:50 -0600479_iso-8859-1 What is the quickest/easiest way to determine what exact DB2 UDB flavor is installed on Windows NT? Workgroup vs. Enterprise, version, fixpack, etc.

Thanks, Kurt

------------------ Kurt Rompot Ingram Book Company

================================================ 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. 17108 69 21_Re: Memo Field in UDB16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT30_Fri, 3 Nov 2000 19:04:31 +0100443_us-ascii hello,

do you mean CLOB?

Aurora Emanuela Dell'Anno Systems Programmer Sistemi Informativi S.p.A. e-mail: aurora.dellanno@sistinf.it tel. +39 335 7429486

no trees were killed in the sending of this message. however - a large number of electrons were seriously inconvenienced.

*std disclaimer* - my opinions are my own and if they seem ridiculous it may be that my get-up-and-go just got up and went... [...] 17178 64 39_Re: Fast Unload, which product ? -Reply13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Fri, 3 Nov 2000 10:27:10 -0800381_iso-8859-1 Just a word of caution. We found that Platinum Fast Unload takes a shared lock over the tablespace, as opposed to DSNTIAUL which goes the 'normal' way.....Intent share for the tablespace ; though I think there could be some parameter set up for our site which makes it do so. So, please test it for your shop before issuing a blanket guideline for the entire shop. [...] 17243 35 40_DB2 Connect and Neon ShadowDirect -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Fri, 3 Nov 2000 13:26:58 -0500480_US-ASCII You get what you pay for. DB2 Connect - inexpensive. ShadowDirect - expensive. goto top.

>>> EVANSMP@CO.MECKLENBURG.NC.US 11/03/00 01:14pm >>> I am interested in hearing from anyone who has experience using both DB2 Connect and Neon's ShadowDirect as a means of connecting to DB2 OS/390. In particular, I'd like to hear about experience with performance and DBA support issues between the two products since one uses DRDA and one does not. Thanks in advance. [...] 17279 51 20_Re: Request for Help11_Doug Fuerst14_djfirst@LI.NET30_Fri, 3 Nov 2000 13:41:18 -0500376_us-ascii I thought CA had stopped this nonsense. Run, do not walk, to an alternate vendor. This happened to me, I had to pay them $85,000 for my own legal licensed software, and subject it to their licensing rules. The alternative was that they'd sue, and didn't care that I had executed licenses and contracts. Change now, it will cost you more with CA in the long run. [...] 17331 76 39_Re: Fast Unload, which product ? -Reply9_Rob Crane22_racrane@CONCENTRIC.NET30_Fri, 3 Nov 2000 11:50:49 -0700596_us-ascii You can set Platinum Fast Unload to use one of three options when it comes to the reference parameter (REFERENCE, CHANGE, IGNORE). I would guess that you had it set to REFERENCE which is the most restrictive, but sometimes needed when dealing with production migrations.

-Rob

Mohan, Ashish" wrote: > > Just a word of caution. We found that Platinum Fast Unload takes a shared > lock over the tablespace, as opposed to DSNTIAUL which goes the 'normal' > way.....Intent share for the tablespace ; though I think there could be some > parameter set up for our site which [...] 17408 44 52_Re: DB2 UDB NT - How to determine what is installed?10_Leo Pedron19_lpedron@BOSCOVS.COM30_Fri, 3 Nov 2000 13:47:49 -0500457_iso-8859-1 type "regedit" at the command line and go down the object tree HKEY_LOCAL_MACHINE -> SOFTWARE -> IBM -> DB2 ....

or just type db2level at the prompt in a Command Window.

Hope that helps, Leo

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Rompot, Kurt Sent: Friday, November 03, 2000 1:23 PM To: DB2-L@RYCI.COM Subject: DB2 UDB NT - How to determine what is installed? [...] 17453 58 52_Re: DB2 UDB NT - How to determine what is installed?14_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 3 Nov 2000 13:51:30 -0500459_us-ascii Kurt, I usually use regedit, local machine, software, ibm, db2 etc, etc, Will show what is installed and version/fix pack level. There is other ways but this is the sure way. Phil



Phil Gunning DB2 DBA











"Rompot, Kurt" cc: Sent by: DB2 Data Subject: DB2 UDB NT - How to determine what Base Discussion is installed? List [...] 17512 176 64_Re: DB2/OS390 Unload files... 2 part.. need to load into UDB/AIX10_Leo Pedron19_lpedron@BOSCOVS.COM30_Fri, 3 Nov 2000 13:57:40 -0500349_iso-8859-1 DB2/OS390 Unload files... 2 part.. need to load into UDB/AIXIf the tables still exist on the mainframe, then you can catalog the data source and use the export command. Export the data in .ixf format to a file on AIX. You should then be able to use the import_create command to create the table and insert the data in one operation. [...] 17689 130 26_Re: db2set return code -1014_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 3 Nov 2000 14:02:29 -0500722_us-ascii It's probably recorded in the ODM somewhere. -- Phil



Phil Gunning DB2 DBA











tim malamphy cc: Sent by: DB2 Subject: Re: db2set return code -10 Data Base Discussion List



11/03/00 01:09 PM Please respond to DB2 Data Base Discussion List











I've tried this and about every combination of flags I can think of with no luck in changing the DB2SYSTEM name. Nothing's in the diag.log either. Although I was focused on the DB2SYSTEM name, I knew I also didn't have DB2COMM set up after I recreated the instance. Once I fixed that, I was [...] 17820 55 39_Re: Fast Unload, which product ? -Reply13_Davis, Ronald17_DavisRo@CONED.COM30_Fri, 3 Nov 2000 14:04:42 -0500424_- I've used the Platinum Fast Unload .I had to unload production data to load test environments. I didn't want to impact production so I found that the Platinum Fast Unload ability to unload from an imagecopy was extremely helpful.

-----Original Message----- From: John Bucaria [SMTP:JBUCARIA@MAIL2.PCH.COM] Sent: Friday, November 03, 2000 1:18 PM To: DB2-L@RYCI.COM Subject: Fast Unload, which product ? -Reply [...] 17876 67 37_Re: DB2 Connect and Neon ShadowDirect14_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 3 Nov 2000 14:07:46 -0500469_us-ascii Mike, I can only speak for DB2 Connect . It is well supported and documented. It works. It continues to get better with connection pooling and connection concentration and SQL profiling. There is a fair amout of expertise on this list on DB2 Connect, I'm not sure about Neon Shadow Direct. I have supported DB2 Connect for over 3 years with very few problems. But, to really see which is better, establish some criteria and evaluate both of them. -- Phil [...] 17944 95 44_Re: DB2 Connect and Neon ShadowDirect -Reply12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Fri, 3 Nov 2000 14:08:45 -0500308_iso-8859-1 Hi Mike,

We compared the "big 3" ODBC drivers a few years ago. We have been running DB2 Connect with few problems, and the problems we have had were mostly the result of backleveled maintenance on OS390. We are a small shop, with a small number of users that mostly do mega downloads. [...] 18040 94 14_Re: free tools14_Grainger, Phil20_Phil.Grainger@CA.COM30_Fri, 3 Nov 2000 19:32:05 -0000439_iso-8859-1

Of course,

All of the DB2 (and IMS) tools from Computer Associates are available for a trial period. Just like buying a car, we'd be happy for you to take a test drive first.

Phil Grainger Product Manager, DB2 Tools Computer Associates

-----Original Message----- From: McCombs, Terry [mailto:tmccomb@SEDGWICK.GOV] Sent: 02 November 2000 16:30 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] free tools [...] 18135 19 28_DB2 Connect on UNIX or NT???15_Stacey L Waters23_waterss1@NATIONWIDE.COM30_Fri, 3 Nov 2000 13:33:57 -0600350_us-ascii We are just getting into DB2 Connect and currently have it running on a NT Server that is not designated to DB2 Connect. We are in the process of evaluating what OS platform to use for the DB2 Connect gateway(s) (NT or UNIX). I am looking for input on stability, performance, high availability, and anything else that would be helpful! [...] 18155 65 32_Re: DB2 Connect on UNIX or NT???14_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 3 Nov 2000 14:44:58 -0500452_us-ascii What are your requirements? Are you talking 200-300 users or 5,000? DB2 Connect runs nicely with 200-300 users on NT . You could use more NT servers and use load balancing. Or, if you are going to have significantly more than 300 or so users, I would not use NT but go with AIX for proven reliability, and availability. As a rule of thumb, when you do not have a good handle on what your requirements will be, take AIX over NT. HTH Phil. [...] 18221 78 37_Re: DB2 Connect and Neon ShadowDirect10_Mike Evans28_EVANSMP@CO.MECKLENBURG.NC.US30_Fri, 3 Nov 2000 15:04:23 -0500549_US-ASCII Phil, thanks for your input.

>>> pgunning@PHEAA.ORG 11/03/00 02:07PM >>> Mike, I can only speak for DB2 Connect . It is well supported and documented. It works. It continues to get better with connection pooling and connection concentration and SQL profiling. There is a fair amout of expertise on this list on DB2 Connect, I'm not sure about Neon Shadow Direct. I have supported DB2 Connect for over 3 years with very few problems. But, to really see which is better, establish some criteria and evaluate both of them. -- Phil [...] 18300 120 44_Re: DB2 Connect and Neon ShadowDirect -Reply10_Mike Evans28_EVANSMP@CO.MECKLENBURG.NC.US30_Fri, 3 Nov 2000 15:07:26 -0500475_US-ASCII Robert, thanks for your input. I talked to Gartner and they pointed out some of the same things you mentioned.

>>> Robert.Hall@OCC.TREAS.GOV 11/03/00 02:08PM >>> Hi Mike,

We compared the "big 3" ODBC drivers a few years ago. We have been running DB2 Connect with few problems, and the problems we have had were mostly the result of backleveled maintenance on OS390. We are a small shop, with a small number of users that mostly do mega downloads. [...] 18421 81 52_Re: DB2 UDB NT - How to determine what is installed?12_Cook, Nicole19_Nicole_Cook@BMC.COM30_Fri, 3 Nov 2000 16:23:20 -0600483_iso-8859-1 Another way is to go to a dos prompt and type "db2cmd" to access the DB2 command line prompt. Then type "db2level". It will tell you the release level and fix pack level.



Nicole Cook Software Support Analyst bmcsoftware 800.537.1813 ncook@bmc.com

-----Original Message----- From: Philip Gunning [mailto:pgunning@PHEAA.ORG] Sent: Friday, November 03, 2000 12:52 PM To: DB2-L@RYCI.COM Subject: Re: DB2 UDB NT - How to determine what is installed? [...] 18503 46 24_FW: UDB install problems13_Doctor, Nadir24_Nadir.Doctor@BGEHOME.COM30_Fri, 3 Nov 2000 17:23:18 -0500526_iso-8859-1 Are you trying to install a Server version of the product on your machine instead of the Personal edition ? (The last one appearing in the list seems odd to me)

-----Original Message----- From: Dennis Raher [mailto:Dennis_Raher@COMPUSERVE.COM] Sent: Thursday, November 02, 2000 9:25 PM To: DB2-L@RYCI.COM Subject: UDB install problems



I have been trying to get UDB 7.1 installed on my windoes 95 system and can't solve the DLL problems. There appears to be a set of DLL's that UDB thinks [...] 18550 209 15_Help with Query25_Loganathan M Ramachandran41_loganathan.m.ramachandran@MAIL.SPRINT.COM30_Fri, 3 Nov 2000 16:23:42 -0600298_ISO-8859-1 Hi,

We have a query, which on Explain shows only 3 matching keys but the query is actually coded to use 4 matching Index keys. I have given the EXPLAIN below, can anyone explain why? Is there any way to instruct the DB2 to use the 4th key?

Ours is DB2 V6.1 in OS/390. [...] 18760 20 44_Re: DB2 Connect and Neon ShadowDirect -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM30_Fri, 3 Nov 2000 17:31:20 -0500461_US-ASCII It seems like my attempt to compliment what I believe to be a great product, ShadowDirect, was met with great disapproval by our salesman at Neon Systems who felt it was his duty to call and berate my manager because of my unfortunate use of the word "expensive".

For this reason I must remind everyone that the opinion expressed by myself is just that, my opinion which is in no way meant to express the opinion of the company I work for. [...] 18781 213 19_Re: Help with Query24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Fri, 3 Nov 2000 14:47:26 -0800316_iso-8859-1 The part of the WHERE clause using EFF_DT >= ? and EFF_DT <= ? will be converted by the DB2 optimizer to a BETWEEN. But even if it weren't, this would stop the match on the index at the third column in the index. However, DB2 would still use the fourth column (PSGL_POST_SYS_ID) to qualify the rows. [...] 18995 19 44_Control Center on NT not Recognizing User ID16_Swinski, Kenneth23_KSwinski@MASSMUTUAL.COM30_Fri, 3 Nov 2000 18:27:43 -0500509_iso-8859-1 An NT user just upgraded his Client Admin software from 5.2 to 6.1 and now the Control Center won't recognize his user ID. He says he's using his "NT Domain ID that's a member of the admin group on his PC". I don't know much about NT security. I'm running NT and I successfully sign on to the Control Center using the same ID and password I use for MS Outlook. Does anybody have any suggestions? I'm thinking of having him set DB2_GRP_LOOKUP=local, even though I don't have that variable set. [...] 19015 216 19_Re: Help with Query15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM30_Fri, 3 Nov 2000 15:59:43 -0800332_iso-8859-1 Predicates are applied/matched in the order of the column was defined in the index. Without ever saying so, DB2 will switch to index screening after it hits the first range predicate, range predicates being between, >, >=, <, <=, and is null. So your 4th key column is being screened not matched on but not ignored. [...] 19232 19 23_DB2 Performance Monitor8_Rush Yan14_db2-l@21CN.COM30_Sat, 4 Nov 2000 12:35:33 +0800550_- Hi, Is there anybody using IBM DB2 Performance Monitor? what substitutes prevail out there? would like to here your comments here or privately. Thank you.

Rush Yan ---------------------------------------------- »ΆΣ­ΚΉΣΓ 21CN ΅ηΧΣΣΚΌώΟ΅Ν³ http://www.21cn.com Thank you for using 21cn.com Email system

================================================ 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. 19252 51 28_Re: New IBM DB2 tools -Reply12_Doug Clifton16_dclifton@EV1.NET30_Fri, 3 Nov 2000 22:36:47 -0600597_us-ascii All of the tools we announced Sept 12 will work with earlier versions of DB2 and you may order the tools now.

Regards, Doug Clifton S/390 DB Tools IBM



At 12:57 PM 11/2/00 -0500, you wrote: >I didn't know they were available yet. The most I've heard is that they >may be available soon as packages with V7, but no specifics about >functionality or comparisons to other vendor tools. > >Regards, >John > > >>> aldrinj@AU1.IBM.COM 11/01/00 08:08pm >>> >Those interested, > >Is there anyone using the new IBM DB2 tools? How do they compare to other >ISV (like BMC, [...] 19304 45 28_Re: Platinum and BMC AppTune12_Doug Clifton16_dclifton@EV1.NET30_Fri, 3 Nov 2000 22:38:50 -0600558_us-ascii And from IBM you may want to take a look at DB2 PM, Query Monitor, and SQL Performance Analyzer. Query Monitor will allow you to capture all SQL statements without starting a trace.

Regards, Doug Clifton S/390 DB Tools IBM

At 11:01 AM 11/2/00 -0700, you wrote: >CA products you may be intersted in: > >Database Analyzer >Detector >Subsystem Analyzer >Insight with 24x7 > >-Rob > > > Lisa Westcott-Dryer wrote: > > > > Hi there. Can anyone tell me if there is a comparable Platinum > > tool for the BMC AppTune tool? > > > > thank [...] 19350 15 44_Pamela Harris/IT/SEARS is out of the office.0_17_pharri1@SEARS.COM30_Sat, 4 Nov 2000 02:00:12 -0600447_us-ascii I will be out of the office from 11/03/2000 until 11/06/2000.

If you need assistance with DB2, use PIN # 7270526, for informix/sqlserver use PIN # 7270525, network issues use PIN # 7271038.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19366 35 46_SQL0970N occurs when adding database container2_dh14_dhord@INCH.COM30_Sat, 4 Nov 2000 11:40:52 -0500586_iso-8859-1 "The system attempted to write to a read-only file" -- apparently refering to the file I've specified for the new database container.

Anybody have any suggestions. Running V 6.1 Workstation, FixPk 5, on NT.

Here is message:

[IBM][CLI Driver][DB2/NT] SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009





SQL:

CREATE LONG TABLESPACE ARTICLES PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE 'I:\Mil_Articles' 20480) EXTENTSIZE 32 OVERHEAD 14.17 PREFETCHSIZE 32 TRANSFERRATE 0.8 BUFFERPOOL IBMDEFAULTBP [...] 19402 110 39_Re: Fast Unload, which product ? -Reply12_Greg Parrish15_zengreg@JPS.NET28_Sat, 4 Nov 2000 17:01:40 GMT652_iso-8859-1 Of course Rob below is referring to Fast Unload's SHRLEVEL parameter, which indicates the level of data integrity requested. Note that with the CHANGE option, the table has no lock placed on it, and other programs can change the table.

-Greg



>-----Original Message----- >From: Rob Crane [mailto:racrane@CONCENTRIC.NET] >Sent: Friday, November 03, 2000 10:51 AM >Subject: Re: Fast Unload, which product ? -Reply > > >You can set Platinum Fast Unload to use one of three options when it >comes to the reference parameter (REFERENCE, CHANGE, IGNORE). I would >guess that you had it set to REFERENCE which is the most [...] 19513 40 27_Re: DB2 Performance Monitor12_Greg Parrish15_zengreg@JPS.NET28_Sat, 4 Nov 2000 17:04:09 GMT376_iso-8859-1 Hi Rush, Another DB2 performance monitor is CA-Insight, which monitors subsystem/application real-time (and history) activity via online or batch. It can also report on DB2 thread activity & history, defined exceptions, CICS/IMS attachments, do EXPLAINs, run application traces or customized reports, perform auditing functions, issue DB2 & MVS commands, etc. [...] 19554 18 18_Free tools for DB213_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Sat, 4 Nov 2000 09:26:13 -0800485_- > I'm afraid if you want a free tools you have to build them by your > own......with REXX/ISPF panels.

Free code from DB2 Update: alphabetical list by article title

-HJC

================================================ 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. 19573 56 61_Migrate table definitions from Subsystem to another subsystem16_Bachi Allamsetty22_BachiA@RENEWAL-IIS.COM30_Sun, 5 Nov 2000 04:17:56 -0500589_iso-8859-1 Greetings group.

I have a task in front of me and the alternative that I am considering requires some advice from experienced people like you.

ENVIRONMENT : DB2 V6.1 for OS/390 2.8. "NO THIRD PARTY TOOLS".

Ours is a small shop with one DB2 subsystem with couple of user databases consisting of 300 tables in each database. Recently we created a new sub system to apply latest maintenance for DB2 and now we are ready to move to new susbsystem. Don't ask me why not apply maintenance on first susbsystem, it's beyond my control. My task here is to move [...] 19630 155 65_Re: Migrate table definitions from Subsystem to another subsystem0_18_mebert@AMADEUS.NET30_Sun, 5 Nov 2000 11:02:19 +0100586_us-ascii Hi Bachi,

I have done a couple of migrations using DSN1COPY... but, as you have found out, there are a lot of "ifs" associated with it. The main hassle is the OBID/DBID/PSID translation; the only real advantage is that you can use an imagecopy as input. For your task, I would go by way of Unload/Reload; use REORG UNLOAD EXTERNAL Utility for unloading and LOAD (of course) for loading. This has the added advantage that if something goes unexpectedly wrong after dropping the source table, you still have the data in usable format as well as a good description of [...] 19786 223 65_Re: Migrate table definitions from Subsystem to another subsystem16_Bachi Allamsetty22_BachiA@RENEWAL-IIS.COM30_Sun, 5 Nov 2000 08:24:28 -0500329_- Dr Ebert !

It was such a pleasure to read your responses. Thanks for clarification and I am glad that I posted this question to the list group.

I think I would go with your solution since it is one time exercise. Like you rightly pointed out this is a question of doing it correctly rather than efficiently. [...] 20010 199 65_Re: Migrate table definitions from Subsystem to another subsystem0_18_mebert@AMADEUS.NET30_Sun, 5 Nov 2000 14:47:53 +0100362_us-ascii Hi Bachi,

glad to be of help. According to my experience, REORG UNLOAD EXTERNAL is about 4-8 times as efficient as DSNTIAUL for simple, full tablespace unloads. It handles multi-table TSs and generates the proper LOAD statements in SYSPUNCH; you may have to edit them slightly (changing table names or specifying REPLACE instead of RESUME). [...] 20210 26 65_Re: Migrate table definitions from Subsystem to another subsystem8_Bob Abad16_BobRabad@AOL.COM28_Sun, 5 Nov 2000 11:13:12 EST418_US-ASCII Bachi,

Dr. Ebert's suggestion is the better alternative. Also, don't forget to specify 'log no' in your reload portion. For quality assurance, you might want to do a compare of both DDL sources from the utility panel....Check your dasd space, use the compression parm for better space usage & performance. Good timing also to verify the separations of your tablespace & indexspace buffer pools... [...] 20237 42 0_12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM28_Sun, 5 Nov 2000 23:00:57 GMT701_- Hi Folks:

Since I altered the storage group definition from VOLUMES(DBA701,DBA702,DBA703) to VOLUMES ('*','*','*') , I started to received a lot of messages like this below:

DSNP010I @ END OF MESSAGES. CONNECTION-ID=BATCH CORRELATION-ID=APPTALRD LUW-ID=* DSNP005I @ DSNPRMVV - COULD NOT REMOVE EXCESS VOLUMES FROM CANDIDATE LIST OF DB2D.DSNDBD.DSCM060.XCM621PC.I0001.A001 CONNECTION-ID=BATCH, CORRELATION-ID=APPTALRD, LUW-ID=*



The db2 messages manual says that it is not a big deal because it won't cause any problem but I would like to know if there is something that I can do to avoid this message. I think the only way to avoid this message is changing the name [...] 20280 52 45_Re: DB2 and WEB Application Security Question9_Eric Kwai18_Eric_Kwai@DTCC.COM30_Sun, 5 Nov 2000 18:36:10 -0600306_- Gillard: There are a few ways to accomplish this depends on how tight you want to control the access. Assuming you are using DB2 Connect to communicate to the host.

Option 1 Convert your Data Access business logic to Stored Procedure 2. Use embedded SQL or SQLJ to access the DB2 OS/390 data [...] 20333 59 45_Re: DB2 and WEB Application Security Question9_Eric Kwai18_Eric_Kwai@DTCC.COM30_Sun, 5 Nov 2000 18:50:40 -0600398_- Gillard:

Sorry, hit the enter key too fast. Lets try it again.

There are a few ways to accomplish this, depends on how tight you want to control the access. Assuming you are using DB2 Connect to communicate to the host,

Option 1 Convert your Data Access business logic to Stored Procedure 2. Use embedded SQL or SQLJ to access the DB2 OS/390 data 3. Use dynamic SQL :-( [...] 20393 228 19_Re: Help with Query11_Suresh Sane21_data_arch@HOTMAIL.COM28_Sun, 5 Nov 2000 20:29:39 CST556_- As others will point out, the matching stops at the first range predicate (in this case the 3rd column). Screen will still occur on the 4th column (except if List prefetch, and V5 or earlier).

Last week an interesting technique was posted that might help you. If you create a "calendar" table containg all possible dates, you could covert the range predicates on your eff_dt and exp_dt to a IN list (with a subselect on the required dates in the range). If this list is short enough you will get an accesstype N on the 3rd col and then macth [...] 20622 46 19_Re: Help with Query14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM30_Mon, 6 Nov 2000 17:14:55 +1100581_- > Loga, > > As previously mentioned, the range scan of the BETWEEN disables any > further matchcols. There are two ways (that I can think of) to increase > the matchcols to 4, but the first question to ask is whether it will buy > you any performance improvement; apart from influencing the optimizers > table join sequence. > > Promoting an index screening (non-matching but indexable predicate) to > index matching will potentially reduce the number of index leaf pages hit. > This is difficult to decipher since you do not appear to have multi-column > cardinality stats [...] 20669 12 32_Re: Fast Unload, which product ?14_Per Callerstal22_per.callerstal@MIPS.SE30_Mon, 6 Nov 2000 02:18:38 -0600303_- Forgot to mention that we're on DB2 V6, OS/390.

/per

================================================ 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. 20682 25 27_Re: DB2 Performance Monitor14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Mon, 6 Nov 2000 10:35:27 +0100504_us-ascii I used DB2PM mainly for batch reports, and (my opinion only) it's better than other monitors. Statistics & accounting reports are clear and flexible. And DB2PM reports are more 'rexxable' (i.e. you can use these reports to build sub-reports with REXX to alter bufferpool limits, for instance).

The online monitor is good, but I prefere B&B Mainview for DB2 (first). Omegamon (second) is good, but sometimes it's more 'obscure' and (in my opinion) the interface is non so 'friendly'. [...] 20708 71 30_Migration to DB2 V6 and REBIND12_Jacob Ganzel19_jacobg@SEMECH.CO.IL30_Mon, 6 Nov 2000 12:06:04 +0200406_x-user-defined Q. Is REBIND mandatory in migration process from V5 to V6 in OS/390 SYSPLEX environment? Can it be done partially or it must be in one shot? Thanks. --------------------------------------------------------------- Jacob Ganzel Database Products Mgr. SEMECH Software Marketing Ltd.

3b Netanyahu St., OR YEHUDA, ISRAEL Email: jacobg@semech.co.il Tel.: +972-3-5333144 Fax.: +972-3-5333132 20780 65 22_Table space Estimation0_18_dsi.listsrv@DB.COM31_Wed, 29 Nov 2000 16:20:52 +0530448_us-ascii Hi,

Using the following example, how do I Estimate the Table space for 'TSREG', 'TSIX' and 'TSLO'.



TABLE STRUCTURE : AUTHOR

AUTHOR(PK) SMALLINT 2 NOT NULL NAME(INDEX) VARCHAR 50 NOT NULL SPEAKER CHAR 1 NOT NULL PICTURE BLOB 1M NOT NULL

NO OF ROWS EXPECTED : 5000

From the above example, I would like to store the data in the following table spaces : Regular : TSREG Index : TSIX Long : TSLO [...] 20846 28 22_Replication Monitoring19_Margaritis Dimitris20_margardi@NOVABANK.GR30_Mon, 6 Nov 2000 14:26:38 +0200447_iso-8859-7 Hi all,

I have implement a DB2 replication on NT. When I define subscriptions I declared continiously replication. However when I insert a row in a table in the source database this row appears in replica after 10-20 minutes. My network is very fast and I want to find the appropiate query to ASN tables in order to know 1)Which is the latest transaction that is replicated and what time 2) Number of remaining transactions [...] 20875 95 26_Re: Table space Estimation16_Bachi Allamsetty22_BachiA@RENEWAL-IIS.COM30_Mon, 6 Nov 2000 07:38:33 -0500481_- Siva !

Try using DB2 ESTIMATOR (free download from www.software.ibm.com/data/db2)

This is great tool and generates detailed but lengthy reports.

bachi

-----Original Message----- From: dsi.listsrv@DB.COM [mailto:dsi.listsrv@DB.COM] Sent: Wednesday, November 29, 2000 5:51 AM To: DB2-L@RYCI.COM Subject: Table space Estimation



Hi,

Using the following example, how do I Estimate the Table space for 'TSREG', 'TSIX' and 'TSLO'. [...] 20971 28 15_Help With Query11_David Nance16_DWNance@FHSC.COM30_Mon, 6 Nov 2000 07:48:03 -0500533_US-ASCII Wondering if anyone can help me figure this one out. Given a unique id and its attributes, including its start and end dates find rows that have same attributes within a 60 +/- day range,(this is where it gets difficult) if one is found look back or forward another 60 days until you get to a range greater than 60 days. One of the ideas I had was to find all rows that qualify without using date processing, then look forward from my given end date to the next start date till range greater than 60 was found and same [...] 21000 35 27_Re: DB2 Performance Monitor10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Mon, 6 Nov 2000 06:55:40 -0600734_ISO-8859-1 Just for the sake of completeness, I should add DB2AM from BMC, which is on a par with Omegamon for DB2, and CA-Insight. They're all pretty similar and as online monitors (in my opinion), have better functionality than DB2PM.



On Sat, 4 Nov 2000 12:35:33 +0800, Rush Yan wrote:

> Hi, > Is there anybody using IBM DB2 Performance Monitor? what substitutes prevail out there? would like to here your comments here or privately. Thank you. > >Rush Yan >---------------------------------------------- >»ΆΣ­ΚΉΣΓ 21CN ΅ηΧΣΣΚΌώΟ΅Ν³ http://www.21cn.com >Thank you for using 21cn.com Email system > >================================================ >To change your subscription options or [...] 21036 42 44_Re: DB2 Connect and Neon ShadowDirect -Reply19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 6 Nov 2000 07:08:00 -0600307_ISO-8859-1 Hey John, have your salesman call me, I'll conference you in, and I'll give him or her my "great disapproval" on how poorly they treated you! I was out in the National Forest one camping trip and observed that sneaking around behind your back is something weasels do!

HTH, Rick Davis [...] 21079 35 36_OS/390 V5 - Table in Read Only Mode?10_Joan Green22_Joan.Green@BOIMAIL.COM30_Mon, 6 Nov 2000 13:19:17 +0000703_us-ascii Hi List,

Quick and easy question - how can I tell if a table is in Read-only mode?

TIA

J.Green





******************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately at MailManager@psir.ie and delete this E-mail from your system. Thank you. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted. For this reason, where the communication is by email, the Bank of Ireland Group [...] 21115 46 27_Re: DB2 Performance Monitor19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Mon, 6 Nov 2000 08:39:33 EST541_ISO-8859-1 Just want to add TMON/DB2 to the list. They also have TMON/CICS and TMON/MVS. We use all three at this installation.

Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: "John Hardy" , on 11/06/2000 7:55 AM: Just for the sake of completeness, I should add DB2AM from BMC, which is on a par with Omegamon for DB2, and CA-Insight. They're all pretty similar and as online monitors (in my opinion), have better functionality than DB2PM. [...] 21162 55 40_Re: OS/390 V5 - Table in Read Only Mode?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Mon, 6 Nov 2000 08:35:06 -0500465_iso-8859-1 -DIS DB(databasename)SPACE(tablespacename) for the tablespace which contains the table.

eric pearson ITO DB2 support Eric.Pearson@nscorp.com



-----Original Message----- From: Joan Green [mailto:Joan.Green@BOIMAIL.COM] Sent: Monday, November 06, 2000 8:19 AM To: DB2-L@RYCI.COM Subject: OS/390 V5 - Table in Read Only Mode?



Hi List,

Quick and easy question - how can I tell if a table is in Read-only mode? [...] 21218 58 40_Re: OS/390 V5 - Table in Read Only Mode?14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE30_Mon, 6 Nov 2000 14:42:19 +0100643_us-ascii Hi Joan,

-DIS DB(dbname)SPACE(tsname) should do the trick.

Regards

Ruediger Kurtz

Joan Green schrieb:

> Hi List, > > Quick and easy question - how can I tell if a table is in Read-only mode? > > TIA > > J.Green > > ******************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please > notify us immediately at MailManager@psir.ie and delete this E-mail > from your system. Thank you. > It [...] 21277 63 40_Re: OS/390 V5 - Table in Read Only Mode?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 6 Nov 2000 07:42:53 -0600605_ISO-8859-1 -DIS DB(dbname) SPACE(spacename)

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, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 21341 78 40_Re: OS/390 V5 - Table in Read Only Mode?21_Sean M O'Keefe/AC/VCU15_sokeefe@VCU.EDU30_Mon, 6 Nov 2000 08:41:57 -0500518_us-ascii Joan, For DB2 for OS/390: -DISPLAY DATABASE (DBNAME) from panel 7 in SPUFI. You will see RO under the STATUS column if the tablespace is in READ ONLY status. NAME TYPE PART STATUS PHYERRLO PHYERRHI CATALOG PIECE, -------- ---- ---- ------------------ -------- -------- -------- -----, XXYYTS TS RO

Sean







Joan Green cc: Sent by: DB2 Subject: OS/390 V5 - Table in Read Only Mode? Data Base Discussion List [...] 21420 12 44_OS/390 V5 - Table in Read Only Mode? (Reply)14_Mike Ockenfels28_michael.d.ockenfels@WCOM.COM30_Mon, 6 Nov 2000 07:45:30 -0600274_us-ascii -DIS DB(XXX) SPACE(YYY)

================================================ 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. 21433 69 0_12_craig patton21_prgpatton@HOTMAIL.COM28_Mon, 6 Nov 2000 13:50:44 GMT774_- Harbry Ariza,

First change the STogroup definition to ('*') ONLY!. Then REORG the objects that use the STOGROUP.

HTH, Craig Patton





>From: HARBRY ARIZA >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Date: Sun, 5 Nov 2000 23:00:57 GMT > >Hi Folks: > > Since I altered the storage group definition from >VOLUMES(DBA701,DBA702,DBA703) to VOLUMES ('*','*','*') , I started to >received a lot of messages like this below: > >DSNP010I @ END OF MESSAGES. > CONNECTION-ID=BATCH > CORRELATION-ID=APPTALRD > LUW-ID=* >DSNP005I @ DSNPRMVV - COULD NOT REMOVE EXCESS VOLUMES >FROM CANDIDATE LIST OF DB2D.DSNDBD.DSCM060.XCM621PC.I0001.A001 > CONNECTION-ID=BATCH, CORRELATION-ID=APPTALRD, > [...] 21503 52 40_Re: OS/390 V5 - Table in Read Only Mode?11_David Nance16_DWNance@FHSC.COM30_Mon, 6 Nov 2000 08:48:00 -0500440_US-ASCII DB2 cmd -dis database(dbname) spacenam(tablespace name) or you can look at entire database using -dis database(*) spacenam(*) limit(*) restrict this will show you any restrictions(copy or check pending, utility, etc...)

Dave Nance First Health Services, Corp. (804)527-6841

>>> Joan.Green@BOIMAIL.COM 11/06/00 08:19AM >>> Hi List,

Quick and easy question - how can I tell if a table is in Read-only mode? [...] 21556 86 45_Re: DB2 and WEB Application Security Question18_Gillard, Joseph L.23_gillard.joseph@MAYO.EDU30_Mon, 6 Nov 2000 08:01:08 -0600606_- Eric, thank you for the input, this will give some options.

Joe Gillard ISR - CP 864 (507)284-0041 Mayo Clinic Foundation gillard.joseph@mayo.edu



> -----Original Message----- > From: Eric Kwai [SMTP:Eric_Kwai@DTCC.COM] > Sent: Sunday, November 05, 2000 6:51 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 and WEB Application Security Question > > Gillard: > > Sorry, hit the enter key too fast. Lets try it again. > > There are a few ways to accomplish this, depends on how tight you want > to > control the access. Assuming you are using DB2 Connect to communicate to > the host, [...] 21643 60 40_Re: OS/390 V5 - Table in Read Only Mode?12_craig patton21_prgpatton@HOTMAIL.COM28_Mon, 6 Nov 2000 14:24:31 GMT678_- Joan,

Check the status of the table's tablespace.

HTH, Craig Patton



>From: Joan Green >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: OS/390 V5 - Table in Read Only Mode? >Date: Mon, 6 Nov 2000 13:19:17 +0000 > >Hi List, > >Quick and easy question - how can I tell if a table is in Read-only mode? > >TIA > >J.Green > > > >******************************************************************** >This email and any files transmitted with it are confidential and >intended solely for the use of the individual or entity to whom they >are addressed. If you have received this email [...] 21704 24 40_Re: OS/390 V5 - Table in Read Only Mode?14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Mon, 6 Nov 2000 15:25:08 +0100562_us-ascii If you have recent PTFs for V5 you can use:

-DIS DB(db_name) SPACENAM(*) LIMIT(*) RES(RO)

This command displays ONLY tablespaces/indexes in read only

You can use this command to display all restricted tablespaces (UT,RECP, etc etc).

HTH

Max Scarpa Non-certified DB2 sysfurlong

================================================ 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. 21729 33 61_ca(platinum log analyzer) not working after DB2V6 conversion.13_Terry Shockey30_Terry.Shockey@OCSE.STATE.AR.US30_Mon, 6 Nov 2000 08:40:40 -0600335_iso-8859-1 Hello List, we converted to DB2V6 over the weekend and when conversion was complete our ca log analyzer extraction job could not find any records to extract(there were plenty to extract) that were created after the DB@V6 conversion but still extracts records from the DB2V5 log that were created just prior to the DB2. [...] 21763 50 65_Re: ca(platinum log analyzer) not working after DB2V6 conversion.15_Zander, Barb J.19_bzander@STATE.ND.US30_Mon, 6 Nov 2000 08:57:39 -0600657_ISO-8859-1 Yes, we had this problem too. This is a known problem with a fix(yea).

Barb

-----Original Message----- From: Terry Shockey [mailto:Terry.Shockey@OCSE.STATE.AR.US] Sent: Monday, November 06, 2000 8:41 AM To: DB2-L@RYCI.COM Subject: ca(platinum log analyzer) not working after DB2V6 conversion.



Hello List, we converted to DB2V6 over the weekend and when conversion was complete our ca log analyzer extraction job could not find any records to extract(there were plenty to extract) that were created after the DB@V6 conversion but still extracts records from the DB2V5 log that were created just prior to the DB2. [...] 21814 72 65_Re: ca(platinum log analyzer) not working after DB2V6 conversion.0_17_sjvagnier@AEP.COM30_Mon, 6 Nov 2000 09:54:50 -0500362_us-ascii Hello Terry,

We experienced this problem also when testing Log Analyzer with DB2 V6. In our case, our release of Log Analyzer (P99G) did not support DB2 V6. CA recommended we upgrade to a new release(?) of Log Analyzer. I would contact CA technical support.



Good luck....

Regards, Steve Vagnier American Electric Power [...] 21887 150 65_Re: ca(platinum log analyzer) not working after DB2V6 conversion.15_Badgley, Andrew21_Andrew.Badgley@CA.COM30_Mon, 6 Nov 2000 10:02:24 -0500339_iso-8859-1 This most likely has do due with the maintenance level of CAs Log Analyzer. IBM put out a PTF for version 6, the PTF number escapes me at the moment, that switched the purpose of some bits in the log record. The problem has already been identified and a solution is available. Please contact tech support to order the fix. [...] 22038 14 65_Re: ca(platinum log analyzer) not working after DB2V6 conversion.0_17_JTonchick@AOL.COM28_Mon, 6 Nov 2000 10:15:38 EST369_US-ASCII Did you call CA support to ask if you were at the correct level of Log Analyzer to support DB2 V6 before you migtated?

================================================ 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. 22053 119 65_Re: Migrate table definitions from Subsystem to another subsystem10_Missy Case28_Missy.Case@FIRSTDATACORP.COM30_Mon, 6 Nov 2000 09:53:43 -0600456_us-ascii Bachi,

We did an LPAR split once - taking 2 DB2 subsystems & splitting them onto two different LPARS. With some preplanning and DASD work, we did the switch over totally painlessly & there was only verification work for the DBA to do. The DASD guys did all the work with the catalogs & aliases & ICF catalog functions. We had NO CHOICE either & since we 'moved' our SAP system, it was too much (70 volumes) to copy or unload & reload. [...] 22173 107 26_Re: db2set return code -1012_Travis, John27_John.Travis@CAPGEMINI.CO.UK30_Mon, 6 Nov 2000 13:13:06 -0000414_- Tim, I found that I also needed to be logged in using the Admin Server id to be able to change the DB2SYSTEm variable. It works for me anyway as I have just had to change the setting for a system moved onto a new server.

John Travis

-----Original Message----- From: tim malamphy [mailto:timalamphy@YAHOO.COM] Sent: 03 November 2000 18:09 To: DB2-L@RYCI.COM Subject: Re: db2set return code -10 [...] 22281 52 15_Re: Remote bind0_19_Tim.Lowe@STPAUL.COM30_Mon, 6 Nov 2000 12:13:30 -0600400_us-ascii Sibi, Thanks to Curt Cotner, the following 2 APARs remove the restriction on hyphens (-) in SQL with remote package bind in DB2 version 6: PQ29507 and PQ31209

Thanks, Tim





"Philip, Sibimon" To: DB2-L@RYCI.COM Subject: Remote bind

11/01/2000 05:34 PM Please respond to DB2 Data Base Discussion List [...] 22334 19 27_DRDA Compatibility Question7_Db2 Dba24_data_analyst@HOTMAIL.COM30_Mon, 6 Nov 2000 12:56:24 -0600358_- Hi,

We are looking into accessing our AIX DB2 from the Mainframe DB2. AIX database is 6.1 and the mainframe version is 5.2.

We are using BIGINT for most of the primary keys in the AIX database and the mainframe version 5.2 does not support BIGINT.

Has anyone else run into this problem? Any ideas how to work around this problem? [...] 22354 45 30_POTENTIALLY INCONSISTENT DATA.20_Alvarez, Maximiliano20_MAXIMILIANO@IADB.ORG30_Mon, 6 Nov 2000 14:25:32 -0500638_iso-8859-1 Hi db2 folks,

Has anyone experienced something like this:

DSNI013I - DSNIOST2 POTENTIALLY INCONSISTENT DATA 388 REASON 00C90205 ERQUAL 504A TYPE 00000302 NAME IEFPLACL.DSBBAL .X'0000ACA4' CONNECTION-ID=BATCH CORRELATION-ID=IEFPCPSE LUW-ID=* DSNI013I - DSNIOST2 POTENTIALLY INCONSISTENT DATA 389 REASON 00C90205 ERQUAL 504A TYPE 00000302 NAME IEFPLACL.DSBBAL .X'0000AC9E' CONNECTION-ID=BATCH CORRELATION-ID=IEFPCPSE LUW-ID=* DSNI013I - DSNIOST2 POTENTIALLY INCONSISTENT DATA 390 REASON 00C90205 ERQUAL 504A TYPE 00000303 NAME IEFPLACL.PKDSBBAL.X'000063D0' CONNECTION-ID=BATCH CORRELATION-ID=IEFPCPSE LUW-ID=* [...] 22400 73 34_Re: POTENTIALLY INCONSISTENT DATA.15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Mon, 6 Nov 2000 13:32:01 -0600502_iso-8859-1 I have seen this before. Usually it means that the tablespace was recovered incorrectly. Check to see if any recoveries have been done on the tablespace recently. Perhaps, the index wasn't recovered along with it.

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

"The problem is not that there are problems. The problem is expecting otherwise and thinking that having problems is a problem." - Theodore Rubin [...] 22474 72 34_Re: POTENTIALLY INCONSISTENT DATA.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 6 Nov 2000 13:40:57 -0600446_ISO-8859-1 Maximiliano, The index doesn't match the table. 00C90205 = Explanation: The data manager detected an inconsistent data condition. In this case, a row obtained from an index entry does not point to a valid row in a data page. The error is probably caused by an extra index entry, but it could also result from a table update not being redone when it should have been. Run CHECK to determine whether a rebuild index is appropriate. [...] 22547 33 24_SQLJ and host variables.13_Scott Goodell22_scott.goodell@WCOM.COM30_Mon, 6 Nov 2000 13:58:31 -0600349_us-ascii I am having problems trying to use host variables with SQLJ in a couple of circumstances. Running UDB PDE V6.1 on NT accessing DB2 OS/390 V6.1 via DB2 CONNECT.

1. Trying to use SET CURRENT PACKAGESET = :collid and I get. SQL0104N An unexpected token ":" was found following ":". Expected tokens may include: "END-OF-STATEMENT". [...] 22581 29 16_Solaris DB2 V7.117_Rabindra Senapati21_rsenapati@HOTMAIL.COM28_Mon, 6 Nov 2000 20:02:37 GMT332_- Hi,

We have installed DB2 V7.1 on Solaris 2.7. We are looking a good Reference book which help us to refer DB2/SUN related parameters and work under DB2/SUN servers. We too looking books for DB2 CONNECT EE which is going to configure DB2/VSE, DB2/SUN and DB2/WINDOWS. The proper guidance for DRDA will be appreciated. [...] 22611 24 14_Free DB2 Tools16_Lamb, Ron (CORP)25_Ron.Lamb@CORPORATE.GE.COM30_Mon, 6 Nov 2000 15:29:09 -0500590_iso-8859-1 http://www.xephon.com/updates/db2alpha.htm

> g > ______________________________________ > Ron Lamb > Leader, Customer Database & Applications Center > GCO - Software Engineering > 8700 Governor's Hill Drive > Cincinnati, OH 45249-1363 > Phone: (513) 583-3436; Dial-Comm: 8*330-3436 > Fax: (513) 583-3458; Dial-Comm: 8*330-3458 > >

================================================ 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. 22636 18 12_Re: EDM pool11_Jeff Kalman15_jkalman@CSC.COM30_Mon, 6 Nov 2000 15:46:09 -0500479_us-ascii Hi all, DB2 users are getting a -904 SQLCODE, Reason Code 00C90089. The problem is correctable by increasing the EDM space. The question I have is, why isn't it the EDM pool getting cleaned out afterwards?

TIA Jeff Kalman

================================================ 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. 22655 47 12_Re: EDM pool16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Mon, 6 Nov 2000 15:49:47 -0500335_iso-8859-1 Jeff, What is taking up the space? Unused CTs? DBDS?

If DBDs, you may need to do the old modify-drop-create on some tablespaces to shrink DBDs.

If unused CT (i.e. they should have been freed), you may have the same symptom we reported to IBM. There is an APAR in the works but not yet available for this. [...] 22703 74 19_Re: Help With Query14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM30_Tue, 7 Nov 2000 08:11:11 +1100617_- David,

Well I'm confused, but if there is one thing we love on the listserver, it's a challenge.

First step is to get the SQL correct, then worry about performance later.

Select a.*, b.* from (Select unique_id, attributes, start_date, end_date from table where start_date > current date - 60 days or end_date < current date + 60 days) as a inner join (Select unique_id, attributes, start_date, end_date from table where start_date > current date - 60 days or end_date < current date + 60 days) as b on b.attributes = a.attributes where b.unique_id <> a.unique_id and exists (select 1 from [...] 22778 47 12_Re: EDM pool18_Teegarden, Stephen22_Teegarden@AEGONUSA.COM30_Mon, 6 Nov 2000 15:18:59 -0600550_- How long has it been since you've ran a MODIFY against your databases ?

According to IBM EDM POOL space handling

Implications for Database Design: When you design your databases, be aware that a very large number of objects in your database means a larger DBD for that database. And when you drop objects, storage is not automatically reclaimed in that DBD, which can mean that DB2 must take more locks for the DBD. To reclaim storage in the DBD, use the MODIFY utility, as described in Section 2 of Utility Guide and Reference. [...] 22826 87 49_Fw: Help installing UDB2 6.1 on Red Hat Linux 6.212_Carl Parrish25_carl.parrish@DATASOFT.COM30_Mon, 6 Nov 2000 14:33:19 -0700657_iso-8859-1

Okay here is my problem while installing I'm hanging on installing JavaSupport. the log file at /tmp/db2setup.log says /bin/rpm -ivh /mnt/cdrom/ibm_db2_6.1/db2jdbc61-6.1.0-0.i386.rp Command failed Return code=1

I think I was able to find the cause of the problem by looking at the LinuxDocs for installing. You see I'm using IBM's JDK 1.3.0 where there is no JRE call. The doc I'm looking at says all I have to do is ln -sf /opt/IBMJava2-13/jre/bin/java /opt/IBMJava2-13/jre/bin/jre okay fine no problems but then it also says That the db2cc script calls the jre command with the -nojit argument, whis is not supported in IBM [...] 22914 26 26_load with termination mode17_John Breidenstine31_JBreidenstine@LEGIS.STATE.PA.US30_Mon, 6 Nov 2000 17:03:55 -0500483_iso-8859-1 Hello all,

I am working with DB2 UDB V6.1 on AIX. I have a situation were a LOAD REPLACE that was run by userid DBADM1 fails. This puts the tablespace into a load-pending state. I can bring the tablespace back to a normal state if I run a LOAD TERMINATE. But I am having trouble doing it with another userid with DBADM authority other than DBADM1. Can anyone tell me if the LOAD TERMINATE must be done by the same userid that owned the failing LOAD REPLACE??? [...] 22941 12 12_Re: EDM pool11_Jeff Kalman15_jkalman@CSC.COM30_Mon, 6 Nov 2000 16:01:44 -0500256_us-ascii Eric,

================================================ 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. 22954 170 89_Nonsense enclosed - those with no sense of humour please delete before becoming irritated24_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Mon, 6 Nov 2000 17:10:09 -0800377_us-ascii

Some of you may know my colleague, Roger Midgette, a consultant and instructor on all things DB2 for some years. His daughter Monique is appearing in a brand new Broadway musical called the "Seussical" after the works by the children's author, Dr. Seuss. Below is a snippet of the play's "book". Try reading it aloud and see if it doesn't make you smile. [...] 23125 12 12_Re: EDM pool11_Jeff Kalman15_jkalman@CSC.COM30_Mon, 6 Nov 2000 17:01:10 -0500288_us-ascii PT's are what is taking up the space.

================================================ 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. 23138 50 30_Re: load with termination mode12_Cook, Nicole19_Nicole_Cook@BMC.COM30_Mon, 6 Nov 2000 16:14:39 -0600358_iso-8859-1 You only need sysadm or dbadm authority. Either one of those should have load authority on the table. What is the error message that you are receiving when trying to terminate the load? FYI: Just remember when doing a load terminate, if your load statement was a replace, the table will become empty after issuing the load terminate command. [...] 23189 21 11_DB2 Monitor7_Softron17_softron@LYCOS.COM30_Mon, 6 Nov 2000 17:03:08 -0500636_us-ascii While our OS/390 DB2 Monitor is not free, it's very inexpensive ($20K) for a site license on any size or number of machines. For more inforamtion email: softron@lycos.com or access our web page at:

http://www.321website.com/members/home/data/softron/homepage.html







Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.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. 23211 30 65_Re: ca(platinum log analyzer) not working after DB2V6 conversion.13_Terry Shockey30_Terry.Shockey@OCSE.STATE.AR.US30_Mon, 6 Nov 2000 16:17:14 -0600466_iso-8859-1 thanks for the reply's; contacted platinum and we have a tape on the way.

Muchos Gracias.

-----Original Message----- From: JTonchick@AOL.COM [mailto:JTonchick@AOL.COM] Sent: Monday, November 06, 2000 9:16 AM To: DB2-L@RYCI.COM Subject: Re: ca(platinum log analyzer) not working after DB2V6 conversion.



Did you call CA support to ask if you were at the correct level of Log Analyzer to support DB2 V6 before you migtated? [...] 23242 115 53_Re: Fw: Help installing UDB2 6.1 on Red Hat Linux 6.213_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Tue, 7 Nov 2000 03:50:14 +0530562_us-ascii



hi !! Have a look at the IBM site .. there is a patch reuired of 100 MB which has to be applied before we install the DB2 Vishy















Carl Parrish on 07/11/2000 03:03:19 AM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Viswanathan N/LTITL)





Subject: Fw: Help installing UDB2 6.1 on Red Hat Linux 6.2 [...] 23358 202 53_Re: Fw: Help installing UDB2 6.1 on Red Hat Linux 6.212_Carl Parrish25_carl.parrish@DATASOFT.COM30_Mon, 6 Nov 2000 16:02:47 -0700430_iso-8859-1 Any idea where I can find this patch? So far at the ibm site I only see the following listed as software requirements. Linux kernel 2.0.35 glibc 2.0.7 pdksh (it doesn't say which version but I think I'm running 5.2) and libstdc++ 2.8

I've checked and i have all of these. But I understand that the Linux versions until 7.1 where all betas so maybe I'm just missing something. Any help would be appreciated. [...] 23561 73 12_Re: EDM pool0_31_greg.palgrave@UNISYSWEST.COM.AU30_Tue, 7 Nov 2000 08:29:28 +0800333_us-ascii Hi,

I've seen this when you have a common database that you use for QMF users etc to store their data. You get tables/tablespaces created & dropped, and the DBD can grow to huge sizes. When the EDM pool gets a bit fragmented, you can't load the DBD. Do a DISPLAY DB to find the DBD sizes - you may be surprised. [...] 23635 163 35_Can I create variables in triggers?10_Mike Wiles14_mwiles@UCG.COM30_Mon, 6 Nov 2000 19:57:17 -0500386_iso-8859-1 Hi Folks!

I have a trigger problem that I can't solve...

I would like to insert multiple records into multiple tables from a trigger. The catch is, I would like to generate a unique key (with generate unique()) and have that be in each of the tables that are inserted into.

Here's an example... id is type char(13) bit data, all others are integers [...] 23799 144 65_Re: Migrate table definitions from Subsystem to another subsystem16_Bachi Allamsetty22_BachiA@RENEWAL-IIS.COM30_Mon, 6 Nov 2000 22:24:28 -0500501_- Missy !

But the problem with your suggestion is , may be I am wrong please correct me if I am, both our subsystems are at two different maint. levels.

We are in fact going to make use of suggestion as a contingency plan, for rollback.



Bachi

-----Original Message----- From: Missy Case [mailto:Missy.Case@FIRSTDATACORP.COM] Sent: Monday, November 06, 2000 10:54 AM To: DB2-L@RYCI.COM Subject: Re: Migrate table definitions from Subsystem to another subsystem [...] 23944 53 48_DB2/OS390 certification, what do I have to know?15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Tue, 7 Nov 2000 08:51:28 +0100524_iso-8859-1 Hello all,

Last time at IDUG in Geneva I tried to do DB2/OS390 Certification. Unfortunately I failed. The questions in the test had a lot to do with Data Sharing and the Control Centre. These features are not implemented in our shop (version 5). Therefore I did not have any knowledge available. First; Is there a list of necessary items to be known for this certification? Second; Is there a book available to learn those items, so I'll be prepared for the next exam? I hope someone can help me out? [...] 23998 128 52_Re: DB2/OS390 certification, what do I have to know?0_18_mebert@AMADEUS.NET30_Tue, 7 Nov 2000 10:06:09 +0100497_us-ascii Jaap,

Shame on you (tongue-in-cheek)! Why didn't you simply re-take the test? Actually, I too was surprised about seeing a question like "When running the Stored Procedure Builder App Wizard, what action is done by the top-right-hand button" (or something like this); I certainly have never seen this on our OS/390 (well the test was for V7 and we're V5/V6). Have you looked at the CD they gave out for free at the IBM booth, DB2 UDB Fastpath for Experienced Relational DBAs? [...] 24127 27 52_Re: DB2/OS390 certification, what do I have to know?14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Tue, 7 Nov 2000 10:48:37 +0100670_us-ascii Hi Jaap....

Don't worry, be happy. To be certified doesn't means that you know DB2 better than someone else if you need to know

which button you have to click.

Regards

Max Scarpa ABSOLUTELY non-certified dba, sysprog,dasd manager,mechanic,blacksmith,etc etc BUT Certified paraglider Certified beer taster Certified Cindy Crawford's fan Hiper-Ultra-Mega-Certified Playboy's Centerfolds expert

================================================ 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. 24155 21 20_moving the database.21_Subscribe Db2-L Navid21_navid@DPI2.DPI.NET.IR30_Tue, 7 Nov 2000 14:19:57 +0330500_US-ASCII Hi there! I'm very glad to join your mailing list.

I want to move a whole database (including its stored procedures specially) from an NT machine to another NT or OS/390 machine. Does anybody now how can I do this?

Best Regards! Navid.

================================================ 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. 24177 40 16_set db2-l nomail14_Grainger, Phil20_Phil.Grainger@CA.COM30_Tue, 7 Nov 2000 11:29:13 -000027_iso-8859-1 set db2-l nomail 24218 139 19_Re: Help With Query16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM30_Tue, 7 Nov 2000 16:58:10 +0530535_iso-8859-1 Hi David, Really confused with the question but will ask some more.You have got current date which is the starting point and from that current date you are going to scan 60 backward and 60 forward and it seems from the Terry's solution that the satisfying rows will have its start date and end date which will be used for further check and again scan 60+ and 60- from that point.As you mentioned "until you get to a range greater than 60 days". The question which i need to ask is range of 60 days from which date ? Is [...] 24358 55 13_Re set nomail14_Grainger, Phil20_Phil.Grainger@CA.COM30_Tue, 7 Nov 2000 11:38:26 -0000198_iso-8859-1 Sorry folks

I know I should have eMailed listserv@ryci.com, but my fingers didn't!!

Phil G

PS Any of you folks that are going to Asia Pacific IDUG, come and say "Hi"! 24414 39 24_Re: moving the database.10_Alan Johns26_AlanJ@PRINCETONSOFTECH.COM30_Tue, 7 Nov 2000 06:53:23 -0500400_ISO-8859-1 Hi Navid. When you say moving the whole database, are you talking about just the object definitions or the data as well. Also, would you want to move all the data or just a relationally intact subset?

Alan

-----Original Message----- From: Subscribe Db2-L Navid [mailto:navid@DPI2.DPI.NET.IR] Sent: 07 November 2000 10:50 To: DB2-L@RYCI.COM Subject: moving the database. [...] 24454 210 52_Re: Date range processing - an idea to pass your way14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM30_Tue, 7 Nov 2000 22:59:31 +1100343_iso-8859-1 Larry,

Can I please clarify something: the reduction from 93 minutes CPU to 1.5 minutes CPU could not be due to index screening predicates becoming index matching (otherwise IBM better look at the performance of index screening in V6); rather the increase in matchcols has resulted in a better access path being chosen. [...] 24665 16 16_MOVING DATABASE.21_Subscribe Db2-L Navid21_navid@DPI2.DPI.NET.IR30_Tue, 7 Nov 2000 16:01:38 +0330346_US-ASCII Hi Alan, I realy mean whole database (with it's data and ...). Thanks for your response. Navid.

================================================ 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. 24682 59 24_Re: moving the database.0_22_rmadan@CYVEILLANCE.COM30_Tue, 7 Nov 2000 07:37:32 -0500582_iso-8859-1 If you are moving from NT to NT you need to do a redirected restore. If you plan on moving to another operating system then you would have to do data unloads(exports) and reloads(imports)

> -----Original Message----- > From: Alan Johns [mailto:AlanJ@PRINCETONSOFTECH.COM] > Sent: Tuesday, November 07, 2000 6:53 AM > To: DB2-L@RYCI.COM > Subject: Re: moving the database. > > > Hi Navid. > When you say moving the whole database, are you talking about just the > object definitions or the data as well. Also, would you want > to move all the > data or just a [...] 24742 58 33_Re: moving the database. Addendum0_22_rmadan@CYVEILLANCE.COM30_Tue, 7 Nov 2000 07:39:53 -0500587_iso-8859-1 The stored procedures will have to be moved by themselves and rebound. You do not state what flavor of UDB you have.

> -----Original Message----- > From: Alan Johns [mailto:AlanJ@PRINCETONSOFTECH.COM] > Sent: Tuesday, November 07, 2000 6:53 AM > To: DB2-L@RYCI.COM > Subject: Re: moving the database. > > > Hi Navid. > When you say moving the whole database, are you talking about just the > object definitions or the data as well. Also, would you want > to move all the > data or just a relationally intact subset? > > Alan > > -----Original Message----- > From: [...] 24801 144 33_Balt./Wash. DB2 Users' Group Mtg.17_Valerie J Traurig18_valeriet6@JUNO.COM30_Tue, 7 Nov 2000 08:06:57 -0500750_- Baltimore/Washington DB2 Users' Group

Meeting Date: Wednesday, December 13, 2000 Location: Sheraton Columbia Inn 10207 Wincopin Circle Columbia, MD (410) 730-3900

Meeting Schedule: 8:30 - 9:00 Registration

9:00 - 10:15 Making Life Easier for DB2 Adminstrators and Programmers: DB2 Control Center, Visual Explain, and DB2 Stored Procedure Builder

Jorge Quintana, IBM Corporation

With the complexity of today's application requirements increasing at internet speed, building and administering applications can be equally complex. This presentation focuses on a few key data management tools that can make life easier for DB2 administrators and programmers. The DB2 UDB package includes the DB2 Control Center, [...] 24946 52 28_Re: SQLJ and host variables.27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Tue, 7 Nov 2000 08:18:20 -0500569_- I don't know about number 1. For number 2, I think the problem is you must pad it out with %. For example 'ABC% ' (which is ABC% followed by 4 spaces) requires the spaces at the end of the column. ABC%%%%% will look for ABC followed by anything.

Tina

> -----Original Message----- > From: Scott Goodell [SMTP:scott.goodell@WCOM.COM] > Sent: November 06, 2000 2:59 PM > To: DB2-L@RYCI.COM > Subject: SQLJ and host variables. > > I am having problems trying to use host variables with SQLJ in a couple of > circumstances. > Running UDB PDE V6.1 on NT [...] 24999 68 62_how to search the documents of db2 database discussion list ?!11_Emrah GUVEN28_emrah.guven@PAMUKBANK.COM.TR30_Tue, 7 Nov 2000 15:49:13 +0200241_ISO-8859-9

hi colleagues,

i want to search the library(old documents) of the list for a specific topic ,

for example "disadv.(problems) of DB2 V7"

would somebody guide me please ...

regards

mr guven 25068 97 66_Re: how to search the documents of db2 database discussion list ?!0_18_mebert@AMADEUS.NET30_Tue, 7 Nov 2000 15:03:16 +01001662_us-ascii Use the web site http://www.jupiter.ryci.com/archives/db2-l.html; it's quite self-explanatory and easy to use.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany







From: Emrah GUVEN on 07/11/2000 13:49 GMT

Please respond to DB2 Data Base Discussion List









|---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |To: | |---------> >---------------------------------------------------------------------------> |DB2-L@RYCI.COM | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> |cc: | |---------> >---------------------------------------------------------------------------> | (bcc: Michael Ebert/MUC/AMADEUS) | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |Subject: | [...] 25166 104 52_How to export asc text file without delimited format10_jack zhang20_trade168@HOTMAIL.COM28_Tue, 7 Nov 2000 14:07:59 GMT327_- Hey all: I have tried to export a select table to a file using undelimited format, such as: export to myfile.asc of IXF, but it give me a bunches of irregular format, could anybody give me hints how i can export a selected table to a asc text file without any delimitation ,such as " or ,. Thank you for your kind help. [...] 25271 105 75_How to export a selected table using asc text file without delimited format10_jack zhang20_trade168@HOTMAIL.COM28_Tue, 7 Nov 2000 14:09:11 GMT368_- Hey all: I have tried to export a select table to a file using undelimited format, such as: export to myfile.asc of IXF, but it give me a bunches of irregular format, could anybody give me hints how i can export a selected table to a asc text file without any delimitation(Such as " or ,) but still has the standard column format. Thank you for your kind help. [...] 25377 63 27_TRIDEX DECEMBER RUG MEETING14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 7 Nov 2000 09:38:05 -0500677_us-ascii TRIDEX 12/7/2000 AGENDA (http://www.db2tridex.org/)

8:30 - 9:00 Morning Refreshments/ Gerri's Corner 9:00 - 10:00 Sheryl M. Larsen, Sheryl M. Larsen, Inc. Leading Edge SL 10:15 - 11:15 Sean Lee, DB2 Specialist, IBM Design Center for e-Transaction Processing DB2 UDB for OS/390 Java Stored Procedures 11:20 - 12:20 Konstantin Tadnev, UPS Multi-Terabyte Database: A repositioning Story 12:20 - 1:00 Free Lunch will be Provided 1:00 - 2:15 Deb Jenson, Director of DB2 Development, Quest Software DB2 UDB SQL Processing Roadmap IBM Corporation Beyond the Utilities - DB2 UDB OS/390 Database Tools from IBM 2:30 - 3:30 Dr. Jerry Rosenbaum, Principal Enterprise [...] 25441 94 52_Re: DB2/OS390 certification, what do I have to know?11_Kwan, James18_James_Kwan@BMC.COM30_Tue, 7 Nov 2000 09:13:41 -0600557_iso-8859-1 Jaap,

Before you can be certified, you need to pass the fundamental one (509/512) first which in my opinion has little connection to OS390. In order to pass this test, you need to know some basics about the UDB. I brought a book 'DB2 UNIVERSAL DATABASE V6.1 for UNIX, Windows, and OS/2' which is designed for the test. If you have a good memory, you can memorize the information in this book and you can pass the test. If you are not so good in memory, you can download a trial version of UDB personal edition and follow the exercise [...] 25536 31 12_Re: EDM pool16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Tue, 7 Nov 2000 10:17:31 -0500612_iso-8859-1 Do you by any chance have an 'umbrella' CICS PLAN with RELEASE DEALLOCATE?

eric pearson ITO DB2 support Eric.Pearson@nscorp.com



-----Original Message----- From: Jeff Kalman [mailto:jkalman@CSC.COM] Sent: Monday, November 06, 2000 5:01 PM To: DB2-L@RYCI.COM Subject: Re: EDM pool



PT's are what is taking up the space.

================================================ 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. [...] 25568 11 34_Re: Migration to DB2 V6 and REBIND15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Tue, 7 Nov 2000 09:20:43 -0600323_- No, we never bind all our packages, if we migrate from one release to the next.

================================================ 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. 25580 18 70_Would IBM try to answer if it is not answered by members in this list.15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Tue, 7 Nov 2000 10:35:28 -0500462_iso-8859-1 I have posted some questions regarding DB2 stored procedure calling from SQLserver procedure. I have not seen any reply. So I am just wondering whether IBM will try to answer this.



Thanks...sibi

================================================ 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. 25599 63 39_Re: Can I create variables in triggers?15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Tue, 7 Nov 2000 09:38:42 -0600548_- On Mon, 6 Nov 2000 19:57:17 -0500, Mike Wiles wrote:

>Hi Folks! > >I have a trigger problem that I can't solve... > >I would like to insert multiple records into multiple tables from a trigger. >The catch is, I would like to generate a unique key (with generate unique ()) >and have that be in each of the tables that are inserted into. > >Here's an example... id is type char(13) bit data, all others are integers > >t1 has two columns: id and t1f1 >t2 has three columns: id, t2f1 and t2f2 >t3 has four columns: id, [...] 25663 90 34_Re: Migration to DB2 V6 and REBIND16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Tue, 7 Nov 2000 15:35:51 -0000379_- We used to do a REBIND PACKAGE(*) once I was a DBA. Due to the growth of DB2 and the applications, this might be more and more difficult to accomplish. An other issue to think about going to V6 is - that IF you REBIND all your packages and plans - and you are unlucky to have OLD DBRM's containing hostvariables without COLON - these packages become invalid and unusable. [...] 25754 30 34_Re: Migration to DB2 V6 and REBIND11_Bloss, Alan23_alan.bloss@CAREMARK.COM30_Tue, 7 Nov 2000 09:57:54 -0600374_iso-8859-1 If you migrate forward, yeah. If you go back to V5, you gotta. And if a package depends on new optimizer procedures, rebind fails, and you have to bind replace.

-----Original Message----- From: Walter Janissen [mailto:walter.janissen@VICTORIA.DE] Sent: Tuesday, November 07, 2000 9:21 AM To: DB2-L@RYCI.COM Subject: Re: Migration to DB2 V6 and REBIND [...] 25785 121 34_Re: Migration to DB2 V6 and REBIND16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Tue, 7 Nov 2000 10:54:48 -0500346_iso-8859-1 In all the various shops I've worked, we *never* did a REBIND PACKAGE(*). We did only the ones which fit the criteria described in the various PTFs new to the new version. And that was very limited since with thousands of packages the Systems and Database staff tends to know the operational nature of only the most visible ones. [...] 25907 135 32_DataJoiner and long column names12_Jacob Ganzel19_jacobg@SEMECH.CO.IL30_Tue, 7 Nov 2000 18:00:49 +0200365_x-user-defined Hello.

We are trying to implement JRE - Datajoiner replication option where source data is Oracle 8 and the target is UDB NT 6.1. DataJoiner 2.1.1 Fixpack#7

Some of the table names or column names in Oracle are longer then 18 bytes. Target tables must be defined exactly as the source (Porting the application from Oracle to UDB). [...] 26043 79 39_Re: Can I create variables in triggers?10_Mike Wiles14_mwiles@UCG.COM30_Tue, 7 Nov 2000 11:44:38 -0500662_iso-8859-1 Thanks Walter! I'll check that out. Does anyone have any idea about this?

-----Original Message----- From: Walter Janissen [mailto:walter.janissen@VICTORIA.DE] Sent: Tuesday, November 07, 2000 10:39 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Can I create variables in triggers?



On Mon, 6 Nov 2000 19:57:17 -0500, Mike Wiles wrote:

>Hi Folks! > >I have a trigger problem that I can't solve... > >I would like to insert multiple records into multiple tables from a trigger. >The catch is, I would like to generate a unique key (with generate unique ()) >and have that be in each of the tables that are [...] 26123 21 74_Re: Would IBM try to answer if it is not answered by members in this list.14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 7 Nov 2000 12:23:09 -0500328_us-ascii Sibi, Many IBM personnel from Silicon Valley and Toronto monitor the list, but there is no guarantee of a reply. Sometimes you get one, sometimes you don't. Having support for the product is the way to go if you can't get help here or elsewhere. You might also try your local IBM DB2 rep for your question. --Phil [...] 26145 150 35_Re: db2set return code -10 resolved12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 7 Nov 2000 09:41:02 -0800527_us-ascii That did it. I had been using the instance id, and didn't even think about the admin server...duh. The order of the parms didn't seem to matter in my case. Many thanks. Tim --- "Travis, John" wrote: > Tim, > I found that I also needed to be logged in > using the Admin Server id > to be able to change the DB2SYSTEm variable. It > works for me anyway as I > have just had to change the setting for a system > moved onto a new server. > > John Travis > > -----Original Message----- > [...] 26296 59 34_Re: Migration to DB2 V6 and REBIND12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 7 Nov 2000 10:11:14 -0800568_us-ascii I believe there is still a parameter in ZPARM which will automatically REBIND any plans or packages that have been marked invalid, and it does this as they are attempted to be executed. This spreads out the time that REBINDS are being done and keeps you from taking the performance hit of doing a REBIND PACKAGE(*) which will tend to tie up the catalog for some period of time. And only packages that have been marked invalid are rebound. An additional plus, is that once you have this parameter set for a while, (sorry, can't remember the name, and all [...] 26356 31 65_Rebuild with sortkeys & Statistics in Version 6 Any Experiences ?11_Sinha, Amit19_Sinha.Amit@MBCO.COM30_Tue, 7 Nov 2000 12:03:17 -0600422_iso-8859-1 We just moved to version 6 of DB2 on OS/390 and was so much used to rebuilding the indexes without the sortkeys and statistics. Anyone out there has any experience of using both sortkeys and statisics by which the performance is drastically improves.

Right now we dont't use WORKDDN to improve performance by eliminating I/O for sort. Will sortkeys will even then be useful. The JCL looks just like [...] 26388 25 44_Sizing DB2 Connect E-Buisness Gateway Server14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 7 Nov 2000 13:47:30 -0500563_us-ascii Has anyone gone through a sizing exercise and used SPecWeb96 as the criteria? Since this deals mostly with http file gets I am looking for some criteria or methodology that deals with ODBC/JDBC calls as most activity will be accessing DB2 for OS/390 via DB2 Connect EE. I am looking at an AIX platform to serve as the DB2 Connect Gateway and that is what I am sizing. I know the memory requirements for the DB2Connect agents, etc, but need a methodology that takes the # of ODBC/JDBC calls per second, or something like that and arrives at a sizing [...] 26414 67 34_Re: Migration to DB2 V6 and REBIND13_John Arbogast19_arbo@CP-DEMO.CP.NET30_Tue, 7 Nov 2000 10:51:07 -0800370_- Tim is correct. We use the auto-rebind feature as well. A word of caution. Some of our access paths changed with the auto rebind, and some of our vendor tools needed installation jobs rerun after the auto bind. Using the SQL out of the manual, you can tell which plans/pkgs will get marked invalid. Might want to run the SQL and take a close look at the results. [...] 26482 16 29_sequence number in QMF report9_Rama Kypa23_RKYPA@ISETS.STATE.IN.US30_Tue, 7 Nov 2000 14:25:48 -0500371_us-ascii Hi all Please let me know how to get sequence number in the QMF (v3 r1.1) report along the selected fields. Thanks, Kypa

================================================ 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. 26499 38 33_Re: sequence number in QMF report15_Rameswara Pavan24_RPAVAN@ISETS.STATE.IN.US30_Tue, 7 Nov 2000 14:38:58 -0500475_us-ascii Hi, What if we use a first column as 1 in selection list and using CSUM option in the report? Example :-

Select 1, column1, column2 from your table;

Thanks Pavan



-----Original Message----- From: Rama Kypa Sent: Tuesday, November 07, 2000 2:26 PM To: DB2-L@RYCI.COM Subject: sequence number in QMF report

Hi all Please let me know how to get sequence number in the QMF (v3 r1.1) report along the selected fields. Thanks, Kypa [...] 26538 53 53_Re: How to set Control Center id/password on NT list.12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 7 Nov 2000 11:53:45 -0800331_us-ascii I forget who asked, but here's the secret handshake for setting the Control Center id and password. If you don't know about this, changing your forgotten/broken password on Control Center can seem like a catch-22 situation, because you need to logon to it, to be able to change it. And it's easier than a re-install. [...] 26592 72 78_Current Timestamp in STored Procs :: was > Can I create variables in triggers?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 7 Nov 2000 15:19:00 -0500476_iso-8859-1 Guten Tag Walter,

I have encountered interesting results investigating the question posed by your message. As you state, >The manual says: the value of the special register >CURRENT TIMESTAMP is inherited.

I'm not sure to which manual you are referring. However, in the v6 Application Programming and SQL Guide, http://www.s390.ibm.com:80/bookmgr-cgi/bookmgr.exe/BOOKS/DSNAP0G2 in section *7.2.4.6 Using special registers in a stored procedure*, [...] 26665 35 33_Re: sequence number in QMF report11_Matt Kelley18_mgk333@HOTMAIL.COM28_Tue, 7 Nov 2000 14:50:45 CST751_- The &ROW variable does exactly this.

>-----Original Message----- >From: Rama Kypa [mailto:RKYPA@ISETS.STATE.IN.US] >Sent: Tuesday, November 07, 2000 1:26 PM >To: DB2-L@RYCI.COM >Subject: sequence number in QMF report > > >Hi all >Please let me know how to get sequence number in the QMF (v3 r1.1) >report along the selected fields. >Thanks, Kypa > >================================================ >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. > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. [...] 26701 77 41_How to load file into a new created table10_jack zhang20_trade168@HOTMAIL.COM28_Tue, 7 Nov 2000 20:51:38 GMT607_- Hey there: I have created a new table,and want to load file into this table, can anybody tell me how to do it, i have tried use the following the commands: import C:\myfile into my table, but it does not work Thanks Jakc

>From: tim malamphy >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: How to set Control Center id/password on NT list. >Date: Tue, 7 Nov 2000 11:53:45 -0800 > >I forget who asked, but here's the secret handshake >for setting the Control Center id and password. If >you don't know about this, changing your [...] 26779 97 45_Re: How to load file into a new created table11_Kwan, James18_James_Kwan@BMC.COM30_Tue, 7 Nov 2000 14:56:57 -0600572_iso-8859-1 Jack,

The syntax should be IMPORT FROM ... You can use control center to generate the command.



James Kwan

-----Original Message----- From: jack zhang [mailto:trade168@HOTMAIL.COM] Sent: Tuesday, November 07, 2000 2:52 PM To: DB2-L@RYCI.COM Subject: How to load file into a new created table



Hey there: I have created a new table,and want to load file into this table, can anybody tell me how to do it, i have tried use the following the commands: import C:\myfile into my table, but it does not work Thanks Jakc [...] 26877 74 53_Re: How to set Control Center id/password on NT list.16_Swinski, Kenneth23_KSwinski@MASSMUTUAL.COM30_Tue, 7 Nov 2000 16:15:48 -0500402_us-ascii I sent the original question. Thanks, I like your solution a lot better than ours. We worked around the problem by doing the following: "Start Menu, Programs, Administrative Tools, User Manager, and then double-clicking on Administrators". We created a new ID, logged on to NT with it, and deleted and re-added his original ID, and now he can logon to the Control Center without problem. [...] 26952 160 52_Re: Date range processing - an idea to pass your way0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Tue, 7 Nov 2000 15:33:27 -0600564_us-ascii You are correct that the access path difference for this particular case did not simply change index screening into index matching.

You have stated very well my original purpose for putting this idea on the list server. I know that I appreciate various choices for recoding SQL in a logically equivalent manner. Many times, when I have seen that the optimizer has made a bad choice, there is some other way of writing the SQL that allows the optimizer to do things correctly. This is simply one of many techniques for allowing this to happen. [...] 27113 39 21_Reorg unload external13_Penny Treptow21_Penny.Treptow@UAL.COM30_Tue, 7 Nov 2000 13:23:39 -0600668_- The following posting is for a co-worker

I'm receiving the following error message when trying to use the UNLOAD EXTERNAL FROM TABLE option on the IBM Reorg (running on OS390/DB2V6):

DSNU005I DSNUGPRS - REORG TABLESPACE database.tablespace DSNU005I DSNUGPRS - LOG NO DSNU005I DSNUGPRS - SORTDATA DSNU005I DSNUGPRS - SHRLEVEL NONE DSNU005I DSNUGPRS - UNLOAD EXTERNAL DSNU005I DSNUGPRS - PUNCHDDN (SYSPUNCH) DSNU005I DSNUGPRS - FROM TABLE creator.MY_TABLE WHEN MY_FILE_NO < 511 DSNU049I DSNUGPRS - INVALID OPERAND '511' FOR KEYWORD 'FROM' DSNU005I DSNUGPRS - UNLDDN (SYSREC00) DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 [...] 27153 33 53_DSNP005I @ DSNPRMVV - COULD NOT REMOVE EXCESS VOLUMES12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM28_Tue, 7 Nov 2000 21:59:44 GMT591_- DSNP009I @ THE FOLLOWING ERROR MESSAGES WERE RECEIVED FOR ALTER REMOVEVOLUMES ON DB2D.DSNDBD.DSCM040.XCM424PC.I0001.A001 IDC3012I ENTRY DB2D.DSNDBD.DSCM040.XCM424PC.I0001.A001 NOT FOUND IDC3009I ** VSAM CATALOG RETURN CODE IS 8 - REASON CODE IS IGG0CLEI-20 IDC0532I **ENTRY DB2D.DSNDBD.DSCM040.XCM424PC.I0001.A001 NOT ALTERED

DSNP010I @ END OF MESSAGES. CONNECTION-ID=BATCH CORRELATION-ID=APB0710 LUW-ID=* DSNP005I @ DSNPRMVV - COULD NOT REMOVE EXCESS VOLUMES FROM CANDIDATE LIST OF DB2D.DSNDBD.DSCM040.XCM424PC.I0001.A001 CONNECTION-ID=BATCH, CORRELATION-ID=APB0710, LUW-ID=* [...] 27187 52 53_DSNP005I @ DSNPRMVV - COULD NOT REMOVE EXCESS VOLUMES12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM28_Tue, 7 Nov 2000 22:08:56 GMT565_- Hi folks:

Since I altered my STOGROUP definition from VOLUMES(DBA700,DBA701,DBA702) to VOLUMES ('*','*','*') to allows SMS control the dataset allocations, I started to receive messages like you can see below:



DSNP009I @ THE FOLLOWING ERROR MESSAGES WERE RECEIVED FOR ALTER REMOVEVOLUMES ON DB2D.DSNDBD.DSCM040.XCM424PC.I0001.A001 IDC3012I ENTRY DB2D.DSNDBD.DSCM040.XCM424PC.I0001.A001 NOT FOUND IDC3009I ** VSAM CATALOG RETURN CODE IS 8 - REASON CODE IS IGG0CLEI-20 IDC0532I **ENTRY DB2D.DSNDBD.DSCM040.XCM424PC.I0001.A001 NOT ALTERED [...] 27240 62 34_Re: POTENTIALLY INCONSISTENT DATA.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Tue, 7 Nov 2000 14:10:34 -0800944_iso-8859-1 If your running v6.1 and using a trigger you might look at apar/ptf PQ42007/UQ47924

cliff:-)

-----Original Message----- From: Alvarez, Maximiliano [mailto:MAXIMILIANO@IADB.ORG] Sent: Monday, November 06, 2000 11:26 AM To: DB2-L@RYCI.COM Subject: POTENTIALLY INCONSISTENT DATA.



Hi db2 folks,

Has anyone experienced something like this:

DSNI013I - DSNIOST2 POTENTIALLY INCONSISTENT DATA 388 REASON 00C90205 ERQUAL 504A TYPE 00000302 NAME IEFPLACL.DSBBAL .X'0000ACA4' CONNECTION-ID=BATCH CORRELATION-ID=IEFPCPSE LUW-ID=* DSNI013I - DSNIOST2 POTENTIALLY INCONSISTENT DATA 389 REASON 00C90205 ERQUAL 504A TYPE 00000302 NAME IEFPLACL.DSBBAL .X'0000AC9E' CONNECTION-ID=BATCH CORRELATION-ID=IEFPCPSE LUW-ID=* DSNI013I - DSNIOST2 POTENTIALLY INCONSISTENT DATA 390 REASON 00C90205 ERQUAL 504A TYPE 00000303 NAME IEFPLACL.PKDSBBAL.X'000063D0' CONNECTION-ID=BATCH CORRELATION-ID=IEFPCPSE LUW-ID=* [...] 27303 59 25_Re: Reorg unload external16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Tue, 7 Nov 2000 17:05:01 -0500524_iso-8859-1 Have you tried it with the WHEN clause inside parentheses?

eric pearson ITO DB2 support Eric.Pearson@nscorp.com



-----Original Message----- From: Penny Treptow [mailto:Penny.Treptow@UAL.COM] Sent: Tuesday, November 07, 2000 2:24 PM To: DB2-L@RYCI.COM Subject: Reorg unload external



The following posting is for a co-worker

I'm receiving the following error message when trying to use the UNLOAD EXTERNAL FROM TABLE option on the IBM Reorg (running on OS390/DB2V6): [...] 27363 74 57_Re: DSNP005I @ DSNPRMVV - COULD NOT REMOVE EXCESS VOLUMES16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Tue, 7 Nov 2000 17:07:32 -0500475_iso-8859-1 Maybe this should be VOLUMES('*') not VOLUMES ('*','*','*')? Then the next thing which drives DELETE and DEFINE - LOAD REPLACE, REORG, RECOVER - will rebuild the candidate volume list.

eric pearson ITO DB2 support Eric.Pearson@nscorp.com



-----Original Message----- From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] Sent: Tuesday, November 07, 2000 5:09 PM To: DB2-L@RYCI.COM Subject: DSNP005I @ DSNPRMVV - COULD NOT REMOVE EXCESS VOLUMES [...] 27438 23 21_Ex PLATINUM Customers15_Jessee, Scott L19_Scott.Jessee@CA.COM30_Tue, 7 Nov 2000 17:20:16 -0500590_iso-8859-1 At the risk of breaking the marketing rule, there have been a few issues posted recently on this list server regarding product support for the former PLATINUM, now Computer Associates, DB2 products.

I wanted to assure all of our customers that are participating on this list server group that our support organization is alive and well and eager to assist you in any way they can. I also wanted to make sure that everyone knows how to get to these highly talented people. The main support number for the DB2 products is the same it has been since 1990: 800-833-7528. [...] 27462 68 0_18_Mulligan, Thomas J30_Thomas.Mulligan@PHL.BOEING.COM30_Tue, 7 Nov 2000 17:29:06 -0500471_iso-8859-1 DELAWARE VALLEY DB2 USERS GROUP

___________________________________________ MEETING DATE: Friday, November 10th, 2000 LOCATION: HOLIDAY INN PHILADELPHIA AIRPORT STARTING TIME: 9:00 AM REGISTRATION: 8:30 AM - 9:00 AM COST: ADVANCE REGISTRATION: MEMBERS $30, NON-MEMBERS $40 WALK IN REGISTRATION: MEMBERS $50, NON-MEMBERS $60 ____________________________________________ AGENDA

09:00 - 09:15 Opening Remarks Rachel Murawski, Chairperson DVDUG [...] 27531 27 28_Tablespace in Read Only Mode11_Bob Trombly19_Bob_Trombly@GAP.COM30_Tue, 7 Nov 2000 15:50:40 -0800449_us-ascii You wrote the following:

Date: Mon, 6 Nov 2000 13:19:17 +0000 From: Joan Green Subject: OS/390 V5 - Table in Read Only Mode?

Hi List,

Quick and easy question - how can I tell if a table is in Read-only mode?

TIA

J.Green

The answer to that is to do a DISPLAY DATABASE(dbname) SPACENAM(tsname). If the tablespace is in read only status the displayed status will be 'RO' [...] 27559 29 19_Re: Help With Query11_Bob Trombly19_Bob_Trombly@GAP.COM30_Tue, 7 Nov 2000 15:47:11 -0800479_us-ascii You'll have to forgive me if I do not answer directly to the e-mail here but I get the daily summary of posts to this list server. However, if I understand the question correctly I think the query might go something like this:

SELECT A.ATTRIBUTES, A.UNIQUE_ID FROM TABLE A WHERE ATTRIBUTES IN (SELECT ATTRIBUTES FROM TABLE B WHERE B.UNIQUE_ID = 'host variable' AND DAYS(A.START_DATE) >= DAYS(B.START_DATE) - 60 AND DAYS(A.END_DATE) <= DAYS(B.END_DATE) + 60) [...] 27589 47 0_11_Bob Trombly19_Bob_Trombly@GAP.COM30_Tue, 7 Nov 2000 16:03:36 -0800512_us-ascii David - You wrote this: Wondering if anyone can help me figure this one out. Given a unique id and = its attributes, including its start and end dates find rows that have same = attributes within a 60 +/- day range,(this is where it gets difficult) if = one is found look back or forward another 60 days until you get to a range = greater than 60 days. One of the ideas I had was to find all rows that = qualify without using date processing, then look forward from my given end = date to the next [...] 27637 93 56_Re: How to export asc text file without delimited format0_31_greg.palgrave@UNISYSWEST.COM.AU30_Wed, 8 Nov 2000 08:53:06 +0800313_us-ascii Jack,

I'm assuming this is UDB on NT/unix platform?

The EXPORT command unfortunately does not give you the option to use a blank delimiter as far as I can see. All I can suggest is :

1. Create a file with the sql for the unload (call it test.sql in this example). e.g. contains [...] 27731 114 83_Re: Current Timestamp in STored Procs :: was > Can I crea te variables in triggers?14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 8 Nov 2000 12:34:26 +1100374_iso-8859-1 David,

1) since the original post referred to "generate_unique", perhaps its not a DB2 OS/390 environment.

2) since the the trigger did not generate the calculation of a CURRENT TIMESTAMP, perhaps it doesn't have one. Is the result different if the trigger does calculate one before calling the SP? Or does the outer-most SQL have to have one? [...] 27846 124 39_Re: Can I create variables in triggers?14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 8 Nov 2000 12:34:48 +1100482_iso-8859-1 Mike

If you get really desperate perhaps you could have a 'special' table which contains all the values you want to insert into other tables (including id). Then - the high-level trigger just generates an insert into the special table, using generate_unique to populate id - an insert trigger on the special table inserts appropriate rows into other tables. (I presume that, like DB2 for OS/390, DB2 for non-OS/390 trigger actions can invoke other triggers.) [...] 27971 219 23_Long Service Waits Time11_Roland Chua18_rolandchua@SGX.COM30_Wed, 8 Nov 2000 11:17:22 +0800643_us-ascii Hi list,,

I had a CICS program which issue only select statements and from the Omegamon accounting detail report it showed that the In-DB2 time is 0.576131 and most of the time spend in Service Waits (0.465974).

From the documenation that I had, Service wait time include the following: Description What I had found out - open/close dataset ( The datasets were defined with CLOSE=NO) -syslgrng update (The program had select statements only) -HSM recall dataset (The datasets were not migrated) -DataSpace Manager Services (The datasets did not had any new extend) - define dataset, extend dataset, delete dataset. [...] 28191 26 23_Who -term'd my utility?15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 8 Nov 2000 15:23:33 +1100561_- Colleagues, Quick question: how can I find out which friend of society -TERMinated my utility? Only a runstats, so no real harm done. Job is peppered with 'Utility job terminated by term command' messages, which could mean it was attempted to be terminated several times. There's nothing in the *MSTR - big surprise - and nothing in the Syslog, so whoever it was didn't use the console. We don't have CA's Detector (did I hear a cheer go up?) so I can't use that. Any clues? I'm walking around with a big stick, speaking softly at the moment. Can't wait [...] 28218 83 27_Re: Who -term'd my utility?0_31_greg.palgrave@UNISYSWEST.COM.AU30_Wed, 8 Nov 2000 12:57:05 +0800313_us-ascii Raymond,

Try to narrow down your search - who in your organisation has the authority to -TERM your utility? If it runs under a DBA group logon, could a fellow DBA have issued a TERM UTIL(*) without checking what was running? If so, you may require a bigger stick.... :)

Happy hunting, [...] 28302 18 12_Linux on Db213_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Wed, 8 Nov 2000 10:31:43 +0530258_us-ascii hi !! We are running Linux on the mainframe !! kernel V 2.14 !! Can anybody say when we will have a DB2 for Linux on S/390 ... ? The Linux has got some 64 MB of real memory .. and still runs pretty fast. Its run on a multiprise 2000 machine !! [...] 28321 47 27_Re: Who -term'd my utility?15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 8 Nov 2000 16:02:42 +1100331_- Hi Greg,

Thanks for the comments. Yes, I thought about looking at who might be able to do this but, as you only need DBADM on the involved database to term a utility, it's quite a large list of potential killers in our case. And you'll be pleased to know I have a wide selection of sticks, depending on the 'target'. [...] 28369 14 52_Re: DB2/OS390 certification, what do I have to know?8_Bob Abad16_BobRabad@AOL.COM28_Wed, 8 Nov 2000 00:07:09 EST353_ISO-8859-1 Sorry for my current ignorance, is the DB2 OS/390 V7 Certification exam officially available now ???

================================================ 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. 28384 64 27_Re: Who -term'd my utility?13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU30_Wed, 8 Nov 2000 16:16:44 +1100635_iso-8859-1 Raymond,

Of the list of potential killers , who was logged on at the time ?

Shaun

-----Original Message----- From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Wednesday, 8 November 2000 16:03 To: DB2-L@RYCI.COM Subject: Re: Who -term'd my utility?

Hi Greg,

Thanks for the comments. Yes, I thought about looking at who might be able to do this but, as you only need DBADM on the involved database to term a utility, it's quite a large list of potential killers in our case. And you'll be pleased to know I have a wide selection of sticks, depending on the 'target'. [...]