1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2000, week 5 2 126 48_Balt./Wash. DB2 Users' Group Mtg. - Mar. 8, 20000_19_valeriet@US.IBM.COM31_Sat, 29 Jan 2000 10:21:01 -0500694_us-ascii Baltimore/Washington DB2 Users' Group

Meeting Date: March 8, 2000

Location: Sheraton Columbia Inn 10207 Wincopin Circle Columbia, MD (410) 730-3900

Meeting Schedule:

8:30 - 9:00 Registration

9:00 - 10:15 DB2 UDB Scalability on Sun Solaris Barry Beach, IBM

DB2 has demonstrated strong scalability on Unix and Intel platforms. How does it scale in an open-systems environment? A long time Sun customer, concerned about their DBMS scalability, challenged IBM and Sun to demonstrate DB2 UDB performance with 1 TB of data on Solaris. This case study presentation describes the test environment and how DB2 UDB on Sun Solaris met the challenge [...] 129 34 24_DB2 Call Attach Facility16_Lamb, Ron (CORP)25_Ron.Lamb@CORPORATE.GE.COM31_Sat, 29 Jan 2000 10:44:11 -0500570_- Paul, we have been using a product called DB2CAFX from Softron for about 10 years now. The product allows us to simplify our production JCL and seems to reduce CPU slightly depending on how long the batch job runs. Short jobs seem to save a higher percentage. The plan name and DB2 subsystem id are read from a parameter file when the batch program first executes. To use this product we include a special load library in the JCL, add the parameter file and execute the batch program directly. We converted to this process without ever changing a single program. [...] 164 141 21_Re: stored prodedures14_Rosenfeld Bill23_rosenfeld.b@DREYFUS.COM31_Sat, 29 Jan 2000 11:04:43 -0500386_- What is the syntax you use to invoke the SP from Access? Thanks.

-----Original Message----- From: Rao, Peavy [SMTP:Peavy.Rao@TRANSAMERICA.COM] Sent: Friday, January 28, 2000 12:34 PM To: DB2-L@RYCI.COM Subject: Re: stored prodedures

Does the documentation say, you can execute Stored Procedure from Command Center ? I use MS Access to execute SPs on main frame.... [...] 306 350 31_CLOB Simulation in DB2/OS390 V514_Ulf-Otto Cihak23_UlfCihak@COMPUSERVE.COM31_Sat, 29 Jan 2000 11:08:20 -0500339_ISO-8859-1 Dear List, some weeks ago I asked you how you would store big documents (50-60K) in V5. I received one very interesting answer from Chris Blaicher (thanks, Chris), and a similar question was raised by Krysia Winska about Long Varchars. An excerpt from these threads, and my findings in the DB2 red books, are copied below. [...] 657 31 8_SDSNLOAD13_Mourer, Ken R18_ken.mourer@EDS.COM31_Sat, 29 Jan 2000 11:23:15 -0600632_iso-8859-1 I prefer to not have SDSNLOAD in the linklist or LLA.

I like having subsystem specific software libraries so that I can implement maintenance on one DB2 system without effecting the others on the same shared DASD complex. But, I use dataset aliases. Base datasets would be like this: DB2.V510.PUT9910.SDSNLOAD and the alias would be DB2.DB2P.SDSNLOAD. Multiple systems can share the same base libraries, but have different Alias names for maximum flexibility. It makes the staging and implementation of maintenance very simple - put out a new set of libraries, and del/def the aliases a subsystem at a time - [...] 689 160 21_Re: stored prodedures5_Jamie14_jamie@DANG.COM31_Fri, 28 Jan 2000 17:50:07 -0500444_iso-8859-1 Thanks. Are these the ones with a couple of examples in C and one in Java? I looked at it, but it wasn't helpful. It seems I'm doing things correctly, according the docs I've seen.--that's what's so frustrating.

Jamie ----- Original Message ----- From: Philip Gunning Newsgroups: bit.listserv.db2-l To: Sent: Friday, January 28, 2000 3:22 PM Subject: Re: [DB2-L] stored prodedures [...] 850 10 17_Re: Locking Error10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Sat, 29 Jan 2000 12:50:03 -0500607_- The -805 sqlcode indicates that the consistency token in the load module does not match the consistency token in the load module you are executing. Posible problems are: not issueing a new copy in cics, executing from the wrong load lib. You need to verify that the bind step executed correctly, what library was the program linked into and what joblib/steplib was used by the executing program. The consistency token is inserted into the dbrm and the program during the precompile process. During execution the tokens are compared. If they don't match -805 results. This "is not" a locking problem. [...] 861 130 38_Re: Trigger calling a Stored Procedure14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Sat, 29 Jan 2000 13:55:54 -0500517_iso-8859-1 Steve,

I don't see any problems just looking at it but I would try the following to see if the problem is your code or something else. In the trigger call to the sp, send the NROW as an input and add another parm as an output parm. On return use the output parm to SET the value in the NROW column and see if you get it them. This will at least see if there is an parm addressing problem somewhere in there. Also, you might consider setting one of the NROW columns to a value before passing it [...] 992 29 44_Re: DB2 active logs and IBM Raid-1 type DASD12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Jan 2000 16:32:28 -0600429_- This is just for the one item:

Can an IBM's, or any other vendor's RAID-1 controller mirror a volume to a volume in a different controller?

