1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2006, week 5 2 105 44_Re: inserting blob in DB@ using perl and DBI13_Mertens, Bart18_bart.mertens@CZ.NL31_Tue, 29 Aug 2006 07:48:45 +0200499_us-ascii I'm with James. Use parameter markers

For a working example: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0512gre enstein/

-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens James Campbell Verzonden: dinsdag 29 augustus 2006 1:15 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: Re: [DB2-L] inserting blob in DB@ using perl and DBI

I'm sort of guessing in this response, so make your own allowances: [...] 108 266 43_Re: Stored procedures Implementation - z/OS0_28_jim_addison@STANDARDLIFE.COM31_Tue, 29 Aug 2006 11:14:13 +0100302_ISO-8859-1 You would not want to mix your Rexx SPs in an applenv with non-Rexx SPs. One reason for this is that you need NUMTCB=1 for Rexx and this is unlikely to be good for your Cobol SPs. We do not use Java SPs but I remember hearing that these should be separate too, but cannot remember why. [...] 375 46 15_special queries13_Harry William24_harry_williamt@YAHOO.COM31_Tue, 29 Aug 2006 06:14:09 -0700397_iso-8859-1 Dear Listers,

Do we have any site where we can get sample & explanation on how to write special queries.

For example

select * from table where (flag1 = ' ' or party = :wk_party) and (flag2 = ' ' or account = :wk_acount)

Thanks in advance Harry



--------------------------------- Stay in the know. Pulse on the new Yahoo.com. Check it out. [...] 422 293 27_Recover data using DSN1COPY43_David Thompson - BCX - Data Centre Services24_David.Thompson@BCX.CO.ZA31_Tue, 29 Aug 2006 15:21:51 +0200467_US-ASCII Hi,

I am trying to recover a multiple dataset (31) tablespace using DSN1COPY. The tablespace was dropped, thus losing all recovery data out of SYSCOPY. I have pre-allocated the second, third ... datasets and done the alter to make them multi-volume datasets. When loading the data, using DSN1COPY from the imagecopy dataset, it does not switch over to the second dataset but carries on until it falls over with a RC 08 with the following errors: [...] 716 300 27_Recover data using DSN1COPY43_David Thompson - BCX - Data Centre Services24_David.Thompson@BCX.CO.ZA31_Tue, 29 Aug 2006 15:31:03 +0200467_US-ASCII Hi,

I am trying to recover a multiple dataset (31) tablespace using DSN1COPY. The tablespace was dropped, thus losing all recovery data out of SYSCOPY. I have pre-allocated the second, third ... datasets and done the alter to make them multi-volume datasets. When loading the data, using DSN1COPY from the imagecopy dataset, it does not switch over to the second dataset but carries on until it falls over with a RC 08 with the following errors: [...] 1017 45 35_Recall: Recover data using DSN1COPY43_David Thompson - BCX - Data Centre Services24_David.Thompson@BCX.CO.ZA31_Tue, 29 Aug 2006 15:27:21 +0200555_US-ASCII The sender would like to recall the message, "Recover data using DSN1COPY".

--------------------------------------------------------------------------------- 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 1063 155 19_Re: special queries13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 29 Aug 2006 09:49:10 -0400426_US-ASCII Hi Harry,

Could you elaborate a little on what you mean by special queries?

Your example doesn't tell me exactly what kind of special queries you mean.

Dave



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Harry William Sent: Tuesday, August 29, 2006 9:14 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] special queries [...] 1219 220 19_Re: special queries17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Tue, 29 Aug 2006 09:25:22 -0500726_us-ascii







Rich Gugel State of Wisconsin Department of Administration DB2 Systems Programmer



Harry

I've found some interesting queries in Graeme's SQL cookbook which can be found at http://mysite.verizon.net/Graeme_Birchall/id1.html It's written for UDB, but it works for Z most of the time as well.

HTH

Rich





=00The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...] 1440 374 34_Re: QMF and DB2 mismatching CCSIDs13_Bell, Raymond22_raymond.bell@LANDG.COM31_Tue, 29 Aug 2006 16:04:30 +0100654_iso-8859-1 All,

David's excellent find below is basically what our Sysprog did here. He grabbed member ADMADFT, modified it to contain:

ADMMDFT APPCPG=00285 DEFAULT IS 00351 @LDC ADMMDFT INSCPG=00285 DEFAULT IS 00351 @LDC

(i.e. our missing conversions) and reassembled it back into blah.SADMMOD. Bingo, warning message disappears.

Cheers,



Raymond Bell Database Administrator

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of David Limkin Sent: 28 August 2006 00:08 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] QMF and DB2 mismatching CCSIDs [...] 1815 134 44_Re: inserting blob in DB@ using perl and DBI18_The SportComputMan27_sport_compu_man@HOTMAIL.COM31_Tue, 29 Aug 2006 08:39:09 -0700958_- Hello Mertens and James, thanks for the contribution. I finally solved it yesterday by following the example on Large object manipulation described in the ibm manual: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0512greenstein/



thx

The Sport Compu Man.











>From: "Mertens, Bart" >Reply-To: DB2 Database Discussion list at IDUG >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] inserting blob in DB@ using perl and DBI >Date: Tue, 29 Aug 2006 07:48:45 +0200 > >I'm with James. >Use parameter markers > >For a working example: >http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0512gre >enstein/ > >-----Oorspronkelijk bericht----- >Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens >James Campbell >Verzonden: dinsdag 29 augustus 2006 1:15 >Aan: DB2-L@WWW.IDUGDB2-L.ORG >Onderwerp: [...] 1950 18 16_db2 unix scripts25_SUBSCRIBE DB2-L Anonymous23_vishalsaibaba@YAHOO.COM31_Tue, 29 Aug 2006 11:12:41 -0500317_- Hi Everyone..

I am trying to set up the unix scripts automation for backup database, reorg, runstat, backup status and stability. And i am not a goog script writer but i have to start from somewhere. Please anyone guide me where can i find the AIX scritps for db2(LUW v8.2).

Thanks In advance. V [...] 1969 87 46_DB2V7 MAINFRAME REBUILD INDEX utility question14_Neff Stephen R22_Stephen.R.Neff@IRS.GOV31_Tue, 29 Aug 2006 12:04:53 -0400309_US-ASCII Hello,

I have a table in its own table space that has multiple indexes. I would like to rebuild two nonpartition indexes of this table. I do not want to rebuild all the indexes. Do I have to run two separate jobs one after the other or can I run the jobs concurrently? Can I use listdef. [...] 2057 51 26_Resume Yes and Compression12_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Tue, 29 Aug 2006 11:44:07 -0500473_us-ascii This is probably a pointless post, but I was wondering if someone from this list(from IBM or otherwise), could explain the logic in not building a compression dictionary when a person is doing a load resume yes but records are going into an empty partition.??

Ive seen several questions on this from the list in the past, and the solution given by the list is always do a reorg after the rows are loaded because load resume doesn't build a dictionary. [...] 2109 92 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )13_David S Waugh16_dsw-dba@JUNO.COM29_Tue, 29 Aug 2006 16:49:19 GMT578_- That's pretty much what I saw at both clients I mentioned. From 3 to 5 times more servers were required for development & test than for production, and anywhere between 10 to 20 more Oracle instances than DB2 subsystems were required. And every time a Production UNIX server went above ~100 users, another production server was required to handle the "load". Also, 15 to 20 Oracle DBAs (and a bunch of very expensive Oracle consultants) were required to keep everything running, as opposed to 2 or 3 DB2 DBAs. And then there were delays upon delays upon delays as Oracle [...] 2202 370 50_Re: DB2V7 MAINFRAME REBUILD INDEX utility question12_HEPP SHERY C17_schepp@SRPNET.COM31_Tue, 29 Aug 2006 09:59:17 -0700474_us-ascii Hi Steve,





Here's one listdef I have for rebuild index (you would just need to wild card or fully qualify the indexes you want to rebuild- and exclude any that fit the wildcard that you don't want)





LISTDEF REBLDIDX INCLUDE INDEX F0PCDK.*

EXCLUDE INDEX F0PCDK.FNCLTRN*

EXCLUDE INDEX F0PCDK.CUST*

EXCLUDE INDEX F0PCDK.SELBO*

EXCLUDE INDEX F0PCDK.BOBLH*

