1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2000, week 4 2 87 35_Can Anybody Help me withthis please21_Yashas Mallawarachchi14_yasas@SLIIT.LK31_Sat, 22 Jul 2000 13:56:33 +0600528_iso-8859-1 Hi All,

Our Institution owns an IBM AS/400 server which is dedicated for Domino. It uses OS/400 V4R4 as the operating system. SB2 Universal database is also installed in it. We are accessing the AS/400 using AS/400 Client Access express for V4R4.



For a a project we are currently involved in, we recommended using an IBM AS/400 server to be used as the central database/Application Server for their MIS. The Application Software is a cleint server based and it uses DB2 Universal database. [...] 90 116 39_Re: Can Anybody Help me withthis please14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 22 Jul 2000 19:26:50 +1000582_iso-8859-1 Yashas

First off, I know nothing about DB2 on AS/400s except by inference from other platforms.

However, one of the quirks of other platforms is that I have seen syntax errors reported at a token before the actual error (eg "ALTER TABLE FRED DROP FOREIGN KEY PSID" on OS/390's reports "SQLCODE = -104, ERROR: ILLEGAL SYMBOL "FOREIGN" ..." ). This is a round-about way of saying that perhaps there really is a syntax error but it is somewhere else. Some-one who can see the _actual_ SQL might be able to help you. I suppose you could do worse than post [...] 207 116 28_Re: Help requested for query14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 22 Jul 2000 19:35:29 +1000384_iso-8859-1 SELECT A.PRB_NO, ACOUNT + BCOUNT FROM ( SELECT PM.PRB_NO, COUNT(*) AS ACOUNT FROM PR.CALL C , PR.PRB_MASTER PM WHERE PM.PRB_NO = 69376 AND PM.PRB_NO = C.PRB_NO GROUP BY PM.PRB_NO) AS A , ( SELECT PM.PRB_NO, COUNT(*) AS BCOUNT FROM PR.CALL_ARC AC , PR.PRB_MASTER PM WHERE PM.PRB_NO = 69376 AND PM.PRB_NO = AC.PRB_NO GROUP BY PM.PRB_NO) AS B WHERE A.PRB_NO = B.PRB_NO ? [...] 324 87 43_Re: Help! Name change for "Data Processing"14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 22 Jul 2000 19:43:13 +1000499_iso-8859-1 Electronic Information Services (eInformation Services - or has IBM trademarked the little 'e' prefix?)

Speaking biz-speak, focus on a name that describes what you provide rather than how you do it. That way, if the means of providing the services change you won't be stuck with an out-of-date name and (more importantly) another provider won't be able to claim "since xxxx is no longer the way things are _done_, you need a new provider to do them in a more modern fashion". [...] 412 24 25_DB2 NT import into OS/39014_Dave Newington31_Dave.Newington@JDWILLIAMS.CO.UK31_Sat, 22 Jul 2000 10:37:25 +0100577_us-ascii Once you have bound the packages using the Client Configuration Asistant (Remember to connect to OS/390 with an ID that has bind add priviledge) it should work fine. I regularly import from DB2 NT V5.2 and 6 into DB2 OS/390 V5. A valid import statement is : import from d:\jdw\database\export\UTILS of ixf insert into prod.UTILS ; Bear in mind that insert is the only valid option when importing data to OS/390. From NT to anywhere else you can use load and create table as well. The IXF format is basically the same as the mainframe Reorg Unload format but with [...] 437 42 11_LOAD Delete0_36_shaun.z.lombard@TRANSPORT.QLD.GOV.AU31_Mon, 24 Jul 2000 09:12:45 +1000339_us-ascii I have a friend who would like to know if this concept has been used by anyone out there; and if so, are there any issues the site should be made aware of:

Summary: To delete (perhaps migrate) the data (TS) of a sparse index, after its 4 indexes have been created. Reason: to save storage cost of data never accessed. [...] 480 21 15_Re: LOAD Delete13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Sun, 23 Jul 2000 18:09:39 -0500345_- >To delete (perhaps migrate) the data (TS) of a sparse index, after its 4 >indexes have been created. Reason: to save storage cost of data never >accessed.

Why not setup a compressed tablespace?

If the data is sparse it should be very compressible and this way you never need to shell out the full space even while loading. [...] 502 135 43_Re: Help! Name change for "Data Processing"0_36_shaun.z.lombard@TRANSPORT.QLD.GOV.AU31_Mon, 24 Jul 2000 09:55:22 +1000864_us-ascii Marcus,

That's a very interesting acronym your final suggestion would make.

Cheers







"Davage, Marcus" on 21/07/2000 23:38:56

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Shaun Z Lombard/CorpServ/qdot/au) Subject: Re: Help! Name change for "Data Processing"





How about throwing a few techie words together with some businessy words and seeing what happens? e.g. Any combination of: Telephony, Information, Technical, Bureau, Knowledge, Technology, Communications, Business, Data, e- with any other combination of: Systems, Services, Support, Technologies, Communications, Networks and maybe one of these in between: -based-, -enabled-, to come up with something like: Telephony, Information [...] 638 164 43_Re: Help! Name change for "Data Processing"11_Marty Stahl17_One_Mind@SLIP.NET31_Sun, 23 Jul 2000 19:21:11 -0500524_iso-8859-1 Quite "A Chorus Line" of talented professionals

My regards and blessings are yours,

Marty Stahl

New thoughts create new conditions -Ernest Holmes

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of shaun.z.lombard@TRANSPORT.QLD.GOV.AU Sent: Sunday, July 23, 2000 6:55 PM To: DB2-L@RYCI.COM Subject: Re: Help! Name change for "Data Processing"

Marcus,

That's a very interesting acronym your final suggestion would make. [...] 803 79 43_Re: Help! Name change for "Data Processing"14_Duncan Gardner23_dgardner@GESB.WA.GOV.AU31_Mon, 24 Jul 2000 08:45:01 +0800679_- Greg,

I'm in the Infrastructure Support Group (not much of anacronym - I prefer Marcus's personally) and do pretty much the same as you - servers, DBA, networks, PCs, Help Desk, phones etc, though not development.

Duncan Gardner DBA Team, Infrastructure Support Group Government Employees Superannuation Board (08) 9263 4164



> ---------- > From: Greg DiGiorgio[SMTP:gdigior@CI.NEWPORT-NEWS.VA.US] > Reply To: DB2 Data Base Discussion List > Sent: 21 July 2000 21:15 > To: DB2-L@RYCI.COM > Subject: Help! Name change for "Data Processing" > > Dear Fellow DB2-L'ers, > > We are a local municipality with 150,000 citizens and are contemplating a [...] 883 244 39_Re: Can Anybody Help me withthis please11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Mon, 24 Jul 2000 11:41:44 +1000629_- It might be worth posting this question to the AS/400 newsgroup - comp.sys.ibm.as400.misc - they specialise in these questions.

Cheers, Ulrich

> -----Original Message----- > From: Yashas Mallawarachchi [SMTP:yasas@SLIIT.LK] > Sent: Saturday, July 22, 2000 5:57 PM > To: DB2-L@RYCI.COM > Subject: Can Anybody Help me withthis please > Importance: High > > Hi All, > > Our Institution owns an IBM AS/400 server which is dedicated for Domino. > It > uses OS/400 V4R4 as the operating system. SB2 Universal database is also > installed in it. We are accessing the AS/400 using AS/400 Client Access > express for [...] 1128 14 43_ROLAND CHUA CHONG KEE is out of the office.11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Mon, 24 Jul 2000 09:53:12 +0800365_us-ascii I will be out of the office from 24/07/2000 until 27/07/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. 1143 83 64_Re: DB2 Load problem: What's wrong with "VARCHAR(60) NOT NULL" ?17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Mon, 24 Jul 2000 09:55:43 +0500611_- Hello, You need to generate the LOAD PARMS.You can do a UNLOAD of the table with SYSPUNCH to generate the control card. Use this control card while LOADING the DATA.This should solve your problem.

Vijay



> -----Original Message----- > From: Christine Sawyer [SMTP:cosawyer@HOTMAIL.COM] > Sent: Friday, July 21, 2000 10:46 PM > To: DB2-L@RYCI.COM > Subject: DB2 Load problem: What's wrong with "VARCHAR(60) NOT NULL" ? > > Hi List, > I'm having problem loading a table. The problem it seems is with a VARCHAR > column of my table. I have "VARCHAR(60) NOT NULL" define as a column and [...] 1227 109 15_Re: Alter Table12_Ahmad, Zafar22_Zafar.Ahmad@ATO.GOV.AU31_Mon, 24 Jul 2000 14:16:18 +1000480_iso-8859-1 Craig,

I had a problem with ALTERS uisng Platinum while renaming certain columns from TEXT to DATE format using Platinum. The length of the column was also changed to cater for the date format. Platinum could not generate the load statements for these columns. Please note that these columns were defined as NOT NULL. Does BMC software allow the generation of load statements in this scnerio and if yes what would be loaded in these columns for DATE value. [...] 1337 17 42_Fred Harb/DOR/NEBRLN is out of the office.0_21_fharb@DOR.STATE.NE.US31_Mon, 24 Jul 2000 01:00:36 -0500474_us-ascii I will be out of the office starting 07/21/2000 and will not return until 07/27/2000.

I will respond to your message when I return. If you need assistance before I return please contact Lou Anne Daugherty (479-4799).

================================================ 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. 1355 36 46_Re: REXX interface problem: DESCRIBE statement16_Singh, Harmander26_Harmander.Singh@ATO.GOV.AU31_Mon, 24 Jul 2000 15:36:02 +1000508_iso-8859-1 Many thanks, Rolf. I referred your email to our system software area, and have been able to solve my problem now.

HS

-----Original Message----- From: Rolf Merkle [mailto:rolf.merkle@DVG-KA.DE] Sent: Thursday, 20 July 2000 17:39 To: DB2-L@RYCI.COM Subject: Re: REXX interface problem: DESCRIBE statement



There are also other errors in the REXX-Interface. Look for APAR PQ31316 and PTF UQ38048. After installation of this PTF at our site the interface worked fine. [...] 1392 15 42_Gordon Reich/WCBAlta is out of the office.0_22_gordon.reich@WCB.AB.CA31_Mon, 24 Jul 2000 01:03:02 -0600389_us-ascii I will be out of the office starting 2000/07/22 and will not return until 2000/08/14.

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. 1408 13 29_Win NT & DB2 6.1 Installation19_Christos Berberidis18_berber@CSD.AUTH.GR31_Mon, 24 Jul 2000 04:26:13 -0500510_- I installed db2 6.1 (Enterprise Edition) on Win NT 4.0. Then tried to create the sample database (from first steps) and got the following message "Can't create sample database". (No errors during the installation) Anyone having encountered the same problem plz help!

================================================ 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. 1422 53 33_Re: Win NT & DB2 6.1 Installation15_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE31_Mon, 24 Jul 2000 05:47:05 -0500310_- Kalimera Christos,

there are - as always- a lot of potential reasons for your problem. I'll try to give some hints where and how to get further diagnostics to find out what is going wriong. Please excuse if some of the following questions sound "silly", but they may help diagnosing the problem. [...] 1476 16 33_Re: Win NT & DB2 6.1 Installation15_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE31_Mon, 24 Jul 2000 05:50:08 -0500440_- Sorry, there's a mistype in the command in Pos.3:

it should of course read "LIST DATABASE DIRECTORY".

BTW: if you issue "STOPDB2" and "STARTDB2", do you get any messages ?

/M.

================================================ 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. 1493 23 33_Re: Win NT & DB2 6.1 Installation13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 24 Jul 2000 07:21:27 -0400436_iso-8859-1 Hi Christos, In addition to the items Matthias suggested checking, make sure you're logged on to NT with the admin ID you specified during the install.

If you took the default, it's probably Userid & Password = db2admin. Try logging onto NT with that combination. That ID will be installed most likely only on your local machine -- not the domain. I've seen Create sample database fail when the wrong id is used. [...] 1517 59 33_Re: Win NT & DB2 6.1 Installation16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Mon, 24 Jul 2000 06:58:43 -0400443_iso-8859-1 Actually this is a very normal error, and common to not only NT but Unix etc. and occurs for 1 of 2 reasons.

(1) You need to be logged on to NT with a userid that conforms to DB2 requirements (through V6.1, not V7). This is an 8 byte userid or less, with no special characters, blanks, etc. If you have a userid that does not conform to this, then there is no way for the system to recognize you and you get this error. [...] 1577 154 54_AW: AW: Import data into DB2 for OS/390 via DB2 for NT12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 24 Jul 2000 13:58:06 +0200377_iso-8859-1 Mike,

it works. Thank you very much for all your help !!!

And for this strange ixf format I received a mail from Dave Newington. He wrote "The IXF format is basically the same as the mainframe Reorg Unload format but with some extra control cards.."

The import works - so my problem is solved. Thanks again to both of you, Mike and Dave !! [...] 1732 93 39_Re: Can Anybody Help me withthis please0_19_mike.holmans@BT.COM31_Mon, 24 Jul 2000 12:58:13 +0100308_- Which level of DB2 is it using? The way the message is coming out, it doesn't look as though BLOB is a valid datatype, which suggests that you don't have the relevant AS/400 PTFs which delivered support for BLOBs. LOB support wasn't in the original release of DB2/400 V4R4, but came with PTF SF99104. [...] 1826 109 28_Error on client installation12_Randy Wilson22_Randy_Wilson@BCBST.COM31_Mon, 24 Jul 2000 08:12:07 -0400601_iso-8859-1 We're running UDB/EEE v 6.1 on AIX, and we've installed the UDB DBAdmin client on an NT workstation... when we try to access any of the tools (including CCA) we get this error: SQL1390C The environment variable DB2INSTANCE is not defined or is invalid.

this is the second machine we've loaded this onto, on the first machine we didn't have this problem.... the machine that gets the error has the same environmental variables as the first one. We've tried reinstalling the client to no avail ... even tried to manually catalog the database on the client. any ideas??? TIA Randy [...] 1936 12 16_unsubscribe me!!15_Kobus Scheepers25_kobus.scheepers@IT-IQ.COM31_Mon, 24 Jul 2000 13:01:51 +0100287_iso-8859-1 please tell me how to un-subscribe

================================================ 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. 1949 23 13_moving tables11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM31_Mon, 24 Jul 2000 08:14:16 -0500297_us-ascii Hi all,

I am a jr DBA who doesn't have tremendous experience with DB2 app DB2 methods so forgive this question.

I have a v5 DB2 OS/390 scenario where I have a test and prod database. I want to copy 2 tables (and their data) from the test database to the prod database. [...] 1973 95 16_DB2 Load Problem11_Mohamed Beg19_mohamedb@ABSA.CO.ZA31_Mon, 24 Jul 2000 15:46:36 +0200467_iso-8859-1 Hi.

I've unloaded a DB2 Table from one development system and loaded it to another. This table has a char field of 80 chars and consists of various chars and symbols eg. ( ! , | etc )

When I load this table onto the target system some of the symbols are represented differently. The strange thing is when I try inserting a record using those symbols which are loaded incorrectly into the table on the target system it inserts correctly. [...] 2069 57 17_Re: moving tables19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 24 Jul 2000 08:53:11 -0500410_iso-8859-1 Hi Trace, Consider using DSN1COPY with the OBXLAT option and an Image Copy of each table. See DB2 Utility manual. To get the DBID, PSID and OBIDs, query SYSTABLES and SYSTABLESPACE after you've created the target tables. Target tables must be defined like the source, e.g.. SEGSIZE, PAGESIZE, etc. Remember to use the RESET option as well. Remember to REBUILD the indexes or DSN1COPY them too. [...] 2127 51 16_Locking Problems14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Mon, 24 Jul 2000 15:48:35 +0100592_us-ascii Hi anyone,

perhaps someone out has some ideas as to what has been causing us trouble since Saturday; we have a tablespace with prox. 8 GB. On Saturday we partitioned the Tablespace, making it LARGE with 20 partitions, partitioning it on the Primary Key which is an inverse timestamp. The Tablespace has been clusterd on the PK since its creation. The table itself has several foreig keys and one of them is self-referencing, using column 'x'; there is an index on the column. The column is nullable and the respective index is referencing prox 35,000 rows out of a total [...] 2179 53 17_Re: moving tables13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 24 Jul 2000 09:06:09 -0500385_iso-8859-1 Assuming the data is not enormous, and you have no 3rd party tools to use ....

1. Use DSNTIAUL sample program to unload the data from test. 2. Edit the unload cards created in step 1 to match production table/creator names. 3. Use DB2 load utility to load data unloaded from step 1 and using the load cards you modified in step2 into the production environment. [...] 2233 102 17_Re: moving tables0_19_mike.holmans@BT.COM31_Mon, 24 Jul 2000 15:10:11 +0100366_- Consider DSN1COPY by all means, but it's a very fiddly way of going about it.

Unless the tables are huge, it makes a lot more sense to unload the data from the test system and then load it into the target system after creating tables with the identical column layout. Especially if you're a junior DBA without much experience of DB2 and its utilities. [...] 2336 60 15_Re: LOAD Delete24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Mon, 24 Jul 2000 10:37:16 -0400307_iso-8859-1 Shaun - could you please define sparse index ? I know what it is in IMS but not in DB2 or is that a term of your own making ? I know of some applctns offloading a subset of a large ts into another ts which they use both to satisfy many queries and/or act as a 'portal' to the large ts...... [...] 2397 10 17_Re: moving tables10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Mon, 24 Jul 2000 10:52:24 -0400343_- It might be a good idea to add a word of caution concerning moving data from your test environment into your production environment. I will assume that access to your data in test is fairly wide open. This could result in some very questionable data being moved into production. I highly recommend verifying the data prior to the move. [...] 2408 17 12_AREST status13_john arbogast19_arbo@CP-DEMO.CP.NET31_Mon, 24 Jul 2000 08:05:10 -0700591_- Listers -

DB2 V6 OS/390 2.8

Has anyone seen pagesets left in AREST status after a defered recovery by DB2? We had DB2 crash while several threads were active. DB2 came right back up and started to clear the postponed aborts. Most of the postponed aborts completed and the pagesets returned to a normal RW status. However, several PS remained in AREST status. Issued the -rec post command and DB2 replied no postponed abort threads found. We IPL'd this weekend as scheduled. DB2 restarted and again no postponed aborts found? Why do we still have PS in AREST status? IBM [...] 2426 22 44_Re: DB2 Migration V4 to V5 CATMAINT 00E4060117_Massimo Biancucci19_mbiancucci@DEBIS.IT31_Mon, 24 Jul 2000 10:20:00 -0500424_- We faced the same problem last weekend. The offset is identical and so we hope our solution will be good to you too. The problem, looking at the dump, is explained by 4 and 5 register (FFFFFDA7 and FFFFFDA7) that means a -601 sqlcode (The name of the object you want to create is identical .....). In our site the problem was due to an alias on the sysibm.syslocation table named sysibm.location . Hope to be useful. [...] 2449 49 56_DB2 OS/390 : question on BOUNDBY value in SYSIBM.SYSPLAN0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Mon, 24 Jul 2000 12:04:51 -0400396_us-ascii Hi,

We're trying to solve a little mystery related to the BOUNDBY value in SYSPLAN

ENVIRONMENT: DB2 / OS390 V5.1

DESCRIPTION: A query to SYSIBM.SYSPLAN revealed a plan was "bound by" userid = DBA07. Userid DBA07 claims he did not bind the plan. The plan in question is rarely used and may have been invalid. The OWNER value is different from the BOUNDBY value. [...] 2499 36 60_DB2 Load problem: What's wrong with "VARCHAR(60) NOT NULL" ?13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Mon, 24 Jul 2000 12:04:08 -0400472_us-ascii Hello ,

The following should be changed :

- For a varchar , the length ( 60 ) is ignored in the control card . The length is obtained from a 2 byte binary field , which is present at the beginning of the varchar data to be loaded . In this case it should be at the beginning of a data row . If this is a first time load , then this 2 byte field has to be built externally . I use a SAS program for this , but I think for a small number of rows [...] 2536 66 60_Re: DB2 OS/390 : question on BOUNDBY value in SYSIBM.SYSPLAN14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Mon, 24 Jul 2000 12:25:43 -0400564_us-ascii Hi Ed,

I have seen similar situations in environments using Platinum (CA) tools. Where a table change strategy generated in RCUpdate creates rebind statements with the existing boundby id. This is facilitated using the .AUTH Platinum statements. If you have these tools in your environment, and wish to weigh the plausibility of this thought - check to see if a change to that object took place on or around the 'Last bound' date - and if it was done using RCU. I do not know how BMC or others tools work so I can not speak to this point, but [...] 2603 82 34_UDB7.1/NT stored procedure problem20_Pav Kumar-Chatterjee17_pavkc@HOTMAIL.COM29_Mon, 24 Jul 2000 16:56:36 GMT399_- Hi List

I am trying to build a store procedure on UDB 7.1 under NT. I am trying to use the BASECASE example, but do not get very far (log output below)!!

My question is: What/where is NMAKE?? Has anyone got this working?

As always, thanks to all those who respond.

Pav

*** PREPCOMPILE D:\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp\P0723780.sqc *** [...] 2686 32 17_FW: moving tables13_OConner, John26_John.OConner@COURTS.WA.GOV31_Mon, 24 Jul 2000 09:58:01 -0700689_iso-8859-1 If you are creating tablespaces for these tables, you will need to know your production standards for bufferpools and DASD (STOGROUPs vs user-defined) allocations.

-----Original Message----- From: Bill Brown [mailto:bill_brown@SPRINGMAIL.COM] Sent: Monday, July 24, 2000 7:52 AM To: DB2-L@RYCI.COM Subject: Re: moving tables



It might be a good idea to add a word of caution concerning moving data from your test environment into your production environment. I will assume that access to your data in test is fairly wide open. This could result in some very questionable data being moved into production. I highly recommend verifying the data prior to [...] 2719 87 15_Re: LOAD Delete0_36_shaun.z.lombard@TRANSPORT.QLD.GOV.AU31_Tue, 25 Jul 2000 09:29:25 +1000413_us-ascii Frank,

That is exactly what they are doing - offloading a subset of the large table for index only query use. They have no need to access the table data and would like to delete the physical VSAM dataset.

Shaun







"Marchese, Frank D, CSCIO" on 25/07/2000 00:37:16

Please respond to DB2 Data Base Discussion List [...] 2807 59 20_Re: unsubscribe me!!0_29_Greg.Palgrave@BANKWEST.COM.AU31_Tue, 25 Jul 2000 08:19:14 +0800531_us-ascii You *could* start by reading the message at the bottom of *all* the db2-l mailings:

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

Cheers, Greg Palgrave





Kobus Scheepers on 24/07/2000 20:01:51

Please respond to DB2 Data Base Discussion List [...] 2867 96 17_Need help in REXX0_18_dsi.listsrv@DB.COM31_Tue, 25 Jul 2000 11:10:25 +0530353_us-ascii





Hi, We would like some help regarding the following problems we are facing.

We are at present trying to migrate a database from db2 2.12 to UDB 5.2. We are writing a REXX script to do the above. We will be doing the export/import using .ixf format for the flat files. This takes care of the codepage change. [...] 2964 126 20_Re: Locking Problems14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Tue, 25 Jul 2000 09:41:07 +0100617_us-ascii Venkat,

last night we dropped the index in question and re-created it to its former state, i.e containing just one nullable column, but that didn't matter much; we are still running into locking conflicts when one cics-transaction acquires a lock and sort of passes it on to the next transaction. We now disabled our protected threads and this somehow solved the locking conflicts. But we're still wondering why the problems occured all of a sudden. We have been using protected threads for quite some time by now, we have been binding a number of packages with release(deallocate) for some time [...] 3091 26 15_VDWQT question.11_K Mahadevan28_kmahadevan@CHENNAI.TCS.CO.IN31_Tue, 25 Jul 2000 13:52:44 +0530514_us-ascii Hi,

In our project we have a situation where one of the jobs is having a very high asynchronous wait time. One of our DBAs have suggested that we change the VDWQT parameter to 0 to reduce this wait time.