The techniques that are generally described as Remote Copy can mirror to a different controller, a different machine, ... The IBM acronyms for the capabilities are PPRC and XRC. So the usual approach is to go out to www.ibm.com/storage and find a few good references. [...] 1022 25 32_Re: Deadlock and isolation level12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Jan 2000 16:54:54 -0600495_- The locking behavior in DB2 for OS/390 is not identical, but it's generally far too complex in real life for anyone to predict with a reasonable level of effort. There are four different isolation levels in both products and they correspond to the international standards. I can think of one technique used by another vendor that is not standard, but sometimes provides data that is old and is in the process of changing. Updates made from a down level source can destroy data integrity. [...] 1048 11 31_Re: Locks on DBD and Tablespace12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Jan 2000 17:10:43 -0600344_- In your Administration Guide chapter "Improving Concurrency", there are a couple of sections titled:

================================================ 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. 1060 24 31_Re: Locks on DBD and Tablespace12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Jan 2000 17:23:09 -0600508_- In your Administration Guide chapter "Improving Concurrency", there are a couple of sections titled: Locks on the DB2 Catalog Locks on the Database Descriptors (DBDs)

Those sections explain some of what you asked. I doubt that you are seeing an exclusive (X) table space lock on the catalog, but rather intent exclusive (IX) lock on the table space and X locks on the modified pages. If your statement was true in general, some job streams with ten concurrent sets of DDL would not be running. [...] 1085 22 23_Re: db2 newbie question12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Jan 2000 17:41:19 -0600314_- I hope those techniques work for you now. Here is another possibility, but for later.

There is also a technique named identity columns. It came out very recently in DB2 for OS/390. Since we have strong DB2 Family Values, it's likely to be coming soon to other platforms. If you want to see more, try [...] 1108 14 44_Re: sql function simil initcap of Oracle sql12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Jan 2000 17:48:48 -0600437_- With the platform and release, the answer is easier. If you are running DB2 for OS/390 Version 6, you can use SUBSTR and ( TRANSLATE or UPPER or UCASE ) or a user-defined function.

Roger

================================================ 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. 1123 45 38_Re: Trigger calling a Stored Procedure12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Sat, 29 Jan 2000 19:09:56 -0600351_us-ascii Thank you Richard Yevich for your suggestions. I think I understand (and have tried) all but one.

Any value I set, by the "INSERT" statement, or in the Insert Trigger just before the SP call, shows up in the SP displays. (For parms specified as INOUT. They don't when I specify they are only OUT of course, but this makes sense.) [...] 1169 71 31_Re: Locks on DBD and Tablespace0_24_ssethi@LOT.TATASTEEL.COM29_Sun, 30 Jan 2000 05:21:05 GMT514_us-ascii Thanks Roger, I went thru the whole portion of the Admin. Guide carefully. Yes, the locks on the tablespace level is IX not X when a DDL is issued, but does some job streams with 10 concurrent sets of DDL on the same Database run ?. As the compatibility table of DBD locking says that if a DDL is issued then X lock is taken in DBD then it conflicts with Dynamic DMLs ,other DDLs and utilities on the same database. Of course ,My question was more on if at all the DBD is locked with X lock then why [...] 1241 56 67_Re: Using working storage variable on both side of the where clause12_Ranjay Sinha24_rsinha@LOT.TATASTEEL.COM29_Sun, 30 Jan 2000 16:19:55 GMT418_us-ascii Madhvan I fell in the where clause table_key_column should come first to avoid tablespace space scan. Also the tablespace scan depends on total no of data fetched by the query even if the where clause have table-key-value.

Ranjay







madhavan @RYCI.COM> on 01/13/2000 08:41:30 PM

Please respond to DB2 Data Base Discussion List [...] 1298 32 39_UCLA spring short courses by Chris Date12_Goodin, Bill21_bgoodin@UNEX.UCLA.EDU31_Sun, 30 Jan 2000 12:53:49 -0800657_iso-8859-1 > This spring, UCLA Extension will present the following short courses > on the UCLA campus in Los Angeles. > > April 3-4, 2000, "Relational Remodeled", $795. > > April 5-7, 2000, "Objects, Relations, and Object/Relational: The > Future of Database Management", $1295. > > The instructor is Chris Date, MA, Independent Consultant and Author. > > For additional information and complete course descriptions, please > visit our web page, http://www.unex.ucla.edu/shortcourses/, > > or contact Marcus Hennessy at: > (310) 825-1047 > (310) 206-2815 fax > mhenness@unex.ucla.edu > > Both of these courses may also be presented on-site at company [...] 1331 150 32_Re: Deadlock and isolation level11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Mon, 31 Jan 2000 08:53:16 +1100589_- Hi Milos, Have you tried 'get snapshot for locks on ' command? This will tell you what locks are currently taken, which may give you some idea of why the deadlock is occurring.

HTH, Bruce

> -----Original Message----- > From: Milos Flek [SMTP:milos.flek@FSP.CZ] > Sent: Saturday, January 29, 2000 7:55 AM > To: DB2-L@RYCI.COM > Subject: Deadlock and isolation level > > Hello, can you help me with following problem (DB2 UDB 5.2 NT)? > > Two applications, SQL commands sequence like this > > Appl 1/ update Xxx col=0 where id=10 > > Appl 2/ select * from Xxx [...] 1482 64 28_Re: DB2 Call Attach Facility13_George Peters22_gpeters@COMPUSERVE.COM31_Sun, 30 Jan 2000 19:58:17 -0500635_iso-8859-1 Paul One of the oldest is from Relational Architects, Inc. It is so basic, I have forgotten the name, but is a pre-req to other DB2 batch/restart products of theirs which require running under MVS proper (CAF), not under the TSO DSN command processor. I know the founders, have evaluated the products, and would strongly recommend them to you. Go to www.relarc.com George Peters > -----Original Message----- > From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of > Lamb, Ron (CORP) > Sent: Saturday, January 29, 2000 10:44 AM > To: DB2-L@RYCI.COM > Subject: DB2 Call Attach Facility > > > Paul, we have [...] 1547 67 67_Re: IFI trace http://jupiter.ryci.com/archives/db2-l-documents.html14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 31 Jan 2000 14:12:01 +1000379_us-ascii Max,

a couple of ways of doing this:

1) Dave Boll's RxSQL program has an interface to DSNWLI to retrieve trace records. I have now posted this to DB2-L-Documents (http://jupiter.ryci.com/archives/db2-l-documents.html). Hopefully Lynne will shortly approve it and you'll be able to pull it off there. I provide an example of using it for this purpose. [...] 1615 78 26_Re: DB2 V5 , VS COBOL-II ?14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 31 Jan 2000 14:12:25 +1000331_us-ascii Kishore

