1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2009, week 1
2 46 51_Re: uuaaa: [DB2-L] Loading Literals with IBM Load ?14_Alexander John28_jalexander@WOOLWORTHS.COM.AU30_Tue, 1 Sep 2009 06:21:49 +0000604_utf-8 Many thanks for all your replies, I really appreciate it..<br><br>We had to stick with IBM Load Resume-Yes, Shrlevel Change for this exercise, and by using 'FORMAT DELIMITED', (comma is the default delimiter) which I never new about until a colleague pointed it out to me!, we were able to load the default values for missing (Char & Timestamp) columns from the input. Basically a comma is needed as a place holder for missing columns, as well as separating existing columns. Load control statement are not required as shown below. LOAD RESUME YES LOG YES SHRLEVEL CHANGE INDDN SYSREC ENFORCE [...]
49 35 54_Re: DB2 DBA & DB2 System programmer or Java programmer14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Tue, 1 Sep 2009 20:04:25 +1000635_US-ASCII Might I suggest Thinking in Java - http://www.mindview.net/Books/TIJ/ - as a beginning text. Not only good, but free download. At least the 3rd edition is.<br><br>Some other free ebooks are at http://blog.taragana.com/index.php/archive/10-free-java-ebooks-for-you/<br><br>James Campbell<br><br>On 31 Aug 2009 at 16:38, Sevetson, Phil wrote:<br><br><snip> > > Third, if you go with Java, you need to buy at least two books; one, a Java for Beginners book of some kind, and the other, the O'Reilly reference book "JAVA in a Nutshell". Then spend a lot of time working on them in your free time to come up to speed for your [...]
85 118 54_Re: DB2 DBA & DB2 System programmer or Java programmer11_Nenad Vidak21_nenad.vidak@GMAIL.COM30_Tue, 1 Sep 2009 10:34:08 +0000414_utf-8 Hello,<br><br>I spent last 6 years working as DB2 z sysprog, and now, as almost all new applications in my shop are written in java (CICS, batch, web), I started to learn java and WEB technologies (JSP, javascript ...) . That helps me to understand our applications and developers better. So don't hesitate - go for java. Your DB2 knowledge won't vanish just like that. ...and one day , who knows ... ? [...]
204 158 51_AW: [DB2-L] Identity columns uniqueness Db2 z/os v835_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Tue, 1 Sep 2009 15:22:53 +0200606_iso-8859-1 Frank<br><br>Isn't there already a function, which does exactly what you want? It's the new Select from insert statement, which came with V8.<br><br>Mit freundlichen Grüßen Walter Janißen<br><br>ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40198 Düsseldorf mailto:walter.janissen@itergo.com<br><br>Vorsitzender des Aufsichtsrates: Jürgen Vetter Geschäftsführung: Dr. Bettina Anders (Vorsitzende), Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön. Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996 [...]
363 35 28_HP Unload 00C90084, 00C9008532_Kimmo M=?UTF-8?Q?=C3=B6rnesten?=27_kimmo.mornesten@SWEDBANK.SE30_Tue, 1 Sep 2009 13:56:04 +0000402_utf-8 Hello,<br><br>Running an HP unload abends with reason code 00C90084 or 00C90085.<br><br>The sql is a join with two tables. No sort is performed explicitly or implicitly. The larger table of the two is scanned with sequential prefetch and the small table has index access.<br><br>The message indicates that the workfile database is full. Do you know why the workfile database has to be used? [...]
399 95 40_AW: [DB2-L] HP Unload 00C90084, 00C9008512_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 1 Sep 2009 16:36:27 +0200754_iso-8859-1 Kimmo,<br><br>DB2 scans both tables in the order of the join columns.<br><br>If no efficient indexes on the join columns provide the order, DB2 might sort the outer table internally.........<br><br>HTH.<br><br>With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Development and Product Support (E3) Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- THINK GREEN - DON'T PRINT THIS EMAIL UNLESS YOU REALLY NEED TO ! [...]
495 84 54_Re: [ DB2 V8 and V9 z/OS ] Statement Cache and Its LOB7_Ed Long19_rdhm99a@PRODIGY.NET30_Tue, 1 Sep 2009 08:55:51 -0700437_iso-8859-1 Hi everyone. I'm researching an interesting phenomena and would appreciate your insights.<br><br>We have the statement cache function enabled and run the EXPLAIN STMTCACHE ALL once per shift.<br><br>Once a week I run a purge, reorg job that deletes all rows greater than 30 days old.<br><br>The DSN_STATEMENT_CACHE_TABLE uses a LOB column stored in the DSN8L81X table space. This table space is setup as a 32k page size. [...]
580 73 31_parameter markers and functions11_Chris Bowen22_chris.bowen@MACRO4.COM30_Tue, 1 Sep 2009 16:09:10 +0000382_UTF-8 This is a nonsense query that, for various reasons, I'm interested in explaining dynamically:<br><br>SELECT COALESCE ( SUM ( "STRING_1_POS" + "STRING_2_POS" ) , 9999 ) , COUNT ( * ) FROM TABLE ( SELECT LOCATE ( ? , "STMT" ) , LOCATE ( ? , "STMT" ) FROM SYSIBM . SYSPACKSTMT ) AS NESTTAB ( "STRING_1_POS" , "STRING_2_POS" ) WHERE "STRING_1_POS" > 0 AND "STRING_2_POS" > 0 [...]
654 88 35_Re: parameter markers and functions9_Mike Bell21_mbell11a1@VERIZON.NET30_Tue, 1 Sep 2009 11:26:15 -0500424_US-ASCII You are correct - EXPLAIN does not work when any parameter to a function is ?. What I have done is substitute an appropriate datatype literal for the host variable reference. For explain processing it doesn't seem to require correct length or anything just the correct datatype. It does get interesting when the function is in the WHERE clause. It is legal in SQL but explain seems to have even more problems. [...]
743 27 54_Re: [ DB2 V8 and V9 z/OS ] Statement Cache and Its LOB13_Jack Campbell23_jackrcampbell@YAHOO.COM30_Tue, 1 Sep 2009 16:57:58 +0000730_utf-8 Ed,<br><br>The last I read a REORG on a LOB would not reclaim space. The 99% freespace may be due to the fact you only get 1 row per page for LOB's<br><br>Regards<br><br>Jack<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- "I had my first experience with certifications (and passed)! I learned a lot about DB2 version 9 (LUW) that hopefully will enable me to convince management a timely migration will be of benefit for the business." _____________________________________________________________________
771 41 49_Inconsistent Database after adding 2 table spaces13_Robert Knight28_bknight@REMOTEDBAEXPERTS.COM30_Tue, 1 Sep 2009 13:02:21 -0400369_us-ascii I just added 2 table spaces to an existing database in production this morning. Each day a procedure executes to check the consistencies in the database. The report came back that there are inconsistencies existing in the database. I then executed the following:<br><br>REPAIR DBD DIAGNOSE DATABASE OEDB02<br><br>The report displayed the inconsistencies. [...]
813 153 35_Re: parameter markers and functions13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Tue, 1 Sep 2009 12:43:14 -0500499_us-ascii It's really just a question of knowing the datatype. This usually works ok if you CAST the parameter marker to a known datatype. For example (in this case using CHAR(1))...<br><br>SELECT COALESCE ( SUM ( "STRING_1_POS" + "STRING_2_POS" ) , 9999 ) , COUNT ( * ) FROM TABLE ( SELECT LOCATE ( CAST (? AS CHAR(1)), "STMT" ) , LOCATE ( CAST (? AS CHAR(1)) , "STMT" ) FROM SYSIBM . SYSPACKSTMT ) AS NESTTAB ( "STRING_1_POS" , "STRING_2_POS" ) WHERE "STRING_1_POS" > 0 AND "STRING_2_POS" > 0 [...]
967 40 54_Re: [ DB2 V8 and V9 z/OS ] Statement Cache and Its LOB7_Ed Long19_rdhm99a@PRODIGY.NET30_Tue, 1 Sep 2009 10:52:41 -0700564_iso-8859-1 My facts seem to fit both of your observations. I'm certainly going to reduce the page size. But, that seems to be only part of the story. I don't want to have to drop this database on a regular basis. Edward Long --- On Tue, 9/1/09, Jack Campbell <jackrcampbell@YAHOO.COM> wrote: > From: Jack Campbell <jackrcampbell@YAHOO.COM> > Subject: Re: [DB2-L] [ DB2 V8 and V9 z/OS ] Statement Cache and Its LOB > To: DB2-L@WWW.IDUGDB2-L.ORG > Date: Tuesday, September 1, 2009, 12:57 PM > Ed, > > The last I read a REORG on a LOB would not reclaim space. > [...]
1008 55 53_Re: Inconsistent Database after adding 2 table spaces16_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM30_Tue, 1 Sep 2009 12:56:12 -0500430_us-ascii It might just be the DBD in the EDMPOOL. Can you stop and restart the database to reload it?<br><br><br><br>Carol L. Broyles carol.l.broyles@acs-inc.com<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robert Knight Sent: Tuesday, September 01, 2009 1:02 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Inconsistent Database after adding 2 table spaces [...]
1064 37 53_Re: Inconsistent Database after adding 2 table spaces11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Tue, 1 Sep 2009 18:07:58 +0000520_utf-8 Hi Bob, What are the objects involved in the inconsistency. Is it the new tablespace or some other objects which are already existing. What kind of inconsistency you are getting ? Is it level id mismatch or something else ? Can you please send the complete error message and brief about the objects involved. Does the new tables have any refrential intigrity with any other tables ? Try running check data or DSN1COPY with CHECK option. But before this i need to know the objects involved and the error code. [...]
1102 50 54_Re: [ DB2 V8 and V9 z/OS ] Statement Cache and Its LOB11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Tue, 1 Sep 2009 18:28:55 +0000388_utf-8 Are you on DB2 virsion 8 or 9. If you are on 9 than you can reclaim the physical space with SHRLEVEL REFERENCE for the LOB tablespace.<br><br>You should calculate the pagesize base on the LOB size or average LOB size. Choosing a page size for LOBs (in the LOB table space) is a tradeoff between minimizing the number of getpages (maximizing performance) and not wasting space. [...]
1153 52 53_Re: Inconsistent Database after adding 2 table spaces10_Todd Burch17_toddburch@MAC.COM30_Tue, 1 Sep 2009 13:39:19 -0500558_US-ASCII If you report the inconsistencies (here or in a PMR), I'll tell you if they are reporting errors or real errors. We have a couple ptfs out that fix bogus reporting errors.<br><br>Todd DB2 z/OS Level 2<br><br><br><br><br><br>On Sep 1, 2009, at 12:02 PM, Robert Knight wrote:<br><br>I just added 2 table spaces to an existing database in production this morning. Each day a procedure executes to check the consistencies in the database. The report came back that there are inconsistencies existing in the database. I then executed the following: [...]
1206 181 55_Re: AW: [DB2-L] Identity columns uniqueness Db2 z/os v815_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Tue, 1 Sep 2009 14:26:47 -0600714_utf-8 I don't believe so. You are still returning the key of the parent table back to the application before using that key in the insert(s) to the child table.<br><br>On 9/1/2009 at 7:22 AM, in message <DB2-L%200909011323058687.00F3@WWW.IDUGDB2-L.ORG>, Walter Janißen <Walter.Janissen@ITERGO.COM> wrote: > Frank > > Isn't there already a function, which does exactly what you want? It's the > new Select from insert statement, which came with V8. > > Mit freundlichen Grüßen > Walter Janißen > > ITERGO Informationstechnologie GmbH > Anwendungsentwicklung > Laufzeitarchitektur > Victoriaplatz 2 > 40198 Düsseldorf > mailto:walter.janissen@itergo.com > > Vorsitzender des Aufsichtsrates: Jürgen Vetter [...]
1388 77 53_Re: Inconsistent Database after adding 2 table spaces13_Robert Knight28_bknight@REMOTEDBAEXPERTS.COM30_Tue, 1 Sep 2009 20:00:04 -0400426_us-ascii Thanks so far for everyone's input. I believe I have found the problem.<br><br>In searching thru the code for the table spaces I did a check on the Database and found to my surprise that the storage group defined to the DBD has been dropped. Apparently in a past conversion to change the storage group names to match the actual spindles the DBD's storage group was dropped. Unfortunately they are not using SMS. [...]
1466 220 63_AW: [DB2-L] AW: [DB2-L] Identity columns uniqueness Db2 z/os v835_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 2 Sep 2009 08:58:42 +0200578_iso-8859-1 o.k. you are right, but you get the value with one call to DB2. And I think, the CPU-overhead will be negligable.<br><br>Mit freundlichen Grüßen Walter Janißen<br><br>ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40198 Düsseldorf mailto:walter.janissen@itergo.com<br><br>Vorsitzender des Aufsichtsrates: Jürgen Vetter Geschäftsführung: Dr. Bettina Anders (Vorsitzende), Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön. Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996 [...]
1687 27 35_Re: parameter markers and functions11_Chris Bowen22_chris.bowen@MACRO4.COM30_Wed, 2 Sep 2009 07:54:09 +0000622_utf-8 Mike & Mike,<br><br>Interesting - thanks very much for your responses.<br><br>Should this be documented in one, or more, of the manuals?<br><br>Thanks again Chris<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- "The clear and high level technical information of some of the sessions makes the conference a value for the money." _____________________________________________________________________
1715 280 37_[Consulting Engagement] CSP and VAGen7_Kim May28_kim.may@THEFILLMOREGROUP.COM30_Wed, 2 Sep 2009 08:20:15 -0400533_us-ascii <br><br><br><br>I have a customer who needs assistance migrating CSP and VisualAge Generator applications from z/VM, DB2/VM 7.5 to EGL, DB2/VM 7.5.<br><br><br><br><br><br>The customer team has received training and is now looking for a consultant to work with them for two weeks to develop and implement a first application which will then be used as template for the rest. The customer is located outside the US - anyone interested needs to be passport-ready and prepared to work with the customer and an interpreter. [...]
1996 100 43_Re: Identity columns uniqueness Db2 z/os v811_Mike Bracey22_mike_bracey@UK.IBM.COM30_Wed, 2 Sep 2009 12:35:43 +0000634_UTF-8 Before V8 NFM, I used a stored procedure to get the equivalent function to sequences. The trick is to use SAVEPOINT and ROLLBACK to avoid the DELETE. The code looks something like this : CREATE PROCEDURE NEXTNO ( OUT NEXT_NO INTEGER , OUT SQLCPARM INTEGER ) EXTERNAL NAME 'NEXTNO' LANGUAGE SQL MODIFIES SQL DATA COLLID collid WLM ENVIRONMENT wlmenv ASUTIME NO LIMIT STAY RESIDENT YES RUN OPTIONS 'NOTEST(ALL,*,,VADTCPIP&9.20.78.60:*)' P1: BEGIN DECLARE SQLCODE INTEGER; DECLARE EXIT HANDLER FOR SQLEXCEPTION SET SQLCPARM = SQLCODE; SET SQLCPARM = 0 ; SET NEXT_NO = 0 ; SAVEPOINT SP1 ON ROLLBACK RETAIN CURSORS; INSERT INTO [...]
2097 64 26_DSNTIAD V8 and V9 Question0_22_DB2information@AOL.COM28_Wed, 2 Sep 2009 14:17:26 EDT399_US-ASCII Hello List, What manual must I review to see all options in DSNTIAD? -- does is not allowed as a comment, unless I am doing something incorrect. Is there a way to include a comment line in DSNTIAD control statements?<br><br><br><br>Ed.<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
2162 131 30_Re: DSNTIAD V8 and V9 Question13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Wed, 2 Sep 2009 14:14:30 -0500877_ISO-8859-1 Thy Appendix D in the Utility Guide.. I'm using the DB2 9 version.<br><br>You can also view the parameters on the web at for DB2 V8 - http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.apsg/rntiad.htm and DB2 9 http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.apsg/rntiad.htm<br><br>Willie<br><br>DB2information@AOL.COM wrote: > Hello List, > What manual must I review to see all options in DSNTIAD? > -- does is not allowed as a comment, unless I am doing something > incorrect. > Is there a way to include a comment line in DSNTIAD control statements? > > > Ed. > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------ > > IDUG - The Worldwide DB2 User Community! <http://www.idug.org> [...]
2294 61 30_Re: DSNTIAD V8 and V9 Question0_22_DB2information@AOL.COM28_Wed, 2 Sep 2009 16:00:53 EDT648_US-ASCII Willie, I can not seams to find if a comment statement is possible in DSNTIAD. A blank line is, but how about just a comment line -- in spufi. Also, can I run spufi in batch?<br><br>Ed.<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- "The clear and high level technical information of some of the sessions makes the conference a value for the money." _____________________________________________________________________
2356 41 30_Re: DSNTIAD V8 and V9 Question11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Wed, 2 Sep 2009 20:16:14 +0000539_utf-8 Ed, DSNTIAD does not accept comments embedde in SQL. DSNTIAD is written in assembler and can issue the same DB2 dynamic SQL statements as DSNTEP2, with the exception of the SELECT statement.<br><br>DSNTAID is written in Assembler language. Because DSNTIAD is a sample program, its source code could be modified to accept SELECT statements if you so desired. But my question is that why are you using DSNTIAD ? Are you using LABEL ON statement ? If you are not using LABEL ON statement you should use DSNTEP2/4(for multi fetch). [...]
2398 126 30_Re: DSNTIAD V8 and V9 Question12_Weaver, Rick19_Rick_Weaver@BMC.COM30_Wed, 2 Sep 2009 14:35:38 -0600515_us-ascii I always considered DSNTEP2 to be 'spufi in batch'. Craig seems to agree with that: http://www.sswug.org/articles/guestarticle.aspx?id=28053<br><br><br><br><br><br>Rick Weaver Product Manager DB2 z/OS Solutions BMC Software<br><br><br><br><br><br>________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DB2information@AOL.COM Sent: Wednesday, September 02, 2009 3:01 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DSNTIAD V8 and V9 Question [...]
2525 73 30_Re: DSNTIAD V8 and V9 Question0_22_DB2information@AOL.COM28_Wed, 2 Sep 2009 16:36:26 EDT441_US-ASCII <br><br>Mukesh, I am creating db2 objects like create database and tablespaces and tables, etc. Will I be able to create objects with dsntep2 or 4? Or what utility can I use in a batch job that will allow me to have comments and blanks lines?<br><br>Ed.<br><br><br><br><br><br><br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
2599 325 30_Re: DSNTIAD V8 and V9 Question13_David Simpson22_dsimpson@THEMISINC.COM30_Wed, 2 Sep 2009 16:43:20 -0400519_us-ascii DSNTEP2 and DSNTEP4 are also documented in Appendix D of the Utility Guide (difference is whether or not Muti Row Fetch is used). To my knowledge these can do everything that DSNTIAD can do with the additional benefit of being able to do a SELECT.<br><br><br><br><br><br><br><br>________________________________________________________________________ ______ David Simpson | Senior Technical Advisor | Themis Education 123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | dsimpson@themisinc.com [...]
2925 374 30_Re: DSNTIAD V8 and V9 Question13_David Simpson22_dsimpson@THEMISINC.COM30_Wed, 2 Sep 2009 16:44:34 -0400513_us-ascii Forgot to mention that DSNTEP2 / 4 can take comments with the --<br><br><br><br><br><br>From: David Simpson Sent: Wednesday, September 02, 2009 3:43 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: RE: [DB2-L] DSNTIAD V8 and V9 Question<br><br><br><br><br><br>DSNTEP2 and DSNTEP4 are also documented in Appendix D of the Utility Guide (difference is whether or not Muti Row Fetch is used). To my knowledge these can do everything that DSNTIAD can do with the additional benefit of being able to do a SELECT. [...]
3300 30 30_Re: DSNTIAD V8 and V9 Question11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Wed, 2 Sep 2009 21:09:58 +0000399_utf-8 Yes Ed, You can create the tables and do whatever DSNTIAD does except LABEL ON statement which i have not seen people using it. So you should use DSNTEP2 for this.<br><br>Thanks Mukesh Jain Senior DB2 DBA & System programmer (517) 9801064<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
3331 50 29_Prepared Dynamic SQL matching15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV30_Wed, 2 Sep 2009 21:31:22 +0000458_utf-8 I was reading Willie Favero's excellent series on DDF threads and in particular "The next episode in our KEEPDYNAMIC dialogue continues with Part 2…" (http://it.toolbox.com/blogs/db2zos/the-next-episode-in-our- keepdynamic-dialogue-continues-with-part-2-13160) when he makes a statement...<br><br><br><br>"Make sure you are using parameter markers to maximize the chances of getting a match against a (prepared) statement in the dynamic cache." [...]
3382 84 54_Re: [ DB2 V8 and V9 z/OS ] Statement Cache and Its LOB12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 2 Sep 2009 15:12:18 -0700331_us-ascii If you want to change the page size, you'll need to unload/load or something equivalent. What's the maximum length of a record.<br><br>And to reclaim space, reorg SHRLEVEL REFERENCE will reclaim old deleted space. But remember, it puts in free space if specified in define of tablespace just like regular reorg does. [...]
3467 74 33_Re: Prepared Dynamic SQL matching9_Mike Bell21_mbell11a1@VERIZON.NET30_Wed, 2 Sep 2009 18:47:14 -0500411_us-ascii Short answer - YES<br><br>The matching is done on a hash value of the entire text of the SQL statement. Many years ago there was an application that generated SQL with literals - after about a year of complaining, they regenerated with parameter markers. The DDF/DB2 cost of the application went down by over 90%. The reduction was so much it didn't even show up on the mamgement reports anymore. [...]
3542 235 76_IDUG North America 2010 - Call For Presentations - Deadline: September 25th!49_IDUG North American Conference Planning Committee23_vijay.sitaram@GMAIL.COM30_Thu, 3 Sep 2009 02:59:02 +0000509_utf-8 Dear List Serve Members,<br><br>The International DB2 Users Group (IDUG®) is accepting presentation abstracts for IDUG 2010 - North America, May 10-14 in Tampa, Florida. This is your opportunity to share your DB2 experience and expertise with an audience of your peers who rely on, or are considering incorporating DB2 in their shop. If your presentation abstract is selected to be delivered at the conference, you will receive one complimentary IDUG 2010 - North America conference registration. [...]
3778 24 39_I am out of office - visiting customer.17_Norbert Jenninger14_JEN@DE.IBM.COM30_Thu, 3 Sep 2009 08:12:01 +0200584_US-ASCII I will be out of the office starting 09/02/2009 and will not return until 09/04/2009.<br><br>I am out of office - travelling, I will be back in the office Friday Sept.4.<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
3803 373 33_Re: Prepared Dynamic SQL matching14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Thu, 3 Sep 2009 09:18:05 +0200847_us-ascii Hi,<br><br><br><br><br><br>I did some tests :<br><br><br><br><br><br>DB2 CPU usage (without appl CPU) in miliseconds for one sql<br><br><br><br><br><br>Db2 subsytem<br><br>Dynamic Statement-Caching is ON<br><br>DB2 CPU Without parameter Marker<br><br>With parameter Marker without CAST<br><br>With parameter Marker and CAST<br><br>D235<br><br>Y<br><br>487 ms<br><br>180 ms<br><br>- 63 %<br><br>166 ms<br><br>- 66 %<br><br>D215<br><br>Y<br><br>798 ms<br><br>262 ms<br><br>- 66 %<br><br>248 ms<br><br>- 69 %<br><br><br><br><br><br>greetings,<br><br><br><br><br><br>Patrick Steurs<br><br><br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Bell Sent: donderdag 3 september 2009 1:47 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Prepared Dynamic SQL matching [...]
4177 40 36_What's the best way to get into LUW?11_Steven Lamb23_stevenjlamb@HOTMAIL.COM30_Thu, 3 Sep 2009 11:42:39 +0000579_UTF-8 In the past I've always worked on mainframes, starting working with DB2 in 1993. Since then I've worked as a DBA/Systems Programmer but as of April this year I'm "looking for new opportunities". Unfortunately there aren't an awful lot of mainframe DBA jobs going at the moment.<br><br>However, there do seem to be some LUW vacancies. The next problem is that I have no experience at all on this side of things, either in DB2 or the operating systems. Can anybody suggest a suitable training path to cross-train into LUW? Is it possible to obtain copies of DB2 LUW for [...]
4218 164 70_Question about Moving from DB2 V8.2 LUW to DB2 V9.5 LUW and PeopleSoft12_John Lendman27_lendman@PALMBEACH.K12.FL.US30_Thu, 3 Sep 2009 07:33:52 -0400434_us-ascii Has anyone experience an upgrade to DB2 V8.2 LUW to DB2 V9.5 with PeopleSoft?<br><br><br><br><br><br>If so I would like to talk to you if possible, to try to find out the problems if any and what to look out for.<br><br><br><br><br><br>TIA<br><br><br><br><br><br>John C. Lendman<br><br>IBM Certified Solutions Expert<br><br>IBM Certified Database Administrator<br><br>IBM Certified Specialist<br><br>Office 561-357-7523 [...]
4383 39 30_Re: DSNTIAD V8 and V9 Question14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 3 Sep 2009 21:48:19 +1000500_US-ASCII One thing you can do with DSNTIAD, but shouldn't, is CREATE several VIEWs.<br><br>Have a look at the contents of SYSVIEWS.TEXT and you'll see why.<br><br>James Campbell<br><br><br><br>On 2 Sep 2009 at 21:09, Mukesh Jain wrote:<br><br>> Yes Ed, > You can create the tables and do whatever DSNTIAD does except > LABEL ON statement which i have not seen people using it. So you should > use DSNTEP2 for this. > > Thanks > Mukesh Jain > Senior DB2 DBA & System programmer > (517) 9801064 > [...]
4423 56 40_Re: What's the best way to get into LUW?18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Thu, 3 Sep 2009 09:15:18 -0400480_US-ASCII DB2 Express edition is free and supports all of the LUW platforms. I recommend you start here and then research topics such as instance settings, database settings, etc.<br><br>Browsing through the manuals is probably not a bad start. I think you will find many similarities in the DML/DDL commands but there are some significant differences as well. z/OS and LUW are 2 completely different databases. For example, a subsystem on z/OS equates to an instance on LUW. [...]
4480 69 40_Re: What's the best way to get into LUW?11_Mike Turner19_mike.turner@GMX.COM30_Thu, 3 Sep 2009 14:19:33 +0100705_UTF-8 Hi Steve<br><br>Here is a link to DB2 Express-C, which is free: http://www-01.ibm.com/software/data/db2/express/getstarted.html<br><br>Can't answer your other questions, but I am sure others will.<br><br>Regards Mike Turner Email: mike.turner@gmx.com Tel: +44 (0)1565-873702 Web: www.michael-turner.ltd.uk Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44. ----- Original Message ----- From: "Steven Lamb" <stevenjlamb@HOTMAIL.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@WWW.IDUGDB2-L.ORG> Sent: Thursday, September 03, 2009 12:42 PM Subject: [DB2-L] What's the best way to get into LUW? [...]
4550 43 40_Re: What's the best way to get into LUW?14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Thu, 3 Sep 2009 15:33:10 +0200578_UTF-8 Personnel Edition is free of charge.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Steven Lamb Sent: donderdag 3 september 2009 13:43 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] What's the best way to get into LUW?<br><br>In the past I've always worked on mainframes, starting working with DB2 in 1993. Since then I've worked as a DBA/Systems Programmer but as of April this year I'm "looking for new opportunities". Unfortunately there aren't an awful lot of mainframe DBA jobs going at the moment. [...]
4594 44 33_Re: Prepared Dynamic SQL matching11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Thu, 3 Sep 2009 13:25:14 +0000556_utf-8 Yes Tonmoy, If you are not using parameter marker than evrytime if there is change in the constant value it will be treated as different SQL. You should use the parameter marker to take the advantange of the dynamic SQL cache with keepdynamic YES.<br><br>I have seen over 90% improvement for the high volume SQLs when they were changed to use parameter market and host valiables. And even some times i i consider changing the static SQLs bind also to use with REOPT (ONCE) so that at least first time it will get the new access path and get the [...]
4639 209 40_Re: What's the best way to get into LUW?15_Leon Katsnelson15_leon@CA.IBM.COM30_Thu, 3 Sep 2009 09:55:40 -0400883_US-ASCII <br><br>The best thing to do is first go grab DB2 Express-C (http://www-01.ibm.com/software/data/db2/express/download.html?S_TACT=LKFREE000&S_CMP=ECDDWW01). It is free to use any which way you like but it really is excellent for learning. I also suggest that you get the free book (http://www.ibm.com/developerworks/wikis/display/DB2/FREE+Book-+Getting +Started+with+DB2+Express-C?S_TACT=LKFREE000&S_CMP=ECDDWW01) we have to go with the free DB2. And last but not least, get plugged in to the community i.e. Subscribe to FreeDB2.com blog (I had to put a plug for it), visit DB2 Express-C forum (http://www.ibm.com/developerworks/forums/forum.jspa?forumID=805), watch videos on ChannelDB2.com. Make sure to watch video lessons by Raul Chong http://www.channeldb2.com/video/video/listForContributor?screenName=319vjwzxxiyj7. With your DB2 for z/OS experience you will be [...]
4849 943 33_Re: Prepared Dynamic SQL matching15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV30_Thu, 3 Sep 2009 09:11:23 -0500341_us-ascii Mike, Mukesh and Patrick!<br><br>Thank you all for your very valuable inputs. Question for you Patrick...<br><br>Care to explain what you mean by the "CAST" ... in the table below. I see that you have got further improvements (though small) by using the CAST. Is it to match the datatypes in the predicate for a Stage 1 query? [...]
5793 30 35_Re: parameter markers and functions15_Patrick Bossman25_patrick.bossman@GMAIL.COM30_Thu, 3 Sep 2009 14:31:55 +0000734_UTF-8 Hello, It's documented in the SQL Reference, Prepare. Scroll down until you see the section on parameter markers. Untyped and typed parameter markers are both covered here. http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sql_prepare.htm<br><br>Best regards, Pat Bossman<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
5824 282 40_Re: What's the best way to get into LUW?15_Leon Katsnelson15_leon@CA.IBM.COM30_Thu, 3 Sep 2009 10:48:18 -0400665_US-ASCII <br><br>Actually, it is DB2 Express-C that is free, not DB2 Express. Get it here http://www.ibm.com/db2/express/download.html?S_TACT=LKFREE000&S_CMP=ECDDWW01. And as I said before, there is a free book to go with it and a series of 17 on-line lessons at http://www.channeldb2.com/group/db2oncampus<br><br>Leon Katsnelson Program Director, IBM Data Servers<br><br><br><br>FreeDB2<br><br><br><br><br><br><br><br><br><br><br><br>From: "Krawetzky, Peter J" <KrawetzkyPJ@AETNA.COM> To: DB2-L@WWW.IDUGDB2-L.ORG Date: 09/03/2009 10:01 AM. Subject: Re: [DB2-L] What's the best way to get into LUW? Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> [...]
6107 61 40_Re: What's the best way to get into LUW?2_DJ20_dj53tx-udb@YAHOO.COM30_Thu, 3 Sep 2009 10:46:42 -0400551_utf-8 On Thursday 03 September 2009 07:42:39 Steven Lamb wrote: > In the past I've always worked on mainframes, starting working with DB2 in > 1993. Since then I've worked as a DBA/Systems Programmer but as of April > this year I'm "looking for new opportunities". Unfortunately there aren't > an awful lot of mainframe DBA jobs going at the moment. > > However, there do seem to be some LUW vacancies. The next problem is that I > have no experience at all on this side of things, either in DB2 or the > operating systems. Can anybody suggest a [...]
6169 201 62_DB2 Optimization Service Center and Java Heap on Windows Vista14_Scott, Matthew18_MScott@ALFAINS.COM30_Thu, 3 Sep 2009 10:42:40 -0500555_us-ascii I am running DB2 Connect V9.5 fixpack 7 and DB2 Optimization Service Center 1.1 fixpack 6 on Windows Vista. I am connecting to DB2 V9 on z/OS. Since I changed my desktop OS to Vista, I have been randomly getting a "Failed to Fork OS Thread" error when running various tasks in DB2 OSC. I am able to open a command window and run a Java -Xmx command to instantiate an environment with enough memory/heap to avoid this error. The problem is that this command is temporary and I would like for it to be permanent. Changing the JAVA_HEAP_SZ DBM [...]
6371 41 35_Re: parameter markers and functions15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV30_Thu, 3 Sep 2009 11:11:31 -0500401_utf-8 Always something to learn! And this comes from the Application Dev Guide...<br><br>"Recommendation: Because DB2 can evaluate an SQL statement with typed parameter markers more efficiently than a statement with untyped parameter markers, use typed parameter markers whenever possible."<br><br><br><br>In the SQL Reference guide, for the function PREPARE the part under "Invocation" reads... [...]
6413 30 47_Problem with Query / Mainframe / DB2V7 vs DB2V815_Gaston, Raymond17_GastonRay@ORU.COM30_Thu, 3 Sep 2009 12:25:45 -0400420_utf-8 Dear List... Our mainframe TEST and USER subsystems are on DB2V8 NFM. However, our production is still on DB2V7. The query below works in TEST & USER but not in Production. The analyst gets the following error: "Sorry, a system error occurred. Your command may not have been executed" (then they ran to lunch before I could even ask how they were running this). Any clues? Help? Is this syntax invalid in V8? [...]
6444 67 51_Re: Problem with Query / Mainframe / DB2V7 vs DB2V814_Arnold, Mark S20_Mark.Arnold@BNSF.COM30_Thu, 3 Sep 2009 11:45:00 -0500409_us-ascii The error is clear - the last phrase should read "Let me buy you lunch first - then we can work on this at 1:10".<br><br>Good luck, Mark -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gaston, Raymond Sent: Thursday, September 03, 2009 11:26 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Problem with Query / Mainframe / DB2V7 vs DB2V8 [...]
6512 80 35_Re: parameter markers and functions11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Thu, 3 Sep 2009 17:07:31 +0000482_utf-8 Hi Tonmoy, You can use the prepare statment in JAVA but you can't use it the same way you use in COBOL or REXX. You need to use the JAVA functions to do that. con.prepareStatement("SQL string")<br><br>Below is one of the example:<br><br>The following code performs the previous steps to update the phone number to ’4657’ for the employee with employee number ’000010’. The numbers to the right of selected statements correspond to the previously-described steps. [...]
6593 48 51_Re: Problem with Query / Mainframe / DB2V7 vs DB2V813_David Simpson22_dsimpson@THEMISINC.COM30_Thu, 3 Sep 2009 13:08:03 -0400400_UTF-8 The SELECT inside the SELECT clause (called a scalar fullselect) was a new feature of DB2 Version 8. It will not be supported in V7.<br><br>You can test the query below... It should work in V7 and 8 and I believe it will return what you want. In any event, you should change the date predicate to do the math on the CURRENT DATE side. This makes it a stage 1 predicate instead of stage 2. [...]
6642 70 51_Re: Problem with Query / Mainframe / DB2V7 vs DB2V816_Lavoie, Frederic29_Frederic.Lavoie@CRA-ARC.GC.CA30_Thu, 3 Sep 2009 13:16:00 -0400420_iso-8859-1 Hello Ray,<br><br>I think Scalar-Fullselect is new in V8. Since you have V7 in production, the select statement will not work.<br><br>Frédéric Lavoie<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gaston, Raymond Sent: September 3, 2009 12:26 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Problem with Query / Mainframe / DB2V7 vs DB2V8 [...]
6713 195 35_Re: parameter markers and functions10_Mark Stone17_mastone@GMAIL.COM30_Thu, 3 Sep 2009 10:25:56 -0700549_windows-1252 Is there an equivalent way to use this in .NET ?<br><br>On Thu, Sep 3, 2009 at 10:07 AM, Mukesh Jain <jain.mukesh@aoins.com> wrote:<br><br>> Hi Tonmoy, > You can use the prepare statment in JAVA but you can't use > it the > same way you use in COBOL or REXX. You need to use the JAVA functions > to do that. > con.prepareStatement("SQL string") > > Below is one of the example: > > The following code performs the previous steps to update the phone number > to ’4657’ for the employee with employee number ’000010’. The numbers to [...]
6909 35 35_Re: parameter markers and functions11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Thu, 3 Sep 2009 17:43:47 +0000736_utf-8 For .NET you need to use Prepare function. For example:<br><br>conn = new DB2eConnection(connString);<br><br>conn.Open();<br><br>cmd = new DB2eCommand("UPDATE EMPLOYEE SET PHONENO=? WHERE EMPNO=?", conn);<br><br>// prepare the command cmd.Prepare();<br><br>Thanks Mukesh Jain Senior DB2 DBA & System programmer (517) 9801064<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- "This was definitely the best IDUG conference I have ever attended." _____________________________________________________________________
6945 86 51_Re: Problem with Query / Mainframe / DB2V7 vs DB2V814_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 3 Sep 2009 13:46:33 -0400454_us-ascii Jeez, is it Friday already and nobody told me? :-)<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Arnold, Mark S Sent: Thursday, September 03, 2009 12:45 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Problem with Query / Mainframe / DB2V7 vs DB2V8<br><br>The error is clear - the last phrase should read "Let me buy you lunch first - then we can work on this at 1:10". [...]
7032 91 51_Re: Problem with Query / Mainframe / DB2V7 vs DB2V815_Gaston, Raymond17_GastonRay@ORU.COM30_Thu, 3 Sep 2009 14:15:01 -0400504_iso-8859-1 Great!!! Thanks Lavoie !!! Now let me go collect that free lunch :-)<br><br>- Gaston<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lavoie, Frederic Sent: Thursday, September 03, 2009 1:16 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Problem with Query / Mainframe / DB2V7 vs DB2V8<br><br>Hello Ray,<br><br>I think Scalar-Fullselect is new in V8. Since you have V7 in production, the select statement will not work. [...]
7124 54 51_Re: Problem with Query / Mainframe / DB2V7 vs DB2V815_Gaston, Raymond17_GastonRay@ORU.COM30_Thu, 3 Sep 2009 14:26:21 -0400456_utf-8 Thanks David. I'll pass this on. / Ray<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson Sent: Thursday, September 03, 2009 1:08 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Problem with Query / Mainframe / DB2V7 vs DB2V8<br><br>The SELECT inside the SELECT clause (called a scalar fullselect) was a new feature of DB2 Version 8. It will not be supported in V7. [...]
7179 79 40_Call attachment facility (CAF) rationale25_jan.vanbrabant@telenet.be25_jan.vanbrabant@TELENET.BE30_Thu, 3 Sep 2009 19:43:59 +0000452_utf-8 Hi,<br><br>What's the rationale for he CAF (call attachment facility)?<br><br>SC18-9841-04 DB2 V9.1 for zOS Application Programming and SQL Guide(dsnapk14) at page 45: ''Use this facility as an alternative to the TSO attachment facility when your application needs tight control over the session environment.''<br><br>The next 25 pages dig a bit more in CAF's functionality & applicability, but WHY has it been invented? What is it's scope? [...]
7259 31 30_Re: DSNTIAD V8 and V9 Question14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Thu, 3 Sep 2009 20:11:05 +0000491_utf-8 Sorry, don't know what I was thinking at the time. Of course you can use DSNTIAD to create a view. It's DSNTIAUL that has problems.<br><br>James Campbell<br><br>On Thu, 3 Sep 2009 21:48:19 +1000, James Campbell <jacampbell@ACSLINK.NET.AU> wrote:<br><br>>One thing you can do with DSNTIAD, but shouldn't, is CREATE several VIEWs. ><br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
7291 120 44_Re: Call attachment facility (CAF) rationale11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Thu, 3 Sep 2009 20:48:22 +0000980_utf-8 Content-Type: text/html<br><br><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>idug.org Newsletter</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <meta http-equiv="Content-Language" content="EN" /> <style type="text/css"> * { margin: 0; padding: 0; } body { font-family: Arial, Helvetica, sans-serif; font-size: 11px; background: #45A3D6; } #container { position: relative; width: auto !important; width: 600px; max-width: 600px; margin: 0 auto; background-color: #FFFFFF; } #masthead { padding: 41px 0 0 23px; height: 150px; background: url(http://www.idug.org/images/sm2emailmarketing/mastheadBg.gif) no-repeat 0 80px; } #infoBar { position: absolute; top: 50px; right: 20px; text-align: right; } #infoBar p.subtitle { font-size: 14px; text-transform: uppercase; color: #3e6f1b; } #infoBar p.date { [...]
7412 77 30_Re: DSNTIAD V8 and V9 Question10_Roger Hecq18_Roger.Hecq@UBS.COM30_Thu, 3 Sep 2009 16:52:10 -0400518_US-ASCII Don't knock DSNTIAUL. It was a life saver for years. I know that it was written to unload data, but I have been amazed at what creative developers have managed and/or attempted to do with it.<br><br>Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of James Campbell Sent: Thursday, September 03, 2009 4:11 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DSNTIAD V8 and V9 Question [...]
7490 176 30_(SQL) Datacom migration to DB225_jan.vanbrabant@telenet.be25_jan.vanbrabant@TELENET.BE30_Thu, 3 Sep 2009 20:56:15 +0000422_utf-8 Hi,<br><br>Disclaimer: I’m rather a broadly scoped generalist than a DB2 specialist.<br><br>As with all migrations JCL for batch is the hard nut cracking! In the batch environment it’s the TSO attachment facility which invokes the DSN command processor. ... etc ... This means in >ALL< JCLs:'exec pgm=IKJEFT01' in stead of 'exec pgm=userpgm','exec pgm=anotherpgm', ‘exec pgm=stillanother’, … etc .... [...]
7667 87 44_Re: Call attachment facility (CAF) rationale9_Mike Bell21_mbell11a1@VERIZON.NET30_Thu, 3 Sep 2009 16:01:41 -0500396_US-ASCII Starting point - CAF was required for IMS to DB2 in batch. That is how it was implemented since - I guess forever.<br><br>using CAF you can do some very usefull things - connect to a specific DB2 subsystem or group. - connect using a plan name under program control - where the program can change which plan name it uses. - disconnect from one DB2 subsystem and connect to another. [...]
7755 147 30_Re: DSNTIAD V8 and V9 Question13_Horacio Villa17_hvilla@AR.IBM.COM30_Thu, 3 Sep 2009 18:21:41 -0300433_US-ASCII I used to do that (in another life) writing till col 72 and continuing in the next line.<br><br><br><br><br><br>From: James Campbell <jacampbell@ACSLINK.NET.AU> To: DB2-L@WWW.IDUGDB2-L.ORG Date: 03/09/2009 09:17 Subject: Re: [DB2-L] DSNTIAD V8 and V9 Question Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG><br><br><br><br><br><br>One thing you can do with DSNTIAD, but shouldn't, is CREATE several VIEWs. [...]
7903 113 44_Re: Call attachment facility (CAF) rationale10_Todd Burch17_toddburch@MAC.COM30_Thu, 3 Sep 2009 16:20:11 -0500627_US-ASCII Hi Jan.<br><br>CALL ATTACH was written for those NON-TSO, NON-CICS, NON-IMS applications that need to connect to DB2.<br><br>The CAF is very popular. It allows explicit control over your connection to DB2.<br><br>Todd<br><br><br><br>On Sep 3, 2009, at 2:43 PM, jan.vanbrabant@telenet.be wrote:<br><br>Hi,<br><br>What's the rationale for he CAF (call attachment facility)?<br><br>SC18-9841-04 DB2 V9.1 for zOS Application Programming and SQL Guide (dsnapk14) at page 45: ''Use this facility as an alternative to the TSO attachment facility when your application needs tight control over the session environment.'' [...]
8017 46 49_New England DB2 User's Group Tools Fair 9/17/20097_Ed Long19_rdhm99a@PRODIGY.NET30_Thu, 3 Sep 2009 15:29:07 -0700403_us-ascii Who says there is no such thing as a free lunch? Our next meeting is Thursday 9/17/09 and its free.<br><br>Plus we have Roger Miller, Steen Rasmussen (CA), Hussaina Husain (IBM), and Bill Arledge (BMC) speaking on Version 9 Performance Readiness.<br><br>Plus we have a number of fabulous prizes.<br><br>You do have to preregister though.To do so please send an email to NEDB2UG@GMAIL.COM. [...]
8064 50 62_Re: New England DB2 User's Group Tools Fair 9/17/2009: UPDATED7_Ed Long19_rdhm99a@PRODIGY.NET30_Thu, 3 Sep 2009 15:38:49 -0700631_us-ascii Sorry for the double post.<br><br>The event will be held at the Publick House in Sturbridge Mass. The facility is less than a mile from where I-84 meets the Massachusetts Turnpike.<br><br>We will start at 0900 and complete the day by 4:30.<br><br>Edward Long<br><br><br><br>--- On Thu, 9/3/09, Ed Long <rdhm99a@prodigy.net> wrote:<br><br>> From: Ed Long <rdhm99a@prodigy.net> > Subject: New England DB2 User's Group Tools Fair 9/17/2009 > To: "DB2 Database Discussion list at IDUG" <DB2-L@WWW.IDUGDB2-L.ORG> > Date: Thursday, September 3, 2009, 6:29 PM > Who > says there is no such thing as a free lunch? Our next > [...]
8115 49 35_Re: parameter markers and functions15_Kalena, Michael27_Michael.Kalena@JPMORGAN.COM30_Thu, 3 Sep 2009 19:27:49 -0400444_us-ascii Hi,<br><br>I have a stupid question on this as it's probably in the doc. Does case matter?<br><br>In other words would these 3 examples be considered equal:<br><br>SELECT COLA FROM TABLEA select cola from tablea select COLA from TABLEA<br><br>Or is it truly an exact byte by byte match?<br><br>Thanks.<br><br>Michael Kalena 973-793-2133 Michael.Kalena@jpmorgan.com<br><br>DB2 Info Page at hBSC (http://whsysops1.is.bear.com/db2/) [...]
8165 198 44_Re: Call attachment facility (CAF) rationale13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US30_Thu, 3 Sep 2009 17:32:07 -0700531_us-ascii We started using it way back because we had old programs that called a BDAM access routine. A lot of these programs let the system close files when they did a goback. We were getting bad return codes from the TSO interface. We created a new module to do DB2 instead of BDAM and we created a called routine to perform the CAF calls and schedule the plan based on the dsn of a temp dataset. No changes to the old code and minimal changes to the JCL. It works great and all programs are executed as PGM=XXXXXXXX with no [...]
8364 30 36_SQL Stored procedure problem on z/OS15_Alex, Aristotle21_db2_learner@YAHOO.COM30_Thu, 3 Sep 2009 23:10:04 -0700555_iso-8859-1 Dear members, DB2 V8.1 on z/OS. I am running into problem when try to run a sql Stored procedure. I have done the prep work to create the pre-compile, compile, link-edit & bind the sql stored procedure. I can see the stored procedure definition & the package however when I call the procedure I am getting -444 when called from Java. I do have authority over the defined wlm. I can do a display and see the stored procedure got started. Do I need to do anything specific for sql procedure? Any one had similar issue with sql procedure and [...]
8395 75 40_Re: SQL Stored procedure problem on z/OS15_Douwe van Sluis21_d.b.van.sluis@HOME.NL30_Fri, 4 Sep 2009 10:10:01 +0200493_iso-8859-1 Take a look at your STEPLIB concat in the WLM Application Environment Started Task JCL. Make sure that the LOADLIB where the program resides is in the list.<br><br>Vriendelijke groet, Douwe van Sluis<br><br><br><br><br><br><br><br>-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Alex, Aristotle Verzonden: vrijdag 4 september 2009 8:10 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: [DB2-L] SQL Stored procedure problem on z/OS [...]
8471 60 44_Re: Call attachment facility (CAF) rationale11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM30_Fri, 4 Sep 2009 08:11:48 +0000660_UTF-8 I recall that some DB2 tools were using CAF to connect to DB2. It was before the RRSAF era ....<br><br>Regards, Nenad<br><br>On Thu, 3 Sep 2009 19:43:59 +0000, jan.vanbrabant@telenet.be <jan.vanbrabant@TELENET.BE> wrote:<br><br>>Hi, > >What's the rationale for he CAF (call attachment facility)? > >SC18-9841-04 DB2 V9.1 for zOS Application Programming and SQL Guide(dsnapk14) >at page 45: >''Use this facility as an alternative to the TSO attachment facility when your >application needs tight control over the session environment.'' > >The next 25 pages dig a bit more in CAF's functionality & applicability, but WHY has it been invented? What is [...]
8532 54 39_[zOS] Level 1 Restricted State Checking12_Adam Baldwin22_adambaldwin@ES.IBM.COM30_Fri, 4 Sep 2009 08:55:18 +0000361_utf-8 I have a doubt re locking and Level 1 Restricted State checking. Than manuals state that an SQL program bound with ACQUIRE(USE) RELEASE(COMMIT) will check level 1 restricted states at the first reference and once per unit of recovery. In the case of program that is only performing reads would commits make a difference? Take the following scenario. [...]
8587 206 57_Antwort: [DB2-L] Call attachment facility (CAF) rationale11_Roy Boxwell16_R.Boxwell@SEG.DE30_Fri, 4 Sep 2009 11:59:14 +0200426_ISO-8859-1 personally I love the idea of standard PGM=xxxx without all the TSO messiness and inline control cards etc. PUS the fact that TSO is an unauthized environment is sometimes VERY annoying!!<br><br><br><br><br><br>Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...]
8794 30 44_Deb Van Epps/MutualOMA is out of the office.0_30_Deb.Van.Epps@MUTUALOFOMAHA.COM30_Fri, 4 Sep 2009 05:01:27 -0500656_us-ascii I will be out of the office starting 09/03/2009 and will not return until 09/08/2009.<br><br><br><br><br><br>If you need immediate assistance please contact my manager Kevin Stettler x3185.<br><br><br><br>This e-mail and any files transmitted with it are confidential and are solely for the use of the addressee. It may contain material that is legally privileged, proprietary or subject to copyright belonging to Mutual of Omaha Insurance Company and its affiliates, and it may be subject to protection under federal or state law. If you are not the intended recipient, you are notified that any use of this material is strictly prohibited. [...]
8825 40 34_Re: (SQL) Datacom migration to DB29_Tony Saul30_generalemaillists@YAHOO.COM.AU30_Fri, 4 Sep 2009 03:34:29 -0700292_utf-8 Hi Jan, I used to work on a Datacom to DB2 conversion tool (2BDB2.com) and we used to generate 3 modules. 1 for CICS, 1 for Batch using CAF and 1 to run under DSN (TSO) The modules were assembler so we had to issue an explicit connect. From the DB2 Application programming Guide - [...]
8866 46 15_DB2 DR Scenario9_Tony Saul30_generalemaillists@YAHOO.COM.AU30_Fri, 4 Sep 2009 03:52:54 -0700480_utf-8 Environment: DB2 V8 (NFM), no datasharing or sysplex. z/OS 1.7<br><br>I am at a new job and they are a merged company (2 small banks). 1 Bank has DB2 and native VSAM and the other has Datacom<br><br>For a DR scenario they break the dasd mirroring and go through recovery procedures. In 1 test the Datacom environment came up with no problems, but the DB2 environment had both BSDS datasets corrupted. Apparently DB2 was mid update at the time the mirroring was broken. [...]
8913 26 40_Re: What's the best way to get into LUW?11_Steven Lamb23_stevenjlamb@HOTMAIL.COM30_Fri, 4 Sep 2009 11:16:23 +0000735_UTF-8 Thanks for all the replies and suggestions - they've been very useful!<br><br>I've downloaded Express-C and I'm going to start playing with it to get a general idea I think before I start looking at training courses.<br><br>Steve<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- “The main reason for my attendance at IDUG - Europe was general training and rekindling enthusiasm. I took away more knowledge and enthusiasm – IDUG did the job!" _____________________________________________________________________
8940 101 34_Re: (SQL) Datacom migration to DB225_jan.vanbrabant@telenet.be25_jan.vanbrabant@TELENET.BE30_Fri, 4 Sep 2009 11:42:00 +0000630_utf-8 thanks Tony (Saul) ! DSNALI: that means that you worked via the CAF (Common Access Facility) language interface. At first glance (and - I admit - NOT being a DB2 specialist), I don't like CAF too much. Why? CAF does not provide attention processing exits or functional recovery routines. You can provide whatever attention handling and functional recovery your application needs, but you must use ESTAE/ESTAI type recovery routines and not Enabled Unlocked Task (EUT) FRR routines. DSN on the contrary: The DSN command processor can provide these services to a program that runs under it: ·Automatic connection to DB2 [...]
9042 24 19_Re: DB2 DR Scenario12_Adam Baldwin22_adambaldwin@ES.IBM.COM30_Fri, 4 Sep 2009 11:49:53 +0000664_utf-8 Tony - are you talking about physical corruption of the DR BSDS content or the fact that DB2 could not come using the DR BSDS and DR Logs?<br><br>Cheers, Adam<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- “The main reason for my attendance at IDUG - Europe was general training and rekindling enthusiasm. I took away more knowledge and enthusiasm – IDUG did the job!" _____________________________________________________________________
9067 135 39_Db2 Connect v9.5 - Missing ODBC driver?13_Hodgin, Scott19_shodgin@SCFBINS.COM30_Fri, 4 Sep 2009 06:59:16 -0500598_us-ascii We have an unlimited license for DB2 Connect Enterprise. I just installed DB2 Connect Enterprise v9.5 on a new 64 bit Windows 2003 server and applied fixpack 4. I have always used the import in the Configuration Assistant to import previously defined z/os data sources. When I run the import, I see the entries show up in Configuration Assistant and I can access them from Command Editor. However, I don't see any IBM drivers in Data Sources (ODBC) and my web applications that are designed to use plain ODBC connections are failing with a message indicating no valid license exists. [...]
9203 225 51_Antwort: Re: [DB2-L] (SQL) Datacom migration to DB211_Roy Boxwell16_R.Boxwell@SEG.DE30_Fri, 4 Sep 2009 14:02:17 +0200461_ISO-8859-1 I disagree there! DSN does none of that (from my memory...) you have to still code it all in progrsm or, even worse, hard code it in JCL! and the ATTN key stuff is just be humurous for friday I hope! Or do your users hit ESC all the time?!?!?!?! And If I had a dollar for every time a TSO program ended with RC = 00 but really should have ended 08 or above I would not be typing this while at work!!! Return code handling in DSN is horrible.... [...]
9429 57 40_Re: SQL Stored procedure problem on z/OS15_Alex, Aristotle21_db2_learner@YAHOO.COM30_Fri, 4 Sep 2009 05:15:16 -0700730_utf-8 ----- Original Message ---- From: Douw Thanks Douwe van Sluis! ----- Original Message ---- From: Douwe van Sluis <d.b.van.sluis@HOME.NL> To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, September 4, 2009 4:10:01 AM Subject: Re: [DB2-L] SQL Stored procedure problem on z/OS Take a look at your STEPLIB concat in the WLM Application Environment Started Task JCL. Make sure that the LOADLIB where the program resides is in the list. Vriendelijke groet, Douwe van Sluis -----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Alex, Aristotle Verzonden: vrijdag 4 september 2009 8:10 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: [DB2-L] SQL Stored procedure problem on z/OS Dear members, [...]
9487 29 19_Re: DB2 DR Scenario12_Adam Baldwin22_adambaldwin@ES.IBM.COM30_Fri, 4 Sep 2009 11:43:00 +0000338_utf-8 Tony, when you say "the DB2 environment had both BSDS datasets corrupted" do you mean that the content of the BSDS was corrupted or that DB2 wasn't able to come up using the DR BSDS?<br><br>I'm not sure if you're talking about physical corruption of the BSDS content or the fact that the DR BSDS copies did not match the logs. [...]
9517 76 34_Re: (SQL) Datacom migration to DB214_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Fri, 4 Sep 2009 14:57:15 +0200353_UTF-8 in my opinion, this is no problem, because: - you can easily establish a connection to DB2 through CAF - Attention Key Support does not matter in batch - for translation of DB2 error codes (SQLCODEs or SQLSTATEs) into messages, you can use DSNTIAR I'm not sure if there is support for this kind of translation from the DSN command processor. [...]
9594 150 19_Re: DB2 DR Scenario11_Mukesh Jain21_jain.mukesh@AOINS.COM30_Fri, 4 Sep 2009 13:11:32 +0000523_utf-8 Hi Tony, First of all i would say that it is common to have some inconsistency in BSDS and LOGs. It looks like you got some realistc scenario because i have seen that most of the places when they do the DR testing they take care extra precautions and thar break the mirroring when there are no updates or batch jobs are going on. But i am not in the favour of doing extra preparation for DR testing. Because when disaster happens it is not going to tell you that disaster is going to happen so make sure that no [...]
9745 351 34_Re: (SQL) Datacom migration to DB210_Roger Hecq18_Roger.Hecq@UBS.COM30_Fri, 4 Sep 2009 09:17:16 -0400382_us-ascii Visit our website at http://www.ubs.com<br><br>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. [...]
10097 92 55_Re: Antwort: Re: [DB2-L] (SQL) Datacom migration to DB225_jan.vanbrabant@telenet.be25_jan.vanbrabant@TELENET.BE30_Fri, 4 Sep 2009 13:36:16 +0000561_iso-8859-1 Hi Roy,<br><br>Not being a DB2 specialist I was just quoting from the manual: page 963 & 964 SC18-9841-04 DB2 V9.1 for zOS Application Programming and SQL Guide (dsnapk14)<br><br>So, you look to me as being a (firm) believer in CAF?! ;-)<br><br>thanks for your reaction. jan<br><br><br><br>I disagree there! DSN does none of that (from my memory...) you have to still code it all in progrsm or, even worse, hard code it in JCL! and the ATTN key stuff is just be humurous for friday I hope! Or do your users hit ESC all the time?!?!?!?! And If I [...]
10190 104 34_Re: (SQL) Datacom migration to DB225_jan.vanbrabant@telenet.be25_jan.vanbrabant@TELENET.BE30_Fri, 4 Sep 2009 13:41:44 +0000576_utf-8 Hi Bernd, thanks! Very valuable post. CAF starts to look better and better. :-) take care, Jan > >in my opinion, this is no problem, because: >- you can easily establish a connection to DB2 through CAF >- Attention Key Support does not matter in batch >- for translation of DB2 error codes (SQLCODEs or SQLSTATEs) into >messages, you can use DSNTIAR >I'm not sure if there is support for this kind of translation from the >DSN command processor. > >At our shop, we did the following: > >we replaced DSNHLI (which is DSNALI or DSNELI, depending on the >environment, [...]
10295 26 43_Re: Db2 Connect v9.5 - Missing ODBC driver?16_Vial R. (Robert)25_robert.vial@NL.FORTIS.COM30_Fri, 4 Sep 2009 13:58:47 +0000647_utf-8 Scott,<br><br>With 9.5 the license files are shipped separately. Have a look at technotes swg21305512 and swg21305417.<br><br>Regards, Robert<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- “The main reason for my attendance at IDUG - Europe was general training and rekindling enthusiasm. I took away more knowledge and enthusiasm – IDUG did the job!" _____________________________________________________________________
10322 55 28_db2 catalog admin tcpip node11_Dave Mullin28_David.Mullin@JOHNLEWIS.CO.UK30_Fri, 4 Sep 2009 14:59:35 +0000519_utf-8 Hi, I have used db2 catalog tcpip node several times but have never used the admin option (db2 catalog admin tcpip node.....). I came across it when looking at the HADR Redbook. I understand this relates to the DAS. Question is I have been able to administer my AIX databases from Control Centre (in situations where it is easier to use the GUI than unix cmd line) for some time now. What would cataloging the das in this way give me? What can't I do now that I will be able to if I perform this extra step? [...]
10378 296 30_Re: DSNTIAD V8 and V9 Question13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Fri, 4 Sep 2009 12:00:34 -0400264_utf-8 I have often asked why the heck people use DSNTIAD and the only answer I've gotten (other than - that's what Suzie Q uses) is that DSNTEP2 is written in PL/I and you used to need the PL/I product to use it. I believe with CEE that's no longer an issue. [...]
10675 139 61_Re: Antwort: [DB2-L] Call attachment facility (CAF) rationale15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Fri, 4 Sep 2009 10:22:38 -0600643_utf-8 Coming from VSE where there is no TSO it always confuses me that TSO seems to be kind of the "default" environment for DB2 applications. CAF seems, to me, to be the obvious option for a straight batch program. Frank<br><br>On 9/4/2009 at 3:59 AM, in message <OF6DEAD1AE.60C40D7F-ONC1257627.0036C94B-C1257627.0036DCB6@seg.de>, Roy Boxwell <R.Boxwell@SEG.DE> wrote: > personally I love the idea of standard PGM=xxxx without all the TSO > messiness and inline control cards etc. PUS the fact that TSO is an > unauthized environment is sometimes VERY annoying!! > > > > Roy Boxwell > SOFTWARE ENGINEERING GMBH > -Product Development- > [...]
10815 94 30_Re: DSNTIAD V8 and V9 Question14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Fri, 4 Sep 2009 18:23:53 +0200544_UTF-8 I think so, too. The LE runtime is part of the OS, and DSNTEP2 is distributed with DB2 as a load module, AFAIK. And the DSNTEP2 plan is bound during the DB2 installation process, or, if not, you can easily do it yourself.<br><br>Regards, Bernd<br><br><br><br>Seibert, Dave schrieb: > > I have often asked why the heck people use DSNTIAD and the only answer > I’ve gotten (other than – that’s what Suzie Q uses) is that DSNTEP2 > is written in PL/I and you used to need the PL/I product to use it. > I believe with CEE that’s [...]
10910 134 34_Re: (SQL) Datacom migration to DB215_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Fri, 4 Sep 2009 10:26:21 -0600596_utf-8 This sounds great! Does it support the CICS environment as well? Any chance I could get a copy of this?<br><br>On 9/4/2009 at 6:57 AM, in message <4AA10EAB.3070303@t-online.de>, Bernd Oppolzer <bernd.oppolzer@T-ONLINE.DE> wrote: > in my opinion, this is no problem, because: > - you can easily establish a connection to DB2 through CAF > - Attention Key Support does not matter in batch > - for translation of DB2 error codes (SQLCODEs or SQLSTATEs) into > messages, you can use DSNTIAR > I'm not sure if there is support for this kind of translation from the > DSN command processor. [...]
11045 39 44_Re: Call attachment facility (CAF) rationale13_Jack Campbell23_jackrcampbell@YAHOO.COM30_Fri, 4 Sep 2009 17:06:08 +0000303_utf-8 At my last client we used all CAF and no TSO attachments - std. z/os and DB2 set-up.<br><br>The rationale was that CAF could be customized, and consumed less CPU to peform the same functionality. I didn't set up the CAF environment so it is difficult to know how true the "savings" are...... [...]
11085 34 32_Re: db2 catalog admin tcpip node13_Jack Campbell23_jackrcampbell@YAHOO.COM30_Fri, 4 Sep 2009 17:09:34 +0000339_utf-8 David,<br><br>I would not claim vast experience on DB2 LUW - but from what I understand the DAS is required if you intend to have luw connect to Zseries (mainframe) or Iseries (as/400)......or if you intend to have control center schedule DB activities<br><br>*Others more proficient in LUW arena may be able to further clarify [...]
11120 266 61_Re: Antwort: [DB2-L] Call attachment facility (CAF) rationale25_jan.vanbrabant@telenet.be25_jan.vanbrabant@TELENET.BE30_Fri, 4 Sep 2009 17:19:21 +0000666_utf-8 Hi Frank. I'm also an ooooooooooooooold DOS/VSer. So yes, I fully second your remark about running DB2 under TSO(batch) ... ;-) jan<br><br><br><br>>----- Oorspronkelijk bericht ----- >Van : Frank Swarbrick [mailto:frank.swarbrick@EFIRSTBANK.COM] >Verzonden : vrijdag , september 4, 2009 06:22 PM >Aan : DB2-L@WWW.IDUGDB2-L.ORG >Onderwerp : Re: [DB2-L] Antwort: [DB2-L] Call attachment facility (CAF) rationale > >Coming from VSE where there is no TSO it always confuses me that TSO >seems to be kind of the "default" environment for DB2 applications. CAF >seems, to me, to be the obvious option for a straight batch program. >Frank > >On 9/4/2009 at 3:59 [...]
11387 65 34_Re: (SQL) Datacom migration to DB214_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Fri, 4 Sep 2009 19:30:13 +0200558_UTF-8 Unfortunately, the answer must be no, because I did the work for a customer of mine and I am not allowed to publish it here. But you can do it by yourself; there are only some minor tricks: you have to write a little ASSEMBLER load module with an arbitrary name with DSNHLI as ENTRY. This module should check on first call (by static switch), in which environment it is running (TSO, CICS, default should be normal BATCH). The result of this check should also be saved in a static flag. Then, depending on this flag, the appropriate IBM interface [...]
11453 52 32_Re: db2 catalog admin tcpip node14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Fri, 4 Sep 2009 19:45:53 +0200308_UTF-8 I'm not sure what DAS means, but I recently was quite impressed when I discovered that it was possible without problems to establish a database connection from a Version 9.5 DB2 Express-C on Windows (free download) to a DB2 Version 8 on z/OS (but with a DB2 Connect Gateway in the middle, AFAIK). [...]
11506 32 39_DB2 Community Supported by IBM Tool Bar19_McBride, Michael C.31_michael.mcbride@DOT.STATE.FL.US30_Fri, 4 Sep 2009 18:49:06 +0000324_utf-8 A great resource for the DB2 User Community is the IBM Software Support Tool Bar!<br><br>It centralizes the most accessed support pages for all your IBM Software and allows for you to quickly search your choice of content across all ibm.com servers. It is a pretty good way to drill down to specific IBM content! [...]
11539 99 30_Re: DSNTIAD V8 and V9 Question9_Mike Bell21_mbell11a1@VERIZON.NET30_Fri, 4 Sep 2009 13:58:45 -0500285_us-ascii Well, the origional reason was that IBM supplied DSNTEP2 in pl/1 source so you had to have the compiler to build it.<br><br>That changed a long time ago (V6 or V7? I don't remember) when SDSNSAMP had an OBJ module and the install clist build a job to LKED and BIND TEP2. [...]
11639 172 43_Re: DB2 Community Supported by IBM Tool Bar14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 4 Sep 2009 15:36:21 -0400677_utf-8 Michael,<br><br><br><br><br><br>I think you actually need to be sending people to this page instead:<br><br>http://www-01.ibm.com/support/docview.wss?rs=960&context=SSALJ7&dc=D600&uid=wws1d64add70b25c8d78852571af006780bd&loc=en_US&cs=UTF-8&lang=en<br><br><br><br><br><br>or for those whose browsers don’t like long URLs, http://tinyurl.com/IBMToolbar<br><br><br><br><br><br>--Phil Sevetson<br><br><br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of McBride, Michael C. Sent: Friday, September 04, 2009 2:49 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Community Supported by IBM Tool Bar [...]
11812 100 30_Re: DSNTIAD V8 and V9 Question13_David S Waugh16_dsw-dba@JUNO.COM28_Fri, 4 Sep 2009 19:40:24 GMT419_windows-1252 Ed:<br><br>Note that there's a "Batch SPUFI" shareware program called DARWIN available. It works much like DSNTEP2 (including handling SELECT statements and allowing -- comment lines), but it's written in COBOL instead of PL/1. Handy if you have a COBOL compiler but not a PL/1 compiler. And it has a few features that DSNTEP2, DSNTEP4 and DSNTIAD don't have. You can get the source code for it here: [...]
11913 107 28_Cobol host variable question15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Fri, 4 Sep 2009 15:27:25 -0600433_us-ascii I'm thinking I just must be blind, but can anyone see why I'm getting this error?<br><br>IGYPS2221-E Host variable "IPN-USERNAMES" was not declared within a "SQL DECLARE" section. The host variable definition was accepted.<br><br><br><br>identification division. program-id. skel. data division. working-storage section. exec sql begin declare section end-exec<br><br>01 sqlcode pic s9(9) comp-5. 01 sqlstate pic x(5). [...]
12021 99 27_host variable issue again?!15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Fri, 4 Sep 2009 15:58:19 -0600324_us-ascii I don't know if this is the same or a different issue as the last one, but can anyone explain it? If I use DB-NAME as the host variable I get an error, but if I use DBNAME I do not. See the output below:<br><br>IGYOS4077-I DSNH4760I DSNHPSRV The DB2 SQL Coprocessor is using the level 2 interface under DB2 V9 [...]
12121 106 31_Re: host variable issue again?!14_Lyon, Lockwood20_Lockwood.Lyon@53.COM30_Sat, 5 Sep 2009 09:48:48 -0400410_us-ascii Frank,<br><br>Call me crazy, but ... my some weird chance is this because your "end-exec" doesn't end with a period?<br><br>Lock Lyon Fifth Third Bancorp<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Frank Swarbrick Sent: Friday, September 04, 2009 5:58 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] host variable issue again?! [...]
12228 147 31_Re: host variable issue again?!15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Sat, 5 Sep 2009 08:46:49 -0600425_us-ascii Someone has kindly pointed out (didn't mention what an idiot I was) that I forgot the leading colon: connect to :db-name<br><br>Oops! (Hanging head in shame.)<br><br>He also suggested that for my other issue (IPN-USERNAMES not being a host variable even though it is defined) might be fixed by making it an 01-level instead of 05. This does not appear to be the case, as I get the same error after changing it. [...]
12376 185 32_Re: Cobol host variable question15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Sat, 5 Sep 2009 08:52:12 -0600448_us-ascii I'm pretty sure this is an IBM bug that is appearing because of: 1) My use of STDSQL(YES) instead of STDSQL(NO) (thus requiring the declare section stuff) 2) My use of the integrated precompiler.<br><br>It looks like it's simply not recognising more than the first few host variables. If I move things around in working storage I can get it to work, but it then no longer recognises the later host variables. Time for a PMR, I think. [...]
12562 87 43_Re: [zOS] Level 1 Restricted State Checking11_Mike Turner19_mike.turner@GMX.COM30_Sat, 5 Sep 2009 16:08:00 +0100424_utf-8 Hi Adam<br><br>My guess (and it is a guess) is that Level 1 Restricted State checking will be done and that, when the TS lock is re-acquired after the Commit, it will be an IS lock. I am still trying to think of a way to test this without writing a program! My notes do not mention that state checking is restricted to updaters and it makes sense to me that it should be performed by readers as well as updaters. [...]
12650 175 32_Re: Cobol host variable question10_Todd Burch17_toddburch@MAC.COM30_Sat, 5 Sep 2009 12:32:53 -0500435_ISO-8859-1 Frank, try twopass and see what happens.<br><br>I'd plug it in and try it for you, buy my recreate system is down right now.<br><br>Todd DB2 Level 2.<br><br><br><br>On Sep 5, 2009, at 9:52 AM, Frank Swarbrick wrote:<br><br>I'm pretty sure this is an IBM bug that is appearing because of: 1) My use of STDSQL(YES) instead of STDSQL(NO) (thus requiring the declare section stuff) 2) My use of the integrated precompiler. [...]
12826 183 32_Re: Cobol host variable question12_Roger Miller19_millerrl@US.IBM.COM30_Sat, 5 Sep 2009 23:34:45 +0000341_utf-8 It has been a very long time, but I suspect that we are looking for the periods in the data division. With the coprocessor, some of the rules are interpreted more strictly.<br><br>Roger Miller, DB2 for z/OS former precompiler person, a long time ago<br><br>On Sat, 5 Sep 2009 12:32:53 -0500, Todd Burch <toddburch@MAC.COM> wrote: [...]
13010 212 32_Re: Cobol host variable question15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Sat, 5 Sep 2009 19:47:50 -0600646_us-ascii Thanks for the idea. Adding periods after all end-execs does not fix the issue.<br><br>The issue does not occur (periods or not) when using the separate precompiler.<br><br>Definitely PMR time.<br><br>Thanks, Frank<br><br><br><br>On 9/5/2009 at 5:34 PM, in message <LISTSERV%200909052334457138.037F@WWW.IDUGDB2-L.ORG>, Roger Miller <millerrl@US.IBM.COM> wrote: > It has been a very long time, but I suspect that we are looking for the > periods > in the data division. With the coprocessor, some of the rules are > interpreted > more strictly. > > Roger Miller, DB2 for z/OS former precompiler person, a long time ago > > On Sat, 5 [...]
13223 54 19_Re: DB2 DR Scenario14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Sun, 6 Sep 2009 20:04:25 +1000342_US-ASCII Last year someone else told me about a corruption in the BSDS during a DR exercise.<br><br>Apparently because of the way that the BSDSs are updated after a log archive (shuffling archive log entries along in slots), if you time it correctly (or is that "incorrectly") the BSDS can contain duplicate entries for an archived log. [...]
13278 66 44_Re: Call attachment facility (CAF) rationale14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Sun, 6 Sep 2009 20:04:25 +1000387_US-ASCII Several clients ago I wrote a simple front end for CAF. The JCL used to execute it looked like<br><br>// EXEC PGM=userprog,PARM='<le-parms>/<ssid>,<plan>/<program-parms>'<br><br>The front-end itself just took the first two parms, called DSNALI to connect to DB2 and open the plan, then called the application program, passing the remaining parms. Plus some error handling. [...]
13345 226 32_Re: Cobol host variable question10_Todd Burch17_toddburch@MAC.COM30_Sun, 6 Sep 2009 08:22:32 -0500671_US-ASCII Open it for COBOL!! :)<br><br>Todd DB2 Level 2.<br><br><br><br>On Sep 5, 2009, at 8:47 PM, Frank Swarbrick wrote:<br><br>Thanks for the idea. Adding periods after all end-execs does not fix the issue.<br><br>The issue does not occur (periods or not) when using the separate precompiler.<br><br>Definitely PMR time.<br><br>Thanks, Frank<br><br><br><br>On 9/5/2009 at 5:34 PM, in message <LISTSERV%200909052334457138.037F@WWW.IDUGDB2-L.ORG>, Roger Miller <millerrl@US.IBM.COM> wrote: > It has been a very long time, but I suspect that we are looking for > the > periods > in the data division. With the coprocessor, some of the rules are > interpreted > more [...]
13572 229 32_Re: Cobol host variable question15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Sun, 6 Sep 2009 10:36:06 -0600551_us-ascii Seriously? I wasn't sure, so if you are serious then that is what I will do. Frank<br><br>On 9/6/2009 at 7:22 AM, in message <BEA6F029-0E69-4C35-BA7F-F881D4F5CC39@mac.com>, Todd Burch <toddburch@MAC.COM> wrote: > Open it for COBOL!! :) > > Todd > DB2 Level 2. > > > On Sep 5, 2009, at 8:47 PM, Frank Swarbrick wrote: > > Thanks for the idea. Adding periods after all end-execs does not fix > the issue. > > The issue does not occur (periods or not) when using the separate > precompiler. > > Definitely PMR time. > > Thanks, > Frank > > [...]
13802 261 32_Re: Cobol host variable question10_Todd Burch17_toddburch@MAC.COM30_Sun, 6 Sep 2009 11:53:50 -0500372_us-ascii Yep. The litmus test is typically whether the precompiler works differenty. In this case, the precompiler works, so my bet would be the parsing being done in the compiler. If COBOL support needs asist from us, they'll holler.<br><br>Todd<br><br>Sent from my iPhone<br><br>On Sep 6, 2009, at 11:36 AM, Frank Swarbrick <frank.swarbrick@EFIRSTBANK.COM > wrote: [...]
14064 37 32_Re: Cobol host variable question10_Todd Burch17_toddburch@MAC.COM30_Sun, 6 Sep 2009 13:40:01 -0500525_US-ASCII You know, another thought I had was to for you try uppercase.<br><br>Todd<br><br><br><br>On Sep 5, 2009, at 8:47 PM, Frank Swarbrick wrote:<br><br>Thanks for the idea. Adding periods after all end-execs does not fix the issue.<br><br>The issue does not occur (periods or not) when using the separate precompiler.<br><br>Definitely PMR time.<br><br>Thanks, Frank<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
14102 169 32_Robert Catterall's presentations10_DB2usa !!!19_db2usa3@HOTMAIL.COM30_Mon, 7 Sep 2009 04:32:33 -0400485_Windows-1252 <br><br>Hi DB2 user,<br><br>Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com<br><br>Last update on Monday, September 7th 2009<br><br><br><br>Here are several DB2 z/OS presentations of Robert Catterall, available on IDUG website and other websites:<br><br><br><br><br><br>- Get Up: DB2 High Availability & Disaster Recovery by Robert Catterall<br><br><br><br><br><br>- What DB2 People Should Know About SOA by Robert Catterall [...]
14272 30 51_Re: Problem with Query / Mainframe / DB2V7 vs DB2V822_Devyani R Sahasrabudhe22_devyani.sah@IN.IBM.COM30_Mon, 7 Sep 2009 09:47:43 +0000814_utf-8 How about this one?<br><br>Select T1.CDE_WR,max(T2.DTE_ACCT_PAY) as MAXDATE from PDB2.PORU.ACCTPAY_00R T1 inner Join PDB2.PORU.ACCTPAY_00R T2 on T1.CDE_WR = T2.CDE_WR WHERE (T1.DTE_ACCT_PAY + 6 MONTHS < CURRENT DATE) GROUP BY T1.CDE_WR<br><br>Thanks, Devyani<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *<br><br>_____________________________________________________________________<br><br>IDUG Europe Attendee Testimonial- "I had my first experience with certifications (and passed)! I learned a lot about DB2 version 9 (LUW) that hopefully will enable me to convince management a timely migration will be of benefit for the business." _____________________________________________________________________
14303 105 51_Re: Problem with Query / Mainframe / DB2V7 vs DB2V812_Isaac Yassin20_yassini@BEZEQINT.NET30_Mon, 7 Sep 2009 13:43:15 +0300402_iso-8859-1 Hi,<br><br>As already been written before (and probably will be written again in the future) -<br><br>Don't use "WHERE (T1.DTE_ACCT_PAY + 6 MONTHS < CURRENT DATE)" instaed, use "WHERE (T1.DTE_ACCT_PAY < CURRENT DATE - 6 MONTHS )<br><br>The reason - the 1st phrase is calculated for every row (and not indexable) the 2nd phrase - the time difference is calculated once and is indexable. [...]
14409 32 43_Re: [zOS] Level 1 Restricted State Checking12_Adam Baldwin22_adambaldwin@ES.IBM.COM30_Mon, 7 Sep 2009 12:27:04 +0000353_utf-8 Mike, thanks for the response. I'm also trying to work out how I can check this without having to code a test program. The only information that I have found re Level 1 Restricted State checking is in the Locking in DB2 for MVS/ESA Environment Redbook. There is a reference in Table 11 - Restricted State Checking During SQL Program Process. [...]
14442 64 43_Re: [zOS] Level 1 Restricted State Checking11_Mike Turner19_mike.turner@GMX.COM30_Mon, 7 Sep 2009 14:01:30 +0100636_utf-8 Hi Adam<br><br>I believe that an update of that Redbook is due before the end of this year. Maybe that will clarify things.<br><br>Regards Mike Turner Email: mike.turner@gmx.com Tel: +44 (0)1565-873702 Web: www.michael-turner.ltd.uk Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44. ----- Original Message ----- From: "Adam Baldwin" <adambaldwin@ES.IBM.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@WWW.IDUGDB2-L.ORG> Sent: Monday, September 07, 2009 1:27 PM Subject: Re: [DB2-L] [zOS] Level 1 Restricted State Checking [...]
14507 70 43_Re: [zOS] Level 1 Restricted State Checking11_Mike Turner19_mike.turner@GMX.COM30_Mon, 7 Sep 2009 14:58:17 +0100516_utf-8 Hi Adam<br><br>I just managed to do a test that confirmed my guess was correct. I ran a batch DSNTEP2 with input of 100 selects followed by a commit followed by another 100 selects, all in a single input stream. I started the TS RO and then started the job. -DIS DB LOCKS showed an S-lock on the table (it was a segmented TS - TS lock was IS as expected). I then started TS RW while job was running and kept doing -DIS DB LOCKS. Table lock stayed as S-lock for while and then switched to IS-lock. This is [...]
14578 26 43_Re: [zOS] Level 1 Restricted State Checking12_Adam Baldwin22_adambaldwin@ES.IBM.COM30_Mon, 7 Sep 2009 14:19:24 +0000383_utf-8 Many thanks Mike. I've got a dsntep2 running at the moment to test it as well! You've beaten me to it! Thanks for you time on this one. That's confirmed the result as being the one that I want it to be.<br><br>Cheers, Adam<br><br>_____________________________________________________________________<br><br>* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]