EXCLUDE INDEX F0PCDK.BILHST* [...] 2573 312 50_Re: DB2V7 MAINFRAME REBUILD INDEX utility question50_Costa, Marc --- Sr. Database Administrator --- CFS28_Marc.Costa@FREIGHT.FEDEX.COM31_Tue, 29 Aug 2006 11:11:25 -0600471_us-ascii Steve,





You can run two jobs at the same time (need different jobname, utility IDs, etc), but they can run concurrently. I would actually suggest putting the two jobs in the same member of a PDS, and then when you type sub, they will both start at the same time. As for using listdef, I think you could include the two indexespaces and there might be a keyword that would build them in parallel, but I am not finding it in the manual. [...] 2886 18 76_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multiple LPARs zOS )11_Robert Jans26_robert.jans@ALBERTSONS.COM31_Tue, 29 Aug 2006 11:11:43 -0600691_us-ascii Or how about when management uses IBM's offer of free UDB EEE software with only annual maintenance fees to leverage a better price out of Oracle. We're still paying for that one..............

Robert Jans

--------------------------------------------------------------------------------- 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 2905 84 30_Re: Resume Yes and Compression15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Tue, 29 Aug 2006 12:12:20 -0500599_us-ascii BMC LOADPLUS for DB2 will do just what you want, and has since release 7.2.

As to the logic as to why not, I can not answer for IBM, but it was not a simple change.

Christopher Y. Blaicher BMC Software, Inc. Austin Development Labs (512) 340-6154 The comments made are my personal opinions. BMC Software, Inc. makes no representations or promises regarding the reliability, completeness, or accuracy of the information provided in this discussion; all readers agree not to rely on this information or take any action against BMC Software in response to this information. [...] 2990 92 30_Re: Resume Yes and Compression50_Costa, Marc --- Sr. Database Administrator --- CFS28_Marc.Costa@FREIGHT.FEDEX.COM31_Tue, 29 Aug 2006 11:19:17 -0600577_us-ascii Mike,

In your example, you are loading across the last ten "empty" partitions. Why not do a load replace at the part level for those ten partitions? That will build the compression dictionary for you for those ten parts. Now, if your example is going to load across partitions that are not empty, this is not a good option. But, if you know what data you are dealing with from a partition standpoint, you could load the empty parts with the replace option (instead of resume yes) and get a compression dictionary for those parts built in the load utility. [...] 3083 56 50_Re: DB2V7 MAINFRAME REBUILD INDEX utility question13_arlen stovall24_arlenstovall@HOTMAIL.COM31_Tue, 29 Aug 2006 13:45:12 -0400767_iso-8859-1 Steve here is an example the frist will rebuild all indexes and the second you can make selective to only rebuild the ones that you want to.





//DSNUPROC.SYSIN DD * REBUILD INDEX(ALL) TABLESPACE FA40X999.FZCCOPR // REBUILD INDEX(SAPR3."GLPCT~1") REBUILD INDEX(SAPR3."GLPCP~1") REBUILD INDEX(SAPR3."MDRP~Z1")



Thanks Arlen Stovall



----------------------------------------------- > Date: Tue, 29 Aug 2006 12:04:53 -0400 > From: Stephen.R.Neff@IRS.GOV > Subject: [DB2-L] DB2V7 MAINFRAME REBUILD INDEX utility question > To: DB2-L@WWW.IDUGDB2-L.ORG > > Hello, > I have a table in its own table space that has multiple indexes. I would like to rebuild two nonpartition indexes of this table. I do not want [...] 3140 345 50_Re: DB2V7 MAINFRAME REBUILD INDEX utility question12_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Tue, 29 Aug 2006 13:10:11 -0500563_us-ascii REBUILD INDEX (ownerid.indexname, ownerid.indexname) SORTKEYS STATISTICS

is what i would run, one utility, building two indexes. lots of different ways you can go though.





Mike Backes







________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Costa, Marc --- Sr. Database Administrator --- CFS Sent: Tuesday, August 29, 2006 12:11 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V7 MAINFRAME REBUILD INDEX utility question [...] 3486 15 21_Re: Column validation14_Brad E. Melton24_Brad.Melton@WAL-MART.COM31_Tue, 29 Aug 2006 13:18:34 -0500585_- James,

Thanks! The translate function was just what I needed to simplify this validation SQL.

Brad

--------------------------------------------------------------------------------- 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 3502 128 30_Re: Resume Yes and Compression12_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Tue, 29 Aug 2006 13:33:05 -0500527_us-ascii Marc, to do a load replace at the part level would require 10 different steps/load cards, plus it would require me to presort my data being loaded into 10 different files. Basically I would have to do the work manually instead of letting db2 do the work for me. If it was a one time shot that would work. But reality is a bit different from my example. In reality we have jobs that do load resumes and roll into the next partition when the key gets to a certain point. (ie we load empty last partions and after a [...] 3631 171 76_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multiple LPARs zOS )3_Les21_db2dba@BTINTERNET.COM31_Tue, 29 Aug 2006 20:23:22 +0100525_US-ASCII Hi David,

I agree with you 100%, as I do with Tom and Joel.

The bottom line is that unless we start to see IBM play a little more rough ball with Oracle we are all going to be in fear of losing our jobs/careers/etc etc.

This reminds me so much of the betamax/VHS battle of the 80s. A much better product lost out to VHS ... Betamax was such a superior product that even to this day that format tape is still used for film work (well it was in my house two years ago when a major television [...] 3803 41 76_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multiple LPARs zOS )3_Les21_db2dba@BTINTERNET.COM31_Tue, 29 Aug 2006 20:32:00 +0100532_US-ASCII Owch ...

That is sad ... !

Les

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robert Jans Sent: 29 August 2006 18:12 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Dropping DB2 mainframe TCO (was: Accessing DB2 from multiple LPARs zOS )

Or how about when management uses IBM's offer of free UDB EEE software with only annual maintenance fees to leverage a better price out of Oracle. We're still paying for that one.............. [...] 3845 33 76_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multiple LPARs zOS )12_McKown, John29_John.Mckown@HEALTHMARKETS.COM31_Tue, 29 Aug 2006 14:32:07 -0500363_us-ascii Around here, I would have to say that nobody cares about TCO at all. What they care about is this year's budget. So, if I there is a product which costs $10,000/year and we plan to keep it for 3 years, it will win over a product which cost $20,000 up front for a 3 year license. The $30,000 spread over three years is "better" than the $20,000 right now. 3879 112 30_Re: Resume Yes and Compression9_Sam Baugh24_Sam.Baugh@MOTION-IND.COM31_Tue, 29 Aug 2006 14:42:47 -0500640_us-ascii If partitions are being reused then why not use KEEPDICTIONARY on LOAD?



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Backes, Mike Sent: Tuesday, August 29, 2006 1:33 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Resume Yes and Compression

Marc, to do a load replace at the part level would require 10 different steps/load cards, plus it would require me to presort my data being loaded into 10 different files. Basically I would have to do the work manually instead of letting db2 do the work for me. If it was a one time shot that would [...] 3992 142 50_Re: DB2V7 MAINFRAME REBUILD INDEX utility question9_Ford Wong14_fordie@SHAW.CA31_Tue, 29 Aug 2006 13:54:05 -0600488_us-ascii As Mike mentions please note that both indexes are specified in the same REBUILD index command.

If I remember correctly using two REBUILD INDEX commands would result in two complete scans of your tablespace to build the indexes. This may have changed?

The trade off is the workfile where DB2 puts the key entries will be bigger as DB2 builds the index keys for BOTH indexes with one scan through the tablespace and puts all key entries into the same workfile. [...] 4135 47 21_DB2 V8 CM on z/OS 1.60_19_csutfin@AMSOUTH.COM31_Tue, 29 Aug 2006 15:20:01 -0500315_us-ascii We attempted to migrate our test DB2 subsystem to V8 Compatibility Mode this weekend.

Prior to this we have done migration in the DBA sandbox and on our System testing LPAR. Both of these were successful and encountered no problems. Batch TSO, batch CAF and CICS jobs all worked with no hitch. [...] 4183 21 40_Connecting to DB2 on Mainframe from Java8_Ritesh M21_ritesh_77@HOTMAIL.COM31_Tue, 29 Aug 2006 20:42:51 +0000728_- Hi All,

I am looking for connecting to DB2 on mainframe from Java / J2EE application. Please can someone let me know how to do that with / wo DB2 Connect. Appreciate any pointer to steps to do for connecting and fetching data.

Thanks, Ritesh

