1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2008, week 5 2 28 16_ALIAS or CONNECT13_Marcus Davage29_marcus.davage@LLOYDSTSB.CO.UK31_Tue, 29 Jul 2008 09:54:22 +0000362_utf-8 Hi,

We’ve a developer who wants to access DB2 z/OS data in another subsystem to the one he’s in. I suggested creating an ALIAS to the table and let DDF do the work, but it has been suggested to me that maybe CONNECT TO DB2X / CONNECT RESET would be a better option. Would this work within a CICS environment? Which is the preferred option? [...] 31 54 20_Re: ALIAS or CONNECT13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Tue, 29 Jul 2008 11:27:25 +0100396_utf-8 Hi Marcus,

One consideration might be the monitoring of processes that access remote databases. Anything that's monitoring SQL executing in the local subsystem is gonna have a hard time watching SQL statements run after CONNECTing to a remote location, simply because the process is no longer local. Given that's the case, if that's important to you I'd go for aliases instead. [...] 86 496 72_Re: Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...7_Ed Long19_rdhm99a@PRODIGY.NET31_Tue, 29 Jul 2008 07:31:16 -0700674_windows-1252 If you don't mind a short, quiet ride in the wilderness of Connecticut you can come to the New England DB2 User Group meetings in Sturbridge Mass. More to come. Edward Long ----- Original Message ---- From: "RENUSHARMA@AOL.COM" To: DB2-L@www.idugdb2-l.org Sent: Monday, July 28, 2008 4:52:10 PM Subject: Re: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept... Hello List Do we have a db2 user group for NY/NJ Can anyone send that info to me . Renu In a message dated 7/28/2008 3:40:24 P.M. Eastern Daylight Time, henry.nalven@MARRIOTT.COM writes: The Baltimore/Washington DB2 Users' Group Meeting Schedule for [...] 583 1046 72_Re: Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 29 Jul 2008 10:43:39 -0400382_us-ascii Visit our website at http://www.ubs.com

This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...] 1630 63 20_Re: ALIAS or CONNECT12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Tue, 29 Jul 2008 09:53:19 -0500342_UTF-8 Hi Marcus, I would recommend going with the DRDA method using CONNECT. ALIAS was created back when we used private protocol to communicate between DB2 subsystems. If you need more information just shoot me an email.

Cheers!

Troy Coleman, Support Engineer IBM Certified Database Administrator - DB2 9 for z/OS and LUW [...] 1694 530 72_Re: Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...11_Mark (work)21_mlabby@AESSUCCESS.ORG31_Tue, 29 Jul 2008 11:46:26 -0400 2225 1618 93_TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...)14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 29 Jul 2008 13:30:32 -0400382_us-ascii There used to be a group called "Tridex" for the NY/NJ area, but I haven't heard anything from them and their website (www.db2tridex.org ) points straight to the IDUG website. Any active TRIDEX people out there?





--Phil Sevetson, NYCAPS DBA Support

Financial Information Services Agency of The City of New York [...] 3844 1587 97_Re: TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...)10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 29 Jul 2008 14:06:03 -0400382_us-ascii Visit our website at http://www.ubs.com

This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...] 5432 571 97_Re: TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...)14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Tue, 29 Jul 2008 18:34:23 +0000656_utf-8 The Tridex website is http://tridexdb2.natemurphy.net/

I think they are independent ... that is they are not an IDUG users group.

On Tue, 29 Jul 2008 13:30:32 -0400, Sevetson, Phil wrote:

>There used to be a group called "Tridex" for the NY/NJ area, but I >haven't heard anything from them and their website (www.db2tridex.org > ) points straight to the IDUG website. Any >active TRIDEX people out there? > > > >--Phil Sevetson, NYCAPS DBA Support > >Financial Information Services Agency of The City of New York > >450 West 33rd Street, 4th Floor > >New York, NY 10001 > [...] 6004 938 97_Re: TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...)15_Degtyarev, Lucy24_ldegtyarev@DIVINVEST.COM31_Tue, 29 Jul 2008 13:58:08 -0500542_us-ascii TRIDEX is still active in NY. We meet on a quarterly basis.Send an e-mail to n-murphy@comcast.net to get more detailed information.

