1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2003, week 4
2 35 19_Valid vs. Operative41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Thu, 22 May 2003 09:02:16 +0200641_iso-8859-1 Fellow Listers,<br><br>in our shop we have a little REXX that checks SYSIBM.SYSPACKAGE for packages with OPERATIVE = "N" or VALID = "N" and produces Rebind-Commands or Free-Commands accordingly. For some time now I have been wondering why the REXX no longer produced any FREE-Statements. So today I changed a table dropping a column and rebound the dependent packages. The Rebind showed the expected results (SQLCODE -206) but still OPERATIVE remains "Y". I'm pretty certain that in olden days OPERATIVE was switched to "N" and we would have gotten FREE-Commands instead of REBIND-Commands from every re-run of the REXX, but [...]
38 179 64_DB2V7 LOAD 254 part table using dynamic allocation via templates31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL31_Thu, 22 May 2003 09:18:43 +0200486_US-ASCII Dear list,<br><br>I ran a DB2V7 LOAD on a 254 part table. The job abended with the underlying message.<br><br>DSNU1015I DSNUGDYN - ERROR ALLOCATING DATA SET DSN=ODAS.ONT.DRT254.DRT254.P00114.FOUT CODE=X'02380000' DSNU1042I DSNUGDYN - START OF IDCAMS MESSAGES IKJ56220I DATA SET ODAS.ONT.DRT254.DRT254.P00114.FOUT NOT ALLOCATED, TOO MANY DATA SETS+ IKJ56220I MAXIMUM NUMBER OF DATA SET ALLOCATIONS ALLOWED BY YOUR SESSION HAS BEEN REACHED, YOU SHOULD FREE UNUSED DATA SETS [...]
218 43 68_Re: DB2V7 LOAD 254 part table using dynamic allocation via templates15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Thu, 22 May 2003 10:49:53 +0300596_us-ascii On Thu, 22 May 2003 09:18:43 +0200 "Douwe van Sluis, Infodemic B.V." <d.b.van.sluis@INFODEMIC.NL> wrote:<br><br>:>I ran a DB2V7 LOAD on a 254 part table. The job abended with the :>underlying message.<br><br>:>DSNU1015I DSNUGDYN - ERROR ALLOCATING DATA SET :>DSN=ODAS.ONT.DRT254.DRT254.P00114.FOUT CODE=X'02380000' :>DSNU1042I DSNUGDYN - START OF IDCAMS MESSAGES :>IKJ56220I DATA SET ODAS.ONT.DRT254.DRT254.P00114.FOUT NOT ALLOCATED, TOO :>MANY DATA SETS+ IKJ56220I MAXIMUM NUMBER OF DATA SET ALLOCATIONS ALLOWED :>BY YOUR SESSION HAS BEEN REACHED, YOU SHOULD FREE UNUSED DATA SETS [...]
262 49 18_Re: Image copy B3715_Steve McAuliffe35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Thu, 22 May 2003 08:50:55 +0100350_- Many thanks for the replies, now I've had a chance to sit down and have a more thorough plough through the manual, I found what I was looking for under the description for the template.<br><br>DB2 will quite happily go a bit wild with the primary allocations so there are controls within the template to hit it with a mallet and calm it down. [...]
312 22 29_Re: DDL extraction for Table.11_The Useless16_mscarpa@CESVE.IT31_Thu, 22 May 2003 09:47:08 +0200537_us-ascii Hi<br><br>BMC Catalog Manager is quite good for DDL extraction and for building application for DB2 management if you know, for example, REXX.<br><br>AFAIK it' s the best product for doing that. My opinion, of course.<br><br>Regards<br><br>Max Scarpa (NOT working for BMC)<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
335 26 22_'Scratched' from DB2-L11_The Useless16_mscarpa@CESVE.IT31_Thu, 22 May 2003 09:57:30 +0200452_us-ascii Estimeed listers<br><br>It's the second time in a week that my subscription to DB2-L is 'scratched' as, according DB2-L server, my account doesn't exist and for 14 times the server received wrong replies from our mail server.<br><br>Did this thing happen to any other lister ? The strange thing is that my subscription to IBM-MAIN continues to work without any problem with our mail server and I continue to receive their mail regularly. [...]
362 31 19_image copy question17_Kathleen S. Jones26_ksjones2@INTERACT.CCSD.NET31_Thu, 22 May 2003 01:07:03 -0700540_ISO-8859-1 I had an image copy job abend two nights ago with a stopped tablespace. I fixed the tablespace and terminated the utility. When the operators went to run it tonight, DB2 thinks the gdgs from the previous night are being created because DB2 had registered them the first time but CA-JOBTRAC had backed them out when the job was purged after the abend. Is there a way of getting the last gdg out of DB2? The work around I have devised is to create a +2 generation and DB2 allows these to be created and added but then we have [...]
394 77 18_Re: Image copy B3715_Steve McAuliffe35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Thu, 22 May 2003 09:09:01 +0100607_- Having said that I've run another test and am even more confused.<br><br>My JCL is as follows, this time I have in the SPACE controls to force a maximum primary allocation of 500 cylinders.<br><br>//S01APPIC EXEC DSNUPROC,PARM='DP01,IMAGECPY.APBP',COND=(08,LE) //DSNTRACE DD SYSOUT=* //SYSIN DD * LISTDEF COPYAPPL INCLUDE TABLESPACE DCRED001.SCRED28P PARTLEVEL TEMPLATE LOCAL DSN (DB2P01IL.&DB..&TS..P&PART..D&JD..T&HO.&MI.) SPACE CYL MAXPRIME 500 TEMPLATE REMOTE DSN (DB2P01IR.&DB..&TS..P&PART..D&JD..T&HO.&MI.) SPACE CYL MAXPRIME 500 COPY LIST COPYAPPL COPYDDN(LOCAL) RECOVERYDDN(REMOTE) CHECKPAGE [...]
472 38 50_Sanjay Singh/RETAIL/BOIGROUP is out of the office.12_Sanjay Singh24_Sanjay.Singh@BOIMAIL.COM31_Thu, 22 May 2003 09:21:08 +0100341_us-ascii I will be out of the office starting 05/22/2003 09:00:00 AM and will not return until 05/22/2003 05:00:00 PM.<br><br>I will be out of the office from 05/22/2003 9:00:00 and will not return until 05/22/2003 17:00:00.<br><br>For any CIS/LENDING query please contact Frank McLoughlin. I will respond to your message on my return. [...]
511 15 29_Re: DDL extraction for Table.14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Thu, 22 May 2003 03:36:49 -0500316_iso-8859-1 Thanks Max<br><br>Colin Clayton (working for BMC)<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
527 21 18_Re: Image copy B3711_The Useless16_mscarpa@CESVE.IT31_Thu, 22 May 2003 10:37:17 +0200476_us-ascii Hi<br><br>Could you please provide a LISTCAT .....VOLUMES of the seq. dataset and the JESYSMSG (to see if SMS allocates<br><br>correctly) of your job ? Even offline, if you like.<br><br>Regards<br><br>Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
549 178 26_Re: 'Scratched' from DB2-L15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Thu, 22 May 2003 10:51:18 +0200533_iso-8859-1 Hello Max,<br><br>Probably useless to say.. Unfortunately you think of yourself as a nuisance. Sofar I've enjoyed your postings as they very well put. Both technical as well as with humor. I find it it a rare combination in this so often dull world.<br><br>So please 'SPEAK!'<br><br>Kind regards,<br><br>Jaap Slot<br><br><br><br><br><br>-----Oorspronkelijk bericht----- Van: The Useless [mailto:mscarpa@CESVE.IT] Verzonden: donderdag 22 mei 2003 9:58 Aan: DB2-L@LISTSERV.YLASSOC.COM Onderwerp: 'Scratched' from DB2-L [...]
728 66 68_Re: DB2V7 LOAD 254 part table using dynamic allocation via templates31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL31_Thu, 22 May 2003 10:21:29 +0200594_US-ASCII I already tried DYNAMNBR.DSNUPROC=600, and it does not work, which makes sence, DYNAMNBR only reserved space in the TIOT for dynamic allocation, it does not expand the TIOT. DB2 can use a XTIOT but as far as I know a job cannot?<br><br>Vriendelijke groet, Douwe van Sluis, Infodemic B.V.<br><br><br><br>-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] Namens Binyamin Dissen Verzonden: donderdag 22 mei 2003 9:50 Aan: DB2-L@LISTSERV.YLASSOC.COM Onderwerp: Re: DB2V7 LOAD 254 part table using dynamic allocation via templates [...]
795 10 23_Re: Valid vs. Operative33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 22 May 2003 03:52:08 -0500333_- What are your options for VALIDATE and SQLERROR? Are they RUN and CONTINUE?<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
806 37 52_=?iso-8859-1?Q?R=E9f=2E_=3A_'Scratched'_from_DB2-L?=13_Moira Langley26_Moira.LANGLEY@CA-DIALOG.FR31_Thu, 22 May 2003 11:00:17 +0200294_us-ascii Hi Max<br><br>Happened to me at the beginning of the month - 7/8 May? - and after not receiving anything for a day or two I discovered that I was no longer subscribed to DB2-L. At the time I just assumed it was a 'glitch' somewhere so I re-subscribed and it's been OK since then. [...]
844 22 29_Re: DDL extraction for Table.11_The Useless16_mscarpa@CESVE.IT31_Thu, 22 May 2003 11:04:31 +0200594_us-ascii You're welcome.<br><br>After working with 4 (maybe 5) products of that kind, this is my **personal/technical** opinion. And I'm not in awe of expressing it .<br><br>BUT this *doesn't mean* that other product are not good, but it's a 'stimulus' for other vendors to improve their products.<br><br>Regards<br><br>Max 'ghost' Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
867 65 68_Re: DB2V7 LOAD 254 part table using dynamic allocation via templates15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Thu, 22 May 2003 12:23:39 +0300363_us-ascii On Thu, 22 May 2003 10:21:29 +0200 "Douwe van Sluis, Infodemic B.V." <d.b.van.sluis@INFODEMIC.NL> wrote:<br><br>:>I already tried DYNAMNBR.DSNUPROC=600, and it does not work, which makes :>sence, DYNAMNBR only reserved space in the TIOT for dynamic allocation, :>it does not expand the TIOT. DB2 can use a XTIOT but as far as I know a :>job cannot? [...]
933 34 23_Re: Valid vs. Operative41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Thu, 22 May 2003 12:02:15 +0200636_iso-8859-1 Walter,<br><br>SQLERROR(NOPACKAGE) and VALIDATE(BIND)<br><br><br><br><br><br>-----Ursprüngliche Nachricht----- Von: Walter Janißen [mailto:walter.janissen@VICTORIA.DE] Gesendet: Donnerstag, 22. Mai 2003 10:52 An: DB2-L@LISTSERV.YLASSOC.COM Betreff: Re: Valid vs. Operative<br><br><br><br>What are your options for VALIDATE and SQLERROR? Are they RUN and CONTINUE?<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...]
968 10 23_Re: Valid vs. Operative33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 22 May 2003 05:55:43 -0500309_- Strange, very strange. I've no idea, may be a bug??<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
979 94 68_Re: DB2V7 LOAD 254 part table using dynamic allocation via templates31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL31_Thu, 22 May 2003 13:00:37 +0200454_US-ASCII With a ALLOCxx TIOT default size of 32K and using VOLCNT 59 I get to 113 files allocated.<br><br>I tested with a VOLCNT of 5 and 11, both work OK. I need in total 512 files allocated.<br><br>If I use a VOLCNT of 12 the job fails again.<br><br>Here's my calculation (see MVS Initialization and Tuning Reference, ALLOCxx): TIOT of 32K = 32768 bytes TIOT header = 60 bytes Per DD with on volume = 20 bytes Each volume after 1 volume = 4 bytes [...]
1074 157 33_db2move won't move after fixpak 914_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Thu, 22 May 2003 12:00:41 +0100578_iso-8859-1 Hi,<br><br>DB2 UDB 7.2 on Windows NT 4.0 with DB2 connect to DB2 for OS/390 V6.1 on z/OS 1.2.<br><br>I've just put FixPak 9 on my local workstation UDB instance, and all of a sudden, db2move returns the following complaint when I try to export data from the mainframe.<br><br>SQL3104N The Export utility is beginning to export data to file "tab1.ixf". SQL3015N An SQL error "-805" occurred during processing. SQL0805N Package "DB2TPRIME.NULLID.SQLUAD08.4141414141594154" was not found. SQLSTATE=51002 SQL3105N The Export utility has finished exporting "0" rows. [...]
1232 32 27_AW: Re: Valid vs. Operative41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Thu, 22 May 2003 13:29:01 +0200646_iso-8859-1 Walter,<br><br>May I take this as a 'YES' for my assumption that OPERATIVE should have changed to 'N' ?<br><br>-----Ursprüngliche Nachricht----- Von: Walter Janißen [mailto:walter.janissen@VICTORIA.DE] Gesendet: Donnerstag, 22. Mai 2003 12:56 An: DB2-L@LISTSERV.YLASSOC.COM Betreff: Re: Valid vs. Operative<br><br><br><br>Strange, very strange. I've no idea, may be a bug??<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...]
1265 86 14_query quandary12_Fay, Colin M22_cfay@UNUMPROVIDENT.COM31_Thu, 22 May 2003 07:46:31 -0400475_us-ascii At our shop (OS/390 DB2 v6 & v7) we have lots of queries of this type :<br><br>select col1, col2 from T1 taba where col2 = (select max(col2) from T1 tabb where tabb.col1 = taba.col1 )<br><br>Col1, col2 is the primary key and col2 is in descending sequence. Typically col1 is a identity field and col2 is a date and we want to identify the row with the latest date for that identity value. (other predicates and tables are often involved , but I keep it simple) [...]
1352 84 23_Re: image copy question13_Michael Ebert18_mebert@AMADEUS.NET31_Thu, 22 May 2003 13:55:37 +0200621_us-ascii Hi Kathleen,<br><br>we have had exactly the same problem when we introduced ControlM as a job scheduler.... and our JobDoc now states to simply do a temporary change for the GDG number to +2, as you did.<br><br>Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany<br><br><br><br><br><br>I had an image copy job abend two nights ago with a stopped tablespace. I fixed the tablespace and terminated the utility. When the operators went to run it tonight, DB2 thinks the gdgs from the previous night are being created because DB2 had registered them the first time but [...]
1437 163 18_Re: explain output33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 22 May 2003 06:58:09 -0500533_- Grace<br><br>Well, it's not so easy, to explain our procedure in a few sentences. Basically we use some views to generate UPDATE-statements fpr most of the catalog-tables and INSERT-/DELETE-statments for SYSCOLDIST. DSNTIAUL using these views generates the appropriate SQL-statements. This statements are executed by a little REXX.<br><br>One View-example:<br><br>CREATE VIEW DB2.CATUPD1 ( A , B , C , D , E , F , G , H , I , J , K , L , M , N , O ) AS SELECT SUBSTR ( 'UPDATE SYSIBM.SYSTABLES SET CARDF = ' , 1 , 36 ) , CASE [...]
1601 21 7_logging10_Bill Kebea23_Bill.Kebea@WAKEFERN.COM31_Thu, 22 May 2003 08:08:52 -0400543_us-ascii I have a need to update a half billion rows in one of our Datawarehouse tables. Is there a way to turn off logging for an SQL update so I don't start spinning off log tapes?<br><br>Bill Kebea Database Analyst Wakefern Food Corp. Edison, N.J. 732-225-8096 Bill.Kebea@wakefern.com<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1623 54 23_Re: image copy question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 22 May 2003 08:20:34 -0400355_iso-8859-1 +2 gets you past the current problem. Long term, you may want to consider giving the SYSCP* DD statements DISP=(,CATLG,CATLG). That way the GDG gets catalogued to OS/390 even if the IC fails. That way you will avoid the problem of DB2 knowing about the generation, but MVS not knowing. Then all you need to do is -TERM the util and rerun. [...]
1678 47 23_Re: image copy question14_Flatley, Lynne30_Lynne.Flatley@CITYOFBOSTON.GOV31_Thu, 22 May 2003 08:39:33 -0400597_iso-8859-1 Oh the life of a DBA...trial by fire, eh, Kathy? The problem is, that some of the tablespaces *were* copied successfully and recorded in the DB2 catalog. Then, when utility attempted to copy the stopped tablespace, the utility abended so that tablespace was not recorded in SYSCOPY...but *all* the gdgs were uncataloged, even the ones that were successful. Some shops code their image copy JCL as (new,catlg) so that even if the job abends, the good image copies will get catalogued. The one 'bad' one will also get catalogued but it will *not* be recorded as a successful copy in [...]
1726 56 11_Re: logging14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 22 May 2003 13:46:20 +0100341_iso-8859-1 I do like these easy ones<br><br>"NO"<br><br>Also, don't be clever (like I was once) and decide that "I won't ever need all these archive logs, so I'll just get the operators to scratch them as soon as DB2 spins them off". Needless to say, my mega-update bombed and Db2 wanted the archives that I had so cleverly overwritten [...]
1783 51 11_Re: logging14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 22 May 2003 13:47:07 +0100363_iso-8859-1 Just had another thought<br><br>What proportion of the total are you updating? If it's significant, had you thought of unloading, doing the update outside DB2 and then reloading again??<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 [...]
1835 24 23_Re: image copy question11_The Useless16_mscarpa@CESVE.IT31_Thu, 22 May 2003 14:56:21 +0200553_us-ascii Hi Kathy<br><br>Did you finished to stay up late and to carouse (I'm waiting for your big ZOT !) ?<br><br>A small note : pay attention to LIMIT value of GDGs, anyway, to avoid to lose some good ICs if on DASDs due to ROLL-OUT of older GDGs.<br><br>Good night<br><br>Max<br><br>The big 'U'<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1860 62 23_Re: image copy question15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 22 May 2003 09:18:24 -0400468_iso-8859-1 Kathy, I do not know CA-JOBTRAC but some of these systems that will restart by deleting files can have rules defined to *NOT* uncatalog and delete files based on a supplied pattern. I have used this for our DB log and IC files for both IMS and DB2 in ZEKE,ZEBB,ZARA automation products(also UCC-1 and UCC-11 several years ago a former job). This insures that if it is cataloged whether by successful completion or ABEND. Talk to your automation folks. [...]
1923 109 35_Re: Generated Fields and Timestamps0_16_khampto1@TXU.COM31_Thu, 22 May 2003 08:26:48 -0500645_us-ascii Not true, Binyamin, the result of subtracting two timestamps is not itself a timestamp, while it may look like one, it is actually a duration, datatype DECIMAL(20,6). (from the DB2 for OS/390 v6 SQL Reference)<br><br>John, I'm afraid you have to go through some little gyrations in order to get a consistent value for duration out of your calculation. You can try something like: SELECT ( ( DAYS(time_seen_by_doctor) - DAYS(time_arrived) ) * 1440 ) + ( HOUR(time_seen_by_doctor - time_arrived ) * 60 ) + MINUTE(time_seen_by_doctor - time_arrived ) as calc_wait_time , ( ( DAYS(time_left_the_office) - DAYS(time_arrived) ) * 1440 ) [...]
2033 172 56_Help! Query with not null where clause acting strange???0_23_edie.richardson@SRS.GOV31_Thu, 22 May 2003 09:46:07 -0400552_us-ascii We just upgraded to DB2 v7.1 My analyst are saying this query worked correctly before we upgraded. This table has 2.1 million rows and is partitioned. What I don't understand is why when I leave the where cause of 'BUDG_RPT_CD IS NOT NULL ' why no rows are returned. This is part of table layout: VIEW NAME COLUMN NAME COLTYPE LENGTH N SCALE VLDGENT_RPT DB2_PART_NO DECIMAL 2 N 0 DB2_PART_CT DECIMAL 7 N 0 * ACCT_PER_FISC_YR DECIMAL 4 N 0 * ACCT_PER_FISC_MO DECIMAL 2 N 0 * GEN_LDG_CD CHAR 4 N 0 * LDG_ENT_AM DECIMAL 13 N 2 * ORG_MEMO_ID [...]
2206 30 35_Re: Generated Fields and Timestamps15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Thu, 22 May 2003 17:03:05 +0300447_us-ascii On Thu, 22 May 2003 08:26:48 -0500 khampto1@TXU.COM wrote:<br><br>:>Not true, Binyamin, :> the result of subtracting two timestamps is not itself a timestamp, :>while it may look like one, it is actually a duration, datatype :>DECIMAL(20,6). :>(from the DB2 for OS/390 v6 SQL Reference)<br><br>True, not an exact timestamp but for the way it is formatted where one cannot do true arithmetic on this duration it may as well be a timestamp.
2237 42 48_Declared Temporary Tables - Scans of SYSDATABASE11_Jim Addison28_jim_addison@STANDARDLIFE.COM31_Thu, 22 May 2003 15:15:05 +0100404_us-ascii OS390 DB2 V6.1<br><br>We appear to have a performance problem when creating DTTs due to the number of getpages required to find the TEMP database on SYSDATABASE (this is on our development subsystem which has a large number of databases).<br><br>Has anyone any experience of this ?<br><br>We have had a suggestion to create an index on SYSDATABASE which includes TYPE to avoid the problem. [...]
2280 45 38_Re: Executing db2 utilities using JDBC14_Sanders, Roger24_Roger.Sanders@NETAPP.COM31_Thu, 22 May 2003 10:32:15 -0400316_iso-8859-1 It is possible to perform operations like LOAD and IMPORT from an application program, but you must do so by invoking the appropriate Administrative API. I have never called an API from a JAVA program; however, you can call an API from a stored procedure, which can the be invoked by a JAVA program. [...]
2326 197 18_Re: explain output10_Grace Chen20_grace.chen@CELERO.CA31_Thu, 22 May 2003 08:35:08 -0600486_- Walter, Your information is really valuable for us and would like to have the power point presentation. I have a colleague in my office who just immigrate from German. He can interpret it for me. You can send to me or DB2-List. My e-mail address is grace.chen@celero.ca<br><br>Thanks, Grace<br><br>-----Original Message----- From: Walter Jani?en [mailto:walter.janissen@VICTORIA.DE] Sent: Thursday, May 22, 2003 5:58 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: explain output [...]
2524 10 60_Re: Help! Query with not null where clause acting strange???33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 22 May 2003 09:30:22 -0500318_- It seems to be a bug, that the only explanation I can offer.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2535 17 56_Re: =?iso-8859-1?Q?R=E9f=2E_=3A_'Scratched'_from_DB2-L?=11_The Useless16_mscarpa@CESVE.IT31_Thu, 22 May 2003 16:47:10 +0200363_us-ascii Thanks Moira<br><br>Now I know I'm not a 'reject'.....Joking of course, as usual<br><br>Cheers Max<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2553 70 19_access path problem33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 22 May 2003 09:43:14 -0500398_- Hi all<br><br>I have again a curious behaviour of the optimizer. The explain looks like a star join access path, but unformately the JOIN_TYPE column is blank. We are on version 7 (DB2 z/os). ZPARMS are: SJTABLES 10, STARJOIN ENABLE.<br><br>The query is quite complex but basically a join between 5 tables, where 4 small tables are joined to a big table and no join between the small tables [...]
2624 11 52_Re: Declared Temporary Tables - Scans of SYSDATABASE33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 22 May 2003 09:45:40 -0500374_- The name of the database is unique isn't it? regardless of type. So, it seems, that I don't understand your problem.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2636 16 24_FW: Old packages redbook10_Dale Smock28_Dale.Smock@ARVATOSYSTEMS.COM31_Thu, 22 May 2003 09:51:41 -0500414_iso-8859-1 I built a pdf from the old redbook.<br><br>(See attached file: gg244001 DB2 Packages.pdf)<br><br>Roger Miller, DB2 for z/OS ibm.com/software/db2zos<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2653 101 52_Re: Declared Temporary Tables - Scans of SYSDATABASE11_Jim Addison28_jim_addison@STANDARDLIFE.COM31_Thu, 22 May 2003 15:58:32 +0100525_iso-8859-1 The name is unique, but when declared you do not supply the database name - presumably DB2 looks for the database with type T (as there is only one) hence the problem.<br><br>Jim.<br><br><br><br><br><br><br><br>Walter Janißen <walter.janisse To: DB2-L@LISTSERV.YLASSOC.COM n@victoria.de> cc: (bcc: Jim Addison/IS/SLC/StandardLifeGroup) Sent by: bcc: Jim Addison/IS/SLC/StandardLifeGroup DB2 Data Base Subject: Re: Declared Temporary Tables - Scans of SYSDATABASE Discussion List <db2-l@listserv .ylassoc.com> [...]
2755 56 51_A NEW PeopleSoft and IBM White Paper on DB2 Cloning11_Kelly Smith20_kellysm@STARBAND.NET31_Thu, 22 May 2003 08:58:15 -0600377_iso-8859-1 A new White Paper on DB2 cloning, written jointly by PeopleSoft and IBM, is available. This White Paper is titled:<br><br>"Copying a PeopleSoft 8.1 DB2 Subsystem with Mainstar's MS/VCR, using the FlashCopy Function of IBM ESS DASD"<br><br>and describes a joint testing project carried out in the fourth quarter of 2002 by PeopleSoft, IBM and Mainstar Software. [...]
2812 44 29_DB2 connect Version 8 Testing15_Goldberg, Carol26_Carol.Goldberg@ACS-INC.COM31_Thu, 22 May 2003 11:22:27 -0400563_iso-8859-1 We are attempting to test version 8.1 of DB2 Connect with Power BuIlder Version 8 release 9074. When attempting to connect to Powerbuilder we are getting the following errors:<br><br><<...OLE_Obj...>><br><br>In the past this happened because the userid we are using did not have the proper authority to DB2, the userid we are using is a "native" SYSadmin ID. So that emliminates that as a problem. We are now wondering, if this is because we need a patch to Power Builder or what release of Power Builder is compatible with DB2 Connect Version 8. [...]
2857 98 28_Re: FW: Old packages redbook13_Steve Runtsch27_Steve.Runtsch@US.FORTIS.COM31_Thu, 22 May 2003 10:23:57 -0500600_US-ASCII Your pdf didn't make it. Can it be placed in DB2-L-DOCUMENTS@LISTSERV.YLASSOC.COM?<br><br>Steve Runtsch Fortis, Inc.<br><br>>>> Dale.Smock@ARVATOSYSTEMS.COM 5/22/2003 9:51:41 AM >>> I built a pdf from the old redbook.<br><br>(See attached file: gg244001 DB2 Packages.pdf)<br><br>Roger Miller, DB2 for z/OS ibm.com/software/db2zos<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...]
2956 44 41_Help - nice and easy License question ...23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 22 May 2003 16:44:32 +0100550_iso-8859-1 > I have the following information in my License file : > > Product Name = "DB2 Enterprise Edition" > Product Password = "DB2UDBEE" > Version Information = "7.2" > Expiry Date = "Permanent" > Concurrent Connect User Policy = "Disabled" > Registered Connect User Policy = "Disabled" > Enforcement Policy = "Soft Stop" > Number of processors = "4" > Number of licensed processors = "1" > Annotation = "" > Other information = "" > > Will the fact the licenses processors is 1 mean that db2 will use no more > than 1 processor of this 4 [...]
3001 22 14_DB2 V7 IVP trx18_Luscombe John (HS)26_John.Luscombe@CONCORDIA.CH31_Thu, 22 May 2003 17:47:08 +0200534_iso-8859-1 Hi folks,<br><br>Has anyone had problems with the IVP trx D8PP, PS and PT with V7 and CICS TS 2.2? We can get the trx to run once, then upon a second invocation it abends with DFHAP0002 and trace point of x'3255'. Maybe it's a CICS TS problem?<br><br>TIA<br><br>John.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
3024 21 23_Re: image copy question17_Kathleen S. Jones26_ksjones2@INTERACT.CCSD.NET31_Thu, 22 May 2003 08:47:07 -0700329_ISO-8859-1 DB2 Data Base Discussion List <DB2-L@LISTSERV.YLASSOC.COM> writes: >Did you finished to stay up late and to carouse (I'm waiting for your big >ZOT !) ? no, Max, I went back home to bed and now I am sleepy this morning but on the job! And Max keep posting - I am learning so much from you and others on this list. [...]
3046 45 11_Re: logging4_Smit24_robert.erwin.smit@WXS.NL31_Thu, 22 May 2003 05:56:33 +0200711_iso-8859-1 Bill,<br><br>You could create a table with "not logged initialy" if your db2 level knows this statement.<br><br>Regards,<br><br>Robert.<br><br>----- Original Message ----- From: "Bill Kebea" <Bill.Kebea@WAKEFERN.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Thursday, May 22, 2003 2:08 PM Subject: logging<br><br><br><br>> I have a need to update a half billion rows in one of our Datawarehouse > tables. Is there a way to turn off logging for an SQL update so I don't > start spinning off log tapes? > > Bill Kebea > Database Analyst > Wakefern Food Corp. > Edison, N.J. > 732-225-8096 > Bill.Kebea@wakefern.com > > ================================================ [...]
3092 40 23_Re: image copy question17_Kathleen S. Jones26_ksjones2@INTERACT.CCSD.NET31_Thu, 22 May 2003 08:44:57 -0700638_ISO-8859-1 DB2 Data Base Discussion List <DB2-L@LISTSERV.YLASSOC.COM> writes: >Oh the life of a DBA...trial by fire, eh, Kathy? The problem is, that >some >of the tablespaces *were* copied successfully and recorded in the DB2 >catalog. Then, when utility attempted to copy the stopped tablespace, the >utility abended so that tablespace was not recorded in SYSCOPY...but *all* >the gdgs were uncataloged, even the ones that were successful. Some shops >code their image copy JCL as (new,catlg) so that even if the job abends, >the >good image copies will get catalogued. The one 'bad' one will also get >catalogued but it will *not* [...]
3133 210 41_Help - nice and easy License question ...22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Thu, 22 May 2003 11:40:10 -0500649_iso-8859-1 <br><br>It will use all 4, but write out a message to DB2DIAG.LOG<br><br>SQL8017W The number of processors on this machine exceeds the defined entitlement of "x" for the product "DB2 Enterprise Edition". The number of processors on this machine is "y". You should purchase additional processor entitlements from your IBM representative or authorized dealer and update your license using the License Center or the db2licm command line utility. For more information on updating processor licenses, refer to the Quick Beginnings manual for your platform. For more information on the db2licm utility, refer to the DB2 Command Reference. [...]
3344 52 11_Re: logging12_Rohn Solecki19_rohnski@HOTMAIL.COM31_Thu, 22 May 2003 11:30:17 -0500468_iso-8859-1 Since Phil has already mentioned the unload/load LOG NO/Image copy option, the only other choice is to break your update down into smaller segments. Use your portioning/clustering index as the starting point to provide the ranges for the WHERE clause.<br><br>----- Original Message ----- From: "Smit" <robert.erwin.smit@WXS.NL> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Wednesday, May 21, 2003 10:56 PM Subject: Re: logging [...]
3397 232 45_Re: Help - nice and easy License question ...23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 22 May 2003 18:12:09 +0100436_iso-8859-1 great thanks for the info .. yes the book sort of told me this but was not exact about it.<br><br>many thanks all.<br><br>Les<br><br>-----Original Message----- From: Venkatesh Mokshagundam [mailto:Vmokshagun@CSEDGE.COM] Sent: Thursday, May 22, 2003 5:40 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Help - nice and easy License question ...<br><br><br><br><br><br>It will use all 4, but write out a message to DB2DIAG.LOG [...]
3630 123 18_Re: Image copy B370_26_jack.oconnell@MCMASTER.COM31_Thu, 22 May 2003 14:04:23 -0400351_iso-8859-1 PCTPRIME is defaulted to 100% ( 100% of the space is allocated as a PRIMARY quantity. if this amount of space is not available on a single volume, decrease PCTPRIME. ) since you did not specify it. If you are intent on avoiding secondaries, keep PCTPRIME at 100%. It sounds like you want secondaries, so the coding seems inconsistent. [...]
3754 60 51_Nulls Allowed in All Columns except the Primary Key16_HIEGEL Annabelle28_Annabelle.Hiegel@STATE.OR.US31_Thu, 22 May 2003 11:07:02 -0700590_- Nulls allowed in all columns except the primary key is the standard set by our technical architect on a Java/websphere project using DB2 7.2 on Sun Solaris. He says this change is necessary to accommodate websphere which is doing an INSERT statement of the row with only the key value, followed by an UPDATE statement with values for all the other columns. We tried setting the default values for the nulls allowed columns which works with ODBC, but not JDBC. Has anyone else encountered this? Why would websphere work this way? Never having done nulls allowed in all columns except [...]
3815 78 42_Dynamic Allocation of datasets in DSNUPROC12_Matt Harding18_MHarding@AFLAC.COM31_Thu, 22 May 2003 14:10:28 -0400410_iso-8859-1 I want to use IBM's Reorg utility with DB2 version 7. The reorg utility requires DD-statements for sortworks and other datasets. Can the Reorg utility dynamically allocate these datasets or do I have to hardcode it in DSNUPROC?<br><br>Thanks<br><br>Matt Harding Database Analyst DB Platform Services Information Technology Division Phone: (706) 596-7675 Fax: (706) 596-3072 Email: mharding@aflac.com
3894 51 18_Re: query quandary14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Thu, 22 May 2003 21:14:05 +0200405_- Hello,<br><br>select col1, max(col3), max(col2) from T1 group by col1<br><br>will give you the desired result. You can take the max or the min from col3; as all values for col3 for each col1 group are the same, you will simply get col3.<br><br>Hope this helps, regards<br><br>Bernd<br><br><br><br><br><br>Am Don, 22 Mai 2003 schrieben Sie: > > select col1,col3, max(col2) > from T1 > group by col1 [...]
3946 33 18_Re: query quandary14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Thu, 22 May 2003 21:18:47 +0200335_- Hello,<br><br>sorry, I didn't understand it right at first time.<br><br>You want the value for col3 from the row with col2 = max(col2) in group col1. Sorry, in my opinion there is no solution without a subquery.<br><br>But I don't see any performance problem with the correlated subquery solution, if you have an index on col1. [...]
3980 90 18_Re: query quandary12_Fay, Colin M22_cfay@UNUMPROVIDENT.COM31_Thu, 22 May 2003 15:40:47 -0400591_us-ascii Hi Bernd,<br><br>That's what I thought at first but it does not return the correct result :<br><br>For example in a two row table<br><br>Col1 Col2 Col3<br><br>100 200 2003-02-02 100 300 2003-02-01<br><br><br><br>Your query returns<br><br>100, 300, 2003-02-02<br><br>What I want is :<br><br>100, 200, 2003-02-02<br><br>i.e. all the columns from the row with the highest date<br><br><br><br><br><br>-----Original Message----- From: Bernd Oppolzer [mailto:Bernd.Oppolzer@T-ONLINE.DE] Sent: Thursday, May 22, 2003 3:14 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: query quandary [...]
4071 116 46_Re: Dynamic Allocation of datasets in DSNUPROC15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 22 May 2003 15:46:08 -0400526_iso-8859-1 Dynamic Allocation of datasets in DSNUPROCyes, sortworks can be dynamically allocated look at the sortdevt and sortnum parameters. Look at templates for other datasets that can be allocated dynamically<br><br>Bob Lawrence DBA Boscov's Dept Stores LLc<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Matt Harding Sent: Thursday, May 22, 2003 2:10 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Dynamic Allocation of datasets in DSNUPROC [...]
4188 26 18_Re: query quandary9_Agus Kwee13_askwe@ATT.NET31_Thu, 22 May 2003 19:53:33 +0000422_- Colin,<br><br>I read with interest your concern about your query that uses: group by col1, col3.<br><br>You mentioned that the combination of col1 and max(col2) uniquely defines a row in which col3 has a unique value. If this is the case, my question is: how can group by col1,col3 produce a result that is a superset of the desired answer? Are there multiple col3 values for the same values of col1 and max(col2)? [...]
4215 92 55_Re: Nulls Allowed in All Columns except the Primary Key15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 22 May 2003 15:54:02 -0400340_iso-8859-1 Annabelle, I am not commenting on the appropriateness of all columns being null except for primary key but you can define indexes as UNIQUE WHERE NOT NULL to enforce uniqueness other than null values. The null valued index rows will act as duplicates but where all the fields are not null then the index row will be unique. [...]
4308 161 55_Re: Nulls Allowed in All Columns except the Primary Key15_Jackson Reavill18_damcon2@US.IBM.COM31_Thu, 22 May 2003 17:09:28 -0400433_US-ASCII Something else to watch out for when using these Java Beans is that not only do they do an insert of the key and then turn around and update, but (from what we saw during monitoring) they do an update for every column in the table! So for example... the insertion of one row into a 10 column table with one column as the key would cause 10 SQL statements to be executed... one insert and nine updates. It's not pretty. [...]
4470 15 47_Craig McGinnis/AO/USR/FTU is out of the office.14_Craig McGinnis27_craig.mcginnis@WACHOVIA.COM31_Thu, 22 May 2003 17:26:12 -0400451_US-ASCII I will be out of the office from 05/22/2003 until 05/27/2003.<br><br>I will respond to your message when I return. If you need immediate assistance please page the IMS/DB2 Services Team.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
4486 110 45_Updated June Meeting information for LAADB2UG15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM31_Thu, 22 May 2003 14:42:09 -0700441_us-ascii The next meeting of the LA Area DB2 User Group will be held on June 5th, 2003 at the Sheraton Cerritos. The meeting room will open at 8:30am for coffee and refreshments with the first presentation beginning around 9:30.<br><br>Driving Directions: The Sheraton Cerritos is located at 12725 Center Court Drive, Cerritos CA 90703. Telephone is (562) 809-1500. It is one block south of the 91 Freeway in the Cerritos Towne Center. [...]
4597 100 29_Rational Rose - Data Modeling13_Tariq Rathore27_Tariq.Rathore@COURTS.WA.GOV31_Thu, 22 May 2003 14:48:12 -0700200_- Hello,<br><br><br><br><br><br>Would like to hear experiences of people who are using Rose for modeling. We are considering the tool for our shop.<br><br><br><br><br><br>Thanks,<br><br>Tariq.<br><br>
4698 141 49_Re: Updated June Meeting information for LAADB2UG11_Joe Timpani14_joe@AZJOBS.COM31_Thu, 22 May 2003 15:25:05 -0700419_iso-8859-1 Donna,<br><br>I would like to send you a job opportunity. Could I reply to this message and could you post it for me.<br><br>Thanks,<br><br>Joe Timpani 480-838-0333 ----- Original Message ----- From: "Donna O'Connell" <donna.oconnell@SAFEWAY.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Thursday, May 22, 2003 2:42 PM Subject: Updated June Meeting information for LAADB2UG [...]
4840 93 45_Re: Help - nice and easy License question ...15_Leon Katsnelson15_leon@CA.IBM.COM31_Thu, 22 May 2003 15:38:45 -0700618_us-ascii No, this means that if you run it on a machine that has more then one CPU you will be in violation of the license agreement that your company accepted.<br><br>Leon Katsnelson Manager, DB2 Product Management and Planning Administration Assistant: Robin Stockfish (905) 413-3632<br><br><br><br>|---------+------------------------------------> | | "Pendlebury-Bowe, Leslie"| | | <Leslie.Pendlebury-Bowe@E| | | U.SONY.COM> | | | Sent by: DB2 Data Base | | | Discussion List | | | <DB2-L@LISTSERV.YLASSOC.C| | | OM> | | | | | | | | | 05/22/2003 08:44 AM | | | Please respond to DB2 | | | Data Base Discussion [...]
4934 167 45_Re: Help - nice and easy License question ...12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 22 May 2003 16:26:22 -0700439_us-ascii And what license agreement did Les's company accept? 1 CPU because that's what comes in the license file on the install CD, or is it the legal agreement to purchase/lease the product which might be for N # of processors, or perhaps an Enterprise wide license? How can you state that he's violating the license agreement if you haven't seen it(I'm assuming you didn't go through all Sony corporate contracts before replying). [...]
5102 64 23_Re: Valid vs. Operative13_David S Waugh16_dsw-dba@JUNO.COM29_Thu, 22 May 2003 23:30:09 GMT605_- Ruediger:<br><br>My sense of the OPERATIVE columns in SYSPLAN and SYSPACKAGES is that they are set to 'N' by Autorebind, and that their purpose is primarily to ensure that Autorebind doesn't run over & over again for plans & packages that won't rebind successfully without human intervention.<br><br>I may be wrong about this, but from what I've been reading it appears that Autorebind sets this column to 'N', but explicit REBIND or BIND do not (presumably because explicit REBIND and BIND have a human watching them who notices whether they fail or not, and who will immediately fix whatever the [...]
5167 52 23_Re: image copy question13_David S Waugh16_dsw-dba@JUNO.COM29_Thu, 22 May 2003 23:47:32 GMT567_- Kathy:<br><br>Seems like another solution would be to specify DISP=(NEW,CATLG,CATLG) on your Image Copy GDG datasets, and then TELL CA-JOBTRAC TO KEEP ITS DIRTY LITTLE HANDS OFF OF THEM.<br><br>Seriously - is there a way to tell CA-JOBTRAC to *not* back out the I/C GDGs after an abend? I've never worked with CA-JOBTRAC, so DISP=(NEW,CATLG,CATLG) has always worked fine for me, allowing me to easily restart after an abend (I have to either -TERM the utility ID to start over from square one or RESTART(PHASE) to have DB2 start where it left off, of course). [...]
5220 17 47_Richard Strong/MAN/Candle is out of the office.14_Richard Strong25_Richard_Strong@CANDLE.COM31_Fri, 23 May 2003 01:00:49 +0100481_us-ascii I will be out of the office starting 22/05/2003 and will not return until 03/06/2003.<br><br><br><br>If you require an update to a problem, or are providing an update for a problem, please email uk_support@candle.com<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
5238 169 34_Re: Rational Rose - Data Modelling12_Cianci, Nick19_nick.cianci@EDS.COM31_Fri, 23 May 2003 10:30:41 +1000565_- Used it a while back 2-3 years now.<br><br>You need to wrap your head around the UML (Unified Modelling Language) concepts, for starters, which has differences from the ERD (Entity Relationship Diagrams). Once you get your head around UML it's not bad.<br><br>It isn't something I'd necessarily that I would go out and buy as a DB2 modelling tool, as I believe there are better, but if you are using the rest of the rational tool suite then it really comes in to it own, providing an integrated solution. The only problem I had and that was with Rose 2000e, [...]
5408 45 29_Re: ICOPY on DSNDB01.DSNSCT0213_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 00:56:36 GMT458_us-ascii Vijay:<br><br>This is due to a change in the indexes on DSNDB01 during migration from V5 to V6. The migration to V6 changes the indexes on the Directory (not the Catalog) to COPY YES. The explanation for this change (see Item RTA000165647 in IBMLink): "It was determined by development that customers may want to IC these indexes and there was no way for the customer to ALTER them." [i.e. to ALTER them to change them to COPY YES eligibility] [...]
5454 71 43_Re: Migrate to catalogued tape image copies13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 01:31:35 GMT372_- Carlos:<br><br>The normal IBM Image Copy utility does not allow duplicates in SYSCOPY. You'll get messages DSNU407I and DSNU408I if you try.<br><br>If the I/C datasets are cataloged in an ICF catalog via DISP=(,CATLG), you'll get a nasty-gram from DFP or SMS about duplicate dataset names. (but if the Operator uncatalogs one before restarting the job, you won't). [...]
5526 34 20_Re: QUIESCE question13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 02:14:23 GMT579_us-ascii I can think of an instance where there *is* a gain from running QUIESCE before the COPY:<br><br>Let's say my COPY job copies several hundred tablespaces (PeopleSoft, SAP, or Seibel, anyone?) and takes several hours to run. Let's say the 196th, 242nd and 373rd tablespaces to be copied are in a 'strange state'. A QUIESCE up front would catch those problems right away, instead of COPY encountering them much, much later. Finding & fixing the problems up front would allow me to avoid a lot of extra work futzing with things in order to restart the I/C each time it [...]
5561 131 45_Re: Help - nice and easy License question ...13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 04:32:08 GMT370_- I too have seen this same thing. My customer purchased 4 licenses of UDB EE 7.1, yet when it came to installing it on our 2-node MSCS Cluster, I got the same nasty-gram about "attempting to run only 1 license on a 2-processor cluster". This because the default (apparently) is to install UDB with 1 license only, regardless of how many we had actually purchased. [...]
5693 98 38_Re: Executing db2 utilities using JDBC22_Bertolino, Salvatore S26_SBertolino@MAIL.SBIC.CO.ZA31_Fri, 23 May 2003 07:58:15 +0200586_iso-8859-1 The only way I know that you can do this is using the JNI (Java Native Interface). I investigated this a while back and found some sample code. Please mail me offline and I can forward it to you.<br><br><br><br>__________________________________________________________________________________________________________________________________<br><br>For information about the Standard Bank group visit our web site <www.standardbank.co.za> __________________________________________________________________________________________________________________________________ [...]
5792 137 23_Re: Valid vs. Operative41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Fri, 23 May 2003 09:10:58 +0200567_iso-8859-1 David,<br><br>thanks a lot for your explanation but: We have AUTO-REBIND turned off, so COEXIST doesn't come into play. Is there really a difference between binding packages via Auto-Rebind and rebinding it manually ? If so, when did that difference come into existence ? For those packages I tried to rebind yesterday the VALID-flag was set to 'N' (quite expectedly), stil operative remained 'Y', so the new values for VALID also didn't affect the rebind-job. The more I think about it the more I wonder when OPERATIVE actually gets switched to 'N'. [...]
5930 97 18_Re: Image copy B3715_Steve McAuliffe35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Fri, 23 May 2003 08:39:20 +0100422_- The problem was actually with the volume count and that at this site although they are SMS they don't have any dataclas defined, (we won't go there will we Max..). The hardcopy of the utilities guide states that the VOLCNT will default to 5. However with changes to fix a tape VOLCNT problem the manual was updated to now say that with DASD templates there is no longer a default value, (there is still for tapes). [...]
6028 44 37_Re: db2move won't move after fixpak 96_Daniel15_bufes@YAHOO.COM31_Fri, 23 May 2003 02:37:13 -0500665_- On Thu, 22 May 2003 12:00:41 +0100, Davage, Marcus <Marcus.Davage@LLOYDSTSB.CO.UK> wrote:<br><br>>Hi, > >DB2 UDB 7.2 on Windows NT 4.0 with DB2 connect to DB2 for OS/390 V6.1 on >z/OS 1.2. > >I've just put FixPak 9 on my local workstation UDB instance, and all of a >sudden, db2move returns the following complaint when I try to export data >from the mainframe. > >SQL3104N The Export utility is beginning to export data to file "tab1.ixf". >SQL3015N An SQL error "-805" occurred during processing. >SQL0805N Package "DB2TPRIME.NULLID.SQLUAD08.4141414141594154" was not >found. >SQLSTATE=51002 >SQL3105N The Export utility has finished exporting "0" rows. > [...]
6073 44 7_signoff12_Mike Houston35_Mike.Houston@SCOTTISH-COURAGE.CO.UK31_Fri, 23 May 2003 08:44:46 +0100502_us-ascii signoff DB2-L<br><br><br><br><br><br><br><br>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. [...]
6118 26 60_Re: Help! Query with not null where clause acting strange???6_Daniel15_bufes@YAHOO.COM31_Fri, 23 May 2003 02:57:38 -0500354_- On Thu, 22 May 2003 09:46:07 -0400, edie.richardson@SRS.GOV wrote:<br><br>>We just upgraded to DB2 v7.1 My analyst are saying this query worked >correctly before we upgraded. This table has 2.1 million rows and is >partitioned. What I don't understand is why when I leave the where >cause of 'BUDG_RPT_CD IS NOT NULL ' why no rows are returned. > [...]
6145 19 31_Re: AW: Re: Valid vs. Operative33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Fri, 23 May 2003 03:34:32 -0500346_ISO-8859-1 Rüdiger<br><br>If I summarize, what has been said in all the replies, I think Davids is a very lucid explanation. If you have set AUTO-REBIND to off, and if only autorebind sets OPERATIVE to 'N', you will never get it. May be you have changed that parameter over time and may be that's the reason you generated FREEs in the past. [...]
6165 110 37_Re: db2move won't move after fixpak 914_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 23 May 2003 10:08:15 +0100349_iso-8859-1 I've bound everything that could possibly need binding, and still get it. However, a colleague has drawn my attention to IY42180 which says "working as designed." I've raised a call to ask IBM to clarify this.<br><br>Someone else has also said that it is a bug in Fixpak 9, and that IBM had build a special build for them to fix it. [...]
6276 74 18_Re: query quandary12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 23 May 2003 12:22:16 +0200316_- Hi,<br><br>Don't throw out the CURSOR options. In the early days of V6 I did a trace on something like your query And got the following results:<br><br>InDB2 Time InDB2 CPU SQL Sorts Locks Rows 00:00.00392 .00341 4 0 7 4 00:00.00625 .00517 4 1 9 24<br><br>The CURSOR was the better performer. Of course YMMV. [...]
6351 19 37_Re: db2move won't move after fixpak 916_Robin Willoughby25_willoughbyr@UK.TIGPLC.COM31_Fri, 23 May 2003 04:08:12 -0500537_- Hi Marcus, I had the same problem with EXPORT and FP9 a couple of weeks ago - after a bit of digging around (and a CLI trace) I found the culprit was package SQLUAD08. To bind this BIND db2ueiwi.bnd - I guess this should really be added to ddcsmvs.lst<br><br>cheers,<br><br>Robin<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6371 97 37_Re: db2move won't move after fixpak 914_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 23 May 2003 10:35:48 +0100628_iso-8859-1 Thanks to Robin (hi, old friend!) and Wolfgang for suggesting the same result at the same time!<br><br>DB2 "bind db2ueiwi.bnd BLOCKING ALL GRANT PUBLIC sqlerror continue" was the answer.<br><br>Marcus<br><br><br><br>--------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...]
6469 15 47_Julie A Lundrigan/GIS/CSC is out of the office.17_Julie A Lundrigan16_jlundri2@CSC.COM31_Fri, 23 May 2003 11:32:40 +0100403_us-ascii I will be out of the office starting 23/05/2003 and will not return until 03/06/2003.<br><br>I will respond to your message when I return.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6485 23 12_Generate DDL15_Katharine Brown25_kathrinebrown@HOTMAIL.COM31_Fri, 23 May 2003 11:39:01 +0000268_- Does anyone has a REXX which generates DDLs when there is a ALter Table which leads to a drop and create of the Table.My manager is not ready to buy any third-party tools due to the cost factor.If there is can you share it online or offline if possible. Thanks [...]
6509 20 19_Data Modeling tools0_28_William_Shipley@VANGUARD.COM31_Fri, 23 May 2003 08:00:23 -0400529_us-ascii I have been asked to query the DB2 Database Discussion List concerning what modeling tool DB2 z/OS or OS/390 shops are using. We are currently using ERwin. What modeling tool do you use?<br><br>Thanks, Bill Shipley DBA The Vanguard Group, Inc. Valley Forge, PA USA<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6530 69 16_Re: Generate DDL19_Ravikumar_Devireddy30_Ravikumar_Devireddy@SATYAM.COM31_Fri, 23 May 2003 17:38:21 +0530373_- Hi Kathy,<br><br>Welcome to no-tools-manage-own... I was also looking for similar info a while back for generating DDL etc., and got some good info from fellow list members on the subject.<br><br>Here's some intresting articles i found in mainframe week that might be useful to you in managing DB2 Objects : These have some rexx scripts also along with the writeup. [...]
6600 87 4_TEST18_Bednarz, Michael P22_Michael.Bednarz@CA.COM31_Fri, 23 May 2003 13:14:51 +0100287_iso-8859-1 Sorry but I've to test my Outlookrules<br><br>Michael Bednarz<br><br>CA Computer Associates GmbH FSG Consultant tel: +49 (0) 211 5306 295 fax: +49 (0) 211 5306 200 mobile: +49 (0) 170 85 38 576<br><br>mailto:michael.bednarz@ca.com http://ca.com/germany<br><br><br><br><br><br>
6688 41 16_Re: Generate DDL23_Leedom, Robert W (ITSC)26_Robert.Leedom@MAIL.IHS.GOV31_Fri, 23 May 2003 07:16:29 -0600604_iso-8859-1 Katherine, Try http://www.db2expert.com/download.html These are a whole set of REXX scripts from YL&A consultants.<br><br>Bob Leedom<br><br>-----Original Message----- From: Katharine Brown [mailto:kathrinebrown@HOTMAIL.COM] Sent: Friday, May 23, 2003 5:39 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Generate DDL<br><br><br><br>Does anyone has a REXX which generates DDLs when there is a ALter Table which leads to a drop and create of the Table.My manager is not ready to buy any third-party tools due to the cost factor.If there is can you share it online or offline if possible. Thanks [...]
6730 97 60_Re: Help! Query with not null where clause acting strange???0_23_edie.richardson@SRS.GOV31_Fri, 23 May 2003 09:30:08 -0400672_us-ascii I did rebuild the indexes. Any other ideas????<br><br>Thanks!<br><br><br><br><br><br><br><br>Daniel <bufes@YAHOO.COM><br><br><br><br>05/23/03 03:57 AM<br><br><br><br>To: DB2-L@LISTSERV.YLASSOC.COM, edie.richardson@srs.gov cc: Subject: Re: Help! Query with not null where clause acting strange???<br><br><br><br>On Thu, 22 May 2003 09:46:07 -0400, edie.richardson@SRS.GOV wrote:<br><br>>We just upgraded to DB2 v7.1 My analyst are saying this query worked >correctly before we upgraded. This table has 2.1 million rows and is >partitioned. What I don't understand is why when I leave the where >cause of 'BUDG_RPT_CD IS NOT NULL ' why no rows are returned. > [...]
6828 41 23_Re: Valid vs. Operative41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Fri, 23 May 2003 15:32:45 +0200497_iso-8859-1 Walter,<br><br>sorry, nope; auto-rebind has been turned off since God knows when at this shop, at least since I started work in this company, and that's a while off by now. And frankly, I can't see any reason why a manual rebind should act differently from an auto-rebind.<br><br>-----Ursprüngliche Nachricht----- Von: Walter Janißen [mailto:walter.janissen@VICTORIA.DE] Gesendet: Freitag, 23. Mai 2003 10:35 An: DB2-L@LISTSERV.YLASSOC.COM Betreff: Re: AW: Re: Valid vs. Operative [...]
6870 26 60_Re: Help! Query with not null where clause acting strange???6_Daniel15_bufes@YAHOO.COM31_Fri, 23 May 2003 08:37:52 -0500498_- On Fri, 23 May 2003 09:30:08 -0400, edie.richardson@SRS.GOV wrote:<br><br>>I did rebuild the indexes. Any other ideas???? > >Thanks! ><br><br>Edie, Another wild guess - suppose it's a parallelism related bug - try to disable parallelism using set current degree or using bind option degree. Then rerun the query. Also - try to search db2 apars database for any problem similar to this. Is your v7 db2 code fairly recent or have you upgraded to an earlier (older) level? Best regards, Daniel [...]
6897 117 46_Re: Dynamic Allocation of datasets in DSNUPROC10_Jwkwan200025_jwkwan2000@HOUSTON.RR.COM31_Fri, 23 May 2003 08:56:14 -0500616_iso-8859-1 Dynamic Allocation of datasets in DSNUPROCMatt,<br><br>DB2 V7 Reorg will dyanimically allocate those work datasets if not specified in JCL.<br><br>James Kwan ----- Original Message ----- From: Matt Harding Newsgroups: bit.listserv.db2-l To: DB2-L@LISTSERV.YLASSOC.COM Sent: Thursday, May 22, 2003 1:10 PM Subject: Dynamic Allocation of datasets in DSNUPROC<br><br><br><br>I want to use IBM's Reorg utility with DB2 version 7. The reorg utility requires DD-statements for sortworks and other datasets. Can the Reorg utility dynamically allocate these datasets or do I have to hardcode it in DSNUPROC? [...]
7015 14 23_Encrypt Data in Storage10_Mary McCoy22_mmccoy@DHR.STATE.MD.US31_Fri, 23 May 2003 08:45:46 -0500468_- This is a DB2 for z/OS and S/390 question.<br><br>Are there any PTFs that we can apply to DB2 V7.1 to take advantage of the new ENCRYPT built-in function? We would like to enable encryption on the column level.<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
7030 24 30_DB2 V7 UNICODE DATA CORRUPTION10_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 23 May 2003 10:09:33 -0400559_us-ascii Hi everyone<br><br>Can someone (Preferably Roger or Leon) give me and explanation as to why IBM DID NOT forewarn The DB2 community about the UNICODE TRANSLATION ISSUE when a DB2 V7 client connects to a DB2 V7 OS/390 server?<br><br>We have DB2 distributed applications that store special characters on the DB2 mainframe. Unfortunately ICONV on the host has translation issues and caused DATA CORRUPTION. We just found out that UNICODE for OS/390 (fmid HUNI2A0) is correcting this issue but has not yet been installed. WHAT IS THE STORY FROM IBM? [...]
7055 27 16_DB2 V7 Utilities12_Joan Stevens23_jstevens@BINGHAMTON.EDU31_Fri, 23 May 2003 10:34:44 -0400324_iso-8859-1 Over the summer, we are converting from DB2 V5 to DB2 V7. Since you have to purchase utilities now, I was wondering if anyone has experience using CA's utilities over purchasing the IBM set. Does anyone know of any other company selling a similar set or programs that I can investigate? Thanks for any help. [...]
7083 66 26_V6 to V7 with data sharing14_Heckman, Carol29_carol_heckman@MEDCOHEALTH.COM31_Fri, 23 May 2003 10:56:56 -0400446_- All, We are migrating from V6 to V7 and have converted everything to data sharing since we migrated to V6. For our most significant production group, we would prefer not to jeopardize the workload of the whole group with the new version all at once. We are considering migrating a week or two apart. Does anyone have any interesting information/warnings/war stories about doing the migration in a phased fashion as opposed to all at once? [...]
7150 24 23_Re: image copy question17_Kathleen S. Jones26_ksjones2@INTERACT.CCSD.NET31_Fri, 23 May 2003 08:03:06 -0700561_ISO-8859-1 DB2 Data Base Discussion List <DB2-L@LISTSERV.YLASSOC.COM> writes: >Seems like another solution would be to specify DISP=(NEW,CATLG,CATLG) on >your Image Copy GDG datasets, and then TELL CA-JOBTRAC TO KEEP ITS DIRTY >LITTLE HANDS OFF OF THEM. I think if I change the JCL to catlg,catlg it will work - this doesn't happen often - only 3 times in the last 6 months that I can remember so I am debating whether it is worth the effort or not. I have not worked with CA-JOBTRAC much till now so I am a novice with it but it isn't the nicest thing to [...]
7175 168 30_Re: V6 to V7 with data sharing13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Fri, 23 May 2003 11:16:37 -0400336_US-ASCII Carol,<br><br>I take it from your note that your most significant production group is a DB2 data sharing group with multiple members, and you are considering migrating the members a week or two apart.<br><br>While this is certainly do-able, and I can understand the need to reduce risk, I'm not sure it will buy you much. [...]
7344 63 23_Re: Data Modeling tools12_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Fri, 23 May 2003 10:23:58 -0500565_us-ascii We are using MS Visio 2002.<br><br>Buzz<br><br><br><br><br><br><br><br>William_Shipley@VA NGUARD.COM To: DB2-L@LISTSERV.YLASSOC.COM cc: Sent by: DB2 Data Subject: Data Modeling tools Base Discussion List <DB2-L@LISTSERV.YL ASSOC.COM><br><br><br><br>05/23/2003 07:00 AM Please respond to DB2 Data Base Discussion List<br><br><br><br><br><br><br><br><br><br><br><br>I have been asked to query the DB2 Database Discussion List concerning what modeling tool DB2 z/OS or OS/390 shops are using. We are currently using ERwin. What modeling tool do you use? [...]
7408 53 30_Re: V6 to V7 with data sharing10_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 23 May 2003 11:36:53 -0400442_us-ascii Carol<br><br>If you allow apps to run under either member.... watch out for ABIND zparm.... if set wrong you could be rebinding each time the app runs on the other member. COEXIST may be the best option.<br><br>Tom<br><br><br><br><br><br>"Heckman, Carol" <carol_heckman@MEDCO To: DB2-L@LISTSERV.YLASSOC.COM HEALTH.COM> cc: Sent by: DB2 Data Subject: V6 to V7 with data sharing Base Discussion List <DB2-L@LISTSERV.YLAS SOC.COM> [...]
7462 22 61_any problems with force to nocopypending on production envt ?6_Nguyen13_ndt98@FREE.FR31_Fri, 23 May 2003 10:33:45 -0500341_- Hi all ,<br><br>We are have a big historical table where some partitions are reloaded every day in tournament , as we keep the sequential used to reloaded it , we planned not to manage the copy, using start access(force) to "clear" the copypending state - For me , there is any problem to do this , as we know how to reload the data. [...]
7485 72 45_Re: Help - nice and easy License question ...11_Sikes, Mary26_Mary.Sikes@TRS.STATE.TX.US31_Fri, 23 May 2003 10:44:02 -0500640_iso-8859-1 In addition to updating number of processors thru License Manager, you might find following link helpful for DB2 config parms to update to take advantage of multiple processors.<br><br>http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document .d2w/report?fn=db2v7d0db2d0227.htm<br><br>Regards, ___________________________________________ Mary Sikes, Database Administrator Teacher Retirement System of Texas<br><br>-----Original Message----- From: Pendlebury-Bowe, Leslie [mailto:Leslie.Pendlebury-Bowe@EU.SONY.COM] Sent: Thursday, May 22, 2003 10:45 AM Subject: Help - nice and easy License question ... [...]
7558 49 65_Re: any problems with force to nocopypending on production envt ?16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Fri, 23 May 2003 12:09:13 -0400431_iso-8859-1 One issue I can think of is - getting rid of SYSLGRNX entries. If you are using IBM MODIFY, you need a FULL copy in order to do cleanup SYSLGRNX.<br><br>Kind regards Steen Rasmussen Computer Associates<br><br><br><br><br><br>-----Original Message----- From: Nguyen [mailto:ndt98@FREE.FR] Sent: 23. maj 2003 17:34 To: DB2-L@LISTSERV.YLASSOC.COM Subject: any problems with force to nocopypending on production envt ? [...]
7608 136 23_Re: Data Modeling tools22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Fri, 23 May 2003 11:15:22 -0500450_iso-8859-1 <br><br>Embarcadero ER/Studio<br><br>-----Original Message----- From: William_Shipley@VANGUARD.COM [mailto:William_Shipley@VANGUARD.COM] Sent: Friday, May 23, 2003 7:00 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Data Modeling tools<br><br><br><br>I have been asked to query the DB2 Database Discussion List concerning what modeling tool DB2 z/OS or OS/390 shops are using. We are currently using ERwin. What modeling tool do you use? [...]
7745 25 29_Will "INSERT" Close a Cursor?12_John Bucaria16_JBUCARIA@PCH.COM31_Fri, 23 May 2003 13:08:35 -0400356_US-ASCII Hi All ,<br><br>We have a COBOL application program that: 1.) opens a cursor and fetches from it 2.) inserts to a DB2 table 3.) attempts to close the cursor and receives a -501 sqlcode on the close<br><br>Since no commit was executed, can I assume that the "insert" caused an automatic close of the cursor and therefore the subsequent -501 ? [...]
7771 56 66_Re: any problems with force to nocopypending on productio n envt ?17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Fri, 23 May 2003 12:39:57 -0500364_iso-8859-1 The whole point of Image Copies is RECOVERABILITY.<br><br>If you feel you have that covered by virtue of the fact that you can re-load the data then you can force off the COPYPEND restriction.<br><br>That's exactly the reason why the LOAD utility offers a NOCOPYPEND option. You might consider using that syntax option if that's what you're after. [...]
7828 42 33_Re: Will "INSERT" Close a Cursor?12_Terry Fuller30_Terry.Fuller@ARVATOSYSTEMS.COM31_Fri, 23 May 2003 12:50:44 -0500509_iso-8859-1 John, Add the phrase "WITH HOLD" to the cursor declaration.<br><br>Terry Fuller arvato systems<br><br>-----Original Message----- From: John Bucaria [mailto:JBUCARIA@PCH.COM] Sent: Friday, May 23, 2003 12:09 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Will "INSERT" Close a Cursor?<br><br><br><br>Hi All ,<br><br>We have a COBOL application program that: 1.) opens a cursor and fetches from it 2.) inserts to a DB2 table 3.) attempts to close the cursor and receives a -501 sqlcode on the close [...]
7871 120 23_Re: Valid vs. Operative13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 22:09:44 GMT558_- Ruediger:<br><br>The only three circumstances I've been able to find where OPERATIVE gets set to 'N' are: 1. Autorebind fails (could be the plan or package can't be rebound, could be the autorebind simply times out due to lock contention).<br><br>2. If the owner of an application plan or package loses a privilege that is required by the plan or package, and the owner does not have that privilege from another source, and if the revoked privilege was EXECUTE on a user-defined function, DB2 marks the plan or package inoperative instead of invalid. [...]
7992 108 23_Re: Valid vs. Operative20_desiz db2 consultant20_desig@CONSULTANT.COM31_Fri, 23 May 2003 13:22:06 -0500520_iso-8859-1 Hi All experts , here we got lot of knowledges from your valuable discussions. We were told lot of things about plan and package free also. Even we had seen that when ever we get RDS CODE as 500 or 600 we free the plan. The RDS CODE is associated with SQL CODES as -206 etc. Even then we heard from seniors that when ever RDS CODE is 500 or 600 free the plan and create it fresh. When we look at diffreent books we never get any explanation about this. Even in IBM manual also not that much descriptive. [...]
8101 69 23_Re: Data Modeling tools6_ScotDB18_teamdba@SCOTDB.COM31_Fri, 23 May 2003 23:09:31 +0100689_- For the "poor" like me, try the DataArchitect tool for TheKompany / Code By Design (http://www.thekompany.com).<br><br>For about $70 you get a tool which is shaping up nicely !!!<br><br>And I've found they are very DB2 friendly.<br><br>HTH<br><br>Phil Nelson ScotDB Limited<br><br>On Fri, 2003-05-23 at 17:15, Venkatesh Mokshagundam wrote: > Embarcadero ER/Studio > > -----Original Message----- > From: William_Shipley@VANGUARD.COM > [mailto:William_Shipley@VANGUARD.COM] > Sent: Friday, May 23, 2003 7:00 AM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Data Modeling tools > > > I have been asked to query the DB2 Database Discussion List concerning > what > modeling tool DB2 z/OS [...]
8171 105 60_Re: Help! Query with not null where clause acting strange???12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US31_Fri, 23 May 2003 13:20:17 -0500295_US-ASCII I don't have the answer for you. I think when this type of issue surfaced on this list in the past, the problem was typically the index. When you made the different changes to your WHERE clause, did you notice if it was using the ILDGENT_RPT04 index for ALL those cases you tried? [...]
8277 51 33_Re: Rational Rose - Data Modeling12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US31_Fri, 23 May 2003 13:27:54 -0500346_US-ASCII I used Rational Rose (not w/DB2) but with Delphi, ERWin, SQL Server, Oracle project. We used it to organize our OO objects. We tried to gain the benefits of reuse of OO objects. There is a learning curve to the tool and with UML. a lot of mainframers who are used to top down design will giggle at the clouds and many new diagrams. [...]
8329 39 33_Re: Will "INSERT" Close a Cursor?14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Sat, 24 May 2003 16:42:31 +0200555_- Hello,<br><br>INSERT does not close a cursor. If the cursor has really been closed, there must be another reason.<br><br>Regards<br><br>Bernd<br><br><br><br><br><br>Am Fre, 23 Mai 2003 schrieben Sie: > Hi All , > > We have a COBOL application program that: > 1.) opens a cursor and fetches from it > 2.) inserts to a DB2 table > 3.) attempts to close the cursor and receives a -501 sqlcode on the > close > > Since no commit was executed, can I assume that the "insert" caused an > automatic close of the cursor and therefore the subsequent -501 ? [...]
8369 65 33_Re: Will "INSERT" Close a Cursor?14_Michael Kaplan25_micaelkp@NETVISION.NET.IL31_Fri, 23 May 2003 22:33:37 +0200373_iso-8859-1 John,<br><br>It should not be happened within the same LUW ( Logical Unit of Work).<br><br>Try this :<br><br>1) open cursor, fetch 2) insert 3) open the same cursor<br><br>you should get sqlerror -502.<br><br>If not, somehow your application probably has started a new LUW. If your appllication is in CICS, check if you are wthin the same peuso-conv. task. [...]
8435 37 23_Re: Data Modeling tools13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 19:25:23 GMT596_- Bill:<br><br>I've been using Sybase's PowerDesigner (V9) at my current contract. A little buggy, unfortunately, and a little difficult to use. One of my colleagues here has ERWin on his laptop, and frankly it looks much better & more flexible than PowerDesigner.<br><br>David Waugh, NCW DSW Consulting & Services Former DB2 Sysprog, now clueless DB2 UDB Win/NT DBA =================================================== Supplimental Commandments for the Nineties =================================================== Thou shalt not fix the dishwasher with an eight-pound hammer and a glue gun. [...]
8473 120 23_Re: Valid vs. Operative13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 20:23:56 GMT558_- Ruediger:<br><br>The only three circumstances I've been able to find where OPERATIVE gets set to 'N' are: 1. Autorebind fails (could be the plan or package can't be rebound, could be the autorebind simply times out due to lock contention).<br><br>2. If the owner of an application plan or package loses a privilege that is required by the plan or package, and the owner does not have that privilege from another source, and if the revoked privilege was EXECUTE on a user-defined function, DB2 marks the plan or package inoperative instead of invalid. [...]
8594 44 65_Re: any problems with force to nocopypending on production envt ?10_Dale Smock28_Dale.Smock@ARVATOSYSTEMS.COM31_Fri, 23 May 2003 13:44:44 -0500515_iso-8859-1 Recommend using nocopypend parameter on the load (if available for your load utility), or Repair nocopypend instead of a start force. That will avoid reseting other status conditions (like recover pending or check pending) that you might want to know about.<br><br>Dale Smock arvato systems<br><br>-----Original Message----- From: Nguyen [mailto:ndt98@FREE.FR] Sent: Friday, May 23, 2003 10:34 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: any problems with force to nocopypending on production envt ? [...]
8639 59 33_Re: Will "INSERT" Close a Cursor?12_John Bucaria16_JBUCARIA@PCH.COM31_Fri, 23 May 2003 15:18:16 -0400396_US-ASCII Terry,<br><br>I realize that "with hold" will maintain the cursor positioning but I didn't realize that an "insert" would close the cursor in the first place. I thought only "commit" or "rollback" would do that.<br><br>John<br><br>>>> Terry.Fuller@ARVATOSYSTEMS.COM 05/23/03 01:50PM >>> John, Add the phrase "WITH HOLD" to the cursor declaration.<br><br>Terry Fuller arvato systems [...]
8699 91 33_Re: Will "INSERT" Close a Cursor?14_Dash, Sushanta21_sushanta.dash@EDS.COM31_Sat, 24 May 2003 23:16:16 -0500545_iso-8859-1 Hi John, you are the right person to check the logic of the program and see how it is getting closed. But there are instances where you would get -501 while trying to close the cursor. That is due to the number of locks by a single user or thread has exceeded the limit defined by NUMLKUS parameter in DSNZPARM. Say your program is having locks and it exceeds the limit NUMLKUS then subsequent fetch and close cursor will fail with -904 and cursor will be closed and it issues a -904. Check whether you have -904 along with this [...]
8791 185 23_DB2 Text Extender 7.1.012_Hamid Alvani22_alvani@DPI2.DPI.NET.IR31_Sun, 25 May 2003 10:47:25 -0700452_iso-8859-1 Hi all experts; For DB2 Text Extender 7.1.0 activation and customization, in OMVS i start search service controller (txstart) and i enter db2tx . then db2tx prompt appears, connection to database complete successfully: db2tx => connect to os390<br><br>Database Connection Information Database product = DSN07011 07.01.0001 SQL authorization ID = Local database alias = OS390 but when i enable server: db2tx => enable server for db2text [...]
8977 24 33_Re: Will "INSERT" Close a Cursor?13_Patric Becker25_Patric_Becker@SIS-WEST.DE31_Sun, 25 May 2003 14:41:35 -0500385_ISO-8859-1 John,<br><br>are there probably any underlying programs your application is calling ? If so : Check if any of these issue a COMMIT or an IMS Synccall (depending on your environment). Insert statements don´t close cursors. Or does your 'problem application' give the control back to the program by which it was called and this one ends the LUOW by committing the data ? [...]
9002 24 33_Re: Will "INSERT" Close a Cursor?13_Patric Becker25_Patric_Becker@SIS-WEST.DE31_Sun, 25 May 2003 14:47:26 -0500397_- John,<br><br>some more informations from the manual :<br><br>> Check for a previous SQL return code that may have closed the cursor. > Commit and rollback operations close cursors. SQLCODES > -404, -652, -679, -802, -901, -904, -909, -910, -911, and -913 will force > the cursor to close. After the cursor is closed, any fetches or close > cursor statements will receive this SQLCODE -501. [...]
9027 32 54_Theo van Westrienen/Martinair/31 is out of the office.19_Theo van Westrienen36_theo.van.westrienen@NL.MARTINAIR.COM31_Mon, 26 May 2003 01:02:35 +0200730_us-ascii I will be out of the office starting 23-05-2003 and will not return until 12-06-2003.<br><br><br><br><br><br><br><br><br><br>***************************************************************** This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Martinair Holland N.V., its subsidiaries and/or [...]
9060 123 23_Re: Valid vs. Operative13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 22:09:44 GMT558_- Ruediger:<br><br>The only three circumstances I've been able to find where OPERATIVE gets set to 'N' are: 1. Autorebind fails (could be the plan or package can't be rebound, could be the autorebind simply times out due to lock contention).<br><br>2. If the owner of an application plan or package loses a privilege that is required by the plan or package, and the owner does not have that privilege from another source, and if the revoked privilege was EXECUTE on a user-defined function, DB2 marks the plan or package inoperative instead of invalid. [...]
9184 67 23_Re: Valid vs. Operative13_David S Waugh16_dsw-dba@JUNO.COM29_Thu, 22 May 2003 23:30:09 GMT605_- Ruediger:<br><br>My sense of the OPERATIVE columns in SYSPLAN and SYSPACKAGES is that they are set to 'N' by Autorebind, and that their purpose is primarily to ensure that Autorebind doesn't run over & over again for plans & packages that won't rebind successfully without human intervention.<br><br>I may be wrong about this, but from what I've been reading it appears that Autorebind sets this column to 'N', but explicit REBIND or BIND do not (presumably because explicit REBIND and BIND have a human watching them who notices whether they fail or not, and who will immediately fix whatever the [...]
9252 48 29_Re: ICOPY on DSNDB01.DSNSCT0213_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 00:56:36 GMT458_us-ascii Vijay:<br><br>This is due to a change in the indexes on DSNDB01 during migration from V5 to V6. The migration to V6 changes the indexes on the Directory (not the Catalog) to COPY YES. The explanation for this change (see Item RTA000165647 in IBMLink): "It was determined by development that customers may want to IC these indexes and there was no way for the customer to ALTER them." [i.e. to ALTER them to change them to COPY YES eligibility] [...]
9301 123 23_Re: Valid vs. Operative13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 23 May 2003 20:23:56 GMT558_- Ruediger:<br><br>The only three circumstances I've been able to find where OPERATIVE gets set to 'N' are: 1. Autorebind fails (could be the plan or package can't be rebound, could be the autorebind simply times out due to lock contention).<br><br>2. If the owner of an application plan or package loses a privilege that is required by the plan or package, and the owner does not have that privilege from another source, and if the revoked privilege was EXECUTE on a user-defined function, DB2 marks the plan or package inoperative instead of invalid. [...]
9425 140 23_Re: Valid vs. Operative41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Fri, 23 May 2003 09:10:58 +0200567_iso-8859-1 David,<br><br>thanks a lot for your explanation but: We have AUTO-REBIND turned off, so COEXIST doesn't come into play. Is there really a difference between binding packages via Auto-Rebind and rebinding it manually ? If so, when did that difference come into existence ? For those packages I tried to rebind yesterday the VALID-flag was set to 'N' (quite expectedly), stil operative remained 'Y', so the new values for VALID also didn't affect the rebind-job. The more I think about it the more I wonder when OPERATIVE actually gets switched to 'N'. [...]
9566 113 37_Re: db2move won't move after fixpak 914_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 23 May 2003 10:08:15 +0100349_iso-8859-1 I've bound everything that could possibly need binding, and still get it. However, a colleague has drawn my attention to IY42180 which says "working as designed." I've raised a call to ask IBM to clarify this.<br><br>Someone else has also said that it is a bug in Fixpak 9, and that IBM had build a special build for them to fix it. [...]
9680 77 18_Re: query quandary12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 23 May 2003 12:22:16 +0200316_- Hi,<br><br>Don't throw out the CURSOR options. In the early days of V6 I did a trace on something like your query And got the following results:<br><br>InDB2 Time InDB2 CPU SQL Sorts Locks Rows 00:00.00392 .00341 4 0 7 4 00:00.00625 .00517 4 1 9 24<br><br>The CURSOR was the better performer. Of course YMMV. [...]
9758 171 30_Re: V6 to V7 with data sharing13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Fri, 23 May 2003 11:16:37 -0400336_US-ASCII Carol,<br><br>I take it from your note that your most significant production group is a DB2 data sharing group with multiple members, and you are considering migrating the members a week or two apart.<br><br>While this is certainly do-able, and I can understand the need to reduce risk, I'm not sure it will buy you much. [...]
9930 75 45_Re: Help - nice and easy License question ...11_Sikes, Mary26_Mary.Sikes@TRS.STATE.TX.US31_Fri, 23 May 2003 10:44:02 -0500639_iso-8859-1 In addition to updating number of processors thru License Manager, you might find following link helpful for DB2 config parms to update to take advantage of multiple processors.<br><br>http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document d2w/report?fn=db2v7d0db2d0227.htm<br><br>Regards, ___________________________________________ Mary Sikes, Database Administrator Teacher Retirement System of Texas<br><br>-----Original Message----- From: Pendlebury-Bowe, Leslie [mailto:Leslie.Pendlebury-Bowe@EU.SONY.COM] Sent: Thursday, May 22, 2003 10:45 AM Subject: Help - nice and easy License question ... [...]
10006 83 43_UNIQUE WHERE NOT NULL index inconsistencies12_Warren Homer17_whomer@CSC.COM.AU31_Mon, 26 May 2003 15:27:54 +1000490_us-ascii DB2 experts,<br><br>I am getting inconsistent results when running SQL that uses an index defined with UNIQUE WHERE NOT NULL .<br><br>Below is the result(incorrect in RED) of the SQL when the UNIQUE WHERE NOT NULL index in used. When I re-ran the SQL after dropping & re-creating this index without the UNIQUE WHERE NOT NULL I received the correct result in BLUE. Both the columns selected allow NULLs. The indexed used is on the column INTERFACE_REC_ID (which allows NULLs). [...]
10090 30 34_SYSDBASE UNAVAILABLE DURING REBIND18_Di Franco Vincenzo22_difrancov@ISIDE.BCC.IT31_Mon, 26 May 2003 10:07:17 +0200437_iso-8859-1 Hi all, I've some problem when run my very large rebind-jobslike that indicated in the msg below:<br><br>DSNT501I -DBP0 DSNXA03 RESOURCE UNAVAILABLE CORRELATION-ID=WFSISBCA CONNECTION-ID=BATCH LUW-ID=* REASON 00C90088 TYPE 00000302 NAME DSNDB06 .SYSDBASE.X'000023'<br><br>I read in 'DB2 v7 Administration Guide' paragraph 'Wait Time for Transaction Locks' about Timeout Periods an multiplier (not modifiable for Rebind). [...]
10121 12 22_test - scratch message14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 26 May 2003 09:55:00 +0200269_us-ascii test<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
10134 102 12_SQL Question18_Di Franco Vincenzo22_difrancov@ISIDE.BCC.IT31_Mon, 26 May 2003 10:24:41 +0200568_iso-8859-1 Hi all,<br><br>Can someone tell me what i’m getting wrong in the following Sql for the Keylength .<br><br>SELECT A.DBNAME, A.TSNAME, A.NAME,<br><br>C.TBCREATOR, C.TBNAME, E.IXCREATOR, E.IXNAME,<br><br>E.PCTFREE, E.FREEPAGE,<br><br>((E.PQTY*4000)/1000) AS PRIQTY,<br><br>((E.SQTY*4000)/1000) AS SECQTY,<br><br>SUM(F.LENGTH) AS KEYLEN<br><br>FROM SYSIBM.SYSINDEXES C<br><br>INNER JOIN SYSIBM.SYSTABLES A<br><br>ON A.NAME = C.TBNAME AND A.CREATOR = C.CREATOR<br><br>INNER JOIN SYSIBM.SYSINDEXPART E<br><br>ON E.IXNAME = C.NAME AND E.IXCREATOR = C.CREATOR [...]
10237 57 38_Re: SYSDBASE UNAVAILABLE DURING REBIND35_=?windows-1255?B?7unr4Owg7Onh+O7v?=25_mliberman@MIVTACHIM.CO.IL31_Mon, 26 May 2003 12:41:25 +0200443_windows-1255 Hi, Are you running the rebind jobs in parallel or job by job ? It seems that you are running it in parallel and one job Is locking the other.<br><br><br><br>Michael Liberman DBA Mivtachim mliberman@mivtachim.co.il<br><br><br><br>-----Original Message----- From: Di Franco Vincenzo [mailto:difrancov@ISIDE.BCC.IT] Sent: Monday, May 26, 2003 10:07 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: SYSDBASE UNAVAILABLE DURING REBIND [...]
10295 226 23_Re: Valid vs. Operative41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Mon, 26 May 2003 12:01:20 +0200563_iso-8859-1 David,<br><br>thanks for your input, I forwarded your mail to our sysporgs and they just informed me that they asked IBM. I let you know their answer.<br><br>As to your mail, I can safely say that (2) and (3) are out of the question; if (2) were true we would be changing our privileges quite a bit ... and we usually don't do that; there is a certain RACF-Group that holds bind-authorizations and all we do is adding users to that group (or removing them), but the group still holds the privilege. And we don't have any user-defined functions in [...]
10522 168 16_Re: SQL Question19_Alekos Papadopoulos13_apapad@NBG.GR31_Mon, 26 May 2003 13:55:59 +0200495_- Buongiorno Vincenzo,<br><br>I personally use something more complicated instead of just sum for the keylength:<br><br>SUM(CASE F.COLTYPE WHEN 'DECIMAL' THEN INTEGER((F.LENGTH+2)/2) WHEN 'VARCHAR' THEN F.LENGTH+4 WHEN 'INTEGER' THEN 4 WHEN 'SMALLINT' THEN 2 WHEN 'FLOAT' THEN 4+4*INTEGER(F.LENGTH/21) ELSE F.LENGTH END) AS KEYLEN<br><br>Not perfect, it usually works in normal circumstances i.e. no LOBs, ROWIDs etc. (no responsibility is accepted anyway :) and imho better that just sum. [...]
10691 44 16_Re: SQL Question33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Mon, 26 May 2003 05:58:27 -0500301_- I think the main problem comes from the join to sysibm.sysindexpart, because there are several rows, if the index is partitioned. But if you take that into account for your query , the keylength will still be wrong, because the column LENGTH of SYSCOLUMNS does not contain the physical length. [...]
10736 67 37_R: SYSDBASE UNAVAILABLE DURING REBIND18_Di Franco Vincenzo22_difrancov@ISIDE.BCC.IT31_Mon, 26 May 2003 16:48:57 +0200527_windows-1255 They are running simultaneously. Bye<br><br><br><br><br><br><br><br><br><br><br><br>Hi, Are you running the rebind jobs in parallel or job by job ? It seems that you are running it in parallel and one job Is locking the other.<br><br><br><br>Michael Liberman DBA Mivtachim mliberman@mivtachim.co.il<br><br><br><br>-----Original Message----- From: Di Franco Vincenzo [mailto:difrancov@ISIDE.BCC.IT] Sent: Monday, May 26, 2003 10:07 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: SYSDBASE UNAVAILABLE DURING REBIND [...]
10804 47 33_Re: Will "INSERT" Close a Cursor?12_Rohn Solecki19_rohnski@HOTMAIL.COM31_Mon, 26 May 2003 11:25:21 -0500609_iso-8859-1 Is it an Online program running under CICS? Has there been a CICS SYNCPOINT issued before the CLOSE? CICS SYNCPOINT triggers a DB2 COMMIT.<br><br>----- Original Message ----- From: "Bernd Oppolzer" <Bernd.Oppolzer@T-ONLINE.DE> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Saturday, May 24, 2003 9:42 AM Subject: Re: Will "INSERT" Close a Cursor?<br><br><br><br>> Hello, > > INSERT does not close a cursor. If the cursor has really been closed, there > must be another reason. > > Regards > > Bernd > > Am Fre, 23 Mai 2003 schrieben Sie: > > Hi All , > > > > We have a [...]
10852 59 42_DB2 Problem Determination Tutorials in PDF12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Mon, 26 May 2003 15:34:57 -0400400_iso-8859-1 FYI. Download these tutorials in PDF. This is a recent change as previously in V8.1 they were only available in html. This is good info. Phil<br><br><br><br>http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/newsletter.d2w/n20030421<br><br><br><br><br><br><br><br>Philip K. Gunning Check out the DB2 Zone at: http://www.gunningts.com/db2zone.htm Associate List Owner DB2-L
10912 24 26_Active Logs ONLY up to 2GB13_Reiner Markus21_reiner.markus@REWE.DE31_Tue, 27 May 2003 05:22:27 -0500504_- Hi,<br><br>currently i'm no DB2 systems programmer, but z/OS systems programmer. Yesterday I've heard from db2 collegues that is is only posslible to allocate DB2 active logs lower 2GB. I'm in the process of defining a new shark only with 3390 model-9 (about 8GB) dasd and we would like to allocate ONE active log data set on ONE model-9. Also I would like to use better throughput of 3590 drives for archive logs, but if I would use them one would copy 2GB to a tape which could hold about 60GB. [...]
10937 116 24_db2look to OS/390: no RI14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 27 May 2003 11:51:55 +0100476_iso-8859-1 Hi.<br><br>I'm trying to create a database on DB2 UDB for NT 7.2 fixpak 9, basing it on a database on DB2 for OS/390 6.1, however, the DDL that db2look creates does not create any RI between the tables. Is this a feature or am I doing something wrong? My command input is this: db2look -d DB2TPRIM -u FIGDBA -z FIGDBA -e -x -l There's loads of RI which I don't want to type in manually. I have to automate the creation of tablespaces and indexspaces as it is! [...]
11054 50 23_Re: Data Modeling tools11_Grant Allen21_grant@TOWERSOFT.CO.UK31_Tue, 27 May 2003 12:25:08 +0100333_us-ascii Bill,<br><br>After a thread on the Oracle list, I tried DBDesigner from fabforce (www.fabforce.com). It's open source, and while it grew out of MySQL, it now provides support for Oracle natively, and any ODBC datasource. Depending on how deep you want your z/os hooks, it's at least worth a play.<br><br>Ciao Fuzzy :-) [...]
11105 84 28_Re: db2look to OS/390: no RI19_Ravikumar_Devireddy30_Ravikumar_Devireddy@SATYAM.COM31_Tue, 27 May 2003 16:52:48 +0530492_- Hi Marcus,<br><br>Your command line seems fine.<br><br>For Db2look, If the DB name is an OS/390 database then output is limited to :<br><br>-DDL for Tables, Views and Indexes -Update Stats statements for tables, columns, column distributions and indexes.<br><br>I have posted a similar query to the list a couple of days back with subject as " DDL Extraction for a table ' , and the recomendations were either to mine the system catalog, or opt for third party tools like ERwin, etc., [...]
11190 17 26_V6 to V7 with data sharing15_Mark Hardenburg30_mark.hardenburg@PRUDENTIAL.COM31_Tue, 27 May 2003 07:41:39 -0400313_us-ascii Carol,<br><br>When we had mixed V6/V7 we saw utility problems when V6 utilities tried to run on the V7 DB2 and vise versa. Our solution was to copy the V6 utility module (DSNUT610) to the V7 DB2 and to copy the V7 utility modules (DSNUT710 + about 25 others all starting with DSNU7*) to the V6 DB2. [...]
11208 37 39_Are COBOL programs supporting UNICODE ?12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 27 May 2003 14:04:42 +0200381_iso-8859-1 Fellow collegues,<br><br>it is annonced that DB2 for z/OS V8 comes along with UNICODE. I believe with the UNICODE UTF8 extension. Am I right ?<br><br>And another question in this area: Are "the good old" COBOL programs supporting UNICODE ? And if so what are any prerequisites to regard ?<br><br>Thanks in advance for any information you are willing to pass along. [...]
11246 125 51_Recovering DB2 System/Data objects using Checkpoint14_HENNAWI, SIRAJ33_sirajhennawi@SAUDIAIRLINES.COM.SA31_Tue, 27 May 2003 15:16:01 +0300482_windows-1256 <br><br>Dear list,<br><br>We are runnunig DB2 V6 / OS390 in datasharing mode that have 3 DB2 members. And we have some questions regarding Recovery and checkpoint hope we get answers to.<br><br>1- Can we use the DB2 System Checkpoint in recovering a single or all Application's Tablespaces ?<br><br>2- Is the System Ckeckpoint considered to be a synchronis point for all databases, like the Tablespace quiesce, as i believe checkpoint flush out BP pages to dasd ? [...]
11372 94 18_Re: Image copy B3710_Alice Frus16_FRUSA@BCBSIL.COM31_Tue, 27 May 2003 07:43:35 -0500418_us-ascii Most shops have a default set for the max number of tapes and the jcl for the tapes needs an override - maybe you hit that.<br><br><br><br><br><br>"Steve McAuliffe" <Stephen.McAuliffe@BANKOFA To: DB2-L@LISTSERV.YLASSOC.COM MERICA.COM> cc: Sent by: "DB2 Data Base Subject: Image copy B37 Discussion List" <DB2-L@LISTSERV.YLASSOC.CO M> 05/21/2003 11:15 AM Please respond to "DB2 Data Base Discussion List" [...]
11467 125 46_Re: DB2 Problem Determination Tutorials in PDF11_Grant Allen21_grant@TOWERSOFT.CO.UK31_Tue, 27 May 2003 14:15:12 +0100437_iso-8859-1 Thanks for this, Phil. I remember painstakingly saving each HTML page for my co-DBAs when I first spotted them. The PDFs are much more "transportable".<br><br>Ciao Fuzzy :-)<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Phil Gunning Sent: Monday, May 26, 2003 20:35 To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 Problem Determination Tutorials in PDF [...]
11593 24 24_DB2 Connect & DB2 OS/39018_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 27 May 2003 09:46:08 -0400324_iso-8859-1 Does anyone know if DB2 Connect version 8 will work with DB2 Version 6 OS/390?? If it does work with v6 OS/390 are there any drawbacks? I'm trying to make my business case for us upgrading to DB2 v7 OS/390 and we use DB2 Connect quite heaviliy. Right now we're on DB2 Connect v7.2 Fixpack 5 & DB2 OS/390 v6. [...]
11618 40 28_Re: DB2 Connect & DB2 OS/39013_Schulz Thomas20_thomas.schulz@SVI.DE31_Tue, 27 May 2003 16:09:42 +0200561_us-ascii Hello Stephen<br><br>i work at the moment on this and I had to install PQ57434, PQ62695 and PQ62139 to get it run.<br><br>Because Version 8 needs a few more funktions and procedures on DB2/390<br><br>Regards Thomas<br><br>"Whittaker, Stephen" schrieb: > > Does anyone know if DB2 Connect version 8 will work with DB2 Version 6 > OS/390?? > If it does work with v6 OS/390 are there any drawbacks? > I'm trying to make my business case for us upgrading to DB2 v7 OS/390 and > we use DB2 Connect quite > heaviliy. Right now we're on DB2 Connect v7.2 [...]
11659 170 30_Re: Active Logs ONLY up to 2GB22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Tue, 27 May 2003 10:04:58 -0500451_iso-8859-1 <br><br>I'm using full 3390-3 devices for my active log datasets (about 2.6G). But, Active Log Datasets do have a limit of 4G. So, you cannot allocate one full 3390-9 to one active log dataset. See link below for DB2 Limits.<br><br>http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnsqh12/A.0?DT=20020827<br><br>Venkatesh Mokshagundam Database Administrator Corporate Systems, Amarillo, TX 79102 Ph: 806-337-3374 Fax: 806-345-2736 [...]
11830 56 23_Re: Valid vs. Operative13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 27 May 2003 11:33:52 -0400516_UTF-8 Hello Rüdiger, David,<br><br>Perhaps I missed something in this discussion.<br><br>Operative=N is caused by, as the book says, "auto-bind failure." In my experience the most common occurrence of this has been something like drop/recreate of a table making a change which the application plan/package can't handle. For instance say you remove a column from the table which was used by the application. Re-BIND, auto- or manual will fail with -206 because the program references a column which is no more. [...]
11887 111 85_DB2 Connect v 8.1 Problem trying to use Control Center to OS390 Version db2 Version 715_Goldberg, Carol26_Carol.Goldberg@ACS-INC.COM31_Tue, 27 May 2003 12:16:42 -0400436_iso-8859-1 -----Original Message----- From: Goldberg, Carol Sent: Monday, May 19, 2003 1:15 PM To: 'DB2 Data Base Discussion List' Subject: RE: [DB2-L] DB2 Connect v 8.1 Problem trying to use .NET<br><br><br><br>I am trying to using the DB2 Control center using DB2 Connect version 8.1 to OS/390 version 7.0 database and am receiving a bind error on syssh200. I did some searched on google and found this may have to do with sqlj. [...]
11999 62 28_Re: DB2 Connect & DB2 OS/39012_Phil Gunning22_pgunning@GUNNINGTS.COM31_Tue, 27 May 2003 12:27:55 -0400804_iso-8859-1 Additional info.....Announcement number 202-15<br><br>----- Original Message ----- From: "Phil Gunning" <pgunning@gunningts.com> To: "DB2 Data Base Discussion List" <DB2-L@LISTSERV.YLASSOC.COM> Sent: Tuesday, May 27, 2003 12:26 PM Subject: Re: DB2 Connect & DB2 OS/390<br><br><br><br>> Yes it does. But check out the announcement and make sure you read the > release notes and test it out. > > http://www1.ibmlink.ibm.com/cgi-bin/master?xh=apEFC*qEbDyw7U2USenGnN9332&req > uest=announcements&parms=H%5F202%2D215&xhi=usa%2Emain&xfr=N > > > > > Phil > ----- Original Message ----- > From: "Whittaker, Stephen" <stephen.whittaker@PGNMAIL.COM> > Newsgroups: bit.listserv.db2-l > To: <DB2-L@LISTSERV.YLASSOC.COM> > Sent: Tuesday, May 27, 2003 9:46 AM > Subject: DB2 Connect & DB2 OS/390 > > > [...]
12062 49 28_Re: DB2 Connect & DB2 OS/39012_Phil Gunning22_pgunning@GUNNINGTS.COM31_Tue, 27 May 2003 12:26:20 -0400782_iso-8859-1 Yes it does. But check out the announcement and make sure you read the release notes and test it out.<br><br>http://www1.ibmlink.ibm.com/cgi-bin/master?xh=apEFC*qEbDyw7U2USenGnN9332&req uest=announcements&parms=H%5F202%2D215&xhi=usa%2Emain&xfr=N<br><br><br><br><br><br><br><br>Phil ----- Original Message ----- From: "Whittaker, Stephen" <stephen.whittaker@PGNMAIL.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Tuesday, May 27, 2003 9:46 AM Subject: DB2 Connect & DB2 OS/390<br><br><br><br>> Does anyone know if DB2 Connect version 8 will work with DB2 Version 6 > OS/390?? > If it does work with v6 OS/390 are there any drawbacks? > I'm trying to make my business case for us upgrading to DB2 v7 OS/390 and > we use DB2 Connect quite > [...]
12112 50 33_Re: DB2 connect Version 8 Testing15_Goldberg, Carol26_Carol.Goldberg@ACS-INC.COM31_Tue, 27 May 2003 12:28:49 -0400425_iso-8859-1 > -----Original Message----- > From: Goldberg, Carol > Sent: Thursday, May 22, 2003 11:22 AM > To: DB2-L@LISTSERV.YLASSOC.COM; Donahue, Heather; Hamilton, Yvonne > Subject: DB2 connect Version 8 Testing > > We are attempting to test version 8.1 of DB2 Connect with Power BuIlder > Version 8 release 9074. When attempting to connect to Powerbuilder we are > getting the following errors: > [ <<...OLE_Obj...>> [...]
12163 135 90_Re: DB2 Connect v 8.1 Problem trying to use Control Center to OS3 90 Version db2 Version 716_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 27 May 2003 12:47:12 -0400664_iso-8859-1 You can get good info on these from: http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/techlib_ v8.d2w/report<br><br><br><br>Regards, Eric Pearson NS ITO DB2 support<br><br><br><br>-----Original Message----- From: Goldberg, Carol [mailto:Carol.Goldberg@ACS-INC.COM] Sent: Tuesday, May 27, 2003 12:17 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 Connect v 8.1 Problem trying to use Control Center to OS390 Version db2 Version 7<br><br><br><br>-----Original Message----- From: Goldberg, Carol Sent: Monday, May 19, 2003 1:15 PM To: 'DB2 Data Base Discussion List' Subject: RE: [DB2-L] DB2 Connect v 8.1 Problem trying to use .NET [...]
12299 102 21_Quest Central for DB216_Aurora Dell'Anno28_Aurora.DellAnno@UK.QUEST.COM31_Tue, 27 May 2003 18:56:58 +0100557_iso-8859-1 Dear DB2 User,<br><br>You are invited to attend a live Web Conference using PlaceWare Web Conferencing.<br><br>Topic: Quest Central for DB2 Time: Thu, 29 May 2003, 11:00 AM Pacific Daylight Time (PDT) 08:00 PM Central European Time (CET)<br><br>Duration: 60 minutes Meeting URL (Address): http://www.placeware.com/cc/questm/A?id=QC%20for%20DB2&pw=621659<br><br>Audio Information: 877-629-3048 or 719-457-4140, Passcode: 748812<br><br><br><br>To add this meeting to your Outlook calendar, click the following URL or enter it in your browser: [...]
12402 21 12_DDF question13_Trace R Jones33_trace.jones@CENTERPOINTENERGY.COM31_Tue, 27 May 2003 13:09:39 -0500322_us-ascii We have DDF setup for 2 different subsystems. I have a user that has a program in database on one subsystem that is attempting to use DDF going across to another subsystem and pull data from a table in a database on that remote subsystem.<br><br>This user is constantly getting -805's no matter what we try. [...]
12424 52 34_SQLCODE examination: -911 and -91313_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Tue, 27 May 2003 14:51:46 -0400472_us-ascii Hey, gang -- Just back from IDUG; it was good to meet so many of you for the first time!<br><br>I just received an interesting question from one of my analysts: How does DB2 decide between issuing a -911 and -913 SQLCODE?<br><br>Examination of the Messages and Codes reveals that either one is issued for a deadlock or a timeout, with a Reason code revealing which of those is the cause. -911 reflects a rollback; -913 is issued when a rollback is not done. [...]
12477 55 16_Re: DDF question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 27 May 2003 14:30:34 -0400559_iso-8859-1 We do *lots* of this (many thousands of times per day).<br><br>1) Precompile 2) Compile 3) Link 4) Bind pacakge on 'local' subsystem using DBRM from 1) 5) Bind package on 'remote' subsystem using DBRM from 1) 6) Bind plan on 'local' subsystem with PKLIST(local.collid.*, remote.collid.*)<br><br><br><br><br><br><br><br>Regards, Eric Pearson<br><br><br><br><br><br>-----Original Message----- From: Trace R Jones [mailto:trace.jones@CENTERPOINTENERGY.COM] Sent: Tuesday, May 27, 2003 2:10 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DDF question [...]
12533 109 38_Re: SQLCODE examination: -911 and -91314_Dash, Sushanta21_sushanta.dash@EDS.COM31_Tue, 27 May 2003 15:19:09 -0500533_- Hi Here is the short answer and many more to come from experts. The major difference is the environment it works with. In non cics environment one can get -913 and 911 in CICS environment. -911 is seen within CICS environment and all the changes within UOR are rolled back where as in non cics environment the locks held by the SQL statement are released and other locks related to environment are held until the program rolls back or issues a commit for UOR and hence a -913 is issued. This is what I can say but do not know [...]
12643 19 61_June 9th - Pittsburgh DB2 Users Group Meeting - RSVP Reminder10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Tue, 27 May 2003 16:39:29 -0400349_US-ASCII Just a reminder, the FREE RUG event is happening on June 9th & is open to anyone to attend. The agenda is available via the PA DB2 RUG website at http://www.db2parug.org. Please email Cathy.Peck@Highmark.Com to register your attendance. Looking forward to seeing everyone for one more RUG meeting before summer offically starts! Seeya [...]
12663 23 68_June 11th - 12th - Bonnie Baker Classes - Central PA - RSVP Reminder10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Tue, 27 May 2003 16:41:51 -0400509_US-ASCII Just a reminder to those interested that have not yet RSVP'ed their attendance.<br><br>The Central PA DB2 Users Group has the pleasure of hosting Bonnie Baker as she returns to Central PA to do a repeat of her famous DB2 classroom series 'Things I Wish Someone Had Told Me....' Part I & Part II. If you are interested, please RSVP to Cathy.Peck@Highmark.Com. If you have any questions, please contact Cathy Peck or check out the class abstracts on the PA DB2 RUG website http://www.db2parug.org [...]
12687 69 38_Re: SQLCODE examination: -911 and -9139_Agus Kwee13_askwe@ATT.NET31_Tue, 27 May 2003 16:43:53 -0400231_iso-8859-1 Phil,<br><br>SQLCODE -913 is an option that is requested in CICS Definition : CEDA DEFINE DB2CONN or DB2ENTRY drollback=no (deadlock rollback=no)<br><br>Regards, Agus Kwee Themis Training http://www.themisinc.com<br><br>
12757 19 62_June 10th - Central PA DB2 Users Group Meeting - RSVP Reminder10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Tue, 27 May 2003 16:39:41 -0400350_US-ASCII Just a reminder, the FREE RUG event is happening on June 10th & is open to anyone to attend. The agenda is available via the PA DB2 RUG website at http://www.db2parug.org. Please email Cathy.Peck@Highmark.Com to register your attendance. Looking forward to seeing everyone for one more RUG meeting before summer offically starts! Seeya [...]
12777 74 35_Re: Decreasing LEAFDIST after REORG32_Poston, William L (COMFIN, ITSS)21_william.poston@GE.COM31_Tue, 27 May 2003 17:09:48 -0400582_iso-8859-1 How can you reduce leafdist to decrease how often you reorg? Adding free pages?<br><br>-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Tuesday, May 27, 2003 1:31 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DDF question<br><br><br><br>We do *lots* of this (many thousands of times per day).<br><br>1) Precompile 2) Compile 3) Link 4) Bind pacakge on 'local' subsystem using DBRM from 1) 5) Bind package on 'remote' subsystem using DBRM from 1) 6) Bind plan on 'local' subsystem with PKLIST(local.collid.*, remote.collid.*) [...]
12852 126 29_Portland, Oregon NODE Meeting24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 27 May 2003 14:27:47 -0700627_- Hi Everyone in the Northern Oregon and Southern Washington areas!<br><br>It's time again for the bi-monthly NODE Regional user group meeting which will be held on June 2, from 1:30 until 4:00 PM at the Lloyd Center Tower 700 building. The address and directions are listed below.<br><br>Our guest speaker for this meeting is Vivian Holman of Lightyear Consulting. She specializes in DB2, Data Management Tools, and Application Development Tools. She'll have 2 presentations with a short break between them. The first presentation will be a review of DB2 V7 and DB2 V8 --- highlighting features and reasons for migrating [...]
12979 102 35_Re: Decreasing LEAFDIST after REORG14_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM31_Tue, 27 May 2003 22:40:00 +0100432_us-ascii Please see the archives. In summary: if you use FREEPAGE > 0 then LEAFDIST > 200 is very approximately when more than half the freepages have been used up and is not a bad rule. If FREEPAGE = 0 then LEAFDIST > NLEAF is a better criterion - it means that about 1% of index pages have been split. For large indexes with FREEPAGE=0 using LEAFDIST > 200 as a reorg criterion will end up reorganising them *far* too often. [...]
13082 18 43_Re: Are COBOL programs supporting UNICODE ?12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 27 May 2003 18:57:53 -0500399_- DB2 UDB for z/OS Version 8 extends support for UTF-8 and UTF-16 beyond what we did in Verion 7. I suggest that you check section 6.2 of the redbook, SG24-6871, DB2 UDB for z/OS Version 8 Technical Preview http://www.ibm.com/software/data/db2/os390/db2zosv8.html<br><br>Enterprise COBOL has also been extended to support Unicode, XML, ... http://www.ibm.com/software/awdtools/cobol/zos/about/ [...]
13101 36 34_Re: DB2 V7 UNICODE DATA CORRUPTION12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 27 May 2003 19:22:09 -0500390_- The places where we have posted warnings about translations and suggested techniques have included the Program Directory, the Installation Guide, several postings on DB2-L, information APARs (II13048 and II13049) and presentations about install and Unicode. The warnings have been there for a couple of years in most cases. Do you have suggestions for other places to have warnings? [...]
13138 14 27_Re: Encrypt Data in Storage12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 27 May 2003 20:24:50 -0500450_- You are not likely to see much V8 function, including this, as a V7 APAR. Our concerns for keeping the quality up are very high, with more than half of customer work on V7.<br><br>Roger Miller<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
13153 13 28_Re: FW: Old packages redbook12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 27 May 2003 20:30:08 -0500411_- I'm ok with emailing it, but would need to do some checking before posting, and there is no time to do the checking. I sent it again.<br><br>Roger Miller<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
13167 23 30_Re: V6 to V7 with data sharing12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 27 May 2003 20:46:28 -0500506_- As others noted, running in coexistence mode can be more complex, and thus possibly more error prone. I would twist on your arm to reread the section of the Data Sharing: Planning & Administration book titled, Considerations for mixed releases in a data sharing group<br><br>That is Acrobat pages 99 - 109 in dsndsh12.pdf, the current version. Do get the latest from the web (October 2002 now, but another update is in the works). http://publib.boulder.ibm.com/cgi-bin/bookmgr/download/dsndsh12.pdf [...]
13191 212 16_Re: SQL Question11_James Szabo18_jim.szabo@CORE.COM31_Tue, 27 May 2003 23:22:19 -0400684_Windows-1252 Don't you have to check to see if the column has the NULL attribute and add +1 to the column length?<br><br>----- Original Message ----- From: "Alekos Papadopoulos" <apapad@NBG.GR> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Monday, May 26, 2003 7:55 AM Subject: Re: SQL Question<br><br><br><br>> Buongiorno Vincenzo, > > I personally use something more complicated instead of just sum for the > keylength: > > SUM(CASE F.COLTYPE WHEN 'DECIMAL' THEN INTEGER((F.LENGTH+2)/2) > WHEN 'VARCHAR' THEN F.LENGTH+4 > WHEN 'INTEGER' THEN 4 > WHEN 'SMALLINT' THEN 2 > WHEN 'FLOAT' THEN 4+4*INTEGER(F.LENGTH/21) > ELSE F.LENGTH END) AS KEYLEN > > Not [...]
13404 51 27_AW: Re: Valid vs. Operative39_=?utf-8?Q?=22Kurtz=2C_R=C3=BCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Wed, 28 May 2003 07:07:37 +0200343_utf-8 David,<br><br>what you describe is exactly what makes me wonder: Dropping a table because a column had to be removed from it caused the Bind to fail - expectedly - with a -206, Operative, however, remained Y'. I would have expected Operative to be set to 'N' because - as you say - the program references a column which is no more. [...]
13456 71 16_Re: DDF question13_Michael Ebert18_mebert@AMADEUS.NET31_Wed, 28 May 2003 09:23:35 +0200359_us-ascii I got this too some time ago, even when the package definitely existed on the remote subsystem (with the proper contoken). I finally puzzled it out: you have to specify the location in the PKLIST of the BIND PLAN command, either explicitely or as *, e.g. for SPUFI:<br><br>BIND PLAN(DSNESPCS) PKLIST(*.DSNESPCS.*) ACT(REP) ISO(CS) SQLRULES(DB2) [...]
13528 116 55_Re: Recovering DB2 System/Data objects using Checkpoint19_Alekos Papadopoulos13_apapad@NBG.GR31_Wed, 28 May 2003 10:48:21 +0200449_iso-8859-7 Hello Siraj,<br><br>It has been discussed in the past, but a short answer in your q1 and q2 is 'No, Checkpoint is not a Quiesce point - there might be "active" transactions at that time'. About your 3rd question, see for example http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg245343.pdf (a redbook on SAP disaster recovery), chapter 4.4.1.1 Establishing a Point of Consistency (archive log mode(quiesce) might fit to your needs ?) [...]
13645 63 20_DB2 8.1 on HP-UX 11i3_A N19_goodmatri@YAHOO.COM31_Wed, 28 May 2003 01:04:28 -0700444_us-ascii Hi All,<br><br>I'm trying to install DB2 8.1 on HP-UX 11i and am running into problems with instance creation. The installation minus the instance creation goes fine. After it has finished, I have tried both these approaches:<br><br>1) via db2isetup GUI (which creates the users/groups and internally calls) 2) db2icrt<br><br>and both fail, giving me a DBI1281E (The database manager configuration file could not be initialized). [...]
13709 57 34_SYSDBASE UNAVAILABLE DURING REBIND12_Cuneyt GOKSU19_cuneytgoksu@USA.NET31_Wed, 28 May 2003 11:16:27 +0300510_ISO-8859-1 Hi,<br><br>Do you have some transactions running Dynamic SQL?<br><br>I have seen similar problem in one of my clients and it's because of some long running Dynamic SQL with wrong BIND parameters.<br><br>My AutoBIND rexx was failing with timeout during rebind because of those dynamic sql transactions.<br><br>I hope it helps.<br><br>Regards, Cuneyt GOKSU<br><br>Date: Mon, 26 May 2003 10:07:17 +0200 From: Di Franco Vincenzo <difrancov@ISIDE.BCC.IT> Subject: SYSDBASE UNAVAILABLE DURING REBIND [...]
13767 22 55_how to detect that the dynamic sql plan is no more used17_Christophe Radier17_c300501@YAHOO.COM31_Wed, 28 May 2003 04:16:25 -0500419_- Hi all,<br><br>We have about 7 plans for DSNTEP2 , as the former admin created one for each version (they are all using the same -current version's- package) I've changed all the job to use only the plan DSNTEP2 , without version number associated - but i can miss some ... I want to free all the plans associated with a version number - But i'm afraid that some are used and will have production's job failed - [...]
13790 48 52_SAP BW & DB2 V6 on OS390 & DSNUTILS Stored Procedure12_Alex Andrade26_alex.andrade@UK.ZURICH.COM31_Wed, 28 May 2003 05:59:57 -0500518_- Good Afternoon/Evening/Morning where appropriate<br><br>Ok heres the scenario :<br><br>1) SAP 4.6D BW on AIX 2) Databse component on DB2 V6 on OS390 2.10 3) OMVS/USS somewhere in the equation (ILCI's i presume) 4) SAP Main plan FOMEP46D has "DSNUTILS" collection included<br><br>On occasions, when SAP aggregate processing - whatever that is ! - is occurring. SAP will drop and recreate indexes which i have assumed are created with the DEFER(YES) option because all the IX's are in the "REBUILD PENDING" state [...]
13839 22 8_Explains13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM31_Wed, 28 May 2003 06:44:16 -0500409_US-ASCII Anybody have any opinions, advice, etc on binding with explain yes in a production OS/390 DB2 V7 environment? I know the Admin book say overhead will be slight, but I remember in class an instructor saying it wasn't a good idea to bind with explain yes in production depending on the number and type of monitors you are running because the monitor will cause significant overhead on DB2 behalf. [...]
13862 15 35_admin guide / user reference manual18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Wed, 28 May 2003 07:00:58 -0500341_- Hi all,<br><br>Want to download DB2 manuals....any directions please?<br><br>TIA /R<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
13878 79 16_Answer: Explains12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 28 May 2003 14:20:04 +0200365_iso-8859-1 Kathy,<br><br>we're binding our production packages (more than 11400 pieces) and plans (more than 890 pieces) always with EXPLAIN(yes).<br><br>The reason for us: Doing so ensures that we have an accurate recording of the access paths details for all our production programms that can be examinated in the (hopely rare) case of performance problems. [...]
13958 43 12_Re: Explains15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Wed, 28 May 2003 08:29:42 -0400381_iso-8859-1 We perform binds with explain yes on every production move that occurs. We also actually review each explain output and archive the bind output to a PDS.<br><br>One bad query can cost you a small fortune, so we feel the minimal over-head is well worth our efforts. I'm not aware of any significant monitoring over-head - maybe someone on the list can enlighten us? [...]
14002 36 39_Re: admin guide / user reference manual11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Wed, 28 May 2003 08:05:13 -0500476_iso-8859-1 If you're talking DB2 for z/OS, just go to http://www-3.ibm.com/software/data/db2/os390/library.html, select the release you want. You can either select it and then do 'File' then 'Save', or you can right click the pdf icon and save it that way.<br><br>Tina<br><br>-----Original Message----- From: Rajendra Deshpande [mailto:rajendra_deshpande@HOTMAIL.COM] Sent: May 28, 2003 7:01 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: admin guide / user reference manual [...]
14039 55 39_Re: admin guide / user reference manual15_Patrick McManus26_pmcmanus@NOTES.STATE.NE.US31_Wed, 28 May 2003 08:06:09 -0500540_US-ASCII (Embedded image moved to file: pic00153.jpg)<br><br>Thanks,<br><br>Patrick McManus Systems DBA Database Management Group State of Nebraska - IM Services Phone: (402) 471- 8050 e-mail pmcmanus@notes.state.ne.us<br><br><br><br><br><br><br><br>Rajendra Deshpande <rajendra_deshpande@H To: DB2-L@LISTSERV.YLASSOC.COM OTMAIL.COM> cc: Sent by: DB2 Data Subject: admin guide / user reference manual Base Discussion List <DB2-L@LISTSERV.YLASS OC.COM><br><br><br><br>05/28/2003 07:00 AM Please respond to DB2 Data Base Discussion List [...]
14095 45 59_Re: how to detect that the dynamic sql plan is no more used11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Wed, 28 May 2003 08:17:14 -0500440_iso-8859-1 You can get this data from SMF if you have the correct traces running. We use a program from our monitor (BMC Mainview) that reads the SMF data and loads it into tables. I then searched those tables and was able to find every job and authid that executed the plans with the release number on the end. After warning these people for a few weeks and verifying no production had used it in a while, then I freed the old plans. [...]
14141 143 38_Re: SQLCODE examination: -911 and -91315_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Wed, 28 May 2003 09:37:44 -0500557_iso-8859-1 Hi, Phil, According to the DB2 application programming and SQL manual for V7 (SC26-9933-02), it depends. For TSO, CAF or batch connections, DB2 will attempt to rollback the unit of work. If it succeeds, then a -911 is issued. If it doesn't, then a -913 is issued, assuming that the application did not abend. For an IMS connection (don't even ask me any more about IMS because I won't know the answer), you can get a -911 when IMS rolls back the unit of work on the application's behalf. For CICS, it depends on what is defined in the ROLBE [...]
14285 204 27_Fw: DB2 Text Extender 7.1.012_Hamid Alvani22_alvani@DPI2.DPI.NET.IR31_Wed, 28 May 2003 18:27:30 -0700409_iso-8859-1 <br><br>----- Original Message ----- From: Hamid Alvani To: DB2 Sent: Sunday, May 25, 2003 10:47 AM Subject: DB2 Text Extender 7.1.0<br><br><br><br>Hi all experts; For DB2 Text Extender 7.1.0 activation and customization, in OMVS i start search service controller (txstart) and i enter db2tx . then db2tx prompt appears, connection to database complete successfully: db2tx => connect to os390 [...]
14490 123 12_Re: Explains13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 28 May 2003 11:03:57 -0400401_us-ascii Kathy,<br><br>We routinely bind our production plans with EXPLAIN(YES). I can't imagine taking the risks involved with an unEXPLAINed production plan.<br><br>We use STROBE, and the CA-INSIGHT for DB2 subsystem monitor, and have not noticed any problems with performance relating to the combination of a monitor and an EXPLAIN(YES) bind (on the other hand, we also haven't been looking). [...]
14614 79 44_stored procedure with a unicode parameter(s)6_Daniel15_bufes@YAHOO.COM31_Wed, 28 May 2003 09:59:09 -0500594_- Hi, Has anyone implemented a stored procedure that works with unicode variables/data on DB2 for OS/390 v7? I would like to pass a character string to a stored procedure and the stored procedure should insert the value into a unicode table. How difficult could that be, one could ask. Is Stored Procedure Builder (or Development Center) capable of creating and calling such stored procedure? How can I pass a unicode string literal to it? Do you know of any sample code/application (working with unicode data) that I can use as an example? My attemts: 1.) when literal is hard-coded into [...]
14694 47 38_Re: SQLCODE examination: -911 and -91313_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 28 May 2003 11:13:34 -0400317_us-ascii I have, I think, what I need from this. Many thanks to all of you who contributed:<br><br>Bob Y., Sushanta, Agus, Linda B.<br><br>--Phil Sevetson phil.sevetson@wakefern.com Database Administration Wakefern Food Corporation 230 Raritan Center Parkway Edison, NJ 08837 Phone: (732) 225-8086 Fax: (732) 225-8109
14742 89 34_Re: DB2 V7 UNICODE DATA CORRUPTION10_Tom Taylor17_ttaylor@CHUBB.COM31_Wed, 28 May 2003 11:13:07 -0400592_us-ascii Roger<br><br>We have read all information about DB2 and UNICODE,,,,, Whats not clear is how DB2 interfaces with ICONV and UNICODE system services. DB2 UDB CLIENT CODE V7 has an undocumented installation default that automatically flows UNICODE to a DB2 V7 host, the V7 host by default accepts it. The host documentation implies that having UNOICODE is an optional feature but provides NO way to turn it off. We were unware of these processes until it was to late. ICONV has problems and IBM refuses to fix them... there stance is to move to UNICODE systems services. We are now [...]
14832 223 102_June 17 New England DB2 Users Group Meeting--Sturbridge Host Hotel (Annual Picnic by the Lake Meeting)14_Mark McCormack27_mamccormack@STATESTREET.COM31_Wed, 28 May 2003 11:26:59 -0400598_iso-8859-1 Here we go again! Let's hope the weather gods smile favorably on June 17 (and, yes, I will be emphasizing to the hotel that we want an OUTDOOR picnic this year). The meeting will be held on Tuesday, June 17, from 8AM (registration; meeting starts at 9) to 3:30PM, at the Sturbridge Host Hotel, Route 20, Sturbridge, MA. Please join us to hear 2 interesting user experiences and a timely vendor overview of the DB2 family platform similarities and differences (with a peek at Performance Tuning/Monitoring parallels). Also, our roving reporter at IDUG, Ed Long, will fill us in with [...]
15056 197 12_Re: Explains11_David Nance16_DWNance@FHSC.COM31_Wed, 28 May 2003 11:27:25 -0400397_US-ASCII Besides the overhead of explain(YES) is only during the bind process. It has no affect whatsoever on actual execution of the program. Is it that important on binding production programs, not to take the few extra milliseconds to populate a plan table?<br><br>Dave Nance First Health Services, Corp. (804)527-6841<br><br><br><br>>>> Phil.Sevetson@WAKEFERN.COM 5/28/03 11:03:57 AM >>> [...]
15254 34 39_Re: admin guide / user reference manual10_Jwkwan200025_jwkwan2000@HOUSTON.RR.COM31_Wed, 28 May 2003 10:40:35 -0500673_iso-8859-1 www-3.ibm.com/software/data/db2/os390/v7books.html<br><br>James Kwan ----- Original Message ----- From: "Rajendra Deshpande" <rajendra_deshpande@HOTMAIL.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@LISTSERV.YLASSOC.COM> Sent: Wednesday, May 28, 2003 7:00 AM Subject: admin guide / user reference manual<br><br><br><br>> Hi all, > > Want to download DB2 manuals....any directions please? > > TIA > /R > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...]
15289 43 34_Re: DB2 V7 UNICODE DATA CORRUPTION6_Daniel15_bufes@YAHOO.COM31_Wed, 28 May 2003 10:33:11 -0500605_- On Wed, 28 May 2003 11:13:07 -0400, Tom Taylor <ttaylor@CHUBB.COM> wrote:<br><br>>Roger > >We have read all information about DB2 and UNICODE,,,,, Whats not clear is >how DB2 interfaces with ICONV and UNICODE system services. DB2 UDB CLIENT >CODE V7 has an undocumented installation default that automatically flows >UNICODE to a DB2 V7 host, the V7 host by default accepts it. The host >documentation implies that having UNOICODE is an optional feature but >provides NO way to turn it off. We were unware of these processes until it >was to late. ICONV has problems and IBM refuses to fix them... [...]
15333 29 10_Bind Error16_Lewer, Brad (B.)18_blewer@VISTEON.COM31_Wed, 28 May 2003 11:53:44 -0400417_iso-8859-1 Please help.. following is the error we are receiving when trying to Bind. READY DSN SYSTEM(DB2I) RETRY(10) DSN BIND PLAN(GABC009A) PKLIST(GDB2I.*) VALIDATE(BIND) RETAIN EXPLAIN(NO) QUALIFIER(VSU@ALL) OWNER(VSU@ALL) DSNT241I -DB2I BIND AUTHORIZATION ERROR ON PLAN GABC009A AUTHORIZATION-ID VSU@ALL NOT AUTHORIZED TO EXECUTE PACKAGE GDB2I.* DSNT201I -DB2I BIND FOR PLAN GABC009A NOT SUCCESSFUL DSN END [...]
15363 71 34_Re: DB2 V7 UNICODE DATA CORRUPTION10_Tom Taylor17_ttaylor@CHUBB.COM31_Wed, 28 May 2003 12:09:15 -0400377_us-ascii Dan event though UNICODE system services is not installed...ICONV is ... it is part of LE cobol.... When unicode comes from a client.... the sysibm.systrings lookup will be bypassed..... Unicode system services is checked next..... if it's not configured.... then it looks for ICONV....which has problems. This is what we understand to be the functional path.... [...]
15435 33 59_Re: how to detect that the dynamic sql plan is no more used33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Wed, 28 May 2003 11:07:21 -0500449_- Tina<br><br>I see, you are also using BMC to extract SMF-data to load it into DB2 tables. We recently migrated from CANDLE to BMC, but I have great trouble with that. Yesterday I ran the batch job I got from BMC to read the SMF file of one day's DB2 production work. The job ran for 14 hours, yes nobody can imagine that big number, 14 hours. How are your experiences with that. Do you also read a whole day's work or just a couple of hours. [...]
15469 45 47_DB2 Connect NULLID packages - more info on them10_Dev DBA SL24_db2_dba@STANDARDLIFE.COM31_Wed, 28 May 2003 17:17:11 +0100555_us-ascii We've been experimenting with invoking Cobol Stored Procedures on DB2 OS/390 v6.1 via JDBC from NT workstations using DB2 Connect 7.2. This has been working OK for most people and when I trace it I find a package called NULLID.SQLL7D04 is executed prior to the Stored Procedure call but must do an incremental bind first (rebinding the statement that actually calls the Stored Procedure). No real problem but would like confirmation that that is what should be happening. (I was bit alarmed at the overhead of an incremental bind at first). [...]
15515 61 14_Re: Bind Error12_michael bell24_mbell11@WORLDNET.ATT.NET31_Wed, 28 May 2003 12:05:02 -0500352_iso-8859-1 The owner id must have the correct authorization for the bind - from the manual it must be Authorization ID of the process must include one of the following:<br><br>° EXECUTE authority on each package specified in the PKLIST ° PACKADM authority on specific collections that contain the packages or on all collections ° SYSADM authority [...]
15577 108 46_Re: DB2 Problem Determination Tutorials in PDF11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Wed, 28 May 2003 10:05:13 -0700432_- Phil, is there a web page for a real DB2 (ZOS OS/390)? cliff;-)<br><br>-----Original Message----- From: Phil Gunning [mailto:pgunning@GUNNINGTS.COM] Sent: Monday, May 26, 2003 12:35 PM To: DB2-L@listserv.ylassoc.com Subject: DB2 Problem Determination Tutorials in PDF<br><br><br><br>FYI. Download these tutorials in PDF. This is a recent change as previously in V8.1 they were only available in html. This is good info. Phil [...]
15686 48 14_Re: Bind Error12_Carlos Olson14_COlson@QRS.COM31_Wed, 28 May 2003 10:23:36 -0700732_iso-8859-1 SET CURRENT SQLID = 'something appropriate'; GRANT EXECUTE ON PACKAGE GDB2I.* TO VSU@ALL;<br><br>Carlos Olson QRS Corporation<br><br>-----Original Message----- From: Lewer, Brad (B.) [mailto:blewer@VISTEON.COM] Sent: Wednesday, May 28, 2003 8:54 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Bind Error<br><br><br><br>Please help.. following is the error we are receiving when trying to Bind. READY DSN SYSTEM(DB2I) RETRY(10) DSN BIND PLAN(GABC009A) PKLIST(GDB2I.*) VALIDATE(BIND) RETAIN EXPLAIN(NO) QUALIFIER(VSU@ALL) OWNER(VSU@ALL) DSNT241I -DB2I BIND AUTHORIZATION ERROR ON PLAN GABC009A AUTHORIZATION-ID VSU@ALL NOT AUTHORIZED TO EXECUTE PACKAGE GDB2I.* DSNT201I -DB2I BIND FOR PLAN GABC009A NOT SUCCESSFUL DSN END [...]
15735 42 56_Once again - question about column sequence in the index19_Luiz Roberto FORONI27_lforoni@CAIXASEGUROS.COM.BR31_Wed, 28 May 2003 14:34:20 -0300368_iso-8859-1 Hi listers,<br><br>I have a question about the numerical position of a column in an index.<br><br>Talking with a sqlserver DBA , he told me he puts the column with the greatest number of distinct values at the first , to create an index, to improve the performance.<br><br>I've never seen some reference about that in any book of DB2, since version 2. [...]
15778 58 46_Re: DB2 Problem Determination Tutorials in PDF12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 28 May 2003 10:44:45 -0700773_us-ascii No. Real Sysprogs already know everything...<br><br><br><br>--- Cliff Boley <Maurice.C.BOLEY@ODOT.STATE.OR.US> wrote: > Phil, > is there a web page for a real DB2 (ZOS OS/390)? > cliff;-) > > -----Original Message----- > From: Phil Gunning [mailto:pgunning@GUNNINGTS.COM] > Sent: Monday, May 26, 2003 12:35 PM > To: DB2-L@listserv.ylassoc.com > Subject: DB2 Problem Determination Tutorials in PDF > > > FYI. Download these tutorials in PDF. This is a > recent change as previously > in V8.1 they were only available in html. This is > good info. Phil > > > http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/newslett > er.d2w/n20030421 > <http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/newslet > ter.d2w/n20030421> > > > [...]
15837 30 60_Re: Once again - question about column sequence in the index9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 28 May 2003 12:58:07 -0500367_- Index design issues are a bit more complex than that and the answer is "it depends".<br><br>If your index columns exactly match your where clause and all of the comparisons are equal, then ordering the columns in the index from most distinct values to least can give the optimizer better filter factors and access to the row you want will likely be very fast. [...]
15868 76 51_Re: DB2 Connect NULLID packages - more info on them16_Swinski, Kenneth23_KSwinski@MASSMUTUAL.COM31_Wed, 28 May 2003 14:21:31 -0400585_us-ascii I don't have any solutions, just some experiences to share. When some of our clients attempted to run Crystal Reports against a DB2 AIX v 7.2 database, the incremental binds of the NULLID packages started happening. In the test database, the "LAST_BIND_TIME" on the NULLID packages was changing regularly. In the production database, we had not granted bindadd to the public, so they'd get an authorization pop-up. When I granted control on all the "NULLID" packages to public in production, the pop-ups went away and yet the LAST_BIND_TIME isn't changing. Very strange. [...]
15945 173 60_Re: Once again - question about column sequence in the index13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 28 May 2003 14:29:30 -0400396_iso-8859-1 The quickie answer is that you can use the COLCARD options in the RUNSTATS utility to enable DB2 to consider more than the first column of an index for cardinality. For example, if you specify COLCARD 2, then DB2 will consider the cardinality of the first and second columns, as well as considering the cardinality of the first column only, when deciding what access path to use. [...]
16119 83 59_Re: how to detect that the dynamic sql plan is no more used11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Wed, 28 May 2003 13:27:04 -0500517_iso-8859-1 Wow. You obviously have much more DB2 activity than we do. We have 3 lpars and I keep them all separate. For 2 of the lpars, our SMF dump job puts the DB2 records in a separate dataset so I don't have to go through all of them. A whole day fits on one tape for each lpar and at most takes 2 hours to do the extract, summarizing, and loading. I don't load the daily information, just the summary (by hour and by day), to reduce disk space used by the tables. I have recently started loading daily data [...]
16203 61 60_Re: Once again - question about column sequence in the index19_Luiz Roberto FORONI27_lforoni@CAIXASEGUROS.COM.BR31_Wed, 28 May 2003 15:55:36 -0300522_us-ascii Jim, In case of full match columns the filter factor wouldn't be the same ? 1 divided by total of rows pointed by the index (fullkeycardf). ---------------------- Encaminhado por Luiz R Foroni/MATRIZ/SASSE em 28/05/2003 15:52 ---------------------------<br><br><br><br>Jim Ruddy <jaruddy@US.IBM.COM>@LISTSERV.YLASSOC.COM> em 28/05/2003 14:58:07<br><br>Favor responder a DB2 Data Base Discussion List <DB2-L@LISTSERV.YLASSOC.COM><br><br>Enviado Por: DB2 Data Base Discussion List <DB2-L@LISTSERV.YLASSOC.COM> [...]
16265 185 59_Re: how to detect that the dynamic sql plan is no more used13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 28 May 2003 15:11:11 -0400601_iso-8859-1 Walter,<br><br>When dealing with SMF records many years ago, I _always_ made a practice of excluding any records I didn't need for the immediate analysis in which I was engaged. SYNCSORT/DFSORT/ICEMAN will let you exclude record based on types, times, and anything else you can find in the fixed portion of the SMF record layout. Run the Sort program with INCLUDE or OMIT specified (can you specify both in recent releases?) and discard anything you won't be using. This should radically reduce your input dataset size for most analyses -- I can't swear to it for yours, since I don't [...]
16451 143 60_Re: Once again - question about column sequence in the index19_Luiz Roberto FORONI27_lforoni@CAIXASEGUROS.COM.BR31_Wed, 28 May 2003 16:12:05 -0300512_iso-8859-1 Phil ,<br><br>when I run RUNSTATS UTILITY in version 5 , I have already gotten COLCARD fol all nonindexed columns by the option COLUMN ALL.<br><br>I don't know if prior versions had this option. ---------------------- Encaminhado por Luiz R Foroni/MATRIZ/SASSE em 28/05/2003 16:03 ---------------------------<br><br><br><br>Phil Sevetson <Phil.Sevetson@WAKEFERN.COM>@LISTSERV.YLASSOC.COM> em 28/05/2003 15:29:30<br><br>Favor responder a DB2 Data Base Discussion List <DB2-L@LISTSERV.YLASSOC.COM> [...]
16595 62 12_Re: Explains12_Rohn Solecki19_rohnski@HOTMAIL.COM31_Wed, 28 May 2003 14:06:40 -0500582_iso-8859-1 <snip> but I remember in class an instructor saying it wasn't a good idea to bind with explain yes in production depending on the number and type of monitors you are running because the monitor will cause significant overhead on DB2 behalf. <end snip><br><br>That sounds like one of those vague warnings that refer to a very explicit situation that occurred in the past, and has probably been fixed with patches or was applicable in prior versions of DB2 and/or 3rd party monitors. It sounds like a variation of "... if it ain't broke, don't fix it..." when used by [...]
16658 96 20_Re: Answer: Explains15_Libby, D.A.@EDD17_DLibby@EDD.CA.GOV31_Wed, 28 May 2003 13:03:07 -0700626_iso-8859-1 here you are tran, since i saw you working on the plan_tables...<br><br><br><br>-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Wednesday, May 28, 2003 5:20 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Answer: Explains<br><br><br><br>Kathy,<br><br>we're binding our production packages (more than 11400 pieces) and plans (more than 890 pieces) always with EXPLAIN(yes).<br><br>The reason for us: Doing so ensures that we have an accurate recording of the access paths details for all our production programms that can be examinated in the (hopely rare) case of performance problems. [...]
16755 43 12_Re: Explains10_Dale Smock28_Dale.Smock@ARVATOSYSTEMS.COM31_Wed, 28 May 2003 16:11:25 -0500436_iso-8859-1 I have not experienced or heard of any actual performance related issues with monitors and Explain Yes. The only possible performance concern I am aware of, would be additional overhead for large online plans during an autobind. We try to avoid those by rebinding affected plans/packages when making DDL changes instead of allowing them to autobind. If that becomes a problem, it can be disabled with a zparm parameter. [...]
16799 24 45_User defined functions list in control center23_Leedom, Robert W (ITSC)26_Robert.Leedom@MAIL.IHS.GOV31_Wed, 28 May 2003 14:32:07 -0600345_iso-8859-1 We seem to have a issue where the programming staff sees only a subset of the available user defined functions thru the control center. When pulled up via a SYSADM id the entire list appears. What is required to allow the programming staff to see all user defined functions thru the control center? This is DB2 UDB V7.2 for AIX. [...]
16824 226 60_Re: Once again - question about column sequence in the index13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 28 May 2003 18:44:14 -0400553_iso-8859-1 Luiz,<br><br>Arrgh! My error.<br><br>The term I meant to use is KEYCARD -- it's a "correlation" term found in the RUNSTATS INDEX syntax. It's different from COLCARD because (a) it's a term in a utility statement, not a column name, and (b) it specifies a way to collect cardinality for _combinations_ of columns, not for single columns. Check it out. For indexes whose highest-cardinality column is _not_ the first column, whose first n columns have low cardinality, it's a way to tell DB2 that there _is_ high cardinality in the index. [...]