1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2000, week 5 2 63 26_Re: Migrating DB2 V5 to V623_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 29 Jun 2000 06:11:29 +0100418_iso-8859-1 Joe I have done both Datasharing and Non and there were no problems .. I have to say that I found it to be one of the easiest upgrades ever .. main thing is you checkout and configure all the new ZPARMS that come with it .. i.e make sure you read up on all thos ZPARMS that change, get added and where appropriate "taken away" - but then if you are doing an upgrade this is pretty standard practice .. [...] 66 54 16_FW: SQLCODE -3107_Sanjeev19_Sanjeev@INTERRA.COM31_Thu, 29 Jun 2000 11:12:06 +0530568_iso-8859-1 Hi Ben, I faced -310 sqlcode many times and it is exactly because of some of our fault in the coding.So the possibilities you shall check are the data type of the column and host variable.It should match exactly.What data type you are using for host variable and what is there for the column definition ?.One mistake which i can recall is the sequence of the column name in the insert clause and in the value clause ,check for that as well.Another thing is ,Just try initializing the host variable before movement. If you have seen SQLDA then you must [...] 121 80 36_Re: Java Stored Procedures on OS/39014_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Thu, 29 Jun 2000 10:55:39 +0100488_iso-8859-1 Hi.

Last I heard was that the Java Stored Procedures APAR didn't make the June RML, and still isn't available as far as I'm aware.

regards,

Julian

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

Julian Stuhler DB2 Specialist, IBM Gold Consultant Triton Consulting

E-mail: julian.stuhler@triton.co.uk Web: http://www.triton.co.uk Mobile: +44 (0)7768 446927 Personal Fax: +44 (0)870 1243510 Office Tel: +44 (0)870 2411550 Office Fax: +44 (0)870 2411549 [...] 202 24 64_Tools for comparing table contents before and after test scripts20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Thu, 29 Jun 2000 11:17:17 +0100367_iso-8859-1 OS/390 V5

I have been asked to suggest tools suitable for comparing the contents of a DB2 table before and after the running of a test script - i.e. something that can produce a list of changes and (ideally) reconcile these with the expected results.

Because of global agreements I would be biased towards a BMC or CA/Platinum solution. [...] 227 29 74_Getting tablespace scan for an access using one of the primary ke y column8_madhavan16_madhavan@INF.COM31_Thu, 29 Jun 2000 15:34:24 +0530545_- Hi,

In one of our tables the primary kay is

broker-number, Type Bill Number

The following SQL gives a tablespace scan in the development environment. Can you please highlight what we are missing ?

SELECT * FROM table WHERE broker_number = :variable

Regards Madhavan.

================================================ 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. 257 48 69_Re: Tools for comparing table contents before and after test scri pts16_Ruane, Paul (P.)16_pruane1@FORD.COM31_Thu, 29 Jun 2000 06:26:00 -0400493_iso-8859-1 Hugh

It's not BMC or CA, but have a look at Compare for DB2 from Princeton Softech (http://www.princetonsoftech.com/library/rt/comparefordb2pd-us.pdf). I'm not sure whether it can do the reconciliation though.

Paul Ruane

Ford Motor Company

-----Original Message----- From: Beighton-Dykes, Hugh [mailto:hugh.beighton-dykes@EDS.COM] Sent: 29 June 2000 11:17 To: DB2-L@ryci.com Subject: Tools for comparing table contents before and after test scripts [...] 306 115 78_Re: Getting tablespace scan for an access using one of the primary ke y column0_18_mebert@AMADEUS.NET31_Thu, 29 Jun 2000 12:35:09 +0100570_us-ascii If the statistics indicate the table is very small, DB2 will choose a TS scan (note DB2 doesn't know actual size of table unless you run RUNSTATS). Or the statistics might indicate a low filter factor for this column. Yet another possibility is that the datatypes of the BROKER_NUMBER column and the host variable differ, in which case DB2 won't use the index. Different lengths are enough. I think the latter is improved in V6, and there's a new ZPARM option to tell DB2 to use indexes even for small TSs (I'm not yet familiar with the V6 possibilities). [...] 422 311 43_Re: Row level Locking Vs Page Level Locking12_Susan Lawson26_susan_lawson@ATTGLOBAL.NET31_Thu, 29 Jun 2000 07:09:49 -0500640_iso-8859-1 Hello Mohamed,

Row level locking should be used when a page of data is simultaneously needed by multiple applications, and each user’s interest is on different rows. If the interest is on the same row, row level locking buys you nothing. Page level locking is still preferred on OS/390 with row level locking being the exception when absolutely required by the application (ex. SAP). Row leveling locking is not a resolution for deadlocks, it can actaully cause more concurrency problems. You would only want to consider row level locking for random processes, not sequential because for sequential processes that is [...] 734 68 79_AW: Getting tablespace scan for an access using one of the primar y ke y column12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 29 Jun 2000 13:06:49 +0200663_iso-8859-1 Madhava,

sometimes we had the same situation. How many different broker-numbers do you have in your development environment ? If there are only a few different numbers DB2 may decide to scan the data and not to use the index...

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 ----------------------------------------------------------------------- [...] 803 538 23_Re: V6.1 -415 on Bind ?15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 29 Jun 2000 08:13:41 -0400383_iso-8859-1 Thanks Rob and others who have responded.

It appears we do not have this APAR applied to our V6.1 environment, but looks like it would solve our problem, so ...my thanks.

Susan Loria

-----Original Message----- From: Rob Lake [mailto:robert.lake@CONTI.DE] Sent: Wednesday, June 28, 2000 1:15 PM To: DB2-L@RYCI.COM Subject: Re: V6.1 -415 on Bind ? [...] 1342 124 49_SQL to determine unneeded referential constraints9_jim.szabo22_jim.szabo@MCIWORLD.COM31_Thu, 29 Jun 2000 08:35:33 -0400353_iso-8859-1 Esteemed list,

Environment: DB2/390 V5

Need to construct an SQL statement or procedure against the DB2 Catalog, and wonder if someone has already done this and could share.

Inherited support for a database with a very high rate of DB2-managed referential integrity used - in some cases, as much as nine tables deep! [...] 1467 69 53_Re: SQL to determine unneeded referential constraints17_Linda F. Claussen18_lindafc@NETINS.NET31_Thu, 29 Jun 2000 07:50:29 -0500360_ISO-8859-1 Jim,

It might be easier to run the REPORT TABLESPACESET utility to find all your RI. All you need to do is list 1 tablespaces and it will report all the related tablespaces & tables that are related. I have found this utility extremely beneficial in identifying relationships and much easier than developing queries against the catalog. [...] 1537 12 12_Re: DSNUTILS18_Sandra Lakenburger34_sandra.lakenburger@MAIL.SPRINT.COM31_Thu, 29 Jun 2000 07:38:50 -0500444_- Have you looked at PQ39077? There isn't much of a description, but it does talk about -471 sqlcodes from stored procedures with a reason code of 00e79002 and was just opened in the last several weeks.

================================================ 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. 1550 45 69_Re: Tools for comparing table contents before and after test scri pts16_Peddycoart, Judy22_peddycoa@UILLINOIS.EDU31_Thu, 29 Jun 2000 08:33:19 -0500381_iso-8859-1 I would suggest that you look at Princeton Softech's Compare for DB2. It allows you to compare the before and after (either thru extracts or two different sets of tables), and report on the differences. If there is RI defined, it will also tell you any inserts or deletes due to cascades. Sorry, it's not a BMC or Platinum solution, but it is a very powerful tool! [...] 1596 49 53_User Defined Functions: infix notations and qualified17_William R. Miller32_william.miller@DRESDNER-BANK.COM31_Thu, 29 Jun 2000 08:23:35 -0500342_- Hello all,