--------------------------------------------------------------------------------- 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 4205 118 33_Re: New Index on SYSIBM.SYSTABLES12_Steve Grimes22_steve_grimes@WUSTL.EDU31_Tue, 29 Aug 2006 16:11:18 -0500911_US-ASCII Hello,

Adding the SET CURRENT SQLID did help (I guess) -- it changed the error message.

SET CURRENT SQLID = 'DBT1ADM'; ---------+---------+---------+---------+---------+---------+---------+-- DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ---------+---------+---------+---------+---------+---------+---------+--

CREATE INDEX SYSIBM.DSNDTX03 ON SYSIBM.SYSTABLES (TBCREATOR, TBNAME); ---------+---------+---------+---------+---------+---------+---------+-- DSNT408I SQLCODE = -204, ERROR: IS AN UNDEFINED NAME DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXICX2 SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 120 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000078' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION ---------+---------+---------+---------+---------+---------+---------+-- [...] 4324 71 44_Re: Connecting to DB2 on Mainframe from Java0_19_csutfin@AMSOUTH.COM31_Tue, 29 Aug 2006 16:28:16 -0500538_us-ascii If you search the archives you should find info for that.

Also you can look at

http://www-128.ibm.com/developerworks/db2/library/techarticle/0310chong/0310chong.html

It is the DB2 Connective Cheat Sheet.

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







"Ritesh M" To Sent by: "DB2 DB2-L@WWW.IDUGDB2-L.ORG Data Base cc Discussion List" [DB2-L] Connecting to DB2 on Mainframe from Java [...] 4396 61 76_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multiple LPARs zOS )35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 29 Aug 2006 17:43:38 -0400656_iso-8859-1 That's in keeping with overall corporate policy in America - only worry about the next quarterly report, and the hell with long range planning.

Joel Goldstein Responsive Systems Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works.... Predicts Group Buffer Pool performance too! www.responsivesystems.com (732) 972-1261 ----- Original Message ----- From: "McKown, John" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, August 29, 2006 3:32 PM Subject: Re: [DB2-L] Dropping DB2 mainframe TCO (was: Accessing DB2 from multiple LPARs zOS ) [...] 4458 253 33_Re: New Index on SYSIBM.SYSTABLES14_David S. Waugh16_dswaugh@LANL.GOV31_Tue, 29 Aug 2006 16:15:21 -0600629_US-ASCII Steve:

Hmmmm... It looks like your original problem (the -551) was that your id didn't have USE OF STOGROUP authority on the default storage group (usually SYSDEFLT), and that's where DB2 was trying to put this index (because you didn't originally specify a storage group in the CREATE INDEX statement).

Run this SQL statement to see who is authorized: SELECT * FROM SYSIBM.SYSRESAUTH WHERE NAME = 'SYSDEFLT' Usually, USE of SYSDEFLT is granted to PUBLIC (this is done by the DSNTIJSG installation job). It's possible someone revoked that at your site for security reasons (or got rid of the SYSDEFLT [...] 4712 399 33_Re: New Index on SYSIBM.SYSTABLES12_Steve Grimes22_steve_grimes@WUSTL.EDU31_Tue, 29 Aug 2006 17:51:35 -0500414_US-ASCII Hello David,

Good points all! I can't believe I missed the BP too! (It did end up in BP0.) Anyway, the auth for this new sysadm id ("DBT1ADM") was missing - no row in SYSRESAUTH. However, it does have:

Grantor Grantee QUALIFIER NAME SYSADM SYSADM SYSDEFLT SYSADM PUBLIC SYSDEFLT SYSADM PUBLIC DSNDB04 SYSDEFLT WU07TT PUBLIC DSNDB04 SYSDEFLT SYSADM DB2PM SYSDEFLT WU07TT PUBLIC SYSDEFLT [...] 5112 38 76_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multiple LPARs zOS )9_Tony Saul30_generalemaillists@YAHOO.COM.AU31_Wed, 30 Aug 2006 09:40:03 +1000455_iso-8859-1 I was just speaking to an IBM person the other day and mentioned this discussion on TCO. DB2 wasn't his area, but he said IBM did have occassions where they will provide "minimum charge" options to run a skeleton system to feed a "real" system. So back to the original question of accessing DB2 from multiple LPARs; maybe it is worth discussing with IBM what pricing deal they could do to have a base DB2 system feeding 1 full DB2 system. [...] 5151 200 33_Re: New Index on SYSIBM.SYSTABLES14_David S. Waugh16_dswaugh@LANL.GOV31_Tue, 29 Aug 2006 17:41:23 -0600327_US-ASCII Well, that's even more peculiar. The GRANT USE OF to PUBLIC for SYSDEFLT should have allowed you to create this index in the SYSDEFLT stogroup, even though you didn't specify it explicitly.

There's no authority specifically granted to DSNDB06 (at least not on my subsystems) so I doubt that's the problem. [...] 5352 60 33_Re: New Index on SYSIBM.SYSTABLES12_Steve Grimes22_steve_grimes@WUSTL.EDU31_Tue, 29 Aug 2006 20:02:09 -0500576_US-ASCII Hello again!

Well, I did verify that DBT1ADM had a row with SYSADMAUTH=G in SYSIBM.SYSUSERAUTH. I just looked at the other areas too...

SYSDEFLT is in SYSIBM.SYSSTOGROUP and SYSIBM.SYSVOLUMES, but in the latter it still has a hardcoded vol-ser (that does exist) and not the asterisk we're using for our master SMSGROUP. Since we had to make ACS routine changes (and RACF?) to get SMS and DB2 to work together, I'll bet it was failing on the allocation attempt. I didn't find any messages in DBT1MSTR but maybe they're in the log and I missed them. [...] 5413 70 37_Dynamic sql coming through db2connect16_Burnette, George27_George_Burnette@KYFBINS.COM31_Tue, 29 Aug 2006 21:07:27 -0400415_us-ascii Esteemed Listers - I am unable to find good documentation on how db2 v8 for zOS receives and processes dynamic sql sent via ado/oledb applications through db2connect 8,1 (enterprise on windows). Can anyone point me towards some good documentation? I also need to know what processes/stored procs need to be in place, packages to be bound, grants to be made to allow for the connection and processing. [...] 5484 45 9_db2 tools11_TRAVIS SHEN21_travis_shen@YAHOO.COM31_Tue, 29 Aug 2006 18:26:34 -0700350_iso-8859-1 Dear lister, We are z/os db2 v7 shops and plan to use db2 tools for speed recovery. Does anyone know which vendor product is good and in which area does it good than normal ibm utilitys? Search the web, I find GENDB2 from recoveryknowledge,can anyone using it to share some experience or how about others? Tks for help. Best Regards. [...] 5530 41 17_db2 recovery tool11_TRAVIS SHEN21_travis_shen@YAHOO.COM31_Tue, 29 Aug 2006 18:38:04 -0700341_iso-8859-1 Dear lister, We are z/os db2 v7 shops and plan to use db2 tools for speed recovery. Does anyone know which vendor product is good and in which area does it good than normal ibm utilitys? Search the web, I find GENDB2 from recoveryknowledge,can anyone using it to share some experience or how about others? Tks. Best Regards. [...] 5572 46 44_Re: Connecting to DB2 on Mainframe from Java12_Carlos Olson23_Carlos.Olson@INOVIS.COM31_Tue, 29 Aug 2006 19:21:39 -0700353_us-ascii You can use the JDBC Type 4 Driver to connect to DB2 on z/OS but you have to be licensed for DB2 Connect in order to get the driver. See the "DB2 UDB for OS/390 and z/OS V7 Application Programming Guide and Reference for Java(TM)" for sample code. http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnjvh18/CCONTENTS

Carlos Olson [...] 5619 190 21_Re: db2 recovery tool5_Craig23_craig@CRAIGSMULLINS.COM31_Tue, 29 Aug 2006 21:26:22 -0500444_us-ascii I think your primary vendors for recovery utilities (other than, of course, IBM) are (in alphabetical order):

*

BMC Software (www.bmc.com) *

CA (www.ca.com) *

CDB Software (www.sdbsoftware.com)

If you are looking to do a recovery of an SAP R/3 and DB2 environment, there are recovery tool built especially for that, too. One example is Software Engineering's (www.seg.de) PIT Recovery for DB2.0 [...] 5810 78 19_Re: special queries13_Harry William24_harry_williamt@YAHOO.COM31_Tue, 29 Aug 2006 22:17:43 -0700604_iso-8859-1 Hi Dave,