Can somebody suggest me how this will help. My assumption is that this parameter (Vertical write threshold) represents the amount of data after which it will write from buffer to DASD. Please tell me what will happen if this value is high and what will happen if this value is low. [...] 3118 68 19_Re: VDWQT question.7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Tue, 25 Jul 2000 14:32:23 +0530597_iso-8859-1 Hi Mahadevan, I believe first of all it has to be known whether it is high asynchronous "read" time or "write" wait time.If it is Asynchronous read wait time then it has to do very little with VDWQT thresholds.However, both of these have been discussed in the list several times. Considering it is Write wait time, DB2 writes pages from BP to DASD asynchronously when VDWQT is reached.It is the %age of pool occupied by the updated pages of a single dataset.Every VDWQT will schedule 128 pages asynchronous writes with the exceptions that VDWQT is hit before 128 unavailable pages [...] 3187 120 20_Re: list of datasets13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Tue, 25 Jul 2000 10:07:00 +0100330_- Deb The answer to your question is no there isn't any indication in the DB2 catalog.

Remember DB2 calls the VSAM Media Manager, basically it uses IDCAMS DEFINE CLUSTER ....., to CREATE the VSAM Linear dataset (LDSs) in the first place. DB2 then performs additional formatting of these LDSs to its own specification. [...] 3308 26 15_BMC CA question11_K Mahadevan28_kmahadevan@CHENNAI.TCS.CO.IN31_Tue, 25 Jul 2000 14:53:37 +0530506_us-ascii Hi, In our project we are using BMC CA and these runs on a few tablespaces 4 times a day (5 am, 6 am, 7 am ,8 am). The DB2 logs are archived to tapes as and when they get filled up. Suppose I cahnge one of my tables at 1 pm on a particular day and subsequently my logs get archived then during the next days Change accumulation at 5 am ( It will try to accumulate all the changes that took place after the last change accumulation that took place the previous day). In this situation will it [...] 3335 51 19_Re: BMC CA question15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Tue, 25 Jul 2000 04:34:33 -0500595_iso-8859-1 It uses SYSLGRNGX and the BSDS to find only those archive logs that have (or may have) updates for the tablespace(s).

Andy Lankester BMC Software Ltd

-----Original Message----- From: K Mahadevan [mailto:kmahadevan@CHENNAI.TCS.CO.IN] Sent: 25 July 2000 10:24 To: DB2-L@RYCI.COM Subject: BMC CA question



Hi, In our project we are using BMC CA and these runs on a few tablespaces 4 times a day (5 am, 6 am, 7 am ,8 am). The DB2 logs are archived to tapes as and when they get filled up. Suppose I cahnge one of my tables at 1 pm on a particular day and [...] 3387 28 31_Converting BLOB to VARCHAR/CHAR0_18_dsi.listsrv@DB.COM31_Tue, 25 Jul 2000 15:03:26 +0530623_us-ascii Hello Everyone!

Is there any way to convert BLOB to VARCHAR/CHAR?.(Assume that only text files are stored in BLOB)

Your early response would be appreciated.

Thanks in advance

Ramesh Babu



============================================================================================= DISCLAIMER: The opinion expressed above is that of the author and should not be understood or in-terpreted as equivalent to the opinion of Deutsche Bank AG or any of its subsidiary companies ============================================================================================= [...] 3416 81 19_Re: VDWQT question.14_David Williams25_David-O.Williams@UBSW.COM31_Tue, 25 Jul 2000 09:49:16 +0100359_us-ascii This threshold is expressed as a percentage of the virtual buffer pool that might be occupied by updated pages from a single data set.

If the percentage of updated pages for the data set exceeds the threshold, writes are scheduled for that data set. If you have a very large buffer pool this will obviously mean a large number of writes. [...] 3498 89 19_Re: BMC CA question11_K Mahadevan28_kmahadevan@CHENNAI.TCS.CO.IN31_Tue, 25 Jul 2000 15:32:29 +0530487_us-ascii Andy,

Thanks very much for your reply . I have one more thing to clear , We have a table called BMC.V22_CALGRNG which is having a BEG_RBA and END_RBA and I assume this is the table which you said as the SYSLGRNX or is there any DB2 supplied table like this (I couldnt find one) . I think it uses the begin RBA and end RBA to decide this. I am not clear how it uses these to decide which logs datasets have the particular tablespace changes.Please explain that also. [...] 3588 125 19_Re: BMC CA question15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Tue, 25 Jul 2000 05:28:47 -0500611_iso-8859-1 Maha,

The BMC.V22.CALGRNG table is used to keep track of the total log range covered by a particular CA dataset so that recover (or the next CA run) knows where to start processing in the residual log that has not had CA run agaist it.

When creating a CA the product will look up in SYSIBM.SYSLGRNG the start/end LRSNs/RBAs for which the tablespace(s) were open for update. Remember that CLOSE/PSEUDOCLOSE will end the SYSLGRNGX entry, and the next update will start a new one. So there may be quite large gaps for intermittently updated tablespaces. The start/end points of these [...] 3714 41 26_rollforward recvoery error11_David Ayers24_david.ayers@HIGHMARK.COM31_Tue, 25 Jul 2000 06:21:44 -0400594_us-ascii hello listserv members

We have a problem when trying to perfrom a forward recovery with datajoiner (DB2 CS / AIX 4.3). We had some processes that were hung in AIX (joining data between oracle / DB2 os/390). I had our unix admins kill the procesess and cleanup any related memory. During restart the DB went into crash recovery and was non functional (could not connect). I issued a restore from an on0line backup with a forward recovery. Everything says the recovery completed (messages / db2diag.log) but the DB is still in a DB rolll-forward pending state. When I try to [...] 3756 63 19_Re: VDWQT question.4_IBM119_IBM1@EGEBANK.COM.TR31_Tue, 25 Jul 2000 15:04:09 +0300588_- to go along with the various detailed and excellent descrpitions of how vertical deferred write afftects your performance, you might want to have a look at an article by Robert Catterall in DB2mag (quarter 2, summer 2000), called 1prefetch and deferred write in OS/390".

ciao!

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...] 3820 30 25_DB2 Connect PE management12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Tue, 25 Jul 2000 07:00:36 -0500488_- I am looking to see how others manage the differant levels of DB2 Connect PE pacakages bound on DB2 for OS/390. I have a test system where I have the PE 5.2, PE 6.1 FP2, and the PE 6.1 FP4 packages bound. Contrary to a response from an ETR I put in with IBM, both versions of PE, 5.1 and 6.1, can connect to OS/390 DB2. If I have PE 6.1 FP2 installed on my PC and upgrade it to FP4, then I believe when I try to bind the packages again on another DB2 system, the FP4 packages will [...] 3851 21 29_Re: DB2 Connect PE management14_Philip Gunning18_pgunning@PHEAA.ORG31_Tue, 25 Jul 2000 08:22:30 -0400415_us-ascii Richard, I have done this with PE and EE over the years with no problems. I tried to keep all at the same version and level, but with disparate applications that is not possible at all times. HTH Phil

Phil Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA IBM Certified Solutions Expert -- DB2 UDB V6 IBM Certified Solutions Developer -- DB2 UDB V6 Assoc List Owner DB2-L [...] 3873 49 16_Re: AREST status17_Richard Cotterill24_RL_cotterill@BIGPOND.COM31_Tue, 25 Jul 2000 22:59:48 +1000294_us-ascii HI, We have just had one of these this last week. We have previously had an object stuck in a Postponed Recovery status. It was different from the AREST status in that we could carry out all functions on the object in AREST status except we found that the BMC utilities objected. [...] 3923 179 20_Re: Locking Problems20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 25 Jul 2000 09:02:24 -0400571_iso-8859-1 Hello Ruediger

Could you provide a little more information on this - - When you dropped and recreated the index on Saturday, did any access path changed due to rebinds ? - Are you on data-sharing? - If yes, do you have good affinity between the partitions and members, If not LOCKPART YES may not be a very good idea. - What exactly is locking problem? Are you getting more LOCK/LATCH WAIT time on your accounting trace ? Are you getting timeout or deadlock? Do you have data-sharing lock contentions such as false or xes contention? - Did you try [...] 4103 65 30_Re: rollforward recvoery error14_Mike Lebermann18_Lebermm@BCBSKC.COM31_Tue, 25 Jul 2000 08:19:46 -0500652_US-ASCII David,

After you rollforward to the point in time and you're still in roll forward recovery, try issuing

db2 "rollforward db dbname complete"

Hope this helps!

Mike

>>> david.ayers@HIGHMARK.COM 07/25/00 05:21AM >>> hello listserv members

We have a problem when trying to perfrom a forward recovery with datajoiner (DB2 CS / AIX 4.3). We had some processes that were hung in AIX (joining data between oracle / DB2 os/390). I had our unix admins kill the procesess and cleanup any related memory. During restart the DB went into crash recovery and was non functional (could not connect). I issued a [...] 4169 34 32_Re: Stored Procedure Performance27_Scott.Gjerdingen (Exchange)27_Scott.Gjerdingen@TARGET.COM31_Tue, 25 Jul 2000 08:28:57 -0500749_iso-8859-1 hmm... no feedback on this note I posted last week?

-----Original Message----- From: Scott.Gjerdingen (Exchange) [mailto:Scott.Gjerdingen@TARGET.COM] Sent: Friday, July 21, 2000 9:26 AM To: DB2-L@RYCI.COM Subject: Stored Procedure Performance



I am considering converting a common cobol subroutine into a stored procedure (os/390 based) which will be called from batch jobs, cics transactions and potentially in the future in a client/server n-tier capacity. I have seen benchmark data on improvements stores procedures can provide client server applications that previously executed dynamic SQL but I have not seen any sort of comparison between OS/390 based batch and CICS transactions using stored procedures [...] 4204 30 15_VDWQT question.14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 25 Jul 2000 09:32:41 -0400387_ISO-8859-1 If you mean Asynch Read time, this has litle to do with VDWQT, except that all reads could be impacted by heavy writes. Now what's high? If the Asynch read is 50 MS, this is not really high, although you could do better. If it's really high, > 70 Ms, you have a DASD performance problem, and you should should see this for Synch reads as well - if they are > 16 - 20 Ms. [...] 4235 50 36_Strange But True Connection Failures24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM31_Tue, 25 Jul 2000 23:36:33 +1000330_iso-8859-1 I am sending this note to the list because the following bug cost me a couple of days, and it might help others plan their DB2 naming conventions on OS390 and even save a few brain cells.



APAR Identifier ...... JR13607 Last Changed..00/03/23 DRDA DUMP BECAUSE COLLECTION ID IS GREATER THAN 8 CHARS. [...] 4286 44 32_Re: Stored Procedure Performance3_FIS18_fis@ARCHES.UGA.EDU31_Tue, 25 Jul 2000 09:38:59 -0400693_us-ascii AIC forgot to give her a default library. She has one now so she should work okay.

At 08:28 AM 07/25/2000 -0500, you wrote: >hmm... no feedback on this note I posted last week? > >-----Original Message----- >From: Scott.Gjerdingen (Exchange) [mailto:Scott.Gjerdingen@TARGET.COM] >Sent: Friday, July 21, 2000 9:26 AM >To: DB2-L@RYCI.COM >Subject: Stored Procedure Performance > > >I am considering converting a common cobol subroutine into a stored >procedure (os/390 based) which will be called from batch jobs, cics >transactions and potentially in the future in a client/server n-tier >capacity. I have seen benchmark data on improvements stores procedures can >provide [...] 4331 198 20_Re: Locking Problems14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Tue, 25 Jul 2000 15:45:28 +0100613_us-ascii Hi Venkat,

what we saw in omegamon for db2 was that locks were taken on the whole tablespace, not on any single partition, although we changed the locksize to 'page' from 'any' yesterday when we first ran into trouble. These S-Locks prohibited any Update-traffic on any partition or the tablespace. What really bothered us was that the TYPE-column in Omegamon showed 'MDEL' indicating a mass-delete while the sql in question really was 'select .... with ur'; We then got into contact with IBM and rumour has it that there might be a conflict when specifying 'lockpart yes' for the tablespace [...] 4530 25 34_DB2 version 6 - migration question0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Tue, 25 Jul 2000 08:47:11 -0500580_us-ascii We are currently moving to DB2 version 6 and have hit a problem. As soon as we installed version 6 into one of our test subsystems, several stored procedures could not be used by programs that were written on visual basic using RDO. As we have investigated this problem, it looks like the client enabler (CAE) that we have installed (version 5.2) is not compatable with version 6. Has anyone else encountered this problem. What do we need to install to replace the client enabler with something that can be used with version 6 of DB2 and successfully execute stored [...] 4556 50 38_Re: DB2 version 6 - migration question12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 25 Jul 2000 06:51:02 -0700565_us-ascii What fixpack of 5.2 are you running on? And what MDAC level for Microsoft. We have MDAC 2.5 and Fixpack 12e for 5.2 accessing version 6 just fine.

--- L-IS.Kirkpatrick@MUTUALOFOMAHA.COM wrote: > We are currently moving to DB2 version 6 and have > hit a problem. As soon > as we installed version 6 into one of our test > subsystems, several stored > procedures could not be used by programs that were > written on visual basic > using RDO. As we have investigated this problem, it > looks like the client > enabler (CAE) that we have installed [...] 4607 37 29_DB2 Datasharing and Version 612_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Tue, 25 Jul 2000 10:40:44 -0400338_iso-8859-1 Hello,

We are in the early stages of planning to migrate from Version 5 to Version 6 of DB2 for OS390 and have hit a snag. We are currently using Shared read only data to share data between subsystems. The data is static and gets refreshed on a periodic basis from an external source, so updates are not a problem. [...] 4645 57 33_Re: DB2 Datasharing and Version 620_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 25 Jul 2000 10:46:39 -0400581_us-ascii I don't think you can have data-sharing without sysplex.

> -----Original Message----- > From: Hall, Robert [SMTP:Robert.Hall@OCC.TREAS.GOV] > Sent: Tuesday, July 25, 2000 10:41 AM > To: DB2-L@RYCI.COM > Subject: DB2 Datasharing and Version 6 > Sensitivity: Private > > Hello, > > We are in the early stages of planning to migrate from Version 5 to > Version > 6 of DB2 for OS390 and have hit a snag. We are currently using Shared > read > only data to share data between subsystems. The data is static and gets > refreshed on a periodic basis from an external [...] 4703 71 33_Re: DB2 Datasharing and Version 615_Toine Michielse18_vndobtm@US.IBM.COM31_Tue, 25 Jul 2000 16:51:09 +0100480_us-ascii Hello Robert,

>> Can you have data sharing without having a sysplex In one word... No...

Regards,

Toine Michielse DB2 for OS/390 Technical Specialist Silicon Valley Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS



"Hall, Robert" @RYCI.COM> on 07/25/2000 03:40:44 PM

Please respond to DB2 Data Base Discussion List [...] 4775 44 33_Re: DB2 Datasharing and Version 614_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Tue, 25 Jul 2000 07:55:37 -0700421_iso-8859-1 Yes, you can use aliases with 3 part names. I have done it in the past. Also, data sharing requires a Parallel Sysplex since it uses Coupling Facility structures. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

From: Hall, Robert [mailto:Robert.Hall@OCC.TREAS.GOV] Subject: [DB2-L] DB2 Datasharing and Version 6 Sensitivity: Private [...] 4820 122 20_Re: DB2 Load Problem11_Ron Johnson25_rjohnson@DATA-TRONICS.COM31_Tue, 25 Jul 2000 09:59:07 -0500361_iso-8859-1 Check the CCSID settings for the source and make sure they are the same on the destination. The SBCS_CCSID setting for the database in one subsystem is probably not the same as it is in the other. When creating a database, if the CCSID parm is not specified, it picks up the CCSID encoding scheme from the installation default (starting in V5). [...] 4943 81 33_AW: DB2 Datasharing and Version 612_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 25 Jul 2000 17:04:00 +0200526_iso-8859-1 Robert,

sorry, but the answer is NO. AFAIK: You cannot have data sharing without sysplex.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 5025 69 33_Re: DB2 Datasharing and Version 615_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 25 Jul 2000 10:11:48 -0500474_iso-8859-1 I think that you are a bit confused about what,exactly, data-sharing is all about. The name is really a misnomer. Data-sharing is not about sharing the data only between DB2 subsystems but sharing the workload between multiple DB2 subsystems who work in unison as one subsystem. It addresses unbalanced workloads across LPARS and availability and scalability issues. The data is shared by necessity between a grouping of subsystems that act, almost, as one. [...] 5095 32 72_Changing underlying VSAM high level qualifiers for DB2 table and indices19_Donald A. Smith, JR18_dsmithj@US.IBM.COM31_Tue, 25 Jul 2000 11:12:12 -0400547_us-ascii I am involved in a project that requires changing the underlying VSAM high level qualifiers for a number of large DB2 tables and indices. In the intrest of time (the tables are hugh), it has been decided to just rename the underlyung VSAM clusters to the new high level qualifier. The amount of data is over 20,000 cylinders that resides on 3390 DASD. Outside of stopping the tablespaces and indices that are having the VSAM cluster renamed, running an IDCAMS ALTER RENAME on the underlying VSAM clusters, and running the following: [...] 5128 49 76_Re: Changing underlying VSAM high level qualifiers for DB2 table and indices13_Toppins, Mike19_MToppins@UNIPAC.COM31_Tue, 25 Jul 2000 09:23:32 -0600456_iso-8859-1 You'll have to do a REORG on each tablespace as well for the new name to be recognized. I'm not positive that it will work. When we did such a task, we had to unload, drop, recreate, and load the tablespaces, etc.

-----Original Message----- From: Donald A. Smith, JR [mailto:dsmithj@US.IBM.COM] Sent: Tuesday, July 25, 2000 9:12 AM To: DB2-L@RYCI.COM Subject: Changing underlying VSAM high level qualifiers for DB2 table and indices [...] 5178 71 76_Re: Changing underlying VSAM high level qualifiers for DB2 table and indices23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 25 Jul 2000 16:34:01 +0100315_iso-8859-1 Donald

your process will work .. I have done it many times

if you had stogroup managed datasets then you would have to :

1. Alter to VCAT managed 2. Drop Stogroup 3. Create Stogroup 4. Alter Pageset or index back to stogroup managed 5. Alter Pri and Sec Qty of pageset or index [...] 5250 78 76_Re: Changing underlying VSAM high level qualifiers for DB2 table and indices9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 25 Jul 2000 16:30:26 +0100458_us-ascii The procedure is documented in the section titled.... 'Changing the high-level qualifier for DB2 Data Sets' ( Section 2.12.10 of DB2 V5.1 Administration Guide). See the appropriate sub-sections under the above section. Kind Regards, Andy Hunt - Scottish And Southern Energy.







"Donald A. Smith, JR" on 25/07/2000 16:12:12

Please respond to DB2 Data Base Discussion List [...] 5329 61 77_Re: Changing underlying VSAM high level qualifiers for DB 2 table and indices22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 25 Jul 2000 11:45:39 -0400372_iso-8859-1 I've done exactly what you're doing under DB2 for OS/390 V3, V4 & V5. Works great. If the tablespaces are in a DB2 STOGROUP, then you must update the VCAT name in the appropriate SYSIBM.SYSSTOGROUP entry. Make sure the IDCAMS ALTER renames the VSAM cluster name and the data component name (vcat.DSNDBC.dbname... & vcat.DSNDBD.dbname...) to be consistent. [...] 5391 178 76_Re: Changing underlying VSAM high level qualifiers for DB2 table and indices22_Kennedy, Tom - Cendant23_Tom.Kennedy@CENDANT.COM31_Tue, 25 Jul 2000 11:44:28 -0400538_iso-8859-1 When renaming the VSAM data sets using the IDCAMS ALTER command you need to ensure that both the old vcat and the new vcat are in the same ICF catalog. If not the ALTER command will rename the VSAM objects but it will NOT move them to the ICFCAT catalog where the new vcat is defined. The renamed objects will reside in the original catalog with the new name. Not what you want. If both alias' are in the same ICFCAT then after the ALTER completes normal catalog search will find your renamed entries in the proper place. [...] 5570 31 30_Discarded rows format in REORG18_Madeleine Fournier27_madeleine.f.fournier@AIB.IE31_Tue, 25 Jul 2000 10:34:11 -0500581_- Hello list,

Do you know a mean of converting a internal DB2 format file into a readable external DB2 format (DSNTIAUL format) ? This file is the discarded rows file from Platinum Rapid Reorg (yes, we are still customer of CA) when having a ROW-PROCESSING clause to delete/select specific rows. Each record contains the DB2 row header (which would not be too difficult to remove) but also decimal fields (and data/time I suppose, if we had any) are in internal DB2 format. We wish to keep these records in a user-friendly format as archives. We are running on DB2 for [...] 5602 62 34_Re: Discarded rows format in REORG20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 25 Jul 2000 11:57:45 -0400464_us-ascii If table in not uncompressed then I have written a custom REXX to convert DB2 internal format to unload format for the following data-types Integer Smallint Decimal Date/time/timestamp.

Send me email directly, I could help you write one for your need.

-----Original Message----- From: Madeleine Fournier [SMTP:madeleine.f.fournier@AIB.IE] Sent: Tuesday, July 25, 2000 11:34 AM To: DB2-L@RYCI.COM Subject: Discarded rows format in REORG [...] 5665 76 33_Re: DB2 Datasharing and Version 612_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Tue, 25 Jul 2000 12:05:26 -0400546_iso-8859-1 Thanks to all for the responses. We are a very small DB2 shop so no way will be be getting a sysplex; I was just hoping we could use datasharing differently than IBM intended, but no such luck!

I have discovered a problem with using three part names in an Alias entry. I can't issue grant statements against an alias, and unfortunately when I try to access the table from an ODBC client, I don't see the alias entry on the table pull down. If I enter the SQL manually, I can select rows from the table in another subsystem [...] 5742 39 36_TEMPSPACE1 is full on UDB 5.2 on AIX13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 25 Jul 2000 11:47:44 -0500680_us-ascii Hi,

We got this message in the db2diag.log and our production db2 had ground to a halt.

SMS Tablespace 1 (TEMPSPACE1) is FULL or file is too large (at OS or user limit), Detected on Container 0. ContPage= 142161 Obj=6 Type=128

2000-07-25-09.44.18.77588 Instance:dbuser Node:0000 PID:2970(db2pclnr) Appid: none buffer_pool_services sqlbWritePageToContainer Probe:99

How do we identify the user that caused the problem and which is the best way to solve it? We took down the application servers and then did a "force applicaitons all" for the problem to clear up. We also did a db2stop/db2start and activated the database again and started [...] 5782 186 77_Re: Changing underlying VSAM high level qualifiers for DB 2 table and indices22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 25 Jul 2000 12:55:03 -0400308_iso-8859-1 Tom -

Very good point. Don't let this stop you from creating a new VCAT that is defined in a different ICFCAT catalog then the old VCAT. After the IDCAMS ALTERs, execute an IDCAMS MERGECAT to move the "new" VCAT entries from the incorrect ICFCAT catalog to the correct ICFCAT catalog. [...] 5969 17 10_Shark Disk7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Tue, 25 Jul 2000 11:44:21 -0500458_- Hi,

We are in the process of adding Shark disks to our EEE/AIX database. What are some major design considerations peculiar to these disks.

Is there any reference material on this topic?

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. 5987 54 40_Re: TEMPSPACE1 is full on UDB 5.2 on AIX14_Mike Lebermann18_Lebermm@BCBSKC.COM31_Tue, 25 Jul 2000 12:28:30 -0500315_US-ASCII Helen,

In order to identify what query is filling up TEMPSPACE1 (in the future), you can setup snapshot monitors to run periodically to capture the SQL statements that are executing. I've also seen SQL text in the db2diag.log when the DIAGLEVEL is set to 4, but I wouldn't suggest that option. [...] 6042 51 35_Re: Converting BLOB to VARCHAR/CHAR20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 25 Jul 2000 13:35:06 -0400415_us-ascii Even if text files are not stored in BLOB, it is definitely possible to store then as VARCHAR. We do it all the time. How big is your BLOB? Where is it residing currently (I mean in a DB2 table or files or on your PC)?

