I need to write a query which brings a filed from 3 tables i.e if table A contains that filed it brings it from A
Others wise from B and than if it is not in table B than it [...]
556 96 33_Re: FULL OUTER JOIN with 3 tables16_Twins Ali&Hassan19_chathas@HOTMAIL.COM30_Sun, 9 Sep 2001 21:09:45 +0500
653 82 65_Re: Comparison between stored procedure written in java and cobol10_praveen_kj19_praveen_kj@INFY.COM30_Sun, 9 Sep 2001 22:54:31 +0530410_iso-8859-1 Hi Simon, can you refer me to some sites or pointers where comparison between java and cobol stored procedure (OS/390 platform,DB2) has been done.
regards Praveen
-----Original Message----- From: Simon George [mailto:simon_x_george@HOTMAIL.COM] Sent: Friday, September 07, 2001 7:58 PM To: DB2-L@RYCI.COM Subject: Re: Comparison between stored procedure written in java and cobol [...]
736 42 19_Delete trigger wows16_Blumenthal, Gary21_GBlument@UNCH.UNC.EDU30_Sun, 9 Sep 2001 14:19:13 -0400792_iso-8859-1 All,
I am trying to create a simple DELETE trigger that will record the deletion of an employee record. I am stumped and the docs are no help.
Here is the error that I am getting on the following syntax:
--------------------------- Command entered ---------------------------- CREATE TRIGGER TRDUSER AFTER DELETE ON tbluser REFERENCING old AS o FOR EACH ROW MODE DB2SQL INSERT INTO TUSERTRAN (cpk_userid, cpk_trans_action, cpk_timestamp, c_trans_source) VALUES (o.cpk_userid, 'DELEMP', current timestamp, 'TCWSUSER'); ------------------------------------------------------------------------ DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0969N There [...]
779 195 22_Re: CA(PLATINUM QUERY)16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Sun, 9 Sep 2001 21:27:36 +0100434_- Good Evening Derez,
Using CA/PLATINUM Fast Unload, the way to unload what you are requesting is :
Limit of 500000 rows - use parameter LIMIT 500000
If you want sampling : SAMPLE (3,600) unloads 3 rows, then skips 597 etc. etc.
Hope this helps best regards Steen Rasmussen Computer Associates Senior Consultant tel: +45 45 47 43 63 fax: +45 45 47 41 10 mobile: +45 22 10 22 64 Steen.rasmussen@ca.com [...]
975 223 33_Re: FULL OUTER JOIN with 3 tables13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Sun, 9 Sep 2001 16:34:54 -0500322_iso-8859-1 Twins?,
Yes, you can simply write the query as:
SELECT cols from A, B or C FROM A FULL OUTER JOIN B ON A.no = B.no FULL OUTER JOIN C ON C.no = COALESCE(A.no, B.no)
The ON must follow each JOIN, although there is one situation where it does not have to.....but I wont go into that now. [...]
1199 25 23_Re: Data Modelling tool11_John Kruger23_krugerj@ISP.STATE.IL.US30_Sun, 9 Sep 2001 17:55:27 -0500573_- Hi Carl, I've been using Erwin for the past three years and can't imagine working without it. For me, Erwin has proved to be a huge timesaver. I use Erwin for creating DB2 models, reverse engineering and as a general purpose auditing tool. I love when managers swear the testing and Production database structures are identical. It takes me only a few minutes using the Erwin Compare Utility to prove they're wrong (most cases). Like most tools Erwin has some quirks but nothing major. Make sure you have applied the latest patches from CA before giving up totally. [...]
1225 23 54_Paul Packham/ITS/POSG/POSTOFFICE is out of the office.12_Paul Packham26_paul.packham@CONSIGNIA.COM31_Mon, 10 Sep 2001 01:05:06 +0000580_us-ascii I will be out of the office from 08/09/2001 until 17/09/2001.
I will respond to your mail when I return, however please contact Mick Graley for DB2/OS/390 issues or Neil Miller for DB2 UDB/AIX issues if urgent.
Thanks Paul
This email and any attachments are confidential and intended for the addressee only. If you are not the named recipient, you must not use, disclose, reproduce, copy or distribute the contents of this communication. If you have received this in error, please contact the sender and then delete this email from your system. [...]
1249 133 22_Re: CA(PLATINUM QUERY)13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM30_Sun, 9 Sep 2001 21:28:49 -0500555_iso-8859-1 Thanks but what about by partition???
"Rasmussen, To: DB2-L@RYCI.COM Steen" cc:
Sent by: DB2 Data Base Discussion List
09/09/01 03:27 PM Please respond to DB2 Data Base Discussion List
Good Evening Derez,
Using CA/PLATINUM Fast Unload, the way to unload what you are requesting is :
Limit of 500000 rows - use parameter LIMIT 500000 [...]
1383 19 32_table loading using parallelism.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM30_Sun, 9 Sep 2001 23:27:39 -0500426_- Hi listers,
I am presently going thru a TOC(total cost of ownership) doc on DB2 where it says that load performance and index creation utilities in DB2 are SMP- enabled which is quite unlike its closest rival that requires the input load file to be split into multiple files to get any parallelism while loading. As a DB2 enthusiast I am much eager to know what is meant by being 'SMP-enabled' and how it works. [...]
1403 27 24_cannot start 2 instances7_ridhwan29_rizwan@CLOVERTECHNOLOGIES.COM31_Mon, 10 Sep 2001 11:06:44 +0530446_iso-8859-1 Hi, This is the error I get when i try to start a second instance (db2inst2) on the same machine. I am having 256 MB ram and running Red Hat Linux 7.1. I can connect to this second database when dn2inst1 is not up. I am not able to access the databases of two instances at the same time. ---------- SQL10003C There are not enough system resources to process the request. The request cannot be processed. SQLSTATE=57011 ---------- [...]
1431 27 5_Procs20_Subramaniam Baskaran27_subramaniam.baskaran@DB.COM31_Mon, 10 Sep 2001 11:45:17 +0530176_us-ascii Hello Listusers
What is a Validproc & Editproc? How do I define and use them?
Any pointers are welcome.
TIA Baskar
1459 89 32_AW: Procs (editproc & fieldproc)12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 10 Sep 2001 08:49:57 +0200437_iso-8859-1 Baskar,
both are so called exit routines and they are usually coded in Assembler (!). This code is then attached to a specific database object and is executed at a specific time, e.g. when the data is updated or inserted.
A validproc receives a row and returns a value indicating wether a data modification is valid and therefore should proceed. In other words: It simply assesses the validity of the data. [...]
1549 59 23_Re: Delete trigger wows12_Simon George26_simon_x_george@HOTMAIL.COM31_Mon, 10 Sep 2001 08:09:03 +0100
1609 90 65_Re: Comparison between stored procedure written in java and cobol12_Simon George26_simon_x_george@HOTMAIL.COM31_Mon, 10 Sep 2001 08:10:46 +0100
1700 63 36_Re: table loading using parallelism.16_Adrian Challinor29_adrian.challinor@OSIRIS.CO.UK31_Mon, 10 Sep 2001 08:31:50 +0100674_iso-8859-1 Rajendra
The phrase "smp-enabled" means being allowed to use multiple threads or processes concurrently on a multiple CPU processor. Most often, this phrase is normally applied to open systems (Unix and NT) rather than OS/390, where this sort of processing was built in the fundemental OS/390 processor.
Typically, with an SMP node, using DB2 Enterprise Extended Edition, you would have multiple database "nodes" running on a single SMP processor. Each node controls its own tablespaces and containers. Because DB2 is a "shared nothing" system, it can run concurrently against each node, thence each partition, without any IO contention or the [...]
1764 38 28_Re: cannot start 2 instances16_Adrian Challinor29_adrian.challinor@OSIRIS.CO.UK31_Mon, 10 Sep 2001 08:36:56 +0100388_iso-8859-1 Ridhwan
> SQL10003C There are not enough system resources to process the > request. The > request cannot be processed. SQLSTATE=57011
You have one of two problems (or possibly both problems!).
1) You need more physical memory on the Linux box. I would ideally want not less than 128 MB per instance.
2) You need more Message Queue Identifiers. [...]
1803 96 22_Re: CA(PLATINUM QUERY)16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Mon, 10 Sep 2001 08:38:22 +0100500_- Sorry Derez that I did not include this information, but here it comes:
PART [ALL|int1, int2,...]
So you can specify ONE partition, ALL partitions ot separate several partitions by commas.
Best regards Steen Rasmussen Computer Associates Denmark
> -----Original Message----- > From: Derez D. Lusk [SMTP:ddlusk@HOUSEHOLD.COM] > Sent: Monday, September 10, 2001 4:29 AM > To: DB2-L@RYCI.COM > Subject: Re: CA(PLATINUM QUERY) > > Thanks but what about by partition??? > > >
1900 38 32_Lock avoidance in RR isolation ?15_Piotr Tarnowski20_TarnowskiP@PROKOM.PL31_Mon, 10 Sep 2001 10:05:23 +0200348_us-ascii Hallo Listers,
After reading some documents I came to conclusion that lock avoidance for unqualified rows could be also possible in Repeateble Read isolation.
For unqualified (at stage1) rows locka avoidance is possible for CS and RS isollations. The process for qualifing rows in RR does not seam to be very different. [...]
1939 90 36_Re: Lock avoidance in RR isolation ?22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 10 Sep 2001 14:25:13 +0530308_- Piotr,
As per my opinion, lock avoidance will not be used with isolation level RR. I would prefer to wait for some experts comment on this. But concept of lock avoidance says that checks will be performed while the data is accessed but RR requires pages to be locked even after it is accessed. [...]
2030 24 18_migration approach22_Ramachandriah, Prakash27_prakash.r@BLR.HPSGLOBAL.COM31_Mon, 10 Sep 2001 14:42:20 +0500622_- Hi guys, Will any one give the solution for the MIGRATION APPROACH FOR UDB DB2 to SQL SERVER 2000.
regards prakash WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.----------------- HCL Perot [...]
2055 85 36_Re: Lock avoidance in RR isolation ?11_David Hayes28_Dave.Hayes@MORGANSTANLEY.COM31_Mon, 10 Sep 2001 10:32:53 +0100341_us-ascii Sanjeev/Piotr
I wouldn't wish this to be seen as an 'expert comment' but I believe under most circumstances lock avoidance will only occur with Isolation (CS) and Currentdata (NO). I think the exception to this is during RI constraint checking when lock avoidance can be used even if the package is bound as RR. Regards [...]
2141 239 17_Re: IDUG Seminars14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 10 Sep 2001 10:46:54 +0100584_iso-8859-1 Not sure I can fit the answer in less than 25 "lines", but here goes.....
Things I wish They Told Me Eight Years Ago (Part 6) - Bonnie Baker While this is the fifth in a series of seminars entitled "Things I Wish They'd Told Me 8 Years Ago", it continues the saga with all new ideas, new tips, and new techniques for improving program performance. Analogies, war stories, and examples are used to simplify difficult concepts so that the programmers can apply those concepts to program logic and SQL in order to improve performance. New features available in V5 [...]
2381 165 26_Re: IDUG Seminars - Part 214_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 10 Sep 2001 10:47:03 +0100670_iso-8859-1 Intimate Details: DB2 UDB EE & EEE Designs for Performance - Scott Hayes Never mind "it depends", those words won't be spoken here. This course will teach how to build DB2 UDB databases for maximum performance and availability, how to configure the configuration settings, strategies for memory and CPU optimization, techniques for speeding up I/O, and what and how to monitor and measure for most effective results, trend analysis, and capacity planning. Starting from the ground up, from database creation to SQL performance analysis, and every configuration parameter in between, this course will leave few performance stones unturned. Attendees will [...]
2547 60 44_Re: Trigger calling a cobol stored procedure10_teldb2kals22_teldb2kals@TELSTRA.COM31_Mon, 10 Sep 2001 20:19:25 +1000350_us-ascii Hi Bill,
U mention that the trigger "appears" to call the procedure. Cd u check up if it is the right proc being invoked ? U cd try having some debugging messages in ur proc code to see exactly what is happening, whether the proc with the correct schema is called, etc. Also check the SQLcode after the CALL PROC in the trigger. [...]
2608 83 72_DB2 v7.1 VSE - Please help, Urgent/really important question about reorg15_Filip Ruhdensjö25_filip.ruhdensjo@PULSEN.SE31_Mon, 10 Sep 2001 12:07:40 +0200543_iso-8859-1 Hi everyone,
I have a question about reorgs of rather large tables. If a table have about 10 000 000 rows located in a dbspace with 1 500 000 pages, active pages about 800 000. How can I do a reorg in a reasonable time?
We have done tests with a table with 1 500 000 rows, located in a dbspace with 1 700 000 pages, active pages 60 000. We used Database service utility (unload/reload). The results we got were about 15 minutes to unload and about 2 hours to reload. There were no activities in the server during [...]
2692 47 12_RR isolation18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Mon, 10 Sep 2001 16:11:53 +0500434_- List I need a clarification on the following which I have pasted below from Admin Guide. >>>snip begin ISOLATION(RR) Repeatable read: A row or page lock is held for all accessed rows, qualifying or not, at least until the next commit point. If the application process returns to the same page and reads the same row again, another application cannot have changed the rows nor have inserted any new qualifying rows. >>>snip end [...]
2740 192 109_Central PA DB2 Users Group - Sheryl Larsen, Sept 28th - $175 - DB2 for OS/390 V6/V7 Transition for Developers10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Mon, 10 Sep 2001 06:47:46 -0400326_iso-8859-1 Hi everyone! If you are interested in attending Sheryl Larsen's class on Sept 28th here in Central PA & have not already registered, please let me know. The price is $175 per person per class. Tks. Seeya
For more details & directions, see our Central PA DB2 Users Group website: http://www.db2parug.org [...]
2933 17 26_Re: IDUG Seminars - Part 210_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Sep 2001 12:15:06 +0200408_us-ascii Hi Phil
Thank you very much for IDUG seminars infos, I think I'll attend (at least) one of the (high quality) seminar you described.
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.
2951 34 36_Re: Lock avoidance in RR isolation ?10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Sep 2001 12:45:16 +0200476_us-ascii Hi all,
As far as I know in user TCB flow lock avoidance occurs for unqualified (stage -1) rows even if CURRENTDATA(YES) as the evaluation of CURRENTDATA value (as READ STABILITY or if the cursor is an update cursor) is performed later in the process (ie after 'does this row qualifies stage-1 predicate(s) Y/N? step). If CLSN/PUNC bit checks fail than a LOCK ('Conditional Lock') is taken on page/row BEFORE stage-1 evaluation even for unqualified rows. [...]
2986 105 16_Re: RR isolation22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 10 Sep 2001 16:51:41 +0530447_- Hi Nagaraj,
To keep is short and simple, i would say the pages/rows traversed in one go will be locked and re-read will be done on those ensuring that those are not changed. Insert is not allowed on the pages which are traversed/touched. Unqualifying rows doesn't mean that all the pages are locked. The pages are locked if it contains only one row and in between pages are also locked in RR. It depends which all pages are touched. [...]
3092 232 23_Re: Delete trigger wows16_Blumenthal, Gary21_GBlument@UNCH.UNC.EDU31_Mon, 10 Sep 2001 07:16:38 -0400373_iso-8859-1 I tried it with/ without the BEGIN ATOMIC - END but since I only have one command in the trigger it should not matter.
I think I'm tripping on a DB2 bug. I just dropped and tried to recreated a trigger with the with the DDL that I have archived (i.e. I know the syntax was good, it worked before) and am now getting the same error. Time to call IBM. [...]
3325 111 26_Re: IDUG Seminars - Part 214_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 10 Sep 2001 12:16:56 +0100440_iso-8859-1 As they are all at the same time, I'd be fascinated if you can be in more than one!!
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: 10 September 2001 11:15 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] IDUG Seminars - Part 2 [...]
3437 55 22_AW: migration approach12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 10 Sep 2001 12:30:46 +0200554_iso-8859-1 Prakash,
wouldn't it be better to migrate from SQL Server to DB2 UDB ?????????????????
With kind regards - mit freundlichen Grüssen, Georg(e) H. Peter -------------------------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Ramachandriah, Prakash [mailto:prakash.r@BLR.HPSGLOBAL.COM] Gesendet am: Montag, 10. September 2001 11:42 An: DB2-L@RYCI.COM Betreff: migration approach
Hi guys, Will any one give the solution for the MIGRATION APPROACH FOR UDB DB2 to SQL SERVER 2000. [...]
3493 22 26_Re: IDUG Seminars - Part 210_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Sep 2001 13:43:18 +0200351_us-ascii I'll apply the power of (CA) Dark Side of the Force multi CPU - I/O Parallellism (DSF-IO v. 69) applied to IDUG seminars.
It's a new stand-alone CA utility which runs on every platform in the univers and perform every thing you desire (ALMOST every thing).
Just kidding, I didn't realize they were all at the same time.... [...]
3516 91 36_Re: Lock avoidance in RR isolation ?22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 10 Sep 2001 17:36:57 +0530583_- Max,
First of all you can't be unqualified STAGE-3, because stage-3 highly qualified(programmatically) for non-qualified results, but very costly. . -:)). (Boonie Baker explained it).
I think you mentioned lock avoidance is not used with RR. Just a clarification.
To add more, What i have found is lock avoidance is used when application is using i) Read only / ambiguouos cursors ii) ISOLATION CS If CURRENT DATA(NO) is used then it is used for qualified and unqualified rows. If CURRENT DATA(YES) is used, it is for both qualified and unqualified rows. [...]
3608 118 16_Re: RR isolation18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Mon, 10 Sep 2001 17:28:59 +0500458_iso-8859-1 Sanjeev Thanks for your reply. How about inserts into a near or far page?. If the page where DB2 intends to insert the row in the first place, is locked then will DB2 not try to insert into a near or far page?. If it does, then the next time you open and read the cursor again will you not get a different result set (assuming that the inserted rows qualify). I am trying to understand the exact definition of repeatability in this context?. [...]
3727 110 96_Re: Procs (editproc & fieldproc)+ How to store password in the database in the encrypted format.10_praveen_kj19_praveen_kj@INFY.COM31_Mon, 10 Sep 2001 17:44:06 +0530350_iso-8859-1 Hi George,
In our project we have an functionality where we are required to store the password in the database in the encrypted form. I think at that place we can use this functionality of field proc.
Can you provide me some input on how to write field proc or some sample programme or some pointers regarding the same. [...]
3838 72 16_Re: RR isolation22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 10 Sep 2001 18:03:34 +0530532_- Nagaraj,
If i am not wrong you are trying to mention something like this:
At time T1, a program A starts reading the table and accessed few pages At time T2, a program B starts inserting the records and inserted into the page which is not yet traversed by A (out of scope for A now). At time T3, program B committed At time T4, program A is still reading and found the page (near or far) where data is inserted by B. If B has issued commit(locks released) then A will receive this data and it is quite logical. [...]
3911 114 16_Re: RR isolation18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Mon, 10 Sep 2001 17:54:05 +0500615_- Sanjeev Sorry for my previous mail. I understood it now. The key phrase is "another application" in the snippet which I overlooked.
Thanks
Nagaraj
> -----Original Message----- > From: S, Sanjeev (Cognizant) [SMTP:SSanjeev@CAL.COGNIZANT.COM] > Sent: Monday, September 10, 2001 4:52 PM > To: DB2-L@RYCI.COM > Subject: Re: RR isolation > > Hi Nagaraj, > > To keep is short and simple, i would say the pages/rows traversed in one > go > will be locked and re-read will be done on those ensuring that those are > not > changed. Insert is not allowed on the pages which are traversed/touched. [...]
4026 48 22_CBT Tape Contributions9_Sam Golob21_sbgolob@ATTGLOBAL.NET31_Mon, 10 Sep 2001 08:27:47 -0400586_us-ascii Hi Everybody,
In case anybody missed my previous posts, please do not use my old aptea.com email address to make contributions to the CBT Tape. That address is not valid anymore.
My two valid addresses are: sbgolob@attglobal.net and sbgolob@aol.com . Additionally, the CBT Tape web site, www.cbttape.org , contains contributor information, which we hope, should be accurate and up-to-date. Also, if you want to email either Sam Knutson or me, and you forgot our addresses, the www.cbttape.org CBT Tape web site contains links, so you can email either of us. [...]
4075 57 23_Re: Delete trigger wows16_Proctor, William25_william.proctor@TGSLC.ORG31_Mon, 10 Sep 2001 07:52:23 -0500474_iso-8859-1 What platform for you trying to create this trigger on and are you trying to use spufi or a batch job to create it?
-----Original Message----- From: Blumenthal, Gary [mailto:GBlument@UNCH.UNC.EDU] Sent: Sunday, September 09, 2001 1:19 PM To: DB2-L@RYCI.COM Subject: Delete trigger wows
All,
I am trying to create a simple DELETE trigger that will record the deletion of an employee record. I am stumped and the docs are no help. [...]
4133 78 44_Re: Trigger calling a cobol stored procedure16_Proctor, William25_william.proctor@TGSLC.ORG31_Mon, 10 Sep 2001 07:58:12 -0500462_iso-8859-1 I only have one stored procedure and I have replaced the call to the stored procedure with an sql statement to prove that the trigger was firing and executing the area with the call in it. We have tested the stored procedure separately and it works like a charm. What could I have setup wrong that causes it not to execute when the trigger calls it? Should it be compiled a certain way or could it have something to do with my plans or packages? [...]
4212 137 21_Odp: Re: RR isolation15_Piotr Tarnowski20_TarnowskiP@PROKOM.PL31_Mon, 10 Sep 2001 15:01:27 +0200622_iso-8859-2 Sandjeev, Nagaraj,
With RR you can open cursor, read all data, close it, open another cursor with the same criteria, read data and you should expect the same set of data.
According to my knowledge this is enforced either by tablespace/table lock or with so called EOF-lock. With tablespace/table lock there is no posibility to insert a new row in any page (neither near nor far) because whole TS is locked. With EOF-lock DB2 uses index to avoid tablespace/table lock. This requires that query (in RR isollation) has matching predicates for index. If so, EOF-lock ensures that neither new nor [...]
4350 203 16_Re: RR isolation22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 10 Sep 2001 18:57:09 +0530495_iso-8859-2 I am really afraid if non-qualifying rows are also not inserted(by other applications) on the pages not 'yet' used by the RR application. What is the difference then between using this isolation and LOCK TABLE in EXCLUSIVE mode for the whole program execution.
At the same time i can say, lock(other than intent) is not taken in advance to reading any rows/pages. It is taken as and when page is required to be read but are not released until commit/deallocate (with RR). [...]
4554 51 36_Re: Lock avoidance in RR isolation ?10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Sep 2001 15:20:34 +0200413_us-ascii Hi Sanjeev howizit ?
First I'm expensive and useless and, as I'm not certified nor golden, I'm not qualified. So expensive (costly+useless) + no certification + no optimization = stage-3 unqualified DB2 sysprog (according Bonnie Baker's theory :-)) ).
As regards CURRENTDATA(YES), from 'DB2 V3 Performance Topics' GG24-4284-00
6.1.2.1 Ambiguous Read Cursors or CURRENTDATA(YES) [...]
4606 55 22_Re: migration approach0_19_mike.holmans@BT.COM31_Mon, 10 Sep 2001 14:32:36 +0100748_iso-8859-1 Best way is to delete SQL Server 2000.
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
>>-----Original Message----- >>From: Ramachandriah, Prakash [mailto:prakash.r@BLR.HPSGLOBAL.COM] >>Sent: 10 September 2001 10:42 >>To: DB2-L@RYCI.COM >>Subject: [DB2-L] migration approach >> >> >>Hi guys, >> Will any one give the solution for the MIGRATION APPROACH >>FOR UDB DB2 to >>SQL SERVER 2000. >> >>regards >>prakash >>WARNING: The information in this message is confidential and >>may be legally >>privileged. It is intended solely for the addressee. Access >>to this message >>by [...]
4662 111 23_Re: Delete trigger wows16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Mon, 10 Sep 2001 09:24:35 -0400584_us-ascii Here is a trigger that I created that works on an os/390 system. I used DSNTIAD, and notice that I had to use a different delimeter for the sql inside of the trigger. The same kind of thing mut be done if using spufi.
//SYSTSIN DD * DSN S(DBD1) RUN PROGRAM(DSNTIAD) PLAN(DSNTIAD) PARM('SQLTERM(~)') /* //SYSIN DD * SET CURRENT SQLID = 'DB2TEST'~ CREATE TRIGGER GABLE011 AFTER INSERT ON CFC6847.TABLE01 REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN (N.MANAGER_ID <> ' ') BEGIN ATOMIC INSERT INTO CFC6847.TABLE02 VALUES(N.SALESMAN_ID,' ',0,'U',' ','01'); END~ [...]
4774 146 25_Re: Odp: Re: RR isolation18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Mon, 10 Sep 2001 20:03:37 +0530596_- Piotr,
You said.... ********** With tablespace/table lock there is no posibility to insert a new row in any page (neither near nor far) because whole TS is locked. **********
But that could be true if you mentioned LOCKSIZE TABLSPACE / LOCKSIZE TABLE which would adversely affect concurreny. Should a page / row lock be acquired then the tablespace / table lock would be in INTENT mode (IS,IX, SIX). Hence I feel that a RR cursor would not hamper insertions as long as the destination page(for insertion) does not lie in the range of the selection expression for the cursor. [...]
4921 14 44_Re: Trigger calling a cobol stored procedure12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 10 Sep 2001 09:34:05 -0500325_us-ascii Um, would you by chance be trying this with a "BEFORE" trigger?
Stg
================================================ 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.
4936 58 24_Left Outer Join Question13_Dana Maxfield23_DMaxfie@DOA.STATE.LA.US31_Mon, 10 Sep 2001 10:01:39 -0500420_iso-8859-1 Last May I asked a question about a left outer join problem. I wanted to thank everyone for their help, particularly Terry Percell, Linda Claussen and Bikash Paul. We applied the put level 0103 maintence to DB2 version 6 and that seemed to clear up the problem. Thanks again!
Dana Maxfield Office of Computing Services email: dmaxfie@doa.state.la.us phone: 225-219-6051
4995 60 16_Stuck with a SQL14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Mon, 10 Sep 2001 09:53:25 -0400583_iso-8859-1 Hi,
I am trying to create a view by joining 2 tables as below:
Table1:
MODE_ID MODE_DESC ======= ========== 1 INCLUDE 2 VIEW 3 SHOW 4 EDIT 0 ALL_MODES
Table2:
GROUP MODE_ID ===== ======== 90 1 91 4 93 0
I want to create a view which will join the above tables and show the GROUP and MODE_DESC. The join criteria is : 1. if Table2.MODE_ID = 1 or 2 or 3 or 4, the view should show the corresponding MODE_DESC from Table1 for the Group. 2. if Table2.MODE_ID = 0, the view should show all the MODE_DESC for modes [...]
5056 124 97_Re: Procs (editproc & fieldproc)+ How to store password i n the database in the encrypted format.14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Mon, 10 Sep 2001 08:08:22 -0700621_iso-8859-1 Praveen, These exits are discussed in an appendix of the DB2 admin guide that covers exits. However, because ANY select from the table will go throught the exit, these exits are a bad place to put password encrypt/decrypt. In my personal opinion, information of this type would be better handled through the external security system, not in DB2. The other option would be to leave the encryption/decryption in the application, and store the encrypted data in a CHARACTER FOR BIT DATA column. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
5181 40 25_Sub-select in ON clause??11_David Nance16_DWNance@FHSC.COM31_Mon, 10 Sep 2001 11:08:20 -0400305_US-ASCII I'm trying to find some documentation now, but would appreciate if anyone knows the answer. In left and right outer joins you are allowed to say col = literal in the on clause. I'm trying to use a col = (select max(col) from table2 where ...) and getting a -338(which is not helpful at all) [...]
5222 80 96_Re: Procs (editproc & fieldproc)+ How to store password i n the database in the encrypted format14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 10 Sep 2001 16:44:32 +0100338_iso-8859-1 Praveen,
The problem with Fieldprocs (and all the other "procs" for that matter) is that they are ALWAYS called when you access a particular column.
So, if you choose to use one to encrypt a password column, it WILL be encrypted on DASD but whenever you SELECT it, it will automatically be decrypted by DB2. [...]
5303 93 44_Re: Trigger calling a cobol stored procedure10_Shery Hepp17_schepp@SRPNET.COM31_Mon, 10 Sep 2001 08:51:05 -0700653_iso-8859-1 Bill- Will you post the trigger and stored proc definitions?
Shery
-----Original Message----- From: Proctor, William [mailto:william.proctor@TGSLC.ORG] Sent: Monday, September 10, 2001 5:58 AM To: DB2-L@RYCI.COM Subject: Re: Trigger calling a cobol stored procedure
I only have one stored procedure and I have replaced the call to the stored procedure with an sql statement to prove that the trigger was firing and executing the area with the call in it. We have tested the stored procedure separately and it works like a charm. What could I have setup wrong that causes it not to execute when the trigger calls it? [...]
5397 94 20_Re: Stuck with a SQL14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Mon, 10 Sep 2001 11:53:38 -0400401_iso-8859-1 Hi,
Please don't worry about the problem. I was able to solve it in the meantime with the following SQL:
( select b.group, a.mode_desc from tab1 a, tab2 b where b.mode_id = a.mode_id
except
select b.group, a.mode_desc from tab1 a, tab2 b where b.mode_id = 0 ) union ( select b.group, a.mode_desc from tab1 a, tab2 b where b.mode_id = 0 and a.mode_id <> 0 ) [...]
5492 56 65_Better Understanding Of UDB Partitioning/Node Distribution on AIX23_DePratti, Roland A H05N25_Roland.DePratti@CIGNA.COM31_Mon, 10 Sep 2001 12:04:33 -0400332_us-ascii I am very new to UDB in the AIX environment. So I appreciate your help and please forgive my newbee questions. I have used partitioning on DB2/OS390 for many years. I know the partitioning implementation is different, but the manuals or redbooks don't appear to give enough detail to answer some very basic questions, [...]
5549 18 50_How can a SQL be uniquely identified from a DBRM ?8_Harish G24_hari_gangadhar@YAHOO.COM31_Mon, 10 Sep 2001 15:55:22 -0500518_- Hi,
How can a SQL be uniquely identified in a DBRM ? Since any statement number above 32767 is set to zero by the pre-compiler is there any combination of fields that can be used to uniquely identify a SQL ? I am at DB2 v5.1.
Thanks and Regards,
Harish.
================================================ 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.
5568 198 22_Re: CA(PLATINUM QUERY)16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Sun, 9 Sep 2001 21:27:36 +0100441_us-ascii Good Evening Derez,
Using CA/PLATINUM Fast Unload, the way to unload what you are requesting is :
Limit of 500000 rows - use parameter LIMIT 500000
If you want sampling : SAMPLE (3,600) unloads 3 rows, then skips 597 etc. etc.
Hope this helps best regards Steen Rasmussen Computer Associates Senior Consultant tel: +45 45 47 43 63 fax: +45 45 47 41 10 mobile: +45 22 10 22 64 Steen.rasmussen@ca.com [...]
5767 31 16_index- define no10_Shery Hepp17_schepp@SRPNET.COM31_Mon, 10 Sep 2001 15:23:50 -0700364_iso-8859-1 Greetings-
I'm looking at creating demo environment for peoplesoft 8 financials. Due to the large number of objects, I'm thinking of creating the indexes with define no. I've checked the archives regarding this subject- and it seems that the ones who dared venture down this road did so with at their own risk- regarding utilities and such. [...]
5799 18 50_How can a SQL be uniquely identified from a DBRM ?8_Harish G24_hari_gangadhar@YAHOO.COM31_Mon, 10 Sep 2001 17:02:44 -0500495_- Hi,
How can a SQL be uniquely identified from a DBRM ? Since the pre-compiler sets statement numbers above 32767 to 0, is there a combination of fields in a DBRM which can be used to uniquely identify a SQL ?
Thanks much..
Harish.
================================================ 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.
5818 100 58_Re: WLM & cobol stored procedure errors - 471 ----00E7900610_teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 11 Sep 2001 09:31:55 +1000334_us-ascii (Sorry if this is a duplicate, didnt see it on the list) Hi Ellen,
Did u solve this problem ? (I see it is atleast 4 days old).
If not, cd u check up if ur proc load module has been linked with DSNRLI ? Just a possibility. Normally the LE datasets wd be in the system LINKLIST, so that shdnt be a problem. [...]
5919 109 23_Re: Delete trigger wows10_teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 11 Sep 2001 09:33:10 +1000345_us-ascii (Sorry if this is a duplicate, didnt see it on the list)
Gary,
Just a possibility. The SQLCODE (-189) indicates a problem with the CCSID of the database. We had the same problem on our OS/390 database, and ur problem cd be related. Try ALTERing the CCSID and see how it goes. Given below is an extract from the APAR. [...]
6029 56 60_Question about online reorg for a large partition tablespace9_sandyt00117_sandyt001@MSN.COM30_Sun, 9 Sep 2001 21:14:15 -0400465_iso-8859-1 My experience in the past of reorging a single partition of a large partition tablespace took several hours to do the build for the the NPI's(DB2 Version 5). I was wondering if someone who has experience in version 6 and or version 7 would share their experience if this is still the case. Are the new IBM utilities for version 7 alot faster or anyone using third party vendor products in version 6 or 7 seen an improvement for the build for large NPI'S.
6086 33 26_Qualified accounting trace13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU31_Tue, 11 Sep 2001 12:28:43 +1000324_iso-8859-1 All,
We are DB2 V6 for OS/390.
I have a problem that could be a bug in DB2. I start an additional trace as follows -START TRACE(A) CLASS(7,8) PLAN(XYZ) DEST(SMF). When I produce a short accounting report I get package level accounting information for plan XYZ as well as other unrelated plans. [...]
6120 47 13_Row Delimiter0_24_Sridhar_Kondusamy@I2.COM31_Tue, 11 Sep 2001 10:32:02 +0530263_us-ascii Hi Listeners
Good Morning
Is there any way wherein I can specify the option of ROW DELIMITER during the LOAD operation similar to COLDEL ?
Sridhar Kondusamy i2 Technologies Bangalore - 560 025
Ph : 2217990 (Extn : 140)
6168 93 14_SQL QUERY HELP17_Demetris Kasheris19_DKasheris@LAIKI.COM31_Tue, 11 Sep 2001 09:57:09 +0300377_us-ascii Hi list. The following SQL was submitted to me for tuning it. It was produced from Business Objects for a datawarehouse database residing on DB2 for AIX V7.1 The query is taking 11 min to finish. I run visual explain and the total cost was 508 units. The heaviest access was on an indexscan (332 units)(tvyindx2) on table TVY_. Any hints on how I can improve it? [...]
6262 64 15_Re: New Process15_Shabtai Shatsky22_shabtai@ATTUNITY.CO.IL31_Tue, 11 Sep 2001 11:43:32 +0200336_iso-8859-1 I have a DB2 process that does RRS multi-threading and thread sharing. A syncpoint is achieved by issuing an "EXEC SQL COMMIT WORK". When it is finished with the thread it does an RRS "TERMINATE THREAD". To terminate the DB2 Connection it does an RRS "TERMINATE IDENTIFY".
Is your process doing any of the above? [...]
6327 58 18_No mail from db2-l14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 11 Sep 2001 10:31:08 +0100203_iso-8859-1 it must be broken......
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
6386 139 35_Re: A question about a simple query11_Eric Wilkin18_eric.wilkin@NBB.BE31_Tue, 11 Sep 2001 11:55:34 +0200377_iso-8859-1 Terry, Test has executed multiple times, your ideas are well logic and conform to our feeling. But the query with count(*) is more performant (2 or 3 times faster !). Multiple tests have been done, on different days by different users ! Thanks for your response.
Eric Wilkin National Bank of Belgium SYDS-DB tel +32 (0)2 221 45 99 fax +32 (0)2 221 30 92 [...]
6526 77 23_Re: Data Modelling tool17_Sundaresan, Anand34_Anand.Sundaresan@BLR.HPSGLOBAL.COM31_Tue, 11 Sep 2001 15:42:00 +0500491_- Carl
You are right on the frustrations with ErWin. I used both ErWin and Visio. The greatest surprise I had was when I installed it and used the Map Database Wizard. Wow, it was so easy just two or three 'Next' and bang there it was my UDB Database (via ODBC) and it gave me options as to what model I needed. That was great. Also I could do this anywhere as long as I had connected to the Network where we had some UDB Installed. I have never seen such seamless connectivity. [...]
6604 83 36_AIX - R/390 version compatibility???16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Tue, 11 Sep 2001 11:16:43 +0100330_us-ascii Hi lists,
I know this is an OS question but since I can get no joy from IBM tech support I thought I'd ask the real experts (tongue still firmly implanted in my cheek, as the man said ;-). I was going to ask it to the large systems group but I'm not sure if an MVS image on a Risk counts as a large system... [...]
6688 36 42_SQLJ or JDBC - what is the better choice ?12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 11 Sep 2001 12:52:23 +0200371_iso-8859-1 Collegues,
in our company we have some discussion about the method how to access DB2 for OS/390 data over the Web.
My personal favorite is SQLJ. The reasons: On the one hand it uses static SQL. On the other hand it seems to me that SQLJ enables Java programs to be developed the way most DB2 programs have been developed for the last years. [...]
6725 43 30_Request for DB2/JAVA sample(s)10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 11 Sep 2001 14:46:23 +0200425_us-ascii Estimeed listers
I'm (again) testing the JDBC connection to DB2 to obtain some indications about performances on our 9672 black box, as we are developing 2 new applications (someone else wants to use UNIX for these apps). I had some samples but unfortunately last friday my hard disk crashed and all directories were destroyed. A very painful circumstance, expecially the loss of some great directories. [...]
6769 12 18_world trade center26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Tue, 11 Sep 2001 06:15:15 -0700328_iso-8859-1 Everybody hear that the world trade center towers were hit by small planes?
================================================ 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.
6782 42 12_DB2 on AS40014_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 11 Sep 2001 14:34:45 +0100643_iso-8859-1 Hi. This may be a stupid question, but how easy would it be for a DB2 DBA (namely me) who has OS/390 and UDB experience to administer DB2 on AS400? How different are they?
Cheers.
Marcus Davage
----------------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...]
6825 20 18_disaster in the US16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 11 Sep 2001 15:27:00 +0100414_us-ascii Hey lists,
did you hear / read / see the news about the planes crashing into the World Trade Centre Towers + Pentagon?
Tune in somehow.
Aurora
================================================ 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.
6846 42 20_UDB/DB2 connectivity16_Katsnelson, Yury26_Yury.Katsnelson@BCBSFL.COM31_Tue, 11 Sep 2001 11:09:15 -0400394_iso-8859-1 Hi, Listers! We need to establish connection between UDB AIX and DB2 Ver. 5 on Mainframe. So, it looks like we will have to build the following structure:
UDB AIX client ----> DB2 Connect Server ----> DB2 Ver. 5 Mainframe Server
I'm wondering if the following structure would also work:
UDB AIX client ----> UDB AIX Server ----> DB2 Ver. 5 Mainframe Server [...]
6889 45 16_unicode literals11_Daniel Adam16_dadam@GRATEX.COM31_Tue, 11 Sep 2001 10:23:49 -0500326_- Hi, This is DB2 v7r1 on OS/390 v2r10 I'm building a stored procedure in C language. My database tables are created with unicode (CCSID 1208) setting. Compile and link seems ok, but when I try to bind the procedure BIND PACKAGE(SAMPLE) - MEMBER(SMPSP1) ACT(REP) ISO(CS) - ENCODING(UNICODE)
I get following error: [...]
6935 20 13_LEVELID Error11_Manoj Veedu18_mv_db2@HOTMAIL.COM31_Tue, 11 Sep 2001 09:57:04 -0600502_- Hi,
Can anybody throw some lights on what causes a LEVElID error. using Db2 V5 for OS/390.
Manoj
_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
================================================ 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.
6956 12 20_Is anyone out there?0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 11 Sep 2001 11:20:40 -0500266_us-ascii Is the list up?
================================================ 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.
6969 28 44_Re: Trigger calling a cobol stored procedure16_Proctor, William25_william.proctor@TGSLC.ORG31_Tue, 11 Sep 2001 11:27:01 -0500581_iso-8859-1 No, it's an after insert.
-----Original Message----- From: Steve Grimes [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Monday, September 10, 2001 9:34 AM To: DB2-L@RYCI.COM Subject: Re: Trigger calling a cobol stored procedure
Um, would you by chance be trying this with a "BEFORE" trigger?
Stg
================================================ 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. [...]
6998 125 44_Re: Trigger calling a cobol stored procedure16_Proctor, William25_william.proctor@TGSLC.ORG31_Tue, 11 Sep 2001 11:36:58 -0500568_iso-8859-1 --#SET TERMINATOR # CREATE TRIGGER WHSE.TRERR001 AFTER INSERT ON WHSE.ERROR FOR EACH ROW MODE DB2SQL BEGIN ATOMIC CALL WHSE.SPXXX002('CSDIALUP'); END# COMMIT #
CREATE PROCEDURE WHSE.SPXXX002 ( IN PROCESSID CHAR(32) LANGUAGE COBOL EXTERNAL NAME SPUID001 NOT DETERMINISTIC MODIFIES SQL DATA DYNAMIC RESULT SET 1 STAY RESIDENT NO;
-----Original Message----- From: Shery Hepp [mailto:schepp@SRPNET.COM] Sent: Monday, September 10, 2001 10:51 AM To: DB2-L@RYCI.COM Subject: Re: Trigger calling a cobol stored procedure [...]
7124 123 20_Re: Stuck with a SQL13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Tue, 11 Sep 2001 09:44:50 -0700498_us-ascii Or probably this simpler one:
SELECT T2.GROUP, T1.MODE_DESC FROM TABLE1 T1, TABLE2 T2 WHERE T1.MODE_ID <> 0 AND T1.MODE_ID = T2.MODE_ID UNION SELECT T2.GROUP, T1.MODE_DESC FROM (SELECT 0 MODE_ID,MODE_DESC FROM TABLE1 WHERE MODE_ID <> 0) T1, TABLE2 T2 WHERE T1.MODE_ID = T2.MODE_ID
Thanks. Ashish.
-----Original Message----- From: Sinha, Abhijit [SMTP:Abhijit.Sinha@GS.COM] Sent: Monday, September 10, 2001 8:54 AM To: DB2-L@RYCI.COM Subject: Re: Stuck with a SQL [...]
7248 91 22_Re: world trade center24_Koleto, Kenneth M. [SLC]21_KKoleto@CSCUS.JNJ.COM31_Tue, 11 Sep 2001 12:44:18 -0400631_- Bill, I guess no one say your note until just now as no postings seem to have gone out lately. Sadly, we know by this time it's much worse than this. My thoughts and prayers go out to all those affected. Ken
> -----Original Message----- > From: Johnson, Bill (Pittsburgh) [SMTP:bjohnson@RUSSELLMELLON.COM] > Sent: Tuesday, September 11, 2001 9:15 AM > To: DB2-L@RYCI.COM > Subject: world trade center > > Everybody hear that the world trade center towers were hit by small > planes? > > ================================================ > To change your subscription options or to cancel your subscription visit > the [...]
7340 77 20_Re: index- define no0_20_John_Lendman@FPL.COM31_Tue, 11 Sep 2001 12:59:37 -0400330_us-ascii Sherry, I know it works in V6 because we tried it with an SAP install. We had to reinstall taking the DEFINE=NO off. Most of SAP could not handle it. I do not think the utilities for V6 can handle it either. Maybe V7 utilities will.
John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413 [...]
7418 32 24_Re: Is anyone out there?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 11 Sep 2001 13:02:56 -0400625_iso-8859-1 all is well here in Atlanta. no posts for a while then a bunch arrived about 12:20 EDT.
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Tuesday, September 11, 2001 12:21 PM To: DB2-L@RYCI.COM Subject: Is anyone out there?
Is the list up?
================================================ 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. [...]
7451 12 24_Re: Is anyone out there?16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Tue, 11 Sep 2001 13:06:26 -0400261_us-ascii yes its up
================================================ 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.
7464 28 24_Re: Is anyone out there?13_Murali Kanaga19_murali@EPIPHANY.COM31_Tue, 11 Sep 2001 10:08:07 -0700491_iso-8859-1 yes!!!!
> -----Original Message----- > From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] > Sent: Tuesday, September 11, 2001 9:21 AM > To: DB2-L@RYCI.COM > Subject: Is anyone out there? > > > Is the list up? > > ================================================ > 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. > [...]
7493 21 22_The List has restarted13_Morrill, John12_JohnM@VP.NET31_Tue, 11 Sep 2001 11:35:31 -0600517_iso-8859-1 Greetings!
The listserver had stopped sometime yesterday. I restarted it this morning. Most of the posting were held in a queue and are now being distributed. I am sorry for the inconvenience.
Cheers! J. Michael Morrill Db2-L Chief List Owner
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
7515 81 22_Re: world trade center13_Jackson, Phil21_PJackson@TXFB-INS.COM31_Tue, 11 Sep 2001 12:37:32 -0500568_iso-8859-1 Small Planes? No - Airliners....
-----Original Message----- From: Johnson, Bill (Pittsburgh) [mailto:bjohnson@RUSSELLMELLON.COM] Sent: Tuesday, September 11, 2001 8:15 AM To: DB2-L@RYCI.COM Subject: world trade center
Everybody hear that the world trade center towers were hit by small planes?
================================================ 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.
7597 120 22_Re: world trade center0_19_mike.holmans@BT.COM31_Tue, 11 Sep 2001 18:42:31 +0100332_iso-8859-1 My deepest condolences to all those affected by this terrible act.
If there are any list members who are normally resident in NYC or Washington reading this, perhaps you could check in so that those of us who know you can know you are safe? (I know that's off-topic, but in this case I think we can bear it). [...]
7718 37 67_Anyone understand fully the Archive/Retrieve User Exit Processing ?19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Tue, 11 Sep 2001 12:34:12 +0100323_us-ascii I'm doing an investigation into the user exit processing on DB2 UDB for AIX (V6), to ensure that I fully understand the implications before implementing it to handle my logs - obviously if something goes wrong and we lose a log file the results could be disastrous, especially if we are doing online backups. [...]
7756 44 43_Re: Downloading APARs - DB2 UDB V7.1 on AIX14_Marshall Fuqua19_marcfuqua@YAHOO.COM31_Tue, 11 Sep 2001 12:32:33 -0500652_- I've not had any responses to the note posted below & thought I'd try again. Does anyone know if this is possible (see below) ?
Marshall
=======================================================================
On Mon, 27 Aug 2001 14:03:29 -0700, Marshall Fuqua wrote:
>I've identified an APAR (IY17104) that I'd like to apply to our DB2 UDB V7.1 on >AIX environment. The APAR is included in Fixpak 3, however, I'd rather not >apply FP 3 just yet for a variery of reasons. > >My question - is it possible to download & apply only APAR IY17104 (or any >APAR, for that matter) without downloading & [...]
7801 46 22_Re: world trade center0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 11 Sep 2001 13:12:55 -0500385_iso-8859-1 FYI, re Phone calls. I work for a phone company and we just received the following message (also being sent to media) To prevent our network from overloading, MTS, along with other telephone companies in Canada, is restricting calls to certain area codes in the U.S. Customers may get an 'all circuits busy' message, or a 'fast busy' signal. (also Ottawa - 613) [...]
7848 42 17_Re: LEVELID Error12_Sue Janowitz22_sjanowitz@MEDIAONE.NET31_Tue, 11 Sep 2001 14:03:02 -0400505_iso-8859-1 I've seen it when we restored the catalog/directory to a point in time, and tried to use an application tablespace that had not been restored. So DB2 saw that the TS was not at the correct level for the catalog/directory.
Sue Janowitz currently unemployed DB2 SYSADM (Boston area)
----- Original Message ----- From: Manoj Veedu Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, September 11, 2001 11:57 AM Subject: [DB2-L] LEVELID Error [...]
7891 186 22_Re: world trade center14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Tue, 11 Sep 2001 14:07:31 -0400326_iso-8859-1 Hi guys -
I live and work in NYC. I just wanted to thank all those who conveyed their condolences.
I just got back from a visit in Israel, where this kind of thing is an everyday occurrence, although not on THIS scale !!!. But I can tell you all that it does NOT make it any easier to deal with. [...]
8078 115 20_Re: index- define no10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM31_Tue, 11 Sep 2001 14:22:47 -0400445_us-ascii We have implemented "define no" on several instances of PeopleSoft on DB2 V6. We had some initial problems with QUIESCE issued against a tablespace with DEFINE NO indexes. IBM supplied a PTF for this and we are implementing in production.
Shery Hepp Sent by: DB2 Data Base Discussion List 09/10/01 06:23 PM Please respond to DB2 Data Base Discussion List [...]
8194 34 22_Re: world trade center14_Scott Trometer22_scott.trometer@RCI.COM31_Tue, 11 Sep 2001 13:26:06 -0500534_iso-8859-1 -----Original Message----- From: Johnson, Bill (Pittsburgh) [mailto:bjohnson@RUSSELLMELLON.COM] Sent: Tuesday, September 11, 2001 8:15 AM To: DB2-L@RYCI.COM Subject: world trade center
Everybody hear that the world trade center towers were hit by small planes?
================================================ 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. [...]
8229 21 22_Re: world trade center14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 11 Sep 2001 14:41:48 -0400524_ISO-8859-1 Two large commercial airliners were hijacked and flown into the WTC. Both towers have collapsed. I watched this happen on TV.
Thousands of people have been murdered here.
All airports in the country are shut down, and the city is closed.
Joel Goldstein
===============================================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.
8251 66 20_Re: index- define no0_23_William_OBlack@FFIC.COM31_Tue, 11 Sep 2001 11:36:47 -0700509_us-ascii Sherry, we just installed PS8 but used the provided scripts. We had thought about using DEFINE=NO for the demo system, but we felt that when we loaded the demo test data that most tables would get populated so all the indexes would be built anyway. However, when we build our first test environment we will use DEFINE=NO. We're currently running GL and Budget in PS7.5, and only about 10% of the defined tables actually have real data in them. We'll start a PS8 implementation effort next year. [...]
8318 89 20_Re: index- define no0_19_Tim.Lowe@STPAUL.COM31_Tue, 11 Sep 2001 14:12:13 -0500577_us-ascii PQ46888?
Keith Kuhn cc: Sent by: DB2 Subject: Re: index- define no Data Base Discussion List
09/11/2001 01:22 PM Please respond to DB2 Data Base Discussion List
We have implemented "define no" on several instances of PeopleSoft on DB2 V6. We had some initial problems with QUIESCE issued against a tablespace with DEFINE NO indexes. IBM supplied a PTF for this and we are implementing in production. [...]
8408 99 20_Re: index- define no15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Tue, 11 Sep 2001 15:14:50 -0400434_iso-8859-1 Shery, IIRC there is a problem with reorganizing a multi table tablespace which does not contain data for all of the tables in tablespace and the indexes defined as DEFINE=NO. The problem was with REORG tries to delete/define the indexes for the tables with no data. This is just from memory of something mentioned several months ago. It may have been fixed or I may be mistaken. I have not tested this on our system. [...]
8508 113 20_Re: index- define no12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Tue, 11 Sep 2001 15:18:50 -0400603_us-ascii Yes. PQ46888/UQ54092 for quiesce and PQ47805/UQ55868 for reorg or rebuild with define no .
Tim.Lowe@STPAUL.COM@RYCI.COM> on 09/11/2001 03:12:13 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: index- define no
PQ46888?
Keith Kuhn cc: Sent by: DB2 Subject: Re: index- define no Data Base Discussion List [...]
8622 74 20_Re: index- define no12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Tue, 11 Sep 2001 14:23:04 -0500443_iso-8859-1 Hi Shery, Yes, We setup all environments with DEFINE NO on indexes only. However, you may run into problems with runstats. We did not use DEFINE NO on tablespaces because of problems with IMAGECOPY. I don't have the query in front of me. But I think for indexes I used SYSIBM.SYSINDEXPART and looked at space = -1. For tablespaces you can look at sysibm.systablepart for space = -1. These are set to -1 when no dataset exists. [...]
8697 48 22_Re: disaster in the US23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 11 Sep 2001 20:23:18 +0100473_- I am sure I speak for everyone in the UK when I say the prayers of the British People are with the US People today.
:-(
Leslie
-----Original Message----- From: Aurora Dell'Anno [mailto:Aurora_E_DellAnno@CANDLE.COM] Sent: Tuesday, September 11, 2001 3:27 PM To: DB2-L@RYCI.COM Subject: disaster in the US
Hey lists,
did you hear / read / see the news about the planes crashing into the World Trade Centre Towers + Pentagon? [...]
8746 42 22_Re: world trade center12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Tue, 11 Sep 2001 14:29:10 -0500297_iso-8859-1 If there are any data centers that have been affected by this disaster, I'm sure that all members of this list will be ready to help in any way necessary to get the data center online again.
May God's blessings be on all of those affected by this cowardly act of terrorism. [...]
8789 52 22_Re: world trade center23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 11 Sep 2001 20:29:10 +0100421_iso-8859-1 I am sure I speak for the whole of the UK(and world for that matter) when I say that our prayers are with the US people at this most tragic and blackest of times.
:(
regards
Leslie Pendlebury-Bowe
-----Original Message----- From: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM] Sent: Tuesday, September 11, 2001 7:42 PM To: DB2-L@RYCI.COM Subject: Re: world trade center [...]
8842 71 22_Re: world trade center23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 11 Sep 2001 20:37:29 +0100484_iso-8859-1 If anybody needs our help just shout ...
Leslie UK 01932 816185
-----Original Message----- From: Moulder, Tom [mailto:Tom_Moulder@BMC.COM] Sent: Tuesday, September 11, 2001 8:29 PM To: DB2-L@RYCI.COM Subject: Re: world trade center
If there are any data centers that have been affected by this disaster, I'm sure that all members of this list will be ready to help in any way necessary to get the data center online again. [...]
8914 28 44_From the List Owners: The World Trade Center13_Morrill, John12_JohnM@VP.NET31_Tue, 11 Sep 2001 13:58:54 -0600483_iso-8859-1 To all members of the DB2-L Community:
Lest there be any question, all members of this list may feel free post messages about the World Trade Center disaster.
Thank you Leslie for your prays and thank you Leslie and Tom for your offers of assistance.
I am sure I speack for all members of the DB2-L community when I say that all off us are ready to help anyone affect by this disaster. This is the worst distaster in the U.S since the civil war. [...]
8943 65 43_Re: Downloading APARs - DB2 UDB V7.1 on AIX19_John H. Maenpaa Jr.24_john_maenpaa@YLASSOC.COM31_Tue, 11 Sep 2001 14:41:13 -0500416_iso-8859-1 Depending on the particular problem, IBM DB2 support may be able to build a fix for your maintenance level. You'll need to call IBM DB2 support and work with them.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Marshall Fuqua Sent: Tuesday, September 11, 2001 12:33 PM To: DB2-L@RYCI.COM Subject: Re: Downloading APARs - DB2 UDB V7.1 on AIX [...]
9009 36 28_OFF TOPIC: Terrorist attacks16_Victor Rodriguez19_victropolis@MAC.COM31_Tue, 11 Sep 2001 14:16:17 -0700392_iso-8859-1 Fellow subscribers,
I just wanted to take a minute to express my sorrow and regret for the terrorist events which have rocked the United States, and indeed the entire world this morning.
I would like to extend my condolences to the family and friends of anyone out there who may have been affected by these horrible acts. You are all in my thoughts and prayers. [...]
9046 43 22_Re: world trade center15_Nadia Dimitrova17_dnady@HOTMAIL.COM31_Tue, 11 Sep 2001 15:36:22 -0500793_- It is a disaster! It was a very beautifull plase!
>From: "Jackson, Phil" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: world trade center >Date: Tue, 11 Sep 2001 12:37:32 -0500 > >Small Planes? No - Airliners.... > >-----Original Message----- >From: Johnson, Bill (Pittsburgh) [mailto:bjohnson@RUSSELLMELLON.COM] >Sent: Tuesday, September 11, 2001 8:15 AM >To: DB2-L@RYCI.COM >Subject: world trade center > > >Everybody hear that the world trade center towers were hit by small planes? > >================================================ >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 [...]
9090 86 22_Re: world trade center19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Tue, 11 Sep 2001 20:42:31 +0100649_us-ascii Put me down as another one to help if needed -
+44-131-660-9450.
We are all praying for everyone - I've just come from our normal weekly prayer meeting and you were all in our thoughts.
Phil Nelson
On Tue, 11 Sep 2001 20:37:29 +0100, Pendlebury-Bowe, Leslie wrote:
>If anybody needs our help just shout ... > >Leslie >UK 01932 816185 > > > >-----Original Message----- >From: Moulder, Tom [mailto:Tom_Moulder@BMC.COM] >Sent: Tuesday, September 11, 2001 8:29 PM >To: DB2-L@RYCI.COM >Subject: Re: world trade center > > >If there are any data centers that have been affected by this disaster, I'm >sure [...]
9177 20 54_Important notice regarding Baltimore/Washington DB2 UG12_Mark Anzmann18_manzmann@EROLS.COM31_Tue, 11 Sep 2001 16:01:11 -0500347_- For all of you that were planning to attend the Baltimore/Washington DB2 Users Group Meeting at the Columbia Sheraton tomorrow (Sept 12th), the meeting has been cancelled. The treasurer will destroy all checks received for pre-registration. Any questions can be sent to Mark Anzmann at manzmann@syscom.com or via telephone at 410-238-1213. [...]
9198 23 17_Buffer pool usage12_Mark Cassity27_Mark.Cassity@MOTION-IND.COM31_Tue, 11 Sep 2001 16:36:00 -0500506_iso-8859-1 Dear List,
Is there any way to determine what the "high water" usage mark is for a given buffer pool over a period of time? I'm not talking about thresholds being exceeded. We have had several discussions about our BP allocations. I personally think they are over allocated, but this question keeps coming up and we don't know if such a measurement is captured anywhere. We are OS/390 V6 and have BMC MainView and a pretty good selection of Platinum tools. Your help is appreciated. [...]
9222 31 22_Re: world trade center16_Adrian Challinor29_adrian.challinor@OSIRIS.CO.UK31_Tue, 11 Sep 2001 22:59:30 +0100474_iso-8859-1 > If anybody needs our help just shout ...
I can offer help on UDB system on Unix and NT, plus Oracle on the same.
Our prayers are with all those affected by this.
Adrian Challinor R&D Director - Osiris Consultants Ltd e-mail: adrian.challinor@osiris.co.uk
phone: 020-8852-1605 This e-mail is environment fax: 0870-0349-134 friendly and was made only mobile: 07860-290-883 from recycled electrons. [...]
9254 37 40_FW: SWARUG Meeting Sept 20- David Beulke10_Shery Hepp17_schepp@SRPNET.COM31_Tue, 11 Sep 2001 15:48:25 -0700686_iso-8859-1 -----Original Message----- From: Steve Hunn [mailto:shunn@lightyr.com] Sent: Monday, September 10, 2001 7:10 AM To: Steve Hunn Subject: SWARUG Meeting Sept 20
Hi SWARUG members,
Our next meeting is Thursday, September 20 at ASU. This meeting is being sponsored by AZTECH Professional Services. We have an excellent keynote speaker lined up - David Beulke will be speaking about DBA Techniques for Efficient Application Development. This presentation will appeal to DBAs and Application Developers so it should be very interesting. David will also be presenting a SIG topic; Data Warehouse Performance. Jay Allen will be doing the other SIG; How to analyze [...]
9292 73 29_Re: Sub-select in ON clause??8_K.Balaji19_K.Balaji@TARGET.COM31_Tue, 11 Sep 2001 18:15:47 -0500517_iso-8859-1 Dave, In V5 (I dont know about V6 & V7) we cannot issue host variable and sub-select in ON clause.
But it looks like you are looking for a row which will contain Max value of col2 in table2. I think this can be worked around like this:
SELECT A.COL1, max(B.COL2) FROM TABLE1 A LEFT OUTER JOIN TABLE2 B ON A.COL1 = B.COL1 GROUP BY A.COL1 HAVING MAX(B.COL2) = (SELECT MAX(C.COL2) FROM TABLE2 C WHERE A.COL1 = C.COL1) This should get you the row which contains max value of COL2 in TABLE2. [...]
9366 19 16_Re: DB2 Security12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Sep 2001 19:23:39 -0500381_- The primary resources for working through DB2 Security are the books. The DB2 Administration Guide has a section called Security and Auditing. If you want an overview of DB2 security, we put several out on the web. http://www.ibm.com/servers/eserver/zseries/zos/racf/presentations.html
The two I'd suggest are: DB2 Security Overview RACF and DB2: Teamed for Security [...]
9386 22 16_Re: DB2 Material12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Sep 2001 19:29:01 -0500659_- If what you want is performance and tuning presentations about DB2 for z/OS & OS/390, then here are the primary web locations I'd check first:
www.share.org/proceedings Look in the DB2 project
ibm.com/software/db2os390 Click on Support, Then Click Technical Presentations
http://db2usa.hypermart.net/eliendb2.htm
Those pages will refer you to many more.
Roger Miller, DB2 for z/OS
================================================ 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.
9409 48 21_Re: Buffer pool usage14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 11 Sep 2001 20:55:01 -0400551_ISO-8859-1 Unless the number of pages referenced from all objects assigned to a pool is less than the total number of buffers - there is no such thing as a "high water" mark. All pages will be used. The only product that can help you size the buffer pools, and optimize the size vs performance is the Buffer Pool Tool. It can PREDICT performance at varying pool sizes, and can show you which objects belong together based on access type and working set sizes. This is the only product that can predict, and this is the only effective way to tune [...]
9458 64 29_Re: Sub-select in ON clause??0_19_mike.holmans@BT.COM31_Wed, 12 Sep 2001 02:04:05 +0100672_iso-8859-1 You could just add it as a WHERE clause. You don't have to it all in the ON.
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
>>-----Original Message----- >>From: David Nance [mailto:DWNance@FHSC.COM] >>Sent: 10 September 2001 16:08 >>To: DB2-L@RYCI.COM >>Subject: [DB2-L] Sub-select in ON clause?? >> >> >> I'm trying to find some documentation now, but would >>appreciate if anyone knows the answer. In left and right >>outer joins you are allowed to say col = literal in the on >>clause. I'm trying [...]
9523 16 8_Re: FAQ?12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Sep 2001 19:53:06 -0500516_- One of the best sets of FAQs is fairly new. Go to the web page for the DB2 product you want, then click on Support and then on Frequently Asked Questions (FAQs).
ibm.com/db2 is good enough to start usually
Roger Miller, DB2 for z/OS ibm.com/software/db2os390
================================================ 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.
9540 14 24_Re: Regarding DB2 sizing12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Sep 2001 20:06:44 -0500461_- If the DB2 is for z/OS and OS/390, the best resource is probably the Redbook - DB2 for OS/390 Capacity Planning, SG24-2244. You might see other red books on capacity planning as well.
Roger Miller, DB2 for z/OS
================================================ 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.
9555 18 43_Re: increased deadlocks with Type 2 indexes12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Sep 2001 20:16:46 -0500494_- When you are having deadlocks and timeouts, the starting place for an external look is usually the IFCIDs 0172 and 0196. They will help work out the specifics of the contention. Most of our large customers are running V6 or later today, so their type 1 indexes are gone. You might see if you're getting concurrent access where the type 1 indexes did not allow it. There are lots of questions and suggestions in the Improving Concurrency chapter, and most are outside of the application. [...]
9574 87 29_Re: Sub-select in ON clause??13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 11 Sep 2001 20:55:35 -0500371_us-ascii David,
It's documented in the SQL Reference guide that an ON clause cannot contain subqueries (do a search for "join-condition").
You may impact the result by negating NULL supplied rows if you add your condition to the WHERE clause. You also risk applying this as a totally after join predicate.
This should give you a similar result: [...]
9662 14 16_Re: DB2 on AS40012_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Sep 2001 20:48:48 -0500453_- The SQL is very similar, but the systems and tuning are very different. http://www.iseries.ibm.com/developer/db2/db2common.html http://www.ibm.com/servers/eserver/iseries/db2/
Roger Miller, DB2 for z/OS
================================================ 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.
9677 155 44_Re: Trigger calling a cobol stored procedure10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 12 Sep 2001 12:22:13 +1000358_us-ascii Hi Bill,
Some possible points I can think of.
U mentioned Workload manager in ur original mail. Are u using WLM SPAS or the DB2 started task SPAS ?
I dont notice a WLM environment parameter in ur procedure definition. So I presume that it is non-WLM. Have u Link-Edited the module with DSNALI ? (or, DSNRLI if a WLM proc). [...]
9833 47 16_You are invited!12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 11 Sep 2001 21:42:32 -0500448_- You are invited to a web site that has been changed a lot since you last visited. Start at the main DB2 web site, ibm.com/software/db2os390 Then click on Support. This should be
We have added many answers to common questions, hints and tips, some recent technical presentations and red books about DB2. Many of the key technical people spent time to get more than 500 new items out on the web. Here are several of the new categories: [...]
9881 24 26_SQL Performance Comparison11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Wed, 12 Sep 2001 10:02:26 +0700314_- Dear all,
A simple question, maybe a very stupid one but still make sense. Is there any difference in SQL Performance if we do a query to two tables with keys in integer, and keys in alphanumeric. I believe DB2 doesn't really care about what type of the keys, as long as they're not in BLOB or CLOB. [...]
9906 51 44_Some items from z/OS 1.2 announcement letter14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 11 Sep 2001 23:22:22 -0500701_ISO-8859-1 For those who haven't yet read it (http://www.ibmlink.ibm.com/usalets&parms=H_201-248) some iteresting items:
- IRLM V2.1 provides enablement of System-Managed CF Structure Duplexing for the IRLM Lock structure for IMS Data Sharing and DB2® through APAR PQ48823. Additionally, PQ48996 is required for the DB2 data sharing environment. - DB2 for z/OS and OS/390, V7 provides support for System-Managed CF Structure Duplexing for its System communication Area. DB2 has supported User-Managed CF Structure Duplexing for its Group Buffer Pools since DB2 V5 and OS/390 R3 with supporting APARs. - WLM provides a new mechanism to dynamically determine the number of server tasks that [...]
9958 156 20_Re: Stuck with a SQL13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 11 Sep 2001 23:47:21 -0500474_US-ASCII Or even simpler:
SELECT T2.GROUP, T1.MODE_DESC FROM TABLE1 T1 JOIN TABLE2 T2 ON (T1.MODE_ID <> 0 AND T2.MODE_ID = 0) OR (T1.MODE_ID = T2.MODE_ID AND T1.MODE_ID <> 0)
"OR's" in a join can disable some of the available join methods; so as always, performance depends.
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 [...]
10115 147 18_Re: SQL QUERY HELP13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 12 Sep 2001 00:27:41 -0500378_US-ASCII Demetris,
I would be increasing the query optimization class to 9 to allow the greatest level of query rewrite etc. Changing such queries is often out of the question.
Also, alter all indexes to increase the number of index range delimiting, rather than index sargable predicates. The index you mention, I would alter the sequence to something like: [...]
10263 125 35_Re: A question about a simple query13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 12 Sep 2001 00:54:15 -0500458_iso-8859-1 Eric,
Unfortunately I was not in the office to test, but an ex-collegue of mine sent me Omegamon trace output on their V6 system(thanks Kals) proving what you were saying to be absolutely true.
Given this, I would be logging this problem with IBM.
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 [...]
10389 16 24_Re: Is anyone out there?15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Wed, 12 Sep 2001 09:11:25 +0200451_us-ascii Yes
Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be those of Sanlam, to whom no liability shall attach whatsoever.
================================================ 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.
10406 29 22_Re: world trade center10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Sep 2001 09:23:48 +0200409_us-ascii Estimeed US lister
Since yesterday afternoon (in Europe) we are keeping up with the events and with the passing of time the disaster looked even worse we could imagine. Cowardly acts carried out by wretch people and they must be heavily punished.
To all Us citizens our deepest condolences and our solidarity, it's the time to do everything possible to save and to help survivors. [...]
10436 45 46_Re: SQLJ or JDBC - what is the better choice ?12_Simon George26_simon_x_george@HOTMAIL.COM31_Wed, 12 Sep 2001 08:37:28 +0100
10482 97 46_AW: SQLJ or JDBC - what is the better choice ?12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 12 Sep 2001 10:19:46 +0200649_iso-8859-1 Thanks a lot, Simon.
Cheers, G e o r g
-----Ursprüngliche Nachricht----- Von: Simon George [mailto:simon_x_george@HOTMAIL.COM] Gesendet am: Mittwoch, 12. September 2001 09:37 An: DB2-L@RYCI.COM Betreff: Re: SQLJ or JDBC - what is the better choice ?
Hi,
We mostly use SQLJ for all our applications for all the reasons we use to use static SQL in our COBOL programs. Its also far easier to code and understand than JDBC (although we use Visual Age For Java that "hides" a lot of it) and the security model is much better (although if you are making calls to stored procedures there [...]
10580 86 24_Re: UDB/DB2 connectivity12_Travis, John27_John.Travis@CAPGEMINI.CO.UK31_Wed, 12 Sep 2001 09:28:04 +0100330_- Yury, Yes the connection AIX Client --> AIX Server --> DB2 V5 OS/390 will work provided the derver is the EE version. Your statement that DB2 connect becomes redundant on moving to UDB on the mainframe is not correct as you will still need the DB2 connect component to provide DRDA client services for connection to hosts. [...]
10667 74 41_READ ONLY status after an Full image copy15_Balbir Chaudhry28_Balbir.Chaudhry@SWISSCOM.COM31_Wed, 12 Sep 2001 10:30:22 +0200741_iso-8859-1 Hi Listers
An image copy should set all tablespace at RW status after it has been ended with RC=4.
Most of our image copy Jobs do this very well. But two of them do not change the RO status to RW.
An Example: //* //STEP010 EXEC PGM=ACPMAIN, // PARM='DB2P,,NEW/RESTART,MSGLEVEL(1)', // REGION=0M //STEPLIB DD DISP=SHR,DSN=SYSDBSP.BMC.DB2P.LOAD // DD DISP=SHR,DSN=SYSDBSP.DB2.DB2P.SDSNLOAD //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //ACPGDG DD * DEFINE GDG (NAME(&BASE) LIMIT(3) SCR) //SYSIN DD * OPTIONS MAXTASKS 4 OUTPUT COPY001 UNIT SYSDA DSNAME UXP.BGF.&DB.&TS.P&LPART(+1) COPY TABLESPACE BDBNAMEX.* COPYDDN(COPY001) SHRLEVEL REFERENCE RESETMOD NO GROUP YES QUIESCE AFTER ON ERROR BADSTATUS END ON [...]
10742 29 47_white papers on UDB DB2 to SQL Server Migration17_Reddy, Sreenivasa34_sreenivasa.reddy@BLR.HPSGLOBAL.COM31_Wed, 12 Sep 2001 13:16:53 +0500668_- Hi,
Could anyone send me the white papers on UDB DB2 to SQL Server migration.
Thanks in advance.
Regards Sreenivas WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.----------------- HCL Perot Systems [...]
10772 26 27_can two cursor be appended.10_praveen_kj19_praveen_kj@INFY.COM31_Wed, 12 Sep 2001 14:52:51 +0530313_iso-8859-1 Hi All,
Can two cursors could be appended to one cursor. In our project we have an requirement where inspite of keeping multiple cursors opening we want to append them all and make them one cursor. Is it possible to append them?
Regards, Praveen Kumar Jain
10799 55 64_Re: Question about online reorg for a large partition tablespace22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 12 Sep 2001 15:38:11 +0530622_- You can look into the redbook DB2 UDB V7 Performance Topics for updates in V7 for online reorg. It is much faster than the previous versions. SWITCH and BUILD2 Phases are redesigned.
Regards, Sanjeev
> -----Original Message----- > From: sandyt001 [SMTP:sandyt001@MSN.COM] > Sent: Monday, September 10, 2001 6:44 AM > To: DB2-L@RYCI.COM > Subject: Question about online reorg for a large partition tablespace > > My experience in the past of reorging a single partition of a large > partition tablespace took several hours to do the build for the the > NPI's(DB2 Version 5). I was wondering if someone [...]
10855 69 48_Re: From the List Owners: The World Trade Center17_Alessandro Brezzi24_alessandro.brezzi@TIN.IT31_Tue, 11 Sep 2001 23:04:03 +0200371_iso-8859-1 Tutti siamo preoccupati per gli avvenimenti e per l'altissimo prezzo in vite umane che gli US hanno pagato in queste ore per una causa che ancora non ci è chiara.
Credo che le preghiere di tutti noi, in qualsiasi lingua o fede siano espresse, saranno rivolte a chi, innocente, è rimasto coinvolto in qualcosa che sfugge ad ogni comprensione umana. [...]
10925 117 22_Re: world trade center16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Wed, 12 Sep 2001 11:34:00 +0100597_us-ascii My sorrow and solidarity too...
Aurora
----- Forwarded by Aurora E DellAnno/CAM/Candle on 12/09/2001 11:33 -----
"Philip Nelson (DBA)" To: DB2-L@RYCI.COM Subject: Re: world trade center
11/09/2001 20:42 Please respond to "Philip Nelson (DBA)"
Put me down as another one to help if needed -
+44-131-660-9450.
We are all praying for everyone - I've just come from our normal weekly prayer meeting and you were all in our thoughts. [...]
11043 72 30_Re: SQL Performance Comparison22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 12 Sep 2001 16:16:09 +0530637_iso-8859-1 If i am correct then unless until there is no data conversion between column and host var/literals/parameter markers exist, performance will not be different for numeric/alphanumeric keys etc.
But it is a good question as i felt.
Regards, Sanjeev
> -----Original Message----- > From: Endy Lambey [SMTP:endyl@CENTRIN.NET.ID] > Sent: Wednesday, September 12, 2001 8:32 AM > To: DB2-L@RYCI.COM > Subject: SQL Performance Comparison > > Dear all, > > A simple question, maybe a very stupid one but still make sense. > Is there any difference in SQL Performance if we do a query to two tables > with keys [...]
11116 64 18_Excessive Getpages0_18_mebert@AMADEUS.NET31_Wed, 12 Sep 2001 12:46:23 +0200561_us-ascii Hi,
yesterday I was testing a query (it did not use the index (YEAR, MONTH, OFFICE) it was supposed to, but did a TS scan). It went SELECT YEAR, MONTH, SUM(C) FROM table WHERE YEAR='2001' AND MONTH='07' GROUP BY YEAR, MONTH; I watched the execution with Omegamon. The TS has about 1.2 M pages. But Omegamon reported around 3 times as many GETPAGEs in the TS Bufferpool (none in the Index BP, just one in BP7 for DSNDB07). I have noticed before that in many cases, the GETPAGEs is much higher than I would expect. What could be the possible [...]
11181 183 35_Re: A question about a simple query20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Wed, 12 Sep 2001 12:51:11 +0200502_iso-8859-1 Hi there, sorry if I'm going to say something absurd or nonsense, but I'm rather new in this field and very curious.
Last time maybe I got in a subject still not so clear to me as access path.
This time I just want to share a thought or better a question: Do you really think this is something correlated with DB2? Isn't it normal that the response time can grow if you have to display one row or thousands of them? Isn't it the I/O the biggest bottleneck in most system? [...]
11365 115 35_Odp: Re: SQL Performance Comparison15_Piotr Tarnowski20_TarnowskiP@PROKOM.PL31_Wed, 12 Sep 2001 13:08:11 +0200357_iso-8859-2 Hallo,
the only difference I can see is the range of values which will fit on both types (CHAR v. INT) If you have data which can only be a number INT or DEC will be better because it gives better filter factor for range predicates (with known 2HIGH, 2LOW values for key). This can be a benefit maybe not in this query but in others. [...]
11481 89 22_Re: Excessive Getpages22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 12 Sep 2001 16:47:07 +0530305_- Hi Dr. Ebert,
Cardinality of year is very less. And this is the reason for TS scan (You know it !). What about the fullkey card of the index? What all colums are there in the index? What is the total number of rows/pages in the index? Do you think a TS scan should have these many getpages? [...]
11571 107 22_Re: Excessive Getpages22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 12 Sep 2001 16:54:40 +0530442_- Sorry for the mistake. My this sentence should be read as whatever is in the small bracket.....This was a Typo...
"If you know that there are less number of records corresponding to the WHERE condition, and [TS scan is better than the index+datapage] (index+datapage scan is better than TS scan), then using anyone of these (including OPTIMIZE FOR) is useful. Otherwise, i do think index+datapage may be costlier than TS only." [...]
11679 97 20_Synchronous RECEIVE?0_18_mebert@AMADEUS.NET31_Wed, 12 Sep 2001 13:17:25 +0200573_us-ascii Hi all,
I have a program to generate JCL for common tasks (Imagecopy, MODIFY, etc.) which is running successfully in our Legacy Prod and Test systems. Now I want to use it for our SAP systems as well. But there are some difficulties.
- The SAP systems are on different LPARs and Machines. We do not have a SAS license there (the pgm uses SAS). - The dataset information for the SAP datasets (DB2 VSAMs and IC datasets) is not reliably accessible from the legacy LPARs. It seems that our MVS group has trouble with sharing the ICF catalog. Also, [...]
11777 138 22_Re: world trade center45_=?ISO-8859-1?B?WUFTRU3dTiDH3UZUx91TT1kg3kVO?=20_ycsen@ETIBANK.COM.TR31_Wed, 12 Sep 2001 14:23:57 +0300677_ISO-8859-1 My condolences to all those affected by this terrible terrorism act. God Bless you all ! ----- Original Message ----- From: Aurora Dell'Anno Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, September 12, 2001 1:34 PM Subject: Re: world trade center
> My sorrow and solidarity too... > > Aurora > > ----- Forwarded by Aurora E DellAnno/CAM/Candle on 12/09/2001 11:33 ----- > > "Philip > Nelson (DBA)" To: DB2-L@RYCI.COM > LOBAL.NET> Subject: Re: world trade center > > 11/09/2001 > 20:42 > Please > respond to > "Philip > Nelson (DBA)" > > [...]
11916 14 24_Re: Synchronous RECEIVE?10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Sep 2001 13:33:57 +0200313_us-ascii Are USS services available in both machine ?
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.
11931 14 20_Re: index- define no15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Wed, 12 Sep 2001 06:26:21 -0500416_us-ascii We use define no on all our tables and indexes in SAP. We have also developed software that checks the space parmameter for -1 before we create Runstats entries ect.
================================================ 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.
11946 183 24_Re: Synchronous RECEIVE?0_19_mike.holmans@BT.COM31_Wed, 12 Sep 2001 12:41:45 +0100431_iso-8859-1 I don't know how standard this would be, given that we use CA-7 as our job scheduler and I don't know if other schedulers have "dataset triggers", but what I'd do is create a bunch of jobs which FTP'd datasets from place to place, with further jobs which get started when the datasets get created, and delete the datasets when they've finished. CA-7 can certainly start a job when it notices that a dataset exists. [...]
12130 49 30_Re: SQL Performance Comparison16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 12 Sep 2001 07:50:59 -0400420_iso-8859-1 There will be some difference as the integer is shorter than te alphanumeric. Thus you will have more keys per page. Index scans will do less I/O. Probably a nit.
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Endy Lambey [mailto:endyl@CENTRIN.NET.ID] Sent: Tuesday, September 11, 2001 11:02 PM To: DB2-L@RYCI.COM Subject: SQL Performance Comparison [...]
12180 13 24_Re: Synchronous RECEIVE?15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Wed, 12 Sep 2001 06:53:47 -0500367_us-ascii Do you have COBOL on your SAP lpar? We have those same type of programs (RUNSTATS,MODIFY,IC,REORG) created in COBOL.
================================================ 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.
12194 13 0_23_Sumi Mohan, J16 Chennai27_sumi_mohan@MSDC.HCLTECH.COM31_Wed, 12 Sep 2001 17:48:38 +0530320_iso-8859-1 Hi All,
Does anyone has an approach to convert IMS DB to DB2
================================================ 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.
12208 42 24_Re: Synchronous RECEIVE?0_18_mebert@AMADEUS.NET31_Wed, 12 Sep 2001 14:19:00 +0200193_us-ascii Yes. I have never used it directly but have experience with "real" UNIXes.
MfG, ME.
Are USS services available in both machine ?
Max Scarpa
12251 98 24_Re: Synchronous RECEIVE?16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Wed, 12 Sep 2001 08:23:03 -0400411_us-ascii Michael,
If you can use DDF to get to the other system, why not simply update one row in a control table when your job is finished (as a last step in the job). Then you can have a monitor job on the other system look in the control table for some variable time (maybe every couple of minutes). We use this technique for a home-grown utility automation that runs utilities on various lpars. [...]
12350 44 29_UDF Question - Raising errors14_Scott Trometer22_scott.trometer@RCI.COM31_Wed, 12 Sep 2001 07:25:47 -0500446_iso-8859-1 Listers,
DB2 UDB for 0s/390 V6 Os/390 V2.7 WLM Goal Mode
I am trying to create an External UDF that either raises an error condition or sets the SQLSTATE and message for certain criteria. I have tried the RAISE_ERROR function and also physically moving values into the SQLSTATE and SQLERRMC fields...both to no avail, my calling SQL from SPUFI executes normally. My UDF has 2 input parms and returns only one value. [...]
12395 46 24_Re: Synchronous RECEIVE?0_18_mebert@AMADEUS.NET31_Wed, 12 Sep 2001 14:30:33 +0200507_us-ascii If you think of recoding the SAS program in COBOL (or REXX, or C++, or...) I'm not even considering it. I have a rather compact programming style in SAS (the vector-based approach fits my way of thinking very well), but even so it's now 2K lines. In COBOL, it would probably have 100K+ lines, and many of the SAS basic operations (like SET.. BY, MERGE) and PROCs (PROC SORT, PROC PRINT) would require a major effort to code in any other language even without capturing the full functionality. [...]
12442 49 0_0_20_John_Lendman@FPL.COM31_Wed, 12 Sep 2001 08:41:35 -0400452_us-ascii I believe that IBM has a utility that will help you in the process. Contact them or check out their web page.
John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413
"Sumi Mohan, J16 Chennai" To: DB2-L@RYCI.COM Subject: Sent by: "DB2 Data Base Discussion List"
09/12/01 08:18 AM Please respond to "DB2 Data Base Discussion List" [...]
12492 67 0_16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Wed, 12 Sep 2001 13:45:06 +0100332_us-ascii Sumi,
as I always do, I'll suggest you have a look at DL/2 from Circle. Their site is http://www.circle-group.com/ and we had a nice talk about this in the list a few weeks ago, you could look it up in the archives if you wish.
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. [...]
12560 32 0_12_Carl Shinkle24_carl.shinkle@MANTECH.COM31_Wed, 12 Sep 2001 08:47:07 -0400415_us-ascii Sumi Yes, our firm does this sort of thing for a living. Please contact me offline. My e-mail is: carl.shinkle@mantech.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] On Behalf Of Sumi Mohan, J16 Chennai Sent: Wednesday, September 12, 2001 8:19 AM To: DB2-L@RYCI.COM Subject:
Hi All,
Does anyone has an approach to convert IMS DB to DB2 [...]
12593 22 20_Re: You are invited!13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 12 Sep 2001 08:48:46 -0400514_iso-8859-1 Thanks for the word, Roger. The site looks great.
I especially like your new translation of the old acronym, Read The Friendly Web
see you in Orlando.
David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12616 12 24_Re: Synchronous RECEIVE?15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Wed, 12 Sep 2001 07:39:42 -0500278_us-ascii We could send you the code.
================================================ 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.
12629 65 24_Re: Synchronous RECEIVE?0_18_mebert@AMADEUS.NET31_Wed, 12 Sep 2001 14:45:50 +0200553_us-ascii Our MVS people mentioned this as well (we use Control-M). But I've been trying for weeks to get the Control-M people to schedule a simple weekly housekeeping job, and they say they did it, but it never runs. So I don't want to do any complex proposals to them. Years ago I did something comparable using BDT (Bulk Data Transfer), defining a job network. I don't know whether it's available here, and I don't think it would be preferable to a REXX wrapper for RECEIVE. Generally, I aim for solutions with a minimum amount of prerequisites. [...]
12695 222 22_Re: world trade center16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Wed, 12 Sep 2001 08:50:12 -0400727_iso-8859-1 My sympathy and thoughts go out to everyone. This has effected more people then just those two cities. While time may smooth over the pain, it will never be able to remove the memories/thoughts/feelings
Robert Galambos Compuware Corp. Of Canada
1-800-348-8299 1-800-447-1662 (quebec) 1-905-803-8603 (fax)
******************************************************************** This message and any attachments are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee you may not copy, forward, disclose or use any part of the message or its attachments and if you have received this message [...]
12918 19 63_InDUG (Indiana DB2 Users Group) meeting 9/13 has been cancelled11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Wed, 12 Sep 2001 07:48:48 -0500438_iso-8859-1 The InDUG meeting for tomorrow has been cancelled. We hope to reschedule it in October.
Tina Hilton Database Analyst Bertelsmann mediaSystems (317) 542-6891 Tina.Hilton@bmsus.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
12938 193 22_Re: world trade center16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Wed, 12 Sep 2001 08:50:57 -0400513_iso-8859-1 God takes care of his children. We will be a stronger nation, hopefully putting aside petty differences and focus on GOD, uniting to assist each other for the common good of humanity.
Please add me to the list of volunteers to help.
Steve Cockerill 704-365-7342 Charlotte, NC USA Peoplesoft, DB2
-----Original Message----- From: YASEMÝN ÇÝFTÇÝSOY ÞEN [mailto:ycsen@ETIBANK.COM.TR] Sent: Wednesday, September 12, 2001 7:24 AM To: DB2-L@RYCI.COM Subject: Re: world trade center [...]
13132 70 30_Re: SQL Performance Comparison14_William Gannon33_wgannon@EMAIL.PALMBEACH.K12.FL.US31_Wed, 12 Sep 2001 08:54:51 -0400553_us-ascii Hi All !
I don't have any proof of difference but wouldn't it make sense that a difference does exist as far as cardinality and weighting of values for key selection. Example: each position, with integer, can contain values of 1 in ten, ranging from 0 thru 9, with a character field each position can contain values of 1 in 36 (min?) values A-Z & 0-9. I would assume access path selection could contain algorithms that take this into effect ... But I guess only Big Blue knows that for sure. I know that if I am wrong here, someone [...]
13203 33 0_19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Wed, 12 Sep 2001 13:58:23 +0100328_us-ascii There's a tool called DL/2 from Circle Group (UK company) which assists with this.
It translates DL/I calls into SQL to allow a phased migration to take place.
How much redesign it allows in the process I'm not sure, as mapping segments to tables is not necessarily the best approach when rewriting. [...]
13237 66 54_Re: How can a SQL be uniquely identified from a DBRM ?22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 12 Sep 2001 15:52:05 +0530337_- Unfortunately this is the case and i do not have any clue about how to determine this in V5. From V6, we have a new column STMTNOI which is defined as INTEGER. It can have value more than 32767 now.
If i am not wrong, then this was a topic of discussion sometime 2 years back. Not able to recall if there was any solution. [...]
13304 29 24_Re: Synchronous RECEIVE?12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US31_Wed, 12 Sep 2001 09:09:35 -0400503_US-ASCII Why not just put it out on the archive??
Mark Anzmann Tech Services DHRIS Program - Team Accenture Phone: 410-238-1213 email: manzmann@dhr.state.md.us
>>> daniel.sullivan@ZURICHNA.COM 09/12/01 08:39AM >>> We could send you the code.
================================================ 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. [...]
13334 125 45_Re: READ ONLY status after an Full image copy22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 12 Sep 2001 16:06:58 +0530343_- Quick Guess !!
You have MODIFY RECOVERY also in the job and its possible that RO state tablespace have no entries in SYSCOPY(All deleted with age(30)). Do a query in SYSIBM.SYSCOPY for tablespace SPACE6,7 and 8. You might get zero record for full imagecopy.
Get back to the list if you do not find any clue based on this. [...]
13460 33 26_Qualified accounting trace17_Erkki Søndergaard20_esonderg@SCA.CSC.COM31_Wed, 12 Sep 2001 15:20:50 +0200464_us-ascii >Date: Tue, 11 Sep 2001 12:28:43 +1000 >From: "LOMBARD,Shaun" >Subject: Qualified accounting trace
>All,
>We are DB2 V6 for OS/390.
>I have a problem that could be a bug in DB2. I start an additional trace as >follows -START TRACE(A) CLASS(7,8) PLAN(XYZ) DEST(SMF). When I produce a >short accounting report I get package level accounting information for plan >XYZ as well as other unrelated plans. [...]
13494 41 24_Re: Synchronous RECEIVE?10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Sep 2001 15:18:24 +0200526_us-ascii I'm not sure I understood the structure of your application, but I shoot:
I used (some years ago) a structure like this, using FTP (BPXBATCH) using USS (but of course it may not fit your needs):
I use FTP batch from one system to another. It's relative simple.
After the trasfer of a first (big) file finish, I tranfer another file in a subsequent jobstep (using IF/THEN/ELSE in JCL) indicating the end of first file transfer (few bytes, may contain statements or data, we call it OK-FILE). [...]
13536 29 43_Stored procedure calling a stored procedure10_praveen_kj19_praveen_kj@INFY.COM31_Wed, 12 Sep 2001 18:44:45 +0530400_iso-8859-1 Hi All,
In our project we are required to call a stored procedure(SP2) from a stored procedure(SP1). Now 1.) client A calls SP1 2.) SP1 calls SP2.
Now if SP2 returns two result set . if SP1 in itself returns One Result Set.
Would the whole three result sets would be available to the Client A or not? or only single result set would be available to the Client A. [...]
13566 38 20_Re: You are invited!16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Wed, 12 Sep 2001 14:19:25 +0100425_us-ascii Very nice!
I bookmarked it straight away!
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
1 Archipelago Lyon Way Frimley Camberley Surrey GU16 7ER UK
* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER [...]
13605 24 22_Re: world trade center16_Martin Berchtold31_Martin.Berchtold@SYSTEMATICS.DE31_Wed, 12 Sep 2001 08:18:26 -0500406_- Also from Germany, the deepest condolence to the people of the United States of America. We are shocked and we are not able to express what we feel for the moment. But you should know, Germany is with you. All our TV and Radio stations has changed their program, sport events were cancelled and the authorities of Munich consider to cancel the biggest party in the world, the Oktoberfest in Munich. [...]
13630 76 24_Re: Synchronous RECEIVE?0_18_mebert@AMADEUS.NET31_Wed, 12 Sep 2001 15:02:10 +0200574_us-ascii Rick,
the problem is to determine when the data is available on the legacy system. Currently the job that RECEIVEs the data is submitted from the SAP system as the last step, after the XMIT, so it would always find the updated row immediately. But it still can (usually does) start executing before the data is available, or RECEIVE data not intended for it. Currently we do not have DDF connectivity yet; I just want to run the part that generates a space usage & growth report. Another idea is to INSERT the dataset (and SYSLGRNX info) into tables on [...]
13707 72 22_Re: Excessive Getpages0_18_mebert@AMADEUS.NET31_Wed, 12 Sep 2001 15:36:33 +0200396_us-ascii Hi Sanjeev,
the index is not very good for this query (I think FULLKEYCARD is >1M). But since I don't know which other queries are run on this table (from BO), and the performance improvement when using OPTIMIZE FOR was about x15, I left it at that.
But the thing that's puzzling me, why does Omegamon report (ca.) 3.6 M TS getpages for a TS scan of a 1.2 M page TS?? [...]
13780 30 12_wtc disaster16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Wed, 12 Sep 2001 09:54:17 -0400552_us-ascii Hatred and prejudice are horrible things because they always lead to actions against those who are hated. I must speak against the factions of the Islam religion that are extremist in nature. They teach that it is good to hate your enemies, and that you will be rewarded in the next life if you murder them. In great contrast to such a destructive teaching, Jesus taught that we should love our enemies, and that we will be rewarded for so doing. This is not easy to do, but it is the highest and most noble of all standards. Some people [...]
13811 46 51_Re: white papers on UDB DB2 to SQL Server Migration20_Pranay Kumar Akhouri15_pka@ANTARIX.NET31_Wed, 12 Sep 2001 19:30:16 +0530
13858 40 70_DB2 UDB Solaris kernel configuration question - msgsys:msginfo _msgseg14_Jeffrey Benner29_Jeffrey_Benner@NOTES.NTRS.COM31_Wed, 12 Sep 2001 09:01:55 -0500419_us-ascii Is anyone out there also aware of discrepancies in IBM documentation regarding Solaris kernel parameter msgsys:msginfo_msgseg? IBM recommends this be set to 32767 in the latest version 7 Quick Beginnings docs, and makes a point of stating it should never be set higher than 32767 (for example, should not be set to 32768). But earlier versions of UDB documentation state the value should be set at 32768. [...]
13899 92 22_Re: Excessive Getpages16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Wed, 12 Sep 2001 15:14:08 +0100423_us-ascii Dr. Ebert,
are you looking at the Near Term History report in Omegamon?
Please contact me offline about this, it sounds like a problem with the (very) old version of Omegamon II for DB2.
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 [...]
13992 94 21_Re: Buffer pool usage12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Wed, 12 Sep 2001 09:17:33 -0500585_iso-8859-1 Mark
This may start a holy war on buffer pool tuning, but here goes anyway. Prediction is one way to tune buffer pools, however, the predictions can only be as good as the data that you collect and the static nature of the workloads you are tuning. If you have the same transaction mix all the time with little variance then predictions can be made that are highly accurate. However, if your workload is constantly changing, then there is no one size fits all environments for your buffer pools. Another alternative is the approach that is taken by Pool Advisor [...]
14087 67 75_Re: DB2 UDB Solaris kernel configuration question - msgsys:msginf o _msgseg18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 12 Sep 2001 10:26:34 -0400304_- We have ours set at 32768. Never noticed the discrepancy. I'm not sure what it is used for. I do know that when the system parms are not set correctly, the install fails.
Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2 [...]
14155 12 50_Re: wtc disaster - treading on minefields with PC?16_aurora dell'anno19_adpucci@HOTMAIL.COM31_Wed, 12 Sep 2001 16:17:48 +0200
14168 18 20_AW: You are invited!12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 12 Sep 2001 16:30:05 +0200383_iso-8859-1 GREAT !!
And now the good old RTF. has a new meaning "Read The Friendly Web".... ;-))
Cheers, Georg H. Peter
================================================ 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.
14187 47 16_Re: wtc disaster13_Ferris, Gregg20_GFerris@AEGONUSA.COM31_Wed, 12 Sep 2001 09:20:38 -0500577_- i'm not sure that this is the correct forum for your message.
> -----Original Message----- > From: Charles F Creech [SMTP:cfcreech@DUKE-ENERGY.COM] > Sent: Wednesday, September 12, 2001 9:54 AM > To: DB2-L@RYCI.COM > Subject: wtc disaster > > Hatred and prejudice are horrible things because they always lead to > actions against those who are hated. I must speak against the factions of > the Islam religion that are extremist in nature. They teach that it is > good > to hate your enemies, and that you will be rewarded in the next life if > you > murder them. [...]
14235 36 4_test20_Westcott-Dryer, Lisa32_Lisa_Westcott-Dryer@FOREMOST.COM31_Tue, 11 Sep 2001 12:38:21 -040011_ISO-8859-1
14272 69 75_Re: DB2 UDB Solaris kernel configuration question - msgsys:msginf o _msgseg18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 12 Sep 2001 10:34:06 -0400416_- Just a little more info on this. Sun describes this as a parameter for interprocess communications. It also recommends that it be set to < 32768. Which means that the V7 doci is correct and the earlier versions are not.
Just curious as to what other installations are set at?
Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2 [...]
14342 198 43_Re: Downloading APARs - DB2 UDB V7.1 on AIX14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Wed, 12 Sep 2001 07:38:12 -0700496_iso-8859-1 Marshall, Based on my experiances, it isn't possible to just apply individual fixes for DB2 UDB for Windows and Unix, you have to apply the fix pack. Under certain circumstances you can get fixes from IBM support, but I believe that thes are only availble BEFORE the fixpack is released, and then only for SEV 1 problems. I'm sure this isn't what you wanted to hear. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
14541 28 16_Re: wtc disaster14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Wed, 12 Sep 2001 09:29:49 -0500390_iso-8859-1 Rick,
I totally agree with your opinions.
I do not believe in discrimination against anyone on the basis of the colour of their skin, their political persuasion or their religious belief. However, Islam seems to lend itself to intolerance and arrogance (and an acute sense of paranoia) and its followers make no effort to integrate with the rest of the world. [...]
14570 135 45_AW: READ ONLY status after an Full image copy15_Balbir Chaudhry28_Balbir.Chaudhry@SWISSCOM.COM31_Wed, 12 Sep 2001 16:44:01 +0200341_iso-8859-1 Hi Sanjeev
Thanks a lot. I have done a query and as you said all records are deleted which were created 30 days before. But i have still some records in the 'sysibm.syscopy' remaining.
If there are no records to delete the following message will be shown: BMC180018W NO ROWS MATCH CRITERIA. NO PROCESSING DONE. [...]
14706 93 24_Re: Synchronous RECEIVE?0_18_mebert@AMADEUS.NET31_Wed, 12 Sep 2001 16:07:59 +0200550_us-ascii Hey Daniel,
that is very generous - thanks - but I've done considerable customisation of my program for our specific needs. For example, can your program:
- create missing GDG bases for new TSs - drop GDG bases for TSs that no longer exist, or are no longer used, after a certain retention period - create ICs for TSs that have been changed since the last IC, when that was more than n days ago - direct IC output to disk or tape, depending on size - create full or partition level ICs, depending on size - create ICs for [...]
14800 56 16_Re: wtc disaster15_Visser, Michael11_mjv@HNC.COM31_Wed, 12 Sep 2001 07:52:45 -0700605_iso-8859-1 A lot of evil has been done in the name of religion, this is merely the latest incident, and won't be the last. As long as people remain intolerant to each other's differences, world civilization will continue to suffer under the violence of war, be it total war or the low-intensity conflicts we have endured over the last half century in various spots around the world. As long as religous dogma persists in the world, along with the disenfranchisement of segments of the world's population, fanatics will be produced to drive trucks of explosives into Marine barracks, park cars loaded [...]
14857 26 4_Test13_Joel Pankonin26_joel.pankonin@ZURICHNA.COM31_Wed, 12 Sep 2001 09:58:40 -0500586_us-ascii Just a test
******************* PLEASE NOTE ******************* This message, along with any attachments, may be confidential or legally privileged. It is intended only for the named person(s), who is/are the only authorized recipients. If this message has reached you in error, please notify the sender immediately and promptly destroy it without review. Dissemination, distribution or copying of this communication is strictly prohibited. Thank you for your help. ********************************************************** [...]
14884 73 16_Re: wtc disaster16_Craig Snoeyenbos27_CSnoeyenbos@STATESTREET.COM31_Wed, 12 Sep 2001 11:00:53 -0400528_us-ascii The Koran teaches this just as the Bible taught the Spanish Inquisition.
Scumbags throughout history have found religious justification for their actions.
This is not the fault of the founders or true leaders of the religions invoked in the name of evil.
Regards, Craig Snoeyenbos 617 985-2163 csnoeyenbos@statestreet.com
"Clayton, Colin" To: DB2-L@RYCI.COM Subject: Re: wtc disaster Sent by: DB2 Data Base Discussion List [...]
14958 26 24_Re: Synchronous RECEIVE?15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Wed, 12 Sep 2001 09:57:36 -0500505_us-ascii We use BMC for Image copy and it creates gdg''s if required. Our image copies go to tape, we don't have the dasd to have that luxury, We have a program which we run once a week to resize the entire system based on space currently used, I'm kinda proud of that one. . We create RUNSTATS based on a parm passed to the program, if stats haven't been run in x days. We also create the MODIFY statements. We create ONLINE reorgs based on a query in the Utility Guide for tablespaces and indexes. [...]
14985 131 75_Re: DB2 UDB Solaris kernel configuration question - msgsys :msginfo _msgseg14_Jeffrey Benner29_Jeffrey_Benner@NOTES.NTRS.COM31_Wed, 12 Sep 2001 10:08:50 -0500581_us-ascii Peter,
That is the problem I have here. The Solaris machines we have DB2 UDB 7.2 running on, have this setting currently at 32768 because of the old documentation reference. If I could find a Sun doc that says otherwise, maybe I could persuade them to set it to 32767. We have strange intermittent problems which may or may not be related to this. I have been brought in, in an advisory role only, and there is reluctance to touch this old configuration without strong documentation support. Could you point me to the Sun docs which advise this kernel setting [...]
15117 30 63_Re: wtc disaster - WHY ARE WE ARGUING? LIST OWNERS PLS MODERATE16_aurora dell'anno19_adpucci@HOTMAIL.COM31_Wed, 12 Sep 2001 17:20:52 +0200
15148 120 16_Re: wtc disaster9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 12 Sep 2001 16:21:56 +0100491_us-ascii Dear Listowner, Before Listserv degenerates into a religious/political slanging match, any chance of ruling that only messages of condoloncies are expressed regarding yesterday's atrocity. Kind Regards, Andy Hunt - Athiest
Craig Snoeyenbos on 12/09/2001 16:00:53
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Re: wtc disaster [...]
15269 61 16_Re: wtc disaster18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Wed, 12 Sep 2001 11:24:10 -0400720_iso-8859-1 All forums should accommodate "the message" under the circumstances!
-----Original Message----- From: Ferris, Gregg [mailto:GFerris@AEGONUSA.COM] Sent: Wednesday, September 12, 2001 10:21 AM To: DB2-L@RYCI.COM Subject: Re: wtc disaster
i'm not sure that this is the correct forum for your message.
> -----Original Message----- > From: Charles F Creech [SMTP:cfcreech@DUKE-ENERGY.COM] > Sent: Wednesday, September 12, 2001 9:54 AM > To: DB2-L@RYCI.COM > Subject: wtc disaster > > Hatred and prejudice are horrible things because they always lead to > actions against those who are hated. I must speak against the factions of > the Islam religion that are extremist in nature. [...]
15331 48 16_Re: wtc disaster12_Imran Kareem13_imran@BEZ.COM31_Wed, 12 Sep 2001 10:37:38 -0500558_iso-8859-1 Colin-
To answer your question the Koran in no way endorses or encourages the things you see in the news. The literal translation of Islam is peace.
When these terrorists claim that they are in a Holy War (known as a Jihad) they have brainwashed themselves in believing they are fighting for a cause endorsed by the Koran. A holy war is when two groups of men are fighting, each with arms for the sake of religion. As soon as a women, child or innocent person has been touched it is no longer a holy war. This is clearly stated [...]
15380 42 16_Re: wtc disaster13_Joel Pankonin26_joel.pankonin@ZURICHNA.COM31_Wed, 12 Sep 2001 10:34:37 -0500565_us-ascii Andy Hunt @RYCI.COM> on 09/12/2001 10:21:56 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: wtc disaster
Sorry to hear that.......
Dear Listowner, Before Listserv degenerates into a religious/political slanging match, any chance of ruling that only messages of condoloncies are expressed regarding yesterday's atrocity. Kind Regards, Andy Hunt - Athiest [...]
15423 19 63_Re: wtc disaster - WHY ARE WE ARGUING? LIST OWNERS PLS MODERATE14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Wed, 12 Sep 2001 10:38:22 -0500450_iso-8859-1 Dear List,
apologies if my reply opened this can-of-worms..
My only excuse is that I was watching the news coverage again at lunchtime and I guess it wound me up !
Love'n'Peace
================================================ 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.
15443 41 21_Re: Buffer pool usage10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Sep 2001 17:45:16 +0200406_us-ascii Apart of (more or less useful) some **magic** product there's an indirect 'water mark' to evaluate if BP are overallocated (looking DB2 from another point of view) and this is BP hit ratio (reversing some Chuck Hoover's examples - see his papers). There's no 'real' water mark (as it happens for open dataset for instance) as all buffers in BP are used (ie data flow reached an equilibrium). [...]
15485 151 16_Re: wtc disaster11_Bill Happel28_Bill.Happel@HARTFORDLIFE.COM31_Wed, 12 Sep 2001 10:54:59 -0500485_US-ASCII Better yet. What are some good discussion groups, where religion and political discussions can be directed to? As well as thoughts and theories regarding the Attack Against America?
>>> Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK 09/12/01 10:21AM >>> Dear Listowner, Before Listserv degenerates into a religious/political slanging match, any chance of ruling that only messages of condoloncies are expressed regarding yesterday's atrocity. Kind Regards, Andy Hunt - Athiest [...]
15637 22 59_Question about DB2 Data sharing and Group naming convention11_Mike Dupuis23_Mike.Dupuis@CLARICA.COM31_Wed, 12 Sep 2001 12:11:21 -0500447_us-ascii In the DB2 UDB V6 Data Sharing Guide it says when establishing a naming convention for the Group Name to avoid names that begin with the letters A-I unless the first three characters are DSN.
I was considering using group names like ADB2 for a Production system and BDB2 for a Development system. Does anyone have any experiences or suggestions about not using the DSN prefix in the group name and it start with letters A- I. [...]
15660 83 16_Re: wtc disaster16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Wed, 12 Sep 2001 12:20:21 -0400537_us-ascii Thank you, Imran. That was very well said.
Best wishes, Rick Creech
Imran Kareem cc: Sent by: DB2 bcc: Data Base Subject: Re: wtc disaster Discussion List
09/12/01 11:37 AM Please respond to DB2 Data Base Discussion List
Colin-
To answer your question the Koran in no way endorses or encourages the things you see in the news. The literal translation of Islam is peace. [...]
15744 116 65_Better Understanding Of UDB Partitioning/Node Distribution on AIX11_James Drewe20_James.Drewe@AEXP.COM31_Wed, 12 Sep 2001 09:26:56 -0700620_iso-8859-1 Roland
I have a some experience with UDB EEE partitioning so I'll attempt to answer your questions.
My application is for data warehouse, not OLTP. Please keep in mind that the designs of the two are different. I typically use surrogate keys and hashing since the distribution across the nodes is pretty even. The surrogate key is sequentially generated key by the Extract, Transform, Load (ETL) program that extracts the data from the operational system. Since I use surrogate keys, there is only one column. However, I don't believe there is any guarantee that the high order column in a [...]
15861 163 16_Re: wtc disaster16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Wed, 12 Sep 2001 12:23:38 -0400540_us-ascii TRY CNN http://community.cnn.com/cgi-bin/WebX?13@@.eefc3c5
Bill Happel on 09/12/2001 11:54:59 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: wtc disaster
Better yet. What are some good discussion groups, where religion and political discussions can be directed to? As well as thoughts and theories regarding the Attack Against America? [...]
16025 158 76_Re: DB2 UDB Solaris kernel configuration question - msgsys :msgin fo _msgseg18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 12 Sep 2001 12:28:59 -0400568_- I have the same type of customers. Even doci doesn't work sometimes.
http://docs.sun.com/ab2/products_C/INDEX/@ProductViewer/5759/*;td=1?Ab2Lang= C&Ab2Enc=iso-8859-1#CurrentPos
Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2
-----Original Message----- From: Jeffrey Benner [mailto:Jeffrey_Benner@NOTES.NTRS.COM] Sent: Wednesday, September 12, 2001 11:09 AM To: DB2-L@RYCI.COM Subject: Re: DB2 UDB Solaris kernel configuration question - msgsys :msginfo _msgseg [...]
16184 33 16_Re: wtc disaster13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 12 Sep 2001 12:29:12 -0400574_iso-8859-1 Imram, Thank you for your enlightening post.
It took courage to brave those who might attack you here or in private. Colin, it was noble of you to apologize.
I'm proud to be part of the DB2-l gang which for the most part has dealt honorably with this tragedy. Sadly, our counterparts over at IMS-l didn't fare so well, getting a number of uninformed, racist arguments going until the listowner shut it down and it is now in moderated mode --meaning, I believe, that each post must be approved by a human moderator before delivered to the list. [...]
16218 36 16_Re: wtc disaster11_Doug Fuerst21_doug@BKASSOCIATES.NET31_Wed, 12 Sep 2001 12:26:42 -0400492_us-ascii Then let them speck out unequivocably. Too many are sympathetic to these extremists.
At 11:00 AM 9/12/2001 -0400, you wrote: >The Koran teaches this just as the Bible taught the Spanish Inquisition. > >Scumbags throughout history have found religious justification for their >actions. > >This is not the fault of the founders or true leaders of the religions >invoked in the name of evil. > >Regards, >Craig Snoeyenbos 617 985-2163 >csnoeyenbos@statestreet.com > [...]
16255 82 16_Re: wtc disaster11_Doug Fuerst21_doug@BKASSOCIATES.NET31_Wed, 12 Sep 2001 12:23:30 -0400538_us-ascii Today, Gregg, every forum is the correct forum if you are either a compassionate human being or an American. My son's godfather's wife and kids worked and were in day care in the WTC. People who worked for me at one time at American Express barely made it out of 7WTC with their lives. People at Credit Suisse First Boston might not have made it out. Or people my wife worked with at Dean Whitter. Excuse us Gregg, we are looking for some sanity in all of this, and count on the support of people from places like this list [...]
16338 29 38_Recovery of Table with Identity Column10_Iris Wilde16_wildei@TDBANK.CA31_Wed, 12 Sep 2001 12:39:35 -0400547_iso-8859-1 Hello all:
A colleague has asked me to submit the following question relating to identity columns in DB2 for OS/390:
"How does DB2 handle a Point-in-time recovery for a table with identity columns, specifically regarding the value of MAXASSIGNEDVAL. If we recover to a prior Point In Time, does DB2 reset the MAXASSIGNEDVAL or does it remain what it was when the failure occurred or when the RECOVER was run? What happens if there is also corruption to the SYSSEQUENCES table which means it too has to be recovered?" [...]
16368 60 16_Re: wtc disaster12_Marc Sennett23_msennett@TEKSYSTEMS.COM31_Wed, 12 Sep 2001 12:57:26 -0500314_us-ascii Sir,
My prayers are with you and all other Muslim Americans, who have nothing to do with this hatred and evil. I hope your non-Muslim brothers embrace you and your family, and do not fall victim to group hatred, discrimination, and all of the by-products of this event. Take care of yourself. [...]
16429 12 21_This is only a test !19_Insixiengmay, Vince22_vinsixieng@STATE.PA.US31_Wed, 12 Sep 2001 12:56:01 -0400261_iso-8859-1
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16442 33 39_SUBSTR function & Access Path Selection13_Penny Treptow21_Penny.Treptow@UAL.COM31_Wed, 12 Sep 2001 12:09:55 -0500514_- When the SUBSTR function is used in the join predicate E.EMPLID = SUBSTR(D.MANAGER_ID,1,6) , the DB2 optimizer is selecting a tablespace scan on the PS_EMPLOYEES table. Without the SUBSTR, an index scan is used - this is the preferred access path for performance. Since the SUBSTR is selecting the first six positions of the primary key, the index could still be used to filter the rows. Does anyone have a recommendation on how to influence the Optimizer to use the index when the SUBSTR function is used? [...]
16476 43 33_The World Trade Center Discussion13_Morrill, John12_JohnM@VP.NET31_Wed, 12 Sep 2001 11:17:25 -0600609_iso-8859-1 Dear Subscribers!
Since the World Trade Center disaster there have been many posts that have offered condolences, prayers and help to those affected. Unfortunately, there have also been posts that contained religious slurs.
When I decide to open the list to discussion about the World Trade Center disaster, I knew it was only a matter of time before someone posted a message that others would find offensive. In the weeks and months that will follow we will find that this tragedy will bring out the best and the worst in people all over the world. Since the DB2-L community is [...]
16520 51 16_Re: wtc disaster16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 12 Sep 2001 13:09:43 -0400536_iso-8859-1 OF COURSE the IMS-L will get the racist stuff. Everyone knows IMS folks are inferior to DB2ers ;-}
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Wednesday, September 12, 2001 12:29 PM To: DB2-L@RYCI.COM Subject: Re: wtc disaster
Imram, Thank you for your enlightening post.
It took courage to brave those who might attack you here or in private. Colin, it was noble of you to apologize. [...]
16572 19 16_Re: wtc disaster13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 12 Sep 2001 13:17:08 -0400424_iso-8859-1 Eric, don't you dare get me in trouble with my IMS buddies.
Please!
David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16592 47 16_Re: wtc disaster12_McKown, John22_JMckown@HEALTHAXIS.COM31_Wed, 12 Sep 2001 12:17:12 -0500576_- Well said. I hope that nobody "targets" somebody else based on how they look or their religion (or lack thereof). I remember Oklahoma City and the rumors about possible local Muslim involvement. That was 100% incorrect. I hope nobody in the U.S. or elsewhere in the world is "punished" just because they say they are a Muslim, or any other religion / philosophy. That is just as terroristic as the attacks performed by these madmen (who were no more doing God's will than the crusaders in the middle ages). I do have my religious beliefs (Christian), but that is cause [...]
16640 88 29_Re: Sub-select in ON clause??8_K.Balaji19_K.Balaji@TARGET.COM31_Wed, 12 Sep 2001 12:14:28 -0500531_iso-8859-1 Mike, If we use WHERE clause instead of ON the Left outer join becomes very complicated. That is one of the reasons why I too use ON clause whenever I issue a join. The problem that Dave has reported is very typical problem with joins. I am facing it quite often. Many times I felt that ON clause should have provisions for using host variables so that we can issue join on specific values of a table. If only two or three tables are joined we can work around this in WHERE clause. If we have more than three table [...]
16729 135 16_Re: wtc disaster9_Al Heiden31_alheiden@NORTHWESTERNMUTUAL.COM31_Wed, 12 Sep 2001 12:21:56 -0500337_ISO-8859-1 My condolences and sympathies are with all those impacted by this tragedy. My heart has been heavy for the past two days due to this mess.
At this time I have not heard positively who is responsible for this, or that anyone has claimed responsibility for it. I haven't heard any news for the last couple of hours. [...]
16865 68 39_[Fwd: [Fwd: FW: America The Beautiful]]12_Marc Sennett23_msennett@TEKSYSTEMS.COM31_Wed, 12 Sep 2001 13:46:51 -0500300_us-ascii Really worth everybody's while to read this one..
================================================ 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.
16934 46 37_Re: The World Trade Center Discussion12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Wed, 12 Sep 2001 12:35:47 -0500599_iso-8859-1 John Morrill wrote: "....."bomb them all,let God sort them out". It would be pointless for me to point out that this would make our country as bad as if not worse then those who attacked us. Instead I just reply with silence."
Mr. Morrill, I am compelled to respond, not with silence, nor with condemnation, but with a heartfelt request that you search your mind and soul and ask yourself, where would the world be today had civilized countries not banded together, responded with bombs, bullets, and yes, violence, and defeated Hitler? Where would the Jews be who were being [...]
16981 50 28_OS/390 V6 - Binding Triggers10_Joan Green22_Joan.Green@BOIMAIL.COM31_Wed, 12 Sep 2001 18:40:46 +0100410_us-ascii Listers,
Firstly I wish to say everyone here is stunned,shocked and speechless. My thoughts and prayers are with those effected by the terrible, terrible atrocities in the US.
Secondly and trivially. We are creating a trigger in a database which has an SBCS_CCSID of 285 and this works fine. When we create the same trigger in a database which has an SBCS_CCSID of 0 we get a -189. [...]
17032 76 37_Re: The World Trade Center Discussion15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 12 Sep 2001 12:43:34 -0500328_iso-8859-1 I think that John means that people are lumping all people of Middle-Eastern origin together. This is not right. Have we not learned anything from WWI and WWII? We cannot blame a whole people for the actions of few. I agree that the perpetrators must be punished but we must be certain about who they are first. [...]
17109 26 69_DB2 OS/390: Java App on server holding locks on DB2 OS/390 Tablespace0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Wed, 12 Sep 2001 13:45:58 -0400537_us-ascii To all,
Every once in a while( 3-4 times a week), a Java online application using DISTSERV seems to hold update locks for a very long time on a tablespace. It seems this thread is hung up and won't go away. Sometimes, our batch processes agains this tablespace abend because of the locks on the tablespace. Could someone explain if the ZPARMS CMTSTAT and IDTHTOIN would help in this situation? They are currently set at ACTIVE, 180. Is it possible the JAVA application requires modification? What about DB2 CONNECT? [...]
17136 23 16_Re: wtc disaster0_17_JTonchick@AOL.COM29_Wed, 12 Sep 2001 13:47:08 EDT375_US-ASCII Fanatics are just that -- fanatics. Whether they quote the Koran, Bible, or any other religious or nonreligious writings. Terrorism has no place in New York, Belfast, Tokyo, or any other place on the planet. If you must vent anger, vent it towards the individuals that committed the acts, not the innocent people who look like the perpetrators of the violence. [...]
17160 189 43_Re: SUBSTR function & Access Path Selection0_24_Bruce.Williamson@PSIR.IE31_Wed, 12 Sep 2001 18:59:29 +0100402_iso-8859-1 Howzit Penny?
Try the following:
SELECT X.MANAGER_ID , E.NAME , X.DEPTID FROM ( SELECT D.MANAGER_ID AS MANAGER_ID , D.DEPTID AS DEPTID , SUBSTR(D.MANAGER_ID,1,6) AS MANAGER_X FROM PS_DEPT_TBL D ,PSTREENODE T WHERE D.DEPTID = T.TREE_NODE AND T.TREE_LEVEL_NUM = ( SELECT T1.TREE_LEVEL_NUM + 1 ... ) AS X , PS_EMPLOYEES E WHERE E.EMPLID = MANAGER_X ... rest of query follows [...]
17350 58 63_Re: Question about DB2 Data sharing and Group naming convention16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Wed, 12 Sep 2001 13:59:30 -0400463_us-ascii The installations that I have seen all start the group name with 'DSN'. For example, DSNP1 for production, DSNP2 for a second production data-sharing system, DSND1 for development, DSNT1 for test, etc.
HTH,
Rick CReech
Mike Dupuis cc: Sent by: DB2 bcc: Data Base Subject: Question about DB2 Data sharing and Discussion List Group naming convention [...]
17409 23 16_Re: wtc disaster13_Joel Pankonin26_joel.pankonin@ZURICHNA.COM31_Wed, 12 Sep 2001 13:18:14 -0500356_us-ascii I want to offer my condolences to all the victims of this tragic act on humanity.
This nation was founded on our faith in God and for that we have been blessed above all other nations. Now is a time to seek His presence in our time of sorrow. We need to pray for our leaders to make the right decisions and the healing of this nation. [...]
17433 199 37_Re: The World Trade Center Discussion15_Joaquim Carmona34_joaquim.carmona@CIRCULOLEITORES.PT31_Wed, 12 Sep 2001 19:19:05 +0100582_iso-8859-1 Sorry guys, but is this a DB2 Discussion List or an American Discussion List? I never saw here, any discussion or any movement against other horrors that unfortunately we saw and heard all over the world. I understand the pain and horror that everybody, including myself, is dealing with, but, and I apologize to be so cruel, there is no difference between horrors and pains. Is not the skin color, the religious flavor or any other flag that makes the difference or makes an horror better or worst then other. The difference is between my horror and yours. And, as [...]
17633 74 40_World trade center - World Day of Prayer14_Bruce Bernhart25_bbernhart@NEWLOGIXINC.COM31_Wed, 12 Sep 2001 13:25:32 -0500431_iso-8859-1 Like many others, I find prayer to be the best response to the World Tarde Center tragedy.
Tomorrow, Sept 13 is a world day of prayer. Check out http://www.unityworldhq.org/wdop/index.html for details.
If you would prefer to read details in Spanish, French, or German, then start at http://www.silentunity.org/
No particular religous affiliation required...
Let there be peace on Earth. [...]
17708 132 40_Re: AIX - R/390 version compatibility???12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 12 Sep 2001 11:47:24 -0700371_us-ascii OS/390 on my RS/6000 box? Yeeha! I can't wait to show my nt/x-head coworkers what a real OS looks like ;-) . I'll have to look up the P390 feature code and slip one into the next configuration... I wonder if there's a "personal edition" version of this software? Thanks for bringing this to our (mine anyway) collective attention Aurora! Wish I could help. [...]
17841 110 30_Re: SQL Performance Comparison14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 12 Sep 2001 13:30:59 -0500440_us-ascii Simple mathematics is your proof for the potential costing difference. This has been true since the beginning and used to be in all performance courses regarding key selection. However, CHAR takes into effect x'00' through x'ff', and not just the 36 non-bit values.
Can it effect access path selection? In certain cardinality cases, yes. Is this a major concern? Probably not but should be considered in key selection. [...]
17952 50 73_Re: DB2 OS/390: Java App on server holding locks on DB2 OS/390 Tablespace12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 12 Sep 2001 21:55:15 +0200504_iso-8859-1 Hi, We had a bad experience with JAVA as well, for the time being we use INACTIVE , 0 (zero). We still search it.
Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net ----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, September 12, 2001 7:45 PM Subject: DB2 OS/390: Java App on server holding locks on DB2 OS/390 Tablespace [...]
18003 136 21_Re: Buffer pool usage14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 12 Sep 2001 13:41:13 -0500404_iso-8859-1 Your reaction method is future changes based on prediction of what has passed, and suffers from the same complaints you listed about "prediction".
In fact, changing on the fly dynamically can have even more damaging effects, adjusting downward on past frequent results when just the opposite is needed, and vice versa, which is what has occurred with those types on tools already. [...]
18140 109 25_Re: America the Beautiful12_Marc Sennett23_msennett@TEKSYSTEMS.COM31_Wed, 12 Sep 2001 15:17:36 -0500582_us-ascii John and DB2 list
Looks like you couldn't read the first version. Again, this is worth reading and passing on.
Subject: America The Beautiful > > In the wake of the national tragedy of yesterday, this is worth reading. > We still live in the greatest country in the world and sometimes we forget > what we have worked so hard for it. This, from a Canadian newspaper, is > worth sharing. > > AMERICA: THE GOOD NEIGHBOR > > Widespread but only partial news coverage was given recently to a > remarkable editorial broadcast from Toronto by Gordon Sinclair, [...]
18250 49 40_Re: AIX - R/390 version compatibility???12_McKown, John22_JMckown@HEALTHAXIS.COM31_Wed, 12 Sep 2001 14:07:56 -0500579_- > -----Original Message----- > From: tim malamphy [SMTP:timalamphy@YAHOO.COM] > Sent: Wednesday, September 12, 2001 1:47 PM > To: DB2-L@RYCI.COM > Subject: Re: AIX - R/390 version compatibility??? > > OS/390 on my RS/6000 box? Yeeha! I can't wait to show > my nt/x-head coworkers what a real OS looks like > ;-) . I'll have to look up the P390 feature code and > slip one into the next configuration... I wonder if > there's a "personal edition" version of this software? > Thanks for bringing this to our (mine anyway) > collective attention Aurora! Wish I could help. > [...]
18300 91 14_WTC Discussion16_Brookman, Gerald30_gerald.brookman@ATOSORIGIN.COM31_Wed, 12 Sep 2001 15:29:24 -0400450_iso-8859-1 I'm originally from Missouri. The only U.S. President from Missouri was Harry Truman, who became President when Franklin Roosevelt died in April, 1945.
In his autobiography, Truman wrote that he agonized for days as President and/or a human about the moral decision to use the atomic bomb against civilian targets in Japan. He wrote that what made the decision for him was "the b****ds never once apologized for Pearl Harbor". [...]
18392 23 22_DB2 and SMP/E question14_Allison, Edith23_edith.allison@UCONN.EDU31_Wed, 12 Sep 2001 15:25:54 -0400523_iso-8859-1 We are having a problem with one of our DB2 subsystems. We seem to have 'lost' some SMP/E maintenance from several months ago - not sure how. We are wondering if anyone applies SMP/E maintenance to one DB2 subsystem and then copies libraries to other subsystems to propagate the changes. If you are doing this, we would really appreciate hearing the details of how this is done (i.e. what libraries are copied, any clists or jobs that must be run after, any other actions). Thanks in advance for your help. [...]
18416 101 15_DB2 V6 Triggers8_Ken Kane24_kkane@UBSPAINEWEBBER.COM31_Wed, 12 Sep 2001 15:30:57 -0400586_iso-8859-1 Hello All, I am a DBA at a MVS DB2 V6 shop who is about to venture into triggers. I have been assigned the task of establishing some groundrules for the documentation and usage of these triggers. Can anyone provide me with pointers or experiences which will help me compile such a document? What should we avoid as beginners, where are you storing the 'Create' DDL.., how are you documenting where Triggers exist, their action and reason for being. How do Triggers behave with utilities? I would appreciate any help at all, including horror stories and success stories. [...]
18518 97 13_WTC editorial10_Greg Retus16_gretus@PHEAA.ORG31_Wed, 12 Sep 2001 15:51:53 -0400429_us-ascii We'll go forward from this moment by Leonard Pitts Jr. of the Miami Herald
"It's my job to have something to say. They pay me to provide words that help make sense of that which troubles the American soul. But in this moment of airless shock when hot tears sting disbelieving eyes, the only thing I can find to say, the only words that seem to fit, must be addressed to the unknown author of this suffering. [...]
18616 31 20_Incredible WTC Photo13_Bethany Allee17_ballee@TIMESN.COM31_Wed, 12 Sep 2001 14:49:30 -0500798_iso-8859-1 http://www.rc51.org/host/flag.jpg
--------------------------------------------- Bethany Allee Times N Systems 1908 Kramer, Bldg. B, Ste. P Austin, TX 78758 512-821-6221
---------------------------------------------------------------------- Don't Let MS Exchange Slow You Down.
The TNS 1600 M: 1) Improves Transaction Rates 2) Boosts Price-to-Performance Ratio 3) Future-Proofs Scalability
Boost your Exchange Performance TODAY. Join the Times N Systems' Evaluation Program: http://www.timesn.com/products/evalform.htm
================================================ 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.
18648 79 26_Re: DB2 and SMP/E question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 12 Sep 2001 16:07:34 -0400386_iso-8859-1 Edith, What works for us:
We never apply SMP/E to our operational datasets. We have an environment which is SMP/E only. We do all the maint there. After APPLY, we copy over to each subsystem the datasets which are referenced by:
1) the subsystem address spaces 2) the PROCs provided with DB2 3) ISPF (and BIND anything where a BIND was generated by SMP/E) [...]
18728 179 21_Re: Buffer pool usage11_Kwan, James18_James_Kwan@BMC.COM31_Wed, 12 Sep 2001 15:20:27 -0500508_iso-8859-1 Richard,
If someone can "predict" future, then there won't be a future for the rest of us. :)
This is my understanding of 2 approaches being discussed.
1) You collect a period of data (eg a weekly/monthly data) and use activity pattern to detemine an optimal buffer size value for each period.
2) You collect data constantly, and based on the usage for the last intervals (5, 10, 15 minutes) you make a decision as to whether you need to make some changes or not. [...]
18908 64 26_Re: DB2 and SMP/E question11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Wed, 12 Sep 2001 15:22:37 -0500318_us-ascii We are OS/390 2.9 DB2 6.1. We have 7 DB2 subsystems on 3 mainframes. One Target lib, one Distribution lib. After the PTF's are received they are tested on one LPAR then the some source and all of the loadlib's and CLIST's, Panels.... etc. are moved to the other boxes. We try to keep them in sync... : ) [...]
18973 112 26_Re: DB2 and SMP/E question10_Bill Disch23_bill.disch@GENMILLS.COM31_Wed, 12 Sep 2001 15:29:02 -0500639_iso-8859-1 Edith,
I have had success with the identical process since DB2 1.3 in 1987!
Bill Disch Technical Services (763) 764-7055 bill.disch@genmills.com
-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Wednesday, September 12, 2001 3:08 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 and SMP/E question
Edith, What works for us:
We never apply SMP/E to our operational datasets. We have an environment which is SMP/E only. We do all the maint there. After APPLY, we copy over to each subsystem the datasets which are referenced by: [...]
19086 133 26_Re: DB2 and SMP/E question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 12 Sep 2001 16:39:22 -0400430_iso-8859-1 Bill, In my case since 1.1 in 1985. This works, so I am reluctant to do it another way. I hope the encroaching 'Unixy' nature of Z/OS does not take away this capability.
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Bill Disch [mailto:bill.disch@GENMILLS.COM] Sent: Wednesday, September 12, 2001 4:29 PM To: DB2-L@RYCI.COM Subject: Re: DB2 and SMP/E question [...]
19220 61 26_Re: DB2 and SMP/E question12_Sue Janowitz22_sjanowitz@MEDIAONE.NET31_Wed, 12 Sep 2001 16:46:01 -0400560_iso-8859-1 At my recent job as a DB2 SYSADM, I had only 1 SMP/E environment, from which I maintained multiple DB2 subsystems (usually 4). If the maintenance did not affect hundreds of loadmods and other modules, I would check the APPLY CHECK and APPLY report called something like UPDATED ELEMENT REPORT. It is the same for both Apply Check and Apply - it shows which elements, in which libraries, are updated. Those are the only ones I had to copy over; any actions that had to be done in all environments would be pointed to by Action Doc Holds. If you [...]
19282 45 26_Re: DB2 and SMP/E question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 12 Sep 2001 16:54:11 -0400454_iso-8859-1 Edith, In addition to the method I mentioned a few minutes ago: We back up our SMP/E environment before and after adding maintenance. I guess we should start doing periodic backups in addition.
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Allison, Edith [mailto:edith.allison@UCONN.EDU] Sent: Wednesday, September 12, 2001 3:26 PM To: DB2-L@RYCI.COM Subject: DB2 and SMP/E question [...]
19328 21 26_Re: DB2 and SMP/E question10_Bill Disch23_bill.disch@GENMILLS.COM31_Wed, 12 Sep 2001 16:00:02 -0500477_iso-8859-1 Eric, I guess the old adage "If it ain't broke, don't fix it" applies here. That's why I've stayed with DB2 and OS/390 for so long - it rarely breaks.
Bill Disch Technical Services (763) 764-7055 bill.disch@genmills.com
===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
19350 96 37_Re: The World Trade Center Discussion11_Doug Fuerst21_doug@BKASSOCIATES.NET31_Wed, 12 Sep 2001 16:23:44 -0400609_us-ascii Mr. Morrill: I also agree with Mr. Vernon's assessment in this post. All civilized people abhor senseless violence, it is part of what makes us civilized. However, one must fight fire with fire. If the Romans had defended the empire better from the Mongols, they might have survived a few more years. But they responded in a more civilized fashion than their Mongol invaders. And they lost. Or perhaps you remember the American Revolution? The British (sorry to our British allies) marched in a line with nice redcoats and complained that the Americans shot from behind trees and rocks. Perhaps [...]
19447 47 26_Re: DB2 and SMP/E question12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 12 Sep 2001 13:36:31 -0700585_us-ascii My client applies all maintenance to a system programmer sand box region. Then all related libraries (load, exit, SPF lib's, clist, etc) are copied to a test db2 and then subsequently after testing to prod. The exits are regenn'd and ZPARMS assembled and binds are done on each set of moves. Works really well with very minimal problems. --- "Allison, Edith" wrote: > We are having a problem with one of our DB2 subsystems. We seem to > have > 'lost' some SMP/E maintenance from several months ago - not sure how. > We > are wondering if anyone [...]
19495 153 37_Re: The World Trade Center Discussion17_Haynes, Michael A22_michael.haynes@NWA.COM31_Wed, 12 Sep 2001 16:21:47 -0500355_iso-8859-1 Folks,
It has become apparent that we are all deeply disturbed by the events that have transpired in the last couple of days. We are searching for reason in the midst of chaos - solution in the wake of uncertainty.
For the sake of finding some solace, somewhere, may I suggest we return to the focus of this discussion, DB2. [...]
19649 124 37_Re: The World Trade Center Discussion12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Wed, 12 Sep 2001 16:27:27 -0500594_iso-8859-1 Please, let me jump in and defend Mr Morrill very quickly.
John Morrill very kindly spoke to me "off list". I had misunderstood his intentions. Both he and Linda stated that the mentality of bombing everyone mindlessly and without due cause (bomb them all and let God sort them out) were objectionable to them. I completely agree with both them. So, please, before anyone else reads my email, or misunderstands John Morrill's, please understand that I made the original mistake, and do not want anyone else to read my posting and respond to it. Mr Morrill and I (as well [...]
19774 31 33_Fetching Dynamic Queries in Cobol11_David Nance16_DWNance@FHSC.COM31_Wed, 12 Sep 2001 17:51:42 -0400403_US-ASCII DB2 V6 OS/390
I have a question from one of our developers about having a dynamic fetch. He builds his query based on inputs from the customer. If gets certain criteria from the customer may have to fetch two additional columns of data. We were trying to figure out if there was a way to do a dynamic fetch or use and evaluate or if else clause to get to the correct fetch. Thanks. [...]
19806 90 73_Re: DB2 OS/390: Java App on server holding locks on DB2 OS/390 Tablespace12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 12 Sep 2001 14:33:01 -0700433_us-ascii We're running INACTIVE, 3600 in production and INACTIVE, 900 in test. As long as we have the JAVA programmers not use EJBs and CMP Beans, we're fine (provided the JAVA programmers issue commits on their own transactions). Only have a problem with locks if the programmers don't manually issue a commit. EJBs and CMP is another issue as are transaction managed beans. We're still working out all the problems with this. [...]
19897 140 21_Re: Buffer pool usage14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 12 Sep 2001 15:51:57 -0500352_iso-8859-1 Tom,
If a tool reacts to just what happened, dynamically changes the BPs, the buffer pools get flushed, which dramatically increases async and sync I/O's for that pool, for data that should have been resident. This affects the pool usage, which affects your dynamic monitoring, and then the snowball and performance degradation. [...]
20038 230 21_Re: Buffer pool usage14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 12 Sep 2001 15:57:49 -0500549_iso-8859-1 James,
I am well aware of not only those 2 tools (BMC and Responsive Systems), but of another coming on the market (see IBM's announcements yesterday).
What I am concerned in is performance. Myself, and others in YL&A, spend a massive amount of time working with tuning buffer pools in high performance environments. I wish we could turn over complete dynamic adjustment to a tool that has no abstract reasoning, but then that is impossible. Generic tools have generic use. High performance systems are something else. [...]
20269 22 21_Re: Buffer pool usage14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 12 Sep 2001 16:10:30 -0500533_iso-8859-1 DB2 Listers,
I apologize! I did not intend to get involved in a "discussion" with two staff of the vendor regarding the benefits of their tool versus all others, and other techniques.
Richard Yevich YL&A < http://www.YLAssoc.com >
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20292 74 21_Re: Buffer pool usage14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 12 Sep 2001 18:13:35 -0400312_ISO-8859-1 James, One of the critical points you have missed regarding pool tuning is quite simple. Every time you change a pool size, you invalidate all the pages so everything has to read into the pool again. This temporarily destroys both your system and application performance from the high I/O rates. [...]
20367 82 24_Re: Synchronous RECEIVE?12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 12 Sep 2001 14:45:24 -0700574_us-ascii Mebert I don't know if it would be useful, but have you looked at REXEC processing. It allows you to exec various commands, scripts, programs, etc on another processor and wait for the results to happen in the originating script/job. We do this all the time for various servers. We have a mainframe job that executes and issues REXEC commands to a server and waits for the script to finish before completing and allowing the scheduler to continue with the next job in the process. Not sure if this will do or is useful, but its an idea. --- mebert@AMADEUS.NET [...]
20450 66 21_Re: Buffer pool usage14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 12 Sep 2001 18:28:35 -0400382_ISO-8859-1 A BP hit ratio may or may not be the actual indicator, but only one of several. Having a hit ratio of 100% does not mean your pool is too big. Now 100% and no I/O at all usually does. My goal for hit ratios is 95% for ndexes, and > 70% for data. Sometimes you can do better, and sometimes you can't come close. It all depends on your system, applications, and data. [...]
20517 102 35_Re: A question about a simple query10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 13 Sep 2001 09:59:18 +1000435_us-ascii Hi Fabrizio,
I am not much familiar with AIX, so not sure abt the realtimes displayed in ur o/p.
But the original question was not abt the difference between SELECT * and SELECT COUNT(*).
It was abt the diff. between "SELECT col1 GROUP BY col1" and "SELECT col1, count(*) GROUP BY col1". With or without the Count(*), DB2 will still produce the same o/p; the count(*) just gives u the count as well. [...]
20620 59 26_Re: DB2 and SMP/E question19_John H. Maenpaa Jr.24_john_maenpaa@YLASSOC.COM31_Wed, 12 Sep 2001 19:44:33 -0500591_US-ASCII > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Myron Miller > Sent: Wednesday, September 12, 2001 3:37 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 and SMP/E question > > > My client applies all maintenance to a system programmer sand box > region. Then all related libraries (load, exit, SPF lib's, clist, etc) > are copied to a test db2 and then subsequently after testing to prod. > The exits are regenn'd and ZPARMS assembled and binds are done on each > set of moves. Works really well with very minimal problems. > [...]
20680 63 26_Re: DB2 and SMP/E question19_John H. Maenpaa Jr.24_john_maenpaa@YLASSOC.COM31_Wed, 12 Sep 2001 19:47:02 -0500591_US-ASCII > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Myron Miller > Sent: Wednesday, September 12, 2001 3:37 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 and SMP/E question > > > My client applies all maintenance to a system programmer sand box > region. Then all related libraries (load, exit, SPF lib's, clist, etc) > are copied to a test db2 and then subsequently after testing to prod. > The exits are regenn'd and ZPARMS assembled and binds are done on each > set of moves. Works really well with very minimal problems. > [...]
20744 57 31_Re: can two cursor be appended.13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 12 Sep 2001 19:49:00 -0500358_iso-8859-1 Praveen,
You have UNIONs or JOINs as relational operations. If these are independent queries with the same number of columns and compatible datatypes, then code a UNION (ALL). If you are joining the results in your program, then yes, combine these into a single join query. But is this is a pure "append", then it may not be possible. [...]
20802 105 29_Re: Sub-select in ON clause??13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 12 Sep 2001 19:49:21 -0500417_iso-8859-1 Balaji,
In V6 you can put expressions, including host variables, but not subqueries, in your ON clause.
The problem I find with Outer Joins is the common misunderstanding between WHERE clause predicates and ON clause predicates. And to confuse the issue we have preserved row and NULL supplying tables, to which different rules apply depending on which table the predicates are applied. [...]
20908 40 26_Re: DB2 and SMP/E question12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 12 Sep 2001 16:53:00 -0400605_- We apply maint to SMP libs only then copy those to other Subsystem specific libs. The libs we copy are: SDSNLOAD SDXRRESL SDSNMACS SDSNDBRM SDSNSPFM SDSNSPFP SDSNPFPE SDSNSPFS
Probably not nec. to copy all of these, but this works for us. >>> DB2-L@RYCI.COM@inter2 09/12/01 02:25PM >>> We are having a problem with one of our DB2 subsystems. We seem to have 'lost' some SMP/E maintenance from several months ago - not sure how. We are wondering if anyone applies SMP/E maintenance to one DB2 subsystem and then copies libraries to other subsystems to propagate the changes. If you are doing [...]
20949 28 19_Re: DB2 V6 Triggers12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 12 Sep 2001 17:13:00 -0400608_- Make sure you have UQ46393 applied.
>>> DB2-L@RYCI.COM@inter2 09/12/01 02:48PM >>> Hello All, I am a DBA at a MVS DB2 V6 shop who is about to venture into triggers. I have been assigned the task of establishing some groundrules for the documentation and usage of these triggers. Can anyone provide me with pointers or experiences which will help me compile such a document? What should we avoid as beginners, where are you storing the 'Create' DDL.., how are you documenting where Triggers exist, their action and reason for being. How do Triggers behave with utilities? I would appreciate any [...]
20978 66 32_Re: OS/390 V6 - Binding Triggers10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 13 Sep 2001 11:38:55 +1000386_us-ascii Hi Joan,
We had this problem a few months back, and also I think there were a couple of threads recently on the list (Search for -189). IBM has an APAR for this. The problem arises for pre-V5 created tablespace where CCSID of 0 apparently meant system default. One way out for us (before the fix was applied) was to ALTER the CCSID of the database to the reqd one. [...]
21045 59 46_Cincinnati, OH DB2 User Group Meeting 09/24/0114_Gill, Joseph G19_joseph.gill@EDS.COM31_Thu, 13 Sep 2001 00:15:44 -0400729_iso-8859-1 You are invited to attend the next Cincinnati DB2 User Group meeting featuring Phyllis Groezinger of IBM, giving presentations on: · DB2 V7 Highlights and Where Do We Go From Here? · Distributed DB2 Technical Discussion RESERVATIONS REQUIRED! To reserve a seat, send an email to cincy-db2-users-event-registration@yahoogroups.com with your name, and company name. WHEN: Monday, September 24, 2001, 1:00 - 4:00 PM WHERE: Procter & Gamble Customer Logistics & Financial Services Office 8500 Governor's Hill Drive Mason, Ohio DIRECTIONS: From Cincinnati or Columbus: Take I-71 to Exit 19 Fields-Ertle Road to Mason-Montgomery Road to Governor's Hill Drive [...]
21105 136 16_Re: wtc disaster23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 13 Sep 2001 07:07:32 +0100403_- Doug As before - should any of the companies need support in any way from this list then there is many of us prepared to assist.
I am sure I speak for Sony Management and Workers Worldwide when I say that we would offer as much human support as we could to help get any of the affected teams back up and running. Our biggest problem is not knowing who to speak with to offer this support. [...]
21242 171 35_Re: A question about a simple query10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 13 Sep 2001 16:40:31 +1000412_us-ascii Hi Terry,
I just realised that this shd be true for a GroupBy with any grouping function and not just count(*). A quick test with a MAX function confirms the same.
Based on the Omegamon trace, it looks like when we code a count(*) function, DB2 determines that the count is reqd and counts the rows and passes it to the data manager, thereby fetching the data and the count as 1 row. [...]
21414 122 35_Re: A question about a simple query13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Thu, 13 Sep 2001 02:26:53 -0500408_us-ascii Kals,
Thanks again for the detailed information. Still I feel there is no reason why the COUNT(*) (or any column function) can evaluate the GROUP within data manager (or index manager), but without the column function, all rows of the group must be returned to RDS.
To me, this is a bug, and something that should be reported to IBM. There is no chance of solving this otherwise. [...]
21537 34 21_Re: Buffer pool usage10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Sep 2001 09:49:47 +0200412_us-ascii Hi Joel
I absolutely agree: if you have a 100% BP hit ratio doesn't mean that your BP is big, but it may mean that you can reach this hit ratio using smaller BP because, as you said, it depends on 'data complex' (ie system,application,data) as a whole. I experimented this fact many times, expecially after a BP tuning. BP hit ratio is a very useful 'indirect detector' and it's undeniable. [...]
21572 159 35_Re: A question about a simple query11_Eric Wilkin18_eric.wilkin@NBB.BE31_Thu, 13 Sep 2001 10:08:06 +0200437_iso-8859-1 Terry, Kals Thanks for your interest for this problem. I will reported it to IBM.
Eric Wilkin National Bank of Belgium SYDS-DB tel +32 (0)2 221 45 99 fax +32 (0)2 221 30 92
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] On Behalf Of Terry Purcell Sent: donderdag 13 september 2001 09:27 To: DB2-L@RYCI.COM Subject: Re: A question about a simple query [...]
21732 43 42_Re: Recovery of Table with Identity Column12_Simon George26_simon_x_george@HOTMAIL.COM31_Thu, 13 Sep 2001 09:14:36 +0100
21776 190 45_Re: READ ONLY status after an Full image copy22_S, Sanjeev (Cognizant)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 13 Sep 2001 14:17:43 +0530586_iso-8859-1 Balbir,
I meant to ask do you have any entry in SYSCOPY which is full IC entry ? This is for the tablespace which are in RO. Are those tablespace having copy pending status?
Regards, Sanjeev
> -----Original Message----- > From: Balbir Chaudhry [SMTP:Balbir.Chaudhry@SWISSCOM.COM] > Sent: Wednesday, September 12, 2001 8:14 PM > To: DB2-L@RYCI.COM > Subject: AW: READ ONLY status after an Full image copy > > Hi Sanjeev > > Thanks a lot. > I have done a query and as you said all records are deleted which were > created 30 days before. > But i have [...]
21967 45 43_Re: Downloading APARs - DB2 UDB V7.1 on AIX16_Adrian Challinor29_adrian.challinor@OSIRIS.CO.UK31_Thu, 13 Sep 2001 09:47:32 +0100403_iso-8859-1 Marshall,
> >I've identified an APAR (IY17104) that I'd like to apply to our DB2 UDB > V7.1 on > >AIX environment. The APAR is included in Fixpak 3, however, I'd > rather not > >apply FP 3 just yet for a variery of reasons. > > > >My question - is it possible to download & apply only APAR > IY17104 (or any > >APAR, for that matter) without downloading & applying all of FP 3? > [...]
22013 181 45_AW: READ ONLY status after an Full image copy15_Balbir Chaudhry28_Balbir.Chaudhry@SWISSCOM.COM31_Thu, 13 Sep 2001 11:21:38 +0200600_iso-8859-1 Sanjeev,
Yes there are entries in SYSCOPY which are full IC entries. The TS do not have copy pending state. Only RO.
Best regards Balbir
-----Ursprüngliche Nachricht----- Von: S, Sanjeev (Cognizant) [mailto:SSanjeev@CAL.COGNIZANT.COM] Gesendet am: Donnerstag, 13. September 2001 10:48 An: DB2-L@RYCI.COM Betreff: Re: READ ONLY status after an Full image copy
Balbir,
I meant to ask do you have any entry in SYSCOPY which is full IC entry ? This is for the tablespace which are in RO. Are those tablespace having copy pending status? [...]
22195 21 38_DB2 V6.1 for OS/390 and XML Extender ?19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Thu, 13 Sep 2001 11:19:44 +0100543_us-ascii I know that text, video and audio extenders are provided with DB2 v6 (according to the "What's New" book.
But is the XML extender supported ? And if so, can you point me to any documentation, information on how to order it, etc.
TIA
Phil Nelson Senior DBA Scottish Widows
================================================ 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.
22217 56 33_FW: UDF Question - Raising errors14_Scott Trometer22_scott.trometer@RCI.COM31_Thu, 13 Sep 2001 07:00:32 -0500644_iso-8859-1 I apologize if this is a re-post. I wasn't sure if it had mad it thru and hadn't received any feedback...
-----Original Message----- From: Trometer, Scott Sent: Wednesday, September 12, 2001 7:26 AM Subject: UDF Question - Raising errors
Listers,
DB2 UDB for 0s/390 V6 Os/390 V2.7 WLM Goal Mode COBOL UDF
I am trying to create an External UDF that either raises an error condition or sets the SQLSTATE and message for certain criteria. I have tried the RAISE_ERROR function and also physically moving values into the SQLSTATE and SQLERRMC fields...both to no avail, my calling SQL from SPUFI [...]
22274 114 43_Re: SUBSTR function & Access Path Selection14_Craig McKellar26_craig.mckellar@BIGPOND.COM31_Thu, 13 Sep 2001 22:00:27 +1000600_us-ascii This not directly related to the substr being indexable or not but other string functions like strip is indexable but rtrim is not. There seems some anomolies between functions on what is and what isn't.
Bruce.Williamson@PSIR.IE wrote:
> > > Howzit Penny? > > Try the following: > > SELECT X.MANAGER_ID > , E.NAME > , X.DEPTID > FROM ( SELECT D.MANAGER_ID AS MANAGER_ID > , D.DEPTID AS DEPTID > , SUBSTR(D.MANAGER_ID,1,6) AS MANAGER_X > FROM PS_DEPT_TBL D > ,PSTREENODE T > WHERE D.DEPTID = T.TREE_NODE > AND T.TREE_LEVEL_NUM = ( SELECT T1.TREE_LEVEL_NUM + 1 > ... > ) AS [...]
22389 15 30_Re: SQL Performance Comparison11_Joan Keemle25_KeemleJoanT@JOHNDEERE.COM31_Thu, 13 Sep 2001 07:16:12 -0500336_- Perhaps more important than subtle performance differences is the data itself. A good rule is "call it what it is". If it is numeric, define it as such. If it is defined as character, it will inevitably end up with character data, which will introduce a myriad of other problems - data integrity, potential for S0c7, etc. * Joan [...]
22405 169 29_Re: Sub-select in ON clause??22_Augustine, Jobi M B22524_Jobi.Augustine@CIGNA.COM31_Thu, 13 Sep 2001 08:31:16 -0400361_iso-8859-1 Hi,
Why don't you try to create a temporary table from TABLE2 with the COL1 and MAX(COL2) and Left Outer Join it with TABLE1 as follows. Hope this will help you !!
SELECT A.COL1,V1.COL2 FROM TABLE1 A LEFT OUTER JOIN (SELECT B.COL1,MAX(B.COL2) AS COL2 FROM TABLE2 B GROUP BY B.COL1) AS V1 ON A.COL1 = V1.COL1 AND A.COL2 = V1.COL2 ; [...]
22575 206 45_Re: READ ONLY status after an Full image copy13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 13 Sep 2001 07:43:32 -0500514_iso-8859-1 One thing that may clear up a little confusion on this -- from Balbir's JCL example, he is not running an IBM imagecopy, but BMC copy+. This will start the objects as RO prior to copying as a means of getting a shrlevel reference copy. After the copy, the objects will be put back into the status that they were in prior to the copy (but not always into RW status). What status is this space in prior to the copy? If I were to take a guess, I would say that it's probably in RO status prior to the [...]
22782 65 16_Re: wtc disaster10_John Hardy22_john_j_hardy@YAHOO.COM31_Thu, 13 Sep 2001 08:03:40 -0500406_- I have until now resisted the urge to contribute to this thread. I have never been to America, and I have been (and am) afraid that any words which I have to say might seem trite in the face of such unprecedented catastrophe and sorrow, and so trivial amongst all the millions of words which have already been said, and which will continue to be said in the years to come about this terrible crime. [...]
22848 101 16_Re: wtc disaster14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 13 Sep 2001 15:38:03 +0200560_iso-8859-1 John,
I could not agree more on almost anything you wrote, and let me add that yesterday a German politician stood up in Parliament saying "Today we're all Americans". Our thoughts go out to those who lost their dear ones.
John Hardy schrieb: > > I have until now resisted the urge to contribute to this thread. I have > never been to America, and I have been (and am) afraid that any words which > I have to say might seem trite in the face of such unprecedented > catastrophe and sorrow, and so trivial amongst all the millions [...]
22950 95 26_wtc and pentagon disasters13_Ginger Duncan20_gingerd@TGA-JOBS.COM31_Thu, 13 Sep 2001 09:47:01 -0400296_iso-8859-1 Thank you John. I too have resisted the urge to respond. I do appreciate the compassion that has been expressed over the past few days. As for the laughing, cheering, and clapping... well, words fail me. However, I hold firm to the fact that when others are not, God is faithful. [...]
23046 100 63_Re: Question about DB2 Data sharing and Group naming convention9_Neal Cash16_nealc@US.IBM.COM31_Thu, 13 Sep 2001 09:23:19 -0400438_us-ascii I have found that this does not affect the operation of the datasharing group at all. However, there is no guarantee of that in the future. IBM recommends DSN and if I was building a datasharing group today and had complete control of naming standards I would use DSN in the group name. That does not mean your members or your group attach name should be named in this way. Following is an example of names using your info. [...]
23147 38 0_12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Thu, 13 Sep 2001 08:50:13 -0500622_iso-8859-1 We have just installed DB2 High Performance Unload here, and have run into a problem (error listed below)
UNLOAD TABLESPACE SHARED.PGMPARM COPYDDN LAST_IC SELECT * FROM TRS.PGM_PARM OUTDDN (SYSREC00) FORMAT DSNTIAUL LOADDDN (SYSPUNCH)
LSCX041 **** ERROR **** ABEND occurred in line 372 of @@168448(CUNL) ,offset 0003AA Extended name: Traitement_UNLOAD Program terminated by operating system. ABEND code = S0C1 A non-C or system routine was running at the time of ABEND Calling trace: Function Line Offset Context @@168448(CUNL) == "Traitement_UNLOAD" 372 0003AA MAIN(CHAP) 803 000C44 [...]
23186 232 16_Re: wtc disaster18_Jean-Jacques Borie18_jjborie@TEKORA.COM31_Thu, 13 Sep 2001 15:45:51 +0200421_iso-8859-1 Yep, we are all american ...
Jean-Jacques Borie Directeur recherche et développement
Tekora, changez votre conception des sites web http://www.tekora.com 17, place de la Résistance - 92130 Issy-les-Moulineaux Tél. : +33 1 55 00 10 03 - Fax : +33 1 55 00 10 10 Por: +33 660199524 jjborie@tekora.com
Pour vous inscrire à la Newsletter Tekora : http://www.tekora.com/tekora/fr/12_1.html [...]
23419 238 45_AW: READ ONLY status after an Full image copy15_Balbir Chaudhry28_Balbir.Chaudhry@SWISSCOM.COM31_Thu, 13 Sep 2001 16:02:29 +0200438_iso-8859-1 Mike
Sorry that i forgot to write this: **** C O P Y P L U S F O R D B 2 V6R1.00 *****
The status prior to copy was always RW.
Thanks a lot in advance
Balbir
-----Ursprüngliche Nachricht----- Von: Vaughan, Mike [mailto:Vaughan.Mike@PRINCIPAL.COM] Gesendet am: Donnerstag, 13. September 2001 14:44 An: DB2-L@RYCI.COM Betreff: Re: READ ONLY status after an Full image copy [...]
23658 48 33_Re: UDF Question - Raising errors14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 13 Sep 2001 08:45:39 -0500409_- Scott,
Are you sure that you haven't accidently overwritten SQLSTATE or the message fields? Have you successfully used SQLSTATE or is this the first time (ie can you clone working code)?
If you like, mail me the program and UDF DDL and I'll see if anything leaps out.
James Campbell
On Wed, 12 Sep 2001 07:25:47 -0500, Scott Trometer wrote: [...]
23707 200 45_Re: READ ONLY status after an Full image copy13_John Arbogast32_john.arbogast.cquz@STATEFARM.COM31_Thu, 13 Sep 2001 09:07:33 -0500656_- I have seen entries in the BMCSYNC table without a corresponding entry in the BMCUTIL table cause this problem. Might be something to look into.
-----Original Message----- From: Vaughan.Mike@PRINCIPAL.COM [mailto:Vaughan.Mike@PRINCIPAL.COM] Sent: Thursday, September 13, 2001 7:44 AM To: DB2-L@RYCI.COM Subject: Re: READ ONLY status after an Full image copy
One thing that may clear up a little confusion on this -- from Balbir's JCL example, he is not running an IBM imagecopy, but BMC copy+. This will start the objects as RO prior to copying as a means of getting a shrlevel reference copy. After the copy, the objects will [...]
23908 41 16_Re: wtc disaster16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Thu, 13 Sep 2001 15:24:29 +0100487_us-ascii now now Eric,
don't be racist...
"Pearson, Eric L," To: DB2-L@RYCI.COM Subject: Re: wtc disaster
12/09/2001 18:09 Please respond to DB2 Data Base Discussion List
OF COURSE the IMS-L will get the racist stuff. Everyone knows IMS folks are inferior to DB2ers ;-}
Regards, eric pearson NS ITO Database Support [...]
23950 49 42_Re: Recovery of Table with Identity Column14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 13 Sep 2001 09:13:04 -0500445_- Iris
When DB2 needs to allocate an identity number, it acquires a block of numbers (the size is specified by CACHE value) and updates SYSSEQUENCES to be old_MAXASSIGNEDVAL + CACHE. The first number acquired is used for the required identity number. Until the cache is exhausted, further numbers are obtained from the internal buffer - not SYSSEQUENCES. This is why there can be holes in the number assignments - unless CACHE is 1. [...]
24000 51 26_Re: DB2 and SMP/E question11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Thu, 13 Sep 2001 09:27:58 -0500545_iso-8859-1 In my previous job, I had a sandbox system, one test DB2 and one production DB2. Each system had it's own libraries for the datasets needed to run a system. At my current job, we have 8 DB2 systems sharing a common set of libraries. All SMP/E work is done against a maintenance copy (MAINT is one of the dataset qualifiers). As we move the maintenance to each DB2, we just change the dataset names in the started task procs and the DSNUTILB procs. When we move it to the 2 production systems, we copy from the MAINT libraries to [...]
24052 61 16_Re: wtc disaster16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 13 Sep 2001 10:37:08 -0400518_iso-8859-1 I used to do IMS myself but outgrew it.
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Aurora Dell'Anno [mailto:Aurora_E_DellAnno@CANDLE.COM] Sent: Thursday, September 13, 2001 10:24 AM To: DB2-L@RYCI.COM Subject: Re: wtc disaster
now now Eric,
don't be racist...
"Pearson, Eric L," To: DB2-L@RYCI.COM Subject: Re: wtc disaster [...]
24114 73 26_Re: DB2 and SMP/E question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 13 Sep 2001 10:53:37 -0400658_iso-8859-1 Tina, How do you handle the ISPF libraries? Do you have separate LOGON PROCs for users of each subsystem?
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Tina Hilton [mailto:Tina.Hilton@BMSUS.COM] Sent: Thursday, September 13, 2001 10:28 AM To: DB2-L@RYCI.COM Subject: Re: DB2 and SMP/E question
In my previous job, I had a sandbox system, one test DB2 and one production DB2. Each system had it's own libraries for the datasets needed to run a system. At my current job, we have 8 DB2 systems sharing a common set of libraries. All SMP/E work is done against a maintenance [...]
24188 12 40_Re: AIX - R/390 version compatibility???14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 13 Sep 2001 09:55:39 -0500317_- try https://app-06.www.ibm.com/servers/resourcelink
James Campbell
================================================ 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.
24201 17 32_DB2 High Performance Unload v1.112_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Thu, 13 Sep 2001 10:18:23 -0500413_iso-8859-1 Good Morning again, We didn't receive a response to our first posting, so I'll ask a different question...does anyone use this product?
many thanks, john
================================================ 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.
24219 231 29_Re: Sub-select in ON clause??11_David Nance16_DWNance@FHSC.COM31_Thu, 13 Sep 2001 11:17:13 -0400509_US-ASCII Jobi, This solution does work, however it would be a tablespace scan on table2. Will also, materialize the resultset, which you then join with and have no index on the result set. If it is a small table, maybe not a big deal. The way to get around that is to add table1 into the view along with it's where conditions and the join condition to table2 that way you have used the index and gotten the materialized result set down to just the rows that would return data and is usually much faster. [...]
24451 19 26_Re: DB2 and SMP/E question14_Allison, Edith23_edith.allison@UCONN.EDU31_Thu, 13 Sep 2001 11:17:55 -0400527_iso-8859-1 To all of you who responded to our request for information, thank you. We are reviewing the responses and I think we'll have follow-up questions later. Thank you again for this invaluable input.
Edith Allison Julie Johnson System Programmers University of Connecticut
================================================ 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.
24471 35 16_Buffer pool tool14_Joseph Fuentes17_Joedbadb2@AOL.COM29_Thu, 13 Sep 2001 11:22:08 EDT220_US-ASCII Anyone, IBm announce this week new buffer tool but not the same as buffer pool tool they before did. I cannot get right answer from IBM. Does anyone know if old Buffer Pool Tool is for V7??
Joseph
24507 59 13_Wasted space?0_32_Gordon.P.PROUTY@ODOT.STATE.OR.US31_Thu, 13 Sep 2001 08:23:40 -0700473_iso-8859-1 We are in the process of preparing for a move of our photo images from DB2 on OS2 to DB2 V6 on OS390. The images on the OS2 are stored in blob format. The image will be stored as varchar for bit data on the OS390.
I believe that if I use the following DDL to create the tablespace\table I will be wasting physical storage space. By defining the bufferpool as 32k and the row as being 20k I will be wasting 12k as I can only get one 20k row per page. [...]
24567 238 43_Re: SUBSTR function & Access Path Selection13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Thu, 13 Sep 2001 08:47:00 -0500369_iso-8859-1 This was rejected due to 250 line limit (twice) ....apologies if it did send 2 or 3 times ......
Penny,
The only additions I have to Bruce's NTE example is, that for indexability prior to V7, then the NTE must be materialized. The example below is most likely to be merged, and therefore not give you the indexability you were hoping for. [...]
24806 103 43_FW: SUBSTR function & Access Path Selection13_Penny Treptow21_Penny.Treptow@UAL.COM31_Thu, 13 Sep 2001 10:27:29 -0500586_- Jeff,
Thanks - the nested table expression with the DISTINCT did the trick - an index scan on PS_EMPLOYEES was used. I found it interesting that without the DISTINCT, the nested table expression fell back to the tablespace scan on PS_EMPLOYEES.
Thanks again! (Penny Treptow for Jim Hannis) DBA's United Airlines
-----Original Message----- From: Jeff.A.L'Italien@aexp.com [SMTP:Jeff.A.L'Italien@aexp.com] Sent: Wednesday, September 12, 2001 12:48 PM To: Treptow, Penny /whqko Cc: Jeff.A.L'Italien@aexp.com Subject: Re: SUBSTR function & Access Path Selection [...]
24910 26 37_Re: Fetching Dynamic Queries in Cobol13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Thu, 13 Sep 2001 10:20:40 -0500324_- David You can use two constants in the SELECT list when the extra columns are not needed thus keeping it a fixed-list SELECT. Or you can use the variable list SELECT. I'd go for the first solution to keep the code simpler. HTH Mohammad
On Wed, 12 Sep 2001 17:51:42 -0400, David Nance wrote: [...]
24937 118 36_Re: DB2 High Performance Unload v1.114_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 13 Sep 2001 16:46:05 +0100545_iso-8859-1 or is everyone waiting for the Version 7 unload utility?
((or perhaps everyone who wants to unload quickly is using BMC/CA/CDB/Infotel (oops, that IS HP Unload!)))
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: Vernon, John [mailto:John.Vernon@TRS.STATE.TX.US] Sent: 13 September 2001 16:18 To: DB2-L@RYCI.COM Subject: [DB2-L] DB2 High Performance Unload v1.1 [...]
25056 97 26_Re: DB2 and SMP/E question11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Thu, 13 Sep 2001 10:44:03 -0500589_iso-8859-1 We don't do anything unless it's required, either something in a ++HOLD or discovered during testing. We do have the procedures in place though, and are used when we upgrade to a new release since our DB2 libraries contain the version. All ISPF access goes through a rexx, which allocates the libraries based upon the subsystem. Right now the same libraries get allocated for all subsystems, but with a simple change of an IF statment we can direct them to the maintenance libraries. We don't have the DB2 libraries in the TSO proc. The only potential problem is that they [...]
25154 75 17_Re: Wasted space?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 13 Sep 2001 16:53:12 +0100397_iso-8859-1 Pat,
I'm assuming you are on V5 otherwise you'd be using BLOBs - right??
However, the answer to your question is "yes".
This is why IBM introduced 8K and 16K page sizes, but of course not a 24K page size!
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
25230 133 21_Re: Buffer pool usage12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Thu, 13 Sep 2001 11:05:51 -0500595_iso-8859-1 Max
I completely understand your reaction to buying another product. You don't have to do that. However, having said that, there are several DB2 monitors -- I guess these are Politcally correct because everyone seems to have one -- that can monitor specific elements in DB2 and through some automation tool take action. It may not have quite the sophistication of a tool designed specifically to handle this tuning effort, but it could be made to work effectively. The issue that must be addressed is the knowledge of when and how to change buffer pools and to do so with [...]
25364 79 43_Re: Downloading APARs - DB2 UDB V7.1 on AIX12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 13 Sep 2001 09:06:54 -0700616_us-ascii I've never tried, or heard of anyone doing this. I've been watching to see if anyone else had experience with this. I usually use the opportunity for a software refresh to upgrade as much as possible with one outage. I would think that IBM puts a lot more testing effort into a fixpak than individual APARs on AIX platforms. Tim --- Marshall Fuqua wrote: > I've not had any responses to the note posted below > & thought I'd try > again. Does anyone know if this is possible (see > below) ? > > Marshall > > ======================================================================= [...]
25444 120 36_Re: DB2 High Performance Unload v1.112_Moulder, Tom19_Tom_Moulder@BMC.COM31_Thu, 13 Sep 2001 11:11:24 -0500494_iso-8859-1 good point Phil
Tom Moulder (BMC Software, Inc.) my opinions, not my employers ...
-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: Thursday, September 13, 2001 10:46 AM To: DB2-L@RYCI.COM Subject: Re: DB2 High Performance Unload v1.1
or is everyone waiting for the Version 7 unload utility?
((or perhaps everyone who wants to unload quickly is using BMC/CA/CDB/Infotel (oops, that IS HP Unload!))) [...]
25565 43 20_Re: Buffer pool tool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 13 Sep 2001 12:16:12 -0400390_ISO-8859-1 The Buffer Pool Tool for DB2 V7 is available right now, directly, from Responsive Systems, the creators of this software. It is notavailable from IBM.
It provides many features and capabilities that go far beyond the software (Buffer Pool Analyzer) anounced Tuesday by IBM.
The Buffer Pool Tool is available with many pricing options, including monthly lease. [...]
25609 134 6_Re: V816_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Thu, 13 Sep 2001 17:43:08 +0100400_iso-8859-1 Sorry guys could not resist this one...
it started with someone asking if anyone had any idea when the next release (V8) of IMS might be out...
grand one Andrew!
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 [...]
25744 115 26_Re: DB2 and SMP/E question11_Mark Turner29_mark.turner@UCDMC.UCDAVIS.EDU31_Thu, 13 Sep 2001 09:45:09 -0700469_us-ascii We currently apply maintenance to a single set of SMP/E target libs, then copy them to a single set of running (productions) libs.
We direct specific subsystems to either the target or running libs by using aliases. Each subsystem has a set of dataset aliases that can be changed to manage lib allocations. Applications use JOBLIB or STEPLIB to allocate the same dataset aliases that are used by the DB2 subsystem that the application attaches to. [...]
25860 32 15_data conversion11_Daniel Adam16_dadam@GRATEX.COM31_Thu, 13 Sep 2001 11:47:52 -0500538_- Hi, This is db2 v7.1 on OS/390 v2r10. From Spufi - select from system tables works - but insert into user tables gives this: DSNT408I SQLCODE = -332, ERROR: CHARACTER CONVERSION BETWEEN CCSID 00870 TO 01208 REQUESTED BY DSNXODTR IS NOT SUPPORTED DSNT418I SQLSTATE = 57017 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXODTR SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF9C' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION [...]
25893 40 13_Wasted space?32_Atalay Tanis (Garanti Teknoloji)22_AtalayT@GARANTI.COM.TR31_Thu, 13 Sep 2001 19:55:29 +0300201_iso-8859-1 If you have the oppurtunity of using compressed tablespace (it may not be preferrable if your mainframe does not support hardware compression) your wasting of space may be less considerable.
25934 116 17_Re: Wasted space?15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Thu, 13 Sep 2001 12:01:29 -0500300_iso-8859-1 The answer is - maybe.
Your bit field is VARCHAR. If you usually fill it, then yes, you will be wasting space. If you do not usually fill it, then probably not as much as you might fear. If your average row is less than 16K, then you will probably get 2 or more rows per page. [...]
26051 17 15_simple question14_subrata mondal25_subratamondal@HOTMAIL.COM31_Thu, 13 Sep 2001 17:09:22 +0000
26069 75 63_Re: Question about DB2 Data sharing and Group naming convention16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Thu, 13 Sep 2001 18:10:20 +0100378_us-ascii Mike,
the reason for this is future use by IBM of these letters, future reserved words etc., however I have seen many shops where the prefix IS DSN.
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 [...]
26145 44 21_Re: Buffer pool usage10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Sep 2001 19:14:21 +0200312_us-ascii Hi Tom, I'm quite surprise of your long reply, it remember me a strong reply from Dr. Mastrorilli (BMC Italy - you certainly know him) about 3rd party tools he sent me some years ago. I'm afraid I'll never be engaged by BMC or CA or. soem other vendor....Is it the time to unsubscribe from DB2-L ? [...]
26190 59 75_Re: DB2 UDB Solaris kernel configuration question - msgsys :msginfo _msgseg14_Jeffrey Benner29_Jeffrey_Benner@NOTES.NTRS.COM31_Thu, 13 Sep 2001 11:52:04 -0500587_us-ascii For those few who may have been interested in this issue of the correct setting for Solaris kernel parameter msgsys:msginfo_msgseg, here is additional information which we obtained after further research:
For servers running Solaris 7 or before, 32767 is the maximum value to which msginfo_msgseg should be set. msginfo_msgseg however is *obsolete* under Solaris 8. So are the parameters, mentioned in DB2 for Unix Quick Beginnings Chapter 6, msgsys:msginfo_msgssz and msgsys:msginfo_msgmap. These 3 parameter recommendations for DB2 may be ignored under Solaris 8. [...]
26250 38 49_DBRMs with Host Variables missing preceded Colons0_32_victor.b.hedrick@US.ANDERSEN.COM31_Thu, 13 Sep 2001 12:29:55 -0500395_us-ascii Hi,
We would like input from other IBM DB2 customers how did they fix DBRMs with host variables that are missing preceding colons. We have application (case tool) which we do not have the source code and is concern about the Bind and Rebind restrictions with both DB2 version 6 and DB2 version 7. We would like to somehow fix these DBRMs before converting to DB2 Version 7. [...]
26289 28 15_Bufferpool tool12_Billy Shears23_bill_shears@HOTMAIL.COM31_Thu, 13 Sep 2001 13:10:49 -0500579_- All,
In response to earlier question on DB2-L about the bufferpool tool.
We run the Response Systems Bufferpool Tool on Version 7 and it is great. On request of my manager I had a look also at the IBM product but Joel Goldstein's tool has a lot more to offer. Everybody can create a display/calculate tool but Joel's predict functions are great and no other tool does this. We also had a look at the BMC tool but this tool keeps changing (read destroying) your bufferpool. Joel will calculate the optimal settings for your bufferpool. Our savings where BIG. [...]
26318 48 19_Re: Bufferpool tool12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Thu, 13 Sep 2001 13:36:31 -0500458_iso-8859-1 Billy
I'm happy for you and the improvements you have been able to achieve. Congratulations.
Tom Moulder (BMC Software, Inc.) my opinions, not my employers ...
-----Original Message----- From: Billy Shears [mailto:bill_shears@HOTMAIL.COM] Sent: Thursday, September 13, 2001 1:11 PM To: DB2-L@RYCI.COM Subject: Bufferpool tool
All,
In response to earlier question on DB2-L about the bufferpool tool. [...]
26367 57 19_Re: Bufferpool tool23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 13 Sep 2001 19:37:04 +0100670_- sounds good ... stupid question .. is v7 of the bufferpool tool only for v7 db2? Joel?
thanks
Les
-----Original Message----- From: Billy Shears [mailto:bill_shears@HOTMAIL.COM] Sent: Thursday, September 13, 2001 7:11 PM To: DB2-L@RYCI.COM Subject: Bufferpool tool
All,
In response to earlier question on DB2-L about the bufferpool tool.
We run the Response Systems Bufferpool Tool on Version 7 and it is great. On request of my manager I had a look also at the IBM product but Joel Goldstein's tool has a lot more to offer. Everybody can create a display/calculate tool but Joel's predict functions are great and [...]
26425 98 24_Archive to DASD question14_Westphal, Carl27_Carl_Westphal@COMPUWARE.COM31_Thu, 13 Sep 2001 14:41:38 -0400523_iso-8859-1 We're running DB2 V6.1 on OS/390 2.10. I recently changed (or tried to) our archive process from tape to DASD. The following from JUZ:
DSN6ARVP ALCUNIT=CYL, ARCWRTC=(1,3,4), ARCWTOR=YES, ARCPFX1=D610.ARCHLOG1, ARCPFX2=D610.ARCHLOG2, ARCRETN=45, BLKSIZE=24576, CATALOG=YES, COMPACT=NO, PRIQTY=85, PROTECT=NO, QUIESCE=5, SECQTY=5, TSTAMP=NO, UNIT=3390, UNIT2=3390
On the first attempt to archive, we got the following:
10.22.26 STC02008 DSNJ001I * DSNJW307 CURRENT COPY 2 ACTIVE LOG DATA [...]
26524 98 20_Re: Buffer pool tool23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 13 Sep 2001 19:40:01 +0100469_- all this tool is the one to have ... period.
if you want info on how we use it mail me direct.
regards
Les
-----Original Message----- From: Joseph Fuentes [mailto:Joedbadb2@AOL.COM] Sent: Thursday, September 13, 2001 4:22 PM To: DB2-L@RYCI.COM Subject: Buffer pool tool
Anyone, IBm announce this week new buffer tool but not the same as buffer pool tool they before did. I cannot get right answer from IBM. Does anyone [...]
26623 67 20_Re: Buffer pool tool23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 13 Sep 2001 19:39:31 +0100459_iso-8859-1 Joel
just asked the question but again .. can v7 of your tool run on v6?
Les
-----Original Message----- From: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM] Sent: Thursday, September 13, 2001 5:16 PM To: DB2-L@RYCI.COM Subject: Re: Buffer pool tool
The Buffer Pool Tool for DB2 V7 is available right now, directly, from Responsive Systems, the creators of this software. It is notavailable from IBM. [...]
26691 126 21_Re: Buffer pool usage12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 13 Sep 2001 11:54:21 -0700630_us-ascii When I last studied buffer pool usage on OS390, I discovered that I had 2 basic profiles. A daytime profile when the onlines were active, and another when batch was released in the evening, and online usage went down considerably. I didn't notice enough variation during the daytime to justify altering the buffer pools then, and having them flushed. But each installation is different, so SYSADMs will want to do what't best for their installation. A few simple ALTER BUFFERPOOL commands launced via our existing automated operations product before batch started, and after it ended allowed us to increase nightime [...]
26818 17 28_Re: Archive to DASD question25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Thu, 13 Sep 2001 14:03:19 -0500496_iso-8859-1 Looks like it's not picking up your ACS routines. I ended up putting display statements in mine so I could figure out Storage Group, Storage Class, and Data Class. Then by using the TEST option under ACS could figure out where they were going.
================================================ 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.
26836 33 14_GMT/local time14_Winston Mangum26_Winston_Mangum@LABCORP.COM31_Thu, 13 Sep 2001 15:10:02 -0400450_US-ASCII Our CLOCKxx parameter in SYS1.PARMLIB is set W 4 hours (for Eastern Daylight Time). We are using a Template during an image copy, with the variable T&HO. The time being generated is 4 hours ahead, GMT. The Utility Guide and Reference for DB2 V7.1 states that all date/time values are set using the STCK instruction and reflect the date and time value in Greenwich Mean Time (GMT). The DB2 V7.1 install manual says an exit can be coded. [...]
26870 90 20_Re: Buffer pool tool14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Thu, 13 Sep 2001 14:21:22 -0500627_iso-8859-1 Les,
It runs on everything from V3 through V7. I just asked Joel as he is with me.
Richard
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Pendlebury-Bowe, Leslie > Sent: Thursday, September 13, 2001 1:40 PM > To: DB2-L@RYCI.COM > Subject: Re: Buffer pool tool > > > Joel > > just asked the question but again .. can v7 of your tool run on v6? > > Les > > -----Original Message----- > From: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM] > Sent: Thursday, September 13, 2001 5:16 PM > To: DB2-L@RYCI.COM > Subject: Re: Buffer [...]
26961 134 28_Re: Archive to DASD question11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Thu, 13 Sep 2001 14:29:09 -0500523_us-ascii Look into the following PTF's: UQ55984 UQ55985... : )
"Westphal, Carl" cc: Sent by: DB2 Data Subject: Archive to DASD question Base Discussion List
09/13/01 01:41 PM Please respond to DB2 Data Base Discussion List
We're running DB2 V6.1 on OS/390 2.10. I recently changed (or tried to) our archive process from tape to DASD. The following from JUZ: [...]
27096 132 28_Re: Archive to DASD question11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Thu, 13 Sep 2001 14:31:46 -0500534_us-ascii Our volumes for archive unload are mounted VOLUME=STORAGE... : )
"Westphal, Carl" cc: Sent by: DB2 Data Subject: Archive to DASD question Base Discussion List
09/13/01 01:41 PM Please respond to DB2 Data Base Discussion List
We're running DB2 V6.1 on OS/390 2.10. I recently changed (or tried to) our archive process from tape to DASD. The following from JUZ: [...]
27229 111 29_Trigger Question sqlcode -73718_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Thu, 13 Sep 2001 21:38:33 +0200374_us-ascii Hi list, We have a problem with a trigger, the first time the result from the update statement returns an sqlcode 000, the second time an sqlcode -438, that what we expected. Then we execute both statements again, the first update an sqlcode 000, that's correct and then the second update returns with an sqlcode -723. We executed the statements with DSNTEP2. [...]
27341 19 40_Statement too long... UDB V7.2 WindowsNT10_Tom Hiscox17_TomHiscox@AOL.COM29_Thu, 13 Sep 2001 15:52:41 EDT409_ISO-8859-1 Trying to delete from the top of a R.I. list (10 - 15 tables deep)with delete cascade plus triggers. Received the following: An error occurred while processing your request: java.lang.Exception: OOOOOOOOPS.... COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0101N The statement is too long or too complex. LINE NUMBER=1. SQLSTATE=54001
The stmtheap size is 16,000 4k pages. [...]
27361 135 33_Re: Trigger Question sqlcode -73722_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Thu, 13 Sep 2001 13:03:48 -0700360_iso-8859-1 If you look at the last SQLCODE of -909 it says the object has been deleted. Is it possible that the row was deleted off of the table you are trying to update?
Marty Killen SR DB2 DBA CNF INC. 503-450-2681 e-mail- killen.martin@cnf.com
"Kind words can be short and easy, but their echoes are truly endless" Mother Theresa [...]
27497 118 28_Re: Archive to DASD question21_Powers, Carol A - CNF20_Powers.Carol@CNF.COM31_Thu, 13 Sep 2001 13:05:28 -0700647_- I think you should look more closely at your SMS setup. The allocation messages you're getting look like you are not going the SMS path. You would see IGD messages if it was SMS allocation.
> -----Original Message----- > From: Westphal, Carl [SMTP:Carl_Westphal@COMPUWARE.COM] > Sent: Thursday, September 13, 2001 11:42 AM > To: DB2-L@RYCI.COM > Subject: Archive to DASD question > > We're running DB2 V6.1 on OS/390 2.10. I recently changed (or tried to) > our > archive process from tape to DASD. The following from JUZ: > > DSN6ARVP ALCUNIT=CYL, > ARCWRTC=(1,3,4), > ARCWTOR=YES, > ARCPFX1=D610.ARCHLOG1, > ARCPFX2=D610.ARCHLOG2, [...]
27616 73 33_Re: UDF Question - Raising errors14_Scott Trometer22_scott.trometer@RCI.COM31_Thu, 13 Sep 2001 15:02:55 -0500444_iso-8859-1 James fixed it. What I missed was a very important section in the Appl Prog/SQL Guide on the linkage addresses. I was not passing all the necessary info back to the SQL statement...
Thanks Loads Mr. Campbell!!
-----Original Message----- From: James Campbell [mailto:jacampbell@ACSLINK.NET.AU] Sent: Thursday, September 13, 2001 8:46 AM To: DB2-L@RYCI.COM; Scott Trometer Subject: Re: UDF Question - Raising errors [...]
27690 43 44_Re: Statement too long... UDB V7.2 WindowsNT17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Thu, 13 Sep 2001 15:46:04 -0500728_us-ascii increase your statement heap
From: Tom Hiscox @RYCI.COM on 09/13/2001 02:52 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Statement too long... UDB V7.2 WindowsNT
Trying to delete from the top of a R.I. list (10 - 15 tables deep)with delete cascade plus triggers. Received the following: An error occurred while processing your request: java.lang.Exception: OOOOOOOOPS.... COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0101N The statement is too long or too complex. LINE NUMBER=1. SQLSTATE=54001 [...]
27734 99 21_Re: Buffer pool usage12_Moulder, Tom19_Tom_Moulder@BMC.COM31_Thu, 13 Sep 2001 15:54:47 -0500526_iso-8859-1 Joel
When a pool is made smaller, DB2 drives the reclaim manager to remove the number of pages from the LRU queue that the pool was reduced by. If you reduce a pool to nothing, then all pages will be invalidated, but if you reduce a pool by a small number, then only that small number of pages are invalidated. So any other applications running would still be able to achieve high hit ratios and there would be no thrashing of pages being removed and then read back in. Just to set the record straight. [...]
27834 47 22_Re: world trade center15_Hagedorn, Linda20_lindah@EPOCRATES.COM31_Thu, 13 Sep 2001 14:50:37 -0700114_iso-8859-1 I can help OS/390 Sysprog, DB2 Sysprog, former IBM L2. 650-274-7790
Also Sun Solaris Oracle DBA.
27882 30 36_Re: DB2 High Performance Unload v1.113_John Arbogast32_john.arbogast.cquz@STATEFARM.COM31_Thu, 13 Sep 2001 12:20:11 -0500457_- We use an ISV (GASP!) and probably still will even with the "improved" V7 IBM utilities.
-----Original Message----- From: John.Vernon@TRS.STATE.TX.US [mailto:John.Vernon@TRS.STATE.TX.US] Sent: Thursday, September 13, 2001 10:18 AM To: DB2-L@RYCI.COM Subject: DB2 High Performance Unload v1.1
Good Morning again, We didn't receive a response to our first posting, so I'll ask a different question...does anyone use this product? [...]
27913 76 13_Re: HP Unload9_Al Heiden31_alheiden@NORTHWESTERNMUTUAL.COM31_Thu, 13 Sep 2001 18:00:58 -0500579_ISO-8859-1 Yes, we starting to use HP Unloader.
John, try putting the LOADDDN before the FORMAT DSNTIAUL.
I have found the HP Unloader if very picky about the order of statements.
Good Luck.
Al Heiden Information Systems Northwestern Mutual 720 E. Wisconsin Ave Room N06SE Milwaukee, WI 53202-4797 phone: 414-665-4771 fax: 414-665-1686 email: alheiden@northwesternmutual.com
-----Original Message----- From: John.Vernon [SMTP:John.Vernon@TRS.STATE.TX.US] Sent: Thursday, September 13, 2001 8:50 AM To: DB2-L Subject: Sensitivity: Personal [...]
27990 15 54_Re: How can a SQL be uniquely identified from a DBRM ?12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 13 Sep 2001 18:19:59 -0500295_- What you want depends upon exactly what you want to do. Some situations make it easier to use the section number or the statement text itself. Most of DB2 uses the statement number only to help someone find an error in the listing, not for finding out what statement to run, for example. [...]
28006 16 63_Re: Question about DB2 Data sharing and Group naming convention12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 13 Sep 2001 18:53:38 -0500329_- The guideline is to avoid conflicts with other products that need to define subsystems, with A through I for IBM and J through Z for customers. The DB2 prefix is DSN, so other products will not use that. Most other choices are safe, but following the guideline is safer, so almost all DB2 customers do use the guidelines. [...]
28023 17 63_Re: Question about DB2 Data sharing and Group naming convention25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Thu, 13 Sep 2001 19:46:11 -0500474_iso-8859-1 I've wondered about that since 1.2. What moron came up with DSN? Seems like DB2 or HDB would have been fine. Can't tell you the number of the number of JCL errors I've either committed or corrected due to DSN=DSN etc.....
================================================ 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.
28041 17 53_Re: DBRMs with Host Variables missing preceded Colons12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 13 Sep 2001 21:32:47 -0500396_- There are quite a few answers in the archives. One customer wrote a program to convert DBRMs and put it on the document file. There are a couple of pages in the V6 Technical Update red book SG24-6108 that have one of the best description. There is a program that can be downloaded from the DB2 home page ibm.com/software/db2os390 then click Download that can help you find the situations. [...]
28059 13 63_Re: Question about DB2 Data sharing and Group naming convention12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 13 Sep 2001 21:39:02 -0500402_- It seems that there was and probably still is some process that assigns the first three characters. Can you say bureaucracy?
Roger Miller, DB2 for z/OS
================================================ 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.
28073 39 40_DB2 Systems Programmer for Princeton, NJ15_Stephen J Spiro25_stephenjspiro@HOTMAIL.COM31_Thu, 13 Sep 2001 23:38:27 -0500357_- I have 2 positions, interviews immediately. Please e-mail resumés with confidence in my discretion.
Leonia, New Jersey. Permanent. Salary at least $100,000 per year. Senior DB2 Systems Programmer. 4 - midnight shift. Bonus at end of year. 24 days vacation in the first year. Excellent benefits. Major financial institution. NO RELOCATION PAID [...]
28113 78 37_Re: The World Trade Center Discussion7_ridhwan29_rizwan@CLOVERTECHNOLOGIES.COM31_Fri, 14 Sep 2001 10:45:25 +0530547_iso-8859-1 > But please, do not expect kindness from we Americans any longer, when we > have been attacked in such a horrid manner. We will defend our right to > civilized behavior in this country, and we will fight to preserve our > freedoms.
Whatever happened was bad enough. My prayers are for every member of humanity. John you feel this 'cause you saw it today. Whoever did that saw it done to them by the 'Allies' some time back and now they want their freedom just like you want to fight for the same. But history will tell who [...]
28192 15 59_Derez D. Lusk/Household International is out of the office.13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Fri, 14 Sep 2001 01:01:14 -0500400_us-ascii I will be out of the office starting 09/13/2001 and will not return until 09/17/2001.
any issues from DB2 please contact HTSMARS VIA HOUSEMAIL
================================================ 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.
28208 25 40_comparison between DB2 6.1 and Db2 6.1.110_praveen_kj19_praveen_kj@INFY.COM31_Fri, 14 Sep 2001 11:34:40 +0530565_iso-8859-1 Hi All, We are doing development for our client in DB2 6.1. Our Client is having Db2 6.1.1 in place.
Can any body throw some light on the possible issues or pointers
Regards,
Praveen Kumar Jain Infosys Technologies Ltd, Asia Pacific Unit, Pune Phone: 91-2139-32800 Ext. 4364 Fax: 91-2139-32832
===============================================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.
28234 93 17_Re: Wasted space?12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 14 Sep 2001 09:46:55 +0200545_iso-8859-1 Hi,
Do an analysis to find the photo length distribution and decide upon it. It won't prevent waste but can lead you to the "optimal" page size to be used. I once was called in a project that used BLOB to store image data, a length analysis showed that about 95% of the data could be handled in 1, 32KB, and the biggest one (and only one!) could fit in 4, 32KB blocks. Of course YMMV, but checking the length distribution can help a lot (and still, you'll have some waste). You may want to check compression as well, even [...]
28328 15 51_Chuck Bonner/Santa Teresa/IBM is out of the office.12_Chuck Bonner22_chuckbonner@US.IBM.COM31_Fri, 14 Sep 2001 00:50:33 -0600405_us-ascii I will be out of the office starting September 13, 2001 and will not return until September 18, 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.
28344 15 19_Re: data conversion11_Daniel Adam16_dadam@GRATEX.COM31_Fri, 14 Sep 2001 01:42:23 -0500464_- One more thing - our DSNTIAD is bound with EBCDIC. When I bind it with UNICODE, I cannot run DSNTIAD form JCL anymore - I get same ccsid conversion problem. Can anyone venture a guess why this is happenning ? Bye, Daniel
================================================ 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.
28360 21 33_Re: Trigger Question sqlcode -7370_24_markus.schaub@SYSTOR.COM31_Fri, 14 Sep 2001 08:59:43 +0200553_us-ascii hi gerrit
the sql select your are executing within your trigger is reciving a sqlcode -909 and therefore the tirgger itself returns a sqlcode -737. so the reason for your failing sql update is actually the sqlcode -909 (saying 'the object has been deleted').
hope it helps. regards markus
================================================ 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.
28382 69 16_Re: wtc disaster18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Fri, 14 Sep 2001 14:11:28 +0530517_- Deeply moved by the enormity of the devastation caused by the dastardly acts of some bigots I have been sombrely casting my mind back to the tragic events of the ill-fated Tuesday. Today is my B'day but I am in no mood to celebrate as I am feeling heavy-hearted. In this moment of agony and plight my sympathies and thoughts are with the people of NYC / DC as also the rest of US. May God give them enough strength to overcome the untold misery. I also pray God to let the souls of the departed rest in peace. [...]
28452 27 5_UDF's15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Fri, 14 Sep 2001 11:30:27 +0200345_us-ascii A question from a colleague ...
Greetings,
I would like to know whether there is a way to copy a specific (scalar) UDF from one database to another in DB2 UDB v6.1 running on AIX. Both databases are in the same in instance. The UDF is written in C, and there's no func_path given in syscat.functions. [...]
28480 96 17_Moment of silence12_Peter Horner27_peter.horner@JULIUSBAER.COM31_Fri, 14 Sep 2001 11:29:51 +0200563_us-ascii Hi List
In all countries of europe today at 12:00 am (local europe time) 3 minutes of silence will be held.
I invite all our european fellows of this list to join in.
Thank you. Peter
-----------------------------------------------------------------------------------
Peter Horner, ISDD Bank Julius Baer & Co. Ltd. Hohlstrasse 602, CH-8010 Zurich, Switzerland Telephone +41 (1) 437 44 04, Fax +41 (1) 437 44 75 www.juliusbaer.com ----------------------------------------------------------------------------------- [...]
28577 18 79_=?iso-8859-1?q?R=E9f?= =?us-ascii?q?=2E_=3A_?= =?us-ascii?q?Moment?= of silence0_25_fmarius@MOUSQUETAIRES.COM31_Fri, 14 Sep 2001 12:17:25 +0200453_iso-8859-1 Nous observons 3 minutes de silence et nous sommes en deuil. Nous aimons l'Amérique, nous sommes tristes pour toutes les victimes de cet horrible attentat. Nous sommes solidaires avec les ETATS UNIS D'AMERIQUE ===============================================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.
28596 32 26_Re: DB2 and SMP/E question14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 14 Sep 2001 06:00:53 -0500638_- One other technique which no-one has mentioned is to used MVS aliased datasets. That is, each subsystem references a fixed dsn, eg DB2.systemid.SDSNLOAD; these names are, however, aliases on top of another name, eg DSN610.#010907.SDSNLOAD.
What would happen is SMP maintenence is applied to a set of base libraries, which are then copied into a set of libraries for today (DSN610.#010914.SDSNLOAD). As the maintenance is rolled through each subsystem, the aliases are switched to the new datasets; fallback is to switch the aliases back to the old datasets. When it has been applied to every subsystem, the old datasets can [...]
28629 104 26_Re: DB2 and SMP/E question9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Fri, 14 Sep 2001 13:14:59 +0100341_us-ascii We have a slight variation of this which helps when in a Sysplex environment. We configure our DB2 sub-systems so that they are all on the same level of code for each LPAR. On any LPAR in the sysplex we require that we use the same dataset names in our jobs/procs etc, but need to allow for different code levels on each LPAR. [...]
28734 26 10_Data files7_ridhwan29_rizwan@CLOVERTECHNOLOGIES.COM31_Fri, 14 Sep 2001 18:05:22 +0530321_iso-8859-1 Hi there, I am new to db2. Not a dba of db2. I want to mirror/rsync the data/log files of a db2 database periodically. Which are the files/directories to be considered for this purpose.
Trying a manual backup with rsync.
I have db2udbee 7.1 on red Hat linux 7.1
Regards thanks in adv [...]
28761 125 16_Re: wtc disaster11_Jim Medlock24_jmedlock@ALLIANCESYS.COM31_Fri, 14 Sep 2001 07:47:53 -0500
28887 78 63_Re: Question about DB2 Data sharing and Group naming convention11_Fred Foster14_B06FMF@FDS.COM31_Fri, 14 Sep 2001 08:50:56 -0400451_us-ascii Mike,
When we started planning for data sharing, we had the same questions regarding naming conventions. We found that the IBM OS/390 Parallel Sysplex Application Migration Guide (GC28-1863) has a better naming convention than the one presented in the DB2 Data Sharing Guide. In section 2.1.3 of the manual (my manual is from 3 years ago, so the section number may have changed), it recommends a naming convention of CTGI, where: [...]
28966 28 16_Re: wtc disaster12_Jim Harrison17_jharrison@GMX.NET31_Fri, 14 Sep 2001 09:15:10 -0400619_us-ascii Jim - my thoughts exactly. Seeing Russians laying flowers outside the US embassy brought tears to my eyes last night. Thanks people, we really do appreciate it.
At 07:47 AM 9/14/2001 -0500, Jim Medlock wrote:
>I too have resisted commenting because as John pointed out, words seem >somewhat trivial in the face of such a disaster and the great human toll >it has taken. However, if there is anything positive that can come out of >this its the fact that civilized peoples are pulling together because of >this. I for one greatly appreciate the outpouring of sympathy I've seen >from [...]
28995 114 37_Re: The World Trade Center Discussion12_Murphy, Land25_GDMurphy@ARKBLUECROSS.COM31_Fri, 14 Sep 2001 08:18:24 -0500351_iso-8859-1 I'd be very curious to know exactly what this is supposed to mean.
"Whoever did that saw it done to them by the 'Allies' some time back and now they want their freedom just like you want to fight for the same."
Perhaps your definition of freedom is different than mine. Obviously your definition of terrorism is as well. [...]
29110 40 63_Re: Question about DB2 Data sharing and Group naming convention16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 14 Sep 2001 09:38:18 -0400446_iso-8859-1 And some times the bureaurats let one slip by - guts of DFSMS was:
IGDZILLA
(picture large beast munching on a DASD controller!)
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Roger Miller [mailto:millerrl@US.IBM.COM] Sent: Thursday, September 13, 2001 10:39 PM To: DB2-L@RYCI.COM Subject: Re: Question about DB2 Data sharing and Group naming convention [...]
29151 129 37_Re: The World Trade Center Discussion12_Marc Sennett23_msennett@TEKSYSTEMS.COM31_Fri, 14 Sep 2001 10:07:33 -0500370_us-ascii Rizwam,
I hate to jump into this but I cannot resist. "...whoever did this saw it done to them..."???? What does this mean? Did we ever hijack a civilian airliner and crash it into a civilian target? Are you really saying that this was somehow a justifiable eye for an eye? If yes, I don't pity you, I loathe you. You are sick twisted and deranged. [...]
29281 50 14_Re: Data files13_Keith Gilbert17_kgilbert@CSA1.COM31_Fri, 14 Sep 2001 09:10:32 -0500317_iso-8859-1 Now this took some guts, or maybe just stupidity. First he makes a post trying to justify the attack on Americans and then he posts a question expecting the list (comprised mostly of Americans!) to help him with his problem. Rizwan, I suggest you change your e-mail id before you can expect any help. [...]
29332 15 37_Re: The World Trade Center Discussion13_Kim Comanchee13_KimC@CDTG.NET31_Fri, 14 Sep 2001 09:06:04 -0500490_- >>Islam says slap him back if you did not deserve it. Then he won't chase >> you and then you will not kill him for the slap.
Arab extremist say 'If a man slaps your face, you never deserve it, so go kill innocent men, women and children.'
================================================ 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.
29348 17 20_Reason Code 00C900AC13_Harve Puckett25_hpuckett@DOAS.STATE.GA.US31_Fri, 14 Sep 2001 09:41:41 -0500464_- We are a DB2 Vers 5 OS/390 Vers 2R6 site with no data sharing groups defined. After applying PUT0107 our install subsystem-sandbox encountered aan unwanted TRKRSITE affiliation (without ever setting TRKRSITE=YES). We solved the problem (we thought) by COLDSTARTing the subsystem. Today, some weeks later, when applying maintenance to our ORACLE gateway ... the problem resurfaced with the reason code 00C900AC. I rechecked the ZPARM and we are TRKRSITE=NO. [...]
29366 29 0_10_Andy Stein22_jbak2009@AMERITECH.NET31_Thu, 13 Sep 2001 09:57:00 -0500379_us-ascii My name is Andy Stein; I am a consultant in executive search. My client develops enterprise-wide tools and utilities to support large enterprise wide IT operations. Many of the OS390 based products are sold through IBM.
My client has recently formed a new division, the Services Group to provide consulting and implementation services around their products. [...]
29396 48 0_14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Fri, 14 Sep 2001 10:49:49 -0400494_iso-8859-1 Andy -
You forgot the most important part:
How much for each resume?
Shaul
-----Original Message----- From: Andy Stein [mailto:jbak2009@AMERITECH.NET] Sent: Thursday, September 13, 2001 10:57 AM To: DB2-L@RYCI.COM Subject:
My name is Andy Stein; I am a consultant in executive search. My client develops enterprise-wide tools and utilities to support large enterprise wide IT operations. Many of the OS390 based products are sold through IBM. [...]
29445 51 16_Re: wtc disaster13_Hanne Lyssand10_han@VPS.NO31_Fri, 14 Sep 2001 16:48:49 +0200369_us-ascii To all you people in USA. I will just give you my deepest condolences to all of you who in any way are affected by this terrible act of terror.
The newspapers over here start to give us the number of people missing from each European country, and I quess there is people from all over the world and from any religions who is trapped in this ruins. [...]
29497 192 55_Re: The World Trade Center Discussion - For the curious15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 14 Sep 2001 10:09:20 -0500468_iso-8859-1 "How involved was the Middle East in WWII? I don't remember my history that well."
A quick check on the net yields this information. Northern Africa was involved in the war but only because Mussolini invaded them (And we know what happened to him.). The Allies were there to free them from the Fascists. So, unless they WANTED to be controlled by the Fascists, they don't have anything to complain about as far as Allied bombings are concerned. [...]
29690 45 37_Re: The World Trade Center Discussion12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 14 Sep 2001 10:09:21 -0500444_- I think we may be getting a little too "hot", people. Let's calm it back down to a professional level. If you don't like what Ridwan said (and I found it offensive), then simply ignore him. "Hitting back" is exactly what he is guilty of and we need to avoid. If you really found it offensive, tell his employer. He was foolish enough to send that message from his corporate email account. And, as far as I can see, it is a U.S. company. [...]
29736 23 46_Re: The World Trade Center Discussion - Rizwan15_Gary Fahrlander28_gary.fahrlander@ZURICHNA.COM31_Fri, 14 Sep 2001 10:33:55 -0500558_us-ascii Head Office & Offshore Development Center Clover Technologies Pvt. Ltd., 1st Floor, Business Avenue, North Main Road, 333 Koregaon Park, Pune 411 001, India Tel +91 20 6119154, + 91 20 6133041 Fax + 91 20 4002613 Email :
Business Enquiries business@clovertechnologies.com HR hr@clovertechnologies.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
29760 31 25_Cut Off For Optimisation?12_Simon George26_simon_x_george@HOTMAIL.COM31_Fri, 14 Sep 2001 16:42:44 +0100480_- Hi Group
Simple question, does the optimizer have a cut off point when it simply gives up on optimization and returns a negative SQL code to the calling application.
The reason for asking is that one of my users has managed to generate a dynamic statement that the optimizer has been chewing on for over 1-day (its composed of a vast number of UNION statements). This is the second time its happened and the last time we had top trash DB2 to stop the thread. [...]
29792 95 37_Re: The World Trade Center Discussion13_Morrill, John12_JohnM@VP.NET31_Fri, 14 Sep 2001 09:52:02 -0600510_- Greetings!
Thank You John. This is what I asked in my post on Wednesday.
I have been receiving requests to end this discussion. Some subscribers are unhappy with my decision to depart from the "There is no cause, need or issue so great that it justifies an off topic post" policy. I thought long and hard before I decided to allow posts about the World Trade Center Discussion. In the end I made a judgment call. As with any policy, one has to exercise judgment and a sense of proportion. [...]
29888 63 37_Re: The World Trade Center Discussion15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 14 Sep 2001 10:46:45 -0500403_iso-8859-1 I believe that Rizwan's response was an emotional one for a very emotional situation. We must not let our emotions take control or there is no chance for an intelligent discussion.
Linda
-----Original Message----- From: McKown, John [mailto:JMckown@HEALTHAXIS.COM] Sent: Friday, September 14, 2001 10:09 AM To: DB2-L@RYCI.COM Subject: Re: The World Trade Center Discussion [...]
29952 12 42_Re: DB2 V6.1 for OS/390 and XML Extender ?12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 14 Sep 2001 10:35:04 -0500309_- The XML extender is only in V7.
Roger Miller, DB2 for z/OS
================================================ 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.
29965 202 45_Re: READ ONLY status after an Full image copy13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Fri, 14 Sep 2001 10:00:14 -0500469_iso-8859-1 Not sure if this will help, but you might try running the imagecopy job with "msglevel(2)" to see if that tells you anything extra. This will display more information in the job listing regarding what's happening (will show the "-start database" commands, etc), and might provide a clue as to why this space is RO after the copy. If that doesn't tell you anything I would recommend passing it along to BMC support to see what they have to say about it. [...]
30168 163 29_Re: Cut Off For Optimisation?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 14 Sep 2001 16:53:29 +0100384_iso-8859-1 There is an SQLCODE (I forget which one) that effectively says "sorry, this is too complex"
I suspect what you have found is a loop in DB2 of some sort
Have a look in IBMLINK or check with IBM
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
30332 13 19_Re: data conversion12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 14 Sep 2001 10:44:35 -0500365_- Are the Unicode services installed on OS/390? I think it's still an optional component.
Roger Miller, DB2 for z/OS
================================================ 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.
30346 15 19_Re: simple question12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 14 Sep 2001 10:49:25 -0500272_- On on UNIX and Windows platform, we have the ISO standard function for recursion. There is an appendix in the SQL Reference for it. The SQL uses a WITH clause, common table expressions and a recursion in a UNION ALL. DB2 for z/OS and OS/390 does not yet have this. [...]
30362 30 37_Re: The World Trade Center Discussion18_Jean-Jacques Borie18_jjborie@TEKORA.COM31_Fri, 14 Sep 2001 17:57:36 +0200378_iso-8859-1 Les vrais vaincus de la guerre, ce sont les morts.
Ernest Renan
Jean-Jacques Borie Directeur recherche et développement
Tekora, changez votre conception des sites web http://www.tekora.com 17, place de la Résistance - 92130 Issy-les-Moulineaux Tél. : +33 1 55 00 10 03 - Fax : +33 1 55 00 10 10 Por: +33 660199524 jjborie@tekora.com [...]
30393 55 37_Re: The World Trade Center Discussion13_Joel Pankonin26_joel.pankonin@ZURICHNA.COM31_Fri, 14 Sep 2001 10:55:54 -0500671_us-ascii To whom it may concern,
I would keep an eye on Mr. ridhwan.
ridhwan @RYCI.COM> on 09/14/2001 12:15:25 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: The World Trade Center Discussion
> But please, do not expect kindness from we Americans any longer, when we > have been attacked in such a horrid manner. We will defend our right to > civilized behavior in this country, and we will fight to preserve our > freedoms. [...]
30449 13 18_Re: GMT/local time12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 14 Sep 2001 10:56:55 -0500425_- The exit for a local date and time format came out in V1R3, with the rest of our date and time support. What do you want to do in the local format?
Roger Miller, DB2 for z/OS
================================================ 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.
30463 57 10_code pages11_Daniel Adam16_dadam@GRATEX.COM31_Fri, 14 Sep 2001 11:00:41 -0500601_- Hi, I'm getting frustrated with the unicode database v7.1 on OS/390 v2r10.
Can anyone explain why I can insert into table only if it was created with EBCDIC ccsid ( but not with UNICODE and ASCII ccsid) ?
This is from the DB2 Command Line Processor: db2 => create table a (a varchar(10)) ccsid unicode DB20000I The SQL command completed successfully. db2 => insert into a values ( 'asd' ) DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0332N There is no available conversion [...]
30521 50 37_Re: The World Trade Center Discussion15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 14 Sep 2001 11:19:52 -0500517_iso-8859-1 English translation:(I believe. I have only been studying French since February.)
The war's defeated truths, these are the dead.
Linda
-----Original Message----- From: Jean-Jacques Borie [mailto:jjborie@TEKORA.COM] Sent: Friday, September 14, 2001 10:58 AM To: DB2-L@RYCI.COM Subject: Re: The World Trade Center Discussion
Les vrais vaincus de la guerre, ce sont les morts.
Ernest Renan
Jean-Jacques Borie Directeur recherche et développement [...]
30572 149 29_Re: Cut Off For Optimisation?12_Kirk Hampton16_khampto1@TXU.COM31_Fri, 14 Sep 2001 11:23:01 -0500340_us-ascii
just curious... What evidence leads you to believe that it is still running the optimizer, and not actually processing the query ? Are there no GETPAGE's accumulating against your user tablespaces, only activity against the system catalog ? If so, then indeed, I would turn this one in to IBM as a bug report. [...]
30722 40 37_Re: The World Trade Center Discussion14_William Gannon33_wgannon@EMAIL.PALMBEACH.K12.FL.US31_Fri, 14 Sep 2001 12:37:24 -0400495_us-ascii Hi fellow human beings (and Ridwan)
Great Idea John !
I just sent an email to the corporate offices of CLOVER TECHNOLOGIES Inc. To: business@clovertechnologies.com hr@clovertechnologies.com info@clovertechnologies.com alantech@speakeasy.net CC: rizwan@CLOVERTECHNOLOGIES.COM
I suggest other members of the list also offended by this do the same. Volume speaks ... 2700+
Bill G.
+++++++++++ copy of note follows ++++++++++++++ To Whom it concerns [...]
30763 13 24_Re: UDB/DB2 connectivity15_Yury Katsnelson26_yury.katsnelson@BCBSFL.COM31_Fri, 14 Sep 2001 11:39:35 -0500307_- John, thanks a lot for your help.
Yury Katsnelson BCBSFL
================================================ 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.
30777 96 37_Re: The World Trade Center Discussion10_Marc Baime14_mbaime@GTE.NET31_Fri, 14 Sep 2001 12:50:47 -0400599_us-ascii After the Horror By PAUL KRUGMAN
It seems almost in bad taste to talk about dollars and cents after an act of mass murder. Nonetheless, we must ask about the economic aftershocks from Tuesday's horror.
These aftershocks need not be major. Ghastly as it may seem to say this, the terror attack - like the original day of infamy, which brought an end to the Great Depression - could even do some economic good. But there are already ominous indications that some will see this tragedy not as an occasion for true national unity, but as an opportunity for political [...]
30874 160 37_Re: The World Trade Center Discussion10_Marc Baime14_mbaime@GTE.NET31_Fri, 14 Sep 2001 12:56:38 -0400514_us-ascii This is what we're going to war against....an enemy that's everywhere and nowhere....welcome to the new Vietnam.
Taliban Plead for Mercy to the Miserable in a Land of Nothing By BARRY BEARAK
The Associated Press
KABUL, Afghanistan, Sept. 12 - If there are Americans clamoring to bomb Afghanistan back to the Stone Age, they ought to know that this nation does not have so far to go. This is a post-apocalyptic place of felled cities, parched land and downtrodden people. [...]
31035 72 37_Re: The World Trade Center Discussion10_Marc Baime14_mbaime@GTE.NET31_Fri, 14 Sep 2001 13:01:30 -0400541_us-ascii Enough is enough...you should cut this discussion off IMO before we start placing people in the concentration camps because of their beliefs. This is still America despite the fascists who would like to make us all think, act, and believe the same. IMO your judgment in allowing this discussion to continue is faulty and will degenerate into name calling and demonization. Feel free to pull my posts (which were an attempt to broaden a foolishly narrowed discussion) if it will help to end this discussion in a database group. [...]
31108 22 37_Re: The World Trade Center Discussion12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Fri, 14 Sep 2001 12:07:32 -0500535_iso-8859-1 I was genuinely moved last night as my wife and I watched the news, and the scene was shown in London of the Changing of the Guards in front of the Palace, whereupon the band played the Star Spangled Banner....for the first time in History.
How extraordinary, how simple, and yet it brought tears to my eyes, to see a very proud nation, so very proud of their heritage, acknowledge our pain and hurt through the symbolism of playing our national anthem in place of theirs, during one of their solemn ceremonies. [...]
31131 44 18_Re: GMT/local time14_Winston Mangum26_Winston_Mangum@LABCORP.COM31_Fri, 14 Sep 2001 13:07:22 -0400365_US-ASCII Thanks for your response. My user is using the TEMPLATE for DSN allocation: DBU.D6.&DB..&TS..D&DATE..T&HO.&MI.
The &HO is using GMT, as documented in the Utility Guide and Reference Manual. Our hardware closk is GMT and must stay that way. I would like another variable that will accept the LOCAL time or use an exit to pick up the LOCAL time. [...]
31176 178 37_Re: The World Trade Center Discussion14_Ruth Gramolini26_rgramolini@TAX.STATE.VT.US31_Fri, 14 Sep 2001 13:12:54 -0400298_iso-8859-1 If the leaders of Afghanastan want to avoid the reprisals then they should give up Bin Laden. If they refuse,as they have all along, then there should be reprisals. If no one had given sanctuary to this monster then he may not have been able to do what he did to the United States. [...]
31355 141 30_FW: America: the good neighbor17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Fri, 14 Sep 2001 10:17:42 -0700306_us-ascii This was forwarded to me my a number of different people and thought under the circumstances I would send it to the list. As a Canadian myself living and working in the US I've come to love this adopted country and share a lot of the sentiments written by my ex-compatriot from my home town. [...]
31497 70 26_Re: DB2 and SMP/E question14_Allison, Edith23_edith.allison@UCONN.EDU31_Fri, 14 Sep 2001 13:52:44 -0400528_iso-8859-1 Eric (and others):
I see that you copy SDSNEXIT. I believe this library contains customized members so after you copy it over, what steps do you take to restore customization. I have not fully investigated this on my own but so far we think we need to rerun DSNTIJUZ from the .NEW.SDSNSAMP library and reassemble our ACF2 exits. I will continue to look for other follow-on actions on my own but any and all detail about your own procedures would be appreciated since we will be doing this late next week. [...]
31568 101 26_Re: DB2 and SMP/E question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 14 Sep 2001 14:07:44 -0400564_iso-8859-1 Edith, Sorry to have left that info out. We do assemble DSNZPARM and DSNHDECP before recycling the subsystem to apply the maintenance. We have some other things in SDSNEXIT (CICS RCTs for example). Those never get assembled in the SMP/E process so they do not get replaced when we do the COPY. We do not use ACF2 so I can't give any insight about that. What we use to assemble ZPARM/DECP is a 'customized' version of DSNTIJUZ. This contains our edited source for //SYSIN and has the SMP/E step removed. If I think of anything else I missed, I will [...]
31670 192 37_Re: The World Trade Center Discussion12_David Booher22_David.Booher@QUEST.COM31_Fri, 14 Sep 2001 11:19:41 -0700667_iso-8859-1 I translate it as:
The real conquerors of war, are the dead.
Dave
-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Friday, September 14, 2001 11:20 AM To: DB2-L@RYCI.COM Subject: Re: The World Trade Center Discussion
English translation:(I believe. I have only been studying French since February.)
The war's defeated truths, these are the dead.
Linda
-----Original Message----- From: Jean-Jacques Borie [mailto:jjborie@TEKORA.COM] Sent: Friday, September 14, 2001 10:58 AM To: DB2-L@RYCI.COM Subject: Re: The World Trade Center Discussion [...]
31863 31 17_Stored Procedures14_Timothy Miller17_njironman@USA.NET29_Fri, 14 Sep 2001 14:19:38 EDT375_US-ASCII Hello,
I have a user that wants to pass in a blob to a stored procedure and return a blob. My question is can you do this from DB2 UDB V6.1 for solaris. I did not see Blob as an option in the Stored Procedure Builder out paramters. Can any one supply me an example, please respond to njironman@usa.net, I receive a digest form of these messages. [...]
31895 116 37_Re: The World Trade Center Discussion9_Mike Mays18_mmays@NOLLJOBS.COM31_Fri, 14 Sep 2001 13:19:19 -0500479_iso-8859-1 Marc: The disucss has been about the crisis and the people who did it. Glad to see someone just had to throw partisan politics into the fray. Couldnt go four days without it, could we. I am NOW totally disgusted.
Mike Mays
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Marc Baime Sent: Friday, September 14, 2001 11:51 AM To: DB2-L@RYCI.COM Subject: Re: The World Trade Center Discussion [...]
32012 49 57_Two Questions excessive -911 errors and defrag of volumes12_Cory Heislen23_heiska4@DSS.STATE.MO.US31_Fri, 14 Sep 2001 13:46:30 -0500371_us-ascii Question #1 We are currently using the Cool-Gen product ver 6 on the OS/390.
My problem is that I am getting -911 on the RPROF table (a timeout on the page level).
A solution that I am considering is changing the table to lock at the row level instead of the page that it is set at currently unless any of you could give me a better solution. [...]
32062 29 59_Is the DB2 Technical Conference in Orlando going to happen?0_19_Tim.Lowe@STPAUL.COM31_Fri, 14 Sep 2001 13:48:13 -0500592_us-ascii DB2listers, According to our company webpage, the U.S. State Department has asked that company travel be limited to only what is critical and essential. In light of this, all planned travel is being reevaluated, and only critical and essential travel is being allowed. (I had thought that the constitution required the State department to deal with foreign travel, so it seems a little strange to me that they have made a recommendation about U.S. travel. And, I cannot find a reference to this on their webpage. Regardless, it sounds like I am not going to be going anywhere.) [...]
32092 37 33_Re: Trigger Question sqlcode -73718_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Fri, 14 Sep 2001 20:54:14 +0200688_us-ascii Markus,
Of course whe see the sqlcode -909.
But why? Nothing was deleted.
Thanks for responding.
Gerrit
markus.schaub@SYSTOR.COM wrote:
> hi gerrit > > the sql select your are executing within your trigger is reciving a sqlcode > -909 and therefore the tirgger itself returns a sqlcode -737. > so the reason for your failing sql update is actually the sqlcode -909 > (saying 'the object has been deleted'). > > hope it helps. > regards > markus > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners [...]
32130 21 37_Re: The World Trade Center Discussion13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 14 Sep 2001 14:57:24 -0400512_iso-8859-1 >I was genuinely moved last night Thanks John, that was very moving.
So's this:
http://www.cnn.com/2001/WORLD/europe/09/14/silence.colour/index.html
David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
32152 69 63_Re: Is the DB2 Technical Conference in Orlando going to happen?0_20_John_Lendman@FPL.COM31_Fri, 14 Sep 2001 15:07:14 -0400422_us-ascii It appears from their web page it is still on.
John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413
Tim.Lowe@STPA UL.COM To: DB2-L@RYCI.COM Sent by: "DB2 cc: Data Base Subject: Is the DB2 Technical Conference in Discussion Orlando going to happen? List"
09/14/01 02:48 PM Please respond to "DB2 Data Base Discussion List" [...]
32222 131 37_Re: The World Trade Center Discussion10_Raghu Kota21_raghukota@HOTMAIL.COM31_Fri, 14 Sep 2001 19:19:48 +0000655_- You want answer!! JIHADIS(Islamic fanatics!!) They are crazy bunch of people. There are hundreds of Jihadi outfits in Pakistan and middle east.
>Marc: The disucss has been about the crisis and the people who did it. Glad >to see someone just had to throw partisan politics into the fray. Couldnt >go >four days without it, could we. I am NOW totally disgusted. > >Mike Mays > > >-----Original Message----- >From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of >Marc Baime >Sent: Friday, September 14, 2001 11:51 AM >To: DB2-L@RYCI.COM >Subject: Re: The World Trade Center Discussion > > >After the [...]
32354 23 23_UDB version 7.2 problem29_Sherri Sterling DIGEST NOMIME29_Sherri.Sterling@BPD.TREAS.GOV31_Fri, 14 Sep 2001 15:22:20 -0400563_us-ascii Our NT security folks have locked down some servers. Now it is taking 15 minutes to bring up control center. We put a sniffer on the line and found out that UDB is issuing LDAP requests to a lot of different servers. Our NT folks said we would have to turn LDAP off in UDB. These are child domains whose communications have been restricted. Those LDAP requests are therefore, not being answered and timeing out. This is what is taking so long. Also, those domains were locked down the same weekend that the db2 admins began noticing the problem. Is [...]
32378 43 37_Re: The World Trade Center Discussion10_Shery Hepp17_schepp@SRPNET.COM31_Fri, 14 Sep 2001 12:33:24 -0700448_iso-8859-1 Until now- I've been quietly sharing my disbelief, sadness and grief with the recent events in our nation.
I'm deeply moved by the show of support and compassion from our friends across the world.
Thank you
Shery
-----Original Message----- From: Vernon, John [mailto:John.Vernon@TRS.STATE.TX.US] Sent: Friday, September 14, 2001 10:08 AM To: DB2-L@RYCI.COM Subject: Re: The World Trade Center Discussion [...]
32422 26 7_DB2 CAE11_Moore, Tony15_TMoore@IKON.COM31_Fri, 14 Sep 2001 15:29:23 -0400368_iso-8859-1 Listers, We are running an extremely outdated version of CAE (2.1.2) on AIX and our UNIX guys recently attempted to copy this code to another AIX box. After copying the code over, reconfiguring the CAE client and bringing over the application programs that use it, when they attempt to bind the application from that box, they get the following error: [...]
32449 136 20_Re: Stuck with a SQL16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Fri, 14 Sep 2001 11:28:43 -0700317_iso-8859-1 Abhijit,
The following SQL should provide you with the result set you are looking for within a view context. Please note that the nested table expression which is used to build TEMP1 is performing a cartisian product, and may not perform very well depending on the size of the tables involved. [...]
32586 40 11_Re: DB2 CAE11_Moore, Tony15_TMoore@IKON.COM31_Fri, 14 Sep 2001 15:49:37 -0400660_iso-8859-1 Yo Listers, Please disregard that question I just sent through, the UNIX guys just uncataloged and recataloged the database on the CAE instance and they're able to bind successfully. Thanks anyway!!
Tony
-----Original Message----- From: Moore, Tony Sent: Friday, September 14, 2001 3:29 PM To: 'DB2-L@RYCI.COM' Subject: DB2 CAE
Listers, We are running an extremely outdated version of CAE (2.1.2) on AIX and our UNIX guys recently attempted to copy this code to another AIX box. After copying the code over, reconfiguring the CAE client and bringing over the application programs that use it, when they attempt to bind the [...]
32627 239 61_Re: Two Questions excessive -911 errors and defrag of volumes14_Johnson, Daryl28_Daryl.Johnson@PACIFICORP.COM31_Fri, 14 Sep 2001 12:59:29 -0700529_iso-8859-1 Our RPROF table is defined so 1 row will fit on a page and we still encounter -911's.
It is my belief that duplicate(s) keys are being created.
Thanks,
Daryl (DJ) Johnson DBA Work Phone: 503.813.5451 Cell Phone: 503.706.6391 Pager: 503.202.4775 Home Phone: 503.632.4719
-----Original Message----- From: Cory Heislen [mailto:heiska4@DSS.STATE.MO.US] Sent: Friday, September 14, 2001 11:47 AM To: DB2-L@RYCI.COM Subject: Two Questions excessive -911 errors and defrag of volumes [...]
32867 23 37_Re: The World Trade Center Discussion0_19_Tim.Lowe@STPAUL.COM31_Fri, 14 Sep 2001 15:25:59 -0500370_us-ascii The biggest question in my opinion is: Can we fight terrorism?
Is it possible to create a world-wide opinion that terrorism is evil, and make anyone who deals with terrorists a pariah? Can we even agree on a definition of terrorism, much less agree to fight it?
I am sorry, but this is just so frustrating to me. The terrorists must not win! [...]
32891 72 19_Re: DB2 V6 Triggers12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Fri, 14 Sep 2001 15:26:35 -0500885_us-ascii Am I correct in understaning that this PTF (UQ46393) was not included (available) in last May's V6 refresh?
Stg
BOB JEANDRON on 09/12/2001 04:13:00 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Steve Grimes/Systems/ais)
Subject: Re: DB2 V6 Triggers
Make sure you have UQ46393 applied.
>>> DB2-L@RYCI.COM@inter2 09/12/01 02:48PM >>> Hello All, I am a DBA at a MVS DB2 V6 shop who is about to venture into triggers. I have been assigned the task of establishing some groundrules for the documentation and usage of these triggers. Can anyone provide me with pointers [...]
32964 136 6_Re: V814_Susan Birgeles25_Susan.Birgeles@ALLTEL.COM31_Fri, 14 Sep 2001 16:03:00 -0500510_ISO-8859-1 IMS has releases?
______________________________ Reply Separator _________________________________ Subject: Re: V8 Author: DB2-L@RYCI.COM (DB2 Data Base Discussion List) at INTERNET Date: 9/13/01 11:43 AM
Sorry guys could not resist this one...
it started with someone asking if anyone had any idea when the next release (V8) of IMS might be out...
grand one Andrew!
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. [...]
33101 63 37_Re: The World Trade Center Discussion15_Craig Nicholson27_Marion_C._Nicholson@HUD.GOV31_Fri, 14 Sep 2001 16:38:59 -0400428_us-ascii As much as it pains me, I believe retaliation begets retaliation. Look at Ireland and the Middle East. If we cannot destroy ALL religious fanatics there will be retaliation. Then what? As much as I would like to kill each of these horrible and stupid individuals I think we should at least think about taking the highest road and refuse to retaliate. I do wonder how that would be received by the world community. [...]
33165 55 37_Re: The World Trade Center Discussion12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 14 Sep 2001 16:04:19 -0500573_- Craig, I think that I agree. My personal opinion is that we need to gather proof, lots and lots of proof, about who did this. Then publish it to the world. Publish it to the countries where these people stay. Then tell those countries, "We want these people tried by the World Court for their crimes." If they say, "Yes", then good. If not, then some sort of World action (not just U.S.) would be needed. Hopefully, just some stronger political pressure, but if not, then restrained and exacting military targeting of these people. The problem is that these cowards [...]
33221 14 43_Re: Downloading APARs - DB2 UDB V7.1 on AIX14_Marshall Fuqua19_marcfuqua@YAHOO.COM31_Fri, 14 Sep 2001 16:14:10 -0500417_- Thanks to the listers who responded to my question. I was able to obtain a 'special' fixpak from IBM Tech. Support that contains only the APAR that I needed.
Marshall
================================================ 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.
33236 35 0_14_Marshall Fuqua19_marcfuqua@YAHOO.COM31_Fri, 14 Sep 2001 14:30:50 -0700579_us-ascii Platform: DB2 UDB V7.1 running under AIX 4.3.3
When a DB2 instance was created, the installer (not me) did not explicitly specify a user ID to be used for running fenced stored procedures & UDFs. My question: is it possible to add a fenced user ID for an instance after the instance is created? I can't find anything in the DB2 documentation or the listserv archives on this subject. I'm guessing that you would create the ID & associated group under AIX & then execute the 'db2iupdt' command with the '-u' parameter to specify the user ID. Is this correct? [...]
33272 23 20_Theme and Variations15_Stephen J Spiro25_stephenjspiro@HOTMAIL.COM31_Fri, 14 Sep 2001 16:28:37 -0500608_- This is ... strange. http://cagle.slate.msn.com/news/Yahtzee/liberty.asp
I found this one moving and VERY disturbing. http://cagle.slate.msn.com/news/Yahtzee/liberty4.asp
Stephen J Spiro
_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
================================================ 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.
33296 97 37_Re: The World Trade Center Discussion15_Wells, Davis B.21_davis.wells@TGSLC.ORG31_Fri, 14 Sep 2001 17:36:59 -0500357_iso-8859-1 If we were dealing with rational people your idea might work. But we're not. If we don't do anything they will attack again anyway. Not retaliating will only encourage them because it proves them right. That we are fat, weak, and decadent. The only time a bully stops bullying people is when someone finally stands up and bloodies his nose. [...]
33394 68 0_18_Gert van der Kooij15_geko@WANADOO.NL31_Sat, 15 Sep 2001 00:53:05 +0200362_iso-8859-1 Hi,
The way you described should work. If it doesn't work or if the instance doesn't start afterwards it could also be an option to backup your database(s), save all settings you changed, drop the instance, create it again with the fenced user specified, change your saved configuration options (if necessary) and restore the database(s). [...]
33463 55 30_Acessing SQL source from SPT0117_Walter Trovijo Jr22_wtrovijo@COELBA.COM.BR31_Fri, 14 Sep 2001 20:17:30 -0300456_iso-8859-1 Hi Folks,
Is there any way to read source SQL statements from SPT01?? We´re doing some research about SQL performance using info from PLAN_TABLE and SYSIBM.SYSPACKSTMT, but STMT in SYSPACKSTMT is incomplete. I actually have a rexx function which reads DBRM and returns SQL source based on STMTNO obtained from SYSPACKSTMT. But it would be great if I could read it directly from SPT01 using a stored procedure or something like that. [...]
33519 59 37_Re: The World Trade Center Discussion8_Helen Tu28_spghct@SOCRATES.BERKELEY.EDU31_Fri, 14 Sep 2001 17:00:52 -0700571_US-ASCII Being human, I find it near impossible to 'calm it back down to a professional level'. The tragic itself is unbearable enough. Someone had to cut even deeper with the heartless comment!!! Has he become a different species???????
Helen Tu
On Fri, 14 Sep 2001, McKown, John wrote:
> I think we may be getting a little too "hot", people. Let's calm it back > down to a professional level. If you don't like what Ridwan said (and I > found it offensive), then simply ignore him. "Hitting back" is exactly what > he is guilty of and we need [...]
33579 17 38_Can DB2 V7.1 on OS/390 be called UDB ?8_K.Balaji19_K.Balaji@TARGET.COM31_Fri, 14 Sep 2001 19:43:37 -0500407_iso-8859-1 Hello, Can somebody tell me the exact definition of Universal Database? Can DB2 V7.1 on OS/390 be called be called as UDB ? TIA Balaji Ph # (510) 727-3259
================================================ 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.
33597 92 82_Re: The World Trade Center Discussion - French quote translation - for the curious15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 14 Sep 2001 21:02:19 -0500360_iso-8859-1 Well, it looks like neither of us are right. I asked the French student who is staying with us this year for a translation. He says that it means "The real losers of the war are the dead."
Linda -----Original Message----- From: David Booher To: DB2-L@RYCI.COM Sent: 9/14/01 1:19 PM Subject: Re: The World Trade Center Discussion [...]
33690 62 42_Re: Can DB2 V7.1 on OS/390 be called UDB ?12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Fri, 14 Sep 2001 22:53:32 -0500486_iso-8859-1 Yes, UDB "Universal Database" is a term used in the industry to identify a database that can support not only the traditional data types like numeric and character, but also non-traditional data like documents, images and video. What you get with DB2 to support this is UDT "User Defined Data Types" and UDF "User Defined Functions". This gives the DBMS the power to be extended beyond what is needed today to what data and processes need to be supported in the future. [...]