1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2005, week 3 2 72 25_Re: SQL Gurus - part 2!!!14_Randall Ibbott15_randall@QBE.COM31_Mon, 16 May 2005 14:17:37 +1000687_UTF-8 Thanks Terry - works like a treat... appreciate your time. Regards, Randall… “Enjoy the little things in life, for one day you may look back and realise they were the big things.” Robert Brault. Randall Ibbott. Senior Database Administrator Insure IT Services, 3 Figtree Drive, Homebush Bay, NSW, AUSTRALIA Phone: +61 2 9701 7611 Fax: +61 2 9701 7503 Mobile: +61 0400 834 769 Email: randall@qbe.com ________________________________________________________________________ IMPORTANT NOTICE : The information in this email is confidential and may also be privileged. If you are not the intended recipient, any use or dissemination of the information and any disclosure or [...] 75 64 28_Validate(run) quick question13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 16 May 2005 13:31:50 +0100620_iso-8859-1 All,

z/OS 1.6, DB2 V7.1 at, as you all know now, PUT0403.

It seems I've been under a misconception for the last, like, forever. Binding packages validate(bind) means any references to objects that don't exist or for which the package owner isn't authorised to access will cause the bind to fail. I had assumed that validate(run) would do exactly the same checking at package execution time (which is true) every time the package is executed (which seems not to be true). It seems once a statement in a package bound validate(run) as been validated the runtime mini-binding of the statement [...] 140 217 30_Re: -556 on Revoke SYSPACKAUTH14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Mon, 16 May 2005 07:22:35 -0500527_US-ASCII I tried BY ALL - same result. I tried set sqlid to the grantor and with/without the BY ALL, still got the -556.

Maybe I will have to log on using my predecessor's user-id.

thanks, Mark Vickers.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~





"Sinha, Amit" Sent by: DB2 Data Base Discussion List 05/13/2005 04:09 PM Please respond to DB2 Database Discussion list at IDUG [...] 358 30 57_Re: Anyone used DSNACICS (supplied SP to run a CICS pgm)?10_Jorg Lueke21_jorg_lueke@EFUNDS.COM31_Mon, 16 May 2005 07:50:37 -0500547_- On Sat, 14 May 2005 10:09:11 -0400, Rob Stein wrote:

>z/os, DB2 Version 7 under WLM. > >We want to have an application stored procedure - app1 - call DSNACICS to run a CICS program. The issue we are having is that DSNACICS appears to need to run in an APF library and so does the application app1 SP that calls it. > >We would prefer not to have an application library APF authorised, so has anybody found a way to get this working? If not can you describe the steps you took to get this working? > >Thanks [...] 389 124 37_Re: Good V7 PUT level to be on for V811_Chris White18_crick616@YAHOO.COM31_Mon, 16 May 2005 07:56:10 -0500486_ISO-8859-1 Interesting discussion. Here's a little war story to illustrate the importance of fallback/toleration maintenance...

Under the best of circumstances (which rarely occur in the wild), it takes at least 6 weeks to migrate a new release through all our environments. More realistically, it might take 2 - 3 months (or more) to get the job done because of scheduling competition and also (perhaps more significantly) to gain everyone's confidence in the new release. [...] 514 27 37_Re: Good V7 PUT level to be on for V819_Luis Enrique Valdez27_evaldez@BANCOFRANCES.COM.AR31_Mon, 16 May 2005 08:15:04 -0500318_- Hi Lock:

I have the same doubts as Raymond (although I'm a Certified DBA, I still have some questions pending...). Our DB2 is at the same PUT level (0403).

We're in the process of migrating to z/OS 1.4 before new year and I know that inmediately after that DB2 will be next in line for migration. [...] 542 20 32_Re: Validate(run) quick question12_Adam Baldwin19_y0027528@ES.IBM.COM31_Mon, 16 May 2005 08:25:32 -0500363_- Raymond,

re your point (2) - my understanding is that VALIDATE (RUN) will validate object existence and security EACH time the PLAN/PACKAGE is executed - that is to say that each SQL statement is validated each time that it is executed.

Like you, if this is not the case, I would like someone to explain what does happen with VALIDATE (RUN). [...] 563 274 30_Re: -556 on Revoke SYSPACKAUTH10_Tee, Chris21_Chris.Tee@EU.SONY.COM31_Mon, 16 May 2005 14:48:25 +0100422_- Mark

You will have to free the plan or bind it without .* in the packagelist as it is an implicit grant done by the original bind.

Chris Tee DB2 DBA Sony IS: Europe Tel: +44 (0) 1256 82 8342

-----Original Message----- From: Mark E Vickers [mailto:MarkVickers@GROCERYBIZ.COM] Sent: Monday, May 16, 2005 1:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] -556 on Revoke SYSPACKAUTH [...] 838 73 57_Re: Anyone used DSNACICS (supplied SP to run a CICS pgm)?12_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Mon, 16 May 2005 08:51:27 -0500491_us-ascii We haven't used this stored procedure, but I'm surprised it would work this way. You do you have app1 executing in a different SP proc, right? You can't mix APF and non-APF libraries in a steplib.

Tina Hilton

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke Sent: Monday, May 16, 2005 7:51 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Anyone used DSNACICS (supplied SP to run a CICS pgm)? [...] 912 171 37_Re: Good V7 PUT level to be on for V812_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Mon, 16 May 2005 08:55:19 -0500409_us-ascii That's why I used the feature in IBMLink to notify me when the informational apar changes (I think it's called "tracking"). As long as IBM updates that in a reasonable amount of time, I'd know if a new PTF came out. When I upgraded from V5 to V6, a couple of new ones did come out while I was upgrading systems, but luckily for me they were for data sharing or some other feature we didn't use. [...] 1084 14 57_Re: Anyone used DSNACICS (supplied SP to run a CICS pgm)?10_Jorg Lueke21_jorg_lueke@EFUNDS.COM31_Mon, 16 May 2005 09:31:36 -0500361_- Right, we had everything for the test in dev in APF libraries. The WLM_RECYCLE proc also needs to be in an APF library so we had moved the stored proc code into the environment we use for that proc. Same with teh actual app code, we manually copied intoan existing APF library. So everything in the steplib was authorized which is a pain but it did run. [...] 1099 48 57_Re: Anyone used DSNACICS (supplied SP to run a CICS pgm)?12_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Mon, 16 May 2005 09:42:31 -0500449_us-ascii I have a separate SP proc for the IBM stuff and the application programs are in their own. Then you don't have that problem. I thought that was the recommended way to do it.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke Sent: Monday, May 16, 2005 9:32 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Anyone used DSNACICS (supplied SP to run a CICS pgm)? [...] 1148 64 32_Re: Validate(run) quick question13_Fleming, Mark21_MFLEMING@ALLSTATE.COM31_Mon, 16 May 2005 10:47:10 -0500624_US-ASCII Adam,

My understanding with VALIDATE RUN is that at bind time, all objects are checked. Any statements that fail to bind, say, because a table (or alias or view) isn't found, are marked. At run time, only those statements that were 'marked' at bind time are re-validated (rechecked), but only if they are referenced. A sort of autobind occurs for that statement. If the autobind of that statement is successful (i.e., security/authorization is okay, objects exists, etc.) then that statement can then be executed. This mini-auto bind is only done for statements that get referenced at run time and only [...] 1213 30 33_DM Threshold in DSNDB07 being hit12_Bob Jeandron21_bobjeandron@YAHOO.COM31_Mon, 16 May 2005 08:48:26 -0700406_us-ascii Have new app. issuing selects without wheres and sorting. They are blowing DM threahold in BP7, DSNDB07 sort Pool. Currently Have 60000 VPs 0 HPs. DWQT(90) VDWQT(80). Hit ratio approx. 70%. Have increased VP to 70000 and DWQT to 60, VDWQT to 50 in attempt to relieve situation. Is this an advisable course of action? How big should I increase BP7 before forcing more writes (100000, 150000)? [...] 1244 359 30_Re: -556 on Revoke SYSPACKAUTH14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Mon, 16 May 2005 10:52:15 -0500653_US-ASCII That worked. thanks for your time, Mark Vickers.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~





"Tee, Chris" Sent by: DB2 Data Base Discussion List 05/16/2005 08:48 AM Please respond to DB2 Database Discussion list at IDUG



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject Re: -556 on Revoke SYSPACKAUTH











Mark

You will have to free the plan or bind it without .* in the packagelist as it is an implicit grant done by the original bind. [...] 1604 15 49_Re: Condtional Reorg using OFFPOSLIMIT V8 db2/3909_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 16 May 2005 11:08:57 -0500671_- Can you post the exact job output? The only difference in V8 is that REORG now treats an implicit clustering index equally with an implicit clustering index.

Jim Ruddy DB2 for z/OS Develoment

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 1620 92 37_Re: DM Threshold in DSNDB07 being hit14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Mon, 16 May 2005 09:26:13 -0700378_us-ascii If I had to make an ordered list of I/O disasters that could strike a data base sort buffer pool it would probably look like Thrashing Sync Writes (a requester for an empty buffer or read must wait for write to clear space) Reads means the bufferpool actually ran out of space and buffers HAD to be externalized Writes (this could in fact be preventive in nature) [...] 1713 266 37_Re: DM Threshold in DSNDB07 being hit12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 16 May 2005 19:54:09 +0200649_us-ascii Hi,

This is from Chuck Hoover presentation:

"Set the vertical deferred write threshold (VDWQT) for the dedicated sort buffer pool to:

0.2 * (100 / number of data sets allocated to DSNDB07-the sort work database)."

The number of datasets(tablespaces) used in DSNDB07 affects the efficiency and concurrency of the writes.(IY)





Isaac Yassin





_____

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Avram Friedman Sent: Monday, May 16, 2005 6:26 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DM Threshold in DSNDB07 being hit [...] 1980 75 32_Re: Validate(run) quick question20_Christopher J Pomasl19_pomasl@STARBAND.NET31_Mon, 16 May 2005 11:20:59 -0600526_iso-8859-1 In reading the manual, this is indeed how it works. With VALIDATE(BIND) , all objects and authorities are checked at BIND time and the BIND fails if there are any missing objects or insufficient authorities. With VALIDATE(RUN), all objects and authorities are also checked at bind time, but missing objects or insufficient authority is noted and rechecked when the SQL is executed at run time. Please note my emphasis below, as this aspect may or may not be clear regarding on WHOM the authorization is based. [...] 2056 198 37_Re: DM Threshold in DSNDB07 being hit19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Mon, 16 May 2005 12:23:42 -0500572_us-ascii

I like Avram's assessment of the problem. And of course, writing a page out doesn't mean the page has to disappear from the buffer pool. It just means it becomes a good candidate for re-use, if necessary.

Personally I like your VDWQT(50) setting but if you're still seeing Sync Writes. that is the first number I'd reduce to help protect the buffer pool from thrashing. Very large sorts are going to have to write the pages out anyway, so a lower VDWQT setting will just help the BP do what it needs to do a little sooner. Conversely a little [...] 2255 40 49_Re: Condtional Reorg using OFFPOSLIMIT V8 db2/39015_Philip Sevetson19_psevetson@GMAIL.COM31_Mon, 16 May 2005 14:46:28 -0400718_ISO-8859-1 Jim, do you mean that implicit and *explicit* clustering indexes are treated in the same way?

--Phil Sevetson IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for OS/390

On 5/16/05, Jim Ruddy wrote: > Can you post the exact job output? The only difference in V8 is that REORG > now treats an implicit clustering index equally with an implicit clustering > index. > > Jim Ruddy > DB2 for z/OS Develoment > > --------------------------------------------------------------------------------- > Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join [...] 2296 13 49_Re: Condtional Reorg using OFFPOSLIMIT V8 db2/3909_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 16 May 2005 15:09:07 -0500586_- Yes - so REORG no longer treats them differently than the data manager.

Jim Ruddy DB2 for z/OS Development

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 2310 22 32_Re: Validate(run) quick question12_Adam Baldwin19_y0027528@ES.IBM.COM31_Tue, 17 May 2005 05:17:19 -0500438_ISO-8859-1 Christopher,

Which manual are you quoting from? I've done a quick search and can't find the quoted section. What you (and IBM) are saying would make more sense. In the DB2 Developers Guide (Fifth Edition) - Craig Mullins - he also states that VALIDATE (RUN)..."imposes a potentially severe performance degradation because each SQL statement is validated each time it is executed". There is clearly some confusion! [...] 2333 17 45_CPU increase after upgrade to DB2 for z/OS V818_Hans-Ulrich Blumer32_Hans-Ulrich.Blumer@WINTERTHUR.CH31_Tue, 17 May 2005 05:58:49 -0500752_- Hi DBAs We are speculating on how much the increase of CPU there will be of the whole DB2 workload after migration to V8. So, I'm interesting to hear from you of your experience. The percentage might be exactly measured or approximately guessed.

With kind regards Hansueli

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 2351 17 0_12_David Wilson19_dbawilson@GMAIL.COM31_Tue, 17 May 2005 12:57:34 +0100531_ISO-8859-1 db2-l stop

-- David Wilson +44-7916-268306

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 2369 16 13_MS SQL to Db23_lan18_lxw176@HOTMAIL.COM31_Tue, 17 May 2005 09:19:52 -0500597_- Hi,

Does anyone can tell me how to import tables from MS SQL 7.0 database into DB2 UDB 8.1 on AIX?

Thanks! Lan

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 2386 241 49_Re: Condtional Reorg using OFFPOSLIMIT V8 db2/39012_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Tue, 17 May 2005 09:42:41 -0500549_- Jim, here is the output from the reorg reportonly job unedited. This table has 4 indexes on it and the first one 'odwix547' is an explicit clustering index. Since the table has an explicit clustering index, there is no implicit clustering index, however the reorg is still checking all indexes to see whether or not to do a reorg. Are you saying the reorg was changed to treat all of these indexes alike? Even though this ts has an explicit clustering index and no implicit clustering indexes? This is a simple tablespace with 1 table in it. [...] 2628 43 17_Re: MS SQL to Db218_Lombardozzi, Bryan25_Bryan_Lombardozzi@CSX.COM31_Tue, 17 May 2005 10:47:45 -0400359_us-ascii Export the tables from SQL Server using delimited format the Hi,

Export the tables from SQL Server using delimited format the use the load command for UDB specifying DEL for the input file.



Sample of a load for UDB using delimited format. The nonrecoverable will keep the tablespace from be put in a backup pending status. [...] 2672 48 25_AW: [DB2-L] MS SQL to Db212_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 17 May 2005 16:46:20 +0200850_iso-8859-1 Lan,

take a look at http://www.redbooks.ibm.com/redpieces/abstracts/sg246672.html

HTH.

With kind regards - mit freundlichen Gruessen, Georg H. Peter c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- We don't make mistakes - only happy accidents.

-----Ursprngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von lan Gesendet: Dienstag, 17. Mai 2005 16:20 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: [DB2-L] MS SQL to Db2 [...] 2721 20 11_DB2 Connect6_Shauna24_shauna.hadden@BCBSKS.COM31_Tue, 17 May 2005 09:48:34 -0500458_- We have a vendor application that claims they are using an IBM DB2 driver to connect to zOS DB2 V7, yet not using DB2 Connect.

A trace on DB2 shows that it is using typical DB2 Connect packages, such as SYSSTAT and SYSSH200. The Lan Admin installed DB2 Connect on the workstation, but has turned off all DB2 services "because the vendor says it does not use DB2 Connect." We noticed that the DB2Diag logfile has entries in it for current date. [...] 2742 42 53_Wrong choice for a CCSID - Which is the best way out?19_Luis Enrique Valdez27_evaldez@BANCOFRANCES.COM.AR31_Tue, 17 May 2005 09:51:49 -0500384_- Hi:

Almost two years ago, when I migrated to DB2 V7, somewhere I found that the 'safe' default value for the EBCDIC CCSID was 500.