While experimenting with DB2 OS/390 User Defined Functions, specifically sourced functions, I have encountered a (lacuna / bug / feature) (choose one).

When you define a UDF using a standard infix operator such as "*" (multiplication), you can use it in your SQL in many ways. Here is the function definition: [...] 1646 50 69_Re: Tools for comparing table contents before and after test scri pts13_Thomas, Janis19_Janis.Thomas@CA.COM31_Thu, 29 Jun 2000 09:40:33 -0400560_iso-8859-1 RC/Compare from Computer Associates, which is a component of RC/Migrator. More information can be found here: http://www.cai.com/products/db2/database_admin/products.htm

Janis Thomas DB2 Product Management Computer Associates International, Inc. janis.thomas@ca.com 630-481-1830





-----Original Message----- From: Beighton-Dykes, Hugh [mailto:hugh.beighton-dykes@EDS.COM] Sent: Thursday, June 29, 2000 5:17 AM

Subject: Tools for comparing table contents before and after test scripts



OS/390 V5 [...] 1697 29 35_Altering a Table to add new columns13_Moss, William15_MossW@AETNA.COM31_Thu, 29 Jun 2000 09:54:59 -0400341_- I have altered a table with fixed length rows and added two new columns and now DB2 treats the rows as variable length. The Administration Guide says that to change the rows back to fixed length do the following two things:

1. Run a reorg. 2. Run the Modify utility to delete records of all image copies made before the reorg. [...] 1727 577 23_Re: V6.1 -415 on Bind ?0_18_TOUSSAN@UK.IBM.COM31_Thu, 29 Jun 2000 14:53:49 +0100521_us-ascii Caution

APAR= PQ38452 - complex SQL receives -415 after UQ37542 applied - SQL fine in DB2 R510 and before UQ37542. This APAR is still open. We have recieved UQ37542 but not applied it yet.

Regards, Neil

Email: Neil_Toussaint@uk.ibm.com



"Loria, Susan C." on 29/06/2000 13:13:41

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Neil Toussaint/UK/IBM) Subject: Re: V6.1 -415 on Bind ? [...] 2305 35 38_Re: BIGINT as Partitioning Key in EEE?11_Steve Mazer17_smazer@FMTUSA.COM31_Thu, 29 Jun 2000 10:11:46 -0400636_us-ascii While I haven't used a BIGINT column as a partitioning key yet, I don't know of any reason why it couldn't be used. I believe that it would be better than using some large decimal(x,0) key.

Regards, Steve Mazer Senior Database Consultant Fourth Millenium Technologies

At 07:40 PM 6/28/00 -0500, you wrote: >Hi, > >Is there any limitation is using a BIGINT column as partitioning key in >EEE. We are using a generated (surrogate) BIGINT column as primary key for >a bunch of tables. This will be used as partitioning key. > > >Any comments? > >================================================ >To change your [...] 2341 156 69_Re: Tools for comparing table contents before and after test scri pts9_Sally Mir22_Sally.Mir@WACHOVIA.COM31_Thu, 29 Jun 2000 10:01:36 -0400482_us-ascii

Janis, Is RC/Compare used to compare DATA? I've always used it to compare DDL. For data comparisons, I've always used the Princeton products.

Sally Mir, DB2 DBA Wachovia Bank







"Thomas, Janis" @RYCI.COM> on 06/29/2000 09:40:33 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: [...] 2498 44 69_Re: Tools for comparing table contents before and after test scri pts8_Long, Ed15_Ed.Long@FMR.COM31_Thu, 29 Jun 2000 10:11:10 -0400626_- We use COMPAREX from Serena Software. Princeton Softech also has a product. For this specific purpose, COMPAREX works well although their syntax is a little tough. I have no experience with Princeton's product.



> -----Original Message----- > From: Beighton-Dykes, Hugh [SMTP:hugh.beighton-dykes@EDS.COM] > Sent: Thursday, June 29, 2000 6:17 AM > To: DB2-L@RYCI.COM > Subject: Tools for comparing table contents before and after test > scripts > > OS/390 V5 > > I have been asked to suggest tools suitable for comparing the contents of > a > DB2 table before and after the running of a test script - i.e. [...] 2543 598 23_Re: V6.1 -415 on Bind ?15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 29 Jun 2000 10:26:00 -0400309_iso-8859-1 Niel,

Again my thanks for this information as during review, I did not see that UQ37542 had a PE issued against it. I am now looking a backing the PTF UQ37542 off since when I review PQ38452, it appears a fix won't be available until 8/2000. Oh boy what fun!

Thanks, Susan Loria [...] 3142 20 18_UNIX UDB Questions13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Thu, 29 Jun 2000 09:11:26 -0500585_- I have two UNIX UDB v5.x questions.

1. We want to change from circular to archive logging on one of our databases. Besides stopping the database, changing LOGRETAIN to Yes/ON, verifying LOGPATH, LOGFILSIZ, LOGPRIMARY, and LOGSECOND, and taking a backup....is there anything we have to do?

2. How do you move a database and associated tablespaces to another disk? We don't want to Alter it and add space to it. We want to totally move it. I have looked thru all of the reference manuals and can't find anything related to this. Has anyone done this and how did you [...] 3163 101 69_Re: Tools for comparing table contents before and after test scri pts13_Thomas, Janis19_Janis.Thomas@CA.COM31_Thu, 29 Jun 2000 10:26:48 -0400307_iso-8859-1 Thanks for pointing that out. I guess I read the original email too quickly before I responded. RC/Compare is actually used to compare the DB2 table structures (or any DB2 object), not data. It's the Data Compare component of RC/Update that is used to compare data. Sorry for the confusion! [...] 3265 118 26_Re: Migrating DB2 V5 to V623_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 29 Jun 2000 10:40:38 -0400677_iso-8859-1 We had following problems after migration to v6

? Stored procedures with no parameters are found to have inherited parameters after conversion; this is documented by IBM APAR UQ36233 (no fix yet); workaround is to drop/create procedure. ? Message DSNH312I (invalid/unusable host variable) on precompile of SQL statement using a host variable as the object of the IN clause; documented by IBM APAR/PTF PQ35859/UQ41287 ? With parallelism enabled, a SELECT MAX(date_col_type) returns the date in unformatted form; workaround is to disable parallelism for the query; documented by IBM APAR PQ35562. ? Some join queries perform significantly worse in V6 than [...] 3384 28 30_Starting DB2 when TCP/IP down.12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Thu, 29 Jun 2000 10:32:01 -0400371_us-ascii Hi all,

We have had a couple of occasions after an IPL that TCP/IP has a corrupt SYSHFS file and as a result DB2 fails to fully initialize. It stops after the 'DSNL003I + DDF IS STARTING' message.

As 95% of our DB2 traffic is local, more people would be happy if a non-DDF version of DB2 could be started while the TCP/IP issue is sorted out. [...] 3413 62 39_Re: Altering a Table to add new columns17_William R. Miller32_william.miller@DRESDNER-BANK.COM31_Thu, 29 Jun 2000 09:29:23 -0500558_- Hi Bill,

You can run load replace instead of a reorg if you have a segmented tablespace and the affected table is the only one contained in the tablespace, or if it is a partitioned tablespace.

The question with the modify is somewhat more complicated. Modify cleans out the DBD. The DBD is where DB2 stores it's opinion of your data, in other words, if it is fixed length or variable. Modify will only flip the switch if there is no chance of recovering any data to a point in time in which, in it's opinion, you have a variable-length [...] 3476 81 69_Re: Tools for comparing table contents before and after test scri pts23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 29 Jun 2000 10:46:09 -0400744_- Janis...Can I do data comparison with RC/COMPARE ? I have always done DDL comparison with it.