Lucy Degtyarev DB2 DBA, z/OS Diversified Investment Advisors Purchase NY

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Tuesday, July 29, 2008 1:31 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...) [...] 6943 524 97_Re: TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...)13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 29 Jul 2008 14:19:24 -0500672_windows-1252 I hope Tridex is still going strong.... I'm speaking there in November.

Willie

Sevetson, Phil wrote: > > There used to be a group called “Tridex” for the NY/NJ area, but I > haven’t heard anything from them and their website (www.db2tridex.org > ) points straight to the IDUG website. Any > active TRIDEX people out there? > > //--Phil Sevetson, NYCAPS DBA Support// > > //Financial Information Services Agency of The City of New York// > > //450 West 33rd Street////, 4th Floor// > > //New York////, NY 10001// > > //phone: (212) 857-1688// > > //mailto: psevetson@fisa.nyc.gov // [...] 7468 158 18_Job alert: DB2 DBA13_Nicole Singer33_nicole.singer@THREEPILLARCORP.COM31_Tue, 29 Jul 2008 12:22:11 -0700364_Windows-1252 START 01 Aug 2008 DURATION 28 Feb 2009 LOCATION Burns Harbor STATE INDIANA RATE : $35-40/hr ROLE DESC Local candidates ONLY

. Please indicate status and current location on top of resume. In person interviews. Must be able to attend face to face if requested. *Please do not submit candidates who are not currently local. Cannot relocate. [...] 7627 605 97_Re: TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...)10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 29 Jul 2008 15:27:53 -0400452_US-ASCII It is because of speakers like you that it is still going strong.

Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero Sent: Tuesday, July 29, 2008 3:19 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...) [...] 8233 197 24_Re: Command Editor Query14_Michael Kaplan25_micaelkp@NETVISION.NET.IL31_Tue, 29 Jul 2008 23:04:32 +0300343_us-ascii Brian,

Unfortunately, it did not help. I've run some SQL trace and saw that module SYSSH100 ( which is bound with UR and TXIsolation = 1 caused to use it) issued this:

SELECT * FROM for fetch only

