1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l March 2001, week 2
2 39 21_PSRCP Status on index0_22_The-Thanh.Luong@AGF.BE30_Thu, 8 Mar 2001 08:57:06 +0100489_- Hi all,
OS390, DB2 V4.1.
A reorg index job abended due to an unavailable resource last night. No big deal. I run a recover index job this morning. The display database restrict shows me this:
..... RGX122 IX 014 RW,RECP,UTUT RGX122 IX 015 RW,RECP,UTUT RGX122 IX 016 RW,RECP,UTUT RGX222 IX RW,RECP*,PSRCP ---- UTUT RGX322 IX RW,RECP*,PSRCP ---- UTUT ******* DISPLAY OF DATABASE RGDB01 ENDED ********* DSN9022I > DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION *** [...]
42 19 25_Re: PSRCP Status on index10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 8 Mar 2001 09:18:23 +0100449_us-ascii Don't worry.
It means you have to recover the whole NPI index(es) as you have a NPI logical partition in RECP* but DB2 don't allow the recover of that logical partition.
HTH Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
62 34 25_Re: PSRCP Status on index0_22_The-Thanh.Luong@AGF.BE30_Thu, 8 Mar 2001 09:41:49 +0100416_- Thank you Max. The-Thanh LUONG
-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: Thursday, 08 March, 2001 9:18 AM To: DB2-L@RYCI.COM Subject: Re: PSRCP Status on index
Don't worry.
It means you have to recover the whole NPI index(es) as you have a NPI logical partition in RECP* but DB2 don't allow the recover of that logical partition. [...]
97 59 42_Re: BLOB columns versus VARGRAPHIC columns8_Rob Lake29_robert.q.lake@PAC.ERICSSON.SE30_Thu, 8 Mar 2001 04:22:06 -0600583_- Hi,
The intention of VARGRAPHIC columns is to provide support for DBCS (Double Byte Character Set) data. This explains why the column length is half that for VARCHAR since the length is the number of Double-byte characters.
I guess that the choice you should be making is between BLOB and VARCHAR FOR BIT DATA. The BIT clause ensures that the data in the column is not treated as character data (for example, data conversion from one CCSID to another when moving it between locations will not take place). In the old days before we had BLOBS we used VARCHAR FOR [...]
157 69 26_Re: -911 Cursor with hold.10_John Hardy24_john_j_hardy@ANOTHER.COM30_Thu, 8 Mar 2001 04:14:43 -0600334_- Be careful before switching to Row Level Locking on any of your tables. Row level locking has its place, but you've got to consider the overhead, which is substantial. i'm sure that there will be plenty of postings on the archive on this subject.
On Wed, 7 Mar 2001 16:50:54 -0600, Rohn.Solecki@MTS.MB.CA wrote: [...]
227 96 30_Re: Read Oracle DB from OS/39018_Michael J. O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV30_Thu, 8 Mar 2001 05:54:25 -0500350_US-ASCII Oracle OS/390 Client may be the finest example of KLUGEWARE on the planet. Its easy to implement, but you get so much "extra" junk during an install that it borders on the absurd. You must install the Oracle kernel et al whether you want it or not. Install means that it comes off the tape; along with about 400 other unneeded modules. [...]
324 68 33_Re: DB2 OS/390 V6 : SQL CODE -5310_25_Ed_Vetock@NAVYFEDERAL.ORG30_Thu, 8 Mar 2001 06:31:27 -0500551_us-ascii Thanks to all who responded on above question. It turns out APAR PQ10303 addresses our situation. IBM does not have a PTF for this however.
Our situation occurred when we altered the primary key to contain one less column. Then when we tried to update the column which was originally part of the primary key, we received the -531. IBM solution to correct the -531 was to drop and rebuild the tables in the RI relationship. This solved our -531 for us although we had to go through the pain of an unload/drop/rebuild/load process. [...]
393 64 26_Re: DB2 v5 to V7 migration0_19_mike.holmans@BT.COM30_Thu, 8 Mar 2001 11:33:26 -0000548_- I Have Heard, although I can't remember from where, that going the V5-V7 direct route is supposedly not preferred, and that you should only really do it if you're desperate for V7 function in the next three minutes or so, and if you're not desperate, then the normal V5-V6-V7 route is safer. Since I can't remember who told me this, I can't remember whether they had some vested interest which would influence them to make such a recommendation. Maybe when they've all finished being Hamburgers someone will be able to enlighten us further. [...]
458 118 34_Re: -911 Cursor with hold. (Reply)14_Scott Trometer22_scott.trometer@RCI.COM30_Thu, 8 Mar 2001 06:57:36 -0500425_iso-8859-1 OS/390?
If, after checking 1) the current locksize value for the tablespace and 2) the commit frequency, you continue to have problems, you might consider increasing pctfree to decrease the number of rows per page. You could also do this with the maxrows parameter. Both are tablespace parms.
Row level locking is another alternative, but, because of the costs, I'd look at other options first. [...]
577 29 25_Re: Stored Procedure Help13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Thu, 8 Mar 2001 07:50:41 -0500442_iso-8859-1 Hi Deborah, This type of problem is precisely why Compuware's Xpediter product now provides Stored Procedure debugging facilities.
If you're an Xpediter customer, you already know how simple it is to step through your code instruction by instruction.
See http://www.compuware.com/products/xpediter/tso/xpedtso70.htm
feel free to contact me off-list and I can put you in touch with my Xpediter colleagues. [...]
607 75 26_Re: DB2 v5 to V7 migration10_John Hardy24_john_j_hardy@ANOTHER.COM30_Thu, 8 Mar 2001 06:51:20 -0600629_- Hamburgers?
On Thu, 8 Mar 2001 11:33:26 -0000, mike.holmans@BT.COM wrote:
>I Have Heard, although I can't remember from where, that going the V5-V7 >direct route is supposedly not preferred, and that you should only really do >it if you're desperate for V7 function in the next three minutes or so, and >if you're not desperate, then the normal V5-V6-V7 route is safer. Since I >can't remember who told me this, I can't remember whether they had some >vested interest which would influence them to make such a recommendation. >Maybe when they've all finished being Hamburgers someone will be able to [...]
683 96 24_Re: Table Comparison SQL14_Richard Arnold24_Richard.Arnold@CHASE.COM30_Thu, 8 Mar 2001 07:18:55 -0600500_us-ascii James,
You could always just comparex the sqls against each other.
It's not sophisticated, but it will quickly and easily identify differences in the columns on the table.
Alternatively, if you have Platinum RC/MIgrator, it can do this.
Hope this helps.
Richard Arnold
James Drewe @RYCI.COM> on 03/07/2001 05:49:13 PM
Please respond to DB2 Data Base Discussion List [...]
780 99 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 8 Mar 2001 07:39:47 -0600495_us-ascii Chris,
Try this. Performance may not be optimal, dependant on the data volumes (query must read every row of TABLE1) and available indexes. The 2nd or 3rd subquery will not be executed if a match is found at a higher level, but if there is no match, then all 3 subqueries will execute. This could be a problem if there is a significant number of rows which do not qualify for either. So if there is any other WHERE clause checking that can be applied to TABLE1, then do so. [...]
880 21 26_Re: DB2 v5 to V7 migration10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 8 Mar 2001 14:44:00 +0100320_us-ascii I agree with Mike Holmans, someone (Miss January ?) said to me that it's not a good idea to jump from V5 to V7.
I think it may be due to high number of PTFs or to some heavy prerequisites (Roger Miller might be more accurate) , but
it'll be safer to jump from v6 to v8 or to V7 to V9 etc.... [...]
902 102 26_Re: DB2 v5 to V7 migration0_19_mike.holmans@BT.COM30_Thu, 8 Mar 2001 14:05:37 -0000650_- The IBM Technical Conference is currently taking place (or may just have finished) in Hamburg, Germany.
Mike Holmans BT ISE Database Services mike.holmans@bt.com
This post represents the views of the author and does not necessarily accurately represent the views of BT
> -----Original Message----- > From: John Hardy [SMTP:john_j_hardy@ANOTHER.COM] > Sent: Thursday, March 08, 2001 12:51 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] DB2 v5 to V7 migration > > Hamburgers? > > > On Thu, 8 Mar 2001 11:33:26 -0000, mike.holmans@BT.COM wrote: > > >I Have Heard, although I can't remember from where, that going the V5-V7 > [...]
1005 120 34_Re: -911 Cursor with hold. (Reply)13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Thu, 8 Mar 2001 08:05:17 -0600650_iso-8859-1 Another option I haven't seen anyone mention yet would be to use uncommitted read in program-B. This obviously means you will first want to check a couple things...
- What's being updated in program-A? - Does program-B care about the data being updated in program-A?
If program-B doesn't really care about the updates being performed in program-A (for example if the processes are looking at different rows/columns and are just getting hit by page-locks), then this might be a good place for uncommitted read (I would specify at the statement-level for those statements accessing the tables in contention). If program-B [...]
1126 134 32_Re: UDB V7.1 ... Export Question12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Thu, 8 Mar 2001 09:12:43 -0500429_iso-8859-1 Greg, My point exactly ... I've tried all the suggestions I've recieved(and appreciated recieving them! )... but nothing has worked. There doesn't seem to be a way to turn this 'feature' off when you need a delimeted file... I'm still looking for an easy way to do that... maybe I'll have to just issue the export command from an AIX prompt and pipe the output thru a unix filter before it writes the file. Randy [...]
1261 27 26_Re: DB2 v5 to V7 migration12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Thu, 8 Mar 2001 09:20:47 -0500577_iso-8859-1 We are/were hoping to migrate from V5 directly to V7 (against my recommendation I might add...I would prefer the v5-v6-v7 path because I am conservative and don't want to be on the bleeding edge of being one of the first shops to jump a release). The announcement and the pricing of utilities has put us into a tailspin with V7 implementation because of the nasty "b" word: budget. We didn't budget for utilities, and while we have a mix and match approach with 3rd party products, I believe that some of the 3rd party products invoke DB2 utilities (Example: I [...]
1289 71 26_Re: DB2 v5 to V7 migration16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 8 Mar 2001 09:37:51 -0500557_iso-8859-1 What about another tack? Rather than not purchasing the DB2 utils, point your BMC/Platinum etc tools to the IBM utils and dump the Platinum (CA) or BMC utils. I don't know about the BMC tools, but Platinum RC/Migrator has parms which tell it what utilities to use and where the model JCL resides. We are looking in that direction. We have had Platinum Quick Copy, Rapid Reorg, and Fast Unload for about 7 or 8 years. The IBM utils have improved enough that we are now very seriously looking into dumping the CA utils so that we send CA less [...]
1361 128 49_Re: Select Distinct vs Open Cursor and Fetch Once5_Chris17_isatcjk@YAHOO.COM30_Thu, 8 Mar 2001 06:38:10 -0800314_us-ascii Wow, It's like a light bulb came on in my head. And yes there are some where conditions on table1, but not enough filtering to avoid a tablespace scan. I've suggested adding three columns to a index on table1, so it's only scanning all 1000 pages of index, rather than all 14000 pages of tablespace. [...]
1490 50 30_Re: Read Oracle DB from OS/39013_Tzachi Nissim21_tzachi@ATTUNITY.CO.IL30_Thu, 8 Mar 2001 16:53:46 +0200526_iso-8859-1 Hi Terry,
You can do this using Attunity Connect (www.attunity.com). This product supports a multitude of platforms and databases (including non-relational). You install it on any machine you either have data on, or an application that wants to access data. This creates a sort of "data network" in which any node can be a client or a server or both. So you could access Oracle/Unix from your os390, and vice versa. BTW - it also allows you to do heterogeneous joins between your different datasources. [...]
1541 151 42_Re: Create Tablespace/Index with DEFINE NO14_Grainger, Phil20_Phil.Grainger@CA.COM30_Thu, 8 Mar 2001 15:13:03 -0000502_iso-8859-1 Of course,
OUCH!!
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: Kornblum, Kenneth [mailto:Kenneth_Kornblum@BMC.COM] Sent: 07 March 2001 22:20 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Create Tablespace/Index with DEFINE NO
Hi Phil!
Since you've chimed in on this, then I'll feel free to as well. [...]
1693 36 23_using blobs with cobol?9_John Cops31_John.Cops@HERITAGEINSURANCE.COM30_Thu, 8 Mar 2001 09:37:36 -0600349_us-ascii i am using db2 with cobol on an os/390.
i am attempting to read a file which contains a pdf and then insert it into a table using blobs.
i have put these in working storage just prior to my include sql statements:
01 ETEPDF-J-PDF USAGE IS SQL TYPE IS BLOB(1M).
01 PDF-LOC USAGE IS SQL TYPE IS BLOB_LOCATOR. [...]
1730 71 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?13_Tzachi Nissim21_tzachi@ATTUNITY.CO.IL30_Thu, 8 Mar 2001 17:39:13 +0200428_iso-8859-1 Hi Mike,
In ODBC there is a statement option called SQL_MAX_ROWS. If you use a driver which supports this option, BO will call SQLSetStmtOption and set SQL_MAX_ROWS to 200. Then the driver knows to only bring so many rows. It sounds like DB2 Connect doesn't support this option (it is not mandatory). If it did there would be no configuration needed for this to take affect. You can call IBM to find out. [...]
1802 178 42_Re: Create Tablespace/Index with DEFINE NO23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Thu, 8 Mar 2001 11:08:58 -0500582_iso-8859-1 Yesterday we had a situation in QA DB2 region, where a few partitions of a LARGE partition table were missing. Not just the physical dataset, but the OS/catalog entry too. We are still investigating what happened there, but I would not want DB2 to QUIESCE or REORG successfully in this case. I am not sure if DB2 internally would differentiate between this situation and the one where an object is defined with 'DEFINE NO'. As Issac pointed out the only way to identify if an object is created with 'DEFINE NO' is to look at SYSIBM.SYSTABLEPART.SPACE = -1. It seems [...]
1981 48 19_Select MAX strategy13_Eric THOUMIRE21_eric.Thoumire@NXBP.FR30_Thu, 8 Mar 2001 17:11:24 +0100445_iso-8859-1 Hi all, A bit strange thing to my taste. Let's consider a table named Table with an ASC index on columns A, B and C. A is the first column in the index. When one execute a SELECT MAX(A) FROM Table, DB2 access the MAX value by a NON MATCH INDEX SCAN. Why does it so ? Why doesn't it use a MATCH INDEX SCAN ? Why doesn't it look at the root of the index since the root must contain the MAX value of the first column of the index ? [...]
2030 202 42_Re: Create Tablespace/Index with DEFINE NO15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 8 Mar 2001 10:26:53 -0600373_iso-8859-1 Do you use SMS at your site? Is the management class set up to delete after a period of time? We have had that problem here in our QA environment.
Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin "Any sufficiently advanced technology is indistinguishable from magic." - Arther C. Clarke [...]
2233 105 23_Re: Select MAX strategy16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM30_Thu, 8 Mar 2001 11:30:03 -0500546_us-ascii
ASC = Ascending value sequence - lowest to highest ordering.
MAX function returns the highest value.
For optimized index utilization (i.e., when utilizing MAX function), define the index column as DESC (DESC = Descending value sequence - highest to lowest ordering).
Rick Molera
Mainframe DB2 DBA
Eric THOUMIRE on 03/08/2001 11:11:24 AM
Please respond to DB2 Data Base Discussion List [...]
2339 106 48_SQL Performance problem with Sequential Prefetch0_18_mebert@AMADEUS.NET30_Thu, 8 Mar 2001 17:34:35 +0100601_us-ascii Hi List,
This is a somewhat longish question, so if you've got time...
DB2 V5 (PUT level around 0006), OS/390 R2.8, no datasharing. Just now a batch program that had been running for 20.000 CPU seconds got cancelled. The previous days it had been running around 1.000 CPU seconds. The only difference, as far as I can tell, is that today a housekeeping job had not been run yet. The Job extracts rows from AIRBKGT-DETAIL table based on values in a smaller reference table. The AIRBKGT_DETAIL table is partitioned. Each partition holds one day of data. The data is inserted [...]
2446 76 23_Re: Select MAX strategy13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 8 Mar 2001 10:31:46 -0600327_iso-8859-1 Eric,
It cannot use a MATCH index scan since you have not specified any WHERE predicates for the index to match.
Why does it scan the entire index? Because the IBM developers have not written the code into DB2 to allow an INDEX-ONE-FETCH MAX on an ASC index (or MIN on a DESC index).....until V7. [...]
2523 80 23_Re: Select MAX strategy0_19_mike.holmans@BT.COM30_Thu, 8 Mar 2001 16:30:42 -0000290_iso-8859-1 It's a non-matching index scan because you haven't given it a value (or range of values) which it can actually match.
What you really need for SELECT(MAX) is a DESCENDING index, because then DB2 can do an I1 fetch in the way you're hinting it ought to be able to do. [...]
2604 27 41_Uncl: Problem with IVP job DSNTEJ75 in V610_Gary Albee23_ASMIGPA@VM7CG.HQ.AF.MIL28_Thu, 8 Mar 2001 11:27:28 EST569_- *** Forwarding note from ASMIGPA --PAFVMU 03/08/01 10:29 *** Date: 08 Mar 01 10:29:18 EST From: To: db2-l Subject: Uncl: Problem with IVP job DSNTEJ75 in V6
While running the IVP jobs migrating to DB2 V6 we have run into a syntax error at line 238 in the compile step of job DSNTEJ75 which is a C program testing LOBS. Unfortunately we do not have anyone with knowledge of the C language so if anybody else ran into this problem could you tell us how to correct it. This job is attempting to compile sample program [...]
2632 77 25_Re: Stored Procedure Help11_Jeff Brokaw20_jeffbrokaw@YAHOO.COM30_Thu, 8 Mar 2001 10:17:07 -0600291_- I've had good success with calling the stored procedure as a load module via a test app, running on the server, and using a debugger against the test app. Of course your test app must do the connect/open thread or equivalent to mimic the circumstances expected by a stored procedure. [...]
2710 19 17_insert with nulls10_Tom Taylor17_ttaylor@CHUBB.COM30_Thu, 8 Mar 2001 11:47:39 -0500472_us-ascii Hi I have a insert with nulls question
If I have a column defined as "char (8) nullable" and the value for that column is 'null'. What is logged during an insert full 8 characters or 1 null byte.
Tom
================================================ 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.
2730 48 26_Re: -911 Cursor with hold.11_Kwan, James18_James_Kwan@BMC.COM30_Thu, 8 Mar 2001 10:50:56 -0600338_iso-8859-1 Tom,
Your subject might mislead everyone who replied. I assume you have commits in program A since you are using WITH HOLD? May be the -911 has nothing to do with WITH HOLD. May be your program B issue a lock table statement. The bottom line is you need to provide more information in order for people to help you. [...]
2779 23 38_Create Tablespace/Index with DEFINE NO0_39_brian_holroyd.consultant@PEOPLESOFT.COM30_Thu, 8 Mar 2001 09:21:56 -0800390_us-ascii Troy, I have been told it is working as designed. See page 8 of the DB2 V7 utilities guide http://www-4.ibm.com/software/data/db2/os390/v7books.html
I would not define tablespaces with defer. Some customers do but are are checking the SPACE column for -1 before running tablespace utilities. Indexes are OK to defer define, but QUIESCE will fail unless it is WRITE NO. [...]
2803 100 42_Re: Create Tablespace/Index with DEFINE NO23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Thu, 8 Mar 2001 12:22:57 -0500606_- Yes...we use SMS and No the management class is not set up to delete DB2 datasets at all.
> -----Original Message----- > From: Billings, Linda [SMTP:linda.billings@DOA.STATE.WI.US] > Sent: Thursday, March 08, 2001 11:27 AM > To: DB2-L@RYCI.COM > Subject: Re: Create Tablespace/Index with DEFINE NO > > Do you use SMS at your site? Is the management class set up to delete > after > a period of time? We have had that problem here in our QA environment. > > Linda Billings > Enterprise Systems Programmer > Info-Tech Services > Department of Administration > State of Wisconsin > "Any [...]
2904 118 42_Re: Create Tablespace/Index with DEFINE NO15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 8 Mar 2001 11:32:31 -0600411_iso-8859-1 That is very wierd. I know that the SMS people should be able to tell if HSM deleted the data sets. I would check that anyway just to rule it out if you haven't done so already.
Linda
-----Original Message----- From: Jain, Sanjay (Exchange) [mailto:sanjayjain@BEAR.COM] Sent: Thursday, March 08, 2001 11:23 AM To: DB2-L@RYCI.COM Subject: Re: Create Tablespace/Index with DEFINE NO [...]
3023 85 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM30_Thu, 8 Mar 2001 09:35:31 -0800675_iso-8859-1 Does this SQL_MAX_ROWS option exist in JDBC as well?
Wayne Kline Ingram Micro
-----Original Message----- From: Tzachi Nissim [mailto:tzachi@ATTUNITY.CO.IL] Sent: Thursday, March 08, 2001 7:39 AM To: DB2-L@RYCI.COM Subject: Re: Accessing DB2 on OS/390 vs Oracle on AIX?
Hi Mike,
In ODBC there is a statement option called SQL_MAX_ROWS. If you use a driver which supports this option, BO will call SQLSetStmtOption and set SQL_MAX_ROWS to 200. Then the driver knows to only bring so many rows. It sounds like DB2 Connect doesn't support this option (it is not mandatory). If it did there would be no configuration needed for [...]
3109 31 23_Re: Select MAX strategy22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR30_Thu, 8 Mar 2001 14:34:06 -0300552_iso-8859-1 Terry said:
> It cannot use a MATCH index scan since you have not specified any WHERE > predicates for the index to match.
In DB2 V5 you can influence the optimiser by writing SELECT MAX(A) FROM Table WHERE A > 0 (I suppose all values of column A are greater than zero). DB2 will perform a Matching Index Scan with 1 matching index key. Although it looks better than a Non-Matching access, I would not recommend using it. I would prefer using a DESC index, because One-Fetch index access is faster than the other methods. [...]
3141 78 36_Re: EMC DASD and SEQCACH and SEQPRES12_Richard Pack23_rpack1@MAIL.STATE.MO.US30_Thu, 8 Mar 2001 11:42:18 -0600557_- On Thu, 1 Mar 2001 18:48:42 -0600, HARBRY ARIZA wrote:
> Eric: > > I think they asking you to do that because those new dasd devices has >the capability to use the benefits of cache with db2 without turnning on the >SEQCACH zparm to SEQ. I wasn't aware of it but as soon I started to change >one of our db2 subsystem Zparm from SEQCACH=BYPASS to SEQCACH=SEQ and then >I started to see a good hit cache ratio (almost higher than 90) but then I >started to do some monitoring to a different db2 subsystem with the SEQCACH [...]
3220 157 52_Re: SQL Performance problem with Sequential Prefetch20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 8 Mar 2001 13:49:33 -0500626_iso-8859-1 Dr.
Would it be possible to show us the query block # & PAGE_RANGE from the explain ?
-Venkat Pillay
> -----Original Message----- > From: mebert@AMADEUS.NET [SMTP:mebert@AMADEUS.NET] > Sent: Thursday, March 08, 2001 11:35 AM > To: DB2-L@RYCI.COM > Subject: SQL Performance problem with Sequential Prefetch > > Hi List, > > This is a somewhat longish question, so if you've got time... > > DB2 V5 (PUT level around 0006), OS/390 R2.8, no datasharing. Just now a > batch > program that had been running for 20.000 CPU seconds got cancelled. The > previous > days it had been [...]
3378 84 26_Re: -911 Cursor with hold.11_Tom Marcano23_marcano_db2@HOTMAIL.COM30_Thu, 8 Mar 2001 18:50:32 -0000
3463 58 55_Re: V7 Utility cost issues - Was DB2 v5 to V7 migration14_Grainger, Phil20_Phil.Grainger@CA.COM30_Thu, 8 Mar 2001 19:00:34 -0000512_iso-8859-1 Hot from Hamburg.
There are THREE 'families' of utilities in V7 (see the brand new "What's New" or the web for more details).
Two families contain utilities you pay for and one contains FREE utilities. The free ones tend to be those with no competition (CATMAINT(!), QUIESCE, REPORT, the stand-alone utilities).
BMC, in common with CA, probably use QUIESCE a lot to externalise data before processing further - this will still work at V7 as Quiesce will always be available. [...]
3522 29 47_s04e error on creation of Part IX - help please7_Sri Sri20_sri_db2l@HOTMAIL.COM30_Thu, 8 Mar 2001 12:48:39 -0600396_- Dear List ,
We are @ DB2 OS/390 V6.
The following is the error message i got while creating a partitioned index.
The system or user abend S04E R=00E50013 was issued. From compile unit DSNTEP2 at entry point DSNTEP2 at compile unit offset +0000131
This happens only in one of our development sub system. Is it that some PTFs are not applied for this sub system. [...]
3552 78 26_Re: DB2 v5 to V7 migration15_Murley, Michael22_Michael_Murley@BMC.COM30_Thu, 8 Mar 2001 13:07:47 -0600610_iso-8859-1 Robert,
BMC COPY PLUS for DB2* invokes the DB2 Copy utility in a couple of cases:
1. Image copy of the special table spaces whose copies are registered in the log rather than in SYSIBM.SYSCOPY:
- DSNDB01.DBD01 - DSNDB01.SYSUTILX - DSNDB06.SYSCOPY
2. A request to copy a table space SHRLEVEL CHANGE, RESETMOD YES.
Since all utilities will be available in the base DB2 product to work on DB2 catalog and directory spaces, case 1 should not be a problem. However, if you invoke COPY PLUS for case 2 on an application table space when the DB2 Copy utility is not [...]
3631 35 14_DB2 DBA Needed22_Fisher, Raymond (ITSC)27_raymond.fisher@MAIL.IHS.GOV30_Thu, 8 Mar 2001 12:05:32 -0700602_iso-8859-1 There is an immediate opening for a DB2 DBA in Albuquerque, NM at the Indian Heath Service National Database Office. Requirements are a minimum of two years experience with DB2 UDB running on a UNIX operating system, preferably AIX on RS6000 hardware. This position is to work in tandem with the IHS civil service DBA in the building and maintenance of national level DB2 databases in support of web based statistical reporting and trend analysis. Current system configuration consists of 1 RS6000 R50, 2 RS6000 S7As, 1 ESS 400G disk unit, 1 Dell Poweredge 6300 NT server, and 1 Compaq [...]
3667 12 18_Websphere on OS39010_Alan Bloss19_abloss@CAREMARK.COM30_Thu, 8 Mar 2001 12:55:07 -0600399_- Til now, we've been running Websphere on a middle-tier server. We're considering running it on the OS390. Anybody doing this? Feedback? Good idea? Trouble?
================================================ 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.
3680 130 26_Re: -911 Cursor with hold.0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 8 Mar 2001 13:18:55 -0600386_iso-8859-1 If you look up the Resource type, 304 is a Tablespace RID, so you are conflicting on a specific row of data. So you can either COMMIT more frequently, in both programs, or schedule them sequentially.
Tom Marcano @RYCI.COM> on 2001/03/08 12:50:32 PM Subject: Re: -911 Cursor with hold. Hello James, [...]
3811 44 22_Re: Websphere on OS39020_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 8 Mar 2001 14:33:16 -0500458_us-ascii The setup is very complex. The product on the OS/390 is in infancy compared to other platforms e.g. EJB is not supported etc.
Multiple versions are getting released quickly so stay with the new ones e.g. we tried with WAS 1.2 which was very different than WAS 3.0.2, now WAS 3.0.5 and WAS 4.1 is about to come. If one starts developing on older version, which supported JAVA 1.1.8 would have to migrate to JAVA 1.2 with higher releases. [...]
3856 132 26_Re: -911 Cursor with hold.23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Thu, 8 Mar 2001 14:37:52 -0500558_- Tom, The LOCKMAX value of 1000 may be causing a lock escalation to table/tablespace in program A, if it processes more than 1000 rows in the table PPP.
Sanjay Jain
> -----Original Message----- > From: Tom Marcano [SMTP:marcano_db2@HOTMAIL.COM] > Sent: Thursday, March 08, 2001 1:51 PM > To: DB2-L@RYCI.COM > Subject: Re: -911 Cursor with hold. > > Hello James, > > > The program B is not using any LOCK table statement , The program a uses > cursor with HOLD and has a commit at the end of the program , and I also > checked the RELCURH [...]
3989 16 54_Re: Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX11_Ruth Sutlic24_ruth.sutlic@DILLARDS.COM30_Thu, 8 Mar 2001 13:18:28 -0600459_- Judith, I was wondering if anybody had answered you offline on this request. I have a need something like this. The only thing that I can find that comes close is a product from ATTUNITY.
Regards, Ruth Sutlic
================================================ 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.
4006 47 50_Create Procedure DDL from SYSROUTINES and SYSPARMS14_Gregg Willhoit21_gwillhoit@NEONSYS.COM30_Thu, 8 Mar 2001 13:58:46 -0600126_- Does anyone know how to derive the original Create Procedure DDL from SYSROUTINES and SYSPARMS tables ?
Thanks, Gregg
4054 97 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Thu, 8 Mar 2001 14:04:57 -0600405_iso-8859-1 I don't know about SQL_MAX_ROWS, but JDBC does have a "setMaxRows()" method on statement objects. This will limit the number of fetches performed to the value specified for .
-----Original Message----- From: Kline, Wayne [mailto:wayne.kline@INGRAMMICRO.COM] Sent: Thursday, March 08, 2001 11:36 AM To: DB2-L@RYCI.COM Subject: Re: Accessing DB2 on OS/390 vs Oracle on AIX? [...]
4152 111 26_Re: -911 Cursor with hold.12_Jim Harrison17_jharrison@GMX.NET30_Thu, 8 Mar 2001 15:50:57 -0500498_us-ascii How long is B keeping that cursor open? How many records is it returning? As long as you mix updaters with readers you run the risk of this happening (I'm assuming someone's updating here because of the rollback message). We have a similar situation in a new application with batch jobs holding a cursor open while they are merging tape files - in the mean time, short batch jobs are trying to update and they get blown off because they can't get an X lock to do their update/insert. [...]
4264 19 14_DB2 Data Links13_Helen Johnson25_helen_johnson@RAC.RAY.COM30_Thu, 8 Mar 2001 14:57:58 -0600459_us-ascii Hi,
We are installing DB2 Data Links 6.1 on AIX on a pilot project next week. Are there any gotchas to look for? Any suggestions would be appreciated. Thanks,
Helen Johnson DBA Raytheon Aircraft
================================================ 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.
4284 200 26_Re: -911 Cursor with hold.12_tim malamphy20_timalamphy@YAHOO.COM30_Thu, 8 Mar 2001 13:33:10 -0800553_us-ascii Sanjay is correct, but I believe the 304 resource indicates a row level conflict. DB2 will commit at the end of your program anyway, when the job finishes, so you may as well save the 6 keystrokes it takes to code it there. I would consider this a job which does not take commits (ie just one big one at the end). You need to commit more frequently within the program when it logically makes sense. The smaller the unit-of-work (UOW), between commits, the fewer locks either job will hold. Having one big commit at the end makes it easier [...]
4485 41 27_DB2 Connect EE V7.1 Problem16_Maculsay, Gary R28_Maculsay.Gary@EMERYWORLD.COM30_Thu, 8 Mar 2001 21:46:58 -0000370_iso-8859-1 Background: we had previously installed DB2 Connect EE V6.1 on Solaris 2.6 using the manual install method. We were able to connect to our OS390 host without issue.
We then purchased DB2 Connect EE V7.1 - we used db2_deinstall to wax the old version's packages and rm'd the software. We then manually installed V7.1. The install was "successful". [...]
4527 73 31_Re: DB2 Connect EE V7.1 Problem12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Thu, 8 Mar 2001 16:05:01 -0600349_iso-8859-1 Two comments, one, we had a problem with the de-install program, which we solved by literally doing another install, then deinstall, then install, which was successful, and second comment is that the error message seems to point towards you did an install in a non-standard directory, which might somehow being causing difficulties. [...]
4601 27 19_Trigger Question...22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM30_Thu, 8 Mar 2001 14:06:11 -0800348_- When you issue a delete on Table A, we need to do an existence check on Table B and trigger a delete if the row exists. In reading the available manuals and books available we cannot find a reference to the existence checking piece for a trigger. We would like know if this can be accomplished by a trigger without using a stored procedure. [...]
4629 32 20_SQL Guru Help Needed11_David Nance16_DWNance@FHSC.COM30_Thu, 8 Mar 2001 17:08:49 -0500564_US-ASCII We have most of our application reports being done via QMF queries, procs and forms. One of our developers has a requirement that I haven't been able to help him figure out yet. This particular report wants a ranking by amount_saved, which we can do by ordering by amount_saved desc, using &row function on the form. The problem comes in when they want the list ordered alphabetically by provider. Does anyone have any ideas how we could give a row a ranking based on a particular column then order by another? We are OS390 V2.8, DB2 V6. Any help is [...]
4662 58 23_Re: Trigger Question...0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 8 Mar 2001 16:33:18 -0600377_us-ascii How about just setting up a Relational Constraint (Foreign Key) with a cascading delete from the parent table to the child. Delete from parent 'triggers' a delete from child.
Or don't worry about existence, unless you have to report on it, just execute a delete on the Child table and code to handle the SQLCODE -100 so that code treats it like SQLCODE 0. [...]
4721 73 26_Re: DB2 v5 to V7 migration64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM30_Thu, 8 Mar 2001 16:37:03 -0600363_ISO-8859-1 Hi Robert.
Utility vendors have all had, since IBM's annoucement at IDUG in May of 2000, the opportunity to identify and change (if need be) any dependencies on running IBM utilities that might not be there in the future.
As far as the impact of not requiring customers to purchase IBM utiltiies... Well, that would be the goal. :-) [...]
4795 232 26_Re: -911 Cursor with hold.23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Thu, 8 Mar 2001 17:36:47 -0500486_iso-8859-1 Tim, What I was saying was that program 'A' may have had a lock escalation and may have promoted its intent locks on the tablespace/table to mode X (provided, thus preventing prog 'B' from acquiring a row level lock on the same table, as the error message DSNT408I says.
Tom, One way to verify a lock escalation is to look for DSNI031I message. Statistics report on locking can also tell you if a lock escalation has occurred and if it caused a deadlock/timeout. [...]
5028 26 26_AIX UDB Mirror + Stripping11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Thu, 8 Mar 2001 16:36:53 -0600511_- Hi List,
Our shop is using AIX 4.3.3 and DB2 v6.1 I want to use LVM stripping & Mirror to eliminate high IO wait. But I heard two drawback of doing that: 1. We have 21 4.5GB disk and 6 9.1GB disk. If we strip them together, we will waste about 4.6 GB space for each 9.1 GB disk. 2. When the file system is getting full, we cannot just plug in a new disk and get free space. Instead, we have to strip all disks again, that means backup database, strip all existing file system and then restore the [...]
5055 63 54_Re: Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX11_Judy Kibler21_judith.kibler@TRW.COM30_Thu, 8 Mar 2001 16:59:44 -0600283_us-ascii Ruth,
So far, no one has responded. Probably, it was how I stated the question, so let me restate:
Can anyone share any wisdom on the fastest and safest way to transfer 60+ GB of DB2 v 5 for OS/390 2.6 data to a DB2 UDB v 6 on AIX 4.3.3?
TIA, Judy [...]
5119 121 25_Another Trigger question.22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM30_Thu, 8 Mar 2001 15:14:29 -0800584_iso-8859-1 Hi There Again.. We are attempting to mimic a data propagator function with the trigger below.. We are not sure if this can be done and have run into the following error when trying to create the trigger. The full trigger syntax is listed below this error message. We know the insert statement is correct because we have created an insert trigger that works with the same statement. There is not a parent/child relationship between these tables. We are trying to do an existence check with the select count. Since we aren't sure about returning a postive 100 SQL code [...]
5241 28 24_Purging/archiving Survey13_Zessin, Peter25_Peter.Zessin@ATCOITEK.COM30_Thu, 8 Mar 2001 16:15:38 -0700381_- We are in the beginning stages of a purging/archiving project for a utility cis/billing application.
Our company is deciding whether to build in-house or purchase one of the purge/archiving tools on the market.
We would like tap the combined knowledge of the great DB2-L brotherhood: 1) Who uses vendor tool ? Which one ? 2) Who uses in-house developed tool ? [...]
5270 103 23_Re: Trigger Question...24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Thu, 8 Mar 2001 15:35:13 -0800644_- Additional information about the problem:
There is no parent/child relationship between these two tables. What we have is an 8 million row table which is feeding data to an Oracle Financials database through the Oracle Transparent Gateway. The financials application only needs data that has been inserted or updated within the recent past, i.e., since the last update to the financials application which is a daily process. Since this update job runs for several hours, we created a much-smaller, look-alike table. The Oracle process will then process the smaller table which will contain about 2,500 rows between runs, and will [...]
5374 49 21_Re: insert with nulls15_Di Carlo, Donna23_Donna_Bermender@BMC.COM30_Thu, 8 Mar 2001 17:47:14 -0600437_iso-8859-1 An insert into a nullable CHAR(8) would be logged like this for a table space or index (ascending):
FF0000000000000000 null 00C4D6D5D5C1404040 value of DONNA
An insert into a nullable VARCHAR(8) would be logged for the table space as follows:
0001FF null 000600C4D6D5D5C1 value of DONNA
An insert into a nullable ascending VARCHAR(8) for an index would look like the nullable CHAR(8) example. [...]
5424 64 28_Re: Purging/archiving Survey24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Thu, 8 Mar 2001 15:47:41 -0800581_- Finally a question to which I can respond in a meaningful way!
We've recently addressed this very issue. The task of writing a purge process is fairly straight-forward. You select the stuff to be purged, and write it out to some type of extract/archive file. Of course, you need to write one of these for each application for which you need to archive data. And naturally, you will need to maintain the archive programs. The difficult part is if you need to retrieve the archived data. As long as the data structures remain static, this is fairly simple. However, as [...]
5489 52 26_Re: DB2 v5 to V7 migration15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Fri, 9 Mar 2001 10:50:01 +1100463_- Hi Robert,
I think some of the vendors have already replied, but I know in tools like RC/Migrator and Change Manager you can specify whether you want the CA/BMC version of a utility to run or the IBM one. The copy utility is an example of this, as is runstats (at least for BMC). So you could go one of two ways: ditch the ISP utilities and use IBM's, or ditch IBM's utilities and use the ISP's. Depending on how IBM group the utilities, of course. [...]
5542 89 54_Re: Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX11_Robert Jans26_robert_jans@ALBERTSONS.COM30_Thu, 8 Mar 2001 16:52:51 -0700312_iso-8859-1 Well, at the risk of showing how much I've forgotten, we use to do about 5 GB a night from DB2 V4 to DB 2.1 on AIX in about 8 hours using AIX DB2 EXPORT/IMPORT....
I'd think you should be able to easily achieve that performance with current technologies, I actually expect better......... [...]
5632 118 29_Re: Another Trigger question.15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM30_Fri, 9 Mar 2001 11:59:03 +1100371_- We're on OS/390 and I don't believe we can nest WHEN's like that, we'd do something like the following (apologies if it doesn't work). We also tend not to use BEGIN ATOMIC . . . END with single Triggered statements and incidentally we've also found that some utilities (eg BMC CM) may not like the ';' embedded in the Trigger to terminate the triggered statement. [...]
5751 70 38_Altering CCSID for Database/Tablespace15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM30_Fri, 9 Mar 2001 12:57:25 +1100409_- We've just migrated to DB2 V6 on OS/390 and are beginning to use the new functionality. When we create some Triggers in a database created prior to V5.1 we get SQL code -189 complaining about missing '00000' SYSTRINGS entry as shown below. This only happens when the trigger references transition variables of type character and the table is in a database/tablespace both of which have SBCS_CCSID = 0. [...]
5822 49 26_Re: DB2 v5 to V7 migration14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 9 Mar 2001 14:17:05 +1100452_iso-8859-1 Doubt that this is really a problem. There are two situations - the optimizer is producing a bad, considering the statistics, access path. Will it really matter if the statistics were generated by RUNSTATS, vendor-STATS or "UPDATE ... SET stats= ..."? Doubt it, support should still "accept" the statistics - even if they don't "trust" them. - Are the statistics correct? If you don't use RUNSTATS, then it's not IBM support's problem. [...]
5872 33 29_UDB Trial copy and Windoze 9814_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU30_Fri, 9 Mar 2001 14:23:14 +1100678_iso-8859-1 **************************************************************** IMPORTANT
The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...]
5906 50 27_Re: using blobs with cobol?14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 9 Mar 2001 14:39:40 +1100403_iso-8859-1 Could you also post the SQL that uses these?
-----Original Message----- From: John Cops [mailto:John.Cops@HERITAGEINSURANCE.COM] Sent: Friday, 9 March 2001 2:38 To: DB2-L@RYCI.COM Subject: [DB2-L] using blobs with cobol?
i am using db2 with cobol on an os/390.
i am attempting to read a file which contains a pdf and then insert it into a table using blobs. [...]
5957 124 30_Re: AIX UDB Mirror + Stripping11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM30_Thu, 8 Mar 2001 23:41:28 -0500572_us-ascii Hi Richard,
Let me begin with a rhetorical question--- are you trying to solve the problem or treat a symptom?
In looking at probably hundreds of different DB2 UDB databases over the last six years, it's a pretty rare event to find an OLTP database (I'm assuming OLTP, if my memory is correct regarding your system) that genuinely has a physical I/O problem. If I/O throughput appears to be the problem, it is most often a symptom of a larger problem, the larger problem being SQL with access strategies involving scans vs. logical random I/O. [...]
6082 144 24_Re: Table Comparison SQL13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 8 Mar 2001 23:12:21 -0600613_iso-8859-1 Jim,
If you are after a pure SQL approach (although the below responses may fit your requirement perfectly)....
Then you could possibly run a query against the catalog tables to generate a compare SQL for every table combination in the 16 regions such as:
SELECT CASE KEYSEQ = 1 THEN 'SELECT A.*, B.* FROM ' CONCAT A.TBCREATOR CONCAT '.' CONCAT A.TBNAME CONCAT ' A FULL JOIN ' CONCAT B.TBCREATOR CONCAT '.' CONCAT B.TBNAME CONCAT ' B ON A.' CONCAT A.KEYSEQ CONCAT ' = B.' CONCAT B.KEYSEQ ELSE 'AND A.' CONCAT A.KEYSEQ CONCAT ' = B.' CONCAT B.KEYSEQ END FROM SYSIBM.SYSCOLUMNS [...]
6227 61 23_Re: Select MAX strategy13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 8 Mar 2001 23:17:07 -0600464_iso-8859-1 Claudio,
I'm not sure I understand what you are trying to achieve. Whether this is matchcols 1 or 0 (matching or non-matching scan), exactly the same number of index leaf pages are read....so why add the redundant predicate? To make the explain output look better?
Redundant predicates can influence the optimizer, but in this example it does not change the access path; so nothing was influenced. This is not exclusive to V5 either. [...]
6289 227 49_Re: Select Distinct vs Open Cursor and Fetch Once11_Richard Tan19_richtan@AU1.IBM.COM30_Fri, 9 Mar 2001 14:45:55 +1000363_us-ascii Terry, David:
We used the following for existance checking: SELECT COUNT(*) FROM TABLE1 WHERE EXISTS (SELECT 1 FROM TABLE2, TABLE3 WHERE ..... )
Where TABLE1 only has one row.
Would it be better use the following and then check for SQLCODE 0 and -811? SELECT 1 FROM TABLE1 TABLE2 WHERE ......
Regards Richard Tan [...]
6517 91 24_Re: Index not being used13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 8 Mar 2001 23:32:48 -0600583_iso-8859-1 James,
If explain shows index access and run time shows a tablespace scan, then it is unlikely to be a datatype mismatch.
It could possible be due to REOPT(VARS), as Rick mentioned; an incremental bind due to an index being dropped; or could be that the original query utilized list prefetch (L in the plan_table prefetch column), but at run time one of the many RID limits were exceeded and the query resorted to a tablespace scan. From memory (can't remember exactly, but near enough is good enough), it is 16 million RIDs, or 50% of the RID pool, or [...]
6609 70 24_Re: SQL Guru Help Needed13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 8 Mar 2001 23:50:59 -0600343_us-ascii David,
Unfortunately for OS/390 DB2 I can only offer you a SQL statement that gets exponentially worse as the number of rows increases.......so what I am trying to say is that I haven't figured out a way to do this efficiently and purely in OS/390 DB2 SQL (non-OS/390 is simpler and more efficient). But this should work: [...]
6680 91 49_Re: Select Distinct vs Open Cursor and Fetch Once15_Corrigan, David31_David.Corrigan@TEAM.TELSTRA.COM30_Fri, 9 Mar 2001 17:51:54 +1100544_- > Richard, > > Looking at the 2 queries, I offer the following: > > Firstly lets look at your existing SQL. I am assuming that the subselect > in this case is a non-correlated Subselect. That being the Case DB2 will > action that select first returning all rows which meet the given > predicates. Only after retrieving all rows for the subselect will DB2 look > at the outer select and evaluate the existence clause. Therefore if you > have 1000 rows which meet the sub select conditions, DB2 will retrieve all > 1000 rows and then look [...]
6772 21 15_Existance check12_Isaac Yassin20_yassini@BEZEQINT.NET30_Fri, 9 Mar 2001 09:49:13 +0200425_iso-8859-1 Hi, I've put a short ppt on the documents server about existance checks. Enjoy .
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@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.
6794 71 16_Re: avg subquery0_24_db46@DAIMLERCHRYSLER.COM30_Mon, 5 Mar 2001 16:39:47 -0500481_us-ascii That's because it is in the subquery. If you have version 5 or higher try this:
SELECT AVG (T1.SSCOUNT) FROM (SELECT COUNT(*) AS SSCOUNT, SS_NUM FROM DB2TEST.CUSTOMER GROUP BY SS_NUM) AS T1 WITH UR;
Dean
"Derez D. Lusk" @RYCI.COM> on 03/05/2001 10:36:32 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
6866 113 49_Re: Select Distinct vs Open Cursor and Fetch Once12_Troy Coleman19_Colematr@MEIJER.COM30_Mon, 5 Mar 2001 16:57:29 -0500521_US-ASCII Hi Shery, Yes I did hear Roger mention that for existence checks or just give me the first occurrence of a row then you may not get the data you are expecting. However, the question to ask is if you know you should only have one row then you should handle the error condition. If the business requirement is to report on this error then do so. If you must get valid data then you can perform a cursor to get one of the many rows. However, what is in the row when you have duplicates ??? The SELECT DISTINCT [...]
6980 28 67_What are the Requirements, Tips & Tricks for monitoring Dynamic SQL13_Carlton Enuda24_carltonenuda@HOTMAIL.COM30_Mon, 5 Mar 2001 17:38:51 -0500531_- Hi DB2 Listers, We are about to begin a process to give a measure of quality assurance to a large set of "Dynamic" SQL statements( SQL fired from a powerbuilder application) by explaining and tunning. I don't even know if we have a problem with the SQLs the way there are now. Anyway, my question is: What needs to be in place to monitor Dynamic SQL? Are there any special tips and tricks specific to dynamic SQL? How can you go about measuring performance or any other kind of improvement? Any and all will be appreciated. [...]
7009 57 33_Re: DB2 OS/390 V6 : SQL CODE -53112_Mckay, Wayne24_Wayne.Mckay@ATCOITEK.COM30_Mon, 5 Mar 2001 15:20:18 -0700449_- Ed
What RI do you have on Column D?
-----Original Message----- From: Ed_Vetock@NAVYFEDERAL.ORG [SMTP:Ed_Vetock@NAVYFEDERAL.ORG] Sent: Monday, 05 March, 2001 11:46 AM To: DB2-L@RYCI.COM Subject: DB2 OS/390 V6 : SQL CODE -531
To all,
We're stumped. We've uncovered a probable error during updates of a table . We receive SQL -531. We understand what a -531 is but believe we should not be getting it. Let me exlain: [...]
7067 119 49_Re: Select Distinct vs Open Cursor and Fetch Once10_Shery Hepp17_schepp@SRPNET.COM30_Mon, 5 Mar 2001 15:29:22 -0700379_iso-8859-1 Hi Troy- Glad my memory hasn't totally gone down the drain. And yes we both agree that a select distinct is expensive- especially if the app doesn't really care what is returned. However if the app is dependent on the result set a cursor may be the best way to go. And yes if IBM decides to close that loop hole it would be great if they let us know before hand. [...]
7187 61 54_Re: IBM TXSeries CICS to use DB2 as a resource manager18_Gert van der Kooij15_geko@WANADOO.NL30_Mon, 5 Mar 2001 23:55:24 +0100323_iso-8859-1 Hi,
(Assuming you are running on Unix or NT ) If you have your CICS queues managed in DB2 you can run the XA interface in One Phase Commit. Check the cicsdb2conf command for the right option or define it using the TXSeries Administration Tool. If you're running on OS/390 Im afraid I can't help you. [...]
7249 72 28_Re: Performence Issue - Help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Mon, 5 Mar 2001 17:36:05 -0600295_us-ascii Santha,
There are a number of techniques, such as using OPTIMIZE FOR n ROWS, or ORDER BY STS, or fiddling the catalog stats. I am not a fan of any of those techniques, unless the OPTIMIZE clause states the required number of rows required by the program (and not simply 1). [...]
7322 51 23_Re: db2 governor on AIX19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Mon, 5 Mar 2001 21:46:24 +0000386_US-ASCII Richard,
Take a look at SQL-GUY from Database-GUYS Inc. (www.database-guys.com).
It allows you to very quickly spot the "bad" SQL. Maybe not prevent it from running, but certainly track bad SQL for tuning purposes.
Using it for a couple of months has had some impressive effects on our server.
HTH
Phil Nelson Senior DBA Scottish Widows [...]
7374 176 13_Re: Rollbacks13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU30_Tue, 6 Mar 2001 09:57:33 +1100463_iso-8859-1 Thanks for the reply Sanjeev. I also believe that if the rollback is not needed it should not be performed, but unless I can provide some evidence that it is an overhead it won't be changed.
Are there other Coolgen sites that have a high number of rollbacks?
Shaun
-----Original Message----- From: S, Sanjeev (CTS) [mailto:SSanjeev@CAL.COGNIZANT.COM] Sent: Monday, 5 March 2001 16:14 To: DB2-L@RYCI.COM Subject: Re: Rollbacks [...]
7551 90 28_Re: Performence Issue - Help16_Santha Narayanan25_santha@GWMAIL.STATE.NV.US30_Mon, 5 Mar 2001 16:00:50 -0800380_US-ASCII Thanks, Terry
>>> Terry Purcell 03/05 3:36 PM >>> Santha,
There are a number of techniques, such as using OPTIMIZE FOR n ROWS, or ORDER BY STS, or fiddling the catalog stats. I am not a fan of any of those techniques, unless the OPTIMIZE clause states the required number of rows required by the program (and not simply 1). [...]
7642 25 22_Re: Return Code on CAF12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Mon, 5 Mar 2001 16:18:39 -0600313_us-ascii We identified the cause of the error. We run various level of DB2 for testing purposes. Hands got crossed and we executed the proc for one level on the another level of DB2. We still can not find the documentation for a return code 8.
Gerald Hodge HLS Technologies, Inc. 888-494-9019 [...]
7668 118 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Mon, 5 Mar 2001 17:18:49 -0600480_us-ascii Troy/Shery/Chris,
It is explicitly coded in the DB2 manuals that when more than one row qualifies from a singleton select, then the retrieved result is unpredictable and cannot be relied upon. This is not a recent addition to the manual....therefore IBM has already told DB2 users not to use this "feature". I liked one of Roger's quotes so much, that I have forgotten it....it was something about "we can't tell people not to stick something in their ears". [...]
7787 197 49_Re: Select Distinct vs Open Cursor and Fetch Once14_Richard Yevich17_ryevich@YAHOO.COM30_Mon, 5 Mar 2001 16:32:04 -0800393_us-ascii All,
(1) When you get a -811, the results of the singleton query cannot be depended upon. It has been this way since 1.1, and will not change since it is a negative return code, and by definition, you can never depend on the results being accurate when there is a negative SQLCODE. IBM has stated many times, that it will not change the meaning of a negative return code. [...]
7985 23 18_Re: DB2 monitoring11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Mon, 5 Mar 2001 11:22:41 -0600371_- Jim,
I also noticed snapshot for dynamic sql is not reliable. Sometime there's no execution time or cpu time. And since the snapshot pulls the information from statement cache which stores packages and statistics for frequently used SQL, so I doubt the snapshot can provide information for all the SQLs for a whole day (Usually 5 million SQLs in our shop). [...]
8009 26 19_db2 governor on AIX11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Mon, 5 Mar 2001 15:06:41 -0600548_- Hi List,
I'm looking for a way to prevent bad SQLs (in terms of cpu usage) from running on our production database. We're a little concerned about using DB2 governor for that purpose, since what the governor does is to limit the number of CPU seconds that can be consumed by an application instead of a SQL. The consequence of that is, Say, If one application has many simple queries, the total cost will eventually reach the CPU limit by the end of the day even though the cost of every single SQL is little. We want to capture only [...]
8036 49 41_Re: "SQL Solutions for a DBA's wish list"11_Suresh Sane21_data_arch@HOTMAIL.COM30_Mon, 5 Mar 2001 20:48:40 -0600665_- Carlton - you can download it from my website:
www.database-architects-inc.com
If you any trouble, send me an email offline and I will send you a ppt.
Thanks for your interest.
Suresh
>From: Carlton Enuda >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: "SQL Solutions for a DBA's wish list" >Date: Mon, 5 Mar 2001 12:36:31 -0500 > >Hi Listers, Mr. Sane, >I will like to get a copy of the May 2000 IDUG NA conference presentation >titled "SQL Solutions for a DBA's wish List" by Suresh Sane. Could someone >share with me a copy of the presentation? [...]
8086 32 45_Select Distinct vs Open Cursor and Fetch Once5_Chris17_isatcjk@YAHOO.COM30_Mon, 5 Mar 2001 12:29:47 -0800426_us-ascii Hello everybody, I have a query that should only get one meaningful row and is doing a SELECT DISTINCT for some strange reason.
In anycase, in general, if you only want to get one row, and your result set doesn't have to materialize, and all the rows in the result set are equal, is it faster to run a SELECT DISTINCT (on a small number of rows) or is it faster to simply open a cursor and fetch one row? [...]
8119 48 15_Re: UDB backups14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU30_Mon, 5 Mar 2001 18:58:35 -0600658_iso-8859-1 Hi,
We run our backups to disk, and then use ADSM to copy this to tape (VTS really) on OS/390. I think with the right vendor software you can do this directly in the backup, but don't quote me!
Regards,
Greg Palgrave Database Administrator Unisys WEST eMail : greg.palgrave@unisyswest.com.au
> -----Original Message----- > From: DB2 Data Base Discussion List @BANKWEST On > Behalf Of "Toppins, Smike" @BANKWEST > Sent: Saturday, 3 March 2001 04:10 > To: DB2-L@RYCI.COM > Subject: UDB backups > > Is it possible (via DB2 Connect or some other tool) to run an image copy > and [...]
8168 37 50_IBM TXSeries CICS to use DB2 as a resource manager11_Mike Fatula17_mfatula@PHEAA.ORG30_Mon, 5 Mar 2001 15:51:49 -0500384_us-ascii We are receiving some sql0918 with online transactions.
SQL0918N Application must execute a rollback.
Cause: The unit of work has already been rolled back in the database but other resource managers involved in this unit of work might not. To ensure integrity of this application, all SQL requests will be rejected until the application issues a rollback. [...]
8206 37 29_DB2 OS/390 V6 : SQL CODE -5310_25_Ed_Vetock@NAVYFEDERAL.ORG30_Mon, 5 Mar 2001 13:45:54 -0500420_us-ascii To all,
We're stumped. We've uncovered a probable error during updates of a table . We receive SQL -531. We understand what a -531 is but believe we should not be getting it. Let me exlain:
- Table A is parent table with a Primary Key on COLA - Table B is the child table. It has one index allowing duplicate values on COLA - The Referential Integrity is on COLA between Table A and Table B. [...]
8244 106 33_Re: DB2 OS/390 V6 : SQL CODE -53116_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Tue, 6 Mar 2001 09:38:04 +0530479_- Ed,
I just looked at the definition of -531 in the manual and found some difference in its explaination for V5 and above and prior to V5. Is this something related to this ?. I am not sure because COLD is not the part of the key. Otherwise, is this a bug because of this difference in implementation ? But why is this only with COLD(Doesn't like it !!). I believe there is nothing better than rechecking it otherwise someone will share his/her experience with you. [...]
8351 32 12_avg subquery13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM30_Mon, 5 Mar 2001 09:36:32 -0600389_us-ascii hi, we need to gather some information a table has the field ss_num which is a char(9) we need to find out the avg number of ss_num on the table. the avg function can only be performed numeric data
this query is invalid
SELECT AVG(SSCOUNT) FROM DB2TEST.CUSTOMER WHERE SS_NUM IN (SELECT COUNT(*) AS SSCOUNT,SS_NUM FROM DB2TEST.CUSTOMER GROUP BY SS_NUM) WITH UR; [...]
8384 55 16_Re: avg subquery12_Troy Coleman19_Colematr@MEIJER.COM30_Mon, 5 Mar 2001 14:49:42 -0500555_US-ASCII I'm not sure what your doing. However, you need to use a table expression to get the results based on your query below:
SELECT AVG(STBL.sscount) FROM (SELECT ss_num, COUNT(*) AS sscount FROM db2test.customer GROUP BY ss_num) STBL WITH UR
Troy Coleman Coleman Consulting, Inc.
>>> ddlusk@HOUSEHOLD.COM 03/05/01 10:36AM >>> hi, we need to gather some information a table has the field ss_num which is a char(9) we need to find out the avg number of ss_num on the table. the avg function can only be performed numeric data [...]
8440 69 18_Re: DB2 monitoring11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Mon, 5 Mar 2001 11:22:42 -0600652_- On Fri, 2 Mar 2001 14:22:26 -0500, Jim Fletcher wrote:
>You might try experimenting with the GET SNAPSHOT FOR DYNAMIC SQL ON dbname >command, if you >are running V6 or later. My testing has shown the output to be unreliable >though, with some statements showing >CPU usage but no executions, very high number of compilations immediately >after resetting monitor data in a >test environment with no users, etc. This would be a powerful tool for >identifying problem statements if it could >be counted on. > >Richard Yan @RYCI.COM> on 03/02/2001 01:42:28 PM > >Please respond to DB2 Data Base [...]
8510 33 24_Performence Issue - Help16_Santha Narayanan25_santha@GWMAIL.STATE.NV.US30_Mon, 5 Mar 2001 14:32:34 -0800336_US-ASCII Hello Everybody,
I have a simple query and when i do a SQL EXPLAIN the ACCESSTYPE is 'R'. How do i make my sql to be Indexed. Alternate Index created on this Table (table1) is: Index Name Column Name ------------------ ------------------ IA00390A STS
SQL : select * from db25.table1 where sts in ('DB','EV') [...]
8544 55 34_Re: Inserting DB2 Data into Oracle13_Olson, Carlos14_COlson@QRS.COM30_Mon, 5 Mar 2001 10:48:09 -0800435_iso-8859-7 There's a Redbook called 'My Mother Thinks I'm a DBA! Cross-Platform, Multi-Vendor, Distributed Relational Data Replication with IBM DB2 DataPropagator and IBM DataJoiner Made Easy!' It provides several case studies which may be similar to your scenario. Carlos Olson Database Administrator QRS Corporation 1400 Marina Way South Richmond, California 94804 email: colson@qrs.com http://www.qrs.com [...]
8600 161 49_Re: Select Distinct vs Open Cursor and Fetch Once12_Troy Coleman19_Colematr@MEIJER.COM30_Mon, 5 Mar 2001 18:38:42 -0500632_US-ASCII Thanks Terry, I had forgot about the Fetch For 1 Row. Maybe they "IBM" know not to setup a CURSOR and invoke the extra API calls with this option.
Troy Coleman
Coleman Consulting, Inc.
>>> Terry_Purcell@YLASSOC.COM 03/05/01 06:18PM >>> Troy/Shery/Chris,
It is explicitly coded in the DB2 manuals that when more than one row qualifies from a singleton select, then the retrieved result is unpredictable and cannot be relied upon. This is not a recent addition to the manual....therefore IBM has already told DB2 users not to use this "feature". I liked one of Roger's quotes so much, that I [...]
8762 109 28_Re: Performence Issue - Help16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Tue, 6 Mar 2001 10:08:25 +0530557_- Terry,
It seems you were returning after delivering some lectures on the SQL tuning and wrote everything out here. All the contents are mentioned quite nicely. Thanks a lot !
Santha,
As Terry mentioned, i would just like to see the cardinality of the column involved in the WHERE predicate i.e "sts". I am sure it must be having very less distinct value. If that is not the case, then RUNSTAT is not at all run. I am 90% sure problems will be solved by this time. If not, apply the tricks given by Terry and then go for tweaking [...]
8872 84 15_Re: DB2 Connect16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV30_Mon, 5 Mar 2001 14:21:09 -0700412_iso-8859-1 DB2 Connect's fixpak is included with the DB2 UDB fixpak. When you install the fixpak it will only install those items relating to the software you have installed, at least that is how it worked for me.
Duane
-----Original Message----- From: Hilton, Tina, BmS - NMI -PM [mailto:Tina.Hilton@BMSUS.COM] Sent: Monday, March 05, 2001 1:44 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect [...]
8957 147 34_Re: Inserting DB2 Data into Oracle13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US30_Mon, 5 Mar 2001 14:45:08 -0500549_US-ASCII Thank you Carlos,
I will check into the Redbook.
Burge
>>> COlson@QRS.COM 03/05/01 01:48PM >>> There's a Redbook called 'My Mother Thinks I'm a DBA! Cross-Platform, Multi-Vendor, Distributed Relational Data Replication with IBM DB2 DataPropagator and IBM DataJoiner Made Easy!' It provides several case studies which may be similar to your scenario. Carlos Olson Database Administrator QRS Corporation 1400 Marina Way South Richmond, California 94804 email: colson@qrs.com http://www.qrs.com [...]
9105 66 15_Re: DB2 Connect27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Mon, 5 Mar 2001 15:44:06 -0500500_iso-8859-1 I see the fixpak for DB2/UDB, but not one for Connect. Or is it one of the clients? None of them sound like they would be for Connect.
TIA,
Tina
-----Original Message----- From: Carroll, Ouida [mailto:Ouida.Carroll@BCBSLA.COM] Sent: March 05, 2001 11:43 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect
Here is the web site where the DB2 Connect fix packs are: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/download .d2w/report [...]
9172 131 29_Re: Latin and other languages14_Richard Yevich26_Richard_Yevich@YLASSOC.COM30_Mon, 5 Mar 2001 12:01:29 -0600626_iso-8859-1 What this thread reminds me of...
Logica defecta stercus tauri explorandus est!
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > McClendon, Rick > Sent: Monday, March 05, 2001 11:47 AM > To: DB2-L@RYCI.COM > Subject: Re: Latin and other languages > > > Hey - I have a dictionary here with some Latin in it(?!?) Well, maybe this > falls under "Other" languages. > > If You Do Not Understand Any of Them, Contact Your Closest Southern Bubba > for an Explanation..... > > Y'ALLBONICS/ENGLISH DICTIONARY > > HEIDI - (noun) -Greeting. > > [...]
9304 100 15_Re: DB2 Connect27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Tue, 6 Mar 2001 06:46:54 -0500451_iso-8859-1 Thanks. We didn't know it worked that way.
Tina
-----Original Message----- From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: March 05, 2001 4:21 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect
DB2 Connect's fixpak is included with the DB2 UDB fixpak. When you install the fixpak it will only install those items relating to the software you have installed, at least that is how it worked for me. [...]
9405 69 49_Re: Select Distinct vs Open Cursor and Fetch Once5_Chris17_isatcjk@YAHOO.COM30_Tue, 6 Mar 2001 06:59:18 -0800347_us-ascii Hello Everyone, Since there seems to be a lot of interest in existence checking queries here's a twist. I've copied my latest finding on the topic...
I've conferred with the original designer, and one of the three tables in the join is optional. If the two other tables provide a match, the third doesn't have to be examined. [...]
9475 70 33_Re: Control center for DB2 OS/39012_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Tue, 6 Mar 2001 09:22:35 -0600518_iso-8859-1 We are paying for DB2 Connect V6 and yes we have a contract for it. DB2 V6 does come with DB2 Connect but it is not as robust version of Connect as DB2 Connect EE that we are paying for separate from UDB DB2 V6. Are you talking about DB2 V6 on the mainframe? If so I would also question how well it performs vs DB2 Connect EE since the DB2 Connect on UDB V5 performs poorly with alot of users and is only a Personal edition meaning we could not distribute it on separate servers. I would be interested [...]
9546 31 43_any tools for moving InterBase data to DB2?12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 6 Mar 2001 06:14:24 -0800534_us-ascii Anyone out there loading or propagating InterBase (Borland) data into UDB tables? What do you use?
tia, Tim > ================================================ > 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.
__________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ [...]
9578 21 26_Input to Stored Procedures11_Tom Koerner25_Tom.Koerner@METAVANTE.COM30_Tue, 6 Mar 2001 06:53:38 -0600501_us-ascii We are currently using Stored Procedures to send data from the mainframe to a Powerbuilder client application. Now we want to be able to send update transactions from the client into a stored procedure. To minimize the number of trips to the host, we are looking for a way to send 1 to n records as input to a stored procedure (similar to a cursor input) but have not been able to find a way to do that. If there is way, we would be interested in hearing about it. Thanks for your help. [...]
9600 26 38_It's here >>> DB2 v7 for z/OS & OS/39013_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 6 Mar 2001 10:07:35 -0500773_iso-8859-1 See http://www.ibmlink.ibm.com/ibmlink?xu=guest&xh=logon&request=usa.announcemen ts&parms=Q and select IBM DB2 UDB Server....
Planned Availability Date
March, 30, 2001
David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@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.
================================================ 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.
9627 62 52_Re: Stored Procedure Error Message DSNX962I DSNX9SER8_Rob Lake29_robert.q.lake@PAC.ERICSSON.SE30_Tue, 6 Mar 2001 06:34:53 -0600406_- Hi,
I notice that your COBOL stored procedure is defined as a SUB-program.
In order to run in a DB2-managed SPAS you can only run stored procedures as type MAIN (see chapter 5-13 DB2 UDB for OS/390 V6 Administration Guide for differences between DB2- and WLM- managed SPAS).
Cheers,
Rob
On Thu, 1 Mar 2001 18:26:22 -0600, Karl Haynes wrote: [...]
9690 33 21_DB2 Bind error in CAE16_Daniel Gillieron23_daniel.gillieron@AGI.CH30_Tue, 6 Mar 2001 16:44:45 +0100488_us-ascii Hello
I want to bind the utilities of the CAE, and I receive the following errors message :
LINE MESSAGES FOR db2clisn.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0805N Package "LOCDE02.NULLID.SQLABC6N.44424A3154664B51" was not found. SQLSTATE=51002
does somebody know to which operating system belongs last three characters "C6N"
I work with the CAE version 6.1 [...]
9724 59 51_Re: Stranded Utility from 5.1 but system is now 6.10_18_mebert@AMADEUS.NET30_Tue, 6 Mar 2001 17:12:30 +0100365_us-ascii Hi Mike,
I searched the archives with "SYSUTILX" and got 5 hits. The first one from Dan Courter titled "No need to re-initialize SYSUTILX" should help you; it is in response to a different thread titled "Unable to TERM a stopped Utility" that will have more info (even if the situation described is somewhat different if I remember correctly). [...]
9784 81 71_Re: What are the Requirements, Tips & Tricks for monitoring Dynamic SQL10_Missy Case28_Missy.Case@FIRSTDATACORP.COM30_Tue, 6 Mar 2001 09:21:24 -0600541_us-ascii Carlton, If you have Platinum Detector, you can turn it on to capture your Dynamic SQL, ours comes in under a 'plan' so we can restrict our gathering to the dynamic plan & we also only capture them as exceptions when they exceed a certain # of getpages. It works really well for that and you can explain the SQL individually or jeu eyeball it & see what/where the improvements could be made in the indexes or SQL. The only drawback is that it is one statement at a time. There are no 'groupings' or anything, so you will spend [...]
9866 61 51_Re: Stranded Utility from 5.1 but system is now 6.115_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Tue, 6 Mar 2001 09:56:57 -0600562_iso-8859-1 You might need to blow away SYSUTIL and recreate it again. There are postings for this procedure in the archives.
Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin
"Any sufficiently advanced technology is indistinguishable from magic." - Arther C. Clarke
-----Original Message----- From: Mike Lawrence [mailto:mlawrence@ASCENSIONHEALTH.ORG] Sent: Tuesday, March 06, 2001 9:42 AM To: DB2-L@RYCI.COM Subject: Stranded Utility from 5.1 but system is now 6.1 [...]
9928 18 49_Alfonso Alonso/Production/Unicible est absent(e).14_Alfonso Alonso26_alfonso.alonso@UNICIBLE.CH30_Tue, 6 Mar 2001 01:00:29 +0100583_iso-8859-1 Je serai absent(e) du 03/05/2001 au 03/09/2001.
Je répondrai à votre message dès mon retour. ===============================================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.
===============================================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.
9947 134 52_Re: SQL Performance problem with Sequential Prefetch0_18_mebert@AMADEUS.NET30_Fri, 9 Mar 2001 11:10:40 +0100553_us-ascii Hello List,
I've removed the original letter as I expect the mail would get too long. First, some more cols from the Plan_table:
QUERYNO QBLOCKNO APPLNAME PROGNAME PLANNO METHOD CREATOR TNAME -----+---------+---------+---------+---------+---------+---------+---------+---- 2 1 DSNESM68 1 0 PNBS T1_AIRBKGT_DETAIL 2 1 DSNESM68 2 1 PNBS T1_OFFICES_REF
TABNO ACCESSTYPE MATCHCOLS ACCESSCREATOR ACCESSNAME INDEXONLY ---------+---------+---------+---------+---------+---------+---------+----- 1 R 0 N 2 I 1 PNBS XOFFICEP N [...]
10082 214 26_Re: -911 Cursor with hold.10_John Hardy24_john_j_hardy@ANOTHER.COM30_Fri, 9 Mar 2001 04:14:14 -0600399_- I'm not sure about the explicit 'COMMIT' being 6 (plus!) wasted keystokes. I think that it's part of good programming practice.
I do consider the 'WITH HOLD' to be nine wasted keystrokes in this instance, though. I think that Tom must not fully understand the purpose of 'WITH HOLD'.
On Thu, 8 Mar 2001 13:33:10 -0800, tim malamphy wrote: [...]
10297 73 26_Re: DB2 v5 to V7 migration16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Fri, 9 Mar 2001 10:52:44 +0000355_us-ascii Well if changing companies has not turned my brain into mashed potatoes, I remember that it was Roger (Miller) himself who in the past suggested that it was absolutely not advisable to skip v6... and Toine (Michielse) also suggested the same several times.
HOWEVER, it is true that in the announcement it says you can do so, and how. [...]
10371 123 26_Re: DB2 v5 to V7 migration15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Fri, 9 Mar 2001 12:29:47 +0100482_iso-8859-1 I remember last IDUG in Geneva, Roger Miller said it was available starting with version 6 to skip a version. (On OS/390 or z/Series).
Kind regards,
Jaap Slot mailto:J.P.Slot@rf.rabobank.nl
Reserve your AGENDA for next DB2 Users Group Conference IDUG Europe, 8-11 October 2001 in Florence, Italy. http://www.idug.org
No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...]
10495 99 41_Re: SQLJ and host variables - with "Like"20_Dr. Matthias Wehrens29_matthias.wehrens@AM-GRUPPE.DE30_Fri, 9 Mar 2001 05:05:56 -0600493_- I have the same problem with the LIKE predicate. It seems to be an error in the customizer DB2PROFC - or a configuaration problem, I don't know.
I tried the following: - SQLJ/DBPROFC against DB2 V5 OS/390: no results found - SQLJ/DBPROFC against local DB2 UDB V6 WinNT: results found
- Explicit BIND with the bind file generated by local preparation: Bind failed: "SQL0134N Improper use of a string column, host variable, constant, or function "". SQLSTATE=42907" [...]
10595 104 25_Re: Stored Procedure Help15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Fri, 9 Mar 2001 13:37:19 +0100370_iso-8859-1 Deborah,
We had the same problem.. this -430 is really a bug on its own. In our case we had a problem with non re-entrant code. In the CREATE procedure it was coded as " STAY RESIDENT YES " It turned out we had to compile with the parm RENT. In the linkedit we used 'REUS(RENT)'. After this, the -430 is vanished. Maybe this helps you out as well [...]
10700 58 19_Dynamic SQL Caching13_Brunner Don J21_Don.J.Brunner@IRS.GOV30_Fri, 9 Mar 2001 07:45:36 -0500345_ISO-8859-1 DB2 UDB for OS/390
For some time after V6 was out there was considerable discussion about the usage and problems associated with turning dynamic SQL caching on. To those who are utilizing this feature, have you found its use beneficial? Any gotchas associated with using it other than keeping an eye on the EDM pool size? [...]
10759 153 48_Re: Onl reorg termed but shadow datasets remain.13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US30_Fri, 9 Mar 2001 08:02:59 -0500418_US-ASCII Hi Tonmoy,
I hope you already have a solution for your problem, if not maybe this will help.
I had to terminate (-term util) an online reorg and was surprised to find shadow data sets remaining. I could not find a way to delete the data sets outside of DB2. When I had a bigger window I ran the reorgs again. When the reorg finished it cleaned up all the shadow data sets from both reorgs. [...]
10913 119 54_Re: Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT30_Fri, 9 Mar 2001 13:57:04 +0100517_- Hi, another way that did not imply the use of DB2 Connect, but I don't know if slower or faster, it's to do an Unload with the DSNTIAUL utility . In the select statement you have use the conversion function DIGITS from INTEGER and SMALLINT to CHAR and the conversion function CHAR from DECIMAL and DATE to CHAR; then we copied all to tape and moved it to the AIX system using the dd command with the "conv=ascii" parameter; the last step is to LOAD the data in the UDB . We have UDB 7.1 but I think it's quite [...]
11033 74 28_Re: Purging/archiving Survey16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Fri, 9 Mar 2001 13:01:59 +0000779_us-ascii Vendor plug?
Actually, if you are interested in more detail about the functionalities of !DB/Workbench from Candle Corp, feel free to contact me offline!!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. Camberley International Office Centre
Office: +44 (0)1276 414752 Mobile: +44 (0)7881 818867 email: aurora_dellanno@candle.com
|--------+---------------------------> | | "Zessin, Peter" | | | | | | | | | 03/08/2001 11:15 | | | PM | | | Please respond to| | | DB2 Data Base | | | Discussion List | | | | |--------+---------------------------> >----------------------------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: [...]
11108 110 26_Re: DB2 v5 to V7 migration0_19_mike.holmans@BT.COM30_Fri, 9 Mar 2001 13:14:49 -0000341_- The announcement says that the core utilities will be provided as part of the base licence in so far as they relate to the catalog and directory. I think even IBM realise that they have to provide methods of backing up and recovering the catalog without extra charges.
Mike Holmans BT ISE Database Services mike.holmans@bt.com [...]
11219 54 51_Re: s04e error on creation of Part IX - help please0_19_mike.holmans@BT.COM30_Fri, 9 Mar 2001 13:20:30 -0000424_- Are there any other messages in xxxxMSTR or xxxxDBM1? An 00E50013 merely says that something failed and caused DB2 to cancel what it was doing. Failure to find enough space to allocate one of the partitions might be enough to cause this.
Mike Holmans BT ISE Database Services mike.holmans@bt.com
This post represents the views of the author and does not necessarily accurately represent the views of BT [...]
11274 88 24_Re: SQL Guru Help Needed0_24_db46@DAIMLERCHRYSLER.COM30_Fri, 9 Mar 2001 08:23:33 -0500413_iso-8859-1 You might try a nested table (if you have version 5 or higher) as follows:
SELECT T3.PROVIDER, VALUE (N1.CNT_HIGHER, 0) + 1, T3.AMOUNT_SAVED FROM TABLEX T3 LEFT OUTER JOIN ( SELECT T1.PROVIDER, COUNT (*) CNT_HIGHER FROM TABLEX T1, TABLEX T2 WHERE T1.PROVIDER ¬= T2.PROVIDER AND T1.AMOUNT_SAVED < T2.AMOUNT_SAVED GROUP BY T1.PROVIDER) AS N1 ON T3.PROVIDER = N1.PROVIDER ORDER BY T3.PROVIDER [...]
11363 104 26_Re: DB2 v5 to V7 migration16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Fri, 9 Mar 2001 08:33:12 -0500631_iso-8859-1 Roger made a statement in a Lightyear conference late last year that V5 to V7 was fine.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Aurora Dell'Anno [mailto:Aurora_E_DellAnno@CANDLE.COM] Sent: Friday, March 09, 2001 5:53 AM To: DB2-L@RYCI.COM Subject: Re: DB2 v5 to V7 migration
Well if changing companies has not turned my brain into mashed potatoes, I remember that it was Roger (Miller) himself who in the past suggested that it was absolutely not advisable to skip v6... and Toine (Michielse) also suggested the same several times. [...]
11468 118 27_Re: using blobs with cobol?9_John Cops31_John.Cops@HERITAGEINSURANCE.COM30_Fri, 9 Mar 2001 07:34:19 -0600789_us-ascii here is my insert statement:
EXEC SQL INSERT INTO HET.ENDOR_PDF ( N_ENDOR, D_EDITION, I_ROW, J_PDF ) VALUES (:ETEPDF-N-ENDOR, :ETEPDF-D-EDITION, :ETEPDF-I-ROW, :ETEPDF-J-PDF-DATA ) END-EXEC. * here is my dclgen: EXEC SQL DECLARE HET.ENDOR_PDF TABLE ( N_ENDOR CHAR(8) NOT NULL, D_EDITION DATE NOT NULL, I_ROW ROWID NOT NULL, J_PDF BLOB(1048576) ) END-EXEC. **************************************************************** * COBOL DECLARATION FOR TABLE HET.ENDOR_PDF **************************************************************** 01 DCLENDOR-PDF. 10 ETEPDF-N-ENDOR PIC X(8). 10 ETEPDF-D-EDITION PIC X(10). 10 ETEPDF-I-ROW USAGE SQL TYPE IS ROWID. 10 ETEPDF-J-PDF USAGE SQL TYPE IS BLOB-LOCATOR. **************************************************************** [...]
11587 36 38_Create Tablespace/Index with DEFINE NO0_27_Sharon.Stevens@WAKEFERN.COM30_Fri, 9 Mar 2001 08:40:29 -0500374_us-ascii From the IBM manual it states:
# The following online utilities will process a table space that has been # defined but has indexes that remain undefined:
# CHECK DATA # CHECK INDEX # COPY TABLESPACE # MERGECOPY # MODIFY # QUIESCE WRITE(NO) # REBUILD INDEX # RECOVER # REORG TABLESPACE # REPAIR, except REPAIR DBD # RUNSTATS TABLESPACE INDEX(ALL) [...]
11624 23 53_SQL stored procedure generated C program/package name23_Scarcella, Gary V (ING)23_ScarcellaGV@ING-AFS.COM30_Fri, 9 Mar 2001 09:18:19 -0500323_iso-8859-1 Does anyone know if there's a way to specify the generated C program and package name, instead of getting a generated name like P0822040, when creating an SQL stored procedure via either the Stored Procedure Builder or the CREATE PROCEDURE command? I'm working with DB2 in a UNIX (Sun Solaris) environment. [...]
11648 32 17_DSN1COPY and DBID13_Hodgin, Scott19_shodgin@SCFBINS.COM30_Fri, 9 Mar 2001 08:37:15 -0600551_iso-8859-1 Dear list,
About two months ago, we used DSN1COPY to copy some support tables from our production sub-system to our BETA sub-system. Unknown at the time was that the incorrect target DBID was specified in the SYSXLAT. The PSID's and table OBID's were specified correctly. After running these DSN1COPY's, we successfully restarted the BETA table spaces and rebuilt all indexes with absolutely no problem. We have been successfully selecting rows via online and batch programs for over two months (these tables are only queried). [...]
11681 40 26_Re: DB2 v5 to V7 migration22_Binder, Ben A. (ISFPC)20_Ben.Binder@ISPAT.COM30_Fri, 9 Mar 2001 08:44:56 -0600442_iso-8859-1 He's made comments on the listserv. Check the archives from "millerr" for last year. Particularly on 00/10/11, 00/08/25 and 00/08/17
-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Friday, March 09, 2001 7:33 AM To: DB2-L@RYCI.COM Subject: Re: DB2 v5 to V7 migration
Roger made a statement in a Lightyear conference late last year that V5 to V7 was fine. [...]
11722 153 41_Re: SQLJ and host variables - with "Like"20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 9 Mar 2001 09:55:43 -0500574_iso-8859-1 I can tell you about DB2PROFC on OS-390 but I have not idea about it on the other platform. The like works for me and about the kind of host vars generated by customizer in the DBRMLIB, you have to be very very careful.
Always use "ONLINE" option because, if you don't, every string is converted to "fixed char (452 data type)" with length 254 and this leads to a bad accesspath. On the other hand, if you use "ONLINE" option then customizer recognizes the original column width and replaces the arbitrary length with the correct length e.g. a column [...]
11876 171 54_Re: Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX12_tim malamphy20_timalamphy@YAHOO.COM30_Fri, 9 Mar 2001 07:13:44 -0800560_us-ascii And you can set up an ESCON link between RS/6000 machines and OS/390's. It's one heck of a big pipeline, although a bit perplexing to set up, and will pump flat file data in either direction. If you set up a DRDA link (which can be over ESCON, or your normal TCP/IP network link), it should work as long as the movement is initiated on the AIX side. I don't think 5.1 supports DB2 being the application requester. tim --- "Napolitano, Fabrizio" wrote: > Hi, > another way that did not imply the use of DB2 > Connect, but [...]
12048 27 15_Sql max problem17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Fri, 9 Mar 2001 09:16:49 -0600399_us-ascii Hello all I have an interesting problem that I can't seem to figure out. Here is the situation, you have a table with 2 columns in it, SSN and Term_date. Each SSN can have many records with different term dates. I want to know the max term_date for each ssn. The kicker is I don't want to select the SSN, I just want the dates. This is part of a subselect for a create view statement. [...]
12076 25 0_13_Emrah Çadırcı20_emrca@KOCBANK.COM.TR30_Fri, 9 Mar 2001 17:12:28 +0200520_iso-8859-9 Dear list, Does anyone know if there's a way to call the Java Stored Procedure, inside an SQL stored procedure I'm working with DB2 in an UNIX (AIX) environment.
Thanks,
Emrah Çadırcı emrca@kocbank.com.tr Analyst Programmer System Development Koçbank A.Ş.
===============================================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.
12102 146 49_Re: SQLJ and host variables - with "Like" (Reply)0_22_scott.goodell@WCOM.COM30_Fri, 9 Mar 2001 09:23:57 -0600317_us-ascii I have had a problem open with IBM on this for two months now. I've sent all kinds of doc and they have re-created the problem but for some reason they are extremely slow on getting a fix for it. If you edit the BND file and correct the lengths all works fine. I've all but given up on IBM fixing this. [...]
12249 20 18_CCA Config Problem15_Benjamin Reches24_Benjamin.Reches@MSDW.COM30_Mon, 5 Mar 2001 19:46:53 -0500495_us-ascii What configuration parameter can you specify with a CUSTOM install of DB2 7.1 that would cause the "3.Protocol" tab NOT to display the checkbox on the bottom regarding 'host or AS400 machines', even after selecting radio-button 'TCP/IP'??
================================================ 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. [...]
12270 132 29_Re: Latin and other languages11_Robert Jans26_robert_jans@ALBERTSONS.COM30_Mon, 5 Mar 2001 13:22:38 -0700495_iso-8859-1 Well, I say this crosses the line of any taste......... Isn't it time this thread dies????
Robert Jans Albertsons, Inc.
-----Original Message----- From: McClendon, Rick [mailto:RMcClendon@ADMIN.FSU.EDU] Sent: Monday, March 05, 2001 10:47 AM To: DB2-L@RYCI.COM Subject: Re: Latin and other languages
Hey - I have a dictionary here with some Latin in it(?!?) Well, maybe this falls under "Other" languages. [...]
12403 58 29_Re: Latin and other languages14_subrata mondal25_subratamondal@HOTMAIL.COM30_Mon, 5 Mar 2001 19:24:17 -0000
12462 174 28_Re: Performence Issue - Help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 06:17:30 -0600450_windows-1255 Olga,
Both the IN predicate, and the range predicate (>= and <=) are indexable.
These two statements, however, are very different since the "IN" returns values that equal 'DB' or 'EV'; whereas the range predicate will also return any rows with values 'DC', 'DD', 'EA', 'ED' (for example).
If due to data specificity, then there are no other values between the two ranges, then they are functionally equivalent. [...]
12637 25 32_DB2 and latin - an extrapolation10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 5 Mar 2001 18:08:54 +0100568_us-ascii I hope that the word 'sex ' would never appear in DB2-L..........then I think we'll see all sort of things and all sort of much
vaunted performance.......
Sorry list owners, I'll never do it again .....as I said some times ago....
Regards and enjoy latin......
Max Scarpa DB2 sysprog
================================================ 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. [...]
12663 66 23_Re: db2 governor on AIX11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Tue, 6 Mar 2001 08:06:27 -0600307_- I'm sure SQL-GUY is a very good tool and actually I'll install a trial version to check it out. Since the tool can not prevent bad SQL from running, do you know any ways doing so ?
Thanks Richard Yan
On Mon, 5 Mar 2001 21:46:24 +0000, Philip Nelson (DBA) wrote: [...]
12730 154 51_Re: HELP! How to reduce bufferpool size at startup?10_Bill Disch23_bill.disch@GENMILLS.COM30_Tue, 6 Mar 2001 08:43:45 -0600410_- Mail system returned this today as undelivered so I am resending.
Additional info: After looking at the Diagnosis Guide V5 - Analyzing BSDS Dumps, it is easy to find all the bufferpool settings in the BSDS. All I would need next time is a way to edit the BSDS and fix everything without having to worry about data or index recovery. Of course, I'd like to think there will not be a next time ;-) [...]
12885 117 28_UDB V7.1 ... Export Question12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Tue, 6 Mar 2001 09:40:12 -0500353_iso-8859-1 Hi Listers, I'm trying to find a way to export a table to a comma delimited flat file and eliminate the CHARDEL of " .... in other words .. in this sample table: CREATE TABLE SAMP.TABLE ( NAME CHAR(10), ADDRESS CHAR(20), AGE SMALLINT, ) in TBSPC01
exporting with this command : export to /file.out of del select * from SAMP.TABLE [...]
13003 38 47_Stranded Utility from 5.1 but system is now 6.113_Mike Lawrence29_mlawrence@ASCENSIONHEALTH.ORG30_Tue, 6 Mar 2001 09:42:17 -0600576_US-ASCII Hello, We are running v6.1 (about one month) on our DB2 test system on OS/390. Apparently there is a batch job that had blown up just prior to our migration and no one was notified so we migrated to v6.1... now we have found that job has continued to abend weekly since and again no one was notified...but it is now abending because it cannot terminate the utility. We have tried to terminate the utility with commands but receive message DSNU115I >DB2T DSNUGTER - STOSPACE UTILITY WITH UTILID = HDTIR50E.STOSPAC CAN ONLY BE TERMINATED BY A MEMBER WITH THE SAME [...]
13042 64 18_Re: CICS Deadlocks16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Tue, 6 Mar 2001 09:49:43 +0530348_- Vince,
Have you tried looking, which table corresponds to this DBID and OBID combination ?. Similar case had been discussed in December, which was indicating DBID.OBID combination for the deadlock/timeout. You may look into the archive for the same. Thread Name starts with --> Timeouts / Deadlocks on resource type D01.(DBID, OBID). [...]
13107 67 34_Re: Inserting DB2 Data into Oracle10_Robert Ord21_robertord@HOTMAIL.COM30_Tue, 6 Mar 2001 11:23:42 -0000712_- If the volumes aren't too high you can use Oracle's DRDA gateway.
Rob
>From: James Campbell >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Inserting DB2 Data into Oracle >Date: Tue, 6 Mar 2001 14:56:57 +1100 > >I believe you might be able to do this with DataJoiner. > >/* standard disclaimer */ >James Campbell >Hansen Corporation > >-----Original Message----- >From: Burgess Evans [mailto:BMEVANS@AUDITOR.STATE.OH.US] >Sent: Tuesday, 6 March 2001 1:50 >To: DB2-L@RYCI.COM >Subject: [DB2-L] Inserting DB2 Data into Oracle > > >Hi all, > >We are installing Oracle for the first time. The Oracle version is [...]
13175 65 19_Re: Sql max problem0_24_db46@DAIMLERCHRYSLER.COM30_Fri, 9 Mar 2001 10:31:08 -0500749_us-ascii Well try a nested table/subquery as follows:
SELECT T1.TERM_DATE FROM ( SELECT SSN, MAX (TERM_DATE) AS TERM_DATE FROM TABLEX GROUP BY SSN) AS T1
Dean
Jeremy Schleicher @RYCI.COM> on 03/09/2001 10:16:49 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Sql max problem
Hello all I have an interesting problem that I can't seem to figure out. Here is the situation, you have a table with 2 columns in it, SSN and Term_date. Each SSN can have many records with different term dates. I want to know [...]
13241 46 19_Re: Sql max problem15_Lankester, Andy22_Andy_Lankester@BMC.COM30_Fri, 9 Mar 2001 09:55:31 -0600642_iso-8859-1 Why not set up another view on top that excludes the ssn and use that.
Andy Lankester bmcsoftware My opinions are just that.
-----Original Message----- From: Jeremy Schleicher [mailto:Jeremy_Schleicher@MAY-CO.COM] Sent: 09 March 2001 15:17 To: DB2-L@RYCI.COM Subject: Sql max problem
Hello all I have an interesting problem that I can't seem to figure out. Here is the situation, you have a table with 2 columns in it, SSN and Term_date. Each SSN can have many records with different term dates. I want to know the max term_date for each ssn. The kicker is I don't want to select the SSN, [...]
13288 92 21_Re: DSN1COPY and DBID10_Bill Disch23_bill.disch@GENMILLS.COM30_Fri, 9 Mar 2001 10:18:54 -0600576_iso-8859-1 Scott,
My experience with DSN1COPY also suggests that an incorrect DBID does not affect processing on the target system. Why, I don't know. I discovered this some time ago when using BMC COPY+ on the target structures with every error detection option turned on in the copy job. The COPY+ execution reported as a warning that the DBID and SSID an something else, I think the HLQ, did not match the information in the DB2 Catalog. The pages still had the source system values. I performed an reorg (either IBM or BMC) and reran the COPY+ job. No errors. [...]
13381 27 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Fri, 9 Mar 2001 10:05:40 -0600355_- Just a clarification, when you say "query cannot be depended upon" you are referring to the value(s) in the host variable(s) and not to the SQLCODE. So if someone is using singleton select only to find out if there are none, one or more rows qulifying the conditions and coding the into clause only to satisfy the precompiler, they should be fine. [...]
13409 50 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Fri, 9 Mar 2001 10:28:59 -0600673_iso-8859-1 Yes, that's correct
Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Mohammad Khan Sent: Friday, March 09, 2001 10:06 AM To: DB2-L@RYCI.COM Subject: Re: Select Distinct vs Open Cursor and Fetch Once
Just a clarification, when you say "query cannot be depended upon" you are referring to the value(s) in the host variable(s) and not to the SQLCODE. So if someone is using singleton select only to find out if there are none, one or more rows qulifying the conditions and coding the into clause only to satisfy the precompiler, [...]
13460 98 19_Re: Sql max problem13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Fri, 9 Mar 2001 10:30:50 -0600557_us-ascii Just for an FYI.......you do not need to select what you GROUP BY at all, so:
SELECT MAX (TERM_DATE) AS TERM_DATE FROM TABLEX GROUP BY SSN
Is fine....the optimizer will not materialize the NTE as in Dean's example, therefore they are equivalent.
Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of db46@DAIMLERCHRYSLER.COM Sent: Friday, March 09, 2001 9:31 AM To: DB2-L@RYCI.COM Subject: Re: Sql max problem [...]
13559 21 19_Re: Sql max problem18_Richard Mccutcheon32_Richard_McCutcheon@HCM.HONDA.COM30_Fri, 9 Mar 2001 11:34:18 -0500469_us-ascii select max(term_date) from xx.xxxxxx group by ssn
this should work fine. (it does in ver5.2 UDB on AIX)
Richard McCutcheon DBA Honda of Canada Mfg. ps - personal statement - ALL YOUR BASE ARE BELONG TO US
================================================ 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.
13581 216 52_Re: SQL Performance problem with Sequential Prefetch19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM30_Fri, 9 Mar 2001 10:38:22 -0600609_iso-8859-1 Hi Doc, A quick guess. I can't help but think this may be related to hitting a bufferpool threshold and somehow affecting things at runtime.
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 [...]
13798 114 24_Re: SQL Guru Help Needed0_27_jim.leask@RS-COMPONENTS.COM30_Fri, 9 Mar 2001 16:39:18 -0000325_iso-8859-1 Dave,
I have a possible solution but I think the performance may be dire for a large number of rows and a solution outside of QMF may be required. However here goes. I have used a table which exists in my environment but you'll get the idea.
Create a QMF procedure which contains the following: [...]
13913 62 33_Re: UDB Trial copy and Windoze 9810_CC Harvest19_ccharvest@YAHOO.COM30_Fri, 9 Mar 2001 09:06:38 -0800671_us-ascii I installed. It works fine.
--- "Tennant, Steve" wrote: > **************************************************************** > IMPORTANT > > The information transmitted is for the use of the > intended > recipient only and may contain confidential and/or > legally > privileged material. Any review, re-transmission, > disclosure, > dissemination or other use of, or taking of any > action in > reliance upon, this information by persons or > entities other > than the intended recipient is prohibited and may > result in > severe penalties. If you have received this e-mail > in error > please notify the Privacy Hotline of [...]
13976 20 31_IBM DB2 High Performance Unload9_Chu, Pius14_ChuP@CONED.COM30_Fri, 9 Mar 2001 12:17:53 -0500493_iso-8859-1 Has anyone use the IBM DB2 high performance unload product? I like to hear any comments and comparison to BMC UNLOAD PLUS or the CA unload product. Thanks.
Pius Chu IR - Operating Systems Support chup@coned.com (212) 460-4764
================================================ 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.
13997 34 50_IBM TXSeries CICS using DB2 EEE receiving SQL0918N11_Mike Fatula17_mfatula@PHEAA.ORG30_Fri, 9 Mar 2001 12:52:54 -0500384_us-ascii We are receiving some sql0918 with online transactions.
SQL0918N Application must execute a rollback.
Cause: The unit of work has already been rolled back in the database but other resource managers involved in this unit of work might not. To ensure integrity of this application, all SQL requests will be rejected until the application issues a rollback. [...]
14032 52 26_Re: -911 Cursor with hold.11_Mark Harmon17_mhinnyc@YAHOO.COM30_Fri, 9 Mar 2001 11:54:44 -0600531_- There have been many good suggestions so far, which is not surprising since this is such a classic DB2 issue. To recap:
-Change job scheduling (rejected, but a valid idea) -See if the problem was due to TS lock escalation by reviewing DB2 messages. If so, play with tablespace max locks --If problem was due to page locking, consider row level locking --If problem was due to page locking, add more freespace to get fewer rows per page --Commit more often --Retry the sql statement that failed due to lock contention [...]
14085 17 38_Building Databases on SHARK DISK Array17_Price, Jeff (EDS)14_jprice@NCL.COM30_Fri, 9 Mar 2001 13:52:08 -0500294_- We will be implementing a IBM DISK array SHARK 2105 Model F20 with 24 drawers of 8 drives each. Each drive is 18gigs. The array is automatically RAID-5. My question is: How does one carve logical volumes out of this array to provide proper separation of database logs, data and indexes? [...]
14103 44 42_Re: Building Databases on SHARK DISK Array11_Moore, Tony15_TMoore@IKON.COM30_Fri, 9 Mar 2001 14:31:59 -0500539_iso-8859-1 Jeff, We just recently converted from 3390 Mod 3's to a Shark. I don't know how technically correct we were in our thinking, but we simply tried to keep a good spread across the channels to ensure we did not have any bottlenecks in that area. As far as splitting up logs, data and indexes, I don't think that is a concern anymore with Raid technology, at least that's what I've been told, and did not try to separate them. There are more than likely those that'll slam that idea, but all I know is that our I/O bound tasks [...]
14148 113 54_Re: Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX0_24_William_O'Black@FFIC.COM30_Fri, 9 Mar 2001 11:21:40 -0800490_us-ascii Judy, we needed to get about 3 gb from DB2 V6 over to AIX evey night. Our AIX box is a 6-way S80 w/4 gb of RAM.
We tried using DSNTIAUL to unload the data, then ftp it over to AIX and load it. If you've got a lot of decimal data or dates, or nullable columns, this is a real cludge to use. Plus the runtime and CPU usage on the unload are both very long, and trying to code the load statements on AIX is a real pain too. We ended up running an export/load from AIX. It [...]
14262 37 42_Re: Building Databases on SHARK DISK Array13_O'Neill, Mike19_Mike.O'Neill@53.COM30_Fri, 9 Mar 2001 14:54:08 -0500422_iso-8859-1 The actual carving happens on the ESS console thru a product called the specialist. Thats where you take the 18gb drive and define mod3 or mod9 3390 volumes. I defined 16 mod9s, 24 mod3s and two specials for each LCU in ours. You should also define aliases volumes or PAV at the same time. Your systems people should have and IODF generated thru HCD that matches the specialist setup. Hope this helps you. [...]
14300 61 38_Re: DB2 Connect V7.1 fp2? experiences?13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Fri, 9 Mar 2001 13:58:58 -0600379_iso-8859-1 Brian,
Yes, we are using PeopleSoft. We did fallback. IBM has identified at least one other customer who reported this error, and has identified the bug. We're told the fix will be in 7.1 fp3 and we can expect it yet this month. When we get it we will re-install v7 into test. I believe June is when IBM has said that support for 6.1 will be discontinued. [...]
14362 22 42_Re: Building Databases on SHARK DISK Array26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Fri, 9 Mar 2001 14:27:46 -0600593_- Just went thru this. Did you pop for the "expert" software or using the "specialist". Anyway not much to worry about. In the SAPR guide the "default" configuration is defined. For x number of 3390s per "array". It does not have to be raid-5 it's an option (highly recommended). If you need any 3380's then recommend going to custom volumes and you get 92GB per array (due to geometry overhead). The dasd is striped across volumes and arrays. You can actually watch it format the drives on alternate banks as it's configured. Plan ahead, to change configuration requires reformatting an [...]
14385 20 26_Default to tablespace scan11_Paul Victor19_paulv57@HOTMAIL.COM30_Fri, 9 Mar 2001 14:21:21 -0600369_- Hi List
In the dim and distant past I recall reading/hearing that on DB2 V5 OS/390 if a table is less than 6 pages, then the optimizer will automatically pick a tablespace scan as the preferred access path, irrespective of whether there is an index or not. Does anyone know if this is true, if it is also applicable to UDB V6, and where it is documented. [...]
14406 130 38_Re: DB2 Connect V7.1 fp2? experiences?12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Fri, 9 Mar 2001 16:16:29 -0500598_iso-8859-1 Dave, Our shop is running peoplesoft also through a v6.1 DB2 Connect gateway ... they have just recently upgraded to this from v5.2. Do you know if peoplesoft currently certifies using v7.1 ? Has IBM actually announced that v6.1 support is ending in June ... I thought I'd heard that v5 support is being discontinued, but not v6.1 yet. These are some concerns of our peoplesoft folks ... I'm working on a system that we're installing on UDB/AIX v7.1 and have been planning on rolling out runtime clients v7.1 ... but, some of these end-users are also running peoplesoft/db2 connect [...]
14537 97 38_Re: DB2 Connect V7.1 fp2? experiences?13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Fri, 9 Mar 2001 15:24:53 -0600520_iso-8859-1 Brian,
My mistake! You are correct it is support for 5.2 that is being dropped in June.
Thanks! Dave
-----Original Message----- From: Brian F. Patella [mailto:patellab@worldnet.att.net] Sent: Friday, March 09, 2001 2:26 PM To: Shapiro, Dave Subject: Re: DB2 Connect V7.1 fp2? experiences?
Thanks Dave!
I hope the support for 6.1 is not dropped! I have seen where they are dropping 5.2 June 30th. If you know where this is documented for 6.1 please let me know. [...]
14635 72 26_Re: DB2 v5 to V7 migration14_Grainger, Phil20_Phil.Grainger@CA.COM30_Fri, 9 Mar 2001 21:43:13 -0000366_iso-8859-1 One 'amusing' thing I did notice. RUNSTATS is in one 'family' of utilities, MODIFY STATISTICS is in the other...
So, you pay to collect statistics and pay more to remove them.......
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
14708 80 24_Re: Table Comparison SQL11_James Drewe20_James.Drewe@AEXP.COM30_Fri, 9 Mar 2001 14:42:14 -0700440_iso-8859-1 Listers
Thanks for your suggestions, with special thanks to Terry Purcell, Andrew Puddy, Sydney Brereton, and James Cambell. I will investigate all your suggestions. In the interim, I will be using the unload Super-CE comparison in OS390 ISPF.
TYAFYH (Thank You All For Your Help -- sorry, no Latin)
Jim Drewe DBA
=============================================================
Dear listers [...]
14789 20 18_Training providers14_Richard Arnold24_Richard.Arnold@CHASE.COM30_Fri, 9 Mar 2001 13:12:19 -0600470_us-ascii Hello list,
Are there any alternatives to IBM for OS/390 datasharing training?
Please let me know if you have had good experiences with anyone.
Thanks in advance for your help.
Richard Arnold
================================================ 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.
14810 182 30_Re: AIX UDB Mirror + Stripping11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Fri, 9 Mar 2001 16:12:05 -0600594_- Hi Scott,
Thanks for your reply.
The reason I want to implement LVM striping & mirror is not because we want to solve a particular problem. We bought some extra disks in and want to rearrange physical layout, spread the database effectively across as many disks as possible to try and minimize I/O wait. We believe placement of data can directly affect the overall performance, sometimes are much more important than the power of CPU. Actually, our production is in a very good shape, average user cpu usage is 20%, system cpu 10%, Io wait 30%, Idle 40%, daily transaction [...]
14993 190 39_Re: Create Tablespace/Index with DEFINE64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM30_Fri, 9 Mar 2001 17:18:35 -0600322_ISO-8859-1 If I can summarize this thread:
Phil (CA) says: "You should (in my opinion, and CAs and BMCs!!) you should be able to run utilities like QUIESCE, COPY etc against undefined objects purely because you are running against a SET of objects and really DB2 should handle whether they are defined or not" [...]
15184 23 40_Zparm CONTSTOR - contract thread storage11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Fri, 9 Mar 2001 16:07:38 -0800371_iso-8859-1 Hi all, We're looking at the CONTSTOR zpam. We currently have it set to YES to save storage but the book say to set it to NO for better performance.
I could set it back to NO since we're not having any problems with space in DBM1 but how much performance would we pick up. Is checking and contracting thread storage that big of a performance hit?? [...]
15208 53 28_Re: Purging/archiving Survey10_DANIEL CYR19_DCYR@EMAIL.USPS.GOV30_Fri, 9 Mar 2001 19:18:20 -0600496_iso-8859-1 IN-HOUSE. This has been underway for more than a year.
______________________________ Reply Separator _________________________________ Subject: Purging/archiving Survey Author: owner-db2-l@RYCI.COM at INTERNET Date: 3/8/01 6:28 PM
We are in the beginning stages of a purging/archiving project for a utility cis/billing application.
Our company is deciding whether to build in-house or purchase one of the purge/archiving tools on the market. [...]
15262 207 39_Re: Create Tablespace/Index with DEFINE13_Bright, Randy20_Randy_Bright@BMC.COM30_Fri, 9 Mar 2001 20:19:52 -0600406_iso-8859-1 By "you", I mean a DBA should be able to run a utility (IBM free, IBM licensed, or third party vendor) without having to worry about if the dataset exists. If an SQL SELECT works exactly the same on an un-instantiated object as it does on an empty object, why doesn't a utility do the same (regardless of who developed and marketed the utility). A DBA can run REORG on an empty tablespace. [...]
15470 212 44_Re: Create Tablespace/Index with DEFINE YES!16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM30_Fri, 9 Mar 2001 22:24:55 -0500326_us-ascii Simple solution to such a menacing and perceived (mole hill, or is it a mountain?) problem:
Do NOT utilize the "DEFINE NO" option (what an epiphany)!
Since DASD is so "CHEAP", allocate unused spaces at a measly one track and be done with it!
Way too much to do about a whole lot of nothing. [...]
15683 40 39_Re: Create Tablespace/Index with DEFINE17_Miguel de Andrade29_miguel.andrade@BTINTERNET.COM31_Sat, 10 Mar 2001 05:48:22 -0600652_- I hope this clarifies a little better this issue.
APAR NUMBER: PQ30999 New Function - Defer support
Under the Utilities paragraph :
Currently, DB2 allows LOAD REPLACE and LOAD RESUME YES|NO utilities work on undefined objects. LOAD Utilities invokes the reset function to create the undefined objects. For REPAIR DBD and STOSPACE functions, they can continue to run without issuing a DSNU185I message (msgDSNU185i). For COPY, RECOVER, QUIESCE, RUNSTATS, REPORT, MODIFY, REPAIR (except REPAIR DBD), CHECK, REORG, REBUILD and MERGECOPY utilities, they are required to check the OBDs during initialization. undefined. [...]
15724 25 51_Re: s04e error on creation of Part IX - help please7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Sat, 10 Mar 2001 09:34:12 -0600422_- Hi, Mike
Thanks for your reply. This problem got resolved.
I did checking for error messages in the XXXXMSTR, XXXXDBM1 address spaces. No messages were found.
I tried same DDL the next day. it worked fine. To be honest with you, i did not know the cause.
Also noticed, this subsystem did not get recycled from the past one week, so i am not sure why the same ddl worked on the next day. [...]
15750 68 26_Re: -911 Cursor with hold.11_Tom Marcano23_marcano_db2@HOTMAIL.COM31_Sat, 10 Mar 2001 17:05:00 -0000
15819 37 30_Re: Platinum Tools With DB2 V612_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Wed, 7 Mar 2001 09:45:00 -0500494_- No problems yet with 99D and DB2 V6. Platinum recommended upgrading to 99D after we had 99C installed. 99D is the 1st release that uses CA LMP keys. This has caused us problems because we don't have all of the products. There are some internal calls to other products that we did not have to have PWs for before 99D. To date, the internal calls simply put messages on the SYSLOG and at user logoff time, but did not stop processing. Make sure you get your LMP keys before moving to 99D. [...]
15857 32 17_External Function8_bharat r20_bharat_321@YAHOO.COM31_Sat, 10 Mar 2001 10:44:47 -0800379_us-ascii Hi list while creating instance I assigned one userid(db2fenc1) as fence user id. I created one function and when I tried to access the function it is failing with an error
SQL0440N No function by the name "SEQ" having compatible arguments was found in the function path. SQLSTATE=42884
Pls . let me me know where the function should reside?? [...]
15890 17 21_Re: External Function17_Miguel de Andrade29_miguel.andrade@BTINTERNET.COM31_Sat, 10 Mar 2001 13:02:47 -0600292_- By default if you didn't specify in the EXTERNAL NAME the full path, DB2 look for it in SQLLIB\function otherwise you can force DB2 to look if the full path is added to CREATE FUNCTION.
What is the error you are having? and the DB2 version and fixpack (check it with DB2LEVEL). [...]
15908 55 22_Re: Training providers12_Susan Lawson24_susan_lawson@YLASSOC.COM30_Fri, 9 Mar 2001 15:06:32 -0600498_iso-8859-1 Hi Richard,
YL&A offers several data sharing courses.
Data Sharing Implementation Data Sharing Performance Data Sharing Recovery Data Sharing Complete
All courses are updated for Version 7 and are detailed with real experiences of the instructors (Susan Lawson or Richard Yevich).
For details visit our web-site http://www.ylassoc.com and look under education.
Regards, Susan Lawson DB2 for OS/390 Certified DBA Yevich, Lawson and Associates, Inc [...]
15964 61 30_Re: Platinum Tools With DB2 V616_Herman, Philippe22_PHILIPPE.HERMAN@CA.COM31_Sat, 10 Mar 2001 21:29:26 -0000480_iso-8859-1 Maintenance Tape 1047HA has been released and solves the LMP keys internal calls mismatch.
Philippe Herman Computer Associates Technical Consultant Tel: +32 (2) 773 28 43 Fax: +32 (2) 762 73 59 Mobile: +32 (496) 59 72 79 philippe.herman@ca.com
-----Original Message----- From: BOB JEANDRON [mailto:BOB.JEANDRON@USDA.GOV] Sent: Wednesday, March 07, 2001 3:45 PM To: DB2-L@RYCI.COM Subject: Re: Platinum Tools With DB2 V6 Sensitivity: Personal [...]
16026 54 21_Re: RECOVER TS TO RBA20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM28_Tue, 6 Mar 2001 22:22:33 EST583_US-ASCII John, The documentation that I send to you a few days about the recovery tool will display all the recovery points of a tablespace. You would type in the tablespace name and you will get an ISPF panel listing of recovery points by RBA with Timestamp and all other Tablespaces names that were quiesced with the specified tablespace. You can also get a panel listing of all recovery points of a tablespace by valid Image Copies dsnames and Timestamps and all Tablespaces in a specified Database. From the ISPF Display Panel the user just Pick and Chose and everything is [...]
16081 70 29_Re: Image Copy in Last 7 Days13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 18:24:58 -0600436_iso-8859-1 Mark,
Try either of these:
SELECT DBNAME, TSNAME, MAX(TIMESTAMP) FROM SYSIBM.SYSCOPY WHERE ICTYPE = 'F' GROUP BY DBNAME, TSNAME HAVING MAX(TIMESTAMP) < CURRENT TIMESTAMP - 7 DAYS
or
SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE A WHERE NOT EXISTS (SELECT 1 FROM SYSIBM.SYSCOPY B WHERE B.DBNAME = A.DBNAME AND B.TSNAME = A.NAME AND B.ICTYPE = 'F' AND B.TIMESTAMP < CURRENT TIMESTAMP - 7 DAYS) [...]
16152 61 21_Re: RECOVER TS TO RBA14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 7 Mar 2001 15:39:33 +1100563_iso-8859-1 My understanding is that the recovery process doesn't know anything about the meaning of the contents of a tablespace. It will happily recover data for a dropped table (ie one with an OBID that is not used by any current table). But this does absolutely nothing to recover the catalog information for the dropped table - the only way to do this is to recover the catalog and directory tablesspace back to the same RBA (:-(). In fact, a "SELECT * FROM " will not suffer a failure due to all the 'unknown rows' in the tablespace, but it [...]
16214 27 22_DB2 DBA- Charlotte, NC13_Kathryn Sears24_ksears@DPCONSULTANTS.COM30_Tue, 6 Mar 2001 16:09:08 -0600396_- I am looking for a DB2 DBA in Charlotte, NC for a client of mine that is seeing MAJOR GROWTH in its DB2 area and will continue to expand in the future (they are an OS390 shop, with many other platforms). This is HUGE, GROWING company and the manager is looking for SELF-STARTERS who LOVE learning about NEW TECHNOLOGY- they work quite a bit with REPLICATION, WEB ACCESS, DATABASE SHARING. [...]
16242 24 28_DBLINKS DB2 UDB / DB2 os/39025_RAUL GILDARDO ROSAS LOPEZ23_rrosasl@MAIL.TELCEL.COM30_Tue, 6 Mar 2001 21:11:14 -0600474_us-ascii Hi....
I try to do some links between db2udb and db2 the problem is that i try to see one view in db2udb but the view is one object in de db2 os/390
Someone know how do that... ?????
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. [...]
16267 24 50_Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX11_Judy Kibler21_judith.kibler@TRW.COM30_Tue, 6 Mar 2001 15:10:21 -0600365_us-ascii Hello,
We are trying to figure out how to migrate our Baan DB2 v5 database (stored with CCSID ASCII) on OS/390 to DB2 UDB v6 on AIX safely and most efficiently. We have about 60 GB of data to transfer. We have a 100 Mbps Ethernet link between the mainframe and the AIX environment. We also have DB2 Connect that could play a part. Suggestions? [...]
16292 173 49_Re: Select Distinct vs Open Cursor and Fetch Once15_Corrigan, David31_David.Corrigan@TEAM.TELSTRA.COM30_Wed, 7 Mar 2001 13:46:58 +1100327_iso-8859-1 Terry,
Correct me if I am wrong, the SQL you have written includes 3 non-correlated subqueries which when the SQL is executed would be preformed first returning all rows which match the predicates. Only after the Subselects are performed will DB2 look at the outer sql and evaluate the Existence clause. [...]
16466 24 17_RECOVER TS TO RBA16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU30_Tue, 6 Mar 2001 17:23:00 -0800472_- Assume Tablespace A has single Table A and that a full image copy is made on Monday. On Tuesday a column is dropped from Table A so we LOAD Tablespace A LOG YES to reload Table A after redefining Table A.
Prior discussions on listserve indicate DB2 can RECOVER TS A to current where current is after the reload of TS A by processing the image copy taken before the new definition of Table A and log records taken both before and after Table A was redefined. [...]
16491 57 29_Re: Image Copy in Last 7 Days13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Tue, 6 Mar 2001 16:05:48 -0800494_us-ascii SELECT DBNAME,NAME FROM SYSIBM.SYSTABLESPACE T1 WHERE NOT EXISTS ( SELECT DBNAME,TSNAME, MAX(TIMESTAMP) FROM SYSIBM.SYSCOPY T2 WHERE ICTYPE = 'F' AND T1.DBNAME = T2.DBNAME AND T1.NAME = T2.TSNAME GROUP BY DBNAME,TSNAME HAVING DATE(MAX(TIMESTAMP)) > CURRENT DATE - 7 DAYS )
Thanks. Ashish.
-----Original Message----- From: Knabach, Mark L [SMTP:mark.knabach@EDS.COM] Sent: Tuesday, March 06, 2001 3:50 PM To: DB2-L@RYCI.COM Subject: Image Copy in Last 7 Days [...]
16549 82 29_Re: Image Copy in Last 7 Days15_Knabach, Mark L20_mark.knabach@EDS.COM30_Tue, 6 Mar 2001 20:58:40 -0500444_iso-8859-1 Ahh, yes. Thank you so much Terry.
-----Original Message----- From: Terry Purcell [mailto:Terry_Purcell@YLASSOC.COM] Sent: Tuesday, March 06, 2001 6:25 PM To: DB2-L@RYCI.COM Subject: Re: Image Copy in Last 7 Days
Mark,
Try either of these:
SELECT DBNAME, TSNAME, MAX(TIMESTAMP) FROM SYSIBM.SYSCOPY WHERE ICTYPE = 'F' GROUP BY DBNAME, TSNAME HAVING MAX(TIMESTAMP) < CURRENT TIMESTAMP - 7 DAYS [...]
16632 182 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 21:17:15 -0600490_iso-8859-1 David,
Excellent pickup.....I was only saying in a class today how a lot of people forget this....and now I can include myself.
Thanks for the correction.
Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Corrigan, David Sent: Tuesday, March 06, 2001 8:47 PM To: DB2-L@RYCI.COM Subject: Re: Select Distinct vs Open Cursor and Fetch Once [...]
16815 120 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 18:14:23 -0600387_us-ascii Chris,
What about something like:
SELECT 1 FROM SYSIBM.SYSDUMMY1 WHERE EXISTS (SELECT 1 FROM TABLE1 A, TABLE2 B WHERE B.PART = A.PART AND A.DATE1 = TODAY) OR EXISTS (SELECT 1 FROM TABLE1 A, TABLE2 B WHERE B.PART = A.PART AND B.DATE1 = TODAY) OR EXISTS (SELECT 1 FROM TABLE1 A, TABLE2 B, TABLE3 C WHERE B.PART = A.PART AND C.PART = B.PART AND C.DATE1 = TODAY) [...]
16936 31 42_Database Creation scripts for UDB V7 on NT10_CC Harvest19_ccharvest@YAHOO.COM30_Tue, 6 Mar 2001 13:58:20 -0800413_us-ascii Hi,gurus: I am new to DB2 world, could anyone send me a scripts to create a database on the command line (I want to manage tablespace inside the database, the script should be like the one in Oracle, if possible).
TIA,
Chris
__________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ [...]
16968 77 29_Re: Image Copy in Last 7 Days15_Knabach, Mark L20_mark.knabach@EDS.COM30_Tue, 6 Mar 2001 20:59:40 -0500673_iso-8859-1 Thanks, Donna!
-----Original Message----- From: Donna O'Connell [mailto:donna.oconnell@SAFEWAY.COM] Sent: Tuesday, March 06, 2001 6:20 PM To: DB2-L@RYCI.COM Subject: Re: Image Copy in Last 7 Days
It should be something like this
SELECT DBNAME, TSNAME, ICDATE, ICTIME, DSNAME FROM SYSIBM.SYSCOPY WHERE ICDATE < CURRENT-DATE - 7 ;
"Knabach, Mark L" wrote:
> I am drawing a blank ... can anyone assist with an SQL statement that would > query the DB2 catalog and detect any tablespace that has not been Image > Copied within the last 7 days? Your help is appreciated. Thanks, in > advance. > > Mark Knabach > [...]
17046 52 29_Re: Image Copy in Last 7 Days15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM30_Tue, 6 Mar 2001 16:20:24 -0800608_us-ascii It should be something like this
SELECT DBNAME, TSNAME, ICDATE, ICTIME, DSNAME FROM SYSIBM.SYSCOPY WHERE ICDATE < CURRENT-DATE - 7 ;
"Knabach, Mark L" wrote:
> I am drawing a blank ... can anyone assist with an SQL statement that would > query the DB2 catalog and detect any tablespace that has not been Image > Copied within the last 7 days? Your help is appreciated. Thanks, in > advance. > > Mark Knabach > EDS - Chicago Solution Centre > 1900 S. Springer Drive > Lombard, IL 60148 > *phone: +01-630-495-3229 (8-520) > *fax: +01-630-691-5303 (8-520) > * mailto: [...]
17099 34 38_Duplicate postings - List is acting up13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sat, 10 Mar 2001 18:40:44 -0600512_iso-8859-1 FYI - I just received notification that 3 of my postings from the 6th have been distributed again!!!!
I checked the archives and there is a lost of postings that have been repeated.....
Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: L-Soft list server at RYCI.COM (1.8d) [mailto:LISTSERV@RYCI.COM] Sent: Saturday, March 10, 2001 4:47 PM To: Terry Purcell Subject: Message ("Your message dated Tue, 6 Mar 2001 18:24:58 -0600...") [...]
17134 24 27_Mainview for DB2 and DB2 PM0_14_mtdage@ATT.NET31_Sun, 11 Mar 2001 02:01:09 +0000372_- Has anybody experienced using Mainview for DB2 (DB2 Performance Monitor from Boole&Babbage now BMC) and DB2 PM? We would really appreciate if you can provide us any opinions/comparisons between the two products.
We currently have Mainview for DB2 and is thinking about trying DB2 PM. Factors we consider are functions, features, doc, and training available. [...]
17159 50 22_Re: Training providers11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Sun, 11 Mar 2001 05:21:26 -0500363_ISO-8859-1 Richard
If you are based in the UK or Europe, you may be interested in my DB2 Datasharing courses. I currently teach two courses: a one-day Datasharing Overview and a two-day Datasharing Recovery Workshop. You can find course descriptions on my web site, www.michael-turner.ltd.uk. I can also tailor training to your specific requirements. [...]
17210 194 54_Re: Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 11 Mar 2001 16:37:16 +0200523_iso-8859-1 Hi, We just use the same disk box for MF, UNIX & PC (it's HDS7700E BTW) and copy of data from disk to disk is realy fast. It takes some time and work to implement but after that it's working fine.
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.com ----- Original Message ----- From: "tim malamphy" Newsgroups: bit.listserv.db2-l To: Sent: Friday, March 09, 2001 5:13 PM Subject: Re: Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX [...]
17405 102 23_Re: Dynamic SQL Caching12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 11 Mar 2001 16:40:19 +0200386_iso-8859-1 Dynamic SQL CachingHi, We used it even in V5 . Benefits are 30%-70% savings on prepares. And you need to watch your EDM.
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.com ----- Original Message ----- From: Brunner Don J Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Friday, March 09, 2001 2:45 PM Subject: Dynamic SQL Caching [...]
17508 46 30_Re: Default to tablespace scan12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 11 Mar 2001 16:43:09 +0200656_Windows-1252 Hi, I don't recall anything like that. In my tests (V5 & V6) DB2 used the index.
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.com ----- Original Message ----- From: "Paul Victor" Newsgroups: bit.listserv.db2-l To: Sent: Friday, March 09, 2001 10:21 PM Subject: Default to tablespace scan
> Hi List > > In the dim and distant past I recall reading/hearing that on DB2 V5 OS/390 > if a table is less than 6 pages, then the optimizer will automatically pick > a tablespace scan as the preferred access path, irrespective of whether > there is an index [...]
17555 102 26_Re: DB2 v5 to V7 migration12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 11 Mar 2001 16:44:28 +0200380_iso-8859-1 Hi, If you drop the TS you get rid of the statistics as well, w/o payment ;-))
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.com ----- Original Message ----- From: "Grainger, Phil" Newsgroups: bit.listserv.db2-l To: Sent: Friday, March 09, 2001 11:43 PM Subject: Re: DB2 v5 to V7 migration [...]
17658 235 44_Re: Create Tablespace/Index with DEFINE YES!14_Grainger, Phil20_Phil.Grainger@CA.COM31_Sun, 11 Mar 2001 16:52:43 -0000471_iso-8859-1 Hi Rick,
The issue isn't one of DASD space it's one of numbers of datasets.....
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: RICHARD E MOLERA [mailto:RICHARD.E.MOLERA@SLMA.COM] Sent: 10 March 2001 03:25 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Create Tablespace/Index with DEFINE YES! [...]
17894 43 15_DECIMAL and SUM17_Valerie J Traurig18_valeriet6@JUNO.COM31_Sun, 11 Mar 2001 10:29:32 -0500377_- Could someone who has the SAMPLE database set up do me a favor and run the following SQL statements on OS/390?
1. SELECT SUM(BONUS)/SUM(SALARY+BONUS+COMM) FROM DSN8610.EMP
(This should get a -419 because the resulting precision and scale algorithms will give you a negative result. The return code advice is to change either the numerator or denominator.) [...]
17938 63 19_Re: DECIMAL and SUM21_Claypool, Alisa@HHSDC21_AClaypoo@HHSDC.CA.GOV31_Sun, 11 Mar 2001 09:40:40 -0800524_iso-8859-1 I executed the statements using SPUFI and received a SQLCODE 0 for each one.
Alisa Claypool HHSDC DB2 Support wk (916) 454-8194 fax (916) 739-7787 aclaypoo@hhsdc.ca.gov
-----Original Message----- From: Valerie J Traurig [mailto:valeriet6@JUNO.COM] Sent: Sunday, March 11, 2001 7:30 AM To: DB2-L@RYCI.COM Subject: DECIMAL and SUM
Could someone who has the SAMPLE database set up do me a favor and run the following SQL statements on OS/390? [...]
18002 95 71_Re: Select Distinct vs Open Cursor and Fetch Once - Final Boarding Call13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sun, 11 Mar 2001 11:46:16 -0600347_us-ascii Richard,
I'm trying to close down this thread by providing as much information as possible in this email (it may continue if anyone disagrees though).
I recall a discussion Michael Hannan, Graham Wiltshire and myself had offline on this subject a year or two ago. Roughly the comparison of existance check methods was: [...]
18098 214 29_Re: AIX UDB Mirror + Striping11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Sun, 11 Mar 2001 13:46:54 -0500465_us-ascii Hi Richard,
To your striping questions #1 & #2:
Most of my AIX knowledge is 95% school of hard knocks, this is my disclaimer...
An AIX volume group should/must contain disks of the same type/size. With 2 different disk sizes, you're looking at at least two different VG's.
I don't believe an AIX LV can span multiple VG's, so you would not be able to create one LV striped across all 27 of your disks. What you could do... [...]
18313 46 16_Import utility..8_bharat r20_bharat_321@YAHOO.COM31_Sun, 11 Mar 2001 11:14:46 -0800542_us-ascii Hi list I am facing problem while creating the table using the import(data is in IXF format) and I m getting error.. This is the error.. SQL3310N Column " 0 æ PÄæ " in the PC/IXF file is not valid
Here is the sript which i am executing
CONNECT TO SIEBQA user abcdef using password; ---- EXPORT TO po.dat OF IXF MESSAGES mesg SELECT * FROM EIMLOAD.V_SBL_PO; ---- connect reset; connect to SAMPLE user abcdef using password; --- import from po.dat OF IXF MESSAGES mesg CREATE INTO DB2INST1.T_TEMPPO; [...]
18360 57 30_Re: Default to tablespace scan13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sun, 11 Mar 2001 13:27:18 -0600440_iso-8859-1 Paul,
I am rather sceptical when I "hear" such statements being made about what DB2 does "Always". Don't believe everything you hear or read. Even what you read in the manuals is not always 100% accurate (my personal favourite is in the V7 SQL Reference - Create View - View Restrictions - "A view definition cannot contain unions", then in the examples it shows a view with UNION ALL, obviously a hangover from V6). [...]
18418 43 25_Stored procedure question8_ritu zee22_ritu_98_2000@YAHOO.COM31_Sun, 11 Mar 2001 13:17:20 -0800466_us-ascii Hello ! This is on UDB on Windows. A SQL stored procedure that I created using Stored procedure builder failed during 'build' by the following message:
RITUZEE.PROC2 - Create stored procedure returns -901.
RITUZEE.PROC2: [IBM][CLI Driver][DB2/Windows 95]
SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Prepcompilation/Compilation failed".) SQLSTATEX004 [...]
18462 199 30_-922 db2 data sharing and racf16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Sun, 11 Mar 2001 19:16:39 -0500487_us-ascii Environment DB2 OS/390 V6.1 datasharing
Another Happy Sunday , I have a user getting a -922 authorization error trying to execute a plan.
I have checked the plan in sysibm.plan -operative valid I have checked the bind - ok I have checked the grant - execute to public - ok I have checked the RTT table - correct names etc.- ok I have checked that the user is in the correct racf group- ok I have checked the tables - all valid - db status rw no restrictions. [...]
18662 31 30_Re: Default to tablespace scan13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Sun, 11 Mar 2001 21:52:15 -0600547_- On Sun, 11 Mar 2001 13:27:18 -0600, Terry Purcell wrote:
>I have seen indexes used on 1 page tables. Indexes can avoid a sort, or a 2 >level index + 1 data page I/O is less than the 6 pages you mention. >
And in many cases they can be a lot more than a performance booster. We have a table which is used by batch jobs to put some miscellenous information ( restart etc. ). Each job has a specific row for itself and is not concerned about any other row in the table. There are around [...]
18694 84 22_High OTHER IN DB2 TIME5_Pearl17_panidak@SCB.CO.TH31_Mon, 12 Mar 2001 11:52:27 +0700462_windows-874 Hi List, Our DBA Team checked accounting Report that produced by Omegamon S/W. We found that One Application had performance problem because OTHER IN DB2 TIME vary high (50%-70% when compared with IN DB2 TIME). We used DB2 V5.1 for OS/390 and our application is IBM COBOL-SQL program on CICS V4. How do we investigate cause of this problem or which part of DB2 & OS that we should be consider? If you have any recommendation, please suggest me. [...]
18779 79 20_Re: Import utility..16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 12 Mar 2001 11:05:36 +0530565_iso-8859-1 Where have you brought this IMPORT data from ? It seems the only problems is with the data only. Look at the file contents(not by eyes, but make sure) if it is ok.
Regards, Sanjeev
> -----Original Message----- > From: bharat r [SMTP:bharat_321@YAHOO.COM] > Sent: Monday, March 12, 2001 12:45 AM > To: DB2-L@RYCI.COM > Subject: Import utility.. > > Hi list I am facing problem while creating the table > using the import(data is in IXF format) and I m > getting error.. > This is the error.. > SQL3310N Column " 0 æ PÄæ " in the PC/IXF [...]
18859 203 41_Re: SQLJ and host variables - with "Like"16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 12 Mar 2001 12:15:55 +0530476_iso-8859-1 Hi Venkat,
Is there any new thing with DB2 UDB for OS390 i.e CUSTOMIZER ? Just asking, I am not aware of many thing and this can be one of those. Is this something similar to Optimizer or you just mistyped it. <<<"On the other hand, if you use "ONLINE" option then customizer recognizes the original column width and replaces the arbitrary length with the correct length e.g. a column with CHAR (8) definition will have length as 8 in the DBRM too.">>> [...]
19063 69 19_AW: DECIMAL and SUM12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Mon, 12 Mar 2001 08:15:23 +0100636_iso-8859-1 Hi Valerie,
I got results for any of the 3 statements with QMF and SPUFI. (v5.1 on v2.6)
Kind regards
Thomas
> -----Ursprüngliche Nachricht----- > Von: Valerie J Traurig [mailto:valeriet6@JUNO.COM] > Gesendet am: Sonntag, 11. März 2001 16:30 > An: DB2-L@RYCI.COM > Betreff: DECIMAL and SUM > > Could someone who has the SAMPLE database set up > do me a favor and run the following SQL statements on OS/390? > > 1. SELECT SUM(BONUS)/SUM(SALARY+BONUS+COMM) > FROM DSN8610.EMP > > (This should get a -419 because the resulting precision > and scale algorithms will give you a negative result. > [...]
19133 16 33_James Drewe is out of the office.11_James Drewe20_James.Drewe@AEXP.COM31_Mon, 12 Mar 2001 01:02:28 -0700470_us-ascii I will be out of the office from 03/09/2001 until 03/15/2001.
I will respond to your message when I return. For DBA assistance, please contact Debbie Russell at 602-766-5035 or Duane Foss at 602-766-5662. 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.
19150 53 30_-922 db2 data sharing and racf9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Mon, 12 Mar 2001 08:01:15 +0000415_us-ascii Its worth checking the number of groups - the limit is 245 (at V5). Amazingly, we hit this limit on one of our ids recently. We found that some of the groups worked ok.......and others didnt. Kind Regards, Andy Hunt - Scottish And Southern Energy.
Another Happy Sunday , I have a user getting a -922 authorization error trying to execute a plan. [...]
19204 99 61_Re: RC00E40085 DSNU099I Utility Lock Synchronisation Problem.17_Russell Sparksman30_Russell.Sparksman@CITEC.COM.AU31_Mon, 12 Mar 2001 18:39:06 +1000458_US-ASCII Andy,
Did hear back from IBM? We just hit a similar issue in V6 (rsu0009) test region. Interested in any feedback.
Ta,
Russell Sparksman Ph 3227 6780 Email: russell.sparksman@citec.com.au
>>> Andy Hunt 24/02/01 3:15:10 >>> Hi, At DB2 V5.1. Looking at Listserv archives it looks like other sites have hit this problem (but no APARs posted). Symptoms are... [...]
19304 163 61_Re: RC00E40085 DSNU099I Utility Lock Synchronisation Problem.9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Mon, 12 Mar 2001 09:42:04 +0000523_us-ascii Russell, IBM asked if we had the following maintenance on before they would pursue it......
IRLM : PQ23978 PQ29130 PQ40116 PQ41710 DB2 : PQ30255 PQ34619 PQ39676 PQ41517
We had the following on.. PQ23978 (on) pq29130 (on) pq40116 (not on) pq41710 (not on) PQ30255 (on) pq39676 (not on) pq41517 (not on)
We are going through a 'maintenance freeze' at the moment. The problem appears to have been a 'one-off' (on a test system) and so have decided to delay putting on the above maintenance. [...]
19468 102 34_Re: -922 db2 data sharing and racf0_27_jim.leask@RS-COMPONENTS.COM31_Mon, 12 Mar 2001 10:08:31 -0000668_iso-8859-1 If it is not the 245 group connect limit mentioned earlier. Then I had a problem with some CICS background transactions when I introduced RACF Group authorisations a long while ago. It may be your problem. The manual excerpt is copied in below.
Good Luck, Jim.
APPENDIX1.2.1.3 Sample exit routines
The sample exit routines provide examples of the functions and interfaces described below. They are provided in source code as members of prefix.SDSNSAMP. To examine the sample connection routine, list or assemble member DSN3SATH; for the sample sign-on routine, member DSN3SSGN. To assemble, you must use Assembler H; both routines [...]
19571 38 85_Re: Dynamic Access path change; was: SQL Performance problem with Sequential Prefetch0_18_mebert@AMADEUS.NET31_Mon, 12 Mar 2001 11:33:15 +0100522_us-ascii Rick,
(again I've removed my email for size reasons; I also changed the Subject line) that's what I think as well, but I never heard of DB2 changing the access path like that at runtime (remember, EXPLAIN always resulted in an indexed access). I don't know why the optimiser thinks it is improving matters either (I've said before that I think the optimiser is trying to be far too clever in many cases). Does somebody know whether this behaviour is documented somewhere, and what the conditions are? [...]
19610 58 31_Re: Select MAX strategy (Final)13_Eric THOUMIRE21_eric.Thoumire@NXBP.FR31_Mon, 12 Mar 2001 12:14:03 +0100462_us-ascii Thanks Terry (sorry for the delay, I was away)., You answered my question regarding the fact that, in this case, DB2does not use more "intelligently" its own features.
I knew the effect of the WHERE clause, the use of the DESC index (it's even a leitmotiv for newbies, here), etc. And we have quite a good doc at which we looked before asking the question. So, sorry to those who were misled by my question. I'll be more carefull next time. [...]
19669 56 77_Select Distinct vs Open Cursor and Fetch Once - Final Boarding Call - Add-on.13_Eric THOUMIRE21_eric.Thoumire@NXBP.FR31_Mon, 12 Mar 2001 12:51:42 +0100595_us-ascii Terry, you wrote:
>Cursor with OPTIMIZE FOR 1 ROW, and fetch once >- Generally the best performing due to the ability to inform the optimizer >that one row was required.
To be more accurate (regarding the "one row"), here's an extract of what the documentation states on the subject .
>>You can use the clause the OPTIMIZE FOR n ROWS in your SELECT statements to limit the number of data >>rows that the server returns on each DRDA network transmission. You can also use OPTIMIZE FOR n ROWS >>to return a query result set from a stored procedure. >>The number [...]
19726 78 81_Re: Select Distinct vs Open Cursor and Fetch Once - Final Boarding Call - Add-on.13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 12 Mar 2001 07:44:32 -0600519_us-ascii Eric,
Sorry to correct your correction, but what you have described is the additional functionality of the OPTIMIZE clause for distributed transactions.
The existance check discussion did not introduce the additional complexity that this was to occur across the network. Regardless, the OPTIMIZE clause still works as I suggested, although it also has the properties you mention for distributed applications (but you forgot to say that this only applies to unambiguously read-only cursors). [...]
19805 90 30_Re: Default to tablespace scan14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Mon, 12 Mar 2001 07:57:24 -0600543_Windows-1252 Issac,
Not sure what you were testing, but V6 APAR PQ33429 added NPGTHRSH specifically to address the situation of the optimizer choosing a tablespace scan, rather than an index scan, when there were less than 10 pages (NPAGES<10).
There is obviously more to this, but this was a V7 enhancement, retrofitted to V6. There were always thresholds based on the NPAGES as to when a TS would be better. It was to my knowledge never an externalized number, but I think at one time, it was NPAGES<=15 even. Whatever... [...]
19896 71 85_Re: Dynamic Access path change; was: SQL Performance problem with Sequential Prefetch20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 12 Mar 2001 09:16:52 -0500684_us-ascii Doc
There are few situations, when optimizer changes access path run-time but could you tell us what the explain access path was in terms of QUERY_BLOCK,PAGE_RANGE and PREFETCH ?
There are times, when people tend to forget the importance of PAGE_RANGE column.
-Venkat Pillay
> -----Original Message----- > From: mebert@AMADEUS.NET [SMTP:mebert@AMADEUS.NET] > Sent: Monday, March 12, 2001 5:33 AM > To: DB2-L@RYCI.COM > Subject: Re: Dynamic Access path change; was: SQL Performance problem > with Sequential Prefetch > > Rick, > > (again I've removed my email for size reasons; I also changed the Subject > line) > that's what [...]
19968 13 23_Re: Trigger Question...15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Mon, 12 Mar 2001 09:07:49 -0600358_- Hi
You cannot put any logic, and may it be so simple, into a trigger SQL. There is no IF THEN ELSE or CASE.
================================================ 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.
19982 53 26_Runaway SYSCOPY & SYSLGRNX14_Richard Arnold24_Richard.Arnold@CHASE.COM31_Mon, 12 Mar 2001 09:41:58 -0600473_us-ascii Hello list,
Environment: DB2 V6 for OS/390; MVS/OS/390 02.08.00
We recently inherited a medium-large DB2 application.
It has 4800 partitions and does 2 images per partition per day. The Modify utility was not run for the last several years; so SYSCOPY and SYSLGRNX badly need a clean up.
When we started, we can get MODIFY to run at the partition level, which deletes rows from SYSCOPY, but does not remove anything from SYSLGRNX. [...]
20036 51 41_Re: SQLJ and host variables - with "Like"20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 12 Mar 2001 10:43:12 -0500480_us-ascii Sanjeev
SQLJ is a different beast, it is Java embedded SQL but JVM runs under USS (Unix Systems Services). The program preparation steps are bit different.
1. Translate the Java code with embedded SQL into a modified Java source code and serialized profile. The command which does this is "sqlj". 2. Customizing the serialized profile to produce DBRM. The customizer command is "db2profc". 3. and then the usual binding the DBRM into plan or packages. [...]
20088 28 23_Re: Trigger Question...19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Mon, 12 Mar 2001 09:43:43 -0600561_us-ascii Really ?
I've got some fairly complex triggers (on DB2 UDB v7.1 for Linux) which have all of these !!!
Phil
On Mon, 12 Mar 2001 09:07:49 -0600, Walter Janissen wrote:
>Hi > >You cannot put any logic, and may it be so simple, into a trigger SQL. >There is no IF THEN ELSE or CASE. > >================================================ >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. [...]
20117 32 33_Anybody using Ariba with DB2 AIX?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Mon, 12 Mar 2001 15:50:50 -0000669_iso-8859-1 Hi everyone,
is anybody using Ariba with DB2 AIX V6? and do you happen to have SAP aswell?
If you do maybe you could mail me direct so I can have a quick chat with you about it.
Many thanks
Leslie
********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Sony cannot accept liability for statements made which are clearly the sender's own and not made on behalf of Sony. (03) ********************************************************************** [...]
20150 86 30_Re: Runaway SYSCOPY & SYSLGRNX19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Mon, 12 Mar 2001 10:07:12 -0600361_iso-8859-1 Hi Richard, Maybe someone knows a "fast" way to do this, and you can research the archives, but I'm afraid that you'll just have to MODIFY a week or so worth at a time until you get caught up. And I agree strongly with you; you should have an image copy DSNUM(ALL) for all the partitioned tablespaces to facilitate local, full forward recovery. [...]
20237 70 30_Re: Runaway SYSCOPY & SYSLGRNX26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Mon, 12 Mar 2001 07:55:51 -0800426_iso-8859-1 We had a similar problem at a former employer, which was fixed by reorging the 2 indexes associated with syscopy. Bill Johnson Russell Mellon
-----Original Message----- From: Richard Arnold [mailto:Richard.Arnold@CHASE.COM] Sent: Monday, March 12, 2001 10:42 AM To: DB2-L@RYCI.COM Subject: Runaway SYSCOPY & SYSLGRNX
Hello list,
Environment: DB2 V6 for OS/390; MVS/OS/390 02.08.00 [...]
20308 79 30_Re: Runaway SYSCOPY & SYSLGRNX16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Mon, 12 Mar 2001 11:10:56 -0500353_us-ascii Hi , you may have to limit modify with age(90) get rid of last 90 days and run this a few times. (7 years?). The modifys will get faster the more you delete. HTH Tom F
Richard Arnold on 03/12/2001 10:41:58 AM
Please respond to DB2 Data Base Discussion List [...]
20388 74 30_Re: Runaway SYSCOPY & SYSLGRNX15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Mon, 12 Mar 2001 10:22:42 -0600448_iso-8859-1 Conventional wisdom is just to bite the bullet and get it done! It seems better to do it in smaller bites: The oldest month or three months then the next and so on, rather than one fell swoop.
Andy Lankester BMC Software My opinions are just that
-----Original Message----- From: Richard Arnold [mailto:Richard.Arnold@CHASE.COM] Sent: 12 March 2001 15:42 To: DB2-L@RYCI.COM Subject: Runaway SYSCOPY & SYSLGRNX [...]
20463 54 52_Pipeline Newsletter for DB2 and Oracle - March Issue9_Cam White20_cwhite@REVEALNET.COM31_Mon, 12 Mar 2001 11:39:10 -0500724_iso-8859-1 Reminder: This is the last month to sign up for a chance to win a FREE full conference registration to IDUG in Orlando (travel/meals/accomodations excluded). ----------------------------------------------
The March, 2001 Issue of the Pipeline Newsletter is now available for Oracle and DB2 professionals.
http://www.revealnet.com/newsletter-v2/newsletter_0301.htm
Feature articles include:
- "Getting a Random Sample of Records" - by Bob Mycroft - "DB2 Version 5 to 6 Migration on OS/390" - by Linda Claussen - "Oracle Web Development Case Study" - Knowledge Base Topic - "Free Oracle Indexfile Utility" - by Kurt Van Meerbeeck - RevealNet to Release Formatter Plus (tm) in April [...]
20518 38 30_Re: Runaway SYSCOPY & SYSLGRNX10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 12 Mar 2001 17:27:30 +0100536_us-ascii If you mean REORG DISCARD FROM TABLE SYSIBM.xxxxxxxx WHEN (condition) I think you can't, as in member
DSNDUNLX of SDSNMACS library is stated :
table-name
Specifies the name of the table that is to be qualified by the following WHEN clause. The table must be described in the catalog and must not be a catalog table. If the table name is not qualified by an authorization ID, the authorization ID of the person who invokes the utility job step is used as the qualifier of the table name. [...]
20557 89 30_Re: Runaway SYSCOPY & SYSLGRNX0_18_mebert@AMADEUS.NET31_Mon, 12 Mar 2001 17:32:47 +0100591_us-ascii Hello Richard,
why do you think that a partition-level MODIFY won't clean up SYSLGRNX? It will. There's just the complication that you cannot run a partition-level MODIFY if there are older DSNUM 0 entries for this TS in SYSCOPY. If you have only partition-level entries, you have no problem. There was a big discussion about this topic end of 99/beginning of 2000. Go to the archives, search for Subject MODIFY and authors name "mebert or dan" (the latter is Dan Courter, IBM - see the "MODIFY Performance fix" posting of last month). I had the same problem as you. To [...]
20647 97 30_Re: Runaway SYSCOPY & SYSLGRNX0_17_sjvagnier@AEP.COM31_Mon, 12 Mar 2001 11:29:57 -0500481_us-ascii Richard, I had a similiar problem with DB2 V5 and MVS/OS 390 02.08.00 I could not get the MODIFY to run within our batch window on SYSLGRNX. IBM recommended the following action:
1). Delete SYSLGRNX 2). Redefine SYSLGRNX 3). ReInitialize SYSLGRNX
For a short period of time, any recovery of DB2 objects will run longer since the "shortcuts" to those objects in SYSLGRNX will not exist, but it was a small price to pay for us. This resolved our problem. [...]
20745 21 24_Description of CPU usage11_Carl Newton30_newtonc@INNOVATION-GROUP.CO.UK31_Mon, 12 Mar 2001 16:33:26 -0000550_- All,
Could anyone point me to a detailed description of where CPU usage is accounted for across the address spaces. I am particularly interested in the scenario for a web based app coming in through the xxxxDIST address space i.e. what is recorded in DIST, what in DBM1 etc.
TIA,
Carl.
================================================ 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.
20767 139 30_Re: Runaway SYSCOPY & SYSLGRNX0_17_sjvagnier@AEP.COM31_Mon, 12 Mar 2001 11:53:22 -0500486_us-ascii Richard,
Dr. Ebert states "You can't REORG SYSLGRNX"
We have been running REORG's on SYSLGRNX successfully with no problems under DB2 V5. There is basically three steps: 1). REORG (UNLOAD PAUSE) 2). Delete and redfine SYSLGRNX 3). REORG (RESTART PHASE)
Regards...
Steve Vagnier
mebert@AMADEUS.NET@RYCI.COM> on 03/12/2001 11:32:47 AM
Please respond to DB2 Data Base Discussion List [...]
20907 134 30_Re: Runaway SYSCOPY & SYSLGRNX13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Mon, 12 Mar 2001 08:58:10 -0800417_iso-8859-1 That is a big surprise to me. My understanding (till now) was that DB2 scans SYSLGRNX for all point in time recoveries. But when this recommendation has come from IBM, obviously I am missing something......
Thanks.
-----Original Message----- From: sjvagnier@AEP.COM [SMTP:sjvagnier@AEP.COM] Sent: Monday, March 12, 2001 8:30 AM To: DB2-L@RYCI.COM Subject: Re: Runaway SYSCOPY & SYSLGRNX [...]
21042 53 23_Re: Trigger Question...14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Mon, 12 Mar 2001 10:57:16 -0600513_iso-8859-1 Walter,
Actually you can get fairly sophisticated in Triggers. - CASE in the WHEN clause - CASE in the SET SET NEW.COLUMN = CASE...
And a Trigger can call a Stored Procedure or a User-defined function which can have all kinds of logic.
Regards, Richard
Richard Yevich - Principal Yevich Lawson & Assoc. Inc. (YL&A) Richard_Yevich@YLAssoc.com 1-888-246-5049/1-217-744-0000 http://www.YLAssoc.com -- DB2 Performance Journal http://www.db2-symposium.com -- DB2 Symposiums [...]
21096 152 30_Re: Runaway SYSCOPY & SYSLGRNX15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Mon, 12 Mar 2001 11:31:36 -0600438_iso-8859-1 Steve,
Is there any place I could more details on your steps? Am I correct in understaning that we will not be able to recover across the RBA when SYSLGRNX gets reintialized (sub-system wide backups required?)?
Thank you in advance. -----Original Message----- From: Mohan, Ashish [mailto:Ashish.Mohan@NIKE.COM] Sent: Monday, March 12, 2001 10:58 AM To: DB2-L@RYCI.COM Subject: Re: Runaway SYSCOPY & SYSLGRNX [...]
21249 73 55_Help needed for Space calculations for Incr. Image copy23_Campbell, James B - CNF22_Campbell.James@CNF.COM31_Mon, 12 Mar 2001 09:47:13 -0800366_- I am having problems calculating the DASD space required for Incremental image copies. In using the data from the report below and using the formula
(changed-pages * nKB-Pages) / 1mb = Total DASD needed to take the incremental (nKB = sysibm.systablespace pgsize)
using the first partition listed - for example: ((78*4) / 1024000 ) = .0003046 MB [...]
21323 131 30_Re: Runaway SYSCOPY & SYSLGRNX15_Murley, Michael22_Michael_Murley@BMC.COM31_Mon, 12 Mar 2001 12:11:12 -0600586_iso-8859-1 Steve,
I would have expected recoveries to run faster after this, since they wouldn't have to mess around with applying any of those pesky log records ;~).
Seriously, did IBM give you a way to force the DB2 Recover utility to bypass SYSLGRNX access after this ? We have OPTION NOSYSLGRNG in BMC RECOVER PLUS for DB2*, but I don't remember seeing an externally documented way to force the DB2 Recover utilty to bypass SYSLGRNX and scan the entire log. Did they also recommend that you image copy any space that might require recovery after this procedure ? [...]
21455 95 59_Re: Help needed for Space calculations for Incr. Image copy16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 12 Mar 2001 13:22:08 -0500388_iso-8859-1 James, I think you need to change 78*4 to 78*4096. 4k per page, not 4 bytes per page.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Campbell, James B - CNF [mailto:Campbell.James@CNF.COM] Sent: Monday, March 12, 2001 12:47 PM To: DB2-L@RYCI.COM Subject: Help needed for Space calculations for Incr. Image copy [...]
21551 141 59_Re: Help needed for Space calculations for Incr. Image copy23_Campbell, James B - CNF22_Campbell.James@CNF.COM31_Mon, 12 Mar 2001 10:34:22 -0800487_- Sorry I miss-stated my calculation its as follows - ((78*4)*1024) / 1024000
James (Jim) Campbell Sr. Analyst & Test Systems Coordinator CNF ADTECH Phone: (503) 450-4839 Fax: (503) 450-3629 Email: campbell.james@cnf.com
-----Original Message----- From: Pearson, Eric L, [SMTP:Eric.Pearson@NSCORP.COM] Sent: Monday, March 12, 2001 10:22 AM To: DB2-L@RYCI.COM Subject: Re: Help needed for Space calculations for Incr. Image copy [...]
21693 215 30_Re: Runaway SYSCOPY & SYSLGRNX0_17_sjvagnier@AEP.COM31_Mon, 12 Mar 2001 13:45:07 -0500603_us-ascii The steps are documented in the V5 Utility Guide and Reference (SC26-8967-00) pages 2-207 to 2-209 under the title "Reorganizing the Catalog and Directory". SYSLGRNX is not mentioned in the first paragraph, but IBM said it could also be included in the list.
The way IBM explained it to me is that SYSLGRNX has RBA entries (i.e. shortcuts) that are used by DB2 to shorten the amount of time it would take to recover an object. With SYSLGRNX reinitialized, you can still recover an object, just that the recovery process would take longer period of time because no RBA's (shortcuts) [...]
21909 174 30_Re: Runaway SYSCOPY & SYSLGRNX0_17_sjvagnier@AEP.COM31_Mon, 12 Mar 2001 13:58:46 -0500336_us-ascii Michael,
IBM did not give me a way to force DB2 Recover utility to bypass SYSLGRNX after this time. This recommendation from IBM was to correct a problem we had on a 3-way Data Sharing production environment with SYSLGRNX having too many entries and not being able to meet our batch window with the MODIFY process. [...]
22084 25 56_Pittsburgh - Calling all DB2ers..... Are you out there??10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Mon, 12 Mar 2001 14:17:01 -0500431_us-ascii Greetings!
I am working towards re-activating the DB2 Users Group in the Pittsburgh area this spring.
However, one of my problems is building up a DB2 contact list...
So...... IF you know of DB2 folks in the Pittsburgh vicinity who would be interested in participating, have them drop me an email.
NOTE: There is NO charge associated w/being on this contact list. So the more the merrier! [...]
22110 58 78_Central PA DB2 Users Group - Upcoming 8 classes - Registrations being accepted10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Mon, 12 Mar 2001 14:17:42 -0500368_us-ascii Greetings! I work w/the Central PA DB2 Users Group. I am happy to be hosting the following DB2 classes by a list of excellent industry leading instructors!
The classes are:
3/28 - Susan Lawson - $150 - DB2 Version 6/7 Impacts on Performance
3/29 - Susan Lawson - $150 - DB2 High Performance Design and Tuning [...]
22169 73 11_Bpool Stats6_Chenny39_solaiyappan_chenniappan@MAIL.AMSINC.COM31_Mon, 12 Mar 2001 13:09:34 -0600798_- Hi All,
Can someone agree with me from the following BPool stats that
for Bpool BP10: GETPAGES-RANDOM request of 6223857.46 pages was responsible for the PAGES READ-DYN.PREF of 5795900 pages and for Bpool BP11: GETPAGES-RANDOM request of 1354769.23 pages was responsible for the PAGES READ-LST.PREF of 1312700 pages
BP10 GENERAL QUANTITY -------------------- -------- BPOOL HIT RATIO (%) 5.90 HPOOL HIT RATIO (%) 7.24 HPOOL R/W RATIO (%) 7.23 GETPAGES-SEQ&RANDOM 6232.7K GETPAGES-SEQ.ONLY 8842.54 SYNC.READ-SEQ&RANDOM 60029.08 SYNC.READ-SEQ.ONLY 948.92 SEQ.PREFETCH REQ 139.84 SEQ.PREFETCH READS 139.84 PAGES READ-SEQ.PREF. 8884.76 LST.PREFETCH REQUEST 0.00 LST.PREFETCH READS 0.00 PAGES READ-LST.PREF. 0.00 DYN.PREFETCH REQUEST 267.3K DYN.PREFETCH READS 210.1K [...]
22243 48 12_Colorado DB214_Toppins, Smike21_smike.toppins@GWL.COM31_Mon, 12 Mar 2001 12:25:28 -0700641_- Any sites in Colorado area interested in doing similar? I've contacted IBM about this a few times and they've dropped the ball on this big time.
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
> ---------- > From: Cathy Peck[SMTP:cathy.peck@HIGHMARK.COM] > Reply To: DB2 Data Base Discussion List > Sent: Monday, March 12, 2001 12:17 PM > To: DB2-L@RYCI.COM > Subject: Pittsburgh - Calling all DB2ers..... Are you out there?? > > Greetings! > > I am working towards re-activating the DB2 Users Group in the Pittsburgh > area this spring. > > However, one of my problems is building up [...]
22292 38 41_Accessing DB2 on OS/390 vs Oracle on AIX?14_Jessen Michael27_JessenMichael@JOHNDEERE.COM30_Tue, 6 Mar 2001 10:28:49 -0600401_iso-8859-1 We currently run Business Objects against both Oracle and DB2 Mainframe databases. Within Business Objects, I can tell Business Objects to only return (for example) 200 rows.
When running a query against Oracle, my query finishes as soon as soon as I get my first 200 rows. When running against DB2, my query returns ALL the rows, then Business Objects uses the first 200 rows. [...]
22331 49 16_Re: Colorado DB214_subrata mondal25_subratamondal@HOTMAIL.COM31_Mon, 12 Mar 2001 19:44:32 -0000
22381 25 23_reading >32k in cobol??9_John Cops31_John.Cops@HERITAGEINSURANCE.COM31_Mon, 12 Mar 2001 14:00:09 -0600367_us-ascii i am attempting to read in a pdf from a file and insert it into a table using blobs. i have been able to figure out how to insert into the blobs etc.
my question is how to read something like this into a blob when it is over 32k?
does the blob somehow get defined in the FD? also, i do not know the size of the pdf when i try to read it?? [...]
22407 27 25_Image Copy in Last 7 Days15_Knabach, Mark L20_mark.knabach@EDS.COM30_Tue, 6 Mar 2001 18:50:21 -0500452_iso-8859-1 I am drawing a blank ... can anyone assist with an SQL statement that would query the DB2 catalog and detect any tablespace that has not been Image Copied within the last 7 days? Your help is appreciated. Thanks, in advance.
Mark Knabach EDS - Chicago Solution Centre 1900 S. Springer Drive Lombard, IL 60148 *phone: +01-630-495-3229 (8-520) *fax: +01-630-691-5303 (8-520) * mailto: mark.knabach@eds.com *pager: +01-888-617-2796 [...]
22435 18 8_FixPak 711_Judy Kibler21_judith.kibler@TRW.COM31_Mon, 12 Mar 2001 14:22:24 -0600430_us-ascii Hi folks,
I noticed that DB2 UDB version 6.1 FixPak 7 is now available. Do most of you wait awhile after a Fixpak is released before you install it?
TIA, Judy Kibler
================================================ 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.
22454 70 31_Re: Mainview for DB2 and DB2 PM13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Mon, 12 Mar 2001 12:21:25 -0800551_iso-8859-1 We have been using BMC's Activity Monitor, which is supposed to be replaced later this year by MainView for DB2. Since we are going to be profoundly affected by this change, we installed MainView for DB2 on a trial basis, and I've been _trying_ to use it. We had a half-day of training, but that was not enough to learn how to do historical reporting, so I'm still dependent on Activity Monitor. I am probably not a good person to ask about this, because I don't have time to read up on MainView, but I come away frustrated every time [...]
22525 22 27_DB2 Installer and ServerPac15_Deborah Barrett22_dbarrett@ISS.EBSCO.COM31_Mon, 12 Mar 2001 14:42:24 -0600361_- Hi listmaties,
We are currently OS/390 2r6. We are on DB2v5 about to go to v6.
Has anybody out there tried to do an install using both a ServerPac AND DB2 Installer on the PC? If so, would you recommend it? We are new to the ServerPac process and are unclear as to when we switch over to the DB2 Installer. Any help and advice are welcome. [...]
22548 34 25_Stored Procedure Question15_Morris, Deborah20_DMorris@UNCH.UNC.EDU31_Mon, 12 Mar 2001 16:15:38 -0500401_iso-8859-1 For DB2 Version 6 Work Load Managed (WLM) stored procedures, which DB2 call level interface should be used in the link edit step of the compile.
I see references to use DSNELI & DSNRLI.
When I use DSNELI, I get a -927 sqlcode -THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND [...]
22583 56 31_Re: DB2 Installer and ServerPac36_Enarson, Mike (CC-Database Services)29_Mike.Enarson@CONAGRAFOODS.COM31_Mon, 12 Mar 2001 15:12:03 -0600431_iso-8859-1 Hi Deborah
We ordered the Server pak and I downloaded the DB2 Installer. I ended up going back to the DB2 install clist after the sysprogs had laid down the files and they had proceeded up to the point of the DB2 install and IVP jobs. This was not because of the Server pak, but apparently the DB2 installer will not create the DSNTIJEX job and also it did not upload the DSNTES* (like DSNTESA) sql members. [...]
22640 72 29_Re: Stored Procedure Question11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Mon, 12 Mar 2001 15:26:29 -0600543_us-ascii Use the following: TSO - DSNELI Call Attach - DSNALI RRSAF - DSNRLI
"Morris, Deborah" To: DB2-L@RYCI.COM Subject: Stored Procedure Question Sent by: DB2 Data Base Discussion List
03/12/01 03:15 PM Please respond to DB2 Data Base Discussion List
For DB2 Version 6 Work Load Managed (WLM) stored procedures, which DB2 call level interface should be used in the link edit step of the compile. [...]
22713 56 29_Re: Stored Procedure Question12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 12 Mar 2001 13:37:32 -0800546_us-ascii You need to use DSNRLI. The problem is that you don't have RRS setup properly or else it wasn't started when you did this. Either will give you the -981. --- "Morris, Deborah" wrote: > For DB2 Version 6 Work Load Managed (WLM) stored procedures, which > DB2 > call level interface should be used in the link edit step of the > compile. > > I see references to use DSNELI & DSNRLI. > > When I use DSNELI, I get a -927 sqlcode -THE LANGUAGE INTERFACE > (LI) WAS > CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT [...]
22770 18 38_Are Identity columns supported by EEE?12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 12 Mar 2001 14:06:45 -0800487_us-ascii If not, does anyone know a timeframe? They've been in OS/390 over a year now?
__________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.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.
22789 27 47_Advantages of EEE versus EE on a single machine12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 12 Mar 2001 14:15:02 -0800474_us-ascii I'm don't think there are any major advantages to using EEE rather than EE on a single machine (it's an 8-way M80 running AIX). That is, other than getting familar with setting up nodegroups, autoloader, etc, before the application outgrows a single machine, and I have to scale it up. Anyone want to set me straight, or point me at the correct doc? I kind of see this as setting up datasharing in a single lpar environment...way more trouble than it's worth. [...]
22817 41 42_Re: Are Identity columns supported by EEE?12_Cook, Nicole19_Nicole_Cook@BMC.COM31_Mon, 12 Mar 2001 16:25:32 -0600479_iso-8859-1 Yes, you can use Identity columns in EEE.
Nicole Cook DB2 UDB Platform Specialist Product Management DataOneSolutions bmcsoftware Austin, Texas 512.340.6817 800.841.2031 ncook@bmc.com
-----Original Message----- From: tim malamphy [mailto:timalamphy@YAHOO.COM] Sent: Monday, March 12, 2001 4:07 PM To: DB2-L@RYCI.COM Subject: Are Identity columns supported by EEE?
If not, does anyone know a timeframe? They've been in OS/390 over a year now? [...]
22859 26 33_Re: Control center for DB2 OS/39013_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Mon, 12 Mar 2001 16:24:08 -0600385_- The software for DB2 Connect V6 may be free, but you have to pay for the licensing. I believe with DB2 Connect EE, you pay for concurrent users and with DB2 Connect PE, you pay for "possible" users (# of machines software is installed on). This was the way it was explained to me by our IBM sales rep. (DB2 Connect PE runs on a workstation and DB2 Connect EE runs on a server). [...]
22886 73 29_Re: Stored Procedure Question18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Tue, 13 Mar 2001 08:53:32 +0930560_us-ascii Howzit Deborah?
Use DSNRLI. Resource Recovery Services (RRS) with associated system logger setup must be enabled to support DB2 RRSAF Attach as part of the DB2 WLM environment.
Cheers
Bruce Williamson
DB2 Database Administrator DCIS NT Government Darwin NT 0800
"Morris, Deborah" @RYCI.COM> on 13/03/2001 06:45:38
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
22960 41 24_DB2 for W98 V6.1 and JVM15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 13 Mar 2001 10:39:09 +1100579_- Some help, please, from those of you who have installed DB2 for Windows 98 V6.1. I'm finally getting off my overweight inactive posterior and trying to do the V6 certification guide, now that I've got a laptop to install it on. The install eventually worked (I wasn't seeing the prompts when installing from the book's CD that the book said I should, so I uninstalled and installed from a demo CD I picked up somewhere. Much better) but when I try to start the Command Center (sp) I get arguably the world's most annoying error message, saying it couldn't find/load/start [...]
23002 65 21_DB2/SMS Data Security16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Mon, 12 Mar 2001 23:45:47 +0000602_us-ascii ----- Forwarded by Aurora E DellAnno/CAM/Candle on 03/12/2001 11:45 PM ----- |--------+-----------------------> | | Reed Petty | | | | | | | | | 03/12/2001 | | | 08:52 PM | | | Please | | | respond to | | | IBM Mainframe| | | Discussion | | | List | | | | |--------+-----------------------> >----------------------------------------------------------------------------| | | | To: IBM-MAIN@BAMA.UA.EDU | | cc: (bcc: Aurora E DellAnno/CAM/Candle) | | Subject: DB2/SMS Data Security | >----------------------------------------------------------------------------| [...]
23068 36 23_DB2 UDB ODBC on Solaris14_M. R. Database19_MR.DATABASE@HEB.COM31_Mon, 12 Mar 2001 18:01:00 -0600459_- Greetings!
I'm having trouble installing the RunTime Client with ODBC connectivity to a DB2 UDB server. The client is a Solaris E450, and the server is running on Windows NT.
The DB2 UDB V6.1 Installation and Configuration Supplement, page 177, under "UNIX Client Access to DB2 Using CLI/ODBC", item #2 states:
"The DB2 CLI/ODBC driver is an optional component during the DB2 client install. Be sure it is selected at that point." [...]
23105 60 27_Re: reading >32k in cobol??14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 13 Mar 2001 11:58:33 +1100606_iso-8859-1 John
A few weeks ago I posted some code outlining some COBOL/CLOB coding techniques. The differences between BLOB and CLOB coding is minimal.
What I would do in your situation is - have a BLOB variable of whatever size is convienient (it can be over 32k in size - in which case PDF-DATA-DATA will be a group of FILLERs), say PDF-DATA - have a BLOB LOCATOR variable, say PDF-BLOB-LOCATOR - have a (COBOL?) PIC S9(9) COMP variable - say PDF-BLOB-LENGTH - EXEC SQL FETCH INTO :PDF-BLOB-LOCATOR - EXEC SQL SET :BLOB-LENGTH = LENGTH(:PDF-BLOB-LOCATOR) -- this is the length of the [...]
23166 19 31_Can we switch off Db2 logging??0_31_Ross_Mallett@SEARCHSOFTWARE.COM31_Tue, 13 Mar 2001 12:49:12 +1000322_us-ascii Currently, I have a problem with enormous quantities of db2 logs being generated.
As this is a software development site, we don't actually have databases that we have any desire to recover.
Is there any way that one can switch off logging on DB2 so my disks don't fill up with unwanted logs?? [...]
23186 37 35_Re: Can we switch off Db2 logging??14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 13 Mar 2001 14:01:15 +1100463_iso-8859-1 OS/390? This topic was raised a couple of weeks ago - check the archives.
/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Ross_Mallett@SEARCHSOFTWARE.COM [mailto:Ross_Mallett@SEARCHSOFTWARE.COM] Sent: Tuesday, 13 March 2001 13:49 To: DB2-L@RYCI.COM Subject: [DB2-L] Can we switch off Db2 logging??
Currently, I have a problem with enormous quantities of db2 logs being generated. [...]
23224 43 48_CA Log Analyser - Performance problem and errors22_drdeath@ozemail.com.au22_drdeath@OZEMAIL.COM.AU31_Tue, 13 Mar 2001 05:19:14 "GMT"326_us-ascii List Server Patrons
Yet another poser, this time with CA Log Analyser. Since we went DB2V6, our Log Analyser jobs are running interminably slowly and using a huge amount of CPU. We are on release 97H (actually v1.4.6). Has anyone else out there had similar problems and can suggest possible work arounds. [...]
23268 58 51_Re: Advantages of EEE versus EE on a single machine11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 13 Mar 2001 00:18:30 -0500476_us-ascii Hi Tim,
Right on.
There's a rule of thumb, originally from the Toronto lab I think, 1 CPU per 30 GB of data. With an 8-way, you're good for 240GB. Be sure to turn on INTRA_PARALLEL if this is a decision support database. A 4K page size tablespace would normally be limited to 64GB, you could avoid this limit with EEE. But, if the DB is that big, you wouldn't be on an M80. Having a root canal as a preventative measure is also a good idea. [...]
23327 48 27_Re: Redbook UDB 7.1 AIX ESS20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Tue, 13 Mar 2001 08:14:44 +0100497_iso-8859-1 Hi again, Sorry but I still receive notes on this topic: as I told last time I got confused and the document I was speaking of isn't really a redbook but some sort of other IBM document (white papers) ; I hope I didn't make alot of people lose their time . However here is all the information I can give you : this is the link to the .pdf file of the book I had cited. The title is exactly that one, but strangely I couldn't find it on IBM site again... at the end I found it with [...]
23376 46 23_Re: Trigger Question...15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 13 Mar 2001 01:45:33 -0600392_- Richard
I know that, but what I meant was, you cannot code in the trigger body something like: UPDATE something; IF SQLCODE = 100 THEN INSERT something as I think the author of this thread would do.
But to come back to the original problem, I think you can achieve what you wanted with two triggers for the update using appropriate WHERE-clauses in the trigger body SQL. [...]
23423 86 50_Re: what's best way to re-size buffer pools daily?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 13 Mar 2001 07:48:31 -0000510_iso-8859-1 If you want Johns paper I have a copy ... mail me direct. I can supply hard ansoft copies.
regards
Leslie
-----Original Message----- From: Vassie, Edward [mailto:Edward_Vassie@BMC.COM] Sent: Friday, February 02, 2001 5:42 PM To: DB2-L@RYCI.COM Subject: Re: what's best way to re-size buffer pools daily?
The first thing is to check your maintenance levels. If you are way behind, you will be missing some important fixes, especially for HP resizing. [...]
23510 26 31_Re: Mainview for DB2 and DB2 PM10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 13 Mar 2001 09:16:57 +0100470_us-ascii Hi
I'm currently using Mainview for DB2 and I used DB2PM some years ago.
In my opinion for online survey Mainview is better and easy-to-use, DB2PM online is not so easy. Mainview historical tables are quite good and you can obtain a lot of infos in some prefixed time slices. On the contrary I prefer DB2PM for batch reports, you can easily obtain a global & quick view of the system and of the problems, Mainview is more 'difficult' to use. [...]
23537 107 44_Re: Zparm CONTSTOR - contract thread storage23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 13 Mar 2001 08:42:05 -0000552_iso-8859-1 ....Hi Cliff,
like all things the true answer to this is "it all depends". If you think about it by setting CONSTOR to YES you are asking DB2 to perform Storage Contraction when the "calculated" threshold (SC) value is breached. Lets say you have 50Mb of stoage left in DBM1 and SC is calculated at 40Mb. DB2 has the potential, becuase we are close to SC value, to hit SC regularly. When DB2 hits the SC value it will burn CPU while it processes each thread in turn and claws back storage. Imagine the hit on our system which is [...]
23645 55 30_Re: Runaway SYSCOPY & SYSLGRNX0_18_mebert@AMADEUS.NET31_Tue, 13 Mar 2001 10:10:15 +0100571_us-ascii Well, if that isn't a pleasant surprise (DB2 V5, OS390)...
Craig Mullins DB2 Developers Guide (3rd and 4th editions) states explicitly that SYSUTILX and SYSLGRNX cannot be REORGed. SYSLGRNX is not in the list of directory TSs that can be REORGed in the DB2 V5 & V6 Utility Guide (both paper and CD versions available to me). In the V6 Utility Guide, it is explicitly stated that SYSLGRNX cannot be REORGed. In the V5 Guide, SYSLGRNX is -not- in the list of TSs that cannot be REORGed (i.e. it's neither pro nor con). So I remember that I once simply [...]
23701 34 44_Re: Zparm CONTSTOR - contract thread storage10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 13 Mar 2001 10:08:30 +0100521_us-ascii Hi Leslie.
I developed a similar REXX to calculate (approx) the totale memory usage for our DB2, a rexx based on John Campbell's article in Solution Journal and presentation in Share web site.
Now I've a test LPAR and I was curious to test if my calculations were correct, so I started a 'naked' DB2 (I call this DB2 a 'naked singularity' using a concept from the physics of black holes, as it is an unreal DB2) and I'm trying to calculate the storage consumption under controlled conditions. [...]
23736 80 84_=?iso-8859-1?Q?RE=3A_R=E9f=E9rence=3A_Platinum_Tools_With_DB2_?= =?iso-8859-1?Q?V6?=23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 13 Mar 2001 09:16:55 -0000563_iso-8859-1 We had problems here. However, with D things are being sorted.
regards
Les
-----Original Message----- From: Marcel Lepage [mailto:marcellepage@MONCOURRIER.COM] Sent: Tuesday, March 06, 2001 5:37 PM To: DB2-L@RYCI.COM Subject: Référence: Platinum Tools With DB2 V6
Hi,
The migration to DB2 V6 from V5 went ok.
Platinum 99C was not running well on DB2 V5 for RC/Migrator with compare tool. This problem is also present with DB2 V6. I would like to know if you encountered problems with RC/Migrator. [...]
23817 119 19_Re: Recovery JCL...23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 13 Mar 2001 09:20:06 -0000320_iso-8859-1 hi
why don't you have the recover statements all in one step. We have the upper limit for DD statement set to 3276 or whatever it is ..
we then have
stepname Exec Utilb dd 1 dd 2 refer back to 1 (no need for vol=ser every time) . . . dd n sysin * recover db.ts 1 db.ts 2 . . db.ts n [...]
23937 68 27_Re: Recovery Ends With RC=823_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 13 Mar 2001 09:21:11 -0000690_iso-8859-1 John
sounds like a bug to me .. . have you asked IBM or checked the APAR database?
Leslie
-----Original Message----- From: John Bucaria [mailto:jbucaria@MAIL2.PCH.COM] Sent: Friday, March 02, 2001 9:29 PM To: DB2-L@RYCI.COM Subject: Recovery Ends With RC=8
Hello Folks,
I recently attempted a recovery of a DB2 V5 - 20 partition tablespace and its indexes (a nonunique partitioning and a unique non-partitioning) which ended with RC=8. I was running 5 jobs concurrently with each job attempting to recover 4 partitions. After each job successfully loaded a single data partition, they all terminated with RC=8 due to duplicate key [...]
24006 77 44_Re: Zparm CONTSTOR - contract thread storage23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 13 Mar 2001 09:34:56 -0000492_iso-8859-1 Max
hi,
I am going to second guess what somebody(IBM developers) with detailed understanding of JCs paper would say. The calculations are based on an active system and are not 100% watertight. I tend to use my gutt feel on everything on DB2 & SAP and normally it never lest me down. Using this on the calc program I have has seen it correct, in a very active systems, with 5% margin for error. Not bad when you consider the many hundreds of things at play here. [...]
24084 21 7_OPTHINT16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Tue, 13 Mar 2001 09:45:00 -0000439_- Anyone out there having observed this behaviour when OPTHINT activated in ZPARM ?
I have a friend who just upgraded their datasharing group to DB2 V6 where OPTHINT is set to YES in ZPARM.
A plan with bound with packages (neither plan or packages have OPTHINT) is executed from a NON-datasharing V6-subsystem using three-part-name into the datasharing group suddenly starts to scan PLAN_TABLE on the datasharing group. [...]
24106 69 22_Re: Websphere on OS39023_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 13 Mar 2001 09:39:18 -0000401_iso-8859-1 I do beleive SQLJ is due to get better this year ??
Les
-----Original Message----- From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] Sent: Thursday, March 08, 2001 7:33 PM To: DB2-L@RYCI.COM Subject: Re: Websphere on OS390
The setup is very complex. The product on the OS/390 is in infancy compared to other platforms e.g. EJB is not supported etc. [...]
24176 53 52_Re: CA Log Analyser - Performance problem and errors14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 13 Mar 2001 09:57:53 -0000390_iso-8859-1 Tony,
P97H is a VERY bad version to be running on Version 6 of DB2. It has toleration of V6 but absolutely no exploitation
You should be at P99D - do you have any plans to upgrade soon (hint hint!).
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
24230 56 27_Re: Recovery Ends With RC=80_18_mebert@AMADEUS.NET31_Tue, 13 Mar 2001 11:02:53 +0100381_us-ascii Hi John,
I don't understand the error you're getting (I would expect Resource unavailable or Incompatible Utilities), but I seem to remember (from experience) that the REBUILD INDEX statement you're using will rebuild partition #n of the Partitioning Index and ALL NPIs (not just the corresponding logical partition). So you'd be rebuilding your NPI 20 times. [...]
24287 42 13_Re: Rollbacks14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Tue, 13 Mar 2001 06:42:25 -0600586_iso-8859-1 Issuing a rollback when it is not needed does not matter if you have spare CPU capacity to waste, no lock contention, and no response time constraints.
When you issue a rollback, you can expect your update transaction response times to at least double. Even read-only transactions will increase in elapsed time. The reason is obvious: You do some work, then tell DB2 to undo the work. A rollback will take longer to complete than the original updates, because DB2 has more work to do. You also retain locks for a longer time, which can affect throughput. [...]
24330 23 30_Re: Default to tablespace scan14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Tue, 13 Mar 2001 06:56:02 -0600283_iso-8859-1 In any situation where DB2 determines it is cheaper to do a tablespace scan than use an index, DB2 will do a TS scan. In just about any situation you can imagine, if there are only very few pages in a tablespace, it will be cheaper to do a scan than to use an index. [...]
24354 94 15_Re: Bpool Stats14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Tue, 13 Mar 2001 07:07:32 -0600381_iso-8859-1 Random getpages can give rise to dynamic prefetch. Sequential getpages (not random!) can give rise to list prefetch.
Where are the decimal places coming from in your stats?
Your hit ratios seem very low. How big are your pools, how much storage is there on your machine, how much storage is being used, and what is your strategy for your bufferpools? [...]
24449 146 32_Re: UDB V7.1 ... Export Question16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 13 Mar 2001 12:55:37 +0000360_us-ascii Hi all,
at the UK GSE meeting yesterday this issue was raised with the IBM guys who were there, and apparently it is very high in the list of priorities as a Change Request (the question was "Have you done it for v7?").
Still, one has to wonder why they don't just do it, but even the IBM speaker was not too sure about this... :-) [...]
24596 144 19_Re: Recovery JCL...16_Dash, Sushanta K21_sushanta.dash@EDS.COM31_Tue, 13 Mar 2001 05:38:59 -0600297_- Some times this method gives us problem like if we go for referback. The problem comes as -813 with reason code 4. Which is unable to open tape or like that. Instead better to go for vol with ser as well lable=(1,sl) for first dd then continue with lable=(2,sl) and so on like lable=(n,sl) [...]
24741 14 27_Re: Redbook UDB 7.1 AIX ESS13_Villa Horacio17_hvilla@TTI.COM.AR31_Tue, 13 Mar 2001 10:28:21 -0300360_iso-8859-1 Try http://www-3.ibm.com/software/data/db2/udb/aix/ I found it on Google, just like you said. Horacio Villa
================================================ 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.
24756 69 13_Re: Rollbacks13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 13 Mar 2001 07:39:11 -0600500_iso-8859-1 Edward,
Could you state the obvious for me and tell me why the read-only transactions will see increased elapsed time. I expect that no work would be required, except locks being released.
Also you mention " Having a transaction that makes an update, presents information that can be copied by the user, then rolls back the update is a standard way of committing fraud. " I would expect pseudo conversational transactions to be used and this situation would not happen. [...]
24826 36 39_Select Distinct .../... Add-on: Thanks.13_Eric THOUMIRE21_eric.Thoumire@NXBP.FR31_Tue, 13 Mar 2001 14:44:02 +0100309_us-ascii Excellent ! Terry. I forgot how slipping the Shakespear's language can be sometimes for me. Shame on me: I took a dangerous shortcut, there. And don't be sorry. You prevented me from misguiding someone with a bad info. I'm pleased indeed to have sent you my (bad) remark. Thanks again. Regards. [...]
24863 57 47_VSAM use in DB2 stored procedures address space12_Fertaki Gina20_GFertaki@EUROBANK.GR31_Tue, 13 Mar 2001 16:11:39 +0200628_iso-8859-7 Hello everyone, We are moving legacy applications in our installation from our AS/400 to OS/390 system , but some applications will remain on the AS/400 and will require access to DB2 OS/390. This access (inquiries, updates, etc) will be implemented via calls to stored procedures on the OS/390 thru a DRDA connection between the two systems. The application requirements are such that it is required that the stored procedures access a VSAM file that is declared as DISP=SHR in the startup procedure of the DB2 stored procedures address space. The NUMTCB parameter of the stored procedures address space is set [...]
24921 44 23_Re: Trigger Question...14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Tue, 13 Mar 2001 08:35:11 -0600495_iso-8859-1 Walter,
Yes! The missing ability to check the SQLCODE in a trigger is especially troublesome when CALLing a STORED PROCEDURE. Also, the inability to use a scalar subquery in the SET statement is annoying. Perhaps after V7 we will see some more improvements in those areas
Regards, Richard
Richard Yevich - Principal Yevich Lawson & Assoc. Inc. (YL&A) Richard_Yevich@YLAssoc.com 1-888-246-5049/1-217-744-0000 http://www.YLAssoc.com -- DB2 Performance Journal [...]
24966 96 51_Re: VSAM use in DB2 stored procedures address space12_Mark Granger22_the_grange@MBOX.COM.AU31_Tue, 13 Mar 2001 09:38:08 -0500478_us-ascii Gina, What SHAREOPTions have you got on the VSAM file ? It would seem 3's or 4's would be appropriate.
Mark Granger Independent Systems Integrators P/L Senior Technical Specialist - 2BDB2 Email: mgranger@isi.com.au Phone: +61 0416-012-262 (Australia) OR +1 617-306-7794 (USA)
----- Original Message ----- From: Fertaki Gina Date: Tuesday, March 13, 2001 9:11 am Subject: VSAM use in DB2 stored procedures address space [...]
25063 22 21_SQL Stored Procedures11_Carl Newton30_newtonc@INNOVATION-GROUP.CO.UK31_Tue, 13 Mar 2001 14:57:14 -0000495_- All,
Environment - DB2 V6 for OS/390
Do you need to use the SPB or DSNTPSMP to create C programs from SQL stored procedures even if the procedure only uses std SQL and none of the procedural statements available?
TIA,
Carl.
================================================ 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.
25086 53 25_Re: SQL Stored Procedures14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Tue, 13 Mar 2001 09:19:41 -0600700_iso-8859-1 Yes. There is still no way to get an executable, regardless of what is in the SQL Procedure code. Still need that load module and package...
Regards, Richard
Richard Yevich - Principal Yevich Lawson & Assoc. Inc. (YL&A) Richard_Yevich@YLAssoc.com 1-888-246-5049/1-217-744-0000 http://www.YLAssoc.com -- DB2 Performance Journal http://www.db2-symposium.com -- DB2 Symposiums
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Carl Newton > Sent: Tuesday, March 13, 2001 8:57 AM > To: DB2-L@RYCI.COM > Subject: SQL Stored Procedures > > > All, > > Environment - DB2 V6 for OS/390 > > Do you need to use [...]
25140 100 26_Re: Dataspace vs hiperpool16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 13 Mar 2001 15:32:12 +0000437_us-ascii Eric,
did you get any responses to this?
I didn't see any, so may I just mention that in the same old GSI meeting of yesterday, John Campbell from IBM mentioned that the CPU overhead was negligible and a few other things.
I am afraid I do not remember his exact wording, maybe one of the other people who were there might like to comment or expand on this subject. No personal experience of this, btw. [...]
25241 17 7_Varchar12_Aditya Narra31_Aditya.Narra@NYCBOE.NYCENET.EDU30_Tue, 6 Mar 2001 12:04:00 -0500424_- Hi All How do i define a table with varchar.I have a table in SQL server with varchar and I want to create a similar table in DB2.Any help would be appreciated. Regards, Audi
================================================ 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. [...]
25259 54 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?0_18_mebert@AMADEUS.NET30_Tue, 6 Mar 2001 18:10:14 +0100501_us-ascii I've never used or even seen BO myself, but BO queries are a known pain... In DB2 on OS390, you can of course OPEN a cursor, FETCH 200 times, then CLOSE the cursor. But it seems from your description that BO simply passes the SQL to DB2, then FETCHes in a loop until it sees an SQLCODE of +100 (buffering all rows somewhere), and only then passes the rows on to the end user, now limiting the number of rows. Thus, I would say that BO is too stupid. I bet it has a GUI (joke - I know it [...]
25314 45 44_Onl reorg termed but shadow datasets remain.15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Tue, 6 Mar 2001 11:04:57 -0600636_iso-8859-1 DB2 V6.1 on OS390.
An on-line reorg job terminated. It conflicted with a long running read program. It appears to be a controlled DB2 termination as a result of the parms "LONGLOG TERM DELAY 1200". What puzzles us are the following... 1) The shadow datasets remain along with the regular 2) SYSPRINT has the message DSNU387I DSNURSWT - SWITCH PHASE COMPLETE, ELAPSED TIME = 00:00:01 Followed by the failure messages with X'00C9008E'. 3) the DB2 LOG shows that at the time of the reorg termination there was a series of failures to delete datasets of the form SS.DSNDB*.DBNAME.SPACNAM.T001.A001....note the fourth [...]
25360 27 26_Platinum Tools With DB2 V610_Wong, S.P.15_sp.wong@HBC.COM30_Tue, 6 Mar 2001 11:51:35 -0500332_- Hi Listers:
We are going to upgrade DB2 for OS/390 from R5.1 to R6.1 using ServerPack dated Feb 9, 2001.
We also use Platinum DB2 tools for OS/390 at P99C level going to P99D level.
I would like to have some comments from all listers who also use Platinum about their experience in Platinum with DB2 V6. [...]
25388 131 26_Re: Dataspace vs hiperpool16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 13 Mar 2001 10:45:27 -0500416_iso-8859-1 IBM did not give an answer of any substance in response to the ETR. They merely quoted from the same manuals I read to formulate the question.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Aurora Dell'Anno [mailto:Aurora_E_DellAnno@CANDLE.COM] Sent: Tuesday, March 13, 2001 10:32 AM To: DB2-L@RYCI.COM Subject: Re: Dataspace vs hiperpool [...]
25520 20 19_Chicago opportunity9_Mike Mays18_MMays@NOLLJOBS.COM30_Tue, 6 Mar 2001 15:46:44 -0600493_- Dear Listers: An opportunity has become available in the Chicagoland area for a UDB-DBA. If there is any interest and for more details, please contact the number or email below. Thanks.
Mike Mays mmays@nolljobs.com 800-798-7736 ext 3450
================================================ 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. [...]
25541 15 30_Re: Platinum Tools With DB2 V612_Richard Pack23_rpack1@MAIL.STATE.MO.US30_Tue, 6 Mar 2001 15:36:50 -0600460_- We are at the P99C level and have found many problems. Specifically in PRA for the Disaster Recovery part that has resulted in fixes for P99D and P99E. Highly recommend P99D at least with all the lastest PTF's.
================================================ 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. [...]
25557 34 11_Re: Varchar13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 6 Mar 2001 12:23:07 -0500277_iso-8859-1 Hi Audi, If my answer is too simple and I missed a part of your question, please post back. Here is an example of a table containing a varchar column. Were you looking for more advice on the complexities of varchar ? Perhaps if you show us the SQLserver DDL... [...]
25592 70 42_Re: Are Identity columns supported by EEE?15_Stacey L Waters23_waterss1@NATIONWIDE.COM31_Tue, 13 Mar 2001 09:48:57 -0600484_us-ascii Tim, You currently cannot use identity columns on partitioned tables. You can find some info in Administration Guide: Implementation p 126 Defining an identity Column on a New Table.
Stacey Waters
"Cook, Nicole" @RYCI.COM> on 03/12/2001 04:25:32 PM
From: "Cook, Nicole" @RYCI.COM on 03/12/2001 04:25 PM
Please respond to DB2 Data Base Discussion List [...]
25663 93 43_Re: end of service dates - db2 connect v5.x12_Kirk Hampton16_khampto1@TXU.COM30_Tue, 6 Mar 2001 16:16:42 -0600454_us-ascii I forwarded this around our shop, and I was asked: "does the service end date include everything to do with version 5.2, including the CAE-only clients, or does it mostly pertain to Personal Edition or the EE gateway code ? " My initial reaction was that all of it is considered DB2 Connect, even a CAE-only installation on a desktop, so we needed to upgrade those clients also, to stay supported. Can anyone tell me if I am wrong ? Leon ? [...]
25757 35 30_Re: Platinum Tools With DB2 V69_Rob Crane22_racrane@CONCENTRIC.NET30_Tue, 6 Mar 2001 10:35:02 -0700554_us-ascii Need to get on P99D..
"Wong, S.P." wrote: > > Hi Listers: > > We are going to upgrade DB2 for OS/390 from R5.1 to R6.1 using ServerPack > dated Feb 9, 2001. > > We also use Platinum DB2 tools for OS/390 at P99C level going to P99D level. > > I would like to have some comments from all listers who also use Platinum > about their experience in Platinum with DB2 V6. > > TIA. > > S.P. > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at [...]
25793 79 48_Re: Onl reorg termed but shadow datasets remain.0_19_Tim.Lowe@STPAUL.COM30_Tue, 6 Mar 2001 11:43:11 -0600556_us-ascii I believe that the original datasets (.I0001) are renamed to temporary datasets (.T0001), Then the shadow datasets (.S0001) are renamed to the original (.I0001). This completes the "switch" phase, then the "temporary" datasets (.T0001) are deleted. This makes rollback possible. If I am wrong, perhaps someone can correct me?
Tonmoy Dasgupta cc: Sent by: DB2 Data Base Subject: Onl reorg termed but shadow datasets Discussion List remain. [...]
25873 44 30_Re: Platinum Tools With DB2 V624_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Tue, 6 Mar 2001 09:40:44 -0800575_- We've had a problem with the 99c level of Platinum on the Fastload utility. If the primary allocation is insufficient to hold the rows being loaded, the secondary allocation is ignored, and the platinum utility uses a 1 track secondary.
> -----Original Message----- > From: Wong, S.P. [SMTP:sp.wong@HBC.COM] > Sent: Tuesday, March 06, 2001 8:52 AM > To: DB2-L@RYCI.COM > Subject: Platinum Tools With DB2 V6 > > Hi Listers: > > We are going to upgrade DB2 for OS/390 from R5.1 to R6.1 using ServerPack > dated Feb 9, 2001. > > We also use Platinum DB2 tools for [...]
25918 175 26_Re: Dataspace vs hiperpool0_20_John_Lendman@FPL.COM31_Tue, 13 Mar 2001 11:14:58 -0500360_us-ascii Roger Miller had said at SHARE that they do not recommend this with out the oZ type software and hardware. John Campbell also said the same thing. They did not put a number on the extra CPU usage, but it sounded to me that they had tried this in the lab and the performance was worst that with the VP,HP. Just my opinion of what they didn't say. [...]
26094 35 18_Test Please ignore10_Ian Potter51_ian_potter/manserv/jlp_at_johnlewis@JOHNLEWIS.CO.UK28_Tue, 6 Mar 2001 16:01:19 GMT476_US-ASCII Ian Potter DBA Team Technical Support Tel. 020 7307 4735 Email: Ian_Potter@JohnLewis.co.uk
*********************************************************************
Notice: This email is confidential and may contain copyright material of the John Lewis Partnership. If you are not the intended recipient, please notify us immediately and delete all copies of this message. (Please note that it is your responsibility to scan this message for viruses). [...]
26130 44 57_=?iso-8859-1?B?Uulm6XJlbmNl?=: Platinum Tools With DB2 V613_Marcel Lepage28_marcellepage@MONCOURRIER.COM30_Tue, 6 Mar 2001 12:37:27 -0500
26175 35 25_DB2 V7 GA Announced Today14_Richard Yevich17_ryevich@YAHOO.COM30_Tue, 6 Mar 2001 09:57:32 -0800373_us-ascii DB2 for OS/390 and z/OS general availability was announced today by IBM. Product available March 30. The library on the IBM site has been updated with all the new manuals, and there are several new ones.
===== Regards, Richard +====+ DB2 UDB OS/390 & z/OS Certified DBA richard_yevich@ylassoc.com YL&A -- 1-217-744-0000 www.ylassoc.com [...]
26211 80 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?14_Jessen Michael27_JessenMichael@JOHNDEERE.COM30_Tue, 6 Mar 2001 12:12:01 -0600344_iso-8859-1 I also think this is what is happening (only at the end are the rows being passed back)... but I'm still wanting to understand why. Is this a limitation in DB2 connect/DRDA, or is this a limitation in Business Objects? What would be needed for a client app (in my case, BO) to control the # rows being returned by DB2 (OS/390)? [...]
26292 75 51_Re: Stranded Utility from 5.1 but system is now 6.112_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL30_Tue, 6 Mar 2001 11:35:44 -0500310_us-ascii Looks like to me some failed to read step 9 in the installation migration V6.1 guide. But you will need to take DB2 down,
blow the sysutilx and rebuild and initialize, There are procedures to do this somewhere, but when I did it I contacted level 2 support and they stepped us through it. [...]
26368 22 58_Re: Latin Phrases for every day use!- In a DBA environment0_24_John_McComb@VANGUARD.COM30_Tue, 6 Mar 2001 11:38:01 -0500455_us-ascii I've been in this business so long my first Cobol manual was in Latin. It began:
"Cobolum est omnis divisa in divortium quattuor."
John McComb (with apologies to Julius Caeser)
================================================ 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. [...]
26391 31 65_Re: Unqualified table names in Power Builder using DB2 Connect v712_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Tue, 6 Mar 2001 10:37:13 -0600390_us-ascii Hello, per our PB guy...
You can use can use unqualified table names in Powerbuilder with DB2 Connect to access DB2 on OS390. Just add a key to the section in your pbodb70.ini file that relates to your DB2 database. The key string should be "PBTableOwner=NO". Set the CURRENTSQLID in your ODBC configuration under the Enterprise tab for the CLI/ODBC advanced settings. [...]
26423 96 42_Re: Are Identity columns supported by EEE?12_Cook, Nicole19_Nicole_Cook@BMC.COM31_Tue, 13 Mar 2001 10:38:53 -0600394_iso-8859-1 Thank you for correcting me Stacy, I thought I had implemented Identity columns on our EEE systems, but now I remember why I had to write a program to calculate values for me....I guess I need to increase my ginko intake.
Nicole Cook DB2 UDB Platform Specialist Product Management DataOneSolutions bmcsoftware Austin, Texas 512.340.6817 800.841.2031 ncook@bmc.com [...]
26520 21 19_DB2 UDB and Connect11_Paul Murphy22_Paul_Murphy@MAY-CO.COM30_Tue, 6 Mar 2001 10:48:28 -0600336_us-ascii Hello List,
I know that DB2 UDB v7.1 EE contains Connect. However, our environment consists of DB2 UDB v7.1 Workgroup Edition on one server and DB2 Connect EE v7.1 on another server. My question to the group is, is it possible for both of these products to reside on the same machine (at the same version/release)? [...]
26542 59 51_Re: Stranded Utility from 5.1 but system is now 6.10_18_mebert@AMADEUS.NET30_Tue, 6 Mar 2001 17:12:30 +0100365_us-ascii Hi Mike,
I searched the archives with "SYSUTILX" and got 5 hits. The first one from Dan Courter titled "No need to re-initialize SYSUTILX" should help you; it is in response to a different thread titled "Unable to TERM a stopped Utility" that will have more info (even if the situation described is somewhat different if I remember correctly). [...]
26602 61 51_Re: Stranded Utility from 5.1 but system is now 6.115_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Tue, 6 Mar 2001 09:56:57 -0600562_iso-8859-1 You might need to blow away SYSUTIL and recreate it again. There are postings for this procedure in the archives.
Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin
"Any sufficiently advanced technology is indistinguishable from magic." - Arther C. Clarke
-----Original Message----- From: Mike Lawrence [mailto:mlawrence@ASCENSIONHEALTH.ORG] Sent: Tuesday, March 06, 2001 9:42 AM To: DB2-L@RYCI.COM Subject: Stranded Utility from 5.1 but system is now 6.1 [...]
26664 234 26_Re: Dataspace vs hiperpool14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 13 Mar 2001 08:48:57 -0800433_us-ascii John,
Thanks John, saved me time re-stating Roger/IBM. But also, what they have said plainly in the past -- only considering using them for low use objects/large objects (etc) as performace is worse in the 32bit world due to the constant movement of pages, from the data space, into and out of the lookaside area in DBM1. That is all new code length, and is expensive in any kind of system with heavy VP/HP use. [...]
26899 78 23_Re: Trigger Question...22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Tue, 13 Mar 2001 08:57:28 -0800300_- Walter,
I wanted to thank you for your suggestion of two triggers. It is exaclty what we needed. I have tested your scenario below and it works like a charm. I did not use the Begin Atomic tho.. Every time I try and use that I seem to have problems. Again, thanks.. I love this list... [...]
26978 143 42_Re: Are Identity columns supported by EEE?12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 13 Mar 2001 09:07:09 -0800383_us-ascii So Nicole- Did you play with timestamps or random # generators, or put a counter in a separate table and have each transaction update the table. I think using a counter in a table would reduce potential concurrency quite a bit, but I don't want to meltdown the cpu with calculations. I don't want to have to spend a lot of time on retries due to duplicate keys either. [...]
27122 22 26_Re: Dataspace vs hiperpool10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 13 Mar 2001 18:04:28 +0100362_us-ascii I heard rumors about poor performance with dataspaces (in some tests, I don't remeber where).
In my opinion, other than a Z HW &SW, it will be better to wait a while, to avoid the problems we had with HP, as Dataspace as HP do not 'belong' to DB2 AS (sometimes, as in (some) married couple sometimes there is a kind of incommunicability...) [...]
27145 26 23_Re: Trigger Question...13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 13 Mar 2001 12:18:52 -0500388_iso-8859-1 Hi Martin, Could your problems with Begin Atomic stem from the need to set a delimiter?
Since you can have multiple SQL statements within the section, it's required that you use the semicolon to delimit those statements.
If you have other SQL statements in your execution unit, you need to set and use a different delimiter -- that is, other than semicolon. [...]
27172 48 38_Problems with Fixpak 6 for DB2UDB v6.112_Dauncey, Ian18_idauncey@FNB.CO.ZA31_Tue, 13 Mar 2001 15:15:45 +0200336_ISO-8859-1 Hi All,
We are running DB2UDB v6.1 on an AIX 4.3.3 box.
We applied Fixpak 6 using the script supplied in the Fixpak 6 readme.txt file over Fixpak 2. Once Fixpak 6 had been applied every DB2 command we entered just hang. No errors have been written to the Diaglog file or any place else that we could find. [...]
27221 47 15_Re: Bpool Stats6_Chenny39_solaiyappan_chenniappan@MAIL.AMSINC.COM31_Tue, 13 Mar 2001 11:21:16 -0600376_- Ed,
Thanks for your response.
>>Where are the decimal places coming from in your stats? Decimal places are due to averages(since its a statistics interval report).
>>Your hit ratios seem very low. How big are your pools, how much storage is >>there on your machine, how much storage is being used, and what is your >>strategy for your bufferpools? [...]
27269 47 26_Re: Dataspace vs hiperpool14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 13 Mar 2001 17:53:15 -0000376_iso-8859-1 IBM have stated that the performance of a vbp supported by a dataspace will never be as good as a vbp in central storage
They are almost a 'stop gap' solution for those folks who need bufferpool space in excess of that supported by one address space ('DBM1) and who aren't able (yet) to take advantage of DB2 (V7+s) ability to exploit 64-bit addressing [...]
27317 47 30_Re: Default to tablespace scan12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 13 Mar 2001 19:52:32 +0200640_iso-8859-1 Hi, Excluding unique indexes in V5 . V6 is another story.
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.com ----- Original Message ----- From: "Vassie, Edward" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, March 13, 2001 2:56 PM Subject: Re: Default to tablespace scan
> In any situation where DB2 determines it is cheaper to do a tablespace scan > than use an index, DB2 will do a TS scan. In just about any situation you > can imagine, if there are only very few pages in a tablespace, it will be > cheaper to do a scan than to [...]
27365 98 42_Re: Problems with Fixpak 6 for DB2UDB v6.10_22_BILL_GALLAGHER@PHL.COM31_Tue, 13 Mar 2001 13:09:52 -0500462_us-ascii Did you stop all the instances and run the "db2iupdt" command for each instance after applying the fixpack?
Bill Gallagher, DBA Phoenix Home Life Enfield, CT 06083
"Dauncey, Ian" To: DB2-L@RYCI.COM Subject: Problems with Fixpak 6 for DB2UDB v6.1 Sent by: DB2 Data Base Discussion List
03/13/01 08:15 AM Please respond to DB2 Data Base Discussion List [...]
27464 41 26_Re: Dataspace vs hiperpool15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Tue, 13 Mar 2001 12:16:48 -0600368_iso-8859-1 The correct term for memory above the 2G area is 'above the BAR'.
24 bit = below the line 32 bit = above the line/below the bar 64 bit = above the bar
Hopefully we do not need a name for beyond 64 bits before I retire.
Chris Blaicher
BMC Software, Inc. Austin Research Labs 10415 Morado Circle Austin, TX 78759 512/340-6154 [...]
27506 53 23_Re: Trigger Question...22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Tue, 13 Mar 2001 10:18:51 -0800356_- You are probably correct.. Fortunately I have been able to only use one SQL statement in the triggers I have created.
Marty Killen SR DB2 DBA CNF INC Information Technology 503-450-2681 - CNF INC 503-450-6038 - Conway e-mail - killen.martin@cnf.com
"Kind words can be short and easy, but their echoes are truly endless" Mother Theresa [...]
27560 31 18_Changing DB2's SRC15_David A. Zelmer25_david.zelmer@CITICORP.COM31_Tue, 13 Mar 2001 12:41:44 -0600549_us-ascii Lister's
DB2 v5.1 OS/290 2.8
I need to change the SRC of an active DB2 system. There is a conflict with Netview and mgmt wants this changed. Currently this subsystem uses a % and we are changing it to -ssid. We can not change the subsystem name.
I am wondering if anyone has done this before? I can not find anything I need to change within DB2. I know I need to change my "automation" software to use the new SRC. Also, IEFSSN* needs to be changed. This is where it gets confusing. Can OS/390 do this w/o an IPL? [...]
27592 56 22_Re: Changing DB2's SRC12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Tue, 13 Mar 2001 14:11:42 -0500279_us-ascii David, i did this to our 8 subsystems a couple of years ago. You are correct in that IEFSSNXX has to be changed and we IPL'ed. I'm fairly certain that you have to. Don't forget to id all the procedures or automation tasks, and operator functions that use the ssid. [...]
27649 51 42_Re: Are Identity columns supported by EEE?11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 13 Mar 2001 14:14:05 -0500412_us-ascii At the time I wrote an article for DB2 Mag on V7.1 (see http://www.db2mag.com/db_area/archives/2000/q2/hayes.shtml and look for 'Identity Columns'), identity columns were not supported yet for EEE. In talking with Toronto lab contacts a year ago when this article was written, they knew they'd take some heat from EEE users and indicated that EEE support was "on the list" for some future release. [...]
27701 160 22_Re: Changing DB2's SRC10_Bill Disch23_bill.disch@GENMILLS.COM31_Tue, 13 Mar 2001 13:21:53 -0600466_- Dave,
I had to do the same thing when we changed all of our single character SRC to -ssid for all production and +ssid for all other DB2 subsystems. This was a few years ago at DB2 V4.1 and OS390 V1R2, I think. Yes, an IPL was required since that is when the IEFSSN* members are read. I also seem to remember having to create a new DSNZPARM member with the new SRC. But my memory is fuzzy so I'm not 100% sure. Everything went OK without any glitches. [...]
27862 16 30_Rule:Re[2]: Changing DB2's SRC11_Ken Liberty29_Ken_Liberty@CONSULTEC-INC.COM31_Tue, 13 Mar 2001 14:32:47 -0500450_us-ascii I will be Out of the Office until Friday, March 16th for DBA Support and DMEM Processing please contact Y. Hamilton (X7282). I will be returning to the office on Monday, March 19th.
Thanks Ken
================================================ 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.
27879 99 22_Re: Changing DB2's SRC12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Tue, 13 Mar 2001 14:34:07 -0500712_iso-8859-1 There is a reference within DSNHDECP but that is not the SRC. No ZPARM changes that i can remember.
Bill Disch @RYCI.COM> on 03/13/2001 02:21:53 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: Changing DB2's SRC
Dave,
I had to do the same thing when we changed all of our single character SRC to -ssid for all production and +ssid for all other DB2 subsystems. This was a few years ago at DB2 V4.1 and OS390 V1R2, I think. Yes, an IPL was required since [...]
27979 57 22_Re: Changing DB2's SRC15_Zander, Barb J.19_bzander@STATE.ND.US31_Tue, 13 Mar 2001 13:45:50 -0600471_ISO-8859-1 Dave, You can add a new SSN without an IPL use SETSSI command. See Ex.
DYNAMIC SUBSYSTEM DEFINITION OS/390 REL 2.9 CONSOLE COMMAND:
SETSSI ADD,SUBNAME=XXXX,INITRTN=XXXXXXXX,INITPARM='XXXXXXXX' -- OR -- SETSSI ADD,S=XXXX,I=XXXXXXXX,P='XXXXXXXX'
This would allow you to get your new ones in. After that you can deactivate your old SSN. But it cannot be changed, so for someone else to reuse your existing/old SSN you would need an IPL. [...]
28037 64 23_Lower case column names16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM31_Tue, 13 Mar 2001 14:43:23 -0500453_iso-8859-1 We have several tables that have been created through a PowerBuilder application. The column names were generated in lower case characters. It seems as though both SPUFI and our application cannot access these columns even if we enter the column name in lower case. It appears to be converted to upper case each time we make an attempt to read a table. Any thoughts or suggestions? Thanks, Mike Friedlander mike.friedlander@firstinvestors.com
28102 118 23_Re: Trigger Question...14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 13 Mar 2001 11:49:24 -0800573_us-ascii Do not ignore the BEGIN ATOMIC. While that statement has no meaning or options today, it will have in the near future. There are extreme differences between ATOMIC and non-ATOMIC groupings of statements. That phrase, while seemingly strange, really isn't.
--- "Killen, Martin W - CNF" wrote: > Walter, > > I wanted to thank you for your suggestion of two triggers. It is > exaclty > what we needed. I have tested your scenario below and it works > like a > charm. I did not use the Begin Atomic tho.. Every time I try and > use [...]
28221 71 22_Re: Changing DB2's SRC17_Belfield, Alma G.21_Alma.Belfield@TWA.COM31_Tue, 13 Mar 2001 13:56:45 -0600414_iso-8859-1 At your level of OS/390 you should be able to add a new MVS subsystem with the SETSSI command - look at SETSSI ADD options to see how to specify the name and SRC etc. This dynamically adds MVS subsystems without having to IPL. But any SETSSI ADDed subsystem definition will not live across IPL's, so you need to update IEFSSN* before your next IPL or you'll lose it. I'd talk to your MVS sysprogs. [...]
28293 18 78_Re: A Program to Replace Host Variables with :H or ? in saved Dynamic SQL Text12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 13:37:58 -0600420_- I like Rob Crane's response. There is one place that does not cause problems - insert statements. There is an option in DB2 Connect to convert the literals into host variables. You might want to start with this first, then look to see if there are other common SQL statements using literals where host variables would be better. Global replacement of literals with host variables has too much downside potential. [...]
28312 62 26_Re: Dataspace vs hiperpool12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 13:50:29 -0600322_- You should probably try to get to IDUG for a presentation by Akiko Hoshikawa, DB2 Performance Beyond 2 GB Real. www.idug.org
How much additional CPU cost? The answer has generally been too much. We have not spent much time measuring what we tell you not to do, but expect the variability to exceed the mean. [...]
28375 21 41_DB2 for OS/390 stored procedures question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Tue, 13 Mar 2001 14:59:53 -0500515_iso-8859-1 Does anyone know if you have to have ssidSPAS started even if you only plan on using WLM-managed stored procedures? If it's not needed, do I just set
Thanks.
Tina Hilton Database Analyst Bertelsmann mediaSystems (317) 542-6891 Tina.Hilton@bmsus.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.
28397 25 45_FW: DB2 for OS/390 stored procedures question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Tue, 13 Mar 2001 15:01:13 -0500399_iso-8859-1 Sorry - I accidentally sent it before I finished it.
> Does anyone know if you have to have ssidSPAS started even if you only > plan on using WLM-managed stored procedures? If it's not needed, do I > just set STORPROC to nothing in DSNZPARM or is there more? > > Thanks. > > Tina Hilton > Database Analyst > Bertelsmann mediaSystems > (317) 542-6891 > Tina.Hilton@bmsus.com > [...]
28423 42 27_Re: Lower case column names14_Toppins, Smike21_smike.toppins@GWL.COM31_Tue, 13 Mar 2001 13:07:37 -0700694_- Try using quotes around the names; e.g.,
SELECT 'col1', 'col2' FROM 'creator'.'tablename'
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
> ---------- > From: Mike Friedlander[SMTP:friedlander@FIRSTINVESTORS.COM] > Reply To: DB2 Data Base Discussion List > Sent: Tuesday, March 13, 2001 12:43 PM > To: DB2-L@RYCI.COM > Subject: Lower case column names > > We have several tables that have been created through a PowerBuilder > application. The column names were generated in lower case characters. > It seems as though both SPUFI and our application cannot access these > columns even if we enter the column name in lower case. It [...]
28466 118 22_Re: Changing DB2's SRC14_Picou, Michael33_picou.michael@MAIL.DC.STATE.FL.US31_Tue, 13 Mar 2001 15:04:43 -0500500_iso-8859-1 Code something like this in IEFSSN**, in this case the SSID is DSNP (P=Production) SUBSYS SUBNAME(DSNP) INITRTN(DSN3INI) INITPARM('DSN3EPX,-DSNP,S') SUBSYS SUBNAME(IRLP) SUBSYS SUBNAME(JRLP)
-----Original Message----- From: Jeff Frazier [mailto:Jeffrey_Frazier@WENDYS.COM] Sent: Tuesday, March 13, 2001 2:34 PM To: DB2-L@RYCI.COM Subject: Re: Changing DB2's SRC
There is a reference within DSNHDECP but that is not the SRC. No ZPARM changes that i can remember. [...]
28585 23 27_Re: Lower case column names13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 13 Mar 2001 15:15:21 -0500371_iso-8859-1 Hi Mike, You may just need to put the names within quotes (or apostrophes -- whatever your string delimiter is). This applies to any special characters and lowercase characters are treated as special.
Look at your Edit profile in SPUFI or just issue the CAPS OFF command to ensure that ISPF Edit isn't the culprit even after you delimit the names. [...]
28609 51 11_Re: OPTHINT24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Tue, 13 Mar 2001 14:17:09 -0600351_- Maybe(?) if a plan is bound with "DEFER(PREPARE)" and "SET CURRENT OPTIMIZATION HINT" had been issued, then perhaps the remote system will use the OPTHINT register at the point the prepare is being done?
I'd like to know what's happening too; we are starting to put up V6.
Richard Humphris CNA Online Systems - DB2 (312) 822-5193 [...]
28661 93 26_Re: Dataspace vs hiperpool16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 13 Mar 2001 15:23:00 -0500348_iso-8859-1 Roger, Thanks for the great info. I will look at the APAR soon. We do not really have a requirement for dataspaces. The situation is that we use hiperpools in prod. Our disaster recovery site does not allow us to use ADMF since the MVS brought up there is a VM guest. And here I thought I was finally rid of VM when I left IBM! :=( [...]
28755 21 24_Re: Table Comparison SQL12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 14:14:27 -0600585_- It's a bit tricky for SQL, but there is also a tool from IBM that was announced last week called the IBM DB2 Object Comparison Tool.
IBM DB2 Object Comparison Tool for z/OS, V1 allows you to compare objects (and dependent objects) from one source to those in another, so your test and development database system can be a mirror image of the production system. The tool runs as an extension to DB2 Administration Tool for OS/390, Version 2.1, and includes a DB2 catalog extract function, a batch job generator, a dynamic link library (DDL) extract feature, an ISPF front [...]
28777 18 21_Re: table last access12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 14:24:52 -0600339_- The question is a bit trickier than it seems. For example, perhaps there is a weekly copy job. Is that usage?
One of the techniques that works at some shops is to use something like DFSMShsm to archive the data sets. That saves the space and some administration. Use a different technique for the copies or avoid the copies. [...]
28796 17 18_Re: CICS Deadlocks12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 14:30:56 -0600346_- For deadlocks and timeouts, there is more information in the instrumentation than we can put in a message. The traces are statistics class 3 and the IFCIDs are 0172 for deadlocks and 0196 for timeouts.
Then you can format the traces with a product like DB2 PM or print them in a dump format and then analyze by looking at DSNWMSGS. [...]
28814 48 23_Lower case column names16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM31_Tue, 13 Mar 2001 15:47:42 -0500144_iso-8859-1 Thanks to all who replied. Double quotes work fine. Thanks again,
Mike Friedlander mike.friedlander@firstinvestors.com
28863 61 49_Re: FW: DB2 for OS/390 stored procedures question11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Tue, 13 Mar 2001 15:07:19 -0600462_us-ascii Set ZPARM to the following: STORPROC=ssidWLM,
"Hilton, Tina, BmS - NMI -PM" To: DB2-L@RYCI.COM Subject: FW: DB2 for OS/390 stored procedures Sent by: DB2 question Data Base Discussion List
03/13/01 02:01 PM Please respond to DB2 Data Base Discussion List
Sorry - I accidentally sent it before I finished it. [...]
28925 136 15_Re: Bpool Stats24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Tue, 13 Mar 2001 15:42:14 -0600347_iso-8859-1 The fact that index pages had to be read to support "list prefetch" is a given. But I don't think you can quantify, at a buffer pool level, how much I/O to the index buffer pool was needed to support "list prefetch". Note: I assume that buffer pool 10 is used as an "index buffer pool" and buffer pool 11 is a "table buffer pool". [...]
29062 135 26_Re: DB2 v5 to V7 migration12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 16:42:50 -0600537_ISO-8859-1 There's been a lot of discussion in this thread, and I'm back from Hamburg at least physically. It was an excellent DB2 and IMS Technical Conference for me. I've had a number of opinions, and they change as customers tell me the release is ready. In the past couple of week, we had a number of customers say that it's good. Just to add to the confusion, I wrote an article for the IDUG Solutions Journal last summer and updated part of it in this note. My guess is that it will appear aound IDUG in May, and this content [...]
29198 15 49_Re: Select Distinct vs Open Cursor and Fetch Once12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 17:25:43 -0600274_- I think all of the points I would make are aready in there. I've been at Share and then at the Technical Conference in Hamburg the last couple of weeks, so the mail, email and other work has backed up a bit. Please don't stick beans in your ears.
Roger Miller [...]
29214 14 45_Re: Uncl: Problem with IVP job DSNTEJ75 in V612_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 17:35:06 -0600468_- Call this one in to service if you can. It would be useful to have the full error message, compiler levels, ... I don't see any changes on that module in the past couple of years.
Roger Miller, DB2 for OS/390 and z/OS
================================================ 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.
29229 15 22_Re: Websphere on OS39012_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 17:45:00 -0600340_- WebSphere Application Server 4.0 for z/OS and OS/390 was announced today. One of the key prerequisites is DB2 V7. Both become generally available on March 30, 2001. WAS 4.0 includes J2EE (EJB Version 1.1 specification level). Some very interesting applications are moving this direction.
Roger Miller, DB2 for OS/390 and z/OS [...]
29245 22 71_Re: What are the Requirements, Tips & Tricks for monitoring Dynamic SQL12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 13 Mar 2001 17:55:37 -0600588_- There are good classes on this topic, often discussing the situation for SAP, PeopleSoft, Siebel, and JDBC or ODBC applications. There are some additional options in DB2 Connect if the applications run on another platform (including Linux on zSeries).
The key option is dynamic statement caching and the instrumentation from the dynamic statement cache. I think that all of the key performance monitors provide reporting for this instrumentation. Your cache hit ratio can make or break the application, so be sure to use parameter markers when you can, instead of literals. [...]
29268 24 34_Modify Database / Tablespace CCSID15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM31_Wed, 14 Mar 2001 11:31:02 +1100539_- Dear List,
Has anyone ever needed to Modify Database / Tablespace CCSID values - and did you experience any gotchas afterwards?
regards, Steve
I 2nd Floor 484 St Kilda Rd, Melbourne
' (03) 9865 8557 7 (03) 9804 5368 *
================================================ 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.
29293 22 21_=?koi8-r?B?6MXM0A==?=21_Jelena Vladisavljevic15_molten@EUNET.YU31_Wed, 14 Mar 2001 02:50:48 +0100566_koi8-r I need to define replication on the table with too long and complicated where clausule.Control table ASN.IBMSNAP_SUBS_MEMBERS have a columne PREDICATES of varchar(512) , but my where clausule is longer and replication don't work. First I trie to make a view , but althought all parameters(sinchpoint, sinctime...) are not null on each replication circle it works a full refresh. When I saw that I alter that table with predicates column of varchar(1024) and bind applyur.lst and applycs.lst,but it still doesn't work.Please tell me what I can do. Jelena [...]
29316 15 39_Any pitfalls with RELEASE(DEALLOCATE) ?13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Tue, 13 Mar 2001 21:45:27 -0600438_- Hi all I'm thinking of rebinding some packages with RELEASE(DEALLOCATE), these are all long running batch jobs doing regular COMMITs. Are there any downsides to this ? Thanks in advance Mohammad
================================================ 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.
29332 107 28_Host Structures and VARCHARS14_Robert T. Swem18_rswem@PLANETKC.COM31_Tue, 13 Mar 2001 22:07:49 -0600320_iso-8859-1 I have a JAVA web application sending a VARCHAR list of codes to an OS/390 COBOL stored procedure. There can be from 1 to 500 10-byte codes sent to the stored procedure. These codes are keys to a SELECT from DB2 tables and a result set is returned to the JAVA application with the requested information. [...]
29440 51 43_Re: Any pitfalls with RELEASE(DEALLOCATE) ?16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 14 Mar 2001 10:49:10 +0530421_- If the tablespace is defined with LOCKSIZE TABLE or Tablespace, if the lock escalation usually takes place to table or tablespace locks, if Lock Table is used.....or in any case the table or tablespace locks is in use, DB2 does not release them in Commit when Release(deallocate) is specified.
Look at the Programmers Only section from Boonie Baker in DB2 Mag,Fall 1998 article titled "Wooes of Commitment" [...]
29492 63 32_Re: Host Structures and VARCHARS14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 14 Mar 2001 16:16:26 +1100599_iso-8859-1 1) such a construct is not possible - indicator variables are only used when DB2 sets them in a FETCH/SELECT INTO list
2) what you might be able to do is: -- create a host variablel structure of 500 varying length fields: 01 LIST-OF-VALUES. 10 A-VALUE-1. 49 A-VALUE-1-LEN PIC 9(4) COMP. 49 A-VALUE-1-DATA PIC X(10). ... -- copy such elements that you do get into the initial varying length fields -- copy the first field into the remaining fields. (You might find redefining the structure by a repeating group usefull) -- using " WHERE IN (:LIST-OF-VALUES) " in [...]
29556 83 44_Re: Zparm CONTSTOR - contract thread storage23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 14 Mar 2001 06:07:51 -0000546_iso-8859-1 Max
doesn't look like the list took this so I will re post. (do not suppose you know a way of getting the list to distribute a copy of my replies that I mayke - but to me aswell ?)
Max
hi,
I am going to second guess what somebody(IBM developers) with detailed understanding of JCs paper would say. The calculations are based on an active system and are not 100% watertight. I tend to use my gutt feel on everything on DB2 & SAP and normally it never lest me down. Using this on the calc program I have [...]
29640 79 30_Re: Runaway SYSCOPY & SYSLGRNX15_Ali OZTURK(942)27_Ali.OZTURK@PAMUKBANK.COM.TR31_Wed, 14 Mar 2001 09:03:40 +0200468_ISO-8859-9 Hi Richard, I have encountered this problem in DB2 V5. Your problem is related with LOCKS PER TABLE(SPACE) and LOCKS PER USER parameters in DSNTIJUZ job. Your Modify utility wants to get more locks entry than these , but it doesn't acquires. if you increase these parameters values, your job will be run succecfully. I have resolved like that it. (also I remember that there is a apar to solve that kinds of problem in V5. But I don't know it in V6. ) [...]
29720 12 26_Test message please ignore12_Fertaki Gina20_GFertaki@EUROBANK.GR31_Wed, 14 Mar 2001 10:26:55 +0200265_iso-8859-7 Test message
================================================ 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.
29733 26 43_Re: Any pitfalls with RELEASE(DEALLOCATE) ?10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 14 Mar 2001 09:57:30 +0100479_us-ascii Hi Mohammad.
If you need RELEASE(DEALLOCATE) with CICS transaction take a look at David Beulke's article in DB2MAG spring 1998 issue.
We use RELEASE(DEALLOCATE) with CICS transaction (following Beulke's suggestions) and the noted good savings in elap. time. You cannot rebind packages until the tx release the resource allocated (never for high-volume transaction). If you want a detailed accounting (not cumulative) trace you need to set TOKENE=YES. [...]
29760 19 44_Re: Zparm CONTSTOR - contract thread storage10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 14 Mar 2001 10:00:35 +0100425_us-ascii Hi Leslie.
I received your first reply, but it seems to me that DB2-L is somewhat strange lately, as I received some strange messages.
Regards
Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
29780 45 44_Re: Zparm CONTSTOR - contract thread storage23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 14 Mar 2001 09:06:16 -0000659_iso-8859-1 How weird
Les
-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: Wednesday, March 14, 2001 9:01 AM To: DB2-L@RYCI.COM Subject: Re: Zparm CONTSTOR - contract thread storage
Hi Leslie.
I received your first reply, but it seems to me that DB2-L is somewhat strange lately, as I received some strange messages.
Regards
Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
29826 62 43_Re: Verify (OS390) DDF IP Port is listening23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 14 Mar 2001 09:08:44 -0000417_iso-8859-1 -----Original Message----- From: Park, Stan [mailto:SPark@STATE.NM.US] Sent: Friday, February 23, 2001 10:08 PM To: DB2-L@RYCI.COM Subject: Verify (OS390) DDF IP Port is listening
Hello List,
Am attempting to create an automated process on my Win NT box that will notify me if any of our DB2 V5.1 OS390 DDF IP ports are NOT listening. This must be a *totally* automated process. [...]
29889 64 43_Re: Verify (OS390) DDF IP Port is listening23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 14 Mar 2001 09:08:52 -0000447_iso-8859-1 what about using rexx?
-----Original Message----- From: Park, Stan [mailto:SPark@STATE.NM.US] Sent: Friday, February 23, 2001 10:08 PM To: DB2-L@RYCI.COM Subject: Verify (OS390) DDF IP Port is listening
Hello List,
Am attempting to create an automated process on my Win NT box that will notify me if any of our DB2 V5.1 OS390 DDF IP ports are NOT listening. This must be a *totally* automated process. [...]
29954 24 27_DB2 OS/390 V5 and UDB NT V711_Iztok Jeras27_Iztok.Jeras@OMVISTRABENZ.SI31_Wed, 14 Mar 2001 10:23:13 +0100351_- Hi list,
We are a small shop, at the moment connecting UDB Win NT 5.2 (+Connect) with DB2 OS/390 V5. We use replication and two phase commit applications.
We would like to move to UDB Win NT V7, so we'd like to know:
* is anybody connecting from UDB V7 to DB2 V5 (any problems ?) and * any ideas where problems may arise ? [...]
29979 35 42_Qualifier, Plan, Package and concatenation18_Blumer Hans-Ulrich32_Hans-Ulrich.Blumer@WINTERTHUR.CH31_Wed, 14 Mar 2001 10:31:59 +0100314_iso-8859-1 Hi Suppose you work with packages and in your plans you only have PLIST with collections and packages (no DBRM's). Does the qualifier of the plan make any sense? Although you bind your package without owner and qualifier, your package qualifier will be filled with the agent of the package binder. [...]
30015 57 30_FW: Test message please ignore12_Fertaki Gina20_GFertaki@EUROBANK.GR31_Wed, 14 Mar 2001 11:36:42 +0200628_iso-8859-7 Hello everyone, We are moving legacy applications in our installation from our AS/400 to OS/390 system , but some applications will remain on the AS/400 and will require access to DB2 OS/390. This access (inquiries, updates, etc) will be implemented via calls to stored procedures on the OS/390 thru a DRDA connection between the two systems. The application requirements are such that it is required that the stored procedures access a VSAM file that is declared as DISP=SHR in the startup procedure of the DB2 stored procedures address space. The NUMTCB parameter of the stored procedures address space is set [...]
30073 130 34_help required - long running query18_Pudukotai, Nagaraj35_nagaraj.pudukotai@BLR.HPSGLOBAL.COM31_Wed, 14 Mar 2001 14:58:09 +0500659_iso-8859-1 Hello List
I have a batch job which runs for 90 min and consumes about 30 min of CPU. About 40 min is spent in DB2 wait time because of heavy sync I/O (about 309,000 I/Os) on the table/index (NPL003TB), which I found when the job was running. I have attached the trace output (from Mainview) with this mail. The query is: SELECT PL03_ACCT_ID , PL03_CENTER_ID , PL03_TRAN_AM , PL03_TRAN_BILL_DT , PL03_TRAN_EFF_DT FROM NPL003TB WHERE PL03_FILE_ID = :WS-CTL-FILE-ID-X AND PL03_TRAN_BILL_DT = :WS-LOW-DATE (which is always equal to '0001-01-01', there are 10.5 million rows satisfying this criterion) AND PL03_TRAN_AM <> :WS-ZERO-AM-COMP3 [...]
30204 25 44_Re: Zparm CONTSTOR - contract thread storage10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 14 Mar 2001 11:44:12 +0100390_us-ascii I received twice the notification for a message. I received a message saying I tried to post the same message twice (but
I'm sure I sent that mail only once). I do not receive all posted messages : for instance i didn't receive the message:
' Verify (OS390) DDF IP Port is listening ', I'm seeing only the replies. Some message I sent once appear twice in DB2-L [...]
30230 39 29_DB2 Warehouse Manager Problem11_Endy Lambey27_endyl@MITRAINFOSARANA.CO.ID29_Wed, 14 Mar 2001 11:00:23 GMT571_ISO-8859-1 Dear all,
I am having a problem developing a process in DB2 Warehouse Manager. I wonder if any of you DB2 Gurus can help me.
The problem is that with DB2 Warehouse Manager, there's no Insert-Update function. I intend to use this to import all available data into a table in our Data Warehouse, and update all changes data and insert all new data. Why DB2 Warehouse Manager don't have this function, it's a very basic function anyway. Can anyone help me with this? I really-really need it. Or is there any other way to overcome this problem? [...]
30270 62 51_FW: VSAM use in DB2 stored procedures address space12_Fertaki Gina20_GFertaki@EUROBANK.GR31_Wed, 14 Mar 2001 13:32:37 +0200674_iso-8859-7 I am sorry if I am resending this message twice, it is only because I have previously sent it with subject: 'Test message please ignore' by mistake... ---------------------------------------------------------
Hello everyone, We are moving legacy applications in our installation from our AS/400 to OS/390 system , but some applications will remain on the AS/400 and will require access to DB2 OS/390. This access (inquiries, updates, etc) will be implemented via calls to stored procedures on the OS/390 thru a DRDA connection between the two systems. The application requirements are such that it is required that the stored procedures access a VSAM [...]
30333 41 28_How many M/F DB2 sites in UK10_Alan Johns26_AlanJ@PRINCETONSOFTECH.COM31_Wed, 14 Mar 2001 07:11:04 -0500547_ISO-8859-1 Greetings folks. I am writing a paper and I need to know how many mainframe DB2 sites there are in the UK, preferably broken down into England, Ireland, Scotland and Wales.
Can anyone help?
Alan
Princeton Softech's Select Enterprise is First to Support Borland JBuilder 4
http://www.princetonsoftech.com/link.asp?doc=news/press/jbuilder.htm
Princeton Softech's Apex Identifies Benefits of Streamlining Relational Databases http://www.princetonsoftech.com/link.asp?doc=news/press/apex.htm [...]
30375 31 36_JDBC application On MVS open edition13_Anil Kalkatte23_anilkalkatte@INDIYA.COM31_Wed, 14 Mar 2001 04:27:34 -0800373_-
Hello Everyone.
When I am trying to run my Java program on MVS open edition , which makes a call to JDBC , I am getting following error message.
CEE3250C The system or user abend S806 R=00000004 was issued. From compile unit DSNAQCOM at entry point SQLJDECP at compile unit offset +000000C8 at address 1A6115A0. [...]
30407 24 46_Re: Qualifier, Plan, Package and concatenation15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 14 Mar 2001 06:17:10 -0600395_- Hans
To the first question: I'm quite sure, that the qualifier has no meaning, if you only use packages.
I'm not sure if I understand your second question. If a package is bound either in USERCOL or in PROJCOL, then DB2 will find always the right one. If this is not the case then the application must do a SET CURRENT PACKAGESET to use a package in the desired collection. [...]
30432 18 38_Re: help required - long running query15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 14 Mar 2001 06:27:34 -0600464_- Hi
I would suggest to change the sequence of your index. Because there are that much rows satifying the condition PL03_TRAN_BILL_DT = :WS-LOW-DATE, it seems to be better to put the 3. column which is PL03_TRAN_EFF_DT as the second one. So there will be no sort and you will get seq. prefetch. I think this will speed up your query. Or if you can't alter the index, because other queries need exactly this sequence, a tablespace scan would be better. [...]
30451 34 113_PJ25955 - SQL0104N AN UNEXPECTED TOKEN "END-OF-STATEMENT" WAS FOUND FOLLOWING KEYA WHERE BLOCKKEY= SQLSTATE=4260114_Bilal YILDIRIM25_byildirim@HALKBANK.COM.TR31_Wed, 14 Mar 2001 14:52:04 +0200530_iso-8859-9 I have problem with db2 connect 6.1 in windows2000
I searched the IBM web page and found some information that says :
Database error information: SQLSTATE:42601 SQLCODE:-104 SQL0104N An unexpected token "END-OF-STATEMENT" WAS FOUND FOLLOWING "KEYA WHERE BLOCKKEY=". eXPECTED TOKENS MAY INCLUDE: "". SQLSTATE=42601 .
you must have fix : DB2 OLAP Server v. 101 FP9. but I couldnt find it if anyone has it or and idea about this problem please inform me :) [...]
30486 47 31_Re: DB2 OS/390 V5 and UDB NT V710_Robert Ord21_robertord@HOTMAIL.COM31_Wed, 14 Mar 2001 13:06:44 -0000609_- Iztok,
You may find you can't connect to the mainframe db2 because the versions are incompatible. I think it's 2 versions up and 1 down.
Rob
>From: Iztok Jeras >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DB2 OS/390 V5 and UDB NT V7 >Date: Wed, 14 Mar 2001 10:23:13 +0100 > >Hi list, > >We are a small shop, at the moment connecting UDB Win NT 5.2 (+Connect) >with >DB2 OS/390 V5. We use replication and two phase commit applications. > >We would like to move to UDB Win NT V7, so we'd like to know: [...]
30534 31 43_what can I do to achieve a good performance15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 14 Mar 2001 06:59:53 -0600528_- Hello list
I have a somehow very general question, so I'm afraid, I won't get any response to this thread. But anymay, may be someone has done a similar job and has some ideas or could share with me his/her experience. Anything is greatly appreciated.
So here are the facts: - Insurance company with DB2/DC and DB2 - DB2 and IMS in a 3-way data sharing environment - about 4 million transactions a day (all using DB2 data) - about 1 TB DB2 data (with about 100 tables > 10 million rows) - about 2800 tables [...]
30566 57 47_Re: what can I do to achieve a good performance16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 14 Mar 2001 08:28:54 -0500490_iso-8859-1 Walter, Consider the use of DB2 Estimator. It may help you forecast the effects upon DASD, CPU, buffers. Of course, you will need a good picture of the catalogs of both sites and the workload of both.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Walter Janissen [mailto:walter.janissen@VICTORIA.DE] Sent: Wednesday, March 14, 2001 8:00 AM To: DB2-L@RYCI.COM Subject: what can I do to achieve a good performance [...]
30624 51 47_Re: what can I do to achieve a good performance14_Scott Trometer22_scott.trometer@RCI.COM31_Wed, 14 Mar 2001 08:29:49 -0500384_iso-8859-1 M O N S T E R . C O M
Just kidding...Wanted to make sure you got at least one response to your thread! This should actually prove to be an interesting one!
-----Original Message----- From: Walter Janissen [mailto:walter.janissen@VICTORIA.DE] Sent: Wednesday, March 14, 2001 8:00 AM To: DB2-L@RYCI.COM Subject: what can I do to achieve a good performance [...]
30676 118 44_Re: Zparm CONTSTOR - contract thread storage11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 14 Mar 2001 08:43:32 -0500426_ISO-8859-1 Leslie
I think there is some confusion in your description (below), or maybe its just in my reading of it. My understanding of storage contraction and the storage cushion is as follows:
If the CONSTOR parameter is set to YES, storage contraction is performed every 50 commits or when the storage for a thread exceeds 2MB. These values are hidden ZPARMS. It is not related to the Storage Cushion. [...]
30795 22 34_Re: FW: Test message please ignore12_Jim Harrison17_jharrison@GMX.NET31_Wed, 14 Mar 2001 09:08:59 -0500600_us-ascii My first thought is what SHAREOPTIONS did you use when you defined the dataset?
At 11:36 AM 03/14/2001 +0200, Fertaki Gina said:
>The stored procedure address space waits for itself (as shown in the report >attached) to exclusively allocate the file, so although the tasks (stored >procedures) are permitted to run concurrently they are delayed due to the >serialization of access to the VSAM. Why is the lock status switched to >Exclusive and can't the allocation be obtained once and be shared for all >stored procedures that run in the stored procedure address space ? [...]
30818 66 43_Re: Any pitfalls with RELEASE(DEALLOCATE) ?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 14 Mar 2001 09:14:48 -0500611_us-ascii Here are few pitfalls that I had-
We have RELEASE(DEALLOCATE) as it is recommended for Data Sharing. We started having big problems with this options as we converted our threads to protected threads. In our scenario, we had protected lasting (reused) for weeks or even months (24x7 system). This made it almost impossible for us to carry out any database changes unless we do it during IPL time. Even that became impossible as different data sharing members were IPLed at different times. We came up with many ideas but none were performance-wise implementable. We went to IBM asking if we [...]
30885 64 43_Re: Any pitfalls with RELEASE(DEALLOCATE) ?0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Wed, 14 Mar 2001 08:17:33 -0600587_us-ascii Hi Mohammad, When we went to V6 on OS/390, we experienced some problems with some packages bound with RELEASE(DEALLOCATE). In V6.1, there is a new thread reuse feature and unfortunately what we found is that if your package was bound as release (deallocate) and it was holding locks when the plan ended and a new plan comes along , it would reuse that thread, acquiring additional locks (AND holding locks from the previous plan). This would cause problems for us when we would attempt to run utilities and we would find locks being held (even though the previous plan had [...]
30950 86 30_Re: Platinum Tools With DB2 V615_Amy C Whitehead14_B06ACW@FDS.COM31_Wed, 14 Mar 2001 09:44:08 -0500743_us-ascii What are LMP keys?
Thanks, Amy
Amy C. Whitehead Federated Systems Group Database Architecture (678) 474-3418
BOB JEANDRON cc: Sent by: DB2 Subject: Re: Platinum Tools With DB2 V6 Data Base Discussion List
03/07/01 09:45 AM Please respond to DB2 Data Base Discussion List
No problems yet with 99D and DB2 V6. Platinum recommended upgrading to 99D after we had 99C installed. 99D is the 1st release that uses CA LMP keys. This has caused us problems because we don't have all of the products. There are some internal calls to other products that [...]
31037 18 15_PRIQTY & SECQTY16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Wed, 14 Mar 2001 09:58:01 -0500520_iso-8859-1 Hey Folks.. Does anyone know where I can change the default for these two parms? When I create temporary tables, rather than specifying the priqty & secqty, I'd like to make them bigger than the 1 track default. Thanks...
Michael Dempsey UNC Health Care System
================================================ 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.
31056 109 38_Re: help required - long running query13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 14 Mar 2001 09:02:50 -0600410_iso-8859-1 Nagaraj,
Unfortunately the trace output did not make it (I think the list has a policy that all attachments are discarded).
If I am not mistaken, then all columns in that SQL statement are in the index, thus the access path should be index-only (no data page access); with the current index being able to avoid a sort (unless something obscure such as parallelism has kicked in). [...]
31166 123 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?0_15_leon@CA.IBM.COM31_Wed, 14 Mar 2001 10:46:53 -0500325_us-ascii The equivalent of the ODBC and DB2 CLI statement option SQL_MAX_ROWS in JDBC is the setMaxRows method. Both of these will limit the number of rows that are returned from the DB2 database server. If an application tries to fetch more rows then what is specified by these parameters it will receive SQLCODE +100. [...]
31290 50 47_Re: what can I do to achieve a good performance15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Wed, 14 Mar 2001 09:49:41 -0600588_iso-8859-1 Walter,
Here are some hints:
Get with the people that currently support the workload you are about to take on. Ask a bunch of questions. Some suggested questions: 1) What size processor are they running the workload on? 2) What is the DB2 configuration? (Buffer pool sizes, EDM pool size, etc.) 3) What are the current SLA (Service Level Agreement) numbers? (Do they meet them?) 4) What is the data set placement that they use? (Forget the hype that placement does not count. If you put too many active objects on a device or channel group you can still get [...]
31341 32 19_DR with DB2 and IMS16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Wed, 14 Mar 2001 13:44:53 +0000429_us-ascii If anyone's interested, there's a nice thread on DR with IMS and DB2 with DBRC in the IMS-l (thread name "get DSP0823I trying a timestamp recovery with DBRC ims v5r1").
the address to subscribe, as you might already know, is
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.
Office: +44 (0) 1276 414 4752 Mobile: +44 (0) 7881 818 867 email: aurora_dellanno@candle.com [...]
31374 23 13_Storage usage12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Wed, 14 Mar 2001 11:23:03 -0500345_us-ascii Has anyone out there saw an increase of storage usage since going to V61. We have a production subsystem that the activity level has not changed. There has been no changes in bufferpools, edmpool etc. But we are seeing an increase in Aux and Expanded storage use.
Stan Goodwin IBM Senior I/T Specialist DECC MBG DB2 Support [...]
31398 49 14_WLM/GM and DB20_19_mike.holmans@BT.COM31_Wed, 14 Mar 2001 15:49:57 -0000382_- In a non-WLM/GM environment, we set up our DB2 dispatching priorities in the following order:
IRLM MSTR & DBM1 SPAS CICS TSO DDF
That's reasonably easy to understand, and we get a fair amount of granularity.
Now we're looking at WLM/Goal Mode, and we're wondering how to go about setting the goals so as to achieve similar results to that which we have. [...]
31448 21 56_Copying data from one database to another using Platinum13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Wed, 14 Mar 2001 11:36:00 -0500404_- Hi list, I have the Platinum suit of tools. I will like to know the steps needed to copy data from multiple tables in one database to like tables in the another tier in one pass using RC/migrator. This is like copying from production to test. Thanks Carlton
_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com [...]
31470 83 43_Re: Any pitfalls with RELEASE(DEALLOCATE) ?13_John Arbogast32_john.arbogast.cquz@STATEFARM.COM31_Wed, 14 Mar 2001 10:40:47 -0600748_- We had the exact same problem, and response from IBM. Working as designed? Nice design?!
-----Original Message----- From: Shan_Leatherman/MO/americancentury@ms00net2.statefarm.com [mailto:Shan_Leatherman/MO/americancentury@ms00net2.statefarm.com] Sent: Wednesday, March 14, 2001 8:18 AM To: DB2-L@RYCI.COM Subject: Re: Any pitfalls with RELEASE(DEALLOCATE) ?
Hi Mohammad, When we went to V6 on OS/390, we experienced some problems with some packages bound with RELEASE(DEALLOCATE). In V6.1, there is a new thread reuse feature and unfortunately what we found is that if your package was bound as release (deallocate) and it was holding locks when the plan ended and a new plan comes along , it would reuse that thread, [...]
31554 25 31_Re: DB2 OS/390 V5 and UDB NT V713_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 14 Mar 2001 11:42:20 -0500343_iso-8859-1 Hello Iztok
I am able to connect to DB2 OS/390 v5 using DB2 v7 from Win 2000. Should be the same for NT.
I haven't run into any problems. I mostly work in v6 on OS/390 so I haven't done lots with v5 since installing v7.
I thought Leon had clarified the 2-up; 1-down business recently, but I can't find it. [...]
31580 12 9_IBM C/C++16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Wed, 14 Mar 2001 08:46:00 -0800392_- We are on DB2/390 V6. We are not currently paying for IBM C/C++. What features/options of DB2/s390 V6(or V7) will we be unable to take advantage of?
================================================ 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.
31593 85 22_Charlotte DBA Position13_kathryn sears24_ksears@DPCONSULTANTS.COM31_Wed, 14 Mar 2001 11:56:29 -0500588_iso-8859-1 I've notified you about this before- Here is a link to find out more about me... http://members.tripod.com/kathrynsears/ This position is in Charlotte, NC with a large company and a growing IT department. Just wanted to update: I just talked to a DBA in this department and he was very positive about the work schedule, the management and the focus in the department. This would be a great opportunity for all levels of people and in particular for people who would like to be in a DB2 department that is growing rapidly with the potential for team lead, etc positions in [...]
31679 92 31_Re: Mainview for DB2 and DB2 PM13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 14 Mar 2001 11:02:20 -0600613_iso-8859-1 Cathy,
Interesting. We dumped Omegamon for Mainview and never looked back. I attended a demo for DB2 PM at IDUG and was unimpressed with it's functionality (in comparison).
IMHO when faced with a production problem, I prefer my battle station to be an F-16 rather than a pile of rocks.
As a side-note, if your environment is sysplex datasharing, nothing compares with Mainview for functionality. Ever try and hunt down a specific thread in a datasharing group using Candle? Then when you find it, wouldn't it be nice to launch a trace from the screen you are viewing? A trace [...]
31772 75 18_Re: WLM/GM and DB20_26_truman.g.brown@VERIZON.COM31_Wed, 14 Mar 2001 12:13:18 -0500518_us-ascii If you have high DDF online activity, Move DDF up and set appropriately high velocity goals.
George
mike.holmans@BT.COM@RYCI.COM> on 03/14/2001 10:49:57 AM
Please respond to "DB2 Data Base Discussion List"
Sent by: "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM cc: Subject: WLM/GM and DB2
In a non-WLM/GM environment, we set up our DB2 dispatching priorities in the following order: [...]
31848 53 60_Re: Copying data from one database to another using Platinum16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 14 Mar 2001 17:13:44 -0000519_- Carlton -
You can use Masking Services to "pair" the tables if they dont have identical creator and/or name. When you ANALYZE the Migrator strategy, you can go into UPDATE OPTIONS and specify that you only want to generate DATA ONLY migration. This will generate the UNLOADS and the LOADS.
You metioned that it must be in ONE PASS. If the source and target subsystem reside on different LPARS - you will need a w-step approach, where you unload from source and execute the load part on the target. [...]
31902 15 13_SQL CODE -4449_Rama Kypa23_RKYPA@ISETS.STATE.IN.US31_Wed, 14 Mar 2001 12:15:44 -0500367_us-ascii Hi all, I am getting this error while running SP calling program. Please let me know any thing on this. Thanks. Kypa
================================================ 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.
31918 73 60_Re: Copying data from one database to another using Platinum0_20_John_Lendman@FPL.COM31_Wed, 14 Mar 2001 12:15:23 -0500528_us-ascii Carlton I use this quite a bit, I am no expert on this, but here is what I do to take a copy of my production tables and then restore that copy into my test system.
Create a migration strategy that identifies that tables I want copied, this is fairly easy for me since all the tables are in one database. Now at this point you have the option of using some of the update facility of the product to change things that are going to be different in the test system. Like for me the database name is different. [...]
31992 72 60_Re: Copying data from one database to another using Platinum11_Moore, Tony15_TMoore@IKON.COM31_Wed, 14 Mar 2001 12:21:08 -0500520_iso-8859-1 Carlton, I've found that using PDA (Database Analyzer) is a lot easier to do this sort of thing than RC/MIGRATOR, but here is how I'd go about it in RC/M...
1. Do a "Quick Migration" under RC/M. 2. Enter "DB" in the OBJECT field and your database name in the NAME field. 3. When the object list comes up, put a "Y" in the TS and TB columns and hit PF3. 4. On the Analysis screen... * Place a Y in UPDATE OPTIONS and a Y in GLOBAL CHANGES * Enter your source and target subsystem ids in the SOURCE [...]
32065 124 27_Re: Lower case column names12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 14 Mar 2001 11:38:20 -0600670_us-ascii
From our PB guy..... ---------------------- Forwarded by Steve Grimes/Systems/ais on 03/14/2001 11:37 AM ---------------------------
Steven Westlund 03/14/2001 11:22 AM
To: Steve Grimes/Systems/ais@AIS cc:
Subject: Re: Lower case column names (Document link: Steve Grimes)
If you're using Powerbuilder with DB2 Connect, make sure the ODBC configuration under the SERVICE tab is not set to convert arguments to schema calls to uppercase. Also, make sure Powerbuilder is not enclosing your table and column names in quotes. That setting is in your Powerbuilder database profile setup under the syntax tab. [...]
32190 48 17_Re: SQL CODE -4440_20_John_Lendman@FPL.COM31_Wed, 14 Mar 2001 12:53:42 -0500409_us-ascii The mannual says that the program that the stored procedure is call could not be found. In the version 6 mannual message and codes page 55. John
"Rama Kypa" cc: Sent by: "DB2 Subject: SQL CODE -444 Data Base Discussion List"
03/14/01 12:15 PM Please respond to "DB2 Data Base Discussion List" [...]
32239 21 18_Re: WLM/GM and DB211_Rolf Loeben17_loeben@DE.IBM.COM31_Wed, 14 Mar 2001 18:44:47 +0100563_us-ascii Don't: keep DDF above any user application or batch, but n e v e r above any of the DB2 tasks. Rationale: client must not be higher than server.
Rolf S. Loeben, Software Marketing DB2
If you have high DDF online activity, Move DDF up and set appropriately high velocity goals.
George
================================================ 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.
32261 46 17_Re: SQL CODE -4440_24_db46@DAIMLERCHRYSLER.COM31_Wed, 14 Mar 2001 13:29:16 -0500444_us-ascii DB2 could not find you stored procedure.
So the load library it is in has not be allocated or it hasn't been started.
Also check to make sure that the stored procedure address space (SPAS) is running and you have access.
Dean
Rama Kypa @RYCI.COM> on 03/14/2001 12:15:44 PM
Please respond to DB2 Data Base Discussion List [...]
32308 17 25_Table authority question.14_Westphal, Carl27_Carl_Westphal@COMPUWARE.COM31_Wed, 14 Mar 2001 13:35:10 -0500388_iso-8859-1 If a user has CREATETAB authority in a database, what are all the privileges he has over that table and other tables in that database? Does he implicitly have authority to grant others authority over tables he creates?
If all users who have CREATETAB in a database need to be able to SELECTand UPDATE all tables in a database, what's the best way to go about that? [...]
32326 35 60_Re: Copying data from one database to another using Platinum16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Wed, 14 Mar 2001 11:35:19 -0700516_iso-8859-1 Use DSN1COPY.
-----Original Message----- From: Carlton Enuda [mailto:carltonenuda@HOTMAIL.COM] Sent: Wednesday, March 14, 2001 9:36 AM To: DB2-L@RYCI.COM Subject: Copying data from one database to another using Platinum
Hi list, I have the Platinum suit of tools. I will like to know the steps needed to copy data from multiple tables in one database to like tables in the another tier in one pass using RC/migrator. This is like copying from production to test. Thanks Carlton [...]
32362 36 35_Hybrid join to a Nested Loop Join ?12_Loria, Susan27_Susan_C_Loria@TVRATINGS.COM31_Wed, 14 Mar 2001 13:49:06 -0500610_iso-8859-1 To the list group,
We are running DB2 V6.1 PUT0005 maintenance (soon to go PUT0101) under OS/390 V2.9 and have been running this since 11/18/00 without performance problems.
Since our normal monthly reorganizations ran on 3/3/01, I'm seeing a data access change that went from performing a Hybrid Join to now doing a Nested Loop join and am unsure why since our tables and indexes, their disk placement, the SQL code, the DB2 subsystem maintenance and anything else I can think of hasn't changed. The only thing that had change was the data growth for the table which added about [...]
32399 49 29_Re: Table authority question.13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Wed, 14 Mar 2001 10:49:42 -0800566_iso-8859-1 CREATETAB authority only allows a user to Create table in a database; though just CREATETAB authority is not sufficient for this. He needs USE authority for a tablespace and a storage group. It does not give any other authority over any other table in that database. However he has all the privileges over the table he creates and he can grant those authority to others. Of course any user can create views on any table he has SELECT access on. For users having CREATETAB to have SELECT and UPDATE over all tables in a database, I can't think of any [...]
32449 105 30_Re: Platinum Tools With DB2 V69_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 14 Mar 2001 12:03:17 -0700475_us-ascii With P99D CA implemented the use of CA-LMP to manage passwords for the db2 products instead of the previous platinum password system.
Each product will have an LMP CODE and LMP KEY. The LMP KEY is the required code to run the product. The LMP CODE for Batch Processor is BP, here is an example of what the entire LMP KEY Certificate would look like for the batch processor. Your contract expiration date and cpu information would be different of course. [...]
32555 97 31_Re: Mainview for DB2 and DB2 PM16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Wed, 14 Mar 2001 18:51:52 +0000430_us-ascii Mayflor,
if you would like to do a 3-way comparison including !Candle OMEGAMON II for DB2, please feel free to contact me offline...
thanks Cathy btw, in England as a joke we'd say "the cheque is in the post"!!
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.
Office: +44 (0) 1276 414 4752 Mobile: +44 (0) 7881 818 867 email: aurora_dellanno@candle.com [...]
32653 42 29_Re: Table authority question.16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Wed, 14 Mar 2001 13:56:26 -0500470_us-ascii You will find all the information you are asking for in the following manuals:
DB2 UDB for OS/390 SQL Reference Guide DB2 UDB for OS/390 Administration Guide
"Westphal, Carl" on 03/14/2001 01:35:10 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: RICHARD E MOLERA/SallieMae) Subject: Table authority question. [...]
32696 53 29_Re: Table authority question.14_Scott Trometer22_scott.trometer@RCI.COM31_Wed, 14 Mar 2001 14:10:09 -0500362_iso-8859-1 Implicit auth on his/her tables...what Ashish said.
To do the grant, try this something like this SQL generate the DCL(its not tested but it might get you started)...you'll might get a warning messages when issuing the grants that some of the users already have privledges (-562, I think) unless you manually pull those out of the result. [...]
32750 144 31_Re: Mainview for DB2 and DB2 PM15_Steven Morrison33_steven.morrison@FIRSTDATACORP.COM31_Wed, 14 Mar 2001 13:23:27 -0600392_us-ascii I agree, I worked at a shop that had Mainview. I now work at a shop that has Omegamon. I prefer Mainview.
"Shapiro, Dave" cc: Sent by: DB2 Data Subject: Re: Mainview for DB2 and DB2 PM Base Discussion List
03/14/2001 11:02 AM Please respond to DB2 Data Base Discussion List [...]
32895 59 32_Re: How many M/F DB2 sites in UK19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Wed, 14 Mar 2001 13:36:52 -0600600_us-ascii Alan,
Might be worth trying the UK branch of the DB2 GUIDE for this type of info.
In Edinburgh there are at least 6 sites I know of - including my own (Scottish Widows).
I suppose only IBM have the definitive answer however.
Phil
On Wed, 14 Mar 2001 07:11:04 -0500, Alan Johns wrote:
>Greetings folks. >I am writing a paper and I need to know how many mainframe DB2 sites there >are in the UK, preferably broken down into England, Ireland, Scotland and >Wales. > >Can anyone help? > >Alan > > >Princeton Softech's Select Enterprise is First to [...]
32955 170 31_Re: Mainview for DB2 and DB2 PM13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 14 Mar 2001 11:53:48 -0800533_iso-8859-1 I guess much of it depends on what you're used to. Omegamon (at least the classic interface, I never bothered to learn to use the GUI) was difficult to learn at first, but after years of use I became convinced there was nothing I couldn't do with it. I've found Activity Monitor to be fairly intuitive, much less so with Mainview. And I found out why MainView's documentation is in Acrobat only -- IBM wanted to charge BMC royalties for using BookManager format. Funny, I don't hear CA complaining about royalties... [...]
33126 49 34_regarding load... immediate reply.17_ravi kumar hassan18_ravibh@HOTMAIL.COM31_Wed, 14 Mar 2001 13:51:53 -0600320_- Hi Folks,
In our shop we are using DB2 V6 on os390. one of request came from the user. they wants to increase the length of column in the existing table. we have a table around 5 columns in that and we have around 10000 records in that. so now they came up with they wants to increase lenth of two column. [...]
33176 87 27_Count is there without data16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM31_Wed, 14 Mar 2001 15:18:40 -0500564_iso-8859-1 Has anyone seen this? I have a tablespace that contains tables created via a PowerBuilder app (yep, here we go again). The tablespace ran short on space so I created an imagecopy of the tablespace, altered the space and recovered. Everything seemed to go just fine, until the phone call. It seems that if you do a: SELECT COUNT(*) FROM DBNAME.TABLESPC you get a result of 90000+ rows. If you do a: SELECT * FROM DBNAME.TABLESPC you get nothing. DB2 is not my strength, but tag I'm it. Can anyone offer any help with this or at least an explanation [...]
33264 88 34_regarding load... immediate reply.15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Wed, 14 Mar 2001 14:24:05 -0600442_us-ascii ---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 03/14/2001 02:20 PM ---------------------------
o:
Subject: regarding load... immediate reply.
Kumar, Unload again newly created table to get correct syspunch if you are not sure about the col positions. Reformat-copy old unloaded data into new file according to the correct layout and use this dataset for uploading. [...]
33353 90 38_Re: regarding load... immediate reply.0_20_John_Lendman@FPL.COM31_Wed, 14 Mar 2001 15:24:41 -0500418_us-ascii With out going in to a lot of detail, this looks to me that you have your load control cards wrong. Remember the cols in the control cards are the place where they were when you unloaded it. Hope this helps. John
"ravi kumar hassan" To: DB2-L@RYCI.COM Subject: regarding load... immediate reply. Sent by: "DB2 Data Base Discussion List" [...]
33444 64 38_Re: regarding load... immediate reply.14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Wed, 14 Mar 2001 14:29:09 -0600626_iso-8859-1 This should work if you are using the loadparms from the original unload. DON'T CHANGE THEM!
-----Original Message----- From: ravi kumar hassan [mailto:ravibh@HOTMAIL.COM] Sent: Wednesday, March 14, 2001 1:52 PM To: DB2-L@RYCI.COM Subject: regarding load... immediate reply.
Hi Folks,
In our shop we are using DB2 V6 on os390. one of request came from the user. they wants to increase the length of column in the existing table. we have a table around 5 columns in that and we have around 10000 records in that. so now they came up with they wants to increase lenth of two column. [...]
33509 65 31_Re: Count is there without data16_Michael McKinney16_mmckinne@CSC.COM31_Wed, 14 Mar 2001 15:28:59 -0500472_iso-8859-1 You may have to run a recover on your indexes as well. Your index(s) and table may have ended up out of sync.
Mike
Mike Friedlander @RYCI.COM> on 03/14/2001 03:18:40 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Count is there without data [...]
33575 19 26_Opportunity in the Midwest9_Mike Mays18_MMays@NOLLJOBS.COM31_Wed, 14 Mar 2001 14:30:36 -0600457_- Dear Listers: An outstanding DB2-DBA position in lovely Omaha. Financial leader in the Midwest. Any interest, please contact me for more details. Thanks much
Mike Mays 800-798-7736 ext 3450
.
================================================ 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.
33595 116 31_Re: Count is there without data0_22_BILL_GALLAGHER@PHL.COM31_Wed, 14 Mar 2001 15:40:33 -0500426_iso-8859-1 Mike,
Why did you imagecopy/recover the tablespace before/after the alter? And what exactly did you alter? Did you just alter the tablespace PRIQTY and/or SECQTY? If so, then you could have just done an alter followed by a reorg to "reallocate" the tablespace with the larger space allocations. When you recovered the tablespace from the image copy, did you also recover/rebuild the associated indexes? [...]
33712 41 31_Migration problem from v5 to v615_Ali OZTURK(942)27_Ali.OZTURK@PAMUKBANK.COM.TR31_Wed, 14 Mar 2001 22:47:18 +0200672_ISO-8859-9 When we are migrating db2 v5 os/390 to V6 , we got an error in CATMAINT process. (job name is DSNTIJTC)
The error is:
DSNU050I DSNUGUTC - CATMAINT UPDATE DSNU750I DSNUECM0 - CATMAINT UPDATE STARTED DSNU777I DSNUECM0 - CATMAINT UPDATE STATUS - VERIFYING CATALOG IS AT CORRECT L DSNU777I DSNUECM0 - CATMAINT UPDATE STATUS - BEGINNING MIGRATION SQL PROCESSIN DSNU778I -DBG1 DSNUEXDL - ERROR PROCESSING SQL STATEMENT - SQL CODE IS: -904 SQL MESSAGE TOKENS: 00C90081,00000200,DSNDB06.SYSOBJ THE FOLLOWING IS THE PROBLEM SQL STATEMENT: CREATE TABLESPACE SYSOBJ IN DSNDB06 CCSID EBCDIC USING VCAT Ü00000 FREEPAGE 0 PCTFREE 7 BUFFERPOOL BP0 LOCKSIZE [...]
33754 50 31_Re: Count is there without data19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Wed, 14 Mar 2001 12:54:34 -0800391_iso-8859-1 First comment: the select statements would have creator.table not dbname.tablespace.
But: COUNT(*) will use an index - i.e. if the index wasn't rebuilt after the tablespace was recovered, they're out of sync and your answer reflects what the index thinks is there. Been there.
And, yes the vsam structure is for the tablespace (which can hold 0 - many tables). [...]
33805 109 38_Re: regarding load... immediate reply.16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Wed, 14 Mar 2001 14:06:08 -0700299_iso-8859-1 Unload the data using DSNTIAUL. Use the load command (created when you unloaded using DSNTIAUL) that matches the old table format to load the data. If you try to use a load command matching the new table definition then the unloaded data will not be in the correct column positions. [...]
33915 123 35_Re: Migration problem from v5 to v611_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Wed, 14 Mar 2001 15:08:28 -0600647_iso-8859-1 00C90081
Explanation: An attempt was made to allocate a resource that is stopped for all access. This reason code is issued by the following CSECTs: +-----------------------------------------------------------------------------------------------+
¦ DSNIDBCA ¦ DSNIDBCI ¦ DSNIDBCJ ¦ DSNIDBCN ¦ ¦ DSNIDBCO ¦ DSNIDBCP ¦ DSNIDBCQ ¦ DSNISTDB ¦ ¦ DSNISTPS ¦ ¦ ¦ ¦ +-----------------------------------------------------------------------------------------------+
System Action: The allocation process is not allowed. User Response: Determine when the resource is no longer stopped, and rerun the job. [...]
34039 158 31_Re: Count is there without data13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Wed, 14 Mar 2001 14:06:09 -0700343_iso-8859-1 Select * uses the data pages, select count(*) will use a index if it exists. when I do a recover tablespace db.ts I follow it with a recover index(all) tablespace db.ts. check index will tell you if this is the case.
The fact that you lost all the data (not just a few rows) tells me you something else may be going on. [...]
34198 84 35_Re: Migration problem from v5 to v60_17_sjvagnier@AEP.COM31_Wed, 14 Mar 2001 16:03:25 -0500627_iso-8859-1 Ali,
Did job member DSNTIJIN run successfully? This member creates Tablespace SYSOBJ in DSNDB06.
Hope this helps
Steve Vagnier
"Ali OZTURK(942)" @RYCI.COM> on 03/14/2001 03:47:18 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Migration problem from v5 to v6
When we are migrating db2 v5 os/390 to V6 , we got an error in CATMAINT process. (job name is DSNTIJTC) [...]
34283 25 21_Cataloging a Database11_Scott Adams20_Sadams@AMERISURE.COM31_Wed, 14 Mar 2001 16:19:16 -0500417_iso-8859-1 Hello, We are currently in the process of rolling out Windows 2000 machines at our site and are trying to catalog the necessary Databases on the local machine. Does the ID that I use to run the script have to be locally defined to the machine and be within the administrators group? What exactly is DB2 v5.2 (fixpack8) looking for regarding authorization when attempting to catalog a Node & Database? [...]
34309 78 35_Re: Migration problem from v5 to v612_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Wed, 14 Mar 2001 16:14:28 -0500567_iso-8859-1 Is dsndb06 started or restricted? i believe sysobj is new and dsndb06 is in unavailable status.
"Ali OZTURK(942)" @RYCI.COM> on 03/14/2001 03:47:18 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Migration problem from v5 to v6
When we are migrating db2 v5 os/390 to V6 , we got an error in CATMAINT process. (job name is DSNTIJTC) [...]
34388 107 35_Re: Migration problem from v5 to v615_Ali OZTURK(942)27_Ali.OZTURK@PAMUKBANK.COM.TR31_Wed, 14 Mar 2001 23:38:19 +0200399_iso-8859-1 You are right. Job member DSNTIJIN ran succussfully., SYSOBJ cluster have allready created by this job. When I start db2, DSNDB06.SYSOBJ TS is stopping. if i want to start this tablespace , it doesn't start. and finishes abnormal completion.
Ali Öztürk Pamukbank Sistem ve Network Bölümü Veri Tabani Yönetimi Servisi Tel: 0212 275 24 24 /3445 ali.ozturk@pamukbank.com [...]
34496 12 35_Re: Migration problem from v5 to v612_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Wed, 14 Mar 2001 16:42:27 -0500291_us-ascii What does a Display db ts restrict show?
================================================ 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.
34509 162 38_Re: help required - long running query11_Kwan, James18_James_Kwan@BMC.COM31_Wed, 14 Mar 2001 15:43:26 -0600346_iso-8859-1 Nagaraj
I don't quite understand why would you use so much time in a single statement. If your database is evenly distributed, you should return approximately 200 records (49M/244,926). The other predicates does not really help due to low unique value.
I cannot read your MainView/DB2 report. Can you send it again? [...]
34672 100 35_Re: Migration problem from v5 to v69_Cam White20_cwhite@REVEALNET.COM31_Wed, 14 Mar 2001 17:04:17 -0500660_iso-8859-1 A paper entitled "DB2 Version 5 to 6 Migration on OS/390", by Linda Claussen is the feature DB2 article in this month's Pipeline Newsletter. http://www.revealnet.com/newsletter-v2/newsletter_0301.htm
Hth,
Cam White RevealNet, inc.
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > sjvagnier@AEP.COM > Sent: Wednesday, March 14, 2001 4:03 PM > To: DB2-L@RYCI.COM > Subject: Re: Migration problem from v5 to v6 > > > Ali, > > Did job member DSNTIJIN run successfully? > This member creates Tablespace SYSOBJ in DSNDB06. > > Hope this helps > > Steve Vagnier > > > > > > [...]
34773 32 55_PowerBuilder 7.0 with DB2 Connect and DB2 V6.1 on OS39022_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM31_Wed, 14 Mar 2001 14:03:00 -0800623_iso-8859-1 DB2 Gurus, We are evaluating DB2 Connect EE as a replacement for our SYBASE Direct Connect gateway and during the evaluation, we found the existing Powerbuilder applications have run into the following issues
1) DB2 Connect is transmitting trailing spaces for Character fields (CHAR) from the database to the client. eg. If you have CHAR(5) field and if the field had only one character position filled say 'X', DB2 Connect is transmitting 'X '. The trailing spaces are causing a problem in the existing apps since the SYBASE gateway does not transmit trailing spaces. 2) Lower case program SQL from [...]
34806 13 12_test message13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Wed, 14 Mar 2001 15:07:35 -0700354_iso-8859-1 my posts don't go through. I get a confirm message, then a rejected message, and nothing in the list.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
34820 54 40_Slooooooow Delete, DB2 V6.1, OS/390 2.1012_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 14 Mar 2001 16:14:41 -0600366_us-ascii Hi there, esteemed list!
We ran a process today which inserted (according to the programmer) 10,009 Fiscal Year 2002 rows into a table of about 300,000 rows. We decided that was wrong and wrote the following SQL to delete them out:
LOCK TABLE FIT_BUDG_BY_FY IN EXCLUSIVE MODE; DELETE FROM FIT_BUDG_BY_FY WHERE FISCAL_YEAR = 2002; COMMIT; [...]
34875 64 35_Re: Migration problem from v5 to v612_HARBRY ARIZA20_harbry_a@HOTMAIL.COM31_Wed, 14 Mar 2001 16:35:34 -0600604_- Ali:
Have you checked if you still having any Type 1 index, datasets passwords or share read-only data. This error aim to that direction. If any of these is true you have to get back to version v5 and get rid of it and then start over the migration.
>From: "Ali OZTURK(942)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Migration problem from v5 to v6 >Date: Wed, 14 Mar 2001 22:47:18 +0200 > > When we are migrating db2 v5 os/390 to V6 , we got an error in >CATMAINT process. (job name is DSNTIJTC) > [...]
34940 97 44_Re: Slooooooow Delete, DB2 V6.1, OS/390 2.1015_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 15 Mar 2001 09:52:36 +1100477_- Hi Steve,
4.5 hours for 10,000 rows. Cool. First suggestion is to bung another hamster in the wheel driving your machine. Failing that, if you're 100% sure there's no RI children for these parent rows, I'd alter the dependent tables to remove the dependency. There may not be any child rows to delete, but DB2 still has to go to each child table, for each row, and see if there's a child or not. Not fast. Get rid of the RI, redo the delete, and put the RI back. [...]
35038 98 48_Slooooooow Delete, DB2 V6.1, OS/390 2.10 (Reply)0_22_scott.goodell@WCOM.COM31_Wed, 14 Mar 2001 16:44:30 -0600382_us-ascii You will want to make sure you have indexes on the foreign keys in the child tables. The indexes have to match the foreign keys or DB2 will not pick to use them. If you do not have indexes on the foreign key columns in the child tables then internally DB2 will tablespace scan those tables just to find there are not rows that need deleted based on your CASCADE rule. [...]
35137 43 19_Re: PRIQTY & SECQTY15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 15 Mar 2001 09:57:20 +1100317_- Hi Mike,
Don't think it's possible. The defaults is what they is. From the 'DB2 UDB for OS/390 V6 SQL Manual':
If PRIQTY is omitted, n is 12, 24, 48, or 96 for 4KB, 8KB, 16KB, and 32KB page sizes, respectively.
This is non-LOB tablespaces. The LOB values are a bit higher, funnily enough. [...]
35181 69 44_Re: Slooooooow Delete, DB2 V6.1, OS/390 2.1013_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 14 Mar 2001 16:59:47 -0600425_iso-8859-1 Steve,
Do the dependent tables have indexes on the foreign key columns? If not you will scan them both for each delete. Still, that is a long time........
Dave -----Original Message----- From: Steve Grimes [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Wednesday, March 14, 2001 4:15 PM To: DB2-L@RYCI.COM Subject: Slooooooow Delete, DB2 V6.1, OS/390 2.10
Hi there, esteemed list! [...]
35251 42 34_Re: FW: Test message please ignore14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 15 Mar 2001 10:02:40 +1100509_iso-8859-1 In addition to Jim's suggestion, I think you might want to consider use of LSR - even though you won't be updating the the VSAM cluster. This should reduce the open/close overheads in each SP and allow the SPs to share, especially, index buffers.
/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Jim Harrison [mailto:jharrison@GMX.NET] Sent: Thursday, 15 March 2001 1:09 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] FW: Test message please ignore [...]
35294 47 36_DB2 for W98 V6.1 and JVM - attempt 215_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 15 Mar 2001 10:03:37 +1100569_- Fellow Listers,
I sent this a couple of days ago. Not sure if it made it through, so here it is again.
Some help, please, from those of you who have installed DB2 for Windows 98 V6.1. I'm finally getting off my overweight inactive posterior and trying to do the V6 certification guide, now that I've got a laptop to install it on. The install eventually worked (I wasn't seeing the prompts when installing from the book's CD that the book said I should, so I uninstalled and installed from a demo CD I picked up somewhere. Much better) but [...]
35342 85 44_Re: Slooooooow Delete, DB2 V6.1, OS/390 2.1013_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 14 Mar 2001 17:01:11 -0600407_us-ascii Steve,
The first thing that springs to mind....do you have indexes on the RI child tables?
Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Steve Grimes Sent: Wednesday, March 14, 2001 4:15 PM To: DB2-L@RYCI.COM Subject: Slooooooow Delete, DB2 V6.1, OS/390 2.10 [...]
35428 79 44_Re: Slooooooow Delete, DB2 V6.1, OS/390 2.1013_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Wed, 14 Mar 2001 16:05:47 -0700480_iso-8859-1 Do the foreign keys on the child tables have indexes? If not, it will scan the child tables for each parent row that's deleted. Also in a test system runstats can be out of date, not run, or run on an empty table that has since been loaded up.
DT
-----Original Message----- From: Steve Grimes [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Wednesday, March 14, 2001 3:15 PM To: DB2-L@RYCI.COM Subject: [DB2-L] Slooooooow Delete, DB2 V6.1, OS/390 2.10 [...]
35508 53 59_Re: PowerBuilder 7.0 with DB2 Connect and DB2 V6.1 on OS39013_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 14 Mar 2001 17:08:41 -0600424_iso-8859-1 Ramesh,
1)For some, 'X ' may be what is desired to be returned.
How about altering the column from char(5) to varchar(5)?
Just an idea.
2)lower case SQL ??
Dave
-----Original Message----- From: Ramesh Balasubramanyan [mailto:RAMBAL@SAIF.COM] Sent: Wednesday, March 14, 2001 4:03 PM To: DB2-L@RYCI.COM Subject: PowerBuilder 7.0 with DB2 Connect and DB2 V6.1 on OS390 [...]
35562 33 23_Re: DR with DB2 and IMS20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 14 Mar 2001 18:20:58 EST164_US-ASCII Aurora, What is the address to subscribe? You did not include the address. Ed DB2 Recovery On-site and Off-site DR http://www.recoveryknowledge.bigstep.com
35596 96 44_Re: Slooooooow Delete, DB2 V6.1, OS/390 2.1014_Richard Yevich17_ryevich@YAHOO.COM31_Wed, 14 Mar 2001 15:27:51 -0800611_us-ascii Steve,
One thing to look at is to see if there are correct foreign key indexes, otherwise if cascade delete, there will be TS scan invoked which can really slooooooooooow things up.
--- Steve Grimes wrote: > Hi there, esteemed list! > > We ran a process today which inserted (according to the programmer) > 10,009 > Fiscal Year 2002 rows into a table of about 300,000 rows. We > decided that was > wrong and wrote the following SQL to delete them out: > > LOCK TABLE FIT_BUDG_BY_FY IN EXCLUSIVE MODE; > DELETE FROM FIT_BUDG_BY_FY > WHERE FISCAL_YEAR [...]
35693 85 39_Re: Hybrid join to a Nested Loop Join ?13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 14 Mar 2001 17:32:04 -0600371_iso-8859-1 Susan,
Any change to the catalog statistics, bufferpools, CPU etc. can change the access path. Unfortunately we are not privvy to the exact formulas, but there are fine lines as to when when a nested loop is better than hybrid or merge scan. And when you cross that line, well you see the result....That's not to say the optimizer is always right. [...]
35779 50 13_Re: IBM C/C++18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Thu, 15 Mar 2001 09:15:17 +0930666_us-ascii Howzit John?
Stored Procedure Builder is 1 I know of.
Cheers Bruce Williamson
DB2 Database Administrator DCIS NT Government Darwin NT 0800
"JOHN G. MATTHEWS" @RYCI.COM> on 15/03/2001 02:16:00
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: IBM C/C++
We are on DB2/390 V6. We are not currently paying for IBM C/C++. What features/options of DB2/s390 V6(or V7) will we be unable to take advantage of? [...]
35830 21 42_inactive (distributed) thread holding lock13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 14 Mar 2001 17:50:21 -0600362_iso-8859-1 Hello List,
I'm hoping that someone can shed some light on the situation of an INACTIVE distributed thread that is continuing to hold locks (DB2 OS/390 V5). A CANCEL thread command was issued, but the inactive thread was unaffected. The thread was no longer present in DB2 Connect.
Cancelling the DDF cleared it up, but is drastic. [...]
35852 214 38_Re: help required - long running query14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 15 Mar 2001 10:53:15 +1100385_iso-8859-1 Nagaraj
Welcome to, as Michael Hannan calls it, "Death by random IO"! Basically, DB2 has decided, based on the statistics in the catalog, that there will be only a few rows (James' estimate is 200) that satisfy the predicates; the cost of synchronous IO to fetch them is pretty low; _and_ there is an index that obviates the need for a sort: So DB2 will use it. [...]
36067 203 47_Re: what can I do to achieve a good performance0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 14 Mar 2001 17:56:02 -0600609_iso-8859-1 Thats a BIG question, with lots of possible answers. Here are few thoughts:
Office Politics: A big hurdle will be office politics (especially when it comes to funding for proactive performance management). As far as most people (especially users and management) are concerned "... if it ain't broke, don't fix it ..." is the golden rule. If you can get management/users to agree that poor performance is one of the criteria defining 'broke' then you are ahead of the game. For example, a batch job that runs several hours, is generally not considered 'broke' until you run out of batch [...]
36271 33 13_Re: IBM C/C++14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 15 Mar 2001 10:57:06 +1100523_iso-8859-1 I think Stored Procedure Builder is one. (I think the output of the builder is actually a C program.)
/* standard disclaimer */ James Campbell Hansen Corporation
-----Original Message----- From: JOHN G. MATTHEWS [mailto:HC#JGM@MVS.MEDCTR.UCLA.EDU] Sent: Thursday, 15 March 2001 3:46 To: DB2-L@RYCI.COM Subject: [DB2-L] IBM C/C++
We are on DB2/390 V6. We are not currently paying for IBM C/C++. What features/options of DB2/s390 V6(or V7) will we be unable to take advantage of? [...]
36305 114 44_Re: Slooooooow Delete, DB2 V6.1, OS/390 2.1012_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Thu, 15 Mar 2001 10:56:51 +1100440_- Steve, I've seen some of the replies, and my personal favourite is putting another Hamster on the wheel.
But, the easiest would be either:- 1) Reorg (with a purge option). ie using the discard option in V6, OR if you are pre-V6 (which you are not) and have a vendor utility like BMC's REORG+, this would probably be the more efficient option. The online versions of this might reduce outages (note the attached note however). [...]
36420 135 39_DB2 Estimator V7 (7.0.4) and PeopleSoft12_Troy Coleman19_Colematr@MEIJER.COM31_Wed, 14 Mar 2001 19:09:42 -0500328_US-ASCII Hello List, I am at a client site and need to do some sizing and other things with a PeopleSoft environment. I thought I would use DB2 estimator to help me out. I downloaded the new V7 copy and copies the given SQL to import tables under DB2 V6. I used the auto name feature starting in column 4 to bypass the PS_ [...]
36556 90 40_Re: JDBC application On MVS open edition14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 15 Mar 2001 11:24:15 +1100348_iso-8859-1 Anil
FIRSTLY: for some reason your posting arrived with a "Reply-To: anilkalkatte@indiya.com" header. As most people will just hit their Reply button, their response will not go back to the list, so others won't see it. Is there some way you can change this?
Now: a bit of simple OS/390 debugging information follows: [...]
36647 81 49_Re: FW: DB2 for OS/390 stored procedures question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 14 Mar 2001 19:27:57 -0500607_iso-8859-1 I checked with IBM, via ETR, and they said to set STORPROC to nothing (STORPROC=,).
Thanks anyway.
Tina
-----Original Message----- From: Jeff Faughn [mailto:Jeff_Faughn@MAY-CO.COM] Sent: March 13, 2001 4:07 PM To: DB2-L@RYCI.COM Subject: Re: FW: DB2 for OS/390 stored procedures question
Set ZPARM to the following: STORPROC=ssidWLM,
"Hilton, Tina, BmS - NMI -PM" To: DB2-L@RYCI.COM Subject: FW: DB2 for OS/390 stored procedures Sent by: DB2 question Data Base Discussion List [...]
36729 61 31_Re: DB2 OS/390 V5 and UDB NT V718_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Thu, 15 Mar 2001 09:51:23 +0930488_us-ascii Howzit Iztok?
We are using DB2 UDB v7 fixpack 2 on NT v4 SP5 connecting to DB2 OS/390 v5.1 without any dramas.
Cheers Bruce Williamson
DB2 Database Administrator DCIS NT Government Darwin NT 0800
Iztok Jeras @RYCI.COM> on 14/03/2001 18:53:13
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
36791 51 17_Re: SQL CODE -44418_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Thu, 15 Mar 2001 09:42:25 +0930508_us-ascii Howzit Kypa?
Depending whether you are using SPAS or WLM for your SP, ensure that your load library/ies is/are in your steplib concatenation for your SPAS or WLM application environment started task.
Cheers Bruce Williamson
DB2 Database Administrator DCIS NT Government Darwin NT 0800
Rama Kypa @RYCI.COM> on 15/03/2001 02:45:44
Please respond to DB2 Data Base Discussion List [...]
36843 185 38_Re: help required - long running query18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Thu, 15 Mar 2001 10:00:02 +0930395_iso-8859-1 Howzit Nagaraj?
Depending on your data distribution you may want to update your column distribution statistics with runstats if this is not already being done.
How often does this batch program run? The other option to consider is to rebind with REOPT(VARS).
Send EXPLAIN output and column distribution stats for further help.
Cheers Bruce Williamson [...]
37029 61 118_Re: PJ25955 - SQL0104N AN UNEXPECTED TOKEN "END-OF-STATE MENT" WAS FOUND FOLLOWING KEYA WHERE BLOCKKEY= SQLSTATE=4260114_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 15 Mar 2001 11:58:28 +1100368_iso-8859-1 Bilal,
(I'm not a Connect expert, but)
What was the error that _you_ had. The documentation that is at IBM might have similar symptoms to yours, but since (I presume) you don't have Olap Server V1.0.1 (and FP9 is several years old, so any problems should have been fixed in more recent products), I doubt you are having the same problem. [...]
37091 66 46_Re: Qualifier, Plan, Package and concatenation14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 15 Mar 2001 12:05:18 +1100481_iso-8859-1 Hansueli
Create another collection, say USERPROJCOL; Bind all project packages into USERPROJCOL, but using the user qualifer; use PKLIST(USERCOL.*, USERPROJCOL.*) in the user plan.
/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Blumer Hans-Ulrich [mailto:Hans-Ulrich.Blumer@WINTERTHUR.CH] Sent: Wednesday, 14 March 2001 20:32 To: DB2-L@RYCI.COM Subject: [DB2-L] Qualifier, Plan, Package and concatenation [...]
37158 118 38_Re: help required - long running query13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 14 Mar 2001 19:42:46 -0600542_iso-8859-1 All,
Michael is the first to admit that he does not know the true origin of the term "Death by Random I/O", but believes that Joel Goldstein may be able to lay claim to it. But I do agree that Michael has added to this statement's fame.
I have not seen "Death by Random I/O" on a single table, since that is what List Prefetch is there to avoid. Unless LP is being disabled due to the clause OPTIMIZE for 1 ROW (not shown). This phenomena generally occurs on the inner table of a nested loop join which does not [...]
37277 37 23_Re: DR with DB2 and IMS12_Mark Granger22_the_grange@MBOX.COM.AU31_Thu, 15 Mar 2001 13:11:53 +1100521_us-ascii Ed, I didn't see what list you wanted, but if you go to the following URL you can search for all public Lists -
http://www.lsoft.com/lists/listref.html
Mark Granger Independent Systems Integrators P/L Senior Technical Specialist - 2BDB2 Email: mgranger@isi.com.au Phone: +61 0416-012-262 (Australia) OR +1 617-306-7794 (USA)
----- Original Message ----- From: "Edward C. Benoit Jr." Date: Thursday, March 15, 2001 10:20 am Subject: Re: DR with DB2 and IMS [...]
37315 52 29_Re: Table authority question.14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 15 Mar 2001 13:47:29 +1100423_iso-8859-1 The way I would do this is - create a secondary auth-id (eg RACF group) - give the id the CREATETAB and USE privileges required - connect users to the id - tell the users that they have to "SET CURRENT SQLID ='id'" before creating tables. (One could go further and give the id CREATETS which means that it will automatically get the required USE OF TABLESPACE privileges when it is used to create each TS.) [...]
37368 88 43_Re: DB2 Estimator V7 (7.0.4) and PeopleSoft14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU31_Thu, 15 Mar 2001 13:44:12 +1100678_iso-8859-1 **************************************************************** IMPORTANT
The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...]
37457 33 23_Re: DR with DB2 and IMS20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 14 Mar 2001 22:09:12 EST109_US-ASCII Thanks Mark.
Ed DB2 Recovery On-site and Off-site DR http://www.recoveryknowledge.bigstep.com
37491 39 35_Re: Can we switch off Db2 logging??0_31_Ross_Mallett@SEARCHSOFTWARE.COM31_Thu, 15 Mar 2001 16:23:45 +1000288_us-ascii Yes, this topic was raised a couple of weeks back. I apologise for not checking first.
The answer was that there is no way to switch off logging per se but "If the objective is to save space on the log and archiving, there are a number of techniques for doing that". [...]