1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 2003, week 2
2 35 38_SQL0444N From Stored Procedure Builder13_Srini S Rajan37_srinivasan.x.sundararajan@VERIZON.COM30_Mon, 8 Dec 2003 12:20:22 +0530505_us-ascii dear members,<br><br>After a successful build of a sample stored procedures from DB2 Stored Procedure to the DB2 os/390 subsystem, I tried to execute the procedure and get the following. ------------------------------------------------------------------ V649744.HELLO - Calling stored procedure.<br><br>[IBM][CLI Driver][DB2] SQL0444N Routine "SQL33705" (specific name "") is implemented with code in library or path "", function "" which cannot be accessed. Reason code: "". SQLSTATE=42724 [...]
38 211 42_Re: How does include column in index help.0_13_apapad@NBG.GR30_Mon, 8 Dec 2003 09:11:55 +0200306_ISO-8859-7 To my understanding, the purpose of the INCLUDE statement in the LUW version 7.2 of DB2 is quite simple: You can have a unique index as required by the logic of your data and you can include some extra columns in order to avoid data access (to get the equivalent of INDEXOLNY access path). [...]
250 76 42_Re: SQL0444N From Stored Procedure Builder6_Vin db16_vindb2@YAHOO.COM30_Mon, 8 Dec 2003 04:09:28 -0800792_us-ascii Srini,<br><br>Did you check out the reasons for the SQLSTATE 47274 ? Two possible reasons are stated into following link: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnmch11/2.1.6.161?ACTION=MATCHES&REQUEST=42724&TYPE=FUZZY&SHELF=DSNSHHA1&DT=20010718150520&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT<br><br>Hope this helps..<br><br>Cheers<br><br>Navin Srini S Rajan <srinivasan.x.sundararajan@VERIZON.COM> wrote: dear members,<br><br>After a successful build of a sample stored procedures from DB2 Stored Procedure to the DB2 os/390 subsystem, I tried to execute the procedure and get the following. ------------------------------------------------------------------ V649744.HELLO - Calling stored procedure. [...]
327 72 20_Re: DB2 log question26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM30_Mon, 8 Dec 2003 12:14:44 -0000286_- Scott,<br><br>Once you've hit the dreaded high values, the log RBA wraps around. By the looks of where you are now, it looks like this will happen to you quite soon, that is in around 40 years or so (maybe less if your systems is on the grow). How long do you keep logs for? ;-) [...]
400 129 20_Re: DB2 log question13_Michael Ebert18_mebert@AMADEUS.NET30_Mon, 8 Dec 2003 14:18:56 +0100326_us-ascii Aurora,<br><br>I think you miscalculated by about a factor of 20... that's assuming that DB2 treats the RBA as an unsigned value, which I wouldn't bet too heavily on (otherwise it's about one order of magnitude). In any case, having used about one percent of a limited resource isn't all that close to the edge. [...]
530 242 42_Re: How does include column in index help.9_Mark Ruhe19_mark.ruhe@QUEST.COM30_Mon, 8 Dec 2003 07:30:10 -0600621_iso-8859-7 As of version 8 this is still just for unique indexes.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of apapad@NBG.GR Sent: Monday, December 08, 2003 1:12 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: How does include column in index help.<br><br><br><br>To my understanding, the purpose of the INCLUDE statement in the LUW version 7.2 of DB2 is quite simple: You can have a unique index as required by the logic of your data and you can include some extra columns in order to avoid data access (to get the equivalent of INDEXOLNY access path). [...]
773 18 57_Re: Question from the latest Idug Solutions Journal issue0_27_walter.janissen@VICTORIA.DE30_Mon, 8 Dec 2003 08:50:35 -0600454_- Hi<br><br>Nobody has replied to that thread anymore, but I think the question regarding the order by problem is not yet solved. Some people say, you can get rows out of order if you read with UR, and others say, that's not possible (I count to the latter). Now who is right? I think that is a serious problem and it should be clarified. May be Roger can do that. (May I add in clear and simple words, that even some German guys can understand it) [...]
792 37 67_New product: Handling extent problems automatically on DB2 for z/OS0_15_D.Johann@SEG.DE30_Mon, 8 Dec 2003 15:53:07 +0100578_us-ascii Dear List,<br><br>We would like to inform you about a new product from our RealTimeMaintain product family for DB2 z/OS called RT-ExtentManager.<br><br>Every DBA knows and hates the problem of exploding DB2 spaces resulting from, e.g., either unexpected amounts of data or unknown storage sizes needed by table spaces belonging to ERP systems like SAP. Even the requested allocation for objects in test environments is often not sufficient. To overcome this, DBAs had only the chance to oversize the allocation for such objects, thus wasting expensive DASD space. [...]
830 47 57_Re: Question from the latest Idug Solutions Journal issue15_Blaicher, Chris22_Chris_Blaicher@BMC.COM30_Mon, 8 Dec 2003 09:37:14 -0600394_iso-8859-1 If you read the manuals, and Roger has said it before, if you want rows returned in order, the only way to be sure is to use an ORDER BY clause. Some forms of processes do return rows in order, but that is by chance, not by design. Any order of rows returned by one release of DB2 may not be the same in the next release of DB2 unless an ORDER BY clause is included in the SQL. [...]
878 96 57_Re: Question from the latest Idug Solutions Journal issue26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM30_Mon, 8 Dec 2003 16:41:47 -0000548_- Chris,<br><br>The issue is exactly that, i.e. in his article Craig mentions that "An order by clause does not guarantee that rows will be returned in order if UR isolation level is used".<br><br>I know it sounds weird and it is very perplexing but I do not find this too odd although MOST inconvenient. If a row can disappear from a result set, or if there can be phantom reads or duplicate entries, it is equally possible that once the query has been executed parts of the results may be changed, but the result set will not be re-ordered. [...]
975 61 8_Re: REXX14_Timothy Curley26_timothy_curley@HOTMAIL.COM30_Mon, 8 Dec 2003 10:14:21 -0700385_- Since this is a db2 forum I assume that you are talking about DSNREXX.<br><br>>>Do you have this on your system?<br><br>DSNREXX is shipped with DB2, however, it is an optional installation step.<br><br>>>Who can use it? Once installed it is just another way of accessing db2. Security can be controlled at the DB2 table level, dsnrexx plan level, or via racf.....if you choose. [...]
1037 254 27_Re: 4K RESOURCE UNAVAILABLE10_Grace Chen20_grace.chen@CELERO.CA30_Mon, 8 Dec 2003 11:08:01 -0700452_ISO-8859-1 <br><br>Thanks for all of you who replied my question. I found a PTF UQ78946 for DB2 V7 which fix the problem that DB2 doesn't release 4K temp work space after the space extension fail. I believe UQ78945 is for DB2 V6.<br><br>Grace<br><br><br><br>-----Original Message----- From: Taddei, Cathy [mailto:Cathy.Taddei@PACIFICORP.COM] Sent: Friday, December 05, 2003 3:48 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: 4K RESOURCE UNAVAILABLE [...]
1292 34 36_SYSDBASE contention with dynamic SQL0_26_Ken.George@EDWARDJONES.COM30_Mon, 8 Dec 2003 12:44:39 -0600521_US-ASCII Hi,<br><br>We have some new Java programs which are executing dynamic SQL calls via db2-connect to our development subsystem. As development of the project has moved forward, we are seeing more and more 00C9008E abends with the Java issued dyamic SQL listed as the loser in the log display. The function that is listed as the holder of the resource is plan PPAMT99F which is CA-Platinum Plan Analyzer which we use as a back end to our compile process to provide explains for mainframe COBOL based programs. [...]
1327 168 8_Re: REXX19_Humphris,Richard P.24_Richard.Humphris@CNA.COM30_Mon, 8 Dec 2003 14:34:44 -0600548_us-ascii Hi Paul,<br><br>Just an fyi<br><br>Although DSNREXX is free, it is truly an "optional feature" of DB2. When ordering your next version of DB2 make sure you also "order" this feature as well (so that it comes with your installation tapes).<br><br>I assume you can order DSNREXX for Vx after the fact (as long as you can still order DB2 Vx itself). Thus, you can currently get DSNREXX for V7; but you won't be able to order DSNREXX for V5. And DSNREXX for V7 won't run on V5 (nor V6 for that matter). However I have run DSNXREXX for V6 [...]
1496 55 41_Creating sysout for each stored procedure12_Bill Johnson27_mellonbill@ZOOMINTERNET.NET30_Mon, 8 Dec 2003 22:55:04 -0500339_iso-8859-1 MessageAll,<br><br>I've heard this discussed before. For testing stored procedures we want each stored procedure to have it's own sysout instead of all the sysouts going to the same DD. How is this accomplished?<br><br>Thanks, Bill Johnson<br><br>---------------------------------------------------------------------------------
1552 52 74_heavy sequential insert to the end of the table and index&platch wait time30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM30_Tue, 9 Dec 2003 02:06:13 -0600365_- Hi all, we have a response time critical application which has too many concurent transactions that inserts 4 log records to 4 tables,and we have designed these tables as pctfree 0 freepage 0 and having an ascending nonclustering index with pctfree and freepage 0 also for inserting all the records to the last pages of data and index for eliminating I/O s. [...]
1605 43 8_Re: REXX0_16_mscarpa@CESVE.IT30_Tue, 9 Dec 2003 09:46:58 +0100373_us-ascii Paul<br><br>>Do you have this on your system?<br><br>Yes I installed V6 DSNREXX when I migrated from V5 to V6 but I use it very little. For admin purpose (ie for small programs) it easy to use, but I prefer to use something else like DB2WWWX for DBA's or DB2 sysprog activity. I used DSNREXX for testing DTTs, triggers & identity columns with small programs. [...]
1649 13 78_Re: heavy sequential insert to the end of the table and index&platch wait time0_27_walter.janissen@VICTORIA.DE30_Tue, 9 Dec 2003 03:09:29 -0600686_- I think the space map could be a problem, because as I know, these pages are treated as if you have row level locking. Did you try TRACKMOD NO. May be then some of your global lock contention will be alleviated.<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG [...]
1663 160 78_Re: heavy sequential insert to the end of the table and index&platch wait time10_OZGUR OZEN13_oozen@YKB.COM30_Tue, 9 Dec 2003 11:41:10 +0200474_Windows-1254 thanks I will plan to use it do you have any idea about the member cluster parameter,can't it be used with segmented ts's<br><br><br><br><br><br><br><br>walter.janissen@VICTORIA.DE<br><br>Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 09.12.2003 11:09 Please respond to DB2 Database Discussion list at IDUG<br><br><br><br>To: DB2-L@WWW.IDUGDB2-L.ORG cc: Subject: Re: heavy sequential insert to the end of the table and index&platch wait time [...]
1824 163 78_Re: heavy sequential insert to the end of the table and index&platch wait time10_OZGUR OZEN13_oozen@YKB.COM30_Tue, 9 Dec 2003 11:44:50 +0200425_Windows-1254 also I see 0 in glocal lock wait time,main problem of me is platch wait time ,is it related with datsaharing or is it only because of inserts,if so I would not work on member cluster and track mod no thanks.<br><br><br><br><br><br><br><br>walter.janissen@VICTORIA.DE<br><br>Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 09.12.2003 11:09 Please respond to DB2 Database Discussion list at IDUG [...]
1988 30 26_three part name in queries13_Srini S Rajan37_srinivasan.x.sundararajan@VERIZON.COM30_Tue, 9 Dec 2003 16:40:23 +0530398_us-ascii all<br><br>when i tried to use three part names to compare objects between sub systems,<br><br>using the following query:<br><br>SELECT NAME, DBNAME FROM SYSIBM.SYSTABLES A WHERE A.NAME NOT IN (SELECT B.NAME FROM rem1.SYSIBM.SYSTABLES B) WITH UR;<br><br>I get the following error SQLCODE = -512, ERROR: STATEMENT REFERENCE TO REMOTE OBJECT IS INVALID<br><br>Is there any workaround ? [...]
2019 139 45_Re: Creating sysout for each stored procedure12_Bob Galeotti22_bgaleotti@SOFTBASE.COM30_Tue, 9 Dec 2003 07:43:45 -0500431_iso-8859-1 MessageHello Bill, I don't know that there's a solution to your liking, but maybe if you implement a new coding standard that mandates that the stored procedure name be placed as the first part of the SYSOUT line ( i.e. - <stor_proc_nam> ), then you will be able to identify the output from each stored procedure. Ofcourse that coding will follow the stored procedure into production. Maybe that's not a bad thing. [...]
2159 40 30_Re: three part name in queries0_18_IWANT2BEME@AOL.COM28_Tue, 9 Dec 2003 07:52:45 EST699_US-ASCII Since remote and local tables can't be joined, one workaround is to build a temporary table with the remote row(s). The local and temp table can be joined.<br><br>Jacquie<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
2200 64 8_Re: REXX0_29_Tina.Hilton@ARVATOSYSTEMS.COM30_Tue, 9 Dec 2003 08:09:22 -0500641_- Max,<br><br>Where can I find DB2WWWX? Or is it something you have to pay for?<br><br>Tina<br><br>-----Original Message----- From: mscarpa@CESVE.IT [mailto:mscarpa@CESVE.IT] Sent: Tuesday, December 09, 2003 3:47 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: REXX<br><br><br><br>Paul<br><br>>Do you have this on your system?<br><br>Yes I installed V6 DSNREXX when I migrated from V5 to V6 but I use it very little. For admin purpose (ie for small programs) it easy to use, but I prefer to use something else like DB2WWWX for DBA's or DB2 sysprog activity. I used DSNREXX for testing DTTs, triggers & identity columns with small programs. [...]
2265 67 45_Re: Creating sysout for each stored procedure11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Tue, 9 Dec 2003 08:28:05 -0500611_iso-8859-1 You can do this but you must use the CEEMOUT service. You will have to set the runopts for the stored procedure i.e<br><br>RUN OPTIONS 'MSGFILE(MYPROG,FBA,121,0,NOENQ)'<br><br>Here are some code snips.<br><br>01 MESG-AREA. 05 MESG-LEN PIC S9(4) BINARY VALUE +120. 05 FILLER PIC X(1) VALUE SPACE. 05 MESG-PROG PIC X(8) VALUE "MYPROG". 05 MESG-TIME PIC X(14). 05 FILLER PIC X(1) VALUE SPACE. 05 MESG-TEXT PIC X(95) VALUE SPACES. 05 FILLER PIC X(1) VALUE SPACE. 01 MESG-DEST PIC S9(9) BINARY VALUE +2. 01 MESG-FEEDBACK PIC X(12). . . . STRING "RECEIVED PARM AUTHID = " AUTHID " " DELIMITED BY SIZE [...]
2333 21 45_Re: Creating sysout for each stored procedure13_Martin Packer24_martin_packer@UK.IBM.COM30_Tue, 9 Dec 2003 13:43:21 +0000432_US-ASCII Parenthetic comment: It's in production where you really want the separation into different DDs - one per SP INSTANCE. If you can, try to avoid writing much to the SPOOL as that'll cause SPs to ENQ. (We figured this one out recently on the SP red book residency.)<br><br>Cheers, Martin<br><br>Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584) [...]
2355 99 8_Re: REXX10_Lisa Bates29_Lisa.Bates@ROCKETSOFTWARE.COM30_Tue, 9 Dec 2003 08:39:19 -0500391_iso-8859-1 Tina, The USS Tools and Toys page http://www-1.ibm.com/servers/eserver/zseries/zos/unix/bpxa1ty2.html<br><br>It is so powerful and useful I never learned how to use DSNREXX. Look for the link db2imsrx . The downside is it can only execute single SQL statements. Running blocks of SQL in a UOW is not supported. I have not had success it getting it to call Stored Procedures. [...]
2455 199 45_Re: Creating sysout for each stored procedure15_William Johnson36_William.Johnson@ANTARESSOLUTIONS.COM30_Tue, 9 Dec 2003 08:41:03 -0500409_us-ascii I seem to recall an easier way that was discussed a while ago and I used a couple of years ago. Wasn't it separate DD's in the DSNSPAS address space for each Stored Procedure? Or something like that?<br><br>Thanks, Bill Johnson<br><br>>>> Lee_Hayden@CSX.COM 12/09/03 08:28AM >>> You can do this but you must use the CEEMOUT service. You will have to set the runopts for the stored procedure i.e [...]
2655 123 45_Re: Creating sysout for each stored procedure9_Agus Kwee13_askwe@ATT.NET30_Tue, 9 Dec 2003 09:02:54 -0500339_iso-8859-1 Bill,<br><br>The method that you mentioned is by using different 8 character name following the OUTDD cobol compiler option when compiling different cobol stored procedure program. You can use the unique stored procedure program name for the name of the OUTDD. You can then use separate DD's for each of those OUTDD names. [...]
2779 46 45_Re: Creating sysout for each stored procedure14_Avram Friedman32_Avram.Friedman@MORGANSTANLEY.COM30_Tue, 9 Dec 2003 09:29:30 -0500447_us-ascii Best solution for SYSOUT in production stored proceedures is DON'T EVEN CONSIDER IT.<br><br>1. The prinicipal use of stored procedures is to reduce network traffic. This implies the users are else where, most likely on a remote heterogeneous platform. They are not around to see the SYSOUT.<br><br>2. Creating a SYSOUT for every instance of every procedure is expensize in terms of cycles, JES resources like JOEs, elapsed time etc. [...]
2826 216 45_Re: Creating sysout for each stored procedure15_William Johnson36_William.Johnson@ANTARESSOLUTIONS.COM30_Tue, 9 Dec 2003 09:53:14 -0500333_us-ascii I'm not in support of using this method in production but for testing SP's it is invaluable. We used this method at another employer a couple of years ago. When you have 6 programmers trying to debug their SP's and all sending their displays to the same DD, splitting them into 6 separate DD's makes it so much easier. [...]
3043 14 78_Re: heavy sequential insert to the end of the table and index&platch wait time0_27_walter.janissen@VICTORIA.DE30_Tue, 9 Dec 2003 09:14:57 -0600647_- Hi<br><br>I've no experience with member cluster, but according to the manual it is only allowed for partitioned tablespaces.<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
3058 64 29_Message from Chief List Admin12_Phil Gunning22_pgunning@GUNNINGTS.COM30_Tue, 9 Dec 2003 10:58:54 -0500389_iso-8859-1 This weekend we will be adding [DB2-L] to the subject line of all posts to help you in setting your mail filter and to easily recognize posts from DB2-L. If you have any questions or concerns reqarding this, contact me offline at pgunningatgunningtsdotcom.<br><br>Cheers, Phil http://www.gunningts.com Chief List Admin IDUG DB2-L Co-Chair IDUG NA 2004 May 9-13, Orlando,Fl [...]
3123 66 27_Re: Loading Identity Column10_Shery Hepp17_schepp@SRPNET.COM30_Tue, 9 Dec 2003 10:05:57 -0600543_- On Thu, 20 Mar 2003 13:28:45 -0800, sue hsu <suehsu2003@YAHOO.COM> wrote:<br><br>> >Hi List, > >We are using DB2 7.1 on z/os 1.2. We encounter a problem with a DB2 identity column. Will appreciate if anyone can shed some light on it. > >We have a table that contains a column defined as: > integer not null generated always as identity > (start with 1, increment by 1, no cache, no cycle). >We defined a primary key (and, of course, a unique index) on this column. > >We inserted 3 rows and then read the table without any problem. >We [...]
3190 28 19_Setting up DSNACCOR18_David Sollenberger30_david.sollenberger@VITALPS.COM30_Tue, 9 Dec 2003 10:06:45 -0600455_- We have the COBOL code that calls DSNACCOR compiled, but when we attempt to bind we get the following message:<br><br>-T10D BIND SQL ERROR USING DB2ADMV2 AUTHORITY PLAN=(NOT APPLICABLE) DBRM=STOPRC STATEMENT=231 SQLCODE=-440 SQLSTATE=42884 TOKENS=PROCEDURE DSNACCOR CSECT NAME=DSNXOSTP RDS CODE=-100 -T10D UNSUCCESSFUL BIND FOR PACKAGE = USTSYIT10D.VVPSBVBE1COL.STOPRC.()<br><br>Has anyone else experienced this problem? thanks -David Sollenberger [...]
3219 170 8_Re: REXX0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Tue, 9 Dec 2003 08:31:17 -0800373_- Since REXX is free most everyone has it and you find a lot of usefully programs (also free) that other DB2 folks have written. This list has a good selection of REXX programs. cliff:-)<br><br>-----Original Message----- From: Humphris,Richard P. [mailto:Richard.Humphris@CNA.COM] Sent: Monday, December 08, 2003 12:35 PM To: DB2-L@www.idugdb2-l.org Subject: Re: REXX [...]
3390 101 33_Re: Message from Chief List Admin17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM30_Tue, 9 Dec 2003 11:14:29 -0600638_iso-8859-1 Hi Phil,<br><br>If we are using SUBJHDR (the standard LISTSERV option to accomplish the same thing) should we turn that off now?<br><br>Ken Kornblum<br><br>-----Original Message----- From: Phil Gunning [mailto:pgunning@GUNNINGTS.COM] Sent: Tuesday, December 09, 2003 9:59 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Message from Chief List Admin<br><br><br><br>This weekend we will be adding [DB2-L] to the subject line of all posts to help you in setting your mail filter and to easily recognize posts from DB2-L. If you have any questions or concerns reqarding this, contact me offline at pgunningatgunningtsdotcom. [...]
3492 30 85_Please Read: Message from Chief List Admin Regarding Subject header change, Cancelled12_Phil Gunning22_pgunning@GUNNINGTS.COM30_Tue, 9 Dec 2003 12:38:47 -0500568_iso-8859-1 I've decided to leave things the way they are as most of you have your email software set the way you want it. For your information, there is a subscription option, SUBJECTHDR (that does the same thing) that individual subscribers can set via the web interface by selecting join or leave the list or change settings from the home page. So if you need to include DB2-L in the Subject then you can set this option. In the future, new subscribers will have this as the default. If you have any difficulty using the web interface, contact the list admins. [...]
3523 115 78_Re: heavy sequential insert to the end of the table and index&platch wait time17_Markus Liebenberg31_Markus_Liebenberg@SAPIENS.CO.UK30_Tue, 9 Dec 2003 17:43:56 -0000668_iso-8859-1 What does the key column(s) look like?<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of zgür Özen Sent: 09 December 2003 08:06 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: heavy sequential insert to the end of the table and index&platch wait time<br><br><br><br>Hi all, we have a response time critical application which has too many concurent transactions that inserts 4 log records to 4 tables,and we have designed these tables as pctfree 0 freepage 0 and having an ascending nonclustering index with pctfree and freepage 0 also for inserting all the records to the last pages of data and index [...]
3639 248 33_Re: Message from Chief List Admin12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV30_Tue, 9 Dec 2003 12:50:44 -0500469_iso-8859-1 Rather than keeping it private, I would prefer to discuss it in public so that others can also see the replies.<br><br>I would ask that you consider the implications of this before proceeding to implement this change.<br><br>Placing a keyword in a subject plays havoc with many email clients because of the inconsistency apps have in treating the "reply to" portion of the subject line, and the relatively weak threading ability of other email clients. [...]
3888 304 33_Re: Message from Chief List Admin13_Brett Walters16_BWalters@UGI.COM30_Tue, 9 Dec 2003 13:23:10 -0500437_- In Novell Groupwise, we can use wildcards on the Subject like *DB2-L* to filter or send to a specific folder. Phil's plan would help, although I believe I already achieve the same results by sending all messages To: *IDUGDB2* to a specific folder...<br><br><br><br>......................................... Brett Walters Database Analyst UGI Utilities, Inc. 225 Morgantown Rd. Reading, PA 19611-1949 610-736-5518 bwalters@ugi.com [...]
4193 110 33_Re: Message from Chief List Admin10_Shi, Zhong23_Zhong.Shi@INCEPTURE.COM30_Tue, 9 Dec 2003 13:42:37 -0500532_iso-8859-1 Good idea.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Phil Gunning Sent: Tuesday, December 09, 2003 10:59 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Message from Chief List Admin<br><br><br><br>This weekend we will be adding [DB2-L] to the subject line of all posts to help you in setting your mail filter and to easily recognize posts from DB2-L. If you have any questions or concerns reqarding this, contact me offline at pgunningatgunningtsdotcom. [...]
4304 234 45_Re: Creating sysout for each stored procedure15_Tanya Haverchak36_Tanya.Haverchak@ANTARESSOLUTIONS.COM30_Tue, 9 Dec 2003 14:11:34 -0500585_us-ascii Avram, I agree with all your points. But I would like to know how do you handle the issue of error diagnosis in production stored procedures. In our shop, if sql call in DB2 stored procedure that is being called from the "web app" , returns negative sql code, SQLCODE along with SQLSTATE is displayed to a sysout for ease of problem determination. So far it has presented no problems. How ever, very recently we switched to WLM managed stored procedures. With these procedures, the displays in WLM address space, cause that particular address space to ABEND with a dump. [...]
4539 64 36_P97G version of CA Solutions for DB212_Carlos Olson14_COlson@QRS.COM30_Tue, 9 Dec 2003 11:25:58 -0800343_- We're currently using P97G version of CA's DB2 Products (Platinum) on OS/390 V2.6. We're planning to move to OS/390 V2.10 and then to Z/OS 1.4 soon. Anyone out there using P97 utilities with OS/390 V2.10 or Z/OS and if so, were there any issues? You can reply to me directly. Thanks, Carlos Olson colson@qrs.com <mailto:colson@qrs.com> [...]
4604 344 45_Re: Creating sysout for each stored procedure13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Tue, 9 Dec 2003 11:49:19 -0800583_iso-8859-1 We use WLM managed stored procedures, and have Cobol programmers doing DISPLAYs to sysout. We had some abends due to conflicts between Cobol's use of SYSOUT and LE/370 trying to put out messages. Most of these were eliminated when we explicitly coded //SYSOUT DD SYSOUT=* in the SP JCL.<br><br>We still had a few abends after that whenever there were multiple copies of a program doing DISPLAYs of 4k blocks of data to SYSOUT at the same time (NUMTCB=8, so it didn't take too many to cause the problem). After the programmer removed this huge DISPLAY, we have had no [...]
4949 311 45_Re: Creating sysout for each stored procedure14_Avram Friedman32_Avram.Friedman@MORGANSTANLEY.COM30_Tue, 9 Dec 2003 14:54:45 -0500425_us-ascii In production most of our SQL errors are resource unavailable. For these errors there is usually a message in the MSTR job log.<br><br>Our DBA's also use BMC APPTUNE to identify unusual SQL Codes. Some of them prefer CA Detector (which we no longer have activly installed)<br><br>I like to think that many potencial errors are addressed in our test environment. (Every one is entitled to at least one fantasy). [...]
5261 342 45_Re: Creating sysout for each stored procedure11_David Nance16_DWNance@FHSC.COM30_Tue, 9 Dec 2003 15:02:32 -0500310_US-ASCII Tanya, How about: writing the offending SQLCODE to an error table of some sort, send back as part of the output from the proc, pass a set SQLSTATE. Those are a few options available to you among many others you will soon be receiving.<br><br>Dave Nance First Health Services, Corp. (804)527-6841 [...]
5604 432 45_Re: Creating sysout for each stored procedure10_Price, Ray18_Ray.Price@DRKW.COM30_Tue, 9 Dec 2003 20:30:19 -0000380_- We also have stored procedures that put error diagnosis data to SYSOUT. We had problems if more than one tried to write to SYSOUT at the same time. We found that the ENQ option in the SP definition worked for us, something like:<br><br><br><br><br><br>RUN OPTIONS 'TRAP(ON),TERMT,MSGFILE(SYSOUT,FBA,121,0,ENQ)'<br><br><br><br><br><br>Seems to work fine for us. We use WLM. [...]
6037 169 40_Re: P97G version of CA Solutions for DB216_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Tue, 9 Dec 2003 14:36:07 -0600447_iso-8859-1 Hello Carlos,<br><br>P97 is an unsupported version, and P99 will have support dropped in June 2004, so you should upgrade to the latest P01 version as soon as possible. Another thing - CA is hosting a webcast December 16, which talks about the reasons to upgrade to P01 as well as some of the news : http://www3.ca.com/events/eventdetail.asp?CID=10779 <http://www3.ca.com/events/eventdetail.asp?CID=10779&CevID=53361> &CevID=53361 [...]
6207 89 20_view materialization15_Shields Michael29_ShieldsMichaelT@JOHNDEERE.COM30_Tue, 9 Dec 2003 14:45:11 -0600512_iso-8859-1 What causes a view to materialize? It makes sense that a where clause and/or a union and/or order by within a view would cause the view to materialize. However, we're seeing a batch report take over 5 hours currently because it's joining to a view (without any of the above conditions) that joins a couple 10 million + record tables and that view is materializing. When we go directly to the tables/columns we need, rather than getting the data from the view, we get the same results in seconds. [...]
6297 24 54_example of an asp application that uses host variables10_Rich Gugel26_rich.gugel@DOA.STATE.WI.US30_Tue, 9 Dec 2003 14:49:28 -0600408_- Does anyone have an example of an ASP or .net application that uses host variables or parameter markers? I've seen hints that Oracle documentation has a good example of one but have been unable to find it. I'm looking to get more out of our statement cache, but without a sample the application folks look lost. Just a small sample going against the sample database or db2 catalog would be wonderful. [...]
6322 107 24_Re: view materialization0_26_Phil.Sevetson@WAKEFERN.COM30_Tue, 9 Dec 2003 15:51:15 -0500358_us-ascii You might want to try "OPTIMIZE FOR 1 ROW" in the poorly-performing SELECT statement -- DB2 assigns different weights to outcomes based on OPTIMIZE. Other than that, one would have to examine the statement in question along with the table/index structures and statistics to get a good picture of why the optimizer is causing a materialization. [...]
6430 246 24_Re: view materialization15_Shields Michael29_ShieldsMichaelT@JOHNDEERE.COM30_Tue, 9 Dec 2003 15:06:55 -0600373_iso-8859-1 I did "Optimize For 1 Row" as I remembered hearing that was a little trick for this type of issue. It did drop the cost estimate in the explain down lower than either of the other 2 variations of the query. I'm going to execute it on prod tomorrow and see how it runs out. The explain with the "Optimize for 1 Row" still showed materialization of the view. [...]
6677 484 58_Re: example of an asp application that uses host variables12_Weigend, Don17_DWeigend@WBMI.COM30_Tue, 9 Dec 2003 15:23:33 -0600459_us-ascii Here is an example of a .net VB program that uses parameter markers. I hope this is an example of what you are looking for.<br><br><br><br><br><br>Dim strSQL As String<br><br>Dim objConn As ADODB.Connection<br><br>Dim objCmd As ADODB.Command<br><br>Dim objRS As ADODB.Recordset<br><br><br><br><br><br>strSQL = "SELECT POLICY_EFF_DATE, POLICY_EXP_DATE " & _<br><br>"FROM PIF_02_REC " & _<br><br>"WHERE POLICY_NUM = ? AND SYM = ? AND MODULE = ? " [...]
7162 17 45_Re: Creating sysout for each stored procedure0_18_IWANT2BEME@AOL.COM30_Tue, 9 Dec 2003 16:32:46 -0500725_iso-8859-1 In application the calling applications logs information about the parameters and the resulting messages which include the SQL code and SQLstate.<br><br>We also use CA's Detector.<br><br>Jacquie<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
7180 105 27_Re: Loading Identity Column14_Kiran P Gunnam17_kgunnam@YAHOO.COM30_Tue, 9 Dec 2003 13:24:01 -0800534_us-ascii I think it will restart the key . You need to alter sequnce and restart with the high number + 1 or next val.<br><br><br><br><br><br>Kiran --- Shery Hepp <schepp@SRPNET.COM> wrote: > On Thu, 20 Mar 2003 13:28:45 -0800, sue hsu <suehsu2003@YAHOO.COM> > wrote: > > > > >Hi List, > > > >We are using DB2 7.1 on z/os 1.2. We encounter a problem with a DB2 > identity column. Will appreciate if anyone can shed some light on it. > > > >We have a table that contains a column defined as: > > integer not null generated always [...]
7286 147 24_Re: view materialization8_goodrich26_phoebemaggie@INSIGHTBB.COM30_Tue, 9 Dec 2003 15:34:57 -0600677_iso-8859-1 MessageReference v7 admin guide 5.10.7.2 for discussion of view materialization ----- Original Message ----- From: Shields Michael Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, December 09, 2003 2:45 PM Subject: view materialization<br><br><br><br>What causes a view to materialize? It makes sense that a where clause and/or a union and/or order by within a view would cause the view to materialize. However, we're seeing a batch report take over 5 hours currently because it's joining to a view (without any of the above conditions) that joins a couple 10 million + record tables and that view is materializing. When we go directly [...]
7434 98 27_Re: Loading Identity Column12_HEPP SHERY C17_schepp@SRPNET.COM30_Tue, 9 Dec 2003 15:15:59 -0700474_iso-8859-1 Once I was able to get into IBMlink I found the following APAR- PQ76971<br><br>LOAD with IGNOREFIELDS YES into a table with an identity column, for example:<br><br>LOAD DATA LOG YES REPLACE INTO TABLE EIM_CONTACT_XM IGNOREFIELDS YES ( DSN_IDENTITY POSITION( 1: 8) DECIMAL)<br><br>caused bad values to be assigned to the identity column. The IGNOREFIELDS specification was not being checked correctly, causing LOAD to fail to generate identity column values. [...]
7533 126 24_Re: view materialization0_28_Dale.Smock@ARVATOSYSTEMS.COM30_Tue, 9 Dec 2003 17:34:24 -0500501_iso-8859-1 As mentioned in another response, the admin guide lists the causes of materialization (group by, column functions, distinct, join). When you join to a view that is materialized, you are joining to the result table (in DSNDB07) that is not indexed, resulting in a scan of the result table for additional joins. The only way we have found to avoid this with large result sets, is to create additional views which select directly to tables and include all the needed joins within a view. [...]
7660 77 40_Re: SYSDBASE contention with dynamic SQL12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 9 Dec 2003 17:30:44 -0800384_us-ascii I can't answer for sure. But I think a bind takes an exclusive lock on SYSDATABASE for the database that the plan needs. I know that I cannot bind plans that have active sql on the tables in the plans.<br><br>I suspect as your volume grows, you'll find more and more contention against SYSDATABASE and find it harder to bind and make database changes during prime time. [...]
7738 75 30_Re: three part name in queries0_18_IWANT2BEME@AOL.COM28_Tue, 9 Dec 2003 07:52:45 EST705_US-ASCII Since remote and local tables can't be joined, one workaround is to build a temporary table with the remote row(s). The local and temp table can be joined.<br><br>Jacquie<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm [...]
7814 112 41_Creating sysout for each stored procedure12_Bill Johnson27_mellonbill@ZOOMINTERNET.NET30_Mon, 8 Dec 2003 22:55:04 -0500776_iso-8859-1 MessageAll,<br><br>I've heard this discussed before. For testing stored procedures we want each stored procedure to have it's own sysout instead of all the sysouts going to the same DD. How is this accomplished?<br><br>Thanks, Bill Johnson<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm [...]
7927 60 74_heavy sequential insert to the end of the table and index&platch wait time30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM30_Tue, 9 Dec 2003 02:06:13 -0600365_- Hi all, we have a response time critical application which has too many concurent transactions that inserts 4 log records to 4 tables,and we have designed these tables as pctfree 0 freepage 0 and having an ascending nonclustering index with pctfree and freepage 0 also for inserting all the records to the last pages of data and index for eliminating I/O s. [...]
7988 33 57_Re: Question from the latest Idug Solutions Journal issue0_27_walter.janissen@VICTORIA.DE31_Wed, 10 Dec 2003 03:29:19 -0600548_- Hi all<br><br>I got it. I read the whole thread a few time and especially James' reply led me to my understanding. I even think now, that DB2 is not able to avoid the wrong ordering.<br><br>Suppose the following SQL-statement:<br><br>SELECT col1, col2, col3 FROM TABLE T1 ORDER BY col1 WITH UR<br><br>and suppose further, there is an index on col1 and the sort is avoided because of that index. The access path is not index only (I think that is important). The rows in the table have keys 10, 20, 30 and 40. Now when the statement picks up [...]
8022 51 3_AIS26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM31_Wed, 10 Dec 2003 11:14:37 -0000497_iso-8859-1 Hello list,<br><br>A quick poll: is anyone out there using the Actimize Intelligence Server (AIS)? If so, what do you think of it?<br><br>Please reply to me offline on this.<br><br>TIA.<br><br>ciao!<br><br>Aurora Emanuela Dell'Anno Database Analyst Data Services Group - Bank of America tel. 66192 ext. 0208 760 6192 aurora.dellanno@bankofamerica.com <mailto:aurora.dellanno@bankofamerica.com><br><br><br><br>* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER [...]
8074 36 41_DB2 Application Development Certification25_Gokulkumar Sathiyamoorthy18_yesgokul@YAHOO.COM31_Wed, 10 Dec 2003 03:14:26 -0800395_us-ascii Hi,<br><br>I'm preparing for DB2 v8 Application development certification. Currently I'm using DB2 Universal Database V8 Application Development Certification Guide, by Steve Sanyal, Kevin Gashyna, David Martineau, Mike Kyprianou I feel that this book alone is not sufficient & hence I have been searching the net for resources for this certification & am unable to find the same. [...]
8111 31 32_What is DB2 Answer to Oracle 10g13_Srini S Rajan37_srinivasan.x.sundararajan@VERIZON.COM31_Wed, 10 Dec 2003 17:06:47 +0530563_us-ascii few months back DB2 produced a top TPC bench mark on P-Series AIX 5L with 32 processors. But since then Oracle 10G on HP Itanium 64 processors produced two > 1 Mil. bench marks, which sounds like Oracle 10g will have superior performance than db2.<br><br>But reading in between, IBM uses only 32 processors so from a non-hardware guy perspective,I feel IBM could easily produce a better result if they use 64 processors at least from a performance angle if not from a cost angle, but I am not finding any such TPC listings from IBM of late. Any one [...]
8143 129 36_Re: What is DB2 Answer to Oracle 10g14_Nelson, Philip34_Philip.Nelson@SCOTTISHWIDOWS.CO.UK31_Wed, 10 Dec 2003 11:49:51 -0000374_iso-8859-1 This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should notify the sender immediately by telephone on 0131-655-6789 and must delete the original E-Mail without taking a copy. If you are not the addressee you must not copy, distribute, disclose or use any of the information in any way. [...]
8273 55 36_Re: [DB2EUG] DB2Move and parallelism4_Smit24_robert.erwin.smit@WXS.NL31_Thu, 11 Dec 2003 02:03:30 +0100394_iso-8859-1 Henry,<br><br>Are you licensed for 4 CPU's inst-user> db2licm -l does this give 4 CPU's or just 1?<br><br>What is your i/o idle time, perhaps you have an i/o problem?<br><br>Finally .........db2move...perhaps you can make it quicker by using exports and db2look? You could start the export jobs in the background so that you can start them all together..... ....parallel....... [...]
8329 21 36_Re: What is DB2 Answer to Oracle 10g12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Wed, 10 Dec 2003 10:51:23 -0600534_- Srini, From the results at TPC.org it is clear IBM dominates the TPC-H category on a habitual basis and was the top vendor in TPC-C 2x this year. I can't speak for IBM but I would point this out to mgt. TPC benchmarks are what they are, but you also need to look at the overall Database capabilities, operating and support costs, skills available, etc when making a database choice. I wouldn't doubt that will see new IBM TPC-C results in the next 6 months or so. They are quite costly to setup and run and maybe IBM puts this [...]
8351 305 24_Re: view materialization15_Shields Michael29_ShieldsMichaelT@JOHNDEERE.COM31_Wed, 10 Dec 2003 11:01:53 -0600416_iso-8859-1 Thanks to everyone for responding!<br><br>I snagged the book from my DBA and read the recommended admin section on materialization of views.<br><br>I then ran a couple tests/explains using the view and found the following:<br><br>select from the view -- did not cause materialization select joining to the view -- did not materialization select outer joining to the view -- did cause materialization [...]
8657 11 41_VSAM KSDS conversion to DB2 V7.1 for z/OS18_Prather, Doug, ISD28_dprather467@WORLDSAVINGS.COM31_Wed, 10 Dec 2003 11:14:52 -0600634_- I was wondering if anyone knew of a utility to convert VSAM KSDS datasets to DB2. Any help would be appreciated.<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
8669 264 24_Re: view materialization13_Mark A. Doyle19_mdoyle@JCPENNEY.COM31_Wed, 10 Dec 2003 11:26:28 -0600507_- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. [...]
8934 472 24_Re: view materialization15_Shields Michael29_ShieldsMichaelT@JOHNDEERE.COM31_Wed, 10 Dec 2003 11:35:28 -0600362_iso-8859-1 it's just the opposite, which is why I don't understand it. If we wanted everything from the view and then left joining it to the other data that would make sense to me. However, we're left outer joining our data to the view data. (data left outer join view)<br><br>I really appreciate Mark and anyone else who is willing to try and explain why. [...]
9407 318 24_Re: view materialization12_HEPP SHERY C17_schepp@SRPNET.COM31_Wed, 10 Dec 2003 10:41:04 -0700438_iso-8859-1 Michael- have you ran an explain on the LOJ query accessing the view? I'm wondering if you're doing merge scan join or nested loop. We have many queries here that use views and multiple inner and LOJ's And yes we have experienced some performance problems, but all of them have been resolved- either by applying PTF's from IBM or by changing the SQL. What version of Db2 are you on and how current on maintenance are you? [...]
9726 50 45_Re: VSAM KSDS conversion to DB2 V7.1 for z/OS12_Mark Granger22_the_grange@MBOX.COM.AU31_Wed, 10 Dec 2003 13:40:47 -0400379_us-ascii Doug,<br><br>See http://www.2bdb2.com .<br><br>2BDB2/VSAM has the option to run as a Transparency so that existing VSAM calls are directed to DB2.<br><br>I think the Data Conversion Utilities are able to be Licensed separately if you don't want the Transparency.<br><br>All the contact details are available there or e-mail me direct and I'll send your details on. [...]
9777 356 24_Re: view materialization15_Shields Michael29_ShieldsMichaelT@JOHNDEERE.COM31_Wed, 10 Dec 2003 11:46:34 -0600659_iso-8859-1 db2 os390 v7. type2 jdbc driver Version 7.2 fixpack 9 -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of HEPP SHERY C Sent: Wednesday, December 10, 2003 11:41 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: view materialization<br><br><br><br>Michael- have you ran an explain on the LOJ query accessing the view? I'm wondering if you're doing merge scan join or nested loop. We have many queries here that use views and multiple inner and LOJ's And yes we have experienced some performance problems, but all of them have been resolved- either by applying PTF's from IBM or by changing the SQL. [...]
10134 92 45_Re: VSAM KSDS conversion to DB2 V7.1 for z/OS0_26_Phil.Sevetson@WAKEFERN.COM31_Wed, 10 Dec 2003 13:00:21 -0500498_us-ascii REPRO to a flat file, followed by a DB2 LOAD statement. Unless you're talking about taking the file COPYLIBs and making DDL out of them?<br><br>--Phil Sevetson Database Administration Wakefern Food Corporation CISD mailto:phil.sevetson@wakefern.com<br><br><br><br><br><br><br><br><br><br><br><br>"Prather, Doug, ISD" <dprather467@WORLDSAVINGS.COM> Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 12/10/2003 12:14 PM Please respond to DB2 Database Discussion list at IDUG [...]
10227 49 45_Re: VSAM KSDS conversion to DB2 V7.1 for z/OS14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 10 Dec 2003 18:07:41 -0000426_iso-8859-1 Be aware that if you just convert an application from VSAM to DB2 and DON'T re-engineer to take advantage of DB2, or take advantage of SQL your performance is likely to be worse than it was with VSAM....<br><br>As an aside, why ARE you converting??<br><br>Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
10277 36 53_WLM Stored Procedure Address Space Management on Z/OS12_Wayne Fugere22_fugere_wayne@YAHOO.COM31_Wed, 10 Dec 2003 10:28:14 -0800387_us-ascii I have some questions for anyone running WLM managed stored procedures on Z/OS DB2 V7.<br><br>How did you decide how many Applenv(s) to run and how many different procedures do you direct to a single Applenv?<br><br>Do you limit the number of address spaces per applenv or use NOLIMIT?<br><br>How do you monitor the WLM address space(s) to decide when one may be too busy? [...]
10314 128 24_Re: view materialization11_David Nance16_DWNance@FHSC.COM31_Wed, 10 Dec 2003 13:38:04 -0500567_US-ASCII Michael, Just wanted to let you know that your problem is not the rule when doing an outer join to a view. The optimizer takes a lot into consideration when making the access path determination and you happened to run into one of the few places where it does not make the correct assumptions about the SQL. You could try writing your view a little differently and may get the results you want. You could, also, send the two queries to the list and recieve suggestions on how the SQL could be rewritten to perhaps avoidd the materialization. Either way, [...]
10443 15 8_Re: REXX0_18_jaruddy@US.IBM.COM31_Wed, 10 Dec 2003 12:46:37 -0600279_- In V8, DSNREXX no longer has to be ordered seperately - it is shipped as part of the base product. As such, it does not have a separate SMP/E install procedure. You will still have to Bind the packages and plan if want to use it.<br><br>Jim Ruddy DB2 for z/OS Development [...]
10459 53 57_Re: WLM Stored Procedure Address Space Management on Z/OS13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 10 Dec 2003 12:43:13 -0600571_us-ascii What language are you writting your stored procedures in?<br><br>Wayne Fugere wrote:<br><br>>I have some questions for anyone running WLM managed stored >procedures on Z/OS DB2 V7. > >How did you decide how many Applenv(s) to run and how many different >procedures do you direct to a single Applenv? > >Do you limit the number of address spaces per applenv or use NOLIMIT? > >How do you monitor the WLM address space(s) to decide when one may be >too busy? > >How do you monitor abends in the WLMs, third party tools? > >Any info is appreciated. > >Wayne > [...]
10513 94 45_Re: VSAM KSDS conversion to DB2 V7.1 for z/OS18_Prather, Doug, ISD28_Dprather467@WORLDSAVINGS.COM31_Wed, 10 Dec 2003 13:23:53 -0600352_us-ascii Thanks Phil, We have an app that wants to convert their VSAM / CICS up to DB2 for more management. We will be doing data modeling. The best approach I've seen so far is to do a repro unload and then selectively load the data columns to the modeled DB2 Database. I was just interested if there was any utility to convert from VSAM to DB2. [...]
10608 24 25_Stored Procedure Question4_Ravi23_Ravi.sankar@VERIZON.COM31_Wed, 10 Dec 2003 13:21:20 -0600459_- Hi,<br><br>We have stored (input 4 parms) procedure in the WLM enviornment and its working fine in test as well as in production.(two different tso system and db2 ssid). Now we have added one more new input parm (toatlly 5 parms) for the same procedure and wanted to test the old side and newside. (if we pass the 5 parms then it should point to new version else it should point to old version) All out SPs are in cobol and in z/os with db2 version 7. [...]
10633 82 57_Re: WLM Stored Procedure Address Space Management on Z/OS0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Wed, 10 Dec 2003 11:54:42 -0800555_- Wayne, We started with one but have added environments as the diversity of the storedprocedrues and users grew.<br><br>How many you create can be divided by your organizational workgroups like you probably do for CICS and BATCH. I've got mine broken down into four major groupings, DMV, PUC, Highway and Tec support. Within each group I'll have subgroups for production, development, testing etc. Within the subgroups I'll add WLM environments based on the type of work being done (finance, personal, etc.) amount of use, security, files used etc. [...]
10716 51 29_Re: Stored Procedure Question13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 10 Dec 2003 15:01:20 -0500413_utf-8 Hi Sankar,<br><br>It sounds to me like you may be confusing the behavior of User Defined Functions and Stored Procedures.<br><br>Stored Procedures are unique by Schema & Name With UDFs you can have multiple versions of the same Schema & Name differing by parameter count or datatype<br><br>To have different versions of the Stored Procedure within a subsystem, you need to vary the name or the schema. [...]
10768 133 45_Re: VSAM KSDS conversion to DB2 V7.1 for z/OS14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 10 Dec 2003 20:06:50 -0000354_iso-8859-1 Doug,<br><br>CA has a product called InfoRefiner that allows mapping of non-DB2 mainframe data sources and then controls the extraction, conversion, aggregation and loading into DB2 tables<br><br>If you need more information, drop me a line off-list, tell me geographically where you are located, and I will get a technician to call you. [...]
10902 59 57_Re: WLM Stored Procedure Address Space Management on Z/OS14_Avram Friedman32_Avram.Friedman@MORGANSTANLEY.COM31_Wed, 10 Dec 2003 15:16:51 -0500542_us-ascii We feel the correct number of application environments is a compromise between 1 and infinity.<br><br>I tend to personally support numbers closer to 1. If there are no changing DD's between one application environment and another then the extra application environment is most likely not needed. The one exception to this rule is if a special WLM is maintained for staging, burnin, diagnostics etc. Two popular applications that require special PROCS and thus special WLM environments are the Stored Procedure Builder and JAVA. [...]
10962 54 45_[DB2-L ZOS] Monitor Tools which use Wall Time0_26_Phil.Sevetson@WAKEFERN.COM31_Wed, 10 Dec 2003 17:32:46 -0500465_us-ascii We're using a third-party midrange OLAP tool against our DB2 V7 z/OS database. The application server occasionally times out on large requests; when it does, the DB2 server (subsystem) doesn't get the message and the database thread continues running. The application server timeout is based on elapsed time, and DB2 RLF controls threads based on CPU time. This is leading to large amounts of CPU cycle waste in environments where we can't afford it. [...]
11017 357 45_Re: VSAM KSDS conversion to DB2 V7.1 for z/OS24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Wed, 10 Dec 2003 17:39:27 -0500414_iso-8859-1 <br><br>Something else to think about on the VSAM KSDS conversion: there are IBM and third-party products which will help you to migrate the data from VSAM to DB2, but enable application programs to continue to run unmodified. The products use a layer of indirection which intercepts the VSAM I/O call and translates it into native DB2 SQL. Collectively we call these products "VSAM Transparency". [...]
11375 61 49_Re: [DB2-L ZOS] Monitor Tools which use Wall Time12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 10 Dec 2003 15:43:55 -0800552_us-ascii I don't know about monitor tools that can monitor/cancel threads. IMF (now from BMC) used to do this, but not sure if it can any more. It had all kinds of operator capabilities that were programmable.<br><br>But if you are using Db2 connect, you can eliminate some of this problem with some settings on your db2 connect server. use QUERYTIMEOUT=0 and INTERRUPT_ENABLED to cancel threads when the user system cancels them. Also don't use KEEPCONNECT=x where x>0. I've found that this will hold threads active even when they're not active. [...]
11437 26 53_Re: DB2 z/OS V7 - Identity columns and MAXASSIGNEDVAL22_KenParis@austin.rr.com22_KenParis@AUSTIN.RR.COM31_Wed, 10 Dec 2003 17:46:57 -0600376_- I have two questions (for anyone to respond to) related to your response. I haven't used REPAIR. How safe is it and what's the likelihood we'll be able to persuade the production DBA's to use it? We have over 20 identities we have to "bump".<br><br>Second, does anyone know of the likelihood that IBM will make the Version 8 facility available to V7 users via an APAR? [...]
11464 140 49_Re: [DB2-L ZOS] Monitor Tools which use Wall Time0_26_Phil.Sevetson@WAKEFERN.COM31_Wed, 10 Dec 2003 18:51:33 -0500570_us-ascii Myron,<br><br>Thanks for the info. I hadn't heard of those settings; I'll forward this info to our DB2-Connect Guru.<br><br>--Phil Sevetson Database Administration Wakefern Food Corporation CISD mailto:phil.sevetson@wakefern.com<br><br><br><br><br><br><br><br><br><br><br><br>Myron Miller <myronwmiller@YAHOO.COM> Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 12/10/2003 06:43 PM Please respond to DB2 Database Discussion list at IDUG<br><br><br><br>To: DB2-L@WWW.IDUGDB2-L.ORG cc: Subject: Re: [DB2-L ZOS] Monitor Tools which use Wall Time [...]
11605 102 49_Re: [DB2-L ZOS] Monitor Tools which use Wall Time16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 10 Dec 2003 18:00:54 -0600627_iso-8859-1 Good afternoon Phil, Since you explicitly asked for vendor solutions, I can't help responding. If you are licensed for just ONE of CA's DB2 products, and you are on the P01 release, you actually get this component for free. The component is called Thread termination. You can set up profiles based on PLAN / Connection-id / Job name / Auth-id / Correlation-id and Connection-type. These profiles are attached to a Threshold Profile where you can define thresholds for Elapsed time, INDB2-elapsed time, INDB2 CPU time IDLE time, GETP requests, Total SQL's. Finally you can define to issue warnings, hard cancels [...]
11708 59 53_Re: DB2 z/OS V7 - Identity columns and MAXASSIGNEDVAL12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 10 Dec 2003 16:01:08 -0800576_us-ascii Ken, I've used REPAIR extensively. But always with extreme caution. Its not for the causal user. You can cause serious damage with it if not careful and don't understand what you're doing. Its fine if you understand it fully. But!!!<br><br>As to your second question, I don't officially have any idea what IBM will do as only they would know. But based upon the experiences IBM had with V5 retroing fixes from V6 into it, I'd seriously doubt if IBM will ever do that again. Some of the retro features caused nightmare headaches for people and IBM support. So my [...]
11768 133 26_Recovery question DB2 Z/OS13_Larry Holford27_lholford@NYSTRS.STATE.NY.US31_Wed, 10 Dec 2003 18:28:57 -0600361_- Hi All,<br><br>I am having trouble recovering a tablespace and need help, here is the sequence of events.<br><br>1. Successfully ran an image copy of the tablespace (62 pages, 1722 rows).<br><br>2. Ran a BMC utility to rename a column (this really does a drop table and create table command), didn't do an unload of the data (my mistake), data now gone. [...]
11902 52 27_DSN1COPY -- for replication0_21_Nam_Wu@PEOPLESOFT.COM31_Wed, 10 Dec 2003 16:34:48 -0800330_us-ascii Hello,<br><br>I am a 390 newbie and I need some help with the DSN1COPY utility. What I want to do is to replicate the objects and data from one database into several other databases. Does anybody out there have a manual they can share, or a link that they can direct me to, or share about the problems you ran into? [...]
11955 446 30_Re: Recovery question DB2 Z/OS17_Duane Lee - EGOVX22_DLee@MAIL.MARICOPA.GOV31_Wed, 10 Dec 2003 17:48:21 -0700596_iso-8859-1 If what you did really did drop and recreate the table then you'll need to use DSN1COPY to recover the old table. Create the old tablespace and table and indexes then execute DSN1COPY, identify the source and target tablespace and table (you may need to use DSN1PRNT against the imagecopy to identify the OBIDs for the source tablespace and table - see the Diagnosis guide for where you can find this information in the DSN1PRNT output), the source data will come from your imagecopy. After you finish "loading" the table with the data from the imagecopy then rebuild the indexes [...]
12402 138 31_Re: DSN1COPY -- for replication17_Duane Lee - EGOVX22_DLee@MAIL.MARICOPA.GOV31_Wed, 10 Dec 2003 18:00:36 -0700528_iso-8859-1 I built some SQL and REXX to build the DSN1COPY JCL for me. I use one SQL routine too extract the source information, one SQL routine to extract the target information and a REXX routine to read the extracted data and build the DSN1COPY JCL. If you have multiple tables per tablespace this won't work without modification on your part. If you are interested let me know and I'll send what I have to you and you can do with it what you will. It sets up one step per table. The table names must be the same in the [...]
12541 251 30_Re: Recovery question DB2 Z/OS0_35_paul.a.redhead@TRANSPORT.QLD.GOV.AU31_Thu, 11 Dec 2003 15:17:15 +1000572_us-ascii Larry, I think I understand you basically saying that you (a) Took an Image Copy of the tablespace (FULL I hope) (b) via software dropped and recreated the table in the tablespace (c) recovered the tablespace.<br><br>In this situation the three magic numbers of importance to you are the database id (DBID), tablespace id (PSID - page set id) and the table id (OBID - OBject id). Since you did not drop and recreate the tablespace the DBID and PSID are kosher...when the RECOVERy happend rows with the old table id were put back. When DB2 looks for rows for [...]
12793 308 30_Re: Recovery question DB2 Z/OS13_Srini S Rajan37_srinivasan.x.sundararajan@VERIZON.COM31_Thu, 11 Dec 2003 12:39:46 +0530557_us-ascii I have not tried it myself, but I read the following from the utilities manual.<br><br>-------------------------------------------------------------------- The FROMCOPY image copy data set must have been created | by one of the following utilities:<br><br>| COPY<br><br># COPYTOCOPY<br><br>| LOAD inline image copy<br><br>| MERGECOPY<br><br>| REORG TABLESPACE inline image copy<br><br>which states that you can unload from the imagecopy set, I wonder will it be easier for you to unload the data from the imagecopy and reload it to the table. [...]
13102 22 45_Re: VSAM KSDS conversion to DB2 V7.1 for z/OS13_Martin Packer24_martin_packer@UK.IBM.COM31_Thu, 11 Dec 2003 09:07:29 +0000374_US-ASCII I don't see why you couldn't run a DFSORT COPY from VSAM to Sequential and then load into DB2.<br><br>(Of course you could do much more with this DFSORT COPY step, including any necessary transformations.)<br><br>Cheers, Martin<br><br>Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584) [...]
13125 22 48_heavy sequential insert activity & response time30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM31_Thu, 11 Dec 2003 03:43:03 -0600349_- Hi all, I had asked about pagelatch time of our inserts and I will try to use member cluster and trackmod no options, bu we have also seen that we have high update commit time for our inserts.<br><br>CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT -------------------- ------------ -------- SER.TASK SWTCH 0.022681 1.02 UPDATE COMMIT 0.022681 1.02 [...]
13148 37 63_z/OS - OT & not DB2 related. Request for assembler program.....0_16_mscarpa@CESVE.IT31_Thu, 11 Dec 2003 11:21:39 +0100318_us-ascii Estimeed listers, my unique and only friends, I've not any friend better than you..... (not bad as flattery, isn't it ?)<br><br>I'm looking for an assembler routine that display the instantaneous CPU usage (like the value you see in SDSF panel when you type DA OJOB for instance), for S390 2.10 or z/OS. [...]
13186 15 52_Re: heavy sequential insert activity & response time0_27_walter.janissen@VICTORIA.DE31_Thu, 11 Dec 2003 05:11:09 -0600285_- Hi<br><br>I am not sure about that, but I think the time arose, because the updated pages have to be written to the group buffer pool. May be, to minimize that, you can do the writing as the updates occur by using the BIND- Parameter IMMEDWRITE YES for the package in question. [...]
13202 167 49_Re: [DB2-L ZOS] Monitor Tools which use Wall Time26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM31_Thu, 11 Dec 2003 11:12:03 -0000502_- Hi Phil,<br><br>my old employers' tool, Omegamon for DB2, could do stuff like this.<br><br>ciao!<br><br>Aurora Emanuela Dell'Anno Database Analyst Data Services Group - Bank of America tel. 66192 ext. 0208 760 6192 <mailto:aurora.dellanno@bankofamerica.com> aurora.dellanno@bankofamerica.com<br><br>* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER<br><br>no trees were killed in sending this message. However, a large number of electrons were seriously inconvenienced :-) [...]
13370 82 45_Re: VSAM KSDS conversion to DB2 V7.1 for z/OS26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM31_Thu, 11 Dec 2003 11:24:01 -0000634_- Doug,<br><br>I remember a product called Convert by Forecross (maybe www.forecross.com ?) that did just that.<br><br>Then there was something called... DBMS Migrator from Blue Phoenix Technologies (no guesses on the web address here).<br><br>These were all examined by my team during a project for VSE/VSAM migration to DB2. We did it some other way due to that VSE keyword, with the help of a wonderful Redbook called "How to Get to DB2 from VSE/VSAM Using DB2 VSAM Transparency for VSE/ESA", which I just looked for on the Redbooks website at http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg244931.html? Open [...]
13453 17 52_Re: heavy sequential insert activity & response time0_16_mscarpa@CESVE.IT31_Thu, 11 Dec 2003 12:31:19 +0100600_us-ascii What GBPCACHE value do you have ?<br><br>Just curious<br><br>Max Scarpa<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
13471 89 57_Re: WLM Stored Procedure Address Space Management on Z/OS26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM31_Thu, 11 Dec 2003 11:29:44 -0000412_- Wayne,<br><br>Apart from all the illuminated answers that you have had (and no doubt will have) from my betters (no longer elders at my age ;-) I can offer you some good white papers and presentations. If you wish, I can email them to you.<br><br>ciao!<br><br>Aurora Emanuela Dell'Anno Database Analyst Data Services Group - Bank of America tel. 66192 ext. 0208 760 6192 aurora.dellanno@bankofamerica.com [...]
13561 125 68_Re: z/OS - OT & not DB2 related. Request for assembler program... ..26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM31_Thu, 11 Dec 2003 11:38:26 -0000608_- Max,<br><br>This is the first reply to your question from IBM-MAIN (if there's more later, you can look them up at the url at the bottom):<br><br>============================================================ Date: Thu, 11 Dec 2003 21:24:15 +1000 Reply-To: IBM Mainframe Discussion List <IBM-MAIN@BAMA.UA.EDU> Sender: IBM Mainframe Discussion List <IBM-MAIN@BAMA.UA.EDU> From: ibm-main <ibm-main@TPG.COM.AU> Subject: Re: FW: z/OS - OT & not DB2 related. Request for assembler program... .. In-Reply-To: <C654430B1D0C9E4084A0D88C5BE132000126D7D3@crotmp14.emea.bankofamerica.com> Content-Type: text/plain [...]
13687 25 17_SET DB2-L NO MAIL12_Dauncey, Ian18_idauncey@FNB.CO.ZA31_Thu, 11 Dec 2003 14:22:47 +0200757_iso-8859-1 ___________________________________________________________________________________________________<br><br><br><br>The views expressed in this email are, unless otherwise stated, those of the author and not those of the FirstRand Banking Group or its management. The information in this e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, [...]
13713 208 52_DB2MOVE Utility Not Moving 'WITH DEFAULT' Definition15_Schade, Jeffrey15_JSchade@ISO.COM31_Thu, 11 Dec 2003 08:08:28 -0500532_us-ascii I have been using the DB2MOVE and DB2LOOK utilities on a Windows DB2 UDB Version 8 platform to extract DDL from OS/390 DB2 Version 6 on a mainframe and I have noticed that all my columns defined as 'NOT NULL WITH DEFAULT' came over as 'NOT NULL'. The 'WITH DEFAULT' option was dropped. Can anyone give me a clue as to why this happened and how I can correctly move the table definitions. I must admit I am seriously disappointed in how many changes I have to make to my mainframe DDL to get it to work on Windows UDB. [...]
13922 68 67_Re: z/OS - OT & not DB2 related. Request for assembler program.....14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Thu, 11 Dec 2003 08:10:11 -0600330_us-ascii Max, What version of OS/390 or z/OS are you on? SDSF is (was?) shipped in source form, look for ISF. Libraries. You should be able to find the code there. Wayne Driscoll Sr. Software Developer Quest Software wdriscoll@listserv.quest.com NOTE: All opinions are strictly my own. EMail Address in sig must be modified. [...]
13991 58 49_Re: [DB2-L ZOS] Monitor Tools which use Wall Time12_Weigend, Don17_DWeigend@WBMI.COM31_Thu, 11 Dec 2003 08:16:14 -0600601_us-ascii Where do I find these "QUERYTIMEOUT=0 and INTERRUPT_ENABLED" in DB Connect. I looked in the client settings as well as the advanced settings for one of the database alias entries.<br><br>Don Weigend DB2 OS/390 Sysprog IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 West Bend Mutual Insurance Company<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Myron Miller Sent: Wednesday, December 10, 2003 5:44 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L ZOS] Monitor Tools which use Wall Time [...]
14050 288 31_Re: DSN1COPY -- for replication12_Weigend, Don17_DWeigend@WBMI.COM31_Thu, 11 Dec 2003 08:18:25 -0600583_us-ascii Sorry to hear about what your CIO is doing. Same thing is happening at my company. I sincerely wish you luck with the job search.<br><br><br><br><br><br>Don Weigend<br><br>DB2 OS/390 Sysprog<br><br>IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390<br><br>West Bend Mutual Insurance Company<br><br><br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Duane Lee - EGOVX Sent: Wednesday, December 10, 2003 7:01 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: DSN1COPY -- for replication [...]
14339 71 49_Re: [DB2-L ZOS] Monitor Tools which use Wall Time18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 11 Dec 2003 09:23:32 -0500431_iso-8859-1 You'll find them under Program Files/SQLLLIB/db2cli.ini ...they would be in there if they are set at all. If not you can add querytimeoutinterval=0 to the end of the file to turn it off.<br><br>--Steve....<br><br>-----Original Message----- From: Weigend, Don [mailto:DWeigend@WBMI.COM] Sent: Thursday, December 11, 2003 9:16 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L ZOS] Monitor Tools which use Wall Time [...]
14411 10 58_Re: example of an asp application that uses host variables10_Rich Gugel26_rich.gugel@DOA.STATE.WI.US31_Thu, 11 Dec 2003 08:44:08 -0600569_- Thanks, That was exactly what I was looking for<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14422 24 67_Re: z/OS - OT & not DB2 related. Request for assembler program.....0_16_mscarpa@CESVE.IT31_Thu, 11 Dec 2003 15:47:11 +0100302_us-ascii Hi Wayne<br><br>I found a SRC library where there are some pieces of code I'll check better. But what I want to find is a routine that simply gives me the cpu usage in my machine in a particular moment using (maybe via REXX) OS/390 (we are at 2.10) services or 'browsing' storage fields. [...]
14447 82 49_Re: [DB2-L ZOS] Monitor Tools which use Wall Time11_Gugel, Rich26_Rich.Gugel@DOA.STATE.WI.US31_Thu, 11 Dec 2003 09:00:54 -0600379_iso-8859-1 Query timeout interval is documented on the cli parameters from the following link, If I remember correctly you need to edit the db2cli.ini file in the common section to put this in.<br><br>http://www-306.ibm.com/software/data/db2/udb/ad/v8/cli.html<br><br>Interupt enable is on the dcs options (connect version 8), but I think it was there on version 7 as well. [...]
14530 45 78_Re: heavy sequential insert to the end of the table and index&platch wait time11_Chris White18_crick616@YAHOO.COM31_Thu, 11 Dec 2003 09:02:23 -0600358_- From a previous post by walter janissen... >>I've no experience with member cluster, but according to the manual it is >>only allowed for partitioned tablespaces.<br><br>Walter, Are you sure about that? I think member cluster can be used on all but LOB and TEMP tablespaces. Here's how I would evaluate whether to use member cluster vs trackmod no... [...]
14576 23 76_Re: z/OS - OT & not DB2 related. Request for assembler program..... - Thanks0_16_mscarpa@CESVE.IT31_Thu, 11 Dec 2003 16:12:41 +0100737_us-ascii Hi all<br><br>Thank you all for replies.<br><br>I found (now that I can connect to the Net again) what I need in a CBT file, a REXX digging in S390 memory/control blocks.<br><br>Best regards<br><br>Max Scarpa<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14600 12 78_Re: heavy sequential insert to the end of the table and index&platch wait time30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM31_Thu, 11 Dec 2003 09:16:54 -0600561_- Can we use these 2 parameters together.<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14613 11 52_Re: heavy sequential insert activity & response time30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM31_Thu, 11 Dec 2003 09:20:25 -0600545_- we use GBPCACHE CHANGED<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14625 14 78_Re: heavy sequential insert to the end of the table and index&platch wait time0_27_walter.janissen@VICTORIA.DE31_Thu, 11 Dec 2003 09:28:27 -0600643_- Chris<br><br>Sorry, you are right and I am wrong. You can create a nonpartitioned member cluster tablespace. So my fault.<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14640 23 78_Re: heavy sequential insert to the end of the table and index&platch wait time0_27_walter.janissen@VICTORIA.DE31_Thu, 11 Dec 2003 09:34:26 -0600677_- On Thu, 11 Dec 2003 09:16:54 -0600, zg=?ISO-8859-1?Q?=FCr_=D6zen?= <oozen@YKB.COM> wrote:<br><br>>Can we use these 2 parameters together. Answer is YES > >--------------------------------------------------------------------------- ------ >Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm [...]
14664 57 20_Log Record Timestamp0_26_Fatima.Osorio@BPORTUGAL.PT31_Thu, 11 Dec 2003 15:35:44 +0000378_iso-8859-1 Hi all. Do you know how to read the timestamp of a log record? I've read the Admin guide, where it is said that in Log record header there is a field of 8 bytes that is the LRHTIME. Is this the time of the creation of this record? How can I translate it to a understandable by me date and time in the format of yyyymmddhhmmssss or something like this? Thank you [...]
14722 13 78_Re: heavy sequential insert to the end of the table and index&platch wait time30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM31_Thu, 11 Dec 2003 09:36:09 -0600659_- I tried and could not created,so now I am trying to partition tables? It returns segsize and member cluster parameters mutually exclusive<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14736 12 30_Re: Recovery question DB2 Z/OS9_nguyen dt30_duc.nguyen@EUROCLEARFRANCE.COM31_Thu, 11 Dec 2003 09:26:22 -0600686_- i've tried the test : unload from copy , you get the message "tablespace is empty" , obviously it has the same logic as copy : the obid doesn't exist anymore so ...<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14749 58 78_Re: heavy sequential insert to the end of the table and index&platch wait time17_Markus Liebenberg31_Markus_Liebenberg@SAPIENS.CO.UK31_Thu, 11 Dec 2003 15:49:15 -0000416_iso-8859-1 With the SEGSIZE clause you should get SQLCODE -628. Remove the SEGSIZE clause from your CREATE TABLESPACE DDL and see what happens.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of zgür Özen Sent: 11 December 2003 15:36 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: heavy sequential insert to the end of the table and index&platch wait time [...]
14808 12 78_Re: heavy sequential insert to the end of the table and index&platch wait time30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM31_Thu, 11 Dec 2003 09:46:53 -0600586_- Yes I got -628 but without segsize it will be simple tablespace?<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14821 34 30_Re: Recovery question DB2 Z/OS0_29_Tina.Hilton@ARVATOSYSTEMS.COM31_Thu, 11 Dec 2003 10:47:00 -0500552_- When the table has been dropped & recreated like this, you must include the DDL of the original table as input. It's described in the Unload Plus reference manual.<br><br>-----Original Message----- From: nguyen dt [mailto:duc.nguyen@EUROCLEARFRANCE.COM] Sent: Thursday, December 11, 2003 10:26 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Recovery question DB2 Z/OS<br><br><br><br>i've tried the test : unload from copy , you get the message "tablespace is empty" , obviously it has the same logic as copy : the obid doesn't exist anymore so ... [...]
14856 113 31_Re: DSN1COPY -- for replication0_17_sjvagnier@AEP.COM31_Thu, 11 Dec 2003 10:58:44 -0500567_us-ascii Duane, please contact me offline about job opportunities..<br><br><br><br>**************************************** Steve Vagnier American Electric Power Data Services One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-716-3677<br><br><br><br><br><br><br><br><br><br>"Weigend, Don" <DWeigend@WBMI.CO To: DB2-L@WWW.IDUGDB2-L.ORG M> cc: Sent by: DB2 Data Subject: Re: DSN1COPY -- for replication Base Discussion List <DB2-L@IDUGDB2-L. ORG><br><br><br><br>12/11/2003 09:18 AM Please respond to DB2 Database Discussion list at IDUG [...]
14970 12 52_Re: heavy sequential insert activity & response time30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM31_Thu, 11 Dec 2003 10:05:05 -0600645_- sorry but can you explain more detailly the effects of immediate write for my case?Does it have any other bad consequences?<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14983 49 78_Re: heavy sequential insert to the end of the table and index&platch wait time11_Chris White18_crick616@YAHOO.COM31_Thu, 11 Dec 2003 10:06:14 -0600630_ISO-8859-1 From zgür Özen <oozen@YKB.COM>... >>Can we use these 2 parameters together?<br><br><br><br>I've never tried so I don't know for sure. It may be technically possible, but they seem to contradict each other in the way they track changes.<br><br>I think "member cluster" maintains the changed data bit on space map pages and "trackmod no" does not, so they seem mutually exclusive in that context. One significant difference... "member cluster" only applies to data sharing environments while "trackmod no" can be used in either DS or non-DS environments. But I don't think the decision for using one or the other is [...]
15033 71 79_Re: heavy sequential insert to the end of the table and index&pla tch wait time26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM31_Thu, 11 Dec 2003 16:05:37 -0000462_- Ozgur Bey,<br><br>For a partitioned tablespace, the syntax is CREATE TABLESPACE ...... NUMPARTS int MEMBER CLUSTER ....<br><br>Your partitioined tbs cannot be segmented, and viceversa.<br><br>HTH, iyi aksamlar.<br><br>ciao!<br><br>Aurora Emanuela Dell'Anno Database Analyst Data Services Group - Bank of America tel. 66192 ext. 0208 760 6192 aurora.dellanno@bankofamerica.com<br><br>* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER [...]
15105 72 24_Re: Log Record Timestamp14_Heiss, Gerhard20_Gerhard.Heiss@RUV.DE31_Thu, 11 Dec 2003 17:03:12 +0100751_iso-8859-1 possibly this might help:<br><br>SELECT TIMESTAMP( X'BA7389BBCC0C0002' ) FROM SYSIBM.SYSDUMMY1; ---------+---------+---------+--------- 2003-12-10-23.05.16.662976 NUMBER OF ROWS SELECTED 1<br><br>regards gerhard<br><br><br><br>-----Original Message----- From: Fatima.Osorio@BPORTUGAL.PT [mailto:Fatima.Osorio@BPORTUGAL.PT] Sent: Thursday, December 11, 2003 4:36 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Log Record Timestamp<br><br><br><br>Hi all. Do you know how to read the timestamp of a log record? I've read the Admin guide, where it is said that in Log record header there is a field of 8 bytes that is the LRHTIME. Is this the time of the creation of this record? How can I translate it to a understandable by me date and time in [...]
15178 55 30_Re: Recovery question DB2 Z/OS0_19_DB2Automate@AOL.COM29_Thu, 11 Dec 2003 11:08:34 EST339_US-ASCII Nguyen, This is Ed the person that sent you a GENDB2 package several months ago. The GENDB2 software product will save all the IDs, DBIDs, PSIDs, and OBIDs that way you do not have to print reports and figure it out (all panel driven). Did you have time to install the software and test it? Please get back with me off line. [...]
15234 78 24_Re: Log Record Timestamp12_michael bell24_mbell11@WORLDNET.ATT.NET31_Thu, 11 Dec 2003 10:20:48 -0600443_iso-8859-1 I haven't checked the log records myself but most of the time fields in DB2 internals are STCK format. see the 370 principles of operations for more details on the actual format (time of day clock). there is an ASM macro STCKCONV that will convert it to more conventional formats. The connect token that causes -818 is a modified STCK format so you might be able to use some code that displays that in normal date/time format. [...]
15313 31 24_Re: Log Record Timestamp0_16_mscarpa@CESVE.IT31_Thu, 11 Dec 2003 17:25:12 +0100358_us-ascii You can use also (if you like REXX):<br><br>/*REXX*/ TRACE O TOD='BA7389BBCC0C0002'X TDATE = X'000000000000000000' ADDRESS LINKPGM "BLSUXTOD TOD TDATE" PARSE VALUE TDATE WITH MM "/" DD "/" YY HR ":" MIN ":" SEC SAY TDATE EXIT<br><br>It gives the same result of a previous post (useful as well). I use it for 'decoding' SMF/GTF header timestamp [...]
15345 177 31_Re: DSN1COPY -- for replication0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 11 Dec 2003 08:30:55 -0800369_- Man how can I get one of those CIO jobs, they seem pretty bullet proof from changes in technology. Would my 20 years as a real programmer handicap me? cliff:-o<br><br>-----Original Message----- From: Duane Lee - EGOVX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: Wednesday, December 10, 2003 5:01 PM To: DB2-L@www.idugdb2-l.org Subject: Re: DSN1COPY -- for replication [...]
15523 28 14_DB2 Replicator11_Mike Fatula22_mfatula@AESSUCCESS.ORG31_Thu, 11 Dec 2003 11:39:58 -0500339_us-ascii Hi:<br><br>I working with the Replicator to see if I'm able to perform the tasks our company run nightly using batch jobs to build our warehouses. I have the Replicator working in a test environment. I'm able to capture changes made on one database and have the changes reflected to another database I'll call the warehouse. [...]
15552 111 46_Bad performance - cannot pinpoint problem area13_Vickers, Mark22_Mark.Vickers@ANICO.COM31_Thu, 11 Dec 2003 10:56:53 -0600546_iso-8859-1 We have a data warehouse update job which we think is performing badly. I will apologize in advance for the length of this, but I am trying to answer all the obvious questions up front (like, Is the power on ?).<br><br>We have DB2 v7 running on IBM T-Rex.<br><br>The batch program is doing 1,7 million selects only using all 9 columns of the index (there are only another 5 columns of data - I know that is excessive, but being a data mart, some of the tables are de-normalized. There is only one index, which is the primary key, [...]
15664 175 31_Re: DSN1COPY -- for replication12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 11 Dec 2003 09:02:02 -0800326_us-ascii Hi Cliff- It's not a problem being a CIO if you're willing to forget everything you've learned, and give up wearing shorts for a suit and tie. And you'll have to quit using acronyms like DB2 and CICS in favor of muddled business-speak. You need to include as many catch phrases as possible into every statement. [...]
15840 48 24_Re: Log Record Timestamp0_26_Fatima.Osorio@BPORTUGAL.PT31_Thu, 11 Dec 2003 16:44:31 +0000700_iso-8859-1 Thank you.<br><br>Fatima<br><br>*************************************************************************** AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros eventualmente anexos, é confidencial e reservada apenas ao conhecimento da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo e proceda à sua destruição, notificando o remetente. LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação por via electrónica não pode ser garantida pelo remetente, o qual, em consequência, não se responsabiliza por qualquer facto susceptível de afectar a sua integridade. [...]
15889 166 50_Re: Bad performance - cannot pinpoint problem area12_michael bell24_mbell11@WORLDNET.ATT.NET31_Thu, 11 Dec 2003 11:29:09 -0600444_iso-8859-1 your symptoms look exactly like death by IO. The clues are 1. 4M getpages for 1.7 M Selects (if the next select was close to the previous index key values, index lookaside would bypass most of the getpages). 2. 1M sync IOs 3. 6M pages read by prefetch<br><br>probable causes are one or both of the sequence issues 1. the sequence of the logic that drives the selects 2. the cluster ration of the index - what does runstats show [...]
16056 179 50_Re: Bad performance - cannot pinpoint problem area0_28_Missy.Case@FIRSTDATACORP.COM31_Thu, 11 Dec 2003 11:35:52 -0600547_US-ASCII Mark, I would first check your bufferpools. Separate the objects into a pool or pair of pools so you can see what kind of pool hits you're getting. Which, if any, thresholds you're hitting. What kind of read to IO ratio you're getting, your page residency rate on the shared pools may be getting you. Personally, I'd put the index(es) into one pool & the tablespace into another. Make sure the batch access is coming to DB2 in the same as the cluster index, this will give you better prefetch page usage & overall batch performance. [...]
16236 63 31_Re: DSN1COPY -- for replication12_Weigend, Don17_DWeigend@WBMI.COM31_Thu, 11 Dec 2003 12:33:54 -0600436_us-ascii Well said, and it rings so true.<br><br>Don Weigend DB2 OS/390 Sysprog IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 West Bend Mutual Insurance Company<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of tim malamphy Sent: Thursday, December 11, 2003 11:02 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: DSN1COPY -- for replication [...]
16300 140 50_Re: Bad performance - cannot pinpoint problem area7_Carol G20_carolg01@COMCAST.NET31_Thu, 11 Dec 2003 13:39:13 -0500564_iso-8859-1 Are you sure you are getting Stats on all the columns in the index. We had a similiar problem also. I would definitely check that. Are your bufferpools big enough or are you overflowing the bufferpools? Is the tablespace and index in a different bufferpool?<br><br><br><br>Regards, Carol<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Vickers, Mark Sent: Thursday, December 11, 2003 11:57 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Bad performance - cannot pinpoint problem area [...]
16441 273 30_Re: Recovery question DB2 Z/OS13_Larry Holford27_LHOLFORD@NYSTRS.STATE.NY.US31_Thu, 11 Dec 2003 13:54:43 -0500546_iso-8859-1 Thanks you so much for all your help, I got the table back.<br><br>Larry<br><br>-----Original Message----- From: paul.a.redhead@TRANSPORT.QLD.GOV.AU [mailto:paul.a.redhead@TRANSPORT.QLD.GOV.AU] Sent: Thursday, December 11, 2003 12:17 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Recovery question DB2 Z/OS<br><br><br><br>Larry, I think I understand you basically saying that you (a) Took an Image Copy of the tablespace (FULL I hope) (b) via software dropped and recreated the table in the tablespace (c) recovered the tablespace. [...]
16715 76 24_Re: Log Record Timestamp0_26_Fatima.Osorio@BPORTUGAL.PT31_Thu, 11 Dec 2003 16:44:31 +0000700_iso-8859-1 Thank you.<br><br>Fatima<br><br>*************************************************************************** AVISO DE CONFIDENCIALIDADE: Esta mensagem, assim como os ficheiros eventualmente anexos, é confidencial e reservada apenas ao conhecimento da(s) pessoa(s) nela indicada(s) como destinatária(s). Se não é o seu destinatário, solicitamos que não faça qualquer uso do respectivo conteúdo e proceda à sua destruição, notificando o remetente. LIMITAÇÃO DE RESPONSABILIDADE: A segurança da transmissão de informação por via electrónica não pode ser garantida pelo remetente, o qual, em consequência, não se responsabiliza por qualquer facto susceptível de afectar a sua integridade. [...]
16792 183 31_Re: DSN1COPY -- for replication12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 11 Dec 2003 09:02:02 -0800326_us-ascii Hi Cliff- It's not a problem being a CIO if you're willing to forget everything you've learned, and give up wearing shorts for a suit and tie. And you'll have to quit using acronyms like DB2 and CICS in favor of muddled business-speak. You need to include as many catch phrases as possible into every statement. [...]
16976 36 14_DB2 Replicator11_Mike Fatula22_mfatula@AESSUCCESS.ORG31_Thu, 11 Dec 2003 11:39:58 -0500339_us-ascii Hi:<br><br>I working with the Replicator to see if I'm able to perform the tasks our company run nightly using batch jobs to build our warehouses. I have the Replicator working in a test environment. I'm able to capture changes made on one database and have the changes reflected to another database I'll call the warehouse. [...]
17013 21 28_bufferpool not starting up..17_Chidambaram, Thol24_Thol.Chidambaram@AIG.COM31_Thu, 11 Dec 2003 14:48:23 -0500369_iso-8859-1 Hi Listers,<br><br>We are running DB2 7.2 in Solaris 64-bit. I'm frequently encountering memory allocation problems in different databases. Database starts up with default pools with warning message (1478W). I checked the bufferpools files and they are fine. Can you please let me know any suggestions for this problem.<br><br>Thanks for the help, Thol [...]
17035 90 49_Re: [DB2-L ZOS] Monitor Tools which use Wall Time12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 11 Dec 2003 12:56:56 -0800485_us-ascii Don, You must set QUERYTIMEOUTINTERVAL=0 in your DB2CLI.INI file found in SQLLIB whereever you put DB2 Connect. It must be set explicity there and cannot be set any other way.<br><br>INTERRUPT_ENABLED can be set via DCS commands. Or you can take the easy way and if you've defined your DB2 Connect OS/390 connection as physically residing on a host, you can set it using CCA, under HOST or AS/400 options. "Disconnect if client generates an interrupt(INTERRUPT_ENABLED). [...]
17126 210 50_Re: Bad performance - cannot pinpoint problem area13_Vickers, Mark22_Mark.Vickers@ANICO.COM31_Thu, 11 Dec 2003 15:13:16 -0600504_iso-8859-1 Bob, 1. No partitioning. Packages and Plans have degree(1).<br><br>2. Buffer Pools (Data Warehouse has their own): POOL VP HP ID SIZE SIZE Data: BP6 7,760 13,700 Index: BP7 7,688 17,100<br><br>3. REOPTVAR = no<br><br>Thanks for your help. Mark.<br><br><br><br>-----Original Message----- From: bob_yoder@illinoispower.com [mailto:bob_yoder@illinoispower.com] Sent: Thursday, December 11, 2003 11:28 AM To: Mark.Vickers@ANICO.COM Subject: Re: Bad performance - cannot pinpoint problem area [...]
17337 251 50_Re: Bad performance - cannot pinpoint problem area12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 11 Dec 2003 13:28:28 -0800596_us-ascii Mark, Some of the numbers from the buffer pool stats concern me. You're saying you get 9 column index match on the explain. Yet, you're seeing roughly 2.5 getpages per every SELECT. 1700k selects versus 4300k getpages. And you're doing a Sync read for almost every single SELECT. Again 1000k sync reads versus 1700k SELECTs. And this doesn't count all the prefetches. That implies to me that essentially for every single select, you are doing random physical I/Os. Confirmed by your buffer hit ratio of 0. So that means you'll be spending the vast majority of your time waiting for [...]
17589 324 50_Re: Bad performance - cannot pinpoint problem area14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 11 Dec 2003 16:47:29 -0500533_ISO-8859-1 Really need a lot more data here.<br><br>You have an index with nine cols, you are matching on all nine, and doing an index "scan"? Understand that this is a warehouse, but then this is still a pretty poor index.<br><br>How many other objects are in the same pools as this index and data? What do the overall pools stats look like, I/O rate, etc. The data you sent shows a VP hit of 0% and HP hit at 100% Certainly can be, but not terribly logical to expect all the referenced pages to have migrated to the HP. Maybe [...]
17914 44 30_Re: three part name in queries14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 12 Dec 2003 08:02:08 +1000635_US-ASCII Have a look at DB2 Information Integrator Classic Federation for z/OS, might do the trick:<br><br>http://www-306.ibm.com/software/data/integration/iicf/<br><br><br><br>James Campbell<br><br>On 9 Dec 2003 at 16:40, Srini S Rajan wrote:<br><br>> all > > when i tried to use three part names to compare objects between sub > systems, > > using the following query: > > SELECT NAME, DBNAME FROM SYSIBM.SYSTABLES A > WHERE A.NAME NOT IN (SELECT B.NAME FROM rem1.SYSIBM.SYSTABLES B) > WITH UR; > > I get the following error > SQLCODE = -512, ERROR: STATEMENT REFERENCE TO REMOTE OBJECT IS > INVALID > > Is there any workaround [...]
17959 141 31_RV: Timeout when SERVER is down13_Horacio Villa17_hvilla@AR.IBM.COM31_Thu, 11 Dec 2003 19:18:30 -0300516_US-ASCII Hi,<br><br>thanks to all who responded to my question. We've decided to put a flag in CICS. When CICS starts, a transaction from PLT will check the connection. If it's OK it sets the flag to OK and terminates. All the programs will check the flag. The first one to find the connection is down will start the transaction in background, which will set the flag to "NOT OK" and call itself every n minutes to check again. When it finds the connection is up again, it will set the OK flag and go to sleep. [...]
18101 84 50_Re: Bad performance - cannot pinpoint problem area13_Vickers, Mark22_Mark.Vickers@ANICO.COM31_Thu, 11 Dec 2003 16:38:21 -0600269_iso-8859-1 To everyone who responded, Thank you, so far. I am going to try to answer all the pertinent questions herein as I am out tomorrow and do not want to appear ungrateful for your time. I will be sure to copy all respondents as soon as I get this resolved. [...]
18186 88 53_Re: DB2 z/OS V7 - Identity columns and MAXASSIGNEDVAL14_Matthews, John25_JMatthews@MEDNET.UCLA.EDU31_Thu, 11 Dec 2003 16:03:41 -0800402_- I thought I had heard from Roger Miller that IBM had decided to take the approach of NOT retrofitting new features in old releases. New features would only be in new releases.<br><br>-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Wednesday, December 10, 2003 4:01 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: DB2 z/OS V7 - Identity columns and MAXASSIGNEDVAL [...]
18275 19 31_Re: DSN1COPY -- for replication13_Srini S Rajan37_srinivasan.x.sundararajan@VERIZON.COM31_Fri, 12 Dec 2003 11:24:44 +0530716_us-ascii I could not understand, why a CIO thinks a person who drives a semi truck cannot drive a car. Transition should be so easy. IMS principles maps to XML. Stateless CICS programming maps to ASP.net.<br><br>Srini S Rajan (Known As Sundar)<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG [...]
18295 25 31_Re: DSN1COPY -- for replication0_16_mscarpa@CESVE.IT31_Fri, 12 Dec 2003 08:54:54 +0100444_us-ascii I'd like to know how they think it's more productive to move to cheaper machine like WIN2000 or SQL SERVER<br><br>Here 2 sysprogs manage a mainframe and a lot of data and other things with minimal outage while in the same time time 2 sysprogs plus some programmers are unable to tune only 1 (one) application in a decent manner on SQL Server, with a lot and prolonged outages. And licence fees are NOT so cheap for only 1 server. [...]
18321 12 3_DB28_S. Kumar29_kumar.x.sivarajan@VERIZON.COM31_Fri, 12 Dec 2003 02:35:11 -0600606_- HAI<br><br>can any one know about any function in db2 on z/OS to identify nth value?<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
18334 25 21_Getting Secondary Ids13_Srini S Rajan37_srinivasan.x.sundararajan@VERIZON.COM31_Fri, 12 Dec 2003 14:23:09 +0530367_us-ascii Dear group,<br><br>How can I find the secondary ids for a given primary id. I want to find all the access rights of a user (given to his primary or secondary ids), but I dont find any catalog tables linking the primary ids and secondary id.<br><br>If it is stored outside in RACF, how can I access that information from JDBC or other client interfaces. [...]
18360 59 7_Re: DB225_Sorensen Henrik (KAFC 21)33_henrik.sorensen@CREDIT-SUISSE.COM31_Fri, 12 Dec 2003 10:47:32 +0100409_ISO-8859-1 On z/OS, DB2 V7<br><br>I wrote a UDF, that returns an increasing number each time it gets invoked.<br><br>That way, you can write queries like this:<br><br>SELECT ID,N# FROM ( SELECT ID,UDF.COUNTER(1) AS N# FROM mytable GROUP BY ID ) AS MYTB WHERE MOD(N#,10000)=0<br><br>ID N# --- ---------- S0A 10000 S0B 20000 S0C 30000 S0D 40000 S0E 50000 S0F 60000 S0G 70000 S0H 80000 S0I 90000 S0J 100000 [...]
18420 78 32_Re: bufferpool not starting up..26_Dell'Anno, Aurora Emanuela33_Aurora.DellAnno@BANKOFAMERICA.COM31_Fri, 12 Dec 2003 10:52:44 -0000359_- Hi Thol,<br><br>This is normally related to the fact that you do not have enough real storage to back up your bufferpool size definition, or that the total size of your BP's exceeds your real storage - same difference as far as you are concerned.<br><br>Resize one or all BPs, to be within your machine's limit and you will see the messages disappear. [...]
18499 17 35_rexx implicitely commits when error9_nguyen dt30_duc.nguyen@EUROCLEARFRANCE.COM31_Fri, 12 Dec 2003 05:03:19 -0600702_- Hi all ,<br><br>I am developing an utility with rexx, how to change my rexx to not commit the changes when it encountered a syntax error ? Is there any way to trap the error condition and execute a special function before leaving<br><br>thank you<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out [...]
18517 32 39_Re: rexx implicitely commits when error15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Fri, 12 Dec 2003 13:12:17 +0200328_us-ascii On Fri, 12 Dec 2003 05:03:19 -0600 nguyen dt <duc.nguyen@EUROCLEARFRANCE.COM> wrote:<br><br>:>I am developing an utility with rexx, how to change my rexx to not commit :>the changes when it encountered a syntax error ? :>Is there any way to trap the error condition and execute a special function :>before leaving [...]
18550 187 39_Re: rexx implicitely commits when error14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 12 Dec 2003 11:29:20 -0000493_iso-8859-1 In your rexx, put a SIGNAL ON SYNTAX statement (or a CALL ON SYNTAX statement), also supplying a procedure...<br><br>SYNTAX: ADDRESS DSNREXX "EXECSQL ROLLBACK" . . . RETURN<br><br>Marcus Davage CEng MBCS IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration for UNIX, Linux, Windows and OS/2 DB2 UDB V7.1 Database Administration for OS/390 'The views expressed are my own and do not necessarily represent the views or policy of my employer, Lloyds TSB Bank plc.' [...]
18738 50 31_Re: DSN1COPY -- for replication12_Weigend, Don17_DWeigend@WBMI.COM31_Fri, 12 Dec 2003 08:32:53 -0600564_us-ascii Hey, our CIO can not even run a power point without the help of another person. So why would you think they would understand that the transition would be easy.<br><br>Don Weigend DB2 OS/390 Sysprog IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 West Bend Mutual Insurance Company<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Srini S Rajan Sent: Thursday, December 11, 2003 11:55 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: DSN1COPY -- for replication [...]
18789 78 32_Replication to Remote Databases.16_Sreedhar Bobbadi24_sbobbadi@DUKE-ENERGY.COM31_Fri, 12 Dec 2003 10:30:04 -0500316_us-ascii Dear Gurus<br><br>We are using Data Propagator (Ver 7) to replicate data from one DB2 (os/390) Data Sharing group to another. This works like a charm. Recently we started replicating to a remote DB2 (os/390) and I am seeing that this is painfully slow. The following is mainview elapse time analysis : [...]
18868 76 47_Question re: utility suite for DB2 V7 on OS/3900_29_Tina.Hilton@ARVATOSYSTEMS.COM31_Fri, 12 Dec 2003 10:58:01 -0500584_- I know that IBM now only sells the full utility suite, but has anyone only purchased either of the smaller packages (diagnostic & recovery, operational utilities)? We'd brought V7 in on trial, but haven't actually purchased it yet. We had ordered only the diagnostic & recovery package since we had everything else covered with BMC utilities. In explaining why we now have to buy the full utility suite, IBM says they don't have ANY customers who didn't buy the utility suite. They also claim that the full utility suite was required in order to even run V7 (even though we've [...]
18945 177 51_Re: Question re: utility suite for DB2 V7 on OS/39014_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 12 Dec 2003 16:09:47 -0000406_iso-8859-1 Hi Tina,<br><br>To answer your question another way, there ARE CA customers using ONLY CA utilities, so obviously not everyone bought the V7 suite<br><br>On the other hand, since IBM put RUNSTATS in one half and MODIFY STATISTICS in the other, it did make sense for anyone considering buying any of the IBM utilities to buy them all and not just half of them - maybe that's what they meant [...]
19123 47 21_DB2 Training for 200424_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Fri, 12 Dec 2003 11:16:03 -0500530_iso-8859-1 The Fillmore Group's schedule of IBM data management software courses is now available for registration. All classes are available * in our Baltimore, USA classroom * via the Internet using our state-of-the-art Distance Learning facility * customized at your location<br><br>We offer courses in DB2 database administration, performance monitoring and tuning, and recovery on one of the most complete ranges of platforms anywhere: z/OS, VSE, VM, Linux, Unix - including the Data Partitioning Feature - and Windows. [...]
19171 47 31_Re: DSN1COPY -- for replication0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 12 Dec 2003 08:15:21 -0800395_- We had a miserable failure with client-server and have since move all of it back to the mainframe. We're looking at moving the server farms to mainframe/linx. So its not all bad news. cliff:-)<br><br>-----Original Message----- From: mscarpa@CESVE.IT [mailto:mscarpa@CESVE.IT] Sent: Thursday, December 11, 2003 11:55 PM To: DB2-L@www.idugdb2-l.org Subject: Re: DSN1COPY -- for replication [...]
19219 44 11_SMPE for V714_Matthews, John25_JMatthews@MEDNET.UCLA.EDU31_Fri, 12 Dec 2003 08:18:05 -0800682_iso-8859-1 Now that the utilities are packaged separately from the base DB2, does it make more sense to include the Utilities FMIDs in the same CSI as the base DB2 or to use separate CSI? I had previously put the optional FMIDs(ODBC,JDBC, etc.) in the same CSI as base DB2.<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached [...]
19264 170 68_Migrating Databases among Platforms(Re: DSN1COPY -- for replication)0_26_Phil.Sevetson@WAKEFERN.COM31_Fri, 12 Dec 2003 11:20:19 -0500413_us-ascii Two years ago, we migrated our Peoplesoft implementation from Oracle/Unix to DB2/OS390; we're migrating another large set of databases from multiple Sybase/AIX servers to a DB2 Data Sharing Group, again on OS390. Our Data Warehouse application is on OS390.<br><br>Don't lose heart, Max.<br><br>--Phil Sevetson Database Administration Wakefern Food Corporation CISD mailto:phil.sevetson@wakefern.com [...]
19435 140 51_Re: Question re: utility suite for DB2 V7 on OS/3900_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 12 Dec 2003 08:27:03 -0800531_- Tina, we have both the utility suite and CA (aka Platinum). Our ODOT agencies use a combination of both, we looked at dropping one of them but the manpower costs of converting all of the batch jobs, training on the products not used before, loss of productivity while staff learn the new products, and weakness in both of the vendors lineup just wasn't worth it to us. It would have been a major project in itself, on top of all the other major projects (see email subject;Re: DSN1COPY -- for replication) we're working on. [...]
19576 97 15_Re: SMPE for V70_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 12 Dec 2003 08:33:45 -0800470_- I toss all DB2 parts into one CSI with no problems, except, be careful with products that use UNIX/HFS. Not being use to that environment I've stomped on production files while applying maintenance. Old dogs can learn new trick, it just takes a while.<br><br>cliff:-)<br><br><br><br><br><br>-----Original Message----- From: Matthews, John [mailto:JMatthews@MEDNET.UCLA.EDU] Sent: Friday, December 12, 2003 8:18 AM To: DB2-L@www.idugdb2-l.org Subject: SMPE for V7 [...]
19674 72 22_Incremental Image copy13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Fri, 12 Dec 2003 11:33:31 -0500580_US-ASCII Hi all,<br><br>I am working on a back up plan for all user data in a DB2 subsystem. We are using the IBM utilities for DB2 V7 on z/OS 1.4. I need some options for my back-up plan which I am hoping will include conditional incremental image copies.<br><br>All our current imagecopy backups are fullimage copies so this is my first venture into incremental copies. In doing so I read about incremental copies and conditional copies in the DB2 Utility and Reference Guide. The guide states that the REPORTONLY parameter will signal a return code and that code could be [...]
19747 87 18_Re: DB2 Replicator13_Tom Duerbusch26_DuerbuschT@STLOUISCITY.COM31_Fri, 12 Dec 2003 10:47:11 -0600513_US-ASCII I can't talk about your specific question as it would require a lot more information. But....<br><br>A source table is a table that you want to capture changes from. The manual recommends that, for any particular table that you want to capture, that you capture all data, both before and after image. When the capture program reads the DB2 log it will populate the CD tables (the Changed Data tables) with this information. The CD tables exist on the same database as the source tables are located. [...]
19835 93 51_Re: Question re: utility suite for DB2 V7 on OS/39014_Paul P Packham16_ppackham@CSC.COM31_Fri, 12 Dec 2003 17:01:49 +0000573_us-ascii Tina,<br><br>We are running DB2 v7 in Production and have both the full suite of Utilities from IBM and a number of utilities from BMC. Personally I would not recommend running DB2 without the full suite from IBM. This does not mean that I am unhappy with the BMC products, but third party products do things 'in their own way' and sometimes the results are not always what is expected. For example we run a lot of SAP BW with DB2 as he back end database, these application would not perform without running IBM's Runstats, BMC's equivalent product just does [...]
19929 46 49_SQLCODE +535 for positioned update of primary key12_Don Fleisher23_donfleisher@HOTMAIL.COM31_Fri, 12 Dec 2003 11:08:24 -0600360_- I have a COBOL/DB2 program which performs positioned update of one of the primary key columns in table (table1). The cursor declaration and statements used to perform the UPDATE are listed below. The table being updated does not have any RI, is neither a parent nor a child and does not contain self referencing relationships. The version of DB2 is V7. [...]
19976 167 31_Re: DSN1COPY -- for replication0_21_Nam_Wu@PEOPLESOFT.COM31_Fri, 12 Dec 2003 09:19:20 -0800546_us-ascii Hi Duane,<br><br>I really appreciate your help in this matter! I would love to see the script you had written to handle the DSN1COPY. You can send it to either the DB2-L distribution list or to me personally. Thanks, once again.<br><br>Nam<br><br><br><br>PS, I sent you an email offline. . .<br><br><br><br><br><br><br><br><br><br><br><br><br><br>"Duane Lee - EGOVX" <DLee@MAIL.MARICOPA.GOV> Sent by: "DB2 Data Base Discussion List" <DB2-L@IDUGDB2-L.ORG> 12/10/2003 05:00 PM Please respond to "DB2 Database Discussion list at IDUG" [...]
20144 14 39_Re: rexx implicitely commits when error0_18_jaruddy@US.IBM.COM31_Fri, 12 Dec 2003 11:39:00 -0600657_- If you are talking about the IBM DSNREXX interface it does not do a commit on a syntax error.<br><br>Jim Ruddy DB2 for z/OS Development<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
20159 71 53_Re: SQLCODE +535 for positioned update of primary key0_28_Dale.Smock@ARVATOSYSTEMS.COM31_Fri, 12 Dec 2003 13:27:16 -0500446_iso-8859-1 If it is a partitioned table that you are updating the partitioning key, there is a zparm parameter PARTKEYU of Yes, No, or Same to allow or disallow updates of partitioning key values.<br><br>Dale Smock Bertelsmann<br><br>-----Original Message----- From: Don Fleisher [mailto:donfleisher@HOTMAIL.COM] Sent: Friday, December 12, 2003 12:08 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: SQLCODE +535 for positioned update of primary key [...]
20231 11 53_Re: DB2 z/OS V7 - Identity columns and MAXASSIGNEDVAL14_Ben Eisenstein22_beisenstein@THEOCC.COM31_Fri, 12 Dec 2003 12:53:44 -0600686_- I tried using REPAIR and you are able to update the MAXASSIGNEDVAL. The problem is CACHE. I haven't figured out how to flush it out. It continues to use the values in memory. I tried a QUIESCE and that had no effect.<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on [...]
20243 155 51_Re: Question re: utility suite for DB2 V7 on OS/39013_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Fri, 12 Dec 2003 11:10:41 -0800549_iso-8859-1 I'm sorry to hear IBM has dropped the option to buy just the diagnostic & recovery suite. We are going to upgrade to V7 without the IBM tools (using CA instead), but we were still trying to convince our management to buy the IBM package to obtain Modify Recovery, because the CA version is not all there yet (and they won't give a hint at when it will be!). We'll have a lot tougher time at that now, especially since we've already begun converting our COPY, LOAD, and RUNSTATS jobs over to the CA versions -- after all that effort, [...]
20399 194 53_Re: SQLCODE +535 for positioned update of primary key11_David Nance16_DWNance@FHSC.COM31_Fri, 12 Dec 2003 14:30:03 -0500489_US-ASCII Don, You are recieving a positive SQLcode which is a warning to you. It does not fail the bind, as you stated below you recieved a condition code pf 04. Take a look in your job's output to see if the words bind sucessful exist or not. From the book +535 THE RESULT OF THE POSITIONED UPDATE OR DELETE MAY DEPEND ON THE ORDER OF THE ROWS Means that you have to ensure your SQL is written correctly to ensure after you change the key you don't see the row in your cursor again. [...]
20594 18 54_Need more info on overhead associated with audit trace18_Sandra Lakenburger34_sandra.lakenburger@MAIL.SPRINT.COM31_Fri, 12 Dec 2003 14:13:45 -0600567_- I'm looking for information on the overhead associated with the various audit trace classes for DB2 running on z/OS. I saw a posting early this year where Roger Miller referred to a capacity class that Akira Shibamiya gave at one of the recent tech conferences. I'd be interested in looking at it as well as any comments about experiences that anyone might want to share. We currently only have Audit classes 1 and 2 started, but may want to look at turning others on as well in conjunction with plans to outsource some of our application and DBA work. Thanks [...]
20613 28 72_Re: Migrating Databases among Platforms(Re: DSN1COPY -- for replication)0_16_mscarpa@CESVE.IT31_Fri, 12 Dec 2003 21:22:40 +0100570_us-ascii Phil, Maurice<br><br>Thank you for your reply and pardon my 'vent' even if it's based on real data and real co$t$ I see (almost) every day, not on marketing people's tall stories. Your experiences are rays of sun in a dark sky.<br><br>The problem is (at least from what I saw) that many managers now came from this cheap machine experience and for them mainframe is an obsolete and dying machine, even if in many cases it's tested that you have savings in many area (other than $$$$). And I don't understand why some prefere a SUN mainframe (for instance) [...]
20642 167 29_REXX Freeware aka open source0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 12 Dec 2003 15:17:52 -0800301_- I put a REXX together to help me with managing my DB2 3390 DASD. I'm willing to share. If you would like a copy send me an email. I'll send a copy to Phil when he get the list documents up and running. Below is an output sample.<br><br>No salesman will call and it won't add inches... cliff:-) [...]
20810 25 41_DB2 DBA- Job Opportunity in Washington DC10_Remi Mohan21_pleniumcorp@YAHOO.COM31_Fri, 12 Dec 2003 20:46:52 -0600434_- We have urgent requirements for DB2 DBA on OS/390 for positions in Washington,DC metro area for our direct client. Pay is approximately $57/hour.<br><br>This is a government contracting opportunity. Duration of the project is indefinite. If you are interested please send us a copy of your resume to PLENIUMCORP@YAHOO.COM<br><br>Also please let us know if you have any friend/colleague with these skills who may be interested. [...]
20836 27 39_Re: rexx implicitely commits when error15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Sat, 13 Dec 2003 20:26:41 +0200330_us-ascii On Fri, 12 Dec 2003 11:39:00 -0600 jaruddy@US.IBM.COM wrote:<br><br>:>If you are talking about the IBM DSNREXX interface it does not do a commit :>on a syntax error.<br><br>If it terminates normally without indicating an abend to MVS and without issuing a ROLLBACK then MVS task-end will implicitly do the COMMIT.<br><br>
20864 75 39_Re: rexx implicitely commits when error13_Michael Ebert18_mebert@AMADEUS.NET31_Sat, 13 Dec 2003 19:48:54 +0100366_us-ascii .... and, as we learned in the recent thread "How to end a REXX step with an Abend", you can't abend a REXX step, even by calling e.g. the ILBOABN0 abend routine (there's also an assembler ABEND Macro; I haven't tried calling that - it seems it is the only chance). So it seems you have to catch all errors within REXX and issue a ROLLBACK explicitly. [...]
20940 45 29_DB2 V7 DSNJU004 output format0_19_DB2Automate@AOL.COM29_Sat, 13 Dec 2003 14:36:42 EST702_US-ASCII Hi List, The output format of the DSNJU004 changed in DB2 V7 put maint 0310 or did it change with DB2 V7. Any IBM PTFs to put it back to the old output format. Anyone having problems with the above condition?<br><br>Regards, Ed.<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest [...]
20986 70 33_Re: DB2 V7 DSNJU004 output format0_17_JTonchick@AOL.COM29_Sat, 13 Dec 2003 18:39:07 EST552_US-ASCII I don't think that IBM will apar a report format just because they moved a column, changed a heading, or added a blank line. There has to be a different reason such as, data is missing, or reported incorrectly. If you have a program or REXX parsing the report for some other reason and now your routine can't correctly parse the new report format, start coding. What you have is a "user modification," or as they are known to SMP/E, a USERMOD. IBM does not support usermods. It's kind of like when you change the engine in your Civic for [...]
21057 22 25_GET PAGES/SYNCH I/O RATIO10_cass cheng11_cass@DR.COM31_Sat, 13 Dec 2003 23:46:54 -0500
21080 45 25_Re: Getting Secondary Ids14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 14 Dec 2003 20:01:15 +1000311_US-ASCII The secondary-ids a user has is determined by the logon exit (sign-on exit for CICS and IMS). This normally copies the RACF group-ids a user is connected to to the list of secondary-ids. It need not - it may do whatever it likes. The ACF/2 version of this exit gets the list using ACF principles. [...]
21126 16 50_Re: Bad performance - cannot pinpoint problem area17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Sun, 14 Dec 2003 09:09:17 -0600714_- I am looking at this thread rather late. SQL access path is usually responsible for the heavy random i/o. Is the SQL tuned?. Poor cluster ratio, access by fat indexes, matching on low cardinality cols on index are usual reasons. Regards, Venkat<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to listserv@www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on [...]
21143 41 29_Re: GET PAGES/SYNCH I/O RATIO17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Sun, 14 Dec 2003 10:42:38 -0600532_- The cause is usually bad access path / pool placement. Poor cluster ratio, low cardinality on matching columns, improper join sequence, access by a fat index etc are usual candidates.<br><br>Sync read is bad because you are reading page by page. When the thread is waiting too much for I/O to complete, it could exacerbate into other problems in a busy system. I/O may have been signaled complete. The thread is dispatched again. The page should be in the buffer. It may have been stolen already. You end up doing I/O again. [...]
21185 23 25_Re: Getting Secondary Ids17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Sun, 14 Dec 2003 10:53:24 -0600542_- Write your own RACF macro to get all valid groups. A list can also be obtained from address space extension block. Look at the delivered programs DSN3SATH, in SDSNSAMP for pointers. I don't think that will work in a distributed java environment. I remember to have seen a FRACLINK general purpose ASM routine on the net. Check planet MVS. You may see some code that you can modify. What is your actual need?. If you knwe the group upfront, Why not just do a SET and if it fails you know that that is not a valid group!!.Not pretty but [...]
21209 49 25_AW: Getting Secondary Ids33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Mon, 15 Dec 2003 02:54:31 +0100401_iso-8859-1 You can code a stored proc (assembler) to run in an APF enabled environment to return all the secondary ids. Another way might be LDAP<br><br>Roland<br><br>-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Srini S Rajan Gesendet: Freitag, 12. Dezember 2003 09:53 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Getting Secondary Ids [...]