I was actually looking for a cookbook to write sqls. Sorry for the confusion.

Regards, Harry



"Seibert, Dave" wrote: Hi Harry,

Could you elaborate a little on what you mean by special queries?

Your example doesn't tell me exactly what kind of special queries you mean. Dave



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Harry William Sent: Tuesday, August 29, 2006 9:14 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] special queries [...] 5889 42 58_Load Utility Warnings while accessing data file on network13_sachin miraje27_sachinmiraje@REDIFFMAIL.COM31_Wed, 30 Aug 2006 05:41:32 -0000586_ISO-8859-1 Hi All,I have mounted a directory on one linux machine to DB2 server, which have a tab delimited data file with last column of Decimal Datatype.On DB2 server i am trying to execute a LOAD command with path of input data file parameter points to data file placed on another machine. It gives me error like \"SQL3124W  The field value in row \"F0-2\" and column \"3\" cannot be converted to a PACKED DECIMAL value, but the target column is not nullable.  The row was not loaded.\"If i place the same file on DB2 server and execute a LOAD command, it worked [...] 5932 97 25_Re: DB2 V8 CM on z/OS 1.613_Bell, Raymond22_raymond.bell@LANDG.COM31_Wed, 30 Aug 2006 09:29:35 +0100350_iso-8859-1 Hey Carol,

Sounds like you're only a few weeks ahead of us. We migrate our first 'public' subsystem to V8 CM in just over 3 weeks. Gulp. No gotchas so far. QMF 8.1 was a doddle, and we're going thru the BMC software upgrades now - again, so far so good. Only thing that worries me is that it seems to be going fairly smoothly. [...] 6030 231 53_Compuware September 2006 Technical Spotlight Sessions17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Wed, 30 Aug 2006 10:23:13 +0100373_us-ascii Hi All,

please find below the September schedule for Spotlight Sessions, for all you Compuware users/customers out there.

Remember, our customers are required to register for FrontLine to access these sessions, the September 12 Spotlight is a great opportunity to register and gain an insight and understanding of how FrontLine can benefit you. [...] 6262 23 31_Re: Recover data using DSN1COPY19_Alekos Papadopoulos13_apapad@NBG.GR31_Wed, 30 Aug 2006 05:39:19 -0500372_- Hello David,

Resolve all space issues you might get (00D70025 for example) by adding some free volumes and then let DB2 to create the datasets, by creating the tablespace with PRIQTY 2097152 SECQTY 0

Short story behind : Db2 gets the exact 2GB size by decreasing automatically the size of last extend. This cannot be done by DSN1COPY, at least in V6. [...] 6286 114 28_FW: Automate DB2 Maintenance17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Wed, 30 Aug 2006 12:36:09 +0100514_us-ascii Hello list,

did anyone else receive this or am I being personally chosen due to my natural gifts or whatever?

This means are pure spamming - sending personal emails to addresses off a mailing list.

ciao!

Aurora Emanuela Dell'Anno Compuware Ltd. Systems Engineer, Mainframe pre-Sales ________________________________________________________________________ ___________________

email: aurora.dellanno@compuware.com tel. : +44 (0)1753 444331 cell.: +44 (0)7779 881331 [...] 6401 147 32_Re: FW: Automate DB2 Maintenance13_Pearson, Eric19_Eric.Pearson@53.COM31_Wed, 30 Aug 2006 07:45:28 -0400455_us-ascii Yes, this is the second ad-spam I've received in the last week with no reason to suspect the sender got my address other than from this list.

The other SPAM was from 'DB2RECOVER@aol.com' .

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dell'Anno, Aurora Sent: Wednesday, August 30, 2006 7:36 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] FW: Automate DB2 Maintenance [...] 6549 289 45_Antwort: [DB2-L] FW: Automate DB2 Maintenance11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 30 Aug 2006 13:54:20 +0200396_us-ascii As a vendor I also find all the ads a little annoying, whats odd is the spam you got, I didn't get (Maybe they know my firm...) but I do get loads of other spam.....



Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de [...] 6839 139 32_Re: FW: Automate DB2 Maintenance13_Michael Ebert18_mebert@AMADEUS.COM31_Wed, 30 Aug 2006 13:56:26 +0200492_US-ASCII I got it as well. I think I received a phonecall from them as well, two or three months ago.

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















"Dell'Anno, Aurora" Please respond to DB2 Database Discussion list at IDUG Sent by: DB2 Data Base Discussion List 30-08-06 13:36 [...] 6979 141 32_Re: FW: Automate DB2 Maintenance12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Wed, 30 Aug 2006 07:02:29 -0700326_US-ASCII Aurora:

I got one as well. I went back and double checked because I read both the technical address and the sales address at the same time. This was sent to the technical address that I use with the list server.

I just added the sender to my JUNK Mail filter. I average about 50 junk emails a day. [...] 7121 72 19_Re: special queries10_Bruce, Mae19_Mae.Bruce@OA.MO.GOV31_Wed, 30 Aug 2006 07:11:43 -0500887_us-ascii http://mysite.verizon.net/Graeme_Birchall/id1.html -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Harry William Sent: Wednesday, August 30, 2006 12:18 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] special queries



Hi Dave,

I was actually looking for a cookbook to write sqls. Sorry for the confusion.

Regards, Harry

--------------------------------------------------------------------------------- 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 7194 215 32_Re: FW: Automate DB2 Maintenance12_Martin Hubel17_Martin@MHUBEL.COM31_Wed, 30 Aug 2006 08:15:42 -0400 7410 45 44_Re: Connecting to DB2 on Mainframe from Java13_Crissy, Frank28_Frank_N_Crissy@HOMEDEPOT.COM31_Wed, 30 Aug 2006 08:19:10 -0400517_us-ascii You need to use Type 4 Java driver and with that you no longer need db2connect services.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ritesh M Sent: Tuesday, August 29, 2006 3:43 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Connecting to DB2 on Mainframe from Java



Hi All,

I am looking for connecting to DB2 on mainframe from Java / J2EE application. Please can someone let me know how to do that with / wo DB2 [...] 7456 17 30_Re: Resume Yes and Compression33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Wed, 30 Aug 2006 07:23:43 -0500438_- Mike

We experienced the same problem, when we load into empty partitions of a non-empty partitioned tablespace. If the tablespace is completely empty, a compression dictionary will be build for each partition, records are loaded into. That works as designed. I raised a requirement, I think, two years ago, excatly for that problem, and I believe it is "accepted" meaning it will be implemented in one of the next releases. [...] 7474 21 30_Re: Resume Yes and Compression9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 30 Aug 2006 07:58:26 -0500326_- The DB2 LOAD utility was changed as part of V7 to build a dictionary during a LOAD RESUME YES SHRLEVEL NONE into an empty tablespace or partition. If this is not happening, please contact IBM support to get it fixed. I see that the Utility Guide and reference did not get properly updated to reflect this new behavior. [...] 7496 67 30_Re: Resume Yes and Compression12_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Wed, 30 Aug 2006 08:37:49 -0500412_us-ascii Jim, Thank you for answering. I went to IBM support to get it fixed already. ETR 37283 I believe. It was after they told me it 'was working as designed' that I posted the message here, because it is not working as you described below.

Maybe im doing something wrong, my load card looks like this. LOAD DATA LOG NO RESUME YES KEEPDICTIONARY INDDN SYSREC01 - INTO TABLE xxxxxxxx.xxxxxxxxxxxxx [...] 7564 51 43_Re: Stored procedures Implementation - z/OS17_Walter Trovijo Jr19_wtrovijo@ELB.COM.BR31_Wed, 30 Aug 2006 10:51:37 -0300302_us-ascii >You would not want to mix your Rexx SPs in an applenv with non-Rexx SPs. One reason for this is that you need NUMTCB=1 for Rexx and this is unlikely to be good for your Cobol SPs. We do not use >Java SPs but I remember hearing that these should be separate too, but cannot remember why. [...] 7616 22 32_Re: FW: Automate DB2 Maintenance0_19_csutfin@AMSOUTH.COM31_Wed, 30 Aug 2006 09:08:53 -0500622_us-ascii You are not being singled out Aurora.

I get them also.

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

