1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2000, week 2
2 75 12_AW: Rollback12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 8 Sep 2000 09:02:16 +0200722_iso-8859-1 Scott,
one of our programmers ran a similar insert. The problem that occurs was a enormous growing of the DB2 for OS/390 log activity.
We decided to unload the table (DSNTIAUL) and load the data into the target table (LOAD-Utility). This was faster and the log activity was normal.....
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ---------------------------------------------------------------------- [...]
78 27 13_ODBC to OS39014_Adrian Collett27_adriancollett@TISCALINET.IT30_Fri, 8 Sep 2000 09:11:56 +0200339_iso-8859-1 Dear list,
I have a client who is using VB6 - MTS - DB2 connect - Db2/os390(V5). They have been having problems with ODBC catalog access. I have found lots of answers on how to reduce this problem and we are almost there, however I still have one question which I haven't been able to find an answer to and that is: [...]
106 58 27_AW: Date Data Type in Index12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 8 Sep 2000 09:13:48 +0200626_iso-8859-1 From which DB2 platform are you talking ?
We're on DB2 for OS/390 V5 and we are using date data type in a lot of primary keys/clustering indexes and other indexes without any performance problems.
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ---------------------------------------------------------------------- [...]
165 18 44_Pamela Harris/IT/SEARS is out of the office.0_17_pharri1@SEARS.COM30_Fri, 8 Sep 2000 02:19:15 -0500554_us-ascii I will be out of the office from 09/08/2000 until 09/11/2000.
If you need assistance with DB2, please use the primary DB2 pager, for informix use the primary informix pager, for network issues please call Ginutis Matutis, PIN # 7270300.
DB2 pin # 7270526, Informix/SQL Server pin # 7270525
================================================ 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.
184 106 17_Re: ODBC to OS3900_18_mebert@AMADEUS.NET30_Fri, 8 Sep 2000 09:27:47 +0200281_us-ascii Because it uses Dynamic SQL? (Just guessing...) And now I have to admit that I don't really know why DSQL should require a DBD lock but not Static SQL. After all, you might consider DSQL conceptually as Bind temp package - execute it - free it. Can somebody tell me? [...]
291 26 45_=?iso-8859-1?B?u9i4tDogT0RCQyB0byBPUzM5MA==?=10_Michale Yu19_yubin@MAIL.DCAC.COM30_Fri, 8 Sep 2000 15:39:25 +0800354_iso-8859-1 Andrian:
Now I am facing the same problem to access DB2/OS390(V5) through DB2connect EEE from an application C++ on windows .Nobody can access catalog(for example, no BIND could be execute) when you issue a connect command or a SQL statement from application C++.
could you give me some help to reduce this problem. [...]
318 270 32_Re: BMC Unload/Load Plus for DB20_18_mebert@AMADEUS.NET30_Fri, 8 Sep 2000 09:42:05 +0200572_us-ascii Hello James,
while I have used both the DSN1COPY/REBUILD and Unload/Load methods for changing characteristics of 30+ GB partitioned TS, I do not have timings. These things come up only rarely here so there is little reason to look for the best method. Further, we do not have 2rd party utilities so we would have to use REORG UNLOAD EXTERNAL for unloading which restricts access to the TS. I'm not too keen on using inline ICs with LOAD. It just adds another opportunity for having the job fail (B37 on IC file e.g.). Having a LOAD followed by a COPY [...]
589 63 49_Re: set package set - one way to use this concept14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 8 Sep 2000 20:06:32 +1100485_iso-8859-1 Michael,
Up front, I'll say that I don't have detailed experience of doing what you're doing. But I don't see an advantage in using PKLIST(*.*).
My reading is that if you SET CURRENT PACKAGESET there is no requirement that the collection used be named in the plan PKLIST. Using PKLIST(.*) (where is a collection that you know will have whatever packages are required to get to the SET CURRENT PACKAGESET seems enough. [...]
653 50 23_Archive Blksize - again14_Ulf-Otto Cihak23_UlfCihak@COMPUSERVE.COM30_Fri, 8 Sep 2000 05:32:54 -0400583_ISO-8859-1 Dear List, I have read all of the previous discussions regarding Archive Blocksize in the List Archives, in the Info Apar II06249, and of course in the manuals but - please excuse that I am still too stupid to understand the following:
I want to reduce my Archive Blocksize from 28672 to 24576. I know how to define the new Blocksize in the ZPARM. However, previous entries in the discussion list lead me to believe that I may have problems doing this. Cited from a February 2000 entry: ''The blocksize of an Archive Log, when read during recovery, must match [...]
704 169 49_Re: set package set - one way to use this concept0_18_mebert@AMADEUS.NET30_Fri, 8 Sep 2000 12:02:12 +0200408_us-ascii Hi James,
of course, with PKLIST(*.*) you always have to do a SET CURRENT PACKAGESET first. This is because you have only _one_ source program and _one_ DBRM (all tablenames are unqualified) and from this you bind N packages, each having the same name and contoken but different collids and qualifiers. Only by doing a SET CURRENT PACKAGESET first can DB2 narrow it down to one package. [...]
874 54 27_CHANGING A TABLESPACE CCSID12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 8 Sep 2000 13:41:27 +0200409_iso-8859-1 Hello List.
We have already installed a DB2 V5 application system inside a DB2 for OS/390 subsystem. Assuming the default is EBCDIC we did not specify a CCSID while we're doing our CREATE TABLESPACE's.
Now this application is rebuild as a real client/server app. Only the application data is stored on the big iron, the presentation is - business as usual - done at a client PC. [...]
929 86 75_Re: 00c90101 - Partitioned tablespace - Delete where current of cursor-name10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Fri, 8 Sep 2000 06:49:04 -0500636_- Tony,
Try searching the archives for 00C90101. There are a heap of postings there, and various solutions for various causes.
Has the t/s been DSN1COPYed to recently?
On Thu, 7 Sep 2000 14:58:57 -0400, Anthony R Gould wrote:
>OS390 v2.8 - DB2 v5.1 > >We have an Easytrieve Plus program that deletes records on a table using > >the CURRENT OF cursor-name. This program has been in production for a >few years and runs four times per year. The program abended this week >with a 00C90101. The additional information from the Write To Operator >(WTO) is: > >DSNI014I ?W [...]
1016 24 12_Re: Rollback15_Melvin Demmicks25_melvin_demmicks@YAHOO.COM30_Fri, 8 Sep 2000 05:09:43 -0700574_us-ascii Yes, Scott that does seem excessive.
But what really seems excessive is inserting 300,000 rows in this manner.
Can you use the Load utility?
Good luck.
__________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.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.
1041 81 44_Re: implementing physical db using case tool19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 8 Sep 2000 07:14:05 -0500569_iso-8859-1 Anil, I agree with Wayne. First, I guess you could call ERwin a CASE tool, but I don't. In my view it is simply a tool that assists me in diagramming logical and physical database ER diagrams and producing the DDL I need. I use ERwin on a daily basis and it can correctly produce all the DDL (including partitioning) I need except for the GRANTs, etc (wish the vendors would pick up on this and provide the capability). However, ERwin is lagging behind somewhat on DB2 UDB for OS390 V6 support. There are competitive products, for example -- SilverRun. [...]
1123 17 41_DB2 Audit and a DB2 v6 compatible release17_Erkki Søndergaard20_esonderg@SCA.CSC.COM30_Fri, 8 Sep 2000 14:15:32 +0200362_us-ascii > NB. We use DB2 Audit to capture changes to a range of tables which >are then passed to our Warehouse database which is on Oracle.
One possibility would be using Capture/MVS to capture the changes. The problem is then applying these changes to an Oracle database but the change data tables and control table structures are well documented. [...]
1141 18 32_Re: DB2 Connect - Need Info ASAP14_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 8 Sep 2000 08:21:15 -0400340_us-ascii Dean,
Q1. Not sure what you mean. Serialization on what? Q2. NO Q3. NO
Phil
================================================ 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.
1160 17 14_Event Analyzer18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Fri, 8 Sep 2000 08:23:35 -0400300_- Has anyone used the event analyzer on Windows NT4? I ftp'ed the file from the Solaris server and tried to open the event file in Windows NT Event Analyzer. I keep getting Dr. Watson errors in db2eva.exe. Was wondering if anyone else has hit this in the past and may have a possible solutioin. [...]
1178 41 74_Re: 00c90101 - Partitioned tablespace - Delete where current ofcursor-name15_Anthony R Gould17_agould@UAKRON.EDU30_Fri, 8 Sep 2000 08:24:14 -0400451_us-ascii No, this tablespace has never been DSN1COPYed. We do use DSN1COPY to "clone" instances of our PeopleSoft system in test. This is a Data Warehouse application and we only do LOAD RESUME and DELETES against this data. Since the addition of the 5 partitions in April (this was done since the last successful run of this DELETE) we have only done one LOAD RESUME and no DELETES. All other access against this tablespace has been via SELECT. [...]
1220 76 32_Re: DB2 Connect - Need Info ASAP0_24_markus.schaub@SYSTOR.COM30_Fri, 8 Sep 2000 14:38:42 +0200584_us-ascii hi dean
each system runing any db2/udb component (ee, connect, client, admin client, etc.) has its own local database directory and if you are defining a remote database on your connect, you will only update your local database directory. if you then use your "local database" to connect to, in fact you will connect to the remote database. so there will be no serializaltion necessary. after a new table is added or a table is modified in the remote database, you will see the changes as soon as they are commited (if you are already connected) or the next time [...]
1297 72 27_Re: Archive Blksize - again19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 8 Sep 2000 07:51:28 -0500588_iso-8859-1 Hi Ulf, You answered your own question correctly! However, the situation isn't necessarily as bad as you may think. You would only have to reblock an Archive *IF* it was needed! Most rollbacks should be able to complete out of the Archives that are still on DASD.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you [...]
1370 56 75_Re: 00c90101 - Partitioned tablespace - Delete where current ofcu rsor-name10_Ulsas, Tom23_tulsas@DOIT.STATE.IN.US30_Fri, 8 Sep 2000 07:49:36 -0500672_iso-8859-1 Tony, Just for the record, would you itemize the steps you performed when you added the 5 partitions.
-----Original Message----- From: Anthony R Gould [mailto:agould@UAKRON.EDU] Sent: Friday, September 08, 2000 7:24 AM To: DB2-L@RYCI.COM Subject: Re: 00c90101 - Partitioned tablespace - Delete where current ofcursor-name
No, this tablespace has never been DSN1COPYed. We do use DSN1COPY to "clone" instances of our PeopleSoft system in test. This is a Data Warehouse application and we only do LOAD RESUME and DELETES against this data. Since the addition of the 5 partitions in April (this was done since the last successful run of [...]
1427 205 32_Re: BMC Unload/Load Plus for DB219_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 8 Sep 2000 08:06:15 -0500592_iso-8859-1 Hi Doc, James, If one was lucky enough to be able to place the tablespace in read only, QUIESCE WRITE(FORCE) it, and shared DASD existed between the target and source, DSN1COPY could be used to copy both the table and indexspaces.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, [...]
1633 46 23_Re: DB2 functions/FMIDs27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Fri, 8 Sep 2000 08:08:37 -0500593_- Thanks! That will be so helpful.
Tina
> -----Original Message----- > From: Hylton Tom P [SMTP:Tom.P.Hylton@IRS.GOV] > Sent: September 07, 2000 2:45 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 functions/FMIDs > > If you have access to IBMLINK, you can use the PCR function (Product Cross > Reference List) under the Service option. This will give you a list of > all components under a product, including FMIDs. The description isn't > detailed, but does have the common name of the functions. > > You need to know the program number for the product you're looking for. > > [...]
1680 85 74_Re: 00c90101 - Partitioned tablespace - Delete where current ofcursor-name15_Anthony R Gould17_agould@UAKRON.EDU30_Fri, 8 Sep 2000 09:30:16 -0400615_us-ascii The data from the existing 12 partitions were unloaded. The tablespace was dropped and the complete structure from tablespaces, table, and index was re-created including the 5 new partitions. The data was then re-loaded.
In reality there were other steps such as quiescing the tablespace, imagecopy, start the objects in UT, re-binding plans and other various small steps. This process was done using Compuware's DBA/XPERT and processing a MODification against the Tablespace and all dependent objects and then telling Compuware to alter the tablespace and indexes to add the 5 new partitions. [...]
1766 37 18_Re: Event Analyzer13_Fletcher, Jim21_jim.fletcher@BSIS.COM30_Fri, 8 Sep 2000 09:30:05 -0400338_iso-8859-1 You might try using db2evmon instead of db2eva. The output is text, but I believe has more info than db2eva. I have always left the files on the server in their original location. You can then let DB2 find the files using -evm option. I know this doesn't answer your question directly...moving the file to NT should work. [...]
1804 121 75_Re: 00c90101 - Partitioned tablespace - Delete where current ofcu rsor-name15_Murley, Michael22_Michael_Murley@BMC.COM30_Fri, 8 Sep 2000 08:56:37 -0500442_iso-8859-1 Tony,
The 00C90101 reason code is a very generic 'something is wrong with the data' code that is further qualified by the ERQUAL value and the issuing CSECT name. If you didn't use DSN1COPY or anything else external to DB2, I would recommend that you open a problem with IBM. They may want to see an SVC dump if one was created, so you might check to see if there is one; ask your MVS systems folks if you're not sure. [...]
1926 49 18_Re: Event Analyzer18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Fri, 8 Sep 2000 09:57:37 -0400548_- Thanks. I will give it a shot.
-----Original Message----- From: Fletcher, Jim [mailto:jim.fletcher@BSIS.COM] Sent: Friday, September 08, 2000 9:30 AM To: DB2-L@RYCI.COM Subject: Re: Event Analyzer
You might try using db2evmon instead of db2eva. The output is text, but I believe has more info than db2eva. I have always left the files on the server in their original location. You can then let DB2 find the files using -evm option. I know this doesn't answer your question directly...moving the file to NT should work. [...]
1976 49 18_Re: Event Analyzer18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Fri, 8 Sep 2000 10:05:27 -0400549_- db2evmon did the trick. Thanks!
-----Original Message----- From: Fletcher, Jim [mailto:jim.fletcher@BSIS.COM] Sent: Friday, September 08, 2000 9:30 AM To: DB2-L@RYCI.COM Subject: Re: Event Analyzer
You might try using db2evmon instead of db2eva. The output is text, but I believe has more info than db2eva. I have always left the files on the server in their original location. You can then let DB2 find the files using -evm option. I know this doesn't answer your question directly...moving the file to NT should work. [...]
2026 170 74_Re: 00c90101 - Partitioned tablespace - Delete where current ofcursor-name0_18_mebert@AMADEUS.NET30_Fri, 8 Sep 2000 16:01:07 +0200434_us-ascii Is it possible that a LOAD RESUME YES job was cancelled or abended and then re-run (not RESTARTed) without first RECOVERing the tablespace/partition?
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
From: Anthony R Gould on 08/09/2000 13:30 GMT
Please respond to DB2 Data Base Discussion List [...]
2197 185 73_Re: 00c90101 - Partitioned tablespace - Delete where currentofcursor-name15_Anthony R Gould17_agould@UAKRON.EDU30_Fri, 8 Sep 2000 10:43:31 -0400373_us-ascii No, there as only been one LOAD RESUME YES job run against this tablespace and the job ended normally. No other update job has been run against this tablespace.
Michael Murley gave me an APAR PQ25741 that I've determined is here but has not been installed. The description of the problem is a "perfect" match. We will put the fix on and give it a try. [...]
2383 128 38_Re: JAVA, DB2 and varchar/fixed length13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Fri, 8 Sep 2000 09:50:40 -0500387_iso-8859-1 Leon,
The Java is executing on websphere, NT.
We have decided not to go the VARCHAR route with the columns on DB2 tables. We have classes to handle the stripping of data returned via results sets.
After some more investigation we narrowed our problem with Cobol stored procedures parameters. The same initial concerns which I outlined still applied. [...]
2512 29 11_DB2 Connect12_Carol Sutfin19_csutfin@AMSOUTH.COM30_Fri, 8 Sep 2000 10:12:25 -0500386_- I hope someone on the list can help us.
We have a client/server application using DB2 Connect and Comm Manager to access data on our mainframe running MVS 5.2.2 and DB2 V4.
They are trying to get the access to work using two different LU ID's. One is for access to test DB2 and the other is for access to production DB2. The DB2 subsystems run on different LPAR's. [...]
2542 61 15_Re: DB2 Connect16_Michael McCarthy18_mmccarthy@DTCC.COM30_Fri, 8 Sep 2000 11:36:00 -0400358_us-ascii Carol,
All you need to do is define the second LU just like the first, and there should be no problem. Just make sure you use the right symbolic destination name for each node. I have multiple SNA LU connections as well as TCP/IP, If you let me know the error you're receiving, I might be able to be more specific with what to look for, [...]
2604 107 27_Re: Archive Blksize - again22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 8 Sep 2000 11:36:16 -0400298_iso-8859-1 Rick -
I agree that you would need to reblock an archive log that DB2 wanted to read... if you can figure out how to do it. The archive log is a variable blocked file (RECFM=VB). I think you would have to twiddle some control blocks in the log file. Could be very dangerous. [...]
2712 166 17_Re: ODBC to OS39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 8 Sep 2000 11:52:20 -0400520_iso-8859-1 It's because dynamic SQL must be bound before it executes. I think the correct term is mini-bind. If you activate a SQL statement detail IFCID trace, then you'll see the mini-bind. Limit the trace to a specific plan, package, and authorization id to minimize the trace overhead.
Doesn't binding static SQL require DBD locks? I believe the mini-bind process is very similar to binding static SQL as far as taking catalog/directory locks, authorization checking, establishing an access path, etc... [...]
2879 16 36_Dynamic Select Statement In UDB V6.118_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Fri, 8 Sep 2000 12:11:18 -0400523_- Does anyone know why the FOR FETCH ONLY would be appended to every dynamic select statement sent from a v6.1 client to UDB v6.1? This parameter is not coded anywhere in the application. Is there a way to turn this off?
Peter J. Krawetzky Aetna, Inc. DataBase Administrator
================================================ 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.
2896 13 40_Re: Dynamic Select Statement In UDB V6.114_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 8 Sep 2000 12:21:44 -0400385_us-ascii I believe this is set on by DB2 Connect automatically if you specified blocking all so that you don't have ambiguous cursors. HTH Phil
================================================ 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.
2910 48 15_Re: DB2 Connect16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU30_Fri, 8 Sep 2000 12:47:43 -0400398_iso-8859-1 Hey Carol... It's very do-able. We do that here. Just create 2 different data sources (prod,test) through CCA. Make sure that you have the two LU's defined to DB2 & VTAM.
-----Original Message----- From: Carol Sutfin [mailto:csutfin@AMSOUTH.COM] Sent: September 08, 2000 11:12 AM To: DB2-L@RYCI.COM Subject: DB2 Connect
I hope someone on the list can help us. [...]
2959 36 74_Re: 00c90101 - Partitioned tablespace - Delete where current ofcursor-name9_Rama Kypa23_RKYPA@ISETS.STATE.IN.US30_Fri, 8 Sep 2000 11:55:11 -0500423_us-ascii In latest version also, is it required to unload and load unaffected partitioned data (i.e. some of partitions limit key doesn't change) due to addition of new partition?. Thanks. Ram
-----Original Message----- From: Anthony R Gould [SMTP:agould@UAKRON.EDU] Sent: Friday, September 08, 2000 8:30 AM To: DB2-L@RYCI.COM Subject: Re: 00c90101 - Partitioned tablespace - Delete where current ofcursor-name [...]
2996 52 17_FW: ODBC to OS39012_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Fri, 8 Sep 2000 13:11:58 -0400482_iso-8859-1 When one makes the catalog entries for the TCPIP node, DCS & Database directories, the physical connectivity to the DB2 subsystem on OS/390 isn't checked - This is actually done when issuing the CONNECT command.
If a database isn't listed in SYSIBM.SYSDATABASES (like DSNDB01 to give an extreme example), then on making the necessary catalog entries (which will succeed) - it would be found that its impossible to obtain a connection (via ODBC or otherwise). [...]
3049 128 27_Re: Archive Blksize - again14_Jack O'Connell26_jack.oconnell@MCMASTER.COM30_Fri, 8 Sep 2000 12:08:18 -0500353_iso-8859-1 We had the same problem when we archived to disk. We used a dasd blocksize ( 24576 ) to get half track blocking but when we went to tape we reblocked to a 28k size. The LRECL on the archlogs is FB 4096 so it can be reblocked without repercussions. The BSDS copy that goes with it is variable though, maybe that is what you were thinking [...]
3178 51 17_Re: ODBC to OS39015_Camitta, Steven30_steven.camitta@INGRAMMICRO.COM30_Fri, 8 Sep 2000 10:19:59 -0700325_iso-8859-1 In addition to the dynamic SQL issue, it's the api & the design of ODBC itself. The objective is to be "open" & expose as little of the DBMS architecture as possible. The details are derived at the call level. That way one can write generalized, portable applications that are independent of the vendor DBMS. [...]
3230 48 40_Re: Dynamic Select Statement In UDB V6.114_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Fri, 8 Sep 2000 12:20:10 -0400695_iso-8859-1 Peter,
This is a benefit to you, to prevent unnecessary locking due to ambiguous cursors, etc. Better question, is what would you be trying to accomplish by turning it off? Perhaps there is another solution.
Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@ylassoc.com http://www.YLAssoc.com -- DB2 Performance Journal
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Krawetzky, Peter J > Sent: Friday, September 08, 2000 12:11 PM > To: DB2-L@RYCI.COM > Subject: Dynamic Select Statement In UDB V6.1 > > > Does anyone know why the FOR FETCH ONLY would be appended to every dynamic [...]
3279 152 27_Re: Archive Blksize - again22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 8 Sep 2000 13:22:55 -0400473_iso-8859-1 My bad... You're exactly right Jack.
I was looking at the DCB info for the 1st file on the archive log tape, the BSDS archive. Never mind...
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Jack O'Connell [mailto:jack.oconnell@MCMASTER.COM] Sent: Friday, September 08, 2000 13:08 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Archive Blksize - again [...]
3432 146 27_Re: Archive Blksize - again19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 8 Sep 2000 12:32:26 -0500534_iso-8859-1 Hi Mike, I had to reblock archive logs during a disaster recovery test because we had done exactly as Ulf wants to do. I used IEBCOPY and simply specified the correct BLKSIZE for the output dataset and it worked just fine. Any active log dataset that isn't in use is an archive log (provided they've all been used at least once). There will be a period of time at Ulf's site where a tape archive might need to be hung that will have the old blocksize on it until they all "age off" or would never be called because of [...]
3579 44 12_Re: Rollback13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM30_Fri, 8 Sep 2000 13:26:14 -0400485_us-ascii Thx to Craig, Bob, Georg and Melvin for their replies.
Just a couple more questions on this subject though: 1) How does DB2 process logs that have been archived to tape? Is it smart enough to go to the record it needs to start at and then be able to step through tape by reading backwards? Or does it need to go to the record it needs to start at, rewind the tape, go to the next previous record, rewind the tape, go to the next previous record, etc, etc, etc???? [...]
3624 20 25_DB2 V6 for OS/390 install27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Fri, 8 Sep 2000 12:45:23 -0500313_- Can someone tell me what is a good level to install V6? I keep getting error holds on HDB6610. I also was just notified that there's another toleration PTF for V5! My PDO level is 0034, which points to a PSP level of 0014.
Tina Hilton Database Analyst Bertelsmann mediaSystems Tina.Hilton@bmsus.com [...]
3645 26 29_DB2 Portability AIX to OS/3908_Gary Rue25_Gary.Rue@MAIL.STATE.KY.US30_Fri, 8 Sep 2000 13:50:06 -0400358_iso-8859-1 We are looking to develop an application using WEBSPHERE and Enterprise Java Beans on DB2 UDB for AIX with the goal to migrate to DB2 UDB OS/390 when the capability becomes available.
What database portability issues are there going from AIX to OS/390? What issues are there when porting from an Oracle AIX database to DB2 UDB OS/390? [...]
3672 178 27_Re: Archive Blksize - again22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 8 Sep 2000 13:51:45 -0400395_iso-8859-1 Rick -
Ahh Hah... I've learned something new. I didn't know that "Any active log dataset that isn't in use is an archive log (provided they've all been used at least once)." I suppose the biggest benefit is efficiency & high performance.
Ulf could also copy and reblock the tape archive logs with the old block size to DASD to enable concurrent archive log access. [...]
3851 45 29_Re: DB2 V6 for OS/390 install15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM30_Fri, 8 Sep 2000 14:06:12 -0400441_iso-8859-1 Hi Tina,
Last I heard from IBM -- RML for V6 was as level 0003; however I did not find that to be stable for our environment. Currently, in our environment that is stable is level 0005 with a couple of additional fixes by IBM. We're holding at this level for now as it has been stable for us at this point throughout our testing - non DDF and non Data Sharing environment running under OS/390 V2.6 soon to go to V2.9. [...]
3897 24 0_12_Bob Lawrence21_rlawrence@BOSCOVS.COM30_Fri, 8 Sep 2000 14:15:59 -0400331_us-ascii Hi list,
We have just installed the DB2 REXX lanquage support for DB2 V5 and I saw the sample DRAW program in the REXX LANGUAGE SUPPORT Version 5 manual. Does this program exist as source code that can be downloaded anywhere or must it be typed in? TIA
Bob Lawrence DBA Boscov's Dept Stores Inc [...]
3922 19 39_Re: Are Reorgs Necessary for Version 6?12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 8 Sep 2000 13:23:56 -0500323_- The classic reasons for a reorg still are accurate, but not required on moving to V6. Some situations are definitely safer, such as where the table was altered to increase a length or the definitions are not perfectly identical. You might want PQ39064 to detect some situations if you are not running the IBM REORG. [...]
3942 20 38_DB2 OS/390 Replication Data Propagator26_Patti Townsdin/Houston/IBM19_ptownsdi@US.IBM.COM30_Fri, 8 Sep 2000 12:59:59 -0600539_us-ascii I keep hearing that replication on OS/390 doesn't work. Can anyone give me their positive/negative experiences
Patti Townsdin White Technical Specialist, DB2 OS/390 Services Delivery Technical Center ph 512-838-1187 fax 512-823-3385 pg 800-946-4646 pin 599-3755 ptownsdi@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.
3963 83 12_Re: Rollback22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 8 Sep 2000 15:02:26 -0400574_iso-8859-1 1) Yes, DB2 knows where to start reading the log RBA (LRSN for data sharing). A combination of info in SYSCOPY & SYSLGRNX positions to the starting RBA/LRSN.
DB2 writes undo/redo log records as well as other types of log records. Because of this scheme, I believe DB2 reads the log backward and applies the undo log records to perform a rollback. I believe DB2 can read a tape backward without rewinding. I suppose the efficiency of reading the tape backward is a function of DB2, the Operating System, tape device hardware and tape device microcode. [...]
4047 24 12_Re: Rollback13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Fri, 8 Sep 2000 15:21:11 -0400422_iso-8859-1 Scott, You might find good information by investigating what the REPORT utility will tell you. REPORT RECOVERY tells you, among other things, what resources DB2 expects to use to be able to perform forward recovery for an object or set of objects.
Check the Utility guide for syntax and function as well as sample report output. Better yet, run it for the tablespace with which you had the problem. [...]
4072 64 16_Re: Online Reorg11_Jay Hendley24_jhendley@CDBSOFTWARE.COM30_Fri, 8 Sep 2000 14:11:30 -0500460_ISO-8859-1 CDB has developed a new method for handling on-line utilities. In doing so, we have recently come up with a more efficient and safer way to eliminate the previous downtimes associated with running our on-line reorg/copy utilities. Please see the following changes:
First, when a reorg/copy job is submitted, it is no longer necessary to initiate a LOCK and COMMIT, although a QUIESCE is still established to guarantee the point in time. [...]
4137 36 18_Correlated Columns11_Carl Nelson20_Carl_Nelson@AICI.COM30_Fri, 8 Sep 2000 15:01:52 -0500630_us-ascii I'm trying to understand correlated columns. I understand the concept behind the topic but am struggling with how to determine if two columns are correlated. After reading the IBM Admin Guide vol2 pg 5-218+, it appears to me that all columns are mathmatically correlated. The manual says to count the number of unique values in both columns (which is the column cardinality from syscolumns). Multiply these together producing the maximum number of possible combinations. Then create a view of these two columns and count the number of distinct pairings. If the pairings is < than the maximum number of combinations, [...]
4174 76 22_Re: Correlated Columns11_Suresh Sane21_data_arch@HOTMAIL.COM28_Fri, 8 Sep 2000 16:25:36 CDT350_- Carl:
In general, unless the count of groupings is exactly equal to the product of the individual cards, the columns ARE correlated. The real question is the DEGREE of correlation.
Case 1: col1 card = 5, col2 card = 20, card of col1.col2 combination = 98 Case 2: col1 card = 5, col2 card = 20, card of col1.col2 combination = 22 [...]
4251 62 16_Re: Online Reorg14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 8 Sep 2000 17:26:43 -0500689_iso-8859-1 A few more thoughts on the Online Reorg discussions taking place on the list recently...
Balancing online utility processes with high transaction volumes present increasing challenges for everyone, especially in SAP and Peoplesoft environments. Even if reorgs use sophisticated methods of achieving renames without stopping the objects (an obvious outage that most environments cannot tolerate), sensitive balancing of utility processes and high online activity is needed. BMC's online reorg has eliminated the need to stop the object in order to apply log final records and complete the renames of shadow datasets being updated. Abends such as -904s (which are due [...]
4314 92 76_Re: 00c90101 - Partitioned tablespace - Delete where current of c ursor-name13_Olson, Carlos14_COlson@QRS.COM30_Fri, 8 Sep 2000 16:11:27 -0700428_iso-8859-1 I had some mysterious 00C90101 errors occurring a couple of months back. I suspected they were due to DFDSS moves of the underlying VSAM datasets (vcat.DSNDBD.*) from 1 volume to another. It seemed way too coincidental that I experienced the errors on 2 of 8 datasets moved. We never discovered anything conclusive... just did recoveries from imagecopies and moved on. I haven't done any DFDSS moves since then. [...]
4407 32 32_UDB6.1 on AIX : Circular Logging0_18_Usregion10@AOL.COM28_Fri, 8 Sep 2000 20:10:26 EDT301_ISO-8859-1 Hi Folks!
By default the db2 udb logging is set to circular logging. Yesterday I ran out of space (SQLCODE -968) for my log file. As a quick fix, I gave it more space and things were back to normal. However, my mission for the next week is: Test how the circular logging works. [...]
4440 83 20_Re: Training Ground?17_Andrew Karandjeff17_eak3rd@SWBELL.NET30_Sat, 9 Sep 2000 23:49:02 -0500575_Windows-1252 As I have just recently started in my development position, I have not really been given an area of responsibility. I had been testing our application for the previous 18 months or so, I have a strong knowledge of our application's data and a solid grasp of SQL. Our DBA and my boss have been giving me some tasks to do that are database related: cleaning up orphans off our four test boxes, hunting production issues, some data mining and report generation for clients, creating metadata documentation, etc. I have been asked to back our DBA up at the end [...]
4524 47 42_Re: DB2 OS/390 Replication Data Propagator11_rick creech18_ykcirc@HOTMAIL.COM29_Sun, 10 Sep 2000 11:49:04 GMT308_- Not so. We use it for a lot of different scenarios on os/390 in both data-sharing and non data-sharing. It's a fully supported product on os/390. Let me give BMC a plug: They also have a replicator product that works on os/390, so if you are evaluating I would look at their product as well as IBM's. [...]
4572 45 29_db2 os/390 migration question29_Sherri Sterling DIGEST NOMIME29_Sherri.Sterling@BPD.TREAS.GOV31_Sun, 10 Sep 2000 10:34:14 -0400544_us-ascii When we migrated from db2 version 4 to 5, we put up a new subsystem and exported everything over to the new subsystem. But now our db2 subsystem environment is too big to do this. So we migrated db2 version 5 tables to version 6. However, the vsam names behind the tables all have a high level qualifier of db25. Also the subsystem name could not be changed on the migration process and it is still db5T as are the archive and active logs dataset names. I think that after the migration, I can easily change the subsystem to db2T [...]
4618 53 42_Re: DB2 OS/390 Replication Data Propagator14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Sun, 10 Sep 2000 14:08:13 -0400447_iso-8859-1 Patti,
Replication on OS/390 has not only been working for years, it is a major software product of your company (IBM) that has been doing it -- Data Propagator Relational and Non-relational series of products.
Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net http://www.YLAssoc.com -- DB2 Performance Journal http://www.ryci.com -- RYC Knowledge Database http://www.DB2-Portal.com [...]
4672 108 33_Re: db2 os/390 migration question12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Sun, 10 Sep 2000 16:06:06 -0500522_- Sherri,
Don't feel that you are alone here. I have inherited a set of DB2 subsystems with the same problems. Active logs, Archive logs, BSDS all have different high-level qualifiers. There are at least three other HLQ's being used for the application datasets.
The application database image copies use a totally different HLQ that is in a different USERCAT. The image copies of the system catalog OAM, Platinum Database and a few other databases that we maintain (System Support) use an another HLQ. [...]
4781 31 49_Re: set package set - one way to use this concept12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 11 Sep 2000 11:04:33 +1300564_us-ascii Michael, James,
Firstly Michael, I wondered when you'd comment on the use of identical tables with different owners. Glad to see it's still working well.
By the time I read the rest of my DB2-L messages there will probably already be an answer to my question which, I think, may be the same as James is suggesting. I understand that having a collection of *.* bound into the plan means you don't have to rebind the plan to add new collections. What James is suggesting - I think - and I'd certainly like to know, is whether you can use [...]
4813 17 54_Paul Packham/ITS/POSG/POSTOFFICE is out of the office.0_29_paul.packham@POSTOFFICE.CO.UK31_Mon, 11 Sep 2000 01:05:04 +0000428_us-ascii I will be out of the office from 09/09/2000 until 20/09/2000.
I will respond to your mail when I return, however please contact Neil Miller if urgent.
Regards 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.
4831 83 49_Re: set package set - one way to use this concept14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 11 Sep 2000 11:09:21 +1100613_iso-8859-1 Michael
I obviously didn't explain myself very clearly.
As Raymond noted, my question related to whether the package named in a SET CURRENT PACKAGESET needs to be accesible through the PKLIST.
My comments about searching the skeleton cursor table when one has PKLIST(*.*) was based on an (erroreous) interpretation of your posting that you had some generic code that accessed common tables (ie aliased from every environment) first. In this case it would not matter in which collection a matching package was found - since the SQL would end up accessing the same base tables. [...]
4915 31 31_Re: CHANGING A TABLESPACE CCSID12_Roger Miller19_millerrl@US.IBM.COM31_Sun, 10 Sep 2000 22:15:50 -0500533_- First you need to find out what code page the data is really stored in. Does the text include German unique characters? Spanish? French? Danish? or is from a country that has multiple languages? You get an initial guess by reading the code page appendix from the Installation Guide. If you are lucky, then the code page DSNZPARM is set to zero, so you didn't get a mixture of direct entry and translation to some other code page. Even in the good, lucky cases, you still need lots of information and may need to change a lot. [...]
4947 13 45_Re: DB2 Audit and a DB2 v6 compatible release12_Roger Miller19_millerrl@US.IBM.COM31_Sun, 10 Sep 2000 22:19:45 -0500375_- The combination of DataPropagator and DataJoiner has the capability to go to other vendor DBMS.
Roger Miller, DB2 for OS/390
================================================ 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.
4961 14 52_Cathy L Peck/ISG/CORP/Highmark is out of the office.10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Mon, 11 Sep 2000 01:00:46 -0400365_us-ascii I will be out of the office from 09/08/2000 until 09/18/2000.
I will respond to your message when I return.
================================================ 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.
4976 55 11_Unsubscribe10_Wang.James24_Wang.James@AAA-CALIF.COM31_Sun, 10 Sep 2000 22:12:31 -0700167_us-ascii Bye!
James Wang ESD-Technical Services Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com
5032 44 25_Accessing B@ from the web15_MAHSOUN, KHALID29_kmahsoun@SAUDIAIRLINES.COM.SA31_Mon, 11 Sep 2000 08:30:05 +0300114_-
hi is there any documentation regarding the authorization process of access DB2 OS/390 through the web .
5077 18 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Mon, 11 Sep 2000 01:01:39 -0500481_us-ascii I will be out of the office starting 09/11/2000 and will not return until 09/12/2000.
I will respond to your message when I return. If this is an emergency, please contact Alison Pellitier, at (801) 902-4184
================================================ 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.
5096 248 17_Re: ODBC to OS3900_18_mebert@AMADEUS.NET31_Mon, 11 Sep 2000 09:25:51 +0200353_us-ascii Yes, I have no problem with that - but the central question (where I'm stuck) is, why does DB2 continue to hold the locks during execution of the dynamic SQL? Static SQL doesn't require them then. We have a lot of long running dynamic SQL SELECTs in our DSS (decision support system) databases, and it is a real pain to run any DDL there. [...]
5345 199 10_DFDSS move0_18_mebert@AMADEUS.NET31_Mon, 11 Sep 2000 09:41:14 +0200542_us-ascii I have been using ADRDSSU moves since a long time to reduce extents - much less CPU, much faster & better than using REORG for that. Never had any problem. I use the JCL below for the purpose. Now the question: the JCL copies the empty part of the VSAM file as well. Sometimes I want that (when the TS is expected to grow); sometimes not (if a file was over-allocated); sometimes I even want the target to have more space than the source. How can I specify that only the used portion is copied (the DFSMSdss Storage manuals did [...]
5545 20 26_No of rows and Performance24_Mahadevan Krishnamoorthy34_mahadevan.krishnamoorthy@WIPRO.COM31_Mon, 11 Sep 2000 13:51:01 +0530496_- Hi List,
Is there anyway we can relate the number of rows we have in a table with the time taken by an SQL on that table (either index or tablespace scan). We are doing some study on a test system which we want to extrapolate to a production system. We are operating with fewer rows in the test system tables . I want to extrapolate the In DB2 CPU time from test to production system . For this what are the factors I should take into consideration?.Please give your views on this. [...]
5566 163 49_Re: set package set - one way to use this concept0_18_mebert@AMADEUS.NET31_Mon, 11 Sep 2000 10:27:37 +0200367_us-ascii You're absolutely right: if the CURRENT PACKAGESET register is not blank, DB2 ignores the plan packagelist (I just looked it up in the SQL reference). I had incorrectly assumed otherwise. So the PKLIST(*.*) is redundant - think of it as documentation.
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...]
5730 31 43_Date format setting in UDB (Solaris) client13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Mon, 11 Sep 2000 10:22:44 +0100369_us-ascii We've just installed a DB2 system on a Solaris server, which is being accessed from WebSphere Application Server on another Solaris box - we've installed the DB2 Solaris client on this.
The date format being displayed on the client is US format - e.g. 08/30/2000. We want the dates in UK format as that is you the Java apps on the WAS expect them. [...]
5762 14 18_Re: Event Analyzer9_Colin Fay13_cfay2@CSC.COM31_Mon, 11 Sep 2000 07:01:11 -0400311_us-ascii Remember when you FTP to use the binary option.
Colin
================================================ 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.
5777 117 20_Re: Training Ground?15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Mon, 11 Sep 2000 07:07:05 -0400656_windows-1252 Andrew,
Discuss your needs more with your DB2 systems installer and DBA as shipped with DB2 for OS/390 are Sample databases and tables found in the installation .SDSNSAMP library. In V6, Chapter 2-9 of the installation guide discusses using these tables for the IVP (Installation Verification process). Usually after installation is complete, either they get removed or just sit there with no activity if they were ever installed to begin with. If your systems installer has installed these on a development/test subsystem, maybe he/she can grant you authorization to use and learn some fundamentals using these tables. If not, at [...]
5895 27 22_DB2 5.1 and OS/390 2.915_Pelle Svennberg24_per-erik.svennberg@NB.SE29_Mon, 11 Sep 2000 13:00:06 GMT357_us-ascii we are testing our new OS/390 ver 2.9 together with DB2 ver 6.1 and it runs ok
now we are falling back to DB2 ver 5.1 and we wonder if anybody has any knowledge of the combination OS/390 2.9 vs DB2 5.1 do they run smothly together or...?
we are quit sure they do but our project leader for OS/390 2.9 want us to check in any way [...]
5923 71 45_Re: DB2 Audit and a DB2 v6 compatible release0_19_mike.holmans@BT.COM31_Mon, 11 Sep 2000 13:36:28 +0100559_- What we are mainly concerned with is getting a version which works with compressed tablespaces. We haven't been beating up on them to get us a V6-compatible release, as we aren't going to have that available for use until 1q2001 anyway.
Have they said it won't work with V6 at the moment, or just that it doesn't support V6 features? I don't know how the log format changes, if at all, between V5 and V6 as long as you only run an application which ran under V5 unmodified, so I don't know whether there would be serious incompatibilties, but I [...]
5995 50 42_Re: DB2 OS/390 Replication Data Propagator11_Manish Lall23_Manish.Lall@IN.IDLX.COM31_Mon, 11 Sep 2000 17:34:48 +0530515_us-ascii Patti,
It works. when we moved from DB2 V5 toUDB V6 we had installed the evaluation copy of propagator and it worked properly. No problem.
Manish
Patti Townsdin/Houston/IBM @RYCI.COM> on 09/09/2000 00:29:59
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 Replication Data Propagator [...]
6046 62 26_Re: DB2 5.1 and OS/390 2.911_Manish Lall23_Manish.Lall@IN.IDLX.COM31_Mon, 11 Sep 2000 17:41:35 +0530293_us-ascii Hi Pelle,
Before we( in my previous company) migrated from DB25.1 to Db2 v6.1 we were at OS/390 2.9 . So no problem. It run smoothly together . Because firstly we moved from OS/390 V2.6 to OS/390 V2.9. When everything was fine then we moved from DB2 V5.1 to DB2/UDB v 6.1 [...]
6109 67 30_Re: No of rows and Performance0_19_mike.holmans@BT.COM31_Mon, 11 Sep 2000 14:37:43 +0100501_- The short answer to your question is "It depends".
One of the most important things to do is to make sure that your catalog stats on the test system are the same as the ones in production (or what is projected for production). If you don't arrange that, you run the risk of the access path chosen for the test system being different to the one which gets used in production, and if you don't have the same access path for your SQL, the measurements taken on test are completely useless. [...]
6177 37 68_restoring UDB instance/database from one server to different serv er17_Hipenbecker, Doug25_Hipenbecker.Doug@MBCO.COM31_Mon, 11 Sep 2000 08:57:19 -0500440_iso-8859-1 Greetings!
I hope someone can enlighten me here...
I have the need to restore a UDB instance/database from server A to server B where the instance/database does not currently exist on server B.
I have read all of the documentation...it appears to be a the RESTORE command with the "INTO" & "TO" parameters...I'm not sure from the documentation about the "REDIRECT" parameter (if it would be necessary). [...]
6215 29 40_Re: Dynamic Select Statement In UDB V6.118_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Mon, 11 Sep 2000 09:56:21 -0400605_- IBM recommends changing the db2_rr_to_rs configuration parm to on. Does anyone have any experience with this? The description in the troubleshooting guide seems to coverage the problem I have with deadlocks. Want to know if anyone has seen a negative impact to this.
> -----Original Message----- > From: Krawetzky, Peter J > Sent: Friday, September 08, 2000 12:11 PM > To: 'DB2-L@RYCI.COM' > Subject: Dynamic Select Statement In UDB V6.1 > > Does anyone know why the FOR FETCH ONLY would be appended to every dynamic > select statement sent from a v6.1 client to UDB v6.1? This parameter is [...]
6245 144 26_Re: DB2 5.1 and OS/390 2.913_Carol Robbins18_CJRobbins@FHSC.COM31_Mon, 11 Sep 2000 09:57:58 -0400381_US-ASCII How about if the OS/390 at 2.8?
>>> Manish.Lall@IN.IDLX.COM 09/11/00 08:11AM >>> Hi Pelle,
Before we( in my previous company) migrated from DB25.1 to Db2 v6.1 we were at OS/390 2.9 . So no problem. It run smoothly together . Because firstly we moved from OS/390 V2.6 to OS/390 V2.9. When everything was fine then we moved from DB2 V5.1 to DB2/UDB v 6.1 [...]
6390 106 30_Re: No of rows and Performance13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Mon, 11 Sep 2000 15:04:00 +0100433_- Folks
not only what Mike says but what processor you are running on will make a difference when your plan/package is bound. DB2 takes into account the 'muscle' or otherwise of the machine you are BINDing on when deciding in the 'best' access path.
Ian McDonald DB2 DBA Abbey National ---------- From: mike.holmans@BT.COM To: DB2-L@RYCI.COM Subject: Re: No of rows and Performance Date: 11 September 2000 02:37PM [...]
6497 54 71_Re: restoring UDB instance/database from one server to different server14_Mike Lebermann18_Lebermm@BCBSKC.COM31_Mon, 11 Sep 2000 09:07:47 -0500416_US-ASCII Douglas,
What platform are you running UDB on? Where are you storing you backups (ie ADSM, filesystem, etc)?
Mike
>>> Hipenbecker.Doug@MBCO.COM 09/11/00 08:57AM >>> Greetings!
I hope someone can enlighten me here...
I have the need to restore a UDB instance/database from server A to server B where the instance/database does not currently exist on server B. [...]
6552 74 71_Re: restoring UDB instance/database from one server to different server17_Hipenbecker, Doug25_Hipenbecker.Doug@MBCO.COM31_Mon, 11 Sep 2000 09:35:30 -0500452_iso-8859-1 UDB NT & AIX Version 5.2 & 6.1...
Backups are to disk filesystems
I'm currently using db2move to do what I want...but would like to know *if* there is a RESTORE posssibility...
Doug H Miller
-----Original Message----- From: Mike Lebermann [mailto:Lebermm@BCBSKC.COM] Sent: Monday, September 11, 2000 9:08 AM To: DB2-L@RYCI.COM Subject: Re: restoring UDB instance/database from one server to different server [...]
6627 16 44_Rebind parms abbreviations changed in V6.1!!12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Mon, 11 Sep 2000 09:13:56 -0500451_- Where can I find the abbreviations available for parms. In particular the REBIND command. It seems the the abbreviation O for OWNER works in the REBIND command in V5. We upgraded to V6.1 this weekend on our test regions and the abbreviation no longer works. What else has changed? I have looked in the V6 manuals but have had little luck on finding what abbreviations are no longer supported. Anybody else run into this when going to V6.1? TIA [...]
6644 292 14_Re: DFDSS move13_Daley, Norman18_NDaley@CINERGY.COM31_Mon, 11 Sep 2000 11:09:04 -0400345_iso-8859-1 Michael, I'm surprised I haven't seen a response from anyone yet, so here goes.
For a time I did not have ADR available, and used REPRO extensively. I moved tablespaces, logs, bootstraps without a problem. Also allocated all these bigger/smaller without a problem. I have a process that creates JCL such as the following: [...]
6937 122 71_Re: restoring UDB instance/database from one server to different server13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 11 Sep 2000 10:19:06 -0500266_US-ASCII Doug, as long as the TARGET server has the same DRIVE setup you can copy the backup to that server and do a restore using the INTO parm. If you do not have the same DRIVE setup at the then TARGET server then use redirected restore or DB2MOVE. HTH Kurt [...]
7060 304 17_Re: ODBC to OS39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 11 Sep 2000 11:21:39 -0400411_iso-8859-1 I hear you on the DDL change pain in a busy dynamic SQL environment.
My guess... maybe it's because the mini-bind is considered a component of the UOW of dynamic SQL. Why? I don't know. Does someone else know? As I'm sure you're aware, if you execute dynamic SQL with no auto commit, then the catalog/directory locks are held. Issue a commit and the catalog/directory locks are released. [...]
7365 154 53_Re: DB2 5.1 and OS/390 2.8 was DB2 5.1 and OS/390 2.922_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 11 Sep 2000 11:24:45 -0400789_iso-8859-1 We're executing DB2 for OS/390 5.1 and OS/390 2.8 OK.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Carol Robbins [mailto:CJRobbins@FHSC.COM] Sent: Monday, September 11, 2000 9:58 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 5.1 and OS/390 2.9
How about if the OS/390 at 2.8?
>>> Manish.Lall@IN.IDLX.COM 09/11/00 08:11AM >>> Hi Pelle,
Before we( in my previous company) migrated from DB25.1 to Db2 v6.1 we were at OS/390 2.9 . So no problem. It run smoothly together . Because firstly we moved from OS/390 V2.6 to OS/390 V2.9. When everything was fine then we moved from DB2 V5.1 to DB2/UDB [...]
7520 22 26_VM, VSE, VSAM Transparency13_Jeff Jennings25_Jeff_Jennings@FSAFOOD.COM31_Mon, 11 Sep 2000 08:16:07 -0700504_us-ascii Hi List, We are a VM/VSE shop that is in the beginning stages of implementing DB2. I have installed V6 of DB2 on both the VM and VSE platforms. I have also installed V5 of VSAM Transparency on a VSE machine. I have been able to access the VM DB from VSE. Can I access the VSE DB from VM? If so, how? I have been able to move a VSAM file into DB2/VSE and access it without changing the application program. Can I move the VSAM file to DB2/VM and still access it from VSE? Again, if so, how? [...]
7543 124 71_Re: restoring UDB instance/database from one server to different server0_22_rmadan@CYVEILLANCE.COM31_Mon, 11 Sep 2000 11:30:48 -0400551_iso-8859-1 replied to you on "DB2EUG: Restoring UDB full offline backup to different server"
my response:
yes...do it all the time...you need to do a redirected restore to size and point the containers to the correct drives on your target server. Remember you need to allocate the high water mark for pages used. It is pretty straight forward. the order of execution, as described in the manual is: restore db.........................redirect; set tablespace containers for (tbspaceid) using (path/file/device); restor db continue; [...]
7668 195 30_Re: No of rows and Performance0_18_mebert@AMADEUS.NET31_Mon, 11 Sep 2000 17:27:08 +0200328_us-ascii That's a detail... any processing that does not scale in a more or less linear fashion (with N*logN, e.g. sorting or index search, being included in more-or-less linear) can be considered as not suitable for production volumes. To give a (very hazy) ballpark figure, I would count with about 3000 rows/CPU second. [...]
7864 116 77_Re: 00c90101 - Partitioned tablespace - Delete where curr ent of c ursor-name22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 11 Sep 2000 11:30:39 -0400576_iso-8859-1 We've used DFDSS to successfully move DB2 VSAM Linear data sets all the time. Others on the list have stated they use DFDSS as well. Make sure you specify the correct options. Search the DB2-L archives for details.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Olson, Carlos [mailto:COlson@QRS.COM] Sent: Friday, September 08, 2000 19:11 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] 00c90101 - Partitioned tablespace - Delete where current of c ursor-name [...]
7981 325 17_Re: ODBC to OS39013_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Mon, 11 Sep 2000 10:36:33 -0500401_iso-8859-1 Just wanted to comment that the same issue DOES exist with static sql as well (sort of). If you have a package that has been invalidated causing automatic rebind, then there are locks retained on the catalog until the program issues a commit. If the program happens to be a long-running read-only process that does not issue commits, then the locks could be held for a very long time. [...]
8307 44 42_Re: DB2 OS/390 Replication Data Propagator14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Mon, 11 Sep 2000 10:45:26 -0500850_iso-8859-1 For anyone interested in the BMC data propagation solution that Rich mentioned below check out http://www.bmc.com/products/edp/
The BMC solutions for data propagation include DataMove for data propagation via extraction and ChangeDataMove for data propagation via log capture.
Cheers, Craig S. Mullins Director, DB2 Technology Planning BMC Software http://www.bmc.com Craig_Mullins@bmc.com http://www.craigsmullins.com cmullins@compuserve.com
>---------------------------------------------------------------------- > >Date: Sun, 10 Sep 2000 11:49:04 GMT >From: rick creech >Subject: Re: DB2 OS/390 Replication Data Propagator > >Not so. We use it for a lot of different scenarios on os/390 in both >data-sharing and non data-sharing. It's a fully supported product on os/390. >Let me [...]
8352 36 18_Online Reorg in V613_Johnson, Bill18_bjo23@ALLSTATE.COM31_Mon, 11 Sep 2000 10:27:58 -0500396_- We are trying to run online reorg for some of our tablespaces that require 24 X 7 availability. The reorg statement is as follows:
REORG TABLESPACE PEDPRSN.PES110 SHRLEVEL CHANGE COPYDDN(SYSCOPY1,SYSCOPY2) MAPPINGTABLE DB2PROD.MAP_PES110 MAXRO 30 DELAY 1200 LONGLOG DRAIN SORTDEVT DISK SORTNUM 4 KEEPDICTIONARY SORTDATA LOG NO STATISTICS TABLE(ALL) SAMPLE 10 INDEX(ALL) UPDATE(ALL) [...]
8389 296 14_Re: DFDSS move12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 11 Sep 2000 19:16:26 +0200582_x-user-defined Hi, I've used repro a lot. Just give it more buffnd(60-80) and not bufni. Look for enough region. Isaac Yassin
"Daley, Norman" wrote: > > Michael, > I'm surprised I haven't seen a response from anyone yet, so here goes. > > For a time I did not have ADR available, and used REPRO extensively. > I moved tablespaces, logs, bootstraps without a problem. Also allocated > all these bigger/smaller without a problem. I have a process that creates > JCL such as the following: > > //STOP EXEC SQLTSO > //SYSTSIN DD * > DSN SYSTEM(DB2T) > -STOP DATABASE(DB001) [...]
8686 199 30_Re: No of rows and Performance12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 11 Sep 2000 19:20:35 +0200607_x-user-defined Hi, And don't forget to check if you have the same disks( vendor, box type, cache, workload). It all affects your I/O and response time. Isaac Yassin
mebert@AMADEUS.NET wrote: > > That's a detail... any processing that does not scale in a more or less linear > fashion (with N*logN, e.g. sorting or index search, being included in > more-or-less linear) can be considered as not suitable for production volumes. > To give a (very hazy) ballpark figure, I would count with about 3000 rows/CPU > second. > > Dr. Michael Ebert > DB2 Database Administration > aMaDEUS Data Processing [...]
8886 24 26_Re: DB2 5.1 and OS/390 2.912_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 11 Sep 2000 19:23:19 +0200126_x-user-defined Hi, We have DB2 V5.1 working on OS/390 V2.8 w/o problems. It's being migrated nowadays to V6.1.
8911 57 22_Re: Online Reorg in V612_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 11 Sep 2000 19:31:41 +0200643_x-user-defined Hi, The code 00C9007F says that the compression dictionary is invalid. Try to remove the KEEPDICTIONARY and run again to force it to be built anew.
Isaac Yassin
"Johnson, Bill" wrote: > > We are trying to run online reorg for some of our tablespaces that require > 24 X 7 availability. The reorg statement is as follows: > > REORG TABLESPACE PEDPRSN.PES110 > SHRLEVEL CHANGE > COPYDDN(SYSCOPY1,SYSCOPY2) > MAPPINGTABLE DB2PROD.MAP_PES110 > MAXRO 30 DELAY 1200 LONGLOG DRAIN > SORTDEVT DISK SORTNUM 4 > KEEPDICTIONARY SORTDATA LOG NO > STATISTICS TABLE(ALL) SAMPLE 10 INDEX(ALL) UPDATE(ALL) > > We've tried it [...]
8969 80 22_Re: Online Reorg in V60_19_Tim.Lowe@STPAUL.COM31_Mon, 11 Sep 2000 11:36:30 -0500719_us-ascii Bill, Have you tried running a REORG UNLOAD EXTERNAL to see if you can read all of the data with your current compression dictionary?
Thanks, Tim
"Johnson, Bill" on 09/11/2000 10:27:58 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: Online Reorg in V6
We are trying to run online reorg for some of our tablespaces that require 24 X 7 availability. The reorg statement is as follows: [...]
9050 77 22_Re: Online Reorg in V613_Johnson, Bill18_bjo23@ALLSTATE.COM31_Mon, 11 Sep 2000 11:43:09 -0500589_- Thanks Isaac, but we have tried it both ways, with KEEPDICTIONARY and without. Still abended both times for the same reason.
Bill Johnson DBA Allstate Insurance Co.
> -----Original Message----- > From: Isaac Yassin [SMTP:yassin@NETVISION.NET.IL] > Sent: Monday, September 11, 2000 1:32 PM > To: DB2-L@RYCI.COM > Subject: Re: Online Reorg in V6 > > Hi, > The code 00C9007F says that the compression dictionary is invalid. Try to > remove the KEEPDICTIONARY > and run again to force it to be built anew. > > Isaac Yassin > > "Johnson, Bill" wrote: > > > > We are trying [...]
9128 80 22_Re: Online Reorg in V619_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 11 Sep 2000 11:51:26 -0500610_iso-8859-1 Hi Bill, What is status of tablespace when you do a -DISPLAY? Error text below for 00C9007F:
Explanation: The compression dictionary for the table space or partition is invalid. Therefore, the table space or partition cannot be opened. This abend reason code is issued by the following CSECT: DSNZLDR
System Action: The table space or partition is implicitly stopped by DB2. Messages DSNT501I and DSNI004I are displayed to inform the operator that the dictionary and the object for which the dictionary is defined are unavailable. An SQLCODE -904 is returned to the SQL end user. [...]
9209 111 22_Re: Online Reorg in V613_Aaron Conklin19_Conklina@MEIJER.COM31_Mon, 11 Sep 2000 12:49:29 -0400434_US-ASCII Try removing the keyword STATISTICS. This is a known problem (with the LOAD as well).
See PTF PQ39093.
Thanks,
Aaron Conklin Data Architecture conklina@meijer.com 616/735-7995
>>> bjo23@ALLSTATE.COM 09/11/00 12:43PM >>> Thanks Isaac, but we have tried it both ways, with KEEPDICTIONARY and without. Still abended both times for the same reason.
Bill Johnson DBA Allstate Insurance Co. [...]
9321 112 22_Re: Online Reorg in V611_Shigang Mai16_smai@METLIFE.COM31_Mon, 11 Sep 2000 13:02:30 -0400456_us-ascii Bill, Rick got the point. The tablespace may not be accessible before reorg. was run. Try recover first and must sure that the tablespace is accessible. Then run the reorg again.
Sam
"DAVIS, RICK (SBCSI)" @RYCI.COM> on 09/11/2000 12:51:26 PM
Please respond to "DB2 Data Base Discussion List"
Sent by: "DB2 Data Base Discussion List" [...]
9434 118 22_Re: Online Reorg in V613_Johnson, Bill18_bjo23@ALLSTATE.COM31_Mon, 11 Sep 2000 12:56:04 -0500628_- Thanks Aaron, you were right. Removing the statistics option corrected the problem. Also thanks to everyone else who replied. Bill Johnson Allstate Insurance Co. PS. For Rick Davis---> the display command indicated a status of RW,UTUT after the abend.
> -----Original Message----- > From: Aaron Conklin [SMTP:Conklina@MEIJER.COM] > Sent: Monday, September 11, 2000 12:49 PM > To: DB2-L@RYCI.COM > Subject: Re: Online Reorg in V6 > > Try removing the keyword STATISTICS. This is a known problem (with the > LOAD as well). > > See PTF PQ39093. > > Thanks, > > Aaron Conklin > Data Architecture > conklina@meijer.com [...]
9553 75 71_Re: restoring UDB instance/database from one server to different server17_Hipenbecker, Doug25_Hipenbecker.Doug@MBCO.COM31_Mon, 11 Sep 2000 13:46:30 -0500379_iso-8859-1 Aaah...
The answer I was looking for...
Please correct my summarization if incorrect for RESTORE to another server: 1) You must have same directory structure as source server 2) If not same directory structure, you must use REDIRECT
Thanks for all of the great help!!!!!!
I find DB2MOVE the most useful for this and easiest to use.... [...]
9629 114 71_Re: restoring UDB instance/database from one server to different server18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Mon, 11 Sep 2000 14:49:48 -0400537_- DB2MOVE is actually more work. If you use the restore command, you do it with a few instructions with multiple redirect statements. Note that all commands must reference the source database except the into parm. Even the continue statement references the source database name.
Here is an example:
restore db dvost003 from /u04/db2/udbt/backup/dvost003 taken at 20000630075732 to /u03/db2/udbt/database/dvosq002 into dvosq002 newlogpath /u04/db2/udbt/dblog/dvosq002 replace existing redirect without rolling forward; [...]
9744 21 71_Re: restoring UDB instance/database from one server to different server13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Mon, 11 Sep 2000 13:35:59 -0500338_- The problem with DB2Move is that it doesn't restore foreign keys, etc.
We have a java program that creates ALL of the tables we use and then use DB2Move Load to fill them up (with constraint checking turned off).
I think that you may need to fiddle with a DB2Look script if you wish to clone a database with db2move. [...]
9766 43 56_Quest Central for DB2 UNIX/NT Now Available for Download13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Mon, 11 Sep 2000 14:04:23 -0500424_ISO-8859-1 Quest Software would like to announce that a beta version of Quest Central for DB2 is now available from our website http://WWW.QUEST.COM/DB2.
Quest Central™ for DB2 provides today's DBA with an integrated suite of powerful and comprehensive database management tools. Each of the 4 components offers distinct functionality that focuses on critical aspects of DB2 UDB database management for UNIX/NT. [...]
9810 33 21_Segmented Tablespaces19_Murari Selvakesavan22_MSelvakesavan@FHSC.COM31_Mon, 11 Sep 2000 15:21:58 -0400462_US-ASCII Hi all,
We have our strategies set forth in our shop to create all medium sized tables in Segmented Tablespaces and one table per tablespace. In order to select the value for SEGSIZE parameter we are using the general recommendations set by IBM based on Number of Table pages. Are there any design considerations that we have to consider before we pick up a value for SEGSIZE. As a rule of thumb it was recommended to use SEGSIZE as follows [...]
9844 17 60_Re: Quest Central for DB2 UNIX/NT Now Available for Download13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Mon, 11 Sep 2000 14:15:02 -0500471_- Does it offer a decent interface to control Replication?
I.e., select a large group of tables, drag them to the target then fill out a small dialogue with the replication details to apply to all these tables.
-HJC
================================================ 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.
9862 55 25_Re: Segmented Tablespaces24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Mon, 11 Sep 2000 12:42:26 -0700316_- Our implementation is a bit simpler. If the expected data volume exceeds 30 pages, then we use SEGSIZE 64. If the expected data volume is greater than 0, but less than 30 pages, we use SEGSIZE 32. If the expected data volume is 0, then we lump all of the tables into a single tablespace and set SEGSIZE to 4. [...]
9918 46 31_Deadlock Contention of SYSUTILX17_Bruzdzinski, Mike24_MIKE.BRUZDZINSKI@SSA.GOV31_Mon, 11 Sep 2000 15:18:05 -0400406_iso-8859-1 We recently experienced a REORG utility job that caused other utilities to abend due to exclusive use of SYSUTILX.
The REORG was running against a partitioned tablespace (100 partitions, defined as LARGE). IT appears that lock escalation occurred against SYSUTILX and the other utility jobs waited or abended.
What we would like to know is just what gets written to SYSUTILX? [...]
9965 56 42_Re: DB2 OS/390 Replication Data Propagator11_Road Runner22_hhardy1@HOUSTON.RR.COM31_Mon, 11 Sep 2000 14:50:14 -0500915_iso-8859-1 RC/Migrator & RC/Extract via CA.......... http://www.cai.com/products/db2/rcmigrator/overview.htm
> >>For anyone interested in the BMC data propagation solution that Rich >>mentioned below >>check out http://www.bmc.com/products/edp/ >> >>The BMC solutions for data propagation include DataMove for data >propagation >>via extraction and ChangeDataMove for data propagation via log capture. >> >>Cheers, >>Craig S. Mullins >>Director, DB2 Technology Planning >>BMC Software >>http://www.bmc.com >>Craig_Mullins@bmc.com >>http://www.craigsmullins.com >>cmullins@compuserve.com >> >> >>>---------------------------------------------------------------------- >>> >>>Date: Sun, 10 Sep 2000 11:49:04 GMT >>>From: rick creech >>>Subject: Re: DB2 OS/390 Replication Data Propagator >>> >>>Not so. We use it for a lot of different scenarios on os/390 in both >>>data-sharing and [...]
10022 124 70_Re: restoring UDB instance/database from one server to differentserver13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Mon, 11 Sep 2000 15:00:48 -0500637_us-ascii If you have a large number of redirects (we have over 300), use an imput file for the redirects. Then it only has to be created once.
Helen
"Krawetzky, Peter J" wrote:
> DB2MOVE is actually more work. If you use the restore command, you do it > with a few instructions with multiple redirect statements. Note that all > commands must reference the source database except the into parm. Even the > continue statement references the source database name. > > Here is an example: > > restore db dvost003 from /u04/db2/udbt/backup/dvost003 taken at > 20000630075732 to /u03/db2/udbt/database/dvosq002 into [...]
10147 28 10_Re: EEDIQI14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Mon, 11 Sep 2000 16:14:02 -0400497_iso-8859-1 John (and everybody else),
Your posting was "infected". See message below:
Sender of the infected attachment: John Lawniczak Subject of the message: EEDIQI One or more attachments were deleted. Attachment LESEUER.GIF.vbs was Deleted for the following reasons: Virus VBS.LoveLetter.Variant was found.
-----Original Message----- From: John Lawniczak [mailto:jlawniczak@RTSWIRELESS.COM] Sent: Monday, September 11, 2000 4:03 PM To: DB2-L@RYCI.COM Subject: EEDIQI [...]
10176 63 51_FW: [DB2-L] EEDIQI - VIRUS DETECTED in mail for you22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 11 Sep 2000 16:14:26 -0400859_iso-8859-1 Our email system detected a virus named LESEUER.GIF.vbs.
Please see below for details.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Email.Firewall@apsn15.ukap.astrazeneca.net [mailto:Email.Firewall@apsn15.ukap.astrazeneca.net] Sent: Monday, September 11, 2000 16:05 To: Piontkowski Michael ML Subject: VIRUS DETECTED in mail for you
Subject:VIRUS DETECTED IN MAIL FOR YOU
AUTOMATIC WARNING.....AUTOMATIC WARNING.....AUTOMATIC WARNING
A message addressed to you containing a computer virus has been delivered to the AstraZeneca mail system. This virus could cause damage to your PC or the data on it. To prevent this the whole message has been isolated by the mail system and not delivered to you. [...]
10240 49 10_Re: EEDIQI14_Richard Yevich17_ryevich@YAHOO.COM31_Mon, 11 Sep 2000 13:19:15 -0700453_us-ascii
To LIST and JOHN,
THIS IS A VBS. FILE. What is it and why are you posting it to the list?
TO ALL SUBSCRIBERS -- DO NOT OPEN!!!!!!!!!!
Richard Yevich
John Lawniczak wrote:
IUXUQIWIGU > ATTACHMENT part 2 application/octet-stream name=LESEUER.GIF.vbs
Regards, Richard +====+ ryevich@attglobal.net
--------------------------------- Do You Yahoo!?
10290 42 48_Re: EEDIQI -- THIS IS A VIRUS - DELETE R. Yevich14_Richard Yevich17_ryevich@YAHOO.COM31_Mon, 11 Sep 2000 13:20:37 -0700390_us-ascii
THIS IS A VIRUS!!!!!!!!!!!! IT HAS BEEN SCANNED AND DETECTED!!!
DO NOT OPEN!!!!!!!!!!!!!!!!!!!!!!!!
John Lawniczak wrote:
IUXUQIWIGU > ATTACHMENT part 2 application/octet-stream name=LESEUER.GIF.vbs
Regards, Richard +====+ ryevich@attglobal.net
--------------------------------- Do You Yahoo!?
10333 68 42_Virus posted by your company on a listserv14_Richard Yevich17_ryevich@YAHOO.COM31_Mon, 11 Sep 2000 13:31:09 -0700650_us-ascii
TO:
RTS Wireless, Headquarters 51 East Bethpage Road Suite 200 Plainview, New York 11803 Telephone: 516-939-6655 Facsimile: 516-939-6189
RTS Wireless International Cedar House Breckland, Linford Wood Milton Keynes, Bucks MK14 6EX United Kingdom Telephone: +44 (0) 1908 800 300 Facsimile: +44 (0) 1908 800 333
John Lawniczak, from @rtswireless.com has posted the Love Letter Virus, on a listserve that feeds corporate America, DB2-L. There are over 3,000 large corporations international that use this listsreve on-line, and another several thousand that get its mail in digest form. [...]
10402 369 17_Re: ODBC to OS39016_Bruce Williamson25_Bruce.Williamson@MAIL.COM31_Tue, 12 Sep 2000 06:34:43 +1000428_iso-8859-1 Howzit Folks?
I haven't worked with ODBC, but if I was to hazard a guess based on what has already been said, it has to do with 2 phase commit logic. Let's assume that there had already been INSERT/UPDATE/DELETE activity on the client or indeed in another database system, then doing a commit during the BIND/REBIND/MINI-BIND would prevent a ROLLBACK of the UOW for data already INSERTed/UPDATEd/DELETEd. [...]
10772 63 39_CRITICAL: The Love Letter Virus Variant14_Richard Yevich17_ryevich@YAHOO.COM31_Mon, 11 Sep 2000 13:51:09 -0700371_us-ascii
All,
I have spoken to RTSWIRELESS and their company was infected by the virus about 1 hour prior to DB2-L. However, to post to our site, they needed to be an approved person. It "appears" that an employee at RTSWIRELESS is a valid subscriber, and the way the virus works -- it gets sent to every email id in the Outlook contact list. [...]
10836 55 28_Fw: Event Analyzer / DB2 UDB11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Mon, 11 Sep 2000 16:48:11 -0400316_us-ascii The Event Analyzer and db2evmon will help you examine individual event records. 1,000's of records can be generated in only a few moments time in active transactional databases, and the task of analyzing all this data can be quite a challenge, especially if you are looking for problem SQL statements. [...]
10892 39 29_JOHN or PHIL: Shut down DB2-L14_Richard Yevich17_ryevich@YAHOO.COM31_Mon, 11 Sep 2000 14:05:05 -0700292_us-ascii
John - Phil --> LOCK DOWN THE SERVER AND PREVENT THE DIGESTS FROM GOING OUT TONIGHT. CANNOT REACH YOU ON PHONE!!!!!!!!
R Yevich
Regards, Richard +====+ ryevich@attglobal.net
--------------------------------- Do You Yahoo!?
10932 15 9_Test Post9_Tom Mertz18_tmertz@VASTNET.NET29_Mon, 11 Sep 2000 08:46:14 GMT393_- Sorry, this is just a test.
--------------------------------------------- This message was sent using Vastnet WebMail. http://www.vastnet.net/
================================================ 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.
10948 111 27_Re: OO Data modelling Tools13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Mon, 11 Sep 2000 16:14:25 -0500614_iso-8859-1 About a year ago there was a "face off" artice in IDUG Solutions journal that addressed this issue (DB2 and OO). Even though it's about a year old, I would still recommend taking a gander at it (http://www.idug.org/member/journal/aug99/faceoff.html). My experience has been that when people start heading down the OO path, they try to jump in with both feet and think only in terms of OO. I generally see people forget all about relational design, performance, and (most importantly) common sense. I have seen a push to use the object model to drive table design, building tables directly from the [...]
11060 27 29_FW: Accessing B@ from the web12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Mon, 11 Sep 2000 19:15:40 -0400697_iso-8859-1 You may find this link helpful: www.software.ibm.com/data/net.data
-----Original Message----- From: MAHSOUN, KHALID [mailto:kmahsoun@SAUDIAIRLINES.COM.SA] Sent: Monday, September 11, 2000 1:30 AM To: DB2-L@RYCI.COM Subject: Accessing B@ from the web
hi is there any documentation regarding the authorization process of access DB2 OS/390 through the web .
================================================ 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.
11088 320 14_Re: DFDSS move14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Mon, 11 Sep 2000 18:29:18 -0500373_iso-8859-1 DFDSS will dump only the used space ( the default if you do not use keywords ALLDATA or ALLEXCP) , instead of all allocated space, in sequential or partitioned data sets or in data sets with a null DSORG field. For VSAM key sequenced ( KSDS ) data sets, the VALIDATE keyword ( which is the default ) dumps only the used data instead of all allocated space. [...]
11409 61 48_Re: Rebind parms abbreviations changed in V6.1!!14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 12 Sep 2000 10:42:50 +1100456_iso-8859-1 Richard,
DB2 _V5_ Command Reference Sect 2.5.1 Abbreviations "The names of the DSN command and its subcommands cannot be abbreviated. For compatibility with prior releases of DB2, abbreviations for some keywords are allowed. However, to avoid potential problems, it is recommended that keywords never be abbreviated."
What happened is that V6 BIND and REBIND have an OPTHINT option, so 'O' is no longer a unique abbreviation. [...]
11471 29 5_Virus14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Mon, 11 Sep 2000 19:01:57 -0400625_iso-8859-1 All,
As you are aware, a severe Virus was posted as an attachment, to DB2-L, BY ACCIDENT (as a product of the Virus email broadcast).
It was removed from the archives and from the digests, so only the real-time subscribers were potentially affected. Most caught the virus with Virus Detection software.
At this time, John, Janis, Phil (the list serve masters) are working with RYC to try and put in place a method to delete all attachments from postings. Since the server does not "read" mail, but simply stores & forwards, virus detection of singular attachments is not possible. Please [...]
11501 68 37_Links about DB2 for OS/390 (09/12/00)6_DB2usa18_db2usa@HOTMAIL.COM31_Tue, 12 Sep 2000 02:15:38 -0500849_ISO-8859-1 Hi,
Here is a non-profit website about DB2 for OS/390 (IBM mainframes):
- English : http://db2usa.hypermart.net/eliendb2.htm - Français: http://db2usa.hypermart.net/liendb2.htm
Last update on Tuesday, September 12th 2000 ===========================================
- Links about DB2 for OS/390: http://db2usa.hypermart.net/eliste.htm IBM changed the policy. Now, you need to register to read redbooks online.
DB2 Today, IBM's DB2 newsletter: August 2000.
- Technical papers: http://db2usa.hypermart.net/earticle.htm Craig Mullins' articles published in TDAN are available on line: - Using constraints to simulate domains by Craig Mullins, TDAN, December 1998. - What's in a name ? by Craig Mullins, TDAN, March 1998. - Denormalization guidelines by Craig Mullins, TDAN, June [...]
11570 304 49_Re: ODBC to OS390 (Dynamic SQL and Catalog locks)11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Tue, 12 Sep 2000 08:49:12 -0400406_iso-8859-1 I had researched this issue at a previous site where lots of dynamic SQL was running. We noticed that if we could get to the code (an example was DSNTIAUL) we could use CURSOR with HOLD and then do a commit. This freed the catalog locks. The problem was/is that we cannot get to the code on most of these dynamic programs (vendor packages). Also CURSOR with HOLD is not always appropriate. [...]
11875 159 27_Re: OO Data modelling Tools19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 12 Sep 2000 08:12:42 -0500578_iso-8859-1 Mike, I mostly agree with your comments and would like to add the following: Encapsulating data with an Object is where I see the main problem to be tackled. Encapsulating data with an Object is just another way of saying Application ownership of data, which in my opinion, is what led to the redundant, out of sync data, and poor performance of the past. Fixing these problems was why relational techniques and databases were deployed. Data isn't owned by an Object or Application, it is a corporate asset that must be shared by all and organized in a way that [...]
12035 26 33_DB2 ARCHIVE COMMAND NOT ISSUED ??14_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 12 Sep 2000 10:07:46 -0400528_- Hi,
I have a started task that issues -ARCHIVE LOG command. The started task starts and ends but I never see:
DSNJ310I + SYNCHRONOUS ARCHIVE LOG COMMAND QUIESCE PROCESSING STARTING FOR MAXIMUM OF 300 SECONDS
hit the console. I also checked the MSTR and I don't see it in the JESLOG ?? So the archive never took place. Is it possible that the command proccessor was busy and the command was flushed ? Or could there have been other DB2 activity that caused the -ARCHIVE command not to be processed ?? [...]
12062 257 42_IBM Invests $200 Million in Database Tools14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 12 Sep 2000 07:13:41 -0700461_us-ascii Tuesday, September 12, 2000 08:17 AM CDT
SOMERS, N.Y., Sep 12, 2000 (BUSINESS WIRE) --
Helps Companies Attack the Cost of Computing With Functionally Rich Tools at Industry Leading Price Points
IBM today announced it will invest $200 million to compete in the database tools market. The four-year investment is aimed at making it more cost effective and easier for companies to manage data on IBM S/390(a) enterprise servers. [...]
12320 55 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 12 Sep 2000 09:29:18 -0500626_iso-8859-1 Hi Dean, Could you have a permissions problem? Check SYSLOG. HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
12376 73 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??14_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 12 Sep 2000 10:35:06 -0400589_- No. The command runs everyday fine, just this one time so far, the command wasn't issued ???
> -----Original Message----- > From: DAVIS, RICK (SBCSI) [SMTP:RD8246@MOMAIL.SBC.COM] > Sent: Tuesday, September 12, 2000 10:29 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 ARCHIVE COMMAND NOT ISSUED ?? > Sensitivity: Personal > > Hi Dean, > Could you have a permissions problem? Check SYSLOG. > HTH, > Rick Davis > > "This e-mail and any files transmitted with it are the property of SBC, > are confidential, and are intended solely for the use of the individual > or entity to whom [...]
12450 100 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 12 Sep 2000 09:39:53 -0500628_iso-8859-1 Was the target DB2 subsystem up at the time the command was issued?
Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
12551 58 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 12 Sep 2000 10:40:29 -0400424_iso-8859-1 Make sure your started task is working properly. Have you tried non-DB2 commands with this started task? Is the userid associated with the started task authorized to issue to DB2 commands to the target DB2 subsystem? Are you using the correct subsystem command prefix?
I believe there is an IFCID associated with the archive logging. Trace it and verify that DB2 is receiving the archive log command. [...]
12610 119 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??14_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 12 Sep 2000 10:42:03 -0400593_iso-8859-1 yes
> -----Original Message----- > From: DAVIS, RICK (SBCSI) [SMTP:RD8246@MOMAIL.SBC.COM] > Sent: Tuesday, September 12, 2000 10:40 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 ARCHIVE COMMAND NOT ISSUED ?? > Sensitivity: Personal > > Was the target DB2 subsystem up at the time the command was issued? > > Rick Davis > "This e-mail and any files transmitted with it are the property of SBC, > are confidential, and are intended solely for the use of the individual > or entity to whom this e-mail is addressed. If you are not one of the > named recipient(s) or otherwise [...]
12730 77 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??14_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 12 Sep 2000 10:43:43 -0400630_- yes the command has been working properly for a couple of weeks. I see the started task begin and end but nothing inbetween. Please explain the IFCID part of your response.
> -----Original Message----- > From: Piontkowski Michael ML [SMTP:michael.piontkowski@ASTRAZENECA.COM] > Sent: Tuesday, September 12, 2000 10:40 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 ARCHIVE COMMAND NOT ISSUED ?? > Sensitivity: Personal > > Make sure your started task is working properly. > Have you tried non-DB2 commands with this started > task? Is the userid associated with the started task > authorized to issue to DB2 commands to [...]
12808 70 35_Re: Deadlock Contention of SYSUTILX20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 12 Sep 2000 10:57:38 -0400469_us-ascii Mike
My guess is that all the utilities write their checkpoint data into SYSUTILX. I have seen this situation of lock escalation on SYSUTILX many times. One example -
We were running MODIFY utility on a tablespace, which had very few imagecopies but a huge SYSLGRNX information. The MODIFY utility kept on exceeding the lock limits on the SYSUTILX tablespace. This made me feel that every check point information is written in the SYSUTILX. [...]
12879 301 38_Calling DB2 Stored Procedures from SAS9_Ed LaTouf17_elatouf@YAHOO.COM31_Tue, 12 Sep 2000 08:00:12 -0700386_us-ascii
We are currently using SAS to Connect to DB2 for OS/390 V5 and issuing selects to SAS datasets.
I have been tasked with using DB2 Stored Procedures for our selects and passing back the data to the local PC for processing within SAS.
I wrote a Cobol DB2 stored procedure and called it from another Cobol program passing a parameter with good results. [...]
13181 113 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 12 Sep 2000 11:40:45 -0400430_iso-8859-1 Search SDSNSAMP(DSNWMSGS) for ARCHIVE. IFCID 1 records the total # of ARCHIVE LOG commands issued since DB2 started.
IFCID pair 174/175 records the begin/end of ARCHIVE LOG MODE(QUIESCE) processing.
From DB2 V5.1 SDSNSAMP(DSNWMSGS): IFCID 0174 BEGINS ARCHIVE LOG MODE(QUIESCE) COMMAND PROCESSING. THIS OCCURS IF A BEGIN-UR REQUEST IS SUSPENDED BECAUSE AN ARCHIVE LOG MODE(QUIESCE) COMMAND IS ACTIVE. [...]
13295 81 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 12 Sep 2000 10:00:00 -0400629_- I have seen times where the system was so busy that console records were lost...Doesn't happen often. Did you run DSNJU004 to see if an archive did happen?
>>> DB2-L@RYCI.COM@inter2 09/12/00 09:35AM >>> No. The command runs everyday fine, just this one time so far, the command wasn't issued ???
> -----Original Message----- > From: DAVIS, RICK (SBCSI) [SMTP:RD8246@MOMAIL.SBC.COM] > Sent: Tuesday, September 12, 2000 10:29 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 ARCHIVE COMMAND NOT ISSUED ?? > Sensitivity: Personal > > Hi Dean, > Could you have a permissions problem? Check SYSLOG. > HTH, > Rick Davis [...]
13377 114 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??38_Andersen, Cindy (CC-Database Services)26_Cindy.Andersen@CONAGRA.COM31_Tue, 12 Sep 2000 10:59:13 -0500443_iso-8859-1 If your site has multiple CPUs and/or multiple LPARs, was the command issued on the correct CPU?
One place to verify if the ARCHIVE LOG command worked is to print the BSDS (bootstrap dataset) using DSNJU004 and look at the bottom of the listing where there will be an archive log command history report. This will indicate if the command did or did not execute. Below is an example from one of our DB2 subsystem's BSDS. [...]
13492 106 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??14_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 12 Sep 2000 11:58:39 -0400573_- No, I didn't but I did a 3.4 on the archlog dataset name and I didn't see one for that time period, so I believe one wasn't created. So far, this is the first time I have seen this and yes the system was busy yesterday at this time.
> -----Original Message----- > From: BOB JEANDRON [SMTP:BOB.JEANDRON@USDA.GOV] > Sent: Tuesday, September 12, 2000 10:00 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 ARCHIVE COMMAND NOT ISSUED ?? > Sensitivity: Personal > > I have seen times where the system was so busy that console records were > lost...Doesn't happen often. [...]
13599 106 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 12 Sep 2000 12:02:37 -0400582_iso-8859-1 Duh... I forgot. DSNJU004 is much easier then using IFCIDs.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: BOB JEANDRON [mailto:BOB.JEANDRON@USDA.GOV] Sent: Tuesday, September 12, 2000 10:00 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 ARCHIVE COMMAND NOT ISSUED ?? Sensitivity: Personal
I have seen times where the system was so busy that console records were lost...Doesn't happen often. Did you run DSNJU004 to see if an archive did happen? [...]
13706 17 30_Re: No of rows and Performance12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 12 Sep 2000 10:46:52 -0500448_- I have just a little to add to the other good answers. Then you get to take into account some of the factors like the clusterratio and index lookaside. Getting 100 rows from a page is many times more efficient than separate index lookup for each one with random IO. Of course locking may come in as a significant factor if your loads scale up high enough. If the situation is simple enough or there are other needs, I look at the Estimator. [...]
13724 130 37_Re: DB2 ARCHIVE COMMAND NOT ISSUED ??14_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 12 Sep 2000 12:15:07 -0400699_iso-8859-1 You know what they say, &@#$ happens !
I checked the BSDS, there was no entry for yesterday at 12 noon, when the archive should have run.
> -----Original Message----- > From: Piontkowski Michael ML [SMTP:michael.piontkowski@ASTRAZENECA.COM] > Sent: Tuesday, September 12, 2000 12:03 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 ARCHIVE COMMAND NOT ISSUED ?? > Sensitivity: Personal > > Duh... I forgot. > DSNJU004 is much easier then using IFCIDs. > > > Mike Piontkowski > Voice/Fax: 302.886.4612 > mailto:michael.piontkowski@astrazeneca.com > > > > -----Original Message----- > From: BOB JEANDRON [mailto:BOB.JEANDRON@USDA.GOV] > Sent: Tuesday, September 12, 2000 10:00 [...]
13855 27 29_Updating partition key values19_Michael Robaczewski25_MROBACZEWSKI@CAREMARK.COM31_Tue, 12 Sep 2000 10:53:56 -0500576_- We have recently converted a non-partitoned table to a table now having 32 partitions. One program that accesses this table performs an update of a partitioning key value resulting in the row moving to another partition. This is now a feature in Version 5 of DB2 as a result of APAR PQ16946. To make to move accross partitions the program needs control of the from partition, from partition and all the partition between them. So the wider the range of the move the more partitions need to be in the program's control. This is resulting in other programs attempting to [...]
13883 54 18_Archiving DB2 Data9_Les Hauer18_lhauer@WALLACE.COM31_Tue, 12 Sep 2000 11:21:06 -0500571_iso-8859-1 From searching the archives, I can see this has been asked before, but there has been little discussion so I thought I 'd bring it up again to see what is being done out in the world.
Are you archiving aged DB2 data that may or may not need to be referenced in the future? Did you build in the archive process in as part of system design or add it on after-the-fact? Are you using vendor products (Row Archive Manager from IBM, Archive for DB2 from Princeton Softech, RC/Extract from CA, CDB/PartRoll from CDB Software, FileAid/RDX from BMC, etc.) [...]
13938 37 35_DB2 Tools Announcement this morning12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 12 Sep 2000 11:26:01 -0500498_- The IBM tools announcement was made today, so if you would like to see the improvements, the announcements are on the web. The tools web page is also updated. ibm.com/software/data/db2imstools/
Roger Miller, DB2 for OS/390
_ 200307 IBM's Strengthened Focus On Database Tools (11.7KB) http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=200-307
_ 200298 IBM Tools for Database Performance Management (39.4KB) http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=200-298 [...]
13976 118 34_Re: DB2 Connect to DB2 OS/390 V5.110_Robert Ord21_robertord@HOTMAIL.COM29_Tue, 12 Sep 2000 16:47:11 GMT726_- Thanks for the pointers. It gives the VB bods something to check as well.
Cheers
Rob
>From: "Mackey, Glenn" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: DB2 Connect to DB2 OS/390 V5.1 >Date: Wed, 6 Sep 2000 13:26:16 -0500 > >Hi, >Over time I have had similar unexplained and non-reproducible problems. >This >group gave some good points which you can investigate. Bottom line: seems >that these are very hard to solve problems. > >Visit the archives http://jupiter.ryci.com/archives/db2-l.html and search >against the SUBJECT "Help needed with problem" > >hth >Glenn > >-----Original Message----- >From: Knight, Robert [...]
14095 28 43_Question about Remote Restore on DB/UDB 6.10_20_John_Lendman@FPL.COM31_Tue, 12 Sep 2000 13:10:21 -0400501_us-ascii I am trying to restore a copy of our production DB named WHSPRO to a DR server with the same named DB. I copied the backup copy down to the DR server and I am running control center from that server. When I copied the backup file down I create a folder on NT with the name of the day of the backup (200000911) and the file name is 230000.001. This is also what I put in the restore mannual part of the restore screen. I also pointed the directory to the place where I copied the backup. [...]
14124 66 47_Re: Question about Remote Restore on DB/UDB 6.10_22_rmadan@CYVEILLANCE.COM31_Tue, 12 Sep 2000 13:19:17 -0400433_iso-8859-1 You have one extra 0 in your directory name "backup (200000911)". Db2 uses the directory name in the date portion of your restore command. It should be "20000911"...See if that helps.
Rakesh Madan Senior Database Administrator http://www.cyveillance.com "Minding your business on the Net"
For additional information or to attend a FREE Executive Cyber Seminar, visit http://www.cyveillance.com. [...]
14191 107 47_Re: Question about Remote Restore on DB/UDB 6.113_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 12 Sep 2000 12:22:18 -0500550_US-ASCII John, Did you create the BACKUP directory structure in CAPS. The directory structure is case sensitive. HTH Kurt
>>> John_Lendman@FPL.COM 09/12/00 12:10PM >>> I am trying to restore a copy of our production DB named WHSPRO to a DR server with the same named DB. I copied the backup copy down to the DR server and I am running control center from that server. When I copied the backup file down I create a folder on NT with the name of the day of the backup (200000911) and the file name is 230000.001. This is also what I put in [...]
14299 78 47_Re: Question about Remote Restore on DB/UDB 6.10_20_John_Lendman@FPL.COM31_Tue, 12 Sep 2000 13:28:03 -0400502_iso-8859-1 Yes, the backup directory is WPRODBKUP, the directory where I put the backup is 20000911 and the file name is 230000.001
John
"Kurt Sahlberg" @RYCI.COM> on 09/12/2000 01:22:18 PM
Please respond to "DB2 Data Base Discussion List"
Sent by: "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM cc:
Subject: Re: Question about Remote Restore on DB/UDB 6.1 [...]
14378 90 47_Re: Question about Remote Restore on DB/UDB 6.10_20_John_Lendman@FPL.COM31_Tue, 12 Sep 2000 13:28:54 -0400608_us-ascii I only have four 0000 on the real one, I mistype the note. John
rmadan@CYVEILLANCE.COM@RYCI.COM> on 09/12/2000 01:19:17 PM
Please respond to "DB2 Data Base Discussion List"
Sent by: "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM cc:
Subject: Re: Question about Remote Restore on DB/UDB 6.1
You have one extra 0 in your directory name "backup (200000911)". Db2 uses the directory name in the date portion of your restore command. It should be "20000911"...See if that helps. [...]
14469 36 24_Max Size OF VSAM Dataset11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Tue, 12 Sep 2000 12:25:17 -0500356_iso-8859-1 Hi, I want to create a Tablespace with 4GB Dataset which DB2 Supports but when I go to create, it fails saying not enough space on the Volume which has around 3000 cyliders. 1. Is that there are new volumes which have more than 3000 Cylinders ?
2. The newer version of VSAM supports a single dataset of 4GB spanning across volumes ? [...]
14506 54 28_Re: Max Size OF VSAM Dataset14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Tue, 12 Sep 2000 12:39:10 -0500449_iso-8859-1 the 4GB limit does not mean you can necessarily put it in one extent. 3390-9 volumes have around 9000 cylinders, but you can still use models that contain less. Give it a smaller Primary quantity and let it go into extent processing.
-----Original Message----- From: Sinha, Amit [mailto:Sinha.Amit@MBCO.COM] Sent: Tuesday, September 12, 2000 12:25 PM To: DB2-L@RYCI.COM Subject: Max Size OF VSAM Dataset Sensitivity: Personal [...]
14561 59 28_Re: Max Size OF VSAM Dataset14_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 12 Sep 2000 13:45:20 -0400485_- VSAM extended KSDS support files larger than 4GB. The max now is 128TB (32K CI size * 4GB), a 4K CI would yield 16TB. I think a 4K CI is a preference by apps folks for performance. These files must be SMS managed. VSAM extended addressibility came about in DFSMS 1.4. They can be shared with systems running 1.3 but not lower. There is toleration maintenance that has to be applied if you have systems prior to release 1.3. DFSMS 1.5 supports extended VSAM files for all types. [...]
14621 22 48_NEW BOOK: DB2 High Performance Design and Tuning14_Philip Gunning18_pgunning@PHEAA.ORG31_Tue, 12 Sep 2000 13:57:39 -0400394_us-ascii FYI. This book is available in bookstores (brick and mortar) and online. I have reviewed it and highly recommend it. Phil
Phil Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA V6.1 IBM Certified Solutions Expert -- Database Adminstration V6.1 IBM Certified Solutions Expert -- Application Development V6.1 Assoc List Owner DB2-L pkg3@psu.edu [...]
14644 59 37_REMINDER: IDUG CALL FOR PRESENTATIONS14_Philip Gunning18_pgunning@PHEAA.ORG31_Tue, 12 Sep 2000 14:02:44 -0400659_us-ascii These were due in last week but if you have a presentation and are still interested, we are still accepting presentations. Just follow the instructions below. Thanks, Phil
CALL FOR PRESENTATIONS
IDUG 13th Annual North American Conference Orlando, Florida May 13, 2001 - May 17, 2001
Do you have a success story, experience, or tips and techniques related to the DB2 product family that you would like to share with the DB2 user community? Selected speakers will attend IDUG North America 2001 for free. Submit an abstract to be considered for IDUG's 2001 North American Conference technical program. [...]
14704 32 10_EDU Crash?31_Jackson Reavill/Tampa/Contr/IBM18_damcon2@US.IBM.COM31_Tue, 12 Sep 2000 15:20:16 -0400285_us-ascii Hi all,
I'm hoping someone can enlighten me as to what an EDU crash is, what causes it, and what can be done to avoid it? It appears that it has to do with engine processes, but I can't seem to find any documentation on it. My environment is DB2 UDB V6.1 for AIX. [...]
14737 131 74_Repost: "DB2 Integrators: Beyond The Mainframe" (Sm@rt Partner, 0 8/16/00)13_Morrill, John12_JohnM@VP.NET31_Tue, 12 Sep 2000 14:00:07 -0600393_- Dear DB2 Interested Parties,
I thought you might be interested in this article about the increasingly attractive market for DB2 experts.
(Thanks to Scott Hayes for his pro-DB2 remarks. You can find Scott and Database-GUYS at http://www.database-guys.com/ )
Regards, Mike + + + + + + +
DB2 Integrators: Beyond The Mainframe Sm@rt Partner By Fred Aun 08/16/00 [...]
14869 93 99_Repost: Webcast (9/14/00): "Strategies and Alternatives for Manag ing ISV Costs for S/390 Software"13_Morrill, John12_JohnM@VP.NET31_Tue, 12 Sep 2000 14:01:00 -0600684_- Dear DB2 Interested Parties,
Below is a bulletin about a S/390 software "Webcast" scheduled for this Thursday, September 14. This is the first in a series of five Webcasts focusing on S/390 enterprise tools covering systems, data and application management.
Join Carl Greiner, Vice President and Director of Meta Group's Enterprise Data Center Services, along with IBM and Tivoli executives to learn about: o S/390 software trends o related Independent Software Vendor (ISV) software costs o management strategies that can help you in controlling your software costs o recent product announcements for the data management, application development and the systems [...]
14963 39 40_Online Reorg Dynamic SortWork Allocation13_Lockwood Lyon19_Lockwool@MEIJER.COM31_Tue, 12 Sep 2000 16:33:50 -0400494_US-ASCII Dear List:
We had a weird situation recently where we ran an on-line Reorg with the SORTDEVT and SORTNUM parms. We intended for the utility to estimate the sortwork dataset size requirements and pass these to DFSORT; however, the results were odd. In this particular case the messages we got indicated that DSNUTILB asked for some datasets having a "secondary" (nor primary!) allocation of over 40,000 blocks. This seems a little Big, especially for secondary allocations. [...]
15003 44 52_Re: NEW BOOK: DB2 High Performance Design and Tuning14_Scott Saunders20_ssaunders@SIEBEL.COM31_Tue, 12 Sep 2000 13:34:37 -0700535_iso-8859-1 Philip; Is it UDB or mainframe oriented?
Scott Saunders Senior Architecture Specialist, Expert Services IBM DB2 UDB Certified Database Administrator SIEBEL SYSTEMS
-----Original Message----- From: Philip Gunning [mailto:pgunning@PHEAA.ORG] Sent: Tuesday, September 12, 2000 10:58 AM To: DB2-L@RYCI.COM Subject: NEW BOOK: DB2 High Performance Design and Tuning
FYI. This book is available in bookstores (brick and mortar) and online. I have reviewed it and highly recommend it. Phil [...]
15048 70 52_Re: NEW BOOK: DB2 High Performance Design and Tuning12_Susan Lawson22_lawson_susan@YAHOO.COM31_Tue, 12 Sep 2000 13:50:43 -0700649_us-ascii Scott, It is primarily OS/390. Regards, Susan Lawson www.ylassoc.com --- Scott Saunders wrote: > Philip; > Is it UDB or mainframe oriented? > > Scott Saunders > Senior Architecture Specialist, Expert Services > IBM DB2 UDB Certified Database Administrator > SIEBEL SYSTEMS > > > -----Original Message----- > From: Philip Gunning [mailto:pgunning@PHEAA.ORG] > Sent: Tuesday, September 12, 2000 10:58 AM > To: DB2-L@RYCI.COM > Subject: NEW BOOK: DB2 High Performance Design and > Tuning > > > FYI. This book is available in bookstores (brick > and mortar) and online. > I have reviewed it and highly recommend it. [...]
15119 35 27_A question about CA-Insight13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Tue, 12 Sep 2000 15:52:51 -0500592_- Would anyone please help me in calculating bufferpool hit ratio from the data displayed by CA-Insight. Here it is ( I've cut off the last column as I couldn't fit it in one line ):
1 Exception Counters 2 Thresholds 3 Read/Write 4 Workfiles
R/BUFRDWRS BP Read/Write Activity - Accum Accum BUFFER POOL BP0 READ I/O WRITE I/O PREFETCH Reqsts Pages Open Datasets 591 Buffer Updates 585332 Seq 70319 2079K Migrated DS Opnd 0 Pages Written 107166 List 42868 1175K Getpage Requests 6796K Buffer Upd Eff 5.5 Dynamic 21063 164K Seq Accs Getpgs 2535K Asynch Wrt I/O 15890 % Getpgs [...]
15155 30 33_Re: Updating partition key values12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Wed, 13 Sep 2000 10:49:32 +1300570_us-ascii Michael,
I'm sorry to say you're not alone in this. We - fortunately - only had one program that needed to update partitioning keys. It was for a conversion process we were going through at the time. It would run for between 5 and 20 minutes before AbEnding, the code of which I can't remember. Something obscure. Odd thing is that it worked fine in Development. Ain't that always the way? Anyway, in the end we had to convert it to do the delete/reinsert thing. It processed the rows about 7 times slower, but it worked. There are fixes available, [...]
15186 58 33_Re: Updating partition key values11_Suresh Sane21_data_arch@HOTMAIL.COM29_Tue, 12 Sep 2000 17:11:06 CDT368_- If I recall correctly, there are 3 options in V6 to control via zparms this update - (1) do not allow (2) allow within the same partition or (3) allow across partitions. It is #3 that locks all partitions in between. My plan is to go with #2 initially. Hopefully, we will not run into any vendor packages that require #3. Will deal with that if/when I have to. [...]
15245 68 33_Re: Updating partition key values14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 12 Sep 2000 15:17:47 -0700344_us-ascii You should convert to the INSERT/DELETE. The UPDATE is working as it must to insure integrity. The general purpose of that feature is to allow applications to go to partitioning, that were not coded for it. This is what you have done. But if the feature is causing problems, then you need to fix the updater to an insert/deleter. [...]
15314 105 20_Re: Datajoiner & DB214_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Tue, 12 Sep 2000 16:10:56 -0700576_us-ascii Leon, I have DB2Connect V7 (plus fixpack 1) installed. We access DB2 OS/390 with it. We also want to access TeraData, Oracle, SqlServer, and Informix thru DB2Connect, and sometimes need to join data from disparate DBMSs. Must I get DataJoiner into the picture between DB2Connect and the target DBMSs in order to join tables from disparate DBMS? Will I need DataJoiner if I don't need to join tables, only accessing one vendor's DBMS at a time. I haven't yet found a clear discussion of implementing 'federated' databases in the IBM library. Any suggestions? TIA [...]
15420 28 22_Re: Archiving DB2 Data13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 12 Sep 2000 21:15:36 -0400468_iso-8859-1 ... >FileAid/RDX from BMC, etc.) or "rolling your own"?
Hi Les, I'm pretty sure File-AID/RDX is STILL a Compuware product. ------------------- The way I read your note, you're looking for customer, and not Vendor perspective.
I'll be very happy to discuss your questions from a vendor and former customer perspective. Prior to my current incarnation, I was a DB2, IMS, and Oracle DBA for 15 years. Feel free to contact off-shore or here. [...]
15449 50 13_DB2 Resources9_Webmaster22_DB2@THERESOURCENET.COM31_Tue, 12 Sep 2000 21:43:45 -0500148_Windows-1252 For DB2 Resources, links to DB2 tool vendors, and job opportunities, check out
http://TheRESOURCEnet.com/db2.asp
15500 31 37_DB2 for OS390 V6 Installation Problem0_22_drdeath@OZEMAIL.COM.AU31_Tue, 12 Sep 2000 21:43:24 -0500345_us-ascii Looking for any ideas here.
We are installing DB2 V6 for OS390 and we get to install job DSNTIJSG which sets up the Stored Procedures (amongst other things) and all creates fail with message
SQLCODE = -879 SQLSTATE = 53095
this error indicates an attempt to use ascii formats in an ebcdic defined environment. [...]
15532 16 41_Re: DB2 for OS390 V6 Installation Problem12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Wed, 13 Sep 2000 16:09:15 +1300382_us-ascii One suggestion; you should probably change your e-mail name from 'Dr Death' to 'Kiss of Life'. Might help...
Raymond
================================================ 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.
15549 77 41_Re: DB2 for OS390 V6 Installation Problem14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 13 Sep 2000 14:52:15 +1100501_iso-8859-1 Dr.Death,
clutching at straws I ask: what did you use for MIXED DATA, EBCDIC CODED CHAR SET, ASCII CODED CHAR SET and DEF ENCODING SCHEME on DSNTIPF (the APPLICATION PROGRAMMING DEFAULTS installation panel)? What was the encoding scheme reported in the error message tokens? Did just the CREATE SPs fail, or all the other things with CCSIDs EBCDIC as well? What are the SBCS_CCSID, DBCS_CCSID and MIXED_CCSID for DSNDB07 (which was, I presume, created without a CCSID keyword)? [...]
15627 67 38_How do I make an ARRAY UPDATE in DB2 !27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM31_Wed, 13 Sep 2000 01:40:27 -0400471_iso-8859-1 Hi List !
One of my colleagues got a mail from a client asking ""Now, if we use oracle or udb then we can use an array update statement to reduce the number of statements to 2, jdbc is 10 times faster with this optimisation. "
I looked up the Oracle PL/SQL guide and it has references to an Array. Its not a true array, but we can make a single table of N columns and M rows as an array (M, N) and refer to the individual cell by a formula. [...]
15695 70 44_Re: Online Reorg Dynamic SortWork Allocation23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 13 Sep 2000 10:25:36 +0100404_iso-8859-1 Hi I raised this very issue direct to IBM and to the List and received no replies....
I know this is of no help at all but I thought it best to let you know.
regards
Leslie
-----Original Message----- From: Lockwood Lyon [mailto:Lockwool@MEIJER.COM] Sent: Tuesday, September 12, 2000 9:34 PM To: DB2-L@RYCI.COM Subject: Online Reorg Dynamic SortWork Allocation [...]
15766 33 37_Problems with the ODBC-driver and MFC19_Scheiderer, Stephan28_Stephan.Scheiderer@DEBIS.COM31_Wed, 13 Sep 2000 11:21:53 +0200525_- > Hi DB2-users, > > I am using DB2 Version 6.1 - Enterprise Edition. > > I connect to the database via ODBC using the CRecordset and CDatabase > classes of the MFC. I open a dynaset and want to change the received data. > Opening the database and getting the data works, but when I want to update > the data, the CLI/ODBC driver says, that it does not support a call to the > CLI function SetPos(). When calling the SQLGetInfo function, the driver > tells me that he only support one of the set_pos parameters and not [...]
15800 404 36_Re: DFDSS move; Dynamic SQL question0_18_mebert@AMADEUS.NET31_Wed, 13 Sep 2000 11:47:35 +0200409_us-ascii Hi all,
thanks - this helps me a lot. I'll rearrange the processing the way ADRDSSU does it (if I've read the manual correctly, it even uses REPRO internally to move VSAM files):
1- stop tablespace 2- create .TEMP file 3- REPRO from .A001 to .TEMP 4- rename .A001 to .XXXX (or delete .A001) 5- rename .TEMP to .A001 6- delete .XXXX (if .A001 not deleted in #4) 7- start tablespace [...]
16205 153 44_Re: Online Reorg Dynamic SortWork Allocation0_18_mebert@AMADEUS.NET31_Wed, 13 Sep 2000 12:07:36 +0200314_us-ascii I have to admit I don't quite understand your problem description (blocks??)... but there's a PTF that is required if you use SORTDEVT with compressed TSs with compression ratios>50%. Without the PTF (don't know the number), DB2 simply doubles the actual size and passes this as an estimate to SORT. [...]
16359 90 52_Re: NEW BOOK: DB2 High Performance Design and Tuning14_Philip Gunning18_pgunning@PHEAA.ORG31_Wed, 13 Sep 2000 08:05:10 -0400372_us-ascii Hi Scott, It is OS/390 oriented, but many of the new functions apply across the family.
Phil
Phil Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA V6.1 IBM Certified Solutions Expert -- Database Adminstration V6.1 IBM Certified Solutions Expert -- Application Development V6.1 Assoc List Owner DB2-L pkg3@psu.edu [...]
16450 48 47_Uploading & Downloading data from Access to DB220_Ravinder Rao Machadi22_machadi_rrao@YAHOO.COM31_Wed, 13 Sep 2000 05:52:23 -0700336_us-ascii Hi All,
I am new to the DB2. We are developing a portal by using java, ejb and db2.
I have the following situation...
DB2 is at the server side(ISP) and Access is at the client. Initially user's data will stored in the Access and once in a week the data will be uploaded & downloaded to and from DB2. [...]
16499 50 49_Recover Tablespace abended with ABND=04E-00D1034512_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 13 Sep 2000 15:05:02 +0200313_iso-8859-1 Hello Listers,
I ran into a problem while recovering a tablespace. Please see the message below. And unfortunately the needed DB2 Messages & Codes are not available at this moment - I can't find them..... Please give an idea what happened (may be a description of the error or so). Thanks. [...]
16550 214 44_Re: Online Reorg Dynamic SortWork Allocation19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 13 Sep 2000 08:07:39 -0500412_iso-8859-1 Lockwood, Leslie, Doc, Another note on this subject. We had trouble with a 3rd party product that simply didn't do a good job of estimating sizes that it passed dynamically to DFSORT. There is a DD card you can use to pass in the sizes to DFSORT, can't remember the required DDname, that DFSORT recognizes and it seemed to override the dynamically passed estimates. Solved our immediate problem. [...]
16765 103 53_Re: Recover Tablespace abended with ABND=04E-00D1034519_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 13 Sep 2000 08:10:35 -0500475_iso-8859-1 Peter,
00D10345
Explanation: A LOG READ completed unsuccessfully because an error was received from a CATALOG LOCATE request for an archive log data set. The requested archive log data set might have been uncataloged or deleted.
System Action: An execution unit might write a record to SYS1.LOGREC and request an SVC dump.
Operator Response: Collect the SYS1.LOGREC and SVC dump, if requested. Notify the system programmer. System [...]
16869 62 53_Re: Recover Tablespace abended with ABND=04E-00D1034518_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 13 Sep 2000 09:12:52 -0400798_- One of the archive log datasets might have been uncataloged or deleted.
DB2 V5 Documentation Website: http://www-4.ibm.com/software/data/db2/os390/v5books.html DB2 V6 Documentation Website: http://www-4.ibm.com/software/data/db2/os390/v6books.html
Hope this helps!
-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Wednesday, September 13, 2000 9:05 AM To: DB2-L@RYCI.COM Subject: Recover Tablespace abended with ABND=04E-00D10345
Hello Listers,
I ran into a problem while recovering a tablespace. Please see the message below. And unfortunately the needed DB2 Messages & Codes are not available at this moment - I can't find them..... Please give an idea what happened (may be a description of the error or so). Thanks. [...]
16932 134 53_AW: Recover Tablespace abended with ABND=04E-00D1034512_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 13 Sep 2000 15:15:08 +0200524_iso-8859-1 Thanks, Rick.
That was what I am looking for.
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ----------------------------------------------------------------------
All disclaimers you can imagine apply.... [...]
17067 91 53_Re: Recover Tablespace abended with ABND=04E-00D1034541_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Wed, 13 Sep 2000 10:13:16 -0300438_iso-8859-1 Georg,
Check your archive logs. See information about that reason code below:
00D10345
Explanation: A LOG READ completed unsuccessfully because an error was received from a CATALOG LOCATE request for an archive log data set. The requested archive log data set might have been uncataloged or deleted.
System Action: An execution unit might write a record to SYS1.LOGREC and request an SVC dump. [...]
17159 12 53_Re: Recover Tablespace abended with ABND=04E-00D1034515_Jeffrey Frazier26_Jeffrey_Frazier@WENDYS.COM31_Wed, 13 Sep 2000 09:08:21 -0400303_us-ascii an archive log was not available to the recover job.
================================================ 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.
17172 33 51_inserting > 255 characters in a varchar(1000) field12_Grant Mackay28_grant_mackay@PROGRESSIVE.COM31_Wed, 13 Sep 2000 08:07:26 -0500687_- I'm having issues with inserting a value > 255 bytes into a varchar field.
I can successfully update the field by saying
UPDATE table SET varcharfield= '...255 byte string...'||'...255 byte string....' WHERE key = xyz
I can't do an insert
Insert Into TABLE(KEYFIELD,VARCHARFIELD) Values(XYZ, '...255 byte string...'||'...255 byte string....')
I get the error....
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "||" was found following "". Expected tokens may include: ") , ". SQLSTATE=42601 [...]
17206 60 55_Re: inserting > 255 characters in a varchar(1000) field14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Wed, 13 Sep 2000 09:47:09 -0400648_iso-8859-1 How about Insert Into TABLE select XYZ, '...255 byte string...'||'...255 byte string....' from sysibm.sysdummy1 (or any other 1 row table);
Manas. > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Grant Mackay > Sent: Wednesday, September 13, 2000 9:07 AM > To: DB2-L@RYCI.COM > Subject: inserting > 255 characters in a varchar(1000) field > > > I'm having issues with inserting a value > 255 bytes into a varchar field. > > I can successfully update the field by saying > > UPDATE table > SET varcharfield= '...255 byte string...'||'...255 byte string....' > WHERE key [...]
17267 50 53_AW: Recover Tablespace abended with ABND=04E-00D1034512_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 13 Sep 2000 15:50:09 +0200386_iso-8859-1 Jeffrey, Claudio, Peter and Rick,
thanks for your answers. I just asked one of our DASD people if it could be possible that an archive log is deleted. The suspected answer was "Yes". ;-((((
My only chance to resolve the problem is to do a RECOVER to the last Full Image Copy... Fortunately this all happened in a test-environment and not in production.... [...]
17318 73 55_AW: inserting > 255 characters in a varchar(1000) field12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 13 Sep 2000 15:56:35 +0200341_iso-8859-1 Grant,
I am not sure, but I can remember there is the option to use CONCAT instead of the two !! . Please try this first.
Another way may be to define a :hostvariable for your varcharfield, move the data concateneted into the :hv and then the SQL looks like UPDATE table SET varcharfield = :hv WHERE key = xyz; [...]
17392 180 51_Re: Uploading & Downloading data from Access to DB216_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Wed, 13 Sep 2000 10:32:58 -0400323_iso-8859-1 IBM has a free software product on its DB2 website called "Scriptoria". It converts M/S Access databases to DB2. The end-user sees nothing different and still thinks they are using M/S Access. It is easy to use, well documented, and FREE! I converted 375 Access users in less than a month with no problems. [...]
17573 87 28_Re: Max Size OF VSAM Dataset11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Wed, 13 Sep 2000 09:50:34 -0500488_iso-8859-1 Thanks everyone for the answers. Yeah the best way is to go into extents. About DFSMS we are at 1.5 release.
AMIT SINHA Ramos Technology Inc., For Miller Brewing Company. Database Administration.
Tel:414-931-4815
-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Tuesday, September 12, 2000 12:45 PM To: DB2-L@RYCI.COM Subject: Re: Max Size OF VSAM Dataset Sensitivity: Personal [...]
17661 22 13_export/import14_Ruth Gramolini26_rgramolini@TAX.STATE.VT.US31_Wed, 13 Sep 2000 10:46:34 -0400295_iso-8859-1 Dear Listers, We are going to put some new drives on our DB2 server. We would like to just move a cold backup of the database to the new drives. Would this be possible?
If not we will export the database and import it into the new space. What kind of export should we do? [...]
17684 109 28_Re: Max Size OF VSAM Dataset14_Dean Montevago18_DMonteva@VNSNY.ORG31_Wed, 13 Sep 2000 10:57:29 -0400586_- I don't know about that. Extents can lead to performance problems depending on the type of processing you are doing.
> -----Original Message----- > From: Sinha, Amit [SMTP:Sinha.Amit@MBCO.COM] > Sent: Wednesday, September 13, 2000 10:51 AM > To: DB2-L@RYCI.COM > Subject: Re: Max Size OF VSAM Dataset > Sensitivity: Personal > > Thanks everyone for the answers. Yeah the best way is to go into extents. > About DFSMS we are at 1.5 release. > > > > AMIT SINHA > Ramos Technology Inc., > For Miller Brewing Company. > Database Administration. > > Tel:414-931-4815 > > > > > [...]
17794 46 4_-3050_25_Julian_Peacock@SWEB.CO.UK31_Wed, 13 Sep 2000 16:22:44 +0100339_ISO-8859-1 Fellow DB2'ers,
A -305 code has been encountered by a program executing a SELECT MAX (colname), even though the column is defined as TIMESTAMP NOT NULL. According to the manual, you can get this error code if you have 'host variables which receive the results of column functions whose result table could be empty'. [...]
17841 89 8_AW: -30512_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 13 Sep 2000 17:39:34 +0200587_iso-8859-1 Julian ,
the answer is: Instead of SELECT MAX(COLA) INTO :HOSTVAR WHERE.. try
SELECT VALUE(MAX(COLA),0) INTO :HOSTVAR WHERE ......
HTH.
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ---------------------------------------------------------------------- [...]
17931 503 14_Re: DFDSS move0_18_mebert@AMADEUS.NET31_Wed, 13 Sep 2000 17:59:08 +0200397_us-ascii Hello Norman,
one thing puzzles me: how do you get your JCL to run? There is one issue with JES that has annoyed me intensely before (IBMLink even has a dummy APAR for this): if you code a DD card with DISP=OLD, JES will allocate it exclusively before the job is even started. If I run the JCL below (or one similar to it), the job will go into LW status, giving the message: [...]
18435 27 57_Connect error on NT client to NT server using IP protocol12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Wed, 13 Sep 2000 11:03:51 -0500823_iso-8859-1 We have several CAE V6 clients (NT/98/95) connecting to an UDB EE V5 database (NT) without any problems. Yesterday a user called with the following error - where is the 10049 error code is documented?
In the Connectivity Supplement there is a list of the Most Common DB2 Connect Problems I wish it would list where ALL the codes are documented at. ____________________________________________________________________________ _________________ SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): [...]
18463 55 11_UNSUBSCRIBE10_Wang.James24_Wang.James@AAA-CALIF.COM31_Wed, 13 Sep 2000 09:05:44 -0700190_us-ascii Please unsubscribe me. Bye.
James Wang ESD-Technical Services Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com
18519 75 8_Re: -30510_John Hardy27_john_j_hardy@CONSULTANT.COM31_Wed, 13 Sep 2000 10:59:24 -0500551_- When using a column function such as MAX, it is irrelevant whether the column is null/not null. If the result set for the function is empty, then DB2 returns NULL, and your query will produce an SQLCODE of -305 unless you have specified the Null Indicator. If the query does return a result set, then your SQLCODE will be zero whether or not you have specified a Null Indicator. Nevertheless, even if you consider that you will never get a null result set, it is good practice to always specify the Null Indicator when using a column function. [...]
18595 18 52_Using 'piecesize' feature on non-partitioned indexes19_Michael Robaczewski25_MROBACZEWSKI@CAREMARK.COM31_Wed, 13 Sep 2000 11:05:34 -0500327_- We are planning to start using the 'piecesize' feature on some of our larger tables. Are there any issues with this feature that anyone has found after they implemented it? Also, are there any guidelines or tips on how to size the 'piecesize' value?
Thank You for any help.
Michael Robaczewski Caremark Rx [...]
18614 46 14_Re: DFDSS move16_Friemel, Norbert24_Friemel@RRZ-KARLSRUHE.DE31_Wed, 13 Sep 2000 18:39:16 +0200497_iso-8859-1 > can prevent this by coding DISP=SHR on DD IN1. But this made > me nervous on > another issue: can I really be sure that the TS will be > STOPped when the STOP > step finishes (and buffers flushed to disk)? I.e. does this > command wait for > completion, or will it just get passed on to DB2? I'm nearly > sure it must be the > former... but maybe somebody can reassure me? I did not find > any info in the > Command Reference. And what if I issue a -STO DB(..) TS(..) > followed [...]
18661 22 44_Re: Online Reorg Dynamic SortWork Allocation9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 13 Sep 2000 11:21:22 -0500406_- The primary and secondary allocations are determined by your sort package (DFSORT, etc.) based on the estimated number of records passed by REORG. REORG calculates this estimate from the size of the tablespace and an estimate of the row size. If everybody ran RUNSTATS and never "tweaked" the statistics to get the access paths they want we could use the numbers out of the catalog instead but..... [...]
18684 18 19_SMS Concurrent Copy17_Charles Jambrosic45_Charles_Jambrosic/CSI%CORNERSTONE@CSIHOME.COM31_Wed, 13 Sep 2000 09:33:18 -0700531_us-ascii Is anyone using the SMS concurrent copy feature for image copies?
If yes, have you experienced any problems and also how does the performance compare to a regular full image copy? I am assuming it's quicker so if you have any hard numbers I would appreciate it.
TIA.
================================================ 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.
18703 25 26_Triggers and SPB on OS/39015_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Wed, 13 Sep 2000 12:49:57 -0400325_us-ascii Can one call an SPB stored procedure (written in SQL using the SPB GUI) from an OS390 trigger??
The 'C' stored proc that I had written on os390 received as input a pointer to a table where each row represented another row being effected by the current sql statement that was causing the trigger to fire. [...]
18729 75 53_Re: Recover Tablespace abended with ABND=04E-00D1034514_Toolan, George21_George.Toolan@FMR.COM31_Wed, 13 Sep 2000 09:20:14 -0400682_iso-8859-1 The D10345 indicates that DB2 could not access a log dataset needed for the recovery (uncataloged/deleted?)
George J. Toolan, Jr. (508) 357-5831 Pager 1-800-SKY-8888 PIN 2128846 george.toolan@fmr.com
> -----Original Message----- > From: Peter, Georg [SMTP:G.Peter@DZBW.DE] > Sent: Wednesday, September 13, 2000 9:05 AM > To: DB2-L@RYCI.COM > Subject: Recover Tablespace abended with ABND=04E-00D10345 > > Hello Listers, > > I ran into a problem while recovering a tablespace. Please see the message > below. And unfortunately the needed DB2 Messages & Codes are not available > at this moment - I can't find them..... Please give an idea what happened [...]
18805 46 43_IDUG North America 2000 Conference Webcasts12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 13 Sep 2000 12:10:37 -0500598_- I tried out the webcasts the other day, and thought that they might be useful for a number of people who have good bandwidth on their Internet connections and have or can install RealPlayer (free download).
Roger Miller, DB2 for OS/390
Were you unable to make it to IDUG's 12th Annual North American Conference in Dallas this past spring? Did you attend the conference and find that there simply was not enough time to take in all the conference sessions of interest to you? If so, you'll want to take advantage of this unique opportunity being offered exclusively through the [...]
18852 59 61_Re: Connect error on NT client to NT server using IP protocol13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 13 Sep 2000 12:27:59 -0500358_iso-8859-1 Paul,
The windows sockets error codes can be found at the microsoft website. I searched and found the following link: % Q150537 - Windows Sockets Error Codes, Values, and Meanings
http:// support.microsoft.com / support / kb / articles / Q150 / 5 / 37.asp
Summary: This article describes the Windows Sockets error codes. [...]
18912 28 46_low performance with db2 6.1 and websphere 2.08_Giuseppe18_dedonno@ARIADNE.IT31_Wed, 13 Sep 2000 19:29:52 +0200468_us-ascii Hi, I have a big problem: a java/servlet application running on websphere 2.0 and access to a db2 6.1 database.
A particular user request is a set of 100 select on various tables, the delay of web response is about 3 minutes, but if I execute the queries in the command center the delay is only 10 seconds! Why? I see a long connection in the websphere monitor db connection. The problem is jdbc? Parameters od db2 o websphere not exact? help me! [...]
18941 24 23_new features in DB2 7.117_Herschfus, Leslee30_Leslee_Herschfus@COMPUWARE.COM31_Wed, 13 Sep 2000 13:59:45 -0400595_iso-8859-1 does anyone know what new features IBM is putting in DB2 7.1??? or is it simply a fixing of those features of 6.1??
Leslee Herschfus Leslee_Herschfus@Compuware.com Compuware Technical Support Voice: (800) 538-7822 Fax : (248) 737-7339
> * Register for Compuware Technical Support at: > http://frontline.compuware.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.
18966 51 23_Re: SMS Concurrent Copy15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 13 Sep 2000 14:12:51 -0500479_iso-8859-1 Hi, Charles,
I don't have any hard numbers but we used it for a time and switched to using CDB utilities instead. The SMS concurrent copy copies all pages in the tablespace whether there are rows on them or not so this got to be a problem for really large tablespaces that weren't necessarily full yet. In addition, it never resets the low log RBA after it executes. That meant that all the logs from that point on had to stay registered in the bootstrap. [...]
19018 40 27_FW: new features in DB2 7.112_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Wed, 13 Sep 2000 15:31:01 -0400597_iso-8859-1 Check out: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document .d2w/report?fn=db2v7q0frm3toc.htm
-----Original Message----- From: Herschfus, Leslee [mailto:Leslee_Herschfus@COMPUWARE.COM] Sent: Wednesday, September 13, 2000 2:00 PM To: DB2-L@RYCI.COM Subject: new features in DB2 7.1
does anyone know what new features IBM is putting in DB2 7.1??? or is it simply a fixing of those features of 6.1??
Leslee Herschfus Leslee_Herschfus@Compuware.com Compuware Technical Support Voice: (800) 538-7822 Fax : (248) 737-7339 [...]
19059 24 23_Re: SMS Concurrent Copy0_29_STANLEY_GOODWIN@MECH.DISA.MIL31_Wed, 13 Sep 2000 15:32:38 -0400306_us-ascii FYI, I was just notified that the love letter virus hit me on 9/11 an dit came from an entry in this forum.
Luckily the virus detection scanner in our server caught and removed it before it was able to do any damaged.
Stan Goodwin IBM Senior I/T Specialist DECC MBG DB2 Support [...]
19084 74 61_FW: Connect error on NT client to NT server using IP protocol12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Wed, 13 Sep 2000 15:37:35 -0400538_iso-8859-1 You may find executing a Protocol Connectivity Test (running pcti/pctn/pctt.exe) to be helpful.
-----Original Message----- From: Shapiro, Dave [mailto:Shapiro.Dave@PRINCIPAL.COM] Sent: Wednesday, September 13, 2000 1:28 PM To: DB2-L@RYCI.COM Subject: Re: Connect error on NT client to NT server using IP protocol
Paul,
The windows sockets error codes can be found at the microsoft website. I searched and found the following link: % Q150537 - Windows Sockets Error Codes, Values, and Meanings [...]
19159 41 52_starting performance monitor remotely, from CC on NT7_J. Wang32_Jizhong_Wang@EMAIL.WHIRLPOOL.COM31_Wed, 13 Sep 2000 16:01:02 -0400354_US-ASCII Hi all,
I am using IBM DB2 Control Center from my laptop, connecting to a remote DB2 UDB database (6.1) on AIX, to start performance monitor. it erred out for everything I picked from monitor sub-menu. (DBA4735, A problem occurred when trying to attach to the database instance. Monitoring history data will be lost. smcode: "-35"). [...]
19201 17 18_DB2 COmmand Center15_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Wed, 13 Sep 2000 16:14:27 -0400297_us-ascii When I try to bring it up on my NT box, I just the window frame and the middle never paints. I cannot 'close' the window. However I can minimize it. Once it has been up in this fashion, any window that covers that space on the screen, does not get it contents erased when minimized. [...]
19219 52 56_Re: Using 'piecesize' feature on non-partitioned indexes10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM31_Wed, 13 Sep 2000 16:03:14 -0400410_us-ascii We use it at Wendy's with no problems. We set PIECESIZE = PRIQTY with a 1 track SECQTY. Depending on how large the NPI is, we use PIECESIZE values of: 16384 32768 65536 etc.
Good luck, Keith Kuhn
Michael Robaczewski on 09/13/2000 12:05:34 PM
Please respond to DB2 Data Base Discussion List [...]
19272 16 3_SPB15_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Wed, 13 Sep 2000 16:16:15 -0400429_us-ascii Does the SQL language provide a table locator datatype? this is needed when getting invoked from an os390 trigger that is passing along a row or set of rows as a temporary table.
================================================ 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.
19289 72 56_Re: Using 'piecesize' feature on non-partitioned indexes14_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Wed, 13 Sep 2000 16:18:04 -0400466_us-ascii We have implemented PIECESIZE with no problems. Below is cross-reference of PIECESIZE to PRIQTY and Disk space:
PIECESIZE Dataset Size PRIQTY 256 K 6 Trks 288 512 K 11 Trks 528 1024 K (or 1 M) 22 Trks 1056 2024 K (or 2 M) 43 Trks 2064 4096 K (or 4 M) 86 Trks 4128 8192 K (or 8 M) 12 Cyls 8640 16384 K (or 16 M) 23 Cyls 16560 32768 K (or 32 M) 46 Cyls 33120 65536 K (or 64 M) 92 Cyls 66240 131072 K (or 128 M) 183 Cyls 131760 262144 K (or 256 M) [...]
19362 100 56_Re: Using 'piecesize' feature on non-partitioned indexes11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Wed, 13 Sep 2000 15:34:23 -0500534_iso-8859-1 Keep the Priqty same as Piecesize and secqty 0 and you should be fine. Depending on the number of datasets you want your NPI to be, have that much Piecesize.
AMIT SINHA Ramos Technology Inc., For Miller Brewing Company. Database Administration.
Tel:414-931-4815
-----Original Message----- From: Larry D Bolick [mailto:ldbolick@DUKE-ENERGY.COM] Sent: Wednesday, September 13, 2000 3:18 PM To: DB2-L@RYCI.COM Subject: Re: Using 'piecesize' feature on non-partitioned indexes [...]
19463 52 17_FW: export/import12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Wed, 13 Sep 2000 16:39:15 -0400681_iso-8859-1 Yes, this can be readily done -I've included a small ***sample script*** below which achieves this:
db2 RESTORE DATABASE picprd FROM D:\dbt TAKEN AT 20000906011032 INTO pictst1 REPLACE EXISTING REDIRECT WITHOUT PROMPTING db2 SET TABLESPACE CONTAINERS FOR 0 USING (PATH 'C:\DB\DB2Data\pictst1\SYSCATSPACE') db2 SET TABLESPACE CONTAINERS FOR 1 USING (PATH 'C:\DB\DB2Data\pictst1\TEMPSPACE1') db2 SET TABLESPACE CONTAINERS FOR 2 USING (PATH 'C:\DB\DB2Data\pictst1\USERSPACE1') db2 SET TABLESPACE CONTAINERS FOR 3 USING (FILE 'C:\DB\DB2Data\pictst1\PI_LUK' 80000) db2 RESTORE DATABASE picprd CONTINUE db2 ROLLFORWARD DATABASE pictst1 COMPLETE db2 DISCONNECT ALL [...]
19516 48 57_US- Albany, NY - Datawarehousing Opp with KPMG Consulting16_Eisman, Steven L16_seisman@KPMG.COM31_Wed, 13 Sep 2000 16:31:47 -0400653_iso-8859-1 KPMG Consulting LLC, we maintain our position as one of the industry leaders by staying on the forefront of technology. If you're an innovative thinker, ready for new challenges, contact KPMG Consulting today. We need professionals who want to join us in revolutionizing the way companies do business.
Current opportunity for datawarehousing professional to join a team responsible for building a DB2 datawarehouse as part of a large scale database integration project for a New York State government agency. Person will reside in Albany, NY and/or travel weekly to this location. Individuals must possess a minimum of 5 years of [...]
19565 24 23_DB2 Utilities Questions10_Shaw, Stan20_Stan.Shaw@DISNEY.COM31_Wed, 13 Sep 2000 13:58:28 -0700427_iso-8859-1 DB2 Utilities Support Questions
We are currently evaluating DB2 Utility alternatives. I am looking for input on problems and the quality of technical support received for DB2 Utilities and tools supplied by the following vendors: BMC CDB IBM Platinum/CA Please comment on any recurring problems or support issues with DB2 Utilities and Tools from any of the above Vendors. Thank you for your input. Stan [...]
19590 42 19_DB2 Connect scaling13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 13 Sep 2000 16:35:52 -0500367_iso-8859-1 Hello List,
I'm just wondering how other installations are scaling for DB2 Connect distributed thread growth.
We've seen a correlation (roughly) between #'s of concurrent threads and the MEM usage graph of the Performance tab of Windows NT task manager of 1 to 1 (i.e. 200 threads and 200 meg of memory). Does this match your 'mileage'? [...]
19633 79 56_Re: Using 'piecesize' feature on non-partitioned indexes11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Wed, 13 Sep 2000 16:45:35 -0500315_iso-8859-1 One more thing about piecesize I was getting error if the number of datasets exceeded 128 so have to keep the number of datasets within 128 any reasons I don't know ? Any one else has faced this problem ?
AMIT SINHA Ramos Technology Inc., For Miller Brewing Company. Database Administration. [...]
19713 114 18_DSNDB06 Vs. DSNDDF16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Wed, 13 Sep 2000 17:46:38 -0400605_iso-8859-1 Environment: DB2 for OS/390 V5.1
We were running an audit to verify all dbname.tsname's were referenced in an image copy job.
We came across the following which appear to be duplicates:
DBNAME TSNAME TABLE DBNAME TSNAME TABLE
DSNDB06 SYSDDF LOCATIONS DSNDDF SYSDDF SYSLOCATIONS DSNDB06 SYSDDF LULIST DSNDDF SYSDDF SYSLULIST DSNDB06 SYSDDF LUMODES DSNDDF SYSDDF SYSLUMODES DSNDB06 SYSDDF LUNAMES DSNDDF SYSDDF SYSLUNAMES DSNDB06 SYSDDF MODESELECT DSNDDF SYSDDF SYSMODESELECT DSNDB06 SYSDDF USERNAMES DSNDDF SYSDDF SYSUSERNAMES DSNDB06 SYSDDF IPNAMES n/a n/a n/a [...]
19828 23 35_OS390 DB2 DDF/connect in Production10_Park, Stan17_SPark@STATE.NM.US31_Wed, 13 Sep 2000 15:53:44 -0600586_iso-8859-1 Hi,
We currently have 2 OS390 DB2 V5 subsystems with DDF/connect access and are considering opening the production subsystem or possibly opening a "production" warehouse.
Would anyone like to comment on doing/not doing in a production subsystem?
(I have noted the archives discussing DDF problems)
Thanks!
================================================ 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.
19852 117 22_Re: DSNDB06 Vs. DSNDDF13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 13 Sep 2000 16:57:54 -0500360_US-ASCII Gerald, The tables in SYSDDF database are the current DB2 V5.1 communications database. The other tables that are prefixed with SYS are for PRIOR DB2 V5.1 releases and are kept for migration fallback. They can be dropped after migration if you have no intent to fallback. HTH Kurt
>>> gerald.brookman@US.ORIGIN-IT.COM 09/13/00 04:46PM >>> [...]
19970 101 22_Re: DSNDB06 Vs. DSNDDF13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 13 Sep 2000 17:07:56 -0500729_US-ASCII Sorry, I meant to say SYSDDF TABLESPACE not database. Kurt >>> gerald.brookman@US.ORIGIN-IT.COM 09/13/00 04:46PM >>>
Environment: DB2 for OS/390 V5.1 We were running an audit to verify all dbname.tsname's were referenced in an image copy job. We came across the following which appear to be duplicates: DBNAME TSNAME TABLE DBNAME TSNAME TABLE DSNDB06 SYSDDF LOCATIONS DSNDDF SYSDDF SYSLOCATIONS DSNDB06 SYSDDF LULIST DSNDDF SYSDDF SYSLULIST DSNDB06 SYSDDF LUMODES DSNDDF SYSDDF SYSLUMODES DSNDB06 SYSDDF LUNAMES DSNDDF SYSDDF SYSLUNAMES DSNDB06 SYSDDF MODESELECT DSNDDF SYSDDF SYSMODESELECT DSNDB06 SYSDDF USERNAMES DSNDDF SYSDDF SYSUSERNAMES DSNDB06 SYSDDF IPNAMES n/a n/a n/a Can someone tell me which set [...]
20072 127 28_Re: Max Size OF VSAM Dataset14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Wed, 13 Sep 2000 18:04:41 -0500493_- Yes, but unless you have DASD that can handle a 4GB dataset, extents are the way to go, assuming compression is not an alternative.
-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Wednesday, September 13, 2000 9:57 AM To: DB2-L@RYCI.COM Subject: Re: Max Size OF VSAM Dataset Sensitivity: Personal
I don't know about that. Extents can lead to performance problems depending on the type of processing you are doing. [...]
20200 118 56_Re: Using 'piecesize' feature on non-partitioned indexes14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 14 Sep 2000 11:52:14 +1100398_iso-8859-1 From DB2 V6 Admin Guide Sect Sect 2.7.2.2 Requirements for your own data sets "For a nonpartitioning index on a partitioned table space that you define using the LARGE option, the maximum data set number is 128." So, I guess it's not totally unexpected.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...]
20319 102 23_Re: DB2 Connect scaling27_Leon Katsnelson/Toronto/IBM15_leon@CA.IBM.COM31_Thu, 14 Sep 2000 01:15:55 -0400596_us-ascii Dave, you should be seeing about 200-250K being consumed on Windows NT per connection (thread) for a typical (a few cursors open at the same time) application. Windows NT task manager window is not the best way to get the right figure for memory consumption. Windows NT Performance Monitor will give you a more accurate picture. We had measurements done with major CRM and ERP applications going through a single DB2 Connect running on a IBM Netfinity 4-way Windows NT box. We had over 1,300 concurrent active connections on the system and it still had room to spare. However, when [...]
20422 14 48_Mark R. Walker/Madison/CMG is out of the office.0_26_mark.walker@CUNAMUTUAL.COM31_Thu, 14 Sep 2000 00:30:54 -0500378_us-ascii I will be out of the office from 09/14/2000 until 09/15/2000.
I am out of the office and will return on Friday 9/15/2000
================================================ 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.
20437 18 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Thu, 14 Sep 2000 01:01:16 -0500481_us-ascii I will be out of the office starting 09/13/2000 and will not return until 09/18/2000.
I will respond to your message when I return. If this is an emergency, please contact Alison Pellitier, at (801) 902-4184
================================================ 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.
20456 122 14_Re: DFDSS move0_18_mebert@AMADEUS.NET31_Thu, 14 Sep 2000 09:16:28 +02001536_us-ascii Thanks Norbert,
for some reason it did not occur to me to look under the STOP DATABASE command - I looked only under DSN - now I've found it.
MfG, ME.
From: "Friemel, Norbert" on 13/09/2000 16:39 GMT
Please respond to DB2 Data Base Discussion List
|---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |To: | |---------> >---------------------------------------------------------------------------> |DB2-L@RYCI.COM | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> |cc: | |---------> >---------------------------------------------------------------------------> | (bcc: Michael Ebert/MUC/AMADEUS) | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| [...]
20579 170 22_Re: DSNDB06 Vs. DSNDDF0_18_mebert@AMADEUS.NET31_Thu, 14 Sep 2000 09:33:56 +0200573_us-ascii Sorry Kurt - still wrong. You meant to say DSNDB06 database - this is the one that is in use with V5 and successors. The DSNDDF database belongs to a previous release (don't know which); it has been moved to the DB2 Catalog DSNDB06.
Gerald, you can drop the DSNDDF database. If you want to be extra careful (I would), do this: stop the DSNDDF database and all its table- and indexspaces. Then HMIGRATE the datasets. If nobody complains for some time, and they stay migrated, nobody is using them any more. Disable all known jobs that access them (like [...]
20750 68 8_Re: -30525_Sinha, Ranjay Kumar (CTS)24_SRanjay@CAL.CTS-CORP.COM31_Thu, 14 Sep 2000 05:22:09 -0400611_iso-8859-1 When ever -305 is encounter it is better to to put null indicator variable in the query.
-----Original Message----- From: Julian_Peacock@SWEB.CO.UK [SMTP:Julian_Peacock@SWEB.CO.UK] Sent: Wednesday, September 13, 2000 8:53 PM To: DB2-L@RYCI.COM Subject: -305
Fellow DB2'ers,
A -305 code has been encountered by a program executing a SELECT MAX (colname), even though the column is defined as TIMESTAMP NOT NULL. According to the manual, you can get this error code if you have 'host variables which receive the results of column functions whose result table could be empty'. [...]
20819 34 13_DB2 FAQ v0.0716_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 14 Sep 2000 13:46:44 +0200700_- You can reach the author at mailto:hohmann@harddiskcafe.de
> home: http://www.harddiskcafe.de/db2faq/index.html > > ================================================================ > Changes (+ new - removed * changed): > + exporting database definitions with DB2LOOK > + changing columnnames / tables > * some reformatting > + Java Version above 1.1.8 and DB2 UDB 6.1 Java GUI > (Larry Edelstein) > + Eliminating duplicates from a table (Serge Rielau) > + Another 'Fetch n-rows' variant > + Another 'Retrieving chunks of data' variant > ================================================================ > > bernd > > -- > the DB2 faq: http://www.harddiskcafe.de/db2faq/index.html > > > [...]
20854 246 5_hello14_R.Teoman KOCER22_tkocer@HALKBANK.COM.TR31_Thu, 14 Sep 2000 14:56:37 +0300274_windows-1254 dear list users i have a problem printing qmf report.i made a prompted query i got the result.when i pressed f4 it says report was printed at dsqprint.but i do not see the output.where is the outpýut.How can i see the report result? thanks for your help
21101 44 22_Re: DSNDB06 Vs. DSNDDF11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Thu, 14 Sep 2000 08:11:10 -0400401_iso-8859-1 DSNDB06.SYSDDF is current for V5. The other is previous. Be aware that when you drop the old ones you may need to adjust some applications. QMF needs to be rebound for one. There is an APAR on IBMLink on that one.
-----Original Message----- From: Brookman, Gerald [mailto:gerald.brookman@US.ORIGIN-IT.COM] Sent: Wednesday, September 13, 2000 5:47 PM Subject: DSNDB06 Vs. DSNDDF [...]
21146 27 23_Re: DB2 Connect scaling14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 14 Sep 2000 08:11:37 -0400460_us-ascii Dave, I experienced the userid problem with DB2 Connect V6.1 with connection pooling, and as you probably know that was fixed via a DB2 for OS/390 PTF. With each release of DB2 Connect and DB2 for OS/390 IBM is making improvments to thread scalability with such things as connection pooling, dynamic SQL profiling, etc. I'm sure you have the enclaves under control on OS/390 , if not you should take a look at controlling them with WLM. HTH Phil [...]
21174 234 9_Re: hello15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 14 Sep 2000 07:15:01 -0500334_windows-1254 Somewhere in your QMF setup there is a place to define the data set or sysout to print your report. For us it is under a menu pick called DFLT that is User Default Options. This is where you define where the report is to print or what data set it is to be written to. We define this before we actually get into QMF. [...]
21409 69 39_Re: OS390 DB2 DDF/connect in Production14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 14 Sep 2000 08:17:17 -0400481_us-ascii Stan, I have used DB2 Connect V5.0 thru 6.1 in produciton over 3 1/2 years and have had no major problems. Had hundreds of VB Powerbuilder clients connected. Set up WLM right and you should be ok.
Phil
Phil Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA V6.1 IBM Certified Solutions Expert -- Database Adminstration V6.1 IBM Certified Solutions Expert -- Application Development V6.1 Assoc List Owner DB2-L pkg3@psu.edu [...]
21479 44 9_Re: hello0_19_mike.holmans@BT.COM31_Thu, 14 Sep 2000 13:27:51 +0100331_ISO-8859-9 DSQPRINT is a dataset which gets allocated when you start QMF. It may be included in your TSO logon proc, or it may be somewhere else. You need to talk to your installation's DBAs to find out where and when DSQPRINT gets allocated to your session, and how you can subsequently view it if you write something to it. [...]
21524 53 9_Re: hello14_R.Teoman KOCER22_tkocer@HALKBANK.COM.TR31_Thu, 14 Sep 2000 15:43:07 +0300566_ISO-8859-9 thanks mike i found it in my tso logon procedure ----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Thursday, September 14, 2000 3:27 PM Subject: Re: hello
DSQPRINT is a dataset which gets allocated when you start QMF. It may be included in your TSO logon proc, or it may be somewhere else. You need to talk to your installation's DBAs to find out where and when DSQPRINT gets allocated to your session, and how you can subsequently view it if you write something to it. [...]
21578 91 8_Re: -30519_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Thu, 14 Sep 2000 09:08:57 EDT339_us-ascii Julian,
Whenever you use an aggregate function without a null indicator it is entirely possible to get a -305 if the table is either empty or it cannot find the rows that qualify for your predicates. It is always advisable to either provide a null indicator or explicitly handle the -305 condition in such situations. [...]
21670 28 11_attachments30_CHRISTOPHER.KELLER@Vereinte.de30_CHRISTOPHER.KELLER@VEREINTE.DE31_Thu, 14 Sep 2000 15:20:00 +0200416_iso-8859-1 --- Received from BG1.KELLERC 6785-2761 14-09-00 15.20
-> DB2-L@RYCI.COM
Hello, Could we all please refrain from posting mails with attachments? Attachments have no place in newsgroups.
Additionally: "Please post only plain text. Do not post HTML, MIME and so forth."
I think that after the scare we had this week, it would be a good time to exercise some self-restraint. [...]
21699 26 23_Re: SMS Concurrent Copy0_23_duerr_jacobsg@WESTLB.DE31_Thu, 14 Sep 2000 13:41:30 +0100446_us-ascii SMS Concurrent Copy with shrlevel reference is logically complete when the pagesets to be copied are serialized (MSG ADR734I) and the Quiescepoint was established. So you don't have to wait for physical completion. Take up to 3 seconds for each pageset to be serialized. There are some hardware restrictions: 16 pagesets SMS concurrent copied at the same time on 1 device 64 pagesets SMS concurrent copied at the same time on 1 box [...]
21726 207 25_EDU Crash? - Please help!31_Jackson Reavill/Tampa/Contr/IBM18_damcon2@US.IBM.COM31_Thu, 14 Sep 2000 10:09:18 -0400682_us-ascii Hi again,
Not getting any responses so thought I'd give some info from the db2diag.log file. Hopefully, it will help. The following is a cut and paste from the log.
2000-09-12-12.30.58.345988 Instance:db200001 Node:000 PID:28122(db2ipccm) Appid:none oper_system_services sqloEDUCodeTrapHandler Probe:155
DiagData 0000 a05a ...Z
2000-09-12-12.30.58.517070 Instance:db200001 Node:000 PID:28122(db2ipccm) Appid:none oper_system_services sqloEDUCodeTrapHandler Probe:156
DiagData 0000 0004 ....
2000-09-12-12.30.58.802537 Instance:db200001 Node:000 PID:22480(db2sysc) Appid:none base_sys_utilities sqleRunSysCtlr Probe:10 [...]
21934 36 39_Re: OS390 DB2 DDF/connect in Production14_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 14 Sep 2000 10:15:00 -0400637_- How do you get to the archives ??
> -----Original Message----- > From: Park, Stan [SMTP:SPark@STATE.NM.US] > Sent: Wednesday, September 13, 2000 5:54 PM > To: DB2-L@RYCI.COM > Subject: OS390 DB2 DDF/connect in Production > > Hi, > > We currently have 2 OS390 DB2 V5 subsystems with DDF/connect > access and are considering opening the production subsystem > or possibly opening a "production" warehouse. > > Would anyone like to comment on doing/not doing in a > production subsystem? > > (I have noted the archives discussing DDF problems) > > Thanks! > > ================================================ > To change your [...]
21971 135 18_Changing Passwords12_Randy Wilson22_Randy_Wilson@BCBST.COM31_Thu, 14 Sep 2000 10:25:45 -0400591_iso-8859-1 Does anyone have a C or Java program that can allow end-users in an UDB/AIX (v7) environment to change their passwords without having to telnet into the server to issue the passwd command? ... I know that you can connect to the database and issue the change there, but our end-users only see an application interface written in a 'C' type language called AION that connects behind the scene. When we pass the newpassword parameter through the AION app, attempting to change it in this manner, it establishes the connection but ignores the change... what we would like to try [...]
22107 143 28_Re: Max Size OF VSAM Dataset16_Cunningham, Bill23_Bill_Cunningham@BMC.COM31_Thu, 14 Sep 2000 09:36:14 -0500507_iso-8859-1 If you are using new RAID DASD such as EMC Symmetrix or RVA/SVA devices, extent processing has very little affect on performance.
-----Original Message----- From: Jack O'Connell [mailto:jack.oconnell@MCMASTER.COM] Sent: Wednesday, September 13, 2000 6:05 PM To: DB2-L@RYCI.COM Subject: Re: Max Size OF VSAM Dataset Sensitivity: Personal
Yes, but unless you have DASD that can handle a 4GB dataset, extents are the way to go, assuming compression is not an alternative. [...]
22251 46 39_Re: OS390 DB2 DDF/connect in Production22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 14 Sep 2000 10:44:14 -0400478_iso-8859-1 We've been using StarSQL and DDF V5.1 TCP/IP accessed by VB applications and MS Access for 2 years. No problems. Works great and the users are very happy.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Park, Stan [mailto:SPark@STATE.NM.US] Sent: Wednesday, September 13, 2000 17:54 To: DB2-L@RYCI.COM Subject: [DB2-L] OS390 DB2 DDF/connect in Production [...]
22298 331 22_Re: DSNDB06 Vs. DSNDDF13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 14 Sep 2000 09:54:13 -0500339_US-ASCII Michael, Thanks for the correction. Kurt
>>> mebert@AMADEUS.NET 09/14/00 02:33AM >>> Sorry Kurt - still wrong. You meant to say DSNDB06 database - this is the one that is in use with V5 and successors. The DSNDDF database belongs to a previous release (don't know which); it has been moved to the DB2 Catalog DSNDB06. [...]
22630 24 21_IBM DB2 Restart Tool?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 14 Sep 2000 10:01:58 -0500636_iso-8859-1 Hi all, Does IBM sell a batch restart tool/product for DB2 OS/390? Regards, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
22655 234 29_Re: EDU Crash? - Please help!12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 14 Sep 2000 10:04:57 -0500327_iso-8859-1 Looking at you log we had the same error on one of our AIX systems after we upgraded it to UDB EE V6 - I opened a problem with IBM because it was failing almost everyday, they said the fix would be in fixpak5 and in the interim turn off the monitor switches. I turned off the switches and the system stayed up. [...]
22890 62 39_Re: OS390 DB2 DDF/connect in Production19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 14 Sep 2000 10:26:08 -0500604_iso-8859-1 http://jupiter.ryci.com/archives/db2-l.html
Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
22953 36 21_Check out dbazine.com14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Thu, 14 Sep 2000 10:33:21 -0500642_iso-8859-1 Dear DB2-L subscribers:
Just a quick note to inform everybody that the latest updated edition of dbazine.com has been published on the web. dbazine.com is a dedicated web portal that contains database technology related articles and information relevant to database administrators and data analysts. Each "issue" of dbazine.com will contain new original articles, as well as a vast collection of links to articles and information at other sites. The links are organized by topic and contain abstracts so you have an idea of the information you will find when you click on the link. Overall, the goal is for dbazine.com [...]
22990 28 59_DB2 REXX interface program -504 on prepare update statement12_Bob Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 14 Sep 2000 11:34:22 -0400534_us-ascii Hi list, I am writing my first REXX DB2 program where I want to update a table using host variables I have successfully connected to my DB2 subsystem where I performed a describe of my table. The the next thing I do is to create my sqlstmt using ? for the hostvariable marker. When I performed the EXECSQL PREPARE S1 FROM :SQLSTMT I get a -504 SQLCODE which states -504 CURSOR NAME S1 is not defined Why would it give this since this is an update statement. I am perplexed. Any and all Ideas will be greatly appreciated [...]
23019 57 39_Re: OS390 DB2 DDF/connect in Production22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 14 Sep 2000 11:36:17 -0400817_iso-8859-1 Search for archive on the http://www.ryci.com/db2-l page.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Thursday, September 14, 2000 10:15 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] OS390 DB2 DDF/connect in Production
How do you get to the archives ??
> -----Original Message----- > From: Park, Stan [SMTP:SPark@STATE.NM.US] > Sent: Wednesday, September 13, 2000 5:54 PM > To: DB2-L@RYCI.COM > Subject: OS390 DB2 DDF/connect in Production > > Hi, > > We currently have 2 OS390 DB2 V5 subsystems with DDF/connect > access and are considering opening the production subsystem > or possibly opening a "production" warehouse. > [...]
23077 58 25_Re: IBM DB2 Restart Tool?9_Chris Tee18_TEECHRI@UK.IBM.COM31_Thu, 14 Sep 2000 16:47:12 +0100473_us-ascii Not that I'm aware of, but BMC and RAI both have good products.
Regards
Chris Tee
UK SSO S390 UK Technical Assurance Specialist IBM Global Services. (Geomar)
Notes: Chris Tee/UK/Contr/IBM@IBMGB, Internal Tel: 258671, External Tel: 023 92568671, Fax: 023 92210613 (North Harbour), Email: teechri@uk.ibm.com, Mail point: FGU (North Harbour)
"DAVIS, RICK (SBCSI)" on 14/09/2000 16:01:58 [...]
23136 19 8_Re: -30517_Anand Thippeswamy19_Thippesa@MEIJER.COM31_Thu, 14 Sep 2000 11:41:05 -0400354_US-ASCII With the exception of "Count" function, it may not need a null indicator.
Regards Anand Meijer ITS
===============================================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.
23156 218 25_Re: IBM DB2 Restart Tool?16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Thu, 14 Sep 2000 16:50:36 +0100451_- And Computer Associates / Softbase to add one to the list.
Regards Steen Rasmussen
-----Original Message----- From: Chris Tee [SMTP:TEECHRI@UK.IBM.COM] Sent: 14 September 2000 17:47 To: DB2-L@RYCI.COM Subject: Re: IBM DB2 Restart Tool?
Not that I'm aware of, but BMC and RAI both have good products.
Regards
Chris Tee
UK SSO S390 UK Technical Assurance Specialist IBM Global Services. (Geomar) [...]
23375 84 23_Re: DB2 Connect scaling13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 14 Sep 2000 10:59:27 -0500608_iso-8859-1 Dave,
In addition to what has been posted. Here are various figures from 4-NT servers which I work with. As Leon says, better to use the NT performance monitor. Anyway, here is what I found on the various boxes., NT Threads Mem Usage Box Description 241 203MB (~~1:1) PeopleSoft, DB2 Connect EE machine. Low usage. Lucky to have 5 real concurrent users. 265 214MB (~~1:1) PeopleSOft, DB2 Connect EE machine. Low usage 180 68MB (~3:1) Does "Nothing", Recently setup ready for use next week. DB2 Connect EE. 270 250MB (~1:1) MS SQLServer. Has about 20 databases. low usage. 2000 inserts [...]
23460 93 63_Re: DB2 REXX interface program -504 on prepare update statement12_Bob Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 14 Sep 2000 12:12:42 -0400561_us-ascii Thanks Andy, That did it. Too bad the manual did not say that in its code smippets Thanks again
Bob Lawrence DBA Boscov's Dept Stores Inc
On Thursday, September 14, 2000 11:44 AM, Andy Hunt [SMTP:Andy.Hunt@scottish-southern.co.uk] wrote: > > It is an odd quirk of the way the interface is implemented that you have to use > cursors even though it is not cursor processing. > Execute it as a cursor and you should be ok. Ill send you some example code. > Regards, > Andy Hunt - Scottish And Southern Energy. > > > > > > > Bob [...]
23554 53 63_Re: DB2 REXX interface program -504 on prepare update statement19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Thu, 14 Sep 2000 09:12:47 -0700664_- I ran into the same thing.
Trying out several iterations, including using c1 as a valid cursor name (which was rightfully rejected since it wasn't a cursor), I finally just executed the SQL statement without preparing it, and it worked fine.
SQL_TS_UPDATE1= UPDATE statement... ADDRESS DSNREXX "EXECSQL" SQL_TS_UPDATE1
HTH, Tim
> -----Original Message----- > From: Bob Lawrence [SMTP:rlawrence@boscovs.com] > Sent: Thursday, September 14, 2000 8:34 AM > To: DB2-L@RYCI.COM > Subject: DB2 REXX interface program -504 on prepare update statement > > Hi list, > I am writing my first REXX DB2 program where I want to update a table [...]
23608 19 16_Triggers and SPB15_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Thu, 14 Sep 2000 12:13:38 -0400450_us-ascii I did not get any responses on yesterday's question.
Is anybody using triggers that call stored procedures that are SQL Procedure Language, generated by SPB?
Has IBM ever tried that????
================================================ 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.
23628 21 17_DBArtisan for UDB0_18_Usregion10@AOL.COM29_Thu, 14 Sep 2000 12:18:22 EDT333_ISO-8859-1 Hi all!
I have downloaded the DBArtisan tool for UDB. We are using UDB6.1 on AIX. Question for those who have used DBArtisan: What value did you see in DBartisan that you couldn't do with the Control Center, Script Center, etc (basically all the GUI tools for udb admin) Looking forward to hear from you. TIA. [...]
23650 75 63_Re: DB2 REXX interface program -504 on prepare update statement12_Bob Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 14 Sep 2000 12:25:11 -0400649_us-ascii Thanks
Bob Lawrence DBA Boscov's Dept Stores Inc
On Thursday, September 14, 2000 12:13 PM, Ohling, Tim R - CNF [SMTP:Ohling.Tim@CNF.COM] wrote: > I ran into the same thing. > > Trying out several iterations, including using c1 as a valid cursor name > (which was rightfully rejected since it wasn't a cursor), I finally just > executed the SQL statement without preparing it, and it worked fine. > > SQL_TS_UPDATE1= UPDATE statement... > ADDRESS DSNREXX "EXECSQL" SQL_TS_UPDATE1 > > HTH, > Tim > > > -----Original Message----- > > From: Bob Lawrence [SMTP:rlawrence@boscovs.com] > > Sent: Thursday, September 14, [...]
23726 84 25_Re: IBM DB2 Restart Tool?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 14 Sep 2000 11:24:55 -0500570_iso-8859-1 Thx Chris
Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
23811 38 21_Re: DBArtisan for UDB18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 14 Sep 2000 12:26:18 -0400434_- The amount of time it takes to migrate an object from one database to another is a few point-and-clicks of the mouse. It would take hours to write shell scripts to do all this. You can decide what you want to move (data, indexes, foreign keys, etc). You can generate the entire database creation script right from DBArtisan. DB2LOOK will not extract triggers, columns comments, etc. DBArtisan does. It is well worth the money. [...]
23850 104 9_Re: hello14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Thu, 14 Sep 2000 08:51:52 -0700402_us-ascii
Many installations write a REXX exec to help you with externalizing DSQPRINT (to a printer or another dataset of your choice) while remaining in QMF. If you want one I wrote, email me outside the list. HTH Roy Reynolds
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Roy Reynolds/SB/GAPINC) Subject: Re: hello
23955 115 23_Re: DB2 Connect scaling13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Thu, 14 Sep 2000 11:57:48 -0500367_iso-8859-1 Leon, Phil, Glenn,
Thank you for responding.
Leon, you provided some excellent information as food for thought, much appreciated!! Do you know of any stress tests for unix flavor boxes (similar to what you described was done to NT, i.e. 2000 threads was pushing things?)
Phil, no, I was not aware of the PTF for the host. Thanks! [...]
24071 41 21_Re: DBArtisan for UDB13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Thu, 14 Sep 2000 13:18:42 -0400491_iso-8859-1 DBArtisan is an extremely powerful tool for making structural changes to tables. Changing a column data type/name/length is a snap with a GUI interface that generates a script. It provides an intuitive tool for querying the catalog, where dependencies, constraints, ddl, space, etc. can be examined quickly. There is no comparison to the Control Center. Be aware of a bug in which column names greater than 18 characters are truncated. This bug is fixed in the next release. [...]
24113 38 20_SV: Triggers and SPB0_19_Sven.Heidorn@CSN.SE31_Thu, 14 Sep 2000 19:26:46 +0200712_ISO-8859-1 Benjamin,
can you explain a little more in detail what you are trying to achieve?
Sven Heidorn
> -----Ursprungligt meddelande----- > Från: Benjamin.Reches@msdw.com [SMTP:Benjamin.Reches@msdw.com] > Skickat: den 14 september 2000 18:20 > Till: DB2-L@RYCI.COM > Ämne: Triggers and SPB > > I did not get any responses on yesterday's question. > > Is anybody using triggers that call stored procedures that are SQL > Procedure Language, generated by SPB? > > Has IBM ever tried that???? > > ================================================ > 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 [...]
24152 113 25_Central PA DB2 User Group12_Terry Gawlas25_terry.gawlas@HIGHMARK.COM31_Thu, 14 Sep 2000 13:20:18 -0400549_iso-8859-1 Attached is the agenda for the next Central PA DB2 User Group. Please feel free to call Cathy or me with questions. If you email your reservation, please include name(s), company, and a phone number. Thanks!
Central Pennsylvania Regional DB2 User Group
Date: Thursday, September 28, 2000 Place: Camp Hill Corporate Center, Building 300, Large Auditorium Cost: FREE Reservations: Email or call: Cathy.Peck@highmark.com (717) 975-7396 or Terry.Gawlas@highmark.com (717) 763-3844 For details: See www.db2parug.org [...]
24266 50 27_Re: DB2 Utilities Questions11_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 14 Sep 2000 17:32:05 GMT319_- BMC support is one of the best I have dealt with, expecially the DB2 Utilities group. Other than them, in general you must be a little smarter than some of the support people in some organizations because some support people make an effort to get you off the phone instead of really trying to solve the problem. [...]
24317 76 27_Re: DB2 Utilities Questions11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM31_Thu, 14 Sep 2000 12:35:47 -0500709_us-ascii The CDB Reorg product is wonderful...
Trace
rick creech @RYCI.COM> on 09/14/2000 12:32:05 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: DB2 Utilities Questions
BMC support is one of the best I have dealt with, expecially the DB2 Utilities group. Other than them, in general you must be a little smarter than some of the support people in some organizations because some support people make an effort to get you off the phone instead of really trying to solve the problem. [...]
24394 15 15_Re: attachments26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Thu, 14 Sep 2000 12:42:21 -0500351_- According to RY it's been neutered. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.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.
24410 35 56_SMS still migrates DB2 underlying VSAMs despite activity15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 14 Sep 2000 12:43:55 -0500594_iso-8859-1 Has anyone encountered this problem? We have DB2 V6. On our development environment we let HSM migrate the underlying VSAM data sets. The problem is that DB2 (or VSAM) only updates the reference date (FMT1 DSCB) when it opens or, I assume, closes the underlying VSAM data sets. This is the reference date that HSM checks to determine whether to migrate or not. These data sets, once opened, stay opened until DB2 is recycled. We seldom recycle our DB2 subsystems. When we do shutdown we use fast shutdown so these underlying VSAMs don't get closed. HSM comes through and thinks [...]
24446 26 14_displayed date17_Herschfus, Leslee30_Leslee_Herschfus@COMPUWARE.COM31_Thu, 14 Sep 2000 13:48:43 -0400368_iso-8859-1 at what point is the format of a displayed date determined --- is it somewhere in the catalog or is it part of the install procedure of DB2
i.e. whether a shop uses '-' or '/' or '.' as the separators in a date
<<...>> Leslee Herschfus Leslee_Herschfus@Compuware.com Compuware Technical Support Voice: (800) 538-7822 Fax : (248) 737-7339 [...]
24473 24 27_Re: DB2 Utilities Questions15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 14 Sep 2000 12:55:10 -0500364_iso-8859-1 We use CDB utilities and have had few problems. The support people are intelligent and efficient. We don't use the Platinum utilities but we have some of the other products. Since they have gone to CA the support isn't the best.
Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin [...]
24498 59 18_Re: displayed date0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 14 Sep 2000 13:27:29 -0500574_us-ascii Default display date format is defined at install. OS/390 V5 SQL Reference, 3.7.4.1 Date ... The length of a DATE column as described in the catalog is the internal length which is 4 bytes. The length of a DATE column as described in the SQLDA is the external length which is 10 bytes unless a date exit routine was specified when your DB2 subsystem was installed. (Writing a date exit routine is described in Appendix B (Volume 2) of Administration Guide.) In that case, the string format of a date can be up to 255 bytes in length. Accordingly, DCLGEN [...]
24558 123 22_Re: Correlated Columns11_Carl Nelson20_Carl_Nelson@AICI.COM31_Thu, 14 Sep 2000 13:51:07 -0500360_us-ascii Thanks. This is exactly what I was looking for. Does any one have an idea at what point correlated columns tend to degrade performance? The few indexes I have examined have correlations up to 35%. I wasn't going to bother with them unless I found something greater than 50%. Is there a rule of thumb for this or "experience says.." type of rule? [...]
24682 57 21_Re: DBArtisan for UDB12_Ragam, Sai J18_Sai.Ragam@BNSF.COM31_Thu, 14 Sep 2000 13:44:55 -0500486_iso-8859-1 This product is truly a client only product with no component required to be installed on the server and its great for lookups, compare, capture and change management etc.
But one issue which I am not sure whether it is still true or not. The problem that I ran into when evaluating DBArtisan is when migrating databases or implementing changes that involved huge tables...I am assuming that the db is on a unix server and you have DBArtisan on windows platform. [...]
24740 69 24_Re: SV: Triggers and SPB15_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Thu, 14 Sep 2000 14:44:47 -0400502_iso-8859-1 Sven,
I have a trigger defined on a table, that fires when an insert,update or delete is peformed on the table. The trigger then calls a stored procedure, passing to it the transition variable. This transition variable is a temporary table containing images of the rows being updated by the current sql statement. I have written the stored procedure in native 'C' on the mainframe. I would like to write that now in the SQL Procedures Language, using the StoredProcedureBuilder. [...]
24810 32 46_Multiple versions of DB2 SPB stored procedures12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 14 Sep 2000 12:51:13 -0700402_us-ascii How are people handling having multiple enviroments in the same DB2 using the same DB2 stored procedure? (Especially SPB stored procedures). And having these stored procedures accessed from VB or other PC type tools. The COLLID and creator (schema) of the stored procedure is stored with the stored procedure and thus you have to compile/build that stored procedure with the unique name. [...]
24843 20 9_DB2 Books17_Charles Jambrosic32_cjambros.CORNERSTONE@CSIHOME.COM31_Thu, 14 Sep 2000 12:50:56 -0700342_us-ascii I was hoping to attain some books on DB2 performance and was wondering if anyone can recommend some good books.
I am mostly interested from a DBA and Sysprog perspective and don't want the material to be outdated too quickly. I have narrowed it down to 3 including a 2 volume set but would like some input from the list. [...]
24864 16 13_Re: DB2 Books26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Thu, 14 Sep 2000 15:12:37 -0500430_- We use Craig Mullin's DB/2 Developers Guide 3rd and 4th edition. Available from www.samspublishing.com $59.99(US). Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.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.
24881 46 13_Re: DB2 Books9_Cam White20_cwhite@REVEALNET.COM31_Thu, 14 Sep 2000 16:16:15 -0400665_iso-8859-1 For technical information that's constantly updated, try downloading a 30-day trial version of RevealNet's Knowledge Base for DB2 from http://www.revealnet.com
Best wishes,
Cam White
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Charles Jambrosic > Sent: Thursday, September 14, 2000 3:51 PM > To: DB2-L@RYCI.COM > Subject: DB2 Books > > > I was hoping to attain some books on DB2 performance and was > wondering if anyone can recommend some good books. > > I am mostly interested from a DBA and Sysprog perspective and > don't want the material to be outdated [...]
24928 17 25_Central PA DB2 User Group14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 14 Sep 2000 16:26:20 -0400331_ISO-8859-1 Terry, I will need directions... coming west on PA Turnpike.
Thanks, Joel
===============================================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.
24946 65 42_Re: DB2 OS/390 Replication Data Propagator21_Devonshire, Stephen M29_stephen.m.devonshire@LMCO.COM31_Thu, 14 Sep 2000 16:26:42 -0400584_- What are the opinions on Platinum, ah no, I mean, CA's Inforefiner and Infotransport as solution ?
> -----Original Message----- > From: rick creech [SMTP:ykcirc@HOTMAIL.COM] > Sent: Sunday, September 10, 2000 7:49 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 OS/390 Replication Data Propagator > > Not so. We use it for a lot of different scenarios on os/390 in both > data-sharing and non data-sharing. It's a fully supported product on > os/390. > Let me give BMC a plug: They also have a replicator product that works on > os/390, so if you are evaluating I would look [...]
25012 168 22_Re: Correlated Columns11_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 14 Sep 2000 15:45:39 CDT543_- Carl: I am not sure I would view higher correlation as a problem to deal with - it is simply stating a fact that helps the Optimizer calculate filter factors more accurately. For example, if city has a card of 1000 and state 50, a condition of the type city=:h and state=:h would incorrectly get a filter factor of 1/50,000 when in reality it is closer to 1/1000 since the two are highly correlated. So I would not go chasing indexes with high correlation (just run col level runstats on at least indexed columns and leave it at that). [...]
25181 26 23_DB2v6 os/390 and DSNCLI11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 14 Sep 2000 13:51:45 -0700330_iso-8859-1 Hi all, Just noticed that DSN610.SDSNLOAD does not have DSNCLI module but my v510 loadlib does. I also found DSNCLI in the CICS v4 loadlib but its not in the CICS v5 lib.
What's the current standing for DSNCLI, should it be in the CICS or DB2 loadlib, both or none? Where/where is the most current version? [...]
25208 40 13_Re: DB2 Books13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 14 Sep 2000 15:42:29 -0500317_us-ascii A new book on the market that you may want to take a look at is "DB2 High Performance Design and Tuning" by Richard Yevich (like in RYCI) and Susan Lawson. I have only scanned a few chapters but so far look pretty good... lots of detail..... IMHO it seems to be an excellent addition to my DB2 library. [...]
25249 55 27_Re: DB2v6 os/390 and DSNCLI12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 14 Sep 2000 16:10:40 -0500415_us-ascii Yes, starting with DB2 Version 6.1, the DSNCLI and DSNCUEXT modules for the CICS/DB2 interface are shipped only with CICS, not with DB2. If you are running OAM applications under CICS, it requires the DSNCLI module to be in an APF-authorized library. There is a CICS APAR that places a copy of the module into SDFHAUTH, as well as SDFHLOAD. We ran into it this week when we migrated DB2 to version 6. [...]
25305 49 12_UDB Doubts..8_ritu zee22_ritu_98_2000@YAHOO.COM31_Thu, 14 Sep 2000 14:43:29 -0700577_us-ascii Hi !
I am in the process of reading UDB manuals before installing it in my installation and am thoroughly confused. Could I benefit from experience of the list in my questions : 1. After installing UDB on my first client, I will configure it with search discovery. Once configured , I plan to create a response file on my client and then distribute it to all the other users. Running response file on any client should automatically install the UDB product as well as configure the client for remote access. If that is the case, when are 'Access profiles' [...]
25355 15 16_Version 6 DSSIZE0_20_bjnigh@HOUSEHOLD.COM31_Thu, 14 Sep 2000 15:16:15 -0700387_us-ascii Has anyone had any experience with the DSSIZE option on CREATE TABLESPACE in DB2 Version 6?
Any information would be appreciated.
================================================ 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.
25371 71 27_Re: DB2v6 os/390 and DSNCLI11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 14 Sep 2000 15:43:30 -0700637_iso-8859-1 Ahh, Thanks Kirk. cliff:-)
-----Original Message----- From: Kirk Hampton [mailto:khampto1@TXU.COM] Sent: Thursday, September 14, 2000 2:11 PM To: DB2-L@RYCI.COM Subject: Re: DB2v6 os/390 and DSNCLI
Yes, starting with DB2 Version 6.1, the DSNCLI and DSNCUEXT modules for the CICS/DB2 interface are shipped only with CICS, not with DB2. If you are running OAM applications under CICS, it requires the DSNCLI module to be in an APF-authorized library. There is a CICS APAR that places a copy of the module into SDFHAUTH, as well as SDFHLOAD. We ran into it this week when we migrated DB2 to version 6. [...]
25443 104 13_Re: DB2 Books4_Fred22_DB2@THERESOURCENET.COM31_Thu, 14 Sep 2000 18:45:08 -0500859_Windows-1252 For understanding performance, I would recommend Mullin's book and
DB2 High Performance Design and Tuning by Susan Lawson, Richard A. Yevich
for other DB2 book recommendations, check out the Books link on
http://TheRESOURCEnet.com/db2.asp
"Edward(Ed) J. Finnell, III" wrote in message news:39C0EAE5.30515.925559@localhost... > We use Craig Mullin's DB/2 Developers Guide 3rd and 4th > edition. Available from www.samspublishing.com $59.99(US). > Edward(Ed) J. Finnell, III > Enterprise Systems/Proj. Mgr. > url:www.ua.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. [...]
25548 105 13_Re: DB2 Books9_Webmaster22_DB2@THERESOURCENET.COM31_Thu, 14 Sep 2000 18:47:06 -0500856_Windows-1252 For performance and tuning, I would recommend Mullin's book and
DB2 High Performance Design and Tuning by Susan Lawson, Richard A. Yevich
other db2 book recommendations are available at
http://TheRESOURCEnet.com/db2.asp check out the books link
+++++++++++++++++++++++++++++++++ "Edward(Ed) J. Finnell, III" wrote in message news:39C0EAE5.30515.925559@localhost... > We use Craig Mullin's DB/2 Developers Guide 3rd and 4th > edition. Available from www.samspublishing.com $59.99(US). > Edward(Ed) J. Finnell, III > Enterprise Systems/Proj. Mgr. > url:www.ua.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 [...]
25654 22 27_Re: new features in DB2 7.112_Roger Miller19_millerrl@US.IBM.COM31_Thu, 14 Sep 2000 19:03:49 -0500338_- This is one we often call an RTFW or read the friendly web. There is a What's New? book on the various DB2 home pages,
For all of the DB2's, try ibm.com/db2
DB2 for UNIX, WIndows, OS/2 is ibm.com/software/db2/udb
For OS/390, start at ibm.com/software/db2os390 Click on What's New for DB2 for OS/390 Version 7? [...]
25677 48 25_Re: Large NPI maintenance12_Mark Roberts19_mhr@GLOBALNET.CO.UK31_Thu, 14 Sep 2000 19:21:26 -0500547_- Hi.... Thanks to everyone who replied to my query on large NPI maintenance. It's a great help hearing how others handle them. Susan, could you please clarify a couple of points on your note ?
Is the 30 hours index build time a single process or run at partition level in parallel ? It sounds like a single process using key files unloaded at partition level and sorted in NPI key order. Does your NPI key follow partition order ? If not, wouldn't you end up with a disorganised index after build if there is no NPI order between key [...]