-----Original Message----- From: dsi.listsrv@DB.COM [SMTP:dsi.listsrv@DB.COM] Sent: Tuesday, July 25, 2000 5:33 AM To: DB2-L@RYCI.COM Subject: Converting BLOB to VARCHAR/CHAR [...] 6094 42 37_DB2, RACF, and Authorization Checking0_22_BILL_GALLAGHER@PHL.COM31_Tue, 25 Jul 2000 14:02:28 -0400419_us-ascii A question for anybody else who may be using RACF for securing your DB2 subsystems:

We had a number of RACF profiles for DB2 resources defined as UACC(READ), particularly in the MDSNTB (DB2 table) class. In order to try to tighten the security on these tables, we RALTERed the resources in question to UACC(NONE) WARNING so that we could identify who might have been getting acess to these tables. [...] 6137 66 76_Re: Changing underlying VSAM high level qualifiers for DB2 table and indices0_17_sjvagnier@AEP.COM31_Tue, 25 Jul 2000 14:47:33 -0400560_us-ascii Donald, your process should work O.K. I have also done the same process several times using V4 and V5.

Regards...

Steve Vagnier American Electric Power









"Donald A. Smith, JR" @RYCI.COM> on 07/25/2000 11:12:12 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Changing underlying VSAM high level qualifiers for DB2 table and indices [...] 6204 40 24_SQL code from ODBC trace18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Tue, 25 Jul 2000 14:51:24 -0400522_iso-8859-1 Could anyone shed any light on this. We're running DB2 OS/390 V5 and we're running this through Datajoiner,the lowest version, I think. We get this message from one of the clients who opens up like 780 cursors and the message back says he is trying to open a cursor that is already opened. If I look at the monitor I can see where 780 were opened and only 779 closed but I can't get down to any more detail then that. Any ideas about this DRDA_HEAP_SZ setting, would that be a factor? Appreciate any help. [...] 6245 33 23_Update of Index Columns12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Tue, 25 Jul 2000 14:03:26 -0500396_- I have an application programmer that has a program running for an excessive amount of time. The environment is DB2V4.1 , MVS5.2.2, COBOL.

The programmer has a generalize update program that can insert, update and mark for delete rows in a set of about 12 tables. The update statements update ALL of the columns in the table including the index columns, even though the row exists. [...] 6279 97 76_Re: Changing underlying VSAM high level qualifiers for DB2 table and indices14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Tue, 25 Jul 2000 14:05:49 -0500374_- If just renaming the datasets,you may wish to correct the informational data in the DB2 header page

. For each partition being moved run a DB2 REPAIR to correct the Location / VCATname within the header page :

REPAIR LOCATE TABLESPACE DBNAME.TSNAME PAGE X'300000' VERIFY OFFSET X'52' DATA 'OLDSTOGROLDVCAT ' REPLACE OFFSET X'52' DATA 'NEWSTOGRNEWVCAT ' [...] 6377 72 27_Re: Update of Index Columns20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 25 Jul 2000 15:08:56 -0400389_us-ascii DB2 does a check if the existing value and updated value specified are same or not before physically updating it. If they are same then update doesn't take place physically but it gets recorded in accounting trace.

In your case the logs will be cut and pre and post image will be recorded from the point the column was updated (changed value) till the end of the row. [...] 6450 32 22_V6 Stored proc problem11_Robert Jans21_Jans.Robert@AMSTR.COM31_Tue, 25 Jul 2000 12:16:00 -0600515_- Hi, listers! We just migrated to DB2 V6 OS/390 on the weekend and have now encountered a strange problem. We use Delphi as a front end and Neon Shadow as the gateway. The users can connect and run a stored proc once but are unable to execute any more stored procs under that thread. There are no errors found in the DB2 SPAS or MSTR logs or in the Neon logs. It appears as if the subsequent calls to any stored procs just disappear. If the user disconnects and re-connects, they can execute one stored proc. [...] 6483 22 14_Reporting Tool9_YOUR NAME17_db2dba@TECHIE.COM31_Tue, 25 Jul 2000 15:10:51 -0400587_- Hi,

Our shop is planning on getting a reporting tool. We are looking at Focus. Any one who is using this product or any reporting tool can you please let us know the pros and cons.

Thank you, Kiran

______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup

================================================ 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. 6506 68 32_Re: Stored Procedure Performance15_Camitta, Steven30_steven.camitta@INGRAMMICRO.COM31_Tue, 25 Jul 2000 12:27:47 -0700336_iso-8859-1 Scott, I don't have any answers but I do echo the same concerns that you have. We are a rather young DB2 shop and the idea has been floated around of moving ALL database access into stored procedures. I haven't heard of anyone doing this and am very concerned that this would not hold up under high transaction volumes. [...] 6575 30 33_Data Joiner and Stored Procedures0_24_db46@DAIMLERCHRYSLER.COM31_Tue, 25 Jul 2000 15:42:11 -0400567_us-ascii Okay fellow DB2 list group, please bear with me on this one. I've been asked to see if it is possible to invoke mainframe based stored procedures through datajoiner.

To our DBA's and others best knowledge and as probably most of you already know that datajoiner is a tool used to join tables from different systems. We have tried to simply invoke a stored procedure in the command processor and not surpisingly it did not work. Besides the fact that datajoiner is basically DB2 version 2, there is no documentation about using stored procedures. [...] 6606 15 31_Re: RUNSTATS- KEYCARD & FREQVAL0_19_tim.lowe@STPAUL.COM31_Tue, 25 Jul 2000 15:18:57 -0500396_- Thanks for the PTF number! This bug was a particular "issue" of mine, and I had thought that it was "working as designed".

Thanks again, Tim Lowe

================================================ 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. 6622 20 84_August 9th - Performance Estimation Class - Tim Lenahan - Last call for registration10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Tue, 25 Jul 2000 16:41:44 -0400557_us-ascii If you are interested in attending the Performance Estimation class being held in Central PA on August 9th, and you have not already registered, please let me know ASAP.

Check out the details on Tim & the course on the Central PA DB2 Users Group webpage at: http://www.db2parug.org

Tks! Seeya

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6643 22 89_Sept 8th - $175 Advanced & Complex SQL Class - Sheryl Larsen, RYC - Central PA User Group10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Tue, 25 Jul 2000 16:51:15 -0400340_us-ascii On Sept 8th, Sheryl Larsen of RYC will be traveling to Central PA to teach her Advanced & Complex SQL Class for the low low cost of $175 per person! I highly recommend this class to your heavy SQL users.

Check out the details on Sheryl & the course on the Central PA DB2 Users Group webpage at: http://www.db2parug.org [...] 6666 26 15_Re: LOAD Delete12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Wed, 26 Jul 2000 09:13:28 +1200379_us-ascii Hi Shawn,

I'm not familiar with the term 'sparse index' - maybe I should be? - but if you want to use the index(es) only without having to worry about the data, maybe you could just use DF/HSM to migrate the bastar.., er, tablespace. It's kinda nice, in that if one day you decide you DO want the data - or another index - you're all ready to rock 'n' roll. [...] 6693 28 15_Job Opportunity12_Diane Barela28_Info@PALLADIANCONSULTING.COM31_Tue, 25 Jul 2000 15:15:29 -0700663_iso-8859-1 Dear Colleagues,

Palladian Consulting, a leader in the RDBMS consulting industry is currently seeking a DB2 or UDB Database Administrator for a permanent position within the West Coast region. This position requires the skills of a Sr. Level Production DBA, taking full responsibility over the database environment. System installation and maintenance support application experience is required. Must be a US citizen, client will not sponsor work permits. If this is something you would be interested in pursuing or hearing more about, please contact me. I can be reached at (800) 750-1777 or via email at staffing@palladianconsulting.com. [...] 6722 52 42_Re: DB2 V7 OS/390 and IMS V7 compatibility0_17_davido@US.IBM.COM31_Tue, 25 Jul 2000 16:34:48 -0600392_us-ascii Jim, Joseph, and everybody on DB2-L:

Here is the scoop on DB2 for OS/390 V7 and IMS compatibility--the V7 What's New book lists IMS Version 6 as the *minimum level required*. Generally, when compatibility requirements list minimum releases required, you can typically count on the compatibility of later releases. (You can always find exceptions; your mileage may vary.) [...] 6775 163 33_Re: DB2 Datasharing and Version 612_troy Coleman20_Troy.Coleman@UAL.COM31_Tue, 25 Jul 2000 15:09:33 -0500430_- Most GUI ODBC centric applications are looking for a database owner in the sign-on process and will use application security for each individual. I will use Neon Convoy as an example. My alias owner is BES100CL and the table owner is DBADB2. I created an alias of BES100CL.CDM_Sample_TBL for EXODBT2.DBABD2.CDM_SAMPLE_TBL. I then have the tool configured to sign-on using BES100CL. In this case all the SQL is unqualified. [...] 6939 29 15_Re: LOAD Delete13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Tue, 25 Jul 2000 19:31:55 -0400404_iso-8859-1 This seems to refer to a technique similar to one that I have come across before. We were running batch updates to insert a relatively small number of records to a very large table on a daily basis; we would maintain an efficient index on only the newly-inserted rows by defining a specific index for just this purpose, and dropping and re-creating the index empty before each batch run. [...] 6969 13317 19_Re: Job Opportunity14_Charles Heinze22_Programmer1969@AOL.COM29_Tue, 25 Jul 2000 20:02:19 EDT693_US-ASCII In a message dated 7/25/00 3:25:53 PM Pacific Daylight Time, Info@PALLADIANCONSULTING.COM writes:

<< Dear Colleagues,

Palladian Consulting, a leader in the RDBMS consulting industry is currently seeking a DB2 or UDB Database Administrator for a permanent position within the West Coast region. This position requires the skills of a Sr. Level Production DBA, taking full responsibility over the database environment. System installation and maintenance support application experience is required. Must be a US citizen, client will not sponsor work permits. If this is something you would be interested in pursuing or hearing more about, please contact me. I can be [...] 20287 20 15_Data Page Limit0_20_bjnigh@HOUSEHOLD.COM31_Tue, 25 Jul 2000 17:08:22 -0700435_us-ascii We have a 64 partition large tablespace which is receiving the following error when attempting to load over 53 million rows into part 19 using the Platinum Fastload Utility:

PFL1201E - NUMBER OF PAGES EXCEEDS MAXIMUM ALLOWED FOR PARTITION 019

Does anyone know if there is a page limitation in DB2? I can't find any error messages in DB2 as to what the problem might be. Has anyone encountered this problem? [...] 20308 17 24_DB2 Connect Alternatives10_Vinson Lee19_vlee@SDCCD.CC.CA.US31_Tue, 25 Jul 2000 18:13:13 -0700514_iso-8859-1 We were wondering what other sites were using as alternatives to IBM's DB2 Connect and Neon Systems' Shadow Direct for ODBC connections from the PC to the Host. We are currently running DB2 version 4.1 and OS/390 version 2.5.



Thanks for the 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. 20326 110 41_Re: DB2, RACF, and Authorization Checking13_Adrian Talbot29_Adrian.Talbot@BANKWEST.COM.AU31_Wed, 26 Jul 2000 09:12:26 +0800407_us-ascii Hi Bill,

From memory you need to check your CICS RCT and what AUTH= parameter you have set. Sounds like you are running with AUTH=USER. Worth noting that if you don't specify AUTH= , I believe that the default is USER.

This then runs the Plans under the individual users access and I believe that it doesn't consider access which they get via GROUPS (need AUTH=GROUP for this?). [...] 20437 63 46_Los Angeles Area DB2 User Group meeting notice16_Palmer, Ronald B29_Ronald.Palmer@WEST.BOEING.COM31_Tue, 25 Jul 2000 20:25:43 -0700342_- For those of you in the Southern California area --



The August 3rd meeting of the Los Angeles Area DB2 User Group will feature a presentation by Fabian Pascal.

> Fabian Pascal has a national and international reputation as > an independent database industry analyst and critic, > consultant, author and lecturer. [...] 20501 22 41_Re: DB2, RACF, and Authorization Checking12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Wed, 26 Jul 2000 15:50:38 +1200549_us-ascii Hi Bill,

I think you might need to check your RCT parms, specifically the AUTH parameter on the TYPE=ENTRY entry. If it says something like AUTH=(USERID,,) then the primary authid is checked for the authority to run the plan. This might be what's going on.

HTH,



Raymond

================================================ 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. 20524 62 19_Re: Data Page Limit12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 26 Jul 2000 17:11:04 +1000354_- That's because CA bought out Platinum, and things just go down hill.

(.... ;-), just joking before I get flamed)

Seriously though the same basic functionality is in 3rd party utils that is in DB2. So I would tend to look for potential reasons why you blew the max size of a partition (4G for a Large Ptn - 1M x 4K pages, in DB2 V5). [...] 20587 35 34_Reference for DB2/390, USS and C++0_20_vpacheco@AMADEUS.NET31_Wed, 26 Jul 2000 09:17:52 +0100586_us-ascii Hello DBA Community

We are deploying a big SAP Project. And for the feeding part (from our legacy systems) we adopted a 'strange' platform: OS/390 USS, C++ and DB2/390. Not that any of this components is strange, but the combination seems to be the 'first in the world'.

Do you know anyone (company or Project) that has adopted this same combination? Do you know anyone that is using any combination of two of the above elements (USS and C++, USS and DB2, C++ and DB2)? Could you provide some references I could contact in order to address some questions to [...] 20623 79 27_AW: Update of Index Columns12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 26 Jul 2000 10:21:53 +0200710_iso-8859-1 Carol,

you should limit updating index columns. When you update columns in indexes, a corresponding update is applied to all indexes in which the column participate. Updating index columns can have a substantial impact on performance due to the the additional I/O overhead.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 20703 26 22_IDMS Vs DB2 Comparison15_Selvi Manjunath31_selvi.manjunath@HPSBLR.SOFT.NET31_Wed, 26 Jul 2000 14:17:01 +0500527_- Hi,

Would like to have details on IDMS versus DB2 comparison. The elements to cover would be the following.

* Products support (development tools, query tools, etc.) * Operating costs (license costs, vendor maintenance costs) * Skills availability in the market (IDMS skills Vs DB2 skills) * Ease of making database changes (e.g.. how much time & effort it takes to insert a new column to a record in IDMS Vs DB2) * Ease of programming (i.e.. writing new programs against IDMS Vs writing them against DB2) [...] 20730 45 28_Re: DB2 Connect Alternatives12_Geert Placke23_Geert.Placke@MERANT.COM31_Wed, 26 Jul 2000 10:26:54 +0100443_- Vinson,

you can take a look at http://www.merant.com. You find the information about DataDirect SequeLink products under PRODUCTS - MERANT DataDirect - SequeLink 5.0.

Or go directly to the fact sheet of SequeLink 5.0 for OS/390: http://www.merant.com/products/datadirect/shared/techdocs/tb/sl50_db2_os390. asp



Geert Placke. Development Manager DataDirect

Tel: +32 - 15 30 77 82 Fax +32 - 15 32 12 60 [...] 20776 64 18_Re: Reporting Tool0_19_mike.holmans@BT.COM31_Wed, 26 Jul 2000 12:07:51 +0100412_- Yesterday I was at a meeting to investigate moving one of our systems from DB2 on OS/390 to Oracle on Unix. The prime motivation for doing this, it emerged, was that there are much better reporting facilities available with Oracle. Currently the application uses Focus. There are some other considerations involved, but what has driven the users up the wall with their system is the uselessness of Focus. [...] 20841 45 88_Re: August 9th - Performance Estimation Class - Tim Lenahan - Last call for registration12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 26 Jul 2000 11:15:35 GMT636_- Cathy,

I will be unable to attend this class. I believe I had indicated interest, but we have a major project going into production that week and I am unable to take the time off.

See you next time! Craig



>From: Cathy Peck >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: August 9th - Performance Estimation Class - Tim Lenahan - Last > call for registration >Date: Tue, 25 Jul 2000 16:41:44 -0400 > >If you are interested in attending the Performance Estimation class being >held in Central PA on August 9th, and you have not already [...] 20887 58 37_Re: Data Joiner and Stored Procedures11_David Ayers24_david.ayers@HIGHMARK.COM31_Wed, 26 Jul 2000 07:59:47 -0400386_us-ascii Dean, to the best of my knowledge datajoiner does support sp's. The DJ application programming and SQL reference supplement pg 95. is an example c program that invokes a sp on dj (note that the sp must be identified to dj via the CREATE STORED PROCEDURE NICKNAME)

hth -dfa







db46@DAIMLERCHRYSLER.COM@RYCI.COM> on 07/25/2000 03:42:11 PM [...] 20946 120 27_Re: Update of Index Columns19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 26 Jul 2000 07:13:27 -0500438_iso-8859-1 Hi Carol, I agree with Georg's comment. If performance is of no concern to this programmer or the program's users, encourage the programmer to continue just the way they've been doing and forget it. Ignorance is bliss. Otherwise, they should only select the columns they need and only change the columns that must be. "Generalized Update Routines" are sometimes known to suffer concurrency problems and be bad performers. [...] 21067 52 26_Re: IDMS Vs DB2 Comparison19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 26 Jul 2000 07:19:47 -0500595_iso-8859-1 Are the questions rhetorical . . .

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." [...] 21120 33 28_Re: DB2 Connect Alternatives27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 26 Jul 2000 07:20:52 -0500586_- At my previous job, we used StarQuest's StarSQL. It was very easy to administer, had very few problems, and the support staff is great!

> -----Original Message----- > From: Vinson Lee [SMTP:vlee@SDCCD.CC.CA.US] > Sent: Tuesday, July 25, 2000 8:13 PM > To: DB2-L@RYCI.COM > Subject: DB2 Connect Alternatives > > We were wondering what other sites were using as alternatives to IBM's DB2 > Connect and Neon Systems' Shadow Direct for ODBC connections from the PC > to > the Host. We are currently running DB2 version 4.1 and OS/390 version > 2.5. > > > Thanks for the info. [...] 21154 44 26_Re: IDMS Vs DB2 Comparison13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 26 Jul 2000 08:31:00 -0400679_us-ascii If you search the archives of this listserv at http://jupiter.ryci.com/archives/db2-l.html you'll find a spirited discussion of the differences between IDMS and DB2.



> -----Original Message----- > From: Selvi Manjunath [SMTP:selvi.manjunath@HPSBLR.SOFT.NET] > Sent: Wednesday, July 26, 2000 5:17 AM > To: DB2-L@RYCI.COM > Subject: IDMS Vs DB2 Comparison > > Hi, > > Would like to have details on IDMS versus DB2 comparison. > The elements to cover would be the following. > > * Products support (development tools, query tools, etc.) > * Operating costs (license costs, vendor maintenance costs) > * Skills availability in the market (IDMS skills Vs [...] 21199 15 14_Re: Shark Disk14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 26 Jul 2000 08:31:38 -0400335_ISO-8859-1 Get the IBM documentation - it's available in PDF format from the web. Regards, Joel

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 21215 88 18_Re: Reporting Tool12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Wed, 26 Jul 2000 07:48:44 -0500499_ISO-8859-1 Mike - I know you were not asking for information on reporting tools - but assuming you have a network with windows machines you can download a demo of QMF for Windows and show them how easy it is to use. It is so much better than the old mainframe based QMF, but we have both and our users have access to all of the queries they created there. In fact they still store their libraries on the mainframe and if the network is down can find a dumb terminal to still run their reports. [...] 21304 120 38_Re: DB2 version 6 - migration question0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 26 Jul 2000 07:52:37 -0500399_iso-8859-1 We will download the Fixpack 14 of CAE and test on it to see if the problem goes away. We are currently using MDAC level 2.1 which is older than yours.

Larry Kirkpatrick









Myron Miller cc: Sent by: DB2 Subject: Re: DB2 version 6 - migration question Data Base Discussion List [...] 21425 114 76_Re: Changing underlying VSAM high level qualifiers for DB2 table and indices0_29_paul.packham@POSTOFFICE.CO.UK31_Wed, 26 Jul 2000 14:47:17 +0000345_us-ascii Don,

This process will work, however please be aware of PQ36136 which details with problem "ALTER INDEX USING STOGROUP to change from user-managed to DB2-managed does not update SYSINDEXPART.STORTYPE from 'E' to 'I' as it should".

We have been hit by this (DB2 V6.1) and its a real pain. We are still awaiting a fix. [...] 21540 108 30_Re: DB2 Connect SYSPLEX option13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 26 Jul 2000 08:55:31 -0500380_iso-8859-1 Leon,

Thanks for the info on Connection Concentrator! We do have a mix of long running/short running threads. Also, good idea on MAXDBAT, hopefully WLM will know not to route work there (and maybe cause a failure due to MAXDBAT=0).

Any comment on why distributed work receives -913's instead of the -911's the same SQL receives when run on the host? [...] 21649 176 29_SQLCODE -911 and SQLCODE -91312_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 26 Jul 2000 16:13:19 +0200727_iso-8859-1 Dave,

SQLCDE -911 (SQLSTATE 40001) is a deadlock or timeout with automatic rollback. (= no decision has to be done by the application.

SQLCODE -913 (SQLSTATE 57033) is a deadlock or timeout WITHOUT automatic rollback. The app has to decide what to do in this case........

HTH.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 21826 20 29_A question about bind/package24_Jose Manuel Ayala Wilson18_jayala@HERDATA.COM31_Wed, 26 Jul 2000 16:15:22 +0200477_us-ascii Hi everybody,

My question is the following:

Do the DB2 routines must have binds ? I know that ones have packages but sometimes I am in doubt whether they must need binds too.

Thanks in advance, Jose Manuel

================================================ 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. 21847 173 33_Re: SQLCODE -911 and SQLCODE -91312_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 26 Jul 2000 14:21:21 GMT481_- DAVE,

It should be mentioned that a -913 is valid with CICS apps only where the ROLLBI in the RCT for that Transaction was defined as 'NO'. This forces the application to do a manual 'backout'. In all other cases, the user should get a -911. I don't know of any other case where a -913 is possible. Anyone else? (I have seen PeopleSoft with error messages of -913 but they are actually -911 in the DB2 logs and are simply reported incorrectly by the PS application.) [...] 22021 261 33_Re: SQLCODE -911 and SQLCODE -9130_20_John_Lendman@FPL.COM31_Wed, 26 Jul 2000 10:31:49 -0400708_iso-8859-1 In SAP you receive a -913 when there is deadlocks. John







"craig patton" @RYCI.COM> on 07/26/2000 10:21:21 AM

Please respond to "DB2 Data Base Discussion List"

Sent by: "DB2 Data Base Discussion List"



To: DB2-L@RYCI.COM cc:

Subject: Re: SQLCODE -911 and SQLCODE -913



DAVE,

It should be mentioned that a -913 is valid with CICS apps only where the ROLLBI in the RCT for that Transaction was defined as 'NO'. This forces the application to do a manual 'backout'. In all other cases, the user should get a -911. I don't know of any other case where a [...] 22283 36 43_Params not seen in Stored procedure builder12_Raj, Dominic25_DRaj@FALLSCHURCH.ESYS.COM31_Wed, 26 Jul 2000 10:18:25 -0400333_iso-8859-1 We are using the stored procedure builder (SPB) (Special Preview 2).

We have created 2 Cobol OS/390 stored procedures, one without Parms (MEDSP001) and the other with Parms (MEDSP002) under Schema DBA$MED. Both are under the same collection with the same privileges. My id (TL78) is in the RACF group DBA$MED. [...] 22320 264 33_Re: SQLCODE -911 and SQLCODE -91320_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 26 Jul 2000 10:37:24 -0400499_iso-8859-1 TSO, CAF and RRSAF should usually return -911 in the event of a deadlock, DB2 tries to ROLLBACK the work. If DB2 is successful then -911 is issued, if ROLLBACK fails (for some reason) -913 is returned.

In case of CICS ROLLBI parameter dictates -911 or -913 as Craig mentioned.

-Venkat

-----Original Message----- From: craig patton [SMTP:prgpatton@HOTMAIL.COM] Sent: Wednesday, July 26, 2000 10:21 AM To: DB2-L@RYCI.COM Subject: Re: SQLCODE -911 and SQLCODE -913 [...] 22585 26 27_8K and 16K usable page size14_Lisa Ouellette29_Lisa.Ouellette@FIRSTUNION.COM31_Wed, 26 Jul 2000 09:21:35 -0500509_- I'm looking for tables that could benefit from 8K and 16K page sizes. In the DB2 V6 Admin Guide:



1. Usable page size is the page size less 22 bytes of overhead (that is, 4074 for 4 KB pages, 8116 for 8 KB pages, 16308 for 16 KB pages, or 32746 for 32 KB pages) multiplied by (100-p) / 100, where p is the value of PCTFREE. If your average record size is less than 16, then usable page size is 255 (maximum records per page) multiplied by average record size multiplied by (100-p) / 100. [...] 22612 68 19_Re: Data Page Limit11_Robert Jans21_Jans.Robert@AMSTR.COM31_Wed, 26 Jul 2000 08:29:00 -0600485_- Actually, what Fastload is telling you is that you have hit the dataset size limit in partition 19. You have a few options at this point: 1) compress it 2) repartition