--------------------------------------------------------------------------------- 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 7639 14 30_Re: Resume Yes and Compression9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 30 Aug 2006 09:10:37 -0500640_- Ahhhhhh. I see the problem. The KEEPDICTIONARY essentially says "don't build a dictionary". Remove that and it wil work fine.

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 7654 52 32_Re: FW: Automate DB2 Maintenance13_Pearson, Eric19_Eric.Pearson@53.COM31_Wed, 30 Aug 2006 10:20:25 -0400435_us-ascii Perhaps we should report these SPAMmers to the 'abuse' and/or 'postmaster' addresses at their ISPs?

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of csutfin@AMSOUTH.COM Sent: Wednesday, August 30, 2006 10:09 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] FW: Automate DB2 Maintenance

You are not being singled out Aurora.

I get them also. [...] 7707 47 41_Re: Dynamic sql coming through db2connect17_Walter Trovijo Jr19_wtrovijo@ELB.COM.BR31_Wed, 30 Aug 2006 11:23:08 -0300589_us-ascii >Esteemed Listers - I am unable to find good documentation on how db2 v8 for zOS receives and processes dynamic sql sent via ado/oledb applications through db2connect 8,1 (enterprise on windows). >Can anyone point me towards some good documentation? I also need to know what processes/stored procs need to be in place, packages to be bound, grants to be made to allow for the connection and >processing. On the zOS side you need to run DSNTIJMS to create objects used by client tools when doing DB2 zOS catalog access. On the client side you need to bind DB2 client packages [...] 7755 166 43_Re: Stored procedures Implementation - z/OS17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Wed, 30 Aug 2006 09:23:31 -0500802_us-ascii I'd love to see this topic presented, perhaps as a subtopic of a larger presentation at IDUG/Share/Whatever the tech conference is called. Things have gotten complex in a hurry.





Rich Gugel State of Wisconsin Department of Administration DB2 Systems Programmer











--------------------------------------------------------------------------------- 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 7922 41 30_Re: : Automate DB2 Maintenance17_Walter Trovijo Jr19_wtrovijo@ELB.COM.BR31_Wed, 30 Aug 2006 11:29:25 -0300680_us-ascii Me too. That led me to think about offering solutions I've developed over the years for automation; Anyone interested?

Never mind, just a joke.

Walter Trovijo Jr.







--------------------------------------------------------------------------------- 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 7964 171 43_Re: Stored procedures Implementation - z/OS12_Travis, John25_john.travis@CAPGEMINI.COM31_Wed, 30 Aug 2006 15:51:45 +0100699_us-ascii

Walter,

See DB2 for z/OS Stored Procedures redbook (SG24-7083-00) Chapter 4 Table 4-1

Regards, John Travis

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Walter Trovijo Jr Sent: 30 August 2006 14:52 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Stored procedures Implementation - z/OS





>You would not want to mix your Rexx SPs in an applenv with non-Rexx SPs. One reason for this is that you need NUMTCB=1 for Rexx and this is unlikely to be good for your Cobol SPs. We do not use >Java SPs but I remember hearing that these should be separate too, but cannot [...] 8136 75 30_Re: Resume Yes and Compression12_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Wed, 30 Aug 2006 10:06:31 -0500482_us-ascii Jim, At first I thought that too, in fact that is how I got involved in looking at what is going on and thinking there was a problem. With what I submitted to support with the ETR, I tried that and it did not build a dictionary.(see job 4)



Quick sypnopsis of the job listings I have sent to support with the ETR/PM? Whatever its called. Job 1. LOAD DATA LOG YES RESUME YES KEEPDICTIONARY INDDN SYSREC04 result: data loaded into empty partition no dict. [...] 8212 69 44_Re: FW: Automate DB2 Maintenance SPAM Issue?35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 30 Aug 2006 11:09:02 -0400375_iso-8859-1 While obviously annoying to some, I never even noticed them with the hundreds of real spam emails I get per day - and that's what gets through the filters I have set up.

So what is spam? We may have differing opinions on this. Is it just any un-solicited email? This strict definition probably puts 99% of the emails in the world into a spam category. [...] 8282 65 43_Re: Stored procedures Implementation - z/OS17_Walter Trovijo Jr19_wtrovijo@ELB.COM.BR31_Wed, 30 Aug 2006 12:11:50 -0300770_us-ascii Thanks a lot John! Going to download and RTFM right now!

Regards,

Walter Trovijo Jr.











Walter,

See DB2 for z/OS Stored Procedures redbook (SG24-7083-00) Chapter 4 Table 4-1

Regards, John Travis







--------------------------------------------------------------------------------- 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 8348 72 44_Re: FW: Automate DB2 Maintenance SPAM Issue?13_Bell, Raymond22_raymond.bell@LANDG.COM31_Wed, 30 Aug 2006 16:21:36 +0100450_iso-8859-1 Got the old grey matter thinking for a second, Joel. Any key, any key... Must be some American keyboard difference. Then the penny dropped. Most amusing. Nice one.

Oh, and does this count as spam? Off-topic, certainly. So sue me.



Raymond Bell Database Administrator



...

So - after my rather long rant - if you aren't interested in an email, use the delete key. Right next to the "any" key. [...] 8421 238 49_Copy After Catalog Reorg - Pre V8 Migration Steps18_Prather, Doug, ISD28_Dprather467@WORLDSAVINGS.COM31_Wed, 30 Aug 2006 10:10:24 -0500442_us-ascii I reorged our DB2 V7.1 z/OS catalog successfully and as expected the objects were left in a copy pending status. Thinking it would be simple to run DSNTIJIC to back them up (with SYSCOPY as the last object to be copied) would work, I found I was wrong. I had to copy SYSCOPY stand alone and then run DSNTIJIC. I received the error message below. If anyone knows a better work around or shed any light, I'd appreciate any input. [...] 8660 245 49_Copy After Catalog Reorg - Pre V8 Migration Steps18_Prather, Doug, ISD28_Dprather467@WORLDSAVINGS.COM31_Wed, 30 Aug 2006 10:17:50 -0500442_us-ascii I reorged our DB2 V7.1 z/OS catalog successfully and as expected the objects were left in a copy pending status. Thinking it would be simple to run DSNTIJIC to back them up (with SYSCOPY as the last object to be copied) would work, I found I was wrong. I had to copy SYSCOPY stand alone and then run DSNTIJIC. I received the error message below. If anyone knows a better work around or shed any light, I'd appreciate any input. [...] 8906 189 33_Re: New Index on SYSIBM.SYSTABLES14_David S. Waugh16_dswaugh@LANL.GOV31_Wed, 30 Aug 2006 10:15:37 -0600599_US-ASCII Steve: I wonder what would happen if you changed the stogroup name in your SQL to SYSDEFLT instead of SMSGROUP? I'd bet it would fail.

CREATE INDEX SYSIBM.SQLDTX99 ON SYSIBM.SYSTABLES (TBCREATOR ASC, TBNAME ASC) USING STOGROUP SYSDEFLT PRIQTY 720 SECQTY 720 ERASE NO FREEPAGE 10 PCTFREE 00;

Error messages would more likely be in the DBM1 output rather than MSTR, as that's the address space that does the dynamic allocation. They would for sure be in the MVS log, in any case. . Thanks, . David Waugh IST - BSI DB2 Database Administration Los Alamos National Laboratory [...] 9096 253 19_Re: special queries14_David S. Waugh16_dswaugh@LANL.GOV31_Wed, 30 Aug 2006 10:18:59 -0600481_US-ASCII Harry: Take a look at this web site - it might provide what you're looking for:

http://mysite.verizon.net/Graeme_Birchall/id1.html . . Thanks, . David Waugh IST - BSI DB2 Database Administration Los Alamos National Laboratory







Harry William Sent by: DB2 Data Base Discussion List 08/29/2006 11:17 PM Please respond to DB2 Database Discussion list at IDUG [...] 9350 179 53_Re: Copy After Catalog Reorg - Pre V8 Migration Steps14_David S. Waugh16_dswaugh@LANL.GOV31_Wed, 30 Aug 2006 10:49:13 -0600489_UTF-8 Doug:

Common problem - "working as designed". SYSCOPY is supposed to be the last catalog tablespace reorged, because the reorg turns on the copy pending flag for it. Once the copy pending flag is turned on for SYSCOPY, any subsequent utility (like another reorg or an image copy) that writes anything to SYSCOPY will fail. So you need to turn the copy pending flag off, and you can do that either by doing an image copy of SYSCOPY or doing a REPAIR to turn off the flag. [...] 9530 158 43_Re: Stored procedures Implementation - z/OS13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 30 Aug 2006 13:23:44 -0400602_US-ASCII Peggy Zagelow - the team lead for Stored Procedure development at DB2 SVL - can always be counted on for excellent presentations on Stored Procedures. Here's one from last years North American DB2 tech conference on Best Practices for SPs. See ftp://ftp.software.ibm.com/software/data/db2zos/Z31.pdf



