1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2000, week 3
2 45 38_Unable to treminate an UTILITY stopped28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Sat, 15 Jan 2000 00:03:10 PST300_- I will look into why a DROP is possible in a UIP state. Meanwhile...
If and only if the object is dropped, and you don't want *ANY* cleanup action taken by -TERM, you can make any SYSUTILX record "termable" by using REPAIR REPLACE to "nullify" the SYSUTILX record, then -TERM it again. [...]
48 71 68_Re: Using working storage variable on both side of the where clau se14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sun, 16 Jan 2000 02:58:33 +1000785_us-ascii The index matching would be disabled with an 'OR' alternative:
select columns_value from some_table where :ws-variable-1 = :ws-variable-2 OR (table_key_column = :ws-key-value etc. )
From: Michael Hannan
>Return-Path: >Newsgroups: bit.listserv.db2-l >Date: Fri, 14 Jan 2000 10:34:06 +1100 >Reply-To: DB2 Data Base Discussion List >Sender: DB2 Data Base Discussion List >From: "Purcell, Terry" >Subject: Re: Using working storage variable on both side of the where clau > se >To: DB2-L@RYCI.COM > >No, the ":ws1 = :ws2" clause will treated as any other stage 2 predicate. > >Regards >Terry Purcell >CPT Consulting > >> -----Original Message----- >> From: [...]
120 54 38_Turning Correlated Subqueries to Views14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sun, 16 Jan 2000 02:58:57 +1000338_us-ascii Converting EXISTS type correlated subqueries into joins ins't so hard. The correlation predicates become join predicates.
If you have nested correlated subqueries and some are of of negative variety, e.g. NOT EXISTS, NOT IN, NOT = (subq), etc. then it gets much harder to convert to joins but usually still possible. [...]
175 117 17_Re: REXX doubt...17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM31_Sat, 15 Jan 2000 11:19:44 -0500566_- The following REXX exec and JCL works for me to edit a file using an edit macro in batch (you'll have to substitute the appropriate library names for your installation):
/*.REXX EXEC */ /*.*******************************************************************/ /*.EDITFILE: EDIT A DATASET USING AN INITIAL EDIT MACRO */ /*.*******************************************************************/ TRACE OFF ARG EDITFILE EDITMACRO EDITFILE = STRIP(EDITFILE,B) EDITMACRO = STRIP(EDITMACRO,B) IF SUBSTR(EDITFILE,1,1) ?= "'" THEN EDITFILE = "'" || EDITFILE || "'" [...]
293 92 42_Re: Turning Correlated Subqueries to Views0_24_ssethi@LOT.TATASTEEL.COM29_Sun, 16 Jan 2000 05:50:49 GMT519_us-ascii I also think that the joins are not always best even if optimizer gets the flexibility as to which table to visit first.Suppose the first table visited A is very small (in no. of rows) and second visited B is very large (one to many relationship with very large no. of records in B for each record in A), then in this case EXISTS should be always better if no columns are to be selected by table B , as all of us had discussed earlier that EXISTS will check for the existence but not for the no. of times [...]
386 25 16_Re: PGM vs SPUFI13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Sun, 16 Jan 2000 13:37:06 -0500371_iso-8859-1 Hey Rick, If it's not the LIKE clause situation Craig mentions, check to make sure your host variable is set before the OPEN CURSOR in your program. Very often I used to have programmers show me in Xpediter that the host variable was set properly immediately before the Fetch. But of course it's at OPEN that the result set is determined -- not at Fetch. [...]
412 25 41_Conversion of MS-ACCESS data bases to DB212_Ran Abeykoon21_rabeykoon@HOTMAIL.COM29_Sun, 16 Jan 2000 15:06:34 PST369_- Folks,
I have a requirement to convert a large number of MS ACCESS data bases to DB2. So I'm wondering, if anyone out there has done similar kind of conversions and would like to share their experience with us. I'm perticularly interested in any third-party or IBM or home-grown tools available for generating DDL for ACCESS tables. Thank you in advance. [...]
438 55 45_Re: Conversion of MS-ACCESS data bases to DB224_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Sun, 16 Jan 2000 19:00:57 -0800557_us-ascii There are two products I have used in the past: DataDirect Explorer (DDE) and Data Junction (DJ). DJ is still around in its original incarnation. DDE was originally the old Q+E that was shipped as an add-in with Excel - before MS Query. It's been acquired and renamed a few times, but it worked great. Typically instead of generating the DDL and unloading the data, I just opened the Access file in one of these products and then did a "Save as...". The only downside to this approach is that I saved a 15,000 record dBase file using the same [...]
494 60 26_Re: Requesting information24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Sun, 16 Jan 2000 19:09:50 -0800574_us-ascii There are four approaches you might be able to take: 1) Filtered Log Recovery 2) what 'll call Storage Pool segregation 3) the Data Restore Feature from IBM 4) VM:DB/Restore from Sterling Software
Which, if any, of these techniques might apply would depend on whether the batch and CICS transactions would be updating the same tables and whether there is any way to identify the transactions from a particular application that might have to be backed out. DB2 Server for VSE&VM doesn't have a point-in- time recovery mechanism like DB2 for OS/390 does. [...]
555 51 21_Re: DB2 V5 and TCP/IP0_14_mtdage@ATT.NET31_Mon, 17 Jan 2000 03:30:29 +0000398_- Hi Michael,
We use NetData (installed in OS/390 Unix System Services 2.4 WEBS LPAR) to get to all our DB2 subsystem found in our ASYS LPAR (OS/390 2.4) We are on DB2 V5.1.
I wrote a simple HTML program to do queries on both local and remote DB2 databases and it worked very well. Did not have to use DB2 Connect. It can also call stored procedures which is my next task to do. [...]
607 355 18_Re: Abend 00C901010_18_mebert@AMADEUS.NET31_Mon, 17 Jan 2000 09:08:00 +0100560_iso-8859-1
We had some development TS with this problem; it's also happened in Production, like this: there is a LOAD RESUME YES on a TS with a unique index which abends during the load phase. The job is TERMed, then restarted. This gives a TS and Index out of synch (and duplicate entries in the TS which are not referred by an index entry). We resolved the problem by unloading with DSNTIAUL (entire TS), then doing a LOAD REPLACE. This gives lots of duplicate key messages, so be sure to have a large LINES parameter on your JCL. Doing a REORG [...]
963 52 11_Re: SMS/DB214_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 17 Jan 2000 09:18:04 +0100313_us-ascii Hi. My 1 cent....
In previous shop I worked we used SMS since 1994 and we polls were:
1) First of all, a good standard naming is essential ! If you create good standards, you'll be able to tuning the I/O system very well, based on application's requirements of I/O, response time etc. [...]
1016 69 42_Re: Unable to treminate an UTILITY stopped15_Filip Van Parys24_filip.vanparys@SIDMAR.BE31_Mon, 17 Jan 2000 03:24:54 -0600394_- On Sat, 15 Jan 2000 00:03:10 PST, Dan Courter (1-408-463-3870) wrote:
Hello Daniel,
we ran into thesame problem last week.
Instead of reinitializing the SYSUTILX tablespace I tried to REPAIR the page to be able to TERMINATE the utility and ... IT WORKED !!!
Thanks,
Filip Van Parys DB2 system engineer Sidmar nv - Belgium [...]
1086 37 42_Re: Unable to treminate an UTILITY stopped14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 17 Jan 2000 11:03:05 +0100361_us-ascii ....But it happens that you can drop an object whiel there's a utility in progress....or stopped !!
And as far as I know, it often happens .
Anyway, as I said 3 days ago, I should have tried to cleanup the record with a REPAIR, without
a CREATE IDCAMS because during night time I prefere to sleep instead to stop DSNDB01..... [...]
1124 144 25_Re: FW: Space calculation10_Leo Flores23_leoflores@EARTHLINK.NET31_Mon, 17 Jan 2000 02:22:52 -0800610_us-ascii I know that when a VSAM file is closed, the Hi Used RBA of that dataset is updated in the VSAM Catalog. If DB2 datasets are not closed often, does anyone know what DB2 activities(besides CLOSE) could update the Hi Used RBA?(such as quiesce, load resume,.....).
Thanks
Leo Flores
Adrian Savory wrote:
> Max, > > A number of people including yourself have advocated the use of Listcat > information for space calculation of DB2 objects. The question I have is does > the high-used-rba value always accurately reflect the amount of space used by > DB2 data? The scenario [...]
1269 78 11_AW: SMS/DB217_richard Marschner34_Karl-Richard.Marschner@HVBINFO.COM31_Mon, 17 Jan 2000 13:21:53 +0100567_iso-8859-1 Hi Jim,
about three years ago we moved from user defined db2 datasets to sms managed datasets. We have about 800 gig of data. We moved step by step. To start we had some space 'double'. Old space and the new pool. This pool was defined from our dasd collegues and fully sms managed. All new objects have been allocated in that new pool and we gained some experience working sms managed. Later all old objects have been altered from 'using vcat' to 'using stogroup' and then reorganized. We did this step by step based on database. We have only [...]
1348 62 16_Re: Column names14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Mon, 17 Jan 2000 13:34:53 +0100494_us-ascii Hi Rick,
thank goodness - at least for once - we don't chosse column names ourselves but our tool (SDW) does it for us - it simply adds a consecutive number to the foreign-key-column; our naming conventions allow not more that 16-bytes for column names so we should be on the safe side for a while; in other words, if tableb has more than 1 relationship to tablea and columna gets inherited any number of times, the column names will be 'columna1, columna2, columna3' .... [...]
1411 68 42_Re: Number of DD statement limited by TIOT13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Mon, 17 Jan 2000 07:41:16 -0600602_iso-8859-1 If you have the BMC unload and load products you can get around this pretty easily -- in the analysis phase, choose to use the BMC unload/load utilities. Then the worklist will only use 1 DD per tablespace instead of 1 per table (of course this won't buy you anything if you have split the application into 1 table per tablespace). Another option (which you can also select in the worklist-analysis) is to migrate the data using dsn1copy from an imagecopy, and avoid the unload/load completely. BMC will perform the OBID translation/reset/etc as part of the worklist, and also generate [...]
1480 197 34_Re: REXX doubt...(Batch ISPF edit)11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Mon, 17 Jan 2000 08:52:31 -0500749_iso-8859-1 Here is a little procedure I use...
//* //* CREATE MACRO TO APPLY TO ALL MEMBERS //* CHANGE EDIT MACRO "CHANGES" TO MEET YOUR NEEDS //* //CRE#MAC EXEC PGM=IEBUPDTE, // PARM=NEW //SYSPRINT DD SYSOUT=* //SYSUT2 DD DSN=&&EXEC, // DISP=(NEW,PASS), // UNIT=SYSDA, // SPACE=(TRK,(5,1,25)), // DCB=(LRECL=80,RECFM=FB,BLKSIZE=0) //SYSIN DD DATA, // DLM='\\' ./ ADD NAME=CHANGES /* REXX */ /************** REXX ***************/ /* */ /* EDIT MACRO */ /* */ /************** REXX ***************/ "ISREDIT MACRO " "ISREDIT CHANGE DB2A DB2P ALL " "ISREDIT END " "ISREDIT MEND " EXIT ./ ADD NAME=EDITPDS /* REXX NAME: EDITPDS FUNCTION: SEE ATTACHED */ /**********************************************************************/ /* */ [...]
1678 58 42_Re: Number of DD statement limited by TIOT14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Mon, 17 Jan 2000 14:34:24 -0000661_- The maximum number of concurrently open datasets is now 10,000 (or more!), but I can never remember which version of OS/390 you need to be able to acheive this.
Also, I have never tested whether JES2 can handle this many DD statements.....
Phil Grainger Director DB2 Operations, Europe Computer Associates International
> -----Original Message----- > From: Gendron, Dave (Exchange) [SMTP:Dave.Gendron@COASTALCORP.COM] > Sent: Friday, January 14, 2000 10:10 PM > To: DB2-L@RYCI.COM > Subject: Number of DD statement limited by TIOT > > Our PeopleSoft DBA is using BMC to perform a migration. He apparently has > 7500 DD statements in [...]
1737 20 36_DB2EUG Database System Monitor Usage0_22_Stepansky_Ruby@EMC.COM31_Mon, 17 Jan 2000 10:24:34 -0500585_iso-8859-1 I'd like to discuss with anyone who has implemented/used DB2 UDB (and more specifically if possible EEE) Database System Monitor and reporting from the output.
Ruby Stepansky EMC Sr. Enterprise Data Warehousing Technology Architect Office: 212-301-7093 Fax: 212-564-6909 stepansky_ruby@emc.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1758 20 31_db2 unload using display format0_18_Usregion10@AOL.COM29_Mon, 17 Jan 2000 10:32:45 EST460_us-ascii Greetings everybody!
Is there anybody out there who has customized the db2 unload utility (DSNTIAUL) to unload data in display format. Preferrably without the delimiter. Thanks in advance. regards, Anil
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1779 43 4_CDRN14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Mon, 17 Jan 2000 16:37:30 +0100424_us-ascii Esteemed list,
perhaps someone could shed some light on the following problems: We've been encountering a considerable number of -904s and -911s in our production environment today. Now we know which CICS-Transaction is holding which ressource but have been unable to solve the problem. We then consulted Omegamon and in the classic interface, Locking conflicts, we found under 'type' the entry 'CDRN'. [...]
1823 84 74_Fw: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.20_Jahangir Nematollahi28_J_NEMATOLLAHI@ISC.IRANET.NET31_Sat, 15 Jan 2000 19:10:43 +0330800_iso-8859-1 Hi jim,
Please send me a copy too. TIA
Jahangir -----Original Message----- From: Clark, Tony Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Wednesday, January 12, 2000 5:10 PM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.
>Jim: > >Please send me a copy. Thanks. > >Tony > >Tony Clark >DB2 System Administrator >Texas Workforce Commission >15th Congress Ave >ADP Room 320 >Austin, Texas 78778-0001 >E-Mail: tclark@twc.state.tx.us >Phone: (512) 463-3079 >Fax: (512) 936-3190 > >> -----Original Message----- >> From: Jim Lewandowski [SMTP:jlewand@STARNETINC.COM] >> Sent: Tuesday, January 11, 2000 10:09 AM >> To: DB2-L@RYCI.COM >> Subject: Re: DB2-OS/390- Statistical [...]
1908 26 42_Re: Number of DD statement limited by TIOT12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 17 Jan 2000 07:46:49 -0800390_us-ascii To get more than 3273 DD's, you need to use dynamic allocation and set a flag. DB2 may be the only current user of this support. The MVS changes are very old - back to 1990 -
MVS VERSION 3 (V3R1M0E OR V3R1M3) WITH THE FOLLOWING APARS INSTALLED: OY26839 OY26840 OY26841 OY26842 OY26843 OY26914 OY25606 DFP VERSION 3.2 WITH THE FOLLOWING APARS INSTALLED: OY29785 OY29786 [...]
1935 38 35_Reorg of the Catalog and Directory.0_25_Julian_Peacock@SWEB.CO.UK31_Mon, 17 Jan 2000 15:50:00 +0000387_ISO-8859-1 Fellow DB2'ers,
I have, like everyone else, witnessed the large volume of interest shown in Dr. Ebert's posted Reorg jobs. I do have some queries regarding this matter:
* Firstly, I was wondering how many sites have actual ever Reorged the Catalog and Directory? I am trying to establish whether this is a task that DBA's never/sometimes/regularly perform. [...]
1974 64 8_Re: CDRN9_Fox, Dave16_Dave_Fox@BMC.COM31_Mon, 17 Jan 2000 09:57:31 -0600376_ISO-8859-1 I believe this stands for "Claim/DRaiN", which is a process used to serialize and restrict new access to a pageset while it is being stopped for utility or other processing. Check your JES log for messages indicating that a STOP or QUIESCE command was issued for the pageset, or whether an UNLOAD, LOAD, REORG, or RECOVER utility was scheduled for the object. [...]
2039 87 8_Re: CDRN14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Mon, 17 Jan 2000 17:01:07 +0100604_us-ascii Thank you Dave,
but alas, there is NO utility running concurrently on this tablespace or its index-spaces, in fact there's no utility running at all during prime time production cics.
Other ideas ?
TIA Ruediger Kurtz
Fox, Dave schrieb: > > I believe this stands for "Claim/DRaiN", which is a process used to > serialize and restrict new access to a pageset while it is being > stopped for utility or other processing. Check your JES log for > messages indicating that a STOP or QUIESCE command was issued for > the pageset, or whether an UNLOAD, LOAD, REORG, or [...]
2127 108 8_Re: CDRN13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Mon, 17 Jan 2000 09:24:52 -0700385_- OMEGAMON II for DB2 Tuning Guide 4.4.2.2 Accessing lock information It is usual to see a cursor stability read drain lock (CDRN) or a write drain lock (WDRN) among the locks held by a utility.
From: ruediger.kurtz%HUK-COBURG.DE@Internet on 01/17/2000 09:03 AM To: DB2-L%RYCI.COM@Internet cc: (bcc: Dan S Brogdon) Subject: Re: CDRN [...]
2236 25 40_Receiving mail from the DB2-L Listserver13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Mon, 17 Jan 2000 10:24:17 -0600241_us-ascii Hi all,
Thanks to all for all of the helpful notes. It turns out there might be a problem with ibm.net and attglobal.net (they took over ibm.net).... the listserver folks are looking into it...
Thanks again....
2262 26 17_Disaster Recovery12_Mike O'Brien30_michael_obrien_48127@YAHOO.COM31_Mon, 17 Jan 2000 09:17:42 -0800586_us-ascii When we go to our recovery site all of our volumes ids will be duplicated at that site, including the log volumes. A couple of questions, 1. When I define new log datasets there, do they have to be the same size as the originals. 2. Do they have to be formatted (ours are very large and a test here took 2 hrs to format them. 3. Can the DB recoveries of catalogs and directories be run over the existing data from the volume dumps, bypassing the vsam delete and define and the initialization steps. Thanks __________________________________________________ Do You Yahoo!? [...]
2289 23 19_Spufi audit logging14_MOWBRAY, DAVID20_david.mowbray@CGI.CA31_Mon, 17 Jan 2000 12:36:14 -0500415_us-ascii I am trying to find a way to log all spufi's run in MVS/TSO that have updated the database (ie UPDATE, INSERT, DELETE). Is there any product out there that does this? Has anyone put together a home grown routine to do this?
Regards, David Mowbray IIS: DMOWBRAY OFC # (416) 215-3041 Senior Consultant FAX # (416) 510-2076 CGI, Application Management Services EMAIL: david.mowbray@cgi.ca [...]
2313 58 23_Re: Spufi audit logging13_McDonald, Ken20_Ken_McDonald@BMC.COM31_Mon, 17 Jan 2000 12:54:34 -0600372_ISO-8859-1 David,
BMC Software's product, Log Master for DB2, has the ability to audit DB2 log and to specify selection criteria, such as PLAN NAME, to meet your needs. Other vendors may have products which fit this need as well... Writing a home grown routine to audit log is a significant endeavor. I would suggest visiting vendor web sites for information. [...]
2372 43 69_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.18_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Mon, 17 Jan 2000 20:17:47 +0100590_us-ascii Jim,
Please send me a copy.
Gerrit
Jim Lewandowski wrote:
> I had sent out many copies of an SMF 42 subtype 6 REXX that provided a > detail and summary of I/O response times (and their components) for > each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested > in this? > > Jim Lewandowski > > Galambos, Robert wrote: > > > > Chuck Hoover, from Compuware, has an excellent presentation > > concerning this subject. In his presentation, using information from the > > Buffer Pool Tool software, among others, he shows how to take the [...]
2416 72 69_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.18_Richard Mccutcheon32_Richard_McCutcheon@HCM.HONDA.COM31_Mon, 17 Jan 2000 13:20:49 -0500789_us-ascii I would also like a copy, please.
Thanks, Richard McCutcheon Honda of Canada Manufacturing DBA
Gerrit Groenendaal on 01/17/2000 03:17:47 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Richard McCutcheon/HCM/AM/HONDA) Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.
Jim,
Please send me a copy.
Gerrit
Jim Lewandowski wrote:
> I had sent out many copies of an SMF 42 subtype 6 REXX that provided a > detail and summary of I/O response times (and their components) for > each table/indexspace for a DB2 DBM1 subsystem. Anyone else interested > in this? [...]
2489 61 39_Re: Reorg of the Catalog and Directory.24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Mon, 17 Jan 2000 14:40:14 -0500434_- Julian,
I reorged the cat/dirs in 5 subsystems about 3 months ago and our application DBAs reported a "significant" increase in performance. Unfortunately, we have yet to establish good performance and capacity monitoring procedures so I cannot quantify this for you. I was a bit skeptical that it would have much affect but, again, the DBAs did report significant reductions in batch run times. For what it is worth... [...]
2551 66 23_Re: Spufi audit logging12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 17 Jan 2000 11:48:41 -0800445_us-ascii There are a number of possible interpretations for your logging. Here are a couple of possibilities, or maybe you want something else.
1. Log all of the individual usage for some specific tables. This might be handled by reporting for the audit trace records. The DB2 Administration Guide chapter on Auditing Concerns describes this (page 3-115 in V5 hard copy). DB2 PM and a number of other products can print the records. [...]
2618 1042 21_Re: Disaster Recovery12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 17 Jan 2000 12:04:31 -0800465_iso-8859-1
What's the objective of this test? If it's mostly to test your procedures, then you can get away with smaller logs. If it's to see what the time for a real recovery would require, then you need the big logs.
Are you allocating and formatting the logs in parallel? That will save quite a bit of time. If you don't preformat the logs, then you format them the first time, and your times are probably longer for the run. [...]
3661 43 25_File system is full error10_Nash Gupta19_nashgupt@US.IBM.COM31_Mon, 17 Jan 2000 14:18:10 -0600584_- Hello List,
I am on DB2 on AIX v5.2.
This is the error I get while I was loading a 100 meg datafile into one of the DB2 tables.
SQL0968C The file system is full. Cause: One of the file systems containing the database is full. This file system may contain the database directory, the database log files, or a table space container. The statement cannot be processed. Action: Refer to the diagnostic log to determine which file system is full. Free system space by erasing unwanted files. Do not erase database files. If additional space is required, it may [...]
3705 190 29_Re: File system is full error11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Tue, 18 Jan 2000 08:20:05 +1100585_- Hi Nash, My first stop is the diagnostic log (typically /home/$DB2INSTANCE/sqllib/db2dump/db2diag.log). Messages in it should indicate the culprit.
HTH, Bruce
> -----Original Message----- > From: Nash Gupta [SMTP:nashgupt@US.IBM.COM] > Sent: Tuesday, January 18, 2000 7:18 AM > To: DB2-L@RYCI.COM > Subject: File system is full error > > Hello List, > > I am on DB2 on AIX v5.2. > > This is the error I get while I was loading a 100 meg datafile into one > of > the DB2 tables. > > SQL0968C The file system is full. > Cause: One of the file systems containing the [...]
3896 42 16_Tablespace error10_Nash Gupta19_nashgupt@US.IBM.COM31_Mon, 17 Jan 2000 15:26:35 -0600487_- Platform: DB2/AIX v5.2
For the error below ..
- HOW DO YOU "EMPTY" THE TABLE SPACE (USERSPACE1)??
I'm positive that I have enough diskspacE. Maximum file size for the userid is set to unlimited.
The logprimary and log second files are 20 and 25 respectively.
AM I MISSING SOMETHING HERE ???
----------------------------------------------------------------- Starting LOAD phase at 01-14-2000 17:42:14.108109. Table DB2INST2.INVENTORY_XREF [...]
3939 15 55_Re: FAROFFPOSF info for an index in Platinum Statistics9_Paul Yuen16_pyuen@GIO.COM.AU31_Tue, 18 Jan 2000 09:00:07 +1000392_us-ascii I'd like to thank Dr.Michael Ebert and Rob Crane for their replies, especially Rob for his detailed info on the PDA set up. Thanks again Paul
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
3955 208 20_Re: Tablespace error11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Tue, 18 Jan 2000 09:04:50 +1100429_- Hi Nash, userspace1 is where all of your tables live (unless you specified a tablespace on any create table statement), except for the catalog and sortwork.
DB2 is saying you do not have enough space. You are saying you do. One of you is wrong.
Can you provide some more information. How big is userspace1, and how much space is left on the filesystem where it lives? What is the LOAD command you are using. [...]
4164 17 30_Exit to intercept DB2 Commands20_[Robert Yoel Cabili]21_rcabili@MANDIC.COM.BR31_Mon, 17 Jan 2000 17:21:20 -0600413_- Hi !
I would like to know if DB2 have an exit who we can intercept DB2 DDL commands like create table, Drop table before the execution
Thanks
Robert
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4182 29 15_RID Pool Tuning0_16_acaldwe2@CSC.COM31_Tue, 18 Jan 2000 10:59:56 +1000382_us-ascii I am currently looking at some statistics for our prod. RID Pool. We are getting a number of failures - approx 1100 failures from 300,000 RID list processes.
Is this an issue ? I suspect the failure rate is not evenly distributed, spikes would exist during peak load. (The admin guide says the task might revert to tablespace scans - definitely not desirable.) [...]
4212 88 39_Re: Reorg of the Catalog and Directory.0_29_Greg.Palgrave@BANKWEST.COM.AU31_Tue, 18 Jan 2000 08:41:21 +0800345_us-ascii Julian,
We reorg the catalog weekly now. The first time we did it, we got some significant improvements, so we decided to take the easy way out, and just put it in the weekly schedule. Our Prod reorg takes around 20 minutes, and that is QUIESCE, REORG and COPY. We also have a pre-reorg copy in a separate job in the suite. [...]
4301 92 20_Re: Tablespace error13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Tue, 18 Jan 2000 08:33:16 +0530389_us-ascii hi !!
See basically the userspace has become full and needs more space. So we have to allocate more space to the userspace. First of all , by default userspace is system managed.
Try creating a tablespace , and create it as user managed. Allocate enough containers to it w.r.t space. Then create the table in this tablespace and load it. I am sure it will work [...]
4394 47 34_Re: Exit to intercept DB2 Commands12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 17 Jan 2000 19:09:00 -0800450_us-ascii There is nothing designed as an exit like this. Some customers have used the DSNHLI module to intercept all of the SQL calls, but the technique does require variations for the various environments: CICS, IMS, TSO attach, call attach, RRS attach.
Roger Miller
"[Robert Yoel Cabili]" @RYCI.COM> on 01/17/2000 03:21:20 PM
Please respond to DB2 Data Base Discussion List [...]
4442 16 19_Re: RID Pool Tuning12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 17 Jan 2000 19:06:18 -0800421_us-ascii Are you running DB2 Version 5? If so, do you have APAR PQ15670 on? This can help a lot for customers who are using list prefetch with index screening.
Roger Miller
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4459 214 30_Re: Looking for DB2 Connect PE15_Michael McGuire32_Michael.McGuire@COLESMYER.COM.AU31_Tue, 18 Jan 2000 15:17:56 +1100383_iso-8859-1 Sadly for us non-Americans, IBM will only ship the CD version of this "free" version of DB2 Personal Developer's Edition to American addresses. The Australian version of SHOPIBM does not have it available. And when I tried to ask IBM USA to ship it to me (I'm more than willing to pay the shipping), the response was that IBM only shipped this to American addresses. [...]
4674 79 20_Re: Tablespace error13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Mon, 17 Jan 2000 22:38:18 CST517_- hummm maybe when you run a specific job (example load/import) it fills up the filesystem where this tablespace resides....the job terminates and releases all the space back. This can definitely produce the situation you described.
Hope this helps ..... regards,
Umair Hussain******************************** DBA Consultant * DB2 UDB, Oracle, Sybase, DataJoiner * IBM Certified Solution Expert - DB2 UDB DBA * IBM Certified AIX System Administrator * ********|All Disclaimers Apply|************** [...]
4754 95 9_PCTFREE 028_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 18 Jan 2000 00:17:02 PST337_- What would the affect be if SYSCOPY had a PCTFREE of 0? Similarly, what would be the affect if many of the catalog indexes had PCTFREE 0? Of course, performance of everything that accessed these objects would suffer.
What if I told you PCTFREE really is ZERO in some cases, REGARDLESS OF WHAT YOUR CATALOG SAYS? Read on... [...]
4850 12 9_PCTFREE 028_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 18 Jan 2000 00:17:56 PST322_- Sorry, I sent the note prematurely...I'll resend the complete note.
Dan
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4863 110 9_PCTFREE 028_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 18 Jan 2000 00:19:41 PST337_- What would the affect be if SYSCOPY had a PCTFREE of 0? Similarly, what would be the affect if many of the catalog indexes had PCTFREE 0? Of course, performance of everything that accessed these objects would suffer.
What if I told you PCTFREE really is ZERO in some cases, REGARDLESS OF WHAT YOUR CATALOG SAYS? Read on... [...]
4974 21 11_DB2 Stmator25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG29_Tue, 18 Jan 2000 09:19:33 GMT349_us-ascii Hi,
Would like to check if any of u have put the above product on the LAN for all the apps folks to use. Were there any problems or issues that u had to address? I believe that this product is a free download from the IBM website. So does that mean that I can put it on the LAN for everybody to use. How is it done at u'r site. [...]
4996 20 11_DB2 Connect9_SrinivasG17_SRINIVASG@INF.COM31_Tue, 18 Jan 2000 14:45:29 +0530477_iso-8859-1 Hi Everyone,
Has anyone used DB2 Connect to connect to DB2 through a Communication Gateway? I would like to know how the SNA/Client and DB2 Connect configuration is performed.
Thanks & Regards
Srinivas G
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5017 89 11_[Fwd: CDRN]14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Tue, 18 Jan 2000 10:39:03 +01009_us-ascii
5107 53 15_Re: [Fwd: CDRN]11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 18 Jan 2000 05:09:16 -0500353_ISO-8859-1 Hi Ruediger
Drain locks are taken by Utilities when they drain an object. Drain Locks are also taken, for a short time only, when an SQL process does what is called a Long Claim. This will be done by the first SQL process to access an object after a utility has run, or the first SQL process after an object is physically opened. [...]
5161 237 21_Re: Disaster Recovery12_Mike O'Brien30_michael_obrien_48127@YAHOO.COM31_Tue, 18 Jan 2000 04:49:51 -0800628_us-ascii Roger, thanks for the informative update. While testing procedures this past weekend the thought occurred that if we are volume copying everything, MVS, HSM, DB2, etc, if we also copied the DB2 active logs and had LOCALSITE daily image copies, would it be possible to update the BSDS with the necessary archive info then just lay down the DB2 image(volume for volume)as a LOCALSITE, do a normal START DB2,ACCESS(MAINT)then Recover all Catalog/directory spaces(in the required order) and user spaces. That's kind of where the log sizing came from. It sounds good theoretically and fairly fast but I sure don't want [...]
5399 18 20_Export decimal field13_Donald Tipton29_Donald.Tipton@DAS.STATE.OH.US31_Tue, 18 Jan 2000 07:58:35 -0500348_us-ascii We are running UDB version 5 on an AIX platform. I am trying to export a table that has a column defined as decimal (15,3 Is there any way to suppress the leading zeros on the decimal field when exporting to a delimited ASCII file? The only options I have found are changing the first character from a + to a blank. Thanks Don Tipton [...]
5418 36 15_Re: [Fwd: CDRN]11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 18 Jan 2000 08:50:11 -0500481_ISO-8859-1 Hi Ruediger
It might still be pageset close/open. DB2 may close CLOSE NO datasets if it hits DSMAX and there are not enough CLOSE YES pagesets on the deferred close queue. Have you checked the DB2 statistics trace for pageset open/close counts?
Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner
Message text written by INTERNET:ruediger.kurtz@huk-coburg.de >Thanx Mike, [...]
5455 30 27_Reducing extents on an NPI?14_Jessen Michael29_JessenMichel@JDCORP.DEERE.COM31_Tue, 18 Jan 2000 08:42:20 -0600306_- I have an index that currently has 107 extents. This is an NPI for a table with 72 partitions.
This particular table has over 100 million rows of data. After I alter the space, Is there any other way to reduce the extents without having to rebuild the entire index?
Thanks in advance! [...]
5486 75 31_Re: Reducing extents on an NPI?13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 18 Jan 2000 14:49:56 -0000464_iso-8859-1 Don't try this at home, but if you have DFHSMS and plenty of contiguous free space...
1. Stop the Index 2. HMIGRATE the dataset 3. HRECALL the dataset 4. Start the index 5. Get a hard copy of your CV (or "resumé" for you colonial cousins) 6. Hide 7. Wait
-----Original Message----- From: Jessen Michael [mailto:JessenMichel@JDCORP.DEERE.COM] Sent: 18 January 2000 14:42 To: DB2-L@RYCI.COM Subject: Reducing extents on an NPI? [...]
5562 34 31_Re: Reducing extents on an NPI?14_Jessen Michael29_JessenMichel@JDCORP.DEERE.COM31_Tue, 18 Jan 2000 08:49:30 -0600466_- > I have an index that currently has 107 extents. This is an NPI for a > table with 72 partitions. > > This particular table has over 100 million rows of data. > After I alter the space, Is there any other way to reduce the extents > without having to rebuild the entire index? > > Thanks in advance! > > oops - I forgot: This is DB2 V5.1 on OS390. > > Mike Jessen > DBA > John Deere Credit > (515) 267-3672 > mj02046@deere.com > > \\\|/// > \ ~ ~ / > (\ @ @ [...]
5597 42 31_Re: Reducing extents on an NPI?14_Massimo Scarpa16_mscarpa@CESVE.IT31_Tue, 18 Jan 2000 15:59:13 +0100392_us-ascii If you have HSM and enough ML1 DASDs you may use STRIZZA, that is a REXX using the
HSM command :
HSEND MIGRATE DSNAME(xxxx.dsndbc.xxxx.xxxx.i0001.a001) CONVERT
.....and wait for many ours !! But I hope this isn't a production table for online transactions......
We used this command to eliminate DB2 VSAM extent quickly in small tablespace, (after a [...]
5640 98 31_Re: Reducing extents on an NPI?24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Tue, 18 Jan 2000 10:06:46 -0500435_iso-8859-1 I have used this too and depending on the space status of your pool,(at least for non-VSAM datasets) it works. However, depending on the size of the underlying dataset the HMIGR could take a while. So do not forget 5, 6, & 7.
-----Original Message----- From: Marcus Davage [mailto:Marcus.Davage@LLOYDSTSB.CO.UK] Sent: Tuesday, January 18, 2000 9:50 AM To: DB2-L@RYCI.COM Subject: Re: Reducing extents on an NPI? [...]
5739 16 55_Can user logons in groups be suspended from logging on?0_25_George_White@VANGUARD.COM31_Tue, 18 Jan 2000 10:32:06 -0500473_us-ascii Can anyone tell me if there is the capability in OS\390 DB2 Version 5 to suspend the connection to DB2? If so, can this be applied to a group or must it be to explicit user-ids?
Thank you, George White.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5756 15 31_Re: Reducing extents on an NPI?12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 18 Jan 2000 07:51:13 -0800393_us-ascii How about online reorg for that index? That should be faster than the rebuild and less disruptive than most other choices.
Roger Miller
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5772 42 59_Re: Can user logons in groups be suspended from logging on?0_23_Mike_Levine@TEKHELP.NET31_Tue, 18 Jan 2000 10:56:01 -0500493_us-ascii Hi,
Using OS/390 SAF (system authorization facility through RACF, ACF/2, etc) you can enable resource DSNR and restrict access. Many installations do not have this level of security enabled but this is how you would restrict ALL access to a DB2 subsystem. This will work with groups or individual ids. Be careful doing this as any process that requires DB2 will have to now be specifically permitted access to this resource through your security system to connect to DB2. [...]
5815 37 22_Release(Deallocate) ??12_Mckay, Wayne24_Wayne.Mckay@ATCOITEK.COM31_Tue, 18 Jan 2000 08:51:50 -0700361_- Hey folks out there
We are planning on allowing Online Inquiry during our nightly batch window. In conjunction with this change we are considering whether it would be practical to change from Release(Commit) to Release(Deallocate). If we adopt this strategy we would phase it in, not implement it wholesale.
Some points on our environment: [...]
5853 121 20_Re: Tablespace error10_Nash Gupta19_nashgupt@US.IBM.COM31_Tue, 18 Jan 2000 10:15:19 -0600389_- Hello!
I did check the USERSPACE1 (SQLT0002.0 container)tablespace. The system shows its current size as 4096 (which is much below the 2GB limit).
Only 33% of the total file system (/usr/) of 3.5 GB has been used. The datafile is around 100 megs. I
This is the load command I used - load from file_name.del of del messages file_name.msg replace into table_name [...]
5975 139 20_Re: Tablespace error13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 18 Jan 2000 10:46:19 -0600454_US-ASCII Nash, Try issuing LIST TABLESPACE CONTAINERS FOR 2 SHOW DETAIL This will confirm path and tablespace info. Kurt
>>> Nash Gupta 01/18/00 10:15AM >>> Hello!
I did check the USERSPACE1 (SQLT0002.0 container)tablespace. The system shows its current size as 4096 (which is much below the 2GB limit).
Only 33% of the total file system (/usr/) of 3.5 GB has been used. The datafile is around 100 megs. I [...]
6115 16 20_Re: Tablespace error10_Nash Gupta19_nashgupt@US.IBM.COM31_Tue, 18 Jan 2000 10:44:38 -0600415_- A correction to my earlier mail ..
The total size of the USERSPACE1 tablespace is 54236 (This is the value I got by typing du -k in that dir.)
Thanks! - nash
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6132 36 39_Re: Reorg of the Catalog and Directory.12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 18 Jan 2000 18:50:45 +0200449_x-user-defined Hi,
Since we have a lot of dynamic SQL and other queries against the catalog we do a reorg about every 1-2 months. We ones checked the changes in response time but I don't have that info now. We have user indexes defined on the catalog as well. We take a time when systems are in "maintenance window" and have a job that is doing the following: 1. Image copy before. 2. DSN1CHKR 3. REORG 4. Image copy after. 5. DSN1CHKR. [...]
6169 28 34_Tool for diagramming DB2 databases23_Campbell, James B - CNF22_Campbell.James@CNF.COM31_Tue, 18 Jan 2000 09:22:34 -0800407_iso-8859-1 I have searched for a tool which could 'read' an entire DB2 database, and draw a readable and meaningful relationship diagram (broken down into logical pages if necessary) of that database (including keys, indexes, relationships etc).
For IDMS databases, there is software which can draw Bachmann diagrams. Does anyone know of something which could provide something similar for DB2? [...]
6198 46 38_Re: Tool for diagramming DB2 databases24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Tue, 18 Jan 2000 12:32:06 -0500515_iso-8859-1 It might be too expensive if the diagramming is the only function you desire but ERwin does a great job of this....it requires the DDL, which most places usually reverse engineer using Platinum/Migrator. My experience with ERwin is that they also quickly update it to 'understand' new DDL features.
-----Original Message----- From: Campbell, James B - CNF [mailto:Campbell.James@CNF.COM] Sent: Tuesday, January 18, 2000 12:23 PM To: DB2-L@RYCI.COM Subject: Tool for diagramming DB2 databases [...]
6245 24 9_Maxrows 122_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Tue, 18 Jan 2000 09:35:43 -0800285_- Hi All,
I have a question concerning MAXROWS. We have altered a tablespace for MAXROWS 1. We then reorged the tablespace and I have gone out and checked the pages and there are aproximately 64 rows per page. We are OS/390 V5. Has anyone run into this, What am I missing? [...]
6270 38 13_Re: Maxrows 124_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Tue, 18 Jan 2000 12:41:14 -0500552_iso-8859-1 Does RUNSTATS come into play here ? Is there an index on this table ?
-----Original Message----- From: Killen, Martin W - CNF [mailto:Killen.Martin@CNF.COM] Sent: Tuesday, January 18, 2000 12:36 PM To: DB2-L@RYCI.COM Subject: Maxrows 1
Hi All,
I have a question concerning MAXROWS. We have altered a tablespace for MAXROWS 1. We then reorged the tablespace and I have gone out and checked the pages and there are aproximately 64 rows per page. We are OS/390 V5. Has anyone run into this, What am I missing? [...]
6309 53 13_Re: Maxrows 122_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Tue, 18 Jan 2000 09:50:41 -0800594_- We did runstats and there is an index on the table. It was my understanding that MAXROWS would not affect the index, just the tablespace.
> -----Original Message----- > From: Marchese, Frank D, CSCIO [SMTP:fdmarchese@ATT.COM] > Sent: Tuesday, January 18, 2000 9:41 AM > To: DB2-L@RYCI.COM > Subject: Re: Maxrows 1 > > Does RUNSTATS come into play here ? Is there an index on this table ? > > -----Original Message----- > From: Killen, Martin W - CNF [mailto:Killen.Martin@CNF.COM] > Sent: Tuesday, January 18, 2000 12:36 PM > To: DB2-L@RYCI.COM > Subject: Maxrows 1 > > > Hi All, [...]
6363 54 46_Our 'documents' web site is open for business!13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 18 Jan 2000 13:23:26 -0500340_us-ascii Please read this entire email.
DB2-L-DOCUMENTS is open for business so if you have a REXX subroutine or a program or any kind of document that would be of interest to the DB2-L community please post it to the DOCUMENTS web site for everyone's mutual benefit.
However, there are a few rules that you must follow; [...]
6418 70 38_Re: Tool for diagramming DB2 databases14_Harvey Wachtel22_babybaby@UAPC.CUNY.EDU31_Tue, 18 Jan 2000 13:35:55 -0500437_us-ascii I can't imagine how that could be accomplished. The nature of a relational database is that the relationships can be created dynamically. Therefore, determining the intent of the designers would seem to be an exercise in mind-reading. Of course some of the relationships are explicitly defined ( e.g. by referential integrity constraints), but most of them live offline, in written documentation and in naming conventions. [...]
6489 162 23_Cursor / Non-Cursor Mix16_Michael McMorrow25_michael.g.mcmorrow@AIB.IE31_Tue, 18 Jan 2000 18:52:46 -0000380_ISO-8859-1 Hi,
As a bald question, I'd like to know whether your installation has an explicit and effective ban on mixing Cursor and Non-Cursor SQL.
My reason for asking involves a lot of background description so apologies for the long read!! A pint of Guinness for anyone who gets to the end! This is really a follow-on from a previous mail on 'Hybrid Join'. [...]
6652 93 38_Re: Tool for diagramming DB2 databases14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 18 Jan 2000 14:08:30 -0500371_us-ascii You can reverse engineer a physical design using ERWin, VISIO Professional or another modeling tool. Depending on how you set it up, that determines the entities and relationships that you get. HTH Phil
Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner DB2-L [...]
6746 20 27_Re: Cursor / Non-Cursor Mix14_Harvey Wachtel22_babybaby@UAPC.CUNY.EDU31_Tue, 18 Jan 2000 14:30:20 -0500370_us-ascii I got to the end OK. Sorry -- I'm not into Guinness, but as a reward I'll settle for the Schadenfreude of seeing someone else struggling with IBM's all too typical broken-as-designed arrogance. And I thought I was having troubles with them over our field procedures! At least we're not threatened with your Damocles' sword of future unpredictable results. [...]
6767 17 50_Re: Our 'documents' web site is open for business!14_Harvey Wachtel22_babybaby@UAPC.CUNY.EDU31_Tue, 18 Jan 2000 14:36:29 -0500516_us-ascii Thanks for your efforts. The ability to easily share long programs and documents is a great improvement.
I have one request. I have one of those small minds that Emerson says a foolish consistency is the hobgoblin of. Please stop rubbing it in. Thanks again.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6785 183 27_Re: Cursor / Non-Cursor Mix12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Tue, 18 Jan 2000 15:01:16 -0500547_iso-8859-1 When you change your code to force materialization of the result set, make sure that you have bound your package/plan with ISOLATION(RR). Otherwise, once you've read and materialized your result set, someone else may update one of the rows you selected before you get to it. Then, you may overlay their update, and you'll have found your case in which separate applications can unwittingly combine to expose data integrity. Thanks to Bonnie Baker for covering this issue in one of her "Things I wish they'd told me . . ." classes. [...]
6969 29 27_DB2 High Performance Unload0_22_BILL_GALLAGHER@PHL.COM31_Tue, 18 Jan 2000 15:17:42 -0500344_us-ascii Hi. We've just purchased and installed this utility from IBM. Early testing shows a pretty drastic improvement from DSNTIAUL performance. For example, in our very simplified benchmark testing, unloading a 3 million row table in DSNTIAUL took over 13.5 minutes, High Performance Unload took less than 2 minutes. Pretty impressive. [...]
6999 37 13_Re: Maxrows 120_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 18 Jan 2000 15:29:04 -0500542_- Did you REUSE option during REORG ?
> -----Original Message----- > From: Killen, Martin W - CNF [SMTP:Killen.Martin@CNF.COM] > Sent: Tuesday, January 18, 2000 12:36 PM > To: DB2-L@RYCI.COM > Subject: Maxrows 1 > > Hi All, > > I have a question concerning MAXROWS. We have altered a tablespace for > MAXROWS 1. We then reorged the tablespace and I have gone out and checked > the pages and there are aproximately 64 rows per page. We are OS/390 V5. > Has anyone run into this, What am I missing? > > Marty Killen > Sr. DB2 DBA > [...]
7037 58 13_Re: Maxrows 122_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Tue, 18 Jan 2000 12:35:11 -0800374_- What we have found out is that during the reorg it is using the PCTFREE and ignoring the MAXROWS. Don't know if this is how this was designed, I sure didn't get the impression from the manual that it worked this way.. On subsequent inserts the MAXROWS is working. so we have set PCTFREE to 99% and reorged and guess what, one row per page. Thanks for all the input.. [...]
7096 38 42_Why isn't User Authorized? UDB v6.1 on AIX0_22_BILL_GALLAGHER@PHL.COM31_Tue, 18 Jan 2000 15:43:54 -0500433_us-ascii Hi. We've run into a minor problem on our UDB v6.1 system running on AIX. We've set up an AIX group, for instance "group1", and added a number of users to this group, including one user in particular, "user2". In our UDB database, we granted SELECT, INSERT, UPDATE, and DELETE authority on all user tables to the group "GROUP1". However, when "user2" tried to bind a package against the database, he received an error: [...]
7135 44 27_Re: Cursor / Non-Cursor Mix12_Greg P Mucha24_Greg_P_Mucha@CARADON.COM31_Tue, 18 Jan 2000 20:45:32 +0000516_us-ascii Michael --
All of our DB2 applications are either cursor or non-cursor, exclusively. So we're not likely to run into this kind of a problem.
What I would do in your position is request that IBM send an appropriate representative to a meeting with your business sponsors and let them understand that the future of their reputation within your organization (and those of us who are watching) hinges on their ability to communicate why DB2 is a better solution than other database managers. [...]
7180 67 13_Re: Maxrows 13_FIS18_fis@ARCHES.UGA.EDU31_Tue, 18 Jan 2000 15:42:09 -0500591_us-ascii Done (I gave me and Tara) alter also
At 12:35 PM 01/18/2000 -0800, you wrote: >What we have found out is that during the reorg it is using the PCTFREE and >ignoring the MAXROWS. Don't know if this is how this was designed, I sure >didn't get the impression from the manual that it worked this way.. On >subsequent inserts the MAXROWS is working. so we have set PCTFREE to 99% >and reorged and guess what, one row per page. Thanks for all the input.. > >> -----Original Message----- >> From: Pillay, Venkat (PCA) [SMTP:venkat_pillay@ML.COM] >> Sent: Tuesday, January 18, [...]
7248 36 27_Re: Cursor / Non-Cursor Mix12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 18 Jan 2000 14:51:19 -0600501_- If it will help, please send me a note and I'll call you early in my morning and late in your afternoon. If you are coming to the DB2 and IMS Technical Conference in Barcelona, I'll buy, and we can talk.
I did get to the end and reread the much longer problem records as well. I also looked over my notes with the developer, several other senior designers, several service people and several top people in the UK. I was part of the discussions while others were talking directly to you. [...]
7285 64 46_Re: Why isn't User Authorized? UDB v6.1 on AIX13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 18 Jan 2000 14:55:02 -0600327_US-ASCII Bill, If this is a static SQL statement, the reference manual states "Privileges granted to groups are not used for authorization checking of static statements" during bind. dynamic SQL will work. I hope IBM will in the future allow use to use groups for binds with an owner as we do on the mainframe world. Kurt [...]
7350 82 70_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.16_Drucker, Aurelia18_ADrucker@KMART.COM31_Tue, 18 Jan 2000 15:59:39 -0500708_iso-8859-1 I would appreciate a copy myself Thanks
-----Original Message----- From: Kim, Gye-Woo [mailto:GYE-WOO.KIM@CAI.COM] Sent: Wednesday, January 12, 2000 2:36 AM Subject: Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spa ces.
Hi.
I want to receive a copy. Please send to me.
Thanks.
> -----Original Message----- > From: Bartolucci Silvia [SMTP:S.Bartolucci@FONDIARIA.IT] > Sent: Wednesday, January 12, 2000 4:17 PM > To: DB2-L@RYCI.COM > Subject: R: DB2-OS/390- Statistical Analysis of Tablespaces and > Index spa ces. > > Hi, i'm very interested, please send a copy to me. > Thanks > Silvia > > > > -----Messaggio originale----- > > Da: [...]
7433 84 46_Re: Why isn't User Authorized? UDB v6.1 on AIX0_22_BILL_GALLAGHER@PHL.COM31_Tue, 18 Jan 2000 16:11:39 -0500470_us-ascii Kurt,
Thanks very much for pointing this out to me. I never even considered that UDB would not consider group privileges for binds, where it does for almost everything else. How annoying! Hopefully this inconsistency will be addressed by IBM in the future.
Bill
Kurt Sahlberg on 01/18/2000 03:55:02 PM
Please respond to DB2 Data Base Discussion List [...]
7518 205 27_Re: Cursor / Non-Cursor Mix15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Tue, 18 Jan 2000 16:30:05 -0500712_iso-8859-1 A small doubt in this big question. Will DB2 not materialize the result set in a hybrid join?
Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com
-----Original Message----- From: Lisle, Kathy [mailto:KLLISLE@INTEGON.COM] Sent: Tuesday, January 18, 2000 2:01 PM To: DB2-L@RYCI.COM Subject: Re: Cursor / Non-Cursor Mix
When you change your code to force materialization of the result set, make sure that you have bound your package/plan with ISOLATION(RR). Otherwise, once you've read and materialized your result set, someone else may update one of the rows you selected before you get to it. Then, you may [...]
7724 101 13_Re: Maxrows 124_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 18 Jan 2000 13:38:13 -0800413_- From the DB2 version 5 manual in Bookmanager:
MAXROWS integer Specifies the maximum number of rows that DB2 will consider placing on each data page. The integer can range from 1 through 255. This value is considered for INSERT, LOAD, and REORG. For LOAD and REORG, the PCTFREE specification is considered before MAXROWS; therefore, fewer rows might be stored than the value you specify for MAXROWS. [...]
7826 30 33_V6 Performance Question for DSMAX8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Tue, 18 Jan 2000 15:47:57 -0600467_us-ascii Hi, We are in the process of setting up a data warehouse. It seems we have altogether around 17,000 partitions and that much index partitions. That means more than 34,000 open/close datasets. We are in DB2V6 and OS390 2.6. My question is, because of this much of open datasets, did it affect overall system performance? Those work on this kind of DB2 shop, please share your experience. I would like to know the consequences of this much open datasets. [...]
7857 73 27_Re: Cursor / Non-Cursor Mix14_Harvey Wachtel22_babybaby@UAPC.CUNY.EDU31_Tue, 18 Jan 2000 16:56:03 -0500418_us-ascii "We're working on it, but it will take some time" is a long way from "It's working as designed, so you're out of luck". What's situation, actually?
Roger Miller cc: Sent by: DB2 Subject: Re: Cursor / Non-Cursor Mix Data Base Discussion List
2000-01-18 15:51 Please respond to DB2 Data Base Discussion List [...]
7931 40 50_DB2 Stored Procedure Builder and SQLSTATE checking17_Mark A. Phillippi28_mphillippi@SENTRY-DIRECT.COM31_Tue, 18 Jan 2000 16:14:02 -0600393_us-ascii I am working with DB2 Stored Procedure Builder and have the need to check the SQLSTATE after a SQL call. Pretty simple on the surface. The code I added to the stored procedure is below:
// set return parameter catch (SQLException e) {sqlCode = e.getErrorCode(); sqlState = e.getSQLState() ; if (sqlState.equals("00000")) { SECURE[0] = "Y" ; } else { SECURE[0] = "N" ; } } [...]
7972 40 29_Re: IBM DB2 "Tech Conference"13_Terry Shockey30_terry.shockey@MAIL.STATE.AR.US31_Tue, 18 Jan 2000 16:56:25 -0600472_iso-8859-1 ann here is the link for info on ibm db2 tech conference not much info yet, just time and place
-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Tuesday, January 11, 2000 3:27 PM To: DB2-L@RYCI.COM Subject: Re: IBM DB2 "Tech Conference"
Hi Lockwood, The title last year was DB2 and Data Warehouse Technical Conference. See http://www-3.ibm.com/services/learning/conf/index.html [...]
8013 155 13_Re: PCTFREE 015_Shaun Z Lombard36_Shaun.Z.Lombard@TRANSPORT.QLD.GOV.AU31_Wed, 19 Jan 2000 09:21:10 +1000440_us-ascii If the PCTFREE is zero for these tablespaces shouldn't the image copy utility report the "AVERAGE PERCENT FREE SPACE PER PAGE =" as zero ? or is the calculation of this also affected by the discrepancy ?
Thanks
Shaun Lombard
"Dan Courter (1-408-463-3870)" on 18/01/2000 18:19:41
Please respond to DB2 Data Base Discussion List [...]
8169 46 46_REXX for DB2 V6 beta now available (follow-up)14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Wed, 19 Jan 2000 10:42:26 +1000579_us-ascii In case any-one else is trying to use this, here are a few experiences I've had
- the error message tokens are returned in SQLERRM (not SQLERRMC as documented) - REXX variables in SQL text _must_ be in upper case, as well as preceeded by a colon. The other text can be in lower case. SQLCODE = -198 awaits violators in PREPARE statements, lost or uninitialised variables in other statements. - in a PREPARE statement, the name of the SQLDA stem _must not_ be preceeded by a colon (despite the examples), but can be lower case. SQLCODE -104 awaits violators. [...]
8216 198 23_Cursor / Non-Cursor Mix14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Wed, 19 Jan 2000 10:33:41 +1000358_iso-8859-1 Michael,
There are 2 main issues here for me. Firstly, after the Join, a singleton UPDATE statement is not advisable. I would like to see a Select for Update Cursor to re-select the row to be updated. This will ensure you do not update it if someone else already updated it to actioned. Also Select for Update helps prevent Deadlocks. [...]
8415 188 27_Re: Cursor / Non-Cursor Mix16_Raffi Garabedian22_hirondel@IX.NETCOM.COM31_Tue, 18 Jan 2000 18:45:50 -0600596_us-ascii set nomail DB2-L
"Lisle, Kathy" wrote:
> When you change your code to force materialization of the result set, make > sure that you have bound your package/plan with ISOLATION(RR). Otherwise, > once you've read and materialized your result set, someone else may update > one of the rows you selected before you get to it. Then, you may overlay > their update, and you'll have found your case in which separate applications > can unwittingly combine to expose data integrity. Thanks to Bonnie Baker > for covering this issue in one of her "Things I wish they'd told me [...]
8604 343 27_Re: Cursor / Non-Cursor Mix0_29_Greg.Palgrave@BANKWEST.COM.AU31_Wed, 19 Jan 2000 08:44:27 +0800330_us-ascii
The problem with the Hybrid Join is fixed by:
APAR Identifier ...... PQ25996
If you check the archives for Fri, 26 Nov 1999 with a "Subject: Re: Hybrid Join" there's a discussion of CURSOR WITH HOLD and Hybrid Join bug, plus a description of the APAR and a work around (force materialisation). [...]
8948 56 31_Re: DB2 High Performance Unload12_Kim, Gye-Woo19_GYE-WOO.KIM@CAI.COM31_Wed, 19 Jan 2000 11:54:56 +1100664_- Hi Bill.
How about testing the CA/FAST UNLOAD(old Platinum Fast Unload) ? If You want to receive the benchmark results, please send to me an email.
Best Regards.
> -----Original Message----- > From: BILL_GALLAGHER@PHL.COM [SMTP:BILL_GALLAGHER@PHL.COM] > Sent: Wednesday, January 19, 2000 5:18 AM > To: DB2-L@RYCI.COM > Subject: DB2 High Performance Unload > > Hi. We've just purchased and installed this utility from IBM. Early > testing > shows a pretty drastic improvement from DSNTIAUL performance. For > example, in > our very simplified benchmark testing, unloading a 3 million row table in > DSNTIAUL took over 13.5 minutes, High [...]
9005 23 56_Re: DB2-L Digest - 17 Jan 2000 to 18 Jan 2000 (#2000-18)15_Lynette Roberts21_llroberts@KSCABLE.COM31_Tue, 18 Jan 2000 19:32:38 -0600565_us-ascii When DB2 is installed on AIX, it will generate a specific entry for the instance owner's user process resource limits -- this is separate from the general defaults for all users that can be defined. Make sure to log onto your AIX machine as the DB2 instance owner user-id and issue the ulimit -a command to list the limits. If these aren't set to unlimited, you can either delete the user specific entry, or update it with the defaults that you desire. Since this takes effect on system logon, you will also need to stop and restart all DB2 instances [...]
9029 59 31_Re: Reducing extents on an NPI?14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Wed, 19 Jan 2000 13:25:44 +1000553_us-ascii Mike
In addition to using an HSM migrate - which requires HSM space, we have done this by using ADRDSSU (the DFSMS utility) with COPY DATASET(INCLUDE(cluster)) DELETE
(Of course, stopping the index beforehand)
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 james.campbell@energyis.com.au -----Original Message----- From: Jessen Michael [mailto:JessenMichel@JDCORP.DEERE.COM] Sent: Wednesday, January 19, 2000 12:42 AM To: DB2-L@RYCI.COM Subject: Reducing extents on an NPI? [...]
9089 42 13_Re: Maxrows 113_Marcel Lepage13_iml@COLBA.NET31_Tue, 18 Jan 2000 22:38:07 -0700315_iso-8859-1 Hi Martin,
I did some test using different values for MAXROWS and it worked fine. The number of row per pages was the same as the parameter.
Two things: 1) Be sure to do your runstats after the reorg 2) Use IBM reorg utilities and not Platinum Rapid Reorg (we`re waiting for a fix)... [...]
9132 130 46_Re: Why isn't User Authorized? UDB v6.1 on AIX11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 18 Jan 2000 21:47:34 -0500384_iso-8859-1 Just a footnote, this legacy "feature" has been in DB2 UNIX from the beginning. Group privileges (including belonging to "public") are not sufficient for static SQL bind processing. It is as if the "bind" program is unwilling to converse with the operating system to explore group membership. I first vented about this in 1996 I think, back on V2, then common server. [...]
9263 26 20_DB2 OS/390 IN-clause4_vcei14_vcei@CEGEKA.BE31_Wed, 19 Jan 2000 09:02:38 +0100497_iso-8859-1 Hi folks,
DB2 for OS/390, V5. This seems a basic problem to me, but nevertheless:
It appears the IN clause can not contain host-variables. "Application Programming and SQL guide" indeed only mentions "several listed values". Is our assumption correct ? If so, why do we only find this out through the result, running the query ? No precompile error, bind error, runtime SQL error or whatsoever. And - just curious - why aren`t host-variables not allowed / possible ? [...]
9290 64 15_Re: [Fwd: CDRN]14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Wed, 19 Jan 2000 09:15:20 +0100301_us-ascii Hi Mike,
I just checked via Omegamon, we have DSMAX at 10,000 and currently there are about 1,200 open datasets, so we are way out of hitting dsmax, and still we're running into problems for the 3rd day running. By now not only our end users are getting increasingly nervous .... [...]
9355 53 24_Re: DB2 OS/390 IN-clause0_24_ssethi@LOT.TATASTEEL.COM29_Wed, 19 Jan 2000 08:47:48 GMT571_us-ascii I think i couldn't get the question perfectly as the 'IN' clause can contain Host Variables in the embedded sql statements.
thanks
sanjeev
vcei @RYCI.COM> on 01/19/2000 01:32:38 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: DB2 OS/390 IN-clause
Hi folks,
DB2 for OS/390, V5. This seems a basic problem to me, but nevertheless: [...]
9409 16 56_Re: DB2-L Digest - 18 Jan 2000 to 19 Jan 2000 (#2000-19)15_Lynette Roberts21_llroberts@KSCABLE.COM31_Wed, 19 Jan 2000 03:03:11 -0600396_us-ascii PowerDesigner from Sybase works well with DB2 and other DBMS
http://www.sybase.com/products/powerdesigner/trial/ for a trial download copy
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9426 14 56_Re: DB2-L Digest - 18 Jan 2000 to 19 Jan 2000 (#2000-19)15_Lynette Roberts21_llroberts@KSCABLE.COM31_Wed, 19 Jan 2000 03:09:25 -0600328_us-ascii Perhaps this is a good candidate for posting to the new DB2-L-DOCUMENTS site?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9441 48 24_Re: DB2 OS/390 IN-clause15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 19 Jan 2000 10:13:39 +0000678_us-ascii Hello Els,
I copied this from the SQL reference. I suspect something else goes wrong. What is the error you are receiving?
"...Example 4: The following example obtains the phone number of an employee in DSN8610.EMP where the employee number (EMPNO) is a value specified within the COBOL structure defined below.
01 EMPNO-STRUCTURE. 05 CHAR-ELEMENT-1 PIC X(6) VALUE '000140'. 05 CHAR-ELEMENT-2 PIC X(6) VALUE '000340'. 05 CHAR-ELEMENT-3 PIC X(6) VALUE '000220'. . . . EXEC SQL DECLARE PHCURS CURSOR FOR SELECT PHONENO FROM DSN8610.EMP WHERE EMPNO IN (:EMPNO-STRUCTURE) END-EXEC. EXEC SQL OPEN PHCURS END-EXEC. EXEC SQL FETCH PHCURS INTO :PHNUM [...]
9490 82 24_Re: DB2 OS/390 IN-clause13_Deepak Kini M21_deepakk@WIPHYD.GE.COM31_Wed, 19 Jan 2000 15:05:02 +0530664_iso-8859-1 Hi Toine, I really wonder how does that Cobol program of yours work! Did we forget that there has to be a ',' between 2 values that we mention when we use 'IN' Clause?.
*************************************************************************** Deepak Kini M GE CBD Insurance Wipro-GE Offshore Development Center Wipro Technologies 1-8-448, Lakshmi Building S.P. Road, Begumpet, Secunderabad - India Tel : 91-40-7896008, Extn : 4519 Fax: 91-40-7896123 E-mail:Deepak.MKini@wipro.com deepakk@wiphyd.ge.com The World's First SEI CMM Level 5 Software Services Company **************************************************************************** [...]
9573 46 15_Re: [Fwd: CDRN]11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 19 Jan 2000 05:00:41 -0500409_ISO-8859-1 Hi Ruediger
I have run out of ideas, unless Omegamon is incorrectly reporting the drain lock. I have known there to be problems in Omegamon in the past in this area.
When you get the -904 and -911 errors, what messages show on the MSTR log? It may be another lock that is the problem. Does Omegamon Locking Conflicts screen show CDRN as a blocking lock for waiting transactions? [...]
9620 57 15_Re: [Fwd: CDRN]11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 19 Jan 2000 05:42:34 -0500489_ISO-8859-1 Hi Ruediger
The reason code in the message 00C900BA indicates that your CICS transaction LVBZ is attempting to acquire a drain lock on partition 1 of tablespace D00ZD030.TPZDN033 and is failing. The transaction must be doing a Long Claim - its the only time SQL tries to take a drain lock. The question is what lock is blocking it, if any? Or is the lock request failing for some other reason - IRLM storage exhausted maybe?? Any messages on the IRLM address space? [...]
9678 75 15_Re: [Fwd: CDRN]14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Wed, 19 Jan 2000 11:06:45 -0000361_- Aha!!
The transaction is not, by any chance, updating the partitioning key is it??
The new 'improvements' to Db2 to support primary key updating have the nasty effect of
"if the update causes the row to be moved from one partition to another then the original partition, the new partition and all intervening partitions are drained" [...]
9754 119 15_Re: [Fwd: CDRN]14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Wed, 19 Jan 2000 12:49:38 +0100600_us-ascii Hi Phil,
Well, well, well, it does indeed, it does indeed, but .... the tablespace has been partitioned for some time and there have been no - visible - problems with it and the applications have been updating the partitioning key for some time also, although the partitioning key has been altered during our re-design process; my understaning of partitioning keys is that only the first 40 bytes are used for deciding which partition to use, and the re-design has not affected the first 70 bytes of the partitioning key; some columns have been aded though, and one more foreign [...]
9874 66 24_Re: DB2 OS/390 IN-clause4_vcei14_vcei@CEGEKA.BE31_Wed, 19 Jan 2000 12:47:16 +0100346_iso-8859-1 Thanks to those who responded. IN clause with host variables DOES work. It appears we`ve been fooled, or rather... we`ve been fooling ourselves. Two consecutive jobs (with literals and with host vars) didn`t give the same result. Now they do.
Thanks Toine for your suggestion : a structure is even more interesting to use. [...]
9941 26 37_Decimal point conversion (DB2 for NT)14_Masone, Franco24_F.Masone@CEDACRIOVEST.IT31_Wed, 19 Jan 2000 13:03:08 +0100536_- Hi all, we use an NT application that needs setup of the English Language. The application performs select, insert and updates on a Db2 for OS390 Version 4.1. On the mainframe, being in Italy, we need to set "decimal point is comma". There are no problems when performing select but when the NT application performs an insert the host system detect an error because of the absence of the comma. How can I do this kind of translation and to have an English notation on NT and preserving "decimal point comma" on the host system ? [...]
9968 28 26_Re: Release(Deallocate) ??11_Hans Selman26_Hans.Selman@NL.ABNAMRO.COM31_Wed, 19 Jan 2000 05:56:16 -0600609_- Wayne
I did have some experience with release(deallocate) for online transactions. Yes, the online tranactions get faster and cheeper. And yes, we did have some side effects. 1. a particular batch job was timed-out (we didn't find an reason) by the online waiting transaction, but it did only 120 inserts, 1700 fetches and 2 deletes and request normally for max 2 pagelocks. 2. scheduled rebind jobs failed because the program stays active (ready for reuse). No real harm but giving application supporters a call late at night. 3. stop command (but not at commit) failed and waited for hours on [...]
9997 19 27_DB2 V4 Maint for Migration.9_Ted Pesta18_tpesta@AMQUEST.COM31_Wed, 19 Jan 2000 08:19:12 -0500305_iso-8859-1 Is there a stable maintenance level for V4 that has the correct migration maintenance for going to V5 ? I remember lots of trouble with 9907. Is there a better level, or is the program directory list all that's really needed to get to version 5 ?
Thank you. Ted Pesta AmQUEST, Inc. [...]
10017 71 31_Re: Reducing extents on an NPI?11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 19 Jan 2000 08:31:41 -0500343_iso-8859-1 Here is an example of DFDSS that I use to both move and consolidate extents. Naturally the objects must be stopped, or as in this case for directory and/or catalog objects DB2 is stopped.
The PERCENTU parm allows you to specify how "full" the candidate volumes gets before you move to the next one in the OUTDYNAM list. [...]
10089 26 14_QMF under CICS17_Bruzdzinski, Mike24_MIKE.BRUZDZINSKI@SSA.GOV31_Wed, 19 Jan 2000 08:40:53 -0500397_iso-8859-1 I was wondering if any sit used QMF under CICS? We have a financial DB2 systems that would like to use QMF for adhoc queuries. I have used QMF test system installs and to very data, but have not focused on it as a permaneny development tool.
Any help or insights that you can give would be greatly appreciated I Michael Bruzdzinski SSA mike.Bruzdzinski@ssa.gov 410-966-7185 [...]
10116 33 31_Re: DB2 V4 Maint for Migration.17_Luke G. Bauerlein24_lbauerlein@MANDTBANK.COM31_Wed, 19 Jan 2000 08:42:04 -0500301_US-ASCII Ted, I am in the process of going to V5 from V4 9907 (actually this weekend on a floor system). If you want to take this offline I can be reached at (716) 639 6052 or via email Lbauerlein@mandtbank.com. There are a few gotchas I ran in to which may be of interest to you. Luke Bauerlein [...]
10150 19 43_Info APAR for DB2 V5 to DB2 V6 Migration???0_23_pjackson@SUMMITBANK.COM31_Wed, 19 Jan 2000 08:51:56 -0500347_us-ascii Does anyone know of an Informational APAR that documents the minimum maintenance to be applied to DB2 Version 5 (PUT9810+) prior to migrating to DB2 Version 6??
I thought that for previous migrations I could find this information - I have not found anything for V6 migration, toleration fallback.
Thanks for your help. [...]
10170 62 47_Re: Info APAR for DB2 V5 to DB2 V6 Migration???9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 19 Jan 2000 13:57:54 +0000471_us-ascii II11442 describes the migration/fallback pts with appropriate PUT levels. The latest one of these is 9911. Ive not seen a 'minimum' PUT level. Kind Regards, Andy Hunt - Scottish And Southern Energy.
pjackson@SUMMITBANK.COM on 19/01/2000 13:51:56
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Info APAR for DB2 V5 to DB2 V6 Migration??? [...]
10233 23 78_Connecting DB2 tables between to seperate subsystems on the same OS390 systems11_Bernie Watt16_BWATT@KEYFIN.COM31_Wed, 19 Jan 2000 08:56:56 -0500456_us-ascii I'm currently trying to run a stored procedure on a test system that needs to connect to the production system for some of its tables. If anyone can direct me to the best way to acomplish this, I would be very thankfull. I am trying to set up the ties by using three part names, but trying to find what info to put in the location tables, is becoming very frustrating. Where is the guide for this, I keep finding pieces not the whole puzzle. [...]
10257 42 47_Re: Info APAR for DB2 V5 to DB2 V6 Migration???14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 19 Jan 2000 09:08:22 -0500293_us-ascii I haven't seen an info apar, but I recall with 9907 maint there was a preconditioning apar that required a cat maint and then shortly after that another apar came out that did not require the cat maint. We are rolling out 9911 next week I 'll check and see what I can find. Phil [...]
10300 39 47_Re: Info APAR for DB2 V5 to DB2 V6 Migration???17_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM31_Wed, 19 Jan 2000 09:05:08 -0500434_iso-8859-1 II11442
I'd recommend that you get UQ34283 as part of the V5 conditioning maintenance - deferring the CATMAINT to V6 where it should be reversible improves the sysprogs sleep.
Craig Snoeyenbos
-----Original Message----- From: pjackson@SUMMITBANK.COM [mailto:pjackson@SUMMITBANK.COM] Sent: Wednesday, January 19, 2000 8:52 AM To: DB2-L@RYCI.COM Subject: Info APAR for DB2 V5 to DB2 V6 Migration??? [...]
10340 18 52_Antwort: Info APAR for DB2 V5 to DB2 V6 Migration???0_25_Ha.Spurk@DEUTSCHERRING.DE31_Wed, 19 Jan 2000 15:10:25 +0100356_us-ascii Hi,
you can find the most recent information on Infoapar II11442.
regards
Hans Peter
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10359 27 31_attglobal.net is blocking DB2-L13_Morrill, John12_JohnM@VP.NET31_Wed, 19 Jan 2000 07:12:45 -0700562_iso-8859-1 Greetings!
For week we have been getting e-mail from subscribers who have not been receiving posting from the list. We have discovered that attglobal.net is blocking messages from the list because they think the list is spam.
We are working to get attglobal.net to lift the block. Today we will be sending out messages to all the subscribers that have attglobal.net addresses, informing them of the problem. If you happen to know someone who has an attglobal.net address and is not getting posting from DB2-L, please pass the word. [...]
10387 13 19_Please reinstate me14_Susan Birgeles25_Susan.Birgeles@ALLTEL.COM31_Wed, 19 Jan 2000 09:13:00 -0600336_us-ascii If I have been dropped from the list please reinstate me. My last message was 1/10/99
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10401 13 45_Re: Conversion of MS-ACCESS data bases to DB211_Bernie Watt16_BWATT@KEYFIN.COM31_Wed, 19 Jan 2000 08:15:44 -0600358_- A product we have used here with some success, for cross system convertions of table definitions, is ER-win. First you reverse engineer the source system. Then chage the target repositoy to the desired system. The final phase is running a script generation. I use the script method, don't feel comfortable letting it create the objects automatically. [...]
10415 77 82_Re: Connecting DB2 tables between to seperate subsystems on the same OS390 systems14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 19 Jan 2000 09:49:36 -0500420_us-ascii Bernie, We use application directed DRDA access between two subsystems instead of 3 part names. entries in sysibm.lunames on the system that I am going from are: (BOSDSNA)
LUNAME SECURITY IN SECURITY OUT
BOSPSFA A A
remaining columns have N's in them, with the exception of username, which is blank. The A means no password required. Username being blank means no useried translation. [...]
10493 141 31_Re: Reducing extents on an NPI?14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Wed, 19 Jan 2000 10:16:58 -0500780_iso-8859-1 OR - use DFDSS - try something like this ! < don't you just love skinning cats ? ;-) >
//* SSID: DSN#? //* STOP DB2 OBJECT //* MOVE DATASET //* START DB2 OBJECT //* //STOP EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT) //STEPLIB DD DISP=SHR,DSN=DSN#?.DSNLOAD //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DSN?) -STO DATABASE( dbname ) SPACENAM( ixspname ) //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSIN DD * //* //COPY1 EXEC PGM=ADRDSSU,REGION=4M //SYSPRINT DD SYSOUT=* //NEWVOL DD DISP=SHR,UNIT=3390,VOL=SER=DBPRDK //SYSIN DD * COPY DATASET (INCLUDE( - DSN#?.DSNDBC.dbname.ixspname.I0001.A001)) - OUTDD (NEWVOL) REP - DELETE CATALOG TOL(ENQF) /* //* //START EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT) //STEPLIB DD DISP=SHR,DSN=DSN#?.DSNLOAD //SYSTSPRT [...]
10635 43 82_Re: Connecting DB2 tables between to seperate subsystems on the same OS390 systems0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 19 Jan 2000 09:34:22 -0600506_us-ascii If you are not trying to do a join across subsystems, you could do a (DB2) CONNECT to the remote subsystem, get the data then re CONNECT to the original subsystem.
Bernie Watt on 2000/01/19 07:56:56 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Rohn Solecki/MTSCommunications/MTS) Subject: Connecting DB2 tables between to seperate subsystems on the same OS390 systems [...]
10679 108 15_Re: [Fwd: CDRN]14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Wed, 19 Jan 2000 17:03:36 +0100520_us-ascii Hi Phil,
it seems my former response was a bit premature; there were - and I didn't know that, because our application designers said there were only minor changes to the programs, that the program in question did update the partitioning index after all, whereas the older version of the program didn't; it appears that there is a PTF for DSNZPARMS where your installation can allow updates on the PI, may say no to updates on PI or may allow updates as long as the columns of the PI didn't change. [...]
10788 124 24_Re: DB2 OS/390 IN-clause20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 19 Jan 2000 11:10:10 -0500511_- Deepak
The precompiler is smart and replaces the group variable with multiple address of variables defined in the group variables when IN clause is used.
In the example below: -
01 EMPNO-STRUCTURE. 05 CHAR-ELEMENT-1 PIC X(6) VALUE '000140'. 05 CHAR-ELEMENT-2 PIC X(6) VALUE '000340'. 05 CHAR-ELEMENT-3 PIC X(6) VALUE '000220'.
Precompiler will split EMPNO-STRUCTURE into three different variables address (that of CHAR-ELEMENT-1, 2 and 3) So you still get the desired result. [...]
10913 82 17_The heroes of y2k16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Wed, 19 Jan 2000 11:17:00 -0500585_us-ascii 11 January 2000 COMPUTERWEEK The heroes of Y2K By Judy Backhouse
The truly crazy headed for the hills with fortified bunkers and ammunition. The more cautious bought water and tinned food. Even the most optimistic drew some extra cash the week before. Everyone speculated about the outcome.
But in the IT world, we worked. We checked code. We corrected code. We tested code. We rolled dates forrward and backward and forward and backward until our nerves were paper-thin. We upgraded hardware. We upgraded operating systems (to cope with the new hardware). [...]
10996 56 31_Re: DB2 V4 Maint for Migration.12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 19 Jan 2000 08:23:01 -0800420_us-ascii From comments that get back here, most of the glitches are covered fairly well in the updated soft copy and PSP bucket. Note Info APAR II10128, which is the V4 to V5 info APAR. You should probably write down II06683. It is the index for all of the other DB2 info APARs. Changing releases is always worth a call to the service group to see what they have, check on a good service level for your target, ... [...]
11053 19 26_What is the DB2 v5 Usermod0_22_Stepansky_Ruby@EMC.COM31_Wed, 19 Jan 2000 11:26:56 -0500510_- That allows controlled suspension of write I/O? Saw this mentioned in an SAP on OS/390 paper.
Ruby Stepansky EMC Sr. Enterprise Data Warehousing Technology Architect Office: 212-301-7093 Fax: 212-564-6909 stepansky_ruby@emc.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11073 111 21_Re: The heroes of y2k13_Adrian Savory24_adrian.savory@ZURICH.COM31_Wed, 19 Jan 2000 16:28:22 +0000313_us-ascii That's a bit over the top isn't it? I know a lot of people out there worked very hard to get around the Y2K issue, but don't forget that the IT industry was responsible for the bugs it was fixing in the first place.
My next mail will be entitled 'How to lose friends and alienate people' :-) [...]
11185 103 30_Re: What is the DB2 v5 Usermod0_20_John_Lendman@FPL.COM31_Wed, 19 Jan 2000 11:38:04 -0500386_us-ascii Here is what I have on this.
DB2 5.1 user modification: SUSPEND LOG writes The command SET ARCHIVE TIME(0) processes the following steps: 1 Set a log-write latch 2 Force out LOG buffers 3 Update the high-written RBA in the BSDS 4 Echo back high-written RBA in a response message SET ARC TIME(0) DSNJ337I SET ARCHIVE COMMAND COMPLETED, COUNT(HIGHRBA) TIME(000001CDED00,).
11289 35 30_Moving from One DB2 to Another15_Michael Bancale21_mbancale@TXFB-INS.COM31_Wed, 19 Jan 2000 10:46:52 -0600547_iso-8859-1 We are beginning a process of consolidating onto a single LPAR. This LPAR will be shared with our sister states. We will have all new DB2 regions installed on the new LPAR with a different name than we are currently using. We have the BMC Change manager product and my initial thought was to use the BMC CHange manager product to migrate the structures and data. This would be accomplished by putting the WORK LIST and output files on Shared DASD. I would then go to the new LPAR and new DB2 and bring the worklist in to create my [...]
11325 307 57_Career Tips for the Database Professional - February 200013_Morrill, John12_JohnM@VP.NET31_Wed, 19 Jan 2000 10:47:39 -0700500_iso-8859-1 Greetings!
Below is a copy of a newsletter I received. It is sponsored by a search firm and it does have some good content. If you are interested, there is information in the newsletter about how to subscribe.
Cheers!
J. Michael Morrill DB2-L Chief List Owner
-----Original Message----- From: John Sroka [mailto:john@dbajobs.com] Sent: Wednesday, January 12, 2000 1:23 AM To: johnm@vp.net Subject: Career Tips for the Database Professional - February 2000 [...]
11633 40 45_Re: Conversion of MS-ACCESS data bases to DB212_Jim Herrmann12_b3d@CUOL.NET31_Wed, 19 Jan 2000 11:50:53 -0600407_us-ascii I've done this before using ERwin. When converting from Access, the conversion goes fine as long as the Access data base uses naming standards that are acceptable to you. You will also have to add all table space and index space information since these are foreign concepts to Access. The tables and their relationships should convert intact. That's probably what you are really after anyway. [...]
11674 180 39_Re: Reorg of the Catalog and Directory.16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Wed, 19 Jan 2000 13:07:20 -0500645_- In our shop, the catalog is reorged by the DB2 System's Programmer only.
Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee
> -----Original Message----- > From: Julian_Peacock@SWEB.CO.UK [SMTP:Julian_Peacock@SWEB.CO.UK] > Sent: Monday, January 17, 2000 10:50 AM > To: DB2-L@RYCI.COM > Subject: Reorg of the Catalog and Directory. > > Fellow DB2'ers, > > I have, like everyone else, witnessed the large volume of interest > shown in Dr. Ebert's posted Reorg jobs. I do have some queries > regarding this matter: > > * Firstly, I was wondering how many sites have actual ever Reorged > the > Catalog and [...]
11855 86 39_DB2 Connect & Multiple copies of TCP/IP10_Wang.James24_Wang.James@AAA-CALIF.COM31_Wed, 19 Jan 2000 10:41:38 -0800399_iso-8859-1 Is this still hold truth?
We are evaluating the usability of DB2 Connect. In reading one of the IBM red book, "WOW ! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 Universal Database", SG24-2212-00. It states in appendix D.3 that " ... When you have DB2 using TCP/IP, however, you can have only one TCP/IP instance connect to OpenEdition MVS on the same MVS system, ..." [...]
11942 46 43_Re: DB2 Connect & Multiple copies of TCP/IP12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 19 Jan 2000 10:57:32 -0800348_us-ascii My understanding of this means that you can only connect to one DB2 subsystem at a time via TCPIP. We've got in production an application that has between 3-12 different threads over the same TCPIP DB2 connection to the same production DB2 at the same time. Each thread has its own DB2 thread ID. But each one uses the same 446 port. [...]
11989 128 13_Re: PCTFREE 024_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Wed, 19 Jan 2000 14:19:13 -0500387_- Is there a method to determine if the DBD and the catalog match? It would be useful to test the condition before and after applying the fix. Thx in advance.
Dave Gendron Colorado Springs, CO 80903 dave.gendron@coastalcorp.com
-----Original Message----- From: Dan Courter (1-408-463-3870) Sent: Tuesday, January 18, 2000 1:20 AM To: DB2-L@RYCI.COM Subject: PCTFREE 0 [...]
12118 199 43_Re: DB2 Connect & Multiple copies of TCP/IP10_Wang.James24_Wang.James@AAA-CALIF.COM31_Wed, 19 Jan 2000 11:20:38 -0800443_us-ascii My concern is we run multiple copies of TCP/IP on our production MVS system.
James Wang Sr. Systems Programmer Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com
-----Original Message----- From: Myron Miller [SMTP:myronwmiller@YAHOO.COM] Sent: Wednesday, January 19, 2000 10:58 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect & Multiple copies of TCP/IP [...]
12318 39 42_V6 Performance Question for DSMAX - REPOST8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Wed, 19 Jan 2000 13:33:19 -0600604_us-ascii Hi All, I am resenting this because i didn't receive a single reply for this. We are more that 2000 DB2 professionals here, i hope atleast somebody can give an answer.
Thanks Bejoy
Hi, We are in the process of setting up a data warehouse. It seems we have altogether around 17,000 partitions and that much index partitions. That means more than 34,000 open/close datasets. We are in DB2V6 and OS390 2.6. My question is, because of this much of open datasets, did it affect overall system performance? Those work on this kind of DB2 shop, please share your experience. [...]
12358 39 43_Re: DB2 Connect & Multiple copies of TCP/IP15_Zander, Barb J.19_bzander@STATE.ND.US31_Wed, 19 Jan 2000 13:37:21 -0600487_iso-8859-1 James, We are running OS/390 2.7 and have 2 TCP/IP instances running under OpenEdition. This was also the case in OS/390 2.5. But when we were at OS/390 1.3 we only had 1 instance connected to OpenEdition(on purpose). I don't believe it was a requirement though.
Barb
-----Original Message----- From: Wang.James [mailto:Wang.James@AAA-CALIF.COM] Sent: Wednesday, January 19, 2000 12:42 PM To: DB2-L@RYCI.COM Subject: DB2 Connect & Multiple copies of TCP/IP [...]
12398 88 11_DCLGEN plan11_Craig Otway16_otwayc@TENET.EDU31_Wed, 19 Jan 2000 13:40:35 -0600619_iso-8859-1 The DCLGEN plan DSNEDCL/DSNECP68 was bound to SS DSN1 overriding the correct SS DSNA resulting in an -818 on a dclgen to DSNA. I bound the plan to DSNA and it successfully ends with RC 0 and writes out the copy book. The problem is that IKJEFT01 is writing out some error messages: IKJ56286I SYSTEM OR INSTALLATION ERROR. REPORT THE FOLLOWING MESSAGE TO YOUR IKJ56286I SYSTEM OR INSTALLATION ERROR. REPORT THE FOLLOWING MESSAGE TO YOUR IKJ56284I UNABLE TO ISSUE MESSAGE TO TERMINAL M02D BECAUSE ZERO CPPL POINTER WHEN PUTLINE/PUGET IKJ56285I FIRST BUFFER NOT SUPPLIED, MESSAGE NOT EXTRACTED FOR ID 9370 [...]
12487 67 15_Re: DCLGEN plan0_24_Ray.Price@DRESDNERKB.COM31_Wed, 19 Jan 2000 19:42:04 -0000668_- See APAR PQ01103.
Have a nice day.
Ray Price DBA Dresdner Kleinwort Benson London
-----Original Message----- From: Craig Otway [SMTP:otwayc@TENET.EDU] Sent: Wednesday, January 19, 2000 7:41 PM To: DB2-L@RYCI.COM Subject: DCLGEN plan
The DCLGEN plan DSNEDCL/DSNECP68 was bound to SS DSN1 overriding the correct SS DSNA resulting in an -818 on a dclgen to DSNA. I bound the plan to DSNA and it successfully ends with RC 0 and writes out the copy book. The problem is that IKJEFT01 is writing out some error messages: IKJ56286I SYSTEM OR INSTALLATION ERROR. REPORT THE FOLLOWING MESSAGE TO YOUR IKJ56286I SYSTEM OR INSTALLATION [...]
12555 41 43_Re: DB2 Connect & Multiple copies of TCP/IP11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 19 Jan 2000 11:58:07 PST616_- That is what we have been told and is how we are running db2 and tcpip. We also are at db2 v.5.1 and mvs 1.3. Regards, Rick Creech
>From: "Wang.James" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DB2 Connect & Multiple copies of TCP/IP >Date: Wed, 19 Jan 2000 10:41:38 -0800 > >Is this still hold truth? > >We are evaluating the usability of DB2 Connect. In reading one of the IBM >red book, "WOW ! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 >Universal Database", SG24-2212-00. It states in appendix D.3 that " ... [...]
12597 63 46_Re: V6 Performance Question for DSMAX - REPOST0_23_Mike_Levine@TEKHELP.NET31_Wed, 19 Jan 2000 15:00:04 -0500513_us-ascii Hi,
I guess I qualify as one of the 2k DB2 professionals on this list. There is a small amount of overhead associated with each open (allocated) dataset. For a relatively low volume data warehouse application you could consider defining the tablespaces and indexes with CLOSE YES and let DB2 open and close the datasets as required. DB2 will not actually close (deallocate) the dataset unless you approach the DSMAX limit which you can leave relatively high (10,000 or more) with no problem. [...]
12661 83 43_Re: DB2 Connect & Multiple copies of TCP/IP11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 19 Jan 2000 12:03:49 PST650_- IBM support told us to connect only one of the tcpip systems to OMVS. This is done via a parm in tcpip profile: NOOE. Put NOOE in all of the tcpip profiles that you do not wish to connect to OMVS. Rick Creech
>From: "Wang.James" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: DB2 Connect & Multiple copies of TCP/IP >Date: Wed, 19 Jan 2000 11:20:38 -0800 > >My concern is we run multiple copies of TCP/IP on our production MVS >system. > >James Wang >Sr. Systems Programmer >Automobile Club of Southern California >(714) 850-2851 >Wang.James@aaa-calif.com [...]
12745 43 27_DB2/CICS mirror transaction0_19_csutfin@AMSOUTH.COM31_Wed, 19 Jan 2000 14:04:45 -0600340_- OK, all of the DB2/CICS gurus
We have a strange problem. The environment is MVS5.2.2, DB2 4.1, and CICS4.1.0
CICS region AA has an APPC connection (LU6.2) being used to process a transaction BBBB from a server.
Transaction BBBB is defined in region AA with program = DFHMIRS. (That's what the vendor asked for.) [...]
12789 22586 18_DB2 Control Center16_Marcelo Silveira20_marbatis@HOTMAIL.COM29_Wed, 19 Jan 2000 11:57:36 PST376_- Hello everyone,
I am trying to use DB2 Control Center , but it is not working. My environment is DB2 OS/390 V5.1 , DB2 Connect PE 6.1 (Applied FP2) ,Windows/NT 4.0 Service Pack 4. All the required PTFs and 390 Enablement were applied. I am using a DDCS gateway. When I click on Tables or any other "object" nothing happens… I appreciate any suggestion. Marcelo. [...]
35376 51 31_Re: DB2 V4 Maint for Migration.14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Wed, 19 Jan 2000 20:11:58 -0000269_- I'd appreciate this NOT going offline!!
I am visiting a customer here in Athens that's trying to get from V4 (I think 9907 or maybe earlier) to V5 vand gets S0C4s in CATMAINT (urgh). He has an open PMR with IBM but anything else we can do to help him out [...]
35428 99 43_Re: DB2 Connect & Multiple copies of TCP/IP15_Zander, Barb J.19_bzander@STATE.ND.US31_Wed, 19 Jan 2000 14:11:20 -0600556_iso-8859-1 Rich, Just so you know. When you get to OS/390 2.5 the NOOE parm is no longer valid. Everything must go thru OpenEdition.
-----Original Message----- From: rick creech [mailto:ykcirc@HOTMAIL.COM] Sent: Wednesday, January 19, 2000 2:04 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect & Multiple copies of TCP/IP
IBM support told us to connect only one of the tcpip systems to OMVS. This is done via a parm in tcpip profile: NOOE. Put NOOE in all of the tcpip profiles that you do not wish to connect to OMVS. Rick Creech [...]
35528 39 50_Re: REXX for DB2 V6 beta now available (follow-up)13_Scott Goodell24_Scott.E.Goodell@WCOM.COM31_Wed, 19 Jan 2000 13:59:03 -0600365_us-ascii James, have you tried to use multiple cursors at the same time with the REXX interface? If I have more then one open at a time I get -313 sqlcodes on the open cursors. I must issue the Declare again for the cursor in order to process it. I also have the same problem if I prep/declare a cursor issue a delete from a table then try to open the cursor. [...]
35568 29 12_snapshot/db211_Danny Davis16_DTDAVIS@PCMH.COM31_Wed, 19 Jan 2000 15:48:48 -0500481_US-ASCII For disaser recovery purposes, we are currently bringing down DB2 weekly, performing a DFDSS backup and bring DB2 backup. For DR testing, we would restore the DFDSS backups and then apply the DB2 image copies to get back to a specific point-in-time. The problem is the downtime for the DFDSS backups has gotten too long. We are now testing snapshot as an alternative to DFDSS. Does anyone have any red flags with regard to using snapshot to perform the cold backups? [...]
35598 181 21_Re: The heroes of y2k13_John Arbogast16_jfarbo@YAHOO.COM31_Wed, 19 Jan 2000 12:58:02 -0800530_us-ascii Easy there..... Not all of us were around back when 2 digits saved enough storage to make a difference.
;-)
--- Adrian Savory wrote: > That's a bit over the top isn't it? I know a lot of > people out there worked very > hard to get around the Y2K issue, but don't forget > that the IT industry was > responsible for the bugs it was fixing in the first > place. > > My next mail will be entitled 'How to lose friends > and alienate people' :-) > > Adrian Savory > ACSIS Ltd > [...]
35780 85 39_Re: Reorg of the Catalog and Directory.13_John Arbogast16_jfarbo@YAHOO.COM31_Wed, 19 Jan 2000 13:05:04 -0800637_us-ascii We have reorged our development catalogs due to the volume of activity. We do it once or twice a year. Peoplesoft caused us to do it the first time. DB2 system programmers only as we start the subsystem in maint mode to do the reorgs/resizing.
--- "Milligan, Andrea" wrote: > In our shop, the catalog is reorged by the DB2 > System's Programmer only. > > Andrea Milligan > DataBase Administrator > BlueCross BlueShield of Tennessee > > > -----Original Message----- > > From: Julian_Peacock@SWEB.CO.UK > [SMTP:Julian_Peacock@SWEB.CO.UK] > > Sent: Monday, January 17, 2000 10:50 AM > > To: [...]
35866 48 16_Re: snapshot/db213_John Arbogast16_jfarbo@YAHOO.COM31_Wed, 19 Jan 2000 13:11:58 -0800573_us-ascii We use snapshot, but since we are in recovering 12T of data, we do not intend to come forward.
--- Danny Davis wrote: > For disaser recovery purposes, we are currently > bringing down DB2 weekly, performing a DFDSS backup > and bring DB2 backup. For DR testing, we would > restore the DFDSS backups and then apply the DB2 > image copies to get back to a specific > point-in-time. The problem is the downtime for the > DFDSS backups has gotten too long. We are now > testing snapshot as an alternative to DFDSS. Does > anyone [...]
35915 61 26_Re: Release(Deallocate) ??12_Mckay, Wayne24_Wayne.Mckay@ATCOITEK.COM31_Wed, 19 Jan 2000 14:33:35 -0700409_- Thanks Hans
Yes, I believe point #2 would be a concern for us. Are you talking about Production or Test programs? If Production, would you not want the rebind to fail so that the plan/package remains static thru out the job execution?
Point #3 should be OK with us as we vary rarely if ever, issue Stops in the Production environment that are not scheduled to run at an appropriate time. [...]
35977 12 45_Re: Conversion of MS-ACCESS data bases to DB212_Jason Hughes20_jason.hughes@TRW.COM31_Wed, 19 Jan 2000 16:12:04 -0600447_- Found this on one of my archives back from June, 99. Never did use the Scriptoria product since the legacy database we converted was not Access. http://www-4.ibm.com/software/data/db2/udb/scriptoria.html
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
35990 125 24_Re: Consulting in Canada14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 20 Jan 2000 09:10:29 +1000629_us-ascii >Date: Wed, 19 Jan 2000 02:02:55 +1000 >To: "Livingstone, Gini" >From: Michael Hannan >Subject: RE: Consulting in Canada > >Gini, > >I have reviewed the contract and find a couple of things a little "over the top" and possibly a little one sided also. >This probably a standard contract for major contract companies doing major jobs. >However here we are dealing with a small contract and my company is very small indeed. > >Section 3 (f) is provides for alternative personel and an overlap of 10 days. >The contrart is only for 10 days and I don't really [...]
36116 16 7_PQ1567012_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 19 Jan 2000 14:49:00 -0500329_- We are having performance problems after rebinding some programs in V5.1. They were running fine in V5.1 before the rebind. I have seen PQ15670 and it looks like a candidate for fixing some of our grief. Does anyone know of any other APARs that address performance issues in V5.1? We are on Put 9903 and non data sharing. [...]
36133 88 50_Re: REXX for DB2 V6 beta now available (follow-up)14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Thu, 20 Jan 2000 10:03:02 +1000462_us-ascii No, because I haven't tried it. It was on the list of things to try. However, I am not surprised! If you look at the DBRM you will see that PREPARE, OPEN, FETCH and CLOSE statements for cursors C2 through C100 (and C102 through C200) don't exist. That is, it can use only one cursor - C1. This also means that, while you might think you are using a CURSOR ... WITH HOLD, in fact it will be run as a non-HOLD cursor: so SQLCODE=-501 after a COMMIT. [...]
36222 16 17_Disaster Recovery16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Wed, 19 Jan 2000 16:38:00 -0800458_- We have begun testing disaster recovery procedures using DB2 V5 for MVS. What we want to do is recover the DB2 catalog/directory then a few user tablespaces and indices. Then we want the users of those DB2 objects to start their applications while we continue recovering other user objects. I know we have to restart DB2 in ACCESS(*) mode for users to access but I am unsure about changing the DEFER(ALL) DSNZPARM value used during the first startup. [...]
36239 56 54_PeopleSoft on DB2 for OS/390 Tuning Classes - FEB 200013_BRIAN HOLROYD31_BRIAN_HOLROYD@DB-CONSULTING.COM31_Wed, 19 Jan 2000 17:58:29 -0800200_iso-8859-1 Classes currently being scheduled in:
New York 1/31 - 2/1 (need to register by 1/21) Kansas City 2/14 - 2/15 Orlando 2/28 - 2/29
Please visit www.db-consulting.com for details
36296 23 45_Apologies: Please ERASE: Consulting in Canada14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 20 Jan 2000 13:00:39 +1000581_us-ascii Apologies to the list.
A personal Email was incorrectly sent to the list due to a cut address failure followed by paste of wrong Email address.
From: Michael Hannan
>Date: Thu, 20 Jan 2000 09:10:29 +1000 >To: DB2-L@RYCI.COM >From: Michael Hannan >Subject: RE: Consulting in Canada >
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
36320 74 31_Re: DB2 V4 Maint for Migration.18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM31_Wed, 19 Jan 2000 22:20:12 -0500597_- I would also like to hear the gotcha's. One of my teammates tried to migrate our DBA-test subsystem, but we ran into so many problems that we went back to V4 and will try again soon. Thank you all for the valuable information.
Deborah Gresham South Carolina Electric & Gas
> -----Original Message----- > From: Grainger, Phil [SMTP:Phil.Grainger@CAI.COM] > Sent: Wednesday, January 19, 2000 3:12 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 V4 Maint for Migration. > > I'd appreciate this NOT going offline!! > > I am visiting a customer here in Athens that's trying to get from [...]
36395 22 55_Connectivity products from lotus notes to DB2 on OS/39010_K V Ramana27_kv_ramana@CHENNAI.TCS.CO.IN31_Thu, 20 Jan 2000 11:47:23 +0530463_us-ascii Hi all, I would like to know info about various connectivity products for accessing DB2 on OS/390 from lotus notes. I know Lotus Pump is one such product(Lotus Enterprise Integrator). Lotus Notes home page talks about lot of products cannecting to many RDBMS products but none was for OS/390. And LotusPump for DB2 on OS/390 is still a beta version. Is this the latest news or are there any new developments? Any info on these lines is appreciated. [...]
36418 17 22_Re: DB2 Control Center32_=?iso-8859-1?q?Martin=20Horgan?=15_mphcc@YAHOO.COM31_Thu, 20 Jan 2000 00:26:37 -0800426_iso-8859-1 Please don't send large attachments. __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
36436 238 15_Re: [Fwd: CDRN]14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Thu, 20 Jan 2000 09:44:41 -0000361_iso-8859-1 I think that this partitoned data movement in update of partitioning key is maybe not completed yet.
It was put in to DB2 to satisfy large ERP installations that want to partition but have no control over updating of columns.
Maybe someone from IBM (Roger??) can indicate whether this pseudo-restriction is likely to be permanent! [...]
36675 22 26_Re: Release(Deallocate) ??14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 20 Jan 2000 11:08:38 +0100364_us-ascii Yes, it was almost the same in previous shop were I worked.
We use RELEASE(DEALLOCATE) following David Beulke's hints on RCT tuning (DB2 mag, spring '98) and It worked well, using THRDS for protected threads. With some operational limitations: the most important was the problem in 'emergency' production rebind (you have to disconnect CICS). [...]
36698 47 26_Re: Release(Deallocate) ??14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 20 Jan 2000 11:56:08 +0100633_us-ascii We also use release(deallocate) in some cases and, as Massimo stated, also use protected threads, but we sometimes encounter problems during our maintenance times, when all protected threads have to be disabled; apart from that we experience no probs with that.
Regards Ruediger Kurtz
Massimo Scarpa schrieb: > > Yes, it was almost the same in previous shop were I worked. > > We use RELEASE(DEALLOCATE) following David Beulke's hints on RCT tuning (DB2 > mag, spring '98) and It worked well, using THRDS for protected threads. > With some operational limitations: the most important was the problem in > [...]
36746 29 30_Re: DB2 V4 Maint for Migration0_32_MLANGLEY@CEDELGLOBALSERVICES.COM31_Thu, 20 Jan 2000 12:06:43 +0100508_- Phil
We had a similar problem (0C4 in catmaint migrating from V4 to V5) at the end of November. PQ31296 fixed it.
Cheers Moira
Visit us at http://www.cedelinternational.com or http://www.cedelglobalservices.com or http://www.cedelbank.com
***************************** IMPORTANT MESSAGE ********************************* Internet communications are not secure and therefore Cedel International does not accept legal responsibility for the contents of this message. [...]
36776 119 31_Re: DB2 V4 Maint for Migration.9_Ted Pesta18_tpesta@AMQUEST.COM31_Thu, 20 Jan 2000 06:22:26 -0500506_iso-8859-1 Deborah and Phil,
I spoke to Phil and he was most helpful. Look in Info APAR II10128. It is continued in II12123. This covers maint required for both V4 and V5. Phil indicated that PTF UQ31453 is also needed. If you check the DB2 list archives you will find some more information about this migration. V4 maint level 9907 appears to have been a problem for lots of others. Like several others also mentioned, it never hurts to check the PSP bucket to see what else may have come up. [...]
36896 11 0_12_Perry Pounds27_Perry.Pounds@DIRECTLINE.COM31_Thu, 20 Jan 2000 12:02:15 +0000302_us-ascii Can someone please verify how to sign-off the list.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
36908 177 31_Re: DB2 V4 Maint for Migration.17_Luke G. Bauerlein24_lbauerlein@MANDTBANK.COM31_Thu, 20 Jan 2000 08:07:59 -0500375_US-ASCII I sent this attachment to George and others. Hope it helps.
>>> "GRESHAM, DEBORAH B" 01/19/00 10:20PM >>> I would also like to hear the gotcha's. One of my teammates tried to migrate our DBA-test subsystem, but we ran into so many problems that we went back to V4 and will try again soon. Thank you all for the valuable information. [...]
37086 98 31_Re: DB2 V4 Maint for Migration.13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Thu, 20 Jan 2000 08:28:04 -0500566_us-ascii We had similar problems long ago. Apart from the PTF mentioned in another post, the problem we found was that, for some reason, our Catalog and/or Directory were out-of -sync. This was possibly caused by a (long-ago?) failed Reorg, failed or improper index recovery, or some such.
There's a step in the Migration titled, "Check for Consistency between Catalog Tables", or something like that. It's a set of queries you run that check things like 'Are all the Tablespace names in SysTables present in SysTablespace?', etc. We ran these in SPUFI. [...]
37185 26 22_Net.Data Info required13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Thu, 20 Jan 2000 18:56:17 +0530256_us-ascii hi !! Can anybody help me out. I want to know FastCGI is supported on which platforms by Net.Data. It says in the IBM site that FastCGI is not supported in NT / OS2 . Now in Linux is it supported ? if yes , then in which version of Net.Data. [...]
37212 42 32_Re: Reducing Extents on an NPI ?0_19_ddzienni@US.IBM.COM31_Thu, 20 Jan 2000 08:57:10 -0500479_us-ascii In reply to: -----Original Message----- From: Jessen Michael [mailto:JessenMichel@JDCORP.DEERE.COM] Sent: Tuesday, January 18, 2000 9:42 AM Subject: Reducing extents on an NPI?
I have an index that currently has 107 extents. This is an NPI for a table with 72 partitions.
This particular table has over 100 million rows of data. After I alter the space, Is there any other way to reduce the extents without having to rebuild the entire index? [...]
37255 48 82_Central PA - March 22-23th - DB2 Classes by Sheryl Larsen, RYC - Time to register!10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Thu, 20 Jan 2000 08:51:07 -0500268_us-ascii Greetings!
On March 22-23th, Sheryl Larsen of RYC will be teaching two DB2 classes in Camp Hill, PA. (Camp Hill is right next door to Harrisburg.)
The classes will be held in the Camp Hill Corporate Center Building 300 Auditorium. The dates are:
37304 43 22_Re: DB2 Control Center14_Philip Gunning20_pgunning@BOSCOVS.COM31_Thu, 20 Jan 2000 09:40:28 -0500305_us-ascii Marcelo, Have you tried a test connection? Did that work ok? Did you bind the DB2 Connect plan and packages? Are your TCPIP ports setup correctly? Can you ping the DB2 port from your workstation? Check these out and you should find your problem. HTH Phil P.S. I stripped off the attachment. [...]
37348 55 11_Re: PQ1567011_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 20 Jan 2000 06:54:25 PST551_- A performance problem that we had in one of our data centers when we went to version 5: Some critical sql against one of the tables started doing rid sorts where on version 5 there was none, and in this case performance went from a batch job running in about 1/2 hour to running for several hours. It turned out that version 4 was more forgiving than version 5 concerning how clustered some tablespaces had to be before considering an alternate access path. Once we did reorg, runstats, rebind in version 5; we got the same access path that we [...]
37404 22 38_Re: Tool for diagramming DB2 databases12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 20 Jan 2000 09:38:41 -0600670_us-ascii Sybase's PowerDesigner (using its reverse engineering function) should be able to do this for you. A free 30-day trial download can be found at http://www.sybase.com/products/powerdesigner/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Steve Grimes Washington University Information Systems OS/390 V2R6 DB2 UDB 6.1 W: 314-935-4376 H: 314-928-5005 Isa.64:6 Steve_Grimes@aismail.wustl.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
37427 24 31_dealing with mixed case columns13_Assaf Lev-Ram19_assaf.l@SAPIENS.COM31_Thu, 20 Jan 2000 10:36:20 -0500414_iso-8859-1 Hi ! Very simple question (I hope): Let's say that one of columns of a table is a text column which can have both UPPER and LOWER case (MIXED). In order to use that column efficiently in a search we want to define an index on it. The thing is that we want this index to be UPPER case only (i.e. - the text in the column to be translated to UPPER case in the index). Is there an easy way to do it ? [...]
37452 27 21_Re: Disaster Recovery12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 20 Jan 2000 10:19:00 -0500621_- Db2 is started with defer all while recovering all apps, then just rename the default dsnzparm to dsnzparo and rename a dsnzparm containing site type "recovery site" and "restart all" to the default-dsnzparm. We do this in case the system/DB2 comes down so it will use the restart. My experiences/opinions. >>> DB2-L@RYCI.COM@inter2 01/19/00 05:38PM >>> We have begun testing disaster recovery procedures using DB2 V5 for MVS. What we want to do is recover the DB2 catalog/directory then a few user tablespaces and indices. Then we want the users of those DB2 objects to start their applications while we continue [...]
37480 30 60_Job Available: DB2 DBA/Developer in Manhattan, New York, USA17_Mohammed J. Kabir26_kabir@INTEGRATIONLOGIC.COM31_Thu, 20 Jan 2000 11:17:54 -0500455_us-ascii My company is looking for a DB2 DBA/developer as a full-time staff member. Our platform is Linux/Apache and applications are all mod_perl and Java based.
The company is a venture funded Internet startup located in Manhattan, NY.
Potential applicants please send resume or inquiries to hr-db2dev@integrationlogic.com
Recruiters or agencies need to inquire. Also, this is a *ON-SITE* position and requires US citizenship. [...]
37511 27 38_Use of IBM DF/SMS for Manging DB2 Dasd11_Jeff Schade15_JSCHADE@PCH.COM31_Thu, 20 Jan 2000 11:26:34 -0500317_- We are currently researching the benefits of implementing IBM System Managed Storage for our DB2 sub-systems. We are currently running OS/390 2.7 and DB2 5.1 and are hoping to eliminate some of the manual steps involved in allocating DB2 tables and indexes. We currently use DB2 STOGROUPS for all allocations. [...]
37539 76 31_Re: DB2 V4 Maint for Migration.12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 20 Jan 2000 18:33:24 +0200313_x-user-defined Hi, I had it a few weeks ago in one customer site. Turns out that there is an APAR (I don't have its number here) that corrected a conversion problem of the either sysstogroup or sysvolumes when going from V4 to V5. Without it the CATMAINT abended 0C4 on the after th2 2nd message while converting.
37616 46 21_AW: Disaster Recovery0_25_carsten.peterreins@TUI.DE31_Thu, 20 Jan 2000 17:35:34 +0100714_iso-8859-1 -----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]Im Auftrag von BOB JEANDRON Gesendet am: Donnerstag, 20. Januar 2000 16:19 An: DB2-L@RYCI.COM Betreff: Re: Disaster Recovery Vertraulichkeit: Persönlich
Db2 is started with defer all while recovering all apps, then just rename the default dsnzparm to dsnzparo and rename a dsnzparm containing site type "recovery site" and "restart all" to the default-dsnzparm. We do this in case the system/DB2 comes down so it will use the restart. My experiences/opinions. >>> DB2-L@RYCI.COM@inter2 01/19/00 05:38PM >>> We have begun testing disaster recovery procedures using DB2 V5 for MVS. What we want to do [...]
37663 20 22_Re: DB2 Control Center0_15_leon@CA.IBM.COM31_Thu, 20 Jan 2000 11:32:33 -0500441_us-ascii You say that you have DB2 Connect Personal Edition installed on the machine where you are using the Control Center. If this is indeed the case then you will want to use DB2 CCA to add a direct connection to your DB2 for OS/390. Once you do that, you will see another system on the explorer tree corresponding to your DB2 for OS/390 subsystem. You will be able to operate on all objects in the explorer tree for that subsystem. [...]
37684 45 21_Re: Disaster Recovery13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 20 Jan 2000 10:38:27 -0600653_US-ASCII Why not just assemble dsnzparm under a new name like dsnzprmd and use the DB2 START PARM(DSNZPRMD) command. Kurt
>>> BOB JEANDRON 01/20/00 09:19AM >>> Db2 is started with defer all while recovering all apps, then just rename the default dsnzparm to dsnzparo and rename a dsnzparm containing site type "recovery site" and "restart all" to the default-dsnzparm. We do this in case the system/DB2 comes down so it will use the restart. My experiences/opinions. >>> DB2-L@RYCI.COM@inter2 01/19/00 05:38PM >>> We have begun testing disaster recovery procedures using DB2 V5 for MVS. What we want to do is recover [...]
37730 20 42_O.T. - search for s/390 related newsgroups14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 20 Jan 2000 17:44:12 +0100480_us-ascii It's a little OT, but can someone post addresses (if any) of S/390 and related discussion groups
and/or newsgroups (CICS, DASD management, programming, S/390 web apps, and so on) ?
Thanks & regards
Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
37751 70 46_Re: O.T. - search for s/390 related newsgroups0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 20 Jan 2000 10:51:24 -06001025_us-ascii Here are some names I have collect over the last couple of years. ------------------------------------------------------------ CICS-L: Subscribe to listserv@@UGA.CC.UGA.EDU. IBM-MAIN (MVS): listserv@BAMA.UA.EDU MQSeries: listserve@AKH-WIEN.AC.AT
comp.databases.ibm-db2 veryactive DB2 newsgroup: ------------------------------------------------------------ http://www.instantweb.com/l/loriaux/s390/mailing.html list of S/390 lists ------------------------------------------------------------ http://www.landoflakes.com/~smcleod/ a web site run by the moderator of the UDB listserv
There is a good listserv for UDB information. To subscribe send an email to - db2eug-request@lists.best.com - In the email body include the word subscribe. ------------------------------------------------------------ http://www.lsoft.com/lists/listref.html It provides information on almost 18000 public listservs. The site allows you to do searches, and it provides information about the lists and how to join them. [...]
37822 50 21_Re: Disaster Recovery12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 20 Jan 2000 10:52:00 -0500559_- That is an option. We try to make things as simple as possible for operations and the people doing the recovery. The zparm module with "restart all" is already sitting in a library at the recovery site and a couple of renames seemed easiest and less error prone. If the machine is IPLed, the automated operator can just bring the DB2s up as it always has using the default zparm module. It comes down to what is your best fit. >>> DB2-L@RYCI.COM@inter2 01/20/00 10:38AM >>> Why not just assemble dsnzparm under a new name like dsnzprmd and use the DB2 [...]
37873 29 27_EDM Suite on demand problem10_John Clark20_pak02449@PIXIE.CO.ZA31_Thu, 20 Jan 2000 13:03:32 +0530466_iso-8859-1 I hope that this is not too off topic, but I have been drafted in to handle the DB2 portion of an EDMSuite on demand installation and we are experiencing problems when isuing the first RADM transaction. We receive a S0C4 and are not able to determine the cause.
I am fairly sure that it is not a DB2 problem, but if it is or if anyone else has installed the product and has come across similar problems, any help would be greatly appreciated. [...]
37903 19 16_Re: Instream SQL12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 20 Jan 2000 13:39:17 -0500489_iso-8859-1 Hi all, The following instream SQL executes correctly, but it uses too much system resources. Can someone please advise me of a way to restructure it so that it uses less system overhead. Thank you in advance.
Jeff
<<...>>
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
37923 39 50_DB2 for OS/390 V 5-6 software migration strategies17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Thu, 20 Jan 2000 13:26:41 -0600583_koi8-r We are in the process of thinking about what service level/release of DB2 to move to next in production. Our general strategy is to identify a stable point, get there, stay there for approx 6 months then find the next stable service level and go there.
Y2K has interrupted this process. We are currently at 9907. But we, like most shops (I'm guessing) froze at or around that level through Y2K. Well, if my guess is right and most/many shops also froze around that service level then it may stand to reason that later service levels haven't been rigorously worked [...]
37963 34 35_Re: Resend of Instream SQL question12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 20 Jan 2000 14:30:45 -0500686_iso-8859-1 I am resending this email to the group because it was brought to my attention that the SQL did not come through on the email. Please advise me how I could restructure the following instream SQL so that it will use less DB2 resources. It executes correctly. The instream SQL is as follows: //SYSTSIN DD * DSN SYSTEM(DB21) RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) LIB('SYS5.MVS1.DB2.RUNLIB.LOAD') PARM('SQL') END //SYSIND DD * SELECT * FROM DB21SQL.TTRNDIAG WHERE (DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) = 07) OR (DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) = 06) OR (DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) = 05) OR (DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) = 04) OR [...]
37998 58 35_Re: Resend of Instream SQL question13_Baldon, David20_David_Baldon@BMC.COM31_Thu, 20 Jan 2000 14:00:33 -0600488_ISO-8859-1 At a quick glance the following should work;
SELECT * FROM DB21SQL.TTRNDIAG WHERE (DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) < 8) AND (DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) > 0) ORDER BY C_DISCHARG_DATE;
HTH.....David BMC Software, Inc. Log Products Group
-----Original Message----- From: Kalman, Jeff [mailto:JKalman@UNCH.UNC.EDU] Sent: Thursday, January 20, 2000 1:31 PM To: DB2-L@RYCI.COM Subject: Re: Resend of Instream SQL question [...]
38057 58 16_Re: snapshot/db217_zeliger, bat-chen24_zeliger_bat-chen@EMC.COM31_Thu, 20 Jan 2000 14:54:24 -0500628_iso-8859-1 EMC TimeFinder can be used to enhance DFDSS backup procedures. TimeFinder Business Continuance Volumes (BCV) can be ESTABLISHED while transactions are processing on the standard data volumes. The ESTABLISH process synchronizes the data between the standard volumes and their BCV. When a DFDSS copy is desired, the DB2 systems can be quiesced and BCV volumes can be SPLIT. The SPLIT process is a very short process taking a few seconds. The DB2 systems can continue processing after the SPLIT has completed. Data on the BCV volumes represent a consistent business point at the time of the SPLIT. DFDSS copies can [...]
38116 67 35_Re: Resend of Instream SQL question0_24_John_McComb@VANGUARD.COM31_Thu, 20 Jan 2000 15:03:22 -0500534_us-ascii You might try:
SELECT * FROM DB21SQL.TTRNDIAG WHERE DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) IN (1, 2, 3, 4, 5, 6, 7) ORDER BY C_DISCHARG_DATE;
My limited tests seem to show some improvement.
John McComb
"Kalman, Jeff" on 01/20/2000 02:30:45 PM Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: John McComb/IT/VGI) Subject: Re: [DB2-L] Resend of Instream SQL question [...]
38184 80 35_Re: Resend of Instream SQL question12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 20 Jan 2000 15:05:45 -0500324_iso-8859-1 David, You're right the following does work. The only problem is it doesn't buy me anything in the way of processing time to reduce overhead. Is there a way to use host variables in instream SQL? The reason I ask is so that the calculation will not have to be done for every row in the table. Please advise. [...]
38265 84 35_Re: Resend of Instream SQL question12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 20 Jan 2000 15:08:12 -0500494_iso-8859-1 Thank you, I'll give it a try.
Jeff
-----Original Message----- From: John_McComb@VANGUARD.COM [mailto:John_McComb@VANGUARD.COM] Sent: Thursday, January 20, 2000 3:03 PM To: DB2-L@RYCI.COM Subject: Re: Resend of Instream SQL question
You might try:
SELECT * FROM DB21SQL.TTRNDIAG WHERE DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) IN (1, 2, 3, 4, 5, 6, 7) ORDER BY C_DISCHARG_DATE;
My limited tests seem to show some improvement. [...]
38350 92 35_Re: Resend of Instream SQL question13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Thu, 20 Jan 2000 15:03:20 -0500554_us-ascii Or maybe:
SELECT * FROM DB21SQL.TTRNDIAG WHERE C_DISCHARG_DATE BETWEEN (CURRENT DATE - 7 DAYS) AND CURRENT DATE ORDER BY C_DISCHARG_DATE;
Does this look right?
-- Lockwood Lyon Amway Corp
"Baldon, David" @RYCI.COM> on 01/20/2000 03:00:33 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: Resend of Instream SQL question [...]
38443 54 35_Re: Resend of Instream SQL question9_Birk, Tim17_BirkT@DIEBOLD.COM31_Thu, 20 Jan 2000 15:13:33 -0500468_iso-8859-1 I would try: SELECT * FROM DB21SQL.TTRNDIAG WHERE C_DISCHARG_DATE > CURRENT DATE - 8 DAYS AND C_DISCHARG_DATE < CURRENT DATE ORDER BY C_DISCHARG_DATE; I would also think about whether the order by was needed or if an external sort would be better.
Tim Birk
-----Original Message----- From: Kalman, Jeff [mailto:JKalman@UNCH.UNC.EDU] Sent: Thursday, January 20, 2000 2:31 PM To: DB2-L@RYCI.COM Subject: Re: Resend of Instream SQL question [...]
38498 73 35_Re: Resend of Instream SQL question12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 20 Jan 2000 15:18:50 -0500525_iso-8859-1 Thank you for your suggestion, I'll give it a shot.
Jeff
-----Original Message----- From: Birk, Tim [mailto:BirkT@DIEBOLD.COM] Sent: Thursday, January 20, 2000 3:14 PM To: DB2-L@RYCI.COM Subject: Re: Resend of Instream SQL question
I would try: SELECT * FROM DB21SQL.TTRNDIAG WHERE C_DISCHARG_DATE > CURRENT DATE - 8 DAYS AND C_DISCHARG_DATE < CURRENT DATE ORDER BY C_DISCHARG_DATE; I would also think about whether the order by was needed or if an external sort would be better. [...]
38572 15 9_PCTFREE 028_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Thu, 20 Jan 2000 12:35:24 PST482_- The value reported in the DSNU400 messages is calculated from the actual PGFREE in the tablespace and is an average. So, unless all pages actually have zero free space (unlikely) this value will not be zero.
Dan dcourter@us.ibm.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
38588 68 54_Re: DB2 for OS/390 V 5-6 software migration strategies24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Thu, 20 Jan 2000 15:47:39 -0500336_- Jerry,
1. What service level people have froze at (if they did) for Y2K.
>>>>Six v51 subsystems @ 9905. Not a formal freeze. Just my decision. Been happy with it.
2. What is the next service level/release you're going to in production.
>>>>>9911 is what I am looking at now, in prep for v6 migration. [...]
38657 18 9_PCTFREE 028_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Thu, 20 Jan 2000 12:43:51 PST316_- I know of no way to detect this PCTFREE 0 problem. It would mean dumping the DBDs and comparing the values. I wish REPAIR DBD had a formatted PRINT function, but it doesn't.
REORG will most certainly fix the problem after you do the ALTERs, and the ALTERs won't hurt you even if your DBDs are correct. [...]
38676 110 35_Re: Resend of Instream SQL question12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 20 Jan 2000 15:58:03 -0500508_iso-8859-1 Yes, I'm currently looking at your construct of this query to determine if the overhead is less. Thank you for your assistance.
Jeff
-----Original Message----- From: Lockwood Lyon [mailto:Lockwood_Lyon@AMWAY.COM] Sent: Thursday, January 20, 2000 3:03 PM To: DB2-L@RYCI.COM Subject: Re: Resend of Instream SQL question
Or maybe:
SELECT * FROM DB21SQL.TTRNDIAG WHERE C_DISCHARG_DATE BETWEEN (CURRENT DATE - 7 DAYS) AND CURRENT DATE ORDER BY C_DISCHARG_DATE; [...]
38787 54 35_Re: Resend of Instream SQL question16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Thu, 20 Jan 2000 15:07:27 -0700598_- Without spending a lot of time looking at it why don't you try BETWEEN, e.g.,
WHERE DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) BETWEEN 1 and 7
Duane
> -----Original Message----- > From: Kalman, Jeff [SMTP:JKalman@UNCH.UNC.EDU] > Sent: Thursday, January 20, 2000 12:31 PM > To: DB2-L@RYCI.COM > Subject: Re: Resend of Instream SQL question > > I am resending this email to the group because it was brought to > my > attention that the SQL did not come through on the email. Please advise me > how I could restructure the following instream SQL so that it will use > less [...]
38842 76 35_Re: Resend of Instream SQL question24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 20 Jan 2000 14:19:44 -0800612_- Try this!
where current date - C_DISCHARG_DATE between 1 and 7
> -----Original Message----- > From: Duane Lee - ATCX [SMTP:DLee@MAIL.MARICOPA.GOV] > Sent: Thursday, January 20, 2000 2:07 PM > To: DB2-L@RYCI.COM > Subject: Re: Resend of Instream SQL question > > Without spending a lot of time looking at it why don't you try BETWEEN, > e.g., > > WHERE DAYS(CURRENT DATE) - DAYS(C_DISCHARG_DATE) BETWEEN 1 and 7 > > Duane > > > -----Original Message----- > > From: Kalman, Jeff [SMTP:JKalman@UNCH.UNC.EDU] > > Sent: Thursday, January 20, 2000 12:31 PM > > To: DB2-L@RYCI.COM > > Subject: Re: [...]
38919 49 16_Re: Instream SQL14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Fri, 21 Jan 2000 09:24:12 +1000390_us-ascii Jeff,
many things are possible, but without your SQL no-one will be able to help you.
In addition to your SQL, can you include details of indexes, appropriate statistics (eg card counts, column distributions etc) and explain output.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 james.campbell@energyis.com.au [...]
38969 24 17_plan/package auth11_Cliff Boley27_maurice.c.boley@STATE.OR.US31_Thu, 20 Jan 2000 17:04:24 -0600478_- I have a question about package exeucte auth. I've created a plan and package list, then bound a package. I granted execute on the plan to a user with no grants on the package. The user was able to run the package having plan only authority. From my tests it would appear that if you have execute auth on the plan you get exectute for all the packages under that plan. This doesn't make sence. If this is the case why even have a packauth table?? Am I missing something? [...]
38994 58 21_Re: plan/package auth14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Thu, 20 Jan 2000 15:42:26 -0800594_iso-8859-1 According to the DB2 V6 SQL Reference, the EXECUTE privilege is used as follows:
Grants the privilege to run application programs that use the designated plan and to specify the packages following PKLIST for the BIND PLAN and REBIND PLAN.
The way this was once explained to me is that when the execution path is from a plan, then the PLAN execute privilege is used, since the AUTHID that bound the PLAN would need to have EXECUTE on the PACKAGE. The only time EXECUTE privilege is checked at run-time for packages is when the package is executed directly, ie. via [...]
39053 78 11_Re: PQ156700_16_dumoore@NMSU.EDU31_Thu, 20 Jan 2000 16:37:29 -0700358_US-ASCII We have just gone through the same situation with a simple one table view that runs 2 minutes on version 4 and 4 to 5 hours on version 5. The reorg, runstats, and bind seemed to clear it up, but now the question remains, how unclustered does the tablespace have to become before performance degrades again? We are up to 9910 on v5 maintenance. [...]
39132 69 35_Re: Resend of Instream SQL question13_Scott Goodell24_Scott.E.Goodell@WCOM.COM31_Thu, 20 Jan 2000 14:16:30 -0600506_us-ascii Another possibility for performance.. Not 100% sure, but I think the sub queires are only executed once.
SELECT * FROM DB21SQL.TTRNDIAG WHERE C_DISCHARG_DATE > (SELECT CURRENT DATE - 8 DAYS FROM SYSIBM.SYSDUMMY1) AND C_DISCHARG_DATE < (SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1)
Scott..
"Kalman, Jeff" on 01/20/2000 01:30:45 PM
Please respond to DB2 Data Base Discussion List [...]
39202 105 35_Re: Resend of Instream SQL question16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 20 Jan 2000 19:52:21 -0500359_iso-8859-1 Scott,
As of V4, those date expressions no longer had to be in a subquery in order to be stage 1 and indexable. So, your query way below is actually slower than: SELECT * FROM DB21SQL.TTRNDIAG WHERE C_DISCHARG_DATE >CURRENT DATE - 8 DAYS AND C_DISCHARG_DATE
If C_DISCHARG_DATE is in an index, then it will be used. [...]
39308 132 40_Re: DB2EUG Database System Monitor Usage11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Fri, 21 Jan 2000 14:26:34 +1100693_- Hi Ruby, We implemented reporting from UDB Event Monitor output. 1. Daily performance summary reports report on tablespace, bufferpools, and database summary. 2. We import the database summary into a database and extract daily summaries into a spreadsheet to show trends (6 months by day) on each variable.
Regards, Bruce
> -----Original Message----- > From: Stepansky_Ruby@EMC.COM [SMTP:Stepansky_Ruby@EMC.COM] > Sent: Tuesday, January 18, 2000 2:25 AM > To: DB2-L@RYCI.COM > Subject: DB2EUG Database System Monitor Usage > > I'd like to discuss with anyone who has implemented/used DB2 UDB (and more > specifically if possible EEE) Database > System Monitor and [...]
39441 64 40_DB2 UDB v 5 on NT - Performance Problems0_30_Milorad_Cerovac@TAC.VIC.GOV.AU31_Fri, 21 Jan 2000 14:35:26 +1000629_us-ascii We have a major performance problem with one of our DB2 production environments. This particular DB2 instance contains 2 databases CFDEV and CFPROD - they reside on a "mid-sized" NT server, which is basically dedicated to this application.
Recently performance deteriorated markedly. The cause has remained a mystery - the DBAs and the NT systems administrators as well as the development team have all investigated and have identified no changes have been made. We have tried running reorgs, dropping and recreating tables. We have also split up the tables into individual tablespaces, but without success. [...]
39506 67 35_Re: Resend of Instream SQL question13_Scott Goodell24_Scott.E.Goodell@WCOM.COM31_Thu, 20 Jan 2000 13:40:17 -0600463_us-ascii Not sure if this is a lot faster but I would think it would be... It is much easier to read....
SELECT * FROM DB21SQL.TTRNDIAG WHERE C_DISCHARG_DATE between current date - 7 days and current date - 1 day ORDER BY C_DISCHARG_DATE;
Scott
"Kalman, Jeff" on 01/20/2000 01:30:45 PM
Please respond to DB2 Data Base Discussion List [...]
39574 262 44_Re: DB2 UDB v 5 on NT - Performance Problems11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Fri, 21 Jan 2000 15:56:15 +1100512_- Hi Milorad, We currently run 150 DB2 NT servers running the same application, which probably gives us a slightly different view on problem solving. However, if one is not working (and all of the others are), rule 1 is reboot. If that doesn't solve it, we also rebuild.
Otherwise, Does the NT performance monitor tell you anything about cpu usage, paging activity, or other disk activity when each of the two databases are running? Does the db2diag.log indicate any errors? Runstats run or not run? [...]
39837 92 48_Potential incompatible change: Are you affected?12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 20 Jan 2000 23:56:50 -0600387_- We are looking at some alternative designs and want to consider one with an incompatible change to clean up the current situation and be compatible with DB2 for Unix, Windows, OS/2 If we made this change would you be affected?
Thanks for the feedback, Roger Miller -------------------------------------------------------------------- Suppose this came in a new release ... [...]
39930 24 37_Re: V6 Performance Question for DSMAX12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 21 Jan 2000 00:30:53 -0600503_- I suggest that you read the red book, SG24-5421, V5 Recent Enhancements, section 9.4. The OS/390 storage of about 300 bytes below the line per open data set, even when SWA is above the line, will generally prevent you from getting to 32K.
If you have 34,000 data sets, then you need to understand how many need to be open at once. If you think you need more than 20,000 to 25,000 at once, then you should be looking at alternative designs, making sure that the OS/390 folks are aware, ... [...]
39955 19 30_Re: What is the DB2 v5 Usermod12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 21 Jan 2000 00:34:53 -0600479_- There is real DB2 support for the function, often called split / mirror in SAP terminology. We call it log suspend and resume, so that external copy facilities like the Enterprise Storage Server FlashCopy or RVA SnapShot can be used for a copy.
DB2 Version 6 implements this function as APAR PQ31492, and I'd recommend that customers who need this support move to the release where we have real support, rather than trying to rely on a usermod that is less robust. [...]
39975 15 35_Re: dealing with mixed case columns12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 21 Jan 2000 00:38:11 -0600503_- If you move to DB2 Version 6, this is easy. There we have a built-in function and a Text Extender. Prior to Version 6, the task is usually performed in an application prior to inserting into the mixed case column and the upper case column.
Roger Miller
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
39991 18 57_Re: O.T. - search for s/390 related newsgroups - Thanks !14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 21 Jan 2000 09:36:05 +0100345_us-ascii Thanks for addresses !!! ;-)))
Regards Max Scarpa Data & System Admin CESVE SpA
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
40010 202 25_Re: FW: Space calculation0_18_mebert@AMADEUS.NET31_Fri, 21 Jan 2000 11:06:32 +0100501_us-ascii I am using LISTCAT extensively for space determinations (e.g. for generating backup jobs) and have never observed any discrepancies. All our datasets are CLOSE NO. I'm pretty sure that the HI-USED-RBA gets updated each time DB2 requests & formats a new page, or to be more precise, each time such a page gets written to disk (maybe someone can comment on all occasions when DB2 updates the disk image). The HI-ALLOC-RBA gets updated each time a new VSAM extent is requested & allocated. [...]
40213 94 39_Re: Reorg of the Catalog and Directory.0_18_mebert@AMADEUS.NET31_Fri, 21 Jan 2000 11:45:09 +0100511_us-ascii A little bit late (I have been on a training)... The original reason why we did the REORG was that BIND jobs were failing because the SYSPKAGE TS could not extend. This was because the disk it was on was 100% full. Also, several TS (mainly SYSPKAGE and SPT01) were into about 50 extents. The CATLIST REXX also revealed that other TSs (e.g. SYSVIEWS) had been allocated far too large. So, the REORG was mainly to redistribute the VSAM files and to adapt the sizes of the files to the actual needs. [...]
40308 27 38_DB2-Tools: Generate DDL / PACKAGE BIND20_Christoph Sassenrath36_christoph.sassenrath@D2MANNESMANN.DE31_Fri, 21 Jan 2000 12:06:42 +0100671_us-ascii Dear Experts,
I need very urgently two nice tools (preferred REXX) to * generate DDL for a complete database (DB2V4) * generate PACKAGE BINDs for PACKAGES of one COLLECTION
Is there "freeware" available?
Thank's
Christoph Sassenrath Mannesmann Mobilfunk GmbH, Germany Abt. FIBD Systembetrieb Telefon: +49 172 33099-3731 Telefax: +49 172 33099-1818 e-mail: christoph.sassenrath@d2mannesmann.de
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
40336 127 11_Re: PQ156700_18_mebert@AMADEUS.NET31_Fri, 21 Jan 2000 12:10:41 +0100610_us-ascii We also had several performance problems after going to V5 (one was with parallelism, which after many PTFs we still do not use). I remember one daily reporting job which alternated between a few minutes runtime one week and several hours the next because of changing access paths (it involved a three-table join, the tables having about 100, 100.000, and 300.000 rows - nothing big, with other words). There was a weekly RUNSTATS, a weekly REBIND, and a REORG every two weeks. The access path with the after-REORG runstats was ok. The access path for the slightly disorganised tablespace (after [...]
40464 113 17_Image Copy exists0_22_The-Thanh.Luong@AGF.BE31_Fri, 21 Jan 2000 12:15:38 +0100584_- Hi,
We had an image copy job abended 2 days ago (date=2000/1/19) because of an existing dataset, see following message:
........ DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = £AE.AE£I008 DSNU050I DSNUGUTC - COPY TABLESPACE AEMH00D0.AEMHCPS0 DSNUM ALL DSNU407I DSNUBCKB - DATA SET ALREADY USED FOR PREVIOUS IMAGE COPY DSNU408I DSNUBCKB - 'TAPD.DDB2.FULLDB.AEMH00D0.AEMHCPS0' EXISTS WITH - VOLUME=012244 FILE SEQUENCE NUMBER=7 RBA=X'001A09A857A3' DATE=99/12/22 TIME=12:41:19 DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 ........ [...]
40578 77 21_Re: Image Copy exists9_Ted Pesta18_tpesta@AMQUEST.COM31_Fri, 21 Jan 2000 06:30:55 -0500692_iso-8859-1 Is the volid still cataloged to the first dataset name ?
-----Original Message----- From: The-Thanh.Luong@AGF.BE [mailto:The-Thanh.Luong@AGF.BE] Sent: Friday, January 21, 2000 6:16 AM To: DB2-L@RYCI.COM Subject: Image Copy exists
Hi,
We had an image copy job abended 2 days ago (date=2000/1/19) because of an existing dataset, see following message:
........
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = £AE.AE£I008 DSNU050I DSNUGUTC - COPY TABLESPACE AEMH00D0.AEMHCPS0 DSNUM ALL DSNU407I DSNUBCKB - DATA SET ALREADY USED FOR PREVIOUS IMAGE COPY DSNU408I DSNUBCKB - 'TAPD.DDB2.FULLDB.AEMH00D0.AEMHCPS0' EXISTS WITH - VOLUME=012244 [...]
40656 179 21_Re: Image Copy exists0_18_mebert@AMADEUS.NET31_Fri, 21 Jan 2000 12:31:23 +0100464_us-ascii The problem is that you re-use dataset names. After 21 days, the entry gets deleted from the OS/390 catalog. But unless you run the MODIFY utility, there is still an entry in SYSCOPY for this dataset. DB2 doesn't know the file doesn't exist anymore. You should run a MODIFY TABLESPACE AEMH00D0.AEMHCPS0 DELETE AGE(20) just before the image copy (this may put your TS into COPY PENDING if you don't have other full ICs that are younger than 21 days). [...]
40836 165 21_Re: Image Copy exists0_22_The-Thanh.Luong@AGF.BE31_Fri, 21 Jan 2000 12:44:34 +0100521_- It was, but is not anymore (I removed the entry from SYSCOPY).
The-Thanh LUONG
-----Original Message----- From: Ted Pesta [mailto:tpesta@AMQUEST.COM] Sent: Friday, January 21, 2000 12:31 PM To: DB2-L@RYCI.COM Subject: Re: Image Copy exists
Is the volid still cataloged to the first dataset name ?
-----Original Message----- From: The-Thanh.Luong@AGF.BE [mailto:The-Thanh.Luong@AGF.BE] Sent: Friday, January 21, 2000 6:16 AM To: DB2-L@RYCI.COM Subject: Image Copy exists [...]
41002 153 21_Re: Image Copy exists0_22_The-Thanh.Luong@AGF.BE31_Fri, 21 Jan 2000 12:58:56 +0100340_- Thank you Dr Ebert, but it still worries me: why does this happen all of a sudden, whereas we run 5 DB2 environments for years, with the same method of image copying (of course, the Test DB2s are with RETPD=3 instead of 21)? There is no such MODIFY before the ICs so far. My SYSCOPY should be filled up with the "old" DSVOLSERs? TIA [...]
41156 246 27_Re: Cursor / Non-Cursor Mix16_Michael McMorrow25_michael.g.mcmorrow@AIB.IE31_Fri, 21 Jan 2000 11:52:10 -0000471_ISO-8859-1 Hi Michael,
1) I agree that performing the Update via an Update Cursor is tighter design with regard to potential intermediate updates from other applications. However in our case (driving Select Cursor with Hybrid Join / RID overflow etc.etc.) performing the independent Update via Singleton Update Statement or via a Cursor Update makes no difference. The driving Select Cursor omits the same rows in both circumstances. 2) I agree, IBM doesn't. [...]
41403 102 21_Re: Image Copy exists14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Fri, 21 Jan 2000 11:21:48 -0000543_iso-8859-1 DB2 is checking in SYSCOPY to make sure you are not overwriting one image copy with another.
So, even if your tape management system is scratching tapes, unless you also use the MODIFY utility to clear out obsolete copies, this is something that you will hit from time to time. It's even worse with cataloged image copies as it only consideres the dataset name. if you were copying to un-cataloged datasets, then DB2 stores (and checks) the dataset name AND the volser and only flags an error if they are BOTH the same. [...]
41506 173 17_Image Copy exists0_22_The-Thanh.Luong@AGF.BE31_Fri, 21 Jan 2000 13:12:06 +0100533_- I had troubles sending this message out, so, Sorry to the list if you get it twice.
> Thank you Dr Ebert, but it still worries me: why does this happen all of a > sudden, whereas we run 5 DB2 environments for years, with the same method > of image copying (of course, the Test DB2s are with RETPD=3 instead of > 21)? > There is no such MODIFY before the ICs so far. My SYSCOPY should be filled > up with the "old" DSVOLSERs? > TIA > > The-Thanh LUONG > > > -----Original Message----- > From: mebert@AMADEUS.NET [...]
41680 74 21_Re: Image Copy exists12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Fri, 21 Jan 2000 04:36:47 PST521_- Hi:
Your problem was caused by uncataloged dataset that were already in your db2 syscopy. It means a previous image copy data set was delete and then when you try to execute an image copy it try to create the same generation again but db2 check that it exists and it abend. If you want to fix it you have to specify in your image copy jcl '(+5)' in the dataset where you are having problem. Try it out and the second way to fix it allocating the data set that is missing and reexecute the job again. I hope [...]
41755 129 21_Re: Image Copy exists11_Hilton Tina15_HiltonT@TCE.COM31_Fri, 21 Jan 2000 07:37:35 -0500405_iso-8859-1 It's just the luck of the draw and has happened to me a few times too. The odds are low (assuming that you do regularly run modify recovery) that a scratch tape will be mounted that happened to have been used to store an image copy of the same table. I used to do the modify recovery withe age(nnn) the same number of days as the retention. Now, I have it one day less than the retention. [...]
41885 157 21_Re: Image Copy exists9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Fri, 21 Jan 2000 12:56:35 +0000413_us-ascii
The Than-Luong is taking uncataloged (ICF catalog) image copies. This is indicated by the 'real' VOLSER (rather than CATG) in the DSNU408I message. The message indicates that the conflict was between uncataloged datasets.
Using the normal 'GDG' mechanism workarounds for cataloged datasets will not therefore work in this case. I think Tina Hilton suggested the appropriate strategy. [...]
42043 160 21_Re: Image Copy exists9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Fri, 21 Jan 2000 12:56:35 +0000413_us-ascii
The Than-Luong is taking uncataloged (ICF catalog) image copies. This is indicated by the 'real' VOLSER (rather than CATG) in the DSNU408I message. The message indicates that the conflict was between uncataloged datasets.
Using the normal 'GDG' mechanism workarounds for cataloged datasets will not therefore work in this case. I think Tina Hilton suggested the appropriate strategy. [...]
42204 32 16_Re: Instream SQL14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Fri, 21 Jan 2000 08:30:08 -0500619_us-ascii Well I am no expert on SQL tuning but why not try
<<..>>
Bill G. ;-)
Kalman, Jeff wrote:
> Hi all, > The following instream SQL executes correctly, but it uses too much system > resources. Can someone please advise me of a way to restructure it so that > it uses less system overhead. Thank you in advance. > > Jeff > > <<...>> > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
42237 44 35_Re: dealing with mixed case columns13_Assaf Lev-Ram19_assaf.l@SAPIENS.COM31_Fri, 21 Jan 2000 09:02:02 -0500470_iso-8859-1 Hi ! Thank you for your response but if you don't mind I need some more information : I want the data for the MIXED column to remain as is but the index occurrences to be created as UPPER case (the reason is that with the tool I'm using it is very easy to translate mixed case to upper case when giving the keyword for the search). 1. Is there a way to achieve that prior to version 6 ? 2. How can I do it in version 6 (more details if you don't mind) ? [...]
42282 129 35_Re: Resend of Instream SQL question14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sat, 22 Jan 2000 01:05:01 +1000523_us-ascii Richard ( & Scott),
Actually the technique Scott recommends (and also recommended by me many a time) may be required up till DB2 V5 makes it unnecessary, if the SQL was static SQL, which it isn't in this question.
DB2 V4 allowed a very small set of constant expressions to be indexable. Unfortuneately the date expressions had to contain literal constant dates for static SQL. CURRENT DATE is not a literal constant, it is a special register, and hence acts the same as a program host variable. [...]
42412 151 35_Re: Resend of Instream SQL question12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Fri, 21 Jan 2000 09:22:36 -0500500_iso-8859-1 Thank you, I'll look into your suggestion.
Jeff
-----Original Message----- From: Michael Hannan [mailto:mhannan@C031.AONE.NET.AU] Sent: Friday, January 21, 2000 10:05 AM To: DB2-L@RYCI.COM Subject: Re: Resend of Instream SQL question
Richard ( & Scott),
Actually the technique Scott recommends (and also recommended by me many a time) may be required up till DB2 V5 makes it unnecessary, if the SQL was static SQL, which it isn't in this question. [...]
42564 20 58_Converting SMF type 100 records to DB2 loadable format....15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 21 Jan 2000 16:19:41 +0000443_us-ascii Hello,
Does anyone out there have a rexx exec or a program to convert SMF type 100 records to a DB2 loadable format? Like the DB2PM file function.
Regards,
Toine Michielse
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
42585 39 22_sql question (simple?)13_Oelkers, Phil25_phil.oelkers@EXPERIAN.COM31_Fri, 21 Jan 2000 07:30:07 -0800231_- Assume I have a table
ID Code 1 A 1 B 2 B 2 B 2 C 3 A 3 C
there is a given set of values in code ('A', 'B', 'C') for a ID there can be multiple rows in the table
How can I do s select to give me a table [...]
42625 108 26_Re: sql question (simple?)0_24_db46@DAIMLERCHRYSLER.COM31_Fri, 21 Jan 2000 11:14:18 -0500728_us-ascii Try this ---------+---------+---------+---------+---------+--- SELECT ID, SUM (A_ROW) AS A#, SUM (B_ROW) AS B#, SUM (C_ROW) AS C# FROM ( SELECT ID, CASE CODE WHEN 'A' THEN 1 ELSE 0 END AS A_ROW, CASE CODE WHEN 'B' THEN 1 ELSE 0 END AS B_ROW, CASE CODE WHEN 'C' THEN 1 ELSE 0 END AS C_ROW FROM TEMP) AS T1 GROUP BY T1.ID ORDER BY T1.ID ---------+---------+---------+---------+---------+---------+---------+----- ID A# B# C# ---------+---------+---------+---------+---------+---------+---------+----- 1 1 1 0 2 0 2 1 3 1 0 1 DSNE610I NUMBER OF ROWS DISPLAYED IS 3 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100 ---------+---------+---------+---------+---------+---------+---------+----- DSNE617I COMMIT [...]
42734 30 34_Separate Connection/Transaction ID12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Fri, 21 Jan 2000 10:20:00 -0600442_us-ascii Hello. DB2 UDB 6.1 OS/390 2.6
I'd like to have a stored procedure which obtains a control-id, adds one, updates and commits without applying any Updates/Inserts/Deletes pending against other tables. In SQL Server we do this with a separate Transaction or Connection ID. (E.g. SQLCB.) Is there some way to do this in DB2? (Plan B is to use the ROWID datatype, but I'd like to get this first approach to work if possible.) [...]
42765 22 13_Re: Thank you12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Fri, 21 Jan 2000 11:46:50 -0500326_iso-8859-1 I would like to thank all of you that replied to my instream SQL question. For FYI purposes the query that works the best was from Lyon Lockwood's reply and it is as follows:
SELECT * FROM DB21SQL.TTRNDIAG WHERE C_DISCHARG_DATE BETWEEN (CURRENT DATE - 7 DAYS) AND CURRENT DATE ORDER BY C_DISCHARG_DATE; [...]
42788 15 52_Re: Potential incompatible change: Are you affected?12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 21 Jan 2000 10:52:28 -0600299_- I was informed by one person that the SQL statement does not work if APAR PQ23778 is not on your DB2. That APAR allows us to have a column in the ORDER BY, but not in the SELECT. If you don't have the APAR, or maybe even if you do, it looks like changing to ORDER BY KEY_SEQ would be better. [...]
42804 53 13_Re: Thank you13_Scott Goodell24_Scott.E.Goodell@WCOM.COM31_Fri, 21 Jan 2000 11:08:14 -0600399_us-ascii Just, FYI..
This solution does not match your original query results. Since Between is inclusive this query would result in data being returned for the current date. Your original query only included items seven days old to one day old (7 days). This query is seven days old to today (8 days). To match your original query the second condition needs to be current date - 1 day. [...]
42858 17 52_Re: Potential incompatible change: Are you affected?0_19_Tim.Lowe@STPAUL.COM31_Fri, 21 Jan 2000 11:56:17 -0600328_us-ascii We would not be affected.
Thanks, Tim Lowe Lead DBA St. Paul companies
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
42876 20 38_Language Environment, COBOL II and CSP12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Fri, 21 Jan 2000 12:20:00 -0500405_- We will migrating our COBOL II apps to LE in the near future. Does anyone know: Are there papers/sites discussing migration from DB2 COBOL II programs (both CICS and Batch)? Are there papers/sites discussing migration to LE from CSP370/AD and CSP370/RS currently configured and running COBOL II?
Any experiences/gotchas from those who have already been down this seemingly treacherous path? [...]
42897 19 21_Multiple buffer pools16_Alison Pelletier30_APelletier@MOUNTAINWESTFIN.COM31_Fri, 21 Jan 2000 11:08:32 -0700326_iso-8859-1 Greetings everyone,
We are DB2/OS390 V5. We currently only have one buffer pool, BP0. For a long time we have tried to convince DB2 systems folks for the need of multiple buffer pools. Do I have a valid argument, if the buffer pool hit ratio is close to 100%? Is/are there other indicators to consider? [...]
42917 120 52_Re: Potential incompatible change: Are you affected?14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Fri, 21 Jan 2000 10:37:33 -0800603_iso-8859-1 Roger, As part of this change, how about putting an indicator in the catalog that the column was defined as UNIQUE? This seems to be a lot better than forcing all DBA's to either blindly perform the ALTER statement before creating any new foreign keys, or having to get an error then rerunning the alter statment. I guess since I don't see the benefit of this, other than being consistent with the other DB2 UDB flavors, I think this would be a huge restriction. What benefit will this provide? Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions [...]
43038 82 25_Re: Multiple buffer pools14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Fri, 21 Jan 2000 13:45:01 -0500355_ISO-8859-1 Message text written by DB2 Data Base Discussion List >We are DB2/OS390 V5. We currently only have one buffer pool, BP0. For a long time we have tried to convince DB2 systems folks for the need of multiple buffer pools. Do I have a valid argument, if the buffer pool hit ratio is close to 100%? Is/are there other indicators to consider?< [...]
43121 47 25_Re: Multiple buffer pools14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 21 Jan 2000 13:51:58 -0500584_us-ascii Alison, Your DB2 systems probrammers are behind the 8 ball. This (only) one buffer pool went out the window quite ahwile ago. IBM does not recommend it, will not allow it via a zparm (I think) in DB2 V6, and most DBA's with any experience will not recommend it. Some justificaitons: How do you really know you are getting 100% hit ratio, is that true for both sequential and random access? How can you favor or prioritize your business critical applications if you have them all lumped together? Are your doing any IO? Substantial improvements can be made with breaking [...]
43169 63 25_Re: Multiple buffer pools0_15_sokeefe@VCU.EDU31_Fri, 21 Jan 2000 13:43:31 -0500588_us-ascii Defintely, although that is a very high hit count! System (catalog) and directory usage is best for BP0. You should then try to establish BP's for: 1) Tablespaces, sequential access 2) Tablespaces mostly random access 3) Indexes mostly sequential access 4) Indexex mostly ranom access 5) BP for temporary/sorts Tehre are several other BP parms other than size (number of pages) to be considered for each BP. Mullins does a good good in his book ("DB2 Developer's Guide, 3rd Edition) of going over these. A good URL for white paper's is: www.responsivesystems.com Good luck. [...]
43233 47 42_Re: Language Environment, COBOL II and CSP14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 21 Jan 2000 13:58:43 -0500317_us-ascii Bob, I did this two years ago. I used the Cobol for MVS and LE migration manuals at that time and found the info to cover the conversion fairly well. There are a few verbs that need to be change in the Cobol II programs (if they are used) and I believe I had some issues with dynam vs nodynam. HTH Phil [...]
43281 106 25_Re: Multiple buffer pools13_John Arbogast16_jfarbo@YAHOO.COM31_Fri, 21 Jan 2000 11:13:22 -0800334_us-ascii Without a tool such as the bufferpool tool, how do you determine which objects go into which pool? What if your objects were mostly random during the day and mostly sequential during the batch window? Could one use 4 BPs as follows:
BP0 - catalog and dir only BP1 - Workfiles only BP2 - Tablespaces BP3 - indexes [...]
43388 144 25_Re: Multiple buffer pools0_15_sokeefe@VCU.EDU31_Fri, 21 Jan 2000 14:13:42 -0500643_us-ascii That's the chore (BP assignment by type of access). On the application I work on, even batch is randow access unfortunately. Yes, you can alter BP before and after your batch window. I'm experimenting with that now.
|--------+-----------------------> | | John Arbogast| | | | | | | | | 01/21/2000 | | | 02:13 PM | | | Please | | | respond to | | | DB2 Data Base| | | Discussion | | | List | | | | |--------+-----------------------> >----------------------------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: Sean M O'Keefe/AC/VCU) [...]
43533 265 44_Re: DB2 UDB v 5 on NT - Performance Problems11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Fri, 21 Jan 2000 15:56:15 +1100519_us-ascii Hi Milorad, We currently run 150 DB2 NT servers running the same application, which probably gives us a slightly different view on problem solving. However, if one is not working (and all of the others are), rule 1 is reboot. If that doesn't solve it, we also rebuild.
Otherwise, Does the NT performance monitor tell you anything about cpu usage, paging activity, or other disk activity when each of the two databases are running? Does the db2diag.log indicate any errors? Runstats run or not run? [...]
43799 132 25_Re: Multiple buffer pools23_Trivedi, Kaushal J, BGM17_kjtrivedi@ATT.COM31_Fri, 21 Jan 2000 14:31:30 -0500330_iso-8859-1 Hi All,
In addition to John's question I would like to know how does one decide in case a number of databases are present, in this case how does one decide, is there a general guideline one follows in case of multiple databases on a single production system.
thank you regards
Kaushal Trivedi [...]
43932 168 43_DB2 High Performance Unload - Select Option18_Stritzinger, David24_StritzingerD@NABISCO.COM31_Fri, 21 Jan 2000 14:50:15 -0500366_- There has been some discussion on the list the last few months about IBM's DB2 High Performance Unload, and just this week we received the tape and installed it. Our environment is DB2 5.1, OS/390 2.6, and SAP R/3. We have started to do some initial testing and we are currently hitting some issues I was hoping someone else may have been able to figure out. [...]
44101 130 25_Re: Multiple buffer pools14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 21 Jan 2000 15:00:05 -0500341_us-ascii Through a combination of the bufferpool tool, display bufferpool detail lstats commands and Plat Subsystem Analyzer you can get a good idea of what you need to do. HTH Phil
Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner DB2-L [...]
44232 53 42_Re: Language Environment, COBOL II and CSP8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Fri, 21 Jan 2000 14:00:38 -0600480_us-ascii Bob, I have done this for my previous client at Singapore around 2 years back. This was from CSP3.3 to CSP 4.1 generating Cobol for MVS code. We migrated around 1000 CSP programs. Initially i had some problems which was able to solve later. One was the DYNAM and the other one i think it is the OPT. There are some other issues like filling the PDS very fast, because of the code generation. Generations options has to be tuned to suppress lot of unwanted messages. [...]
44286 165 30_Fwd: Re: Multiple buffer pools13_John Arbogast16_jfarbo@YAHOO.COM31_Fri, 21 Jan 2000 12:01:32 -0800490_us-ascii
I asked how to do this WITHOUT such tools! We have neither available to us.
Philip Gunning wrote: Date: Fri, 21 Jan 2000 15:00:05 -0500 Reply-to: "pgunning@boscovs.com"
From: Philip Gunning
Subject: Re: Multiple buffer pools To: DB2-L@RYCI.COM
Through a combination of the bufferpool tool, display bufferpool detail lstats commands and Plat Subsystem Analyzer you can get a good idea of what you need to do. HTH Phil [...]
44452 172 30_Fwd: Re: Multiple buffer pools13_John Arbogast16_jfarbo@YAHOO.COM31_Fri, 21 Jan 2000 12:01:32 -0800490_us-ascii
I asked how to do this WITHOUT such tools! We have neither available to us.
Philip Gunning wrote: Date: Fri, 21 Jan 2000 15:00:05 -0500 Reply-to: "pgunning@boscovs.com"
From: Philip Gunning
Subject: Re: Multiple buffer pools To: DB2-L@RYCI.COM
Through a combination of the bufferpool tool, display bufferpool detail lstats commands and Plat Subsystem Analyzer you can get a good idea of what you need to do. HTH Phil [...]
44625 49 14_DB2 and Delphi9_Fatih Nar34_fatihnar@ANATOLIA.MSIS.METU.EDU.TR31_Fri, 21 Jan 2000 21:37:07 +0200491_US-ASCII Hi,
I am using Delphi 4 (later I will use Delphi 5) and DB2 UDB VB.52 (later I will use DB2 UDB V6.x)
I have got some questions to ask:
1. I think this question is the one of the most asked one by beginner of DB2. Coming : AUTOINCREMENT.. how can I define an autoincrement field. I found the trigger foing that. But why DB2 does not support such a thing. I read that DB2 V6.1 does it, but it supports it in UNIX version but not NT version. Is it the fact? [...]
44675 261 29_FW: Re: Multiple buffer pools14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 21 Jan 2000 15:21:45 -0500335_us-ascii Then you use the db2 display bufferpool commands. They provide a lot of information. The results of the displays are documented in the messages and codes manual. Phil
Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner DB2-L [...]
44937 191 21_Re: Image Copy exists0_18_mebert@AMADEUS.NET31_Fri, 21 Jan 2000 12:31:23 +0100464_us-ascii The problem is that you re-use dataset names. After 21 days, the entry gets deleted from the OS/390 catalog. But unless you run the MODIFY utility, there is still an entry in SYSCOPY for this dataset. DB2 doesn't know the file doesn't exist anymore. You should run a MODIFY TABLESPACE AEMH00D0.AEMHCPS0 DELETE AGE(20) just before the image copy (this may put your TS into COPY PENDING if you don't have other full ICs that are younger than 21 days). [...]
45129 48 24_Re: Multiple bufferpools14_Max 'Guderian'16_mocion@LIBERO.IT31_Fri, 21 Jan 2000 22:11:44 +0100409_iso-8859-1 Where I worked as Data & System Admin I followed Joel Goldstein's hints and with few (but
multiples) bufferpools I reached very high hits in BPs with low application response time (don't
forget I/O and TS placement, however.....). Using the simple 'shotgun' method, for instance,
you can obtain good results with a little use of storage, with the separation of TS and IX. [...]
45178 35 25_Re: Multiple buffer pools0_17_JTonchick@AOL.COM29_Fri, 21 Jan 2000 16:29:06 EST441_us-ascii In a message dated 01/21/2000 12:32:56 PM Central Standard Time, APelletier@MOUNTAINWESTFIN.COM writes:
<< Greetings everyone,
We are DB2/OS390 V5. We currently only have one buffer pool, BP0. For a long time we have tried to convince DB2 systems folks for the need of multiple buffer pools. Do I have a valid argument, if the buffer pool hit ratio is close to 100%? Is/are there other indicators to consider? >> [...]
45214 19 15_DB2 V6 on OS39016_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Fri, 21 Jan 2000 15:07:38 -0700317_- I'm close to ordering OS390 DB2 v6 but heard that a new release, v 6.2, is due out in March. If that is the case I want to wait for the new release. Has anyone else heard about this or are we just talking about a bunch of PTFs that would be applied and a new designation of 6.2?? Any info will be appreciated. [...]
45234 75 16_ORACLE LIST-SERV16_Mary Ann Pickett24_pickettm@DOT.STATE.AL.US31_Fri, 21 Jan 2000 16:10:12 -0600314_iso-8859-1 Hi All,
Does anyone know of a good list-serve for Oracle on NT. We have DB2 on the mainframe and ORACLE on NT servers. I have gotten a lot of good information and help about DB2 from this list and would love to find someting comparable for ORACLE.
Thanks,
Mary Ann Pickett DBA ALDOT
45310 78 16_ORACLE LIST-SERV16_Mary Ann Pickett24_pickettm@DOT.STATE.AL.US31_Fri, 21 Jan 2000 16:10:12 -0600314_iso-8859-1 Hi All,
Does anyone know of a good list-serve for Oracle on NT. We have DB2 on the mainframe and ORACLE on NT servers. I have gotten a lot of good information and help about DB2 from this list and would love to find someting comparable for ORACLE.
Thanks,
Mary Ann Pickett DBA ALDOT
45389 133 37_Antw: Re: DB2 V4 Maint for Migration.13_Michael Fleck19_m.fleck@MAIL.LVR.DE31_Fri, 21 Jan 2000 09:36:17 +0100565_US-ASCII Hi,
we had exactly the same problem some months ago. Here are the responses and the workaround from IBM: ---->>>
-Cust is migrating from V4 to V5 and gets msg in catalogue conversion job dsntijtc abendS0c4 RSN=10 PQ22050/PQ22051 are applied -STL recommends to restore UQ34282 (after accepting maint) and to proceed like descripted in II10128 or II11442 (as maint in V4 is not accepted, SDSNLOAD is to be used instead of ADSNLOAD for linking DSNHDECP, also the INCLUDE statement is to be removed - this is to get the new DSNARIB) [...]
45523 210 33_Re: Certification courses in DB2.14_O'Conner, John26_john.oconner@COURTS.WA.GOV31_Fri, 21 Jan 2000 14:16:21 -0800414_iso-8859-1 I agree with both sides of the issue. DB2 certification doesn't add anything to the resume of someone with years of experience in a mainframe production environment. But I believe there are practical reasons to seek certification. Here are three uses for certification:
1) The reason cited below. To determine areas where you may be able to improve your skills/knowledge (self-improvement). [...]
45734 34 19_Re: DB2 V6 on OS3900_18_DB2DBAinTX@AOL.COM29_Fri, 21 Jan 2000 17:37:56 EST542_us-ascii I heard that is was a refresh.
-----Original Message----- From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: Friday, January 21, 2000 4:08 PM To: DB2-L@RYCI.COM Subject: DB2 V6 on OS390
I'm close to ordering OS390 DB2 v6 but heard that a new release, v 6.2, is due out in March. If that is the case I want to wait for the new release. Has anyone else heard about this or are we just talking about a bunch of PTFs that would be applied and a new designation of 6.2?? Any info will be appreciated. [...]
45769 46 20_Re: ORACLE LIST-SERV14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Sat, 22 Jan 2000 16:53:13 +1000592_us-ascii Mary,
two lists I know about are: 1) http://www.telelists.com/cgi-bin/lyris.pl?enter=oracle 2) send a blank email to oracledba-subscribe@lazydba.com Both are general Oracle lists, rather than NT specific, and cover the same ground. The same postings often appear on both.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 james.campbell@energyis.com.au -----Original Message----- From: Mary Ann Pickett [mailto:pickettm@DOT.STATE.AL.US] Sent: Saturday, January 22, 2000 8:10 AM To: DB2-L@RYCI.COM Subject: ORACLE LIST-SERV [...]