1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 2000, week 4 2 40 16_Re: -ve PAGESAVE15_Sydney Brereton21_sbrereton@MMAL.COM.AU31_Wed, 22 Nov 2000 16:38:19 +1030322_US-ASCII Hi Bruce, it says in the SQL Reference manual that "The value can be negative, for example, data compression causes an increase in the number of pages in the data set." I assume you have collected statistics for the tablespace by running RUNSTATS? You might get a -1 value if no stats are there? Cheers, Syd [...] 43 71 19_Re: Hiperpool Size.12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM31_Wed, 22 Nov 2000 00:38:11 -0600432_- Joel:

It means that is not recommended use Hiperpool for the sort work database because anyway db2 has to write those pages out to dasd and then get it back to the hiperpool over and over. It is interesting because I have heard a lot good comments about using hiperpool for the sort work but if it works this way you may count a lot of differents topics involved to carry out this activity. Thanks for your comments , [...] 115 111 33_Re: RESOLVING INDEX DE-CLUSTERING16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Wed, 22 Nov 2000 11:14:56 +0530552_- Hi Elsie, I think that everything you asked is explained by Dave. I understand that these points came out from our discussion on < 95% cluster ratio. One most important thing i have realized and done study that "Skewed Data" which has to be there because of the complex business implementation. At the initial moment of the project or design we shall put a lot of effort on the uniform data distribution as far as possible and if it is not possible at that time then we shall try and design our archival policy in such a manner that operational [...] 227 85 12_Re: 00E4001823_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 22 Nov 2000 08:04:05 -0000489_iso-8859-1 Eric

I think the problem is with the fact that Bud did do a term util and then reran the job - and DB2 got the hump.

It sounds to me that he needs to get himself a new sysutilx.

all the best

Les Leslie Pendlebury-Bowe DB2 DBA OS390 SAP DB2 Certified







-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Monday, November 20, 2000 1:54 PM To: DB2-L@RYCI.COM Subject: Re: 00E40018 [...] 313 23 12_SAP RECOVERY16_Martin Berchtold31_Martin.Berchtold@SYSTEMATICS.DE31_Wed, 22 Nov 2000 02:42:11 -0600420_- Hi,

I have a ask a question regarding SAP recovery. A customer had to recover the entire SAP database and the action took 50 hours. He had all the archive logs on tape. Then he tried to recover the environment again, archive logs on DASD (ESS), and now it took 19 hours. Does someone have any experience how long it should take to do the recovery for a SAP system, running with DB2 V6.1 under OS/390 V2.6. [...] 337 75 44_Re: Data compression using DSN8HUFF editproc12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Wed, 22 Nov 2000 09:15:37 -0000516_iso-8859-1 I think it's true to say that the takeup on software compression was very low and was only done after extensive testing whereas hardware compression is generally regarded as a good thing for large tables. Its the CPU cycles which make software compression quite an overhead.

Colin Allen

-----Original Message----- From: Mackey, Glenn [mailto:GMackey@GUIDEMAIL.COM] Sent: Tuesday 21 November 2000 11:38 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Data compression using DSN8HUFF editproc [...] 413 78 39_=?ISO-8859-7?Q?=C1=D0=3A_SAP_RECOVERY?=19_Alekos Papadopoulos13_apapad@NBG.GR31_Wed, 22 Nov 2000 12:12:00 +0200605_ISO-8859-7 Martin, Unfortunately, in almost all the cases "SAP recovery" means entire SAP database recovery. However a few tricks can be applied to reduce recovery time: 1) Moving archive logs on DASD, as you have already seen, helps a lot. 2) If you want to recover to a previous point in time, try to exclude from recovery the TSs who do not have changes after this PIT. You have 3 alternatives to find the changed tablespaces: REPORT RECOVERY for all tablespaces, DSN1LOGP SUMMARY or several vendor products. Eliminating the unchanged tablespaces will really reduce the recovery time a lot. 3) If [...] 492 70 16_Re: -ve PAGESAVE16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Wed, 22 Nov 2000 15:38:49 +0530598_- Hi Raymond, It might be your personal opinion but we do use COMPRESS YES only for saving disk space and hence I/O .I am not sure if you have any other reason for using this if pagesave is -ve.

Regards, Sanjeev

> -----Original Message----- > From: Bell, Raymond W [SMTP:Raymond.W.Bell@TEAM.TELSTRA.COM] > Sent: Wednesday, November 22, 2000 11:13 AM > To: DB2-L@RYCI.COM > Subject: Re: -ve PAGESAVE > > Got it in one, Bruce. If Pagesave is negative, the tablespace is bigger > compressed than it was uncompressed. So either your data doesn't compress > very well, or the size of [...] 563 71 16_Re: -ve PAGESAVE16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Wed, 22 Nov 2000 05:15:15 -0500587_- Hi Syd, This is the particular case when value is 0 if the statistics is not gathered or the tablespace is defined with COMPRESS NO or there is no saving of space.

Regards Sanjeev

> -----Original Message----- > From: Sydney Brereton [SMTP:sbrereton@MMAL.COM.AU] > Sent: Wednesday, November 22, 2000 11:38 AM > To: DB2-L@RYCI.COM > Subject: Re: -ve PAGESAVE > > Hi Bruce, > it says in the SQL Reference manual that "The value can be > negative, for example, data compression causes an increase in the > number of pages in the data set." I assume you have collected > [...] 635 29 18_-924 00f30024 help19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Wed, 22 Nov 2000 11:18:38 +0100509_iso-8859-1 Dear list members

I have been phoned by a developer working on a mainframe with DB2 IMS. Whilst trying to run a online program he received the following error message.

sql -924 return code 00f30024

Does somebody have any idea what this might be. I have read the error messages and codes description of the error but do not understand what the "connection name or connection type does not match the name or type established by another connected task in the address space". [...] 665 98 6_re SAP30_CHRISTOPHER.KELLER@Vereinte.de30_CHRISTOPHER.KELLER@VEREINTE.DE31_Wed, 22 Nov 2000 11:28:00 +0100422_iso-8859-1 --- Received from BG1.KELLERC 6785-2761 22-11-00 11.28

-> DB2-L@RYCI.COM

Hallo Martin, This has been discussed here a lot in the past. Will send you tomorrow in private mail a summary of the discussions.

In addition to the good suggestions from Alekos, here my contribution. There are various suggestions (e.g empty tables in own tablespaces(s)), but basically I see the alternatives: [...] 764 44 22_Re: -924 00f30024 help17_Fiorese Giampaolo29_Fiorese.Giampaolo@GENERALI.IT31_Wed, 22 Nov 2000 11:37:18 +0100463_iso-8859-1 Check if the program has been linkedited including DFSLI000. Regards Giampaolo

-----Original Message----- From: Briggs, N. - Neil - [mailto:N.Briggs@CANON-EUROPA.COM] Sent: Wednesday, November 22, 2000 11:19 AM To: DB2-L@RYCI.COM Subject: -924 00f30024 help

Dear list members

I have been phoned by a developer working on a mainframe with DB2 IMS. Whilst trying to run a online program he received the following error message. [...] 809 159 34_Re: Archive logs to DASD then tape23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 22 Nov 2000 08:12:28 -0000304_ISO-8859-1 Pedro

firstly I agree with you(and we do hold 24 hours on disk), however, at my shop we can cut a 2 gig archive log every 8 to 12 minutes at peak ..

so doing the numbers for peak ...

1440 / 4 = 180 logs ... @ 2 gig = 360 Gig .. and we do dual logging / archiving ... [...] 969 96 44_Re: Performance Degradation !!! Reorganize ?16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Wed, 22 Nov 2000 16:24:03 +0530622_- Hi Pantazis, My point is that it is not neccessary to reorg all the tablespace or indexes with the standard time frame for all i.e weekly/daily/yearly.You have to classify the tablespaces which are to be reorged depending on the growth rates, its de-clustering and sometimes depending on the performance degradation.However, the RUNSTATS have to be run daily for getting the current information. I think it is better to use the automatic utility which tells you the tablespaces/indexes which are eligible to be reorged by querying catalog tables.You may find this in either DB2-L archives or in Xephon. You can use [...] 1066 49 22_Re: -924 00f30024 help13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 22 Nov 2000 07:07:28 -0500617_iso-8859-1 Hi Neil, As Giampaolo implies you may have an incorrect link-edit step for the program in question.

When I've seen this sqlcode, it's been a result of having the wrong language interface, and it's always been caused by a incorrect link-edit. In IMS, you need the IMS attach -- provided as Giampaolo says, by DFSLI000, the IMS language interface module. My guess would be that you have a main program, probably link-edited correctly with DFSLI000 calling a subroutine which has a different language interface, perhaps the TSO (DSNELI) attach. Here's the advice from the Programming & SQL Guide: [...] 1116 45 22_Re: recover tablespace18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Wed, 22 Nov 2000 06:04:59 -0600331_- Howzit Rakesh?

Assuming you have done a quiesce prior to whatever you were doing you can recover to the RBA from the quiesce. Have a look in SYSIBM.SYSCOPY to determine the latest START_RBA for your tablespace.

If you send me some details about what you were trying to do there may be some other alternatives. [...] 1162 99 16_Re: SAP RECOVERY23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 22 Nov 2000 12:07:08 -0000413_iso-8859-7 ..be careful with using UNDO SQL in a SAP env .. not that it cannot work but we have had cases where not all SQL undo recs have been found

Leslie Pendlebury-Bowe DB2 DBA OS390 SAP DB2 Certified







-----Original Message----- From: Alekos Papadopoulos [mailto:apapad@NBG.GR] Sent: Wednesday, November 22, 2000 10:12 AM To: DB2-L@RYCI.COM Subject: ??: SAP RECOVERY [...] 1262 113 19_Re: Hiperpool Size.27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 22 Nov 2000 07:31:00 -0500435_- I thought that hiperpools weren't supposed to help DSNDB07. Did they change that opinion at some point and I missed it?

While we're talking about hiperpools and expanded storage, I have a question I hope someone can answer. I know that ADMF must be enabled in order to user hiperpools, but does anything else use ADMF? We don't have it enabled here, and I've wondered if there's anything else we might be missing out on. [...] 1376 16 16_Re: -ve PAGESAVE18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Wed, 22 Nov 2000 22:11:19 +0930327_us-ascii Howzit Folks?

Thanks for the confirmation troops.

Cheers Bruce

================================================ 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. 1393 80 27_Re: used vs allocated space11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM31_Wed, 22 Nov 2000 06:53:59 -0600727_us-ascii Nick,

Please forward the JCL/REXX if you don't mind.

Trace







"Cianci, Nick" @RYCI.COM> on 11/21/2000 11:40:02 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: used vs allocated space



Trace, Pretty much as Eric mentions Hi-Used Vrs. Hi Alloc RBAs.

A couple of things to be aware of though is that these values could wildly vary (up or down) after a reorg. Either because of PCTFREE / FREEPAGE parameters or because of reclamation of pseudo-deleted RIDS in type-2 indices. [...] 1474 98 27_Re: used vs allocated space14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Wed, 22 Nov 2000 14:07:09 +0100611_us-ascii Hi Nick,

wouldn't this be something for the documents-site ?

Regards Ruediger Kurtz

Trace Jones schrieb:

> Nick, > > Please forward the JCL/REXX if you don't mind. > > Trace > > "Cianci, Nick" @RYCI.COM> on 11/21/2000 > 11:40:02 PM > > Please respond to DB2 Data Base Discussion List > > Sent by: DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: > > Subject: Re: used vs allocated space > > Trace, > Pretty much as Eric mentions Hi-Used Vrs. Hi Alloc RBAs. > > A couple of things to be aware of [...] 1573 16 27_Re: used vs allocated space15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 22 Nov 2000 07:05:13 -0600478_- Hello Trace

Another alternative is using the stospace utility and comparing the value in the space-column of systablespace with nactive. This tells you the number of allocated bytes and the number of active pages.

Cheers

================================================ 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. 1590 43 16_Re: -ve PAGESAVE16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 22 Nov 2000 08:04:07 -0500505_iso-8859-1 I Believe that it means the size of the compression dictionary exceeded the amount of data pages saved. At least there is a 1-to-1 correlation with that statement at our site. Yes, these are good candidates for removing compression.

eric pearson ITO DB2 support Eric.Pearson@nscorp.com



-----Original Message----- From: Bruce.Williamson@NT.GOV.AU [mailto:Bruce.Williamson@NT.GOV.AU] Sent: Wednesday, November 22, 2000 12:38 AM To: DB2-L@RYCI.COM Subject: -ve PAGESAVE [...] 1634 12 11_Re: compare15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM31_Wed, 22 Nov 2000 07:15:17 -0600317_us-ascii We use BMC to compare the structures in one sub system to another.

================================================ 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. 1647 18 20_Re: GMT Time and DB215_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 22 Nov 2000 07:16:31 -0600371_- Dean

I think DB2 won't, but maybe you. In our installation we also use GMT=GMT and I recognized that for example the precompiler-timestamp and the version in sysibm.syspackage are different in exact one hour. The special register CURRENT TIMEZONE contains 10000 and maybe there are others (computing the version out of contoken or a timestamp out of LRSN). [...] 1666 34 19_Re: Hiperpool Size.14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 22 Nov 2000 08:44:55 -0500440_ISO-8859-1 Tina, That opinion was corrected about 3 yrs ago based on testing at many user sites. As far as I know, nothing else uses admf... but it's possible. Additionally, DB2 V6 uses a "fastmove" instead of admf because it's more efficient. Regards, Joel

+++++++++++++++++++++++++++++++++++++++++++++++++ I thought that hiperpools weren't supposed to help DSNDB07. Did they change that opinion at some point and I missed it? [...] 1701 37 19_Re: Hiperpool Size.14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 22 Nov 2000 08:55:36 -0500579_ISO-8859-1 However you interpret it, I strongly recommend that every site turn on a HP for the sort work... and measure the performance. More than 50% of the sites so far have gotten good performance gains from this. Regards, Joel



Message text written by DB2 Data Base Discussion List > It means that is not recommended use Hiperpool for the sort work database because anyway db2 has to write those pages out to dasd and then get it back to the hiperpool over and over. It is interesting because I have heard a lot good comments about using hiperpool for the [...] 1739 39 19_Re: Hiperpool Size.14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 22 Nov 2000 09:02:27 -0500501_ISO-8859-1 Maybe it's semantics, but the way you write itg is not correct. Pages written out to dasd can then be moved to the HP. As soon as any page is written to dasd, it can be moved to the HP. Then if it in the HP when needed, it does not have to be read back from dasd. Since pages read back from the sort dasd are usually discarded at that point, there is no circular read/re-read going on. They are not read back from dasd and moved to the HP, although it could be migrated to hp again if [...] 1779 55 56_Re: DB2PM, DPMPARMS Dataset Not Compatible After Upgrade23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 22 Nov 2000 13:51:46 -0000480_iso-8859-1 Tim sadly we do not use the parms dataset here ..

but I agree with you for what it is worth.

Leslie

-----Original Message----- From: tkelly@NOTES.STATE.NE.US [mailto:tkelly@NOTES.STATE.NE.US] Sent: Wednesday, November 15, 2000 7:15 PM To: DB2-L@RYCI.COM Subject: DB2PM, DPMPARMS Dataset Not Compatible After Upgrade



Has anyone run into the problem of not being able to use DPMPARMS after upgrading to the next version of DB2PM? [...] 1835 30 44_Re: Data compression using DSN8HUFF editproc10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 22 Nov 2000 15:26:05 +0100298_us-ascii I tried Huffman compression (but it was many years ago and with a 3rd party product) and the compression was good,

but I remember that for DB2 it was not so good as for VSAM and sequential files, and the CPU costs was relatively high.

Sorry but I've no numbers to show. [...] 1866 20 41_DB2 messages returned to stored procedure21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Wed, 22 Nov 2000 09:33:08 -0500418_iso-8859-1 Hi Folks,

Is there any way to get the DB2 message returned to a stored procedure, ie 00f30086 when a password has expired?

DB2 V5 OS/390 2.6

Jim

================================================ 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. 1887 39 44_Re: Data compression using DSN8HUFF editproc12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 22 Nov 2000 06:34:14 -0800613_us-ascii Why use an editproc for compression when COMPRESS=YES is standard and fully supported? There's been lots of comments in the archives about using COMPRESS=YES. Plus IBM is strongly recommending to not use EDITPROCs. --- Ajit Behera wrote: > Hi, > > I have a question about using DSN8HUFF editproc for > data compression. I > want to know how good it is and what is the effect > on performance if the > table is used in an online environment. > Thanks, > > Ajit > > ================================================ > To change your subscription options or to cancel > your [...] 1927 20 16_Re: SAP RECOVERY0_17_JTonchick@AOL.COM29_Wed, 22 Nov 2000 10:08:51 EST399_US-ASCII I think that the real question to ask here is:

"What is happening in the SAP application that is causing the customer to think that they need to recover databases so much?"

DB2 does an excellent job concerning data integrity and recovery. There is obviously another problem here besides the speed at which DB2 can recover data. The fastest recovery is the one you avoid. [...] 1948 28 45_Re: DB2 messages returned to stored procedure15_Lucchetti Bruno22_B.Lucchetti@BARILLA.IT31_Wed, 22 Nov 2000 16:20:42 +0100666_iso-8859-1 For the message (written on MVS SYSLOG) :

09.46.52 STC00203 DSNL030I =A7 DSNLTSEC DDF PROCESSING FAILURE FOR LUWID=3DGA4B0B0A.G404.B4F5321C466F AUTHID=3Du95, REASON=3D00F30085



I use an Automation Tool(Autooperator by B&B - now BMC) that captures the message and sends it to interested people.





Bruno Lucchetti Barilla Alimentare S.p.A. Via Mantova 166 43100 Parma Italy

================================================ 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. 1977 27 17_DB2 Identity Cols14_Scott Trometer22_scott.trometer@RCI.COM31_Wed, 22 Nov 2000 11:00:05 -0500461_iso-8859-1 ----- List,