Option 1 would be my first choice, just alter to compress yes and reorg/reload. (I'm assuming you're doing a load replace) The other option require dropping and recreate unless you have tools to help with repartitioning. You mentioned this is defined as LARGE tablespace so that's not an option for you [...] 22681 27 39_Problem with program binded DEGREE(ANY)15_Michele Granito29_michele.granito@ISTRUZIONE.IT31_Wed, 26 Jul 2000 16:46:00 +0200462_iso-8859-1 I've probem with some programs binded with DEGREE(ANY) option. I'm in DB2 V5.1 and applied PTF UQ40842 but the problem is not resolved. If I rebind with DEGREE(1) the program works without abend.

Anybody had experience with the same problem?

Tkanks in advance.

Michele Granito EDS Italy Delivery Via Maremmana Superiore, 29 Monteporzio Catone (RM) tel. +39 06 9402392 fax +39 06 9402237 e-mail: michele.granito@istruzione.it [...] 22709 57 43_Re: Problem with program binded DEGREE(ANY)15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 26 Jul 2000 17:00:15 +0100552_us-ascii Hello Michelle,

Can you be a little more specific about the symptoms you have with degree(any). Also, what kind of parallelism are you getting? I/O, CPU, sysplex?

Regards,

Toine Michielse





Michele Granito @RYCI.COM> on 07/26/2000 03:46:00 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Problem with program binded DEGREE(ANY) [...] 22767 58 43_Re: Problem with program binded DEGREE(ANY)16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Wed, 26 Jul 2000 08:06:24 -0700440_us-ascii Michele,

When you indicate that you've had problems with programs bound with DEGREE(ANY), could you tell me what you have experienced (sqlcodes/reason codes)? We have had situations here where we too have had application abends when DEGREE(ANY) was used.

Regards, Jeff L'Italien American Express





From: "Michele Granito" @RYCI.COM> on 07/26/2000 04:46 PM ZE2 [...] 22826 135 30_Re: DB2 Connect SYSPLEX option0_15_leon@CA.IBM.COM31_Wed, 26 Jul 2000 11:04:13 -0400413_us-ascii Dave, I don't have any wisdom on why -913 is more common for distributed vs. -911 for host applciations. I wil ask arround to see if there is a good explanation.

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



"Shapiro, Dave" on 07/26/2000 09:55:31 AM

Please respond to DB2 Data Base Discussion List [...] 22962 136 32_Re: Stored Procedure Performance0_15_leon@CA.IBM.COM31_Wed, 26 Jul 2000 11:26:27 -0400581_us-ascii This is a summary of the thoughts on the stored procedures subject from some of the IBM brightest (no, it is not me, I don't pretend to be in that category ;-) ):

- Yes, there is additional overhead when you use a stored procedure to invoke an SQL statement compared to running that single SQL statement outside the stored procedure. If you run 100 SQL INSERT statements as 100 CALLs to a stored procedure (where each stored procedure does one INSERT), your performance will degrade. This would also be true if you implemented each SQL statement as a separate [...] 23099 17 30_Do we need WLM to use DSNTPSMP12_Raj, Dominic25_DRaj@FALLSCHURCH.ESYS.COM31_Wed, 26 Jul 2000 10:59:58 -0400411_iso-8859-1 Do we need WLM enabled stored procedure region to implement DSNTPSMP?

Can we use this under DB2 enabled stored procedure region?

Thanks, Dominic

================================================ 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. 23117 29 59_How to get value of INSERTed NOT NULL WITH DEFAULT column ?13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Wed, 26 Jul 2000 16:54:16 +0100291_us-ascii I'm writing an application which inserts a row into a table with a field defined as "NOT NULL WITH DEFAULT" (or possibly an generated IDENTITY column in UDB V7).

We need to know what the generated value was, as we intend to use it as part of the key for "child" tables. [...] 23147 44 88_Re: August 9th - Performance Estimation Class - Tim Lenahan - Last call for registration8_sncmonty18_sncmonty@YAHOO.COM31_Wed, 26 Jul 2000 09:33:29 -0700619_us-ascii do you have classes in San Francisco.? --- Cathy Peck wrote: > If you are interested in attending the Performance > Estimation class being > held in Central PA on August 9th, and you have not > already registered, > please let me know ASAP. > > Check out the details on Tim & the course on the > Central PA DB2 Users Group > webpage at: http://www.db2parug.org > > Tks! Seeya > > ================================================ > To change your subscription options or to cancel > your subscription visit the DB2-L webpage at > http://www.ryci.com/db2-l. The owners of the list [...] 23192 73 40_Re: Strange But True Connection Failures12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Wed, 26 Jul 2000 13:27:02 -0400353_iso-8859-1 Peter,

We went through something similar last year and we posted to the listserv.....

Our problem was a little bit different in that we had S0C4's reported by DB2 on the host and DRDA dumps on the DB2 Connect server. One of our DBAs discovered the problem with the collection IDs after a lot of hard work and head banging! [...] 23266 151 41_Re: DB2, RACF, and Authorization Checking0_22_BILL_GALLAGHER@PHL.COM31_Wed, 26 Jul 2000 13:28:03 -0400575_us-ascii Adrian,

Thanks for the info, but I think you missed the point of my question. Let me re-phrase:

If the plan being executed is already granted EXECUTE to PUBLIC (i.e. the plan is defined in the MDSNPN RACF class with a UACC(READ)), then why are we getting RACF warnings for the users against the tables being accessed within the plan? The tables are being accessed via statically bound SQL within the packages in the PKLIST of the plan, so there shouldn't be any authorization checking for the tables being done at execute time (as far as I know). [...] 23418 32 14_SAP ListServ ?0_20_John_Lendman@FPL.COM31_Wed, 26 Jul 2000 13:32:40 -0400445_us-ascii Any one know if the SAP listserv is down. I tried to post a question and my mail server said it could not connect.

I will go ahead and post it here, So if you are a SAP DB2 person read on:

In the SAP DBA manual, there is a section that talks about the DB Alert Monitor. Some of the information that you should be able to get from SAP via the oscollector is Backup, OptimizerStatistics, DBSystemCheck,SpaceManagement. [...] 23451 22 23_number of Changed Pages21_Rechsteiner, Tom (TH)20_trechsteiner@DOW.COM31_Wed, 26 Jul 2000 13:34:53 -0400378_iso-8859-1 Hi,

The COPY with CHANGELIMIT REPORTONLY will give you a report of Image Copy Information, which has the number of Changed Pages for the tablespace. Is this the only IBM option to find the number of Dirty pages for a tablespace?

(I am hoping to either find it in the Catalog after runstats or via a listcat, although any help would be appreciated) [...] 23474 13 11_DB2 Connect13_Toppins, Mike19_MToppins@UNIPAC.COM31_Wed, 26 Jul 2000 11:35:23 -0600342_iso-8859-1 Is there a "version" of DB2 Connect to talk to SQL Server? I know there's one for Oracle.

================================================ 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. 23488 98 19_Re: Data Page Limit0_20_bjnigh@HOUSEHOLD.COM31_Wed, 26 Jul 2000 10:39:38 -0700361_us-ascii Nick,

We did indeed add 5 additional columns to the end of the record and then repopulated the partition. The tablespace is compressed and defined as LARGE. I called Platinum and according to the listcat on the tablespace, we have indeed reached the 4 Gig limit. The listcat shows the HI-U-RBA------4246585344. They told me this was 4 Gig. [...] 23587 171 41_Re: DB2, RACF, and Authorization Checking13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 26 Jul 2000 13:51:11 -0400625_iso-8859-1 What about the bind parm VALIDATE(RUN) versus VALIDATE(BIND)?

> -----Original Message----- > From: BILL_GALLAGHER@PHL.COM [SMTP:BILL_GALLAGHER@PHL.COM] > Sent: Wednesday, July 26, 2000 1:28 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2, RACF, and Authorization Checking > > Adrian, > > Thanks for the info, but I think you missed the point of my question. Let > me re-phrase: > > If the plan being executed is already granted EXECUTE to PUBLIC (i.e. the > plan is defined in the MDSNPN RACF class with a UACC(READ)), then why are > we getting RACF warnings for the users against the tables being accessed [...] 23759 179 41_Re: DB2, RACF, and Authorization Checking22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 26 Jul 2000 13:52:21 -0400561_iso-8859-1 This is a wild guess and I don't know if you need it or that it can be done but...

Did you do the RACF equivalent of a DB2 GRANT EXECUTE ON PACKAGE collection-id.* TO PUBLIC in addition to UACC(READ) on the plan?



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





-----Original Message----- From: BILL_GALLAGHER@PHL.COM [mailto:BILL_GALLAGHER@PHL.COM] Sent: Wednesday, July 26, 2000 13:28 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2, RACF, and Authorization Checking [...] 23939 336 33_Re: SQLCODE -911 and SQLCODE -91319_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 26 Jul 2000 11:05:45 -0500603_iso-8859-1 Hi Venkat, Could you please give a specific example where a -911 was expected but DB2 returned a -913. I have never seen what you describe happen. Just lucky I guess.

Regards, Rick

"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 [...] 24276 28 22_DB2 on OS/390 from WEB12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 26 Jul 2000 12:57:00 -0400368_- I asked this ? several weeks ago and got great responses. Thanks to all who responded. But, I have more ?s. The ?s I have now are how are you handling security in this scenario. Is there just one ID that connects to DB2 connect from the WEB server? Or, are there separate logon IDs from the WEB server for each OS/390 user? Are you using encryption and/or DCE? [...] 24305 48 27_Re: number of Changed Pages12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 26 Jul 2000 18:04:14 GMT329_- Tom,

A DSN1PRNT (or DSN1COPY) of the space map page(s) can give you the same information, albiet in a formatted dump. Other than that, I can't think of any other 'IBM' process. There are some other utilities by 3rd party vendors that can provide this information in formatted reports (with conditioning available). [...] 24354 22 29_VSAM RLS Record Level Sharing17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM31_Wed, 26 Jul 2000 14:10:11 -0400399_- I know this is not about DB2, but thought somewhere here might know or be able to steer me to the right place.

Does anyone know where I can find out about VSAM RLS (Record Level Sharing)? I need some information about it's features, benefits, limitations, requirements, etc. (I've heard it uses the MVS Sysplex Coupling Facility to allow provide VSAM users with record level sharing). [...] 24377 35 15_Re: DB2 Connect22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 26 Jul 2000 14:13:25 -0400463_iso-8859-1 What "version" of D2 Connect do you use to talk to Oracle?



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





-----Original Message----- From: Toppins, Mike [mailto:MToppins@UNIPAC.COM] Sent: Wednesday, July 26, 2000 13:35 To: DB2-L@RYCI.COM Subject: [DB2-L] DB2 Connect



Is there a "version" of DB2 Connect to talk to SQL Server? I know there's one for Oracle. [...] 24413 50 15_Re: DB2 Connect13_Toppins, Mike19_MToppins@UNIPAC.COM31_Wed, 26 Jul 2000 12:16:22 -0600639_iso-8859-1 Don't know. Got the info from IBM sales rep. Haven't personally tried it.

-----Original Message----- From: Piontkowski Michael ML [mailto:michael.piontkowski@ASTRAZENECA.COM] Sent: Wednesday, July 26, 2000 12:13 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect



What "version" of D2 Connect do you use to talk to Oracle?



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





-----Original Message----- From: Toppins, Mike [mailto:MToppins@UNIPAC.COM] Sent: Wednesday, July 26, 2000 13:35 To: DB2-L@RYCI.COM Subject: [DB2-L] DB2 Connect [...] 24464 47 33_Re: VSAM RLS Record Level Sharing22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 26 Jul 2000 14:46:37 -0400558_iso-8859-1 From http://www.storage.ibm.com/software/sms/smshome.htm Click on DFSMSdfp and there are links to the books.



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





-----Original Message----- From: Scarcella, Gary V [mailto:ScarcellaGV@AETNA.COM] Sent: Wednesday, July 26, 2000 14:10 To: DB2-L@RYCI.COM Subject: [DB2-L] VSAM RLS Record Level Sharing



I know this is not about DB2, but thought somewhere here might know or be able to steer me to the right place. [...] 24512 68 15_Re: DB2 Connect14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Wed, 26 Jul 2000 13:59:46 -0500455_iso-8859-1 Your rep is probably talking about DataJoiner, which is similar to DB2 Connect, performs the same functions plus some, and does talk to either Oracle or SQL Server (in addition to DB2) by the purchase of additional pieces and licenses.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Toppins, Mike Sent: Wednesday, July 26, 2000 1:16 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect [...] 24581 53 32_Performance problems - any tips?0_23_edie.richardson@SRS.GOV31_Wed, 26 Jul 2000 15:05:34 -0400553_us-ascii We just downgraded our mainframe (I know... wrong direction) from an IBM 9672-R73 to an IBM 9672-R24, from 130 MIPS to 86 MIPS, Model Group 60 to Model Group 40 and from 7-way to 2-way configuration.

We are running db2 v4.1. Since the downgrade we have noticed that our batch programs CPU time has decreased but our elasped time has really increased. I'm not very experienced in performance and tuning and I'm not really sure where to begin. I have DB2 PM but I'm not very well versed in it. The only thing I know how to do is look [...] 24635 20 16_Stored Procedure16_Proctor, William25_william.proctor@TGSLC.ORG31_Wed, 26 Jul 2000 14:19:51 -0500360_iso-8859-1 Hello, We are making our first attempt at creating a stored procedure in DB2 UDB V6.1 and we are getting the following error. SQL1109n 'The specified dll 'Uniqueid' could not be loaded' . Does anyone have an ideal of what the problem is? Thanks in advance for all replies.

Bill Proctor Adabas/DB2 DBA Texas Guaranteed Student Loan Corp. [...] 24656 70 36_Re: Performance problems - any tips?12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 26 Jul 2000 13:01:01 -0700579_us-ascii Have you looked at RMFWDM (RMF workload delay monitor) to see the delays for the batch jobs? In other words, this tool (assuming your systems people have it started and setup) will show where your batch job is spending its time, especially shows delays causing increased elapsed time.

Since you went from a 7 way with each engine about 25 mips to a 2 way with each engine about 45 mips, I can easily see why the CPU time for the batch jobs decreased. But with the significantly decreased number of engines, it wouldn't surprise me to see significant amounts [...] 24727 53 36_Re: Performance problems - any tips?12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 26 Jul 2000 23:30:51 +0200484_x-user-defined Hi, First - rebind. Second - You are short on CPU and there are waits for it, so this explains the increase in elapse time, before the change you could have 7 jobs running and using cpu at the same time, now you can have only two, so the rest wait. Your sysprog should look for tuning in goal mode definitions (if you use it) and lowering the number of batch partitions. Each cpu is much stronger (nearly double) so you need less cpu time to do the same activity. [...] 24781 44 36_Re: Performance problems - any tips?0_17_JTonchick@AOL.COM29_Wed, 26 Jul 2000 16:29:14 EDT353_US-ASCII In a message dated 07/26/2000 2:12:50 PM Central Daylight Time, edie.richardson@SRS.GOV writes:

<< We are running DB2 v4.1. Since the downgrade we have noticed that our batch programs CPU time has decreased but our elapsed time has really increased. >>

Ediei, this is exactly what I would expect. Less MIPS = longer runtime. [...] 24826 100 15_Re: DB2 Connect0_15_leon@CA.IBM.COM31_Wed, 26 Jul 2000 16:42:35 -0400337_us-ascii Well, the IBM rep is most likely is talking about DB2 Connect V7.1 and the optional piece called DB2 Relational Connect. V7.1 of DB2 Connect incorporates Distributed Join function that allows you to reference tables on Oracle and DB2 in the same select statement. This is the same function that is available in DataJoiner. [...] 24927 19 31_Varchar(32672) vs. Long Varchar7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Wed, 26 Jul 2000 15:27:40 -0500372_- Hi everyone,

I am just wondering what the differenc is between a column defined as varchar and long varchar. The byte difference is 28 bytes.

I know that to define a column of varchar(32672), your tablespace pagesize needs to be defined as 32k. This also applies to the pagesize of its bufferpool. However, LONG VARCHAR does not require these values. [...] 24947 47 35_Re: Varchar(32672) vs. Long Varchar9_Wu, James13_jwu@KRAFT.COM31_Wed, 26 Jul 2000 16:13:49 -0500410_- Varchar(n) has an maximum length of n bytes while LONG VARCHAR has 'no fixed Limit'. The length of LONG VARCHAR depends on the number of all LONG VARCHAR columns and whatever is left by the fixed and varchar columns. E.g. if the pagesize is 32k, and all fixed length and varchar columns use up 10 k, then the length of each LONG VARCHAR column will be 22K divided by the number of LONG VARCHAR columns. [...] 24995 331 33_Re: SQLCODE -911 and SQLCODE -91313_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 26 Jul 2000 16:34:09 -0500383_iso-8859-1 Rick,

If for example you issue a lock table stmt in spufi, with option 8 autocommit set to NO, then, from another TSO session you attempt an SQL stmt on that table, you will receive a -911.

However, if you issue the same SQL from, say, DB2 for NT Command Center (or any distributed app using DB2 Connect i.e. Peoplesoft or SAP) you will receive a -913. [...] 25327 61 26_Re: V6 Stored proc problem23_Lee, Kenneth (Exchange)14_kmlee@BEAR.COM31_Wed, 26 Jul 2000 18:06:48 -0400549_- We have DB2 Connect and have a numerous problems with DB2 V6 OS/390 stored procedure as well.

> -----Original Message----- > From: Robert Jans [SMTP:Jans.Robert@AMSTR.COM] > Sent: Tuesday, July 25, 2000 2:16 PM > To: DB2-L@RYCI.COM > Subject: V6 Stored proc problem > > Hi, listers! > We just migrated to DB2 V6 OS/390 on the weekend and have now encountered > a > strange problem. We use Delphi as a front end and Neon Shadow as the > gateway. > The users can connect and run a stored proc once but are unable to execute > any > more [...] 25389 34 28_Re: Turn of Archive logging!13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Wed, 19 Jul 2000 13:30:32 -0700436_iso-8859-1 Does DB2 allow that ? Would be a surprise to me. You can of course 'overwrite' the same archive log dataset again and again.

Ashish.

-----Original Message----- From: Jeff Faughn [SMTP:Jeff_Faughn@MAY-CO.COM] Sent: Wednesday, July 19, 2000 12:30 PM To: DB2-L@RYCI.COM Subject: Turn of Archive logging!

Does anyone know the ZPARM setting to stop Archive logging on a TEST system in DB2 ver 6.1... : ) [...] 25424 16 32_Re: Urgent solution required....0_27_Bud.Greenman@ONONDAGA.NY.US31_Wed, 19 Jul 2000 19:18:00 -0400556_us-ascii just declare the cursor as select .... order by pkey descending

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

================================================ 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. 25441 86 61_FW: Bloor Research: "IBM Drags DB2 into the e-commerce Arena"13_Morrill, John12_JohnM@VP.NET31_Wed, 19 Jul 2000 17:28:03 -0600394_iso-8859-1 Dear DB2 Interested Parties,

I thought that I had sent this report to you back in April, but apparently not. It's worth a look (was written based on a pre-announce DB2 V7 briefing for analysts). Check out the Web site at IT-Analyst.com for this report and other interesting links/reports: http://www.it-analysis.com/00-04-13-1.html?its

Regards, Mike + + + + + + + [...] 25528 32 35_Re: Varchar(32672) vs. Long Varchar13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 26 Jul 2000 19:04:34 -0400442_iso-8859-1 Note also a drastic side-effect of Long Varchar.

Long Varchar essentially says use the rest of the page for this column. The implication of this is that it will be very difficult (impossible without extra-ordinary measures) to ever add another column to this table.

(If you try to Alter table... add long varchar column, you get SQLCODE = -670, ERROR: THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT) [...] 25561 19 35_Re: Varchar(32672) vs. Long Varchar13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Wed, 26 Jul 2000 18:07:51 -0500538_- >(If you try to Alter table... add long varchar column, you get >SQLCODE = -670, ERROR: THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE >LIMIT)

So, what performance dropoff should I expect for using CLOBS instead of 20K Varchars? (Assuming I keep away from Cold Fusion).

-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. 25581 95 27_IBM load utility ---- a bug23_AITHA, BHEEMSEN (SBCSI)22_BA2984@MSG.PACBELL.COM31_Wed, 19 Jul 2000 16:21:11 -0700398_iso-8859-1 Hi list,

We have a table with last column defined with NNWD(not null with default). The type is CHAR. Length is 1. We loaded this table using IBM load utility. The load file was incorrect in the sense that the last column contained NULLS (i.e. x'00' in the dataset when viewed with hex on). But the load didn't fail, neither there were any warnings too. Here is the output : [...] 25677 86 32_Re: Urgent solution required....23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Wed, 19 Jul 2000 23:17:46 -0000437_iso-8859-1 WITH caution THE pkey >= WOULD HAVE TO BE pkey <= and and order by pkey desc so you will have to be careful about indexing the table or use both a desc and ascending indexes .



Andrew Puddy



-----Original Message----- From: Vijay Subramanyam [mailto:vijay.subramanyam@HPSBLR.SOFT.NET] Sent: Thursday, 20 July 2000 3:52 To: DB2-L@RYCI.COM Subject: Urgent solution required.... Importance: High [...] 25764 27 38_SQL code -904 during tablespace create13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Wed, 26 Jul 2000 19:21:38 EDT713_- Hi list, Can someone help explain this -904 message for me. In general, and as a programmer,I understand resource not available, especially with application tables. But when it comes to DB2 datasets, I'm lost about what to do. Here's the error message I'm getting:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D70025, TYPE OF RESOURCE 0000022 RESOURCE NAME USERCAT.DSNDBC.DBSMT01.TSSMT001.I0001.A001 DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXICTS SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 105 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000069' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' [...] 25792 114 18_Re: Reporting Tool14_Duncan Gardner23_dgardner@GESB.WA.GOV.AU31_Thu, 27 Jul 2000 07:33:34 +0800571_- Mike,

There's good news and bad. The bad news is that Oracle takes 2-3 times as much effort to administer than DB2 and it'll cost more. In my experience the Oracle Application and Reporting tools are very tied to the physical database design. You can do a bit with views, but basically the database needs to be designed for the application rather than the logical data model or efficiency. The Oracle generator tools are very useful for quickly producing demos and prototypes, but once you really get down to it, you have to code a lot yourself - or rather [...] 25907 34 31_Re: IBM load utility ---- a bug13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 19 Jul 2000 19:38:08 -0400579_iso-8859-1 Hi Bheemsen,

You didn't load nulls. You loaded one byte of binary zeroes -- a perfectly legal value for a Char(1) field.

Nulls in DB2 tables are identified by the null-indicator and are only inserted into a column which has been defined as nullable.

Note that you can have the load utility load nulls(only into nullable columns, of course) with the Nullif parameter which tells the load utility to look for a special character in the input record. For instance, look at the nullif parms for PTN_ORIG_DT POSITION(125) and OPTN_EXP_DT POSITION [...] 25942 22 26_Installing a DB2 subsystem13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Wed, 26 Jul 2000 19:43:02 EDT347_- Hi List, I have been put in a tough situation and need to learn quickly. I like the challange but need assistance. I've been tasked to create a new DB2 subsystem for a special development and testing effort. Can someone give a crash course on how to install a second subsystem. I know it is a lot of work, but I need to know where to start [...] 25965 49 42_Re: SQL code -904 during tablespace create13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 26 Jul 2000 19:46:01 -0400692_iso-8859-1 Hi Carlton,