Then, the only LOCK which existed for this table is SHARE MASS DELETE and this was not "DRAINED". [...] 8431 240 24_Re: Command Editor Query11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Tue, 29 Jul 2008 16:34:43 -0400400_US-ASCII Did you try PATCH2=6? With it and autocommit=1 and txnisolation=1, I have no remaining claims or locks following a SELECT * from ;.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Kaplan Sent: Tuesday, July 29, 2008 4:05 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Command Editor Query [...] 8672 593 10_Re: TRIDEX11_Harold, Ray15_RHarold@ETS.ORG31_Tue, 29 Jul 2008 17:08:56 -0400432_us-ascii http://tridexdb2.natemurphy.net/

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero Sent: Tuesday, July 29, 2008 3:19 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] TRIDEX (was RE: [DB2-L] Baltimore/Washington DB2 Users' Group - Meeting Schedule for Sept...)

I hope Tridex is still going strong.... I'm speaking there in November. [...] 9266 444 22_Re: Job alert: DB2 DBA19_MALIK, MUNWAR (CTR)31_munwar.malik@ASSOCIATES.DHS.GOV31_Tue, 29 Jul 2008 17:26:26 -0400566_us-ascii Rate sucks!!!!!!!!!!





M Malik

DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Nicole Singer Sent: Tuesday, July 29, 2008 3:22 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Job alert: DB2 DBA





START 01 Aug 2008 DURATION 28 Feb 2009 LOCATION Burns Harbor STATE INDIANA RATE : $35-40/hr ROLE DESC Local candidates ONLY





. Please indicate status and current location on top of resume. In person interviews. Must be able to attend face to face if requested. [...] 9711 480 22_Re: Job alert: DB2 DBA15_Joel Responsive26_joel@RESPONSIVESYSTEMS.COM31_Tue, 29 Jul 2008 22:39:14 -0400669_iso-8859-1 I can't speak for the job market in Indiana, but I pay more than that for visual basic programming. (no open requirements).

However, if one is unemployed, anything is better than nothing.

Regards, Joel

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 tel. (732) 972-1261 fax.(732) 972-9416 ----- Original Message ----- From: MALIK, MUNWAR (CTR) Newsgroups: bit.listserv.db2-l To: DB2-L@www.idugdb2-l.org Sent: Tuesday, July 29, 2008 5:26 PM Subject: Re: [DB2-L] Job alert: DB2 DBA [...] 10192 183 35_Ad: Buffer Pool Tool V9.4 available15_Joel Responsive26_joel@RESPONSIVESYSTEMS.COM31_Tue, 29 Jul 2008 22:55:21 -0400612_iso-8859-1 The industry standard Buffer Pool Tool has a new release, available to all licensed clients. Just send us an email requesting the code. If you can't receive attached files, we have a download available too.

In addition to the major enhancements provided with version 9.3, this enhances memory reporting, and allows a lower number of automatic pool simulations when running the Consolidated Reporting facility. The smaller number of concurrent simulations reduce the 64Bit memory requirement approximately 60% when simulating the performance of very large pools, exceeding 100,000 buffers. [...] 10376 263 39_Re: Ad: Buffer Pool Tool V9.4 available0_17_jtonchick@AOL.COM31_Wed, 30 Jul 2008 00:03:19 -0400664_us-ascii

What timing, Joel.? I just received the approval? today from the TransUnion change committee to implement V9.3 in production? It's going in tomorrow morning.





Jim







-----Original Message----- From: Joel Responsive To: DB2-L@www.idugdb2-l.org Sent: Tue, 29 Jul 2008 9:55 pm Subject: [DB2-L] Ad: Buffer Pool Tool V9.4 available



































The industry standard Buffer Pool Tool has a new release, available to all licensed clients. [...] 10640 46 12_SQL Question15_Michael Bednarz24_michael.bednarz@CITI.COM31_Wed, 30 Jul 2008 08:10:37 +0000453_utf-8 Hi all,

question for SQL - GURU

What the main diffrence between:

SELECT x FROM table C WHERE SUBSTR(C.CREATOR,1,3) = 'ABC' ;

and

SELECT x FROM table C WHERE C.CREATOR LIKE 'ABC%' ;

Is it only a performance issue?

In my case the result is the same.

Regards

Michael Bednarz Citicorp Operations Consulting GmbH Düsseldorfer Str. 71b 40667 Meerbusch mailto:michael.bednarz@citi.com [...] 10687 56 20_Re: ALIAS or CONNECT13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Wed, 30 Jul 2008 09:55:49 +0100355_utf-8 15-all. I forget who's serving...

As an aside, I don't think using aliases requires private protocol, although they're of similar vintage. You can alias down to off-host DRDA-compliant DBMSs (eg. DB2 LUW) which don't run private protocol, so one doesn't require the other - although I know you weren't suggesting they do. Did. Whatever. [...] 10744 95 16_Re: SQL Question14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 30 Jul 2008 10:38:28 +0100418_iso-8859-1 Hi Michael

Yes - two SQLs are requesting EXACTLY the same thing

"Are the first 3 characters of c.creator 'ABC'"??

There will be a big performance difference though

The LIKE predicate is just comparing the first 3 characters of each column occurrence to 'ABC'

The SUBSTR version will first extract the first three characters from the column and THEN do the comparison [...] 10840 54 29_LDAP authentication behaviour29_=?ISO-8859-9?Q?R=FDfat_Aras?=22_rifat.aras@TCMB.GOV.TR31_Wed, 30 Jul 2008 13:19:22 +0300603_ISO-8859-9 Esteemed List,

We have a DB2 LUW v9.5 installed on RedHat Enterprise Server (zLinux). We are performing the authentication with IBM's LDAP plugin.

We have a strange problem with authentication though (maybe strange behaviour of DB2). In control center, when I try to -lets say- see the list of tables on the database, I am asked for my domain user and password. After entering those info, the control center asks password for the DB2 Administration Server user id (I use the same username for DAS user id). Here I enter the password that I set in the operating system (not [...] 10895 29 20_Re: ALIAS or CONNECT13_Marcus Davage29_marcus.davage@LLOYDSTSB.CO.UK31_Wed, 30 Jul 2008 10:55:18 +0000404_utf-8 It depends...

There, I've said it! Do I get a prize?

Craig Mullins replied to a twitter of mine, "I believe private protocal will be de- supported in Vnext. Aliases will still work, but will have to use DRDA."

Does that mean that if we use ALIAS we would have to change our code to put CONNECTs in, or that they would automatically use DRDA under the covers from then on? [...] 10925 105 24_AW: [DB2-L] SQL Question16_Bednarz, Michael24_michael.bednarz@CITI.COM31_Wed, 30 Jul 2008 11:54:37 +0100504_iso-8859-1 Hi Phil,

Yes thx.

That helps!

Michael

-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Grainger, Phil Gesendet: Mittwoch, 30. Juli 2008 11:38 An: DB2-L@www.idugdb2-l.org Betreff: Re: [DB2-L] SQL Question

Hi Michael

Yes - two SQLs are requesting EXACTLY the same thing

"Are the first 3 characters of c.creator 'ABC'"??

There will be a big performance difference though [...] 11031 80 20_Re: ALIAS or CONNECT14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 30 Jul 2008 12:13:42 +0100483_us-ascii From the Command/Utility reference

DBPROTOCOL(DRDA/PRIVATE) Specifies which protocol to use when connecting to a remote site that is identified by a three-part name statement.

As an alias is really a "synonym" for a 3-part name I've always assumed that accessing an ALIAS with DBPROTOCOL(DRDA) will do exactly that

Phil Grainger CA Senior Principal Product Manager Phone: +44 (0)1753 577 733 Mobile: +44 (0)7970 125 752 eMail: phil.grainger@ca.com [...] 11112 24 16_Re: SQL Question12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Wed, 30 Jul 2008 11:32:41 +0000504_utf-8 Phil is correct - the SUBSTR version is not indexable and will result in a scan of the tablespace with the SUBSTR function being applied to all rows befor the comparison is made.

The LIKE can use an index and will out perform the SUBSTR.

Regards, Adam

______________________________________________________________________

* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________ [...] 11137 66 20_Re: ALIAS or CONNECT13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 30 Jul 2008 07:42:56 -0400395_us-ascii It seems to me that we're clouding the issue a bit here with the idea of ALIAS.

The real distintion should be between using 3-part names (whether hidden by an ALIAS or not) and CONNECT TO. Maybe I'm missing something.

You CAN have 3-part names and use DRDA.

So Marcus, to answer your question, NO you don't have to code CONNECT statements to use 3-part names. [...] 11204 80 16_Re: SQL Question12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Wed, 30 Jul 2008 07:46:48 -0500358_UTF-8 Check out the DB2 Administration Guide - Summary of predicate processing WHERE SUBSTR(xxxx) = 'ABC' is non-indexable and stage 2

WHERE col like 'ABC%' is indexable and stage 1

So the difference is option 2 will out perform option 1.

Troy Coleman, Support Engineer IBM Certified Database Administrator - DB2 9 for z/OS and LUW [...] 11285 387 44_Invitation to the next IDUG/CA DB2 9 webcast14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 30 Jul 2008 14:08:09 +0100571_iso-8859-1 Hi all

Just a quick plug for next weeks installment in the continuing IDUG/CA DB2 9 webcast series entitled Better Availability with DB2 9. The webcast is on Wednesday, August 6, 11 a.m. ET

DB2 9 for z/OS delivers many new features and options to enhance the availability of applications as well as minimize the impacts of planned and unplanned outages. Join this IDUG and CA co-sponsored event as Phil Grainger takes us through a look at online reorg improvements, uses of cloned tables, online REBUILD INDEX and new online schema options. [...] 11673 22 20_Re: ALIAS or CONNECT13_Marcus Davage29_marcus.davage@LLOYDSTSB.CO.UK31_Wed, 30 Jul 2008 13:12:45 +0000779_utf-8 Thanks, Dave. I'd hoped as much.

Thanks too, to all who contributed so quickly!

Marcus

______________________________________________________________________

* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click [...] 11696 92 20_Re: ALIAS or CONNECT12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Wed, 30 Jul 2008 08:14:29 -0500378_UTF-8 Hi Raymond, Yep you are correct. I was thinking about the ALIAS that is defined and resolved at the requester site. With DRDA the ALIAS has to be defined at the site where the package is executed.

Marcus, A good write up on this can be found in the DB2 8 - Application Programming and SQL Guide subject "Moving from DB2 private protocol access to DRDA access" [...] 11789 41 16_Re: SQL Question13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 30 Jul 2008 09:22:00 -0400495_us-ascii In other words, (perhaps words one of my sons would use)

They are almost exactly alike.... ... except one sucks eggs big time.

Dave



The 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. [...] 11831 230 16_Re: SQL Question10_Dave Nance16_dav1mo@YAHOO.COM31_Wed, 30 Jul 2008 06:30:30 -0700398_iso-8859-1 Basically, they are doing the same work. You have already gotten responses about the substr being a stage 2 predicate and such, though I am not so sure that is true any more. I'm not working on a V9 system just yet, but can't I create an index in V9 based on a substr of a column? That kind of makes me think that it would no longer be a stage 2 predicate and that it is indexable. [...] 12062 18 20_Re: ALIAS or CONNECT13_Marcus Davage29_marcus.davage@LLOYDSTSB.CO.UK31_Wed, 30 Jul 2008 13:56:42 +0000739_utf-8 Thanks again, Troy.

______________________________________________________________________

* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms 12081 208 20_Re: ALIAS or CONNECT15_Christopher Tee19_CHRISTEE@UK.IBM.COM31_Wed, 30 Jul 2008 15:23:14 +0100353_US-ASCII Marcus

Don't forget, with DRDA you will need to bind your package on both the local and remote systems. If you use an alias, DB2 needs to be able to resolve the name at the remote site as well.



Chris Tee DB2 Systems Programmer Database Team SSO IGA Technical Services Internal Tel: 250072 External Tel: 023 9256 0072 [...] 12290 25 32_zos DB2 JDBC SYSDBASE deadlocks.23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Wed, 30 Jul 2008 08:04:33 -0700793_us-ascii hi all, is there anything new on preventing SYSDBASE deadlocks of distributed JDBC threads with BINDs ? The only info I found was old (list-serve 2004) with no resolutions.

thanks, cliff:-)

______________________________________________________________________

* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If [...] 12316 106 52_Re: Antwort: Re: [DB2-L] DB2 9 on z/OS DBRM question12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 30 Jul 2008 15:21:20 +0000412_utf-8 For a practical size restriction on DBRMs and packages, I suggest that you check the Redpaper DB2 for z/OS: Considerations on Small and Large Packages http://www.redbooks.ibm.com/abstracts/redp4424.html

The limit was for the size of a DBRM entry, a representation of a single statement, rather than for the full DBRM. It was pretty small in the days before large statements and Unicode and V8. [...] 12423 119 20_Re: ALIAS or CONNECT12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Wed, 30 Jul 2008 11:08:50 -0500531_ISO-8859-1 You are correct Dave. The use of 3 part names and or hidden in a ALIAS is the same.

I would think the use of ALIAS over CONNECT would be how you want to architect your code to change location for processing. With ALIAS you can bind the package into a new collection with a new qualifier that would pick up the correct ALIAS. So to switch from LOCA to LOCB assuming I use a collection id of LOCA and LOCB then all I would have to do is issue SET CURRENT PACKAGESET = :WS-LOCATION where ws-location is LOCA or [...] 12543 404 20_Re: ALIAS or CONNECT12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 30 Jul 2008 11:28:35 -0500430_US-ASCII Troy, I am not a developer, but since we are supposed to advise them I was curious.... If you have a cursor CUR-A open (from DB2B) and then switch to DB2C, can you still fetch CUR-A ? Mark.





Troy Coleman Sent by: DB2 Data Base Discussion List 07/30/2008 11:10 AM Please respond to DB2 Database Discussion list at IDUG [...] 12948 110 67_DB2 V9.1 Performance Measurements and Reasons For Going to DB2 V9.19_Ford Wong14_fordie@SHAW.CA31_Wed, 30 Jul 2008 15:09:10 -0600603_windows-1252 Dear Listers, Our shop is considering moving to DB2 V9.1 and would like to know what performance improvements to expect and what the main reasons for going to DB2 V9.1 are. If possible, I would like to compile a list of the top five reasons for doing so Has anyone done any performance Benchmarks of V9.1 with V8.1 and is willing to share their findings. The Red Book “DB2 For Z/OS Performance Topics” states “General OLTP CPU utilization improvements of 1.4% were measured for non-data sharing environments”. It was my understanding that all the performance goodies for DB2 V8.1 were [...] 13059 652 16_Re: SQL Question13_David Simpson22_dsimpson@THEMISINC.COM31_Wed, 30 Jul 2008 18:05:00 -0400529_iso-8859-1 The SUBSTR will be stage 1 / indexable in DB2 9 only if you have created an index on that expression AND that index is chosen in the access path selection. Otherwise it is still a stage 2 operation and continues to suck eggs (according to Dave Seibert)... :-)





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dave Nance Sent: Wednesday, July 30, 2008 8:31 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] SQL Question [...] 13712 48 0_3_MSH16_mvsmsh@YAHOO.COM31_Wed, 30 Jul 2008 20:00:20 -0700578_us-ascii Hi Listers ,

