1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2000, week 1
2 19 28_Y2K - North America - Brazil13_Lourdes Kishi14_lkishi@BKB.COM30_Sat, 1 Jan 2000 01:51:00 -0500370_US-ASCII Batch and Online checked... and running. No problems at all.
OS/390 1.3 DB2 4.1
Regards and Happy Y2k !!!
================================================ 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.
22 42 32_Re: Y2K - North America - Brazil13_Martin Kenney25_martin.kenney@RAILINC.COM30_Sat, 1 Jan 2000 01:22:15 -0500398_us-ascii I know this is not a DB2 problem, but we use INFOMAN V6.3 and have been getting S0C7 reason code 7 right after midnight. Is anyone else experiencing this problem.
Lourdes Kishi on 01/01/2000 01:51:00 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Marty R Kenney/RICC/AAR) [...]
65 32 38_Belated checkin Y2K UK - all clear !!!13_Philip Nelson24_philip@PANDP.SALTIRE.ORG30_Sat, 1 Jan 2000 08:41:18 +0000407_us-ascii Happy New Year / Stasny novy rok.
I wasn't in until 8 am just outside Edinburgh in Scotland, hence the late report.
Just finished our basic testbeds on IMS V5.1, DB2 V5.1 and Platinum toolset -all clear as expected.
Also all clear on DB2 on OS/2 and NT (V6.1).
Waiting for our AIX servers to be brought back up and then I'll have a look at DB2 and Oracle on these. [...]
98 22 51_Y2K in Italy: final check from CESVe, Padua, Italy.14_Max 'Guderian'16_mocion@LIBERO.IT30_Sat, 1 Jan 2000 10:24:53 +0100435_us-ascii All batch and night activities OK. All system Status Ok. Only 1 minor problem in a old pgm.
All applicatios runs. :-)))))))))))))
Cheers
Max Scarpa Cesve SpA Italy
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
121 22 31_Storing images in db2 v5 os/39011_Eric Wilkin18_eric.wilkin@NBB.BE30_Sat, 1 Jan 2000 03:24:11 -0800376_- We are now starting a new project with db2 v5 under os/390. This project requires to store/manage images (photos).
I know that with DB2 V6 we will have the possibility to use the DB2 Extenders.
But our site has forseen V6 installation on end 2000 (late for this project).
My question : What are the possibilities to store images in db2 v5 os/390 ? [...]
144 56 0_14_khalid mahsoun27_kmahsoun@SAUDIONLINE.COM.SA30_Sat, 1 Jan 2000 12:33:21 +0300293_windows-1256 hi every body I am located in Jeddah Saudi Arabia we are -3 GMT.The time now is 12:30 local which is 9:30 . our system operate on GMT time zone we passed two rollover 'local for power and telecom /GMT machine time ' 'with no problems . we run OS390 , IMS V6 AND DB2 V4 AND CICS V4
201 57 24_From Jeddah SAUDI ARABIA14_khalid mahsoun27_kmahsoun@SAUDIONLINE.COM.SA30_Sat, 1 Jan 2000 12:34:10 +0300293_windows-1256 hi every body I am located in Jeddah Saudi Arabia we are -3 GMT.The time now is 12:30 local which is 9:30 . our system operate on GMT time zone we passed two rollover 'local for power and telecom /GMT machine time ' 'with no problems . we run OS390 , IMS V6 AND DB2 V4 AND CICS V4
259 45 22_Re: Any news from U.K?10_Robert Ord21_robertord@HOTMAIL.COM28_Sat, 1 Jan 2000 10:08:38 GMT924_- No problems so far ! We will have to wait until our batch schedule completes to see whether all the applications cope.
Robert Ord
>From: Deepak Kini M >Reply-To: "Deepak, Kini" >To: DB2-L@RYCI.COM >Subject: Any news from U.K? >Date: Sat, 1 Jan 2000 10:31:14 +0530 > >*************************************************************************** >Deepak Kini M >GE CBD Insurance >Wipro-GE Offshore Development Center >Wipro Technologies >1-8-448, Lakshmi Building >S.P. Road, Begumpet, >Secunderabad - India >Tel : 91-40-7896008, Extn : 4519 >Fax: 91-40-7896123 >E-mail:Deepak.MKini@wipro.com >deepakk@wiphyd.ge.com >The World's First SEI CMM Level 5 Software Services Company >**************************************************************************** > >================================================ >To change your subscription options or to [...]
305 49 3_Y2K12_Terry Spikes21_terryspikes@YAHOO.COM30_Sat, 1 Jan 2000 02:25:41 -0800366_us-ascii DB2-L
Happy New Year! I'm in Eastern North Carolina USA and everything is ok here. It's about 05:15 am EST now. I have run thru 2 sets of test scripts for these products...
IBM DB2/OS390 v5.1 QMF v3.3
CA/Platinum RC/Query (97C) RC/Migrator Recovery Analyzer Fast Recover Fast Unload
CA PANSQL (DB2 interface for Easytrieve) [...]
355 83 33_Re: How many DBAs does it take...15_Lynette Roberts21_llroberts@KSCABLE.COM30_Sat, 1 Jan 2000 06:18:42 -0800619_- And I naively thought that it was only my company that short-staffed the technical groups, DBAs included! We have been attempting to argue for increased staffing, either permanent or contract, for the last three years, only to receive the standard "things are tough all over" response. It seems that our company only appreciates the technical staff when a major problem crops up, which unfortunately doesn't occur often enough around budget time, when they decide the headcount figures for next year. Are we understaffed? YES, YES, and YES, and we have a SAP implementation looming for the year 2000 without any [...]
439 15 10_Y2K STATUS0_20_ddlusk@HOUSEHOLD.COM30_Sat, 1 Jan 2000 06:38:40 -0600495_us-ascii 6.5 hours after rollover C.S.T., Production is going full steam ahead, no database problems, so far everythings ok, here... But I haven't heard any planes taking off or landing at Chicago's O'Hare airport, we're only a few miles away. hmmmmm...
================================================ 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.
455 20 21_Re: Reorg DB2 catalog15_Lynette Roberts21_llroberts@KSCABLE.COM30_Sat, 1 Jan 2000 06:41:51 -0800567_- The "DB2 for OS/390 V5 Utility Guide and Reference" specifically talks about how reorgs on the system catalog are performed. We only had a few gotcha's when implementing this: 1. almost nothing else can be running in DB2 while the reorg was going. 2. a "repair set nocopypend" will not work on the system catalog -- you have to take an imagecopy to reset a copy pending flag 3. when doing the imagecopy after the reorg, SYSCOPY has to be copied first, followed by everthing else, followed by a backup of SYSCOPY once again (since SYSCOPY is updated during the [...]
476 14 31_Re: SNAPSHOT - recovery options15_Lynette Roberts21_llroberts@KSCABLE.COM30_Sat, 1 Jan 2000 06:50:28 -0800333_- Have you looked into using DFSMS to do your backups? DB2V5/OS390 has a direct hook into DFSMS which allows for a SNAPSHOT-like backup, while also recording the backup information within DB2. So your backups will run very fast and you still would have the recovery flexibility of using either DB2 utilities or a DFSMS restore. [...]
491 51 22_Re: Any news from U.K?22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Sat, 1 Jan 2000 13:21:51 +0000877_ISO-8859-1 Hi all ..
all ok here in sunny England ...... eveything up and running on our SAP system ..
os390 2.6 / DB2 V5
regards
Leslie Pendlebury-Bowe
______________________________ Reply Separator _________________________________ Subject: Any news from U.K? Author: Deepak Kini M at Internet Date: 1/1/00 10:31 AM
*************************************************************************** Deepak Kini M GE CBD Insurance Wipro-GE Offshore Development Center Wipro Technologies 1-8-448, Lakshmi Building S.P. Road, Begumpet, Secunderabad - India Tel : 91-40-7896008, Extn : 4519 Fax: 91-40-7896123 E-mail:Deepak.MKini@wipro.com deepakk@wiphyd.ge.com The World's First SEI CMM Level 5 Software Services Company **************************************************************************** [...]
543 18 15_Y2K - All is OK13_Decastro, Joe23_Joe.Decastro@DISNEY.COM30_Sat, 1 Jan 2000 06:30:22 -0800425_iso-8859-1 Hello all....
Nightly batch is winding down and all is well in Florida at 9:30 AM EST (GMT - 5). We run DB2 V5 and Platinum 97G on OS/390.
Happy New Year, Joe
================================================ 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.
562 118 33_Re: How many DBAs does it take...14_Philip Gunning20_pgunning@BOSCOVS.COM30_Sat, 1 Jan 2000 10:00:53 -0500334_us-ascii Lynette, I would definitely recommend getting another DBA or two for the SAP implementation. Will it be on OS/390, NT, or AIX? Do you have any time for performance tuning and monitoring? Doesn't sound like it. If you don't have tools for OS/390 to aid in capturing and analyzing dynamic SQL you should get one. HTH Phil [...]
681 22 64_New Manual on Building Cross-Platiform Stored Procedures and SPB14_Philip Gunning20_pgunning@BOSCOVS.COM30_Sat, 1 Jan 2000 10:22:37 -0500488_us-ascii Check this out: http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg245485.pdf
Cheers! Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner
================================================ 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.
704 15 0_17_Sethuraman,Sriram26_Sriram.Sethuraman@NIKE.COM30_Sat, 1 Jan 2000 08:02:11 -0800416_iso-8859-1 Our entire system is up and running. We didn't face even single Problem in US. Our Batch process was running yesterday without any PP. Great News!!!!
Sriram
================================================ 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.
720 56 32_Re: Reorg DB2 catalog/MODIFY run13_Tu-vinh Chang18_TMCHANG@ITRWEB.COM30_Sat, 1 Jan 2000 09:48:00 -0800103_ISO-8859-1 Hi, Can you also forward the attachment to me? Thanks, Tu-Vinh Chang California, USA
777 25 6_Y2K OK16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Sat, 1 Jan 2000 14:11:50 -0500363_windows-1256 Hello from DB2-L and RYCI.COM.
See, if you're getting this, then something must be working. We have much software behind DB2-L and the entire RYCI web site is DB2. Since everyone is communicating their successes, we might as well talk about ours, which is letting you talk about yours.
The MEDIA was wrong, Y2K was a minor hiccup! [...]
803 38 49_Re: Y2K OK. Thanks to Richard Yevich for infos...14_Max 'Guderian'16_mocion@LIBERO.IT30_Sat, 1 Jan 2000 22:21:09 +0100348_us-ascii This is music for me. Nice to hear you, folks !!
But I'm waiting for a complete 'cycle' of our production environment, i.e. a day of tx work and a
night of heavy batch, to be sure that all is ok, mainly application software.
BUT for the moment, all subsystems work well and this is a good Y2K start....isn't it ? [...]
842 24 12_Y2K in India9_SrinivasG17_SRINIVASG@INF.COM30_Sun, 2 Jan 2000 06:24:19 +0530290_iso-8859-1 Hi All,
It's now more than 24 hrs since Y2K rollover in INDIA and everything seems fine, a perfect touchdown. We are running DB2 V5.1 on OS/390 V2.5 and DB2 V5.1 as well as DB2 V6.1 on OS/390 V2.7. We are also running CICS 4.1 and CICS TS 1.3. No probs there either. [...]
867 19 34_Y2K - What was all the fuss about?0_22_BILL_GALLAGHER@PHL.COM30_Sun, 2 Jan 2000 09:40:00 -0500322_us-ascii The best comment I heard about Y2K was in yesterday morning's newspaper: after all the hype about Y2K, and the apparent lack of any real problems resulting from it (so far), January 1, 2000 will long be remembered as the "Yawn of the New Millennium".
Bill Gallagher, DBA Phoenix Home Life Enfield, CT [...]
887 13 32_Re: Reorg DB2 catalog/MODIFY run0_15_KATIKAN@AOL.COM28_Sun, 2 Jan 2000 11:01:58 EST256_us-ascii to me
================================================ 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.
901 63 32_Re: Reorg DB2 catalog/MODIFY run13_Tu-vinh Chang18_TMCHANG@ITRWEB.COM30_Sat, 1 Jan 2000 09:48:00 -0800103_iso-8859-1 Hi, Can you also forward the attachment to me? Thanks, Tu-Vinh Chang California, USA
965 58 24_From Jeddah SAUDI ARABIA14_khalid mahsoun27_kmahsoun@SAUDIONLINE.COM.SA30_Sat, 1 Jan 2000 12:34:10 +0300293_windows-1256 hi every body I am located in Jeddah Saudi Arabia we are -3 GMT.The time now is 12:30 local which is 9:30 . our system operate on GMT time zone we passed two rollover 'local for power and telecom /GMT machine time ' 'with no problems . we run OS390 , IMS V6 AND DB2 V4 AND CICS V4
1024 57 0_14_khalid mahsoun27_kmahsoun@SAUDIONLINE.COM.SA30_Sat, 1 Jan 2000 12:33:21 +0300293_windows-1256 hi every body I am located in Jeddah Saudi Arabia we are -3 GMT.The time now is 12:30 local which is 9:30 . our system operate on GMT time zone we passed two rollover 'local for power and telecom /GMT machine time ' 'with no problems . we run OS390 , IMS V6 AND DB2 V4 AND CICS V4
1082 63 38_Re: Y2K - What was all the fuss about?14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU30_Sun, 2 Jan 2000 17:49:30 -0500473_us-ascii The trouble with that statement is its implication that the entire Y2K effort was much ado about nothing. Those of us who have been on the front lines, especially those who had to deal with old application systems, know that nothing could be farther from the truth. I can't speak for anyone else, but I know if we hadn't been breaking our backs for the last year or so, we would have indeed had the type of disaster at our shop that some had been predicting. [...]
1146 31 38_Re: Y2K - What was all the fuss about?0_17_JTonchick@AOL.COM28_Sun, 2 Jan 2000 20:59:37 EST574_us-ascii In a message dated 01/02/2000 4:46:13 PM Central Standard Time, HWachtel@UAPC.CUNY.EDU writes: << The trouble with that statement is its implication that the entire Y2K effort was much ado about nothing. Those of us who have been on the front lines, especially those who had to deal with old application systems, know that nothing could be farther from the truth. I can't speak for anyone else, but I know if we hadn't been breaking our backs for the last year or so, we would have indeed had the type of disaster at our shop that some had been predicting. >> [...]
1178 36 38_Re: Y2K - What was all the fuss about?14_Massimo Scarpa16_mscarpa@CESVE.IT30_Mon, 3 Jan 2000 08:12:40 +0100381_us-ascii Even in Italy newspapers say that Y2K bug was only a big business for someone.
But without Y2K fear our management would have left our systems at the stone age, no Y2K
budget, no system upgrade, 'It costs too much' would be the main phrase....But what would be the costs for a real bug ? No one knows.....How many managers would be fired if Y2K was not [...]
1215 19 38_Re: Y2K - What was all the fuss about?11_learning DB20_thelist_us@YAHOO.COM30_Sun, 2 Jan 2000 23:26:45 -0800521_us-ascii Typical management statement - nothing went wrong, so it was a scam; if something had gone wrong, it would be my fault.
__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://messenger.yahoo.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1235 71 21_Re: Reorg DB2 catalog0_18_mebert@AMADEUS.NET30_Mon, 3 Jan 2000 09:37:32 +0100423_us-ascii Hi,
let's hope the media-driven Y2K hysteria is over. At least it has gotten me 2 days extra vacation and a nice cash bonus. I have by now sent my Cat/Dir Reorg jobs to about 40 people, with a couple more outstanding. I got some delivery failure reports, which I will have to look at later; if you have requested the JCLs, but have not received them yet or in the next one or two days, write me again. [...]
1307 109 21_Re: Reorg DB2 catalog11_learning DB20_thelist_us@YAHOO.COM30_Mon, 3 Jan 2000 00:57:46 -0800504_us-ascii Please send me a copy too...TIA
--- mebert@AMADEUS.NET wrote: > Hi, > > let's hope the media-driven Y2K hysteria is over. At > least it has gotten me 2 > days extra vacation and a nice cash bonus. I have by > now sent my Cat/Dir Reorg > jobs to about 40 people, with a couple more > outstanding. I got some delivery > failure reports, which I will have to look at later; > if you have requested the > JCLs, but have not received them yet or in the next > one or two days, write me > [...]
1417 50 19_Re: SAP chooses ...11_Daniel Adam15_dadam@GRATEX.SK30_Mon, 3 Jan 2000 03:28:32 -0800476_ISO-8859-1 On Thu, 30 Dec 1999 15:09:37 -0600, Richard A Yevich wrote:
>MISLEADING INITIAL POSTING...
Richard and other subscribers,
What can I say. It was not my intention to mislead anyone. I copy-pasted the lines from http://www.sap.com/solutions/technology/index.htm. Looking at the web page now, the only thing I can say is that THE STATEMENET WAS CHANGED there. I hope someone noticed the change too and can confirm. D. [...]
1468 48 38_Re: Y2K - What was all the fuss about?12_Canvas Botha18_vzbotha@MWEB.CO.ZA30_Mon, 3 Jan 2000 11:33:08 +0200490_us-ascii Yes the fuss about Y2K. Although I agree with all that has been said, it was the actual last month that anoyed me. We have tested and made changes for the past 18 month to ensure that the Y2K project would be a success. Why then freeze all changes to the development environment? Why this massive standby effort after we have proved to management about 10 times that the project will work? I do think that there was some over reaction. Crying "WOLF" works, like in this case. [...]
1517 84 19_Re: SAP chooses ...14_Chris Cronrath18_CCronrath@NESL.COM31_Thu, 30 Dec 1999 16:31:44 -0500469_iso-8859-1 I agree that the title says mysap.com but when my boss read the following statement posted at the web site he thinks SAP has chosen Micrsoft SQL Server for the Windows NT/2000 Platform. Reason being is the statement that starts "In addition,". This makes it look like SAP has chosen SQL Server for both Windows platforms and the mySAP.com solutions. If SQL Server is only for the mySAP.com solution this press release should be changed to reflect that. [...]
1602 25 98_FW: Getting Started with DB2 Stored Procedures: Give Them a Call through the Network, SG24-4693-0112_Fertaki Gina20_GFertaki@EUROBANK.GR30_Mon, 3 Jan 2000 12:58:26 +0200513_windows-1253 Hello, its been some time now that when I try to view online the above redbook at IBMs redbook site, I get a message 'done' but nothing appears on the screen. Does anybody know something about it? Thank in advance.
Gina Fertaki - DBA EFG Eurobank SA Greece ============================================ 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. [...]
1628 26 102_Re: FW: Getting Started with DB2 Stored Procedures: Give Them a Call through the Network, SG24-4693-010_24_ssethi@LOT.TATASTEEL.COM28_Mon, 3 Jan 2000 11:41:20 GMT281_us-ascii I have downloaded it by not opening it but saving it in my hard disk.But i did this 2 months back.
It may be ur internet server's cache problem, sometimes it doesn't load the full document at the first time and from the next time it gets that from cache only. [...]
1655 56 38_Re: Y2K - What was all the fuss about?11_Hilton Tina15_HiltonT@TCE.COM30_Mon, 3 Jan 2000 07:43:25 -0500418_iso-8859-1 Well, I'm sorry to admit this, but we are still running CICS 2.1.2 and MVS 4.3. We might upgrade CICS to V4 this year, but OS/390 was removed from the budget. We're currently on DB2 V3, although I've been ready to upgrade to V4 for the past year. I wasn't allowed to do that upgrade because of the Y2K work. So, some budgets didn't get opened up and we're still forced to run with antiquated software. [...]
1712 54 38_Re: Y2K - What was all the fuss about?14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU30_Mon, 3 Jan 2000 08:05:31 -0500367_us-ascii That sums it up. Talk about no-win situations!
All we can do is keep doing our jobs. Let's hope our luck (or maybe I should say "skill") continues to hold up.
learning DB cc: Sent by: DB2 Subject: Re: Y2K - What was all the fuss about? Data Base Discussion List [...]
1767 53 35_Re: Storing images in db2 v5 os/39018_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Mon, 3 Jan 2000 07:01:28 -0600588_iso-8859-1 Eric, I've never had to look into this but if I did I would consider LONG VARCHAR or LONG VARGRAPHIC. Try searching the DB2-L archives too. 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 [...]
1821 88 38_Re: Y2K - What was all the fuss about?14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU30_Mon, 3 Jan 2000 08:09:55 -0500357_us-ascii I've found, as many others have, from butter experience that it's best not to make more than one major change at a time, if only because it makes it ten times harder to figure out the cause of glitches that appear. The calendar rollover is a major change imposed from outside, so it makes sense to me not to do anything else at the same time. [...]
1910 35 18_information please13_Martin Kenney25_martin.kenney@RAILINC.COM30_Mon, 3 Jan 2000 08:22:53 -0500576_us-ascii I posted this question around two weeks ago and only received one response (probably because of all of the year 2000 stuff), so I will try again. Me and the other DBA in our shop have requested the installation of DB2 connect and DB2 stored procedures as a solution to business requirements to access mainframe VSAM files and mainframe DB2 tables. One of our main reasons for choosing this solution is that we feel it will be easier for our systems people to do the upgrades/maintenance if we keep the solution in the DB2 family. Our (new) VP/IT basically wants [...]
1946 99 33_Re: How many DBAs does it take...13_Lynne Flatley17_LFlatley@NEFN.COM30_Mon, 3 Jan 2000 08:35:34 -0500335_us-ascii James,
Yes! The references to the Gartner Group studies was one of the things I was looking for. I will get a look at those research notes and pass the information on to my boss. It would appear that our group is under-staffed, although not as much as the groups of some of the other respondents to this question! [...]
2046 32 47_Making a copy of a database for query\reporting0_25_George_White@VANGUARD.COM30_Mon, 3 Jan 2000 08:49:26 -0500375_us-ascii Hi,
I'm interested in anyone's experiences in creating a duplicate copy of a database.
We currently use unload\load for smaller databases. But, I am now asked to do the same for a larger DB.
o Does anyone have experiences they can share regarding IBM's Data Propagator Capture-Apply?
o How about BMC's Change Data Capture or others? [...]
2079 16 20_BP0 Getpages -- Why?0_22_kmulcahy@CHECKFREE.COM30_Mon, 3 Jan 2000 09:17:08 -0500429_us-ascii Given that BP0 is dedicated to the DB2 catalog and directory, why would a CICS transaction require BP0 getpages every time it executes?
Kevin Mulcahy CheckFree Corporation
================================================ 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.
2096 15 25_Data Warehouse - the term12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US30_Mon, 3 Jan 2000 08:49:26 -0600427_iso-8859-1 Does anyone know where the term "data warehouse" originated? What was the paper or where and when was the conference where it was first introduced?
Thanks, Louise Reid
================================================ 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.
2112 60 51_Re: Making a copy of a database for query\reporting11_Ball, Linda18_Linda_Ball@BMC.COM30_Mon, 3 Jan 2000 08:53:05 -0600600_ISO-8859-1 George, Do you need an exact copy for query? Do you need different indexes but the same tables? I recommend a bulk move technique if you don't want to reformat. That is faster than UNLOAD/LOAD. Then, if you find even that is too slow, you can consider propagation to keep it up-to-date. All propagation techniques, to my knowledge, require processing log, recreating SQL and applying it. There are differences in the products available but since this involves a fair amount of processing, you would do well to ask yourself how often you need this and how much transformation you need [...]
2173 53 38_Re: Y2K - What was all the fuss about?14_Theisen, Craig22_CTheisen@GUIDEMAIL.COM30_Mon, 3 Jan 2000 08:59:08 -0600551_iso-8859-1 Well said, the software release and application comments are ditto for our shop. But lets wait a few months before we sigh too deep thinking it is all over or yield to any complaints from management about Y2K being a bunch of expensive hype. We passed a big milestone, but most of those millions of lines of legacy code are in daily, monthly, quarterly etc batch cycles which have not executed yet. The reality of the Y2K risk may still be felt by enough companies that those that did a prudent job preparing for it will not be sorry. [...]
2227 116 33_Re: How many DBAs does it take...20_Alvarez, Maximiliano20_MAXIMILIANO@IADB.ORG30_Mon, 3 Jan 2000 10:14:16 -0500593_iso-8859-1 Lynette how many hours per week do you have to work to do all that?
> ---------- > From: Lynette Roberts[SMTP:llroberts@KSCABLE.COM] > Sent: Saturday, January 01, 2000 9:18 AM > Subject: Re: How many DBAs does it take... > > And I naively thought that it was only my company that short-staffed the > technical groups, DBAs included! We have been attempting to argue for > increased staffing, either permanent or contract, for the last three > years, > only to receive the standard "things are tough all over" response. It > seems > that our company only appreciates the [...]
2344 102 38_Re: Y2K - What was all the fuss about?14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU30_Mon, 3 Jan 2000 10:20:55 -0500584_us-ascii I (and many other observers) have been predicting that there will be minor glitches for months to come.
One thing that I think shouldn't be overlooked by anyone who's been running a source remediation program that used any kind of windowing: Before putting the project to bed, an exit report should be prepared indicating dates for future action. For fixed windows, this would be a few years before the end of the window. For floating windows, this would be a few years before the end of the window might wrap around to encompass old data (which would have to be [...]
2447 90 51_Re: Making a copy of a database for query\reporting13_McDonald, Ken20_Ken_McDonald@BMC.COM30_Mon, 3 Jan 2000 09:22:22 -0600504_ISO-8859-1 Hi George,
There are several 'off the shelf' products and techniques available for moving data. Some questions to be answered before choosing would be how current does the copy need to be, how much latency can be tolerated between updates to the primary database and the copy, and how frequently does the copy need to be updated? You mentioned that this will be a duplicate copy, but, if it is not an exact duplicate, how much data transformation or removal of columns must occur? [...]
2538 38 24_Re: BP0 Getpages -- Why?12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 3 Jan 2000 07:27:42 -0800536_us-ascii Is anything bound VALIDATE(RUN)? Authorization checking? Any dynamic SQL?
Roger Miller
kmulcahy@CHECKFREE.COM@RYCI.COM> on 01/03/2000 06:17:08 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: BP0 Getpages -- Why?
Given that BP0 is dedicated to the DB2 catalog and directory, why would a CICS transaction require BP0 getpages every time it executes? [...]
2577 45 16_Re: Y2K in India15_Philip, Sibimon19_PhilipS@SEALAND.COM30_Mon, 3 Jan 2000 10:30:18 -0500651_ISO-8859-1 Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com
"Without deviation from the norm, progress is not possible" - Frank Zappa
-----Original Message----- From: SrinivasG [mailto:SRINIVASG@INF.COM] Sent: Saturday, January 01, 2000 6:54 PM To: DB2-L@RYCI.COM Subject: Y2K in India
Hi All,
It's now more than 24 hrs since Y2K rollover in INDIA and everything seems fine, a perfect touchdown. We are running DB2 V5.1 on OS/390 V2.5 and DB2 V5.1 as well as DB2 V6.1 on OS/390 V2.7. We are also running CICS 4.1 and CICS TS 1.3. No probs there either. [...]
2623 56 102_Re: FW: Getting Started with DB2 Stored Procedures: Give Them a Call through the Network, SG24-4693-0112_Roger Miller19_millerrl@US.IBM.COM30_Mon, 3 Jan 2000 07:34:27 -0800498_us-ascii There is a newer version out on www.ibm.com/redbooks The latest one is listed as December 16, 1999. It's about 3.3 MB.
Developing Cross-Platform DB2 Stored Procedures: SQL Procedures and the DB2 Stored Procedure Builder , SG24-5485-00 1999-12-16
Roger Miller
ssethi@LOT.TATASTEEL.COM@RYCI.COM> on 01/03/2000 03:41:20 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
2680 37 24_Re: BP0 Getpages -- Why?12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM28_Mon, 3 Jan 2000 08:06:29 PST289_- Any tablespace or indexspace can use BP0 just if you specified that. If you want change it , you have to check what not catalog tablespace is using the BP0 BUFFERPOOL. You can create a query to search from sysibm.systablespace and find out what tablespaces are using the BP0 bpool. [...]
2718 45 103_Re: FW: Getting Started with DB2 Stored Procedures: Give Them a C all through the Network, SG24-4693-0116_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV30_Mon, 3 Jan 2000 09:35:43 -0700601_- We had the same problem ourselves on other Redbooks. Our solution was to download a newer version of Adobe Acrobat which then allowed us to read the old an new documents.
Duane
> -----Original Message----- > From: ssethi@LOT.TATASTEEL.COM [SMTP:ssethi@LOT.TATASTEEL.COM] > Sent: Monday, January 03, 2000 4:41 AM > To: DB2-L@RYCI.COM > Subject: Re: FW: Getting Started with DB2 Stored Procedures: Give > Them a Call through the Network, SG24-4693-01 > > I have downloaded it by not opening it but saving it in my hard disk.But i > did this 2 months back. > > It may be ur internet [...]
2764 59 24_Re: BP0 Getpages -- Why?17_Barbosa, Odimir J22_odimir.barbosa@EDS.COM30_Mon, 3 Jan 2000 10:34:34 -0600739_- If you have dynamic sql / validate run ... Your access in BP0 : DSNDB06.SYSDBASE, DSNDB06.SYSSTATS, DSNDB06.SYSUSER, DSNDB06.SYSVIEWS, DSNDB06.DSNADH01, DSNDB06.DSNATX02, DSNDB06.DSNAUH01, DSNDB06.DSNDSX01, ....
Odimir
> -----Original Message----- > From: Roger Miller [SMTP:millerrl@US.IBM.COM] > Sent: Monday, January 03, 2000 1:28 PM > To: DB2-L@RYCI.COM > Subject: Re: BP0 Getpages -- Why? > > Is anything bound VALIDATE(RUN)? Authorization checking? Any dynamic > SQL? > > Roger Miller > > kmulcahy@CHECKFREE.COM@RYCI.COM> on 01/03/2000 06:17:08 AM > > Please respond to DB2 Data Base Discussion List > > Sent by: DB2 Data Base Discussion List > > > To: DB2-L@RYCI.COM > [...]
2824 65 102_Re: FW: Getting Started with DB2 Stored Procedures: Give Them a Call through the Network, SG24-4693-010_18_mebert@AMADEUS.NET30_Mon, 3 Jan 2000 12:22:05 +0100377_us-ascii Unfortunately this is a common occurrence on the internet. It's most likely due to an overburdened network, and/or server, or the internet explorer has lost track of it's internal pointers... Try closing the IE & re-starting it, this sometimes helps. Other than that, wait for a less busy time & keep trying. I've had so many problems today that I have given up. [...]
2890 91 103_Re: FW: Getting Started with DB2 Stored Procedures: Give Them a C all through the Network, SG24-4693-0117_Scarcella, Gary V21_ScarcellaGV@AETNA.COM30_Mon, 3 Jan 2000 12:26:07 -0500664_- It could be something as simple as the "window" with the online book is hidden behind your current window running your browser.
Gary Scarcella Internet address: ScarcellaGV@aetna.com
> ---------- > From: mebert@AMADEUS.NET[SMTP:mebert@AMADEUS.NET] > Reply To: DB2 Data Base Discussion List > Sent: Monday, January 03, 2000 6:22 AM > To: DB2-L@RYCI.COM > Subject: Re: FW: Getting Started with DB2 Stored Procedures: Give > Them a Call through the Network, SG24-4693-01 > > Unfortunately this is a common occurrence on the internet. It's most > likely due > to an overburdened network, and/or server, or the internet explorer has > lost [...]
2982 74 19_Re: SAP chooses ...16_Richard A Yevich21_ryevich@BELLSOUTH.NET30_Mon, 3 Jan 2000 11:32:23 -0500653_iso-8859-1 Daniel,
ALWAYS POST! No one is blaming you! In fact, this was a good thing as it may not have been clarified otherwise. So actually, nice job!
Regards, Richard +===+===+===+===+====+ ryevich@attglobal.net
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Daniel Adam > Sent: Monday, January 03, 2000 6:29 AM > To: DB2-L@RYCI.COM > Subject: Re: SAP chooses ... > > > On Thu, 30 Dec 1999 15:09:37 -0600, Richard A Yevich > wrote: > > >MISLEADING INITIAL POSTING... > > Richard and other subscribers, > > What can I say. It was not [...]
3057 61 51_Re: Making a copy of a database for query\reporting12_Canvas Botha18_vzbotha@MWEB.CO.ZA30_Mon, 3 Jan 2000 19:21:28 +0200560_us-ascii We are using a combination depending on what the purpose of the copy is. We have found on very large tables the unload/load does not work well because the original tables are compressed and we require large amounts of tapes to copy the tables to the new destination. We have resorted to a DRP type approach in the end. We use DSN1COPY to move the data to the new destination. Needs a little work in settingup the JCL but once done, it's done. Structure changes do however cause problems every now and again. For once of movements we use PLATINUM [...]
3119 29 26_DB2Perf.DLL in UDB/NT V6.113_George Peters22_gpeters@COMPUSERVE.COM30_Mon, 3 Jan 2000 13:48:52 -0500634_iso-8859-1 Hi - question re DB2 UDB Workgroup Edition for WIN NT (Version 6.1, migration from 5.2).
Am wondering if anyone has encountered a message in WIN NT Event Viewer like "The library file c:\winnt\system32\db2Perf.dll specified for the DB2_NT_Performance Service could not be opened". This happens immediately after upgrade from V5.2 to V6.1 The problem generated by this message is that there are now no DB2-related objects in the WIN NT Performance Monitor. The monitor cannot be used for DB2 purposes. Indeed, there is no such file, and copying the file from \sqlllib\bin to that folder does not help. The Event [...]
3149 41 29_Re: Data Warehouse - the term16_Richard A Yevich21_ryevich@BELLSOUTH.NET30_Mon, 3 Jan 2000 13:15:30 -0500678_iso-8859-1 From Bill Inmon's publications/presentations, late 80's I believe. IBM was using the term Information Warehouse, for both some products and literature, but Bill's term has a broader base of exposure.
Regards, Richard +===+===+===+===+====+ richard_yevich@ibm.net
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Reid, Louise > Sent: Monday, January 03, 2000 9:49 AM > To: DB2-L@RYCI.COM > Subject: Data Warehouse - the term > > > Does anyone know where the term "data warehouse" originated? What was the > paper or where and when was the conference where it was first introduced? > > Thanks, [...]
3191 41 29_Re: Data Warehouse - the term13_George Peters22_gpeters@COMPUSERVE.COM30_Mon, 3 Jan 2000 14:24:18 -0500382_iso-8859-1 Linda Barry Devlin and P. Murphy published a seminal paper in the IBM Systems Journal, 27, No 1, 1988, "An Architecture for a Business and Information System", where he used the term Information Warehouse, as I recall. Later writers, including Devlin himself, used the term Data Warehouse, as in his own 1997 book on that subject (actually released in 1996). George [...]
3233 58 29_Re: Data Warehouse - the term0_23_Mike_Levine@TEKHELP.NET30_Mon, 3 Jan 2000 14:38:55 -0500734_us-ascii Hi,
What ever happened to the term 'repository' or 'data repository'? Was that just an IBM term and product? I believe this was used prior to 'warehouse'.
Regards,
Michael Levine Premier Data Services, Inc.
>>From Bill Inmon's publications/presentations, late 80's I believe. IBM was >using the term Information Warehouse, for both some products and literature, >but Bill's term has a broader base of exposure. > >Regards, >Richard >+===+===+===+===+====+ >richard_yevich@ibm.net > >> -----Original Message----- >> From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of >> Reid, Louise >> Sent: Monday, January 03, 2000 9:49 AM >> To: DB2-L@RYCI.COM >> Subject: Data [...]
3292 92 29_Re: Data Warehouse - the term13_George Peters22_gpeters@COMPUSERVE.COM30_Mon, 3 Jan 2000 14:50:34 -0500591_iso-8859-1 Michael IBM's Repository Manager (MVS) was released in about 1990-91(?). It was a true Repository, and part of IBM's unsuccessful AD/Cycle endeavour, IBM's way to get users to SAA. It was not a Data Warehouse in conventionally used sense (it was metadata). Most of these terms are no longer in use; ditto the products, tho' some remnants of SAA linger on. I recall reading an interview with the "father of SAA" in the early/mid-90s (Earl Wheeler??). Whn asked what happened to it, the reply was something along the lines of "I guess it gave way to Open systems", or similar. [...]
3385 121 29_Re: Data Warehouse - the term16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Mon, 3 Jan 2000 14:22:22 -0500725_iso-8859-1 Further clarification:
Bill Inmon - the "father of data warehousing" coined the term data warehouse in 1990. His definition is: A DATA WAREHOUSE is a subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision making process.
Regards, Richard +===+===+===+===+====+ ryevich@attglobal.net
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > George Peters > Sent: Monday, January 03, 2000 2:51 PM > To: DB2-L@RYCI.COM > Subject: Re: Data Warehouse - the term > > > Michael > IBM's Repository Manager (MVS) was released in about 1990-91(?). It was a > true Repository, and part [...]
3507 30 14_aix/udb newbie15_Sherri Sterling23_ssterling@BPD.TREAS.GOV30_Mon, 3 Jan 2000 15:49:06 -0500523_US-ASCII Sorry, this may be a dumb question, but being only a mainframe db2 system programmer, I have been thrown into the UDB arena. I have gotten a small stack of cd's. I have attempted to install UDB on an AIX box not knowing AIX, I have fumbled through this. The UDB level is 6.1 without any fixpacks added. So my question is this what is the proper procedures and how do I install the maintenance fixpacks. I have gone out the to IBM web site and downloaded the zip file onto a jazz drive. But do I need to unzip [...]
3538 91 51_Re: Making a copy of a database for query\reporting13_B. J. Scherer18_BScherer@QUEST.COM30_Mon, 3 Jan 2000 12:49:56 -0800507_iso-8859-1 Have you looked at Platinum (CA) Info Refiner? It can take DB2 log records and keep your tables in sync. So once you have a point in time copy, you can bring the changes forward to the copy and/or a summary table. This can happen nightly, hourly, how ever often you want. It uses the Log Reader from Log Analyzer to get the log data. Not that I care for CA, I know the technology works. It is 3270 front end and can even work for IMS to DB2 or you can join IMS and DB2 to have DB2 resultant [...]
3630 182 61_OS/390 - Active Log Archival & Queisce Period Parameter Value0_26_ken.george@EDWARDJONES.COM30_Mon, 3 Jan 2000 15:15:26 -0600366_US-ASCII Hi -
We had a situation occur over the weekend during one of our year end cycles where it appears as if DB2 could not automatically archive our full active logs. This proceeded to the point where DB2 eventually shut down processing until it could archive the logs. This has happened several times in the past and I would like to understand why. [...]
3813 45 32_PowerBuilder 6.5 & DB2 OS/390 V612_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Mon, 3 Jan 2000 15:59:42 -0600373_us-ascii Hi.
We used DB2 Connect on an NT 4.0 workstation, to successfully configure an ODBC connection for Powerbuilder 6.5. It's very cool, and opens up the data base in the PB Database Painter. Here's what's wierd though. On some of the tables, PB brings up the table definitions (columns, etc.) without a problem. On others, it pops up a window which says: [...]
3859 20 42_Time out function utility for Applications10_Nash Gupta19_nashgupt@US.IBM.COM30_Mon, 3 Jan 2000 15:57:29 -0800367_- Hello List!
Is there any parameter/function/utility in DB2 whereby an application could be terminated after a specfic time. For example: Lets say I want to terminate all applications which are connected to the database but have not been used since last 2 hrs. May be somebody just forgot to log off. Is it possible to log off such an app automatically. [...]
3880 42 88_International DB2 Users Group Update: 2000 North American Confere nce Schedule Available4_IDUG12_IDUG@SBA.COM30_Mon, 3 Jan 2000 16:13:14 -0600708_iso-8859-1 IDUG 2000 North America is set for May 14-18 at the Wyndham Anatole Hotel in Dallas, Texas. The complete technical session schedule for this 12th Annual North American Conference is now available online. Visit http://www.idug.org for detailed information on: * 140 unique technical sessions covering DB2 Universal Database for OS/390 and DB2 Universal Database for UNIX, Windows, OS/2 * Keynote presentations by Don Haderle, IBM's founding architect of DB2, and popular syndicated columnist Dave Barry * Nonstop networking opportunities with more than 2000 conference participants * Diverse technical tracks on current and new DB2 releases for mainframe and distributed [...]
3923 18 51_Re: Making a copy of a database for query\reporting12_Chris Miller24_Chris_Miller@PAYLESS.COM30_Mon, 3 Jan 2000 08:17:22 -0600526_us-ascii We just installed our first project that uses Data Propagator. However, it's on Windows NT (both source and target databases). I think the overall Data Propagator strategy is good if you absolutely must duplicate data, but the implementation hasn't been as easy as one might like. I would imagine there are better monitoring/management tools on OS/390 to help you know how well the programs are performing, how far through a subscription they are, etc. We plan on a OS/390 implementation later this summer/fall. [...]
3942 49 27_TCP/IP connection to OS/39014_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Mon, 3 Jan 2000 18:16:53 -0500490_iso-8859-1 Hi!
Happy New Year to everyone!!!
Our Sysprog just got TCP/IP enabled for one of our DB2 Subsystems and now when we try to connect to the database using IP we get the following error:
13.16.24 STC01818 DSNL032I -DB2E DSNLIRTR DRDA EXCEPTION CONDITION IN REQUEST FROM REQUESTOR LOCATION=xxx.xxx.xxx.xxx FOR THREAD WITH LUWID=AC100960.G57B.B3644DFD4881 REASON=00D3101C ERROR ID=DSNLIRTR0003 IFCID=0192 SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000003 [...]
3992 26 62_Automated DB2 Statistics replication between Production & Test16_Christine Sawyer20_cosawyer@HOTMAIL.COM28_Mon, 3 Jan 2000 18:23:09 EST391_- Can anyone share some experience on this one? I will like to set up a ajob to automatically update one of our test databases with production statistics on a weekly basis. Currently, we manually do this using Platinum's MIGRATOR product. I will appreciate any information/material anyone may provide Or where I can get more information about it? Any documented step by step procedure? [...]
4019 14 66_Re: Automated DB2 Statistics replication between Production & Test12_Chris Miller24_Chris_Miller@PAYLESS.COM30_Mon, 3 Jan 2000 17:29:19 -0600459_us-ascii If you're running DB2 on Unix or NT, you can use the DB2LOOK command to get your production statistics replicated to your test system. I'm not sure if there is such a thing on OS/390. (I'm not an OS/390 DBA).
================================================ 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.
4034 21 46_Re: Time out function utility for Applications12_Chris Miller24_Chris_Miller@PAYLESS.COM30_Mon, 3 Jan 2000 17:36:48 -0600508_us-ascii If you're running on unix or NT, you can use the DB2 govenor to force applications off the database (or re-nice them) based on various events (i.e. exceeded a max CPU time, clock time, etc.) We use the govenor for very basic monitoring. It is not the most graceful/elegant thing I've ever seen, but seems to work ok. You don't hear much about it. It doesn't have a GUI interface and isn't well integrated into DB2 like other things are. You can, however, find info in the admin guide about it. [...]
4056 37 6_Ooops!0_29_Greg.Palgrave@BANKWEST.COM.AU30_Tue, 4 Jan 2000 07:50:03 +0800590_us-ascii Apologies to all on the list who received a Lotus Notes "out of office" from me. I had set it up to NOT reply to DB2-L, but Notes apparently decided otherwise....
Greg Palgrave Database Administration Group Bank of Western Australia eMail : greg.palgrave@bankwest.com.au
_______________________________________________________________________________ Unencrypted electronic mail is not secure and may not be authentic. If you have any doubts as to the contents please telephone to confirm. [...]
4094 76 31_Re: TCP/IP connection to OS/3909_SrinivasG17_SRINIVASG@INF.COM30_Tue, 4 Jan 2000 06:01:24 +0530348_iso-8859-1 Hi, Happy new year to all of you.
After enabling TCPIP, the Sysprog has to populate the communications database. Namely SYSIBM.IPNAMES , SYSIBM.LUNAMES (for SNA), SYSIBM.LOCATIONS etc. Please refer to the DB2 Installation manual for details. For access from all IP addresses to DB2 , just insert a blank into SYSIBM.IPNAMES. [...]
4171 59 59_Re: Automated DB2 Statistics replication between Production10_DANIEL CYR19_DCYR@EMAIL.USPS.GOV30_Mon, 3 Jan 2000 20:36:35 -0600783_iso-8859-1 Christine,
I have a set of QMF queries/forms/proc/REXX that migrates our production stats to the test/development subsystem. Let me know and I can send an e-mail with attachments.
Dan dcyr@email.usps.gov
______________________________ Reply Separator _________________________________ Subject: Automated DB2 Statistics replication between Production & Te Author: owner-db2-l@RYCI.COM at INTERNET Date: 01/03/2000 6:33 PM
Can anyone share some experience on this one? I will like to set up a ajob to automatically update one of our test databases with production statistics on a weekly basis. Currently, we manually do this using Platinum's MIGRATOR product. I will appreciate any information/material anyone may provide Or [...]
4231 73 31_Re: TCP/IP connection to OS/39017_Linda F. Claussen18_lindafc@NETINS.NET30_Mon, 3 Jan 2000 20:32:53 -0600561_ISO-8859-1 The message implies you need to double check your links:
The DCS Directory entry Target database name on your workstation should equal the Location name in the DB2 for OS/390 Boot Strap Dataset.
Linda F. Claussen Claussen & Associates DB2 Consulting and Training lindafc@netins.net http://www.netins.net/showcase/lclaussen/ Phone: (319) 343-3216 Office: (319) 847-1985
---------- From: Manas Dasgupta To: DB2-L@RYCI.COM Subject: TCP/IP connection to OS/390 Date: Monday, January 03, 2000 5:16 PM [...]
4305 16 46_Re: Time out function utility for Applications13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Tue, 4 Jan 2000 08:35:32 +0530422_us-ascii If you are talking about online transaction applications . Then CICS has a parameter in the SIT which can specify a logoff after specific amount of idle time.
Vishy
================================================ 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.
4322 31 17_Disaster Recovery0_14_DPetro@AOL.COM28_Mon, 3 Jan 2000 22:10:59 EST368_us-ascii I was wondering if anyone would be willing to share some of their current practices as related to offsite Disaster Recovery. Some questions I have are:
1) What are people doing to ensure that recovery times at the offsite location are kept to an absolute minimum? For example, copying archive logs to disk before recovering application databases. [...]
4354 31 37_Fwd: Re: Reorg DB2 catalog/MODIFY run17_ravi kumar hassan18_ravibh@HOTMAIL.COM28_Mon, 3 Jan 2000 19:34:56 PST496_- TO ME............
Thanks in advance.
>From: KATIKAN@AOL.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Reorg DB2 catalog/MODIFY run >Date: Sun, 2 Jan 2000 11:01:58 EST > >to me > >================================================ >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. [...]
4386 30 21_DB2Perf.DLL in UDB/NT13_George Peters22_gpeters@COMPUSERVE.COM30_Tue, 4 Jan 2000 00:51:33 -0500637_iso-8859-1 Thought I'd ask this one again..... Hi - question re DB2 UDB Workgroup Edition for WIN NT (Version 6.1, migration from 5.2).
Am wondering if anyone has encountered a message in WIN NT Event Viewer like "The library file c:\winnt\system32\db2Perf.dll specified for the DB2_NT_Performance Service could not be opened". This happens immediately after upgrade from V5.2 to V6.1 The problem generated by this message is that there are now no DB2-related objects in the WIN NT Performance Monitor. The monitor cannot be used for DB2 purposes. Indeed, there is no such file, and copying the file from \sqllib\bin to that [...]
4417 53 26_RES: DB2Perf.DLL in UDB/NT13_Lourdes Kishi14_lkishi@BKB.COM30_Tue, 4 Jan 2000 03:16:00 -0500419_US-ASCII Sorry... I don' t know anything about UDB... (yet)
-----Mensagem original----- De: DB2 Data Base Discussion List at INTERNET Enviada em: terça-feira, 4 de janeiro de 2000 14:51 Para: DB2-L@RYCI.COM at INTERNET Assunto: DB2Perf.DLL in UDB/NT
Thought I'd ask this one again..... Hi - question re DB2 UDB Workgroup Edition for WIN NT (Version 6.1, migration from 5.2). [...]
4471 91 21_Re: Disaster Recovery22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Tue, 4 Jan 2000 07:46:35 +0000548_ISO-8859-1 Hi Dave .
In reply to your request for Information see information below after each of your questions.
Hope this helps
Leslie Pendlebury-Bowe DB2 DBA OS390 SAP etc
______________________________ Reply Separator _________________________________ Subject: Disaster Recovery Author: DPetro@AOL.COM at Internet Date: 1/3/00 10:10 PM
I was wondering if anyone would be willing to share some of their current practices as related to offsite Disaster Recovery. Some questions I have are: [...]
4563 70 26_HANDLE PARAMETER NOT VALID14_Popy A. Dimoka24_dimokap@INTERAMERICAN.GR30_Tue, 4 Jan 2000 11:35:22 +0200517_iso-8859-7 HELLO LIST AND HAPPY NEW YEAR,
I AM NEW TO DB2 UDB PE V6.1 FOR WINDOWS AND I AM JUST TRYING TO DISCOVER BACKUP AND RECOVERY ISSUES.I HAVE SCHEDULED SOME BACKUP JOBS TO RUN AND NOW I WANT THEM TO BE REMOVED FROM THE PENDING JOBS OF THE JOURNAL.WHEN TRYING TO DO SO, I GET MESSAGE SQL1058N "THE HANDLE PARAMETER IN THE DIRECTORY SCAN COMMAND IS NOT VALID".I HAVEN'T FOUND ANY SUFFICIENT DOCUMENTATION ON THAT MESSAGE. COULD SOMEONE PLEASE GIVE SOME MORE INFO ??? (EXCUSE MY ELEMENTARY LEVEL....) [...]
4634 45 51_Re: Making a copy of a database for query\reporting14_Massimo Scarpa16_mscarpa@CESVE.IT30_Tue, 4 Jan 2000 10:41:18 +0100404_us-ascii We had 3 types of db to replicate. We didn't use anty 3rd-party tool.
- A small one, we replicate with UNLOAD/LOAD via shared tape and shared GDGs (NEARLINE STORAGETEK shared between prod and test) during night time. We generated the JCL once, then it was scheduled and parameters edited via CONTROL-M (with auto-edit feature). It was a production db even if created in a test LPAR. [...]
4680 71 21_Re: Disaster Recovery9_Jim Leask27_jim.leask@RS-COMPONENTS.COM30_Tue, 4 Jan 2000 10:07:39 -0000582_iso-8859-1 At my current site we are lucky as we do not have a 24x7 requirement. Also, the business requirement for Disaster Recover is to recover to the beginning of the processing day (around 6am).
Therefore we can take advantage of the snapshot technology on our RVA disk system.
We have a disaster recovery slot each day at 5.30am where DB2 is shutdown and all other batch update processing is curtailed. A snapshot is taken of all disks within the RVA box, this takes about 2 seconds per disk volume. The disks are then copied off to tape in the background, [...]
4752 71 59_Re: Automated DB2 Statistics replication between Production17_Barbosa, Odimir J22_odimir.barbosa@EDS.COM30_Tue, 4 Jan 2000 05:35:59 -0600724_- Dan,
I would be interested in obtaining a the QMF queries/forms/proc and REXX mentioned below.
Thanks in advance.
Odimir mailto: odimir.barbosa@eds.com > -----Original Message----- > From: DANIEL CYR [SMTP:DCYR@EMAIL.USPS.GOV] > Sent: Tuesday, January 04, 2000 12:37 AM > To: DB2-L@RYCI.COM > Subject: Re: Automated DB2 Statistics replication between Production > > > Christine, > > I have a set of QMF queries/forms/proc/REXX that migrates our > production stats to the test/development subsystem. Let me know and > I can send an e-mail with attachments. > > Dan > dcyr@email.usps.gov > > > ______________________________ Reply Separator > _________________________________ > Subject: Automated [...]
4824 37 30_Re: HANDLE PARAMETER NOT VALID13_Lynne Flatley17_LFlatley@NEFN.COM30_Tue, 4 Jan 2000 07:23:07 -0500301_us-ascii Are you saying that the jobs have not begun to execute yet and you want to cancel them? Or, are you saying that you scheduled these jobs, they executed (or are executing) and now you want to stop seeing them as pending jobs? I too am using UDB 6.1 (on NT) and haven't seen this problem. [...]
4862 46 67_Re: Automated DB2 Statistics replication between Production & Tes t13_Lynne Flatley17_LFlatley@NEFN.COM30_Tue, 4 Jan 2000 07:27:06 -0500634_us-ascii Actually, Platinum's Database Analyzer product is supposed to be able to automate this process. I haven't gotten it to do that yet, though. Anyone else?
> -----Original Message----- > From: Christine Sawyer [SMTP:cosawyer@HOTMAIL.COM] > Sent: Monday, January 03, 2000 6:23 PM > To: DB2-L@RYCI.COM > Subject: Automated DB2 Statistics replication between Production & > Test > > Can anyone share some experience on this one? I will like to set up a ajob > to automatically update one of our test databases with production > statistics > on a weekly basis. Currently, we manually do this using Platinum's > MIGRATOR [...]
4909 163 30_Re: HANDLE PARAMETER NOT VALID14_Popy A. Dimoka24_dimokap@INTERAMERICAN.GR30_Tue, 4 Jan 2000 14:35:18 +0200475_iso-8859-1 Sorry if i didn't make myself clear! The jobs are scheduled to run tomorrow so haven't not started to execute yet. They are just in the pending jobs queue and i want to cancel them.Even if i try to reschedule,the error message still remains the same. My (test) platform is Win98. ----- Original Message ----- From: Lynne Flatley Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Tuesday, January 04, 2000 2:23 PM Subject: Re: HANDLE PARAMETER NOT VALID [...]
5073 39 46_Re: Time out function utility for Applications17_Marchese, Frank D18_fdmarchese@ATT.COM30_Tue, 4 Jan 2000 07:59:33 -0500406_iso-8859-1 Check out the Admin Guide Vol 2, p 5-122 and 123. It's not exactly what you describe but maybe it's better than nothing. I'm just not sure if the manual is describing distributed threads only or not.
-----Original Message----- From: Nash Gupta [mailto:nashgupt@US.IBM.COM] Sent: Monday, January 03, 2000 6:57 PM To: DB2-L@RYCI.COM Subject: Time out function utility for Applications [...]
5113 28 30_Anybody using DB2 PM with SAP?22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Tue, 4 Jan 2000 13:02:09 +0000393_ISO-8859-1 Hi all, is anybody using PM with SAP? We are and would be interested in understanding the type of near term history information (and other bits) that you found to be usefull - what would you not do again and what would you do in the future with PM.
We are about to go Datashairng this month and would also be interested if anybody has used PM in a SAP DS environment .. [...]
5142 30 24_Re: BP0 Getpages -- Why?0_22_kmulcahy@CHECKFREE.COM30_Tue, 4 Jan 2000 08:08:33 -0500454_us-ascii Thanks for the replies! We are getting BP0 getpage activity on CICS transactions, and the reason is not apparent to me. There is no dynamic SQL and no objects in BP0 other than the DB2 catalog and directory. The number of BP0 getpages is constant and significant. I suspect authorization and am researching this, but can't turn on a trace in production right now. Does anyone have any more ideas? Here are some BP0 I/O statistics from B&B: [...]
5173 105 41_Re: Stored Procedure - information please0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Tue, 4 Jan 2000 07:15:53 -0600339_us-ascii Martin, I'll answer part of your question. Why we chose to go with stored procedures. (We use WLM established stored procedures and DB2 Connect.) Make sure you are at the right level of LE. , When developers choose to use stored procedures in our shop its usually because they answered yes to one of the following questions. [...]
5279 140 21_Re: Reorg DB2 catalog23_Donald W. Woodruff, Jr.30_dwoodruf@CI.NEWPORT-NEWS.VA.US30_Tue, 4 Jan 2000 08:30:43 -050085_iso-8859-1 Could you send me a copy also?
Thanks in advance...
5420 63 25_Re: DB2Perf.DLL in UDB/NT13_George Peters22_gpeters@COMPUSERVE.COM30_Tue, 4 Jan 2000 08:49:34 -0500632_iso-8859-1 Lourdes - well, at least you replied! George
> -----Original Message----- > From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of > Lourdes Kishi > Sent: Tuesday, January 04, 2000 3:16 AM > To: DB2-L@RYCI.COM > Subject: RES: DB2Perf.DLL in UDB/NT > > > > Sorry... I don' t know anything about UDB... (yet) > > -----Mensagem original----- > De: DB2 Data Base Discussion List at INTERNET > Enviada em: terça-feira, 4 de janeiro de 2000 14:51 > Para: DB2-L@RYCI.COM at INTERNET > Assunto: DB2Perf.DLL in UDB/NT > > > Thought I'd ask this one again..... > Hi - question re DB2 UDB [...]
5484 66 36_Re: PowerBuilder 6.5 & DB2 OS/390 V614_McCombs, Terry20_tmccomb@SEDGWICK.GOV30_Tue, 4 Jan 2000 08:04:17 -0600470_us-ascii There is a wildcard option that must be unchecked in order to see columns of tables with names containing an underscore. I learned about this a few months ago from a post on this list, and it solved our problem. Hope this helps.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Steve Grimes Sent: Monday, January 03, 2000 4:00 PM To: DB2-L@RYCI.COM Subject: PowerBuilder 6.5 & DB2 OS/390 V6 [...]
5551 65 58_Re: Time out function utility for Applications / Platform?11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM30_Tue, 4 Jan 2000 09:24:41 -0500577_iso-8859-1 New years resolutions: 1) Get more exercise 2) Play with the spouse and kids more often 3) Remember to include DB2 platform on DB2-L when asking questions
:)
DB2 NT, UNIX, OS/2 includes a tool called the governor. I did an extensive presentation on its features and use at DB2 Tech last fall in New Orleans, you may have or be able to get the CD from a friend. The Governor can be used to force off connections that have been idle for a defined period of time. This functionality works reasonably well, perhaps one of the tools better features... [...]
5617 66 21_Re: Disaster Recovery19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 4 Jan 2000 08:39:06 -0600485_iso-8859-1 Dave, For Q#2 . . . in addition to Lesley's suggestion, you can always recover to a DB2 checkpoint RBA/LRSN closest to the time/point other data stores are using and handle any inflights/indoubts. Without a system/enterprise-wide? quiesce, which syncs all data stores, this is about best you can do. Note: most shops simply restore/recover all data stores as far forward as they can and deal with any out-of-sync conditions, unless, of course, there is a large gap(s). [...]
5684 19 12_Broken pages12_Canvas Botha18_vzbotha@MWEB.CO.ZA30_Tue, 4 Jan 2000 16:35:15 +0200309_us-ascii We have been running our first full business run last night and DB2 let me down!! I encountered a number of broken pages "00C200FD" on our largest database. Although it was easy to fix I am concerned about it. Tonight we will try to isolate the problem. Anybody out there with similar problems? [...]
5704 71 58_Re: Time out function utility for Applications / Platform?13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET30_Tue, 4 Jan 2000 09:28:41 -0500522_us-ascii I read all the messages that come thru, would appreciate how to get a copy of the cd...thanks
Scott Hayes wrote:
> New years resolutions: > 1) Get more exercise > 2) Play with the spouse and kids more often > 3) Remember to include DB2 platform on DB2-L when asking questions > > :) > > DB2 NT, UNIX, OS/2 includes a tool called the governor. I did an extensive > presentation on its features and use at DB2 Tech last fall in New Orleans, > you may have or be able to get the CD from a friend. [...]
5776 103 31_Re: TCP/IP connection to OS/39014_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Tue, 4 Jan 2000 09:43:47 -0500643_iso-8859-1 Srini:
I thought you do NOT need to update the tables in CDB (IPNAMES, LOCATIONS etc) for inbound requests.
Manas.
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > SrinivasG > Sent: Monday, January 03, 2000 7:31 PM > To: DB2-L@RYCI.COM > Subject: Re: TCP/IP connection to OS/390 > > > Hi, > Happy new year to all of you. > > After enabling TCPIP, the Sysprog has to populate the communications > database. Namely SYSIBM.IPNAMES , SYSIBM.LUNAMES (for SNA), > SYSIBM.LOCATIONS etc. Please refer to the DB2 Installation manual for > details. For access [...]
5880 75 18_Re: aix/udb newbie11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM30_Tue, 4 Jan 2000 09:46:52 -0500371_iso-8859-1 Sherri,
Do a binary FTP of the downloaded file from your PC/Jazz drive to a file system on your AIX machine that has at least 250MB of free disk space.
You should also do an ASCII FTP of the Fixpak.Readme file to the same location.
Uncompress and un-tar the fixpack file (eg. U468276.tar.Z): prompt> zcat < U468276.tar.Z | tar -xvf - [...]
5956 53 24_Re: BP0 Getpages -- Why?15_Murley, Michael22_Michael_Murley@BMC.COM30_Tue, 4 Jan 2000 08:45:02 -0600468_ISO-8859-1 If there are any update (UPDATE, INSERT, or DELETE) transactions, getpages for SYSLGRNX and its indexes are expected, since an update to a table space not previously open for update causes DB2 to insert a new SYSLGNRX row.
The getpages for SPT01 show up when DB2 loads a package into the EDMPOOL, I think. I'm surprised you don't see any activity for DSNDB01.DBD01 for DBD access (maybe it's just not included in the reporting interval below?). [...]
6010 98 41_Re: Reorg DB2 catalog/MODIFY running time13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM30_Tue, 4 Jan 2000 09:41:16 -0500541_us-ascii Would you please send me a copy of the jobs and aux REXX??? TIA
mebert@AMADEUS.NET wrote: > > Hello, > > yes I have done this about 4 months ago (DB2 V5, OS/390 R2.6). You can find some > exchanges on this in the archives because the first try left me with an empty > Cat/Dir because of a coding error, and then I had trouble recovering the Cat/Dir > because I kept specifying the Index space names instead of the Index names. Now > I have working & tested JCLs for Cat/Dir Reorg, Cat/Dir Recover, Check/Checkr > and an [...]
6109 69 67_Re: Automated DB2 Statistics replication between Production & Tes t15_Philip, Sibimon19_PhilipS@SEALAND.COM30_Tue, 4 Jan 2000 09:57:06 -0500445_iso-8859-1 Is there any BMC product which does this? I too would like to know more about this.
Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com
-----Original Message----- From: Lynne Flatley [mailto:LFlatley@NEFN.COM] Sent: Tuesday, January 04, 2000 6:27 AM To: DB2-L@RYCI.COM Subject: Re: Automated DB2 Statistics replication between Production & Tes t [...]
6179 89 21_Re: Disaster Recovery22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Tue, 4 Jan 2000 14:59:45 +0000743_ISO-8859-1 Rick - yep forgot about that one .. :-) so easy to overlook the obvious things like system checkpoints ...
cheers
Leslie
______________________________ Reply Separator _________________________________ Subject: Re: Disaster Recovery Author: "DAVIS; RICK (SBCSI)" at Internet Date: 1/4/00 8:39 AM
Dave, For Q#2 . . . in addition to Lesley's suggestion, you can always recover to a DB2 checkpoint RBA/LRSN closest to the time/point other data stores are using and handle any inflights/indoubts. Without a system/enterprise-wide? quiesce, which syncs all data stores, this is about best you can do. Note: most shops simply restore/recover all data stores as far [...]
6269 50 45_=?iso-8859-1?B?UulmLiA6IEJyb2tlbiBwYWdlcw==?=0_26_denzil.coulter@UNICIBLE.CH30_Tue, 4 Jan 2000 16:15:48 +0100674_iso-8859-1 what version of DB2 and OS390 are you?
Canvas Botha @RYCI.COM> le 04.01.2000 15:35:15
Veuillez répondre à DB2 Data Base Discussion List
Envoyé par : DB2 Data Base Discussion List
Pour : DB2-L@RYCI.COM cc :
Objet : Broken pages
We have been running our first full business run last night and DB2 let me down!! I encountered a number of broken pages "00C200FD" on our largest database. Although it was easy to fix I am concerned about it. Tonight we will try to isolate the problem. Anybody out there with similar problems? [...]
6320 24 34_DSNZPARM Option SEQCACH for RAID ?11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Tue, 4 Jan 2000 10:17:37 -0500362_iso-8859-1 I have looked at the redbook
STORAGE MANAGEMENT WITH DB2 FOR OS/390
and there is not much specific info there on this Zparm. Does anyone have advice and/or experience for this with Hitachi or EMC DASD configurations ? Any specific gotchas ? What size DASD caches are you using ?
Lee Hayden DB2 SysProg (904) 366-4169 [...]
6345 127 31_Re: TCP/IP connection to OS/3909_SrinivasG17_SRINIVASG@INF.COM30_Tue, 4 Jan 2000 20:48:38 +0530297_iso-8859-1 Hi,
You definately need to incase you are trying to connect from a PC or a Remote Database to the Mainframe DB2. I had to do it for my site. Insert a blank row in IPNAMES and then try. It will work.
Bye Srinivas G DB2 DBA, INFOSYS TECHNOLOGIES Ltd, Bangalore, INDIA. [...]
6473 121 67_Re: Automated DB2 Statistics replication between Production & Tes t9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Tue, 4 Jan 2000 15:27:30 +0000449_us-ascii BMC DASD Manager Plus allows you to use the following 'utilities'. BMCUPRS - Update the DB2 catalog using stats held in the DASD Manager database. BMCCPRS - Update the 'BMC' stats held in the DASD Manager database using stats from the DB2 Catalog.
It would require 'BMC' stats data being copied from DASD Manager tables in your 'source' DB2 to your 'target' DB2 if the 'source' and the 'target' are not the same DB2 sub-system. [...]
6595 78 51_Re: Making a copy of a database for query\reporting13_B. J. Scherer18_BScherer@QUEST.COM30_Tue, 4 Jan 2000 07:29:43 -0800555_iso-8859-1 I agree with your statement that you need to asses the value of the data being up to date and the amount of DASD / tape that you need to accommodate a replication / propagation tool. The additional log activity, due to the Data Capture, is an initial fear but those who have implemented it have not complained about the additional logging. Depending on the activity, the additional logs may be minimal. If there is a lot of activity, then all the more reason to give the user their data in a timely manner. Either way, the ability to keep [...]
6674 469 59_Re: Automated DB2 Statistics replication between Production10_DANIEL CYR19_DCYR@EMAIL.USPS.GOV30_Tue, 4 Jan 2000 10:33:41 -0600688_iso-8859-1 Christine, e-mail if you have any questions. Dan
______________________________ Reply Separator _________________________________ Subject: Automated DB2 Statistics replication between Production & Te Author: owner-db2-l@RYCI.COM at INTERNET Date: 01/03/2000 6:33 PM
Can anyone share some experience on this one? I will like to set up a ajob to automatically update one of our test databases with production statistics on a weekly basis. Currently, we manually do this using Platinum's MIGRATOR product. I will appreciate any information/material anyone may provide Or where I can get more information about it? Any documented step by step procedure? [...]
7144 28 35_Stored Procedure Builder on UDB 6.10_25_Pierre.Evans@AUTOZONE.COM30_Tue, 4 Jan 2000 09:30:49 -0600330_us-ascii Greetings all, Has anyone used the new Stored Procedure Builder yet in UDB 6.1 ? I've started to test it but haven't been able to successfully build a Java SP (although it will generate). I keep getting a SQL4301, which indicates "An error occurred while attempting to start or communicate with a Java interpreter". [...]
7173 121 67_Re: Automated DB2 Statistics replication between Production & Tes t17_Lobenstein, Jerry30_Jerry_Lobenstein@COMPUWARE.COM30_Tue, 4 Jan 2000 10:37:30 -0500294_iso-8859-1 DBA-Xpert Utility Manager will allow the DBA to define a rules set to move stat's between DB2 Catalogs. It would collect the stat's in the UM Tables and then copy from the UM tables source DB2 to your target DB2 if the 'source' and the 'target' are not the same DB2 sub-system. [...]
7295 145 31_Re: TCP/IP connection to OS/39017_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM30_Tue, 4 Jan 2000 10:34:56 -0500599_iso-8859-1 We connect just fine from PC's without anything in SYSIBM.IPNAMES. I don't have a clue as to the origional problem, but this doesn't seem likely to be the fix.
Craig Snoeyenbos
-----Original Message----- From: SrinivasG [mailto:SRINIVASG@INF.COM] Sent: Tuesday, January 04, 2000 10:19 AM To: DB2-L@RYCI.COM Subject: Re: TCP/IP connection to OS/390
Hi,
You definately need to incase you are trying to connect from a PC or a Remote Database to the Mainframe DB2. I had to do it for my site. Insert a blank row in IPNAMES and then try. It will work. [...]
7441 160 67_Re: Automated DB2 Statistics replication between Production & Tes t15_Philip, Sibimon19_PhilipS@SEALAND.COM30_Tue, 4 Jan 2000 10:41:59 -0500351_iso-8859-1 Andy...Thanks for the reply Our production and TEST is in two different subsystem. I would like to have an option in BMC as follows
1. Create a migration profile which contain all the table for which the statistics need to be copied from production. 2. Do a analysis in production 3. Import the analysis and execute it in TEST. [...]
7602 17 38_Re: DSNZPARM Option SEQCACH for RAID ?12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 4 Jan 2000 07:46:37 -0800308_us-ascii I would always say to set the sequential caching parameter to SEQ for any RAID device. Some of the units appear to ignore the setting, but the sequential hint can be very important in some cases. Unless your cache sizes are very small and not managed, sequential is better.
Roger Miller [...]
7620 28 20_Using One Global CSI9_John Reid14_jreid@FBFS.COM30_Tue, 4 Jan 2000 09:54:13 -0600575_us-ascii Hi list,
I have a questions from our DB2 Systems Programmer. We are on DB2 OS390 v5.1, :
It follows:
Our shop is considering using one global csi for DB2, CICS, and MVS. The idea is to bring new releases of these products in at the same time to be on the same maintenance level. We would then have cross system dependencies in one csi for maintenance. I have some concerns about doing this thinking it might make putting on maintenance more complicated. I was wondering if anyone else is using one global csi for all these systems and what [...]
7649 54 24_Re: BP0 Getpages -- Why?13_Adrian Savory24_adrian.savory@ZURICH.COM30_Tue, 4 Jan 2000 16:16:47 +0000726_us-ascii Not using a shadow catalog for 3rd party utilities by any chance?
Adrian Savory ACSIS Ltd
kmulcahy@CHECKFREE.COM on 04/01/2000 13:08:33
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Adrian Savory/ZI/England/Zurich)
Subject: Re: BP0 Getpages -- Why?
Thanks for the replies! We are getting BP0 getpage activity on CICS transactions, and the reason is not apparent to me. There is no dynamic SQL and no objects in BP0 other than the DB2 catalog and directory. The number of BP0 getpages is constant and significant. I suspect authorization and am researching this, but can't turn on a [...]
7704 71 59_Re: Automated DB2 Statistics replication between Production16_Christine Sawyer20_cosawyer@HOTMAIL.COM28_Tue, 4 Jan 2000 11:17:22 EST714_- Good morning Mr. Cyr, Re: your email below: Please by all means do!!. Thanks in advance for the time & effort Christine
>From: DANIEL CYR >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Automated DB2 Statistics replication between Production >Date: Mon, 3 Jan 2000 20:36:35 -0600 > > > Christine, > > I have a set of QMF queries/forms/proc/REXX that migrates our > production stats to the test/development subsystem. Let me know and > I can send an e-mail with attachments. > > Dan > dcyr@email.usps.gov > > >______________________________ Reply Separator >_________________________________ >Subject: Automated DB2 Statistics [...]
7776 34 38_Re: DSNZPARM Option SEQCACH for RAID ?14_Massimo Scarpa16_mscarpa@CESVE.IT30_Tue, 4 Jan 2000 17:21:07 +0100272_us-ascii I set SEQCACHE SEQ many years ago and it works well.
Ted Blank, an IBM RVA/RAID expert said to use SEQ when cache size is > 64 Mb, but I think it's better if it is greater than 256 MB, because we saw many bypass cache in DB2 DASDs with some old 3990. [...]
7811 70 21_Re: Disaster Recovery0_21_kramps@NATIONWIDE.COM30_Tue, 4 Jan 2000 11:22:32 -0500580_us-ascii You've gotten a number of good responses so far, but one thing I haven't seen addressed yet is the very labor-intensive process of updating the bootstrap dataset. We have automated almost all of this. We use reports from our tape management system as input to some File Aid jobs. These jobs create the delete and newlog statements for the archive logs. The only manual work that we do now to the bootstrap dataset are to delete and add the new active logs, add the last archive log, update the high rba, and create the conditional restart record. Everything else is [...]
7882 212 67_Re: Automated DB2 Statistics replication between Production & Tes t9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Tue, 4 Jan 2000 16:31:52 +0000531_us-ascii If your 'source' and 'target' are in different DB2 sub-systems, then I think that the BMC DASD Manager option may be too complicated. Transferring BMC statistics data between DB2 sub-systems and converting object qualifier/names etc. (if different) would require an in-house program to be written. This does not deliver the degree of automation you require. Therefore I think a system using BMCUPRS/BMCCPRS could only be practically used in the same sub-system. Kind Regards, Andy Hunt - Scottish And Southern Energy [...]
8095 65 59_Re: Automated DB2 Statistics replication between Production13_Karen Daniels21_Karen.Daniels@TRW.COM30_Tue, 4 Jan 2000 08:32:42 -0800602_US-ASCII I would appreciate a copy of those myself.
Thanks, Karen Daniels
<<< DANIEL CYR 1/ 3 8:39p >>>
Christine,
I have a set of QMF queries/forms/proc/REXX that migrates our production stats to the test/development subsystem. Let me know and I can send an e-mail with attachments.
Dan dcyr@email.usps.gov
______________________________ Reply Separator _________________________________ Subject: Automated DB2 Statistics replication between Production & Te Author: owner-db2-l@RYCI.COM at INTERNET Date: 01/03/2000 6:33 PM [...]
8161 277 59_Re: Automated DB2 Statistics replication between Production0_23_J.P.Slot@RF.RABOBANK.NL30_Tue, 4 Jan 2000 17:39:07 +0100422_us-ascii The size of the Message Text is 7736(> 6K), So it is kept in the First Attachment Andy,
Just at thought crossed my mind.. Isn't it possible to use change manager form BMC to do this? Using the migrate option?
Regards,
Jaap Slot
PS. A little late perhaps, but all you Listers a very happy and prosperous 2000! ----------------------[Reply - Original Message]---------------------- [...]
8439 193 66_Re: Automated DB2 Statistics replication between Production & Test9_Sally Mir16_smir@BCBS-GA.COM30_Tue, 4 Jan 2000 11:40:32 -0500332_us-ascii I haven't seen anyone mention Platinum's Statistics Manager, which comes with Plan Analyzer. With it, you can extract stats from one subsystem, apply masks to change database names, table and index creator names, etc., and update the catalog in another subsystem with those stats. Sounds like what you're looking for. [...]
8633 41 11_unsubscribe2_JM14_jumori@IBM.NET30_Wed, 5 Jan 2000 01:48:26 +0900183_iso-2022-jp unsubscribe
------------------------------------------------ Junji Mori E-Mail:jumori@attglobal.net ------------------------------------------------
8675 127 21_Re: Disaster Recovery9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Tue, 4 Jan 2000 16:48:49 +0000446_us-ascii Taking the 'automated' BSDS update a stage further.....
I worked at a previous site where we created a 'Disaster Recovery BSDS' after each archive log was produced (invoked after each issue of DSNJ003I). The actual BSDS and actual archive log were then immediately copied as file 1 and 2 on an offsite version of the archive log. This 'Disaster Recovery BSDS' was then written as a 3rd file on our offsite archive log tapes. [...]
8803 99 21_Re: Disaster Recovery22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Tue, 4 Jan 2000 16:52:18 +0000304_ISO-8859-1 Hi we too have automation for all aspects of the DR build and at the DR site.. we use Platinum Recovery Analyser.
this works great for us ..
Incidentally I now think that with PRA we can put our DR jobs into ControlM and not even need a DB2 DBA at DR ... wonderful. [...]
8903 55 39_Re: Stored Procedure Builder on UDB 6.110_Leo Pedron19_lpedron@BOSCOVS.COM30_Tue, 4 Jan 2000 11:51:12 -0500481_iso-8859-1 Try setting the (KEEPDARI) parameter in the DBM CFG to NO and set the (JAVA11_PATH) parm to \SQLLIB\JAVA\JDK. Refer to the Application Building Guide and Application Development Guide for sample stored procedure source code that you can use to test the SPB. You can find them online http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report#UDBPUBS
These examples helped us to find our mistakes. My experience with the SPB is only with JDBC apps. [...]
8959 63 24_Re: Using One Global CSI22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Tue, 4 Jan 2000 12:07:39 -0500307_- I assume you're interested in IBM software. I've worked in environments with one Global CSI and separate Global CSIs. I prefer one Global CSI. It's a shared resource among the Sys Progs so it must be managed accordingly, backups, recoveries etc... Each product still has its own target & dlib zones. [...]
9023 328 59_Re: Automated DB2 Statistics replication between Production9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Tue, 4 Jan 2000 17:09:46 +0000583_us-ascii Jaap, I dont believe you can just migrate data using BMC Change Manager. If you migrate a table and specify 'Data Y (and everything else N) ' in the migration options for the table, the worklist generates a CREATE TABLE.... statement in the worklist. I have used Change Manager to move data in this way but it has always involved me manually editing the worklist to remove unwanted DDL. I dont think Change Manager could help in changing the names of the objects in the statistics records since these changes would need to be made to the unloaded/reloaded data (rather [...]
9352 44 24_Re: BP0 Getpages -- Why?14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Tue, 4 Jan 2000 11:33:09 -0600394_ISO-8859-1 Kevin:
First of all, verify that the tablespaces and indexes of all accessed objects are actually in a bufferpool other than BP0. You might have missed one or perhaps there is some access to an object that you were not aware of.
Secondly, if the transaction uses any dynamic SQL, access to the catalog (in BP0) will occur when the SQL is prepared during run time. [...]
9397 352 59_Re: Automated DB2 Statistics replication between Production13_Horton, Libby20_Libby_Horton@BMC.COM30_Tue, 4 Jan 2000 11:39:44 -0600500_ISO-8859-1 Hello, For a data only migrate using BMC Change Manager if you go to the Override screen from the Analysis interface and then remove the S from SQL you won't get the Create Table DDL in the worklist. Best regards, Libby Horton BMC Product Support 1-800-537-1813
-----Original Message----- From: Andy Hunt [mailto:Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK] Sent: Tuesday, January 04, 2000 11:10 AM To: DB2-L@RYCI.COM Subject: Re: Automated DB2 Statistics replication between Production [...]
9750 71 24_Re: BP0 Getpages -- Why?22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Tue, 4 Jan 2000 13:08:58 -0500666_- Kevin :
Another possibility - I would think the REOPT(VARS) bind option causes getpages to the catalog/directory.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: Mullins, Craig[SMTP:Craig_Mullins@BMC.COM] > Sent: Tuesday, January 04, 2000 12:33 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] BP0 Getpages -- Why? > > Kevin: > > First of all, verify that the tablespaces and indexes of all accessed > objects are actually in a bufferpool other than BP0. You might have missed > one or perhaps there is some access to an object that you were not aware > of. > > Secondly, if [...]
9822 93 21_Re: Disaster Recovery50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Tue, 4 Jan 2000 13:10:12 -0500617_- I set up BMC recovery manager and it took care of all of this. Why do this manually?
> ---------- > From: kramps@NATIONWIDE.COM[SMTP:kramps@NATIONWIDE.COM] > Reply To: DB2 Data Base Discussion List > Sent: Tuesday, January 04, 2000 11:22 AM > To: DB2-L@RYCI.COM > Subject: Re: Disaster Recovery > > You've gotten a number of good responses so far, but one thing I haven't > seen addressed yet is the very labor-intensive process of updating the > bootstrap dataset. We have automated almost all of this. We use reports > from our tape management system as input to some File Aid [...]
9916 39 40_Government Claims Credit for Y2K Victory16_Charles Stansell19_cfstansell@JUNO.COM30_Tue, 4 Jan 2000 12:18:57 -0600548_- Hey All,
Listening on TV to the government spokesman for Y2K, he seems to be claiming that the reason that the Y2K rollover went so well was due to the massive, well coordinated government effort. I think he said something about a Y2K office or something. Well I'm sure they spent lots of Tax Dollars but it's funny, I don't remember seeing anybody from the government here to help me fix code. And all this time I thought it was our company management that was making sure things got done, I had no idea it was really Uncle Sam that [...]
9956 28 43_Automatic Deletion of Log Files in UDB v6.10_22_BILL_GALLAGHER@PHL.COM30_Tue, 4 Jan 2000 13:24:40 -0500579_us-ascii I've just compiled, linked, and enabled the "db2uext2" exit in UDB v6.1 for one of our databases to archive and retrieve database log files through ADSM. Unfortunately, this procedure does not seem to delete the log file from the log directory once it has been archived through ADSM.
How are other people handling some sort of automated deletion of log files in UDB? I would like to set something up in our environment so that we wouldn't start filling up our disks with log files if they're being archived somewhere else, and I would like to see this as an [...]
9985 61 44_Re: Government Claims Credit for Y2K Victory11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM30_Tue, 4 Jan 2000 12:27:51 -0600464_us-ascii AMEN! My management thought I was the nut when in 1988 I showed a 15 year Gas Lease was not calculated correctly!
Charles Stansell on 01/04/2000 12:18:57 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Ray H Janes/C/Dallas/Mobil-Notes) Subject: Government Claims Credit for Y2K Victory
Hey All, [...]
10047 40 31_function of DSNIDM and DSNIRNXT17_Bruzdzinski, Mike24_MIKE.BRUZDZINSKI@SSA.GOV30_Tue, 4 Jan 2000 13:35:58 -0500372_iso-8859-1 We are experiencing a problem with a DB2-CICS transaction that had sub-second response time a few moths ago and is now getting large number of SQL calls and is spending a lot of time in the following DB2 Modules: DSNIDM and DSNIRNXT.
We tried to locate some information about the modules. The best we could find is some references to them in APARS. [...]
10088 250 44_Re: Government Claims Credit for Y2K Victory14_Sutton, Donald29_DSutton@CEOIT.CO.ORANGE.CA.US30_Tue, 4 Jan 2000 10:04:01 -0800448_iso-8859-1 Al G is too busy re-inventing himself at the moment, so I guess we will have to fend for ourselves for now.
-----Original Message----- From: Ray H Janes [mailto:ray_h_janes@EMAIL.MOBIL.COM] Sent: Tuesday, January 04, 2000 10:00 AM To: DB2-L@RYCI.COM Subject: Re: Government Claims Credit for Y2K Victory
AMEN! My management thought I was the nut when in 1988 I showed a 15 year Gas Lease was not calculated correctly! [...]
10339 65 35_Re: function of DSNIDM and DSNIRNXT9_Fox, Dave16_Dave_Fox@BMC.COM30_Tue, 4 Jan 2000 12:52:40 -0600522_ISO-8859-1 Mike,
DSNIDM is the load module containing the Data Manager routines, of which DSNIRNXT is one [see DSNSAMP(DSNWMODS) for brief routine description]. The description for DSNIRNXT is "move CUB to next record", implying that a cursor is moving from one record to the next in a sequential scan. See if your accounting data shows an increased number of FETCH calls. Sounds to me like an index may have been dropped, or you added a bunch of rows that expanded the answer set of a previously small query. [...]
10405 64 44_Re: Government Claims Credit for Y2K Victory0_23_Mike_Levine@TEKHELP.NET30_Tue, 4 Jan 2000 13:53:17 -0500562_us-ascii Hi,
Good point. To be fair though, the Republicans were ready to come down hard on Clinton and company if there were real problems. They would have had no choice but to accept a lot of the blame and there would have been plenty to go around (Gore would have been finished). The best thing the government did do was to paint all those rosy forecasts of no problems which kept the general public calm. I was quite (pleasantly) surprised that the public remained so calm and that the rollover went so seemingly well. I do not believe that this [...]
10470 74 44_Re: Government Claims Credit for Y2K Victory8_Long, Ed15_Ed.Long@FMR.COM30_Tue, 4 Jan 2000 14:07:03 -0500520_- Now thats what I call a "BUSH" comment!!
The guy indicts himself if he thinks that Y2K is over. There is after all the little matter of 2/29/00 and I'm not sure but I think we have only run 1 business day in the new millenium. He clearly doesn't remember the Heidi game of long ago that cost an NBC TV programmer his job. N.Y. Jets score 21 points in last 3 minutes to defeat Oakland but no one in country sees the fabulous finish because it was 7Pm in the Eastern time zone and he switched the network to [...]
10545 103 44_Re: Government Claims Credit for Y2K Victory13_Lynne Flatley17_LFlatley@NEFN.COM30_Tue, 4 Jan 2000 14:16:04 -0500570_us-ascii Hi Ed!
Yes, DB2 Connect is being used in production for one of our apps that has over 500 users (although the number of actual concurrent users is much lower). I can put you in touch with our DB2 Connect guy...
> -----Original Message----- > From: Long, Ed [SMTP:Ed.Long@FMR.COM] > Sent: Tuesday, January 04, 2000 2:07 PM > To: DB2-L@RYCI.COM > Subject: Re: Government Claims Credit for Y2K Victory > > Now thats what I call a "BUSH" comment!! > > The guy indicts himself if he thinks that Y2K is over. There is after all > the little matter [...]
10649 103 44_Re: Government Claims Credit for Y2K Victory14_O'Conner, John26_john.oconner@COURTS.WA.GOV30_Tue, 4 Jan 2000 11:42:55 -0800569_iso-8859-1 We were lucky. The fortunes of time were on our side. In the late '80s we converted our largest application from Wang super minicomputers to the mainframe. Since the code was basically rewritten (and the database redesigned), we added century to all our dates. About five years ago we migrated our other large application from ADABAS to DB2. We added century to all our dates at that time. The rest of our code was easily changed for Y2K in the last couple of years. Months ago we started a new LPAR at 12/31/1999 and watched it roll over to 01/01/2000 [...]
10753 82 48_Re: FW: Government Claims Credit for Y2K Victory16_Charles Stansell19_cfstansell@JUNO.COM30_Tue, 4 Jan 2000 13:57:03 -0600587_- Craig (Craig.Snoeyenbos@starwoodhotels.com),
I knew there would be at least one person who would whine about cross-posting or spam. But I participate in all three newsgroups (DB2, CICS and MVS) and a great deal of effort was put forth by people in all three of these areas, as well as others. I think it was a travesty of some to claim the government coordination was more than just trivial in the outcome of the Y2K efforts. I believe the combined efforts of the people in these newsgroups was very significant. I thought the post was appropriate. It was also intended to [...]
10836 108 48_Re: FW: Government Claims Credit for Y2K Victory18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Tue, 4 Jan 2000 15:09:33 -0500284_iso-8859-1 Just my 2cents worth but I thought it was humerous... After all the hours we put into this Y2K boogy-man its good to get a little humor. Now on to bigger and better Y3K issues!! :-) It will be interesting to see what the next latest and greatest challenge will be.... [...]
10945 175 31_Re: TCP/IP connection to OS/39017_KUSTERS, ED (TAO)30_ED.KUSTERS.tao@CCRA-ADRC.GC.CA30_Tue, 4 Jan 2000 15:27:00 -0500550_iso-8859-1 Date: Tuesday, 4 January 2000 3:27pm ET To: db2-l@ryci.com From: KUSTERS.ED@RCT Subject: Re: TCP/IP connection to OS/390
We didn't touch the CDB at all on OS/390 and we are connecting from an NT PC running DB2 Connect v5.2. The error message mentions DDCS, which is the old name for DB2 Connect. Once we had the IP addresses and ports configured on the OS/390 IBM TCPIP stack for the DB2 sub-system as well as the DB2 DDF zparms set to match these, everything worked OK when we pointed DB2 Connect to the IP/Port combinations. [...]
11121 136 41_Re: Stored Procedure - information please14_Philip Gunning20_pgunning@BOSCOVS.COM30_Tue, 4 Jan 2000 15:51:29 -0500312_us-ascii Shan, Very good checklist. I wouldn't mind seeing a copy of your stored procedure standard if you have one. I have one I can share with anyone that needs one. Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Certified Solutions Expert -- CICS TS Assoc List Owner [...]
11258 102 36_Re: PowerBuilder 6.5 & DB2 OS/390 V612_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Tue, 4 Jan 2000 14:52:26 -0600807_us-ascii Thank you Terry. It was the wildcard option. It's working great now.
Thanks again!
Sg ---------------------- Forwarded by Steve Grimes/Systems/ais on 01/04/2000 02:52 PM ---------------------------
"McCombs, Terry" on 01/04/2000 08:04:17 AM
Please respond to tmccomb@sedgwick.gov
To: DB2-L@RYCI.COM
cc: (bcc: Steve Grimes/Systems/ais)
Subject: Re: PowerBuilder 6.5 & DB2 OS/390 V6
There is a wildcard option that must be unchecked in order to see columns of tables with names containing an underscore. I learned about this a few months ago from a post on this list, and it solved our problem. Hope this helps. [...]
11361 186 31_Re: TCP/IP connection to OS/39014_Philip Gunning20_pgunning@BOSCOVS.COM30_Tue, 4 Jan 2000 16:29:09 -0500354_us-ascii The CDB is not checked for TCPIP inbound requests and no entries are required. Make sure you have cataloged the correct ipaddress for host db2 in you DB2 Connect PE or EE database configuration. Then, see if you correctly specified it in the required host tcpip datasets. Then check your ddf startup and you should see a message like this: [...]
11548 60 24_Re: Using One Global CSI0_20_evans036@MC.DUKE.EDU30_Tue, 4 Jan 2000 16:41:22 -0500380_us-ascii john,
you may have problems with products/modules that are common to other (non db2) products. for example, if you have ims, the db2 irlm may 'clobber' the ims irlm which would be a problem if they need to be at different releases.
maybe you would also have probs with the cics attach stuff (since 4.1 cics is shipped with its own db2 attach modules). [...]
11609 34 41_Re: Stored Procedure - information please12_Jim Harrison12_jimh@QIS.NET30_Tue, 4 Jan 2000 16:04:21 -0500410_us-ascii Excellent timing Phil - I just sent out a note to our DB2 DBAs requesting we meet to discuss how we were going to deal with SPs. After helping a developer get started using them today I came up with 4 immediate concerns: Updating SYSPROCEDURES, updating the SPAS loadlib, START & STOP priviledges and output DDs and debugging facilities in the SPAS. I'd like to see what you have so far. Thanks! [...]
11644 231 31_FW: TCP/IP connection to OS/39014_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Tue, 4 Jan 2000 16:55:12 -0500686_iso-8859-1 -----Original Message----- From: Manas Dasgupta [mailto:manas.dasgupta@pfsfhq.com] Sent: Tuesday, January 04, 2000 4:46 PM To: pgunning@boscovs.com Subject: RE: TCP/IP connection to OS/390
Philip:
I do get the following message in the DDF start-up:
10.06.47 STC01818 DSNL004I -DB2E DDF START COMPLETE LOCATION ADCDB2E LU ADC1.A20DB2E GENERICLU -NONE DOMAIN INTL TCPPORT 446 RESPORT 1447
And the error message that I get appears on db2mstr on the host - which makes me think it is making it to OS/390 alright. So, the IP address is correct and I am using port 446. I've tried both authentication SERVER and DCS but get the same error. [...]
11876 19 13_COBOL,AIX,DB211_Dale Miller23_dmille@TRADESERVICE.COM30_Tue, 4 Jan 2000 16:52:08 -0500396_us-ascii Our system is written in MicroFocus Cobol running in an IBM AIX environment. We are attempting to enhance our system by offering a relational database, either SQLServer or DB2. We are using ISG as a funnel to transpost data and as a driver from the COBOL applications to either DB2 or SQL Server. Is there anyone out there doing a similar thing and if so, have you been successful? [...]
11896 71 41_Re: Stored Procedure - information please13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Tue, 4 Jan 2000 16:02:30 -0600637_iso-8859-1 You may want to consider use of SPs from client server/web applications via DDF.
The problem is how to locate the package in the correct collection, or how to execute different packages which reside in different collections. Normally Plans handle this by the use of the PKLIST parameter.
Plans are not used in by distributed applications, only collections are used to locate a package, so you cannot search through multiply collections to find a package. If you have a package in a common collection, and application packages in another collection, then you will find problems when you want the application [...]
11968 46 33_Re: How many DBAs does it take...4_Bill26_disch000@MAIL.GENMILLS.COM30_Tue, 4 Jan 2000 16:08:10 -0800349_- Here's some info:
DB2 V5.1 7 DB2 subsystems all non-data sharing SAP R/2 - Prod, QA, Test non-SAP - Prod, QA, Test (includes DW) Experimental - DBA new release, maint, etc.
Total structures: 327 databases 6100 tables 5300 indexes most are 1 table/tablespace most large tables use hardware compression including ALL the SAP data [...]
12015 25 30_Migration PS from NT to OS/39012_Silvia Motta21_silviamotta@YAHOO.COM30_Tue, 4 Jan 2000 14:28:43 -0800586_us-ascii Happy Y2K !!!
I have to migrate People Soft HR 7.5 from Sql Server/NT to DB2 v4/OS 390. Have anyone the correct and save steps to do it ? Thanks a lot !!
Silvia Motta DBA
__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://messenger.yahoo.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12041 160 41_Re: Stored Procedure - information please13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Tue, 4 Jan 2000 16:32:11 -0600494_iso-8859-1 WRT Stored Procedures (SPs) called from web applications and JAVA specifically, we are heading towards putting almost everything in SPs. This includes the obvious like business functions etc, but extends to screen validation, screen population, report generating.
The end result is that our client applications will handle the user interaction, screen presentation but basically be a series of calls to various SP. to do any kind of processing done against the database. [...]
12202 93 24_Re: Using One Global CSI22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Tue, 4 Jan 2000 19:26:25 -0500677_- The DB2 attach modules that shipped with CICS V4.1 and up are named (DSN2*) differently than the modules (DSNC*) shipped with DB2. It should not be a problem.
I'm not sure about the potential IRLM conflict.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: evans036@MC.DUKE.EDU[SMTP:evans036@MC.DUKE.EDU] > Sent: Tuesday, January 04, 2000 4:41 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Using One Global CSI > > john, > > you may have problems with products/modules that are common to other (non > db2) > products. for example, if you have ims, the db2 irlm may 'clobber' the ims > [...]
12296 196 41_Re: Stored Procedure - information please14_O'Conner, John26_john.oconner@COURTS.WA.GOV30_Tue, 4 Jan 2000 16:35:59 -0800549_iso-8859-1 This is the direction we want to go as well, but we have yet to implement our first SP. We plan to migrate to v6.1 (OS/390) in a couple of months. After that we will probably get serious about SPs. We expect to have a layering of SPs. Our host applications already contain business logic and the more complex cross edits, so these applications will start out accessing SPs that do only the basic SQL processing. But our new "web" apps will also want to use SPs for business logic and complex cross edits in addition to the basic SQL [...]
12493 70 34_Re: Migration PS from NT to OS/39012_Roger Miller19_millerrl@US.IBM.COM30_Tue, 4 Jan 2000 16:53:24 -0800437_us-ascii The first contact is your PeopleSoft representative. They have a migration technique. Here is a paste from the PeopleSoft web site.
A Choice of Leading Platforms
With PeopleSoft, you're never locked into a single platform vendor. PeopleTools and all PeopleSoft applications operate on a range of leading hardware and database platforms. So you have immediate choices throughout the life cycle of your system. [...]
12564 37 17_Re: COBOL,AIX,DB213_Umair Hussain25_umair_hussain@HOTMAIL.COM28_Tue, 4 Jan 2000 18:56:46 CST633_- DB2 on aix works very well both MF Cobol as well as IBM Cobol. Have supported both environments as a DBA.
>From: Dale Miller >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: COBOL,AIX,DB2 >Date: Tue, 4 Jan 2000 16:52:08 -0500 > >Our system is written in MicroFocus Cobol running in an IBM AIX >environment. We are attempting to enhance our system by offering a >relational database, either SQLServer or DB2. We are using ISG as a funnel >to transpost data and as a driver from the COBOL applications to either DB2 >or SQL Server. Is there anyone [...]
12602 120 24_Re: Using One Global CSI14_Steven Camitta30_steven.camitta@INGRAMMICRO.COM30_Tue, 4 Jan 2000 17:04:27 -0800500_iso-8859-1 The IRLM conflict that I have seen when sharing a common global zone between IMS and DB2 is that when ACCEPT processing is done by either, the PTF is deleted from the global zone and PTS. When the other guy does APPLY, the PTF is mysteriously missing. This can be addressed by setting the CLEANUP option of the OPTIONS entry to PURGE(NO) which will disable the purge on ACCEPT. You can run the REJECT PURGE manually for this FMID specifying both IMS and DB2 DLIB zones to be checked. [...]
12723 20 24_Re: Using One Global CSI13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Wed, 5 Jan 2000 08:34:19 +0530400_us-ascii hi !!
Using one global CSI file will only complicate the situations for you. If you have to seperate out the problems which the patches give normally, then it will be a real tedious work tracking them. Basically your maintenance of your CSI file will increase. !! .We have all the 3 CSI files seperate, and comfortably maintaining the same service levels for them. regards Vishy [...]
12744 69 31_Re: TCP/IP connection to OS/39012_MILLS,Robert26_robert.mills@DEWRSB.GOV.AU30_Wed, 5 Jan 2000 15:14:19 +1100313_iso-8859-1 Hi Manas,
I have been getting exactly the same error since I tried connecting to DB2 OS/390 V5 from UDB V6.1 (fixpack 2). The TCP/IP connection from UDB V5.2 to DB2 OS/390 still works perfectly, so I suspect it is possibly a software compatibility problem and not a configuration problem . [...]
12814 34 16_Re: Broken pages12_Canvas Botha18_vzbotha@MWEB.CO.ZA30_Tue, 4 Jan 2000 23:40:48 -0800515_- Our system is a 5 way sysplex running DB2 V5 on fix level 9908 and OS/390 2.6. All our data is managed by SMS. About a year ago when we upgraded from V4 to V5 I had similar problem. This one I think was caused by the Y2K though. Management wanted us to IPL all our machines. OPS did a power- on/reset on the coupleing facility while we had updating batch jobs running in the various DB2 members. Very naughty of them. But I would have liked DB2 to recover correctly from this. We have opened a call with IBM [...]
12849 22 0_6_Sumedh24_sumedh@CHENNAI.TCS.CO.IN30_Wed, 5 Jan 2000 10:12:02 +0530467_us-ascii Hi all Does JDBC driver for DB2 5.1 on OS/390 support java servlets accessing DB2 from Websphere? For DB2 version 5.1 on OS/390, we have installed the JDBC driver and also CLI. We were able to succesfully run the standalone Java sample SAMPLE01.JAVA that is supplied with the driver. Now when we are trying to run JDBCServlet.java supplied by websphere invoking thru the html supplied it is giving an exception. Can some one please help us out. Thanks. [...]
12872 137 21_Re: Disaster Recovery14_Massimo Scarpa16_mscarpa@CESVE.IT30_Wed, 5 Jan 2000 08:32:57 +0100350_us-ascii Because some companies have a very poor budget (or no budget at all) for disaster recover.
It's an old story: "A recovery tool costs to much, it's not startegic, here there are not any
earthquake, flood" etc. etc..
So do it manually, create a recovery strategy, type a lot of REXX and pgms....If all will be ok, my [...]
13010 64 103_FW: FW: Getting Started with DB2 Stored Procedures: Give Them a C all through the Network, SG24-4693-0112_Fertaki Gina20_GFertaki@EUROBANK.GR30_Wed, 5 Jan 2000 09:41:11 +0200524_windows-1253 Yes, this solved my problem with this redbook. I downloaded the latest version of Acrobat Reader (I had version 3.01 installed and I now have version 4.05)and I was able to view it online. Thank you Duane and everybody for all your answers. Gina
-----Original Message----- From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: Monday, January 03, 2000 6:36 PM To: DB2-L@RYCI.COM Subject: Re: FW: Getting Started with DB2 Stored Procedures: Give Them a C all through the Network, SG24-4693-01 [...]
13075 16 47_Re: Automatic Deletion of Log Files in UDB v6.114_Tom Decabooter27_Tom.Decabooter@HONDA-EU.COM30_Wed, 5 Jan 2000 09:07:31 +0100399_us-ascii In UDB on WinNT there is a command DB2ADUTL that allows to list and delete the backups/logs managed by ADSM.
Tom Decabooter Honda Europe N.V.
================================================ 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.
13092 28 31_A question about Connect PE 5.014_Massimo Scarpa16_mscarpa@CESVE.IT30_Wed, 5 Jan 2000 10:43:19 +0100392_us-ascii We have troubles with DB2 Connect Personal Edition 5.0.
On 30th Dec. all was ok, now 5th of January 2000 we can't connect to DB2 s/390 V5.
I think that DB2 Connect PE ODBC driver is not Y2K compatible and we obtain the error:
parameter "119c" , value "", not supported.
I'm downloading Fixpack 6 & 12, but is it the right way to solve our problems ? [...]
13121 111 21_Re: Reorg DB2 catalog0_24_ujjwal@LOT.TATASTEEL.COM28_Wed, 5 Jan 2000 09:46:07 GMT469_us-ascii Hi Mebert , Could you please send me the Jcl for CAT/DIR REORG jobs.I would be very thankful. UJJAL BHATTACHARYA DBA GROUP TATA STEEL ,JAMSHEDPUR ,INDIA PH - 430298
mebert@AMADEUS.NET@RYCI.COM> on 01/03/2000 03:37:32 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Re: Reorg DB2 catalog [...]
13233 23 46_Reorg DB2 catalog - a request to Michael Ebert14_Massimo Scarpa16_mscarpa@CESVE.IT30_Wed, 5 Jan 2000 11:03:52 +0100521_us-ascii I think it'll be better to post the JCL in DB2-l, so everyone can see the job......I'm interested too !
I 've made catalog reorgs, but it was in V4, so I would like to see if thera are differences between
JCLs.
Regards
Max Scarpa System Admin
================================================ 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.
13257 44 24_Question about faroffpos19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Wed, 5 Jan 2000 11:19:34 +0100389_iso-8859-1 Dear All,
I have just ran the query that is listed in the administration guide that will help you determine when a tablespace/index space will require reorganizing.
SELECT I.DBNAME, I.NAME FROM SYSIBM.SYSINDEXES I, SYSIBM.SYSINDEXPART P WHERE I.CREATOR = 'SQLUSRH' AND I.NAME = P.IXNAME AND I.CREATOR = P.IXCREATOR AND (P.FAROFFPOSF > 0 OR NEAROFFPOSF > 0) ; [...]
13302 83 28_Re: Question about faroffpos13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK30_Wed, 5 Jan 2000 10:41:02 -0000431_iso-8859-1 Neil,
To quote my esteemed colleague, Mike Holmans, "FAROFFPOS is a measure of the organisation of the data in the underlying table. It assumes that the index in question is the clustering index, and then tells you how many of the rows in the table are ill-placed given that assumption. In other words, if the index is not the clustering index, the value of FAROFFPOS tells you absolutely nothing of value." [...]
13386 70 35_Re: A question about Connect PE 5.024_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM30_Wed, 5 Jan 2000 21:50:52 +1100413_iso-8859-1 Massimo,
From my experience a 119c error is indicative of a codepage error.
You should check your DB2CODEPAGE on your PC and on OS/390.
You can check your NT settings from a DB2 command line prompt by typing DB2SET, and review any values that you have set.
On OS/390 your codepage is set in the DSNHDECP member that is usually kept in the same member as your DSNZPARM. [...]
13457 52 17_Re: COBOL,AIX,DB224_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM30_Wed, 5 Jan 2000 22:00:15 +1100433_iso-8859-1 Dale,
I am working in an environment that uses MicroFocus Cobol on NT with DB2 for OS/390. We use DB2 Connect Enterprise Edition for NT as our gateway.
The Cobol application provides a full function GUI investment application for about 400 end users.
As the application is enhanced to be WEB, quite a lot of the existing COBOL routines have been ported to run as DB2 stored procedures on OS/390. [...]
13510 96 28_Re: Question about faroffpos0_18_mebert@AMADEUS.NET30_Wed, 5 Jan 2000 12:24:25 +0100660_us-ascii For REORGing, these statistics make sense ONLY in relation to the clustering index (the utilities guide refers to this only obliquely as "...statistics may appear even worse after reorging for other indexes"). NEAR/FAROFFPOSF and CLUSTERRATIO essentially are measures for out-of-sort-orderness (it also says somewhere that the formula for calculating CLUSTERRATIO has not been published), and the sort order achieved by REORG is determined by the clustering index only. So for an automated job you should make sure that 1) you have an IXC for each TS, and 2) that you disregard statistics for non-clustering IXs when determining whether to reorg [...]
13607 51 21_Re: Disaster Recovery12_Steve Thomas29_sherpa@HORNST.FREESERVE.CO.UK30_Wed, 5 Jan 2000 11:30:03 -0000568_iso-8859-1 Leslie,
Yes, I've tried this and it works well. I didn't run the recovery both ways, so I can't comment on relative speed. I was told (probably by the same expert you are referring to!) that doing this allows DB2 to make direct access to the log range it needs to recover, rather than reading the archive log sequentially. Unless you have a huge number of objects to recover, such as in your SAP implementation, it probably won't make a huge difference in the great scheme of things, but any little helps I suppose. The most vital thing, as you [...]
13659 33 13_Catalog stats14_David Williams24_David-O.Williams@WDR.COM30_Wed, 5 Jan 2000 11:47:42 +0000518_US-ASCII Is anyone aware of a tool that that will assist in populating a DB2(OS390) catalog with stats from another sub system....
...and a Happy New Year to you all....
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...]
13693 37 32_Saving authority settings (BMC?)0_23_J.P.Slot@RF.RABOBANK.NL30_Wed, 5 Jan 2000 13:00:50 +0100586_us-ascii Greetings fellow listers,
In my shop we have a database that is accessed by multiple applications. The Data is taken care of by image copies and backup of loadfiles. The DDL is saved by a datamodelling tool (Sybase Data Architect). BMC Change manager is used to implement DDL changes into the different environments (development, test and production). After a change we a baseline of the structure, to make sure there's an easy way to fall back. Within BMC Change Manager it is not possible to only save the authority settings. If I want to save those I have to do [...]
13731 58 17_Re: Catalog stats0_23_J.P.Slot@RF.RABOBANK.NL30_Wed, 5 Jan 2000 13:06:07 +0100357_us-ascii David, I heard this story a year ago..Data Propagator uses the statistics of db2 in order to do an explain for an oracle program and uses the explain information to "hint" the oracle database in order to get the fastest path..So I guess Data Propagator is able to get statistics from oracle..? Any1 out there might know the truth about this.. [...]
13790 59 17_Re: Catalog stats13_Adrian Savory24_adrian.savory@ZURICH.COM30_Wed, 5 Jan 2000 12:15:48 +0000549_us-ascii David,
CA-Migrator does this, I believe BMC Change Manager can also do this.
Adrian Savory ACSIS Ltd
David Williams on 05/01/2000 11:47:42
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Adrian Savory/ZI/England/Zurich)
Subject: Catalog stats
Is anyone aware of a tool that that will assist in populating a DB2(OS390) catalog with stats from another sub system.... [...]
13850 88 24_Re: Using One Global CSI0_23_Mike_Levine@TEKHELP.NET30_Wed, 5 Jan 2000 08:18:12 -0500558_us-ascii Hi,
IBM ships IMS together with DB2 in the same 'DBDS' SREL (CBIPO) so I don't see how this could be a problem. There were four SRELs (three now I believe) each with their own global zone - DBDS (IMS and DB2), CICS, MVS and network (VTAM, etc.). It really depends on your SMP/E methodology. If you follow the IBM CBIPO path then you should probably have separate global zones for each of the SRELs. If you just do product installs/upgrades then you can get away with a single global zone for all of the IBM products. However, You should [...]
13939 58 33_Re: How many DBAs does it take...13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 5 Jan 2000 08:32:16 -0500582_us-ascii Do they let you take vacations?! :-)
> -----Original Message----- > From: Bill [SMTP:disch000@MAIL.GENMILLS.COM] > Sent: Tuesday, January 04, 2000 7:08 PM > To: DB2-L@RYCI.COM; LFlatley@NEFN.COM > Cc: Bill > Subject: Re: How many DBAs does it take... > > Here's some info: > > DB2 V5.1 > 7 DB2 subsystems all non-data sharing > SAP R/2 - Prod, QA, Test > non-SAP - Prod, QA, Test (includes DW) > Experimental - DBA new release, maint, etc. > > Total structures: > 327 databases > 6100 tables > 5300 indexes > most are 1 table/tablespace > most large tables use [...]
13998 87 21_Re: Disaster Recovery12_Mike O'Brien30_michael_obrien_48127@YAHOO.COM30_Wed, 5 Jan 2000 05:57:50 -0800544_us-ascii Steve, what did you use to copy the archives to the log datasets and how did you determine which datasets to copy to.
--- Steve Thomas wrote: > Leslie, > > Yes, I've tried this and it works well. I didn't run > the recovery both ways, > so I can't > comment on relative speed. I was told (probably by > the same expert you are > referring to!) that doing this allows DB2 to make > direct access to the log > range > it needs to recover, rather than reading the archive > log sequentially. > [...]
14086 107 21_Re: Disaster Recovery22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Wed, 5 Jan 2000 14:32:10 +0000447_ISO-8859-1 REPRO? I would assume ??? Steve ....? Leslie ps how are things at BMC these days?
______________________________ Reply Separator _________________________________ Subject: Re: Disaster Recovery Author: "Mike O'Brien" at Internet Date: 1/5/00 5:57 AM
Steve, what did you use to copy the archives to the log datasets and how did you determine which datasets to copy to. [...]
14194 38 32_DB2 Connect Enterprise addtition18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Wed, 5 Jan 2000 09:48:19 -0500545_iso-8859-1 Could use some info if anyone knows:
We are currently running DB2 Connect Enterprise addition on an NT box. (I'm a DB2/DBA mainframe guy so please bear with me on this question). Is there a way to monitor the number of connections from that NT machine at any given time?? What I would be looking for is there a way to tell how many threads are currently being run off that box? Is there a command that can be issued from DB2 Connect that lists the current active threads coming thru it?? I know that when I'm in my little [...]
14233 59 17_Re: Catalog stats17_Lobenstein, Jerry30_Jerry_Lobenstein@COMPUWARE.COM30_Wed, 5 Jan 2000 09:58:11 -0500377_iso-8859-1 Hello David, you can get any vendor Compuware, BMC or CA/Platinum to moves stats for you, each product set will differ somewhat but in the long run they will all do virtually same function. DBA-Xpert for DB2 is Compuware Corporations solution to this function.
WWW.Compuware.Com File-Aid Group
Jerry Lobenstein Compuware Corporation (614)847-8212 [...]
14293 55 34_Re: DB2 Connect Enterprise edition13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 5 Jan 2000 09:55:48 -0500617_us-ascii The NT performance monitor would capture that info for you. There is a way registering DB2 Connect with the performance monitor, I'm sure it's documented in one of the DB2 Connect manuals.
> -----Original Message----- > From: Whittaker, Stephen [SMTP:stephen.whittaker@CPLC.COM] > Sent: Wednesday, January 05, 2000 9:48 AM > To: DB2-L@RYCI.COM > Subject: DB2 Connect Enterprise addtition > > Could use some info if anyone knows: > > We are currently running DB2 Connect Enterprise addition on an NT box. > (I'm a DB2/DBA > mainframe guy so please bear with me on this question). > Is there a way [...]
14349 52 47_Re: Automatic Deletion of Log Files in UDB v6.10_22_BILL_GALLAGHER@PHL.COM30_Wed, 5 Jan 2000 09:58:17 -0500516_us-ascii Tom,
Thanks for the info about this command. We were not aware of it, and it looks like it will be very helpful.
But it does not really solve my original question: once log files have been backed to ADSM, we would like to automatically delete them from the disk where they currently reside in order to free up space for new log files as they are created. Otherwise, we will have to periodically do this as a manual process or run the risk of running out of disk space and have UDB crash. [...]
14402 23 34_DSNZPARM Option SEQCACH for RAID ?12_Glenn Bowman25_glenn.bowman@WAKEFERN.COM30_Wed, 5 Jan 2000 09:59:52 -0500565_us-ascii The EMC 5500 ignores the 3990 Advanced Functions Commands so in effect, it is ignoring DB2's request to pre-load the 3990's Cache. I was told that the EMC 5500 has internal logic to sense sequential reading of data and will automatically read ahead and load the cache. The HDS 7700E does respect the 3990 Advanced Functions Commands and also has the internal sequential read ahead logic. If you are on the HDS 7700E and are looking at pure DASD Response times, set SEQCACHE=NO and let the HDS 7700E do the work. We converted from an EMC 5500 to a HDS [...]
14426 77 36_Re: DB2 Connect Enterprise addtition11_Kurt Rompot21_RompotK@SCHNEIDER.COM30_Wed, 5 Jan 2000 09:04:13 -0600478_us-ascii I use "list dcs applications" from the db2 clp quite a bit. Will only show those connected from other clients, not those that originate from the NT box.
-------------------- Kurt Rompot DB2 Database Analyst Schneider National, Inc. rompotk@schneider.com
"Whittaker, Stephen" To: DB2-L@RYCI.COM Subject: DB2 Connect Enterprise addtition Sent by: DB2 Data Base Discussion List [...]
14504 134 21_Re: Disaster Recovery12_Mike O'Brien30_michael_obrien_48127@YAHOO.COM30_Wed, 5 Jan 2000 07:17:09 -0800637_us-ascii Never worked at BMC, so I don't know, must be another Mike O'Brien. I use to work at Ford and used BMC products though. --- Leslie Pendlebury-Bowe wrote: > REPRO? I would assume ??? Steve ....? > Leslie > ps how are things at BMC these days? > > > ______________________________ Reply Separator > _________________________________ > Subject: Re: Disaster Recovery > Author: "Mike O'Brien" > at Internet > Date: 1/5/00 5:57 AM > > > Steve, what did you use to copy the archives to the > log datasets and how did you determine which > datasets > [...]
14639 129 21_Re: Disaster Recovery12_Steve Thomas29_sherpa@HORNST.FREESERVE.CO.UK30_Wed, 5 Jan 2000 15:18:36 -0000341_iso-8859-1 Mike,
We were using a third party tool to generate the DR jobs so it did it for us, but I believe it used Repro to copy the archives back to the active logs. The jobs defined a new set of active log datasets and then just repro'd the data in with the appropriate RBA/LRSNs, and modified the BSDS with the information. [...]
14769 185 21_Re: Disaster Recovery12_Mike O'Brien30_michael_obrien_48127@YAHOO.COM30_Wed, 5 Jan 2000 07:26:22 -0800533_us-ascii Steve, thanks for the info. That makes it pretty clear. Glad you mentioned being careful about which log dataset to put them on.
--- Steve Thomas wrote: > Mike, > > We were using a third party tool to generate the DR > jobs so it did it for > us, but I believe it used Repro to copy the archives > back to the active > logs. The jobs defined a new set of active log > datasets and then just > repro'd the data in with the appropriate RBA/LRSNs, > and modified the BSDS > with the [...]
14955 45 16_Connect for V6.113_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US30_Wed, 5 Jan 2000 10:36:55 -0500445_US-ASCII Hi all,
I am a DB2 UDB for OS/390 DBA and have a problem regarding DB2 UDB for NT V6.1.
We are having trouble connecting to DB2 UDB for OS/390 V5.1 using DB2 Connect V6.1 for NT. We would like to connect using ODBC and JDBC. I try to test the connection after adding a new database, I keep getting an error that reads "Connection test failed SQLerror 10007N message 1056567296 could not be retrieved. Reason code 4." [...]
15001 23 0_0_29_STANLEY_GOODWIN@MECH.DISA.MIL30_Wed, 5 Jan 2000 10:39:10 -0500315_us-ascii Question for all you DB2 connect experts. I installed DB2 connect on Windows NT, the panel that request a username and password was completed, but when I reboot I am getting an error when the task 'DB2DAS00' is started, how do I change that userid andpassword.
Stan Goodwin MBG DAC DB2 Support [...]
15025 84 35_Re: DB2 Connect Enterprise adtition0_15_leon@CA.IBM.COM30_Wed, 5 Jan 2000 10:47:44 -0500570_us-ascii There are several ways of figuring out this information. Which are available to you will depend on the version that you have. DB2 Connect V6.1 has the most complete set. In all versions you can issue LIST DCS APPLICATIONS command using command line processor to display a line for each database connection coming through a DB2 Connect EE server. It is important to note that connections originating from DB2 Connect EE box itself will not be reflected in this display unless you are using V6.1 and do something special i.e. set DBCONNECT_IN_APP_PROCESS=0. [...]
15110 18 20_Re: Connect for V6.113_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Wed, 5 Jan 2000 21:18:29 +0530248_us-ascii We cannot connect to DB2 V5 on os390 from DB2 connect v6.1 . In our shop we are routing the same thru another server . so 6.1 on NT talks to V5.2 on NT , 5.2 on NT talks to OS390 DB2 V5.1 . So thats how we connect for the time being. [...]
15129 15 0_13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Wed, 5 Jan 2000 21:19:32 +0530418_us-ascii Starting the DRDAS in NT. go to the service manager and select the options for the service. There u can enter the userid and password for the task
regards Vishy
================================================ 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.
15145 17 0_0_29_STANLEY_GOODWIN@MECH.DISA.MIL30_Wed, 5 Jan 2000 10:53:06 -0500402_us-ascii What is the DRDAS and how do you start it... Stan Goodwin MBG DAC DB2 Support
Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15163 11 0_13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Wed, 5 Jan 2000 21:24:57 +0530273_us-ascii sorry It was DB2DAS00.
================================================ 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.
15175 47 14_Re: no subject13_John Arbogast16_jfarbo@YAHOO.COM30_Wed, 5 Jan 2000 07:47:07 -0800645_us-ascii Fellow listers. Could we please have something in the subject line?? That is how I filter through the list email.
Thanks!
--- STANLEY_GOODWIN@MECH.DISA.MIL wrote: > Question for all you DB2 connect experts. I > installed DB2 connect on > Windows NT, the panel that request > a username and password was completed, but when I > reboot I am getting an > error > when the task 'DB2DAS00' is started, how do I change > that userid > andpassword. > > Stan Goodwin > MBG DAC DB2 Support > > Stanley_goodwin@mech.disa.mil > DSN: 430-4335 > Outside:- 717-605-4335 > > ================================================ [...]
15223 66 20_Re: Connect for V6.10_14_dcreed@CSC.COM30_Wed, 5 Jan 2000 10:01:37 -0600734_us-ascii Look at your registery. Regedit. \HKEY_LOCAL_MACHINE\SOFTWARE\IBM\
BMEVANS@auditor.state.oh.us on 01/05/2000 09:36:55 AM
Please respond to DB2-L@ryci.com
To: DB2-L@ryci.com cc: (bcc: Daniel S Creed/HI/CSC) Subject: Connect for V6.1
Hi all,
I am a DB2 UDB for OS/390 DBA and have a problem regarding DB2 UDB for NT V6.1.
We are having trouble connecting to DB2 UDB for OS/390 V5.1 using DB2 Connect V6.1 for NT. We would like to connect using ODBC and JDBC. I try to test the connection after adding a new database, I keep getting an error that reads "Connection test failed SQLerror 10007N message 1056567296 could not be [...]
15290 97 31_Re: TCP/IP connection to OS/39014_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Wed, 5 Jan 2000 11:09:51 -0500598_iso-8859-1 Thanks, Robert. I am using UDB V6.1 on NT as the requestor and UDB V6 on OS/390 as server. Also, I get the same error when I use UDB 5.2 (Fixpack 9) on AIX as the requestor.
Thanks, Manas.
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > MILLS,Robert > Sent: Tuesday, January 04, 2000 11:14 PM > To: DB2-L@RYCI.COM > Subject: Re: TCP/IP connection to OS/390 > > > Hi Manas, > > I have been getting exactly the same error since I tried connecting to DB2 > OS/390 V5 from UDB V6.1 (fixpack [...]
15388 68 41_Re: Stored Procedure - information please14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Wed, 5 Jan 2000 10:06:39 -0600690_ISO-8859-1 Re: stored procedures
There are quite a few details that should be analyzed and settled before implementing any type of logic in the database (that is, stored procedures, triggers, and user-defined functions). For a recent article on some of these issues check out the following on the IDUG web site:
http://www.idug.org/member/journal/mar99/faceoff.html#mullins
One other quick issue, once you migrate to DB2 V6, you no longer update SYSPROCEDURES, but issue CREATE PROCEDURE statements that populate SYSROUTINES - - a much more elegant implementation. Some shops may not have a problem with certain users issuing an INSERT to a catalog table, but may [...]
15457 17 38_Re: Y2K - What was all the fuss about?15_Lyle Kelly-LH-117_kelly.lh.1@PG.COM30_Wed, 5 Jan 2000 11:23:19 -0500474_us-ascii Harvey said "I hope the pundits out there understand that if 2000-01-01 was a yawn, it's because all of us in data processing did a helluva job (even if some of us did cause the problem in the first place)."
Exactly.
================================================ 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.
15475 215 21_Re: Disaster Recovery22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Wed, 5 Jan 2000 16:43:23 +0000526_ISO-8859-1 Mike sorry - ps was for somebody else. :-)
I guessed that REPRO must be used ...
If you get the ARCHIVES into the ACTIVE and tested before me (assuming you do this) can you let me know what performance improvements you see ?
speak to you soon
Leslie
______________________________ Reply Separator _________________________________ Subject: Re: Disaster Recovery Author: "Mike O'Brien" at Internet Date: 1/5/00 7:26 AM [...]
15691 126 35_Re: DB2 Connect Enterprise adtition11_Kurt Rompot21_RompotK@SCHNEIDER.COM30_Wed, 5 Jan 2000 10:44:50 -0600550_us-ascii Minor typo Leon, that should be DB2CONNECT_IN_APP_PROCESS.
"db2set DB2CONNECT_IN_APP_PROCESS=0"
Are there any performance implications by making this change?
-------------------- Kurt Rompot DB2 Database Analyst Schneider National, Inc. rompotk@schneider.com
leon@CA.IBM.C OM To: DB2-L@RYCI.COM Sent by: DB2 cc: Data Base Subject: Re: DB2 Connect Enterprise adtition Discussion List
01/05/2000 09:47 AM Please respond to DB2 Data Base Discussion List [...]
15818 111 35_Re: DB2 Connect Enterprise adtition18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Wed, 5 Jan 2000 11:31:26 -0500494_iso-8859-1 Leon: Thanks for the info...I set the db2connect_in_app_process=0 and that did the trick..
Appreciate the response.
--Steve....
Steve Whittaker DB2/DBA Carolina Power & Light Mail stop: CPB 17A4 - Raleigh Email: stephen.whittaker@cplc.com Phone: (919) 546-7267
-----Original Message----- From: leon@CA.IBM.COM [mailto:leon@CA.IBM.COM] Sent: Wednesday, January 05, 2000 10:48 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect Enterprise adtition [...]
15930 99 47_Re: Automatic Deletion of Log Files in UDB v6.114_Tom Decabooter27_Tom.Decabooter@HONDA-EU.COM30_Wed, 5 Jan 2000 17:43:37 +0100436_us-ascii I thought the log files were reused, a kind of 'wrap around' : if the last one is full, the first one is 'activated' again. I am still setting up the archiving on our NT system, so i am not 100% sure.
Tom Decabooter Honda Europe N.V.
BILL_GALLAGHER@PHL.COM on 05/01/2000 15:58:17
Please respond to DB2 Data Base Discussion List [...]
16030 62 3_SQA11_Brian Lynch27_blynch@GRPWISE-EAST.TRW.COM30_Wed, 5 Jan 2000 11:41:50 -0500479_US-ASCII This problem and other storage related problems started showing up after our conversion from MVS to OS/390.
Has anyone else seen this? What did you do?
We are at v5.1 PUT 9805 and IBM has already told us to get more current. We have already planned a migration to a more recent PUT level, but that won't be implemented for several months. If you have any suggestions that can be implemented right now on our current configuration that would be great. [...]
16093 113 33_Cat/Dir REORG JCLs Part 0 - Intro0_18_mebert@AMADEUS.NET30_Wed, 5 Jan 2000 17:59:35 +0100299_us-ascii Hello all -
I give up. I have until now sent my Cat/Dir REORG JCL to 70 people, but another 15 have accumulated in the meantime (today). So I'm finally going to cut&paste the original documents into several mails (to prevent size problems) and post them to the list in general. [...]
16207 166 35_Cat/Dir REORG JCLs Part 4 - CATLIST0_18_mebert@AMADEUS.NET30_Wed, 5 Jan 2000 17:59:59 +0100675_us-ascii Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany Tel. ++49 -8122-433962 Fax ++49-8122-433260
/*---------------------REXX-----------------------------------------*/ /*------------------------------------------------------------------*/ parse upper arg ssid
ofile="OBO025.CATLIST.TXT"
/* because DSNDB01 is not in the Catalog, add it explicitly: */ b.1="DSNDB01 DBD01 " b.2="DSNDB01 SCT02 DSNSCT02" b.3="DSNDB01 SPT01 DSNSPT01" b.4="DSNDB01 SPT01 DSNSPT02" b.5="DSNDB01 SYSLGRNX DSNLLX01" b.6="DSNDB01 SYSLGRNX DSNLLX02" b.7="DSNDB01 SYSUTILX DSNLUX01" b.8="DSNDB01 SYSUTILX DSNLUX02" k=8 [...]
16374 162 36_Cat/Dir REORG JCLs Part 3 - RCVRCATP0_18_mebert@AMADEUS.NET30_Wed, 5 Jan 2000 17:59:56 +01001368_us-ascii Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany Tel. ++49 -8122-433962 Fax ++49-8122-433260
//OBO025RC JOB (USERJOB,ME),'DB2 UTILITY',CLASS=Y,MSGCLASS=X, // REGION=6M,NOTIFY=&SYSUID,TYPRUN=HOLD /*JOBPARM SYSAFF=AMAB //* //*===================================================================== //* //* RECOVER Job for DB2P Catalog/Directory //* See UTILITIES Guide, p. 2-177 f. //* //*===================================================================== //* //*--------------------------------------------------------------------- //TERMUTIL EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DB2P) -TER UTIL(OBO025.RECOVER) //*--------------------------------------------------------------------- //SYSUTILX EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER' //SYSPRINT DD SYSOUT=* //SYSIN DD * RECOVER TABLESPACE DSNDB01.SYSUTILX //*--------------------------------------------------------------------- //DBD01 EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER' //SYSPRINT DD SYSOUT=* //SYSIN DD * RECOVER TABLESPACE DSNDB01.DBD01 //*--------------------------------------------------------------------- //IDXUTILX EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER' //SYSPRINT DD SYSOUT=* //UTPRINT DD SYSOUT=* //SYSIN DD [...]
16537 74 36_Cat/Dir REORG JCLs Part 2 - DB2CATCK0_18_mebert@AMADEUS.NET30_Wed, 5 Jan 2000 17:59:51 +01001052_us-ascii Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany Tel. ++49 -8122-433962 Fax ++49-8122-433260
//OBO025CK JOB (USERJOB,ME),'M. EBERT X3962',CLASS=Y,MSGCLASS=X, // MSGLEVEL=(1,1),REGION=6M,NOTIFY=&SYSUID,TYPRUN=HOLD /*JOBPARM SYSAFF=AMAB //JOBLIB DD DISP=SHR,DSN=SYS1.DB2.PRD1.SDSNLOAD //* //*===================================================================== //* Check Catalog & Directory //* //* For some obscure reason, adding these steps after the DB2PCAT job //* causes a RESOURCE UNAVAILABLE condition on the VSAM files in the //* RLODTABL steps, so they have to be in their own job. //* //*===================================================================== //* //*##################################################################### //CHECKR PROC TABLE=DB.TABLE Instream Procedure //CHKR EXEC PGM=DSN1CHKR,PARM='FORMAT',COND=(4,LT) //SYSUT1 DD DSN=DB2P.DSNDBC.DSN&TABLE..I0001.A001,DISP=SHR //SYSPRINT DD SYSOUT=* // PEND //CHECK PROC TABLE=DB.TABLE Instream Procedure //CHK [...]
16612 1296 35_Cat/Dir REORG JCLs Part 1 - DB2PCAT0_18_mebert@AMADEUS.NET30_Wed, 5 Jan 2000 17:59:44 +0100778_us-ascii Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany Tel. ++49 -8122-433962 Fax ++49-8122-433260
//OBO025D2 JOB (USERJOB,ME),'M. EBERT X3962',CLASS=Y,MSGCLASS=X, // MSGLEVEL=(1,1),REGION=6M,NOTIFY=&SYSUID,TYPRUN=HOLD /*JOBPARM SYSAFF=AMAB //JOBLIB DD DISP=SHR,DSN=SYS1.DB2.PRD1.SDSNLOAD //* //********************************************************************** //* Job to REORG the DB2 Catalog & Directory * //* * //* All TSs except SPT01 are on MSY003 (P)/MS4440 (T)/DB2M01 (M) * //* All IXs except DSNSPT01/02 are on MSY005 / MS4441 / DB2M02 * //* For SPT01 and its indexes DSNSPT01/02, the order is reversed. * //* DSNKSX01 (on SYSPKAGE) is also on MSY003 / MS4440 / DB2M01 * //* in order to have both [...]
17909 87 39_Re: Stored Procedure Builder on UDB 6.10_25_Pierre.Evans@AUTOZONE.COM30_Wed, 5 Jan 2000 10:58:24 -0600543_us-ascii Leo, I tried setting those DBM parms but the only difference is that I now get a return code "1" with SQL4301. I suspect the problem is caused by the JDK - I dont recall installing that on the system, hence there's no jdk subdirectory in \sqllib\java. Do you know if the JDK is installed by default when UDB 6.1 is installed, or is it a separate install ? I used lslpp to check the software installed, and it listed Java Support, but not the JDK. Just skimming through the install cd's doesnt reveal any for JDK. Thanks for your [...]
17997 71 27_EXISTS and Index processing0_27_BoSDBA@BANKOFSCOTLAND.CO.UK30_Wed, 5 Jan 2000 17:02:27 +0000569_us-ascii Hello,
I have a question about stage 2 predicates and index access paths....
My undestanding is that use of EXIST and NOT EXISTS with correlated subquery continues to be a stage 2 predicate in DB2 V 5 and that as a consequence cannot be supported by any kind of index based access path (matching or non matching). However I have observed some SQL in our production subsystem with a BIND date of 1997-10-10 14:43:39.07 (at which time we were version 4) which appears to me to be stage 2 but with an index in the access path. Is this subquery [...]
18069 21 38_Re: DSNZPARM Option SEQCACH for RAID ?12_Roger Miller19_millerrl@US.IBM.COM30_Wed, 5 Jan 2000 10:59:46 -0800592_- I think you may want to check on your specification. The name of the parameter is SEQCACH and the values are BYPASS and SEQ. The other key information is the cache size. The IO rate is helpful.
It's easy to understand how respecting BYPASS would hurt performance. Knowing sequential handling would seem to be better than only detecting it later. Interaction among the algorithms in the cache and DB2 can be very tricky, and I suspect that some information is proprietary on both sides. We get to work closely together with the IBM designers, but we have very little information [...]
18091 22 7_Re: SQA12_Roger Miller19_millerrl@US.IBM.COM30_Wed, 5 Jan 2000 09:17:24 -0800299_us-ascii I don't have time for the real work on this one, but it sounds as though some of the storage areas are smaller or effectively smaller now. I'd recheck the CSA, SQA, ... specifications as well as making sure that the SWA is above the line and even the private storage limits in OS/390. [...]
18114 80 21_Re: Disaster Recovery13_Dayna Brennan25_Dayna.Brennan@STATE.MN.US30_Wed, 5 Jan 2000 11:28:59 -0600525_iso-8859-1 We use BMC also and have been very pleased with it. We are running PeopleSoft HRMS (really old version) and are working on a re-install of PS HRMS 7.5, we have too many customizations to allow an upgrade. Because of the number of objects, and the fact that all our logs are on tape, we only recover to a fixed point in time, no recover to current because of the gazillions of scan passes through the logs. The new version of PS has about 4 times as many objects as the one we're running now, so this is a big [...]
18195 47 28_question for DB2-list-server13_Martin Kenney25_martin.kenney@RAILINC.COM30_Wed, 5 Jan 2000 12:39:20 -0500525_us-ascii A co-worker of mine requested I send the below problem to the list server. Please respond if you can help him. Thanks!! ---------------------- Forwarded by Marty R Kenney/RICC/AAR on 01/05/2000 12:33 PM ---------------------------
Sridhar Gupta 01/05/2000 11:09 AM
To: Marty R Kenney/RICC/AAR@AAR WASHINGTON cc:
Subject: question for DB2-list-server
Marty, Could you please send this query to the DB2 List-server group and please let me know if you require any more details. [...]
18243 24 29_DB2 V5 for OS390 data sharing11_John Rosser24_jhrosser@DUKE-ENERGY.COM30_Wed, 5 Jan 2000 11:32:43 -0800438_- Since DBM1 is subject to the 2G OS390 address space limit, I wonder if adding another member to the ds group would be a good idea. Adding another member, at least from my viewpoint, would allow us to grow virtual bufferpools and give apps better data hit ratio. This would also lessen the risk of 878, A78s storage. Also allow us to tune one member towards dynamic apps (PSoft) and one member towards our static apps (home grown). [...]
18268 16 12_ESS2501 DASD11_John Rosser24_jhrosser@DUKE-ENERGY.COM30_Wed, 5 Jan 2000 11:39:07 -0800456_- Anyone have experience with new ESS2501 DASD. DASD folks think I can eliminate some DSNDB07 work database files, since this dasd reduces IODQ time close to nil.
Regards, John Rosser Duke Energy Corporation
================================================ 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.
18285 10 16_Re: ESS2501 DASD11_John Rosser24_jhrosser@DUKE-ENERGY.COM30_Wed, 5 Jan 2000 11:43:09 -0800290_- That is IOSQ time. Model # is ESS 2105-E20. JR
================================================ 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.
18296 28 26_Delete rule in foreign key15_Philip, Sibimon19_PhilipS@SEALAND.COM30_Wed, 5 Jan 2000 12:49:13 -0500413_iso-8859-1 Could some one please explain the following to me
1. What is NO ACTION means in the delete rule. I read the administration guide, could not understand much.
2. Why we cannot define a RESTRICT rule in a self referencing table foreign key (I mean the foreign key is referencing to same table). We can only use CASCADE or NO ACTION. I do not want to delete if there is a dependent row. [...]
18325 30 18_DB2 to Oracle(sic)10_John Clark20_pak02449@PIXIE.CO.ZA30_Wed, 5 Jan 2000 12:57:35 +0530423_iso-8859-1 Given the current trends, this may seem like a strange post; however I have just been asked by one of our users how long it would take to move our DB2 database(s) to an Oracle platform.
I am assuming that the Oracle/Solaris platform and catalogue would be set up. I am being lazy in that I wuld like to know if anyone on the list hasdone this at any time and what the comparable load times could be. [...]
18356 131 31_Re: TCP/IP connection to OS/3900_15_leon@CA.IBM.COM30_Wed, 5 Jan 2000 12:55:28 -0500341_us-ascii This error has nothing to do with levels of DB2 Connect software you are using. You have a problem in cataloging your DB2 for OS/390 database on the DB2 Connect box. Basically, DB2 Connect thinks it is talking to DB2 UDB for UNIX,NT and OS/2. The reason for this is a missing entry in the DCS directory on the DB2 Connect box. [...]
18488 55 38_Re: DSNZPARM Option SEQCACH for RAID ?0_29_Joseph_Esposito@PUTNAMINV.COM30_Wed, 5 Jan 2000 13:27:36 -0500677_us-ascii Roger
If we have IBM Shark Dasd what should SEQCACH be BYPASS or SEQ ?
From: Roger Miller on 01/05/2000 01:59 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Joseph Esposito/FRA/PutnamInv)
Subject: Re: DSNZPARM Option SEQCACH for RAID ?
I think you may want to check on your specification. The name of the parameter is SEQCACH and the values are BYPASS and SEQ. The other key information is the cache size. The IO rate is helpful. [...]
18544 161 31_Re: TCP/IP connection to OS/39013_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US30_Wed, 5 Jan 2000 13:33:51 -0500354_US-ASCII Hi Leon,
I am getting the same error when trying to use DB2 Connect V6.1 on NT to connect to DB2 for OS/390. I tried using the DB2CCA as you suggest. I found a panel to change node options. This is the only place I found to select an operating system. OS/390 was not an option. WinXX, NT OS2 AIX etc were there but no OS/390 or MVS. [...]
18706 31 38_Migrating from v5 to v4 and back again17_Luke G. Bauerlein24_lbauerlein@MANDTBANK.COM30_Wed, 5 Jan 2000 13:28:20 -0500595_US-ASCII Attn: sysprogs. I migrated successfully from version4 to version 5 in my MVS "sandbox" LPAR. I now need to provide support for both versions in a development LPAR and then in production and not have to create 2 separate subsystems. I would like the ability to flip-flop them at will. I used the same logic when migrating from V3 to V4 and it worked fine. When I tried to start version 4 in my sandbox I received an ABND=04e-00c90101 for DSNDBM1 and for DSNMSTR I received DSNI012I - page logically broken type 00000302 name dsndb06 .sysdbase.x'000027' modname dsnimsms erqual 0c10 [...]
18738 204 35_Re: DB2 Connect Enterprise adtition0_15_leon@CA.IBM.COM30_Wed, 5 Jan 2000 13:39:32 -0500677_us-ascii I accidentally deleted a post from somebody (Kurt I think) who was asking me about performance implications of setting DB2CONNECT_IN_APP_PROCESS=0 in DB2 Connect. The answer is "yes, there are possible performance implications". However, the extent of these implications is highly version, application, and configuration dependent.
I'll try to explain what setting this parameter does and some of the conclusions that may be drawn from it. All requests from remote clients (those applications running on boxes physically separated from the DB2 Connect EE server by a LAN) are handled by an "agent" in the DB2 Connect EE address space. However, application [...]
18943 297 21_Re: Disaster Recovery16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM30_Wed, 5 Jan 2000 13:59:55 -0500348_- We run PeopleSoft GL 5.1 and now are running AP/Purchasing/Inventory/HRMS/Payroll at Release 7.5. I have never had to do a full recovery of all objects to a given point in time, but am curious as to why you need to to that --- except for disaster recovery ---.
Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee [...]
19241 20 14_Visual Explain12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Wed, 5 Jan 2000 13:12:00 -0500426_- We are just getting started with DB2 Connect. We are going from an NT to an AIX UNIX system then on to DB2 on OS390. We can connect from the PC to DB2 on OS390 just fine from the Client Configuration Assistant and the Command Center. But when we attempt to connect to DB2 in Visual Explain (V6 from WEB), the Visual Explain application just dies on the PC. No Errors. No log. No indication whatsoever of what happened. [...]
19262 118 39_Re: Stored Procedure Builder on UDB 6.110_Leo Pedron19_lpedron@BOSCOVS.COM30_Wed, 5 Jan 2000 14:21:28 -0500451_iso-8859-1 The JDK is installed as a part of the SDK. I believe that the SDK now comes as a part of UDB 6.1, but I'm not sure that it installed by default. If you don't have a \SQLLIB\JAVA\JDK directory then you most likely need to install the SDK. The SDK can be downloaded from www.software.ibm.com/data/db2/java if your CD doesn't have it. I have only installed this product on NT servers(so far), it may be different on UNIX based platforms. [...]
19381 133 47_Re: Automatic Deletion of Log Files in UDB v6.10_14_dcreed@CSC.COM30_Wed, 5 Jan 2000 13:29:51 -0600527_us-ascii I archive utilizing ADSM on AIX at DB2/6000 2.1.2 (yeah I know out of support), but it does the archive and does not keep the log files on the AIX side. The number keeps increasing for the LOG files, but I utilize the db2adutl command to clean up old backups. I actually need to go read back up on the syntax of the log deletions, but I redid some "db2adutl delete full keep 9 DAYS db dname" for a test. I use the "db2adutl query db dbname" to verify what is actually usuable. Perhaps I need to prune the history [...]
19515 124 21_Re: Disaster Recovery20_Chatterjee, Anindita28_Anindita.Chatterjee@NIKE.COM30_Wed, 5 Jan 2000 11:31:25 -0800665_iso-8859-1 unsubscribe DB2-L
> -----Original Message----- > From: Milligan, Andrea [SMTP:Andrea_Milligan@BCBST.COM] > Sent: Wednesday, January 05, 2000 11:00 AM > To: DB2-L@RYCI.COM > Subject: Re: Disaster Recovery > > We run PeopleSoft GL 5.1 and now are running > AP/Purchasing/Inventory/HRMS/Payroll at Release 7.5. I have never had to > do a full recovery of all objects to a given point in time, but am curious > as to why you need to to that --- except for disaster recovery ---. > > Andrea Milligan > DataBase Administrator > BlueCross BlueShield of Tennessee > > -----Original Message----- > From: Dayna Brennan [SMTP:Dayna.Brennan@STATE.MN.US] [...]
19640 45 30_Using time stamp - Performance19_kishore erukulapati21_kishore_e@HOTMAIL.COM28_Wed, 5 Jan 2000 11:49:11 PST395_- We want to fetch rows from a table which are older than "N" (retention-days ) days and write into a flat file for archival purpose using COBOL program.
We want to find a best solution to acheive this .
Solution :
Cursor was declared with the following where clause :
Days(:ws-current-date) - Days (creation_date_time) >= :retention-days . ( 2 host variables ) [...]
19686 28 38_Re: DSNZPARM Option SEQCACH for RAID ?12_Glenn Bowman25_glenn.bowman@WAKEFERN.COM30_Wed, 5 Jan 2000 14:47:50 -0500529_us-ascii Sorry, you are correct. I set SEQCACH=BYPASS meaning to disable and not perform the 3990 Cache Loading function. The Cache sizes of my 2 machines were EMC 2GB and HDS 3GB. The EMC had 400 GB DASD defined and the HDS has 700GB. My DB2 DASD were all 3390-9 format on both boxes and the I/O Rates are pretty normal ranging from 10 to 30 I/Os per second but there are peaks to 70 I/Os per second. We only have the single HDS 7700E and average around 1100 I/Os per second on first shift with peak 15 minute intervals at [...]
19715 53 42_Re: Migrating from v5 to v4 and back again22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Wed, 5 Jan 2000 15:12:53 -0500669_- Luke -
Falling back from V5 to V4 is well documented in the DB2 for OS/390 V5 Installation Guide (GC26-8970). At a minimum, V4 needs toleration PTFs to handle the fallback.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: Luke G. Bauerlein[SMTP:lbauerlein@MANDTBANK.COM] > Sent: Wednesday, January 05, 2000 1:28 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Migrating from v5 to v4 and back again > > Attn: sysprogs. I migrated successfully from version4 to version 5 in my > MVS "sandbox" LPAR. I now need to provide support for both versions in a > development LPAR and then in [...]
19769 24 24_Re: Using One Global CSI11_Judi Powers20_jpowers3@METLIFE.COM30_Wed, 5 Jan 2000 15:12:33 -0500602_us-ascii We had a global csi at a previous shop and I certainly miss it, I felt the central point excellent....and only one group did the receives and tape headaches (how nice not to have to deal with getting your tape over to the tape room let alone mounted!). Maintenance is more centralized and coordinated, for example so when PUT9812 was in house, you knew across the board those PTFs were available(received). Of course the separate groups were responsible for tailoring and reading HOLD data(each product, DB2, CICS etc had its own Target and Distribution zones with FMIDs assigned to them [...]
19794 73 38_Re: DSNZPARM Option SEQCACH for RAID ?14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Wed, 5 Jan 2000 15:14:40 -0500374_ISO-8859-1 EMC has always ignored the SEQCACHE. One of the absolute critical factors with EMC is the positioning of the datasets. It does not use real RAID striping. So when you think you're separating datasets on your logical volumes they may map to the same internal physical disk.... and you die because of internal DASD contention. Dataset placement still matters. [...]
19868 50 37_Selective Partition Locking and NPI's12_Price, David22_David.Price@SCHWAB.COM30_Wed, 5 Jan 2000 12:16:00 -0800652_iso-8859-1 When Selective Partition Locking is implemented for a given partitioned tablespace, how does DB2 manage locks and latches for the Non-Partitioning Indexes?
Specifically, what will happen in the following situation:
1. Partitioned Tablespace with 10 partitions. 2. One Partitioning Index on the tablespace. 3. One Non-Paritioning Index on the same tablespace.
- The NPI has one attribute (ID) - The attribute (ID) is defined as INTEGER - All inserts, insert an ID which is one higher than the previous ID. 4. The application is constructed so that all access to any given partion occurs from one and only one member [...]
19919 67 30_Re: Delete rule in foreign key17_Linda F. Claussen18_lindafc@NETINS.NET30_Wed, 5 Jan 2000 14:18:55 -0600553_ISO-8859-1 For self referencing constraints the NO ACTION rule accomplishes the equivalent of the RESTRICT rule for standard referential constraints.
For relationship checking DB2 does not allow a relationship DELETE rule that is access path dependent or dependent on the order in which it processes the relationships and order in which it processes the rows. That is why DELETE RESTRICT is not allowed for self referencing constraints. The DELETE RESTRICT constraint is checked before it performs each cascaded update and delete operation. [...]
19987 42 18_Re: Visual Explain11_Danny Davis16_DTDAVIS@PCMH.COM30_Wed, 5 Jan 2000 15:23:09 -0500621_US-ASCII I have also run into the exact same problem and would be interested in any resolutions anyone could provide as well.
Danny Davis Systems Analyst Univerity Health Systems dtdavis@pcmh.com
>>> BOB JEANDRON 01/05/00 01:12PM >>> We are just getting started with DB2 Connect. We are going from an NT to an AIX UNIX system then on to DB2 on OS390. We can connect from the PC to DB2 on OS390 just fine from the Client Configuration Assistant and the Command Center. But when we attempt to connect to DB2 in Visual Explain (V6 from WEB), the Visual Explain application [...]
20030 105 31_Re: EXISTS and Index processing20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 5 Jan 2000 15:38:52 -0500616_- Index can be used for subquery because it is different query block but it is stage 2 predicate for the outer query.
Distinct is not necessary inside this subquery.
> -----Original Message----- > From: BoSDBA@BANKOFSCOTLAND.CO.UK [SMTP:BoSDBA@BANKOFSCOTLAND.CO.UK] > Sent: Wednesday, January 05, 2000 12:02 PM > To: DB2-L@RYCI.COM > Subject: EXISTS and Index processing > > Hello, > > I have a question about stage 2 predicates and index access paths.... > > My undestanding is that use of EXIST and NOT EXISTS with correlated > subquery > continues to be a stage 2 predicate in DB2 V 5 and that [...]
20136 47 33_Re: DB2 V5 for OS390 data sharing20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 5 Jan 2000 15:46:35 -0500378_- Data sharing sure does help to alleviate 2G storage limitation but alternatively you could reduce your VP and increase your HP or wait till V6 to use data space.
Directing jobs to a particular member is not a problem because you could use GROUP ID or SSID while attaching (CICS can not use GROUP id). You could have different member in different LPAR or m/c also. [...]
20184 138 47_Re: Automatic Deletion of Log Files in UDB v6.10_22_BILL_GALLAGHER@PHL.COM30_Wed, 5 Jan 2000 15:50:39 -0500620_us-ascii Tom,
The logs are reused in a "wrap-around" fashion, but only if you are doing circular logging (logretain parameter = 0). When using circular logging, forward recovery of the database is not possible.
We are using forward recovery logging (logretain parameter = 1) because we want to have the ability to retain our log files indefinitely. In this case, when all allocated logs are filled up, more log files are allocated. Previous experience has shown us that the number of allocated log files can grow excessively if not cleaned up periodically. That is why we are looking to automate this [...]
20323 163 31_Re: TCP/IP connection to OS/39014_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Wed, 5 Jan 2000 16:01:41 -0500390_iso-8859-1 Thanks, Leon. Got it to work from AIX requestor after re-cataloging NODE, DATABASE and DCS directory entries. However still cannot get it work from DB2 V6 PE from NT. Like Burgess Evans reported in one of the previous mails that MVS is not one of the option that appears on CCA. I tried cataloging the node on the command line using OSTYPE MVS but still get the same error. [...]
20487 32 35_DB2 for OS/390 from other platforms13_Tierney, Mark20_mtierney@FIRSTAM.COM30_Wed, 5 Jan 2000 15:20:35 -0600537_- Hello List,
Currently we have a Data Warehouse that is queried by Mainframe query tools. This is considered somewhat antiquated and a little cumbersome as it requires our clients to have special training. We are beginning to look at querying the data from other platforms (user pc's, other databases, etc.). I myself have only used distributed from DB2 Connect (users all on a lan, MS Excel, MS SQLServer, etc.) in a limited fashion and from other DB2 ssid's on MVS (or OS/390) so I am a little foggy on some requirements. [...]
20520 18 31_function of DSNIDM and DSNIRNXT28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM28_Wed, 5 Jan 2000 13:34:26 PST409_- DSNIDM is the load module for DB2/390's data manager component.
DSNIRNXT is the "next record" csect in this load module. It is the csect that moves forward to the next record to be accessed in a table space scan. Performance of this module is affected by the degree of clustering, segmentation, locking, selection expression etc., basically anything that affects locating the next table record. [...]
20539 189 31_Re: TCP/IP connection to OS/39014_O'Conner, John26_john.oconner@COURTS.WA.GOV30_Wed, 5 Jan 2000 15:03:32 -0800549_iso-8859-1 Manas, Burgess,
I don't know if this help or not, but it's what I have found. I downloaded DB2connect v6 and udb v6 from the IBM web site (just to play with). When I install udb, I get a non-expiring version that behaves as you describe (no os/390 option in CCA). If I then install DB2connect, I get the os/390 option in CCA (but then udb expires in 60 days). If I uninstall and re-install DB2connect only, I get the os/390 option (and again udb expires). If I then install udb, I get a non-expiring udb, but no os/390 option [...]
20729 135 31_Re: EXISTS and Index processing14_Michael Hannan24_mhannan@C031.AONE.NET.AU30_Thu, 6 Jan 2000 10:15:46 +1000385_us-ascii Just to expand slightly on what Venkat correctly replied:
The NOT EXISTS subquery is executed when rows of Table A have been filtered by the earlier stage 1 predicates and passed to stage 2 processing in the RDS.
Subquery may not be executed if 1 page memory cache determines result already known for same value of correlation column A . FINANCIAL_PROD_ID. [...]
20865 84 37_Selective Partition Locking and NPI's14_Michael Hannan24_mhannan@C031.AONE.NET.AU30_Thu, 6 Jan 2000 10:16:11 +1000570_us-ascii David,
For a non-Data Sharing system there is no NPI problem due to no locking on the NPI (only on data rows). Latches are brief and not a substantial problem.
However in Data Sharing your problem does exist.
Since all inserts to the NPI are at the end, the pages are in heavy use as you say. Each member wanting to update the page must get a page p-lock exclusive and negotiate with other process already holding the page p-lock to relinquish it and send latest copy of page to Coupling Facility. This makes for a lot of inter member [...]
20950 75 34_Re: Using time stamp - Performance14_Michael Hannan24_mhannan@C031.AONE.NET.AU30_Thu, 6 Jan 2000 10:32:46 +1000458_us-ascii kishore,
If you are on DB2 V5, then step 1 and step 2 of alternative solution can be combined into 1 SQL and indexable on cre_date_time:
Where cre_date_time <= TIMESTAMP(DATE(:ws_current_date) - (:retention_days) DAYS, TIME('00:00:00'))
On earlier versions of DB2, do it like this:
Where cre_date_time <= (Select TIMESTAMP(DATE(:ws_current_date) - (:retention_days) DAYS, TIME('00:00:00')) FROM DUMMY_ONE_ROW_TABLE) [...]
21026 25 38_Re: DSNZPARM Option SEQCACH for RAID ?12_Roger Miller19_millerrl@US.IBM.COM30_Wed, 5 Jan 2000 17:32:57 -0800443_us-ascii If you have IBM Enterprise Storage Server (also known as Shark) disk then SEQCACH should be SEQ.
On the DB2 for OS/390 home page, www.ibm.com/software/db2os390
Look at the items under News, and click on
White paper: DB2 for OS/390 Performance on IBM Enterprise Storage Server to see how the disk performs on a laboratory race track. Being able to get rid of almost all IOSQ time makes a very big difference. [...]
21052 46 39_DB2 DATA SHARING DLI BATCH GROUP ATTACH0_24_Jodi.Murawski@MIDATA.COM30_Wed, 5 Jan 2000 20:52:05 -0600518_us-ascii I am posting this to the list to see if there are any companies out there that have the same need as ours, and if so, I would like you to inform your IBM rep. Here is the scenario.
In DB2 data sharing, the Group Attach allows you to provide a Group Name instead of the DB2 subsystem name in a batch job. The job could connect to any member of the 'group', so you can run the job on any CPU that has a member of the group. The Capacity Planning people love this for workload balancing. Problem now [...]
21099 247 31_Re: TCP/IP connection to OS/39013_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Thu, 6 Jan 2000 09:52:12 +0530456_us-ascii hello Leon !! Even I was facing the same problem of connecting to Os390 db2 v5.1 from a db2 connect of UDB 6.1 on an NT machine. There is no OS/390 option in the CCA . So when I specify the IP address and port and try to connect to os/390 db2 v5.1 then it gives tcpip could not retrieve information / message !! why is this happening. Now what I did was connect this 6.1 to 5.2 on NT and then talk to os/390 thru this db2 v5.2 on another NT. [...]
21347 24 35_Re: A question about Connect PE 5.010_Michale Yu19_yubin@MAIL.DCAC.COM30_Thu, 6 Jan 2000 08:57:45 +0800389_gb2312 Hello Massimo:
I have met the same problem when I connect to DB2 for OS/390 through DB2 CONNECT EE from NT several months ago. The reason is that either your code page of DRDA AS or DRDA AR is not valide,I have solved this problem by define correct CCSID for DRDA AS and DRDA AR both.You could check information of CCSID in DB2 INSTALLATION and DB2 CONNECT EE document. [...]
21372 99 34_Re: Using time stamp - Performance23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU30_Thu, 6 Jan 2000 05:12:59 -0000425_iso-8859-1 Another option is use unload utility with a where clause. This can also be used to unload the rest and reload to get rid of the achived records hth
Andrew Puddy Phone 07 3867 1747 Mobile 0419 824 076
-----Original Message----- From: kishore erukulapati [mailto:kishore_e@HOTMAIL.COM] Sent: Thursday, 6 January 2000 5:49 To: DB2-L@RYCI.COM Subject: Using time stamp - Performance [...]
21472 281 31_Re: TCP/IP connection to OS/3900_15_leon@CA.IBM.COM30_Thu, 6 Jan 2000 00:33:07 -0500347_us-ascii The only way you will have an option that says "MVS/ESA, or OS/390, or AS/400" on the DB2 CCA screen is if you have DB2 Connect product or DB2 UDB with DB2 Connect component installed. It seems you are either using DB2 UDB Workgroup Edition or you are using DB2 UDB EE but you did not install DB2 Connect component (optional piece). [...]
21754 194 31_Re: TCP/IP connection to OS/3900_15_leon@CA.IBM.COM30_Thu, 6 Jan 2000 00:36:10 -0500335_us-ascii When you say "DB2 V6 PE from NT" do you mean "DB2 Connect Personal Edition" or "DB2 UDB Personal Edition". If you are talking about "DB2 UDB" then you are using the wrong product and you will NOT see MVS, OS/390 and AS/400 as options. DB2 UDB Personal Edition is neither licensed nor is it enabled for host connectivity. [...]
21949 181 31_Re: TCP/IP connection to OS/3900_15_leon@CA.IBM.COM30_Thu, 6 Jan 2000 00:43:45 -0500482_us-ascii Bring up DB2 CCA, and click on "Add" button. "Add Database" SmartGuide will come up. Select "Manually configure ..." radio button and new tab pages will be added to the SmartGuide. Proceed to the second page and select TCP/IP as the protocol. You should see "Target Operating System" area appear on the same page with 4 radio buttons (LAN-based, MVS/ESA or OS/390, OS/400, VM ) to select the OS. Select "MVS/ESA or OS/390" and proceed with the rest of the SmartGuide. [...]
22131 93 31_Re: TCP/IP connection to OS/3900_15_leon@CA.IBM.COM30_Thu, 6 Jan 2000 00:45:41 -0500446_us-ascii Robert, what is the EXACT product that you have installed. I don't mean version and FIxPack level. I am talking about which eddition of DB2 UDB and is DB2 Connect optional component is installed.
Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com
"MILLS,Robert" on 01/04/2000 11:14:19 PM
Please respond to DB2 Data Base Discussion List [...]
22225 19 12_Access Paths14_Anand Jeyapaul26_anandjey@CHENNAI.TCS.CO.IN30_Thu, 6 Jan 2000 12:02:28 +0530396_us-ascii New Year Greetings.
Can anyone tell me when should we optimize access paths in sql and how do we do this.
with regards
Anand
================================================ 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.
22245 256 16_Re: Access Paths27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Thu, 6 Jan 2000 12:45:51 +0530494_iso-8859-1 Anand,
When do you need to optimize access paths : ==============================================
1. Usually, the optimizer in-built in DB2 takes care of determining the optimum Access path. Sometimes however, the optimizer is not always accurate and the application analyst understands the nature of the data better than DB2. Then you can influence the optimzer into choosing an access path that you think is a better one but which the optimizer thinks is worse. [...]
22502 79 38_Re: DSNZPARM Option SEQCACH for RAID ?22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Thu, 6 Jan 2000 07:41:11 +0000446_ISO-8859-1 Joseph we chewed this over for a day about 3 months ago here in my site .. and it should be SEQ ... I have some information on this somewhere - do you want a copy (fax)?
regards
Leslie Pendlebury-Bowe
______________________________ Reply Separator _________________________________ Subject: Re: DSNZPARM Option SEQCACH for RAID ? Author: Joseph_Esposito@PUTNAMINV.COM at Internet Date: 1/5/00 1:27 PM [...]
22582 125 21_Re: Disaster Recovery22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Thu, 6 Jan 2000 07:48:14 +0000489_ISO-8859-1 Dayan
as you use BMC products for your DR .. can you tell me if the BMC products are able to handle the daily job we have here of load balancing our tapes? We are SAP and like us IU am sure your site has problems with one night your first backup job will use 1 tape the next night 2 .. so you move objects out of that job into one of your other backup jobs that is still using one tape (we have 50gig tapes) and then 2 nights later another job will go to 2 tapes .. [...]
22708 55 23_Re: DB2 to Oracle (sic)22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Thu, 6 Jan 2000 07:50:44 +0000384_ISO-8859-1 John ...send the User to a health farm for the weekend .. ORACLE??? :-)
There is a paper or something similar on this I am sure ( check the WEB)... I am sure there will be no redbook that covers how to go about taking your data from db2 to Oracle so that you can get shot of DB2 .. :-))) but there may be one on how to replicate from one to the other .. Leslie [...]
22764 27 12_db2 and IRLM4_Amit19_agarwalamit@USA.NET30_Thu, 6 Jan 2000 15:23:37 +0530338_ISO-8859-1 Hi, We have a problem with dispatching priority of DB2 and IRLM. We get the following message everytime we start DB2:
DSNT405E DISPATCH PRIORITIES NOT IN SYNC ;IRLM 0021 COMPARED TO DB2
To the best of my knowlege, the priorities here are set in the goal mode.
Thanks in advance for any help provided. [...]
22792 70 16_Re: db2 and IRLM22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Thu, 6 Jan 2000 10:42:06 +0000420_ISO-8859-1 Amit our priorities are :
1. VTAM 2. IRLM 3a. MSTR 3b. DBM1 (if i/o priority then mstr bfore dbm1)
you may place comms stack addr space between VTAM and IRLM ..
how do other have it?
Leslie
______________________________ Reply Separator _________________________________ Subject: db2 and IRLM Author: Amit at Internet Date: 1/6/00 3:23 PM [...]
22863 50 11_unsubscribe32_Diana Mendonca Andrade Fernandes24_DianaMA@BBVBRASIL.COM.BR30_Thu, 6 Jan 2000 08:52:56 -0300110_- Please remove me immediately from this list dianama@bbvbrasil.com.br
22914 47 16_Re: Access Paths22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR30_Thu, 6 Jan 2000 09:12:45 -0200588_iso-8859-1 >Can anyone tell me when should we optimize access paths in sql and how do we do >this.
How - I would suggest you the same as Deepak.
When - Whenever a program is ready to enter the production subsystem you should execute Explain for it. In our instalaltion tables have catalog information updated by Runstats once a week, on Sundays. All plans/packages are rebound after the weekly Runstats execution. In addition, I would suggest you to extract some trace data - you can use DB2 PM or another performance monitor - and generate a set of average values for [...]
22962 160 47_Re: Automatic Deletion of Log Files in UDB v6.113_Philip Nelson24_philip@PANDP.SALTIRE.ORG30_Thu, 6 Jan 2000 11:14:18 +0000603_us-ascii I wrote a REXX script to do this on our OS/2 DB2 servers and am rewriting it in Perl for AIX.
When its done I can share it with you.
Phil
On Wed, 5 Jan 2000 15:50:39 -0500, BILL_GALLAGHER@PHL.COM wrote:
>Tom, > >The logs are reused in a "wrap-around" fashion, but only if you are doing >circular logging (logretain parameter = 0). When using circular logging, >forward recovery of the database is not possible. > >We are using forward recovery logging (logretain parameter = 1) because we want >to have the ability to retain our log files indefinitely. In this [...]
23123 19 47_Inserting records in a table with VARCHAR(4096)13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Thu, 6 Jan 2000 16:46:27 +0530495_us-ascii Hi!!
I have a problem while inserting records in a table which contains fields of varchar(4096) . It gives the input is too long. Where as the length of the input is just 300 to 400 chars. What can be the solution ??
regards Vishy
================================================ 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.
23143 28 67_SQL -555: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF12_Hans Landaal27_hans.h.landaal@IS.SHELL.COM30_Thu, 6 Jan 2000 05:24:49 -0600436_- Recently I received a request to revoke a users DBADM authority. According to the info in table SYSIBM.SYSDBAUTH the grantee is the same as the grantor. The grantor has CREATEDBA authority. You probably can guess where this is going. When I execute the following SQL I receive a '-555 ,an authid cannot revoke a privilige from itself'. Executed SQL: SET CURRENT SQLID = 'userid1' ; REVOKE DBADM ON DATABASE dbname FROM userid1 ; [...]
23172 73 16_Re: db2 and IRLM4_Amit19_agarwalamit@USA.NET30_Thu, 6 Jan 2000 17:07:31 +0530372_ISO-8859-1 Leslie,
can you please let me know where/how you have set your priorities? To the best of my knowledge our proirities are set in the goal mode....can you provide me a copy of your prioirty list and which member it is defined....
Amit
*********** REPLY SEPARATOR ***********
On 1/6/00, at 10:42 AM, Leslie Pendlebury-Bowe wrote: [...]
23246 198 87_Web site to hold user-developed tools?, was Automatic Deletion of Log Files in UDB v6.113_Lynne Flatley17_LFlatley@NEFN.COM30_Thu, 6 Jan 2000 06:44:53 -0500419_iso-8859-1 Many months ago, while we were still using American University as the host of the listserv, some folks had talked about a member of the listserv building and maintaining their own Web site where we could store members' REXX, Perl, etc. tools. I would like to volunteer again to do this if no one has any objections. I've cc'd the owners of this list to confirm that they don't have a problem with this. [...]
23445 63 71_Re: SQL -555: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF9_Chris Tee18_TEECHRI@UK.IBM.COM30_Thu, 6 Jan 2000 11:52:08 +0000359_us-ascii My guess is that userid1 is the creator of the database and thus gets all privileges including DBADM automatically. The only way to revoke DBADM from userid1 would be to drop the database and recreate it with another id as creator.
Regards
Chris Tee
DB2 Systems Programmer IBM UK DB/DC Systems Support North Harbour [...]
23509 82 71_Re: SQL -555: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF13_Lynne Flatley17_LFlatley@NEFN.COM30_Thu, 6 Jan 2000 07:03:38 -0500603_us-ascii I'm going to assume that your own ID has sysadm authority...execute the revoke from userid1 again but don't set the current SQLID to userid1. Execute the revoke under your own ID.
> -----Original Message----- > From: Chris Tee [SMTP:TEECHRI@UK.IBM.COM] > Sent: Thursday, January 06, 2000 6:52 AM > To: DB2-L@RYCI.COM > Subject: Re: SQL -555: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE > FROM ITSELF > > My guess is that userid1 is the creator of the database and thus gets all > privileges including DBADM automatically. The only way to revoke DBADM > from > userid1 would be to [...]
23592 80 34_Re: Using time stamp - Performance10_Bill Brown25_bill_brown@SPRINGMAIL.COM30_Thu, 6 Jan 2000 07:23:27 -0500480_- If the retention perion remains constant I would recommend calculating the date in an initialization routine ONE TIME and placing the result in a host variable. By using this method DB2 doesn't have to calculate the date each time.
On Thu, 6 Jan 2000 10:32:46 +1000 Michael Hannan wrote:
kishore,
If you are on DB2 V5, then step 1 and step 2 of alternative solution can be combined into 1 SQL and indexable on cre_date_time: [...]
23673 27 92_Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB v6.113_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Thu, 6 Jan 2000 07:41:47 -0500405_iso-8859-1 Hello Lynne, I think that's an excellent idea.
Think of the trouble this would have saved Herr Dr. Ebert and others who've recently had to distribute things like this manually. And think of the bandwidth it would save on this list from individuals who don't heed the suggestion to write the distributor individually rather than post their interest back for the entire list to read. [...]
23701 102 16_Re: db2 and IRLM18_Andrade, Alexander25_alexander.andrade@CAI.COM30_Thu, 6 Jan 2000 12:45:33 -0000640_iso-8859-1 Address space priorities are normally set using the IEAIPSxx and IEAICSxx members in SYS1.Parmlib, you will probably need to consult with the cissy progs
Alex Andrade
ANDAL04@cai.com
-----Original Message----- From: Amit [SMTP:agarwalamit@USA.NET] Sent: Thursday, January 06, 2000 11:38 AM To: DB2-L@RYCI.COM Subject: Re: db2 and IRLM
Leslie,
can you please let me know where/how you have set your priorities? To the best of my knowledge our proirities are set in the goal mode....can you provide me a copy of your prioirty list and which member it is defined.... [...]
23804 66 29_Load Errors using VARCHAR Col11_Ken Liberty26_KLiberty@CONSULTEC-INC.COM30_Thu, 6 Jan 2000 08:00:11 -0500335_US-ASCII I have a LOAD job, which is failing on a Decimal defined column which is preceded by a VARCHAR column.... I've seen in the DB2 Developers Guide, 3rd edition that it is recommended that VARCHAR columns are placed at the end of the table, but that does not explain why I cannot have a VARCHAR in the middle of the table??? [...]
23871 49 39_Re: DB2 for OS/390 from other platforms14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US30_Thu, 6 Jan 2000 08:25:50 -0500369_us-ascii Hi Mark,
I wish I could answer your technical questions but alas I can not. As for the 'recommended documents' - the entries on my list of "Read when you get free time" ;-) are : Distributed Relational Database Architecture Connectivity Guide (SC26-4783) and Distributed Relational Database Cross Platform Connectivity and Applications (SG24-4311) [...]
23921 258 31_Re: TCP/IP connection to OS/39014_Philip Gunning20_pgunning@BOSCOVS.COM30_Thu, 6 Jan 2000 09:08:27 -0500380_us-ascii Manas, What version and type of DB2 connect are you using? I have seen this error before and it was because the ip address in the node directory on the client was wrong. Check that the hostname and port are correct there. HTH .Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner [...]
24180 86 33_Re: Load Errors using VARCHAR Col17_Marchese, Frank D18_fdmarchese@ATT.COM30_Thu, 6 Jan 2000 09:11:08 -0500425_iso-8859-1 I don't believe that you can't have VARCHAR columns in mid-row but it is recommended they be at the end of the row. This is a perf issue having to do with the amt of the row logged during an SQL UPDATE , as I remember it.
-----Original Message----- From: Ken Liberty [mailto:KLiberty@CONSULTEC-INC.COM] Sent: Thursday, January 06, 2000 8:00 AM To: DB2-L@RYCI.COM Subject: Load Errors using VARCHAR Col [...]
24267 37 14_Testing in DB215_Michael Bancale21_mbancale@TXFB-INS.COM30_Thu, 6 Jan 2000 08:17:07 -0600567_iso-8859-1 We have been a mostly VSAM shop for a really long time. We have moved some small and medium systems to DB2 by rewriting them. We recently put what I am considering a large application to DB2. This application now shares some data with two other applications. In the testing environment the two areas were having some difficulties testing because the common table was needed on way for one team and another way for the other team. We are now beginning work on a large system which will share data between even more systems. In the past if a programmer [...]
24305 21 53_Getting PLAN name in a COBOL/DB2 OS/390 batch program17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM30_Thu, 6 Jan 2000 09:23:16 -0500376_- Does anyone know a better way of getting the PLAN name in a COBOL/DB2 OS/390 batch program during its execution? (running with PGM=IKJEFT1B)
My only idea is to read the SYSTSIN file (or a copy of it) into the COBOL program and parse the RUN PROGRAM(...) PLAN(...) control card. I've gotten this to work but was wondering if something better/simpler is possible. [...]
24327 121 33_Re: Load Errors using VARCHAR Col17_Patricia Candella21_pcandella@METLIFE.COM30_Thu, 6 Jan 2000 09:27:44 -0500533_us-ascii Ken, In order for this to work.. the position (40 - in your example) must be the beginning of your length field, and the variable length field must be padded on your load file to the maximum length of your field. The reason it has to be padded is so that the next field can be found in the position that you have specified in your load criteria. I have had problems with this type of load before if the file that was generated from a BMC Unloadplus utility.. for some reason, the length bytes are not provided.. on the [...]
24449 221 31_Re: TCP/IP connection to OS/39014_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Thu, 6 Jan 2000 09:36:35 -0500586_iso-8859-1 That answers it. I am using DB2 UDB Personal Edition. Thanks for all your help.
Manas.
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > leon@CA.IBM.COM > Sent: Thursday, January 06, 2000 12:36 AM > To: DB2-L@RYCI.COM > Subject: Re: TCP/IP connection to OS/390 > > > When you say "DB2 V6 PE from NT" do you mean "DB2 Connect > Personal Edition" > or "DB2 UDB Personal Edition". If you are talking about "DB2 UDB" then you > are using the wrong product and you will NOT see MVS, OS/390 and AS/400 as > [...]
24671 61 39_Re: DB2 for OS/390 from other platforms0_14_dcreed@CSC.COM30_Thu, 6 Jan 2000 08:43:48 -0600305_us-ascii I am sure there are other vendors that supply the client. One that used to be quoted on the list heavy was something like StarSQL or something like that.
QMF for windows goes direct into DB2 with TCPIP and no CAE client or DB2 Connect software is required. Not sure about the others. [...]
24733 105 33_Re: Load Errors using VARCHAR Col17_Linda F. Claussen18_lindafc@NETINS.NET30_Thu, 6 Jan 2000 08:47:06 -0600561_ISO-8859-1 Ken,
I have loaded data with the VARCHAR in the middle, due to columns added after the fact.
I would double check the starting position of the decimal columns and the data type. Is the decimal data you are loading in the appropriate format? DECIMAL is the same as DECIMAL PACKED so you need to make sure that the input data is in the appropriate packed decimal format. If it is not, use DECIMAL ZONED or DECIMAL EXTERNAL (length,scale) to define the format of the input data so DB2 can convert it properly to the column data type. [...]
24839 116 33_Re: Load Errors using VARCHAR Col20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 6 Jan 2000 10:05:01 -0500410_iso-8859-1 Ken
VARCHAR in the middle of the table is never a problem unless you have two varchars and you want to load without mentioning the full LOAD card. For example -
LOAD DATA LOG NO INDDN SYSREC00 INTO TABLE TEST.TABLE1
The above control card works when VARCHAR is at the end but loads wrong data if you have two varchars. One VARCHAR in the middle and another one after this. [...]
24956 29 16_db2 index broken10_Jan Rabaut23_jan.rabaut@SGMS.SEMA.BE30_Thu, 6 Jan 2000 16:13:26 +0100311_iso-8859-1 We have a strange problem on new created indexspaces since 1 Jan 2000.
Situation: We created a type 2 index containing 2 columns as key in ascending order. When we insert rows in random order in that table, we receive the rows back in random order although we did a select via the index. [...]
24986 10 26_Looking for DB2 Connect PE10_Bill Brown25_bill_brown@SPRINGMAIL.COM30_Thu, 6 Jan 2000 10:28:12 -0500329_- Does anyone know where to obtain a copy of DB2 Connect Personal Edition on the web???
================================================ 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.
24997 51 24_Re: Using One Global CSI12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 6 Jan 2000 09:26:00 -0500507_- I use a Global CSI for each product (DB2, QMF, DB2PM, CSP). This may be a waste but I like to keep it that way for isolation purposes in the event something should go wrong with SMP processing. I admit I am not an expert in SMP and I don't want to or have time to be. Also, The DB2 sysadmin before me had all of the DB2 products in one CSI along with other products belonging to other groups. One of the other groups decided to delete the CSI. Later, I needed to update one of those products because [...]
25049 47 39_Re: DB2 for OS/390 from other platforms11_Hilton Tina15_HiltonT@TCE.COM30_Thu, 6 Jan 2000 07:24:52 -0500691_iso-8859-1 I don't know how you can do it without something like DB2 Connect, but there are alternatives to DB2 Connect. We use StarSQL from StarQuest.
-----Original Message----- From: Tierney, Mark [mailto:mtierney@FIRSTAM.COM] Sent: Wednesday, January 05, 2000 4:21 PM To: DB2-L@RYCI.COM Subject: DB2 for OS/390 from other platforms
Hello List,
Currently we have a Data Warehouse that is queried by Mainframe query tools. This is considered somewhat antiquated and a little cumbersome as it requires our clients to have special training. We are beginning to look at querying the data from other platforms (user pc's, other databases, etc.). I myself have [...]
25097 117 34_Re: Using time stamp - Performance15_Philip, Sibimon19_PhilipS@SEALAND.COM30_Thu, 6 Jan 2000 10:41:08 -0500620_iso-8859-1 Bill,
Where cre_date_time <= TIMESTAMP(DATE(:ws_current_date) - (:retention_days) DAYS, TIME('00:00:00'))
In the above SQL, will DB2 calculate timestamp for each record? Since the retention period is populated before opening the cursor, I think timestamp is calculated only once.
Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com
-----Original Message----- From: Bill Brown [mailto:bill_brown@SPRINGMAIL.COM] Sent: Thursday, January 06, 2000 6:23 AM To: DB2-L@RYCI.COM Subject: Re: Using time stamp - Performance [...]
25215 213 92_Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB v6.111_Hilton Tina15_HiltonT@TCE.COM30_Thu, 6 Jan 2000 07:49:41 -0500436_iso-8859-1 I thought it had been decided that CBT (http://www.cbttape.org/) was the best place to submit these to, since they're already set up for it. Or was that only one of the suggestions?
-----Original Message----- From: Lynne Flatley [mailto:LFlatley@NEFN.COM] Sent: Thursday, January 06, 2000 6:45 AM To: DB2-L@RYCI.COM Subject: Web site to hold user-developed tools?, was Automatic Deletion of Log Files in UDB v6.1 [...]
25429 54 24_Re: Using One Global CSI11_Hilton Tina15_HiltonT@TCE.COM30_Thu, 6 Jan 2000 07:55:52 -0500505_iso-8859-1 How did you handle new releases of DB2? Did you set up new target and dlib zones for them? I create a whole new global for each release of DB2 since I need to keep the old one available until I have the last system installed. Also, at our shop when we go to a new release of MVS (or OS/390 when we get to it), then it's an entirely new system. Do you do something like this too? It seems like it would be messy to get all the sysmods, holds, and target and distribution zones added to the [...]
25484 134 39_Solution: Load Errors using VARCHAR Col11_Ken Liberty26_KLiberty@CONSULTEC-INC.COM30_Thu, 6 Jan 2000 10:38:01 -0500455_US-ASCII Thanks to all those that offered advice on this problem.... The solution to the problem is described below... The entire LOAD Statement was NOT used, as I had assumed it was.... Once again its clear that you should NEVER ASSUME anything....
Thanks Ken
____________________Reply Separator____________________ Subject: Re: Load Errors using VARCHAR Col Author: "Pillay; Venkat (PCA)" Date: 1/6/00 10:05 AM [...]
25619 23 71_Re: SQL -555: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF0_18_DB2DBAinTX@AOL.COM28_Thu, 6 Jan 2000 10:47:46 EST321_us-ascii You can either unload all the data out of all the tables in the database, drop the database, create the database, tablespaces, tables, indexes, foreign keys, primary keys, view, aliases, synonyms or Change macro DSN6SPRC to &SPRMCTU SETC '1'' and reassemble ZPARM and update the catalog with the new owner. [...]
25643 16 39_Re: DB2 for OS/390 from other platforms12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 6 Jan 2000 07:47:43 -0800418_us-ascii QMF for Windows implements the DRDA requester directly, so there is no need for DB2 Connect. We've found that DB2 Connect has been doing very well.
Roger Miller
================================================ 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.
25660 14 39_Re: DB2 for OS/390 from other platforms16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Thu, 6 Jan 2000 10:48:41 -0500309_us-ascii Try qmf for windows http://www.rocketsoftware.com/qmf/ Tom
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
25675 146 71_Re: SQL -555: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF10_Ali OZTURK27_ali.ozturk@PAMUKBANK.COM.TR30_Thu, 6 Jan 2000 17:44:13 +0200696_iso-8859-9
Hi Hans,
Can you try the following statement please ? REVOKE DBADM ON DATABASE dbname FROM userid1 BY userid1;
-----Original Message----- From: Hans Landaal [mailto:hans.h.landaal@IS.SHELL.COM] Sent: Thursday, January 06, 2000 1:25 PM To: DB2-L@RYCI.COM Subject: SQL -555: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF
Recently I received a request to revoke a users DBADM authority. According to the info in table SYSIBM.SYSDBAUTH the grantee is the same as the grantor. The grantor has CREATEDBA authority. You probably can guess where this is going. When I execute the following SQL I receive a '-555 ,an authid cannot revoke a [...]
25822 18 22_Java in SP on DB2/390?0_28_henrik-bang.sorensen@UBS.COM30_Thu, 6 Jan 2000 16:55:35 +0100365_US-ASCII Hi List,
Any knews about using Java to program stored procedures on DB2/390 ?
Thanks Henrik Sorensen
================================================ 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.
25841 248 92_Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB v6.113_Lynne Flatley17_LFlatley@NEFN.COM30_Thu, 6 Jan 2000 10:55:50 -0500585_iso-8859-1 They offered but nothing seemed to have happened. Once again, if I see no objections, I will have a site up and available by Tuesday, January 11th.
> -----Original Message----- > From: Hilton Tina [SMTP:HiltonT@TCE.COM] > Sent: Thursday, January 06, 2000 7:50 AM > To: DB2-L@RYCI.COM > Subject: Re: Web site to hold user-developed tools?, was Automatic > Deletio n of Log Files in UDB v6.1 > > I thought it had been decided that CBT (http://www.cbttape.org/) was the > best place to submit these to, since they're already set up for it. Or > was > that only one [...]
26090 87 24_Re: Using One Global CSI19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 6 Jan 2000 09:55:47 -0600606_iso-8859-1 Bob, ON THE NOSE -- Nobody will take better care of DB2 than the DB2 folks, if you have the SMPE skills!!!!!!
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 your computer. Any other use, retention, dissemination, [...]
26178 20 53_Implications of running batch and online concurrently0_22_Thomas_Abbott@HESC.COM30_Thu, 6 Jan 2000 10:45:26 -0500579_us-ascii We are a shop which runs CICS transactions during the day and batch jobs at night after online update has been programmatically disabled. We are investigating the possibilities of running batch and online update transactions concurrently. I am interested in methods used to allow this. Our batch programs currently take table locks and commit at the end of processing. Our tables are defined with page-level locks. What sort of programmatic(locking, commits, rollbacks, restarts, timestamp considerations on read/update) and/or database changes would be required ? [...]
26199 232 31_Re: TCP/IP connection to OS/39013_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US30_Thu, 6 Jan 2000 10:58:36 -0500403_US-ASCII Hi Leon,
A copy of DB2 UDB V6.1 Personal Edition, DB2 Connect V6.1 Personal Edition, and the Control Center V6.1 was installed on an NT machine for evaluation purposes. I found the license information in the Control Center and it says that the DB2 UDB Personal Edition V6 is licensed and the Expiration date is 1/28/2000 (Try or Buy). That is the only product listed under License. [...]
26432 102 24_Re: Using One Global CSI16_Byars, Ann Marie19_ambyars@EASTMAN.COM30_Thu, 6 Jan 2000 10:53:50 -0500524_- I have been using SMPE for about 15 years or so. I would discourage putting so many products into one CSI. I agree with Bob - ONE CSI per product is much more feasible.
We currently have IMS and DB2 in one CSI because the person who setup DB2 also setup IMS and was supporting both products. Now we have one person supporting IMS and one supporting DB2 and we run into conflicts with data set accesses when we are both trying to put on maintenance at the same time - we have to be sure to coordinate with each [...]
26535 49 57_Re: Implications of running batch and online concurrently14_Philip Gunning20_pgunning@BOSCOVS.COM30_Thu, 6 Jan 2000 11:09:15 -0500603_us-ascii Tom, You really need to take a hard look at the transaction mix, commit frequency, locking strategy, use of uncomitted read where prudent and possible, and the most important area is how the applications group originally wrote the application. Are there logical steps in the process that takes locking into consideration, IE; do the applications always access the objects in a certain order to avoid contention or not? The answer is probably no. So you will have some contention. The degree of contention will be determined by the transaction mix at your shop. It is possible to do it but [...]
26585 51 51_Re: Inserting records in a table with VARCHAR(4096)12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 6 Jan 2000 08:02:46 -0800408_us-ascii I don't have enough information for anything but a guess or two.
guess 1) You are inserting with literals "this is a short string" The limit for a literal text string is 255. Use host variables instead of literals. With V6, you can concatenate multiple strings for this.
guess 2) VARCHAR(4096) and the other columns don't fit into a 4K page. You will need an 8K, 16K or 32K page. [...]
26637 58 51_Re: Inserting records in a table with VARCHAR(4096)9_Sally Mir16_smir@BCBS-GA.COM30_Thu, 6 Jan 2000 11:17:04 -0500564_us-ascii My guess would be that you're not initializing the length field for the VARCHAR column.... Be sure to set it to the value of the length of your string.
Sally Mir
Roger Miller wrote:
> I don't have enough information for anything but a guess or two. > > guess 1) You are inserting with literals "this is a short string" > The limit for a literal text string is 255. Use host variables > instead of literals. > With V6, you can concatenate multiple strings for this. > > guess 2) VARCHAR(4096) and the other columns don't fit into [...]
26696 48 57_Re: Implications of running batch and online concurrently17_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM30_Thu, 6 Jan 2000 11:18:29 -0500504_iso-8859-1 You should start by restating the problem.
/Purist Mode - in an OLTP environment there are no batch jobs, only non-terminal transactions that run concurrently with other transactions -/Purist Mode off
In real life the minimal change is to remove the lock table statements and have the batch jobs take regular commits to avoid lockouts. Since values of "regular" are hard to guesstimate, a table with jobname, time and commit frequency allows you to tune without recompiles. [...]
26745 67 39_DB2 DATA SHARING DLI BATCH GROUP ATTACH0_18_cmunson@US.IBM.COM30_Thu, 6 Jan 2000 09:27:18 -0700548_us-ascii Jodi, While it is true that DB2 does not provide group attach support for DL/I batch in mainline code, a usermod is and has been available for some time. Tom Brooks in DB2 Level 2 is the current coordinator of this usermod. The reason that we don't have a full blown PTF is that there may be a slight behavior difference before/after the code is applied. This behavior difference is minor and does not apply to everyone but we did not feel it wise to implement at the time with this difference. Instead we did 2 things, first we have [...]
26813 47 20_Re: db2 index broken0_23_Mike_Levine@TEKHELP.NET30_Thu, 6 Jan 2000 11:34:56 -0500575_us-ascii Hi,
This is probably not a Y2K issue. If you want the rows back in a certain order use must code an ORDER BY clause. The ORDER BY may or may not cause a sort depending on the access method DB2 uses.
Regards,
Michael Levine Permier Data Services, Inc.
>We have a strange problem on new created indexspaces since 1 Jan 2000. > >Situation: We created a type 2 index containing 2 columns as key in >ascending order. >When we insert rows in random order in that table, we receive the rows back >in random order >although we did a [...]
26861 59 18_Re: Testing in DB20_23_Mike_Levine@TEKHELP.NET30_Thu, 6 Jan 2000 11:35:59 -0500400_us-ascii Hi,
One suggestion to consider is to add a column to the tables (like 'OPER_ID') and create views on the tables as SELECT * FROM tab WHERE OPER_ID=USER WITH CHECK OPTION. As data is added to the tables you can populate the OPER_ID field as necessary. Programmers would then only see and manipulate their own data and not step on others. LOADs would still have to be coordinated. [...]
26921 33 92_Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB v6.112_Jim Harrison12_jimh@QIS.NET30_Thu, 6 Jan 2000 11:39:18 -0500592_us-ascii I don't recall the discussions about this, but I think a DB2 specific site might be better suited to this purpose. I always thought the CBT was for all purpose/platform type files and I think we could easily flood it with DB2 specific utilities. I say go with it!
At 10:55 AM 1/6/00 -0500, you wrote: >They offered but nothing seemed to have happened. Once again, if I see no >objections, I will have a site up and available by Tuesday, January 11th. > >> -----Original Message----- >> From: Hilton Tina [SMTP:HiltonT@TCE.COM] >> Sent: Thursday, January 06, 2000 7:50 AM [...]
26955 84 43_Re: DB2 DATA SHARING DLI BATCH GROUP ATTACH0_23_Mike_Levine@TEKHELP.NET30_Thu, 6 Jan 2000 11:40:28 -0500620_us-ascii Hi Chris,
Will something similar be available for CICS RCT group attach support?
Thanks, Michael Levine Premier Data Services, Inc.
>Jodi, While it is true that DB2 does not provide group attach support for >DL/I batch in mainline code, a usermod is and has been available for some >time. Tom Brooks in DB2 Level 2 is the current coordinator of this >usermod. The reason that we don't have a full blown PTF is that there may >be a slight behavior difference before/after the code is applied. This >behavior difference is minor and does not apply to everyone but we did [...]
27040 78 57_Re: Implications of running batch and online concurrently19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 6 Jan 2000 10:48:08 -0600613_iso-8859-1 Craig, One issue that hasn't been noted thus far is that some batch process(es) may actually need ISOLATION(RR) and/or LOCK several TABLEs within a unit of work.
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. [...]
27119 92 37_Selective Partition Locking and NPI's0_18_cmunson@US.IBM.COM30_Thu, 6 Jan 2000 09:52:58 -0700606_us-ascii Dave, As you probably know Selective Partition Locking (SPL) is a tablespace keyword, only applicable to the partition tablespace and therefore not a player for your NPI. If you have affinities of members to the partitions and if using SPL this will avoid GBP dependency on the tablespace partitions and will lessen coupling facility overheads for the tablespace. The NPI on the other hand can't enjoy the same luxury. With each member is inserting into different parts, they all are still inserting into the one NPI and therefore it will be GBP dependent. There really isn't much you can do [...]
27212 51 30_Re: Delete rule in foreign key14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Thu, 6 Jan 2000 11:05:37 -0600466_ISO-8859-1 The behavior of the NO ACTION delete rule is similar to RESTRICT. The only difference is that RESTRICT enforces the delete rule immediately and NO ACTION enforces the delete rule at the end of the statement. When deleting multiple rows from a table with a self-referencing constraint, RESTRICT would prohibit the delete, but NO ACTION can allow it to complete. To use NO ACTION the current rules special register must be set to STD (instead of DB2). [...]
27264 45 70_Re: SQL -555: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROMITSELF14_Marilyn Stokes28_mstokes@OPPENHEIMERFUNDS.COM30_Thu, 6 Jan 2000 10:12:03 -0700262_us-ascii Is the user that you are trying to revoke the CREATOR of the DB object? If so, they have the inherent rights to DBADM. I had the same issue, the only way around is to rebuild using a different creator id. This is where RACF group usage is ideal. m [...]
27310 101 57_Re: Implications of running batch and online concurrently17_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM30_Thu, 6 Jan 2000 12:23:42 -0500452_iso-8859-1 Rick,
You're right. The original question referred to batch update jobs, which I assumed to be old style VSAM master file update logic. The lock table and/or RR requirements would imply a balance and audit type process, which is incompatible with any updates. Some application designer somewhere has undoubtably added updates to a balance and audit run. It's going to take more than DBA work to fit that into a 24/7 environment. [...]
27412 93 24_Re: Using One Global CSI12_Sue Janowitz18_SJanowitz@NEFN.COM30_Thu, 6 Jan 2000 12:26:52 -0500544_us-ascii For what it's worth, we keep each product in its own CSI. And for each new release of DB2 (or QMF, TMON for DB2, etc.), I create a new global zone. (Like Tina, we need to keep the old one available until all subsystems have been upgraded to the newest release.) Then, after the new release has been upgraded across the board, I archive the old CSI for a while, then delete it. We use extra DASD space temporarily, but it works well. And since different products are installed by different people, there are no conflicts on usage. [...]
27506 85 36_FW: Saving authority settings (BMC?)13_Melian, Terri20_Terri_Melian@BMC.COM30_Thu, 6 Jan 2000 11:22:07 -0600361_ISO-8859-1 One of the consultants I work with does installation and training for BMC Software's Change Manager and Catalog Manager. He does not currently subscribe to the list, so I passed your question along to him. Here is his reply:
There is a way to do this but it will take some editing of the worklist. The way I use to do this is as follows: [...]
27592 52 21_Re: Disaster Recovery13_Dayna Brennan25_Dayna.Brennan@STATE.MN.US30_Thu, 6 Jan 2000 11:33:06 -0600554_iso-8859-1 That would be the reason. The other reason would be if we had some sort of "software system meltdown". Since we don't in many cases know what tables are involved (due to the dynamic nature of the SQL), if we have to restore one table we would restore them all just in case something needs to be in synch that we don't know about. We do have a few processes where we create recoverability points, and luckily we've never had to actually bring back the entire production database into production. We did however once put a copy of the data [...]
27645 108 36_Re: Saving authority settings (BMC?)15_Philip, Sibimon19_PhilipS@SEALAND.COM30_Thu, 6 Jan 2000 13:05:27 -0500537_iso-8859-1 We have CATALOG MANAGER 5.4.02. I am not able to do HGRANT. It is giving UNKNOWN COMMAND error. Also I checked BMC's Catalog manager command reference and I do not see this command. Is our version old?
thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com
-----Original Message----- From: Melian, Terri [mailto:Terri_Melian@BMC.COM] Sent: Thursday, January 06, 2000 11:22 AM To: DB2-L@RYCI.COM Subject: FW: Saving authority settings (BMC?) [...]
27754 129 36_Re: Saving authority settings (BMC?)13_Horton, Libby20_Libby_Horton@BMC.COM30_Thu, 6 Jan 2000 12:11:50 -0600613_ISO-8859-1 HGRANT was added in Catalog Manager 5.4.03, so it looks like you just missed it. Sorry! The current version is 5.4.05.
Best regards, Libby Horton BMC Product Support 1-800-537-1813
-----Original Message----- From: Philip, Sibimon [mailto:PhilipS@SEALAND.COM] Sent: Thursday, January 06, 2000 12:05 PM To: DB2-L@RYCI.COM Subject: Re: Saving authority settings (BMC?)
We have CATALOG MANAGER 5.4.02. I am not able to do HGRANT. It is giving UNKNOWN COMMAND error. Also I checked BMC's Catalog manager command reference and I do not see this command. Is our version old? [...]
27884 37 0_13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Thu, 6 Jan 2000 12:14:23 -0600475_US-ASCII Hello Stan, You can use the db2admin "SETID" command to set the userid and password. It's documented in the command reference. HTH Kurt
>>> 01/05/00 09:39AM >>> Question for all you DB2 connect experts. I installed DB2 connect on Windows NT, the panel that request a username and password was completed, but when I reboot I am getting an error when the task 'DB2DAS00' is started, how do I change that userid andpassword. [...]
27922 52 39_Re: DB2 for OS/390 from other platforms16_Dennis P Bennett20_dbennett@NEONSYS.COM30_Thu, 6 Jan 2000 12:16:17 -0600608_us-ascii Dennis P Bennett@NEON 01/06/2000 12:16 PM
Mark,
NEON Systems, where I work, has a product called Shadow Direct which will allow clients to directly access DB2 data and stored procedures.
Shadow Direct consists of two parts, a client-side driver (available for Windows, Unix, Linux, OS/2) and an OS390-MVS-based server. Shadow Direct uses either the ODBC or JDBC API and accesses DB2 through the Call Attach Facility. The product performs very well and can scale to over tens of thousands of users. There is no need for any gateway servers when connecting to the mainframe. [...]
27975 24 29_CA/Platinum Detector question11_aime Duclos22_aime_Duclos@BCBSME.COM30_Thu, 6 Jan 2000 13:52:23 -0500592_us-ascii A fellow DBA has asked if I would present a concern re: Platinum Detector. Platinum basically has said to unload/load. There are differences in the layouts of the two historys. Has anyone done this? Willing to share? We are on DB2 v.5, OS/390.
Here's Paul question:
What I need is any information and load parameters to convert the Platinum Detector history from release 5.1.2 to release 97G. This information is stored in the Datastores and I believe all I need to do is unload it from the old version and load it into the new. It may be more complicated [...]
28000 12 0_13_Lourdes Kishi14_lkishi@BKB.COM30_Thu, 6 Jan 2000 12:58:00 -0500268_US-ASCII LISTSERV@ryci.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
28013 46 33_Re: CA/Platinum Detector question0_20_John_Lendman@FPL.COM30_Thu, 6 Jan 2000 14:12:25 -0500611_us-ascii Why not use Platinum RC Migrator. This should do exactly what you want to do. John
"aime Duclos" on 01/06/2000 01:52:23 PM
Please respond to "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM cc: Subject: CA/Platinum Detector question
A fellow DBA has asked if I would present a concern re: Platinum Detector. Platinum basically has said to unload/load. There are differences in the layouts of the two historys. Has anyone done this? Willing to share? We are on DB2 v.5, OS/390. [...]
28060 35 39_DB2 DATA SHARING DLI BATCH GROUP ATTACH0_18_cmunson@US.IBM.COM30_Thu, 6 Jan 2000 12:30:18 -0700535_us-ascii Michael, The CICS support is a little more complicated because of in-doubts. This has been on our plate as well and we recognize it as a requirement and are working on it. Presently there is no, nor will there be a usermod for CICS before we announce our CICS group attach support. The only other thing I would mention is that the CICS attach is now owned by CICS at Hursley so while we need to provide some code to allow CICS group attach, they have changes on their end as well and are working on something. Sorry if I [...]
28096 32 8_UDB List13_George Peters22_gpeters@COMPUSERVE.COM30_Thu, 6 Jan 2000 14:42:05 -0500636_iso-8859-1 Hi. Doesn anyone recall the exact name of the UDB list, and the command to subscribe to it? In the meantime here is my question (again).
re DB2 UDB Workgroup Edition for WIN NT (Version 6.1, migration from 5.2).
Am wondering if anyone has encountered a message in WIN NT Event Viewer like "The library file c:\winnt\system32\db2Perf.dll specified for the DB2_NT_Performance Service could not be opened". This happens immediately after upgrade from V5.2 to V6.1 The problem generated by this message is that there are now no DB2-related objects in the WIN NT Performance Monitor. The monitor cannot be used [...]
28129 55 12_Re: UDB List14_Philip Gunning20_pgunning@BOSCOVS.COM30_Thu, 6 Jan 2000 14:52:42 -0500554_us-ascii George, Go to http://people.mn.mediaone.net/scottrmcleod and follow the instructions. Regards, Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Certified Solutions Expert -- CICS TS Assoc List Owner
-----Original Message----- From: George Peters [SMTP:gpeters@COMPUSERVE.COM] Sent: Thursday, January 06, 2000 2:42 PM To: DB2-L@RYCI.COM Subject: UDB List
Hi. Doesn anyone recall the exact name of the UDB list, and the command to subscribe to it? In the meantime here is my question (again). [...]
28185 15 12_CDB software12_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM30_Thu, 6 Jan 2000 14:49:37 -0500419_iso-8859-1 Does anyone have experience with using CDB software (supercopy, automation, superreorg, rw-reorg). Any information will be gratefully appreciated.
Andy Wheeler
================================================ 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.
28201 35 41_Re: OS390 DB2 5.1/Websphere/java servlets12_Daniel Kirby25_daniel.kirby@CITICORP.COM30_Thu, 6 Jan 2000 14:55:07 -0500607_us-ascii Yes, java servlets running on WebSphere containing either dynamic SQL or stored procedure calls can access DB2 data stored on OS/390. I am not familiar with JDBCservlet.java. Send me the code (off-line) or I could send you (off-line) a small servlet that works.
Daniel.
Sumedh wrote:
> Hi all > Does JDBC driver for DB2 5.1 on OS/390 support java servlets > accessing DB2 from Websphere? > For DB2 version 5.1 on OS/390, we have installed the JDBC driver > and also CLI. We were able to succesfully run the standalone Java sample > SAMPLE01.JAVA that is supplied with the [...]
28237 39 16_Re: CDB software18_Teegarden, Stephen22_Teegarden@AEGONUSA.COM30_Thu, 6 Jan 2000 14:26:57 -0600702_- Andy;
We use CDB image copy and reorg products. I have found them fast and easy to use. No problems at all. I am happy with the products.
Steve Teegarden, DBA PeopleSoft 319-398-8066
> -----Original Message----- > From: Andy Wheeler [SMTP:Andy.Wheeler@GRIZZARD.COM] > Sent: Thursday, January 06, 2000 1:50 PM > To: DB2-L@RYCI.COM > Subject: CDB software > > Does anyone have experience with using CDB software (supercopy, > automation, > superreorg, rw-reorg). Any information will be gratefully appreciated. > > Andy Wheeler > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L [...]
28277 78 43_Re: DB2 DATA SHARING DLI BATCH GROUP ATTACH14_Steven Camitta30_steven.camitta@INGRAMMICRO.COM30_Thu, 6 Jan 2000 12:37:10 -0800475_iso-8859-1 Jodi,
We implemented a front end step within our DB2-DLI proc that takes the SSN (passed by parm field) and looks it up in a control stmt translation table. The translate pgm first obtains the host name where it's running. It then takes the SSN passed thru parm & host name and searches for a translation. Group name is always translated to SSID. SSIDs are also coded in the table so that they can be used as well. They simply translate to themselves. [...]
28356 43 35_Default schema alternatives on AIX?0_18_damcon2@US.IBM.COM30_Thu, 6 Jan 2000 15:49:25 -0500470_us-ascii Hello all,
Does anyone know if there is a way to set a default schema for a database with DB2 UDB V5.2 on AIX, other than issuing the "set current schema" command. What we are looking for is a way for anyone who connects to the database to automatically have the same default schema instead of the id they're connected with. The reason I ask is, we are testing a product that is not qualifying column names in the SQL properly. An example would be: [...]
28400 59 57_Re: Implications of running batch and online concurrently12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM28_Thu, 6 Jan 2000 12:52:05 PST634_- Thomas:
I would like to suggest review some points before you start to process online and batch concurrently. -If you are on V4 or later , use index type 2 . - Plan or Package definitions. If you want to improve your concurrency you have bind your aplications chosing the options that can help you to get it like ISOLATION (CS) , ACQUIRE(USE), and RELEASE(COMMIT). Specifying Isolation level CURSOR STABILITY allow your application lock the page long enough meantime the cursor is getting another page. Acquire(use) (default for packages) and Release(commit) allow your application free resources more frecuently but it [...]
28460 15 17_DB2 Communication12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Thu, 6 Jan 2000 14:54:47 -0600453_us-ascii We are developing an application that will communicate across LPARS to different DB2 subsystems. What is the best way to do this? Is DDF and LU 6.2 our only option? Any information would be 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.
28476 35 21_Re: DB2 Communication12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 6 Jan 2000 13:00:18 -0800659_us-ascii Its certainly one way. But you've got my interest so I'll bite and ask the obvious question. Why not use DB2 data sharing? Its designed to facilitate this communication easily.
--- Dan Sullivan wrote: > We are developing an application that will > communicate across LPARS to different > DB2 subsystems. What is the best way to do this? Is > DDF and LU 6.2 our only > option? > Any information would be 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 [...]
28512 29 37_DB2 UDB: Is SMS or DMS better to use?9_J Steffan23_jsteffan_2000@YAHOO.COM30_Thu, 6 Jan 2000 13:00:10 -0800351_us-ascii I'm fairly new to DB2 UDB and am undecided on weather it's better to go with SMS or DMS. I understand the differences between the two, but I'd like to know how they shake out in real life!
I'm running in a Windows NT and Solaris environment and I figure one or the other must be better from a support and reliability perspective. [...]
28542 13 21_Re: DB2 Communication12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Thu, 6 Jan 2000 15:19:41 -0600336_us-ascii Data Sharing is not an option for us right now. We have to use what we have in place.
================================================ 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.
28556 46 14_drda questions14_Marg Gozdowski27_marg.gozdowski@LA-Z-BOY.COM30_Thu, 6 Jan 2000 16:29:34 -0500536_iso-8859-1 I have been working with a couple of contract people for the last couple of months on trying to set up drda. Right now, it looks like we are connecting to the mainframe using the odbc driver only - is this possible? Since we have not been able to find any good doc on what is needed to set up the mainframe security, we have been granting more security than is needed (possibly) just to get it running on a test lpar system. I was wondering if anyone on the list would possibly know the answer to the following question [...]
28603 19 21_Re: DB2 Communication12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 6 Jan 2000 13:37:28 -0800312_us-ascii TCP/IP is a fairly obvious alternative to SNA, then if you don't use Data Sharing, and you're running at least DB2 V5 and OS/390 V2R5 (for the performance, V2R4 is ok, V1R3 is only for light work).
You didn't say why you want an alternative. There are non-DB2 types of connections, like MQ. [...]
28623 69 35_Question about faroffpos - extn....0_16_acaldwe2@CSC.COM30_Fri, 7 Jan 2000 08:54:54 +1000390_us-ascii Neil,
As others have already said, FAROFFPOS and NEAROFFPOS relate to the degree of correct clustering sequence in your base data - not non-clustering index entries.
For the 'health of the index', checkout the LEAFDIST column. This give a value indicating the sequence of the index entries for the order of the index columns. (see Admin guide for more details). [...]
28693 13 21_Re: DB2 Communication12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Thu, 6 Jan 2000 15:54:03 -0600403_us-ascii We are trying to determine what would be the fastest. MQ was mentioned and if nothing else is avaliable MQ will be it. We are running DB2 V5 OS/390 5.2.
================================================ 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.
28707 32 26_Looking for DB2 Connect PE17_KUSTERS, ED (TAO)30_ED.KUSTERS.tao@CCRA-ADRC.GC.CA30_Thu, 6 Jan 2000 16:54:00 -0500489_- Date: Thursday, 6 January 2000 4:54pm ET To: db2-l@ryci.com From: KUSTERS.ED@RCT Subject: Looking for DB2 Connect PE
try: http://www.ibm.com/software/data/db2/udb/downloads.html --------------------------( Forwarded letter 1 follows )--------------------- Date: Thursday January 06, 2000 10:28:12 AM To: DB2-L@RYCI.COM From: owner-db2-l@RYCI.COM Subject: Looking for DB2 Connect PE
Does anyone know where to obtain a copy of DB2 Connect Personal Edition on the web??? [...]
28740 12 37_Connecting UDB 390 to UDB OS2 Servers11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Thu, 6 Jan 2000 15:57:39 -0600277_us-ascii How can it be done!... : )
================================================ 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.
28753 36 21_Re: DB2 Communication14_Philip Gunning20_pgunning@BOSCOVS.COM30_Thu, 6 Jan 2000 17:17:56 -0500317_us-ascii A faster option than MQ is a client using Db2 connect calling cics program via EXCI. It's about twice as fast as MQ. Not sure what you are trying to do though. HTH Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner [...]
28790 173 21_Re: Disaster Recovery14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Fri, 7 Jan 2000 09:36:42 +1000606_us-ascii Leslie,
BMC's Copy Plus has a multi-tasking option. I've never used it, but according to the manual when each task finishes copying a space it starts on the next space to be copied. Hence, with a tape to each task the balancing will be done automatically.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 james.campbell@energyis.com.au -----Original Message----- From: Leslie Pendlebury-Bowe [mailto:Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP] Sent: Thursday, January 06, 2000 5:48 PM To: DB2-L@RYCI.COM Subject: Re: Disaster Recovery [...]
28964 147 34_Re: Using time stamp - Performance14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU30_Fri, 7 Jan 2000 09:41:04 +1100360_iso-8859-1 Sibimon,
You are correct, because the calculation does not involve any table columns (ie. non-column expression); it will be calculated once only. The same applies to the second example provided by Michael Hannan (this is why they are both stage 1 and indexable in V5 & pre-V5 respectively).
Regards, Terry Purcell CPT Consulting [...]
29112 23 24_DB2 PM and authasn (0C4)14_Masone, Franco24_F.Masone@CEDACRIOVEST.IT30_Thu, 6 Jan 2000 23:51:20 +0100370_- Hi to all, perhaps a stupid question, but I am involved in a DB2 PM test without being a Db2 expert...
Trying to activate the TCP interface for DB2 Pm on OS390 2.7 I get a sad 0C4 abend. Db2PM is looking for an "authasn" address space. No info on program directory or IBM-LINK, I think these are new parameters. Db2PM works ok without TCP/IP activation .. [...]
29136 112 33_Re: Load Errors using VARCHAR Col14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Fri, 7 Jan 2000 09:52:39 +1000502_us-ascii Ken,
if you are still having problems after reading the other responses, please post a hex dump of the the first record. (eg, an IDCAMS "PRINT INFILE(..) DUMP COUNT(1)".)
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 james.campbell@energyis.com.au -----Original Message----- From: Ken Liberty [mailto:KLiberty@CONSULTEC-INC.COM] Sent: Thursday, January 06, 2000 11:00 PM To: DB2-L@RYCI.COM Subject: Load Errors using VARCHAR Col [...]
29249 185 30_Re: Looking for DB2 Connect PE22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Thu, 6 Jan 2000 17:57:08 -0500497_iso-8859-1 As others have said, DB2 Connect Personal Edition is available at > http://www.ibm.com/software/data/db2/udb/downloads.html as part of DB2 Personal Developer's Edition.
If DB2 Personal Developer's Edition is too large to download, then you can purchase the CD-ROM as explained below.
Thanks
Dear DB2 Interested Parties,
As a follow-up to my note to you (below) regarding the complimentary copy of DB2 UDB Personal Developer Edition V6.1 via download... [...]
29435 23 24_Wrap QMF detail Question15_Mallett, Steven38_Steven.Mallett@CORPMAIL.TELSTRA.COM.AU30_Fri, 7 Jan 2000 09:52:46 +1100294_- > Happy Y2K everyone, > > I can't find a QMF Discussion group so could I ask on this listserver if > anyone knows how to wrap QMF output lines greater than 150 characters wide > onto multiple report lines ? > We are a Mainframe site running OS/390, DB2 5.1 and QMF version 3 release 3.0 [...]
29459 50 28_Re: Wrap QMF detail Question14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Fri, 7 Jan 2000 10:13:46 +1000508_us-ascii Steve,
Use the "Line wrapping width?" option in the FORMS.OPTION panel. Use the command "SH F.OP" to display it, and "SH F.M" to go back to the normal formatting panel.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 james.campbell@energyis.com.au -----Original Message----- From: Mallett, Steven [mailto:Steven.Mallett@CORPMAIL.TELSTRA.COM.AU] Sent: Friday, January 07, 2000 8:53 AM To: DB2-L@RYCI.COM Subject: Wrap QMF detail Question [...]
29510 16 29_Cretification courses in DB2.18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM30_Thu, 6 Jan 2000 18:22:47 -0500416_us-ascii Can somebody tell me reagrding certfication in DB2? Are there any exams for a Certified DB2 DBA or a System Admin? Where can I find these info??
Thanks Kartik
================================================ 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.
29527 65 28_Re: Wrap QMF detail Question15_Mallett, Steven38_Steven.Mallett@CORPMAIL.TELSTRA.COM.AU30_Fri, 7 Jan 2000 10:36:59 +1100633_- Thankyou James, that was the answer to our problem.
regards, Steve
> -----Original Message----- > From: Campbell James [SMTP:James.Campbell@ENERGYIS.COM.AU] > Sent: Friday, 7 January 2000 11:14 am > To: DB2-L@RYCI.COM > Subject: Re: Wrap QMF detail Question > > Steve, > > Use the "Line wrapping width?" option in the FORMS.OPTION panel. Use > the command "SH F.OP" to display it, and "SH F.M" to go back to the > normal formatting panel. > > /* standard disclaimer */ > James Campbell > DBA > Hansen Corporation, Doncaster > +61 3 9840 3864 > james.campbell@energyis.com.au > -----Original Message----- > From: [...]
29593 42 33_Re: Cretification courses in DB2.17_Linda F. Claussen18_lindafc@NETINS.NET30_Thu, 6 Jan 2000 18:36:36 -0600658_ISO-8859-1 You can find the information on the following web page:
http://www-4.ibm.com/software/data/db2/udb/db2cert.html
Cheers, Linda F. Claussen Claussen & Associates DB2 Consulting and Training lindafc@netins.net http://www.netins.net/showcase/lclaussen/ Phone: (319) 343-3216 Office: (319) 847-1985
---------- From: Kartik Subramanian To: DB2-L@RYCI.COM Subject: Cretification courses in DB2. Date: Thursday, January 06, 2000 5:22 PM
Can somebody tell me reagrding certfication in DB2? Are there any exams for a Certified DB2 DBA or a System Admin? Where can I find these info?? [...]
29636 30 17_SYSADM revokes...16_Charles Valentin15_VALENCH@AOL.COM28_Thu, 6 Jan 2000 19:40:41 EST615_us-ascii Hi Group, 01/06/00
We've been asked by our Auditors to clean up "obsolete" SYSADM's defined to DB2 (we have numerous sysadm id's). I seem to recall sometime ago there was a discussion on revoking these id's "without" causing a cascading effect on priviliges granted to id's. Can anyone refresh my memory on the procedure to do this? We have BMC Opertune product installed and I believe the idea is to grant install SYSADM to Userid being revoked, revoking sysadm from Userid and then removing install sysadm from said Userid. Am I missing anything? Opertune will allow me to add/remove install [...]
29667 58 21_Re: SYSADM revokes...14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Fri, 7 Jan 2000 11:51:27 +1000342_us-ascii Charles,
- create a new ZPARM which defines the userid as an install sysadm - restart db2 with the new ZPARM - revoke sysadm from the userid. Since the userid is still a sysadm (ie an install sysadm), there's no cascade revoke
You should switch to having a group-id as your sysadm id. Then this problem goes away. [...]
29726 91 41_Re: DB2 UDB: Is SMS or DMS better to use?0_29_Greg.Palgrave@BANKWEST.COM.AU30_Fri, 7 Jan 2000 08:50:42 +0800577_us-ascii Well, *it depends* ! :)
We use SMS for tables which are fairly static (low/no growth, mostly read only, very few updates) and which have low space requirements. We just have to set & forget.
We use DMS for high activity tables (insert/update/delete) and high space usage. We split the indexes out to their own DMS also. This lets us allocate for say, 12 months of data. We can add containers if & when required. DMS is pre-allocated space, so when the table grows, you don't get performance hits as the NT [...]
29818 58 16_Re: CDB software0_17_ttaylor@CHUBB.COM30_Thu, 6 Jan 2000 20:00:58 -0500688_us-ascii Andy
Our dba's use it with out any hitches. They say it's pretty ease to set up.
Tom
Andy Wheeler on 01/06/2000 02:49:37 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Thomas G Taylor/ChubbMail)
Subject: CDB software
Does anyone have experience with using CDB software (supercopy, automation, superreorg, rw-reorg). Any information will be gratefully appreciated. [...]
29877 19 51_Re: Inserting records in a table with VARCHAR(4096)13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Fri, 7 Jan 2000 10:18:20 +0530380_us-ascii I am actually trying to insert the same from Net.Data . See if it is thru cobol then there is no problem at all and I have host variables thru which I can insert. But thru Net.Data I have to pass them as host variables. And here I have to use Parameter markers "?" to pass the data . Now how to do this . this is my question . I have cornered the problem till here. [...]
29897 236 90_Re: Web site to hold user-developed tools?,was Automatic Deletion of Log Files in UDB v6.110_John Clark20_pak02449@PIXIE.CO.ZA30_Fri, 7 Jan 2000 00:59:49 +0530320_iso-8859-1 Hi all,
A months ago I wrote a REXX to interogate package token id's and received several requests for the code. I eventually put the code on our web site www.connection42.co.za under our IEFSHARE section. Unfortunatly as we do not as yet have an FTP site this means a bit of cutting and pasting. [...]
30134 110 31_Re: TCP/IP connection to OS/39012_MILLS,Robert26_robert.mills@DEWRSB.GOV.AU30_Fri, 7 Jan 2000 17:02:07 +1100392_iso-8859-1 Leon,
I understand what is happening now, our V5.2 connection is via the Enterprise Edition whereas I have been testing V6.1 through the Personal Edition which obviously doesn't include DB2 Connect support. The cause of the problem wasn't that obvious when the connection actually gets through to DDF, albeit in an unrecognised form, and UDB returns an empty sqlstate. [...]
30245 33 29_Re: Remote DB2 Administration15_Mallett, Steven38_Steven.Mallett@CORPMAIL.TELSTRA.COM.AU30_Fri, 7 Jan 2000 18:10:27 +1100540_- > Dear Listmembers, > > We are using DB2 Connect - Enterprise Edition, Version 5.2 on a Windows NT > Server (Terminal Server Edition) platform. The NT Server is acting as a > DB2 Gateway Server allowing DB2 CAE Version 5.2 Clients on a Windows NT > Workstation platform to access DB2 on an OS/390 platform. Is there a way > of administering DB2 connections on the Gateway Server from the Client > PCs? For example, can we remotely view the details of the DB2 instance on > the Gateway Server as we can from the Control Center on the [...]
30279 48 57_Re: Implications of running batch and online concurrently9_Jim Leask27_jim.leask@RS-COMPONENTS.COM30_Fri, 7 Jan 2000 08:02:30 -0000534_iso-8859-1 A few considerations:
Ensure your batch programs can correctly handle timeouts and deadlocks only failing when n contention problems are hit Ensure your batch programs take frequent commits (aim for a few seconds below your timeout value) Watch out for lock escalation Amend the batch programs so that no table locks are taken If v4 or above amend all indexes to type 2 if not already done Consider isolation UR for batch reports Only move to row locking for problematic tables, consider amending maxrows first [...]
30328 40 28_Re: Wrap QMF detail Question9_Jim Leask27_jim.leask@RS-COMPONENTS.COM30_Fri, 7 Jan 2000 08:15:15 -0000648_iso-8859-1 Enter QMFs FORM.MAIN screen amend the width of the column to desired value, say 60, and change the edit code to CW (character wrap).
Jim.
-----Original Message----- From: Mallett, Steven [mailto:Steven.Mallett@CORPMAIL.TELSTRA.COM.AU] Sent: 06 January 2000 22:53 To: DB2-L@RYCI.COM Subject: Wrap QMF detail Question
> Happy Y2K everyone, > > I can't find a QMF Discussion group so could I ask on this listserver if > anyone knows how to wrap QMF output lines greater than 150 characters wide > onto multiple report lines ? > We are a Mainframe site running OS/390, DB2 5.1 and QMF version 3 release 3.0 [...]
30369 78 57_Re: Implications of running batch and online concurrently11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM30_Fri, 7 Jan 2000 16:30:19 +0800314_us-ascii Hi,
Just to add in one more consideration: Ensure that your batch programs can be restart from the point of failure or checkpoint. If your batch programs read records from input file, you need to bypass those already processed records. Similarly, you need to take care of the output file too. [...]
30448 206 21_Re: Disaster Recovery22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 7 Jan 2000 09:01:28 +0000378_ISO-8859-1 James yep I am aware of this - I installed and configured multiple Copy Plus Options files at a previous site - and I used the muti-tasking then - as the site had 24 tape drives and used very small tapes we were able to get the backup time down from 10 hours a night to 40 Minutes .... it was all down to the configuration of BMC Copy Plus .. a win in my books. [...]
30655 46 43_Re: DB2 DATA SHARING DLI BATCH GROUP ATTACH11_Mike Turner29_Michael_Turner@COMPUSERVE.COM30_Fri, 7 Jan 2000 04:37:53 -0500514_ISO-8859-1 Chris
Don't you get problems with in-doubts with the IMS attach also? Both CICS and IMS attaches use two-phase commit protocol. I guess if only DB2 data is updated then there is no problem to manage, but if there are non-DB2 updates also (DL/1 or VSAM) then re-connect after failure to a different DB2 member would require that member to commit or rollback a thread from the original DB2 member. (If all I hear back is a muffled 'no comment' I will assume Roger has fitted you with a gag!). [...]
30702 31 92_Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB v6.112_Adam Flinton16_adam@SOFTFAB.COM30_Fri, 7 Jan 2000 11:43:02 +0100536_us-ascii On Thu, 6 Jan 2000 07:41:47 -0500, Seibert, Dave wrote:
>Hello Lynne, > I think that's an excellent idea. > >Think of the trouble this would have saved Herr Dr. Ebert and others who've >recently had to distribute things like this manually. And think of the >bandwidth it would save on this list from individuals who don't heed the >suggestion to write the distributor individually rather than post their >interest back for the entire list to read. > >I hope it happens this time around. >Thanks for offering again. [...]
30734 49 16_Re: CDB software0_19_mike.holmans@BT.COM30_Fri, 7 Jan 2000 12:12:48 -0000408_- We've been using CDB's SuperReorg product for several years, and we are very pleased with it. We use the automation facility a bit, but I don't think it actually buys us an awful lot, as it goes.
I find some of the parms counter-intuitive - some of them do the opposite of what I would have guessed by just looking at them - but a spot of the old RTFM usually does the trick on such occasions. [...]
30784 62 42_Re: Migrating from v5 to v4 and back again12_Sue Janowitz18_SJanowitz@NEFN.COM30_Fri, 7 Jan 2000 08:09:46 -0500261_us-ascii I'm the DB2 SYSADM at my company. I'm pretty sure we left the IEFSSN member the same when we went from V4 to V5 (it's over a year ago now, so my memory is a little fuzzy). I think the member name DSN3EPX changed from V3 to V4, only that one time. [...]
30847 60 33_Re: Cretification courses in DB2.11_Danny Davis16_DTDAVIS@PCMH.COM30_Fri, 7 Jan 2000 08:08:56 -0500277_US-ASCII I went to the web page and I didn't see anything related to OS/390. Are they still not offering any certification for DB2 Admin of OS/390 or is it nested into the current exams? I like the challenge of trying to pass the exams, but I have no experience with UDB. [...]
30908 18 43_Re: DB2 DATA SHARING DLI BATCH GROUP ATTACH0_24_Jodi.Murawski@MIDATA.COM30_Fri, 7 Jan 2000 07:56:08 -0600387_us-ascii Thanks to everyone who provided suggestions and information on the usermod that is available.
Jodi Murawski DBA M&I Data Services
================================================ 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.
30927 56 56_A strange behavior of DB2 when stopped. Any suggestion ?14_Massimo Scarpa16_mscarpa@CESVE.IT30_Fri, 7 Jan 2000 15:01:27 +0100377_us-ascii I wrote a mail some months ago where I explained this problem:
After a -STOP DB2 command you receive the message in SDSF log that is all is ok, DB2 is
stopped and if you try run a query, for instance, you obtain the messsage that DB2 is
not active.
But if you look at SDSF panel after a DA command to have a snapshot of all subsystems [...]
30984 65 33_Re: Cretification courses in DB2.9_Sally Mir16_smir@BCBS-GA.COM30_Fri, 7 Jan 2000 09:29:31 -0500
31050 91 33_Re: Cretification courses in DB2.22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 7 Jan 2000 14:40:44 +0000823_ISO-8859-1 ..no Db2 os390 stuff ..and there are no plans for it yet either ..
Les
______________________________ Reply Separator _________________________________ Subject: Re: Cretification courses in DB2. Author: Sally Mir at Internet Date: 1/7/00 9:29 AM
There is a web-based company that offers certification in many fields, for what it's worth. Check out www.brainbench.com Sally Mir
Danny Davis wrote:
I went to the web page and I didn't see anything related to OS/390. Are they still not offering any certification for DB2 Admin of OS/390 or is it nested into [...]
31142 30 60_FW: A strange behavior of DB2 when stopped. Any suggestion ?14_Massimo Scarpa16_mscarpa@CESVE.IT30_Fri, 7 Jan 2000 15:44:49 +0100319_us-ascii Sorry, I've forgotten to say that there's absolutely no activity on DB2 and so it's no waiting for
any terminating thread, as you can see at restart (inflight/indoubt/incommit/ inabort count = 0).
The shutdown is correct, as far as I can see from messages, at the end and at restart of DB2. [...]
31173 114 33_Re: Cretification courses in DB2.16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Fri, 7 Jan 2000 09:53:44 -0500505_us-ascii Hi, I did participate in survey from IBM last year(century) as to what should be in the certification for DB2/OS390. Have not heard anything on it yet. or when it will be available? Tom
Leslie Pendlebury-Bowe on 01/07/2000 09:40:44 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: Cretification courses in DB2. [...]
31288 24 22_Use of unqualified sql11_David Ayers24_david.ayers@HIGHMARK.COM30_Fri, 7 Jan 2000 10:03:08 -0500603_us-ascii Hello list. We have an application this is accessing both DB2 v5.1 OS/390 tables and Oracle tables within the same Cobol programs that reside on OS/390. The connection to the Oracle databases is from DataJoiner. Currently we are connection to the DataJoiner database passing a single userid/ password in the connect string. We are using this userid to resolve the schema names in the datajoiner catalog (nicknames). This is working fine, but we loose all accountability to the user who executes the app. Is there another way to pass a schema name to DataJoiner We looked at trying to bind [...]
31313 19 20_Unavailable Resource12_Mike O'Brien30_michael_obrien_48127@YAHOO.COM30_Fri, 7 Jan 2000 07:07:42 -0800602_us-ascii Anyone run into a problem where you get a unavailable resource accessing a stopped object in SPUFI, but the associated DSNT501I message does not appear on the console log. The object is in a Peoplesoft application. __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
31333 91 18_Re: drda questions15_Philip, Sibimon19_PhilipS@SEALAND.COM30_Fri, 7 Jan 2000 10:08:50 -0500342_iso-8859-1 We are also in the process of implementing DRDA. Since TCP/IP is not activated in DB2 (We are trying to do this soon), the connection from ODBC driver go through SNA. So you must be using TCP/IP or SNA to reach DDF from ODBC driver. Since we have not developed any application, right now we granting public access to package. [...]
31425 102 42_Re: Migrating from v5 to v4 and back again18_Andrade, Alexander25_alexander.andrade@CAI.COM30_Fri, 7 Jan 2000 15:18:24 -0000291_iso-8859-1 I know in the case of concurrency, the DSN3EPX must be the latest version. You can use the same SSID yes, as you will usually want the same for your prod environment eg DSNP. During testing you probably had both versions active at the same time with 2 different SSID's yes ? [...]
31528 234 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?22_Kennedy, Tom - Cendant23_Tom.Kennedy@CENDANT.COM30_Fri, 7 Jan 2000 10:21:45 -0500388_iso-8859-1 After you issue the -STO DB2 command, or just before if you like, issue a -DIS THREAD(*) command to see what connections are still active. You'll probably see your Boole started task still connected. If you're bringing DB2 down normally it will wait for all connections to terminate. If you don't manually stop the Boole started task it will prevent DB2 from coming down. [...]
31763 53 29_Re: Remote DB2 Administration13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Fri, 7 Jan 2000 09:24:34 -0600420_iso-8859-1 Using something like "pcANYWHERE" would allow you to sign onto the server remotely and basically do anything you could do if you were sitting at the server. Aside from that, you can also issue the list/force-applications commands remotely from a command-line processor prompt, but you need to attach to the server first using the "ATTACH" command ("DB2 ATTACH TO USER USING "). [...]
31817 134 42_Re: Migrating from v5 to v4 and back again17_Luke G. Bauerlein24_lbauerlein@MANDTBANK.COM30_Fri, 7 Jan 2000 10:30:15 -0500582_US-ASCII The problem was corrected by applying PTF UQ31543 to V4, yet another migration/fallback PTF ( I had to apply over 200 for migration). Shame on me for being at 9702 of DB2 V4. We don't place any DB2 modules in LPA. I don't have to change IEFSSNxx but V5 must be the version of "early code" SDSNEXIT modules that are executed at subsystem startup time thus an IPL is required. SETSSI MVS command will not work with this particular subsystem , I tried (BOO HOO). Thanks for the responses. Finding this professional listserver was a godsend. Luke >>> "Andrade, Alexander" [...]
31952 25 43_DB2 UDB and Solaris 7 Operating Environment11_Kurt Rompot21_RompotK@SCHNEIDER.COM30_Fri, 7 Jan 2000 09:34:07 -0600420_us-ascii We are preparing to upgrade to Sun Solaris 7 Operating Environment. Does anyone know of any issues with the use of DB2 UDB on Sun Solaris 7? Any there any required Solaris patches?
Specifically, we are interested in the use of DB2 Connect Enterprise Edition on Sun Solaris 7.
Thanks.
-------------------- Kurt Rompot DB2 Database Analyst Schneider National, Inc. rompotk@schneider.com [...]
31978 129 16_Re: Access Paths14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 7 Jan 2000 09:34:53 -0600439_ISO-8859-1 Anand and Deepak:
One other thing to add: if you are using DB2 V6, IBM has added optimizer "hints." Using this method of changing the access path, you point DB2 at an old access path in a PLAN_TABLE. So, if an access path changes to one that is less desirable than a previous access path, simply rebind and point to the old PLAN_TABLE rows to tell the optimizer the access path to use (using the OPTHINT parameter). [...]
32108 31 32_Automated statistics replication13_Horton, Libby20_Libby_Horton@BMC.COM30_Fri, 7 Jan 2000 09:44:40 -0600407_ISO-8859-1 Hello, Recently there was a question about statistics propagation. Here is some information from one of our support representatives:
BMC has a product called PATROL SQL-EXPLORER which has the functionality to migrate statistics from DB2 to DB2. It can also migrate BMCSTATS to the DB2 Catalog. This will be available in the 3.1.01 ISPF version which is due to go GA in February 2000. [...]
32140 22 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?0_22_Bob_Pingston@AMWAY.COM30_Fri, 7 Jan 2000 11:13:33 -0500329_us-ascii Max,
A possiblity is that your subsystem swapped out on shut down. If you have MVS Omegamon, try swapping the tasks in to see if the terminate noramlly. I would do DB2xDIST, DB2xDBM1, then DB2xMSTR. If this works, you need to talk to your MVS people about the performance settings of your DB2 address spaces [...]
32163 52 36_Re: Automated statistics replication16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM30_Fri, 7 Jan 2000 11:08:15 -0500442_iso-8859-1 Hi
I thought I may put my two cents in here as well.
Compuware's DBA tool, called DBA-XPERT, has the capability to move DB2 runstats statistics from one DB2 sub-system/database/etc. to another. This capability is build within the product.
Robert Galambos robert_galambos@compuware.com
Compuware Corp. Of Canada 1-905-803-8600 1-800-348-8299 (Canada & US) 1-905-803-8603 (fax) 1-800-447-1662 (Quebec)
32216 86 33_Re: Cretification courses in DB2.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 7 Jan 2000 10:59:57 -0600625_iso-8859-1 Danny, Re: OS/390 DB2 Certification. I need the person with a SHK degree that has excelled.
HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this [...]
32303 55 28_Re: Wrap QMF detail Question13_Chie, Jim (C)17_chiej@CONNEXT.COM30_Fri, 7 Jan 2000 09:15:21 -0800438_iso-8859-1 Or try edit code CT for breaks on word boundaries. Say, this product can be pretty slick.
-----Original Message----- From: Jim Leask [mailto:jim.leask@RS-COMPONENTS.COM] Sent: Friday, January 07, 2000 12:15 AM To: DB2-L@RYCI.COM Subject: Re: Wrap QMF detail Question
Enter QMFs FORM.MAIN screen amend the width of the column to desired value, say 60, and change the edit code to CW (character wrap). [...]
32359 134 33_Re: Cretification courses in DB2.22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 7 Jan 2000 17:21:28 +0000447_ISO-8859-1 I received a mail from them last week saying they have no plans for an os390 db2 cert exam .. I was pestering them all last year about it.... their loss .. not ours - as I know I can do my job :-)
Les
______________________________ Reply Separator _________________________________ Subject: Re: Cretification courses in DB2. Author: "Thomas E. Faglon" at Internet Date: 1/7/00 9:53 AM [...]
32494 100 33_Re: Cretification courses in DB2.0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 7 Jan 2000 11:36:55 -0600435_us-ascii My loss too!
There is still lots of my job for me to learn and know better. When I asked this question about this time last year the answer was "... not yet but some time (soon) in the future ...". I am disappointed to hear that they don't plan to have a OS/390 course. As I understand it, even in V6 there are still significant feature and functionality differences between UDB on OS/390 and the other platforms. [...]
32595 129 33_Re: Cretification courses in DB2.23_AITHA, BHEEMSEN (SBCSI)23_B4AITHA@MSG.PACBELL.COM30_Fri, 7 Jan 2000 09:42:45 -0800659_iso-8859-1 My loss too.
Bheem Aitha
-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Friday, January 07, 2000 9:37 AM To: DB2-L@RYCI.COM Subject: Re: Cretification courses in DB2.
My loss too!
There is still lots of my job for me to learn and know better. When I asked this question about this time last year the answer was "... not yet but some time (soon) in the future ...". I am disappointed to hear that they don't plan to have a OS/390 course. As I understand it, even in V6 there are still significant feature and functionality differences between UDB on OS/390 and [...]
32725 154 33_Re: Cretification courses in DB2.22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Fri, 7 Jan 2000 13:16:10 -0500660_iso-8859-1 IBM -
Please reconsider and offer a DB2 UDB for OS/390 certification program. Does anyone know why IBM decided against a certification program for DB2 UDB for OS/390?
> ---------- > From: AITHA, BHEEMSEN (SBCSI)[SMTP:B4AITHA@MSG.PACBELL.COM] > Sent: Friday, January 07, 2000 12:42 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Cretification courses in DB2. > > My loss too. > > Bheem Aitha > > -----Original Message----- > From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] > Sent: Friday, January 07, 2000 9:37 AM > To: DB2-L@RYCI.COM > Subject: Re: Cretification courses in DB2. > > > My loss too! > > There is still [...]
32880 169 33_Re: Cretification courses in DB2.13_Chie, Jim (C)17_chiej@CONNEXT.COM30_Fri, 7 Jan 2000 10:25:51 -0800467_iso-8859-1 is being cretified anything like having a lobotomy?
-----Original Message----- From: Piontkowski Michael ML [mailto:michael.piontkowski@ASTRAZENECA.COM] Sent: Friday, January 07, 2000 10:16 AM To: DB2-L@RYCI.COM Subject: Re: Cretification courses in DB2.
IBM -
Please reconsider and offer a DB2 UDB for OS/390 certification program. Does anyone know why IBM decided against a certification program for DB2 UDB for OS/390? [...]
33050 173 33_Re: Cretification courses in DB2.13_Fisher, Larry19_LFISHER@INTEGON.COM30_Fri, 7 Jan 2000 13:27:14 -0500334_iso-8859-1 I think IBM feels that the DB2 DBA's and Sys Admin's on OS/390 are capable, diligent, and careful while the PC group needs something to separate the wheat from the chaff and in this case it's a certificate. I am assuming that " Cretification " is just a misspelling of certification; if not then I retract this reply. [...]
33224 196 33_Re: Cretification courses in DB2.11_Eric Robida22_Eric_Robida@BCBSME.COM30_Fri, 7 Jan 2000 13:32:28 -0500566_us-ascii I thought it was the first step to becoming a member of management.
"Chie Jim (C)" on 01/07/2000 01:25:51 PM
To: DB2-L@RYCI.COM cc: (bcc: Eric Robida/BCBSME) Subject: Re: Cretification courses in DB2.
is being cretified anything like having a lobotomy?
-----Original Message----- From: Piontkowski Michael ML [mailto:michael.piontkowski@ASTRAZENECA.COM] Sent: Friday, January 07, 2000 10:16 AM To: DB2-L@RYCI.COM Subject: Re: Cretification courses in DB2. [...]
33421 180 33_Re: Cretification courses in DB2.22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 7 Jan 2000 18:50:31 +0000612_ISO-8859-1 Hi
not that they will not do it .. but that they have no plans ...
like all things this can change - see my previous post.
regards
Leslie
______________________________ Reply Separator _________________________________ Subject: Re: Cretification courses in DB2. Author: Piontkowski Michael ML at Internet Date: 1/7/00 1:16 PM
IBM -
Please reconsider and offer a DB2 UDB for OS/390 certification program. Does anyone know why IBM decided against a certification program for DB2 UDB for OS/390? [...]
33602 140 33_Re: Cretification courses in DB2.22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 7 Jan 2000 18:49:37 +0000264_ISO-8859-1 ...and mine ..
I asked the questions several times direct to them last year .. and I received the reply below a week ago .. I told them that the cert for os390 db2 should be a high priority and out there now .. this is their reply to me ... [...]
33743 164 33_Re: Cretification courses in DB2.0_19_rbarbour@HUMANA.COM30_Fri, 7 Jan 2000 14:05:17 -0500376_us-ascii You were right to mention marketing. I never believed there would be certification on OS/390 simply because the market is not requiring it. In order to compete in the client/server world IBM has to offer certification just like Microsoft, Oracle, SAP, Powerbuilder, etc.., or be the only major player who doesn't. In the mainframe world, no such presure exists. [...]
33908 46 39_DB2 DATA SHARING DLI BATCH GROUP ATTACH0_18_cmunson@US.IBM.COM30_Fri, 7 Jan 2000 12:03:03 -0700570_us-ascii Mike, While it is true that CICS and IMS use 2 phase commit, DL/I batch really doesn't. It currently uses the same protocol but one of the main differences is that DB2 is the coordinator. Furthermore with DL/I batch there is no coordination with VSAM (or any other resources like MQ). In this scenario the coordination with IMS updates is a little more complicated. As you know the definition of an in-doubt is an agent failure between phase 1 and phase 2 commit. Since we are the coordinator we really can't be in-doubt because we know what the answer is [...]
33955 211 33_Re: Cretification courses in DB2.15_Rameswara Pavan24_RPAVAN@ISETS.STATE.IN.US30_Fri, 7 Jan 2000 14:21:09 -0500412_us-ascii Though certification is a marketing issue to IBM, I was thinking it is a best preparation to learn things which you have never faced in your past experience and to test your self for improvement. Pavan
-----Original Message----- From: rbarbour@HUMANA.COM [SMTP:rbarbour@HUMANA.COM] Sent: Friday, January 07, 2000 2:05 PM To: DB2-L@RYCI.COM Subject: Re: Cretification courses in DB2. [...]
34167 55 31_CLOB simulation (V5): page size14_Ulf-Otto Cihak23_UlfCihak@COMPUSERVE.COM30_Fri, 7 Jan 2000 14:37:48 -0500626_ISO-8859-1 Dear all, we have to store documents (approx. 60K on average, varying considerably) in DB2/OS390 V5. The application sees one document as one big chunk, so it has no DB2-known structure. Since trailing blanks may be important, we will store the documents in VARCHAR (not fix length CHAR + compression). Nevertheless, we will use DB2 compression for this tablespace. To store/retrieve one document to/from DB2, we need a segmentation layer between the application and DB2. I see the following alternatives: - segment into 4K blocks, and use a 4KB tablespace - segment into 32K blocks, and use a 32KB tablespace [...]
34223 25 35_Re: Certification in DB2 for OS/39012_Roger Miller19_millerrl@US.IBM.COM30_Fri, 7 Jan 2000 11:55:29 -0800504_us-ascii You asked why we don't have certification on DB2 for OS/390, and the essence of the problem is one of resources and priorities. This is not a case of blacks and whites, but more one where the need is much more dramatic on the Windows and Unix platforms. The question that is asked more than any other at the certification class is, "What about DB2 for OS/390?" The most concrete example I have heard for the need is that some government workers can be paid more if they have a certificate. [...]
34249 42 35_Re: Certification in DB2 for OS/39011_Danny Davis16_DTDAVIS@PCMH.COM30_Fri, 7 Jan 2000 15:33:11 -0500621_US-ASCII Roger, The need you cited for OS/390 is obviously not a good one. Just curious, what are the 'needs' on Windows and Unix that are driving certification other than the realistic reason someone quoted before, that all the other server based databases have it.
>>> Roger Miller 01/07/00 02:55PM >>> You asked why we don't have certification on DB2 for OS/390, and the essence of the problem is one of resources and priorities. This is not a case of blacks and whites, but more one where the need is much more dramatic on the Windows and Unix platforms. The [...]
34292 99 35_Re: CLOB simulation (V5): page size15_Blaicher, Chris22_Chris_Blaicher@BMC.COM30_Fri, 7 Jan 2000 14:55:49 -0600308_ISO-8859-1 If I was doing it I would use 32K pages and using the intermediate layer, break the CLOB into 4K or 8K chunks. I would also use DB2 compression.
Here is my reasoning.
1) You have to use the intermediate layer because there is no table type that supports a page longer than 32K. [...]
34392 39 33_Re: Cretification courses in DB2.10_Marc Baime23_mbaime1@TAMPABAY.RR.COM30_Fri, 7 Jan 2000 15:50:07 -0500661_iso-8859-1 Certification is considered important in the client-server world. Almost all the companies that provide software and hardware in that world have certification programs. It stratev with Novell certifications, then Microsoft engineer certifications, and now certifications for all the Database management systems and other types of system software. If you're a manager doing hiring and you are not knowledgeable in the particular technical area you're hiring in and you have no one who is able to give a good technical interview in that area then a good certification program (like Oracle's or IBM's program) goes a long way towards providing you [...]
34432 20 35_DB2 Visual Explain, Statement Table11_GOSE PAUL M17_pmgose@SRPNET.COM30_Fri, 7 Jan 2000 13:49:28 -0700322_ISO-8859-1 I've recently began use of Visual Explain and I am getting abends when I process plan table entries and I have a statement table present. I suspect the problem may have something to do with the way I've defined the statement table. Can anyone provide DDL for a proven statement table (DSN_STATEMNT_TABLE)? [...]
34453 28 30_SMF - CPU time, Plan, and User0_22_BILL_GALLAGHER@PHL.COM30_Fri, 7 Jan 2000 16:00:06 -0500283_us-ascii I've been asked by my management to produce a file of raw SMF data for one of our lines of business. In particular, we are looking for DB2 CPU time. I believe this is in the 101 Accounting record, but I really don;t have much experience with dealing with raw SMF data. [...]
34482 71 35_Re: Certification in DB2 for OS/39019_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 7 Jan 2000 14:59:30 -0600410_iso-8859-1 Thought OS/390 DB2 was a "server" of data before there were any "server-based" DBMs. OS/390 DB2 is becoming, more and more, "the server of choice" for many applications across the entire gamut of businesses. Reliability, scalability, and speed of recovery come immediately to mind. Don't look now, but not a single person working directly with OS/390 DB2 has a OS/390 DB2 certification either. [...]
34554 57 34_Re: SMF - CPU time, Plan, and User20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 7 Jan 2000 16:14:20 -0500387_- Bill
You have to have class 2 accounting trace on, in order to get in-DB2 CPU time. The TCB time has format of TOD clock of MVS and in available via DSNDQWAC. The PLAN name, User name is available in production section of SMF 101 type records. The macro to map this is DSNDQWHS (Standard header contains IFCID and RMID), DSNDQWHC (Correlated header contains plan name etc. [...]
34612 88 33_Re: Cretification courses in DB2.11_John Wynton21_jwynton@THEMISINC.COM30_Fri, 7 Jan 2000 16:18:48 -0500347_iso-8859-1 First, I have a vested interest as we do DB2 and UDB training.
I'm ambivalent about certification in general. There are pro's and con's. Certainly taking training then passing the exams gives you a fair idea (at least theoretically) of the attributes of the software in question be it database or network related (i.e. NT). [...]
34701 14 39_Re: DB2 Visual Explain, Statement Table12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 7 Jan 2000 13:47:31 -0800319_us-ascii How about the one in member DSNTESC of SDSNSAMP?
Roger Miller
================================================ 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.
34716 309 31_Re: TCP/IP connection to OS/39016_Swinski, Kenneth32_KSwinski@INTERNAL.MASSMUTUAL.COM30_Fri, 7 Jan 2000 17:13:59 -0500612_us-ascii Could I manually configure an OS/390 connection using the Client Configuration Assistant in the CAE distributed with UDB for AIX? We filled in the hostname and port number as defined in OS/390 VTAM and TCP/IP but have been getting errors at the workstation.
> -----Original Message----- > From: leon@CA.IBM.COM [SMTP:leon@CA.IBM.COM] > Sent: Thursday, January 06, 2000 12:33 AM > To: DB2-L@RYCI.COM > Subject: Re: TCP/IP connection to OS/390 > > The only way you will have an option that says "MVS/ESA, or OS/390, or > AS/400" on the DB2 CCA screen is if you have DB2 Connect product or DB2 [...]
35026 45 43_Re: DB2 DATA SHARING DLI BATCH GROUP ATTACH11_Mike Turner29_Michael_Turner@COMPUSERVE.COM30_Fri, 7 Jan 2000 17:22:18 -0500704_ISO-8859-1 Chris
Thanks for the informative feedback. Not at all vague!
Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner
Message text written by DB2 Data Base Discussion List >Mike, While it is true that CICS and IMS use 2 phase commit, DL/I batch really doesn't. It currently uses the same protocol but one of the main differences is that DB2 is the coordinator. Furthermore with DL/I batch there is no coordination with VSAM (or any other resources like MQ). In this scenario the coordination with IMS updates is a little more complicated. As you know the definition of an in-doubt is [...]
35072 39 0_14_subrata mondal25_subratamondal@HOTMAIL.COM28_Fri, 7 Jan 2000 22:28:21 GMT378_- Guru's.,
1. I have a column in the databse that is Identity column. This identity column can generate sequential number for every new record entered. This is a feature that exist with the table.
2. I am accessing the identity column thru a PB( Power Builder application).
3. The power builder application is not able to handle the Identity property. [...]
35112 350 31_Re: TCP/IP connection to OS/3900_15_leon@CA.IBM.COM30_Fri, 7 Jan 2000 17:38:42 -0500388_us-ascii The reason you are getting errors is because DB2 CAE neither has the capability nor is licensed for direct connectivity to the host or AS/400 databases. DB2 Connect Personal Edition is the product that provides direct connectivity from your desktop systems to S/390 and AS/400 database servers.
Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com [...]
35463 153 33_Re: Cretification courses in DB2.12_Hylton Tom P23_Tom.P.Hylton@M1.IRS.GOV30_Fri, 7 Jan 2000 17:33:46 -0500372_iso-8859-1 Not wanting to argue, but what exactly does a paper certificate give you that you can't get now? You seem to imply that since there is no certification program then there are no classes and you are being excluded from learning about anything OS/390 related.
A simple click to this link: http://www-3.ibm.com/services/learning/roadmaps/db2osidx.html [...]
35617 113 33_Re: Cretification courses in DB2.0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 7 Jan 2000 17:07:48 -0600530_us-ascii I agree with most of what you say John, and the main reason I'm looking for certification IS the training. Unless you are in the consulting business, certification itself doesn't help. On the other hand, my job (and manager) just won't let me take an hour or two a day to work thru a CBT or other form of self paced, self help training. The main reason I'm on this list is because I consider it as a form of training, looking over other peoples shoulders as they work thru real world problems. Maybe 1 in 10 or 1 in [...]
35731 159 33_Re: Certification courses in DB2.24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Fri, 7 Jan 2000 16:14:10 -0800604_iso-8859-1 Interesting discussion on certification. Seems like the group is about evenly split. I'd like to add just one more voice to this, and hopefully I'm not just rehashing what someone else has already said.
I'd like to see certification for just one reason, i.e., it involves a comprehensive test of DB2 knowledge. The results of that test will provide valuable feedback that I can then use to improve my knowledge of DB2 in areas where I'm lacking. If necessary, those results can be shown to my management in order to justify additional training, and to document skills improvement. [...]
35891 18 43_Gateway Product for Adabase Natural and DB210_Ravi Verma26_ravi.verma@TELECOMMAND.COM30_Fri, 7 Jan 2000 16:57:03 -0800381_iso-8859-1 Does any one of a gateway product which allows data exchange between Adabase Natural and DB2.
Regards.
Ravi Verma.
================================================ 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.
35910 34 47_Re: Gateway Product for Adabase Natural and DB224_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM30_Fri, 7 Jan 2000 20:23:09 -0500343_- I believe SAGA has a "Natural for DB2" product. Predict can also be used in some capacity to manage DB2, but I have been told it isn't pretty. Our shop is both ADABAS/Natural and DB2, but we have not attempted to interface, ...yet.
Try looking at http://www3.sagasoftware.com/site/sagahome.htm Run a search on "DB2 and Natural". [...]
35945 30 65_DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.11_Linda Smith22_linda_home@HOTMAIL.COM30_Fri, 7 Jan 2000 20:32:43 -0600499_- HI, I have more than 325 tablespaces in one of the production database. I want to group all the tablespaces, indexspaces based on their access, into different Buffer pools.
How do i get the following information for all tablespaces and indexes.
a) Sequential accessed mostly( Large & small working sets) Tablespaces and indexes b) Randomly accessed mostly (Large & small working sets) Tablespaces and Indexes c) Finding the no of buffers needed for each tablespace and indexes. [...]
35976 76 69_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 7 Jan 2000 21:54:52 -0500559_ISO-8859-1 Message text written by DB2 Data Base Discussion List >I have more than 325 tablespaces in one of the production database. I want to group all the tablespaces, indexspaces based on their access, into different Buffer pools.
How do i get the following information for all tablespaces and indexes.
a) Sequential accessed mostly( Large & small working sets) Tablespaces and indexes b) Randomly accessed mostly (Large & small working sets) Tablespaces and Indexes c) Finding the no of buffers needed for each tablespace and indexes. [...]
36053 20 34_Re: SMF - CPU time, Plan, and User13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Sat, 8 Jan 2000 08:28:31 +0530314_us-ascii hi !!
Ya it is possible to obtain information about CPU , plan and user from SMF 101. about DB2. Just look at the DSECTS available which are given by IBM. These have to be used and mapped to the records from SMF. You will find variables in the DSECTS which will give you a lot of information. [...]
36074 16 33_Re: Cretification courses in DB2.13_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM30_Sat, 8 Jan 2000 08:30:57 +0530336_us-ascii No
No Certification Test is for DB2 V5, but available for DB2 V6
Mayank
================================================ 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.
36091 43 43_Where in your IS organization are the DBAs?15_Lynette Roberts21_llroberts@KSCABLE.COM30_Fri, 7 Jan 2000 20:58:53 -0600361_- Our company is currently thinking about doing some realignment within Information Systems. Management is having a difficult time deciding on where the DBAs should "fit" into the reporting structure, and has asked us to see where other companies have put the DBA staff.
What we would like to know: 1. What databases/platforms do your DBAs support? [...]
36135 50 34_Re: SMF - CPU time, Plan, and User14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 7 Jan 2000 22:08:31 -0500856_ISO-8859-1 Bill, The batch reporting side of whatever online monitor you have can probably do this for you quite easily. One caveat may the be the cost of processing all the 101 records which depends on the size/volume of your applications - how many actg records you produce per day. Regards, Joel |======================================================= | Joel Goldstein | Responsive Systems Company |======================================================= | WEB Site | www.responsivesystems.com |======================================================= | Buffer Pool Tool for DB2 & DASD/Xpert for DB2 | >>> The Answers for your performance problems <<< |------------------------------------------------------- | Tel.(800) DB2-EXPErt Tel.(800) 322-3973 | Tel.(732) 972-1261 Fax.(732) 972-9416 |======================================================= [...]
36186 28 69_Re: DB2-OS/390- Statistical Analysis of Tablespaces and Index spaces.13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Sat, 8 Jan 2000 08:40:31 +0530544_us-ascii Hi !!
First of all you have to write a toll which will read / scanthe catalog intelligently and generate a nice report / statistics for your analysis. This tool you have to write and then you will have to see if any access method is not fine.
It is always preferred that you allocate a lot of memory for BP0 and allow DB2 to manage the tablespaces. in it. But if you feel that you need special treatment for a specific tablespace , then do the requirement calculation, accordingy and allocated in another BP / BP32. [...]
36215 17 60_Re: A strange behavior of DB2 when stopped. Any suggestion ?13_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM30_Sat, 8 Jan 2000 08:54:41 +0530366_us-ascii Hi
I think problem is in your definition of System to vtam. Please Check your entry in Vtamlst
Mayank
================================================ 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.