The process for investigatin -904 is fairly straightforward. The most useful piece of information is normally the Reason code. In this case, that's d70025. If I recall, that's frequently unable to extend the VSAM dataset.

Well, maybe. Msgs & codes says ------------------- System Programmer Response: Examine messages DSNP009I and DSNP010I on the operator's console for the access method services messages they encompass. Refer to the appropriate MVS publication for information about specific access method services messages received. ------------------- See if you can find those messages in the JES log or in the log to the ....MSTR address space [...] 26015 51 30_Re: Installing a DB2 subsystem12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Wed, 26 Jul 2000 19:00:22 -0500419_- You don't say what platform?

If this is DB2 for OS390 (or MVS) start with the Installation Guide. That's the only one I can help you with right now.

Carol Sutfin Corporate DBA AmSouth Bank N.A. (205)326-5214 csutfin@amsouth.com





Carlton Enuda on 07/26/2000 06:43:02 PM



Please respond to DB2 Data Base Discussion List [...] 26067 114 37_Re: AW: Clustering Indexes - Question0_29_Greg.Palgrave@BANKWEST.COM.AU31_Thu, 20 Jul 2000 08:10:46 +0800341_us-ascii It uses the one with the lowest OBID, which is not always the first one created, as OBIDs can be reused.

I believe that DB2 will not treat it as a clustering index for REORG etc - if you want it clustered, you need to explicitly define a clustering index. It's the only way to guarantee you get the clustering YOU want. [...] 26182 42 39_Re: RE : ADDING NEW VOLUMES TO STOGROUP20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 19 Jul 2000 14:56:07 -0400520_us-ascii Now we are on SMS but I remember the old days and answer to your question is yes it will.

-----Original Message----- From: Andre Cupido [SMTP:wcacu@WOOLWORTHS.CO.ZA] Sent: Wednesday, July 19, 2000 2:50 PM To: DB2-L@RYCI.COM Subject: RE : ADDING NEW VOLUMES TO STOGROUP Importance: High

Hi All

I need to fix a space problem pronto. If i were to add an additional volume to a specific stogroup , stop and start the tablespace , will the offending file extend to the newly added volume . [...] 26225 24 24_DB2 Connect Alternatives10_Shaw, Stan20_Stan.Shaw@DISNEY.COM31_Wed, 26 Jul 2000 16:57:49 -0700566_iso-8859-1 We our currently using StarQuest for ODBC connection to DB2 at the version 4 and 5 levels. They can be contacted at www.starquest.com . HTH.

Date: Tue, 25 Jul 2000 18:13:13 -0700 From: Vinson Lee > Subject: DB2 Connect Alternatives

We were wondering what other sites were using as alternatives to IBM's DB2 Connect and Neon Systems' Shadow Direct for ODBC connections from the PC to the Host. We are currently running DB2 version 4.1 and OS/390 version 2.5. [...] 26250 116 33_Re: Clustering Indexes - Question15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 19 Jul 2000 17:52:51 -0500533_iso-8859-1 Richard,

According to the doc, if no explicit clustering index exists, SORTDATA is ignored (DB2 V6 Utility Guide, p. 319). I haven't tested this myself.

Michael Murley BMC

-----Original Message----- From: Richard Yevich [mailto:ryevich@attglobal.net] Sent: Wednesday, July 19, 2000 4:26 PM To: DB2-L@RYCI.COM Subject: Re: Clustering Indexes - Question



You only need to specify SORTDATA on the REORG I believe to get around the problem when you have not defined a clustering index. [...] 26367 79 37_Re: AW: Clustering Indexes - Question14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 19 Jul 2000 20:11:03 -0400540_iso-8859-1 Sorry, unless something has really changed -- the index picked for INSERTS, when there is no clustering index, is based on a control block chain, in the DBD, in the EDM pool, at run time according to IBM doc and tests done years ago. It has nothing to do with the OBID. The oldest living index will be the first one in the chain of control blocks. Drop and recreate, with no intervening stuff happening, and it may actually stay in the same place in the chain, but generally moves to the bottom of the list. The OBID may or [...] 26447 150 33_Re: Clustering Indexes - Question14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 19 Jul 2000 19:03:44 -0400729_iso-8859-1 According to the document referenced, you are correct and I am wrong. That is one of those things that I know I read somewhere along the way, but never tested either.

Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net http://www.YLAssoc.com -- DB2 Performance Journal http://www.ryci.com -- RYC Knowledge Database http://www.DB2-Portal.com



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Murley, Michael > Sent: Wednesday, July 19, 2000 6:53 PM > To: DB2-L@RYCI.COM > Subject: Re: Clustering Indexes - Question > > > Richard, > > According to the doc, if no explicit clustering index exists, SORTDATA [...] 26598 104 30_DB2 V4 Performance problem ...13_Myoungsoo Huh18_huhm@FARMERS.CO.NZ31_Thu, 27 Jul 2000 13:25:03 +1200305_iso-8859-1 HI all.

After Migrate DB2 V4 ,(OS390.2.4) , I met severe performance problem ..(Heavey SIO , in SDSF) and Omegamon shows heavy get page rate .. ( about 4 times(?) higher that V3)..

We didn't have any type2 Index yet , no new plan , didn't rebind any plans.. ( except SPUFI). [...] 26703 73 39_Dropped connections DB2 V-5 & web pages12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Wed, 26 Jul 2000 21:39:17 -0400582_ISO-8859-1

I'm hoping that someone can shed some light on an error we are getting when accessing DB2 Ver 5 through DB2 Connect from a web application. When the queries being executed run in less than a minute, everything works fine, but if the SQL takes over a minute, then the connection between DB2 and the web application is dropped before the results can be obtained, resulting in an error at the application. I believe there must be a timeout limit somewhere in the path that is being tripped, but can't find out where. The developer has the timeout parameter for [...] 26777 84 26_Re: DB2 on OS/390 from WEB12_troy Coleman20_Troy.Coleman@UAL.COM31_Wed, 26 Jul 2000 15:50:49 -0500448_- Is your shop using LDAP? DB2 Connect does support the use of LDAP. You can have a portal that all applications will go through. The portal would make the LDAP authentication and then pass you to the called application.

Most ACF2 and/or RACF administrators do not want to add thousands of userids into their mainframe security database. As a work around you may authenticate to LDAP and then pass information on to the called program. [...] 26862 150 33_Re: Clustering Indexes - Question13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Wed, 19 Jul 2000 15:58:49 -0700480_iso-8859-1 Well ,

That has been my understanding too all these years ; again I have not tested it.

Ashish.

-----Original Message----- From: Murley, Michael [SMTP:Michael_Murley@BMC.COM] Sent: Wednesday, July 19, 2000 3:53 PM To: DB2-L@RYCI.COM Subject: Re: Clustering Indexes - Question

Richard,

According to the doc, if no explicit clustering index exists, SORTDATA is ignored (DB2 V6 Utility Guide, p. 319). I haven't tested this myself. [...] 27013 45 20_Re: Stored Procedure13_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM31_Thu, 27 Jul 2000 08:48:22 +0530720_us-ascii William, Are you working on Windows NT or S390??? We have successfully created and running Stored procedure in DB2 V6.1 on S390. regards Mayank







"Proctor, William" on 27/07/2000 01:49:51 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Mayank Sharma/LTITL)

Subject: Stored Procedure





Hello, We are making our first attempt at creating a stored procedure in DB2 UDB V6.1 and we are getting the following error. SQL1109n 'The specified dll 'Uniqueid' could not be loaded' . Does anyone have an ideal of what the problem is? Thanks in advance for all replies. [...] 27059 81 42_Re: SQL code -904 during tablespace create11_K Mahadevan28_kmahadevan@CHENNAI.TCS.CO.IN31_Thu, 27 Jul 2000 09:07:51 +0530344_us-ascii Hi,

I think problem should be in your storage group. If you are using a storage group whose volumes are almost full already , then they may not have the required space to allocate the primary qty for this tablespace. Try to create some space in those by removing unwanted datasets or try to create in a different stogroup. [...] 27141 80 42_Re: SQL code -904 during tablespace create0_19_Tim.Lowe@STPAUL.COM31_Wed, 26 Jul 2000 18:38:58 -0500425_us-ascii Carlton, Just a few quick ideas/questions: Is this object stogroup-managed? Did this occur during a CREATE for a tablespace or index? Was the dasd request greater than what was available in your pool? Does the MVS usercat for this high-level qualifier exist? Does your data security system prevent your DB2 subsystem from creating this dataset? Are there any messages obout this in your DB2?DBM1 address space? [...] 27222 95 42_Re: SQL code -904 during tablespace create0_19_Tim.Lowe@STPAUL.COM31_Wed, 26 Jul 2000 18:58:07 -0500843_us-ascii Dave, I thought that an extend failure was a 00D70014, and a 00D70025 was a DEFINE failure. Do I have it backwards?

Thanks, Tim













"Seibert, Dave" on 07/26/2000 06:46:01 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Tim Lowe/sfm/spc)





Subject: Re: SQL code -904 during tablespace create















Hi Carlton,

The process for investigatin -904 is fairly straightforward. The most useful piece of information is normally the Reason code. In this case, that's d70025. If I recall, that's frequently unable to extend the VSAM dataset. [...] 27318 23 22_A DB2 connect Question9_SrinivasG17_SRINIVASG@INF.COM31_Thu, 27 Jul 2000 10:00:25 +0530423_iso-8859-1 Hi,

I am using UDB 6.1 on NT to connect to DB2 on OS/390. When users connect from Control Center to the Mainframe DB2 they are not able to see the Tables List although they Bind the DB2 utilities from Client Configuration assistant. But when I login using sysadm auth, I am able to see the Tables list. What specific authority needs to be given to the uses so that they can work with Control Center? [...] 27342 66 30_Re: Installing a DB2 subsystem9_SrinivasG17_SRINIVASG@INF.COM31_Thu, 27 Jul 2000 12:09:19 +0530583_- There is also the DB2 Installer CD.

> -----Original Message----- > From: Carol Sutfin [SMTP:csutfin@AMSOUTH.COM] > Sent: Thursday, July 27, 2000 5:30 AM > To: DB2-L@RYCI.COM > Subject: Re: Installing a DB2 subsystem > > You don't say what platform? > > If this is DB2 for OS390 (or MVS) start with the Installation Guide. > That's the only one I can help you with right now. > > Carol Sutfin > Corporate DBA > AmSouth Bank N.A. > (205)326-5214 > csutfin@amsouth.com > > > > Carlton Enuda on 07/26/2000 06:43:02 PM > > > Please respond to DB2 [...] 27409 66 34_Reference for DB2/390, USS and C++0_20_vpacheco@AMADEUS.NET31_Thu, 27 Jul 2000 09:08:02 +0100424_us-ascii Hello again DBA Community

Yesterday I have posted the note that follows in attachment. I have received only one direct answer: thanks to Isaac Yassin. And this reply did not 'qualify' for what I am investigating...

I know that this is not the best time of the year... and the question I have submitted is not so much interesting to you guys. The absense of replies is even worst than I though... [...] 27476 98 42_Re: SQL code -904 during tablespace create14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 27 Jul 2000 09:16:17 +0100603_us-ascii Hi Tim,

since I got the -904, 00D70025 over the last weekend, I can tell you that you're right; I decreased the Primary allocation and bingo, the index was created just fine.

Regards Ruediger

Tim.Lowe@STPAUL.COM schrieb: > > Dave, > I thought that an extend failure was a 00D70014, and a 00D70025 was a > DEFINE failure. > Do I have it backwards? > > Thanks, > Tim > > "Seibert, Dave" on 07/26/2000 06:46:01 PM > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > > cc: (bcc: Tim Lowe/sfm/spc) > > [...] 27575 139 34_Re: DB2 V4 Performance problem ...7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Thu, 27 Jul 2000 13:16:18 +0530398_iso-8859-1 I believe you should start playing with threshold little bit because VPSEQT is very high and most of your I/Os are synchronous in nature.I cann't say how the performance problems were not there in V3 (someone else may answer) but DB2 is using very less portion of pool for keeping the In-Use data pages and it is always stealed after the release page, which gives high I/O to disk. [...] 27715 113 38_AW: Reference for DB2/390, USS and C++12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 27 Jul 2000 10:16:42 +0200534_iso-8859-1 Vitor,

allow me a question: You're using the term USS. Does it mean OS/390 UNIX System Services ?

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 27829 146 18_Re: Reporting Tool13_Skelton Brian20_skelton.b@MELLON.COM31_Thu, 27 Jul 2000 05:03:33 -0400595_iso-8859-1 The bad news is that Oracle takes 2-3 times as much effort to administer than DB2 and it'll cost more

Mike,

Would you have any evidence to back this up. As I have some friends who are staring a new project and are considering Oracle & DB2.

Brian

> -----Original Message----- > From: Duncan Gardner [SMTP:dgardner@GESB.WA.GOV.AU] > Sent: Thursday 27 July 2000 00:34 > To: DB2-L@RYCI.COM > Subject: Re: Reporting Tool > > Mike, > > There's good news and bad. The bad news is that Oracle takes 2-3 times as > much effort to administer than DB2 and it'll [...] 27976 235 18_AW: Reporting Tool12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 27 Jul 2000 11:22:50 +0200772_iso-8859-1 Hi Brian,

not an evidence.... but there is an survey from the MetaGroup published in 1999. And they said ..to administer an Oracle database you need twice as much DBA's compared to an IBM database.....

(Source: A german IT journal named Informationweek 26/1999, page 38)

May be you find the analysis at http://www.metagroup.com/ With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 28212 26 16_Loss of LX Slots0_29_paul.packham@POSTOFFICE.CO.UK31_Thu, 27 Jul 2000 11:18:16 +0000484_us-ascii Hi,

I would like to make users of OS/390, DB2 & RRS aware of an issue.

We were hit with a problem running DB2 V6, SAP 4.6 & RRS where we ran out of LX Slots and were forced to IPL to free them up. This happened because we had multiple DB2 subsystems running on the same LPAR which were re-cycled each night to pack dump. Each time we dropped DB2 its asids were being marked as non re-usable. This was caused by RRS having a cross system connection to DB2. [...] 28239 68 20_Re: Loss of LX Slots23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 27 Jul 2000 11:51:50 +0100509_iso-8859-1 Paul

I do beleive there are a couple of fixes in the pipe line for this :

V6 ones ... V5 on their way.

1. PQ40021 for base code, and 2. PQ40022 for ERLY code.

Have not looked at them but will do later today .. only got the info thismorning.

all the best

Les

-----Original Message----- From: paul.packham@POSTOFFICE.CO.UK [mailto:paul.packham@POSTOFFICE.CO.UK] Sent: Thursday, July 27, 2000 12:18 PM To: DB2-L@RYCI.COM Subject: Loss of LX Slots [...] 28308 22 42_Re: SQL code -904 during tablespace create13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 27 Jul 2000 06:52:53 -0400619_iso-8859-1 Seems more likely that I have it backwards. It would be more reasonable that Define rather than Extend would be invoked during tablespace create.

I expect that Carlton can confirm this once he gets it resolved.

Thanks for the correction, Tim and Ruediger.

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. 28331 104 30_Re: Installing a DB2 subsystem15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 27 Jul 2000 07:05:45 -0400542_iso-8859-1 If this subsystem is on a separate LPAR, then you might be able to take an ADRDSSU dump of your entire DB2 subsystem datasets and restore it using ADRDSSU onto the new LPAR retaining all the same names.

If on the same LPAR, you should follow the DB2 installation guide and step through the CLIST configuration setup to install your new subsystem. It will require an IPL too as there will be some PARMLIB changes required to recognize the DB2 ERLY code and the new DB2 subsystem recognition character used for commands. [...] 28436 16 71_BILL GALLAGHER/Phoenix Home Life Mutual Insurance is out of the office.0_22_BILL_GALLAGHER@PHL.COM31_Thu, 27 Jul 2000 01:00:56 -0400410_us-ascii I will be out of the office from 07/26/2000 until 07/31/2000.

If you have any DB2 questions or problems, please refer them to Mark Stankiewicz at x2573.

================================================ 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. 28453 61 42_Re: SQL code -904 during tablespace create0_27_jim.leask@RS-COMPONENTS.COM31_Thu, 27 Jul 2000 12:14:27 +0100304_iso-8859-1 Another thing to look at is SMS. If you use SMS managed datasets and volumes you may have a conflict. i.e. The dataset is targeted to an SMS volume but the dataset name is not within the SMS ACS rules.

As others have suggested the previous DSNP messages in the log should clarify. [...] 28515 36 41_Data-Prop Capture Invocation JCL Problems9_SrinivasG17_SRINIVASG@INF.COM31_Thu, 27 Jul 2000 16:45:20 +0530520_- Hi, I am trying to run the Invocation JCL for DPROP I am getting a S0C1 error. The foll is the JCL

//ASNL2RN6 JOB ,,NOTIFY=&SYSUID,CLASS=N,MSGLEVEL=(1,1),MSGCLASS=X //ASNL2RN6 EXEC PGM=ASNLRP66,PARM='DSNG COLD' //STEPLIB DD DISP=SHR,DSN=DSN610.DPROP1.SASNLLNK // DD DISP=SHR,DSN=DSN610.SDSNLOAD //* DD DISP=SHR,DSN=EDC.V2R1M0.SEDCLINK //* DD DISP=SHR,DSN=PLI.V2R3M0.SIBMLINK //MSGS DD DISP=SHR,DSN=DSN610.DPROP.MSGS //CEEDUMP DD SYSOUT=* //SYSTERM DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSPRINT DD SYSOUT=* [...] 28552 64 36_Re: Performance problems - any tips?0_19_mike.holmans@BT.COM31_Thu, 27 Jul 2000 12:25:06 +0100440_- I don't suppose you kept the PLAN_TABLE from before the downgrade? You could have a look and see whether the access paths have changed - as they well might do if you change the processor configuration.

Is it possible that the batch program was bound with DEGREE(ANY)? If so, then you could have gone from 7-way parallelism to 2-way (or even no parallelism), in which case you would certainly get the effect that you describe. [...] 28617 62 43_Re: Dropped connections DB2 V-5 & web pages12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 27 Jul 2000 06:31:10 -0500466_iso-8859-1 The following is what I sent to our users when we had a similar timeout problem ____________________________________________________ ; Added for UDB V5.2 by Paul Martin 03/12/99 ; These updates go into the DB2CLI.INI file - it's in the SQLLIB lib. ; Found in the CLI trace -- CLI_cpinitQueryTimeout ; DB2 checks to see if the query has timed out ; QUERYTIMEOUTINTERVAL is set to 1 (ON) ; QUERYTIMEOUTINTERVAL is set to 0 (OFF) QUERYTIMEOUTINTERVAL=0 [...] 28680 29 19_QMF V6.1 - DSQ1444415_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 27 Jul 2000 07:32:32 -0400350_iso-8859-1 Hi Newsgroup,

Wanted to let those know who are migrating up to DB2 V6.1 for OS/390, that for some time we have been having a problem with QMF V6.1 in performing any type of SET command; whether online or batch. We have been getting a RC16 in our batch with no further output messages and in our online we are getting DSQ14444. [...] 28710 53 27_Re: number of Changed Pages0_19_mike.holmans@BT.COM31_Thu, 27 Jul 2000 12:35:10 +0100382_- I don't understand your question, really. I thought "dirty" pages were those which had been changed by currently-executing UOWs which had not yet committed.

But if you're merely after the number of pages which have been changed since the last image copy was taken, I don't know of any convenient method of getting it other than getting the relevant utility to report. [...] 28764 70 45_Re: Data-Prop Capture Invocation JCL Problems0_24_lightsey@ITS.STATE.MS.US31_Thu, 27 Jul 2000 07:47:20 -0500424_us-ascii We found that we had to include the cee.sceelked and the pli.sibmlink libraries in the steplib concatenation - might be worth a shot.







SrinivasG cc: Sent by: DB2 Subject: Data-Prop Capture Invocation JCL Problems Data Base Discussion List



07/27/2000 06:15 AM Please respond to DB2 Data Base Discussion List [...] 28835 54 42_Re: SQL code -904 during tablespace create12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 27 Jul 2000 13:07:41 GMT339_- CArlton,

MOst likely, the DASD in your STOGROUP does not have enough space for your allocation requirements for this tablespace. Check out the space available on the DASD volumes in your STOGROUP and most likely you will have to alter the stogroup to add more volumes. If using SMS, then you will need to look there as well. [...] 28890 142 15_Re: DB2 Connect12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 27 Jul 2000 06:24:43 -0700610_us-ascii Does Relational Connect allow access to OS/390 DB2 and Oracle 8? The documentation I found talks about UDB EE and EEE only.

I found some limited documentation in the Admin. Guides but never found any documentation about Relational Connect itself. Where can I find that documentation? --- leon@CA.IBM.COM wrote: > Well, the IBM rep is most likely is talking about > DB2 Connect V7.1 and the > optional piece called DB2 Relational Connect. V7.1 > of DB2 Connect > incorporates Distributed Join function that allows > you to reference tables > on Oracle and DB2 in the same select statement. [...] 29033 138 76_Re: Changing underlying VSAM high level qualifiers for DB2 table and indices12_Chris Rennie28_chris.rennie@CCRA-ADRC.GC.CA31_Thu, 27 Jul 2000 08:22:25 -0500661_- Paul,

IBM sent us the following fix that corrected the problem you refer to:

PTF UQ44954.

UQ44954 supercedes UQ42398, BQ36136, AQ36136, and AQ32711. UQ41049 is a pre-req.







On Wed, 26 Jul 2000 14:47:17 +0000, paul.packham@POSTOFFICE.CO.UK wrote:

>Don, > >This process will work, however please be aware of PQ36136 which details with >problem "ALTER INDEX USING STOGROUP to change from user-managed to DB2- managed >does not update SYSINDEXPART.STORTYPE from 'E' to 'I' as it should". > >We have been hit by this (DB2 V6.1) and its a real pain. We are still awaiting a >fix. > >Regards, Paul > > > [...] 29172 186 61_Re: Performance problems - any tips? - THANKS FOR THE ANSWERS0_23_edie.richardson@SRS.GOV31_Thu, 27 Jul 2000 09:39:11 -0400621_us-ascii Thanks to all for the answers. I think we got a good place to start now.

Edie







mike.holmans@BT.COM Sent by: DB2 Data Base Discussion List



07/27/00 07:25 AM Please respond to DB2 Data Base Discussion List



To: "Edith W. Richardson" cc: Subject: Re: Performance problems - any tips?

I don't suppose you kept the PLAN_TABLE from before the downgrade? You could have a look and see whether the access paths have changed - as they well might do if you change the processor configuration. [...] 29359 34 49_Re: Are BMC indexes on the DB2 Catalog desirable?9_ken Hynes17_khynes@TRIGON.COM31_Thu, 27 Jul 2000 09:10:26 -0500672_- On Mon, 17 Jul 2000 14:58:31 -0500, Cathy Overman wrote:

>As one weighs the plus and minus factors of creating user indexes on the >DB2 catalog, would it be desirable to create BMC indexes on the DB2 >catalog? This is recommended in BMC's Administrative Products for DB2 >Installation Guide and sample SQL is supplied in the BMC.CNTL(DCIDB2IX) >library. (I have DB2 V5 for OS/390 and am installing version 6.1 of the >BMC admin tools). > >================================================ >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 [...] 29394 89 38_Re: Reference for DB2/390, USS and C++20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 27 Jul 2000 10:24:31 -0400456_us-ascii Not us. What is USS ??

-----Original Message----- From: vpacheco@AMADEUS.NET [SMTP:vpacheco@AMADEUS.NET] Sent: Thursday, July 27, 2000 4:08 AM To: DB2-L@RYCI.COM Subject: Reference for DB2/390, USS and C++

Hello again DBA Community

Yesterday I have posted the note that follows in attachment. I have received only one direct answer: thanks to Isaac Yassin. And this reply did not 'qualify' for what I am investigating... [...] 29484 94 38_Re: Reference for DB2/390, USS and C++9_Rob Crane22_racrane@CONCENTRIC.NET31_Thu, 27 Jul 2000 08:52:05 -0600591_us-ascii Unix System Services = USS, ability to have OS/390 box run Unix. Starting to look at this, lots of interest.