I did a PUT LEVEL upgrade of our DB2 libraries and now I'm being warned (thru DSNT526I message) that I also have to choose the ASCII CCSID and while doing my homework, I found out that the EBCDIC CCSID chosen for our site is wrong. [...] 2785 59 15_Re: DB2 Connect12_Jim McAlpine22_Jim.McAlpine@CEDAR.COM31_Tue, 17 May 2005 16:01:47 +0100448_iso-8859-1 Yes, if the application is using the pure Java JCC Type 4 driver. There is no underlying software required.

Jim McAlpine

-----Original Message----- From: Shauna [mailto:shauna.hadden@BCBSKS.COM] Sent: 17 May 2005 15:49 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Connect



We have a vendor application that claims they are using an IBM DB2 driver to connect to zOS DB2 V7, yet not using DB2 Connect. [...] 2845 94 32_Re: Validate(run) quick question13_Bell, Raymond22_raymond.bell@LANDG.COM31_Tue, 17 May 2005 16:09:27 +0100585_iso-8859-1 All,

Two things:

1) Thanks for all the feedback. The one thing that still seems to be in doubt - in my mind, at least - is if the re-validation of statements that failed the bind-time processing occurs EVERY TIME (apologies for shouting) the statement is subsequently executed or only until originally failing statements are successfully validated. It's relatively academic for us as the only statements that would fail would be ones they shouldn't be executing anyway (i.e. insert/update/deletes in our read-only environment) but I'd still like to know. [...] 2940 82 15_Re: DB2 Connect14_Shaul Bergfeld18_Sbergfeld@TACT.COM31_Tue, 17 May 2005 11:32:48 -0400482_us-ascii I read once, in a medical novel, an interesting definition for the Hebrew word "CHUTZPAH" (effrontery). It said there that "CHUTZPAH" is trying to accomplish something you have NO chance of accomplishing, and... accomplishing it ANYHOW !!!

Why am I telling you this?

Well, because it seems it is indeed possible to connect to DB2 OS/390 (and VSAM, and IMS) without using anything else, such as a DB2 Driver, DB2 Connect, nor even the Operating System... [...] 3023 94 15_Re: DB2 Connect12_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Tue, 17 May 2005 10:59:44 -0500425_us-ascii You still need to be licensed for DB2 Connect, though, so it's not free.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jim McAlpine Sent: Tuesday, May 17, 2005 10:02 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Connect

Yes, if the application is using the pure Java JCC Type 4 driver. There is no underlying software required. [...] 3118 39 49_Re: CPU increase after upgrade to DB2 for z/OS V815_nguyen duc tuan17_ndt.db2@GMAIL.COM31_Tue, 17 May 2005 18:06:19 +0200695_ISO-8859-1 check recent redbook v8 perf topics

On 5/17/05, Hans-Ulrich Blumer wrote: > Hi DBAs > We are speculating on how much the increase of CPU there will be of the > whole DB2 workload after migration to V8. > So, I'm interesting to hear from you of your experience. > The percentage might be exactly measured or approximately guessed. > > With kind regards > Hansueli > > --------------------------------------------------------------------------------- > Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home > page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select > "Join or Leave the list". The [...] 3158 175 32_Re: Validate(run) quick question13_Fleming, Mark21_MFLEMING@ALLSTATE.COM31_Tue, 17 May 2005 11:29:13 -0500581_iso-8859-1 Raymond,

I believe that the mini-bind occurs the first time the statement is referenced but is not re-bound *each* time the statement is referenced during the run unit. If the package is referenced by a transaction system, like CICS or by a stored procedure, then each time the package is run and that marked statement is executed, it will be bound. If the statement is executed multiple times in the same run unit, it's only bound once. If it's used in a batch job, it'll be bound once (if the statement is executed), but not *every* time that statement is [...] 3334 49 15_Re: DB2 Connect18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 17 May 2005 12:44:04 -0400412_us-ascii It can be done with a Java Type 4 driver BUT you are still required to buy the licensing for the DB2 Connect product, to my knowledge. So it ain't gonna be free! :-)

--Steve....

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Shauna Sent: Tuesday, May 17, 2005 10:49 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Connect [...] 3384 18 54_Calling a CICS transaction from a DB2 stored procedure17_Bryan Lombardozzi25_bryan_lombardozzi@CSX.COM31_Tue, 17 May 2005 12:02:40 -0500693_- Hello,

We are trying to call a CICS transaction from a db2 stored procedure. If anyone has done this could you please send an example of the syntax.

Thanks,

Bryan Lombardozzi DB2 Support and Services

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 3403 93 54_Calling a CICS transaction from a DB2 Stored Procedure18_Lombardozzi, Bryan25_Bryan_Lombardozzi@CSX.COM31_Tue, 17 May 2005 13:12:47 -0400797_us-ascii Hello,





We are trying to call a CICS transaction from a DB2 stored procedure. Does anyone have an example of syntax to do this.





Thanks,





Bryan Lombardozzi

DB2 Support and Services

CSX Technology







----------------------------------------- This email transmission and any accompanying attachments may contain CSX privileged and confidential information intended only for the use of the intended addressee. Any dissemination, distribution, copying or action taken in reliance on the contents of this email by anyone other than the intended recipient is strictly prohibited. If you have received this email in error please immediately delete it and notify sender at the above [...] 3497 333 58_Re: Calling a CICS transaction from a DB2 Stored Procedure12_McKown, John26_john.mckown@UICIINSCTR.COM31_Tue, 17 May 2005 12:24:01 -0500277_US-ASCII Well, I don't know how to do it, but I do have a question that I think needs to be answered. Does the SP need to get some sort of result back from the CICS transaction, or can the CICS transaction just execute asynchronously? I think that will make a difference. [...] 3831 22 24_[v7 z/OS] Empty LISTDEF?15_Philip Sevetson19_psevetson@GMAIL.COM31_Tue, 17 May 2005 13:25:42 -0400342_ISO-8859-1 We're building a variable-input REORG utility using a LISTDEF/TEMPLATE approach. If we don't have anything to put in the LISTDEF, can we run the job with the LISTDEF empty (what return code will it get)? Does anyone know?

-- --Phil Sevetson IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for OS/390 [...] 3854 83 32_Re: Validate(run) quick question20_Christopher J Pomasl19_pomasl@STARBAND.NET31_Tue, 17 May 2005 11:37:01 -0600452_iso-8859-1 Sorry I did not attribute the quote correctly. It actually came from a pre-release version of the DB2 V8 SQL Reference, dated August, 2003 in PDF format. The reference had no revision bars associated so the reference should at least be valid for V7 also.

Exact location is: Chapter 2. Language Elements/Authorization IDs and Authorization Names/Authorization IDs and statement preparation/last two paragraphs of this subsection. [...] 3938 310 58_Re: Calling a CICS transaction from a DB2 Stored Procedure12_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Tue, 17 May 2005 13:22:56 -0500538_us-ascii Can you just call the DSNACICS stored procedure to execute the CICS transaction? I've never done it, but it's there unless your DB2 is a really old release.





Tina Hilton

Random House Bertelsmann Shared Services





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lombardozzi, Bryan Sent: Tuesday, May 17, 2005 12:13 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Calling a CICS transaction from a DB2 Stored Procedure [...] 4249 118 15_Re: DB2 Connect12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 17 May 2005 21:43:07 +0200424_us-ascii Hi,

A company called CORIGIN developed and marketed a product like that. I don't have the full details, but last I've heard they went out of business.



Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Shaul Bergfeld Sent: Tuesday, May 17, 2005 5:33 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Connect [...] 4368 97 58_Re: Calling a CICS transaction from a DB2 Stored Procedure15_Leon Katsnelson15_leon@CA.IBM.COM31_Tue, 17 May 2005 14:56:52 -0400676_US-ASCII What you want is an already made stored procedure called DSNACICS. You can find additional information on this in APAR PQ47595: NEW STORED PROCEDURE FOR CALLING CICS TRANSACTIONS at http://www-1.ibm.com/support/docview.wss?uid=swg1PQ47595.

There is also information on this in this article that I co-authored at http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0504zikopoulos/ as well as in the following red books: DB2 for z/OS Stored Procedures: Through the CALL and Beyond http://www.redbooks.ibm.com/abstracts/SG247083.html?Open Distributed Functions of DB2 for z/OS and OS/390 http://www.redbooks.ibm.com/abstracts/SG246952.html?Open [...] 4466 11 15_Re: DB2 Connect6_Shauna24_shauna.hadden@BCBSKS.COM31_Tue, 17 May 2005 14:12:25 -0500587_- Is there a way to tell, by looking at the machine...if they are using the type 4 driver....such as log files, etc?

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 4478 30 8_DSNACICS8_Michelle26_mmetcalf@NOTES.STATE.NE.US31_Tue, 17 May 2005 14:39:08 -0500399_- I've seen the recent threads on the topic of DSNACICS including today's. We are experincing problems too when calling DSNACICS. I have a batch cobol program calling DSNACICS which runs a CICS program with an update to a DB2 table in it - very simple process! Well, I continue to get the DSNT530I but I have checked and my jcl only has 3 libraries in the STEPLIB and ALL 3 are APF authorized. [...] 4509 34 28_Re: [v7 z/OS] Empty LISTDEF?15_Andersen, Cindy18_candersen@FNNI.COM31_Tue, 17 May 2005 15:21:01 -0500620_iso-8859-1 Here is what you get:

DSNU1008I -DBD1 DSNUILSA - LISTDEF LISTDF1 CONTAINS NO OBJECTS DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

________________________________

From: DB2 Data Base Discussion List on behalf of Philip Sevetson Sent: Tue 5/17/2005 12:25 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] [v7 z/OS] Empty LISTDEF?

We're building a variable-input REORG utility using a LISTDEF/TEMPLATE approach. If we don't have anything to put in the LISTDEF, can we run the job with the LISTDEF empty (what return code will it get)? Does anyone know? [...] 4544 53 23_Resource Limit messages14_Gonella, Vamsi22_Vamsi.Gonella@21ST.COM31_Tue, 17 May 2005 13:44:24 -0700712_iso-8859-1 Hi Listers,

We are on DB2 V7 PUT 0411 and Z/OS 1.4.

Is there any way we can capture the Resource limit related messages into MSTR's JES message log?

Ex: DSNT408I SQLCODE = -905, ERROR: UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING EXCEEDED, RESOURCE NAME = ASUTIME LIMIT = 000000000320 CPU SECONDS (000003000000 SERVICE UNITS) DERIVED FROM SYSIBM .DSNRLST01 DSNT418I SQLSTATE = 57014 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 101 13172746 0 13231829 -641327090 12714050 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000065' X'00C9000A' X'00000000' X'00C9E6D5' X'D9C6200E' X'00C20042' SQL DIAGNOSTIC INFORMATION [...] 4598 52 79_IDUG 2005 - North America, May 22-26, Denver. You can still REGISTER to attend.35_Mike Skaff - Colorado zOS UG Leader28_mike.skaff@FIRSTDATACORP.COM31_Tue, 17 May 2005 15:43:00 -0500458_ISO-8859-1 You can still REGISTER to attend the IDUG 2005 - North America Conference!!

Register via fax or Onsite using the print-friendly version of registration form.

Can't get away for four days? Join us for one or two and still reap the rewards that IDUG 2005 -- North America has to offer. Register today . [...] 4651 69 28_Re: [v7 z/OS] Empty LISTDEF?11_Hardy, Dale14_DHardy@MIB.COM31_Tue, 17 May 2005 17:30:10 -0400781_us-ascii You can include an empty list with a valid list.

LISTDEF LS2SUNIQ INCLUDE TABLESPACE ODS0121.T221S <-- valid tablespace INCLUDE TABLESPACE DIS0108.* <-- database exists, but doesn't have any tablespaces

DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TESTLIST

DSNUGUTC - COPY LIST LS2SUNIQ SHRLEVEL REFERENCE COPYDDN(TMTRKIC1) -DB2T DSNUILSA - LISTDEF LS2SUNIQ CLAUSE IDENTIFIES NO NEW OBJECTS: INCLUDE TABLESPACE DIS0108.% DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TMTRKIC1 DDNAME=SYS00001 DSN=NDBAT.IC.DB2T.ODS0121.T221S.G0005V00 DSNUBBID - COPY PROCESSED FOR TABLESPACE ODS0121.T221S NUMBER OF PAGES=3 AVERAGE PERCENT FREE SPACE PER PAGE = 28.33 PERCENT OF CHANGED PAGES = 16.66 ELAPSED TIME=00:00:00 -DB2T DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR [...] 4721 411 79_LEARN ABOUT VERITAS SOFTWARE SOLUTIONS FOR DB2 UDB AT IDUG 2005 - NORTH AMERICA13_Ram Narayanan25_Ram.Narayanan@VERITAS.COM31_Tue, 17 May 2005 15:39:05 -0700499_US-ASCII SUBJECT: Learn about VERITAS Software Solutions for DB2 UDB at IDUG 2005 - North America





May 22 - 26, Denver, Colorado

Achieve your performance and availability objectives, while reducing the headaches of managing complex DB2 environments. VERITAS Software offers integrated solutions for DB2 UDB, including the industry's leading database storage management, clustering and performance-boosting technologies - several of them co-developed with DB2 Labs. [...] 5133 16 49_Re: Condtional Reorg using OFFPOSLIMIT V8 db2/3909_Jim Ruddy18_jaruddy@US.IBM.COM31_Tue, 17 May 2005 17:50:34 -0500640_- Mike,

The other indexes are incorrectly being identified as clustering. Please open a problem with the support center.

Jim Ruddy DB2 for z/OS Development

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 5150 52 45_Visit ITgain Booth #214 at IDUG North America15_john flickinger20_john_db2@HOTMAIL.COM31_Tue, 17 May 2005 21:10:56 -0500609_- Stop by the ITgain booth and review the standard in DB2 UDB Monitoring for Linux, UNIX and Windows -- Speedgain for DB2 from ITgain. See how you can achieve breakthrough DB2 performance using the Speedgain DB2 Monitor and performance database(PDB). Speedgain for DB2 truly enables DBAs to answer questions like what happened at 2PM yesterday, the day before or week or even month before at a particular time. Speedgain uses low overhead snapshot monitoring and inserts monitoring data into DB2 tables in the Speedgain PDB. Speedgain enables DBAs to go back in time and identify what was running at the [...] 5203 89 58_Re: Calling a CICS transaction from a DB2 Stored Procedure18_Peter Zillo Jensen16_jjensen6@CSC.COM31_Wed, 18 May 2005 09:09:20 +0200944_US-ASCII Hello,

Search after DSNACICS in the manuals.

(or use this link)

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnaph14/APPENDIX1.9.2?ACTION=MATCHES&REQUEST=dsnacics&TYPE=FUZZY&SHELF=&DT=20041112162639&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT



Regards, Peter Zillo ----------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ---------------------------------------------------------------------------------------- [...] 5293 61 29_Re: AW: [DB2-L] MS SQL to Db216_Robin Willoughby25_willoughbyr@UK.TIGPLC.COM31_Wed, 18 May 2005 04:29:34 -0500510_ISO-8859-1 Lan, assuming you have access to MS SQL Sever (and the fact you are trying to move data from SQL Server implies that you do...) another easy way to get the data onto DB2 is to use SQL Servers DTS tool (Import and Export Data tab on Start/Programs/SQl Server) - this works quite well and will create the tables are part of the export/import process (if required) - you will need DB2 Connectivity on the SQL Server machine - I think you should have Windows clients supplied with your Aix DB2 s/w [...] 5355 13 31_Compression & Recovery question12_Billy Larsen19_billarsen@YAHOO.COM31_Wed, 18 May 2005 05:18:27 -0500581_- Dear all,

compressed records are stored compressed in the log. What happens if this has been rebuilt?

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 5369 32 57_Re: Wrong choice for a CCSID - Which is the best way out?12_Roy Cornford19_cornford@US.IBM.COM31_Wed, 18 May 2005 05:32:55 -0500476_- Enrique,



SVL DB2 Development can assist you with this. The procedure is to use the PMR process to make initial contact with them. For those outside the USA, ask you local IBM Support to route the PMR to DB2 Development.

The initial entry in the PMR need only include something like:

We have identified a mismatch between our emulator CCSID and DB2 (or we have more than one CCSID in DB2 subsystem etc.) and require guidenance on resolving. [...] 5402 31 51_Access to data on Z/OS from client apps thru TCP/IP10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 18 May 2005 05:39:12 -0500583_- Hi,

Many of you probably have production applications on the mid-tier (Windows, Unix) accessing DB2 data on the host (z/os) directly using TCP/IP.

Did anyone have to do any study of the security risks that may be caused by exposing such legacy data to the outer world thru TCP/IP ? The good old SNA was and used to be considered very reliable. Somehow, inspite of TCPIP being used in the mainframe world for quite some time now, there are still questions raised in some places. What precautions (for example, firewalls) if any would we need to take to open this [...] 5434 48 35_Re: Compression & Recovery question14_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM31_Wed, 18 May 2005 06:00:58 -0500462_windows-1250 What platform? 'Rebuilding' a log is not a DB2 for z/OS concept.

Andy Lankester

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Billy Larsen Sent: Wednesday, May 18, 2005 11:18 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Compression & Recovery question

Dear all,

compressed records are stored compressed in the log. What happens if this has been rebuilt? [...] 5483 17 35_Re: Compression & Recovery question15_nguyen duc tuan17_ndt.db2@GMAIL.COM31_Wed, 18 May 2005 14:46:15 +0200671_ISO-8859-1 i suppose that the compression dictionary is either in the image copy (or in the log if the dictionary is rebuilt and LOG YES) , then DB2 will read syscopy to get all these informations ...

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 5501 51 35_Re: Compression & Recovery question53_Leedom, Robert --- Sr. Database Administrator --- CFS31_Robert.Leedom@FREIGHT.FEDEX.COM31_Wed, 18 May 2005 07:03:20 -0600308_us-ascii The compression dictionary is only rebuilt upon a reorg. Which then requires a new imagecopy to be taken as part of that reorg or immediately after for recovery of such issues as per your concern. That is the row could now have a different compression dependant upon the data now in the table. [...] 5553 26 53_DB2/UDB for Solaris - Persistent db2bp too persistent0_22_drdeath@OZEMAIL.COM.AU31_Wed, 18 May 2005 22:55:16 +1000463_ISO-8859-1 Having an odd problem with UDB.

Trying to backup LDAP database and it keeps failing with Database in use.

We have a cron job which stops ibmslapd and then issues a force applications all followed by a loop of list applications. When the list issues a SQL1611W (no applications), it issues the backup database ldapdb2. What appears to be happening is that db2bp is reconnecting before the backup gets in and hence the in use message. [...] 5580 125 106_Dynamic SQL is everywhere, and it is negatively impacting your DB2 performance...see you in Denver at IDUG10_David Kane14_dkane@TACT.COM31_Wed, 18 May 2005 09:28:25 -0400345_us-ascii Visit TACT Software's Booth # 422 at IDUG Denver May 23-25 for a live demo, fun & prizes, and to learn how EZ-DB2 captures and consolidates all dynamic & static SQL Statements.

Also see Sheryl Larsen present "The Impact of Dynamic SQL on Performance Tuning & Index Design (For DB2 on z/OS)" Wed. May 25 at 2PM, IDUG Denver. [...] 5706 45 32_Documentation for Visual Explain0_20_jane.leyba@PCIAA.NET31_Wed, 18 May 2005 08:43:06 -0500417_US-ASCII What's the best source for documentation on Visual Explain? Specifically we want to view samples of the output and what the output will really tell us and compare it to other outputs as a result for executing explains.





Jane Leyba IDUG 2005 NACPC Manager, Business Support ISS, Inc. (847) 553-3642

--------------------------------------------------------------------------------- 5752 64 57_Re: DB2/UDB for Solaris - Persistent db2bp too persistent14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Wed, 18 May 2005 09:49:39 -0400398_- Cleaner way is to recycle the instance, cleanup the db2 processes, quiesce the instance/database, then start the offline backup.

db2stop force db2_kill ipclean -a db2start

db2 "quiesce instance immediate" Start backup.

If there are multiple databases in the instance and you cannot recycle the instance: db2 "quiesce db immediate" Start backup. [...] 5817 161 49_Re: Condtional Reorg using OFFPOSLIMIT V8 db2/39012_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Wed, 18 May 2005 08:53:35 -0500316_- Jim,

PMR04619 opened 4-27-2005.

It was after IBM told me it was WAD(working as designed), that I brought it to the list in the hopes that You or someone like you would see it. Thank you for your response and attention to this. Its good to know I havnt lost what little there is left of my mind. [...] 5979 130 70_Antwort: [DB2-L] DB2/UDB for Solaris - Persistent db2bp too persistent0_19_dirk.pohl@SERCON.DE31_Wed, 18 May 2005 15:59:28 +0200615_US-ASCII Hi Tony

I suppose there is no difference between an LDAP and an regular Database .

how about

quiesce database immediate force connections + unquiesce database

Hth Best regards dirk

Am 18.05.2005 14:55:16 schrieb DB2 Data Base Discussion List: > Having an odd problem with UDB. > > Trying to backup LDAP database and it keeps failing with Database in use. > > We have a cron job which stops ibmslapd and then issues a force applications > all followed by a loop of list applications. When the list issues a SQL1611W > (no applications), it issues the backup database [...] 6110 54 28_Re: [v7 z/OS] Empty LISTDEF?14_Seth Bienstock19_sethdb2@COMCAST.NET31_Wed, 18 May 2005 09:06:42 -0500340_- Unfortunately, the way the utilities were designed it will give a return code of 8 as Cindy pointed out. I am of the opinion that the utility should either supply a return code of 4, or provide a way of controlling this (i.e. another OPTION clause).

Evaluate the "list" of objects first, and if the list is empty then either: [...] 6165 368 36_Re: Documentation for Visual Explain4_Phil22_pgunning@GUNNINGTS.COM31_Wed, 18 May 2005 10:26:35 -0400374_us-ascii This is the home page: http://www-306.ibm.com/software/data/db2/zos/osc/ve/ for DB2 for z/OS. Visual Explain has context sensitive help which can be viewed by selecting the operator in question. I'm sure Roger, Terry or Patrick can provide more details. The V8 Visual Explain is quite powerful in enabling DBAs to tune SQL and has a nice reporting capability. [...] 6534 23 19_Physical data model7_Do Park19_doparkdba@YAHOO.COM31_Wed, 18 May 2005 09:23:39 -0500399_- Hello all,

Sometimes I have to review physical data model. Some area is overlap with logical data model. I am a DBA (not application DBA) who I don't provide any supports to buisness area.

What is the best way to reivew physical data model? What do you check when you review physical data model? Do you review logical data model, too? Is there any article (or book) about this? [...] 6558 90 74_Re: Antwort: [DB2-L] DB2/UDB for Solaris - Persistent db2bp too persistent0_22_drdeath@OZEMAIL.COM.AU31_Thu, 19 May 2005 00:35:12 +1000357_ISO-8859-1 Thanks Dirk,

However, I've already tried this and in fact I put back in the force applications all to get rid of the connection that had got back in. Unfortunately, as I understnd it quiesce only restricts access by user auth and since the services are all running under an id with sysadm, restricting acces to sysadm is ineffective. [...] 6649 25 16_timestamp column13_Trace R Jones33_trace.jones@CENTERPOINTENERGY.COM31_Wed, 18 May 2005 09:45:25 -0500384_US-ASCII Hi all,

I'm trying to add a timestamp column to an existing table. This column is not null with default.

I thought that the not null with default on a timestamp column inferred current timestamp. But, what I'm seeing is the default timestamp of:

0001-01-01-00.00.00.000000

How can I get the default of the column to be the current timestamp? [...] 6675 51 20_Re: timestamp column10_Doyle Mark21_Mark.Doyle@WIN-NA.COM31_Wed, 18 May 2005 09:50:54 -0500412_us-ascii According to the manual (SQL Ref, section 5.10), default for an existing row in the table is 0001-01-01 . . . ; default for a new row is current TS.

HTH

Mark

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Trace R Jones Sent: Wednesday, May 18, 2005 9:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] timestamp column [...] 6727 87 20_Re: timestamp column15_Moschelli Mauro31_mauro.moschelli@SANPAOLOIMI.COM31_Wed, 18 May 2005 16:51:46 +0200652_us-ascii It should be current timestamp when you inser a row, but for rows already present before you added the column, it is correct to have the default 0001-01-01-00.00.00.00000

HTH





Mauro Moschelli SanPaoloIMI S.p.A.

-> -----Original Message----- -> From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On -> Behalf Of Trace R Jones -> Sent: Wednesday, May 18, 2005 4:45 PM -> To: DB2-L@WWW.IDUGDB2-L.ORG -> Subject: [DB2-L] timestamp column -> -> -> Hi all, -> -> I'm trying to add a timestamp column to an existing table. -> This column is -> not null with default. -> -> I thought that the not [...] 6815 49 20_Re: timestamp column10_Doyle Mark21_Mark.Doyle@WIN-NA.COM31_Wed, 18 May 2005 09:54:21 -0500401_us-ascii To get current TS on existing rows, either: Update Table set TS column = current timestamp; OR unload table & reload w/o reference to the TS column.

Mark

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Trace R Jones Sent: Wednesday, May 18, 2005 9:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] timestamp column [...] 6865 75 20_Re: timestamp column13_Michael Ebert18_mebert@AMADEUS.NET31_Wed, 18 May 2005 16:59:10 +0200557_US-ASCII The default is CURRENT TIMESTAMP for rows that are newly added to the table after you've run your ALTER. However, your table exists and probably holds rows. When you ADD a column, this just changes the dictionary; the table rows are not updated, i.e. the new column is not "instantiated" (until you do a REORG). DB2 just marks the DBD that you added the column; when you retrieve a row, DB2 checks whether it is "short" and if yes, adds the value 0001-01-01... to the row that is returned to the application. This is the best that DB2 can do; [...] 6941 61 69_UDB V 8.1.7 Infomation Center daemon Config (db2ic.conf) - Linux/UNIX13_George Peters16_geope@US.IBM.COM31_Wed, 18 May 2005 11:12:46 -0400344_US-ASCII Colleagues Is anyone familiar with the DB2 UDB Infomation Center V8.1.7 (LINUX 32 BIT)daemon configuration file (db2ic.conf) in Linux/UNIX env? If so, what is the format, or where is it documented? There is but a brief and passing reference to it in V8.1.7 Release Notes, p.86, and its location, but nothing regarding its format: [...] 7003 47 26_DB2-L] Physical data model14_Seth Bienstock19_sethdb2@COMCAST.NET31_Wed, 18 May 2005 10:17:45 -0500356_- The best way to review a physical model would depend upon what your objectives are. The inputs, outputs, and processes related to the "review" would depend upon those objectives. A "physical data model" IS the implementation and can reviewed simply by looking at the DDL and/or DB2 catalog. A pictorial diagram of that design is invaluable as well. [...] 7051 42 27_tablespace disk space uasge12_Jim McAlpine22_Jim.McAlpine@CEDAR.COM31_Wed, 18 May 2005 16:45:21 +0100551_iso-8859-1 I'm not a dba, but I'm trying to understand the following. I am creating some test tablespaces/tables which have a priqty and secqty equal to 12, a segsize of 4 and a pagesize of 32KB. I understand from the manual that priqty and secqty will be changed to 96 for pagesize 32KB. Fair enough. I create the tablespace and the dsndbd entity has a primary allocation of 2 3390 tracks which again is fair enough. Now I create the table and the dsndbd entity increases to 5 tracks and now has 4 extents where it previously had 1. Anyone care [...] 7094 240 30_Re: DB2-L] Physical data model13_George Peters16_geope@US.IBM.COM31_Wed, 18 May 2005 11:46:46 -0400612_US-ASCII IBM used to have a formal Application Database Design Review process, deriving back from the older IMS days. A document for the DB2 environment was issued in the mid-80's, but I have never seen an update. Many companies write their own Review Processes.

The key thing to look for, IMHO, is to be able to answer the single following question :"Does the proposed design meet the performance requirements of the application?" If not, since coding has not yet commenced (that is the "right way", rarely followed), you can revisit the design, including the logical design. So clearly you need to [...] 7335 92 31_Re: tablespace disk space uasge13_Michael Ebert18_mebert@AMADEUS.NET31_Wed, 18 May 2005 18:14:18 +0200512_US-ASCII I have noticed this behaviour a couple of years back, with 4K-pages. My posting ("segsize oddity") never got a satisfactory answer.

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







From: Jim McAlpine @IDUGDB2-L.ORG on 18-05-2005 16:45

Please respond to DB2 Database Discussion list at IDUG

Sent by: DB2 Data Base Discussion List [...] 7428 235 31_Re: tablespace disk space uasge12_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Wed, 18 May 2005 11:28:04 -0500494_- Im no expert but ill give it a shot. A 3390 track can hold 48k, since you are using 32k pages you will get 1 page per track. The priqty of 96 creates the two track allocation you see when you first create the tablespace. My guess is that the secqty does no go to 96 like you think it does and therefore does not allocate two tracks when it extends. Instead it appears to be allocating 1 track at at time or 48, as that is the smallest you can allocate(ie. 12 becomes 48 no matter what). [...] 7664 126 31_Re: tablespace disk space uasge13_Bright, Randy20_Randy_Bright@BMC.COM31_Wed, 18 May 2005 11:43:07 -0500550_- When you create a segmented tablespace, DB2 "allocates" one segment for each table at the time the table is created. Since you said SEGSIZE 4, four 32K pages (actually 8 4K CI's, unless you have variable CISIZE enabled) are "pre-allocated" for the table. If you create a second table in the tablespace, another four 32K pages will be added, etc. A 3390 device can hold 12 4K CI's on a track, so you will now have 32 4K CI's meaning you will need a little less than three tracks for the one table segment. First extent. Plus three more tracks, [...] 7791 174 0_18_Pohlen Mailinglist24_fjpohlen-maillist@GMX.DE31_Wed, 18 May 2005 18:37:31 +0200568_iso-8859-1 Hi db2 experts,

I have a customer who wants to upgrade from os390 2.9 to zos 1.5. I have setup the zos system and tried to implement his existing SAP DB2 v6.1 database to zos (with the necessary ptfs installed). The migration to v7 will be made in a second step. Everything seems to work fine except spufi. It comes with the error below. I assume that there is an error in implementing the db2 software, but I cannot find where. The DSNTEP2 works normally. The ICLI server can connect to the database, too. The reason code tells something about [...] 7966 235 3_Re:11_Gugel, Rich26_Rich.Gugel@DOA.STATE.WI.US31_Wed, 18 May 2005 11:51:39 -0500635_iso-8859-1 I sometimes get this when the lrecl of my spufi datset does not match the length as set in the defaults. Delete your spufi datset and try a rerun

_____

From: Pohlen Mailinglist [mailto:fjpohlen-maillist@GMX.DE] Sent: Wednesday, May 18, 2005 11:38 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L]



Hi db2 experts,

I have a customer who wants to upgrade from os390 2.9 to zos 1.5. I have setup the zos system and tried to implement his existing SAP DB2 v6.1 database to zos (with the necessary ptfs installed). The migration to v7 will be made in a second step. Everything seems to work [...] 8202 456 3_Re:29_GOODWIN, STANLEY (Contractor)26_GoodwinS.ctr@MECH.DISA.MIL31_Wed, 18 May 2005 13:00:19 -0400336_iso-8859-1 I can honestly admit when we went to ZOS 1.4, we did not experience this. I was wondering though, that since SPUFI must execute out of a loadlib under the ISPLLIB. You might want to make sure all the libraries in the ISPLLIB are APF authorized...........





Stan Goodwin

DB2 Support Decc Mech [...] 8659 364 30_Re: DB2-L] Physical data model13_George Peters16_geope@US.IBM.COM31_Wed, 18 May 2005 13:21:35 -0400459_US-ASCII Do ....