How can I fix this ?





We're using TSM userexit for log archiving with 40 log files.



I found that as soon as TSM archive fail , DB2 haung up with message

"DB2 is waiting for log files to be archived" and "DB2 was unable to confirm logs were achived"



I thought that even if the first TSM archive fail , DB2 will switch to next log files and keep processing untill it reached the last log files , and I'll I got enough time to fix TSM proble ,because I still got 39 logs files available. [...] 13761 345 20_Re: ALIAS or CONNECT12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Wed, 30 Jul 2008 23:03:00 -0500 14107 162 16_RE :failarchpath3_MSH16_mvsmsh@YAHOO.COM31_Wed, 30 Jul 2008 21:08:16 -0700649_us-ascii Thanks Renee !

My failarchpath setting is blank , it explains why DB2 can not switch when it fails.

I'll try update failarchpath and will see how it works !



Regards









--- On Thu, 7/31/08, Renee Wilson wrote:

> From: Renee Wilson > Subject: Fw: [DB2-L] > To: mvsmsh@YAHOO.COM > Date: Thursday, July 31, 2008, 8:03 AM > Hi, > > What are the db cfg settings for failarchpath? You can use > this parameter > to write your archive logs to disk if the archive media in > unable. Next > time a log is successfully archived [...] 14270 22 16_UNLOAD Null tabs34_SUBSCRIBE DB2-L Tejas V Jadhav_IBM17_tejasvj@GMAIL.COM31_Thu, 31 Jul 2008 04:49:11 +0000766_utf-8 Hi Experts,

