1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2001, week 3
2 31 63_back end panel or exit to DB2 SPUFI option to submit batch jobs14_Vivoda, Robert30_Robert.Vivoda@TEAM.TELSTRA.COM31_Fri, 15 Jun 2001 15:07:11 +1000269_- Hi, Has anyone written a front end or exit to the DB2 SPUFI option so that users can choose or be forced to run their SQL statements in batch mode.
I realise that there is an option 6 from the DB2 primary menu, but getting users to go there is very hard. [...]
34 156 42_Re: Order of Processing: Join and Subquery13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Fri, 15 Jun 2001 00:15:43 -0500458_iso-8859-1 Sanjeev,
Joins physically occur in stage 2 (RDS) anyway. But the accessing of table 3 with the join predicates from table 2 is indexable (provided of course an index exists and the predicates are of an indexable nature).
The accessing of table 3 occurs only after table 2's columns have been returned to stage 2 for it's stage 2 predicates (including subquery) and the physical join of the row from table 1 and 2 are performed. [...]
191 103 38_JDBC TO OS 390 probelm in storing data8_duam lee16_duam_lee@USA.NET29_Thu, 14 Jun 2001 23:56:40 MDT431_US-ASCII Hi Listers , I hope this questions would be answered by the experts unlike my previous doubts. I sincerely request the master's to answer these questions. I m waiting all the expert comments for this.
=========the doubt explained below============================= I'm having a problem storing a long value in a table column of type DECIMAL(19,0) in an DB2 v6 for OS/390 database. I'm curious to know if there [...]
295 28 52_Re: udf in c on linux fails, SQL0465N Reason code 4212_Jason Pyeron16_jason@PYERON.COM31_Fri, 15 Jun 2001 02:12:45 -0400499_US-ASCII I get the same results when using java udf's
42 = Failure to create the REPLY QUEUE.
SQL0465N Unable to start, initialize, or communicate with fenced mode process.Reason code "42". SQLSTATE=58032 -jp
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron Pyerotechnics Development - - Projects Manager Suite 101/2937 St Paul St - - +1 410 467 2266 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- [...]
324 15 43_Paul Park/Toronto/IBM is out of the office.21_Paul Park/Toronto/IBM16_ppark@CA.IBM.COM31_Fri, 15 Jun 2001 02:20:11 -0400395_us-ascii I will be out of the office starting June 15, 2001 and will not return until June 17, 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.
340 26 15_Re: Index usage16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 15 Jun 2001 11:45:17 +0530392_- Hi Jaydeep,
Nice to hear from you. It would be better if you could send the explain output. Also you can look the accounting report for the date range between (20001-05-05 and 2001-05-31) and (2001-05-05 and 2001-05-10). I still feels if optimizer is thinking tablespace scan is better, then it must be. So, why not compare the CPU time and I/O to look which one can be better. [...]
367 18 63_Re: udf in c on linux fails, SQL0465N Reason code 42 [solution]12_Jason Pyeron16_jason@PYERON.COM31_Fri, 15 Jun 2001 02:50:00 -0400428_US-ASCII echo "128" > /proc/sys/kernel/msgmni
they reccomend 1024 or larger for production systems default was 16
see: http://www.linuxdoc.org/HOWTO/DB2-HOWTO/kernel24.html
================================================ 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.
386 21 44_Question about CA Platinum HST01 table usage13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Fri, 15 Jun 2001 04:41:10 -0400
408 18 7_DSN8ED713_Thomas Schulz20_thomas.schulz@SVI.DE31_Fri, 15 Jun 2001 03:22:13 -0500478_- Hi Listers
I know the sample program DSN8ED7 is available in DB2 V7 to list the DSNZPARM in a list. Is ist also available in Version 5. If yes where can I find it
Thanks for any response
Thomas Schulz DBA SVI GmbH
================================================ 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.
427 101 22_Re: Impossible update?10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Fri, 15 Jun 2001 03:35:36 -0500553_- On Thu, 14 Jun 2001 18:07:49 +0100, Bruce.Williamson@PSIR.IE wrote:
>Howzit Steve? > >It is possible but pretty ugly. How big is the table you plan to update? > >Here's a start anyway: > >UPDATE table >SET C1 = DATE ( > STRIP (STRIP (CHAR (DEC (99 - DEC (SUBSTR (C3,7,2)),2,0)),L,' ') > || STRIP (CHAR (DEC (99 - DEC (SUBSTR (C3,5,2)),2,0)),L,' ') > || STRIP (CHAR (DEC (9999 - DEC (SUBSTR (C3,1,4)),4,0)),L,' ') > ,T,'.')) > , C2 = DATE ( > STRIP (STRIP (CHAR (DEC (99 - DEC (SUBSTR (C3,7,2)),2,0)),L,' ') > || STRIP (CHAR (DEC (99 - DEC [...]
529 165 47_Re: Traces, Classes and IFCIDs for DB2 OS390 V614_Adrian Collett27_adriancollett@TISCALINET.IT31_Fri, 15 Jun 2001 11:51:28 +0200646_iso-8859-1 Mike,
You can also find them in the COMMAND manual under START TRACE.
Adrian Collett DB2 Consultant Milano, ITALY.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Mike Lawrence Sent: 14 June 2001 20:46 To: DB2-L@RYCI.COM Subject: Traces, Classes and IFCIDs for DB2 OS390 V6
Hello, I am looking for a list that will show me the IFCIDs associated with a specific type of trace and class. I have the book "DB2 Answers" by RYC and they say that this list exists in a member DSNMSGS in SDSNSAMP lib...but I don't have this member. I have a [...]
695 57 23_Re: Cursors and updates22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Fri, 15 Jun 2001 08:02:50 -0300391_iso-8859-1 Dave,
The program does not use the WHERE CURRENT OF clause because the cursor has three joined tables, so it is not an "updateable" statement. The program must update two out of the three joined tables. I have just found something in the Application Programming Guide that confirms what you said. Programmers will probably work this out by changing the program logic. [...]
753 150 15_Re: Index usage13_Aysegul Cayci22_Aysegul@POLARIS.COM.TR31_Fri, 15 Jun 2001 14:18:38 +0300483_us-ascii Hi,
The distribution of data may not be uniform and DB2 optimizer may be aware of this. DB2 optimizer can be aware of non-uniform distribution, if frequency values for index columns is being collected during RUNSTATS. (you can check it by querying SYSCOLDIST catalog table). If data is skewed in the range 25/5/2001 and 30/5/2001, tablespace scan might be the best access path for any query searching this range (especially if clustering ratio of index is low). [...]
904 35 15_Re: Index usage13_Aysegul Cayci22_Aysegul@POLARIS.COM.TR31_Fri, 15 Jun 2001 14:23:14 +0300543_us-ascii If this mail is a duplicate , please just delete it.
Hi,
The distribution of data may not be uniform and DB2 optimizer may be aware of this. DB2 optimizer can be aware of non-uniform distribution, if frequency values for index columns is being collected during RUNSTATS. (you can check it by querying SYSCOLDIST catalog table). If data is skewed in the range 25/5/2001 and 30/5/2001, tablespace scan might be the best access path for any query searching this range (especially if clustering ratio of index is low). [...]
940 59 30_Re: Database holy war - UPSERT13_Popwell, Greg26_Greg.Popwell@BELLSOUTH.COM31_Fri, 15 Jun 2001 08:37:12 -0400539_iso-8859-1 Which world leader would Lou would be in the "Two Tribes" video?
Greg
-----Original Message----- From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Thursday, June 14, 2001 8:01 PM To: DB2-L@RYCI.COM Subject: Re: Database holy war - UPSERT
I think 'Frankie goes to Hollywood' had the right idea. Get Lou Gerstner and Larry Ellison in a ring and let them slug it out. The one standing at the end is the winner. Just as civilized as any other method of determining the 'winner'. [...]
1000 53 21_Re: DRDA problem.....17_Mondello, Richard27_Richard.Mondello@PFIZER.COM31_Fri, 15 Jun 2001 08:34:45 -0400460_iso-8859-1 Hi Shreedhar,
I'm hoping you are the shreedhar that worked with me at PSE&G. How are you doing? I've been asked to some DB2 work in terms of backing up a consultant for the few remaining DB2 systems Pfizer has. The last I heard from Vadim you were in the NC. Vadim is still with Oracle, I left last Dec. to take a job with Pfizer. I'm trying to get Vadim a job at Pfizer, not successful so far. Well just wanted to say hello, Take care. [...]
1054 35 34_Where should we put our databases?0_22_BILL_GALLAGHER@PHL.COM31_Fri, 15 Jun 2001 09:26:29 -0400355_us-ascii Hi,
For many years, we've had two database environments in our shop: DB2 for OS/390 has been our high-end database server, and MS SQL Server for NT has been our low-end database server. For us, it has always been fairly easy to determine when a particular application was better suited for DB2 on the mainframe, or SQL Server for NT. [...]
1090 60 67_Re: back end panel or exit to DB2 SPUFI option to submit batch jobs11_Suresh Sane21_data_arch@HOTMAIL.COM31_Fri, 15 Jun 2001 08:56:34 -0500354_- Robert,
One quick solution that should work for you is setting the RLF limit in DSNTLSTxx table for plan/package DSNESPCS and/or RR to zero. That way - not only do you prevent them from using it but also set up a trap and wait for the phone call complaining of sqlcode -905. Then you go after them! I have done this for RR isolation level. [...]
1151 64 38_Re: Where should we put our databases?14_Scott Trometer22_scott.trometer@RCI.COM31_Fri, 15 Jun 2001 09:03:33 -0500414_iso-8859-1 Bill,
I can't really help you w/ your decision making but I was curious...what was the justification for the DB2 on AIX? Was the mainframe not meeting some new or potential business need??
-----Original Message----- From: BILL_GALLAGHER@PHL.COM [mailto:BILL_GALLAGHER@PHL.COM] Sent: Friday, June 15, 2001 8:26 AM To: DB2-L@RYCI.COM Subject: Where should we put our databases? [...]
1216 29 36_Problem with bind to v7.1. Very slow11_Mike Hately20_MHately@ETECH-UK.COM31_Fri, 15 Jun 2001 15:08:05 +0100405_us-ascii Hi folks,
Platform : AIX 4.3 RDBMS : v7.1 EE Language : IBM COBOL
I'm supporting a team of developers who are seeing database binds take a very long time when making COBOL executables with embedded SQL. The problem seems as though it may be related to the use of IBM's debugger, xldb in that a bind runs much more slowly when anyone is using the debugger on the same database. [...]
1246 64 11_Index usage13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Fri, 15 Jun 2001 10:31:33 -0400286_us-ascii Hello all ,
Here is the portion of the explain :
PLANNO : 1 METHOD : 0 CREATOR : WOM TNAME : TERM_CALL_DETAIL TABNO : 1 ACCESSTYPE : R MATCHCOLS : 0 ACCESSNAME : 0 INDEXONLY : N PREFETCH : S PAGE RANGE : - - No sorts - ACCESS DEGREE : - PARALLELISM MODE : - [...]
1311 56 67_Re: back end panel or exit to DB2 SPUFI option to submit batch jobs17_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Sat, 16 Jun 2001 00:55:48 +1000281_us-ascii Hi, It is possible to get SPUFI to run in batch. A number of year ago I wrote a CLIST front end which gives you the option to submit SPUFI in BATCH or ONLINE. I also included some of options which are on different panels in DB2I/SPUFI eg DB2 subsystem id, blocksize. [...]
1368 135 30_Re: Database holy war - UPSERT23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 15 Jun 2001 10:58:26 -0400660_iso-8859-1 REDWOOD SHORES, Calif. (AP) - Oracle Corp. (NasdaqNM:ORCL -news) slashed the price on its database software by nearly 50 percent on Thursday in an effort to thwart recent advances by rivals IBM and Microsoft Corp. (NasdaqNM:MSFT - news).The price cut comes amid growing concern that Oracle has been losing business in its biggest market under a 11/2-year-old pricing formula that charged customers more for database software as their computer processors became more powerful. With Thursday's switch, a customer that paid $326,000 for Oracle's main database product a month ago would pay $160,000 under the new plan, said industry analyst Betsy [...]
1504 117 38_Re: Where should we put our databases?0_22_BILL_GALLAGHER@PHL.COM31_Fri, 15 Jun 2001 10:50:48 -0400550_us-ascii Scott,
The mainframe has always met all of our needs. The reason why DB2 for AIX was brought into our shop was to fill a role as a "mid-range" database server for databases that are bigger than what we would like to run in SQL Server, but don't need the power or size of the mainframe. However, none of the databases that we have put on AIX have really fit cleanly into this specification . . . most of them were better sized for a small SQL Server database, and the one large database that the applications originally wanted to [...]
1622 101 30_Press release on Oracle vs DB214_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Fri, 15 Jun 2001 10:26:02 -0500684_iso-8859-1 In case you missed this buried in another thread. It is important if Oracle vs DB2 is an issue. Thank you Sanjay for sending this in.
Regards, Richard +-----+-----+-----+-----+-----+ Richard_Yevich@YLAssoc.com YL&A - http://www.YLAssoc.com DB2 and Sysplex Gold Consultant Certified DB2 DBA for OS/390, z/OS
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Jain, Sanjay (Exchange) > Sent: Friday, June 15, 2001 9:58 AM > To: DB2-L@RYCI.COM > Subject: Re: Database holy war - UPSERT > > > REDWOOD SHORES, Calif. (AP) - Oracle Corp. (NasdaqNM:ORCL -news) > slashed the > price on its database [...]
1724 143 38_Re: Where should we put our databases?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 15 Jun 2001 11:38:15 -0400439_iso-8859-1 Among other things, anything currently on SQL Server and needing a high degree of integrity and recoverability would be a candidate for either DB2. Anything on SQL Server which might some day need to be joined with Other DB2 data would be a good candidate. Consider also that it may be worthwhile to move *all* the SQL Server stuff to DB2/AIX or DB2/Windows and have only one database family to know - leverage skills etc. [...]
1868 114 56_Re: Stored procedure debugging on OS390 using a COBOL SP17_Linda F. Claussen18_lindafc@NETINS.NET31_Fri, 15 Jun 2001 10:43:23 -0500444_iso-8859-1 The runtime options are specified in the CREATE PROCEDURE statement in V6 and for V5 when you insert the row in the SYSPROCEDURES table.
Cheers, Linda Claussen
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of K.Balaji Sent: Thursday, June 14, 2001 10:34 PM To: DB2-L@RYCI.COM Subject: Re: Stored procedure debugging on OS390 using a COBOL SP Sensitivity: Personal [...]
1983 95 15_Re: Index usage13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Fri, 15 Jun 2001 08:51:03 -0700382_us-ascii Hi Jaydeep,
Instead of conjecturing and guessing which access path would be better, why not temporarily tweak catalog statistics (say increase FIRSTKEYCARD to 200000) and then run your query. It should now use the index (check that in Explain). Compare this with the time it is taking at present (when it is doing a tablespace scan) to see which one is better. [...]
2079 25 12_Oracle again13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Fri, 15 Jun 2001 08:56:28 -0700366_iso-8859-1 Recently, in India, IBM announced the National Entrance Test (NET) for entry into the IBM Advanced Certificate in Software Engineering (IBM ACSE) course; It is an 8 month, fast track course which provides for a strong programming foundation and builds proficiency in Enterpise Computing, Java, Web Programing, Object Oriented Programming and Oracle. [...]
2105 58 38_Re: Where should we put our databases?12_Brian Church19_bchurch@DEJAZZD.COM31_Fri, 15 Jun 2001 11:49:02 -0400344_us-ascii If the mainframe satisfies your needs when databases are too large for SQL Server there probably isn't a good reason to have a mid-level server. If you don't have availability problems or distributed processing needs, then stay away from the mid-level and save yourself a lot religious wars about putting things on the AIX boxes. [...]
2164 21 16_Re: Oracle again26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Fri, 15 Jun 2001 09:01:08 -0700581_iso-8859-1 > Ashish stated: >Why is IBM doing Oracle this favor? With all this recent spate of >choicest insinuations from Oracle pointed towards IBM, I cannot even >imagine Oracle ever teaching DB2.
Don't forget that IBM has a services division. Why limit themselves to just selling DB2 services?
Bill Johnson Russell Mellon
================================================ 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.
2186 50 16_Re: Oracle again12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Fri, 15 Jun 2001 11:27:19 -0500278_iso-8859-1 Ashish:
You ask a good question to which I wish I had a good answer. I do not. I am a member of the IBM DB2 Gold Team and we do ask question such as yours of IBM. I have used your letter as the basis of an inquery. When I get an answer I'll let you know. [...]
2237 40 80_June 11th Issue of Computer World page 8, Oracle Escalates Databa se War with 9i14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Fri, 15 Jun 2001 09:38:25 -070081_- The previously mentioned article is in the latest issue of Computer World. Phil
2278 201 25_Query on Nested Loop Join25_Loganathan M Ramachandran41_loganathan.m.ramachandran@MAIL.SPRINT.COM31_Fri, 15 Jun 2001 12:28:22 -0500750_ISO-8859-1 Hi,
Have a problem with the nested loop join and would like to get your suggestions.
DB2 V6 on OS/390. I have a Dynamic query joining two tables VLBR_FNC (6595 rows) and VMTL_CD (37850 rows) as follows:
SELECT A.CRP_CD, A.UTI_CMP_NBR, A.BUS_GRP_ID, A.MTL_CD, A.FNC_CD, A.RSR_TYP_CD, B.MTL_CD_TX, A.NCAP_LN_ITEM_NBR, A.ULT_ACN_CD FROM PGDSC.VLBR_FNC A, PGDSC.VMTL_CD B WHERE A.BUS_GRP_ID = 'LTD ' AND A.RSR_TYP_CD > ' ' AND A.MTL_CD = B.MTL_CD AND A.EFF_DT <= CURRENT DATE AND A.INA_DT > CURRENT DATE AND B.EFF_DT <= CURRENT DATE AND B.INA_DT > CURRENT DATE UNION ALL SELECT A.CRP_CD, A.UTI_CMP_NBR, A.BUS_GRP_ID, A.MTL_CD, A.FNC_CD, A.RSR_TYP_CD, B.MTL_CD_TX, A.NCAP_LN_ITEM_NBR, A.ULT_ACN_CD FROM PGDSC.VLBR_FNC [...]
2480 82 29_Re: Query on Nested Loop Join34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Fri, 15 Jun 2001 14:21:42 -0400329_iso-8859-1 Hi Loga
Here are my opinion on questions you asked.
>> I don't understand why the additional criteria caused table VMTL_CD to >> become as the outer table. It's my understanding that during the Nested >> loop join the table with less number of rows will be the one in the >> outer join. Am I wrong? [...]
2563 44 23_Re: websphere and java?34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Fri, 15 Jun 2001 14:24:49 -0400410_iso-8859-1 We did touch the surface and evaluated Webshpere & java servlets on OS/390, unfortunately right now management doesn't feel that as strategic direction.
There is a plenty of documentation for it is all scattered. IBM marketing folks usually arrange for 3 days free classes. One I attented at IBM Gaithersburg last year, which was very helpful. I suggest touch-base with Marketing folks. [...]
2608 18 39_Command to get 'check pending' tables ?14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Fri, 15 Jun 2001 14:32:01 -0400444_iso-8859-1 Hello List,
Is there a command to get a list of tables in a UDB database which are in 'Check pending' state ? Or anything else without using any 3rd party tool ?
Thanks, Abhijit
================================================ 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.
2627 48 43_Re: Command to get 'check pending' tables ?13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Fri, 15 Jun 2001 12:00:40 -0700434_iso-8859-1 Hope this is not UDB for OS/390. The column STATUS in SYSCAT.TABLES gives you this info.
Select Tabschema, Tabname, STATUS, SUBSTR(CONST_CHECKED,1,1) AS FK, SUBSTR(CONST_CHECKED,2,1) AS Check_const, SUBSTR(CONST_CHECKED,3,1) AS Summary_tables FROM SYSCAT.TABLES WHERE STATUS = 'C'
FK, Check_const and Summary_tables columns will tell you which of the constraints is not being met.
Thanks. Ashish. [...]
2676 10 43_Re: COMMAND TO GET 'CHECK PENDING' TABLES ?16_Bernard Greenman27_Bud.Greenman@ONONDAGA.NY.US31_Fri, 15 Jun 2001 15:03:00 -0400302_- try select * from sysibm.systablespace where status = 'p';
================================================ 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.
2687 35 43_Re: COMMAND TO GET 'CHECK PENDING' TABLES ?12_Deluca, Fred27_Fred.Deluca@CCRA-ADRC.GC.CA31_Fri, 15 Jun 2001 15:21:12 -0400681_iso-8859-1 TRY on OS390
- DIS DB(dbname) SPACE(*) LIMIT(*) RESTRICT
Thanks, Fred De Luca DB2 DB Specialist DSD/ADBS Fred.Deluca@ccra-adrc.gc.ca
-----Original Message----- From: Bernard Greenman [mailto:Bud.Greenman@ONONDAGA.NY.US] Sent: June 15, 2001 3:03 PM To: DB2-L@RYCI.COM Subject: Re: COMMAND TO GET 'CHECK PENDING' TABLES ?
try select * from sysibm.systablespace where status = 'p';
================================================ 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. [...]
2723 32 0_13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Fri, 15 Jun 2001 15:32:49 -0400549_us-ascii Hello Ashish ,
I fully agree with your statement that 'Well, DB2 is conspicuous by it's absence' as applied to India . For the vast majority of the IT people there , including developers and managers , a RDBMS usually means Oracle and a DBA is one who does administration on Oracle . There is almost no presence of DB2 in colleges , or more importantly , in training institutes , which churn out IT workforce in large numbers , of which some would be decision makers in future . Obviously , those decision makers chose Oracle . [...]
2756 36 12_Oracle again13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Fri, 15 Jun 2001 15:42:49 -0400603_us-ascii ------------ Sending it again , please ignore if duplicate ------------------------------------
Hello Ashish ,
I fully agree with your statement that 'Well, DB2 is conspicuous by it's absence' as applied to India . For the vast majority of the IT people there , including developers and managers , a RDBMS usually means Oracle and a DBA is one who does administration on Oracle . There is almost no presence of DB2 in colleges , or more importantly , in training institutes , which churn out IT workforce in large numbers , of which some would be decision makers in future . [...]
2793 65 0_13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Fri, 15 Jun 2001 12:47:51 -0700474_iso-8859-1 '...RDBMS usually means Oracle in India..' and IBM is only doing it's bit to reinforce that image:-). Jaydeep, you know geographical boundaries don't matter in IT and with all the shortage of 'qualified DB2 professionals' globally that IBM makes us to believe, it could do better than teach Oracle. Read a statement few days back by IBM India manager. I forget the exact wordings but it's gist was 'Oracle beware, DB2 has arrived...it's an all out war now'. [...]
2859 64 43_Re: Command to get 'check pending' tables ?14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Fri, 15 Jun 2001 16:48:38 -0400402_iso-8859-1 Thanks Ashish. Works like a charm. Its UDB 7.1 on NT and Solaris.
Abhijit
-----Original Message----- From: Mohan, Ashish [mailto:Ashish.Mohan@NIKE.COM] Sent: Friday, June 15, 2001 3:01 PM To: DB2-L@RYCI.COM Subject: Re: Command to get 'check pending' tables ?
Hope this is not UDB for OS/390. The column STATUS in SYSCAT.TABLES gives you this info. [...]
2924 16 0_17_Michael Antonelli18_mantone1@YAHOO.COM31_Fri, 15 Jun 2001 16:22:36 -0700414_us-ascii "SIGNOFF DB2-L"
__________________________________________________ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
2941 30 17_Next record Query20_MANIKHANDAN Ramasamy21_RManikha@COVANSYS.COM31_Fri, 15 Jun 2001 22:16:23 -0400324_- Hi List,
I need a Query to fetch only the next record from the table. For example, Consider my table has only one column,the values are say 15,20,25,30.
Here i need only the next row of 15.(i,e 20) and not all the subsequent rows (20,25 and 30.).
Since i am new to DB2 , pl help me with a Query. [...]
2972 89 21_Re: Next record Query12_Hemant Kumar24_hkumar@LOT.TATASTEEL.COM31_Sat, 16 Jun 2001 09:34:08 +0530640_iso-8859-1 hi manikhandan
select min(col name) from table where col name > 15
will it suffice ur requirement
Hemant Kumar, ITS, Tata Steel. |------------------------+------------------------+------------------------| | | MANIKHANDAN Ramasamy | | | | | DB2-L@RYCI.COM | | | Sent by: DB2 Data | cc: | | | Base Discussion List | Subject: | | | | Next record Query | | | | | | | 06/16/01 07:46 AM | | | | Please respond to DB2| | | | Data Base Discussion | | | | List | | | | | | |------------------------+------------------------+------------------------| [...]
3062 28 26_Why does Big Blue do that?13_Henry J. Cobb14_hcobb@SLIP.NET31_Fri, 15 Jun 2001 23:33:14 -0500370_- > Ashish stated: >Why is IBM doing Oracle this favor? With all this recent spate of >choicest insinuations from Oracle pointed towards IBM, I cannot even >imagine Oracle ever teaching DB2.
IBM is bigger than that.
They've been at this since the days of dangling chads.
The feds gave them a real shock a while back and they've grown up a bit. [...]
3091 65 17_Next record Query16_Norbert Thiebaud23_norbert@INFOTELCORP.COM31_Sat, 16 Jun 2001 03:28:33 -0400474_iso-8859-1 First 'Next' in the table assume an order relation. There is no implicit garanteed order in SQL unless you specify an order-by
Now, If you statement is embedded in a program you have a cursor... just fetch twice and ignore the first one...
If you really want just a SQL statment that retrun 1 rows, we will have to assume that what you are looking for is the second smallest value (second biggest works too if you replace min() by max() below) [...]
3157 65 16_Indexing problem13_Arora, Ashish26_ashish.arora@HPSGLOBAL.COM31_Sat, 16 Jun 2001 16:56:44 +0530501_- Hi all,
I'm using DB2 7.1 (on NT + AIX), with none fixpacks. I hv a column of varchar, length 512. I want to execute a sql using "ORDER BY" on that column, but DB2 does not allow me to have column of more than 255 in the "ORDER BY" clause. Moreover it doesn't allow me to create an index on a column whose length is greater than 255. Can anyone tell me that is there a way to index a column whose length is greater than 255 or can this be rectified by installing any of the fixpacks ??? [...]
3223 43 24_Problem in creating view13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Sat, 16 Jun 2001 17:08:07 +0500629_- Hi,
I am trying to create a view on the following table Table Language ( lang_id bigint, iso_shotcode varchar(10), name varchar(100) ) The view is also very simple
create view tfc30.cp_languages_view_v30 as select lang_id,iso_shortcode,name from language order by name;
But I am getting the following error DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "from language" was found following "rtcode, language.name". Expected tokens may include: "". SQLSTATE=42601 [...]
3267 86 30_Re: Database holy war - UPSERT0_24_ujjwal@LOT.TATASTEEL.COM31_Sat, 16 Jun 2001 18:00:38 +0530502_us-ascii I think this is taking too much on Oracle . This thread is never ending .Why don't somebody take some of the good things of Oracle instead of bashing continuasly. There is no doubt that DB2 is sound in terms of Recovery,Performance, Integrity etc etc but then coming to SQL features I am yet to see some features like SAVEPOINT , hold on I am talking about DB2 V5. This is what Henry Ford had to say : I hope it is not ... HENRY FORD : " PEOPLE CAN HAVE IT IN ANY COLOUR AS LONG AS IT IS [...]
3354 21 46_Re: AW: DB2 V5 to V7 MIGRATION budget surprise12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 16 Jun 2001 13:19:55 -0500540_- There was a price difference when moving from V5 to V6 of around 15% as I remember it. There was some variation, and some customers found the total to be nearly 20%. While I know the specifics are much more complicated, in general terms, the V7 base price is about 10% more than V6. The V7 utilities suite is about 8% of the V6 price, but that is converted to a one time charge. Then it get financed in many situations. Currency translations add another level of differences. If you had some form of special pricing like NALC on the [...]
3376 36 21_Re: Database holy war12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 16 Jun 2001 14:00:57 -0500490_ISO-8859-1 If you are interested in some of the early history, we had an SQL reunion back in 1995, with most of the historical people: Paul McJones, Roger Bamford, Mike Blasgen, Don Chamberlin, Josephine Cheng, Jean-Jacques Daudenarde, Shel Finkelstein, Jim Gray, Bob Jolls, Bruce Lindsay, Raymond Lorie, Jim Mehl, Roger Miller, C. Mohan, John Nauman, Mike Pong, Tom Price, Franco Putzolu, Mario Schkolnick, Bob Selinger, Pat Selinger, Don Slutz, Irv Traiger, Brad Wade, and Bob Yost. [...]
3413 20 22_Re: Database holy war.12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 16 Jun 2001 14:36:33 -0500613_- I'm sure that your local sales person can talk on this for hours or days, if you have the time. They have huge amounts of information available on db2info, but we don't publish externally. The reasons tend to start by asking what problems you are having, from costs, optimization, support, connections, depth of the implementations and technology, integration with other products and other data in your company, partnerships with key vendors like SAP, PeopleSoft, Siebel, ... Then we can fill in the points more easily. My opinion is that most IBMers don't want to be attacking or defending, but sometimes [...]
3434 14 11_Re: DSN8ED712_Roger Miller19_millerrl@US.IBM.COM31_Sat, 16 Jun 2001 15:57:37 -0500453_- DSN8ED7 just called DSNWZP, which is in the older releases. DSNWZP interprets the IFCID 0106 record, which has been around for a very long time. I think DSN8ED7 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.
3449 14 28_Re: Problem in creating view12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 16 Jun 2001 16:18:29 -0500450_- ORDER BY is not allowed on CREATE VIEW - only on SELECT statements. You can dig this out of the SQL Reference - CREATE VIEW is a subselect, which does not have an ORDER BY.
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.
3464 67 23_Re: Pessimistic Locking14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 17 Jun 2001 02:43:42 -0500612_- Dennis,
Perhaps my juxtapostion of a discussion of a pessimistic locking scenario with the comment about rowids misled you.
1) a db2 rowid can be used only if the table has a column of type ROWID 2) the contents of the rowid column contain invarient information which identifies the row, and the "time" it was inserted. ("time" here refers to a code identifying the number of times a load replace or reorg has been carried out on the tablespace.) 3) the information returned from a "select rowid_column into :hv_rowid ..." includes the invarient information stored in the table, the current [...]
3532 112 23_Re: V6 & Reserved Words14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 17 Jun 2001 03:06:37 -0500536_- Marcia,
I think Steve meant to write "My guess is that so long as the column name is not also a key word for the Parser _in the context in which it appears_ it's OK for it to appear in a query without delimiting."
In my experience this is mostly correct. The one exception I have found is ALTER TABLE ... DROP FOREIGN KEY XXXXX. If XXXXX is a reserved word, then this can fail on a syntax error - with the error position pointing to the word DROP! Very confusing. (And, if you're interested, PSID was the keyword I [...]
3645 54 31_Reorg running forever : DB2 AIX14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Sun, 17 Jun 2001 13:15:28 -0400249_iso-8859-1 We had a REORG job run for 22 hours before we killed it. The table has 13 million rows and 2 indexes have been defined on it. By the time I got to look at the problem a db2stop had been issued and I did not get to run any snapshots. [...]
3700 31 49_John Matear/SDG/SS/BankWest is out of the office.11_John Matear32_John.Matear@CBS-SOLUTIONS.COM.AU31_Mon, 18 Jun 2001 01:34:25 +0800442_us-ascii I will be out of the office from 06/18/2001 until 06/22/2001.
Please contact Ron Hesketh - 94498730
This message was automatically generated by the Lotus Notes Out-Of-Office agent
_______________________________________________________________________________ Unencrypted electronic mail is not secure and may not be authentic. If you have any doubts as to the contents please telephone to confirm. [...]
3732 19 16_Re: DB2 Presence12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Sun, 17 Jun 2001 15:46:44 -0500425_iso-8859-1 IBM is trying to change the "no presence of DB2 in colleges". They have a program, DB2 Scholars, which provides free software, free training for Professors, free books, cut rates at conferences, etc. for students, professors and researchers. Anyone interested can register at http://www-4.ibm.com/software/data/highered/. My graduate class rec'd db2 udb, db developer, visual warehouse, etc. Hope this helps. [...]
3752 52 25_When Two Tribes Go To War15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Mon, 18 Jun 2001 11:27:42 +1000471_- Hmmm, tricky one. Well, as Ronny Ray-gun was such a nut-job it seems logical that Mr. E (or is that 'the big O'? - apologies to Roy Orbison) should be represented by him. But then that leaves the then-largest Communist country leader to represent the world's largest capitalist IT company, which kinda doesn't make sense. So maybe we can change the rules slightly and have two Ronny's ('The Two Ronnies'? So who would be Barker and who would be Corbett?) instead. [...]
3805 55 20_Re: Indexing problem11_Grant Allen22_grant@TOWERSOFT.COM.AU31_Mon, 18 Jun 2001 11:58:33 +1000498_- Arora, Ashish[SMTP:ashish.arora@HPSGLOBAL.COM] wrote: > > Hi all, > > > > I'm using DB2 7.1 (on NT + AIX), with none fixpacks. I hv a column of > varchar, length 512. I want to execute a sql using "ORDER BY" on that > column, but DB2 does not allow me to have column of more than 255 in the > "ORDER BY" clause. Moreover it doesn't allow me to create an index on a > column whose length is greater than 255. Can anyone tell me that is there > a way to index a column whose length is greater [...]
3861 101 42_500+ links about DB2 for OS/390 (06/11/01)6_DB2usa18_db2usa@HOTMAIL.COM31_Sun, 17 Jun 2001 21:24:50 -0500568_ISO-8859-1 Hi,
Here is a non-profit website about DB2 for OS/390 (IBM mainframes):
- English : http://db2usa.hypermart.net/eliendb2.htm - Français: http://db2usa.hypermart.net/liendb2.htm
Last update on Monday, June 11th 2001 ======================================
* Technical papers about DB2: http://db2usa.hypermart.net/earticle.htm Summer 2001 issue of DB2mag is available on line: - The Limited Case For Dynamic SQL by Robert Catterall, DB2mag, Summer 2001. - Predicates Evaluation: Part III by Bonnie Baker, DB2mag, Summer 2001. [...]
3963 120 30_Re: Database holy war - UPSERT16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 18 Jun 2001 09:43:08 +0530451_- When IBM made DB2, i think it would never have thought about keeping such features. I personally don't like this. There are something which we 'intelligent' people have to do. Since other databases have started giving these features which made 'non-intelligent' people coming and joining IT. IBM have to survive in this competition and hence thought about being in the market with all the facilities other databases have. So what IBM have is : [...]
4084 69 16_Re: Oracle again16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 18 Jun 2001 10:02:42 +0530555_- Ashish and others,
As i am located in India, i feel i can give some clear picture of what is happening our here.
I think problem here are promotion policy and advertisement strategy. I can't comment about marketting strategy because i am not aware of this. But till now, in India i have found only one advertisement of DB2 in a newspaper......however, i don't read more than 4 newspapers in a day and 5 magazines per month. But it should be more easily there and WHY SHOULD IT BE THERE IN THE "IT" magazines, it is read by IT people. [...]
4154 169 30_Re: Database holy war - UPSERT0_24_ujjwal@LOT.TATASTEEL.COM31_Mon, 18 Jun 2001 10:05:02 +0530553_us-ascii There is nothing called ' I personally feel' in the market .The market is been and should always be dictated by Customers whether he is a fool or intelligent . A Customer is a Customer . A fool can ask more questions than a wiseman can answer. Intelligent people had to change there marketing stragety of late. And when u r talking to be with Technology, my friend this features which u call technology was there in the early 90's. So please look from an angle of Application Developers point of view. And I am not aware of other features [...]
4324 49 21_Re: Next record Query16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 18 Jun 2001 10:28:23 +0530583_- I am not sure which version of DB2 you are in but V7 for OS390/z-OS offers scrollable cursors which gives the facility to use FETCH NEXT records. Do let us know if you require any more details on this.
Regards Sanjeev
> -----Original Message----- > From: MANIKHANDAN Ramasamy [SMTP:RManikha@COVANSYS.COM] > Sent: Saturday, June 16, 2001 7:46 AM > To: DB2-L@RYCI.COM > Subject: Next record Query > > Hi List, > > I need a Query to fetch only the next record from the table. > For example, > Consider my table has only one column,the values are say 15,20,25,30. > [...]
4374 204 30_Re: Database holy war - UPSERT16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 18 Jun 2001 10:34:50 +0530647_iso-8859-1 Correct ! But every customers have their own opinion. Being a customer, i mentioned my feeling (as i can't know what others feel). As far as the "Intelligent" and "Non-Intelligent" remarks are concerned, that is for programmers who can be intelligent or non-intelligent. Progrmmers do the coding, so how efficiently it can be done, is depending on his/her intelligence. As far as application developers features are concerned, other databases have many and are good. But databases are bought not to make the life of "only" application developers easy but its a trade off among users(customers), application developers and DBAs. So [...]
4579 16 51_David Ayers/ISG/CORP/Highmark is out of the office.11_David Ayers24_david.ayers@HIGHMARK.COM31_Mon, 18 Jun 2001 01:01:01 -0400452_us-ascii I will be out of the office starting 06/15/2001 and will not return until 06/22/2001.
For DB2 OS/390 assistance contact your support DBA. For Datajoiner / DB2 connect support contact Chuck Krall
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4596 30 49_Dean J Burchill/TCC/DCC/DCX is out of the office.0_24_db46@DAIMLERCHRYSLER.COM31_Mon, 18 Jun 2001 04:01:28 -0400790_us-ascii I will be out of the office starting 06/18/2001 and will not return until 06/25/2001.
I will respond to your message when I return.
For emergency reasons only, you can contact my home at (810) 296-2356
****************************************************************************
The information contained in this transmission, which may be confidential and proprietary, is only for the intended recipients. Unauthorized use is strictly prohibited. If you receive this transmission in error, please notify me immediately by telephone or electronic mail and confirm that you deleted this transmission and the reply from your electronic mail system. **************************************************************************** [...]
4627 64 18_Nasty access path!14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Mon, 18 Jun 2001 09:37:12 +0100507_iso-8859-1 Hi'yall.
We've a heavily-used, tiny work table, 24 pages, one index. The delete statement in Prod takes a tablespace scan access path, which causes much contention. QA (different machine, subsystem, but otherwise identical) does a matching index scan - preferable. To try and solve it, I did in prod, "ALTER TABLESPACE DFIGP1J.SRTNWRK MAXROWS 1 PRIQTY 720 SECQTY 720 PCTFREE 0 FREEPAGE 1;" to pad it out a bit. Reorg/runstats/rebind, and voilá - matching index scan, goodbye ts scan! [...]
4692 79 22_Re: Nasty access path!16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 18 Jun 2001 15:00:54 +0530337_iso-8859-1 Hi Marcus,
It could be very difficult to say without actually looking at anything i.e. query, accesspath or monitor output because as we know, accesspath depends on many things.
When you issues the ALTER TABLESPACE, how many pages table had ?. This will be equal to the number of rows because MAXROWS is 1. [...]
4772 77 22_Re: Nasty access path!14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Mon, 18 Jun 2001 10:27:25 +0100601_iso-8859-1 Further to this... We're DB2 for OS/390 V5.1. We've just put 159 rows of rubbish into it, did a runstats/rebind, and it's using the index again. This is a bit of a cowboy approach, but it works. My questions still stand, though.
> -----Original Message----- > From: Davage, Marcus > Sent: 18 June 2001 09:37 > To: DB2-L (E-mail) > Subject: Nasty access path! > > Hi'yall. > > We've a heavily-used, tiny work table, 24 pages, one index. The delete > statement in Prod takes a tablespace scan access path, which causes much > contention. QA (different machine, subsystem, [...]
4850 44 23_Re: Cursors and updates15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Mon, 18 Jun 2001 05:03:26 -0500564_- Hello David
I'm just wondering: Can a cursor joining three tables be coded with the FOR UPDATE OF CLAUSE, because it's by definition READ ONLY?
And one more item: Will the access path change, when I use this clause?
To me it seems, that if the cursor points to the basic table, it is possible that the phenomen occurs as you described, but if I can achieve, that the cursor will be materialized in a temporary file (may be by adding an ORDER BY clause) this will be the only way to preclude that (again: the cursor won't be updateble). [...]
4895 47 25_Use of GRAPHIC (Win/Unix)11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Mon, 18 Jun 2001 13:14:54 +0200446_us-ascii Hi gurus,
could anybody explain me, what the graphic data types (GRAPHIC, VARGRAPHIC, DBCLOB) are good for? I know only that they contain double-byte characters (DBCS).
Some questions from the practice:
(DB2 V7.1 AIX/Win2k)
According to my experience, graphic columns can be used only in MBCS databases (that have an MBCS codepage, for example 1363 - Korean) OK, I have a Korean db, with code page 1363. [...]
4943 12 21_Re: DRDA problem.....0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Mon, 18 Jun 2001 07:58:24 -0400307_us-ascii Check to see if your packages are valid on the DB server
================================================ 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.
4956 14 16_program swapping17_Polley, Mike (M.)16_mpolley@FORD.COM31_Mon, 18 Jun 2001 07:57:57 -0400470_iso-8859-1 A while back (many years) there was a standard established in our shop that all DB2 programs had to be IMS BMPs so that they would not be swapped out. Many new hired DB2 developers resisted this standard but to no avail. We're wondering if this standard is now obsolete like putting as much code as you can on one line to limit the number of punched cards. Is this still a good standard to have or have we missed something in one of the releases of DB2? [...]
4971 57 21_Re: DRDA problem.....7_Vishy N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Mon, 18 Jun 2001 17:44:17 +0530324_us-ascii hi, The packages are valid ... but if its an error .. won't db2 return error . ya .. I think the packages are not valid ..but this happens erratically .. sometimes it runs and sometimes not .. .. so actually I know that IBM has a PTF for this ... but I am not able to pin point the error... can anyone help ?? [...]
5029 42 20_Re: program swapping15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Mon, 18 Jun 2001 07:24:57 -0500457_iso-8859-1 Hardline view.
_All_ batch programs should have checkpoint/restart logic. This much easier to do if they are BMPs where the IMS XRST command provides the working storage restore and GSAM seq. file repositioning.
Andy Lankester bmcsoftware My opinions are just that
-----Original Message----- From: Polley, Mike (M.) [mailto:mpolley@FORD.COM] Sent: 18 June 2001 12:58 To: DB2-L@RYCI.COM Subject: program swapping [...]
5072 65 35_Re: Reorg running forever : DB2 AIX14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Mon, 18 Jun 2001 07:37:41 -0500582_iso-8859-1 I have seen similar behaviour due to running out of space in a file system. Fixing that problem got the thing working again.
From Edward Vassie...
-----Original Message----- From: Manas Dasgupta [mailto:manas.dasgupta@PFSFHQ.COM] Sent: 17 June 2001 18:15 Subject: Reorg running forever : DB2 AIX
We had a REORG job run for 22 hours before we killed it. The table has 13 million rows and 2 indexes have been defined on it. By the time I got to look at the problem a db2stop had been issued and I did not get to run any snapshots. [...]
5138 35 29_Re: DSN8ED7 Zparms and DSNWZP11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Mon, 18 Jun 2001 08:44:20 -0400556_iso-8859-1 No DSN8ED7 in v6 or prior. I did however post some sample programs for calling DSNWZP out on the DB2L Documents site. Check October 2000 at:
http://jupiter.ryci.com/archives/db2-l-documents.html
-----Original Message----- From: Thomas Schulz [mailto:thomas.schulz@SVI.DE] Sent: Friday, June 15, 2001 4:22 AM Subject: DSN8ED7
Hi Listers
I know the sample program DSN8ED7 is available in DB2 V7 to list the DSNZPARM in a list. Is ist also available in Version 5. If yes where can I find it [...]
5174 74 35_Re: Reorg running forever : DB2 AIX14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Mon, 18 Jun 2001 09:29:53 -0400459_iso-8859-1 The filesystem was about 70% used ..... so we had plenty of space.
Manas. ========================================== I have seen similar behaviour due to running out of space in a file system. Fixing that problem got the thing working again.
>From Edward Vassie...
-----Original Message----- From: Manas Dasgupta [mailto:manas.dasgupta@PFSFHQ.COM] Sent: 17 June 2001 18:15 Subject: Reorg running forever : DB2 AIX [...]
5249 115 35_Re: Reorg running forever : DB2 AIX10_Mathai Joy22_mathaijoydb2@YAHOO.COM31_Mon, 18 Jun 2001 07:02:43 -0700603_us-ascii Check your temp file. Reorg needs more temp space. Mathai --- Manas Dasgupta wrote: > The filesystem was about 70% used ..... so we had > plenty of space. > > Manas. > ========================================== > I have seen similar behaviour due to running out of > space in a file system. > Fixing that problem got the thing working again. > > >From Edward Vassie... > > > -----Original Message----- > From: Manas Dasgupta > [mailto:manas.dasgupta@PFSFHQ.COM] > Sent: 17 June 2001 18:15 > Subject: Reorg running forever : DB2 AIX > > > We had a REORG job run [...]
5365 145 22_Re: Nasty access path!12_Mark Granger22_the_grange@MBOX.COM.AU31_Mon, 18 Jun 2001 09:15:44 -0500494_us-ascii Marcus, Where are the Binds being done for each system ? One site I have worked found that Binds done on their Development machine worked as expected (using expected indexes,etc), but when bound on their Production machine DB2 used a TS scan. The reason was apparently the machine was that much faster that DB2 considered TS scan the fastest method. I believe their is a option to change that in DB2 and I don't remember the DB2 version they were on (V5 I think). Just a thought. [...]
5511 125 35_Re: Reorg running forever : DB2 AIX14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Mon, 18 Jun 2001 10:21:55 -0400669_iso-8859-1 The temp tablespace is an SMS tablespace and it had access to about 6 gigs of space.
========================================= Check your temp file. Reorg needs more temp space. Mathai --- Manas Dasgupta wrote: > The filesystem was about 70% used ..... so we had > plenty of space. > > Manas. > ========================================== > I have seen similar behaviour due to running out of > space in a file system. > Fixing that problem got the thing working again. > > >From Edward Vassie... > > > -----Original Message----- > From: Manas Dasgupta > [mailto:manas.dasgupta@PFSFHQ.COM] > Sent: 17 June 2001 [...]
5637 16 11_total space13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Mon, 18 Jun 2001 09:31:24 -0500368_us-ascii Hi... Is there a way to find out how large a table is in bytes??? manual or somewhere in platinum tools
T.I.A.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5654 30 15_Re: total space14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Mon, 18 Jun 2001 09:39:44 -0500595_iso-8859-1 total the stogroup sizes for that database.
-----Original Message----- From: Derez D. Lusk [mailto:ddlusk@HOUSEHOLD.COM] Sent: Monday, June 18, 2001 9:31 AM To: DB2-L@RYCI.COM Subject: total space
Hi... Is there a way to find out how large a table is in bytes??? manual or somewhere in platinum tools
T.I.A.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...]
5685 122 22_Re: Nasty access path!14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Mon, 18 Jun 2001 15:49:25 +0100644_iso-8859-1 Hi Mark, QA binds are done on the Dev mx, and yes, the Prod is much faster. Marcus
-----Original Message----- From: Mark Granger [mailto:the_grange@MBOX.COM.AU] Sent: 18 June 2001 15:16 To: DB2-L@RYCI.COM Subject: Re: Nasty access path!
Marcus, Where are the Binds being done for each system ? One site I have worked found that Binds done on their Development machine worked as expected (using expected indexes,etc), but when bound on their Production machine DB2 used a TS scan. The reason was apparently the machine was that much faster that DB2 considered TS scan the fastest method. I believe their is [...]
5808 57 15_Re: total space0_22_BILL_GALLAGHER@PHL.COM31_Mon, 18 Jun 2001 11:01:26 -0400426_us-ascii Derez,
Look at the number of tracks used by the table, and multiply by 48k . . . that will give you a good approximation of bytes used.
Bill
"Derez D. Lusk" To: DB2-L@RYCI.COM Subject: total space Sent by: "DB2 Data Base Discussion List"
06/18/01 10:31 AM Please respond to "DB2 Data Base Discussion List" [...]
5866 46 55_DB2 Symposium - Wellington and Sydney - July 30 - Aug 312_Susan Lawson24_susan_lawson@YLASSOC.COM31_Mon, 18 Jun 2001 10:14:29 -0500497_iso-8859-1 The DB2 Symposium educational event is going to be held in Wellington, New Zealand on July 30-31st and August 2-3rd in Syndey, Australia.
Each session is one full day. There are two sessions each day to choose from.
Each session is only $250 US per student per session. This cost includes a course book, lunch and 1 copy of our DB2 UDB Version 7 Family Reference Guide (a 460 page reference for all SQL syntax, return codes, commands, and more on all DB2 platforms). [...]
5913 33 45_Range v/s IN-list predicate ? CPU reduction ?6_Chenny39_solaiyappan_chenniappan@MAIL.AMSINC.COM31_Mon, 18 Jun 2001 10:15:04 -0500422_- All,
Probably this may have been covered in the past, if so please direct me to the specific thread in the archives otherwise shed some light on this.
We are experiencing a one-third drop in CPU usage just by replacing the range predicate to IN-list predicate for queries running against a large fact table with 80 million data pages (table is partitioned & clustered by YEAR,MONTH & ORGANIZATION)... [...]
5947 32 15_Trigger problem13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Mon, 18 Jun 2001 20:25:04 +0500581_- Hello Members,
I wanted some clarification regarding Triggers and constraints.This issue came up while I was testing some BEFORE triggers for our application.
The table on which the trigger has been created has a column for which the NOT NULL constraint has been set. The trigger is so designed that if there in no value assigned to that column in the INSERT statement, then a default value is assigned in the trigger. My problem is that if I give an INSERT statement I get an error even before the trigger is fired stating "Assignment of a NULL valueto a NOT [...]
5980 75 37_DB2/VM-VSE Stored Procedures Question15_Joaquim Carmona34_joaquim.carmona@CIRCULOLEITORES.PT31_Mon, 18 Jun 2001 16:12:23 +0100570_iso-8859-1 Hello from Portugal,
With VSE 2.5/DB2 7.1 IBM gave us the Stored Procedures which, among other features, give us the possibility to access DLI databases and VSAM files through them.
Did anyone try it? What can you say about it? What are, if any, the relationships with VSE Java Connectors?
I understood that these Stored Procedures are developed in COBOL/VSE. I think this means that we cannot use DB2/VM and its Guest Sharing Feature on VSE. Instead, a database should be installed on VSE for these Stored Procedures. Is this true? [...]
6056 19 29_DS2 Stored Procedure Question15_Louis.Commodore26_Louis.Commodore@TARGET.COM31_Mon, 18 Jun 2001 10:29:22 -0500386_iso-8859-1 Good Morning Group.
It is possible to submit a batch job dynamically from within stored procedure?
Thanks Louis
================================================ 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.
6076 139 22_Re: Nasty access path!0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 18 Jun 2001 10:56:56 -0500281_iso-8859-1 Don't forget that there is a threshold on small tables where optimizer decides TS scan is more efficient than indexed access. I recall recently reading that in (OS390) DB2 V6 and up there is a zparm you can set to control this but I don't know if it applies to V5. [...]
6216 62 33_Re: DS2 Stored Procedure Question17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Mon, 18 Jun 2001 18:07:38 +0100594_us-ascii I think you need only an INTRDR dd on your SP address space and open - write - close the dd.
Best regard.
"Louis.Commodore" @RYCI.COM> on 18/06/2001 16.29.22
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: DS2 Stored Procedure Question
Good Morning Group.
It is possible to submit a batch job dynamically from within stored procedure? [...]
6279 125 22_Re: Nasty access path!12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 18 Jun 2001 19:10:13 +0200463_iso-8859-1 Hi, If it's a unique index and the delete is of 1 row (by key) then it should be via the index. In V6 you can use NPGTHRSH=-1 in DSNZPARM to favour index acess for small tables (<10 pages).
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net ----- Original Message ----- From: "Mark Granger" Newsgroups: bit.listserv.db2-l To: Sent: Monday, June 18, 2001 4:15 PM Subject: Re: Nasty access path! [...]
6405 24 33_Re: DS2 Stored Procedure Question12_Jim Harrison17_jharrison@GMX.NET31_Mon, 18 Jun 2001 12:13:35 -0400326_us-ascii I don't see why not. Just have an internal reader allocated to the SP or WLM address space - or dynamically allocate it yourself.
At 10:29 AM 06/18/2001 -0500, Louis.Commodore said: >Good Morning Group. > >It is possible to submit a batch job dynamically from within stored >procedure? > > >Thanks >Louis [...]
6430 41 33_Whats wrong with this procedure ?14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Mon, 18 Jun 2001 12:13:52 -0400372_iso-8859-1 Hi list,
I am trying to create the following simple SQL stored proc in DB2 Command center and keep getting the following error. Can anyone tell me what could be wrong ?
CREATE PROCEDURE MAC.Proc1 ( ) RESULT SETS 1 LANGUAGE SQL P1: BEGIN DECLARE C1 CURSOR WITH RETURN FOR SELECT FUNC_AREA_I FROM MAC.MAC_FUNC_AREAS_TB; OPEN C1; END P1 [...]
6472 239 11_BIN Search.31_Cagdas Ucar (Garanti Teknoloji)22_cagdasu@GARANTI.COM.TR31_Mon, 18 Jun 2001 19:24:45 +0300365_iso-8859-9 Hello all,
I'm working at the credit card department as application programmer. Our database is DB2 V6.1.
I wonder how everybody handles the BIN search problem in DB2. Search method for VSAM is standardized by major credit card companies, but there should be an easier way of doing this in DB2. The problem can be explained like this: [...]
6712 81 49_Re: Range v/s IN-list predicate ? CPU reduction ?13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 18 Jun 2001 11:32:31 -0500406_iso-8859-1 Chenny,
Unless you are V5 (and have not applied APAR PQ15670) or earlier, then you will not be obtaining index screening on list prefetch; and instead these predicates will be applied on the data pages at stage 1. Otherwise you will have all stage 1 predicates which could not be chosen as index matching, applied as screening predicates on the index pages. That is one possibility. [...]
6794 24 22_Re: Nasty access path!12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 18 Jun 2001 19:30:14 +0200384_iso-8859-1 Hi, Just realized you're on V5 so NPGTHRSH won't work ;-( Using locksize row can help to reduce the locking contention. You can add more "garbage" rows as well. Check that MAXROWS 1 really works and that no one is changing it back. If it doesn't work (bug) you can "enlarge" the rows with blank fields (I used it in V3 ....) but I'm not sure it's good to go that far. [...]
6819 76 15_Re: total space10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Mon, 18 Jun 2001 10:46:10 -0500602_us-ascii Derez, The max record length below doesn't take any kind of compression into account. Besides the old fashioned way, the RC Query from CA/Platinum screen shows the answer like this: RQTD R06.01 -------------- RC/Q Table Detail -------------- 06-18-2001 10:44 COMMAND ===> SCROLL ===> CSR PT029I - USE PF10/11 FOR UP/DOWN WITHIN DATA ITEM DB2 Object ===> T Option ===> D Table Name ===> BHTBFDTS Creator ===> DBJN Where => N Qualifier ===> * Grantor ===> * Loc: LOCAL ---------- SSID: DB2P ----------DBJN ---- FRAME 1 OF 1 NUMBER OF COLUMNS: 97 OBID: 277 EDIT PROCEDURE : NUMBER OF ROWS : [...]
6896 41 33_Re: DS2 Stored Procedure Question8_apkjha x18_apkjha@HOTMAIL.COM31_Mon, 18 Jun 2001 17:05:05 -0000671_- Hello,
Yes it is possible, I coded such an SP a couple of weeks ago. What you need to do is to add an INTRDR DD statement to your SP address space. Then write the JCL statements to INTRDR from the SP and then just close the INTRDR.
/Kjell
>From: "Louis.Commodore" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DS2 Stored Procedure Question >Date: Mon, 18 Jun 2001 10:29:22 -0500 > >Good Morning Group. > >It is possible to submit a batch job dynamically from within stored >procedure? > > >Thanks >Louis > >================================================ >To change your [...]
6938 16 17_IBM Query monitor6_Chenny39_solaiyappan_chenniappan@MAIL.AMSINC.COM31_Mon, 18 Jun 2001 12:14:27 -0500344_- All,
Does anyone have any opinions/advise on the IBM Query Monitor?
Thanks Chenny USDA
================================================ 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.
6955 9 0_15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Mon, 18 Jun 2001 12:29:35 -0500244_-
================================================ 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.
6965 17 28_UDB DB2 Archiving of the Log15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Mon, 18 Jun 2001 12:32:17 -0500311_us-ascii Would anyone be willing to share their experiance with the archiving procedure on RS6000 DB2 UDB? I am a mainframer and have to archive the logs on UDB. Is anyone using the exit program or are you creating your own script to do the archiving? Would you be willing to share your knowledge? Thanks. [...]
6983 25 20_View Auth error -16411_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 18 Jun 2001 11:03:48 -0700404_iso-8859-1 This ones a little puzzling to me. One of my DBAs is getting -164 auth error when trying to create a similar view CREATE VIEW DB1.VIEW TB1COL, TB2COL, TB3COL AS SELECT TB1COL, TB2COL, TB3COL FROM DB1.TAB1, DB1.TAB2, DB1.TAB3; I have SYSADM and ,as the error text states, can create the view. The DBA has DBADM on the database DB1, why can't a DBA create a view on tables in his database? [...]
7009 47 24_Re: View Auth error -16412_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 18 Jun 2001 21:16:33 +0200426_iso-8859-1 Hi, Can it be that one of the tables was created in the wrong database ? DB1 here is table creator, the question is in what DB they were defined.
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net ----- Original Message ----- From: "Cliff Boley" Newsgroups: bit.listserv.db2-l To: Sent: Monday, June 18, 2001 8:03 PM Subject: View Auth error -164 [...]
7057 133 24_Re: View Auth error -16414_Crichton, Jean21_jcrichton@FEDDATA.COM31_Mon, 18 Jun 2001 14:21:25 -0400308_iso-8859-1 Cliff,
Are you using ACF2/DB2 to secure DB2 objects? If so, the CREATE VIEW privilege is no longer inherent for a table owner or DBADM. If you do have ACF2/DB2, I can check with one of my ACF2 buddies to find out how CREATE VIEW needs to be authorized.
Jean E. Crichton Logicon [...]
7191 56 32_Re: UDB DB2 Archiving of the Log0_22_BILL_GALLAGHER@PHL.COM31_Mon, 18 Jun 2001 14:27:15 -0400344_us-ascii Daniel,
We're using the db2uext2 exit to archive the logs to TSM. We were able to take the "db2uext2.cadsm" sample exit in the "/sqllib/samples/c" directory and follow the directions that are documented in the source code to implement. It was surprisingly easy, even for a mainframer like me. It's worked very well for us. [...]
7248 25 48_v7 distribution installation using response file11_Richard Yan23_dhspa3f@DHS.STATE.IL.US31_Mon, 18 Jun 2001 14:06:16 -0500588_- Hi List,
We want to use response file to distribute DB2 v7 Appliation Development Client (SDK) on many window workstations, the database server is on AIX.
Is anyone out there using CONTROL_CENTER_SERVER_USERID = KEYWORD ? This userid seems to be used to start control center server on individual workstations. Since response file is for multiple pcs instead of a particular pc, so I don't know which user id I should specify in the response file. I tried to skip the keyword or put a space in, but It didn't help, DB2 kept asking for the userid and password keyword. [...]
7274 28 28_Freeing Agent Private Memory12_John Appsili18_csc266@HOTMAIL.COM31_Mon, 18 Jun 2001 14:17:37 -0500350_- Can DB2 agent private memory be freed after use ?
DB2 memory use for my application was explained to me this way :
Each DB2 connection uses what is called private and shared memory . Shared memory is freed and reused and managed by DB2. However, DB2 does not free the private memory used by a connection until the user logs off. [...]
7303 60 24_Re: View Auth error -16415_Toine Michielse18_vndobtm@US.IBM.COM31_Mon, 18 Jun 2001 21:52:21 +0200435_us-ascii Hello Cliff,
Could it be that the authid that is used to create the view is NOT DB1? If so than that is the cause. DB2 V7 will allow users with DBADM to create views with a different authid just like SYSADM. But until then....
Regards,
Toine Michielse DB2 S/390 Advocate Silicon Valley Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...]
7364 78 24_Re: View Auth error -16411_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 18 Jun 2001 13:24:12 -0700372_iso-8859-1 I added a set current sqlid to DB1 and that did the trick. I've never come across this before, guess we don't create many view here:-) Thanks everyone for your help cliff:-)
-----Original Message----- From: Toine Michielse [mailto:vndobtm@US.IBM.COM] Sent: Monday, June 18, 2001 12:52 PM To: DB2-L@RYCI.COM Subject: Re: View Auth error -164 [...]
7443 76 24_Re: View Auth error -1640_19_csutfin@AMSOUTH.COM31_Mon, 18 Jun 2001 15:26:31 -0500593_us-ascii Cliff
I have already fought with this one. Only SYSADM or SYSCTRL can create views the are qualified with something other than their own ID. I know it seems like DBADM should be able to do that. I think that is coming in the future.
The DB2V5 Admin Guide states:
If you create a table, a view, an index, an alias, or a synonym with a qualified name, then the qualifier becomes the owner of the object, subject to these restrictions: If you issue the CREATE statement dynamically, and have no administrative authority, then the qualifier must be your primary [...]
7520 93 30_Client Configuration Assistant7_Ask Db218_askdb2@HOTMAIL.COM31_Mon, 18 Jun 2001 17:01:34 -0400538_Windows-1252 Hi all,
I am able to connect to a remote database using the Client Configuration Assistant of V 6.02. This works fine. I am able to browse through all the tables from the control center.
Control center doest not show all the records for some reason and it is also hard to edit records. So we link this remote instance through ODBC and Access. I have done this many time and I am able to link perfectly in Access if it is a local database. But I cannot link a remote one. These are the errors when I try to [...]
7614 29 16_Re: Oracle again13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Mon, 18 Jun 2001 16:16:10 -0500548_- Hi Sanjeev Though I've been away from India for a while I'd disagree, not with your understanding of DB2 but with your understanding of us Indians. Here Lakshmi leads the way ( for the uninitiated Lakshmi is the godess of wealth ) and few other things matter. More ads about DB2 on the back page won't help but ads in the help wanted section will. If there are jobs available people will do anything to get them including learning what it takes or even cursing Larry Ellison. So if IBM marketing people can open a few accounts you'd see the [...]
7644 55 33_Re: DS2 Stored Procedure Question15_Louis.Commodore26_Louis.Commodore@TARGET.COM31_Mon, 18 Jun 2001 16:23:42 -0500487_iso-8859-1 Thank you Apkjha X. for this information
-----Original Message----- From: apkjha x [mailto:apkjha@HOTMAIL.COM] Sent: Monday, June 18, 2001 12:05 PM To: DB2-L@RYCI.COM Subject: Re: DS2 Stored Procedure Question
Hello,
Yes it is possible, I coded such an SP a couple of weeks ago. What you need to do is to add an INTRDR DD statement to your SP address space. Then write the JCL statements to INTRDR from the SP and then just close the INTRDR. [...]
7700 37 33_Re: DS2 Stored Procedure Question15_Louis.Commodore26_Louis.Commodore@TARGET.COM31_Mon, 18 Jun 2001 16:27:03 -0500557_iso-8859-1 Thanks to all for your information
-----Original Message----- From: Jim Harrison [mailto:jharrison@GMX.NET] Sent: Monday, June 18, 2001 11:14 AM To: DB2-L@RYCI.COM Subject: Re: DS2 Stored Procedure Question
I don't see why not. Just have an internal reader allocated to the SP or WLM address space - or dynamically allocate it yourself.
At 10:29 AM 06/18/2001 -0500, Louis.Commodore said: >Good Morning Group. > >It is possible to submit a batch job dynamically from within stored >procedure? > > >Thanks >Louis [...]
7738 137 34_Re: Client Configuration Assistant12_Troy Coleman19_Colematr@MEIJER.COM31_Mon, 18 Jun 2001 18:14:18 -0400294_US-ASCII You may have a different version of DB2 on your client than what was bound in the report site. I know that NULLID is the default owner for packages bound by the utility bind option. You may want to click on the database in CCA and then click on BIND and bind the utilities again. [...]
7876 14 22_QUERY PATROLLER-URGENT17_Francois Okaingni23_francois_26@HOTMAIL.COM31_Mon, 18 Jun 2001 17:44:39 -0500
7891 165 32_Re: Freeing Agent Private Memory14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Mon, 18 Jun 2001 19:41:09 -0700602_iso-8859-1 John, If you are memory constrained, you might want to disable pooling by letting num_poolagents default to no pooling, that way when an agent is has completed work on behalf of an application, it is terminated, not returned to the pool, thus freeing memory. This is an indirect way to "free" the memory you are talking about. If you are running AIX, take a look at the DB2MEMDISCLAIM environmental variable, this can be used in memory constrained systems to free memory. Also look at DB2MEMMAXFREE. If it helps, you can control the number of concurrent agents by setting maxagents and [...]
8057 167 15_Re: BIN Search.10_John Hardy22_john_j_hardy@YAHOO.COM31_Mon, 18 Jun 2001 21:31:16 -0500456_- I would expect (assuming that your table is keyed on BIN_NO), that you would get better results from attempting to match on 16 bytes and then work down. Something like (my Pl1 may be a bit rusty!):
EXEC SQL SELECT ISSUSER_CODE,DEBIT_CREDIT,BIN_ORGANIZASYON INTO :DKKPRBN.ISSUSER_CODE,:DKKPRBN.DEBIT_CREDIT, > >:DKKPRBN.BIN_ORGANIZASYON > >FROM VKKPRBN > >WHERE BIN_NO = :DKKPRBN.BIN_NO; > >IF SQLCODE ^= 0 THEN CALL ERROR_EXIT(ERR_READBIN2); [...]
8225 174 15_Re: BIN Search.10_John Hardy22_john_j_hardy@YAHOO.COM31_Mon, 18 Jun 2001 21:49:02 -0500423_- Please ignore my previous premature and unfinished reply!
I would expect (assuming that your table is keyed on BIN_NO), that you would get far better results from attempting to match on 16 bytes and then working down. Something like (my PL1 may be a bit rusty!):
===================================================================
sqlcode = 100;
do a = 16 by -1 to 2 while sqlcode = 100; [...]
8400 17 42_Fred Harb/DOR/NEBRLN is out of the office.0_21_fharb@DOR.STATE.NE.US31_Tue, 19 Jun 2001 01:01:06 -0500474_us-ascii I will be out of the office starting 06/18/2001 and will not return until 06/25/2001.
I will respond to your message when I return. If you need assistance before I return please contact Lou Anne Daugherty (479-4799).
================================================ 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.
8418 33 28_DB2 Stored procedure probelm8_duam lee16_duam_lee@USA.NET29_Tue, 19 Jun 2001 01:34:34 MDT361_US-ASCII Hi All Masters I could see lot of questions on stored procedure last week. I have a new kind of probelm while genearting and building from Stored procedure Wizard.
The probelm I got is illustrated below. ERP002.ADDRESS - [IBM][CLI Driver][DB2/SUN] SQL4301N Java interpreter startup or communication failed, reason code "1". SQLSTATE=58004. [...]
8452 126 15_Re: BIN Search.31_Cagdas Ucar (Garanti Teknoloji)22_cagdasu@GARANTI.COM.TR31_Tue, 19 Jun 2001 11:09:05 +0300581_- Yes, that is a solution. I wonder if there are any other ways of doing it with one query in an efficient way.
Thanks.
-----Original Message----- From: John Hardy [mailto:john_j_hardy@YAHOO.COM] Sent: Tuesday, June 19, 2001 5:49 AM To: DB2-L@RYCI.COM Subject: Re: BIN Search.
Please ignore my previous premature and unfinished reply!
I would expect (assuming that your table is keyed on BIN_NO), that you would get far better results from attempting to match on 16 bytes and then working down. Something like (my PL1 may be a bit rusty!): [...]
8579 64 22_Re: Nasty access path!14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 19 Jun 2001 09:15:07 +0100657_iso-8859-1 Filling it with garbage worked, but LOCKSIZE ROW won't make a scrap of difference when two applications are contending for a DELETE, locking via a tablespace scan.
Marcus
-----Original Message----- From: Isaac Yassin [mailto:yassini@BEZEQINT.NET] Sent: 18 June 2001 18:30 To: DB2-L@RYCI.COM Subject: Re: Nasty access path!
Hi, Just realized you're on V5 so NPGTHRSH won't work ;-( Using locksize row can help to reduce the locking contention. You can add more "garbage" rows as well. Check that MAXROWS 1 really works and that no one is changing it back. If it doesn't work (bug) you can "enlarge" the rows with [...]
8644 25 15_Re: total space10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 19 Jun 2001 11:54:04 +0200555_us-ascii Hi Derez (and Hi Missy, how are your BPs ? ;-))
Take a look at Platinum's DB, there's a topic 'Figuring free space of tablespace' which may be useful to calculate the space.
http://www.platinum.com/dbtips/tps_os05.htm
HTH
Max Scarpa Useless DB2 sysprog
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
8670 32 11_SUBSYS=DB2?0_19_mike.holmans@BT.COM31_Tue, 19 Jun 2001 11:08:17 +0100432_- OS390 2.8, going to 2.10; DB2 for OS/390 V5, going to V7 next year.
I've just had our WLM guy on the phone. We're in the process of getting ready to go to Goal Mode and he's checking a few things out.
In the current ICS/IPS setup we have, MSTR, DBM1 etc are coded as SUBSYS=STC which makes them started tasks. My cow orker has spotted that within the WLM dialog, there is the opportunity to specify SUBSYS=DB2. [...]
8703 20 15_Re: SUBSYS=DB2?14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Tue, 19 Jun 2001 05:58:38 -0500451_iso-8859-1 Mike,
are you not ashamed to admit that you have your own "cow orker".
I thought they became extinct in the wake of foot-and mouth anyway.
(Sorry..couldn't resist!)
Colin
================================================ 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.
8724 22 40_New DB2 Connect table viewing error -4409_Don Cross20_Don.Cross@TC.FAA.GOV31_Tue, 19 Jun 2001 06:58:51 -0400349_us-ascii Hi all..Thanks for the previous responses..they fixed that problem..somehoh on the install of DB2 no temp spaces were created in DSNDB07. We found the job and ran it.
Now when we connect and try to see data in tables we get SQL error 440 stating
No by the name PROCEDURE having compatible arguments was found. [...]
8747 34 44_Re: New DB2 Connect table viewing error -44013_Schulz Thomas20_thomas.schulz@SVI.DE31_Tue, 19 Jun 2001 13:21:19 +0200564_us-ascii hey Don
Do you have created the Stored Procedure DSNWZP
Thomas
Don Cross schrieb: > > Hi all..Thanks for the previous responses..they fixed that problem..somehoh > on the install of DB2 no temp spaces were created in DSNDB07. We found the > job and ran it. > > Now when we connect and try to see data in tables we get SQL error 440 > stating > > No by the name PROCEDURE having compatible arguments was found. > > and there are 6 possible reasons for failure. But could something else be > missing from the install? > [...]
8782 44 15_Re: SUBSYS=DB2?0_19_mike.holmans@BT.COM31_Tue, 19 Jun 2001 12:17:40 +0100425_- Not really.
USENet history digression:They started orking cows in talk.bizarre many years ago, and Sean Willard introduced the practice to alt.folklore.urban in 1991. It is in no way related to the mythical practice of cow tipping.
Mike Holmans BT ISE Database Services mike.holmans@bt.com
This post represents the views of the author and does not necessarily accurately represent the views of BT [...]
8827 38 38_TOP SECRET and Execution Auth problems10_Mark Frost23_mark.frost@CITICORP.COM31_Tue, 19 Jun 2001 13:08:50 +0100408_ISO-8859-1 Hi.
Anyone experienced the following.
DB2 V6 on OS390 TOP Secret External Security Package. Sample Auth and Connection exits installed on DB2. IBMGROUP "FRED" connected to User BILL. Execute on Stored procedure A granted to FRED
Stored procedure A called from a windows client with BILL logged on, ie remote connection.
DB2 experiences an 00E20005 abend in MSTR ? [...]
8866 125 23_Query Performance-HELP!11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Tue, 19 Jun 2001 15:20:41 +0300884_iso-8859-7 Hello List, i was given the following query to optimize,as it takes about 8 minutes to complete (DB2 for OS/390 V6.1.1). ------------------------------------------- SELECT DISTINCT (A.POL_NO) AS POLNO,A.TRNS_ISS_DT, TBNRI2.NONR AS NON , TBNRI2.PNOM,TBNRI2.NOM1 AS NOM1, TBNRA2.ADR2,TBNRA2.HUNR, TBNRA2.NTEL,TBNRA2.CPOS,TBNRA2.LOCA FROM TBAUPTRN A, TBNRI2, TBAUPCL, TBNRA2 WHERE TBAUPCL.CLN_RLTN = 'Á' AND TBAUPCL.PST_ADDRSS <> ' ' AND TBNRI2.NOM1 like 'Á%' AND A.TRNS_ISS_DT= (SELECT MAX(B.TRNS_ISS_DT) FROM TBAUPTRN B WHERE B.POL_NO = A.POL_NO) AND TBNRI2.NONR = TBAUPCL.CLN_NO AND TBNRI2.NONR = TBNRA2.NONR AND TBNRA2.CMAD=TBAUPCL.PST_ADDRSS AND TBAUPCL.POL_NO = A.POL_NO AND TBAUPCL.RCPT_NO = A.RCPT_NO AND ------------------------------------------------- Unfortunately,the only tool available for query analyzing is .....EXPLAIN,through which i got the following [...]
8992 45 15_Re: SUBSYS=DB2?12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM31_Tue, 19 Jun 2001 07:26:49 -0500
9038 23 21_auto rebind scenarios12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Tue, 19 Jun 2001 09:03:17 -0400552_us-ascii Under DB2 v61, has anyone seen a scenario where an 'ALTER ADD COLUMN' causes auto-rebinds to occur on all plans/packages depending on the altered object
Stan Goodwin IBM Senior I/T Specialist DECC MBG DB2 Support
Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9062 194 15_Re: SUBSYS=DB2?15_Zander, Barb J.19_bzander@STATE.ND.US31_Tue, 19 Jun 2001 08:18:59 -0500682_iso-8859-1 Yes, it will go to the default if its not specifically defined, but from what I remember the default is the lowest priority there is. NOT where you want DB2 to be.
Barb
-----Original Message----- From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] Sent: Tuesday, June 19, 2001 7:27 AM To: DB2-L@RYCI.COM Subject: Re: SUBSYS=DB2?
Mike:
We are just going through the same process now and what I would suggest to you is to take a look at the Cheryl Watson Quickstart service policy at www.watsonwalker.com . We've been following step by step in looks pretty easy. Regarding your question if you or [...]
9257 40 25_Re: auto rebind scenarios13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 19 Jun 2001 08:25:32 -0500297_US-ASCII Hello Stan, If you ALTER ADD a date, time, timestamp column with not null with default DSNXIATB forces plans/packages to be invalidated because DB2 does not know what value to use for the existing rows. The dependent plans and packages need to be flushed from the EDM pool. HTH Kurt [...]
9298 66 37_Re: Whats wrong with this procedure ?11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Tue, 19 Jun 2001 15:28:10 +0200661_us-ascii Hi Abhijit,
the problem is, that the ';' characters are recognized as statement terminator character (that is, only the text before that is passed to the CLP to execute) in the "Interactive" tab.
Since the Command Center calls the CLP (either db2 or db2 -f ) it behaves in the same way as if you used the CLP. For scripts, the default statement terminator is the new-line, which can be overridden with the -t option of the CLP: -t : ';' is the termination character -tdx : 'x' is the termination character (each statement must begin on [...]
9365 21 25_Re: auto rebind scenarios15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 19 Jun 2001 08:53:50 -0500414_- Kurt
I think existing rows will get '01.01.0001' for date-columns '00:00:00 for time-columns and timestamp similar.
>If you ALTER ADD a date, time, timestamp column with not null with default >DSNXIATB forces plans/packages to be invalidated because >DB2 does not know what value to use for the existing rows. The >dependent plans and packages need to be flushed from the EDM pool. >HTH >Kurt [...]
9387 17 35_IBM 9672's and hardware compression10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 19 Jun 2001 09:08:15 -0500444_- Dear List,
Does anybody know if an IBM 9672-R36 (a G5 processor) comes with hardware data compression as standard? Does one need to do anything to activate it?
Regards,
Steve Lamb
================================================ 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.
9405 116 27_Re: Query Performance-HELP!13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 19 Jun 2001 09:15:14 -0500733_iso-8859-1 Do you have an index on.TRNS_ISS_DT descending on TBAUPTRN to support a direct read of the subquery?
Helen Johnson
Dimoka Popy wrote:
> Hello List, > i was given the following query to optimize,as it takes about 8 > minutes to complete (DB2 for OS/390 V6.1.1). > ------------------------------------------- > SELECT DISTINCT (A.POL_NO) AS POLNO,A.TRNS_ISS_DT, > TBNRI2.NONR AS NON , TBNRI2.PNOM,TBNRI2.NOM1 AS NOM1, > TBNRA2.ADR2,TBNRA2.HUNR, > TBNRA2.NTEL,TBNRA2.CPOS,TBNRA2.LOCA > FROM TBAUPTRN A, TBNRI2, TBAUPCL, TBNRA2 > WHERE > TBAUPCL.CLN_RLTN = 'Á' AND TBAUPCL.PST_ADDRSS <> ' ' > AND TBNRI2.NOM1 like 'Á%' AND > A.TRNS_ISS_DT= (SELECT MAX(B.TRNS_ISS_DT) FROM TBAUPTRN B > WHERE B.POL_NO [...]
9522 53 23_Stogroup Order Question15_Gary Fahrlander28_gary.fahrlander@ZURICHNA.COM31_Tue, 19 Jun 2001 09:15:11 -0500411_us-ascii We are attempting to put all of our test volumes on all of our DB2 test stogroups. Currently, we have volumes named UDT001 to UDT046. Our thought was to alter the stogroups such that the tablespace stogroups have the list of volumes from UDT001 to UDT046 and our indexspace stogroups have the list of volumes from UDT046 to UDT001. Our first alter we generated for an indexspace looked like this: [...]
9576 13 27_Re: Stogroup Order Question15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 19 Jun 2001 09:29:33 -0500396_- Gary
If I remember it right (we are using SMS for all our DB2-data), you cannot recognize the order of the volumes by looking at the DB2-catalog.
================================================ 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.
9590 20 39_Re: IBM 9672's and hardware compression10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 19 Jun 2001 16:29:56 +0200474_us-ascii All 9672s have hardware compression. As far as I was told you need an APAR to DEACTIVATE it....
Some years ago BMC utilities (when executed) detected if hardware compression was present.
HTH Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9611 196 15_Re: SUBSYS=DB2?14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Tue, 19 Jun 2001 10:26:58 -0400569_iso-8859-1 Mike,
SUBSYS=STC and SUBSYS=DB2 are no different right out of the box. It's how you set them up that makes them different. SUBSYS=DB2 allows you to set your DB2 apart from other started tasks. IRLM needs to dispatch very high, and you want MSTR and DBM1 to dispatch higher than most of your other started tasks. We had a workload defined specifically for IRLM for which the service class had an execution velocity of 99 because our CPU was always up high (we found this out during a benchmark -- execution velocity is the best way to set this up [...]
9808 59 15_Re: SUBSYS=DB2?21_Powers, Carol A - CNF20_Powers.Carol@CNF.COM31_Tue, 19 Jun 2001 07:30:27 -0700631_- SUBSYS=DB2 in WLM is only used for some types of parallel query work (cpu parallelism, and, if I recall, parts of the query distributed to more than one OS/390 server). The basic address spaces are still classified under SUBSYS=STC. Make sure your IRLM address spaces are classified into SYSSTC and assign DBM1 and MSTR to a service class with a relatively high velocity. (These are pretty standard recommendations). You'll want manual GC28-1761, MVS Planning: Workload Management which explains all the terminology. You might also want to look at red book SG24-4693, Getting Started with DB2 Stored Procedures. It has some [...]
9868 113 39_Re: IBM 9672's and hardware compression14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Tue, 19 Jun 2001 10:31:50 -0400397_iso-8859-1 Steve,
My IBM hardware buddy says that it is a standard and you don't have to do anything to turn it on. It's also much faster than software compression.
Jean E. Crichton Logicon
-----Original Message----- From: Steve Lamb [mailto:steve.lamb@POWERGEN.CO.UK] Sent: Tuesday, June 19, 2001 10:08 AM To: DB2-L@RYCI.COM Subject: IBM 9672's and hardware compression [...]
9982 164 39_Re: IBM 9672's and hardware compression0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 19 Jun 2001 09:39:40 -0500411_iso-8859-1 I copied the following tips from Greg Sawyer on how to check for yourself to see if you have hardware &/or software compression available:
Below are steps to run to determine if CPU has hardware &/or software compression enabled. · exit from ISPF to the Ready prompt · Type in the 'test' keyword and the file to execute, it returns to "TEST" prompt, ie: test 'sys1.linklib(iefbr14)' TEST [...]
10147 78 27_Re: Stogroup Order Question11_Robert Jans26_robert_jans@ALBERTSONS.COM31_Tue, 19 Jun 2001 07:40:38 -0700338_iso-8859-1 well since SYSVOLUMES contains 1 row per volid, there's multiple rows. Unless you use an order by, there is no guarantee that DB2 will retrieve the rows in any particular order. That means, in theory, you could get different results running the query twice.......
You need to have the order by clause on your query [...]
10226 30 27_Re: Stogroup Order Question13_Hanne Lyssand10_han@VPS.NO31_Tue, 19 Jun 2001 16:44:48 +0200467_us-ascii Seems strange. Have you checked SYSIBM.SYSVOLUMES or are you using any other product to take out this list?
Best regards Hanne
********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. [...]
10257 74 14_PSQL Questions12_Collier, Mel21_MCollier@TXFB-INS.COM31_Tue, 19 Jun 2001 09:54:25 -0500305_iso-8859-1 What version of UDB both on the Mainframe and NT Server must you be at to take advantage of PSQL?
Does anyone have any good or bad experiences with PSQL?
Thanks, Mel S. Collier DBA mcollier@txfb-ins.com Southern Farm Bureau Insurance Companies www.txfb-ins.com Waco, Texas
10332 79 27_Re: Stogroup Order Question12_Boone, Henry16_HBoone@GEICO.COM31_Tue, 19 Jun 2001 10:57:35 -0400468_iso-8859-1 I imagine you simply queried SYSIBM.SYSVOLUMES to retrieve this information. I remember reading in one Craig Mullins's DB2 Developer's Guides that you have to be careful with this. I believe he suggested that you should keep track of the order the volumes were specified yourself. In my experiences, DB2 has always used the volumes in the order I specified which may or may not be different that the order presented to me in a query against the table. [...]
10412 16 27_Re: Stogroup Order Question10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 19 Jun 2001 17:09:56 +0200349_us-ascii But are you using SMS ? If yes yhy don't u use '*' (asterisk) ???
Regards
Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10429 217 27_Re: Stogroup Order Question14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Tue, 19 Jun 2001 08:40:42 -0700593_iso-8859-1 The only way to determine the order that DB2 will use volumes defined in a stogroup is by running the pointer chain from the SYSSTOGROUP row, to the first SYSVOLUMES row, to the next SYSVOLUMES row, and so on. The last row in SYSVOLUMES will point back to the SYSSTORGROUP row. See the Catalog Table format section in the DB2 Diagnosis Guide and Ref (section 7.5 in the V6 manual). An select with an order by won't help, since the volume sequence number isn't stored as a column in sysvolumes. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All [...]
10647 193 39_Re: IBM 9672's and hardware compression15_Robert lawrence21_rlawrence@BOSCOVS.COM31_Tue, 19 Jun 2001 11:41:28 -0400469_iso-8859-1 Here is another way to tell what compression is available
/* rexx */ cvt = storage(10,4) cmpflag = x2b(c2x(storage(d2x(c2d(cvt) + x2d(0179)),1))) cvtcmpsc = translate(substr(cmpflag,1,1),'YN','10') cvtcmpsh = translate(substr(cmpflag,2,1),'YN','10') say 'software compression supported <' cvtcmpsc '>' say 'hardware compression supported <' cvtcmpsh '>' return
save this in a a dataset in your sysproc concatenation and execute it [...]
10841 57 38_Re: Stogroup Order Question - addendum15_Gary Fahrlander28_gary.fahrlander@ZURICHNA.COM31_Tue, 19 Jun 2001 10:39:01 -0500493_us-ascii Should've added that we're not SMS managed on the original question. We're managing our own Stogroups through DB2. I wish sysibm.sysvolumes had a timestamp.
Max Scarpa @RYCI.COM> on 06/19/2001 10:09: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: Stogroup Order Question [...]
10899 30 41_Quest Software Free DB2 Technical Seminar13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Tue, 19 Jun 2001 10:36:00 -0500597_- Please join Quest Software for a free half-day DB2 technical seminar coming to your area. The seminar focuses on comparing DB2 on the mainframe to DB2 running on Unix/NT. The presentation is geared towards individuals who support or anticipate supporting DB2 running on multiple platforms. The information presented will also be very helpful for non-DB2 shops that are considering the introduction of DB2 into their environment and would like to learn more about the requirements for managing this new technology. This technical seminar is appropriate for developers, DBAs and IT managers. [...]
10930 21 50_GEN DDL using V7.1.2 UDB Client and V6.1 DB Server13_Joel Pankonin26_joel.pankonin@ZURICHNA.COM31_Tue, 19 Jun 2001 10:46:35 -0500370_us-ascii We recently went to UDB V7.1.2 on our client while still running V6.1 on the DB server. When trying to GEN DDL we nothing but the following.
(Embedded image moved to file: pic22483.pcx)
(Embedded image moved to file: pic06617.pcx)
I would expect to get what I requested, but didn't.
(Embedded image moved to file: pic22813.pcx) [...]
10952 34 22_Another Oracle barrage0_26_Steve.Westfall@EQUIFAX.COM31_Tue, 19 Jun 2001 11:21:44 -0500520_us-ascii Oracle has put another barrage directed at DB2 on its web site:
The first: "IBM DB2 Just Starting to Crawl as the Oracle9i Database Achieves World Records. Oracle is at least two generations ahead." is at http://www.oracle.com/features/9i/index.html?generations.html
The second: "IBM: Yesterday's Innovator, Today's Dinosaur" is at http://www.oracle.com/features/insider/index.html?oi_bonvanie_02.html
I will leave it to those more familiar with both products to address their claims. [...]
10987 94 55_Re: WinNT, Win2000 Utilities Scheduling - backup, reorg8_Kim Lyon23_klyon@MSI-INSURANCE.COM31_Tue, 19 Jun 2001 11:20:29 -0500432_us-ascii We are using this EZ Scheduler software - very simple to use and it's free! ----- Forwarded by Kim Lyon/MSI-CORP/MSI-INC on 06/19/2001 11:23 AM -----
Robert Litke To: Kim Lyon/MSI-CORP/MSI-INC@MSI-INC 06/19/2001 cc: 09:57 AM Subject: Re: WinNT, Win2000 Utilities Scheduling - backup, reorg (Document link: Kim Lyon)
EZ Scheduler
(See attached file: EZ scheduler setup.exe) [...]
11082 159 27_Re: Stogroup Order Question11_Mark Turner29_mark.turner@UCDMC.UCDAVIS.EDU31_Tue, 19 Jun 2001 09:37:04 -0700355_us-ascii Does DB2 construct a list of eligible volumes from the Stogroup and pass the eligible list to OS/390 SRM (System Resource Manager) and DADSM (Direct Access Device Storage Manager) to pick a specific volume based on space, device busy, and open dataset activity?
Or does DB2 skip SRM and allocate directly to a volume in the Stogroup? [...]
11242 44 50_GEN DDL using V7.1.2 UDB Client and V6.1 DB Server13_Joel Pankonin26_joel.pankonin@ZURICHNA.COM31_Tue, 19 Jun 2001 11:52:05 -0500402_us-ascii Okay.... let's try this again,
Right now we support multipal version of UDB on several platforms. We recently went to UDB V7.1.2 on our client while still running V6.1 on the UNIX/DB server. When trying to GEN DDL we get nothing but the following:
command executed:
echo db2look: /db2/usuasb02/sqllib/db2_19.out
db2look -d DVSCE200 -u EVSC -e -c -o db2_19.out [...]
11287 42 27_Re: Stogroup Order Question12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 19 Jun 2001 19:54:48 +0200340_iso-8859-1 Hi, It uses the internal list. I've encountered case (when NOT using SMS) that you have few disks on the stogroup, DB2 needs to extend a file (TS / IX) and searches for enough space, if it does not find enough space on the first 3 disks on the chain it issues extend failure even if there is enough space on the 4th volume. [...]
11330 29 71_Stored procedure builder, result set column name is getting trunc ated.15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 19 Jun 2001 13:01:23 -0400394_iso-8859-1 I just started using Stored procedure builder to execute a COBOL procedure in OS/390 V2.9 DB2 V6.1. In the result set the column heading is getting truncated like
VEHICL I D ------ - -
this should be
VEHICLE_K IB_OB_IND_K DOWNLOAD_TYPE_K --------- ----------- ---------------
In my environment properties, all the check box in output tab is checked. [...]
11360 73 47_Re: GEN DDL using V7.1.2 UDB Client and V6.1 DB17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Tue, 19 Jun 2001 12:25:26 -0500475_us-ascii Yes, I have tried the exact same thing and got the same results. We are running 7.1 UDB on NT and 6.1 clients. I have run db2look from the CLI, and tried to generate DDL from control center, both on the server and on the client, and got the same results. Basically I got nothing. I finally remembered that I could create the table and populate it at the same time using the create function within and Import. I never did get db2look to work correctly with 7.1. [...]
11434 208 39_Re: IBM 9672's and hardware compression12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Tue, 19 Jun 2001 13:37:08 -0400357_iso-8859-1 Well, I'll be...!
Thanks for dredging this up and reminding me that I can indeed forget more than I ever knew; must have had more time on my hands in those days, too.
I can't take credit for the solution, however - I just supplied the detailed explanation of the interpretation; a certain Jim Lewandowski was the real culprit. [...]
11643 93 15_Re: SUBSYS=DB2?14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Tue, 19 Jun 2001 14:15:15 -0400597_iso-8859-1 Sorry for the incorrect information in my previous email about the SUBSYS=STC and the SUBSYS=DB2 parameter being the same. The WLM manual states that the SUBSYS=DB2 parameter is used if you plan to use enclaves in a sysplex environment. I was doing a postmortem with the OS390 sysprog I worked with to set up DB2 in WLM on how we set things up and replied before we had really finished thinking it through. Anyway, when we went to goal mode several years ago, our production environment was already sysplex, data sharing, and we wanted parallelism, so we never considered anything [...]
11737 24 14_DB2 V6 Install14_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 19 Jun 2001 14:24:15 -0400528_iso-8859-1 Hi, Is JDB6619 (math function) a *required* FMID ? I see it in member DSNTIJAP and it is not makered optional. Please advise. Thanks Dean
Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax
dmonteva@vnsny.org
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11762 49 15_Re: SUBSYS=DB2?21_Powers, Carol A - CNF20_Powers.Carol@CNF.COM31_Tue, 19 Jun 2001 11:47:09 -0700347_- For IRLM you want to set the service class to SYSSTC which is an IBM provided class that keeps the dispatching priority at X'FE', just below service class SYSTEM at X'FF'. Starting with OS/390 2.6 (I think) WLM you can assign SYSSTC directly in your classification rules. It definitely works at the OS/390 2.10 level which is where we are. [...]
11812 201 15_Re: SUBSYS=DB2?14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Tue, 19 Jun 2001 15:19:15 -0400454_iso-8859-1 From all the responses I have seen so far, it looks like a lot has changed since we went to goal mode at OS390 1.3. We had to set the velocity of IRLM to 99 in the service class because we couldn't assign SYSSTC then. Maybe I'm not crazy after all, just out of date! Sounds like Carol is the WLM heavy here -- thanks for the great information -- I am passing this on to some other sysprogs I know so they can re-evaluate the environment. [...]
12014 56 54_Re: GEN DDL using V7.1.2 UDB Client and V6.1 DB Server11_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Tue, 19 Jun 2001 20:44:39 +0100359_us-ascii Joel,
I have seen this. If it is the same thing, it was intorduced as a bug fix in version 6.
The -u flag is for the creator of the table - which is a pain if you are looking for all tables belonging to a particluar schema. In version 5.2 it fetched all tables belonging to a schema. I believe that there is an APAR open about it. [...]
12071 65 32_Re: UDB DB2 Archiving of the Log11_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Tue, 19 Jun 2001 20:47:09 +0100373_us-ascii Daniel / Bill,
Just to be different, we actually use a TCL/TK script. It has about 200 lines of code, which is a fraction of the C version.
I did recently see a Korn script which was even shorter, although it didn't do all we require. I believe the C version is a good starting point, but when you want to change it I recommend a simple script. [...]
12137 85 32_Re: Freeing Agent Private Memory11_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Tue, 19 Jun 2001 20:50:04 +0100367_us-ascii John / Phil,
Whilst I agree with what Phil is saying, a word of warning about not having pool agents. If you need to create agents, this will take up CPU. If you need to start a large number of agents at the same time, your run queue will increase significantly. This will make your system freeze for a moment. Another of lifes great trade offs. [...]
12223 59 75_Re: Stored procedure builder, result set column name is getting trunc ated.12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Tue, 19 Jun 2001 16:02:16 -0400418_us-ascii Standard practice - the column names/labels are truncated to the size of the data output; the full names are available in the meta-data however (although any qualifying table name is not passsed in the meta-data - i.e. TABLEA.VEHICLE_K is passed as merely VEHICLE_K).
Gregg Sawyer
"Philip, Sibimon" @RYCI.COM> on 06/19/2001 01:01:23 PM [...]
12283 77 44_DB2 Connect v7 Powerbuilder foreign key info15_Zander, Barb J.19_bzander@STATE.ND.US31_Tue, 19 Jun 2001 15:21:52 -0500387_iso-8859-1 In the PowerBuilder's database painter, we can no longer see any of the foreign key information. Also, in the datawindow painter, there is no automatic join shown when trying to create a datawindow that access 2 or more related tables. This worked fine in v5 of DB2 Connect.
Barbara Zander State of North Dakota 600 East Boulevard Dept 112 Bismarck, ND 58505-0100 [...]
12361 23 32_Re: Freeing Agent Private Memory4_J. A18_csc266@HOTMAIL.COM31_Tue, 19 Jun 2001 15:16:43 -0500311_- Thanks for your responses.
Can someone explain the design here ?
If e.g. 10 users in a 1000-user shop log into an application and each run a query where 100 Mb of private agent memory is used to service this query, then 1 Gb of RAM is locked up until these 10 users leave the application ? [...]
12385 16 32_Re: Freeing Agent Private Memory4_John18_csc266@HOTMAIL.COM31_Tue, 19 Jun 2001 15:20:37 -0500374_- I've turned on DB2MEMDISCLAIM and also set DB2MEMMAXFREE - neither made any difference in my case.
Apparently, a per-user footprint of 2-5 Mb for inactive connected users is not unusual. In Sybase, the per user footprint used to be in the few Kb. Is there any way to reduce the memory footprint of a connection that is simply logged in and not doing anything. [...]
12402 85 37_Re: Whats wrong with this procedure ?14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Tue, 19 Jun 2001 18:29:45 -0400525_iso-8859-1 Bela,
Thank you for your response. I am able to create the procedure now.
Abhijit
-----Original Message----- From: Hamar, Bela [mailto:Bela.Hamar@VARETIS.COM] Sent: Tuesday, June 19, 2001 9:28 AM To: DB2-L@RYCI.COM Subject: Re: Whats wrong with this procedure ?
Hi Abhijit,
the problem is, that the ';' characters are recognized as statement terminator character (that is, only the text before that is passed to the CLP to execute) in the "Interactive" tab. [...]
12488 49 32_Re: DB2 Stored procedure probelm14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Tue, 19 Jun 2001 18:31:47 -0400534_iso-8859-1 Hi Lee,
Go this message a few times. Just issue "db2stop force" and "db2start" from a db2 command window. That usually solves this problem.
Abhijit
-----Original Message----- From: duam lee [mailto:duam_lee@USA.NET] Sent: Tuesday, June 19, 2001 3:35 AM To: DB2-L@RYCI.COM Subject: DB2 Stored procedure probelm
Hi All Masters I could see lot of questions on stored procedure last week. I have a new kind of probelm while genearting and building from Stored procedure Wizard. [...]
12538 74 38_DB2 V7 Uility template with tape STACK0_26_Chris.Virnig@COURTS.WA.GOV31_Tue, 19 Jun 2001 15:53:05 -0700731_iso-8859-1 We're just beginning to investigate new Version 7 features. I'm trying to set up an image copy for tablespaces in a database using the TEMPLATE and LISTDEF statements. I'm trying to stack the copies onto tape. When I specify STACK YES I get an allocation error:
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = ICOPY7 DSNU050I DSNUGUTC - LISTDEF SFTJQRY INCLUDE TABLESPACE SDBJQRY.* EXCLUDE TABLESPACE SDBJQRY.JTSRFR EXCLUDE TABLESPACE SDBJQRY.JTSJUV DSNU1035I DSNUILDR - LISTDEF STATEMENT PROCESSED SUCCESSFULLY DSNU050I DSNUGUTC - TEMPLATE TAPEDDN DSN(DB2T.D&DATE..T&TIME..&TS.) UNIT CART STACK YES DSNU1035I DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY DSNU050I DSNUGUTC - COPY LIST SFTJQRY [...]
12613 130 15_Re: SUBSYS=DB2?17_Walter Trovijo Jr22_wtrovijo@COELBA.COM.BR31_Tue, 19 Jun 2001 19:59:19 -0300737_iso-8859-1 And don´t forget that enclaves will happen only from distributed transactions. CICS (up to TS 1.3) does not support enclaves.
Walter Trovijo Jr
"Crichton, Jean" Enviado Por: DB2 Data Base Discussion List 19/06/2001 15:15 Responder a DB2 Data Base Discussion List
Para: DB2-L@RYCI.COM cc: Assunto: Re: SUBSYS=DB2?
Sorry for the incorrect information in my previous email about the SUBSYS=STC and the SUBSYS=DB2 parameter being the same. The WLM manual states that the SUBSYS=DB2 parameter is used if you plan to use enclaves in a sysplex environment. I was doing a postmortem with the OS390 sysprog I worked with [...]
12744 126 32_Re: Freeing Agent Private Memory14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Tue, 19 Jun 2001 17:25:51 -0700571_iso-8859-1 John, Check all the values for configuration parameters for global and agent private memory. If you can reduce these, do so. This is a way to reduce memory usage, short of terminating the application. Check the agent pool size and maxagents and make sure they are appropriate. Now, you could use the governor to check on applications that have been idle for a certain amount of time and have the governor terminate them if the value is reached. However, this does not seem to be an option for you. Also, since the amount of memory being used per agent is [...]
12871 37 39_Re: IBM 9672's and hardware compression15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 20 Jun 2001 10:55:00 +1000645_- Still do. Notice it occasionally on LoadPlus jobs.
Raymond
> -----Original Message----- > From: Max Scarpa [SMTP:mscarpa@CESVE.IT] > Sent: Wednesday, 20 June 2001 12:30 am > To: DB2-L@RYCI.COM > Subject: Re: IBM 9672's and hardware compression > > All 9672s have hardware compression. As far as I was told you need an > APAR > to DEACTIVATE it.... > > Some years ago BMC utilities (when executed) detected if hardware > compression was present. > > > HTH > Max Scarpa > > ================================================ > To change your subscription options or to cancel your subscription visit > the DB2-L webpage [...]
12909 77 76_Re: Stored procedure builder, result set column name is getting t runc ated.15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 19 Jun 2001 20:58:09 -0400397_- Thanks. Where can I see this meta data. Also can I overide this standard practice with some setting in SPB. I really like to see the full column name.
-----Original Message----- From: Gregg Sawyer [mailto:gregg.a.sawyer@VERIZON.COM] Sent: Tuesday, June 19, 2001 03:02 PM To: DB2-L@RYCI.COM Subject: Re: Stored procedure builder, result set column name is getting trunc ated. [...]
12987 174 15_Re: BIN Search.14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 19 Jun 2001 21:36:58 -0500337_- My guess is that the structure of the CASE expression is forcing a tablespace scan - even if there's an index on BIN_NO. John's suggestion is proably the most efficient; if you want a single SQL statement you will have to live with some in-efficiencies. What about this:
DCL 1 HV_BIN_LO CHAR(16); DCL 1 HV_BIN_HI CHAR(16); [...]
13162 180 15_Re: BIN Search.14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 19 Jun 2001 21:36:58 -0500346_iso-8859-1 My guess is that the structure of the CASE expression is forcing a tablespace scan - even if there's an index on BIN_NO. John's suggestion is proably the most efficient; if you want a single SQL statement you will have to live with some in-efficiencies. What about this:
DCL 1 HV_BIN_LO CHAR(16); DCL 1 HV_BIN_HI CHAR(16); [...]
13343 64 4_Cows15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 20 Jun 2001 13:10:15 +1000654_- Eh? I'm guessing 'cow tipping' is the practice - as immortalised by Beavis and Butthead - of pushing over cows while they're asleep standing up. But orking? C'mon, Mike; spill the beans. What's it all about?
Mystified of (currently) Melbourne
> -----Original Message----- > From: mike.holmans@BT.COM [SMTP:mike.holmans@BT.COM] > Sent: Tuesday, 19 June 2001 9:18 pm > To: DB2-L@RYCI.COM > Subject: Re: SUBSYS=DB2? > > Not really. > > USENet history digression:They started orking cows in talk.bizarre many > years ago, and Sean Willard introduced the practice to alt.folklore.urban > in > 1991. It is in no way related to the [...]
13408 51 26_Re: Another Oracle barrage10_John Hardy22_john_j_hardy@YAHOO.COM31_Tue, 19 Jun 2001 23:29:50 -0500509_- Just one of many maggots drawn from the piece of ordure named "IBM: Yesterday's Innovator, Today's Dinosaur":
"Problems that DB2 introduces into your business solution include escalating row-level locking that dramatically slows database performance under heavy loads...."
Perhaps Mr. Bonvanie (who laid the aforementioned article), or some other "Oracle Expert" who knows anything about DB2 (and has their nose in this discussion list), would care to justify and explain this statement. [...]
13460 31 39_AW: IBM 9672's and hardware compression12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 20 Jun 2001 08:32:55 +0200930_iso-8859-1 Hi Steve,
hardware compression is standard if you're running a IBM 9672-R36 big iron.
With kind regards - mit freundlichen Grüssen, Georg H. Peter DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- Linux is like a wigwam: no gates, no windows, and an apache inside..... ===============================================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.
13492 198 27_Re: Query Performance-HELP!11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Wed, 20 Jun 2001 09:44:01 +0300621_iso-8859-7 Hi Helen, yes ,index IXAUPTRN2 (POL_NO ,TRNS_ISS_DT ) is defined with a descending order of TRNS_ISS_DT .That's why the subquery is carried out by a one-fetch index scan ( I1 -see last step of the explain output ).
TIA,
Popy A. Dimoka
> ---------- > From: Helen Johnson[SMTP:helen_johnson@RAC.RAY.COM] > Reply To: DB2 Data Base Discussion List > Sent: Ôñßôç, 19 Éïõíßïõ 2001 4:15 ìì > To: DB2-L@RYCI.COM > Subject: Re: Query Performance-HELP! > > Do you have an index on.TRNS_ISS_DT descending on TBAUPTRN to support a > direct read of the subquery? > > Helen Johnson > > Dimoka Popy [...]
13691 121 15_Re: BIN Search.31_Cagdas Ucar (Garanti Teknoloji)22_cagdasu@GARANTI.COM.TR31_Wed, 20 Jun 2001 10:37:19 +0300513_iso-8859-9 Yes, I think you're right. Thank you.
-----Original Message----- From: James Campbell [mailto:jacampbell@ACSLINK.NET.AU] Sent: Wednesday, June 20, 2001 5:37 AM To: DB2-L@RYCI.COM Subject: Re: BIN Search.
My guess is that the structure of the CASE expression is forcing a tablespace scan - even if there's an index on BIN_NO. John's suggestion is proably the most efficient; if you want a single SQL statement you will have to live with some in-efficiencies. What about this: [...]
13813 42 24_Re: ACCESS PATH QUESTION14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 20 Jun 2001 03:02:14 -0500424_- I have just noticed that IBM is still recommending "or 0=1" in V7. ( http://publibz.boulder.ibm.com/cgi- bin/bookmgr_OS390/BOOKS/DSNAGH10/5.8.4.2 )
Does anyone know if this is because - the optimizer enhancements that were supposed to circumvent the index disablement have not been implemented. That is, the optimizer will still disable index selection if it sees "or 0=1"; or - the V7 manual was not updated? [...]
13856 32 50_Re: Another Oracle barrage - dandruff strikes back10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 20 Jun 2001 11:08:48 +0200351_us-ascii I read the articles. I think that Mr Bonvanie says some right things and a lot of wrong things.
For instance I'd to suggest to Mr Bonvanie to think about the disk used by ORACLE AND why ORACLE didn't detected
I/O error, for instance, so we had to recover a big DB after many days. AND this is not due to dandruff sniffing. [...]
13889 18 14_Sample Scripts18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 20 Jun 2001 07:05:12 -0400538_iso-8859-1 Does anyone know of a website (IBM's) where I can get a copy of the sample scripts printed in the back of the UDB V7.1 Performance tuning guide?
Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2 (860) 273-0301
================================================ 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.
13908 42 28_Size of DBSPACE, DB2 for vse34_Filip Ruhdensj=?ISO-8859-1?Q?=F6?=25_filip.ruhdensjo@PULSEN.SE31_Wed, 20 Jun 2001 06:16:10 -0500277_ISO-8859-1 Hi everyone,
We are using DB2 for VSE 7.1.
I have a question about the size of dbspaces. I know how I calculate the size of a dbspace but what I wonder is, if I have a dbspace with 5 000 000 active page can I reorg the dbspace in reasonable time? [...]
13951 31 41_Union all conversion into full outer join18_Blumer Hans-Ulrich32_Hans-Ulrich.Blumer@WINTERTHUR.CH31_Wed, 20 Jun 2001 13:44:31 +0200592_iso-8859-1 Is it possible to convert an union all into a full outer join and if yes is it worthwile to do it from a performance view? The best would be to give a simpe example. Thanks a lot!
regards Hans ---------------------------------------------- Hans-Ulrich Blumer Informatik Schweiz Software Entwickler-Support Mailto:Hansueli.Blumer@winterthur.ch Tel +41 52 26124 16 Fax +41 52 261 83 70 ---------------------------------------------- Winterthur Versicherungen Konradstrasse 14 CH-8401 Winterthur http://www.winterthur.com/ch ---------------------------------------------- [...]
13983 16 39_Re: IBM 9672's and hardware compression10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Wed, 20 Jun 2001 06:43:21 -0500357_- Well, that's given me a couple of ways of working out whether hardware compression is turned on or not!
What happens when you have BOTH the hardware and software settings set, as in the results from the TEST test? Presumably the hardware feature overrides the software part, or do they both need to be on for the hardware compression to work? [...]
14000 55 45_Re: Union all conversion into full outer join16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 20 Jun 2001 17:43:50 +0530366_- Hi Hans,
YES, UNION ALL can be converted into a full outer join. As far as performance point of view is concerned, i would say "It depends". It depends on what is the access path of UNION ALL at present. Due to the recent enhancements of outer joins, you can get it better but still i feel, its better to try out both and compare the performance data. [...]
14056 73 45_Re: Union all conversion into full outer join16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 20 Jun 2001 17:48:23 +0530392_- Forgot to give the "best" i.e. the example.....
SELECT C1, C2,C3 FROM T1 WHERE C4 = ? AND C5 = ? UNION ALL SELECT C1', C2', C3' FORM T2 WHERE C4' = ? AND C5 ' = ?
converted to FOJ
SELECT VALUE(C1,C1') as C-1, VALUE(C2,C2') as C-2,VALUE(C3,C3') as C-3 FROM T1 FULL OUTER JOIN T2 ON C1 = C1' AND C2 = C2' AND C3 = C3' WHERE C4 = ? AND C5 = ? AND C4' = ? AND C5' = ? [...]
14130 109 50_GEN DDL using V7.1.2 UDB Client and V6.1 DB Server0_22_BILL_GALLAGHER@PHL.COM31_Wed, 20 Jun 2001 08:13:18 -0400557_us-ascii The APAR is IY13655. IBM has added a new option, -z, which provides the same functionality that the -u option used to provide before they "fixed" it.
Some background: according to IBM, the -u option's behavior did not match the documentation of how it was supposed to work. APAR IY11255 was included in a v6.1 fixpack (4c) which "corrected" this "problem", and caused -u to not work the way it used to. I opened a PMR with IBM complaining about this, and made a case for needing it to work the old way. They agreed to add a new option, [...]
14240 61 25_use of union in subselect15_Chris Van Daele33_Chris.Van.Daele@TOYOTA-EUROPE.COM31_Wed, 20 Jun 2001 14:29:24 +0200338_us-ascii Hi,
I have a query that gives me a list of numbers, except for the zero number that I also need in addition
the query looked at first like :
SELECT * FROM DWHD.WPDCNLIN WHERE LUP IN (SELECT LUP FROM DWHD.TEDMARTL WHERE TABLE_NAME_DW = 'WPDCNLIN' AND TABLE_NAME_DM = 'MPFDCNOT' AND STATUS = 'L') [...]
14302 98 29_Re: use of union in subselect12_Troy Coleman19_Colematr@MEIJER.COM31_Wed, 20 Jun 2001 09:00:43 -0400453_US-ASCII Hi Chris, You need to use the "IN" clause.
SELECT * FROM DWHD.WPDCNLIN WHERE LUP IN ( SELECT LUP FROM DWHD.TEDMARTL WHERE TABLE_NAME_DW = 'WPDCNLIN' AND TABLE_NAME_DM = 'MPFDCNOT' AND STATUS IN( 'L','0') )
Troy Coleman Coleman Consulting, Inc.
IBM Certified Solutions Expert DB2 V7.1 Database Administration for OS/390 DB2 UDB V5 Database Administration IBM Certified Advanced Technical Expert DB2 -DRDA [...]
14401 85 29_Re: use of union in subselect11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Wed, 20 Jun 2001 20:02:24 +0700575_- Chris,
I think you can use th 'IN' clause instead of '=' I haven't tried it, but perhaps your SQL should look like this :
SELECT * FROM DWHD.WPDCNLIN WHERE LUP IN ( SELECT LUP FROM DWHD.TEDMARTL WHERE TABLE_NAME_DW = 'WPDCNLIN' AND TABLE_NAME_DM = 'MPFDCNOT' AND STATUS IN ('L',0) )
H.T.H
>Hi, > > >I have a query that gives me a list of numbers, except for the zero number that >I also need in addition > >the query looked at first like : > >SELECT * FROM DWHD.WPDCNLIN >WHERE LUP IN > (SELECT LUP FROM DWHD.TEDMARTL > WHERE TABLE_NAME_DW [...]
14487 24 35_Joins between Remote & Local tables10_Chris Kern23_Chris_Kern@VANGUARD.COM31_Wed, 20 Jun 2001 09:03:10 -0400517_us-ascii Hi List, There is a restriction between joining local and remote tables (aliases). Is there anyway around this or do I need to deal with it?
Ex. Select COLA from REMOTE.ALIAS where COLA in ( Select COLB from LOCAL.TABLE);
TIA
kdg
================================================ 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.
14512 90 29_Re: use of union in subselect16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 20 Jun 2001 18:38:22 +0530395_- I think i could not understand what you are trying to achieve. If it is STATUS should be 'L' or '0', you need to do STATUS IN('L','0'). I am sure you are aware of this.
I am not sure but it seems, for using UNION in subquery, i think you need to have V7. I am telling this because of the reason VIEW is allowed to have UNION with V7, hence i think subquery should also be allowed. [...]
14603 84 8_Re: Cows11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Wed, 20 Jun 2001 08:11:12 -0500325_iso-8859-1 I don't know if this was where it originated, but I first heard of cow-orkers from a Dilbert newsletter (a newsletter sent by Scott Adadms, creator of the Dilbert cartoon). I think it was in a contest about names for loser coworkers to differentiate them from losers in general (who are called induhviduals). [...]
14688 41 29_Re: use of union in subselect15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Wed, 20 Jun 2001 08:34:40 -0500411_iso-8859-1 Or possibly
... STATUS = 'L' OR STATUS IS NULL
depending on what is meant by 0 - 'O', '0' or null
Andy Lankester bmcsoftware My opinions are just that
-----Original Message----- From: Troy Coleman [mailto:Colematr@MEIJER.COM] Sent: 20 June 2001 14:01 To: DB2-L@RYCI.COM Subject: Re: use of union in subselect
Hi Chris, You need to use the "IN" clause. [...]
14730 56 18_Re: DB2 V6 Install11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 20 Jun 2001 09:29:37 -0400527_iso-8859-1 Dean,
Here is what I used. The ones that are commented out are "optional" depending on what you are trying to do with v6. Note I have REXX listed but it is really "optional" (but since it is free and handy why not)...
FORFMID ( HIR2101, /* IRLM */ HIY6610, /* V6 IMS ATTACH */ HIZ6610, /* V6 SUB-SYS INIT */ HDB6610, /* V6 BASE */ HDB661A, /* V6 DB2 ONLINE HELP */ JDB6613, /* V6 BASE LE */ JDB6614, /* V6 ENGLISH PANELS */ JDB661H /* V6 REXX */ /* H242220, DB2 NET.DATA */ /* JDB6612, V6 JAVA */ [...]
14787 113 8_Re: Cows0_19_mike.holmans@BT.COM31_Wed, 20 Jun 2001 14:34:38 +0100318_- As I understood it, "cow orker" appeared as an innocent typo in talk.bizarre in about 1989 and the denizens of the group seized on it.
My guess is that Raymond's a bit confused by it because "co-worker" is not a usual term outside the US.
Mike Holmans BT ISE Database Services mike.holmans@bt.com [...]
14901 108 8_Re: Cows15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 20 Jun 2001 08:50:32 -0500521_iso-8859-1 And loser teenagers are called a-duh-lescents.
Cow-tipping actually predates Beevis and Butthead. I have heard of it since I was a kid but haven't actually participated in a night of cow-tipping. Farmers don't like it. It ranks right up there with snipe-hunting. Snipe-hunting is where you tell country newbies that you are going hunting for snipes. You tell them that to do that they must hold a bag and call for the snipes. You then leave them to find their own way home or back to the campsite. [...]
15010 63 39_Re: Joins between Remote & Local tables15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 20 Jun 2001 15:56:12 +0200446_us-ascii Hello Chris,
Yes, you can't do it. The restriction is that all tables referenced in any single SQL must reside on the same DB2 subsystem.
There is a way around this however and that would be to use a product called Data Joiner (IBM). Of course, another way around it would be to replicate the remote table into your local DB2 (either periodic copy or if you happen to have DPROP installed have automatic replication). [...]
15074 59 18_Re: Sample Scripts9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Wed, 20 Jun 2001 14:40:23 +0100615_us-ascii Peter,
Try http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246012.pdf . I cut and pasted the scripts from there.
Chris
"Krawetzky, Peter J" To: DB2-L@RYCI.COM Subject: [DB2-L] Sample Scripts Sent by: DB2 Data Base Discussion List
20/06/01 12:05 Please respond to DB2 Data Base Discussion List
Does anyone know of a website (IBM's) where I can get a copy of the sample scripts printed in the back of the UDB V7.1 Performance tuning guide? [...]
15134 28 18_Re: Sample Scripts13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 20 Jun 2001 10:07:08 -0400460_iso-8859-1 Peter, Try http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246012.pdf or http://www.redbooks.ibm.com/redbooks/SG246012.html
If I recall correctly, you may have to register to get into the Redbooks details. I presume you want electronic copy so you don't have to re-type them.
You should be able to cut/paste from either of the above sites. It can be tricky cutting/pasting from PDF. Holler off-list if you can't get that to work [...]
15163 43 28_trigger qmf signal sqlstate?15_Neff, Stephen R16_NeffSR@STATE.GOV31_Wed, 20 Jun 2001 09:15:07 -0400623_iso-8859-1 Hello,
I created the following trigger on a DB2 OS390 v6 platform CREATE TRIGGER CLSMDEV.CLSRHAPI NO CASCADE BEFORE INSERT ON CLSODV5.CLSTHAP REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN (N.SN_WEIGHT + N.GN_WEIGHT ¬= 1) BEGIN ATOMIC SIGNAL SQLSTATE '75001' ('INVALID INSERT SN_WEIGHT + GN_WEIGHT MUST = 1'); END I tested by trying to insert a row where the SIGNAL SQLSTATE condition would be raised. I did this using QMF Version 6 Release 1 on the mainframe the edit table function. Sure enough the insert failed. QMF returns the message 'Non end-user SQLCODE returned from DBM.' I pressed pf1 [...]
15207 75 24_Re: ACCESS PATH QUESTION14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 20 Jun 2001 09:11:13 -0500742_iso-8859-1 One of many little things not yet changed in the manuals. Almost without exception, forget the 0=1 style of taking predicates away from index choices.
Regards, Richard +-----+-----+-----+-----+-----+ Richard_Yevich@YLAssoc.com YL&A - http://www.YLAssoc.com DB2 and Sysplex Gold Consultant Certified DB2 DBA for OS/390, z/OS
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > James Campbell > Sent: Wednesday, June 20, 2001 3:02 AM > To: DB2-L@RYCI.COM > Subject: Re: ACCESS PATH QUESTION > > > I have just noticed that IBM is still recommending "or 0=1" in V7. ( > http://publibz.boulder.ibm.com/cgi- > bin/bookmgr_OS390/BOOKS/DSNAGH10/5.8.4.2 ) > > [...]
15283 33 22_Re: Stogroup vol order16_Lemaire, Nigel B21_nigel.lemaire@EDS.COM31_Wed, 20 Jun 2001 09:19:52 -0500513_iso-8859-1 The problem is that there isn't an index on SYSVOLUMES, so when you add volumes DB2 just places the new entries in any pages that it finds space. Volumes are used in the sequence "found" in SYSVOLUMES, and are filled in that order for a given STOGROUP. I sure wish IBM would put an index on SYSVOLUMES and add a column SEQUENCE_ORDER. And use that to provide the order in which volumes are made available to a given Stogroup. Fortunately, we are on SMS managed DASD, so placement is somewhat PFM. [...]
15317 70 18_Re: DB2 V6 Install11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 20 Jun 2001 10:20:09 -0400539_iso-8859-1 Correction: JDB6619 is required. I had not originally applied it but did have a problem later without it.
My bad....
-----Original Message----- From: Hayden, Lee Sent: Wednesday, June 20, 2001 9:30 AM To: 'DB2L' Cc: 'Dean Montevago' Subject: RE: DB2 V6 Install
Dean,
Here is what I used. The ones that are commented out are "optional" depending on what you are trying to do with v6. Note I have REXX listed but it is really "optional" (but since it is free and handy why not)... [...]
15388 11 29_Re: use of union in subselect20_Dr. Matthias Wehrens29_matthias.wehrens@AM-GRUPPE.DE31_Wed, 20 Jun 2001 09:13:08 -0500334_- In V7 the UNION operation is allowed, because the IN-predicate is extended to FULLSELECTs.
================================================ 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.
15400 27 29_DB2 DBA help/ ORLANDO FLORIDA12_Confidential26_confidential@ECFACTORY.NET31_Wed, 20 Jun 2001 10:32:07 -0400521_iso-8859-1 I am currently looking for a person with IT experience i.e. DB2, DBA and OS/390 expertise for a position in ORLANDO FLORIDA. The opportunity offers a strong salary plus a nice sign on bonus plus full relo and a host of outstanding benefits. If you know of anyone who may be a good fit or if you want to know a little more detail yourself please reply or call and I would be happy to help in any way I can. We are not able to sponsor anyone with H1-b visa status. I can reward anyone with a referral bonus [...]
15428 17 20_Re: program swapping12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 20 Jun 2001 09:43:41 -0500434_- There are much better mechanisms for controlling swapping today. You don't want to swap out some job holding locks if another task will need conflicting access. Do not let the DB2 jobs have a discretionary priority and manage the commit frequency. I agree with the statements about having checkpoint and restart as required points. If you can't commit at some frequency, then you can't get a committed service level agreement. [...]
15446 69 45_Re: Union all conversion into full outer join16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 20 Jun 2001 20:15:26 +0530541_- I am sorry for my presumption i.e. I can't see UNION ALL and FOJ same if UNION ALL returns duplicate rows. In that case, UNION and FOJ is only having same result. If UNION ALL is used only for the performance reason, you can use FOJ.
Regards Sanjeev
> -----Original Message----- > From: S, Sanjeev (CTS) > Sent: Wednesday, June 20, 2001 5:39 PM > To: 'DB2 Data Base Discussion List' > Subject: RE: Union all conversion into full outer join > > Hi Hans, > > YES, UNION ALL can be converted into a full outer join. As far [...]
15516 58 26_Re: Another Oracle barrage14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 20 Jun 2001 09:49:23 -0500542_- You too can see Mr Bonvanie in action:
http://www.oracle.com/pls/ebn/popup.on_demand? p_referred=related_show&p_shows_id=587163&p_win_size=K056 (needs RealPlayer)
3 tribes. 4 challenges. 1 survivor. Rene Bonvanie, VP Oracle9i Marketing, keynotes OOW Berlin and outlines the DBA challenge--and what makes 9i the clear winner.
An interesting example of dazzling showmanship - and playing to a tame audience.
James Campbell
On Tue, 19 Jun 2001 23:29:50 -0500, John Hardy wrote: [...]
15575 95 37_Manager: QA needed in North Carolina!13_kathryn sears24_ksears@DPCONSULTANTS.COM31_Wed, 20 Jun 2001 10:55:25 -0400672_iso-8859-1 Hi- Once again, a $1,000.00 referral fee for leads that lead to placement of the following (in North Carolina- salary will be at least in the 70K plus range, although I would like to talk to anyone with this set of skills)-- Thanks, everyone! QA Supervisor/ Testing Manager:Lead System Testing of Agency initiatives through the management of a team of 10-15 Testers; Coordinate resources and activities to prepare project testing plans, script and execute test scenarios, track problems and corrections, and implement projects to Acceptance Testing to meet project target dates; Communicate with all stakeholders regarding testing effort; Provide training [...]
15671 44 30_Conditional Insert in triggers13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Wed, 20 Jun 2001 20:13:06 +0500593_- Hi Members,
I wanted a clarifications regarding Triggers. I have to do a conditional insert,in an after trigger, in the following manner
if (condtion1) then insert into t1 value v1 else ( if (condition2) then insert into t1 value v2 endif insert into t1 value v3 ) endif
At present I have had to create 3 triggers which execute on different when conditions Trigger1 - executes when condition1 is true and inserts v1 into t1 Trigger2 - executes when condition1 is NOT true and condition2 is true and insert v2 and v3 into t1 Trigger3 - executes when both conditions [...]
15716 30 57_3 DB2 Systems Programmers needed in Arizona or Minnesota.15_Jeff Wrightsell27_jwrightsell@RAPIDDEPLOY.COM31_Wed, 20 Jun 2001 10:05:58 -0500448_iso-8859-1 Must be a strong DB2 systems programmer. Responsible for implementation and on-going support of DB2 systems software for mainframe processors. Install, maintain, and troubleshoot various software products and tools used with DB2 and related software. Implementation, automation, maintenance, upgrades, configuration planning support of DB2 systems environment.
SMP/E, JCL, TSO/ISPF, BMC and/or Platinum utilities, MVS, CICS. [...]
15747 15 18_Re: PSQL Questions12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 20 Jun 2001 10:35:17 -0500481_- DB2 for OS/390 implemented SQL procedures back in Version 5 with APARs. See http://www.ibm.com/software/data/db2/os390/sqlproc/
DB2 for UNIX, Windows, OS/2 implemented SQL procedures in Version 7.
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.
15763 100 39_Re: Joins between Remote & Local tables12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US31_Wed, 20 Jun 2001 10:39:48 -0500416_US-ASCII Are you on os/390?
You can reference multiple DBMSs within a single statement. This is a distributed request and possible within a Federated Database.
Refer to: DB2 UDB Version 6, Administration Guide: Design and Implementation page 23, Federated Database System Concepts for an overview.
It states that you can even join a DB2 table with an Oracle view within a single statement. [...]
15864 14 26_Re: Another Oracle barrage10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 20 Jun 2001 18:11:32 +0200297_us-ascii No thanks I've a weak heart.
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.
15879 19 26_Re: Another Oracle barrage12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 20 Jun 2001 11:44:55 -0500318_- The way I understand this is that some Oracle folks think that lock escalation is bad. Oracle does not have the option for escalation - or cursor stability for that matter. My guess is that this marketing person does not understand that lock escalation is an option that customers can turn off if they want to. [...]
15899 231 32_Re: trigger qmf signal sqlstate?14_Crichton, Jean21_jcrichton@FEDDATA.COM31_Wed, 20 Jun 2001 13:24:04 -0400342_iso-8859-1 Hi Steve! Is this a trip down memory lane or what?
Native QMF uses Call Attach Facility executing dynamic SQL for ad-hoc queries. In order to get the SQLSTATE from CAF or any application, you would need to have a mechanism to return the SQLCA to the user, and I don't think native QMF returns the SQLCA to the display. [...]
16131 18 32_Re: trigger qmf signal sqlstate?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 20 Jun 2001 13:53:49 -0400466_iso-8859-1 Have you tried the insert from Spufi?
On non-zero SQLcodes, you generally get the SQLCA displayed from Spufi.
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.
16150 52 26_Re: Another Oracle barrage34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Wed, 20 Jun 2001 13:57:12 -0400493_iso-8859-1 Oracle uses redo logs to provides read stability to transactions which started after update transactions began, this way they avoid row lock for read transactions.
It is a different technique that Oracle uses but I personally feel DB2 has much robust mechanism to handle this using locking.
I am a big mainframer (the so called dinosour by few) but it would be interesting to hear opinions from people who have used Oracle as well as UDB on NT or Unix platforms. [...]
16203 16 41_DB2 V6 stored procedures and Powerbuilder14_Michele Saffer32_Michele_Saffer@CONSULTEC-INC.COM31_Wed, 20 Jun 2001 14:18:11 -0400395_us-ascii Is anyone using Powerbuilder to call a Version 6 stored procedure with a schema name other than SYSPROC?
Michele Saffer ACS/Consultec DBA
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16220 168 27_Re: Query Performance-HELP!13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Wed, 20 Jun 2001 13:46:42 -0500568_iso-8859-1 Sorry, I missed that.
Helen
Dimoka Popy wrote:
> Hi Helen, > yes ,index IXAUPTRN2 (POL_NO ,TRNS_ISS_DT ) is defined with a > descending order of TRNS_ISS_DT .That's why the subquery is carried out by a > one-fetch index scan ( I1 -see last step of the explain output ). > > TIA, > > Popy A. Dimoka > > > ---------- > > From: Helen Johnson[SMTP:helen_johnson@RAC.RAY.COM] > > Reply To: DB2 Data Base Discussion List > > Sent: Ôñßôç, 19 Éïõíßïõ 2001 4:15 ìì > > To: DB2-L@RYCI.COM > > Subject: Re: Query Performance-HELP! > > > > Do [...]
16389 17 38_DB2 V7 Uility template with tape STACK28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Wed, 20 Jun 2001 11:48:00 PDT369_- Chris,
This has been APAR'd. See PQ45835. Sorry you had to run into this.
Dan DB2 Utilities Development
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16407 64 25_Question on SQL procedure23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Wed, 20 Jun 2001 15:16:54 -0400279_ISO-8859-1 Greetings
Can anyone explain, how SQLCODE or SQLSTATE can be returned from a SQL procedure ? I have gone through the sample in the Redbook, but it does not work. I am using UDB ver 7.1 fix pack 2 and have also tried it on fix pack 3 (essentially ver 7.2). [...]
16472 71 29_Re: Question on SQL procedure15_Benjamin Reches33_Benjamin.Reches@MORGANSTANLEY.COM31_Wed, 20 Jun 2001 15:30:20 -0400443_us-ascii set 2 OUT variables to SQLCODE and SQLSTATE
"Jain, Sanjay (Exchange)" wrote:
> Greetings > > Can anyone explain, how SQLCODE or SQLSTATE can be returned from a SQL > procedure ? I have gone through the sample in the Redbook, but it does not > work. I am using UDB ver 7.1 fix pack 2 and have also tried it on fix pack 3 > (essentially ver 7.2). > > Sanjay Jain > > > > > > > > > > > > > > > > > > > > > > > > > > > [...]
16544 25 21_response file for 6.117_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Wed, 20 Jun 2001 14:44:38 -0500500_us-ascii Hello list!
We are in the process of rolling out db2 udb 6.1 admin and runtime clients using a response file. On some occasions we are running into a problem where some processes have DB2 locked and we cannot perform the upgrade. I know that in 7.1 to get around this there is a KILL option. When I add this to the response file for 6.1, it errors out at that line number and does not know what the line means. Anyone have a clue to killing those processes from a response file? [...]
16570 110 29_Re: Question on SQL procedure23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Wed, 20 Jun 2001 15:46:25 -0400501_ISO-8859-1 Benjamin,
It does not work. Like I said, I tried the sample in Redbook, but always get 0 or 00000 back. If it worked for you, can you share the code ? Also I forgot to mention that SQL proc is developed for DB2/OS390 ver 6.1 using SPB.
Sanjay Jain 8-226-7069
-----Original Message----- From: Benjamin Reches [mailto:Benjamin.Reches@MORGANSTANLEY.COM] Sent: Wednesday, June 20, 2001 3:30 PM To: DB2-L@RYCI.COM Subject: Re: Question on SQL procedure [...]
16681 20 33_Change tool for UDB on NT and AIX10_Fred Edgar22_fred_edgar@HOTMAIL.COM31_Wed, 20 Jun 2001 15:24:05 -0500386_- I would like to have a tool to make changes to UDB objects on NT and AIX. Something similar to CA's Migrator or BMC's Alter. Does anyone have any advice or recommendations. I would prefer not to hear from vendors right now. Thanks.
_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com [...]
16702 38 18_Re: Sample Scripts18_Gert van der Kooij15_geko@WANADOO.NL31_Wed, 20 Jun 2001 22:26:52 +0200737_iso-8859-1 It's on ftp://www.redbooks.ibm.com/redbooks/SG246012/
You can also get there by clicking on the 'Additional material' link on this rebooks 'main'page.
----- Original Message ----- From: "Krawetzky, Peter J" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, June 20, 2001 1:05 PM Subject: Sample Scripts
> Does anyone know of a website (IBM's) where I can get a copy of the sample > scripts printed in the back of the UDB V7.1 Performance tuning guide? > > Peter J. Krawetzky, DBA > IBM Certified Solutions Expert > DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2 > (860) 273-0301 > > ================================================ [...]
16741 55 37_Re: Change tool for UDB on NT and AIX12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 20 Jun 2001 13:44:55 -0700555_us-ascii Howdy Fred-
As I remember them, Migrator and Alter did different things. You can use control center to do table changes with a gooey interface, db2look to move table definitions, export/import to move data, and they're all free and part of UDB. There's the DIFF AIX command to compare scripts of DDL . Since it sounds like you're a mainframer going to the wonderful world of AIX, be a man and use the Command Line Processor. It'll remind you of TSO in the good old days before SPF. A BMC rep told me that their ALTER is part of their [...]
16797 50 38_RACF and DB2 Version 6 on OS/390 R2.1026_Angharad aka Dayna Brennan26_the_unicorn_lady@YAHOO.COM31_Wed, 20 Jun 2001 13:45:20 -0700404_us-ascii I am trying to move DB2 security to RACF. I have a situation I cannot explain and am hoping someone can help me.
User1 is SYSADM via RACF group. User2 is SYSADM via DB2. User2 has no other authorizations in DB2 or RACF.
User1 can create and drop lots of objects, including Database. User2 can create lots of objects and drop them, the only thing they cannot drop is Database. [...]
16848 36 29_Unique where not null on AIX?15_Jackson Reavill18_damcon2@US.IBM.COM31_Wed, 20 Jun 2001 17:00:21 -0400537_us-ascii Hi all,
Is there a way to create a unique index on AIX that would be the equivalent of "create unique index where not null" on OS/390? Don't see it in the DB2 UDB V7 for AIX manual, but maybe I'm missing it or it's disguised under some other syntax.. We've got a column that needs to be unique only when a value is supplied. If need be a trigger will probably do the trick. However, that's additional overhead on top of a non-unique index to support the trigger. It would be much cleaner to just have a unique index [...]
16885 46 37_Re: Change tool for UDB on NT and AIX10_Fred Edgar22_fred_edgar@HOTMAIL.COM31_Wed, 20 Jun 2001 16:12:13 -0500565_- Tim, I think Alter and Migrator do pretty much the same thing. I want a tool that will handle all the hassle when I change the order of columns in a table, or any task that requires dropping/re-creating objects without losing the data. And it would be nice if it would do runstats, take a backup and rebind packages while we're at it. Fred >Howdy Fred- > >As I remember them, Migrator and Alter did different >things. You can use control center to do table >changes with a gooey interface, db2look to move table >definitions, export/import to move data, and [...]
16932 42 37_Re: Change tool for UDB on NT and AIX18_Gert van der Kooij15_geko@WANADOO.NL31_Wed, 20 Jun 2001 23:19:22 +0200306_iso-8859-1 Hi,
I used PowerDesigner 7 from Sybase for a little project and found it to be very usefull. It's also completely configurable if you dig deep enough. It needs some time to get used to it but it's really powerfull. You can download a time-limited trial version from the Sybase site. [...]
16975 64 33_Re: Unique where not null on AIX?18_Gert van der Kooij15_geko@WANADOO.NL31_Wed, 20 Jun 2001 23:26:40 +0200523_iso-8859-1 Sorry, you're out of luck:)
Copied from the SQL Reference 'CREATE INDEX' syntax:
When UNIQUE is used, null values are treated as any other values. For example, if the key is a single column that may contain null values, that column may contain no more than one null value.
----- Original Message ----- From: "Jackson Reavill" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, June 20, 2001 11:00 PM Subject: Unique where not null on AIX? [...]
17040 17 16_UDB Compression?11_jim keister22_jkeister@ALTAVISTA.NET31_Thu, 21 Jun 2001 07:01:44 +080076_iso-8859-1 Is data compression available on UDB platforms other than OS/390?
17058 148 29_Re: Question on SQL procedure14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 20 Jun 2001 19:00:39 -0500421_iso-8859-1 The example in the Redbook does not work due to the way the C code is generated.
There is a "EXEC SQL SELECT x FROM SYSDUMMY1 INTO y" (condensed example) which sets the SQLCODE to 0 before you save the SQLCODE that you are interested in.
2 options really but you need to save the returned SQLCODE immediately after the statement is executed, else just modify the C code which is quite easy. [...]
17207 101 39_Re: Joins between Remote & Local tables11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Thu, 21 Jun 2001 07:11:45 +0700604_- I've tried it once on W2K, DB2 and Oracle. And it works fine... But you need to have DB2 Relational Connect to connect to Oracle.
>Are you on os/390? > >You can reference multiple DBMSs within a single statement. This is a >distributed request and possible within a Federated Database. > >Refer to: >DB2 UDB Version 6, Administration Guide: Design and Implementation >page 23, Federated Database System Concepts for an overview. > >It states that you can even join a DB2 table with an Oracle view within a single statement. > >Interesting....never implemented this, just read it. > >doug > [...]
17309 76 42_Re: RACF and DB2 Version 6 on OS/390 R2.1016_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Wed, 20 Jun 2001 20:12:56 -0400325_us-ascii hi, user2 has to be in the racf group for that db ie authorized to drop create db - sysadm or not. create racf group vvv grant dbadm on db vvv to racf group - connect user2 to racf group. hth tom f
Angharad aka Dayna Brennan on 06/20/2001 04:45:20 PM [...]
17386 71 37_Re: Change tool for UDB on NT and AIX16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Wed, 20 Jun 2001 20:19:41 -0400382_us-ascii fred, why drop create objects? why change the order of columns in a table? db2 doesn't care what order they sre in . alter add cols to end of table. reorg and use views for the order you need. hth tom f
Fred Edgar on 06/20/2001 05:12:13 PM
Please respond to DB2 Data Base Discussion List [...]
17458 64 59_Re: DB2 Symposium - Wellington and Sydney - July 30 - Aug 312_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Thu, 21 Jun 2001 10:35:30 +1000579_iso-8859-1 Any chance of visiting not so sunny Melbourne? and what the cost will be in $Aus?
Cheers, Nick Cianci > -----Original Message----- > From: Susan Lawson [SMTP:susan_lawson@YLASSOC.COM] > Sent: Tuesday, June 19, 2001 1:14 AM > To: DB2-L@RYCI.COM > Subject: DB2 Symposium - Wellington and Sydney - July 30 - Aug 3 > > The DB2 Symposium educational event is going to be held in Wellington, New > Zealand on July 30-31st and August 2-3rd in Syndey, Australia. > > Each session is one full day. There are two sessions each day to choose > from. > > Each session [...]
17523 52 37_Re: Change tool for UDB on NT and AIX11_Grant Allen22_grant@TOWERSOFT.COM.AU31_Thu, 21 Jun 2001 10:41:56 +1000501_- Thomas E. Faglon[SMTP:tfaglon@TELCORDIA.COM] wrote: > > fred, > > why drop create objects? why change the order of columns in > a > > table? db2 doesn't care what order they sre in . alter add cols to end > of > > table. reorg and use views for the order you need. > > hth > > tom f > Going slightly off topic here ... the order of columns directly impacts on the amount of logging needed for an update. Any change to a value in a varchar column dictates that the rest of the row (every column [...]
17576 84 21_Re: Next record Query10_John Hardy22_john_j_hardy@YAHOO.COM31_Wed, 20 Jun 2001 19:46:03 -0500454_- Manikhandan,
From the way you have framed your question, I would guess that you are more used to dealing with non-relational databases. Although you use terms such as 'Table', 'Column', and 'Row', you are still thinking in terms of pulling records off a file. DB2, in common with other relational databases, deals in 'sets' of data. In the case of your hypothetical one column table, your 'results set' may consist of the following values: [...]
17661 153 8_Re: Cows15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 21 Jun 2001 11:05:18 +1000326_iso-8859-1 Believe it or not, I do know what a co-worker is. Although, as I don't do any work myself, it might be stretching things to say I have fellow workers. I had assumed 'cow orker' was a typo, but then it spun out of control so I assumed there was more to it (which there was). Thanks for the etymology, everyone. [...]
17815 59 49_Re: Range v/s IN-list predicate ? CPU reduction ?12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Thu, 21 Jun 2001 11:24:28 +1000298_- Chenny, I assume that MONTH is defined as Integer? Depending on the type of col. stats you've collected DB2 may think that the predicate is not going to give any filtering (remembering 0 and negative numbers), and hence the filtering is being applied at the Data pages. [...]
17875 179 27_Re: Query Performance-HELP!13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 20 Jun 2001 20:34:20 -0500609_Windows-1252 Popy,
Too much is unknown about the query to give any detailed suggestions for performance improvements to this query.
As you can see, Explain does not really tell you much apart from what indexes were used, the general table join sequence, and what type of prefetch was chosen at bind time.
A trace would provide more detail as to where the problem lies. Also, you say the tables are large, but this is potentially irrelevant. What is more important is how many rows qualify after the application of each predicate (local and join) in the existing table join sequence. [...]
18055 76 37_Re: Change tool for UDB on NT and AIX16_Richard Muirhead19_dbaguru@HOTMAIL.COM31_Wed, 20 Jun 2001 21:57:30 -0500
18132 54 16_Update statement9_sandyt00123_sandyt001@EMAIL.MSN.COM31_Tue, 19 Jun 2001 22:53:50 -0400236_iso-8859-1 DB2 OS/390 version 6. Can you issue the following sql update. UPDATE TABLEA TA SET DIVISION = (SELECT TB.DIVISION FROM TABLEB TB WHERE TA.CHAIN = TB.CHAIN AND TA.MERCHANT = TB.MERCHANT)
18187 84 20_Re: Update statement13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 20 Jun 2001 22:54:12 -0500491_iso-8859-1 Yes. Remember though that the subquery can only return one row (scalar subquery).
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of sandyt001 Sent: Tuesday, June 19, 2001 9:54 PM To: DB2-L@RYCI.COM Subject: Update statement
DB2 OS/390 version 6. Can you issue the following sql update. UPDATE TABLEA TA SET DIVISION = (SELECT TB.DIVISION FROM TABLEB TB WHERE TA.CHAIN = TB.CHAIN AND TA.MERCHANT = TB.MERCHANT)
18272 102 59_Re: DB2 Symposium - Wellington and Sydney - July 30 - Aug 313_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 20 Jun 2001 23:08:50 -0500483_iso-8859-1 Nick,
I am speaking on behalf of my employers here, but the main reason that we have chosen Sydney only is because the Symposiums were held in Canberra and Melbourne last year. Sydney was completely left out last year with IDUG also in Melbourne.
This year it is Melbourne's turn, with IDUG heading to Canberra. It should make you extremely eager to attend our Symposium if Melbourne is a destination for 2002 (as IDUG will probably be in Sydney also). [...]
18375 98 20_Re: Update statement14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 20 Jun 2001 23:17:14 -0500457_iso-8859-1 Yes as long as DB2 OS/390 V6 is at the May 2000 refresh level.
Regards, Richard +-----+-----+-----+-----+-----+ Richard_Yevich@YLAssoc.com YL&A - http://www.YLAssoc.com DB2 and Sysplex Gold Consultant Certified DB2 DBA for OS/390, z/OS
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of sandyt001 Sent: Tuesday, June 19, 2001 9:54 PM To: DB2-L@RYCI.COM Subject: Update statement [...]
18474 99 59_Re: DB2 Symposium - Wellington and Sydney - July 30 - Aug 314_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 20 Jun 2001 23:17:14 -0500655_iso-8859-1 Did Melbourne last 2 years, just doing Sydney this year.
Regards, Richard +-----+-----+-----+-----+-----+ Richard_Yevich@YLAssoc.com YL&A - http://www.YLAssoc.com DB2 and Sysplex Gold Consultant Certified DB2 DBA for OS/390, z/OS
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Cianci, Nick > Sent: Wednesday, June 20, 2001 7:35 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Symposium - Wellington and Sydney - July 30 - Aug 3 > > > Any chance of visiting not so sunny Melbourne? and what the cost > will be in > $Aus? > > Cheers, > Nick Cianci > > -----Original [...]
18574 86 45_Re: Union all conversion into full outer join13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 20 Jun 2001 23:20:45 -0500464_iso-8859-1 Hans,
Yes it is possible to convert a UNION ALL to a FULL OUTER JOIN, although this is not something I would do for performance, but rather to overcome the limitation of pre-V7 OS/390 DB2 being unable to code a UNION in a view, nested table expression, subquery etc.
It is important to note though that the FULL OUTER JOIN and UNION ALL will only provide the same results if the join predicate is not possible between the two tables. [...]
18661 19 21_Doubt about SQLSTATE.13_Mathew, Sithu30_sithu.mathew@BLR.HPSGLOBAL.COM31_Thu, 21 Jun 2001 09:26:25 +0500477_- Hi List,
We are doing a migration project from ORACLE 8.1.6 to DB2 UDB 7.1. Can anybody tell what would be the SQLSTATE when you try to select from a table , into which insertion is taking place????......
Regards Mathew
================================================ 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.
18681 95 49_Re: Range v/s IN-list predicate ? CPU reduction ?13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 20 Jun 2001 23:31:10 -0500357_iso-8859-1 Nick,
Regardless of what DB2 determines to be the predicate's filter factor, if the predicate is an indexable or stage 1 predicate and does not qualify for matching index access, but the column appears in the index; then DB2 will apply the predicate as index screening (unless you are pre-V6 and V5 APAR and list prefetch is chosen). [...]
18777 50 49_Re: Range v/s IN-list predicate ? CPU reduction ?12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Thu, 21 Jun 2001 14:50:02 +1000408_- Terry, Cool bananas!
I caught your reply about 10 minutes after I sent mine off. My excuse is I've been off colour for a couple of days with a cold/flu, courtesy of young daughter, so it took me a little while to catch up with my list-serv stuff.
Your point on IN and BETWEEN was well taken. Although the difference about traversing non-leaf pages in the index should be minimal. [...]
18828 95 29_Re: use of union in subselect10_John Hardy22_john_j_hardy@YAHOO.COM31_Thu, 21 Jun 2001 00:02:18 -0500498_- Your requirement seems a little odd, but if I read you correctly, then what you want is simply this:
SELECT * FROM DWHD.WPDCNLIN WHERE LUP = 0 OR LUP IN (SELECT LUP FROM DWHD.TEDMARTL WHERE TABLE_NAME_DW = 'WPDCNLIN' AND TABLE_NAME_DM = 'MPFDCNOT' AND STATUS = 'L')
Of course, if your query was doing a matching index scan on an Index on WPDCNLIN, then it won't anymore. This is another alternative for you to try which should work and would maintain your matching index scan: [...]
18924 189 49_Lies, More Lies, and Oracle Claims, Part II of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 22:47:44 -0700640_- Let's Do the Time Warp Again
DB2 was a leader in 1995 and 1996 (not to mention 1981 through 2001), becoming the first database to support JDBC, and the first to publish TPC-D benchmarks. After staging V1 availability on AIX, HP, Solaris and NT, DB2 v2.1.2 shipped simultaneously on all of these platforms in 1996, with a few more precedents as the first database that supported stored procedures and user-written functions in Java. For DB2, this was not exceptional: the leadership extends backwards through IBM's invention of relational database (RDBMS), SQL, the first commercial RDBMS (1981), the introduction of recursion [...]
19114 103 50_Lies, More Lies, and Oracle Claims, Part III of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 22:49:19 -0700583_- Rules-base optimizers have certain limitations: they can blindly assume that data distributions are uniform or that indexes are always faster. DB2's optimizer uses more data to make better decisions: the number of CPU's on the SMP, the number of SMP's in the cluster, the disk speed and processor speed, and the data patterns that are not uniform. DB2's optimizer does not rely on hints (there is no HINT parameter on the SELECT statement in DB2). With DB2 it's always been easy -- we've made automatic selection of the right plan a design goal from day one of our very first [...]
19218 45 25_Re: Doubt about SQLSTATE.14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Thu, 21 Jun 2001 00:50:51 -0500398_iso-8859-1 Hi Mathew,
If you mean when you get a lock contention while trying to select (I.e. a deadlock or timeout) then for a -911 (UOW auto rollback) the SQLSTATE is 40001, for a -913 (UOW not rolled-back) it is 57033.
For a full list I suggest you RTM :)
There should be a DB2 Messages Reference in the DB2 Information Center, also Books Online and/or IBM's web site. [...]
19264 86 49_Lies, More Lies, and Oracle Claims, Part VI of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 22:53:11 -0700622_- Conclusion
Some technology companies like to ship a big software release and announce that the war is won, but check the facts. Some companies apparently don't always do so. Just how new are the features Oracle is touting in Oracle 9i? Look closely and judge for yourself. Consider query-sized memory allocation: DB2 has had the ability to allocate memory based on query size in the bufferpools and query compiler since 1995. DB2 has had self-managing tools for years: DB2's Governor shipped in 1995 and Query Patroller shipped in 1998. The Governor and Query Patroller have the ability to assign priorities [...]
19351 82 49_Lies, More Lies, and Oracle Claims, Part 1B of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 23:08:07 -0700603_- Advantages of Clustering for Scalability
Why is DB2 so committed to clustering? Because the ability to cluster machines and have software exploit the added power allows you to grow your business past the limits of the biggest single SMP you can buy. In 2001, DB2 has published TPC benchmarks across the spectrum (TPC-C, H and W) on clustered SMP's, NUMA machines and large SMP's for each result. Sun Microsystems sells machines with 64 CPU's, and Hewlett Packard has an architecture that can grow to 128, and DB2 is running at customer sites on clustered machines with over 200 CPU's. Sun [...]
19434 248 49_Lies, More Lies, and Oracle Claims, Part VA of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 23:09:34 -0700615_iso-8859-1 5) Scaling and Clustering Oracle's current (June 14, 2001) top-ten TPC-C result is on one large SMP, ranking in eighth place. Does this mean that it was just beaten by more hardware? Not necessarily. Although six results ahead of Oracle's are clustered, each resulted in a lower price/tpmC, result, as well as being faster (http://www.tpc.org/tpcc/results/tpcc_perf_results.asp). DB2 is the only database to publish transactional benchmarks (TPC-C, TPC-W) on both clustered and standalone machines, and also tackle TPC-H with both a medium-sized SMP and massive clusters. Consider the scope of DB2: [...]
19683 234 50_Lies, More Lies, and Oracle Claims, Part IVA of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 23:11:38 -0700675_iso-8859-1 And who should be held responsible for ensuring that no power user consumes too many resources? The DB2 Governor and DB2 Query Patroller. They automatically monitor and enforce policies for resources used by groups of applications. This makes it possible to automatically protect DB2 systems from runaway applications and to distribute resources fairly while still giving Database Administrators the ability to define their own policies for handling different workloads. The DB2 Governor permits DBA's to monitor and control the behavior of applications that run against the database, along with how often the Governor should check and enforce the rules. The [...]
19918 96 50_Lies, More Lies, and Oracle Claims, Part IVB of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 23:12:29 -0700550_- 3) DB2 as a Web Database
DB2 was attuned to the power of the web as far back as 1996, when DB2www (now Net.Data) offered an HTML and CGI interface to DB2 data. JDBC and Java stored procedure support followed, with SQLJ support and DB2 being bundled with Websphere in 1998. DB2 leads TPC-W at the 100,000 item count level. Is DB2 web-ready? DB2 customers were using XML in 1996, and IBM contributes a major part of open source for the XML parser in the Apache XML project. DB2 was also the first relational database to beta on Linux, to [...]
20015 237 49_Lies, More Lies, and Oracle Claims, Part 1A of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 23:27:48 -0700532_- This is a copy of an email from Mike Swift to DB2 Interested Parties.
Phil
Dear DB2 Interested Parties,
Clearly, DB2's success in the marketplace (14 consecutive quarters of double-digit growth) has got Oracle's attention. Their campaign of false claims and misrepresentations has intensified, as I'm sure you have noticed. I suppose that it comes with the territory, but the lies are galling. Worse, they are potentially damaging to companies whose decision-makers may not be able to discern the truth. [...]
20253 209 44_Lies, More Lies, and Oracle Claims, VB of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 23:31:02 -0700791_- CLEANUP_ROLLBACK_ENTRIES DELAYED_LOGGING_BLOCK_CLEANOUTS DML_LOCKS LM_LOCKS MAX_ROLLBACK_SEGMENTS ROLLBACK_SEGMENTS ROW_LOCKING SERIALIZABLE TRANSACTIONS TRANSACTIONS_PER_ROLLBACK_SEGMENT
7) High Availability/Non-Stop Computing
Oracle 9i uses a shared storage architecture. The other major databases on Unix and Windows (DB2, Informix, Microsoft) have chosen the shared nothing architecture. Oracle shares disks across nodes. The cost of this shared access has been that a DLM (distributed lock manager) runs in the background. DB2 requires no extra layer: shared nothing means that each node has exclusive ownership of its disks. Disks are shareable, not shared (just as any children's toy is always shareable, but seldom truly shared without dispute resolution). If a [...]
20463 136 44_Lies, More Lies, and Oracle Claims, VC of VI14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 20 Jun 2001 23:32:00 -0700303_- 10) The Evolution of the Database - Managing All Types of Data Choose your year, and IBM DB2 was there with innovation and leadership. After developing the System R prototype in the 1970's, and shipping SQL/DS and DB2 for MVS in the early 1980's, the next generation of DB2 developers delivered: [...]
20600 88 34_FW: Conditional Insert in triggers13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Thu, 21 Jun 2001 11:44:51 +0500346_- Hi Members,
I had posted the following query but haven't got any answers so I am posting it again. I have to do a conditional as follows:- insert,in an after trigger, in the following manner
if (condtion1) then insert into t1 value v1 else ( if (condition2) then insert into t1 value v2 endif insert into t1 value v3 ) endif [...]
20689 38 43_migration fom ims db and dc to db2 and cics17_Klein, Hans-Peter24_hans-peter.klein@EDS.COM31_Thu, 21 Jun 2001 08:55:40 +0100771_iso-8859-1 hi all
has someone experience with the migration from ims db and dc to db2
is it possible to migrate all the programms with a tool or do I have to convert some of them myselfe
Mit freundlichen Grüßen / Kind Regards
hans-peter klein ---------------------------------------------------------------------------- --------------------------------------------------- > EDS Electronic Data Systems > Informationstechnologie und Service GmbH > > CoC Warenwirtschaft Tel.: +49 (0) 6327 39-218 Im Altenschemel 21 Fax. : +49 (0) 6327 39-280 67435 Neustadt/Weinstraße Hans-Peter.Klein@eds.com ---------------------------------------------------------------------------- ---------------------------------------------------- [...]
20728 145 34_AW: Conditional Insert in triggers17_Klein, Hans-Peter24_hans-peter.klein@EDS.COM31_Thu, 21 Jun 2001 08:59:02 +0100736_iso-8859-1 hi i thiks it should be:
if (condtion1) then insert into t1 value v1 else ( if (condition2) then insert into t1 value v2 else insert into t1 value v3 endif ) endif
Mit freundlichen Grüßen / Kind Regards
hans-peter klein ------------------------------------------------------------------------ ------------------------------------------------------- > EDS Electronic Data Systems > Informationstechnologie und Service GmbH > > CoC Warenwirtschaft Tel.: +49 (0) 6327 39-218 Im Altenschemel 21 Fax. : +49 (0) 6327 39-280 67435 Neustadt/Weinstraße Hans-Peter.Klein@eds.com ------------------------------------------------------------------------ -------------------------------------------------------- [...]
20874 20 38_Date of first Release of DB2 for OS39011_Graham Earl26_gearl@PRINCETONSOFTECH.COM31_Thu, 21 Jun 2001 03:14:57 -0500395_- Sorry, I know I should either be able to find this on the archive, or should know it myself, but sorry I cannot get satisafction from either!
Here goes. Simple question. What was the release date of the very first release of DB2 on OS390 (i.e. 1.1)? I have a vague recollection, but I'm sure someone out there knows. I'm doing a presentation that i need this for the introduction. [...]
20895 29 19_TOP Secret Problems10_Mark Frost23_mark.frost@CITICORP.COM31_Thu, 21 Jun 2001 09:45:33 +0100463_US-ASCII Hi.
Has anyone experienced problems with DB2 OS390 and TOP Secret with regards execution authority for packages and stored procedures being executed from a remote connection ?
Secondary authids are not being checked for execution authority. They are however being checked for normal SQL requests..
any information would be most appreciated..
regs
Mark Frost. Database Support. Tel - 0207 500 2632. [...]
20925 72 42_Re: Date of first Release of DB2 for OS3900_24_ujjwal@LOT.TATASTEEL.COM31_Thu, 21 Jun 2001 14:26:52 +0530489_us-ascii When Codd introduced the relational model in 1970 , there was a flurry of experimentation with relational ideas.A major research and development effort was initiated at IBM's San Jose Research Center .It led to the announcement of two commercial relational DBMS products by IBM in the 1980s : SQL/DS FOR DOS/VSE(virtual storage extended) and the VM/CMS environments introduced in 1981. AND DB2 for MVS OS was introduced in 1983. Ingres was also introduced in the late 1970s. [...]
20998 190 34_Re: Conditional Insert in triggers13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Thu, 21 Jun 2001 14:15:47 +0500375_iso-8859-1 Hi Peter,
The condition that I have mentioned is correct. If condition1 fails then there is one general insert and one conditional insert. So the else if (condtion1) then insert into t1 value v1 else ( if (condition2) - If condition2 then insert then insert into t1 value v2 endif insert into t1 value v3 - insert always if condition1 is false ) endif [...]
21189 20 34_Re: Conditional Insert in triggers15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 21 Jun 2001 06:05:05 -0500440_- Hi Swamy or Ritesh ?
You can do that with a CASE expression:
INSERT INTO t1 SELECT CASE WHEN condition1 THEN v1 WHEN condition2 THEN v2 and so on END) FROM SYSIBM.SYSDUMMY
HTH
================================================ 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.
21210 26 19_DB2 V6 and S390 2.510_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 21 Jun 2001 13:36:40 +0200421_us-ascii Estimeed listerz,
We are installing DB2 V6. We planned to install S390 V 2.10 first, but unfortunately for internal problems it'll be not possible.
Did someone meet any problem with this strange couple ? Any tip/hint ?
Thanks & regards Max Scarpa Useless DB2 sysprog
'Everybody,man or woman, is equal before the law of gravity. So don't trust in apparent violations of this law' [...]
21237 112 30_Db2 Timeout & Deadlock Problem11_DSI LISTSRV18_dsi.listsrv@DB.COM31_Thu, 21 Jun 2001 17:04:35 +0530606_us-ascii From: Murthy P on 06/21/2001
Subject: Db2 Timeout & Deadlock Problem
Hi,
We are facing TIMEOUT & DeadLocks Exceptions in DB2(UDB 6.1 on NT) while saving data . This problem occurs when 10+ users have connected to the database. When users are connected & working on the database continously, below mentioned tables gets locked and others cannot save the data because of lock timeout error. Currently we have set the locktime out to 180 seconds. We have checked the commit points in the code and seems to be OK. Kindly let me know how do we solve this problem. The [...]
21350 150 29_Re: use of union in subselect13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Thu, 21 Jun 2001 06:46:14 -0500390_iso-8859-1 To avoid the UNION sort, then code:
SELECT * FROM DWHD.WPDCNLIN WHERE LUP IN (SELECT LUP FROM DWHD.TEDMARTL WHERE TABLE_NAME_DW = 'WPDCNLIN' AND TABLE_NAME_DM = 'MPFDCNOT' AND STATUS = 'L' AND LUP <> 0) UNION ALL SELECT * FROM DWHD.WPDCNLIN WHERE LUP = 0;
Or to maintain a single select, so that an index can avoid an ORDER BY sort (if coded of course), then: [...]
21501 66 42_Re: TOP SECRET and Execution Auth problems11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Thu, 21 Jun 2001 08:43:47 -0400395_iso-8859-1 Mark,
I did not see a response to this so even though we are not Top Secret I will take a stab.... I think it is similar to RACF. One area you need to check for group authority is the DB2 exits.
In order for DB2 to get a list of "groups" that a user is associated with, there are some 2 exits involved. For RACF DB2 comes with samples. See job DSNTIJEX in Samplib. [...]
21568 22 41_Re: Lies, More Lies, and Oracle Claims...12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Thu, 21 Jun 2001 08:52:54 -0400571_us-ascii Philip, Thank you for forwarding that comprehensive refutation.
Unfortunately, we seem to have let slip a golden opportunity to put such questions to the big E himself :
http://news.bbc.co.uk/hi/english/business/newsid_1399000/1399108.stm#say
Don't you hate it when that happens?
Gregg Sawyer
================================================ 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.
21591 71 37_Re: Change tool for UDB on NT and AIX0_22_BILL_GALLAGHER@PHL.COM31_Thu, 21 Jun 2001 08:56:51 -0400614_us-ascii We've done a pretty extensive evaluation of database administration tools for the UDB/AIX environment. The best tools that we've seen are BMC's "Patrol: Change Manager", and the Database Administration component of Quest's "Quest Central" suite of tools. CA also has their "ManageIT" tools now available for this environment, I will be taking a look at those in the near future. Embarcadero's "DBArtisan" is a nice tool, it's dirt cheap, has a fair amount of functionality for simple schema changes, but is not the most robust tool out there. If you have large tables (in terms of volume of data), I [...]
21663 13 18_Re: Sample Scripts18_Peter J. Krawetzky21_KrawetzkyPJ@AETNA.COM31_Thu, 21 Jun 2001 07:41:51 -0500483_- Thanks for the responses. One more question. Did anyone have to change the locks.awk script because of errors? I attempted to use the sample as is but have been getting errors in the awk scripts. I am unable to figure out the syntax error.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21677 19 29_Changing DB2 Passwords via VB9_Tim Burke21_Tim_Burke@PEPBOYS.COM31_Thu, 21 Jun 2001 07:44:23 -0500356_- I have 3 environments: Development, Test and Production DBs. within a VB application I would like the user to have the ability to change their user password. This functionality works in Development and Test, but not Production. Can anyone help solve this mystery? Is their a setting on the Production DB that is cause this change not to be allowed? [...]
21697 23 10_Visual C++0_20_John_Lendman@FPL.COM31_Thu, 21 Jun 2001 09:14:34 -0400526_us-ascii I know this is a Database list server, but a friend of mine what to know if there was a good self instructional course out there on Visual C++? If any one know please let me know
Thanks
John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413
================================================ 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.
21721 99 42_Re: RACF and DB2 Version 6 on OS/390 R2.100_22_BILL_GALLAGHER@PHL.COM31_Thu, 21 Jun 2001 09:16:25 -0400480_us-ascii Dayna,
If you've defined a profile for SYSADM via RACF, then any SYSADM authority in DB2 should be ignored. SYSADM authority should only be determined by who has access to the RACF SYSADM profile.
The only time DB2 security will be accessed would be in a situation where User2 is try to perform some sort of action against a particular object in which there is no RACF profile (specific or generic) defined that covers that action against that object. [...]
21821 55 18_Re: Sample Scripts9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Thu, 21 Jun 2001 14:17:55 +0100446_us-ascii Peter,
I found that there were a few typo errors in the scripts. I've got them all working and can send them to you offline if you like.
Chris Tee
"Peter J. Krawetzky" To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Sample Scripts Sent by: DB2 Data Base Discussion List
21/06/01 13:41 Please respond to DB2 Data Base Discussion List [...]
21877 46 40_Re: Date of first Release of DB2 for OS364_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Thu, 21 Jun 2001 08:29:37 -0500501_ISO-8859-1 DB2 V1R1 became generally available in April, 1985.
Todd Burch
-----Original Message----- From: gearl@PRINCETONSOFTECH.COM Sent: Thursday, June 21, 2001 3:41 AM To: DB2-L@RYCI.COM Subject: Date of first Release of DB2 for OS390
-------------------------------------------------------------------------- -- Sorry, I know I should either be able to find this on the archive, or should know it myself, but sorry I cannot get satisafction from either! [...]
21924 59 33_Re: Changing DB2 Passwords via VB9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Thu, 21 Jun 2001 14:22:32 +0100735_us-ascii Tim,
Check that the ZPARM parameter EXTSEC is set to YES on your prod system.
Chris Tee
Tim Burke cc: Sent by: DB2 Subject: [DB2-L] Changing DB2 Passwords via VB Data Base Discussion List
21/06/01 13:44 Please respond to DB2 Data Base Discussion List
I have 3 environments: Development, Test and Production DBs. within a VB application I would like the user to have the ability to change their user password. This functionality works in Development and Test, but not Production. Can anyone help solve this mystery? Is their a setting on the Production [...]
21984 12 18_Re: Sample Scripts18_Peter J. Krawetzky21_KrawetzkyPJ@AETNA.COM31_Thu, 21 Jun 2001 08:33:39 -0500333_- Yes, please. Debugging this awk stuff is very frustrating...
KrawetzkyPJ@aetna.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.
21997 68 40_Re: Date of first Release of DB2 for OS316_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 21 Jun 2001 09:46:54 -0400545_iso-8859-1 Generally available but not generally usable! Those were really tough days for DB2 support folks. I got assigned DB2 duties since I had the least seniority in the department. No complaints though, it was a good career move!
Regards. eric pearson NS ITO Database Support
-----Original Message----- From: Todd Burch ***************************************************** [mailto:tburch@CDBSOFTWARE.COM] Sent: Thursday, June 21, 2001 9:30 AM To: DB2-L@RYCI.COM Subject: Re: Date of first Release of DB2 for OS3 [...]
22066 48 40_Re: Date of first Release of DB2 for OS364_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Thu, 21 Jun 2001 09:18:19 -0500432_ISO-8859-1 I *WAS* DB2 support in those days!! (along with about 15 others in Level 2/3 @ Santa Teresa, then an offsite building in San Jose) It started getting REALLY busy in '86, about the time I went into DB2 planning. '84 and '85 was spent helping the early customers and the controlled availability customers, and of course, learning DB2. 17 years later, who would have thunk? A lot of the original folks are still there. [...]
22115 26 26_Re: Another Oracle barrage18_Peter J. Krawetzky21_KrawetzkyPJ@AETNA.COM31_Thu, 21 Jun 2001 09:23:40 -0500519_- And there lies the big difference. We converted an application from Oracle to UDB. After the conversion, the application started experiencing deadlocks. After several attempts to fix it at the database level, we determined that the deadlocks are being created within the application itself. Reason, Oracle allows dirty reads. The application logic needed current data. It had repetatively re-read rows to maintain currency and update others in the same table. UDB does this very well outside of the application. [...]
22142 12 34_Re: Client Configuration Assistant18_Peter J. Krawetzky21_KrawetzkyPJ@AETNA.COM31_Thu, 21 Jun 2001 09:26:46 -0500409_- You have to bind packages for each operating system that you are accessing UDB/DB2 from (i.e. windows95, windows98, windowsNT, etc). You can do this through the CCA.
================================================ 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.
22155 52 41_Re: Lies, More Lies, and Oracle Claims...11_John Wynton21_jwynton@THEMISINC.COM31_Thu, 21 Jun 2001 10:29:22 -0400576_windows-1252 Gregg:
I don't think you are too late to email a question. From a little digging, it would appear the show is on at 20:30 today, or 3:30 pm ET.
Ask Away
Cheers,
John Wynton Senior Account Manager Themis, Inc. Specialists in DB2, CICS & MQSeries Education 1-800-756-3000; 908-233-8900 (Int'l) http://www.themisinc.com
-----Original Message----- From: Gregg Sawyer [mailto:gregg.a.sawyer@VERIZON.COM] Sent: Thursday, June 21, 2001 8:53 AM To: DB2-L@RYCI.COM Subject: Re: Lies, More Lies, and Oracle Claims... [...]
22208 26 42_Unsuccessful Call of DB2 Stored Procedures14_Maryann Galvin25_maryann.galvin@IBPINC.COM31_Thu, 21 Jun 2001 09:14:52 -0500395_- Hello Everyone,
I am hoping someone can give me some ideas on get this working. I am tyring to call a DB2 Stored Procedure. We are able to call our Stored Procedures through program such as VB and C, however when we trying calling these same Stored Procedures through a product such as Crystal Reports V8.0, or Microsoft Excel using Microsoft Query we receive the following error. [...]
22235 49 34_Re: Conditional Insert in triggers13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Thu, 21 Jun 2001 19:49:40 +0500375_iso-8859-1 Hi Walter,
Thanks for the info. I had tried this earlier but the problem is that if the conditions are not met then then a blank row gets inserted into the table, which we want to avoid.
regds, Ritesh
-----Original Message----- From: Walter Janissen To: DB2-L@RYCI.COM Sent: 06/21/2001 4:05 PM Subject: Re: Conditional Insert in triggers [...]
22285 101 47_Re: migration fom ims db and dc to db2 and cics0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 21 Jun 2001 10:01:01 -0500573_iso-8859-1 Yes there are tools to 'automate' the conversion but there will always be a need for some manual intervention. What the conversion tool vendors won't tell you is that there is a fundamental difference between how the two DBMS are designed. IMS is hierachical, 1 record at time, DB2 is relational it works with sets of rows. So although converted code will execute, it will not do so efficiently. One of our daily batch programs ran for over 30 hours after the intitial conversion. It took huge effort to get the run time down to an acceptable range. In our [...]
22387 79 42_Re: Date of first Release of DB2 for OS39022_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 21 Jun 2001 10:48:01 -0400686_iso-8859-1 Check out Roger Miller's message about the early days. Very cool history lesson.
From: Roger Miller [millerrl@US.IBM.COM] Sent: Saturday, June 16, 2001 15:01 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Database holy war
If you are interested in some of the early history, we had an SQL reunion back in 1995, with most of the historical people: Paul McJones, Roger Bamford, Mike Blasgen, Don Chamberlin, Josephine Cheng, Jean-Jacques Daudenarde, Shel Finkelstein, Jim Gray, Bob Jolls, Bruce Lindsay, Raymond Lorie, Jim Mehl, Roger Miller, C. Mohan, John Nauman, Mike Pong, Tom Price, Franco Putzolu, Mario Schkolnick, Bob Selinger, Pat Selinger, Don Slutz, Irv [...]
22467 83 41_Re: Lies, More Lies, and Oracle Claims...12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Thu, 21 Jun 2001 11:17:49 -0400320_us-ascii John, Thanks for the encouragement, but that page is now "hidden", leaving me to assume that they are no longer accepting questions and are now working on compiling the good stuff - or, as is prevalent these days, passing them to the Oracle bods for vetting to make sure nothing uncomfortable is raised... [...]
22551 14 39_Re: IBM 9672's and hardware compression12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 21 Jun 2001 10:21:22 -0500477_- If hardware is there, it is faster, so it's used. If the hardware is not there, DB2 uses its own software, since we shipped our compression work in 1993 V3, before the MVS software support was there.
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.
22566 65 34_Re: Conditional Insert in triggers10_Shery Hepp17_schepp@SRPNET.COM31_Thu, 21 Jun 2001 08:22:55 -0700677_iso-8859-1 Walter/Ritesh - have you been successful at creating a trigger with a case statement? I would be very interested in obtaining the ddl of the trigger.- since I've been unsuccessful at that.
Here's a question I posted to the list earlier this year-
> -----Original Message----- > From: Shery Hepp [SMTP:schepp@SRPNET.COM] > Sent: Saturday, March 31, 2001 4:14 AM > To: DB2-L@RYCI.COM > Subject: Trigger question > > Greetings- > > I'm having a problem with creating an after trigger. I've been going > through > the manuals and trying all kinds of different variations and I'm fresh [...]
22632 40 26_Re: Another Oracle barrage11_Mike Hately20_MHately@ETECH-UK.COM31_Thu, 21 Jun 2001 16:28:22 +0100383_us-ascii It's an interesting problem isn't it? Allowing concurrent access to the same data. The 2 databases use entirely different locking strategies and so a high concurrency system is never going to be an easy port. But surely it would work the same in reverse? If you tie the design of a system to the underlying RDBMS architecture than some problems are nigh on inevitable. [...]
22673 72 45_Re: DB2 V6 stored procedures and Powerbuilder12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 21 Jun 2001 10:45:07 -0500407_us-ascii Hello,
Yes, I believe we're doing this. Our PB wiz is out for a few days but it looks to me like we're using two schema names that we pulled into the SCHEMALIST on the Enterprise tab via the Advanced Settings option of the CLI/ODBC Settings, through the Client Configuration Assistant (or NT Control Panel - ODBC Data Sources.) We define our subsystems as System DSN ODBC data sources. [...]
22746 45 66_Upgrade Issues going from DB2/UDB 5.2 (AIX) to DB2/UDB 7.1 (AIX) ?18_Richard Mccutcheon32_Richard_McCutcheon@HCM.HONDA.COM31_Thu, 21 Jun 2001 11:54:37 -0400607_us-ascii Good day all.
I am in the preliminary stages of putting together a plan to upgrade many (approx. 15) DB2/UDB ver5.2 instances to DB2/UDB ver7.1. I am looking for any experiences along that line that any of you would be kind enough to share.
I will be staging the implementations over a fairly long timescale (ie/ a couple of months), and therefore have to keep in mind how some of these instances will communicate with each other during the implementation. In our envirenment we have a fair bit of Replication between numerous AIX servers, and an OS/390 mainframe. The mainframe [...]
22792 133 76_Re: Stored procedure builder, result set column name is getting t runc ated.12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Thu, 21 Jun 2001 11:40:39 -0400408_us-ascii Philip, You cannot "see" this meta data explicitly in Stored Procedure Builder (SPB) - it is interpreted for you and presented as the column names you are seeing (albeit truncated in some cases). SPB is essentially a Java application providing a development tool for Stored Procedures; I do not believe that it is intended as a presentation mechanism - compare the SPUFI mainframe application. [...]
22926 107 34_Re: Conditional Insert in triggers13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Thu, 21 Jun 2001 21:45:00 +0500369_iso-8859-1 Hi Sherry,
I have also been trying to use stored procedures but haven't been able to do so. I had also posted a question on the list asking how to call stored procedures from triggers in UDB 7.1 on NT, but did not get any replies.
As far as using the CASE is concerned I also could use it only for UDF's in VALUES and SET statements only. [...]
23034 95 45_Re: DB2 V6 stored procedures and Powerbuilder14_Michele Saffer32_Michele_Saffer@CONSULTEC-INC.COM31_Thu, 21 Jun 2001 12:22:51 -0400372_us-ascii Thanks for the help. I finally got it to work. Turns out all I had to do was put a collection ID in the definition of the stored procedure in DB2.
Michele
____________________Reply Separator____________________ Subject: Re: DB2 V6 stored procedures and Powerbuilder Author: DB2 Data Base Discussion List Date: 6/21/01 11:45 AM [...]
23130 78 26_Re: Another Oracle barrage12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Thu, 21 Jun 2001 11:56:32 -0500300_us-ascii Just to clear up a mis-conception, Oracle does NOT allow dirty reads. It is not even an option.
With Oracle, you have an instant snapshot of committed-only data as of the start of your query. Data that changes (committed or not) during the life of your Oracle query is not seen. [...]
23209 38 41_How do you report a bug with Db2 Connect?12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Thu, 21 Jun 2001 12:55:41 -0400360_iso-8859-1 Hello,
I have a problem (that I believe to be a bug with DB2 Connect V7.2 under Windows 2000) but since we did not purchase the support option, how to I go about reporting the bug? Or can I only report bugs if I buy the service? I checked the web pages and my Passport Advantage (whatever that is) and all I seem to do is go in circles. [...]
23248 16 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Thu, 21 Jun 2001 12:06:26 -0500447_us-ascii I will be out of the office starting 06/21/2001 and will not return until 06/22/2001.
I will be out of the office for the remainder of the day. I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
23265 115 26_Re: Another Oracle barrage15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 21 Jun 2001 12:11:51 -0500528_iso-8859-1 Hi, John, "With Oracle, you have an instant snapshot of committed-only data as of the start of your query. Data that changes (committed or not) during the life of your Oracle query is not seen." Forgive my ignorance but isn't that the definition of a dirty read? A dirty read is where you can read the data and you don't take any locks on that data to ensure that no one else will change it while you are looking at it. When a dirty read is not allowed then DB2 will lock the data with an S-lock that will allow [...]
23381 186 45_Re: How do you report a bug with Db2 Connect?14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Thu, 21 Jun 2001 10:17:37 -0700584_iso-8859-1 Well Robert, as far as I know and based on experience, you need a support line contract to report problems. However, since the product manager and others from Toronto are on this list, they might be looking at your problem now. However, the list is no substitute for support as you know. Plus, some of our subscribers might have experienced the same problem and have an answer for you, if you're lucky:) Hmm, if you go to http://www-4.ibm.com/software/data/db2/db2connect/support.html you will find, newsgroups and db2-l listed as informal resources.... Regards, Phil [...]
23568 174 26_Re: Another Oracle barrage13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Thu, 21 Jun 2001 10:24:06 -0700535_iso-8859-1 Oracle's philosophy is different for handling data consistency. It shows the user only consistent data, as the data was, the 'last time' it was consistent. Let us suppose a UOW started two hours back and is not yet committed. Now if I run a query to select for a table involved in UOW, Oracle shows me the data when it was 'consistent' the last time. In short, if a row of that table was changed two hours back and is not yet committed, I will see the data as it was two hours back. This is definitely not 'dirty read' [...]
23743 169 26_Re: Another Oracle barrage34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Thu, 21 Jun 2001 13:34:39 -0400595_iso-8859-1 Linda
That is not dirty read. Dirty read is actually read thru locks. DB2 has different mechanism than Oracle for . DB2 you have isolation UR/CS/RS/RR and locking is needed for any DML operations unless UR or lock avoidance is used. However Oracle provides a REDO log mechanism. It keeps tracks of every changes done by various transactions in the REDO log, which are defined for each table. When some transaction wants to read the data, ORACLE based of SCN, determines the time sequences and then reads the REDO logs to give a committed data at the time read transaction [...]
23913 177 26_Re: Another Oracle barrage12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Thu, 21 Jun 2001 12:36:49 -0500556_iso-8859-1 Well, no.
A "dirty read" is what you get with DB2's "WITH UR".
That lets you read changed but uncommitted data. Since the data is uncommitted, it might be inconsistent -- more data is to be changed before the commit. It might not ever be committed, it might be rolled back.
Oracle's "consistent read" is similar to DB2's Cursor Stability (CS) -- data can indeed change after you have read it. Oracle's "consistent read" is different in that it does not show any changes that have occurred since the start of the query. [...]
24091 41 27_Oracle & Sun marketting fun12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 21 Jun 2001 10:43:50 -0700607_us-ascii While we're ranting about silly marketting claims and ploys coming out of silicon valley...
Has anyone else noticed the SUN ads touting how they only support one operating system (Solaris, of course), and how it's such an advantage to have a homogenous datacenter? Dastardly vendors HP and IBM insist on giving you a choice of up to 11 different operating systems, those cads. Including, I'm shocked to say, Linux! Mr McN. seems to have come full circle in a relative short period of time, from advancing the idea of "open" systems connected via (his dog) Network. Must be drinking too [...]
24133 204 26_Re: Another Oracle barrage15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 21 Jun 2001 12:59:44 -0500624_iso-8859-1 Thank you for the clarification, Ashish. I looked up the definition of a dirty read or uncommitted read in the Admin guide and this is what it says,
"....However, if you use uncommitted read (UR) isolation, you can violate that basic principle of locking. Uncommitted read (UR) isolation lets users to see uncommitted data. Although the data is physically consistent, a number of logical inconsistencies can occur, or the data could be wrong. " It seems that Oracle will only read the consistent data so therefore doesn't do dirty reads according to this definition. However, the data can change from [...]
24338 136 26_Re: Another Oracle barrage34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Thu, 21 Jun 2001 14:01:18 -0400576_iso-8859-1 I clicked the sent button in the previous mail by mistake. That mail had tons of grammatical error as errors found in Oracle. This mail has those errors corrected. Remaining errors will be corrected in the version 11x. ---------------------------------------------------------------------------- -------- Linda
That is not dirty read. Dirty read is actually read through locks. DB2 has different mechanism than Oracle for locking . In DB2, you have isolation UR/CS/RS/RR and locking is needed for any DML operations unless UR or lock avoidance is used. [...]
24475 212 47_Stored Procedure produces duplicate results set10_Lynch, Pam25_PLynch@HASTINGSMUTUAL.COM31_Thu, 21 Jun 2001 13:44:01 -0400449_iso-8859-1 Environment: DB2 for OS/390 Version 5 Stored Procedure on OS/390 written in COBOL for MVS DB2 Connect Enterprise Edition Version 7.1, Fixpack 2 Web application is using ASP (Active Server Page) code to call the stored procedure.
The stored procedure has 3 input/output parameters, 2 output only parameters, and 1 result set. For the most part, this stored procedure is working fine, and we are receiving the expected results. [...]
24688 75 45_Re: How do you report a bug with Db2 Connect?12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 21 Jun 2001 11:19:15 -0700391_us-ascii Have you tried calling the 1-800 number for IBM? I've found that even if you don't have a support contract, you can call that number for DB2 Connect and they will take problems. They'll give you a funny problem number that you have to use to call in. It makes it hard to track via IBM link (or Passport Advantage) (like impossible), but you can create problems in this manner. [...]
24764 153 26_Re: Another Oracle barrage15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 21 Jun 2001 13:30:18 -0500390_iso-8859-1 Thanks for all the information everyone. It obviously has been a while since I have dealt with dirty reads. That was a nice review and lesson on how Oracle works.
Linda
-----Original Message----- From: Pillay, Venkat (USPC.PCT.Hopewell) [mailto:venkat_pillay@ML.COM] Sent: Thursday, June 21, 2001 1:01 PM To: DB2-L@RYCI.COM Subject: Re: Another Oracle barrage [...]
24918 27 14_RTRiM Question13_Keerthi Chegu18_lpbusobj@YAHOO.COM31_Thu, 21 Jun 2001 13:23:57 -0500387_- Hi All:
This is a simple one. But, somehow I am not able to get the correct syntax. Db version is UDB 5.2/os 390 and I need to rtrim a column with trailing blanks in my select st.
select rtrim(country_name) from country_t
This st. gives me " IBM CLI driver SQL 0104N unexpected token rtrim found, possible tokens include substr,avg,max) etc., SQL state 42601 [...]
24946 242 45_Re: How do you report a bug with Db2 Connect?14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Thu, 21 Jun 2001 11:45:13 -0700588_iso-8859-1 Myron, Hmm... You must have the magic touch because EVEN with a support contract I have had problems when the paperwork wasn't in order ...:) Phil
-----Original Message----- From: Myron Miller To: DB2-L@RYCI.COM Sent: 6/21/01 11:19 AM Subject: Re: How do you report a bug with Db2 Connect?
Have you tried calling the 1-800 number for IBM? I've found that even if you don't have a support contract, you can call that number for DB2 Connect and they will take problems. They'll give you a funny problem number that you have to use to call in. It makes it hard [...]
25189 33 39_Bad Access Path thru CLI - OK otherwise12_Jim Fletcher19_jfletch3@US.IBM.COM31_Thu, 21 Jun 2001 14:46:48 -0400594_us-ascii Hi,
I have a complex query running in a CLI application. The call takes about 10 minutes and 600 cpu secs to complete, that time being spent in the open cursor. When the call is extracted from the program and run from a DB2 command window or query tool, it begins returning rows immediately. The explain output was captured at execute time(db2explain=3 in db2cli.ini) in the CLI app and it looks absolutely terrible. The explain output from the DB2 command window is complex but efficient. The call has four parameter markers. The explain done with the markers is the same [...]
25223 48 18_Re: RTRiM Question11_Jeff Schade21_JSCHADE@MAIL2.PCH.COM31_Thu, 21 Jun 2001 14:48:58 -0400450_US-ASCII Hi KC,
You want to use the STRIP function which is coded as follows:
STRIP(column name,T)
The last T is for trailing and could also be L for leading and B for Both.
Jeff
>>> lpbusobj@YAHOO.COM 06/21/01 02:23PM >>> Hi All:
This is a simple one. But, somehow I am not able to get the correct syntax. Db version is UDB 5.2/os 390 and I need to rtrim a column with trailing blanks in my select st. [...]
25272 52 18_Re: RTRiM Question12_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 21 Jun 2001 21:48:10 +0200383_Windows-1252 Hi, Are you calling DB2 on OS/390 ? If yes then V5 on OS/390 does not support rtrim. You should use "strip" instead.
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net ----- Original Message ----- From: "Keerthi Chegu" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, June 21, 2001 8:23 PM Subject: RTRiM Question [...]
25325 29 19_CAE and DB2 Connect11_Moore, Tony15_TMoore@IKON.COM31_Thu, 21 Jun 2001 14:59:09 -0400578_iso-8859-1 Listers, I currently have DB2 for Windows 2.1.2 (CAE) installed and I'm about to try my hand at a DB2 Connect download/install. However, before I begin, I would like to be able to successfully select some data from DB2 on OS/390 using CAE so I have something to compare against once I have DB2 Connect installed. As the DB2 OS/390 DBA (and a mainframe dinosaur), the only experience I have with CAE is troubleshooting installs and connection problems. Any-who, I'm trying to figure out how to do some simple selects from a couple of my DB2 OS/390 tables from my [...]
25355 139 39_Re: Joins between Remote & Local tables13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM31_Thu, 21 Jun 2001 13:58:09 -0500410_iso-8859-1 Another possible solution, depending on where you want to run the query from, is to use MS-Access to do the join for you. Simply attach the two tables using an ODBC driver to a client MS-Access database. Then using the query designer in MS-Access, build the query and MS-Access, using the JET Database engine, will query both tables, return the data to Access and Access will perform the join. [...]
25495 38 45_Re: How do you report a bug with Db2 Connect?18_Gert van der Kooij15_geko@WANADOO.NL31_Thu, 21 Jun 2001 21:12:56 +0200383_iso-8859-1 RE: How do you report a bug with Db2 Connect? Hi, I've seen these messages when the installer tries to install another language. Did you specify the language in your response file? When running the setup it can be specified by the '/i ' option ( '/i en' to install english). I don't know how it should be specified in your installation files, but that's up to you :) [...]
25534 219 26_Re: Another Oracle barrage11_Bill Happel22_WRHappel@US.FORTIS.COM31_Thu, 21 Jun 2001 14:30:04 -0500383_US-ASCII Now that we have defined "Dirty Reads" and "Oracle Locks", I am curious about Peter's original assessment: "The application logic needed current data. It had repetitively re-read rows to maintain currency and update others in the same table." Could this be "Pessimistic Locking" (see earlier thread titled "Pessimistic Locking")?
William R. Happel Hartford Life [...]
25754 51 23_Re: CAE and DB2 Connect13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Thu, 21 Jun 2001 14:52:21 -0500405_iso-8859-1 Tony,
2.1.2 was a long time ago, but I'm thinking it was still the same....how about running db2cmd from ....sqllib\bin and issuing a connect: DB2 CONNECT TO yourdatasource USING yourmainframeid
After supplying your mainframe password....
type: DB2 SELECT * FROM yoursmalltesttable
Your could trace it using your mainframe DB2 monitor and compare your results. [...]
25806 52 33_Off Topic - Anyone in Prague, CR?16_Brookman, Gerald30_gerald.brookman@ATOSORIGIN.COM31_Thu, 21 Jun 2001 15:50:02 -0400178_iso-8859-1 If you currently/formerly live and/or work in Prague, Czech Republic or anywhere near there, please contact me off-list. TIA.
Gerald R. (Garry) Brookman
25859 104 23_Re: CAE and DB2 Connect11_Moore, Tony15_TMoore@IKON.COM31_Thu, 21 Jun 2001 16:26:40 -0400523_iso-8859-1 Dave, Thanks for the info. I gave that a whirl, but ran into a SQL1009N which says "The command is not supported when issued on a client-only workstation or against remote databases."
Since I sent the original email, I found a means to getting something to test with though... I created a database in MS/ACCESS and linked to a table on DB2 OS/390 using ODBC and then ran the query from there. At least that'll give me something to compare to once (and if) I get DB2 Connect downloaded and installed. [...]
25964 16 30_VB Tools for DB Administration9_Tim Burke21_Tim_Burke@PEPBOYS.COM31_Thu, 21 Jun 2001 15:20:24 -0500449_- Does anyone know of any 3rd party tools, IBM tools or API calls to allow a user to change their DB2 password? Using IBM DB2 for OS/390
Any help would be greatly appreciated.
Thanks, Tim Burke
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
25981 27 42_Looking for a pure DB2 systems programmer.15_Jeff Wrightsell27_jwrightsell@RAPIDDEPLOY.COM31_Thu, 21 Jun 2001 15:53:53 -0500376_iso-8859-1 The positions I have are strictly for DB2 Systems programmers. This is not an applications job.
Location: Minneapolis, Phoenix Rate: to 90K + 10-20% bonus + up to 10k sign-on bonus
We can get feedback from our client within five minutes of sending a candidate.
Interested parties please send resume and contact number as soon as possible. [...]
26009 72 26_Re: Another Oracle barrage12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Thu, 21 Jun 2001 16:53:09 -0500577_us-ascii You have this problem with all RDBMS's in a conversational application.
First your program queries the database and displays the current data. End of the first UOW, locks released.
The user looks at the data, has some coffee, changes a row and hits enter.
Then your program wants to update the database with the user's change. If you just do the update, you might undo someone else's changes. So you now re-query the data with a SELECT FOR UPDATE, check that the data had not changed, and do the update. End of the second UOW, locks released [...]
26082 29 53_Re: Lies, More Lies, and Oracle Claims, Part 1A of VI13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Fri, 22 Jun 2001 08:34:15 +1000494_- Good stuff Phil, but are we preaching to the converted?
Is this excellent material to be made visible to non-DB2 interested parties so that they too can see the light?
Steve T
> -----Original Message----- > From: Philip Gunning [SMTP:Philip.Gunning@QUEST.COM] > Sent: Thursday, 21 June 2001 16:28 > To: DB2-L@RYCI.COM > Subject: Lies, More Lies, and Oracle Claims, Part 1A of VI > > This is a copy of an email from Mike Swift to DB2 Interested Parties. > > Phil > > [...]
26112 105 42_Re: Date of first Release of DB2 for OS39015_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Fri, 22 Jun 2001 09:22:49 +1000287_- Yeah, it is. I'm about 1/2 way through it. Like my wife, I skipped to the end to see whodunnit and found the gem about the first release of Oracle being V2. Apparently 'they figured nobody would buy V1'. The document can be hard-going but you do pick up a few gems along the way. [...]
26218 42 26_Re: Another Oracle barrage11_Grant Allen22_grant@TOWERSOFT.COM.AU31_Fri, 22 Jun 2001 09:49:34 +1000641_- Bill Happel[SMTP:WRHappel@US.FORTIS.COM] wrote: > > Now that we have defined "Dirty Reads" and "Oracle Locks", I am curious > about Peter's original assessment: "The application logic needed current > data. It had repetitively re-read rows to maintain currency and update > others in the same table." Could this be "Pessimistic Locking" (see > earlier thread titled "Pessimistic Locking")? > In my understanding, no. Pessimistic locking is the good old "Select for update ... " approach, allowing other readers, but blocking other writters until the transaction is committed. I could be wrong ... I certainly had a few cobwebs in the [...]
26261 57 32_Re: trigger qmf signal sqlstate?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 21 Jun 2001 21:51:19 -0500288_ISO-8859-1 Stephen
Apart from the change in version number, I have not been able to find a difference between QMF 3.3 and QMF 6.1. (I hope someone will lift the scales from my eyes and show me the splendour of the enhancements that were made - but I'm not holding my breath.) [...]
26319 17 20_Re: program swapping11_Mark Harmon17_mhinnyc@YAHOO.COM31_Thu, 21 Jun 2001 22:06:47 -0500448_- At one time IMS may have been the easier way to get checkpoint restart but now there a few products on the market that do more and should be easier to use. Andy didn't mention it, but BMC has such a product as does Relational Architects (Smart/RESTART). Roger Miller suggested managing the checkpoint frequency. Any checkpoint/restart product should do this, prefereably external to the application program, on the fly and/or automatically. [...]
26337 92 42_Re: Date of first Release of DB2 for OS39013_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 21 Jun 2001 22:30:01 -0500626_us-ascii Announced on June 7, 1983, went GA in April 2, 1985
Willie Favero
"Piontkowski, Michael L" wrote:
> Check out Roger Miller's message about the early days. > Very cool history lesson. > > From: Roger Miller [millerrl@US.IBM.COM] > Sent: Saturday, June 16, 2001 15:01 > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Database holy war > > If you are interested in some of the early history, we had an SQL reunion > back in 1995, with most of the historical people: Paul McJones, Roger > Bamford, Mike Blasgen, Don Chamberlin, Josephine Cheng, Jean-Jacques > Daudenarde, Shel Finkelstein, Jim Gray, [...]
26430 169 26_Re: Another Oracle barrage0_24_ujjwal@LOT.TATASTEEL.COM31_Fri, 22 Jun 2001 10:05:20 +0530541_us-ascii Hi Linda, With Oracle u have the RBS ( Rollback Segments) which is a predefined value defined when the data base is created. What happens is when the data is read from the bufferpool for update they have two components in the rollback segments 1. Undo ( Pre change Image ) 2. Changed (Post Change Image) In the UNDO component it will have the same data as in the bufferpool ie before change. So when the Update takes place it will keep updating in the Changed segment of the RBS and during this time others will not be able to [...]