Dave



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Walter Trovijo Jr Sent: Wednesday, August 30, 2006 9:52 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Stored procedures Implementation - z/OS [...] 9689 34 28_LUW V8.2 Monitoring question10_Dave Nance16_dav1mo@YAHOO.COM31_Wed, 30 Aug 2006 10:34:48 -0700397_iso-8859-1 Hey all, I have recently gone to the other side. Now supporting DB2 on Linux, instead of mainframe. I'm wanting to get a list of stored procedures that need some tuning done. Its fairly easy for me to find the names of the real long running procs. My question is how could I get a list of processes that are running in the 2 - 10 second range, without turning on event monitoring? [...] 9724 37 30_SQL finding special characters10_Dave Nance16_dav1mo@YAHOO.COM31_Wed, 30 Aug 2006 10:43:24 -0700405_iso-8859-1

Alright SQL guru time.

How in a SQL statement would you find the following:

I want to find all occurances of COTE, but I, also, want to find it if it has special characters, for instance Cóté. My thought is to store the data twice, once, as it is displayed and once as a searchable field with the latin equivalent of the letter. Any help is much appreciated. Thanks. [...] 9762 164 32_Re: FW: Automate DB2 Maintenance7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 30 Aug 2006 10:50:53 -0700379_iso-8859-1 I was promised a velvet picture of Elvis and Liberace together again!

Martin Hubel wrote: As opposed to unpure spamming? And I thought it was because they liked me. I was waiting for the offer of a free toaster, a £1,000,000 prize in the lottery in which I didn't buy a ticket, or the chance to have body parts enhanced. >> Hello list, [...] 9927 64 34_Re: SQL finding special characters11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 30 Aug 2006 13:02:05 -0500462_- Dave,

I think you should be able to do this using the TRANSLATE function. Stroring it redundantly as you indciated would probably perform better anyway.

You would specify something like

WHERE TRANSLATE(colname, 'to-chars', 'from-chars') = ...

I am not sure how my results will be displayed here but here is an example:

SELECT TRANSLATE ('CóTé', 'OE', 'óé') FROM SYSIBM.SYSDUMMY1 ---------+---------+---------+---------+ [...] 9992 97 34_Re: SQL finding special characters10_Dave Nance16_dav1mo@YAHOO.COM31_Wed, 30 Aug 2006 11:46:00 -0700581_iso-8859-1 Yes that would work for that situation, but the problem with that is this input would be pretty mcuh the only input to the query on several million row tables. Using TRANSLATE would make it non-matching index access and give me poor performance. Also, what about finding those letters with other special characters, such as Ò, ô, œ, ø, if the user had entered an "O" in the search string we would want to find all variations of it. This functionality exists on the different search engines(ggogle, yahoo...) and performs well. Though the only way I can think to do [...] 10090 85 44_Re: Connecting to DB2 on Mainframe from Java12_Carlos Olson23_Carlos.Olson@INOVIS.COM31_Wed, 30 Aug 2006 12:16:11 -0700623_us-ascii You don't need the services but you still have to buy a DB2 Connect product. See the FAQ's (13) in the following link:

"To obtain JDBC drivers (including Type 4 JDBC Driver) licensed for use with the zSeries and iSeries servers, the customer must purchase an appropriate DB2 Connect product."

http://www-306.ibm.com/software/data/db2/db2connect/faq-v82.html

This is another one of those increased TCO to run on a mainframe. You can use the JDBC Type 4 drivers for free with DB2 on Linux, UNIX or Windows but you have to have DB2 Connect to use the driver on i and z series. See the below [...] 10176 61 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 30 Aug 2006 19:51:19 GMT380_- Interesting discussion on this subject. Hope IBM is paying attention.

It's a shame that Oracle can lie their buns off time after time and continue to get away with it. You would think it would all catch up to them sooner or later, but so far it doesn't seem to have. I know if I treated my customers the way they treat theirs, I'd be out of business in short order. [...] 10238 115 34_Re: SQL finding special characters11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 30 Aug 2006 14:56:56 -0500675_- Dave,

I agree re. performance. You wanted an SQL solution... now you want it to perform too?... (:

Thx Suresh



>From: Dave Nance >Reply-To: DB2 Database Discussion list at IDUG >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] SQL finding special characters >Date: Wed, 30 Aug 2006 11:46:00 -0700 > > Yes that would work for that situation, but the problem with that is >this input would be pretty mcuh the only input to the query on several >million row tables. Using TRANSLATE would make it non-matching index access >and give me poor performance. Also, what about finding those letters with [...] 10354 162 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )13_Michael Ebert18_mebert@AMADEUS.COM31_Wed, 30 Aug 2006 22:05:29 +0200367_US-ASCII That's probably because managers worry about their jobs too... admitting a multi-million-dollar mistake is not a good career move. If everyone else is nodding and saying how happy they are now that they've got Oracle, it's obvious that it's the manager who's at fault... so no-one wants to be the first to say, "the marquise d'O has got no clothes on!" [...] 10517 90 10_IDMS - DB210_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Wed, 30 Aug 2006 15:09:39 -0500364_us-ascii Has anyone here been through a successful large-scale IDMS - DB2 conversion; specifically one with heavy ADS/O and ADS/A usage? lf so, would you be willing to have some off-line discussions regarding any life lessons you may have learned in the process.

P.S. No vendors at this time please.......you will get your opportunity at a later date. [...] 10608 82 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )15_Mitchell, Kelly18_kmitchell@PLLS.COM31_Wed, 30 Aug 2006 13:11:18 -0700395_us-ascii I've been reading this with interest...I still read the list too....but I watched my large Fortune 500 shop hire a CIO who proclaimed the mainframe dead and then proceeded to hire an Oracle/Unix bigot as the enterprise architect...we were then converted to the new coolaid and many lost their jobs as the mainframe's presence dwindled yet IT costs sky-rocketed...sigh...I miss DB2 [...] 10691 305 14_Re: IDMS - DB29_Dee Reins24_dee.reins@CENTURYTEL.COM31_Wed, 30 Aug 2006 16:00:55 -0500493_us-ascii I did one about 8 years ago. The response time doubled and we had our DB2 system tuned better than the vendor.





If this is not perspicuous please let me know. Dee Reins dee.reins@centurytel.com 360 905-7343 Business 360 905-7212 Fax 360 608-5262 Cell

_____

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin, Jim Sent: Wednesday, August 30, 2006 1:10 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IDMS - DB2 [...] 10997 95 14_Re: IDMS - DB213_javier sotela19_jsotela@HOTMAIL.COM31_Wed, 30 Aug 2006 17:20:14 -0400524_- Hi Jim:

We are in the process of the migration from idms adso and cobol batch with idms to 3-tier with java and db2 database. We are learning a lot, there is a company that its the responsable for the migration . At this time we are analizing the database model migration and preparing the db2 database, but there is still nothing in production at this time. Just working hard with this migration. If you have some specific question you can send me an email directly to me and I will respond as much as I can. [...] 11093 206 14_Re: IDMS - DB235_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 30 Aug 2006 17:26:12 -0400396_iso-8859-1 Hi Jim,

The key to performance is DESIGN. PORT is a 4 letter word.

The obvious issue is the cost of re-design and re-coding, versus some black box interface. You can pay on the re-design/re-coding side, or pay on the performance side with increased cpu costs and probably a processor upgrade.

There have been many successful conversions, and a few disasters. [...] 11300 102 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Wed, 30 Aug 2006 21:07:23 -0500540_us-ascii I have to tell one more Oracle story. I don't know all of the details, because in this case I am only a user of the system. I have one client that uses Oracle Time and Labor to enter time sheets. Recently the system was down for two weeks for changes to the system. I'm sure the employees were paid even though they could not input their time sheets, but for contractors, this meant that for two weeks the company did not pay for hours worked because they could not enter them into the system. What possible change could take [...] 11403 68 72_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPA...0_17_JTonchick@AOL.COM29_Wed, 30 Aug 2006 23:59:49 EDT508_US-ASCII One reason the business community does not hear about the Oracle true costs is the short average tenure of CIO's in companies since the Internet bubble burst. The average tenure is now only three years, too short for some of the failures to "stick". As CIOs leave companies, they reap the short term benefits of the Oracle conversions and leave for "greener pastures" before the true cost of those conversions affect the corporate budget. In rare cases, they are forced out by failed projects. [...] 11472 43 21_Re: db2 recovery tool0_22_DB2information@AOL.COM29_Thu, 31 Aug 2006 03:47:49 EDT569_US-ASCII You may wish to look at www.recoveryknowledge.com for DB2 recovery automation.

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 11516 25 28_From S/390 V2R10 to z/OSV1R415_Katharine Brown25_kathrinebrown@HOTMAIL.COM31_Thu, 31 Aug 2006 08:19:30 +0000520_- The MVS team out here is planning to upgrade the OS from OS/390 V2R10 to z/OS V1R4. Could anyone suggest as to what precaution needs to be taken from DB2 V7.1. Has anyone encountered any problems in DB2 during z/OS upgrade.