You might "think IBM should be consistent in all their products ", but they're not. Different products are written by entirely different groups of people. (Much as I would like to have a rant about this, I'll refrain.)

One way you can get your data into your program is by doing something like: [...] 1694 25 29_SCLM control of package binds14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 31 Jan 2000 14:17:03 +1000538_us-ascii Hi

Has anyone customised SCLM to handle package binds? How? (I think I'm getting the intellectual hang of what needs to be done, but I'ld like a second opinion.)

James Campbell Hansen Corporation, 2 Frederick Street, Doncaster +61 3 9840 3864 james.campbell@energyis.com.au

================================================ 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. 1720 54 18_bind authorization17_Bartolucci Silvia25_S.Bartolucci@FONDIARIA.IT31_Mon, 31 Jan 2000 09:00:19 +0100329_- Hi , i've a problem with bind authorization and RACF groups. I've a group of persons , say FDB2PL01 , which has to bind new and old packages on a specific collection. (In this RACF group there are the userids of persons). I've run the installation job DSNTIJEX , then i've given the following authorization to the group : [...] 1775 20 57_Platinum Recovery Analyser in a Datasharing Environment??22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 31 Jan 2000 08:09:24 +0000310_ISO-8859-1 Dear all, are any of you using the above product in a Datasharing environment? If you are can I ask you a couple question over mail??? - I have the product sorted I just wish to confirm a few things that I think are "funnies" in a DS environment abd this product with you .. Many thanks Leslie [...] 1796 47 12_Partitioning0_24_Ray.Price@DRESDNERKB.COM31_Mon, 31 Jan 2000 08:11:27 -0000394_iso-8859-1 Hello.

I have a question about the updating of columns in a partitioning index. I understand that this is now possible (with the right PTF) but that it causes drain locks to be taken. My question is what happens if the update does not change the partition? Does DB2 still drain the one partition involved? I can't find anything in the manuals to confirm this either way. [...] 1844 65 38_Program tests in emergency situations?10_Peter Boot22_Peter.Boot@MAIL.ING.NL31_Mon, 31 Jan 2000 09:21:24 +0000609_US-ASCII Hi,

I'd like your input on the following:

I'm working at a large financial institution which is gradually making the switch to DB2. During the night, we have massive batch jobs which run on a very tight schedule. At present, these jobs use sequential and VSAM files, but soon they'll read and update DB2 databases (millions of updates). One thing we're worried about is the following: once every while program errors will cause a program to abend somewhere during the night. At present, after a standby programmer has fixed the code (if necessary), a test run of the fixed program [...] 1910 101 22_Re: bind authorization13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Mon, 31 Jan 2000 13:35:43 +0530428_us-ascii hi !!

sepecify owner as FDB2PL01 it will work . !! by the way what is MPGDD , is it one of the RACF groups . if yes then the default RACF group (profile prefix) of the person submitting the job is MPGDD

regards Vishy









Bartolucci Silvia on 01/31/2000 01:30:19 PM

Please respond to DB2 Data Base Discussion List [...] 2012 139 21_R: bind authorization17_Bartolucci Silvia25_S.Bartolucci@FONDIARIA.IT31_Mon, 31 Jan 2000 11:53:29 +0100566_iso-8859-1 MPGDD is the userid of a person that belongs to FDB2PL01 group.



Bye Silvia

> -----Messaggio originale----- > Da: Viswanathan N [SMTP:Viswanathan.N@POWAIMAIL.LTITL.COM] > Inviato: luned́ 31 gennaio 2000 9.06 > A: DB2-L@RYCI.COM > Oggetto: Re: bind authorization > > hi !! > > sepecify owner as FDB2PL01 it will work . !! by the way what is > MPGDD > , is it one of the RACF groups . if yes then the default RACF group > (profile prefix) of the person submitting the job is MPGDD > > regards > Vishy > > > > > > Bartolucci Silvia [...] 2152 178 25_Re: R: bind authorization0_24_ssethi@LOT.TATASTEEL.COM29_Mon, 31 Jan 2000 12:27:25 GMT483_iso-8859-1 I think Group Name is having the BINDADD/BINDAGEND authority rather than the primary authorisation id (of the user who submits the job).Either use group name in the owner parameter or grant BINDADD/BINDAGENT to person who is submitting the job.

Thanks

Sanjeev









Bartolucci Silvia @RYCI.COM> on 01/31/2000 04:23:29 PM

Please respond to DB2 Data Base Discussion List [...] 2331 17 31_Re: Locks on DBD and Tablespace12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 31 Jan 2000 07:23:21 -0600530_- Yes, DDL runs concurrently. It sounds as though you have missed some of the database design comments from the earlier sections of the book. DDL runs on different databases.

If you try to make concurrent updates to a single object, then the problem is very difficult.

Roger