Sanjay

> -----Original Message----- > From: Thomas, Janis [SMTP:Janis.Thomas@CA.COM] > Sent: Thursday, June 29, 2000 9:41 AM > To: DB2-L@RYCI.COM > Subject: Re: Tools for comparing table contents before and after test > scri pts > > RC/Compare from Computer Associates, which is a component of RC/Migrator. > More information can be found here: > http://www.cai.com/products/db2/database_admin/products.htm > > Janis Thomas > DB2 Product Management > Computer Associates International, Inc. > janis.thomas@ca.com > 630-481-1830 > > > > -----Original Message----- > From: Beighton-Dykes, Hugh [mailto:hugh.beighton-dykes@EDS.COM] [...] 3558 22 68_What replaced the "using" clause of the LOAD utility in DB2/UDB V 6?12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 29 Jun 2000 09:48:08 -0500552_iso-8859-1 Under DB2/UDB V5 this is where you supplied a path to a large enough file system where the keys could be stored during the index build phase. I can find no documentation on this in either of the Admin Guides (performance or Design) or in the Data Movement Guide either. It looks like it wants to do all the sorting in the temporary Tablespace now. Does this mean TEMPSPACE1 now has to be large enough under V6 to support the BUILDs of all the LOADs that might be running concurrently as well as any query sorts that might be occurring? [...] 3581 119 26_Re: Migrating DB2 V5 to V612_Kirk Hampton16_khampto1@TXU.COM31_Thu, 29 Jun 2000 09:47:41 -0500532_us-ascii Hello Joe, I would have to agree with Leslie, the upgrade it self goes smoothly, as it usually does for us. We have only done our test systems so far, as we ran into some abend situations that have scared us away from going production until we get some resolutions from IBM. We are non- datasharing, BTW. We went into test at PUT 9912, moved to PUT 9902 + Hipers a few weeks later, and are currently at PUT 9904 + a lot of Hipers, well past the May refresh level. Our worst problem seemed to be memory corruption with [...] 3701 61 22_Re: UNIX UDB Questions18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 29 Jun 2000 10:50:59 -0400324_- 1. That's all you have to do. Make sure your filesystem has enough space to hold all the logs that would be generated by UDB.

2. Use the redirect option in the restore command. This allows you to restore the container to another filesystem. I recommend you restore from an offline backup. Below is an example: [...] 3763 35 22_Re: UNIX UDB Questions18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 29 Jun 2000 10:53:36 -0400637_- Forgot to mention that this method works great to copy databases from one name to another. Eliminates having to use db2look and exports/imports.

-----Original Message----- From: Shauna Hadden [mailto:shauna.hadden@BCBSKS.COM] Sent: Thursday, June 29, 2000 10:11 AM To: DB2-L@RYCI.COM Subject: UNIX UDB Questions



I have two UNIX UDB v5.x questions.

1. We want to change from circular to archive logging on one of our databases. Besides stopping the database, changing LOGRETAIN to Yes/ON, verifying LOGPATH, LOGFILSIZ, LOGPRIMARY, and LOGSECOND, and taking a backup....is there anything we have to do? [...] 3799 43 6_D9300113_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Thu, 29 Jun 2000 15:57:00 +0100409_- Folks we are having problems with our DB2V4 test subsystem on OS390 2.8.

When try to run some DDL it brings the subsystem down and causes a catalog/directory corruption.

When this initially occured we got round it by manually deleting the DSNDBC/D dataset i.e. via 3.4, restoring the catalog/directory from the overnight backups. This was followed by a cold start and all was well again. [...] 3843 61 34_Re: Starting DB2 when TCP/IP down.0_27_jim.leask@RS-COMPONENTS.COM31_Thu, 29 Jun 2000 15:56:09 +0100408_iso-8859-1 Martin,

One option would be to amend your DSNZPARM so that DDF start-up was by COMMAND (install screen DSNTIPR) rather than AUTO and then issue the START DDF command when TCP/IP is okay.

Jim.



-----Original Message----- From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] Sent: 29 June 2000 15:32 To: DB2-L@RYCI.COM Subject: Starting DB2 when TCP/IP down. [...] 3905 44 34_FW: Starting DB2 when TCP/IP down.13_Gleason, Mike22_MGleason@UILLINOIS.EDU31_Thu, 29 Jun 2000 09:59:48 -0500384_iso-8859-1 You could have an alternate ZPARM module specifying that DDF be started by command, not auto. Restart DB2 using the alternate zparm and wait to start DDF until TCP/IP is fixed.

-----Original Message----- From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] Sent: Thursday, June 29, 2000 9:32 AM To: DB2-L@RYCI.COM Subject: Starting DB2 when TCP/IP down. [...] 3950 66 73_Re: What replaced the "using" clause of the LOAD utility in DB2 /UDB V 6?13_Sundari Yegna24_Sundari_Yegna@WSIB.ON.CA31_Thu, 29 Jun 2000 11:04:45 -0400649_us-ascii Hi..I saw this in the DB2 UDB V7.1 Manual, Data Movement Utilities Guide and Reference, in the section, Changes to Previous Load Behavior Introduced in Version 6 and Version 7

The sorting of index keys during index creation takes advantage of a new sorting algorithm used by the DB2 UDB Version 6 database engine. The amount of memory dedicated to sorting is controlled by the values of the sort heap (sortheap) database configuration parameter, and the sort heap threshold (sheapthres) database manager configuration parameter. This means that the old LOAD options for SORT BUFFER, and the temporary sort directories specified [...] 4017 86 22_Re: UNIX UDB Questions13_Sundari Yegna24_Sundari_Yegna@WSIB.ON.CA31_Thu, 29 Jun 2000 11:06:38 -0400351_us-ascii For Question 1: When you turn logretain ON to enable rollforward recovery, you can turn on USEREXIT to archive the logs to Tape or ADSM or to another disk. This way you don't need to worry about the active log path filling up.









"Krawetzky, Peter J" on 06/29/2000 10:50:59 AM [...] 4104 26 32_DB2/OS390 to DB2 UDB replication5_Buz W14_buzw@YAHOO.COM31_Thu, 29 Jun 2000 08:20:25 -0700339_us-ascii Hello,

Can anyone point me to the documentation I need to read in order to setup replication from a mainframe database to a UDB server?

I'm a mainframe bigot and don't fully understand the UDB side. My client wants to copy data from the mainframe to the UDB server daily.

Thanks in advance for any help. [...] 4131 618 23_Re: V6.1 -415 on Bind ?15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 29 Jun 2000 11:26:36 -0400503_iso-8859-1 Sorry Neil - I mispelled your name.

I have further researched the PTF UQ37542 and it is the DB2 V6.1 CSI in receive status - so backing it off is not an option for me to get beyond the -415 BIND failures. I have updated my ETR record with IBM and have reviewed PQ38452 and have seen an open date of 6/26/200 with a target delivery of 8/2/2000 so I will have to plan our V6.1 testing and implementation at a later time in the year as we cannot get through the BINDS to do testing. [...] 4750 50 72_Re: What replaced the "using" clause of the LOAD utility in DB2/UDB V 6?16_Michael McCarthy18_mmccarthy@DTCC.COM31_Thu, 29 Jun 2000 11:30:25 -0400473_us-ascii Paul,

The syntax on the LOAD utility is a little different. The option you are looking for is TEMPFILES PATH .

-Mike.