Of course there is the IBM DB2 UDB Design Advisor, clearly discussed in the current DB2 magazine (Q2,2005). This assumes a pretty comprehensive knowledge of the SQL, of course, and is more of a tuning aid that a Review process, but it is there, and available for use. You asked about a book... The one by von Halle and Fleming remains very useful. It's a bit old know, but covers general design principles in a methodical manner. [...] 9024 51 49_DB2 V7 for z/OS: WLM Stored Procedure NUMTCB Parm11_Jay Reavill23_Jay.Reavill@CERTEGY.COM31_Wed, 18 May 2005 13:34:49 -0400390_us-ascii Hello all,

We are running WLM in goal mode. For a 3rd party application we are running we've been advised by them to set the NUMTCB parm for the stored procedure address spaces to 2. At the moment the usage level of the SPs is low. However, we do expect it to increase in the near future. In light of that we feel the setting of 2 seems too low. So my questions are... [...] 9076 62 26_DB2 SQL Reserved word list16_Burnette, George27_George_Burnette@KYFBINS.COM31_Wed, 18 May 2005 13:52:04 -0400352_us-ascii How are the IBM DB2 SQL reserved words used? We have a vendor that has named tablespaces some names from that list and DB2 did not prohibit it. We are using UDB 7.1 for z/OS and will be going to V 8 later in the year and the reserved word list has grown. Are there any consequences of using those reserved words for proprietary purposes? [...] 9139 39 30_Re: DB2 SQL Reserved word list15_nguyen duc tuan17_ndt.db2@GMAIL.COM31_Wed, 18 May 2005 20:05:15 +0200625_ISO-8859-1 check sql ref , somewhere in the appendix

On 5/18/05, Burnette, George wrote: > > > How are the IBM DB2 SQL reserved words used? We have a vendor that has > named tablespaces some names from that list and DB2 did not prohibit it. We > are using UDB 7.1 for z/OS and will be going to V 8 later in the year and > the reserved word list has grown. Are there any consequences of using those > reserved words for proprietary purposes? > > Thanks, > George Burnette > --------------------------------------------------------------------------------- > Welcome to the IDUG DB2-L [...] 9179 172 30_Re: DB2 SQL Reserved word list0_25_LL581@DAIMLERCHRYSLER.COM31_Wed, 18 May 2005 14:18:51 -0400335_US-ASCII George,

There's reserved words and there are Reserved Words :)

For the fun of it, I attempted the following (DB2 V7 for z/OS):

CREATE TABLE FROM (SELECT CHAR (7) NOT NULL, WHERE CHAR (7) NOT NULL, AND CHAR (7) NOT NULL, BETWEEN CHAR (7) NOT NULL, EQUALS CHAR (7) NOT NULL, NULL CHAR (7)) IN TS0023 ; [...] 9352 75 18_00C20200 revisited15_Chris Hoelscher21_choelscher@HUMANA.COM31_Wed, 18 May 2005 14:42:44 -0400490_US-ASCII thanks in advance





I am moving a large application from one subsystem (DBP3) to a new subsystem (DBP8)- as follows:



capture object definitions on DBP3 shutdown DBP3 backup DBP3 appl datasets w/adrdssu add objects to DBP8 (define yes) IDCAMS delete all DBP8 application datasets restore application data from DBP3 backup (change hlq, change all j0001 to I0001 in 5th node) DBP8 repair levelid tablespace ... DBP8 repair levelid index ..... [...] 9428 86 30_Re: DB2-L] Physical data model16_Bhogale, Pushkar24_bhogale.pushkar@MBCO.COM31_Wed, 18 May 2005 14:10:57 -0500518_iso-8859-1 If you are using a modeling tool such as ERwin or Visio 2003 to store a pictorial view of the data model, you can store all sorts of information within that Physical Model. Information that can be stored includes: 1. Index naming standards which can be slightly automated and connected to the table names 2. Bufferpools used for various objects such as tablespace or indexspace 3. Primary and Secondary quantities for various objects used for capacity management 4. Lock sizes used for various objects [...] 9515 82 31_Problem trying to use triggers.9_Dan Lamas22_dlamas@DUKE-ENERGY.COM31_Wed, 18 May 2005 14:41:11 -0500344_US-ASCII Our shop is running os/390 v2.10 DB2 v7

This is my first attempt to use triggers. The developers have asked me to create triggers on some security tables. Every time there is an Update or Delete to these tables they want me to Insert the before image of the row into a History table. I have created the following triggers: [...] 9598 114 35_Re: Problem trying to use triggers.16_Burnette, George27_George_Burnette@KYFBINS.COM31_Wed, 18 May 2005 16:06:23 -0400363_us-ascii Dan,

Am I missing something or does the trigger name in the error message not match the triggers you created ? Also, call me old fashioned, but I usually specify the column names after the insert into authid.tablename ( col1, col2,...) It helps me make sure I am pairing up the columns I want to update with the values I want to put in them. [...] 9713 188 35_Re: Problem trying to use triggers.9_Dan Lamas22_dlamas@DUKE-ENERGY.COM31_Wed, 18 May 2005 15:15:51 -0500763_US-ASCII Sorry about that. I attached the wrong trigger.

There were several new triggers.

Here is the correct one.

CREATE TRIGGER ILS_TETU.SECUSI_U AFTER UPDATE ON GASDB91.SEC_USERID REFERENCING OLD AS OLD_SECUSI FOR EACH ROW MODE DB2SQL INSERT INTO GASDB91.SEC_USERID_H VALUES (OLD_SECUSI.USERID , OLD_SECUSI.CONTACT_ID , OLD_SECUSI.NT_ID_IND , OLD_SECUSI.DB_LGID , OLD_SECUSI.CA_LOGONID , OLD_SECUSI.INTN_EXTN_IND , OLD_SECUSI.DISABLED_IND , OLD_SECUSI.PASSWORD_VL , OLD_SECUSI.HINT_QUESTION_TXT , OLD_SECUSI.HINT_ANSWER_TXT , OLD_SECUSI.UPDATER , OLD_SECUSI.UPDATE_TIMESTAMP , OLD_SECUSI.EMPL_BY_BA_NBR , OLD_SECUSI.USERID_TP , OLD_SECUSI.EFF_FROM_TS , OLD_SECUSI.EFF_THRU_TS , OLD_SECUSI.EMPL_BY_BA_ABBR , OLD_SECUSI.TEMP_ID_IND ) ; [...] 9902 225 35_Re: Problem trying to use triggers.13_Horacio Villa17_hvilla@AR.IBM.COM31_Wed, 18 May 2005 17:42:11 -0300436_US-ASCII Maybe there's a column with a user-defined data type in GASDB91.SEC_USERID, and that's causing the problem?

Horacio Villa





Dan Lamas cc: Sent by: DB2 Data Subject: Re: [DB2-L] Problem trying to use triggers. Base Discussion List



18/05/2005 17:15 Please respond to DB2 Database Discussion list at IDUG [...] 10128 45 30_Re: DB2 SQL Reserved word list20_Christopher J Pomasl19_pomasl@STARBAND.NET31_Wed, 18 May 2005 15:15:38 -0600336_utf-8 Using reserved words as identifiers is in fact allowed, however not recommended.

The use of reserved words without quoting them is dependent on the context. If the context is unambiguous, then the name can be in free text. If the context could be construed one way or the other, then you need to quote the identifier. [...] 10174 64 30_Re: DB2 SQL Reserved word list14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 18 May 2005 17:57:14 -0500580_- I've had -104 errors where un-quoted reserved words have been used in an un- ambiguous context (at least according to the syntax diagrams). IIRC ALTER TABLE xxx DROP FOREIGN KEY can give a syntax error on the word FOREIGN.

The problem is that the syntax analyser doesn't know that a given word is an identifier. At the time it executes all it sees is a string of reserved words, punctuation and "other" stuff. Depending on circumstance the analyser might decide to check if a word is a reserved word rather than assume that only an identifier can be [...] 10239 55 28_Reasonable and Customary SOX13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 18 May 2005 16:12:26 -0700604_us-ascii This is directed towards U.S. companies, and those with U.S. subsidiaries that must adhere to Sarbanes Oxley requirements.

Our internal auditor is asking us to routinely (daily) review our audit trails to make sure that no one with SYSADM authority updated any data improperly -- essentially, to prove we didn't do anything wrong. We tried explaining that the DB2 log is there for forensic analysis, not proactive monitoring. That didn't fly. I would like to argue that our procedures are pretty much "industry standard", so I need to find out what that is. I know there is a lot of [...] 10295 166 68_DB2 V7.1 ZOS SQL Guru : Can someone explain how this query would run15_Kompalli, Shyam31_Shyam.Kompalli@NATIONALCITY.COM31_Wed, 18 May 2005 20:23:35 -0400300_iso-8859-1 Folks

I got a query from someone and the query has a typo error (which I realized later). But, I would like to know how DB2 would run this query(in Plain English). I realized the mistake when query was running for more than an hour and the monitor tool showed massive getpages [...] 10462 104 30_Re: DB2 SQL Reserved word list14_Wayne Driscoll34_wdriscoll@WESTERN-METAL-SUPPLY.COM31_Wed, 18 May 2005 22:34:34 -0500568_US-ASCII Lock, In some instances (like you found) the DB2 parser is extremely smart, and can deal with these issues. It knows for example that you are doing a create table, so it realizes that a "FROM" clause isn't an issue. However, there are times that you do need to quote reserved words. The rule I try to follow is to always quote reserved words (of course then you need to ensure that the case is correct). This will protect me later, as the reserved word list grows. Wayne Driscoll Product Developer Western Metal Supply NOTE: All opinions are strictly my [...] 10567 68 74_Any policy guidelines for Stored Procedures on DB2 for OS/390 and z/OS V7?0_18_PPantazi@LAIKI.COM31_Thu, 19 May 2005 10:07:17 +0300297_us-ascii Our Environment is DB2 for OS/390 and z/OS Version 7 and are just considering the implementation of Stored Procedures.

Since I can not open up the system and tell the developers, start writing SPs; I need to define a policy and pass it on to the them in order to be followed. [...] 10636 124 78_Re: Any policy guidelines for Stored Procedures on DB2 for OS/390 and z/OS V7?4_Peri19_peri.ncst@GMAIL.COM31_Thu, 19 May 2005 13:33:04 +0530627_ISO-8859-1 DB2 for z/OS Stored Procedures: Through the CALL and Beyond http://www.redbooks.ibm.com/redbooks/pdfs/sg247083.pdf

On 5/19/05, PPantazi@laiki.com wrote: > > Our Environment is DB2 for OS/390 and z/OS Version 7 and are just > considering the implementation of Stored Procedures. > > Since I can not open up the system and tell the developers, start writing > SPs; I need to define a policy and pass it on to the > them in order to be followed. > > I expect that the policy will provide consistency among the various SPs in > the system, system healthiness and also avoid any pitfalls [...] 10761 117 22_Re: 00C20200 revisited13_Michael Ebert18_mebert@AMADEUS.NET31_Thu, 19 May 2005 10:14:52 +0200597_US-ASCII This procedure will work only if you get all the internal identifiers (DBID, PSID, OBID, ISOBID) correct which is a rather big "if" (actually you possibly might get away with differing ISOBIDs according to a paper I once read). If DBP8 does NOT hold other objects, then doing a Homogeneous System Copy from DBP3 might be safer. First, check the IDs for differences. Also, the error code says the indexes are formatted differently. If you have a Change Management Tool, you may be able to run a compare between the two subsystems to check whether they really are identically defined. [...] 10879 316 91_Antwort: Re: [DB2-L] Antwort: [DB2-L] DB2/UDB for Solaris - Persistent db2bp too persistent0_19_dirk.pohl@SERCON.DE31_Thu, 19 May 2005 10:59:56 +0200492_US-ASCII Hi Tony

I suppose you have some scripts running db2 clp with sysadm authority . I would take a closer look at these ones .

1. Do they really need to run under sysadm authority . 2. If they get an SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032 you should provide a wait , thats long enough to start your backup 3. Is online backup an alternative ? [...] 11196 117 53_Re: DB2 V7 for z/OS: WLM Stored Procedure NUMTCB Parm14_Dash, Sushanta21_Sushanta.Dash@FMR.COM31_Thu, 19 May 2005 05:18:06 -0400341_us-ascii Hi Jay,

In brief the low value of NUMTCB would lead to high wait time for suspension would be high and lead to more elapsed time. Db2 would wait till the timeout value mentioned in the DSNTIPX and after exceeding it would go for -471 sql code. You have to go for refresh. The lower the NUMTCB the faster is the refresh. [...] 11314 17 72_Re: DB2 V7.1 ZOS SQL Guru : Can someone explain how this query would run33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 19 May 2005 04:13:20 -0500366_- As a correlated subquery is stage2, there will be a tablespace scan for table A and the subquery will be evaluated for each row of tbale A. So if there are 1 million rows in table A, the subquery will be evaluated 1 million times.

And because there is no local predicate for table B, DB2 will do a tablespace scan for table B for every row of table A. [...] 11332 81 32_Re: Reasonable and Customary SOX18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM31_Thu, 19 May 2005 07:06:46 -0400577_us-ascii Cathy, We are being asked (or, in our case, told) to do the same thing. Even though we have to use a separate userid for production SYSADM and that userid is "audited" via TopSecret, we are still being asked to report on the activity by scanning the log. If this cannot be avoided, we will be using the CA-DB2 (formerly Platinum) Log Analyzer tool. You might also consider how you will find anomalous updates that are not done via SQL, such as non-logged loads or REPAIRs. I am very interested in the other responses. Please consider summarizing and posting back [...] 11414 363 96_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] DB2/UDB for Sol aris - Persistent db2bp too persistent23_Baskerville, Mark {PBG}26_Mark.Baskerville@PEPSI.COM31_Thu, 19 May 2005 06:14:34 -0500392_- Hi Tony -

We had a similar problem with an offline backup on AIX 5.2 with v8.2. Seems that the database has to be "deactivated" in order to avoid the sql1035 "database in use".

This sequence worked for us (as instance owner):

db2 force applications all db2 deactivate database db2 connect to database db2 quiesce database immediate force connections db2 terminate [...] 11778 176 95_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] DB2/UDB for Solaris - Persistent db2bp too persistent0_22_drdeath@OZEMAIL.COM.AU31_Thu, 19 May 2005 21:49:17 +1000610_ISO-8859-1 Thanks again Dirk,

I think that's precisely the problem. I'll look into the wait.

Unfortunately Online backup isn't an option all the time, so I still have to solve this problem.

Cheers

Tony Mitchell > > From: dirk.pohl@SERCON.DE > Date: 19/05/2005 18:59:56 > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] Antwort: Re: [DB2-L] Antwort: [DB2-L] DB2/UDB for Solaris - Persistent db2bp too persistent > > Hi Tony > > I suppose you have some scripts running db2 clp with sysadm authority . > I would take a closer look at these ones . > > 1. Do they really need to run [...] 11955 342 36_Re: Documentation for Visual Explain14_Steurs Patrick21_Patrick.Steurs@NBB.BE31_Thu, 19 May 2005 13:49:36 +0200834_us-ascii Hi,





Is this manual also available for the z/os-environment ?





greetings,





Patric Steurs

DBA at National Bank of Belgium.









-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Sent: woensdag 18 mei 2005 16:27 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Documentation for Visual Explain





This is the home page: http://www-306.ibm.com/software/data/db2/zos/osc/ve/ for DB2 for z/OS. Visual Explain has context sensitive help which can be viewed by selecting the operator in question. I'm sure Roger, Terry or Patrick can provide more details. The V8 Visual Explain is quite powerful in enabling DBAs to tune SQL and has a nice [...] 12298 80 28_Re: [v7 z/OS] Empty LISTDEF?13_Mackey, Glenn20_GMackey@GUIDEONE.COM31_Thu, 19 May 2005 07:14:25 -0500598_us-ascii In our lists, we add an EMPTY list consisting of a single TS object with nothing in it.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Seth Bienstock Sent: Wednesday, May 18, 2005 9:07 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [v7 z/OS] Empty LISTDEF?