Any help would be appreciated.

Rgds kathy

_________________________________________________________________ Get real-time traffic reports with Windows Live Local Search http://local.live.com/default.aspx?v=2&cp=42.336065~-109.392273&style=r&lvl=4&scene=3712634&trfc=1 [...] 11542 113 44_Re: FW: Automate DB2 Maintenance SPAM Issue?17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Thu, 31 Aug 2006 11:10:17 +0100289_us-ascii Hey Joel how's tricks?

In principle, I agree with the "if you don't like it delete it" rule, it is just puzzling that since I have had this very email address only for 8 weeks, the company who used it to send me competitive information ;-) must have got it from here. [...] 11656 51 14_Re: IDMS - DB215_Chris Hoelscher21_choelscher@HUMANA.COM31_Thu, 31 Aug 2006 07:46:45 -0400428_US-ASCII .... and we had our DB2 system tuned better than the vendor.



really? what methods did you employ to tune the vendor?





The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. [...] 11708 16 23_multi row insert syntax10_John Lantz20_john.p.lantz@FRB.GOV31_Thu, 31 Aug 2006 06:40:41 -0500298_- I'm running DB2 V8 NFM and I'm trying to do a multi-row insert. In the UDB environment, the following syntax works: INSERT INTO table VALUES (1,2,3),(4,5,6),(7,8,9) which will insert 3 rows into the table.

When I try the same syntax on z/os, I get a -104. Does this not work in z/os? [...] 11725 338 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Thu, 31 Aug 2006 08:11:24 -0400465_us-ascii I also have been reading this with interest; our CIO also believes that migrating applications from the mainframe to Unix will save the company TONS money.





We out source our main frame systems support, so the system administrators and system programmers costs are included in the monthly bill. It is difficult to get the 'budget people' to include the MANY Unix administrator's salary and benefits when doing a cost comparison. [...] 12064 109 27_Re: multi row insert syntax9_Agus Kwee19_askwe@OPTONLINE.NET31_Thu, 31 Aug 2006 12:39:47 +0000414_us-ascii John,

The multi row insert in DB2 z/OS V8 only works in embedded SQL statement in application program. A sample syntax in Cobol application program is like this: exec sql insert into table values (:var1, :var2,:var3) end-exec. var1, var2, var3 must be array variables ( defined using occurs n times) where the n is the number of rows that you planned to insert with a single insert statement. [...] 12174 190 32_Re: FW: Automate DB2 Maintenance17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Thu, 31 Aug 2006 13:45:03 +0100748_iso-8859-1 tsk. I never got that. I protest most strongly :-(

ciao!

Aurora Emanuela Dell'Anno Compuware Ltd. Systems Engineer, Mainframe pre-Sales ___________________________________________________________________________________________

email: aurora.dellanno@compuware.com tel. : +44 (0)1753 444331 cell.: +44 (0)7779 881331

___________________________________________________________________________________________

No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced.



________________________________

From: Ed Long [mailto:rdhm99a@PRODIGY.NET] Sent: 30 August 2006 18:51 Subject: Re: FW: Automate DB2 Maintenance [...] 12365 244 32_Re: FW: Automate DB2 Maintenance13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Thu, 31 Aug 2006 09:08:06 -0400539_iso-8859-1 Hey Aurora,

One of my sons is going to university in Kalamazoo.

He could stop into the 7-11 there and ask Elvis if he still has any of those velvet paintings left.

I'm sure, with the proper exchange of fees, a copy could be obtained.

Dave



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dell'Anno, Aurora Sent: Thursday, August 31, 2006 8:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] FW: Automate DB2 Maintenance [...] 12610 122 18_IDUG Presentations17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Thu, 31 Aug 2006 14:13:54 +0100542_us-ascii Yes I know one should not leave everything to the last moment but I did.

Anybody else having kittens trying to submit a presentation on the IDUG website, at http://idugew.prod.web.sba.com/callpapers/CallPapers.cfm?conference_id=6 1?

ciao!

Aurora Emanuela Dell'Anno Compuware Ltd. Systems Engineer, Mainframe pre-Sales ________________________________________________________________________ ___________________

email: aurora.dellanno@compuware.com tel. : +44 (0)1753 444331 cell.: +44 (0)7779 881331 [...] 12733 146 22_Re: IDUG Presentations0_25_LL581@DAIMLERCHRYSLER.COM31_Thu, 31 Aug 2006 09:20:08 -0400402_US-ASCII Aurora,

I was able to bypass most of the kittens. I did this by first ensuring that all my Internet Explorer files and cookies were deleted. I then went to the IDUG home page and navigated from there.

I believe that the presentation submission form stores "something" in a cookie; my first presentation submission worked, but later ones did not. Until I deleted the cookie. [...] 12880 313 32_Re: FW: Automate DB2 Maintenance13_Jackson, Jeff20_Jeff.Jackson@FMR.COM31_Thu, 31 Aug 2006 09:33:03 -0400433_iso-8859-1 I thought Elvis was hanging out in a Dunkin Donuts or Burger King there???

Jeff

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Seibert, Dave Sent: Thursday, August 31, 2006 9:08 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] FW: Automate DB2 Maintenance



Hey Aurora,

One of my sons is going to university in Kalamazoo. [...] 13194 449 32_Re: FW: Automate DB2 Maintenance13_Bell, Raymond22_raymond.bell@LANDG.COM31_Thu, 31 Aug 2006 14:51:37 +0100463_iso-8859-1 Reminds me of that Gary Larson cartoon, the one with Elvis and Salman Rushdie taking a sneak peak out their motel room window at the world.

And, OK then, yes I will have fries with that.



Raymond

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Jackson, Jeff Sent: 31 August 2006 14:33 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] FW: Automate DB2 Maintenance [...] 13644 70 52_[DB2V7 on z/OS] Interesting Catalog Query / PAGESAVE15_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Thu, 31 Aug 2006 10:06:34 -0400344_ISO-8859-1 It occurred to me to wonder whether we're getting good results from our policy of defaulting to "COMPRESS YES" in our production OLTP subsystem, and after a bit of experimenting, I came up with this fairly simple query. It identifies cases where compression has not yielded good results for the data. Hope it's useful to y'all. [...] 13715 259 22_Re: IDUG Presentations13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 31 Aug 2006 09:09:36 -0500562_us-ascii Aurora,

You are not the only one that has put off submitting abstracts to the last minute. I am having the same problem and I have tried getting to the submission page a number of ways and all the tricks I could think of.

LL581@DAIMLERCHRYSLER.COM wrote:

> > Aurora, > > I was able to bypass most of the kittens. I did this by first > ensuring that all my Internet Explorer files and cookies were deleted. > I then went to the IDUG home page and navigated from there. > > I believe that the presentation submission form stores [...] 13975 96 22_Re: IDUG Presentations13_Phil Grainger30_philg@PHILGRAINGER.DEMON.CO.UK31_Thu, 31 Aug 2006 15:29:52 +0100610_- I uploaded one this morning with no rpoblems (honest)

I started at http://idugew.prod.web.sba.com/callpapers/CallLogin.cfm?conference_id=60 , and clicked on the "login here" link. From there it should be easy.....

Mind you, I just tried to navigate to that url again now, and it's either slow or dead :(

Phil G CA

wfavero@ATTGLOBAL.NET wrote: > Aurora, > You are not the only one that has put off submitting abstracts to the > last minute. I am having the same problem and I have tried getting to > the submission page a number of ways and all the tricks I could think of. > [...] 14072 281 14_Re: IDMS - DB29_Dee Reins24_dee.reins@CENTURYTEL.COM31_Thu, 31 Aug 2006 09:49:02 -0500351_us-ascii Good one, the vendor was Canadian. The tips for tuning seem to have something lost in the translation.