================================================ 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. 2349 122 12_Re: PM tools0_18_mebert@AMADEUS.NET31_Mon, 31 Jan 2000 12:39:27 +0100369_us-ascii I second that. I was a SAS Datawarehouse Admin until about one year ago, and it's an extremely powerful & efficient language. (I use a rule-of-thumb-factor of 30 to convert DB2 CPU times to SAS CPU times for batches under OS/390 - of course, there are many assumptions in this). However, most of the SAS Code written by others that I see makes me weep... [...] 2472 175 46_Re: MODIFY UTILITY FOR PARTITIONED TABLESPACES0_18_mebert@AMADEUS.NET31_Mon, 31 Jan 2000 13:10:37 +0100585_us-ascii The discussion was in the last week of December: look for subject lines "Re: Reorg DB2 catalog/MODIFY running time". As the main driver of this discussion thread, I'd like to summarise (all my problems were with partitioned TS too):

1. The running time of MODIFY is proportional to the square of the number of entries in SYSCOPY for a given (partitioned) tablespace. 2. Running the MODIFY in N steps that each remove only a single day results in about the same CPU time (disregarding overhead) as running a MODIFY to remove N days in one go. So this strategy does [...] 2648 25 22_DB2 DBAs billing rates0_18_Usregion10@AOL.COM29_Mon, 31 Jan 2000 09:01:26 EST528_us-ascii Greetings all!

Now that we have past the whole y2k thing and that it was a non-event, has anybody noticed the change in the demand-supply equation as far as db2 dbas are concerned. Also, most importantly I was curious to hear from the list about what the ongoing billing rates are for a db2 dba. I am referring mostly to the billing rates in the context of the contracting world. looking forward to hear from you all. thanks. Anil Principal Consultant, BAVS CORP. world's leading database service provider. [...] 2674 97 38_FW: SQL Performance for Report program8_madhavan16_madhavan@INF.COM31_Mon, 31 Jan 2000 20:00:21 +0530613_- Hi,

1. For some of them we will not be able to create indexes and we require the reports on a regular basis. 2. EVen if we have indexes for some of the reports, I would like to know if approach 2 will still give better performance?

regards Madhavan.

> -----Original Message----- > From: ssethi@LOT.TATASTEEL.COM [SMTP:ssethi@LOT.TATASTEEL.COM] > Sent: Saturday, January 29, 2000 8:24 AM > Subject: Re: SQL Performance for Report program > > Hi Madhavan, > > I think it is more of a physical design issue rather than anything > else.Try > identifying the candidate columns for creating [...] 2772 117 38_Re: SQL Performance for Report program14_Arnold, Mark S20_Mark.Arnold@BNSF.COM31_Mon, 31 Jan 2000 08:40:06 -0600328_iso-8859-1 It also depends on what you mean by performance. Are you trying to reduce CPU usage? I/O? Run time? I would think the issue of program maintenance should be addressed too. The first approach will be lots easier down the line, after the report requirements change several times...

Mark Arnold BNSF Railway [...] 2890 21 24_DB2 and ESS dasd WARNING11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Mon, 31 Jan 2000 09:00:35 -0600595_- To the list: New ESS DASD suffered microcode problem and promptly brought down MVS. Needless to say DB2 crashed and burned. Upon restart, DB2 recorded several inflight recoveries. These seemed to go well, but 00C90101 (data inconsistencies) were numerous. DB2 Log and DASD were out of synch. In other words, DB2 log recorded the change, but the cache(?) of this "shark" DASD (Do I hear the JAWS theme) never updated the physical dataset. All is recovered or REPAIRed. Just wanted to let the list know, in case anyone is implementing ESS DASD. Regards, John Rosser Duke Energy Corporation [...] 2912 50 28_Re: DB2 and ESS dasd WARNING22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 31 Jan 2000 15:35:51 +0000442_ISO-8859-1 John we have "Shark" can you either post or send me the microcode level you are at as soon as you get the chance ..

Our current microcode level is : F25524

thanks

Leslie Pendlebury-Bowe





______________________________ Reply Separator _________________________________ Subject: DB2 and ESS dasd WARNING Author: John Rosser at Internet Date: 1/31/00 9:00 AM [...] 2963 123 40_Re: Oracle Transparent G'Way Question...0_19_mike.holmans@BT.COM31_Mon, 31 Jan 2000 15:36:35 -0000605_iso-8859-1 My guess would be that you will find that the performance problems you are finding with the procedural gateway will be as nothing compared to the problems you will get on the transparent gateway.

We installed the OTG as a method of allowing access from an Oracle-based reporting system to get information from the parent DB2 system directly. We selected that product on the basis of what our customer said they wanted to do. Our evaluation, which backed up what Oracle had said, was that the OTG was suitable for low-level use with about 2-3 concurrent users, with occasional peaks [...] 3087 10 28_Re: DB2 and ESS dasd WARNING11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Mon, 31 Jan 2000 09:37:20 -0600276_- It's the same level. Regards, JR

================================================ 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. 3098 11 37_DB2 Connect Enterprise Edition for NT12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 31 Jan 2000 10:12:00 -0500323_- Is there a WEB site where I can download DB2 Connect Enterprise Edition for NT?

================================================ 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. 3110 113 38_Re: SQL Performance for Report program14_Michael Hannan24_mhannan@C031.AONE.NET.AU30_Tue, 1 Feb 2000 03:09:44 +1000342_us-ascii Madavan,

1 Million rows is not a very big table. You may not be able to afford every possible index for local predicates, and TS Scan for this is O.K.

However it would be very strange if the index could not be built for the join predicates, e.g. primary index and foreign key indexes for such medium sized tables. [...] 3224 32 41_Re: DB2 Connect Enterprise Edition for NT20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 31 Jan 2000 11:21:47 -0500656_us-ascii Bob This is the site.