"Martin, Paul" on 06/29/2000 10:48:08 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Michael McCarthy/DTC) Subject: [DB2-L] What replaced the "using" clause of the LOAD utility in DB2/UDB V 6? [...] 4801 55 36_Re: DB2/OS390 to DB2 UDB replication10_Mike Paris14_MPARIS@TUC.COM31_Thu, 29 Jun 2000 10:32:01 -0500405_US-ASCII The DB2 Replication Certification Guide and the V6 Replication Manual are good places to start. If you have particular questions feel free to contact me offline.

HTH, Michael Paris

Senior Database Analyst IBM Certified Solutions Expert DB2 UDB Database Administration IBM Certified Advanced Technical Expert Data Replication

Trans Union 555 West Adams Chicago, IL 60616 [...] 4857 110 69_Re: Tools for comparing table contents before and after test scri pts14_Snyder, Kei E.23_kesnyder@SOUTHERNCO.COM31_Thu, 29 Jun 2000 10:25:48 -0500575_- Actually, you can use RC/UPDATE, choose the DATA COMPARE (DC) option (leave "object" and "item name" blank), then create a strategy to do the compare of data between two tables. It generates unloads for the two tables, then compares the data and produces a report of the differences. But you'll have to define a new table, if you don't already have one, that looks exactly like your test table. Unload your "source" table before your test, and load that data into the new "target" table. Run your test on the "source" table, then run the data compare strategy. If you [...] 4968 106 69_Re: Tools for comparing table contents before and after test scri pts13_Thomas, Janis19_Janis.Thomas@CA.COM31_Thu, 29 Jun 2000 11:39:06 -0400495_iso-8859-1 Sanjay -

I did sent a follow up posting, explaining that I jumped the gun responding to this & I meant RC/Update, not RC/Compare.

Janis Thomas DB2 Product Management Computer Associates International, Inc. janis.thomas@ca.com 630-481-1830





-----Original Message----- From: Jain, Sanjay (Exchange) [mailto:sanjayjain@BEAR.COM] Sent: Thursday, June 29, 2000 9:46 AM Subject: Re: Tools for comparing table contents before and after test scri pts [...] 5075 30 30_DB2 SUBSYSTEM ABENDED - URGENT41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Thu, 29 Jun 2000 12:42:29 -0300609_iso-8859-1 We got a DSNV086E abend in our production subsystem. The reason code is 00E80100 (The DB2 subsystem was abended because the DB2 address space control task ESTAE was entered). Initially, a DDF thread was cancelled with CANCEL THREAD, but it remained on line. After that, our system programmer cancelled our DIST address space and we got the message above. Our subsystem is unaccessible, however, the DIST address space continues consuming CPU. It seems that it is in process of finish some activity (maybe related to that thread). A -STOP DB2 was issued but no answer was given. What should we [...] 5106 228 32_Re: converting a UNION ALL query23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 29 Jun 2000 11:59:34 -0400415_iso-8859-1 Sanjeev and Suresh,

Another 'select with value function' on top of the full outer join does the trick, well almost. In our case, for a.col1=c.col1, a.col2 and c.col2 may not match, hence the user wants to get both rows. your query would eliminate one of the row. I guess, I could append something to make a.col1 and c.col1 always different and strip later on, but this would be one ugly SQL. [...] 5335 50 10_Rexx - DB211_Adam Foster22_Adam.Foster@BULL.CO.UK31_Thu, 29 Jun 2000 16:59:26 +0100415_us-ascii Dear List....

I am looking for a bit of REXX which will allow me to run a select against a DB2 database on OS/390.

I've seen a couple in some of the Xephon DB2 update magazines, but they always contain pages of REXX which I'm simply not interested in. Quite simply all I need is a bit of REXX to run a select for and for the output to go into a dataset which I can then play about with. [...] 5386 111 73_Re: What replaced the "using" clause of the LOAD utility in DB2 /UDB V 6?13_Sundari Yegna24_Sundari_Yegna@WSIB.ON.CA31_Thu, 29 Jun 2000 12:10:37 -0400673_us-ascii The USING option in LOAD is obsolete starting V6.1. The following paragraphs are from the DB2 Datamovement Utiities Guide and Reference.

Sort spills that occur during load index creation are now performed inside a temporary table space. Sort operations do not spill directly to disk; rather, they spill to the bufferpool associated with the temporary table space. Having a large bufferpool associated with the temporary table space can improve index creation time. To achieve the same type of I/O parallelism that was available in pre-Version 6 load sort operations (by specifying multiple temporary sort directories), it is recommended that temporary [...] 5498 172 26_Re: Migrating DB2 V5 to V620_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 29 Jun 2000 11:45:15 -0400476_iso-8859-1 Dear list

>>> IBM has a DBRM checker available to download, >>> at http://www-.ibm.com/software/data/db2/os390/downloads.html but we have not tried it.

Is it free of charge to use for any one?

Thanks Venkat

-----Original Message----- From: Kirk Hampton [SMTP:khampto1@TXU.COM] Sent: Thursday, June 29, 2000 10:48 AM To: DB2-L@RYCI.COM Subject: Re: Migrating DB2 V5 to V6 [...] 5671 457 52_Repost: PeopleSoft and IBM Expand Global Partnership13_Morrill, John12_JohnM@VP.NET31_Thu, 29 Jun 2000 10:18:51 -0600752_iso-8859-1 Greetings!

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

Cheers!

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



Dear DB2 Interested Parties,

This week PeopleSoft announced that DB2 would become its strategic database platform for UNIX, as well as PeopleSoft's primary development platform for that environment. In addition, platform support for PeopleSoft with DB2 has been expanded immediately to include the Solaris and NT environments, followed by HP-UX and Linux, in addition [...] 6129 74 14_Re: Rexx - DB215_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 29 Jun 2000 12:23:40 -0400368_us-ascii Why not use DSNTIAUL with SQL parm to unload data to file and then process it. That way you do not have to use REXX. HTH





Bob Lawrence DBA Boscov's Dept Stores Inc



-----Original Message----- From: Adam Foster [SMTP:Adam.Foster@BULL.CO.UK] Sent: Thursday, June 29, 2000 11:59 AM To: DB2-L@RYCI.COM Subject: Rexx - DB2 [...] 6204 70 14_Re: Rexx - DB212_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 29 Jun 2000 19:26:41 +0200548_x-user-defined Hi, I've put an example of doing it without any tools/software/etc... about 2 weeks ago. Look at the archives. You only need DSNTIAUL and regular REXX.

Isaac Yassin





Adam Foster wrote: > > Dear List.... > > I am looking for a bit of REXX which will allow me to run a select against > a DB2 database on OS/390. > > I've seen a couple in some of the Xephon DB2 update magazines, but they > always contain pages of REXX which I'm simply not interested in. Quite > simply all I need is a bit of REXX to [...] 6275 58 34_Re: DB2 SUBSYSTEM ABENDED - URGENT12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 29 Jun 2000 19:30:08 +0200339_x-user-defined Hi,

Since you already did -stop db2 then if it still don't go down, do "f ,abend,nodump" to kill the irlm and bring DB2 down. If it won't work you'll have to cancel or even force the DB2 address spaces. (And this may lead to IPL....) Then start again (restart may take some time, depends on activity). [...] 6334 375 56_Repost: IBM DB2 Administration Tool for OS/390 Version 213_Morrill, John12_JohnM@VP.NET31_Thu, 29 Jun 2000 10:28:01 -0600735_iso-8859-1 Greetings!

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

Cheers!

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



Dear DB2 Interested Parties,

