1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2000, week 1
2 141 20_Re: index comparison15_TERENCE PURCELL27_terrypurcell@OZEMAIL.COM.AU30_Sun, 1 Oct 2000 18:29:07 +1000406_iso-8859-1 Venkat,
I'm glad you agree with Donna and I. If you read through both of our responses you will find we said the same thing. Donna was simply correcting my guess on the number of bytes overhead for each key (thanks Donna).
Terry -----Original Message----- From: Pillay, Venkat (PCA) Date: Saturday, 30 September 2000 00:58 Subject: Re: index comparison [...]
144 86 28_Repost: 3 New DB2 Benchmarks13_Morrill, John12_JohnM@VP.NET30_Sun, 1 Oct 2000 01:38:21 -0600694_- Dear DB2 Interested Parties,
Below are brief summaries of 3 recent record-setting benchmarks using DB2. For more information on this and other DB2 Benchmarks see http://www.ibm.com/software/data/db2/benchmarks
Regards, Mike * * *
IBM demonstrates scalability of DB2 UDB EEE on NUMA-Q using 300GB TPC-H Benchmark
On September 5, 2000, IBM published two 300GB TPC-H benchmarks using a 32 processor (8 quad) and a 48 processor (12 quad) configuration of it's next generation NUMA-Q 2000 system and DB2 Universal Database Version 7.1. These benchmark results, along with the record setting 64 processor (16 quad) result published on May 3, 2000, demonstrate that [...]
231 150 35_Re: DROP FOREIGN KEY in ALTER TABLE16_Bachi Allamsetty22_BachiA@RENEWAL-IIS.COM30_Sun, 1 Oct 2000 10:25:11 -0400474_iso-8859-1 Thanks James.....that is it.....quotes did the trick,
Thanks again.
Bachi
-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Saturday, September 30, 2000 10:54 PM To: DB2-L@RYCI.COM Subject: Re: DROP FOREIGN KEY in ALTER TABLE
Bachi
SECURITY is a reserved word. Put quotes (or whatever your SQL string delimiter is) around SECURITY. ALTER TABLE DROP FOREIGN KEY "SECURITY" [...]
382 57 19_DB2 and SMF records0_20_vpacheco@AMADEUS.NET30_Sun, 1 Oct 2000 16:44:31 +0200613_us-ascii Hello DB2 community
We are on the last phase of a Project that uses DB2 on OS/390 as Datastore for an application developed in C++ and running on the Unix System Services (USS). DB2 version is 5 and OS/390 version is 2.6.
The current stage is that the programs are concluded and we are performing Volume Testing. Because one of the programs is performing reasonably bad, we have been analyzing it deeply, using Omegamon Historical Reporter over the collected SMF records. Interestingly is that the DB2 component of the programs seem to be OK. Recently we have addressed some questions [...]
440 117 23_Re: DB2 and SMF records12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Sun, 1 Oct 2000 19:39:18 +0200561_iso-8859-1 Hi, While not searching deeply the SMF for USS usage (no problem with billing, yet) I've checked that using dynamic SQL cache gives us 20%-60% reuse. You can use Omegamon application trace to try to see what's going on your application (do it into a VSAM file and not to memory). We have C & PL1 & REXX programs on the USS calling DB2 on regular LPAR using either dynamic SQL or CAF but didn't notice any strange behavior like you mentioned. Preparation of the dynamic SQL costs you, authorization checks cost as well, a bigger BP0 may help. Do [...]
558 129 51_Re: Static Java Stored Procedure Timestamp Conflict17_Kevin Gottfredsen23_kgottfredsen@HUMANA.COM30_Sun, 1 Oct 2000 16:48:12 -0500406_- Hi Trupti,
Thanks for the reply...I tried to do as you stated, and received the following error:
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20204N The user defined function or procedure "SP_GETEMPLOYER" was unable to map to a single Java method. LINE NUMBER=7. SQLSTATE=46008 [...]
688 164 64_Re: DB2 Connect from Unix to DB2 OS/390, maybe WEBSPHERE on UNIX0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Sun, 1 Oct 2000 19:21:25 -0500605_us-ascii
Hi Jerry,
Thought I'd share our experience with you and it may be helpful in your research
When migrating to V6 we encountered a problem in our test environment with DB2 Connect and Stored Procedures.
What we learned is that for us its VERY VERY important that we are on the right version and fixpack for DB2 Connect & VAJ. What we ran into was a problem with VAJ (Visual Age Java) applications or JDK118 (Java Developers Kit) applications or even if we ported to an AIX test server, any process that would call a stored procedure on OS/390 environment. [...]
853 16 8_MQSERIES5_hsvak19_hsvak@AMERACASH.COM30_Sun, 1 Oct 2000 20:56:06 -0400357_us-ascii I would like to know where I can find sample mqseries programs written in cobol.
Regards, Alejandro
================================================ 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.
870 36 8_DSN1COPY10_Elsie Tama24_elsie.m.tama@VERIZON.COM30_Sun, 1 Oct 2000 20:53:04 -0400628_us-ascii Hi there,
I'm trying to test DSN1copy to see if we can use it to copy very large tables from production. However, I faced with the following error messages;
.DSN1992I VSAM PUT ERROR, RPLERREG = 008, RPLERRCD = 028 .DSN1993I DSN1COPY TERMINATED, 01410320 PAGES PROCESSED
There is not enough space on the DASD volume to allocate the extents needed. Also each extent tries to grab the primary allocation, not the secondary, making it more difficult to find the space needed. Please let me know what parameter,(or if there is any parameter that could be added to DSN1COPY that would allow [...]
907 96 12_Re: DSN1COPY12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Mon, 2 Oct 2000 12:33:17 +1100373_- Elsie, Yep this can be a problem. I think it's because DSN1COPY only knows about the volumes, that you would get back if you did a VSAM ListCat. What we did to get around the problem was to run the following IDCAMS step prior to running the DSN1COPY.
//******************************************************************
//* IDCAM IDCAMALT FOR DSN1COPY [...]
1004 35 38_Urgent help - problem after v5 upgrade25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG30_Mon, 2 Oct 2000 09:57:31 +0800371_us-ascii Hi,
After we cut over to db2 5.1 we are having problem with many of our indexes. We also upgraded the os to OS390 2.6 from 1.3. The index is having levelid problem indicating that type of index has been changed. I have done the following when upgrading
1. Updated the defixty in the zparm to 2 2. Run the catmaint to convert to type 2 [...]
1040 64 17_Re: DB2 Resources4_fred22_DB2@THERESOURCENET.COM30_Sun, 1 Oct 2000 22:22:03 -0500427_Windows-1252 For DB2 Resources, links to DB2 tool vendors, job opportunities, and recommended books, check out
http://TheResourceNet.com/db2.asp
For anyone who checked out this site before. It has been completely redesigned. (No more annoying flashing ad banners everywhere, its toned down a little) It does still require frame and script enabled browsers, which was a compliant I got. Let me know what you think.
1105 89 42_Re: Urgent help - problem after v5 upgrade14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Mon, 2 Oct 2000 14:08:04 +1100541_iso-8859-1 I can't see anything in the explanation for 00C2010D (or DSNB232I - which is referred to in the 00C2010D explation) which mentions the type of index.
DB2 keeps a record of when (actually the log RBA or LRSN) each cluster is updated in its directory and in the cluster. When DB2 opens a cluster it checks to see if these are the same. If not you get this error. There are two things you could have done to cause it - used a non-DB2 utility , or DSN1COPY without the RESET option, to recover an old version of the data. [...]
1195 66 12_Re: DSN1COPY11_Sinha, Amit19_Sinha.Amit@MBCO.COM30_Sun, 1 Oct 2000 22:50:28 -0500373_iso-8859-1 Elsie, You may be aware you WILL have to allocate the tablespace which you are trying to dsn1copy to big enough so that it's not in extents. What I mean is if your source tablespace is in extent you should define your target tablespace so that it's primary allocation will be the (priqty + (number of extent-1)*secqty). DSN1COPY does not copies in EXTENTS. [...]
1262 112 42_Re: Urgent help - problem after v5 upgrade9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Mon, 2 Oct 2000 08:30:23 +0100650_us-ascii II12123 - DB2 V4.1 MIGRATION/FALLBACK COEXISTENCE TO/FROM DB2 V5.1 mentions this code as follows..
"Customers are receiving following message/s under DB2 V5.1 against index/es that are built with BMC code under DB2 V4.1 - ABEND0C4 OR ABEND0C6 IN DSNKPOSI at various offsets if PQ03666 is not installed. - ABEND04E RC00C2010D DSNB1OPP with PQ03666 installed. - DSNT500I DSNB1OPP RESOURCE UNAVAILABLE 00C2010D TYPE 220. BMC used RID_length field of index header page within it's code. The length of this field is changed under DB2 V5.1. To resolve this problem customers had to run RECOVER INDEX under DB2 V5.1. Please call BMC to [...]
1375 159 12_Re: DSN1COPY0_18_mebert@AMADEUS.NET30_Mon, 2 Oct 2000 09:46:50 +0200578_us-ascii If the target tablespace is not big enough, DSN1COPY will allocate secondary extents in the normal OS/390 way. Of course, it will use the VSAM primary & secondary allocation values (which you can check using LISTCAT), not the DB2 ones which may be different.
Several weeks ago I used DSN1COPY to copy data from a production Imagecopy to a test tablespace for a performance test. I also got these odd VSAM PUT ERRORs (don't remember the error codes so I can't say whether it was exactly the same error). As it turned out, there were a couple of PTFs missing [...]
1535 160 34_DB2 Log Archiving ( Dual Logging )11_Mohamed Beg19_mohamedb@ABSA.CO.ZA30_Mon, 2 Oct 2000 11:16:56 +0200347_iso-8859-1 Hi
We've experienced problem with our logs archiving. We have dual logging at our site. If you look at the a copy of the logs below you will see that :
DB2's last active log filled up and DB2 switched to single mode logging but immediately after that said that the logs were full and was out of space in active logs. [...]
1696 30 11_Re: DSNTIAD17_William R. Miller32_william.miller@DRESDNER-BANK.COM30_Mon, 2 Oct 2000 04:39:40 -0500365_- Where is this documented? I tried using this parameter PARM('MAXERR(0)' on our v6 system and I got this error: DSNTIAD - SAMPLE DYNAMIC SQL PROGRAM 2.0 ERROR: INPUT PARAMETER 1 CONTAINS INVALID ARGUMENT
Parameters RC0 and SQLTERM(x) work fine!
-- Bill Miller
On Sat, 30 Sep 2000 13:32:38 -0500, Roger Miller wrote: [...]
1727 54 11_Re: DSNTIAD0_22_The-Thanh.Luong@AGF.BE30_Mon, 2 Oct 2000 11:54:35 +0200508_- DSNTEP2 is a PLI program, you need to change the value of MAXERRORS as you want, and recompile it. The source is coming in your SDSNSAMP library (we run DB2 V4). Regards,
LUONG The-Thanh
===== Disclaimer: opinions expressed are strictly my own, etc... =====
-----Original Message----- From: William R. Miller [mailto:william.miller@DRESDNER-BANK.COM] Sent: Monday, October 02, 2000 11:40 AM To: DB2-L@RYCI.COM Subject: Re: DSNTIAD [...]
1782 106 11_Re: DSNTIAD9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Mon, 2 Oct 2000 10:55:08 +0100433_us-ascii I think Roger may be referring to changing the source and re-assembling DSNTEP2 rather than passing a paramater the existing module.
The DSNTEP2 source (at V5 on our system) accepts 2 parameters and these are processed by PL1 SELECT statement..e.g.
SELECT (PARM1); /* @46*/ WHEN ('ALIGN(MID)') /*IF PARM 1 = ALIGN(MID) THEN @46*/ DO; /* @46*/ ALIGNLHS = NO; /* SET ALIGNMENT TO CENTER @46*/ END; /* @46*/ [...]
1889 37 12_Re: MQSERIES10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Mon, 2 Oct 2000 05:26:06 -0500475_- The sample pieces of COBOL code in the MQSeries Application Programming Guide, together with the MQSeries Application Programming Reference should give you enough information to code a program (I've just done it myself!). The manuals are available online at IBM's website:
http://www-4.ibm.com/software/ts/mqseries/library/manuals/
Be careful to use the 'SYNCPOINT' option correctly in each environment (Batch/CICS, etc.) to keep MQ/DB2 updates in Sync. [...]
1927 16 19_DB2 on NT Fixpaks!!13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Mon, 2 Oct 2000 16:49:43 +0530355_us-ascii hi !! can anybody tell be where I can download DB2 for NT v 5.2 fixpaks !! I want fixpak 10
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.
1944 41 23_SV: DB2 on NT Fixpaks!!0_19_Sven.Heidorn@CSN.SE30_Mon, 2 Oct 2000 13:32:47 +0200716_ISO-8859-1 Vishy,
try: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/download .d2w/report
Sven Heidorn
> -----Ursprungligt meddelande----- > Från: Viswanathan.N@POWAIMAIL.LTITL.COM > [SMTP:Viswanathan.N@POWAIMAIL.LTITL.COM] > Skickat: den 2 oktober 2000 13:24 > Till: DB2-L@RYCI.COM > Ämne: DB2 on NT Fixpaks!! > > hi !! > can anybody tell be where I can download DB2 for NT v 5.2 fixpaks !! > I want > fixpak 10 > > 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. [...]
1986 16 3_qmf6_teoman22_tkocer@HALKBANK.COM.TR30_Mon, 2 Oct 2000 14:30:53 +0300481_windows-1254 i am trying to connect another location from the qmf main panel i am issuing CONNECT TO command and when i press f4 i can not see the all locations including one i need.what else do i need before i connect thanks for your help
================================================ 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.
2003 85 38_FW: DB2 Log Archiving ( Dual Logging )19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 2 Oct 2000 07:20:23 -0500333_iso-8859-1 It appears my first attempt to send this may have failed . . . trying again . . .
MOHAMED, It appears that DB2 is not being allowed to Archive the Active Logs. DB2 will NOT write over an Active Log that is waiting to be Archived, it just waits and stops all activity until a successful Archive occurs. [...]
2089 115 42_Re: FW: DB2 Log Archiving ( Dual Logging )11_Mohamed Beg19_mohamedb@ABSA.CO.ZA30_Mon, 2 Oct 2000 14:42:29 +0200484_iso-8859-1 Hi Rick
It is my understanding that if you have dual logging DB2 will switch to single mode logging and overwrite one of the dual logs when all the active logs get full which it did not do in this instance.
I could be mistaken. ???
----- Original Message ----- From: DAVIS, RICK (SBCSI) Newsgroups: bit.listserv.db2-l To: Sent: 02 October 2000 02:20 Subject: FW: DB2 Log Archiving ( Dual Logging ) [...]
2205 125 42_Re: FW: DB2 Log Archiving ( Dual Logging )12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Mon, 2 Oct 2000 13:47:01 +0100459_iso-8859-1 DB2 will not write over an active log which has not been archived because it may need it for rollback or forward recovery. If I understand you correctly, you are asking why it doesn't switch to single logging mode and overwrite all the COPY1 datasets before failing, this is simply because it is defined to use dual logging and favours data integrity over the slight risk of switching to single logging (or the developers never considered it) [...]
2331 153 42_Re: FW: DB2 Log Archiving ( Dual Logging )12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Mon, 2 Oct 2000 13:53:14 +0100381_iso-8859-1 Now I see what you mean. DB2 will switch to single logging if it can't write to either of the copies. This will always happen when the logs fill because the writes to the two datasets are serial, not parallel, but will immediately fail because the other one is also full (unless you have them defined as different sizes) It will not overwrite one of the dual logs. [...]
2485 150 42_Re: FW: DB2 Log Archiving ( Dual Logging )0_19_mike.holmans@BT.COM30_Mon, 2 Oct 2000 13:55:00 +0100600_iso-8859-1 Yes, you are mistaken.
DB2 will not overwrite active log datasets which have not been properly archived, whether you are logging singly or dually.When DB2 drops down from dual logging to single logging, it is simply doing the best it can to keep going while you get yourself sorted out by catching up with your log archiving. It's a very short-term expedient from DB2's point of view, to keep the service up while you continue with your emergency fix procedures to sort things out properly. You should *never* base your procedures on DB2 switching to simplex logging, as it is [...]
2636 60 23_Re: SMALLER active logs12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Mon, 2 Oct 2000 14:23:30 +0100465_iso-8859-1 1. Stop DB2 2. Delete all active logs which have archived and define them smaller 3. Start DB2 4. Issue ARCHIVE LOG command, wait until offload is complete, repeat 1-3
If you require more detail reply to me and I will expand on it.
Colin Allen Abbey National
-----Original Message----- From: Tom Taylor [mailto:ttaylor@CHUBB.COM] Sent: Wednesday 09 August 2000 08:04 PM To: 'DB2-L@RYCI.COM' Subject: [DB2-L] SMALLER active logs [...]
2697 35 47_SP via DB2 Connect - failures after DB2 upgrade11_Roland Owen20_Roland.Owen@UBSW.COM30_Mon, 2 Oct 2000 09:16:12 -0500346_- Any advice on the following gratefully received.
We have a client application calling stored procedures on the mainframe, via DB2 Connect, which worked fine under DB2 v5. Following our DB2 upgrade to the May refresh level of v6 some of the stored procedures are abending - 04E with reason 00E50013 - the dump shows reason 00C90101. [...]
2733 146 42_Re: FW: DB2 Log Archiving ( Dual Logging )14_David R Slocum22_drslocum@CMSENERGY.COM30_Mon, 2 Oct 2000 10:16:51 -0400383_us-ascii We're on DB2 5.1 and have run into the situation where all DB2 active logs become full. DB2 did not start writing over one copy of the un-archived active logs. Instead, it waited until one set of active logs were successfully archived before proceeding. All activity in DB2 that needed to write to the log came to a complete stop until after the archive had completed. [...]
2880 25 23_End-user reporting tool21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US30_Mon, 2 Oct 2000 10:27:15 -0400526_iso-8859-1 Hi all,
I am looking for a replacement to a tool, named Intellect, that allows end-users to enter "English like" statements about the information they want on a report. The tool then takes the request and formats into the proper language/structure for the file structure being accessed, i.e. DB2, VSAM, etc. I have looked at QMF for Windows and like the functionality that it offers, but I want to know if anyone knows of a tool that offers some of the same functionality of the soon-to-be predecessor. [...]
2906 59 30_Re: PDF Question on DB2 OS/3909_Bob Lewis17_BLewis@ACSSYS.COM30_Mon, 2 Oct 2000 07:29:24 -0700378_iso-8859-1 Bruce -
I know you asked for a mainframe solution, but check out the IBM's Datalink product. It lets you store big things (PDF's, video, etc.) outside DB2 in a 'native' environment, but maintains referential integrity, backup/recovery control within DB2. I'm pretty sure it's only supported on AIX/Unix/NT at this point, but here is a link for more info: [...]
2966 47 17_Re: DB2 Resources0_22_Rohn.Solecki@MTS.MB.CA30_Mon, 2 Oct 2000 09:33:01 -0500436_iso-8859-1 Monday Oct2, 9:30 am CST I tried the link but get the following error. Has anyone else been able to get to the site? Did somebody forget to pay their registration fees (BG).
The requested item could not be loaded by the proxy.
Proxy server is unable to locate the server: theresourceet.com. The server does not have a DNS entry. Check the server name in the Location (URL) and try again. [...]
3014 64 30_Re: PDF Question on DB2 OS/39023_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Mon, 2 Oct 2000 10:41:56 -0400281_- Bruce,
I have converted ER Diagrams (created using ERWIN) to PDF files, loaded them into DB2 tables as BLOB (wrote a COBOL program to load each PDF file) and have a java servlet to fetch them and display on the browser. Works like a charm. What do you want to know ? [...]
3079 85 17_Re: DB2 Resources14_David R Slocum22_drslocum@CMSENERGY.COM30_Mon, 2 Oct 2000 10:48:05 -0400432_iso-8859-1 I was able to get to the site without any problems. It could be that your DNS server needs to be refreshed to pick up the correct information. My only complaint about the site is that the font size used in the menu along the left side of the page is so tiny you can't make it out. I'm using a ViewSonic G771 17" monitor at 1024 by 768 resolution. I hate to think how bad the situation would be on a smaller display! [...]
3165 13 17_Re: DB2 Resources16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Mon, 2 Oct 2000 10:44:32 -0400317_us-ascii http://www.theresourcenet.com/getframes.asp?site=DB2 works for 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.
3179 86 30_Re: PDF Question on DB2 OS/39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Mon, 2 Oct 2000 10:51:16 -0400701_iso-8859-1 Not familiar with the details but maybe DB2 Text Extenders are a possible solution.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Jain, Sanjay (Exchange) [mailto:sanjayjain@BEAR.COM] Sent: Monday, October 02, 2000 10:42 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] PDF Question on DB2 OS/390
Bruce,
I have converted ER Diagrams (created using ERWIN) to PDF files, loaded them into DB2 tables as BLOB (wrote a COBOL program to load each PDF file) and have a java servlet to fetch them and display on the browser. Works like a charm. What do you want to know ? [...]
3266 103 17_Re: DB2 Resources14_Scott Saunders20_ssaunders@SIEBEL.COM30_Mon, 2 Oct 2000 08:00:38 -0700641_iso-8859-1 Your error message states, "Proxy server is unable to locate the server: theresourceet.com.". Try theresourcenet as opposed to theresourceet and I think you will have better luck.
-----Original Message----- From: David R Slocum [mailto:drslocum@CMSENERGY.COM] Sent: Monday, October 02, 2000 7:48 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Resources
I was able to get to the site without any problems. It could be that your DNS server needs to be refreshed to pick up the correct information. My only complaint about the site is that the font size used in the menu along the left side of the page is so tiny [...]
3370 17 49_Compile an AIX SQL Pgm to use different Databases11_Mike Fatula17_mfatula@PHEAA.ORG30_Mon, 2 Oct 2000 11:06:18 -0400514_us-ascii Is there a way to compile an SQL program for one database and then without re-compiling change the database used by the program.
We are using Microfocus, and are forced to have multiply load libraries for each database. Real examples would be very helpful.
================================================ 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.
3388 201 42_Re: FW: DB2 Log Archiving ( Dual Logging )4_IBM119_IBM1@EGEBANK.COM.TR30_Mon, 2 Oct 2000 18:22:50 +0300518_iso-8859-9 excuse me colin,
would you care to explain what you mean by "defined as different sizes"?
I think I may have gotten the wrong end of the stick here... I did not think you could do so!
ciao!
Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________________ No trees were killed in the sending of this message. However, a large number of electrons were terribly inconvenienced. [...]
3590 43 13_UDB POSITIONS11_Bill Fource15_wfource@ONE.NET30_Mon, 2 Oct 2000 11:12:45 -0400543_us-ascii International software company is adding new UDB DB2 DBA permanent positions to its offices in the following cities:
Boston Hartford Philadelphia D.C. area Charlotte Atlanta
Requirements: - mid to senior level UDB DBA experience on a Unix platform. - Experience should include work in most typical DBA areas including: installations, physical database design, backup/recovery, performance tuning, security, etc. - other database experience a plus. - UNIX SysAdmin experience or Windows NT Server experience a plus. [...]
3634 25 16_DB2 Region Sizes14_Dean Montevago18_DMonteva@VNSNY.ORG30_Mon, 2 Oct 2000 11:28:59 -0400554_- Hi, Does anyone have any reccomendations on what the region sizes should be for the DB2 tasks. Will using a region large region above the line improve processing ? TIA Dean
Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax
dmonteva@vnsny.org
================================================ 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.
3660 48 28_Performance on View vs Table0_22_Rohn.Solecki@MTS.MB.CA30_Mon, 2 Oct 2000 10:35:28 -0500602_us-ascii Thanks all, Thomas's link worked.
I agree with David's observation about the page layout.
I found the following question on one of the links "DB2 Fans.com" discussion link (and it has no responses), and I'm interested in the answer too. We have a standard to define a base view and I'd love some justification for eliminating that standard for new tables. As I understand it, base views served some valid purpose in DB2 V2.3 or earlier, but no longer. The only impact I'm currently aware of is that base views are redundant and clutter up the system catlogs with additional [...]
3709 226 42_Re: FW: DB2 Log Archiving ( Dual Logging )12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Mon, 2 Oct 2000 16:36:08 +0100407_iso-8859-1 I'm sure in the past we accidentally had a test system where the LOGCOPY1 datasets were VSAM defined with a different primary quantity to the LOGCOPY2. Log switching was triggered by the smaller of the pair. There is no sensible reason I can think of for doing this deliberately, but as logs are VSAM defined I guess DB2 just waits for a full/unavailable response and triggers a log switch. [...]
3936 44 20_Re: DB2 Region Sizes11_Robert Jans21_Jans.Robert@AMSTR.COM30_Mon, 2 Oct 2000 09:44:00 -0600331_- Dean, as always, "It depends" applies. If you are V6, yes, the more avaialable above the line storage, the better. I'd suggest a minimum of 128m to ensure you get multi-tasking on the utilities. I don't know the threshold limit, I do know 32m isn't enough. At version 5 and under, the extra region size won't really do much [...]
3981 54 27_SV: End-user reporting tool0_19_Sven.Heidorn@CSN.SE30_Mon, 2 Oct 2000 17:50:50 +0200689_ISO-8859-1 Jim,
have a look at EasyAsk / English Wizard at: http://www.easyask.com/pages/home/home.htm If this product is installed QMF for Windows will recognize it and the Natural Query option will be available in the File->New menu.
Hope this helps
Sven Heidorn
> -----Ursprungligt meddelande----- > Från: brownjr@CI.RICHMOND.VA.US [SMTP:brownjr@CI.RICHMOND.VA.US] > Skickat: den 2 oktober 2000 16:34 > Till: DB2-L@RYCI.COM > Ämne: End-user reporting tool > > Hi all, > > I am looking for a replacement to a tool, named Intellect, that allows > end-users to enter "English like" statements about the information they > want > on a report. The tool then [...]
4036 65 20_Re: DB2 Region Sizes14_Dean Montevago18_DMonteva@VNSNY.ORG30_Mon, 2 Oct 2000 11:47:48 -0400562_- Thanks Robert.
> -----Original Message----- > From: Robert Jans [SMTP:Jans.Robert@AMSTR.COM] > Sent: Monday, October 02, 2000 11:44 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Region Sizes > > Dean, as always, "It depends" applies. If you are V6, yes, the more > avaialable > above the line storage, the better. I'd suggest a minimum of 128m to > ensure > you get multi-tasking on the utilities. I don't know the threshold limit, > I do > know 32m isn't enough. At version 5 and under, the extra region size won't > really do much > > Robert Jans > [...]
4102 21 32_Re: Performance on View vs Table9_Bob Lewis17_BLewis@ACSSYS.COM30_Mon, 2 Oct 2000 08:54:07 -0700587_iso-8859-1 As I recall, there was a small section in the big Mullins book that listed all the reasons why you shouldn't create 'base' views. Take a look at this article, particularly the section 'Do Not Create One View Per Base Table".
http://www.craigmullins.com/viewnw.htm
Hope this helps.
Bob Lewis Mercenary Contract 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.
4124 55 20_Re: DB2 Region Sizes0_22_Rohn.Solecki@MTS.MB.CA30_Mon, 2 Oct 2000 10:55:38 -0500426_us-ascii I'm assuming you are talking about the JCL "REGION" paramter on the JCL Job card or step EXEC line. We've been using "REGION=0M" to allow the system to grab what it can.
If you are not talking about the JCL REGION, please tell me where you are setting it.
Robert Jans @RYCI.COM> on 2000/10/02 10:44:00 AM Subject: Re: DB2 Region Sizes [...]
4180 77 20_Re: DB2 Region Sizes11_Robert Jans21_Jans.Robert@AMSTR.COM30_Mon, 2 Oct 2000 10:05:00 -0600287_- Rohn, we have a user exit in place in OS/390 that sets the limits. The exit has been modified so DNSUTILB can receive up to 128M. I don't have to code a REGION=128M on my jobcard. I do need to request some region size, even 0m so the rest of the rules in the user exit are happy. [...]
4258 33 7_Re: qmf21_Devineni, KishoreBabu29_KishoreBabu.Devineni@NIKE.COM30_Mon, 2 Oct 2000 09:03:00 -0700581_us-ascii If you issue connect to ? and then hit F4, you can see all the locations. If any location is not available means you cannot access that location from the existing location. Mostly, they don't grant the access to connect to production database from test database.
> -----Original Message----- > From: teoman [SMTP:tkocer@HALKBANK.COM.TR] > Sent: Monday, October 02, 2000 4:31 AM > To: DB2-L@RYCI.COM > Subject: qmf > > i am trying to connect another location from the qmf main panel > i am issuing CONNECT TO command and when i press f4 i can not see the all > [...]
4292 20 42_Re: Urgent help - problem after v5 upgrade12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 2 Oct 2000 11:14:00 -0500531_- You may also want to check on APAR PQ39064 if you use some third party utilities. This APAR improves our detection of various problems caused by brand X load, reorg, and recover.
Here's a detail URL to save some time. Where we have spent time doing the diagnosis, we include the information in a set of Info APARs. http://techsupport.services.ibm.com/support/390.support/phuic?query=PQ39064& stype=Exact+Words&prod=ALL&maxhits=20&sortby=proximity&startmonth=0&startyea r=0&endmonth=0&endyear=0&startrec=0&who=psearch [...]
4313 60 39_Compile/Link errors developing with CLI12_Owens, Steve20_SOwens@COOP-TECH.COM30_Mon, 2 Oct 2000 12:10:06 -0400321_- We're trying to port an existing VC++ ODBC application to DB/2 CLI and are having trouble with what to #include. Our environment: NT 4.0, MS Visual Studio 98, UDB 5.2 SDK. Our goal is to migrate this code to MVS. I've BTFM (browsed :-) and looked at the samples in the cli subdirectory, but I'm missing something. [...]
4374 21 8_Geo-plex0_22_Rohn.Solecki@MTS.MB.CA30_Mon, 2 Oct 2000 11:39:27 -0500377_us-ascii I just read the following article, "Geoplex: Exploiting the Concept of Multi-site Recovery", by Susan Lawson and Richard Yevich in The IDUG Solutions Journal, August 1998 - Volume 5, Number 2.
If I interpretted the article correctly, Geoplex would only work with a "Hot Site" Disaster Recovery setup. Can Geoplex be used with in a "Cold Site" DR scenario? [...]
4396 20 46_Porting data from DB2 OS/390 to DB2 UDB on AIX16_Jerry Bustamante20_ggbusta@LANDSEND.COM30_Mon, 2 Oct 2000 11:48:18 -0500421_iso-8859-1 What it the most efficient way, time wise, to port approx. 20 GB of data from OS/390 to AIX DB2 on a once a day basis?
Thanks,
Jerry Bustamente Lands' End
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4417 47 50_Re: Porting data from DB2 OS/390 to DB2 UDB on AIX12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Mon, 2 Oct 2000 20:16:49 +0200552_iso-8859-1 Hi, If you have shared disks (can be done with some vendors) then that's the easiest way (a little bit tricky, but works). Otherwise I suggest, UNLOAD, FTP, LOAD.
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Jerry Bustamante" Newsgroups: bit.listserv.db2-l To: Sent: Monday, October 02, 2000 6:48 PM Subject: Porting data from DB2 OS/390 to DB2 UDB on AIX [...]
4465 39 18_Rich Text Usage #211_Ken Liberty29_Ken_Liberty@CONSULTEC-INC.COM30_Mon, 2 Oct 2000 13:23:38 -0400695_us-ascii Since the first attempt of getting feed back was very weak, I figured I would give it another attempt.
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
We have an Power Builder application which needs to use Rich Text Functions, such as BOLD, ITALICS, etc on text in a VARCHAR column. My assumption is that the application will need to insert Before / After Characters around the 'text' (Example.... #Bold#Test#Bold#, would bold display 'Test') in which they want formatted differently, just like Word or Word Perfect does. The application will need to interpret these characters when accessing the column to ensure that it is display with BOLD [...]
4505 40 50_Re: Porting data from DB2 OS/390 to DB2 UDB on AIX10_Leo Pedron19_lpedron@BOSCOVS.COM30_Mon, 2 Oct 2000 13:39:56 -0400484_iso-8859-1 If you catalog the OS/390 data source on the AIX machine, then you can use the export utility in UDB/AIX to export the data from the host in IXF format. Then just call the load utility to load the data into the tables.
Leo
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Jerry Bustamante Sent: Monday, October 02, 2000 12:48 PM To: DB2-L@RYCI.COM Subject: Porting data from DB2 OS/390 to DB2 UDB on AIX [...]
4546 10 14_Visual Explain11_Tom Johnson25_new_to_db2@SPRINGMAIL.COM30_Mon, 2 Oct 2000 14:04:24 -0400562_- I have been using the Visual Explain product to perform some tuning tasks. Our PC support group had to re-install Windows. I went to the IBM download site and downloaded another version of Visual Explain. In the readme.txt doc it says to run the setup.exe member to install. There is no setup.exe member in the download. Two week ago I sent an email to IBM to notify them of this. I received an email back telling me that the email had been forwarded to the appropriate group. No contact from IBM. I downloaded another version of Visual Explain today and [...]
4557 126 64_Re: DB2 Connect from Unix to DB2 OS/390, maybe WEBSPHERE on UNIX16_Jerry Bustamante20_ggbusta@LANDSEND.COM30_Mon, 2 Oct 2000 13:27:57 -0500581_us-ascii Shan,
Thanks for the valuable information. Your taking the time is much appreciated.
Sincerely,
Jerry Bustamente Lands' End
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM Sent: Sunday, October 01, 2000 7:21 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect from Unix to DB2 OS/390, maybe WEBSPHERE on UNIX
Hi Jerry,
Thought I'd share our experience with you and it may be helpful in your research [...]
4684 38 50_Re: Porting data from DB2 OS/390 to DB2 UDB on AIX16_Swinski, Kenneth23_KSwinski@MASSMUTUAL.COM30_Mon, 2 Oct 2000 14:57:47 -0400336_iso-8859-1 Don't forget about using the OS/390 FTP server to process SQL queries. It involves binding plan EZAFTPMQ using a DBRM from library 'TCPIP.SEZADBRM'. It could save a lot of DASD because no flat files need to be staged on OS/390. It has been discussed in this forum before, and I can provide details if you're interested. [...]
4723 16 26_BMC Patrol for DB2 on Unix16_Swinski, Kenneth23_KSwinski@MASSMUTUAL.COM30_Mon, 2 Oct 2000 15:02:30 -0400520_iso-8859-1 Does anybody use this product? We are evaluating it and have not been able to obtain any references. The whole market for performace tools for DB2 on Unix is very immature, with lots of opportunities for vendors, so it wouldn't surprise me if nobody else is using it.
================================================ 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.
4740 61 50_Re: Porting data from DB2 OS/390 to DB2 UDB on AIX16_Jerry Bustamante20_ggbusta@LANDSEND.COM30_Mon, 2 Oct 2000 14:32:37 -0500675_iso-8859-1 Ken,
I am very interested. The details would be very helpful.
Thanks alot!
Jerry Bustamente
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Swinski, Kenneth Sent: Monday, October 02, 2000 1:58 PM To: DB2-L@RYCI.COM Subject: Re: Porting data from DB2 OS/390 to DB2 UDB on AIX
Don't forget about using the OS/390 FTP server to process SQL queries. It involves binding plan EZAFTPMQ using a DBRM from library 'TCPIP.SEZADBRM'. It could save a lot of DASD because no flat files need to be staged on OS/390. It has been discussed in this forum before, and I can [...]
4802 13 20_Re: DB2 Region Sizes8_Bob Abad16_BobRabad@AOL.COM28_Mon, 2 Oct 2000 15:53:40 EDT307_ISO-8859-1 I have been using region=0m. Any problem with that????
================================================ 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.
4816 42 30_Re: BMC Patrol for DB2 on Unix22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Mon, 2 Oct 2000 16:06:23 -0400738_iso-8859-1 Other options are:
Database-Guys http://www.database-guys.com/
Quest Software http://www.quest.com/db2/
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Swinski, Kenneth [mailto:KSwinski@MASSMUTUAL.COM] Sent: Monday, October 02, 2000 15:03 To: DB2-L@RYCI.COM Subject: [DB2-L] BMC Patrol for DB2 on Unix
Does anybody use this product? We are evaluating it and have not been able to obtain any references. The whole market for performace tools for DB2 on Unix is very immature, with lots of opportunities for vendors, so it wouldn't surprise me if nobody else is using it. [...]
4859 73 50_Re: Porting data from DB2 OS/390 to DB2 UDB on AIX11_Jim Keohane19_jimkeo@LOCKSTAR.COM30_Mon, 2 Oct 2000 16:12:53 -0400432_us-ascii Jerry, I would hazard a very strong guess that FTP SQL queries are not the way to go for performance. The result set of the SELECT is returned in a formatted SPUFI-like tabular manner. There's CPU cycles in the formating and in the row fetching and in the EBCDIC-ASCII translation. You should look for some bulk transfer mechanism with the preponderance of CPU cycles expended on AIX not OS/390. Cheers, - Jim Keohane [...]
4933 11 23_Re: DB2 on NT Fixpaks!!13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Mon, 2 Oct 2000 16:32:50 -0500315_- Try ftp://ftp.software.ibm.com/ps/products/db2/fixes/english-us/db2ntv5
================================================ 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.
4945 45 27_DB2 V6 Installation Problem15_Morris, Deborah20_DMorris@UNCH.UNC.EDU30_Mon, 2 Oct 2000 19:22:44 -0400363_- We just recently implemented V6 on OS390 and are having a problem with the start of DDF. The problem is that when DDF is started the domain name can not be resolved.
Here's the information:
DSNL004I DDF Start Complete Location "our location name appears" LU "our lu name appears" GenericLu -NONE Domain -NONE TCPPORT 446 RESPORT 5020 [...]
4991 68 30_Fw: PDF Question on DB2 OS/3909_jim.szabo22_jim.szabo@MCIWORLD.COM30_Mon, 2 Oct 2000 20:33:28 -0400530_Windows-1252 We store PDFs as OAM objects that can be accessed through OnDemand, or as IBM is calling the suite: ContentManager.
Jim Szabo
> > -----Original Message----- > > From: Bruce Fuller [SMTP:BFuller@EBSCO.COM] > > Sent: Friday, September 29, 2000 2:32 PM > > To: DB2-L@RYCI.COM > > Subject: PDF Question on DB2 OS/390 > > > > I have been asked to forward this question to the DB2 list. > > > > Has anyone on the list stored a file in PDF format (for use by WEB > > interface) in a DB2 table? > > > > If [...]
5060 94 31_Re: DB2 V6 Installation Problem10_Rob Wright17_rwright@LIC.CO.NZ30_Tue, 3 Oct 2000 13:39:10 +1200654_us-ascii Have you configured your UNIX Systems Services (or OpenEdition) environment and ran the installation verification process to confirm LE is operating properly in this environment?
Also, see the following section in the DB2 V6 Install Guide:
3.3.2 Step 1: Prepare the LE/370 runtime library
Because DDF uses some functions in the LE/370 library, DDF needs access to the runtime library. The standard way to handle this is to include the LE/370 library in a STEPLIB concatenation for the DDF JCL procedure. The LE/370 library must be APF authorized to be added to the DDF JCL procedure. The DB2 installation automatically [...]
5155 23 39_copy of catalog for distributed access?13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Mon, 2 Oct 2000 15:38:27 -0500448_iso-8859-1 Hello List,
Just curious how many of you are using copies of the DB2 OS/390 catalog for DB2 Connect access.
Is anybody using the catalog directly?
Why or why not?
With the capablility of creating user defined indexes on the catalog, and with improvements over time to both DB2 Connect and to DB2 OS/390, can a heavy distributed environment perform satisfactorily without having to replicate the catalog? [...]
5179 43 30_Re: BMC Patrol for DB2 on Unix11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM30_Tue, 3 Oct 2000 01:20:29 -0400667_us-ascii Hi Kenneth,
Our thanks to Michael Piontkowski for calling our URL to DB2-L's attention (http://www.database-guys.com/). We have a new press release that may interest you at http://www.database-guys.com/press3.shtml, and I hope you'll take just a couple minutes to read our "Cards & Letters" at http://www.database-guys.com/guestbook/guestbook.html
What we lack in "high gloss" we more than make up for in results. As you'll note, helping folks succeed with DB2 UDB is our only business. Performance RESULTS. It's what we do. It's who we are. And we're having a tremendous lot of fun helping DB2 professionals; we hope we can help you too. [...]
5223 19 42_Re: FW: DB2 Log Archiving ( Dual Logging )14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Tue, 3 Oct 2000 12:28:44 +0100292_us-ascii His Colin, the same happened to us in test some years ago whill defining a new DB2. We realized of this 'problem' some weeks later.
I think that DB2 archive is triggered by active log full as you said, that is it's it's the smaller of the two logs who shoot the archive. [...]
5243 29 7_UDB/USS0_37_frank_petersen@BANKDATA-DK.E-MAIL.COM28_Tue, 3 Oct 2000 06:45:18 EDT577_US-ASCII We are considering moving some buisness-applications from AIX to OS390 open system (USS). Under AIX we have these grouped in 2; one sort of application uses a UDB-client on AIX to access data on DB2/OS390 and the other group uses a local UDB on AIX. - When trying to read about UDB and OS390/USS we get a little confused whether there actually exists a UDB/client for USS and a UDB 'fullfuntion database'. Or does all the access have to be 'piped' through the CLI-interface aiming towards a UDB on a other platform. Which means recoding the applications ! - Does [...]
5273 95 32_Re: Performance on View vs Table0_19_mike.holmans@BT.COM30_Tue, 3 Oct 2000 12:02:19 +0100598_iso-8859-1 What Craig Mullins says is that you shouldn't create views without thought, and that you should have good reasons for doing it. He goes through an awful lot of spurious reasons which people have come up with over the years for "base" views and refutes them.
Generally, I'd endorse what he says. But we use base views on a number of our systems, and the main reason for that is the 8-character restriction on the names of various things in DB2, such as tablespaces, indexes and foreign key relationships (tablespace and indexspace names have an 8-char restriction if you want [...]
5369 272 42_Re: FW: DB2 Log Archiving ( Dual Logging )0_19_mike.holmans@BT.COM30_Tue, 3 Oct 2000 12:31:14 +0100430_iso-8859-1 I suppose one "sensible" reason for defining log dataset pairs with the datasets of different sizes might be if you were in a shop like Mohamed's where they don't seem to get their log archiving right. The smaller dataset's filling up would trigger the log offload, but DB2 could carry on logging in single mode for a bit while someone wakes up for long enough to mount a tape so that the log archive can proceed. [...]
5642 130 32_Re: Performance on View vs Table19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 3 Oct 2000 06:55:55 -0500594_iso-8859-1 Hi all, To answer, somewhat, the original question: Are there performance issues related to using a base view vs. the base table? I believe this issue was discussed heavily some yrs. ago with the majority opinion indicating that there was very little to no performance penalty using views. However, if you wish to create a logistics and maintenance "wonderland", start using base views on all your tables, (hehe)! So far, I have only seen two uses of views that served some "real world" purpose: 1) to restrict access to sensitive data and, 2) as a vehicle to simplify SQL that [...]
5773 35 20_Re: DB2 Region Sizes19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 3 Oct 2000 07:16:22 -0500602_iso-8859-1 Bob, The REGION parm can be changed and/or limited by the OS390 sysprogs via user exit. Check with them to ensure the upper limit is what you'll require.
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 [...]
5809 93 51_Re: SP via DB2 Connect - failures after DB2 upgrade0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Tue, 3 Oct 2000 07:47:08 -0500516_us-ascii Hi Roland,
I checked our Sysroutines and it shows Y as well for all the NULL_CALL columns of our stored procedures after we converted to V6. I'm assuming that must be the default as our Routinetype = 'p' and it could have very well have been set to a blank. For us it doesn't appear to be causing us any problems. Although since you've had success with blank on your other converted subsystem, it would be easy enough for you to give that a try and see if that made a difference. Give it a try. [...]
5903 81 43_Re: copy of catalog for distributed access?0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Tue, 3 Oct 2000 08:20:16 -0500575_us-ascii I may not fully understand your question but I'll answer with what I think you're asking..
We have always kept a copy of the DB2 Catalog on OS/390 for most of our DB2 subsystems which we refer to as our clone catalog. We copy the information form the active DB2 catalog every night around midnight, so it always reflects yesterdays data. Since we can add more indexes to the clone we can improve performance on the clone thus getting better response time in many cases on many tools that access the catalog and many clist processes that don't require up [...]
5985 120 51_Re: SP via DB2 Connect - failures after DB2 upgrade36_Enarson, Mike (CC-Database Services)24_Mike.Enarson@CONAGRA.COM30_Tue, 3 Oct 2000 08:23:24 -0500545_iso-8859-1 Hi Roland. Info Apar II12343 contains the ptfs in addition to the May refresh that needs to be on. Also you said the dump indicated a 00C90101? Have you checked into to this as the problem?
Regards Mike Enarson
-----Original Message----- From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM [mailto:Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM] Sent: Tuesday, October 03, 2000 7:47 AM To: DB2-L@RYCI.COM Subject: Re: SP via DB2 Connect - failures after DB2 upgrade [...]
6106 72 43_Re: copy of catalog for distributed access?12_Carol Sutfin19_csutfin@AMSOUTH.COM30_Tue, 3 Oct 2000 08:39:34 -0500585_- We only allow access to the system catalog to the application DBA's in the production subsystem. This has been done because of the lack of experience on the part of our application staff.
We do have one case of using a copy of the catalog for application use. I created a copy of the SYSTABLES table for one distributed application here. Originally, it was accessing SYSIBM.SYSTABLES in order to determine if the subsystem was active, The application did not perform any form of commit or release at the end of a thread which was causing deadlocks with other tasks, both [...]
6179 83 43_Re: copy of catalog for distributed access?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 3 Oct 2000 08:48:27 -0500636_iso-8859-1 Carol, Could the same be achieved by doing: EXEC SQL SET :hostvar = CURRENT TIMESTAMP END-EXEC.
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 [...]
6263 90 43_Re: copy of catalog for distributed access?13_John Arbogast19_arbo@CP-DEMO.CP.NET30_Tue, 3 Oct 2000 07:05:35 -0700540_- Or a select from sysdummy1?? On Tue, 03 October 2000, "DAVIS, RICK (SBCSI)" wrote:
> > Carol, > Could the same be achieved by doing: > EXEC SQL SET :hostvar = CURRENT TIMESTAMP END-EXEC. > > 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 [...]
6354 60 43_Re: copy of catalog for distributed access?12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 3 Oct 2000 07:21:09 -0700491_us-ascii At one client of mine, we created a shadow catalog and had all DB2 Connect users go against that. This was on DB2 rel 4.
My current client goes directly against the SYSIBM catalog. We've tried to use DB2OCAT, but have had several outstanding problems with it (reported to IBM for over 2 years with no resolution). These problems have made it totally unusable - cannot get DB2OCAT to even finish shadow catalog build. So we have not been able to test using that product. [...]
6415 13 45_Integrity on the catalog tables -- UDB on AIX12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Tue, 3 Oct 2000 09:29:31 -0500388_iso-8859-1 On the mainframe we have DSN1CHKR to check the integrity of the catalog tables - anyone aware of a similar tool/product for UDB on AIX?
================================================ 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.
6429 66 49_Re: Integrity on the catalog tables -- UDB on AIX13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Tue, 3 Oct 2000 09:48:58 -0500473_US-ASCII Paul, Try DB2DART Regards, Kurt
>>> Paul.Martin@ECOLAB.COM 10/03/00 09:29AM >>> On the mainframe we have DSN1CHKR to check the integrity of the catalog tables - anyone aware of a similar tool/product for UDB on AIX?
================================================ 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.
6496 135 43_Re: copy of catalog for distributed access?12_Carol Sutfin19_csutfin@AMSOUTH.COM30_Tue, 3 Oct 2000 10:03:43 -0500569_- Okay, there are many (and better) ways of checking for an active subsystem. This wasn't my idea in the first place. This is a "vendor" written application, by a vendor who had no real DB2 experience. They were trying to transfer an Oracle application to DB2. Every time they encountered a non-zero sqlcode, a select was issued to sysibm.systables to "see if the subsystem was active". No checking for +100, -911, -904, etc. This is what happend when Users are allowed to select their own software vendors without the direction of someone in the technical arena. [...]
6632 69 32_Re: Performance on View vs Table14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Tue, 3 Oct 2000 10:11:34 -0500554_iso-8859-1 There may be additional overhead associated with a view, but it depends on how/where the view is being used. If the view is being used in ad hoc or dynamic SQL, DB2 will have to read the view definition from the catalog tables (SYSVIEWS, etc.) before running the actual query. If the view is being access in a static bound SQL statement then it may possibly avoid this is view merge was used (that is, at BIND time, the SQL that accesses the view is merged with the view DDL SQL). If view materialization is used then additional I/O will [...]
6702 23 32_Re: Performance on View vs Table0_19_Tim.Lowe@STPAUL.COM30_Tue, 3 Oct 2000 10:11:06 -0500516_us-ascii I saw a user once upon a time that was using a select distinct on a view that had been created for him in order to "simplify" the SQL and eliminate the complexity. It turned out that the view was a 3-way join, and in his current query he only needed to query 1 of the tables. But, the only thing that he had been given was the view, so he just added a distinct to get back the data from the single table. (performance obviously left much to be desired) Ever since then, I have questioned the wisdom of [...]
6726 25 23_Table/Index statistics.19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Tue, 3 Oct 2000 11:12:31 EDT405_us-ascii Hi,
When I calculate FAROFFPSOF / CADF or (NEARINDREF + FARINDREF) / CARDF, do I get a value in terms of a percentage or a decimal fraction?
The reason for this question is to determine if I need to reorg a table, can I take this number and consider a reorg if the value is greater than 10, for example, or do I have to do any additional calculation to arrive at a percentage? [...]
6752 21 21_DB2 Opportunity in NC16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU30_Tue, 3 Oct 2000 11:26:23 -0400451_iso-8859-1 We have a full time position available as a DB2 application programmer here at UNC Health Care System. We are looking for someone with 3-5 years experience in DB2 applications with COBOL & CICS. We are a large Health Care System located in Central North Carolina. We are looking for someone to fill an open position on our DB2 Development team. If interested in finding out more, please email me with questions and or resume. Thanks.. [...]
6774 63 32_Re: Performance on View vs Table15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Tue, 3 Oct 2000 17:29:59 +0200487_iso-8859-1 Tim,
As a DBA you should be aware of the data and the customers needs. Maybe this particular customer didn't contact the DBA about changed design. It looks like nobody reviewed the customers SQL. Sometimes there are company rules about not joining tables iin certain applications...just some other thoughts. I do agree with you this wasn't the best solution for this particular case. But things I see aren't always black and white. They're grey most of the time.. [...]
6838 30 29_Question Reg. Bufferpool Tool8_Kurian B23_Bejoy_Kurian@MAY-CO.COM30_Tue, 3 Oct 2000 10:36:17 -0500612_us-ascii Hi Joel,
My name is Bejoy and currently working for May company. Our shop running with DB2v6 on os390. We have Bufferpool Tool also installed and found this an excellent product for bufferpool tuning. We are in the process of tuning our bufferpools. We found the 'Buffer Pool graphic facility' extremely useful, especially the recomentation. Our current problem is capturing the data file for 'Buffer Pool graphic facility. Our system programmer says that he can not run this job for more than 1 hour because of DASD problem. According to him, to capture 1 hour data, it requires 600CYL. Is [...]
6869 51 35_DB2 Connect extended security codes10_Peter Boot22_Peter.Boot@MAIL.ING.NL30_Tue, 3 Oct 2000 17:27:33 +0100373_US-ASCII Hi all,
We'll be implementing DB2 Connect shortly and are playing around with some options on the server and/or the mainframe. We have turned on EXTSEC in the mainframe DB2 subsystem but do not receive the extended security messages we'd like to see.
The setup: DB2 Connect PE 6.1, MS SNA Server 4.0, DB2/OS390 5.1 (on an MVS system using ACF2) [...]
6921 53 33_Re: Question Reg. Bufferpool Tool11_Jerry, Jeff27_Jeff.D.Jerry@WELLSFARGO.COM30_Tue, 3 Oct 2000 10:43:36 -0500643_- We have a similar problem since our DB2 subsystems are very busy. We send the data to a tape data set and have no problems with it at all.
-----Original Message----- From: Kurian B [SMTP:Bejoy_Kurian@MAY-CO.COM] Sent: Tuesday, October 03, 2000 10:36 AM To: DB2-L@RYCI.COM Subject: Question Reg. Bufferpool Tool
Hi Joel,
My name is Bejoy and currently working for May company. Our shop running with DB2v6 on os390. We have Bufferpool Tool also installed and found this an excellent product for bufferpool tuning. We are in the process of tuning our bufferpools. We found the 'Buffer Pool graphic facility' extremely [...]
6975 165 43_Re: copy of catalog for distributed access?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 3 Oct 2000 10:48:55 -0500595_iso-8859-1 I feel your pain . . .
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 e-mail is strictly prohibited." [...]
7141 32 73_Problem with utilities executing against wrong library and not fi nishing14_McCombs, Terry20_tmccomb@SEDGWICK.GOV30_Tue, 3 Oct 2000 10:50:04 -0500588_iso-8859-1 Last night the system programmer did some maintenance on our test DB2 subsystem (OS/390, V5), but failed to change any of the production batch jobs to point to the correct load library. The regular image copies were submitted at 8PM. About 5AM this morning, when the operators noticed they hadn't completed yet (a little sarcasm here, they normally take less than a minute to run), the jobs were cancelled, and are now in rollback status. I finally got the good news at 9AM and got locked up trying to display utility (because the TSO JCL hadn't been changed, either), so [...]
7174 20 43_Re: copy of catalog for distributed access?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 3 Oct 2000 12:02:39 -0400324_iso-8859-1 >Every time they encountered a >non-zero sqlcode, a select was issued to sysibm.systables to "see if the >subsystem was active". No checking for +100, -911, -904, etc. This is >what happend when Users are allowed to select their own software vendors >without the direction of someone in the technical arena. [...]
7195 23 41_Public access and private protocol access21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US30_Tue, 3 Oct 2000 12:07:14 -0400345_iso-8859-1 Hello listers,
Is it possible to access tables that have SELECT authority granted to PUBLIC using three part names. Whenever anyone tries to access tables that their TSO id does not have explicit authority to a table, they get an -551 sqlcode. This does not seem normal and I feel that something is amiss in this process. [...]
7219 73 33_Re: Question Reg. Bufferpool Tool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Tue, 3 Oct 2000 12:07:47 -0400532_ISO-8859-1 Bejoy, As Jeff Jerry just replied, you can run the collection to tape . You may lose a bit of data up front waiting for the tape mount, and lose a large amount if it goes to a second volume. In todays environments, 600 Cyl is not a lot of space. We have many client sites that run 2000 Cyl collections. The collection can then be archived to tape - as another approach. There is no way to reduce the volume of data that is collected and written out. This process has already been optimized by discarding most of the [...]
7293 84 33_Re: Question Reg. Bufferpool Tool8_Kurian B23_Bejoy_Kurian@MAY-CO.COM30_Tue, 3 Oct 2000 11:23:25 -0500674_us-ascii Jeff and Joel Thanks.
From: Joel Goldstein @RYCI.COM> on 10/03/2000 11:07 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Fax to: Subject: Re: Question Reg. Bufferpool Tool
Bejoy, As Jeff Jerry just replied, you can run the collection to tape . You may lose a bit of data up front waiting for the tape mount, and lose a large amount if it goes to a second volume. In todays environments, 600 Cyl is not a lot of space. We have many client sites that run 2000 Cyl [...]
7378 50 45_Re: Public access and private protocol access38_Andersen, Cindy (CC-Database Services)26_Cindy.Andersen@CONAGRA.COM30_Tue, 3 Oct 2000 11:32:35 -0500367_iso-8859-1 Jim,
Has the SELECT authority that was granted to PUBLIC been granted AT ALL LOCATIONS?
If you are accessing the table from different locations, you need to add the additional clause to the GRANT statement when doing the initial grant.
The statement should look like: GRANT SELECT ON TABLE "tablename" TO PUBLIC AT ALL LOCATIONS; [...]
7429 45 45_Re: Public access and private protocol access9_Don Alden25_Don.Alden@I-STRUCTURE.COM30_Tue, 3 Oct 2000 10:33:56 -0600418_iso-8859-1 Hello James,
In order to GRANT table access to Distributed users you must use the following format.
GRANT SELECT ON TABLE XXXXXXXX to XXXXXX AT ALL LOCATIONS;
Good Luck, Don
-----Original Message----- From: Brown, James R. - DIT [mailto:brownjr@CI.RICHMOND.VA.US] Sent: Tuesday, October 03, 2000 9:07 AM To: DB2-L@RYCI.COM Subject: Public access and private protocol access [...]
7475 67 45_Re: Public access and private protocol access21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US30_Tue, 3 Oct 2000 13:07:43 -0400448_iso-8859-1 Thanx Cindy and Don. That was the problem.
Jim
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Andersen, Cindy (CC-Database Services) Sent: Tuesday, October 03, 2000 12:33 PM To: DB2-L@RYCI.COM Subject: Re: Public access and private protocol access
Jim,
Has the SELECT authority that was granted to PUBLIC been granted AT ALL LOCATIONS? [...]
7543 47 46_00C90101 erqual 5007 after migrate to DB2 V5.118_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM30_Tue, 3 Oct 2000 13:16:46 -0400726_iso-8859-1 We migrated our production DB2 to V5.1 this weekend. We use Princeton Softech's MOVE for DB2 product to load some accounts for sample billing. The job is abending S04E and causing these messages in the MSTR log: DSNI014I - DSNKINSN DATA IN USE DURING ABEND REASON 00C90101 ERQUAL 5007 TYPE 00000302 NAME CSRDI010.CSRCSSBG.X'000000EE' CONNECTION-ID=DB2CALL CORRELATION-ID=CSRSB002 LUW-ID=* DSNI014I - DSNKINSN DATA IN USE DURING ABEND REASON 00C90101 ERQUAL 5007 TYPE 00000303 NAME CSRDI010.NXBGP01 .X'00000002' CONNECTION-ID=DB2CALL CORRELATION-ID=CSRSB002 LUW-ID=* We unload/reload the data, rerun the job, and it seems to get past this tablespace only to cause the same abend/messages on another tablespace. [...]
7591 12 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.112_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Tue, 3 Oct 2000 12:19:43 -0500279_us-ascii We've also gotten this error
================================================ 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.
7604 76 31_Re: DB2 V6 Installation Problem11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Tue, 3 Oct 2000 12:33:56 -0500439_us-ascii You are missing the DNS name. See page 476 and 477 of the Installation guide. The "MAKESITE" piece must be done!... : )
Example: DOMAIN IBMMWDB TCPPORT 30211 RESPORT 30212
From: "Morris, Deborah" @RYCI.COM> on 10/02/2000 06:22 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
7681 69 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.113_Johnson, Bill18_bjo23@ALLSTATE.COM30_Tue, 3 Oct 2000 12:37:39 -0500611_- Check with IBM. We've just received a fix that handles the 00C90101 abend. Just waiting to recycle DB2 to implement the fix. It has something to do with updating an indexspace. Sorry I don't know the PTF. Bill Johnson DBA Allstate Insurance Co.
> -----Original Message----- > From: GRESHAM, DEBORAH B [SMTP:DGRESHAM@SCANA.COM] > Sent: Tuesday, October 03, 2000 1:17 PM > To: DB2-L@RYCI.COM > Subject: 00C90101 erqual 5007 after migrate to DB2 V5.1 > > We migrated our production DB2 to V5.1 this weekend. We use Princeton > Softech's MOVE for DB2 product to load some accounts for sample billing. [...]
7751 82 32_Re: Performance on View vs Table19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 3 Oct 2000 12:57:47 -0500484_iso-8859-1 Hi Tim, Jaap, Tim, your observation, unfortunately, happens quite often and is certainly regrettable (keep the programmers in the dark; don't dare show them the data model, it might scare them). Like Jaap noted, it depends. Using a view to make complicated SQL easier to maintain should be a carefully considered decision, rarely used, and well documented. The designers and analysts should have caught the problem you describe well before a line of code was written. [...]
7834 92 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.118_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Tue, 3 Oct 2000 14:19:30 -0400541_iso-8859-1 This may not apply here but we just ran into these C90101 errors on our Indexes. We are are DB2 OS/390 V5 and we use CA/Platinum tools. Seems the Platinum rapid reorgs changed some settings in the Index Header and after we applied our DB2 V5 maitenance up to 0002 we started getting errors on these indexes. I had to have CA/Platinum send us a hiper tape and I just finished checking it out. The fix does set these header page flags back to a value that DB2 likes. Where the problem was is that when we reorg'd a partitioned [...]
7927 10 32_Help with SQLDA in COBOL program10_Bill Brown25_bill_brown@SPRINGMAIL.COM30_Tue, 3 Oct 2000 14:52:17 -0400557_- We are modifying our environment to contain multiple copies of tables and using the set packageset to point at the proper table based on a customer id. We have to be able to move the data without experiencing an outage. I am attempting to write a COBOL program using dynamic SQL that will perform an insert with the unloaded data. Two questions: One of the columns in the SQLDA that needs to be populated is the SQLLEN. In the case of packed decimal the first byte should contain the precision and the second byte should contain the scale. The field [...]
7938 101 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.110_Greg Jonas21_gjonas@CP-DEMO.CP.NET30_Tue, 3 Oct 2000 11:56:55 -0700549_- Things that make you say "Hmmm". We've had the problem with the 00C90101 under V6 and had been blaming it on the BMC V6 tolerant utils. Now this note blames the CA/Platinum tools. Hmmmm.
On Tue, 03 October 2000, "Whittaker, Stephen" wrote:
> > This may not apply here but we just ran into these C90101 errors on our > Indexes. > We are are DB2 OS/390 V5 and we use CA/Platinum tools. Seems the Platinum > rapid reorgs > changed some settings in the Index Header and after we applied our DB2 V5 > maitenance up > to 0002 [...]
8040 143 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.118_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Tue, 3 Oct 2000 15:04:29 -0400525_iso-8859-1 Sounds a little bit like these settings existed before and were ignored by IBM but now as we move up the maintenance ladder that they are not going to be so forgiving. I just wish CA had told us about this potential problem when they first knew about it. That would have saved me alot of headaches when we went into Production. Now we have broken NPI's out there that I've had to identify and somehow get them into the maint. window to be repaired. Guess thats why we get the big bucks!!! Or so some say! :-) [...]
8184 26 38_Migrating DataPropagator from V5 to V611_Sinha, Amit19_Sinha.Amit@MBCO.COM30_Tue, 3 Oct 2000 14:47:30 -0500486_iso-8859-1 We are in the process of migrating the dataPropagator from Version 5 to Version 6 and was just curious to know anyone in this list has already done the migration and was just wondering if they had encountered any problem. The website of IBM has no details about migration to Version 6 it has for version 5. Our Environment is OS/390 DB2 Version 6.1 as Source and OS/390 DB2 Version 6.1 as Target. We have replication from Segmented Tablespace to Partitioned Tablespace. [...]
8211 57 42_Re: Migrating DataPropagator from V5 to V610_Mike Paris14_MPARIS@TUC.COM30_Tue, 3 Oct 2000 14:54:03 -0500410_US-ASCII Amit,
We completed the migration a few months ago. The sysadm that performed the migration reported no problems.
If you want to contact me offline feel free.
Michael Paris
Senior Database Analyst IBM Certified Solutions Expert DB2 UDB Database Administration IBM Certified Advanced Technical Expert Data Replication
Trans Union 555 West Adams Chicago, IL 60616 [...]
8269 41 45_Using Java and Stored Procedures and DB2 KEYS12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 3 Oct 2000 13:04:16 -0700372_us-ascii Our JAVA programmers are trying to tell us that for our DB2 tables that we need to have a unique key that is generated for each table. They are stating that the composite keys cause problems in JAVA and EJB and the UNIFIED OBJECT MODELING that they are using. Something about object persistence and being unable to guarantee integrity of the data otherwise. [...]
8311 67 34_just pinging... (where's everyone)17_McDonnell, Victor22_vmcdonnell@CAYENTA.COM30_Tue, 3 Oct 2000 13:13:16 -0700200_ISO-8859-1
Victor McDonnell Database Architecture and Administration <<...OLE_Obj...>> 1900 Campus Commons Dr Reston, VA 20191 phone: 703.390.4826 email: vmcdonnell@cayenta.com
8379 14 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.112_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Tue, 3 Oct 2000 15:24:39 -0500385_us-ascii We had the same error, using BMC. What we di is a check index to identify the problems, Then use IBM utilities to recover the indexes.
================================================ 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.
8394 125 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.18_Lo, Mary17_mary.lo@TGSLC.ORG30_Tue, 3 Oct 2000 15:26:22 -0500496_iso-8859-1 I got the same 00C90101 problem with V6 IVP job DSNTEJ71, loading LOB table.
-----Original Message----- From: Greg Jonas [mailto:gjonas@CP-DEMO.CP.NET] Sent: Tuesday, October 03, 2000 1:57 PM To: DB2-L@RYCI.COM Subject: Re: 00C90101 erqual 5007 after migrate to DB2 V5.1
Things that make you say "Hmmm". We've had the problem with the 00C90101 under V6 and had been blaming it on the BMC V6 tolerant utils. Now this note blames the CA/Platinum tools. Hmmmm. [...]
8520 13 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.112_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Tue, 3 Oct 2000 15:31:22 -0500353_us-ascii Also this was only happening in muti table tablespaces,....so far anyway. Is that the same with yours?
================================================ 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.
8534 144 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.19_Rob Crane22_racrane@CONCENTRIC.NET30_Tue, 3 Oct 2000 15:27:46 -0600557_us-ascii Here is something that might help you find the suspect header pages...
I believe the fix for this problem has been available for 6+ months. If you are a user of utilities from an ISV (CA, BMC, etc), I would make sure you are at the correct level of software including hypers. NPI index header pages canned be scanned to look for the specific problem so you can take the corrective action ahead of running into this issue. I believe this was one of those catch22 issues where you not only need to correct software level, but you need to [...]
8679 47 35_DB2 Connect V6.1 and DB2/OS390 V5.112_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Tue, 3 Oct 2000 17:22:17 -0400695_iso-8859-1 Hello list,
Well, I think the problem with the 0C4 abends in DB2 has been resolved by applying maintenance 9909. However, the maintenance has introduced an incompatibility with DB2 Connect V6.1, namely connection pooling (refer to APAR NUMBER: II12269). Since V5 has downlevel DRDA, when Connect 6.1 uses connection pooling all sorts of sporadic problems occur, either the nebulous SQL30081N Communication error message or an invalid password message is sporadically returned to the clients. Apparently, V5 doesn't understand the connection pooling and there are authorization problems if user A attempts to re-use User B's previous connection via connection pooling. The [...]
8727 78 43_Re: copy of catalog for distributed access?13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Tue, 3 Oct 2000 15:59:44 -0500538_iso-8859-1 Thanks for the feedback Myron!
DB2OCAT did not fly here as well, but that was before my involvement so I don't know the details.
Catalog contention, as you referred to, is one of my outstanding questions.
Anyone with a high degree of distributed activity using direct catalog access? How's your mileage?
-----Original Message----- From: Myron Miller [mailto:myronwmiller@yahoo.com] Sent: Tuesday, October 03, 2000 9:21 AM To: DB2-L@RYCI.COM Subject: Re: copy of catalog for distributed access? [...]
8806 60 36_Re: Help with SQLDA in COBOL program11_Suresh Sane21_data_arch@HOTMAIL.COM28_Tue, 3 Oct 2000 17:01:55 CDT296_- Bill,
Multiplying by 256 is like shifting left.
Here is what I have used in the past. If you need to have a decimal of precision p and scale s, calculate p*256 + s. For example, for a column declate DEC(15,2), you would use 3842. Move this number to sqllen and you are done. [...]
8867 68 61_Re: Help with SQLDA in COBOL program - An answer and question14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU30_Wed, 4 Oct 2000 09:07:02 +1100427_iso-8859-1 Bill, from (old) memory...
03 TARGET-LEN USAGE PACKED-DECIMAL. (or comp-n) 03 TARGET-XX REDEFINES TARGET-LEN 05 TARGET-PREC PIC X. 05 TARGET-SCAL PIC X. 01 blah 03 SOURCE-PRECISION USAGE PACKED-DECIMAL. 03 SP REDEFINES SOURCE-PRECISION 05 FILLER PIC X. 05 SOURCE-PRECISION-X2 PIC X 01 blah vlah 03 SOURCE-SCALE USAGE PACKED-DECIMAL. 03 SC REDEFINES SOURCE-SCALE 05 FILLER PIC X. 05 SOURCE-SCALE-X2 PIC X [...]
8936 58 26_Re: WLM extending lifetime12_Kirk Hampton16_khampto1@TXU.COM30_Tue, 3 Oct 2000 17:25:19 -0500565_us-ascii Hello Tom, I was catching up on a week's worth of DB2-L after being on vacation, and the WLM caught my eye. No one else seems to have responded, probably because WLM is something of a mystery to all but the lead OS/390 sysprogs.
What is your concern with keeping the stored procedure address space running when it is not being used ? Just so that the next caller of the stored procedure does not have to wait for the address space to initialize ? We have many such infrequently-called stored procedures here, and have had no complaints on wait [...]
8995 52 41_FYI: e(logo)series - the new IBM branding14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 4 Oct 2000 10:23:47 +1100610_iso-8859-1 > IBM has announced a major rebranding: > > 1) Many things come under the <<...>> brand. <<...>> can be written > "e(logo)server". (In case the embedded graphic doesn't make it through > the e-mail system, "e(logo)" is a lower case 'e' with the tail extended up > and over and around the body in the same fashion as an @ character.) > http://www.ibmlink.ibm.com/usalets&parms=H_100-322 > > 2) Hardware has been re-branded > S/390 becomes zSeries (with zArchitecture as the generic term for the > instruction set etc). > RS/9000 becomes pSeries > AS/400 beomes iSeries > Netfinity (ie Intel x86 [...]
9048 53 25_Re: DB2 Opportunity in NC16_Bruce Williamson25_Bruce.Williamson@MAIL.COM30_Wed, 4 Oct 2000 09:35:17 +1000598_iso-8859-1 Dear Michael
Thanks for contacting me regarding this position but I'm interested in a DB2 DBA position or applications development using emerging technologies like VisualAge for Java, WebSphere, XML, etc.. Should you have anything in these areas I'd appreciate being considered for them.
Thanks for your time.
Regards
Bruce Williamson
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Dempsey, Michael Sent: Wednesday, 4 October 2000 01:26 To: DB2-L@RYCI.COM Subject: DB2 Opportunity in NC [...]
9102 58 24_COMMON TABLE EXPRESSIONS19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW30_Wed, 4 Oct 2000 21:46:29 +0800241_big5 HI : ALL I don't known what is common table expressions , so any one can tell me : 1. in use os/390 , NT, AIX or .....others 2. I can reference DB2 manual , book no... 3. use DB2 versions , how use common table expressions
THANKS
9161 24 42_Re: Urgent help - problem after v5 upgrade25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG30_Wed, 4 Oct 2000 10:11:09 +0800422_us-ascii Hi,
Would like to thank Roger, Andy for you timely help. The bug did arise from BMC product. I have run the jobs suggested by the BMC tech support (Albert) and my indexes are now ok. I would like to Check with the group on the following
a. When I change the default index in the DSNZPARM to type 2, would it affect the DB2 subsystem if the susystem comprised of both type 1 and type 2 indexes. [...]
9186 73 28_Re: COMMON TABLE EXPRESSIONS14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 4 Oct 2000 13:49:08 +1100514_big5 The general form of a SELECT statement is: SELECT list-of-columns FROM list-of-table-views-aliases-or-synonyms WHERE ...
A table expression allows one to have, effectively, an in-line view instead of a table, etc in the FROM clause. The syntax of a table expression is: (subselect) AS correlation-name
for example: SELECT B.DBNAME, B.NAME FROM (SELECT DBID, MIN(OBID) AS MOBID FROM SYSIBM.SYSTABLESPACE GROUP BY DBID) AS A, SYSIBM.SYSTABLESPACE B WHERE A.DBID = B.DBID AND A.MOBID = B.OBID [...]
9260 13 49_Barb Ferguson/DASIMS/NEBRLN is out of the office.13_Barb Ferguson26_bferguso@NOTES.STATE.NE.US30_Wed, 4 Oct 2000 01:00:22 -0500336_us-ascii I will be out of the office starting 10/04/2000 and will not return until 10/18/2000.
================================================ 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.
9274 15 44_Pamela Harris/IT/SEARS is out of the office.0_17_pharri1@SEARS.COM30_Wed, 4 Oct 2000 01:53:03 -0500447_us-ascii I will be out of the office from 10/04/2000 until 10/10/2000.
If you need assistance with DB2, use PIN # 7270526, for informix/sqlserver use PIN # 7270525, network issues use PIN # 7271038.
================================================ 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.
9290 41 28_Re: COMMON TABLE EXPRESSIONS17_Valerie J Traurig18_valeriet6@JUNO.COM31_Fri, 23 Apr 1999 07:08:58 -0400408_- Common table expressions can only be used with the DB2 UDB for UNIX, Windows and OS/2 product. Although nested table expressions can be found on the OS/390 platform, common table expressions are not.
Don Chamberlain's A Complete Guide to DB2 UDB has a good explanation with examples although it is not current (V5). You can also get the syntax from the SQL Reference manual (SC09-2847 for V6). [...]
9332 67 42_Re: Urgent help - problem after v5 upgrade9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Wed, 4 Oct 2000 08:15:50 +0100511_us-ascii No, it does affect existing type 1 indexes. It just sets the default for new index creations when the type is not specified explicitly. Kind Regards, Andy Hunt - Scottish And Southern Energy
Srirengan Venkatesh Kumar <"SRIRENGAN_VENKATESH_KUMAR/IRAS"@IRAS.GOV.SG> on 04/10/2000 03:11:09
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Re: Urgent help - problem after v5 upgrade [...]
9400 18 33_Re: Question Reg. Bufferpool Tool14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Wed, 4 Oct 2000 09:41:07 +0100454_us-ascii If you are using SMS, did you consider hardware compression ? We collect a lot of SMF record in compressed flat files with DATACLAS=COMPRESS using S/390 hardware compression.
HTH
Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9419 87 40_Re: e(logo)series - the new IBM branding15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Wed, 4 Oct 2000 10:00:28 +0200425_iso-8859-1 James,
I am wondering whether IBM has feeling for a strong brandname. Everytime they have established a name they come up with a new one. But I have to admit, at least they broadcast it to theworld. I've seen other places... IBM is more like a cameleon, changing their brands as they have a mood-swing.. Remember DB2, UDB, DB2 for wendex, DB2 for whatever... I hope they won't change the name for DB2! [...]
9507 53 13_RECURSIVE SQL19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW30_Thu, 5 Oct 2000 04:30:46 +0800234_big5 HI : ALL I don't known what is recursive sql , so any one can tell me : 1. in use os/390 , NT, AIX or ....others platfrom 2. I can reference DB2 manual , book no.... 3. use in DB2 versions , how about to use rescursive sql THANKS
9561 51 27_Re: Table/Index statistics.20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM30_Wed, 4 Oct 2000 09:18:46 +0100308_iso-8859-1 You get a decimal fraction. Multiply it by 100 if you want a percentage.
Once you've done that then, yes, 10% is a reasonable value to choose as your threshold but your question sugests you are at an early stage in understanding this subject and there is a great deal more to be said! [...]
9613 50 55_Differences between DB2 for OS/390 and DB2 for OS/400 ?12_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 4 Oct 2000 11:53:27 +0200396_iso-8859-1 Hello Listers.
For all our Smalltalk app's is DB2 for OS/390 Release 5 the database of choice. So we've prepared the whole environment (data definition language, DBRM's, programs etc.) for DB2 for OS/390....
One of our IT centers wants to install this Smalltalk-NT-application - and they already have a DB2 for OS/400, Release 4.2 subsystem (and no DB2 for OS/390). [...]
9664 195 50_Re: 00C90101 erqual 5007 after migrate to DB2 V5.118_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Wed, 4 Oct 2000 06:33:02 -0400527_iso-8859-1 Rob: I agree. I used DSN1PRNT to create an outlist for me of the index header. Then I just looked for the parm HPGPARTN and in the cases where the index was bad the value in this flag was set to something like HPGPARTN = '0008'X. The '8' being for the 8 partitions of the tablespace. I also checked the HPGIFLGS value and this was usually something other than '00'X. Either case, once I put on the CA hiper and did a Rapid Reorg against the index and went back in these 2 parm values were set correctly. I wish [...]
9860 74 43_DB2s own support for defer defined pagesets14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 4 Oct 2000 12:22:42 +0100376_iso-8859-1 Apologies if this has been raised before.
I just created a tablespace in one of our DB2 V6 subsystems with the "DEFINE NO" keywords to defer creation of the underlying VSAM pagesets until the table has data in it.
I then tried to image copy the tablespace and got:
DSNU185I !S61A DSNUGSRI - THE VSAM DATA SET DOES NOT EXIST FOR TABLESPACE [...]
9935 62 7_db2/udb13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET30_Wed, 4 Oct 2000 08:01:48 -0400580_us-ascii I am using DB2/UDB version 6.0 on solaris....with windows nt workstation. I am having a problem using Visual Basic v6.0 and connected via odbc. I can connect just fine. In fact the app. was working fine until changes were requested adding new fields to the database. Now, on an insert I get SQL0010N returned (sqlstate 42603) saying that the field (which it does not say) has missing delimiters. All fields have proper delimiters. I can start from the bottom of the insert list and comment out each field until I reach the one where the insert goes thru normally. I [...]
9998 37 47_Re: DB2s own support for defer defined pagesets24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM30_Wed, 4 Oct 2000 08:25:10 -0400544_iso-8859-1 Phil - am I missing something....why would you try to IC a non-existent tablespace ?
-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: Wednesday, October 04, 2000 7:23 AM To: DB2-L@RYCI.COM Subject: DB2s own support for defer defined pagesets
Apologies if this has been raised before.
I just created a tablespace in one of our DB2 V6 subsystems with the "DEFINE NO" keywords to defer creation of the underlying VSAM pagesets until the table has data in it. [...]
10036 170 47_Re: DB2s own support for defer defined pagesets14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 4 Oct 2000 14:05:53 +0100475_iso-8859-1 I guess you wouldn't if you knew it was empty
However, with many ERP apps, it is not clear which tablespaces are empty and which ones aren't, so people tend to create COPY TABLESPACE statements for ALL tablespaces in a database or created by the same ID.
In this case, I would expect COPY to put a row into SYSCOPY indicating that at this log RBA, the tablespace was undefined (and hence empty). If it did, imagine how fast RECOVERy would be!!! [...]
10207 15 47_Re: DB2s own support for defer defined pagesets12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Wed, 4 Oct 2000 08:25:03 -0500446_us-ascii We have also implemented the DEFINE NO parameter. Saved about 3 GIG in DASD. We went from 25,000 datasets to about 12,000. Cut our imagecopy time in half, runstats the same. We use BMC Copy Plus.
================================================ 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.
10223 19 47_Re: DB2s own support for defer defined pagesets0_29_paul.packham@POSTOFFICE.CO.UK30_Wed, 4 Oct 2000 14:55:54 +0000525_us-ascii Phil,
I've been through the loop with IBM on this. You might want to check out PQ30999 which details all the utilities which you can/cannot run when using this feature. I have raised a design request to see if this issue can be addressed quickly.
Regards, Paul
================================================ 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.
10243 102 47_Re: DB2s own support for defer defined pagesets14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 4 Oct 2000 14:41:41 +0100347_iso-8859-1 Presumably you are only selecting the DEFINED datasets for RUNSTATS as you cannot RUNSTATS an undefined tablespace (I just tried).
I'm also presuming that you are selectively copying the tablespaces with Copy Plus too - otherwise I'd be intrigued to know what BMC are putting in SYSCOPY!!! (but I bet no-one tells me......) [...]
10346 29 17_db2-rexx question16_Isenhour, Amy F.27_afisenhour@NOVANTHEALTH.ORG30_Wed, 4 Oct 2000 10:00:10 -0400710_iso-8859-1 Sending on behalf of wayne,
Newbie using rexx/db2. Does anyone have any examples showing how to insert a lot of variables, greater than 250 characters in length, into DB2. I'm stuck. Getting the following error:
627 +++ ADDRESS DSNREXX "EXECSQL EXECUTE S1 USING :SERVER_NAME,:CLIENT, :PLATFORM,:DATE_STARTED,:TIME_STARTED, :OBJECTS_INSPECTED,:OBJECTS_BACKED_UP,:OBJECTS_UPDATED,:OBJECTS_REBOUND,:OBJ ECTS_DELETED,:OBJECTS_FAILED,:BYTES_TRANSFERRED,:BYTES_XFER_IN_KB, :DATA_TRANSFER_TIME,:NETWORK_XFER_RATE,:AGGREGAT_XFER_RATE, :OBJECT_COMPRESS_BY,:PROCESSING_TIME,:ANS4007E_NUM,:BACKUP_STATUS, :JOB_NAME" IRX0030I Error running TSMBKUP#, line 627: Name or string > 250 characters [...]
10376 215 28_Re: COMMON TABLE EXPRESSIONS9_Mark Ruhe19_Mark.Ruhe@QUEST.COM30_Wed, 4 Oct 2000 07:01:39 -0700370_iso-8859-1 Common table expressions are similar to inline views (i.e.. Select * from (select * from tab) ). An example would be;
With mytab (column_list) as (select column_list from table) select * from mytab
These can be recursive in nature if the common table expression references itself. Examples of this can be found in the UDB reference guides. [...]
10592 72 78_Re: Problem with utilities executing against wrong library and no t fi nishing12_Sue Janowitz18_SJanowitz@NEFN.COM30_Wed, 4 Oct 2000 10:08:24 -0400390_us-ascii No sure ideas, and I suspect you're out of this by now, but I'll give it a try since no one else answered.
1. Can you get into your computer room to see what's happening on the console? 2. If maintenance caused jobs to take hours to run, then either: a- they were hung up trying to access a dataset b- could the maintenance have introduced a bug in DB2 causing a loop? [...]
10665 112 47_Re: DB2s own support for defer defined pagesets14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 4 Oct 2000 15:14:35 +0100490_iso-8859-1 Thanks Paul,
Yes - I checked the APAR and I am left wondering if this is one of those "implemented in more than one part" type enhancements, but as you say IBM seem to be saying that this is all the support that there is or will be
Phil G
-----Original Message----- From: paul.packham@POSTOFFICE.CO.UK [mailto:paul.packham@POSTOFFICE.CO.UK] Sent: 04 October 2000 15:56 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2s own support for defer defined pagesets [...]
10778 119 21_Re: db2-rexx question0_18_mebert@AMADEUS.NET30_Wed, 4 Oct 2000 16:21:45 +0200730_us-ascii This is a REXX error. REXX strings have a maximum length of 250 chars. Try using multiple strings, viz.:
ADDRESS DSNREXX "EXECSQL EXECUTE S1 USING :SERVER_NAME,:CLIENT," , ":PLATFORM,:DATE_STARTED,:TIME_STARTED,:OBJECTS_INSPECTED," , ":OBJECTS_BACKED_UP,:OBJECTS_UPDATED,:OBJECTS_REBOUND," , ":OBJECTS_DELETED,:OBJECTS_FAILED,:BYTES_TRANSFERRED," , ":BYTES_XFER_IN_KB,:DATA_TRANSFER_TIME,:NETWORK_XFER_RATE," , ":AGGREGAT_XFER_RATE,:OBJECT_COMPRESS_BY,:PROCESSING_TIME," , ":ANS4007E_NUM,:BACKUP_STATUS,:JOB_NAME"
I.e. use one constant quoted string per line, and continue the statement onto the next line by the trailing comma outside of the string. This continuation is legal where a blank would be. [...]
10898 76 47_Re: DB2s own support for defer defined pagesets15_Murley, Michael22_Michael_Murley@BMC.COM30_Wed, 4 Oct 2000 09:26:49 -0500559_iso-8859-1 I couldn't pass up a chance to take Phil's bet (It's all very public knowledge anyway :~).
BMC COPY PLUS and RECOVER PLUS both support DEFINE NO table spaces and indexes, but we don't put anything in SYSCOPY when you try to copy one. Instead, we just issue a message and bypass the space. I can't see any reason to create any recovery resources for an empty space, but I also wouldn't want the job to fail. RECOVER PLUS also just bypasses a DEFINE NO space. Things are a bit more complicated when COPY is requested to perform a quiesce [...]
10975 14 47_Re: DB2s own support for defer defined pagesets12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Wed, 4 Oct 2000 09:34:31 -0500451_us-ascii Actually, we developed a program to create RUNSTATS control statements for tables where the space column is greater than -1. We are not selectively imagecopying tablespaces though. We us BMC for that.
================================================ 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.
10990 353 22_Visual Explain Problem13_Michael Fleck14_m.fleck@LVR.DE30_Wed, 4 Oct 2000 09:45:02 +01001057_ISO-8859-1 Hi list members,
i've got a problem concerning Visual Explain.
When I try to connect to a subsystem I got the error message:
Runtime error: Primitive failed in: PlatformFunction>>#callWithArguments: due to OS error 126 See the walkbacklog for more information.
Content of the walkback.log:
------------------------------------------------------------------------------------------------------------------------------------------- Walkback at 08:42:19 on 04.10.2000 Primitive failed in: PlatformFunction>>#callWithArguments: due to OS error126 [] in EpRuntimeStartUp class(EsWindowSystemStartUp class)>>#outputWalkback:process: receiver = EpRuntimeStartUp arg1 = 'Primitive failed in: PlatformFunction>>#callWithArguments: due to OS error126' arg2 = Process:168154{running,3} temp1 = 'walkback.log' temp2 = -1 temp3 = a CfsWriteFileStream EsCompactBlockContextTemplate(Block)>>#valueWithErrorHandler:oldHandler:onReturnDo: receiver = [] in EsWindowSystemStartUp class>>#outputWalkback:process: arg1 = [] in [...]
11344 19 16_Db2 On the MacOS12_John Donahue28_john.donahue@DONOVANDATA.COM30_Wed, 4 Oct 2000 09:53:13 -0500578_- At my company were are looking at migrating and existing application which is based on MS-SQL to Db2/390 to provide more direct access to our legacy data(and remove some extraction layers). We have run into a problem in that the existing application supports both Win32 and MacOS 8 but IBM has pulled support for the Mac runtime client leaving us with a hole in the conversion effort. Does anyone out there support MacOS clients in their application enviroment? What are the possible solutions to allow our MacOS users to work in a Db2 enviroment given the lac of an IBM [...]
11364 97 78_Re: Problem with utilities executing against wrong library and no t fi nishing14_McCombs, Terry20_tmccomb@SEDGWICK.GOV30_Wed, 4 Oct 2000 10:55:18 -0500548_- Thanks for answering, Sue.
We never did determine exactly why the jobs were hung. They didn't seem to be using CPU or doing I/O, so I don't think they were in a loop. We resolved the problem by bringing down the DB2 address space (STOP still wanted to wait for the rollback to complete) and bringing DB2 back up. That's it. (Surprised us!) When it came up, DB2 did not try to resolve the rollback. The two utilities were pending (in the image copy, so the quiesce had run OK), and I just terminated them. We've since pointed the jobs [...]
11462 74 40_Re: e(logo)series - the new IBM branding0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 4 Oct 2000 11:07:00 -0500408_us-ascii Remeber, this name change is brought to you by the same brilliant marketing organization that "took care of" the IBM PC, PC Jr., OS/2, and the various flavours of DB2 as Jaap points out, etc. .
I would be interested to learn what the rational is for the new prefixes "z/p/i". Are they shortforms for some name relating to the various platforms, or are they just 'pulled out of the air'? [...]
11537 111 32_Re: Performance on View vs Table14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Wed, 4 Oct 2000 11:11:41 -0500496_iso-8859-1 Mike:
Just read through your post this morning (I subscribe to the DIGEST) and thought I'd comment. I can understand why you're doing what you're doing and actually it basically conforms to one of the "good" reasons for view usage that I cite in the article (http://www.craigsmullins.com/viewnw.htm). You are using views to rename awkwardly named tables. In the article I use an example of renaming awkwardly named columns, not tables, but the general concept is the same. [...]
11649 19 18_Hints to optimizer16_Trivedi, Kaushal17_c_triveka@BAM.COM30_Wed, 4 Oct 2000 08:59:25 -0700502_iso-8859-1 Hi All, I would like to take a look at a sample to provide hints to the optimizer, if anyone has one could you share it with me, I would like to tell the optimizer to pick up another index than what its using.
thank you
Kaushal Trivedi
================================================ 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.
11669 270 47_Re: DB2s own support for defer defined pagesets14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 4 Oct 2000 17:26:05 +0100502_iso-8859-1 Thanks Michael,
I would be interested, though, to know what the customers think of having a "copy" of an undefined tablespace registered in SYSCOPY. After all, this IS a valid point of recovery - the tablespace is EMPTY (which also makes it damn easy to recover!!)
Phil G
-----Original Message----- From: Murley, Michael [mailto:Michael_Murley@BMC.COM] Sent: 04 October 2000 15:27 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2s own support for defer defined pagesets [...]
11940 92 40_Re: e(logo)series - the new IBM branding19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 4 Oct 2000 11:41:18 -0500588_iso-8859-1 Jeez, this branding thing should be obvious to all -- ya gotta have a small letter in front of any name now-a-days or ya ain't eKEWL (that means cool to all you dinosaurs, lol)!!!!!!
HTH, Rick Davis <----- laughing
"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 [...]
12033 117 40_Re: e(logo)series - the new IBM branding12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Wed, 4 Oct 2000 19:57:50 +0200494_iso-8859-1 Hi, I see a problem here. If "Z" is for the new 64 bit OS then what'll we have for the 128 bit OS ? ;-))
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Slot, JP (Jaap)" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, October 04, 2000 10:00 AM Subject: Re: e(logo)series - the new IBM branding [...]
12151 106 40_Re: e(logo)series - the new IBM branding14_Laredo, Andrew19_Andy_Laredo@BMC.COM30_Wed, 4 Oct 2000 11:55:23 -0500441_iso-8859-1 Z=zero down time
-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Wednesday, October 04, 2000 12:07 PM To: DB2-L@RYCI.COM Subject: Re: e(logo)series - the new IBM branding
Remeber, this name change is brought to you by the same brilliant marketing organization that "took care of" the IBM PC, PC Jr., OS/2, and the various flavours of DB2 as Jaap points out, etc. . [...]
12258 120 40_FW: e(logo)series - the new IBM branding12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Wed, 4 Oct 2000 13:06:11 -0400488_iso-8859-1 P=perfectly priced ; I=inexpensive ?
-----Original Message----- From: Laredo, Andrew [mailto:Andy_Laredo@BMC.COM] Sent: Wednesday, October 04, 2000 12:55 PM To: DB2-L@RYCI.COM Subject: Re: e(logo)series - the new IBM branding
Z=zero down time
-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Wednesday, October 04, 2000 12:07 PM To: DB2-L@RYCI.COM Subject: Re: e(logo)series - the new IBM branding [...]
12379 74 45_Re: FYI: e(logo)series - the new IBM branding22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Wed, 4 Oct 2000 10:36:44 -0400734_iso-8859-1 So, can we expect DB2 for z/OS in the future releases of DB2 for OS/390?
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Tuesday, October 03, 2000 19:24 To: DB2-L@RYCI.COM Subject: [DB2-L] FYI: e(logo)series - the new IBM branding
> IBM has announced a major rebranding: > > 1) Many things come under the <<...>> brand. <<...>> can be written > "e(logo)server". (In case the embedded graphic doesn't make it through > the e-mail system, "e(logo)" is a lower case 'e' with the tail extended up > and over and around the body in the same [...]
12454 21 40_Re: e(logo)series - the new IBM branding13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Wed, 4 Oct 2000 10:05:00 -0700344_- > I am wondering whether IBM has feeling for a strong brandname. Everytime > they have established a name they come up with a new one.
Behind that impervious dark blue suit is a very warped mind, it seems.
> I hope they won't change the name for DB2!
What? Surely you know that the upgrade path for DB2 v9.9 is DB3. [...]
12476 143 40_Re: e(logo)series - the new IBM branding10_Ben Marino19_bmarino@NEONSYS.COM30_Wed, 4 Oct 2000 11:52:44 -0500502_us-ascii Ben Marino@NEON 10/04/2000 11:52 AM
That would be "EZ"
Isaac Yassin on 10/04/2000 11:57:50 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Ben Marino/Dev/Neon)
Subject: Re: e(logo)series - the new IBM branding
Hi, I see a problem here. If "Z" is for the new 64 bit OS then what'll we have for the 128 bit OS ? ;-)) [...]
12620 25 30_Oracle replacement for DB2 QMF11_James Stoll27_James_H_Stoll@FMSO.NAVY.MIL30_Wed, 4 Oct 2000 13:28:35 -0400441_US-ASCII Don't beat me up for asking an Oracle question on the DB2 listserver, my manager asked me to pose the question. I am seeking information about Oracle Internet Developer Suite. I am told that packaged within this software suite is software that can go against a DB2 database and could be used as a replacement for QMF at a cheaper cost. I would appreciate any information, experiences anyone may have using this product in DB2. [...]
12646 21 25_Re: DB2 Opportunity in NC8_Bob Abad16_BobRabad@AOL.COM28_Wed, 4 Oct 2000 13:34:04 EDT580_ISO-8859-1 Bruce,
You might want to consider joining IBM e-Commerce group where they have a 'work anywhere' approach with periodic travel to clients, or business partners??.
There you can practice your DB2 DBA skills, learn Java, XML, WebShpere, and many others.
Go to: www.ibm.com to start...
Hope this helps!
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12668 45 12_Re: Geo-plex14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Wed, 4 Oct 2000 13:00:32 -0400648_iso-8859-1 Ron,
Check out now Tracker site recovery. GPDS and Tracker now offer many options now.
Hope this helps, Richard Yevich
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Rohn.Solecki@MTS.MB.CA > Sent: Monday, October 02, 2000 12:39 PM > To: DB2-L@RYCI.COM > Subject: Geo-plex > > > I just read the following article, "Geoplex: Exploiting the Concept of > Multi-site Recovery", by Susan Lawson and Richard Yevich in The IDUG > Solutions Journal, August 1998 - Volume 5, Number 2. > > If I interpretted the article correctly, Geoplex would only work with a > [...]
12714 83 49_Re: Using Java and Stored Procedures and DB2 KEYS19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 4 Oct 2000 13:38:20 -0500615_iso-8859-1 Myron, Boy, are you going to stir up a hornets nest on this issue -- very good!
I think you'll find that OO and UML design will usually include surrogate keys (automatically generated or not) for every dataClass -- its just the way its "preached to the masses". The "discipline" makes the assumption that all entities can benefit from their use. Well, as you are probably aware, there are very few business requirements that need the support of surrogate keys, however, when needed, they do offer tremendous advantage and should be used without hesitation. A perfect example of attempting to [...]
12798 17 49_Re: Using Java and Stored Procedures and DB2 KEYS26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Wed, 4 Oct 2000 13:45:23 -0500460_- In yesterday's announcements, IBM announced z/OS and a herd of new 2064 processors for 64 bit addressing. Also announced the abandonment of SOM. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu
================================================ 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.
12816 24 49_Re: Using Java and Stored Procedures and DB2 KEYS13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 4 Oct 2000 14:55:31 -0400380_iso-8859-1 There was a brief, informative discussion of the evils of using surrogate keys here around a year ago-- actually closer to Halloween.
Search the Archives in October 1999 for RE: Data Warehouse and surrogate keys.
See especially Richard Yevich's and Michael Hannan's posts.
((it's always nice having such recognized authorities agree with me)) [...]
12841 35 40_Re: e(logo)series - the new IBM branding15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV30_Wed, 4 Oct 2000 14:55:46 -0400395_iso-8859-1 Probably "H", since its all Greek to me :O
Bill Blaney
-----Original Message----- From: Isaac Yassin [mailto:yassin@NETVISION.NET.IL] Sent: Wednesday, October 04, 2000 1:58 PM To: DB2-L@RYCI.COM Subject: Re: e(logo)series - the new IBM branding
Hi, I see a problem here. If "Z" is for the new 64 bit OS then what'll we have for the 128 bit OS ? ;-)) [...]
12877 127 40_Re: e(logo)series - the new IBM branding12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM30_Wed, 4 Oct 2000 15:26:37 -0400518_us-ascii If "Z" is for 64 bit, "ZZ" is for 128 bit and 256 bit is called "ZZ TOP"!
OK, somebody shoot me.
M.
Isaac Yassin wrote:
> Hi, > I see a problem here. > If "Z" is for the new 64 bit OS then what'll we have for the 128 bit OS ? > ;-)) > > Isaac Yassin > DBMS & IT Consultant > > Email: yassin@netvision.net.il > > Tel : +972 9 9505172 > Cell: +972 54 452793 > Fax : +972 9 9560803 > ----- Original Message ----- > From: "Slot, JP (Jaap)" > Newsgroups: [...]
13005 47 16_IDENTITY columns11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Wed, 4 Oct 2000 14:26:29 -0500439_us-ascii Hello DB2 Land!
We are OS/390 2.6 and DB2 6.1. We have applied all the needed PTF's to make IDENTITY columns work but, it does not! Does anyone know what modifies the DB2 catalog to add the necessary Tablespaces and Tables to make IDENTITY columns work?
Signed, Wemissedapiece!.... : )
---------------------- Forwarded by Jeff Faughn/MDSC/MAYCO on 10/04/2000 02:18 PM --------------------------- [...]
13053 23 38_IRLM dispatching priorities under WLM.12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM30_Wed, 4 Oct 2000 15:41:58 -0400321_us-ascii Hi everyone,
Our sysprogs recently went to Work Load Manager and set both the main DB2 address spaces and IRLM to SYSSTC service class. The DB2 books always said that IRLM must dispatch higher than the other DB2 address spaces.
Will this give us problems now that we are running tight on CPU? [...]
13077 60 20_Re: IDENTITY columns13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 4 Oct 2000 15:53:37 -0400312_iso-8859-1 Hi Jeff, Looks like the same thing happened at your place as happened at mine.
In a nutshell, the person applying PQ30652 or one of the others missed a step or 2.
Here's IBM's response when I had the same symptoms as you. It just pointed to doc in the HOLD information for UQ38405. [...]
13138 96 20_Re: IDENTITY columns0_22_BILL_GALLAGHER@PHL.COM30_Wed, 4 Oct 2000 16:01:28 -0400569_us-ascii Jeff,
Our systems programmer installed support for identity columns when we went to v6 back in April/May . . . the APAR is PQ30652, and the PTF is UQ38405 . . . as far as I know, he didn't have to do anything else . . . the new catalog tables that are needed are SYSIBM.SYSSEQUENCES and SYSIBM.SYSSEQUENCESDEP . . . maybe somebody forgot to run a step in the installation of this PTF to create these tables? I know that we've encountered similar problems when applying PTF's that added other new functionality to v6, where our sysprogs "forgot" to [...]
13235 23 9_Batch SQL16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU30_Wed, 4 Oct 2000 16:09:12 -0400510_iso-8859-1 We're using dsntiaul in batch to run a query. The query is to select * from tabla where col1 in ('0000000','00000005',.....) for a total of over 5,000 constants. Every time I run it, it fails on the 455th constant with a -010, The string constant beginning '0000 is not terminated. I've gone ahead and broken the query up into an 'in list' of 444 numbers and it works fine. Is there a limitation as to how many constants you can have in an 'in list' and if so, is there a way to get around it? [...]
13259 51 49_Re: Using Java and Stored Procedures and DB2 KEYS12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 4 Oct 2000 13:14:26 -0700615_us-ascii I am 99% against them as well. The problem is the issue with JAVA and EJB and objects and the implication that they are required for object integrity.
I don't know enough about JAVA and Enterprise Java Beans with UML (objects) to say. Fundamentally, whereever possible, I personally avoid them like the plague. --- "Seibert, Dave" wrote: > There was a brief, informative discussion of the > evils of using surrogate > keys here around a year ago-- actually closer to > Halloween. > > Search the Archives in October 1999 for > RE: Data Warehouse and surrogate keys. [...]
13311 15 40_Re: e(logo)series - the new IBM branding26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Wed, 4 Oct 2000 15:16:24 -0500354_- With or without the cheap sun glasses? Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu
================================================ 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.
13327 55 8_rexx/db216_Isenhour, Amy F.27_afisenhour@NOVANTHEALTH.ORG30_Wed, 4 Oct 2000 16:20:34 -04001250_iso-8859-1 Need some assistance please. I have a decimal value (123.45) I'm trying to insert into a DB2 column type decimal (24,2). I get a -804 08. I can insert this value thru SPUFI with no problem. Below are the details... thanks wayne
/* rexx */ . . SQLSTMT = , 'INSERT INTO WMS001.TSM_BACKUP_DATA ' , '(SERVER_NAME,CLIENT,PLATFORM,DATE_STARTED,TIME_STARTED,' , 'OBJECTS_INSPECTED,OBJECTS_BACKED_UP,OBJECTS_UPDATED,OBJECTS_REBOUND,' , 'OBJECTS_DELETED,OBJECTS_FAILED,BYTES_TRANSFERRED,BYTES_XFER_IN_KB,' , 'DATA_TRANSFER_TIME,NETWORK_XFER_RATE,AGGREGAT_XFER_RATE,' , 'OBJECT_COMPRESS_BY,PROCESSING_TIME,BYPASS_ANS4007E,ANS4007E_NUM,' , 'BACKUP_STATUS,JOB_NAME) ' , 'VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' . . BYTES_TRANSFERRED_IN_KB = 123.45 . . ADDRESS DSNREXX "EXECSQL EXECUTE S1 USING :SERVER_NAME,:CLIENT," , ":PLATFORM,:DATE_STARTED,:TIME_STARTED," , ":OBJECTS_INSPECTED,:OBJECTS_BACKED_UP,:OBJECTS_UPDATED," , ":OBJECTS_REBOUND,:OBJECTS_DELETED,:OBJECTS_FAILED," , ":BYTES_TRANSFERRED,:BYTES_TRANSFERRED_IN_KB,:DATA_TRANSFER_TIME," , ":NETWORK_DATA_TRANSFER_RATE,:AGGREGATE_DATA_TRANSFER_RATE," , ":OBJECTS_COMPRESSED_BY,:ELAPSED_PROCESSING_TIME," , ":BYPASS_ANS4007E,:ANS4007E_NUM,:BACKUP_STATUS," , ":JOB_NAME" [...]
13383 42 13_Re: Batch SQL24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Wed, 4 Oct 2000 13:22:54 -0700554_- I believe the limit is on the number of bytes, not the number of entries. I did not look it up, but I think the limit is 4096 bytes.
> -----Original Message----- > From: Dempsey, Michael [SMTP:MDempse@UNCH.UNC.EDU] > Sent: Wednesday, October 04, 2000 1:09 PM > To: DB2-L@RYCI.COM > Subject: Batch SQL > > We're using dsntiaul in batch to run a query. The query is to select * > from > tabla where col1 in ('0000000','00000005',.....) for a total of over 5,000 > constants. Every time I run it, it fails on the 455th constant with a > -010, [...]
13426 29 40_Re: e(logo)series - the new IBM branding19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Wed, 4 Oct 2000 13:26:54 -0700624_iso-8859-1 Different hardware vendor...
-----Original Message----- From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] Sent: Wednesday, October 04, 2000 1:16 PM To: DB2-L@RYCI.COM Subject: Re: e(logo)series - the new IBM branding
With or without the cheap sun glasses? Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu
================================================ 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. [...]
13456 58 13_Re: Batch SQL13_ATKINS, BRIAN17_BRIATK@SAFECO.COM30_Wed, 4 Oct 2000 13:18:22 -0700339_iso-8859-1 Here is the IBM Explanation, But if you have terminated it properly, then there is obviously a limitation, you might ask yourself, why do I have 5000 constants in a "in" clause, write the SQL in a join fashion, etc., a select * in batch is a big negative!
-010 THE STRING CONSTANT BEGINNING string IS NOT TERMINATED [...]
13515 18 13_Re: Batch SQL13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Wed, 4 Oct 2000 13:33:24 -0700449_- > where col1 in ('0000000','00000005',.....) > for a total of over 5,000 constants.
Uh, wouldn't it be easier to create a temporary table with one field (as a primary key) and do a join?
-HJC
================================================ 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.
13534 74 12_Re: rexx/db213_Horacio Villa17_hvilla@TTI.COM.AR30_Wed, 4 Oct 2000 17:41:22 -0300574_iso-8859-1 I think your problem is in the value you have for objects_updated, which is the 8th host variable. Horacio
-----Mensaje original----- De: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]En nombre de Isenhour, Amy F. Enviado el: Miércoles 4 de Octubre de 2000 17:21 Para: DB2-L@RYCI.COM Asunto: rexx/db2
Need some assistance please. I have a decimal value (123.45) I'm trying to insert into a DB2 column type decimal (24,2). I get a -804 08. I can insert this value thru SPUFI with no problem. Below are the details... thanks wayne [...]
13609 34 13_Re: Batch SQL12_Tal Lifshitz21_Tal.Lifshitz@MSDW.COM30_Wed, 4 Oct 2000 16:36:54 -0400566_us-ascii You can create a global temporary table, populate the table with the 5000 values, and then join the two tables.
Tal
"Dempsey, Michael" wrote:
> We're using dsntiaul in batch to run a query. The query is to select * from > tabla where col1 in ('0000000','00000005',.....) for a total of over 5,000 > constants. Every time I run it, it fails on the 455th constant with a -010, > The string constant beginning '0000 is not terminated. I've gone ahead and > broken the query up into an 'in list' of 444 numbers and it works fine. Is > [...]
13644 67 39_Re: DB2 Connect V6.1 and DB2/OS390 V5.113_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Wed, 4 Oct 2000 11:42:52 -0500471_iso-8859-1 Robert,
Thanks for the reference to II12269. Interesting. However I believe you can turn off connection pooling in 6.1 (which is on by default upon installation) by issuing:
UPDATE DBM CFG USING NUM_POOLAGENTS 0
HTH Dave
-----Original Message----- From: Hall, Robert [mailto:Robert.Hall@OCC.TREAS.GOV] Sent: Tuesday, October 03, 2000 4:22 PM To: DB2-L@RYCI.COM Subject: DB2 Connect V6.1 and DB2/OS390 V5.1 Sensitivity: Private [...]
13712 32 26_DB2 Connect and 432 Error?13_Tierney, Mark20_mtierney@FIRSTAM.COM30_Wed, 4 Oct 2000 16:03:52 -0500454_- Greetings....
I am attempting to install the DB2 Connect V7 Runtime client on Windows 2000 and am receiving the following message:
432 : SETUP has determined that UnInstall shield is in use. Please close UnInstall shield and re-start.
If I sign on as Admin this problem does not occur. In going over the doc it looks as if Admin is not required. Am I missing something? Can anyone shed any light on the message or occurrence? [...]
13745 21 40_Re: e(logo)series - the new IBM branding13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Wed, 4 Oct 2000 16:13:49 -0500324_- On Wed, 4 Oct 2000 19:57:50 +0200, Isaac Yassin wrote:
>Hi, >I see a problem here. >If "Z" is for the new 64 bit OS then what'll we have for the 128 bit OS ? >;-)) >
128 bit !? What are you talking about ? 64 bit is "more than ANYbody is ever going to need" !!! HA ! HA ! HA ! [...]
13767 85 20_Re: IDENTITY columns11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Wed, 4 Oct 2000 16:29:36 -0500489_us-ascii Dave, That did the trick! Thanks for your help!... : )
From: "Seibert, Dave" @RYCI.COM> on 10/04/2000 02:53 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Fax to: Subject: Re: IDENTITY columns
Hi Jeff, Looks like the same thing happened at your place as happened at mine. [...]
13853 140 40_Re: e(logo)series - the new IBM branding25_Robinson, Peter [IBM GSA]33_Peter.J.Robinson@TEAM.TELSTRA.COM30_Thu, 5 Oct 2000 08:29:33 +1100771_iso-8859-1 Hi all
Here's a snippet from a blurb we got yesterday:
---------------------------------------------------------- From today, the IBM family will be divided into four groups suited for the specific needs of e-business infrastructures: IBM zSeries (for zero downtime) -- the most reliable, mission-critical data and transaction server on earth; IBM pSeries (for performance) -- the most powerful, technologically advanced UNIX server; IBM iSeries (for integrated system) -- the high performance, integrated business server for mid-market companies; IBM xSeries (for x-architecture) -- the affordable, Linux-ready, Intel-based server with mainframe-inspired reliability technologies. ---------------------------------------------------------- [...]
13994 161 40_Re: e(logo)series - the new IBM branding14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU30_Thu, 5 Oct 2000 08:32:51 +1100493_iso-8859-1 Well it looks like the truth is going to slip out.
The real reason for the z/OS to gently introduce people to the reality of the best place to live, work and do business. The further stages of this will the subtle name changes to Z/Os and then Oz.
-----Original Message----- From: Robinson, Peter [IBM GSA] [mailto:Peter.J.Robinson@TEAM.TELSTRA.COM] Sent: Thursday, 5 October 2000 8:30 To: DB2-L@RYCI.COM Subject: Re: e(logo)series - the new IBM branding [...]
14156 27 17_Re: RECURSIVE SQL14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU30_Thu, 5 Oct 2000 08:40:28 +1100505_big5 There's an article by Sheryl Larsen on the ryci.com site which discusses this.
-----Original Message----- From: A000896@MS.SKH.ORG.TW [mailto:A000896@MS.SKH.ORG.TW] Sent: Thursday, 5 October 2000 7:31 To: DB2-L@RYCI.COM Subject: RECURSIVE SQL
HI : ALL I don't known what is recursive sql , so any one can tell me : 1. in use os/390 , NT, AIX or ....others platfrom 2. I can reference DB2 manual , book no.... 3. use in DB2 versions , how about to use rescursive sql THANKS [...]
14184 182 40_Re: e(logo)series - the new IBM branding22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Wed, 4 Oct 2000 18:01:23 -0400633_iso-8859-1 Dorothy's Oz or HBO's Oz?
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Tennant, Steve [mailto:Steve.Tennant@ATO.GOV.AU] Sent: Wednesday, October 04, 2000 17:33 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] e(logo)series - the new IBM branding
Well it looks like the truth is going to slip out.
The real reason for the z/OS to gently introduce people to the reality of the best place to live, work and do business. The further stages of this will the subtle name changes to Z/Os and then Oz. [...]
14367 206 40_Re: e(logo)series - the new IBM branding22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Wed, 4 Oct 2000 18:11:01 -0400435_iso-8859-1 For those not in the States, HBO is a cable TV network that has a series named Oz about a maximum security prison named Oz.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Piontkowski Michael ML Sent: Wednesday, October 04, 2000 18:01 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] e(logo)series - the new IBM branding [...]
14574 45 42_Re: IRLM dispatching priorities under WLM.15_Jim Lewandowski22_jlewand@STARNETINC.COM30_Wed, 4 Oct 2000 17:51:47 -0500323_iso-8859-1 > Hi everyone, > > Our sysprogs recently went to Work Load Manager and set both the main DB2 > address spaces and IRLM to SYSSTC service class. The DB2 books always said > that IRLM must dispatch higher than the other DB2 address spaces. > > Will this give us problems now that we are running tight on CPU? [...]
14620 35 40_Re: e(logo)series - the new IBM branding12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Thu, 5 Oct 2000 10:21:16 +1100692_- I know I'm showing my age (or perhaps not), but perhaps it's "z", because it's based around the old "z80" processor chips!
Cheers, Nick C :-) _______________________________________________________________
> -----Original Message----- > From: Nadir Doctor [SMTP:Nadir.Doctor@BGEHOME.COM] > Sent: Thursday, October 05, 2000 4:06 AM > To: DB2-L@RYCI.COM > Subject: FW: e(logo)series - the new IBM branding > > P=perfectly priced ; I=inexpensive ? > > -----Original Message----- > From: Laredo, Andrew [mailto:Andy_Laredo@BMC.COM] > Sent: Wednesday, October 04, 2000 12:55 PM > To: DB2-L@RYCI.COM > Subject: Re: e(logo)series - the new IBM branding > > > Z=zero down time > [...]
14656 17 12_(no subject)10_Lee Mandel16_DBMSUser@AOL.COM28_Wed, 4 Oct 2000 20:19:50 EDT433_US-ASCII Hello List, After taking a image copy of the Cat/Dir tablespaces should these image copies entries be recorded in syscopy just like user tablespaces image copies entries? Thanks, Lee
================================================ 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.
14674 18 40_Syscopy entries of Cat/Dir Image Copies.10_Lee Mandel16_DBMSUser@AOL.COM28_Wed, 4 Oct 2000 20:27:08 EDT507_US-ASCII Hello List, This is the 2nd email because I did not put a subject on the first email. After taking a image copy of the Cat/Dir tablespaces should these image copies entries be recorded in syscopy just like user tablespaces image copies entries? Thanks, Lee
================================================ 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.
14693 44 44_Re: Syscopy entries of Cat/Dir Image Copies.10_Rob Wright17_rwright@LIC.CO.NZ30_Thu, 5 Oct 2000 13:36:01 +1200489_us-ascii In DB2 for OS/390, all tablespaces except DSNDB01.DBD01, DSNDB01.SYSUTILX and DSNDB06.SYSCOPY will have entries in SYSIBM.SYSCOPY. These t/s have their entries in the DB2 LOG.
Rob
Lee Mandel on 10/05/2000 12:27:08 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Rob Wright/ham/LIC)
Subject: Syscopy entries of Cat/Dir Image Copies. [...]
14738 62 21_HOW TO USE CODE TABLE19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW30_Thu, 5 Oct 2000 21:46:47 +0800247_big5 HI : ALL I use IBM os/390 DB2 V6 in new envorinment , and try to use code table , but I don't known how to use because I concern to db2 performance : 1. code table how to use in os/390 DB2 2. improvemet DB2 performance ?
Thanks
14801 49 19_regarding MAX(DATE)17_ravi kumar hassan18_ravibh@HOTMAIL.COM28_Thu, 5 Oct 2000 01:39:49 GMT582_- Hi Folks,
In our shop we are using DB2 V6 on OS390. We have a program wich contains sql query to select a max(date) from the table, the sql query in the program like this
SELECT MAX(CODE_END_DT) INTO :WS-CODE-END-DT from table WHERE CODE_ID = :WS-CODE-ID
we are having unique index on column code_end_dt and i am passing ws-code-id to sql query, when i tried to execute the program, i am getting the sql code as 0(zero) but the host variable ws-code-end-dt contains junk value. when i saw the data in the table for the code_id the data looks ok, because [...]
14851 86 23_Re: regarding MAX(DATE)14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM30_Thu, 5 Oct 2000 14:06:23 +1100527_- Kumar,
Often this is something obvious; so here are a couple of things you may want to check: - WS-CODE-ID is actually being populated before the singleton select (or before the open cursor - iff applicable). - do a display of WS-CODE-ID immediately before the SQL is executed to ensure the value is correct. - ensure the SQLCODE checked is from that statement (some sites move SQLCODE to a COBOL WS variable to check the 88 level) - ensure the datatypes match exactly (I know you have said you used the DCLGEN). [...]
14938 79 13_Re: Batch SQL14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 5 Oct 2000 14:25:56 +1100491_iso-8859-1 Not 4096, but 32767 bytes. Let me guess: one constant per line (455*72 = 32760).
Even as a continuous string, you'ld still need at least 50,000 bytes.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au
-----Original Message----- From: Leblanc, Francis C - CNF [mailto:Leblanc.Francis@CNF.COM] Sent: Thursday, October 05, 2000 7:23 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Batch SQL [...]
15018 150 55_Re: DB2-L Digest - 4 Oct 2000 to 5 Oct 2000 (#2000-288)0_24_cbaker@INTERLINK-INC.NET30_Thu, 5 Oct 2000 02:11:51 -0400
15169 62 13_SV: Batch SQL0_19_Sven.Heidorn@CSN.SE30_Thu, 5 Oct 2000 09:16:19 +0200365_ISO-8859-1 Michael,
I'm wondering if you might have passed the 32K limit for an SQL query, 72 character a line times 455 makes 32760.
So, my assumption is that ('0000000','00000005',.....) will make a difference from ('0000000', '00000005', .....)
You might make it a bit longer but I don't think you will get all 5000 through in one run. [...]
15232 22 26_os/390 v5 - lockpart (yes)9_Iam Green21_iam_green@HOTMAIL.COM28_Thu, 5 Oct 2000 10:52:57 IST694_- Can someone outline the advantages and disadvantages of the LOCKPART(YES) option on partitioned tablespaces.
Our DBA says IBM recommend not using LOCKPART(YES)?????
Many thanks in advance, _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at http://profiles.msn.com.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15255 116 30_Re: os/390 v5 - lockpart (yes)25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG30_Thu, 5 Oct 2000 18:17:05 +0800355_us-ascii
Hi,
Let us assume you want to data patch a part tablespace previously you will have to lock the table or tablespace to speed the update operation or to avoid lock escalation. With this option you can lock part and multi-app the update job. The lock usage is low. When you run concurrent you will reduce the total time of run. [...]
15372 68 30_Re: os/390 v5 - lockpart (yes)15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Thu, 5 Oct 2000 12:39:23 +0200358_iso-8859-1 Ian,
In my shop we have a table with partitioned tablespace and LOCKPART(YES). This is done cause we have one program running in concurrent jobs doing updates on different partitions. This option is used for a specific reason. So as IBM would say; 'IT depends.' If you don't need to run concurrent you don't need to use LOCKPART(YES). [...]
15441 30 31_Reason 00C90101 and Erqual 506E16_Bachi Allamsetty22_BachiA@RENEWAL-IIS.COM30_Thu, 5 Oct 2000 07:22:30 -0400545_iso-8859-1 Greetings !
We are using DB2 V6 on OS/390. When we are trying to load a table we are getting the following error message.
DSNIRCCS DATA IN USE DURING ABEND REASON 00C90101 ERQUAL 506E TYPE 00000302 NAME ..X'00000002' CONNECTION-ID=UTILITY CORRELATION-ID=DB2LOADA LUW-ID=*
This table never had data and this is the first time we are trying put some data in it. I dropped and recreated the tablespace and table etc, with no luck. I even tried to creating a new tablespace , again with no luck. [...]
15472 47 23_DB2 - MSTR & DBM1 tasks18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Thu, 5 Oct 2000 07:40:50 -0400370_iso-8859-1 At the request of our system programmers I'd like to put this question out to the group for any information: We are currently running DB2 Version 5 at maintenance level 0002.
>>IBM pointed us to APAR II04309 and part of that APAR contains the IBM recommendation that you run MSTR and DBM1 tasks at 0M. << Our current DB2 subsystems are set at 8M. [...]
15520 19 26_UDB Connection Information18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Thu, 5 Oct 2000 07:49:00 -0400335_- Is there anyway to query the connection information in UDB via SQL? I know you can obtain the information via the control center but I was wondering if you could use SQL to get it also.
Is there anyway to map a UDB connection to a Unix process?
Peter J. Krawetzky Aetna, Inc. DataBase Administrator (860) 273-0301 [...]
15540 36 24_ODBC Access to os390 DB219_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Thu, 5 Oct 2000 14:28:19 +0200495_ISO-8859-1 Hi
Could somebody please tell me has to terminate a thread of an odbc server. We have os390 db2v5.1. Users are accessing the database from microsoft access that is running an odbc server. I can see that threads are being created in DB2 on the mainframe. Results of the sql select are sent to the remote machine no problem. The trouble is the threads that were created remain. There are not reusable because DB2 still thinks they are active. I quote from the admin guide:- [...]
15577 78 28_Re: ODBC Access to os390 DB218_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Thu, 5 Oct 2000 08:34:51 -0400563_iso-8859-1 On the OS/390 side you can go to DB2I and do a: -DISPLAY THREAD(*) TYPE(ACTIVE) Find the 'token' number of the thread that you want to cancel. Its usually all the way out to the right of the display. Then do a: -CANCEL THREAD (xxxxxx) where xxxxx is the 'token' number. This will cancel the DDF thread that is running and will release any resources. We are using DB2 Connect and Datajoiner and have had problems with users coming in through MS Access. They would not exit correctly and this would leave the threads hanging. We've asked them to do [...]
15656 51 35_Re: Reason 00C90101 and Erqual 506E11_Steve Evans17_sevans@FOVEON.COM30_Thu, 5 Oct 2000 08:38:29 -0700554_us-ascii bachi,
is this a large ts (ie each part > 4 gig) ?.
if so you may have encountered the db2 bug that we hit. ibm coded a patch for us in less that 24 hrs - that's great service.
see apar pq42010.
if u need more info, let meknow.
good luck,
steve
Bachi Allamsetty wrote:
> Greetings ! > > We are using DB2 V6 on OS/390. When we are trying to load a table we are > getting the following error message. > > DSNIRCCS DATA IN USE DURING ABEND > REASON 00C90101 > ERQUAL 506E > TYPE [...]
15708 101 28_Re: ODBC Access to os390 DB219_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Thu, 5 Oct 2000 14:47:24 +0200358_ISO-8859-1 Stephen
Thank you for your prompt reply. It is not the cancel thread that is the problem. The user making the connection from the pc is creating a thread, that though inactive is not terminated. I think I will have to reduce the idle thread time out value to 120 secs. Do you know how to chnage this. I guess it is a zparm parameter?. [...]
15810 61 24_QMF application question11_Carl Powers17_CDPowers@FHSC.COM30_Thu, 5 Oct 2000 08:48:38 -0400341_US-ASCII Platform - DB2 v5 / OS/390
Question - Is it possible to build a QMF proc that runs one query to populate a GLOBAL TEMPORARY table and then run a second query that performs a select from that GLOBAL TEMPORARY table? My experimentation up to this point has concluded that the data does not persist across the two queries. [...]
15872 260 30_Re: os/390 v5 - lockpart (yes)14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM30_Thu, 5 Oct 2000 05:53:35 -0700480_iso-8859-1 Remember however, that LOCKPART(YES) only allows concurrency on the partitioned objects. If there are NPI's involved, you may still get locking problems. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.
-----Original Message----- From: Slot, JP (Jaap) [mailto:J.P.Slot@RF.RABOBANK.NL] Sent: Thursday, October 05, 2000 5:39 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] os/390 v5 - lockpart (yes) [...]
16133 135 28_Re: ODBC Access to os390 DB218_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Thu, 5 Oct 2000 09:03:17 -0400516_iso-8859-1 Yes the idle thread is a ZPARM and usually the default comes with a setting of '0' which means 'run forever'. We changed it and it does require you to bring the subsystem down and back up. We had to tweak this setting but we came up with 600 seconds. (the value is set in seconds). As a DBA I lobbied for a lower setting because the threads can tie up resources and my take is if you ain't done anything in 10 minutes or less then your outta there. You may also want to check your ZPARM settings for [...]
16269 154 28_Re: ODBC Access to os390 DB219_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Thu, 5 Oct 2000 15:13:34 +0200647_ISO-8859-1 Stephen
Many thanks I am making the changes now, should be completed tomorrow.
Yours gratefully Neil Briggs
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Thursday, October 05, 2000 3:03 PM To: DB2-L@RYCI.COM Subject: Re: ODBC Access to os390 DB2
Yes the idle thread is a ZPARM and usually the default comes with a setting of '0' which means 'run forever'. We changed it and it does require you to bring the subsystem down and back up. We had to tweak this setting but we came up with 600 seconds. (the value is set in seconds). As a DBA I lobbied [...]
16424 169 40_Re: e(logo)series - the new IBM branding16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM30_Thu, 5 Oct 2000 06:25:52 -0700387_iso-8859-1 - Z/OS could be known as Zeus, the top dog of the Greek gods. - P/OS should be Perseus - Isn't he the one who flew too close to the sun, then plummeted to earth when the wax on his wings melted? Too bad it's not T/OS, Thor would inspire more confidence. - I/OS would be shortened to IO, who changed shape as necessary. - For X/OS, hmmm, how about Xena, Warrior Princess? [...]
16594 49 35_Re: Reason 00C90101 and Erqual 506E13_Johnson, Bill18_bjo23@ALLSTATE.COM30_Thu, 5 Oct 2000 07:56:24 -0500297_- We have just applied a PTF supplied by IBM to fix a similar problem we were having. We were receiving 00C90101's when a specific application was trying to update a partitioning index. Its PTF UQ46912. Might want to look at it as a possible solution? Bill Johnson DBA Allstate Insurance Co. [...]
16644 158 28_Re: ODBC Access to os390 DB219_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Thu, 5 Oct 2000 15:31:39 +0200404_ISO-8859-1 Hi Stephen
You mentioned that you changed the CMTSTAT from ACTIVE to INACTIVE. I have just read that 'Inactive and indoubt threads are not subject to time out'. So if you have set the IDLE THREAD TIME OUT to say 3 mins and the CMTSTAT to inactive. Are inactive threads cancelled after 3 mins or are the left inactive for ever. If this is the case can an inactive thread be reused? [...]
16803 62 28_Size of a new Buffer Pool ..11_Emrah GUVEN28_emrah.guven@PAMUKBANK.COM.TR30_Thu, 5 Oct 2000 16:32:31 +0300257_iso-8859-1 Hi everybody ,
How can I calculate the Size of a new Buffer Pool ? ( or Group Buffer Pool )
Environment : OS/390 , DB2 UDB V5 , Page size 4KB , Sysplex Data Sharing Enviroment with Coupling Facility
regards
emrah guven
16866 20 40_Re: e(logo)series - the new IBM branding14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Thu, 5 Oct 2000 15:35:20 +0100540_us-ascii - P/OS should be Perseus - Isn't he the one who flew too close to the sun, then plummeted to earth when the wax on his wings melted?
It was Icarus, the protector of paragliders.....
Regards Max Scarpa
All disclaimers apply, expecially if you're a hangglider/paraglider
================================================ 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.
16887 48 40_Re: e(logo)series - the new IBM branding4_IBM119_IBM1@EGEBANK.COM.TR30_Thu, 5 Oct 2000 16:44:00 +0300462_- ecco ora arai anche tu antipatico a toine perche' abbiamo discusso proprio di questo thread.... :-PPP
ciao!
Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________________ No trees were killed in the sending of this message. However, a large number of electrons were terribly inconvenienced.
*std disclaimer* - my opinions are my own [...]
16936 24 54_DB2 OS/390 V5.1: DB2PM Long Accounting Report Question0_25_Ed_Vetock@NAVYFEDERAL.ORG30_Thu, 5 Oct 2000 09:45:31 -0400387_us-ascii To all,
In the long accounting report for a particular CICS DB2 transaction, a majority of time spent in CLASS 2 is recorded in field "NOT ACCOUNT". I believe this has to do with swapped out time, paging, wait for CPU time, dispatching priority.
Am I accurate in my assumption? What might the likely cause(s) be for the high numbers in the NOT ACCOUNT field? [...]
16961 42 30_Re: UDB Connection Information14_Mike Lebermann18_Lebermm@BCBSKC.COM30_Thu, 5 Oct 2000 08:37:12 -0500417_US-ASCII Peter,
You can issue the command :
db2 list applications show detail
In the output there is a column called "pid/thread".
Mike
>>> KrawetzkyPJ@AETNA.COM 10/05/00 06:49AM >>> Is there anyway to query the connection information in UDB via SQL? I know you can obtain the information via the control center but I was wondering if you could use SQL to get it also. [...]
17004 27 40_Re: e(logo)series - the new IBM branding14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Thu, 5 Oct 2000 08:59:02 -0400413_iso-8859-1 ENOUGH!
Each unnecessary email causes over 3000 emails to be sent to severs worldwide. Each average about 1.5MB outbound for each of these non-technical comments (and that is without the attachments of previous emails). With attachments, most are in the 40 to 50MB outbound through the list server.
Let's leave the bandwidth available for the really necessary questions and answers. [...]
17032 68 40_FW: e(logo)series - the new IBM branding4_IBM119_IBM1@EGEBANK.COM.TR30_Thu, 5 Oct 2000 17:01:52 +0300433_- sorry list it was meant to be a private message - hence the italian.....
ciao!
Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________________ No trees were killed in the sending of this message. However, a large number of electrons were terribly inconvenienced.
*std disclaimer* - my opinions are my own [...]
17101 187 28_Re: ODBC Access to os390 DB222_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Thu, 5 Oct 2000 10:00:58 -0400440_iso-8859-1 IDLE THREAD TIME OUT is for active threads.
Your inactive thread will not be canceled after 3 mins. Don't know if it's reused. An active thread will go inactive if all DB2 resources have been released & CMTSTAT is inactive. Make sure your remote application is doing commits. If an active thread is done working and has not done a commit, then it is an active thread and is subject to the IDLE THREAD TIME OUT value. [...]
17289 15 31_DB2Connect and Expired Password11_Joseph Sumi14_JSumi@HCFA.GOV30_Thu, 5 Oct 2000 10:34:37 -0400348_- Hello, I'm researching DB2 Connect and how to handle an expired password. I see that an SQL CONNECT will return SQL01404 if the password is expired. It doesn't look like the SQL CONNECT can initiate an expired password change.... what is the interface/API for the application to handle expired pw once it receives the SQL01404 ? Thanks, Joe [...]
17305 76 40_Re: e(logo)series - the new IBM branding10_Ben Marino19_bmarino@NEONSYS.COM30_Thu, 5 Oct 2000 09:27:11 -0500800_us-ascii Ben Marino@NEON 10/05/2000 09:27 AM
Io non capisco nessuna cosa
IBM1 on 10/05/2000 07:44:00 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Ben Marino/Dev/Neon)
Subject: Re: e(logo)series - the new IBM branding
ecco ora arai anche tu antipatico a toine perche' abbiamo discusso proprio di questo thread.... :-PPP
ciao!
Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________________ No trees were killed in the sending of this message. However, a large number of electrons were terribly inconvenienced. [...]
17382 39 17_Secondary Extents12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Thu, 5 Oct 2000 15:38:40 +0100407_iso-8859-1 I have just stopped a segmented tablespace and altered its secondary quantity from 0 to 480 then restarted it. I thought DB2 would pick up the new secondary size and extent quite happily, but it didn't, it filled up the primary then ran out of space. I'm sure I've changed a small secondary to a large value in the past without having to reorg to pick up the changes, am I imagining things? [...]
17422 63 21_Re: Secondary Extents13_Horacio Villa17_hvilla@TTI.COM.AR30_Thu, 5 Oct 2000 11:55:49 -0300626_iso-8859-1 Yes, you are.
-----Mensaje original----- De: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]En nombre de Allen, Colin Enviado el: Jueves 5 de Octubre de 2000 11:39 Para: DB2-L@RYCI.COM Asunto: Secondary Extents
I have just stopped a segmented tablespace and altered its secondary quantity from 0 to 480 then restarted it. I thought DB2 would pick up the new secondary size and extent quite happily, but it didn't, it filled up the primary then ran out of space. I'm sure I've changed a small secondary to a large value in the past without having to reorg to pick up the changes, am [...]
17486 85 21_Re: Secondary Extents13_Adrian Savory24_adrian.savory@ZURICH.COM30_Thu, 5 Oct 2000 15:55:28 +0100434_us-ascii Colin,
We're on V5 and do this all the time - the new secondary extent size is picked up when DB2 next requests a new extent. Don't even need to stop the object.
Not sure about V4 though.
Adrian Savory ACSIS Ltd
"Allen, Colin" cc: Sent by: DB2 Data Base Subject: Secondary Extents Discussion List [...]
17572 52 32_Re: Size of a new Buffer Pool ..14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Thu, 5 Oct 2000 10:56:09 -0400690_ISO-8859-1 Well, you can take a guess(swag) and start at a few thousand buffers and try to tune from there, or use the Buffer Pool Tool to accurately predict the size, and properly tune everything else also.
Regards, Joel +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ +++ Buffer Pool Tool for DB2 - The only product that can Predict the effect of changes & show how to properly group objects into pools based on access DASD/Xpert for DB2 - Easily shows all your DASD performance problems, and recommends tuning options. Visit www.responsivesystems.com - performance white papers and presentations *** MANY *** New software announcements will be on [...]
17625 23 51_How to not show a 390 system in the Control Center?0_19_Sven.Heidorn@CSN.SE30_Thu, 5 Oct 2000 17:09:08 +0200430_ISO-8859-1 Hi all,
does anyone know how to set up a connection to the host with DB2 connect/UDB NT without showing the system in the control center. I don't want the users to be able to do things against the 390 system through the control center. This is due to that we have some generic userid's that have pretty high authority and I don't want to expose the system to them when they use one of the generic userid's. [...]
17649 42 27_Comparing DataBase Changes.9_Harish P.32_ParameswaranHarish@HALIFAX.CO.UK30_Thu, 5 Oct 2000 16:08:48 +0100346_us-ascii Is there any utilities available to compare DB2 (on OS390 system) databases say before and after 5 hours of testing. I am looking at the following options now:
1)Create a complete backup say before testing and do an incremental backup after testing. If I could decode this incremental backup, then it might solve my purpose. [...]
17692 63 31_Re: Comparing DataBase Changes.16_Peddycoart, Judy22_peddycoa@UILLINOIS.EDU30_Thu, 5 Oct 2000 10:11:41 -0500469_iso-8859-1 Take a look at Compare from Princeton Softech. It does exactly what you're looking for!
-----Original Message----- From: Harish P. [mailto:ParameswaranHarish@HALIFAX.CO.UK] Sent: Thursday, October 05, 2000 10:09 AM To: DB2-L@RYCI.COM Subject: Comparing DataBase Changes.
Is there any utilities available to compare DB2 (on OS390 system) databases say before and after 5 hours of testing. I am looking at the following options now: [...]
17756 79 28_Re: ODBC Access to os390 DB20_15_leon@CA.IBM.COM30_Thu, 5 Oct 2000 11:12:30 -0400335_us-ascii I am not sure which product provides your ODBC access to the DB2 for OS/390. If you are using DB2 Connect there are several solutions available. An obvious one is to have DB2 for OS/390 cancel inactive DDF threads after a period of inactivity. I believe DB2 Administration Guide describes management of inactive threads. [...]
17836 196 31_Re: Comparing DataBase Changes.16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Thu, 5 Oct 2000 16:12:41 +0100530_- Harish - if you want to see WHAT data has changed from what-to-what, there are a couple of standard tools in the market. I guess Compuware and BMC will reply too, so here is a response from CA/PLATINUM.
You can use LogAnalyzer to show Before/After image of all updated, deleted and inserted rows - either as a load file, SQL or in a report form. You can use our DataCompare feature within RC/Update (like your option 2). A third option that might be considered is Unload of the INCREMENTAL imagecopy after the test. [...]
18033 24 35_Migrating C++ ODBC code to DB/2 CLI12_Owens, Steve20_SOwens@COOP-TECH.COM30_Thu, 5 Oct 2000 11:58:07 -0400339_- We're attempting to migrate code from WinNT ODBC to DB/2 CLI that can run on both WinNT and MVS. Our development environment is DB/2 UDB 5.2, NT 4.0, Visual C++. Simply recompiling with %DB2PATH%\include before the MS directories causes problems due to typedef differences between IBM's sql.h and sqlext.h and Microsoft's versions. [...]
18058 19 65_Activating Stored Procedures after migration to DB2 for OS/390 V50_17_JTonchick@AOL.COM28_Thu, 5 Oct 2000 12:06:38 EDT311_US-ASCII Now that I've migrated to V5 from V4, I wanted to activate support for stored procedures. But the UPDATE option in the DB2 Install Clist prevents adding the stored procedure proc name on panel DSNTIPX. Do I have to use the INSTALL function to add stored procedures to an exsisting subsystem? Why? [...]
18078 63 47_Re: DB2s own support for defer defined pagesets19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Thu, 5 Oct 2000 11:10:06 -0500621_iso-8859-1 Phil, Seems to me that any IBM process (DB2 utilities in particular) should check the SPACE column for the affected object before failing and rather than fail hard, issue some informative DSNannna msg under RC04 indicating the object isn't defined.
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 [...]
18142 85 17_Re: SV: Batch SQL12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 5 Oct 2000 19:13:34 +0200457_iso-8859-1 Hi, Split it to, let's say 10 jobs, each with different in-list and run in parallel to separate files, then join them.
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Thursday, October 05, 2000 9:16 AM Subject: SV: Batch SQL [...]
18228 76 27_Re: DB2 - MSTR & DBM1 tasks13_Gendron, Dave28_Dave.Gendron@COASTALCORP.COM30_Thu, 5 Oct 2000 11:14:25 -0500631_iso-8859-1 REGION=0K is set for MSTR and DBM1 on our 6 subsystems. Have been for ages.
Dave Gendron
|-----Original Message----- |From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] |Sent: Thursday, October 05, 2000 5:41 AM |To: DB2-L@RYCI.COM |Subject: DB2 - MSTR & DBM1 tasks | | | At the request of our system programmers I'd like to put |this question out |to the |group for any information: |We are currently running DB2 Version 5 at maintenance level 0002. | |>>IBM pointed us to APAR II04309 and part of that APAR |contains the IBM |recommendation |that you run MSTR and DBM1 tasks at 0M. << |Our [...]
18305 25 107_How can I change the incoming userid connecting to the mainframe to a differnt userid before it is verified12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Thu, 5 Oct 2000 11:18:14 -0500564_iso-8859-1 Our environment: DB2 Connect V6 on AIX DB2 V6 on OS/390 Runtime Client V6 code on the workstation The user is running MS Access connecting to the mainframe TCP/IP protocol used ACF is used for security on the mainframe
Opportunity: When a certain userid connects to the mainframe change the userid he/she comes in with to a different userid. I thought I could use the SYSIBM.USERNAMES table to translation a userid to a different one but it doesn't seem to work.. Anyone doing this or know of a different way I to accomplish the same thing? [...]
18331 47 40_Re: e(logo)series - the new IBM branding12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 5 Oct 2000 19:41:14 +0200455_iso-8859-1 Hi, So we need D/os for Dedalous.
(Icaros's father,.. go read it...) Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Massimo Scarpa" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, October 05, 2000 4:35 PM Subject: Re: e(logo)series - the new IBM branding [...]
18379 87 27_Re: DB2 - MSTR & DBM1 tasks11_Carl Nelson22_Carl.Nelson@ANTHEM.COM30_Thu, 5 Oct 2000 11:51:04 -0500386_us-ascii We're set at 8M but I don't know why we use those settings. On a couple of occassions, DB2 has been accused of eating up too much memory and threatening to force MVS to come to a stop.
"Whittaker, Stephen" on 10/05/2000 06:40:50 AM
Please respond to DB2 Data Base Discussion List [...]
18467 92 69_Re: Activating Stored Procedures after migration to DB2 for OS/390 V513_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Thu, 5 Oct 2000 12:12:32 -0500552_US-ASCII Jim, Just set STORPROC= xxxxxxxx in ZPARM to the SPAS proc name you will be using for that subsystem. It's more involved if your using WLM stored procedures. HTH Kurt
>>> JTonchick@AOL.COM 10/05/00 11:06AM >>> Now that I've migrated to V5 from V4, I wanted to activate support for stored procedures. But the UPDATE option in the DB2 Install Clist prevents adding the stored procedure proc name on panel DSNTIPX. Do I have to use the INSTALL function to add stored procedures to an exsisting subsystem? Why? [...]
18560 133 21_Re: Secondary Extents0_19_Tim.Lowe@STPAUL.COM30_Thu, 5 Oct 2000 12:13:24 -0500431_us-ascii Colin, This was implemented in DB2 V5 with APAR PQ04053 / PTF UQ06309 back on 6/30/97. (See the DB2 web page for "new function in DB2 V5 through apars". http://www-4.ibm.com/software/data/db2/os390/v5apar.html ) I do not believe that this was ever retrofitted back to DB2 V4.
Thanks, Tim
Adrian Savory on 10/05/2000 09:55:28 AM [...]
18694 72 27_Re: DB2 - MSTR & DBM1 tasks12_Sue Janowitz18_SJanowitz@NEFN.COM30_Thu, 5 Oct 2000 13:21:35 -0400630_us-ascii We use REGION=0K. This allows MSTR and DBM1 to get as much region as they need, up to the system limits that your MVS people have in place.
Sue Sue Janowitz DB2 Systems Administrator New England Financial Information Systems Boston, MA SJanowitz@nefn.com
> -----Original Message----- > From: Whittaker, Stephen [SMTP:stephen.whittaker@CPLC.COM] > Sent: Thursday, October 05, 2000 7:41 AM > To: DB2-L@RYCI.COM > Subject: DB2 - MSTR & DBM1 tasks > > At the request of our system programmers I'd like to put this question > out > to the > group for any information: > We are currently running DB2 [...]
18767 112 27_Re: DB2 - MSTR & DBM1 tasks11_John Wallin24_john.wallin@ZURICHUS.COM30_Thu, 5 Oct 2000 12:56:37 -0500289_us-ascii I have 128M on my PC. If DB2 is using too much storage (real not virtual) then there is a problem with IPS parameters or a code problem. If the region cannot get storage it will not run. I suggest the fix the code problem not limit the storage as a fix (for tuning or maint) [...]
18880 14 21_Where is DB2EUG List?0_22_BILL_GALLAGHER@PHL.COM30_Thu, 5 Oct 2000 14:22:06 -0400444_us-ascii Does anybody know what happened to the DB2EUG list? I haven't received anything from it all week, and when I tried to send a test message to it, the message got returned to me as undeliverable.
================================================ 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.
18895 67 31_Re: Comparing DataBase Changes.11_Sinha, Amit19_Sinha.Amit@MBCO.COM30_Thu, 5 Oct 2000 13:27:49 -0500459_iso-8859-1 BMC Change Manager will be good ...
AMIT SINHA
-----Original Message----- From: Harish P. [mailto:ParameswaranHarish@HALIFAX.CO.UK] Sent: Thursday, October 05, 2000 10:09 AM To: DB2-L@RYCI.COM Subject: Comparing DataBase Changes.
Is there any utilities available to compare DB2 (on OS390 system) databases say before and after 5 hours of testing. I am looking at the following options now: [...]
18963 40 69_Re: Activating Stored Procedures after migration to DB2 for OS/390 V50_17_JTonchick@AOL.COM28_Thu, 5 Oct 2000 14:28:43 EDT598_US-ASCII Thanks, Kurt, but editing the DSNTIJUZ macros only tells DB2 to attempt to start the xxxxSPAS started task during subsystem startup, it does not generate the started task JCL, or sample application jobs.
The only way I've seen these items generated is a new subsystem install, or during migration. To keep changes to a minimum across the v4 - v5 migration I did not activate stored procedure support. Now, that v5 is in and stable, I want to go back and update the subsystem using the DSNTINST clist, but can't. Since I support multiple subsystems using the same SDSNSAMP base [...]
19004 24 28_User Exit - DB2 V6.1 for AIX14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Thu, 5 Oct 2000 14:37:33 -0400407_iso-8859-1 We are looking at using user exits to archive logs. The following statement in the manual (Admin Guide : Design & Implementation Pg.739) is not very clear to me:
1. Table space roll-forward recovery does not support the retrieval of log files using user exits.
Does this mean that by using user exits to archive and retrieve logs we give up on tablespace rollforward recovery? [...]
19029 33 22_longvar defined column18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Thu, 5 Oct 2000 14:42:27 -0400523_iso-8859-1 I've got a column in a DB2 V5 table that is defined as longvar 4018. When its viewed using QMF the data is returned in a 'character' format but when you try to access the column using DB2 Connect or through Datajoiner the data comes back in HEX. Can anyone tell me if there's a way to retrieve this data using DB2 Connect CLP that will return the row in 'character' format. Sure would be alot easier to read. This is an INDUS application we are using so we did not have any control as to how the tables and [...]
19063 198 34_check/backup pending & db2diag.log17_McDonnell, Victor22_vmcdonnell@CAYENTA.COM30_Thu, 5 Oct 2000 11:57:49 -0700661_ISO-8859-1 guhdie! (that's Aussie, you know)
(vUDB 6.1 on AIX 6000) Has anyone ever seen a tablespace put into BACKUP pending as the result of a constraint violation? Following, if you will, is section of diag log. I have the interpretation instructions (troubleshooting guide, but the codes that follow I cannot find ('40',Probe:50,60,etc '-30850', 'Fede' ???). Following the attempt to mass insert data (Commerce-Suite Load Utility, which apparently does INSERTS), the tablespace was put into BACKUP pending status, according to LIST TABLESPACES; however the Control Center did not show a problem! I did a backup to remove the pending status, and [...]
19262 18 22_Indexex not being used13_Eric McDonald22_Eric_McDonald@BELK.COM30_Thu, 5 Oct 2000 15:13:05 -0400467_us-ascii Greetings-
I am in the process of try to eliminate indexes that have been created but are not being used. Does anyone know of a way to find this information.
Thanks in advance for any responses.
================================================ 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.
19281 58 22_Indexes not being used16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM30_Thu, 5 Oct 2000 15:38:39 -0400209_iso-8859-1 select creator, name from sysibm.sysindexes ix where not exists (select * from sysibm.systables tb where tb.creator = ix.tbcreator and tb.name = ix.tbname);
Gerald R. (Garry) Brookman
19340 29 26_Re: Indexex not being used9_Rob Crane22_racrane@CONCENTRIC.NET30_Thu, 5 Oct 2000 14:11:13 -0600634_us-ascii CA/Platinum's Subsystem Analyzer will allow you to determine which indexes are being used and which ones are not being used based on the SQL that has run on your subsystem.
Eric McDonald wrote: > > Greetings- > > I am in the process of try to eliminate indexes that have been created but > are not being used. Does anyone know of a way to find this information. > > Thanks in advance for any responses. > > ================================================ > 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 [...]
19370 28 41_V6- view materialization and performancer12_HEPP SHERY C17_schepp@SRPNET.COM30_Thu, 5 Oct 2000 12:55:22 -0700575_iso-8859-1 Greetings fellow listers-
We recently implemented DB2 V6 in our production environment and have experienced some performance degradation. More specifically when we execute queries referencing Views that require materialization via a multiple table join. Has anyone else encountered any performance problems with this? When we explain the query behind the view we get what appears a good access path (i.e. index access) - however when we execute the query materializing the view we get hundreds of thousands of getpages- for a small result set of data. [...]
19399 34 26_Re: Indexex not being used0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 5 Oct 2000 14:57:06 -0500357_us-ascii check the archive, Aug 13, there was some SQL posted to help find unused indexes
To: DB2-L@RYCI.COM cc: Subject: Re: Indexex not being used
CA/Platinum's Subsystem Analyzer will allow you to determine which indexes are being used and which ones are not being used based on the SQL that has run on your subsystem. [...]
19434 77 26_Re: Indexex not being used16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM30_Thu, 5 Oct 2000 15:56:16 -0400374_us-ascii Eric,
The query below will check the catalog for all unused indices (remember, there are many ways to code SQL to return the same result set - this is only ONE way!!!).
One other thing to keep in mind, this query pertains to statically bound packages / plans!
If your shop is utilizing dynamic SQL then DO NOT (solely) rely on this query! [...]
19512 88 26_Re: Indexex not being used12_Susan Lawson22_lawson_susan@YAHOO.COM30_Thu, 5 Oct 2000 13:10:26 -0700426_us-ascii Hi Eric,
Any SQL you run against the catalog is not going to account for indexes being used for dynamic SQL or RI. In fact, indexes used for RI are not reported anywhere.
Any tools that tell you which ones are not used have no way of looking into the future and accounting for SQL statements that may need those indexes for transactions that may not have ran during that particular capture period. [...]
19601 139 26_Re: Indexex not being used14_Richard Yevich17_ryevich@YAHOO.COM30_Thu, 5 Oct 2000 13:20:07 -0700436_us-ascii Richard,
This query only points up some of the usages and non-usages, and recording of indexes. It cannot be even be used for the situations you mentioned 100% accuratley.
Bottom line - it is almost impossible to deteremine whether an index is used or not used after creation without extensive analysis, traces, etc. Trace tools only show a period of time. Catalog queries only show what might be attempted. [...]
19741 62 45_Re: V6- view materialization and performancer23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Thu, 5 Oct 2000 16:36:47 -0400673_- Shery,
We have been in that situation and turning off parallelism did the trick for us.
Sanjay Jain
> -----Original Message----- > From: HEPP SHERY C [SMTP:schepp@SRPNET.COM] > Sent: Thursday, October 05, 2000 3:55 PM > To: DB2-L@RYCI.COM > Subject: V6- view materialization and performancer > > Greetings fellow listers- > > We recently implemented DB2 V6 in our production environment and have > experienced some performance degradation. More specifically when we > execute > queries referencing Views that require materialization via a multiple > table > join. Has anyone else encountered any performance problems with this? > When > [...]
19804 174 26_Re: Indexex not being used16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM30_Thu, 5 Oct 2000 16:48:02 -0400375_us-ascii Mr. Yevich,
Thanks, I really appreciated your note, but I should have expected it since that's what you get when you reply quickly and take for granted that DBA's should know, there are NO silver bullets or simple "one off" answers.
The query I submitted should be utilized ONLY as the first step in the completion of proper access path analysis. [...]
19979 33 26_Re: Indexes not being used14_Laredo, Andrew19_Andy_Laredo@BMC.COM30_Thu, 5 Oct 2000 15:50:07 -0500565_iso-8859-1 I'm afraid this will not suffice.
But you better define "used" first. Do you mean used by static SQL (possible to find) or used by dynamic SQL (nearly impossible to find)
-----Original Message----- From: Brookman, Gerald [mailto:gerald.brookman@US.ORIGIN-IT.COM] Sent: Thursday, October 05, 2000 3:39 PM To: DB2-L@RYCI.COM Subject: Indexes not being used
select creator, name from sysibm.sysindexes ix where not exists (select * from sysibm.systables tb where tb.creator = ix.tbcreator and tb.name = ix.tbname); [...]
20013 48 112_Re: How can I change the incoming userid connecting to the mainfr ame to a differnt userid before it is verified17_Belfield, Alma G.15_AGBELFI@TWA.COM30_Thu, 5 Oct 2000 16:06:12 -0500427_iso-8859-1 Do you have the 'WOW DB2 Supports TCP/IP' redbook sg24-2212-00? Section 12.3 describes how the inbound security works. CDB isn't used for inbound requests and DSN3@ATH is driven not DSN3@SGN. So you could customise DSN3@ATH..... of course this doc was written for V5, not sure if V6 is different. There is also a section 'Controlling Inbound Connections the Use TCP/IP Protocols' in the DB2 OS/390 Admin Guide. [...]
20062 63 70_Re: Activating Stored Procedures after migration to DB2 for OS /390 V515_Jeffrey Frazier26_Jeffrey_Frazier@WENDYS.COM30_Thu, 5 Oct 2000 16:36:39 -0400398_us-ascii Hi, dont know if this is what you are looking for but the started task jcl is in the install sdsnsamp lib in member DSNTIJMV. Sample jobs are probably there also. You will have to edit these to reflect your dataset naming for your shop.
JTonchick@AOL.COM on 10/05/2000 02:28:43 PM
Please respond to DB2 Data Base Discussion List [...]
20126 66 38_DB2 V5 - DSNB226I reason code 00C200F727_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Thu, 5 Oct 2000 16:28:25 -0500463_- We have been getting these errors sporadically and on different objects since we moved this system to our data center. If we rerun the batch job or transaction that failed, it works (well, once I think we had to rerun a job twice before it ran to good eoj). So, it doesn't seem to be a real data error, at least not with the index or tablespace that's listed with the message. We've run check against the objects with the errors, but no errors were found. [...]
20193 17 50_Oracle's Ellison: Would You Buy Soap From This Man14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Thu, 5 Oct 2000 17:55:48 -0400380_iso-8859-1 http://dailynews.yahoo.com/h/zd/20001005/tc/ellison_would_you_buy_soap_from_ this_man__1.html
This is enjoyable!
================================================ 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.
20211 19 26_Re: Indexes not being used13_John McNeilly23_johnmcneilly@MCMAIL.COM30_Fri, 6 Oct 2000 00:00:45 +0100326_us-ascii One method I have successfully used in the past to determine index usage in an MIS environment where the majority of SQL is dynamic was to analyse the information captured in SMF type 42 records. Indexspace datasets which had a total of zero I/Os during one business cycle (in this case one month) were dropped. [...]
20231 73 31_Re: Comparing DataBase Changes.14_Michael Finnis28_MFinnis@PRINCETONSOFTECH.COM30_Thu, 5 Oct 2000 19:48:57 -0400628_ISO-8859-1 Harish,
Compare for DB2 from Princeton Softech is designed to do exactly what you want. Please take a look at:
http://princetonsoftech.com/comparefordb2
Cheers, Mike Finnis Product Specialist Princeton Softech Australia
-----Original Message----- From: Harish P. [mailto:ParameswaranHarish@HALIFAX.CO.UK] Sent: Friday, October 06, 2000 12:39 AM To: DB2-L@RYCI.COM Subject: Comparing DataBase Changes.
Is there any utilities available to compare DB2 (on OS390 system) databases say before and after 5 hours of testing. I am looking at the following options now: [...]
20305 49 27_Comparing DataBase Changes.12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM30_Thu, 5 Oct 2000 20:24:22 -0400365_ISO-8859-1 Steen,
We use the CA products, and while I think they're great in most areas, comparing data is not one of them. The data compare function is simply running the ISPF compare function which is far from a really nice output to look at or evaluate. I have requested for some time that this feature be enhanced to really provide a useful output. [...]
20355 46 27_Re: DB2 - MSTR & DBM1 tasks14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Thu, 5 Oct 2000 20:52:26 -0400584_ISO-8859-1 John, Maybe I'm missing something.. was the opener about 128M on your PC just a pun? Just as a general overview... The IPS has nothing to do with the amount of memory DB2 asks for, or can ultimately get from a real operational perspective, nor is this usually related to a code problem. Attempting to control memory usage in the IPS (storage fencing) is a generally obsolete approach in todays environments. Aside from many large memory requirement for DB2 DBM1 (the large consumer), almost all the memory used is above the line, and mostly from SP 229. It's used for [...]
20402 66 26_Re: longvar defined column14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 6 Oct 2000 15:13:08 +1100472_iso-8859-1 Steve,
Is, by any chance, the column is defined as 'for bit data' (syscolumns.foreignkey = 'B')? "SUBSTR(column,1)" might work.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Friday, October 06, 2000 5:42 AM To: DB2-L@RYCI.COM Subject: [DB2-L] longvar defined column [...]
20469 82 25_Fw: HOW TO USE CODE TABLE19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW30_Sat, 7 Oct 2000 01:29:25 +0800402_big5
----- Original Message ----- From: ´ö½Òªø To: DB2 Data Base Discussion List Sent: Thursday, October 05, 2000 9:46 PM Subject: HOW TO USE CODE TABLE
HI : ALL I use IBM os/390 DB2 V6 in new envorinment , and try to use code table , but I don't known how to use because I concern to db2 performance : 1. code table how to use in os/390 DB2 2. improvemet DB2 performance ? [...]
20552 73 17_Fw: RECURSIVE SQL19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW30_Sat, 7 Oct 2000 01:29:42 +0800397_big5
----- Original Message ----- From: ´ö½Òªø To: DB2 Data Base Discussion List Sent: Thursday, October 05, 2000 4:30 AM Subject: RECURSIVE SQL
HI : ALL I don't known what is recursive sql , so any one can tell me : 1. in use os/390 , NT, AIX or ....others platfrom 2. I can reference DB2 manual , book no.... 3. use in DB2 versions , how about to use rescursive sql THANKS
20626 215 31_Re: Comparing DataBase Changes.16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Fri, 6 Oct 2000 06:45:30 +0100355_- Hi Dennis;
Fast Unload DO unload from Incrementals - I know it didn't until a while ago, but I had a customer (while the company was PLATINUM) who got this enhancement implemented as a PTF, and its now part of Fast Unload. The exception is if the imagecopy is taken from a compressed tablespace, where we dont have access to the dictionary. [...]
20842 157 21_Re: Secondary Extents12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Fri, 6 Oct 2000 09:29:56 +0100311_iso-8859-1 It looks like I must have read that it would be possible way back then imagined that I had done it, memory plays strange tricks over time.
Thanks everyone for clearing it up, hopefully when we finally get to v5 I won't 'remember' that it's necessary to do a reorg to pick up the changes. [...]
21000 35 10_Hiperpools14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Fri, 6 Oct 2000 12:16:44 +0100346_us-ascii Hi all folks, I hope that we came to an understanding about IBM's new logo..... ;-)
We are implementing Hiperpools in our production environment. We are using Joel Goldstein's suggestion to tune
VP & HP. Hps seem to work well, but I remember that there's a 10 % rule-of-thumb, but I don't remeber if this rule regards [...]
21036 49 14_Re: Hiperpools14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 6 Oct 2000 06:27:34 -0400344_ISO-8859-1 Max, It;'s not so much that there's a 10% rule of thumb...... While 10% may sound like a low %, it may still give a good payback in term of I/O savings. Ultimately, you want to calculate how many I/Os/Sec the HP is saving you.... The HP efficiency formula is: Total pages read back into the VP from HP/Total pages written to HP [...]
21086 24 33_More on LOCKPART(YES) - OS/390 V59_Iam Green21_iam_green@HOTMAIL.COM28_Fri, 6 Oct 2000 12:14:31 IST673_- Thats great, thanks!
What advantages are there for online usage of the table (which has reasonably heavy usage) or are there any compelling reasons?
TIA
_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at http://profiles.msn.com.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21111 47 26_Re: Indexes not being used16_Bruce Williamson25_Bruce.Williamson@MAIL.COM30_Fri, 6 Oct 2000 22:00:49 +1000352_us-ascii Howzit Eric?
Have a look for indexes that have no entry in SYSPACKDEP, this will give you a list of indexes not used in static SQL. Be aware that there may still be dynamic SQL (including QMF, SPUFI, etc.) that use these indexes. To check whether they use the indexes from your previous query, do an EXPLAIN on all SQL statements. [...]
21159 75 29_DB2 version v6 address spaces15_Pierre Dagenais19_pdagenai@UOTTAWA.CA30_Fri, 6 Oct 2000 08:12:04 -0400613_us-ascii Hi everyone,
I have a question about db2 v6. How many address space do you need to run the complete db2 v6. So far I have gathered the following information. for each subsystem, you will need the following address spaces.
xxxxDIST xxxxMSTR xxxxSPAS xxxxDBM1 IRLMxxxx
plus
WLM1xxxx , tcbnum=1 for the REXX stored procedure processor DSNTPSMP WLM2xxxx , tcbnum=1 for the DSNUTILS (stored procedure to run db2 utilities using the Control center) WLM3xxxx, tcbnum=X for stored procedure written in sql and user defined function and old cobol stored procedure if you want to. [...]
21235 203 18_Re: DB2-L meeting?0_18_mebert@AMADEUS.NET30_Fri, 6 Oct 2000 14:15:56 +0200422_us-ascii Hi all IDUG-goers,
I will be arriving in Geneva on Monday morning. Since this is my first IDUG, I would appreciate any hints & tips & advance warnings. Pls email me offline (mebert@amadeus.net).
TIA
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
From: "Peter, Georg" on 27/09/2000 14:33 GMT [...]
21439 31 26_Re: Indexes not being used11_Steve Evans17_sevans@FOVEON.COM30_Fri, 6 Oct 2000 08:32:59 -0700602_us-ascii john,
this may not work if the index is updated during the day.
steve
John McNeilly wrote:
> One method I have successfully used in the past to determine index usage in an MIS environment where the majority of SQL is dynamic was to analyse the information captured in SMF type 42 > records. Indexspace datasets which had a total of zero I/Os during one business cycle (in this case one month) were dropped. > > The method is obviously not foolproof as it assumes that all queries will be executed during the business cycle being analysed, this may not [...]
21471 37 23_Control centre problem.14_Stephen Levett18_slevett@SIEBEL.COM30_Fri, 6 Oct 2000 05:22:36 -0700560_iso-8859-1 Hello DB2 users,
I have a peculiar problem with the UDB control centre, it is version 6.1 (G.A) running on WinNT 4.0 SP6. The problem is as follows :
I have set up a UID with SYSADM authority and I have dropped this UID in the local group I have defined. I have also updated the DBM CFG SYSADM_GRP parameter with this local group information. Please note the DB2ADMIN default UID and PWD is not in this local group so it should now have restricted DB2 authority. Indeed it does and the setup works fine, the UID has the necessary [...]
21509 51 40_DB2 Connect V6 and DB2/OS390 V5 Problems12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Fri, 6 Oct 2000 08:31:49 -0400537_- To all:
First I want to give a big thank you to my IBM account rep and the folks at IBM for responding so quickly to my question.
The informational APAR II12269 is a bit misleading, and I think the intent was "if you want to use connection pooling, then migrate to V6/OS390". When I did the APAR search, I didn't get hits for the following APAR because I didn't have the same symptoms as the APAR (but the problem is essentially the same problem). There is a fix for the problem, both on the server and on the host: [...]
21561 22 21_QMF vs Easytrieve DB211_Ken Liberty29_Ken_Liberty@CONSULTEC-INC.COM30_Fri, 6 Oct 2000 08:36:50 -0400346_us-ascii Has anyone done a back to back comparison on the capabilities of QMF vs Easytrieve for DB2?. Personally, I personally think QMF is superior, but I really need to take a broader look at Report Writing Tools and the functionality in which each one offers. If anyone can share their research/experiences with me I would appreciate it. [...]
21584 24 27_Stored Procedures Standards11_Ken Liberty29_Ken_Liberty@CONSULTEC-INC.COM30_Fri, 6 Oct 2000 08:37:20 -0400445_us-ascii We are in the process, like so many others, of laying done procedures and standards to our Application Group for developing and using Stored Procedures (on DB2 OS/390 V5). What kind of Standards / Procedures has other's used, who've already pioneered through this frontier? I know that the management, development of Stored Procedures becomes much easier in V6, but we are not there yet! Experiences / Advise would be appreciated. [...]
21609 62 31_Re: Stored Procedures Standards14_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 6 Oct 2000 08:49:46 -0400471_us-ascii Ken, I wrote a standard that addresses stored procedue use on DB2 for OS/390 and on DB2 on NT or AIX/UNIX. I can send it to you if you would like. It might need a little updating vis a vis V6 . Phil
Phil Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA V6.1 IBM Certified Solutions Expert -- Database Adminstration V6.1 IBM Certified Solutions Expert -- Application Development V6.1 Assoc List Owner DB2-L pkg3@psu.edu [...]
21672 277 31_Re: Stored Procedures Standards12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Fri, 6 Oct 2000 08:59:19 -0400486_iso-8859-1 Philip, That sounds like something I could use too :) Thanx, Randy Wilson
-----Original Message----- From: Philip Gunning [mailto:pgunning@PHEAA.ORG] Sent: Friday, October 06, 2000 8:50 AM To: DB2-L@RYCI.COM Subject: Re: Stored Procedures Standards
Ken, I wrote a standard that addresses stored procedue use on DB2 for OS/390 and on DB2 on NT or AIX/UNIX. I can send it to you if you would like. It might need a little updating vis a vis V6 . Phil [...]
21950 48 31_Re: Stored Procedures Standards15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU30_Fri, 6 Oct 2000 08:58:13 -0400458_iso-8859-1 We created a new plan name to hold our stored procedures because Execute authority is needed
When Defining the stored procedure to the catalog table SYSPROCEDURES Set SYSPROCEDURES field ASUTIME to a low value to contain any runaway threads. we had a few run-away (4 or 5) while trying to establish this stuff. We would execute A Stored Procedure call and the thread would try to access the Stored Procedure and never come back ($$$). [...]
21999 28 17_Re: When to REORG12_Susan Tipton22_tiptosa@SHANDS.UFL.EDU30_Fri, 6 Oct 2000 08:59:42 -0400435_US-ASCII You are trying to post to a list that you do not belong to so your posting is being bounced. You will have to cut and paste the "from" (PMV2@MEAD.COM) or call the number she listed ((937)495-3789).
SAT
>>> daniel.sullivan@ZURICHUS.COM 7/18/00 10:49:22 AM >>> In the sample library that comes with DB2, there are various queries you can run to determine when to reorg. The member would be: SDSNSAMP(DSNTESP) [...]
22028 99 44_Re: DB2 Connect V6 and DB2/OS390 V5 Problems14_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 6 Oct 2000 09:06:54 -0400386_us-ascii Robert, There is a good write up on pushing clients out to desktops, Distributed Windows Install of DB2 Products, at http://www-4.ibm.com/software/data/pubs/papers/. Also, the installation and configuration supplement is an excellent source for congifuring and distributing clients. HTH
PS I applied PQ37949 at a previous site and it took care of the -551 problem. [...]
22128 24 50_Re: When to reorg - Please delete my previous post12_Susan Tipton22_tiptosa@SHANDS.UFL.EDU30_Fri, 6 Oct 2000 09:07:28 -0400562_US-ASCII Please ignore and delete my previous post. It was a reply to a co-worker that was sent to the wrong address while I was reading the list postings.
Thank you. My apologies. Susan
Susan Ann Tipton DataBase Administrator Shands HealthCare tiptosa@shands.ufl.edu (352) 265-0680 x85479 (352) 265-7982 fax
===============================================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.
22153 91 27_Re: Control centre problem.0_22_BILL_GALLAGHER@PHL.COM30_Fri, 6 Oct 2000 09:09:16 -0400301_us-ascii Stephen,
We ran into the same problem when we started working in this environment. It has to do with the fact that UDB v6.1 Control Center runs as a JDBC applet, and if you're running it from an NT workstation, it should be run under a SYSADM ID in order to get SYSADM authority. [...]
22245 38 41_failed to attach to the database instance7_J. Wang32_Jizhong_Wang@EMAIL.WHIRLPOOL.COM30_Thu, 5 Oct 2000 17:01:46 -0400401_US-ASCII Platform: Server: AIX 4.3, DB2 UDB 7.1 with the latest fix Client: Windows NT and Windows 2000, Control Centre (7.1)
Every time when I try to view connection information, via Control Centre, under database-connections tab, an error says "A problem occured when trying to attach to database instance. smcode "-35" ". Error logs from the Administrator server from the AIX box says: [...]
22284 111 27_Re: Control centre problem.14_Stephen Levett18_slevett@SIEBEL.COM30_Fri, 6 Oct 2000 07:02:07 -0700620_iso-8859-1 Hello Bill,
Yes that worked perfectly, thanks very much for you assistance.
Regards Stephen .....
-----Original Message----- From: BILL_GALLAGHER@PHL.COM [mailto:BILL_GALLAGHER@PHL.COM] Sent: Friday, 06 October, 2000 2:09 PM To: DB2-L@RYCI.COM Subject: Re: Control centre problem.
Stephen,
We ran into the same problem when we started working in this environment. It has to do with the fact that UDB v6.1 Control Center runs as a JDBC applet, and if you're running it from an NT workstation, it should be run under a SYSADM ID in order to get SYSADM authority. [...]
22396 43 44_Returning Result Set from a Stored Procedure10_Ed La Touf17_elatouf@YAHOO.COM30_Fri, 6 Oct 2000 09:20:35 -0500320_- I am passing a select statement in a parm from a client Cobol Program to a store procedure(cobol). I am using dynamic sql for a fixed list. In the stored procedure these are the statements:
EXEC SQL DECLARE CUR-ST-CD CURSOR WITH RETURN FOR STMT END-EXEC.
EXEC SQL PREPARE STMT FROM :PARM1 END-EXEC. [...]
22440 41 32_How to test for V6 -101 problem?31_Jackson Reavill/Tampa/Contr/IBM18_damcon2@US.IBM.COM30_Fri, 6 Oct 2000 10:47:28 -0400343_us-ascii Hi all,
I'm curious to know if anyone out there has put together a plan to test for the -101 problem when going to DB2 V6 for OS/390? Or is it just close your eyes, cross your fingers, and hope that one of your most critical applications doesn't head south? If you have a plan would you please be kind enough to share it? [...]
22482 27 14_Re: Hiperpools14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Fri, 6 Oct 2000 16:56:08 +0100360_us-ascii Hi Joel & thanks for the reply.
I remember an article where it is was said that if u have a HP hit > 10% ( I think it was hit ratio) it was useful to keep an HP
because you avoid a little I/O, however.
But as you say that 10% is a POOR hit ratio I trust you. As a rule-of-thumb what's a 'reasonable' good HP hit ratio and HP [...]
22510 26 14_Re: Hiperpools0_26_truman.g.brown@VERIZON.COM30_Fri, 6 Oct 2000 11:08:44 -0400331_us-ascii Our hiperpools run above 95% "hit ratios" (Omegamon DB2) and we use 10% read-to-write ratio as a minimum for justifying an HP UNLESS (key word, unless) a smaller read to write ratio still represents a LARGE amount of saved read I/O -OR- the additional hits reduce response times for a critical on-line ap- plication. [...]
22537 62 42_Re: IRLM dispatching priorities under WLM.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Fri, 6 Oct 2000 10:26:07 -0500568_iso-8859-1 Martin, Jim, SYSSTC is a non-managed service class within WLM/Goal mode meaning that all ASIDs within it get CPU whenever they need it and all ASIDs start out with the same DP. There can be some adjustment of DP amongst the ASIDs within this service class should they start getting too much or too little DP to accomplish their tasks. Putting IRLM, MSTR, and DBM1 in this class might look initially like a good idea because the service class isn't managed. However, this idea is really rather like using the same DP for IRLM, MSTR, and DBM1. It can be [...]
22600 54 30_Re: Comparing DataBase Changes14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 6 Oct 2000 10:32:52 -0500771_iso-8859-1 There are two data comparison products I know of:
- Comparex from Serena and; - Compare for DB2 from Princeton Softech.
And if you ever need to compare database structures, BMC's Change Manager can accomplish that quite nicely.
Craig S. Mullins Director, DB2 Technology Planning BMC Software http://www.bmc.com Craig_Mullins@bmc.com http://www.craigsmullins.com cmullins@compuserve.com
----------------------------- > >Date: Thu, 5 Oct 2000 16:08:48 +0100 >From: "Harish P." >Subject: Comparing DataBase Changes. > >Is there any utilities available to compare DB2 (on OS390 system) databases >say before and after 5 hours of testing. I am looking at the following >options now: > >1)Create a [...]
22655 18 60_Stored Procedure programs running as MVS authorized programs12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Fri, 6 Oct 2000 10:46:50 -0500399_iso-8859-1 In section 7.2.4.10 Preparing a stored procedure of the Application Programming Guide it says: Preparing a stored procedure to run as an authorized program: If your stored procedure runs in a WLM-established address space, you can run it as an MVS authorized program.
Question: Can we set up our WLM SP environment so none of the stored procedures run as authorized programs? [...]
22674 61 32_Re: User Exit - DB2 V6.1 for AIX13_Umair Hussain25_umair_hussain@HOTMAIL.COM28_Fri, 6 Oct 2000 10:47:14 CDT493_- Nope it only means that userexit "RETRIVE fucntion" wont be called during a rollforward recovery of a tablespace BUT .... you could move the logs manually yourself to the designated log path and it will work like a charm ..
regards Umair
Umair Hussain******************************** DBA Consultant * DB2 UDB, Oracle, Sybase, DataJoiner * IBM Certified Solution Expert - DB2 UDB DBA * IBM Certified AIX System Administrator * ********|All Disclaimers Apply|************** [...]
22736 64 25_Re: HOW TO USE CODE TABLE19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Fri, 6 Oct 2000 08:47:15 -0700443_big5 If you're asking about the best way to do lookups on a code table in the DB2 environment, the standard answer of "it depends" holds true as the best access method will depend on the application architecture:
An online transaction doing data capture and validation will normally do singleton selects against the code table based on the code value. Handle the notfound condition with an "invalid code" message back to the user. [...]
22801 25 36_Re: How to test for V6 -101 problem?0_29_paul.packham@POSTOFFICE.CO.UK30_Fri, 6 Oct 2000 16:57:20 +0000305_us-ascii Jay,
We have had two occurrences of programs returning sqlcode -101 on our site. If it does happen a workaround is to rebind the plan on DB2 V6. Also IBM have recommended to us to apply PQ40039/UQ46498. We applied theat fix two days ago. 'Touch wood' we have not had another failure. [...]
22827 85 30_Re: Comparing DataBase Changes12_craig patton21_prgpatton@HOTMAIL.COM28_Fri, 6 Oct 2000 16:12:52 GMT698_- CA-Platinum has a data compare feature (within RC/UPDATE) that can do this as well.
Craig Patton President/DBA Consultant Patton Research Group, Inc. "Specializing in Performance and PeopleSoft In DB2 for OS/390"
>From: "Mullins, Craig" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Comparing DataBase Changes >Date: Fri, 6 Oct 2000 10:32:52 -0500 > >There are two data comparison products I know of: > >- Comparex from Serena and; >- Compare for DB2 from Princeton Softech. > >And if you ever need to compare database structures, BMC's Change Manager >can accomplish that quite nicely. > >Craig S. [...]
22913 34 36_Re: How to test for V6 -101 problem?13_John Arbogast19_arbo@CP-DEMO.CP.NET30_Fri, 6 Oct 2000 09:15:32 -0700560_- We also encountered this problem on very short and simple statements. Our PMR with IBM led to the maint Paul mentions. After we applied it, we have not seen any more -101s. HTH
On Fri, 06 October 2000, paul.packham@POSTOFFICE.CO.UK wrote:
> > Jay, > > We have had two occurrences of programs returning sqlcode -101 on our site. If > it does happen a workaround is to rebind the plan on DB2 V6. Also IBM have > recommended to us to apply PQ40039/UQ46498. We applied theat fix two days ago. > 'Touch wood' we have not had another failure. > [...]
22948 28 14_Re: Hiperpools14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 6 Oct 2000 12:16:21 -0400608_ISO-8859-1 While I have not not looked at this particular hit ratio in Omegamon, I suspect it is artificially high and mis-leading. While I may be incorrect, I say this because their VP hit ratio calculation is wrong and mis-leading. Regards, Joel
Message text written by DB2 Data Base Discussion List >Our hiperpools run above 95% "hit ratios" (Omegamon DB2) and we use 10% read-to-write ratio as a minimum for justifying an HP UNLESS (key word, unless) a smaller read to write ratio still represents a LARGE amount of saved read I/O -OR- the additional hits reduce response times for a [...]
22977 69 14_Re: Hiperpools14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 6 Oct 2000 12:36:32 -0400417_ISO-8859-1 Max, I am somewhat reluctant to say what is really good here. Obviously the higher the better. Based on what I have seen at installations so far, I would say that any HP with a read-back ratio > 30% is giving good payback.
I don't use a "hit ratio" for HPs, only the read-back ratio, and generally keep the hpseqt rather low, and sometimes zero.... depending on the type of activity in the VP. [...]
23047 85 14_Re: Hiperpools11_Shigang Mai16_smai@METLIFE.COM30_Fri, 6 Oct 2000 13:14:46 -0400647_us-ascii Joel, Is there any reason you would keep the HPSEQT low or even zero? Thanks.
"Joel Goldstein" @RYCI.COM> on 10/06/2000 12:36:32 PM
Please respond to "DB2 Data Base Discussion List"
Sent by: "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM cc: Subject: Re: Hiperpools
Max, I am somewhat reluctant to say what is really good here. Obviously the higher the better. Based on what I have seen at installations so far, I would say that any HP with a read-back ratio > 30% is giving good payback. [...]
23133 58 14_Re: Hiperpools14_Richard Yevich17_ryevich@YAHOO.COM30_Fri, 6 Oct 2000 10:47:27 -0700617_us-ascii Wow! Another honest voice in the wilderness that is not afraid to tell the truth!!!
Way to go Joel! I get disbelief whenever I talk about the mis-information in those other performance monitors.
Richard
--- Joel Goldstein wrote: > While I have not not looked at this particular hit ratio in > Omegamon, > I suspect it is artificially high and mis-leading. While I may be > incorrect, > I say this because their VP hit ratio calculation is wrong and > mis-leading. > Regards, > Joel > > > Message text written by DB2 Data Base Discussion List [...]
23192 31 14_Re: Hiperpools0_26_truman.g.brown@VERIZON.COM30_Fri, 6 Oct 2000 12:58:16 -0400590_us-ascii I will second Joel Goldstein's comment on I/O saved relative to memory used. We have an application in a dedicated sub- system that had pretty dysmal performance. By allocating ob- jects to different and larger VBP's and adding moderately sized HP's we had on-line transaction improvements - some from 10 sec to 3 sec, some from 6 sec to sub-sec, all greatly improved with most into the sub-sec range; their nightly batch process ran five ours (elapsed) faster, and one daily batch job went from five hours to 88 minutes (I also agree with Joel on HPSEQT values being smaller [...]
23224 21 24_Stored Procdure Standard14_Philip Gunning18_pgunning@PHEAA.ORG30_Fri, 6 Oct 2000 13:20:42 -0400555_us-ascii I am posting this to the db2-l-documents list.
Phil Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA V6.1 IBM Certified Solutions Expert -- Database Adminstration V6.1 IBM Certified Solutions Expert -- Application Development V6.1 Assoc List Owner DB2-L pkg3@psu.edu
================================================ 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.
23246 26 12_SQL Question16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU30_Fri, 6 Oct 2000 14:32:39 -0400625_iso-8859-1 I want to be able to insert a comma between unloaded rows via dsntiaul. Can I do this via an sql statement rather then writing a program to accomplish this. I'd like the data to look like this...
12345,10/06/2000,abc,7.5
rather then this...
1234510/06/2000abc7.5
Thanks....
Michael Dempsey Data Base Administration UNC Health Care System
================================================ 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.
23273 48 16_Re: SQL Question12_Bob Lawrence21_rlawrence@BOSCOVS.COM30_Fri, 6 Oct 2000 14:41:38 -0400603_us-ascii yes but you will have to use the SQL parm and select each field with constant of SUBSTR(',',1,1) between each field. The substr function is to prevent the comma fields to be considered variable length fields with an embedded length byte.
HTH Bob Lawrence DBA Boscov's Dept Stores llc
On Friday, October 06, 2000 2:33 PM, Dempsey, Michael [SMTP:MDempse@UNCH.UNC.EDU] wrote: > I want to be able to insert a comma between unloaded rows via dsntiaul. Can > I do this via an sql statement rather then writing a program to accomplish > this. I'd like the data to look like [...]
23322 48 16_Re: SQL Question0_17_JTonchick@AOL.COM28_Fri, 6 Oct 2000 14:42:02 EDT496_US-ASCII Mike, since DSNTIAUL is supplied as assembler source, you could edit the source and create a a version (UNCTIAUL ?) that does what you want. That way the commas would always be inserted between the columns of any table you unload. This will save you from having to write a separate editing program for every table. And once you have the updated source, you can add it to SMP/E as a USERMOD so that if IBM changes DSNTIAUL, your version would also get the new changes automatically. [...]
23371 56 30_Re: DB2 Connect and 432 Error?0_15_leon@CA.IBM.COM30_Fri, 6 Oct 2000 15:02:01 -0400569_us-ascii What kind of Windows 2000 are you installing on (Professional, Server, Advanced Server)?
Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com
"Tierney, Mark" on 10/04/2000 05:03:52 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: DB2 Connect and 432 Error?
Greetings....
I am attempting to install the DB2 Connect V7 Runtime client on Windows 2000 and am receiving the following message: [...]
23428 44 26_Re: Indexes not being used13_John McNeilly23_johnmcneilly@MCMAIL.COM30_Fri, 6 Oct 2000 20:22:59 +0100500_us-ascii That's a good point Steve. Fortunately in this case all update processing was applied in a set overnight window when no end user activity was permitted so I was able to exclude any I/O during this period from my analysis.
I would agree with other contributors to this thread that there is no sure-fire way to identify index usage in an environment where dynamic SQL is allowed but given the right circumstance I believe that type 42 records are a valuable source of information. [...]
23473 45 26_db2/udb using Visual Basic13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET30_Fri, 6 Oct 2000 15:38:57 -0400169_us-ascii Are there anyone out there using Visual Basic front end to a DB2/udb v6.1 on unix server????
Having all kinds of problems connecting using odbc... thanks
23519 15 24_Indexes not being useful13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Fri, 6 Oct 2000 12:43:48 -0700505_- Even if an index is used for some ad-hoc reporting queries from time to time, wouldn't you want to drop it if the time taken to update it during your line of business transactions takes longer than the time saved during your overnight batch reports?
-HJC
================================================ 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.
23535 18 32_mulp db2 inst on same sun server11_David Ayers24_david.ayers@HIGHMARK.COM30_Fri, 6 Oct 2000 15:43:39 -0400324_us-ascii Does anyone know if there is a problem when installing a separate version of DB2 UDB (v6.1 fp 4) onto a server with an existing version(v5.2 fp 13). We had DB2 UDB v5.2 running and tried to install a new instance on the same server and ran into problems even though we specified different product directories. [...]
23554 33 36_Re: mulp db2 inst on same sun server12_Cook, Nicole19_Nicole_Cook@BMC.COM30_Fri, 6 Oct 2000 14:49:06 -0500623_iso-8859-1 What kind of errors are you getting? Make sure you are specifying the correct LIBPATH variable.
-----Original Message----- From: David Ayers [mailto:david.ayers@HIGHMARK.COM] Sent: Friday, October 06, 2000 2:44 PM To: DB2-L@RYCI.COM Subject: mulp db2 inst on same sun server
Does anyone know if there is a problem when installing a separate version of DB2 UDB (v6.1 fp 4) onto a server with an existing version(v5.2 fp 13). We had DB2 UDB v5.2 running and tried to install a new instance on the same server and ran into problems even though we specified different product directories. [...]
23588 79 39_Re: DB2 Connect extended security codes0_15_leon@CA.IBM.COM30_Fri, 6 Oct 2000 15:55:02 -0400498_us-ascii Microsoft SNA Server does not support extended security codes. IBM Communication Servers do and so does TCP/IP.
Just out of curiosity, what is stoping you from using TCP/IP?
Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com
Peter Boot on 10/03/2000 12:27:33 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: DB2 Connect extended security codes [...]
23668 62 36_Re: mulp db2 inst on same sun server11_David Ayers24_david.ayers@HIGHMARK.COM30_Fri, 6 Oct 2000 16:01:52 -0400306_us-ascii we got the error during the install of the v6.1 code. during the install it created links between the v6 product directories to the v5 products directories. We Could not stop the v5 instance and had to kill the processes (Solaris). We are now in the process of restoring the v5 product code. [...]
23731 17 35_MVS System's Programmer List Server16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU30_Fri, 6 Oct 2000 16:08:45 -0400377_iso-8859-1 Does anyone know if one is in existence?
Michael Dempsey Data Base Administration UNC Health Care System 919.966.4696
================================================ 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.
23749 19 39_Re: MVS System's Programmer List Server26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Fri, 6 Oct 2000 15:09:27 -0500382_- ==>There's one at bama.ua.edu/archives/ibm-main.html can sign- ==>up, or search the archives. It's been in business since 1986 and has ==>many of the developers from IBM and OEM vendors ==>participating. For eMail send us a note at listserv@bama.ua.edu in ==>the body of the text sub ibm-main your name Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...]
23769 30 39_Re: MVS System's Programmer List Server11_Doug Fuerst14_djfirst@LI.NET30_Fri, 6 Oct 2000 16:13:29 -0400462_us-ascii IBM-MAIN@BAMA.UA.EDU MVS/OS390
At 16:08 06-10-00 -0400, you wrote: >Does anyone know if one is in existence? > >Michael Dempsey >Data Base Administration >UNC Health Care System >919.966.4696 > >================================================ >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. [...]
23800 79 36_Re: mulp db2 inst on same sun server12_Cook, Nicole19_Nicole_Cook@BMC.COM30_Fri, 6 Oct 2000 15:20:15 -0500396_iso-8859-1 Did you specify an installation directory, or did you just take the defaults? I have several Solaris boxes with different version of UDB installed and I've never run into a problem.
-----Original Message----- From: David Ayers [mailto:david.ayers@HIGHMARK.COM] Sent: Friday, October 06, 2000 3:02 PM To: DB2-L@RYCI.COM Subject: Re: mulp db2 inst on same sun server [...]
23880 34 14_Re: Hiperpools14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 6 Oct 2000 16:41:33 -0400480_ISO-8859-1 Sure. I wantto favor the random pages. This is where you'll get the most benefit from HPs. If an object gets heavy scan you will get no benefit unles the sum of your VP + HP is > than the number of pages for an object. Scanned objects that cannot fit completely into a pool don't need a lot of pool space, since you just scan and scan and scan. I often leave "some" seq space in the HP, depending on what the benefit might be, and what the statistical data shows. [...]
23915 72 30_Re: DB2 Connect and 432 Error?13_Tierney, Mark20_mtierney@FIRSTAM.COM30_Fri, 6 Oct 2000 15:57:22 -0500656_- We are using Windows 2000 Professional.
Any ideas?
> -----Original Message----- > From: leon@CA.IBM.COM [SMTP:leon@CA.IBM.COM] > Sent: Friday, October 06, 2000 2:02 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Connect and 432 Error? > > What kind of Windows 2000 are you installing on (Professional, Server, > Advanced Server)? > > Leon Katsnelson, DB2 Connect Development Manager > mailto:leon@ca.ibm.com > > > "Tierney, Mark" on 10/04/2000 05:03:52 PM > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: > Subject: DB2 Connect and 432 Error? > > > > > Greetings.... [...]
23988 21 12_Data Sharing11_John Puglia21_JPUGLIA@MAIL2.PCH.COM30_Fri, 6 Oct 2000 16:49:28 -0400473_US-ASCII Does anyone know of any good books on Data Sharing, pertaining to OS/390 platform DB2 V6?
Any articles on this subject? I have found some but nothing in great detail.
I appreciate any feedback.
Thank you
===============================================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.
24010 25 0_17_Walter Trovijo Jr22_wtrovijo@COELBA.COM.BR30_Fri, 6 Oct 2000 17:47:22 -030030_us-ascii SEARCH DB2-L REXX DB2
24036 36 39_Re: MVS System's Programmer List Server12_Bob Lawrence21_rlawrence@BOSCOVS.COM30_Fri, 6 Oct 2000 17:06:21 -0400699_us-ascii it is at following site if you did not get the info yet For IBM-MAIN subscribe / signoff / archive access instructions, send email to listserv@bama.ua.edu with the message: GET IBM-MAIN INFO
Bob Lawrence DBA Boscov's Dept Stores Inc
On Friday, October 06, 2000 4:09 PM, Dempsey, Michael [SMTP:MDempse@UNCH.UNC.EDU] wrote: > Does anyone know if one is in existence? > > Michael Dempsey > Data Base Administration > UNC Health Care System > 919.966.4696 > > ================================================ > 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 [...]
24073 40 9_DDF Setup0_20_Jones.H@GRAINGER.COM30_Fri, 6 Oct 2000 16:11:00 -0500493_- We have a fairly new DB2 subsystem (version 5.0). DDF is set up, as far as I can tell. MSTR log says its started.
These guys area all out there. SYSIBM.LOCATIONS SYSIBM.LUNAMES SYSIBM.LUMODES SYSIBM.MODESELECT
But these guys do not exist: SYSIBM.SYSLOCATIONS SYSIBM.SYSLUNAMES SYSIBM.SYSLUMODES SYSIBM.SYSMODESELECT
From what I've read, I need to get the SYS-guys out there and then I'm ready to roll with DDF to another subsytem --- right??? How does one do that? [...]
24114 80 26_FW: longvar defined column12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM30_Fri, 6 Oct 2000 17:30:50 -0400548_iso-8859-1 This may occur with a differing codepage when using DB2 Connect.
-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Friday, October 06, 2000 12:13 AM To: DB2-L@RYCI.COM Subject: Re: longvar defined column
Steve,
Is, by any chance, the column is defined as 'for bit data' (syscolumns.foreignkey = 'B')? "SUBSTR(column,1)" might work.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...]
24195 76 13_Re: DDF Setup0_26_truman.g.brown@VERIZON.COM30_Fri, 6 Oct 2000 17:30:55 -0400443_us-ascii Hayden,
One set of tables was for pre V5; as of V5 they became catalog tables. You would only need both if you have a V4 DB2 coming into the V5 subsystem via DDF.
George
Jones.H@GRAINGER.COM on 10/06/2000 05:11:00 PM
Please respond to "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM
cc: (bcc: TRUMAN G. BROWN/EMPL/MD/Bell-Atl) [...]
24272 75 32_DB2 for OS/390 and MS SQL Server18_Bond, Victor - CFC20_Bond.Victor@CFWY.COM30_Fri, 6 Oct 2000 14:25:15 -0700379_iso-8859-1 Gurus,
I have been asked to research the following:
Is there a way to access a MS SQL Server data base from MVS/CICS/DB2 and back the other way. The access would be read and possibly write. I looked at Datajoiner. It seemed to be able to access SQL Server from UDB, but could not see anything about MVS DB2. I searched the archives and got no hits. [...]
24348 81 27_Comparing DataBase Changes.12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM30_Fri, 6 Oct 2000 19:27:36 -0400518_ISO-8859-1 Venlig,
Thanks for the additional information. We are on the 97F version of the product and while I'll have to reconfirm it, I know I have not been able to use fast unload on incremental copies. What I can't be sure of is if it was on a compressed table or not. When I asked support about this they confirmed the error message I had gotten, but did not mention anything about the feature being added already, or the limitation you mention. Do you remember which version this was implemented in? [...]
24430 55 65_Re: Stored Procedure programs running as MVS authorized p rograms14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Sat, 7 Oct 2000 17:39:52 +1100529_iso-8859-1 Make sure that at least one library in the STEPLIB concatenation is unauthorised. (Do you have _any_ libraries in the STEPLIB concatenation that are authorised?)
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au
-----Original Message----- From: Martin, Paul [mailto:Paul.Martin@ECOLAB.COM] Sent: Saturday, October 07, 2000 2:47 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Stored Procedure programs running as MVS authorized programs [...]
24486 18 40_Recovery of sysutilx, dbd01, and syscopy10_Lee Mandel16_DBMSUser@AOL.COM28_Sat, 7 Oct 2000 14:39:57 EDT386_US-ASCII Hi All, Since recovery information for sysutilx, dbd01, and syscopy do not reside in syscopy how do you do a recovery tocopy for these? Where and how do you get the dsnames of the image copies datasets. What DB2 manuals explains how the recover control cards look like for these three cat/dir tablespaces? I can't seams to find the information in the manuals. Thanks, Ed. [...]
24505 65 16_Re: Data Sharing12_Susan Lawson24_susan_lawson@YLASSOC.COM30_Fri, 6 Oct 2000 15:29:34 -0500354_iso-8859-1 Hi John,
In our new book 'DB2 High Performance Design and Tuning' Richard and I covered Data Sharing - V6 in great detail in 6 chapters. We cover topics from implementation, migration to performance and tuning.
Other references include (while some are back versions they are still good references - look for updates also) : [...]
24571 35 26_Install problem in UDB PDE8_ritu zee22_ritu_98_2000@YAHOO.COM30_Sat, 7 Oct 2000 14:40:21 -0700371_us-ascii Hi ,
I have recently downloaded the freely downloadable UDB Personal Developer's edition from IBM Website. After downloading, i unzipped the file and when i click on 'INSTALL'on my PC (Windows 98), it does not even start and straight away gives the following error :
"The requested language, 'EN',is not included with this DB2 install image". [...]
24607 70 30_Re: Install problem in UDB PDE14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Sun, 8 Oct 2000 14:29:16 +1100412_iso-8859-1 You need to download two files: a common file and a language specific file. Did you?
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au
-----Original Message----- From: ritu zee [mailto:ritu_98_2000@YAHOO.COM] Sent: Sunday, October 08, 2000 8:40 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Install problem in UDB PDE [...]
24678 61 44_Re: Recovery of sysutilx, dbd01, and syscopy14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Sun, 8 Oct 2000 14:56:17 +1100486_iso-8859-1 Ed
REPORT RECOVERY TABLESPACE DSNDB06.SYSCOPY CURRENT etc. No special RECOVERY control statements, but (of course) the special order of recovery.
Note however the manuals make a few points: - you should only do a point in time recovery on the catalog and directory if you made the suitable preparation at that point - if you don't use CURRENT on the REPORT RECOVERY, then the report will read all the way back through your (perhaps migrated) archive logs. [...]