1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2001, week 2
2 59 54_Re: DB2 for OS/390 DBA Certification - two complaints.14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Sun, 8 Jul 2001 08:52:17 -0500511_- Brendan,
A few other points:
- I presume you are aware of http://www-4.ibm.com/software/data/db2/skills/offer1.html
- the only gotya in the first test is that the SQL is assummed to be (in DB2 for OS/390 terms) SQL(STD) not SQL(DB2). So check on those differences.
- the pass marks are fairly low - I seem to recall 62% for the first and 68% for the second. So, even though the second test will have some V7 specifics, you can afford (well, you _might be able_) to blow them. [...]
62 63 15_Re: QMF Reports12_Troy Coleman29_troycci@COLEMANCONSULTING.COM30_Sun, 8 Jul 2001 15:30:40 -0500508_us-ascii In the past when I've done this I would just add a REXX step to format the data for further processing. I thought QMF now supports REXX in the PROC section. You could issue a QMF PRINT REPORT, followed by some rexx magic to format the data. Or I have a few other ideas. Why don't you send me your query and form off-line. I'll take a look at it and see what I can come up with to help you out. Has your shop setup the DB2 interface for REXX yet? If they have that might be another alternative. [...]
126 92 54_Re: DB2 for OS/390 DBA Certification - two complaints.15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Mon, 9 Jul 2001 09:57:11 +1000528_- Brendan,
James is right; the pass marks are fairly low. 55% and 63% for 512 and 516 respectively when I did them a month or so ago. Do the V7 online sample tests and if you get >75% (I think) they'll send you a voucher to do the test for real - saves you some money. A quick butchers at the V7 'What's New' manual, along with your OS/390 V6 experience, should be more than enough. And don't sweat the fundamentals. Yes there's 'little DB2' stuff in there but it's not too demanding. Get hold of a sample CD (maybe [...]
219 30 17_No Page Available11_Endy Lambey20_endyl@CENTRIN.NET.ID30_Mon, 9 Jul 2001 11:41:32 +0700393_- Guys...
We have two dbs on an AIX box with 1GB Memory and 150 GB HD, with 6 SSA HDs. and 2 SCSI HDs. Each db we assign 4 bufferpools. Sometimes we found this problem '...there are currently no page available...'
Can anybody give us a clue what cause this problem? Everytime we found this problem, we need to restart our Warehouse Services in order our application to run. [...]
250 54 32_Re: Row-lock /Page-lock Decision16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Mon, 9 Jul 2001 09:57:38 +0530421_- Teresa,
Row locking is definitely an overhead if the number of locks are getting very high. Normally row level locking is used for the reference table reads which has very high number of reads. Unless until there is no way out, using the row level locking for transaction tables process some large number of rows without being committing, is an overhead. If i am not wrong 1 lock cost 250 bytes of storage. [...]
305 48 21_Java Stored Procedure8_ritu zee22_ritu_98_2000@YAHOO.COM30_Sun, 8 Jul 2001 21:44:32 -0700504_us-ascii Hello !
I have a doubt regarding a stored procedure example given in IBM Application development guide....a sample Stored procedure demonstrating the use of an OUT host variable. The client program (whic calls the stored procedure) has the following piece of code:
Connection con = DriverManager.getConnection("jdbc:db2:sample");
outLanguage(con); outParameter(con); inParameters(con); inoutParam(con, outMedian); resultSet(con); twoResultSets(con); allDataTypes(con); [...]
354 22 11_Re: LevelId15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA30_Mon, 9 Jul 2001 09:24:40 +0200416_us-ascii Thanx ... I'll check into that. We are using a data sharing environment.. The expected levelid was higher than the encountered levelid - but we are doing a very large push in terms of modifies, and have several issues regarding this , so potentially this might be the reason.
I'm going to check with our systems-side guys as to APAR level's suggested, and I'll let you know if that solves it... [...]
377 26 12_TSs into CF?0_18_mebert@AMADEUS.NET30_Mon, 9 Jul 2001 10:03:07 +0200555_us-ascii Hello List,
I've just received a question from the MVS group: would it make sense to put DB2 table/indexspaces into the Coupling Facility in order to improve performance? (We're OS/390, DB2 V5/V6, and NOT Data-Sharing). What are the pros/cons/gotchas? What kind of TSs would be good candidates for a legacy system with mixed DSS type applications and OLTP (V5)? For SAP (V6)? It seems there are ongoing problems with the disk subsystems that do not show any sign of being resolved, and the hope is that we can bypass this bottleneck. [...]
404 21 32_Re: Row-lock /Page-lock Decision15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Mon, 9 Jul 2001 03:41:55 -0500500_- Teresa
I am a DBA too, and I neither like row level locking. If anybody thinks he will need that, first of all I will ask him the following questions:
1. Are there update simultaniously or does one guy update and the other read and can dirty read be afforded? 2. Are you in data sharing ? (Then the overhead is even more) 3. How many rows are in your table? Is NUMROWS an option? 4. Can the rows, which are processed simultaniously be seperated by changing the clustering index? [...]
426 19 16_Re: TSs into CF?15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Mon, 9 Jul 2001 03:48:23 -0500314_- Michael
I always thought, you only can use group buffer pools, when you are IN data sharing or what do you mean with putting tablespaces in the CF?
If you aren't in data sharing then there will be any tablespace ever group buffer pool dependent are there is no need for DB2 to look at the CF. [...]
446 82 32_Re: Row-lock /Page-lock Decision13_Patric Becker25_Patric_Becker@SIS-WEST.DE30_Mon, 9 Jul 2001 03:56:56 -0500437_ISO-8859-1 Hi Teresa !
Finding advantages of row level locking is a pretty good challenge :-)
I think the choice of the isolation level depends on available resources (e.g. to aquire a lock takes 10 microseconds for each lock / unlock). When there´s enough "power" and there are no long-running transactions, it shouldn´t be a big problem (but row level locking shouldn´t become the default for all your tablespaces). [...]
529 55 32_Re: Row-lock /Page-lock Decision14_Vassie, Edward21_Edward_Vassie@BMC.COM30_Mon, 9 Jul 2001 04:25:57 -0500297_iso-8859-1 I will go with the DBA on this one...
It would be good practice to start with page-level locking, and only change this if a real problem is experienced in production. I would feel that one timeout every 6 hours is not a real problem, but one timeout every hour probably is. [...]
585 156 32_AW: Row-lock /Page-lock Decision12_Peter, Georg15_G.Peter@DZBW.DE30_Mon, 9 Jul 2001 11:29:54 +0200380_iso-8859-1 Teresa, Patric, Walter,
The nature of YOUR specific application and data determines wether page or row locks are most applicable.
Please keep in mind that the resources required to aquire, maintain, and release a row lock are nearly the same as the resources required for a page lock... The more rows per page, the more resources will be consumed... [...]
742 35 16_Re: TSs into CF?0_18_mebert@AMADEUS.NET30_Mon, 9 Jul 2001 11:25:12 +0200478_us-ascii Hi Walter,
the way I understand it, the CF is mostly a MVS/Parallel Sysplex thing; much more than a DB2/Data Sharing thing. And I think I've heard somewhere that you can put heavily accessed files (or other resources?) into the CF to shorten the access path to them. However, the question I've received "would it help to put DB2 TSs into the CF" currently leaves me absolutely clueless, so I'm hoping somebody on the list has an idea what might be meant... [...]
778 23 90_Reminder - Pittsburgh area - Advanced SQL Class July 23-24 - Terry Purcell, YL&A - $200 PP10_Cathy Peck23_cathy.peck@HIGHMARK.COM30_Mon, 9 Jul 2001 06:09:53 -0400363_us-ascii Hi all! Just wanted to drop everyone a reminder about the Advanced SQL Class. If you're interested but haven't registered yet, let me know as soon as possible....
On July 23rd-24th, Terry Purcell from YL&A will be teaching the Advanced SQL Class in Pittsburgh. The cost of the 2-day class is $200 if you are associated w/the Pitt User Group. [...]
802 81 54_Re: DB2 for OS/390 DBA Certification - two complaints.20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM30_Mon, 9 Jul 2001 11:17:46 +0100345_iso-8859-1 Hi Susan,
Would people (like me) who already have the Baklarz/Wong UDB 7.1 Certification Guide be better off using that for 512 exam preparation, or does your book cover the Fundamentals stuff as well as the OS/390 stuff?
By the way, amazon.com quotes 27th July for availability, but amazon.co.uk says 31st August. [...]
884 21 36_Re: AW: Row-lock /Page-lock Decision15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA30_Mon, 9 Jul 2001 12:27:15 +0200405_us-ascii As mentioned by other people - the decision for us came down to con-currency. Row-level locking is only really justified (imho) for very small tables with very high concurrency requirements. I guess that the maxrows or padding of pages works , but since it only results in the same solution as the row-level locking, and has a (small) space costs, I prefer row-level locking in those cases. [...]
906 63 40_Re: Closing a long run UOW and rollback.12_Myron Miller22_myronwmiller@YAHOO.COM30_Mon, 9 Jul 2001 05:16:37 -0700593_us-ascii Roger, I don't entirely agree with you. I think that there are cases where cancelling without a rollback is not that bad. Certainly, you must be careful in this situation. However, say you have a test system where the data is easily recreated from image copies from production. Then if some application programmer gets an update program in a loop and it runs for a considerable amount of time before being caught. Without the ability to cancel without a rollback, essentially you have two choices. Either let it rollback for the extended hours (and I've seen where this could be [...]
970 37 27_Re: 390 SQL runtime control11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Mon, 9 Jul 2001 09:00:03 -0400450_iso-8859-1 You may want to check out what the vendors have out there. I have used the Thread-Sentry series from Relational Architects (www.relarc.com). It is very powerful for both dynamic and static SQL. It can monitor resources other than CPU as well such as time and I/O.
-----Original Message----- From: Cheung, Teresa [mailto:cheungt@TOYSRUS.COM] Sent: Friday, July 06, 2001 10:32 AM Subject: 390 SQL runtime control [...]
1008 87 16_Request for help10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 9 Jul 2001 15:54:18 +0200417_iso-8859-1 Estimeed list...
I received some request about a REXX for reading SYSLGRNX records. Sometimes I use this REXX and it works, but before to insert it in DB2-L documents I need someone who tests this REXX to understand if it works properly. Can anyone help me ?
It's easy to use:
1) You've to REPRO SYSLGRNX to a sequential file (RECFM=FB, LRECL=4096) NOT production SYSLGRNX !! ;-) [...]
1096 59 32_Re: Row-lock /Page-lock Decision13_Daniel Turner28_daniel_turner@ALBERTSONS.COM30_Mon, 9 Jul 2001 08:04:22 -0600369_iso-8859-1 I dissagree.
The OVERHEAD of locks is based on the NUMBER of locks which is unrelated to the SIZE of the locks.
Commit frequencys for long running threads need to be controlled. Big batch jobs need recovery and restart logic to control this and programmers can do this when they want to. There are vendor products to help in this as well. [...]
1156 105 54_Re: DB2 for OS/390 DBA Certification - two complaints.12_Susan Lawson24_susan_lawson@YLASSOC.COM30_Mon, 9 Jul 2001 09:14:25 -0500333_iso-8859-1 Hello Hugh,
The Baklarz/Wong book does have some additional information you will need for the 512. We covered quite a bit of the 512 (DB2 Products, SQL), however there is still some information required for the test that we did not cover, however it is a small amount(such as more Control Center information). [...]
1262 36 40_Re: Closing a long run UOW and rollback.10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 9 Jul 2001 16:12:25 +0200591_us-ascii I agree with you Myron.
No one want to create new occasions to destroy data integrity, but it's undeniable that at least once in the life a DB2 sysprog met a never ending rollback, expecially on Monday.
At present there are many ways to destroy data integrity but if we created the correct procedures to recover data and if the recovery procedure is managed properly the risk is minimum. I think it's better to cancel a rollback and to execute recoveries (so only few tablespaces are involved in the recovery) instead to wait for that never ending rollback or to [...]
1299 38 15_Re: QMF Reports14_Binder, Ben A.20_Ben.Binder@ISPAT.COM30_Mon, 9 Jul 2001 09:24:26 -0500464_iso-8859-1 I've been saving this one a long time, I think it's what you're looking for. Thanks to Dave. ---------- From: Whitmer, David M. To: BABIND; RSTREM; DB2-L Subject: Re: [DB2-L] saving qmf output to dsqprint Date: Tuesday, August 19, 1997 10:04AM
First, try changing your report options to:
print report (length=cont,datetime=no,pageno=no
to also eliminate the current date/time and page numbers at the end of the report. [...]
1338 62 27_Re: how to compare 2 tables13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Mon, 9 Jul 2001 09:37:08 -0500293_iso-8859-1 Eric,
To compare two tables I simply run a full outer join between the two (provided they are in the same subsystem) on all columns. If I retrieve any NULLs, then there are differences either with the values on two rows, or rows existing in one table and not the other. [...]
1401 141 16_Re: TSs into CF?14_Crichton, Jean21_jcrichton@FEDDATA.COM30_Mon, 9 Jul 2001 10:48:42 -0400587_iso-8859-1 I would ask what kinds of disk subsystem problems you are having and what are the bottlenecks? Enabling data sharing won't necessarily help you avoid disk subsystem problems. Your data will still reside on disk and ultimately be written to disk. If you need to spread your data out to avoid bottlenecks, enabling data sharing isn't going to do a thing to help, since it spreads work out across processors and DB2s, not disk. Having said that, I think there are both performance and availability advantages to data sharing, and it might very well be a good thing for your [...]
1543 148 20_Re: Request for help0_18_mebert@AMADEUS.NET30_Mon, 9 Jul 2001 16:39:28 +0200417_iso-8859-1 I have found these errors:
0.) (trivial) the DBID= ... line is duplicated. 1.) (Remark only) It would be much nicer to initialise CT with 0 - then it would actually mean what it suggests it means, namely a counter for the records found. 2.) You have to provide a record count to the output operation: either "EXECIO "CT"DISKW..", or execute VAR.0=CT first (this assumes initialisation with 0). [...]
1692 32 20_Re: Request for help10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 9 Jul 2001 17:16:28 +0200371_us-ascii Hi Dr Ebert
Thank for your help. I'll correct errors. Duplicate DBID is a cut & paste error.
I used count=1 at the beginning so it's easy to insert the header in output file. I think this is not a problem.
The partition number is not present in this REXX, but in the original it is as it's easy to read. I'll put this value in the next [...]
1725 172 20_Re: Request for help15_Murley, Michael22_Michael_Murley@BMC.COM30_Mon, 9 Jul 2001 10:35:43 -0500332_iso-8859-1 One additional comment:
Even if you follow the ID map, as Dr. Ebert suggests, you may find SYSLGRNX entries that represent table spaces that have been dropped. The SYSLGRNX entries are not deleted when a table space is dropped; they are instead cleaned up when a new space is created with the same DBID/PSID. [...]
1898 25 20_Re: Request for help10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 9 Jul 2001 17:54:24 +0200541_us-ascii Hi Michael & thanks for your reply.
Of course it's possible to have SYSLGRNX entries even if the tablespace doesn't exist anymore. It's well known since last May . Some IBM people confirmed it ('working as design').
The REXX exec it's a part of a more large exec and I do not want to eliminate invalid records (ie belonging to dropped tablespaces). I'm just checking point 6) but until now I've found no strange records. I'll check again as I'm sure that DR Ebert is right (I was told to check this some by IBM). [...]
1924 214 20_Re: Request for help11_Carl Nelson22_Carl.Nelson@ANTHEM.COM30_Mon, 9 Jul 2001 10:55:20 -0500524_iso-8859-1 Can you put in an SQL call to get obid/dbid's?
Carl Nelson 785-330-0346
Roy Faulkner To: Carl Nelson/IN002/AICI/US@AICI 07/09/2001 cc: 10:37 AM Subject: Re: Request for help(Document link: Carl Nelson - Local)
Carl,
It does seem to work. It should be able to run in a batch enviornment.
Roy
Carl Nelson To: Roy Faulkner/KY/AICI/US@AICI 07/09/2001 cc: 10:17 AM Subject: Request for help [...]
2139 125 11_DB2 Connect0_24_Bruce.Williamson@PSIR.IE30_Mon, 9 Jul 2001 17:05:48 +0100833_iso-8859-1 Howzit Folks?
Can anyone tell me specifically what the restrictions are with the limited edition version of DB2 Connect that is an optional component of DB2 UDB for OS/390 Version 6.
Cheers Bruce
__________________________________
Bruce Williamson DB2 Database Administrator
Perot Systems Information Resource Computer Centre Cabinteely Dublin 18 Ireland
Bruce.Williamson@psir.ie
******************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately at MailManager@psir.ie and delete this E-mail from your system. Thank you. [...]
2265 120 7_DB2 AIX0_24_Bruce.Williamson@PSIR.IE30_Mon, 9 Jul 2001 17:08:43 +0100826_iso-8859-1 Howzit Folks?
What are the communications options for connecting from DB2 or Oracle on AIX to DB2 on OS/390?
Cheers Bruce
__________________________________
Bruce Williamson DB2 Database Administrator
Perot Systems Information Resource Computer Centre Cabinteely Dublin 18 Ireland
Bruce.Williamson@psir.ie
******************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately at MailManager@psir.ie and delete this E-mail from your system. Thank you. It is possible for data transmitted by email to be deliberately or [...]
2386 16 20_mysterious optimizer23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Mon, 9 Jul 2001 12:12:09 -0400595_us-ascii *********************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************
================================================ 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.
2403 104 0_33_=?iso-8859-9?Q?R.Teoman_KO=C7ER?=22_tkocer@HALKBANK.COM.TR30_Mon, 9 Jul 2001 15:05:34 +0300361_iso-8859-9 dear list members i have a problem connecting db2 table using tcpip for selecting all columns to form a recordset. i am getting following error DSNL511I * DSNLIENO TCP/IP CONVERSATION FAILED 331 TO LOCATION 10.9.5.215 IPADDR=10.9.5.215 PORT=1523 SOCKET=WRITEV RETURN CODE=140 REASON CODE=745A7242 anybody to know how to solve this ? thanks in advance
2508 63 28_DB2/OS390 V5 to DB2/OS390 V725_Taylor, Donald L. - TPDLT18_DTaylor@SEMPRA.COM30_Mon, 9 Jul 2001 09:35:36 -0700180_iso-8859-1 Hi all,
Is there an information APAR out there documenting maintenance levels when migrating from DB2 V5 to DB2 V7?
Thanks,
Don Taylor Sempra Energy
2572 168 15_Re: DB2 Connect0_24_Bruce.Williamson@PSIR.IE30_Mon, 9 Jul 2001 18:31:18 +0100450_iso-8859-1 Howzit Folks?
I need to clarify this question, can anyone tell me specifically what the restrictions are with the "restricted use" version of DB2 Connect that is provided with DB2 UDB for OS/390 Version 6.
Cheers Bruce
-----Original Message----- From: Bruce.Williamson@PSIR.IE [mailto:Bruce.Williamson@PSIR.IE] Sent: 09 July 2001 17:06 To: DB2-L@RYCI.COM Subject: DB2 Connect
Howzit Folks? [...]
2741 26 32_Re: DB2/OS390 V5 to DB2/OS390 V70_36_doreenrowland@NORTHWESTERNMUTUAL.COM30_Mon, 9 Jul 2001 12:41:03 -0500378_ISO-8859-1 IBM has mentioned that for OS/390 you should pull the PSP/buckets for V6 and for V7 and do both of those for the V5 to V7 upgrade.
-----Original Message----- From: DTaylor [SMTP:DTaylor@SEMPRA.COM] Sent: Monday, July 09, 2001 11:36 AM To: DB2-L Cc: DTaylor Subject: DB2/OS390 V5 to DB2/OS390 V7
<< File: DB2_OS390 V5 to DB2_OS390 V7.HTM >> [...]
2768 134 15_Re: DB2 Connect12_tim malamphy20_timalamphy@YAHOO.COM30_Mon, 9 Jul 2001 11:07:37 -0700337_us-ascii In answer to your first post, TCP/IP is the communications.
If you're just going to connect a UDB on AIX with DB2 on OS/390, you can do that by cataloging the OS/390 subsystem on UDB, and adding the UDB node to the OS/390 system, and get the whole thing working via DDF (the DIST) part of OS/390 over a TCP/IP link. [...]
2903 81 11_DB2 Connect14_Philip Gunning24_Philip.Gunning@QUEST.COM30_Mon, 9 Jul 2001 11:08:36 -0700371_- Bruce, I believe you are referring to DB2 Connect Personal Edition which is provided for use when administering objects on OS/390 or Z/OS with the Control Center. This is spelled out in the DB2 V6.1 announcement letter. Phil
-----Original Message----- From: Bruce.Williamson@PSIR.IE To: DB2-L@RYCI.COM Sent: 7/9/01 10:31 AM Subject: Re: DB2 Connect [...]
2985 16 20_mysterious optimizer23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Mon, 9 Jul 2001 14:09:59 -0400588_us-ascii **************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************
================================================ 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.
3002 101 15_Re: DB2 Connect13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Mon, 9 Jul 2001 13:27:53 -0500346_iso-8859-1 Howdy, I am sure it means you cannot use the "restricted use" software for purposes other than what it was delivered to support. It has full functionality. In other words, you cannot use this version of DB2 connect to support a web application or other application. You have to buy licenses for those other applications and uses. [...]
3104 62 11_SQL problem15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Mon, 9 Jul 2001 14:56:43 -0400601_iso-8859-1 I created two sample table
create table l3728.test1 (col1 char(7),col2 char(1))
create table l3728.test2 (col1 int,col2 char(1))
insert into l3728.test1 values ('1','A')
insert into l3728.test1 values ('2','B')
insert into l3728.test1 values ('NS','C')
insert into l3728.test1 values ('PS','D')
insert into l3728.test2 values (1,'H')
insert into l3728.test2 values (2,'I')
insert into l3728.test2 values (10,'J')
select * from l3728.test1 A, l3728.test2 B where int(a.col1) = b.col1 with ur [...]
3167 44 34_Re: Declarative RI and prefetching31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL30_Mon, 9 Jul 2001 21:48:53 +0200430_iso-8859-1 Thanks Roger, but does this mean that prefetching, in what ever way, is not trigged ?
Douwe van Sluis Infodemic B.V. IT-Specialist +31 (0) 6 53 96 95 23 www.infodemic.nl
-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]Namens Roger Miller Verzonden: vrijdag 6 juli 2001 17:21 Aan: DB2-L@RYCI.COM Onderwerp: Re: Declarative RI and prefetching [...]
3212 13 48_Using EMC Timefinder for DB2 Disaster Recovery ?0_25_Garry.C.1@BWC.STATE.OH.US30_Mon, 9 Jul 2001 15:45:20 -0400520_- My company is currently considering utilizing EMC Timefinder and DB2 Version 6.0 Copy for our Disaster Recovery Strategy. We would like to do volume dumps weekly in conjunction with Image Copy/Incremental Image Copies daily. Is anyone familiar with the EMC Timefinder product?
================================================ 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.
3226 138 15_Re: DB2 Connect0_24_Bruce.Williamson@PSIR.IE30_Mon, 9 Jul 2001 21:38:57 +0100490_windows-1252 Howzit Phil, Tim & Glenn?
Thanks the info.
Cheers Bruce
-----Original Message----- From: Philip Gunning [mailto:Philip.Gunning@QUEST.COM] Sent: 09 July 2001 19:09 To: DB2-L@RYCI.COM Subject: DB2 Connect
Bruce, I believe you are referring to DB2 Connect Personal Edition which is provided for use when administering objects on OS/390 or Z/OS with the Control Center. This is spelled out in the DB2 V6.1 announcement letter. Phil [...]
3365 180 34_Re: Restart(current) in a load job14_Crichton, Jean21_jcrichton@FEDDATA.COM30_Mon, 9 Jul 2001 16:48:49 -0400564_iso-8859-1 Jaydeep,
I didn't see anybody biting on this one, so.... You actually performed a current restart when you specified RESTART by itself, as you suspected. You failed on the RESTART(CURRENT) because it was syntactically incorrect. The only valid parameters to use in JCL for DB2 V6 utilities are RESTART or RESTART(PHASE). Your DD allocations were correct, but check out the section 2.9.2.5 on terminating or restarting a LOAD utility in the DB2 UDB for OS/390 V6 Utility Guide and Reference for a sanity-check if you haven't already done so. [...]
3546 22 44_Lane Kelly/Boulder/IBM is out of the office.10_Lane Kelly18_ltkelly@US.IBM.COM30_Mon, 9 Jul 2001 14:40:16 -0600444_us-ascii I will be out of the office starting July 9, 2001 and will not return until July 11, 2001.
I will respond to your message when I return. Please contact the following Claim,BMSA, BMSB, BMSD: Patrick Mehrhoff 651-982-1176 BMSDEV2: Marv Paulson 612-397-6921 O&M(VSAM) & NWN(Datacom): Zakee Shahid 650-588-1361 XCEL(Datacom,Oracle): Rhonda Cherniet 818-989-0075 Any other issues contact my manager: Clarence Owens 303-754-3536 [...]
3569 232 18_Career Opportunity11_Harold Hill24_hhill@EMPYREAN-GROUP.COM30_Mon, 9 Jul 2001 16:44:12 -0400579_iso-8859-1 Hello,
This message is from Harold Hill with SunTrust Bank in Orlando, FL. Currently, we are looking for several IT resources, in particular a DB2 DBA to join our Advanced Technology Team. I would like to speak to you in detail in regards to this position and your current situation. Please give me a call at your earliest convenience at the number below, so that we may discuss these opportunities further. If for any reason you are not interested at this time, please contact me as you may know of someone currently looking that we can both help. I look [...]
3802 27 24_SQL access path question15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Mon, 9 Jul 2001 18:31:28 -0400485_iso-8859-1 Table TAB1 has a column col1 with Char(6) and Table TAB2 has column col2 with Char(2)
Then I have the following SQL
select * From TAB1 left outer join TAB2 on TAB2.col2 = substr(TAB1.col1,1,2) where TAB1.col1 = ?
I have a index on col2 in TAB2, but it is not used. Query is doing a table space scan on TAB2 and using index on TAB1. TAB2 has around 1000 rows. All this is on DB2 V6.1 on OS/390 V2.9. Is there anyway can I make use of index on TAB2. [...]
3830 70 17_DB2 system tables10_Grace Chen22_gchen@CUCENTRAL-AB.COM30_Mon, 9 Jul 2001 16:29:09 -0600465_iso-8859-1 Hi! Where can I found the explanation of each column in the DB2 system tables? For example: in the sysibm.systablespace, it has column close rule , type, lock size, lock part..........
Thanks! Grace Chen Technical Support Credit Union Central Alberta Ltd. Tel: (403) 258-5982 E-mail : gchen@cucentral-ab.com
_______________________________________________________ eSafe Protect Gateway has scanned this mail for viruses, vandals and
3901 97 21_Re: DB2 system tables15_Hagedorn, Linda20_lindah@EPOCRATES.COM30_Mon, 9 Jul 2001 15:55:08 -0700535_iso-8859-1 http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH10/D.0
-----Original Message----- From: Grace Chen [mailto:gchen@CUCENTRAL-AB.COM] Sent: Monday, July 09, 2001 3:29 PM To: DB2-L@RYCI.COM Subject: DB2 system tables
Hi! Where can I found the explanation of each column in the DB2 system tables? For example: in the sysibm.systablespace, it has column close rule , type, lock size, lock part.......... [...]
3999 36 21_Re: DB2 system tables0_21_db2_dba@BELLSOUTH.NET30_Mon, 9 Jul 2001 18:56:26 -0400693_us-ascii Take a look in the back of the SQL manual. One of the appendix sections contains a column by column explanation of each system table.
At 04:29 PM 7/9/01 -0600, you wrote: >Hi! >Where can I found the explanation of each column in the DB2 system tables? >For example: >in the sysibm.systablespace, it has column close rule , type, lock size, >lock part.......... > >Thanks! >Grace Chen >Technical Support >Credit Union Central Alberta Ltd. >Tel: (403) 258-5982 >E-mail : gchen@cucentral-ab.com > > >_______________________________________________________ >eSafe Protect Gateway has scanned this mail for viruses, vandals and >suspicious attachments. [...]
4036 106 21_Re: DB2 system tables0_19_csutfin@AMSOUTH.COM30_Mon, 9 Jul 2001 18:12:15 -0500359_iso-8859-1 Grace
You did not mention which platform or version of DB2.
For OS390 DB2 V6 you will find the information in the SQL Reference.
Or you can got the the IBM DB2 (platform of you choice) Library, pick your version and then search on SYSTABLESPACE.
This should give you a list of the manuals to start looking through. [...]
4143 58 30_Re: DEADLOCK ON PACKAGE REBIND15_Michael McGuire32_Michael.McGuire@COLESMYER.COM.AU31_Tue, 10 Jul 2001 10:31:07 +1000346_iso-8859-1 This is smiler to a problem that we have been having in the last week in our datasharing environment. (We're at V5.) We're still researching APARs, but a workaround has been to do a rebind (a bind would work too) on the other related subsystem. That then frees the global locks and allows for the failed bind job to be restarted. [...]
4202 55 25_Re: Java Stored Procedure14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Mon, 9 Jul 2001 20:03:33 -0500413_- It appears that someone took the code in samples/java/Spclient and half- butchered it. The methods, other than outParameter, appear in the actual sample code - but not in the manual. The missing methods do other things, and are not relevent to the example demonstrated.
From your question, it appears that you overlooked the code for outParameter on the next page - which shows why "con" is passed. [...]
4258 72 28_Re: SQL access path question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Mon, 9 Jul 2001 22:14:34 -0500465_iso-8859-1 Sibi,
V7 can use an index on this column expression, provided the column expression is accessed first in the pair-wise join (which it is in this case).
Until then, you need to materialize the column expression before the join using DISTINCT or GROUP BY, such as
select * From (select DISTINCT substr(TAB1.col1,1,2) as subcol1, TAB1.* from TAB1 where TAB1.col1 = ?) as SUBTAB1 left outer join TAB2 on TAB2.col2 = SUBTAB1.subcol1 [...]
4331 95 28_Re: SQL access path question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Mon, 9 Jul 2001 22:45:11 -0500342_iso-8859-1 Sibi,
One other thing I just realized. Since you already know the value of TAB1.col1 (since it is an equals predicate = ?), then you could substitute the exact 2 characters in the original ON clause. Or majority of non-column expressions are stage 1 and indexable, so you could also change the SUBSTR to substr(?,1,2). [...]
4427 14 51_Michael Armour/GL/KSC/KeyCorp is out of the office.17_Michael T. Armour26_Michael_Armour@KEYBANK.COM31_Tue, 10 Jul 2001 01:00:31 -0400386_us-ascii I will be out of the office from 07/09/2001 until 07/16/2001.
All questions/concerns should be forwarded to Jim Szabo at 2-5865.
================================================ 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.
4442 16 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Tue, 10 Jul 2001 01:14:37 -0500447_us-ascii I will be out of the office starting 07/10/2001 and will not return until 07/11/2001.
I will be out of the office for the remainder of the day. I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4459 23 11_Re: LevelId15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Tue, 10 Jul 2001 09:55:45 +0200311_us-ascii Jean, et al.
To quote our vendors' systems DBA, "PQ40974/UQ47157 looks like a very good hit. ". It seems to match our scenario exactly. We'll be implementing as soon as red tape etc. is done. It's a bit difficult to know how to re-create the problem, but this does feel like the right fix. [...]
4483 86 15_Re: SQL problem11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Tue, 10 Jul 2001 12:14:53 +0200553_iso-8859-1 Hi Philip,
just some thoughts to your mail ...
>select * >from l3728.test1 A, > l3728.test2 B >where int(a.col1) = b.col1 >with ur
>This is returning result as follows
>COL1 COL2 COL1 COL2 >------- ---- ----------- ---- >1 A 1 H >2 B 2 I >(null) (null(null) (null >(null) (null(null) (null
>I expected only two rows, but got 4, one for each non numeric value in test1 >table. I cannot execute this one from QMF, getting -420, but works fine >through ODBC. Any idea why this is not working through QMF. [...]
4570 28 32_Page Problem, NEED HELP A.S.A.P.11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Tue, 10 Jul 2001 17:40:54 +0700313_- Dear guys,
We encounter a problem whenever many of our users try to query a table at the same time. The table is a fact table, part of our Data Warehouse Star Schema. The message of problem contains this message "...there is currently no page available ..."
How can we overcome this problem? [...]
4599 13 22_Re: Career Opportunity15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Tue, 10 Jul 2001 06:25:06 -0500374_us-ascii Thanks for the interest Harold, but the wife would never let me move to Florida without her, and noway is she going for 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.
4613 48 68_DB2 OS/390 V6.1: Question on Cursor Declaration and Fetch Statements0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Tue, 10 Jul 2001 07:33:54 -0400430_us-ascii Hi,
We have a situation where an application programmer coded the example below by mistake yet the compile and bind were successful. A cursor was declared selecting 4 columns from a table. However, the fetch was coded using 5 columns. We're wondering why the compile and/or bind were successful. Shouldn't the validity checking in the bind step catch this? We'd appreciate anyone shedding some light on this. [...]
4662 82 93_nonsense enclosed, those with no sense of humour please delete before becoming irritated!!!!!16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 10 Jul 2001 12:47:32 +0100366_us-ascii LESSONS FOR CUSTOMER SUPPORT (when restaurants will work same as Microsoft/Oracle).
Client: Waiter!
Waiter: Hi, my name is Bill and I am your support waiter. What seems to be the problem?
Client: There's a fly in my soup!
Waiter: Try again, maybe the fly will no longer be there this time.
Client: Nope. Still there. [...]
4745 201 71_Re: DB2 OS/390 V6.1: Question on Cursor Declaration and FetchStatements12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 10 Jul 2001 08:03:50 -0400754_US-ASCII What did you have for BIND options? Validate (RUN) or VALIDATE(BIND)?
Troy Coleman Coleman Consulting, Inc.
IBM Certified Solutions Expert DB2 V7.1 Database Administration for OS/390 DB2 UDB V5 Database Administration IBM Certified Advanced Technical Expert DB2 -DRDA
Voice: (847) 722-2698 Email: troycci@colemanconsulting.com
>>> Ed_Vetock@NAVYFEDERAL.ORG 07/10/01 07:33AM >>> Hi,
We have a situation where an application programmer coded the example below by mistake yet the compile and bind were successful. A cursor was declared selecting 4 columns from a table. However, the fetch was coded using 5 columns. We're wondering why the compile and/or bind were successful. Shouldn't the validity [...]
4947 89 73_Re: DB2 OS/390 V6.1: Question on Cursor Declaration and F etch Statements0_19_mike.holmans@BT.COM31_Tue, 10 Jul 2001 13:07:44 +0100625_iso-8859-1 As a slightly indirect answer, if you only specified three host variables on the FETCH, SQLWARN3 in the SQLCA would be set to 'W'.
In other words, no, the pre-compile/bind does not validate the FETCH against the cursor declaration. Which is, in some ways, reasonable.
If you were really weird, you could decide to call *all* the cursors in your application program C1. You could certainly have four alternative paths through a program each opening a cursor, which could be called C1 in each case. How, unless the pre-compile/binds are supposed to follow the tortuous logic of the spaghetti code [...]
5037 73 73_Re: DB2 OS/390 V6.1: Question on Cursor Declaration and Fetch Sta tements16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 10 Jul 2001 17:43:05 +0530301_- I do not think this gives an error because there is no error here. If the number of host variable was less than the columns then DB2 would not have found the (missed) host variable where the value in the column needs to be put in, then it would have given some SQLCODE of series + or - 300(+). [...]
5111 117 21_Re: DB2 system tables10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Tue, 10 Jul 2001 06:44:03 -0600438_iso-8859-1 Thanks Carol. We are running DB2 V7 on OS/390. Your information is really helpful.
Grace -----Original Message----- From: csutfin@AMSOUTH.COM [mailto:csutfin@AMSOUTH.COM] Sent: Monday, July 09, 2001 5:12 PM To: DB2-L@RYCI.COM Subject: Re: DB2 system tables
Grace
You did not mention which platform or version of DB2.
For OS390 DB2 V6 you will find the information in the SQL Reference. [...]
5229 60 36_Re: Page Problem, NEED HELP A.S.A.P.14_Scott Saunders20_ssaunders@SIEBEL.COM31_Tue, 10 Jul 2001 06:02:00 -0700364_iso-8859-1 Endy; Are you out of bufferpool space for the given object? You might want to check your diagnostic logs for any messages that might indicate this.
Depending upon how many users you have, 1 GB RAM might be too small. Each connected user requires private memory and you need space for all the shared memory associated with the database, etc. [...]
5290 31 22_DB2 UDB on Linux S/39011_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 10 Jul 2001 09:29:09 -0400478_ISO-8859-1 I have a client who has Linux for S/390 up and running and wants to install DB2 UDB EE on it. He tells me they have a CD for DB2 UDB Version 6. I thought that the DB2 port to Linux for S/390 was done at Version 7.
Can anyone tell me please if UDB V6 will work on Linux for S/390 (maybe by installing the Unix flavour?), or is it essential to get V7? If V7 is a pre-req, is Linux for S/390 support on the basic V7 CD or do they need to order it specially? [...]
5322 106 15_Re: SQL problem15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 10 Jul 2001 09:44:35 -0400434_iso-8859-1 I think the ODBC driver we use is not capturing -420 returned by DB2. I think DB2 should return NULL (not -420) when it cannot convert a value to integer.
Thanks..Sibi
-----Original Message----- From: Hamar, Bela [mailto:Bela.Hamar@VARETIS.COM] Sent: Tuesday, July 10, 2001 05:15 AM To: DB2-L@RYCI.COM Subject: Re: SQL problem
Hi Philip,
just some thoughts to your mail ... [...]
5429 54 26_Re: DB2 UDB on Linux S/39012_Moulder, Tom19_Tom_Moulder@BMC.COM31_Tue, 10 Jul 2001 08:50:29 -0500560_iso-8859-1 Here is the IBM link for UDB on Linux on zSeries. There is a download link there. The file is not that large. The install process will probably take one day, depending upon how many people have to be involved for answers. It might be profitable to take one day to go through this process and take all the defaults just so you can look at the finished product and see where the install process puts everything based on your responses. Then you can make decisions about whether to isolate UDB directories or have them integrated with the rest of [...]
5484 38 18_Directory Reclaims11_Ruth Sutlic24_ruth.sutlic@DILLARDS.COM31_Tue, 10 Jul 2001 08:31:25 -0500453_- Morning Listers, Need help understanding what "directory reclaims" are? I am in a db2 v5 4 member datasharing environment on OS/390 2.10. I came across a REXX that reports on how well your group buffer pools are doing. (Am new to data sharing and relatively new to DB2.) One of the items from the report talk about directory reclaims. Can someone tell me where I can find out more information on what they are and how they relate to performance? [...]
5523 16 47_Re: Java Stored Procedure Authorization Problem12_David Harvey17_dmh@ONETEL.NET.UK31_Tue, 10 Jul 2001 08:46:50 -0500539_- Tony,
Given that "SET CURRENT SQLID" is (sensibly) forbidden, what was the resolution to the authorization issue. i.e. How to restrict access to a specific Java object to just those people who should see its results. Also, what version of Websphere and DB2 is applicable to your scenario.
================================================ 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.
5540 23 6_rebind15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 10 Jul 2001 09:22:39 -0500566_us-ascii Hi all,
REBIND PACKAGE(colid.package_id.(*)) DEGREE(ANY) EXPLAIN (YES)
rebinds all the packages of all qualifiers and owners of same colid.
But I want to rebind a package of particular qualifier and owner for same colid.
Any help on this will certainly appreciated.
Regards Nayeem
================================================ 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.
5564 24 22_Re: Directory Reclaims10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 10 Jul 2001 16:33:43 +0200399_us-ascii Hi Ruth,
It's related to directory entries in the CF structure to specify the location and status of a page in a ds group, 1 directory entry for each page and it's correlated with the number of data pages. Reclaims cause page invalidation and reads of clean pages from DASD.
I've some foils dealing with reclaims and ds tunign. Contact me offline if you need this foilz. [...]
5589 33 52_Length of columns in DB2 OS/390 -Version 7, 8 , 9 ??18_Blumer Hans-Ulrich32_Hans-Ulrich.Blumer@WINTERTHUR.CH31_Tue, 10 Jul 2001 16:38:27 +0200585_iso-8859-1 Hi
The possible length of columns in DB2 UDB for OS/390 V6 is CHAR(18). How will it be for the next versions? Will it stay with CHAR(18) or will it grow?
Kind regards Hans
---------------------------------------------- Hans-Ulrich Blumer Informatik Schweiz Software Entwickler-Support Mailto:Hansueli.Blumer@winterthur.ch Tel +41 52 26124 16 Fax +41 52 261 83 70 ---------------------------------------------- Winterthur Versicherungen Konradstrasse 14 CH-8401 Winterthur http://www.winterthur.com/ch ---------------------------------------------- [...]
5623 63 29_Potentially inconsistent data12_Fertaki Gina20_GFertaki@EUROBANK.GR31_Tue, 10 Jul 2001 17:34:06 +0300599_iso-8859-7 Hello to everyone, I was wondering if you can help me with the follownig problem:
We are occasionally experiencing in Production the following message for the index of a specific table:
DSNI013I + DSNIIDIS POTENTIALLY INCONSISTENT DATA REASON 00C90206 ERQUAL 5002 TYPE 00000302 NAME EBBMCPMC.EBPMCFAE.X'D13EBC' CONNECTION-ID=BATCH CORRELATION-ID=MFJP1150 LUW-ID=*
The table is a partitioned table with 16 partitions and the above mentioned index is a non partitioning index. Looking at the DB2 messages and codes manual the explanation for this reason code is : [...]
5687 15 11_Parallelism12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Tue, 10 Jul 2001 10:51:36 -0400439_us-ascii Hi All. Has anyone changed or used the setting &sprmpth setc '120' within SDSNMACS(DSN6SPRC) that is defaulted to 120 by PTF UQ52960? Any ideas or input or experiences with this? TIA, Jeff
================================================ 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.
5703 103 33_Re: Potentially inconsistent data11_Bikash Paul19_bikash_db@YAHOO.COM31_Tue, 10 Jul 2001 07:53:02 -0700600_us-ascii Hi, As far as i know , this can happen only when a tablespace is recovered to a point either using TOCOPY option or using DSN1COPY but index is not subsequently built. Index will have still old data and pointers to the data will be invalid.
Thanks and Regards, Bikash
--- Fertaki Gina wrote: > Hello to everyone, > I was wondering if you can help me with the follownig > problem: > > We are occasionally experiencing in Production the > following > message for the index of a specific table: > > DSNI013I + DSNIIDIS POTENTIALLY INCONSISTENT [...]
5807 120 33_Re: Potentially inconsistent data0_18_mebert@AMADEUS.NET31_Tue, 10 Jul 2001 16:55:27 +0200337_us-ascii Hi Gina,
off the hat I would think the most likely probability is using DSN1COPY on the TS partition and rebuilding the partitioning index afterwards, but not the NPI. Or, a LOAD RESUME that was terminated (or abended) before the BUILD phase and then was rerun without doing a RECOVER TS first. Something like that. [...]
5928 52 10_Re: rebind11_Bikash Paul19_bikash_db@YAHOO.COM31_Tue, 10 Jul 2001 07:57:55 -0700674_us-ascii Hi, It looks like that it cant not be done. However write to a SQL to generate the REBIND statement and then execute it.
SELECT 'REBIND PACKAGE('||colid||'.'||package_id||'.(*)) DEGREE(ANY) EXPLAIN (YES)' FROM SYSIBM.SYSPACKAGES WHERE OWNER = 'XXXXX' AND COLLID = 'VVVVVVV' ;
Thanks and Regards, Bikash
--- Mohammed Nayeem wrote: > Hi all, > > REBIND PACKAGE(colid.package_id.(*)) DEGREE(ANY) EXPLAIN (YES) > > rebinds all the packages of all qualifiers and owners of same > colid. > > But I want to rebind a package of particular qualifier and owner > for same colid. > > Any help on this will [...]
5981 23 14_This is a test14_David R Slocum22_drslocum@CMSENERGY.COM31_Tue, 10 Jul 2001 11:01:19 -040080_us-ascii Sorry, this is just a test to see if a co-worker is receiving his DB2-L
6005 70 22_Re: Directory Reclaims12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Tue, 10 Jul 2001 10:02:03 -0500600_iso-8859-1 The place to read about this is in the Data Sharing Planning and Administration Manual. I have a version 6 manual instead of version 5, so these page numbers may be off. However, Chapter 7 of that manual concerns performance issues, one of which is tuning group buffer pools. In the Version 6 manual, page 251 contains a major heading entitled "Determining the correct size and ratio". That section describes the relationship of data pages to directory entries in the group buffer pool. This ratio is important, because you can run out of directory entries and go through the reclaim [...]
6076 60 56_Re: Length of columns in DB2 OS/390 -Version 7, 8 , 9 ??14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Tue, 10 Jul 2001 10:06:49 -0500577_iso-8859-1 V7 OS/390 they stay the same. In IBM trends and directions presentations, they talk about them changing in a near future release.
Regards, Richard +-----+-----+-----+-----+-----+ Richard_Yevich@YLAssoc.com YL&A - http://www.YLAssoc.com DB2 and Sysplex Gold Consultant Certified DB2 DBA for OS/390, z/OS
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Blumer Hans-Ulrich Sent: Tuesday, July 10, 2001 9:38 AM To: DB2-L@RYCI.COM Subject: Length of columns in DB2 OS/390 -Version 7, 8 , 9 ?? [...]
6137 60 38_Re: mysterious optimizer - 3rd attempt23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Tue, 10 Jul 2001 11:08:33 -0400786_ISO-8859-1 Greetings !!!
Following query changes access path when the number of columns selected is changed (as shown below). The tables and where clause remains the same. Can anyone explain why ?
SELECT DISTINCT SUBSTR(T.QUAL_TABLE_NAME,1,27) AS QUALTABLE T.VERSION AS TVER SUBSTR(P.PGM_NAME,1,8) AS PROGRAM P.VERSION AS PVER P.ENT_ID AS ENTID FROM DBXDB2.DBX_DB2_TABLES T, DBXIMS.DBX_IMS_PROGRAM P, DBXREL30.DBX_XREF X1, DBXREL30.DBX_XREF X2, DBXREL30.DBX_XREF X3, DBXREL30.DBX_XREF X4 WHERE T.QUAL_TABLE_NAME = 'ACUP.ACACCTTB' AND T.ENT_ID =X1.ENT_ID AND X1.ENT_TYPE = 126 AND P.ENT_ID =X2.ENT_ID AND X2.ENT_TYPE = 151 AND X4.SOURCE_ID = T.ENT_ID AND X4.ENT_TYPE = 102 AND X3.SOURCE_ID = P.ENT_ID AND X3.ENT_TYPE = 285 AND X3.TARGET_ID = X4.ENT_ID [...]
6198 34 15_Re: Parallelism50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Tue, 10 Jul 2001 11:13:30 -0400552_iso-8859-1 Parallelism threshold value :: I used the default of 0, But in my notes I have PQ25135 associated with it. V5 of DB2. You might want to review it.
Bob Knight
-----Original Message----- From: Jeff Frazier [mailto:Jeffrey_Frazier@WENDYS.COM] Sent: Tuesday, July 10, 2001 10:52 AM To: DB2-L@RYCI.COM Subject: Parallelism
Hi All. Has anyone changed or used the setting &sprmpth setc '120' within SDSNMACS(DSN6SPRC) that is defaulted to 120 by PTF UQ52960? Any ideas or input or experiences with this? TIA, Jeff [...]
6233 96 36_Re: Page Problem, NEED HELP A.S.A.P.11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Tue, 10 Jul 2001 22:20:01 +0700316_ISO-8859-1 Hi Scott, Thanks for your Reply. The other problem is that I don't know how to check the diagnostic logs. And how can I measure whether the Bufferpools that we've created are enough? Are there any kind of formula to do this?
ANd how can I reserve the space for each user connection to the DB? [...]
6330 124 19_Antwort: Re: rebind15_Durga Vamsidhar22_durga.vamsidhar@DB.COM31_Tue, 10 Jul 2001 17:10:14 +0100767_iso-8859-1 Dear listers,
Can you please help me in solving the followin problem. I am getting an error while loading the DB2 Table using the LOAD utility.
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = EDIFACT.EZ1VAS DSNU050I DSNUGUTC - LOAD DATA RESUME NO REPLACE DSNU650I ?DB31 DSNURWI - INTO TABLE DB.EZ1VAT WHEN(1:6)='EZ1VAT' DSNU650I ?DB31 DSNURWI - (SC_PREFIX POSITION(10:11) CHAR(2) NULLIF(10)='?', DSNU650I ?DB31 DSNURWI - PREFIX_DESCRIPTION POSITION(31:50) CHAR(50), DSNU650I ?DB31 DSNURWI - DE_1131 POSITION(15:17) DECIMAL EXTERNAL, DSNU650I ?DB31 DSNURWI - DE_3055 POSITION(21:23) CHAR(3), DSNU650I ?DB31 DSNURWI - ISO_CC POSITION(27:28) CHAR(2)) DSNU350I ?DB31 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE DSNU335I ?DB31 [...]
6455 46 10_Re: rebind9_Rob Crane22_racrane@CONCENTRIC.NET31_Tue, 10 Jul 2001 09:21:07 -0600517_us-ascii Give this a try....
SELECT 'REBIND PACKAGE(' || RTRIM(COLLID) || '.' || RTRIM(NAME) || '.(*)) DEGREE(ANY)' || ' EXPLAIN(YES)' FROM SYSIBM.SYSPACKAGE WHERE COLLID = 'your_coll' and name = 'your pkg' and owner = 'your_owner' and qualifier = 'your_qual';
You can set up some JCL to have this write out to a flat file (spufi in batch), then in the second step read the flat file into a batch job to do the rebind this will build. Just change the where clause to get a different result, etc... [...]
6502 156 33_Re: Potentially inconsistent data12_Fertaki Gina20_GFertaki@EUROBANK.GR31_Tue, 10 Jul 2001 18:18:46 +0300529_iso-8859-7 Hello to everyone who replied to me,
actually this a Production table against which no DSN1COPY or LOAD utility has run. It is updated thru application programs. This problem is usually observed on Mondays and every Sunday we have a scheduled REORG job per partition of this tablespace, if that can cause any potential problem. The REORG job ran normally this Saturday and then on Monday we had this message during a batch program run. Again we don't phase this problem every Monday but from time to time. [...]
6659 60 20_Load utility problem15_Durga Vamsidhar22_durga.vamsidhar@DB.COM31_Tue, 10 Jul 2001 17:13:31 +0100767_iso-8859-1 Dear listers,
Can you please help me in solving the followin problem. I am getting an error while loading the DB2 Table using the LOAD utility.
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = EDIFACT.EZ1VAS DSNU050I DSNUGUTC - LOAD DATA RESUME NO REPLACE DSNU650I ?DB31 DSNURWI - INTO TABLE DB.EZ1VAT WHEN(1:6)='EZ1VAT' DSNU650I ?DB31 DSNURWI - (SC_PREFIX POSITION(10:11) CHAR(2) NULLIF(10)='?', DSNU650I ?DB31 DSNURWI - PREFIX_DESCRIPTION POSITION(31:50) CHAR(50), DSNU650I ?DB31 DSNURWI - DE_1131 POSITION(15:17) DECIMAL EXTERNAL, DSNU650I ?DB31 DSNURWI - DE_3055 POSITION(21:23) CHAR(3), DSNU650I ?DB31 DSNURWI - ISO_CC POSITION(27:28) CHAR(2)) DSNU350I ?DB31 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE DSNU335I ?DB31 [...]
6720 63 56_Re: Length of columns in DB2 OS/390 -Version 7, 8 , 9 ??12_Mark Granger22_the_grange@MBOX.COM.AU31_Tue, 10 Jul 2001 10:26:43 -0500417_us-ascii Hi Hans, V7 still has the char(18) limitation (going by SYSIBM.SYSCOLUMNS definition). The DB2 Gold meeting is in September, maybe they will announce something there, or accept the request to allow column names > char(18).
Mark Granger Independent Systems Integrators P/L Senior Technical Specialist - 2BDB2 Email: mgranger@isi.com.au Phone: +61 0416-012-262 (Australia) OR +1 617-306-7794 (USA) [...]
6784 87 33_Re: Potentially inconsistent data14_Hickman, Mindy29_Mindy.Hickman@DOA.STATE.WI.US31_Tue, 10 Jul 2001 10:33:02 -0500409_ISO-8859-7 We were experiencing the same problem with a web application. Do you have RRS on your system? We applied some DB2 maintenance and we haven't experienced the problem since the maintenance was applied. We're DB2 6.1.
-----Original Message----- From: Fertaki Gina [mailto:GFertaki@EUROBANK.GR] Sent: Tuesday, July 10, 2001 9:34 AM To: DB2-L@RYCI.COM Subject: Potentially inconsistent data [...]
6872 95 22_Re: Directory Reclaims16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 10 Jul 2001 16:37:33 +0100360_us-ascii Ruth,
Directory Reclaims are closely connected with tuning in a Data Sharing environment, it is important when you're trying to determine the size of your Group Buffer Pools, to avoid running out of Directory Entries (basically if you have the incorrect ratio of directory claims / directory entries you will incur in directory reclaims). [...]
6968 77 56_Re: Length of columns in DB2 OS/390 -Version 7, 8 , 9 ??16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 10 Jul 2001 16:39:37 +0100383_us-ascii Hans,
the column length limits have not been altered for v 7.1 on S/390, there are rumours of chan ging them in the future, but nothing announced as yet.
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.
Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com [...]
7046 61 15_Re: Parallelism12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Tue, 10 Jul 2001 11:43:18 -0400391_us-ascii I did review that and PQ25135 set it to 0 as default. Now on Version 6 PTF(UQ52960) is changing default to 120. We are applying maint to DB2 Version 6 and were wondering what a good number is and has anyone else adjusted it on v6.
"Knight, Robert A. (Cameron of Pittsburgh at Alcoa)" @RYCI.COM> on 07/10/2001 11:13:30 AM [...]
7108 171 23_Re: Antwort: Re: rebind12_McKown, John22_JMckown@HEALTHAXIS.COM31_Tue, 10 Jul 2001 10:42:57 -0500291_iso-8859-1 I'm not 100% sure, but I think that this message indicates that the record being loaded is too small. The LOAD command says that it starts in column 31 for 50 characters. That's column 31 through 80. If the record is smaller than 80 bytes, then I think you get this message. [...]
7280 216 33_Re: Potentially inconsistent data11_Bikash Paul19_bikash_db@YAHOO.COM31_Tue, 10 Jul 2001 08:44:53 -0700616_us-ascii Hi, Does REORG job fails.. Reorg has phases like UNLOAD, LOAD, BUILD.. During the BUILD phase, indexes are rebuilt.. If BUILD phase has failed and pagesets have been started with ACCESS(FORCE) option, this problem might occur.
Regards, Bikash --- Fertaki Gina wrote: > Hello to everyone who replied to me, > > actually this a Production table against which no DSN1COPY > or LOAD > utility has run. It is updated thru application > programs. This problem is usually observed on Mondays and > every > Sunday we have a scheduled REORG job per > partition of this tablespace, [...]
7497 142 23_Re: Antwort: Re: rebind11_Bikash Paul19_bikash_db@YAHOO.COM31_Tue, 10 Jul 2001 08:47:15 -0700617_us-ascii Hi, The PREFIX_DESCRIPTION field has a attribute CHAR(50) but from the POSITION(31:50), It is only 20 bytes.. So there is a mismatch.. If you correct it, should run fine
Regards, Bikash --- Durga Vamsidhar wrote: > Dear listers, > > Can you please help me in solving the followin problem. > I am getting an error while loading the DB2 Table using the LOAD > utility. > > DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = > EDIFACT.EZ1VAS > DSNU050I DSNUGUTC - LOAD DATA RESUME NO REPLACE > DSNU650I ?DB31 DSNURWI - INTO TABLE DB.EZ1VAT WHEN(1:6)='EZ1VAT' > DSNU650I [...]
7640 232 24_Re: Load utility problem14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 10 Jul 2001 16:45:18 +0100415_iso-8859-1 Firstly,
The format of the field specification is "field_name(start:end)". You appear to have "field_name(start:length)" so I would change that straight away!
(It is to be telling you that you have defined field PREFIX_DESCRIPTION as being from position 31 to position 50. That's only 20 bytes, so when you then say it is 50 bytes long, you have exceeded the field you have described) [...]
7873 184 33_Re: Potentially inconsistent data16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 10 Jul 2001 11:47:36 -0400708_iso-8859-7 Is the REORG IBM or other?
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Fertaki Gina [mailto:GFertaki@EUROBANK.GR] Sent: Tuesday, July 10, 2001 11:19 AM To: DB2-L@RYCI.COM Subject: Re: Potentially inconsistent data
Hello to everyone who replied to me,
actually this a Production table against which no DSN1COPY or LOAD utility has run. It is updated thru application programs. This problem is usually observed on Mondays and every Sunday we have a scheduled REORG job per partition of this tablespace, if that can cause any potential problem. The REORG job ran normally this Saturday and then on Monday we [...]
8058 65 40_Re: Length of columns in DB2 OS/390 -Ver64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Tue, 10 Jul 2001 10:55:04 -0600402_ISO-8859-1 At IDUG 2001, IBM openly indicated (without commitments, of course) that in DB2 V8 the length of short identifiers (8) and long identifiers (18) will increase to 128 bytes (varchar).
Todd Burch
-----Original Message----- From: Hans-Ulrich.Blumer@WINTERTHUR. Sent: Tuesday, July 10, 2001 9:49 AM To: DB2-L@RYCI.COM Subject: Length of columns in DB2 OS/390 -Version [...]
8124 90 24_Re: Load utility problem14_Riedel, Marcia26_MRiedel@TUCSONELECTRIC.COM31_Tue, 10 Jul 2001 08:51:19 -0700440_iso-8859-1 Durga:
The load description, PREFIX_DESCRIPTION POSITION(31:50) CHAR(50), is asking for 50 character bytes between input record positions 31 and 50. There are not 50 character bytes between byte 31 and byte 50 of the input record.
Marcia
-----Original Message----- From: Durga Vamsidhar [SMTP:durga.vamsidhar@DB.COM] Sent: Tuesday, July 10, 2001 9:14 AM To: DB2-L@RYCI.COM Subject: Load utility problem [...]
8215 88 24_Re: Load utility problem64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Tue, 10 Jul 2001 10:56:25 -0600544_ISO-8859-1 This sounds like the field "PREFIX_DESCRIPTION" is a VARCHAR field and the length field is invalid.
Todd Burch
-----Original Message----- From: durga.vamsidhar@DB.COM Sent: Tuesday, July 10, 2001 10:43 AM To: DB2-L@RYCI.COM Subject: Load utility problem
-------------------------------------------------------------------------- -- Dear listers,
Can you please help me in solving the followin problem. I am getting an error while loading the DB2 Table using the LOAD utility. [...]
8304 13 24_Re: Load utility problem9_Jim Ruddy18_jaruddy@US.IBM.COM31_Tue, 10 Jul 2001 11:02:35 -0500346_- This usually means your input record is too short.
Jim Ruddy DB2 fo z/OS and OS/390 Development
================================================ 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.
8318 174 33_Antwort: Re: Load utility problem15_Durga Vamsidhar22_durga.vamsidhar@DB.COM31_Tue, 10 Jul 2001 18:09:07 +0100365_iso-8859-1 Dear listers,
I am sorry to say that I have given some wrong details in my earlier messages. It was actually given as 31:80 not 31:50. And also it is not a VARCHAR field, just an ordinary character field.
Can you please help me in solving the followin problem. I am getting an error while loading the DB2 Table using the LOAD utility. [...]
8493 44 28_New Zealand User Group HELP!14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Tue, 10 Jul 2001 11:36:43 -0500166_iso-8859-1 Anyone know who is in charge of New Zealand DB2 User Group? It was Denis Martin but he cannot be found. Is there still a User Group in New Zealand?
8538 72 33_Antwort: Re: Load utility problem12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 10 Jul 2001 12:44:20 -0400423_US-ASCII Just off the top of my head. Did you check your input file. I have seen this problem with a sort step is added and the output dataset did not have the correct LRECL.
Cheers,
Troy Coleman Coleman Consulting, Inc.
IBM Certified Solutions Expert DB2 V7.1 Database Administration for OS/390 DB2 UDB V5 Database Administration IBM Certified Advanced Technical Expert DB2 -DRDA [...]
8611 141 26_Re: DB2 UDB on Linux S/39014_Philip Gunning24_Philip.Gunning@QUEST.COM31_Tue, 10 Jul 2001 10:17:51 -0700775_iso-8859-1 Mike, Linux support was announced in announcement 200-322 and V7.1 is required. I'm not sure if it is on different media. HTH Phil
http://www2.ibmlink.ibm.com/cgi-bin/master?request=announcements&parms=S&xh= RV4azNpRVZUFre1USenGnN9332&type=ANNO&smonth=06&sday=10&syear=2000&emonth=06& eday=10&eyear=2001&searchwords=DB2+&content=TITLE&n%240=&n%241=&n%242=&n%243 =&n%244=&n%245=&n%246=&n%247=&n%248=&n%249=
-----Original Message----- From: Mike Turner To: DB2-L@RYCI.COM Sent: 7/10/01 6:29 AM Subject: DB2 UDB on Linux S/390
I have a client who has Linux for S/390 up and running and wants to install DB2 UDB EE on it. He tells me they have a CD for DB2 UDB Version 6. I thought that the DB2 port to Linux for S/390 was done at Version 7. [...]
8753 26 34_V5 to V6 distributed (both OS/390)27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Tue, 10 Jul 2001 12:39:13 -0500477_iso-8859-1 We have an application on a V6 system that needs to access some tables on a V5 system (select only). The V5 system is rather far back on maintenance (9911) and won't be upgraded for a while yet. I know there was some V5 maintenance for distributed processing that could result in DB2 abending if it wasn't on all systems. Does anyone know if there's an informational apar that would tell me what PTFs need to be on the V5 system so they can talk to each other? [...]
8780 178 37_Re: Antwort: Re: Load utility problem13_Bright, Randy20_Randy_Bright@BMC.COM31_Tue, 10 Jul 2001 13:00:55 -0500316_iso-8859-1 This usually means the input dataset (SYSREC) LRECL is not as long as you have indicated by your field specifications. In this particular case, PREFIX_DESCRIPTION is defined as being from column 31 through 80 of the input file. Probably, the input dataset has an LRECL that is shorter than 80 bytes. [...]
8959 138 37_Re: Antwort: Re: Load utility problem13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 10 Jul 2001 13:48:56 -0500552_iso-8859-1 Is it possible that the input file has a variable length record? It does need to be fixed length.
Helen
Durga Vamsidhar wrote:
> Dear listers, > > I am sorry to say that I have given some wrong details in my earlier messages. It was actually given as 31:80 not 31:50. And also it is not a VARCHAR field, just an ordinary character field. > > Can you please help me in solving the followin problem. > I am getting an error while loading the DB2 Table using the LOAD utility. > > DSNU000I DSNUGUTC - OUTPUT START FOR [...]
9098 47 26_Re: DB2 UDB on Linux S/39011_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 10 Jul 2001 15:25:36 -0400615_ISO-8859-1 Tom
Thanks, I had already found the link. I was deterred by the prospect of a 15 hour download over a 56K dial-up link. Still better that trying it at 9600, which is the best I can get from the client's location!
Regards Mike Turner Email: michael_turner@compuserve.com Web: www.michael-turner.ltd.uk
Message text written by DB2 Data Base Discussion List >Here is the IBM link for UDB on Linux on zSeries. There is a download link there. The file is not that large. The install process will probably take one day, depending upon how many people have to be involved for answers. [...]
9146 177 24_Re: Load utility problem11_Ron Johnson25_rjohnson@DATA-TRONICS.COM31_Tue, 10 Jul 2001 14:58:42 -0500380_iso-8859-1 It may be a long shot but how about this scenario... (I've had it happen to me): If your load file is defined as a variable-length record file and you use ISPF to edit it after its creation, ISPF will set the end of record at the last non-blank character, thus causing the record to be less than 80 characters. Attempting to load it would then cause this message. [...]
9324 63 26_Re: DB2 UDB on Linux S/39012_Moulder, Tom19_Tom_Moulder@BMC.COM31_Tue, 10 Jul 2001 15:17:04 -0500325_iso-8859-1 I'm sorry it will take that long. I guess my world view was somewhat tinted by these rose colored glasses. My download was through a LAN connection to the internet at 100mbps. Perhaps someone from IBM will offer a better way of getting the file since it would take so long to download -- are you there Roger? [...]
9388 69 49_Press Release of Disaster Recovery Automated Tool20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Tue, 10 Jul 2001 17:05:46 EDT659_US-ASCII DB2 Disaster Recovery Automation Tool Enhancement Press Release
Recovery Knowledge is please to announce GENDB2 Release 2.4 with enhancements to include IDCAMS Automation Feature. This feature automates the creation of all DB2 VSAM datasets for DB2 Cat/Dir Tablespaces, User Application Tablespaces, Active Logs, and BSDS. Space allocation for these DB2 resources is included. This feature saves time and resources at the Local site by eliminating the need of Disk Pack Dump of these resources. It will also save time and resources at the DR site by eliminating the need of Disk Pack Restore. The Delete/Define of these DB2 resources are [...]
9458 164 37_Re: Antwort: Re: Load utility problem13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 10 Jul 2001 13:48:56 -0500552_iso-8859-1 Is it possible that the input file has a variable length record? It does need to be fixed length.
Helen
Durga Vamsidhar wrote:
> Dear listers, > > I am sorry to say that I have given some wrong details in my earlier messages. It was actually given as 31:80 not 31:50. And also it is not a VARCHAR field, just an ordinary character field. > > Can you please help me in solving the followin problem. > I am getting an error while loading the DB2 Table using the LOAD utility. > > DSNU000I DSNUGUTC - OUTPUT START FOR [...]
9623 22 18_fyi usa developers16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Tue, 10 Jul 2001 21:50:34 -0400654_us-ascii On August 13-16, thousands of developers are coming to Solutions, The IBM Technical Developer Conference in San Francisco. They're coming to find answers. Answers behind the issues surrounding the future of open standards. Answers to building a flexible e-infrastructure.
Register now through July 13 and you can attend for just USD $995 - a $200 savings off regular admission. Just enter the code "EB1" when you register. You can also receive from $400-$600 off with group discounts and one to two day passes, just visit our web site http://destinationsite.com/c?c=333903.46522.0.8836.0 or call 1-800-628-5219 for more information. [...]
9646 23 31_FYI DB2 UDB Performance Monitor16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Tue, 10 Jul 2001 21:59:45 -0400473_us-ascii Precise Software today shipped performance management software for IBM's DB2 UDB database.
Precise/Indepth for DB2 UDB lets database managers monitor and analyze the performance of DB2 applications as well as diagnose the causes of bottlenecks, Precise said.
The new product supports DB2 UDB running on Solaris, HP-UX and IBM AIX, with NT support planned in the future, Precise said. Pricing starts at $10,000 and depends on server performance. [...]
9670 93 38_Re: mysterious optimizer - 3rd attempt14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 10 Jul 2001 21:00:15 -0500647_- Sanjay,
As ever, the ways of the optimizer are, indeed, mysterious. However, one possible explanation is that the optimizer might be looking at the cost of the DISTINCT sort.
Looking at the query and speculating at its meaning, you are possibly thinking that the predicate on T.QUAL_TABLE_NAME = 'ACUP.ACACCTTB' should be providing a (reasonably) low filter factor - biasing the optimizer towards the T-->X1-->X4-->X3-->P-->X2 path. However, it might be thinking that, if there is a P(ENT_ID, ???) index, it can get reasonable filtering using it as well as discarding many, many duplicates (so they will not need to be sorted [...]
9764 131 15_Re: SQL problem14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 10 Jul 2001 21:24:18 -0500594_ISO-8859-1 Philip
What ODBC driver are you using? The symptoms you are getting appear to be that the ODBC driver is retrieving raw table data from DB2 and attempting to do SQL analysis itself. In your second example: > select sum (case when int(col1) >= 0 then 1 else 0 end) as total There are two possible ways to handle int(): - return sqlcode=-420, which is what I would expect - treat it as NULL, which is at least 'sort-of-reasonable'. However, in discussing the case expression, the SQL Ref Manual states "[n]ote that when a case evaluates to unknown (because of [...]
9896 103 25_Re: Java Stored Procedure8_ritu zee22_ritu_98_2000@YAHOO.COM31_Tue, 10 Jul 2001 20:25:58 -0700418_us-ascii Hi James,
Could you be more specific what you mean by 'someone'? This code is in the IBM manual. So, is 'someone' IBM? So, is this an error in the manual?
I did look at outParameter method in the manual but as all the methods (outLanguage, outParameter,inParameters,inoutParam,resultSet, twoResultSets, allDataTypes ) are specified in the same place in the manual, i mentioned all of them. [...]
10000 17 25_DB2 for OS/390 V7 GA date15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 11 Jul 2001 13:54:58 +1000352_- Quick question, colleagues. When did DB2 for OS/390 and z/OS V7 go GA?
Cheers,
Raymond
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10018 45 29_Re: DB2 for OS/390 V7 GA date10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 11 Jul 2001 14:31:16 +1000731_us-ascii 30 March 2001.
Please refer to
http://www-4.ibm.com/software/data/db2/os390/availsum.html
if u need further info.
Cheers, Kals
-----Original Message----- From: Bell, Raymond W [SMTP:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Wednesday, July 11, 2001 1:55 PM To: DB2-L@RYCI.COM Subject: DB2 for OS/390 V7 GA date
Quick question, colleagues. When did DB2 for OS/390 and z/OS V7 go GA?
Cheers,
Raymond
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
10064 57 29_Re: DB2 for OS/390 V7 GA date15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 11 Jul 2001 15:01:33 +1000631_- Thanks for that, Kals.
> -----Original Message----- > From: teldb2kals [SMTP:teldb2kals@TELSTRA.COM] > Sent: Wednesday, 11 July 2001 2:31 pm > To: DB2-L@RYCI.COM > Subject: Re: DB2 for OS/390 V7 GA date > > 30 March 2001. > > Please refer to > > http://www-4.ibm.com/software/data/db2/os390/availsum.html > > if u need further info. > > > Cheers, > Kals > > > -----Original Message----- > From: Bell, Raymond W [SMTP:Raymond.W.Bell@TEAM.TELSTRA.COM] > Sent: Wednesday, July 11, 2001 1:55 PM > To: DB2-L@RYCI.COM > Subject: DB2 for OS/390 V7 GA date > > Quick question, colleagues. When did DB2 for OS/390 and z/OS V7 [...]
10122 37 43_DB2 Online Reorganization - Help Needed !!!17_Demetris Kasheris19_DKasheris@LAIKI.COM31_Wed, 11 Jul 2001 08:22:34 +0300426_us-ascii Hi,
I am trying to implement online reorganizations at my installation but I am facing a few problems as far as SMS allocations. Our installation uses OS390 2.9 / DB2 OS390 6.0 and SMS 1.5
I have asked the SMS guys and they have created a new pool of temporary volumes in order for my mirror datasets to be placed there during the online reorganization. However, their seems to be a problem there. [...]
10160 60 47_Re: DB2 Online Reorganization - Help Needed !!!15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 11 Jul 2001 15:53:12 +1000359_- It could be because your 'temporary' tablespace/index datasets become the real ones. DB2 reorgs into the S0001 (I can't remember the actual names so I could be wrong here), deletes the old cluster name and renames the S* to the I* dataset. If the other pool is chosen because of the temporary name I guess it's staying put when the dataset is renamed. [...]
10221 43 56_AW: Length of columns in DB2 OS/390 -Version 7, 8 , 9 ??12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 11 Jul 2001 08:28:22 +0200441_iso-8859-1 Hans-Ulrich,
I have been at a meeting at the IBM laboratory Boeblingen (Germany) in May 2001. And at this meeting an IBM'er was asked exactly what you are asking.
The answer: DB2 for OS/390 and z/OS Version 8 or higher MAY deliver some good things, e.g. column names with a 128 character length, online-schema-change (ALTER COLUMN, DROP COLUMN etc.) and a thing called Object Restore (somewhat like an UNDROP). [...]
10265 31 10_Db2 import13_Abi Manoahran23_abi@PROTEOMESYSTEMS.COM31_Wed, 11 Jul 2001 01:02:08 -0500328_- Hi, I am trying to load a ascii flat file with comma delimiter into a Db2 database (Ver 7.1) in Linux server. The problem is some of the fields are text which contains comma as text. So the DB2 is not accepting.
Here is a sample file: (file name: /tmp/A.txt)
123,"ABC","xyz,abc.c,d" 456,"DEF","ij,klbc.c,d" [...]
10297 30 47_Re: DB2 Online Reorganization - Help Needed !!!10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 11 Jul 2001 08:35:06 +0200533_us-ascii I'm almost sure that your SMS guys define an ACS routine entry filtering the mirror datasets, ie something like this:
YOUR_VCAT.DSNDB*.dbname.tsname.I*.A00x >>>> for normal tablespaces
YOUR_VCAT.DSNDB*.dbname.tsname.S*.A00x >>>> for mirror tablespaces
Of course when mirror tablespace is renamed (switch phase) it remains in the volume were it was defined. If you copy
that tablespace using DFSMSdss it'll return to the original pool. This is not valid for a 'normal' reorg (SHRLEVEL NONE). [...]
10328 61 20_Locks - Open - Fetch18_Blumer Hans-Ulrich32_Hans-Ulrich.Blumer@WINTERTHUR.CH31_Wed, 11 Jul 2001 09:54:01 +0200457_iso-8859-1 Hi As there are a lot of parameters and conditions concerning locking, it is difficult for me to find out at wich time which lock starts and how long it stays. I made a little example and I'd like to ask you when the locks begin. Do they start during open or later during the first fetch. We use Cursor Stability, Current Data(YES) and page locking. We might suppose that there are three rows to fetch. It is an IMS-transaction (no Commit). [...]
10390 25 38_CPU/IO time units help needed urgently8_duam lee16_duam_lee@USA.NET29_Wed, 11 Jul 2001 02:14:06 MDT424_US-ASCII Hi All the units in which CPU time and I/o time are measured are like this xx:yy:zz.aaa. Could you please clear my doubts regarding the units of this. I mean the xx is in hour or minute and yy is in minute or seconds, zz in milliseconds or seconds and aaa part in terms of units of seconds . I m waiting for your valuable inputs . Any site for this gaining knowledge is highly welcome. Waiting for your reply. [...]
10416 43 24_Re: Locks - Open - Fetch16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 11 Jul 2001 13:58:01 +0530527_- Hans,
You have not mentioned ACQUIRE/RELEASE parameter so i would presume ACQUIRE(USE). In this case, please look at the lock? below for my reply. Let's see what others have to say.
> Declare THISEMP Cursor for > select... > for update of <....> > > Open THISEMP Lock? - LOCK EVERY PAGE WHICH CONTAINS ROW > WITH "U" LOCK > > Fetch THISEMP into .... Lock? - LOCKED WITH "U" LOCK > > Update table Lock? - LOCK THE SAME WITH "X" LOCK AND > REMOVE "X" AFTER UPDATE > set A= ... > where current of THISEMP > > [...]
10460 74 11_Summary SQL14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 11 Jul 2001 10:21:57 +0100347_iso-8859-1 Hi.
DB2 for OS/390 V5.1
If I've a table, thus:
Company no. Turnover 1 49000 2 48000 3 88000 4 99000 5 77000 ... n 2000000 m 2000001 ...
And I want a results set, thus:
Turnover No. businesses <50K 2 50K to 100K 3 100K to 150K etc. >2000000
Is there an easier way of doing this other than: [...]
10535 208 33_Re: Potentially inconsistent data12_Fertaki Gina20_GFertaki@EUROBANK.GR31_Wed, 11 Jul 2001 12:37:45 +0300397_iso-8859-7 no, The Reorg ends normally as I said in my note and it is IBM REORG.
Best regards, Gina -----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Tuesday, July 10, 2001 6:48 PM To: DB2-L@RYCI.COM Subject: Re: Potentially inconsistent data
Is the REORG IBM or other?
Regards, eric pearson NS ITO Database Support [...]
10744 53 37_Sort Phase in IBM Load Utility DB2 V512_Marcus Green18_mgreen@AAPT.COM.AU31_Wed, 11 Jul 2001 19:43:28 +1000345_US-ASCII Hi,
I'm in the process of preparing for expanding a large 64 partitioned table into a larger 128/256 partitioned table.
As part of this, I've been testing the fastest methods for unloading and loading a partition, and thought that if I did an unload, external sort, and then a load, that would give the best results. [...]
10798 115 15_Re: Summary SQL9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Wed, 11 Jul 2001 10:50:09 +0100559_ISO-8859-1 Hi,
You could create a code table:
Turnover_range low_value high_value less than 50K 0 50000 etc..
Then just join the two tables group by turnover_range... I think it would work.
Jim.
-----Original Message----- From: Davage, Marcus [mailto:Marcus.Davage@LLOYDSTSB.CO.UK] Sent: 11 July 2001 10:22 To: DB2-L@RYCI.COM Subject: Summary SQL
Hi.
DB2 for OS/390 V5.1
If I've a table, thus:
Company no. Turnover 1 49000 2 48000 3 88000 4 99000 5 77000 ... n 2000000 m 2000001 ... [...]
10914 71 13_R: Db2 import20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Wed, 11 Jul 2001 11:52:17 +0200552_iso-8859-1 Hi, I think you have basically 2 options: 1) you can manage to get your ascii flat file with a different column delimiter (eg. !): 123!"ABC"!"xyz,abc.c,d" and then use the command: db2 import from '/tmp/A.txt' of del MODIFIED BY coldel! insert into A By the way is you flat file created by a DB2 Export? If fo you can set the parameter clodel! (or whatever character you like) and use the import with the above syntax. 2) Check that the file is of a fixed lenght, as in your samplefile, so always the same length (24); in this case you [...]
10986 93 6_urgent33_=?iso-8859-9?Q?R.Teoman_KO=C7ER?=22_tkocer@HALKBANK.COM.TR31_Wed, 11 Jul 2001 10:41:54 +0300274_iso-8859-9 Dear list members can anybody tell me how to solve this problem? thanks
DSNL511I * DSNLIENO TCP/IP CONVERSATION FAILED 479 TO LOCATION 10.9.5.215 IPADDR=10.9.5.215 PORT=1253 SOCKET=WRITEV RETURN CODE=140 REASON CODE=745A7242
11080 20 15_Display Command9_Ted Pesta18_tpesta@AMQUEST.COM31_Wed, 11 Jul 2001 06:10:15 -0400321_iso-8859-1 Good Morning,
I'm having a problem using a -DISPLAY command on one of the DB2 systems here. I can enter -DISPLAY DATABASE(XXXXXXX) SPACENAM(*) and I get the response I expect. When I add the LOCKS parameter I hang DB2 and my TSO session. Is there a ZPARM setting I'm missing?
TIA, Ted Pesta [...]
11101 97 21_SQL question (DB2 V6)16_Petteno' Massimo27_Petteno.Massimo@GENERALI.IT31_Wed, 11 Jul 2001 12:24:36 +0200264_- Hi all,
Is it possible using SQL to select a row every "n" number of rows? For example SELECT COL1, COL2 FROM TAB1 gives all the row
COL1 COL2 ------- ------- A 1 B 1 C 2 D 2 E 1 E 3 ...
and I need to pick just one row every 3 rows so: [...]
11199 116 15_Re: Summary SQL0_24_Bruce.Williamson@PSIR.IE31_Wed, 11 Jul 2001 12:11:23 +0100856_iso-8859-1 Howzit Marcus?
Use the case statement.
Cheers Bruce __________________________________________________
Bruce Williamson DB2 Database Administrator
perotsystems information resource(tm)
Computer Centre Cabinteely Dublin 18 Ireland
Bruce.Williamson@psir.ie
******************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately at MailManager@psir.ie and delete this E-mail from your system. Thank you. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted. For this reason, where the communication is by email, the [...]
11316 216 2_DB15_Chris Van Daele33_Chris.Van.Daele@TOYOTA-EUROPE.COM31_Wed, 11 Jul 2001 13:39:00 +02001059_us-ascii V5.1 join
Hi list,
one of my batch programs is running very very slow
the SQL statement looks like
DECLARE CURSOR1 CURSOR FOR SELECT NPSDISHI_VW.DSH_TO_DIS_RT, CHAR(NPSDISHI_VW.DSH_YYYYMM_DAT,ISO), CHAR(NPSDISHI_VW.DSH_DSTPROC_DAT,ISO), CHAR(NPSDISHI_VW.DSH_TMMEPRC_DAT,ISO), NPSDISHL_VW.DHL_PARTNB_PNM, NPSDISHL_VW.DHL_SALES_QTY, NPSDISHL_VW.DHL_ONHAND_QTY, NPSDISHL_VW.DHL_ONORDER_QTY, NPSDISHL_VW.DHL_BCKORDR_QTY, NPSDISHL_VW.DHL_LOCALIS_COD, NPSDISHL_VW.DHL_DEADSTK_FLG, NPSDISHL_VW.DHL_SELLING_FLG, NPSDISTR_VW.DIS_FROM_CUS_RT, NPSDISTR_VW.DIS_DISTRIB_NUM FROM NPSDISHI_VW NPSDISHI_VW, NPSDISHL_VW NPSDISHL_VW, NPSDISTR_VW NPSDISTR_VW WHERE NPSDISHL_VW.DHL_FROM_DSH_RT = NPSDISHI_VW.DSH_TO_DIS_RT AND NPSDISHL_VW.DHL_FROM_DSH_RT1 = NPSDISHI_VW.DSH_YYYYMM_DAT AND NPSDISHI_VW.DSH_TO_DIS_RT = NPSDISTR_VW.DIS_DISTRIB_NUM AND ( NPSDISHI_VW.EXTRACTS_TS BETWEEN :WS-BEGIN-TS AND :WS-END-TS OR NPSDISHL_VW.EXTRACTS_TS BETWEEN :WS-BEGIN-TS AND :WS-END-TS OR NPSDISTR_VW.EXTRACT_TS BETWEEN :WS-BEGIN-TS AND :WS-END-TS ) [...]
11533 28 44_Automatic quiesce of the directory (DSNDB01)13_Tony Hurlston27_tony.hurlston@UK.ZURICH.COM31_Wed, 11 Jul 2001 12:41:40 +0100359_us-ascii Hi List,
"We have recently upgraded our DB2 systems to version 6. Since the upgrade, when we quiesce the catalog & directory tablespaces, DB2 takes an automatic quiesce of the directory (DSNDB01) indexspaces as well. I cannot find this documented anywhere nor can I find a way of disabling it. Can anyone shed some light on this please?" [...]
11562 41 38_Re: V5 to V6 distributed (both OS/390)11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 11 Jul 2001 08:03:01 -0400443_iso-8859-1 Start with the info APAR that is the index to all other DB2 info APARS
====> II12337
Unfortunately, there are many INFO apars that deal with distributed and DDF listed there. Be sure to check the ones with HANG or WAIT in the title.
-----Original Message----- From: Hilton, Tina, BmS - NMI -PM [mailto:Tina.Hilton@BMSUS.COM] Sent: Tuesday, July 10, 2001 1:39 PM Subject: V5 to V6 distributed (both OS/390) [...]
11604 64 6_Re: DB16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 11 Jul 2001 17:49:49 +0530382_- Hi Chris,
It was a bit difficult to see the complete things sent by you but with my understanding i could say that "OR" is the culprit. Can you write 3 sqls for this one which gets executed one after another and each "OR" predicate in the separate one ?
Another thing which i could not look is whether index is available on "EXTRACTS_TS"(for all the 3 tables). [...]
11669 53 48_Re: Automatic quiesce of the directory (DSNDB01)16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 11 Jul 2001 18:01:54 +0530366_- Hi Tony,
Just a quick guess based on the reason of indexes getting quiesed automatically. It might be possible that the indexes on the directory are defined with COPY YES with V6.
Probably diagnosis guide can give some idea. But have not found this in other manuals. Someone may point out if i am missing something or wrong. Its just a guess !! [...]
11723 114 6_Re: DB14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 11 Jul 2001 13:36:08 +0100329_iso-8859-1 Chris,
For starters I would look at the indexing on the big table. You are accessing its index, matching no columns "Join using nested loop join with Access table dwh2.sxpdishl using index dwh2.sxpdishl_ix (0 cols)". So, an index scan of this huge table for every qualifying row from the first table...... [...]
11838 24 10_Re: urgent14_Harvey Puckett25_HPUCKETT@DOAS.STATE.GA.US31_Wed, 11 Jul 2001 08:45:53 -0400410_US-ASCII you already know (probably) that you have a "broken pipe" (input or output file) ... but do tell us more ...
>>> tkocer@HALKBANK.COM.TR 07/11/01 03:41AM >>> Dear list members can anybody tell me how to solve this problem? thanks
DSNL511I * DSNLIENO TCP/IP CONVERSATION FAILED 479 TO LOCATION 10.9.5.215 IPADDR=10.9.5.215 PORT=1253 SOCKET=WRITEV RETURN CODE=140 REASON CODE=745A7242 [...]
11863 55 48_Re: Automatic quiesce of the directory (DSNDB01)0_18_mebert@AMADEUS.NET31_Wed, 11 Jul 2001 14:50:00 +0200370_us-ascii Indeed Directory Indexes in DB2 V6 have the COPY YES attribute by default. This is to give you the option of image copying them. Remember that the Directory is not listed in the Catalog, and thus you cannot run SQL (like ALTER INDEX... COPY YES) on them.
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...]
11919 98 15_Re: Summary SQL11_David Nance16_DWNance@FHSC.COM31_Wed, 11 Jul 2001 08:58:07 -0400445_US-ASCII Marcus, Use case expression. Something like:
Select sum(case when turnover < 50000 then 1 else 0 end) ,sum(case........
Dave Nance First Health Services, Corp. (804)527-6841
>>> Marcus.Davage@LLOYDSTSB.CO.UK 07/11/01 05:21AM >>> Hi.
DB2 for OS/390 V5.1
If I've a table, thus:
Company no. Turnover 1 49000 2 48000 3 88000 4 99000 5 77000 ... n 2000000 m 2000001 ... [...]
12018 48 10_DDF thread18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Wed, 11 Jul 2001 09:02:48 -0400541_iso-8859-1 HELP! I've got a thread coming into our DB2 production subsystem (DB2 V5) and its using DB2 Connect (I think v6.1.1). I can't cancel the thread. When I issue the -cancel thread command it tells me the thread was previously cancelled. When I try to cancel it from our TMON monitor it tells me the same thing. Meantime the thread is just cranking along. Its not taking any DB2 time or CPU time. Here's a piece of the info from our TMON monitor: >>TOTAL : 50:00.04 DB2 : 50:00.04 WAIT : 102 PACKAGES: 1 * * TOT CPU: 0:00.02 DB2 [...]
12067 20 48_Re: Automatic quiesce of the directory (DSNDB01)16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 11 Jul 2001 18:35:34 +0530285_- Thanks for the logical reason Dr. M. Alter can't be used in directory indexes and hence it is given with COPY YES to make them used in image copy.
Tony, i hope you must have seen the reply from Dr. M, i can say that my guess was correct !!
Regards Sanjeev [...]
12088 48 15_Re: Summary SQL14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 11 Jul 2001 14:10:30 +0100389_iso-8859-1 Credit where credit's due, DB2Lister Philip Nelson provided SELECT TURNOVER_AMOUNT, COUNT(*) FROM (SELECT CASE WHEN TURNOVER < 50000 THEN '< 50k' WHEN TURNOVER < 100000 THEN ' 50k to 100k' WHEN TURNOVER < 150000 THEN ' 100k to 150k' ... END AS TURNOVER_AMOUNT FROM table) AS TURNOVER_TOTALS GROUP BY TURNOVER_AMOUNT; which satisfied my query. Thanks. Marcus Happy Lazy DBA [...]
12137 71 14_Re: DDF thread50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Wed, 11 Jul 2001 09:19:00 -0400272_iso-8859-1 I have been working with a client with DB2 V6 and I am supporting 2 other clients with DB2 V5. This same problem arose on the V6 subsystem, these threads came in from a server. They finally opened this up with IBM and have not received a response on this. [...]
12209 39 26_Re: DB2 UDB on Linux S/39011_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 11 Jul 2001 09:20:22 -0400521_ISO-8859-1 Philip
Thanks for that. I couldn't access that site (security) but I found another way in to announcements. 200-322 seems to be something else, but 200-412 seems to be the announcement I needed. Thanks again.
Regards Mike Turner Email: michael_turner@compuserve.com Web: www.michael-turner.ltd.uk
Message text written by DB2 Data Base Discussion List > Mike, Linux support was announced in announcement 200-322 and V7.1 is required. I'm not sure if it is on different media. HTH Phil [...]
12249 72 14_Re: DDF thread12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Wed, 11 Jul 2001 09:27:47 -0400369_iso-8859-1 Stephen,
How current are you on maintenance? We were on V5 at 9804 and 9905 and had similar problems. we are now at 0002 put level and haven't had any problems. (FYI, we had the same situation in PROD a while back where the suggestion was to cancel DDF....I correctly predicted that DB2 would crash and it did. All bad in the middle of the day!) [...]
12322 100 14_Re: DDF thread18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Wed, 11 Jul 2001 09:30:53 -0400318_iso-8859-1 We too are waiting for a response from IBM on this. As for TMON when i tried to do an 'explain' on the sql stmt it blew my TMON session right out of the water. We tried cancelling the thread using TMON but no luck. As for shutting down TMON I don't think they have had any problems there but not sure. [...]
12423 115 15_Re: Summary SQL12_Grant Mackay28_Grant_Mackay@PROGRESSIVE.COM31_Wed, 11 Jul 2001 09:33:20 -0400323_us-ascii SELECT TURNOVER_RANGE, count(*) AS no_business FROM ( SELECT CASE WHEN TURNOVER < 50000 THEN 'LT 50K' ELSE CASE WHEN TURNOVER < 100000 THEN '50K TO 100K' ELSE CASE WHEN TURNOVER < 150000 THEN '100K TO 150K' ELSE CASE WHEN TURNOVER < 200000 THEN '150K TO 200K' ELSE 'GT 200K' END END END END AS TURNOVER_RANGE [...]
12539 35 6_Re: DB15_Armando Arranja27_Armando_Arranja@BANCOBPI.PT31_Wed, 11 Jul 2001 14:29:53 +0100338_iso-8859-1 Hi Chris
I think the big problem is the first nested loop join... 269X13M rows using a non-matching index scan on the big table. I agree with Phil about indexing of the dishl table.
If that isn't possible, you should try a different solution like a good old father-son logic with flat files. [...]
12575 207 33_Re: Potentially inconsistent data14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Wed, 11 Jul 2001 09:47:51 -0400588_iso-8859-7 Gina,
Are you in a data sharing environment? There are two recent APARs for the 00C90206 for indexes on partitioned tablespaces in a data sharing environment. There are several others (non-data-sharing) that are older, so it would be good to know what your maintenance level is. Also, did you get an SVC dump with the error? If so, what was the dump title? My experience with inconsistent data errors has been that if you haven't used DSN1COPY or had a utility terminate abnormally, there's a very good chance that the error is an internal error or that you have a [...]
12783 94 14_Re: DDF thread16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 11 Jul 2001 09:47:15 -0400651_iso-8859-1 Stephen is not alone. We have this at our shop. V7, 150 maint. ETR is open sev 2 on this with IBM.
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Hall, Robert [mailto:Robert.Hall@OCC.TREAS.GOV] Sent: Wednesday, July 11, 2001 9:28 AM To: DB2-L@RYCI.COM Subject: Re: DDF thread
Stephen,
How current are you on maintenance? We were on V5 at 9804 and 9905 and had similar problems. we are now at 0002 put level and haven't had any problems. (FYI, we had the same situation in PROD a while back where the suggestion was to cancel DDF....I correctly predicted that [...]
12878 106 14_Re: DDF thread18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Wed, 11 Jul 2001 09:59:39 -0400505_iso-8859-1 Robert: We are current with our maint. on DB2 V5 'cause we're in the process of upgrading to DB2 V6 so we made sure we were up to snuff. My thoughts are now is to recycle the server that DB2 Connect is on and hope that that might cancel this thread. Or we have to wait until the next Sunday that our production system recyles...I hate to let it sit out there that long. By the responses I'm seeing this looks like a wide-spread problem. Oh well, just my luck. :-) Appreciate all the info. [...]
12985 60 19_DB2 Connect problem13_Pat Carbonaro19_pat2ldb2@EXCITE.COM31_Wed, 11 Jul 2001 07:04:11 -0700401_us-ascii Environment:
9672/R34 RS/6000 PC OS/390 V1.3 AIX V4.3.3 Windows NT V4 DB2 for OS/390 V5 Lotus Notes V4.6 DB2 Connect PE V5 Lotus Pump V2.5 Office '97 DB2 Connect EE V5 Visual Basic EE V6
Situation:
DB2 Connect EE was successfully installed and configured on RS/6000 to allow data to be brought from DB2 for OS/390 into Lotus Notes, on the RS/6000, using Lotus Pump. [...]
13046 13 42_Re: CPU/IO time units help needed urgently9_Linda Dba21_linda_dba@HOTMAIL.COM31_Wed, 11 Jul 2001 08:59:57 -0500379_- The xx:yy:zz.aaa means HH:MM:SS.AAA where .AAA is fraction of second so that 1:2:3.444 would mean 1 hr 2min and 3.444 sec.
Linda
================================================ 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.
13060 126 14_Re: DDF thread18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Wed, 11 Jul 2001 10:19:29 -0400393_iso-8859-1 Our systems programmer was talking with IBM a short while ago and she mentioned that we should try canceling the TCP/IP connection in order to cancel this thread. Now I wasn't privy to the conversation so not sure what she was really saying or how that would be done. We are now trying to get ahold of our tcp/ip guru's and see what they say. If it works I'll let y'all know.. [...]
13187 27 18_S390 2.10 & DB2 V510_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 11 Jul 2001 16:13:55 +0200359_us-ascii Hi estimeed list & listers..
We are instaling S390 2.10 on our test LPAR.
For some reason we cannot migrate to V6 immediately so we have to stay in V5 with S390 2.1o running.
Does anyone knows if there are some PTF to apply to DB2 ? Any problem with this release of S390 and DB2 ? Is anyone experimenting S390 with DB2 V5 ? [...]
13215 191 51_SQL0101N - The statement is too long or too complex14_Michael Bedard28_michael_p_bedard@HOTMAIL.COM31_Wed, 11 Jul 2001 10:21:58 -0400562_- Hello all,
I have a Business Objects generated SQL Select statement running on an NT Workstation V4 w/DB2 Connect Personal Edition V6 connected to DB2 UDB V7.1 on a SUN/Solaris box. I have read through the manuals and have yet to determine the exact problem !#$^%@$%&!!!!. If we take the sum function out of the select it works fine. We have tried increasing the DRDA heap size froom 128 to 256 and still get the error (I'll try making it larger, when I am done with this email) Can anybody out there either share their experiences with me or give [...]
13407 147 14_Re: DDF thread12_Le BD Nguyen20_lnguyen@AHOLDUSA.COM31_Wed, 11 Jul 2001 10:33:06 -0400431_us-ascii Steve,
Did you try to issue command "-STOP DDF MODE(FORCE)"?
I don't know if it will help but I think it is a little bit less drastic than cancelling the DDF address space and may prevent crashing the subsystem.
Le.
"Whittaker, Stephen" cc: Sent by: DB2 Data Subject: Re: DDF thread Base Discussion List [...]
13555 64 14_Re: DDF thread13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 11 Jul 2001 09:36:50 -0500591_US-ASCII Steve, Have you tried -stop ddf mode(force) HTH Kurt
>>> stephen.whittaker@PGNMAIL.COM 07/11/01 08:02AM >>> HELP! I've got a thread coming into our DB2 production subsystem (DB2 V5) and its using DB2 Connect (I think v6.1.1). I can't cancel the thread. When I issue the -cancel thread command it tells me the thread was previously cancelled. When I try to cancel it from our TMON monitor it tells me the same thing. Meantime the thread is just cranking along. Its not taking any DB2 time or CPU time. Here's a piece of the info from our TMON monitor: >>TOTAL : 50:00.04 [...]
13620 122 14_Re: DDF thread13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 11 Jul 2001 09:39:51 -0500433_iso-8859-1 Stephen,
We also have an open problem with IBM on this (SEV 1). Forcing the thread at the server doesn't help either. So far only recycling the DB2 subsystem clears it up. We are V6 DB2 OS/390 and V6.1 DB2 Connect EE.
Dave
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@PGNMAIL.COM] Sent: Wednesday, July 11, 2001 9:00 AM To: DB2-L@RYCI.COM Subject: Re: DDF thread [...]
13743 46 24_Re: Locks - Open - Fetch15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 11 Jul 2001 09:42:07 -0500412_- Hi
Well I disagree with Sanjeev in some aspects. First of all what locks do think about: intent locks as tablespace locks and table locks or page and row locks.
> Declare THISEMP Cursor for > select... > for update of <....> > > Open THISEMP Lock? -
As you say for update of, the cursor is not read only. At Open Cursor time tablespace and table (if segmented otherwise not) with IX. [...]
13790 138 38_Re: mysterious optimizer - 3rd attempt23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Wed, 11 Jul 2001 10:44:16 -0400830_iso-8859-1 James,
Thank you for your reply. No the response is not good with the second access path.
Table T has index on ENT_ID and clustering(TB_NAME,STATUS,VERSION) Table P has index on ENT_ID and clustering(TB_NAME,STATUS,VERSION) Table Xn has index on clustering(ENT_TYP,ENT_ID),(ENT_ID,ENT_TYP,SOURCE_ID, TARGET_ID), (ENT_ID), (TARGET_ID,ENT_TYP_SOURCE_ID),(SOURCE_ID),(SOURCE_ID,ENT_TYP,TARGET_ID),(SOU RCE_ID,TARGET_ID,ENT_TYP),(SOURCE_ID,TARGET_ID,ENT_TYP,ENT_ID),(TARGET_ID).
These are Platinum repository tables. As you said, columns selected from T table has no impact of access path, but if I remove the other 2 'P' columns from select list, the access path changes. Keeping any one of the 'P' column besides P.ENT_ID gives me the desired access path. The trouble is user is only interested [...]
13929 168 14_Re: DDF thread50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Wed, 11 Jul 2001 10:47:48 -0400462_iso-8859-1 If you execute this command the entire DDF shuts down. I use this command to terminate all DDF threads before bringing down Tmon. Otherwise DB2PDIST hangs up. Tmon will not come down because it tries to quiesce the DDF threads. This problem occurs in tmon V3.1.
Bob Knight
-----Original Message----- From: Le BD Nguyen [mailto:lnguyen@AHOLDUSA.COM] Sent: Wednesday, July 11, 2001 10:33 AM To: DB2-L@RYCI.COM Subject: Re: DDF thread [...]
14098 148 14_Re: DDF thread16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 11 Jul 2001 11:01:26 -0400427_iso-8859-1 Steve, We have had this problem with both TCP/IP and with SNA. So apparently it is fairly pervasive. Please let the group know whether the IBM suggestion works for you.
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@PGNMAIL.COM] Sent: Wednesday, July 11, 2001 10:19 AM To: DB2-L@RYCI.COM Subject: Re: DDF thread [...]
14247 62 48_Re: Automatic quiesce of the directory (DSNDB01)13_Tony Hurlston27_tony.hurlston@UK.ZURICH.COM31_Wed, 11 Jul 2001 16:04:22 +0100557_us-ascii Thanks guys but..... the question remains..... how do we turn off COPY YES ?
Regards
Tony ____________________________________________________ Tony Hurlston Senior Systems Programmer Technology Operations & Planning Zurich Financial Services (UKISA) Group Services Ltd.
Mailto:Tony.Hurlston@uk.zurich.com
"S, Sanjeev (CTS)" cc: Sent by: DB2 Data Subject: Re: Automatic quiesce of the directory (DSNDB01) Base Discussion List [...]
14310 191 22_Re: Directory Reclaims15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Wed, 11 Jul 2001 11:13:12 -0400591_iso-8859-1 Hi Ruth, and welcome to the club.
I noticed that a couple of the list members have politely told you to RTFM. Having pored over these FMs I can testify that they can be quite confusing. Furthermore, the recommendation for the number of directory entries a data sharing group needs is (paraphrased) "Choose an appropriate number for the directory ratio. We like the number 5." Translated: "Even we don't have a clue how many directory entries you'll need - take a guess and adjust it accordingly." To give you an idea where to start, here's what I've learned thus far. [...]
14502 150 25_Re: Java Stored Procedure14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 11 Jul 2001 10:32:02 -0500532_- Ritu,
By 'someone', I mean a human body. I leave aside the meta-physical discources on whether the "one" is the body, or the soul that inhabits the body, on the grounds that the action of butchering (whether fully- or only half-butchering) still requires a body to carry out the action. Even if that half-butchering was carried out by some form of artifical intelligence (in which case the short comings of artifical intelligence are plain to see), I think a human body would still be needed somewhere in the process. [...]
14653 34 48_Re: Automatic quiesce of the directory (DSNDB01)0_18_mebert@AMADEUS.NET31_Wed, 11 Jul 2001 17:43:35 +0200377_us-ascii You can't (for any Directory object). Just accept it. The only effect is a few extra entries in SYSCOPY. They get removed when you run MODIFY on the TSs.
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
Thanks guys but..... the question remains..... how do we turn off COPY YES ? [...]
14688 15 46_Pasword Changes for Cold Fusion and DB2 OS/3909_Tim Burke21_Tim_Burke@PEPBOYS.COM31_Wed, 11 Jul 2001 10:27:54 -0500389_- Does anyone know how to change the password to DB2 OS/390 in Cold fusion?
Any ideas would be greatly appreciated.
Thanks, Tim Burke
================================================ 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.
14704 167 14_Re: DDF thread12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 11 Jul 2001 09:00:01 -0700395_us-ascii Well, looks like it really spread. We have an open problem with IBM on this as well (Sev 2 right now). Sometimes -STO DDF MODE(FORCE) works and sometimes it doesn't. Sometimes, after the -STO DDF MODE(FORCE) after a lengthy period (up to 15 minutes) the thread will go away and sometimes the only way to get rid of the thread is to KILL DB2 which is obviously not a good solution. [...]
14872 181 14_Re: DDF thread18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Wed, 11 Jul 2001 12:11:04 -0400510_iso-8859-1 Well we tried the IBM suggestion with tcp/ip and NOTHING. That darn thread is out there and it ain't goin away until we recycle the production subsystem. I even tried signing onto the server and stopping the application process. It stopped the other threads that were running but not this one. Now that was really strange. So now I've run out of ideas and I guess we just wait until next Sunday. Thanks for all the responses to this. Its nice to know one is not alone with this little problem. [...]
15054 23 39_Balt./Wash. DB2 Users' Group - handouts17_Valerie J Traurig18_valeriet6@JUNO.COM31_Wed, 11 Jul 2001 12:18:45 -0400663_us-ascii FYI -The Baltimore/Washington DB2 Users' Group has posted some of the handouts of the presentations from the last session, June 14, on their website: www.bwdb2ug.org.
________________________________________________________________ GET INTERNET ACCESS FROM JUNO! Juno offers FREE or PREMIUM Internet access for less! Join Juno today! For your FREE software, visit: http://dl.www.juno.com/get/tagj.
================================================ 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.
15078 175 47_Re: DB2 Online Reorganization - Help Needed !!!13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 11 Jul 2001 09:25:37 -0700563_iso-8859-1 Your problem is not with SMS, it is with the concept that shadow datasets are different from "normal" ones. They are not -- the mirror is allocated at the start of the reorg, and at the end it is renamed back to the "normal" name. This is changed in version 7 (the rename no longer takes place), but the underlying concept of online reorg remains the same: there is no functional difference between shadow datasets and "normal" ones. They should be in the same SMS pool, and your pool will have to be enlarged to accommodate the reorg process. We [...]
15254 52 22_Re: S390 2.10 & DB2 V50_36_doreenrowland@NORTHWESTERNMUTUAL.COM31_Wed, 11 Jul 2001 11:42:46 -0500341_ISO-8859-1 We have just gone to OS/390 V2.10 and all our DB2 subsystems are V5. Some were at 2000 mid year level maintenance when 2.10 first went in and they did not experience any problems. We've very recently brought our V5 up to a newer 2001 level of maintenance for the V6 upgrade, and still there are no problems with OS/390 2.10. [...]
15307 18 48_calling stored procedures using Microsoft Access10_Vinson Lee19_vlee@SDCCD.CC.CA.US31_Wed, 11 Jul 2001 09:45:51 -0700475_iso-8859-1 Is it possible to call a DB2 stored procedure using Microsoft Access or Excel? Is anyone doing this? What needs to be done to get this working? We are running DB2 version 5 on OS/390 version 2.5
Thanks.
Vince
================================================ 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.
15326 31 27_Compression and Bufferpools11_DBA Support21_dbasupport@WILLIS.COM31_Wed, 11 Jul 2001 18:15:41 +0100702_us-ascii Hi
Am I right in assuming that if you have a compressed tablespace, that the data will still be compressed in the bufferpool (and thus in effect making the bufferpool approx twice the size but using the same amount of storage)?
We are on DB2 V6.1 and OS/390 V2.6.
Thanks, Phil Cooper.
______________________________________________________________________ The information in this email and in any attachments is confidential and may be privileged. If you are not the intended recipient, please destroy this message, delete any copies held on your systems and notify the sender immediately. You should not retain, copy or use this email [...]
15358 56 51_00C900BA on related index during online reorg of TS0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 11 Jul 2001 12:30:34 -0500640_us-ascii I'm missing part of the 'big picture'. DB2 V6 on OS390 v2.10. I did an online reorg of one of our large tables (21,000 tracks) with the following reorg command
REORG TABLESPACE db.TS000005 SORTDATA SORTKEYS SHRLEVEL NONE UNLDDN SYSREC COPYDDN (CPLA0001) STATISTICS REPORT YES UPDATE ALL UNLOAD CONTINUE
The TS reorg went fine, no contention, until it got to the index rebuild. At that point I started getting resource unavailable errors with reason 00c900ba on an index (resource type 2003) for the table. Since this locked up production access to that table for 30 minutes, I am anticipating getting my [...]
15415 19 22_Re: Directory Reclaims11_Ruth Sutlic24_RUTH.SUTLIC@DILLARDS.COM31_Wed, 11 Jul 2001 12:22:10 -0500280_- Bill, I am overcome with emotion that you would take so much time to write in detail what this means. This answers allot of my questions w/o having to start with the manual. You've also given me some commands to use in my quest for information on good versus bad reclaims. [...]
15435 17 47_Re: DB2 Online Reorganization - Help Needed !!!14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Wed, 11 Jul 2001 10:59:36 -0500450_iso-8859-1 The mirror dataset gets renames to the original dataset name at the end of the reorg. You should allocate your mirror dataset in the same pool as your original dataset.
From Edward Vassie...
================================================ 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.
15453 13 34_Re: Restart(current) in a load job9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 11 Jul 2001 12:41:42 -0500347_- In V7 RESTART(CURRENT) is synonymous with RESTART.
Jim Ruddy DB2 for z/OS and OS/390 Development
================================================ 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.
15467 18 41_Re: Sort Phase in IBM Load Utility DB2 V59_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 11 Jul 2001 12:47:19 -0500347_- The sort that you see during load is for the index keys. Using the same sort parameters for your input data probably put the data in some bizarre order which caused the elongated elapsed time.
The input data should be sorted so that input data is in the same sequence as your partitioning index - only then will the sort be avoided. [...]
15486 216 31_Re: Compression and Bufferpools0_24_Bruce.Williamson@PSIR.IE31_Wed, 11 Jul 2001 18:49:43 +0100637_windows-1252 Howzit Phil?
The amount of additional data that can fit in the bufferpool is dependent on the compression ratios of compressed tablespace pages in the bufferpool.
HTH
Cheers Bruce
__________________________________________________
Bruce Williamson DB2 Database Administrator
perotsystems information resource(tm)
Computer Centre Cabinteely Dublin 18 Ireland
Bruce.Williamson@psir.ie
-----Original Message----- From: DBA Support [mailto:dbasupport@WILLIS.COM] Sent: 11 July 2001 18:16 To: DB2-L@RYCI.COM Subject: Compression and Bufferpools [...]
15703 13 31_Re: Compression and Bufferpools0_26_truman.g.brown@VERIZON.COM31_Wed, 11 Jul 2001 14:00:21 -0400345_us-ascii A bonus with compression is that corresponding DB2 protection log records are compressed, too.
================================================ 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.
15717 83 55_Re: 00C900BA on related index during online reorg of TS16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 11 Jul 2001 14:01:22 -0400464_iso-8859-1 Yes. You want SHRLEVEL CHANGE. You will still have a very brief outage for the last phase of the LOG APPLY and for the SWITCH (rename). You can influence the length of the last log apply via MAXRO which you should set less than IRLMRWT if you want to reduce (or maybe even avoid!) SQLCODE -911. For the SWITCH, figure 1-4 seconds per dataset. Your biggest challenge will be the DRAIN in the REORG if your applications do not have frequent COMMITs. [...]
15801 46 31_Re: Compression and Bufferpools12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Wed, 11 Jul 2001 13:19:54 -0500481_iso-8859-1 YES Tom Moulder (BMC Software,Inc.)
-----Original Message----- From: DBA Support [mailto:dbasupport@WILLIS.COM] Sent: Wednesday, July 11, 2001 12:16 PM To: DB2-L@RYCI.COM Subject: Compression and Bufferpools
Hi
Am I right in assuming that if you have a compressed tablespace, that the data will still be compressed in the bufferpool (and thus in effect making the bufferpool approx twice the size but using the same amount of storage)? [...]
15848 37 43_Re: Balt./Wash. DB2 Users' Group - handouts12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US31_Wed, 11 Jul 2001 14:19:25 -0400580_US-ASCII Thanks for sending this out...
Mark Anzmann Database Administration DHRIS Program Team Accenture
>>> valeriet6@JUNO.COM 07/11 12:18 PM >>> FYI -The Baltimore/Washington DB2 Users' Group has posted some of the handouts of the presentations from the last session, June 14, on their website: www.bwdb2ug.org.
________________________________________________________________ GET INTERNET ACCESS FROM JUNO! Juno offers FREE or PREMIUM Internet access for less! Join Juno today! For your FREE software, visit: http://dl.www.juno.com/get/tagj. [...]
15886 48 31_Re: Compression and Bufferpools13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Wed, 11 Jul 2001 11:13:48 -0700550_- yes, thats true. The number of rows per page is still affected by PCTFREE and FREEPAGE as well.
DT
-----Original Message----- From: DBA Support [mailto:dbasupport@WILLIS.COM] Sent: Wednesday, July 11, 2001 11:16 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Compression and Bufferpools
Hi
Am I right in assuming that if you have a compressed tablespace, that the data will still be compressed in the bufferpool (and thus in effect making the bufferpool approx twice the size but using the same amount of storage)? [...]
15935 207 55_Re: 00C900BA on related index during online reorg of TS13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 11 Jul 2001 11:33:45 -0700405_iso-8859-1 I hope this isn't a duplicate, I got a reject message for my last message...
Online reorg is defined as SHRLEVEL CHANGE, so these must not be the actual control statements you used or it was not an online reorg. The only time you should experience an outage for index rebuild is if you reorg a partition and have an NPI, but the control statements you provided do not specify PART. [...]
16143 27 44_HELP : Archive lost ... DB2 not starting !!!17_Alessandro Brezzi24_alessandro.brezzi@TIN.IT31_Wed, 11 Jul 2001 20:42:09 +0200365_us-ascii Hi all, a collegue deleted (sic !!) all the archive log we made on disk for your test environment (DB2 v6 for OS/390). Just ten minutes after this, a long running thd (from DDF), come down and DB2 tried to recover from active log and from the most recent archive, but no dataset is still there, so DB2 decided to abend, and now refuse to start again. [...]
16171 64 34_progr/analyst AS400 North Carolina13_kathryn sears24_ksears@DPCONSULTANTS.COM31_Wed, 11 Jul 2001 15:01:06 -0400511_iso-8859-1 Hi, all! If anyone knows of the following, we do pay $1K referral fees: RPG 400/IV/ILE Programmer/ Analyst North Carolina: Triad (Greensboro/ High Point/ Winston-Salem) Prefer local candidate 2-5 yrs or more of experience. Really great company/ growth/ strong technology and mgmnt. Salary will start out between 50-63K, but will be reviewed and increased if candidate performs well. Thanks for your help once more! Kathryn Sears Data Processing Consultants, Inc. 336.510.5526 ksears@dpconsultants.com
16236 111 14_Re: DDF thread12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 11 Jul 2001 12:17:02 -0700584_us-ascii Lots of good advice, and an obvious problem with DDF, but I haven't seen anyone suggest identifying the application server that the thread was coming from and killing the process (or rebooting the server) from the other side to clear up a distributed thread that wouldn't be cancelled from the console. At a previous job, we even had a naming convention to make this identification easier, and could call the operators and tell them which machine in the small server farm to power off. Sometimes it would take a couple of minutes for the thread to finally go away after [...]
16348 35 48_Re: HELP : Archive lost ... DB2 not starting !!!15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Wed, 11 Jul 2001 14:10:12 -0500404_us-ascii Start DB2 Cold as follows:
Check volume 1 of the administration guide on page 4-239
to cold start db2 follow the following steps:
run dsnj004 to print the highest RBA written
HIGHEST RBA WRITTEN 00003DA8FE3E <==== use this RBA HIGHEST RBA OFFLOADED 00003C1DEFFF RBA WHEN CONVERTED TO V4 0000033373E8
add +1 to the rba and round up to the next 4k boundary [...]
16384 54 48_Re: HELP : Archive lost ... DB2 not starting !!!20_Pav Kumar-Chatterjee17_pavkc@HOTMAIL.COM31_Wed, 11 Jul 2001 19:27:33 -0000358_- Hi Alessandro
You can't tell DB2 to ignore something it is trying to back out. When you try and start DB2 what message do you get back??
As a last resort, if this is a test system, you could always try and cold start DB2. This could leave you with potentially inconsistent data!! Make sure you talk to your DBAs/Users before doing this. [...]
16439 57 48_Re: HELP : Archive lost ... DB2 not starting !!!12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 11 Jul 2001 22:27:16 +0200411_iso-8859-1 Hi, COLDSTART ;-( If it's test it's (hopefully) not that bad. You use utility DSNJU003 CRESTART CREATE,STARTRBA=?????????000,ENDRBA=???????????000 where they are equal and greater then the "highest rba written" from DSNJU004. (note it must end with '000')
Isaac Yassin DBMS & IT Consultant IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 yassini@bezeqint.net [...]
16497 128 14_Re: DDF thread26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Wed, 11 Jul 2001 12:36:14 -0700675_iso-8859-1 We had a similar problem at a former employer and we routinely recycled the gateway to clear up stranded threads.
Bill Johnson Russell Mellon
-----Original Message----- From: tim malamphy [mailto:timalamphy@YAHOO.COM] Sent: Wednesday, July 11, 2001 3:17 PM To: DB2-L@RYCI.COM Subject: Re: DDF thread
Lots of good advice, and an obvious problem with DDF, but I haven't seen anyone suggest identifying the application server that the thread was coming from and killing the process (or rebooting the server) from the other side to clear up a distributed thread that wouldn't be cancelled from the console. At a previous job, we even [...]
16626 15 13_IP versus SNA10_Tom Taylor17_ttaylor@CHUBB.COM31_Wed, 11 Jul 2001 15:38:58 -0400300_us-ascii Does anyone have numbers or issues for using IP over SNA or visa versa when connecting to DB2. I know there are IBM white papers, but I was looking for real user experience. I estimate that we do 2-3 million ddf transactions a day going thru 3 ddcs gateways running db2 connect EE. Tom [...]
16642 29 53_inactive threads caused by calls to stored procedures16_Adriana Teixeira29_ateixeira@CAIXASEGUROS.COM.BR31_Wed, 11 Jul 2001 16:48:01 -0300580_us-ascii Hi List,
We're facing a problem in our environment (DB2/390 v. 5.1) with inactive threads, these threads are becoming inactive after being initialized by an ASP application that is calling a stored procedure written in COBOL . This ASP application establishes a TCP/IP connection using ADO components, this connection should not be closed due to performance reasons. So I'd like to know if any of you knowns how to free the thread (release) without closing the connection. I may say, Is there any method in the ADO components that don't let inactive threads? [...]
16672 39 48_Re: HELP : Archive lost ... DB2 not starting !!!17_Alessandro Brezzi24_alessandro.brezzi@TIN.IT31_Wed, 11 Jul 2001 21:54:58 +0200321_us-ascii Thank Daniel and Pav, I'm sure of the risk: there was a batch job running for update on a large table space (about 100M rows), but : 1) this is a test env, 2) I can rebuild from scratch the TS, and finally the User made the disaster deleting the archive (" ... what is this *spam* filling up 6 volumes? "). [...]
16712 93 48_Re: HELP : Archive lost ... DB2 not starting !!!16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Wed, 11 Jul 2001 21:05:10 +0100354_us-ascii Ale,
you must do a COLD START.
Details can be found in the Admin Guide - sorry but I changed my laptop and I have not yet re-installed the READIBMW or I could do a bit of cut and paste of more precise instructions....
you have to run a couple of utilities (from memory, DNSJU003 and 4) and calculate STARTRBA / ENDRBA. [...]
16806 47 17_AW: IP versus SNA16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Wed, 11 Jul 2001 22:25:15 +0200587_iso-8859-1 We run some tests and IP is faster, but we had a lot of problems with the resynch stuff. IBM fixed it on version 5 (connect server) and it's included in DB2 connect V7 FP1
I can't remember the number
Roland
> -----Ursprüngliche Nachricht----- > Von: Tom Taylor [SMTP:ttaylor@CHUBB.COM] > Gesendet am: Mittwoch, 11. Juli 2001 21:39 > An: DB2-L@RYCI.COM > Betreff: IP versus SNA > > Does anyone have numbers or issues for using IP over SNA or visa versa > when connecting to DB2. I know there are IBM white papers, but I was > looking for real [...]
16854 79 17_RACF/DB2 security10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Wed, 11 Jul 2001 15:04:57 -0600525_iso-8859-1 We are working on the RACF/DB2 security now and we ran into a problem: Even we permitted a user with SYSADM authority, he still isn't able to enter DB2 command under TSO. However, he is able to enter the DB2 command under SDSF. The RACF command we did is: PERMIT DBT1.SYSADM CLASS(DSNADM) ID(userid) ACC(READ) I don't know if we missing anything. Another related question is : What's the difference between ACC(READ) and ACC(ALTER) when permitting the DB2 administrative authorities(DBADM,SYSADM,SYSOPR....). [...]
16934 77 18_DB2 Connect thread10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Wed, 11 Jul 2001 15:22:31 -0600549_iso-8859-1 Hi List, We have DB2 UDB V7 installed on OS/390 and DB2 connect personal edition running on my PC which is window NT. I am able to connect to OS/390 database with DB2 Control Center. The only thing is the thread is always active even I specified DDFTHREADS=INACTIVE on DB2 installation panel. So now I set idle thread timeout to 3sec and the active thread does disappear after idle for a while. However, from performance point of view, I would like to make the thread inactive instead of timeout. Is it any way can make this happen? [...]
17012 65 55_Re: 00C900BA on related index during online reorg of TS0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 11 Jul 2001 17:05:53 -0500384_us-ascii Thanks Eric.
I was trying to find our value for IRLMRWT (IRLM locked resource wait time limit) and not having much luck matching the ZPARM descriptions displayed in Mainview (Boole & Babbage) with IRLMRWT (I tried RTFM, but the zparm is not in the B&B manual). Is it in this display? Could it be "TIMEOUT (SECS)" (60 is default value specified in Install Guide)? [...]
17078 100 21_Re: RACF/DB2 security0_19_Tim.Lowe@STPAUL.COM31_Wed, 11 Jul 2001 17:13:47 -0500429_iso-8859-1 Grace, I have not tried this, but I remember reading on this list that commands could not use RACF security, they had to use native security. You might want to search the archives for "racf commands".
I hope this helps.
Thanks, Tim
Grace Chen cc: Sent by: DB2 Subject: RACF/DB2 security Data Base Discussion List [...]
17179 207 19_LPL status question10_Shery Hepp17_schepp@SRPNET.COM31_Wed, 11 Jul 2001 15:17:00 -0700296_iso-8859-1
Greetings:
We have a production tablespace that recently had an LPL status. Just wondering what causes this and what's the best way to correct and prevent in the future?
(V6 DB2 2 way data sharing OS/390 2.7)
TIA- Regards,
Shery Hepp
17387 78 41_Re: Sort Phase in IBM Load Utility DB2 V50_19_mike.holmans@BT.COM31_Wed, 11 Jul 2001 23:27:15 +0100360_iso-8859-1 Is there any referential integrity defined on this table?
As I understand the manual, if there is a foreign key defined on it, that counts as a key.
Mike Holmans Database Consultant BT Affinitis Computing Partners mike.holmans@bt.com
This post is solely the opinion of its author and does not necessarily reflect BT's view [...]
17466 102 55_Re: 00C900BA on related index during online reorg of TS16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 11 Jul 2001 18:39:09 -0400503_iso-8859-1 It looks like TIMEOUT is IRLMRWT - makes some sense (the DB2 default is 60 seconds), and DEADLOCK is the IRLM deadlock detection cycle (again, 5 is the default). So if you have perhaps 30 or 45 for the MAXRO value in your online reorg, you reduce the exposure to -911. We have our timeout value set to 180 seconds (*WAY* too high IMHO) and have MAXRO typically about 60. Of course, make sure that your applications COMMIT or else you will have the REORG time out trying to do the DRAIN. [...]
17569 127 14_Re: DDF thread12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 11 Jul 2001 16:04:48 -0700604_us-ascii We're exclusively TCPIP and get the thread hangs continuously. Killing the APP server doesn't help at all any more than STOPPING DDF MODE(FORCE). We know exactly what APP server is the problem and have tried that. Threads just hang. period. --- tim malamphy wrote: > Lots of good advice, and an obvious problem with DDF, > but I haven't seen anyone suggest identifying > the application server that the thread was coming from > and killing the process (or rebooting the server) from > the other side to clear up a distributed thread that > wouldn't be cancelled from [...]
17697 120 39_Re: Need help on SQL Performance - ASAP13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 11 Jul 2001 18:54:36 -0500651_iso-8859-1 Beth,
The dynamic-ness of the queries makes tuning difficult, since for online performance you would need the greatest level of matching index predicates as possible.
One single index will not help, since all WHERE clause combinations cannot be catered for.
You could create a single column index for each column, and hope for multi-index access. Although this is "generally" an undesirable access path. Or you could create 5 indexes, each with all 5 columns, and each table having the leading column different. The second matchcol of two IN lists is always an index screening predicate anyway (I haven't tried an [...]
17818 199 22_Re: Directory Reclaims15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 12 Jul 2001 09:56:57 +1000327_iso-8859-1 Hi Bill,
We've got a few small data sharing groups here but unfortunately I'm not involved in all that. Just wanted to say that, not having used DS, I liked your post. Helped explain a whole lot of stuff I haven't experienced. Sometimes it's good to just RTFL (L for DB2-Listserv) for what you're after. [...]
18018 158 6_Re: DB13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 11 Jul 2001 19:04:52 -0500439_us-ascii Chris,
Indexes are not going to help this current query....The problem is that every row of the three tables must be joined before the WHERE clause date range predicates can be evaluated. Therefore, I cannot disqualify a row until I have checked that it fails all three date range checks.
Sanjeev was on the right track. What you need to do is split them up into three separate SQLs and separate them by UNIONS [...]
18177 81 55_Re: SQL0101N - The statement is too long or too complex13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 11 Jul 2001 19:06:50 -0500609_iso-8859-1 Michael,
This part of the message should hold the key:
Increase the size of the statement heap (stmtheap) in the database configuration file.
Regards Terry Purcell Yevich Lawson & Assoc Inc (YL&A) IBM Gold Consultant - DB2 IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 http://www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Michael Bedard Sent: Wednesday, July 11, 2001 9:22 AM To: DB2-L@RYCI.COM Subject: SQL0101N - The statement is too long or too complex [...]
18259 175 25_Re: Java Stored Procedure15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 12 Jul 2001 10:05:32 +1000625_iso-8859-1 Bored by any chance, James?
Raymond PS. I liked 'that' sentence too.
> -----Original Message----- > From: James Campbell [SMTP:jacampbell@ACSLINK.NET.AU] > Sent: Thursday, 12 July 2001 1:32 am > To: DB2-L@RYCI.COM > Subject: Re: Java Stored Procedure > > Ritu, > > By 'someone', I mean a human body. I leave aside the meta-physical > discources on whether the "one" is the body, or the soul that inhabits the > body, on the grounds that the action of butchering (whether fully- or only > half-butchering) still requires a body to carry out the action. Even if > that half-butchering was [...]
18435 232 14_Re: DDF thread11_Roland Chua18_rolandchua@SGX.COM31_Thu, 12 Jul 2001 09:05:40 +0800725_us-ascii We also had the same problem. Threads terminated when we brought down the DB2 connect server.
"Whittaker, Stephen" cc: Sent by: DB2 Data Subject: Re: DDF thread Base Discussion List
12/07/2001 12:11 AM Please respond to DB2 Data Base Discussion List
Well we tried the IBM suggestion with tcp/ip and NOTHING. That darn thread is out there and it ain't goin away until we recycle the production subsystem. I even tried signing onto the server and stopping the application process. It stopped the other threads that were running but not this one. Now that was [...]
18668 155 20_Re: DB2 Data Sharing21_Anthony L. Ciabattoni25_ACiabattoni@CHECKFREE.COM31_Wed, 11 Jul 2001 22:10:17 -0400359_iso-8859-1 Steve,
If you are interesting in any DB2 Data Sharing related classes please do look at Bryce Krohn's website - www.krohnskorner.com. Byrce's classes and hands on lab are developed in conjunction with IBM learning Services. I have first hand experiences in these classes that Bryce teaches and they were wonderful and very informative. [...]
18824 101 41_Re: Sort Phase in IBM Load Utility DB2 V512_Marcus Green18_mgreen@AAPT.COM.AU31_Thu, 12 Jul 2001 12:23:54 +1000412_US-ASCII Hi Mike,
Thanks for the response. No there is no key (foreign or Primary) defined in the DDL - only the single partitioning index (result being a single key I believe).
Marcus
>>> mike.holmans@BT.COM 12/07/01 8:27:15 >>> Is there any referential integrity defined on this table?
As I understand the manual, if there is a foreign key defined on it, that counts as a key. [...]
18926 242 25_Re: Java Stored Procedure8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 11 Jul 2001 19:37:21 -0700396_us-ascii James,
As if the IBM manual itself was not confusing enough, you've confused me even further. But one thing I CAN surmise from your mail is that it takes more than some knowledge of DB2 and java to understand these manuals....some understanding of human behavior, the reasons for human existence and a knowledge of why human beings behave the way they behave would not hurt. [...]
19169 242 25_Re: Java Stored Procedure8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 11 Jul 2001 19:40:06 -0700416_us-ascii James,
As if the IBM manual itself was not confusing enough, you've confused me even further. But one thing I CAN surmise from your mail is that it takes more than some knowledge of DB2 and java to understand these manuals....to be more specific, some understanding of human behavior, the reasons for human existence and a knowledge of why human beings behave the way they behave would'nt hurt. [...]
19412 242 25_Re: Java Stored Procedure8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 11 Jul 2001 19:41:44 -0700396_us-ascii James,
As if the IBM manual itself was not confusing enough, you've confused me even further. But one thing I CAN surmise from your mail is that it takes more than some knowledge of DB2 and java to understand these manuals....some understanding of human behavior, the reasons for human existence and a knowledge of why human beings behave the way they behave would not hurt. [...]
19655 241 25_Re: Java Stored Procedure8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 11 Jul 2001 19:43:50 -0700396_us-ascii James,
As if the IBM manual itself was not confusing enough, you've confused me even further. But one thing I CAN surmise from your mail is that it takes more than some knowledge of DB2 and java to understand these manuals....some understanding of human behavior, the reasons for human existence and a knowledge of why human beings behave the way they behave would not hurt. [...]
19897 246 25_Re: Java Stored Procedure8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 11 Jul 2001 19:48:00 -0700396_us-ascii James,
As if the IBM manual itself was not confusing enough, you've confused me even further. But one thing I CAN surmise from your mail is that it takes more than some knowledge of DB2 and java to understand these manuals....some understanding of human behavior, the reasons for human existence and a knowledge of why human beings behave the way they behave would not hurt. [...]
20144 123 23_Java Stored Procedure..8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 11 Jul 2001 19:49:50 -0700396_us-ascii James,
As if the IBM manual itself was not confusing enough, you've confused me even further. But one thing I CAN surmise from your mail is that it takes more than some knowledge of DB2 and java to understand these manuals....some understanding of human behavior, the reasons for human existence and a knowledge of why human beings behave the way they behave would not hurt. [...]
20268 33 25_same table Insert problem12_Rakesh Singh14_rasun@JUNO.COM31_Wed, 11 Jul 2001 20:09:00 -0700461_us-ascii Howdy folks , I have a situation where i have to insert a new row in the table A by selecting from table A itself. for example.
insert into TABLEA (first_name , last_name ) select "mike", last_name from TABLEA where first_name = "jack"
I tried using the above statement but hit a SQL error of -118 . My environment is OS/390, DB2 V5.1 I know i can do it programmatically but just being lazy. So any help will be greatly appreciated. [...]
20302 71 24_Re: Locks - Open - Fetch16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 12 Jul 2001 09:48:46 +0530307_- Walter,
You mentioned correctly. I did not point the kind of lock (page/row/table etc) because i presumed it depends on how is the tablespace defined and what DB2 thinks about it. I mentioned views only WHEN the locks will be taken. I am not sure but if someone can point out its correctness. [...]
20374 63 29_Re: same table Insert problem16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 12 Jul 2001 09:58:51 +0530307_- I am not sure what you are trying to achieve by this. If the last name for all the "jack" is same for all/unique rows then you can simply code the insert statement like:
INSERT INTO TABLEA VALUES("MIKE",last name for 'jack').
It would be better if you could send the requirement again. [...]
20438 229 25_Re: SQL question (DB2 V6)13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 11 Jul 2001 23:38:32 -0500332_iso-8859-1 SQL question (DB2 V6)Max,
On OS/390 the SQL only solutions are not pretty, and are therefore only suitable for a "once-off", or for small result sets.
For a more regular solution, or for larger results, then your best bet is to simply open a cursor, fetch every row, and discard those you do not need. [...]
20668 211 14_Re: DDF thread13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU31_Thu, 12 Jul 2001 14:39:54 +1000441_iso-8859-1 There are two flavours for the Cancel Thread command, I assume you have tried both! -Cancel Thread(token) -Cancel DDF thread(token)
What is the actual (token) number , I seem to remember a problem when this number got too large ?
Shaun
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@PGNMAIL.COM] Sent: Thursday, 12 July 2001 2:11 To: DB2-L@RYCI.COM Subject: Re: DDF thread [...]
20880 16 14_Re: DDF thread15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM31_Thu, 12 Jul 2001 14:40:00 +1000378_- I may be off the mark here but if there's a Client thread on the workstation you could purge it from DB2 Connect
regards, Steve
================================================ 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.
20897 16 51_David Ayers/ISG/CORP/Highmark is out of the office.11_David Ayers24_david.ayers@HIGHMARK.COM31_Thu, 12 Jul 2001 01:01:20 -0400452_us-ascii I will be out of the office starting 07/11/2001 and will not return until 07/15/2001.
For DB2 OS/390 assistance contact your support DBA. For Datajoiner / DB2 connect support contact Chuck Krall
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20914 26 47_Reg Munusamy/PIP/GGEN/GIO is out of the office.12_Reg Munusamy20_rmunusamy@GIO.COM.AU31_Thu, 12 Jul 2001 15:10:09 +1000665_us-ascii I will be out of the office from 01/12/2001 until 07/23/2001.
I will respond to your message when I return.
This email message and any accompanying attachments may contain information that is confidential and is subject to legal privilege. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the [...]
20941 98 29_Re: same table Insert problem12_Rakesh Singh14_rasun@JUNO.COM31_Wed, 11 Jul 2001 22:42:42 -0700341_us-ascii Hi Sanjeev , The requirement still remain the same . For the sake of argument i gave a small example. otherwise TableA has 12 columns . we want to insert new row in table A which will have 10 fields similar to the row already existing in the table. The key fields will be changed and a new row will be inserted into the table. [...]
21040 15 52_William F Renfroe/GA/CheckFree is out of the office.15_William Renfroe22_WRenfroe@CHECKFREE.COM31_Thu, 12 Jul 2001 01:32:20 -0400389_us-ascii I will be out of the office starting 07/12/2001 and will not return until 07/16/2001.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21056 43 10_Re: urgent29_=?US-ASCII?Q?R.Teoman_KOCER?=22_tkocer@HALKBANK.COM.TR31_Thu, 12 Jul 2001 09:07:20 +0300457_US-ASCII i am trying to select all columns of my table.table has about 8.5 million records.i have no problem selecting all columns for smal tables .i mean the tables which have less records.i am thinking it is because of record size but i may be wrong.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Harvey Puckett Sent: Wednesday, July 11, 2001 3:46 PM To: DB2-L@RYCI.COM Subject: Re: urgent [...]
21100 122 29_Re: same table Insert problem16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 12 Jul 2001 11:55:43 +0530312_- Hi Rakesh,
I can see the query working at my place. I am not sure about the reason you are getting -118. I have tried it out in V6. I do not have V5 manual to confirm if it doesn't work there but V6 manual never says it is a new feature and if i can recall correctly i had used this in V5 as well. [...]
21223 17 35_Tablespaces without full image copy40_=?iso-8859-1?Q?Maria_Gra=E7a_Fernandes?=22_graca.fernandes@CGD.PT31_Thu, 12 Jul 2001 07:33:43 +0100350_iso-8859-1 Hello I need to know, the tablespaces that don´t have a full image copy.
TIA Graça Fernandes
===============================================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.
21241 22 23_Re: LPL status question15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 12 Jul 2001 02:18:34 -0500313_- Shery
A page is flagged LPL (logical page list), when it has to be written to the group bufferpool, but cannot.
possible reasons
1. Your group bufferpool is to small 2. You have some problems with your disks, because DB2 can't cast out as quickly as new pages are stored into the pool [...]
21264 21 39_Re: Tablespaces without full image copy15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 12 Jul 2001 02:23:58 -0500434_- Maria
Try:
SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE T WHERE NOT EXISTS (SELECT 1 FROM SYSIBM.SYSCOPY C WHERE C.DBNAME = T.DBNAME AND C.TSNAME = T.NAME AND C.ICTYPE = 'F' )
================================================ 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.
21286 42 39_Re: Tablespaces without full image copy16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 12 Jul 2001 12:51:42 +0530699_iso-8859-1 Will this help ?
SELECT T1.DBNAME,T1.NAME FROM SYSIBM.SYSTABLESPACE T1 WHERE NOT EXISTS (SELECT 1 FROM SYSIBM.SYSCOPY T2 WHERE T2.DBNAME = T1.DBNAME AND T2.TSNAME = T1.NAME AND T2.ICTYPE = 'F')
Regards Sanjeev
> -----Original Message----- > From: Maria Graça Fernandes [SMTP:graca.fernandes@CGD.PT] > Sent: Thursday, July 12, 2001 12:04 PM > To: DB2-L@RYCI.COM > Subject: Tablespaces without full image copy > > Hello > I need to know, the tablespaces that don´t have a full image copy. > > TIA > Graça Fernandes > > ===============================================To change your subscription > options or to cancel your subscription visit the DB2-L webpage at > [...]
21329 178 39_Re: Tablespaces without full image copy0_24_Bruce.Williamson@PSIR.IE31_Thu, 12 Jul 2001 08:30:22 +0100711_iso-8859-1 Howzit Maria?
Assuming there haven't been any start force commands issued, you can look for all ts in copy pending state.
Otherwise select not exists from systablespace to syscopy and remember to account for partition level ic.
HTH
Cheers Bruce __________________________________________________
Bruce Williamson DB2 Database Administrator
perotsystems information resource(tm)
Computer Centre Cabinteely Dublin 18 Ireland
Bruce.Williamson@psir.ie
-----Original Message----- From: Maria Graça Fernandes [mailto:graca.fernandes@CGD.PT] Sent: 12 July 2001 07:34 To: DB2-L@RYCI.COM Subject: Tablespaces without full image copy [...]
21508 45 39_Re: Tablespaces without full image copy25_Sinha, Ranjay Kumar (CTS)25_SRanjay@CAL.COGNIZANT.COM31_Thu, 12 Jul 2001 13:06:23 +0530735_iso-8859-1 Maria, Query the catalog with
"Select TSNAME from sysibm.syscopy where ictype <> 'F' "
This will list all the tablespaces without full imagecopy.
HTH
Ranjay sinha
> -----Original Message----- > From: Maria Graça Fernandes [SMTP:graca.fernandes@CGD.PT] > Sent: Thursday, July 12, 2001 12:04 PM > To: DB2-L@RYCI.COM > Subject: Tablespaces without full image copy > > Hello > I need to know, the tablespaces that don´t have a full image copy. > > TIA > Graça Fernandes > > ===============================================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 [...]
21554 47 39_Re: Tablespaces without full image copy15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Thu, 12 Jul 2001 02:47:35 -0500348_iso-8859-1 If you really want to ask 'which tablespaces are non-recoverable', this is more complex than just not having a full image copy.
You must also check that there are no 'LOG NO' utilities after the last 'F' copy.
Also I think you can get cases where you have a full image copy but cannot use it because of a PiT recovery [...]
21602 73 29_AW: same table Insert problem12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 12 Jul 2001 09:48:20 +0200708_iso-8859-1 Rakesh,
SQLCODE -118 (SQLSTATE 42902)means that a table or view is illegaly named in both data modification clause (e.g. INSERT) and the FROM clause..
HTH.
With kind regards - mit freundlichen Grüssen, Georg H. Peter DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- [...]
21676 20 22_Re: S390 2.10 & DB2 V510_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 12 Jul 2001 10:01:21 +0200455_us-ascii Hi Doreen
Thanks for your reply. I needed this info as our S390 2.10 will be install in few days in production LPAR.
Thanks again and regards
Max Scarpa Absolutely useless DB2 sysprog
================================================ 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.
21697 94 39_Re: Tablespaces without full image copy0_18_mebert@AMADEUS.NET31_Thu, 12 Jul 2001 10:13:17 +0200360_iso-8859-1 Hi Graca,
I've already seen a few replies to your question - some insufficient, some simply wrong (the same question turned up some months ago; search the archives. But there was no complete solution there either).
There is no single query to give you this list, except in very simple cases. Things you have to take into account: [...]
21792 118 29_Re: same table Insert problem16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 12 Jul 2001 13:57:02 +0530408_iso-8859-1 Hi George,
Is this SQL correct ?
INSERT INTO TABLE1 (COL1, COL2, COL3, COL4,COL5) SELECT 'DB2-L', 1, COL3,COL4,COL5 FROM TABLE1 WHERE COL1 = 'RYCI' AND COL2 = 1;
Where COL1 and COL2 are columns of primary key. WHERE clause of subselect return only one row.
I have tried this with V6 and its working. Just need to cross check it because of the explanation of -118. [...]
21911 75 39_Re: Tablespaces without full image copy16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 12 Jul 2001 14:02:59 +0530648_iso-8859-1 I believe Dr. Michael and Andy are correct because they have given a wider picture. The question should be "usable" Full image copy and if not the answer should definitely because there is no use of "unusable" Full image copy.
Thanks to both for the valuable information.
Regards Sanjeev
> -----Original Message----- > From: Lankester, Andy [SMTP:Andy_Lankester@BMC.COM] > Sent: Thursday, July 12, 2001 1:18 PM > To: DB2-L@RYCI.COM > Subject: Re: Tablespaces without full image copy > > If you really want to ask 'which tablespaces are non-recoverable', this is > more complex than just not having a full image [...]
21987 113 21_Re: RACF/DB2 security16_Bednarz, Michael22_Michael.Bednarz@CA.COM31_Thu, 12 Jul 2001 09:29:31 +0100411_iso-8859-1 Hi Grace,
did you refresh the security enviroment for the user in the permit request? Or did the user logoff and logon? Did you recieve any racf related security violation messages? If yes wich RC's?
Michael Bednarz
-----Original Message----- From: Grace Chen [mailto:gchen@CUCENTRAL-AB.COM] Sent: Mittwoch, 11. Juli 2001 23:05 To: DB2-L@RYCI.COM Subject: RACF/DB2 security [...]
22101 61 24_R: SQL question (DB2 V6)16_Petteno' Massimo27_Petteno.Massimo@GENERALI.IT31_Thu, 12 Jul 2001 10:57:30 +0200205_- Thanx Terry,
I've found another way to select a subset (for example 10%) of rows from a table:
SELECT * FROM TAB1 WHERE MOD ( INT (RAND() * 100), 10) = 0
Regards, Max
22163 19 39_Re: Tablespaces without full image copy10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 12 Jul 2001 10:58:33 +0200417_us-ascii I think that
they are called 'fundamentals' of DB2 data management, as everyone knows. These infos are given in the basic DB2 course.
Regards Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
22183 21 39_Re: Tablespaces without full image copy10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 12 Jul 2001 11:03:30 +0200513_us-ascii Hi Sanjeev how is it ?
I believe that Maria knows this fundamentals even if (may be) not certified.
I think she simply asked for a query to detect tablespaces without an entry in SYSCOPY as you 've provided. That's all....
Regards Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
22205 24 39_Re: Tablespaces without full image copy16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 12 Jul 2001 14:50:09 +0530333_- You are correct Max !
Still i thought we should have mentioned the exceptional cases. If Maria doesn't have to do anything with recovery then query is sufficient but after mail from Dr. Michael, i thought what would someone do with information regarding Full image copy if it doesn't have to do anything with recovery. [...]
22230 18 25_Re: Java Stored Procedure14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Thu, 12 Jul 2001 04:35:12 -0500408_iso-8859-1 Actually...
I was listening to a CD of the First Phase on the way to work today, and heard the answer is definitely 42.
From Edward Vassie...
================================================ 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.
22249 26 39_Re: Tablespaces without full image copy10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 12 Jul 2001 11:49:59 +0200362_us-ascii Hi Sanjeev.
You're right.
But I think (again) that if someone is playing with image copies & SYSCOPY she/he knows why IC are
executed and what's is their use in DB2 data management & recovery, at least at a basic level (ie the situations
described in Dr Ebert's reply). Or at least I think this is the normal situation. [...]
22276 58 17_linux - off topic16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Thu, 12 Jul 2001 11:25:10 +0100538_us-ascii Hello list,
this is totally off-topic, but since it has been brought to my attention that the trailer to my signature may be considered offensive by a real Indian (Apache or otherwise) origin person with a sense of humour bypass, I think I shuld state the following:
I love Cat Stevens I am European I like Linux a lot, as opposed to the four-letter word starting with U I read Tex Willer comics I do not like Billy-boy My trailer is meant to be a compliment to Linux - and laterally to less stressful living. [...]
22335 81 21_Re: linux - off topic19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Thu, 12 Jul 2001 12:37:26 +0200430_iso-8859-1 Just my six pence worth. I see nothing insulting about you signature. You will have no PC moans from me. By the way I would like to think that I have a sense of humour :-)
Best wishes to all
Neil
-----Original Message----- From: Aurora Dell'Anno [mailto:Aurora_E_DellAnno@CANDLE.COM] Sent: Thursday, July 12, 2001 12:25 PM To: DB2-L@RYCI.COM Subject: linux - off topic [...]
22417 22 39_Re: Tablespaces without full image copy15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 12 Jul 2001 05:46:28 -0500340_- Michael
I'm very surprized with that:
> After a LOG YES operation, the IC will become invalid as well > (essentially LOG YES writes an IC to the log, a RECOVER TO CURRENT won't > use the IC any more) but the TS won't be in Copy pending, so an IC at > this point is only (strongly)recommended but not actually required. [...]
22440 35 22_Fast Log Apply Storage16_WOLFENDEN, Kevin26_Kevin.WOLFENDEN@SEMA.CO.UK31_Thu, 12 Jul 2001 11:40:32 +0100699_iso-8859-1 What value do people specify for the ZPARM LOGAPSTG ?
How did you arrive at that figure ?
Cheers
Kevin Wolfenden DB2 Database Group Sema Global Services
___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. [...]
22476 53 39_Re: Tablespaces without full image copy9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Thu, 12 Jul 2001 12:13:08 +0100414_ISO-8859-1 You can still recover to current but if the LOAD was a load replace with log yes, DB2 will process the logs to perform the recovery not the image copy.
-----Original Message----- From: Walter Janissen [mailto:walter.janissen@VICTORIA.DE] Sent: 12 July 2001 11:46 To: DB2-L@RYCI.COM Subject: Re: Tablespaces without full image copy
Michael
I'm very surprized with that: [...]
22530 46 39_Re: Tablespaces without full image copy0_18_mebert@AMADEUS.NET31_Thu, 12 Jul 2001 13:16:58 +0200571_us-ascii Max
I think that's somewhat unfair. Knowing what ICs are for, how to create and use them doesn't really help you in determining exactly which TSs require one. As I've tried to point out, there's a lot of factors involved; I consider it far from basic. I suspect most shops will simply IC everything according to a fixed schedule, plus create ICs at certain key points in their application processing. I also suspect that a good many shops with more than a few hundred TSs will have at least some they couldn't recover if they wanted to. It'd be fun, [...]
22577 50 39_Re: Tablespaces without full image copy0_18_mebert@AMADEUS.NET31_Thu, 12 Jul 2001 13:32:37 +0200462_us-ascii Hi Walter,
there's a misunderstanding. What I meant with "invalid" is, the IC will not be required/used for a recovery to current anymore after a LOG YES operation. DB2 will simply start reading the log from the RBA recorded in SYSCOPY and rebuild the TS from scratch, with the information in the log. Note this applies to REORG LOG YES and LOAD REPLACE LOG YES only. A LOAD RESUME LOG YES does not provide a point to start a recovery from. [...]
22628 60 27_What are TCB and SRB times?15_Piotr Tarnowski20_TarnowskiP@PROKOM.PL31_Thu, 12 Jul 2001 13:53:07 +0200478_us-ascii Halo Listers,
I am quite new in OS/390 (my domain is UNIX) and I do performance tuning using IBM's PM. In many reports there are TCB (Task Control Block) and SRB (Service Request Block) times.
DB2 PM Report Reference says (which means nothing to me): TCB TIME The accumulated job step time (TCB) for the address space. Derived from the DB2 field QWSAEJST. SRB TIME The accumulated SRB time for the address space. Derived from the DB2 field QWSASRBT. [...]
22689 196 14_Re: DDF thread11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Thu, 12 Jul 2001 08:03:06 -0400326_iso-8859-1 Add me to this list of DDF problems. I have 2 open sev2 on test system. I have seen the "DDF won't come down" (and it was broke) and the immediate crash of DB2. I am at V6 0104. All related to TCP/IP threads. Now they want traces on both sides (GTF of DB2 USR X'FB9' trace records and client side DDCS Trace ) [...]
22886 135 29_Re: same table Insert problem12_Rakesh Singh14_rasun@JUNO.COM31_Thu, 12 Jul 2001 05:19:00 -0700360_iso-8859-1 Hi sanjeev, My SQL is exactly the same and the select does return one row but when i try to execute the same query i get -118 and as the error message says it looks like a restriction or i am missing something. I guess it still a restriction in VER 5 . Can somebody else verify it or i missing some maintenance on this DB2 . please let me know [...]
23022 168 29_Re: same table Insert problem13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 12 Jul 2001 07:34:21 -0500356_iso-8859-1 It is a restriction. You cannot INSERT via a sub-select which references the same table in V5. V6 allows it for an INSERT (Not update/delete tho ) I am talking OS390.
-----Original Message----- From: Rakesh Singh [mailto:rasun@JUNO.COM] Sent: Thursday, July 12, 2001 7:19 AM To: DB2-L@RYCI.COM Subject: Re: same table Insert problem [...]
23191 25 32_Connecting Oracle and DB2 OS/39010_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Thu, 12 Jul 2001 07:24:26 -0500591_- Dear List
I know mentioning Oracle usually provokes some, lets say "negative" comments about rivals to DB2 ;-), but I'd like to ask how people connect their DB2 OS/390 systems to Oracle (I think the version I'm interested in is 8i), running on HP-UX and Sun Solaris. We would need to be able to perform updates to both databases (and possibly SQL Server as well) from programs running on either of the two systems. Looking at the IBM website, it appears that DataJoiner is their offering. I've been told that the Oracle product (Oracle Gateway for DB2?) only makes connections [...]
23217 19 23_Re: LPL status question11_Ruth Sutlic24_ruth.sutlic@DILLARDS.COM31_Thu, 12 Jul 2001 07:25:59 -0500262_- I have seen the LPL status when we had a job running at the time our db2 region came down. We had our ZPARM setup for DEFER (?). This way, when our DB2 came up, we would get called. It gave us an opportunity to check things out. We were not data sharing. [...]
23237 141 14_Re: DDF thread18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 12 Jul 2001 09:06:01 -0400380_iso-8859-1 Tim: We did try this. I had our web folks stop the application process on the server. It killed all the associated threads for this application that were running EXCEPT for this one. That was really strange. The thread just will not go away. Its like the 'thread-from-hell'. (pardon my french). So now we're just gonna wait for a recycle of our production system. [...]
23379 43 21_Re: RACF/DB2 security13_Juan Mautalen22_jmautalen@ANSES.GOV.AR31_Thu, 12 Jul 2001 10:18:00 -0300552_iso-8859-1 Grace: For profiles in RACF classes DB2-related, READ is allways enough authority to access the ressource. UPDATE or CONTROL authorities will give the same as READ. But be careful with ALTER!! Of course, having ALTER also allows the access to the ressource, but if the profile is DISCRETE, users with ALTER access are able to perform profile administration (except changing the profile's OWNER). For instance, a user with access ALTER over a discrete profile can PERMIT others users to access the resource, and even delete the profile. [...]
23423 37 39_Re: Tablespaces without full image copy10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 12 Jul 2001 15:22:13 +0200335_us-ascii Hi Dr. Ebert
I agree that there are many factors to consider but I'm sure that most DB2 DBA/sysprogs know them, but most of these factors (my opinion as I learned them in some basic DB2 courses) are 'fundamentals' in DB2 data management using DB2 log one-way time line and well explained in IBM & non-IBM courses. [...]
23461 84 39_Re: Tablespaces without full image copy13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Thu, 12 Jul 2001 06:36:46 -0700410_- Wow! This generates interest.
Now for one more 'it depends':
A "full" image may be applied to only one partition of a partitioned tablespace. You need either a
DSNUM = 0
or a complete set
from 1 to (SELECT PARTITIONS FROM SYSIBM.SYSTABLESPACE WHERE .....)
before you have a really FULL image copy.
If you think this would never be an issue? guess again. [...]
23546 151 21_Re: RACF/DB2 security10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Thu, 12 Jul 2001 07:36:06 -0600335_iso-8859-1 Hi Michael, We did refresh security environment and the user did logoff and logon again. No RACF related security violation message. However, the user was able to select system catalog table through SPUFI after I permitted him as a SYSADM. Do you think I missing anything in RACF for protecting the DB2 commands? Grace [...]
23698 49 14_Re: DDF thread9_Colin Fay13_cfay2@CSC.COM31_Thu, 12 Jul 2001 09:41:04 -0400519_us-ascii Hi,
Meanwhile ....
I would try this workaround I got from Linda Billings (archives Wed, 20 Dec 2000) when I was having DDF hanging under early version OS/390 v 5 and Db2Connect v 7. This was a 2-tier situation but it might work for you also:
"Stopping DDF using VTAM commands: Another way to force DDF to stop is to issue the VTAM VARY NET,INACT command. This command makes VTAM unavailable and terminates DDF. VTAM forces the completion of any outstanding VTAM requests immediately. [...]
23748 53 21_Re: RACF/DB2 security10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Thu, 12 Jul 2001 07:38:46 -0600714_iso-8859-1 Thanks Juan! This is really helpful.
Grace
-----Original Message----- From: Juan Mautalen [mailto:jmautalen@ANSES.GOV.AR] Sent: Thursday, July 12, 2001 7:18 AM To: DB2-L@RYCI.COM Subject: Re: RACF/DB2 security
Grace: For profiles in RACF classes DB2-related, READ is allways enough authority to access the ressource. UPDATE or CONTROL authorities will give the same as READ. But be careful with ALTER!! Of course, having ALTER also allows the access to the ressource, but if the profile is DISCRETE, users with ALTER access are able to perform profile administration (except changing the profile's OWNER). For instance, a user with access ALTER over a discrete profile [...]
23802 189 14_Re: DDF thread12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 12 Jul 2001 06:49:43 -0700561_us-ascii If it doesn't end when you bounce the app server, then you can bet that this is a DDF mainframe bug. (Something about being in "must commit" status comes to mind). I would think that IBM could solve this with a dump or two, and it appears that several other folks have already sent some. Hopefully these threads aren't holding any resources anyone else needs and it will only be MINIMALLY intrusive until you can take an outage. Most of my problems were coming from an MTS (microsoft trans server) app. Good luck, and please post the fix when one [...]
23992 72 26_Re: Fast Log Apply Storage23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 12 Jul 2001 14:52:39 +0100426_ISO-8859-1 for various reasons we have this set to 0. Which means db2 will only use 10mb of "fast log apply" storage at restart time.
We will, however, be setting this value in the not to distant future back to a value of 100Mb. We have 6 gig of storage for each of our four db2 members (total 24 gig) and are fairly comfortable with giving this amount of storage away at the event of an unplanned db2 restart ... [...]
24065 159 39_Re: Need help on SQL Performance - ASAP0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 12 Jul 2001 09:01:28 -0500403_us-ascii Reading this, another alternative has come to mind. Hard code the most common versions of the generated SQL, and use the program logic to pick the hardcoded SQL that matches the options, and if one is not found then it generates a dynamic SQL. This way you can bind and explain the SQL so that you can do some optimization. Eliminating the dynamic prepares should also help response time. [...]
24225 84 39_Re: Tablespaces without full image copy14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 12 Jul 2001 15:11:19 +0100601_iso-8859-1 I've been resisting this, but it's no good.
It's been DAYS since I plugged a product...
One of the little known features of CA Log Analyzer is that it can produce a report of all tablespaces that have not been image copied in the last "n" days. In addition to the obvious cross-checking between SYSTABLEPART and SYSCOPY, it also looks for whether the image copies are still cataloged in the ICF catalog (nasty if your image copy that DB2 still has in SYSCOPY has been scratched by your tape management system.....) AND checks whether all the intervening archive logs are [...]
24310 25 38_Application-level list server for db2?12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 12 Jul 2001 07:55:23 -0700456_us-ascii I'm aware of the db2eug list (I like this one better), but a collegue of mine asked if there was a list that was more application-oriented than this one. He's coding in C++. Other reference materials other than lists or the IBM site/doc would be appreciated. Any suggestions?
Tim
__________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ [...]
24336 31 55_Powerbuilder/DB2 Connect - Thread Resource Usage - ASAP16_Michael McKinney16_mmckinne@CSC.COM31_Thu, 12 Jul 2001 10:46:54 -0400326_us-ascii All,
We are running DB2 v6 and we are making use of Powerbuilder 7.0 as a frontend tool and DB2 Connect for middleware. I should add that we, over the last 6 months, have been actively building our datacenter from the ground up. We still have quite a bit of software installation and configuration to do. [...]
24368 21 38_Utility Benchmarks between IBM and BMC11_Randy Scott19_Randy_Scott@VFC.COM31_Thu, 12 Jul 2001 11:16:45 -0400469_us-ascii Hi,
Has anyone recently done any benchmarking of imagecopies and reorgs between IBM and BMC utilities? We are DB2 V6 currently, but would like to hear about V7 also.
Thanks,
Randy Scott VF Services
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
24390 54 36_Re: Connecting Oracle and DB2 OS/39011_Bikash Paul19_bikash_db@YAHOO.COM31_Thu, 12 Jul 2001 08:17:23 -0700567_us-ascii Hi, How about using ODBC/JDBC for connecting to both DB2 and ORACLE ??
Regards, Bikash --- Steve Lamb wrote: > Dear List > > I know mentioning Oracle usually provokes some, lets say "negative" > comments about rivals to DB2 ;-), but I'd like to ask how people > connect > their DB2 OS/390 systems to Oracle (I think the version I'm > interested in > is 8i), running on HP-UX and Sun Solaris. We would need to be able > to > perform updates to both databases (and possibly SQL Server as well) > from > programs running [...]
24445 54 42_Re: Application-level list server for db2?12_Mark Granger22_the_grange@MBOX.COM.AU31_Thu, 12 Jul 2001 10:19:28 -0500459_us-ascii For the actual SQL component this is probably the best list I've seen, but if you want some other list to try go to http://www.lsoft.com/lists/list_q.html and search for C++ (or whatever). There are a few lists there. It provides all the info for subscribing, etc.
Mark Granger Independent Systems Integrators P/L Senior Technical Specialist - 2BDB2 Email: mgranger@isi.com.au Phone: +61 0416-012-262 (Australia) OR +1 617-306-7794 (USA) [...]
24500 47 36_Re: Connecting Oracle and DB2 OS/39021_Powers, Carol A - CNF20_Powers.Carol@CNF.COM31_Thu, 12 Jul 2001 08:25:13 -0700536_- We have Oracle running on Solaris and DB2 6.1 on OS/390. We use Oracle's Pro*COBOL (precompiler) to allow mainframe programs to access Oracle. The only dowside is that you can't access Oracle in the same program as DB2 (which precompile would go first and which EXEC SQLs would it process?), so you have to put one or the other in a called program. We also use the Oracle Transparent Gateway for DB2, but, as you say, this is providing access to the DB2 data from the Sun Oracle side as if it were a distributed Oracle database. [...]
24548 103 39_Re: Tablespaces without full image copy9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Thu, 12 Jul 2001 16:28:36 +0100502_iso-8859-1 Phil,
Won't a REPORT RECOVERY CURRENT give you the latest SYSCOPY copy.
Chris
"Grainger, Phil" To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Tablespaces without full Sent by: DB2 image copy Data Base Discussion List
12/07/01 15:11 Please respond to DB2 Data Base Discussion List
I've been resisting this, but it's no good. [...]
24652 20 52_Re: calling stored procedures using Microsoft Access12_Jason Hughes20_jason.hughes@TRW.COM31_Thu, 12 Jul 2001 10:42:56 -0500489_- Vince, Yes it is possible to call a DB2 stored procedure, via DB2 Connect, on the mainframe from Access. (Provided the DDF portion of DB2 has been setup and that is another topic within itself.) Several people on this list have done this, myself included. You should be able to call a SP from Excel but I never have tried. I'm sorry for being brief but I have an "enjoyable" meeting to attend to in a few minutes. Search the archives and you should find many threads on this topic. [...]
24673 13 29_Re: same table Insert problem9_Jim Ruddy18_jaruddy@US.IBM.COM31_Thu, 12 Jul 2001 10:46:30 -0500350_- V7 will allow self-referencing UPDATE/DELETE as well.
Jim Ruddy DB2 for z/OS and OS/390 Development
================================================ 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.
24687 42 19_DB2/Siebe Questionl14_Scott Trometer22_scott.trometer@RCI.COM31_Thu, 12 Jul 2001 11:57:20 -0500305_iso-8859-1 Listers,
We are in the process of implementing a Siebel solution on Unix w/ DB2. We have another DB2 system (V6) that resides on Os/390. I was asked by one of the developers what's the easiest way to pull in and/or update data on the Os/390 box from the Siebel app. Any thoughts??? [...]
24730 25 26_Automatic Increment Column12_Walker, Rick18_RWalker@SFBCIC.COM31_Thu, 12 Jul 2001 12:43:46 -0500406_iso-8859-1 Dear List,
I have a table that has a primary key column of Client Number. I would like to have all newly inserted rows to autmatically be populated with the maximum Client Number + 1. Does anyone out there know if there is a way to do this?
Thanks,
Rick Walker Database Administrator Mississippi Farm Bureau (601)977-4287 rwalker@sfbcic.com [...]
24756 59 59_Re: Powerbuilder/DB2 Connect - Thread Resource Usage - ASAP19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 12 Jul 2001 12:54:32 -0500617_iso-8859-1 Hi Mike, check out the Resource Limit Facility of DB2 for OS390 . . .
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 [...]
24816 56 30_Re: Automatic Increment Column16_Blumenthal, Gary21_GBlument@UNCH.UNC.EDU31_Thu, 12 Jul 2001 14:08:43 -0400347_iso-8859-1 Rick,
I'm kind of new to DB2, but recently discovered that Version 6 has IDENTITIES which are the same as IDENTITIES in Sybase or SQL Server. When creating the table, the DDL looks similar to the following:
CREATE TABLE TABLEFOO (PKID INTEGER GENERATED ALWAYS AS IDENTITY, FIELD1 CHAR(6) NOT NULL WITH DEFAULT, . . . [...]
24873 53 30_Re: Automatic Increment Column19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 12 Jul 2001 13:12:38 -0500611_iso-8859-1 Rick, check out IDENTITY columns . . .
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." [...]
24927 87 30_Re: Automatic Increment Column22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Thu, 12 Jul 2001 13:28:54 -0500591_- What Platform are you on? If non OS/390, try the following....not sure if its available on OS/390....
HTH
Venkatesh
DB Administrator Corporate Systems Amarillo, Texas Ph: 806-337-3374 vmokshagun@csedge.com
Identity Column Support
DB2 now allows you to generate a unique numeric value for each row in a table. For example, an identity column can be used to generate unique primary key values. You can also port applications that use identity columns from other RDBMS vendors to DB2. See the Administration Guide: Implementation for more information. [...]
25015 212 30_Re: Automatic Increment Column16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Thu, 12 Jul 2001 19:32:13 +0100499_iso-8859-1 Correct that IDENTITY columns will take care of the INCREMENTS. However - if you dont want to have "holes" in the generated keys, then IDENTITY columns cannot help you. There is no way you can guarantee this. Also - when DB2 is stopped, the IDENTITY number already in the cache are gone. Another issue - in a datasharing environment each MEMBER will have its own numbers generated, so you can end up with one members numbers not being used at all - again meaning you will get holes. [...]
25228 37 51_Urgent - DB2 Connect usage with Transaction manager22_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM31_Thu, 12 Jul 2001 11:48:33 -0700339_iso-8859-1 Hello DB2 Gurus, I am trying to desperately find some information on when a Transaction manager (Like Microsoft MTS or Tuxedo) should be used with DB2 Connect (Enterprise Edition). We are moving from SYBASE direct Connect to DB2 Connect EE and I have been asked if for connection pooling , we should employ a Txn manager ? [...]
25266 118 30_Re: Automatic Increment Column12_Walker, Rick18_RWalker@SFBCIC.COM31_Thu, 12 Jul 2001 14:00:01 -0500607_iso-8859-1 My platform is OS/390.
Rick Walker Database Administrator Mississippi Farm Bureau (601)977-4287 rwalker@sfbcic.com
-----Original Message----- From: Venkatesh Mokshagundam [mailto:Vmokshagun@CSEDGE.COM] Sent: Thursday, July 12, 2001 1:29 PM To: DB2-L@RYCI.COM Subject: Re: Automatic Increment Column
What Platform are you on? If non OS/390, try the following....not sure if its available on OS/390....
HTH
Venkatesh
DB Administrator Corporate Systems Amarillo, Texas Ph: 806-337-3374 vmokshagun@csedge.com [...]
25385 85 30_Re: Automatic Increment Column19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 12 Jul 2001 14:03:24 -0500589_iso-8859-1 I would use GENERATED BY DEFAULT and a unique index on it -- makes LOADing possible given you find next number to start with . . .
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. [...]
25471 102 30_Re: Automatic Increment Column12_Walker, Rick18_RWalker@SFBCIC.COM31_Thu, 12 Jul 2001 14:05:43 -0500493_iso-8859-1 Thanks for your help. I don't think "holes" will be a problem. We are more interested in generating unique client ids as oppossed to sequential client ids.
Rick Walker Database Administrator Mississippi Farm Bureau (601)977-4287 rwalker@sfbcic.com
-----Original Message----- From: Rasmussen, Steen [mailto:Steen.Rasmussen@CA.COM] Sent: Thursday, July 12, 2001 1:32 PM To: DB2-L@RYCI.COM Subject: Re: Automatic Increment Column [...]
25574 78 21_DB2 connect SQL Query17_Petluri, Srinivas36_Srinivas.Petluri@CENDANTMOBILITY.COM31_Thu, 12 Jul 2001 14:58:31 -0400379_- Hi all,
Can you please help me out using the following Query with DB2 connect. It is giving problem
set :ClientId '4589'; select * from dbtcb01.NAN001TB where RA_Client_No= :ClientId;
Thanks & Regards, Sreeni
Srinivasa Rao Petluri, Cendant Mobility, 40, Apple ridge Road, Danbury, CT
Ph : (203)-205-8838 (W) (203)-791-0704 (R)
25653 27 20_BAD PLANS & PACKAGES18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Thu, 12 Jul 2001 15:11:48 -0400434_iso-8859-1 DB2 List;
We are DB2V5 on OS/390! We are currently "cleaning up" our SYSPLAN and SYSPACKAGE tables, and have dropped (after much analysis/research) all plans/packages where VALID = 'N' and OPERATIVE = 'N'. However, we are now faced with numerous situations in SYSPLAN where VALID = 'N' but OPERATIVE = 'Y'. Their last binddate was in July of 2001. I believe that these plans have no DBRMs associated with them. [...]
25681 155 15_Re: SQL problem15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Thu, 12 Jul 2001 15:12:29 -0400333_iso-8859-1 James,
I am yet to contact the company (Called Grandvu in California )which made this ODBC driver. My thinking is that for each -420, it is returning a row with all null values. Same thing is happening with Sum SQL also. I can see that I got -420 two time, one for each non numeric value in Platinum detector. [...]
25837 87 30_Re: Automatic Increment Column0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 12 Jul 2001 14:20:18 -0500478_iso-8859-1 Take a look in the archive for "Sequence", this topic has been discussed a couple of times in the last year. From those discussions, if I remember correctly (if I'm not, someone will correct me ) identity columns may not work as a "Client Number" because they are not persistent. If you delete some rows then unload/reload the table, the numbers get regenerated. You might want to consider using a stored procedure or trigger to generate the sequence number. [...]
25925 54 24_Re: BAD PLANS & PACKAGES12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 12 Jul 2001 15:32:51 -0400337_us-ascii Hi, in your V5 SDSNSAMP lib there should be a member called (DSNTESQ). This has a bunch of queries that may be helpful. they are all documented on what they do. I believe a few of them will do what you are wanting.
"Gaston, Raymond J." @RYCI.COM> on 07/12/2001 03:11:48 PM [...]
25980 69 21_Re: RACF/DB2 security12_Dallas Focht21_dallas.focht@PMIC.COM31_Thu, 12 Jul 2001 14:44:16 -0500631_us-ascii Check resource RACF CLASS DSNR, RESOURCE subsystem.BATCH and subsystem.SASS. The first allows connection to DB2 in batch mode and the second allows connection to DB2 through TSO.
Grace Chen wrote:
> We are working on the RACF/DB2 security now and we ran into a > problem:Even we permitted a user with SYSADM authority, he still isn't > able to enter DB2 command under TSO. However, he is able to enter the > DB2 command under SDSF. The RACF command we did is:PERMIT DBT1.SYSADM > CLASS(DSNADM) ID(userid) ACC(READ)I don't know if we missing > anything.Another related question is :What's the difference [...]
26050 59 28_Re: R: SQL question (DB2 V6)0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 12 Jul 2001 15:05:24 -0500319_iso-8859-1 Just out of curiosity, why did you include the MOD(). You get the same result without it.
ie for approx 10 % scan of table, in range 0 thru 9 , 0 occurs 10% of time SELECT * FROM tab1 WHERE INT(RAND() * 10) = 0;
for approx 25% scan of table SELECT * FROM tab1 WHERE INT(RAND() * 10) < 25; [...]
26110 29 31_Federated Database User Mapping9_Ed Lipson30_Ed_Lipson@LNOTES5.BANKOFNY.COM31_Thu, 12 Jul 2001 15:56:17 -0400570_us-ascii We are starting to use Federated Database support in UDB 7.2 to access DB2 390 and Sybase. Does anyone have any suggestions on best practices for managing the User Mapping tables? How do your audit departments see it? Security organization? Should there be one mapping per user for full attribution of user access, or should there be a 'server' ID everyone is mapped to (since the access to the nickname is locally managed by GRANTS)? The Server object (CREATE SERVER) has already been established with one centrally managed ID for all server definitions. [...]
26140 18 29_Converting CA Datacom to DB 29_Bob Crail15_r.crail@ATT.NET31_Thu, 12 Jul 2001 20:48:01 +0000136_- I am currently involved in with a project to migrate from DATACOM to DB2. Does any one have any insight they may want to share
26159 50 33_Re: Converting CA Datacom to DB 212_Mark Granger22_the_grange@MBOX.COM.AU31_Thu, 12 Jul 2001 16:24:17 -0500435_us-ascii Bob, I assume you are doing a a Native Source code conversion and not using a Transparency (because I haven't heard of you using our product). E-mail me offline with some questions, and I'll see what non- sensitive information I can supply.
Mark Granger Independent Systems Integrators P/L Senior Technical Specialist - 2BDB2 Email: mgranger@isi.com.au Phone: +61 0416-012-262 (Australia) OR +1 617-306-7794 (USA) [...]
26210 13 14_Re: DDF thread11_Mark Harmon17_mhinnyc@YAHOO.COM31_Thu, 12 Jul 2001 16:25:08 -0500364_- You might want to look into DB2 apar PQ47558. It has to do with canceling DDF VTAM threads causing DB2 to die.
MH
================================================ 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.
26224 15 38_Data Replication between multiple DBMS15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Thu, 12 Jul 2001 17:53:58 -0400351_- Can we replicate data using UDB 7.2 between this and DB2 OS/390 or SQLserver or Oracle?
Thanks..Sibi
================================================ 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.
26240 121 33_Re: Converting CA Datacom to DB 210_Shukla, JR18_JR.Shukla@BNSF.COM31_Thu, 12 Jul 2001 17:04:00 -0500346_iso-8859-1 Bob
I am not sure what you need to know but I will be happy to share my experience with it. With another company, I actually designed and developed a software product to automate the mapping of meta data to DB2 as well as the conversion of the native source code to make sql calls to DB2. You may call me or send an email. [...]
26362 26 23_verison 6 adn getpages.12_Victor Kumar28_Victor_Kumar@DCF.STATE.FL.US31_Thu, 12 Jul 2001 18:12:09 -0400377_us-ascii I need help in a big way.
We went Db2 version 6 June 3 2001 and every thing was fine. July 5th the application staff promoted programs and did a bind of the plan. Since then we are getting large increase in the GET PAGES and our overall CPU time for the LPAR has gone up double. Our system is crawling like a snail. It is pointing towards the access path. [...]
26389 88 21_Re: linux - off topic15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Fri, 13 Jul 2001 09:35:34 +1000424_- Hi Aurora,
Just thought I'd say; chill. I've always taken your footer to be a gentle promotion of Linux and a gentle kick in the teeth for the Evil Empire aka the Gatester. Or is that ganster? Whatever. Don't know what your rather perverse affection for Cat Stevens has to do with anything, and I've absolutely no idea what Tex Willer comics are and who 'Billy-boy'... um, think I've just worked that one out. [...]
26478 120 39_Re: Need help on SQL Performance - ASAP13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Thu, 12 Jul 2001 19:18:54 -0500363_us-ascii Ron,
This is what the Static Profiler provides with DB2 Connect V7.1, the capability to capture and bind dynamic SQL to become static. Otherwise there is always the dynamic statement cache.
You also talk about the possibility of prompting the user for more info, and this capability is provided with predictive governing in OS/390 V6. [...]
26599 117 25_Re: DB2 connect SQL Query14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Thu, 12 Jul 2001 20:02:00 -0500336_iso-8859-1 It might be an idea to give some *details* about the problem if you are hoping to get some help. What are the errors/error messages, sql codes, etc. What environment are you using, version of software etc.
I can't help with connect, but others on the list may be able to assist if you give some more information. [...]
26717 19 14_Re: DDF thread11_Mark Harmon17_mhinnyc@YAHOO.COM31_Thu, 12 Jul 2001 19:58:53 -0500297_- The initial item that started this thread said: "When I issue the -cancel thread command it tells me the thread was previously cancelled."
Is it DB2 that says the thread was previously cancelled (it wasnt clear if it was Tmon or DB2)? If it is DB2, what is the error message number? [...]
26737 12 22_Re: DB2 Connect thread12_Brian Picard26_brian_picard@ALTAVISTA.COM31_Thu, 12 Jul 2001 20:43:28 -0500414_- You can set CMTSTAT to inactive which will make the thread to go inactive after every commit. Down side is an accounting rec being cut each time the thread goes inactive.
================================================ 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.
26750 105 30_Re: Automatic Increment Column14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Thu, 12 Jul 2001 20:53:58 -0500450_iso-8859-1 Rohn,
There are options when using IDENTITY columns to prevent the problem you mentioned and most of the other ones mentioned. GENERATED DEFAULT and using INSERT VALUES (DEFAULT...) solve the one you mentioned. Not CACHING in Data Sharing solve the sequencing issue, etc. For further info, see www.idug.org last issue of the IDUG Solutions Journal, for a column on all of these issues. If you need more info, send me an email. [...]
26856 60 27_R: R: SQL question (DB2 V6)16_Petteno' Massimo27_Petteno.Massimo@GENERALI.IT31_Fri, 13 Jul 2001 09:08:24 +0200145_- Thanks Rohn,
you right,
for approx 25% scan of table SELECT * FROM tab1 WHERE INT(RAND() * 100) < 25;
Regards. Max
26917 84 41_Level ID error when creating a Tablespace20_Robert Gillespie (P)21_GillesRP@TELKOM.CO.ZA31_Fri, 13 Jul 2001 09:55:26 +0200553_iso-8859-1 Hi all
DB2 UDB for OS/390 OS/390 2.7
I have a interesting problem here. In our development Subsystem I dropped a table space and recreated it with 9 partitions as I had to load a large amount of data for the programmers to test. After the tests I dropped the partition table space to recreated the original table space and I got a level ID error. Now I cannot create any table space in that database but can create table spaces in other databases in the same Subsystem. Here is the SQL I used to create the table space and [...]
27002 88 24_Re: BAD PLANS & PACKAGES16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 13 Jul 2001 13:11:07 +0530409_- If i am not sure for DB2 every plan has a DBRM associated with them. We might have the DBRM deleted from our dataset but for that DB2 may not be able to keep the records. SYSIBM.SYSDBRM and SYSPLAN are consistent, that is what DB2 need to think about. The OPERATIVE -= Y plans can still be rebound but not bound if the DBRM is not existing. I feel, It might be a difficult job to find it out via. SQL. [...]
27091 59 27_Re: verison 6 adn getpages.10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 13 Jul 2001 18:38:08 +1000334_us-ascii Victor,
When we went to v6, we found that a couple of our Left Outer Joins had got converted to Merge Scan Joins by the optimiser and the resource utilisation just shot up!!! And it was a stored procedure as well. Took us quite a while to find the culprit and bring it to book. And yes, the getpages had shot up. [...]
27151 16 45_Re: Level ID error when creating a Tablespace10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 13 Jul 2001 10:41:23 +0200402_us-ascii No datasharing ? Can you redefine the partitioned tablespace you dropped ? Are you shure that VSAM linear were not migrated ?
Regards MAx Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
27168 21 27_Re: verison 6 adn getpages.10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 13 Jul 2001 11:17:57 +0200545_us-ascii Hi Victor...just an information as we are planning to move to V6 few weeks after we'll install S390 2.10 in our prod LPAR.
Did you rebind again all plans/packages after V6 migration or id that changes in access path occurred in some other
way ?
Thanks in advance 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.
27190 38 45_Re: Level ID error when creating a Tablespace20_Robert Gillespie (P)21_GillesRP@TELKOM.CO.ZA31_Fri, 13 Jul 2001 11:19:02 +0200434_iso-8859-1 Hi
No datasharing. I cannot create any tablespace in the database
Robert Gillespie DBA
-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: 13 July 2001 10:41 To: DB2-L@RYCI.COM Subject: Re: Level ID error when creating a Tablespace
No datasharing ? Can you redefine the partitioned tablespace you dropped ? Are you shure that VSAM linear were not migrated ? [...]
27229 101 31_Row Archive Manager - DB2 OS39012_Aedan Molony20_Aedan.Molony@PSIR.IE31_Fri, 13 Jul 2001 10:29:21 +0100750_iso-8859-1 Hi Listers...
Can anyone please provide information on their experience or knowledge of IBM's DB2 Row Archive Manager (RAM)?
Also are there better/alternative products or home brew techniques?
We're DB2 V6 on OS390 2.9.
TIA
Aedan
******************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately at MailManager@psir.ie and delete this E-mail from your system. Thank you. It is possible for data transmitted by email to be deliberately or accidentally corrupted [...]
27331 36 49_Loading probelm with conversion with load utility9_john king24_john_king@REDIFFMAIL.COM31_Fri, 13 Jul 2001 09:33:42 -0000305_- Hi Can any one tell me about the difficulties I m facing while loading into table. The DESCRIPTION is a column in the table and it is having Japanese characters in it. I m using db2 v7 which supports Unicode. But it gives me error like this which I m describing below. I m waiting for your inputs. [...]
27368 16 45_Re: Level ID error when creating a Tablespace10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 13 Jul 2001 11:41:37 +0200390_us-ascii Did you stopped the database since the tablespace was dropped ? Can you stop it with Sto DB(xxxyyy) spacenam(*) ?
Regards Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
27385 100 27_Re: verison 6 adn getpages.12_Victor Kumar28_Victor_Kumar@DCF.STATE.FL.US31_Fri, 13 Jul 2001 08:26:39 -0400387_us-ascii Kals, thanks for the reply, Can you give a time line how long it took for you to do this. We have identified the programs and are looking into. thanks
Victor Kumar 487-7058
teldb2kals cc: Sent by: DB2 Subject: Re: verison 6 adn getpages. Data Base Discussion List [...]
27486 37 23_another Siebel question0_24_lightsey@ITS.STATE.MS.US31_Fri, 13 Jul 2001 07:48:15 -0500543_us-ascii We are in the process of installing a new, complete "portal" on AIX and among the components are DB2, Siebel, and WebSphere. On the DB2 servers, I went ahead and installed DB2 UDB 7.2 ( new install - start with the latest stuff, right ?). Now we find that the Siebel reps are aghast as their software "isn't certified to work with UDB 7.x" - until the new release comes out next month. Is anyone currently using Siebel with UDB v7.x anywhere ? If there truly is a problem, why ? I'd think that anything v6.1 could do, v7.2 could [...]
27524 79 59_Re: Powerbuilder/DB2 Connect - Thread Resource Usage - ASAP0_24_lightsey@ITS.STATE.MS.US31_Fri, 13 Jul 2001 08:10:28 -0500497_us-ascii We had much the same problem and ended up having to set the WLM goal for DDF threads to be the same as for low priority batch jobs and the goals for a selected few ddf users - known to be "batch" processes on an NT server - to be even lower than that ( though not so low as to be in the discretionary range). I still see the cpu for the db2dist enclaves at > 100%, but the rest of my users get sufficient cycles and the ddf users aren't suffering for response time either. I do wish [...]
27604 78 27_Re: another Siebel question11_Jeff Gibson29_jeff.w.gibson@MAIL.SPRINT.COM31_Fri, 13 Jul 2001 08:45:04 -0500395_ISO-8859-1 Bruce,
Here at Sprint North Supply, we have just implemented Siebel. Currently we are using Siebel version 6.0.1.37 on top of DB2 UDB 6.1 FP3 on Solaris. We really beat on Siebel to try to certify on 7.1, but they didn't budge. We are however using the 7.1 cliet without any problem (and yes, they Siebel complained). Our plan is to look at Siebel 2001 later in the year. [...]
27683 64 36_Re: Connecting Oracle and DB2 OS/39014_Cheung, Teresa19_cheungt@TOYSRUS.COM31_Fri, 13 Jul 2001 09:47:18 -0400654_iso-8859-1 Hi Carol,
Would you know any good websites about PRO*COBOL precompiler ? Thanks
-----Original Message----- From: Powers, Carol A - CNF [mailto:Powers.Carol@CNF.COM] Sent: Thursday, July 12, 2001 11:25 AM To: DB2-L@RYCI.COM Subject: Re: Connecting Oracle and DB2 OS/390
We have Oracle running on Solaris and DB2 6.1 on OS/390. We use Oracle's Pro*COBOL (precompiler) to allow mainframe programs to access Oracle. The only dowside is that you can't access Oracle in the same program as DB2 (which precompile would go first and which EXEC SQLs would it process?), so you have to put one or the other in a called [...]
27748 32 14_Re: DDF thread12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 13 Jul 2001 06:48:22 -0700584_us-ascii This APAR is for SNA threads and revolves around 1 phase and 2 phase connect issues with VTAM and SNA. For us using TCPIP, I doubt if it will be of much use. --- Mark Harmon wrote: > You might want to look into DB2 apar PQ47558. It has to do with > canceling > DDF VTAM threads causing DB2 to die. > > MH > > ================================================ > 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. [...]
27781 97 23_Re: DB2/Siebe Questionl15_Janardhan Ragam16_sragam@YAHOO.COM31_Fri, 13 Jul 2001 07:16:09 -0700586_us-ascii I am not sure if anybody replied to you...
The options that I came up with are:
- Stored Procedures - Replication
Per what I hear - Siebel apps cannot call stored procedures on s/390. They sure can issue dynamic sql calls from their application interface....so if you setup connectivity the developers can read or update s390 db2 data from the siebel interface. I am not sure if application can be coded within siebel to access data statically. This may require additional resources etc., and probably not a good idea unlees you have spare resources. [...]
27879 96 27_Re: another Siebel question16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Fri, 13 Jul 2001 15:23:43 +0100314_us-ascii Bruce,
on our internal systems we have just upgraded to Siebel 2000 (i.e., 6.3) and we are running DB2 v. 7.1... don't know if there were any complaints from Siebel, I'll ask some colleagues and let you know, no reported problems so far but hey, we're going into Production only this weekend. [...]
27976 34 22_Re: DB2 Connect thread10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Fri, 13 Jul 2001 08:30:40 -0600471_iso-8859-1 Hi Brian, I already set CMTSTAT to INACTIVE. However, it still always ACTIVE.
Grace
-----Original Message----- From: Brian Picard [mailto:brian_picard@ALTAVISTA.COM] Sent: Thursday, July 12, 2001 7:43 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect thread
You can set CMTSTAT to inactive which will make the thread to go inactive after every commit. Down side is an accounting rec being cut each time the thread goes inactive. [...]
28011 33 20_db2 personal edition13_Jimmy Willett13_JRLBW@AOL.COM29_Fri, 13 Jul 2001 10:36:25 EDT316_US-ASCII I have just downloaded and installed DB2 version 7.1 personal edition. I am using Windows 98. I have used Windows NT and am familiar with the admin authority of NT. When I tried to create the sample database, it said do not have authority. Where in Windows 98 do you set up the "admin" authority????? thanks
28045 128 23_Re: DB2/Siebe Questionl14_Scott Trometer22_scott.trometer@RCI.COM31_Fri, 13 Jul 2001 09:32:41 -0500411_iso-8859-1 Thanks. The person that asked me was told the same thing about SPs on s/390. I started to wonder, then, could I call an SP on the SIEBEL DB server(unix) to access my s/390 data via DDF instead? Or could I directly query the s/390 data just like any other DB2 to DB2 distributed app? (Is that what you were saying about the dynamic SQL calls...Not sure if it would be feasable to do statically?) [...]
28174 34 31_DBA Access to developers in DEV15_Janardhan Ragam16_sragam@YAHOO.COM31_Fri, 13 Jul 2001 07:37:43 -0700452_us-ascii Hello All,
I am not sure if this was discussed before...
Consider the following: OLAP environment, application in design phase, requires lot of table/view changes etc. in this phase, probably 30 to 40 changes on a daily basis.
Is it a good idea to grant admin privilege to developer and not deal with the changes in dev. Or do you think DBA should still be involved in the above scenario. What are the pros and cons? [...]
28209 134 31_Row Archive Manager - DB2 OS39016_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Fri, 13 Jul 2001 15:42:35 +0100337_us-ascii Aedan,
can't answer on the list since it's for another company, but when asked by clients about this type of utility, we have advised them to look at RAM and also at Active Archiving from Princeton Softech.
I am not really aware of any other products from other vendors, this does not mean there aren't any!! [...]
28344 64 45_Re: Level ID error when creating a Tablespace19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Fri, 13 Jul 2001 09:45:27 -0500625_iso-8859-1 quick guesses -- check VCAT of the STOGROUP, HDELETE
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." [...]
28409 103 59_Re: Powerbuilder/DB2 Connect - Thread Resource Usage - ASAP16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Fri, 13 Jul 2001 15:50:00 +0100346_us-ascii Mike,
apart from looking into your code, you mikght find it useful to set the Workload Manager goal to the same level, for your DDF threads and for your lower-priority batches, as well as looking into the priority/goal of your NT users originating from NT processes.
Avoid sending them to Discretionary range however! [...]
28513 116 42_Re: Application-level list server for db2?16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Fri, 13 Jul 2001 15:53:38 +0100540_us-ascii Just a quick reminder of the sites where you find lists of lists:
http://www.lsoft.com/lists/listref.html http://List-Universe.com/ http://www.nauticom.net/www/softwise/mfdisc.htm http://www.instantweb.com/l/loriaux/s390/mailing.html
(the first one is the same as Mark told you, actually)...
HTH.
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.
Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com [...]
28630 184 23_Re: DB2/Siebe Questionl15_Janardhan Ragam16_sragam@YAHOO.COM31_Fri, 13 Jul 2001 08:06:41 -0700441_us-ascii Again, I would think that if Siebel cannot call SP on s390 then Siebel cannot call SP on Unix. DB2 is DB2...remember s390 is another server(much bigger though) just like a unix server.
You should be able to query s390 db2 data just like any other unix db2 data. But you will have to setup connectivity - tcpip(requires db2 connect) or sna (require ddcs gateway). As you can see, each has its own requirements and setup. [...]
28815 76 53_Re: Loading probelm with conversion with load utility19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Fri, 13 Jul 2001 10:07:09 -0500636_iso-8859-1 some guesses -- target table have correct code page / datatype?
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." [...]
28892 76 35_Re: DBA Access to developers in DEV12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 13 Jul 2001 08:10:13 -0700588_us-ascii Janardhan, I suspect you'll get all sorts of answers to this question. This is one of those issues that lots of people feel strongly about in many ways. That said, here's my personal opinion for what its worth:
The DBA must be involved in the application. Don't give this to the applications staff and not be involved in the changes. Even though there are lots of changes per day, if the DBA is involved, he can review the changes, make suggestions as to better ways to do things, ensure that shop standards for naming conventions are followed, better understand the [...]
28969 64 35_Re: DBA Access to developers in DEV19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Fri, 13 Jul 2001 10:10:44 -0500305_iso-8859-1 I would hope that you, if you are the responsible DBA for the application, would be involved in every aspect related to the DB design. The design does appear to be somewhat a "helter skelter" affair wherein I feel the requirements should be nailed down better . . .
HTH, Rick Davis [...]
29034 57 35_Re: DBA Access to developers in DEV11_Robert Jans26_robert_jans@ALBERTSONS.COM31_Fri, 13 Jul 2001 09:15:08 -0600335_- Personally, if your getting 30 - 40 changes per day for a project, even in development, I'd be out there kicking so Data Architect/Project Team butt because they haven't done due diligence on the design. From a performance perspective, how good are your developers? Do they design databases every day? Probably not............. [...]
29092 16 38_Migration from DB2 for OS/390 V5 to V712_Bob LaCerais28_Bob_LaCerais@TAX.STATE.NY.US31_Fri, 13 Jul 2001 11:05:05 -0400442_us-ascii Has anyone gone directly from DB2 for OS/390 Version 5 to Version 7? If so, what were your experiences?
We're considering dong this. Does anyone know any good reasons why we shouldn't?
================================================ 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.
29109 84 24_Re: db2 personal edition14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Fri, 13 Jul 2001 08:18:53 -0700331_iso-8859-1 jIMMY, You have to create a userid and logon with that userid. Go to control panel, and create the user there. This will be the userid that DB2 will use and give you sysadm rights. HTH Phil
-----Original Message----- From: Jimmy Willett To: DB2-L@RYCI.COM Sent: 7/13/01 7:36 AM Subject: db2 personal edition [...]
29194 207 23_Re: DB2/Siebe Questionl14_Scott Trometer22_scott.trometer@RCI.COM31_Fri, 13 Jul 2001 10:14:18 -0500427_iso-8859-1 Makes sense. thanks for the assistance.
-----Original Message----- From: Janardhan Ragam [mailto:sragam@YAHOO.COM] Sent: Friday, July 13, 2001 10:07 AM To: DB2-L@RYCI.COM Subject: Re: DB2/Siebe Questionl
Again, I would think that if Siebel cannot call SP on s390 then Siebel cannot call SP on Unix. DB2 is DB2...remember s390 is another server(much bigger though) just like a unix server. [...]
29402 45 42_Re: Migration from DB2 for OS/390 V5 to V716_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 13 Jul 2001 11:31:21 -0400573_iso-8859-1 We did this. Near zero problems with the IBM stuff. Only IBM-related issue is that we had to change bind parameters on a handful (out of many thousands) of packages due to some undesirable access path changes. In some cases, going to REOPT(VARS) helped, in some cases changing REOPT(VARS) to NOREOPT(VARS) helped. Only caution: you will probably need to BIND or REBIND a lot more than the cover letters imply. We would up doing BIND or REBIND on everything. OEM vendors are another issue. Best of luck there. All it is PC to say at this time is that Candle [...]
29448 61 34_copy archive log from dasd to tape10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Fri, 13 Jul 2001 09:30:15 -0600339_iso-8859-1 We want our both archive logs go to dasd and then copy them to tape without using HSM migration. This is for disaster recovery. Does anyone know which utility I should use and how can I let DB2 know. Thanks! Grace Chen Technical Support Credit Union Central Alberta Ltd. Tel: (403) 258-5982 E-mail : gchen@cucentral-ab.com [...]
29510 146 45_Re: Level ID error when creating a Tablespace14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Fri, 13 Jul 2001 11:33:59 -0400369_iso-8859-1 Robert,
The fact that you have a levelid problem on a dropped tablespace and the fact that you are now unable to create ANY tablespaces in the database leads me to suspect that you may have an inconsistent DBD. You could try running the REPAIR DBD TEST (and be sure to use the TEST!!!!) to verify the consistency of your DBD. Here is the syntax: [...]
29657 27 24_Grants on plans question12_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Fri, 13 Jul 2001 11:35:06 -0400325_us-ascii OS/390 V5 I have a question regarding Grants. After I create a package, I am using GRANT BIND,EXECUTE ON PLAN p11770B TO PUBLIC; SELECT * FROM SYSIBM.SYSPLANAUTH WHERE NAME = 'p11770B' I see public access to the plan. but when I go back to Spufi and do a SELECT * FROM SYSIBM.SYSPLANAUTH WHERE NAME = 'p11770B' [...]
29685 137 52_FW: calling stored procedures using Microsoft Access10_Vinson Lee19_vlee@SDCCD.CC.CA.US31_Fri, 13 Jul 2001 08:41:14 -0700644_iso-8859-1 Don,
I was unable to reply to your inquiry directly because I got the following message:
Unknown recipient: don.cross/act-wjhtc@tc.faa.gov
Anyway, I'm posting the reply to the listserver.
Vince
-----Original Message----- From: Vinson Lee Sent: Friday, July 13, 2001 8:28 AM To: 'Don.Cross/ACT-WJHTC@tc.faa.gov' Subject: RE: calling stored procedures using Microsoft Access
Don,
I got one reply from Jason Hughes at TRW and am pasting it below. I also found some information by searching the DB2-L list archives using 'stored procedures msaccess' as search words. [...]
29823 176 24_Re: BAD PLANS & PACKAGES18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Fri, 13 Jul 2001 11:42:00 -0400374_ISO-8859-1 Sanjeev/Jeff, Thanks again for the feedback. We issued the following SQL to determine dbrm's that were associated with PLANs that were VALID='N' and OPERATIVE='Y'. Below is a partial sample output. We'll write the rexx to determine whether the DBRM member (i.e., NUXPLAN) exist in the corresponding PDSNAME dataset (i.e., if the dataset itself still exist). [...]
30000 92 38_Re: copy archive log from dasd to tape16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 13 Jul 2001 12:00:27 -0400632_iso-8859-1 What is wrong with MSM migration?
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Grace Chen [mailto:gchen@CUCENTRAL-AB.COM] Sent: Friday, July 13, 2001 11:30 AM To: DB2-L@RYCI.COM Subject: copy archive log from dasd to tape
We want our both archive logs go to dasd and then copy them to tape without using HSM migration. This is for disaster recovery. Does anyone know which utility I should use and how can I let DB2 know. Thanks! Grace Chen Technical Support Credit Union Central Alberta Ltd. Tel: (403) 258-5982 E-mail : gchen@cucentral-ab.com [...]
30093 92 35_Re: DBA Access to developers in DEV15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 13 Jul 2001 11:10:17 -0500447_iso-8859-1 Even though I am mainly a lowly systems programmer I have witnessed a project that shall remain nameless where the developers were making changes in a helter-skelter manner even right up to production implementation. Fortunately, we keep control over data base changes with a DBA. The DBA finally had to get management to whack them all with a really, really big stick because they were affecting the stability of the application. [...]
30186 79 24_Re: db2 personal edition8_Kim Lyon23_klyon@MSI-INSURANCE.COM31_Fri, 13 Jul 2001 11:10:58 -0500413_iso-8859-1 What user ID are you logged in with? I've noticed that for some reason DB2 Connect doesn't like the Administrator ID (too long) and it also doesn't like user IDs with dashes in them (such as sup-kl in my case). Something to check...
Jimmy Willett cc: Sent by: DB2 Subject: db2 personal edition Data Base Discussion List [...]
30266 80 24_Re: db2 personal edition21_Devineni, KishoreBabu29_KishoreBabu.Devineni@NIKE.COM31_Fri, 13 Jul 2001 09:39:42 -0700413_us-ascii Jimmy, Windows 98 does not have user administration available like Win NT or Win2K. Any user ID can be used for this purpose which means all the users are administrators. Simply log on with a user ID and that should work.
Kishore
-----Original Message----- From: Jimmy Willett [mailto:JRLBW@AOL.COM] Sent: Friday, July 13, 2001 7:36 AM To: DB2-L@RYCI.COM Subject: db2 personal edition [...]
30347 142 38_Re: copy archive log from dasd to tape14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Fri, 13 Jul 2001 12:48:00 -0400558_iso-8859-1 Grace,
I want to preface this by saying that this is a very high-level and extremely simplified answer to your question. If I understand you correctly, you are looking at copying your logs to tape to send them offsite as opposed to removing them from disk after copying them to tape. For this, you can just copy them to tape just as if they were any other sequential file using IEBGENER or DFDSS, or any other such utility, but make sure that you either use a different name for each log dataset or use a NEW,KEEP on your tape dataset [...]
30490 37 30_DB2 for OS/390 V6 CPU increase16_Alison Pelletier17_ap84098@YAHOO.COM31_Fri, 13 Jul 2001 09:49:02 -0700484_us-ascii Hello all,
We upgraded to V6 2 months ago. I've done analysis and find that there is approx. 5% CPU time increase. I've taken into account access path changes, parallelism program changes, etc. After putting aside these causes, I still see most programs with no changes, no parallelism and no access path changes have increased their average CPU consumption 5% - 7%. Some of the packages have been rebound, some not. It doesn't appear to make a difference there. [...]
30528 53 28_Re: Grants on plans question15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 13 Jul 2001 11:58:20 -0500527_iso-8859-1 Are you committing your grant?
Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services
"Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic." - someone named Taylor, www.bookoftruths.com
-----Original Message----- From: Amit Agarwal [mailto:amit_agarwal@STANDARDANDPOORS.COM] Sent: Friday, July 13, 2001 10:35 AM To: DB2-L@RYCI.COM Subject: Grants on plans question [...]
30582 33 50_Re: another Siebel question - Siebel's explanation0_24_lightsey@ITS.STATE.MS.US31_Fri, 13 Jul 2001 12:37:27 -0500598_us-ascii Siebel's rep for our account sent me the following explanation - thought I'd share it with the list for those in similar circumstances :
here is the technical reason why DB2 7.x will not support Siebel 2000.
The Siebel applications requires a Unique Row Generator which is something that was supported in DB2 v6.1. Siebel and IBM jointly built a User Defined Function (UDF) called NEXTSEQ for DB2 v6.x to generate these IDs. IBM did not put in DB2 v7.x the memory management features that this UDF needs to operate correctly. So the Siebel 2000.x UDF will not work with [...]
30616 107 38_Re: copy archive log from dasd to tape18_Michael L McCawley20_mike_dba@HOTMAIL.COM31_Fri, 13 Jul 2001 17:32:12 -0000581_- Grace -
I would use DFDSS to copy or backup the archive data to tape. This is the same utility used by HSM to move data.
If you reconsider using DFSMSHSM, there are many advantages to allowing HSM to manage your Archive logs backups, including automatic tape recycle and offsite backup.
A few things to adjust for HSM: 1) Migrate directly to tape (Migration level 2 or ML2). You probably don't want DB2 Archive log datasets dominating your ML1 dasd vols. 2) Resize your active logs so that each of resultant archive log datasets are 20% or less of tape [...]
30724 114 45_Re: Level ID error when creating a Tablespace18_Michael L McCawley20_mike_dba@HOTMAIL.COM31_Fri, 13 Jul 2001 17:46:44 -0000588_- Robert -
Just a guess, but it looks like you have a problem during the VSAM allocation of FDDD2.DSNDBC.WLKDB02.WLKT1001.I0001.A001. The level id error is indicating a null value, which implies the VSAM target doesn't exist. Perhaps there is a problem with the STOGROUP WLKSG00 volumes. I have seem similar errors when there is room on the volume, but the VTOC or VTOC index is full. DB2's interface to AMS doesn't seem to cope with this very gracefully. Try allocating the same size linear VSAM dataset on the volume outside of DB2 using IDCAMS to see what kind of error is [...]
30839 90 28_Re: Grants on plans question12_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Fri, 13 Jul 2001 13:50:11 -0400538_us-ascii Linda , your solution worked. However, the autocommit was set to 'on' in spufi. It seems that an explicit commit is still necessary. Never noticed that before.
Thank you Amit
"Billings, Linda" on 07/13/2001 12:58:20 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Amit Agarwal/FIS)
Subject: Re: Grants on plans question [...]
30930 107 28_Re: Grants on plans question15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 13 Jul 2001 13:15:05 -0500433_iso-8859-1 That's odd. I didn't know that either.
Linda
-----Original Message----- From: Amit Agarwal [mailto:amit_agarwal@STANDARDANDPOORS.COM] Sent: Friday, July 13, 2001 12:50 PM To: DB2-L@RYCI.COM Subject: Re: Grants on plans question
Linda , your solution worked. However, the autocommit was set to 'on' in spufi. It seems that an explicit commit is still necessary. Never noticed that before. [...]
31038 131 28_Re: Grants on plans question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 13 Jul 2001 14:31:03 -0400475_iso-8859-1 Maybe a maint issue? I just did similar to what Amit did (actually identical except for the plan name). It worked as expected. The auths were in place the second time I went into SPUFI. We are V7, maint 0105.
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Friday, July 13, 2001 2:15 PM To: DB2-L@RYCI.COM Subject: Re: Grants on plans question [...]
31170 159 34_Re: DB2 for OS/390 V6 CPU increase14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Fri, 13 Jul 2001 14:33:21 -0400586_iso-8859-1 Alison,
There is a definite increase in CPU for V6 parallelism. DB2 V6 has more opportunities to use parallelism (non-partitioned tablespaces using index or tablespace scan, outer joins, etc.), and parallelism does incur CPU to begin with. I went through this when I upgraded from V5 to V6 on a system where we had heavy parallelism. We did not change any of our access paths either, and I saw the same degree of parallelism in the applications, but we started seeing periodic CPU spikes and an overall increase in CPU of up to 15% in the worst case, although it [...]
31330 50 35_Re: DBA Access to developers in DEV13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 13 Jul 2001 16:30:49 -0400595_iso-8859-1 I agree with all the responses about having control over the development environment and the absolute need for the DBA and DA to be very involved in development and about the apparent lack of solid design if the app. in question is generating so many design change requests in a day. (reminds me of a Tech. Conf. presentation I attended a few years back where there was a heated discussion in the audience about object oriented design and performance considerations and quality. One of the young proponents of OO dismissed all those concerns by saying "It's no longer about that [...]
31381 26 21_Re: linux - off topic13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Fri, 13 Jul 2001 15:26:18 -0500417_- Your signature is OK but the people whom you are calling "real Indian" aren't Indian at all. Hey ! those guys are "real American". Sure Columbus didn't know any better but now we all know that India happens to be located on the other side of the globe (from America). BTW 500+ years are more than enough to correct a mistake. Have fun MOhammad ( BTW it's just a light hearted hair splitting and nothing more ) [...]
31408 27 49_Free 1/2 day DB2 Seminar in Chicago/San Francisco13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Fri, 13 Jul 2001 15:29:15 -0500644_- Please join Quest Software for a free half-day DB2 technical seminar coming to Chicago on Tuesday, July 17th at the Oakbrook Marriot and in San Francisco Thursday, July 19th at the SF Marriott.
The seminar focuses on the architectural differences of DB2 on the mainframe vs. DB2 running on Unix/NT. The presentation is geared towards individuals who support or anticipate supporting DB2 running on multiple platforms. The information presented will also be very helpful for non-DB2 shops that are considering the introduction of DB2 into their environment and would like to learn more about the requirements for managing this new [...]
31436 84 35_Re: DBA Access to developers in DEV15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 13 Jul 2001 15:52:47 -0500415_iso-8859-1 Good thoughts. I find that the people who work in the alternative platforms, not OS/390, tend not to have any procedures or methodologies in place for their design work, if there is any design. But I remember the days when newbie mainframe programmers, including me, would just jump in and start coding without any thought toward design let alone any methodologies. I have learned a lot since then. [...]
31521 47 21_Re: linux - off topic12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM31_Fri, 13 Jul 2001 13:58:59 -0700471_- The distinction is between what Eric Idle called "India" Indians and "Woo-Woo" Indians. I hope both types have a sense of humor. :-)
And please, let's not start a long thread on this! My excuse is that it's Friday afternoon, and things are a little slow.
Wayne Kline Ingram Micro
-----Original Message----- From: Mohammad Khan [mailto:mkkhan88@HOTMAIL.COM] Sent: Friday, July 13, 2001 1:26 PM To: DB2-L@RYCI.COM Subject: Re: linux - off topic [...]
31569 111 35_Re: DBA Access to developers in DEV16_Bhogale, Pushkar24_Bhogale.Pushkar@MBCO.COM31_Fri, 13 Jul 2001 16:04:49 -0500395_iso-8859-1 I think I can call myself to be a vivid example of this approach of keeping the control close to a DBA but also catering to the application peoples need on a timely manner. Shifting from an application side as recently as 6 months ago, my main responsibility lies with catering to the application people. I am lucky they don't change their table definitions 30 - 4- times a day. [...]
31681 24 17_DSNDB07 Sort Work0_19_RTurpen@WOODMEN.COM31_Fri, 13 Jul 2001 14:15:27 -0500320_us-ascii Does anyone know if there a performance advantage to using either A - Fewer but larger 4K tablespaces/data sets or B - Smaller but more 4K tablespaces/data sets in the DSNDB07 database? This is for a dedicated DB2 Version 5.1 subsystem that will be running multiple requests against two large tablespaces. [...]
31706 113 35_Re: DBA Access to developers in DEV0_22_Rohn.Solecki@MTS.MB.CA31_Fri, 13 Jul 2001 17:01:47 -0500557_us-ascii I am basically in the 'keep DB design and change control under DBA control' group. DBA group is where the DB logical and physical design experts are. We are the one's that are ultimately held responsible for good DB design and performance.
I guess like Dave and others, I'd like to get a better idea of what you mean by "...30-40 changes per day...". Is that say, a new column in a single table in 30-40 development DB's, or 30-40 totally different changes applied to tables in one (or more) DB(s) ? And just how long does this pace of [...]
31820 45 21_Re: DSNDB07 Sort Work20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Fri, 13 Jul 2001 18:03:36 EDT309_US-ASCII Ray, I have been told many years ago, it is better to have a many small work t/s spread over many disk. This was many years ago, maybe things have changed.
Regards, Ed. DB2 Disaster Off-site and On-site Recovery Automated and Simplified http://www.recoveryknowledge.com
31866 30 19_OS390 LOAD question14_Michele Payton18_paytonm@US.IBM.COM31_Fri, 13 Jul 2001 15:59:45 -0600519_us-ascii I am posting this question for a colleague:
Question:
I am writting a Java program running on OS390/OE (Open Edition) environment. The program requires load a huge amount of data into DB2 on OS390. The LOAD utility can do it but it is from JCL. The only way I think I can use is to use DSNUTILS stored procedure that will invoke LOAD utility. Is there anyone who has the example to show me how to call DSNUTILS for load utility? I need the example for those parameters required by DNSUTILS. [...]
31897 66 21_Re: DSNDB07 Sort Work24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 13 Jul 2001 15:22:14 -0700549_- Hi Ray!
Good question. It's come up a number of times in the past, and my feeling on this is that option B will generally give better performance. The datasets will be spread across more volumes which should reduce contention. The IBM recommendation is for at least as many datasets as the largest number of partitions, but not less than 5. I think that's in the administration manual. In addition, if you are using global temporary tables (GTT), you should also check out the 3rd sentence in the 5th paragraph on this IBM web page... [...]
31964 15 42_iI will return your note after I get back.15_Mark Hardenburg30_mark.hardenburg@PRUDENTIAL.COM31_Sat, 14 Jul 2001 01:01:31 -0400403_us-ascii I will be out of the office starting 07/13/2001 and will not return until 07/16/2001.
For DB2 help while I am out, contact Frank Yao at 716-8644.
================================================ 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.
31980 63 23_Re: DB2/Siebe Questionl17_Miguel de Andrade29_miguel.andrade@BTINTERNET.COM31_Sat, 14 Jul 2001 00:32:46 -0500593_- Hello Scott,
Siebel provides a mechanism for propagation in XML format and others, Workflow monitor is called, not sure if it is the least complicated, it depends on the skills in your shop ... just be carefull if you are thinking in updating the Siebel DB outside 'the Siebel application'. The other supported way of two way propagation is MQ Series again with Workflow. If you are implementing Siebel you would have someone from Siebel (TAM) assisting your company, ask him for more details, also, again, ensure that your implementation in inline with the Siebel architecture. [...]
32044 16 53_Charles D Wolf/Headquarters/USX is out of the office.14_Charles D Wolf14_CDWolf@USS.COM31_Sat, 14 Jul 2001 02:15:19 -0400464_us-ascii I will be out of the office starting 07/14/2001 and will not return until 07/24/2001.
I will respond to your message when I return. If you are having a question/problem with DB2, please contact Gary Norman.
================================================ 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.
32061 18 51_BVR/SYS/Nykredit =?iso-8859-1?q?tr=E6ffes_ikke=2E?=14_Bjarne V. Ravn15_bvr@NYKREDIT.DK31_Sat, 14 Jul 2001 09:02:08 +0200416_iso-8859-1 Jeg er ikke på kontoret fra 14-07-2001 og vender ikke tilbage før 12-08-2001.
Jeg har sommerferie indtil 13. august. Jeg besvarer din besked, når jeg vender tilbage. ===============================================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.
32080 85 24_Re: BAD PLANS & PACKAGES13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Sat, 14 Jul 2001 08:58:26 -0400439_iso-8859-1 Hello Ray, I suggest you might want to take a different approach.
First of all, I'd like to ensure you understand the situation where SYSPLAN/PACKAGE has VALID=N,OPERATIVE=Y. You probably do, but just to be sure:
VALID=N merely indicates something minor about the plan/package access path has changed and a rebind is necessary. In most cases where you also have OPERATIVE=Y, the auto-rebind will remedy this. [...]
32166 82 28_Re: Grants on plans question0_18_mebert@AMADEUS.NET31_Fri, 13 Jul 2001 20:59:00 +0100462_us-ascii Amit,
most likely you had some extra text at the bottom that caused an SQL error and thus a ROLLBACK.
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
From: Amit Agarwal @RYCI.COM on 13/07/2001 13:50 AST
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
32249 16 50_William D Trago/ISS/HQ/FHLMC is out of the office.10_Bill Trago33_William_D_Trago_Jr@FREDDIEMAC.COM31_Sat, 14 Jul 2001 17:28:32 -0400460_us-ascii I will be out of the office starting 07/12/2001 and will not return until 07/16/2001.
I will respond to your message when I return. If action needs to be taken immediately, Please contact Barbara Swart.
================================================ 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.