"Pillay, Venkat (PCA)" wrote: > > Not us. What is USS ?? > > -----Original Message----- > From: vpacheco@AMADEUS.NET [SMTP:vpacheco@AMADEUS.NET] > Sent: Thursday, July 27, 2000 4:08 AM > To: DB2-L@RYCI.COM > Subject: Reference for DB2/390, USS and C++ > > Hello again DBA Community > > Yesterday I have posted the note that follows in attachment. > I have received only one direct answer: thanks to Isaac Yassin. And > this reply > did not 'qualify' for what I [...] 29579 20 61_Debugging a Stored Procedure(written in JAVA)in UDB 6.1 on NT15_Joel Zigelstein20_jzigel1@HALLMARK.COM31_Thu, 27 Jul 2000 09:35:14 -0500313_- Hi ....

We have been unable to do this. Do we require VisualAge for Java and the IBM remote debugger to be able to do this??? We have rebuilt our stored procedures with all the options for debugging turned on (including the IP address of where the output should be sent!)but cannot get it to debug! [...] 29600 104 38_Re: Reference for DB2/390, USS and C++12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Thu, 27 Jul 2000 10:56:04 -0400579_us-ascii We too have up and are starting to use Unix System Services (is it oficially USS?) but will use Java via Websphere rather than C++.

Martin Wolff.

Rob Crane wrote:

> Unix System Services = USS, ability to have OS/390 box run Unix. > Starting to look at this, lots of interest. > > "Pillay, Venkat (PCA)" wrote: > > > > Not us. What is USS ?? > > > > -----Original Message----- > > From: vpacheco@AMADEUS.NET [SMTP:vpacheco@AMADEUS.NET] > > Sent: Thursday, July 27, 2000 4:08 AM > > To: DB2-L@RYCI.COM > > Subject: Reference for DB2/390, USS and [...] 29705 58 39_Re: RE : ADDING NEW VOLUMES TO STOGROUP14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Wed, 19 Jul 2000 16:47:03 -0500335_us-ascii You didn't indicate whether your data was controlled via SMS or not , but if SMS was controlling it, adding a volume to the proper SMS STORAGEGROUP will handle the problem. If the allocation is controlled via non-SMS then the additional volume would have to be added with an 'ALTER STOGROUP ADD VOLUMES(VOLSER)' command. [...] 29764 49 39_Re: DB2 Connect Alternatives (offtopic)14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Thu, 27 Jul 2000 10:53:19 -0400575_us-ascii Hi Stan,

I have a hopefully easy question(s) for you (or anyone on the list) about your implementation of StarQuests product. First some background - There is a department here for the school district that has implemented a SQL Server database and regularly download data from our DB2 OS/390 V4 DB2 via this product. It was here when I got here and no one knows anything about it, except that "it came with SQL Server". Up till recently, only one user was accessing DB2 via this process, but now others in that same department want access. I was able to [...] 29814 27 26_RLF & Install SYSADM Auth.32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Thu, 27 Jul 2000 18:02:10 +0300333_- Hello,

When I send Dynamic SQL from a CICS pgm. with Install SysADM Auth., RLF Values for this package are bypassed.

But when i send SQL over DB2 Connect with Command Center via SysAdm Auth., RLF values are still used. DB2 Does not understand that my AuthID as SysADM.

Do you have any comments for that ? [...] 29842 95 38_Re: Reference for DB2/390, USS and C++15_Aniruddha Garud24_Aniruddha.Garud@WCOM.COM31_Thu, 27 Jul 2000 11:23:09 -0400473_- We are using db2/390, USS (which is also referred as OMVS (open MVS) segment of OS390 at our place). We are only using netdata, java applets/servlets but not C++. What are you using C++ for? Is it for the business layer?

HTH, Aniruddha DB2 DBA (All my opinions only)

-----Original Message----- From: vpacheco@AMADEUS.NET [mailto:vpacheco@AMADEUS.NET] Sent: Thursday, July 27, 2000 4:08 AM To: DB2-L@RYCI.COM Subject: Reference for DB2/390, USS and C++ [...] 29938 379 33_Re: SQLCODE -911 and SQLCODE -91313_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 27 Jul 2000 09:50:50 -0500624_iso-8859-1 I was also interested in the response about Peoplesoft incorrectly reporting -911's as -913's. What "DB2 logs" you are looking at to determine this? When I look at the DB2 started tasks I just see the "00C90088"/"00C9008E" messages, but either one of these can return either -911 or -913. I'll be the first to say that Peoplesoft does some things I don't like, but I have a have a hard time believing they are changing sqlcodes before displaying them, especially when it appears to give a pretty complete message that appears to come directly from DB2 ("[IBM][CLI DRIVER][DB2]SQL0913N Unsuccessful execution [...] 30318 130 38_Re: Reference for DB2/390, USS and C++13_OConner, John26_John.OConner@COURTS.WA.GOV31_Thu, 27 Jul 2000 08:08:59 -0700393_iso-8859-1 This is our situation as well.

-----Original Message----- From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] Sent: Thursday, July 27, 2000 7:56 AM To: DB2-L@RYCI.COM Subject: Re: Reference for DB2/390, USS and C++



We too have up and are starting to use Unix System Services (is it oficially USS?) but will use Java via Websphere rather than C++. [...] 30449 16 26_UDB DB2DIAG.LOG ON Solaris18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 27 Jul 2000 11:11:15 -0400455_- Does anyone know where I can get the PROBE: codes that match the messages in the db2diag.log file? The reason code doesn't really help.

Peter J. Krawetzky Aetna, Inc. DataBase Administrator (860) 273-0301

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 30466 26 16_Plans-2-Packages13_Eric McDonald22_Eric_McDonald@BELK.COM31_Thu, 27 Jul 2000 11:05:34 -0400435_us-ascii Greetings-

We are a DB2 v5 OS/390 shop that is putting together a plan to go from plans to packages. I have been assigned the tasks of developing a "Risk Assessment" and "Impact Analysis Procedures". From reviewing past mail about this topic I have found useful information on the benefits/pros of converting to packages, but I have not been able to find any cons, gottchas or just general things to look out for. [...] 30493 25 35_RE : ADDING NEW VOLUMES TO STOGROUP12_Andre Cupido22_wcacu@WOOLWORTHS.CO.ZA31_Wed, 19 Jul 2000 20:49:55 +0200521_us-ascii Hi All

I need to fix a space problem pronto. If i were to add an additional volume to a specific stogroup , stop and start the tablespace , will the offending file extend to the newly added volume .



Thanking you in advance

Andre Cupido

================================================ 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. [...] 30519 93 39_Re: DB2 Connect Alternatives (offtopic)13_OConner, John26_John.OConner@COURTS.WA.GOV31_Thu, 27 Jul 2000 08:30:24 -0700226_iso-8859-1 Here is how we use SWRC0000:

QUALIFIER: PACKAGE=STARADM.SWRC0000

Command User Grantor Type HowGot Date Authorizations

----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v- 30613 67 30_Re: RLF & Install SYSADM Auth.0_17_sjvagnier@AEP.COM31_Thu, 27 Jul 2000 11:27:28 -0400473_us-ascii Hello Cuneyt,

I believe that RLF will ONLY bypass govenor settings if you are an Install Sysadm. A Sysadm user would still be restricted by RLF. To get around this, define any Sysadm user with ASUTIME of nulls (ie. unlimited service time).



Hope this helps Steve Vagnier American Electric Power











"Cuneyt Goksu (Garanti Teknoloji)" @RYCI.COM> on 07/27/2000 11:02:10 AM [...] 30681 28 29_I'm in trouble - DB2v6 OS/39011_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 27 Jul 2000 08:33:54 -0700497_iso-8859-1 Does anyone have a solution to this catch 22. (other than a LPAR) I just migrated my development DB2 to v6. Production is v5. v5 loadlib is in the linklist.

Now my users can't run batch DB2 programs because they can't add v6.SDSNLOAD to their steplib or joblibs because their loadlib are not in the APF and they can't use a JOBLIB for v6.SDSNLOAD and steplib their loadlibs because the steplib will override the joblib and then they'll get the v5.SDSNLOAD via the linklist! [...] 30710 50 20_Re: Plans-2-Packages20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 27 Jul 2000 11:34:46 -0400366_us-ascii One thing to look for is to make sure that no body runs "BIND PLAN" jcl anymore after conversion is completed. Many folks have old jcls and they keep running it long after things are changed, I had a situation where people unknowingly kept binding the plans instead of packages after each compile and therefore messing the whole setup again and again. [...] 30761 67 20_Re: Plans-2-Packages13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 27 Jul 2000 11:38:00 -0400604_us-ascii I have been known to revoke the developers' ability to bind the plan(s) for that very reason!

> -----Original Message----- > From: Pillay, Venkat (PCA) [SMTP:venkat_pillay@ML.COM] > Sent: Thursday, July 27, 2000 11:35 AM > To: DB2-L@RYCI.COM > Subject: Re: Plans-2-Packages > > One thing to look for is to make sure that no body runs "BIND PLAN" jcl > anymore after conversion is completed. Many folks have old jcls and they > keep running it long after things are changed, I had a situation where > people unknowingly kept binding the plans instead of packages after each > compile [...] 30829 80 16_Re: AREST status12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 27 Jul 2000 10:43:20 -0500558_us-ascii We had the same experience as Richard. We had a DDF thread that was -CANCELed, but it hung instead of cancelling. Had to cancel IRLM (F xxxxIRLM,ABEND) to get the DB2 down to clear it. Upon restart, tablespaces and indexes were marked RESTP. Support center recommended a COLD start to clear the RESTP. We have never started COLD in the 15 years we have had DB2 in this shop, and were reluctant to do so. We were able to drop, re-create, and reload from another copy of the table (luckily this was test, not production). IBM has an open problem [...] 30910 64 33_Re: I'm in trouble - DB2v6 OS/3900_17_sjvagnier@AEP.COM31_Thu, 27 Jul 2000 11:47:48 -0400510_us-ascii Hello Cliff,

Why can't you just APF the v6.SDSNLOAD, SDSNLINK, SDSNEXIT and let the user's Steplib to v6 to run batch ? You can dynamically APF libraries without an IPL.



Regards, Steve Vagnier American Electric Power









Cliff Boley @RYCI.COM> on 07/27/2000 11:33:54 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 30975 89 30_Re: RLF & Install SYSADM Auth.32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Thu, 27 Jul 2000 18:57:55 +0300310_- Hello,

I agree with you. PLase ignore my first message. I correct my statement for DB2 Connect connection as ' But when i send SQL over DB2 Connect with Command Center via INSTALL SYSADM AUTH., RLF values are still used. DB2 Does not understand that my AuthID as SysADM.'

How about this ? [...] 31065 85 33_Re: I'm in trouble - DB2v6 OS/39011_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 27 Jul 2000 09:04:00 -0700486_iso-8859-1 v6.SDSNLOAD is in the APF. If the uses concatenates his loadlib with the v6.SDSNLOAD then SDSNLOAD becomes un authorized because you can't concat APF and nonAPF libs. DB2 must be in the APF to run and you don't want user loadlib in the APF. that's my catch 22 cliff:-)





-----Original Message----- From: sjvagnier@AEP.COM [mailto:sjvagnier@AEP.COM] Sent: Thursday, July 27, 2000 8:48 AM To: DB2-L@RYCI.COM Subject: Re: I'm in trouble - DB2v6 OS/390 [...] 31151 37 28_DB2 V4 to V5 migrate problem13_Joe Abbagnaro25_Joe_Abbagnaro@PRAXAIR.COM31_Thu, 27 Jul 2000 12:03:47 -0400331_us-ascii I can not get by panel DSNTIPH in the migrate process.

I selected Migrate on a previous panel as the install option. When I get to this panel (DSNTIPH) which looks for BSDS and Log info I can not

get by this panel. It telling me required field not filled out and puts the cursor on the following field. [...] 31189 15 34_Re: Discarded rows format in REORG9_Jim Ruddy18_jaruddy@US.IBM.COM31_Thu, 27 Jul 2000 10:50:09 -0500404_- REORG UNLOAD EXTERNAL was developed in V6 and retrofitted to V5.

UNLOAD EXTERNAL is mutually exclusive with DISCARD.

Jim Ruddy IBM DB2 Development

================================================ 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. 31205 132 30_Re: RLF & Install SYSADM Auth.0_17_sjvagnier@AEP.COM31_Thu, 27 Jul 2000 12:05:42 -0400488_us-ascii Cuneyt, could it be that DB2 Connect or Command Center is not sending your authid correctly accross to DB2 to process the SQL? Check your DB2 monitor for verification that the DB2 thread to process your SQL does infact have the correct userid.

Hope this helps...



Steve Vagnier American Electric Power













"Cuneyt Goksu (Garanti Teknoloji)" @RYCI.COM> on 07/27/2000 11:57:55 AM [...] 31338 101 33_Re: I'm in trouble - DB2v6 OS/39014_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 27 Jul 2000 12:10:55 -0400572_- Can you make a copy of their batch loadlib and secure it so they can only execute programs from it, and APF this one so they can steplib and test.

> -----Original Message----- > From: Cliff Boley [SMTP:Maurice.C.BOLEY@ODOT.STATE.OR.US] > Sent: Thursday, July 27, 2000 12:04 PM > To: DB2-L@RYCI.COM > Subject: Re: I'm in trouble - DB2v6 OS/390 > > v6.SDSNLOAD is in the APF. > If the uses concatenates his loadlib with the v6.SDSNLOAD then SDSNLOAD > becomes un authorized because you can't concat APF and nonAPF libs. > DB2 must be in the APF to run and you [...] 31440 93 33_Re: I'm in trouble - DB2v6 OS/39012_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 27 Jul 2000 11:15:00 -0400537_- We don't have any DSNLOADs in the linklist...and we have it contatenated with non-apf libs in many batch jobs. Did you try it? I would guess that the modules DB2 uses for Batch don;t need APF authorization.

>>> DB2-L@RYCI.COM@inter2 07/27/00 11:04AM >>> v6.SDSNLOAD is in the APF. If the uses concatenates his loadlib with the v6.SDSNLOAD then SDSNLOAD becomes un authorized because you can't concat APF and nonAPF libs. DB2 must be in the APF to run and you don't want user loadlib in the APF. that's my catch 22 cliff:-) [...] 31534 58 33_Re: I'm in trouble - DB2v6 OS/39011_Burch, Todd18_Todd_Burch@BMC.COM31_Thu, 27 Jul 2000 11:17:12 -0500464_iso-8859-1 Doesn't the standard search order go steplib, joblib, then the linklist? If so, your second point doesn't hold up. Todd.



Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: I'm in trouble - DB2v6 OS/390



Does anyone have a solution to this catch 22. (other than a LPAR) I just migrated my development DB2 to v6. Production is v5. v5 loadlib is in the linklist. [...] 31593 114 33_Re: I'm in trouble - DB2v6 OS/39014_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 27 Jul 2000 12:19:00 -0400608_- That is true, SDSNLOAD doesn't need to be APF'd. Only SDSNEXIT and SDSNLINK.



> -----Original Message----- > From: BOB JEANDRON [SMTP:BOB.JEANDRON@USDA.GOV] > Sent: Thursday, July 27, 2000 11:15 AM > To: DB2-L@RYCI.COM > Subject: Re: I'm in trouble - DB2v6 OS/390 > Sensitivity: Personal > > We don't have any DSNLOADs in the linklist...and we have it contatenated > with > non-apf libs in many batch jobs. Did you try it? I would guess that the > modules DB2 uses for Batch don;t need APF authorization. > > >>> DB2-L@RYCI.COM@inter2 07/27/00 11:04AM >>> > v6.SDSNLOAD is in the APF. > [...] 31708 57 32_Re: DB2 V4 to V5 migrate problem18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM31_Thu, 27 Jul 2000 12:16:59 -0400424_iso-8859-1 I had these exact symptoms, but it turned out to be my error. I had pulled in a V3 input member instead of the one for V4. Once I got the correct member, I could go on through the install.

Good luck! Deborah Gresham

-----Original Message----- From: Joe Abbagnaro [mailto:Joe_Abbagnaro@PRAXAIR.COM] Sent: Thursday, July 27, 2000 12:04 PM To: DB2-L@RYCI.COM Subject: DB2 V4 to V5 migrate problem [...] 31766 100 16_Re: AREST status14_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 27 Jul 2000 12:21:27 -0400565_- How do you start DB2 "cold" ???

> -----Original Message----- > From: Kirk Hampton [SMTP:khampto1@TXU.COM] > Sent: Thursday, July 27, 2000 11:43 AM > To: DB2-L@RYCI.COM > Subject: Re: AREST status > > We had the same experience as Richard. We had a DDF thread that > was -CANCELed, but it hung instead of cancelling. Had to cancel IRLM > (F xxxxIRLM,ABEND) > to get the DB2 down to clear it. Upon restart, tablespaces and indexes > were > marked RESTP. Support center recommended a COLD start to clear the > RESTP. We have never started COLD in the 15 [...] 31867 136 33_Re: I'm in trouble - DB2v6 OS/39011_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 27 Jul 2000 09:31:01 -0700323_iso-8859-1 Ahh the fog clears, Thank all for the info and saving me a fallback. I didn't know about SDSNLOAD not needing to be APF. I don't know why but I have always joblibed both SDSNEXIT and SDSNLOAD together, that explains my APF non APF problems and misconceptions. Thanks again for the quick responses. cliff:-) [...] 32004 81 33_Re: I'm in trouble - DB2v6 OS/39014_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 27 Jul 2000 12:33:18 -0400570_- No it's

Job Pack Area TAsklib Joblib Steplib LPA linklist

> -----Original Message----- > From: Burch, Todd [SMTP:Todd_Burch@BMC.COM] > Sent: Thursday, July 27, 2000 12:17 PM > To: DB2-L@RYCI.COM > Subject: Re: I'm in trouble - DB2v6 OS/390 > > Doesn't the standard search order go steplib, joblib, then the linklist? > If > so, your second point doesn't hold up. > Todd. > > > Sent by: DB2 Data Base Discussion List > > > To: DB2-L@RYCI.COM > cc: > > Subject: I'm in trouble - DB2v6 OS/390 > > > Does anyone have a solution to this [...] 32086 24 33_Re: I'm in trouble - DB2v6 OS/3909_Sally Mir22_Sally.Mir@WACHOVIA.COM31_Thu, 27 Jul 2000 12:20:38 -0400569_us-ascii If you're running under TSO attach, you can specify the application load library in the DSN command.

//RUNSTEP EXEC PGM=IKJEFT01 //STEPLIB DD DSN=...SDSNEXIT,DISP=SHR // DD DSN=...SDSNLOAD,DISP=SHR . . . //SYSTSIN DD * DSN SYSTEM (ssid) RUN PROGRAM (yourprogram) PLAN (yourplan) LIB (yourapplicationloadlibrary)

================================================ 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. 32111 272 16_Re: AREST status13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 27 Jul 2000 11:43:03 -0500611_US-ASCII Kirk, You need to create a CRCR. (Conditional Restart Control Record) Use DSNJU003 to create. Look up in Util Guide. Kurt

>>> DMonteva@VNSNY.ORG 07/27/00 11:21AM >>> How do you start DB2 "cold" ???

> -----Original Message----- > From: Kirk Hampton [SMTP:khampto1@TXU.COM] > Sent: Thursday, July 27, 2000 11:43 AM > To: DB2-L@RYCI.COM > Subject: Re: AREST status > > We had the same experience as Richard. We had a DDF thread that > was -CANCELed, but it hung instead of cancelling. Had to cancel IRLM > (F xxxxIRLM,ABEND) > to get the DB2 down to clear it. Upon restart, tablespaces [...] 32384 166 30_Re: RLF & Install SYSADM Auth.32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Thu, 27 Jul 2000 19:45:52 +0300362_- I checked it. AuthID is my Install SYSADM Id. Here is more info..

When i sign on to CICS with the same Auth ID and run the same Dynamic SQL, i see this from TMON.

+------------- RESOURCE LIMIT FACILITY ------------+ TABLE ID : A1 LIMIT FROM : INFINITE LIMIT - SUPER SYSADM/SYSOPR LIMIT IN SU'S: NO LIMIT LIMIT IN CPU : HIGH CPU USED: 0.0004 [...] 32551 112 39_Re: DB2 Connect Alternatives (offtopic)14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Thu, 27 Jul 2000 13:03:32 -0400595_us-ascii Hi Paul, John - Thanks for the prompt responses,

But alas that was my true 'first attempt'. I granted execute on plan RJOHNSON.SWRC0000 to ASDREA Where RJOHNSON was the original and only user and ASDREA was the RACF group of the new interested parties. After the grant, when the new parties attempted to access DB2 they received errors that led me to believe that the Starquest software somehow directs the name of the package at the mainframe level. This is complete conjecture (I think) and I was hoping someone would be able to clarify the situation. Is the package name [...] 32664 161 33_Re: I'm in trouble - DB2v6 OS/39012_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 27 Jul 2000 12:46:00 -0400804_- This is from the V5.1 Install Manual P2-231... *------------------------------------------------------------------- Job DSNTIJMV updates IEAAPFxx to include the DB2 program libraries (prefix.SDSNEXIT, prefix.SDSNLOAD, prefix.SDXRRESL, and prefix.SDSNLINK) as APF-authorized libraries. *------------------------------------------------------------------- I also see the next paragraph... *------------------------------------------------------------------- ... All libraries concatenated with prefix.SDSNLOAD in STEPLIB and JOBLIB statements must be APF-authorized... *------------------------------------------------------------------- I can only tell you what works at our site. The normal working concatenation we use here is : //STEPLIB ...SDSNEXIT APF ...SDSNLOAD APF Application libs Non APF [...] 32826 161 39_Re: DB2 Connect Alternatives (offtopic)13_OConner, John26_John.OConner@COURTS.WA.GOV31_Thu, 27 Jul 2000 10:49:12 -0700487_iso-8859-1 Bill,