Below is an excerpt from this week's announcement of a new version of the IBM DB2 Administration Tool (DB2 Admin). DB2 Admin offers DB2 catalog query and object management capabilities to supplement DB2 for OS/390 administration tasks. The DB2 Admin Web site is at http://www-4.ibm.com/software/data/dbtools/db2adm.html . [...] 6710 151 96_Repost: Would like to receive a note when the DB2 for OS/390 V7 b ooks are available on the Web?13_Morrill, John12_JohnM@VP.NET31_Thu, 29 Jun 2000 10:28:35 -0600540_iso-8859-1 Greetings!

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

Cheers!

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



Dear DB2 Interested Parties,

If you would like to receive a note when the DB2 for OS/390 V7 books are available on the Web, follow one of these procedures: [...] 6862 111 69_Re: Tools for comparing table contents before and after test scri pts14_Snyder, Kei E.23_kesnyder@SOUTHERNCO.COM31_Thu, 29 Jun 2000 11:31:46 -0500543_- > You can use RC/UPDATE, choose the DATA COMPARE (DC) option (leave "object" > and "item name" blank), then create a strategy to do the compare of data > between two tables. It generates unloads for the two tables, then > compares the data and produces a report of the differences. But you'll > have to define a new table, if you don't already have one, that looks > exactly like your test table. Unload your "source" table before your > test, and load that data into the new "target" table. Run your test on > the "source" table, then [...] 6974 62 34_Re: DB2 SUBSYSTEM ABENDED - URGENT13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 29 Jun 2000 11:29:50 -0500395_iso-8859-1 Hi,

To get the system back, I would abend the IRLM (Modify irlmproc,ABEND) and try a restart, seems as if you cannot get anything from DB2 via commands.

Glenn

-----Original Message----- From: Cláudio Meluzzi Mendes [mailto:P000002@BEG.COM.BR] Sent: Thursday, June 29, 2000 10:42 AM To: DB2-L@RYCI.COM Subject: DB2 SUBSYSTEM ABENDED - URGENT Importance: High [...] 7037 44 36_Re: DB2/OS390 to DB2 UDB replication10_Park, Stan17_SPark@STATE.NM.US31_Thu, 29 Jun 2000 11:17:44 -0600490_iso-8859-1 The UDB/Connect WEB page has a great search facility!

http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/index.d2 w/report

-----Original Message----- From: Buz W [mailto:buzw@YAHOO.COM] Sent: Thursday, June 29, 2000 9:20 AM To: DB2-L@RYCI.COM Subject: DB2/OS390 to DB2 UDB replication



Hello,

Can anyone point me to the documentation I need to read in order to setup replication from a mainframe database to a UDB server? [...] 7082 43 34_Re: Starting DB2 when TCP/IP down.14_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 29 Jun 2000 13:42:12 -0400546_- When you say local, do you mean non-DDF ? If so, why can't you just start DDF after the IP issue is straightened out ?

> -----Original Message----- > From: MARTIN WOLFF [SMTP:martin_wolff@GLOBALCROSSING.COM] > Sent: Thursday, June 29, 2000 10:32 AM > To: DB2-L@RYCI.COM > Subject: Starting DB2 when TCP/IP down. > > Hi all, > > We have had a couple of occasions after an IPL that TCP/IP has a corrupt > SYSHFS > file > and as a result DB2 fails to fully initialize. > It stops after the 'DSNL003I + DDF IS STARTING' message. > > As [...] 7126 97 34_Re: DB2 SUBSYSTEM ABENDED - URGENT45_=?x-user-defined?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Thu, 29 Jun 2000 14:59:01 -0300354_x-user-defined Hello,

uuufff, after terrible moments of pressure everything goes smoothly...

IRLM was already off but, I do not know how, DIST and MSTR were still running, showing CPU usage but no I/O access. An MVS FORCE has cancelled DB2 address spaces. After that, DB2 starded normally, resolving some indoubt and inflight threads. [...] 7224 166 34_Re: DB2 SUBSYSTEM ABENDED - URGENT0_17_sjvagnier@AEP.COM31_Thu, 29 Jun 2000 14:26:25 -0400330_iso-8859-1 Claudio,

Sometimes, issuing a MVS FORCE of an address space may not always free up the storage that was in use. You may need to do an IPL to regain the storage back. For that reason, an MVS FORCE of a DB2 address space should be a last resort .



Regards, Steve Vagnier American Electric Power [...] 7391 79 28_Re: SQLJ compilation error..23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 29 Jun 2000 14:41:22 -0400610_- Ajay,

I think you are coding the wrong jdbc driver. I code "COM.ibm.db2.jdbc.app.DB2Driver" in SQLJ programs and it works fine. Also the URL should be set to "jdbc:db2:".

HTH

Sanjay

> -----Original Message----- > From: ajay kumar [SMTP:db2v5r1@HOTMAIL.COM] > Sent: Tuesday, June 27, 2000 12:40 PM > To: DB2-L@RYCI.COM > Subject: SQLJ compilation error.. > > Hi > > We are using DB2 V6R1 on OS 390 V2R8. We enabled the JDBC connectivity to > acces db2 data on OMVS. CLI interface also goes thru well. > > On SQLJ, [...] 7471 64 34_Re: DB2 SUBSYSTEM ABENDED - URGENT11_Pedro Cunha24_pedro.cunha@CAIXA.GOV.BR31_Thu, 29 Jun 2000 14:10:40 -0300113_iso-8859-1 Hello Claudio,

What is the status of your IRLM and other DB2 Adress spaces?

Salutations, 7536 91 53_Re: SQL to determine unneeded referential constraints11_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 29 Jun 2000 15:41:41 CDT296_- Jim: Here is a start. The SQL below will work for hierarchies 3 levels deep (t1-->t2-->t3). This can be extended for 4 or more quite easily. There might be a more elegant way but here is one that works. If you have any recursive rels, they must be excluded, otherwise the result is wrong. [...] 7628 212 34_Re: DB2 SUBSYSTEM ABENDED - URGENT12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 29 Jun 2000 15:55:13 -0500414_us-ascii



Of course, if you already have a wise-guy for a systems programmer that went and CANCELed your DIST address space just to kill a user thread, he deserves all the credit for the IPL to clean up after he issues the FORCE to get your DB2 back.

Claudio, glad everything came out all right. DB2 is incredibly resilient and generally recovers well from even human-inflicted crashes. [...] 7841 126 109_Repost: DB2 Certification News: V7 Updates Coming That Will Inclu de *New* Family Exams and *New* OS/390 Exam13_Morrill, John12_JohnM@VP.NET31_Thu, 29 Jun 2000 15:18:10 -0600436_iso-8859-1 Dear DB2 Interested Parties,

Here is some (great) new news about DB2 Certification:

o With the product announcement of DB2 UDB for UNIX, Windows, OS/2 Version 7, IBM is updating the certification exams to cover:

- DB2 UDB V7 Family Fundamentals Exam- Test 512 - DB2 UDB V7 Database Administration on Unix, Windows and OS/2 Exam - Test 513 - DB2 UDB V7 Application Development Family Exam - Test 514 [...] 7968 118 113_Re: Repost: DB2 Certification News: V7 Updates Coming That Will Inclu de *New* Family Exams and *New* OS/390 Exam16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Thu, 29 Jun 2000 19:07:37 -0400470_us-ascii



Thanks, we have been looking forward to this (OS390 DBA Certification) for ages. Fantastic Tom F







"Morrill, John" on 06/29/2000 05:18:10 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Repost: DB2 Certification News: V7 Updates Coming That Will Inclu de *New* Family Exams and *New* OS/390 Exam [...] 8087 25 39_Lotus LS:DO access DB2/OS390 by DB2 CLI6_TaoTao19_taotao@ONLINE.SH.CN31_Fri, 30 Jun 2000 10:47:53 +0800405_us-ascii Dear all,