When i do UNLOAD using DSNTIAUL

Can i know how to replace the null seperator between the columns with TABS ?

______________________________________________________________________

* IDUG 08 Bangalore, India * 21-23 August 2008 * http://IDUG.ORG/lsIN * ______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic [...] 14293 50 20_Re: UNLOAD Null tabs14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Thu, 31 Jul 2008 12:59:28 +0000751_utf-8 Use the unload utility instead, it supports specification of various types of delimieters.

There are many other unload solutions out there.

Regards Avram Friedman

On Thu, 31 Jul 2008 04:49:11 +0000, SUBSCRIBE DB2-L Tejas V Jadhav_IBM wrote:

>Hi Experts, > >When i do UNLOAD using DSNTIAUL > >Can i know how to replace the null seperator between the columns with TABS ? > >_________________________________________________________________ _____ > >* IDUG 08 Bangalore, India * 21-23 August 2008 * http://IDUG.ORG/lsIN * >_________________________________________________________________ _____ > > >The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, [...] 14344 454 20_Re: ALIAS or CONNECT11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 31 Jul 2008 11:28:11 -0500701_iso-8859-1

We have dealt with similar situations by creating a CTT or DTT to pull all rows from the remote subsystem and then join it to the local table. Performs much better than the huge # of open/close operations that are otherwise needed.

