1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2001, week 4
2 138 19_Re: Trigger Unhappy0_24_markus.schaub@SYSTOR.COM31_Thu, 22 Feb 2001 09:17:39 +0100551_us-ascii hi all
we are using similar triggers like the one suresh shared and in most cases they are working fine.
but in some rare cases we ran into troubles. the problems are not trigger specific, they are caused by the SQL UPDATE ... SELECT. if the updated column is nullable and the select returns a empty result for one row, the updated column is set to null for the current row (all correct so far), but !! if there are more than one row updated in the same commit scope (unit of work) the column updated is null regardless if [...]
141 50 31_Re: Broken page during DSN1COPY15_Sriram Sankaran27_ssgsriram@CHENNAI.TCS.CO.IN31_Thu, 22 Feb 2001 13:58:59 +0530767_us-ascii Thanks everyone. The problem was because I had not mentioned '32K' during DSN1COPY. I did that and it went through like a breeze.
Thanks once again.
Regards, Sriram
Tom.Decabooter@HONDA-EU.COM on 21/02/2001 01:31:05 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Sriram Sankaran/Support/TCSCHENNAI)
Subject: Re: Broken page during DSN1COPY
DSN1COPY reports a broken page if you copy a 32K tablespace without specifying the 32K parameter. I ran into this problem not so long ago. After recovering the tablespace, i still had the 'broken page' error message when using DSN1COPY to restore an image copy from [...]
192 43 32_SET CURRENT PACKAGESET WITH CICS10_john clark20_pak02449@PIXIE.CO.ZA31_Thu, 22 Feb 2001 11:06:48 +0530592_us-ascii While I think that I may already know the answer to this question (after searching the archives and enquiring of local experts), I thought that I would try to get a definitive answer from the list.
I have been asked about the best way to point to multiple databases which are mirrors of each other (One DB2 subsystem). Obviously batch presents no problem whatsoever in that we can bind several times and use different plans (along with other methods). In CICS (one CICS several databases)I am looking at SET CURRENT PACKAGESET which on the surface seems to fit the bill. [...]
236 119 33_Re: Archive and Purge of DB2 data15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Thu, 22 Feb 2001 13:41:33 +0100577_iso-8859-1 Cathy, Toni,
HTH, From a Datawarehouse perspective I had contact last year with Princeton Softtech and Pine Cone systems. They're both partners of BMC. Pine Cone has a product that captures SQL on data, in doing so they can predict which part of the data is used. As you mentioned Princeton has Archive for DB2 and it operates after periods of time. (e.g. Archive after 1 month) Last year I asked Princeton wether they could work together with Pine Cone.. If you know which data is used, you also know which data you don't use and you could archive this [...]
356 59 66_Re: S/390 database app wins scalability honors; Oracle cries fou l11_KATHY JONES26_JONESKS@GROUPWISE.CCSD.NET31_Wed, 21 Feb 2001 16:29:49 -0800448_US-ASCII You have to include the value 2,00.html that is on the second line and then it comes up.
>>> SPhilip@CSXLINES.COM 02/21/01 04:15PM >>> Could anybody ready this. I could not? Is this URL correct?
-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Tuesday, February 20, 2001 07:00 PM To: DB2-L@RYCI.COM Subject: FYI: S/390 database app wins scalability honors; Oracle cries fou l [...]
416 47 57_Re: Websphere monitoring/tuning from a DBA's perspective?15_Stacey L Waters23_waterss1@NATIONWIDE.COM31_Thu, 22 Feb 2001 07:17:21 -0600698_us-ascii Lynne, IBM has a paper with recommended parameter settings.
Lynne Flatley @RYCI.COM> on 02/21/2001 08:16:56 AM
From: Lynne Flatley @RYCI.COM on 02/21/2001 08:16 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Websphere monitoring/tuning from a DBA's perspective?
We have several applications currently developing their applications using Websphere 3.5 on NT. Does anyone have any monitoring/tuning tips for either the WAS repository db or the SESSIONS db? [...]
464 54 33_Re: Archive and Purge of DB2 data15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Thu, 22 Feb 2001 07:17:44 -0600420_iso-8859-1 A very simple method is to use the REORG DISCARD option. Its main advantage is that it avoids logging of the 'deletes' if LOG NO is used. You may have to worry about RI however.
Andy Lankester My opinions are just that
-----Original Message----- From: Taddei, Cathy [mailto:Cathy.Taddei@PACIFICORP.COM] Sent: 22 February 2001 00:58 To: DB2-L@RYCI.COM Subject: Archive and Purge of DB2 data [...]
519 93 48_Re: questions for update / insert into db2 table15_Jackson Reavill18_damcon2@US.IBM.COM31_Thu, 22 Feb 2001 09:16:21 -0500523_us-ascii Qian,
If you are using UDB (Little DB2), then use the import utility with the commitcount parm set to something manageable. If this is OS/390, then use the log no parm.
Cheers, Jay
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. - Bavarian Motor Works ----------------------------------------------------- [...]
613 78 66_Re: S/390 database app wins scalability honors; Oracle cries fou l16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Thu, 22 Feb 2001 09:51:07 -0500448_us-ascii Just to annoy everyone once more....
".....I think you have to add 2,00.html to the end of the URL."
KATHY JONES on 02/21/2001 07:29:49 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: RICHARD E MOLERA/SallieMae) Subject: Re: S/390 database app wins scalability honors; Oracle cries fou l [...]
692 29 31_dropped table recovery question17_Wood, Christopher17_cwood@CAYENTA.COM31_Thu, 22 Feb 2001 06:48:47 -0800500_ISO-8859-1 I have changed environments recently:
In my old environment UDB/NT 5.2 we had to frequently drop and re-create tablespaces due to a bug in the load utility (which has since been fixed), and if we had "DROPPED TABLE RECOVERY ON" we would get the log full message when we attempted to do the drop tablespace. I assumed this was because it was logging the delete of every row (or at least page) in the tablespace. So we created all our tablespaces with DROPPED TABLE RECOVERY OFF [...]
722 75 48_Re: questions for update / insert into db2 table17_Wood, Christopher17_cwood@CAYENTA.COM31_Thu, 22 Feb 2001 07:10:38 -0800369_ISO-8859-1 Qian
Jay and Lily were correct, but they did not tell you how to generate the input file with the extra column. I would suggest doing an export with an SQL that generates the additional column. If this is not immediately obvious. send me the update statement that was going to update more than the 10K records, I will compose the select for you. [...]
798 86 57_Re: Websphere monitoring/tuning from a DBA's perspective?0_22_BILL_GALLAGHER@PHL.COM31_Thu, 22 Feb 2001 10:30:41 -0500415_us-ascii Stacey,
Do you know where we could get this paper from? Is it available at IBM's web site? Do you have a URL?
Bill Gallagher, DBA Phoenix Home Life Enfield, CT 06083
Stacey L Waters cc: Sent by: DB2 Subject: Re: Websphere monitoring/tuning from a DBA's perspective? Data Base Discussion List [...]
885 43 49_need help in creating partition tablespace in UDB12_Gopi Krishna21_Gopi.Krishna@WCOM.COM31_Thu, 22 Feb 2001 09:21:50 -0600422_iso-8859-1 Hi, When I tried to create Partition table space in UDB NT, thru CREATE NODEGROUP MAXGROUP ON NODES (1, 2, 5) I am getting a messages saying that "node 1 is not found"
when I tried to add a node thru
ADD NODE LIKE NODE 1
I am getting .. add node like node 0 ------------------------------------------------------------------------ SQL1096N The command is not valid for this node type. [...]
929 34 8_DSNILKES17_Polley, Mike (M.)16_mpolley@FORD.COM31_Thu, 22 Feb 2001 10:31:58 -0500571_iso-8859-1 We have an IMS transaction that is locking up after 5 or more users. From DB2 we're getting the following error:
DSN3201I -DSN3 ABNORMAL EOT IN PROGRESS FOR USER=BPCDA37 CONNECTION-ID=IMST CORRELATION-ID=0003SBP8888 JOBNAME=SDIMT31B TCB=006E5BF8 DSNI031I -DSN3 DSNILKES - LOCK ESCALATION HAS OCCURRED FOR RESOURCE NAME = TPT@TDB.MRTMA31_INVIDX LOCK STATE = X PLAN NAME : PACKAGE NAME = ALRTM500 : ALRTM500 STATEMENT NUMBER = 010888 CORRELATION-ID = 0007ALRTM500 CONNECTION-ID = IMST LUW-ID = DBNANET.DSN3.B56CD97AF42E THREAD-INFO = FDAL118 : * : * [...]
964 158 14_Re: Query Help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Thu, 22 Feb 2001 10:20:07 -0600443_iso-8859-1 Sanjeev,
Notice I added the word MAY, since the problem highlighted is possible, but MAY not apply to Michael (this time).
I've added some tests to show what I was saying, but also noticed that the original syntax from Michael was incorrect because the column referenced in the subquery was not part of the GROUP BY (or within a column function). So I've written this assuming that the syntax was correct........ [...]
1123 92 12_Re: DSNILKES15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Thu, 22 Feb 2001 17:28:24 +0100438_iso-8859-1 Excerpt from the manual:
"Lock escalation balances concurrence with performance by using page locks while a process accesses relatively few pages, then changing to tablespace or table locks when the process accesses a number of pages that exceeds a defined treshold (LOCKMAX) for the tablespace."
name = Database_Name.Tablespace_Name or name = Creator_Name.Table_Name or name = Database_Name.Tablespace_Name [...]
1216 24 20_UDB EE and Nodegroup20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Thu, 22 Feb 2001 17:37:46 +0100602_- Hello, Can anyone be so kind to stop one minute and try to eplain me one thing? I'm working with DB2 UDB Enterprise Edition 7.1 and I can't really understand the concept of the object "Nodegroup", or better I can see the reason for defining that kind of object in a distribuited environment (DB2 UDB EEE), but why should I define different nodegroups when I'm working on a single node? Why when I create a DB three nodegroup (IBMCATGROUP, IBMTEMPGROUP, IBMDEFAULTGROUP) are created by default? Why othe applications also (QMF for Windows) do create multiple nodegroups to span their tablespaces [...]
1241 82 36_Re: SET CURRENT PACKAGESET WITH CICS0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 22 Feb 2001 10:56:15 -0600454_us-ascii We've been using SET CURRENT PACKAGESET for the last 6 years. For our online modules, we execute it at the very start of the module so that it is invoked once for each transaction in our pseudo conversational setup.
When you are running multiple DBs in a single CICS, you are aware that they are all running the same version of the source code. This is appropriate for a training type setup, it is NOT for a development environment. [...]
1324 31 42_Loading with RESUME YES and recoverability14_Carroll, Ouida24_Ouida.Carroll@BCBSLA.COM31_Thu, 22 Feb 2001 11:06:43 -0600533_iso-8859-1 We have a large partitioned table (os/390 DB2 V6.1) that we want to use the LOAD utility to add some records to the table every night (not necessary in one partition). So, we had planned to run LOAD with RESUME YES. What do we run to make this table recoverable? 1) LOAD with LOG YES? 2) According to the Utility Guide, we can't run an incremental copy if we use RESUME YES, so that's out. Also, we can't take an inline image copy with RESUME, 3)Rull a full image copy every night after the load (we may not have the [...]
1356 62 24_Re: UDB EE and Nodegroup12_Cook, Nicole19_Nicole_Cook@BMC.COM31_Thu, 22 Feb 2001 11:22:45 -0600613_iso-8859-1 Hi Fabrizio,
In my experience, Nodegroups in EE can be used for several different reasons. You can use nodegroups to help with organization of your database, for instance you can put all tablespaces into a particular node group that belong to a certain applications. Another reason to use nodegroups in EE is if you have a development system using EE, but your production system runs EEE, it is very easy to migrate all of your objects from development into production. In a EE system, I haven't seen any performance increase or decrease when I used multiple nodegroups compared to systems [...]
1419 41 15_Re: DB2 Editors14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Thu, 22 Feb 2001 11:39:42 -0600436_iso-8859-1 The table editor is a recent enhancement to BMC Catalog Manager. It is available as of version 6.2.01. You do NOT need to purchase Princeton's product (or any other product) to get the table editor feature with BMC Catalog Manager (as of 6.2.01).
Cheers, Craig S. Mullins Director, DB2 Technology Planning BMC Software http://www.bmc.com Craig_Mullins@bmc.com http://www.craigsmullins.com craig@craigsmullins.com [...]
1461 23 6_DSSIZE0_20_bjnigh@HOUSEHOLD.COM31_Thu, 22 Feb 2001 09:43:19 -0800578_us-ascii We are having difficulties with the DSSIZE parameter and DB2 Version 6. We are able to create a 64-part tablespace with DSSIZE of 64G with no problem. We are experiencing problems, however, when we try and load data greater than 4gig into a partition. I am using the IBM LOAD utility with the REPLACE parameter on a particular partition which I know has data which exceeds 4gig. For some reason, the primary quantity (4 gig) is allocated during the load but the secondary quantity (1 gig) is not being allocated. The load acts as if there is no secondary quantity [...]
1485 67 46_Re: Loading with RESUME YES and recoverability14_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Thu, 22 Feb 2001 12:56:03 -0500324_us-ascii Assuming that this table is image copied daily (full or incremental), QUIESCE the tablespace prior to the LOAD RESUME. If the LOAD fails and can't be restarted, then RECOVER the tablespace to the QUIESCE point. Run the load LOG YES followed by a FULL Image Copy SHRLEVEL CHANGE. I believe that this will work. [...]
1553 215 26_Command Center --- UDB/EEE12_Randy Wilson22_Randy_Wilson@BCBST.COM31_Thu, 22 Feb 2001 13:02:53 -0500351_iso-8859-1 Hello listers, I've been trying to get the reorg command to work within the Control Center GUI ... I right click on the table.. select the table I would like to reorg... I'm then prompted to enter the temp tablespace to use and the index to reorg by ... after selecting these and pressing 'Reorg Now' I'm receiving this error message: [...]
1769 21 14_Delete Pending10_Lee Herbst29_lherbst@PROPAPPR.MARION.FL.US31_Thu, 22 Feb 2001 13:22:25 -0500521_us-ascii I asked for help on this a couple of days ago, but did not get a reply, so I'm trying it again. I have a table space that is stuck in a delete pending state and I can't find a way to get it out of that state. I found some information on phantom quiesces (they specifically mentioned delete pending) and followed the instructions to clear the problem, but after I did the quiesce reset, the table space went back to delete pending. Is there a way to clear this condition? In this state I can't get to any of [...]
1791 17 33_Restarting DB2 EE database on AIX7_TSVANDR20_TSVANDR@LANDSEND.COM31_Thu, 22 Feb 2001 12:32:09 -0600437_iso-8859-1 I have a database that is down. It appears that one of the log files is bad. Is there a way to allow reconnecting to the database without using this log?
Thanks. Tami Van Dreese
================================================ 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.
1809 46 10_Re: DSSIZE9_Saddy, Ed16_Ed_Saddy@BMC.COM31_Thu, 22 Feb 2001 12:27:53 -0600655_iso-8859-1 I encountered a similar problem with the DB2 LOAD. I heard that IBM has fixed this. You might want to check IBM LINK.
-----Original Message----- From: bjnigh@HOUSEHOLD.COM [mailto:bjnigh@HOUSEHOLD.COM] Sent: Thursday, February 22, 2001 11:43 AM To: DB2-L@RYCI.COM Subject: DSSIZE
We are having difficulties with the DSSIZE parameter and DB2 Version 6. We are able to create a 64-part tablespace with DSSIZE of 64G with no problem. We are experiencing problems, however, when we try and load data greater than 4gig into a partition. I am using the IBM LOAD utility with the REPLACE parameter on a particular partition which I [...]
1856 52 18_Re: Delete Pending11_Robert Jans26_robert_jans@ALBERTSONS.COM31_Thu, 22 Feb 2001 11:50:02 -0700543_iso-8859-1 Lee, I worked on DB2 2.1 for AIX years ago and we had a problem with a tablespace. I don't remember exactly what happened but it ended up in an inaccessible state (one of the flags was set) I could not reset the flags by any normal means. I finally got an app from IBM support that allowed me to manipulate the flags manually. This was supplied as a last ditch effort to avoid rebuilding a data warehouse. We were repeatedly warned that using this would leave the database okay but all the data would need to be reloaded...... [...]
1909 28 22_update, insert process15_Amy C Whitehead14_B06ACW@FDS.COM31_Thu, 22 Feb 2001 13:50:24 -0500404_us-ascii All, Need some advice,
Within 1 logical unit of work.... I have a cursor that gets about 3 rows. I select most columns. Then I update 3 of columns where 1 column is part of the of unique index. I do not use update of current. Instead I am updating via a where clause. The update gets SQLCODE of 0. Then I try to insert a new row with the original unique key value and I get an -803. [...]
1938 24 15_Triggers in UDB17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Thu, 22 Feb 2001 13:03:55 -0600485_us-ascii Hello everyone I have a rather strange trigger question for the UDB platform. My manager is concerned about the amount of triggers that I am proposing for my new database to handle RI. He is concerned that a large amount of triggers will some how add overhead to the system and slow it down. Does anyone know of a case or had a problem with triggers used for RI slowing down the application? We are talking a database with 40 or so tables with around 75 triggers for RI. [...]
1963 51 19_Re: Triggers in UDB12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 22 Feb 2001 11:22:43 -0800584_us-ascii I have to ask the obvious question. Why are you proposing triggers to handle RI rather than using DB2's underlying RI mechanisms directly? Its much more efficient to use the direct RI rather than triggers to simulate this, beyond the fact that DB2 has it coded rather than you having to code this yourself. --- Jeremy Schleicher wrote: > Hello everyone I have a rather strange trigger > question for the UDB > platform. My manager is concerned about the amount > of triggers that I am > proposing for my new database to handle RI. He is > [...]
2015 34 17_IP ADDRESS change12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Thu, 22 Feb 2001 13:24:37 -0600500_iso-8859-1 We changed our IP address of one of the LPARS on our system. I updated the CDB IPNAMES to have the new IP address. But when I bounced DB2, I received the following message:
DSNL003I -DB2D DDF IS STARTING DSNL512I -DB2D DSNLILNR TCP/IP GETHOSTBYADDR FAILED WITH RETURN CODE=1 AND REASON CODE=00000000 DSNL004I -DB2D DDF START COMPLETE LOCATION DB2DDIST LU TRSNET.LUDB2D GENERICLU -NONE DOMAIN -NONE TCPPORT 446 RESPORT 5020 DSN9022I -DB2D DSNYASCP 'START DB2' NORMAL COMPLETION [...]
2050 26 39_Re: DSNILKES & type 2 Index locking????13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 22 Feb 2001 14:22:32 -0500401_iso-8859-1 Hey Mike, Long time no see.
You can get to the v6 manuals at http://www.s390.ibm.com:80/bookmgr-cgi/bookmgr.exe/Shelves/DSNSH0G3
Is anyone else surprised to see this level of locking and lock escalation at the index level on a Type 2 Index?
Mike, you say this resource TPT@TDB.MRTMA31_INVIDX is an index, right? And you're v6, so it must be a type 2 index, right? [...]
2077 63 26_Re: update, insert process0_26_JCameron@MSI-INSURANCE.COM31_Thu, 22 Feb 2001 13:24:10 -0600676_us-ascii Was the update COMMITed before the insert ?
Amy C Whitehead To: DB2-L@RYCI.COM Subject: update, insert process Sent by: DB2 Data Base Discussion List
02/22/01 12:50 PM Please respond to DB2 Data Base Discussion List
All, Need some advice,
Within 1 logical unit of work.... I have a cursor that gets about 3 rows. I select most columns. Then I update 3 of columns where 1 column is part of the of unique index. I do not use update of current. Instead I am updating via a where clause. The update gets SQLCODE of 0. [...]
2141 62 26_Re: Dynamic Insert Program0_19_Tim.Lowe@STPAUL.COM31_Thu, 22 Feb 2001 13:30:24 -0600400_us-ascii Mark, I had heard that the new DB2 version 7 Load utility was going to be able to do this. Can you wait for V7?
Tim
Mark McCormack cc: Sent by: DB2 Data Subject: Dynamic Insert Program Base Discussion List
02/21/2001 06:10 PM Please respond to DB2 Data Base Discussion List [...]
2204 36 19_Re: Triggers in UDB12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Thu, 22 Feb 2001 14:38:01 -0500583_us-ascii Jeremy, a trigger that doesn't fire produces no overhead. It isn't so much the number of the triggers that you have but the frequency that each one is used and the type (before vs after, row vs statement etc).
Martin Wolff, Global Crossing.
Jeremy Schleicher wrote:
> Hello everyone I have a rather strange trigger question for the UDB > platform. My manager is concerned about the amount of triggers that I am > proposing for my new database to handle RI. He is concerned that a large > amount of triggers will some how add overhead to the system [...]
2241 49 21_Re: IP ADDRESS change13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 22 Feb 2001 13:47:51 -0600393_US-ASCII John, check the archives, there have been many discussions on this error. I believe it has to do with the USS etc/hosts definition. Regards, Kurt
>>> John.Vernon@TRS.STATE.TX.US 02/22/01 01:24PM >>> We changed our IP address of one of the LPARS on our system. I updated the CDB IPNAMES to have the new IP address. But when I bounced DB2, I received the following message: [...]
2291 47 26_Re: Dynamic Insert Program13_Bright, Randy20_Randy_Bright@BMC.COM31_Thu, 22 Feb 2001 14:02:41 -0600434_iso-8859-1 The next version of LoadPlus for DB2 from BMC Software will do this and will allow setting the commit frequency.
-----Original Message----- From: Mark McCormack [mailto:mamccormack@STATESTREET.COM] Sent: Wednesday, February 21, 2001 6:11 PM To: DB2-L@RYCI.COM Subject: Dynamic Insert Program
I am posting this for a co-worker. Any help would be appreciated.
Mark McCormack [...]
2339 65 21_Re: IP ADDRESS change11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Thu, 22 Feb 2001 14:03:54 -0600431_us-ascii DOMAIN -NONE is not correct. Ours is DOMAIN IBMMWDB. Where "IBMMWDB" is our DNS name. Your DNS name is not working. Try to "TSO PING YOURDNSNAME"... : )
"Vernon, John" cc: Sent by: DB2 Data Subject: IP ADDRESS change Base Discussion List
02/22/01 01:24 PM Please respond to DB2 Data Base Discussion List [...]
2405 50 39_Re: DSNILKES & type 2 Index locking????17_Polley, Mike (M.)16_mpolley@FORD.COM31_Thu, 22 Feb 2001 15:33:19 -0500520_iso-8859-1 Dave, thanks for the V6 manuals, I was looking for the message code: DSNI031I Couldn't find it in the V5 message and codes.
At first and desparate glance I thought the culprit was an index. Not! Just has a misleading table name.
Thanks to you and all others for your reply.
-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Thursday, February 22, 2001 2:23 PM To: DB2-L@RYCI.COM Subject: Re: DSNILKES & type 2 Index locking???? [...]
2456 71 38_Re: Plan DISTSERV Locks whole Database15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 22 Feb 2001 14:58:36 -0600586_iso-8859-1 Hi, Popy, You have two problems here. First, your JAVA app is probably using JDBC (dynamic SQL) so it requires a lock on the DBD to do its dynamic bind. This causes the failures on your ALTER statements. Second, if your JAVA apps are not commiting often enough the locks are not released on a timely basis so that another thread can acquire locks on the tables. This gets even worse if someone walks away from their workstation and the locks haven't been released. The effect is the same as if conversational CICS transactions were used (Anyone remember THOSE?). Third, [...]
2528 31 32_SQL Statement 0 in large program5_Chris17_isatcjk@YAHOO.COM31_Thu, 22 Feb 2001 13:19:19 -0800461_us-ascii Hi Everybody, A large program that I'm tuning has STMTNO = zero for many of it's statements.
Does anybody know if Platinum's RC/Query and Omegamon for DB2's Application Trace...whether they're using an older/shorter statement number from the SYSIBM.SYSSTMT table (stmtno)?
Perhaps the STMTNOI column in SYSIBM.SYSSTMT table should be used?
Thanks Chris
===== http://www.geocities.com/isatcjk/index.html [...]
2560 76 19_Re: Triggers in UDB0_22_BILL_GALLAGHER@PHL.COM31_Thu, 22 Feb 2001 16:26:19 -0500569_us-ascii You also need to take into account the actual work that a trigger will perform once it is fired. If it's performing a few simple actions, the overhead may not be that significant. It's a different story if the work is more complex.
On the other hand, if the work that needs to be done fits a business requirement, then it probably doesn't matter if it's being accomplished by a trigger or by application logic. Doing it via a trigger would provide a little more integrity because you can be assured that it will always be fired consistently by the [...]
2637 113 38_Re: Plan DISTSERV Locks whole Database0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 22 Feb 2001 15:31:24 -0600386_us-ascii Poppy, when you first posted the question it wasn't an issue here. Then yesterday I ran into ***exactly*** the same problem! A developer testing JAVA had a session abend, and although the SQL itself was finished (CLOSEs = OPENs) JAVA held a lock on the DB (actually I've been told it was on the DBD) for over 7 hours until the Websphere server was shutdown and restarted. [...]
2751 46 10_Re: DSSIZE13_Olson, Carlos14_COlson@QRS.COM31_Thu, 22 Feb 2001 13:47:41 -0800899_iso-8859-1 I just had the same problem. Click on this link for the answer:
http://techsupport.services.ibm.com/support/390.support/phuic?query=PQ36667+ ++++++++++&prod=ALL&maxhits=20&startmonth=1&startyear=1997&endmonth=10&endye ar=2000&startrec=0&who=psearch&stype=Exact+Words&sortby=proximity
Carlos Olson Database Administrator QRS Corporation
-----Original Message----- From: bjnigh@HOUSEHOLD.COM [mailto:bjnigh@HOUSEHOLD.COM] Sent: Thursday, February 22, 2001 9:43 AM To: DB2-L@RYCI.COM Subject: DSSIZE
We are having difficulties with the DSSIZE parameter and DB2 Version 6. We are able to create a 64-part tablespace with DSSIZE of 64G with no problem. We are experiencing problems, however, when we try and load data greater than 4gig into a partition. I am using the IBM LOAD utility with the REPLACE parameter on a particular partition which I know [...]
2798 61 26_Re: update, insert process14_Richard Yevich17_ryevich@YAHOO.COM31_Thu, 22 Feb 2001 13:50:27 -0800533_us-ascii Amy,
Until you COMMIT, that old row with the unique key change, has not been changed. After COMMITing the original, then your INSERT should work.
--- Amy C Whitehead wrote: > All, > Need some advice, > > Within 1 logical unit of work.... > I have a cursor that gets about 3 rows. I select most columns. > Then I update 3 of columns where 1 column is part of the of > unique > index. I do not use update of current. Instead I am updating > via a > where clause. The update gets SQLCODE of [...]
2860 60 36_Re: SQL Statement 0 in large program12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Thu, 22 Feb 2001 16:02:36 -0600297_us-ascii Chris: What version of DB2 are you running? There used to be a patch to handle statement numbers that could not fit in the small init value that held statement number. The number was reset to zero and all SQL statements that followed had the same number 0. How large is the program? [...]
2921 105 26_Re: update, insert process15_Amy C Whitehead14_B06ACW@FDS.COM31_Thu, 22 Feb 2001 16:52:10 -0500406_us-ascii No, The update is not committed prior to insert, but it is within 1 logical unit of work. If something fails along the way, the unit of work needs to be rolled back along with the update.
If DB2 requires the update to be committed, then following approach should not work either, right? Then changing this logic to delete 1 record and insert 2 records will not work without an commit? [...]
3027 174 38_Re: Plan DISTSERV Locks whole Database13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Thu, 22 Feb 2001 14:03:16 -0800445_iso-8859-1 In fact SQLJ actually IS Database independent (One more reason to prefer SQLJ over JDBC). This is because SQLJ translator replaces the SQLJ statements contained in the Java source program with calls to a generic SQLJ runtime layer. All database vendors supporting SQLJ ship the same SQL translator thereby making it DB independent. SQLJ Runtime component is then capable of selecting the correct runtime code for any given DBMS. [...]
3202 74 26_Re: update, insert process0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 22 Feb 2001 16:26:57 -0600294_us-ascii Then I update 3 of columns where 1 column is part of the of unique index. I do not use update of current. Instead I am updating via a where clause. The update gets SQLCODE of 0. Then I try to insert a new row with the original unique key value and I get an -803. [...]
3277 47 12_Data masking14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU31_Fri, 23 Feb 2001 09:41:03 +1100678_iso-8859-1 **************************************************************** IMPORTANT
The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...]
3325 35 30_DB2 390 MODIFY performance fix28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Thu, 22 Feb 2001 17:48:13 PST594_- A performance fix for the MODIFY RECOVERY utility is currently entering beta test and should be available in 2Q 2001 if the test goes well.
The performance improvements are substantial, but given how bad performance was, it could hardly be otherwise. (I thought I'd say it before someone else did!) On a 10,000 row SYSCOPY cleanup operation we see reductions in elapsed and CPU in excess of 95% (Your mileage may vary). SYSLGRNX cleanup is not affected by this change. Other fixes for MODIFY are available or are in progress to reduce the number of locks held, reduce rollback on [...]
3361 23 34_UDB v7.1 EEE on AIX SQL Procedures13_Todd Grinaway21_tgrinaway@RITEAID.COM31_Thu, 22 Feb 2001 22:18:33 -0500462_us-ascii Hello everyone, We are new to UDB EEE, and are running into an issue with compiling SQL Procedures. We are able to compile them, but only on the catalog owning node. We also only seem to be able to run them on the same SP node we create them (currently have two DB2 nodes sharing an SP node). Can anyone tell if they have/had this experience, we are just getting started with SQL procedures and have covered all the doc we can find to no avail.... [...]
3385 82 39_Re: DSNILKES & type 2 Index locking????16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 23 Feb 2001 10:48:39 +0530593_- I got afraid after looking at Dave's mail, it looked one more un-noticed thing. But now relaxed after mail from Mike again, saying that it was a table name.
Finally, Still no locks on Type 2 Indexes. It could have led to a big thread again but saved now.
Regards, Sanjeev
> -----Original Message----- > From: Polley, Mike (M.) [SMTP:mpolley@FORD.COM] > Sent: Friday, February 23, 2001 2:03 AM > To: DB2-L@RYCI.COM > Subject: Re: DSNILKES & type 2 Index locking???? > > Dave, thanks for the V6 manuals, I was looking for the message code: > DSNI031I > Couldn't find [...]
3468 20 22_Immedwrite bind option15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Fri, 23 Feb 2001 16:38:54 +1100531_- A quick question, and not urgent. Can someone please tell me where the value of the immedwrite bind option is stored. I'm guessing Sysibm.Syspackage but I can't see it anywhere. Probably going blind. Old age will do that to you, eh Terry?
Mustn't grumble...
Raymond
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
3489 39 46_Any tool/SQL to generate DDLs from DB2 Catalog11_Jerry Doong16_jdoong@DB2I2.COM31_Thu, 22 Feb 2001 22:14:58 -0800641_iso-8859-1 Try DB2I2 for DB2/OS390 from JRH Golden State Software Inc.
It provides the following functions Application tuning DASD management Migration Management Dynamic SQL interface Package/Plan Management Security Management Data Move/Replication Catalog Management Backup Management Recover Management Reorg Management
and many many more.....
with a very affordable price tag.
If you would like to try it, please visit www.db2i2.com for detail Jerry Doong JRH GoldenState Software Inc. 29011 Golden Meadow Drive Rancho Palos Verdes, CA 90275 (310) 544-1497 (310) 544-1497 (Fax) e-mail: jdoong@db2i2.com [...]
3529 104 46_Re: Loading with RESUME YES and recoverability16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 23 Feb 2001 11:56:58 +0530522_- Taking the QUIESE point before LOAD will really help if LOAD fails. So another job step in the load jcl to taking the quiese point. If only quiese is successful, LOAD step should be performed(Ofcourse the tablespace should be in the UT mode when QUIESE is taken). But, Do we really need to take full image copy after LOAD RESUME WITH LOG YES ? Is not it still recoverable without this ? I think it is. The image copies will be taken on the regular basis as it is now and the QUIESE will be just before LOAD. If the [...]
3634 209 14_Re: Query Help16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 23 Feb 2001 12:37:43 +0530591_iso-8859-1 Hi Terry,
Thanks for the clarification. The examples were simple and could be tested in the SAMPLE database. Things are crystal clear now. So, one more question : Which performs better ? First one or second one(modified) in the non-OS/390 platform. Again i think, if the DEPTNO is duplicate in the first table (i.e PROJECT) then 2nd one will perform better otherwise first one is the best with performance. With the amount of data and load in the SAMPLE database it can't be judge now but what is your experience with both the queries ? Is the correlation still works [...]
3844 42 36_Migration from CA-IDMS to DB2 OS/39019_Jean-Claude MOREROD19_jmorerod@PICTET.COM31_Fri, 23 Feb 2001 08:47:06 +0100575_us-ascii Hi all,
I'm new on the list and would like to share good or bad experiences concerning a conversion from CA-IDMS to DB2 for OS/390. We are a CICS / ADSO / BATCH (assembler / Cobol) environment using CA-IDMS and would implement DB2 for OS/390 connected through CICS. Did you use products for the conversion ? How is your feedback after the conversion ? Is the maintenance easy to do on converted code ? I would apreciate of any good or bad experiences for such style of conversion, products used for conversion and companies who can offer these services. [...]
3887 96 40_AW: Migration from CA-IDMS to DB2 OS/39012_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 23 Feb 2001 09:34:01 +0100929_iso-8859-1 Jean-Claude,
you are writing that you are new on this very helpful list. Just one recommendation for using the list. There is an archive with all posted questions/answers for various topics. You can search this archive under http://jupiter.ryci.com/archives/db2-l.html. May be your migration question is discussed in the past....
HTH.
With kind regards - mit freundlichen Grüssen, Georg H. Peter DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- Disclaimer: All thoughts are mine and not [...]
3984 71 48_Re: questions for update / insert into db2 table9_Long Qian21_qianl@IHPC.NUS.EDU.SG31_Fri, 23 Feb 2001 16:50:36 +0800310_us-ascii Thanks for all your help I think I can make it now.
But from all your response I feel db2 is quiet cautious in making update / insert operation and I should avoid such operation in the future right? May I have your opinion what is the upper limit for the records I can update in one shot? [...]
4056 58 19_Re: DECIMAL and SUM14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 23 Feb 2001 11:14:22 -0000327_iso-8859-1 Valerie,
If any of the columns BONUS, SALARY or COMM are Integer, Smallint or Decimals with differing precisions, then the precision of the result may not be what you expect.
For example, in DB2 terms:
2.5 + 2.0 + 2 = 6 (and NOT 6.5)
or
2.11 + 2.22 + 2.3 = 6.6 (and not 6.63) [...]
4115 23 39_Re: DSNILKES & type 2 Index locking????13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 23 Feb 2001 07:27:07 -0500310_iso-8859-1 >I got afraid after looking at Dave's mail
I was afraid too. I feared maybe it was one of these 15/255 tables limits deals.
I was afraid maybe somebody missed index locking so badly that they asked SVL to put it back and, being the nice guys they are, IBM reinstated it via APAR. [...]
4139 82 48_Re: questions for update / insert into db2 table17_Wood, Christopher17_cwood@CAYENTA.COM31_Fri, 23 Feb 2001 05:08:57 -0800398_ISO-8859-1 Qian,
You are welcome, but rest assured that the problem you encountered is not DB2 specific. It is just a characteristic of circular logging, Sybase would have the same issue.
-----Original Message----- From: Long Qian [mailto:qianl@IHPC.NUS.EDU.SG] Sent: Friday, February 23, 2001 3:51 AM To: DB2-L@RYCI.COM Subject: Re: questions for update / insert into db2 table [...]
4222 32 21_SRTPool One More Time13_Lockwood Lyon19_Lockwool@MEIJER.COM31_Fri, 23 Feb 2001 08:25:24 -0500586_US-ASCII List,
Thanks to all who responded to my first note about the SRTPOOL ZParm and its meaning.
Actually, I already mostly understood how the Sort Pool works, what the meaning of the ZParm is (from the Install and Admin Guides), etc. Thanks anyway for the confirmation and clarification!
Still, there's an outstanding issue in my opinion: How do you control the Total Size of the pool system-wide? How do you prevent a gaggle of sort users (SQL with ORDER BY, etc) from completely filling the DBM1 address space? What other limiting parameters are there? [...]
4255 153 26_Re: update, insert process0_26_JCameron@MSI-INSURANCE.COM31_Fri, 23 Feb 2001 07:39:56 -0600384_us-ascii Based on what you are attempting, I'll assume there isn't any RI on this table. Rather than update the key of the first row, I would insert that same row with the new key column. There shouldn't be a duplicate key error on this. Then, you should be able to update the existing row with the non-key data you were trying to insert. That should work within a unit of work. [...]
4409 51 21_schemea db2 version 729_Sherri Sterling DIGEST NOMIME29_Sherri.Sterling@BPD.TREAS.GOV31_Fri, 23 Feb 2001 08:37:31 -0500535_us-ascii Hello;
In the documentation for release 7.1 of DB2/UDB, there is a reference that
a query can return the results in xml format. Does this refer to both static and dynamic SQL calls? Has there a particular XML schema that the data is returned in?
I am currently writing a command level program to return the results in a XML format. I would like to structure the XML returned to what the version 7 will return, so that when version 7 is implemented, the impact on the client programs will be minimal. [...]
4461 17 26_Re: update, insert process15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 23 Feb 2001 07:36:02 -0600397_- Hi Amy
I disagree with Richard's response (sorry), but I did a little test, doing the same thing than you did. Update a column of a unique index and insert a new row with the old value without a commit in between and it works! So I guess that you have another unique index on your table and you are violating the unique constraint of this index. Did you check that? Hope this helps. [...]
4479 17 26_Re: Immedwrite bind option15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 23 Feb 2001 07:52:27 -0600366_- Hi
I have asked the same question some time ago to an IBM'er. That's what he wrote back: This option is not stored in the DB2 catalog nor can you specify this option using DB2I. They will be honored in Version 7.
There is a new ZPARM in Version 6 came in with PQ25337. That ZPARM will be modifiable in the installation panel with version 7 too. [...]
4497 178 26_Re: update, insert process14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 23 Feb 2001 14:12:44 -0000322_iso-8859-1 Also, I suspect that this is time to chip in with a paraphrase of something I read in an IBM document some time ago
"Fetching rows within a cursor and updating those rows outside the same cursor in the same unit of work can lead to unpredictable results"
Which is IBM-speak for "don't do it" [...]
4676 41 26_Re: Immedwrite bind option8_Rob Lake29_Robert.Q.Lake@PAC.ERICSSON.SE31_Fri, 23 Feb 2001 07:49:03 -0600449_- Hi Raymond,
The Immediate Write changes were introduced as a V6 enhancement via APAR PQ25337. This introduced an IMMEDWRITE system parameter bind option in DSNZPARM, in addition to the bind option for plans/packages to which you refer.
The option is not reflected in the installation panels (for ZPARM) or the System Catalog until V7. You'll find this documented somewhere in the DB2 UDB for OS/390 Version 7 "What's New" book. [...]
4718 14 33_Re: Archive and Purge of DB2 data0_26_truman.g.brown@VERIZON.COM31_Fri, 23 Feb 2001 09:26:54 -0500303_us-ascii Use the archive capability of REORG...
George
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4733 83 36_Re: SQL Statement 0 in large program5_Chris17_isatcjk@YAHOO.COM31_Fri, 23 Feb 2001 06:43:59 -0800601_us-ascii Hi Gerald, We're running version 6, don't know what maint level.
The largest statement number is 32735 and there are 697 sql statements in the program.
Also the STMTNOI column is all zeros.
Thanks for the info about the patch. Chris
--- Gerald Hodge wrote: > Chris: > What version of DB2 are you running? There used to be a patch to handle > statement numbers that could not fit in the small init value that held > statement number. The number was reset to zero and all SQL statements that > followed had the same number 0. How [...]
4817 22 55_firstkeycardf version db25 vs firstkeycard version db2615_Neff, Stephen R16_NeffSR@STATE.GOV31_Fri, 23 Feb 2001 10:14:03 -0500353_iso-8859-1 Hello,
I may have misprint in my manual and am looking for confirmation. The version 5 admin manual shows in the Statistics Used for Access Path Selection - SYSIBM.SYSINDEXES the column named FIRSTKEYCARDF. The version 6 udb manual show FIRSTKEYCARD no F. Does anyone know if this was a change or is this a mistake in the manual. [...]
4840 20 59_Re: firstkeycardf version db25 vs firstkeycard version db2612_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Fri, 23 Feb 2001 10:58:53 -0500463_us-ascii Stephen, I would say you got a misprint, my 6.1 book says firstkeycardf
Stan Goodwin IBM Senior I/T Specialist DECC MBG DB2 Support
Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335
================================================ 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.
4861 47 25_Re: SRTPool One More Time14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Fri, 23 Feb 2001 11:14:38 -0500449_ISO-8859-1 Lockwood, The simple answer to your question is - you can't control the max memory potential. So don't make the srtpool too large..... guesstimate the max concurrent users you expect, maybe double this for safety, then evaluate that number times the srtpool size.
Regards, Joel
Message text written by DB2 Data Base Discussion List >Thanks to all who responded to my first note about the SRTPOOL ZParm and its meaning. [...]
4909 45 59_Re: firstkeycardf version db25 vs firstkeycard version db260_22_Rohn.Solecki@MTS.MB.CA31_Fri, 23 Feb 2001 10:18:46 -0600560_us-ascii My online version, "EDITION Edition Notice, First Edition (June 1999)" is the same as Stephen's.
Stan Goodwin @RYCI.COM> on 2001/02/23 09:58:53 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Re: firstkeycardf version db25 vs firstkeycard version db26
Stephen, I would say you got a misprint, my 6.1 book says firstkeycardf [...]
4955 151 14_Re: Query Help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Fri, 23 Feb 2001 10:20:26 -0600547_iso-8859-1 Sanjeev,
The best I/O is the one you didn't do, and even if buffered, the best Getpage is the one you didn't do.....
So to compare the two queries below, the correlated subquery is additional getpages (for no additional benefit); and therefore it should perform worse than the COUNT(DISTINCT EMPNO) in the select list. Non-OS390 Visual Explain shows the number of instructions, timerons etc. which can help to evaluate similar statements. This case is quite unique though since all else in the queries is equivalent. [...]
5107 74 57_RC00E40085 DSNU099I Utility Lock Synchronisation Problem.9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Fri, 23 Feb 2001 17:15:10 +0000514_us-ascii Hi, At DB2 V5.1. Looking at Listserv archives it looks like other sites have hit this problem (but no APARs posted). Symptoms are...
>>> Job output DSNU474I -DB2D DSNUQUIA - QUIESCE AT RBA 017B0E133F1E AND AT LRSN B56F9 DSNU475I DSNUQUIB - QUIESCE UTILITY COMPLETE, ELAPSED TIME= 00:39:15 DSNU099I -DB2D DSNUGSUU - IRLM LOCK REQUEST FAILED, IRLM RETURN CODE = X'00000008' IRLM REASON CODE = X'2000' -DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABEND ED, REASON=X'00E40085' [...]
5182 81 40_DB2 Shop but SQL Server 7 support needed0_29_WilliamsByron@RUSSELLCORP.COM31_Fri, 23 Feb 2001 11:49:41 -0600398_ISO-8859-1 We are a DB2 shop however we have SQL Server and Oracle, and the DBA(s) must support these systems. If you know of a SQL Server Listserv like the DB2 Listserv, please share the site. If someone could help with the Error 4213 it would be greatly appreciated. I have performed the full database backup, as directed, however I am still getting the error. Thank you for any help, Byron [...]
5264 191 14_Re: Query Help10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Fri, 23 Feb 2001 11:48:57 -0600430_us-ascii Terry,
"If it was easy then your wife could do your job!!!" pahleease!
For all the women/wives working DB2 out there, I'd have hoped you'd at least have put a behind that!
Thanks. Missy Case FDR TMDBA 701-275-6358
Terry Purcell cc: Sent by: DB2 Data Subject: Re: Query Help Base Discussion List [...]
5456 84 40_DB2 Shop but SQL Server 7 support needed0_29_WilliamsByron@RUSSELLCORP.COM31_Fri, 23 Feb 2001 11:49:41 -0600398_ISO-8859-1 We are a DB2 shop however we have SQL Server and Oracle, and the DBA(s) must support these systems. If you know of a SQL Server Listserv like the DB2 Listserv, please share the site. If someone could help with the Error 4213 it would be greatly appreciated. I have performed the full database backup, as directed, however I am still getting the error. Thank you for any help, Byron [...]
5541 221 14_Re: Query Help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Fri, 23 Feb 2001 12:03:42 -0600535_us-ascii Missy,
I keep forgetting I'm in the US where I can easily offend a few million people....
My wife is very intelligent, just not a computer person.....Maybe I should have said:
"If it was easy then my grandfather could do my job!!!"
Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Missy Case Sent: Friday, February 23, 2001 11:49 AM To: DB2-L@RYCI.COM Subject: Re: Query Help [...]
5763 100 30_Re: NT/ UDB 7.1 - Backup times0_22_rmadan@CYVEILLANCE.COM31_Fri, 23 Feb 2001 13:12:31 -0500576_iso-8859-1 Dave,
We are currently on 5.2 on NT backing up 350 + gig to disk in about 6 hours.
-----Original Message----- From: David Bargeron [mailto:David.Bargeron@BTINTERNET.COM] Sent: Sunday, February 18, 2001 4:25 PM To: DB2-L@RYCI.COM Subject: NT/ UDB 7.1 - Backup times
Hi Listers,
We will be running UDB v7.1 on NT with TSM as the backup manager to magstar x 2 tape drives (fibre connected), database of around 300 Gb on SSA with LOBs. Our site is new to UDB on NT and are about to run some benchmarks for database backups etc. [...]
5864 27 23_More trigger questions.12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Fri, 23 Feb 2001 13:20:33 -0500337_us-ascii Hi all. It seems like trigger questions are the subject of the week so, I hope someone can answer my questions.
The first is about who creates triggers in test environments. Do you let the application people create triggers in test? If so, how is it working out? Are there problems with not creating them centrally? [...]
5892 34 14_Re: Query Help10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM31_Fri, 23 Feb 2001 13:27:29 -0500186_us-ascii Missy, The Curiosity is killing me. What does mean?
"For all the women/wives working DB2 out there, I'd have hoped you'd at least have put a behind that!"
5927 26 14_Re: Query Help10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM31_Fri, 23 Feb 2001 13:29:00 -050051_us-ascii Hey wait a minute ...... I'm a Grandfather
5954 56 44_Re: DB2 Shop but SQL Server 7 support needed12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Fri, 23 Feb 2001 12:38:19 -0600298_iso-8859-1 I thought we were the ONLY shop in the world that expected the DBAs to support DB2, Oracle and Sql Server!
Things I would check - as you can probably tell - I'm not a SQL Server wizard - but ...... do you have truncate log on checkpoint on or do you have the log backing up. [...]
6011 88 44_Re: DB2 Shop but SQL Server 7 support needed0_26_JCameron@MSI-INSURANCE.COM31_Fri, 23 Feb 2001 12:54:01 -0600766_iso-8859-1 You may have to truncate the transaction log first, then do a full database backup.
John Cameron JCameron@msi-insurance.com
WilliamsByron@RUSSE LLCORP.COM To: DB2-L@RYCI.COM Sent by: DB2 Data cc: Base Discussion Subject: DB2 Shop but SQL Server 7 support needed List
02/23/01 11:49 AM Please respond to DB2 Data Base Discussion List
We are a DB2 shop however we have SQL Server and Oracle, and the DBA(s) must support these systems. If you know of a SQL Server Listserv like the DB2 Listserv, please share the site. If someone could help with the Error 4213 it would be greatly appreciated. I [...]
6100 32 19_SQL Server ListServ10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM31_Fri, 23 Feb 2001 14:04:22 -0500158_us-ascii There are 2 SQL Server discussion forums I know of, the first one is the best:
www.Win2000mag.net/channels/sqlserver www.swynk.com/discuss_sql
6133 27 51_Dataspace manager - poor index performance - help!!15_Amy C Whitehead14_B06ACW@FDS.COM31_Fri, 23 Feb 2001 13:50:48 -0500393_us-ascii All, In the TMON we see a portion of the definition of service wait as data space manager services. Does anyone know where the dataspace manager is and what it does?
We have a consistent in-DB2 time of 3 seconds and a service wait time of 3 seconds per insert with partitioned tablespace. We are datasharing. We have looked at the service wait causes and eliminated most. [...]
6161 35 42_Loading with RESUME YES and recoverability13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Fri, 23 Feb 2001 14:31:57 -0500267_us-ascii Our datawarehouse load jobs are very similar to what Sanjeev has mentioned . We do the following in sequence : 1. Start the ts in UT mode . 2. Quiesce 3. Load ( with resume yes ) 4. Start the ts in RW . 5. A copy job takes a full image copy of the ts . [...]
6197 45 44_Re: DB2 Shop but SQL Server 7 support needed12_Jim Harrison12_jimh@QIS.NET31_Fri, 23 Feb 2001 14:49:49 -0500507_us-ascii Try the newsgroup comp.databases.ms-sqlserver or one of the Microsoft groups under microsoft.public.sqlserver.* - but I'd try searching http://groups.google.com/ since that archives all of them.
As for your specific problem, sounds like you may have select into/bulk copy turned on. However, I just tried a backup, inserts & restore on a on 7.0 personal edition database with that option turned on and it worked just fine - except for the fact that it didn't tell me I lost my inserts. [...]
6243 20 44_Re: DB2 Shop but SQL Server 7 support needed12_Jim Harrison12_jimh@QIS.NET31_Fri, 23 Feb 2001 14:57:05 -0500291_us-ascii Now that you mention it, I'm curious how many DBAs support multiple databases. We have all three in our shop as well, and I support DB2 & SQL Server. I just haven't had time to learn Oracle, but I'm going to have to start since that is our strategic direction on the mid-tier. [...]
6264 56 44_Re: DB2 Shop but SQL Server 7 support needed9_Cam White20_cwhite@REVEALNET.COM31_Fri, 23 Feb 2001 15:35:10 -0500692_iso-8859-1 RevealNet has excellent cross-database Knowledge Bases for:
* DB2 (OS/390) * Oracle Database Administration * Oracle PL/SQL Development
Coming Soon: * SQL Server * DB2 UDB (NT, Unix)
30-day free trial available at http://www.revealnet.com
Best wishes,
Cam White RevealNet, Inc.
...do IT smarter (tm)
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Jim Harrison > Sent: Friday, February 23, 2001 2:57 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Shop but SQL Server 7 support needed > > > Now that you mention it, I'm curious how many DBAs support multiple > databases. We [...]
6321 59 50_Re: Is my Batch Processing really OLTP in disguise15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 23 Feb 2001 14:32:39 -0600401_iso-8859-1 No one has taken a stab at this one so here goes. I would say yes. I have seen similar situations where really ugly SQL gets generated by these packages. Often no one can modify the SQL to make it more efficient so the DBA and systems people are stuck with making the bufferpools as large as possible and praying to your diety of choice that it will reuse the pages in the bufferpool. [...]
6381 85 44_Re: DB2 Shop but SQL Server 7 support needed7_Mark S.23_Mark_Sopczak@WENDYS.COM31_Fri, 23 Feb 2001 15:25:32 -0500362_us-ascii We have 7 DB2 subsystems, and 9 SQL Slower installations with 2 new ones one the way... seems someone thinks of a new SQL Server application every 3 months or so.....
Jim Harrison Sent by: DB2 Data Base Discussion List 02/23/01 02:57 PM Please respond to DB2 Data Base Discussion List [...]
6467 74 27_Re: More trigger questions.15_Jackson Reavill18_damcon2@US.IBM.COM31_Fri, 23 Feb 2001 15:37:02 -0500597_us-ascii Hi Martin,
I can only speak to your first question... In our shop the DBA's create the triggers for the following reasons:
- They are a DB2 object. - Gives us control over what's out there. - Performance tuning/impacts of the triggers.
Cheers, Jay
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. - Bavarian Motor Works ----------------------------------------------------- [...]
6542 81 46_Re: Loading with RESUME YES and recoverability15_Jackson Reavill18_damcon2@US.IBM.COM31_Fri, 23 Feb 2001 15:41:49 -0500587_us-ascii Hi all,
Is the forcing of a full image copy due to not being able to recover thru the load (even with log yes) or is it because the load does not update the changed page bit so the incremental copy doesn't know what all has changed?
Thanks, Jay
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. - Bavarian Motor Works ----------------------------------------------------- [...]
6624 154 44_Re: DB2 Shop but SQL Server 7 support needed13_Walter Davies26_wdavies@CO.EL-DORADO.CA.US31_Fri, 23 Feb 2001 12:58:42 -0800384_iso-8859-1 Besides DB2 on mainframe and server, Oracle and Sql server. I also get to support M204 as a database. And I am the only DBA.
Walter -----Original Message----- From: Mark S. Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Friday, February 23, 2001 11:32 AM Subject: Re: DB2 Shop but SQL Server 7 support needed [...]
6779 60 14_Re: Query Help15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Fri, 23 Feb 2001 16:01:31 -0500350_iso-8859-1 And I'm a grandmother working DB2 -- 5 times over and mighty proud I might add!
-----Original Message----- From: Keith Kuhn [mailto:Keith_Kuhn@WENDYS.COM] Sent: Friday, February 23, 2001 1:29 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Query Help
Hey wait a minute ...... I'm a Grandfather working DB2.
6840 60 20_Re: DB2 / SQL Server7_Mark S.23_Mark_Sopczak@WENDYS.COM31_Fri, 23 Feb 2001 16:04:12 -0500362_us-ascii We have 7 DB2 subsystems and 9 SQL Slower installations with 2 new ones one the way... seems that someone thinks of a new SQL Server application around here every 3 months or so.....
Jim Harrison Sent by: DB2 Data Base Discussion List 02/23/01 02:57 PM Please respond to DB2 Data Base Discussion List [...]
6901 157 44_Re: DB2 Shop but SQL Server 7 support needed13_Walter Davies26_wdavies@CO.EL-DORADO.CA.US31_Fri, 23 Feb 2001 12:58:42 -0800384_iso-8859-1 Besides DB2 on mainframe and server, Oracle and Sql server. I also get to support M204 as a database. And I am the only DBA.
Walter -----Original Message----- From: Mark S. Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Friday, February 23, 2001 11:32 AM Subject: Re: DB2 Shop but SQL Server 7 support needed [...]
7059 126 44_Re: DB2 Shop but SQL Server 7 support needed15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Fri, 23 Feb 2001 16:51:32 -0500517_- We have 2 DB2 subsystem and 35 SQLserver and one or two Oracle server. I support both DB2 and SQLserver now.
-----Original Message----- From: Mark S. [mailto:Mark_Sopczak@WENDYS.COM] Sent: Friday, February 23, 2001 02:26 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Shop but SQL Server 7 support needed
We have 7 DB2 subsystems, and 9 SQL Slower installations with 2 new ones one the way... seems someone thinks of a new SQL Server application every 3 months or so..... [...]
7186 126 39_Verify (OS390) DDF IP Port is listening10_Park, Stan17_SPark@STATE.NM.US31_Fri, 23 Feb 2001 15:08:16 -0700442_iso-8859-1 Hello List,
Am attempting to create an automated process on my Win NT box that will notify me if any of our DB2 V5.1 OS390 DDF IP ports are NOT listening. This must be a *totally* automated process.
Am using the NT AT command to run the IBM Protocol Communications Tester (Protocol Tester) PCTT.exe in the SQLLIB\BIN directory of DB2 UDB V7 PE. So far so good except I can't get the retcode variable to test it. [...]
7313 43 38_Re: UDB v7.1 EEE on AIX SQL Procedures11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Fri, 23 Feb 2001 17:42:26 -0500722_us-ascii Todd,
Are you seeing any diagnostics, SQL codes, error messages, or errors in $HOME/sqllib/db2dump/db2diag.log ?
Regards, Scott
Do you know who is using your data warehouse? How often? Chargebacks? Are your EEE nodes equally sharing the load? See http://www.database-guys.com/cmgui.shtml You can't control what you can't measure. Get Answers. Get Results. Get Database-GUYS(TM).
Todd Grinaway wrote in message news: <01C09D1D.673F7BC0.tgrinaway@riteaid.com>... > Hello everyone, > We are new to UDB EEE, and are running into an issue with compiling SQL > Procedures. We are able to compile them, but only on the catalog owning > node. We also only seem to [...]
7357 28 14_Re: Query Help14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 24 Feb 2001 10:03:14 +1100483_iso-8859-1 Grin. As in "I'm grinning to show that I'm saying something that is deliberately provocative".
-----Original Message----- From: Keith Kuhn [mailto:Keith_Kuhn@WENDYS.COM] Sent: Saturday, 24 February 2001 5:27 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Query Help
Missy, The Curiosity is killing me. What does mean?
"For all the women/wives working DB2 out there, I'd have hoped you'd at least have put a behind that!" [...]
7386 21 24_REORG UNLOAD/LOAD FORMAT14_Toppins, Smike21_smike.toppins@GWL.COM31_Fri, 23 Feb 2001 14:17:12 -0700564_- Does anyone have some samples of using a REORG UNLOAD ONLY of a multi-table tablespace and the corresponding LOAD FORMAT UNLOAD INTO the multiple tables. The Utility manual implies that this can be done but doesn't give any examples. TIA.
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
================================================ 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.
7408 66 36_service wait time/data space manager15_Amy C Whitehead14_B06ACW@FDS.COM31_Fri, 23 Feb 2001 19:09:29 -0500575_us-ascii All, Question 1: In the TMON we see a portion of the definition of service wait as data space manager services. Does anyone know where the dataspace manager is and what it does?
Question 3: In production, we have a consistent in-DB2 time of 3 seconds and a service wait time of 3 seconds per insert with 33 partitioned tablespace. The tablespace is defined with lockpart yes, close no. Data is inserted in a round robin starting in part 1 through part 33 using the MOD algorithm. Each partition can be inserted into from any of the 7 members. Currently, [...]
7475 70 18_performance crisis15_Amy C Whitehead14_B06ACW@FDS.COM31_Fri, 23 Feb 2001 19:45:51 -0500346_us-ascii All, This message was rejected because it was repetitive. However, I have not been able to send it successfully. I apologize if this is repetitive..... Scenario 1:
In the TMON we see a portion of the definition of service wait as data space manager services. Does anyone know where the dataspace manager is and what it does? [...]
7546 40 38_SHARE in Long Beach - Focus on ERP/DB219_Freeling, Marv, ITD25_mfreelin@CO.ALAMEDA.CA.US31_Fri, 23 Feb 2001 18:46:50 -0800380_iso-8859-1 The ERP Focus track at SHARE will provide the edge your company needs to stay ahead of the curve... ERP Focus Sessions at SHARE:
The next SHARE is in Long Beach, California during the week of February 25th - March 2nd, 2001. We will be having an ERP focus day in Long Beach, once again sponsored by the DB2 Project at SHARE, much like we've had previously. [...]
7587 38 38_SHARE in Long Beach - Focus on ERP/DB219_Freeling, Marv, ITD25_mfreelin@CO.ALAMEDA.CA.US31_Fri, 23 Feb 2001 19:28:56 -0800578_iso-8859-1 ERP Focus Sessions at SHARE:
The next SHARE is in Long Beach, California during the week of February 25th - March 2nd, 2001. We will be having an ERP focus day in Long Beach, once again sponsored by the DB2 Project at SHARE, much like we've had previously.
We are planning to have ERP/DB2 sessions at the SHARE in Long Beach that focus on PeopleSoft and SAP solutions running on a DB2 for OS390 platform, and how to get started. We will have speakers from the ERP Competency Center and elsewhere too. Once again, we plan to focus on topics [...]
7626 32 40_Re: Migration from CA-IDMS to DB2 OS/39013_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Fri, 23 Feb 2001 21:24:17 -0600540_- Hi Jean-Claude I don't have any experience of IDMS to DB2 conversion but I've worked on both ( though IDMS is more of an old memory ), so here are my 2 cents. * Whatever you do, DO NOT implement the IDMS design on DB2. I mean do not go for table for table and OBTAIN -> SELECT conversion. Consider your existing system to be your "specifications" and design the new system with DB2 in mind. The world of set processing is very different from record by record processing under program control. You'll get the worst of both the worlds [...]
7659 32 40_Re: Migration from CA-IDMS to DB2 OS/39013_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Fri, 23 Feb 2001 21:24:17 -0600540_- Hi Jean-Claude I don't have any experience of IDMS to DB2 conversion but I've worked on both ( though IDMS is more of an old memory ), so here are my 2 cents. * Whatever you do, DO NOT implement the IDMS design on DB2. I mean do not go for table for table and OBTAIN -> SELECT conversion. Consider your existing system to be your "specifications" and design the new system with DB2 in mind. The world of set processing is very different from record by record processing under program control. You'll get the worst of both the worlds [...]
7692 25 5_LOCKS18_Subramanyam, Vijay35_vijay.subramanyam@BLR.HPSGLOBAL.COM31_Sat, 24 Feb 2001 09:41:25 +0500318_- > Hello List, > > This a CICS application & some times while running a transaction I hit > SQLCODE -904. > I have done the -DISPLAY DATABASE & the following is the output of that: > XXXXS003 TS RW CICS5 CT00XXXX H-IS,S,C
> What should be done??? > How can this lock be released??? > > Regards, > VIJAY > [...]
7718 57 16_Re: Data masking9_Rob Crane22_racrane@CONCENTRIC.NET31_Sat, 24 Feb 2001 00:02:21 -0700672_us-ascii Data Navigator (platinum/ca) provides the ability to do most of what you want. Give it a try. It can do encryption as well as test data generation taking into account system or user RI, etc.
"Tennant, Steve" wrote: > > **************************************************************** > IMPORTANT > > The information transmitted is for the use of the intended > recipient only and may contain confidential and/or legally > privileged material. Any review, re-transmission, disclosure, > dissemination or other use of, or taking of any action in > reliance upon, this information by persons or entities other > than the intended recipient is prohibited [...]
7776 113 28_Re: REORG UNLOAD/LOAD FORMAT12_Asamoto, Roy22_Roy.Asamoto@STAUTO.COM31_Sat, 24 Feb 2001 13:49:04 -0500386_iso-8859-1 Smike,
The Reorg utility with UNLOAD EXTERNAL will create the LOAD statements for you as long as you have the SYSPCHxx defined for each REORG UNLOAD statement. You can modify the statements to REPLACE or point to use a different identifier for the tables or run a dummy reorg unload on the target tablespace. The following JCL will create 2 unloaded tablespaces: [...]
7890 21 27_FYI - IDUG One Day Seminars14_Philip Gunning26_philip_gunning@HOTMAIL.COM31_Sat, 24 Feb 2001 14:14:13 -0500
7912 13 20_UDB EE and Nodegroup14_Philip Gunning26_philip_gunning@HOTMAIL.COM31_Sat, 24 Feb 2001 14:16:18 -0500
7926 14 21_Re: IP Address Change14_Philip Gunning26_philip_gunning@HOTMAIL.COM31_Sat, 24 Feb 2001 14:17:36 -0500
7941 64 38_Re: Plan DISTSERV Locks whole Database9_Eric Kwai18_Eric_Kwai@DTCC.COM31_Sat, 24 Feb 2001 19:46:45 -0600590_- Popy:
Verify if you have DB2 Connect V6 FP4 or later installed, fixpack 6 is better (It solves a lot of Java issues). Make sure your Java application/servlets are closing each open cursor in the Java program. Verify that they are releasing the connection resouce by issuing con.close in the program. Use JDBC Connection pooling in WAS, (if you are using WebSphere), use Stored Procedure. These are some major items I'll recommended. We are planning to use SQLJ in our shop as well, need to plan out the sqlj, db2profc, and change management issue. The DBA job is getting more [...]
8006 95 27_Re: More trigger questions.14_Grainger, Phil20_Phil.Grainger@CA.COM31_Sun, 25 Feb 2001 20:24:43 -0000394_iso-8859-1 I'm also interested to know how many people rebind trigger packages AFTER creating them (usually on empty tables), populating the table(s) and running RUNSTATS and has anyone ever hit problems by NOT rebinding them??
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
8102 46 26_Re: Immedwrite bind option15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Mon, 26 Feb 2001 09:37:57 +1100428_- Hi Rob,
Guess you're in Sweden now. Man, you get around even more than I do!
Thanks for the background info on IMMEDWRITE, but it doesn't quite answer my question. If the bind option is valid and remembered it must be held somewhere for each package. The question is: where? It's not in something like those old 'reserved for future use' columns, is it? Can't see any of those in Sysibm.Syspackage anymore. [...]
8149 45 44_Re: DB2 Shop but SQL Server 7 support needed14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Sun, 25 Feb 2001 18:58:02 -0600358_iso-8859-1 Well, we have DB2 5.1, DB2 UDB 5.2 on NT, SQL Server 6.5 and 7.0, Oracle 8i on NT and Oracle 8i on Unix to support.
The oracle support is a recent additon. We are lucky to have at least been on the Oracle DBA course. Unfortunately, we don't know unix....so of course we are PROD support.......did I mention Oracle is a pig to support? [...]
8195 27 22_Concurrent copy option15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Mon, 26 Feb 2001 12:05:46 +1100605_- Colleagues, DB2 for OS/390 V6. Just a quickie (no comments, Terry; you're in enough trouble already...). Can someone confirm or shoot down the assertion that an image copy taken using the Concurrent option (i.e. to invoke DF/DSS to take the copy 'instantly') generates an image copy dataset that is then used in the normal recovery process by the Recover utility. Alternatively, as I'm assuming SMS is better at moving large quantities of data than DB2, is it possible to get SMS to somehow restore the tablespace using this copy and then complete the recovery using the Logonly option of Recover? [...]
8223 56 26_Re: Concurrent copy option12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Mon, 26 Feb 2001 13:11:15 +1100331_- Raymond,
off the top of my head, so feel free to shoot me down here list, the Concurrent Copy as you've eluded to uses DFSMS/dss services to dump the data. The Recovery utility sees that the image copy is marked as concurrent and uses the same set of services to "restore" the dataset before applying logs ... et al. [...]
8280 81 46_Re: Loading with RESUME YES and recoverability16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 26 Feb 2001 10:07:40 +0530567_- I understand the incremental image copy is not allowed and not required as well. But my question was mainly do we require any sort of image copy if LOAD WITH RESUME YES is run. We do have logs after any previous image copy(full).
Suppose the utility procedure in a particular installation is something like this. In the past : Daily Full Image copy. Now if the LOAD with RESUME YES is scheduled after this FULL image copy(can't be put before FULL Image copy because rescheduling of Full image copy is not possible due to certain reason) then do we need [...]
8362 57 9_Re: LOCKS16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 26 Feb 2001 10:20:09 +0530293_- It looks the same old thing if i am not wrong. Your total number of locks acquired exceeds your NUMLKUS in the Zparm. Please ensure the you are commiting frequently(tough to believe if it is a CICS online application) or do not have row locks for the objects accessed, if not feasible. [...]
8420 53 46_Re: Loading with RESUME YES and recoverability16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 26 Feb 2001 10:33:53 +0530559_- In my reply below all LOAD RESUME YES is with LOG YES.
Regards Sanjeev
> -----Original Message----- > From: S, Sanjeev (CTS) > Sent: Monday, February 26, 2001 10:05 AM > To: 'DB2 Data Base Discussion List' > Subject: RE: Loading with RESUME YES and recoverability > > I understand the incremental image copy is not allowed and not required as > well. But my question was mainly do we require any sort of image copy if > LOAD WITH RESUME YES is run. We do have logs after any previous image > copy(full). > > Suppose the utility procedure [...]
8474 133 46_Re: Loading with RESUME YES and recoverability0_25_john.halloran@SGIO.COM.AU31_Mon, 26 Feb 2001 16:13:20 +0930515_us-ascii As I understand it you do not require a full image copy after a load to ensure recovability if you use the load option LOG YES. (resume yes says to load the data and keep all existing data ) A load resume yes doesn't even require a quiesce to be taken as the load writes a record to SYSCOPY before the load commences. On the other hand a load with replace yes will write a record to SYSCOPY after the load has completed. As long as you have a full image copy and changes have been logged by using LOG [...]
8608 55 25_Migration from 6.1 to 7.113_Arora, Ashish26_ashish.arora@HPSGLOBAL.COM31_Mon, 26 Feb 2001 12:18:32 +0530212_- Hi, I want to migrate my DB2 from 6.1 to 7.1. The database is in running & working condition, so I want to do it as soon as possible. Pls anybody tell me how shall I proceed for this ???
Regards, Ashish.
8664 14 51_Daniel Sullivan/ZI/USA/Zurich is out of the office.15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM31_Mon, 26 Feb 2001 00:51:56 -0600365_us-ascii I will be out of the office from 02/26/2001 until 02/27/2001.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
8679 175 46_Re: Loading with RESUME YES and recoverability16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 26 Feb 2001 12:53:40 +0530614_iso-8859-1 You are absolutely correct John. Thanks for reminding. This was discussed sometimes in June last year. No need of QUIESE as well as long as LOG YES is specified.
Regards, Sanjeev
> -----Original Message----- > From: john.halloran@SGIO.COM.AU [SMTP:john.halloran@SGIO.COM.AU] > Sent: Monday, February 26, 2001 12:13 PM > To: DB2-L@RYCI.COM > Subject: Re: Loading with RESUME YES and recoverability > > As I understand it you do not require a full image copy after a load to > ensure > recovability if you use the load option LOG YES. (resume yes says to load > the > data and keep all [...]
8855 37 29_Re: Migration from 6.1 to 7.111_Endy Lambey27_endyl@MITRAINFOSARANA.CO.ID31_Mon, 26 Feb 2001 10:34:10 +0100585_ISO-8859-1 Ashish,
I don't know on what platform your DB2 is. I only answer from my experience with NT. First you backup the database, just to keep sure that you have the backup if the installation gone wrong. you don't have to drop the db though. Then uninstall DB2 6.1, restart the Server. Install the DB2 7.1, restart the Server, The execute this command on Command Windows or Command Center: "migrate database " without quotes of course and dbname is the name of the database that you want to migrate. As to other internal function that you've used in DB2 6.1, [...]
8893 45 29_Re: Migration from 6.1 to 7.116_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 26 Feb 2001 15:14:13 +0530298_- Hi Ashish,
I believe this is Non-OS390 DB2. The installation of V7.1 and cataloging the database on its given node should do the work. Not so easy though, If you do have V7.1 CD, you can look at the migrating from V6.1 over there. You can perform the step by step points given there. [...]
8939 29 40_Re: service wait time/data space manager10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 26 Feb 2001 11:12:16 +0100381_us-ascii Hi Amy, in redbook
ABCs of OS/390 System Programming Volume 1 SG24-5597-00 and others (from vol 1 to vol 5)
there's a verrrrrrrry brief description of data space.
Are u using a ny 3rd part tools ? Spmetimes they use extensively Data Spaces.
Regards
Max Scarpa ('I'm not a real DB2 Sysprog, I'm just drawn that way') [...]
8969 38 18_extra partitionins7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Mon, 26 Feb 2001 04:10:39 -0600361_- Dear List,
We have a table with 32 million rows in production. It has only 10 partitions.
Partitioning key is :
col 1 -> 8 character --- group id. --- which is check digit + available number col 2 -> integer --- group act seq no.
Now the partitioning keys for 1 partition 09999999, 2147483647 2 partition 19999999, 2147483647 [...]
9008 82 26_Re: Immedwrite bind option8_Rob Lake29_robert.q.lake@PAC.ERICSSON.SE31_Mon, 26 Feb 2001 04:51:14 -0600590_- Hi Raymond,
It's been cold here in Stockholm the last few days (-9C). I guess you're nearing the end of summer there.
As you know, DB2 will use the IMMEDWRITE option used at the last bind of the plan/package during REBIND if it is not overridden on REBIND.
The option is held internally (I believe in the skeleton cursor/package tables in the DB2 directory) and is not visible through any catalog column (reserved or otherwise) until Version 7. Thus DB2 knows what the value is, but you don't unless you keep your own record. (Technically of course, if you know [...]
9091 63 33_Re: Archive and Purge of DB2 data10_Alan Johns26_AlanJ@PRINCETONSOFTECH.COM31_Mon, 26 Feb 2001 06:26:14 -0500420_ISO-8859-1 Hi Cathy. First of all - don't worry, I'm not a salesman, I'm a techie. I work for a company called Princeton Softech, who deal with tools for manipulating DB2 relational data, including the ability to archive, view and restore relationaly intact sets of DB2 data.
There are no limits to the number of tables we can handle, and a number of our clients talk about archiving millions of rows a day. [...]
9155 76 16_Re: Data masking10_Alan Johns26_AlanJ@PRINCETONSOFTECH.COM31_Mon, 26 Feb 2001 06:37:51 -0500586_ISO-8859-1 Hi Steve. I'm a product specialist for Princeton Softech. This is just a quick reminder about the Move for DB2 tool, that is part of the Relational Tools for DB2 you already have installed - as you currently use Access for DB2. Move, as you probably already know, can identify and move complex sets of relationaly intact DB2 data. It however, also has the ability to change and manip[ulate the data when inserting it to the target database. The functions are called tables mapping and column mapping. It also has a PROPagate command that allways the tool to cascade key [...]
9232 63 59_Moving from DB2/Unix to DB2/OS390 - security considerations13_Tzachi Nissim21_tzachi@ATTUNITY.CO.IL31_Mon, 26 Feb 2001 14:18:36 +0200482_iso-8859-1 We have a software product that is written is C and is running on Unix. It is accessing DB2 via dynamic SQL. We have ported this product to OS390 and are now finding out that we do not know enough about the differences between db2 security on Unix vs. OS390. Basically we would like to be able to prompt our users for a username and password and have this username be the username used by db2. Any pointers as to how to accomplish this would be greatly appreciated. [...]
9296 28 24_Buffer Pool Tool for IMS14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Mon, 26 Feb 2001 09:16:36 -0500391_ISO-8859-1 Today, at Share in Long beach, CA, Responsive Systems announces the Buffer Pool for IMS. This builds upon the existing industry standard software, Buffer Pool Tool for DB2, and provides the ability to Predict the effect of tuning changes to the I/O buffers for IMS.
More information is available on the web site on the Announcements page, at www.responsivesystems.com [...]
9325 77 22_Re: performance crisis14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Mon, 26 Feb 2001 08:24:15 -0600590_iso-8859-1 I can give a response to part of your problem.
The short answer is that increasing PCLOSET to about 40 minutes and PCLOSEN to a high number so that it is ignored, may help you. Other sites have reported this has helped them.
The long answer is...
DB2 keeps track of which objects are open for update, and which are only used for read-only processing. If DB2 is re-started after a failure, DB2 can check this information and ensure recovery action is triggered for objects known to be in update mode. Objects that are read-only by definition do not need [...]
9403 21 29_Re: Migration from 6.1 to 7.111_Paul Murphy22_Paul_Murphy@MAY-CO.COM31_Mon, 26 Feb 2001 08:48:47 -0600425_us-ascii If you're on a Windows platform and converting from UDB 6.1 to 7.1, no conversion or uninstall necessary. All you have to do is install the UDB 7.1 code. It will automatically detect the v6.1 code, all cataloged databases, etc and install. You will have to reboot to get the new DLL's and services loaded. A migration of the database is only necessary if you are going from UDB v5.2 to 6.1 or from v5.2 to 7.1. [...]
9425 28 19_dsn1copy & dsn1chkr32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Mon, 26 Feb 2001 17:15:37 +0200354_- Hello List,
This is about DSN1CHKR & DSN1COPY.
I applied DSN1CHKR Utility To DBD01 and it processed 1093 Pages. Then, applied DSN1COPY with CHECK to the same TS and it processed 1440 pages.
The Messages & Codes says the page number in DSN1CHKR output represents the number of pages read from ts not the number of pages in ts. [...]
9454 31 22_Re: performance crisis10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 26 Feb 2001 16:12:10 +0100363_us-ascii Hi Amy, probably this is an action you've done via a search in APAR database, but I remember there are some APARS
to alleviate spikes during Logical OPEN/CLOSE in a DS environment, I read something in a John Campbell's
presentation, as new improvements for DB2 V5 Datasharing. In my note I find some references, but I've not the APAR. [...]
9486 58 26_Performance on DB2 7 on NT11_Asif Rashid23_arashid@ALPHA-GAMMA.COM31_Mon, 26 Feb 2001 10:22:38 -0500361_iso-8859-1 Hi All,
This is my first posting to list and also I have just started DB2 development. I have developed web based solution for our client in which I am using Cold Fusion and DB2. In my application I am running only Select statements to display different set of data on web. I am facing lot of performance related problems with DB2 on NT, [...]
9545 30 22_Immedwrite bind option12_Chris Munson18_cmunson@US.IBM.COM31_Mon, 26 Feb 2001 09:24:13 -0800395_us-ascii Because the immediate write code was added via APAR a catalog change was not an option. The value is therefore not externalized until V7. REBIND honors the previously set value if not specified so no worries there.
Chris Munson DB2 for OS/390, IBM Silicon Valley Laboratory
On Fri, 23 Feb 2001 16:38:54 +1100, Bell, Raymond W wrote: [...]
9576 69 26_Re: Concurrent copy option0_26_mark.walker@CUNAMUTUAL.COM31_Mon, 26 Feb 2001 13:02:49 -0600408_us-ascii Raymond,
We use concurrent copy as well. Using concurrent copy allows us to get a jump on our recoveries in our disaster recovery tests. While our sysprogs are recovering our DB2 subsystem, we are restoring our business data using DF/DSS. This works great and gives us a couple of hours head start on recovering our data. Once DB2 is up, we do recover log only and then rebuild indexes. [...]
9646 15 33_Re: Archive and Purge of DB2 data7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Mon, 26 Feb 2001 13:09:35 -0600472_- How does Princeton Softech DB2 Archive handle the case when the table structure changes, is it possible to restore the archive to the changed table from the old archive which was made from the earlier table structure.
Sri
================================================ 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.
9662 47 33_Re: Archive and Purge of DB2 data14_Michael Finnis28_MFinnis@PRINCETONSOFTECH.COM31_Mon, 26 Feb 2001 16:43:49 -0500301_ISO-8859-1 Hello Sri,
The short answer is YES. Princeton Softech's Archive for DB2 stores both the data and DDL (meta data) in a proprietary file format. From this we are able to re-create the "old" data model or "map" from the old model to a new model at both the table and column level. [...]
9710 66 26_Re: Immedwrite bind option15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 27 Feb 2001 09:25:39 +1100585_- Hi Rob/Chris M,
Autumn is indeed approaching. Average daytime temps are down around 25C these days. Almost pleasant. Apparently it snows here too in places. Snow. In Australia. Can't seem to get my head around that.
Anyway, gibber gibber. Not sure if the SKPT will be the magic store for this info. I guess all I really need to know, as Chris M alluded, is that DB2 manages it internally somewhere until, like you say, V7 externalises it. Could be, though; there's a few 'columns' described in the CA Reference Guide as 'reserved'. Could be one of those, I guess. [...]
9777 35 64_Re: Moving from DB2/Unix to DB2/OS390 - security consider ations14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 27 Feb 2001 09:30:17 +1100420_iso-8859-1 Check the archives from two weeks ago for a thread titled 'One Process - Many Users' in which I discussed an approach.
/* standard disclaimer */ James Campbell Hansen Corporation
-----Original Message----- From: Tzachi Nissim [mailto:tzachi@ATTUNITY.CO.IL] Sent: Monday, 26 February 2001 23:19 To: DB2-L@RYCI.COM Subject: [DB2-L] Moving from DB2/Unix to DB2/OS390 - security considerations [...]
9813 39 8_SQL Help13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Mon, 26 Feb 2001 16:25:52 -0600367_- I have a SQL statement that is getting sequential prefetch at the table level. There are about 500,000 or so rows in the table. I have tried every index imaginable and outside of rewriting the program or the query, no index will work as well as I want it to. I did get it to do a multiple (3) index scan, but prefer not to use one due to response time issues. [...]
9853 57 26_Re: Concurrent copy option15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 27 Feb 2001 10:45:15 +1100404_- Mark/Nick/etc.,
Interesting comments all. As usual, I'm a little confused. I'm fairly confident that a concurrent image copy calls up DFDSS to copy 'under the covers' the actual tablespace (and possibly index(es) if requested). I believe this is deadly quick as far as DB2 sees it, with DFDSS backing up the cluster asynchronously. What I'm puzzled with is how this copy is used. Does one: [...]
9911 93 12_Re: SQL Help14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 27 Feb 2001 11:00:32 +1100395_iso-8859-1 Shauna
off the top, try adding a and SrvcDt >= :HV3 to the outermost level of the where clause. You'll note that this does apply a tighter filter (ie it will not disqualify any rows that are not already disqualified), but allows an index matchcols on SrvcDt.
Now try the query with an index on (Indid, SrvcDt, Id, SubId, SeqId). Should get matchcols=2, but a sort. [...]
10005 57 53_BMC Image Copy runtime blowout when altering SHRLEVEL15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM31_Tue, 27 Feb 2001 11:09:29 +1100558_- Hello list,
This may be an oldie but I couldn't find it in the archives. We're on OS/390 DB2 V6.1 and we use BMC Copy Plus for our image copies (where we copy multiple tablespaces on to a stacked tape volume using the wildcard option).
Recently we altered the SHRLEVEL from READ to CHANGE and this seems to have caused a blowout in runtimes from about 15mins to 4hours. The jobs' elapsed times now appear to be accumulating as if the tape is being rewound and then has to be repositioned before the next tablespace is copied, so maybe a [...]
10063 81 12_Re: SQL Help15_Corrigan, David31_David.Corrigan@TEAM.TELSTRA.COM31_Tue, 27 Feb 2001 11:11:28 +1100365_- You could rewrite the query as follows:
Select ...... From Table 1 Where (Id = :HV1 or SubId = :HV1) and IndId = :HV2 and SrvcDt >=:HV3 and not (SrvcDt = :HV3 and SeqId <= :HV4)) Order by SrvcDt, SeqId
Note: By coding SrvcDt >= we can get an extra level of matching on the chosen index. The Not clause then prevents us returning unwanted rows. [...]
10145 117 29_Re: Migration from 6.1 to 7.113_Arora, Ashish26_ashish.arora@HPSGLOBAL.COM31_Tue, 27 Feb 2001 08:37:42 +0500585_- Thanks Paul, I got the useful info from the link provided and the database migration also worked fine.
> -----Original Message----- > From: Paul Murphy [SMTP:Paul_Murphy@MAY-CO.COM] > Sent: Monday, February 26, 2001 8:19 PM > To: DB2-L@RYCI.COM > Subject: Re: Migration from 6.1 to 7.1 > > If you're on a Windows platform and converting from UDB 6.1 to 7.1, no > conversion or uninstall necessary. All you have to do is install the UDB > 7.1 code. It will automatically detect the v6.1 code, all cataloged > databases, etc and install. You will have to reboot to get the [...]
10263 76 57_Re: BMC Image Copy runtime blowout when altering SHRLEVEL15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM31_Tue, 27 Feb 2001 15:13:08 +1100593_- Changing it to RESETMOD NO seemed to fix the problem (the Site default was RESETMOD YES).
Given this is the answer would anyone know why would it be the case that there should be such a dramatic increase in elapsed times and that they would accumulate for successive copies?
regards, Steve
> -----Original Message----- > From: Mallett, Steven > Sent: Tuesday, February 27, 2001 11:09 AM > To: 'DB2 Data Base Discussion List' > Subject: BMC Image Copy runtime blowout when altering SHRLEVEL > > Hello list, > > This may be an oldie but I couldn't find it in [...]
10340 22 28_C/DB2 Precompiler & compiler12_Warren Homer17_whomer@CSC.COM.AU31_Tue, 27 Feb 2001 15:26:20 +1100489_us-ascii Hi all,
I was wondering if anyone could provide some sample C or PL1 code for :
a dynamic varying-list select (as specified in sect. 6.1.4 in the DB2 V4 application programming guide) an insert a delete
Thanks. Warren
================================================ 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.
10363 40 32_Re: C/DB2 Precompiler & compiler14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 27 Feb 2001 16:02:51 +1100516_iso-8859-1 SDSNSAMP(DSNTEP2)
/* standard disclaimer */ James Campbell Hansen Corporation
-----Original Message----- From: Warren Homer [mailto:whomer@CSC.COM.AU] Sent: Tuesday, 27 February 2001 15:26 To: DB2-L@RYCI.COM Subject: [DB2-L] C/DB2 Precompiler & compiler
Hi all,
I was wondering if anyone could provide some sample C or PL1 code for :
a dynamic varying-list select (as specified in sect. 6.1.4 in the DB2 V4 application programming guide) an insert a delete [...]
10404 47 37_Allocating space on UDB 7.1 EEE on NT14_Willem Van Wyk27_Willem_van_Wyk@SANTAM.CO.ZA31_Tue, 27 Feb 2001 08:37:45 +0200353_- Hi DB2listers
I am new to DB2 and wonder if someone out there can help me.
On UDB 7.1 EEE running on NT. I would like to put table AA on drive X on all (4) nodes and table BB on drive Y on all (4) nodes How do I assign a file or device to be used . Can is specify it for a tables space ? How do I do it on node or partition level ? [...]
10452 15 55_Re: Dataspace manager - poor index performance - help!!15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 27 Feb 2001 00:33:41 -0600521_- Amy
I think the data space manager manages the data spaces (what else?), a new option of version 6. And as the data spaces don't have any programming code, I think it could be that this manager supersedes the buffer manager. Do you use data spaces for your buffer pools?
================================================ 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.
10468 27 40_Re: service wait time/data space manager15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 27 Feb 2001 02:31:43 -0600406_- Hi Amy
I'm afraid that I can't answer your questions, because they request very exact answers. Instead I have another question. Why do you use lockpart yes. I think it produces much more overhead than lockpart no. DB2 has to acquire and to propagate locks for each partition (logical intent locks as well as physical pageset locks). Increasing DSMAX doesn't give you any benfit in this case. [...]
10496 76 26_Re: Concurrent copy option15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Tue, 27 Feb 2001 03:04:53 -0600581_iso-8859-1 Raymond,
It's number three. Both COPY and RECOVER invoke DFDSS under the covers to do the backup/restore. There are three main disadvantages to concurrent copy:
1) It is not a DB2 image copy, it's a DFDSS dump. So you can't use DSN1xxx against it. In my experience DBAs prefer real ICs, which they understand. 2) If you copy multiple spaces they all go into one humungous dump dataset (This is to reduce the overhead of invoking DFDSS for each space). This means that if you need to recover a single object for any reason you may have to read through [...]
10573 44 33_Re: Archive and Purge of DB2 data10_Alan Johns26_AlanJ@PRINCETONSOFTECH.COM31_Tue, 27 Feb 2001 06:21:49 -0500607_ISO-8859-1 Hi Sri. Thanks for getting back. The archive creation process records both data and metadata i.e the table structures, indexes, views etc from the original targeted source. When restoring data, this metadata is used to 'map' the archived data to the target tables (it gives the archived data 'context', if you like). Our column mapping feature can then allow the data to be tailored to fit the target, using literals, arithmetic functions, substringing, concatenation, and key change propogation functions (to name a few). Any column type data changes are handled automatically by the tool. [...]
10618 64 33_Re: Archive and Purge of DB2 data10_Alan Johns26_AlanJ@PRINCETONSOFTECH.COM31_Tue, 27 Feb 2001 06:27:42 -0500319_ISO-8859-1 Hi Mike. I sent the same info to Sri . Didn't reailise this was you area. I will keep an eye out for any more questions and forward them to you.
alan
-----Original Message----- From: Michael Finnis Sent: 26 February 2001 21:44 To: DB2-L@RYCI.COM Subject: Re: Archive and Purge of DB2 data [...]
10683 28 29_Possible Problem Column Names19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 27 Feb 2001 07:17:08 -0600603_iso-8859-1 Hi all and TIA, DB2 z/OS, V6 and batch COBOL on OS390. Anyone ever had problems with using EDITABLE, VISIBLE, REQUIRED, and AUTH as column names. Before you check, they aren't COBOL or SQL reserved words, at least everywhere I've looked.
Regards, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, [...]
10712 53 33_Re: Possible Problem Column Names19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 27 Feb 2001 07:22:39 -0600613_iso-8859-1 Hi again, reference previous post on same issue; this could be a DB2 z/OS Precompiler problem, or a COBOL parms issue. Generating :H instead of column names in DBRM.
Regards, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from [...]
10766 120 26_Re: Concurrent copy option0_26_mark.walker@CUNAMUTUAL.COM31_Tue, 27 Feb 2001 07:32:22 -0600381_us-ascii Number one (* use DFDSS to restore from this copy externally to DB2, then optionally continue recovering using logonly?) also works. This is the basis of our disaster recovery process.
I'd love to go back to "regular" imagecopies so we could use DSN1COPY, but we have a DR process that seems to be working for us, so no need to spend any more money on it . [...]
10887 38 31_Faster Performance for RUNSTATS12_Alex Pauliah16_Apaulia1@TXU.COM31_Tue, 27 Feb 2001 07:37:20 -0600405_us-ascii Hi All,
I'm new to this list and for that matter new to the DBA world. So here's my question.
How can I make RUNSTATs run faster These are the options currently in the JCL for the long running jobs TABLE SAMPLE 25 INDEX(ALL) SHRLEVEL(REFERENCE) This is not a table that gets freshly loaded but there are a lot of inserts during the day and the RUNSTATS is run once every week. [...]
10926 90 57_Re: BMC Image Copy runtime blowout when altering SHRLEVEL13_John Arbogast32_john.arbogast.cquz@STATEFARM.COM31_Tue, 27 Feb 2001 07:48:01 -0600456_- We are about to start using shrlevel concurrent. Have you tried that? What did BMC support have to say?
-----Original Message----- From: Steven.Mallett@TEAM.TELSTRA.COM [mailto:Steven.Mallett@TEAM.TELSTRA.COM] Sent: Monday, February 26, 2001 10:13 PM To: DB2-L@RYCI.COM Subject: Re: BMC Image Copy runtime blowout when altering SHRLEVEL
Changing it to RESETMOD NO seemed to fix the problem (the Site default was RESETMOD YES). [...]
11017 26 35_Re: Faster Performance for RUNSTATS10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 27 Feb 2001 15:07:31 +0100343_us-ascii Why don't you run execute runstats every day with SHRLEVEL CHANGE (so u use UR isolation level) ?
Is it mandatory to run RUNSTATS with SHRLEVEL REFERENCE ? Usually optimizer choose the same access path
even if statistics are not 'so' accurate. Try to use UPDATE ACCESSPATH (it saves CPU time) instead of UPDATE ALL [...]
11044 33 16_DB2 and EMC SRDF14_Richard Arnold24_Richard.Arnold@CHASE.COM31_Tue, 27 Feb 2001 08:07:11 -0600418_us-ascii Hello list,
Is anyone using EMC SRDF to mirror their produciton DB2 data?
We are installing EMC SRDF to mirror our data to our Disaster Recovery site. We are being told that the DB2 log datasets IO is too high for SRDF to sustain in "semi-sync" mode.
I find this difficult to believe because EMC is SRDFing other clients to their DR sites. We are not that big of a DB2 installation. [...]
11078 48 55_Re: Dataspace manager - poor index performance - help!!15_Amy C Whitehead14_B06ACW@FDS.COM31_Tue, 27 Feb 2001 09:17:36 -0500417_us-ascii No, we are still on V5. But the service wait times documentation do refer to Dataspace manager. Thanks, Amy
Walter Janissen cc: Sent by: DB2 Data Subject: Re: Dataspace manager - poor index Base Discussion performance - help!! List
02/27/01 01:33 AM Please respond to DB2 Data Base Discussion List [...]
11127 65 35_Re: Faster Performance for RUNSTATS14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 27 Feb 2001 14:19:04 -0000375_iso-8859-1 Alex,
RUNSTATS is primarily an I/O operation and you are doing 196 of them in series (one after the other) - that's only about 1' 30" per statement. Not too long, but even if you got it down to 30" each, that's still over 1.5 hours.
Better to run them in parallel which means, as RUNSTATS doesn't support parallelism yet, running multiple jobs. [...]
11193 102 64_Re: Moving from DB2/Unix to DB2/OS390 - security consider ations13_Tzachi Nissim21_tzachi@ATTUNITY.CO.IL31_Tue, 27 Feb 2001 16:15:54 +0200343_iso-8859-1 Hi James,
Thanks for that pointer. I read the thread, but I still need help. I think I need to go into a little more detail than I did in my previous email.
General c/s facts:
- Our product provides distributed access to datasources on a variety of machines from different client APIs (ODBC, ADO, XML...). [...]
11296 96 35_AW: Faster Performance for RUNSTATS12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 27 Feb 2001 15:21:03 +0100777_iso-8859-1 Alex, have you tried
RUNSTATS TABLESPACE yourdbname.yourtsname INDEX(ALL) KEYCARD TABLE(ALL) SAMPLE SHRLEVEL CHANGE
For our shop this works fine and fast.
HTH.
With kind regards - mit freundlichen Grüssen, Georg H. Peter DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- Disclaimer: All thoughts are mine and not of the company. [...]
11393 59 20_Re: DB2 and EMC SRDF15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Tue, 27 Feb 2001 08:34:48 -0600421_iso-8859-1 Richard,
I am not at all sure that semi-sync is viable for DBMS data since as I understand it it does not guarantee that log I/O is complete before doing data I/O. You need to go fully synchronous.
If you are having problems with log data I/O rates then the only real solution is to go to data sharing and put the logs for different members on to different storage boxes/remote connections. [...]
11453 66 20_Re: DB2 and EMC SRDF16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 27 Feb 2001 09:40:16 -0500355_iso-8859-1 We are doing this with (usually) success. The biggest 'gotchas' we have encountered have been due to Telco issues. There is supposed to be a 'clean' path to our DR site which is about 20km away. Sometimes the telco has routing issues which make the distance effectively 400 miles or so. We have had significant problems when this happens. [...]
11520 41 36_Preview IBM z/OS Version 1 Release 212_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 27 Feb 2001 15:39:13 +0100832_iso-8859-1 For those who are interested: Here is an url for an IBM preview on IBM z/OS Version 1 Release 2:
http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=201-044
By the way: Is someone out there running z/OS already ?
With kind regards - mit freundlichen Grüssen, Georg H. Peter DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- Disclaimer: All thoughts are mine and not of the company. [...]
11562 20 26_Performance on DB2 7 on NT14_Philip Gunning26_philip_gunning@HOTMAIL.COM31_Tue, 27 Feb 2001 09:48:21 -0500
11583 14 14_db2-l archives0_32_Gordon.P.PROUTY@ODOT.STATE.OR.US31_Tue, 27 Feb 2001 07:16:18 -0800339_iso-8859-1 I am having difficulty finding the db2-l archives, what is the address?
Thanks!
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11598 148 64_Re: Moving from DB2/Unix to DB2/OS390 - security consider ations12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 27 Feb 2001 10:34:03 -0500588_US-ASCII Have you looked at your bind option (VALIDATE = RUN). This will use the Current SQLID for validation. The issue you may have is that the qualifier is taken from the SQLID. This will require synonyms or alias to support the many different users. A better approach is to use a common "access-id" once the user has been validates. If you take a look at the PeopleSoft security architecture. The end user also known as an operator is authenticated. Once authenticated a thread is established using an "access-id". The access id is either the implicit table owner and no synonym [...]
11747 24 23_using blobs with cobol?9_John Cops31_John.Cops@HERITAGEINSURANCE.COM31_Tue, 27 Feb 2001 09:27:06 -0600396_us-ascii I am attempting to store pdf's in a table using the blob definition. I am the first to attempt this in our shop so i am pretty lost. After going over the manual and contacting ibm, the best info i have received is cryptic at best.
Does anybody have any samples i can see that show how to set up everything from the column definitions to using the table and auxiliary table?? [...]
11772 29 18_Re: db2-l archives13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 27 Feb 2001 09:44:49 -0600603_iso-8859-1 http://jupiter.ryci.com/archives/db2-l.html
-----Original Message----- From: Gordon.P.PROUTY@ODOT.STATE.OR.US [mailto:Gordon.P.PROUTY@ODOT.STATE.OR.US] Sent: Tuesday, February 27, 2001 9:16 AM To: DB2-L@RYCI.COM Subject: db2-l archives
I am having difficulty finding the db2-l archives, what is the address?
Thanks!
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
11802 105 18_Help with some SQL10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 27 Feb 2001 10:46:36 -0500481_us-ascii HI all
I have a some sql that is selecting some columns and summing others from a view. When the view is explained, the order of process is table A then B then C. When the sql is explained it procsses table C then B then A. The problem is table C is 1200 rows, Table B is 32,000 rows and table A is 15,000,000. Can someone explain to me why DB2 switches the access around. Is it the SUMS, Where conditions, group,order, ???? The view and sql are below. Thanks [...]
11908 24 27_Regarding DB2 certification14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Tue, 27 Feb 2001 10:57:09 -0500380_iso-8859-1 Hi,
I am trying to find resources on the web to prepare for DB2 v7.1 Family Appl. Dev. certification. Unlike Java 2 cert. where I found plenty of resources on the internet including lots and lots of mock and sample tests, plus 3rd party test preparation tools, I could not locate much info for DB2. Most of my searches produced links to IBM's website only. [...]
11933 29 16_Where's url.dll?0_19_mike.holmans@BT.COM31_Tue, 27 Feb 2001 15:49:32 -0000440_- I'm playing with the TCP/IP connection to DB2 V5, using DB2 Connect PE V7 for Win95 downloaded a month or two ago. I know everyone else did this yonks ago, but I still think it's pretty magical that I can do my catalog queries from my pc and don't have to keep going in and out of QMF in my ISPF session, so I've been smiling beatifically for the last few days and pointing at my screen and saying "Oooh, look" to any passing DB2er. [...]
11963 34 25_DBAT Queued - Help Needed6_Chenny39_solaiyappan_chenniappan@MAIL.AMSINC.COM31_Tue, 27 Feb 2001 09:59:44 -0600364_- Hi All,
We are running DB2v6 on S390 being accessed via DDF and i have some conflicting numbers from DB2PM Statistics Report for a given interval between 2/21/01 10:00 AM - 2/21/01 11:00 AM:
DBAT Queued - 195 Active DBAT(snapshot) - 3 Inactive DBAT(snapshot) - 0 Max Active DBATs(HWM) - 7 Max Inactive DBATs(HWM) - 1 Max Total DBATs(HWM) - 24 [...]
11998 174 22_Re: Help with some SQL13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 27 Feb 2001 10:26:29 -0600558_us-ascii Tom,
Yes, Yes, Yes and Yes. It is the SUMS, Where conditions, group and order. The two SQL statements are very different. At runtime, the optimizer performs a view merge (I'm assuming view materialization is not occurring)....basically it takes the the two SELECT statements and merges them into one. The select against the view has more restrictive predicates than the original view definition, and therefore the optimizer has made the access path selection based on the merged SQL, which is of course different than the original view. [...]
12173 73 44_Re: DB2 Shop but SQL Server 7 support needed16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Tue, 27 Feb 2001 11:32:52 -0500443_iso-8859-1 We try to support DB2 SQLserver ADABAS mixure Steve slcockerill@nationalgypsum.com -----Original Message----- From: Cam White [mailto:cwhite@REVEALNET.COM] Sent: Friday, February 23, 2001 3:35 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Shop but SQL Server 7 support needed
RevealNet has excellent cross-database Knowledge Bases for:
* DB2 (OS/390) * Oracle Database Administration * Oracle PL/SQL Development [...]
12247 14 33_Re: Archive and Purge of DB2 data7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Tue, 27 Feb 2001 10:13:08 -0600370_- Seems very interesting. I will study further to see if it meets my clients needs.Thanks for the info Alan and Mike.
Sri
================================================ 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.
12262 33 12_DB2 DBA need13_Kathryn Sears24_ksears@DPCONSULTANTS.COM31_Tue, 27 Feb 2001 11:32:58 -0500377_us-ascii I have a strong need in the North Carolina area for a Senior DB2 DBA. This is a GREAT COMPANY, and an INDUSTRY LEADER, devoted to PROMOTING FROM WITHIN, dedicated to staying on top of NEW TECHNOLOGY.
I need to find someone who wants a HOME with a great company. STOCK options and grants are a part of the salary program. We will relocate the right person. [...]
12296 64 20_Re: DB2 and EMC SRDF19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 27 Feb 2001 10:47:04 -0600573_iso-8859-1 Richard, In addition to the other posts on this subject, unless things have changed since I looked at this product, if you have DB2 data spread across 2 or more controllers they too could be out of sync at the DR site.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in [...]
12361 83 55_Re: Dataspace manager - poor index performance - help!!14_Adrian Collett27_adriancollett@TISCALINET.IT31_Tue, 27 Feb 2001 17:54:06 +0100435_iso-8859-1 Amy,
The Data Space Manager is a sub-component of the Database Services Address Space(DBM1) and performs data set and page set space management - for a more detailed info check out the Diagnosis Guide & Reference section on sub-components.
As far as I am aware one of its functions is pre-formatting of pages during insert processing - from what I've seen of the thread I presume you have ruled that out. [...]
12445 72 31_Re: Regarding DB2 certification12_Susan Lawson22_lawson_susan@YAHOO.COM31_Tue, 27 Feb 2001 08:58:58 -0800655_us-ascii Abhijit,
The following book is available on this topic:
DB2 Universal Database V7.1 Application Development Certification Guide, by Steve Sanyal, Kevin Gashyna, David Martineau, Mike Kyprianou ISBN: 0-13-091367-7
If you need more resources, let me know.
Regards, Susan Lawson
--- "Sinha, Abhijit" wrote: > Hi, > > I am trying to find resources on the web to prepare > for DB2 v7.1 Family > Appl. Dev. certification. Unlike Java 2 cert. where > I found plenty of > resources on the internet including lots and lots of > mock and sample tests, > plus 3rd party test preparation tools, [...]
12518 47 27_Re: using blobs with cobol?15_Craig Wahlmeier27_cwahlmeier@DATA-TRONICS.COM31_Tue, 27 Feb 2001 11:08:24 -0600490_iso-8859-1 John,
Is this mainframe COBOL or non-mainframe? We have plenty of Microfocus COBOL running on Windows XX that uses BLOBs on DB2 for Windows NT. If you want some code, I'll send it...
Craig Wahlmeier Senior Technical Administrator - Database Systems Data-Tronics Corp.
-----Original Message----- From: John Cops [mailto:John.Cops@HERITAGEINSURANCE.COM] Sent: Tuesday, February 27, 2001 9:27 AM To: DB2-L@RYCI.COM Subject: using blobs with cobol? [...]
12566 19 43_DB2 performance monitors for NT/Solaris ???14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Tue, 27 Feb 2001 12:10:30 -0500455_iso-8859-1 Hi,
Has anyone come across a good performance monitor tool for use with DB2 UDB v6 / v7 on NT & Solaris? I checked IBM's website and they have the IBM DB2-PM for OS/390 only.
Thanx Abhijit
================================================ 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.
12586 80 27_Re: using blobs with cobol?9_John Cops31_John.Cops@HERITAGEINSURANCE.COM31_Tue, 27 Feb 2001 11:18:07 -0600606_us-ascii this is on a mainframe. how different is the code?
thanks John
Craig Wahlmeier cc: Sent by: DB2 Data Fax to: Base Discussion Subject: Re: using blobs with cobol? List
02/27/2001 11:08 AM Please respond to DB2 Data Base Discussion List
John,
Is this mainframe COBOL or non-mainframe? We have plenty of Microfocus COBOL running on Windows XX that uses BLOBs on DB2 for Windows NT. If you want some code, I'll send it... [...]
12667 61 53_DB2 OS/390 Certification 'Crammer' Course - April 9th12_Susan Lawson22_lawson_susan@YAHOO.COM31_Tue, 27 Feb 2001 09:46:06 -0800392_us-ascii Hello all,
I am pleased to announced that we will be offering the DB2 for OS/390 Version 7 DBA Certification Course at the YL&A DB2 Symposium in St Louis, MO on April 9th. This course will be taught by Susan Lawson of YL&A. Susan Lawson and Richard Yevich have recently completed the DB2 for OS/390 and Z/OS Version 7 DBA Certification Guide to be published this spring. [...]
12729 137 28_Re: REORG UNLOAD/LOAD FORMAT14_Toppins, Smike21_smike.toppins@GWL.COM31_Tue, 27 Feb 2001 11:25:16 -0700636_- Please tell me where I can find more information on this EXTERNAL parameter that you used. It is not in the Utility manual (V5) that I have.
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
> ---------- > From: Asamoto, Roy[SMTP:Roy.Asamoto@STAUTO.COM] > Reply To: DB2 Data Base Discussion List > Sent: Saturday, February 24, 2001 11:49 AM > To: DB2-L@RYCI.COM > Subject: Re: REORG UNLOAD/LOAD FORMAT > > Smike, > > The Reorg utility with UNLOAD EXTERNAL will create the LOAD > statements for you as long as you have the SYSPCHxx defined for each > REORG UNLOAD statement. You can [...]
12867 66 41_Re: Allocating space on UDB 7.1 EEE on NT12_Cook, Nicole19_Nicole_Cook@BMC.COM31_Tue, 27 Feb 2001 14:16:28 -0600581_iso-8859-1 Are drives X and Y available on all four partitions? By that I mean can you access both drives from each partition in the system? If so, then you can create tablespaces that have containers that span all four nodes but use that one drive. You will need to create a nodegroup that has all 4 partitions listed, then create a tablespace that spans across each node listed in this nodegroup. When creating the tablespaces, you will create multiple containers that exist on the appropriate drive (make sure you have at least one of the containers assigned to every node [...]
12934 168 22_Re: Help with some SQL0_24_db46@DAIMLERCHRYSLER.COM31_Tue, 27 Feb 2001 15:35:22 -0500580_us-ascii You might also try using a case statement in the where clause as follows:
SELECT * FROM DBMISRP.MITPREM1, DBMISRP.MITCREN1, DBMISRP.MITCRPR1 WHERE CSTMR_LVL_C = SRC_CSTMR_LVL_C AND PRAC_DTL_N = SRC_PRACT_DTL_NO AND RPTG_BR_N = SRC_ENT_CODE AND SRC_ENT_TYPE IN ('B', 'P') AND ( CASE TGT_MIS_CATGY_TY_C WHEN '15' CASE WHEN RPTG_ARTR_POL_C > ' ' THEN 1 ELSE 0 END WHEN '25' CASE WHEN RPTG_ARTR_POL_C > ' ' THEN 1 ELSE 0 END WHEN '17' CASE WHEN NON_DOMESTIC_IND = 'Y' THEN 1 ELSE 0 END WHEN '27' CASE WHEN NON_DOMESTIC_IND = 'Y' THEN 1 ELSE 0 END ELSE 1 END) = 1 [...]
13103 52 35_Re: Faster Performance for RUNSTATS0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 27 Feb 2001 16:03:30 -0600344_us-ascii We didn't have a long enough maintenance window to do all RUNSTATS on same day, so instead we now RUNSTATS a different part of the system each day. This way our stats are no more than a week out of date, which is acceptable.
Max Scarpa @RYCI.COM> on 2001/02/27 08:07:31 AM [...]
13156 204 75_Why is it so? An academic question as to why DB2 chooses a bad me rge scan.12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 28 Feb 2001 09:10:49 +1100534_iso-8859-1 > Dear List-Gurus, > came across a bit of a curly SQL from an App. programmer. > Although I've corrected SQL and it's now performing it's a bit of a > mystery to me why DB2 ever choose the bad Access path to begin with. I've > enclosed the relevant stat's at the end of the posting. > > Basically the query is trying to extract all relevant "nodes" given a > customers phone number. Phone_Nbr is on table F01 (Pkey Serial_Nbr), F02 > is an intersection table with F01 and yields Cust_Nbr. I03 & I04 implement > a tree [...]
13361 107 26_Re: Concurrent copy option15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 28 Feb 2001 09:22:47 +1100329_- Mark/Andy,
Thanks for the comments, guys. I was hoping DFDSS was invoked both ways i.e. during copy and recover. As soon as this TDMF/concurrent copy incompatibility is resolved I'll give it a go. Hell, even if it takes 5 minutes it's a damn sight better than the 4.5 hour Load Replace I'd otherwise be looking at. [...]
13469 64 35_Re: Faster Performance for RUNSTATS12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 28 Feb 2001 09:49:01 +1100322_- I'm coming in on the tail end of this thread, with out the benefit of having seen what's gone before, so firmly planting foot in mouth I respond with:
* Have you tried some of the RUNSTAT option like SAMPLE, and reducing the number of columns that you might be collecting stats on to just the index columns? [...]
13534 43 34_Strange DB2 Optimizer phenomena...10_Mike Wiles14_mwiles@UCG.COM31_Tue, 27 Feb 2001 17:50:24 -0500447_iso-8859-1 Hi List!
I've got a very strange phenomena on one of my DB2 6.1 (AIX) databases. In a four table join, I narrow one of the dimensions with an "in" that looks like this:
"field1 in (900001,900002,900003,900004,900005,900006,900007,900008)". When I run this, the query takes about 15 seconds.
If I change that to "field1=900001" the query _never_ returns (or it hasn't yet, because we kill it after 10 minutes.) [...]
13578 71 38_Re: Strange DB2 Optimizer phenomena...11_RICHARD YAN23_DHSPA3F@DHS.STATE.IL.US31_Tue, 27 Feb 2001 17:08:55 -0600326_US-ASCII Mike,
I have no idea why. but I'm very interested in it. Would you do an explain on each of the statement and send it over. Please also include the DDL for the table and indexes. Please use following options when you format the access plan.
db2exfmt -d dbname -w -1 -n % -s % -# 0 -g TIC -o output [...]
13650 61 16_Re: DB2 DBA need17_Esmaiel Nokhodian15_dbaen@TEXAS.NET31_Tue, 27 Feb 2001 17:21:53 -0600475_iso-8859-1 Hi Kathryn,
Attached is a copy of my resume. I am interested in DB2 DBA position. Please review my resume and let me know if you have any further questions.
Thanks-Esmaiel, 512-340-6974 wk. 512-335-0971 hm
----- Original Message ----- From: Kathryn Sears Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, February 27, 2001 10:32 AM Subject: DB2 DBA need [...]
13712 29 44_Re: DB2 Shop but SQL Server 7 support needed12_Jim Harrison12_jimh@QIS.NET31_Tue, 27 Feb 2001 18:58:31 -0500467_us-ascii I'm suprised anyone owned up to M204! I didn't list it as I don't want to remind anyone where I work that I know anything about it. Unfortunately I spent several years learning & supporting it, wondering the whole time why I got into it. We still have it in house, but it's been targeted to become history - some day. As well as IDMS, which I worked with (and loved) for a long time in a previous job but don't care to deal with in my current position. [...]
13742 59 83_DB2/0S390 V5: shared use of DB2 subroutines by WLM-SP, CICS and T SO batch programs9_Gerard Ip26_Gerard.Ip@COLESMYER.COM.AU31_Wed, 28 Feb 2001 11:38:22 +1100631_iso-8859-1 Hi All,
My company is implementing WLM stored procedures. In the past many COBOL subroutines with DB2 SQL were developed and shared used (dynamically linked to) by CICS programs and TSO batch programs. These subroutines are also required to be used by WLM stored procedures. I understand a DB2 subroutine to be called by WLM stored procedures has to be precompiled, compiled and link-edited a little bit different from those for CICS programs and TSO Batch programs especially the RRSAF attachment and the language interface DSNRLI. An easy way to make available this routine to WLM-SP is to produce another [...]
13802 60 25_Data Warehouse Center 7.111_Mike Barton14_MikeBa@VSP.COM31_Tue, 27 Feb 2001 17:36:08 -0800
13863 180 78_Re: Why is it so? An academic question as to why DB2 chooses a bad merge scan.13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 27 Feb 2001 22:16:04 -0600606_iso-8859-1 Nick,
Simple answer - the query is a little odd. Complex answer - Read on....
There is no join predicate between F01 and any other table, therefore there is a cartesian join between F01 and I03/I04.
If F01 returns only one row, then a cartesian to any other table does not introduce duplicate rows....so it doesn't seem too bad....but...joined to every row of I04!!! Explain shows a nested loop join between two tables with no join predicates. Now the predicate which is doing the majority of filtering on I03 (I'm assuming CURR_IND = 'Y' has a low cardinality) is the [...]
14044 64 40_Re: Preview IBM z/OS Version 1 Release 214_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 28 Feb 2001 15:46:33 +1100440_iso-8859-1 Any non-IBM sites would have an NDA (Non disclosure agreement) that would prevent them saying "yes".
But you can be pretty sure that the ISVs are running z/OS.
/* standard disclaimer */ James Campbell Hansen Corporation
-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Wednesday, 28 February 2001 1:39 To: DB2-L@RYCI.COM Subject: [DB2-L] Preview IBM z/OS Version 1 Release 2 [...]
14109 103 88_Re: DB2/0S390 V5: shared use of DB2 subroutines by WLM-SP , CICS and T SO batch programs14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 28 Feb 2001 15:50:27 +1100562_iso-8859-1 Gerard,
Firstly, despite the subject you placed on your question, WLM-SPs are not available with DB2 V5.
Let me get this right: you want to have a single DB2 load module that can (successfully) be exectuted in CICS, WLM-SP and TSO? Yes, it can be done. Have a look in the archives - this comes up from time to time (look for, eg, "TCBCAUF"). However, I am coming to the conclusion that programs being executed in batch, CICS or SPAS (either WLM- or DB2-) should each have their own load libraries with appropriately linked modules. [...]
14213 15 23_Rexx callable interface21_Devineni, KishoreBabu29_KishoreBabu.Devineni@NIKE.COM31_Tue, 27 Feb 2001 20:55:57 -0800372_us-ascii I am just trying to use DSQCIX. I am getting return code of 16 in the start command. Can anybody tell me how to fix this.
================================================ 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.
14229 200 27_Re: using blobs with cobol?14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 28 Feb 2001 15:58:39 +1100585_iso-8859-1 The following is from a variety of sources, and sometimes refers to other mails which are not included here. It specifically refers to CLOBs, but programming BLOBs is the same - except there is no CCSID translation. CREATE LOB TABLESPACE xxxxxxxx IN DBAAAAAA USING STOGROUP .... BUFFERPOOL BPy LOCKSIZE LOB LOG NO ; CREATE TABLESPACE yyyyyyyy IN DBAAAAAA USING STOGROUP .... BUFFERPOOL BP1 LOCKSIZE PAGE CCSID EBCDIC ; (Note read the Admin Guide guidelines on assigning a tablespace to a bufferpool. Don't use a "non LOB" buffer pool, and set DWQT to zero) [...]
14430 102 79_Re: Why is it so? An academic question as to why DB2 chooses a ba d merge scan.12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 28 Feb 2001 16:12:36 +1100465_- Terry, ahhhhh! Thanks, the penny has finally dropped so to speak. I was wondering why the evaluation of the subquery didn't do much for the access path. I should have realised it. Chalk up one more black mark for correlated Sub-queries.
It's at times like these I wish DB2 would re-write the correlated Sub-query into a join. But then again it gave me a chance to suggest another use for a NTE. I'm beginning to like them; ... must be your influence. [...]
14533 137 87_Re: DB2/0S390 V5: shared use of DB2 subroutines by WLM-SP , CICS and TSO batch programs13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 27 Feb 2001 23:12:36 -0600612_iso-8859-1 James/Gerard,
DB2 V5 introduced WLM Stored Procedures. DB2 V4 had DB2 managed only.
I cannot disagree with the statement "SPs are great, but ONLY IF THEY CANNOT BE EFFICIENTLY EXECUTED IN THE CALLER'S ENVIRONMENT". But I seem to recall a comparison from the IBM Performance Labs regarding SQL statements in CICS or a SP. After about 20 SQL statements the SP outperforms the CICS transaction, since the CICS subtask switch is so high for each call (including OPEN CURSOR, each FETCH etc.). If that is true, then most CICS programs would be doing around 15-20 fetches alone to fill a [...]
14671 50 88_Re: DB2/0S390 V5: shared use of DB2 subroutines by WLM-SP , CICS and T SO batch programs15_Richard Simpson20_rsimpson@AU1.IBM.COM31_Wed, 28 Feb 2001 16:44:18 +1100592_us-ascii James Campbell wrote:
>Gerard, > >Firstly, despite the subject you placed on your question, WLM-SPs are not >available with DB2 V5.
Mmmm, are you sure about that James ? News to me. He did say 5 after all, not 4.
To quote from the V5 "What's New" manual
"Enhanced Stored Procedures Environment
With Version 5 and enhancements to the MVS workload manager that are available in OS/390 Release 3, the DB2 stored procedures environment supports a higher volume of transaction processing than in prior releases. Enhancements include the following: [...]
14722 119 41_Re: Allocating space on UDB 7.1 EEE on NT14_Willem Van Wyk27_Willem_van_Wyk@SANTAM.CO.ZA31_Wed, 28 Feb 2001 08:13:55 +0200378_- Nicole I am using a test/development system. 1 cpu pc with 3 local drives. In the prod system we will span data over more that one drive (and partition). I since found that I can create the tablespaces with the "containers" from the command line but the problem is only in the ControlCentre. In ControlCenrte when I add a container I can not select a drive or directory. [...]
14842 31 88_Re: DB2/0S390 V5: shared use of DB2 subroutines by WLM-SP , CICS and T SO batch programs14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 28 Feb 2001 17:24:22 +1100486_iso-8859-1 OK, so I was wrong. My only excuse is that I managed to skip V5.
-----Original Message----- From: Richard Simpson [mailto:rsimpson@AU1.IBM.COM] Sent: Wednesday, 28 February 2001 16:44 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2/0S390 V5: shared use of DB2 subroutines by WLM-SP , CICS and T SO batch programs
James Campbell wrote:
>Gerard, > >Firstly, despite the subject you placed on your question, WLM-SPs are not >available with DB2 V5. [...]
14874 17 41_Sharon Fields/PCSHS is out of the office.0_23_Sharon.Fields@PCSHS.COM31_Wed, 28 Feb 2001 00:41:27 -0700520_us-ascii I will be out of the office starting 02/27/2001 and will not return until 03/13/2001.
I will respond to your message when I return. If you require DBA support in the interim, you may contact Debra Kopecky (x2376), Ben Richardson (x8553), Myron Perlmutter (x8506)
================================================ 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.
14892 54 44_Re: DB2 Shop but SQL Server 7 support needed11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Wed, 28 Feb 2001 09:51:48 +0200627_iso-8859-7 I am supporting DB2 for OS/390 ,DB2 UDB for NT and finally SQL SERVER.Of course,after some time of applications running on Sql Server (and even DB2 on NT),almost everybody wants them to be moved to the mainframe....
Regards,
Popy A. Dimoka Interdata S.A Athens,Greece
> ---------- > From: Jim Harrison[SMTP:jimh@QIS.NET] > Reply To: DB2 Data Base Discussion List > Sent: ÐáñáóêåõÞ, 23 Öåâñïõáñßïõ 2001 9:57 ìì > To: DB2-L@RYCI.COM > Subject: Re: DB2 Shop but SQL Server 7 support needed > > Now that you mention it, I'm curious how many DBAs support multiple > databases. We have all three [...]
14947 15 35_Re: Faster Performance for RUNSTATS10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 28 Feb 2001 08:48:24 +0100393_us-ascii We run Runstats out of maintenance window, when tx load is low or very low using SHRLEVEL CHANGE, SAMPLE, UPDATE ACCESSPATH.
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.
14963 49 20_Re: Where's url.dll?20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Wed, 28 Feb 2001 08:04:32 -0000426_iso-8859-1 Mike,
Help works in my Command Senna. It fires up Internet Explorer to view stuff.
Url.dll is in my windows\system folder and is copyright Microsoft so I guess the problem is in your Internet Explorer setup, rather than in DB2.
Hugh -----Original Message----- From: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] Sent: 27 February 2001 15:50 To: DB2-L@RYCI.COM Subject: Where's url.dll? [...]
15013 89 44_AW: DB2 Shop but SQL Server 7 support needed12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 28 Feb 2001 09:18:21 +0100832_iso-8859-7 Kalimera, Popy.
that is our experience too. Some of our apps where running first on the MS SQL Slower. And after a short time the app people came to me and begged me to implement their apps on the good old big iron - with DB2 for OS/390.....
With kind regards - mit freundlichen Grüssen, Georg H. Peter DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- Disclaimer: All thoughts are mine and not of [...]
15103 29 32_DB2 and EMC SRDF - Great Success15_Jeffery A Price17_jprice@IPALCO.COM31_Wed, 28 Feb 2001 06:37:09 -0500582_us-ascii Richard,
We have an EMC symmetrix at our main data processing center, and a remote symm at another service center (about 20 miles away). All DB2 volumes, including logs, are fully syncronous SRDF. For DR, we pull BCV's from remote symm, transport them to off-site location, and IPL. We have tested this on three separate occasions. For one test, we even unplugged the SRDF links while both a huge DB2 update and IMS update jobs were runnning. When we IPL'd at DR site, DB2 and IMS backed out 1 or 2 transactions. Amazing. Anyway, I'd argue that sync mode would [...]
15133 36 35_Assembler program & SQL - a request10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 28 Feb 2001 12:27:46 +0100634_us-ascii Dear Listers,
As everyone knows (even stones), I don't know anything about assembler (and many other things, starting from DB2).
Unfortunately I need aa assembler program executing INSERTs and DELETEs to create an Tape Management System using DB2 tables (you know I've to archive my centerfolds).
I searched the archives but I didn't find any post regarding assembler & SQL so... is there any powerful & good-hearted man or some wonderful woman (eehhmmm I think the correct English term is 'fawning'...) who can provide some code or can indicate some web site where I can find samples ? It's enough [...]
15170 78 20_Re: Where's url.dll?0_19_mike.holmans@BT.COM31_Wed, 28 Feb 2001 11:33:08 -0000383_- Ah. Thanks to everyone who replied by email too. I suppose that those of us who don't have IE installed are in a bit of a mess, then. Does anyone know of a way to make this work with Netscape 4.7?
Mike Holmans BT ISE Database Services mike.holmans@bt.com
This post represents the views of the author and does not necessarily accurately represent the views of BT [...]
15249 31 27_Re: Rexx callable interface14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 28 Feb 2001 22:58:50 +1100489_iso-8859-1 I'ld start by looking at what dsq_message_id and dsq_message_text contain.
/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Devineni, KishoreBabu [mailto:KishoreBabu.Devineni@NIKE.COM] Sent: Wednesday, 28 February 2001 15:56 To: DB2-L@RYCI.COM Subject: [DB2-L] Rexx callable interface
I am just trying to use DSQCIX. I am getting return code of 16 in the start command. Can anybody tell me how to fix this. [...]
15281 16 27_Re: Rexx callable interface10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 28 Feb 2001 13:14:46 +0100350_us-ascii In DB2-L documents (May 2000) there's a REXX exec sample using DSQCIX.
HTH
Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15298 32 20_Re: Where's url.dll?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 28 Feb 2001 07:20:28 -0500360_iso-8859-1 Hi Mike, I use Netscape 4.73 as my primary browser and help fails for me but with no messages. I click Help and one of the menu items and my browswer window is brought into focus, but no connection is made to the help pages. I have IE 5.0 also and there is no url.dll on my machine anywhere either. I also use Netscape 6.0 and it doesn't help. [...]
15331 36 82_Central PA DB2 Users Group - Susan Lawson, YL&A - March 28th-29th - $150 per class10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Wed, 28 Feb 2001 07:53:01 -0500569_us-ascii Hi everyone! It is my pleasure to be hosting Susan Lawson of YL&A for 2 days of DB2 classes right here in Central PA!! Although this will be Susan's first visit to our User Group, many of you are probably already very familiar w/Susan as the heart & soul behind the successful world-wide DB2 Symposium classes. At numerous IDUG events, she's been named Best Overall Speaker. She's also an IBM Gold Consultant who has authored books such as the popular DB2 Answers & DB2 High Performance Design and Tuning. I am positive that you will find her & the class [...]
15368 157 41_Re: Different results in program vs SPUFI11_David Nance16_DWNance@FHSC.COM31_Wed, 28 Feb 2001 08:19:26 -0500563_US-ASCII Mohammad, Was wondering if/how this was solved for your installation, I have just run across the same error here in our shop.
Dave Nance First Health Services, Corp. (804)527-6841
>>> mkkhan88@HOTMAIL.COM 01/22/01 11:53PM >>> To check my theory regarding this problem ( that singleton select is not working ) I wrote a program with both singleton select and and cursor. And sure enough the FETCH found the row but the SELECT did not. Here is program, the job output and working data. And yes our DBA is going to get in touch with IBM. [...]
15526 55 20_Re: Where's url.dll?0_19_mike.holmans@BT.COM31_Wed, 28 Feb 2001 13:29:13 -0000594_- Thanks, Dave.
At least it's not something *I've* screwed up, which always seems likely when I'm not dealing with OS/390. (I screw things up on that platform too, but at least I can usually work out what I've done wrong.)
Mike
> -----Original Message----- > From: Seibert, Dave [SMTP:Dave_Seibert@COMPUWARE.COM] > Sent: Wednesday, February 28, 2001 12:20 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Where's url.dll? > > Hi Mike, > I use Netscape 4.73 as my primary browser and help fails for me but > with > no messages. I click Help and one of the menu items and [...]
15582 139 39_Re: Assembler program & SQL - a request20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 28 Feb 2001 08:32:07 -0500713_iso-8859-1 Here is one quick and dirty sample
YREGS BUG CSECT STM R14,R12,12(R13) LR R12,R15 LA R14,2048(R12) LA R14,2048(R14) USING BUG,R12,R14 XC SAVEAREA(72),SAVEAREA LA R11,SAVEAREA ST R13,4(R11) ST R11,8(,R13) LR R13,R11 CAFCALL LOAD EP=DSNALI ST R0,LIALI LOAD EP=DSNHLI2 ST R0,LISQL * CONNECT L R15,LIALI A(DSNALI) CALL (15),(CONNECT,SYS,TECB,SECB,RIBPTR),VL * OPEN L R15,LIALI A(DSNALI) CALL (15),(OPEN,SYS,PLAN),VL ** L R7,=F'1' OPEN (OUTDATA,(OUTPUT)) CATSECT LA R4,CAAREA USING CA,R4 LA R9,DAAREA USING SQLDSECT,R9 EXEC SQL X SELECT TOTAL X INTO MX X FROM (SELECT EMP_ID, SUM(SALARY) AS TOTAL X FROM TGATEBT.TBTSTEMP X WHERE EMP_ID = 'AAA' X GROUP BY EMP_ID) AS T *** BCT R7,CATSECT RETURN1 [...]
15722 44 50_Am I asking too much of my Structure Change Tool ?19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Wed, 28 Feb 2001 07:36:22 -0600383_us-ascii I am looking at a system with the following -
TABLE1 (COL1A, COL1B) where COL1A is primary key TABLE2 (COL2A, COL2B, COL2C) where (COL2A, COL2B) is primary key and a foreign key ties COL2A back to COL1A in TABLE1 TABLE3 (COL3A, COL3B, COL3C, COL3D) where (COL3A, COL3B, COL3C) is primary key and a foreign key ties (COL3A, COL3B) back to (COL2A,COL2B) in TABLE2 [...]
15767 48 20_Re: Where's url.dll?9_Alex J.P.16_apaulia1@TXU.COM31_Wed, 28 Feb 2001 07:21:13 -0600350_- Hi Mike
"url.dll" is in the system directory of windows. I use WinNT and this file is found in c:\winnt\system32\url.dll
I do not think it is a part of the db2 connect client software but I cannot be sure of this.
mail me if you need more help
Alex... On Tue, 27 Feb 2001 15:49:32 -0000, mike.holmans@BT.COM wrote: [...]
15816 24 88_Re: DB2/0S390 V5: shared use of DB2 subroutines by WLM-SP , CICS and T SO batch programs13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 28 Feb 2001 08:46:45 -0500322_iso-8859-1 >OK, so I was wrong. My only excuse is that I managed to skip V5. James,
Aliquando bonus dormitat Homerus. (Even the good Homer nods.)
I was just about to send this when I realized the sad possibility this could lead to a discussion of the Simpsons. ... please don't go there -- wrong Homer. [...]
15841 101 87_Re: DB2/0S390 V5: shared use of DB2 subroutines by WLM-SP, CICS and T SO batch programs0_26_JCameron@MSI-INSURANCE.COM31_Wed, 28 Feb 2001 07:50:43 -0600338_us-ascii We are using WLM stored procedures and ran into this problem too. For COBOL stored procedures that are also used as callable sub-programs, we use a different compile routine that executes 2 link-edits, with each module going to a different PDS. This way we only have 1 copy of the source code. It's not ideal, but it works. [...]
15943 72 16_Re: DB2 DBA need13_Kathryn Sears24_ksears@DPCONSULTANTS.COM31_Wed, 28 Feb 2001 09:13:01 -0500602_us-ascii Your resume was not attached to this email-- could you please resend it? I will check through the rest of my emails and make sure that I have not received it elsewhere! Thanks-- Kathryn
Esmaiel Nokhodian wrote: > > Hi Kathryn, > > Attached is a copy of my resume. I am interested in DB2 DBA position. Please > review my resume and let me know if you have any further questions. > > Thanks-Esmaiel, > 512-340-6974 wk. > 512-335-0971 hm > > ----- Original Message ----- > From: Kathryn Sears > Newsgroups: bit.listserv.db2-l > To: > Sent: [...]
16016 29 53_Re: Am I asking to much of my structure change tool ?19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Wed, 28 Feb 2001 08:37:16 -0600509_us-ascii Further to my previous note -
I tried running the script produced by Embarcardero and Quest - AND THEY WORK !!!
So I now have two tables with columns of different lengths with a foreign key relationship between them. I insert a string less than 10 characters into the parent and the same string into the child and the RI check is fine. Add an eleven character field and (of course) you can't enter eleven characters into the ten character child field so the RI check always fails. [...]
16046 36 24_Data Type not Compatible15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM31_Wed, 28 Feb 2001 08:47:13 -0600462_us-ascii I am trying to do a query against the catalog to determine if runstats has not been run in x number of days. My select looks like this:
DECLARE STATCSR CURSOR FOR SELECT A.NAME, A.DBNAME, A.STATSTIME, B.SPACE FROM SYSIBM.SYSTABLESPACE A, SYSIBM.SYSTABLEPART B WHERE A.DBNAME = B.DBNAME AND A.NAME = B.TSNAME AND A.CREATOR = 'SAPR3' AND B.SPACE > -1 AND (DATE(A.STATSTIME) < CURRENT DATE - :WS-NO-DAYS DAYS) ORDER BY A.STATSTIME DESC [...]
16083 29 25_Host variables in linkage0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 28 Feb 2001 09:02:46 -0600520_us-ascii I have had to solve several application problems related to host variables in linkage (or host variables in the FD of a file). I know why it is a bad practice to use host variables in linkage but have had a hard time communicating to the rest of the shop that this should be avoided. Almost every time a programmer brings this problem to me, they have been working on it for quite some time and are usually saying that DB2 is broken. Usually, they have put displays in their program and are very confused. [...]
16113 20 16_Re: DB2 DBA need13_Kathryn Sears24_ksears@DPCONSULTANTS.COM31_Wed, 28 Feb 2001 10:00:10 -0500322_us-ascii Sorry about that last listserve posting-- I am not really well-versed in this type of thing and had not realized that I had not been emailed directly when I responded.
FUTURE RESPONSE to the DB2 DBA posting (which I would love to receive) should be emailed directly to me at: ksears@dpconsultants.com [...]
16134 104 27_Re: using blobs with cobol?15_Craig Wahlmeier27_cwahlmeier@DATA-TRONICS.COM31_Wed, 28 Feb 2001 09:07:54 -0600316_iso-8859-1 John,
Can't speak to how different the code is. We are running DB2 V5 on the mainframe and therefore have no blobs or COBOL code that uses blobs. We used the NT platform for the imaging systems we wrote. (Disk space is much cheaper than mainframe...)
Let me know if you want it anyway. [...]
16239 17 29_Re: Host variables in linkage16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Wed, 28 Feb 2001 10:28:52 -0500514_us-ascii This situation has been around for a long time. The first time that I saw it was in DB2 os/390 version 1.3 in 1988 and it caused the same confusion then that you are describing now. If someone has a permanent solution, it would be nice to know.
Rick Creech
================================================ 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.
16257 61 33_Host variables in linkage (Reply)0_22_scott.goodell@WCOM.COM31_Wed, 28 Feb 2001 09:29:14 -0600459_us-ascii I would agree Larry. This is a very confusing issue for programmers when they run across it. We have had that happen a couple times here but it is not a major problem. I agree IBM should check the condition and flag it during the pre-compile.
Scott
L-IS.Kirkpatrick@MUTUALO FOMAHA.COM To: DB2-L@RYCI.COM Sent by: DB2 Data Base cc: Discussion List Subject: Host variables in linkage [...]
16319 32 29_Re: Host variables in linkage13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 28 Feb 2001 10:44:10 -0500543_iso-8859-1 Hi Larry, Yes, I have run into this years and years ago -- at least the File Section. Back then, if I recall, I was fighting with a change mgmt fascist who had a funny understanding of providing a disservice to his customers. He was upset with the fact that you could have copybooks expanded by either COBOL Copy or SQL INCLUDE.... In my battles, I found that you can't get the precompiler to expand an include that is in the File Section. I found also that it is documented in the Appl. Pgming & SQL guide that Host variables [...]
16352 62 28_Re: Data Type not Compatible11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 28 Feb 2001 09:55:29 -0600674_- Daniel - try this (have not tried it, looks like it should work):
AND DAYS(CURRENT DATE) - DAYS(A.STATSTIME) >= :WS-NO-DAYS
Declare ws-no-of-days as s9(4) comp or s9(9) comp.
Good luck!
Suresh
>From: Daniel Sullivan >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Data Type not Compatible >Date: Wed, 28 Feb 2001 08:47:13 -0600 > >I am trying to do a query against the catalog to determine if runstats has >not been run in x number of days. My select looks like this: > > > DECLARE STATCSR CURSOR FOR > SELECT A.NAME, A.DBNAME, > A.STATSTIME, B.SPACE > [...]
16415 99 28_Re: Data Type not Compatible13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 28 Feb 2001 10:20:12 -0600449_iso-8859-1 Daniel,
I would prefer to understand why your original SQL does not work.
The host variable :WS-NO-DAYS should be numeric, such as PIC S9(9) COMP, or some other numeric datatype.
What error message do you receive when you compile with a COMP?
Also, just for FYI, you can change to predicate from stage 2 to stage 1 (and indexable) by moving the DATE scalar function to the non-column expression, such as: [...]
16515 81 29_Re: Host variables in linkage0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 28 Feb 2001 10:34:56 -0600423_us-ascii The specific recent battle was caused by a DB2 application program that used host variables found in linkage. Since this program was called by a program that did not locate the passed values at the same location each time, there were some very confusing results. The solution to the problem was to first move the value from linkage into working storage and then to use the host variable from working storage. [...]
16597 36 24_-904 RC00C200F3 QUESTION16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Wed, 28 Feb 2001 09:45:13 -0700417_us-ascii We recently had a locking problem in a set of our batch jobs which run concurrently accessing the same DB2 plan. One of the jobs went down with a -904 RC00C200F3 and in viewing the output from the job in question, it appears as though it was due to some contention on the primary index (partition 2) of a twelve partition tablespace. The messages and codes manual provides the following for RC00CF0023: [...]
16634 74 28_Re: -904 RC00C200F3 QUESTION19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Wed, 28 Feb 2001 11:31:59 -0600387_iso-8859-1 Jeff, Here's some guesses! Were the two jobs running on two different members? If so, look into MEMBER CLUSTER, TRACKMOD (if Incremental Image Copy isn't used), and GPBCACHE in an effort to gain more concurrency. Of course, if both are trying to get to the same page/row at the same time I'd look into commit frequency, lock size, and BIND (CS, if applicable) parms too. [...]
16709 28 41_Re: Different results in program vs SPUFI13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Wed, 28 Feb 2001 12:16:20 -0600365_- Dave We changed the "SELECT ... INTO " to a CURSOR as we wanted it fixed by yesterday. BTW it turned out to be a known problem ( to IBM that is ) and they sent a patch. For some purely local reasons the patch has not been applied and I'm only hoping (!?) that other SELECT's are working OK. Get in touch with IBM and apply the patch ASAP. Good luck Mohammad [...]
16738 19 34_Report on cpu time for a DB2 table10_Hong, Lynn23_syljh@SMTP.AIS.UCLA.EDU31_Wed, 28 Feb 2001 10:19:34 -0800366_iso-8859-1 Hello everyone, We have a user who frequently downloads DB2 tables via DDF. My manager would like to monitor his activities on the cpu consumption of one specific table. I don't see anything in SMF101 records that pertains to a specific table. Does anyone know how to do this? I'm not a DB2 person, please be descriptive as much as possible. Thanks. [...]
16758 96 6_Unload20_Balaguru Paramasivan17_pbalaguru@USA.NET29_Wed, 28 Feb 2001 11:49:51 MST698_US-ASCII Hi,
//STEP10 EXEC BMCUNLD, // RC='4', // SYSTEM='DSND', // UID='O7WSTEST20', // UTPROC='NEW', // MSGLEVEL='MSGLEVEL(1)' //SYSREC DD DSN=DSET.UNLOAD.FILE, // DISP=(NEW,CATLG,DELETE), // SPACE=(CYL,(50,50),RLSE), //* DCB=(RECFM=VB,LRECL=289,BLKSIZE=0), // UNIT=DISK, // LABEL=RETPD=14 //SYSCNTL DD DSN=DSET.TEMP.FILE, // DISP=(NEW,CATLG,DELETE), // SPACE=(TRK,(3,1),RLSE), // UNIT=DISK, // LABEL=RETPD=14 //SYSIN DD * UNLOAD ORDER YES MAXSORTS 3 SORTNUM 12 ENUMROWS 100000 DIRECT NO SELECT A.CLNT_ID, C.PLCY_ACCT_NUM, C.LOB, A.NAME_FIRST, A.NAME_MID, A.NAME_LAST, A.NAME_SFX FROM ZYA.RR45 A, ZYA.RR44 B, ZYA.RR42 C WHERE (A.CLNT_ID = B.CLNT_ID AND A.NAME_ID = B.NAME_ID) [...]
16855 39 38_Re: Report on cpu time for a DB2 table13_Pranav Sampat21_psampat@PACIFICEX.COM31_Wed, 28 Feb 2001 11:03:23 -0800435_US-ASCII SMF101 ecords does report DDF activity however accounting is not specific to a particular table but to that particular DDF thread. You can monitor the thread corresponding to your user. Remote location will point to the IP address of he user. One caution, this accounting cannot be used for chargebacks as it a user's thread activity which is from the time the connection is first established till connection terminates. [...]
16895 23 21_Peoplesoft Upgrade V812_Deb Rumancik32_Deborah_Rumancik@PROGRESSIVE.COM31_Wed, 28 Feb 2001 14:10:08 -0500531_us-ascii We use Peoplesoft Financials, the GL module and are currently upgrading from V7 to V8 on DB2 V6.1 and OS/390 2.8. I am the DB2 DBA and I am interested in sharing experiences with anyone going down this path. Setting up the environments for test and demo has been very tedious. We have installed the V8 demo, but are having problems. We have started upgrading the copies of V7 demo and test. I would like to know how others handle the ddl, the security, are you renaming objects, etc. I would appreciate any feedback. [...]
16919 59 25_Data Warehouse Center 7.111_Mike Barton14_MikeBa@VSP.COM31_Wed, 28 Feb 2001 11:22:49 -0800
16979 40 25_Data Warehouse Center 7.111_Mike Barton14_MikeBa@VSP.COM31_Wed, 28 Feb 2001 11:29:15 -0800566_iso-8859-1 I have just recently installed a server with UDB 7.1 EE on WinNT 4.0. Previously we were using UDB V6.x with Visual Warehouse. I have been trying to define some fairly simple process steps, copying data from an OLTP table, to a table with the exact same e structure, to support reporting requirements. Both the Source and Target tables are already defined, and contain 237 columns each. The task of building the SQL query in Visual Ware house used to take about 5 minutes (an awfully long time, in my opinion at the time). The same task now takes 45 [...]
17020 21 27_Sybase 11 to UDB conversion0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 28 Feb 2001 14:56:19 -0500444_us-ascii With the help of Paul Simon of ManTech, I will be trying to convince the powers to be to let us use UDB 7.1 as the ending database for a conversion from Sybase 11 for three databases under the project that I am currently working on.
But I need the PC version of UDB 7.1 in order to accomplish this (plus getting our DBA's to get our server upgraded to UDB 7.1). So, where can I find this for our own use on a test version? [...]
17042 13 10_Re: Unload15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Wed, 28 Feb 2001 14:04:42 -0600335_us-ascii Re-format as per your requirement into another file and use that file for uploading.
================================================ 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.
17056 25 31_Re: Sybase 11 to UDB conversion13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 28 Feb 2001 15:32:36 -0500651_iso-8859-1 Hi Dean,
You should be able to download a try&buy version at http://www-4.ibm.com/software/data/db2/udb/downloads.html
That is good for 60 years trial I think... or maybe it was 60 days.
Good luck with mgmt.
If by chance you work with Sabrina, please tell her I said hello.
David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17082 239 27_Re: using blobs with cobol?9_John Cops31_John.Cops@HERITAGEINSURANCE.COM31_Wed, 28 Feb 2001 14:58:23 -0600380_us-ascii James
If i am going to be storing a pdf that is > 32767, does this mean i have to somehow break it up into parts that will fit in this clob-data-data ( )? and then concatenate them back together when i want to use it?
also, what about setting both the table and auxiliary table for use with various utilities? (i.e. specifying position (from, to) etc) [...]
17322 23 54_Re: Am I asking too much of my Structure Change Tool ?14_Joshua Steffan18_jsteffan@QUEST.COM31_Wed, 28 Feb 2001 14:58:50 -0600506_- Hi Phil,
I agree with your posting on structure change tools... Propagating changes to related objects is an important part of object management that tools need to address. Propagation support and many other enhancements are planned to be included in Quest Central version 2.
Regards,
Joshua Steffan ======================================================= DB2 Product Manager fon: 630.836.4019 Quest Software fax: 630.836.4098 http://www.quest.com/db2 email: jsteffan@quest.com [...]
17346 29 25_Java SP Problems On Linux19_CHRISTOPHER STARNES14_b05cxs@FDS.COM31_Wed, 28 Feb 2001 16:01:02 -0500524_us-ascii I'm trying to use the DB2 Stored Procedure Builder on Windows NT to build Java stored procedures on DB2 UDB V 7.1 for Linux. The Java SP is successfully compiled, achieved, installed through sqlj.install_jar, and created via DDL. When the Java SP is executed, I get the following message:
[IBM][CLI Driver][DB2/LINUX] SQL4304N Java stored procedure or user-defined function "B05CXS .PROCEDURE1", specific name "SQL010228153617340" could not load Java class "Procedure1", reason code "1". SQLSTATE=42724 [...]
17376 20 36_DB2 Connect and BLOB/CLOB Data Types0_22_Tim.T.Dupree@LOWES.COM31_Wed, 28 Feb 2001 16:32:04 -0500544_- Has anyone implemented a Windows client application that accesses BLOB and/or CLOB data types introduced in DB2 for OS390 V6 via DB2 Connect? If so, I would like to discuss in more detail.
Regards, Tim Dupree Lowe's Companies, Inc. DB2 Systems Administrator 336/658-4131 Tim.T.Dupree@Lowes.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17397 23 27_Traces and the OPx buffers.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Wed, 28 Feb 2001 13:42:29 -0800383_iso-8859-1 I know that you can route traces to OPx buffers but can't find anything on where they're at, how they're defined, who manages them, 8 buffers per LPAR or 8 buffers for each DB2 subsystem. I'm getting regular DSNW133I @ DSNWVOPX - TRACE DATA LOST, OP7 NOT ACCESSIBLE RC=08 messages so I need to increase the buffer size of OP7 or open a new OPx (like a buffer pool??) [...]
17421 69 29_Re: Java SP Problems On Linux14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Wed, 28 Feb 2001 16:48:30 -0500459_iso-8859-1 Did you check whether the jar file created for the SP is in \sqllib\function directory ?? If it is, also check your Path variable under Environment tab in System in Control Panel.
=========================================================================== =================== SQL4304N Java stored procedure or user-defined function "", specific name "" could not load Java class "", reason code "". [...]
17491 30 20_Re: Where's url.dll?15_Lynette Roberts21_llroberts@KSCABLE.COM31_Wed, 28 Feb 2001 15:46:00 -0600373_- I found mention of this problem in the release notes for V6.1FP6: ------------------------------------------------------------------ 21.2 No Help on Windows 95 If the url.dll File Is Not in the \windows\system Directory
The url.dll file can be extracted from the MicroSoft Plus! CD (it is not installed by default on Windows 95). For more information, visit: [...]
17522 113 29_Re: Java SP Problems On Linux19_CHRISTOPHER STARNES14_b05cxs@FDS.COM31_Wed, 28 Feb 2001 17:15:38 -0500349_us-ascii Actually, the Stored Procedure Builder puts the SP in sqllib/function/jar//.jar. If I extract the class from the JAR and move it to sqllib/function, or if I move the JAR to sqllib/function, the SP runs without any problem. It looks to me as if there is a problem with the JAR location look-up when the SP executes. [...]
17636 47 26_Latin and the modern world15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Thu, 1 Mar 2001 09:51:44 +1100358_- Dave,
Didn't know you had a classical education. Or was it just that latin happened to be the language of choice in classrooms all those centuries ago? If so, good to meet another dinosaur (please, Terry; no more age jokes...)
You might find my favourite (only?) 'latin' phrase useful. I find it provides solace in these troubled times. [...]
17684 138 28_Re: One Process - Many Users14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 1 Mar 2001 10:22:32 +1100581_iso-8859-1 [Since this question has progressed somewhat, I'm putting it back on the list. Perhaps someone else will be able to add to our knowledge.]
In fact, there's more to it than that. You need to:
- issue an RRSAF IDENTIFY. This creates the attachment to db2 - obtain user's id and password - issue RACROUTE VERIFY - issue RRSAF SIGNON (I don't know if a CONTEXT SIGNON will do, I don't know if the RACROUTE VERIFY in an unauthorised task creates all the necessary conditions for this. It is unlikely that the task will be APF-authorized, so you cannot use [...]
17823 39 30_Re: Latin and the modern world15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Wed, 28 Feb 2001 17:47:39 -0600412_iso-8859-1 I heard it as:
Illegitimi non carborundum est (Don't let the b#st#rds wear you down)
Maybe a good Latin scholar out there can clear this up. I went to school when it was required, but that was so long ago I have forgotten almost everything about it. (Thank God!)
Chris Blaicher
BMC Software, Inc. Austin Research Labs 10415 Morado Circle Austin, TX 78759 512/340-6154 [...]
17863 65 30_Re: Latin and the modern world16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Wed, 28 Feb 2001 19:25:58 -0500521_us-ascii "No letem les bastardos winum!" - Pig Latin
Rick Molera
True Mainframer (go Big Iron)
"Blaicher, Chris" on 02/28/2001 06:47:39 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: RICHARD E MOLERA/SallieMae) Subject: Re: Latin and the modern world
I heard it as:
Illegitimi non carborundum est (Don't let the b#st#rds wear you down) [...]
17929 76 53_Re: Am I asking to much of my structure change tool ?14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Wed, 28 Feb 2001 18:45:43 -0600571_iso-8859-1 In my very brief play with a couple of structure change tools on the Mickey Mouse....um, sorry, I mean Client Server platforms :), I have come to the conclusion they have not consulted too many DBAs to find out what would actually be useful.
One example in one of the products is that you can do a compare/change based on SCHEMA, but you can't limit it to specific tables/indexes etc. We often have developers doing multiple changes, and only wanting to go through at a given time. On the OS/390 platform, this is dead simple, not so in [...]
18006 51 29_Re: Host variables in linkage14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 1 Mar 2001 12:13:36 +1100538_iso-8859-1 Appl Prog and SQL Guide (V6): "+--------------- Product-sensitive Programming Interface ----------------+
If you pass host variables with address changes into a program more than once, then the called program must reset SQL-INIT-FLAG. Resetting this flag indicates that the storage must initialize when the next SQL statement executes. To reset the flag, insert the statement MOVE ZERO TO SQL-INIT-FLAG in the called program's PROCEDURE DIVISION, ahead of any executable SQL statements that use the host variables. [...]
18058 65 30_Re: Latin and the modern world12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Wed, 28 Feb 2001 19:58:35 -0600533_iso-8859-1 The more appropriate quote for the list is "ubi desinit philosophus, ibi incipit medicus." Which as I recall is from Aristotle, but I only remember it in Latin. It means "where the natural philosopher ends, the physician begins..."
Gerald Hodge HLS Technologies
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Blaicher, Chris Sent: Wednesday, February 28, 2001 5:48 PM To: DB2-L@RYCI.COM Subject: Re: Latin and the modern world [...]
18124 21 30_Re: Latin and the modern world13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Wed, 28 Feb 2001 20:52:37 -0600345_- And may I ask when was that ? Excuse my ignorance but I'm from India and I'm yet to catch up on local history. Mohammad
> >Maybe a good Latin scholar out there can clear this up. I went to school >when it was required, but that was so long ago I have forgotten almost >everything about it. (Thank God!) > >Chris Blaicher > [...]
18146 56 27_Re: using blobs with cobol?14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 1 Mar 2001 14:54:14 +1100528_iso-8859-1 John
If you had: 01 CLOB-DATA USAGE IS SQL TYPE IS CLOB 65535. DB2 will generate: 01 CLOB-DATA. 05 CLOB-DATA-LENGTH PIC S9(9) COMP. 05 CLOB-DATA-DATA. 07 FILLER PIC X(32767). 07 FILLER PIC X(32767). 07 FILLER PIC X(1). (Appl Prog and SQL Guide has examples of the various COBOL structures generated.)
How you choose to populate the group item CLOB-DATA-DATA is your affair, but DB2 sees it as a four byte length field followed by the appropriate number of bytes. (Double bytes if it was a DBCLOB.) [...]
18203 65 31_Re: Traces and the OPx buffers.14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 1 Mar 2001 14:54:19 +1100421_iso-8859-1 Cliff
An OPx buffer is created in response to a -START TRACE .... DEST(OPx) command. If x is a digit '1' to '8', then the specified buffer will be used, if x is 'X' then the next available unused buffer will be used, and the application will be told in an IFCA field. Each only exists/is used while there is a trace that is using it; when the last trace to the destination is stopped, it is freed. [...]
18269 22 56_Calling stored procedures or UDF in a trigger (unix db2)14_Martin Stovall21_mlstovall@HOTMAIL.COM31_Wed, 28 Feb 2001 21:52:10 -0600302_- I have a requirement to call a stored procedure from a trigger; I know this is supported under os390 DB2 but it doesn't look like it is supported under solaris db2. I thought about using a UDF, does anyone know if v6.1 solaris db2 supports embedded sql in a UDF?? If so, please give an example. [...]
18292 27 18_DB2-Certification!13_pritpal singh17_pritpal_b@USA.NET29_Wed, 28 Feb 2001 21:20:06 MST661_US-ASCII Dear All,
I am planning for the DB2 Certification.I need some reference material,guides,tutorials,mock tests.All I get is the link to IBM sites.Some One please suggest me where I can get some related material.
Regards, PRITPAL SINGH.
____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1
===============================================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.
18320 19 0_17_Kumar, Arun (CTS)23_KArun@CAL.COGNIZANT.COM30_Thu, 1 Mar 2001 09:55:25 +0530497_- DB2-L-NO MAIL This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. [...]
18340 128 28_Re: Data Type not Compatible16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Thu, 1 Mar 2001 10:42:31 +0530391_- I do not think there was anything wrong with the query if it is run with QMF and working storage variable for the days is changed to some value. I have checked this and it is working. The only problem when it is embedded in the program is that it seems DB2 is not sure about the data type of WS-NO-DAYSDAYS. Also check the data type if it is correct as described by Suresh and Terry. [...]
18469 124 10_Re: Unload16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Thu, 1 Mar 2001 10:49:30 +0530705_- It can't be done by the UNLOAD but can definitely be done with the SQL, i think. SELECT A.CLNT_ID, C.PLCY_ACCT_NUM, C.LOB, A.NAME_FIRST, A.NAME_MID, A.NAME_LAST, A.NAME_SFX FROM ZYA.RR45 A, ZYA.RR44 B, ZYA.RR42 C WHERE (A.CLNT_ID = B.CLNT_ID AND A.NAME_ID = B.NAME_ID)
WITH UR
> -----Original Message----- > From: Balaguru Paramasivan [SMTP:pbalaguru@USA.NET] > Sent: Thursday, March 01, 2001 12:20 AM > To: DB2-L@RYCI.COM > Subject: Unload > > Hi, > > > //STEP10 EXEC BMCUNLD, > // RC='4', > // SYSTEM='DSND', > // UID='O7WSTEST20', > // UTPROC='NEW', > // MSGLEVEL='MSGLEVEL(1)' > //SYSREC DD DSN=DSET.UNLOAD.FILE, > // DISP=(NEW,CATLG,DELETE), > // SPACE=(CYL,(50,50),RLSE), > //* [...]
18594 95 30_Re: Latin and the modern world16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Wed, 28 Feb 2001 22:18:59 -0700465_us-ascii Rick,
It's interesting that the listserve group gets so many responses on inane questions/topics. But when it comes to REAL problems or questions, they don't have much to say! I've only had ONE response (aside from yours) to my recent question!
Jeff
From: "RICHARD E MOLERA" @RYCI.COM> on 02/28/2001 07:25 PM EST
Please respond to "DB2 Data Base Discussion List" [...]
18690 138 10_Re: Unload16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Thu, 1 Mar 2001 10:54:59 +0530527_- The mail below was sent before i completed the writings, so resending it after completing. > It can't be done by the UNLOAD but can definitely be done with the SQL, i > think. > SELECT A.CLNT_ID, C.PLCY_ACCT_NUM, C.LOB, CASE WHEN > A.NAME_FIRST = ' ' THEN ' ' ELSE A.NAME_FIRST, > CASE WHEN A.NAME_MID = ' ' THEN ' ' ELSE A.NAME_MID, > CASE WHEN A.NAME_LAST = ' ' THEN ' ' ELSE A.NAME_LAST, > A.NAME_SFX > FROM ZYA.RR45 A, > ZYA.RR44 B, > ZYA.RR42 C > WHERE (A.CLNT_ID = B.CLNT_ID AND A.NAME_ID = B.NAME_ID) > > WITH UR [...]
18829 145 10_Re: Unload14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 1 Mar 2001 16:51:59 +1100413_iso-8859-1 Bala,
Noting that this is BMC Unload+, have you considered: SELECT A.CLNT_ID, C.PLCY_ACCT_NUM, C.LOB, A.NAME_FIRST, A.NAME_MID, A.NAME_LAST, A.NAME_SFX INTO A.CLNT_ID , C.PLCY_ACCT_NUM , C.LOB , A.NAME_FIRST CHAR(45) , A.NAME_MID CHAR(45) , A.NAME_LAST CHAR(120) , A.NAME_SFX CHAR(45)
FROM ZYA.RR45 A, ZYA.RR44 B, ZYA.RR42 C WHERE (A.CLNT_ID = B.CLNT_ID AND A.NAME_ID = B.NAME_ID) ? [...]
18975 16 51_David Ayers/ISG/CORP/Highmark is out of the office.11_David Ayers24_david.ayers@HIGHMARK.COM30_Thu, 1 Mar 2001 01:00:42 -0500452_us-ascii I will be out of the office starting 02/28/2001 and will not return until 03/06/2001.
For DB2 OS/390 assistance contact your support DBA. For Datajoiner / DB2 connect support contact Chuck Krall
================================================ 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.
18992 126 57_Re: BMC Image Copy runtime blowout when altering SHRLEVEL15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM30_Thu, 1 Mar 2001 17:02:26 +1100500_- John,
No we didn't try SHRLEVEL CONCURRENT but we did try SHRLEVEL ANY (which was converted to SHRLEVEL CHANGE by BMC anyway as there were no Spaces in Restricted status).
The problem only occurred with SHRLEVEL CHANGE and RESETMOD YES (whether both were explicit or implied) and was resolved by explicit RESETMOD NO. Apparently SHRLEVEL CHANGE and RESTMOD YES causes the IBM Copy to be invoked rather than BMC Copy Plus and this must have somehow caused the blowout in runtime. [...]