Unfortunately, the way the utilities were designed it will give a return code of 8 as Cindy pointed out. I am of the opinion that the utility should either supply a return code of 4, or provide a way of controlling this (i.e. another OPTION clause). [...] 12379 406 36_Re: Documentation for Visual Explain16_Burnette, George27_George_Burnette@KYFBINS.COM31_Thu, 19 May 2005 08:28:50 -0400286_us-ascii We are using VE 8 for DB2 UDB 7.1 on zOS. The interface was totally redesigned over previous versions and some windows are frustratingly small, but it is a good product and there is a tutorial in the help menu. You can save the results in XML format and pass them around. [...] 12786 320 42_Re: abend 04E in SPUFI (was: )18_Pohlen Mailinglist24_fjpohlen-maillist@GMX.DE31_Thu, 19 May 2005 15:22:58 +0200466_iso-8859-1 Thank you Stan and Rich for your tips, but sometimes (or should I say mostly) the error sits in front of the monitor. The zOS at customer site was a dump of our own system with db2 version 7 installed. I have changed the logon procedure to reflect the version 6 libraries. But I forgot to change the panel command. There was a self written clist for db2 v7 which allocated the the db2 v7 libraries again. After correcting this everything works fine. [...] 13107 91 32_Re: Reasonable and Customary SOX12_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Thu, 19 May 2005 08:27:44 -0500345_us-ascii Hi Cathy. I wouldn't complain about this at all. Just tell them you have to buy a 3rd part product to do it efficiently. Think of all the other useful things you could do with it!

I wish my company had requirements that would force them to buy a log analysis tool. I had BMC's at my old job, and it was really nice to have. [...] 13199 26 55_Re: Access to data on Z/OS from client apps thru TCP/IP10_Jorg Lueke21_jorg_lueke@EFUNDS.COM31_Thu, 19 May 2005 08:27:22 -0500419_- We use DB2 Connect Gateway server inbetween all the clients and the host. We switched from SNA to TCP/IP a few years ago mainly because SNA resources were quite scarce.

With this set up there are security risks. If you do not encrypt the data any DB2Connect admin (or WebSphere if you use that) can start a trace and see all the data flowing. Of course the network people can run sniffers to do the same. [...] 13226 78 28_Re: [v7 z/OS] Empty LISTDEF?15_Philip Sevetson19_psevetson@GMAIL.COM31_Thu, 19 May 2005 09:41:04 -0400653_ISO-8859-1 Glenn's approach sounds like what we'll probably use. Thanks to all contributors/responders!

--Appreciatively, Phil

On 5/19/05, Mackey, Glenn wrote: > In our lists, we add an EMPTY list consisting of a single TS object with > nothing in it. > > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of Seth Bienstock > Sent: Wednesday, May 18, 2005 9:07 AM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] [v7 z/OS] Empty LISTDEF? > > Unfortunately, the way the utilities were designed it will give a return > code of 8 as Cindy pointed out. I [...] 13305 131 15_Re: DB2 Connect10_Jorg Lueke21_jorg_lueke@EFUNDS.COM31_Thu, 19 May 2005 08:37:22 -0500278_- We tested out a couple of these drivers one or two years sgo and they worked. I don't know about the license since we allready have DB2 Connect, maybe without that it would not work. But all we had to know was DB2's LUname and a mainframe ID/password and connect we did. [...] 13437 147 30_Re: DB2 SQL Reserved word list10_Dave Churn19_davechurn@GMAIL.COM31_Thu, 19 May 2005 08:53:48 -0500465_ISO-8859-1 George & all,

During our upgrade to version 7, we discovered where we had used reserve words in programs. While rebinding the programs, DB2 gave us errors from our usage of the following words;

DECLARE CURSOR CURSOR -and- DECLARE PLAN CURSOR

IBM will probably change the rules for better enforcement of the reserve words in version 8. We view using reserve words as a bad practice and seek to get our programmers to avoid them. [...] 13585 213 72_Re: DB2 V7.1 ZOS SQL Guru : Can someone explain how this query would run11_David Nance16_DWNance@FHSC.COM31_Thu, 19 May 2005 08:55:19 -0500459_us-ascii Shyam, The typo is not a typo, syntactically. So, the SQL is valid and can be executed, albeit, it will perform terribly. Walter has already explained that you will get a tablespacescan on both tables and repeatedly on table B, at that. All that can be said is next time make the typo syntactically incorrect, so that you get a -104, -206 or something along those lines. Also, you may want to look at explaining queries prior to executing them. [...] 13799 53 32_Re: Reasonable and Customary SOX15_Philip Sevetson19_psevetson@GMAIL.COM31_Thu, 19 May 2005 10:08:00 -0400433_ISO-8859-1 Cathy, I think you pretty much by definition _can't_ audit SYSADM for a moderately sly actor. The problem with SYSADM is that you can set the SQLID to _anything_, so your basic log auditing isn't going to find anything unless you have a hostile-and-stupid actor. The only thing you can really do with certainty using a log tool is identify key (hopefully small) tables and review all updates for questionable values. [...] 13853 37 42_Quest Software: Stop by booth #208 at IDUG13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Thu, 19 May 2005 09:19:19 -0500419_ISO-8859-1 Quest Central for DB2: The DBAs Complete Workbench If you are attending IDUG be sure to stop by our booth for a demo of the latest release of Quest Central for DB2. The most complete integrated workbench for managing DB2 on Unix, Windows, Linux, OS/390, and z/OS.

Hammer out performance problems Drill down to discover bottlenecks Tighten up database administration Tune SQL to improve queries [...] 13891 22 27_Disaster Recovery - Misc DB12_Edward Kosek15_ekosek@HESC.COM31_Thu, 19 May 2005 09:51:56 -0500786_- While reviewing sysibm.sysdatabase to maker sure all databases were identified for recovery, I came accross these databases and was wondering if they needed to have imagecopies created or will they be created when the DB2 subsystem is created.

DSNDDF DSNATPDB DSNRGFDB DSNRLST RAADB RDBIDB1 RDBIDB2 RDBIDB3

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 13914 78 32_Re: Reasonable and Customary SOX13_McDonald, Ken20_Ken_McDonald@BMC.COM31_Thu, 19 May 2005 10:00:22 -0500345_- The primary authid is what is actually stored in the Begin Unit of Recovery log record. So, even though a SET SQLID is executed, the log will reflect the ID to which the thread was attached.

I'm giving a presentation at IDUG -- A DSN1LOGP Primer -- which will have examples of using DSN1LOGP to do some of this kind of monitoring. [...] 13993 33 22_Re: 00C20200 revisited15_Chris Hoelscher21_choelscher@HUMANA.COM31_Thu, 19 May 2005 11:13:34 -0400352_US-ASCII >>This procedure will work only if you get all the internal identifiers >>(DBID, PSID, OBID, ISOBID) correct which is a rather big "if" (actually you >>possibly might get away with differing ISOBIDs according to a paper I once >>read). If DBP8 does NOT hold other objects, then doing a Homogeneous System >>Copy from DBP3 might be safer. [...] 14027 70 22_Re: 00C20200 revisited13_Michael Ebert18_mebert@AMADEUS.NET31_Thu, 19 May 2005 17:33:48 +0200467_US-ASCII I think the index space OBID (ISOBID) cannot be specified. This is the paper I mentioned, check it out: "Using FlashCopy Version 2 for DB2 UDB for OS/390 and z/OS Object-Level Migration" http://www.zjournal.com/Article.asp?ArticleID=899

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







From: Chris Hoelscher @IDUGDB2-L.ORG on 19-05-2005 11:13 AST [...] 14098 82 31_Re: Disaster Recovery - Misc DB13_Michael Ebert18_mebert@AMADEUS.NET31_Thu, 19 May 2005 17:50:14 +0200581_US-ASCII All of the TSs you list are user-maintained, they will not be created automatically; however, some of them are closely tied into DB2.

DSNDDF was moved into the Catalog TS SYSDDF many DB2 versions ago. It can be dropped. DSNRLST is for the Resource Limit Facility (RLF). You need it. DSNRGFDB is the Registration Database, a means whereby you can strictly control who can do what on your DB2 - I don't know whether anyone uses this. I've never come across DSNATPDB. We've had the RAADB and RDBIDB* as well; they belong to some ISV product and were installed in [...] 14181 131 31_Re: Disaster Recovery - Misc DB12_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Thu, 19 May 2005 11:13:30 -0500468_us-ascii DSNATPDB is for the ODBC/JDBC metadata stored procedures (sysibm.sql*).

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Ebert Sent: Thursday, May 19, 2005 10:50 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Disaster Recovery - Misc DB

All of the TSs you list are user-maintained, they will not be created automatically; however, some of them are closely tied into DB2. [...] 14313 58 43_Re: Governing statements from a remote site11_Cindy Foote29_cindy.foote@FIRSTDATACORP.COM31_Thu, 19 May 2005 11:11:08 -0500677_- On Sun, 5 Dec 2004 09:04:14 +0300, ALBAR, HASHIM O wrote:

>Hi; > > > >I have created a DSNRLST table to govern all dynamic queries > 30 sec. >coming from a remote site (TCP/IP). The RLST table successfully blocked all >SQL statement (SELECT, INSERT, DELETE, UPDATE) except the FETCH statement. > > > >Can anyone tell me if DSNRLST could govern the FETCH statement as well? > > > > > >Regards, > >Hashim Albar > > > > >--------------------------------------------------------------------------- ------ >Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. [...] 14372 28 12_RLST ASUTIME11_Cindy Foote29_cindy.foote@FIRSTDATACORP.COM31_Thu, 19 May 2005 11:56:13 -0500579_- Can anyone tell me what I'm missing?

I am trying to set up the RLST to govern dynamic SQL. We have two DB2 subsystems on the same processor. Reviewing the documentation the ASUTIME should work the same on both subsystems but It doesn't.

On one subsystem I set the ASUTIME to 200000 the job will run 0:16.07 CPU minutes and then receive the message: DSNT408I SQLCODE = -905, ERROR: UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING EXCEEDED, RESOURCE NAME = ASUTIME LIMIT = 000000000010 CPU SECONDS (000000200000 SERVICE UNITS) DERIVED FROM SYSIBM.DSNRLST01 [...] 14401 95 16_Re: RLST ASUTIME13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Thu, 19 May 2005 10:31:43 -0700627_us-ascii Hi Cindy. Are the messages EXACTLY the same? That is, do both state RESOURCE NAME = ASUTIME, LIMIT = 000000000010 CPU SECONDS (000000200000 SERVICE UNITS), and DERIVED FROM SYSIBM.DSNRLST01?

There are several places where limits can be set: a resource limit specification table, a system parameter, or the SYSIBM.SYSROUTINES catalog table. The DERIVED FROM part of the message you posted states that it was from SYSIBM.DSNRLST01, so you need not check the other places. The 2000000 SERVICE UNITS part of the message tells you exactly what the limit is, so there's no need to check other rows in the table. [...] 14497 57 16_Re: RLST ASUTIME14_Seth Bienstock19_sethdb2@COMCAST.NET31_Thu, 19 May 2005 17:36:47 +0000567_- Can you confirm that the same entries (rows) in both DSNRLSTx are being used to restrict the processes? It is possible that other criteria (rows) are taking precedence to the ones you THINK are being used. -------------- Original message --------------

> Can anyone tell me what I'm missing? > > I am trying to set up the RLST to govern dynamic SQL. We have two DB2 > subsystems on the same processor. Reviewing the documentation the ASUTIME > should work the same on both subsystems but It doesn't. > > On one subsystem I set the ASUTIME to 200000 the [...] 14555 87 22_Re: 00C20200 revisited0_22_sally.mir@WACHOVIA.COM31_Thu, 19 May 2005 13:41:31 -0400314_US-ASCII There is no OBID clause for CREATE INDEX; however, it is easily 'zapped' using the REPAIR utility. For indexes, you need to REPAIR the DBID, ISOBID, and OBID. For tablespaces, it's DBID, PSID, and OBID.

Shameless plug: IDUG next week, session H8 -- contains all the details of how to do this! [...] 14643 147 16_Re: RLST ASUTIME0_25_LL581@DAIMLERCHRYSLER.COM31_Thu, 19 May 2005 13:45:57 -0400425_US-ASCII Cindy,

One question / clarification: You state that "We have two DB2 subsystems on the same processor.". Are these subsystems part of a Data Sharing Group, or are they standalone subsystems?

If they are standalone, then each has its own RLST; hence, you need to ensure that you are updating the correct RLST with your ASUTIME values. I wasn't sure of your environment based on your original note. [...] 14791 98 17_Re: MS SQL to Db212_Roger Miller19_millerrl@US.IBM.COM31_Thu, 19 May 2005 13:11:55 -0500511_- There is a new redbook, still in draft form about migrating from Microsoft SQL Server to DB2. The book number is SG24-6672, and here is the the current draft: http://www.redbooks.ibm.com/redpieces/pdfs/sg246672.pdf

This web site has good resources too: http://www.ibm.com/developerworks/db2/zones/porting/

Roger Miller

On Tue, 17 May 2005 10:47:45 -0400, Lombardozzi, Bryan wrote:

>Export the tables from SQL Server using delimited format the >Hi, [...] 14890 402 43_Join Compuware at IDUG 2005 - North America16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Thu, 19 May 2005 14:24:07 -0400582_iso-8859-1

Join Compuware at IDUG 2005







Visit Compuware Corporation at booth #307 to see our comprehensive DB2 solutions for:

Interactive analysis, testing and debugging

File and data management

Fault management

Application performance management





In addition, we'll be presenting on various topics throughout the conference including:







Lifting the Veil of DB2's DDF: SQL Revealed



Martin Hubel, President, Martin Hubel Consulting, Inc. [...] 15293 100 10_Freepage ?14_Neff Stephen R22_Stephen.R.Neff@IRS.GOV31_Thu, 19 May 2005 14:37:11 -0400310_- Hello, I have 5.2 million rows to insert via cics transactions into an empty table. I would like to keep locking minimum and performance maximum. The idea has comme up to set the ddl to maximize inserts initially. I was wondering what in the DDL would do this? Would FREEPAGE and PCTFREE be candidates? [...] 15394 298 32_Re: Reasonable and Customary SOX28_Koleto, Kenneth M. [NCS SLC]21_KKoleto@CSCUS.JNJ.COM31_Thu, 19 May 2005 14:37:36 -0400373_iso-8859-1 DB2 Audit Trace Class 7 will show SQLID changes, from and to. But as pointed out in this thread, a good analysis tool would be needed to pull everything together. We haven't been pushed that hard--yet. Class 7 by itself will show you if someone it trying to elevate their privileges by setting their own id to an id with SYSADM privileges (attempted hack). [...] 15693 57 40_What are horizontal/veritcal db2 tables?14_Neff Stephen R22_Stephen.R.Neff@IRS.GOV31_Thu, 19 May 2005 14:38:48 -0400594_- Hello,

Where would I find a definition for horizontal/veritcal db2 tables?

Thanks

Steve Neff



--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 15751 32 44_Re: What are horizontal/veritcal db2 tables?15_Philip Sevetson19_psevetson@GMAIL.COM31_Thu, 19 May 2005 14:46:09 -0400773_ISO-8859-1 Do you mean horizontal/vertical *partitioning* of tables?

On 5/19/05, Neff Stephen R wrote: > > > Hello, > > Where would I find a definition for horizontal/veritcal db2 tables? > > Thanks > > Steve Neff

-- --Phil Sevetson IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for OS/390

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG [...] 15784 139 44_Re: What are horizontal/veritcal db2 tables?14_Neff Stephen R22_Stephen.R.Neff@IRS.GOV31_Thu, 19 May 2005 14:55:33 -0400484_- I was asked about tables. But there is some confusion as to what the question should be. At any rate I would also be interested in a definition for what horizontal/vertical *partitioning* of tables means.

Thank you

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Philip Sevetson Sent: Thursday, May 19, 2005 2:46 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] What are horizontal/veritcal db2 tables? [...] 15924 378 43_Re: Governing statements from a remote site12_Kirk Hampton28_khampto1@CAPGEMINIENERGY.COM31_Thu, 19 May 2005 14:15:20 -0500492_us-ascii From the Version 8 Application Programming and SQL Guide:

6.1.3 Limiting dynamic SQL with the resource limit facility

The resource limit facility (or governor) limits the amount of CPU time an SQL statement can take, which prevents SQL statements from making excessive requests The governor controls only the dynamic SQL manipulative statements SELECT, UPDATE, DELETE, and INSERT. Each dynamic SQL statement used in a program is subject to the same limits. [...] 16303 161 14_Re: Freepage ?13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 19 May 2005 14:17:10 -0500372_us-ascii Will your inserts be random or sequential?

If sequential, the amount of free space becomes less important.

If random, free pages and free space within a page "could" become an issue. However, if all 5.2 million rows will be added initially without performing a REORG at any time, free space and free pages will become meaningless very quickly. [...] 16465 141 14_Re: Freepage ?13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 19 May 2005 14:27:27 -0500572_us-ascii One other thought.... if this is an initial table load, have you considered simply using the LOAD utility?

Willie

Neff Stephen R wrote:

> Hello, I have 5.2 million rows to insert via cics transactions into an > empty table. I would like to keep locking minimum and performance > maximum. The idea has comme up to set the ddl to maximize inserts > initially. I was wondering what in the DDL would do this? Would > FREEPAGE and PCTFREE be candidates? > > > After the inserts are finished the table will remain static. An alter > and REORG [...] 16607 162 14_Re: Freepage ?19_Janes, Ray H {PBSG}20_Ray.H.Janes@PBSG.COM31_Thu, 19 May 2005 14:30:00 -0500681_- and, sort the input in clustering key order first.

-----Original Message----- From: Willie Favero [mailto:wfavero@ATTGLOBAL.NET] Sent: Thursday, May 19, 2005 2:27 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Freepage ?



One other thought.... if this is an initial table load, have you considered simply using the LOAD utility?

Willie

Neff Stephen R wrote:



Hello, I have 5.2 million rows to insert via cics transactions into an empty table. I would like to keep locking minimum and performance maximum. The idea has comme up to set the ddl to maximize inserts initially. I was wondering what in the DDL would do this? [...] 16770 70 14_Re: Freepage ?14_Seth Bienstock19_sethdb2@COMCAST.NET31_Thu, 19 May 2005 19:48:45 +0000636_- Some of the alternatives for achieving your goals might depend upon some of the following:

1) What is the frequency/rate/duration of INSERT activity? Is this a one-time occurrence? Once per day? Every hour? (etc.) 2) How many concurrent threads will be doing the INSERTs? One, two, dozens, thousands? 3) Are there potentially other accesses to the data (i.e. DELETE, SELECT, UPDATE) while the INSERTs are taking place? If so, what are their frequencies/rates/durations/volumes? 4) Is there anything relationship at all between the arrival order of the data and the content of any of the columns? 5) The criticality of the [...] 16841 117 32_Re: Reasonable and Customary SOX14_Amsden, John W27_John.Amsden@JPFINANCIAL.COM31_Thu, 19 May 2005 15:59:22 -0400370_iso-8859-1 Cathy, We too have been struck by the Sarbanes-Oxley bug. Our requirements included "report anything dome by our DBAs on our production database".

We use the CA Log Analyzer tool to 1) report any SQL operation by any of our DBAs and 2) to report any "set current SQLID...." statements. We report this daily from the 1) DB2 log and 2) SMF records. [...] 16959 200 14_Re: Freepage ?14_Neff Stephen R22_Stephen.R.Neff@IRS.GOV31_Thu, 19 May 2005 16:17:00 -0400358_- Hi, This is a random insert. We are trying to achive 500,000 transaction in an hour. Accomplishing the initial process in about 10 hours. Multiple CICS regions run muliple transaction with two lpars in a DB2 data sharing enviornment. To complicate matters there is update/insert activity all being done by the same CICS transaction on the same table. [...] 17160 298 14_Re: Freepage ?8_Ron Root24_ron.root@CPA.STATE.TX.US31_Thu, 19 May 2005 15:24:25 -0500410_iso-8859-1 MessageI'd suggest dropping all indexes during this populate process, unless they are needed for integrity (uniqueness, RI). If it is an archive table those may not be an issue. -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Neff Stephen R Sent: Thursday, May 19, 2005 3:17 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Freepage ? [...] 17459 62 36_Re: Documentation for Visual Explain12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 19 May 2005 15:23:04 -0500760_- Just to be clear, there is no book for Visual Explain on DB2 UDB for z/OS. There are some presentations on the function and answers to questions. There are about 15 pages on V8 Visual Explain (which works with DB2 V7) in the V8 Everything redbook, SG24-6079 (section 10.19, page 823 or Acrobat page 853) and a similar amount in SG24-6465 V8 Performance Topics (section 3.15, page 110, Acrobat page 140). The web site for downloading the module and the integrated help is http://www.ibm.com/software/data/db2/zos/osc/ve/index.html ftp://ftp.software.ibm.com/software/db2storedprocedure/db2zos390/techdocs/Z 31m.pdf ftp://ftp.software.ibm.com/software/data/db2zos/Z32.pdf ftp://ftp.software.ibm.com/software/db2storedprocedure/db2zos390/techdocs/O A3.pdf [...] 17522 21 65_SPUFI Syntax to copy a row and override a couple of field values.13_Brendan Friel28_Brendan_Friel@NOTES.NTRS.COM31_Thu, 19 May 2005 15:37:07 -0500724_US-ASCII I need to copy a couple of rows (subselect ?) and override some fields with hard coded values.

I couldn't find the syntax for this in Google, the manuals, Mullins or Wiorkowski.

I need the regular SPUFI syntax.

TIA, Brendan

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 17544 60 69_Re: SPUFI Syntax to copy a row and override a couple of field values.10_Doyle Mark21_Mark.Doyle@WIN-NA.COM31_Thu, 19 May 2005 16:04:43 -0500468_us-ascii Brendan,

There is no way to "insert into . . . select * from . . " where the source & target are the same table. This may cause never ending inserts.

Here's what you can do: Create table temp.table_name like real.table_name; commit; Insert into temp.table_name select * from real.table_name where your-criteria-here; commit; insert into real.table_name (col1, col2 . . . Etc) select col1, col2, hard-coded-literal, etc from temp.table_name [...] 17605 64 69_Re: SPUFI Syntax to copy a row and override a couple of field values.9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 19 May 2005 16:08:34 -0500583_windows-1250 you mean something like insert into tablea (select col1, 'abc',2,3,cold from tableb where yada yada yada)

You just have to do the override on the select which isn't intuitively obvious I know but that is the impact of many years of SQL on a brain..



Mike Bell HLS Technologies -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Brendan Friel Sent: Thursday, May 19, 2005 3:37 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] SPUFI Syntax to copy a row and override a couple of field values. [...] 17670 87 14_Re: Freepage ?9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 19 May 2005 16:31:10 -0500426_windows-1250 sorted input is a big help. drop 3 of the indexes for the build time is major help. random index inserts will make it run 3 times slower. commit frequency is another issue. If the CICS trans can insert 10 rows and commit instead of just 1 row, you can avoid a lot of the CPU for commit. LOAD with sysrec dd dummy and preformat option will initial format the primary allocation for tablepsace and each index. [...] 17758 87 14_Re: Freepage ?12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 19 May 2005 17:40:41 -0500575_- You have many good suggestions for options and tradeoffs in the notes. For benchmarks, we have examples that far exceed this one, for example 2900 transactions per second with 6 indexes at 2 inserts and 1 select per transaction.

There is a presentation at IDUG next week by Akira Shibamiya and presented by Sean Lee on insert performance. As Akira is the definitive DB2 performance expert, I hope you can get to IDUG, have a friend who does, or at least download the presentation (probably soon after the conference is over) from the DB2 UDB for z/OS web site. [...] 17846 42 42_New roadmap to information on DB2 for z/OS12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 19 May 2005 17:43:11 -0500595_- Don't you wish you could find all of the different kinds of information about DB2 for z/OS in one place (other than your favorites or bookmark lists)? I think you'll be happy to learn about a brand new Web page called the DB2 UDB for z/OS Information Roadmap. Information roadmaps are being developed by many IBM product teams in an effort to simplify the lives of users by providing a single place to find all sorts of useful information resources, such as: Product information from the official library IBM Redbooks Articles in a variety of different online publications, including the [...] 17889 58 46_Re: New roadmap to information on DB2 for z/OS12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 19 May 2005 18:00:00 -0500432_- Here is the rest of the note.

I encourage you to check out the new DB2 for z/OS Information Roadmap: http://www.ibm.com/software/data/db2/zos/roadmap.html

You can also start from the main DB2 UDB for z/OS web page and click on the Information Roadmap news item or icon. http://www.ibm.com/software/db2zos/

Roger Miller

On Thu, 19 May 2005 17:43:11 -0500, Roger Miller wrote: [...] 17948 27 24_Going ot IDUG in Denver?15_Leon Katsnelson15_leon@CA.IBM.COM31_Fri, 20 May 2005 01:59:18 -0400376_US-ASCII Going to IDUG North American conference in Denver? Make sure to take advantage of the free DB2 certification and win some cool prizes.

To get more details use DB2 Check for Updates facility in DB2 UDB and DB2 Connect Version 8.2 (v8.1 with FP7) or later. To check for DB2 updates do: - Start - All Programs - IBM DB2 - Information - Check for DB2 Updates [...] 17976 74 69_Re: SPUFI Syntax to copy a row and override a couple of field values.13_Michael Ebert18_mebert@AMADEUS.NET31_Fri, 20 May 2005 10:11:36 +0200353_US-ASCII Just for the record, it IS possible to run INSERT INTO T1 SELECT * FROM T1; (just tested it) and it does not cause an infinite loop. I think this loop is called the "Halloween problem", and it was solved in one of the first DB2 versions.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 18051 41 50_DB2 V7 on zOS 1.4: MSTR looping after I/O problems13_Michael Ebert18_mebert@AMADEUS.NET31_Fri, 20 May 2005 10:45:34 +0200350_US-ASCII Hi List,

yesterday we had to recycle our DB2. In the night, a DASD storage box which had been limping along close to its capacity for months (no more upgrades for mainframes...) finally ran out of collected free space. This caused I/O errors, -904 unavailable resource errors and objects in LPL and WEPR status. So far, so good. [...] 18093 134 14_Re: Freepage ?17_SALVADORI Etienne17_esalvadori@GMF.FR31_Fri, 20 May 2005 11:18:39 +0200526_iso-8859-1 If you want to improve insert/logging processing you sould initiate a Compression Dictionnary befor adding 500k rows (i.e. : via a load with 2k rows, then delete with load dummy with keepdictionnary option).



Etienne Salvadori

AZUR-GMF . SGBD Levallois . ISM 01-49-64-37-73



-----Message d'origine----- De : DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] De la part de Mike Bell Envoy : jeudi 19 mai 2005 23:31 : DB2-L@WWW.IDUGDB2-L.ORG Objet : Re: Freepage ? [...] 18228 37 51_Question - or, better, curiosity - about BP tuning.10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 20 May 2005 11:45:30 +0200583_US-ASCII Estimeed listers

I saw a BP tuning method based on tablespaces/indexes size and I mean the space allocated on DASDs and not 'Hoover's working size' of a pageset.

We discussed BP tuning methods many times here but I never read anything about this method which looks to me unproductive for many reasons: for example it doesn't take in any account the 'type' of pages (seq, random), the real 'working size' for a pageset, there's no indication of cold or hot pages in Bps, you could have the risk of using a BP with many objects while other BPs are (almost) [...] 18266 20 46_Re: New roadmap to information on DB2 for z/OS10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 20 May 2005 11:53:01 +0200675_US-ASCII Roger, or my GPS for DB2 V 69.01 is wrong or you forgot to put the web adddress of this new web page in your post in DB2-L........

I cannot find the way :-)

Cheers

Max Scarpa

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 18287 22 46_Re: New roadmap to information on DB2 for z/OS10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 20 May 2005 11:54:48 +0200739_US-ASCII OOPssss I saw too late the next Roger's post...sorry...bad thing old age __________________

Roger, or my GPS for DB2 V 69.01 is wrong or you forgot to put the web adddress of this new web page in your post in DB2-L........

I cannot find the way :-)

Cheers

Max Scarpa

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences [...] 18310 111 14_Re: Freepage ?11_Mike Turner29_michael_turner@COMPUSERVE.COM31_Fri, 20 May 2005 10:48:04 +0100602_iso-8859-1 Hi Steve

If you will be doing heavy inserting via two or more members of a DB2 Data Sharing group you should consider using the MEMBER CLUSTER option for the tablespace. This will eliminate page P-lock contention on the space map pages.

Regards Mike Turner Email: michael_turner@compuserve.com Tel: +44 (0)1565-873702 Web: www.michael-turner.ltd.uk -----Original Message----- From: owner-db2-l@WWW.IDUGDB2-L.ORG [mailto:owner-db2-l@WWW.IDUGDB2-L.ORG]On Behalf Of Neff Stephen R Sent: Thursday, 19 May 2005 21:17 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Freepage ? [...] 18422 65 43_Re: Governing statements from a remote site13_Michael Ebert18_mebert@AMADEUS.NET31_Fri, 20 May 2005 11:59:39 +0200377_US-ASCII Of course a FETCH may require a large amount of ASUTIME. Trivial example: if you have to scan a very large amount of rows to fetch the next qualifying one. Less trivial, if you have to evaluate a costly sub-query for every row to determine whether it qualifies.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 18488 181 14_Re: Freepage ?17_SALVADORI Etienne17_esalvadori@GMF.FR31_Fri, 20 May 2005 12:34:28 +0200388_iso-8859-1 Yes, by this way you prevent spacemap pg locking but you cannot alter this TS option with 'ALTER TS' And, in fact, any inserted is wrote in any availlable space independently of the clustering index... the cluster order will be only achieved with the next reorg (and why not drop/create this tablespace without MEMBER CLUSTER option; followed by a load with a sorted PDS) [...] 18670 101 55_Re: Question - or, better, curiosity - about BP tuning.14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Fri, 20 May 2005 04:29:16 -0700365_us-ascii The classic buffer pool tuning methods pre date DB2 by 20 years or more.

IMS and CICS which were announced at the 'same' time in the 60's both supported the method of one buffer pool per dataset only.

IMS quickly moved away from that with one common pool but suffered a brief relapse with the introduction of new fangled VSAM in IMS/VS. [...] 18772 136 32_Re: Reasonable and Customary SOX11_Chris White18_crick616@YAHOO.COM31_Fri, 20 May 2005 06:57:24 -0500620_- I've been involved in similar discussions. This is a particularly difficult issue because it is totally opposite the usual pressure we get from accounting and auditing folks... i.e. DON'T spend money. Also, some companies may discover that scanning the entire log with any of the currently available anaylzers could take more than 24 hours (think about large data sharing groups). I think we should work to charge the scanning costs to the accounting department, including the hardware upgrades that will undoubtedly be necessary to support such an enormous process. It might bring some sanity to the discussion. [...] 18909 16 62_Application development accessing DB2 Z/OS and SQL Server data14_Zobjeck, A. J.21_Allen_Zobjeck@TTX.COM31_Fri, 20 May 2005 07:27:42 -0500723_us-ascii I have data in both DB2 O/OS and on SQL databases. We are using DB2 Connect. The Web developers are starting to ask about JOINING DB2 data with SQL data. What if any is the preferred method for doing this? Is there any IBM information on this?

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 18926 40 66_Re: Application development accessing DB2 Z/OS and SQL Server data16_Burnette, George27_George_Burnette@KYFBINS.COM31_Fri, 20 May 2005 08:32:40 -0400322_us-ascii IBM does have info on this, but I don't have the link. You may also consider looking at db2 information integrator which can access homogenous datasources and make them appear as from a single datasource. One thing to be wary of is timestamp data - sql server and db2 may not be compatible on that datatype. [...] 18967 180 14_Re: Freepage ?14_Chad A. Walmer19_Cwalmer@RITEAID.COM31_Fri, 20 May 2005 08:38:00 -0400353_us-ascii Be sure that you are current on maintenance if you are planning on using MEMBER CLUSTER. If the table space was full, then the search for a candidate page would have to read a lot more space map pages since they only cover 199 pages with the MEMBER CLUSTER parameter as opposed to ~10,0000 for a non-member cluster TS with a 4k page size. [...] 19148 88 75_AW: [DB2-L] Application development accessing DB2 Z/OS and SQL Se rver data12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 20 May 2005 14:37:25 +0200697_iso-8859-1 >>> timestamp data - sql server and db2 may not be compatible on that datatype.<<<