In our case, we have Websphere on the server (NT), and websphere is connecting with its own RACF defined userid (something other than STARADM). We give all the necessary authorizations to the websphere userid, and individual user access is controlled at the server (if they're ok to use websphere, then their requests come across one of the websphere connections). If I were having your problem, I would suspect the use of the RACF Group (secondary authid). [...] 32988 29 23_Online Reorg of Indexes13_Moss, William15_MossW@AETNA.COM31_Thu, 27 Jul 2000 14:19:01 -0400334_- I'm in the processing of testing the reorging of indexes using SHRLEVEL CHANGE DB2 V5.1 (OS/390 2.8) and my question pertains to the shadow files created during the Build phase.

If I terminate the reorg utility during the Build phase, the shadow files remain and must be manually deleted before running the reorg again. [...] 33018 55 27_Re: Online Reorg of Indexes20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 27 Jul 2000 14:24:32 -0400483_us-ascii The terminate utility deletes the shadow datasets. But abnormal termination of the reorg will leave the shadow datasets and will get deleted when terminate utility command is issued.

There is no need to manually delete the shadow dataset, you could always issue -term util to do the same thing.

-----Original Message----- From: Moss, William [SMTP:MossW@AETNA.COM] Sent: Thursday, July 27, 2000 2:19 PM To: DB2-L@RYCI.COM Subject: Online Reorg of Indexes [...] 33074 198 30_Re: RLF & Install SYSADM Auth.12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 27 Jul 2000 13:28:10 -0500248_us-ascii Cuneyt, what level of DB2 are you running ? V6 ? What does it do if you run the SQL thru SPUFI ? We saw a problem, for which there is a PTF, on an earlier maint level of DB2 V6, where RLF was limiting SYSADM users when it should not. [...] 33273 84 32_Re: DB2 V4 to V5 migrate problem14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Thu, 27 Jul 2000 13:11:30 -0500510_iso-8859-1 This parm can be changed by ( making a backup of ) and editing , in TSO/ISPF either the DSNTIDXA or the DSNTID%% parm that you created during the migrate process. I assume you used the DSNTID%% from the Version 4 subsystem and the version 5 base parm (DSNTIDXA)in DSN510.SDSNSAMP ( or whatever the version 5 SDSNSAMP lib is called ). IBM does not recommend that DSNTIDXA should be changed since it can affect all DB2 subsystem migrations, but if it was already changed and you are fixing it... [...] 33358 166 39_Re: DB2 Connect Alternatives (offtopic)22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 27 Jul 2000 14:53:42 -0400621_iso-8859-1 Bill -

There are no plans with StarSQL... its all packages. Granting execute on a plan is useless.

Make sure you issue GRANT EXECUTE ON PACKAGE collection-id.* TO PUBLIC where collection-id is the StarSQL collection id.

We use StarSQL to access DB2 for OS/390 from Windows desktops and Windows Web servers. We are using a 2-tier architecture - the StarSQL ODBC driver is installed on each client. The StarSQL ODBC data source on each client is configured to use the same StarSQL collection-id. Each client specifies a userid that is unique to him/her... we know who is doing what. We [...] 33525 118 32_Re: DB2 V4 to V5 migrate problem50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Thu, 27 Jul 2000 14:58:32 -0400271_- The V4 DSNTIDX# goes on line 3. The V5 DSNTIDX# goes on line 6 & the newly created param gos on line 7.

I have had the same problem. One way to correct this is to take the V4 member using update go thru the motions hit enter to create the dsntijuz member . [...] 33644 203 30_Re: RLF & Install SYSADM Auth.0_17_sjvagnier@AEP.COM31_Thu, 27 Jul 2000 15:29:10 -0400402_us-ascii What does TMON option 5.2 (Online Analysis Thread Summary) show for userid for CICS and DB2 Connect? If it also shows the same Install SYSADM id, then I would check with IBM to see if there are any APAR's relating to this problem.

Regards, Steve









"Cuneyt Goksu (Garanti Teknoloji)" @RYCI.COM> on 07/27/2000 12:45:52 PM [...] 33848 183 39_Re: DB2 Connect Alternatives (offtopic)14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Thu, 27 Jul 2000 15:22:01 -0400412_us-ascii Hi Mike,

Package - not plan - Correct, I was (believe it or not) thinking and meant Package when I typed > I granted execute on plan RJOHNSON.SWRC0000 to ASDREA There theoretically shouldn't be any difference between the above grant and granting to 'Public', as long as we are talking about individuals in the ASDREA group - correct ? The following statement may provide the answer I need : [...] 34032 89 16_Re: AREST status13_john arbogast19_arbo@CP-DEMO.CP.NET31_Thu, 27 Jul 2000 13:21:54 -0700564_- Since we are talking about a PeopleSoft instance, dropping and recreating objects is really an option. Thankfully this is a test system. I hope this is fixed before we go to production with v6.

On Thu, 27 July 2000, Kirk Hampton wrote:

> > We had the same experience as Richard. We had a DDF thread that > was -CANCELed, but it hung instead of cancelling. Had to cancel IRLM > (F xxxxIRLM,ABEND) > to get the DB2 down to clear it. Upon restart, tablespaces and indexes were > marked RESTP. Support center recommended a COLD start to clear the [...] 34122 247 39_Re: DB2 Connect Alternatives (offtopic)22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 27 Jul 2000 16:35:14 -0400394_iso-8859-1 Bill -

Is the RACF group ASDREA assigned as a secondary authid? If so, then it seems like you're asking if GRANTing execute to a secondary authid will work. I don't know if GRANTing execute to a RACF group will work. We don't use secondary authids.

If the client is Windows 2000, then go to Start\Settings\Control Panel\Administrative Tools \Data Sources (ODBC)\. [...] 34370 32 12_DAta Sharing12_Silvia Motta21_silviamotta@YAHOO.COM31_Thu, 27 Jul 2000 13:56:24 -0700319_us-ascii Hello, My question is ; I'll make a datasharing with two DB2, A and B.

To run a batch program now I write DSN(A) RUN PROGRAM(PEPITO) PLAN(MENGANO) END

But if i have datasharing How i write the job ?? Because, i want to run the program in A or B indistinctly.

Thanks very much, Silvia [...] 34403 236 39_Re: DB2 Connect Alternatives (offtopic)27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Thu, 27 Jul 2000 15:36:32 -0500397_iso-8859-1 You need to use the StarAdmin utilty that comes on the CD. I think it's called that, anyway. We don't have StarSQL at my current job so I can't check. Anyway, it's really easy to do the bind and grant with that. That way you'll make sure you've bound and granted on all the packages. Just make sure you connect with an id that can do the bind. I always used our install sysadm id. [...] 34640 52 16_Re: DAta Sharing20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 27 Jul 2000 17:10:10 -0400435_iso-8859-1 When you are in data sharing you also get a group attach name. You could run your program in two ways 1. DSN SYS(GROUP-ATTACH-NAME) independent of LPAR or m/c RUN PROG(....)

2 DSN SYS(DB2A or DB2B) depending on which LPAR you're running RUN PROG(...)

-----Original Message----- From: Silvia Motta [SMTP:silviamotta@YAHOO.COM] Sent: Thursday, July 27, 2000 4:56 PM To: DB2-L@RYCI.COM Subject: DAta Sharing [...] 34693 59 16_Re: DAta Sharing12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 27 Jul 2000 16:08:38 -0500305_us-ascii Hello Silvia, when you move into data sharing, one of the things you define is a "group attach name" . Let's say you call your group G, and your two members are A and B. You would code your job DSN SYSTEM(G) and it would connect to either A or B depending on which LPAR it gets executed on. [...] 34753 46 16_Re: DAta Sharing14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Thu, 27 Jul 2000 14:18:34 -0700553_iso-8859-1 Silvia, When you set up datasharing, you specify a "Group Attach Name" which must abide by the same naming conventions as a subsystem name. So you would have 2 members A and B, with a group attach name of X, then you would code dsn (X) run program(myprog)

This would allow the DB2 IDENTIFY code (that gets run as part of connect) to pick the appropriate subsystem name. Beware that if you 2 or more members running in the same MVS image (using DB2 V5 or lower), using the group attach name will cause DB2 to ALWAYS pick the FIRST [...] 34800 136 41_Re: Installing a DB2 subsystem - Continue13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Thu, 27 Jul 2000 17:38:30 EDT462_- Hi list, To all who responded to my initial inquiry, thank you very much for your comments. As a followup, here is my next question:

I have a MP3000-P90, 60 MIP, 1 ESCON, 1 GB RAM, and 6x18GB+9GB DASD; pre-load OS390 software bundle. I have one subsystem in place and want to add a second subsystem with the idea of a single shared libraries, shared DASD, etc, etc. Is my machine, as described above, capable of running two subsystem concurrently? [...] 34937 60 16_Re: Data Sharing14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Thu, 27 Jul 2000 14:16:50 -0700462_us-ascii Silvia, You will specify neither A nor B. Instead, you specify the Group Attach Name. Data Sharing has superb benefits. Hundreds of shops use it. But, because DB2 Data Sharing implementation is rather complex and time-consuming, you'd better read the following:

http://www.s390.ibm.com:80/bookmgr-cgi/bookmgr.cmd/BOOKS/DSNDS0G2/CCONTENTS?SHELF=DSNSH0G3

It is the DB2 Version 6 Data Sharing Planning and Administration Guide. HTH, Roy [...] 34998 102 20_Re: Plans-2-Packages12_troy Coleman20_Troy.Coleman@UAL.COM31_Thu, 27 Jul 2000 13:52:35 -0500592_- Eric, I've been working with packages since they first came out in DB2 V2.3. From an application developers point of view you really have no CONs. Well I guess the only CON is that you need to understand your application architecture. You have several ways of implementing packages. I personally like to have one PLAN for batch and one for ON-LINE CICS. I've also used the concept of having one plan with a PKLIST including multiple collections for each test environment. The programmer would then pass a batch parameter and/or have the application read a DB2 table for the collection [...] 35101 17 38_Enforcing uniqueness on partial column7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Thu, 27 Jul 2000 17:20:48 -0500259_- Is there any efficient way to enforce uniqueness on part of a column. For example, if you need to make sure that the string made of the first 4 characters of the last name is unique (not the whole last name), is there any way to create a unique index? [...] 35119 176 38_Re: Reference for DB2/390, USS and C++17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Thu, 27 Jul 2000 20:12:22 +0200443_us-ascii Hi Victor, I'm involved, just now, in a project to install SAP R/3 V4.6C on OS/390 2.9, DB2 V6.1.

The installation is for an IBM Business Partner, and this must be a Demo point, not a production env.

We just finished to prepare the DB2 env, following the IBM manual "SAP R/3 Release 4.6C (June 2000), Final Version, SAP Material Number 51009164". Now we are waiting for a list of APAR necessary for DB2 PM and DB2. [...] 35296 315 18_Re: Reporting Tool14_Duncan Gardner23_dgardner@GESB.WA.GOV.AU31_Fri, 28 Jul 2000 07:56:55 +0800535_iso-8859-1 Brian,

I haven't done Oracle DBA, just development on a couple of projects. But I've done Ingres DBA for 15 years or so, and there are plenty of comments on the Ingres user group about people moving to Oracle and it taking 3 times as much effort to administer as Ingres. You could try asking the info-ingres@ams.org newsgroup, they love to tell you stories. DB2 is a bit more effort that Ingres, but that's mainly because there are more things to tweak. The move is almost worth it just for the RESTORE command! [...] 35612 142 38_Re: Reference for DB2/390, USS and C++0_14_mtdage@ATT.NET31_Fri, 28 Jul 2000 02:12:29 +0000313_- This is our environment too except right now. We have two DB2 subsystem (one test and one prod) running on our WEBS LPAR where Unix System Services is running. We do use NetData to access DB2 on our OS/390 production LPAR.

Soon we would like to explore the use of JAVA via WEBSPHERE instead of C++. [...] 35755 101 33_Re: I'm in trouble - DB2v6 OS/39023_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Fri, 28 Jul 2000 02:46:48 -0000417_iso-8859-1 Usually users application programs dont do anything that requires apf authorization so they should run ok. it is only when you do a modeset that an s047 abend occurs, and this is not usually done in applications.

-----Original Message----- From: Cliff Boley [mailto:Maurice.C.BOLEY@ODOT.STATE.OR.US] Sent: Friday, 28 July 2000 2:04 To: DB2-L@RYCI.COM Subject: Re: I'm in trouble - DB2v6 OS/390 [...] 35857 77 45_Re: Data-Prop Capture Invocation JCL Problems9_SrinivasG17_SRINIVASG@INF.COM31_Fri, 28 Jul 2000 09:54:52 +0530746_- I have added CEE.SCEERUN as well as SCEELKED under steplib and still the same error persists. Please help.

Srinivas G

> -----Original Message----- > From: Martin, Paul [SMTP:Paul.Martin@ecolab.com] > Sent: Thursday, July 27, 2000 5:33 PM > To: SrinivasG > Subject: RE: Data-Prop Capture Invocation JCL Problems > > Note I have CEE.SCEERUN in concatenation > > XXASNL2RN5 EXEC PGM=ASNLRP65, > XX PARM='DB2P &STERM &SMODE &SPRUNE &STRACE', > XX REGION=10M, > XX TIME=1440 > IEFC653I SUBSTITUTION JCL - PGM=ASNLRP65,PARM='DB2P NOTERM WARMNS > XXSTEPLIB DD DISP=SHR,DSN=ASNL.V6R1M0.PROD.SASNLLNK > XX DD DISP=SHR,DSN=DB2.DB2P.DSNLOAD > XX DD DISP=SHR,DSN=CEE.SCEERUN > XXMSGS DD DISP=SHR,DSN=ASNL.V6R1M0.PROD.MSGS > XXSYSTERM DD [...] 35935 12 54_Greg Fernholz/Deluxe Corporation is out of the office.13_Greg Fernholz24_Greg_Fernholz@EFUNDS.COM31_Fri, 28 Jul 2000 01:00:57 -0500312_us-ascii I will be out of the office from 07/27/2000 until 07/31/2000.

================================================ 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. 35948 12 53_Joel Zigelstein/Canada/HALLMARK is out of the office.15_Joel Zigelstein20_jzigel1@HALLMARK.COM31_Fri, 28 Jul 2000 02:22:25 -0400312_us-ascii I will be out of the office from 07/28/2000 until 07/31/2000.

================================================ 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. 35961 62 42_AW: Enforcing uniqueness on partial column12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 28 Jul 2000 09:18:43 +0200394_iso-8859-1 We had the same problem in a resident registration & information system based on DB2 for OS/390. There's no chance. You must have an additional column and then a unique index on that column.

You cannot define an index in a way like CREATE unique INDEX name ON table (substr(colname,1,4) asc.... This results in an SQLSTATE 42601 (or SQLCODE -104) ILLEGAL SYMBOL "("..... [...] 36024 40 34_Reference for DB2/390, USS and C++0_20_vpacheco@AMADEUS.NET31_Fri, 28 Jul 2000 10:04:38 +0100349_us-ascii Dear DB2 Community

Thanks to all of you that have replied to my note. I believe that it had helped in two different ways: to learn what is USS, and to learn what the 'rest of the world' is doing with it. I say the rest of the world because it seems we are the only ones using the combination I have mentioned: USS, DB2 and C++. [...] 36065 188 34_Re: DB2 V4 Performance problem ...12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Fri, 28 Jul 2000 18:28:44 +1000371_iso-8859-1 Dear Myoungsoo (in the land of the long white cloud),

greetings from the land of Oz!

This is a bit of a long shot, but if no plans/packages have been rebound or "automagically" (Auto rebind), and the dynamics of the transaction load have not changed, is there a possibility that the ZPARMs may have changed during the upgrade from V3 to V4? [...] 36254 116 45_SV: Data-Prop Capture Invocation JCL Problems11_Arne Nilsen18_Arne.Nilsen@SDS.NO31_Fri, 28 Jul 2000 10:48:22 +0200745_- Hi;

Perhaps this can help you, here is our "CAPTURE-JCL":

//********************************************************************/ //ASNLRN25 EXEC PGM=ASNLRP25,PARM='DB2F &TERM &START &PRUNE &TRACE', // REGION=0M //STEPLIB DD DSN=SYS2.DPROPR.SASNLLNK.DB2F,DISP=SHR // DD DSN=SYS1.DSNDB2F.DSNLOAD,DISP=SHR // DD DSN=CEE.SCEELKED,DISP=SHR //* DD DSN=SYS1.EDC.LINKLIB,DISP=SHR //* DD DSN=SYS1.PLI.LINKLIB,DISP=SHR //MSGS DD DSN=SYS2.DPROPR.MSGS.DB2F,DISP=SHR //CEEDUMP DD SYSOUT=* //SYSTERM DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSPRINT DD SYSOUT=*

Arne Nilsen

Posten SDS AS Nydalsvn 28, Postboks 4364 Torshov, 0402 Oslo Telefon 23 14 50 00, telefaks 23 14 50 01 Direkte tlf.nr. 23 14 46 47 URL: http://www.sds.no [...] 36371 63 20_Re: Plans-2-Packages12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Fri, 28 Jul 2000 09:03:00 +0100417_- The only things to watch out for that I can think of is that if you use default versioning you can end up with several versions of a package, so there is extra housekeeping involved. This also means that if you create the package but the load module doesn't get moved across,, the old load module will still find the package and work quite happily, but this may be bad news from the application point of view. [...] 36435 26 24_error message in db2 udb25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG31_Fri, 28 Jul 2000 17:03:48 +0800371_us-ascii Hi,

Our env is hp-ux 10, db2 udb 6.1. When I was trying to run the db2sampl, I hit the following message

"sql1043c database service could not initialise the system catalogs. error "931" was retruned."

I have the following questions:

1. I cannot find the 931 decode in the manual. 2. How much space does the sample database take. [...] 36462 24 42_Re: Enforcing uniqueness on partial column14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Fri, 28 Jul 2000 04:08:19 -0500395_iso-8859-1 The answer is no...and why would you want to do it anyway ???

And you can't define a column as substr anything ! You would have to create a new column and have your app insert the 'unique' value.

If the first part of a column has meaning as a unique value, I suspect that something has gone wrong in the data analysis. What value has the remainder of the column ?? [...] 36487 51 33_DDF performance problem in DB2 V413_myoungsoo huh19_xdbjmsh@HOTMAIL.COM29_Fri, 28 Jul 2000 06:10:31 EDT321_- Hi all , This is what I findings after I post DB2 V4 Performance problem , days ago.

After Migration to DB2 V4 , at same time DB2 connect V 5.2 was applied ( or updated ?) with new FIXPACK (?) and rebinded. After that ,I met severe SIO in DB2 V4 especially on DDF thread that submitted through DB2 connect. [...] 36539 94 16_Re: Data Sharing23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 28 Jul 2000 11:45:12 +0100388_iso-8859-1 Roy

there may be times you wish to go to a particular member though ... using the group attach name, whilst 99% of the time , is not always a "must". your thoughts?

all the best

Les

-----Original Message----- From: Roy R Reynolds [mailto:Roy_Reynolds@GAP.COM] Sent: Thursday, July 27, 2000 10:17 PM To: DB2-L@RYCI.COM Subject: Re: Data Sharing [...] 36634 26 37_Re: DDF performance problem in DB2 V414_Philip Gunning18_pgunning@PHEAA.ORG31_Fri, 28 Jul 2000 08:18:42 -0400320_us-ascii Did you submit the exact SQL statement via QMF? Did you use parameter markers or host variables? This seems to be a problem with the SQL, not DB2 Connect. Are all the indexes type 2 on the table in question? If not, DB2 will indicate that an index will be used but you will get a tablespace scan. HTH Phil [...] 36661 85 28_Re: error message in db2 udb16_Michael McCarthy18_mmccarthy@DTCC.COM31_Fri, 28 Jul 2000 08:24:38 -0400502_us-ascii Srirengan,

The "931" error returned is an SQLCODE. I have attached the description below,

-Mike.

SQL0931C Operating system file table overflow occurred. Subsequent SQL statements cannot be processed.

Explanation: An Operating system limit has been reached. The application program is not permitted to issue additional SQL statements. The database is marked as needing recovery and all applications using the database are prevented from accessing the database. [...] 36747 83 42_Re: Enforcing uniqueness on partial column13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Fri, 28 Jul 2000 07:40:59 -0500384_iso-8859-1 As mentioned, a new column is required and it needs the unique index built against it. Instead of having an application maintain that column, an INSERT trigger could do that work. gm

-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Friday, July 28, 2000 2:19 AM To: DB2-L@RYCI.COM Subject: AW: Enforcing uniqueness on partial column [...] 36831 73 36_Re: Performance problems - any tips?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 28 Jul 2000 08:03:32 -0500348_iso-8859-1 This seems to be a wise path to follow. Assuming that the MVS folks are tuning, wait until they are done and then pursue other suggestions concerning DB2 itself. If they aren't, you might suggest that they do so.

Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin [...] 36905 53 33_Re: A question about bind/package15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 28 Jul 2000 08:23:05 -0500329_iso-8859-1 No one has responded so I will give it a try.

If by a routine you mean a UDF or User-defined Function, then if the function contains SQL then a package must be bound but the package doesn't need to be in a PKLIST of the invoking plan. If the function doesn't contain SQL then no package needs to be bound. [...] 36959 53 45_Re: Data-Prop Capture Invocation JCL Problems15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 28 Jul 2000 08:49:01 -0500481_iso-8859-1 The program is called ASNLRP66 in the JCL and you mention that it is called ASNRP66. Does ASNLRP66 or ASNRP66 reside in DSN610.DPROP1.SASNLINK?

Linda Billings

-----Original Message----- From: SrinivasG [mailto:SRINIVASG@INF.COM] Sent: Thursday, July 27, 2000 6:15 AM To: DB2-L@RYCI.COM Subject: Data-Prop Capture Invocation JCL Problems



Hi, I am trying to run the Invocation JCL for DPROP I am getting a S0C1 error. The foll is the JCL [...] 37013 51 26_Re: A DB2 connect Question11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Fri, 28 Jul 2000 08:49:58 -0500365_us-ascii This happen to us about 1 year ago and I don't remember the exact table name but, have someone turn on an ODBC trace and you will be able to see what authority is missing!... : )







From: SrinivasG @RYCI.COM> on 07/26/2000 11:30 PM

Please respond to DB2 Data Base Discussion List [...] 37065 53 65_Re: Debugging a Stored Procedure(written in JAVA)in UDB 6.1 on NT13_Chris Roberts19_CTROBERT@HEWITT.COM31_Fri, 28 Jul 2000 08:51:03 -0500525_us-ascii I have gotten this to work...

You need: 1 - Visual Age for Java Professional Edition (or Enterprise Edition) - There is a seperate install for the remote debugger tool from the CD, so you have to run it seperately. 2 - There is a db2 environment variable which tells the server to enable debugging. To enable it do the following (on the server machine): db2set DB2ROUTINE_DEBUG=on a few warnings - 1 - I think it has to be run from a DB2 command window and 2 - The syntax must be EXACT - including case. [...] 37119 14 44_Web address for the stored procedure redbook13_Chris Roberts19_CTROBERT@HEWITT.COM31_Fri, 28 Jul 2000 08:53:50 -0500428_us-ascii I couldn't find it when I wrote the original note, but here is the address with the redbook I mentioned in my previous note.. http://www.redbooks.ibm.com/abstracts/sg245485.html

================================================ 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. 37134 90 45_Re: Data-Prop Capture Invocation JCL Problems0_29_STANLEY_GOODWIN@MECH.DISA.MIL31_Fri, 28 Jul 2000 09:58:03 -0400513_us-ascii Linda, Aren't you missing one thing, try putting the LE370 runtime library in the jcl.



Stan Goodwin DAC MBG DB2 Support

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





"Billings, Linda" cc: Sent by: DB2 Data Base Subject: Re: Data-Prop Capture Invocation JCL Discussion List Problems



07/28/00 09:49 AM Please respond to DB2 Data Base Discussion List [...] 37225 33 42_Re: Installing a DB2 subsystem - Continued13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Fri, 28 Jul 2000 09:58:13 EDT408_- Hi list, I sent this out yesterday. I'm not sure it got out to the list, so I'm resending. To all who responded to my initial inquiry regarding what is required to install a second DB2 subsystem, thank you very much for your comments and advice. They were very helpful in focussing my attention to the right chapters and information in the installation guide. As a followup, here is my next question: [...] 37259 30 16_Re: Data Sharing14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Fri, 28 Jul 2000 07:06:33 -0700506_iso-8859-1 On obvious time that you would want to go to a specific member rather than using the group attach name would be when you are running commands that have "member-scope" such as -dis thread(*) Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.



Roy

there may be times you wish to go to a particular member though ... using the group attach name, whilst 99% of the time , is not always a "must". your thoughts? [...] 37290 120 45_Re: Data-Prop Capture Invocation JCL Problems22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Fri, 28 Jul 2000 10:07:20 -0400319_iso-8859-1 Here a shot in dark.

I'm not familiar with the Data_Prop installation procedures. Did you have to compile or relink ASNLRP66? If you did, then if the product requires LE for OS/390, then make sure the correct LE for OS/390 libraries (CEE.SCEELKED other CEE.*) were used in the compile or relink. [...] 37411 57 16_Re: Data Sharing23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 28 Jul 2000 15:10:07 +0100594_iso-8859-1 this is exactly what I do an an hour boundary for my performance monitoring ..

Les

-----Original Message----- From: Wayne Driscoll [mailto:Wayne.Driscoll@QUEST.COM] Sent: Friday, July 28, 2000 3:07 PM To: DB2-L@RYCI.COM Subject: Re: Data Sharing



On obvious time that you would want to go to a specific member rather than using the group attach name would be when you are running commands that have "member-scope" such as -dis thread(*) Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 37469 112 45_Re: Data-Prop Capture Invocation JCL Problems15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 28 Jul 2000 09:14:55 -0500314_iso-8859-1 Just to clarify, I am not using DPROP. I was pointing out that Srinivas was using two different names for the load module in the original email. Sometimes the simplest solutions are overlooked. If Srinivas is using the wrong name for the load module it will result in a module not found condition. [...] 37582 27 25_DB2 Stored procedure help11_sudhakaranr19_sudhakaranr@INF.COM31_Fri, 28 Jul 2000 19:50:30 +0530396_- > Hi , > > We have a requirement where we need to write into a error > log file > from a stored procedure(Cobol - DB2 / DB2 version 5.2) . > > This stored procedure is to be called by a tool (CoolGen ). > > Can we write into a file from the stored procedure? > > If yes, where will i specify the name of the file > that the stored procedure has to write into? > > Thanks, > Sudhakaran R > [...] 37610 84 42_R: Problem with program binded DEGREE(ANY)15_Michele Granito29_michele.granito@ISTRUZIONE.IT31_Fri, 28 Jul 2000 16:33:17 +0200323_iso-8859-1 The program use CPU parallelism and give a generic SQLCODE -904. With Monitor Landmark DB2 I can see the SQL statement in execution, it use NOT EXISTS in predicate. In DB2 for OS/390 V5 Application Programming and SQL Guide on topics 6.4.8.3 you can see that if query use EXISTS parallelism is not allowed. [...] 37695 24 35_Re: Varchar(32672) vs. Long Varchar10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Fri, 28 Jul 2000 09:19:51 -0500450_- "...Note also a drastic side-effect of Long Varchar. Long Varchar essentially says use the rest of the page for this column. The implication of this is that it will be very difficult (impossible without extra-ordinary measures) to ever add another column to this table...."

QUESTION: As VARCHAR(n > 255) is considered LONG VARCHAR, does this imply that the above killer restriction also applies here (i.e. to 'non-LONG' VARCHAR > 255)? [...] 37720 29 14_QMF compliancy27_Landaal, Hans H SSI-ISES-4227_Hans.H.Landaal@IS.SHELL.COM31_Fri, 28 Jul 2000 16:36:53 +0200341_iso-8859-1 Hi List,

Does anyone know if DB2 V6 can run with QMF V3.3 and what about DB2 V5 and QMF V6 ? Here's some background: We just installed DB2 V6 on our test system and want to roll in out soon to other platforms, but we are not sure if we also have to upgrade QMF. From IBM we received some confusing answers about this. [...] 37750 26 33_UDB7 connecting to os/390 db2 5.10_24_lightsey@ITS.STATE.MS.US31_Fri, 28 Jul 2000 09:44:56 -0500407_us-ascii Is anyone doing this ? My UDB user just installed v7 on a test machine (HP-UX v11) and when he tries to get to the mainframe he gets SQL5048 release level of db client not supported by db server. I'm about to go onto IBMLink to look for any needed apars for the os/390 side (this was a complete surprise to me) but I wanted to see if anyone had any other suggestions to offer from experience. [...] 37777 62 18_Re: QMF compliancy0_17_sjvagnier@AEP.COM31_Fri, 28 Jul 2000 10:56:28 -0400458_us-ascii DB2 V6 can run with QMF V3.3. DB2 V5 and QMF V6, I would think QMF would be but I'm not 100% positive.

Regards...



Steve Vagnier American Electric Power









"Landaal, Hans H SSI-ISES-42" @RYCI.COM> on 07/28/2000 10:36:53 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 37840 83 16_Re: Data Sharing14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Fri, 28 Jul 2000 08:02:27 -0700455_us-ascii Les , Wayne, You are quite right. There are circumstances where the member name is the one to use. CICS affinity to a member is another case as is monitoring of specific members. To repeat, anyone looking at data sharing needs to 'read the friendly manuals' to get a fuller appreciation of the magnitude of the project as well as the key benefits in the areas of processing scalability and high availability. HTH, Roy (standard disclaimers) [...] 37924 89 18_Re: QMF compliancy16_Michael McCarthy18_mmccarthy@DTCC.COM31_Fri, 28 Jul 2000 11:10:18 -0400476_us-ascii Hans,

I'm running QMF V3.2 with DB2 V6.1 PUT0003.

-Mike.











sjvagnier@AEP.COM on 07/28/2000 10:56:28 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Michael McCarthy/DTC) Subject: Re: [DB2-L] QMF compliancy







DB2 V6 can run with QMF V3.3. DB2 V5 and QMF V6, I would think QMF would be but I'm not 100% positive. [...] 38014 70 18_Re: QMF compliancy0_18_damcon2@US.IBM.COM31_Fri, 28 Jul 2000 11:10:21 -0400538_us-ascii Hans,

We're running fine with DB2 V6 and QMF 3.2. So I would think QMF 3.3 would be fine.

Cheers, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW -----------------------------------------------------



"Landaal, Hans H SSI-ISES-42" @RYCI.COM> on 07/28/2000 10:36:53 AM [...] 38085 55 18_Re: QMF compliancy12_Kirk Hampton16_khampto1@TXU.COM31_Fri, 28 Jul 2000 10:11:06 -0500364_us-ascii Not sure about running QMF v3.3 with DB2 v6, but it should work. We upgraded all our QMF to v6.1 before we upgraded our test DB2 to v6.1, so right now we are running QMF v6.1 with both DB2 v5.1 and v6.1, no problems.











"Landaal, Hans H SSI-ISES-42" on 07/28/2000 09:36:53 AM [...] 38141 64 29_Re: DB2 Connect PE management13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Fri, 28 Jul 2000 10:17:57 -0500648_iso-8859-1 Richard,

We keep several levels of install code around as well. We are also investigating the impact of cleaning up old packages, including sets where users may have performed a non-standard install with the default bind options.



I'd be interested in hearing about the success people have had with the 'thin-client' model. This is using a file server to distribute one (or more?) standard version(s) of the client code and using a directory to distribute the configuration information. Each client would receive the DLL's etc once (i.e. after startup in the morning) and they would remain in memory during the [...] 38206 31 23_Data Dictionary Options15_Klassy, Carolyn30_Carolyn.Klassy@TRS.STATE.TX.US31_Fri, 28 Jul 2000 10:23:37 -0500509_iso-8859-1 Hello DB2-L Listers!

Management has requested a response to this question.

We are trying to decide what is the best method of building a data dictionary for the columns on our database. One suggestion has been to use the Remarks column on SYSIBM.SYSCOLUMNS to keep the definitions of the columns. Is maintaining this information in the DB2 catalog a generally recognized standard in the DB2 world? What other methods would you suggest or are you using to keep this type of data? [...] 38238 52 16_Re: Data Sharing20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 28 Jul 2000 11:19:46 -0400310_us-ascii Also, when you run CAF or RRSAF, The group attach has a disadvantage of ignoring START ECB. Using the specific member name enables START ECB parameter. However the START ECB as well as "member scope" for some DB2 commands are changing in V7 or in V6 with few APARs such as PQ29031 & PQ25094 etc. [...] 38291 241 24_FYI DFHSMDSS 1.5 and DB213_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 28 Jul 2000 10:33:41 -0500599_US-ASCII Greeting list users, I thought I'd pass this along because it affected us for months. APAR OW45188 : Resolves a problem when recalling a DB2 dataset with a CI size greater than 32K. Without PTF UW71405 you may experience a 00C200FD ABEND. The IBM error description follows :



ERROR DESCRIPTION: Following a DFSMSdss 1.5.0 logical RESTORE of a VSAM LDS data set, the target data set was corrupted. This problem will occur when the data set being restored has more than 32K CI's. In the reported case, the data set was part of a DB2 application. The RESTORE completes with [...] 38533 18 30_multithreaded DB2 application.31_Cagdas Ucar (Garanti Teknoloji)22_cagdasu@GARANTI.COM.TR31_Fri, 28 Jul 2000 17:31:01 +0300528_- Hi all,

I want to write a multithreaded server using C on OS/390(not Open MVS) which uses DB2 statically. Is this possible?... Because I know that there are restrictions for writing a multi-task server in PL/1 if it uses DB2. Any comments on that?...

Thanks in advance..

================================================ 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. 38552 115 20_Re: Plans-2-Packages14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Fri, 28 Jul 2000 08:37:56 -0700577_us-ascii I, like many, migrated to use of packages back in the old days. I used 'auto' versioning. Be sure you have some process in place to periodically purge 'old' versions of packages from sysibm.syspackage. For the development environment, I did this my running a batch REXX job to build a 'package purge job' to: 1. keep all packages bound in the last three weeks, and 2. keep up to two versions of every package for 60 days, and 3 always keep the most current version of every package. This same batch REXX used different time limits for the production environment. [...] 38668 24 35_Re: Varchar(32672) vs. Long Varchar13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 28 Jul 2000 12:00:51 -0400415_iso-8859-1 >As VARCHAR(n > 255) is considered LONG VARCHAR

John, Long Varchar is a different data type specification than Varchar.

I believe what you might be recalling is that

a Varchar column with a maximum length > 255 is a long string column.

This is not the same as Long Varchar.

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com [...] 38693 22 37_Re: UDB7 connecting to os/390 db2 5.113_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 28 Jul 2000 12:11:20 -0400383_iso-8859-1 I am connecting successfully from Windows 2000 UDB v7 up to a v5 OS/390 DB2. I don't have handy access to an HP machine.

I believe I've heard officially somewhere that the intended policy is to support 2 levels back. Theoretically what you're trying should work.

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com [...] 38716 54 42_Re: Installing a DB2 subsystem - Continued12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 28 Jul 2000 19:59:48 +0200573_x-user-defined Hi, The famous "It Depends" (on your workload on both subsystems and the rest of the MVS system). Any subsystem needs memory of its own so you have to look after it carefully (and over your paging datasets as well).

Isaac Yassin





Carlton Enuda wrote: > > Hi list, > I sent this out yesterday. I'm not sure it got out to the list, so I'm > resending. To all who responded to my initial inquiry regarding what is > required to install a second DB2 subsystem, thank you very much for your > comments and advice. They were very [...] 38771 15 34_Re: Do we need WLM to use DSNTPSMP9_Jim Ruddy18_jaruddy@US.IBM.COM31_Fri, 28 Jul 2000 11:46:31 -0500472_- If you are using the IBM REXX Language Support then this must run under WLM. It has never been tested under the DB2 SPAS address space and the results will be unpredictable, perhaps exciting!

Jim Ruddy IBM DB2 Development

================================================ 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. 38787 15 33_Re: I'm in trouble - DB2v6 OS/3909_Jim Ruddy18_jaruddy@US.IBM.COM31_Fri, 28 Jul 2000 11:50:38 -0500443_- SDSNLOAD MUST be APF authorized but I believe the only code that a user would execute out of SDSNLOAD that must invoked authorized would be DSNUTILB or DSNUTILS.

Jim Ruddy IBM DB2 Developement

================================================ 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. 38803 47 12_sql question10_Mike Evans28_EVANSMP@CO.MECKLENBURG.NC.US31_Fri, 28 Jul 2000 13:40:50 -0400335_US-ASCII I would like to get some advice from the list concerning a sql statement. I have two tables, table a and table b , that look similar to the following:

table a table b col1 col1 col2 col2 date

where the primary key is col1+ col2 + date for table b. this index is clustered as col1 asc, col2, asc, date desc. [...] 38851 55 27_Re: Data Dictionary Options14_Laredo, Andrew19_Andy_Laredo@BMC.COM31_Fri, 28 Jul 2000 12:37:53 -0500445_iso-8859-1 It would not be a very good solution (although a cheap one) from a data design/model point of view. You will have dupl. columns across your physical tables (say primary/foreign keys) ....how would you keep all the remarks columns in synch for the same data column, or if you tried to keep the remarks updated in only one of the syscolumn remarks entries what if you ever dropped that column, then your data dictionary goes away. [...] 38907 40 34_Re: Do we need WLM to use DSNTPSMP22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Fri, 28 Jul 2000 13:47:31 -0400574_iso-8859-1 Jim -

Good one... I like your sense of humor.



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





-----Original Message----- From: Jim Ruddy [mailto:jaruddy@US.IBM.COM] Sent: Friday, July 28, 2000 12:47 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Do we need WLM to use DSNTPSMP



If you are using the IBM REXX Language Support then this must run under WLM. It has never been tested under the DB2 SPAS address space and the results will be unpredictable, perhaps exciting! [...] 38948 203 16_Reorg Procedures22_Donnie Woodruff (Work)30_dwoodruf@CI.NEWPORT-NEWS.VA.US31_Fri, 28 Jul 2000 14:01:04 -0400574_iso-8859-1 DB2L'ers:

This is my first attempt at setting up procedures for reorging DB2 tablespaces and I have a couple of questions:

Some background info on our shop: DB2 v5.1 for OS390 Our standard is to have 1 table per tablespace (1:1). We (and I) are all quite new to DB2.

1. I understand it is important (for faster recovery) to take a full image copy of the tablespace that will be reorged. But, my question is, should I take full image copies of ALL tablespaces that are related to the tablespace that will be reorged? The reason I ask is, [...] 39152 64 16_Re: sql question13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM31_Fri, 28 Jul 2000 14:17:05 -0400527_us-ascii How about this?

select DISTINCT a.col1 ,a.col2 ,MAX(b.date) from tablea a ,tableb b where a.col1 = b.col1 and a.col2 = b.col2

Scott Lindsey Sr. DBA, Highlights for Children

Mike Evans wrote: > > I would like to get some advice from the list concerning a sql statement. > I have two tables, table a and table b , that look similar to the > following: > > table a table b > col1 col1 > col2 col2 > date > > where the primary key is col1+ col2 + date for table b. this index is > clustered as > [...] 39217 118 20_Re: Reorg Procedures15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 28 Jul 2000 13:26:13 -0500570_iso-8859-1 Hi, Donnie, Are you going to perform online reorgs, meaning that update activity can occur during the reorg? If not, once you start the reorg there isn't going to be any update activity against the tablespace that is being reorganized because your utility will have it and no one else will be able to use it. That is why reorgs are done during periods of low activity. If you are performing online reorgs, my understanding is that the changes queue up while the reorg is taking place and then are applied to the newly reorganized table. In both cases it [...] 39336 205 20_Re: Reorg Procedures14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Fri, 28 Jul 2000 11:31:45 -0700609_us-ascii

Donnie, No need, in my experience to image copy related tablespaces if they are not to be reorged. Image copy only the tablespaces or partitions being reorged.....both before and after the reorg. It is a good idea to include a jobstep or control card after the last image copy to MODIFY (purge) old SYSIBM.SYSCOPY info on the reorged tablespaces as well. While writing your own can be done given enough time and DB2 knowledge, I recommend a 'buy' rather than 'build' solution. Building the jobs is most reliably done by a third-party utility. CA-Platinum, BMC, and the other big vendors [...] 39542 55 32_Re: DB2 V4 to V5 migrate problem0_17_JTonchick@AOL.COM29_Fri, 28 Jul 2000 14:50:59 EDT436_US-ASCII Joe, I ran across the same problem during my receint migration from v4 -> v5. In my case is was a simple problem, I accidently invoked the v4 install clist (which was concatinated on TSO SYSPROC). I corrected this by invoking the v5 install clist from a setup clist in which I issued an ALTLIB ACTIVATE APPL(CLIST) DA('SMPE.DSN510.SDSNCLST') command, and LIBDEFs for SDSNSPFM & SDSNSPFP. Once I did that, DSNTINST ran ok. [...] 39598 27 37_LAN Install of DB2 6.1 UDB Win Client13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Fri, 28 Jul 2000 15:32:09 -0400335_iso-8859-1 Hello,

I have been trying to set up the DB2 6.1 Winxx Run-time Client to be installed from a LAN Drive. I have followed the install guide to the letter...using the CPYSETUP.BAT directory EN ...where EN is English. I am able to install from the LAN drive on my machine, but other users get the following message: [...] 39626 27 42_Re: Enforcing uniqueness on partial column7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Fri, 28 Jul 2000 14:23:33 -0500398_- Colin,

In general you are right that it does not make sense that only the first part of a column is unique. However, this is an exceptional case where we are performing MATCHING of new data against the existing in the database. For example we are matching on SSN and first 4 characters of a person's last name to see if the person we are trying to add already exists in the database. [...] 39654 25 42_Re: Enforcing uniqueness on partial column13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Fri, 28 Jul 2000 14:31:17 -0500366_- >Based on our existing data patterns, we have established that people are >very inconsistent with the spelling of their last names, including typos, >spacings, etc. So if we based our comparisons on the entire last name, then >we would miss some of matches. > >Another problems is that we have established that SSN is non-unique and can >be used and misused. [...] 39680 37 22_ETL ( or just E ) tool13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Fri, 28 Jul 2000 15:56:39 -0400475_us-ascii Hi , I would appreciate suggestions for an ETL , or just an extract tool , which would fit in the following scenario : There are many servers( say 50 ) , distributed all over US . They are NT boxes , running Informix . The database ( tables , indexes , etc ) is the same at every location . Every night we have to collect data from all these servers , consolidate them , and load it to a central database . This central database is running on DB2 V5 / OS/390 . [...] 39718 51 42_Re: Enforcing uniqueness on partial column0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Fri, 28 Jul 2000 14:53:52 -0500681_us-ascii Is there a way of doing this in version 6 with triggers??

Larry Kirkpatrick Mutual of Omaha





Db2 Dba cc: Sent by: DB2 Subject: Enforcing uniqueness on partial column Data Base Discussion List



07/27/2000 05:20 PM Please respond to DB2 Data Base Discussion List











Is there any efficient way to enforce uniqueness on part of a column. For example, if you need to make sure that the string made of the first 4 characters of the last name is unique (not the whole last name), is there any way to create a unique index? [...] 39770 18 48_Re: UDB7 connecting to os/390 db2 5.1 - it works0_24_lightsey@ITS.STATE.MS.US31_Fri, 28 Jul 2000 15:07:21 -0500355_us-ascii Thanks to all who responded. The problem turned out to be that the UDB guy cataloged "something" wrong. He fixed that and all seems to work as advertised - even Apply ! ( we never were able to get Apply to work between db2 v5 on os/390 and udb v6 on the hp-ux v11 box - the Toronto guys must have found and fixed that problem (thanks guys)) [...] 39789 238 20_Re: Reorg Procedures15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Fri, 28 Jul 2000 13:21:40 -0700565_iso-8859-1 Donnie, The process we use was put in place before my time, when we were a new to DB2 shop, so I don't say I understand the strategy of it all but it has worked quite well for us. All reorgs all scheduled and are run Sunday morning beginning at 5:30 AM, our lowest activity time. (We haven't investigated on-line reorgs yet . We just got to V5) We schedule reorgs weekly, bi-weekly or monthly, based on anticipated table update/growth activity. Full DRA Image copies of all tables are taken before the Reorgs start. Tables are separated as either a [...] 40028 20 11_DB2 Locking17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM31_Fri, 28 Jul 2000 14:16:31 -0700408_us-ascii We are using LOCK ANY for our segmented tablespaces which is fine for our onlines but not necessarily for our batch. We were going to run alters for our tablespaces specifying locks on the tablespace prior to running batch to see if it would improve performance. Does anyone know of any other way of running batch with a different locking specification other than running alters prior to them. [...] 40049 39 14_R: DB2 Locking17_Fiorese Giampaolo29_Fiorese.Giampaolo@GENERALI.IT31_Fri, 28 Jul 2000 23:29:06 +0200640_iso-8859-1 Why don't you use the LOCK TABLE stmt.? Regards