I have looked and looked...Does DB2 let me know what the value of an 'identity' column is upon insert(by way of SQLCODE,MSG,TOKEN, etc.)?

It seems to me that there must be a DB2 supported means to know what the value is immediately. Otherwise, it's nice that I have this new(V6) ability to let DB2 generate uniqueness for a row, but, how can I guarantee that I will select the correct row after it has been inserted ?? [...] 2005 106 16_Re: SAP RECOVERY9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Wed, 22 Nov 2000 09:14:46 -0700601_iso-8859-7 Howdy Guys,

The method in which SAP Recovery is executed is "directly proportional" to the Release of SAP (R2, R3-4.5A, R3-4.5B, R3-4.6B) and the level of recovery (Recover to Current or Point-in-Time). The number of DB2 objects increases as the R3 versions increase (about 24 percent per).

I won't get into detail here because I would need much more that the 250 lines allowable on the DB2 Listerv. The easiest level of Recovery in SAP R3 is "Recover to Current". The quickest approach here is to use IBM SnapShot because it uses a DASD volume Restores to do it's thing [...] 2112 33 71_question regarding your use of OS/390 DB2 and the web - security issues0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 22 Nov 2000 10:26:29 -0600626_us-ascii We are getting into some discussions regarding using mainframe (OS/390) DB2 as a underlying datastore for web based applications and have some concerns regarding security. One possible option for enhancing security would be the creation of a brand new DB2 platform exclusively for web access. Of course, if this option is used, there will be a requirement for sending data back and forth between the web DB2 and our operational DB2. As an alternative to creating a second platform, we are also considering direct web access to our current operational DB2 using firewall(s) to provide security. In this way, data [...] 2146 47 21_Re: DB2 Identity Cols10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Wed, 22 Nov 2000 10:31:00 -0600331_- Scott,

I assume that you have read and read about the IDENTITY_VAL_LOCAL function, and decided that it doesn't help you? If not (and I think that it may well do what you want), see chapter 3.1.8 in DB2 UDB Server for OS/390 Version 6 Technical Update, which is starring at your friendly local IBM web site right now. [...] 2194 66 21_Re: DB2 Identity Cols0_19_Tim.Lowe@STPAUL.COM31_Wed, 22 Nov 2000 10:38:35 -0600580_us-ascii Scott, Take a look at the IDENTITY_VAL and IDENTITY_VAL_LOCAL functions in Apar PQ30652.

Thanks, Tim





Scott Trometer cc: Sent by: DB2 Subject: DB2 Identity Cols Data Base Discussion List



11/22/2000 10:00 AM Please respond to DB2 Data Base Discussion List











----- List,

I have looked and looked...Does DB2 let me know what the value of an 'identity' column is upon insert(by way of SQLCODE,MSG,TOKEN, etc.)? [...] 2261 79 21_Re: DB2 Identity Cols0_19_Tim.Lowe@STPAUL.COM31_Wed, 22 Nov 2000 10:42:50 -0600574_us-ascii Sorry, that should have been PQ36328. ----- Forwarded by Tim Lowe/sfm/spc on 11/22/2000 10:42 AM -----

Tim Lowe To: DB2 Data Base Discussion List 11/22/2000 10:38 AM cc: Subject: Re: DB2 Identity Cols(Document link: Tim Lowe)







Scott, Take a look at the IDENTITY_VAL and IDENTITY_VAL_LOCAL functions in Apar PQ30652.

Thanks, Tim





Scott Trometer cc: Sent by: DB2 Subject: DB2 Identity Cols Data Base Discussion List [...] 2341 15 29_VB connect to change password21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Wed, 22 Nov 2000 11:51:12 -0500344_iso-8859-1 Would anyone have a sample ADODB.Connect string to change a password on DB2/390?

Jim

================================================ 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. 2357 61 23_Poor CICS Response Time16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Wed, 22 Nov 2000 12:04:43 -0500355_iso-8859-1 Environment: DB2 OS/390 V6.1, CICS Tran Server 1.3 (put level unavailable)

We upgraded to DB2 V6.1 last weekend. Since then our CICS response time has degraded dramatically. Just CICS. Everything else has the same or better elapsed times. Does anyone have any ideas or experienced the same problem? TIA.

Gerald R. (Garry) Brookman 2419 113 44_Re: Performance Degradation !!! Reorganize ?17_Pantazis Pantazis20_zakis@CYTANET.COM.CY31_Wed, 22 Nov 2000 07:12:48 +0200459_iso-8859-7 Thank you all for your prompt response. I will look into all the answers and see which one applies to our installation.

The main problem here is the management. You know how they are. Somebody told them that if you reorganize the whole DB2 the performance becomes better and now they want the whole DB2 to be reorganized. I tried to convince them that it does not have to be the whole DB2 but just the important databases, but bothing. [...] 2533 91 42_Re: Partitioning Challenge, DB2 OS/390 V 616_Jerry Bustamante20_ggbusta@LANDSEND.COM31_Wed, 22 Nov 2000 11:13:14 -0600563_iso-8859-1 Andy, Suresh, Raymond, Nick,

Wow. Thanks a million for taking the time to answer and all your wonderful advice. I need to skull over a few things and get with our vendor to find out more about the key.



Thanks again.



Sincerely,

Jerry Bustamente Lands' End





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Cianci, Nick Sent: Tuesday, November 21, 2000 11:21 PM To: DB2-L@RYCI.COM Subject: Re: Partitioning Challenge, DB2 OS/390 V 6 [...] 2625 79 17_DSNZPARM CACHEPAC16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Wed, 22 Nov 2000 12:30:21 -0500526_iso-8859-1 Envir: DB2 OS/390 V6.1

I need some assistance in calculating the value of DSNZPARM "CACHEPAC". We have 4546 rows in SYSIBM.SYSPACKAGE. The installation guide states that "32KB is enough storage for about 375 collection-ID.package-ID's". I divided 4546 by 375 and results were rounded up to 13. 13 times 32KB equals 416KB or 425984. Am I doing this correctly? When I display this value in OMEGAMON for DB2 V500, it shows zero. Platinum RC/Query indicates the 425984 value. I don't know which to believe. [...] 2705 32 19_JDBC 1st use binds?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 22 Nov 2000 14:03:30 -0500571_iso-8859-1 I am attempting to help a colleague who is using a product which makes JDBC calls. The product has been around awhile but he is using it in a new DB2 subsystem. He was failing in his first attempts to make JDBC calls. Debugging information pointed to BIND failures. He obtained BINDADD from the Sysadm in that subsys. The calls still failed. The Sysadm temporarily gave the end user Sysadm authority and the calls now work. Snooping the catalog, I see that at the time he was first successful in making JDBC calls in that subsystem, there are 49 packages [...] 2738 60 23_Re: JDBC 1st use binds?11_rick creech18_ykcirc@HOTMAIL.COM31_Wed, 22 Nov 2000 13:13:10 -0600649_- Hi,

Sounds like a typical DB2 Connect installation. It always uses a collection name of NULLID to create it's packages. As well as BINDADD, there must also be granted CREATE IN collection NULLID.

HTH,

Rick Creech



>From: "Seibert, Dave" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: JDBC 1st use binds? >Date: Wed, 22 Nov 2000 14:03:30 -0500 > >I am attempting to help a colleague who is using a product which makes JDBC >calls. The product has been around awhile but he is using it in a new DB2 >subsystem. He was failing in his first [...] 2799 54 23_Re: JDBC 1st use binds?13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 22 Nov 2000 13:29:06 -0600275_US-ASCII Dave, If you are using DB2 Connect to access host databases, you will need to bind the bind files. Since this is a new subsystem I assume the DB2 connect administrator did not bind the bind files. Some of the bind files will be bound at first connect. HTH Kurt [...] 2854 49 0_11_Joseph Link26_joe.link@FIRSTDATACORP.COM31_Wed, 22 Nov 2000 13:22:04 -0600563_us-ascii We have uncovered a strange performance scenario, and I was hoping someone on the Listserve might have an explanation for what we have found.

An SQL statement that joins a table to itself was using an excessive amount of CPU. The access path was Index Only on the unique clustering index with 5 (of 5) matching columns with a nested loop join to the same index with 5 matching columns. The outer table has equal predicates on the first 4 columns and a greater than on the 5th. The inner table has 5 equal predicates. The values we tested had [...] 2904 18 96_Control Center (V7 on NT) error while trying to display the buff erpools on OS/390 DB2 Version 612_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Wed, 22 Nov 2000 13:37:11 -0600446_iso-8859-1 Any ideas what causes the following error when I try to display the bufferpools?

IFI Command Execution: IFI Return code: 0. IFI Reason code: 0/ IFI excess bytes : 0. No results returned.

================================================ 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. 2923 87 32_Re: Degree (1 ) and Degree (any)12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US31_Wed, 22 Nov 2000 14:38:08 -0500323_US-ASCII Ken, Byron and List-

We are also testing parallelism (currently v5, but soon to be v6) and have not run across this issue (I haven't seen any count distinct statements or incorrect results). Are there other known instances of parallelism coming back with incorrect results that we should look out for? [...] 3011 123 27_Re: used vs allocated space15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 22 Nov 2000 13:53:17 -0600542_iso-8859-1 Yes, I would be interested in such a routine as well.

Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin

"The problem is not that there are problems. The problem is expecting otherwise and thinking that having problems is a problem." - Theodore Rubin



-----Original Message----- From: Ruediger Kurtz [mailto:ruediger.kurtz@HUK-COBURG.DE] Sent: Wednesday, November 22, 2000 7:07 AM To: DB2-L@RYCI.COM Subject: Re: used vs allocated space [...] 3135 170 27_Re: used vs allocated space13_Davis, Ronald17_DavisRo@CONED.COM31_Wed, 22 Nov 2000 15:31:26 -0500329_iso-8859-1 I've put together a little procedure that gets the allocated vs used - and generates alters based on an algorhythm that can be easily changed to fit your needs. I have the algorhythm set as amount used + 2% with 5% going to secondary. The FDR part of the procedure gets the allocated vs used. It looks like this: [...] 3306 186 27_Re: used vs allocated space15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 22 Nov 2000 14:34:46 -0600606_iso-8859-1 Thanks! I'll give it a try next week. Gotta go eat turkey, you know.

Linda

-----Original Message----- From: Davis, Ronald [mailto:DavisRo@CONED.COM] Sent: Wednesday, November 22, 2000 2:31 PM To: DB2-L@RYCI.COM Subject: Re: used vs allocated space



I've put together a little procedure that gets the allocated vs used - and generates alters based on an algorhythm that can be easily changed to fit your needs. I have the algorhythm set as amount used + 2% with 5% going to secondary. The FDR part of the procedure gets the allocated vs used. It looks like this: [...] 3493 198 27_Re: used vs allocated space16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Wed, 22 Nov 2000 15:38:14 -0500719_us-ascii Ron,

Thanks! It was very good of you to share this w/ the listserve community!

Rick Molera

Mainframe DB2 DBA











"Davis, Ronald" on 11/22/2000 03:31:26 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: RICHARD E MOLERA/SallieMae) Subject: Re: used vs allocated space





I've put together a little procedure that gets the allocated vs used - and generates alters based on an algorhythm that can be easily changed to fit your needs. I have the algorhythm set as amount used + 2% with 5% going to secondary. The FDR part of the procedure gets [...] 3692 139 32_Re: Degree (1 ) and Degree (any)13_Michael Kovas17_KOVASM@BCBSIL.COM31_Wed, 22 Nov 2000 14:42:51 -0600388_US-ASCII We have had similar problems in v6 doing an Outer Join with nested table expressoin with exists. The following SQL was bound with Degree any in v5 and returned no rows. We ran the same program(bound with Degree Any) in v6 and received rows back. We rebound the program using Degree 1 in v6 and the SQL returned no rows(as it should). We are using Degree 1 as a work around. [...] 3832 157 34_Re: Archive logs to DASD then tape19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 22 Nov 2000 14:41:53 -0600583_ISO-8859-1 Hi Leslie, The best way I've seen yet to handle this situation follows; maybe someone has an even better way. We didn't use DFSMS. We had an "Archive Pool" on DASD. It represented about 25% of our total Active log space (dual logging). Each successful archive message to SYSLOG was trapped by OPS/MVS which triggered a job to copy that Archive to tape and if successful, delete it from the "Archive Pool". Obviously its not this simple. We had some REXX code to handle errors, etc. But the concept worked well. This particular subsystem had 12 dual active logs, each [...] 3990 38 42_Re: Partitioning Challenge, DB2 OS/390 V 618_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Wed, 22 Nov 2000 22:09:56 +0100606_us-ascii Jerry,

If you are on db2V6 just use rowid. 2.8.6.3 Using ROWID as the partitioning key

Gerrit

Jerry Bustamante wrote:

> Hey Folks, > > We have a 34 char(acter), alphanumeric, near random column value we need to try > and partition on. > I'm looking for an algorithm to apply to this value to calculate a partitioning > value. I would > prefer a minimum of 50 partitions up to the maximum. Any suggestions? > > Thanks, > > :-) > > Jerry Bustamente > Lands' End > > ================================================ > To change your subscription options or to cancel [...] 4029 189 27_Re: used vs allocated space15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 22 Nov 2000 15:11:47 -0600638_iso-8859-1 I just looked at this a little more closely. It looks like we need the program source code as well. Will you be able to include that?

Thanks,

Linda

-----Original Message----- From: Davis, Ronald [mailto:DavisRo@CONED.COM] Sent: Wednesday, November 22, 2000 2:31 PM To: DB2-L@RYCI.COM Subject: Re: used vs allocated space



I've put together a little procedure that gets the allocated vs used - and generates alters based on an algorhythm that can be easily changed to fit your needs. I have the algorhythm set as amount used + 2% with 5% going to secondary. The FDR part of the procedure [...] 4219 204 27_Re: used vs allocated space13_Davis, Ronald17_DavisRo@CONED.COM31_Wed, 22 Nov 2000 16:19:50 -0500476_iso-8859-1 FDR is a vendor product - all shops have some sought of DASD mgmt product. You may have FDR - check with DASD guys.

-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Wednesday, November 22, 2000 4:12 PM To: DB2-L@RYCI.COM Subject: Re: used vs allocated space



I just looked at this a little more closely. It looks like we need the program source code as well. Will you be able to include that? [...] 4424 26 32_ACCESS TO DB2 CONVERSION PROBLEM17_Rabindra Senapati21_rsenapati@HOTMAIL.COM31_Wed, 22 Nov 2000 15:38:42 -0600311_- Hi Friends,

We are in the process of converting a ACCESS database to DB2 UDB V7.1. How could we achive the following two datatypes which is not supported in DB2 UDB? One field Yes/No and another AUTO NUMBER in Access. If any one has sloved the problem please let us know. That will be great help. [...] 4451 24 39_How to get a Julian date from version 515_Smith, Dennis J22_dennis.j.smith@EDS.COM31_Wed, 22 Nov 2000 16:07:28 -0600314_iso-8859-1 A new application wants to be able to use the Julian-day function under our test system which is version 6, but our production systems are v5 right now. We will not be at v6 in production before the application will be in production. Is there a v5 equivalent?

Thanks;

Dennis J. Smith [...] 4476 68 16_Re: -ve PAGESAVE15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 23 Nov 2000 09:33:23 +1100393_- Sanjeev,

Perhaps I wasn't clear enough. I meant that, for small tablespaces (i.e. <10 cyls) that are larger after compression than before, I wouldn't bother uncompressing them to get back that handful of cylinders. It depends on how much of a priority your organisation puts on saving every last track. Personally, and this is still my opinion, it's more effort than it's worth. [...] 4545 56 43_Re: How to get a Julian date from version 50_22_Rohn.Solecki@MTS.MB.CA31_Wed, 22 Nov 2000 17:21:02 -0600561_us-ascii How about SQL modeled on this example:

Calculate Julian Day of Year SELECT DAYS(CURRENT_TIMESTAMP) - DAYS(SUBSTR( CHAR(DATE(CURRENT_TIMESTAMP),ISO),1,4)||'-01-01') + 1 FROM SYSIBM.SYSDUMMY1 ;











"Smith, Dennis J" @RYCI.COM> on 2000/11/22 04:07:28 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: How to get a Julian date from version 5 [...] 4602 55 43_Re: How to get a Julian date from version 511_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 22 Nov 2000 17:22:03 -0600336_- Dennis: Try this -

DAYS(your_date) + 1721425

Today's (Nov 23rd) Julian day is 2,451,871.

The 1721424 is the days diff between Dec 31st year 0 and Dec 31st year 4712 B.C.

Anyone know what special event took place in 4712 B.C.? Just curious why this was chosen as the base year for Julian_day function. [...] 4658 57 19_Re: Hiperpool Size.12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM31_Wed, 22 Nov 2000 17:46:10 -0600608_- Thanks to all of you for the comments.

regards,

harbry





>From: Joel Goldstein >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Hiperpool Size. >Date: Wed, 22 Nov 2000 09:02:27 -0500 > >Maybe it's semantics, but the way you write itg is not correct. >Pages written out to dasd can then be moved to the HP. >As soon as any page is written to dasd, it can be moved to the HP. >Then if it in the HP when needed, it does not have to be read back from >dasd. >Since pages read back from the sort [...] 4716 66 43_Re: How to get a Julian date from version 514_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 23 Nov 2000 12:35:03 +1100417_iso-8859-1 See http://www.pauahtun.org/CalendarFAQ/cal/calendar23.txt section 2.15. What is the Julian Period?

Basically: - several Christian cyclical periods co-incide every 7980 years - the last time they were all at '1' was in 4713 BC - every year in Christian history has a positive number

The name is claimed to be derived from the name of the father (Julius Caesar Scaliger) of its inventor. [...] 4783 37 36_DB2 V5.1 Alter ROSHARE to NONE Fails14_Michael Vanner21_mvanner@WAVE.HOME.COM31_Wed, 22 Nov 2000 20:41:51 -0500579_iso-8859-1 I have been working on a conversion from DB2 shared read-only to DB2 data sharing. We are a DB2 OS/390 V5.1 with current maintenance (PUT 0005 or better) running on OS/390 V2.6. When we attempt to convert from 'ROSHARE OWNER' to 'ROSHARE NONE' DB2 attempts to perform an idcams ALTER RVOL(*) on the dataset. For some reason the idcams alter fails. The databases are stogroup managed with SMS doing the dataset management. We have reported the problem to IBM and they haven't been able to correct it. We do have a workaround where we can do an alter rvol(*) where [...] 4821 62 23_Re: JDBC 1st use binds?10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 23 Nov 2000 13:32:03 +1000389_ISO-8859-1 Dave,

