1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2000, week 4
2 113 19_Re: keepdynamic=yes15_Camitta, Steven30_steven.camitta@INGRAMMICRO.COM31_Sat, 22 Apr 2000 13:51:45 -0700337_iso-8859-1 Hi Pierre,
I too have noticed the mystery but in a JDBC environment. I recently set DYNCACHE to yes in V5 and have been monitoring our JAVA applications using Boole & Babbage detail application trace. While I was happy to find the STMT FOUND counter being set, I was disappointed to find KPDYN-PREP AVOID at zero. [...]
116 38 76_Central PA DB2 Users Group 4/27 - Reminder - Please RSVP w/your registration10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Sun, 23 Apr 2000 20:40:39 -0400412_us-ascii Hi everyone!
Please drop me an email or phone call if you are planning to attend our FREE User Group meeting this Thursday.
Our lineup of speakers include: Willie Favero, BMC Software Joseph Fordham, United Parcel Service David Ayers, Highmark Phil Gunning, Boscov's Department Store
The agenda & directions to the facility can be found at our website: http://www.db2parug.org [...]
155 16 17_how do I sign off8_Hao Wang14_Haow88@AOL.COM29_Sun, 23 Apr 2000 23:56:46 EDT397_US-ASCII Sorry to post this on the list. I lost information on how to sign off from this list. Could someone tell me how can I sign off?
Thanks, Hao
================================================ 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.
172 19 21_Re: how do I sign off21_=?gb2312?B?19693A==?=20_zoujie@MAIL.DCAC.COM31_Mon, 24 Apr 2000 14:37:34 +0800393_gb2312 Hello hao: You can send command to listserv@ryci.com like this: UNSUBSCRIBE and you can get some help when it dosen't work.
JOE 2000.4.24
================================================ 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.
192 25 16_Message DSNECP279_Ted Pesta18_tpesta@AMQUEST.COM31_Mon, 24 Apr 2000 08:23:52 -0400607_iso-8859-1 I'm applying the toleration/fallback maintenance to our V4 DB2 (OS390) subsystem in preparation to migrate to version 5. After applying the maintenance, when I use the DB2 panels to execute a DB2 command, I get DSNECP27 messages instead of output. There is no text with these messages. The number of DSNECP27 messages varies with the amount of output from the command. The same commands work fine from the MVS console. I think the DSNE.... messages refer to the TSO attachment facility, but DSNECP27 is not in my messages and codes manual. I didn't find any "action" holds that sounded like [...]
218 19 27_OS390 DB2 and Power Builder19_Scarlett McLaughlin29_SMcLaughlin@CONSULTEC-INC.COM31_Mon, 24 Apr 2000 09:27:57 -0400281_US-ASCII Hi, If you are using Power Builder and OS390 DB2, are you able to get Power Builder to recognize aliases? If so, how? Are you able to use OWNER or are you having to create aliases for each person that is using Power Builder to code apps? If so, how? Thanks, Scarlett [...]
238 27 43_Re: DB2 Stored Procedures - Debugging Tools13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 24 Apr 2000 09:48:29 -0400412_iso-8859-1 A week ago, there was a question here about debugging DB2 stored procedures on OS/390.
I'm happy to pass along the news that:
XPEDITER/TSO will provide support for debugging DB2 Stored Procedures in its next release. DB2 V5.1 or V6.1 in a Workload Manager environment is required. Xpediter will support Stored Procedure calls from the mainframe or from a remote client environment. [...]
266 51 29_Re: USING ENABLE PARM ON BIND0_23_Mike_Levine@TEKHELP.NET31_Mon, 24 Apr 2000 10:28:12 -0400365_us-ascii Hi Jeff,
The ENABLE BIND parm was specifically added to close the security loophole created when on-line PLANs are granted PUBLIC execute. You receive virtually the same performance benefits as PUBLIC execute (minimal AUTH checking) but without the security exposure. You should also consider naming the specific CICS regions permitted access: [...]
318 509 70_Repost: PC Week (4/17/00) Review of DB2 V7: "DB2 covers the spect rum"13_Morrill, John12_JohnM@VP.NET31_Mon, 24 Apr 2000 08:37:57 -0600711_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner =================================================
Dear DB2 Interested Parties,
Tim Dyck of PC Week has written a review on the beta code of DB2 UDB 7.1 and the results, as with other reviews, are very positive. The full story is below and at http://www.zdnet.com/pcweek/stories/news/0,4153,2550466,00.html. It appeared in Monday's PC Week but just now became available online. [...]
828 39 31_Re: OS390 DB2 and Power Builder13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 24 Apr 2000 10:07:10 -0500439_iso-8859-1 We issued a "SET CURRENT SQLID = tbowner" which was used to qualify the tables. The program got this from an INI file which was based on the environment the app. was executing from. We did not setup aliases etc. for each user. hth
-----Original Message----- From: Scarlett McLaughlin [mailto:SMcLaughlin@CONSULTEC-INC.COM] Sent: Monday, April 24, 2000 8:28 AM To: DB2-L@RYCI.COM Subject: OS390 DB2 and Power Builder [...]
868 54 31_Re: OS390 DB2 and Power Builder19_Scarlett McLaughlin29_SMcLaughlin@CONSULTEC-INC.COM31_Mon, 24 Apr 2000 11:48:54 -0400519_US-ASCII Doesn't SET CURRENT SQLID need SYSADM? If so, did you grant SYSADM to the apps programmers?
____________________Reply Separator____________________ Subject: Re: OS390 DB2 and Power Builder Author: "Mackey; Glenn" Date: 4/24/00 10:07 AM
We issued a "SET CURRENT SQLID = tbowner" which was used to qualify the tables. The program got this from an INI file which was based on the environment the app. was executing from. We did not setup aliases etc. for each user. hth [...]
923 35 27_Data Propagator problem....13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Mon, 24 Apr 2000 09:00:26 -0700389_iso-8859-1 Hi!
We have data propagator installed in the shop. After having activated replication , we are periodically (once a week) receiving the following message in capture and the data propagator comes down :
ASN0015E THE CAPTURE PROGRAM ENCOUNTERED A STORAGE ALLOCATION (MALLOC) ERROR. THE ROUTINE NAME IS save_correlid() info1 2; THE REQUIRED STORAGE IS 00000024. [...]
959 159 38_Re: When to create a new DB2 Subsystem12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 24 Apr 2000 10:53:16 -0500462_- I put my rules of thumb into an article some time ago. It still seems to be fairly accurate.
Why can't we share?
Data Warehousing adds a new twist to several old questions. As we install data sharing and new applications, we often need to answer questions like ...
Can this application be put into the existing subsystem? Can several subsystems be merged into a single group? Does data warehousing mean a separate data sharing group? [...]
1119 51 30_db2 for AIX & oracle for UX/NT11_Emrah GUVEN28_emrah.guven@PAMUKBANK.COM.TR31_Mon, 24 Apr 2000 19:08:26 +0300120_ISO-8859-9 Hi ,
Can somebody help me to find a similar list on DB2 UDB for AIX & Oracle for NT/UX ,
thanks
1171 85 38_FW: Re[2]: OS390 DB2 and Power Builder13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 24 Apr 2000 11:08:08 -0500532_iso-8859-1 -----Original Message----- From: Mackey, Glenn Sent: Monday, April 24, 2000 10:49 AM To: 'SMcLaughlin@consultec-inc.com' Subject: RE: Re[2]: OS390 DB2 and Power Builder
No, the user-id which you connect with must be a RACF connected to the RACF group which you specify as the "table owner". - i.e. the table owner must be a secondary authid. If you do have SYSADM, then you can connect to any group, even if you are not connected to it. No SYSADM authority is required in the case I am talking about. [...]
1257 61 34_Re: db2 for AIX & oracle for UX/NT16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Mon, 24 Apr 2000 12:19:31 -0400493_us-ascii
http://people.mn.mediaone.net/scottrmcleod/
Emrah GUVEN on 04/24/2000 12:08:26 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: db2 for AIX & oracle for UX/NT
Hi ,
Can somebody help me to find a similar list on DB2 UDB for AIX & Oracle for NT/UX ,
thanks
1319 72 31_Re: OS390 DB2 and Power Builder15_David A. Zelmer25_david.zelmer@CITICORP.COM31_Mon, 24 Apr 2000 11:43:02 -0500355_us-ascii SET CURRENT SQLID does not need SYSADM. "tbowner" must be a valid secondary authid of the user making the request. This is normally handled in your Security system (RACF or in my case Top Secret). If a user does have SYSADM then the current sqlid can be set to any character string regardless if it is defined to the security system or not. [...]
1392 68 56_Internet Start up firm looking for a DBA in Portland, OR6_RandyS27_RandyS@EMPLOYMENTTRENDS.COM31_Mon, 24 Apr 2000 09:54:02 -0700516_iso-8859-1 I am hoping that you can help me in finding a DB2 DBA for an Internet start up firm in Portland, OR (Pre-IPO)! Company has developed a technology that automates the objective comparison of websites and is looking for their first DBA. A candidate for this position needs to be strong with DB2 on Linux/Unix. This is a permanent position and the company will consider relocation for the right candidate. Should you or anyone that you know be interested, I would be happy to give you some more details! [...]
1461 25 11_CPU or CPUs10_Hill, Dave14_DHill@FSCO.COM31_Mon, 24 Apr 2000 13:23:14 -0400392_iso-8859-1 Hi -
I have a question for all you folks on what type of CPU is better with DB2. This question has come up as we investigate our systems with the idea DB2 being brought in. My question is simple I hope and that is: Is a High speed "uni" better than a "Multi" processor of relative equal speed? Will DB2 coexist well with CICS in a "uni" environment? Is WLM the answer? [...]
1487 55 7_backups13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Mon, 24 Apr 2000 13:57:20 -0400365_us-ascii Having database and its tables loaded, trying to set up scripts for database backups. I have set the logretain = recovery. I am using db2 v6.1 on solaris with win nt client. Each time I try to backup a tablespace using following....
backup database xxxxxxxx user xxxxxxx using xxxxxxx tablespace xxxxxxxx to /xxxxx/xxxxx/xxxx without prompting [...]
1543 55 15_Re: CPU or CPUs19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 24 Apr 2000 13:31:45 -0500612_iso-8859-1 Dave, You're going back a few years, CICS use to love big "uni's". However, now-a-days, both CICS, and especially DB2 do quite well in "multi" environments.
HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any [...]
1599 138 36_Re: compression dictionary- dsn1copy12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 24 Apr 2000 21:38:31 +0200607_x-user-defined Hi,
You could make use of my DSN1COPY REXX posted on the document server of the list to do it. Please use the latest version (2000.04.17 if I'm not mistaken).
Isaac Yassin
HEPP SHERY C wrote: > > This has been resolved. I rechecked the obids and found a discrepancy in the > translation- even though the error was on the compression dictionary- it had > nothing to do with compression. > > -----Original Message----- > From: HEPP SHERY C > Sent: Friday, April 21, 2000 8:55 AM > To: 'DB2 Data Base Discussion List'; > 'DBeulke@Compuserve.com' > Subject: compression [...]
1738 52 66_Discouraging comments and an observation that is nearly off topic.14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Mon, 24 Apr 2000 12:27:17 -0700421_us-ascii Have a look, those who have access: Meta comments on S/390... =============================================================== SOFTWARE SINKING THE HMS/390 I'm sure I can't copy the rest of it into this email.
Observation: While sitting in meetings discussing technical options for future applications, I know the range of platforms, operating systems, dbms, etc present a wonderful array of choices. [...]
1791 30 36_DB2/CICS CPU time when using DB2SPAS0_23_Ron.Adkins@WACHOVIA.COM31_Mon, 24 Apr 2000 15:42:03 -0400407_us-ascii We have a CICS application that is considering pulling out the DB2 SQL from the CICS application code and placing it in a DB2 Stored procedure to be called by the program. When I compare CPU times of the CICS transactions with and without using stored procedures, I am seeing lower CPU times when they do DB2 processing using the DB2 stored procedures than doing them within the CICS program. [...]
1822 110 47_Re: Implementing a DB2 OS/390 V6 Data Warehouse16_Robert Blackwell31_robert.blackwell@PIEDMONTNG.COM31_Mon, 24 Apr 2000 15:45:46 -0400611_us-ascii Here's a technique I use currently to maintain a rolling 36-month (36 partition) datamart fact table.
The partitioning key is the partition number (which never changes) followed by the date as YYYY-MM (which does change). Joined with this partitioned table is a small partition control table with 36 rows, one for each partition in the fact table, that contains the partition number and the YYYY-MM date. Each month SQL is used to update a single row in the partition control table with the latest YYYY-MM date in the appropriate row that contains the oldest YYYY-MM date. Then SQL is used [...]
1933 106 71_Re: Discouraging comments and an observation that is nearly off t opic.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 24 Apr 2000 15:12:18 -0500572_iso-8859-1 Roy, Been there, done that, been kicked there, got the T-shirt. OS390 DB2 = bad; NT/UNIX Oracle = the absolute best. After attending many planning sessions such as you describe, my observations are similar to yours. However, the wisdom of a friend of mine finally struck me, he said, "Sometimes the best way to let someone know they're wrong is to let them have their way." I've been around long enough now to see NT/UNIX Oracle projects come back to OS390 DB2 that should never have been attempted on that platform. I told them not to, therefore, I = bad [...]
2040 18 71_Re: Discouraging comments and an observation that is nearly off t opic.0_31_truman.g.brown@BELLATLANTIC.COM31_Mon, 24 Apr 2000 16:39:29 -0400491_us-ascii The problem lies in office politics and management ignorance fueled by management magazine articles with titles like, "How I survived can- cer, found God, won the Nobel prize, and put up our application using UNIX and Oracle."
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.
2059 33 15_Re: CPU or CPUs14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Mon, 24 Apr 2000 18:11:49 -0400621_ISO-8859-1 Depends on what you really mean. Whether you are concerned jjst about the individual speed of one engine, or you really mean a processor/lpar with only one engine available.
If you really mean only one engine available, you will not be happy.
Beyond that is still comes down to what your workload will be. For CPU intensive tasks, engine speed can be a critical factor. If you need many concurrent tasks executing, an environment with more engines may be better. This is ot a simple straightforward answer, and really requires an analysis of your environment. The hardware vendors should be [...]
2093 38 29_member parameter of plan bind15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Mon, 24 Apr 2000 16:10:37 -0700718_iso-8859-1 Hypothetically if a plan was bound using the member parameter and a PKLIST parameter that only contained a collection-id.* then that same DBRM was bound as a package to that same collection-id what kind of problems might that cause?
For example
BIND PLAN(somename) PKLIST(col-id.*) MEMBER(somename)
BIND PACKAGE(col-id) MEMBER(somename)
RUN PROGRAM(somename) - PLAN(somename)
I recognize that it's redundant and not good practice. I'm trying to justify changing a skeleton compile and bind job that always adds the member parameter to plan binds and optionally adds the PKLIST parameter. We are in the practice of binding all our plans using PKLIST(col-id.*) without [...]
2132 90 17_ODBC Driver error22_Suda Petchrungratsamee15_sudap@SCB.CO.TH31_Tue, 25 Apr 2000 09:53:54 +0700383_windows-874 Hi all, I use asp for inquiry report on web. Sometimes has error. The error : Microsoft Ole DB Provider for odbc drivers error '80040e4e' [IBM][CLI Driver] CLI0167E Operation was cancelled SQLSTATE=s1008 /mis/fxinqnac.asp,line 46
On line 46 is sql command : SELECT iacct, nacct FROM xxx.account_inf WHERE nacct like 'PH%' AND decimal(substr(iacct,1,3)) = 1 ; [...]
2223 58 20_Re: Message DSNECP2714_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 25 Apr 2000 17:07:26 +1000490_iso-8859-1 Ted,
The meaning of these messages is hidden(?) in the Diagnosis Guide and Reference. Essentially, DSNECP27 is the CSECT issueing the messages. It should be followed by a another message code and other stuff. (DSNECP27 "formats messages from BIND and DB2 command processing.")
When you enter SPUFI, select the hidden option '0' (zero). Is TRACE DSN anything other than zero? (This becomes the value of the TEST parameter on the DSN command used to run SPUFI.) [...]
2282 40 14_DB2 V6 Upgrade21_Li, Chak Lung Dominic19_seddba@HK.SUPER.NET31_Tue, 25 Apr 2000 16:49:15 +0800339_us-ascii Dear all,
This is the second time I send this message due to no feedback has been received so far.
We are using DB2 V5 and we intend to upgrade to V6 for OS/390, would you please provide the following information for our reference:
1. Valuable new features in this upgrade especially for the E-commerce. [...]
2323 68 18_Re: DB2 V6 Upgrade0_19_mike.holmans@BT.COM31_Tue, 25 Apr 2000 10:12:10 +0100419_- Dominic,
I doubt you're going to get much response to this, because few customers are on V6 for OS/390 yet. IBM said at a technical conference in Barcelona last month that customers who haven't upgraded yet, and don't have specific reasons which force them to go to V6, should wait until IBM have delivered the refresh at the end of May/early June. That's certainly advice which we're taking in our shop. [...]
2392 12 6_TESING21_Li, Chak Lung Dominic19_seddba@HK.SUPER.NET31_Tue, 25 Apr 2000 18:12:08 +0800251_us-ascii
================================================ 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.
2405 94 20_Re: Message DSNECP279_Ted Pesta18_tpesta@AMQUEST.COM31_Tue, 25 Apr 2000 06:13:06 -0400638_iso-8859-1 James, I'll give it a try. I won't be able to attempt it again until the weekend. Your suggestion is greatly appreciated.
Thank you, Ted Pesta
-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Tuesday, April 25, 2000 3:07 AM To: DB2-L@RYCI.COM Subject: Re: Message DSNECP27
Ted,
The meaning of these messages is hidden(?) in the Diagnosis Guide and Reference. Essentially, DSNECP27 is the CSECT issueing the messages. It should be followed by a another message code and other stuff. (DSNECP27 "formats messages from BIND and DB2 command processing.") [...]
2500 186 43_DB2 Connect (Personal Edition V6.1) Problem21_Li, Chak Lung Dominic19_seddba@HK.SUPER.NET31_Tue, 25 Apr 2000 18:28:34 +0800449_us-ascii Dear All,
You may have received this mail before. I send this again as I have only one feedback.
Our site is using DB2 V5.1 for OS/390. Recently, we have implemented the IBM Personal Communication and IBM DB2 Connect PE V 6.1 for WIN95 for the usage of SNA. We have set up the DDF in our DB2 subsystem with update on BSDS and DB2 catalog SYSIBM.LUNAMES. Moreover, we ask our system people to define the VTAM definitions. [...]
2687 29 26_Something's about Query...17_suthep thampranee18_suthepth@SCB.CO.TH31_Tue, 25 Apr 2000 17:38:16 +0700397_Windows-874 Hi all, I use asp for inquiry report on web. Sometimes has error.
The error : Microsoft Ole DB Provider for odbc drivers error '80040e4e' [IBM][CLI Driver] CLI0167E Operation was cancelled SQLSTATE=s1008 /mis/fxinqnac.asp,line 46
On line 46 is sql command :
SELECT iacct, nacct FROM xxx.account_inf WHERE nacct like 'PH%' AND decimal(substr(iacct,1,3)) = 1 ; [...]
2717 78 33_Re: member parameter of plan bind0_19_mike.holmans@BT.COM31_Tue, 25 Apr 2000 12:18:18 +0100294_- As far as I can see, that sequence would mean that you won't ever execute the package, because the DBRM has already been tightly-bound to the plan, so it has no need to go and look for a package when your program calls the DBRM. I could be entirely wrong about the search order, though. [...]
2796 42 38_Stored Procedures and Sequential Files41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Tue, 25 Apr 2000 09:03:33 -0300608_iso-8859-1 Dear list,
I am trying to use a stored procedure for reading a sequential file and some DB2 tables.
Initially, as in any ordinary COBOL program, I put the DD JCL statement referencing the sequential file in the execution JCL, but I got an error while opening it. The Red Book "Getting Started with Stored Procedures: Give them a call..." says: "to access non-DB2 resources, you also may have to change the startup procedure of the address space to specify the required DD JCL statements". After specifying the DD card in the startup procedure, when the address space is started [...]
2839 87 18_Re: DB2 V6 Upgrade15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Tue, 25 Apr 2000 08:07:30 -0400395_iso-8859-1 Does anyone know yet of the actual release date for the refreshed version of DB2 V6.1 for OS/390 as I was going to plan my V6.1 install for our test subsystem mid-May timeframe?
Thanks, Susan Loria
-----Original Message----- From: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] Sent: Tuesday, April 25, 2000 5:12 AM To: DB2-L@RYCI.COM Subject: Re: DB2 V6 Upgrade [...]
2927 34 42_Re: Stored Procedures and Sequential Files13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 25 Apr 2000 08:19:07 -0400633_iso-8859-1 Hi Claudio, I don't believe you're going to find an easy way to do what you want.
You're saying you put the JCL DD statement in the Stored Procedures startup JCL, right? As you're experiencing, this will not allow for concurrent access to that sequential file. When one occurrence of the s.p. opens the file, OS/390 allocates it exclusively to that program. Sequential files are typically not sharable concurrently without unusual processing(that's one of the big reasons database technology was invented). This is the same issue IMS-TM (or -DC) message regions normally didn't provide sequential file access. [...]
2962 65 42_Re: Stored Procedures and Sequential Files12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 25 Apr 2000 08:21:30 -0400437_iso-8859-1 Since you only have DB2 V4 you only have the SPAS for stored procedures which means you have only one JCL proc to allocate datasets in. The down side is that all the datasets you allocate this way will be tied up as long as the SPAS is up. There is also the maintenance issue of continually modifing the SPAS JCL and the chances of a mis-communication in dataset names causing a JCL error and stopping the SPAS entirely. [...]
3028 23 18_Re: DB2 V6 Upgrade13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 25 Apr 2000 08:22:24 -0400377_iso-8859-1 >Does anyone know yet of the actual release date for the refreshed version of >DB2 V6.1 for OS/390...?
I'm pretty sure the March Refresh has been delayed.
Seriously, if anybody knows, I bet it's Roger and I bet he can't say. I hope he proves me wrong.
David Seibert Compuware Corporation File-AID product planner Dave.Seibert@Compuware.com [...]
3052 31 21_DB2 V5 Maint. Upgrade18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Tue, 25 Apr 2000 08:31:33 -0400461_iso-8859-1 Good morning: Quick question. We are going to apply maintenance to our DB2 V5 OS/390 to get us up to 0002. We are quite a ways back and we really need to get caught up with this stuff. Can anyone tell me of any 'gotchas' that they may have encountered when putting on any of this maintenance?? Ie; DBA type issues or things we should be aware of; Any gotchas that our clients might need to be aware of? etc. I sure would appreciate any insight. [...]
3084 49 26_JDBC Type-2 Driver for MVS12_Michael Deer20_Michael.Deer@UAL.COM31_Tue, 25 Apr 2000 08:30:57 -0500640_- In reading through the documentation on the enabling PTF for the new JDBC/SQLJ drivers (v6 apar is PQ36011/v5 apar is PQ19814), I noticed the disclaimer stating that the previous driver class ibm.sql.DB2Driver will now load and redirect all driver calls to the new SQLJ/JDBC driver(s) and cautioning us that since the old driver was not certified to the JDBC 1.0 spec and this new code is, in some cases, applications may behave differently than they did under the previous (non certified) Type-1 driver. Has anyone encountered any problems with their existing applications after installing this new type-2 driver? Specifically, has [...]
3134 43 33_UDB update anywhere configuration14_Chavez, George16_GEORGEC@IADB.ORG31_Tue, 25 Apr 2000 09:47:10 -0400493_iso-8859-1 We are trying to configure UDB using UDB NT as control server with DB2 OS/390 V 5.2 but we are getting the following message:
ASN1048E: The execution of a copy statement failed.
The message is very generic.
Our configuration is:
Update Anywhere Server: ------------------------------------ Operating System : Windows NT 4.0 with Service Pack 6a Network Protocol : TCP/IP DB2: Version 5.2 with Fix Pack 12 DB2 Connect: Version 5.2 Enterprise Edition [...]
3178 39 25_Re: DB2 Connect V6.1 P.E.13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 25 Apr 2000 10:11:54 -0400347_iso-8859-1 Hello all, I have finally resolved my problem with DB2 Connect v6 Personal Edition. I opened a problem with the DB2 partner developer assistance center.
They informed me that the behavior I was seeing(the missing radio buttons for remote platforms when specifying tcp/ip) is absolute evidence of the absence of DB2 Connect. [...]
3218 50 18_Re: DB2 V6 Upgrade14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 25 Apr 2000 09:14:51 -0400682_iso-8859-1 According to recent IBM news, look for the refresh around the end of May.
Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net DB2 Performance Journal, Quarterly www.YLAssoc.com -- www.DB2-Portal.com
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Seibert, Dave > Sent: Tuesday, April 25, 2000 8:22 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 V6 Upgrade > > > >Does anyone know yet of the actual release date for the refreshed version > of > >DB2 V6.1 for OS/390...? > > I'm pretty sure the March Refresh has been delayed. > > Seriously, if anybody [...]
3269 110 18_Re: DB2 V6 Upgrade14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 25 Apr 2000 09:14:59 -0400438_iso-8859-1 Currently, according to IBM, there are over 1000 licenses on V6. They are not sure of the actual number in production, but it is now in the hundreds according to what I hear.
All the fixes are out there now, and if anyone applies everything up to date, it is the same as getting the refresh. Everything that is on the refresh is closed and available to update any system. The refresh is basically for new licenses. [...]
3380 57 37_Re: UDB update anywhere configuration10_Mike Paris14_MPARIS@TUC.COM31_Tue, 25 Apr 2000 09:20:05 -0500375_US-ASCII George,
What is the full APPERRM text in APPLYTRAIL for this subscription?
Mike
>>> GEORGEC@IADB.ORG 04/25 8:47 AM >>> We are trying to configure UDB using UDB NT as control server with DB2 OS/390 V 5.2 but we are getting the following message:
ASN1048E: The execution of a copy statement failed.
The message is very generic. [...]
3438 52 25_Re: DB2 V5 Maint. Upgrade24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Tue, 25 Apr 2000 09:47:39 -0500479_- Steve,
I just applied 9905 thru 0002 v5 maintenance last Saturday in 4 development subsystems. Haven't seen any problems as of yet. All ptfs were applied except for a few that I excluded. We are a heavy PeopleSoft machine.
Dave
Dave Gendron Colorado Springs, CO 719-520-4760 dave.gendron@coastalcorp.com
-----Original Message----- From: Whittaker, Stephen Sent: Tuesday, April 25, 2000 6:32 AM To: DB2-L@RYCI.COM Subject: DB2 V5 Maint. Upgrade [...]
3491 138 24_Compression CPU overhead15_Stovall, Martin16_MStovall@USG.COM31_Tue, 25 Apr 2000 09:52:08 -0500542_iso-8859-1 Does anyone else experience the CPU overhead that this test showed? I have asked the hardware/system's group and the machine supposedly has The hardware compression assist feature. Also, is there any flaw that anyone sees in this test??
I ran the following test to be able to determine the CPU overhead for decompressing rows. I ran a query against a table with no indexes to force a tablespace Scan and the bufferpool was sized so that there was a 100% hit ratio. The compressed table had a compression ratio of 65%.. [...]
3630 49 24_privileges & authorities17_John Breidenstine31_JBreidenstine@LEGIS.STATE.PA.US31_Tue, 25 Apr 2000 10:58:12 -0400409_iso-8859-1 Hello,
We have a question that involves the following system catalog tables - DB2 V6.1 EE on AIX. SYSCAT.COLAUTH SYSCAT.DBAUTH SYSCAT.INDEXAUTH SYSCAT.PACKAGEAUTH SYSCAT.SCHEMAAUTH SYSCAT.TABAUTH
The problem we have is that whenever we drop a table, tables or database, to recreate it a little differently, we lose all of the privileges and authorities held in the above tables. [...]
3680 109 28_Re: Compression CPU overhead15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Tue, 25 Apr 2000 10:51:47 -0500344_ISO-8859-1 I see no errors in the execution or the data. I do see errors in the concept.
Let me say up front that I have no interest in hardware, either CPU or DASD, but I do have an interest in appropriateness. I work on utilities now, but previously I worked at a very large package delivery company and did performance analysis. [...]
3790 43 21_Administering Clients0_20_vpacheco@AMADEUS.NET31_Tue, 25 Apr 2000 17:57:27 +0100570_us-ascii Dear all
We are running DB2 Connect (NT,V5 and V6) and CAE (NT,V5 and V6) to provide some users with ODBC connections to DB2 on OS/390. Currently we have 3 DB2 Connect installations and around 300 CAE users installed (which result in less than 10 concurrent users).
Because of the upgrade of one of this GW we would like to move the users currently defined on it to one of the others, upgrade it and move them back. One process would be to Export the configuration file for the target GW and request the users to Import this configuration to [...]
3834 16 16_Large Tablespace13_Moss, William15_MossW@AETNA.COM31_Tue, 25 Apr 2000 12:04:07 -0400393_- If a tablespace has been created with the large parameter, what is the maximum size an NPI on the table can be ?
TIA,
Bill Moss
================================================ 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.
3851 71 25_Re: Administering Clients14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 25 Apr 2000 12:11:13 -0400508_iso-8859-1 Vitor, You will find the details available in the Installation and Configuration Supplement for DB2 UDB and DB2 Connect V6 GC09-2857-00. Many possibilities and many challenges. HTH Phil Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS
----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, April 25, 2000 12:57 PM Subject: Administering Clients [...]
3923 99 33_Re: member parameter of plan bind9_Rob Crane22_racrane@CONCENTRIC.NET31_Tue, 25 Apr 2000 11:20:19 -0600570_us-ascii I would make your change (eliminating the DBRM plan bind once it is a package), you should be able to justify it given the following.
1) Reduced space in catalog and directory 2) Ability to have multiple versions of a program running 3) Easier to understand, less confusing
The ability to have both DBRM's and Packages in the PLAN bind was a convenient way to allow people to convert from DBRM plans to PACKAGE based plans with the release of 2.3 of DB2. In most cases, you would not have the same DBRM and package as you describe below. The [...]
4023 18 33_Any books on stored procedures???10_John Lantz23_john.lantz@ZURICHUS.COM31_Tue, 25 Apr 2000 12:10:43 -0500433_- We are looking for a good book on stored procedures. We are specifically looking for stuff relating to the use of the SQL procedure language. I realize that this is just becoming available for UDB with Windows NT/2000 with V7, and that not many folks have had a chance to use it yet. But it's been around with AS400 since last year. Is anything out there yet? Is anybody working on one (we would be willing to help proof it)? [...]
4042 120 42_Re: Stored Procedures and Sequential Files22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 25 Apr 2000 13:48:55 -0400716_iso-8859-1 Check out Jim Harrison's DB2-L-Documents March 2000 contribution "Dynamic File Allocation from a COBOL DB2 Stored Procedure" at http://jupiter.ryci.com/archives/db2-l-documents.html.
Also, search the db2-l archives http://jupiter.ryci.com/archives/db2-l.html.
> ---------- > From: MARTIN WOLFF[SMTP:martin_wolff@GLOBALCROSSING.COM] > Sent: Tuesday, April 25, 2000 8:21 AM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Stored Procedures and Sequential Files > > Since you only have DB2 V4 you only have the SPAS for stored procedures > which means you have only one JCL proc to allocate datasets in. The down > side is that all the datasets you allocate this way will be tied up as > long [...]
4163 137 15_Re: CPU or CPUs12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 25 Apr 2000 20:10:22 +0200442_x-user-defined Hi, On top of all the answers you've got please remember that there is a "penalty" for each cpu added as the "speed" of each cpu is decremented as you may see from the following numbers (taken from IBM data). The more cpu's the better the total throuput but each task gets a little bit less for itself. It really depends on your workload and needs much deeper analysis of what is going on (or planned to be) on your site. [...]
4301 29 45_any DB2 positions open (Wash DC - Baltimore)?12_Julian Burke21_jtburke@IX.NETCOM.COM31_Tue, 25 Apr 2000 12:53:32 -0500531_- Please let me know of any DB2 contract or permanent positions, in the extended metropolitan areas of Washington, DC and Baltimore for a Consultant with 15 years experience in developing DB2 applications and databases for Fortune 500 companies and government organizations. Full life cycle experience includes logical and physical modeling. Have designed and written numerous applications using COBOL, CICS and DB2. Extensive experience using CASE tools. Strong DB2 experience and training from IBM. Light ORACLE experience. [...]
4331 79 28_Re: privileges & authorities10_Leo Pedron19_lpedron@BOSCOVS.COM31_Tue, 25 Apr 2000 14:44:28 -0400555_iso-8859-1 We use DBArtisan from Embarcadero Technologies to perform the sort of tasks you are describing. When we need to make a table change the tool renames the table, generates the DDL to create the new table loads the data recreates all the constraints and issues all the authorities to the new object that belonged to the old one. This tool also has many nice features for monitoring databases as well. The only thing t doesn't do is drop the old table, so you need to have enough space in the tablespace to hold two copies of the data. We use [...]
4411 51 47_Re: DB2 Connect (Personal Edition V6.1) Problem13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 25 Apr 2000 13:45:00 -0500528_iso-8859-1 Hello,
One nice feature of V5 is support for TCPIP connectivity (liberation from the SNA/VTAM model) It is much more straightforward to set up. Have you considered going this route? I remember the frustration of getting the old DDCS/2 Server to host connection going initially...(shudder)...
Dave
-----Original Message----- From: Li, Chak Lung Dominic [mailto:seddba@HK.SUPER.NET] Sent: Tuesday, April 25, 2000 5:29 AM To: DB2-L@RYCI.COM Subject: DB2 Connect (Personal Edition V6.1) Problem [...]
4463 50 20_Re: Large Tablespace19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 25 Apr 2000 13:45:27 -0500551_ISO-8859-1 Hi Bill, DB2 UDB/OS390 V6. I'll take a shot at this. If I'm reading the table right, and please feel free to correct me, its 64G for NPI when 125 extents are allowed, or approx 128G if 254 are allowed. 1T or 16T for partitioned indexes based on whether or not the tablespace the partitioning index is built on is LARGE or DSSSIZE is used. See SQL REF, Appendix A, Limits in DB2 for OS/390, bookmanager ref., A.0; Hope I got that right, the table is "challenging". HTH, Rick Davis "This e-mail and any files transmitted with it are the [...]
4514 90 28_Re: privileges & authorities41_Stritchko, Scott (CC-Application Support)27_Scott.Stritchko@CONAGRA.COM31_Tue, 25 Apr 2000 13:38:55 -0500641_iso-8859-1 -----Original Message----- From: Leo Pedron [mailto:lpedron@BOSCOVS.COM] Sent: Tuesday, April 25, 2000 1:44 PM To: DB2-L@RYCI.COM Subject: Re: privileges & authorities
We use DBArtisan from Embarcadero Technologies to perform the sort of tasks you are describing. When we need to make a table change the tool renames the table, generates the DDL to create the new table loads the data recreates all the constraints and issues all the authorities to the new object that belonged to the old one. This tool also has many nice features for monitoring databases as well. The only thing t doesn't do is drop the old [...]
4605 193 18_Re: DB2 V6 Upgrade12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Tue, 25 Apr 2000 15:01:03 -0400516_iso-8859-1 Look in your documentation for "DB2 UDB for OS/390 V6 Release Planning Guide" or go to http://www.software.ibm.com/data/db2/os390 and look for it.
Two specific gotchas during migration:
1) Don't to assume that the DSNTESQ queries contain anything that will look for VIEWS on SYSCOLDIST or SYSCOLDISTSTATS. You have to query yourself. If you don't remove any that you have before attempting CATMAINT, you will fail and be in that land of limbo between V5 & V6. It's a very lonely place. [...]
4799 36 8_DSN1COPY23_Trivedi, Kaushal J, BGM17_kjtrivedi@ATT.COM31_Tue, 25 Apr 2000 14:16:25 -0400511_ISO-8859-1 Hi all, I was trying to bring a backup up copy using DSN1COPY , Since the table structure had changed from the older copy I created a table with the old structure and am trying to XLAT the backup copy, the DSN1COPY runs just fine and says n pages loaded and stuff , when I tried to reorg the tablespace agter wards it gave me this message, can some one throw some light, I have tried to use DSN1COPY with the parms 'OBIDXLAT,FULLCOPY,RESET', but I do not know much about broken segmented pages, [...]
4836 62 12_Re: DSN1COPY20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 25 Apr 2000 15:19:51 -0400593_us-ascii Have checked up SEGSIZE ? Is it matching with the old structure ? Did you do "alter table" to change the old table structure earlier ?
-----Original Message----- From: Trivedi, Kaushal J, BGM [SMTP:kjtrivedi@ATT.COM] Sent: Tuesday, April 25, 2000 2:16 PM To: DB2-L@RYCI.COM Subject: DSN1COPY
Hi all, I was trying to bring a backup up copy using DSN1COPY , Since the table structure had changed from the older copy I created a table with the old structure and am trying to XLAT the backup copy, the DSN1COPY runs just fine and says n pages loaded and stuff , when I [...]
4899 79 12_FW: DSN1COPY18_Satkowski, William18_wsatkowski@CSW.COM31_Tue, 25 Apr 2000 15:11:09 -0500818_iso-8859-1 If the source table was altered(add a column) and was never reorged afterward, you could get this problem on the target.
Bill Satkowski Data Base Consultant Wsatkowski@csw.com 918-594-2282
---------- From: Pillay, Venkat (PCA) [SMTP:venkat_pillay@ML.COM] Sent: Tuesday, April 25, 2000 2:20 PM To: DB2-L@RYCI.COM Subject: Re: DSN1COPY
Have checked up SEGSIZE ? Is it matching with the old structure ? Did you do "alter table" to change the old table structure earlier ? -----Original Message----- From: Trivedi, Kaushal J, BGM [SMTP:kjtrivedi@ATT.COM] Sent: Tuesday, April 25, 2000 2:16 PM To: DB2-L@RYCI.COM Subject: DSN1COPY [...]
4979 31 35_online reorg mapping table question0_26_mmetcalf@NOTES.STATE.NE.US31_Tue, 25 Apr 2000 15:30:00 -0500603_us-ascii I'm curious about documentation I've read stating that the mapping table tablespace itself need only minimal allocation but the index for that mapping table needs to account for 110% of the number of rows in the tablespace being reorged (because all access to the mapping table is index only).
I am reorging a tablespace with 105,559 rows. I created a mapping table tablespace with priqty 48k and 0 secqty. The index on the mapping table (map_tbl_ix) was created with priqty 48k and secqty 48k. I used Platinum to perform a space calculation and came to the conclusion that I would [...]
5011 55 13_script center13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Tue, 25 Apr 2000 16:54:11 -0400562_us-ascii This is the second time I have posted this, because I have not received any answers... hope someone out there knows enough about DB2/U ver 6.1 for Solaris on windows NT workstation. I have to reference the script center and journal thru the control center. I can use the control center fine, it shows all my databases, tables, etc...on the Solaris... I can click on a table and obtain sample data, all works fine... however, when I go to use the script center... no system is in the drop down,,,so when I try to create new script, error msg saying [...]
5067 36 17_Re: script center10_Park, Stan17_SPark@STATE.NM.US31_Tue, 25 Apr 2000 15:21:47 -0600660_iso-8859-1 I have Databases on Solaris, NT, and OS390. Control center shows ALL but Script center and journal show ONLY NT platform. -Stan -----Original Message----- From: Jimmy Willett [mailto:Jimmy.Willett@NCMAIL.NET] Sent: Tuesday, April 25, 2000 2:54 PM To: DB2-L@RYCI.COM Subject: script center
This is the second time I have posted this, because I have not received any answers... hope someone out there knows enough about DB2/U ver 6.1 for Solaris on windows NT workstation. I have to reference the script center and journal thru the control center. I can use the control center fine, it shows all my databases, tables, etc...on the [...]
5104 54 11_Re: backups13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Tue, 25 Apr 2000 17:02:48 CDT357_- -db2 update db cfg for db using logretain on -force applications At this point database will be placed in backup pending state and you will be forced to do a complete offline database back before proceeding any further. Once completed then you could do your tablespace level backups (although not necessary at this point) and so on ........ [...]
5159 58 12_Re: DSN1COPY13_Purnima Patel18_ppatel@METLIFE.COM31_Tue, 25 Apr 2000 15:43:08 -0400671_us-ascii Did you stop the new tablespace before doing the DSN1COPY , if you did not then you will get this message.
"Trivedi, Kaushal J, BGM" on 04/25/2000 02:16:25 PM
Please respond to "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM cc: (bcc: Purnima Patel/Bsg/MetLife/US) Subject: DSN1COPY
Hi all, I was trying to bring a backup up copy using DSN1COPY , Since the table structure had changed from the older copy I created a table with the old structure and am trying to XLAT the backup copy, the DSN1COPY runs just fine and says n pages loaded and stuff , [...]
5218 26 28_DB2 SQL error handler - CODE12_Jim Harrison12_jimh@QIS.NET31_Tue, 25 Apr 2000 19:07:13 -0400514_us-ascii I promised I'd post when I'd uploaded the generic SQL error handler we use and I must have had a senior moment because I don't see it in the archives. For those who expressed interest, the source code can be found at:
http://jupiter.ryci.com/cgi/wa.exe?A2=ind0004&L=db2-l-documents&F=&S=&P=651
It's for batch programs primarily, but could be used in TSO applications. It's a called program that analyzes SQL error codes and displays the associated message and some related information. [...]
5245 48 20_Re: Large Tablespace14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 25 Apr 2000 18:29:02 -0400669_iso-8859-1 DB2 V6 OS/390 - if using piecesize, then same size as table - 254 pieces at 64GB each = 16TB DB2 V5 OS/390 - if using piecesize, then 512 GB
Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net DB2 Performance Journal, Quarterly www.YLAssoc.com -- www.DB2-Portal.com
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Moss, William > Sent: Tuesday, April 25, 2000 12:04 PM > To: DB2-L@RYCI.COM > Subject: Large Tablespace > > > If a tablespace has been created with the large parameter, what is the > maximum size an NPI on the table can [...]
5294 48 37_Re: Any books on stored procedures???14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 25 Apr 2000 18:32:15 -0400694_iso-8859-1 Book is titled "SQL/PSM", by Jim Melton - came out last year.
Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net DB2 Performance Journal, Quarterly www.YLAssoc.com -- www.DB2-Portal.com
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > John Lantz > Sent: Tuesday, April 25, 2000 1:11 PM > To: DB2-L@RYCI.COM > Subject: Any books on stored procedures??? > > > We are looking for a good book on stored procedures. We are specifically > looking for stuff relating to the use of the SQL procedure language. I > realize that this is just becoming available for UDB [...]
5343 104 34_Re: Removing Entries from SYSLGRNX12_Kirk Hampton16_khampto1@TXU.COM31_Tue, 25 Apr 2000 18:53:45 -0500456_us-ascii Andy, how are you viewing the contents of SYSIBM.SYSLGRNX ? I am on DB2 for OS/390 v5 and I cannot perform a SELECT from that table.
"DAVIS, RICK (SBCSI)" on 04/20/2000 01:30:15 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Kirk Hampton/Texas Utilities) Subject: Re: Removing Entries from SYSLGRNX [...]
5448 110 11_Re: backups0_29_Greg.Palgrave@BANKWEST.COM.AU31_Wed, 26 Apr 2000 08:35:52 +0800680_us-ascii
BankWest - "Behaving With Integrity"
Jimmy,
Have you done a full OFFLINE backup since turning on log retain? From the messages manual(*** are mine):
SQL2421N Table space level backup is not allowed because roll-forward recovery is not enabled.
Cause: Table space level backup cannot be performed while the database is not logging for forward recovery as forward recovery will be required at restore time. ***Forward recovery is placed into effect by setting either the database configuration logretain parameter or the userexit parameter, and then performing an offline backup of the database. *** [...]
5559 57 26_Links about DB2 for OS/3906_DB2usa18_db2usa@HOTMAIL.COM31_Tue, 25 Apr 2000 19:23:09 -0500502_ISO-8859-1 Hi,
Here is a non-profit website about DB2 for OS/390 (IBM mainframes): - English : http://www.multimania.com/db2usa/eliendb2.htm - Français: http://www.multimania.com/db2usa/liendb2.htm
Last update on Wednesday, April 26th 2000 =========================================
- Links about DB2 for OS/390: http://www.multimania.com/db2usa/eliendb2.htm IBM annonced DB2 UDB Server for OS/390, version 7. PDF document : What's new in version 7 is available on IBM's site. [...]
5617 66 27_RV: Question about triggers18_Centro de Computos21_iplc05@INFOVIA.COM.AR31_Tue, 25 Apr 2000 22:20:58 -0300388_iso-8859-1 Hi everybody !!! I sent this message some days ago, but had no responses, can anyone confirm if it is reaching the list?
TIA
Daniel DBAdmin
INSTITUTO PROVINCIAL DE LOTERIA Y CASINOS BUENOS AIRES - ARGENTINA
---------- Desde: Administrador Enviado el: miércoles 12 de abril de 2000 20:40 Para: 'DB2 List' Asunto: Question about triggers [...]
5684 28 18_DB2 Instance Hangs18_Centro de Computos21_iplc05@INFOVIA.COM.AR31_Tue, 25 Apr 2000 22:28:13 -0300442_iso-8859-1 Hi all ! Recently we started to upgrade from DB2 UDB v5.2 to v6.1 (under Win NT). Sometimes, when accesing the database in the development environment, it hangs. We are almost sure these is related to the use of a Visual Basic DataSource component, since accessing the database from the Control Center or Command Center is always OK. The issue here is that it only hangs sometimes, and we don´t know why. Any insight on this? [...]
5713 70 12_Re: DSN1COPY16_Brian F. Patella25_patellab@WORLDNET.ATT.NET31_Tue, 25 Apr 2000 20:43:13 -0400462_iso-8859-1 I was planning to use DSN1COPY for the recovery of segmented tablespaces until I read the following in section 4.6.6 Recovery of Dropped Objects in the DB2 V5 Administration Guide. Subtopic Limitations of the Procedures reads as follows: "These procedures do not reclaim a dropped table in a segmented table space. Because of the way space is reused for segmented table spaces, there is no simple, predictable procedure to recover these tables." [...]
5784 108 12_Re: DSN1COPY12_Price, David22_David.Price@SCHWAB.COM31_Tue, 25 Apr 2000 18:54:02 -0700574_- Brian, The documentation in your note only applies to "dropped" tables, it does not apply to recovering all tables in a segmented tablespace. Dave Price
Technical Director - Availability Schwab Technology Innovation Charles Schwab & Co. PHXDC-02-2055
Work: (602) 426-2702 Pager (888) 416-3386 Mobile (602) 321-6518
All email sent to or from this address will be received or otherwise recorded by the Charles Schwab corporate email system and is subject to archival, monitoring or review by, and or disclosure to, someone other than the recipient [...]
5893 59 24_Tools for increase perfo7_revadee18_revadeev@SCB.CO.TH31_Wed, 26 Apr 2000 09:15:22 +0700278_windows-874 Hi, all
I used DB2 on Solaris, but right now size of database is 60 GB and it take about 3.5 hours for "db2 backup database". I'm not quite sure that have any tools (third party) to improve speed for backup database.
Thanks in advance. Revadee.
5953 53 11_BLOB column7_revadee18_revadeev@SCB.CO.TH31_Wed, 26 Apr 2000 09:30:24 +0700165_windows-874 Hi, all
About BLOB column data in the table, which ways to compress space for BLOB data in this table.?
Thanks in advance, Revadee.
6007 18 30_Re: Links about DB2 for OS/3908_Bob Abad16_BobRabad@AOL.COM29_Wed, 26 Apr 2000 00:13:17 EDT429_US-ASCII http://www.multimania.com/db2usa/eliendb2.htm
Thanks for a job well done in this website. Will be accessing this frequently for technical referencing....
-Bob Abad-
================================================ 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.
6026 76 71_Re: Discouraging comments and an observation that is nearly off t opic.14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 26 Apr 2000 09:01:16 +0200377_us-ascii Hi Rick.
I think you're quite right, let them to have they (wrong ?) way. And cry, may be.
I escaped from a company who suddenly decided to convert ALL applications from Unisys/S390
to UNIX (HP & SUN)/ORACLE. It was an technology innovations, they said.
The boss who decided this 'new' course was a new manager from a company based on [...]
6103 18 20_Plan Name into Pgm..32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Wed, 26 Apr 2000 10:46:18 +0300443_- Hello List,
Do you know any mechanism to get the Name of the Application Plan into the pgm ?
Regards,
Cüneyt GÖKSU Tel : 0090-212-657 0404 Ext: 1218 mailto:Cuneytg@garanti.com.tr
================================================ 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.
6122 126 39_Re: online reorg mapping table question0_18_mebert@AMADEUS.NET31_Wed, 26 Apr 2000 10:42:30 +0100531_us-ascii The mapping table index is built up during the RELOAD phase and used in the LOG APPLY phase. After this has finished, the Index is again reset to its primary allocation. In a small TS like this, these phases take seconds only, so you may simply have missed seeing the IX in extents. I am not quite sure whether index entries are created for all rows or only for rows where the new and old RID are different but I suspect the former because I think I have seen the mapping IX in extents even when rerunning a REORG on [...]
6249 177 31_Re: RV: Question about triggers0_18_mebert@AMADEUS.NET31_Wed, 26 Apr 2000 10:50:55 +0100432_us-ascii Hi Daniel,
it is reaching the list but apparently nobody has any idea of what might be the problem. Maybe you can create a simple test table, reducing the problem to its minimum (getting rid of complicated WHERE clauses and so on) and repost that. Sometimes I managed to solve problems that way. How's Argentina these days? I have several good friends there (in La Plata and Olavarria) from my university days! [...]
6427 28 28_Re: Compression CPU overhead18_Rajesh Kumar Sinha24_rksinx@LOT.TATASTEEL.COM29_Wed, 26 Apr 2000 12:35:20 GMT584_us-ascii Hi stovall, We have implemented software compression in our development environment. Reason is DASD is much cheaper than CPU. I had also conducted similar test for one of our large batch job and find before compression CPU 3.01 min and after compression 3.8 min . This difference was even not acceptable to us. But my batch job was only reading the data. See CPU is very much dependent on whether your query is reading or writing to the table space. Reading compressed table is better, because you save on I/O and for reading data only decompression is required. But in [...]
6456 24 43_sortwork BP usage vs sortwork dataset usage16_Robert Blackwell31_robert.blackwell@PIEDMONTNG.COM31_Wed, 26 Apr 2000 08:45:15 -0400451_us-ascii -DIS DB(DSNDB07) SPACE(*) USE LIMIT(*)
Using the display command above, I monitor usage of the sortwork datasets. Without knowing exactly what certain CICS programs are doing, I see regular usage of these datasets by CICS transactions. I would expect almost all of the CICS programs to be using the sortwork BP without having to make use of the sortwork datasets with batch programs being the major user of the sortwork datasets. [...]
6481 29 39_DB2 for NT Control Center connect error12_Mike O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV31_Wed, 26 Apr 2000 08:26:11 -0400453_US-ASCII I have installed DB2 for Win NT on my desktop. We are currently running DB2 for OS/390 v6.1 on our mainframes, and have 2 DB2 subsystems on one LPAR.
My question is: How can I get the second DB2 instance to be recognized in the Control Center? I have added it via the CCA, and tested and bound the utilities successfully. When I try to sign on to it, I get a message: SQL1403N Invalid user id or password; and a SQL state of 08004. [...]
6511 23 34_Is there a way to get Program Name9_Ken Paris17_KenParis@LVCM.COM31_Wed, 26 Apr 2000 06:47:03 -0700309_US-ASCII We'd like to use a trigger to stuff in information about when a row was inserted/updated. The date/time info is easy and, if it was done online then we'll use the USER special register. However, we can't figure out how to get the program name (for batch jobs).
Does anyone know of a way? [...]
6535 26 34_Is there a way to get Program Name9_Ken Paris17_KenParis@LVCM.COM31_Wed, 26 Apr 2000 06:49:03 -0700370_US-ASCII We'd like to use a trigger to stuff in information about when a row was inserted/updated. The date/time info is easy and, if it was done online then we'll use the USER special register. However, we can't figure out how to get the program name (for batch jobs).
We'd prefer to do it without calling a stored procedure, but will do that if necessary. [...]
6562 26 48_Is there a way to get program name in a trigger?9_Ken Paris17_KenParis@LVCM.COM31_Wed, 26 Apr 2000 06:54:02 -0700286_US-ASCII We'd like to use a trigger to stuff in information about when and by who a row was inserted/updated. The date/time info is easy and, if it was done online then we'll use the USER special register. However, we can't figure out how to get the program name (for batch jobs). [...]
6589 29 47_Re: sortwork BP usage vs sortwork dataset usage0_31_truman.g.brown@BELLATLANTIC.COM31_Wed, 26 Apr 2000 09:57:36 -0400511_us-ascii A dedicated sortwork bufferpool responds to bufferpool parameters just like any other bufferpool. We use VPSEQT of 98, DWQT of 80 (or more), and VDWQT of 65 (or more).
DWQT and VDWQT values will depend on the size and concurrency of individual concurrent application sortworks.
Remember that the SORTWORK parameter is per user; each user gets this value. If possilbe, make the SORTWORK value large enough so that most "runs" don't get written to DASD (requiring a subsequent merge). [...]
6619 121 71_Re: Discouraging comments and an observation that is nearly off t opic.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 26 Apr 2000 09:44:27 -0500620_ISO-8859-1 Hi Max, Your wise paraphrase: "I'm sitting on river bank, waiting the corpse of my 'enemy'....". I've forgotten the source, was it Confucius, or General T'Soo? Somebody else?
Best 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 [...]
6741 43 46_How do I find the IDENTITY value of a new row?14_Harold Trammel19_hlt@NAPCC.ASPCA.ORG31_Wed, 26 Apr 2000 09:44:04 -0500610_us-ascii I have installed the DB2 7.1 beta on my WinNT development computer and have begun exploring the new functionality it provides. We anticipate upgrading from 6.1 to 7.1 in June when the "real" version is released.
One of the application requirements that we have is an auto-incrementing primary key. We have been working with a trigger that uses max() and nullid.counter, but it would appear that the new IDENTITY column could be a cleaner replacement for our trigger. The problem we have had with the trigger approach was finding out the value of the newly inserted primary key. It appears [...]
6785 20 32_Cloning a complete DB2 subsystem12_Mike O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV31_Wed, 26 Apr 2000 10:47:55 -0400532_US-ASCII We are getting ready to create a production DB2 subsystem, and want to clone the current Acceptance Test one, since that has all the structures, etc. that we need. Is there any way to do this without having to run all the install jobs?
Thanx, Mike O'Neill US Customs Service
================================================ 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.
6806 63 47_Re: sortwork BP usage vs sortwork dataset usage14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 26 Apr 2000 10:53:38 -0400604_ISO-8859-1 I guess you are referring to the SRTPOOL parameter in the Zparm. This area of memory is used before data goes to the bufferpoool, so this Combined with the bufferpool size and thresholds determines if/when data is written to dasd. Making srtpool too large (especially considering multiple concurrent sorters) may drive your system paging through the roof. Raising the dwqt and vdwqt are good options if "almost all" of your sorts can complete in the pool without going to dasd. The other consideration, may be that you will slam into spth, dmth, and iwth when larger sorts hit the system [...]
6870 40 27_-911's with Online Reorg V515_Knabach, Mark L20_mark.knabach@EDS.COM31_Wed, 26 Apr 2000 11:05:17 -0400552_iso-8859-1 Hi all ... I could use a little help, please.
While running the Online Reorg under V5, I'm having a problem with application jobs timing out (-911's) or in other cases abending because of a "Resource Unavailable", Reason: 00C900BA, and Type: 00002009 (Index space partition CS-claim class).
I'm using the following parameters on my control card and have tried modifying both the MAXRO and the DRAIN (between 'writers' and 'all') parameters without success of eliminating the -911's or the "Resource Unavailable" messages: [...]
6911 336 42_Re: Performance on using partitioned Index14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 27 Apr 2000 01:20:14 +1000464_us-ascii Sekar.S.,
This is your first email with enough information to make a start on your problem. Before that a lot of wild guesses were being made that probably not relevant.
When you have 4 matching columns on the partition index, you do not need extra help from partition range filter. The index narrows down to a single partition anyway. DB2 will probe straight to the correct partition and correct index leaf page and correct data page. [...]
7248 16 22_online books, Platinum0_20_ddlusk@HOUSEHOLD.COM31_Wed, 26 Apr 2000 10:23:22 -0500452_us-ascii Can anyone point me to Platinum's plan analyzer, online reference guide Can't seem to find them on the Computer Associates site I need to set up a batch explain, for a dynamic sql program
T.I.A.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
7265 48 0_13_Virnig, Chris26_Chris.Virnig@COURTS.WA.GOV31_Wed, 26 Apr 2000 09:09:23 -0700527_iso-8859-1 I have what I think is a simple problem, but I can't seem to resolve it.
Recently we had a DB2 subsystem abend. When we restarted a single thread was identified as INDOUBT. This thread was created by a requester running a Websphere JAVA application on an NT server accessing DB2 on OS/390. The DB2 JES log and display thread command display the following information. My problem is I can't figure how to get rid of the thread via the recover thread command. Any help would be greatly appreciated. Thanks [...]
7314 45 26_Re: online books, Platinum13_Thomas, Janis19_Janis.Thomas@CA.COM31_Wed, 26 Apr 2000 12:29:11 -0400428_iso-8859-1 We are currently in the process of setting up support pages for the old Platinum products on http://support.ca.com. The pages will be available within the next couple of weeks & will include the online documentation. For now, the old Platinum support site with the online doc is still available here: http://platinum.support.com. It will be going away once everything is transferred over to the CA support site. [...]
7360 10 19_Re: Indoubt threads10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Wed, 26 Apr 2000 12:36:22 -0400364_- Try the recover indoubt command. With this command you can specify weather you want to commit or abort the unit of work.
================================================ 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.
7371 23 53_MVS/OS390 Generating unique row identifiers - how to?14_Stewart, Brian21_BStewart@NEONSOFT.COM31_Wed, 26 Apr 2000 10:36:16 -0600415_iso-8859-1 Hello -
I am trying to port some SQL written for DB2 UDB on Unix to DB2 for MVS/OS390. The UDB code has a GENERATE_UNIQUE() function that generates a unique row ID for each row upon insert. I cannot find a similar function for DB2 on MVS. Amy I missing something? Does anyone know of a workaround? Has anyone had to deal with this or a similar problem? Any help would be greatly appreciated. [...]
7395 93 0_9_Ted Pesta18_tpesta@AMQUEST.COM31_Wed, 26 Apr 2000 12:44:21 -0400517_iso-8859-1 Chris,
Try
RECOVER INDOUBT (SERVER) ACTION(ABORT) ID(*)
Make sure you have no other "SERVER" activity when you enter this. Reference -RECOVER INDOUBT In the Command Reference manual.
HTH, Ted Pesta Standard disclaimers apply.
-----Original Message----- From: Virnig, Chris [mailto:Chris.Virnig@COURTS.WA.GOV] Sent: Wednesday, April 26, 2000 12:09 PM To: DB2-L@RYCI.COM Subject:
I have what I think is a simple problem, but I can't seem to resolve it. [...]
7489 115 26_Re: Recover indoubt thread19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 26 Apr 2000 11:44:31 -0500748_ISO-8859-1 Chris, Try COMMIT first. Then ABORT.
RECOVER INDOUBT-------------------------ACTION(---COMMIT---)-----> ¦ ¦ +-(connection-name)-+ +-ABORT--+ ¦ ¦ ¦ ¦ <-,--------------+ ¦ ¦ >----ID(-----correlation-id-----)----------------------------------->< ¦ ¦ ¦ +-*------------------+ ¦ ¦ ¦ ¦ <-,----------+ ¦ ¦ ¦ +-NID(---network-id---)--------¦ ¦ ¦ ¦ <-,-------+ ¦ ¦ ¦ +-LUWID(----luwid----)---------+ ¦ ¦ +-token-+
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 [...]
7605 33 7_Re: SQL12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Wed, 26 Apr 2000 12:52:23 -0400373_iso-8859-1 Hi all, I could really use some assistance with a query that I've been wrestling with. It goes like this: Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col From table A, table B Where ..................
I need to extract all of the rows off of table A, regardless of whether or not I match with table B. Sugestions........................ [...]
7639 63 7_Re: SQL0_23_sjtoeniskoetter@AEP.COM31_Wed, 26 Apr 2000 13:00:04 -0400732_us-ascii Use a left outer join:
Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col From table A left outer join table B On A.joincol = B.joincol Where ..................
Steve Toeniskoetter
"Kalman, Jeff" on 04/26/2000 12:52:23 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Steve J Toeniskoetter/OR1/AEPIN)
Subject: Re: SQL
Hi all, I could really use some assistance with a query that I've been wrestling with. It goes like this: Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col From table A, table B Where .................. [...]
7703 80 7_Re: SQL12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Wed, 26 Apr 2000 13:03:52 -0400557_iso-8859-1 Thank you for you reply.
Jeff
-----Original Message----- From: sjtoeniskoetter@AEP.COM [mailto:sjtoeniskoetter@AEP.COM] Sent: Wednesday, April 26, 2000 1:00 PM To: DB2-L@RYCI.COM Subject: Re: SQL
Use a left outer join:
Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col From table A left outer join table B On A.joincol = B.joincol Where ..................
Steve Toeniskoetter
"Kalman, Jeff" on 04/26/2000 12:52:23 PM [...]
7784 70 7_Re: SQL11_Dave Canham19_DAVE_CANHAM@PHL.COM31_Wed, 26 Apr 2000 13:02:44 -0400532_us-ascii You need a left outer join.
Try this:
Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col From table A LEFT JOIN table b ON
(the ON replaces WHERE)
"Kalman, Jeff" @RYCI.COM> on 04/26/2000 12:52:23 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: bcc: Subject: Re: SQL [...]
7855 85 7_Re: SQL12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Wed, 26 Apr 2000 13:15:52 -0400425_iso-8859-1 Thank you for your reply, I'll go with it.
-----Original Message----- From: Dave Canham [mailto:DAVE_CANHAM@PHL.COM] Sent: Wednesday, April 26, 2000 1:03 PM To: DB2-L@RYCI.COM Subject: Re: SQL
You need a left outer join.
Try this:
Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col From table A LEFT JOIN table b ON
(the ON replaces WHERE) [...]
7941 65 31_Re: -911's with Online Reorg V514_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Wed, 26 Apr 2000 13:29:32 -0400349_us-ascii If I'm interpeting your error message correctly, you are Online reorging a partitioned tablespace (all parts). An Online Reorg of a partitioned tablespace executes a BUILD2 phase after the SWITCH phase to update the NPI's. The Online Reorg does not rename the NPI's, it updates them. During the BUILD2 phase, no SQL access is allowed. [...]
8007 63 7_Re: SQL0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 26 Apr 2000 13:45:25 -0400455_us-ascii Well, have nothing in the where clause. But you will get the cross product (cartesian product)
The other choice is to do a left outer join on the matching rows with table B.
Dean
"Kalman, Jeff" @RYCI.COM> on 04/26/2000 12:52:23 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
8071 54 7_Re: SQL16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Wed, 26 Apr 2000 10:55:11 -0700596_- Use LEFT OUTER JOIN
Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col From table A LEFT OUTER JOIN table B ON A.? = B.? AND A.? = B.? .... Where ..................
Duane > -----Original Message----- > From: Kalman, Jeff [SMTP:JKalman@UNCH.UNC.EDU] > Sent: Wednesday, April 26, 2000 9:52 AM > To: DB2-L@RYCI.COM > Subject: Re: SQL > > Hi all, > I could really use some assistance with a query that I've been wrestling > with. It goes like this: > Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col > From table A, table B > Where .................. > > I [...]
8126 68 7_Re: SQL12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Wed, 26 Apr 2000 13:58:20 -0400404_iso-8859-1 Thank you for your reply.
-----Original Message----- From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: Wednesday, April 26, 2000 1:55 PM To: DB2-L@RYCI.COM Subject: Re: SQL
Use LEFT OUTER JOIN
Select A.col1, A.col2, A.col3, A.col4, A.col5, A.col6, B.col From table A LEFT OUTER JOIN table B ON A.? = B.? AND A.? = B.? .... Where .................. [...]
8195 62 30_Re: JDBC Type-2 Driver for MVS9_Wu, James13_jwu@KRAFT.COM31_Wed, 26 Apr 2000 13:06:21 -0500374_- Hi MIKE!
We are still use type 1 JDBC thru Websphere/VisualAge. One problem we are experiencing is that when Java passes a parm of VARCHAR or a concatenation of two different datatypes, e.g. a char string and a number, the parm is not translated properly in SP. Even the DISPLAY shows the right content, it is not recognized in the WHERE clause. Very strange. [...]
8258 32 58_DB2 Batch Program Running on Side1 Accessing Data on Side212_Bruce Fuller17_BFuller@EBSCO.COM31_Wed, 26 Apr 2000 13:21:13 -0500370_- Hello everyone, We have had a strange request that my coworker and I would like group's input on. We are currently working on converting most of our COBOL VSAM programs to be COBOL DB2. Our operations manager is worried about the system resources on our production LPAR. He is concerned that we will not be able to run ONLINE programs and BATCH at the same time. [...]
8291 53 62_Re: DB2 Batch Program Running on Side1 Accessing Data on Side214_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Wed, 26 Apr 2000 14:41:31 -0400715_us-ascii Have you considered Data Sharing?
Bruce Fuller on 04/26/2000 02:21:13 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Larry D Bolick/Corp/DukePower) Subject: DB2 Batch Program Running on Side1 Accessing Data on Side2
Hello everyone, We have had a strange request that my coworker and I would like group's input on. We are currently working on converting most of our COBOL VSAM programs to be COBOL DB2. Our operations manager is worried about the system resources on our production LPAR. He is concerned that we will not be able to run ONLINE programs and [...]
8345 26 62_Re: DB2 Batch Program Running on Side1 Accessing Data on Side20_31_truman.g.brown@BELLATLANTIC.COM31_Wed, 26 Apr 2000 14:44:05 -0400610_us-ascii You don't say anything about CICS transaction arrival rates, batch/CICS concurrency/contention issues, etc. I've seen a lot of systems that run batch concurrent with CICS without any problems. Why not try a stress test in your test environment?
If VTAM message traffic would be heavy via DDF (lots of small messages back and forth) it could be a performance problem. We once had heavy batch DDF with LOTS of small messages through 3 different VTAM nodes, and the VTAM delay was a sig- nificant part of the batch elapsed time. Solved the problem with regular extracts from the remote which [...]
8372 46 62_Re: DB2 Batch Program Running on Side1 Accessing Data on Side28_Long, Ed15_Ed.Long@FMR.COM31_Wed, 26 Apr 2000 14:35:09 -0400580_- What about Data Sharing?
> -----Original Message----- > From: Bruce Fuller [SMTP:BFuller@EBSCO.COM] > Sent: Wednesday, April 26, 2000 2:21 PM > To: DB2-L@RYCI.COM > Subject: DB2 Batch Program Running on Side1 Accessing Data on Side2 > > Hello everyone, > We have had a strange request that my coworker and I would like group's > input on. We are currently working on converting most of our COBOL VSAM > programs to be COBOL DB2. Our operations manager is worried about the > system resources on our production LPAR. He is concerned that we will not > be able to run [...]
8419 87 12_Re: DSN1COPY12_HEPP SHERY C17_schepp@SRPNET.COM31_Wed, 26 Apr 2000 12:20:39 -0700542_ISO-8859-1 You didn't mention in your note if you ran the recover index utility. You need to do this to verify if the dsn1copy worked correctly. It is during this phase you'll encounter the inconsistent data message if you have data problems. I don't think the reorg will work until the indexes and data are in sync. We use dsn1copy frequently here. If you encounter an error on your recover index verify that the obids are correct and that the table structures are truly in sync with the table structures at the time of the image copy. [...]
8507 38 17_IBM on-line reorg10_Mark Labby16_mlabby@PHEAA.ORG31_Wed, 26 Apr 2000 15:26:21 -0400361_us-ascii We have been converting all of our reorg jobs over to the IBM on-line reorgs using DB2 v5 for OS/390. In setting up the mapping tables and indices, we have found that the space requirements that we need to allow each mapping table to be able to handle the largest tablespace in the job pointing to that mapping table is much larger than expected. [...]
8546 372 42_Re: Performance on using partitioned Index19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 26 Apr 2000 14:20:48 -0500437_ISO-8859-1 Hey Mike, Havin' a bad day mate? Can I "consult" someone for you? Hehe! I've come to rely on your help on DB2-L and I'll be glad to handle any problems keepin' you from it. Go easy on ol' Sekar.S. She/He came to DB2-L for a reason. It may be that her/his DBA is a rookie and has no hope of answering questions of this nature and ol' Sekar was nice enough not to say so. Its hard to compose a good question anyway. G'Day! [...]
8919 14 21_Any CICS or IMS List?20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 26 Apr 2000 15:30:09 EDT315_US-ASCII Hi All, Do anyone know of a CICS or IMS List like this DB2 List?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
8934 52 25_Re: Any CICS or IMS List?16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Wed, 26 Apr 2000 15:33:52 -0400657_us-ascii To: "ims-l (E-mail)" cc: (bcc: Thomas E. Faglon/Telcordia) Subject: LISTPROC documentation
Listproc documentation for the use of IMS-L and managing you subscription can be found at http://www.listproc.net/docs/index.html
The deamon's address is listproc@lists.missouri.edu, the posting address is ims-l@lists.missouri.edu.
Len Rugen HTTP://www.missouri.edu/~rugenl
"Edward C. Benoit Jr." on 04/26/2000 03:30:09 PM
Please respond to DB2 Data Base Discussion List [...]
8987 31 25_Re: Any CICS or IMS List?10_Hill, Dave14_DHill@FSCO.COM31_Wed, 26 Apr 2000 15:34:54 -0400422_iso-8859-1 CICS-L (CICS List (Marist College)). You can join this group by sending the message "sub CICS-L your name" to listserv@vm.marist.edu N.B.: you will have to confirm your subscription, using a control code provided by listserv.
-----Original Message----- From: Edward C. Benoit Jr. [mailto:DB2Automate@AOL.COM] Sent: Wednesday, April 26, 2000 3:30 PM To: DB2-L@RYCI.COM Subject: Any CICS or IMS List? [...]
9019 30 25_Re: Any CICS or IMS List?10_Hill, Dave14_DHill@FSCO.COM31_Wed, 26 Apr 2000 15:35:48 -0400429_iso-8859-1 I forgot your IMS IMS-L (IMS discussion group) You can join this group by sending the message "subscribe IMS-L your name" to listproc@lists.missouri.edu
-----Original Message----- From: Edward C. Benoit Jr. [mailto:DB2Automate@AOL.COM] Sent: Wednesday, April 26, 2000 3:30 PM To: DB2-L@RYCI.COM Subject: Any CICS or IMS List?
Hi All, Do anyone know of a CICS or IMS List like this DB2 List? [...]
9050 28 25_Re: Any CICS or IMS List?15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Wed, 26 Apr 2000 15:45:10 -0400546_us-ascii IMS-L is at listproc@lists.missouri.edu
-----Original Message----- From: Edward C. Benoit Jr. [SMTP:DB2Automate@AOL.COM] Sent: Wednesday, April 26, 2000 3:30 PM To: DB2-L@RYCI.COM Subject: Any CICS or IMS List?
Hi All, Do anyone know of a CICS or IMS List like this DB2 List?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
9079 73 25_Re: Any CICS or IMS List?12_HEPP SHERY C17_schepp@SRPNET.COM31_Wed, 26 Apr 2000 12:41:11 -0700642_ISO-8859-1 Here's a link to a mainframe related discussion groups. You can register for various mainframe related groups.
http://www.nauticom.net/www/softwise/mfdisc.htm
Good luck
Regards,
Shery Hepp SRP Sr. Database Adminstrator Information Services
(602)236-2650 pager (602)275-2508(8035) Dreams-we don't see things as they are, we see things as we are..... Success is getting what you want.....Happiness is wanting what you have...... "The question is not whether we will die, but how we will live." * Joan Borysenko [...]
9153 27 29_Maximum size of an Indexspace13_Olson, Carlos14_COlson@QRS.COM31_Wed, 26 Apr 2000 13:10:27 -0700373_iso-8859-1 Can someone tell me what is the maximum size of an indexspace in OS/390 DB2 V4.1? We just started on our 16th 2 gig VSAM dataset (CRSPRD.DSNDBD.CCDBCRSP.WIMX1001.I0001.A016) on a clustering index and I want to be sure that the limit is not 32 gigabytes. I can't find the limit in appendix A of the SQL Reference guide so please tell where it is documented. [...]
9181 53 59_optimizer use of runstats multi-column frequency statistics0_19_Tim.Lowe@STPAUL.COM31_Wed, 26 Apr 2000 16:17:07 -0500739_us-ascii FYI, If you are gathering multi-column frequency statistics in runstats(For example, FREQVAL NUMCOLS 2 COUNT 10), then you may want to see APAR PQ35742/V5 PTF UQ42355/V6 PTF UQ42356.
From APAR PQ35742: **************************************************************** MULTI-COLUMN FREQUENCIES NOT USED.
PROBLEM DESCRIPTION: Multi-column Frequency statistics not used during access path selection.
When DB2 determines the access path for a particular SQL statement, it was found that certain statistics, namely multi-column frequency statistics, were not being considered. This could result in less efficient access paths being selected than would have been if multi-column statistics had been considered. [...]
9235 128 12_Re: DSN1COPY14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Thu, 27 Apr 2000 07:13:00 +1000397_us-ascii Kaushal, As per Shery's point with the index , remember that if there's a clustering index the REORG will use that index to unload rows from the table unless you specify the SORTDATA keyword in the REORG control cards. It may be interesting to try the REORG specifying SORTDATA (if you currently are not) and see if that works. If it does, then what Shery has suggested is the case. [...]
9364 70 37_SQLCODE -333 on AFTER UPDATE TRIGGER.12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 26 Apr 2000 16:59:24 -0500468_us-ascii Here's an OS/390 DB2 V6.1 trigger discovery.
Table SG01 has a SMALLINT column (GROUP_NUM_) defined as "default" (because I want a zero on unmatched outer joined rows.)
Table SG02 has the same SMALLINT column (GROUP_NUM) defined as "not null" (because its part of the primary key).
Table SG01 has an UPDATE trigger (FIUSG012) which INSERT's an SG02 row, using the SG01 NEW transitional variable for GROUP_NUM, namely: NROW.GROUP_NUM. [...]
9435 52 31_Re: RV: Question about triggers12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 26 Apr 2000 17:15:31 -0500537_us-ascii Daniel,
Yes, your query reached the list.
Regarding #1,
1) I've made an after update trigger on a table, which inserts one row in the same table. The trigger has a WHEN clause which tests the value of a column, and the row inserted by the trigger is asigned a value in this field that avoids recursive calls, but nonetheless I receive the message "The application heap size is not large enough to process this command".Is the trigger working recursively? Is there any other way to trigger this insert? [...]
9488 121 65_Partitioning parent/child should parts & key values be the same ?15_Macleod, Robert23_Robert.Macleod@ICBC.COM31_Wed, 26 Apr 2000 15:25:31 -0700446_iso-8859-1 When partitioning tables in a parent/child relation, should the key values be the same for both parent/child? Does the parent/child have to be partitioned for the same number of parts ?
If so, what are the benefits from doing this ? OR drawbacks from NOT doing this ?
Example : DB2V5-OS/390 Child table previously partitioned (10prts) Index(dec,15) Parent table (should be partitioned...into 10prts ?) Index(dec,15) [...]
9610 34 14_DB2 UDB on AIX24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Wed, 26 Apr 2000 16:09:41 -0700512_- Hi Guys!
We're looking for a contractor with DB2 UDB experience on an AIX operating system. The project involves setting up and tuning a database which will be more than 1 TB in size. The selected individual will also be responsible for developing the in-house staff.
The contract will be in the range of 3 to 6 months. Implementation is currently scheduled for late June, will grow very rapidly, and we expect to perform additional tuning for the first few months following implementation. [...]
9645 15 40_Sample Visual Basic code for DB2V6 BLOBS15_Rooney, Michael15_MRooney@ISO.COM31_Wed, 26 Apr 2000 20:07:35 -0400516_iso-8859-1 We've just installed V6 DB2 for os390 and would be interested in any sample Visual Basic Code (connecting to DB2 via ODBC) that works with BLOB (digital pictures, BMP , JPEG etc). Mainly, insert and retrieval of BLOBs. Any assistance would be greatly appreciated.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9661 398 42_Re: Performance on using partitioned Index14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 27 Apr 2000 10:24:30 +1000392_us-ascii Rick,
I think I orginally decided not to send the answer and then accidentally sent it very late.
I was annoyed actually more by all the valuable time put in by various people with irrelvant answers, although caused by inadequate details in the question. Time is valuable (to some anyway). If someone wants a good answer they had better ask the question properly. [...]
10060 104 69_Re: Partitioning parent/child should parts & key values be the same ?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 27 Apr 2000 10:37:47 +1000581_us-ascii Robert,
The limit keys don't have to match up. The reason is that partitioning limit keys is a physical thing but parent and child relationships is a separate logical thing. However if the number of partitions in the child table is going to be higher than in the parent, I would suggest do not have a child partition that relates to (with parent rows in) multiple parent partitions. i.e. one parent key range split into multiple child key ranges so every parent limit key is also limit key of some child partition. This is to allow for possibility of multiple [...]
10165 52 33_Re: Maximum size of an Indexspace14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 27 Apr 2000 10:44:37 +1000505_iso-8859-1 Carlos
Admin Guide Sect 4.7.13.2 Out of DASD Space or Extent Limit Reached: "[h]owever, no index space or table space can be larger than 64 gigabytes" is as much as I could find.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au
-----Original Message----- From: Olson, Carlos [mailto:COlson@QRS.COM] Sent: Thursday, April 27, 2000 6:10 AM To: DB2-L@RYCI.COM Subject: Maximum size of an Indexspace [...]
10218 34 22_RV: DB2 Instance Hangs18_Centro de Computos21_iplc05@INFOVIA.COM.AR31_Wed, 26 Apr 2000 21:48:38 -0300570_iso-8859-1 ---------- Desde: Administrador Enviado el: Tuesday, April 25, 2000 10:28 PM Para: 'DB2 List' Asunto: DB2 Instance Hangs
Hi all ! Recently we started to upgrade from DB2 UDB v5.2 to v6.1 (under Win NT). Sometimes, when accesing the database in the development environment, it hangs. We are almost sure these is related to the use of a Visual Basic DataSource component, since accessing the database from the Control Center or Command Center is always OK. The issue here is that it only hangs sometimes, and we don´t know why. Any insight on this? [...]
10253 72 27_RV: Question about triggers18_Centro de Computos21_iplc05@INFOVIA.COM.AR31_Wed, 26 Apr 2000 21:46:33 -0300381_iso-8859-1 ---------- Desde: Administrador Enviado el: Tuesday, April 25, 2000 10:20 PM Para: 'DB2 List' Asunto: RV: Question about triggers
Hi everybody !!! I sent this message some days ago, but had no responses, can anyone confirm if it is reaching the list?
TIA
Daniel DBAdmin
INSTITUTO PROVINCIAL DE LOTERIA Y CASINOS BUENOS AIRES - ARGENTINA [...]
10326 37 31_Re: RV: Question about triggers14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 27 Apr 2000 11:18:19 +1000349_iso-8859-1 Daniel,
From the text of the error message it seems to me that you are running a non-OS/390 version of DB2 . You might try posting your query to the comp.databases.ibm-db2 newsgroup, which seems to specialise in those flavours. (Not, of course, that there is any difference between the flavours of the Universal Database :-;) [...]
10364 106 38_Re: Is there a way to get Program Name14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Thu, 27 Apr 2000 11:52:31 +1000507_us-ascii Ken, I haven't tried it but I have an idea you might like to try. I'll attach two recent posts, one from DB2-L and one from TSO-REXX. I think a combination of the two may solve your problems. Basically you will need to add a step prior to your batch program in which you determine the JOBNAME, JOB NUMBER (or whatever) and use it to write to a dataset that you then read in the batch step. Yes it does mean a slight change to the batch code, but you only need to read one line from a file and [...]
10471 68 33_Re: Maximum size of an Indexspace10_Leo Flores23_leoflores@EARTHLINK.NET31_Wed, 26 Apr 2000 19:19:53 -0700296_us-ascii According to my Platinum Reference Guide for DB2 Ver 4 Maximum partition size 1 - 16 parts is limited to 4 gig's each part 17 - 32 parts is limited to 2 gig's each part 33 - 64 parts is limited to 1 gig's each part
HTH Leo Flores
James Campbell wrote: [...]
10540 43 70_Re: Discouraging comments and an observation that is nearly off topic.14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 27 Apr 2000 08:45:15 +0200334_us-ascii Hi Rick, nice to meet you.
I know it's a chinese proverb, but I don't know the author (I suppose it was Confucio's).
However this is not a wish, I worked very well in my previous company. But in my opinion
the phrase 'UNIX do it better at less cost' (I read many 'white papers' about UNIX/mainframe [...]
10584 158 18_Re: DB2 V6 Upgrade18_Michael Arlebrandt28_micke_arlebrandt@HOTMAIL.COM30_Thu, 27 Apr 2000 09:20:21 CEST414_- Hi, there is an info APAR II12343 saying
DB2 V6 RML (RECOMMENDED MAINTENANCE LEVEL) SMC0014 INFORMATION
and according to this it says that PDO (level 0014) or PUT 0003 will bring the system up to the RML level.
We have migrated most of our DB2 systems to version 6 but only have run for a couple of weeks so we have not tested any of the new functionalities, except for the bad ones... [...]
10743 36 25_Re: Any CICS or IMS List?19_Pedro Correia (DSI)27_TE00102@MUNDIALCONFIANCA.PT31_Thu, 27 Apr 2000 08:32:14 +0200667_- Hi Edward
Yes exists a similar list for CICS. You can subscrive for this
listserv@uga.cc.uga.edu
Regards Pedro Correia
> -----Original Message----- > From: Edward C. Benoit Jr. [SMTP:DB2Automate@AOL.COM] > Sent: Wednesday, April 26, 2000 9:30 PM > To: DB2-L@RYCI.COM > Subject: Any CICS or IMS List? > > Hi All, > Do anyone know of a CICS or IMS List like this DB2 List? > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can > be reached at DB2-L-REQUEST@RYCI.COM. [...]
10780 88 41_Re: SQLCODE -333 on AFTER UPDATE TRIGGER.5_VCEI,14_VCEI@CEGEKA.BE31_Thu, 27 Apr 2000 09:33:55 +0200463_iso-8859-1 No experience with triggers and maybe I miscomprehended, but you use "default", because you "want a zero on unmatched outer joined rows". To my knowledge default value is only used when rows get inserted or loaded. But maybe things have changed in V6 ?
-----Original Message----- From: Steve Grimes [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: woensdag 26 april 2000 23:59 To: DB2-L@RYCI.COM Subject: SQLCODE -333 on AFTER UPDATE TRIGGER. [...]
10869 161 31_Re: -911's with Online Reorg V50_18_mebert@AMADEUS.NET31_Thu, 27 Apr 2000 10:05:49 +0100478_us-ascii This is not quite true: when you do an OLR of a single partition of a partitioned TS, then the BUILD2 phase will disable the access to the logical partition of the NPI(s) that is being reorg'd (the RIDs that point to the reorg'd partition). The logical partition of the NPI(s) will then be in RECP status, and you will get a "Resource unavailable" message, not a timeout. If you do a full TS OLR, there is no BUILD2 phase, and the NPI is not updated, but rebuilt. [...]
11031 22 39_DB2 for NT Control Center connect error15_Jeffery A Price17_jprice@IPALCO.COM31_Thu, 27 Apr 2000 06:25:23 -0500379_us-ascii We have 3 DB2 subsystems, and each one has a profile defined via CCA. However, the seurity is verified at the client side, i.e., the userid and password is the same for all three subsystems (in our case, it is the same as the NT userid and password).
HTH, Jeffery A. Price Associate Engineer Indianapolis Power and Light Co. (317) 261-5010 jprice@ipalco.com [...]
11054 104 11_Re: backups13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Thu, 27 Apr 2000 07:39:03 -0400409_us-ascii thanks Greg for your reply, I tried to do an offline backup but it gave the same error. After changing the parameters, I stopped and restarted DB2. I got the same. Over night the system was re-cycled. and the next morning, the backups went fine... I still do not know what happened. What is the difference between stopping and starting DB2 and having the system do it over night??? again thanks [...]
11159 90 11_Re: backups13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Thu, 27 Apr 2000 07:40:42 -0400587_us-ascii thanks Umair I got it to work, but only after the db2 system was re-cycled overnight. I had stopped and restarted the db2 but got the same messages.. Do not know what happens when the system is re-cycled... again thanks
Umair Hussain wrote:
> -db2 update db cfg for db using logretain on > -force applications > At this point database will be placed in backup pending state and you will > be forced to do a complete offline database back before proceeding any > further. Once completed then you could do your tablespace level backups > (although not [...]
11250 51 43_standby DB2 using real production data sets13_Martin Kenney25_martin.kenney@RAILINC.COM31_Thu, 27 Apr 2000 07:58:07 -0400571_us-ascii We are currently making our production DB2 available during scheduled maintenance windows by doing the following: 1) Start all spaced in RO in production DB2 2) Cleanly shut down production DB2 3) Shut down the production LPAR 4) Bring up backup LPAR 5) Bring up backup DB2 pointing to all of our production DB2 data sets (system linear, logs, etc.) giving our customers read access to their applications. 6) Shut down backup DB2 and LPAR 7) Bring up production LPAR and DB2 pointing to the same data sets (system, linear, logs, etc. used on backup system. [...]
11302 425 42_Re: Performance on using partitioned Index11_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 27 Apr 2000 06:36:14 PDT545_- I agree heartily. The only bad question is the one that is not asked. We are all going to be in trouble if people become afraid to ask questions because they are going to be jumped on for doing so (because someone else thinks it a bad question). No one knows everything. Over the years I have noticed that some people are afraid to ask questions because they seem to think it makes them look inferior; and in a competitive climate people are always trying to get a "leg up." From a practical standpoint, people who have been working with [...]
11728 27 42_Re: Performance on using partitioned Index14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 27 Apr 2000 15:55:46 +0200390_us-ascii I'm well awared I don't know everything, and for this reason every question, even a (apparently)
very simple question is useful as I noted that sometimes to respond to these 'simple' questions
many people have to read manuals again....a good chance to 'refresh' some concepts
you read when Paleoctopus Newboldi was cheerfully swimming in late Cretaceous. [...]
11756 128 41_Re: SQLCODE -333 on AFTER UPDATE TRIGGER.12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 27 Apr 2000 09:26:17 -0500376_us-ascii I'm sorry, let me clarify "wanted a zero on unmatched outer joined rows". This was on an Update of the first table (SG01) using a SET with sub-select, where the sub-selected table contained only a subset of the keys in SG01.
Thanks.
SG ---------------------- Forwarded by Steve Grimes/Systems/ais on 04/27/2000 09:15 AM --------------------------- [...]
11885 106 47_Re: standby DB2 using real production data sets15_David A. Zelmer25_david.zelmer@CITICORP.COM31_Thu, 27 Apr 2000 09:46:39 -0500579_us-ascii Martin,
We do this all the time without any problems. Our datacenter(s) have 2 to 3 production LPARs each, with each LPAR running on a separate machine. All the Dasd is shared between the LPARs. When maintenance is scheduled for system "A", all activity on "A" is brought down in a normal fashion and system "A" has it's maintenance done, i.e. hardware changes and/or IPL. While "A" is down, the DB2 system that was running on "A", say DB2A, is brought up on system "B". DB2A comes up without error and production online/batch is run against it. We use CICS [...]
11992 29 14_DB2V6 or DB2V713_Martin Kenney25_martin.kenney@RAILINC.COM31_Thu, 27 Apr 2000 10:57:02 -0400574_us-ascii Our shop was planning to begin our upgrade process from DB2V5 to DB2V6 sometime after August 1999. The DB2V7 release guide states the following:
DB2 for OS/390 version 7 supports migration from either a Version 5 or a Version 6 subsystem.
Our primary reason to upgrade to DB2V6 was to stay current. Because of this we are wondering how many people were planning on migrating from DB2V5 to DB2V7. If we did that we would only push our actual upgrade back around 5 months because we prefer to give new releases at least a 6 month 'burn in period'. [...]
12022 14 53_Re: standby DB2 using real production data sets--txs!8_Bob Abad16_BobRabad@AOL.COM29_Thu, 27 Apr 2000 11:12:59 EDT351_US-ASCII David & Martin, thanks for these valuable info....Will keep in mind for future 'real' 24 x 7 SLAs...
================================================ 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.
12037 48 30_DB2V6 upgrade and NETDATA/JDBC12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 27 Apr 2000 08:35:03 -0700448_us-ascii In the upgrade to V6 that my client is performing right now, we ran into an interesting problem with that upgrade. As part of the SERVER PAC that IBM shipped, it updates some Unix System Services HFS files: /usr/lpp/db2 and /usr/lpp/netdata. The catch is that these are the same HFS mount points that are used in Version 5. Thus to upgrade to V6 we had to delete the files that were created in V5 and reallocate the new files for V6. [...]
12086 40 38_Re: Is there a way to get Program Name9_Bruce,Mae26_BruceM@MAIL.OA.STATE.MO.US31_Thu, 27 Apr 2000 10:37:11 -0500426_iso-8859-1 One of our coding standards is for each program to have an 8-byte working storage field defined that contains the program name.
Mae Bruce State of Missouri OA/Division of Information Services Phone: (573) 522-2489 Fax: (573) 751-3229
-----Original Message----- From: Ken Paris [mailto:KenParis@LVCM.COM] Sent: Wednesday, April 26, 2000 8:47 AM Subject: Is there a way to get Program Name [...]
12127 37 31_A couple of basic DB2 questions14_Joseph Stanton26_jstanton@DELTADENTALNJ.COM31_Thu, 27 Apr 2000 11:31:58 -0400476_- Greetings DB2 gurus, I'm a new guy on the list and hope I've come to the right place. I'll soon find out. Please bear with me. A little intro: I am the sys prog in a VSE shop, no VM, no DB2(VSAM and flat seq files only) . We presently run VSE 2.2 in 3 LPARS. We are developing a migration plan to take us to VSE 2.4 in our 2 production LPARs and 2.5 in the 3rd test LPAR. We also have a number of c/s apps running on NT, HP, and SUN. All are running Oracle. The 'plan' [...]
12165 68 34_Re: DB2V6 upgrade and NETDATA/JDBC15_Zander, Barb J.19_bzander@STATE.ND.US31_Thu, 27 Apr 2000 10:53:18 -0500418_ISO-8859-1 Myron, When I converted I just created new files and had the Unix Services mountpoint point to them. Worked fine. Then when I was ready to go production just renamed the files and used the old mountpoints.
Barb
-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Thursday, April 27, 2000 10:35 AM To: DB2-L@RYCI.COM Subject: DB2V6 upgrade and NETDATA/JDBC [...]
12234 103 34_Re: DB2V6 upgrade and NETDATA/JDBC12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 27 Apr 2000 09:00:22 -0700528_us-ascii How did you run DB2 with both V5 and V6 at the same time with the mountpoint pointing to one set or the other? Only one mountpoint. And with NETDATA how did you have two versions of it, one pointing to the mountpoint pointing to V6 and the other to V5 at the same time? I'm confused. We don't see how. And IBM told us the same thing. --- "Zander, Barb J." wrote: > Myron, > When I converted I just created new files and had > the Unix > Services mountpoint point to them. Worked fine. Then > [...]
12338 70 22_compression dictionary12_HEPP SHERY C17_schepp@SRPNET.COM31_Thu, 27 Apr 2000 09:08:06 -0700605_ISO-8859-1 Hi all- I have a question concerning the compression dictionary.
When you compress a tablespace and build your compression dictionary using the reorg utility is it beneficial/necessary to periodically rebuild your compression dictionary? IBM's reorg allows you to specify KEEP DICTIONARY or it will rebuild the dictionary. We have a 3rd party tool that doesn't have this option and will never rebuild the compression dictionary. This may be a non issue- I was just curious if your data is changing over time would it be wise to periodically rebuild your compression dictionary? TIA [...]
12409 80 34_Re: DB2V6 upgrade and NETDATA/JDBC0_17_sjvagnier@AEP.COM31_Thu, 27 Apr 2000 12:10:39 -0400327_us-ascii Hello Myron,
I am in the process of upgrading DB2 to V6 level 0003 on a test LPAR but haven't upgraded the NETDATA or JDBC features yet. Unfortunately, we do use JDBC in production, so your e-mail is definitely a big concern for us.
Did IBM indicate when they would have a solution the the problem? [...]
12490 125 34_Re: DB2V6 upgrade and NETDATA/JDBC15_Zander, Barb J.19_bzander@STATE.ND.US31_Thu, 27 Apr 2000 11:10:39 -0500436_ISO-8859-1 I did not run them both at the same time but I did have both sets of libraries out there and mounted at the same time. I did not delete V5 to load V6. You can make the V6 mountpoint different to run the load (ex. /db61/usr/lpp/db2) and point this to the V6 dataset. I then ran all the SMPE etc pointing to the new datasets. Then when I was ready to cut over just unmounted and renamed datasets. I installed using a PDO. [...]
12616 129 34_Re: DB2V6 upgrade and NETDATA/JDBC15_Zander, Barb J.19_bzander@STATE.ND.US31_Thu, 27 Apr 2000 11:21:41 -0500345_ISO-8859-1 Myron, I think the big difference is that I used a PDO and you have a serverpac. I talked to our MVS sysprog that does the OS/390 install which comes as a serverpac. He says in the custompac dialogs under variables there is a parm that says which directory to use for HFS files that points to where the HFS files will be loaded. [...]
12746 45 35_Re: A couple of basic DB2 questions14_Nancy Stafford24_nancy.stafford@AFBIC.COM31_Thu, 27 Apr 2000 11:22:04 -0500501_us-ascii There is a newsgroup I have found that deals specifically with DB2 on VSE and VM. It is ibm.software.db2.vse-vm .
Joseph Stanton wrote:
> Greetings DB2 gurus, > I'm a new guy on the list and hope I've come to the right place. I'll soon > find out. Please bear with me. > A little intro: I am the sys prog in a VSE shop, no VM, no DB2(VSAM and > flat seq files only) . We presently run VSE 2.2 in 3 LPARS. We are > developing a migration plan to take us to VSE 2.4 in our 2 [...]
12792 95 26_Re: compression dictionary14_John P Shipley24_jpshiple@DUKE-ENERGY.COM31_Thu, 27 Apr 2000 12:51:10 -0400357_us-ascii If you have any reason to believe that data has changed significantly then it might be a good idea. Otherwise I would probably not rebuild it every time. Also if you use a log extraction tool, they may get irritated when the dictionary changes.
HEPP SHERY C on 04/27/2000 12:08:06 PM [...]
12888 104 26_Re: compression dictionary0_31_truman.g.brown@BELLATLANTIC.COM31_Thu, 27 Apr 2000 12:37:20 -0400479_us-ascii I think the answer to this lies in the dynamics of the data. Do many columns change significantly via updates between reorgs, or is the nature of the data changing over time?
"it depends..."
"HEPP SHERY C" on 04/27/2000 12:08:06 PM
Please respond to "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM
cc: (bcc: TRUMAN G. BROWN/EMPL/MD/Bell-Atl) [...]
12993 106 26_Re: compression dictionary15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Thu, 27 Apr 2000 12:07:29 -0500490_ISO-8859-1 There are two reasons you might want to be able to rebuild a dictionary that I can think of off the top of my head.
The first is when you have first loaded a table with a small amount of data and so either no dictionary was built or one based on a small sample. Once a tablespace has a dictionary built, it is fixed and LOAD RESUME runs will not add to it, nor will DB2 insert activity. In this case you would want/need a reorg to build a new compression dictionary. [...]
13100 126 26_Re: compression dictionary9_Don Alden26_Don.Alden@PKSIS.LEVEL3.COM31_Thu, 27 Apr 2000 11:13:08 -0600590_iso-8859-1 Howdy Shery,
When a compressed DB2 Tablespace is unloaded during the Unload Phase of the REORG the data is decompressed so that Index Values can be extracted. When the REORG commences the Reload, this uncompressed data must be Re-compressed thus driving-up the CPU time requirement.
If you were to use the KEEPDICTIONARY parameter the re-compression would be skipped thus saving significant CPU time. Thus, as you can see, KEEPDICTIONARY is a good choice if the characteristics of the data have not changed with respect to data compression when doing a REORG. [...]
13227 127 26_Re: compression dictionary14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 28 Apr 2000 03:21:34 +1000538_us-ascii Chris made some good points. I experienced a problem where partition was initially empty or nearly and later had a very large number of rows added (resumed) with a very poor compression dictionary causing me to have problems with likely overflowing 4 Gig limit on partition. Reorg of the partition would absolutely need to build a new better compression dictionary to drop down the partition down to half the number of pages (in my case). Keep Dictionary may be a useful option but I would not want to be forced to keep it! [...]
13355 127 34_Re: DB2V6 upgrade and NETDATA/JDBC12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 27 Apr 2000 10:27:00 -0700279_us-ascii Not really. I just talked with them again about this topic this morning. We have an open PMR on this topic. The IBM'er I talked to indicated that NETDATA was the biggest problem. He had a workaround as long as you didn't need to use a different version of NETDATA. [...]
13483 188 26_Re: compression dictionary12_HEPP SHERY C17_schepp@SRPNET.COM31_Thu, 27 Apr 2000 10:29:41 -0700450_ISO-8859-1 Thanks to all of you who replied to my question.
Regards,
Shery Hepp SRP Sr. Database Adminstrator Information Services
(602)236-2650 pager (602)275-2508(8035) Dreams-we don't see things as they are, we see things as we are..... Success is getting what you want.....Happiness is wanting what you have...... "The question is not whether we will die, but how we will live." * Joan Borysenko [...]
13672 175 34_Re: DB2V6 upgrade and NETDATA/JDBC12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 27 Apr 2000 10:34:10 -0700343_us-ascii As part of the serverpac for DB2 V6 that we received, there weren't any parms to decide where to put it. The documentation just stated to put it on the /usr directories. We could have manually changed it and then created a bunch of new profiles etc. But nothing in the serverpac that we received had any customization like that. [...]
13848 70 57_Re: MVS/OS390 Generating unique row identifiers - how to?8_Rob Lake20_robert.lake@CONTI.DE31_Thu, 27 Apr 2000 12:24:43 -0500409_- Ignoring performance/concurrency implications - some possibilities of the top of my head if you are using DB2 UDB for OS/390 V6.1 are :
1) Use the IDENTITY column attribute available as new function support through APAR PQ30652/PTF UQ38405.
2) Use a column with the ROWID data type if all you want is uniqueness. (Note that it uses 17 bytes internally - somewhat longer than an INTEGER). [...]
13919 25 39_-101 sqlcodes after migration to DB2 V613_John Arbogast16_jfarbo@YAHOO.COM31_Thu, 27 Apr 2000 10:55:26 -0700456_us-ascii As I reported before, we are experiencing -101s on simple singleton selects. On advice from IBM we bound our plans/packages receiving the error with NOREOPT(VARS) parm (the default). We then decided to bind the plans/packages with their production bind cards. We seem to now be rid of our -101s regardless of the NOREOPT/REOPT(VARS) parameter. Has anyone else experienced this?? The plans and packages seem to double in size?? Any insights?? [...]
13945 40 27_-911's with Online Reorg V513_Matheny, Bill25_bill.matheny@EXPERIAN.COM31_Thu, 27 Apr 2000 10:52:49 -0700584_- Mark,
I'd suggest reorging any PARTITIONED tables by individual partition if you don't have an NPI; otherwise, the switching phase takes SO long that you'll never get rid of the -911's. For each data and index dataset at least 2 renames have to take place (I0001 to T0001; and S0001 to I0001), each taking up to 2 seconds (according to IBM, but could be longer based up the condition of your catalog). If you have a large number of partitions, this becomes even more important, since the elapsed time becomes extremely elongated. We had a reorg doing 64 partitions take [...]
13986 157 34_Re: DB2V6 upgrade and NETDATA/JDBC0_17_sjvagnier@AEP.COM31_Thu, 27 Apr 2000 14:33:18 -0400472_us-ascii I just finished having this dicussion with one of our MVS/UNIX sysprog's and she basically echoed the same comments for the workaround for NETDATA and JDBC.
Thanks for the info.....
Steve Vagnier
Myron Miller on 04/27/2000 01:27:00 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Stephen J Vagnier/OR1/AEPIN) [...]
14144 37 27_Query tuning index question15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Thu, 27 Apr 2000 12:56:11 -0700591_iso-8859-1 DB2 V5 OS/390
The query below uses a nested loop join, doing a non matching index tablespace scan on cae_mtrd_adj as the outer table (method 1, accesstype I, matchcols 0, accessname blank, prefetch S). Access to the inner table is by accesstype I, matchcols 3 on the three join predicates. So my question is this; would I be better off to add an index to the outer table on tran_dte, add tran_dte to the existing outer table index that currently consists of the three join predicate columns and believe that index screening will also happen, or do nothing because the [...]
14182 49 82_Re: IDUG 12th Annual North American Conference May 14 - May 18, 2000 Dallas, Texas12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 27 Apr 2000 15:57:03 -0500552_us-ascii I'll meet with the DB2-L group at lunch on Tuesday.
Philip Gunning on 04/12/2000 09:05:24 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Kirk Hampton/Texas Utilities) Subject: IDUG 12th Annual North American Conference May 14 - May 18, 2000 Dallas, Texas
Greetings! For those DB2-L subscribers attending this year, the following arrangements have been made with IDUG Headquarters: [...]
14232 67 83_Re: IDUG 12th Annual North American Conference May 14 - May 18, 2 000 Dallas, Texas8_Long, Ed15_Ed.Long@FMR.COM31_Thu, 27 Apr 2000 17:00:38 -0400594_- I'll be the guy with a bag over my head (Celtics fan in withdrawal).
> -----Original Message----- > From: Kirk Hampton [SMTP:khampto1@TXU.COM] > Sent: Thursday, April 27, 2000 4:57 PM > To: DB2-L@RYCI.COM > Subject: Re: IDUG 12th Annual North American Conference May 14 - May > 18, 2000 Dallas, Texas > > I'll meet with the DB2-L group at lunch on Tuesday. > > > > > > > Philip Gunning on 04/12/2000 09:05:24 AM > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: (bcc: Kirk Hampton/Texas Utilities) > Subject: [...]
14300 31 36_Duplicate on table with unique index15_Philip, Sibimon27_Sibimon_Philip@CSXLINES.COM31_Thu, 27 Apr 2000 17:17:46 -0400517_iso-8859-1 To all,
I have table TAB1 with unique index on COL1. I use a query like
select col1, count(*) from tab1 group by col1 have count(*) > 1
to find the duplicate. Since this use the index on COL1, it is telling there is no duplicate. But when I unload this table to SQL server it is telling there is duplicate. Is there anyway, can I make this query to do a table space scan to get the result instead of an index scan. As a last choice, I may use CHECK utility to find the duplicate. [...]
14332 51 40_Re: Duplicate on table with unique index24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 27 Apr 2000 14:27:17 -0700552_- I'd try adding a where clause like:
Where COL2 = COL2
or
Where COL2 like '%'
> -----Original Message----- > From: Philip, Sibimon [SMTP:Sibimon_Philip@CSXLINES.COM] > Sent: Thursday, April 27, 2000 2:18 PM > To: DB2-L@RYCI.COM > Subject: Duplicate on table with unique index > > To all, > > I have table TAB1 with unique index on COL1. I use a query like > > select col1, count(*) > from tab1 > group by col1 > have count(*) > 1 > > to find the duplicate. Since this use the index on COL1, it is telling > there > is [...]
14384 74 26_Re: RV: DB2 Instance Hangs10_Mike Wiles14_mwiles@UCG.COM31_Thu, 27 Apr 2000 17:32:24 -0400464_iso-8859-1 Hi Daniel!
This isn't exactly the same problem, but it may be related...
A few weeks ago, we upgraded a database to 6.1 from 5.2. After the upgrade, whenever any client connected to this database, it would lock a particular table, so that no one else had _any_ access to it. We then upgraded all of our clients to 6.1 (which we had hoped, out of sheer laziness, that we wouldn't have to do. ;)) and then everything worked fine again. [...]
14459 101 40_Re: Duplicate on table with unique index0_19_Tim.Lowe@STPAUL.COM31_Thu, 27 Apr 2000 16:41:12 -0500541_us-ascii Philip, I think that if I suspect that an index has a problem, then I would start with a CHECK INDEX utility to make sure that this is the problem. This utility is very fast, and it would immediately tell you if this is the problem.
If the index is corrupted (duplicates do exist), then you could drop the index, and then run your query. (if it is corrupted, then why not drop it?) But, once you have the key that is a duplicate, are you going to delete both records, or just one? (What would your delete statement look [...]
14561 51 40_Re: Duplicate on table with unique index0_18_NDaley@CINERGY.COM31_Thu, 27 Apr 2000 18:01:18 -0400433_iso-8859-1 Philip, I've seen this happen when the DB2 data contains mixed upper/lower case and considers them to be different, where SQLserver considers them to be the same (like "Data" and "data").
Norm Daley Cinergy Corp.
-----Original Message----- From: Philip, Sibimon [mailto:Sibimon_Philip@CSXLINES.COM] Sent: Thursday, April 27, 2000 5:18 PM To: DB2-L@RYCI.COM Subject: Duplicate on table with unique index [...]
14613 156 40_Re: Duplicate on table with unique index12_HEPP SHERY C17_schepp@SRPNET.COM31_Thu, 27 Apr 2000 15:00:49 -0700520_ISO-8859-1 Did you have any load resume utilities that may have ended abnormally and the tablespace wasn't recovered properly afterwards?
Regards,
Shery Hepp SRP Sr. Database Adminstrator Information Services
(602)236-2650 pager (602)275-2508(8035) Dreams-we don't see things as they are, we see things as we are..... Success is getting what you want.....Happiness is wanting what you have...... "The question is not whether we will die, but how we will live." * Joan Borysenko [...]
14770 239 47_Re: standby DB2 using real production data sets12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Thu, 27 Apr 2000 18:24:33 -0400578_iso-8859-1 Yes, we have multiple LPARs running, and we often shut a DB2 subsystem down on one and start up on another for various reasons. We run batch and online, CICS and DDF, update & read, regardless of where it's at.
I'm a little confused about your terminology of the "backup" DB2 though. It's the same subsystem, just started in a different place if you're using the same datasets via shared dasd (Is your DASD shared between these systems?). As long at the everything's catalogued on both systems, then you have no worries as far as DB2 is concerned. You do [...]
15010 36 29_UDB Version 5 SAMPLE Database9_Don Alden26_Don.Alden@PKSIS.LEVEL3.COM31_Thu, 27 Apr 2000 17:14:31 -0600509_iso-8859-1 Upon completion of installation of UDB 5 Personal Edition on my NT workstation, I bring-up the First Steps Panel and select "Create SAMPLE Database". I then get a Warning message telling me that selecting this option will take several minutes.
When I OK this option I don't receive any kind of message that it is running etc. When I try to launch the create again I get a message that "the SAMPLE database in being created in the current instance" and the "First Steps" panel reapears. [...]
15047 78 27_JDBC to connect to DB2/390.13_Morrill, John12_JohnM@VP.NET31_Thu, 27 Apr 2000 18:16:28 -0600493_iso-8859-1
-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Thursday, April 27, 2000 6:01 PM To: 'DB2-L Request at RYCI (E-mail)' Subject: Thanks and 1st Question
Hi,
If I have a browser based application running on let's say NT that wants to use JDBC to connect to DB2/390. When they issue the jdbc:db2os390: is the location the DB2 subsystem name or the name of the local host as specified in /etc/hosts. [...]
15126 70 46_REPOST (sans HTML): JDBC to connect to DB2/39013_Morrill, John12_JohnM@VP.NET31_Thu, 27 Apr 2000 18:18:39 -0600381_iso-8859-1
-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Thursday, April 27, 2000 6:01 PM To: 'DB2-L Request at RYCI (E-mail)' Subject: Thanks and 1st Question
Hi, If I have a browser based application running on let's say NT that wants to use JDBC to connect to DB2/390. When they issue the jdbc:db2os390: [...]
15197 59 33_Re: UDB Version 5 SAMPLE Database11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Fri, 28 Apr 2000 08:33:02 +0800445_us-ascii Do you have DB2 Control Center? Thru Control Center you should be able to find out whether the Sample database had been created successfully.
Don Alden on 28/04/2000 07:14:31 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: ROLAND CHUA CHONG KEE/DATACEN/IT/SGX) Subject: UDB Version 5 SAMPLE Database [...]
15257 74 27_Query tuning index question14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 28 Apr 2000 11:18:26 +1000575_us-ascii Sandi,
Of course the answer 'depends' on a few things:
1. How often will it be executed. Cost of scanning 8K+ pages is not high if not executed often. But then you probably wouldn't be asking.
2. What is the filtering by TRAN_DTE. Assuming a TRAN_DTE index will not be well clustered, new index will be useful only if the filtering limits the rows hit to somewhat less than 8K rows, i.e. less than 1 row per page to make list Prefetch potentially out perform the TS Scan. However note that no need to be scared of adding additional indexes [...]
15332 42 0_14_Dmitriy Bobrov16_wertor@TICON.NET31_Thu, 27 Apr 2000 21:34:03 -0500136_iso-8859-1 Is anybody have any information about standard existing interfaces between UNIX RS600 boxes and DB2 database?
15375 112 28_Re: Compression CPU overhead15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 27 Apr 2000 05:42:09 -0500377_us-ascii The information from the tests below occurred on a 9672-R75 (7 CP @ 65 mips). MVS Omegamon verified that the CMPSC hardware instruction was getting hit 33% of the time for CPU TCB inspection samples. The CVT flag bit also verifies that the hardware compression feature IS installed. So, everything came out as I had mentioned a few months back. No surprise here. [...]
15488 41 18_2gb question again14_Backes,Michael26_BackeM@MAIL.OA.STATE.MO.US31_Thu, 27 Apr 2000 22:16:55 -0500530_iso-8859-1 we are running db2 v5.1, not sure of the os390 version,
i have a tablespace that i am allocating at 2863444 priqty(approx 2.8 gb i think) from what i understand the 2gb limit was a vsam limitation, and since i(db2) is allocating a vsam file larger than 2gb, i am pretty sure we are not limited at 2gb. however it is my understanding that even though the 2 gb limit is no loger there for the vsam dataset, in db2 v5.1, if the a001 dataset is over 2gb(in my case) or extends to 2gb or past, db2 will create a [...]
15530 84 28_Re: Compression CPU overhead15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 27 Apr 2000 05:55:36 -0500602_us-ascii I forgot one more thing. What was the overall row length (uncompressed) for this test. I would be curious to see how linear decompression is with respect to row length. It probably isn't as their is a lot of other CPU wrapped around the CMPSC instruction.
Jim Lewandowski
Stovall, Martin wrote: > > Does anyone else experience the CPU overhead that this test showed? I have > asked the hardware/system's group and the machine supposedly has > The hardware compression assist feature. Also, is there any flaw that anyone > sees in this test?? > > I ran the following [...]
15615 21 42_TRACE THE CICS COMMAND IN C ONLINE PRIGRAM10_young huyi21_young_hui@HOTMAIL.COM29_Thu, 27 Apr 2000 20:21:33 PDT487_- HI FOLKS, I WRITE A ONLINE PROGRAM IN C LANGUAGE(C/VSE WITH LE/VSE ENVIRONMENT), I COMPILE THIS PROGRAM WITH 'EDF' TRANSLATOR OPTION. THIS PROGRAM RUN OK,BUT WHEN I TRY TO TRACE THE 'CICS COMMAND IN THE PROGRAM' WITH 'CEDF TRANSACTION' ,NO CICS COMMAND WAS TRACED ,CAN ANYONE TELL ME WHAT HAPPEN AND HOW TO FIX IT. THANK IN ADVANCED. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com [...]
15637 90 20_Re: SAP DBA GOOD/BAD23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 28 Apr 2000 06:19:31 +0100405_iso-8859-1 Cliff not that this is the kind of question that can be answered here .. but briefly and as best and impartial as I can here are my thoughts.
Whilst I was not a SAP DB2 DBA when the transfer of the SAP project at my site was completed, from Oracle to DB2, I am aware of the work that was involved and in particular the events as they unfolded after the cut over - thanks Adrian :-) [...]
15728 33 32_S978 error in PLATINUM QUICKCOPY14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 28 Apr 2000 09:01:46 +0200376_us-ascii Esteemed list, the question may be out of theme, but I would like to sound if someone met the
same problem because this error may become a big problem for us.
Our affiliate company is using for first time PLATINUM Quickcopy and, suddenly, they met an
S978 error during a FREEMAIN instruction for a dynamic allocation of copy file. Technical [...]
15762 59 13_REORG PROBLEM11_Stefan Geus25_stefan.geus@HUK-COBURG.DE31_Fri, 28 Apr 2000 11:22:02 +0100372_us-ascii Hi all,
I post This for a teammate:
Urgent Question!!!!!!
the latest trick for DB2 OS390 V 5.1 V5R1M0 ===>>>> How to generate a Unique Index with a Table and Nonunique Data <<<<===
Following scenario:
Suppose you have a table (approx. 12 mill. Rows) with a unique index on COL1, COL2. You try to reorg with [...]
15822 75 47_Re: standby DB2 using real production data sets12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 28 Apr 2000 12:44:17 +0200364_x-user-defined Hi,
No problem, at all. We do it just fine with RW. you need to be sure that your operators (or any other person) won't start the DB2 subsys on the other LPAR before the original was stopped (we had it ones... not a nice story). We now do VARY OFFLINE/ONLINE to disks involved with DB2 data, BSDS, LOGS etc. just to prevent any problem. [...]
15898 106 47_Re: standby DB2 using real production data sets12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Fri, 28 Apr 2000 11:12:00 +0100577_- We have changed the started task JCL to allocate a dummy dataset witha disp of OLD to prevent any mishaps.
Colin. ---------- From: Isaac Yassin To: DB2-L@RYCI.COM Subject: Re: standby DB2 using real production data sets Date: 28 April 2000 11:44
Hi,
No problem, at all. We do it just fine with RW. you need to be sure that your operators (or any other person) won't start the DB2 subsys on the other LPAR before the original was stopped (we had it ones... not a nice story). We now do VARY OFFLINE/ONLINE to disks involved with DB2 data, BSDS, LOGS [...]
16005 21 16_Which Member ???32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Fri, 28 Apr 2000 17:04:37 +0300316_- If there is more than one DB2 Member in a single MVS Image, which member will be chosen from the Batch job, which accesses with group attach name. For example, In MVS Image PRDB, there are two members PDB1 and PDB2. PD01 is the group attach name. If i use DSN SYSTEM(PD01) in JCL which member will be chosen? [...]
16027 36 20_Re: Which Member ???14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Fri, 28 Apr 2000 07:23:36 -0700495_iso-8859-1 If I recall correctly (its been a while since I was in this situation), the subsystem control table is searched in a serial fashion, so the first on located (the first one defined in parmlib) will be used. This may have changed, but this is the most logical method. For this reason, there really isn't much load-balancing that can be done within a single MVS Image. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
16064 45 20_FW: Which Member ???32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Fri, 28 Apr 2000 17:28:21 +0300542_- I hurried up for the question. The answer was in the manuals and here it is. Sorry for it.
FYI...
The answer was in Data Sharing: Planning and Admin. Guide.
If the name on the DSN command is a group attachment name, it constructs a list of DB2 subsystems that are defined to this MVS, and tries to attach to each one in order, until it finds a DB2 subsystem that is started on this MVS, or until it reaches the end of the list. DB2 always attaches to the first started one on the list--there is no load balancing. [...]
16110 267 43_DR- SAP multi-dataset simple 32K tablespace10_Bill Disch23_bill.disch@GENMILLS.COM31_Fri, 28 Apr 2000 10:01:03 -0500435_iso-8859-1 We completed another successful Disaster Recovery Test at our hot site. I say successful because previous problems have disappeared and new glitches show up that need attention. I'll try to be as brief as possible without missing any needed info. Here is the pertinent info for our situation:
OS/390 V1.2 DB2 V5.1 SAP R/2 V6.1G (user defined DB2 datasets) BMC Utilities for DB2 - (Copy+, Load+, Unload+, Reorg+) [...]
16378 29 39_DB2 UDB DBA Contract Opportunity - Ohio0_18_jtulman@MAAINC.COM31_Fri, 28 Apr 2000 11:02:26 -0400580_us-ascii Ladies and Gentlemen, Happy Friday to you all!!! We have a client that is located in the Columbus, Ohio area that has an IMMEDIATE need for a SOLID UDB DB2 DBA on the AIX/RS6000 platform for a 3-6 month minimum contract opportunity. They are looking for someone with 2+ years of UDB experience on the AIX platform as well as any Java or IBM's Visual Age for Java experience as well. This opportunity has the potential for an extended duration as a consultant or possibly go permanent if desired. For IMMEDIATE Consideration, please contact me via one of the methods [...]
16408 33 16_DB2 Log Process.17_Armando Zaporteza25_azaporte@CI.PHOENIX.AZ.US31_Fri, 28 Apr 2000 08:16:33 -0700384_US-ASCII Hi,
I'm new at this thing, However I need help on the DB2 Logging so that we won't run out of Space.
Little bit of History, We're DB2 and Ver. 4(We'll be updating to Ver. 5 soon).Also I'm in the application area and not a DB2 Sys. Programmer.
The problem is we are continually running out of space during the logging process of DB2. [...]
16442 26 28_Re: Compression CPU overhead14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Fri, 28 Apr 2000 11:22:43 -0400521_ISO-8859-1 Exactly how much of the "observed overhead" was due to the Omegamon trace? Tracing is far from free.
Regardsm Joel
Message text written by DB2 Data Base Discussion List >The MVS/Omegamon trace showed 33% of the CPU time spent on the CMPSC instruction. Since the tests showed about 70% overall CPU overhead for decompressing bufferpool rows, the other 37% is probably in extra codepath getting into the DB2 compression module. It also might possible incur GETMAIN/FREEMAIN overhead.< [...]
16469 51 36_Re: S978 error in PLATINUM QUICKCOPY13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 28 Apr 2000 10:37:16 -0500356_US-ASCII Max, with out the system code and reason code for IEA705I its hard to tell. Did you try running the copy with REGION=0M ? Kurt
>>> mscarpa@CESVE.IT 04/28/00 02:01AM >>> Esteemed list, the question may be out of theme, but I would like to sound if someone met the
same problem because this error may become a big problem for us. [...]
16521 74 22_Re: 2gb question again22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Fri, 28 Apr 2000 10:33:39 -0400341_- 1. No. The 2GB limit is a DB2 limit. VSAM has had a 4GB limit since the 1st release of VSAM (late 1960s early 1970s?) - I think? 2. Don't know 3. The 2GB limit is not a VSAM limit. The VSAM limit is 4GB under OS/390 V2.5 & DFSMS V1.4. Yes, I believe newer versions of DFSMS - I don't the version - increased the VSAM limit above 4GB. [...]
16596 57 20_Re: Which Member ???0_17_sjvagnier@AEP.COM31_Fri, 28 Apr 2000 11:51:18 -0400338_us-ascii We don't have our Data Sharing environments setup where we have more than one member on the same MVS Image. But, I think in your case, DB2 would run the Batch Job with the first member entry DB2 hits that matches the Group Name (PD01) in SYS1.PARMLIB(IEFSSNxx).
Hope this helps, Steve Vagnier American Electric Power [...]
16654 107 52_SYSLGRNX and data integrity of dropped tablespaces??15_Stovall, Martin16_MStovall@USG.COM31_Fri, 28 Apr 2000 10:53:56 -0500454_iso-8859-1 I found the following in the SQL REFERENCE (V5) under DROP
# Deleting SYSLGRNX records for dropped table spaces: After dropping a table space, you cannot delete the associated records. If you want to remove the records, you must quiesce the table space, and then run the MODIFY | RECOVERY utility before dropping the table space. If you delete the | SYSLGRNX records and drop the table space, you cannot reclaim the table | space. [...]
16762 101 14_DB2 CONNECTION7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Fri, 28 Apr 2000 13:00:27 -0300493_iso-8859-1 Hi friends.
When trying to connect to a specific database (UDB 6.1 FOR NT) I receive the following message:
The connection test failed.
[IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001 [...]
16864 49 18_Re: DB2 CONNECTION14_Stewart, Brian21_BStewart@NEONSOFT.COM31_Fri, 28 Apr 2000 10:14:15 -0600359_iso-8859-1 Usually when I get this error message it means the server is refusing TCPIP connections because TCPIP isnt properly configured or the server is down. You may not have the /etc/services entries you need, also your DB2COMM variable may not be set to TCPIP. You may want to look at the output from the "db2 get dbm cfg" command. Hope this helps. [...]
16914 21 8_DB2 JDBC14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 28 Apr 2000 12:01:51 -0400525_- Hi,
If I have a browser based application running on let's say NT that wants to use JDBC to connect to DB2/390. When they issue the jdbc:db2os390: is the location the DB2 subsystem name or the name of the local host as specified in /etc/hosts.
Thanks Dean >
================================================ 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.
16936 54 18_Re: DB2 CONNECTION13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Fri, 28 Apr 2000 11:07:19 -0500435_iso-8859-1 Gustavo, A few questions. 1. Are you using the enterprise edition of DB2 Connect? 2. Is this reproducible problem or intermittent? 3. Has it ever worked?
F.Y.I. - we have got this problem and we could not reproduce the error.
Glenn
-----Original Message----- From: Gustavo [mailto:lozano@BANDEIRANTES.COM.BR] Sent: Friday, April 28, 2000 11:00 AM To: DB2-L@RYCI.COM Subject: DB2 CONNECTION [...]
16991 93 22_Re: 2gb question again14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 28 Apr 2000 12:10:23 -0400539_- I thought the 2GB limit was lifted in DB2 V5 ?
> -----Original Message----- > From: Piontkowski Michael ML [SMTP:michael.piontkowski@ASTRAZENECA.COM] > Sent: Friday, April 28, 2000 10:34 AM > To: DB2-L@RYCI.COM > Subject: Re: 2gb question again > > 1. No. The 2GB limit is a DB2 limit. VSAM has had a 4GB limit > since the 1st release of VSAM (late 1960s early 1970s?) - I think? > 2. Don't know > 3. The 2GB limit is not a VSAM limit. The VSAM limit is 4GB under > OS/390 V2.5 & DFSMS V1.4. Yes, I believe newer versions of [...]
17085 27 11_TSO command12_Vernon, John27_John.Vernon@TWC.STATE.TX.US31_Fri, 28 Apr 2000 11:23:56 -0500420_- Recently, someone listed a TSO command that displays a users security profile. I would really appreciate it if someone could pass that back to me!
John Vernon DB2 System Administrator Texas WorkForce Commission 101 East 15th Street Austin, Texas 78778 Vice-President, Heart of Texas DB2 Users Group Email: john.vernon@twc.state.tx.us jvernonrr@aol.com Phone: 512-936-3170 Fax: 512-936-3190 [...]
17113 42 15_Re: TSO command10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Fri, 28 Apr 2000 11:23:29 -0500627_- TSO LISTUSER
> ---------- > From: Vernon, John[SMTP:John.Vernon@TWC.STATE.TX.US] > Reply To: DB2 Data Base Discussion List > Sent: Friday, April 28, 2000 11:23 AM > To: DB2-L@RYCI.COM > Subject: TSO command > > Recently, someone listed a TSO command that displays a users security > profile. I would really appreciate it if someone could pass that back to > me! > > > > John Vernon > DB2 System Administrator > Texas WorkForce Commission > 101 East 15th Street > Austin, Texas 78778 > Vice-President, Heart of Texas DB2 Users Group > Email: john.vernon@twc.state.tx.us > jvernonrr@aol.com > Phone: 512-936-3170 > [...]
17156 36 15_Re: TSO command15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Fri, 28 Apr 2000 17:25:36 +0100732_us-ascii John,
Try 'TSO LU username'.
Best regards,
Gordon Fishwick DB2 Systems Programmer Scottish and Southern Energy plc
********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in [...]
17193 40 15_Re: TSO command13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 28 Apr 2000 11:28:36 -0500311_US-ASCII John, If using RACF you can use TSO LU XXXXX for a user or TSO LG XXXXX for a group. Kurt
>>> John.Vernon@TWC.STATE.TX.US 04/28/00 11:23AM >>> Recently, someone listed a TSO command that displays a users security profile. I would really appreciate it if someone could pass that back to me! [...]
17234 61 15_Re: TSO command0_17_sjvagnier@AEP.COM31_Fri, 28 Apr 2000 12:35:31 -0400442_us-ascii Hello John,
If you are using RACF, I believe the TSO Command is : LU xxxxxxxx where xxxxxxx represents the users RACF user-id. Also, you must be granted "special" on your RACF user-id in order to look at someone's user security.
Hope this helps,
Steve Vagnier American Electric Power DB2 Sys Prog
"Vernon, John" on 04/28/2000 12:23:56 PM [...]
17296 26 43_Can anyone recommend a good DB2 data editor11_Jim Coleman23_Jim.Coleman@STATE.MN.US31_Fri, 28 Apr 2000 11:36:14 -0500422_iso-8859-1 Greetings all,
Can anyone recommend a good DB2 data editor, (especially one that interfaces nicely with BMC Catalog Manager)?
We currently use CA-PLATINUM RC/Update but may soon be losing it. Our users will be sorry to see RC/Update go because it's easy to use for quick manual updates to data without much knowledge of SQL or RDBMS. This replacement editor would be mainly for that purpose. [...]
17323 56 27_question about another list11_Emrah GUVEN28_emrah.guven@PAMUKBANK.COM.TR31_Fri, 28 Apr 2000 19:52:43 +0300151_ISO-8859-9 Hı db2_land , i need a similar list on Oracle , can anybody advise an adress ?! thanks & regards
emrah guven , DBA , pamukbank,Turkey
17380 40 47_Re: Can anyone recommend a good DB2 data editor15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Fri, 28 Apr 2000 12:56:41 -0400678_iso-8859-1 You could try Fileaid for DB2 from Compuware.
-----Original Message----- From: Jim Coleman [mailto:Jim.Coleman@STATE.MN.US] Sent: Friday, April 28, 2000 12:36 PM To: DB2-L@RYCI.COM Subject: Can anyone recommend a good DB2 data editor
Greetings all,
Can anyone recommend a good DB2 data editor, (especially one that interfaces nicely with BMC Catalog Manager)?
We currently use CA-PLATINUM RC/Update but may soon be losing it. Our users will be sorry to see RC/Update go because it's easy to use for quick manual updates to data without much knowledge of SQL or RDBMS. This replacement editor would be mainly for that purpose. [...]
17421 45 47_Re: Can anyone recommend a good DB2 data editor16_Swinski, Kenneth32_KSwinski@INTERNAL.MASSMUTUAL.COM31_Fri, 28 Apr 2000 13:18:04 -0400651_us-ascii Princeton Softech Access for DB2 is a relational DB2 data editor that interfaces very nicely with BMC Catalog Manager. Here's the product's web address: http://www.princetonsoftech.com/index.asp
> -----Original Message----- > From: Jim Coleman [SMTP:Jim.Coleman@STATE.MN.US] > Sent: Friday, April 28, 2000 12:36 PM > To: DB2-L@RYCI.COM > Subject: Can anyone recommend a good DB2 data editor > > Greetings all, > > Can anyone recommend a good DB2 data editor, (especially one that > interfaces > nicely with BMC Catalog Manager)? > > We currently use CA-PLATINUM RC/Update but may soon be losing it. Our > users > will be sorry to [...]
17467 232 34_Re: DB2V6 upgrade and NETDATA/JDBC0_32_Larry.Hill1@BRIDGE.BELLSOUTH.COM31_Fri, 28 Apr 2000 12:21:13 -0500407_US-ASCII Myron,
In our shop, we have a mix of DB2 subsystems running v5 an v6. The release versions of Net.Data do not have a one to one correspondence to the DB2 release versions (since Net.Data is not really directly related to DB2, it is more of an add on to Websphere). Net.Data is currently at version 2.2 and I don't believe there would be any reason to run two versions of this software. [...]
17700 90 31_Re: Query tuning index question15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Fri, 28 Apr 2000 10:23:46 -0700438_iso-8859-1 Thanks Michael.
-----Original Message----- From: Michael Hannan [mailto:mhannan@C031.AONE.NET.AU] Sent: Thursday, April 27, 2000 6:18 PM To: DB2-L@RYCI.COM Subject: Query tuning index question
Sandi,
Of course the answer 'depends' on a few things:
1. How often will it be executed. Cost of scanning 8K+ pages is not high if not executed often. But then you probably wouldn't be asking. [...]
17791 319 34_Re: DB2V6 upgrade and NETDATA/JDBC12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 28 Apr 2000 10:41:10 -0700462_us-ascii True. But you have the same problem. You cannot run two versions of JDBC at the same time. Nor two versions of the different software for JDBC provided by DB2 (ie the V5 or the V6 libs) at the same time. You run one or the other.
For the small shops that only have one machine but require the capability to run both versions at the same time so that they can test the new version while running the old in production, this is a real problem. [...]
18111 127 47_Re: DR- SAP multi-dataset simple 32K tablespace22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Fri, 28 Apr 2000 13:49:28 -0400684_iso-8859-1 Bill -
How about FULLCOPY dumping A003 and A004 even though they're empty. DB2 will have the full copy he wants, it'll cost you 2 tapes & your recovery process is the same.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: Bill Disch[SMTP:bill.disch@GENMILLS.COM] > Sent: Friday, April 28, 2000 11:01 AM > To: DB2-L@RYCI.COM > Subject: [DB2-L] DR- SAP multi-dataset simple 32K tablespace > > We completed another successful Disaster Recovery Test at our hot site. I > say successful because previous problems have disappeared and new glitches > show up that need attention. I'll try to be as [...]
18239 73 31_Re: question about another list16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Fri, 28 Apr 2000 13:56:26 -0400418_us-ascii
Hi, everyting about oracle. http://members.spree.com/rnalam/html/oracle/oralinks.htm hth
Emrah GUVEN on 04/28/2000 12:52:43 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: question about another list
18313 16 7_DB2/DDF14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 28 Apr 2000 13:55:27 -0400349_- Hi, Where can I get info on configuring DDF ? And in DB2 V4.1 does it fully support TCP/IP ? Thanks, Dean
================================================ 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.
18330 84 18_Re: DB2 CONNECTION7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Fri, 28 Apr 2000 14:58:34 -0300393_iso-8859-1 Glenn:
The workstation where I tried to connect from is a Windows/NT Workstation with DB2 UDB/EEE V6. From this workstation I am already able to connect to other DB2 subsystems, including OS/390. This is a reproducible problem and it never worked. I have already checked my DBM Configuration with IBM and it seems to be OK. Thank you for your help, Glenn. Best regards. [...]
18415 25 15_Re: TSO command12_Vernon, John27_John.Vernon@TWC.STATE.TX.US31_Fri, 28 Apr 2000 13:04:44 -0500600_- To one and all who so kindly responded with the command, my sincerest Thanks!! (oh to have the manuals!!!)
John Vernon DB2 System Administrator Texas WorkForce Commission 101 East 15th Street Austin, Texas 78778 Vice-President, Heart of Texas DB2 Users Group Email: john.vernon@twc.state.tx.us jvernonrr@aol.com Phone: 512-936-3170 Fax: 512-936-3190
================================================ 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.
18441 45 47_Re: Can anyone recommend a good DB2 data editor15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Fri, 28 Apr 2000 14:11:51 -0400444_us-ascii BMC has(had) a relationship with Princeton Softech(sic) for this I believe. Ask your BMC rep Bob
-----Original Message----- From: Jim Coleman [SMTP:Jim.Coleman@STATE.MN.US] Sent: Friday, April 28, 2000 12:36 PM To: DB2-L@RYCI.COM Subject: Can anyone recommend a good DB2 data editor
Greetings all,
Can anyone recommend a good DB2 data editor, (especially one that interfaces nicely with BMC Catalog Manager)? [...]
18487 17 11_Re: DB2/DDF8_Bob Abad16_BobRabad@AOL.COM29_Fri, 28 Apr 2000 14:13:20 EDT474_US-ASCII Hi Dean! Not sure what your configuration is whether: > VTAM <-> DB2 for remote connections or > TCP/IP <-> Using DRDA in a TCP/IP network
Please see the V5 Installation Guide (Chaps. 3-2 & 3-3).....Hope this helps!!
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
18505 128 18_Re: DB2 CONNECTION13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Fri, 28 Apr 2000 13:08:32 -0500427_iso-8859-1 Does your work station just have the client code on it, or does it have the whole EE server?
In any case, I will assume you have a client connecting to an EE server. I would see if there is a fire wall not allowing communications. I have seen this before. If you have a fire wall, check the log/messages to see if you have been blocked. You will need to get help from the Network team for that I assume. [...]
18634 21 4_TEST14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 28 Apr 2000 14:20:38 -0400348_- Hi, I just subscribed to this list and have asked a couple of questions, and I don't see my questions coming back to my e-mail so I don't know if they are being posted ? I haven't received any responses. Can someone let me know if they receive this. Thanks, Dean Montevago MVS Systems Programming Visiting Nurse Service of NY (212) 290-0543 [...]
18656 42 8_Re: TEST16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Fri, 28 Apr 2000 14:28:24 -0400647_us-ascii YOUR BEING POSTES
Dean Montevago on 04/28/2000 02:20:38 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: TEST
Hi, I just subscribed to this list and have asked a couple of questions, and I don't see my questions coming back to my e-mail so I don't know if they are being posted ? I haven't received any responses. Can someone let me know if they receive this. Thanks, Dean Montevago MVS Systems Programming Visiting Nurse Service of NY (212) 290-0543 [...]
18699 39 8_Re: TEST15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Fri, 28 Apr 2000 14:36:31 -0400607_us-ascii Dean, Welcome aboard, check your settings, I think it is ACK for acknowledgement of posts Bob
-----Original Message----- From: Dean Montevago [SMTP:DMonteva@VNSNY.ORG] Sent: Friday, April 28, 2000 2:21 PM To: DB2-L@RYCI.COM Subject: TEST
Hi, I just subscribed to this list and have asked a couple of questions, and I don't see my questions coming back to my e-mail so I don't know if they are being posted ? I haven't received any responses. Can someone let me know if they receive this. Thanks, Dean Montevago MVS Systems Programming Visiting Nurse Service of NY (212) 290-0543 [...]
18739 66 47_Re: Can anyone recommend a good DB2 data editor13_Penny Treptow21_Penny.Treptow@UAL.COM31_Fri, 28 Apr 2000 13:21:47 -0500415_- We use CA/Platinum's RC/Update. Even end users utilize it to edit their code tables.
---------- From: DB2-L(a)RYCI.COM Sent: Friday, April 28, 2000 11:36 AM To: DB2-L(a)RYCI.COM Cc: Jim.Coleman(a)STATE.MN.US Subject: Can anyone recommend a good DB2 data editor
Greetings all,
Can anyone recommend a good DB2 data editor, (especially one that interfaces nicely with BMC Catalog Manager)? [...]
18806 45 11_Re: DB2/DDF16_Michael McCarthy18_mmccarthy@DTCC.COM31_Fri, 28 Apr 2000 16:01:37 -0400438_us-ascii Dean,
The redbook WOW! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 Universal Database number SG24-2212-00 is an excellent book to use for configuring TCP/IP connections. However, you must have Version 5 of DB2 for OS/390.
-Mike.
Dean Montevago on 04/28/2000 01:55:27 PM
Please respond to DB2 Data Base Discussion List [...]
18852 85 33_Re: UDB Version 5 SAMPLE Database9_Don Alden26_Don.Alden@PKSIS.LEVEL3.COM31_Fri, 28 Apr 2000 14:56:44 -0600397_iso-8859-1 Yes, Control Center was installed and I checked the Database path and found nothing.
I did check the UDB started tasks and discovered that an error had occured attempting to start the "DB2 SERVICES TASK".
The error was => DB2 SERVICES TERMINATED WITH SERVICE-SPECIFIC ERROR 4294959296 <==
Have any of you UDB Gurus seen this before and if so ==> HELLLLPPP !!! [...]
18938 23 38_SMF recording for MSU MULC reporting ?14_Johnson, Tracy22_TJohnson@GUIDEMAIL.COM31_Fri, 28 Apr 2000 16:21:06 -0500349_iso-8859-1 Our DB2 MSU usage calculation for MULC reports seem way too high for us. We have BMC's Mainview / CMF reports (using type 30 records ?) that show a level that is 1/6th what MULC reports. Can anyone suggest what service unit report to use for DB2 accounting records to be able to reconcile against the MULC report? Thanks in advance. [...]
18962 52 47_Re: Can anyone recommend a good DB2 data editor10_Mike Wiles14_mwiles@UCG.COM31_Fri, 28 Apr 2000 17:38:21 -0400543_iso-8859-1 Hi Jim!
I don't know if this is helpful (because I'm green enough to be unsure of exactly what you want) but I use SQL Explorer (also known as Database Desktop, I think) that comes with a lot of Inprise (formerly Borland) tools. I know it comes with Delphi, and possibly C++ Builder. It allows me to browse/edit any table on any ODBC data source that you have rights to, and you can also enter SQL directly into it and have it executed right away. It has a few quirks, but it is very useful for making quick changes and [...]
19015 129 33_Re: UDB Version 5 SAMPLE Database12_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 28 Apr 2000 14:23:09 -0700415_us-ascii Sample should only take a minute or so to create. Open a DB2 command line on your PC...start programs...DB2 for Windows NT...Command line processor , and enter "list database directories" and it will return all the databases you have defined on your PC.
I haven't found a good place outside of IBM tech support to find some of the various weird return codes. My guess is a TCP/IP port problem. [...]
19145 50 13_DB2 interface14_Dmitriy Bobrov16_wertor@TICON.NET31_Fri, 28 Apr 2000 17:32:31 -0500346_iso-8859-1 Can anyone recomend good interface(connection) between UNIX RS6000 box and DB2 database , which is been arount for a while and standard, that we can look at? We want to replace our existing mainframe software with RS600 UNIX boxes and runing out of ideas of interfaces between DB2 and UNIX. Can anyone point me to the right dirrection?
19196 40 42_Re: SMF recording for MSU MULC reporting ?14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Fri, 28 Apr 2000 20:29:52 -0400360_ISO-8859-1 Mike, Are you also accounting for the DB2 time that is charged to the applications? If the type 30 records you are looking at are only for the DB2 system address spaces, you are missing most of the charges. Most of the costs of running your Db2 system are charged to the applications and are in the type 101 records. You have to add it all up. [...]
19237 20 40_Converting Indexes from Type 1 to Type 215_Dorinda Peachey22_dorinda@ARCHES.UGA.EDU31_Fri, 28 Apr 2000 20:56:21 -0400527_US-ASCII Is there any way to convert all of the indexes in SYSIBM.SYSINDEXES from Type 1 to Type 2 to do a system-wide convert? I ran a CATMAINT CONVERT and it only got the DB2 system catalog and directory indexes.
Thanks in advance,
Dorinda Peachey University of Georgia
================================================ 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.
19258 115 44_Re: Converting Indexes from Type 1 to Type 210_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Sat, 29 Apr 2000 03:34:28 GMT694_us-ascii Hi Dorinda, CATMAINT does it for the catalog and directories only.You have to do it either manually or numbers of tools mentioned in some of the previous mails of this topic discussion.There are very effective ways of conversion also discussed in the list some 2-3 months back.I request you to search archives and hope you will definitely find it over there. The only problems which i can see is that you require minimum down time. I am sending some of the things which came in the list and which are there in my archives : -------------------------------------------------------------------------------------------------------------------------------- First, change your default [...]
19374 128 56_Re: SYSLGRNX and data integrity of dropped tablespaces??10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Sat, 29 Apr 2000 04:07:13 GMT508_iso-8859-1 Hi Martin, First of all this is not a new feature in DB2 V5 ,It was there in V4 as well ,i have not checked other previous manuals but the i presume it was then as well because it looks highly logical to me from the recovery purpose. Right from the begining i have seen IBM's main stress on is data consistency and recovery.I do find it to be useful in many of the cases.What if a tablespace is accidently dropped and u have an image copy , u can run DSN1COPY and get it back to the point in [...]