Thanks, Suresh







Date: Wed, 30 Jul 2008 23:03:00 -0500From: troy.coleman@SOFTBASE.COMSubject: Re: [DB2-L] ALIAS or CONNECTTo: DB2-L@www.idugdb2-l.org Yes,You can join tables like this:CONNECT TO DB2A OPEN CURSOR DB2A_C1 FETCH DB2A_C1 Loop to join DB2A_C1 to DB2B_C1 CONNECT TO DB2B MOVE DB2A_C1 values into host variables for DB2B_C1 OPEN CURSOR DB2B_C1 FETCH DB2B_C1 until no more data CLOSE DB2B_C1 CONNECT [...] 14799 34 45_Ron Powell/IT/VANCPOWER is out of the office.10_Ron Powell18_Ron.Powell@DOM.COM31_Thu, 31 Jul 2008 14:03:51 -0400667_US-ASCII I will be out of the office starting 07/31/2008 and will not return until 08/01/2008.

I will respond to your message when I return. If you need immediate assistance please contact Nick Helmore or Rick Richardson.

CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you [...] 14834 88 51_recompiling a NEWFUN=NO cobol program as NEWFUN=YES15_Chris Hoelscher21_choelscher@HUMANA.COM31_Thu, 31 Jul 2008 14:26:57 -0400397_US-ASCII Good afternoon all

