1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 1999, week 3 2 56 80_Re: Is there anyway to tell the order of Loading 255 tables with RI into DB2/UDB12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Mon, 15 Nov 1999 10:07:00 -0000514_- I would suggest running with the ENFORCE(NO) option then running the CHECK DATA utility against anything with a CHECK PENDING status. With complex relationships (or even self referencing tables) it can be impossible to get the 'right' sequence.

HTH,

Colin Allen, DB2 DBA Abbey National

Colin.Allen@AbbeyNational.Co.Uk ---------- From: Christine Sawyer To: DB2-L@RYCI.COM Subject: Is there anyway to tell the order of Loading 255 tables with RI into DB2/UDB Date: 12 November 1999 15:58 [...] 59 60 8_FW: ODBC14_Richard Bourke25_Richard.Bourke@MERANT.COM31_Mon, 15 Nov 1999 12:23:27 +0100553_- JAL, 1. security implications, in no particular order, and with some possible solutions: A. Does the odbc driver support static sql ? If yes, grant access to the plan and that should be all you need. If no, are you prepared to grant access to the underlying objects? If yes, do (and also EXECUTE on the dynamic plan). If no, some solutions (such as sequeLink odbc edition, made by Merant, for whom I work) will allow a mapping so that you don't have to provide logins direct access to objects. B. Can you be sure that the application calling via [...] 120 69 19_Re: monotoring tool0_15_sokeefe@VCU.EDU31_Mon, 15 Nov 1999 06:41:55 -0500661_us-ascii Karina, I use Database-Guys "Wise-GUY" monitoring and DB2 tuning tool for this very purpose. "Wise-GUY" integrates CPU busy, paging, and virtual memory monitoring along with DB2 UDB database monitoring. "Wise-GUY" is easy to use like 'monitor' and helps the DBA focus on System and DB2 performance metrics that are important. At VCU, we also use "Pool-GUY" for BP monitoring/tuning, and "ConnectionMiner", to see who is doing what with our DataMarts. All of the Database-Guys tools have been easy to install, easy to use/understand, and they stand behind thier products. As a working-DBA/state employee, I usually do not endorse vendors publicly, [...] 190 126 43_Re: Mergecopy Utility and Disaster Recovery0_22_BILL_GALLAGHER@PHL.COM31_Mon, 15 Nov 1999 08:25:01 -0500422_us-ascii Sanjay,

Thanks for the info, but I'm looking in the DB2 v5 "Utility Guide and Reference" under MERGECOPY, and cannot find what you are referencing below. Can you point me to exactly where in the manual you are finding this?

Also, if anybody on the list has been able to do this, can you please show me an example of the utility syntax to merge local incrementals into a new recovery site full? [...] 317 26 46_Installing UDB/NT on an existing MS SQL Server13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 15 Nov 1999 08:26:26 -0500421_- Has anyone installed UDB (either 5.2 or 6.1) on an NT server which already has MS SQL Server (6.5) running on it? Ideally, I would have preferred to keep them separate but we're having trouble getting a new test box. By the way, is there an issue with service pack (SP) 3 versus SP 4 on NT? I'm not an NT expert but I know SQL Server 6.5 doesn't coexist well with SP 4. Does UDB have the same problem/restriction? [...] 344 101 43_Re: Mergecopy Utility and Disaster Recovery15_Gingras, Martin30_Martin.Gingras@CCRA-ADRC.GC.CA31_Mon, 15 Nov 1999 08:40:33 -0500549_- Hi,

Two things about your email :

1- You could use the dual copy facility of the copy job. Sending one copy offsite and keeping your other one local and then using it for your merge copy jobs.

2- Depending on when you want to run your quiesce, if there is not so much activity on your database the quiesce will go through easilly. We are doing SHRLEVEL CHANGE here (even for our incremental) and we are doing a quiesce after for our point of consistency. The problem with this is that you would have to recover to RBA. A [...] 446 42 34_Changing password from DB2 Connect13_Murat Umurhan25_Murat.Umurhan@TCMB.GOV.TR31_Mon, 15 Nov 1999 15:46:43 +0200557_windows-1254 Hello,

From the DB2 discussion list we have some answers related to the subject. We have studied our environment and we could not match the answers with our site. To change the passwords there are two choices to use: MVS/ESA SP and CICS-APPC PEM by using SNA for communication. We have seen that it is possible to use the Cics option for our site. But there is a little problem with the manuals, that is we use CA-Top Secret for security and the manuals are related with RACF as you know. Also our CICS versions ara 4.1 and TS 1.2. [...] 489 113 43_Re: Mergecopy Utility and Disaster Recovery18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 15 Nov 1999 07:48:17 -0600565_iso-8859-1 Bill, I'm not trying to be argumentative, just, hopefully, helpful. If your company's intentions are like most company's, they intend to roll as far forward as they can in the event of a disaster recovery at a hot site. Now, please ask yourself of what value is the QUIESCE point you are trying to retain? Is any user QUIESCE point valuable? Or for that matter, Image Copy SHRLEVEL REF (you're going to roll forward out of the logs which don't need a SHRLEVEL REFERENCE Copy)? Even if you don't roll as far forward as you can? This might be because [...] 603 165 43_Re: Mergecopy Utility and Disaster Recovery0_22_BILL_GALLAGHER@PHL.COM31_Mon, 15 Nov 1999 09:50:05 -0500522_us-ascii Rick,

Thanks for the response. Your points are very valid. I would just like to quickly resond to your questions/points.

I have two separate concerns here: (1) to be able to have a full image copy available at the recovery site in the event of a disaster recovery scenario; and (2) to have the ability to perform very specific point-in-time recoveries at our local site in the event of an application recovery scenario. Our current backup strategy fits both of these requirements quite nicely. [...] 769 15 43_Re: Mergecopy Utility and Disaster Recovery12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Mon, 15 Nov 1999 08:56:14 -0600278_us-ascii Have you looked at 'Update While Open'. There is a package called SysB from H&W Systems in Idaho that will allow you to update you CICS VSAM files while they are online. I have used this product in the past and it was very helpful in opening up that batch window. [...] 785 34 4_jdbc18_Campidoglio, Elena29_E.Campidoglio@CEDACRIOVEST.IT31_Mon, 15 Nov 1999 15:54:16 +0100539_- hi everybody, i'm trying to test the sample01 shipped with jdbc I have os/390 2.7 and db2 5.1 and after adding classpath, libpath....and so on I sadly get a javadump.

I called ibm support last week and I'm in contact with an ibmer that rapresents a special support but it seems that nobody has a useful suggestion for me. I'd like to know what is necessary to do to make this jdbc working apart from receiving/applying the fmid, following the instructions in the readme and compiling the sample01 substituing the correct url [...] 820 15 42_Gordon Reich/WCBAlta is out of the office.0_22_gordon.reich@WCB.AB.CA31_Mon, 15 Nov 1999 08:19:23 -0700389_us-ascii I will be out of the office starting 1999/11/15 and will not return until 1999/11/22.

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. 836 219 43_Re: Mergecopy Utility and Disaster Recovery18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 15 Nov 1999 09:54:39 -0600640_iso-8859-1 Bill, I agree with you in that the Incremental Image Copies should reduce "wall time" in the "batch window".

Another question, again, hopefully, helpful. If the QUIESCEs they need for point-in-time recoveries are application-determined, do they care when or how an image copy was done? Instead of doing TOCOPY, SHRLEVEL REFERENCE point-in-time recoveries, show them how to use the RBA set by their QUIESCE job to do a TORBA recovery. Is speed of a point-in-time recovery important? If so, have their QUIESCE and subsequent job(s) dependent on completion of your Image Copy SHRLEVEL CHANGE, which you can start at the [...] 1056 14 42_DB2 UDB Developer Edition and Visual Basic18_Claudio Mazzoccoli29_claudio_mazzoccoli@IT.IBM.COM31_Mon, 15 Nov 1999 10:01:46 -0800503_- Are there any web site(s) were to find documentation/samples about Visual Basic application Develoment using DB2 Universal DataBase ?

DB2 Software Developer Kits seems to be very rich in terms of C++/Java code, but not so exhaustive about Visual Basic.

================================================ 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. 1071 21 25_Compression Dictionary...16_Charles Valentin15_VALENCH@AOL.COM29_Mon, 15 Nov 1999 11:07:47 EST326_us-ascii Hi Folks, Can anyone help me out with the following question: Is there any way to build a DB2 compression dictionary for a partition "ahead" of time without having to run a utility against it? ie: If the partition is "empty". Our environment is: DB2 V5.1 @put-9903+hipers. thanks, RichP. e-mail: polovri@bam.com [...] 1093 60 29_Re: Compression Dictionary...15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Mon, 15 Nov 1999 10:39:12 -0600533_ISO-8859-1 I know of no way to 'pre-build' a compression dictionary.

The problem is you have to build the DB2 rows before you can pass the rows to the dictionary builder. To do that you may as well go ahead and load the data.

Reading between the lines, are you running into a case where you do a load replace of a table and one of the parts has no rows added, so no dictionary is built for it? Or, are you looking to get the optimum compression based on the whole partition rather than the first N number of rows? [...] 1154 44 29_Re: Compression Dictionary...14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Mon, 15 Nov 1999 11:48:16 -0500631_iso-8859-1 I believe you'd need to run either a LOAD REPLACE or REORG to build the compression dictionary. You can however, LOAD REPLACE the partition with some dummy data to build the compression dictionary and then delete the data from the partition.

Manas.

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Charles Valentin > Sent: Monday, November 15, 1999 11:08 AM > To: DB2-L@RYCI.COM > Subject: Compression Dictionary... > > > Hi Folks, > Can anyone help me out with the following question: > Is there any way to build a DB2 compression dictionary > [...] 1199 151 29_Re: Compression Dictionary...16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Mon, 15 Nov 1999 12:16:15 -0500529_- I know of no way. Here is what we do. Being an insurance company, we load claims data to a large data warehouse partitioned table once a month. Since it isn't practical ot size all partitions to their full size prior to use we size them up quarterly. To do this, we alter the partitions to their new size, load about 2,000 rows of "seed" data into these partitions, reorg the newest partitions (thus creating the dictionary) and then delete the data. This insures that the new partitions have a resonably good dictionary. [...] 1351 30 43_Re: Mergecopy Utility and Disaster Recovery13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Mon, 15 Nov 1999 10:45:21 -0700589_- Just a thought: I've interpreted concurrent copy or snaphsot as a valid product/process if you have a specific need to recover to a specific point in time and also allow changes to occur while making the copy.,i.e. the application on a regular basis would like to see the data as it looked 1 month ago, otherwise recovery scenarios will be recover to current (the last successful UOW) or to LRSN/RBA in a DR scenario. You might consider ARCHIVE LOG MODE(QUIESCE) which is less disruptive to virtual pools and applications and has retry logic so it's failure to execute is minimized [...] 1382 38 29_Re: Compression Dictionary...13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 15 Nov 1999 12:58:43 -0500424_- It would make sense to load 'quasi-dummy' data into the partition (because the load utility will build the compression dictionary) and then delete the data if you are going to populate the partition via SQL inserts. The inserts will not cause a compression dictionary to be built. If you're going to populate the partition with production data via the load utility anyway, you don't need to pre-build the dictionary. [...] 1421 48 29_Re: Compression Dictionary...12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Mon, 15 Nov 1999 10:13:32 PST446_- Charles:

I guess it is not posible because db2 has to read the data and it decides if this data is a good candidate to compress and against this process db2 data compression might be the optimal. (data with repeated string (such as names , addreess) or number with sequences of zeros) results in good compression savings. For this reason I don't believe that triyng to create db2 compression dictionary on empty table is recommend. [...] 1470 43 47_UDB 5.2 JDBC, Websphere and Fixpack 11 - URGENT14_Rebecca A Bond22_rebecca_a_bond@UHC.COM31_Mon, 15 Nov 1999 13:20:32 -0500461_us-ascii We were having app connectivity errors using Websphere and UDB 5.2 (no fixpacks). This didn't happen until we got a heavier than usual load. IBM support advised that this was a known JDBC issue and to apply at least Fixpack 8. We applied Fixpack 11 instead.