They ARE not compatible. And this is true also for DATE, TIME and so on... ;-((

With kind regards - mit freundlichen Gruessen, Georg H. Peter c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- We don't make mistakes - only happy accidents. [...] 19237 138 44_Logical/Physical data model synchronization:18_Lombardozzi, Bryan25_Bryan_Lombardozzi@CSX.COM31_Fri, 20 May 2005 08:54:37 -0400625_us-ascii List,





My question is in regards to logical/Physical DM synchronization.





Currently we have 4 production systems each housing 150 - 200 databases. Many times the DBA groups will get requests which bypass our data modelers and the models don't always match up. We have been using Erwin to do a bi-directional sync update to get our physical model to match the logical models however doing this we can only do 1 database at a time which takes quite sometime for the modelers to keep up. We have also used BMC to do baseline compares and generate reports and this again [...] 19376 60 29_DB2 V7 Catalog Reorg Question21_Deepak Gujaba Gaikwad24_deepakggaikwad@YAHOO.COM31_Fri, 20 May 2005 06:00:32 -0700383_us-ascii

Hello All,

We have a monthly db2 catalog reorg job running in Test DB2. The job uses default OFFPOSLIMIT 10 INDREFLIMIT 10. Due to this most of the tablespace reorgs are skipped. We were wondering :

0) Anybody using these options and running the catalog reorgs on regular basis ?

1) What should be these values for db2 catalog reorg jobs ? [...] 19437 25 55_Re: Question - or, better, curiosity - about BP tuning.10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 20 May 2005 15:07:04 +0200380_US-ASCII Hi Avram

Unluckily some (not ALL) of historical steps are part of my experience........

I'm sure that there are valid technique but I think tuning BPs using tablespace size (ie space allocated on DASD) gives (many) less advantages than the methods used nowadays in DB2 l and I don't see any reference of any kind in the historical list to this method. [...] 19463 313 48_Re: Logical/Physical data model synchronization:16_Burnette, George27_George_Burnette@KYFBINS.COM31_Fri, 20 May 2005 09:06:36 -0400570_us-ascii We use ERStudio from Embarcadero Technologies and it as an ole automation interface... I assume ERWIN does as well. It may be possible for you to use ole automation to query model mart (if you have it - we have ERStudio repository), pull out the models one at a time, and do compares against production databases, sync them and then put the updated models back into model mart (this may be possible with ERWIN - I don't know). I have heard of this being done with ERStudio/ERStudio Repository. I do believe a good portion of this can be automated... given [...] 19777 294 14_Re: Freepage ?14_Neff Stephen R22_Stephen.R.Neff@IRS.GOV31_Fri, 20 May 2005 09:08:19 -0400585_- Hello, And thanks to all who have replied. Does freepage and pctfree maintain itself as inserts and updates occur. When starting with an empty table would it make sense to assign Values to freepage/pctfee? Will the table as rows are inserted maintain the freepage/pctfree when adding a row. As more rows are added/updated will indexes without FREEPAGE 0 PCTFREE 0 cause lock contention to occur? Is the assignment of freepage and pctfree more for once a table and its activity are understood or does it allow for an empty table to spread the inserts across DASD so that as more [...] 20072 31 78_Re: Any policy guidelines for Stored Procedures on DB2 for OS/390 and z/OS V7?10_Jorg Lueke21_jorg_lueke@EFUNDS.COM31_Fri, 20 May 2005 08:31:21 -0500526_- Are you going to write the procs in Cobol, Java, or use SQL Procs? If you use Cobol you should be able to leverage most of your existing processes around coding standards, security, and change process and control. That assumes you are running Cobol on z/OS.

The downside is that with Cobol you tend to need a hand off between front end and back end developers. With things like rapid application development, agile, etc. that can really get in the way. Especially if the two groups are not in the same location. [...] 20104 183 14_Re: Freepage ?9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 20 May 2005 08:42:02 -0500387_windows-1250 PCTFREE and FREEPAGE are only honored by the utilities LOAD and REORG. Their purpose is to create enough space that inserted rows can be placed in the correct page to maintain clustering. Your case of starting with an empty table and doing inserts will ignore any PCTFREE and FREEPAGE because INSERT is supposed to be a user of the embedded free space not maintain it. [...] 20288 79 55_Re: Question - or, better, curiosity - about BP tuning.35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 20 May 2005 09:40:12 -0400452_iso-8859-1 Hi Max,

Tuning BPs using tablespace size, or pages from the catalog is completely useless in almost all cases, unless you have a rather small object and can make the pool larger than the object. This again, would only be of value if you were going to access every page in the object with a high frequency. As an example, take an object with 1,000,000 pages, and you access a few thousand pages per hour, many of them repeatedly. [...] 20368 49 28_Re: Going to IDUG in Denver?12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Fri, 20 May 2005 08:43:21 -0500431_us-ascii When I try this I get an error that Microsoft points back to Sun saying that JAVA does not work! Do I need a more current JAVA or something?

Gerald Hodge HLS Technologies, Inc

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Leon Katsnelson Sent: Friday, May 20, 2005 12:59 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Going ot IDUG in Denver? [...] 20418 26 54_Re: DB2 V7 on zOS 1.4: MSTR looping after I/O problems10_Jorg Lueke21_jorg_lueke@EFUNDS.COM31_Fri, 20 May 2005 08:43:46 -0500458_- Thanks for posting, this is an interesting case. We also have a DASD box that is getting tired. Luckily we have only seen this problem in our sandbox/test region which gets 10% of the MIPS of one of the production CPUs. When production gets busy and we run datasharing in test the datasharing member can't get enough CPU to process the locks in IRLM. Then things crash and we had to bring down the member. Now we just leave it down during busy times. [...] 20445 92 33_Re: DB2 V7 Catalog Reorg Question0_28_Missy.Case@FIRSTDATACORP.COM31_Fri, 20 May 2005 08:54:11 -0500330_US-ASCII Deepak,

We reorg some hugely busy production catalogs quarterly. Annually seemed a bit of a stretch, but monthly seems like we'd never get permission for that many 'outages'. We settled for quarterly, but we don't use those options, we just run them all & get it over with.

Missy Case FDR 701-275-6358 [...] 20538 31 55_Re: Question - or, better, curiosity - about BP tuning.10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 20 May 2005 16:00:00 +0200570_US-ASCII Hi Joel

I was waiting your reply and I obviously agree with you. Using blindly tablespace size to 'populate' different BPs without any consideration on how pages are read and about how 'hot' are these pages gives no or little (in the case of small table for instance with all pages referenced) advantages with respect the method usually used. For instance we have very big historical tablespaces but they uses only a small part of total pages as via IFCIDs we saw that pages came only from few users and for few months (usually back to 1 to 6 moths [...] 20570 42 26_It's a miracle! I can see!13_Bell, Raymond22_raymond.bell@LANDG.COM31_Fri, 20 May 2005 15:00:32 +0100587_iso-8859-1 All,

You may or may not remember (care?) but I posted a note saying I wasn't getting many posts from DB2-L, but I could see the responses on the Archives. I think there are others out there suffering from the same condition. I've accidentally found the cause.

I use Outlook for e-mail. I had chosen to use the Arial truetype font when reading plain text e-mails. It seems for some bizarre this was buggering up DB2-L's e-mails to me, because for a completely unrelated reason I changed this to be the fixed format Courier font and Shazam! I'm getting DB2-L [...] 20613 37 26_SQL Gurus, An SQL question24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Fri, 20 May 2005 08:58:49 -0500511_- I have written a query as follows, which works just fine

SELECT * FROM SYSIBM.SYSTABLES WHERE (DBNAME,TSNAME) IN ( SELECT DBNAME,NAME FROM SYSIBM.SYSTABLESPACE WHERE NAME = 'TSXXXX') ;



Now I want to write the same query with Literal values instead of the subquery.

So I wrote a query as follows

SELECT * FROM SYSIBM.SYSTABLES WHERE (DBNAME,TSNAME) IN ('AXXDB','AXXXTS', <-- DBNAME,TSNAME 1 'BXXDB','BXXXTS', <-- DBNAME,TSNAME 2 'CXXDB','CXXXTS') ; <-- DBNAME,TSNAME 3 [...] 20651 28 36_Accounting records for WLM SPAS work16_Charlie Crockett30_Charles_Crockett@HAM.HONDA.COM31_Fri, 20 May 2005 09:55:00 -0400339_us-ascii The performance guy has asked me if there is any DB2 accounting record/IFCID for a stored procedure. I guess the programmers are saying how much more efficient a new version of their SP is, and he would like to try to measure it. I suspect he wants to see the SP name & WLM Environment name, plus cpu times. Maybe IFCID 148? [...] 20680 132 48_Re: Logical/Physical data model synchronization:14_Seth Bienstock19_sethdb2@COMCAST.NET31_Fri, 20 May 2005 14:16:57 +0000555_- Perhaps management needs to revisit the role/purpose of the data modelers.

In one large financial institution that I worked, on a specific project, I was quite impressed with the fact that NOTHING went into development without having first being reviewed by the data modeler and input into the data modeling tool (Bachman). Even if it was a change that had nothing to do with the logical model, it still had to be reviewed by the modeler. Although it could be perceived by some as a hinderance, in the big picture I believe it's worthwhile. [...] 20813 44 18_DB2 Tools on Unix:14_jack fernicola20_bowling730@YAHOO.COM31_Fri, 20 May 2005 07:20:31 -0700414_us-ascii Hello List,

We are bugeting for a new DB2 project. Does anyone know of a good tool to manage DB2 in the UNIX environment along with its estimated cost?

Thanks Jack



Jack Fernicola

--------------------------------- Yahoo! Mail Stay connected, organized, and protected. Take the tour

--------------------------------------------------------------------------------- 20858 20 30_Re: It's a miracle! I can see!10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 20 May 2005 16:23:03 +0200640_US-ASCII Raymond

Now you see the light. I was resurrected. The number of DB2-L lister seems multiplied. Our Lady of DB2-L's miracles ????

Cheers

Max

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 20879 111 69_Re: SPUFI Syntax to copy a row and override a couple of field values.10_Doyle Mark21_Mark.Doyle@WIN-NA.COM31_Fri, 20 May 2005 09:24:31 -0500594_us-ascii Hmmm, I learn something new every day! Thanks

Mark -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Ebert Sent: Friday, May 20, 2005 3:12 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] SPUFI Syntax to copy a row and override a couple of field values.



Just for the record, it IS possible to run INSERT INTO T1 SELECT * FROM T1; (just tested it) and it does not cause an infinite loop. I think this loop is called the "Halloween problem", and it was solved in one of the first DB2 versions. [...] 20991 74 30_Re: SQL Gurus, An SQL question14_Seth Bienstock19_sethdb2@COMCAST.NET31_Fri, 20 May 2005 14:24:45 +0000629_- How about something simple like:

SELECT TB.* FROM SYSIBM.SYSTABLES TB WHERE ( TB.TSNAME = 'TSxxxxxx' ) -------------- Original message --------------

> I have written a query as follows, which works just fine > > SELECT * FROM SYSIBM.SYSTABLES > WHERE (DBNAME,TSNAME) IN > ( SELECT DBNAME,NAME FROM SYSIBM.SYSTABLESPACE WHERE > NAME = 'TSXXXX') ; > > > Now I want to write the same query with Literal values instead of the > subquery. > > So I wrote a query as follows > > SELECT * FROM SYSIBM.SYSTABLES > WHERE (DBNAME,TSNAME) IN ('AXXDB','AXXXTS', <-- DBNAME,TSNAME 1 > 'BXXDB','BXXXTS', <-- DBNAME,TSNAME [...] 21066 85 30_Re: SQL Gurus, An SQL question12_McKown, John26_john.mckown@UICIINSCTR.COM31_Fri, 20 May 2005 09:28:32 -0500586_US-ASCII > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ramachandran Subramanian > Sent: Friday, May 20, 2005 8:59 AM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] SQL Gurus, An SQL question > > > I have written a query as follows, which works just fine > > SELECT * FROM SYSIBM.SYSTABLES > WHERE (DBNAME,TSNAME) IN > ( SELECT DBNAME,NAME FROM SYSIBM.SYSTABLESPACE WHERE > NAME = 'TSXXXX') ; > > > Now I want to write the same query with Literal values instead of the > subquery. > > So I wrote a query as follows [...] 21152 28 66_Re: Application development accessing DB2 Z/OS and SQL Server data12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 20 May 2005 09:52:35 -0500511_- This is a big subject, with lots of IBM products and information. Here is the base pointer for the area we call Information Integration. The area is branded under WebSPhere now. http://www.ibm.com/software/data/integration/

The join technology is primarily under federation: http://www.ibm.com/software/data/integration/federation.html http://www.ibm.com/software/data/integration/db2ii/

Roger Miller

On Fri, 20 May 2005 07:27:42 -0500, Zobjeck, A. J. wrote: [...] 21181 226 30_Re: SQL Gurus, An SQL question11_David Nance16_DWNance@FHSC.COM31_Fri, 20 May 2005 09:44:46 -0500432_us-ascii How about(This works as long as you do not have same tsname in multiple databases): SELECT * FROM SYSIBM.SYSTABLES WHERE DBNAME IN (LIST) AND TSNAME IN (LIST)

Or you could try(a bit more typing and results in multiple index scan for the access path, but still runs rather quickly): SELECT * FROM SYSIBM.SYSTABLES WHERE ((DBNAME = ? AND TSNAME = ?) OR (DBNAME = ? AND TSNAME = ?) OR (DBNAME = ? AND TSNAME = ?)) [...] 21408 54 66_Re: Application development accessing DB2 Z/OS and SQL Server data16_Burnette, George27_George_Burnette@KYFBINS.COM31_Fri, 20 May 2005 11:13:42 -0400616_us-ascii Db2ii looks like a pretty awesome product for those in need of data integration services.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roger Miller Sent: Friday, May 20, 2005 10:53 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Application development accessing DB2 Z/OS and SQL Server data



This is a big subject, with lots of IBM products and information. Here is the base pointer for the area we call Information Integration. The area is branded under WebSPhere now. http://www.ibm.com/software/data/integration/ [...] 21463 78 30_Re: SQL Gurus, An SQL question13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Fri, 20 May 2005 11:14:04 -0400401_US-ASCII You could try creating a view on SYSIBM.SYSTABLE and then doing your query.

I tested the following and it looks to do what you want.

CREATE VIEW OPDBA17.DBTS AS SELECT DBNAME||TSNAME AS COL1, NAME FROM SYSIBM.SYSTABLES WHERE TYPE = 'T'; SELECT * FROM OPDBA17.DBTS WHERE COL1 IN ('DPISM003TSEVENT','DPISM004TSWAYMST');

Marty Kenney Sr. DB2 DBA Railinc (919) 651-5211 [...] 21542 17 30_Re: SQL Gurus, An SQL question24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Fri, 20 May 2005 10:37:22 -0500590_- Sir ,

I tried your method , unfortunately it does not work. Thank you for your help anyway.



Ram

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 21560 32 22_STORMXAB current value11_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US31_Fri, 20 May 2005 10:44:09 -0500336_- Hello,

We need to know how many times a stored procedure has abended but has not yet reached the STORMXAB parameter setting. For example, assume that the value is set to 5 in the STORMXAB parm, but the stored procedure has only just terminated abnormally for the 3rd time. We would like to be able to display the value 3. [...] 21593 22 30_Re: SQL Gurus, An SQL question24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Fri, 20 May 2005 10:39:36 -0500337_- Sir,

Thank you for your answer. How ever my basic intent of the question was to understand if it was possible to represent a set of multiple values in an IN predicate as literals.



i.e. Is there a string representation of a result set of a query that returns multiple columns that can be fed back to a query. [...] 21616 55 30_Re: SQL Gurus, An SQL question13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Fri, 20 May 2005 11:51:56 -0400539_US-ASCII Well then, just do something like the following SELECT * FROM table WHERE col1||col2 IN ('col1valuecol2value','col1valuecol2value')

Access path may not be very good, but DB2 will give you the correct rows.

Marty Kenney Sr. DB2 DBA Railinc (919) 651-5211



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ramachandran Subramanian Sent: Friday, May 20, 2005 11:40 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] SQL Gurus, An SQL question [...] 21672 71 30_Re: SQL Gurus, An SQL question12_McKown, John26_john.mckown@UICIINSCTR.COM31_Fri, 20 May 2005 10:57:30 -0500396_US-ASCII This is not likely to be what you wanted either, but it may work.