Is there anyone who has implement Lotus LS:DO(or LSX) access DB2/OS390 by DB2 CLI? I have binded DB2 CLI package and plan successfully. But when I run Lotus Script on the Domino server for OS390 to access DB2 in the OE environment, the Domino Server responses 'can not connect to data source : xxx'. The xxx is what I write in the script 'ODBCconnectto(ds,uid,pwd),ds=xxx'. [...] 8113 19 38_withdrawal of support of MVS DB2 V4.1?31_Eric Ng Yew Heng/ITNOC/PBB/PBBG22_ngyh@PUBLICBANK.COM.MY31_Fri, 30 Jun 2000 10:58:39 +0800420_iso-8859-1 I read from IBM homepage that IBM is will withdraw from marketing DB2 for MVS/ESA V4 effective Dec 1,2000. Does it mean IBM will not support it too after Dec 1,2000?

DBA ===============================================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. 8133 34 42_Re: withdrawal of support of MVS DB2 V4.1?0_17_JTonchick@AOL.COM29_Thu, 29 Jun 2000 23:17:21 EDT416_US-ASCII In a message dated 06/29/2000 10:02:23 PM Central Daylight Time, ngyh@PUBLICBANK.COM.MY writes:

<< I read from IBM homepage that IBM is will withdraw from marketing DB2 = for MVS/ESA V4 effective Dec 1,2000. Does it mean IBM will not support it too after Dec 1,2000?

DBA= >>

Support for a product extends at least 12 months beyond the date the product is withdrawn from marketing. [...] 8168 257 32_Re: converting a UNION ALL query7_Sanjeev19_Sanjeev@INTERRA.COM31_Fri, 30 Jun 2000 09:47:58 +0530540_iso-8859-1 Hi Sanjay, I believe FULL OUTER JOIN of table3(c) with intermediate view having a.col1 and a.col2 as the columns will return both the matching and non-matching rows. I am sorry if i am not able to understand your concern with this sentence : "In our case, for a.col1=c.col1, a.col2 and c.col2 may not match, hence the user wants to get both rows. your query would eliminate one of the row." I am not sure tables are in some different kind of relationship than the orthodox one with col1 and col2 involved in all the tables. [...] 8426 95 14_Re: Rexx - DB27_Sanjeev19_Sanjeev@INTERRA.COM31_Fri, 30 Jun 2000 09:57:06 +0530337_x-user-defined Hi Adam, Search the archive for DB2WWWX suggested by Max Scarpa , twice in the list.It needs OMVS to be able to install this one.I had done in my previous installation as suggested by Max.It is very easy to install and use. I hope it will help you to do what you want. You can also search the IBM site using DB2WWWX. [...] 8522 83 37_Links about DB2 for OS/390 (06/30/00)6_DB2usa18_db2usa@HOTMAIL.COM31_Thu, 29 Jun 2000 23:46:55 -0500525_ISO-8859-1 Hi,

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

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

Last update on Friday, June 30th 2000 =====================================

- Links about DB2 for OS/390: http://www.multimania.com/db2usa/eliste.htm IBM announced software withdrawal: DB2 Version 4, DB2 Admininistration Tool Version 2 (that replaces Version 1.2) and DB2 OS/390 certification. [...] 8606 110 30_Re: AW: Migrating DB2 V5 to V623_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 30 Jun 2000 06:44:45 +0100518_iso-8859-1 ...I agree with Steve, however thinking about it I cannot see any reason why it should make a difference what member gets migrated first. Lets be honest V5 to V6 is with reason just a CATMAINT and a define of the new VSAM datasets for the catalog(new indexes and new tables) and then point the member at the new libs .. I appreciate it is a bit more involved than that(zparm and other things do change), but the basics of the migration are there....oh and all the pre and post checking that goes on .. [...] 8717 36 43_Linux symbol (the famous penguin) wanted...12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 30 Jun 2000 08:41:39 +0200656_iso-8859-1 Hello list.

I have to prepare a presentation. And therefore I am searching a *.bmp.file or a *.jpeg.file with the Linux symbol, the famous penguin.

Is there anybody out there who can send me such a file ?

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 ---------------------------------------------------------------------------- - [...] 8754 105 47_Re: Linux symbol (the famous penguin) wanted...0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 30 Jun 2000 14:53:26 +0800792_us-ascii try this:

http://www.linux.org/info/logos.html

Cheers,

Greg Palgrave Database Administration IT Services Bank of Western Australia eMail : greg.palgrave@bankwest.com.au



---------------------------------------- Message History ----------------------------------------



From: "Peter, Georg" on 30/06/2000 14:41





Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Greg Palgrave/PRS/SS/BankWest)

Subject: Linux symbol (the famous penguin) wanted...







Hello list.

I have to prepare a presentation. And therefore I am searching a *.bmp.file or a *.jpeg.file with the Linux symbol, the famous penguin. [...] 8860 26 34_Re: DB2 SUBSYSTEM ABENDED - URGENT14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Fri, 30 Jun 2000 09:10:29 +0100459_us-ascii Claudio, welcome in the club.

I had the same in the previous shop where I worked. Every time it was a great pain. In MVS log you (probably) can see that DB2 was stopped correctly, but in SDSF you can see MSTR, DIST, DBM1 still running (high CPU use but no I/O) . So you have to use CANCEL command (with FORCE sometimes). May be that at restart you can find some 'ghosts' address spaces. By the way do you use Boole and Babbage MainView ? [...] 8887 52 39_Re: Altering a Table to add new columns12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 29 Jun 2000 15:54:00 +0100274_- I'm not sure about (1) without trying, but if you are doing a load replace, you may as well drop/recreate the table. For (2) the answer is a definite yes, as long as DB2 knows there is a copy with the old length which you may want to recover from, it stays variable. [...] 8940 34 17_Re: DSNJ004I & co17_Giorgio De Nunzio25_giorgio.denunzio@UNILE.IT31_Fri, 30 Jun 2000 09:52:50 +0200426_us-ascii Hi james, thanks for your kind reply!

>It is possible that the 5 largest contiguous free spaces on P390DX (the >volume to which archive logs are allocated?) are not enough to allocate the >archive log primary space. Try a defrag to accumulate all the free space >into one area.

Ooops! Never defragmented a dasd in my life (shame on me..) Is there any ISPF option to do the trick? I'll look for it. [...] 8975 140 69_Fw: Tools for comparing table contents before and after test scri pts12_Robert Brock28_brock@KRYPTON-CONSULTING.COM31_Fri, 30 Jun 2000 02:56:47 -0500327_iso-8859-1 Kei is right but you don't have to create a second copy of the table to do the comparison. There is an option with the data compare to compare the contents of a table across two points in time. You do the first unload of the table, run the updates, then do the second unload and the compare to get your report. [...] 9116 137 28_Re: COBOL-DB2 Commit Problem17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Fri, 30 Jun 2000 10:56:30 +0200465_us-ascii Hi Pearl, I agree with James: I suppose you use LE, so you have to specify ABTERMENC(ABEND) in the startup parms of your program. We start such a program as follow:

DSN SYSTEM(DSNP) RUN PROGRAM(GN116I78) - PLAN(ISC1) - PARM('0000D/RPTOPTS(ON),ABTERMENC(ABEND)') - LIB('AP.TESTLIB') END

Where the part *before* the slash is for the application program, the remainder is for LE. RPTOPTS(ON) display your current setting for the execution. [...] 9254 81 20_Re: FW: SQLCODE -31015_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE31_Fri, 30 Jun 2000 04:44:25 -0500355_- Sorry to interfere ...

But are you sure you mean DECIMAL data ?

I mean... this is OS/390, and we are talking about EBCDIC *PACKED* Decimal.