we are ready to move from V8 VM to NFM

we are planning to leave the developer COBOL precompiler at NEWFUN=NO while TEST is in NFM and PROD in in CM - changing it to NEWFUN=YES only when PROD goes to NFM

a question - will a program (that uses NO new functionality) compiled under NEWFUNC=NO compile identical when compiled under NEWFUNC=YES ?? [...] 14923 27 56_db2 v8 and visual studio 2008 web application grayed out13_Don Isenstadt21_disenstadt@PARKER.COM31_Thu, 31 Jul 2008 19:26:56 +0000 14951 76 55_Re: recompiling a NEWFUN=NO cobol program as NEWFUN=YES13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 31 Jul 2008 14:45:43 -0500543_ISO-8859-1 If you have no new function in your application, it doesn't matter what you set NEWFUN to..

Also remember, this only controls stuff that has to be compiled. If you allow dynamic SQL, new function can still run dynamically.

Willie

Chris Hoelscher wrote: > > Good afternoon all > > we are ready to move from V8 VM to NFM > > we are planning to leave the developer COBOL precompiler at NEWFUN=NO > while TEST is in NFM and PROD in in CM - changing it to NEWFUN=YES > only when PROD goes to NFM > > a question [...] 15028 89 71_Re: DB2 V9.1 Performance Measurements and Reasons For Going to DB2 V9.114_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Thu, 31 Jul 2008 20:01:44 +0000563_utf-8 Given the lack of replys to this posting I thought I would repeat the following story that contains a valuable lesson.

An apperently wealthy man instructs his driver to pull over to the side of the road where a woman is standing. He rolls down the window and the following conversation results Wealthy man: Will you sleep with me for a millon dollars? Woman: (after some thought) Sure Wealthy man: How about 5 dollars? Woman: What sort of woman do you think I am? Wealthy Man: We have allready established that, we are just discussing the rate! [...] 15118 432 20_Re: ALIAS or CONNECT12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Thu, 31 Jul 2008 15:14:30 -0500 15551 24 71_Re: DB2 V9.1 Performance Measurements and Reasons For Going to DB2 V9.111_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 31 Jul 2008 20:29:26 +0000763_- >Wealthy man: Will you sleep with me for a millon dollars?

George Bernard Shaw. Over 60 years ago.

- Too busy driving to stop for gas!

______________________________________________________________________

* IDUG 08 Bangalore, India * 21-23 August 2008 * http://IDUG.ORG/lsIN * ______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed [...]