AS Kurt said, it does seem as if the DB2 connect modules had not been bound to the host subsystem. I am not sure how many are there, but as part of the DB2 connect install process, u bind these into NULLID. (The Db2Connect Users Guide shd have more information). I guess it wd be a onetime process, and u wouldn't need to give BIND authority to all the users. [...] 4884 47 33_Re: SQLColAttibute and data types10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 23 Nov 2000 13:37:23 +1000341_ISO-8859-1 Hi Tiago,

I havent seen any response to this question yet, but I can think of one possibility.

R u using SQL Server ? From what I can remember, in SQL Server, there is no separate Date and Time datatypes. U have a "Datetime" datatype, which contains the date AND time in it. (yyyy-mm-dd hh:mm:ss.milliseconds). [...] 4932 129 25_Re: Authorization problem11_Roland Chua18_rolandchua@SGX.COM31_Thu, 23 Nov 2000 11:49:52 +0800734_us-ascii Did you amended any records in the SYSIBM.IPNAMES, or SYSIBM.LUNAMES or SYSIBM.USERNAMES? Previously, do you do any ID translation?







"Philip, Sibimon" @RYCI.COM> on 20/11/2000 11:20:03 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: Authorization problem



Thanks for all the reply.

1. ID with sysadm is able to do a select with 3 part name. 2. When I granted select access to public at all locations, all the user-ids were able to use the 3 part names based on suggestion from the list. 3. We grant [...] 5062 21 33_DB2 vs IMS performance benchmarks14_C S R Krishnan29_csr_krishna@CHENNAI.TCS.CO.IN31_Thu, 23 Nov 2000 11:32:32 +0530524_us-ascii Hi,

Would like to know if there are any performance benchmarks available (from IBM or otherwise), to compare DB2 and IMS performance on OS/390. Any numbers based on your experiences would also help.

Thanks in advance for all your help.

Regards Krishnan

================================================ 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. 5084 91 0_16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Thu, 23 Nov 2000 11:38:04 +0530504_- Hi Joe, First of all i am not an expert in interpreting the trace output but looking at the literal meaning of the output i can come down to some guesses or may ask you to check some more stuffs.What is the actual number of rows qualified from the query ? Is it 5853 or 5 ? I get a feeling that DB2 was looking at FULLKEYCARD when statistics was full and it was using COLCARDS when it was reverted back to -1(3 of them) .Let us give one more try and have a look at the results.Try maintaining the [...] 5176 15 56_Alexander Frayberg/USA/StateStreet is out of the office.0_25_afrayberg@STATESTREET.COM31_Thu, 23 Nov 2000 02:59:40 -0500389_us-ascii I will be out of the office starting 11/23/2000 and will not return until 11/27/2000.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5192 35 37_Re: DB2 vs IMS performance benchmarks17_Fiorese Giampaolo29_Fiorese.Giampaolo@GENERALI.IT31_Thu, 23 Nov 2000 09:11:27 +0100587_iso-8859-1 Do you want to compare DL1 to DB2, a RECORD oriented DBMS vs a SET ORIENTED DBMS????? Regards Giampaolo

-----Original Message----- From: C S R Krishnan [mailto:csr_krishna@CHENNAI.TCS.CO.IN] Sent: Thursday, November 23, 2000 7:03 AM To: DB2-L@RYCI.COM Subject: DB2 vs IMS performance benchmarks

M Hi,

Would like to know if there are any performance benchmarks available (from IBM or otherwise), to compare DB2 and IMS performance on OS/390. Any numbers based on your experiences would also help. Thanks in advance for all your help. Regards Krishnan [...] 5228 129 43_Re: How to get a Julian date from version 50_18_mebert@AMADEUS.NET31_Thu, 23 Nov 2000 09:23:42 +0100317_us-ascii The Julian_day function manual writers probably didn't take into account that there is no year 0. Btw, there is another type of Julian Day function around: one that simply counts the number of days since (including) Jan. 1st of the year under question. For Nov. 23, 2000 it would return 328 or 2000328. [...] 5358 12 16_it's just a test16_Petteno' Massimo27_Petteno.Massimo@GENERALI.IT31_Thu, 23 Nov 2000 09:29:26 +0100259_- This is a test.

================================================ 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. 5371 73 33_Runstats making your query slower10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Thu, 23 Nov 2000 03:43:07 -0600457_- Joe,

"The access path shown in the PLAN_TABLE was the same before and after the change to the statistics".

Assuming that your query is static embedded SQL using Host Variables, are you using the 'REOPT(VARS)' bind option? If not, then stop reading now. If you are, then try Explaining your query using literals (the same values as those in the HOSTVARS at execution time) both with and without your Catalogue fix, and see what happens. [...] 5445 144 14_Re: RC4 in R1516_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT31_Thu, 23 Nov 2000 10:51:24 +0100627_iso-8859-2 Mike,

the following is an excerpt from an old redbook on LE impementation:

"? RETURN-CODE special register COBOL/MVS (and VS COBOL II) provides a special register called RETURN-CODE that is used to pass a completion code back to the operating system. This register will be set after every COBOL/MVS CALL statement to contain the value returned by the subroutine (non-COBOL/MVS and non-VS COBOL II) in General Register 15. During program termination this value will be passed back to MVS/ESA as a return code. If the value is non-zero this can cause an unexpected completion code or at worse a VSE [...] 5590 32 30_The joys of text extender.....10_Mark Savin31_Mark.Savin@SCOOT-TECHNOLOGY.COM31_Thu, 23 Nov 2000 11:01:49 -0000318_iso-8859-1 Dear list,

We've got (another) problem with Text Extender for DB2 UDB v6.1 on AIX. We're querying a tx-enabled table to see if there are any rows returned when we search for the word 'car' or similar. We have 37 similar words specified in the query. Unfortunately, this gives an error as below: [...] 5623 93 23_Re: JDBC 1st use binds?18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Thu, 23 Nov 2000 05:46:23 -0600366_- Howzit Dave?

As previous respondees have indicated part of the DB2 Connect configuration process is to BIND for the following options depending on your requirements:

1. CLI/ODBC Support 2. Command Line Processor 3. Data Import/Export Utilities 4. Rexx Support

BINDs will need to be done for each clinet version of DB2 you are supporting. [...] 5717 37 47_Need Info on DB2 Vs ORACLE : UNIX and RS/6000 !27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM31_Thu, 23 Nov 2000 17:52:15 +0530455_- Greetings all !

My client needs to get a web based system implemented and right now, we are in the process of advising them for which database to go in for. Although, we are in favour of DB2 we need to come up with an comparison document which compares DB2 with ORACLE and across different platforms such as UNIX, RS/6000 and SUN-SOLARIS . The document should cover key parameters such as scalability, performance, security, web access,etc. [...] 5755 219 27_Re: used vs allocated space14_Langley, Moira30_Moira.Langley@VENDEXKBB-ITS.NL31_Thu, 23 Nov 2000 14:24:57 +0100428_iso-8859-1 I have a Rexx routine which uses the catalog search interface to produce a sequential dataset containing dbname, tsname, allocated space in tracks, and used space in tracks, all based on an input HLQ. Using the CSI avoids any dependence on third party products, and amending the Rexx to include thresholds or a sum function would be easy enough to do. If there's any interest I'll post it to the documents site. [...] 5975 23 11_Archive log10_Robert Ord21_robertord@HOTMAIL.COM31_Thu, 23 Nov 2000 15:02:43 -0000551_- Dear All,



Do anyone know the equivalent UDB (AIX) command for the ARCHIVE LOG command on OS390 ?



Regards

Rob _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.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. 5999 55 15_AW: Archive log12_Harvey,David19_David.Harvey@TUI.DE31_Thu, 23 Nov 2000 16:10:32 +0100505_iso-8859-1 Rob, Not until V7 I believe. In the mean time, when the Instance is stopped, you can rename the log (say) after midnight.

Regards

Dave Harvey

-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]Im Auftrag von Robert Ord Gesendet am: Donnerstag, 23. November 2000 16:03 An: DB2-L@RYCI.COM Betreff: Archive log

Dear All,



Do anyone know the equivalent UDB (AIX) command for the ARCHIVE LOG command on OS390 ? [...] 6055 41 36_Re: ACCESS TO DB2 CONVERSION PROBLEM11_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Thu, 23 Nov 2000 19:13:55 +0000531_us-ascii Senapati,

The field of Yes / No can be achieved by having a character field using a check constraint. I believe there is an example of this in the create table section of the manuals.

I am assuming that AUTO NUMBER in Access is a uniquely generated integer. If so, this is available in V7 - it is called a IDENTITY column. It allows you to specify both the starting number and the interval to be used. At IDUG in Geneva, I think Julian Stuhler did a presentation on Identity columns - albeit for S/390. [...] 6097 44 51_Re: Need Info on DB2 Vs ORACLE : UNIX and RS/6000 !14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 23 Nov 2000 19:59:17 -0500629_ISO-8859-1 Go to www.ylassoc.com

There is a white paper there about Total Cost of Ownership comparing DB2 to Oracle.

Regards, Joel



Message text written by DB2 Data Base Discussion List >My client needs to get a web based system implemented and right now, we are in the process of advising them for which database to go in for. Although, we are in favour of DB2 we need to come up with an comparison document which compares DB2 with ORACLE and across different platforms such as UNIX, RS/6000 and SUN-SOLARIS . The document should cover key parameters such as scalability, performance, security, [...] 6142 32 32_Regarding DB2 dataset Allocation12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM31_Fri, 24 Nov 2000 03:42:31 -0600609_- Hi folks:



I'm just curious about SMS and DB2 datasets allocation. I was running a DSN1COPY to a tablespace and It failed because it couldn't find enough space available in the volume but the dataset was define in SMS (stogroup) as a multivolume with guarantee space. It means this datasets should be able to grow accross differents volumes and indeed it does but only when db2 require an extent (cause insert activity,updates, or Loading data). It seems to me that when db2 require an extent , different components are involved rather than when an extent is requested by program outside [...] 6175 25 27_-911 & DROLLBACK & Batch...32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Fri, 24 Nov 2000 13:59:16 +0200417_- Hello List,

As you may know, in CICS Environment, DB2 Attachment Parameter DROLLBACK may cause automatic rollback with -911 or may not with -913. Let's say that parameter is changed to NO and CICS transactions receive -913 instead of -911. And after that point, rollback of all UOWs depend on the application. it may issue EXEC CICS SYNCPOINT ROLLBACK and DB2 rollbacks or it may retry again and again. [...] 6201 63 31_Re: -911 & DROLLBACK & Batch...11_Suresh Sane21_data_arch@HOTMAIL.COM31_Fri, 24 Nov 2000 08:43:19 -0600365_- Cuneyt,

I don't believe you have such an option in batch/tso/caf. This does not mean you will never get a -913. According to the App Guide, DB2 will attempt to rollback (no choice). If this rollback is successful, it will return a -911 (most common). If rollback is not successful (not sure of situations when this can happen), DB2 will issue a -913. [...] 6265 23 37_Re: DB2 vs IMS performance benchmarks0_17_JTonchick@AOL.COM29_Fri, 24 Nov 2000 10:51:42 EST378_US-ASCII I believe that the IMS Fast Path database has posted the fastest tran/sec benchmarks published by IBM. You might want to checkout the IBM IMS web site page.

http://www-4.ibm.com/software/data/ims

Personally, if I was building an application in today's OS/390 environments, I'd choose IMS/TM as the transaction manager and DB2 as the database server. [...] 6289 27 25_AIX Memory per Connection14_Scott Saunders20_ssaunders@SIEBEL.COM31_Fri, 24 Nov 2000 09:55:56 -0800323_iso-8859-1 Does anyone have a good way to determine how much memory is being utilized by DB2 for a connection to AIX? We have attempted to use VMSTAT to determine how much memory was being used per connection by: - Run VMSTAT with DB2 running and no connections - Re-run VMSTAT with various numbers of users connected [...] 6317 50 89_Re: Why is Fisher-Price knowledge required for OS/390 Certificati on b ut not vice versa?10_Marc Baime14_mbaime@GTE.NET31_Sat, 25 Nov 2000 20:41:40 -0500504_iso-8859-1 I can't speak to why the certification exams are set up the way they are but I can tell you there is no need to put Linux on a box to get a copy of UDB. The developers edition for Windows has been free at IBM's web site for ages and you can also pick up ap 90 day trial on CD for a few dollars that is more than adequate to get you through the fundamentals exam. In fact, I didn't even study for the fundamentals exam and passed it. Your 'amusing' comments about DB2 for Barbie show that [...] 6368 73 36_Links about DB2 for OS390 (11/27/00)6_DB2usa18_db2usa@HOTMAIL.COM31_Mon, 27 Nov 2000 04:58:31 -0600685_ISO-8859-1 Hi,

Here is a non-profit website about DB2 for OS/390 (IBM mainframes):

- English : http://www.db2usa.com - Français: http://www.db2france.com

DB2 for OS/390 poll: Do you use DB2 packages in production ?



Last update on Monday, November 27th 2000 ==========================================

- DB2USA's second year http://db2usa.hypermart.net/eanniversaire.htm DB2USA celebrates its second year online. 400+ links about DB2 for OS/390 available and 50,000+ hits from 48 different countries. French Forum DB2 pour OS/390 started on February 2000 contains 200+ messages written by 50 different users and was accessed 2,500+ times. [...] 6442 41 16_Re: SAP RECOVERY14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Mon, 27 Nov 2000 07:13:46 -0600386_iso-8859-1 I'm on SAP 3.1H DB2 v5 on OS/390 and I use BMC Recovery Manager and Recover Plus for DB2. At the DR site it takes about 1.5 to bring bake DB2 and then 3 to 4 hours to bring back the data.

-----Original Message----- From: Martin Berchtold [mailto:Martin.Berchtold@SYSTEMATICS.DE] Sent: Wednesday, November 22, 2000 2:42 AM To: DB2-L@RYCI.COM Subject: SAP RECOVERY [...] 6484 54 36_Re: Regarding DB2 dataset Allocation16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 27 Nov 2000 08:31:45 -0500500_iso-8859-1 Harbry, Did it fail trying to get the *first* extent or trying to extend? If it failed trying to get the first extent you probably encountered a 'feature' is SMS multi-volume guaranteed space. The primary extent quantity must be available on *all* volumes in the storage group. Ouch.





-----Original Message----- From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] Sent: Friday, November 24, 2000 4:43 AM To: DB2-L@RYCI.COM Subject: Regarding DB2 dataset Allocation [...] 6539 221 16_Re: SAP RECOVERY22_Bertolino, Salvatore S26_SBertolino@MAIL.SBIC.CO.ZA31_Mon, 27 Nov 2000 15:51:39 +0200532_iso-8859-1 I have done tests on 4.0B and DB2 v5 and it took about 3.5 hrs to recover both the catalog and directory as well as the data. This was using the method described in the manuals using the conditional restart of DB2 and recovering to current. This was done using normal DB2 utilities and using the REUSE parameter on the recovery running 5 parallel recovery streams. -----Original Message----- From: Zobjeck, A. J. [mailto:Al_Zobjeck@TTX.COM] Sent: 27 November, 2000 15:14 To: DB2-L@RYCI.COM Subject: Re: SAP RECOVERY [...] 6761 92 89_Re: Why is Fisher-Price knowledge required for OS/390 Certificati on b ut not vice versa?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 27 Nov 2000 07:53:50 -0600368_iso-8859-1 "....Your 'amusing' comments about DB2 for Barbie show that you're a bit out of touch with what is going on in the real world as most DBAs who are working on what you would consider to be a 'Barbie' platform (whether it's DB2, Oracle, SQL Server, or whatever that they're working with) do better than those who work on the aging mainframe platforms. " [...] 6854 104 47_Re: Stored Procedure Builder TSO delete problem11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Mon, 27 Nov 2000 09:12:01 -0500496_iso-8859-1 We have an open APAR with IBM on the delete problem. See PQ43397. There is a manual work-around documented there.

-----Original Message----- From: Ärlebrandt Michael [mailto:Michael.Arlebrandt@VOLVO.COM] Sent: Monday, November 20, 2000 1:18 AM Subject: Re: Stored Procedure Builder V7.1



Hi,

The DDL to create these new tables can be found in DSN610.SDSNSAMP(DSNTIJSG),

you can find the steps to perform in the hold action for PTF UQ39824 (V6). [...] 6959 76 36_Re: Regarding DB2 dataset Allocation13_Davis, Ronald17_DavisRo@CONED.COM31_Mon, 27 Nov 2000 09:26:19 -0500571_- DSN1COPY doesn't allow you to extent a DB2 dataset. Because it runs outside of DB2, DB2 wouldn't know about the new high-allocated RBA if DSN1COPY did extend the dataset. I don't think your problem is SMS related. Redefine the tablespace to place all of the data into one extent if possible. Then run your DSN1COPY. I ran into this problem when trying to automate a production to test download. It worked fine until it needed that extra extent. I got around the problem by using Platinum's Fast Unload to put the data into load format (from an Imagecopy) and then [...] 7036 63 51_Re: Need Info on DB2 Vs ORACLE : UNIX and RS/6000 !19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 27 Nov 2000 08:32:25 -0600653_ISO-8859-1 Deepak, Besides Richard Yevich's excellent white paper, you can find many good hits by searching the db2-l archives on "benchmark".

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, [...] 7100 22 39_IDENTITY DATATYPE AND INCREMENTING BY 117_Rabindra Senapati21_rsenapati@HOTMAIL.COM31_Mon, 27 Nov 2000 08:47:10 -0600442_- Hello Group,