http://www-4.ibm.com/software/data/db2/udb/downloads.html

> -----Original Message----- > From: BOB JEANDRON [SMTP:BOB.JEANDRON@USDA.GOV] > Sent: Monday, January 31, 2000 10:12 AM > To: DB2-L@RYCI.COM > Subject: DB2 Connect Enterprise Edition for NT > Sensitivity: Personal > > Is there a WEB site where I can download DB2 Connect Enterprise Edition > for > NT? > > ================================================ > 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. [...] 3257 39 41_Re: DB2 Connect Enterprise Edition for NT16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Mon, 31 Jan 2000 11:26:37 -0500522_us-ascii Bob, no site for download http://www-4.ibm.com/software/data/db2/udb/udb-nt/ this site you can request the cd's hth Tom







BOB JEANDRON on 01/31/2000 10:12:00 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: DB2 Connect Enterprise Edition for NT







Is there a WEB site where I can download DB2 Connect Enterprise Edition for NT? [...] 3297 78 44_Re: DB2 active logs and IBM Raid-1 type DASD22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 31 Jan 2000 11:50:50 -0500321_- Not sure if someone mentioned this.

OK - maybe the IBM Raid-1 DASD will work with the active logs but what about the archive logs?

How do you recover if there's a problem with the single archive log? Dual active logs gives the added benefit of dual archive logging under DB2's control and knowledge. [...] 3376 44 30_Using high capacity cartridges14_Donovan, Peggy22_peggy.donovan@SSMB.COM31_Mon, 31 Jan 2000 11:51:33 -0500626_- JCL allows a max for steps of255, but DD max is 3273. Do multiple copies in a step and specify Vol retain & ref option & the Label dataset#. Hope this helps.

000011 //NDXCOPY1 EXEC DSNUPROC,...... etc9,UID='M006IXCT',UTPROC='',

000012 //COPY01 DD DISP=(,CATLG,CATLG),UNIT=T3490,

000013 // DCB=(SHS.DSCB,RECFM=FB,BLKSIZE=24576,BUFNO=20,TRTCH=COMP),

000014 // VOL=(,RETAIN,,15),LABEL=(001,SL,RETPD=15),

000015 // DSN=DB2TST99.DAILYFUL.................

000016 //COPY02 DD DISP=(,CATLG,CATLG),UNIT=T3490,

000017 // DCB=(SHS.DSCB,RECFM=FB,BLKSIZE=24576,BUFNO=20,TRTCH=COMP), [...] 3421 93 26_Re: DB2 V5 , VS COBOL-II ?19_kishore erukulapati21_kishore_e@HOTMAIL.COM29_Mon, 31 Jan 2000 09:56:24 PST660_- Is it OK if I go for COMP-2 ?



>From: Campbell James >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: DB2 V5 , VS COBOL-II ? >Date: Mon, 31 Jan 2000 14:12:25 +1000 > >Kishore > >You might "think IBM should be consistent in all their products ", but >they're not. Different products are written by entirely different >groups of people. (Much as I would like to have a rant about this, I'll >refrain.) > >One way you can get your data into your program is by doing something >like: > >SELECT ... SUM(col - >DEC(INTEGER(col-(col/10000000000.0)*10000000000.0),15,3)) [...] 3515 171 43_Re: stored procedures - Calling from Access10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Mon, 31 Jan 2000 12:01:38 -0600369_ISO-8859-1 In Access open up window for Query / Design/ Pass thru SQL. Here the calling syntax for SP is {Call STPR051(1, '4811300000')};

This SP has two parameters .

Save this query and open it. When you open (double click) this query Access opens Login dialog, type UserID & Password and select the DSN from th ODBC sources, which connects to DB2. [...] 3687 123 44_Re: DB2 active logs and IBM Raid-1 type DASD19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 31 Jan 2000 13:31:22 -0600657_iso-8859-1 Mike, I would recommend dual active logs on different channels/controllers. In this manner a single controller failure doesn't potentially remove a active log from service nor add the problem with archive logging you mention. I agreed that removing a mirrored volume from service within a single controller would not bother DB2 active logging. I do NOT agree that mirroring replaces dual logging to separate channels/controllers; not only from an availability/reliability standpoint, but a from loss of service standpoint as well. The failure of a RAID-1 controller, upon which you are DB2 single logging, puts you in a possible position of [...] 3811 27 22_User Defined Functions12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 31 Jan 2000 13:42:42 -0600457_us-ascii Hello.

Is it true that one can only create and utilize UDF's in DB2 (V6.1, OS/390 V2.R6) if you use WLM managed address spaces? This seems to be the "implication" of the manuals I'm reading.

Thanks.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Steve Grimes Washington University Information Systems OS/390 V2R6 DB2 UDB 6.1 W: 314-935-4376 H: 314-928-5005 Isa.64:6 Steve_Grimes@aismail.wustl.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [...] 3839 19 11_Date format11_Kenneth Lam14_klam@BTMNA.COM31_Mon, 31 Jan 2000 15:24:37 -0500429_us-ascii Hello, Does DB2 have a built-in fucntion to convert date format. For example, I like to convert 2000-01-31 to 2000-Jan-31.

Can anyone give me some ideas.

Thanks Ken