I'm just asking, because this is not a datatype you really have in C/C++.

If you supply a char[n] with a *string reprensatation* of a "valid number" , that is NOT a "decimal type" [...] 9336 206 26_Re: Migrating DB2 V5 to V611_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 30 Jun 2000 04:34:07 PDT718_- Venkat, Yes, it is free of charge, but not supported. I down-loaded it last week and ran it with no problems. hth, Rick Creech



>From: "Pillay, Venkat (PCA)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Migrating DB2 V5 to V6 >Date: Thu, 29 Jun 2000 11:45:15 -0400 > >Dear list > > >>> IBM has a DBRM checker available to download, > >>> at http://www-.ibm.com/software/data/db2/os390/downloads.html > but we have >not tried it. > >Is it free of charge to use for any one? > >Thanks >Venkat > > -----Original Message----- > From: Kirk Hampton [SMTP:khampto1@TXU.COM] [...] 9543 178 14_Re: Rexx - DB211_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 30 Jun 2000 04:44:55 PDT549_- Here is a sample REXX that I wrote recently to demonstrate how to do cursor processing from DSNREXX on os/390. It does not have the logic to subsequently write to a sequential file but you can get that from the most basic rexx manual.

/* THIS IS A DB2 REXX FOR FETCHING ROWS FROM A CURSOR*/ PARSE ARG SSID "SUBCOM DSNREXX" IF RC THEN S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX') /* */ /* CONNECT TO THE DB2 SUB-SYSTEM */ /* */ ADDRESS DSNREXX "CONNECT" SSID IF SQLCODE ¬= 0 THEN SAY 'ADDRESS FAILED' OUTMAN = 'Z' OUTSEX = 1 /* */ /* SET [...] 9722 22 36_Re: DB2/OS390 to DB2 UDB replication14_Philip Gunning18_pgunning@PHEAA.ORG31_Fri, 30 Jun 2000 08:40:03 -0400448_us-ascii Buz, The DB2 Replication Certification Guide will provide detailed instructions on how to do this. Also, DB2 UDB Database Admin Guide, Design and Implementation, SC09-2839-00. This is available from IBM and most book stores. 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 [...] 9745 303 26_AW: Migrating DB2 V5 to V612_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 30 Jun 2000 15:23:13 +0200741_iso-8859-1 Rick,

I have downloaded the colon finder too. I agree with you - this piece works.



And... what a wonder ;-) this tool has really found several very old DBRM's (must be built in 1990 or 1991) with host variables without the required colon...

A nice weekend to everybody out there....

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 ------------------------------------------------------------------------ [...] 10049 36 52_Custom-Built Offering for the Installation of DB2 V621_Li, Chak Lung Dominic19_seddba@HK.SUPER.NET31_Fri, 30 Jun 2000 21:25:52 +0800439_us-ascii Dear all,

We are consider to install DB2 V6 in the near future. According to IBM, there are several ways for the installation. CBIPO and SeverPac approach are being offered.

Since we have no experiece to use these installation packages, would you please let me know the following for our evaluation:

1. Are both CBIPO and SeverPac suitable for the installation or they are suitable for maintenance only? [...] 10086 17 23_DB2 for LINUX on OS/39010_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 30 Jun 2000 09:44:41 -0400384_us-ascii Hi all

I'm interested in learning all about running DB2 for LINUX on the OS/390 platform. Are there any good books?

Tom

================================================ 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. 10104 94 20_Re: FW: SQLCODE -31015_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Fri, 30 Jun 2000 10:13:20 -0400558_us-ascii M

c does give you decimal as basic type i'm writing c++ and i user the IBinaryCodedDecimal class for decimal functions. the cData member function returns a pointer to the packed data.

ben

Matthias Pohlig wrote:

> Sorry to interfere ... > > But are you sure you mean DECIMAL data ? > > I mean... this is OS/390, and we are talking about > EBCDIC *PACKED* Decimal. > > I'm just asking, because this is not a datatype > you really have in C/C++. > > If you supply a char[n] with a *string reprensatation* of > a "valid [...] 10199 325 32_Re: converting a UNION ALL query23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 30 Jun 2000 11:27:24 -0400627_iso-8859-1 Sanjeev,

Here is a scenario

Table1.col1 = 'JAD' Table1.col2 = 'TAFT Security'

Table2.col1 = 'JAD' Table2.col2 = 'Citadel Trading'

With UNION ALL I get both the rows (which the user wants). With Full outer join on table1.col1 = table2.col1, followed by VALUE function, I get only one set of value depending upon the order of columns in VALUE( ) function. To work around this, I am appending a fixed char string to table1.col1 say 'XXX' and another one to table2.col1 say 'YYY'. With this Table1.col1 will never match Table2.col1. Hence the full outer join will give me 2 rows instead [...] 10525 25 30_Communication SQL NT<->DB2 AIX14_Karen Grantham25_kgrantham@CUSTOM-EDGE.COM31_Fri, 30 Jun 2000 10:46:54 -0500549_us-ascii Does anyone know a poor man's (no tool) method of communicating between NT and AIX? We have a propagator process that runs against DB2 UDB creating an exclusive lock on a table. This process runs continuously. We have another process on NT that accesses the DB2 table in locked state and times out. There is a simple command to execute on AIX to stop and start the propagator table hog (apply), but the trick is how to control it from NT or SQL SERVER. We'd thought about updating a 'toggle' table on DB2 from NT, but that seems a bit [...] 10551 17 31_Runstats in a new DB2 subsystem15_Mark Hardenburg30_mark.hardenburg@PRUDENTIAL.COM31_Fri, 30 Jun 2000 11:54:47 -0400466_us-ascii Someone here has suggested that running runstats on a new DB2 subsystem is not necessary because DB2 itself uses links and hashes to access catalog information. I am concerned that any plans which select from the catalog (CA-PLATINUM tools for example) would find -1 and use the default statistics which may be less efficient. I am curious to hear the opinion of "The List" and would like to know if anyone else has taken this (non-runstats) approach. [...] 10569 13 35_Re: Runstats in a new DB2 subsystem12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Fri, 30 Jun 2000 11:26:58 -0500388_us-ascii When we install a new system or upgrade to a new version we run runstats. Then maybe on a yearly basis. But we are still discussing that.

================================================ 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. 10583 54 35_Re: Runstats in a new DB2 subsystem19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 30 Jun 2000 11:35:47 -0500649_iso-8859-1 Hi Mark, Not all directory and catalog tables use links/hashing, see DB2 Diagnosis Guide and Reference. Also, you may add indexes to these tables. See Platinum recommendations for indexes. Consider setting up RUNSTATS on a daily, weekly, monthly, or not necessary basis for all tablespaces, including the cat/dir based on activity on those tables. For example, use daily RUNSTATS on tables with high delete/insert activity where dynamic or static sql with REOPT(VARS) occurs. See archives for recommendations on how to perform the RUNSTATS. HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are [...] 10638 20 15_Fw: unsubscribe12_INFO_SYSTEMS26_INFO_SYSTEMS@EMAIL.MSN.COM31_Fri, 30 Jun 2000 09:46:59 -0700457_- ----- Original Message ----- From: "Fritz Rapp" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, June 22, 2000 3:22 AM Subject: unsubscribe



> unsubscribe >

================================================ 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. 10659 38 11_unsubscribe12_INFO_SYSTEMS26_INFO_SYSTEMS@EMAIL.MSN.COM31_Fri, 30 Jun 2000 09:52:41 -070020_iso-8859-1 signoff * 10698 56 20_PROBUILD replacement0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Fri, 30 Jun 2000 12:11:14 -0500385_us-ascii Question 1): Are there any shops using Probuild and if so, what are you planning to do when you migrate to V6?