Does any one use IDENTITY datatype in DB2? Could any one give me a example how to use that? I could not able to find in the help on DB2 UDB V7.1 Also. Please let me know if any one use the perticular datatype and How to use.

Rabi.



_____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com [...] 7123 90 36_Re: Regarding DB2 dataset Allocation0_19_Tim.Lowe@STPAUL.COM31_Mon, 27 Nov 2000 09:02:54 -0600658_us-ascii Harbry, When I need to use DSN1COPY to copy to a tablespace that is so large that it must go to additional volumes, I use IDCAMS to alter the tablespace immediately before the DSN1COPY to add additional candidate volumes. For example: ALTER 'hlq.DSNDBD.dbname.tsname.I0001.A001' ADDVOLUMES(*,*) Then, after the DSN1COPY is complete, I use IDCAMS to attempt to remove the candidates, 1 at a time. Something like this: ALTER 'hlq.DSNDBD.dbname.tsname.I0001.A001' REMOVEVOLUMES(*) ALTER 'hlq.DSNDBD.dbname.tsname.I0001.A001' REMOVEVOLUMES(*) Obviously, this is not very "convenient", but it does work. Fortunately, I do not need to do this often. [...] 7214 36 47_CDB Software Mailing Quoting DB2 List Responses13_Keith Gilbert17_kgilbert@CSA1.COM31_Mon, 27 Nov 2000 09:25:53 -0600484_iso-8859-1 This morning I received in the mail a postcard from CDB software. The postcard states....

"People are talking about CDB Software (as seen on the DB2 listserve - www.ryci.com/db2l)"

The card prints 5 quotes from the list. I looked up the most current quotes.

They were from Trace Jones of Reliant Energy and Linda Billings of the State of Wisconsin in response to a question posted by Pat Daniels. No credits were given to the quotes, just a date. [...] 7251 52 51_Re: CDB Software Mailing Quoting DB2 List Responses15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 27 Nov 2000 09:23:48 -0600480_iso-8859-1 They didn't ask me. I think they owe me a t-shirt.

Linda

-----Original Message----- From: Keith Gilbert [mailto:kgilbert@CSA1.COM] Sent: Monday, November 27, 2000 9:26 AM To: DB2-L@RYCI.COM Subject: CDB Software Mailing Quoting DB2 List Responses



This morning I received in the mail a postcard from CDB software. The postcard states....

"People are talking about CDB Software (as seen on the DB2 listserve - www.ryci.com/db2l)" [...] 7304 88 51_Re: CDB Software Mailing Quoting DB2 List Responses11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM31_Mon, 27 Nov 2000 09:34:28 -0600478_us-ascii Well,

They can use all my words as they wish. My words were not bought or fabricated. I believe in the CDB Reorg product. It literally has saved our team hours a month in manual reorgs. It's much faster and safer than IBM reorg so we are able to schedule it and let it choose whether or not a reorg is needed (just a few simple parameters to do this). Also, CDB's help desk, technicians, etc are always responsive, kind, and most importantly knowledgeable. [...] 7393 106 51_Re: CDB Software Mailing Quoting DB2 List Responses15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 27 Nov 2000 09:39:59 -0600433_iso-8859-1 Ditto. Their products are very easy to work with and the tech support staff, especially Gerald and Sam, are a dream to work with, very professional mixed with a little laid-back Texas style.

Linda

-----Original Message----- From: Trace Jones [mailto:Trace_R_Jones@RELIANTENERGY.COM] Sent: Monday, November 27, 2000 9:34 AM To: DB2-L@RYCI.COM Subject: Re: CDB Software Mailing Quoting DB2 List Responses [...] 7500 82 51_Re: CDB Software Mailing Quoting DB2 List Responses0_19_Tim.Lowe@STPAUL.COM31_Mon, 27 Nov 2000 09:43:42 -0600359_us-ascii Keith, Personally, I would like to have seen any quoted statements attributed to the original author, not just to the DB2 list. (otherwise, someone could send in comments to the list, and then quote themselves!) However, I think everything on the list is public, so I think that they can do whatever they like. But, I am certainly NOT a lawyer! [...] 7583 69 51_Re: CDB Software Mailing Quoting DB2 List Responses12_Michael Deer20_Michael.Deer@UAL.COM31_Mon, 27 Nov 2000 09:50:41 -0600532_- My expectation is that when I send/publish a message via internet email (a listserver in this case), I and only I own the copyright to my own words. This is consistent with common practices among internet listservers and more importantly is consistent with federal copyright law. In my opinion, copyrights to all listserv messages are owned by the respective authors. It is also my opinion that CDB should have procured releases/licenses from each individual sender of each message reproduced in CDB's promotional materials. [...] 7653 15 51_Re: CDB Software Mailing Quoting DB2 List Responses0_18_DB2DBAinTX@AOL.COM29_Mon, 27 Nov 2000 10:50:52 EST442_US-ASCII I think CDB Software should take each customer quoted on the postcard out on the town and give them a T-Shirt for publishing the quotes without getting the permission first. Just my thoughts.

================================================ 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. 7669 101 51_AW: CDB Software Mailing Quoting DB2 List Responses12_Harvey,David19_David.Harvey@TUI.DE31_Mon, 27 Nov 2000 16:58:43 +0100685_iso-8859-1 CDB - great stuff, used it for years.

Feel free to quote me.

Dave Harvey (Size 40)

-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]Im Auftrag von Michael Deer Gesendet am: Montag, 27. November 2000 16:51 An: DB2-L@RYCI.COM Betreff: Re: CDB Software Mailing Quoting DB2 List Responses

My expectation is that when I send/publish a message via internet email (a listserver in this case), I and only I own the copyright to my own words. This is consistent with common practices among internet listservers and more importantly is consistent with federal copyright law. In my opinion, copyrights to all [...] 7771 98 51_Re: CDB Software Mailing Quoting DB2 List Responses14_Scott Trometer22_scott.trometer@RCI.COM31_Mon, 27 Nov 2000 11:17:07 -0500524_iso-8859-1 I agree!

I would think that using one's name, likeness, or even thoughts for that matter, to sell product without permission or some agreed upon commission / compensation, has got to be illegal in the U.S.

Just because someone was in public when it was said, thought, etc. does not provide another the right to use it without permission, especially when the object is to financially benefit from the quote, likeness, etc...unless it is documented in the fine print of this server registration. [...] 7870 54 43_Re: IDENTITY DATATYPE AND INCREMENTING BY 112_Cook, Nicole19_Nicole_Cook@BMC.COM31_Mon, 27 Nov 2000 10:25:46 -0600546_iso-8859-1 I'm assuming you are on a UNIX/LINUX/NT or other non-mainframe platform.



CREATE TABLE mytable (col1 INT, col2 DOUBLE, col3 INT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 100,INCREMENT BY 5));

I hope this helps,

Nicole



Nicole Cook bmcsoftware 512-340-6817 800-841-2031 ncook@bmc.com

-----Original Message----- From: Rabindra Senapati [mailto:rsenapati@HOTMAIL.COM] Sent: Monday, November 27, 2000 8:47 AM To: DB2-L@RYCI.COM Subject: IDENTITY DATATYPE AND INCREMENTING BY 1 [...] 7925 131 51_Re: CDB Software Mailing Quoting DB2 List Responses0_19_mike.holmans@BT.COM31_Mon, 27 Nov 2000 16:25:25 -0000322_iso-8859-1 For those who are going on about what US law may or may not state, it may be worth pointing out the The World Is A Very Big Place, and US law is not in force everywhere where messages from this mailing list - which also appears as a Usenet group even if you can't post using NNTP - can be read or written. [...] 8057 125 51_Re: CDB Software Mailing Quoting DB2 List Responses16_Craig Snoeyenbos27_CSnoeyenbos@STATESTREET.COM31_Mon, 27 Nov 2000 11:30:48 -0500367_us-ascii You may own the copyright to your e-mail, but by posting to a public listserv with an archive, you would seem to be implicitly licensing the world to read it. It would seem a distinction without difference for CDB to quote someone as opposed to providing a pointer to the archive. (Not a lawyer but my understanding of how the world works in practice.) [...] 8183 152 51_Re: CDB Software Mailing Quoting DB2 List Responses18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Mon, 27 Nov 2000 11:42:12 -0500672_iso-8859-1 Ok, I give up, "what is a Merkin"??

Steve Whittaker DB2/DBA Carolina Power & Light Mail stop:OHS 4 - Raleigh Email: stephen.whittaker@cplc.com Phone: (919) 546-7267



-----Original Message----- From: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] Sent: Monday, November 27, 2000 11:25 AM To: DB2-L@RYCI.COM Subject: Re: CDB Software Mailing Quoting DB2 List Responses