================================================ 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. 3859 42 26_Re: User Defined Functions13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 31 Jan 2000 15:37:17 -0500448_iso-8859-1 Yes, UDFs must run in WLM address spaces. We've deduced this from the SQLcodes you get back if you try creating a UDF without WLM and you can deduce it also from the description in the SQL Ref. of the WLM ENVIRONMENT parameter in the CREATE FUNCTION statement: "Identifies the MVS workload manager (WLM) application environment in which the function is to run. The name is a long SQL identifier that must not contain an underscore. [...] 3902 53 15_Re: Date format15_Toine Michielse18_vndobtm@US.IBM.COM30_Thu, 2 Mar 2000 21:34:00 +0000475_us-ascii Hello Ken,

Provided you're talking about DB2 V6...check out the ALTDATE function. Appendix F.1 in the SQL reference.

Regards,

Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS



Kenneth Lam @RYCI.COM> on 01/31/2000 08:24:37 PM

Please respond to DB2 Data Base Discussion List [...] 3956 44 17_REORG and the RVA10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Mon, 31 Jan 2000 12:43:55 -0800309_us-ascii We are currently at DB2 v5.1 for OS/390 and have an IBM RVA.

Our storage administrator was wondering if there was a feature in any version of DB2 for OS/390 that took advantage of the architecture of the RVA for a REORG in the same manner that he can now do a logical defrag of a volume. [...] 4001 59 86_Re: Central PA - March 22-23th - DB2 Classes by Sheryl Larsen, RYC - Time to register!0_26_dawn.kastelic@HIGHMARK.COM31_Mon, 31 Jan 2000 15:46:32 -0500496_us-ascii Hey Cathy - how's everything going?? I got the go ahead to schedule this class. What all do I need to provide you with??

Thanks,

Dawn







Cathy Peck on 01/20/2000 08:51:07 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Dawn Kastelic/OPERATIONS/CORP/Highmark) Subject: Central PA - March 22-23th - DB2 Classes by Sheryl Larsen, RYC - Time to register! [...] 4061 20 41_UDB (DB2) backups on non-OS/390 platforms11_Paul Turpin26_Paul.Turpin@FIRSTUNION.COM31_Mon, 31 Jan 2000 14:42:43 -0600288_- I have already posted a similar question to the db2eug listserv, but because DB2-L has a larger membership I'm posting it here as well. I know that the majority of DB2-L members are using DB2 on OS/390, but this question is mainly for those using DB2 (UDB) on no-OS/390 platforms. [...] 4082 12 8_sorry...0_26_dawn.kastelic@HIGHMARK.COM31_Mon, 31 Jan 2000 15:51:44 -0500311_us-ascii I meant to send that last message directly to Cathy. Sorry!!

================================================ 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. 4095 27 26_Re: User Defined Functions12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 31 Jan 2000 15:17:28 -0600521_us-ascii Yes Dave - that's what I'm deducing as well.

I'm wonder though, why it isn't listed in the Release Planning Guide under:

G.1.2.1. Operating System and support programs, or, ideally?, under G.1.2.2. Function Dependent Program Requirements.

Oh well. Thanks.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Steve Grimes Washington University Information Systems OS/390 V2R6 DB2 UDB 6.1 W: 314-935-4376 H: 314-928-5005 Isa.64:6 Steve_Grimes@aismail.wustl.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [...] 4123 152 15_Re: Date format0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 31 Jan 2000 15:19:26 -0600544_iso-8859-1

I looked into this question a few years ago (at the start of our Y2K project). As shipped, I don't think there is any easy wat to that format (we were looking for that format, without the dashes). All you can get are the 4 numeric formats listed in the table below. You probably could get it with some complex SQL that parsed the numeric month into the Char format you want (ie using STRING and CASE). But with a little work you can tell DB2 to display (and accept) dates in a site specific format using an exit routine [...] 4276 52 26_Re: User Defined Functions14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Mon, 31 Jan 2000 15:31:33 -0500647_iso-8859-1 Yes, this is a requirement for V6 and it is documented in the V6 manuals.

Regards, Richard +===+===+===+===+====+ ryevich@attglobal.net



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Steve Grimes > Sent: Monday, January 31, 2000 2:43 PM > To: DB2-L@RYCI.COM > Subject: User Defined Functions > > > Hello. > > Is it true that one can only create and utilize UDF's in DB2 (V6.1, OS/390 > V2.R6) if you > use WLM managed address spaces? This seems to be the "implication" of the > manuals I'm reading. > > Thanks. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [...] 4329 88 22_Re: bind authorization14_Harvey Wachtel22_babybaby@UAPC.CUNY.EDU31_Mon, 31 Jan 2000 16:40:25 -0500405_us-ascii Administration Guide contains a table titled "Privileges Required for Basic Operations" that explains the rules in detail. In the section on "Operations on Plans and Packages" the table indicates that FREE, COPY, BIND REPLACE, REBIND and execute can be authorized via a secondary authorization ID, but BIND of a new plan requires the primary authorization ID to have the required privilege. [...] 4418 80 21_Re: REORG and the RVA15_Toine Michielse18_vndobtm@US.IBM.COM30_Thu, 2 Mar 2000 22:35:12 +0000438_us-ascii Hello,

No, that is not supported. The DB2 REORG utility reorders the ROWS within a tablespace according to the definition of the clustering index. The internal tables of the RVA do not control data at that granularity..............

Regards,

Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...] 4499 204 15_Re: Date format15_Toine Michielse18_vndobtm@US.IBM.COM30_Thu, 2 Mar 2000 22:51:26 +0000496_iso-8859-1 Hello Ron,

I guess you brought up a good marketing point for DB2 V6 here.....

Thanks...

Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS



Rohn.Solecki@MTS.MB.CA@RYCI.COM> on 01/31/2000 09:19:26 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 4704 208 43_Re: stored procedures - Calling from Access14_Rosenfeld Bill23_rosenfeld.b@DREYFUS.COM31_Mon, 31 Jan 2000 17:04:23 -0500429_ISO-8859-1 Thanks. Now, is it possible to execute a stored procedure from the command center?