Background: PROBUILD is a CA product that will not be supported beyond DB2 V5. We use PROBUILD within TSO Clists and TSO REXX execs to access DB2 OS/390 data. CA's replacement product for PROBUILD is RC/Query, but it does not provide this funtionality. [...] 10755 23 47_DB2I defaults disappearing when migrating to V60_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Fri, 30 Jun 2000 12:15:27 -0500353_us-ascii Has anyone else experienced their defaults set in V5 disappearing when migrating to V6? The V6 release guide indicates that DB2I panel variables in the ISPF profile from previous release can be migrated to the new release but our experience is that we are losing them. Anyone else having the same experience and if so how did you rectify? [...] 10779 43 51_Re: DB2I defaults disappearing when migrating to V613_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 30 Jun 2000 12:37:31 -0500663_US-ASCII Hello Shan, I believe the default input member name is DSNTIDXA for the install CLIST. (in SAMPLIB) If you saved your prior install values to a different member then point the CLIST to that member. I think is on panel 2. HTH Kurt







>>> Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM 06/30/00 12:15PM >>> Has anyone else experienced their defaults set in V5 disappearing when migrating to V6? The V6 release guide indicates that DB2I panel variables in the ISPF profile from previous release can be migrated to the new release but our experience is that we are losing them. Anyone else having the same experience [...] 10823 31 29_DB2 connect & security issues14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Fri, 30 Jun 2000 11:35:21 -0700341_us-ascii Scenario: End users have CAE on their PCs. DB2 Connect (v6) is on a mid-tier Unix box. S/390 (v2.6) hosts DB2 (v5, PUT9909). TCP/IP is used all the way through. ALREADYV=YES, EXTSEC=YES Mid-tier has a userid and password to access S/390 DB2. This userid supports all users who have varying RACF authorizations to tables/views. [...] 10855 102 24_Re: PROBUILD replacement12_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 30 Jun 2000 13:19:41 -0700382_us-ascii We don't use Probuild, but I have used RC-Query in the past. QMF from IBM is more functionally equivalent to RC Query, and runs under TSO, but I don't know if it will do what you want.

Have you tried using the CAF? You should be able to call it from a clist (DSN(subsysid)) and then use DSNTEP2 (created during installation IVP process) to pass the SQL to DB2. [...] 10958 61 33_Re: DB2 connect & security issues10_Leo Pedron19_lpedron@BOSCOVS.COM31_Fri, 30 Jun 2000 16:38:23 -0400435_iso-8859-1 I believe that you can use DCS_ENCRYPT as the authentication setting at the client and on the DB2 Connect server to send the password over the network, and have it be encrypted, all the way from the client to the host. This would also allow your users to only access the data that their RACF id would normally allow them access to, because they would still be providing their RACF userid and password. Hope that helps. [...] 11020 83 51_Re: DB2I defaults disappearing when migrating to V612_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 30 Jun 2000 13:42:21 -0700571_us-ascii Ah, conversion time, when people's defaults change and they don't know what they had them set to in the last version... If you browse your personal TSO profile dataset (usually TSOID.ISPPROF or something similar) you will see a whole bunch of members. The ones that start with DSN are where DB2 stores all the info you need to run SPUFI, (ie where to connect, CS or RR, dataset names, etc). The ones that start with DSN4 are from version 4.1, DSN5 are from 5.1, etc. You can't always just rename your DSN4 members to DSN5 members because there isn't always [...] 11104 106 51_Re: DB2I defaults disappearing when migrating to V612_Bing Alabata25_bing.alabata@MCMASTER.COM31_Fri, 30 Jun 2000 16:01:49 -0500424_iso-8859-1 We keep track of our DSNTIDxx member in DSN510.SDSNSAMP each time we make changes to parms, libraries, etc. At conversion time, we review the most current DSNTIDxx member against a cross reference of MACRO parameters, DSNTIDxx fields, and installation panels. We then feed the member to the Installation/Migration Clist and breeze through the generation of JCL members with the old and new DB2 parms intact. [...] 11211 24 65_Tools for comparing table contents before and after test scri pts12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Fri, 30 Jun 2000 17:01:55 -0400327_ISO-8859-1 Hi janice,

I have tried the compare feature of RC Update and found it not very useful since it simply unloads the data and uses the ISPF compare function which is far from what I would like to see for a user friendly data compare feature. I think CA needs to really provide a good data compare facility. [...] 11236 19 51_Re: DB2I defaults disappearing when migrating to V626_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Fri, 30 Jun 2000 16:10:53 -0500376_- Think what we do is let the DB/2 installer tailor stuff with new version and get the DSN5 profile in the ISPPROF DSN, then copy the DSN5 profile member into the system wide ISPTLIB DSN so as users pop into v5 they'll get the v5 tailored defaults. Haven't got V6 yet, shouldn't it work for it too? Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...] 11256 159 51_Re: DB2I defaults disappearing when migrating to V612_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 30 Jun 2000 14:43:47 -0700557_us-ascii Are we talking about the same thing? I'm talking about the ISPF panels which allow people to do SPUFI, DCLGEN's, BINDs, etc. Not the DB2INST clist which generates the install jobs and Zparms. I've seen some of the DB2I parameters in DSNTIDXA, but others (like SPUFI isolation level of RR which I always change to CS manually) seem to automagically get generated out of thin air. I'd always assumed they were hard coded inside the DB2 code somewhere. If you're saying that I can find this in DSNTIDXA I'd like to know what keyword to look for. [...] 11416 198 51_Re: DB2I defaults disappearing when migrating to V612_Bing Alabata25_bing.alabata@MCMASTER.COM31_Fri, 30 Jun 2000 17:30:12 -0500586_iso-8859-1 Sorry for being dense. It's late Friday afternoon. If you want to change your SPUFI defaults on initial entry, you can change panel variables in the DSNESP02 of the DB2 panel library. Last I check in DSN410.SDSNSPFP(DSNESP02) the panel variables were:

IF (&DSNESV2F = &Z) &DSNESV2F = RR /* ISOLATION LEVEL DEFAULT */ IF (&DSNESV2D = &Z) &DSNESV2D = 250 /* MAX SELECT LINES DEFAULT */ IF (&DSNESV2C = &Z) &DSNESV2C = 4092 /* RECORD LENGTH DEFAULT */ IF (&DSNESV21 = &Z) &DSNESV21 = 4096 /* BLOCK SIZE DEFAULT */ IF (&DSNESV22 = &Z) &DSNESV22 = VB /* RECORD FORMAT [...] 11615 177 51_Re: DB2I defaults disappearing when migrating to V612_Bing Alabata25_bing.alabata@MCMASTER.COM31_Fri, 30 Jun 2000 17:39:27 -0500387_iso-8859-1 Just a follow up. This may be the key to the SPUFI variables disappearing act. There are now 2 panel libraries in DB2 V5, i.e. DSN510.SDSNSPFP and DSN510.SDSNPFPE. All the DSNE Panel source members are in the latter while the install panel member are in the earlier. In the case of SPUFI, the new panel library can me modified to change the default initialization parms. [...] 11793 39 26_Re: Migrating DB2 V5 to V611_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 30 Jun 2000 15:46:03 -0700396_iso-8859-1 I migrated my test system to v6 with out any real problems. I'm currently having a time with the fallback. I though I had all of the fallback PTFs applied, but I evidently missed one?? cliff:-)



-----Original Message----- From: Joe Hartmann [mailto:jhartman@MAIL.STATE.MO.US] Sent: Wednesday, June 28, 2000 4:38 AM To: DB2-L@RYCI.COM Subject: Migrating DB2 V5 to V6 [...]