We are now getting the same error from the Websphere app (CLI0614E) as we did before the fixpack was applied, but the JDBC logs are showing new (different) errors since the upgrade: [...] 1514 49 56_Re: DB2-L Digest - 13 Nov 1999 to 14 Nov 1999 (#1999-41)10_Leo Flores23_leoflores@EARTHLINK.NET31_Mon, 15 Nov 1999 10:51:37 -0800619_us-ascii Try moving it to a S9(m)v(n) field(no comp-3) and display that. Depending on the SIGN of the decimal, you may have to adjust the pic 9 clause so that the number is displayed the way the User desires.

HTH Leo Flores

Karthik Subramaniam wrote:

> Hi all.... > I am involved in developing an online application involving CICS, VS-COBOL II > and DB2. Further it involves Dynamic SQLs to process queries from the CICS > screen. > I had no problems in displaying CHAR, TIMESTAMP,VARCHAR except for data types > DECIMAL(m,n) since they require a corresponding s9(m)v(n) comp-3 declarations > [...] 1564 34 28_Claimers through DB2 Connect13_Chris Roberts19_CTROBERT@HEWITT.COM31_Mon, 15 Nov 1999 12:43:39 -0600327_us-ascii Hello all,

I am an application developer in an environment where we use the DB2CAE (currently 5.0) on the desktop, a DB2 Connect (5.2) gateway, and DB2 for OS/390 (a mixture of v5 and v6 databases). We also live in an evironment where the occasional RESOURCE UNAVAILABLE error is inevitable for our users. [...] 1599 18 44_Load data inddn sysrec log no part n replace15_Robin Woolyhand22_woolyhr@NATIONWIDE.COM31_Mon, 15 Nov 1999 12:53:02 -0800549_- Does anyone know of problems with using

LOAD DATA INDDN SYSREC LOG NO INTO tablename PART n REPLACE

causing the load job to log even though you have LOG NO?

We were running concurrent loads to the partitions with log no and the data center claims we were logging and forcing archives.

================================================ 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. 1618 43 48_Re: Load data inddn sysrec log no part n replace20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 15 Nov 1999 14:30:43 -0500606_- Robin

If you have non partitioning index (NPI), then some logging can occur during build phase. Otherwise I have loaded million of rows in LARGE tablespace with NO NPI and near 4GB each parts and never there were problems.

Regards Venkat Pillay

> -----Original Message----- > From: Robin Woolyhand [SMTP:woolyhr@NATIONWIDE.COM] > Sent: Monday, November 15, 1999 3:53 PM > To: DB2-L@RYCI.COM > Subject: Load data inddn sysrec log no part n replace > > Does anyone know of problems with using > > LOAD DATA INDDN SYSREC LOG NO > INTO tablename PART n REPLACE > > causing the load [...] 1662 55 48_Re: Load data inddn sysrec log no part n replace10_Mann, Tony19_TMann@UTILICORP.COM31_Mon, 15 Nov 1999 13:47:15 -0600352_- Robin

Is this tablespace a member of a large database (ie, is the DBD large?).

Reorg, Load and DDL (among others) log before and after pictures of the DBD. A large DBD and multiple partitions being reorged could result in a lot of logging: and there is nothing you can do about it, other than move the tablespace to a smaller DBD. [...] 1718 271 43_Re: Mergecopy Utility and Disaster Recovery0_22_BILL_GALLAGHER@PHL.COM31_Mon, 15 Nov 1999 14:52:37 -0500648_us-ascii Rick,

Our current recovery strategy is to do TOLOGPOINT (we're a data-sharing shop) recoveries as opposed to TOCOPY recoveries on those rare occasions when we actually have to do application recoveries (we've been lucky, not too many!). We're dealing with a fairly large application (157 tables) with a lot of referential integrity (228 constraints), so TOCOPY recoveries would be a real pain in the neck to be assured that the entire application is recovered to a single, consistent state. They are currently taking their full image copies as SHRLEVEL REFERENCE because on occasion they like to copy their production database [...] 1990 21 19_Re: RCT Entry Macro0_21_william.poston@DB.COM31_Mon, 15 Nov 1999 13:42:51 -0600290_us-ascii I have sent this message before but I do not think it is making it to the list so I am sending it again! Could someone please explain to me how RACF security works for DB2 CICS tranctions using plans... specifically defining how AUTH values work on RCT Entry Macro Parameters [...] 2012 89 15_REASON=00F300880_14_mtdage@ATT.NET31_Mon, 15 Nov 1999 20:02:48 +0000351_- Help please............

I am getting this error message when I tried to issue the command EXEC SQL CONNECT TO USTOPNETDB2I using DB2I SPUFI to test my DRDA connection. I am trying to make a DB2 subsystem (DSSJ) for OS/390 on Unix System Services (we call it our WEBS LPAR) talk to DB2 subsystem (DSSI) for OS/390 in our OS/390 MVS LPAR. [...] 2102 25 26_Imagecopy Tape Compression11_Carl Nelson20_Carl_Nelson@AICI.COM31_Mon, 15 Nov 1999 15:24:29 -0500581_US-ASCII I've been reviewing our recovery abilities for DB2. In my readings of Craig Mullin's book, he suggests compressing imagecopies on tapes using silo compression (pg 794). I've asked our tech staff about doing this but they are not familiar with it. Is this hardware compression, software compression, microcode? What model of carts is required? Does DCB=TRTCH=COMP invoke this? What am I looking at? Beyond ensuring that we have the correct hardware at the disaster recovery site, what other issues could blindside me if I use compressed imagecopies? We are on DB2 v4. [...] 2128 37 30_Re: Imagecopy Tape Compression10_Leo Flores23_leoflores@EARTHLINK.NET31_Mon, 15 Nov 1999 12:49:17 -0800374_us-ascii When I was working at LADWP, we used the DCB=TRTCH=COMP and were able to recover on-site(not 100% about recovery site but pretty sure we did). I also remember our DB2 System Programmer indicating that the DB2 Archive Logs could not be compressed using the DCB=TRTCH=COMP. We had V4.1 at that time and I am now retired but interested in finding DBA work again. [...] 2166 324 43_Re: Mergecopy Utility and Disaster Recovery18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Mon, 15 Nov 1999 14:53:35 -0600568_iso-8859-1 Bill, The headache was not intended, however, in cases like this I've found that taking 2 (two) Excedrin now, and two adult beverages immediately after work helps me! Wow, we've come a long way on this one. So, would it be true to say that the applications staff(s) are the ones to determine when the QUIESCEs need to occur (I would think just before their mainline processing/jobs start)? If so, show them, or do it for them, how to establish the "RI tablespace sets" that need to be QUIESCEd as a group and affected by the job(s). To avoid CHECKing, [...] 2491 163 48_Re: Load data inddn sysrec log no part n replace12_Kapil Mathur25_Kapil.Mathur@WACHOVIA.COM31_Mon, 15 Nov 1999 15:58:05 -0500424_us-ascii

Why does DB2 log pre-image & post-image of the DBD on a LOAD or a REORG? Does the execution of a LOAD or a REORG change anything in the DBD itself?

TIA









"Mann, Tony" @RYCI.COM> on 11/15/99 02:47:15 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 2655 27 18_Database Migration12_Mark Britton25_Mark.Britton@COMMERCE.COM31_Mon, 15 Nov 1999 14:04:24 -0700404_iso-8859-1 What is the best way to migrate (or copy) a database from one machine to another?

Please reply to mbritton@commerce.com because I subscribe to the digest version of the list, but this is kind of an urgent case...

Thanks!

Mark Britton Database Administrator Global Commerce Systems, Inc. mbritton@commerce.com Phone: 303.583.5070 Fax: 303.583.5070 Pager: 303.851.8765 [...] 2683 50 30_Re: Imagecopy Tape Compression15_Webster, Murray30_Murray.Webster@CCRA-ADRC.GC.CA31_Mon, 15 Nov 1999 16:25:29 -0500328_iso-8859-1 I assume that he is referring to tape compaction which is available on a 3480 type device with the improved data recording capability (IDRC) feature. This is a hardware feature which at my shop is used by default. On a related note, compaction is undesirable for archive logs, so we set COMPACT=NO in the ZPARM. [...] 2734 147 24_Re: Compression Checking15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Mon, 15 Nov 1999 16:24:30 -0500405_iso-8859-1 Thanks for all the reply. I have done little more digging into our system and found that we run a nightly BMC copy job with COPY RMGROUP xxx.xxxx FULL YES SHRLEVEL ANY RESETMOD NO ACCESS EXCP COPYDDN( COPY0001 ) RECOVERYDDN( COPY0002 ) COPYDSN( &USERID.&SSID.&DB.&TS.P&PART.D&DATE ) RECOVERYDSN( DR.&SSID.&DB.&TS.P&PART.D&DATE ) SQUEEZE NO CHECKERROR 4 COMPRESS NO RUNSTATS YES UPDATE ALL [...] 2882 134 19_Re: REASON=00F3008812_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 15 Nov 1999 13:30:37 -0800542_us-ascii Your HOST TOP SECRET password is not correct for the USERID that you used. That is what the message is trying to tell you. Either you used the wrong password, or the userid had its password revoked by Top Secret.

--- mtdage@ATT.NET wrote: > Help please............ > > I am getting this error message when I tried to > issue > the command EXEC SQL CONNECT TO USTOPNETDB2I using > DB2I SPUFI to test my DRDA connection. I am trying > to > make a DB2 subsystem (DSSJ) for OS/390 on Unix > System > Services (we call it our [...] 3017 123 48_Re: Load data inddn sysrec log no part n replace10_Mann, Tony19_TMann@UTILICORP.COM31_Mon, 15 Nov 1999 15:32:54 -0600340_- Good question.

But it was about ten years ago that I came across this problem (the hard way - 800 user QMF tables in one database. IBM said "you're not supposed to do that" -- I still haven't seen that restriction documented....) -- so I cannot remember chapter and verse, and I no longer have access to the diagnosis manual. [...] 3141 153 24_Re: Compression Checking10_Leo Flores23_leoflores@EARTHLINK.NET31_Mon, 15 Nov 1999 14:19:19 -0800594_us-ascii You could perform a RUNSTATS on those tablespaces that you're concerned about and then see what the stats look like.

HTH - Leo Flores

Philip, Sibimon wrote:

> Thanks for all the reply. I have done little more digging into our system > and found that we run a nightly BMC copy job with > COPY RMGROUP xxx.xxxx > FULL YES > SHRLEVEL ANY > RESETMOD NO ACCESS EXCP > COPYDDN( > COPY0001 > ) > RECOVERYDDN( > COPY0002 > ) > COPYDSN( > &USERID.&SSID.&DB.&TS.P&PART.D&DATE > ) > RECOVERYDSN( > DR.&SSID.&DB.&TS.P&PART.D&DATE > ) > SQUEEZE NO CHECKERROR 4 > COMPRESS [...] 3295 122 30_Re: Imagecopy Tape Compression11_Chris Hardy15_hardy@URVIP.NET31_Mon, 15 Nov 1999 16:27:25 -0600400_iso-8859-1

Its compression to save tape (physically) whereas a shop may/can reduce the physical number of tape/s... So, if you don't utilize compression backup/disaster recovery may have 30 tapes, using compression, shop may reduce the number to say maybe 10-15 tape cartridges.... Combinations (options) of compression can be achieved via hardware as well as software embedded feature. [...] 3418 83 30_Re: Imagecopy Tape Compression14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Tue, 16 Nov 1999 09:37:47 +1000610_us-ascii Leo,

"DB2 Archive Logs could not be compressed using the DCB=TRTCH=COMP" is not true. They can be - there may, however, be a performance problem when using them.

To do a rollback, DB2 reads backwards through the log. The earlier tape drives could not read a compressed tape block backwards, only forwards. So to read backwards through the tape the drive had to physically: - position at the start of a block - read block forwards, decompressing during the read - move backwards two blocks (to position at the begining of the prior block) - read block forwards, decompressing during [...] 3502 30 13_Websphere 3.014_O'Conner, John26_john.oconner@COURTS.WA.GOV31_Mon, 15 Nov 1999 14:47:58 -0800444_iso-8859-1 Hello list,

We have contractors who created an app using container managed Enterprise Java Beans with WebSphere Advanced 2.02 on NT. At the time, they were using DB2/390 5.1 as the persistence for the app. When they converted the app to WAS Advanced 3.0 NT they no longer had DB2/390 working. They are using UDB 6.1 local to get to 5.1 DB2 on the host/390. The application does work however if the DB is local (UDB 6.1). [...] 3533 234 43_Re: Mergecopy Utility and Disaster Recovery0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 15 Nov 1999 16:25:08 -0600330_us-ascii Question, I don't think I've heard anyone suggest putting tables with RI into a single TS. Is it that bad an option for large DB's? I know there are some space issues given rows of different length. Is there any practicle (I know, "... it depends ...") limits on the number of RI'd tables you'd want in a single TS? [...] 3768 38 113_Reminder! - $149 - 12/2-3 - Willie Favero-DB2 Recover From Z to A & Fun with DB2 Performance for Everyone Classes0_23_cathy.peck@HIGHMARK.COM31_Mon, 15 Nov 1999 17:54:40 -0500635_us-ascii Hi all! Just wanted to send out a reminder that Willie's December Camp Hill classes are still open.

So if you are contemplating attending, please register asap.

Contact me if you have any questions. Tks!!! Seeya Cathy Peck - (717) 975-7396 / Cathy.Peck@Highmark.Com



--------------------------- Willie Favero Class - 12/2 - $149 - DB2 Recovery from Z to A To see class details & to register, go to http://www.bmc.com/education/index.html Click on REGISTER. Then click on COURSE REGISTRATION. Then click on CONTINUE. Then select DB2 RECOVERY FROM Z TO A (2nd occurrence) on the drop down menu. [...] 3807 40 46_Re: DB2 UDB Developer Edition and Visual Basic0_15_leon@CA.IBM.COM31_Tue, 16 Nov 1999 07:13:49 +1100602_us-ascii Version 6 has VisualBasic samples in \SQLLIB\samples\ADO\VB and \SQLLIB\samples\RDO subdirectories.

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



Claudio Mazzoccoli on 11/16/99 05:01:46 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: DB2 UDB Developer Edition and Visual Basic







Are there any web site(s) were to find documentation/samples about Visual Basic application Develoment using DB2 Universal DataBase ? [...] 3848 50 50_Re: Installing UDB/NT on an existing MS SQL Server0_15_leon@CA.IBM.COM31_Tue, 16 Nov 1999 07:10:24 +1100429_us-ascii I have both DB2 UDB and MS SQL Server installed on several boxes. The re are no problems that I can see.

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



Lynne Flatley on 11/16/99 12:26:26 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Installing UDB/NT on an existing MS SQL Server [...] 3899 115 13_c++ and cobol6_RANJAN23_Ranjan.Kotnala@WCOM.COM31_Mon, 15 Nov 1999 17:20:08 -0700741_iso-8859-1 Hi List Following is an example from an IBM manual for an inter language communication application.

Figure 20 and Figure 21 contain an example of an ILC application. The C++ routine CPP1 statically calls the COBOL CBL1 program. CBL1 statically CALLs C++ routine CPP2.

/* Module/File Name: EDCXCB */ /******************************************************************/ /* Illustration of Interlanguage Communication between C++ */ /* and COBOL. All parameters passed by reference. */ /* */ /* CPP1 ---------> CBL1 ---------> CPP2 */ /* static static */ /* call call */ /******************************************************************/ #include #include #include extern "COBOL" [...] 4015 79 50_Re: Installing UDB/NT on an existing MS SQL Server0_29_Greg.Palgrave@BANKWEST.COM.AU31_Tue, 16 Nov 1999 08:24:32 +0800351_us-ascii Hello Lynne,

We have several servers running both MS-SQL Server and DB2 UDB V5.2, but UDB was installed first (if that matters). SQL Server on these machines is used for Unicenter TNG databases for job scheduling, UDB is for real applications.. :)

They seem happy to coexist. I don't know if any of the servers are at SP4. [...] 4095 96 50_Re: Installing UDB/NT on an existing MS SQL Server13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 15 Nov 1999 20:41:41 -0500606_- Oh good. Thanks much.

> -----Original Message----- > From: Greg.Palgrave@BANKWEST.COM.AU [SMTP:Greg.Palgrave@BANKWEST.COM.AU] > Sent: Monday, November 15, 1999 7:25 PM > To: DB2-L@RYCI.COM > Subject: Re: Installing UDB/NT on an existing MS SQL Server > > Hello Lynne, > > We have several servers running both MS-SQL Server and DB2 UDB V5.2, but > UDB was installed first (if that matters). > SQL Server on these machines is used for Unicenter TNG databases for job > scheduling, UDB is for real applications.. :) > > They seem happy to coexist. I don't know if any of the servers are at SP4. [...] 4192 25 8_Re: jdbc13_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM31_Tue, 16 Nov 1999 08:22:38 +0530576_us-ascii hi elena

Can u send me your dump??

See check following points-

- r u prepare dsnacli plan using supplied DBRMs. if not prepare it. - grant execute authority on this plan to your userid.

If again u r not succeed send me dump on my personal id mayank.sharma@powaimail.ltitl.com

regards mayank

================================================ 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. 4218 18 19_Re: REASON=00F3008813_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM31_Tue, 16 Nov 1999 08:29:35 +0530365_us-ascii Hi

There may be problem due to ur Id may be revoked. Ask you RACF admin to resume it.

regards mayank

================================================ 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. 4237 57 61_Will DB2 use other index if it can match on the primary key ?14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Tue, 16 Nov 1999 16:24:40 +1000313_us-ascii Hi Folks, I believe I remember from some previous discussion that if DB2 can perform a full matching scan on the primary key then it won't attempt to use any other index. I'm not sure if this was true/ was not true/ is still true / is not still true and was wondering if someone could enlighten me. [...] 4295 87 65_Re: Will DB2 use other index if it can match on the primary key ?14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Tue, 16 Nov 1999 17:43:26 +1100575_- Pre V4 - No From V5 - Yes

Terry Purcell DBA & Environments Manager Product DBoR - Telstra Phone: +613 98657164 Fax: +613 98045368 Mobile: 0416 221582

> -----Original Message----- > From: Paul A Redhead [SMTP:Paul.A.Redhead@TRANSPORT.QLD.GOV.AU] > Sent: Tuesday, 16 November 1999 05:25 pm > To: DB2-L@RYCI.COM > Subject: Will DB2 use other index if it can match on the primary key > ? > > Hi Folks, > I believe I remember from some previous discussion that if DB2 can > perform > a > full matching scan on the primary key then it won't attempt to use any [...] 4383 82 65_FW: Will DB2 use other index if it can match on the primary key ?14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Tue, 16 Nov 1999 17:45:06 +1100517_- Should read > Pre V5 - No > From V5 - Yes > (Sorry) > -----Original Message----- > From: Paul A Redhead [SMTP:Paul.A.Redhead@TRANSPORT.QLD.GOV.AU] > Sent: Tuesday, 16 November 1999 05:25 pm > To: DB2-L@RYCI.COM > Subject: Will DB2 use other index if it can match on the primary key > ? > > Hi Folks, > I believe I remember from some previous discussion that if DB2 can > perform > a > full matching scan on the primary key then it won't attempt to use any > other > index. I'm not > sure if this was true/ was [...] 4466 33 0_19_kishore erukulapati21_kishore_e@HOTMAIL.COM29_Mon, 15 Nov 1999 23:42:24 PST529_- >> >>We want to sum all the rows corresponding to amount column of a table . >>When >>we use DB2 Sum function we are getting Sql Code -304 . We have defined >>Host >>Variable ( to hold the sum ) as PIC S9(15)V9(3) USAGE COMP-3 as this is >>the >>max. limit for numeric in VS-COBOL II. >> >>Is there any solution to store the sum ( i.e. to overcome the limitation >>of >>VS-Cobol II) >> >> The pre-compiler option was dec(31) . >> Pre-compilation fails if I increase the host variable >>length . >> >>Thanks , >>Kishore >> [...] 4500 90 30_Re: Imagecopy Tape Compression10_Leo Flores23_leoflores@EARTHLINK.NET31_Tue, 16 Nov 1999 00:22:28 -0800598_us-ascii James, as soon as I read your 2nd sentence I remembered about the problem of reading the compressed archived tapes backwards. You are absolutely correct. Thanks for pointing out that correction.

Leo Flores

Campbell James wrote:

> Leo, > > "DB2 Archive Logs could not be compressed using the DCB=TRTCH=COMP" is > not true. They can be - there may, however, be a performance problem > when using them. > > To do a rollback, DB2 reads backwards through the log. The earlier tape > drives could not read a compressed tape block backwards, only forwards. > So to read [...] 4591 46 28_Re: Waiting for DB2 Services10_Ali Ozturk24_ali.ozturk@PAMUKBANK.COM31_Tue, 16 Nov 1999 10:53:18 +0200633_iso-8859-9 Hi Dan, If you are using HSM or DFDSS volume backup, they can put lock on the volume and db2 utilities can wait them.

----- Original Message ----- From: Dan Courter (543-3870) Newsgroups: bit.listserv.db2-l To: Sent: Monday, November 15, 1999 5:39 AM Subject: Waiting for DB2 Services



> Last week I saw a couple of list members mention DB2 Utilities experiencing > some type of "wait" for DB2 Services. Nothing showed up on -DIS UTIL > but did who up on -DIS THREAD. > > Could someone give me more information about what specific "wait" is > being [...] 4638 69 0_0_24_ssethi@LOT.TATASTEEL.COM31_Tue, 16 Nov 1999 14:31:09 +0530360_us-ascii U can do this by separating the Before DECIMAL and After DECIMAL part and accept it in two different host variables and then combining it for the use but even then u will have to keep that in character field if it exceeds 9(18) i.e the limit. so

SELECT (col1 - DECIMAL(col1)) ,DECIMAL(col1) into :before-decimal, :after-decimal from Table [...] 4708 63 48_Re: Load data inddn sysrec log no part n replace9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 16 Nov 1999 10:07:19 +0000367_us-ascii Used BMC Log Master at DB2 V4 and noticed logging when removing duplicate keys (even thought LOG NO). I guess if you have a lot of duplicates this may cause noticeable logging. Presume mechanism is the same at DB2 V5. Andy Hunt - Scottish And Southern Energy.







Robin Woolyhand on 15/11/99 20:53:02 [...] 4772 15523 7_R: jdbc18_Campidoglio, Elena29_E.Campidoglio@CEDACRIOVEST.IT31_Tue, 16 Nov 1999 13:20:47 +0100805_- hi mayank, thank you very much or yor interest here are the ceedump and the javadump I get after invoking the sample01

<>



JAVADUMP:

SIGSEGV received. Processing terminated

Full thread dump: "Garbage Collector" (TID:0xd59f240, sys_thread_t:0xcd257e8) .(Native Thread State: pthread_t:0c4575c000000003 Reuse:1 . Type:DAEMON State:SLEEPING .) prio=5 ----------------------------------------------------------------------

"Finalizer thread" (TID:0xd59f120, sys_thread_t:0xcd25690) .(Native Thread State: pthread_t:0c4569e000000002 Reuse:1 . Type:DAEMON State:MONITOR WAIT . Monitor:0ccf4770 Owner:00000000 Count:0 . Registered Monitor Name:"Finalize me queue lock" .) prio=5 ---------------------------------------------------------------------- [...] 20296 68 40_Re: Buffer Manager I/O error during read12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Tue, 16 Nov 1999 05:44:49 PST655_- Phil:

just execute the stop and start command on the tablespace where you've got the problem. Try it out and let me know if your problem have been fixed.

I hope it help.







>From: dbasupport@WILLIS.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Buffer Manager I/O error during read >Date: Thu, 11 Nov 1999 08:49:26 +0000 > >Hi, > >We have had three errors this week on our main DB2 system similar to the >following > >12.04.29 STC15550 DSNB225I -DB2Q DSNB5RDP - BUFFER MANAGER > I/O ERROR DURING READ > DBNAME=DBSS2PRD > SPACENAME=SUPOSTS > DATA SET NUMBER=3 > [...] 20365 274 43_Re: Mergecopy Utility and Disaster Recovery18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Tue, 16 Nov 1999 07:46:20 -0600469_iso-8859-1 Hi Rohn, I'm sure your suggestion of putting RI related tables into a single tablespace has merit when accessed by a single application. Static reference tables, if RI related, would seem to be some of the candidates. However, might this be a problem when many applications need the reference tables? For non-partitioned tables, many utilities use a tablespace lock. You loose granularity. This could be a problem because all applications are affected. [...] 20640 372 43_Re: Mergecopy Utility and Disaster Recovery0_22_BILL_GALLAGHER@PHL.COM31_Tue, 16 Nov 1999 09:26:26 -0500598_us-ascii Rick,

Thanks for the advice about Excedrin and beverages, I'll keep that in mind. Now back to business . . .

We've worked with the application staff to identify the key points in their batch cycle where we want to establish potential recovery points, and they are currently QUIESCEing their entire database (all 157 tables) at a number of distinct places: at the start of batch, at the end of batch, and at various points in between their update programs in their batch cycle. The entire database is QUIESCEd at once because of the complexity of the RI defined. There's [...] 21013 50 0_14_Sunit C. Patke19_patkes1@STATE.MI.US31_Tue, 16 Nov 1999 09:14:25 -0500623_US-ASCII Kishore,

Convert the number to FLOAT by using FLOAT function. e.g. FLOAT(SUM(mycolumn)).

Use corresponding datatype in COBOL.

Sunit

>>> kishore erukulapati 11/16 2:42 AM >>> >> >>We want to sum all the rows corresponding to amount column of a table . >>When >>we use DB2 Sum function we are getting Sql Code -304 . We have defined >>Host >>Variable ( to hold the sum ) as PIC S9(15)V9(3) USAGE COMP-3 as this is >>the >>max. limit for numeric in VS-COBOL II. >> >>Is there any solution to store the sum ( i.e. to overcome the limitation >>of >>VS-Cobol II) [...] 21064 78 0_17_LaLuzerne, George32_George.LaLuzerne@DOA.STATE.WI.US31_Tue, 16 Nov 1999 08:59:17 -0600459_iso-8859-1 I had a similar type problem about a couple of years ago and was helped out by James Campbell. Correct me if I'm wrong James, but I think the solution went something like this . . .

* Define a pic x working storage field to retrieve your value. * I'm just using a 25 byte field here for an example. 01 WS-SUM-HEX PIC X(25). 01 FILLER REDEFINES WS-SUM-HEX. 05 WS-SUM-C-HI PIC 9(12). 05 WS-SUM-C-LO PIC 9(9)V9(3). 05 WS-SUM-C-SIGN PIC X. [...] 21143 23 4_jdbc15_Sherri Sterling23_ssterling@BPD.TREAS.GOV31_Tue, 16 Nov 1999 10:32:55 -0500463_US-ASCII I'm not sure if this is your problem, but the sample01 that comes with db2 is a java program and after you compile it, then you can only run it from UNIX. In order to run it from a browser and specifying a url, then you need to make it a servlet. Then the web administrators has to set up a link from the servlet to the java program. Ours is working fine. You also have to at version 1.3 maintenance level of the Language Environment/370 or higher. [...] 21167 24 29_Data Sharing and DB2 Datasets0_21_rumina.jivraj@BMO.COM31_Tue, 16 Nov 1999 10:54:32 -0500576_us-ascii We are in the process of setting up our first data sharing environment. In the past we copied the contents of SDSNEXIT, SDSNLOAD and SDXRRESL as well as RUNLIB.LOAD to a subsystem specific load library. In a data sharing group however, the members are supposed to be able to exist at different releases. How do people handle the libraries? Does each member have its own set of all the libraries, load libraries as well as clist,panels etc.? DSNHDECP and the EXITS have to be common - so one would need at least one common library. I would really appreciate some [...] 21192 64 51_LOAD utility running with DSNUTILS stored procedure8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Tue, 16 Nov 1999 09:37:22 -0600354_us-ascii Thanks to Dan Courter for the information. This is the only one reply i got to this posting.

I would like to know, is any other way to submit multiple utility jobs and write the job output to a DB2 table or to a sequential file?? Any suggestion is highly appreciated. I hope some of the DB2 Guru's can be able to find some solution. [...] 21257 14 52_When is Space made available for reuse after delete?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 16 Nov 1999 09:59:00 -0500435_- When does DB2 make the space available for inserts/updates on data and index pages after some of the data has been deleted in a segmented non-partitioned tablespace?

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. 21272 44 56_Re: When is Space made available for reuse after delete?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 16 Nov 1999 11:50:53 -0500395_- For the both SEGMENTED & PARTITIONED tablespaces the space map is updated with availability of space by flipping the bits. However segmented has 4 bits per page and partitioned spaces have 2 bits per page represented in the space map.

Next insert looks for candidate page based on clustering index and if space is available in candidate page + not locked then the space is reused. [...] 21317 254 55_Re: LOAD utility running with DSNUTILS stored procedure16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Tue, 16 Nov 1999 13:04:16 -0500268_- For the OS/390, simply change your JCL to create a file instead of the SYSOUT report. I have done than many times, then come back with a simple program (my choice is Easytrieve) that reads this file and inserts the info I want to track to DB2 tables I created. [...] 21572 21 39_Commit/Rollback in CICS/DB2 environment21_Devineni, KishoreBabu29_KishoreBabu.Devineni@NIKE.COM31_Tue, 16 Nov 1999 10:16:12 -0800421_us-ascii Hi,

I am just curious to know about the difference between CICS syncpoint and DB2 commit in a DB2/CICS environment.

Thanks In advance

Regards Kishore

================================================ 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. 21594 61 43_Re: Commit/Rollback in CICS/DB2 environment0_19_Tim.Lowe@STPAUL.COM31_Tue, 16 Nov 1999 12:29:55 -0600560_us-ascii A DB2 commit is not allowed in a CICS environment, it will get an sqlcode of -925. You must use a CICS syncpoint command to accomplish this function.













"Devineni, KishoreBabu" on 11/16/99 12:16:12 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

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





Subject: Commit/Rollback in CICS/DB2 environment [...] 21656 38 43_Re: Commit/Rollback in CICS/DB2 environment10_Vikas Puri24_Vikas.Puri@METAMORGS.COM31_Tue, 16 Nov 1999 14:02:19 -0500390_us-ascii The COMMIT SQL statement must not be used in the IMS or CICS environments, instead use the appropriate commit operation for the respective transaction manager that will have the same effect. SYNCPOINT is double phase COMMIT. It will commit only if the remote system(e.g. DB2) ready for commit.

If you use commit in CICS environment you will get some negative sql code. [...] 21695 20 14_db2 udb2 -140211_David Ayers24_david.ayers@HIGHMARK.COM31_Tue, 16 Nov 1999 14:09:46 -0500416_us-ascii We have a udb 5.2 fp 8 on an aix box. We are receiving an SQL1402N when trying to connect to the database from a cae 5.2 client (nt). We can connect to the database locally on the aix box with no problem. The error states the db2ckpw may have the incorrect permissions set. We have verified the permissions as -r-s--x--x 1 root db2iadm1 19576 Oct 07 11:17 db2ckpw. Has anybody experienced this before. [...] 21716 55 18_Re: db2 udb2 -14029_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM31_Tue, 16 Nov 1999 13:48:17 -0800356_us-ascii Check the database manger configuration settings. If authentication is done on the client, then the password cannot be verified there (userid does not exist, or NT security service not started). If authentication is at the server, make sure enough swap (paging) space exits. The permissions on db2ckpw are the same as my Solaris DB2 UDB 6.1. [...] 21772 24 14_Archiving data30_Szeszycki, Matthew (WTC/Lisle)22_mszeszycki@WALLACE.COM31_Tue, 16 Nov 1999 20:09:37 -0000552_iso-8859-1 I am looking for a way to archive data monthly, partitioned by month/year, with the assumption that the archived data could be recovered if needed. I want to keep 2 years of data active, with the ability to restore/recover by the partitioned month/year, if the requested record is more than 2 years old from the current date. We are thinking of using FDR to archive month 1 when we are inserting into the 25th month, month 2 when inserting into the 26th month and so on. Does anyone know if an easier way is possible and if not, is any [...] 21797 39 18_Re: Archiving data14_Huang, Eugenia16_HuangE@AETNA.COM31_Tue, 16 Nov 1999 15:20:14 -0500480_- We have application programs perform this type of purging/archiving process monthly. There's a vender product called: Archive for DB2 by Princeton SOFTECH, you may want to check it out at princetonsoftech.com. I only read about it, but do not have any hands-on experience on it though.

-----Original Message----- From: Szeszycki, Matthew (WTC/Lisle) [mailto:mszeszycki@WALLACE.COM] Sent: Tuesday, November 16, 1999 3:10 PM To: DB2-L@RYCI.COM Subject: Archiving data [...] 21837 65 62_ATTN: Dan Courter >>> Waiting for DB2 Services: a contribution14_Max 'Guderian'16_mocion@LIBERO.IT31_Tue, 16 Nov 1999 21:27:53 +0100595_iso-8859-1 A little contribution to our problem with DB2 V5 and OS/390 2.5.

We had problems with copy, reorg and 1 runstats. The problem appers with an high DB2 MVS page-ins, sometimes after a while utility(ies) was (were) running. Unfortunately no other collegue reported this increase in page-ins with the problems of utilities, so I don't know if it's significant. It may be a problem of our shop, but buffer pools, edm pools, rid pools are small (not SO small however) so we do no waste memory and our monitors do not display memory constraints. Usually page-ins is very low. (0 [...] 21903 60 47_DB2 v5 (OS/390) talking to UDB v6 (AIX) - Help!0_22_BILL_GALLAGHER@PHL.COM31_Tue, 16 Nov 1999 15:52:03 -0500365_us-ascii Hi,

We've just installed UDB v6.1 on an AIX box, and I'm trying to set up the communication database in DB2 v5.1 on OS/390 to be able to connect to AIX. It's not working. This is certainly not my area of expertise, so I'm assuming that I'm missing something somewhere. Can anybody point me in the right direction? Here's what I've done so far: [...] 21964 66 79_ATTN: Dan Courter >>> Waiting for DB2 Services (repost: problem with e-mail...)14_Max 'Guderian'16_mocion@LIBERO.IT31_Tue, 16 Nov 1999 21:46:28 +0100593_iso-8859-1 A little contribute to our problem with DB2 V5 and OS/390 2.5.

We had problems with copy, reorg and 1 runstats. The problem appers with an high DB2 MVS page-ins, sometimes after a while utility(ies) was (were) running. Unfortunately no other collegue reported this increase in page-ins with the problems of utilities, so I don't know if it's significant. It may be a problem of our shop, but buffer pools, edm pools, rid pools are small (not SO small however) so we do no waste memory and our monitors do not display memory constraints. Usually page-ins is very low. (0 [...] 22031 59 18_Re: Archiving data12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Tue, 16 Nov 1999 16:03:31 -0500322_ISO-8859-1 I have also worked with applications programs that performed this activity. The archived data was written to a GDG, and the archiving programs maintained a table of dataset names (with GDG number), dates, and original table ids. This table allowed us to automate the recovery of archived data when needed. [...] 22091 51 33_Re: Data Sharing and DB2 Datasets15_Webster, Murray30_Murray.Webster@CCRA-ADRC.GC.CA31_Tue, 16 Nov 1999 16:27:40 -0500422_iso-8859-1 We use a version qualifier in our dataset names which allows for different members to be at different software levels if need be.

The modules that are normally found in SDSNEXIT should be specific to a release of DB2 - not to a member in a data-sharing group. You will need to distinguish between each member's ZPARM module within a release of DB2, however, using names like DB1ZPARM, DB2ZPARM etc. [...] 22143 37 44_Load data inddn sysrec log no part n replace0_27_mamccormack@STATESTREET.COM31_Tue, 16 Nov 1999 16:39:39 -0500349_US-ASCII Andy Hunt mentioned this briefly in his reply. I wish to expand on it.

When you specify LOG NO on a load utility control statement, it only prevents logging in the Reload phase. There are other phases in the load utility which may make changes to the table, and those changes will be logged, whether or not LOG NO is specified. [...] 22181 120 51_Re: DB2 v5 (OS/390) talking to UDB v6 (AIX) - Help!9_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM31_Tue, 16 Nov 1999 15:43:40 -0800631_us-ascii Bill,

From Spufi you can't code three part names to an SQL database from DB2 OS/390 5.1 Youu can use the CURRENTSERVER(SAMPLE) parameter in the bind for plan .DSNESPCS. I took plan DSNESPRR and bound to my remote DB2 UDB 6.1 Solaris database IRSSDEV as follows:

BIND PLAN (DSNESPRR) OWNER (TSSS037) QUALIFIER(TSSS037) ACTION (REPLACE) RETAIN PKLIST (*.DSNESPRR.DSNESM68) VALIDATE (RUN) ISOLATION (RR) ACQUIRE (USE) RELEASE (DEALLOCATE) NODEFER (PREPARE) CURRENTSERVER(IRSSDEV) CACHESIZE (256) CURRENTDATA (NO) DISCONNECT (EXPLICIT) SQLRULES (STD) DEGREE (1) NOREOPT (VARS) KEEPDYNAMIC (NO) EXPLAIN (NO) [...] 22302 21 31_REXX Pgm to return SQLCODE desc0_18_Usregion10@AOL.COM29_Tue, 16 Nov 1999 17:56:12 EST339_us-ascii Hi all !

I recall that there is one of those DSN.... something load modules that returns the description for a SQLCODE.In other words, its a module that takes the sqlcode as an input and returns the descrption as the output. Does anyone have a CLIST/REXX program to do this function ? Thanks in advance. regards, Anil [...] 22324 57 18_Re: Archiving data23_Campbell, James B - CNF22_Campbell.James@CNF.COM31_Tue, 16 Nov 1999 22:46:09 -0000529_- Hi,

You might want to look at a product from Princeton Softech called Archive for DB2. This product has the exact ability your looking for. I just finished reviewing the product for our company and found it to be very dependable. It can also be run from batch. The product allows relationships between tables to be setup or it can use the current DB2 relationships. So I don't get to longwinded check out the web site WWW.PRINCETONSOFTECH.COM and look at the info contained there. [...] 22382 39 35_Re: REXX Pgm to return SQLCODE desc14_Rao, Lakshmana22_Lakshmana.Rao@NIKE.COM31_Tue, 16 Nov 1999 15:10:33 -0800619_us-ascii The DSQQM_SQL_RC QMF Global variable will contain this info...

Thanks,

Lakshmana Rao

> -----Original Message----- > From: Usregion10@AOL.COM [SMTP:Usregion10@AOL.COM] > Sent: Tuesday, November 16, 1999 2:56 PM > To: DB2-L@RYCI.COM > Subject: REXX Pgm to return SQLCODE desc > > Hi all ! > > I recall that there is one of those DSN.... something load modules that > returns the description for a SQLCODE.In other words, its a module that > takes > the sqlcode as an input and returns the descrption as the output. > Does anyone have a CLIST/REXX program to do this function ? > Thanks [...] 22422 49 35_Re: REXX Pgm to return SQLCODE desc22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM31_Tue, 16 Nov 1999 18:27:39 -0500437_- Anil -

I believe the DB2 routine is DSNTIAR. Maybe it's possible to set up a CLIST/REXX to call DSNTIAR. Not sure of the details...never tried it from CLIST/REXX - only COBOL & PL/I. Maybe there's info in the DB2 REXX Language Support manual available at http://www.software.ibm.com/data/db2/os390/library.html

Also check out DB2 for OS/390 V5 Application Programming and SQL Guide (SG26-8958) for more information. [...] 22472 32 8_Re: jdbc13_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM31_Wed, 17 Nov 1999 08:30:26 +0530439_us-ascii Hi elena,

Here I want to know how r u compile this program? Check the following points in your code.

- for register the DB2 for OS/390 driver with DriverManager Class.forName("ibm.sql.DB2Driver");

- The URL is in the form of "jdbc:db2os390:location_name" String url = "jdbc:db2os390:S390JPDD";

- Compile this program in UNIX using javac programname.ext

- run using command java programname [...] 22505 31 34_DB2 Subsystem Diagnosis methodolgy16_CHUNG SEUNG KEON22_skchung@LGEDS.LG.CO.KR29_Wed, 17 Nov 1999 11:50:40 KST639_euc-kr Hi, DB2 colleague.

Now, I'm looking for any methodolgy or guide related to DB2 system diagnosis. (ex, DSNZPARM parameter setting, DB2 Pool usage, etc).

If somebody has any procedure or guide on this topic, please notify me directly.



Thanks. +------------------------------------------------------+ | Seung-keon, Chung | | KTIC S/W(DB2) Part, LG-EDS Systems Inc. | | LG Kang-Nam Tower 24th Floor | | 679, Yeoksam-dong, Kangnam-gu, Seoul 135-080, Korea | | Phone : 82-2-2005-8891 | | FAX : 82-2-2005-8897 | | E-mail : skchung@lgeds.lg.co.kr | +------------------------------------------------------+ [...] 22537 47 66_Re: ATTN: Dan Courter >>> Waiting for DB2 Services: a contribution15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Mon, 15 Nov 1999 22:42:12 -0600419_us-ascii Below.....

Max 'Guderian' wrote: > We ran 4 image copies on each partition of a partioned tablespace > concurrently and all was OK (but we had the problem with tablespace on > different databases); but when we started the fifth copy DB2 page-ins > increased,

How are you defining "page-ins" (via SDSF paging field on top line, or paging for the individual address space and/or DBM1 itself)? [...] 22585 15 55_Lisa Westcott-Dryer/IS/Corp/Amway is out of the office.0_29_Lisa_Westcott-Dryer@AMWAY.COM31_Wed, 17 Nov 1999 01:01:58 -0500328_us-ascii I will be out of the office from 11/16/99 until 11/18/99.

seminar Lisa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 22601 49 22_DB2 VSAM dataset names0_27_John.Matear@BANKWEST.COM.AU31_Wed, 17 Nov 1999 14:34:04 +0800630_us-ascii A question regarding DB2 VSAM datasets. We have just noticed that quite a number of our development DB2 datasets are not suffixed with the usual "I0001.A001". Instead of for example :

PCBSV.DSNDBC.AKOA1900.AK2IN9Y1.I0001.A001 PCBSV.DSNDBD.AKOA1900.AK2IN9Y1.I0001.A001

we are getting :

PCBSV.DSNDBC.AKOA1900.AK2IN9Y1.I0001.A001 PCBSV.DSNDBD.AKOA1900.AK2IN9Y1.D0225876

Apart from the "D" the remaining numbers seems to be random. Any suggestions as to how this can happen would be much appreciated. I seem to remember a similar problem a few years ago and this (I think) was DFSMS related. [...] 22651 136 26_Re: DB2 VSAM dataset names0_37_SRIRENGAN_VENKATESH_KUMAR@IRAS.GOV.SG31_Wed, 17 Nov 1999 15:31:07 +0800940_US-ASCII





Hi,

Is it because of the HSM recall action. Ofcourse one should not have renamed the LDS directly.

Regards







(Embedded image moved John.Matear@BANKWEST.COM.AU to file: (Tel: ) PIC29701.PCX) 17/11/99 02:34 PM







Please respond to DB2-L@RYCI.COM

To: DB2-L@RYCI.COM cc: (bcc: SRIRENGAN VENKATESH KUMAR/IRAS) bcc: SRIRENGAN VENKATESH KUMAR/IRAS Subject: DB2 VSAM dataset names







A question regarding DB2 VSAM datasets. We have just noticed that quite a number of our development DB2 datasets are not suffixed with the usual "I0001.A001". Instead of for example : PCBSV.DSNDBC.AKOA1900.AK2IN9Y1.I0001.A001 PCBSV.DSNDBD.AKOA1900.AK2IN9Y1.I0001.A001 we are getting : PCBSV.DSNDBC.AKOA1900.AK2IN9Y1.I0001.A001 PCBSV.DSNDBD.AKOA1900.AK2IN9Y1.D0225876 Apart from the "D" the remaining numbers seems to be [...] 22788 110 27_Re: 14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Wed, 17 Nov 1999 18:10:33 +1000540_us-ascii Yes, pretty much. The only thing I would suggest is that Kishore use:

SELECT HEX(SUM(DECIMAL(,??,?))

(making sure that the lengths of the working storage areas and the length of the summed data match.)

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Tooronga +61 3 9261 1802 james.campbell@energyis.com.au -----Original Message----- From: LaLuzerne, George [mailto:George.LaLuzerne@DOA.STATE.WI.US] Sent: Wednesday, November 17, 1999 12:59 AM To: DB2-L@RYCI.COM Subject: [...] 22899 173 26_Re: DB2 VSAM dataset names0_27_John.Matear@BANKWEST.COM.AU31_Wed, 17 Nov 1999 15:28:38 +0800632_us-ascii I have tried migrating and then recalling but it came back with the correct suffix.



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



From: SRIRENGAN_VENKATESH_KUMAR@IRAS.GOV.SG on 17-11-99 03:31 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: John Matear/SDG/SS/BankWest)

Subject: Re: DB2 VSAM dataset names













Hi,

Is it because of the HSM recall action. Ofcourse one should not have renamed the LDS directly. [...] 23073 51 43_Re: Commit/Rollback in CICS/DB2 environment14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Wed, 17 Nov 1999 18:23:05 +1000382_us-ascii As I understand it (and I probably don't), CICS is the transaction co-ordinator (not DB2). So if you are using non-DB2 processes, a CICS syncpoint will initiate the 2-phase commit over the other processes as well as DB2. The -925/-926 is DB2 telling you that it is listening for the commit/rollback message from the CICS transaction co-ordinator rather than your SQL. [...] 23125 38 35_Re: REXX Pgm to return SQLCODE desc13_Paul Fletcher28_Paul_L_Fletcher@BISCUITS.COM31_Wed, 17 Nov 1999 08:47:51 +0000529_us-ascii Anil,

here is a REXX I have written to show a description of an SQLCODE.

/* REXX */ ARG SQLCODE SQLC = D2X(SQLCODE,8) SQLC = X2C(SQLC) SQLCA = 'SQLCA 'X2C(00000088)SQLC||X2C(0000)||COPIES(' ',78) SQLCA = SQLCA||COPIES(X2C(00),24)COPIES(' ',16) TIAR_MSG = X2C(0190)COPIES(' ',400) TEXT_LEN = X2C(00000050) ADDRESS ATTCHPGM 'DSNTIAR SQLCA TIAR_MSG TEXT_LEN' SAY SUBSTR(TIAR_MSG,4,400)



This REXX assumes that your DSNLOAD library is in the steplib for your TSO session or in the LINKLIST. [...] 23164 121 48_Re: Load data inddn sysrec log no part n replace9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 17 Nov 1999 09:25:43 +0000562_us-ascii Ken, I was using DB2 Load. BMC Log Master (1) generated DELETEs for rows with duplicate keys. Ive always assumed that DB2 has to do this to allow restartability of the utility. That is, it would need to backout the deleted rows in order to put the table/index into the same state for the phase being restarted. Therefore I don't think it has any real implications for RECOVER since you wouldnt be rolling through this part of the log on a RECOVER. RECOVER would use the image copy taken after successful completion of the LOAD (since it will be in [...] 23286 39 37_SAP / DB2 Sites - Are you interested?22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Wed, 17 Nov 1999 08:40:45 +0000547_ISO-8859-1 Guys & Gals

Any of you interested in comparing performance stats with our site?

I would just like to build up a picture of what kinds of performance data your SAP DB2 sites are getting and comparing it with my own.

I will do it such that if you supply me with the information from ST03 and ST04 I will collate it into a spreadsheet - without the names of the people or their companies on it and then supply it to all those people that supplied data. That way we have nobody giving away the crown jewels but it [...] 23326 21 39_communication error on UDB on NT server11_Roland Chua21_rolandchua@SES.COM.SG31_Wed, 17 Nov 1999 17:55:05 +0800341_us-ascii Hi, I did a connect to my UDB database on NTserver and left it idle for a while. Subsequently, when i try to acess my database again, I encounter the error message - "SQL30081N communication error has been detected". Apparently, my previous connection to the database has been dropped and I need to do another CONNECT command. [...] 23348 42 33_UDB6.1 - Comms Problem on Solaris22_drdeath@ozemail.com.au22_drdeath@OZEMAIL.COM.AU31_Wed, 17 Nov 1999 14:10:29 "GMT"571_us-ascii I recently installed V6.1 on an environment from which a previous version had been removed, with no problems, but then installed on a second machine from which V5.0 had been removed haphazardly (Our Unix guys love to just delete things), and even though I ran the deinstall and followed the book procedures still ended up with remnants of an instance still on the machine. As a result when I ran the db2install it ended with errors and had failed to create the instance or admin server. I then got a Unix support guy to seek out the offending remnants, and [...] 23391 147 26_Re: DB2 VSAM dataset names22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM31_Wed, 17 Nov 1999 09:23:32 -0500430_iso-8859-1 I don't know if this is what happened in your case. I've seen a similar situation as the result of a DFSMShsm recall that did not complete properly.

When DFSMShsm is recalling a data set the recalled data is written to a temporary data set name - in your case the data component was named "PCBSV.DSNDBD.AKOA1900.AK2IN9Y1.D0225876". I suspect the cluster was named "PCBSV.DSNDBC.AKOA1900.AK2IN9Y1.C0225876". [...] 23539 44 22_Moving to data sharing0_19_mike.holmans@BT.COM31_Wed, 17 Nov 1999 14:22:39 -0000282_- We are just about to embark on the process of setting up and enabling a data sharing sysplex. We need to do this because one of our applications will burst the capacity of a single box in a year or so's time, and we see this as the best way of achieving additional capacity. [...] 23584 27 38_DB2 Connect - Thin client installation10_Robert Ord21_robertord@HOTMAIL.COM29_Wed, 17 Nov 1999 06:40:55 PST444_- I am trying to carry out a thin client installation of DB2Connect client application enabler. However the documentation suggests using the thnsetup program which I can't find on the disks I have. Does anyone have an example of the response file entries required to make this work using the normal client setup. All my attempts result in the all client software being installed on the client without any database connections being setup. [...] 23612 34 21_DB2 V5 (MVS) question11_Hilton Tina15_HiltonT@TCE.COM31_Wed, 17 Nov 1999 10:01:51 -0500355_iso-8859-1 I'm embarrased to ask this question, but here goes. We currently have DB2 3.1 running on MVS/ESA 4.3. I just found out this week that OS/390 was removed from next year's budget, so it looks like we're sticking with 4.3 until 2001. That also means that we won't be upgrading CICS (currently 2.1) to CICS/TS, since that only runs on OS/390. [...] 23647 43 33_Distributed threads holding locks0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Wed, 17 Nov 1999 09:13:08 -0600432_us-ascii PROBLEM: We take a nightly system wide quiesce that lately has been failing due to locks held by distributed threads.

The distributed threads in question, appear to be committing frequently so that is not the problem. We think the problem only occurs when a thread is terminated abruptly from the client such as a reboot or the application abends. Db2 thinks the thread is still active and is held indifinetly. [...] 23691 77 26_Re: Moving to data sharing0_23_Mike_Levine@TEKHELP.NET31_Wed, 17 Nov 1999 10:22:41 -0500585_us-ascii Hi Mike,

With data sharing there is only one DB2 catalog that is shared by all of the members. You would only need to merge catalogs if you have multiple production subsystems to begin with. The recommended approach is to enable your existing DB2 subsystem as a single member data sharing group. You then create one or more member subsystems through the install CLIST process that share the catalog and directory. If you use the existing DB2's susbystem id as the GROUP ATTACH name, then there are very few JCL changes required to run DB2 jobs on either LPAR. The [...] 23769 79 37_Re: Distributed threads holding locks11_Chris Flink17_cflink@AWGINC.COM31_Wed, 17 Nov 1999 09:36:25 -0600328_us-ascii Shan, you can adjust the idle thread times parameter for ddf threads idthtoin. You can also code a release SQL statement in the application which will terminiate the connection at the last commit. Also you might look at binding the application with disconnect ( automatic ). The first suggestion worked for us.... [...] 23849 64 18_Re: Archiving data0_32_thomas.e.faglon@BELLATLANTIC.COM31_Wed, 17 Nov 1999 10:47:21 -0500737_us-ascii There is also The DB2 Row Archive Manager From IBM http://www-4.ibm.com/software/data/db2/os390/v6facts/db2ram.html Tom Faglon NYDBA at http://www.angelfire.com/ny/nydba







"Huang, Eugenia" on 11/16/99 03:20:14 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E Faglon) Subject: Re: Archiving data





We have application programs perform this type of purging/archiving process monthly. There's a vender product called: Archive for DB2 by Princeton SOFTECH, you may want to check it out at princetonsoftech.com. I only read about it, but do not have any hands-on experience on it though. [...] 23914 84 26_Re: Moving to data sharing13_John Arbogast16_jfarbo@YAHOO.COM31_Wed, 17 Nov 1999 08:03:24 -0800526_us-ascii Mike -

As far as I know you cannot merge two existing DB2 subsystems into each other. The catalog merge isn't supported by IBM. I'd go with an existing DB2 and add new ones to the group.

Just my opinions.

--- mike.holmans@BT.COM wrote: > We are just about to embark on the process of > setting up and enabling a data > sharing sysplex. We need to do this because one of > our applications will > burst the capacity of a single box in a year or so's > time, and we see this > as the best way [...] 23999 97 37_Re: Distributed threads holding locks22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM31_Wed, 17 Nov 1999 11:08:31 -0500355_- Read up on Inactive vs. Active threads in the DB2 for OS3/90 Administration Guide (SC26-8957) and the Redbook WOW! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 Universal Database.

From the OS/390 Administration Guide: A database access (DDF) thread that does not hold any cursors or database resources is known as an inactive thread. [...] 24097 76 50_Re: Installing UDB/NT on an existing MS SQL Server12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 17 Nov 1999 18:15:24 +020036_x-user-defined Hi, The same.

24174 73 28_Re: Waiting for DB2 Services12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 17 Nov 1999 18:14:15 +0200554_x-user-defined Hi, Yesterday I had a REORG job with about 60 small TS to be reorged (from 1000-15000 pages each). Some of the big ones are compressed (12000-15000 pages after compression). About the middle of the run DB2 has gone into a wait for service on the reload step after completing the dictionary build (it was without keepdictionary) and got stuck for 30 minutes... We had to recycle DB2 to get rid of the problem (nothing else worked) - anyway it was a TEST DB2 and at 2200 hours .... Nothing was working on the system, no DMS, HSM or any [...] 24248 66 37_Re: UDB6.1 - Comms Problem on Solaris13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Wed, 17 Nov 1999 10:24:14 CST434_- Since this is a new udb server install I would check the connectivity setup and also make sure db2tcpcm and db2tcpim (ps -ef|grep db2tcp)processess are running under the instance owner.

Umair Hussain******************************** DBA Consultant * DB2 UDB, Oracle, Sybase, DataJoiner * IBM Certified Solution Expert - DB2 UDB DBA * IBM Certified AIX System Administrator * ********|All Disclaimers Apply|************** [...] 24315 28 18_DB2 Connect / JAVA10_DB2 Review21_db2review@HOTMAIL.COM29_Wed, 17 Nov 1999 11:39:29 EST515_- There's talk of using Visual Age for Java as part of our new development strategy.

My understanding is that VA Java travels the CAE (DB2CLP) up to the server (DB2Connect) at one end and (DDF) at the other to acces the MF DB2.

In this scenario, the "transaction" as defined as the phase between commits appears to me to be remarkably similar to a spufi or tso-like session, as opposed to a "conventional" CICS/DB2 transaction in its connectivity. Do I have this understanding somewhat correct ? [...] 24344 14 37_Adhoc query tools for OS/390 DB2 data11_Paul Turpin26_Paul.Turpin@FIRSTUNION.COM31_Wed, 17 Nov 1999 12:24:37 -0800524_- I have a customer who is interested in doing adhoc queries against DB2 data on the mainframe (OS/390). They have used Access through a DB2 Connect gateway, but have complained about the speed of queries.

Has anyone used a different adhoc query product that has worked well?

================================================ 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. 24359 37 41_Re: Adhoc query tools for OS/390 DB2 data18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 17 Nov 1999 13:33:05 -0500603_- What about QMF?





Peter J. Krawetzky, Database Administrator Aetna, Inc. Hartford, CT 06156 Email: KrawetzkyPJ@aetna.com Phone: (860) 273-0301





-----Original Message----- From: Paul Turpin [mailto:Paul.Turpin@FIRSTUNION.COM] Sent: Wednesday, November 17, 1999 3:25 PM To: DB2-L@RYCI.COM Subject: Adhoc query tools for OS/390 DB2 data



I have a customer who is interested in doing adhoc queries against DB2 data on the mainframe (OS/390). They have used Access through a DB2 Connect gateway, but have complained about the speed of queries. [...] 24397 33 41_Re: Adhoc query tools for OS/390 DB2 data10_DB2 Review21_db2review@HOTMAIL.COM29_Wed, 17 Nov 1999 13:37:22 EST699_- QMF for Windows is pretty good...



>From: Paul Turpin >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Adhoc query tools for OS/390 DB2 data >Date: Wed, 17 Nov 1999 12:24:37 -0800 > >I have a customer who is interested in doing adhoc queries against >DB2 data on the mainframe (OS/390). They have used Access through a DB2 >Connect gateway, but have complained about the speed of queries. > >Has anyone used a different adhoc query product that has worked well? > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage at [...] 24431 148 26_Re: Moving to data sharing0_22_rob.crane@PLATINUM.COM31_Wed, 17 Nov 1999 12:46:42 -0600353_us-ascii As several people have mentioned you can not automagically merge DSNDB01 and DSNDB06. You can however get this accomplished in a round about way.

Here is the basic idea:

source --> subsystem you want to move target --> subsystem where you are merging to.

1) Being cautious, do a full image copy of the source objects. [...] 24580 172 26_Re: Moving to data sharing10_DB2 Review21_db2review@HOTMAIL.COM29_Wed, 17 Nov 1999 13:53:57 EST617_- Is there a tool available which with migrate DDL and data to the UDB NT platform ?

THX JAL



>From: rob.crane@PLATINUM.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Moving to data sharing >Date: Wed, 17 Nov 1999 12:46:42 -0600 > >As several people have mentioned you can not >automagically merge DSNDB01 and DSNDB06. You can >however get this accomplished in a round about way. > >Here is the basic idea: > >source --> subsystem you want to move >target --> subsystem where you are merging to. > >1) Being cautious, do a full image copy of [...] 24753 58 41_Re: Adhoc query tools for OS/390 DB2 data13_Ashwini Kumar22_Ashwini.Kumar@SLMA.COM31_Wed, 17 Nov 1999 14:00:58 -0500450_us-ascii Check out tools like DOLAP/Business Intelligence tools like Brio, Business Object, etc. They provide OLAP functionality, what if type of analysis, multi-dimensional analysis,drag and drop type features, a lot more for the money and very easy to use....

Ashwini Kumar







DB2 Review on 11/17/99 01:37:22 PM

Please respond to DB2 Data Base Discussion List [...] 24812 52 41_Re: Adhoc query tools for OS/390 DB2 data12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Wed, 17 Nov 1999 13:02:23 -0600435_iso-8859-1 We have been using QMF running under CICS since 1996. In June of this year we implemented QMF for Windows. Our customers are extremely happy with it. Response time is impressive and they use the QMF add-ins for MS Access and Excel to download data locally. They are running queries against a DB2 data warehouse with more than 60 tables. Some tables have millions of rows of data. We use the CPIC connection to DB2/390. [...] 24865 36 41_Re: Adhoc query tools for OS/390 DB2 data11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 17 Nov 1999 11:02:52 PST659_- You have probably already considered this basic issue: Have you verified the access path (index usage, etc) with explain on the sql statements in question? The "speed" may be due to typical access path issues rather than the query tool.



>From: Paul Turpin >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Adhoc query tools for OS/390 DB2 data >Date: Wed, 17 Nov 1999 12:24:37 -0800 > >I have a customer who is interested in doing adhoc queries against >DB2 data on the mainframe (OS/390). They have used Access through a DB2 >Connect gateway, but have complained about [...] 24902 207 26_Re: Moving to data sharing0_22_BILL_GALLAGHER@PHL.COM31_Wed, 17 Nov 1999 14:07:34 -0500289_us-ascii From UDB, you should be able to connect to your DB2/OS390 host, and export the tables you want to move to UDB in IXF format. Then FTP the IXF files to NT, and do an import in CREATE mode. This will create the table and indexes, as well as populate it with the exported data. [...] 25110 148 35_Re: REXX Pgm to return SQLCODE desc15_Lentine Chuck O26_Chuck.O.Lentine@M1.IRS.GOV31_Wed, 17 Nov 1999 14:10:17 -0500698_iso-8859-1 Thanks Paul. Your tool is going to come in handy.

Chuck Lentine

-----Original Message----- From: Paul Fletcher [mailto:Paul_L_Fletcher@BISCUITS.COM] Sent: Wednesday, November 17, 1999 3:48 AM To: DB2-L@RYCI.COM Subject: Re: REXX Pgm to return SQLCODE desc



Anil,

here is a REXX I have written to show a description of an SQLCODE.

/* REXX */ ARG SQLCODE SQLC = D2X(SQLCODE,8) SQLC = X2C(SQLC) SQLCA = 'SQLCA 'X2C(00000088)SQLC||X2C(0000)||COPIES(' ',78) SQLCA = SQLCA||COPIES(X2C(00),24)COPIES(' ',16) TIAR_MSG = X2C(0190)COPIES(' ',400) TEXT_LEN = X2C(00000050) ADDRESS ATTCHPGM 'DSNTIAR SQLCA TIAR_MSG TEXT_LEN' SAY SUBSTR(TIAR_MSG,4,400) [...] 25259 13 41_Re: Adhoc query tools for OS/390 DB2 data12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Wed, 17 Nov 1999 13:40:46 -0600404_us-ascii Used just plain QMF. But like anything you run the risk of some user querying the world and when he gets no response he goes home and it's still running.

================================================ 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. 25273 26 24_UDB on Linux and netstat15_David Partridge22_dpartridge@METLIFE.COM31_Wed, 17 Nov 1999 13:34:19 -0800472_- Hi everyone,

I have just installed UDB on Linux. I have made an entry in the /etc/services file and modified the service name in the dbm cfg. I have stopped and started UDB and even recycled the machine. Yet, when I do a netstat, I can't find any mention of the UDB listener. Is there something additional that I need to do? I can connect to UDB with the command line processor. Additionally, I can see an entry for the db2as listener in the netstat output. [...] 25300 149 37_Re: Distributed threads holding locks22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM31_Wed, 17 Nov 1999 15:01:40 -0500718_iso-8859-1 I got this from William Satkowski. I believe it was intended for db2-l so I'm forwarding to db2-l.



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

> ---------- > From: Satkowski, William[SMTP:wsatkowski@csw.com] > Sent: Wednesday, November 17, 1999 2:54 PM > To: Piontkowski Michael ML > Subject: RE: Distributed threads holding locks > > Does anyone use oracle/sqlnet to access DB2? It has the same problems > with > hung threads and I'd like to know if anyone has a solution. > > ---------- > From: Piontkowski Michael ML > [SMTP:michael.piontkowski@ZCSWILM.ZENECA.COM] > Sent: Wednesday, November 17, 1999 10:09 AM > To: DB2-L@RYCI.COM > [...] 25450 34 42_DB2 System Administrator contractor needed13_Beth Roddy-EC15_roddy.ec@PG.COM31_Wed, 17 Nov 1999 14:54:08 -0500631_us-ascii Hi!

We are looking for an experienced DB2 System Administrator contractor. If you are interested please reply to me DIRECTLY, not to the listserve.

The requirements are the following: DB2 Contractor Key Tasks: 1. DB2 System Administrator training - willing to do training & knowledge transfer 2. Assistance with DB2 V6 upgrade Timing: 6 months, beginning between 12/1/99-2/1/2000 Location: Cincinnati, OH Travel required: No Key skills: practical experience in the system administration of DB2, willing to train Pager: contractor to carry the DB2 pager - 1 week out of every 4 weeks, very minimal pages [...] 25485 22 41_Re: Adhoc query tools for OS/390 DB2 data13_Helen Johnson25_Helen_Johnson@RAC.RAY.COM31_Wed, 17 Nov 1999 14:11:45 -0600375_us-ascii We use QMF also with good results. We don't have a problem with long running queries locking out online transactions. We run an OPS rule that 'sees' that a QMF query is in contention with an online and simply cancel the TSO userid. Not elegant, but the users know that that is the cost of querying the online systems. They must be avail for the online systems. [...] 25508 91 37_Re: Distributed threads holding locks12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 17 Nov 1999 12:24:08 -0800304_us-ascii In addition to the setting of Inactive threads which is very important to the management of threads, you can get DB2 aware of Terminated threads more quickly with the TCPIP KEEPALIVE parm. IBM is recommending that this parm be set to about 3-5 minutes. I think that the default is 2 hours. [...] 25600 88 42_Re: DB2 Connect - Thin client installation11_Robert Hall25_robert.hall@OCC.TREAS.GOV29_Wed, 17 Nov 1999 13:16:36 EST591_us-ascii Robert,

I haven't used SMS to perform the installs, but....

What version of DB2 Connect are you installing? The RSP files are different for version 5 and 6 (and version 5 RSP wouldn't work for me with V6). Be sure to change the type parameter to type=2 (custom install) in the RSP file. Also, if you are creating your own CD for the install, make sure the RSP file is in the DB2\WINNT95\COMMON directory or you explicity point to the location of the RSP file (for Windows anyway, you didn't say what platform you were running on)....otherwise the install program [...] 25689 49 32_APAR for DB2 Timestamp on OS/3908_Peter Yu14_peyu@BTMNA.COM31_Wed, 17 Nov 1999 16:01:57 -0500395_us-ascii We recently picked up an APAR PQ10568 that is now classified as Y2K item which affects the calculation using DB2 timestamp. Since we did not detect this Y2K APAR in March this year, we are wondering whether we should apply this APAR because it does not seem to be Y2K related; the calculation is wrong now and it will be wrong next year also if 24 hour is specified for timestamp. [...] 25739 19 36_Moving images between Oracle and UDB12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Wed, 17 Nov 1999 15:11:49 -0600293_iso-8859-1 We are in the process of outsourcing the creation of our product catalog -- the company uses Oracle and would like to FTP back to us each night the changed images (JPEG's) that are stored in Oracle so we can load them back into UDB as BLOBs -- anyone doing anything like this? [...] 25759 72 76_Re: ATTN: Dan Courter >>> Waiting for DB2 Services (attn - Jim Lewandowski )14_Max 'Guderian'16_mocion@LIBERO.IT31_Wed, 17 Nov 1999 21:58:12 +0100390_iso-8859-1 >>>> First of all, thanks for the answer. <<<< :-))

Now some detail.

****** How are you defining "page-ins" (via SDSF paging field on top line, or ****** paging for the individual address space and/or DBM1 itself)?

I measured DB2 DBM1 page-ins via SDSF and via B&B monitor, at DB2 (MainView for DB2) and MVS (MainView for MVS) level. Very few page-out. [...] 25832 101 36_Re: APAR for DB2 Timestamp on OS/39014_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Wed, 17 Nov 1999 16:27:43 -0500351_us-ascii It certainly makes no sense at all, and I'd be surprised (and appalled) if it turned out to be ISO. The range of times of day is 0<=x<24.

If DB2 accepts 24:00 as a valid time, it's a bug. If IBM says it's documented, then it's a typical IBM broken-as-designed bug. I'm very curious to hear what anyone else has to say about this. [...] 25934 29 23_OLE DB provider for DB212_Ramana Nunna29_Ramana.Nunna@MAIL.STATE.AR.US31_Wed, 17 Nov 1999 15:20:36 -0600551_- Hi all!

I am trying to establish connection between SNA server version 4 servicepack 2 on windows NT server version 4.0 with the OS/390 DB2 database.Defintions in VTAM has been defined as a switched connection with PU type 2.1 and a dependent LU and the logmode is 'D4C32772'.SNA server side is also configured as in the VTAM definitions. When i try to test between LU to LU ,I am getting a communication failure error over the SNA server side and connection established with the PU in the mainframe logs but no messages seen on the LU. [...] 25964 132 35_Re: REXX Pgm to return SQLCODE desc11_Daryl Wells18_dwwell1@US.IBM.COM31_Wed, 17 Nov 1999 17:30:16 -0500400_us-ascii



This will only if the SQL CA is not a different format. Such as other ISPF panels using RXSQL. If you call from COBOL or other application, the ca will be standardized (but still depends on the environment).

Also, most times can use "CALL" instead of "ADDRESS ATTCHPGM".





Lentine Chuck O on 11/17/99 02:10:17 PM [...] 26097 12 22_Recall: Christmas poem14_Johnson, Tracy22_TJohnson@GUIDEMAIL.COM31_Wed, 17 Nov 1999 17:36:53 -0600310_- Johnson, Tracy would like to recall the message, "Christmas poem".

================================================ 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. 26110 13 9_Apologies14_Johnson, Tracy22_TJohnson@GUIDEMAIL.COM31_Wed, 17 Nov 1999 17:41:05 -0600354_iso-8859-1 My deepest apologies....my last message sent was totally by accident. I hope I did not offend anyone!

================================================ 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. 26124 64 47_24:00:00 - was APAR for DB2 Timestamp on OS/39014_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Thu, 18 Nov 1999 11:55:48 +1000593_us-ascii Harvey,

I disagee - I believe 24:00:00 is, and SHOULD be, a valid time. After all, you mentioned being taught that "the day ends at 12:00 PM, which is midnight[.]"

I suspect that your problem arises because you are getting the effects of ordinal numbering (first, second, etc) confused with cardinal numbering (zero, one, etc). Time uses cardinal numbering. 24:00:00 means "24 hours, zero minutes, zero seconds since the start of the day" rather than "part of the 24th hour". Claiming that it is not part of the day whose end it marks, is to claim that that day is [...] 26189 164 36_Re: APAR for DB2 Timestamp on OS/3900_29_Greg.Palgrave@BANKWEST.COM.AU31_Thu, 18 Nov 1999 10:18:16 +0800395_us-ascii Harvey,

DB2 has allowed the 24.00.00 time value since at least V2.1 (when I first touched it), and I'm pretty sure it has always been there since V1.whatever. It's not a bug, even if it's confusing....

1999-11-18-24.00.00.00 to me indicates midnight between 18th and 19th November

1999-11-18-00.00.00.00 to me indicates midnight between 17th and 18th November [...] 26354 69 28_Re: UDB on Linux and netstat13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Wed, 17 Nov 1999 23:45:38 CST580_- run the following commands: -db2set DB2COMM=TCPIP -db2stop -db2start -ps -ef |grep db2tcp

You should see 2 processes ... db2tcpim and db2tcpcm under the instance owner (these are the listerner processes -- interrupt and connect). Once these process are running than your db2 server is ready for client connectivity.

regards, Umair Hussain******************************** DBA Consultant * DB2 UDB, Oracle, Sybase, DataJoiner * IBM Certified Solution Expert - DB2 UDB DBA * IBM Certified AIX System Administrator * ********|All Disclaimers Apply|************** [...] 26424 109 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/3900_18_mebert@AMADEUS.NET31_Thu, 18 Nov 1999 09:34:02 +0100538_us-ascii James,

I have to disagree with THAT. 24:00:00 is NOT a valid time. A day is 86.400 seconds long, and the first second is not second 1, it's 0 (00:00:00) so second #86.400 is 23:59:59 (try it). This is a different case from years, which "start" with A.D. 1. There's no year 0. So the two cases are different. For years, the numbering is from 1 to n; for times, it's from 0 to (n-1). The "day ends at 12:00 PM" only in the US, which in the matter of measurements generally is in a pre-18th century states (as Europeans [...] 26534 41 35_Workload Balancing over DB2 Connect0_20_vpacheco@AMADEUS.NET31_Thu, 18 Nov 1999 09:49:26 +0100567_us-ascii Dear all

We are running distributed connections over DB2 Connect (NT, version 6.1) to access DB2 on OS/390. We use APPC (LU 6.2) from the DB2 Connect to the DB2/390 and TCP/IP from the CAE to DB2 Connect. We are about to put in Production a new application that requires high availability and the responsible are not so satisfied to have the current design with only one gateway - a single point of failure. Hence we have decided to build a second DB2 Connect gateway - same platform - to act as alternative in case we experience problems on the [...] 26576 29 19_Preformatting Pages13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Thu, 18 Nov 1999 11:53:18 +0000586_us-ascii The PREFORMAT option of the LOAD utility will preformat pages of a tablespace.

I have a new application which is heavily inserting, both in online IMS transactions and in the overnight batch. The only other activity on the table is some query reporting (there are no updates or deletes).

Is there any mileage in running a load job before releasing the system for use with the PREFORMAT option ? What is the % expected benefits ? Would it also be worth doing an UNLOAD and LOAD of the table periodically with the PREFORMAT option (say instead of a reorg once [...] 26606 39 23_Indexes on foreign keys14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 18 Nov 1999 12:22:12 +0100497_us-ascii Hello everyone out there,

I have a simple question concerning indexes on foreign keys; as a rule we create indexes on foreign keys, no matter what; now we do have parent tables with not more than, say, 100 rows, sometimes just 1 row, whereas the dependent table has several millions of rows. We do feel inclined to simply drop the indexes on those foreign keys because we feel they are not of much use. Are we wrong or/and could someone please shed some light on that matter. [...] 26646 129 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39020_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Thu, 18 Nov 1999 11:45:08 -0000641_iso-8859-1 Michael. I agree - though you forgot to mention their Mars probe.

-----Original Message----- From: mebert@AMADEUS.NET [mailto:mebert@AMADEUS.NET] Sent: 18 November 1999 08:34 To: DB2-L@RYCI.COM Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390



James,

I have to disagree with THAT. 24:00:00 is NOT a valid time. A day is 86.400 seconds long, and the first second is not second 1, it's 0 (00:00:00) so second #86.400 is 23:59:59 (try it). This is a different case from years, which "start" with A.D. 1. There's no year 0. So the two cases are different. For years, the numbering is from [...] 26776 117 51_Re: DB2 v5 (OS/390) talking to UDB v6 (AIX) - Help!13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 18 Nov 1999 07:47:24 -0500587_- Once you bind the spufi package, DSNESPCS, to the AIX UDB and grant execute on the package in UDB and grant whatever table authorities you want, i.e. SELECT, UPDATE, etc. in UDB, then in SPUFI on line 10 of the panel, specify the connection location, in this case, SAMPLE.

> -----Original Message----- > From: Jim Jones [SMTP:jim.jones@INGRAMENTERTAINMENT.COM] > Sent: Tuesday, November 16, 1999 6:44 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 v5 (OS/390) talking to UDB v6 (AIX) - Help! > > Bill, > > From Spufi you can't code three part names to an SQL database from DB2 [...] 26894 46 49_Re: Benchmark between MS SQL Server and UDB on NT13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 18 Nov 1999 07:51:01 -0500576_- I just confirmed from some who got to attend the conference that the presentation is not on the CD. Does anyone have similar info to this presentation as I need it too?

Thanks!

> -----Original Message----- > From: Steve Mazer [SMTP:smazer@FMTUSA.COM] > Sent: Wednesday, November 10, 1999 9:51 AM > To: DB2-L@RYCI.COM > Subject: Re: Benchmark between MS SQL Server and UDB on NT > > Paul, > Check out the presentation that Richard Yevich did at this year's DB2 Tech > Conference, titled DB2 UDB 5.2 vs MS SQL Server 7.0 > > Regards, > Steve Mazer > Fourth [...] 26941 53 23_Re: Preformatting Pages0_19_mike.holmans@BT.COM31_Thu, 18 Nov 1999 12:53:13 -0000637_- I can't speak to the benefits of preformatting, but there's no need to do an UNLOAD and LOAD rather than a REORG to get preformatting, because APAR PQ03652 added PREFORMAT as a REORG parameter as well.

Mike Holmans BT ISE Technical Design mike.holmans@bt.com

> -----Original Message----- > From: Philip Nelson [SMTP:teamdba@ATTGLOBAL.NET] > Sent: Thursday, November 18, 1999 11:53 AM > To: DB2-L@RYCI.COM > Subject: Preformatting Pages > > The PREFORMAT option of the LOAD utility will preformat pages of a > tablespace. > > I have a new application which is heavily inserting, both in online IMS > transactions and [...] 26995 160 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/3900_18_mebert@AMADEUS.NET31_Thu, 18 Nov 1999 14:04:49 +0100560_us-ascii Sorry, I haven't had my coffee yet, and I don't get it - what do you mean? ME.





From: "Beighton-Dykes, Hugh" on 18/11/99 11:45 GMT





Please respond to DB2 Data Base Discussion List



To: DB2-L@RYCI.COM



cc: (bcc: Michael Ebert/MUC/AMADEUS)







Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390







Michael. I agree - though you forgot to mention their Mars probe. [...] 27156 30 29_DB2/OAM & On-Demand Software?16_Charles Valentin15_VALENCH@AOL.COM29_Thu, 18 Nov 1999 08:20:06 EST678_us-ascii Hi DB2 Group, Our shop is currently embarking on a "new" project which uses IBM/OAM and On-Demand Software. As part of installation in "test", DB2 Systems Group had to define several D/B's, T/S' & I/X's, etc. for Object Storage Databases, Optical Configuration D/B & Object Administration D/B's. The On-Demand Software also requires definition of additional DB2 D/B resources (which we haven't installed yet). Question: Does anyone out there have any positive/negative experiences with this software? For OAM, are the DB2 resources mentioned above normally created & maintained (bkup/recovery/reorgs) by DB2 Systems Group "or" by DBA Group? Has anyone noticed any [...] 27187 112 65_FW: Will DB2 use other index if it can match on the primary key ?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 18 Nov 1999 00:16:06 +1000418_us-ascii Pre V5, DB2 would not consider any other index if full equals match on a unique index. Note however if 2 indexes were full equals matched, it could consider both of them.

In V5, DB2 will consider other indexes, such as 'Index Only' possibilities but not guaranteed to use them.

To get around the problem pre V5 I recommend change last matching column equals predicate from: AND col = value [...] 27300 57 49_Re: Benchmark between MS SQL Server and UDB on NT14_Chris Cronrath18_CCronrath@NESL.COM31_Thu, 18 Nov 1999 08:33:04 -0500381_- If anyone has any similar info could you please point me to it. The only stuff I have found so far is marketing material from both IBM and Mircrosoft and both, of course, say they are the fastest. What I need is some kind of proof. I want to be able to use DB2 but sadly my company has a Microsoft bias and I have to prove DB2 is faster. Any documentation would be helpful. [...] 27358 78 27_Re: Indexes on foreign keys14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 18 Nov 1999 00:51:07 +1000401_us-ascii Ruediger,

Firstly you must determine how many indexes you can afford and whether each index provides enough benefit to outweigh the cost.

Very small tables can have all the indexes you like with little or no penalty unless extremely dynamic.

Tables over 100 million rows might be unmanageable with any more than 1 index (partitoning, unique, clustering all in one). [...] 27437 18 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39013_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 18 Nov 1999 09:05:47 -0500372_iso-8859-1 I believe he means that we dumb yankees in addition to having confusing old-world time-keeping attitudes should be ashamed we are not yet using the metric system of measurement(which apparently was the cause for the crash of the Mars probe recently(engineers from one team sent measurements in miles and the other team neglected to convert to kilometers). [...] 27456 46 33_Re: DB2/OAM & On-Demand Software?15_Zander, Barb J.19_bzander@STATE.ND.US31_Thu, 18 Nov 1999 08:12:23 -0600715_iso-8859-1 We use both of these products. The backup/recovery etc are handled by the systems group. We have not had any problems with it.

Barb.

-----Original Message----- From: Charles Valentin [mailto:VALENCH@AOL.COM] Sent: Thursday, November 18, 1999 7:20 AM To: DB2-L@RYCI.COM Subject: DB2/OAM & On-Demand Software?



Hi DB2 Group, Our shop is currently embarking on a "new" project which uses IBM/OAM and On-Demand Software. As part of installation in "test", DB2 Systems Group had to define several D/B's, T/S' & I/X's, etc. for Object Storage Databases, Optical Configuration D/B & Object Administration D/B's. The On-Demand Software also requires definition of additional DB2 [...] 27503 74 23_Re: Preformatting Pages0_18_damcon2@US.IBM.COM31_Thu, 18 Nov 1999 09:13:02 -0500397_us-ascii Philip,

As an alternative, you might want to consider using the load utility to actually "load resume" the data instead of doing massive inserts for the batch application. That is, as long as it won't cause contention with the on-line transactions. If there is contention you could partition the table or split the table in two. But, this may be more trouble than it's worth. [...] 27578 80 39_Re: Workload Balancing over DB2 Connect9_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM31_Thu, 18 Nov 1999 08:29:51 -0800460_us-ascii Victor,

An alternative to multiple gateways and workload balancing is to use DB2 Connect PE with TCP/IP access to DB2 OS/390 V5. We slowly phased out our DB2 Connect gateway machine, first using direct client connection to DB2 OS/390 and now we have a mixture of DB2 Connect 5.2 and 6.1 clients talking to DB2 OS/390 without a gateway. It does require Open Edition for DB2 TCP/IP support, but we're on OS/390 2.5 so that is not a problem. [...] 27659 49 33_Re: DB2/OAM & On-Demand Software?12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Thu, 18 Nov 1999 09:28:51 -0500472_windows-1252 With a previous employer, I worked with these products. DBAs generally handled image copies, reorgs, etc., while systems folks worked on OAM itself. Before I inherited the project, other DBAs had tuned the indexes and set up partitioning. Since I wasn't involved with that effort, I don't remember the details, but I believe that they both added new indexes and removed unneeded ones. I know that those changes made a world of difference in performance. [...] 27709 144 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39012_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Thu, 18 Nov 1999 08:36:54 -0600441_us-ascii This is most likely an "as designed bug." It is unfortunate that it seems to excite such cultural bias. I have done a lot of business across Europe and it is news to me that the business day ends at 12 noon. (Some educated US Citizens do use 12 noon for science, but I believe they went abroad for their educations.) We must thank Dr. Ebert for this enlightenment. Does Europe celebrate the new year at 12 noon or at midnight? [...] 27854 18 33_Re: DB2/OAM & On-Demand Software?0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 18 Nov 1999 09:38:18 -0500383_us-ascii Charles,

We use OAM and ONDEMAND. Please contact me directly to discuss. (too much to put in an email)

Ed 703.255.7909

================================================ 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. 27873 184 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39020_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 18 Nov 1999 09:44:40 -0500583_iso-8859-1 Also not to forget that European space agency had similar error years ago when they tried using American FPS data but forgot to convert to ISO leading to failure of their mission.

> -----Original Message----- > From: Gerald Hodge [SMTP:ghodge@ATTGLOBAL.NET] > Sent: Thursday, November 18, 1999 9:37 AM > To: DB2-L@RYCI.COM > Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390 > > This is most likely an "as designed bug." It is unfortunate that it seems > to excite such cultural bias. I have done a lot of business across Europe > and it is news to [...] 28058 178 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39024_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Thu, 18 Nov 1999 08:45:49 -0800392_us-ascii Gerald, The answer to your root (are you working on Unix now?) question is that '1999-11-18-00:00:00.000000' and '1999-11-17-24:00:00.000000' would appear to be one moment in time - cue Whitney Houston - but the comparison of these two values in DB2 will render an inequality.

Warmest regards, Frank



On Thu, 18 Nov 1999 08:36:54 -0600, Gerald Hodge wrote: [...] 28237 87 33_Re: DB2/OAM & On-Demand Software?12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 18 Nov 1999 08:52:18 -0600626_us-ascii Hi Charles, I am the Systems person here for DB2. The Optical Storage and Object Admin tables you speak of belong to OAM (Object Access Method. This is a component of DFSMS, part of the operating system, so our systems people have responsibility for creating and maintaining these DB2 objects. OnDemand is a little different animal. Since it is a vendor application, even though it comes from IBM, the DBA group has been given responsibility for maintenance of those tables (backup and reorg). However, since it required extensive integration with OAM, the systems group installed the initial release (back then [...] 28325 188 36_Re: APAR for DB2 Timestamp on OS/3908_Peter Yu14_peyu@BTMNA.COM31_Thu, 18 Nov 1999 10:01:20 -0500535_us-ascii Harvey,

I have been looking at IBM DB2 manual and it turns out that allowing two different values for midnight is fully documented in SQL Reference (page 76 for V6.1 OS/390, page 55 for V4.1 MVS) and IBM claims it is ISO format of the 24-hour clock. This makes me more concern about midnight on 12/31/1999 since I predict there are some computer systems that try to have logic to avoid or perform some additional thing at midnight of this year end since this time is so special and the result is so unpredictable. [...] 28514 158 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39013_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Thu, 18 Nov 1999 15:39:00 -0000387_iso-8859-1 Folks this is of course how the Romans ovecame the millenium bug in the year 0.

They didn't have a year zero!!!

So when their sundials, or is it moondials, ticked over midnight in 1 BC it went straight to 1 AD!!!

The abacii didn't fail, the triremes didn't sink and the Cisterse went up 4% against the British Groat on the Athens stock exchange!!!!! [...] 28673 22 39_Re: Workload Balancing over DB2 Connect15_Filip Van Parys24_filip.vanparys@SIDMAR.BE31_Thu, 18 Nov 1999 09:50:17 -0800557_- we have the following configuration : CAE clients on Windows NT, two DB2 connect gateways on Windows NT, DB2 v5 for OS/390, all connecting thru TCP/IP. We perform some balancing between the two gateways with a feature of our DNS server, named 'ROUND ROBIN'. In the DSN the two gateways are defined having the same logical hostname. To resolve the IP address the DNS server picks one IP number out of a pool of IP numbers. In this case we have two IP numbers and with every request to resolve the hostname the DNS server switches between these two. I [...] 28696 74 28_Re: Waiting for DB2 Services12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Thu, 18 Nov 1999 08:13:22 PST557_- Dan:

I suggest if you want to do this kind of activity you've got to use one monitor with the capability to give you online and batch information that could help you with it. In our shop , we've got Activity Monitor and trough their reports we can research more deeply when it needed. Talking about db2 wait times in the acounting report in class three you can see all the acumulated wait time for db2 events. If you want to find out more about it you can get useful information in the Adminitration Guide Chapter 5 (Perfomance Monitoring and [...] 28771 30 31_What can we use as a "trigger?"15_Ludovici, Jim R35_Jim.R.Ludovici@QUESTDIAGNOSTICS.COM31_Thu, 18 Nov 1999 11:43:06 -0500376_- Our programmers would like the database to take care of updating a column value on an insert to a table. Basically, the rule would be,at insert set Col X of row n = Col A of row n, if Col X is spaces. This should be accomplished with no code changes in the application programs. A function easily executed by a "trigger" in a client server environment, such as Sybase. [...] 28802 91 39_Re: Workload Balancing over DB2 Connect0_20_vpacheco@AMADEUS.NET31_Thu, 18 Nov 1999 18:01:29 +0100329_us-ascii Filip,

Thanks for your reply.

I have heard about this Round-Robin balancing and the concern is that in case of one of the gateways being down the balancing will continue to ditribute workload over that gateway, hence this process does not meat the primary objective that is the backup of the gateway. [...] 28894 116 49_SV: Benchmark between MS SQL Server and UDB on NT25_Heidorn Sven IT Sundsvall19_Sven.Heidorn@CSN.SE31_Thu, 18 Nov 1999 18:10:31 +0100584_iso-8859-1 Chris,

TPC publishes all results on the web, I can't remember the URL though.

Sven Heidorn

> -----Ursprungligt meddelande----- > Från: Chris Cronrath [SMTP:CCronrath@NESL.COM] > Skickat: den 18 november 1999 14:33 > Till: DB2-L@RYCI.COM > Ämne: Re: Benchmark between MS SQL Server and UDB on NT > > If anyone has any similar info could you please point me to it. The only > stuff I have found so far is marketing material from both IBM and > Mircrosoft and both, of course, say they are the fastest. What I need is > some kind of proof. I want to [...] 29011 95 28_Re: UDB on Linux and netstat15_David Partridge22_dpartridge@METLIFE.COM31_Thu, 18 Nov 1999 12:06:37 -0500338_us-ascii Umair,

Thanks for your assistance.

I performed the steps you mentioned. I see one of the 2 processes, db2tcpcm. However, there is no db2tcpim. I do have an entry in /etc/services for the interrupt port. Is there something else I need to do?

If you need me to send you additional info, just let me know. [...] 29107 18 18_DB2 Float Datatype16_Amy C. Whitehead14_B06ACW@FDS.COM31_Thu, 18 Nov 1999 12:17:24 -0500480_us-ascii I have question about using the FLOAT datatype. I looked in for the answers, but could not find them. What is the difference in precison and double precision in relationship to FLOAT? What is the difference in COMP,COMP -4, COMP-3, OMP-2, COMP-1? What are the performance issues with using FLOAT? What are your suggestions for using FLOAT versus DECIMAL? I understand that you should choose smallint, integer,decimal,then REAL or FLOAT, but I do not understand why. [...] 29126 17 35_DB2 Performance questions for OS39016_Amy C. Whitehead14_B06ACW@FDS.COM31_Thu, 18 Nov 1999 12:18:58 -0500489_us-ascii With the monitor we use (TMON), some of the time DB2 spends on behalf of an application is charged to that application. How then do I determine total CPU time for DB2? How is the breakout to the applications determined?

Thanks, Amy

================================================ 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. 29144 98 49_Re: Benchmark between MS SQL Server and UDB on NT18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Thu, 18 Nov 1999 11:27:52 -0600632_iso-8859-1 Chris, Go to this url: http://www-4.ibm.com/software/data/db2/benchmarks/ HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 29243 18 49_Re: Benchmark between MS SQL Server and UDB on NT13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 18 Nov 1999 12:31:56 -0500442_iso-8859-1 >TPC publishes all results on the web, I can't remember the URL though

It's www.tpc.org

David Seibert Compuware Corporation File-AID product planner 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. 29262 209 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/3900_19_mike.holmans@BT.COM31_Thu, 18 Nov 1999 17:18:46 -0000536_iso-8859-1 Oh wotthehell, I guess I'll leap on this one.

What seems wrong to me is *insisting* that midnight *is* 24:00:00 or *is* 00:00:00, and that it can't be the other. As far as I can see, they are alternate designations of the same thing, like 32 deg F and 0 deg C. For some applications, it is logical to construe midnight at the end of a day as 24:00:00, and for others it makes more logical sense to refer to the day beginning at 00:00:00. As long as DB2 can recognise that both are valid and identical in terms of [...] 29472 59 16_Uncommitted Read16_Michael McMorrow25_michael.g.mcmorrow@AIB.IE31_Thu, 18 Nov 1999 17:52:47 -0000457_ISO-8859-1 Hi,

A general question about 'Uncommitted Read'.

We (DB2 V4) use this VERY sparingly to avoid data integrity exposure.

However we have two heavily competing batch suites (SuiteA and SuiteB) and decided to use Uncommitted Read for a couple of long running Cursors (30-40 minutes) in SuiteA in the absolute knowledge that the only Update/Insert/Delete activity in SuiteB can be Update of columns of no interest to SuiteA. [...] 29532 214 36_Re: APAR for DB2 Timestamp on OS/39014_O'Conner, John26_john.oconner@COURTS.WA.GOV31_Thu, 18 Nov 1999 10:03:42 -0800864_iso-8859-1 Greg,

I modified your example slightly to show that DB2 ignores the time "24.00.00" in its calculations (the only exception I know of is where adding 24 hours to 00.00.00 results in 24.00.00).

SELECT TIMESTAMP('1999-11-17-23.59.59.999999') + 1 MICROSECOND , TIMESTAMP('1999-11-18-00.00.00.000000') - 1 MICROSECOND FROM SYSIBM.SYSDUMMY1 ; ---------+---------+---------+---------+---------+---------+--- 1999-11-18-00.00.00.000000 1999-11-17-23.59.59.999999 ---------+---------+---------+---------+---------+---------+---

SELECT CHAR(TIME('01:23:45') + 24 HOURS, ISO) , CHAR(TIME('00:00:00') + 24 HOURS, ISO) , CHAR(TIME('24:00:00') + 24 HOURS, ISO) FROM SYSIBM.SYSDUMMY1 ; ---------+---------+---------+---------+---------+---------+--- 01.23.45 24.00.00 24.00.00 ---------+---------+---------+---------+---------+---------+--- [...] 29747 57 39_Re: DB2 Performance questions for OS3909_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM31_Thu, 18 Nov 1999 12:33:38 -0800496_us-ascii Hi Amy,

DB2 CPU time for the application TCB is charged back to the application, other TCB used on behalf of an application like async reads, write engine etc. are charged to DB2 address spaces. To get a rough idea, you can obviously add the application CPU to DB2 CPU, but total DB2 time will be less if the application does other "stuff". To be accurate you have to process SMF records, type 100 - 102. I haven't seen them in a long time but TMON will produce the reports. [...] 29805 23 65_DB2 Connect and Business Objects and DB2 for OS/390 - cancelling?17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Thu, 18 Nov 1999 12:46:31 -0600513_koi8-r This may have already been addressed but I ask that you bear with me.

Can a BO query via DB2 Connect to DB2 for OS/390 have it's thread in DB2 cancelled by cancelling the query in BO?

Thanks,

:-)

Jerry Bustamente Lands' End 608-935-4815

================================================ 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. 29829 12 43_http://www-4.ibm.com/software/data/db2/ ???0_21_RompotK@SCHNEIDER.COM31_Thu, 18 Nov 1999 12:47:12 -0600311_us-ascii Can anyone access http://www-4.ibm.com/software/data/db2/???

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 29842 78 22_Re: DB2 Float Datatype0_19_Tim.Lowe@STPAUL.COM31_Thu, 18 Nov 1999 12:48:07 -0600465_us-ascii Amy, Maybe this will help a little:(?) SMALLINT 4 bytes Cobol PIC S9(4) COMP. Binary, values +/-32,767 (2 to the 15th) INTEGER 8 bytes Cobol PIC S9(9) COMP. Binary, values +/-2,147,483,646 (2 to the 31st) DECIMAL varies Cobol PIC S9(?) COMP-3. max length 31 (15 before DB2 V2R3) REAL 4 bytes Cobol PIC usage COMP-1. Single precision floatiing point 0.00000+00 FLOAT 8 bytes Cobol PIC usage COMP-2. Double precision floating point 0.000000000000000+00 [...] 29921 22 47_Re: http://www-4.ibm.com/software/data/db2/ ???14_Philip Trbovic19_TRBOVICP@BCBSIL.COM31_Thu, 18 Nov 1999 12:55:55 -0600636_US-ASCII Yes, with no problems.

>>> 11/18/1999 12:47:12 PM >>> Can anyone access http://www-4.ibm.com/software/data/db2/???

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.

===============================================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. 29944 25 33_DB2 for OS/390 and degree(any)...0_23_john.lantz@ZURICHUS.COM31_Thu, 18 Nov 1999 14:03:59 -0500599_us-ascii Watching a job in BMC's AppTune product, we came across some unexplained times. In this job, some packages were bound with DEGREE(ANY), and others were bound with DEGREE(1). Based on the SQL and looking at the EXPLAIN, DB2 was not doing any parallelism in any of the programs bound with DEGREE(ANY). When looking in APPTUNE, there is a category called "parallel groups" under the heading of I/O parallelism. There was a number here (like 1.7 million) that matched the number of SELECT's that the program did. There was also a significant amount of time in "other wait time" (about 30% [...] 29970 66 50_Re: DB2 Connect Performance - SNA connection LU6.230_Humphris,Richard,CNA Insurance24_Richard.Humphris@CNA.COM31_Thu, 18 Nov 1999 11:28:06 -0600457_- Reduce how many times it takes to transmit x bytes of data to your PC.

I beleive (a much simplified) formula for PC elapsed time is: PC elapsed time = "DB2 mainframe time" + network time where "db2 mainframe time" = qmf time = 25 minutes and where "network time" = (avg time for a 1-way communication between PC and mainframe) times 660,000 (fetches) times 2 (1way up; 1 way back) so "network time" = 6 hours minus 25 minutes = 20,100 seconds [...] 30037 25 28_Re: COBOL Pre_compiler error12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 18 Nov 1999 14:12:14 -0500425_iso-8859-1 Can someone tell me why the Pre-Compiler is flagging the following select with an error. The error is pointing to host variable, DCLSYSINDEXPART. The error message is: undefined or unusable host variable. The host variable is the group level name in the DCLGEN. We are running DB2 version 5.

EXEC SQL SELECT * INTO :DCLSYSINDEXPART FROM SYSIBM.SYSINDEXPART WHERE IXNAME-TEXT = :WS-DB2-TSNAME END-EXEC. [...] 30063 32 31_Looking for DB2 UDB opportunity15_Mohammed Nayeem21_db2udbxpert@YAHOO.COM31_Thu, 18 Nov 1999 11:18:30 -0800478_us-ascii Hi All

I am IBM certified DB2 UDB V5 Database Administrator, and I have obtained training from IBM: IBM DB2 UDB V 6.1 Administration Workshop on Windows NT and I have 6 year exp in DB2,CICS,COBOL,EASYTRIEVE PLUS. Is it possible to get DB2 UDB DBA job anywhere in U.S.A as per my experience and skills. I am looking for suitable position.My qualification is Bachelor of Engineering in Computer Science. If any one is interested then call me @ (612) 220-5121 [...] 30096 56 39_Re: DB2 Performance questions for OS39014_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 18 Nov 1999 14:23:44 -0500584_ISO-8859-1 In most cases, as a guideline, expect 95%+ of the cost to be charged to the application TCB for a TP environment. Jobs with heavy prefetch may be slightly less. If you are concerned about one job or application, there is no way you can know unless you ran a stand-alone benchmark of the job/application. The application data, as reported by TMON is from the SMF 101 data (or having gotten it thru IFI or control blocks), so this is only the application time/costs. However, since 'most' of the processing costs are charged to the application, this is usually adequate [...] 30153 35 31_DB2 Failover and Load Balancing14_Mitesh Damania24_mitesh_damania@YAHOO.COM31_Thu, 18 Nov 1999 11:16:42 -0800527_us-ascii I have the task of researching a failover system for our DB2 databases for our webstore.

We currently use one DB2 database on a Sun Solaris system with no failover system!

I have researched so far and found that Sun Clusters will solve our problem using 2 DB2 databases on 2 Sun Solaris machines. Unfortunately, the possible maximum distance between the two server machines is only 10km (Sun Cluster restriction). We need to have one database on the West Coast while the other is on the East Coast. [...] 30189 43 28_Re: COBOL Pre_compiler error9_Mark Ruhe15_MRuhe@QUEST.COM31_Thu, 18 Nov 1999 11:28:51 -0800342_iso-8859-1 Its been a long time since I wrote any COBOL but I don't believe you can read into a Group level name. The precompiler isn't smart enough to rewrite your SQL. You must specify each host variable. The group level name isn't really a host variable but is a name of a structure. I could be wrong but I have never seen this done. [...] 30233 39 28_Re: COBOL Pre_compiler error9_Mark Ruhe15_MRuhe@QUEST.COM31_Thu, 18 Nov 1999 11:31:28 -0800545_iso-8859-1 Spoke to soon. This can be done. Sorry.

-----Original Message----- From: Kalman, Jeff [mailto:JKalman@UNCH.UNC.EDU] Sent: Thursday, November 18, 1999 1:12 PM To: DB2-L@RYCI.COM Subject: Re: COBOL Pre_compiler error



Can someone tell me why the Pre-Compiler is flagging the following select with an error. The error is pointing to host variable, DCLSYSINDEXPART. The error message is: undefined or unusable host variable. The host variable is the group level name in the DCLGEN. We are running DB2 version 5. [...] 30273 37 47_Re: http://www-4.ibm.com/software/data/db2/ ???14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Thu, 18 Nov 1999 13:27:44 -0600721_us-ascii However, I can't, and I've had this problem on a regular basis.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Philip Trbovic Sent: Thursday, November 18, 1999 12:56 PM To: DB2-L@RYCI.COM Subject: Re: http://www-4.ibm.com/software/data/db2/ ???



Yes, with no problems.

>>> 11/18/1999 12:47:12 PM >>> Can anyone access http://www-4.ibm.com/software/data/db2/???

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...] 30311 26 47_Re: http://www-4.ibm.com/software/data/db2/ ???16_Sandkam, Stephen19_SSandkam@ESD.WA.GOV31_Thu, 18 Nov 1999 11:27:32 -0800588_iso-8859-1 Yes. I accessed it. It is a pretty good site.

-----Original Message----- From: RompotK@SCHNEIDER.COM [mailto:RompotK@SCHNEIDER.COM] Sent: Thursday, November 18, 1999 10:47 AM To: DB2-L@RYCI.COM Subject: http://www-4.ibm.com/software/data/db2/ ???



Can anyone access http://www-4.ibm.com/software/data/db2/???

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...] 30338 63 39_Re: DB2 Performance questions for OS39020_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 18 Nov 1999 14:34:23 -0500378_us-ascii To add few more points

- CPU time shown on SMF 101 or accounting trace does not show application cpu in CICS environment. It only shows attachment + in db2 cpu. In order to know application cpu using CICS smf records 110 subtype 1 or 2.

- Elapsed time shown in accounting record covers all the time (including application time) under db2 accounting. [...] 30402 61 39_Re: http://www-4.ibm.com/software/data/0_21_RompotK@SCHNEIDER.COM31_Thu, 18 Nov 1999 13:44:36 -0600451_us-ascii It's somewhat comforting to see that someone else is having this problem. I've got IBM consultants on site waiting for me to download the lastest version of SDK. Yet I can't get to the website. How ironic.







tmccomb@sedgw ick.gov To: Janet Kubsh/Schneider@Schneider, Kurt Rompot/Schneider@Schneider, DB2-L@DB2-L@RYCI.COM@SMTP@exchange 11/18/1999 cc: 01:27 PM Subject: Re: http://www-4.ibm.com/software/data/ [...] 30464 25 47_Re: http://www-4.ibm.com/software/data/db2/ ???16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Thu, 18 Nov 1999 12:49:57 -0700537_- yes

> -----Original Message----- > From: RompotK@SCHNEIDER.COM [SMTP:RompotK@SCHNEIDER.COM] > Sent: Thursday, November 18, 1999 11:47 AM > To: DB2-L@RYCI.COM > Subject: http://www-4.ibm.com/software/data/db2/ ??? > > Can anyone access http://www-4.ibm.com/software/data/db2/??? > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can > be reached at DB2-L-REQUEST@RYCI.COM. [...] 30490 79 39_Re: http://www-4.ibm.com/software/data/16_Sandkam, Stephen19_SSandkam@ESD.WA.GOV31_Thu, 18 Nov 1999 11:56:01 -0800557_iso-8859-1 This may sound dumb but how are you getting to the internet. I can access the site, do downloads, do searches, etc.

-----Original Message----- From: RompotK@SCHNEIDER.COM [mailto:RompotK@SCHNEIDER.COM] Sent: Thursday, November 18, 1999 11:45 AM To: DB2-L@RYCI.COM Subject: Re: http://www-4.ibm.com/software/data/



It's somewhat comforting to see that someone else is having this problem. I've got IBM consultants on site waiting for me to download the lastest version of SDK. Yet I can't get to the website. How ironic. [...] 30570 49 28_Re: COBOL Pre_compiler error14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 18 Nov 1999 14:57:41 -0500621_iso-8859-1 IXNAME-TEXT is not a column in SYSTABLEPART table. Did you mean to code IXNAME?

Manas.

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Kalman, Jeff > Sent: Thursday, November 18, 1999 2:12 PM > To: DB2-L@RYCI.COM > Subject: Re: COBOL Pre_compiler error > > > Can someone tell me why the Pre-Compiler is flagging the following select > with an error. The error is pointing to host variable, > DCLSYSINDEXPART. The > error message is: undefined or unusable host variable. The host > variable is > the group level name in the DCLGEN. We [...] 30620 31 10_SAP Reorgs12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Thu, 18 Nov 1999 14:31:10 -0600376_us-ascii We have been live for 10 months with SAP/R3. We have run a query to determine which tables need to be reorganized and only come up with one - moni - can anyone tell me why I don't see more activity with the other tables. We have grown about 4 million rows a month since the go live date and I would expect more tables to need reorg based on the following query: [...] 30652 66 35_Re: What can we use as a "trigger?"16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 18 Nov 1999 15:36:21 -0500331_iso-8859-1 You could use EDITPROC although it is a little overkill to do so. An INSERT Stored Procedure would be better but would require some program change. The EDITPROC does require some delicate ASM Language coding, and other issues. Strongly suggest using the SP approach and changing to TRIGGERS when you can get to V6. [...] 30719 83 49_Re: Benchmark between MS SQL Server and UDB on NT16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 18 Nov 1999 15:36:26 -0500695_iso-8859-1 Go to www.ryci.com/tech99 and download the pdf from there. Same as you would have received on the CD, except that it has been updated further, and will continually be updated. I will see that they post the update date on it there on the site.

Richard Yevich +=====+======+ Information Technology Consulting, Data Modeling, Advanced Education RYC® Inc. USA: 1-800-664-2421 Int'l: 1-305-361-8585 Fax: 1-512-476-3930 Web: Email: info@ryci.com Offices: USA and Europe DB2® Family and Oracle® Specialists - Parallel Technologies VLDB and Data Sharing Technologies (specialties SAP®, Peoplesoft®) Authors of "DB2 Answers" by Osborne-McGraw Hill, May, 1999 [...] 30803 54 14_Re: SAP Reorgs22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM31_Thu, 18 Nov 1999 16:01:56 -0500642_- When was the last time RUNSTATS was executed against the tablespaces, tables, indexes...?



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

> ---------- > From: Dan Sullivan[SMTP:daniel.sullivan@ZURICHUS.COM] > Sent: Thursday, November 18, 1999 3:31 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] SAP Reorgs > > We have been live for 10 months with SAP/R3. We have run a query to > determine > which tables need to be reorganized and only come up with one - moni - can > anyone tell me why I don't see more activity with the other tables. We > have > grown about 4 million rows a [...] 30858 12 14_Re: SAP Reorgs12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Thu, 18 Nov 1999 15:10:26 -0600273_us-ascii Runstats is run weekly

================================================ 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. 30871 19 19_Storage utilization16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Thu, 18 Nov 1999 14:56:26 -0700363_- On our Mainview for MVS monitor my test DB2 subsystem shows an allocation of 20K frames. There is no activity against this subsystem at the time we are looking at the monitor (using history view) but we are wondering why the storage is allocated and has not been "released" back to the system for use by any other jobs. Any clarification would be helpful. [...] 30891 45 69_Re: DB2 Connect and Business Objects and DB2 for OS/390 - cancelling?14_Danny S. Creed19_dscreed@FULLNET.NET31_Thu, 18 Nov 1999 17:21:42 -0600450_koi8-r Yes, it can. At least with CAE V5.2 and DB2 Connect V5R2. Don't know about before that. Make sure you set the interrupt_enabled parm on the db definition Regards Danny S. Creed

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Gerald Bustamente Sent: Thursday, November 18, 1999 12:47 PM To: DB2-L@RYCI.COM Subject: DB2 Connect and Business Objects and DB2 for OS/390 - cancelling? [...] 30937 157 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39014_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Fri, 19 Nov 1999 10:21:45 +1000589_us-ascii Michael,

As I said in my prior posting, I think there is confusion about the effects of things described using ordinal and cardinal numbers. Its even worse with using cardinal numbers to describe time, because time is continuous. 00:00:00 only really describes the _start_ of the first second. Because all the moments within that second, except for its end point, are at a time of 00:00:00.nnnn from the start of the day, it is conventional to write it as 00:00:00, but 00:00:01.000... is the end point of the first second (and hence part of it), as well as being the [...] 31095 174 51_FW: 24:00:00 - was APAR for DB2 Timestamp on OS/3900_23_adamsrob@WELLSFARGO.COM31_Thu, 18 Nov 1999 15:36:45 -0800420_iso-8859-1 Midnight is AM, noon is PM - that makes 24:00:00.0000 clearly the beginning of the first second of the day, not any part of the last second.

Rob Adams-Kane Relational Applications

-----Original Message----- From: Campbell James [mailto:James.Campbell@ENERGYIS.COM.AU] Sent: Thursday, November 18, 1999 4:22 PM To: DB2-L@RYCI.COM Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390 [...] 31270 226 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39014_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Thu, 18 Nov 1999 19:27:01 -0500559_us-ascii Regardless of whether an ordered linear range is continuous or discrete, a practical numbering scheme should be able to break it into subintervals whose identities can be read off from the numbers. That's why systems programmers number storage addresses from zero instead of one, so they can avoid errors like thinking that the millennium changes at the end of this year. If the sysprogs were running things, this year, the 1999th year of the calendar, would be numbered 1998 , which is year 98 (the 99th year) of century 19 (the 20th century). [...] 31497 206 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39014_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Fri, 19 Nov 1999 11:19:00 +1000494_us-ascii I just knew that letting Harvey's mistake go by would get me into trouble. Especially quoting it, even though I wanted to the 'end at' bit, rather than end before.

Midday and midnight are both neither AM nor PM. AM=ante meridiem, PM=post meridiem, ie before and after the middle. Midday is neither before, nor after, the middle but _is_ the middle. Midnight is equi-distant (time wise) from the preceeding and succeeding middays, so is neither closer to one nor the other. [...] 31704 210 55_Re: FW: 24:00:00 - was APAR for DB2 Timestamp on OS/39014_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Thu, 18 Nov 1999 19:32:02 -0500345_us-ascii Before digital clocks arrived on the scene, midnight was PM and noon was M (how could noon be either AM (before noon) or PM (after noon)???). "M" stood for meridian, AM was and still is "ante meridiem", and PM was and still is "post meridiem". Digital representation in the form of digital clocks exposed the folly of this system. [...] 31915 236 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39014_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Thu, 18 Nov 1999 19:35:45 -0500494_us-ascii We seem to have transmitted simultaneously. What you said made sense, but (at the risk of allowing my age to be inferred) we were taught quite definitively that midnight was 12 PM of the ending day. Several of my contemporaneous friends remember this also. We all remember this bit of grade-school trivia for the same reason: that it struck us, even at our grade-school levels of mathematical sophistication, as totally illogical, just as annotating midnight as 24:00 does today. [...] 32152 20 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39014_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Thu, 18 Nov 1999 19:44:04 -0500546_us-ascii I forgot to mention that a few years ago there was a court case reported in the newspapers from some town in New Jersey involving a dispute over what time "12 PM" on a parking restriction sign refers to. The answer seems to depend on whether you're over 50.

New York City uses "noon" and "midnight" on its signs. "Midnight" apparently belongs to either day, depending on whether it's at the start or end of the interval (e.g., "No Parking 8 AM - Midnight Mon-Fri" or "No Parking Midnight - 8 AM Mon-Fri". "12:01 AM", anyone? [...] 32173 276 36_Re: APAR for DB2 Timestamp on OS/3900_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 19 Nov 1999 08:43:44 +0800425_us-ascii John,

You saved me some typing! I agree - DB2 *allows* 24.00.00 as a time/stamp value, but as far as I am aware, it never supplies this value to you in the CURRENT TIME/STAMP registers.

And I'd be really surprised if any *users* are entering timestamp values manually - we have a hard enough time getting them to type their logins correctly! :) Sadly, true even of some 'programmers' I've seen... [...] 32450 120 39_Re: http://www-4.ibm.com/software/data/0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 19 Nov 1999 08:52:24 +0800483_us-ascii Hi,

For what it's worth, I've recently had problems downloading fixpacks etc. for UDB, but it appears the problem is with FTP through the firewall we have. It *used* to work - don't know what got changed, but....

I use IE5 as my browser, and to get around the problem I went to the Internet Options - Advanced tag, and enabled the "Use Web Based FTP" option. There is probably a similar option in Netscape or other browsers. Try that and see if it helps. [...] 32571 56 28_Re: COBOL Pre_compiler error14_zhangxiaoliang28_zhangxiaoliang@MAIL.DCAC.COM31_Fri, 19 Nov 1999 09:30:28 +0800522_iso-8859-1 Hi, We also use DB2 version 5.In DCLGEN panel of DSNI,the source table name is unqualified.It means that your default qualifier or primary sqlid will be used here.In this panel ,we cannot specify the full name like 'SYSIBM.SYSINDEXPART'.Therefore,it's impossible for us to DCLGEN directly a group level name of such a system catalog table. One possible solution is to create a user table 'LIKE' such a system table and DCLGEN it with the name DCLSYSINDEXPART.And then in out progrom we can code like this: [...] 32628 24 47_Re: http://www-4.ibm.com/software/data/db2/ ???12_Jim Harrison12_jimh@QIS.NET31_Thu, 18 Nov 1999 14:04:20 -0500633_us-ascii Works for me.

At 12:47 PM 11/18/99 -0600, RompotK@SCHNEIDER.COM wrote: >Can anyone access http://www-4.ibm.com/software/data/db2/??? > >================================================ >To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. > >

================================================ 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. 32653 255 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39011_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Thu, 18 Nov 1999 22:19:52 -0800708_- DB2-List administrator...kindly remove me from the list and put me back on when the discussion on 24:00:00 is over.

Regards

Sanjay Jain

-----Original Message----- From: Harvey Wachtel Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Thursday, November 18, 1999 4:34 PM Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390



>We seem to have transmitted simultaneously. What you said made sense, but >(at the risk of allowing my age to be inferred) we were taught quite >definitively that midnight was 12 PM of the ending day. Several of my >contemporaneous friends remember this also. We all remember this bit [...] 32909 315 9_unsucribe13_Console - SDP21_console@PENTAFOUR.COM31_Fri, 19 Nov 1999 09:41:52 +0530653_iso-8859-1 unsucribe

> ---------- > From: sanjay jain[SMTP:sanjay_jain@EMAIL.MSN.COM] > Reply To: DB2 Data Base Discussion List > Sent: Friday, November 19, 1999 11:49 > To: DB2-L@RYCI.COM > Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390 > > DB2-List administrator...kindly remove me from the list and put me > back on > when the discussion on 24:00:00 is over. > > Regards > > Sanjay Jain > > -----Original Message----- > From: Harvey Wachtel > Newsgroups: bit.listserv.db2-l > To: DB2-L@RYCI.COM > Date: Thursday, November 18, 1999 4:34 PM > Subject: Re: 24:00:00 - was APAR for DB2 [...] 33225 37 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39012_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 19 Nov 1999 08:58:41 +020078_x-user-defined Hi, It is just a plot to get one more minute to fine you ... ;) 33263 30 14_Re: SAP Reorgs12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 19 Nov 1999 09:12:44 +0200373_x-user-defined Hi, What about clustrratio ? I didn't see any reference to that

Dan Sullivan wrote: > > Runstats is run weekly > > ================================================ > 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. 33294 170 14_Re: SAP Reorgs22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 19 Nov 1999 06:54:44 +0000578_ISO-8859-1 Dan

I have been on SAP/DB2 OS390 in a very large production environment for just over a year now.

Can I suggest that you use several ways to determine which tables to reorg?

Reasons to Reorg (straight from a presentation by Namik) ----------------

Get rid of Extents on the underlying files (rapid growth objects - extent limit might be reached, but there are tricks to slow this up) Note also that on 133 extents are allowed on one volume and that 255 for a file is the upper limit - if you have multi 2gb files per pageset then the [...] 33465 120 27_Re: Indexes on foreign keys14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Fri, 19 Nov 1999 09:45:55 +0100548_us-ascii Michael,

thanks a lot for your answer; now let me get into detail if you don't mind:

we have - amongst others - one table with 12.2 million rows; there are 7 parent tables with 16, 86, 1, 1, 1, 181, 9 rows respectively. Those three tables with one row might 'grow' to 100 rows eventually, but I don't think that matters much; now we do have indexes on those 7 foreign keys, i.o.w., 7 indexes on 12.2 million rows; in addition to those 7 indexes we also have the partitioning index which is also the index on the primary [...] 33586 60 4_TIME9_Slot J.P.23_J.P.Slot@RF.RABOBANK.NL31_Fri, 19 Nov 1999 10:11:09 +0100557_us-ascii Hello All,

Regarding the time discussion I would add the following. As I was born I was 0 years old. After I lived one full year I became 1 year old. Hence after living 2000 years we become 2000 years old. So starting 1 januari 2000 00.00.00 hours we begin the next millenium. The first period of time in a new day is 00.00.00 hours. after finishing 1 second it is 00.00.01 hours. After finishing 86400 seconds we finalised a day. So then it is the new day start, therefore 00.00.00 hours. What bothers me is the date, since everything [...] 33647 119 49_Re: Benchmark between MS SQL Server and UDB on NT12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Fri, 19 Nov 1999 09:53:00 -0000526_iso-8859-1 I've downloaded it, but when I try to open it it asks for a Password, any ideas?

Colin Allen DBA Abbey National ---------- From: Richard A Yevich To: DB2-L@RYCI.COM Subject: Re: Benchmark between MS SQL Server and UDB on NT Date: 18 November 1999 20:36

Go to www.ryci.com/tech99 and download the pdf from there. Same as you would have received on the CD, except that it has been updated further, and will continually be updated. I will see that they post the update date on it there on the site. [...] 33767 26 49_Re: Benchmark between MS SQL Server and UDB on NT14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Fri, 19 Nov 1999 05:14:31 -0500513_ISO-8859-1 It opens without any problem on my system after I downloaded it.. Regards, Joel

Message text written by DB2 Data Base Discussion List > I've downloaded it, but when I try to open it it asks for a Password, any ideas?

Colin Allen DBA Abbey National<

===============================================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. 33794 89 20_Re: Uncommitted Read12_Steve Thomas29_sherpa@HORNST.FREESERVE.CO.UK31_Fri, 19 Nov 1999 10:10:18 -0000532_iso-8859-1 Michael,

One thing which could cause problems is if there are variable length columns involved in your update. Depending upon the circumstances, DB2 might relocate the row to a page that your UR cursor has already processed, and therefore you'd miss it. Having said that, you said that in this instance there was no conflict so it shouldn't have caused problems. Even if they did clash, you'd need to be very unlucky to have it happen 77 times. Someone else might be able to come up with another scenario.... [...] 33884 89 8_Re: TIME14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Fri, 19 Nov 1999 04:43:09 -0600348_ISO-8859-1 Sorry Jaap - your logic is flawed.

You will only have lived 2000 years at the END of the 2000th year. The next millennium will therefore start immediately after 23:59:59.99999999 etc on the last day, i.e. 01/01/2001.

You are 0 years old when you are born until you have completed your first year (Year 1) and so on... [...] 33974 31 6_DCLGEN14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Fri, 19 Nov 1999 12:01:50 +0100288_us-ascii Dear DB2 fellows out there,





a colleague of mine just asked me whether there is DCLGEN for DB2 for OS/2 in SDK and as I didn't know the answer and didn't find any hints in the manuals I thought I might put this question out to you.

TIA Ruediger Kurtz 34006 44 49_Re: Benchmark between MS SQL Server and UDB on NT12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 19 Nov 1999 05:31:51 -0800581_us-ascii I attempted to download it and it requested that I enter a password also. When I entered cancel I got nothing. It was Acrobat reader that was requesting the password.

--- Joel Goldstein wrote: > It opens without any problem on my system after I > downloaded it.. > Regards, > Joel > > Message text written by DB2 Data Base Discussion > List > > > I've downloaded it, but when I try to open it it > asks for a Password, any > ideas? > > Colin Allen > DBA > Abbey National< > > ===============================================To > [...] 34051 13 14_Re: SAP Reorgs12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Fri, 19 Nov 1999 07:51:52 -0600336_us-ascii We have developed software to set clusterratio to 99% accross the board, works great.

================================================ 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. 34065 22 14_Type 2 indexes13_Tomassi, Aldo20_Aldo_Tomassi@BMC.COM31_Fri, 19 Nov 1999 08:03:29 -0600293_ISO-8859-1 One question about type2 indexes on DB2 V6 On the V5 Administration Guide, at topic 2.5.1.1, I find this definition about type 2 indexes: "There are no one-level type 2 indexes. A type 2 index is created as a two-level index with a root page that points to an empty leaf page" [...] 34088 155 39_Re: http://www-4.ibm.com/software/data/0_21_RompotK@SCHNEIDER.COM31_Fri, 19 Nov 1999 08:22:22 -0600370_us-ascii Yep, I ran into that problem a while back. That was a real stumper. But this is something new. I can hit every IBM website except for www.software.ibm.com. I can also access the FTP server (ftp.software.ibm.com) directly. My network people refuse to look into the problem. So hopefully it is something between here and IBM that will fix itself eventually. [...] 34244 165 27_Re: Indexes on foreign keys0_19_mike.holmans@BT.COM31_Fri, 19 Nov 1999 13:51:13 -0000456_iso-8859-1 Ruediger,

The foreign key indexes are essential if you are going to change the primary keys of, or delete rows from, the parent tables, because otherwise DB2 has to tablespace scan the child each time you do it. They'd obviously also be useful if you were selecting from the children based on first getting a value from the parent, but if SYSPACKDEP doesn't show these indexes being used, it's a fair bet that you're not doing that. [...] 34410 13 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39014_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Fri, 19 Nov 1999 09:33:23 -0500368_us-ascii I promise to quit at this point. I did try to restrict my postings to after hours, but I agree that enough is enough.

================================================ 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. 34424 36 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39018_Ottenbacher, Cindy25_Cindy_Ottenbacher@BMC.COM31_Fri, 19 Nov 1999 08:59:54 -0600710_ISO-8859-1 Yes, that was amazing. Sounds like a team coordination problem.

Cindy Ottenbacher Austin, Texas



-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Thursday, November 18, 1999 8:06 AM To: DB2-L@RYCI.COM Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390



I believe he means that we dumb yankees in addition to having confusing old-world time-keeping attitudes should be ashamed we are not yet using the metric system of measurement(which apparently was the cause for the crash of the Mars probe recently(engineers from one team sent measurements in miles and the other team neglected to convert to kilometers). [...] 34461 56 23_Re: Storage utilization13_Paul Weissman21_Paul.Weissman@WDR.COM31_Fri, 19 Nov 1999 10:01:55 -0500388_- I'd also expect that your system has plenty of memory and that the paging rate is close to zero. The 20K frames (80MB) of virtual storage can be stolen if there was any need to, unless somebody has done some extremely aggressive old style fencing of storage. What you see is an indication of why main storge occupancy (MSO) service units tend not to be a reliable measure anymore. [...] 34518 40 26_dcs interrupt_enabled parm17_Hipenbecker, Doug25_Hipenbecker.Doug@MBCO.COM31_Fri, 19 Nov 1999 09:38:12 -0600511_iso-8859-1 Greetings!

I am running DB2Connect EE 5.2 FP10 on AIX via SNA 5.0.3 to MVS/DB2 5.1. I have an application that has AIX clients that issue query cancellations that are being ignored by DB2/MVS.

I was told to put ,,interrupt_enabled,,,,, in the parms of the dcs directory entry. This still hasn't corrected the problem. Do I need upper case...do I need a different count of leading/trailing commas?????? Is there something else I'm missing???? Any help would be GREATLY appreciated. [...] 34559 54 12_Mars Orbiter0_23_adamsrob@WELLSFARGO.COM31_Fri, 19 Nov 1999 07:43:31 -0800443_iso-8859-1 A team co-ordination problem? It sounds like the injection burn was never, ever tested in simulation, or the simulation didn't actually simulate that which was being tested.

Rob Adams-Kane Relational Applications -----Original Message----- From: Ottenbacher, Cindy [mailto:Cindy_Ottenbacher@BMC.COM] Sent: Friday, November 19, 1999 7:00 AM To: DB2-L@RYCI.COM Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390 [...] 34614 113 8_Re: TIME24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Fri, 19 Nov 1999 09:43:49 -0800588_us-ascii Colin, Your assertion regarding how old you are when you're born is not universally applicable. In Korea folks believe you are 1 year old when you're born.

Frank

On Fri, 19 Nov 1999 04:43:09 -0600, Clayton, Colin wrote:

>Sorry Jaap - your logic is flawed. > >You will only have lived 2000 years at the END of the 2000th year. The next >millennium will therefore start immediately after 23:59:59.99999999 etc on >the last day, i.e. 01/01/2001. > >You are 0 years old when you are born until you have completed your first >year (Year 1) and so on... > >I [...] 34728 56 23_Re: Preformatting Pages15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 18 Nov 1999 05:41:13 -0600327_us-ascii Philip Nelson wrote:

> Is there any mileage in running a load job before releasing the system for use with the PREFORMAT option ? What is the % expected benefits ? Would it also be > worth doing an UNLOAD and LOAD of the table periodically with the PREFORMAT option (say instead of a reorg once a month) ? [...] 34785 44 14_Type 2 indexes17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Fri, 19 Nov 1999 10:09:08 -0600420_ISO-8859-1 Hi Aldo,

I don't know about the Admin Guide, but there is a statement in the v6 Diagnosis Guide (pg 361) that reiterates "no one-level type 2 indexes". Is that what you were after?

Cheers, Ken Kornblum BMC Software

-----Original Message----- From: Tomassi, Aldo [mailto:Aldo_Tomassi@bmc.com] Sent: Friday, November 19, 1999 8:03 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Type 2 indexes [...] 34830 141 49_Re: Benchmark between MS SQL Server and UDB on NT12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Fri, 19 Nov 1999 10:25:32 -0600442_iso-8859-1 When I go out to www.ryci.com/tech99 it requests a password -- what is the password we can/should use?



Paul E. Martin Systems Consultant



-----Original Message----- From: Heidorn Sven IT Sundsvall [ mailto:Sven.Heidorn@CSN.SE ] Sent: November 18, 1999 11:11 AM To: DB2-L@RYCI.COM Subject: SV: Benchmark between MS SQL Server and UDB on NT [...] 34972 19 37_Re: DB2 for OS/390 and degree(any)...12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 19 Nov 1999 10:30:08 -0800432_- There are many situations where DEGREE of ANY is used and other factors prevent use of parallelism. I'd start with the section Parallel Operations and Query Performance in the DB2 Administration Guide, V5 that's pages 5-294 to 5-308.

There is some overhead for evaluating parallelism and some variation in the cost, but it's generally pretty low. Other than measuring, I don't know how to work out your specific case. [...] 34992 27 23_Re: Preformatting Pages12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 19 Nov 1999 10:39:35 -0800596_- REORG has the preformat option too, added in the same APAR, PQ03652. You can get the description on the web.

http://www.ibm.com/software/db2os390/ Click on the V5 APARs line at the bottom of the page, then on the APAR you want.

The LOAD and REORG utilities have been modified to add the PREFORMAT option. The PREFORMAT option on the LOAD and REORG utilities specifies that the space that remains in the table space and index spaces after data is loaded is formatted as zero pages so that the high used RBA equals the high allocated RBA. Insert activity following the LOAD or [...] 35020 15 18_Re: Type 2 indexes12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 19 Nov 1999 10:46:34 -0800263_- In V6 there are no type 1 indexes, so there is not much sense in describing a difference between a type 1 and type 2 index. That's how I remember this one, but then they said that memory is the second thing to go, and I don't think I remember the first... [...] 35036 13 10_Re: DCLGEN12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 19 Nov 1999 10:48:41 -0800357_- I think that DCLGEN is one of the new functions added to DB2 for Unix, Windows, OS/2 in V6.1.

Roger Miller

================================================ 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. 35050 14 29_This is a test Please ignore.19_Margaret Vradenburg20_mmvrade@LANDSEND.COM31_Fri, 19 Nov 1999 11:02:35 -0600255_us-ascii Test

================================================ 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. 35065 107 8_Re: TIME12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 19 Nov 1999 19:24:33 +020075_x-user-defined HI , I see no problem with celebrating twice ....;))

35173 185 49_Re: Benchmark between MS SQL Server and UDB on NT22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM31_Fri, 19 Nov 1999 12:41:17 -0500481_iso-8859-1 Who/What is requesting the password? Carefully read the password request box and note the resource that requires a password. For example, if you're IE 4 you'll get a dialog box with something similar to

Please enter your authentication information

Resource: a resource name User name: Password:

I can get to http://www.ryci.com/tech99 and display Download UDBvsMSSQLvsOracle.v1.pdf (Version 1999/10/12) with no problems. No password requested. [...] 35359 84 30_Re: dcs interrupt_enabled parm9_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM31_Fri, 19 Nov 1999 11:51:08 -0800339_us-ascii Doug,

You're dcs_paramet is correct. We have Win/95 and NT clients on DB2 Connect 5.2 FP8 or 6.1 FP1 and Linux and Unix (Solaris) clients on 6.1 FP1 and cancel works. We use TCP/IP direct from client, but I don't recall a problem when we used an SNA gateway. On DB2 OS/390 5.1 here are two zparms that come into play: [...] 35444 82 30_Re: dcs interrupt_enabled parm0_14_dcreed@CSC.COM31_Fri, 19 Nov 1999 11:56:56 -0600350_us-ascii Hi Doug, I am not sure this helps at all, since different software. We have BO (business objects) clients that are set up to have asynch connections, which allows them to cancel the request. The request is sent to the host and processed. We are also utilizing TCPIP vs SNA at this point. A sample DCS that works for us is: DCS 1 entry: [...] 35527 38 8_Failover14_Mitesh Damania24_mitesh_damania@YAHOO.COM31_Fri, 19 Nov 1999 10:09:15 -0800641_us-ascii I am still researching a failover soluion for our DB2 database on sun solaris.

We would require a private/leased line to connect the servers for real-time mirroring whenever the distance is super-great(West Coast/EastCoast). That would be cost-prohibitive for us.

I have this (less expensive) idea:

Someone told me this would actually slow down the database greatly, so I would like your opinion. If we have Sun Clustered databases on 2 servers on the West Coast that will do load-balancing and failover and a third database on the East Coast that will be the data replication target, will it be feasible? [...] 35566 215 49_Re: Benchmark between MS SQL Server and UDB on NT15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Fri, 19 Nov 1999 13:21:18 -0500410_iso-8859-1 When we click on the download, a small popup window with message ' 'http://www.ryci.com/tech99' is protected' Then a password box. If we enter something, it will tell 'invalid password' and go back to the password window again. Now when we click on 'Cancel', we get a blank screen.

Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com [...] 35782 37 17_ER Model Exercise18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Fri, 19 Nov 1999 13:01:32 -0600623_iso-8859-1 Hi all, I think I already know the answer to this but, I would like to be able to enforce a business rule via DB2 tables, PKs, FKs, column constraints, stored procedure, validproc, whatever, etc. I figure someone has been run over by this before and could help out. DB2 for OS390 V5. Given these attributes, currently grouped into these entities: Parent table, CustID, Name, BillingStreetAddr, etc. 1st Child table of Parent table, CustID, EmailAddr 2nd Child table of Parent table, CustID, PhoneNumber 3rd Child table of Parent table, CustID, CellPhoneNumber Is it possible to enforce, via DB2, a business [...] 35820 284 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39018_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Fri, 19 Nov 1999 13:15:30 -0600623_iso-8859-1 Certainly Sir, at what time would you like it to be effective: 00:00:00 or 24:00:00?

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 [...] 36105 13 18_Re: Type 2 indexes0_25_Clint.Taylor@AUTOZONE.COM31_Fri, 19 Nov 1999 13:23:32 -0600348_us-ascii In rel 6 of DB2 type 1 indexes are not supported. Everything most be converted to type 2 indexes.

================================================ 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. 36119 48 28_Re: COBOL Pre_compiler error11_Neil Duffee18_NDuffee@UOTTAWA.CA31_Fri, 19 Nov 1999 14:43:58 -0500557_US-ASCII On 18 Nov 99, at 14:12, concerning "Re: COBOL Pre_compiler error", Kalman, Jeff wrote:

> Can someone tell me why the Pre-Compiler is flagging the following > select with an error. The error is pointing to host variable, > DCLSYSINDEXPART. The error message is: undefined or unusable host > variable. The host variable is the group level name in the DCLGEN. > We are running DB2 version 5. > > EXEC SQL > SELECT * > INTO :DCLSYSINDEXPART > FROM SYSIBM.SYSINDEXPART > WHERE IXNAME-TEXT = :WS-DB2-TSNAME > END-EXEC. [...] 36168 298 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39011_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Fri, 19 Nov 1999 14:44:35 -0800674_- somewhere in between

-----Original Message----- From: DAVIS, RICK (SWBT) Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Friday, November 19, 1999 11:17 AM Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390



>Certainly Sir, at what time would you like it to be effective: 00:00:00 or >24:00:00? > >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 [...] 36467 69 23_Re: Preformatting Pages11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Fri, 19 Nov 1999 15:09:07 -0500478_ISO-8859-1 Hi Philip

The savings will only be for insert processing. Every so often, when there is no space left in formatted pages, an insert will trigger the formatting of the next two allocation units (tracks or cylinders). This will show as high Wait Service time in the DB2 Accounting Trace. If this formatting is causing you problems (long on-line response times or long running batch job) then consider PREFORMAT. If it is not causing problems, don't bother. [...] 36537 186 49_Re: Benchmark between MS SQL Server and UDB on NT18_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Fri, 19 Nov 1999 21:35:15 +0100676_iso-8859-1 Hi folks, I'am using netscape 4.7, no problem, I'am now printing the documents.

Gerrit

"Philip, Sibimon" wrote:

> When we click on the download, a small popup window with message ' > 'http://www.ryci.com/tech99' is protected' Then a password box. If we enter > something, it will tell 'invalid password' and go back to the password > window again. Now when we click on 'Cancel', we get a blank screen. > > Thanks > Sibimon Philip > 972-702-2515 - Office > 972-417-3597 - Residence > E-mail - Sibimon_philip@sealand.com > > -----Original Message----- > From: Piontkowski Michael ML > [mailto:michael.piontkowski@ZCSWILM.ZENECA.COM] > Sent: [...] 36724 68 10_Re: DCLGEN10_Marc Baime23_mbaime1@TAMPABAY.RR.COM31_Fri, 19 Nov 1999 15:49:57 -0500732_iso-8859-1 You are correct Roger. The new command in V6 is db2dclgn and the syntax from the command line is as follows:

Usage: db2dclgn -d -t []

Option Description Parameter Default Setting ---------------------------------------------------------------------------- --- -a Action ADD|REPLACE ADD -b LOB Variable Type LOB|LOCATOR|FILE LOB -c Column as Suffix none FALSE -i Indicator Variables none FALSE -l Host Language C|COBOL|FORTRAN|JAVA C -n Field Name Prefix prefix none -o Output File filename table-name.x where .x is .h for C, .cbl for COBOL, .java for JAVA, .f for FORTRAN (UNIX), .for for FORTRAN (INTEL) -p Password password none -r Remarks none FALSE -s Structure [...] 36793 21 31_Accounting detail info from CAF18_Stritzinger, David24_StritzingerD@NABISCO.COM31_Fri, 19 Nov 1999 15:59:38 -0500409_- We are running SAP with DB2 as our DBMS. Transactions are submitted through the ICLI address spaces using CAF connections. The connections are there 24x7 and terminated once a week.

Is there any way to get DB2PM accounting detail type information in this environment for indivicual transactions and applications?

The SMF accounting records only get cut when the connection is terminated. [...] 36815 46 35_Re: Accounting detail info from CAF20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 19 Nov 1999 16:15:44 -0500378_- There is no way you can get individual transaction info from DB2PM in this case. You have look for your tool to cut SMF records per transaction.

We use shadow direct, which also uses CAF and keeps persistent thread and does not cut individual transaction level SMF records. But shadow also provides a option, which lets you cut accounting records per transaction. [...] 36862 123 49_Re: Benchmark between MS SQL Server and UDB on NT16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 19 Nov 1999 16:20:00 -0500590_iso-8859-1 The CORRECT version, 11/18, WITHOUT PASSWORD REQUIRED will be on the site late Friday.

Richard

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Allen, Colin > Sent: Friday, November 19, 1999 4:53 AM > To: DB2-L@RYCI.COM > Subject: Re: Benchmark between MS SQL Server and UDB on NT > > > I've downloaded it, but when I try to open it it asks for a Password, any > ideas? > > Colin Allen > DBA > Abbey National > ---------- > From: Richard A Yevich > To: DB2-L@RYCI.COM > Subject: Re: Benchmark between MS [...] 36986 53 28_Re: COBOL Pre_compiler error17_Linda F. Claussen18_lindafc@NETINS.NET31_Fri, 19 Nov 1999 15:39:37 -0600706_ISO-8859-1 Jeff,

IXNAME-TEXT = :WS-DB2-TSNAME

Try taking the -TEXT out of the where clause, DB2 is trying to interpret as a host variable instead of the column of the table.

Linda F. Claussen Claussen & Associates DB2 Consulting and Training lindafc@netins.net http://www.netins.net/showcase/lclaussen/ Phone: (319) 343-3216 Office: (319) 847-1985 ---------- > From: Kalman, Jeff > To: DB2-L@RYCI.COM > Subject: Re: COBOL Pre_compiler error > Date: Thursday, November 18, 1999 1:12 PM > > Can someone tell me why the Pre-Compiler is flagging the following select > with an error. The error is pointing to host variable, DCLSYSINDEXPART. The > error message [...] 37040 115 30_Re: dcs interrupt_enabled parm17_Hipenbecker, Doug25_Hipenbecker.Doug@MBCO.COM31_Fri, 19 Nov 1999 16:10:19 -0600783_iso-8859-1 Hi again,

I'm a little confused...someone from IBM told me to use this in the dcs directory parms: ,,interrupt_enabled,,,,,

is this different from ,,interrupt_enabled

I find this in IBM's online documentation: ---------------------------------------------------------------------------- --------------- ,,INTERRUPT_ENABLED This is the third positional parameter. If INTERRUPT_ENABLED is configured in the DCS directory at the DB2 Connect workstation, and a client application issues an interrupt while connected to the DRDA server, DB2 Connect will perform the interrupt by dropping the connection and rolling back the unit of work. This interrupt behavior is supported on AIX, OS/2, and Windows NT. The application will receive sqlcode (-30081) [...] 37156 44 18_Re: Archiving data18_Anyanso Agwu-Okeke17_pagwu@HOTMAIL.COM29_Fri, 19 Nov 1999 17:23:53 EST667_- Hi Matt, Where can I get information about the FDR software product? Thanks Phillips



>From: "Szeszycki, Matthew (WTC/Lisle)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Archiving data >Date: Tue, 16 Nov 1999 20:09:37 -0000 > >I am looking for a way to archive data monthly, partitioned by month/year, >with the assumption that the archived data could be recovered if needed. >I want to keep 2 years of data active, with the ability to restore/recover >by the partitioned month/year, if the requested record is more than 2 years >old from the current date. >We are thinking of [...] 37201 22 8_Re: TIME0_24_DB46@DAIMLERCHRYSLER.COM31_Fri, 19 Nov 1999 13:32:09 -0500541_us-ascii Shees all this about the millenium.

Please note that there was no year zero. So the first millenium was

1 to 1,000 years (at the end of 1,000)

The second millenium is 1,001 to 2,000 (again the end of 2,000)

I'm going to party like it's 1999 and 2000.

Dean

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 37224 63 35_Re: What can we use as a "trigger?"0_24_DB46@DAIMLERCHRYSLER.COM31_Thu, 18 Nov 1999 12:49:27 -0500747_us-ascii Upgrade to version 5 and use a stored procedure or upgrade to version six and use a trigger.









"Ludovici, Jim R" on 11/18/99 11:43:06 AM

Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc:





Subject: What can we use as a "trigger?"















Our programmers would like the database to take care of updating a column value on an insert to a table. Basically, the rule would be,at insert set Col X of row n = Col A of row n, if Col X is spaces. This should be accomplished with no code changes in the application [...] 37288 14 0_15_Pravat Banerjee32_pravatbanerjee@LOT.TATASTEEL.COM31_Sat, 20 Nov 1999 08:56:06 +0530340_us-ascii Hi guys , Can you tell me how 'tweaking' improves performance ? Thanx in advance pravat .

================================================ 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. 37303 27 32_Platinum Rapid Reorg and Maxrows13_Marcel Lepage13_iml@COLBA.NET31_Fri, 19 Nov 1999 23:26:08 -0700358_us-ascii Hi everyone,

I alter a tablespace for the MAXROWS parameter from 255 to 5 and then reorg with Platinum Rapid Reorg and that utility never take care of the new value.

That is not the case with IBM reorg.

Does anyone have experienced this before ?

Thanks for any help.

Marcel Lepage DBA DBSYS Technologies Inc. [...] 37331 141 8_Re: TIME14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sat, 20 Nov 1999 16:00:09 +1000341_us-ascii Frank,

What nonsense to say Koreans believe you are 1 year old when born! Koreans may well say you are in your first year when you are born, but clearly you cannot be 1 year old. Be careful when translating foreign languages and comments on their beliefs!

Since you are not Korean, I must be extremely skeptical. [...] 37473 65 21_Re: ER Model Exercise14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sat, 20 Nov 1999 16:10:40 +1000354_us-ascii Rick,

It is not possible to enforce such a rule without writing some application code, or Stored Procedures or V6 Triggers.

Note that the rule cannot be enforced immediately but must be delayed slightly since R.I. will insist on parent row being inserted before child. So I gues you want to enforce it before the next commit. [...] 37539 51 43_Re: communication error on UDB on NT server11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Sat, 20 Nov 1999 00:36:13 -0500369_iso-8859-1 I've seen such a thing before when your connection is forced off by the DBA and db2 is stopped and restarted. However, I wouldn't think this is normal. I also wouldn't advocate establishing connections for "life" either. Connect. Work. Connect reset/terminate. Activate the database if you are connecting for the sake of maintaining a started database. [...] 37591 95 21_Re: ER Model Exercise17_Linda F. Claussen18_lindafc@NETINS.NET31_Sat, 20 Nov 1999 18:11:03 -0600428_ISO-8859-1 Rick,

The only non-application solution to your problem that I can think of is to de-normalize your tables.

Since you have an assumed 1-1 relationship to the CustID and BillingStreetAddr can one assume that you also have a 1-1 relationship on CustID and the EmailAddr, PhoneNumber and CellPhoneNumber. If this is the case you can use a Table Check Constraint on the 3 attributes you wish to check. [...] 37687 158 63_Greater K.C. Metro area Db2 User Group meeting - Dec 6 reminder0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Sun, 21 Nov 1999 12:24:02 -0600416_us-ascii If you are planning to attend the Dec 6th, Heart of America, DB2 User group meeting and you have not gotten with me, please let me know your food preference (Chicken,Beef or Vegetarian) by next Monday, Nov 29th.

We will be electing officers for Year 2000 at the December meeting so if you are interested in serving on the board, please let me know and I'll add you to the ballot. Positions are: [...] 37846 73 45_DB2 Classes offered in K.C on 12/7 & 12/8/99.0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Sun, 21 Nov 1999 14:51:14 -0600332_us-ascii DB2 CLASSES in K.C.

December 7 - Recovery from Z to A December 8 - Fun with DB2 Performance for Everyone

Heart of America DB2 Users Group is happy to announce two DB2 classes taught by Willie Favero of BMC. The cost is $150 per person, per class. The classes will be held from 8:30 a.m. to 4:00 p.m. at: [...] 37920 45 8_Re: TIME10_Ron, Yoram12_rony@ANZ.COM31_Mon, 22 Nov 1999 11:21:56 +1100318_iso-8859-1 Sorry mate, There was a year 'zero'. When the date changed after 31/12/(-1) it was 1/1/0 not 1/1/1 as you suggest. The last year BC = 1/1/(-1) to 31/12/(-1) First year AC = 1/1/0 to 31/12/0

You can roll the system date all the way down to 0 to check. It is important to be Y0 (Y-zero) ready ;-) [...] 37966 51 51_Re: 24:00:00 - was APAR for DB2 Timestamp on OS/39014_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Mon, 22 Nov 1999 10:59:13 +1000521_us-ascii Harvey, "Out of Hours" for who ?

Paul. Outside good 'ol US of A and past the "Here be Dragons" sign.

---------------------- Forwarded by Paul A Redhead/CorpServ/qdot/au on 22/11/99 11:00 ---------------------------



Harvey Wachtel on 20/11/99 00:33:23

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Paul A Redhead/CorpServ/qdot/au) Subject: Re: 24:00:00 - was APAR for DB2 Timestamp on OS/390 [...] 38018 76 8_Re: TIME14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 22 Nov 1999 14:04:15 +1000574_us-ascii I would be interested in seeing a reference to any authority (as much as anything on the Internet can be an "authority") claiming there was a year zero. Here a counter authority (ie no year zero between BC and AD):

http://www.tondering.dk/claus/cal/calendar21.txt (in sect 2.10.2)

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Tooronga +61 3 9261 1802 james.campbell@energyis.com.au -----Original Message----- From: Ron, Yoram [mailto:rony@ANZ.COM] Sent: Monday, November 22, 1999 10:22 AM To: DB2-L@RYCI.COM Subject: Re: TIME [...] 38095 104 20_Re: Uncommitted Read14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Mon, 22 Nov 1999 13:46:55 +1000527_us-ascii Michael, The only 'way out' thing that occurs to me is if a tablespace scan is occurring and you have pages in the logical page list. I know years ago I was quite suprised when I learned that if I tried to access rows directly via an index and the RID's pointed to rows on pages in the LPL I would get a -904 and yet I could select 'ALL' rows happily from a table with no error...the tablespace scan simply jumped past pages in the LPL. I am guessing this behaviour still occurs. I also believe that stopping and [...]