-----Original Message----- From: Rao, Peavy [SMTP:Peavy.Rao@TRANSAMERICA.COM] Sent: Monday, January 31, 2000 1:02 PM To: DB2-L@RYCI.COM Subject: Re: stored procedures - Calling from Access

In Access open up window for Query / Design/ Pass thru SQL. Here the calling syntax for SP is {Call STPR051(1, '4811300000')}; [...] 4913 75 22_Re: bind authorization11_rick creech18_ykcirc@HOTMAIL.COM29_Mon, 31 Jan 2000 14:13:48 PST638_- Use the racf group as the OWNER. Regards, Rick Creech



>From: Bartolucci Silvia >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: bind authorization >Date: Mon, 31 Jan 2000 09:00:19 +0100 > >Hi , i've a problem with bind authorization and RACF groups. >I've a group of persons , say FDB2PL01 , which has to bind new and old >packages on a specific collection. (In this RACF group >there are the userids of persons). >I've run the installation job DSNTIJEX , then i've given the following >authorization to the group : > >- BINDADD auth to FDB2PL01 >- [...] 4989 18 15_Re: Date format11_Kenneth Lam14_klam@BTMNA.COM31_Mon, 31 Jan 2000 17:30:02 -0500458_us-ascii Toine, Thanks for your information. By the way, do you know what is alternate C PROGRAM compiler for job DSNTEJ2U to create these UDF. If you have any information, I would be very grateful.

Thanks Ken

================================================ 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. 5008 32 30_DB2 for VM - Migration to V6R123_Mulkey, DW David (7091)21_MulkeyDW@GVL.ESYS.COM31_Mon, 31 Jan 2000 16:42:58 -0600360_- To any fellow DB2 for VM'ers:

We are attempting to migrate from SQL/DS V3R5 to DB2 for VM V6R1. We are having trouble with the migration step that migrates the database system catalogs to the V6R1 level using the ARISMEX utility. This utility keeps attempting to load the V3R5 saved segments (rather than those created for V6R1) and then abends. [...] 5041 229 15_Re: Date format0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 31 Jan 2000 16:39:30 -0600553_iso-8859-1 Hello Toine:

Actually I think that Ken's required date format "2000-Jan-31", and our prefered display format of "00Jan31" (our old 3270 character app (no snickers please, ) had limited screen space) points out what could be considered a couple of shortfalls in the ALTDATE function. Below I snipped the format list for the function from the manual you mention on the IBM Website (http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/Shelves). None of the formats include the 3 Char Month abbreviation or formats without separators. [...] 5271 80 28_Re: DB2 and ESS dasd WARNING0_19_csutfin@AMSOUTH.COM31_Mon, 31 Jan 2000 16:09:57 -0600542_- John/Leslie We also have Shark. I am checking on the microcode level. We did an upgrade on it about 10 days ago. Will let you both know.

Thanks for the heads up.

Carol Sutfin AmSouth Banks NA









Leslie Pendlebury-Bowe on 01/31/2000 09:35:51 AM



Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Carol Sutfin/BIRMINGHAM/AL/AMSOUTH BANK) Subject: Re: DB2 and ESS dasd WARNING [...] 5352 20 21_Re: stored prodedures12_Jason Hughes20_jason.hughes@TRW.COM31_Mon, 31 Jan 2000 16:49:49 -0600522_- The basic syntax is {CALL spname('parm1','parm2',parm3,...)} Be sure to include the { and }.

Jason Hughes

On Sat, 29 Jan 2000 11:04:43 -0500, Rosenfeld Bill wrote:

>What is the syntax you use to invoke the SP from Access? Thanks. >

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5373 15 34_DB2 Connect and Secondary Auth IDs12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 31 Jan 2000 16:59:00 -0500280_- There is an entry in the V5.1 Admin Guide on P 3-79 that says that in order to use Secondary Auth IDs with TCP/IP connections you have to modify DSN3@ATH. Does anyone know if this is a fact? This is the only reference I have found regarding this.

Thanks in advance. [...] 5389 123 26_Re: DB2 V5 , VS COBOL-II ?14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Tue, 1 Feb 2000 10:20:35 +1000364_us-ascii I would expect so, but do the cast before the sum. That is SELECT SUM(BIG_NUM) INTO :HV-COMP-2 will still fail because the summation will overflow before the host variable gets involved. You'ld have to: SELECT SUM(FLOAT(BIG_NUM)) INTO :HV-COMP-2 Of course, you'll lose accuracy since floating point numbers don't convert the fractional part exactly. [...] 5513 275 44_Re: DB2 UDB v 5 on NT - Performance Problems0_30_Milorad_Cerovac@TAC.VIC.GOV.AU30_Tue, 1 Feb 2000 07:49:53 +1000387_us-ascii Thanks Rohn, we are planning an import back to prod as soon as we've finished our analysis of what has caused this problem, but like you said we do not want to lose the "cause" of the problem. We're currently looking at trialing a product called Disk Keeper which we hope may tell us if there is any fragmentation of the DB2 files. And if so, then perform a defrag for us. [...] 5789 277 15_Re: Date format15_Toine Michielse18_vndobtm@US.IBM.COM30_Fri, 3 Mar 2000 00:44:12 +0000415_iso-8859-1 Hello Rohn,

No pun intended but again that's the beauty of DB2 V6..... if it doesn't provide exactly what you need.... There's a good chance you can build it yourself with an external user defined function.