For those who are going on about what US law may or may not state, it may be worth pointing out the The World Is A Very Big Place, and US law is not in force everywhere where messages from this mailing list - which also appears as a Usenet group even [...] 8336 170 51_Re: CDB Software Mailing Quoting DB2 List Responses21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Mon, 27 Nov 2000 11:54:07 -0500499_iso-8859-1 Maybe that should be `Merkins.

Jim



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Whittaker, Stephen Sent: Monday, November 27, 2000 11:42 AM To: DB2-L@RYCI.COM Subject: Re: CDB Software Mailing Quoting DB2 List Responses



Ok, I give up, "what is a Merkin"??

Steve Whittaker DB2/DBA Carolina Power & Light Mail stop:OHS 4 - Raleigh Email: stephen.whittaker@cplc.com Phone: (919) 546-7267 [...] 8507 181 51_Re: CDB Software Mailing Quoting DB2 List Responses9_Cam White20_cwhite@REVEALNET.COM31_Mon, 27 Nov 2000 11:56:54 -0500670_iso-8859-1 People from the "United States of 'Merka"

Cam White

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Whittaker, Stephen > Sent: Monday, November 27, 2000 11:42 AM > To: DB2-L@RYCI.COM > Subject: Re: CDB Software Mailing Quoting DB2 List Responses > > > Ok, I give up, "what is a Merkin"?? > > Steve Whittaker > DB2/DBA Carolina Power & Light > Mail stop:OHS 4 - Raleigh > Email: stephen.whittaker@cplc.com > Phone: (919) 546-7267 > > > -----Original Message----- > From: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] > Sent: Monday, November 27, 2000 11:25 AM > To: DB2-L@RYCI.COM [...] 8689 76 40_FW: CDB Software Mailing Quoting DB2 Lis14_Jennifer Moody22_jmoody@CDBSOFTWARE.COM31_Mon, 27 Nov 2000 10:52:20 -0600461_ISO-8859-1 I'd be happy to send a free t-shirt to anyone on the listserve who would like one. Email your contact info (name, company name, address, phone) to jmoody@cdbsoftware.com and I will send it immediately.

Jennifer Moody Marketing Coordinator CDB Software, Inc.

-----Original Message----- From: linda.billings@DOA.STATE.WI.US Sent: Monday, November 27, 2000 9:36 AM To: DB2-L@RYCI.COM Subject: Re: CDB Software Mailing Quoting DB2 Lis [...] 8766 30 34_stop/start database in batch mode.13_Karen Daniels23_karenhdaniels@YAHOO.COM31_Mon, 27 Nov 2000 08:55:33 -0800546_us-ascii I have a requirement to stop a database/tablespace in batch mode. I have researched DSNTIAD/DSNTEP2 and they don't appear to handle this command. Does anyone know of a way I can accomplish this in batch.

TIA

===== Karen Daniels Database Administrator TRW S&ITG

Office Telephone: (334) 242-3784 Email: karenhdaniels@yahoo.com or karen.daniels@trw.com

__________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ [...] 8797 57 38_Re: stop/start database in batch mode.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 27 Nov 2000 12:03:38 -0500446_iso-8859-1 Try: //STOP EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(????) -STOP DB(????????) SPACE(????????) END /* regards, Eric Pearson NS ITO Database Support



-----Original Message----- From: Karen Daniels [mailto:karenhdaniels@YAHOO.COM] Sent: Monday, November 27, 2000 11:56 AM To: DB2-L@RYCI.COM Subject: stop/start database in batch mode. [...] 8855 44 38_Re: stop/start database in batch mode.13_Toppins, Mike19_MToppins@UNIPAC.COM31_Mon, 27 Nov 2000 10:09:40 -0700480_iso-8859-1 A Batch TSO job using the DSN command will do the job.

-----Original Message----- From: Karen Daniels [mailto:karenhdaniels@YAHOO.COM] Sent: Monday, November 27, 2000 9:56 AM To: DB2-L@RYCI.COM Subject: stop/start database in batch mode.



I have a requirement to stop a database/tablespace in batch mode. I have researched DSNTIAD/DSNTEP2 and they don't appear to handle this command. Does anyone know of a way I can accomplish this in batch. [...] 8900 180 51_Re: CDB Software Mailing Quoting DB2 List Responses0_19_mike.holmans@BT.COM31_Mon, 27 Nov 2000 16:49:51 -0000694_iso-8859-1 Try pronouncing "American" with an "American" accent.

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: Whittaker, Stephen [SMTP:stephen.whittaker@CPLC.COM] > Sent: Monday, November 27, 2000 4:42 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] CDB Software Mailing Quoting DB2 List Responses > > Ok, I give up, "what is a Merkin"?? > > Steve Whittaker > DB2/DBA Carolina Power & Light > Mail stop:OHS 4 - Raleigh > Email: stephen.whittaker@cplc.com > Phone: (919) 546-7267 > > > -----Original Message----- [...] 9081 115 38_Re: stop/start database in batch mode.0_18_mebert@AMADEUS.NET31_Mon, 27 Nov 2000 18:12:28 +0100518_us-ascii Yep:

//*------- Stop the Tablespace ----------------------------------------- //STOP EXEC PGM=IKJEFT1B //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(ssid) -STO DB(dbname) SPACE(tsname/ixspacename) [ PART( nnn) ]



Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany







From: Karen Daniels on 27/11/2000 16:55 GMT

Please respond to DB2 Data Base Discussion List [...] 9197 28 51_Re: CDB Software Mailing Quoting DB2 List Responses15_Melvin Demmicks25_melvin_demmicks@YAHOO.COM31_Mon, 27 Nov 2000 09:13:30 -0800325_us-ascii >For those who are going on about what US law may or may not state, it may be >worth pointing out the The World Is A Very Big Place, and US law is not in >force everywhere where messages from this mailing list

I agree with Mike. For example, it's obvious US law is not enforced in the republic of Texas. [...] 9226 45 38_Re: stop/start database in batch mode.14_Dean Montevago18_DMonteva@VNSNY.ORG31_Mon, 27 Nov 2000 12:13:40 -0500612_- Karen, Use propgram IKJEFT01 and pass the commands vis the SYSTSIN DD prefixed with the subsystem command recognition character. Dean > -----Original Message----- > From: Karen Daniels [SMTP:karenhdaniels@YAHOO.COM] > Sent: Monday, November 27, 2000 11:56 AM > To: DB2-L@RYCI.COM > Subject: stop/start database in batch mode. > > I have a requirement to stop a database/tablespace in > batch mode. I have researched DSNTIAD/DSNTEP2 and > they don't appear to handle this command. Does anyone > know of a way I can accomplish this in batch. > > TIA > > ===== > Karen Daniels > Database Administrator > TRW [...] 9272 22 38_Re: stop/start database in batch mode.15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM31_Mon, 27 Nov 2000 11:11:33 -0600474_us-ascii Try something like this:



//STARTDB EXEC PGM=IKJEFT01 //STEPLIB DD DSN=MPSYS1.DB2.SAP.DSNLOAD,DISP=SHR //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM (DB2X) -START DATABASE(DSNDB06) SPACENAM(DSNKKX01) END /*

================================================ 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. 9295 63 38_Re: stop/start database in batch mode.12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 27 Nov 2000 19:18:45 +0200564_iso-8859-1 Hi,

//CMD EXEC PGM=IKJEFT1B //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN S(ssid) <== put your ssid here (eg: DB2T ....) -stop db(xxxxxxxxx) space(xxxxxxxxxx) END //* Isaac Yassin DBMS & IT Consultant

Email: yassin@netvision.net.il

Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Karen Daniels" Newsgroups: bit.listserv.db2-l To: Sent: Monday, November 27, 2000 6:55 PM Subject: stop/start database in batch mode. [...] 9359 53 38_Re: stop/start database in batch mode.14_Stevens, Wayne21_Wayne_Stevens@BMC.COM31_Mon, 27 Nov 2000 11:18:11 -0600607_iso-8859-1 You can do it with the IKJEFT01/IKJEFT1B program with the parms in the DDNAME SYSTSIN

ie DSN SYSTEM (DB2P) -STOP DATABASE(DBNAME) END

Wayne Stevens BMC Software, Inc.

-----Original Message----- From: Karen Daniels [mailto:karenhdaniels@YAHOO.COM] Sent: Monday, November 27, 2000 10:56 AM To: DB2-L@RYCI.COM Subject: stop/start database in batch mode.



I have a requirement to stop a database/tablespace in batch mode. I have researched DSNTIAD/DSNTEP2 and they don't appear to handle this command. Does anyone know of a way I can accomplish this in batch. [...] 9413 80 38_Re: stop/start database in batch mode.16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Mon, 27 Nov 2000 12:17:18 -0500727_us-ascii Karen,

Here you go:



//JOBCARD JOB ('xxx'),'NAME', // REGION=0M,NOTIFY=&SYSUID,CLASS=D,MSGCLASS=X //* //********************************************************************* //* STOP SPACE //********************************************************************* //* //STEP010 EXEC PGM=IKJEFT01,DYNAMNBR=25,REGION=0M //* //STEPLIB DD DSN=DB2.DSNEXIT,DISP=SHR // DD DSN=DB2.DSNLOAD,DISP=SHR //SYSPRINT DD SYSOUT=* //SYSTERM DD SYSOUT=* //SYSTSPRT DD SYSOUT=* //UTLSUSO8 DD SYSOUT=* //UTLSUSO9 DD SYSOUT=* //SYSOUT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSIN DD DUMMY //SYSTSIN DD * DSN SYSTEM(DB2) -STOP DB(DBNAME) SPACE(IXorTBSC) PART (20) -START DB(DBNAME) SPACE(IXorTBSC) PART (20) END /* //* [...] 9494 50 51_Re: CDB Software Mailing Quoting DB2 List Responses13_Morrill, John12_JohnM@VP.NET31_Mon, 27 Nov 2000 10:20:50 -0700428_iso-8859-1 Greetings!

Warning! We are going were the DB2-L charter does not allows us to go. Please, no political or other off topic posts.

Cheers! J. Michael Morrill DB2-L Chief Listowner



-----Original Message----- From: Melvin Demmicks [mailto:melvin_demmicks@YAHOO.COM] Sent: Monday, November 27, 2000 10:14 AM To: DB2-L@RYCI.COM Subject: Re: CDB Software Mailing Quoting DB2 List Responses [...] 9545 99 44_Re: FW: CDB Software Mailing Quoting DB2 Lis12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 27 Nov 2000 19:21:44 +0200499_iso-8859-1 Hi, Getting those quotes and printing them like that without a written prior permission is a matter for lawyers...

Isaac Yassin DBMS & IT Consultant

Email: yassin@netvision.net.il

Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Jennifer Moody" Newsgroups: bit.listserv.db2-l To: Sent: Monday, November 27, 2000 6:52 PM Subject: FW: CDB Software Mailing Quoting DB2 Lis [...] 9645 15 51_Re: CDB Software Mailing Quoting DB2 List Responses11_Pat Daniels20_patd0327@HOTMAIL.COM31_Mon, 27 Nov 2000 11:20:34 -0600485_- You can quote me anytime, after all the listserve is public domain. Pat Daniels _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.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. 9661 93 43_Re: IDENTITY DATATYPE AND INCREMENTING BY 112_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 27 Nov 2000 19:28:48 +0200427_iso-8859-1 Hi, It works fine on OS/390 DB2 V6.1 with the correct ptf's. (V6 APAR PQ30652) The data type of an identity column can be INTEGER, SMALLINT, or DECIMAL with a scale of 0. GENERATED ALWAYS means DB2 generates it for you and is responsible for unique values, GENERATED BY DEFAULT means you are resposible to insure unique values There are more to it - look at the manual (or the hold data that goes with the ptf) [...] 9755 68 51_Re: CDB Software Mailing Quoting DB2 List Responses14_Scott Trometer22_scott.trometer@RCI.COM31_Mon, 27 Nov 2000 12:34:08 -0500651_iso-8859-1 Ok...I was going leave my comments stand as said...however...

To the Non-Merks,

Yes the world is a big place...with planes, tranes, automobiles...faxes, email, and telephones...and a whole bunch more technical stuff that makes communication across the big pond quite convenient.

So, it really doesn't matter where the 'company' is, if it steals my thoughts,quotes,likeness, etc. for profit...and indeed it is 'illeagal' in the US. I, as a US citizen, have options to hold that company accountable... both in the US and possibly in the country that hosts that company, if it is lawfully applicable in that country. [...] 9824 39 32_Create procedure (sql procedure)11_Tom Marcano23_marcano_db2@HOTMAIL.COM31_Mon, 27 Nov 2000 17:35:23 -0000683_- Hello Everybody,

I'm trying to get any help regarding a SQL procedure. I created and compiled my SQL procedure:

CREATE PROCEDURE owner.CARDINFO (IN ORD_NO_VAR CHAR(9), IN USERDATA_FLD14_VAR CHAR(29)) LANGUAGE SQL COLLID bindcard RESULT SETS 1 WLM ENVIRONMENT wlmcard MODIFIES SQL DATA UPDATE owner.CREDIT_INFO_B SET USERDATA_FLD14 = USERDA_FLD14_VAR WHERE ORD_NO = ORD_NO_VAR

Everything looks good at this point, except my sysibm.sysroutines because doesn't have any entry for it. I believed that DB2 created this entry when I compiled and linked my sql procedure so Am I supposed to execute the same DDL using spufi or something like that to create this [...] 9864 63 73_From the List Owners Re: CDB Software Mailing Quoting DB2 List Re sponses13_Morrill, John12_JohnM@VP.NET31_Mon, 27 Nov 2000 10:55:56 -0700407_iso-8859-1 Greetings!

I am not an attorney, but through out the years I have consulted attorneys about copyright law, although I have not consulted an attorney about this particular case.

Copyright laws do vary from county to county, but there are several treaties between counties that prevent someone publishing the work of an author in another country without compensating the author. [...] 9928 50 57_Error Connecting to Database on Local Node (UDB v6.1/AIX)0_22_BILL_GALLAGHER@PHL.COM31_Mon, 27 Nov 2000 13:56:44 -0500520_us-ascii Hi,

I've experiencing a problem trying to set up and connect to a database on another instance on the same AIX box using UDB v6.1. I've been able to do this on other AIX boxes in our shop, but for some reason, I'm getting an error on this particular box.

Some background: We're running UDB v6.1 (Fixpack 5) on AIX 4.3.3. We have multiple UDB instances running on this box. One is running WebSphere (instance name "db2was"), and the other is running a user database (instance name "db2ccom"). [...] 9979 71 61_Re: Error Connecting to Database on Local Node (UDB v6.1/AIX)13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Mon, 27 Nov 2000 14:04:29 -0500456_iso-8859-1 Bill, You're probably aware of this but have you issued the db2start command twice, with the DB2INSTANCE environment variable being set properly for each execution? In the example you gave, it looks like the db2was instance has not been started. By logging on with the db2was id, the DB2INSTANCE variable should be set correctly, but you might check it by issuing the SET command, which displays all environment variables. Hope this helps. [...] 10051 45 51_DB2 stored procedure error message to Client/Server15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 27 Nov 2000 15:49:32 -0500574_iso-8859-1 I had posted some questions regarding calling stored procedure from Powerbuilder. With the help of people from this group we are able to call now. This message is regarding the error handling.

From stored procedure in COBOL, how do we pass a error message to 4 GL language in the client/server. Even though I got some solutions from this list (Such as extra columns in the result set), none of them was straight. Since we are using Grandvu ODBC driver, we are planning to tell them to modify the ODBC driver. If there is a error in COBOL procedure we [...] 10097 18 27_Re: used vs allocated space7_DB2 fan16_askdb2@YAHOO.COM31_Mon, 27 Nov 2000 14:44:06 -0600473_- Yes, Using IGGCSIRX is by far the best available tool to query catalog. I use a REXX call to IGGCSIRX to get the extent, volumes, and allocated space information and to trigger REORGs. For anybody who is interested in wrting their own call please look at the book DGT1C105 at IBM bookserver. It is fairly simple and straightforward. there is also a document that illustrates the usage of this interface along with a SAS program in the DB2L documents section. Db2fan [...] 10116 116 61_Re: Error Connecting to Database on Local Node (UDB v6.1/AIX)11_Phil Castle20_phil@ECNETWORK.CO.NZ31_Tue, 28 Nov 2000 09:57:27 +1300496_iso-8859-1 I agree with the previous post. The SQL2032N message states quite unambiguously what the problem is (DB2 instance not started).

One trap, which fools me all the time despite the fact that I know about it, is the db2 backend process. This keeps you attached to an instance even after you have disconnected from the database, or changed the DB2INSTANCE variable. If you are switching between instances, you must do a "db2 terminate" before attaching to the new instance. Eg. [...] 10233 167 61_Re: Error Connecting to Database on Local Node (UDB v6.1/AIX)0_22_BILL_GALLAGHER@PHL.COM31_Mon, 27 Nov 2000 16:08:07 -0500572_us-ascii Phil and Jim,

Thanks for the suggestions, but unfortunately this is not the case. Because I've been bitten too many times by the "trap" of which instance am I REALLY connected to, I usually log on as the instance owner whenever I'm doing any work against a particular instance. So I logged onto both db2ccom and db2was, issued the "db2start" command for each one, and in both cases received the "SQL1026N The database manager is already active" message. Yet I still get the SQL2032N message when I try to connect to the custcare database from db2was. [...] 10401 25 19_BD2 VSE INFORMATION17_Rabindra Senapati21_rsenapati@HOTMAIL.COM31_Mon, 27 Nov 2000 15:06:34 -0600327_- Hello Friends,

Does any one know the same kind of ListServer Available for DB2 VSE or for VSE platform? If yes, Please let me know the web site information where i could clear some of the DB2 VSE related doubts. Is DB2 VSE is popular in the market now or getting absolute. Any further information is appreciable. [...] 10427 14 27_Re: used vs allocated space7_DB2 fan16_askdb2@YAHOO.COM31_Mon, 27 Nov 2000 15:19:21 -0600457_- I forgot to add these lines. you may also find a sample REXX in SYS1.SAMPLIB. This can be changed to suit your needs. Basicvally you add the CSI fields that you want and increment the CSINUMEN accordingly. DB2 fan

================================================ 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. 10442 195 61_Re: Error Connecting to Database on Local Node (UDB v6.1/AIX)11_Phil Castle20_phil@ECNETWORK.CO.NZ31_Tue, 28 Nov 2000 10:29:49 +1300402_iso-8859-1 when you log onto the instance owner, do you "su" or "su -"? It seems to me that you are not connected to the instance you think you are - which also explains the "SQL1026N The database manager is already active" when you are are trying to start up the new instance. Thats why I always use "db2 get instance" as a way of checking the instance name - you should do this just to be sure. [...] 10638 18 61_Re: Error Connecting to Database on Local Node (UDB v6.1/AIX)18_Gert van der Kooij15_geko@WANADOO.NL31_Mon, 27 Nov 2000 22:30:11 +0100426_iso-8859-1 Hi Bill,

Just a guess, maybe you made a typo when cataloging the instance? To be sure, check with 'list node directory' on the db2was instance.

Hope this helps

================================================ 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. 10657 30 61_Re: Error Connecting to Database on Local Node (UDB v6.1/AIX)11_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Mon, 27 Nov 2000 21:47:15 +0000625_us-ascii Bill,

Another good way to see what you can do is to try and attach to the instance. It might be that your instance is catalogued OK, but not your database.

Jeremy



Gert van der Kooij wrote:

> Hi Bill, > > Just a guess, maybe you made a typo when cataloging the instance? > To be sure, check with 'list node directory' on the db2was instance. > > Hope this helps > > ================================================ > 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 [...] 10688 131 44_Re: FW: CDB Software Mailing Quoting DB2 Lis15_Toine Michielse18_vndobtm@US.IBM.COM31_Mon, 27 Nov 2000 22:36:44 +0000393_us-ascii O please...... No lawyers or I'll shut up forever.. The next thing you know someone will hold me accountable for an opinion I expressed on this forum. Let's just get back to the 'easy living' without too much legal hassles, sueing and what have you.

If someone quotes an individual's expression on the forum then so be it... If you can't take it, don't post your opinion. [...] 10820 56 23_Re: BD2 VSE INFORMATION24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Mon, 27 Nov 2000 16:44:18 -0800772_us-ascii Rabindra,

Websites: http://www.software.ibm.com/data/db2/vse-vm http://www.thefillmoregroup.com Choose "Public classes"

There used to be a listserv at sqlinfo@listserv.uic.edu, but it's dormant.

Frank



On Mon, 27 Nov 2000 15:06:34 -0600, Rabindra Senapati wrote:

>Hello Friends, > >Does any one know the same kind of ListServer Available for DB2 VSE or for >VSE platform? If yes, Please let me know the web site information where i >could clear some of the DB2 VSE related doubts. Is DB2 VSE is popular in the >market now or getting absolute. Any further information is appreciable. > >Rabi. > > > > >_____________________________________________________________________________________ >Get more from the Web. FREE [...] 10877 44 77_Re: From the List Owners Re: CDB Software Mailing Quoting DB2 List Re sponses0_24_John_McComb@VANGUARD.COM31_Mon, 27 Nov 2000 16:44:12 -0500363_us-ascii I also am not a lawyer, but I have a couple of comments

>Also, thereis the issue of 'fair use' in copyright law, which provides for the >quoting of copyrighted work.

The issue of "Fair Use" is intended for quoting parts of a copyrighted work in reviews, journals, etc. and I don't believe it applies to the commercial use of the work. [...] 10922 30 12_memo columns12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Mon, 27 Nov 2000 15:54:11 -0600543_iso-8859-1 We have a request to modify one of our tables to include a "memo" type column. Right now the table has a column designating supplement and sequence number so that the table can have up to 99 supplements and up to 99 lines per supplement with 70 characters in each line. They would like to get rid of this and have one "memo" column. We are DB2/OS390 v.5. Do future versions of DB2/OS390 have a data type that can handle this large of a text column? If yes, would someone please share the max size, name, etc. Also any warnings [...] 10953 28 3_CDB13_Lockwood Lyon19_Lockwool@MEIJER.COM31_Mon, 27 Nov 2000 16:52:45 -0500375_US-ASCII I have an opinion as well.

See Disclaimer.

- - LL



Lockwood Lyon -- Meijer Technical Support (616) 735-7553 (office) (616) 791-5131 (fax)

Copyright (c) 2000 by Lockwood Lyon. All rights reserved. "These opinions are mine and not necessarily those of my employer, Meijer, Inc."

=============================================== 10982 78 78_Re: From the List Owners Re: CDB Software Mailing Quoting DB2 Lis t Re sponses13_Davis, Ronald17_DavisRo@CONED.COM31_Mon, 27 Nov 2000 17:06:30 -0500482_- How do I sign up for this 'BUZZ' thing? And, how much does it pay?

-----Original Message----- From: Morrill, John [SMTP:JohnM@VP.NET] Sent: Monday, November 27, 2000 12:56 PM To: DB2-L@RYCI.COM Subject: From the List Owners Re: CDB Software Mailing Quoting DB2 List Re sponses

Greetings!

I am not an attorney, but through out the years I have consulted attorneys about copyright law, although I have not consulted an attorney about this particular case. [...] 11061 76 36_Re: Create procedure (sql procedure)8_LAM, Leo17_l.lam@IOOF.COM.AU31_Tue, 28 Nov 2000 09:04:37 +1000475_iso-8859-1 Tom,

If you're using JCL, the job should have a step to execute the DDLs generated in pre-compilation to create the sysroutines entry (see DSNTEJ63 sample).

If you're using the Stored Procedure Builder, are you getting a RC 4 during pre-compilation ?

Leo

-----Original Message----- From: Tom Marcano [mailto:marcano_db2@HOTMAIL.COM] Sent: Tuesday, 28 November 2000 3:35 To: DB2-L@RYCI.COM Subject: Create procedure (sql procedure) [...] 11138 36 16_Re: memo columns0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 27 Nov 2000 16:33:19 -0600634_us-ascii Have you looked at VARCHAR data type, max 4046 char in 4kb data pages and 32,704 char in a 32kb data page.









"Reid, Louise" @RYCI.COM> on 2000/11/27 03:54:11 PM

To: DB2-L@RYCI.COM Subject: memo columns

We have a request to modify one of our tables to include a "memo" type column. Right now the table has a column designating supplement and sequence number so that the table can have up to 99 supplements and up to 99 lines per supplement with 70 characters in each line. They would like to get rid of this and have one "memo" column. We are [...] 11175 51 16_Re: memo columns13_Morrill, John12_JohnM@VP.NET31_Mon, 27 Nov 2000 16:59:30 -0700639_- Greetings!

V.6 introduces a LOB data type (Large Binary Object). There is a sub-type called CLOB (Character Large Binary Object). These data types can be up to 2G in size. However, there are restrictions.

You can find the V6 library at http://www-4.ibm.com/software/data/db2/os390/v6books.html

You can find more information on LOB's at http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/BOOKS/DSNSQ0G2/3%2e8%2e4?SHE LF=

Cheers!

John





P.S You may also want to read about text extenders at: http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/BOOKS/DESU6002/CCONTENTS?SHE LF=DSNSH0G3 [...] 11227 127 44_Re: Data compression using DSN8HUFF editproc14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Mon, 27 Nov 2000 15:58:48 -0800377_iso-8859-1 Another thing to consider before using an editproc (any editproc, not just DSN8HUFF) is that once a table has an editproc you can no longer use the ALTER TABLE to add columns to the table, or use the ATLER TABLE COLUMN statement against the table. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 11355 49 23_Re: BD2 VSE INFORMATION13_Morrill, John12_JohnM@VP.NET31_Mon, 27 Nov 2000 17:06:13 -0700749_- Greetings!

Check out news://news.software.ibm.com/ibm.software.db2.vse-vm

If clicking on this link does not get you to the news group then on your news reader connect to server news.software.ibm.com

Then find newsgroup ibm.software.db2.vse-vm

Cheers!

John

-----Original Message----- From: Rabindra Senapati [mailto:rsenapati@HOTMAIL.COM] Sent: Monday, November 27, 2000 2:07 PM To: DB2-L@RYCI.COM Subject: BD2 VSE INFORMATION



Hello Friends,

Does any one know the same kind of ListServer Available for DB2 VSE or for VSE platform? If yes, Please let me know the web site information where i could clear some of the DB2 VSE related doubts. Is DB2 VSE is popular in the market now [...] 11405 76 16_Re: memo columns16_Peter Lehmensich27_peter.lehmensich@HIC.GOV.AU31_Tue, 28 Nov 2000 11:42:19 +1100729_us-ascii V6 introduces CLOBs, character large objects ..... can store up to 2 GB of single byte character data.

Peter







"Reid, Louise" @RYCI.COM> on 28/11/2000 08:54:11

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: memo columns



We have a request to modify one of our tables to include a "memo" type column. Right now the table has a column designating supplement and sequence number so that the table can have up to 99 supplements and up to 99 lines per supplement with 70 characters in each line. They [...] 11482 27 17_VALIDPROC example12_Marcus Green18_mgreen@AAPT.COM.AU31_Tue, 28 Nov 2000 12:13:55 +1100385_US-ASCII Hi,

I'm trying to find out as much as I can about VALIDPROCs and EDITPROCs. I believe I have some requirements for both.

Does anyone have an example program they could send to me to give me a starting point on either. (preferably in Cobol?).

I've been looking through the DB2 manuals, and have found quite a bit of useful info, but no real examples. [...] 11510 40 29_Some Change Manager questions15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 28 Nov 2000 12:58:05 +1100596_- I've got two questions for those of you with BMC's Change Manager, both to do with migrating databases:

1) Can you change the order in which objects are generated? 2) Can you generate Bind Plan statements only, without the Bind Package statements?

For 1) above I'd like CM to generate the Create Alias statements after it's generated all the Create Table and Create View statements. When running the workid you get +403's for the Create Alias statements, saying the object the alias refers to hasn't been created yet. It's OK in that the objects will be created later in the [...] 11551 42 40_Re: CDB Software Mailing Quoting DB2 Lis16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Tue, 28 Nov 2000 09:57:52 +0530650_- Name - Sanjeev Company Name - CTS Address - SA-333, Sakchi Supervisors Flat, Sakchi, Jamshedpur, India. PIN-831001 Phone - 91-33-3573211 Extn-1420 (Work) .

Regards Sanjeev

> -----Original Message----- > From: Jennifer Moody [SMTP:jmoody@CDBSOFTWARE.COM] > Sent: Monday, November 27, 2000 10:22 PM > To: DB2-L@RYCI.COM > Subject: FW: CDB Software Mailing Quoting DB2 Lis > > I'd be happy to send a free t-shirt to anyone on the listserve who would > like one. Email your contact info (name, company name, address, phone) to > jmoody@cdbsoftware.com and I will send it immediately. > > Jennifer Moody > Marketing Coordinator > CDB [...] 11594 75 33_Re: Some Change Manager questions14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 28 Nov 2000 15:35:04 +1100553_iso-8859-1 The way we do 1) is to use an edit macro - although in our case its to put unloads/loads into the same sequence as the (tape) image copies we'll be using as the data source. You could use this to do 2) as well.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Tuesday, November 28, 2000 12:58 PM To: DB2-L@RYCI.COM Subject: [DB2-L] Some Change Manager questions [...] 11670 57 40_Re: CDB Software Mailing Quoting DB2 Lis16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Mon, 27 Nov 2000 23:40:41 -0500592_- My opologies : Sorry to post this to list.But i believe Jennifer can have a look at this as well.

Again "My Opinion that i need a T-Shirt"

Regards' Sanjeev

> -----Original Message----- > From: S, Sanjeev (CTS) > Sent: Tuesday, November 28, 2000 9:56 AM > To: 'DB2 Data Base Discussion List' > Subject: RE: CDB Software Mailing Quoting DB2 Lis > > Name - Sanjeev > Company Name - CTS > Address - SA-333, Sakchi Supervisors Flat, Sakchi, Jamshedpur, India. > PIN-831001 > Phone - 91-33-3573211 Extn-1420 (Work) . > > Regards > Sanjeev > > -----Original Message----- [...] 11728 69 38_Re: stop/start database in batch mode.16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Tue, 28 Nov 2000 10:15:49 +0530636_- DSNTIAD and DSNTEP2 are strictly the programs which contains dynamic sqls and DB2 Commands are not the dynamic sqls.It needs DSN prompt to run.So JCL you use to run your cobol-DB2 program just write the DB2 commands in place of RUN PROGRAM(*) PLAN(*)

HTH

Regards Sanjeev



> Karen Daniels on 11/27/2000 11:55:33 AM > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: (bcc: RICHARD E MOLERA/SallieMae) > Subject: stop/start database in batch mode. > > > > I have a requirement to stop a database/tablespace in > batch mode. I have [...] 11798 97 31_Re: -911 & DROLLBACK & Batch...16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Tue, 28 Nov 2000 11:01:54 +0530592_- Hi Is issuing of -911 or -913 by chance or depending on some parameters. As i remember we had some discussion on this some 10 months back but that time also no concrete information came out. I believe we shall have one more round of discussion on this.



Regards Sanjeev

> -----Original Message----- > From: Suresh Sane [SMTP:data_arch@HOTMAIL.COM] > Sent: Friday, November 24, 2000 8:13 PM > To: DB2-L@RYCI.COM > Subject: Re: -911 & DROLLBACK & Batch... > > Cuneyt, > > I don't believe you have such an option in batch/tso/caf. This does not > mean you will never [...] 11896 17 55_Re: FW: CDB Software Mailing Quoting DB2 Lis - PLZ STOP10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 28 Nov 2000 08:26:12 +0100337_us-ascii Hi Toine.

Well said !!

Max Scarpa A 'simple' (non-certified) 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. 11914 99 0_30_Karthigai Thirunal,J16 Chennai25_ekarthik@MSDC.HCLTECH.COM31_Tue, 28 Nov 2000 14:14:09 +0530353_iso-8859-1 Is there any fix for DB2 V6.1 on OS/390, Since I am getting error while trying to access the host tables from DB2 UDB Personal Edition, V7.1 (WINDOWS-NT.)



I have applied the Fixpatch-1 for Windows-NT, But still I am getting the following error on the Win-NT side...

CLI10150E Driver not Capable. SQLSTATE=HYC00 And [...] 12014 116 38_Re: stop/start database in batch mode.10_CEI, Bruno20_Bruno.CEI@SEMA.CO.UK31_Tue, 28 Nov 2000 09:33:38 -0000525_iso-8859-1 Karen,

you can build the stop/start command in your JCL as Sanjeev suggest, but be aware that the commands are executed asynchronously. The "command complete" message you receive doesn't mean that the database is stopped, but only that your command has been sent to DB2 and that DB2 has accepted it. You need then to verify that your command has been successfully executed by displaying the status of the database, looking for things like STOPP (stop pending) before continuing with the next JCL step. [...] 12131 142 38_Re: stop/start database in batch mode.0_18_mebert@AMADEUS.NET31_Tue, 28 Nov 2000 10:47:47 +0100487_us-ascii When run in batch, the -STOP command executes synchronously, i.e. if you get to the next job step, the database is certain to be stopped (see the command reference for -STOP DB(..)). If some thread is active in the DB/TS, it may take a while. But unlike a manual -STOP (asynch), the batch command can be cancelled. Then the DB/TS is in STOPP and you can restart it manually or using batch: important if you discover that your -STOP command is endangering a production job. [...] 12274 37 27_SQLESETI and SQLEQRYI api's14_Joniaux Ortwin24_ortwin.joniaux@ORDAB.COM31_Tue, 28 Nov 2000 11:21:46 +0100370_iso-8859-1 Hello,

I'm trying to use the SQLESETI and SQLEQRYI api's to store client information to a database in a 3 tier application. Unfortunaly, without success. Is there anyone who has some experience with these api's? If so, I would be very interested in receiving some information.

Thank you for your time,



Ortwin Joniaux Analist [...] 12312 201 38_Re: stop/start database in batch mode.16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Tue, 28 Nov 2000 16:22:30 +0530638_iso-8859-1 I think what Michael has described is absolutely correct.Any JCL waits (if we see in the Sysprint output) till the particular step is completed.This is batch mode.

Regards Sanjeev

> -----Original Message----- > From: mebert@AMADEUS.NET [SMTP:mebert@AMADEUS.NET] > Sent: Tuesday, November 28, 2000 3:18 PM > To: DB2-L@RYCI.COM > Subject: Re: stop/start database in batch mode. > > When run in batch, the -STOP command executes synchronously, i.e. if you > get to > the next job step, the database is certain to be stopped (see the command > reference for -STOP DB(..)). If some thread is active in the DB/TS, [...] 12514 63 89_Re: Why is Fisher-Price knowledge required for OS/390 Certificati on b ut not vice versa?10_Marc Baime14_mbaime@GTE.NET31_Tue, 28 Nov 2000 07:53:50 -0500455_iso-8859-1 Linda, you are right on the money. No one doubts the sophisticiation of mainframes. And one has to be in another world not to see the direction that mid-range servers are heading. Anyone who calls the mid-range server platforms running databases, web-servers, and application servers 'Barbie' platforms is, IMO, out of touch. I understand how all that CICS might go to someone's head. After all, I used to code CICS macros 15 years ago... [...] 12578 24 27_Free Pages Statistic In UDB18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 28 Nov 2000 08:28:40 -0500515_iso-8859-1 Does anyone know when the free pages statistic on a tablespace is updated in UDB v6.1? This information is retrieved via the list tablespaces show detail command. It never seems to go down after rows are deleted from a table in the tablespace. The documentation suggests that you have to drop the tablespace and recreate it in order to change this number. All I want to do is get a daily report of free pages in the database (as a percentage). The calculation is: (free pages / usable pages) * 100. [...] 12603 37 37_parallelism on UNIX - DB2 UDB EE (E?)16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT31_Tue, 28 Nov 2000 13:58:55 +0100468_us-ascii hi list,

I am asking this question on behalf of a colleague:

he has been set the task of finding out, whether setting up parallelism with DB2 UDB EE (not sure about the number of E-s here) is feasible, impacts on performance if so, how to go about it etc.

I am afraid I don't always read matters relating to non-os/390 DB2, so maybe if this has already been discussed on the list somebody might tell me and I'll search the archives, [...] 12641 82 89_Re: Why is Fisher-Price knowledge required for OS/390 Certificati on b ut not vice versa?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 28 Nov 2000 07:44:49 -0600367_iso-8859-1 I have been doing mainframe support myself for over 15 years. I am learning about my home PC more and more because I walk on the wild side there, no backups and no anti-virus software. I have had to fix that more times than I care to admit. At work I will be learning more about the NT platform and SQL Server if I can ever get the time for training. [...] 12724 168 61_Re: Error Connecting to Database on Local Node (UDB v6.1/AIX)0_22_BILL_GALLAGHER@PHL.COM31_Tue, 28 Nov 2000 08:47:39 -0500571_us-ascii Phil,

Your suggestion of using "db2 get instance" let me down another path towards approaching this problem, and brought me right to the solution. The "db2 get instance" command was resulting in a SQL10007N error. This made me think that maybe it was a problem with file/directory permissions, since I was able to accomplish this successfully from my own userid. Sure enough, the permissions for the directory above sqllib for the db2ccom instance were not set correctly. I reset those with a "chmod 755" command, and now everything is working fine. [...] 12893 20 36_Re: Regarding DB2 dataset Allocation11_Ajit Behera25_ajit.behera@USA.XEROX.COM31_Tue, 28 Nov 2000 07:46:52 -0600382_- Harbri,

Recently I did a DSN1COPY recovery of a large multivolume tablespace with OBIDXLAT parm. I didn't have any problem with getting extents (the tablespace is STOGROUP managed). Initially my job ended with RC=0, but when I did a count(*) on the table it gave me zero row. Later on I put the FULLCOPY parameter in the parm clause and reran the job, it worked fine. [...] 12914 48 21_Re: VALIDPROC example19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 28 Nov 2000 07:59:14 -0600641_ISO-8859-1 Marcus, Can you please tell the list "why" you need VALID/EDITPROCs? They impose limitations and/or performance issues you may wish to avoid.

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, [...] 12963 32 23_Re: JDBC 1st use binds?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 28 Nov 2000 09:18:34 -0500566_iso-8859-1 Thanks Kals, Curt, and Rick for pointing me at DB2 connect as the source of the SQLL* packages which I had incorrectly suspected to be components of JDBC.

As they all suggested, these packages appear to be mostly utilities from DB2 connect. They are apparently expected to be bound when DB2 connect is configured for the subsystem. In the client configuration assistant, at the end of the Add database dialog there is a button for Bind. When you click this button, an attempt is made to bind all the packages on the target database/subsystem. [...] 12996 22 39_DB2 PM saving data for later processing10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 28 Nov 2000 09:35:35 -0500327_us-ascii HI all

I have been asked to review the performance monitors and have a question concerning DB2 PM. From what I read, PM will over write the performance data when it reaches the end of the dataset or dataspace.

What process(s) are there to save the data, lets save to tape, before it's over written? [...] 13019 59 36_Re: Create procedure (sql procedure)16_Peter Van Eeuwen24_pvaneeuwen@ALTAVISTA.COM31_Tue, 28 Nov 2000 06:45:23 -0800626_- Are you using the "stored procedure builder" or JCL to create the proc?

P. Van Eeuwen





On Mon, 27 November 2000, Tom Marcano wrote:

> > Hello Everybody, > > I'm trying to get any help regarding a SQL procedure. I created and compiled > my SQL procedure: > > CREATE PROCEDURE owner.CARDINFO > (IN ORD_NO_VAR CHAR(9), > IN USERDATA_FLD14_VAR CHAR(29)) > LANGUAGE SQL > COLLID bindcard > RESULT SETS 1 > WLM ENVIRONMENT wlmcard > MODIFIES SQL DATA > UPDATE owner.CREDIT_INFO_B > SET USERDATA_FLD14 = USERDA_FLD14_VAR > WHERE ORD_NO = ORD_NO_VAR > > Everything looks good at this point, [...] 13079 151 44_Re: FW: CDB Software Mailing Quoting DB2 Lis10_Wim Ruarus18_w.h.ruarus@KPN.COM31_Tue, 28 Nov 2000 15:42:10 +0100612_iso-8859-1 I completely agree with you Toine, let's stick to DB2 matters here and leave the legal stuff on the LawyersList.

Wim Ruarus.

> ---------- > Van: Toine Michielse[SMTP:vndobtm@US.IBM.COM] > Antwoord naar: DB2 Data Base Discussion List > Verzonden: maandag 27 november 2000 23:36 > Aan: DB2-L@RYCI.COM > Onderwerp: Re: FW: CDB Software Mailing Quoting DB2 Lis > > O please...... No lawyers or I'll shut up forever.. The next thing you > know > someone will hold me accountable for an opinion I expressed on this forum. > Let's just get back to the 'easy living' without too much legal [...] 13231 27 8_Packages13_Davis, Ronald17_DavisRo@CONED.COM31_Tue, 28 Nov 2000 10:05:41 -0500333_- I am about to convert some Plans to Packages. I've set up an online plan and a Batch plan. I've worked out a naming convention for the Collection Ids. Now I need to make a big decision:

Versioning - Yes or No?

If we go with versioning we would like to keep 3 versions. In my last job versioning got out of hand. [...] 13259 47 12_Re: Packages14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Tue, 28 Nov 2000 09:10:19 -0600431_iso-8859-1 We don't use versioning in our test subsystem or in our production batch, but we do use version(auto) for production CICS. (This keeps the users from getting a -805 error. Programmers can live with it, because they can do a new copy on the test CICS region.) I have a routine that runs every weekend that cleans up old versions after production CICS has been bounced. This has worked well for us for several years. [...] 13307 41 0_13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 28 Nov 2000 09:16:16 -0600362_US-ASCII Hello Thirunal, Did you run DSNTIJCC samplib member on OS/390 ? There is also a list of V6 PTF's on the DB2 Connect web site. HTH Kurt

>>> ekarthik@MSDC.HCLTECH.COM 11/28/00 02:44AM >>> Is there any fix for DB2 V6.1 on OS/390, Since I am getting error while trying to access the host tables from DB2 UDB Personal Edition, V7.1 (WINDOWS-NT.) [...] 13349 42 28_Execution of Multiple EXISTS11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 28 Nov 2000 09:16:31 -0600418_- Have a question to which I would like a definitive answer (asked in on of our sql classes). When a query contains multiple EXISTS clauses connected with an OR, is DB2 smart enough not to evaluate the second block when the first is found to be TRUE? Here is the exact question asked: " If you have a query that is of the structure below, will DB2 check both subqueries or stop when one is met because of the OR? [...] 13392 30 12_Re: Packages15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 28 Nov 2000 09:28:23 -0600445_- Hi Davis

I think there is a lot to say about this issue. In our shop the biggest decision was one collection or more, because how do you or the developpers decide in which collection a package must be bound - in only one? in some? or in all? -

Another point to mention is, only two plans ?? I think it's not a good idea to use only two plans, because trouble shooting, performance analysis and traces are almost impossible. [...] 13423 83 12_Re: Packages11_Joseph Link26_joe.link@FIRSTDATACORP.COM31_Tue, 28 Nov 2000 09:33:14 -0600428_us-ascii Ronald,

In answer to your questions,

1. Yes, we have a program that reads SYSPACKAGE and generates FREE statements for all packages except for the latest #, where # is an input parameter.

2. Currently we only use VERSION(AUTO). I have also seen a specific version identifier used for emergency or quick-fix situations. This way your clean-up process can identify these packages and skip them. [...] 13507 74 12_Re: Packages14_Richard Arnold24_Richard.Arnold@CHASE.COM31_Tue, 28 Nov 2000 09:14:11 -0600731_us-ascii Ronald,

I vote no for versioning. It usually gets out of hand.

Just my opinion.

Richard Arnold DBA Morgan Chase







"Davis, Ronald" on 11/28/2000 09:05:41 AM

Please respond to DB2 Data Base Discussion List



























To: DB2-L@RYCI.COM

cc: (bcc: Richard Arnold/CHASE)





Subject: Packages





I am about to convert some Plans to Packages. I've set up an online plan and a Batch plan. I've worked out a naming convention for the Collection Ids. Now I need to make a big decision: [...] 13582 57 31_Re: Free Pages Statistic In UDB0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Tue, 28 Nov 2000 10:40:37 -0500485_us-ascii Peter,

I have found that the only way to reclaim pages (so that the free page number goes higher) is via a reorg.

HTH

Ed







"Krawetzky, Peter J" @RYCI.COM> on 11/28/2000 08:28:40 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Free Pages Statistic In UDB [...] 13640 80 12_Re: Packages10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Tue, 28 Nov 2000 09:36:31 -0600422_us-ascii Ronald, I was in a class at the Tech Conf where they stated that 'creating a single online plan & a single batch plan was NOT the optimal path'. It was in the 'Top 20 Myths about DB2' section in DB2 OS/390 High Performance Design: Systems class. They recommended that the number of packages put into a single plan should be based on functionality (read application - customer orders, shipping, warehouse,..) [...] 13721 79 36_Re: Create procedure (sql procedure)11_Tom Marcano23_marcano_db2@HOTMAIL.COM31_Tue, 28 Nov 2000 15:38:09 -0000 13801 41 31_jdbc - App driver vs Net driver14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Tue, 28 Nov 2000 10:39:02 -0500574_iso-8859-1 I have a java application program running in an AIX box which does a simple select on a table. When I use jdbc net driver the program works but when I change the code to use App driver the program fails with the following error:

java.sql.SQLException: No suitable driver at java.lang.Exception.(Compiled Code) at java.sql.SQLException.(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at DB2Conn.getDB2Connection(Compiled Code) at testDB2Conn.main(Compiled Code) [...] 13843 41 12_Re: Packages13_Davis, Ronald17_DavisRo@CONED.COM31_Tue, 28 Nov 2000 10:43:19 -0500462_- Oh - I forgot to mention - Each application will have there own online and batch plans and collections.

-----Original Message----- From: Davis, Ronald [SMTP:DavisRo@CONED.COM] Sent: Tuesday, November 28, 2000 10:06 AM To: DB2-L@RYCI.COM Subject: Packages

I am about to convert some Plans to Packages. I've set up an online plan and a Batch plan. I've worked out a naming convention for the Collection Ids. Now I need to make a big decision: [...] 13885 13 32_Re: Execution of Multiple EXISTS15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 28 Nov 2000 09:43:41 -0600356_- Suresh

I'm not sure, but an application trace will show you, whether the second exists will be evaluated.

================================================ 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. 13899 80 31_Re: Free Pages Statistic In UDB14_Scott Saunders20_ssaunders@SIEBEL.COM31_Tue, 28 Nov 2000 07:52:58 -0800313_iso-8859-1 Peter, Ed;

This has been my experience as well. Given that, do you know if DB2 is reusing the space left by the deleted rows, assuming fixed row sizes, or is the space just flagged to be reclaimed at reorganization time? I am referring to DB2 UDB Unix.

Scott Saunders Siebel Systems [...] 13980 190 44_Re: FW: CDB Software Mailing Quoting DB2 Lis12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 28 Nov 2000 07:58:28 -0800618_us-ascii I have no problem with people quoting me. But I have a problem with any company using those quotes for commercial advertising purposes without my permission.



To me there is a significant difference between the two . And I believe that is the real issue being brought up here. That is, can or even more importantly should any company use your comments on DB2-L for commercial purposes without your knowledge or permission? --- Toine Michielse wrote: > O please...... No lawyers or I'll shut up forever.. > The next thing you know > someone will hold me accountable for [...] 14171 58 36_Re: accessing DB2 V6.1 from Db2 UDB.12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 28 Nov 2000 08:32:23 -0800286_us-ascii Two problems that I see. First off, I don't think that DB2 UDB PE can access OS/390 tables directly. I think it needs DB2 Connect installed as well to accomplish this, but Leon can verify for sure. I think this is the reason you're getting the driver not capable message. [...] 14230 223 44_Re: FW: CDB Software Mailing Quoting DB2 Lis15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 28 Nov 2000 10:06:51 -0600507_iso-8859-1 Perhaps notification needs to be made to vendors that they need to ask for permission before quoting anyone. It is not like they can't email anyone. Or, perhaps, and this would require more administration on the part of the list owners, new list members are warned about this sort of thing can happen when they sign up. If they don't want their comments ending up on someone's postcard they can say so. Vendors would have to check with list owners to make sure they can use someone's quote. [...] 14454 58 22_CONNECTION INTERRUPTED8_Tam Tran18_ttran@LASERCOM.COM31_Tue, 28 Nov 2000 17:28:14 +0100319_us-ascii Hello DB2 Experts

This is my first time on list. please help me

Here is our problem :

A DB2 session (i.e. DB2 client software on Client talking to the DB2 database on Server) fails if it is idle for a long time (maybe a day).

We use DB2 with WindowNT on both Client and Server [...] 14513 20 4_help10_Elsie Tama24_elsie.m.tama@VERIZON.COM31_Tue, 28 Nov 2000 11:42:51 -0500503_us-ascii What is the down-side or draw-back for multiple applications(Business Groups) selecting, reading, updating, and deleting from a single table?

Any recommendation or suggestions will be greatly appreciated.

Thanks,

Elsie 703-974-2605

================================================ 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. 14534 62 44_Re: FW: CDB Software Mailing Quoting DB2 Lis14_Scott Trometer22_scott.trometer@RCI.COM31_Tue, 28 Nov 2000 11:44:47 -0500380_iso-8859-1 I agree with Linda that this would help to minimize the problem, however, my view is that the List Owners are not responsible for the conduct of the vendors...the vendor is.

A Vendor is oblidged to know and follow all laws, rules, industry standards, etc. in all jurisdictions in which it operates. It is responsible...not you, not me, not the list owners. [...] 14597 44 8_Re: help16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 28 Nov 2000 11:42:40 -0500511_iso-8859-1 No downside at all as long as the applications COMMIT frequently and you do the appropriate frequency of BACKUP and REORG. DB2 handles concurrency extremely well when the applications are well-behaved. We do tens of millions (some days hundreds) of inserts/updates per day.

regards, Eric Pearson NS ITO Database Support



-----Original Message----- From: Elsie Tama [mailto:elsie.m.tama@VERIZON.COM] Sent: Tuesday, November 28, 2000 11:43 AM To: DB2-L@RYCI.COM Subject: help [...] 14642 53 8_Re: help15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 28 Nov 2000 10:52:41 -0600418_iso-8859-1 Hi, Elsie,

Two thoughts come to mind. First, depending on the amount of activity on the table and the table size, locking could be a problem. Second, if there is an RI requirement on the table, it should be enforced through DB2, not the application.

My humble opinion,

Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin [...] 14696 130 77_Re: From the List Owners Re: CDB Software Mailing Quoting DB2 List Re sponses16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT31_Tue, 28 Nov 2000 17:40:39 +0100514_us-ascii "I do have a problem with it. These quotes may have been (or might be in the future) taken out of context or otherwise distorted for the advertisers benefit."

I agree with that.... I have never in my life said anything so witty or brilliant to think I'd be quoted, instead it seems that a couple of my remarks about the VENDOR-WHO-SHALL-REMAIN-UNNAMED (the same guys who are taking over the world, if you remember a nice thread about fisher-price DB2 a while ago), WERE quoted out of context. [...] 14827 82 8_Re: help10_Elsie Tama24_elsie.m.tama@VERIZON.COM31_Tue, 28 Nov 2000 11:52:46 -0500881_us-ascii Eric,

Thanks,but how about if they don't comit frequently, nor reorged frequently, then what?

Thanks,

Elsie

---------------------- Forwarded by ELSIE M. TAMA/EMPL/VA/Bell-Atl on 11/28/2000 11:51 AM ---------------------------



"Pearson, Eric L," on 11/28/2000 11:42:40 AM

Please respond to "DB2 Data Base Discussion List"





To: DB2-L@RYCI.COM

cc: (bcc: ELSIE M. TAMA/EMPL/VA/Bell-Atl)





Subject: Re: help











No downside at all as long as the applications COMMIT frequently and you do the appropriate frequency of BACKUP and REORG. DB2 handles concurrency extremely well when the applications are well-behaved. We do tens of millions (some days hundreds) of inserts/updates per day. [...] 14910 91 23_Re: BD2 VSE INFORMATION16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT31_Tue, 28 Nov 2000 17:46:33 +0100463_us-ascii Rabi,

DB2 Server for VSE and VM is very much alive and kicking, to the dismay of all who have to work with it!!! only joking there....

the home page is http://www.software.ibm.com/data/db2/vse-vm

also, check the website from The Fillmore Group since they have classes on the subject (I cannot remember their address offhand, but I think it is www.thefillmoregroup.com and I think Frank Fillmore subscribes to this list anyway). [...] 15002 13 14_fragmentation.10_Elsie Tama24_elsie.m.tama@VERIZON.COM31_Tue, 28 Nov 2000 11:56:06 -0500344_us-ascii In my shop we found out that due to heavy insert and delete on a table, fragmenation accured.

================================================ 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. 15016 30 14_fragmentation.10_Elsie Tama24_elsie.m.tama@VERIZON.COM31_Tue, 28 Nov 2000 11:58:08 -0500413_us-ascii In my shop we found out that due to heavy insert and delete on a table, fragmenation accured. what is the down side of this and how can it be avoided.

Thanks Elsie

---------------------- Forwarded by ELSIE M. TAMA/EMPL/VA/Bell-Atl on 11/28/2000 11:57 AM ---------------------------



ELSIE M. TAMA 11/28/2000 11:56 AM

To: DB2-L@RYCI.COM cc: Subject: fragmentation. [...] 15047 98 31_Re: Free Pages Statistic In UDB18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 28 Nov 2000 12:09:33 -0500406_iso-8859-1 One of my co-workers proved the reorg theory. It did change the free pages statistic. If UDB works the same way as DB2 OS/390, I assume it reuses empty pages. I think this is true because we insert approximately 200,000 rows into a tablespace per day at the same time old rows are deleted (approximately 5,000/day). I have not seen a significant increase in space usage in this tablespace. [...] 15146 107 8_Re: help15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 28 Nov 2000 11:12:01 -0600330_iso-8859-1 I say get out a big stick and bonk them on the head! There are a lot of reasons for doing fairly frequent commits besides release of locks, such as faster recovery. Of course, it depends. You don't want to do too many commits or you lose those precious uprocs and iprocs, and you lose out on sequential detection. [...] 15254 55 18_Re: fragmentation.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 28 Nov 2000 12:14:58 -0500483_iso-8859-1 Downside = degraded performance, waste of space. Avoid = frequent REORG and/or increased PCTFREE. Consider IBM's REORG SHRLEVEL CHANGE (also fondly known as ONLINE REORG) which allows you to REORG with (almost) zero application outage.

regards, Eric Pearson NS ITO Database Support



-----Original Message----- From: Elsie Tama [mailto:elsie.m.tama@VERIZON.COM] Sent: Tuesday, November 28, 2000 11:58 AM To: DB2-L@RYCI.COM Subject: fragmentation. [...] 15310 128 8_Re: help16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 28 Nov 2000 12:16:01 -0500663_iso-8859-1 Linda, I *LOVE* the stick idea. It is much kinder and gentler than the Uzi treatment I proposed to management.

regards, Eric Pearson NS ITO Database Support



-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Tuesday, November 28, 2000 12:12 PM To: DB2-L@RYCI.COM Subject: Re: help



I say get out a big stick and bonk them on the head! There are a lot of reasons for doing fairly frequent commits besides release of locks, such as faster recovery. Of course, it depends. You don't want to do too many commits or you lose those precious uprocs and iprocs, and you lose [...] 15439 45 12_Re: Packages14_Scott Trometer22_scott.trometer@RCI.COM31_Tue, 28 Nov 2000 12:20:38 -0500437_iso-8859-1 I have my own theory...although it is not currently in practice.

First: Keep it simple. In the long term, the benefits of keeping things simple generally outweigh the performance improvements of complicated set ups. In terms of learning curve, administration, flexibility, etc. Of course, there are exceptions. Having things set up simply to begin with will allow you to accommodate/document the exceptions later. [...] 15485 142 8_Re: help19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 28 Nov 2000 11:22:40 -0600422_ISO-8859-1 Eric, A further point . . . As Linda rightly pointed out, RI should be handled by DB2. In fact, all business rules for the table should be moved into DB2 (via constraints, SPs, triggers, whatever) so that all Applications play by each others business rules. You may even find out that two different Application's rules for the same column may conflict with each other and will need to be worked out/fixed. [...] 15628 164 8_Re: help16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 28 Nov 2000 12:24:20 -0500404_iso-8859-1 AMEN to that. Well over 90% of our RI is in DB2 and all the new stuff is. I've been pushing SP but we have too many folks who prefer to be the second mouse.

regards, Eric Pearson NS ITO Database Support



-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Tuesday, November 28, 2000 12:23 PM To: DB2-L@RYCI.COM Subject: Re: help [...] 15793 24 11_CURRENTDATA9_mrk theni20_mrktheni@HOTMAIL.COM31_Tue, 28 Nov 2000 11:26:38 -0600356_- Can somebody enlighten me with CURRENTDATA and Isolation combination.

Would it be beneficial to use CURRENTDATA(NO) and UR, to take advantage over lock avoidance both ways. For example; with UR, when PROGRAM-A is allowed to read uncommitted data of PROGRAM-B, will CURRENTDATA(NO) allow PROGRAM-B to update the records selected by PROGRAM-A? [...] 15818 36 8_Re: help12_Jim Harrison12_jimh@QIS.NET31_Tue, 28 Nov 2000 12:46:07 -0500663_us-ascii If by chance they start to update other shared tables, be sure they coordinate their update/locking strategy to avoid deadly embraces. Since it appears these are separate business groups, this could happen very easily.





>-----Original Message----- >From: Elsie Tama [mailto:elsie.m.tama@VERIZON.COM] >Sent: Tuesday, November 28, 2000 11:43 AM >To: DB2-L@RYCI.COM >Subject: help > > >What is the down-side or draw-back for multiple applications(Business >Groups) >selecting, reading, updating, and deleting from a single table? > >Any recommendation or suggestions will be greatly appreciated. > >Thanks, > >Elsie >703-974-2605 [...] 15855 17 44_Re: FW: CDB Software Mailing Quoting DB2 Lis11_Scott Adams20_Sadams@AMERISURE.COM31_Tue, 28 Nov 2000 13:06:01 -0500436_us-ascii Can we please just allow this thread to die!

The legal/moral rights of someone to quote something we have stated on a public list has nothing to do with the purpose of this 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. 15873 37 44_Re: FW: CDB Software Mailing Quoting DB2 Lis18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Tue, 28 Nov 2000 13:09:14 -0500438_iso-8859-1 I 2nd this motion for this thread to die out. (and no re-count is necessary). ;-)

Steve Whittaker DB2/DBA Carolina Power & Light Mail stop:OHS 4 - Raleigh Email: stephen.whittaker@cplc.com Phone: (919) 546-7267



-----Original Message----- From: Scott Adams [mailto:Sadams@AMERISURE.COM] Sent: Tuesday, November 28, 2000 1:06 PM To: DB2-L@RYCI.COM Subject: Re: FW: CDB Software Mailing Quoting DB2 Lis [...] 15911 37 71_question regarding your use of OS/390 DB2 and the web - security issues0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Tue, 28 Nov 2000 12:32:53 -0600608_us-ascii Since I originally asked this question just before the holidays, I would guess that it missed some people (not to mention the fact that no one responded). So I will give it one more try.

We are getting into some discussions regarding using mainframe (OS/390) DB2 as a underlying datastore for web based applications and have some concerns regarding security. One possible option for enhancing security would be the creation of a brand new DB2 platform exclusively for web access. Of course, if this option is used, there will be a requirement for sending data back and forth between the [...] 15949 76 26_Re: CONNECTION INTERRUPTED13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 28 Nov 2000 12:53:36 -0600486_iso-8859-1 Tran,

10054 can be idle thread timeout at host (DB2 OS/390?). If after your SELECT, you would issue a COMMIT to release any locks (and assuming DB2 Connect packages are bound release commit), your thread would probably be set to status inactive at host instead of active (threads holding any locks will remain active). An inactive thread will persist, whereas an active thread is subject to the idle thread timeout as configured for the 'DB2 database on Server'. [...] 16026 69 32_Re: Execution of Multiple EXISTS20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 28 Nov 2000 14:15:33 -0500639_us-ascii Hi Suresh

How are you?

Here is the definitive answer.

DB2 is smart enough to stop after the first sub-query has been found true. However if the first sub-query is not true then order in which the subquery has been coded matters.

Regards Venkat Pillay

> -----Original Message----- > From: Suresh Sane [SMTP:data_arch@HOTMAIL.COM] > Sent: Tuesday, November 28, 2000 10:17 AM > To: DB2-L@RYCI.COM > Subject: Execution of Multiple EXISTS > > Have a question to which I would like a definitive answer (asked in on of > our sql classes). When a query contains multiple EXISTS clauses connected > [...] 16096 157 36_Re: Create procedure (sql procedure)12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 28 Nov 2000 11:18:14 -0800470_us-ascii Tom, You running into a known restriction between Triggers and Stored Procedures. You cannot pass a variable to a stored procedure that updates that variable and expect the updated value to be correctly inserted by the Trigger when the INSERT is actually done.

This issue was described in some detail at the IBM DB2 Tech Conference by Richard Yevich in his presentation Advanced Db2 Programming - Triggers, Stored Procedures, and UDFs, etc. Part 2. [...] 16254 90 18_Re: fragmentation.0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 28 Nov 2000 13:25:56 -0600547_us-ascii Speaking of Online Re-org, has anyone experience using it in a high transaction environment? We haven't used it yet (DB2 V5.1 OS390 V2.8) because when it first came out someone had a concern about how long the TS would be unavailable during DS swapping. Unfortunately we can't test effectively in development and certain people around here are absolutely paranoid about testing in production causing outages for users (especially if they can be 'blamed' on us). Any positve experieces I can quote would help reduce the 'fear level'. [...] 16345 76 75_Re: question regarding your use of OS/390 DB2 and the web - security issues12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 28 Nov 2000 21:33:03 +0200443_iso-8859-1 Hi, We're using "top-secret" to handle the connections. All tcpport are disallowed except for a known list of users (need top-secret admin. for that). No user can have a fixed password or no-password attribute and they must be changed frequent or they get totally closed. They never get direct access prod data, only to db2web so we can add more controls if needed. It's still at the beginning - so it may be changed later on. [...] 16422 92 26_Re: CONNECTION INTERRUPTED11_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Tue, 28 Nov 2000 19:43:16 +0000603_us-ascii Tran,

There is something similar on Unix. The tcp_keepidle and tcp_keepintvl parameters. These are used to drop connections where the client side of the connection no longer exists. For example, the client PC is rebooted.

I seem to recall there is a reasonable amount of information in the books to help investigate this - although it isn't the easiest information to find. I believe on NT it is to do with settings in the registry. Certainly when I investigated a similar issue with Windows clients to Aix server, it was an AIX settings problem rather it being a DB2 issue. [...] 16515 127 18_Re: fragmentation.12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 28 Nov 2000 21:41:46 +0200538_iso-8859-1 Hi, Depends on update rate. In V5.1 take 2-3 seconds elapsed for any file participating for the switch phase (e.g.: 1 table (in ts) + 3 indexes ==> 10-12 seconds). And you need to add the final pass over the log. If you can stand with this - fine. Using shrlevel change takes much longer to run but this is the real purpose - heard it's going to be improved on V6/V7. More problematic are long running batch jobs (even if they're read only) that prevent the drain from completion - it can kill your OLR after all work was [...] 16643 87 26_Re: CONNECTION INTERRUPTED13_McHugh, Gerry21_MchughG@DIVINVEST.COM31_Tue, 28 Nov 2000 13:37:41 -0600590_iso-8859-1 Also my first time. Just joined this morning. Hope this helps. There are a number of configuration parameters in DB2 OS/390 that control thread disposition. One in particular that comes to mind in your case is ZPARM "idle thread timeout". Sounds from what you describe that this thread might be inactive and the parm value that's set could be timing it out. Another is ZPARM "pool thread timeout". BUT, I must say that from the specific error message below that it looks like a TCP/IP connection is failing and that will break the connection. I personally don't know of any [...] 16731 139 18_Re: fragmentation.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 28 Nov 2000 14:45:15 -0500434_iso-8859-1 We do a lot of this. If you make (MAXRO + dataset time)considerably lower than IRLMRWT where dataset time is about 1-5 seconds for each dataset containing partitions of the tablespace and supporting indexes then you should be okay.

If you have LARGE tablespaces (hundreds of partitions), this could be a real issue (although you may run out of space in Private or LSQA long before you got to the SWITCH phase). [...] 16871 34 20_DB2 & Indus/Passport18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Tue, 28 Nov 2000 14:50:47 -0500576_iso-8859-1 Currently we are running with OS/390 DB2 V5 and Indus/Passport V7. Starting in early 2001 there is talk of going to Indus/Passport Version 8 and about that same time we are looking at upgrading to DB2 Version 6. My question; Is anyone out there (who runs Indus) running Indus/Passport V8 on DB2 V6?? If so have you had any problems?? My understanding is that Indus does NOT certify their Passport V8 with DB2 V6 and will not certify it. This could pose a problem for support but thats another bridge to cross. Any info would be appreciated, either through the [...] 16906 60 8_Re: help13_McHugh, Gerry21_MchughG@DIVINVEST.COM31_Tue, 28 Nov 2000 13:39:37 -0600648_iso-8859-1 Additional suggestion. Don't know if this is possible, but maybe you could also distribute (i.e. cluster/partition) the data so different apps hit different areas of the TS.

-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Tuesday, November 28, 2000 11:43 AM To: DB2-L@RYCI.COM Subject: Re: help



No downside at all as long as the applications COMMIT frequently and you do the appropriate frequency of BACKUP and REORG. DB2 handles concurrency extremely well when the applications are well-behaved. We do tens of millions (some days hundreds) of inserts/updates per day. [...] 16967 146 18_Re: fragmentation.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 28 Nov 2000 14:46:43 -0500663_iso-8859-1 Isaac, Linda's stick or my Uzi can fix the long-running-batch problem.

regards, Eric Pearson NS ITO Database Support



-----Original Message----- From: Isaac Yassin [mailto:yassin@NETVISION.NET.IL] Sent: Tuesday, November 28, 2000 2:42 PM To: DB2-L@RYCI.COM Subject: Re: fragmentation.



Hi, Depends on update rate. In V5.1 take 2-3 seconds elapsed for any file participating for the switch phase (e.g.: 1 table (in ts) + 3 indexes ==> 10-12 seconds). And you need to add the final pass over the log. If you can stand with this - fine. Using shrlevel change takes much longer to run but this is the real purpose - [...] 17114 205 61_Re: Error Connecting to Database on Local Node (UDB v6.1/AIX)11_Phil Castle20_phil@ECNETWORK.CO.NZ31_Wed, 29 Nov 2000 08:57:33 +1300598_iso-8859-1 the correct spelling is EUNUCHS.

One of the most important things in the computing industry is the widespread adoption of standards. It's just a pity that (somehow) Unix and C became the standards. It set the computer industry back about 10 years in my opinion. Especially C where, to achieve even relatively trivial things, you have to fiddle with pointers and memory allocation. I can't imagine how many thousands of man-years have been wasted dealing with this. Not to mention how many pieces software suffer from memory leaks and GPFs / core-dumps when you get it wrong. [...] 17320 46 18_Re: fragmentation.13_McHugh, Gerry21_MchughG@DIVINVEST.COM31_Tue, 28 Nov 2000 13:45:38 -0600396_iso-8859-1 More pctfree, freepage.

-----Original Message----- From: Elsie Tama [mailto:elsie.m.tama@VERIZON.COM] Sent: Tuesday, November 28, 2000 11:58 AM To: DB2-L@RYCI.COM Subject: fragmentation.



In my shop we found out that due to heavy insert and delete on a table, fragmenation accured. what is the down side of this and how can it be avoided.

Thanks Elsie [...] 17367 23 77_Re: From the List Owners Re: CDB Software Mailing Quoting DB2 List Re sponses13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Tue, 28 Nov 2000 13:57:18 -0600392_- > >to be quite honest I'd have preferred to be quoted on a t-shirt :-) I >certainly would have had no problems with that and actually I hope to get >one of the t-shirts ASAP! >

I fail to understand this facination with t-shirts ( in reality ads ). As for me I'd refuse to wear one unless I were paid for everytime I wear it in public. Why should I be their billboard for free ? [...] 17391 109 18_Re: fragmentation.11_David Nance16_DWNance@FHSC.COM31_Tue, 28 Nov 2000 14:59:21 -0500295_US-ASCII The answer "it depends" will always come into play. The best way for you to find out in your system would be to use the online reorg during your defined maintenance window on the tablespaces you have identified as candidates for online reorg and see how long they are unavailable. [...] 17501 48 78_Re: From the List Owners Re: CDB Software Mailing Quoting DB2 Lis t Re sponses16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 28 Nov 2000 15:01:59 -0500512_iso-8859-1 Mohammad, 1) The shirt is free. If you don't dislike the product, why object? 2) Wearing geeky clothing helps geeks recognize each other. Sort of like a 'letter sweater' among meatheads ... uhh athletes.

regards, Eric Pearson NS ITO Database Support



-----Original Message----- From: Mohammad Khan [mailto:mkkhan88@HOTMAIL.COM] Sent: Tuesday, November 28, 2000 2:57 PM To: DB2-L@RYCI.COM Subject: Re: From the List Owners Re: CDB Software Mailing Quoting DB2 List Re sponses [...] 17550 187 18_Re: fragmentation.12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 28 Nov 2000 22:11:52 +0200495_iso-8859-1 Hi, It's problematic - there are many of them and few of us :)) Really -it's a long story running up and down mgmt. levels with no political solution for the moment. If you have a long running read-only analysis you are in a problem with the current OLR . What is needed is a way to pass the locks to the "new" (shadow if you like) dataset so it will not hold the switch phase (that's for IBM). I even passed them a solution for online index creation - but no response till now. [...] 17738 76 65_Re: From the List Owners Re: CDB Software Mailing Quoting DB2 Lis16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Tue, 28 Nov 2000 15:15:04 -0500457_us-ascii People on this list server have WAY TOO MUCH time on their hands!!!!

Thank goodness for the DELETE option. I vote for adding an "IGNORE" feature.

Signed:

A Busy DBA who does NOT monitor this list server every SECOND of the day.....











"Pearson, Eric L," on 11/28/2000 03:01:59 PM

Please respond to DB2 Data Base Discussion List [...] 17815 88 76_Re: question regarding your use of OS/390 DB2 and the web - secur ity issues13_McHugh, Gerry21_MchughG@DIVINVEST.COM31_Tue, 28 Nov 2000 14:32:46 -0600399_iso-8859-1 Quite timely receiving this question, as I was 5 minutes away from posing a similiar question myself (honest to God!!!). Must be some kind of omen. Here's our deal. We are also getting more and more development using web based and distributed apps, and security concerns me. We are using Websphere 3.5, DB2 Connect 6.1 on an NT server, accessing data on DB2 V5 for OS/390 on the MF. [...] 17904 105 26_Re: CONNECTION INTERRUPTED13_McHugh, Gerry21_MchughG@DIVINVEST.COM31_Tue, 28 Nov 2000 14:37:43 -0600690_iso-8859-1 Believe there's also an idle thread timeout in DB2 Connect, that should be set >= the ZPARM in OS/390. Don't know about UDB on platforms other than OS/390.

-----Original Message----- From: Shapiro, Dave [mailto:Shapiro.Dave@PRINCIPAL.COM] Sent: Tuesday, November 28, 2000 1:54 PM To: DB2-L@RYCI.COM Subject: Re: CONNECTION INTERRUPTED



Tran,

10054 can be idle thread timeout at host (DB2 OS/390?). If after your SELECT, you would issue a COMMIT to release any locks (and assuming DB2 Connect packages are bound release commit), your thread would probably be set to status inactive at host instead of active (threads holding any locks will remain [...] 18010 74 35_Re: jdbc - App driver vs Net driver0_24_db46@DAIMLERCHRYSLER.COM31_Tue, 28 Nov 2000 15:41:59 -0500330_us-ascii Basically you need the right driver in the appropriate directory on the AIX box.

We've had the same problems. I had to copy the latest db2java.zip file to my c:/Program Files/sqllib/java directory so it would work with the app driver.

One other cause could be that you have different versions of JDBC. [...] 18085 91 78_Re: From the List Owners Re: CDB Software Mailing Quoting DB2 Lis t Re sponses0_22_BILL_GALLAGHER@PHL.COM31_Tue, 28 Nov 2000 15:52:16 -0500312_us-ascii Vendor t-shirts are ideal apparel to wear when performing important database tasks, such as:

1) Mowing the lawn on a hot, humid day 2) Painting 3) Changing the oil in your car 4) Any other task in which you'd rather not get a shirt that you actually paid for dirty

OK, I'll stop now. [...] 18177 163 44_Re: FW: CDB Software Mailing Quoting DB2 Lis10_Jiang Tong30_jiang@INTREPID.CDG-HARGRAY.COM31_Tue, 28 Nov 2000 14:52:35 -0600672_us-ascii

I would like to have a CDB t-shirt (XL), thanks.

Jiang Tong DBA Communications Data Group PO Box 4036 Champaign, IL 61824









Jennifer Moody on 11/27/2000 10:52:20 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Jiang Tong/mbsgroup/CDG) Subject: FW: CDB Software Mailing Quoting DB2 Lis







I'd be happy to send a free t-shirt to anyone on the listserve who would like one. Email your contact info (name, company name, address, phone) to jmoody@cdbsoftware.com and I will send it immediately. [...] 18341 98 78_Re: From the List Owners Re: CDB Software Mailing Quoting DB2 Lis t Re sponses16_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT31_Tue, 28 Nov 2000 23:11:06 +0100395_us-ascii while I second and also third the motion to kill this thread, I can't help thanking eric....

geeky greetings.

Aurora Emanuela Dell'Anno Systems Programmer Sistemi Informativi S.p.A. e-mail: aurora.dellanno@sistinf.it tel. +39 335 7429486

no trees were killed in the sending of this message. however - a large number of electrons were seriously inconvenienced. [...] 18440 103 28_DB2 OS/390 V6.1 Online Reorg16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Tue, 28 Nov 2000 17:24:48 -0500319_iso-8859-1 I online reorg'd 315 indexes in a single day starting at 9:00 and finishing at 18:30. I submitted thirty (30) sets of indexes at a time, grouped by ascending row count. There were partitioned and non-partitioned. I saved the largest indexes (>500K rows) for last and did those a single index at a time. [...] 18544 11 28_Re: New IBM DB2 tools -Reply7_James K23_james_kinder@ES.ADP.COM31_Tue, 28 Nov 2000 16:18:06 -0600324_- Is anyone using the new IBM DB2 Tools and if so, what do you think of the tools?

================================================ 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. 18556 69 76_Re: question regarding your use of OS/390 DB2 and the web - secur ity issues15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 29 Nov 2000 09:30:25 +1100475_- Larry,

Saw your original note. Didn't know how to reply, so didn't. Still don't, really, but this might be useful.

http://www.redbooks.ibm.com/abstracts/sg245273.html

It's a redbook called Accessing DB2 for OS/390 Data from the World Wide Web , SG24-5273-00 which sounds like it might be what you're looking for. There are several other redbooks there that might also be useful, to do with websphere etc. Have a look at the site; it's quite good. [...] 18626 104 44_Re: Problem accessing host table from DB2 PE0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Tue, 28 Nov 2000 16:41:48 -0600505_us-ascii



We experienced problems trying to access host tables from DB2 PE and other microsoft products and CAE . Once we installed DB2 EE and went through DB2 Connect , it worked just fine.

HTH Shan,

Disclaimer: All opinions are mine and not my employers.









"Karthigai Thirunal,J16 Chennai" on 11/28/2000 02:44:09 AM





Please respond to DB2 Data Base Discussion List [...] 18731 56 38_Re: stop/start database in batch mode.15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 29 Nov 2000 10:26:57 +1100271_- Hate to dissent but I dont' think this is quite right. Yes, DSN commands in batch are issued synchronously. Yes, if you get to the next statement/step then the DSN command has been issued - and performed - but no, it's not quite that simple if you cancel the job. [...] 18788 61 25_16 vs 32 bit ODBC problem10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 29 Nov 2000 09:34:32 +1000333_ISO-8859-1 Hi everybody,

We have got a problem with one of our applications which we have havent been able to figure out, yet.

This is a 16 bit Windows based application (it is pretty old) connecting to DB2 (V5) on the mainframe using DB2 Connect V5, with options which kick off other applications (again 16 bit). [...] 18850 28 33_Re: Some Change Manager questions15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 29 Nov 2000 10:35:37 +1100592_- Hi Mike/Bill,

Thanks for your comments. I really despise having to do anything 'non-vanilla' when performing tasks. So, I don't think I'll be using an edit proc to muck around with the worklist. And yes, I could edit the worklist to make it do what I want, but I would have preferred to get CM to generate what I want instead. The probs aren't big; I can delete the Bind Package statements from the generated worklist (the only downer being the analysis takes significantly longer when it's generating thousands of Bind Package statements) and I can either a) generate synonyms [...] 18879 99 21_Re: VALIDPROC example12_Marcus Green18_mgreen@AAPT.COM.AU31_Wed, 29 Nov 2000 10:37:15 +1100627_US-ASCII Oh yeah, I guess that would make sense (sorry, should have included originally).

We are on DB2 V5.1 OS/390, so triggers are not currently available to us. We have a Developer who wants a datastor created something like this:

cust-id, product-id, effective-date, termination-date, status(maybe)

If inserting a new customer into the table, then no checks need to be made. If inserting a new row that already has a row in it with the same cust-id, then the old row must have a termination-date, and the new row must have an effective date greater (not equal) than the old rows termination-date. [...] 18979 92 36_Re: accessing DB2 V6.1 from Db2 UDB.22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 28 Nov 2000 19:01:22 -0500346_- Myron -

Your correct you must install & configure DB2 Connect to access DB2 for OS/390. You don't need DB2 UDB PE to access DB2 for OS/390.

You need DB2 Connect to access DB2 for OS/390 data.

The DB2 UDB PE engine does not access DB2 for OS/390.

One application that uses DB2 Connect is the DB2 Control Center. [...] 19072 129 21_Re: VALIDPROC example15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 29 Nov 2000 01:01:23 +0000311_us-ascii Hello Marcus,

You asked for a sample in COBOL... However, exit routines (validproc is one) must be written in assembler... Also, you are not allowed to use ANY DB2 services in exit routines, so SQL is out of the question and I don't think you can perform the checks you need any other way. [...] 19202 22 14_-DIS DB output0_14_DPetro@AOL.COM29_Tue, 28 Nov 2000 19:15:06 EST554_US-ASCII Hi,

Even with LIMIT(*) I am getting maxed out on the amount of lines displayed on a -DIS DB(....) command. The amount of output I can display varies during the day. The message description indicates the amount of output is limit 'by the space available'. What space is this??

Thanks. Dave.

================================================ 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. 19225 50 15_Re: CURRENTDATA22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 28 Nov 2000 19:17:02 -0500508_iso-8859-1 Search the DB2-L archives (http://jupiter.ryci.com/archives/db2-l.html) for CURRENTDATA(NO). Chris Munson from the IBM labs wrote an excellent explanation of CURRENTDATA. I believe it was sometime in January 2000.



Mike Piontkowski TP&S Technical Maintenance Voice: +1 302.886.4612 Fax: +1 302.886.4749



-----Original Message----- From: mrk theni [mailto:mrktheni@HOTMAIL.COM] Sent: Tuesday, November 28, 2000 12:27 To: DB2-L@RYCI.COM Subject: [DB2-L] CURRENTDATA [...] 19276 78 12_Re: Packages14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 29 Nov 2000 11:47:01 +1100367_iso-8859-1 Ronald,

There are a couple of critical questions:

1) how are subroutines invoked - by a static link are a dynamic link/load? If you statically link subroutines, then what happens when the subroutine is re-compiled? Do you: a) relink every main program which calls the subroutine; or b) relink main programs on some sort of ad-hoc basis. [...] 19355 69 18_Re: -DIS DB output15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 29 Nov 2000 11:50:54 +1100381_- Hi Dave,

This might be useful. From the front of the Command Reference:

2.4 Output from DB2 Commands

The amount of output that you receive from a DB2 command is always less than 256KB. The following factors determine the maximum amount of output you can receive:

The amount of storage available to your DB2 subsystem or to an individual command. [...] 19425 14 45_Carol Rentschler-CH/PGI is out of the office.16_Carol Rentschler20_rentschler.ch@PG.COM31_Tue, 28 Nov 2000 22:40:19 -0500365_us-ascii I will be out of the office from 11/27/2000 until 12/04/2000.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.