1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2000, week 1
2 70 19_Re: LOCKPART clause7_Sanjeev21_Sanjeev@INTERRAIT.COM30_Tue, 1 Aug 2000 12:33:30 +0530521_iso-8859-1 Hi Venkat,<br><br>Sorry for this content in my previous mail : "I believe the highest level of escalation is Tablespace locks (if LOCKPART=YES) and Partitions(if LOCKPART = NO)." Instead it is reverse.Highest level of escalation is Tablespace locks (if LOCKPART=NO) and Partitions(if LOCKPART = YES)<br><br>Regards<br><br>Sanjeev<br><br>-----Original Message----- From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] Sent: Monday, July 31, 2000 7:25 PM To: DB2-L@RYCI.COM Subject: Re: LOCKPART clause [...]
73 435 46_Re: AW: Enforcing uniqueness on partial column11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Tue, 1 Aug 2000 18:15:23 +1000361_iso-8859-1 James,<br><br>you DO mean DB2 - the little one. UDB V7 (UNO) supports generated columns, and they can be generated from a substring (or any other scalar function, among many other things). However, you do end up with the additional column in the table, so you don't save any space, just application logic since DB2 maintains the column for you. [...]
509 102 42_R: Problem with program binded DEGREE(ANY)15_Michele Granito29_michele.granito@ISTRUZIONE.IT30_Tue, 1 Aug 2000 10:15:08 +0200362_iso-8859-1 Hi Sanjeev,<br><br>thanks for the help, the problem has been resolved applying PTFs UQ43423, UQ44792 and UQ43002. After REBIND of program with EXPLAIN the columns ACCESS_DEGREE and ACCESS_PGROUP_ID on the PLAN_TABLE, have value NULL. Before applying PTFs the columns indicated the use of parallelism (ACCESS_DEGREE = 9 and ACCESS_PGROUP_ID = 1). [...]
612 36 16_Re: QMF question11_Roland Owen20_Roland.Owen@UBSW.COM30_Tue, 1 Aug 2000 04:29:24 -0500627_- Judi - there is a contrived way round this.<br><br>Define conditions at F.COND as: ID CONDITIONAL EXPRESSION --- ----------------------------- 1 &DSQAO_NUM_FETCHED>0 2 &DSQAO_NUM_FETCHED=0<br><br>Go to F.DET and define adjust variation 1 to be selected only when rows are returned ie "Select Panel Variation? ===> C1".<br><br>Increment the Var count in the top right corner to create a second 'variation' definition - to be used when no rows are found. Specify C2 for its "Select panel variation?", turn off headings, and set the "put data at line .." to NONE. In the "detail heading text" section put the text you want [...]
649 17 5_Views13_Skelton Brian20_skelton.b@MELLON.COM30_Tue, 1 Aug 2000 06:03:18 -0400366_- Could anyone tell me if you create a view and don't qualify this. Where would this be stored ?<br><br>Regards<br><br>Brian<br><br>================================================ 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.
667 30 9_Re: Views18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Tue, 1 Aug 2000 06:06:36 -0400402_- All views are "stored" in the catalog. The views owner (or schema) would default to the id you used to connect to the database.<br><br>-----Original Message----- From: Skelton Brian [mailto:skelton.b@MELLON.COM] Sent: Tuesday, August 01, 2000 6:03 AM To: DB2-L@RYCI.COM Subject: Views<br><br><br><br>Could anyone tell me if you create a view and don't qualify this. Where would this be stored ? [...]
698 224 48_Bonnie Baker at SIRDUG (Charlotte, NC) 8/24-8/2511_Paul Turpin22_pault704@EARTHLINK.NET30_Tue, 1 Aug 2000 05:17:46 -0500688_ISO-8859-1 SIRDUG Southeastern Inter-Relational Database Users' Group P.O. BOX 34641 Charlotte, NC 28234<br><br>Website: http://users.vnet.net/sirdug Email: SIRDUG@VNET.NET Information/Message Line: (704) 556-6621<br><br><br><br>Meeting Announcement ========================================================================<br><br>WHEN? Thursday, August 24th & Friday, August 25th<br><br>WHERE? Charlotte Marriott Executive Park 5700 Westpark Dr. Charlotte NC 28217 704) 527-9650<br><br>COST? $175 each day cash or check, in advance or at the door. We do not Invoice and we do not accept credit cards. (the two seminars are separate so you are welcome to attend one or both seminars) [...]
923 30 18_Re: R: DB2 Locking10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Tue, 1 Aug 2000 05:26:23 -0500372_- Hello,<br><br>'LOCK TABLE' is an SQL statement which you would need to include in your application programs. I can see that if you have several programs, then it may be a pain to include it in all of them, but it can pay large dividends in terms of reduced locking overhead, and is sometimes essential in order to stay below NUMLKUS. The statement looks like this: [...]
954 128 25_Stored Procedure Question13_Brunner Don J21_Don.J.Brunner@IRS.GOV30_Tue, 1 Aug 2000 06:46:52 -0400603_iso-8859-1 I'm in the process of testing stored procedures between two OS/390 DB2s on different machines. I want to use the DB2 managed stored procedures address space. The messages below are appearing in the Master address space whenever I attempt to execute the stored procedure on that box:<br><br>DSNX967I -DB2T DSNX9OPN ATTEMPT TO PERFORM WLM FUNCTION JOIN FAILED WITH WLM RC = 00000008 RSN = 033A0810 SSN = DB2T PROC= ASID = 00000158 WLM_ENV = DSNX967I -DB2T DSNX9CLO ATTEMPT TO PERFORM WLM FUNCTION LEAVE FAILED WITH WLM RC = 00000008 RSN = 033D0810 SSN = DB2T PROC= ASID = 00000158 WLM_ENV [...]
1083 68 88_Re: August 9th - Performance Estimation Class - Tim Lenahan - Last call for registration16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Tue, 1 Aug 2000 06:21:02 -0400573_iso-8859-1 Yes, please check out www.db2-syposium.com for this November.<br><br>> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > craig patton > Sent: Wednesday, July 26, 2000 7:16 AM > To: DB2-L@RYCI.COM > Subject: Re: August 9th - Performance Estimation Class - Tim Lenahan - > Last call for registration > > > Cathy, > > I will be unable to attend this class. I believe I had indicated > interest, > but we have a major project going into production that week and I > am unable > to take the time off. > > See [...]
1152 20 28_Re: DB2 Call Attach Facility0_23_pjackson@SUMMITBANK.COM30_Tue, 1 Aug 2000 07:56:28 -0000534_us-ascii To All,<br><br>Thanks for your responses - the problem turned out to be that one of our previous MVS systems programmers put the DB2 Call Attach Facility in the LINKLIST so that ENDEVOR would not need STEPLIB.<br><br>Once we added a Version 6 STEPLIB all was OK.<br><br>Thanks again.<br><br>================================================ 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.
1173 80 38_Re: (Fwd) (Fwd) Re: LX, NSYSLX - Day 223_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Tue, 1 Aug 2000 12:57:23 +0100601_iso-8859-1 I think I put the details of a couple of fixes to do with this last week ... check in the archives.<br><br>Les<br><br>-----Original Message----- From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] Sent: Monday, July 31, 2000 11:57 PM To: DB2-L@RYCI.COM Subject: (Fwd) (Fwd) Re: LX, NSYSLX - Day 2<br><br><br><br>------- Forwarded message follows ------- From: "Edward(Ed) J. Finnell, III " <efinnell@seebeck.ua.edu> Organization: Seebeck Computer Center To: db2-l@ryci.cim Date sent: Mon, 31 Jul 2000 17:55:15 -0500 Subject: (Fwd) Re: LX, NSYSLX - Day 2 Priority: normal [...]
1254 18 9_Re: Views14_Jean W Stimmel25_jwstimmel@DUKE-ENERGY.COM30_Tue, 1 Aug 2000 08:10:27 -0400353_us-ascii Default database = 'DSNDB06'; Default tablespace = 'SYSVIEWS'.<br><br>View text is stored in: SYSIBM.SYSVIEWS catalog table.<br><br>When view is created, at that point it is just a catalog entry into a couple of catalog tables - its "data" doesn't exist until it gets materialized, i.e. when you access it and it presents the data report. [...]
1273 142 29_Re: Stored Procedure Question0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Tue, 1 Aug 2000 07:18:59 -0500466_us-ascii <br><br><br><br>When you compiled and linkedit your stored procedure do you include DSNALI in your link edit? Thats the include for DB2 established Stored procedure.<br><br>If you used DSNRLI, thats the include for WLM stored procedures.<br><br>I thought I read that DB2 stored procedures are no longer being enhanced by IBM and they are encouraging shops to go to WLM stored procedures, as there are many more advantages to them that I won't go into. [...]
1416 270 29_Re: Stored Procedure Question13_Brunner Don J21_Don.J.Brunner@IRS.GOV30_Tue, 1 Aug 2000 08:27:05 -0400505_iso-8859-1 Shan,<br><br>Thanks for replying. The stored procedure is link-edited with DSNALI, and both DB2s are at V6. This is a test of receiving a result set back from a stored procedure, and I wanted to keep the setup as simple as possible.<br><br>-----Original Message----- From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM [mailto:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] Sent: Tuesday, August 01, 2000 8:19 AM To: DB2-L@RYCI.COM Subject: Re: Stored Procedure Question [...]
1687 41 9_Re: Views13_Skelton Brian20_skelton.b@MELLON.COM30_Tue, 1 Aug 2000 09:26:54 -0400602_- Thanks for this just one more question in order to create a view would you need create table authority ? and is there any way you could let people create views but stop them creating tables.<br><br>Regards<br><br><br><br>Brian > -----Original Message----- > From: Jean W Stimmel [SMTP:jwstimmel@DUKE-ENERGY.COM] > Sent: Tuesday 01 August 2000 13:10 > To: DB2-L@RYCI.COM > Subject: Re: Views > > > Default database = 'DSNDB06'; Default tablespace = 'SYSVIEWS'. > > View text is stored in: SYSIBM.SYSVIEWS catalog table. > > When view is created, at that point it is just a catalog entry into a > [...]
1729 65 9_Re: Views12_craig patton21_prgpatton@HOTMAIL.COM28_Tue, 1 Aug 2000 13:38:34 GMT604_- You do not need to be able to create tables to create views. The view creator simply needs SELECT on the table. (If it is an UPDATE view the the user needs THAT table auth too.)<br><br>HTH, Craig Patton<br><br><br><br>>From: Skelton Brian <skelton.b@MELLON.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: Views >Date: Tue, 1 Aug 2000 09:26:54 -0400 > >Thanks for this just one more question in order to create a view >would you need create table authority ? >and is there any way you could let people create views but stop them >creating tables. > [...]
1795 12 16_alter tablespace0_27_Bud.Greenman@ONONDAGA.NY.US30_Tue, 1 Aug 2000 09:43:09 -0400420_- I need to alter some tablespaces to increase the priqty and secqty. Will the alter command take effect at extent time if the stogroup is SMS managed? We are on DB2 V4 on OS/390<br><br>================================================ 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.
1808 33 9_Re: Views14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM30_Tue, 1 Aug 2000 06:45:35 -0700349_iso-8859-1 Brian, If you look at the SQL reference, for each statement, the required Authorization is clearly stated. To create a view, SELECT privilege on ALL tables and columns referenced in the view is required. Hope this helps Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
1842 77 9_Re: Views14_Jean W Stimmel25_jwstimmel@DUKE-ENERGY.COM30_Tue, 1 Aug 2000 09:50:16 -0400676_us-ascii Be careful on your authorities...you can update the underlying tables if you update the view - SELECT ONLY on the view/tables is a good idea.<br><br><br><br><br><br>|--------+-----------------------> | | Skelton Brian| | | <skelton.b@ME| | | LLON.COM> | | | | | | 08/01/00 | | | 09:26 AM | | | Please | | | respond to | | | DB2 Data Base| | | Discussion | | | List | | | | |--------+-----------------------> >----------------------------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: Jean W Stimmel/Corp/DukeEnergy) | | Subject: Re: Views | >----------------------------------------------------------------------------| [...]
1920 40 20_Re: alter tablespace11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM30_Tue, 1 Aug 2000 08:52:32 -0500330_us-ascii no, you will have to have a PTF on to issue the Alter dynamically. Otherwise you have to -STO, Alter and -STA the tablespace. Even then, it will not take effect until a reorg or load is done. Consider online reorg, especially in your test environments. Sorry, I don't have the PTF number for the alter modification. [...]
1961 49 20_Re: alter tablespace12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Tue, 1 Aug 2000 15:03:00 +0100446_- Any new extents will be based on the new size, to change existing extents a reorg is required<br><br>Colin Allen Abbey National ---------- From: Bud.Greenman@ONONDAGA.NY.US To: DB2-L@RYCI.COM Subject: [DB2-L] alter tablespace Date: 01 August 2000 02:43PM<br><br>I need to alter some tablespaces to increase the priqty and secqty. Will the alter command take effect at extent time if the stogroup is SMS managed? We are on DB2 V4 on OS/390 [...]
2011 66 9_Re: Views16_Michael McCarthy18_mmccarthy@DTCC.COM30_Tue, 1 Aug 2000 10:02:51 -0400639_us-ascii To create a view, all you need is select on the table(s) involved. Of course you won't be able to do anything but select from it.<br><br>-Mike.<br><br><br><br><br><br><br><br><br><br>Skelton Brian <skelton.b@MELLON.COM> on 08/01/2000 09:26:54 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Michael McCarthy/DTC) Subject: Re: [DB2-L] Views<br><br><br><br><br><br><br><br>Thanks for this just one more question in order to create a view would you need create table authority ? and is there any way you could let people create views but stop them creating tables. [...]
2078 49 20_Re: alter tablespace11_Gerd Wetzel21_gerd.wetzel@DEBIS.COM30_Tue, 1 Aug 2000 15:54:18 +0200569_iso-8859-1 No, you have to make an REORG TABLESPACE.<br><br>Regards<br><br>Gerd Wetzel<br><br><br><br>Bud.Greenman@ONONDAGA.NY.US schrieb:<br><br>> I need to alter some tablespaces to increase the priqty and secqty. Will the > alter command take effect at extent time if the stogroup is SMS managed? We > are on DB2 V4 on OS/390 > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
2128 146 53_Repost: A Couple of Recent DB2-Related Press Releases13_Morrill, John12_JohnM@VP.NET30_Tue, 1 Aug 2000 08:19:59 -0600520_iso-8859-1 -----Original Message----- From: dbswift@us.ibm.com [mailto:dbswift@us.ibm.com] Sent: Tuesday, August 01, 2000 7:54 AM To: DB2_Interested_Parties@us.ibm.com Subject: A Couple of Recent DB2-Related Press Releases<br><br><br><br><br><br><br><br>Dear DB2 Interested Parties,<br><br>Thought some of you might be interested in these recent press releases (full text below):<br><br>o "TurboLinux Launches Dataserver With IBM DB2 Universal Database" o "IBM Smokes Oracle in Race for Windows 2000 Certification" [...]
2275 32 107_Repost: DBAs and developers: "Solutions 2000, the IBM Technical D eveloper Conference" has 25+ DB2 sessions13_Morrill, John12_JohnM@VP.NET30_Tue, 1 Aug 2000 08:26:07 -0600451_iso-8859-1 Dear DB2 Interested Parties,<br><br>Some of you and your colleagues may be interested in attending "Solutions 2000, The IBM Technical Developer Conference", August 14-17 in Las Vegas at the MGM Grand Conference Center. There are over 25 DB2 seminars and hands-on tutorial sessions at the event.<br><br>View the DB2 session offerings, conference information and register at http://www-4.ibm.com/software/data/events/ibmsolutions.html . [...]
2308 22 17_archive log error12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Tue, 1 Aug 2000 09:40:28 -0500384_iso-8859-1 We received the following error message: DSNAME=DB2Q.ARCHLOG2.B0000681, ERROR STATUS=4714041D, SMS REASON CODE=00000000 DSNJ115I -DB2Q OFFLOAD FAILED, COULD NOT ALLOCATE AN ARCHIVE DATA SET<br><br>DB2 is stopped due to the fact that it cannot allocate an archive data set. But I cannot find the error message anywhere....does anyone know what this error status means? [...]
2331 50 42_Re: Enforcing uniqueness on partial column14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Tue, 1 Aug 2000 09:53:09 -0500530_iso-8859-1 Isaac:<br><br>Yes, thanks for correcting my horrible grammar!<br><br>And yes, your LOAD solution works as long as both columns (the original and the SUBSTR of the original) are in the same table (which is, I think, what the original post implied).<br><br>Cheers, Craig S. Mullins BMC Software http://www.bmc.com http://www.craigsmullins.com ------------------------------<br><br>Date: Mon, 31 Jul 2000 19:45:07 +0200 From: Isaac Yassin <yassin@NETVISION.NET.IL> Subject: Re: Enforcing uniqueness on partial column [...]
2382 45 21_Re: archive log error41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR30_Tue, 1 Aug 2000 11:56:15 -0300459_iso-8859-1 We often receive that message when our DASD is out of space. Provide more space for your achive files or try issuing an HMIGRATE for them. This might solve your problem.<br><br>Good luck, Claudio<br><br><br><br><br><br>-----Mensagem original----- De: Vernon, John <John.Vernon@TRS.STATE.TX.US> Grupos de notícias: bit.listserv.db2-l Para: DB2-L@RYCI.COM <DB2-L@RYCI.COM> Data: Terça-feira, 1 de Agosto de 2000 11:35 Assunto: archive log error [...]
2428 79 42_Re: Enforcing uniqueness on partial column12_craig patton21_prgpatton@HOTMAIL.COM28_Tue, 1 Aug 2000 15:03:21 GMT401_- FYI, I haven't seen all of the posts for this one, but has anyone suggested a FIELDPROC as a possible solution?? The user could code to accept the original data, then based on some criteria, could make the data unique for the colunm, guaranteed by a unique index defined on the column. Not the BEST solution, but if coded properly, this could provide the user with the resolution being sought. [...]
2508 48 21_Re: archive log error11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Tue, 1 Aug 2000 10:05:16 -0500458_us-ascii Check the allocation status of your SMS volumes. We had one mounted Private vs. Storage and it caused us problems... : )<br><br><br><br><br><br><br><br>From: "Vernon, John" <John.Vernon@TRS.STATE.TX.US>@RYCI.COM> on 08/01/2000 09:40 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>To: DB2-L@RYCI.COM cc: Fax to: Subject: archive log error [...]
2557 31 21_Re: archive log error14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM30_Tue, 1 Aug 2000 08:05:38 -0700459_iso-8859-1 The 4714041D is a dynamic allocation error, look for SVC 99 documentation. It is in the Authorized Assembler Services Guide. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.<br><br><br><br>We received the following error message: DSNAME=DB2Q.ARCHLOG2.B0000681, ERROR STATUS=4714041D, SMS REASON CODE=00000000 DSNJ115I -DB2Q OFFLOAD FAILED, COULD NOT ALLOCATE AN ARCHIVE DATA SET [...]
2589 22 16_Websphere on AIX13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Tue, 1 Aug 2000 09:56:14 -0500359_- We have Websphere running on an AIX box. Websphere uses a UDB database called WAS which is created during install. This database is set up with circular logging. I understand that circular logging is the preferred method on test databases, but not on production ones. Also, I understand that in order to back up one, you have to stop all access to it. [...]
2612 91 20_Re: alter tablespace0_19_Tim.Lowe@STPAUL.COM30_Tue, 1 Aug 2000 09:30:38 -0500406_us-ascii Ray, I think that the APAR you are referring to is PQ04053, and the DB2 V5 PTF is UQ06309 from back in June of 97. But, I do not think that this was ever retrofitted back to V4.<br><br>Thanks, Tim<br><br><br><br><br><br><br><br><br><br><br><br><br><br>Ray H Janes <ray_h_janes@EMAIL.MOBIL.COM> on 08/01/2000 08:52:32 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
2704 110 28_Re: DB2 Call Attach Facility11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Tue, 1 Aug 2000 11:22:08 -0400458_iso-8859-1 It looks like you may have a old STEPLIB in ENDEVOR. Yes DSNHDECP does have version information. Here is a dump of a V5 one. Many OEM products that have to connect to multiple DB2 sub-systems can handle different versions as long as the proper level is identified. The product documentation would indicate what sort of loadlib concatenation is required. Does ENDEVOR have any configuration settings for the level of DB2 it is connecting to ? [...]
2815 58 15_Re: DB2 Locking17_Fiorese Giampaolo29_Fiorese.Giampaolo@GENERALI.IT30_Tue, 1 Aug 2000 17:44:48 +0200451_iso-8859-1 No, you can't have such a statement executed under the command processor and athen execute youy batch pgm. You have to code it into your program and put some logic if it should be executed or not depending on external conditions.<br><br>Regards<br><br><br><br><br><br>-----Original Message----- From: Charles Jambrosic [SMTP:Charles_Jambrosic@CSIHOME.COM] Sent: Monday, July 31, 2000 6:20 PM To: DB2-L@RYCI.COM Subject: R: DB2 Locking [...]
2874 49 21_Re: archive log error14_Jack O'Connell26_jack.oconnell@MCMASTER.COM30_Tue, 1 Aug 2000 10:53:11 -0500579_iso-8859-1 Usually this is due to the SMS Pool allocated for DB2Q.ARCHLOG2.* dsns filled up. You must either add volumes to the SMS storagegroup or remove old dsns in the pool that these dsns reside. If you must remove old dsns though, unless you own the dsns and are positive the dsns won't be re-used, back them up before deleting them. Old archive dsns are recalled frequently. Also review the ARCRETN=, MAXARCH= , parms in the latest DSNTIJU* job in the DB2Q.SDSNSAMP ( ? or whatever the naming convention is for SDSNSAMP ). These parm control the days the ARCHLOGs are [...]
2924 36 32_QISTCOLS counter became wild....14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Tue, 1 Aug 2000 18:00:22 +0100318_us-ascii We migrated some DB2s from V 4 to V 5. All was OK (more or less) but we noted that suddenly a STATISTICS counter,<br><br>QISTCOLS jumped from 0 to an high value after migration.<br><br>It seems that V5 introduced some modifications in SQL and for this reason there are many invalid SELECT procedures. So [...]
2961 37 15_IDENTITY column10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Tue, 1 Aug 2000 10:58:23 -0500307_- Has anybody out there defined a table with a column 'AS IDENTITY' in DB2 for OS/390 yet? This feature was made available in the Version 6 refresh of May 2000.<br><br>We are running DB2 Version 6.1 for OS/390 (RML May 2000), and I encounter the following when attempting to define an IDENTITY column: [...]
2999 42 34_Isolation level of UR (dirty read)18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Tue, 1 Aug 2000 12:21:36 -0400562_iso-8859-1 Could use a little clarification if possible. We are current running DB2 V5 OS/390 with the latest maint. on our system test subsystems. I'm also running Datajoiner V2 on an NT server that connect to DB2 OS/390. Here's my question: We are using 'packages' that are bound with an isolation level of UR (dirty read) at the clients workstation. (this was recommended by IBM). Now when the client launches an SQL stmt through Datajoiner I can see it using the package that is set for UR. But when I look at the rest of the TMON (monitor for DB2 that [...]
3042 51 38_Re: Isolation level of UR (dirty read)14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM30_Tue, 1 Aug 2000 09:37:43 -0700460_iso-8859-1 Do the packages contain any DYNAMIC SQL STATEMENTS? If so, the PREPAREs are done with CS and will take locks on the catalog. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.<br><br>-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Tuesday, August 01, 2000 11:22 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Isolation level of UR (dirty read) [...]
3094 67 20_Re: Websphere on AIX0_22_BILL_GALLAGHER@PHL.COM30_Tue, 1 Aug 2000 12:57:06 -0400608_us-ascii Shauna,<br><br>We are also running Websphere on AIX, and we are using archival logging. All you need to do to enable archive logging is to set the "logretain" database configuration parameter to "1" for "recovery logging". It's probably a good idea to also archive the log files once you enable recovery logging, otherwise your log files may take over your system. To do this, you will need to modify and compile the "db2uext2" exit, and enable it via the "userexit" database configuation parameter. There are a couple of sample "db2uext2" exits shipped with the product, you should be able to [...]
3162 67 21_Re: archive log error12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Tue, 1 Aug 2000 12:05:24 -0500391_iso-8859-1 Thanks for all the help with the archive log problem, it turned out that we needed to allocate additional volumes to the stogroup (3390 NOT 3380!)....what a great help this list is!<br><br>john<br><br>-----Original Message----- From: Jack O'Connell [mailto:jack.oconnell@MCMASTER.COM] Sent: Tuesday, August 01, 2000 10:53 AM To: DB2-L@RYCI.COM Subject: Re: archive log error [...]
3230 69 38_Re: Isolation level of UR (dirty read)0_20_John_Lendman@FPL.COM30_Tue, 1 Aug 2000 13:04:18 -0400456_us-ascii Also in order to do UR you need to have Type 2 indexes. Ensure that all indexes are Type 2. John<br><br><br><br><br><br><br><br>"Whittaker, Stephen" <stephen.whittaker@CPLC.COM>@RYCI.COM> on 08/01/2000 12:21:36 PM<br><br>Please respond to "DB2 Data Base Discussion List" <DB2-L@RYCI.COM><br><br>Sent by: "DB2 Data Base Discussion List" <DB2-L@RYCI.COM><br><br><br><br>To: DB2-L@RYCI.COM cc:<br><br>Subject: Isolation level of UR (dirty read) [...]
3300 11 20_Re: Alter tablespace0_27_Bud.Greenman@ONONDAGA.NY.US30_Tue, 1 Aug 2000 14:14:21 -0400369_- Thanks for all the responses. I reorged the TS after running the alter and the space allocation was altered to what I wanted.<br><br>================================================ 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.
3312 19 19_Re: IDENTITY column0_19_valeriet@US.IBM.COM30_Tue, 1 Aug 2000 14:13:19 -0400269_us-ascii If you read the SQL Reference manual, Vol. II, p. 543, it states: "You must specify GENERATED for a column with a row id data type (or a distinct type that is sourced on a row ID data type). Do not specify GENERATED for columns with any other data type." [...]
3332 68 19_Re: IDENTITY column8_Dan Tuck18_dan_tuck@YAHOO.COM30_Tue, 1 Aug 2000 11:21:54 -0700568_us-ascii My class example has NOT NULL as part of the identity definition.<br><br>--- John Hardy <john_j_hardy@CONSULTANT.COM> wrote: > Has anybody out there defined a table with a column > 'AS IDENTITY' in DB2 > for OS/390 yet? This feature was made available in > the Version 6 refresh of > May 2000. > > We are running DB2 Version 6.1 for OS/390 (RML May > 2000), and I encounter > the following when attempting to define an IDENTITY > column: > > CREATE TABLE > TBGTEMP1 > (TEMP1_IDENTITY INTEGER > GENERATED BY DEFAULT AS > IDENTITY, > TEMP1_DATA CHAR (200) [...]
3401 17 19_Re: IDENTITY column0_19_valeriet@US.IBM.COM30_Tue, 1 Aug 2000 14:24:51 -0400483_us-ascii I apologize -- I am wrong. I didn't read the note carefully; I overlooked the "refresh".<br><br>Valerie J. Traurig, DB2 Education Specialist phone: (301) 240-3007 t/l 8-372-3007 Lnotes: IBMUSM35(valeriet) E-mail: valeriet@us.ibm.com<br><br>================================================ 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.
3419 52 19_Re: IDENTITY column13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 1 Aug 2000 14:49:01 -0400673_iso-8859-1 John, Here's an Alter statement I've successfully used to add an Identity column to an existing table.<br><br>ALTER TABLE SPINSERT ADD ID DECIMAL(18) GENERATED ALWAYS AS IDENTITY (START WITH 9999999999,INCREMENT BY -1)<br><br>Note that if there's data in the table when you alter add an ident column, you get<br><br>SQLCODE = 610, WARNING: A CREATE/ALTER ON OBJECT BFHDJS1.TEMPINT HAS PLACED OBJECT IN REORG PENDING ------------------------------------------------ I've also taken your DDL and executed it successfully. See below. I thought the identity apars were supposed to be included in the RML. You should check for sure. I believe PTF UQ38405 is the [...]
3472 114 75_Increase table col width - new tablespace - new nodegrp?? -- buffer pool???16_Mandar Ghosalkar27_mghosalkar@STAFF.EINDIA.COM30_Tue, 1 Aug 2000 11:42:02 -0700764_iso-8859-1 Hi DB2 guys,<br><br><br><br>i need to alter a table and increase its varchar column to 6000 bytes.<br><br>db2 => list nodegroups<br><br>NODEGROUP NAME ---------------------------- IBMCATGROUP IBMDEFAULTGROUP IBMTEMPGROUP<br><br>While creating the tablespace i got the following error.<br><br>db2 => CREATE TABLESPACE USERSPACE2 PAGESIZE 16K MANAGED BY SYSTEM using ('/export/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0003.0') DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1582N The PAGESIZE of the table space "USERSPACE2" does not match the PAGESIZE of the bufferpool "IBMDEFAULTBP" associated with the table space. SQLSTATE=428CB db2 => [...]
3587 128 78_Re: Increase table col width - new tablespace - new nodegrp?? --buffer pool???13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Tue, 1 Aug 2000 14:15:23 -0500489_US-ASCII Mandar, Create another bufferpool with a larger pagesize like 8k and alter the tablespace to use that bufferpool. HTH Kurt<br><br>>>> mghosalkar@STAFF.EINDIA.COM 08/01/00 01:42PM >>><br><br>Hi DB2 guys,<br><br><br><br>i need to alter a table and increase its varchar column to 6000 bytes.<br><br>db2 => list nodegroups<br><br>NODEGROUP NAME ---------------------------- IBMCATGROUP IBMDEFAULTGROUP IBMTEMPGROUP<br><br>While creating the tablespace i got the following error. [...]
3716 60 79_Re: Increase table col width - new tablespace - new nodegrp?? -- buffer pool???13_Fletcher, Jim21_jim.fletcher@BSIS.COM30_Tue, 1 Aug 2000 15:18:30 -0400348_iso-8859-1 You need to create a bufferpool that can handle the 16K page size for the tablespace. Use the CREATE BUFFERPOOL statement with the appropriate PAGESIZE parm. Then specify the new bufferpool in your tablespace statement. I believe you will need to disconnect all applications from the database for the new bufferpool to take effect. [...]
3777 29 28_DB2 Connect "Zero Footprint"13_Tierney, Mark20_mtierney@FIRSTAM.COM30_Tue, 1 Aug 2000 14:38:01 -0500325_- Greetings All............<br><br>I received some marketing material from an IBM rep regarding DB2 Connect/EE and was curious about the "zero client footprint" indicated on V6+. This sounds as if there is no code loaded on the client side. Does anyone have experience with this and/or know if Zero actually means Zero? [...]
3807 38 24_DB2 DBA looking for work13_Dayna Brennan25_Dayna.Brennan@STATE.MN.US30_Tue, 1 Aug 2000 16:41:30 -0500345_iso-8859-1 DB2 DBA with 5+ years OS/390 DBA experience and 10+ years DB2 experience overall. Leaving current position, looking for a new position in the Twin Cities area (Minneapolis and St. Paul, Minnesota).<br><br>Experience in all phases of design, both logical and physical, as well as SQL tuning and all backup/recovery functionality. [...]
3846 73 78_Re: Increase table col width - new tablespace - new nodegrp?? --buffer pool???12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 1 Aug 2000 15:08:29 -0700541_us-ascii I was just playing with this today, and 8K was the max page size I could set a BP to using version 5.2 of UDB on AIX , although the Control Center also shows 16 and 32K as options. Tim<br><br>--- Kurt Sahlberg <Kurt.Sahlberg@EXPERIAN.COM> wrote: > Mandar, > Create another bufferpool with a larger pagesize > like 8k > and alter the tablespace to use that bufferpool. > HTH > Kurt > > >>> mghosalkar@STAFF.EINDIA.COM 08/01/00 01:42PM >>> > > Hi DB2 guys, > > > i need to alter a table and increase its varchar > column to 6000 [...]
3920 49 20_Re: Websphere on AIX12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 1 Aug 2000 15:13:33 -0700554_us-ascii To take an online backup you need to have archival logging enabled. Tim --- Shauna Hadden <shauna.hadden@BCBSKS.COM> wrote: > We have Websphere running on an AIX box. Websphere > uses a UDB database > called WAS which is created during install. This > database is set up > with circular logging. I understand that circular > logging is the preferred > method on test databases, but not on production > ones. Also, I understand > that in order to back up one, you have to stop all > access to it. > > How has everyone else resolved this? Is [...]
3970 59 18_Re: R: DB2 Locking17_Charles Jambrosic29_Charles_Jambrosic@CSIHOME.COM30_Tue, 1 Aug 2000 17:57:48 -0700449_us-ascii Since we just want to test the differences in our batch stream with the lock alternatives we'll initially use the alter tablespace and then try the programming approach with the lock table sql statement.<br><br>Thanks for the responses!<br><br>---------------------- Forwarded by Charles Jambrosic/CSI on 08/01/2000 05:52 PM ---------------------------<br><br><br><br>John Hardy <john_j_hardy@CONSULTANT.COM> on 08/01/2000 03:26:23 AM [...]
4030 14 15_Re: DB2 Locking12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 1 Aug 2000 20:35:49 -0500475_- If you want the batch application to lock the entire table, then the LOCK TABLE statement is more direct than altering the definition. You could even lock a specific partition with the statement.<br><br>Roger Miller, DB2 for OS/390<br><br>================================================ 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.
4045 20 63_Re: How to get value of INSERTed NOT NULL WITH DEFAULT column ?12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 1 Aug 2000 20:57:26 -0500563_- If you mean the identity column, then look up the IDENTITY_VAL_LOCAL function. In SG24-6108, the page number is 86 on my pdf file.<br><br>"In many applications, you will need to know the value DB2 has generated for the identity column. Most commonly this will be when tables in a referential set (either application or DB2 maintained) are populated in one unit of work. An example would be to create an order number and order lines for that order. The order number would be required to create the order lines. This function is introduced by APAR PQ36328." [...]
4066 25 33_Re: I'm in trouble - DB2v6 OS/39012_Roger Miller19_millerrl@US.IBM.COM30_Tue, 1 Aug 2000 21:10:32 -0500502_- I have a one-step-back question. First let's presume that you did put on all of the V5 preconditioning APARs. Why change the steplibs now? Here's a paragraph from the Installation Guide.<br><br>"You can attach to multiple releases of DB2 with your existing TSO or CAF logon procedures,without changing the load libraries for your applications. After you migrate completely to the latest level of DB2,you MUST update those procedures and jobs to point to the latest level of DB2 load libraries." [...]
4092 18 42_Re: Installing a DB2 subsystem - Continued12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 1 Aug 2000 21:24:44 -0500388_- The primary questions about whether something will fit is the amount of white space left (cpu, memory & disk) compared to the work load you want to run.<br><br>There is a section of the Installation Guide titled Installing a Second DB2 on the Same Operating System. My V5 hard copy has it on page 2-252, as it tries to use the planning and work from the DB2 that is already there. [...]
4111 20 28_Re: Turn of Archive logging!12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 1 Aug 2000 21:56:44 -0500540_- If you do this and make one more simple mistake (have a long running unit of work that rolls back or ...), then you get to use restore tapes for the complete subsystem or reinstall the subsystem.<br><br>On the other hand if you don't care about your data, then you can chase this down in the macros, use single logging, ... The reason we will never document or support the parameter is that customers will say that someone recommended using the parameter that lost the data. I recommend that you avoid using this if at all possible. [...]
4132 76 19_Re: IDENTITY column14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 2 Aug 2000 18:00:27 +1000609_iso-8859-1 John,<br><br>Have you also created SYSIBM.SYSSEQUENCES and SYSSEQUENCESDEP? If not, read the doco in UQ38405.<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au<br><br>-----Original Message----- From: John Hardy [mailto:john_j_hardy@CONSULTANT.COM] Sent: Wednesday, August 02, 2000 1:58 AM To: DB2-L@RYCI.COM Subject: [DB2-L] IDENTITY column<br><br><br><br>Has anybody out there defined a table with a column 'AS IDENTITY' in DB2 for OS/390 yet? This feature was made available in the Version 6 refresh of May 2000. [...]
4209 18 24_MSSQL Listserver Address15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM30_Wed, 2 Aug 2000 15:17:49 +1000382_- Hello fellow DB2-ers,<br><br>Would anyone know if the MS SQL Listserver is still active and how one would subscribe ?<br><br>thanks, Steve<br><br>================================================ 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.
4228 47 63_Re: How to get value of INSERTed NOT NULL WITH DEFAULT column ?13_Philip Nelson21_teamdba@ATTGLOBAL.NET30_Wed, 2 Aug 2000 10:15:44 +0100597_us-ascii Roger,<br><br>Thanks for the reply - unfortunately I can't find a similar function in UDB for AIX - anybody know if there is one ?<br><br>Phil<br><br>On Tue, 1 Aug 2000 20:57:26 -0500, Roger Miller wrote:<br><br>>If you mean the identity column, then look up the IDENTITY_VAL_LOCAL >function. In SG24-6108, the page number is 86 on my pdf file. > >"In many applications, you will need to know the value DB2 has generated for >the identity column. Most commonly this will be when tables in a referential >set (either application or DB2 maintained) are populated in one unit of >work. [...]
4276 44 52_DSNP031I - no docs on this .. anybody know about it?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 2 Aug 2000 10:45:39 +0100342_iso-8859-1 Anybody have any information on a new message that appeared in our DB2 V6 system today ..<br><br>we are really happy about it having it come out .. max extents being nearly reached etc .. but we cannot find it in any of the manuals - it must be very new. We also cannot find it in any of the recent V65 maintenance hold data. [...]
4321 82 56_Re: DSNP031I - no docs on this .. anybody know about it?15_Toine Michielse18_vndobtm@US.IBM.COM30_Wed, 2 Aug 2000 12:19:01 +0100553_us-ascii Hello Les,<br><br>I suggest you download the new version of the Messages and Codes from : http://www-4.ibm.com/software/data/db2/os390/v6books.html<br><br>The message description is in that version of the manual,<br><br>Regards,<br><br><br><br>Toine Michielse DB2 for OS/390 Technical Specialist Silicon Valley Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS<br><br><br><br>"Pendlebury-Bowe, Leslie" <Leslie.Pendlebury-Bowe@EU.SONY.COM>@RYCI.COM> on 08/02/2000 10:45:39 AM [...]
4404 100 56_Re: DSNP031I - no docs on this .. anybody know about it?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 2 Aug 2000 11:28:34 +0100482_iso-8859-1 thanks<br><br>..interesting but the support centre did not know about it either.<br><br>Les<br><br>-----Original Message----- From: Toine Michielse [mailto:vndobtm@US.IBM.COM] Sent: Wednesday, August 02, 2000 12:19 PM To: DB2-L@RYCI.COM Subject: Re: DSNP031I - no docs on this .. anybody know about it?<br><br><br><br>Hello Les,<br><br>I suggest you download the new version of the Messages and Codes from : http://www-4.ibm.com/software/data/db2/os390/v6books.html [...]
4505 106 56_Re: DSNP031I - no docs on this .. anybody know about it?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 2 Aug 2000 11:40:45 +0100327_iso-8859-1 we have just raised a change request to have this changed so that it is in ZPARM and thus allows you to set your own value for when the message comes out.<br><br>IBM have just let us know that it comes out 5 extents before 251 or 119 (max) - if something is expanding that quickly then this is of little use .. [...]
4612 60 47_DB2 Disaster Recovery Enhancement Press Release10_Lee Mandel16_DBMSUser@AOL.COM28_Wed, 2 Aug 2000 07:10:19 EDT654_US-ASCII DB2 Disaster Recovery Enhancement Press Release<br><br>Recovery Knowledge is please to announce GENDB2 Release 2.0 with enhancements to automate the creation of complete Job JCL and Control Cards to (A) Register the latest Archive log. (B) Delete/Newlog Active Logs. (C) Conditional Restart ENDRBA This is done without the customer interface. These enhancements will aid the customer in a faster recovery of the DB2 System at their Disaster Recovery Site. This is a Recovery Tool that will display all the different recovery points of a Tablespace by Image Copies, Quiesced RBA, Timestamp, Etc., Etc. It will also simplify and automate the [...]
4673 33 17_Need Rexx Samples25_CAPLIN Philippe (UA 1101)32_philippe.caplin@BANQUE-FRANCE.FR30_Wed, 2 Aug 2000 13:50:50 +0200460_- Hi DB2 Community !<br><br>I'm looking for some Rexx samples for DB2 OS/390 Version 5. If anyone can give me some URLs or some examples, it will help me.<br><br><br><br>TIA, PhilCap :-)<br><br><br><br>************************************************************** Ce mel est a l'attention exclusive des destinataires designes. Il peut contenir des informations confidentielles. Si vous le recevez par erreur, merci d'en informer sans delai l'expediteur. [...]
4707 69 21_Re: Need Rexx Samples23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 2 Aug 2000 13:09:41 +0100530_iso-8859-1 Phil<br><br>we need some details of what types of things you wish to see ...<br><br>you could always buy the book on Mike Cowlishaw<br><br>http://www.amazon.com/exec/obidos/ASIN/0137806515/qid=965218069/sr=1-2/103-2 700317-9861430<br><br>what I use all the time ... or you can look at the manuals online ..<br><br>Les<br><br>-----Original Message----- From: CAPLIN Philippe (UA 1101) [mailto:philippe.caplin@BANQUE-FRANCE.FR] Sent: Wednesday, August 02, 2000 12:51 PM To: DB2-L@RYCI.COM Subject: Need Rexx Samples [...]
4777 285 29_Re: Stored Procedure Question0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Wed, 2 Aug 2000 07:41:37 -0500362_us-ascii <br><br><br><br>It was worth a try. I'll include the checklist I give programmer when they are creating a WLM stored procedure. I don't have time to see what would be done differently if it was a DB2 stored procedure but perhaps it might give you an idea of something else that needs to be done. (This checklist was for V5 and will change for V6.) [...]
5063 19 21_Re: Need Rexx Samples14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Wed, 2 Aug 2000 14:49:29 +0100459_us-ascii It's a little generic request. Please specify what kind of REXX ECECs you need.<br><br>To execute SQL statements ? To execute DDL statements ? To call DSNALI and IFI via REXX ?<br><br>Regards<br><br>Mx Scarpa<br><br>================================================ 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.
5083 407 21_Re: Need Rexx Samples11_rick creech18_ykcirc@HOTMAIL.COM28_Wed, 2 Aug 2000 13:12:06 GMT545_- Phil, Here is one that I wrote recently:<br><br>/************************* rexx appfilt ***************************\ * author: rick creech department: dba * * * * description: * * This is a db2 rexx for verifying that plans * * issuing dynamic sql are being filtered. * * Previous to this rexx, the load307 data is * * generated from apptune trace tapes. * * For each plan that has issued dynamic sql, if * * the plan name does not exist in the db2 table * * that contains all plans being filtered then an * * entry is made in the sysout [...]
5491 50 63_How to store UNICODE data in a DB2 for OS/390 Version 5 table ?12_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 2 Aug 2000 15:41:28 +0200416_iso-8859-1 Hi all.<br><br>We have the need to store character data in a special format - UNICODE.<br><br>UNICODE is a double-byte-character set ;-(<br><br>I think there is no way to declare a "DBCS column format" in a CREATE TABLE column definition under DB2 for OS/390 Version 5.<br><br>What is the column definition solution here ? Declaring VARCHAR(xxxx) MIXED DATA or declaring VARCHAR(xxxx) FOR BIT DATA ? [...]
5542 37 38_DB2 UDB Application Development Client17_Mark A. Phillippi28_mphillippi@SENTRY-DIRECT.COM30_Wed, 2 Aug 2000 08:54:23 -0500430_us-ascii We are moving into the realm of developing DB2 applications on WIN NT to access DB2 data in UDB on WIN NT and DB2 OS/390. We are using V6.1 of DB2 Connect and DB2 UDB. I'm confused about the licensing requirements for our DB2 developers. I continue to get mixed messages from IBM reps and although this has been touched on in the archives back in January, I don't see a final resolution so I'm bringing it up again. [...]
5580 16 33_X.400 Inter-Personal Notification18_Sridhar Adusumilli32_Sridhar.Adusumilli@PEARSONTC.COM30_Wed, 2 Aug 2000 09:50:45 -0400420_- Your message to was received at 02 Aug 2000 09:57:45 -0400<br><br>This notification was generated Manually The following extra information was given: RE: DB2 on OS/390 from WEB<br><br>================================================ 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.
5597 50 21_QISTCOLS: who knows ?14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Wed, 2 Aug 2000 16:05:28 +0100327_us-ascii I repost this mail because there was an error in the previous.<br><br>We migrated some of our 43 DB2s from V 4 to V 5.<br><br>All was OK (more or less) but we noted that suddenly a STATISTICS counter, QISTCOLS jumped from 0 to an high value<br><br>after migration. In SDSNMACS the description of this counter is: [...]
5648 45 32_DB2 for OS390 Upgrade- V6 or V7?12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Wed, 2 Aug 2000 10:28:56 -0400410_iso-8859-1 Hello,<br><br>We are in the process of planning an upgrade to DB2 on OS390 V1.3. We are currently on V5 with a put level of 9805. We are not in any immediate need of the new features in V6 or V7, but we have had some query performance problems, sporadic 0C4 abends that bring DB2 down and we need some of the functionality V5 maintenance would provide (changing passwords via DDF for example). [...]
5694 34 17_DSNUTILS Question8_Kurian B23_Bejoy_Kurian@MAY-CO.COM30_Tue, 1 Aug 2000 16:33:02 -0500628_us-ascii Hi List,<br><br>Our shop run on DB2V6 with os390 v2r6. We have an automated process to run load utility jobs using DSNUTILS stored procedure. This job runs fine when running one job. When running multiple load jobs the 2nd job returns with file in use. The output is shown below.<br><br>IKJ56246I DATA SET XXX.SWSAL.STDTYN NOT ALLOCATED, FILE IN USE IKJ56861I FILE SYSREC NOT UNALLOCATED, DATA SET IS OPEN IKJ56861I FILE SYSMAP NOT UNALLOCATED, DATA SET IS OPEN IKJ56861I FILE SYSERR NOT UNALLOCATED, DATA SET IS OPEN IKJ56861I FILE SYSUT1 NOT UNALLOCATED, DATA SET IS OPEN IKJ56861I FILE SORTOUT NOT UNALLOCATED, [...]
5729 434 21_FW: Need Rexx Samples17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM30_Wed, 2 Aug 2000 10:50:24 -0400348_- I've put together a sample DB2 REXX program with various examples and useful subroutines that can be copied into any REXX program needed to access DB2. See REXX code below:<br><br>/* REXX */ /* DB2 REXX INTERFACE SUBROUTINES AND EXAMPLES */ TRACE OFF /*----------------------*/ SSID = "DB2T" CALL DB2_CONNECT SSID /*----------------------*/ [...]
6164 87 67_Re: How to store UNICODE data in a DB2 for OS/390 Version 5 table ?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 2 Aug 2000 10:02:56 -0500594_iso-8859-1 Hi Georg, I'm sorry to relay to you that UNICODE support, according to the last rumor I heard, was scheduled for DB2 V8 or higher. You might press your sales rep for better/more info.<br><br>Regards, Rick Davis<br><br>"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 [...]
6252 77 36_Re: DB2 for OS390 Upgrade- V6 or V7?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 2 Aug 2000 16:09:57 +0100269_iso-8859-1 Robert<br><br>unless you are happy to wait until this time next year I would go to V6 .. as V7 will not be out and stable until 1Q01 or 2Q01 .. my opinion only but I find V6 to be ok and we hammer the hell out of it in a SAP Datasharing environment ... [...]
6330 78 36_Re: DB2 for OS390 Upgrade- V6 or V7?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 2 Aug 2000 10:13:21 -0500294_iso-8859-1 Hi Robert, Majority opinion is that V6, at the current refreshed level, is a stable release. See the archives for more info. My question is whether or not you can upgrade to DB2 V6 (which is what I would recommend you do by the way) under OS390 V1.3?<br><br>Regards, Rick Davis [...]
6409 94 36_Re: DB2 for OS390 Upgrade- V6 or V7?12_Kirk Hampton16_khampto1@TXU.COM30_Wed, 2 Aug 2000 10:19:50 -0500539_us-ascii <rant mode on> I have been turning in problems to IBM on version 6 constantly since January. If a few more of you whiners would get in the game here with me and get a little bloody, there would be an end to the "concerns about the stability of V6". In our environment there has been no such thing as a "stable" maintenance level of DB2, because even if we never change our software, the workload will shift or someone here will code some dynamic SQL that will FIND a problem. <rant mode off > ...whew... well, I feel better. [...]
6504 74 36_Re: DB2 for OS390 Upgrade- V6 or V7?11_Ron Johnson25_rjohnson@DATA-TRONICS.COM30_Wed, 2 Aug 2000 10:26:39 -0500540_iso-8859-1 Robert, I would suggest at least applying maintenance to V5. I'm pretty sure you lack the needed prereqs to go to V6 at your current V5 level. You would also gain the functionality you mentioned within V5. As far as going to V6 versus waiting for V7... we are currently trying to make that decision. My thoughts are that V6 is stable enough but question whether or not there is a need for the new functionality within the next year or so. If there is not a need, I'd consider waiting until V7 and save the money and time it [...]
6579 88 25_Re: QISTCOLS: who knows ?22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Wed, 2 Aug 2000 11:31:32 -0400618_iso-8859-1 Max -<br><br>Search the DB2-L archives for "invalid select". There was a discussion about this last year which basically points to the "Considerations for Rebinding Certain Plans and Packages in Chapter 5.3 in the DB2 for OS/390 Administration.<br><br>When we upgraded, the invalid select count was high and was isolated to a small number of plans and packages. We created a report from IFCID 0244 that ranked from high to low the number of occurrences of invalid selects for each plan and package and rebound them in that order. Tracing IFCID 0244 did not cause a performance problem, especially once [...]
6668 31 26_SQLCODE -904 during insert13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Wed, 2 Aug 2000 11:38:36 EDT412_- Hi list, Attempt to insert a row into a table produces a -904 reason code 200. I checked the status of the tablespace and it is "A"ctive. I also checked the status for the table and it is blank (no parent index defined):<br><br>(1) The catalog space column for the tablespace is zero '0' and I'll like to know if perhaps that is the reason for the -904 error I get while trying to insert into this table? [...]
6700 176 36_Re: DB2 for OS390 Upgrade- V6 or V7?12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 2 Aug 2000 08:43:04 -0700380_us-ascii You might have to apply the maintenance to V5 just to be able to upgrade to V6. See II12343 for recommended maintenance prior to upgrading to V6.<br><br>I don't know about going to V7 and what shape it will be in. But considering that it won't be GA for some time, unless you want to wait until probably 2q 2001 to get it, it probably is not an option at this time. [...]
6877 77 25_Re: QISTCOLS: who knows ?12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 2 Aug 2000 08:46:06 -0700549_us-ascii One question: Generally as part of the upgrade, there are a number of action items for some of the maintenance that is part of the upgrade. Quite often, one of the action items is to REBIND all plans and packages as some PTFs require this. Did you do this REBIND all when you upgraded? Did you check the action items for the maintenance to see if this REBIND was required? --- Massimo Scarpa <Massimo_Scarpa@DEBIS.IT> wrote: > I repost this mail because there was an error in the > previous. > > We migrated some of our 43 DB2s from V [...]
6955 210 36_Re: DB2 for OS390 Upgrade- V6 or V7?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 2 Aug 2000 16:53:46 +0100428_iso-8859-1 I refer to your comments :<br><br>>is a fairly simple shop with no data sharing involved, but lots of DDF and parallel processing.<br><br>in my experience DDF and parallel prcoessing have been nightmares no matter what shop I have been in and to that end I recomended and forced people to refuse switching it on here ... I repeat V6 is in and stable here but for how much longer it shall last I do not know :-)) [...]
7166 100 36_Re: DB2 for OS390 Upgrade- V6 or V7?0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 2 Aug 2000 10:53:50 -0500462_us-ascii Don't forget the discussion we had a few months ago. IBM announced that starting in V7 (OS/390) they will be charging for utilities that are currently part of the base price. But they were vague about the actual pricing and which utils would be 'free' and which would be priced separately. It may or may not have a significant effect on the bottom line cost of upgrading V7 so it's probably something you want to add to your cost benefit analysis. [...]
7267 24 32_Re: DB2 Connect "Zero Footprint"14_Philip Gunning18_pgunning@PHEAA.ORG30_Wed, 2 Aug 2000 11:55:29 -0400415_us-ascii Mark, I am not familiar with the "Zero Footprint" but this is probably referring to running the client from a codeserver. That way only the directories are maintained on the client. The executables are downloaded at runtime from the codeserver. For more information look in the Installation and Configuration Supplement which describes the various types of install and configuration options. HTH Phil [...]
7292 29 28_Re: MSSQL Listserver Address0_12_jimh@QIS.NET30_Wed, 2 Aug 2000 11:57:14 -0400419_- Interesting. The only "list" I could find was here:<br><br>http://www.swynk.com/discuss_home/<br><br>Otherwise most of the posting I see on that topic happens on usenet at:<br><br>microsoft.public.sqlserver.server<br><br><br><br>>At 03:17 PM 8/2/00 +1000, Mallett, Steven said: >Hello fellow DB2-ers, > >Would anyone know if the MS SQL Listserver is still active and how one would >subscribe ? > >thanks, >Steve [...]
7322 65 30_Re: SQLCODE -904 during insert12_craig patton21_prgpatton@HOTMAIL.COM28_Wed, 2 Aug 2000 16:08:27 GMT481_- Carlton,<br><br>Can you print more of the message?<br><br>The '0' in the catalog for space is NOT the cause of your problem. Check to see how many extents you have for your VSAM file, check the DASD volume it is allocated to and make sure there is space available for another extent. Is this STOGROUP or VSAM defined? (A 'Y' in the IMPLICIT column in SYSTABLESPACE indicates that it was created using a STOGROUP.) If using a STOGROUP, check that all the volumes have space. [...]
7388 23 36_Re: DB2 for OS390 Upgrade- V6 or V7?0_17_JTonchick@AOL.COM28_Wed, 2 Aug 2000 12:30:15 EDT362_US-ASCII I suggest that you apply the maintenance to V5 as soon as your schedules allow.<br><br>1) you need to be current whether or not you decide to migrate to v6 or v7. 2) you "problems" might be fixed with the maintenance. 3) some of the v6 features have been added to v5 with the 9/1999 special maintenance release check the DB2 web pages for details. [...]
7412 138 36_Re: DB2 for OS390 Upgrade- V6 or V7?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 2 Aug 2000 16:32:18 +0100490_iso-8859-1 ...sorry Kirk but I have to disagree. We have V6 working flat out in a "very" dynamic environment - SAP .. if anything is going to kill it SAP will and to be honest so far so good. Our system is one of if not the biggest of it's type in the world (twin ZZ7s) .. (excuse the biggest in the world comment as I hate every saying these sorts of things without being able to back it up .. and I cannot back it up).....We have problems with V6 PM .. lots of them .. but not V6 in [...]
7551 60 54_Re: Stored Procedures & DB2 Dev/Test/Prod Environments13_Michalik, Ken19_kmichalik@KRAFT.COM30_Wed, 2 Aug 2000 11:48:48 -0500452_- We are waiting for V6 schemas.<br><br>In the meantime, we have a set of tables with one column with one character...the envrionment that the calling program is running in. The particular table that is accessed depends on its stage, each of which has its own quailfier... TEST, QA, UNIT,....<br><br>The letter returned is modifies the SP base name in a host variable used in an SQL CALL :host_var. So in test, the SP called is TSP1, in QA, QSP1. [...]
7612 104 30_Re: SQLCODE -904 during insert13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Wed, 2 Aug 2000 12:55:48 EDT940_- Hi Craig, Thanks for the response. Here's a screen print of the error message:<br><br>INSERT INTO PYT.PTMT_CUST_REF (ACCOUNT_ID, ROW_TIMESTAMP) VALUES('TEST','2000-07-21-03.03.03.000000'); ---------+---------+---------+---------+---------+---------+---------+-------- DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200, AND RESOURCE NAME DBPTTMT01 .PTCMT033 DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -110 13172746 0 13223106 -974970879 12714050 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9C4C2' X'C5E32001' X'00C20042' SQL DIAGNOSTIC INFORMATION ---------+---------+---------+---------+---------+---------+---------+-------- DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 [...]
7717 126 30_Re: SQLCODE -904 during insert11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM30_Wed, 2 Aug 2000 11:58:44 -0500485_us-ascii Take an image copy...c90097 says to do that. Reads will work, but no DML<br><br><br><br><br><br><br><br>Carlton Enuda <carltonenuda@HOTMAIL.COM> on 08/02/2000 11:55:48 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Ray H Janes/C/Dallas/Mobil-Notes) Subject: Re: SQLCODE -904 during insert<br><br><br><br><br><br><br><br><br><br>Hi Craig, Thanks for the response. Here's a screen print of the error message: [...]
7844 76 30_Re: SQLCODE -904 during insert0_28_Roy_Bertossi@ABERCROMBIE.COM30_Wed, 2 Aug 2000 13:21:44 -0400687_us-ascii Carlton,<br><br>The 200 was probably the resource type - tablespace. The reason code is a 8 digit number.<br><br>Roy ---------------------------------------------------------- Roy Bertossi Abercrombie & Fitch Senior Database Analyst (614) 577-6372<br><br><br><br>|--------+--------------------------> | | Carlton Enuda | | | <carltonenuda@HO| | | TMAIL.COM> | | | Sent by: DB2 | | | Data Base | | | Discussion List | | | <DB2-L@RYCI.COM>| | | | | | | | | 08/02/00 11:38 | | | AM | | | Please respond | | | to DB2 Data Base| | | Discussion List | | | | |--------+--------------------------> >----------------------------------------------------------------------------| | | [...]
7921 73 21_Re: DSNUTILS Question0_22_BILL_GALLAGHER@PHL.COM30_Wed, 2 Aug 2000 13:08:05 -0400502_us-ascii Bejoy,<br><br>I know it is possible to run multiple DSNUTILS at one time, but I have not tried to do it myself. Here's a quote from a PMR that I had open with IBM a couple of months ago that may have some pertinent info:<br><br>"You must run DSNUTILS with NUMTCB=1. In Goal mode with a high enough priority (i.e. shorter runtime) WLM will start multiple address spaces to run multiple DSNUTILS. NUMTCB=2 won't work for DSNUTILS however, ... Goal mode is required to autostart processes." [...]
7995 21 30_DB2 for AIX Upgrade- V6 or V7?12_Ragam, Sai J18_Sai.Ragam@BNSF.COM30_Wed, 2 Aug 2000 12:21:12 -0500360_iso-8859-1 Has anybody considered migrating to V7 instead of V6 from V5 in the mid-tier world(Unix). Any comments, problems, suggestions etc. will be appreciated. I see a lot a benefits in terms of data joiner and db2 being integrated into one product apart from lot of other benefits. Has anybody migrated to v7 from v5 directly or considering to do so? [...]
8017 57 32_Re: DB2 Connect "Zero Footprint"13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Wed, 2 Aug 2000 12:57:34 -0500347_iso-8859-1 Mark,<br><br>I heard something about this at IDUG, but I don't know the details. I think it involves using a file server for the DLL's, and LDAP for the config/directory information. I'd like more info on this as well. Is there really no code on the client at all? How would client machines know to look or where to look for LDAP? [...]
8075 135 30_Re: SQLCODE -904 during insert13_Helen Johnson25_helen_johnson@RAC.RAY.COM30_Wed, 2 Aug 2000 13:15:02 -0500444_us-ascii Here are some possible reasons you need a copy run.<br><br>00C90097<br><br>Explanation: An attempt was made to allocate to a table space for update operations. However, the table space was marked as 'image copy' required, and updates are not allowed. This condition occurs as a result of any of the following:<br><br>Running a REORG LOG NO or LOAD LOG NO utility on the table space without running a copy that specifies FULL YES. [...]
8211 36 51_Refresh 1 subsystem from another subsys - DB2 OS39015_Miller, Dale E.15_dmiller@UGI.COM30_Wed, 2 Aug 2000 15:36:25 -0400593_us-ascii I have been given the task of developing a process for copying all data from a PRODUCTION DB2 subsystem and loading it into a QA subsystem for the purpose of "parallel" testing. This is not a once-and-done situation. We must be able to periodically "refresh" the QA subsystem from Production. I have considered developing JCL to unload one DB at a time from PROD and loading into QA. I have also considered SNAPSHOT to copy the entire subsystem. My problem is that even with SNAPSHOT, I cannot shutdown DB2 or even change the TS's to Read-Only (availability issues). This raises [...]
8248 289 36_Re: DB2 for OS390 Upgrade- V6 or V7?12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 2 Aug 2000 13:03:05 -0700530_us-ascii Our parallel processing is very small and limited in scope. I doubt if there are 10 tables that will invoke parallel processing. And probably less than that number that are partitioned. We've been just dipping our feet into to it.<br><br>IBM, Roger and others, have been touting how much parallel processing is, so we have been testing it on very limited basis. I think its really amusing that here's a feature that IBM is pushing that still doesn't work well enough that most shops are avoiding it like the plague. [...]
8538 15 32_Re: DB2 Connect "Zero Footprint"14_Philip Gunning18_pgunning@PHEAA.ORG30_Wed, 2 Aug 2000 16:03:09 -0400536_us-ascii Additionally, DB2 Connect for Windows 2000 will use the Windows directory allowing the database catalog information to be stored there, thus with that you will probably have the "Zero Footprint." You might want to check the announcement for DB2 Connect V7 for further details. HTH Phil<br><br>================================================ 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.
8554 79 55_Re: Refresh 1 subsystem from another subsys - DB2 OS3909_Rob Crane22_racrane@CONCENTRIC.NET30_Wed, 2 Aug 2000 14:31:33 -0600489_us-ascii If you have any 3rd Vendor tools you have lots of options depending on what you own. I am assuming that you do not have any of these products.<br><br>With the absence of 3rd vendor tools I will think that you will find the unloading of any substantial amount of data is going to take to much time and CPU to be worth the trouble. Depending on what you normally do for your production backup's you may have the ability to use what is already in place to build your QA system. [...]
8634 140 30_Re: SQLCODE -904 during insert11_Robert Jans21_Jans.Robert@AMSTR.COM30_Wed, 2 Aug 2000 13:22:00 -0600637_- The reason code says an image copy is required.............<br><br>******************** Text Below Copyright (c) 2000, IBM *****************<br><br>00C90097<br><br>Explanation: An attempt was made to allocate to a table space for update operations. However, the table space was marked as 'image copy' required and updates are not allowed. This condition occurs as a result of any of the following: o Running a REORG LOG NO or LOAD LOG NO utility on the table space without running a copy that specifies FULL YES. o Execution of a RECOVER utility which specifies the TORBA or TOCOPY options, without following it with the required [...]
8775 44 55_Re: Refresh 1 subsystem from another subsys - DB2 OS3909_Ray Potts23_rpotts@MAIL.STATE.MO.US30_Wed, 2 Aug 2000 15:53:21 -0500610_us-ascii Use DSN1COPY to refresh the QA subsystem databases from Production Image copies. Your downtime for Production for this process is your currently scheduled Image copy jobs.<br><br><br><br>"Miller, Dale E." wrote:<br><br>> I have been given the task of developing a process for copying all data from a > PRODUCTION DB2 subsystem and loading it into a QA subsystem for the purpose of > "parallel" testing. This is not a once-and-done situation. We must be able to > periodically "refresh" the QA subsystem from Production. I have considered > developing JCL to unload one DB at a time from PROD and [...]
8820 300 26_Visual Explain - off topic23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Wed, 2 Aug 2000 17:59:36 -0400386_iso-8859-1 Hi all,<br><br>This is not exactly DB2 related, but some of you may have faced this problem. The Flow Chart in Visual Explain shows overlapped boxes. It used to work alright on my PC, until today. I tried un-install/re-install, but it didn't help. Can anyone suggest what might be wrong. I suspect something on NT side is wrong, but then all other GUI stuff works fine. [...]
9121 66 14_Recovery Tools0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Wed, 2 Aug 2000 18:29:30 -0500474_us-ascii We were curious if a tool exists that can read through log records and filter out and apply log records from a dropped table to a newly created table.<br><br>I don't believe DB2 allows you to apply log records from a dropped table to a newly created table (and please correct me if I'm wrong). I thought that DB2 invalidates the log records in SYSLGRNX when it drops the tablespace and deletes all related entries in Syscopy and various other Catalog tables.. [...]
9188 90 18_Re: Recovery Tools24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Wed, 2 Aug 2000 16:34:16 -0700652_- You might try looking into CA-Platinum Log Analyzer. I believe BMC has a product also. I'm not sure if either of them would work with dropped tables, but since they read the log files directly, I'd be surprised if they didn't.<br><br>> -----Original Message----- > From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM > [SMTP:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] > Sent: Wednesday, August 02, 2000 4:30 PM > To: DB2-L@RYCI.COM > Subject: Recovery Tools > > We were curious if a tool exists that can read > through log records and filter out and apply log > records from a dropped table to a newly created table. > > I [...]
9279 124 18_Re: Recovery Tools13_OConner, John26_John.OConner@COURTS.WA.GOV30_Wed, 2 Aug 2000 17:29:38 -0700547_iso-8859-1 We use BMC LogMaster and we recently discovered something interesting. If your table is compressed, the tool uses the compression dictionary from an image copy that was taken around the time the logs were written. We keep logs for 60 days and image copies for 14 days. So, for our compressed tables, we can only get information from the logs for 14 days back. I think there's a similar constraint for tables that have been altered since the logs were written. There are some features in the works at BMC to improve this situation. [...]
9404 153 21_Re: Need Rexx Samples14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 3 Aug 2000 13:36:05 +1000704_iso-8859-1 Here's a V6 snippet that you might find usefull:<br><br><br><br>display_sqlca: procedure /*display formatted sqlca */, expose sqlcode sqlerrmc sqlerrp sqlerrd. sqlwarn. , sqlstate trace 'n' /* display formatted SQLCA<br><br>arg(1), if provided, SQL text arg(2), if provided, text explanation of SQL statement<br><br>James Campbell, Hansen Corporation, 2000 */ do __i = 2 to arg() if arg(__i) <> '' then say arg(__i) end if right(sqlerrmc,1) <> 'ff'x then sqlerrmc = sqlerrmc || 'ff'x /* rebuild a 'real' sqlca */ message_llen = 79 message_lines = 10 realsqlca = 'SQLCA ' upper realsqlca realsqlca = realsqlca , ||x2c(d2x(136,8)) , ||x2c(d2x(sqlcode,8)) , ||x2c(d2x(length(sqlerrmc),4)) , [...]
9558 63 37_Links about DB2 for OS/390 (08/03/00)6_DB2usa18_db2usa@HOTMAIL.COM30_Wed, 2 Aug 2000 23:53:12 -0500538_ISO-8859-1 Hi,<br><br>Here is a non-profit website about DB2 for OS/390 (IBM mainframes):<br><br>- English : http://www.citeweb.net/db2usa/eliendb2.htm - Français: http://www.citeweb.net/db2usa/liendb2.htm<br><br>Last update on Thursday, August 3rd 2000 ========================================<br><br>- Links about DB2 for OS/390: http://www.citeweb.net/db2usa/eliste.htm Poll results: Which DB2 version do you use in production (total votes: 188). We'll do it again in six months. New poll: Do you use Data Sharing in production ? [...]
9622 55 23_Re: Performance Figures15_Douwe van Sluis20_d.b.vansluis@KPN.COM30_Thu, 3 Aug 2000 08:36:18 +0200622_- Hi Rick,<br><br>Take a look at Redbook "DB2 for OS/390 Capacity Planning, SG24-2244-00". In chapter 3, you'll find some calculation you may find interesting. Have fun.<br><br>Kind regards, Douwe van Sluis<br><br>> ---------- > Van: DAVIS, RICK (SBCSI)[SMTP:RD8246@MOMAIL.SBC.COM] > Antwoord naar: DB2 Data Base Discussion List > Verzonden: maandag 31 juli 2000 17:53 > Aan: DB2-L@RYCI.COM > Onderwerp: Performance Figures > > Hi all and TIA, > Does anyone have any performance figures, or know where to find > any, > on INSERT and UPDATE to the bufferpool and UPDATE misses? > I thought sure I saw something in one [...]
9678 328 36_Re: DB2 for OS390 Upgrade- V6 or V7?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 3 Aug 2000 08:01:11 +0100294_iso-8859-1 Myron<br><br>we site applying every bit of maintenance that comes out every week .. we have to as I say it "sit past the leading edge". But I can put my hand on my heart and say I am happy so far ..<br><br>DDF .. well we could all bang on about this .. problem after problem .. [...]
10007 35 34_SAP 4.5B to 4.6B migration problem13_Adelino Regio28_adelino.regio@EDINFOR.EDP.PT30_Thu, 3 Aug 2000 01:37:09 -0500574_- Greetings<br><br><br><br>We are in the process of migrating a SAP R/3 on DB2 for OS/390 system from version 4.5B to version 4.6B. We have noticed that the ICLI server 4.6B address space is consuming a lot of CPU power. Our monitoring tools (such as Mainview) are reporting the ICLI RRS threads as being in DB2, but without any type of activity inside DB2. The last SQL statement reported is an INSERT. So far, we have not been able to spot any timeout or deadlock situation. There are no unavailable resources too. ICLI 4.6B seems to have hanged itself (it's running [...]
10043 38 34_SAP 4.5B to 4.6B migration problem13_Adelino Regio28_adelino.regio@EDINFOR.EDP.PT30_Thu, 3 Aug 2000 07:30:12 +0100581_us-ascii Greetings<br><br><br><br>We are in the process of migrating a SAP R/3 on DB2 for OS/390 system from version 4.5B to version 4.6B. We have noticed that the ICLI server 4.6B address space is consuming a lot of CPU power. Our monitoring tools (such as Mainview) are reporting the ICLI RRS threads as being in DB2, but without any type of activity inside DB2. The last SQL statement reported is an INSERT. So far, we have not been able to spot any timeout or deadlock situation. There are no unavailable resources too. ICLI 4.6B seems to have hanged itself (it's running [...]
10082 79 38_Re: SAP 4.5B to 4.6B migration problem23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 3 Aug 2000 08:10:56 +0100293_iso-8859-1 Adelino<br><br>We are doing 4.6C migration as we speak .. 2.8 OS390 , DB2 V6 MRL 3 +ptfs etc.<br><br>We have not seen excessive CPU utilization from our ICLIs. ... Have you looked on OSS to see if there are any other sites that have had this problem? I suggest that you do ... [...]
10162 192 63_Re: How to get value of INSERTed NOT NULL WITH DEFAULT column ?11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Thu, 3 Aug 2000 17:08:44 +1000542_- Yes, apparently V7 GA has it, too. (It was not in the first beta release.)<br><br>Cheers, Ulrich<br><br>> -----Original Message----- > From: Philip Nelson [SMTP:teamdba@attglobal.net] > Sent: Wednesday, August 02, 2000 7:16 PM > To: DB2-L@RYCI.COM > Subject: Re: How to get value of INSERTed NOT NULL WITH DEFAULT > column ? > > Roger, > > Thanks for the reply - unfortunately I can't find a similar function in > UDB for AIX - anybody know if there is one ? > > Phil > > On Tue, 1 Aug 2000 20:57:26 -0500, Roger Miller wrote: > > >If [...]
10355 158 7_DB2 & C19_Christos Berberidis18_berber@CSD.AUTH.GR30_Thu, 3 Aug 2000 10:20:20 +0300207_windows-1253 I am a young data miner (wannabe). Can anyone help me on finding how to connect a C program with DB2? Or to use C with db2 6.1. Any reference would be great.<br><br>Thank you in advance Christos
10514 100 55_Re: Refresh 1 subsystem from another subsys - DB2 OS39012_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Thu, 3 Aug 2000 09:06:00 +0100532_- We use an approach which is nowhere near as efficient but is more tolerant of differences between the two environments, as we find that the developers only want to do this to test a new release against 'production' data:<br><br>1. Generate a list of all tables in Production 2. Edit the list to remove tables you don't want 3. Run a REXX against the list to produce multiple unload and load jobs, 100 tables per job, all data to tape, load decks to DASD. 4. Run unloads 5. Edit load decks to match table changes 6. Run loads [...]
10615 20 21_Re: Need Rexx Samples15_Philippe CAPLIN32_philippe.caplin@BANQUE-FRANCE.FR30_Thu, 3 Aug 2000 03:11:07 -0500403_- In fact, I want to know if Rexx/SQL can help me to build some simple automated tools in our Production (I've been using it for 2 days). Actually, this kind of Rexx Execs read the result of DSNTEP2 programm or DSN Subcommands. I would prefer to do all of this in one pass. The IBM documentation (Rexx Language Support) is a little bit poor to give me the informations I need (my opinion only...). [...]
10636 28 11_Re: DB2 & C30_Ramesh Padmanabha, AMB Chennai34_ramesh_padmanabha@MSDC.HCLTECH.COM30_Thu, 3 Aug 2000 14:10:29 +0530467_- Use MQ-Series and try to establish the connectivity with DB2. I think this works Ramesh P > -----Original Message----- > From: Christos Berberidis [SMTP:berber@CSD.AUTH.GR] > Sent: Thursday, August 03, 2000 12:50 PM > To: DB2-L@RYCI.COM > Subject: DB2 & C > > I am a young data miner (wannabe). > Can anyone help me on finding how to connect a C program with DB2? > Or to use C with db2 6.1. > Any reference would be great. > > Thank you in advance > Christos [...]
10665 16 21_Re: Need Rexx Samples14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Thu, 3 Aug 2000 10:32:00 +0100329_us-ascii Try DB2WWWX to automate some production tools<br><br>Regards<br><br>Max Scarpa<br><br>================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10682 63 21_Re: Need Rexx Samples14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 3 Aug 2000 19:03:26 +1000321_iso-8859-1 You should be able to use DSN subcommands (ie those that start with a hyphen) using Rexx/SQL - but it would be a bit messy.<br><br>You'ld do this by coding the subcommand as an IFI command, with the other IFI parameters, and then using a rexx LINKPGM to DSNWLIR. Any output would be in the return buffer. [...]
10746 75 38_Re: SAP 4.5B to 4.6B migration problem0_29_paul.packham@POSTOFFICE.CO.UK30_Thu, 3 Aug 2000 10:16:12 +0000396_us-ascii Adelino,<br><br>We have done an upgrade to SAP 4.6B in a number of DB2 Subsystems and haven't seen any significant increase in ICLI CPU consumption, however our upgrade path was from 3.1I. I can't imagine what your problem might be other than a possible rollback ?<br><br>Regards, Paul<br><br><br><br><br><br><br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
10822 107 38_Re: SAP 4.5B to 4.6B migration problem23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 3 Aug 2000 10:42:43 +0100588_iso-8859-1 Paul<br><br>but if it was then you would see MSTR going mad????<br><br>Les<br><br>-----Original Message----- From: paul.packham@POSTOFFICE.CO.UK [mailto:paul.packham@POSTOFFICE.CO.UK] Sent: Thursday, August 03, 2000 11:16 AM To: DB2-L@RYCI.COM Subject: Re: SAP 4.5B to 4.6B migration problem<br><br><br><br>Adelino,<br><br>We have done an upgrade to SAP 4.6B in a number of DB2 Subsystems and haven't seen any significant increase in ICLI CPU consumption, however our upgrade path was from 3.1I. I can't imagine what your problem might be other than a possible rollback ? [...]
10930 159 18_Re: Recovery Tools24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM30_Thu, 3 Aug 2000 20:25:35 +1000409_iso-8859-1 John,<br><br>I am sure that BMC is taking the safe option by going back to an image copy that contains the compression dictionary. There appears to be several situations that might cause a rebuild of compression dictionary that are not recorded in the DB2 catalog. The cases would cause the log tool to get incorrect data if it assumed that the current dictionary matched the old log records. [...]
11090 32 17_Help asap please.9_Harish P.21_emailharish@YAHOO.COM30_Thu, 3 Aug 2000 05:25:21 -0500609_- We are at loggerheads trying to find out the next step towards achieving this.<br><br>Basically, a large team of developers is working on a single corporate data model under the same owner-id. This causes problems in testing with developers messing with each others test data. Is there some way of specifying in the SQL and/or in DDL so that database can be 'partitioned' logically or physically in effect giving each team their own copy of the database??? (within the same OwnerId.TableName of course)... This is effect would mean each team working on different partition could use the same key value [...]
11123 68 21_Re: Help asap please.0_27_jim.leask@RS-COMPONENTS.COM30_Thu, 3 Aug 2000 12:33:08 +0100351_iso-8859-1 Harish,<br><br>The easiest way would be to set up copy tables with different owner ids, as you have already requested. I would ask the DBAs to outline their objections to you. I would think that they would be solvable.<br><br>There are other ways using views and synonyms but I think it would be more work and difficult to administer. [...]
11192 89 16_USERS and GROUPS12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Thu, 3 Aug 2000 07:53:40 -0400381_iso-8859-1 ok folks... I give up... been looking for this in the manuals and can't find it... outside of using the GUI's provided with UDB/EEE to add users to a group... what is the command to do it... I've created a group and set the permissions on that group.... I can grant everything to the users individually, but I'd much rather add them to this group. TIA Randy Wilson [...]
11282 73 88_Re: August 9th - Performance Estimation Class - Tim Lenahan - Last call for registration16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Tue, 1 Aug 2000 06:21:02 -0400573_iso-8859-1 Yes, please check out www.db2-syposium.com for this November.<br><br>> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > craig patton > Sent: Wednesday, July 26, 2000 7:16 AM > To: DB2-L@RYCI.COM > Subject: Re: August 9th - Performance Estimation Class - Tim Lenahan - > Last call for registration > > > Cathy, > > I will be unable to attend this class. I believe I had indicated > interest, > but we have a major project going into production that week and I > am unable > to take the time off. > > See [...]
11356 73 88_Re: August 9th - Performance Estimation Class - Tim Lenahan - Last call for registration16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Tue, 1 Aug 2000 06:21:02 -0400573_iso-8859-1 Yes, please check out www.db2-syposium.com for this November.<br><br>> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > craig patton > Sent: Wednesday, July 26, 2000 7:16 AM > To: DB2-L@RYCI.COM > Subject: Re: August 9th - Performance Estimation Class - Tim Lenahan - > Last call for registration > > > Cathy, > > I will be unable to attend this class. I believe I had indicated > interest, > but we have a major project going into production that week and I > am unable > to take the time off. > > See [...]
11430 25 28_Re: DB2 Call Attach Facility0_23_pjackson@SUMMITBANK.COM30_Tue, 1 Aug 2000 07:56:28 -0000540_us-ascii To All,<br><br>Thanks for your responses - the problem turned out to be that one of our previous MVS systems programmers put the DB2 Call Attach Facility in the LINKLIST so that ENDEVOR would not need STEPLIB.<br><br>Once we added a Version 6 STEPLIB all was OK.<br><br>Thanks again.<br><br>================================================ 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. [...]
11456 85 38_Re: (Fwd) (Fwd) Re: LX, NSYSLX - Day 223_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Tue, 1 Aug 2000 12:57:23 +0100601_iso-8859-1 I think I put the details of a couple of fixes to do with this last week ... check in the archives.<br><br>Les<br><br>-----Original Message----- From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] Sent: Monday, July 31, 2000 11:57 PM To: DB2-L@RYCI.COM Subject: (Fwd) (Fwd) Re: LX, NSYSLX - Day 2<br><br><br><br>------- Forwarded message follows ------- From: "Edward(Ed) J. Finnell, III " <efinnell@seebeck.ua.edu> Organization: Seebeck Computer Center To: db2-l@ryci.cim Date sent: Mon, 31 Jul 2000 17:55:15 -0500 Subject: (Fwd) Re: LX, NSYSLX - Day 2 Priority: normal [...]
11542 85 38_Re: (Fwd) (Fwd) Re: LX, NSYSLX - Day 223_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Tue, 1 Aug 2000 12:57:23 +0100601_iso-8859-1 I think I put the details of a couple of fixes to do with this last week ... check in the archives.<br><br>Les<br><br>-----Original Message----- From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] Sent: Monday, July 31, 2000 11:57 PM To: DB2-L@RYCI.COM Subject: (Fwd) (Fwd) Re: LX, NSYSLX - Day 2<br><br><br><br>------- Forwarded message follows ------- From: "Edward(Ed) J. Finnell, III " <efinnell@seebeck.ua.edu> Organization: Seebeck Computer Center To: db2-l@ryci.cim Date sent: Mon, 31 Jul 2000 17:55:15 -0500 Subject: (Fwd) Re: LX, NSYSLX - Day 2 Priority: normal [...]
11628 25 28_Re: DB2 Call Attach Facility0_23_pjackson@SUMMITBANK.COM30_Tue, 1 Aug 2000 07:56:28 -0000540_us-ascii To All,<br><br>Thanks for your responses - the problem turned out to be that one of our previous MVS systems programmers put the DB2 Call Attach Facility in the LINKLIST so that ENDEVOR would not need STEPLIB.<br><br>Once we added a Version 6 STEPLIB all was OK.<br><br>Thanks again.<br><br>================================================ 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. [...]
11654 23 9_Re: Views14_Jean W Stimmel25_jwstimmel@DUKE-ENERGY.COM30_Tue, 1 Aug 2000 08:10:27 -0400353_us-ascii Default database = 'DSNDB06'; Default tablespace = 'SYSVIEWS'.<br><br>View text is stored in: SYSIBM.SYSVIEWS catalog table.<br><br>When view is created, at that point it is just a catalog entry into a couple of catalog tables - its "data" doesn't exist until it gets materialized, i.e. when you access it and it presents the data report. [...]
11678 147 29_Re: Stored Procedure Question0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Tue, 1 Aug 2000 07:18:59 -0500466_us-ascii <br><br><br><br>When you compiled and linkedit your stored procedure do you include DSNALI in your link edit? Thats the include for DB2 established Stored procedure.<br><br>If you used DSNRLI, thats the include for WLM stored procedures.<br><br>I thought I read that DB2 stored procedures are no longer being enhanced by IBM and they are encouraging shops to go to WLM stored procedures, as there are many more advantages to them that I won't go into. [...]
11826 23 9_Re: Views14_Jean W Stimmel25_jwstimmel@DUKE-ENERGY.COM30_Tue, 1 Aug 2000 08:10:27 -0400353_us-ascii Default database = 'DSNDB06'; Default tablespace = 'SYSVIEWS'.<br><br>View text is stored in: SYSIBM.SYSVIEWS catalog table.<br><br>When view is created, at that point it is just a catalog entry into a couple of catalog tables - its "data" doesn't exist until it gets materialized, i.e. when you access it and it presents the data report. [...]
11850 147 29_Re: Stored Procedure Question0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Tue, 1 Aug 2000 07:18:59 -0500466_us-ascii <br><br><br><br>When you compiled and linkedit your stored procedure do you include DSNALI in your link edit? Thats the include for DB2 established Stored procedure.<br><br>If you used DSNRLI, thats the include for WLM stored procedures.<br><br>I thought I read that DB2 stored procedures are no longer being enhanced by IBM and they are encouraging shops to go to WLM stored procedures, as there are many more advantages to them that I won't go into. [...]
11998 97 18_Re: Recovery Tools12_craig patton21_prgpatton@HOTMAIL.COM28_Thu, 3 Aug 2000 12:34:09 GMT364_- CA/PLATINUM has a tool that can reapply records from the log, but I can't say for sure in your case as the table was dropped and recreated. I STRONGLY suggest in the future that you Start the TS in RO mode, run and IC, THEN unload/drop/recreate/load. Then YOU HAVE an up to date IC to use if the 'alter' process fails or has problems as you have described. [...]
12096 97 21_Re: DSNUTILS Question8_Kurian B23_Bejoy_Kurian@MAY-CO.COM30_Thu, 3 Aug 2000 08:00:54 -0500444_us-ascii Bill Thanks. The NUMTCB=1 should be coded to WLM address space? We have NUMTCB=8 for WLM stored address space. Please confirm. Bejoy<br><br><br><br><br><br>From: BILL_GALLAGHER@PHL.COM@RYCI.COM> on 08/02/2000 12:08 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br>To: DB2-L@RYCI.COM cc: Fax to: Subject: Re: DSNUTILS Question [...]
12194 35 21_Re: Need Rexx Samples13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Thu, 3 Aug 2000 09:02:50 EDT589_- Hi Max, What is DB2WWWX and where can I find it? thanks<br><br><br><br>>From: Massimo Scarpa <Massimo_Scarpa@DEBIS.IT> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: Need Rexx Samples >Date: Thu, 3 Aug 2000 10:32:00 +0100 > >Try DB2WWWX to automate some production tools > >Regards > >Max Scarpa > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can >be reached at DB2-L-REQUEST@RYCI.COM. [...]
12230 407 36_Re: DB2 for OS390 Upgrade- V6 or V7?12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 3 Aug 2000 06:32:31 -0700421_us-ascii Take up with IBM labs about DDF at the Labs as well. If IBM is going to be serious about web processing, DDF must work!<br><br>Right now, unfortunately, at my client's site, the choice is between DB2 Connect and the Oracle Gateway. DB2 Connect is significantly faster (one app went from 4 minutes elapsed to 10 sec just by changing from Oracle Gateway to DB2 Connect) but DB2 Connect is much less reliable. [...]
12638 45 20_Re: USERS and GROUPS14_Mike Lebermann18_Lebermm@BCBSKC.COM30_Thu, 3 Aug 2000 08:25:56 -0500587_US-ASCII Randy,<br><br>Just replace the user name with the group name:<br><br>db2 grant insert,update,select, delete to groupname db2 grant all to groupname<br><br>Mike >>> Randy_Wilson@BCBST.COM 08/03/00 06:53AM >>> ok folks... I give up... been looking for this in the manuals and can't find it... outside of using the GUI's provided with UDB/EEE to add users to a group... what is the command to do it... I've created a group and set the permissions on that group.... I can grant everything to the users individually, but I'd much rather add them to this group. TIA Randy Wilson [...]
12684 67 21_Re: Help asap please.19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Thu, 3 Aug 2000 09:17:08 EDT601_us-ascii Harish,<br><br>In UNIT test / DEV environment this is inevitable. This is the reason, we have SYSTEM test environment where we try to keep the data as clean as possible. We develop test data and refresh the SYSTEM test environment from time to time.<br><br>At our installation we started off with 13 databases in the UNIT test environment but then reverted to a single database because of problems of maintaining all 13 databases and people copying data from one database to another and messing it up anyway because they forgot to switch the qualifiers around. In our case, the database [...]
12752 42 67_AW: How to store UNICODE data in a DB2 for OS/390 Version 5 table ?12_Peter, Georg15_G.Peter@DZBW.DE30_Thu, 3 Aug 2000 15:32:33 +0200403_iso-8859-1 Hi Rick,<br><br>I have found out that UNICODE is supported in DB2 Universal Database for OS/390 Version 7 (First Customer Ship).Availability: FCS to customers in the Early Support Program (ESP) was June 30, 2000. General availability will be announced later........<br><br>The problem is that we need a solution to store this UNICODE data NOW and not somewhere in the future............ [...]
12795 65 55_Re: Refresh 1 subsystem from another subsys - DB2 OS39011_Steve Evans20_evans036@MC.DUKE.EDU30_Thu, 3 Aug 2000 09:23:40 -0400411_us-ascii dale,<br><br>if you are at v6 (apar pq31492 ?), you can use the 'SET LOG SUSPEND' command along with snapshot (RVA) or flashcopy (DSS). This will quiesce the system for just a minute or two without shutting down.<br><br>havent used it - just read about it.<br><br>good luck,<br><br>steve<br><br><br><br><br><br><br><br><br><br><br><br>"Miller, Dale E." <dmiller@UGI.COM> on 08/02/2000 03:36:25 PM [...]
12861 275 29_Re: Stored Procedure Question13_Brunner Don J21_Don.J.Brunner@IRS.GOV30_Tue, 1 Aug 2000 08:27:05 -0400505_iso-8859-1 Shan,<br><br>Thanks for replying. The stored procedure is link-edited with DSNALI, and both DB2s are at V6. This is a test of receiving a result set back from a stored procedure, and I wanted to keep the setup as simple as possible.<br><br>-----Original Message----- From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM [mailto:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] Sent: Tuesday, August 01, 2000 8:19 AM To: DB2-L@RYCI.COM Subject: Re: Stored Procedure Question [...]
13137 28 24_dba performance measures10_Mike Evans28_EVANSMP@CO.MECKLENBURG.NC.US30_Thu, 3 Aug 2000 09:49:16 -0400444_US-ASCII I'm interested in getting feedback from the list regarding qualitative measures of DBA performance to assist in assessing how well our dba group is performing. We have a number of quantitative measures in place but I'm having trouble coming up with some objective measures of the quality of our work. Data availibility, integrity and performance are the likely areas to look at but dba's can't control all factors in those areas. [...]
13166 275 29_Re: Stored Procedure Question13_Brunner Don J21_Don.J.Brunner@IRS.GOV30_Tue, 1 Aug 2000 08:27:05 -0400505_iso-8859-1 Shan,<br><br>Thanks for replying. The stored procedure is link-edited with DSNALI, and both DB2s are at V6. This is a test of receiving a result set back from a stored procedure, and I wanted to keep the setup as simple as possible.<br><br>-----Original Message----- From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM [mailto:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] Sent: Tuesday, August 01, 2000 8:19 AM To: DB2-L@RYCI.COM Subject: Re: Stored Procedure Question [...]
13442 83 55_Re: Refresh 1 subsystem from another subsys - DB2 OS39019_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Thu, 3 Aug 2000 09:00:44 EDT342_us-ascii Dale,<br><br>Some precautions to be taken :<br><br>1. Ensure that the table layouts in PROD & QA are exactly the same. Even if the segsize is different, you will not be able to access the data in QA.<br><br>2. Verify OBID, PSID every time. If, at any time, you drop a table and re-create you could end up with different values. [...]
13526 46 9_Re: Views13_Skelton Brian20_skelton.b@MELLON.COM30_Tue, 1 Aug 2000 09:26:54 -0400602_- Thanks for this just one more question in order to create a view would you need create table authority ? and is there any way you could let people create views but stop them creating tables.<br><br>Regards<br><br><br><br>Brian > -----Original Message----- > From: Jean W Stimmel [SMTP:jwstimmel@DUKE-ENERGY.COM] > Sent: Tuesday 01 August 2000 13:10 > To: DB2-L@RYCI.COM > Subject: Re: Views > > > Default database = 'DSNDB06'; Default tablespace = 'SYSVIEWS'. > > View text is stored in: SYSIBM.SYSVIEWS catalog table. > > When view is created, at that point it is just a catalog entry into a > [...]
13573 17 16_alter tablespace0_27_Bud.Greenman@ONONDAGA.NY.US30_Tue, 1 Aug 2000 09:43:09 -0400426_- I need to alter some tablespaces to increase the priqty and secqty. Will the alter command take effect at extent time if the stogroup is SMS managed? We are on DB2 V4 on OS/390<br><br>================================================ 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. [...]
13591 17 16_alter tablespace0_27_Bud.Greenman@ONONDAGA.NY.US30_Tue, 1 Aug 2000 09:43:09 -0400426_- I need to alter some tablespaces to increase the priqty and secqty. Will the alter command take effect at extent time if the stogroup is SMS managed? We are on DB2 V4 on OS/390<br><br>================================================ 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. [...]
13609 70 9_Re: Views12_craig patton21_prgpatton@HOTMAIL.COM28_Tue, 1 Aug 2000 13:38:34 GMT604_- You do not need to be able to create tables to create views. The view creator simply needs SELECT on the table. (If it is an UPDATE view the the user needs THAT table auth too.)<br><br>HTH, Craig Patton<br><br><br><br>>From: Skelton Brian <skelton.b@MELLON.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: Views >Date: Tue, 1 Aug 2000 09:26:54 -0400 > >Thanks for this just one more question in order to create a view >would you need create table authority ? >and is there any way you could let people create views but stop them >creating tables. > [...]
13680 70 9_Re: Views12_craig patton21_prgpatton@HOTMAIL.COM28_Tue, 1 Aug 2000 13:38:34 GMT604_- You do not need to be able to create tables to create views. The view creator simply needs SELECT on the table. (If it is an UPDATE view the the user needs THAT table auth too.)<br><br>HTH, Craig Patton<br><br><br><br>>From: Skelton Brian <skelton.b@MELLON.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: Views >Date: Tue, 1 Aug 2000 09:26:54 -0400 > >Thanks for this just one more question in order to create a view >would you need create table authority ? >and is there any way you could let people create views but stop them >creating tables. > [...]
13751 38 9_Re: Views14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM30_Tue, 1 Aug 2000 06:45:35 -0700349_iso-8859-1 Brian, If you look at the SQL reference, for each statement, the required Authorization is clearly stated. To create a view, SELECT privilege on ALL tables and columns referenced in the view is required. Hope this helps Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
13790 45 20_Re: alter tablespace11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM30_Tue, 1 Aug 2000 08:52:32 -0500330_us-ascii no, you will have to have a PTF on to issue the Alter dynamically. Otherwise you have to -STO, Alter and -STA the tablespace. Even then, it will not take effect until a reorg or load is done. Consider online reorg, especially in your test environments. Sorry, I don't have the PTF number for the alter modification. [...]
13836 46 9_Re: Views13_Skelton Brian20_skelton.b@MELLON.COM30_Tue, 1 Aug 2000 09:26:54 -0400602_- Thanks for this just one more question in order to create a view would you need create table authority ? and is there any way you could let people create views but stop them creating tables.<br><br>Regards<br><br><br><br>Brian > -----Original Message----- > From: Jean W Stimmel [SMTP:jwstimmel@DUKE-ENERGY.COM] > Sent: Tuesday 01 August 2000 13:10 > To: DB2-L@RYCI.COM > Subject: Re: Views > > > Default database = 'DSNDB06'; Default tablespace = 'SYSVIEWS'. > > View text is stored in: SYSIBM.SYSVIEWS catalog table. > > When view is created, at that point it is just a catalog entry into a > [...]
13883 13 21_Re: DSNUTILS Question9_Jim Ruddy18_jaruddy@US.IBM.COM30_Thu, 3 Aug 2000 10:13:44 -0500304_- DSNUTILS must run TCB=1<br><br>Jim Ruddy IBM DB2 Development<br><br>================================================ 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.
13897 22 21_export import db2 6.18_Giuseppe18_dedonno@ARIADNE.IT30_Thu, 3 Aug 2000 17:18:38 +0200463_us-ascii Hi, I done an export from a db2 6.1 and then I tried to import in another db2 6.1 but I had an error about a null alias on new db. I wrote the alias, but the error remain.<br><br>Help me<br><br>thank you giuseppe<br><br>================================================ 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.
13920 136 18_Re: Recovery Tools15_Murley, Michael22_Michael_Murley@BMC.COM30_Thu, 3 Aug 2000 11:22:01 -0500584_iso-8859-1 Shan,<br><br>I assume that you meant to say that this was a partitioned space rather than a segmented one, since the whole exercise was aimed at repartitioning.<br><br>In order to do anything with the log records between the most recent image copy and the drop/create, you probably would first need to re-create the space using the old limit key definition. If you can't come up with that definition easily, BMC Log Master could get it from the log records created during the drop. You could then use BMC R+/RESOURCE MAXIMIZER to do a drop recovery up to the point of [...]
14057 37 107_Repost: DBAs and developers: "Solutions 2000, the IBM Technical D eveloper Conference" has 25+ DB2 sessions13_Morrill, John12_JohnM@VP.NET30_Tue, 1 Aug 2000 08:26:07 -0600451_iso-8859-1 Dear DB2 Interested Parties,<br><br>Some of you and your colleagues may be interested in attending "Solutions 2000, The IBM Technical Developer Conference", August 14-17 in Las Vegas at the MGM Grand Conference Center. There are over 25 DB2 seminars and hands-on tutorial sessions at the event.<br><br>View the DB2 session offerings, conference information and register at http://www-4.ibm.com/software/data/events/ibmsolutions.html . [...]
14095 62 67_Re: How to store UNICODE data in a DB2 for OS/390 Version 5 table ?20_Goss, Stephen (S.M.)15_sgoss1@FORD.COM30_Thu, 3 Aug 2000 11:38:40 -0400574_iso-8859-1 Can't you use the GRAPHIC data type?<br><br>Stephen Goss Ford Motor Company<br><br>-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: 03 August 2000 14:33 To: DB2-L@ryci.com Subject: AW: How to store UNICODE data in a DB2 for OS/390 Version 5 table ?<br><br><br><br>Hi Rick,<br><br>I have found out that UNICODE is supported in DB2 Universal Database for OS/390 Version 7 (First Customer Ship).Availability: FCS to customers in the Early Support Program (ESP) was June 30, 2000. General availability will be announced later........ [...]
14158 51 34_Re: DB2 for AIX Upgrade- V6 or V7?14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Thu, 3 Aug 2000 13:36:28 -0400647_iso-8859-1 Sai:<br><br>Hope the following link will help you decide if you should go to V6 or V7 http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=900-125<br><br>It appears that DB2 UBB V6 for AIX has been withdrawn from the market and V7 is offered instead as a replacement.<br><br>Thanks, Manas.<br><br><br><br>> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Ragam, Sai J > Sent: Wednesday, August 02, 2000 1:21 PM > To: DB2-L@RYCI.COM > Subject: DB2 for AIX Upgrade- V6 or V7? > > > Has anybody considered migrating to V7 instead of V6 from V5 in > the mid-tier > world(Unix). > [...]
14210 61 34_FW: DB2 for AIX Upgrade- V6 or V7?14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Thu, 3 Aug 2000 13:43:50 -0400494_iso-8859-1 Ooops! .....didn't read the date correctly...its 06/29/2001 (and not 2000)!<br><br>Sorry for the confusion.<br><br>-----Original Message----- From: Manas Dasgupta [mailto:manas.dasgupta@pfsfhq.com] Sent: Thursday, August 03, 2000 1:36 PM To: DB2 Data Base Discussion List Subject: RE: DB2 for AIX Upgrade- V6 or V7?<br><br><br><br>Sai:<br><br>Hope the following link will help you decide if you should go to V6 or V7 http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=900-125 [...]
14272 45 20_Re: alter tablespace11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM30_Tue, 1 Aug 2000 08:52:32 -0500330_us-ascii no, you will have to have a PTF on to issue the Alter dynamically. Otherwise you have to -STO, Alter and -STA the tablespace. Even then, it will not take effect until a reorg or load is done. Consider online reorg, especially in your test environments. Sorry, I don't have the PTF number for the alter modification. [...]
14318 118 63_Repost: "Why Big Blue Is Finally Getting Tough" (ZDNET, 8/1/00)13_Morrill, John12_JohnM@VP.NET30_Thu, 3 Aug 2000 12:01:42 -0600436_iso-8859-1 -----Original Message----- From: dbswift@us.ibm.com [mailto:dbswift@us.ibm.com] Sent: Wednesday, August 02, 2000 8:36 AM To: DB2_Interested_Parties@us.ibm.com Subject: "Why Big Blue Is Finally Getting Tough" (ZDNET, 8/1/00)<br><br><br><br><br><br><br><br>Dear DB2 Interested Parties,<br><br>Although this article does not mention DB2, I thought it might be interesting to some of you.<br><br>Regards, Mike + + + + + + + [...]
14437 75 83_Reminder: IDUG North America 2001 Call for Presentations (deadl ine is 4 September)13_Morrill, John12_JohnM@VP.NET30_Thu, 3 Aug 2000 12:03:42 -0600661_iso-8859-1 Dear DB2 Interested Parties,<br><br>Below is a reminder bulletin about the call for presentations for next year's IDUG North American Conference, May 14-18 in Orlando. The deadline is September 4th for submission of presentation abstracts for consideration by the conference committee.<br><br>I encourage you to join your colleagues at the conference, and better yet, to share your unique and valuable experience and expertise through a conference presentation. The online submission form is on the IDUG web site at http://www.idug.org , click on the pull-down window for the 2001 North American conference - it will lead you to the online Call [...]
14513 39 28_Re: dba performance measures14_Susan Birgeles25_Susan.Birgeles@ALLTEL.COM30_Thu, 3 Aug 2000 15:51:00 -0500719_us-ascii Do you have service level agreements with your internal customers?<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: dba performance measures Author: DB2-L@RYCI.COM (DB2 Data Base Discussion List) at INTERNET Date: 8/3/00 8:49 AM<br><br><br><br>I'm interested in getting feedback from the list regarding qualitative measures of DBA performance to assist in assessing how well our dba group is performing. We have a number of quantitative measures in place but I'm having trouble com ing up with some objective measures of the quality of our work. Data availibilit y, integrity and performance are the likely areas to look at but dba's can't con trol [...]
14553 19 48_Transferring Data between DB2 - MS SQL 7.0 - DB213_Smith, Glynne20_SmithGly@NABISCO.COM30_Thu, 3 Aug 2000 10:23:52 -0400259_- > I'm sure I've asked this before but..... > > Would anyone care to tell me what products they use to transfer data > between tables. I need to go from MS SQL 7.0 to DB2 OS/390 and back again! > Whole tables, or parts of tables! > > Glynne Smith > > > [...]
14573 128 21_Re: DSNUTILS Question0_22_BILL_GALLAGHER@PHL.COM30_Thu, 3 Aug 2000 16:12:15 -0400457_us-ascii Bejoy,<br><br>Yes, I have been told by IBM Tech Support that the WLM address space in which DSNUTILS will run needs to be coded as NUMTCB=1.<br><br>Bill Gallagher, DBA Phoenix Home Life Enfield, CT<br><br><br><br><br><br><br><br><br><br>Kurian B <Bejoy_Kurian@MAY-CO.COM>@RYCI.COM> on 08/03/2000 09:00:54 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
14702 141 28_Balt./Wash. DB2 Users' Group0_19_valeriet@US.IBM.COM30_Thu, 3 Aug 2000 11:38:39 -0400723_us-ascii Baltimore/Washington DB2 Users' Group<br><br>Meeting Date: September 12,2000 (Please note: this is a Tuesday)<br><br>Location: Sheraton Columbia Inn 10207 Wincopin Circle Columbia, MD (410) 730-3900<br><br>Meeting Schedule:<br><br>8:30 - 9:00 Registration<br><br>9:00 - 10:15 From DBA to eDBA: Internet-Age DBA Skills Craig Mullins, BMC Software<br><br>The internet is dramatically altering the way we do business. It has created expectations for businesses to be more connected, more available, and more useful. The need to integrate the Web with traditional IT services, such as DBMSs, places heightened expectations on those who manage the databases and keep them running--the DBAs. This presentation will [...]
14844 22 9_Vacation.17_Armando Zaporteza25_azaporte@CI.PHOENIX.AZ.US30_Thu, 3 Aug 2000 13:20:00 -0700374_US-ASCII Hi,<br><br><br><br>I will be on vacation from Aug. 5th through Aug. 14, 2000.<br><br><br><br>Thanks.<br><br><br><br>Armando<br><br>================================================ 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.
14867 196 21_Re: Help asap please.38_=?iso-8859-1?q?Harish=20Parameswaran?=21_emailharish@YAHOO.COM30_Thu, 3 Aug 2000 08:03:57 -0700475_iso-8859-1 Rajeev & Richard..Thanks for the input. Since that was my first mail to any technical list, I missed the crucial bits. Sorry for the longish story here though. (Please read 5.2 only if in hurry!)<br><br>1)This application is being built on a COBOL-CICS-DB2 on OS390 platform. Since all versioning is controlled through Endevor we are planning to use Endevor to pick up the correct Database when moving across from Unit to Integration to System to UAT to..... [...]
15064 17 12_AIX UDB V5.213_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Thu, 3 Aug 2000 15:43:24 -0500413_- I sent this in early this afternoon, but do not see it posted...so I will send it again.<br><br>Our AIX systems people want me to move the installation of DB2 from the hard drive on the server to RAID. I understand how to move a user database with a backup, alter container and restore w/redirect, but how does one move the entire install (without having to reinstall) which would include system catalogs? [...]
15082 49 60_Free DB2 Migration Tool "SProCT" Upgraded - August 1st, 200013_Martin Spratt18_sprattm@US.IBM.COM30_Thu, 3 Aug 2000 12:50:56 -0400392_us-ascii Attn DB2 Community,<br><br>This note is to inform you that an upgrade of ManTech Systems Solutions Corporation's (MSSC) Stored Procedure Conversion Tool (SProCT)(TM) has been posted on IBM.COM and is available for free from the IBM DB2 Migration web site at:<br><br>http://www.software.ibm.com/data/db2/migration.<br><br>The upgrade was made available at 6:35 PM EDT on 8/1/00. [...]
15132 67 32_VB V6 and OS/390 DB2 field names13_Walter Davies26_wdavies@CO.EL-DORADO.CA.US30_Thu, 3 Aug 2000 10:02:44 -0700502_iso-8859-1 Hi all: We are currently trying to get stored procedures to work with Visual Basic. While we can get the results back from the mainframe we are not getting the column names back which the programmer wants to use. I have turned on decsstat on the DB2 subsystem which the book says should allow the passing of column names. The programmer is still not able to get the names back. Does anyone have any experience with this and give me a clue on where to look next or even have a solution. [...]
15200 14 36_Recall: Need an experienced DB2 DBA.19_Patrick Lewis - 28319_plewis@ACT1CORP.COM30_Thu, 3 Aug 2000 13:11:03 -0700329_- Patrick Lewis - 283 would like to recall the message, "Need an experienced DB2 DBA.".<br><br>================================================ 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.
15215 33 28_Need an experienced DB2 DBA.19_Patrick Lewis - 28319_plewis@ACT1CORP.COM30_Thu, 3 Aug 2000 13:12:03 -0700268_- Hello,<br><br>My name is Patrick Lewis and I am new to the list, I am posting my one job posting for this month and I hope I am not being rude but I have an urgent need. Please follow the link below to find out more and feel free to call me with any questions. [...]
15249 29 28_Need an experienced DB2 DBA.19_Patrick Lewis - 28319_plewis@ACT1CORP.COM30_Thu, 3 Aug 2000 09:01:42 -0700268_- Hello,<br><br>My name is Patrick Lewis and I am new to the list, I am posting my one job posting for this month and I hope I am not being rude but I have an urgent need. Please follow the link below to find out more and feel free to call me with any questions. [...]
15279 70 34_Restrict Access on Partition Table30_Karthigai Thirunal,J16 Chennai25_ekarthik@MSDC.HCLTECH.COM30_Thu, 3 Aug 2000 20:36:49 +0530305_iso-8859-1 Hi,<br><br>Is it possible to restrict users to access specifice partitions ...? FOr example I have 5 partitions, I would like to give access different partitions for different groups. I suppose to use partition tables only.<br><br>Regards Karthik<br><br><br><br><br><br><br><br><br><br><br><br>
15350 56 14_DCLGEN problem11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM30_Fri, 4 Aug 2000 08:51:38 +0800655_us-ascii Hi,<br><br>1. We are running DB2 V5 on OS/390 and I tried to perform a DCLGEN on a view (refer to view definition below) and encountered the following error message,<br><br>SQL Error :<br><br>DSNT408I SQLCODE = -815, ERROR: A GROUP BY OR HAVING CLAUSE IS IMPLICITLY OR EXPLICITLY SPECIFIED IN AN EMBEDDED SELECT STATEMENT OR A SUBQUERY OF A BASIC PREDICATE DSNT418I SQLSTATE = 42920 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXOVC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -300 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFED4' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION [...]
15407 56 38_Re: Restrict Access on Partition Table12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Fri, 4 Aug 2000 11:55:53 +1000384_- Karthik, Not directly; access typically applies to the table. However ..... as somebody mentioned earlier it is possible with a little bit of smoke and mirrors (metaphorically speaking).<br><br>ie:- Create views for each partitions (or groups of partitions) and grant access to each view. Unfortunately though this means that you have to access through the view not the table! [...]
15464 227 21_Re: Help asap please.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 4 Aug 2000 06:58:05 -0500345_ISO-8859-1 Hi Harish, The best solution, and I think the only viable one, is using different ownerid/creator names. It could be suggested that the DBAs and ENDEAVOR folks could use a little training in how to support a multi-ownerid/creator name environment that would encourage productivity rather than 'shade tree mechanic' work-arounds. [...]
15692 36 19_DB2 Connect Problem9_SrinivasG17_SRINIVASG@INF.COM30_Fri, 4 Aug 2000 14:37:38 +0530297_- Hi All, I am using DB2 V6.1 to connect to DB2 OS/390 V6.1 . I am using Control Center. I am able to test connection to the server from CCA. I am also able to execute SQLs from Command Center. However when I try to display the Tables list in Control Center I get the following error message [...]
15729 42 40_-508 or When is cursor positioning lost?17_William R. Miller32_william.miller@DRESDNER-BANK.COM30_Fri, 4 Aug 2000 07:28:12 -0500332_- Hello all, We have had a strange problem here. A program gets a -508 Sqlcode as the result of an UPDATE WHERE CURRENT OF cursor. As far as I can tell, the programm obeys all the rules. The scenario is as follows:<br><br>DECLARE CURSOR C1 FOR SELECT * FROM WRSX037 WHERE ... FOR UPDATE OF FLAG The column FLAG is not indexed. [...]
15772 72 20_Re: USERS and GROUPS13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Fri, 4 Aug 2000 08:48:05 EDT524_- Hi Mike and to all, good morning, If you don't mind, how do you go about creating groupname in an OS/390 environment. Here's my situation: We have RACF in place and I have 4 database with 4 distinct user groups. I want to be able to grant DML authority to some, DBADM to a few, SYSADM to a few, authority to CREATEIN (SYSPROCEDURE, FUNCTIONS and TRIGGERS which is new to me) to a few. We are a new shop and I'm being asked to develop DB2 authorization and access hierachy for our shop. I've not done this in the past [...]
15845 226 21_Re: Help asap please.11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Fri, 4 Aug 2000 08:48:35 -0400436_iso-8859-1 I think this is very difficult without multiple tables with different ownerids. In a previous shop we accomplished the multiple level of testing in multiple DB2s with packages. This was a multi client service center so we needed to provide different mirror tables for clients at different development levels. This was done by wrapping the client number ("owner") with a prefix for sub-system and a suffix for level i.e. [...]
16072 57 21_Re: Help asap please.13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Fri, 4 Aug 2000 08:51:22 -0400610_iso-8859-1 Hi Harish, I would strongly discourage doing ANYTHING to your application database design just to facilitate testing. If you put additional columns (like userid) in your tables, especially in a "key" (primary key?) this will most likely affect your processing logic and your performance and perhaps your data distribution.<br><br>I haven't had to use Endevor in a few years, but back 3-4 years ago it had a hard enough time doing what it was supposed to do with DB2 programs, let alone asking it to do things you shouldn't do -- like change application code between environments. If you change [...]
16130 51 32_Re: Need an experienced DB2 DBA.13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Fri, 4 Aug 2000 08:55:08 EDT612_- Good morning Mr. Lewis, My name is Phillips, and I'm a DB2/DBA currently on assignment here in Durham. I am interested in talking with you regarding your DB2-L job posting for DB2/DBA for your client in Madison, WI. You can reach me at (919) 572-0901 x315. Phillips<br><br><br><br><br><br>>From: Patrick Lewis - 283 <plewis@ACT1CORP.COM> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Need an experienced DB2 DBA. >Date: Thu, 3 Aug 2000 09:01:42 -0700 > >Hello, > >My name is Patrick Lewis and I am new to the list, I am posting my one >job posting for this month [...]
16182 46 46_Trigger and Stored Procedure Naming Convention12_troy Coleman20_Troy.Coleman@UAL.COM30_Fri, 4 Aug 2000 07:55:47 -0500468_- Hello DB2 List, I've been asked by a colleague to ask the following question:<br><br>"If your shop is using DB2 triggers and/or stored procedures, what naming conventions have you developed for both?"<br><br><br><br>Thank you for your help.<br><br>Troy Coleman Coleman Consulting, Inc. IBM Certified Solutions Expert DB2 UDB V5 Database Administration IBM Certified Advanced Technical Expert DB2 - DRDA mailto: troycci@colemanconsulting.com voice: 847-705-1468 [...]
16229 40 16_Re: AIX UDB V5.213_Fletcher, Jim21_jim.fletcher@BSIS.COM30_Fri, 4 Aug 2000 08:59:21 -0400422_iso-8859-1 If the database was created on a mount point filesystem called say.../db2data ..the AIX admins should be able to move this filesystem to the RAID device without DBA involvement. Just make sure the instance is stopped. All permanent tablespaces, including the system catalog, can be moved with redirected restore. You might have to create a new temporary tablespace on the RAID device and drop the old one. [...]
16270 22 15_Using DEFINE NO12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Fri, 4 Aug 2000 08:02:45 -0500477_us-ascii IS anyone using the DEFINE NO option for tabelspaces and indexes. We implemented it in one of our semi test production SAP sub systems. We are now getting messages like the following:\ DSNP012I -DDA1 DSNPCNP0 - ERROR IN VSAM CATALOG LOCATE FUNCTION FOR USADDA1B.DSNDBC.BTAB14.TERRDRRR.I0001.A001 CTLGRC=00000008 CTLGRSN=C5C7002A CONNECTION-ID=RRSAF, CORRELATION-ID=172019046079, LUW-ID=*<br><br>I thought DB2 was suppose to create the dataset on the first write? [...]
16293 40 21_Re: DSNUTILS Question8_Kurian B23_Bejoy_Kurian@MAY-CO.COM30_Fri, 4 Aug 2000 08:18:59 -0500413_us-ascii Thanks Jim. Need some more informations. Do we need WLM in GOAL mode? Any difference between TCB and NUMTCB? Do we need to start multiple WLM address spaces? Thanks Bejoy<br><br><br><br><br><br>From: Jim Ruddy <jaruddy@US.IBM.COM>@RYCI.COM> on 08/03/2000 10:13 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
16334 93 67_AW: How to store UNICODE data in a DB2 for OS/390 Version 5 table ?12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 4 Aug 2000 15:27:33 +0200325_iso-8859-1 Stephen,<br><br>thanks for your answer. We tried the GRAPHIC format and run into some difficulties because GRAPHIC allows only a length of 127. Okay we said let's try VARGRAPHIC. On the first sight this works. But then we found out that there are a some SQL DML restrictions and indexing restrictions too.... [...]
16428 36 16_Re: AIX UDB V5.214_Mike Lebermann18_Lebermm@BCBSKC.COM30_Fri, 4 Aug 2000 08:28:59 -0500615_US-ASCII Shauna,<br><br>A redirected restore for a full database backup will include both the user data and the system catalog tables.<br><br>Mike<br><br>>>> shauna.hadden@BCBSKS.COM 08/03/00 03:43PM >>> I sent this in early this afternoon, but do not see it posted...so I will send it again.<br><br>Our AIX systems people want me to move the installation of DB2 from the hard drive on the server to RAID. I understand how to move a user database with a backup, alter container and restore w/redirect, but how does one move the entire install (without having to reinstall) which would include system catalogs? [...]
16465 130 52_Re: Transferring Data between DB2 - MS SQL 7.0 - DB224_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Fri, 4 Aug 2000 09:35:25 -0700569_us-ascii <br><br>Glynne, You can use bi-directional heterogeneous replication. You would need:<br><br>Workstation (Unix or NT) SQL Server Client DataJoiner DB2 UDB DataPropagator-Relational (DPropR) DB2 Connect<br><br>Host (OS/390) DPropR Capture DPropR Apply<br><br>The IBM courses which describe how to do this are DW140 and DW150 for replication and CF601 for host connectivity. You can go to our website at http://www.thefillmoregroup.com. Choose "Public Classes" for information on the classes and "Systems Integration" for a brief overview of the solutions. [...]
16596 46 36_Re: VB V6 and OS/390 DB2 field names12_Raj, Dominic25_DRaj@FALLSCHURCH.ESYS.COM30_Fri, 4 Aug 2000 09:37:16 -0400581_iso-8859-1 Walter :<br><br>After turning the DECSTAT did you reind all the stored procedure packages.<br><br>Dominic Raytheon Company<br><br><br><br>7700 Arlington Boulevard, Mailstop A-240, Falls Church, Virginia 22042-2900 ---------------------------------------------------------------------------- ------------- Dominic J Raj phone: (703) 560-5000 X 3465 draj@fallschurch.esys.com<br><br>-----Original Message----- From: Walter Davies [mailto:wdavies@CO.EL-DORADO.CA.US] Sent: Thursday, August 03, 2000 1:03 PM To: DB2-L@RYCI.COM Subject: VB V6 and OS/390 DB2 field names [...]
16643 30 38_Re: Restrict Access on Partition Table14_Laredo, Andrew19_Andy_Laredo@BMC.COM30_Fri, 4 Aug 2000 08:41:56 -0500577_iso-8859-1 try using views, 1 view per partition and grant access to the views rather than the underlying table...<br><br>-----Original Message----- From: Karthigai Thirunal,J16 Chennai [mailto:ekarthik@MSDC.HCLTECH.COM] Sent: Thursday, August 03, 2000 11:07 AM To: DB2-L@RYCI.COM Subject: Restrict Access on Partition Table<br><br><br><br><br><br>Hi,<br><br>Is it possible to restrict users to access specifice partitions ...? FOr example I have 5 partitions, I would like to give access different partitions for different groups. I suppose to use partition tables only. [...]
16674 22 45_Visual Basic and DB2 Stored Procedures sample41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR30_Fri, 4 Aug 2000 10:56:34 -0300405_iso-8859-1 Does anyone know where I can find samples for a Visual Basic program (if possible, V5.0) calling DB2 OS/390 V5.1 stored procedures?<br><br>I took a look at the redbook "Getting Started with DB2 Stored Procedures: Give Them a Call Trough the Network", but I found its instructions a bit complex because my VB knowlege is very limited. I would appreciate it if you could share some samples. [...]
16697 148 67_Re: How to store UNICODE data in a DB2 for OS/390 Version 5 table ?20_Goss, Stephen (S.M.)15_sgoss1@FORD.COM30_Fri, 4 Aug 2000 11:07:19 -0400618_iso-8859-1 Georg,<br><br>There is a non unicode approach ...<br><br>What we've done is to use normal CHAR datatypes and store different codepages in the them depending on the country. This scheme works - because a column indicating the country is part of the key of every table and the users only look at data belonging to their country. Our database currently supports 41 countries and contains customer name and address information for which it is important to get the national characters correct. We interface to the web using two methods: codepage translation services in MQ or Oracle via a stored procedure. [...]
16846 23 16_high bsds access10_Tom Taylor17_ttaylor@CHUBB.COM30_Fri, 4 Aug 2000 11:05:49 -0400283_us-ascii Hi all<br><br>Seem to have a high number of BSDS accesses for a 1 hour period. What are the reasons for BSDS update. I can think of<br><br>archive log update - only one occurred in the hour active log update - only one occurred in the hour quiesce update - no quiesces [...]
16870 24 23_DB2 Archive Log Problem14_Dean Montevago18_DMonteva@VNSNY.ORG30_Fri, 4 Aug 2000 11:10:35 -0400549_- Hi, I am trying to enter #ARCHIVE LOG MODE(QUIESCE) from the MVS console and DB2 is telling me I'm not authorized. What do I need to do to correct this ? Regards, Dean<br><br>Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax<br><br>dmonteva@vnsny.org<br><br>================================================ 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.
16895 69 44_Re: -508 or When is cursor positioning lost?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 4 Aug 2000 11:18:32 -0400411_us-ascii Bill<br><br>Sounds like bug in DB2 software, because I was able to do it here without any problem. But I still wonder, why do you need to update the same cursor position twice?<br><br>-Venkat<br><br>-----Original Message----- From: William R. Miller [SMTP:william.miller@DRESDNER-BANK.COM] Sent: Friday, August 04, 2000 8:28 AM To: DB2-L@RYCI.COM Subject: -508 or When is cursor positioning lost? [...]
16965 51 20_Re: high bsds access19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 4 Aug 2000 10:33:39 -0500628_ISO-8859-1 Might there be some products running (like replication) that need to read the BSDS often?<br><br>Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is [...]
17017 45 27_Re: DB2 Archive Log Problem38_Andersen, Cindy (CC-Database Services)26_Cindy.Andersen@CONAGRA.COM30_Fri, 4 Aug 2000 10:35:13 -0500488_iso-8859-1 You need to have the ARCHIVE privilege granted to your id OR be an Install SYSOPR authority OR have SYSCTRL authority OR have SYSADM authority to issue the ARCHIVE LOG command.<br><br>Remember DB2 commands issued from an MVS console are not associated with any secondary authorization IDs.<br><br><br><br>-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Friday, August 04, 2000 10:11 AM To: DB2-L@RYCI.COM Subject: DB2 Archive Log Problem [...]
17063 48 20_Re: high bsds access13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Fri, 4 Aug 2000 08:40:55 -0700329_iso-8859-1 Well, 'highest RBA written' is another field which is updated 'frequently' in BSDS. I know 'ideally' it should be updated each time buffer logs are written to active logs but I guess it is not updated anytime.<br><br>Could someone on list tell me what is the frequency at which 'highest RBA written' is updated?? [...]
17112 63 27_Re: DB2 Archive Log Problem14_Dean Montevago18_DMonteva@VNSNY.ORG30_Fri, 4 Aug 2000 11:46:20 -0400581_- If it's executed from the console how do I give it sufficient authority ? I also want to be able to issue this as a JES2 automated command via a $VS.<br><br>> -----Original Message----- > From: Andersen, Cindy (CC-Database Services) > [SMTP:Cindy.Andersen@CONAGRA.COM] > Sent: Friday, August 04, 2000 11:35 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Archive Log Problem > > You need to have the ARCHIVE privilege granted to your id OR be an > Install > SYSOPR authority OR have SYSCTRL authority OR have SYSADM authority to > issue the ARCHIVE LOG command. > > Remember DB2 [...]
17176 19 35_Seaching for Foreign Key violations13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Fri, 4 Aug 2000 10:30:40 -0500394_- We've found a few places where we have foreign keys that don't match to the primary key on the target table. (Ouch.)<br><br>I'm thinking of writing up a Java program to go query DB2 UDB V6.1 on NT and return all of the missing foreign key information for all tables.<br><br>Which system tables do I need to query to find the foreign key relationships and has somebody already done this? [...]
17196 133 36_Re: VB V6 and OS/390 DB2 field names13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Fri, 4 Aug 2000 10:48:09 -0500525_US-ASCII Walter, Look at DESCRIBE CURSOR in the application programming guide. HTH Kurt<br><br>>>> DRaj@FALLSCHURCH.ESYS.COM 08/04/00 08:37AM >>> Walter :<br><br>After turning the DECSTAT did you reind all the stored procedure packages.<br><br>Dominic Raytheon Company<br><br><br><br>7700 Arlington Boulevard, Mailstop A-240, Falls Church, Virginia 22042-2900 ---------------------------------------------------------------------------- ------------- Dominic J Raj phone: (703) 560-5000 X 3465 draj@fallschurch.esys.com [...]
17330 116 49_Technical Tips - DB2 V5 AND V6 Migration Articles11_John Wynton21_jwynton@THEMISINC.COM30_Fri, 4 Aug 2000 11:50:44 -0400658_windows-1252 Dear DB2 List:<br><br>We have expanded the "Technical Tips" section of our redesigned web site to include two new papers on DB2 V5 and DB2 V6 Migration.<br><br>These articles were written by Linda Claussen, a frequent speaker at conferences and user groups. Linda's 30+ years of experience spans the various roles of Application Developer, Project Manager, Database Administrator and System's Programmer. Linda's first exposure to DB2 started with DB2 1.1 and during the last 15 years she has been actively engaged in consulting and training assignments for large DB2 MVS and OS/390 environments. Linda is currently a principle of Claussen [...]
17447 156 50_Re: Trigger and Stored Procedure Naming Convention12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Fri, 4 Aug 2000 10:50:25 -0500634_us-ascii <br><br><br><br>Hello.<br><br>We're using Stored Procedures and Triggers. Here is a snipit from our naming conventions, (which aren't perfect, but seem to cover most of our most cases.)<br><br>Chars 1-2 Application (e.g. PP - pay/pers, FI - financial, etc.) Char 3 Entity code (See following list)<br><br>C Constraint D Database E Delete Trigger F User-Defined Function G Storage Group I Insert Trigger K Key L DCLGEN output M Synonym N Collection P Program Q Sub-Program R Standalone SQL code S Table Space T Table U Update Trigger V View W Working Storage (Stored Procedure call parameters) X Index Y Stored Procedure [...]
17604 188 18_Re: Recovery Tools0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Fri, 4 Aug 2000 11:19:14 -0500330_us-ascii Thanks Michael for your reply.<br><br>Yes, we assumed that if we were to go back to the logs that we would have to put it back in the same format so that the logs records would match up. We didn't do that as we knew of no way that DB2 would be apply the log records since it had been deleted so it was a mute point. [...]
17793 239 21_Re: Help asap please.19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Fri, 4 Aug 2000 11:14:39 EDT521_us-ascii Harish,<br><br>By now you must have seen the other replies to your current posting. I have some suggestions which might help you.<br><br>1. Going with your idea of adding the userid/group id to the base table, I would support the earlier view of not including it in the primary key. My personal preference would be to add a group id instead of userid. Have a separate index which includes the group id at the highest level. This will also be useful whenever you want to copy data to and from this database. [...]
18033 68 20_Re: high bsds access14_Jack O'Connell26_jack.oconnell@MCMASTER.COM30_Fri, 4 Aug 2000 12:13:09 -0500411_iso-8859-1 What is the Checkpoint frequency defined to the subsystem? This will be an auto capture of the RBA based on your Checkpoint frequency.<br><br>Merge / Modify ( CA-Platinum ) or the BMC Equivalent may also do the scan<br><br>-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Friday, August 04, 2000 10:34 AM To: DB2-L@RYCI.COM Subject: Re: high bsds access [...]
18102 17 38_REORG logging in DB2 for OS390 vs UNIX15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Fri, 4 Aug 2000 12:54:59 -0500536_iso-8859-1 I am from the DB2 for OS390 world...and usually specify LOG NO when reorging large tablespaces. The REORG TABLE syntax diagram in DB2 for UNIX/WINDOWS shows no LOG (YES/NO) option...does that mean that all reorgs in Unix/Windows will involve mandatory logging?<br><br>Tonmoy Dasgupta<br><br>================================================ 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.
18120 17 21_Re: DSNUTILS Question9_Jim Ruddy18_jaruddy@US.IBM.COM30_Fri, 4 Aug 2000 13:02:03 -0500510_- I should have said NUMTCB=1.<br><br>WLM can be in compatibility mode but you will need to start the address spaces manually. You will need multiple address spaces if you want to have multiple users invoking DSNUTILS concurrently.<br><br>Jim Ruddy IBM DB2 Development<br><br>================================================ 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.
18138 33 19_INSERT performance?14_Jessen Michael27_JessenMichael@JOHNDEERE.COM30_Fri, 4 Aug 2000 13:19:43 -0500599_iso-8859-1 In the DB2 Developers Guide (3rd edition), it states that no specific access path stategies can be chosen for an insert (p639).<br><br>We have an COBOL application on OS390 (DB2 V5.1) Using Strobe, we are showing an INSERT on a partitioned table that takes a considerable amount of cpu (in comparison with other inserts in the same application). How can we determine what is actually happening behind the scenes? Is the insert into the indexes causing the slowdown? Is the table being scanned to determine where to insert the new row? Also, in looking at syspackstmt, :H is the host [...]
18172 64 23_Re: INSERT performance?14_John P Shipley24_jpshiple@DUKE-ENERGY.COM30_Fri, 4 Aug 2000 14:23:36 -0400584_us-ascii Do you have RI pointing to a table with no supporting index?<br><br><br><br><br><br>|--------+-----------------------------> | | Jessen Michael | | | <JessenMichael@JOHN| | | DEERE.COM> | | | | | | 08/04/00 02:19 PM | | | Please respond to | | | DB2 Data Base | | | Discussion List | | | | |--------+-----------------------------> >----------------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: John P Shipley/Corp/DukePower) | | Subject: INSERT performance? | >----------------------------------------------------------------| [...]
18237 36 18_DB2 Connect doubts10_Radha Rani24_radha_rani@ALTAVISTA.COM30_Fri, 4 Aug 2000 11:49:29 -0700396_- Hi !<br><br>I have just started reading about DB2 Connect and have a basic question :<br><br>Net.Data as I understand allows you to create applications that access data in DB2 databases from the Web.<br><br>However, Java Database Connectivity (JDBC) and Embedded SQL for Java (SQLJ) are provided with DB2 to allow you to create applications that access data in DB2 databases from the Web. [...]
18274 58 23_Re: INSERT performance?19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Fri, 4 Aug 2000 15:48:32 EDT486_us-ascii Mike,<br><br>In the SYSPACKSTMT table, all host variables are denoted by ': H'. You will see the same thing if you see inside a DBRM.<br><br>When you are comparing the cpu utilization for inserts, I suspect that you are not comparing with inserts by other programs into the SAME table. The CPU utilization will depend on a number of factors. Check the number of indexes on the table. Also check if RI is defined and, if so, how many foreign keys are defined on the table. [...]
18333 247 21_Re: Help asap please.15_Dunton.Doug.MCI31_dunton.doug.mci@HARTE-HANKS.COM30_Fri, 4 Aug 2000 14:53:29 -0500745_US-ASCII Why not build "Views" looking at different key values one for each team? It will give everyone a different table name, but hey.<br><br>Doug Dunton Harte-Hanks DB2 DBA<br><br><br><br>______________________________ Reply Separator _________________________________ Subject: Re: Help asap please. Author: DB2 Data Base Discussion List <DB2-L@RYCI.COM> at ~INTERNET Date: 08/04/2000 6:58 AM<br><br><br><br>Hi Harish, The best solution, and I think the only viable one, is using different ownerid/creator names. It could be suggested that the DBAs and ENDEAVOR folks could use a little training in how to support a multi-ownerid/creator name environment that would encourage productivity rather than 'shade tree mechanic' work-arounds. [...]
18581 31 24_Data Propagator question12_Kirk Hampton16_khampto1@TXU.COM30_Fri, 4 Aug 2000 14:57:56 -0500550_us-ascii We have had DPROP/R running here for several years, but a new DBA ran into something yesterday that I could not explain. We are testing with v6.1 of DPROP/R, against a v6.1 UDB for OS/390 database. He had set up his source tables, target tables, and CD tables, and had successfully replicated to his targets. Then he ran an update SQL thru SPUFI that changed several thousand rows, but it updated only one column in each row, and it set the column value to the same value it already was in those rows. The message from SPUFI was that n [...]
18613 74 28_Re: Data Propagator question0_18_damcon2@US.IBM.COM30_Fri, 4 Aug 2000 17:08:35 -0400508_us-ascii Kirk,<br><br>DB2 is smart enough to know that the column was the same value and didn't really need to be updated, so therefore, no logging. Capture only captures what is logged.<br><br>Cheers, Jay<br><br><br><br>Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW ----------------------------------------------------- [...]
18688 99 13_DB2 Utilities15_Andrea Milligan25_Andrea_Milligan@BCBST.COM30_Fri, 4 Aug 2000 17:18:00 -0400687_iso-8859-1 We are hearing rumors that the IBM supplied DB2 utilities are going to be an "additional cost" item in version 7. Has anyone else heard that? Does anyone know?<br><br>Andrea Milligan Database Administator BlueCross BlueShield of Tennessee Phone (423) 755-5928 Pager (423) 527-0970<br><br><br><br><br><br>The information contained in this message and any attached documents is intended only for the personal and confidential use of the designated recipient(s). This message may be a confidential and privileged communication. If the reader of this message is not the intended recipient (or an agent responsible for delivering it to the intended recipient), you are hereby [...]
18788 125 20_Re: USERS and GROUPS12_tim malamphy20_timalamphy@YAHOO.COM30_Fri, 4 Aug 2000 14:33:57 -0700401_us-ascii The DSN3@ATH exit (usually in dsnexit loadlib) passes this info to DB2 from RACF. The DB2 sysprog makes sure this exit is in place. The exit provided by IBM is in dsnsamp, but needs to be assembled. Creating the actual groups is a RACF function, (sorry I don't know the syntax). Hopefully your RACF sysprog isn't totally new too (and is someone other than you) and knows how to do this. [...]
18914 84 17_Re: DB2 Utilities16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM30_Fri, 4 Aug 2000 17:34:22 -0400341_iso-8859-1 <br><br>There was an announcement at IDUG concerning just that. My personnel understanding is that IBM will unbundle some or all of the DB2 utilities. There was a discussion of just that right after the IDUG conference this year. You may want to look at the archives.<br><br><br><br>Robert Galambos Compuware Corp. Of Canada [...]
18999 60 17_Re: DB2 Utilities12_tim malamphy20_timalamphy@YAHOO.COM30_Fri, 4 Aug 2000 14:36:09 -0700597_us-ascii Search the archives! I don't think the list can stand another debate on IBM charging for utilities. --- Andrea Milligan <Andrea_Milligan@BCBST.COM> wrote: > We are hearing rumors that the IBM supplied DB2 > utilities are going to be an > "additional cost" item in version 7. Has anyone > else heard that? Does > anyone know? > > Andrea Milligan > Database Administator > BlueCross BlueShield of Tennessee > Phone (423) 755-5928 > Pager (423) 527-0970 > > > > The information contained in this message and any > attached documents is > intended only for the personal and confidential [...]
19060 37 21_Can I backout a bind?16_Alison Pelletier26_alison_pelletier@YAHOO.COM30_Fri, 4 Aug 2000 14:38:29 -0700563_us-ascii I think the answer is no to this question, but I need to ask just in case...We are DB2 V5. We had an exceptable access path w/list prefetch. Runstats were run and I'm told sequential caching was turned on by our systems folks. We bound and list prefetch is no longer the choice of the optimizer. The call is using an unclustered index, which was the index of choice before, for many qualifying rows joining to 3 other smaller tables. Anyhow, it's running much longer than before now that list prefetch is turned off. We tried putting stats back the [...]
19098 33 23_DB2 Connect EE install.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Fri, 4 Aug 2000 14:55:31 -0700316_iso-8859-1 Hi all, I'm a DB2 OS/390 system programmer and I've got stuck with installing DB2CEE for NT because it has DB2 in the product name and it connects to the mainframe. I'm not a LAN/Server guy and don't want to be, only thing worse than a LAN are printers or maybe a poke in the eye with a sharp stick. [...]
19132 60 27_Re: DB2 Connect EE install.13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Fri, 4 Aug 2000 17:08:30 -0500477_iso-8859-1 Cliff,<br><br>1. Install the "Run-time Clients" on the clients. There should be a CD with a name like that. 2. Use configuration assistant similar to the PE edition and define the databases. You can setup an auto-response file to install from a file server once you have things all worked out. If you got PE going, you can get EE clients going. 3. Lic. - honor system I think. Nothing to enforce as far as I know. 4. Welcome to LAN-World. The fun begins now :) [...]
19193 81 22_Re: DB2 Connect doubts13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Fri, 4 Aug 2000 17:30:32 -0500495_iso-8859-1 Radha,<br><br>Net.data basically allows you to issue SQL from html (via macros). To incorporate program logic into a net.data implementation, typically the SQL issued would be a stored procedure call. This model works very well.<br><br>Accessing DB2 data via Java involves the webserver initiating the program logic (Java) at an application type server (i.e. Websphere) which then uses a connectivity product (i.e. DB2 Connect) to access the DB2 data. This model works well too. [...]
19275 64 27_Re: DB2 Connect EE install.0_15_leon@CA.IBM.COM30_Fri, 4 Aug 2000 19:35:15 -0400541_us-ascii Cliff, we could not put a cup of coffee in the product box but we did put a paper book called "DB2 Connect Enterprise Edition Quick Beginnings" in. Installation on Windows NT is trivial if all you want is very basic function. Just log on to an id that is 8 characters or less (in V7.1 it can be any id), stick in the CD in the drive and keep clicking "Next" until you get to the panel where "Finish" button is enabled. Once everything is installed go to DB2 Client Configuration Assistant or (CCA) and click on "Add database". [...]
19340 63 19_Re: Using DEFINE NO0_29_paul.packham@POSTOFFICE.CO.UK30_Sat, 5 Aug 2000 11:22:23 +0000472_us-ascii Dan,<br><br>We used the DEFINE NO option in our SAP 4.6C test install & ran into all sorts of problems. In the end we had to create a 'dummy' table in each tablespace which was created with this option to create the underlying dataset to allow the install to continue. There are a number of APARs which we found that might help. PQ37845/UQ43910 is one which we have just applied. We will be testing this on Monday, PQ39813 is another but this is still open. [...]
19404 17 25_TSO Attach Feature vs CAF12_Roland Holup19_rholup@MEGSINET.NET30_Sat, 5 Aug 2000 23:05:14 -0500427_- Has anyone done any benchmarking between running DB2 Embedded COBOL Programs in batch under the TSO Attach facility vs using basic CAF with just SQL statements and linkediting the programming with the CAF routines? The program code is the same. The difference is in how you linkedit and run the jobs. I am trying to determine if their are major benefits to CAF or if the default TSO Attach as most people use is better. [...]
19422 45 29_Re: TSO Attach Feature vs CAF27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Sun, 6 Aug 2000 13:55:47 +0530313_iso-8859-1 Roland,<br><br>We have used CAF in our shop as well as TSO attach and seen major benefits with regards to avoiding overhead on the DB2 Subsystem by using CAF.<br><br>Also, CAF gives you major benifits in terms on error debugging by exactly pointing out the error to you as compared to TSO attach. [...]
19468 26 17_db2 for GNU/Linux30_=?iso-8859-1?Q?Tiago_Ant=E3o?=14_tra@FCT.UNL.PT30_Sun, 6 Aug 2000 19:29:51 +0100565_US-ASCII Hi!<br><br>Has anyone tried to put DB2 to work on a non RPM based GNU/Linux distribution? If yes could you give a pointer to where it be could found that information?<br><br>Has I was unable to find anything on this subject, I started to try to get DB2 working in a non rpm (a dpkg - Debian in this case) distribution. If you are interested, you can find my atempt (which worked ok) to install only the client on a non rpm distro documented at http://tiago.org/db2-4-linux.html . With time I'll try other components, and document it. I've tried to be [...]
19495 44 21_Re: db2 for GNU/Linux18_Gert van der Kooij15_geko@WANADOO.NL30_Sun, 6 Aug 2000 20:59:48 +0200586_iso-8859-1 You might be interested in the DB2-HOWTO. You can find it at www.linuxdoc.org.<br><br>----- Original Message ----- From: "Tiago Antão" <tra@FCT.UNL.PT> Newsgroups: bit.listserv.db2-l To: <DB2-L@RYCI.COM> Sent: Sunday, August 06, 2000 8:29 PM Subject: db2 for GNU/Linux<br><br><br><br>> Hi! > > Has anyone tried to put DB2 to work on a non RPM based GNU/Linux > distribution? If yes could you give a pointer to where it be could found > that information? > > Has I was unable to find anything on this subject, I started to > try to get DB2 working in a non rpm (a dpkg - [...]
19540 15 49_Alfonso Alonso/Production/Unicible est absent(e).14_Alfonso Alonso26_alfonso.alonso@UNICIBLE.CH30_Mon, 7 Aug 2000 01:00:31 +0200343_iso-8859-1 Je serai absent(e) du 04.08.2000 au 25.08.2000.<br><br>Je répondrai à votre message dès mon retour. ===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
19556 56 20_Re: high bsds access7_Sanjeev21_Sanjeev@INTERRAIT.COM30_Mon, 7 Aug 2000 09:17:58 +0530558_iso-8859-1 Hi Ashish, You must have seen few informations available in the Admin Guide related to the point you have mentioned : As the HIGHEST RBA field is updated frequently(as you asked) in the BSDS, the highest RBA written can be interpreted as an approximation of the end of the log. The field is updated in the BSDS when any one of a variety of internal events occurs. In the absence of these internal events, the field is updated each time a complete cycle of log buffers is written. A complete cycle of log buffers occurs when the number of log [...]
19613 282 28_Re: Data Propagator question11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Mon, 7 Aug 2000 14:11:03 +1000400_- Kirk,<br><br>just to expand on Jay's answer: while we were doing some testing a few years ago (from memory we were on DB2 OS/390 V4 at the time, or possibly V3), we noticed that even if a parent table was CHECK PENDING, we could update foreign keys as long as no values were actually changed. We did not get the usual error message until we tried to change a foreign key to a different value. [...]
19896 95 20_Re: high bsds access9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Mon, 7 Aug 2000 08:29:38 +0100356_us-ascii The 'Data Sharing Recovery And Restart Course (CF32U) p 5-5 - Restarting DB2' states....<br><br>"From time to time (for example, when DB2 is stopped normally or when DB2 has reached the end of the log buffer), a DB2 subsystem writes the RBA of the latest log record to its BSDS."<br><br>Kind Regards, Andy Hunt - Scottish And Southern Energy [...]
19992 57 45_Problems inserting LOB data greater than 16MB10_Mark Feven19_markfeven@YAHOO.COM30_Mon, 7 Aug 2000 11:38:03 +0100519_iso-8859-1 Hello,<br><br>Has anyone out there used a COBOL (or PL1) program to INSERT LOB data greater than 16 MB?<br><br>As far as I can see, the rules are as follows:<br><br>- with fields up to 32KB, the LOAD utility can be used - I have successfully used this.<br><br>- with fields up to 16MB, a program has to be used. Both COBOL and PLI have a limitation that any individual working storage field may not exceed 32KB. Therefore a 'group' data item can be used as follows (I have successfully used this also): [...]
20050 187 69_UNICODE data in a DB2 for OS/390 Version 5 table - here's an idea ...12_Peter, Georg15_G.Peter@DZBW.DE30_Mon, 7 Aug 2000 12:51:43 +0200467_iso-8859-1 Stephen,<br><br>thanks for your response. We're testing now such a non unicode approach.<br><br>The idea is the following: We use DB2 only for storing the columns and put the UNICODE data in varchar for bit data defined columns.<br><br>We do not intend to view the information on the big iron. If the data is needed a PC client will start a select (on a non-UNICODE-key), catch all the data needed, bring the data down and present the data on the PC. [...]
20238 27 35_Column definition in DB2 for OS/39012_Peter, Georg15_G.Peter@DZBW.DE30_Mon, 7 Aug 2000 13:05:40 +0200429_iso-8859-1 Hello list.<br><br>I have defined a table column in DB2 for OS/390 as ...VARCHAR (length) FOR BIT DATA.<br><br>After a look on SYSIBM.SYSCOLUMNS I have not found a column that indicates that this column is defined as FOR BIT DATA.<br><br>Any idea/comment where this information can be found in the catalog ?<br><br>With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator [...]
20266 54 39_Re: Column definition in DB2 for OS/3900_19_mike.holmans@BT.COM30_Mon, 7 Aug 2000 12:12:40 +0100637_iso-8859-1 SYSIBM.SYSCOLUMNS.FOREIGNKEY has a value of 'B' if the column contains bit data, according to the documentation I have.<br><br>Mike Holmans BT ISE Technical Design mike.holmans@bt.com<br><br>This post represents the views of the author and does not necessarily accurately represent the views of BT<br><br>> -----Original Message----- > From: Peter, Georg [SMTP:G.Peter@DZBW.DE] > Sent: Monday, August 07, 2000 12:06 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Column definition in DB2 for OS/390 > > Hello list. > > I have defined a table column in DB2 for OS/390 as ...VARCHAR (length) > FOR > BIT DATA. > > After a look [...]
20321 82 39_AW: Column definition in DB2 for OS/39012_Peter, Georg15_G.Peter@DZBW.DE30_Mon, 7 Aug 2000 13:23:12 +0200669_iso-8859-1 Thanks Mike, I have overread this.<br><br>With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------<br><br>-----Ursprüngliche Nachricht----- Von: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] Gesendet am: Montag, 7. August 2000 13:13 An: DB2-L@RYCI.COM Betreff: Re: Column definition in DB2 for OS/390 [...]
20404 72 27_Re: DB2 Archive Log Problem11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Mon, 7 Aug 2000 08:28:06 -0400365_iso-8859-1 GRANT ARCHIVE TO SYSOPR.<br><br>-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Friday, August 04, 2000 11:46 AM Subject: Re: DB2 Archive Log Problem<br><br><br><br>If it's executed from the console how do I give it sufficient authority ? I also want to be able to issue this as a JES2 automated command via a $VS. [...]
20477 40 49_Re: Visual Basic and DB2 Stored Procedures sample11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Mon, 7 Aug 2000 08:31:28 -0400548_iso-8859-1 I have not tested these, but it looks like what you are looking for.<br><br>http://www-4.ibm.com/software/data/db2/os390/cstips/<br><br>http://www-4.ibm.com/software/data/db2/os390/cstips/vbsamps.html<br><br>-----Original Message----- From: Cláudio Meluzzi Mendes [mailto:P000002@BEG.COM.BR] Sent: Friday, August 04, 2000 9:57 AM Subject: Visual Basic and DB2 Stored Procedures sample<br><br><br><br>Does anyone know where I can find samples for a Visual Basic program (if possible, V5.0) calling DB2 OS/390 V5.1 stored procedures? [...]
20518 33 0_10_Pete Coles28_peter.coles@SOMERFIELD.CO.UK30_Mon, 7 Aug 2000 14:51:49 +0100313_iso-8859-1 Dear DB2 list community, Does anyone have any accurate SQL I can to use to correctly 'unstat' the performance statistics in the DB2 catalogue. I have in the past been using SQL to set COLCARD to -1 in SYSIBM.SYSCOLUMNS but I can't help but feel this is not enough. Any views would be appreciated. [...]
20552 81 36_Re: VB V6 and OS/390 DB2 field names0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Mon, 7 Aug 2000 07:49:55 -0500448_iso-8859-1 We had a similar problem and it turned out that we needed to upgrade CAE to version 6. Without this upgrade, the parameter list that was returned to the VB program was not not the correct order.<br><br>Larry Kirkpatrick Mutual of Omaha<br><br><br><br><br><br><br><br>Walter Davies <wdavies@CO.EL-DOR To: DB2-L@RYCI.COM ADO.CA.US> cc: Sent by: DB2 Data Subject: VB V6 and OS/390 DB2 field names Base Discussion List <DB2-L@RYCI.COM> [...]
20634 64 0_19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 7 Aug 2000 08:04:35 -0500630_ISO-8859-1 Peter, My first thought was WHY? All user updateable columns related to RUNSTATS are documented in the DB2 Admin. Gde., para., Statistics Used for Access Path Selection.<br><br>Regards, Rick<br><br>"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 [...]
20699 78 0_10_Pete Coles28_peter.coles@SOMERFIELD.CO.UK30_Mon, 7 Aug 2000 15:08:52 +0100693_iso-8859-1 thanks for the positive response<br><br>-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Monday, August 07, 2000 1:05 PM To: DB2-L@RYCI.COM Subject:<br><br><br><br>Peter, My first thought was WHY? All user updateable columns related to RUNSTATS are documented in the DB2 Admin. Gde., para., Statistics Used for Access Path Selection.<br><br>Regards, Rick<br><br>"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 [...]
20778 64 12_AW: 'unstat'12_Peter, Georg15_G.Peter@DZBW.DE30_Mon, 7 Aug 2000 15:14:25 +0200428_iso-8859-1 Pete,<br><br>what's the reason for your question ? Wanna fooling the optimizer to receive a special access path ? Or is it to determine where runstats was not in place ?<br><br>With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r<br><br>-----Ursprüngliche Nachricht----- Von: Pete Coles [mailto:peter.coles@SOMERFIELD.CO.UK] Gesendet am: Montag, 7. August 2000 15:52 An: DB2-L@RYCI.COM Betreff: [...]
20843 80 12_Re: 'unstat'10_Pete Coles28_peter.coles@SOMERFIELD.CO.UK30_Mon, 7 Aug 2000 15:17:46 +0100412_iso-8859-1 want to correct an incorrect runstats with table all.<br><br>-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Monday, August 07, 2000 1:14 PM To: DB2-L@RYCI.COM Subject: AW: 'unstat'<br><br><br><br>Pete,<br><br>what's the reason for your question ? Wanna fooling the optimizer to receive a special access path ? Or is it to determine where runstats was not in place ? [...]
20924 98 20_Re: high bsds access10_Tom Taylor17_ttaylor@CHUBB.COM30_Mon, 7 Aug 2000 09:16:33 -0400834_us-ascii HI Any reason not to make outbuf = 4000k if you have the storage.<br><br>Tom<br><br><br><br><br><br><br><br><br><br><br><br><br><br>Sanjeev <Sanjeev@INTERRAIT.COM> on 08/06/2000 11:47:58 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>To: DB2-L@RYCI.COM<br><br>cc: (bcc: Thomas G Taylor/ChubbMail)<br><br><br><br><br><br>Subject: Re: high bsds access<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>Hi Ashish, You must have seen few informations available in the Admin Guide related to the point you have mentioned : As the HIGHEST RBA field is updated frequently(as you asked) in the BSDS, the highest RBA written can be interpreted as an approximation of the end of the log. The field is updated in the BSDS when [...]
21023 110 12_Re: 'unstat'0_19_mike.holmans@BT.COM30_Mon, 7 Aug 2000 14:25:16 +0100678_iso-8859-1 The most obvious way of "correcting" a runstats is to run runstats again. What do you mean by an "incorrect" runstats?<br><br>Mike Holmans BT ISE Technical Design mike.holmans@bt.com<br><br>This post represents the views of the author and does not necessarily accurately represent the views of BT<br><br>> -----Original Message----- > From: Pete Coles [SMTP:peter.coles@SOMERFIELD.CO.UK] > Sent: Monday, August 07, 2000 3:18 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] 'unstat' > > want to correct an incorrect runstats with table all. > > -----Original Message----- > From: Peter, Georg [mailto:G.Peter@DZBW.DE] > Sent: Monday, August 07, 2000 1:14 PM > To: [...]
21134 26 76_DB2 v5.1 Reorg shrlevel change on a single partition of a 10 partition table10_Robert Ord21_robertord@HOTMAIL.COM28_Mon, 7 Aug 2000 13:40:36 GMT308_- I am having a problem performing an online reorg of single partition holding about 11 millions rows. The unload phase takes 5 minutes but the reload phase is taking a couple of hours to load just 1 million rows.<br><br>Does anyone have any ideas why this should be and what can do to speed things up. [...]
21161 88 16_Runstats Problem4_DBAS14_DBAS@CWCOM.NET30_Mon, 7 Aug 2000 14:42:20 +0100390_iso-8859-1 We are in the process of upgrading to Version 5 of DB2 from Version 4.1. Last weekend we rolled one of our development subsystems up to version 5 and back again. Everything worked as expected, we had a successful migrate and thought we had a successful fallback. However, we are trying to run runstats back at Version 4.1 and getting the following failure message: 00E40213 [...]
21250 179 38_Re: Removing Runstats from the Catalog24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM30_Mon, 7 Aug 2000 23:39:09 +1000317_iso-8859-1 I use the following SQL to reset STATS for tables that have zero rows. I figure that default stats are better than the optimiser believing that the table has no rows and then set the stats time ahead by a fixed amount so that you can identify which stats have been changed and when they were changed. [...]
21430 76 3_Re:12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Mon, 7 Aug 2000 14:47:00 +0100367_- If you look for RUNSTATS in the utility guide and reference for whichever release you are on, you should find a table of columns used to select data access paths. You should find that these are all updateable (look in SQL Reference Appendix D DB2 Catalog Tables) Note that according to this, not all updateable columns are used for data access path selection. [...]
21507 160 20_Re: USERS and GROUPS27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Mon, 7 Aug 2000 09:55:24 -0400295_iso-8859-1 Hi !<br><br>How do I add users to groups in a DB2 V6.0 for Windows NT. I have a SAMPLE Database in which I have created some tables and want to grant access on update , select, etc to a particular Group say XYZ.<br><br>The question is : How do I add user ABC to this group XYZ ? [...]
21668 121 12_Re: 'unstat'12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Mon, 7 Aug 2000 14:54:00 +0100454_iso-8859-1 I guess sometimes the only way forward is to go backwards.<br><br>We set some tablespaces back to -1 because they are very volatile and normally empty when runstats are run, as we were happy with the performance on these particular tables before we did runstats/rebind, we do runstats on everything then reset some of them, I guess we could try to guesstimate some 'real' values, but what's the point when it worked ok before we started. [...]
21790 108 20_Re: high bsds access10_Tom Taylor17_ttaylor@CHUBB.COM30_Mon, 7 Aug 2000 09:51:28 -0400328_us-ascii Sanjeev<br><br>Along the lines of logging and high bsds access, it seems that OUTBUF and WRTHRSH work together.<br><br>1) Is OUTBUF the amount of storage that can be used? 2) Is this storage carved up in to x number of buffers? 3) Is WRTHRSH the number of these buffers to be filled before I/O to the active logs? [...]
21899 52 29_Re: TSO Attach Feature vs CAF20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Mon, 7 Aug 2000 09:55:35 -0400415_us-ascii I had an IDUG presentation on this topic this year in Dallas. I have done lot of benchmarks using various traces for TSO, CAF & RRSAF. There are no performance differences between TSO vs CAF. The difference is the storage used.<br><br>If you are running short on storage below 16 MB line using TSO ATTACH then it make sense to change it over to CAF using implicit connection else it is not advisable. [...]
21952 181 12_Re: 'unstat'0_22_BILL_GALLAGHER@PHL.COM30_Mon, 7 Aug 2000 09:58:01 -0400502_iso-8859-1 Colin,<br><br>Try dropping and recreating the tablespace and all subordinate objects (tables, indexes, etc). It's not that elegant, but it will get your desired results.<br><br>Bill Gallagher, DBA Phoenix Home Life Enfield, CT<br><br><br><br><br><br><br><br><br><br>"Allen, Colin" <Colin.Allen@ABBEYNATIONAL.CO.UK>@RYCI.COM> on 08/07/2000 09:54:00 AM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.COM> [...]
22134 15 20_Re: USERS and GROUPS14_Philip Gunning18_pgunning@PHEAA.ORG30_Mon, 7 Aug 2000 09:59:08 -0400492_us-ascii Deepak, You create the group in NT via user manager and add users to the group. You then authorize access to objects at the group level. DB2 uses operating system security on all platforms so if you keep that in mind you should be okay. Phil<br><br>================================================ 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.
22150 122 29_Re: TSO Attach Feature vs CAF27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Mon, 7 Aug 2000 10:21:42 -0400601_iso-8859-1 Venkat,<br><br>Maybe, but woud'nt you say that CAF is a much better alternative than the others for the following reasons ? Also , does'nt it put less load on the CPU and allow you to connect to different CPUs in different locations !<br><br>1. The new Call Attach connects to DB2 at the time your application executes SQL, not before. With IKJEFT01(the other alternative), the connection and the opening of your plan happened ahead of your application. And it happened even if your application didn't execute SQL. What makes this so important is that in our environment, the same JCL [...]
22273 34 20_Re: USERS and GROUPS27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Mon, 7 Aug 2000 10:25:47 -0400509_iso-8859-1 Thanks Philip,<br><br>I'm trying it out !<br><br>Regards, Deepak.<br><br>-----Original Message----- From: Philip Gunning [mailto:pgunning@PHEAA.ORG] Sent: Monday, August 07, 2000 7:29 PM To: DB2-L@RYCI.COM Subject: Re: USERS and GROUPS<br><br><br><br>Deepak, You create the group in NT via user manager and add users to the group. You then authorize access to objects at the group level. DB2 uses operating system security on all platforms so if you keep that in mind you should be okay. Phil [...]
22308 18 17_VSAM odbc drivers21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US30_Mon, 7 Aug 2000 11:04:19 -0400431_iso-8859-1 Hi all<br><br>Does anyone have any experience with Merant's SequeLink for VSAM or any recommendations for other vendors that offer access to VSAM files via ODBC calls?<br><br>Jim<br><br>================================================ 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.
22327 19 23_Re: INSERT performance?23_kswinski@massmutual.com23_kswinski@MASSMUTUAL.COM30_Mon, 7 Aug 2000 09:46:40 -0500300_- We had a similar Strobe that showed most of the time being spent fetching index entries (cutout below). We also saw a lot of Dynamic Prefetch Events in the bufferpool for the tables and indexes in question. Runstats showed that an index was badly in need of a reorg, which solved the problem. [...]
22347 37 22_Re: TSO attach problem50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Mon, 7 Aug 2000 11:15:03 -0400472_- Anybody ever encountered the following problem or similiar?<br><br>I have batch job running then hangup. We cancel the job receive a 222 error on MVS, then look at the DB2MSTR and get the standard ::<br><br>DSN3201I ! ABNORMAL EOT IN PROGRESS FOR CONNECTION-ID=TSO CORRELATION-ID=<br><br>Then when going into TMON the current thread summary shows the thread still there. I have cancelled the thread thru TMON and thru option 7 of DB2I panel. But they still remain. [...]
22385 101 27_Re: DB2 Connect EE install.12_tim malamphy20_timalamphy@YAHOO.COM30_Mon, 7 Aug 2000 08:46:25 -0700562_us-ascii Cliff- Welcome to the "dark side". In addition to what Glenn says, I think you might need NT domain Admin Rights for the install. Just use all the excuses DBAs have given you over the years about why they needed SYSADM... :-). And I needed to use a MF Sysadm id to make the MF definitions in Connect until I discovered the catalog noauth parameter. Tim --- "Mackey, Glenn" <GMackey@GUIDEMAIL.COM> wrote: > Cliff, > > 1. Install the "Run-time Clients" on the clients. > There should be a CD with > a name like that. > 2. Use configuration assistant [...]
22487 32 31_Expired password, ODBC & OS/39014_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Mon, 7 Aug 2000 11:52:44 -0400528_iso-8859-1 We have a situation where certain users have coded their RACF passowrds in the ODBC configuration. They then use Microsoft Access/Powe Builder to link to OS390 DB2 tables using the ODBC DSN. The problem occurs when their password is expired on the mainframe. The client hangs and on the OS390 DB2's MSTR address space we see these hundreds of DDF processing failure with reason code=00F30086. It appears that the client tries to connect to OS390 database indefinitely. We experience this problem when we connect [...]
22520 119 27_Re: DB2 Connect EE install.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Mon, 7 Aug 2000 08:55:14 -0700626_iso-8859-1 I do have the NT domain Admin Rights, It was really pretty easy, the LANey folks got tired of coming over to install stuff on our PCs. Thanks cliff:-)<br><br><br><br>-----Original Message----- From: tim malamphy [mailto:timalamphy@YAHOO.COM] Sent: Monday, August 07, 2000 8:46 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect EE install.<br><br><br><br>Cliff- Welcome to the "dark side". In addition to what Glenn says, I think you might need NT domain Admin Rights for the install. Just use all the excuses DBAs have given you over the years about why they needed SYSADM... :-). And I needed to use a MF Sysadm [...]
22640 129 20_Re: high bsds access19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 7 Aug 2000 10:51:39 -0500594_ISO-8859-1 Hi Tom, I too was interested in this several years ago so I figured I'd do an update by searching thru 'da books'(V6). Couldn't find anything negative except the warning not to exceed 20% of the buffers for the write threshold.<br><br>Regards, Rick<br><br>"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 [...]
22770 65 35_Re: Expired password, ODBC & OS/39014_Jones, Peter J18_pjones2@LEHMAN.COM30_Mon, 7 Aug 2000 12:05:17 -0400404_- Manas,<br><br>We had this problem using Powerbuilder. I believe it's a bug in the DB2 client code.<br><br>The looping you describe is caused by PBs default use of the SQL_DRIVER_COMPLETE option in the fDriverCompletion argument of the SQLDriverConnect ODBC function call. If you change it to SQL_DRIVER_NOPROMPT, you'll get the appropriate "expired password" error message returned to the client. [...]
22836 23 46_Managing DB2 objects via ChangeMan from Serena13_Tim K. Larsen23_tim-kent.larsen@UBS.COM30_Mon, 7 Aug 2000 17:55:45 +0200541_US-ASCII Is anyone out there doing change management on their DB2 objects (tables, triggers etc.) using ChangeMan from Serena ?<br><br>If so, how did you set it up? Are you using additional software packages? Are there any pitfalls?<br><br>Thanks in advance Tim Larsen<br><br>tim-kent.larsen@ubs.com<br><br>================================================ 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.
22860 179 20_Re: high bsds access13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Mon, 7 Aug 2000 09:11:30 -0700407_iso-8859-1 Yes WRTHRSH is the number of OUTBUF buffers to be filled up before I/O to active logs is scheduled. But I/O can be scheduled even prior to reaching WRTHRSH in case the log encounters a commit by some UOW . So, in a transaction oriented environment, with default value of WRTHRSH, I think commits and not WRTHRSH would be the triggering factor for output buffers to be written to active log. [...]
23040 34 29_Re: TSO Attach Feature vs CAF12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 7 Aug 2000 11:07:03 -0500321_- I tend to favor the TSO attach in most situations.<br><br>When we get down to measuring performance, the maximum I've seen is around one tenth of a second. Where the TSO modules are heavily used, they are generally moved to LPA, so there is one set of modules for all of the users. That will reduce the times too. [...]
23075 93 23_Re: INSERT performance?14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Mon, 7 Aug 2000 11:24:29 -0500559_iso-8859-1 Mike:<br><br>A lot of things can slow down your INSERT performance. First of all, you can compare INSERTs to the same table to get similar performance characteristics, but INSERTs within the same application to different tables will have not provide any meaningful data. There are really two types of INSERTs:<br><br>1) sequential inserts - occur when there is no free space; all inserts go at the end of the data set 2) random inserts - occur when there is free space; DB2 will attempt to preserve clustering based on key of the inserted row [...]
23169 40 23_Re-initialising DSNDB070_24_Mike_Jarrett@MANDG.CO.UK30_Mon, 7 Aug 2000 17:25:26 +0000365_us-ascii Hi List,<br><br>We have a number of whole-volume DSNDB07 datasets which, for simplicity of D.R., I would like to include in our daily backups, along with everything else. However, given their size this is a bit extravagant, and we currently re-create from scratch at D.R. tests, to save the time & space which would be taken up by dumping them daily. [...]
23210 11 12_Re: 'unstat'10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Mon, 7 Aug 2000 11:12:12 -0500379_- If the tables are so volatile, can't you arrange for a one-off RUNSTATS/REBIND at a point in time when your tables have been populated?<br><br>================================================ 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.
23222 41 25_DB2 replication question.0_25_George_White@VANGUARD.COM30_Mon, 7 Aug 2000 12:43:25 -0400635_us-ascii Hi.<br><br>I have two questions regarding data replication in a OS\390 DB2 V6 environment.<br><br>(1) Our current replication implementation uses BMC's Unload+\Load+ as the solution. To ensure consistency, we execute the unload utility in sharelevel reference. Because of this, one of our major databases is off-line for approximately 30 minutes each day. The data need only be unloaded once a day and there is no requirement for immediate replication. We were going to use one the replication tools (IBM Data Propagator, BMC ChangeDataMove) for this effort but an alternative was raised to use EMC hardware replication. [...]
23264 44 80_Re: DB2 v5.1 Reorg shrlevel change on a single partition of a 10 partition table15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Mon, 7 Aug 2000 12:03:03 -0500514_iso-8859-1 Just suggesting a possible cause...you have a number of indexes and possibly have specified the SORTKEYS parameter in your REORG. When you reorg a partition, all indexes are affected and specification of SORTKEYS kicks off sub-tasks sorting index keys in the RELOAD phase.<br><br>-----Original Message----- From: Robert Ord [mailto:robertord@HOTMAIL.COM] Sent: Monday, August 07, 2000 8:41 AM To: DB2-L@RYCI.COM Subject: DB2 v5.1 Reorg shrlevel change on a single partition of a 10 partition table [...]
23309 193 73_Re: UNICODE data in a DB2 for OS/390 Version 5 table - here's an idea ...12_Stephen Goss19_sgoss@FOCALPT.CO.UK30_Mon, 7 Aug 2000 11:46:20 -0500581_ISO-8859-1 Georg,<br><br>This should work fine. You could use char, long varchar whatever and indexes could be used subject to normal db2 limitations. You can store anything in the column - its irrelevant to db2 that it's unicode if you're just passing it back to the client for input/output. There's no reason why you can't do business rule processing on the mainframe as well. Of course if you need to process the contents of the field rather than just move it about then you will need some unicode intelligence in the mainframe software - but that shouldn't be a big deal. [...]
23503 89 35_Re: Expired password, ODBC & OS/39014_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Mon, 7 Aug 2000 13:41:03 -0400598_iso-8859-1 Thanks, Peter. We'll make the change in Power Builder. In MS Access however I do not see this argument as being configurable.<br><br>Thanks, Manas.<br><br>> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Jones, Peter J > Sent: Monday, August 07, 2000 12:05 PM > To: DB2-L@RYCI.COM > Subject: Re: Expired password, ODBC & OS/390 > > > Manas, > > We had this problem using Powerbuilder. I believe it's a bug in the DB2 > client code. > > The looping you describe is caused by PBs default use of the > SQL_DRIVER_COMPLETE option [...]
23593 89 15_Re: DB2 Locking19_Jaiwant K. Jonathan25_jkjonath@DOAS.STATE.GA.US30_Mon, 7 Aug 2000 12:26:56 -0500353_- Here is a trick that I adopt sometimes when a program would benefit from a LOCK TABLE statement. The idea is to avoid excessive locks being taken on the same table. We have also employed this in instances when the system limit on the number of locks has exceeded due to excessive locks on one table resulting in a -904 with reason code 00C90096. [...]
23683 22 21_Re: Help asap please.19_Jaiwant K. Jonathan25_jkjonath@DOAS.STATE.GA.US30_Mon, 7 Aug 2000 12:34:16 -0500533_- Harish, You can probably try synonyms and create a different qualifier for the tables. Then you can set up a separate plan with this this qualifier and a collection with the same. The owner can be the same. However, you cannot achieve the data independence you are talking about without physically isolating data or controlling acces through a program. Which means, using the synonyms will only be deceiving the user into thinking he is using a different database, but the underlying database (and the data) will be the same. [...]
23706 101 35_Re: Expired password, ODBC & OS/3900_24_lightsey@ITS.STATE.MS.US30_Mon, 7 Aug 2000 14:22:29 -0500367_us-ascii my Powerbuilder user(s) had this error and, rather than a change to the PB app, there was a fix from IBM that updated the DLL on the client machine (DB2connect 5.2).<br><br><br><br><br><br>"Jones, Peter J" To: DB2-L@RYCI.COM <pjones2@LEHM cc: AN.COM> Subject: Re: Expired password, ODBC & OS/390 Sent by: DB2 Data Base Discussion List <DB2-L@RYCI.C OM> [...]
23808 28 11_TCP/IP DRDA8_Nick Nur19_Nick_nur@WSIB.ON.CA30_Mon, 7 Aug 2000 14:58:39 -0500515_- Hi everyone. I hope you can help me. I am in the process of planning for the implementation of LEVEL II DRDA using DB2 OS/390 v5.1, TCPIP and DB2 Connect EE on AIX machine and two phase commit. Here is my question prefixed by "I know": 1. I know that Level II means multiple site updates and two phase commit 2. I know that DB2 OS/390 v5.1 and up supports Level II DRDA for both SNA and TCP/IP 3. I know that the Sync. Point Manager(SPM) is needed for SNA DRDA implementation of Level II on OS/390 DB2. 4. I [...]
23837 207 29_Re: Stored Procedure Question13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Mon, 7 Aug 2000 18:59:11 EDT439_- Hi Mr. Leatherman, list, I followed this thread a little bit last week, and lo and behold, i'll soon be getting request to create a WLM stored procedure. Item #3 of the checklist you provided talked about a Db2 Request form for a Stored Procedure that is sent to DBA. I was wondering if you could share an example of the form you use in you shop with me. I think, like the checklist, very helpful to store procedure rookie like me! [...]
24045 16 50_Trimming fixed-length char columns during the load7_Db2 Dba24_data_analyst@HOTMAIL.COM30_Mon, 7 Aug 2000 18:17:55 -0500498_- Hi everyone,<br><br>Is there a way to strip trailing blanks in CHAR column during the load? I know that stripblanks/stripnulls works for variable-length columns. What is the best way to handle this for fixed-length char columns?<br><br>Thanks in advance.<br><br>================================================ 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.
24062 88 29_Re: TSO Attach Feature vs CAF0_19_Tim.Lowe@STPAUL.COM30_Mon, 7 Aug 2000 11:37:26 -0500330_us-ascii Roger, You are certainly right that we had problems several years ago when implicit call attach failed to connect. (It was not setting the sqlcode, but only the return-code when implicit call attach connection errors occurred.) But, then the sqlcode -991 was created (early in version 5?), which fixes this problem. [...]
24151 375 28_Re: Data Propagator question11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Tue, 8 Aug 2000 11:38:58 +1000367_- I meant to add a second point to this yesterday, and forgot:<br><br>All comments below only apply to DB2 OS/390. In little db2 (UNO), this works differently - any update statement is always logged (and therefore Capture will pick up the change), even if no value is actually modified. At least this is the case in V5.2; I have not tested it in later releases. [...]
24527 42 41_regardig IDCAMS, repro (Help needed asap)17_ravi kumar hassan18_ravibh@HOTMAIL.COM28_Tue, 8 Aug 2000 02:53:52 GMT444_- Hi Folks,<br><br>I want to copy a data from one dataset which is Variable block to another dataset which is Fixed block and i tried using IDCAMS, Repro like this<br><br>//IED13A JOBCARD //STEP1 EXEC PGM=IDCAMS //IN1 DD DSN=HFIT.PDS.MNO102,DISP=SHR //OUT1 DD DSN=HDMT.PDS.KFC103, // DISP=(NEW,CATLG,CATLG), // DCB=(RECFM=FB,LGRECL=248), // SPACE=(TRK,(5,2),RLSE) //SYSPRINT DD SYSOUT=* //SYSIN DD * REPRO INFILE(IN1) OUTFILE(OUT1) /* //* [...]
24570 79 45_Re: regardig IDCAMS, repro (Help needed asap)14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Tue, 8 Aug 2000 13:33:09 +1000554_iso-8859-1 You possibly have an input record that is longer than 252 bytes long. (252=248 + 4 bytes of record header) Does the error happen on every record, or just some?<br><br>The only obvious error in your JCL is LGRECL.<br><br>/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: ravi kumar hassan [mailto:ravibh@HOTMAIL.COM] Sent: Tuesday, August 08, 2000 12:54 PM To: DB2-L@RYCI.COM Subject: [DB2-L] regardig IDCAMS, repro (Help needed asap) [...]
24650 36 45_Re: regardig IDCAMS, repro (Help needed asap)0_17_JTonchick@AOL.COM28_Mon, 7 Aug 2000 23:36:59 EDT403_US-ASCII You didn't mention the maximum lrecl or blksize of the IN1 dataset. For this to work, the output must be outlrecl = max inlrecl - 4 and the outblksize a multiple of outlrecl.<br><br>Have you looked into IEBGENER or other OEM products like File/Aid to do the transformation?<br><br>Good Luck<br><br>In a message dated 08/07/2000 9:54:25 PM Central Daylight Time, ravibh@HOTMAIL.COM writes: [...]
24687 84 34_Repost: TDAN.com August Newsletter13_Morrill, John12_JohnM@VP.NET30_Mon, 7 Aug 2000 22:55:14 -0600656_- Re: The Data Administration Newsletter -- http://www.tdan.com/ - August 2000<br><br>"Quality Information for Quality Results" is the theme of the Information Quality Conference, Anaheim, September 24-28, 2000. To learn about the expert presentations and success stories to be presented, visit http://www.infoimpact.com/body/IQConf2000_Home.htm.<br><br>- - - - -<br><br>The 3rd Anniversary Issue of TDAN.com (posted 7/1) focused on enterprise data management and data warehousing. If you have not had a chance to read the articles, resources, conferences, job ads, etc. here are some quick links to take you to the sections updated for issue 13.0 -- [...]