Regards,

Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...] 6067 122 28_Re: Tool to evaluate indexes14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Mon, 31 Jan 2000 23:54:20 -0000402_iso-8859-1 I guess what is needed here is the ability to analyze the SQL that is being executed in a subsystem (both static and dynamic) and determine which set of indexes would best support this activity.

So, the statements that are being executed the most will have the greatest impact on the chosen indexes, and the statements which are executed infrequently will have a limited impact. [...] 6190 266 25_Re: Question on Utilities14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Mon, 31 Jan 2000 23:54:30 -0000376_iso-8859-1 This is my understanding of the situation at IBM too.

However, there is another side to this.

Do people really think that CA, BMC and CDB are going to stand idly by while their revenue is eroded by IBMs 'advances'? Or are we collectively going to make sure that for the forseeable future there ARE good reasons to look at third party utilities?? [...] 6457 77 16_Re: Partitioning14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Mon, 31 Jan 2000 23:54:51 -0000389_- Ray,

The original PTF that introduced this feature (whose number I don't have handy) actually DID say that "if the update will move a row from one partiton to another, then a drain will be taken on the original partition, the new partition and all intervening partitions". By inference, I have assumed that if you do NOT move the row then there will NOt be any drain issues. [...] 6535 253 46_Re: MODIFY UTILITY FOR PARTITIONED TABLESPACES14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Mon, 31 Jan 2000 23:55:02 -0000428_iso-8859-1 People may not be aware that CA have an alternative to IBMs Modify Utility (have a look at Merge/Modify) which is better, faster and more flexible than IBMs Modify AND Mergecopy utilities.

If Modify is causing some concern, then take a look at CA Merge/Modify.

Of course, it may be that you only have short-term problems with Modify, but an evaluation of Marge/Modify might still be useful........ [...] 6789 132 44_Re: DB2 active logs and IBM Raid-1 type DASD0_29_Greg.Palgrave@BANKWEST.COM.AU30_Tue, 1 Feb 2000 08:05:48 +0800432_us-ascii Mike,

You can specify dual archives even if you only have single active logs.

If you have dual actives, it tries to take a copy of each to ARCHLOG, but if you only have single active, it copies it twice.

Cheers,

Greg Palgrave Database Administration Group Information Services, Level 10, Tower Bank of Western Australia eMail : greg.palgrave@bankwest.com.au [...] 6922 63 15_Re: Date format24_Peter Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM30_Tue, 1 Feb 2000 11:25:13 +1100480_iso-8859-1 the following sql works with DB2 UDB V5 for OS390

SELECT CURRENT DATE , SUBSTR(DIGITS(YEAR(CURRENT DATE)),7,4) || '-' || CASE MONTH(CURRENT DATE) WHEN 1 THEN 'JAN' WHEN 2 THEN 'FEB' WHEN 3 THEN 'MAR' WHEN 4 THEN 'APR' WHEN 5 THEN 'MAY' WHEN 6 THEN 'JUN' WHEN 7 THEN 'JUL' WHEN 8 THEN 'AUG' WHEN 9 THEN 'SEP' WHEN 10 THEN 'OCT' WHEN 11 THEN 'NOV' WHEN 12 THEN 'DEC' ELSE ' ' END || '-' || SUBSTR(DIGITS(DAY(CURRENT DATE)),9,2) FROM SYSIBM.SYSDUMMY1 WITH UR; [...] 6986 197 32_Re: Deadlock and isolation level0_18_mebert@AMADEUS.NET31_Mon, 31 Jan 2000 12:15:57 +0100292_us-ascii The CS isolation level will cause a row to be locked as it is fetched, then the lock will be released again for this row when the next row is fetched. That way the row cannot be changed by another application while the cursor is on it (that's why it's called Cursor Stability). [...] 7184 28 48_Regarding OPERATIVE column in sysibm.syspackage.17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Mon, 31 Jan 2000 19:06:30 PST452_- Hello Everybody,

I have a question on OPERATIVE column in SYSIBM.SYSPACKAGE catlogue table. we have like OPERATIVE = Y and OPERATIVE = N. can anybody explain about this OPERATIVE column. and when it is going to put OPERATIVE = N.

because i know VALID = Y or VALID = N in sysibm.syspackage column. when the table or index droped, it will put VALID = N. but i am not able to understand for operative. can anybody help in this issue. [...] 7213 37 52_Re: Regarding OPERATIVE column in sysibm.syspackage.13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 31 Jan 2000 22:42:39 -0500365_iso-8859-1 Hi Ravi, I've been able to keep the differences between Operative & Valid clear by remembering that a plan/package which is inValid can be dynamically rebound at invocation time and remedied without humanoid intervention while a plan/package which is inoperative requires intervention -- the dynamic rebind is not attempted for inoperative objects. [...] 7251 77 52_Re: Regarding OPERATIVE column in sysibm.syspackage.14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU30_Tue, 1 Feb 2000 13:48:13 +1000394_us-ascii Dave, What you say is probably correct. The understanding I have is also that dropping an object makes VALID = 'N' and if the automatic rebind fails then OPERATIVE is marked 'N' so that DB2 won't waste it's time attempting another auto rebind.

Paul.

---------------------- Forwarded by Paul A Redhead/CorpServ/qdot/au on 01/02/2000 13:50 --------------------------- [...] 7329 58 13_Log in DB2 V55_Sudap15_sudap@SCB.CO.TH30_Tue, 1 Feb 2000 11:08:33 +0700262_windows-874 Hello. In the log of db2 (v5 on sp2) , if I want to know who insert,delete,update data in tables. Have you any idea to suggest me how to trace the log file. Otherwise maybe you have other ways to do that. Please suggest me too.

Thanks.