SELECT * FROM SYSIBM.SYSTABLES WHERE (DBNAME,TSNAME) IN ( SELECT 'AXXDB','AXXXTS' <-- DBNAME,TSNAME 1 UNION SELECT 'BXXDB','BXXXTS' <-- DBNAME,TSNAME 2 UNION SELECT 'CXXDB','CXXXTS') ; <-- DBNAME,TSNAME 3

Again, I apologize for not being able to test this myself. I really with that I did have a DB2 system! 21744 15 49_Re: Condtional Reorg using OFFPOSLIMIT V8 db2/3909_Jim Ruddy18_jaruddy@US.IBM.COM31_Fri, 20 May 2005 11:04:58 -0500712_- Yes, please do append my response in the PMR. I have already notified the change team as well as a couple of people in Level 2 but there is always a possibility someone else will see the PMR first.

Jim Ruddy DB2 for z/OS Development

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 21760 113 14_Re: Freepage ?10_Jwkwan200025_jwkwan2000@HOUSTON.RR.COM31_Fri, 20 May 2005 12:10:08 -0500444_iso-8859-1 With all the recommendations, would it still be quicker to write the record into a file and use the load utility to load the data ? It would be an interesting benchmark exercise for performance group in IBM.

James Kwan ----- Original Message ----- From: "Roger Miller" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, May 19, 2005 5:40 PM Subject: Re: [DB2-L] Freepage ? [...] 21874 159 14_Re: Freepage ?9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 20 May 2005 12:30:07 -0500573_windows-1250 The origional request cited the need for updates and inserts from some other source.

That said, one option no one has mentioned is load the table with data from previous backup, and change the CICS transaction to do update/insert logic

read row from DB2, if data hasn't changed get next conversion record if row exists and data has changed, update data if row not found, insert the row. I have done that before and the stats were impressive, over 90% of the data rows were read and discarded. Less than 1% of the rows needed to be inserted. [...] 22034 151 69_Re: SPUFI Syntax to copy a row and override a couple of field values.13_Brendan Friel28_Brendan_Friel@NOTES.NTRS.COM31_Fri, 20 May 2005 12:28:19 -0500410_US-ASCII Yes, mine worked fine and you can also override values in the SELECT with hard coded values. That was my requirement.

Thanks to all, Brendan







Doyle Mark cc: Sent by: DB2 Data Subject: Re: [DB2-L] SPUFI Syntax to copy a row and Base Discussion override a couple of field values. List [...] 22186 68 40_Re: Accounting records for WLM SPAS work13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 20 May 2005 18:17:51 +0100390_US-ASCII Yup. Use Package Accounting within Accounting Trace. IFCIDs 3 and 239 for V7. Only IFCID 239 for V8.

Whether this is a Stored Procedure or not is flagged in the QPAC section.

Martin

Martin Packer, MBCS CITP Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584)

"Las cosas de palacio van despacio" [...] 22255 178 32_Re: Reasonable and Customary SOX12_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 20 May 2005 11:17:23 -0700567_us-ascii And is all your audit trail being written to write-once media, so that it can't be manipulated to hide the culprit's tracks?

--- "Amsden, John W" wrote:

> Cathy, > We too have been struck by the Sarbanes-Oxley bug. > Our requirements > included "report anything dome by our DBAs on our > production database". > > We use the CA Log Analyzer tool to 1) report any SQL > operation by any > of our DBAs and 2) to report any "set current > SQLID...." statements. > We report this daily from the 1) DB2 log and 2) [...] 22434 112 20_Started Task Problem9_Dan Lamas22_dlamas@DUKE-ENERGY.COM31_Fri, 20 May 2005 14:01:17 -0500553_US-ASCII Hello Listers,

My name is Dan Lamas.

I am having a problem that no one here seems to be able to figure out. I was requested to create a new DB2 Testing environment for a special project. We are os/390 v2.10 with DB2 v7. Our shop uses WLM with DB2 Stored Procedures. I have created everything that I think I need for the new system. I requested from the SYSPROG to create a new WLM Applenv for the stored procedures and I have requested of the Security Admin to create a new Started Task Id cloned from and existing (working) [...] 22547 468 24_Re: Started Task Problem11_David Nance16_DWNance@FHSC.COM31_Fri, 20 May 2005 14:18:39 -0500300_us-ascii Dan, I would suggest that your sysprog messed up with the new WLM Applenv. Why did he put the override to the non-existent device of NONE? Since its not in any of your other WLM STC's why not just remove it from the new one?

Dave Nance First Health Services, Corp. (804)527-6841 [...] 23016 168 24_Re: Started Task Problem16_Proctor, William25_William.Proctor@TGSLC.ORG31_Fri, 20 May 2005 14:23:16 -0500513_us-ascii What is the //iefproc.iefrder card for? We have the same setup but without this card.

Bill Proctor Database Administrator (Adabas/DB2) DB2 UDB V7.1 Database Administration for OS/390 Texas Guaranteed Student Loan Corp. Austin, Texas Phone: 512-219-4847





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dan Lamas Sent: Friday, May 20, 2005 2:01 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Started Task Problem [...] 23185 32 24_Re: Started Task Problem12_McKown, John26_john.mckown@UICIINSCTR.COM31_Fri, 20 May 2005 14:29:04 -0500438_US-ASCII I am not very DB2 literate. However, the card that you show is generated "automagically" by the START command if the DB2WLM2 proc is started with "S DB2WLM2,NONE". This is a standard part of z/OS going all the way back to OS/360. So, the question comes up, why is the ",NONE" being added to the end of the START command for DB2WLM2? I assume that the START command is actually generated by something in DB2. This I cannot answer. 23218 171 24_Re: Started Task Problem12_Colleen Clow23_Colleen_Clow@BCBSIL.COM31_Fri, 20 May 2005 14:30:10 -0500359_us-ascii 2 IEFC001I PROCEDURE DB2WLM2 WAS EXPANDED USING SYSTEM LIBRARY SYSP.DBA.

This message from your note below cuts off the library that DB2WLM2 is being expanded from, and you may have already checked this, but are the other procs being expanded using the same system library? Or do they have a proclib in them that's missing from this one? [...] 23390 179 24_Re: Started Task Problem19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Fri, 20 May 2005 14:32:47 -0500442_us-ascii The MVS start command can modify an IEFRDER DD statement. Could it be that the start command itself is requesting the IEFRDER dd statement to be modified... And could the system automatically be creating the IEFRDER DD statement as a result?

Look for something strange in SYSLOG for how you are starting this task. If you see something strange, I'd ask your JES group and/or MVS group about how this task is starting up. [...] 23570 173 24_Re: Started Task Problem0_17_sjvagnier@AEP.COM31_Fri, 20 May 2005 15:34:28 -0400487_US-ASCII Dan, there is probably something wrong with the way the WLM application environment was defined. I suggest having the SYSPROG compare a WLM application environment that currently works (ie. DB2WLM) with the new DB2WLM2 application definition.

Regards,

**************************************** Steve Vagnier American Electric Power Database Administration One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-716-3677 Audinet: 200-3677 [...] 23744 172 24_Re: Started Task Problem0_27_craig.mcginnis@WACHOVIA.COM31_Fri, 20 May 2005 15:34:16 -0400574_US-ASCII Will you provide the actual start command from the syslog that was used to start the WLM address space? I suspect we will see the problem there. The reason I say this is because I don't understand why I see PGM=DSNX9WLM,REGION=0K,TIME=NOLIMIT,PARM=' as part of the substitution JCL. We should only be seeing the symbolics. For some reason, I believe you are passing the other as part of the parm on the start command, including a real parm value that is being truncated and throwing us down the wrong path with the IEFRDER dd. I believe the answer lies in the [...] 23917 74 24_Re: Started Task Problem0_27_craig.mcginnis@WACHOVIA.COM31_Fri, 20 May 2005 15:35:32 -0400754_US-ASCII The start command is generated by WLM as defined in the applenv definition.







"McKown, John" To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: [DB2-L] Started Task Problem



05/20/2005 03:29 PM



Please respond to DB2 Database Discussion list at IDUG











I am not very DB2 literate. However, the card that you show is generated "automagically" by the START command if the DB2WLM2 proc is started with "S DB2WLM2,NONE". This is a standard part of z/OS going all the way back to OS/360. So, the question comes up, why is the ",NONE" [...] 23992 43 24_Re: Started Task Problem12_McKown, John26_john.mckown@UICIINSCTR.COM31_Fri, 20 May 2005 14:49:12 -0500350_US-ASCII > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of craig.mcginnis@WACHOVIA.COM > Sent: Friday, May 20, 2005 2:36 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] Started Task Problem > > > The start command is generated by WLM as defined in the > applenv definition. > [...] 24036 194 24_Re: Started Task Problem17_No Name Available26_dmortens@NOTES.STATE.NE.US31_Fri, 20 May 2005 14:42:01 -0500767_US-ASCII According to OY44553 here is your potential problem

















SUPPORT WAS PROVIDED IN MVS/ESA VERSION 4 TO ALLOW ALL DD KEYWORDS TO BE USED ON THE START COMMAND. THIS CAUSES POTENTIAL JCL ERRORS FOR THOSE START COMMANDS WHOSE SYNTAX ALLOWED A DD KEYWORD PREVIOUSLY. **************************************************************** * USERS AFFECTED: ALL MVS/ESA VERSION 4 USERS WHOSE START * * COMMAND SYNTAX USE DD KEYWORDS (E.G. MODE). * **************************************************************** THE SYNTAX OF THE START AVM WILL CHANGE THE MODE KEYWORD, SEE OY45399. THE CONVERSION NOTEBOOK WILL BE CHANGED TO STATE THAT ANY DD KEYWORD THAT IS USED ON A START COMMAND WILL BE TREATED [...] 24231 71 54_Re: DB2 V7 on zOS 1.4: MSTR looping after I/O problems13_Michael Ebert18_mebert@AMADEUS.NET31_Fri, 20 May 2005 21:57:21 +0200355_US-ASCII Well, it was MSTR that was looping. I did not have the feeling that any other task was having a problem, at least none that was as obvious. We simply cancelled IRLM as a surefire way of bringing down DB2, when it ignored the -STOP command.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 24303 235 35_DB2 V7 OS/390 Explain analysis help13_Rhea, Matthew29_Matthew.Rhea@INFARMBUREAU.COM31_Fri, 20 May 2005 15:01:54 -0500463_iso-8859-1 Hello, list.

Why do these two queries use different access paths?

SELECT TCH_POL_ID, CK_POLICY_NBR, LST_ETR_CD FROM LH_BAS_POL WHERE CK_CMP_CD = '01' AND CK_SYS_CD = 'I' AND ((LST_ETR_CD > 'A' AND LST_ETR_CD < 'J') OR LST_ETR_CD = 'R') ORDER BY CK_POLICY_NBR

This first query uses a non-matching index scan which contains the columns below. The explain shows that no sort is required because it is using the clustering index. [...] 24539 128 39_Re: DB2 V7 OS/390 Explain analysis help0_22_sally.mir@WACHOVIA.COM31_Fri, 20 May 2005 16:09:35 -0400376_US-ASCII The filter factor formula for > and < is slightly different from the filter factor formula for BETWEEN. Could be making the difference with the optimizer. See the Application Programminig and SQL Guide for the details.

Just my $.02,



Sally A. Mir, AVP IBM Certified Database Administrator DB2 Universal Database V8.1 for Z/OS (336) 773-4011 [...] 24668 171 39_Re: DB2 V7 OS/390 Explain analysis help13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Fri, 20 May 2005 15:14:40 -0500365_iso-8859-1 I'm guessing an "optimize for 1 rows" would make the second query pick up the index. If you can get away with it, you might also consider putting CK_POLICY_NBR behind CK_CMP_CD and CK_SYS_CD on the index (would give you 2-column match as opposed to non-matching scan). This would obviously have other ramifications that would need to be considered. [...] 24840 23 14_IDUG next week13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 20 May 2005 15:19:18 -0500263_ISO-8859-1 Packing up for IDUG next week. I hope some of you all look me while you are in Denver.

If you do go to IDUG next week, don't forget to pick up your brown DB2-L ribbon at registration and check out the Daily Globe for the date of the DB2-L lunch. 24864 94 24_Re: Started Task Problem9_Dan Lamas22_dlamas@DUKE-ENERGY.COM31_Fri, 20 May 2005 15:29:17 -0500498_US-ASCII WE GOT IT!!!!!!

Thanks to everyone that responded. This one was really kicking me in the tail.

The SYSPROG did have the word NONE in the start parameters.

thanks again. you all are GREAT!!



Dan Lamas DBA - Duke Energy Gas Transmission 713.627.4261





"McKown, John" To Sent by: DB2 Data DB2-L@www.idugdb2-l.org Base Discussion cc List Re: [DB2-L] Started Task Problem [...] 24959 17 24_Re: Started Task Problem11_Ed Mullikin17_EMullikin@SCU.EDU31_Fri, 20 May 2005 15:17:52 -0700606_US-ASCII I'll be out of the office from 05/23 thru 05/27. For any database issues, please contact Mai Anh at ex.4814.

Thanks, ED

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 24977 85 32_Re: Reasonable and Customary SOX12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 21 May 2005 12:29:17 +0200478_us-ascii Hi,

CA - Log Analyzer is run daily for all dynamic sql usage.



Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Taddei, Cathy Sent: Thursday, May 19, 2005 1:12 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Reasonable and Customary SOX

This is directed towards U.S. companies, and those with U.S. subsidiaries that must adhere to Sarbanes Oxley requirements. [...] 25063 48 16_Re: RLST ASUTIME11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 21 May 2005 15:51:48 -0500626_- Sounds like the access path may be different. Causing one to take more time?

Mike Kalena mkalena@bear.com

On Thu, 19 May 2005 11:56:13 -0500, Cindy Foote wrote:

>Can anyone tell me what I'm missing? > >I am trying to set up the RLST to govern dynamic SQL. We have two DB2 >subsystems on the same processor. Reviewing the documentation the ASUTIME >should work the same on both subsystems but It doesn't. > >On one subsystem I set the ASUTIME to 200000 the job will run 0:16.07 CPU >minutes and then receive the message: >DSNT408I SQLCODE = -905, ERROR: UNSUCCESSFUL [...] 25112 61 16_Re: RLST ASUTIME11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 21 May 2005 15:58:47 -0500618_- Please ignore this post, I misread the question. On Sat, 21 May 2005 15:51:48 -0500, Mike Kalena wrote:

>Sounds like the access path may be different. Causing one to take more >time? > >Mike Kalena >mkalena@bear.com > >On Thu, 19 May 2005 11:56:13 -0500, Cindy Foote > wrote: > >>Can anyone tell me what I'm missing? >> >>I am trying to set up the RLST to govern dynamic SQL. We have two DB2 >>subsystems on the same processor. Reviewing the documentation the ASUTIME >>should work the same on both subsystems but It doesn't. >> >>On one subsystem I set [...]