-----Messaggio originale----- Da: Charles Jambrosic [mailto:Charles_Jambrosic@CSIHOME.COM] Inviato: venerdì 28 luglio 2000 23.17 A: DB2-L@RYCI.COM Oggetto: DB2 Locking

We are using LOCK ANY for our segmented tablespaces which is fine for our onlines but not necessarily for our batch. We were going to run alters for our tablespaces specifying locks on the tablespace prior to running batch to see if it would improve performance. Does anyone know of any other way of running batch with a different locking specification other than running alters prior to them. [...] 40089 57 23_Logging to a raw device6_csc26618_csc266@HOTMAIL.COM31_Fri, 28 Jul 2000 14:33:32 -0700334_iso-8859-1 environment: DB2 v6.1 on AIX

I am configuring my DB2 server to write logs to a raw device. Does this mean I can't do archive logging and would only be allowed circular logging ? The reason I am using raw partitions is to prevent against lost data due to O.S buffering when using regular filesystem directories/files. 40147 49 27_Re: Logging to a raw device13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Fri, 28 Jul 2000 17:25:45 CDT374_- You can put both archival (I tested this one) and i believe circular too on raw devices ....but it is not very flexible !!! IBM does not provide any tool to query how space is left on the device in other words you can not monitor space used by your active logs on a raw device. Such a monitor, in my humble opinion is extremely important in a production environment. [...] 40197 73 27_Re: Logging to a raw device6_csc26618_csc266@HOTMAIL.COM31_Fri, 28 Jul 2000 15:49:26 -0700462_Windows-1252 How do you do archival logging ?. Wouldn't you need to back up your archives off to tape or disk ? If you have logging done to a raw device and it fails, how can you do rollforward recovery from 'backup archived log files' ?



----- Original Message ----- From: "Umair Hussain" Newsgroups: bit.listserv.db2-l To: Sent: Friday, July 28, 2000 3:25 PM Subject: Re: Logging to a raw device [...] 40271 84 34_Users changing their own passwords6_csc26618_csc266@HOTMAIL.COM31_Fri, 28 Jul 2000 15:59:51 -0700411_iso-8859-1 Is there a way to accomplish DB2 password changes with the following constraints

AIX env. DB2 v6

1. Users should never be able to log on directly to the Unix backend that has their login a/c 2. telnet, ftp, any interactive sessions not allowed 3. Only a user should know her own password. Shouldn't have to blurt it out to the Unix admin etc 4. Be able to change passwords at will [...] 40356 103 27_Re: Logging to a raw device13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Fri, 28 Jul 2000 18:15:04 CDT522_- IBM provides a userexit exit program to copy/archive transaction logs to an archived path (i.e a filesystem on unix). For this to happen you need to turn USEREXIT = ON in db cfg for db and modify the db2uext2 program to fit your environment. You can get detailed information from the admin guide. But if you dont have USEREXIT=ON but still want to do archival logging (LOGRETAIN=ON) then in a recovery situation there is a BIG question mark .. and you basically have to count on your lucky stars .....!!!! [...] 40460 139 27_Re: Logging to a raw device4_Ln S18_csc266@HOTMAIL.COM31_Fri, 28 Jul 2000 18:30:34 -0500503_- Thanks for your response

I did review the userexit programs that DB2 comes with, however, I can't see how you can get these to work with a raw partition ??!!

They seem to want to archive off actual files. Perhaps we're missing on the definition of a raw partition. I'm basically using a logical volume's device file (e.g /dev/rdb2l1) as the logpath. I can't see how I can ask a 'filesystem' to be archived , in my userexit program. I'd be curious to know how you accomplished this. [...] 40600 93 27_Re: Data Dictionary Options13_OConner, John26_John.OConner@COURTS.WA.GOV31_Fri, 28 Jul 2000 17:19:34 -0700582_iso-8859-1 Our organization uses two types of "data dictionary like" information. We store this information in HTML that is accessible from our intranet. The first type of information is about the physical characteristics of our tables/columns. We have a program that we run once a week to query the DB2 catalog and build the appropriate HTML (a fully automated process). The second type of information is an expanded description of the individual data elements. The programmers edit HTML templates (a manual process so far) as they add new tables and columns to the database. [...] 40694 127 45_Re: Data-Prop Capture Invocation JCL Problems9_SrinivasG17_SRINIVASG@INF.COM31_Sat, 29 Jul 2000 09:43:08 +0530681_iso-8859-1 ASNLRP is in the Dataset DSN610.DPROP1.SASNLLNK. I have added the CEE Libraries in the Steplib such as SCEERUN & SCEELKED. Still the same result.

-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Friday, July 28, 2000 7:45 PM To: DB2-L@RYCI.COM Subject: Re: Data-Prop Capture Invocation JCL Problems



Just to clarify, I am not using DPROP. I was pointing out that Srinivas was using two different names for the load module in the original email. Sometimes the simplest solutions are overlooked. If Srinivas is using the wrong name for the load module it will result in a module not found condition. [...] 40822 59 44_DB2 Symposium 2000 - Chicago IL Sept 13-15th12_Susan Lawson26_susan_lawson@ATTGLOBAL.NET31_Fri, 28 Jul 2000 23:39:37 -0500496_iso-8859-1 Dear DB2 Professional,

I would like to announce the upcoming schedule for the DB2 Symposium Education Event in Chicago, Il. at the Marriott Courtyard - Downtown. If you register before August 15th you qualify for a 15% early bird discount.

Chicago, IL September 13th-15th

All in-depth sessions are 1 day each and are taught by some of the most famous DB2 instructors world-wide. All attendees will recieve a FREE copy of the new YL&A DB2 Performance Journal. [...]