The vendor had the entire IDMS system in one file.





In the conversion from IDMS to DB2 we lost the speed of DBAM access methods. It is possible to read the IDMS dictionary and create DB2 file definitions. [...] 14354 248 22_Re: IDUG Presentations13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 31 Aug 2006 09:48:43 -0500670_us-ascii I method I try "times out".....

I think it must be a conspiracy... LOL

Willie Favero My DB2 Blog --> http://blogs.ittoolbox.com/database/db2zos

Phil Grainger wrote:

>I uploaded one this morning with no rpoblems (honest) > >I started at http://idugew.prod.web.sba.com/callpapers/CallLogin.cfm?conference_id=60 , and clicked on the "login here" link. From there it should be easy..... > >Mind you, I just tried to navigate to that url again now, and it's either slow or dead :( > >Phil G >CA > >wfavero@ATTGLOBAL.NET wrote: > > >>Aurora, >>You are not the only one that has put off submitting abstracts to the >>last minute. I am [...] 14603 24 69_IDUG2007 NA Call-for-presentations - trouble upaloding? Please read!!11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 31 Aug 2006 09:57:26 -0500299_- We are aware of the issue and HQ is working on it. Please bear with us. I will provide an update as soon as it is available.

Rest assured that we will extend the deadline if we have to. Your participation is needed to make the conference a success!

Sorry for the inconvenience. [...] 14628 85 59_Re: IDUG2007 NA Call-for-presentations - trouble upaloding?12_Martin Hubel17_Martin@MHUBEL.COM31_Thu, 31 Aug 2006 11:11:55 -0400 14714 25 36_DB2 Connect where can I download it.9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Thu, 31 Aug 2006 11:17:55 -0500299_us-ascii Does anyone know how to or where to get DB2 Connect PE EE or CAE, possibly a download on from the WEB.

Thanks Dee

"If we ever forget that we're one nation under God, then we will be a nation gone under." Dee Reins 360 905-7343 Business 360 905-7212 Fax 360 608-5262 Cell [...] 14740 404 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 31 Aug 2006 12:43:28 -0400323_iso-8859-1 Well, I have never yet heard of any "documented" case where moving off the mainframe has saved a major corp. money.

Caveat Emptor!!

If Oracle is telling them they can reduce the TCO - ask them for several clients as references, and then find out how they measured their "supposed" TCO saving. [...] 15145 49 32_Re: From S/390 V2R10 to z/OSV1R412_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 31 Aug 2006 20:06:05 +0200588_US-ASCII Hi,

Actually you can now go direct to 1.6 instead of 1.4

Isaac Yassin



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Katharine Brown Sent: Thursday, August 31, 2006 10:19 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] From S/390 V2R10 to z/OSV1R4



The MVS team out here is planning to upgrade the OS from OS/390 V2R10 to z/OS V1R4. Could anyone suggest as to what precaution needs to be taken from DB2 V7.1. Has anyone encountered any problems in DB2 during z/OS upgrade. [...] 15195 110 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )3_Les21_db2dba@BTINTERNET.COM31_Thu, 31 Aug 2006 19:18:15 +0100313_us-ascii Kelly Unless big blue step up to the plate and put on some pretty big gloves then we're all doomed.

I have a feeling that IBM will come out fighting with version 9 of its software (on all platforms).

9 on the mainframe is some kinda software .. It will be the best from every angle .. [...] 15306 116 77_Re: Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS )12_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 31 Aug 2006 21:25:26 +0200433_us-ascii Hi

It may be the best, but the price will make it a beast

(sorry, nearly Friday, couldn't resist)

Isaac Yassin



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Les Sent: Thursday, August 31, 2006 8:18 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Dropping DB2 mainframe TCO (was: Accessing DB2 from multip le LPARs zOS ) [...] 15423 332 22_Re: IDUG Presentations13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 31 Aug 2006 13:49:30 -0500669_us-ascii Looks the IDUG's web site for submitting abstracts is back up and running.

I would wait about 10 minutes before using it though.. that way I will have a chance to upload my abstracts...LOL...

Willie

Willie Favero wrote:

> I method I try "times out"..... > > I think it must be a conspiracy... LOL > > Willie Favero > My DB2 Blog --> http://blogs.ittoolbox.com/database/db2zos > > Phil Grainger wrote: > >>I uploaded one this morning with no rpoblems (honest) >> >>I started at http://idugew.prod.web.sba.com/callpapers/CallLogin.cfm?conference_id=60 , and clicked on the "login here" link. From there it should be easy..... >> [...] 15756 41 54_Deadlocks due to Java programs from Application server13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 31 Aug 2006 14:56:32 -0400416_us-ascii Hi, What the best practices to reduce contention problems due to Java programs to Z/OS (from weblogic). We are see a lot more timeouts than before due to the Java programs. Do the programmers have to explicitly close connections within their programs? Also, can someone point out the code used to select the isolation levels within a java program please. I remember reading a note on it sometime back. [...] 15798 117 36_How long can one stay in V8 CM mode?14_David S. Waugh16_dswaugh@LANL.GOV31_Thu, 31 Aug 2006 13:40:16 -0600323_US-ASCII Well, it looks like we're finally going to bite the bullet and migrate from DB2 for z/OS V7 to V8. Mostly because support for V7 will run out soon.

In the meeting yesterday, one of the managers asked this question:

"Can we just migrate to V8 Compatibility Mode and just stay there for 3 years?" [...] 15916 123 40_Re: How long can one stay in V8 CM mode?15_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Thu, 31 Aug 2006 15:52:11 -0400499_ISO-8859-1 Sorry- I haven't got good news for you ... the 12-month limit is the amount of time you have from the month in which you receive the V8 tape until IBM starts double-charging you (both the V7 and the V8 fees) if you still want V7 support. That's all, as far as I know. It may in fact be possible to stay in CM. Though IBM probably won't give as much weight to CM problem tickets as to NFM tickets, on the assumption that no one in their right mind would _want_ to stay in CM forever. [...] 16040 24 14_Re: IDMS - DB213_Dan Zychowski28_dan.zychowski@EDDIEBAUER.COM31_Thu, 31 Aug 2006 14:43:21 -0500419_- Just completed an IDMS to DB2 last month. We had about 100 apps to convert and 60 schemas. We didn't notice any degradation in the onlines. The batch was mixed. Some jobs that took 2 hours now takes 6, some no change and some that took a hour now run in 10 minutes. The poor preformers are being re- written. We used a vendor and was able to complete the project in 6 months. Had very few issues after cut over. [...] 16065 369 40_Re: How long can one stay in V8 CM mode?12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Thu, 31 Aug 2006 15:13:33 -0700495_us-ascii You should try to bring your IBM team in on the argument. As far as I know three years is the longest that any one has stayed on V8 CM because that is the length of time they have been waiting for their vendors. They are still there and still waiting. This is the only case I know of to wait this long. V9 should be out soon, again a reason to bring your IBM team into the fray. Once it is out V7's days are numbered, but using the figure of 18 months for the next release and one [...] 16435 318 53_Re: Copy After Catalog Reorg - Pre V8 Migration Steps18_Prather, Doug, ISD28_Dprather467@WORLDSAVINGS.COM31_Thu, 31 Aug 2006 16:35:31 -0500706_us-ascii Thanks David for the info,

After the Catalog and Directory Reorg, I just issued a repair on dsndb06.syscopy nocopypend then I was able to run DSNTIJIC just fine.





Doug Prather

IBM Certified Database Administrator DB2 Universal Database 8.1 for z/OS

Senior Database Administrator

World Savings and Loan (Golden West)

4101 Wiseman

San Antonio, TX 78251

210-543-6742





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David S. Waugh Sent: Wednesday, August 30, 2006 11:49 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Copy After Catalog Reorg - Pre V8 Migration Steps [...] 16754 58 58_Re: Deadlocks due to Java programs from Application server12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 31 Aug 2006 18:58:28 -0700631_iso-8859-1 Yes, in fact, the java programmers need to close their result sets and then their statements prior to their closing the connection. If not done, the locks will be held for almost forever.

Myron

--- "Agarwal, Amit" wrote:

> Hi, > What the best practices to reduce contention problems due to Java > programs to Z/OS (from weblogic). We are see a lot more timeouts than > before due to the Java programs. Do the programmers have to explicitly > close connections within their programs? Also, can someone point out > the code used to select the isolation levels [...]