1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2000, week 4
2 63 24_Stored procedures / JDBC18_De Andrade, Miguel24_miguel.deandrade@CAI.COM31_Fri, 22 Sep 2000 10:11:28 +0100180_iso-8859-1 Hi Sinead,
Get the Redbook DB2 Java Stored Procedures
Learning by Example
An excellent redbook I am finding
Cheers, Miguel de Andrade
66 120 36_SQLCODE -805 and SQLERRD(1) = '-250'12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 22 Sep 2000 12:05:26 +0200765_iso-8859-1 Hi listers.
One of our programs ran into a SQLCODE -805 (SQLSTATE 51002). That's normally an error that can be fixed immediately. But in the following case somewhat is unusual.... So I need your help...................
Here's the error: TRANSACTION: DNAW PROGRAM: DTSERVEX TASK: 0000455 APPLID: A06CICS2 DISPLAY: 00 STATUS: COMMAND EXECUTION COMPLETE CALL TO RESOURCE MANAGER DSNCSQL EXEC SQL INSERT P.AUTH=LADIVAU , S.AUTH=LADIVAAW PLAN=PLDACICT, DBRM=DTBZP997, STMT=00333, SECT=00001 SQL COMMUNICATION AREA: SQLCABC = 136 AT X'0834A150' SQLCODE = -805 AT X'0834A154' SQLERRML = 039 AT X'0834A158' SQLERRMC = '..DTBZP997.167AD0DF1B34855C,PLDACICT,03' AT X'0834A15A' SQLERRP = 'DSNXEPM' AT X'0834A1A0' SQLERRD(1-6) = -250, 000, 00000, [...]
187 50 96_Re: DB2 OS/390: DSNDB07 SORT WORK AREA. How to find the transaction / or batch job using DSNDB070_24_ujjwal@LOT.TATASTEEL.COM29_Sat, 23 Sep 2000 10:20:21 GMT415_us-ascii Hello Ed_Vetock , Check the space allocated for your SORTPOOL in DSNZPARM of your installation .Anything above 15 MB is a good value and also check the amount of space allocated for your catalog DSNDB07. With Regards Ujjal Bhattacharya
Ed_Vetock@NAVYFEDERAL.ORG@RYCI.COM> on 09/21/2000 07:44:08 PM
Please respond to DB2 Data Base Discussion List [...]
238 20 21_Cost Based Optimizer?12_Hayes, Chris19_CHRIS.HAYES@SSA.GOV31_Fri, 22 Sep 2000 07:03:27 -0400564_iso-8859-1 I was examining an access path yesterday when a thought occurred to me for which I would like your opinions. For years I have been saying that DB2 for OS/390 uses a cost based optimizer, but with the advent of parallelism, isn't it really a time based optimizer? Isn't it possible for the optimizer to choose a more CPU intensive (and thus more expensive) access path over a less CPU intensive path because parallelism will allow it to return the result set quicker? Of course even if you buy into this theory, if you also believe in the old adage [...]
259 38 40_Re: SQLCODE -805 and SQLERRD(1) = '-250'16_Friemel, Norbert24_Friemel@RRZ-KARLSRUHE.DE31_Fri, 22 Sep 2000 13:00:03 +0200472_iso-8859-1 snip > SQLERRMC = '..DTBZP997.167AD0DF1B34855C,PLDACICT,03' AT > X'0834A15A' > SQLERRP = 'DSNXEPM' AT snip > > Controlling the package version, seems okay............. > > SELECT COLLID, NAME, VERSION FROM SYSIBM.SYSPACKAGE WHERE > NAME = 'DTBZP997' > > ---------+---------+---------+---------+---------+---------+ > COLLID NAME VERSION > ---------+---------+---------+---------+---------+---------+ > DAOSSYENTW DTBZP997 2000-08-24-11.50.01.693179 > snip [...]
298 34 25_Re: DB2 Connect EE on AIX12_Rompot, Kurt26_kurt.rompot@INGRAMBOOK.COM31_Fri, 22 Sep 2000 06:01:21 -0500600_iso-8859-1 Have you tried AUTHENTICATION DCS on the CATALOG DB command? That should do the trick.
-----Original Message----- From: BOB JEANDRON [mailto:BOB.JEANDRON@USDA.GOV] Sent: Thursday, September 21, 2000 3:24 PM To: DB2-L@RYCI.COM Subject: DB2 Connect EE on AIX Sensitivity: Personal
We have the following scenario: DB2 Connect CAE on NT ===> DB2 Connect EE on AIX ===> DB2 on OS390 The only way this works is if the userid and PW is the same on the AIX box as it is on OS390. Is there a way to let AIX just be a passthru to OS390 from NT? I.e. Not require a [...]
333 27 97_Re: DB2 OS/390: DSNDB07 SORT WORK AREA. How to find the transacti on / or batch job using DSNDB0714_Clayton, Colin21_Colin_Clayton@BMC.COM31_Fri, 22 Sep 2000 06:42:05 -0500350_iso-8859-1 Hi Ed,
if you have suspects, that is a good place to start. Assuming you have bound them with Explain=Yes then examine the PLAN_TABLE for sorts. You could also display locks held on DSNDB07 at the time you get the problems. It's hit-or-miss but you might get lucky.
A good monitor would help (I could recommend one....) [...]
361 103 42_CA hosts Bonnie Baker - More free seminars14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 22 Sep 2000 13:01:43 +0100635_iso-8859-1
CA is hosting a series of Bonnie Baker seminars in November. Bonnie Baker a consultant, writer and educator specialising in DB2 application performance and tuning on the OS/390 platform, her award winning classes have been attended by thousands at technical conferences worldwide.
Bonnie will be giving the following presentations: "The best of things I wish they'd told me eight years ago" and "Little things can make a big difference" . Both sessions are designed to help both developers and DBAs gain a better understanding of DB2 and how this can lead to better program logic and SQL. Bonnie will be [...]
465 19 34_Group Buffer Pool Allocation Alter13_Johnson, Bill18_bjo23@ALLSTATE.COM31_Fri, 22 Sep 2000 07:45:19 -0500526_- All, We are trying to dynamically alter our group buffer pool (GBP32K) to increase its size.(from 512 to 1024) After issueing the alter we do a display and it stills shows the old value for the size. Any recommendations/explainations? Thanks, Bill Johnson DBA Allstate Insurance Co.
================================================ 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.
485 487 40_Re: SQLCODE -805 and SQLERRD(1) = '-250'15_Ali OZTURK(942)27_ali.ozturk@PAMUKBANK.COM.TR31_Fri, 22 Sep 2000 16:24:54 +0300415_iso-8859-1 Hi Georg,
you must check the connection token value in db2 catalog and it's value must be equal to 167AD0DF1B34855C. (it can be find this value in SQLERRMC area.)
you can use the following sql to learn the connection token value for this package.
SELECT NAME,HEX(CONTOKEN) FROM SYSIBM.SYSPACKAGE WHERE NAME = 'DTBZP997';
If they are not equal , you can check some steps. [...]
973 115 38_Re: Group Buffer Pool Allocation Alter15_Ali OZTURK(942)27_ali.ozturk@PAMUKBANK.COM.TR31_Fri, 22 Sep 2000 17:01:34 +0300668_ISO-8859-9 Hi, You should rebuild group bufferpool structure after changing size.
rebuild command is:
SETXCF START,REBUILD,STRNM=str_name,LOC=NORMAL
-----Original Message----- From: Johnson, Bill [mailto:bjo23@ALLSTATE.COM] Sent: Friday, September 22, 2000 3:45 PM To: DB2-L@RYCI.COM Subject: Group Buffer Pool Allocation Alter
All, We are trying to dynamically alter our group buffer pool (GBP32K) to increase its size.(from 512 to 1024) After issueing the alter we do a display and it stills shows the old value for the size. Any recommendations/explainations? Thanks, Bill Johnson DBA Allstate Insurance Co. [...]
1089 45 34_Re: DB2 Connect - OS/390 to Oracle27_Leon Katsnelson/Toronto/IBM15_leon@CA.IBM.COM31_Thu, 21 Sep 2000 09:40:28 -0400383_us-ascii Yes, a combination of the federated database function and DB2 Relational Connect add-on product to DB2 UDB and/or DB2 Connect will allow you to have read-only access to Oracle and DB2 data from S/390 COBOL applications. DataJoiner on the other hand provides full update capability as well.
Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com [...]
1135 52 38_Re: Group Buffer Pool Allocation Alter13_Johnson, Bill18_bjo23@ALLSTATE.COM31_Fri, 22 Sep 2000 09:32:36 -0500669_- We did the rebuild, but it still shows the original size in the display. Thanks, Bill Johnson
> -----Original Message----- > From: Ali OZTURK(942) [SMTP:ali.ozturk@PAMUKBANK.COM.TR] > Sent: Friday, September 22, 2000 10:02 AM > To: DB2-L@RYCI.COM > Subject: Re: Group Buffer Pool Allocation Alter > > Hi, > You should rebuild group bufferpool structure after changing size. > > > rebuild command is: > > SETXCF START,REBUILD,STRNM=str_name,LOC=NORMAL > > > > -----Original Message----- > From: Johnson, Bill [ ] > Sent: Friday, September 22, 2000 3:45 PM > To: DB2-L@RYCI.COM > Subject: Group Buffer Pool Allocation Alter > > > [...]
1188 193 38_Re: Group Buffer Pool Allocation Alter15_Ali OZTURK(942)27_ali.ozturk@PAMUKBANK.COM.TR31_Fri, 22 Sep 2000 17:58:51 +0300456_ISO-8859-9
ok. You should drop all connection from group bufferpool. (stop all db2 that is connected this gbp and start again.)
-----Original Message----- From: Johnson, Bill [mailto:bjo23@ALLSTATE.COM] Sent: Friday, September 22, 2000 5:33 PM To: DB2-L@RYCI.COM Subject: Re: Group Buffer Pool Allocation Alter
We did the rebuild, but it still shows the original size in the display. Thanks, Bill Johnson [...]
1382 92 42_Re: DB2 OS/390 Performance monitoring tool11_Shigang Mai16_smai@METLIFE.COM31_Fri, 22 Sep 2000 10:08:47 -0400280_us-ascii I am surprise the lack of response on this topic. Thanks Larry. You were the only one responded. Let me be more specific. Is there anyone have experience on STOBE FOR DB2 and BMC PATROL KM FOR DB2 OS/390? Larry, does IBM DB2PM offer what I listed below? Thanks all. [...]
1475 13 38_Re: Group Buffer Pool Allocation Alter13_Darrel Schumm23_dschumm@TOTALSYSTEM.COM31_Fri, 22 Sep 2000 11:30:55 -0400327_us-ascii could you show us the command you are using and display you are getting back
================================================ 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.
1489 29 33_Interactive stored procedure call15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Fri, 22 Sep 2000 11:30:39 -0400417_iso-8859-1 Can I call a stored procedure from QMF interactively?
Book manager show as follows
The CALL SQL Statement
The CALL statement is used when invoking a stored procedure.
The usage of this statement: Interactive(Yes), Embedded(Yes), Dynamic(Yes)
I am getting following error when I call it from QMF
'The statement is not valid in this database manager. ' [...]
1519 86 34_Re: DB2 Connect - OS/390 to Oracle0_19_Tim.Lowe@STPAUL.COM31_Fri, 22 Sep 2000 10:56:43 -0500900_us-ascii FYI, In case anyone has a requirement for accessing Oracle databases(or Sybase or SQL/server?) from S/390, there do appear to be options available.
"Leon Katsnelson/Toronto/IBM" on 09/21/2000 08:40:28 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: Re: DB2 Connect - OS/390 to Oracle
Yes, a combination of the federated database function and DB2 Relational Connect add-on product to DB2 UDB and/or DB2 Connect will allow you to have read-only access to Oracle and DB2 data from S/390 COBOL applications. DataJoiner on the other hand provides full update capability as well. [...]
1606 46 59_DB2-L Subscribers - Get Your Complimentary Olympic T-shirt!28_Martin Spratt/Des Moines/IBM18_sprattm@US.IBM.COM31_Fri, 22 Sep 2000 12:12:16 -0400356_us-ascii DB2-L Subscribers - Get Your Complimentary Olympic T-shirt!
To get you off to a fast start, view one of our migration Web-based seminars. They only take 20 minutes and you will get great information about migrating from Oracle, Informix, Sybase or SQL Server.
As our thank you, we will send you a complimentary Olympic T-shirt. [...]
1653 140 40_Re: SQLCODE -805 and SQLERRD(1) = '-250'11_Suresh Sane21_data_arch@HOTMAIL.COM29_Fri, 22 Sep 2000 11:18:01 CDT629_- Hi Georg,
Buried in the sqlerrm is the reason code 03 - this is a true timestamp conflict (old -818). The composition of the plan is OK (otherwise the reason code would have been 02). So you need to use the right dbrm or just repeat the process.
HTH.
Suresh
>From: "Peter, Georg" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: SQLCODE -805 and SQLERRD(1) = '-250' >Date: Fri, 22 Sep 2000 12:05:26 +0200 > >Hi listers. > >One of our programs ran into a SQLCODE -805 (SQLSTATE 51002). That's >normally an error that can be fixed [...]
1794 27 38_os/390 outbound request to udb for aix10_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 22 Sep 2000 12:45:20 -0400533_us-ascii Hi all
I'm trying to do a connect from OS/390 db2 out to a UDB for AIX box. I have update the communications database with my userid and password and have sucessfully made it to the box. I have a questions regarding access and authorization
Since I must logon on to the host using RACF, I infact have verified my authorization. I now would like to run a sql that connects to a udb for aix on a remote server. The unix box needs a userid/password to logon to. How can I set up my os/390 CDB so that anyone [...]
1822 33 29_DB2 catalog compare utilities12_HEPP SHERY C17_schepp@SRPNET.COM31_Fri, 22 Sep 2000 10:00:03 -0700343_ISO-8859-1 Fellow listers-
We are looking at the CA/Plat compare product. Are there other 3rd party vendor tools out there that provide similar functionality? We are specifically looking for something that will help manage our Peoplesoft environment- so the tool must be able to handle a large volume of objects across subsystems. [...]
1856 54 33_Re: DB2 catalog compare utilities14_Laredo, Andrew19_Andy_Laredo@BMC.COM31_Fri, 22 Sep 2000 12:09:16 -0500614_iso-8859-1 There's a little company down in Texas called BMC...take a look at Change Manager...
-----Original Message----- From: HEPP SHERY C [mailto:schepp@SRPNET.COM] Sent: Friday, September 22, 2000 1:00 PM To: DB2-L@RYCI.COM Subject: DB2 catalog compare utilities
Fellow listers-
We are looking at the CA/Plat compare product. Are there other 3rd party vendor tools out there that provide similar functionality? We are specifically looking for something that will help manage our Peoplesoft environment- so the tool must be able to handle a large volume of objects across subsystems. [...]
1911 83 33_Re: DB2 catalog compare utilities0_22_BILL_GALLAGHER@PHL.COM31_Fri, 22 Sep 2000 13:12:47 -0400609_us-ascii Shery,
We have used BMC's DB2 tools in the past, but have recently replaced them with the CA/Platinum DB2 tools. I would highly recommend BMC Change Manager over the corresponding CA tool (RC/Migrator). I always found BMC Change Manager extremely easy to use and quite powerful, especially when doing schema compares across environments . . . I find the CA/Platinum tools quite cumbersome and frustrating to use. I recently tried to do what I thought was a simple compare of a handful of tables between our test and production environments using RC/Migrator, and had to give up and do it [...]
1995 58 33_Re: DB2 catalog compare utilities9_Bob Lewis17_BLewis@ACSSYS.COM31_Fri, 22 Sep 2000 10:12:21 -0700425_iso-8859-1 Shery -
Embarcadero has a product called DB Artisan Change Manager which I believe is or will be available for the OS/390 platform. I've been trial-ing it for DB2/AIX and it's pretty impressive. Here's their website: http://www.embarcadero.com/products/products.htm
So far the product has done everything we've needed. It is significantly less expensive than the BMC/CA/Plat mainframe products. [...]
2054 85 33_Re: DB2 catalog compare utilities12_Cook, Nicole19_Nicole_Cook@BMC.COM31_Fri, 22 Sep 2000 12:34:37 -0500347_iso-8859-1 All,
BMC Software also provides a change manager tool that does everything that DB Artisan does, and much more! It provides an analysis on all changes before the script runs, schema management, and also you can compare two databases to check differences! Check them out, we support OS/390 and distributed systems (NT,UNIX). [...]
2140 18 33_Re: DB2 catalog compare utilities9_Sally Mir22_Sally.Mir@WACHOVIA.COM31_Fri, 22 Sep 2000 14:20:14 -0400312_us-ascii If you have PeopleSoft, as we do, I strongly recommend that you **don't** rely on Platinum RC/Compare. It just cannot handle the volume of objects that exist in a PS environment. If you want to discuss this further, and get specifics, feel free to e-mail me offline.
Sally Mir Wachovia Bank [...]
2159 159 42_Re: os/390 outbound request to udb for aix13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 22 Sep 2000 14:20:20 -0500384_US-ASCII Tom, Here is a possible solution. You can create a userid on the server and grant privileges that id ex. connect, select, insert, update, delete etc.
add the TYPE, LINKNAME AND NEWATHID in the sysibm.usernames
ex. O LINKNAME SERVERUSERID
If you use a blank AUTHID, All users that connect to AIX from OS/390 will get the server userid authorization. [...]
2319 15 33_Re: DB2 catalog compare utilities0_19_Tim.Lowe@STPAUL.COM31_Fri, 22 Sep 2000 15:26:33 -0500467_us-ascii In my opinion, if you have used BMC DB2 tools, then using Platinum/CA DB2 tools will feel like driving a Yugo. (At best, the ride is not comfortable, and you had better be prepared to walk. You get what you pay for.)
================================================ 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.
2335 37 33_Re: DB2 catalog compare utilities17_Herschfus, Leslee30_Leslee_Herschfus@COMPUWARE.COM31_Fri, 22 Sep 2000 16:33:38 -0400455_iso-8859-1 hey - there is a great product out there from Compuware called dba-xpert that puts bmc and ca/platinum to shame
Leslee Herschfus Leslee_Herschfus@Compuware.com Compuware Technical Support Voice: (800) 538-7822 Fax : (248) 737-7339
-----Original Message----- From: Tim.Lowe@STPAUL.COM [mailto:Tim.Lowe@STPAUL.COM] Sent: Friday, 22 September, 2000 04:27 PM To: DB2-L@RYCI.COM Subject: Re: DB2 catalog compare utilities [...]
2373 58 25_FW: DB2 Connect EE on AIX12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Fri, 22 Sep 2000 16:59:31 -0400367_iso-8859-1 Check your database manager configuration parameter: TRUST_CLNTAUTH - It should be set to SERVER instead of CLIENT (the default).
The authentication method for your server then needs to be DCS - You'll need to make DB & DCS DB catalog entries for your database on OS/390 (only on NT should likely suffice since DB2 Connect is available there). [...]
2432 85 42_FW: os/390 outbound request to udb for aix12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Fri, 22 Sep 2000 17:04:29 -0400366_iso-8859-1 One can achieve this without any entries in the CDB too.
Check your database manager configuration parameter on AIX: TRUST_CLNTAUTH - It should be set to SERVER instead of CLIENT (the default).
The authentication method for your server then needs to be DCS - You'll need to make DB & DCS DB catalog entries for your database on OS/390. [...]
2518 24 22_WLM extending lifetime11_Tom Marcano23_marcano_db2@HOTMAIL.COM29_Fri, 22 Sep 2000 22:27:14 GMT419_- Hello all,
Our production WLM store procedures application will automatically come down after an hour of no use. We need a way to extend the WLM execution time beyond 1 hour when no customers are using it. Does anyone know any way to do that?
Thanks _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. [...]
2543 25 34_COPY PENDING flag mysteriously set11_Paul Turpin22_pault704@EARTHLINK.NET31_Fri, 22 Sep 2000 21:19:13 -0500580_- We have run into a situation where a tablespace mysteriously goes into a COPY PENDING status about once a month. This has happened several times and each time we have verified that NO utilities that could normally caused a tablespace to go into COPY PENDING status have run. We checked SYSIBM.SYSCOPY for LOADs, REORGs, etc. There are no image copies registered for this particular tablespace, so I thought maybe a MODIFY utility might have caused the problem. I ruled this out by making sure the tablespace was in RW status and then I ran a MODIFY. After the MODIFY which [...]
2569 21 16_DB2 jobs inquiry9_John Dbms17_db2user@YAHOO.COM31_Fri, 22 Sep 2000 21:55:53 -0500313_- This was cross-posted on db2eug.
Is anyone aware of any good jobs in the NC, SC, or TN area working with DB2 on the Windows or UNIX platforms?. A job where the DBA gets to spend part of the time working on DB2 on OS/390 and part of the time working on DB2 on Windows or NT platforms would be ideal. [...]
2591 19 20_Re: DB2 jobs inquiry8_Bob Abad16_BobRabad@AOL.COM29_Fri, 22 Sep 2000 23:30:52 EDT488_US-ASCII Yes, John. Go to ibm.com and check out DB2 jobs opportunity. You can live anywhere, but you might have to travel to clients and perform DB2 DBA practice whether in OS/390 or UDB in NT, or AIX.....Good luck!
>( :-) Bob Abad
================================================ 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.
2611 40 20_Fw: DB2 jobs inquiry4_fred22_DB2@THERESOURCENET.COM31_Sat, 23 Sep 2000 00:09:17 -0500606_Windows-1252 For DB2 job opportunities, you should check out the Jobs links at http://theResourceNet.com/DB2.asp ----- Original Message ----- From: "John Dbms" Newsgroups: bit.listserv.db2-l To: Sent: Friday, September 22, 2000 9:55 PM Subject: DB2 jobs inquiry
> This was cross-posted on db2eug. > > Is anyone aware of any good jobs in the NC, SC, or TN > area working with DB2 on the Windows or UNIX > platforms?. A job where the DBA gets to spend part of > the time working on DB2 on OS/390 and part of the time > working on DB2 on Windows or NT [...]
2652 67 33_Fw: DB2 catalog compare utilities4_fred22_DB2@THERESOURCENET.COM31_Sat, 23 Sep 2000 00:23:06 -0500589_iso-8859-1 Shery-
check out the following page from www.bmc.com
http://www.bmc.com/technews/991/991tn6.html
excerpt from that page "PeopleSoft Applications can present difficulties when making changes to objects, trying to quickly locate information in the DB2 catalog, and monitoring and tuning SQL. BMC Software provides many products that enhance the systems management interface to the PeopleSoft environment. This article presents an overview of those products, which can enhance the availability, performance and recoverability of PeopleSoft Applications." [...]
2720 51 38_Re: COPY PENDING flag mysteriously set16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Sat, 23 Sep 2000 09:10:31 -0400728_us-ascii Hi, you might check application batch jobs that update with log no. HTH Tom F
Paul Turpin on 09/22/2000 10:19:13 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: COPY PENDING flag mysteriously set
We have run into a situation where a tablespace mysteriously goes into a COPY PENDING status about once a month. This has happened several times and each time we have verified that NO utilities that could normally caused a tablespace to go into COPY PENDING status have run. We checked SYSIBM.SYSCOPY for LOADs, REORGs, etc. There [...]
2772 57 38_Re: COPY PENDING flag mysteriously set15_Murley, Michael22_Michael_Murley@BMC.COM31_Sat, 23 Sep 2000 08:33:48 -0500448_iso-8859-1 Paul,
This is the sort of mystery for which a Log Analysis tool like BMC Logmaster for DB2* is great. You can run Logmaster looking for any deletes from SYSCOPY for this table space.
I think Modify would only put the space in COPY status if its execution deleted recovery resources that made the space unrecoverable. If there was nothing to delete, I don't think it would change the status (not 100% sure about that). [...]
2830 772 111_Central PA DB2 Users Group - Nov 1st-2nd - Bonnie Baker - Part I / II - Things I wish..... Seminars - $150 each10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Sat, 23 Sep 2000 12:20:24 -0400312_us-ascii Greetings! The Central PA DB2 Users Group is hosting Bonnie Baker on November 1st-2nd.
November 1st - Things I Wish Someone Had Told Me 8 Years Ago (Part I) November 2nd - More Things I wish They'd Told Me 8 Years Ago (Part II)
Each class is $150. Attached are the seminar abstracts. [...]
3603 113 26_Re: Convert DB2 to use SMS15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 23 Sep 2000 12:08:04 -0500630_iso-8859-1 ----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, September 20, 2000 2:46 PM Subject: Re: Convert DB2 to use SMS
> We've been using SMS with DB2 for three or four years now, we've never had > a problem with it. > > However, I did recently learn from an impromptu discussion with our > DASD/performance guy that even with RAID, placement of datasets on logical > DASD volumes could still be a bottleneck because the I/O subsystem could be > queuing on a logical device name. Even though a logical DASD device is > spread [...]
3717 142 38_Re: COPY PENDING flag mysteriously set16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Sun, 24 Sep 2000 01:39:24 +0100633_- Paul,
If you execute a MODIFY db.ts DELETE AGE(*) - then your tablespace would get into this state, so search for a situation like this.
Good hunting Steen Rasmussen Computer Associates Denmark
> -----Original Message----- > From: Paul Turpin [SMTP:pault704@EARTHLINK.NET] > Sent: 23 September 2000 04:19 > To: DB2-L@RYCI.COM > Subject: COPY PENDING flag mysteriously set > > We have run into a situation where a tablespace mysteriously goes into > a COPY PENDING status about once a month. This has happened several > times and each time we have verified that NO utilities that could normally > caused a [...]
3860 15 19_SQLSTATE vs SQLCODE7_R Holup19_rholup@MEGSINET.NET31_Sat, 23 Sep 2000 22:39:31 -0500386_- I have been testing the SQLCODE after all SQL statements in my mainframe programmings for years. I have seen some organizations testing SQLSTATE instead of the SQLCODE to make their code more portable for the different DB2's (OS/2, NT, UNIX, MF, etc.). What have your experiences been? If you have made any changes, what type of response did you get from your programming staff? [...]
3876 61 31_Re: UDB Security Group - PUBLIC14_Duncan Gardner23_dgardner@GESB.WA.GOV.AU31_Mon, 25 Sep 2000 09:51:29 +0800371_- Hi Anil,
We always revoke bindadd, connect, createtab and implicit_schema from public as soon as we create a database, then just grant the appropriate privs to the user/group. The reasoning - you've worked that out already I think. We never give a user any access unless it is specifically required. Rule No 1 of all DBAs and System Administrators I think! [...]
3938 115 34_Re: DB2 V6 Table Function in COBOL14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 25 Sep 2000 15:04:04 +1100444_iso-8859-1 Troy,
I'm reluctant to reveal the secrets of our coding :-) - and the only one we've written got written in C :-(. However, the way we've done it:
calling program: SELECT ... FROM ..., TABLE(UD_TABLE_FUNC(:arg1,:...)) AS XXX ...
Create definition: CREATE FUNCTION schema.UD_TABLE_FUNC (, ...) RETURNS TABLE ( , ... ) other options just like a non-table function [...]
4054 68 33_Links about DB2 OS/390 (09/25/00)6_DB2usa18_db2usa@HOTMAIL.COM31_Mon, 25 Sep 2000 00:50:56 -0500624_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
DB2 for OS/390 poll: Do you use Data Sharing in production ?
Last update on Monday, September 25th 2000 ==========================================
- Links about DB2 for OS/390: http://db2usa.hypermart.net/eliste.htm IBM will broadcast an e-seminar named "New DB2 OS/390 Data Management Tools" (free registration) on Friday, September 27th 2000 with Dan Wardman and David Schwartz of IBM. [...]
4123 68 38_AW: COPY PENDING flag mysteriously set12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 25 Sep 2000 08:27:07 +0200574_iso-8859-1 Paul,
check out if there was a job (LOAD, REORG etc.) executed that runs with the option LOG NO.
HTH.
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Department Product Support Compentence Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ---------------------------------------------------------------------- [...]
4192 21 19_Sharing V5 material25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG31_Mon, 25 Sep 2000 14:31:29 +0800340_us-ascii Hi,
We are in the process of upgrading to DB2 v5.1. We need to share the V5.1 application impacts and the features. Is there anybody in the group who have conducted a briefing or tech sharing on V5 features. Can you share or point to v5.1 presentation material. Appreciate if it were in the form of power point slides. [...]
4214 71 23_AW: SQLSTATE vs SQLCODE12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 25 Sep 2000 08:50:16 +0200406_iso-8859-1 As the SQLSTATE's came up (can't remember exactly - was it DB2 for MVS Version 3.1 ?) we simply changed our central SQL error handling routine that works in every (!) sql program in the same manner.
We needed to change about 11.000 dbrm's/packages at that point in time. This SQL error handling routine is a copy book that can be included in every program that needs such a routine. [...]
4286 29 18_collating sequence4_R.S.30_R.Skorupka@BREMULTIBANK.COM.PL31_Mon, 25 Sep 2000 09:26:48 +0200615_iso-8859-2 Hi everybody, I'm from Poland, and use polish national characters in my data. For proper collating sequence in SELECT ... ORDER BY char_column we must use FIELDPROC clause. This very convenient with one exception: you cannot define table (column) using both: FIELDPROC and NOT NULL WITH DEFAULT clauses. I'm wondering WHAT countries must use FIELDPROC for collating sequence ? I know about Poland, Montenegro, Ukraina, Slovenia... But I HAVE TO KNOW how it is solved in Italy, Portugal and Greece. Must they use FIELDPROC for character data ? Is there anybody from southern Europe ? Thank you in advance.
4316 145 31_Re: UDB Security Group - PUBLIC0_18_mebert@AMADEUS.NET31_Mon, 25 Sep 2000 09:47:25 +0200262_us-ascii NO. I would only revoke a right from a user if there was a very specific reason for it. After all, I'm providing a service for the user (customer), and I want to make it as good as possible. I guess this tells you I'm not working for a government. [...]
4462 16 33_James Drewe is out of the office.11_James Drewe20_James.Drewe@AEXP.COM31_Mon, 25 Sep 2000 01:08:30 -0700470_us-ascii I will be out of the office from 09/22/2000 until 10/02/2000.
I will respond to your message when I return. For I.T. assistance, please contact C.Duane Foss at 602-766-5662 or Deb Russell at 602-766-5035. Thanks!
================================================ 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.
4479 54 33_Re: DB2 catalog compare utilities12_Jesper sleth19_slethit@SLETHIT.COM31_Mon, 25 Sep 2000 02:19:15 -0700426_- Hi Shery
I will vote for BMC.
It is easy to use, and give good functionallity.
Especially in the area of version management.
You can freese your databases at certain levels, and run compare against the freesed level with the actual level. It can generate SQL to bring the database from one level to another and back again, and ballance databases from testinvironment to production and back. [...]
4534 24 33_Re: DB2 catalog compare utilities10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Mon, 25 Sep 2000 04:34:25 -0500332_- You might want to consider Princeton Softech's 'Compare for DB2'. I evaluated their products against those of some of their competitors (NB. I don't want to name them, but BMC's products were NOT given to me to evaluate), and they came out on top in terms of reliability, function and quality. The products I evaluated were: [...]
4559 29 47_Remote Ad Hoc queries killing the Db2 Subsystem12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Mon, 25 Sep 2000 09:52:37 GMT473_- Hi Folks:
I would like to hear your comments about what could be the best way to control all the Remote Ad Hoc Queries running against my db2 Subsystem. I've been thinking to use WLM as soon we migrate our OS/390 operating system. Another choice is lowing down the DB2DDF started task priority but I don't know it goes to help me much. If somebody else has experienced something similar , I would like to hear your comments about it. Thank very much, [...]
4589 51 11_SQL Tracing11_John Matear32_John.Matear@CBS-SOLUTIONS.COM.AU31_Mon, 25 Sep 2000 17:57:58 +0800481_us-ascii Hello, We currently use BMC's Activity Monitor to monitor our DB2 systems (DB2 V5). We have a requirement to get some SQL information from the monitor and have been running the appropriate traces (for example -IFCIDS 22,53,55,58-66,237,311,324). There are a number of standard SQL batch reports (detailed and summary) provided by BMC but they are going down to a level of detail that we don't really want and hence we are getting overwhelmed by the volume of output. [...]
4641 129 42_Re: DB2 OS/390 Performance monitoring tool14_Thomas, Steven21_Steven_Thomas@BMC.COM31_Mon, 25 Sep 2000 06:01:38 -0500319_iso-8859-1 If you're looking for a Performance Monitoring Tool from BMC, then you should be looking at MAINVIEW as that's the strategic product in this area. I can get you more info offline from the group if needed - just mail me direct.
Strobe is a good product, but it's not really a performance monitor. [...]
4771 61 38_Re: Group Buffer Pool Allocation Alter23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Mon, 25 Sep 2000 11:56:11 +0100332_iso-8859-1 I have read the other responses and am going to give another angle on this ..
is the SIZE value of the GBP32K higher than or equal to 1024? if it is then an Alter should be all you need. i.e there is no need for a group bufferpool rebuild as you can just move upto the value in SIZE for the GBP32K structure. [...]
4833 87 38_Re: COPY PENDING flag mysteriously set0_22_The-Thanh.Luong@AGF.BE31_Mon, 25 Sep 2000 13:30:47 +0200598_- Hi, I ran into this problem some time ago. My understanding is, when you execute a MODIFY dbname.tsname DELETE AGE(*) and there is nothing to delete (or when, after deletion, there still is a valid image copy DB2 can recover that tablespace to), then nothing happens, the tablespace does not get into CopyPend state. Whereas if all copies qualify for the delete operation, and have been deleted, it's normal that DB2 requires a new image copy and the CopyPend is set for that tablespace. I searched in our environment for the jobs launched automatically by a scheduler (Control-M) and found [...]
4921 61 96_Re: DB2 OS/390: DSNDB07 SORT WORK AREA. How to find the transaction / or batch job using DSNDB0710_John Hardy27_john_j_hardy@CONSULTANT.COM31_Mon, 25 Sep 2000 07:32:07 -0500647_- Am I missing something here? If a query blows up DSNDB07 then a 00D70014 message in the Master Address Space will give the Correlation/Connection ID. You can then look at the Accounting Trace for more info.
On Sat, 23 Sep 2000 10:20:21 GMT, ujjwal@LOT.TATASTEEL.COM wrote:
>Hello Ed_Vetock , > Check the space allocated for your SORTPOOL in DSNZPARM of your >installation .Anything above 15 MB is a good value and also check the >amount of space allocated for your catalog DSNDB07. > With Regards > Ujjal Bhattacharya > > > > >Ed_Vetock@NAVYFEDERAL.ORG@RYCI.COM> on 09/21/2000 07:44:08 PM > >Please respond to [...]
4983 16 43_Reduce size of Catalog & Directory Datasets11_Joan Keemle25_KeemleJoanT@JOHNDEERE.COM31_Mon, 25 Sep 2000 07:53:22 -0500476_- We recently freed a significant number of package versions. SYSPKAGE and SPT01 datasets are in extents. We've reorganized SYSPKAGE and SPT01, but existing datasets were of course reused since they are user-managed / vcat-defined. Now we want to create new datasets of a reduced size and get everything back into a single extent. Does anyone have a simple, reliable method for deriving required space for catalog & directory objects, in order to size down? Thanks, Joan [...]
5000 111 47_Re: Reduce size of Catalog & Directory Datasets0_18_mebert@AMADEUS.NET31_Mon, 25 Sep 2000 15:09:42 +0200323_us-ascii After REORGing the Cat/Dir TSs, you can do a LISTCAT to determine the amount of used space (HI-USED-RBA), or type LVSAM in front of the Data component (*.DSNDBD.**) in an ISPF 3.4 dataset listing (I don't know whether that's a general method or site-specific). This gives you the (minimum) size needed. Then: [...]
5112 48 51_Re: Remote Ad Hoc queries killing the Db2 Subsystem9_Bob Lewis17_BLewis@ACSSYS.COM31_Mon, 25 Sep 2000 06:21:28 -0700415_iso-8859-1 Harbry -
How about the Resource Limit Facility (DSNRLST)? Pretty slick for dynamic SQL statements. Plus you can be a bit more surgical than with WLM.
Bob Lewis
-----Original Message----- From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] Sent: Monday, September 25, 2000 4:53 AM To: DB2-L@RYCI.COM Subject: Remote Ad Hoc queries killing the Db2 Subsystem
Hi Folks: [...]
5161 157 47_FW: Reduce size of Catalog & Directory Datasets12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Mon, 25 Sep 2000 09:38:20 -0400759_iso-8859-1 For a new installation, the DB2 Installer tool assists in providing an optimal estimate for specific user requirements - Details are available at:
http://www-4.ibm.com/software/data/db2/os390/db2inst
-----Original Message----- From: mebert@AMADEUS.NET [mailto:mebert@AMADEUS.NET] Sent: Monday, September 25, 2000 9:10 AM To: DB2-L@RYCI.COM Subject: Re: Reduce size of Catalog & Directory Datasets
After REORGing the Cat/Dir TSs, you can do a LISTCAT to determine the amount of used space (HI-USED-RBA), or type LVSAM in front of the Data component (*.DSNDBD.**) in an ISPF 3.4 dataset listing (I don't know whether that's a general method or site-specific). This gives you the (minimum) size needed. Then: [...]
5319 25 23_Re: Sharing V5 material13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 25 Sep 2000 07:02:19 -0400347_iso-8859-1 Hello Srirengan, Chuck Hoover has a short book on V5 changes and features. Several of his presentations are on our web site. I don't know that the v5 book is there, but I'm confident there is v5 information there. Have a look at http://www.compuware.com/products/hoover/index.asp
You might find the Release Guide helpful at [...]
5345 28 51_Re: FW: Reduce size of Catalog & Directory Datasets0_17_JTonchick@AOL.COM29_Mon, 25 Sep 2000 09:53:03 EDT578_US-ASCII I have successfully used DSN1COPY to resize the Catalog & Directory data sets.
1) LISTCAT output to find the high used RBA, use this as base minimum for new size. 2) prepare JCL to: a) DSN1COPY to nonVSAM backup b) delete/define dataset c) DSN1COPY from backup into new sized dataset.
Of course I do this when DB2 is down for the major tablespaces. For an index dataset, I just include a step at the beginning to issue a -STOP command, then when DSN1COPY procedure is complete, a final step to -START the dataset. In either case, be careful when you [...]
5374 78 15_Re: SQL Tracing20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 25 Sep 2000 10:02:50 -0400661_us-ascii Hi John
I have an European IDUG presentation for such similar purposes "Customizing DB2 Trace Output" due next month in Geneva. There are real life problem/examples, samples and codes and building own monitor sample comprising of mainly REXX.
Send me mail directly, I could be of some help.
Regards Venkat Pillay
> -----Original Message----- > From: John Matear [SMTP:John.Matear@CBS-SOLUTIONS.COM.AU] > Sent: Monday, September 25, 2000 5:58 AM > To: DB2-L@RYCI.COM > Subject: SQL Tracing > > Hello, > We currently use BMC's Activity Monitor to monitor our DB2 systems (DB2 > V5). We have a requirement to get some SQL [...]
5453 14 35_Tom Reichardt is out of the office.0_17_treicha@SEARS.COM31_Mon, 25 Sep 2000 09:17:06 -0500365_us-ascii I will be out of the office from 09/25/2000 until 09/29/2000.
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.
5468 87 51_Re: Remote Ad Hoc queries killing the Db2 Subsystem10_Bill Disch23_bill.disch@GENMILLS.COM31_Mon, 25 Sep 2000 09:20:54 -0500572_- Harbry,
We have had excellent results using RLF. Just define your own default limits for each ad-hoc PLAN, then if exceptions are required, specify higher limits based on PLAN, USER, CONNECTION, etc. All of our ad-hoc came from DSNTEP2, DXT, ODBC, or QMF. We also had the QMF Governor implemented befor RLF was available and the two features work well together for the QMF Users. I would not recommend messing with any started task priorities. Let DB2 do its job quickly - if a user is going to exceed a CPU limit, why make them wait additional time just to [...]
5556 138 33_Re: DB2 catalog compare utilities15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Mon, 25 Sep 2000 11:09:18 -0400332_iso-8859-1 We use Platinum with PeopleSoft and have had no problem. I have used it extensively in the last year migrating one instance of peoplesoft Financials and/or HR (at release 7.5 where there are a total of 10,000 tables between the two) to a new instance. Have also used it to migrate a copy of production back to test. [...]
5695 13 19_Trigger performance14_Chris Michaels35_Christopher_A_Michaels@VANGUARD.COM31_Mon, 25 Sep 2000 10:54:21 -0400402_us-ascii In DB2 OS/390, does anyone know the performance difference between implementing DB2 RI between two tables and implementing the same RI using a Trigger?
================================================ 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.
5709 48 23_Re: Trigger performance38_Toine Michielse/Santa Teresa/Contr/IBM18_vndobtm@US.IBM.COM31_Mon, 25 Sep 2000 17:11:12 +0100500_us-ascii Hello Chris,
Not in exact numbers but RI enforcement through triggers will be a worse performer...
Regards,
Toine Michielse DB2 for OS/390 Technical Specialist Silicon Valley Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS
Chris Michaels @RYCI.COM> on 09/25/2000 03:54:21 PM
Please respond to DB2 Data Base Discussion List [...]
5758 36 23_Re: Trigger performance20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 25 Sep 2000 11:17:50 -0400728_us-ascii Chris
Not only the performance will be bad implementing RI using triggers but also, think about constraint implementation such as
- How to enforce RI, while LOADing the table having triggers? - How to enforce RI, while RECOVERing having triggers?
etc.
> -----Original Message----- > From: Chris Michaels [SMTP:Christopher_A_Michaels@VANGUARD.COM] > Sent: Monday, September 25, 2000 10:54 AM > To: DB2-L@RYCI.COM > Subject: Trigger performance > > In DB2 OS/390, does anyone know the performance difference between > implementing > DB2 RI between two tables and implementing the same RI using a Trigger? > > ================================================ > To change your subscription [...]
5795 40 23_Re: Trigger performance15_Steven Morrison33_steven.morrison@FIRSTDATACORP.COM31_Mon, 25 Sep 2000 10:37:03 -0500430_us-ascii Did some bench marks not duplicating RI but doing through a trigger what we used to do in a program and the cost was considerably higher about 17%.
Chris Michaels cc: Sent by: DB2 Data Base Subject: Trigger performance Discussion List
09/25/2000 09:54 AM Please respond to DB2 Data Base Discussion List [...]
5836 14 47_John P. Schulting/FIS/CMG is out of the office.17_John P. Schulting29_john.schulting@CUNAMUTUAL.COM31_Mon, 25 Sep 2000 10:42:56 -0500365_us-ascii I will be out of the office from 09/25/2000 until 10/01/2000.
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.
5851 86 96_Re: DB2 OS/390: DSNDB07 SORT WORK AREA. How to find the transaction / or batch job using DSNDB0713_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Mon, 25 Sep 2000 11:34:17 -0500334_iso-8859-1 John,
I've seen cases where the abending process was a victim, due to space being used by a 'hog(s?)' (i.e. reason codes 00c900a5 and 00c90084). Having a dis db command issued automatically when these situations occur is helpful in determining what was going on in the workfiles at the time.
Thanks Dave [...]
5938 208 33_Re: DB2 catalog compare utilities12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 25 Sep 2000 19:58:28 +0200349_iso-8859-1 RE: [DB2-L] DB2 catalog compare utilitiesHi, AFAIK if you have P99C tape installed and the parmlib for Migrator has the new option (called "Use Fulltree Build" (default is YES) - if I remember correctly) then your performance should be nearly twicw as fast as before and handle big lists as well. . Isaac Yassin DBMS & IT Consultant [...]
6147 31 42_Re: DB2 OS/390 Performance monitoring tool12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 25 Sep 2000 12:18:16 -0500404_- DB2 PM does have what you asked for. It is very closely coordinated with DB2 and makes it easy to use the latest version. I'd suggest a couple of pointers.
For the larger tool set: ibm.com/software/data/db2imstools/
For DB2 PM ibm.com/software/data/dbtools/
The DB2 PM books can be browsed or downloaded from the same page as DB2: ibm.com/software/data/db2/os390/v6books.html [...]
6179 19 44_DB2 access through S/390 Domino Web Server ?14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Mon, 25 Sep 2000 10:14:29 -0700342_us-ascii I'd like to hear from people who are doing this in a production environment entirely on S/390 through USS. Perhaps there is a better forum, but I'll start here. I am looking at the potential of doing it on a limited basis but want to glean any 'pearls of wisdom' from those who have more experience. Are you out there? TIA, Roy [...]
6199 75 23_Re: Trigger performance16_Richard A Yevich21_ryevich@BELLSOUTH.NET31_Mon, 25 Sep 2000 12:20:47 -0400407_iso-8859-1 Declaring Rules for DB2 to process in the engine will always be faster than your user code, especially when it comes to Triggers. Triggers are fast but not as fast as declarative RI and Table Check Constraints.
Simple rule: 1 - Declarative RI first 2 - Triggers only it DCL RI cannot handle it 3 - Table Check Constraints first for validation 4 - Triggers only if CC cannot handle it [...]
6275 33 42_Upgrading from UDB v6.1 to UDB v7.1 on AIX0_22_BILL_GALLAGHER@PHL.COM31_Mon, 25 Sep 2000 14:00:31 -0400452_us-ascii Hi,
We are looking to upgrade to UDB v7.1 on AIX probably within the next two months or so. UDB v6.1 was our first installation in this environment. We have applied a couple of fixpacks to v6.1, but have not yet done a full upgrade to UDB.
I'm wondering if anybody can shed some light on how involved a full upgrade is as compared to a fixpack installation. Is it basically the same steps, or is there more to it than that? [...]
6309 38 48_Re: DB2 access through S/390 Domino Web Server ?0_14_mtdage@ATT.NET31_Mon, 25 Sep 2000 18:58:37 +0000326_- We have our Unix System Services on a separate LPAR and we call it our WEBS LPAR and we use Net.Data to access some of our DB2 tables that reside on another OS/390 LPAR. Applications accessing DB2 data are Intranet type applications.
So far it has been working well. Email me offline if you need some more info. [...]
6348 63 51_Re: Remote Ad Hoc queries killing the Db2 Subsystem11_Hans Selman26_hans.selman@NL.ABNAMRO.COM31_Mon, 25 Sep 2000 14:14:05 -0500610_- On Mon, 25 Sep 2000 06:21:28 -0700, Bob Lewis wrote:
>Harbry - > >How about the Resource Limit Facility (DSNRLST)? Pretty slick for dynamic >SQL statements. Plus you can be a bit more surgical than with WLM. > >Bob Lewis > >-----Original Message----- >From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] >Sent: Monday, September 25, 2000 4:53 AM >To: DB2-L@RYCI.COM >Subject: Remote Ad Hoc queries killing the Db2 Subsystem > > > Hi Folks: > > > I would like to hear your comments about what could be the best way >to control all the Remote Ad Hoc Queries running against my db2 [...]
6412 15 26_Re: Insert performance doc7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Mon, 25 Sep 2000 14:20:19 -0500379_- Dave,
This is a great document. Do you, by any chance, know of a similar discussion for the UDB/EEE on AIX platform?
Amir
================================================ 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.
6428 26 14_Max SQL length12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Mon, 25 Sep 2000 15:28:02 -0400361_us-ascii Hi everyone,
We have a large tablespace definition (252 partitions) which in 'neat form' goes way past the 33016 byte limit that DSNTIAUL sets for the max input value. I guess I could pack the definition together to make a more compact, but unreadable form. Do I have any other options ? (other than keeping a packed and an unpacked copy). [...]
6455 94 51_Re: Remote Ad Hoc queries killing the Db2 Subsystem12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Mon, 25 Sep 2000 14:42:10 -0500332_- DB2/V6 on OS390 also is supposed to have a Predictive Governor that works like RLF but won't let the query start. I haven't gotten that far yet, but I currently use RLF and fully intend to test and use predictive govenor when I get to V6.
Carol Sutfin Corporate DBA AmSouth Bank N.A. (205)326-5214 csutfin@amsouth.com [...]
6550 77 70_Repost: "Virtual" sessions from IDUG North America 2000 now avail able13_Morrill, John12_JohnM@VP.NET31_Mon, 25 Sep 2000 14:49:28 -0600353_- Dear DB2 Interested Parties,
Below is a bulletin from the International DB2 Users Group (IDUG) regarding availability of Webcasts (presentation slides with synchronized speaker audio) of the IBM keynote, IBM spotlight, and IBM panel sessions at this year's IDUG North American conference that took place in Dallas last May. Check 'em out! [...]
6628 227 42_Repost: IBM Announcement on Database Tools13_Morrill, John12_JohnM@VP.NET31_Mon, 25 Sep 2000 14:50:55 -0600731_- Dear DB2 Interested Parties,
Today IBM launched a major new initiative to compete in the database tools market. The announcement introduces new products, enhances existing products, offers migration support, as well as financing alternatives to further shape IBM's Data Management portfolio. IBM Data Management Tools address the most common database requirements of DB2 and IMS users including Database Administration to service and support database operations, Performance management and performance utilities to operate at peak performance, Recovery and Replication Management including archival, image copy, and point in time recovery and Database Application Management tools for cost effective data management. [...]
6856 131 64_Repost: Webcasts on DB2 for OS/390 and IMS Data Management Tools13_Morrill, John12_JohnM@VP.NET31_Mon, 25 Sep 2000 14:52:51 -0600336_- Dear DB2 Interested Parties,
More information on the specific DB2 for OS/390 and IMS data management tools announced on September 12 will be available via next week. Also available is a rebroadcast of the September 14 Webcast, "Strategies and Alternatives for Managing ISV Costs of S/390 Software". See below for details. [...]
6988 50 18_Re: Max SQL length22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 25 Sep 2000 16:47:08 -0400710_iso-8859-1 How about using DSNTEP2 for DDL?
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] Sent: Monday, September 25, 2000 15:28 To: DB2-L@RYCI.COM Subject: [DB2-L] Max SQL length
Hi everyone,
We have a large tablespace definition (252 partitions) which in 'neat form' goes way past the 33016 byte limit that DSNTIAUL sets for the max input value. I guess I could pack the definition together to make a more compact, but unreadable form. Do I have any other options ? (other than keeping a packed and an unpacked copy). [...]
7039 31 34_Group Buffer Pool Allocation Alter23_Mary Petras/Norwalk/IBM19_marypetr@US.IBM.COM31_Mon, 25 Sep 2000 16:26:25 -0400455_us-ascii A structure is allocated based on the INITSIZE in the CFRM policy - say it is 1000. Then after the command, SETXCF START,ALTER is issued with a SIZE of 2000, the structure deallocates, and for the next allocation of the structure, we use the INITSIZE.
If you want to keep the ALTERed size, then this requires an update to the CFRM policy. If a new policy is started, then the structure sizes reflect the defined sizes in that policy! [...]
7071 24 35_Fix pack 5 Error - UDB V6.1 for AIX5_Manas25_manas.dasgupta@PFSFHQ.COM31_Mon, 25 Sep 2000 17:48:40 -0400437_iso-8859-1 Has anyone had any problems with Fix Pack 5 of UDB V6.1.?
We just upgraded 2 of our AIX boxes to Fix Pack 5 and we are getting -805 on package NULLID.SQLL7C0W.3741744D534D4A51 when we call a OS390 stored procedure via DB2 Connect from Java/jdbc code in AIX.
The package SQLL7C0W does exist in OS/390 DB2 but with a different contoken. We did do the ddcsmvs.lst bind and thats what created SQLL7C0W package. [...]
7096 24 13_Database Copy14_busayo adebayo15_bayo9@YAHOO.COM31_Mon, 25 Sep 2000 15:06:40 -0700583_us-ascii Hi everybody,
How can I create a copy of a database on a machine from another machine.
Both machine are on the same network and they are both running NT. Thanks
__________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
7121 127 44_Re: implementing physical db using case tool14_Michael Finnis28_MFinnis@PRINCETONSOFTECH.COM31_Mon, 25 Sep 2000 18:43:11 -0400362_ISO-8859-1 Hello Rick,
Re your comment about vendors picking up on generating DDL for Grants (highlighted below). Princeton Softech have done a fair amount of work on the Server Builder component of Select SE (System Engineer) over the last couple of years. Much of this was concerned with keeping up to date with DB2 (and Oracle) database versions. [...]
7249 36 43_Oracle-to-DB2 and DB2-to-Oracle performance17_Belfield, Alma G.15_AGBELFI@TWA.COM31_Mon, 25 Sep 2000 18:18:58 -0500412_iso-8859-1 We considering moving an application from a DB2 OS/390 mainframe to an Oracle UNIX (probably HP) machine. The problem is that after the move, other mainframe applications will still need real-time OLTP access to some of the data that's been moved to Oracle. And the application that's been moved will still need real-time OLTP access to some of the data that still lives in DB2 on the mainframe. [...]
7286 55 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM31_Mon, 25 Sep 2000 16:21:27 -0700702_iso-8859-1 Why, if the data is co-dependent, are you considering moving to Oracle? Just curious?
Wayne Kline Sr. DBA Ingram Micro
-----Original Message----- From: Belfield, Alma G. [mailto:AGBELFI@TWA.COM] Sent: Monday, September 25, 2000 4:19 PM To: DB2-L@RYCI.COM Subject: Oracle-to-DB2 and DB2-to-Oracle performance
We considering moving an application from a DB2 OS/390 mainframe to an Oracle UNIX (probably HP) machine. The problem is that after the move, other mainframe applications will still need real-time OLTP access to some of the data that's been moved to Oracle. And the application that's been moved will still need real-time OLTP access to some of the [...]
7342 98 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Mon, 25 Sep 2000 19:10:06 -0500603_us-ascii We have used the Oracle Transparent Gateway to DRDA since 1994.
1) Transparent is a one-way mirror. The gateway makes DB2 tables look like Oracle tables in an Oracle distributed database. You use Oracle tools and Oracle SQL. 2) All Oracle SQL functions are available. Where DB2 has the equivalent function, the function request is passed to DB2. When the Function is not available in DB2, the data is retrieved and 'post applied' within the gateway. 3) Since you are writing Oracle SQL, you cannot use DB2 functions that do not have an Oracle equivalent. 4) DB2 performance via the [...]
7441 66 31_Re: Fix pack 5 Error - UDB V6.130_CHRISTOPHER.KELLER@Vereinte.de30_CHRISTOPHER.KELLER@VEREINTE.DE31_Tue, 26 Sep 2000 08:05:00 +0200496_iso-8859-1 --- Received from BG1.KELLERC 6785-2761 26-09-00 08.05 --------------------------------------------------------------------------------------------------------------
-> DB2-L@RYCI.COM
Hello, Not AIX but yesterday I came up with this problem with FP5 for V6 Personal Edition running under NT 4.0 SP5. Upgraded from V5.2 FP 11 to V6 and then applied FP5. Haven't really examined it yet, and don't have time at the moment, so I can't really say where the problem lies. [...]
7508 56 48_Re: DB2 access through S/390 Domino Web Server ?60_=?iso-8859-1?Q?F=E8lix?= Ventosa =?iso-8859-1?Q?Franqu=E9s?=19_fventosaf@MENTA.NET31_Tue, 26 Sep 2000 08:13:52 +0200577_iso-8859-1 Why offline? How will I learn about it then??
Please, don't be so shy. We all are interested in this discussions.
Thanks.
Félix Ventosa
mtdage@ATT.NET escribió:
> We have our Unix System Services on a separate LPAR and > we call it our WEBS LPAR and we use Net.Data to access > some of our DB2 tables that reside on another OS/390 > LPAR. Applications accessing DB2 data are Intranet type > applications. > > So far it has been working well. Email me offline if you > need some more info. > > OS/390 2.7 > DB2 UDB for [...]
7565 81 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance17_Michael Mc Morrow25_michael.g.mcmorrow@AIB.IE31_Tue, 26 Sep 2000 10:58:47 +0100699_ISO-8859-1 Another solution would be to use some generic middleware technology such as MQ Series....Application services could be developed on the mainframe and unix platforms so that, for instance, a mainframe/DB2 application could send a request for data via MQ to a unix/oracle application service....Some benefits: (1) both sets of applications are totally independent and blissfully unaware of each other's underlying technology making future changes to either side very flexible (2) probably eliminates shipping irrelevent data as the application services can return exact answers....Some drawbacks: (1) you need to buy the middleware and learn that technology (2) each application is an [...]
7647 68 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 26 Sep 2000 06:22:38 -0500388_- Yes. Without wishing to offend our UNIX/ORACLE colleagues (I'm sure nobody wants a rehash of the "our platform/database is better than yours" debate) it seems like a fairly drastic measure. Usually one I've seen suggested by software vendors or consultants, and often ending in tears....
On Mon, 25 Sep 2000 16:21:27 -0700, Kline, Wayne wrote: [...]
7716 67 49_(Repost) DB2-OS/390 and Oracle/HP-UX Connectivity14_Romeo B Titong26_rbtitong@ACISYSTEMS.COM.PH31_Tue, 26 Sep 2000 19:30:11 +0800341_us-ascii Hi All!
(This mail was posted last week but it did not reach my mailbox so I'm sending it again. Hope someone could help.)
I will be connecting DB2 on OS/390 to Oracle on HP-UX for a particular client. I still don't have the exact details (e.g. versions) of the OS and applications, but I badly need your advise. [...]
7784 72 41_Why should DB2 for OS/390 be so strict???11_?????? ????24_dimokap@INTERAMERICAN.GR31_Tue, 26 Sep 2000 14:39:30 +0300582_- Hello List,
i am testing a DB2 UDB V6 for NT apllication , on the DB2 V5 for OS/390 platform. I have made a copy of the UDB database at the mainframe and i am binding and running the programs through DB2 Connect.Part of the application is running ok,but a problem arises when i try to bind a certain program. I issue the following command from the Command Center with which i am binding the programs at the DB2 for OS/390 : ---------------------------------------------------------------------------- ---------- connect to db2T(=host subsystem) user .... using ...... [...]
7857 54 18_Re: Max SQL length12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 26 Sep 2000 07:49:52 -0400672_us-ascii With DSNTEP2, the maximum input is controlled by the variable MAXARRAY. It is set at 32760 which makes it less than DSNTIAULs 33016 bytes.
Piontkowski Michael ML wrote:
> How about using DSNTEP2 for DDL? > > Mike Piontkowski > Voice/Fax: 302.886.4612 > mailto:michael.piontkowski@astrazeneca.com > > -----Original Message----- > From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] > Sent: Monday, September 25, 2000 15:28 > To: DB2-L@RYCI.COM > Subject: [DB2-L] Max SQL length > > Hi everyone, > > We have a large tablespace definition (252 partitions) which in 'neat form' > goes way > past the 33016 byte limit that DSNTIAUL sets for [...]
7912 108 45_Re: Why should DB2 for OS/390 be so strict???19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 26 Sep 2000 06:54:41 -0500437_ISO-8859-1 Popy, -815 A GROUP BY OR HAVING CLAUSE IS IMPLICITLY OR EXPLICITLY SPECIFIED IN AN EMBEDDED SELECT STATEMENT OR A SUB-QUERY OF A BASIC PREDICATE
Explanation: An embedded SELECT statement or a sub-query of a basic predicate either (1) directly contains a GROUP BY or HAVING clause, or (2) specifies as its object a view having a definition that includes a GROUP BY or HAVING clause. Neither construct is permitted. [...]
8021 31 28_UDB/NT and Hummingbird Genio23_DePratti, Roland A H07A25_Roland.DePratti@CIGNA.COM31_Tue, 26 Sep 2000 07:57:01 -0400565_us-ascii The Data Warehouse efforts in our division have started work with the Extract Tool, Hummingbird Genio. The warehouse DBMS at this point in time is UDB/NT 6.1 with it eventually moving up to the Unix flavor of DB2. Has anyone worked with this tool and UDB? I am especially interested in any hard learnings people have had in tweeking either the tool or UDB so the two products work well together. The tool has a repository that it uses to maintain the extraction/cleansing rules. That will also be on UDB/NT, so there will be a couple of places that I [...]
8053 83 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 26 Sep 2000 07:01:10 -0500609_ISO-8859-1 Alma, I agree with Wayne and John -- why move this data and app to Oracle/UNIX with the data codependences? Sounds like a political rather than technical issue/opportunity (hehe) -- has everyone considered this in light of Oracle's current bent on self-destruction . . .
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received [...]
8137 88 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Tue, 26 Sep 2000 07:54:05 -0400483_iso-8859-1 Doesn't DB2 UDB 7.1 allow you to create Federated databases, giving you access to multiple platforms - DB2 OS/390, DB2 UDB & Oracle (if you have DB2 Relational Connect)? The source of the data is transparent - Check out this concept, it is really cool!
-----Original Message----- From: John Hardy [mailto:john_j_hardy@CONSULTANT.COM] Sent: Tuesday, September 26, 2000 7:23 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Oracle-to-DB2 and DB2-to-Oracle performance [...]
8226 42 51_Re: Remote Ad Hoc queries killing the Db2 Subsystem11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Tue, 26 Sep 2000 08:15:23 -0400424_iso-8859-1 Look at the Thread Stopper and Thread Sentry product from Relational Architects. These are much more powerful than RLF and can also monitor resources other than CPU (on static SQL too).
http://www.relarc.com/Threads.htm
-----Original Message----- From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] Sent: Monday, September 25, 2000 5:53 AM Subject: Remote Ad Hoc queries killing the Db2 Subsystem [...]
8269 132 45_Re: Why should DB2 for OS/390 be so strict???10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 26 Sep 2000 08:21:43 -0500511_- It's not that DB2 for OS/390 is being 'strict': your query would run as a piece of dynamic SQL on OS/390 just as well as it does on NT. There are however, rules defining what you can and cannot do in EMBEDDED SQL, and your query breaches them. The theory is that a singleton SELECT can only return one row, and GROUP BY and HAVING imply more than one row in the result set (as does ORDER BY, which is also not permitted). You might know that the result set will consist of only one row in this case, but [...]
8402 11 45_Re: Why should DB2 for OS/390 be so strict???10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 26 Sep 2000 08:37:00 -0500383_- Please disregard my point about the unique index, which was irrelevant: this particular query could quite clearly only ever return one row.
================================================ 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.
8414 81 18_Re: Max SQL length22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 26 Sep 2000 09:52:37 -0400547_iso-8859-1 Ohhh. I learned something new. Have you found a solution besides packing?
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] Sent: Tuesday, September 26, 2000 7:50 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Max SQL length
With DSNTEP2, the maximum input is controlled by the variable MAXARRAY. It is set at 32760 which makes it less than DSNTIAULs 33016 bytes. [...]
8496 90 18_Re: Max SQL length12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 26 Sep 2000 10:14:23 -0400675_us-ascii Not yet. One possible option is to modify DSNTIAUL to create a temporary packed copy of the tablespace create and pass that on to be processed.
It seems like a lot of work for just one SQL and my assemblier is kind of rusty....
Martin.
Piontkowski Michael ML wrote:
> Ohhh. I learned something new. Have you found a solution > besides packing? > > Mike Piontkowski > Voice/Fax: 302.886.4612 > mailto:michael.piontkowski@astrazeneca.com > > -----Original Message----- > From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] > Sent: Tuesday, September 26, 2000 7:50 > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Max SQL length > > [...]
8587 52 37_Re: A few questions on DB2 UDB on AIX13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 26 Sep 2000 10:15:07 -0400587_us-ascii Jizhong, No one seems to have answered your (very good!) question on encryption. Did anyone respond to it privately? One of our applications also has a need to encrypt some data.
> -----Original Message----- > From: J. Wang [SMTP:Jizhong_Wang@EMAIL.WHIRLPOOL.COM] > Sent: Thursday, September 07, 2000 11:40 AM > To: DB2-L@RYCI.COM > Subject: A few questions on DB2 UDB on AIX > > Hi all, > > after being Oracle DBA for many years, I am recently involved with DB2 UDB > on > AIX platform and having many basic questions (even after taking an IBM > fast > track class [...]
8640 104 18_Re: Max SQL length15_Narasim Narayan24_Narasim_Narayan@GLIC.COM31_Tue, 26 Sep 2000 10:22:18 -0400501_us-ascii I took the easy way out.. let the defaults( of priqty ,secqty,free page etc ..) and later do Alters
Piontkowski Michael ML on 09/26/2000 09:52:37 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Narasim Narayan/TheGuardian)
Subject: Re: Max SQL length
Ohhh. I learned something new. Have you found a solution besides packing? [...]
8745 33 45_Re: Why should DB2 for OS/390 be so strict???12_Grant Mackay28_Grant_Mackay@PROGRESSIVE.COM31_Tue, 26 Sep 2000 10:24:13 -0400749_us-ascii The following should also work.
select max(rel_pol_num) , max(rel_anan_num) , max(rel_pr_num) , max(rel_net_prim) INTO :RELIAB-REL-POL-NUM, :RELIAB-REL-ANAN-NUM, :RELIAB-REL-PR-NUM, :RELIAB-REL-NET-PRIM from ( SELECT REL_POL_NUM, REL_ANAN_NUM, REL_PR_NUM, SUM(REL_NET_PRIM) as rel_net_prim FROM RELIAB WHERE REL_POL_NUM = :RELIAB-REL-POL-NUM AND REL_ANAN_NUM = :RELIAB-REL-ANAN-NUM AND REL_PR_NUM = :RELIAB-REL-PR-NUM GROUP BY REL_POL_NUM, REL_ANAN_NUM, REL_PR_NUM
) as result
================================================ 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.
8779 44 45_Re: Why should DB2 for OS/390 be so strict???10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 26 Sep 2000 09:34:10 -0500767_- The Messages and Codes manual says that you can't issue an embedded Select against a view including a GROUP BY or HAVING clause. I would have expected that this would include inline views(?)
On Tue, 26 Sep 2000 10:24:13 -0400, Grant Mackay wrote:
>The following should also work. > > >select max(rel_pol_num) >, max(rel_anan_num) >, max(rel_pr_num) >, max(rel_net_prim) >INTO :RELIAB-REL-POL-NUM, > :RELIAB-REL-ANAN-NUM, > :RELIAB-REL-PR-NUM, > :RELIAB-REL-NET-PRIM >from ( SELECT REL_POL_NUM, > REL_ANAN_NUM, > REL_PR_NUM, > SUM(REL_NET_PRIM) as rel_net_prim > FROM RELIAB > WHERE REL_POL_NUM = :RELIAB-REL-POL-NUM AND > REL_ANAN_NUM = :RELIAB-REL-ANAN-NUM AND > REL_PR_NUM = :RELIAB-REL-PR-NUM > GROUP BY [...]
8824 46 14_DB2-L meeting?15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Tue, 26 Sep 2000 16:37:11 +0200420_iso-8859-1 Hello all,
Will you be joining next IDUG conference in Geneva? Maybe it's nice to meet the Sunday before in the Noga Hilton or during the Conference? It would be nice to actually meet the people who are contributing to the DB2-Listserver..
Kind regards,
Jaap Slot
* F 0031 (0)30 215 2220 * Mobile 0031 (0)6 5374 0167 * H 0031 (0)30 696 1948 * [...]
8871 31 18_Re: Max SQL length13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 26 Sep 2000 10:41:10 -0400387_iso-8859-1 Hi Martin, I remember last year or prior there was a discussion of DSNTEP2 and alternatives some of them written in COBOL. Search the archives. You might find one which gives you some flexibility or where the source is available for your own tailoring.
Note that even in v6, the max SQL statement length is still 32765 -- I presume that's after DB2 strips blanks. [...]
8903 44 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 26 Sep 2000 09:41:00 -0400616_- We use Oracle Procedural gateway to access OS/390 DB2 and IDMS data via CICS from Oracle on UNIX. It has performed well to this point. I believe this topic, at least in part, was discussed earlier. Check the archives.
>>> DB2-L@RYCI.COM@inter2 09/25/00 06:18PM >>> We considering moving an application from a DB2 OS/390 mainframe to an Oracle UNIX (probably HP) machine. The problem is that after the move, other mainframe applications will still need real-time OLTP access to some of the data that's been moved to Oracle. And the application that's been moved will still need real-time OLTP access to [...]
8948 108 18_Re: Max SQL length12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 26 Sep 2000 10:43:33 -0400631_us-ascii That's a good idea!
Kind of ironic that IBM supports large objects but doesn't have the means to fully create them in one statement!
Martin.
Narasim Narayan wrote:
> I took the easy way out.. let the defaults( of priqty ,secqty,free page etc ..) > and later do Alters > > Piontkowski Michael ML on 09/26/2000 > 09:52:37 AM > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: (bcc: Narasim Narayan/TheGuardian) > > Subject: Re: Max SQL length > > Ohhh. I learned something new. Have you found a solution > [...]
9057 157 23_ASCII and CHR functions8_Lo, Mary17_mary.lo@TGSLC.ORG31_Tue, 26 Sep 2000 10:03:12 -0500335_iso-8859-1 I am in the process of porting a UDB database on NT to OS/390. I am stuck with a trigger using ASCII and CHR functions to convert between the base36 alphanumeric characters and their corresponding integer values from a Net.data application on NT. I found DB2 on mainframe doesn't have build-in ASCII and CHR functions. [...]
9215 120 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Tue, 26 Sep 2000 09:25:04 -0600467_iso-8859-1 Alma,
I agree with Rick, on Oracle. If you follow the DB2-L you probably saw an article a few days ago about the cost of using Oracle. They now bill on Universal Power Unit (UPU). One of the examples I saw was a customer wanted to use Oracle on a $30k Sun Solaris box. The CIO was a bit "agast" when he recieved a bill for $135,000.00 (US Dollars)for the use of Oracle. As Rick mentioned, Oracle is "on a roll" to price itself out of business. [...]
9336 192 31_Re: UDB Security Group - PUBLIC10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 26 Sep 2000 10:36:24 -0500279_- Sorry, but I think that a lot of us would agree with Duncan: government or not. Your native might be friendly, but you probably wouldn't want him tinkering with the engine of your Porsche if he's never seen under the bonnet (that's 'hood' in American!) of a car before ;) [...]
9529 17 26_VM <-> AS/400 Connectivity13_Jeff Jennings25_Jeff_Jennings@FSAFOOD.COM31_Tue, 26 Sep 2000 08:40:58 -0700414_us-ascii I am trying to allow the use of the DBS utility and ISQL from VM on an AS/400. Chapter 15 of the V6 SysAdmin VM manual discusses running something(???) on the AS/400 to create the 'DB2 Server fro VM system catalog tables'. It does NOT specify what that something is! I do have a PMR with IBM to resolve this issue, but am hoping that someone on this list already knows the answer. TIA for your help. [...]
9547 48 31_Re: UDB Security Group - PUBLIC0_18_mebert@AMADEUS.NET31_Tue, 26 Sep 2000 17:52:23 +0200412_us-ascii 1. I would, under supervision (the more they know, the easier my job becomes). And he's more likely to ask first - instead of trying to bypass me - if he suspects the answer won't be "No". 2. It's not my Porsche, it's HIS - I'm just the mechanic. Easy to forget, that. 3. But obviously there is no right or wrong answer, just a difference in attitude towards customers - so let's leave it at that. [...]
9596 67 48_Re: DB2 access through S/390 Domino Web Server ?0_14_mtdage@ATT.NET31_Tue, 26 Sep 2000 15:53:01 +0000516_- Not sure if the additional info needed would be geared towards DB2 or Unix System Services(USS).
OK, I will post it here next time.
Thanks for letting me know.
Mayflor > Why offline? > How will I learn about it then?? > > Please, don't be so shy. We all are interested in this discussions. > > Thanks. > > Félix Ventosa > > > mtdage@ATT.NET escribió: > > > We have our Unix System Services on a separate LPAR and > > we call it our WEBS LPAR and we use Net.Data to access > > some of our [...]
9664 227 31_Re: UDB Security Group - PUBLIC15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Tue, 26 Sep 2000 17:56:27 +0200427_iso-8859-1 I guess dr Ebert and Duncan are both right about the issue. It's only a matter of opinion (seems a lot like ACF2 or RACF). They both work for a specific customer.
Just my opinion.
Jaap Slot
-----Oorspronkelijk bericht----- Van: John Hardy [mailto:john_j_hardy@CONSULTANT.COM] Verzonden: dinsdag 26 september 2000 17:36 Aan: DB2-L@RYCI.COM Onderwerp: Re: UDB Security Group - PUBLIC [...]
9892 248 31_Re: UDB Security Group - PUBLIC10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 26 Sep 2000 11:06:06 -0500659_- Different strokes for different folks. Let's be good DBAs, and say 'it depends'. :):):):):):):):)
On Tue, 26 Sep 2000 17:56:27 +0200, Slot, JP (Jaap) wrote:
>I guess dr Ebert and Duncan are both right about the issue. >It's only a matter of opinion (seems a lot like ACF2 or RACF). >They both work for a specific customer. > >Just my opinion. > >Jaap Slot > > >-----Oorspronkelijk bericht----- >Van: John Hardy [mailto:john_j_hardy@CONSULTANT.COM] >Verzonden: dinsdag 26 september 2000 17:36 >Aan: DB2-L@RYCI.COM >Onderwerp: Re: UDB Security Group - PUBLIC > > >Sorry, but I think that a lot of us would [...]
10141 157 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance17_Belfield, Alma G.15_AGBELFI@TWA.COM31_Tue, 26 Sep 2000 11:49:13 -0500422_iso-8859-1 Gentlemen, You know how these things happen..... While I said we were 'moving' an application it would be more accurate to say we are replacing an existing in-house-written application with a vendor package. Business Users require enhanced application functionality as soon as possible if not immediately. Vendor package is a good match but is only available on Unix/Oracle and will need to be integrated. [...]
10299 107 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 26 Sep 2000 12:51:05 -0400619_iso-8859-1 Another option is IBM's Data Joiner. It's designed for 2 way updates.
Like others have said though if the data is that tightly coupled, then why move the data to another platform? Politics. There are many options to access DB2 for OS/390 data from S/390 platforms.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Michael Mc Morrow [mailto:michael.g.mcmorrow@AIB.IE] Sent: Tuesday, September 26, 2000 5:59 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Oracle-to-DB2 and DB2-to-Oracle performance [...]
10407 205 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 26 Sep 2000 20:05:06 +0200484_iso-8859-1 Hi, I wonder how the application works on SUN machines with all those memory problems ... ;-))
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "Belfield, Alma G." Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, September 26, 2000 6:49 PM Subject: Re: Oracle-to-DB2 and DB2-to-Oracle performance [...]
10613 19 18_Re: Max SQL length12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 26 Sep 2000 12:02:57 -0500326_- The SQL statement comes in a varchar format, which is defined as a signed half word counter and then the text, up to 32K. The limit in the other programs just reflects this maximum size for input. If you have questions about limits, the Limits appendix of the SQL Reference spells most of them out, including this one. [...]
10633 106 48_Re: DB2 access through S/390 Domino Web Server ?12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 26 Sep 2000 20:13:25 +0200257_windows-1255 Hi, We have an LPARs with USS (one on OS/390 v2.4 and the other 2.8). Both can access DB2 V5.1 PROD data (still on 2.4 on the way to 2.8 and DB2 V6.1). Access is done via WEB browser (IE5) and executed either by CAF (C & PL1) or REXX-SQL. [...]
10740 31 26_September 26 announcements12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 26 Sep 2000 12:28:37 -0500381_ISO-8859-1 There are several announcements today that might be interesting for DB2 users.
IBM COBOL for OS/390 & VM V2R2 becomes available on Friday, Sept. 29. It includes 31 digit decimal support, a new COMP-5 data type and the ability to use DB2 precompiler services. The first two come in DB2 V5 and up with APAR PQ35280. The precompiler services deliver in DB2 V7. [...]
10772 203 27_Re: ASCII and CHR functions15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Tue, 26 Sep 2000 13:32:23 -0400533_iso-8859-1 Mary,
Since you're talking triggers, is it safe to assume that you're porting to DB2 version 6 for OS/390?
If so, take a look at the TRANSLATE scalar function, I believe it will do quite nicely, and is even easier than using the ASCII and CHR functions.
If not, you may get stuck creating a FIELDPROC, which will probably need to be written in IBM Assembler. The trick here is to determine whether or not you're converting to ASCII or EBCDIC characters. The translations for each are as follows: [...]
10976 253 27_Re: ASCII and CHR functions10_Paul Wendt14_PaulW@ENET.COM31_Tue, 26 Sep 2000 10:34:41 -0700542_us-ascii Typos in the EBCDIC values, should actually be the following...
(Paul Wendt)
Characters base36 ASCII EBCDIC ----------+-----------+-----------+----------- 0..9 x'00..x'09 x'30..x'39 x'f0..x'f9 A..I x'0a..x'13 x'41..x'49 x'c1..x'c9 J..R x'14..x'1d x'4a..x'52 x'd1..x'd9 S..Z x'1e..x'27 x'53..x'5a x'e2..x'e9
"Blaney, Bill L." To: DB2-L@RYCI.COM Subject: Re: ASCII and CHR functions Sent by: DB2 Data Base Discussion List [...]
11230 73 47_FW: Oracle-to-DB2 and DB2-to-Oracle performance11_Jakobs, Jef18_jjakobs@HARTIC.COM31_Tue, 26 Sep 2000 13:32:22 -0500325_iso-8859-1 Such a gateway has some limitations... I only have some experience querying DB2 from the Oracle side. What I remember (for example), is that when the Oracle side has a query with a join in it for the db2 OS/390 database, it pulls all the tables completely across the network, and then does the join itself... [...]
11304 21 30_Re: September 26 announcements13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 26 Sep 2000 14:36:10 -0400526_iso-8859-1 Roger, You neglected to mention the obvious DB2 announcement:
IBM DB2 Universal Database and IBM DB2 Connect, Version 7.1, Can Now Be Built-to-Order Announcement 200-322
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.
11326 36 49_Automatic rebind causing errors in DB2 v6 - HELP!15_Tjader, Polly A20_patjader@EASTMAN.COM31_Tue, 26 Sep 2000 14:56:30 -0400457_iso-8859-1 Our shop has had DB2 for many years, but we have done very little development or maintenance in the last few years. A table change was made this morning which caused automatic rebinds of several plans/packages, and we are getting the following error:
DSNX200I -PDSN REBIND SQL ERROR USING PRODDB AUTHORITY PLAN=(NOT APPLICABLE) DBRM=PDM6540 STATEMENT=5632 SQLCODE=-104 SQLSTATE=42601 TOKENS=WS-ACT-ID.: CSECT NAME=DSNHSMS1 RDS CODE=0 [...]
11363 20 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 26 Sep 2000 14:06:01 -0500543_us-ascii Just a quick guess - are you host variables missing the colon?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Steve Grimes Washington University Information Systems OS/390 V2R6 DB2 UDB 6.1 W: 314-935-4376 H: 636-928-5005 Isa.64:6 Steve_Grimes@aismail.wustl.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11384 51 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!13_OConner, John26_John.OConner@COURTS.WA.GOV31_Tue, 26 Sep 2000 12:06:42 -0700622_ISO-8859-1 Just a guess (since you didn't include much information), but it looks like you may have a host variable without a ":" preceding it.
-----Original Message----- From: Tjader, Polly A [mailto:patjader@EASTMAN.COM] Sent: Tuesday, September 26, 2000 11:57 AM To: DB2-L@RYCI.COM Subject: Automatic rebind causing errors in DB2 v6 - HELP!
Our shop has had DB2 for many years, but we have done very little development or maintenance in the last few years. A table change was made this morning which caused automatic rebinds of several plans/packages, and we are getting the following error: [...]
11436 49 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!12_HEPP SHERY C17_schepp@SRPNET.COM31_Tue, 26 Sep 2000 12:06:11 -0700545_ISO-8859-1 Have you verified the host variables have a : in front of them?
-----Original Message----- From: Tjader, Polly A [mailto:patjader@EASTMAN.COM] Sent: Tuesday, September 26, 2000 11:57 AM To: DB2-L@RYCI.COM Subject: Automatic rebind causing errors in DB2 v6 - HELP!
Our shop has had DB2 for many years, but we have done very little development or maintenance in the last few years. A table change was made this morning which caused automatic rebinds of several plans/packages, and we are getting the following error: [...]
11486 63 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!36_Enarson, Mike (CC-Database Services)24_Mike.Enarson@CONAGRA.COM31_Tue, 26 Sep 2000 14:08:45 -0500376_iso-8859-1 Polly, just a thought, but if the DBRM was compiled before version 2.3 and the colon ":" was not used for the host variables then the rebind will fail. The solution is to manually bind the plan. This is documented in the version 6 Release Guide.
OTOH is is possible that the owner of the plan (PRODDB) does not have bind authority anymore on this plan? [...]
11550 54 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Tue, 26 Sep 2000 15:12:07 -0400403_us-ascii Polly,
(1) -104 is a syntax error. I'd look at statement 5632 as a possible culprit. In addition, I believe DB2 V6 started enforcing the use of a colon to designate a host variable; you may want to look closer there.
(2) What table change was made?
Ed
"Tjader, Polly A" @RYCI.COM> on 09/26/2000 02:56:30 PM [...]
11605 87 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!15_Tjader, Polly A20_patjader@EASTMAN.COM31_Tue, 26 Sep 2000 15:19:19 -0400490_iso-8859-1 See, I knew you all were good! I hate that I'm so rusty on DB2 now. There is no colon in the SQL in the program. I didn't even THINK to look for that!
There is a possibility that this DBRM was compiled before version 2.3.
BTW, the table change I made was adding a date column that was 'not null with default'. I knew this would cause rebinds, but DB2 has run so smoothly around here for so long that I thought we should have a little excitement! Just kidding. [...]
11693 27 16_RESTORE REDIRECT29_Hamar =?iso-8859-1?Q?B=E9la?=23_bela.hamar@LHSYSTEMS.HU31_Tue, 26 Sep 2000 21:49:54 +0200549_us-ascii Hello,
I'm trying to restore a database into a new one with container redirection (on DB2 UDB for Windows). The SET TABLESPACE CONTAINERS ... command requires the tablespace-id (integer), not the tablespace-name, which I don't like very much... Could someone tell me, how can I extract the tablespace-id's from the backup image? The LIST HISTORY command lists only the tablespace names. The current state of the database (LIST TABLESPACES) can be misleading, because the tablespaces may have been dropped, new ones created etc. [...]
11721 53 20_FW: RESTORE REDIRECT12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Tue, 26 Sep 2000 16:02:06 -0400734_iso-8859-1 Issue the following commands in sequence:
* db2 list tablespaces show detail * db2 list tablespace containers for
-----Original Message----- From: Hamar Béla [mailto:bela.hamar@LHSYSTEMS.HU] Sent: Tuesday, September 26, 2000 3:50 PM To: DB2-L@RYCI.COM Subject: RESTORE REDIRECT
Hello,
I'm trying to restore a database into a new one with container redirection (on DB2 UDB for Windows). The SET TABLESPACE CONTAINERS ... command requires the tablespace-id (integer), not the tablespace-name, which I don't like very much... Could someone tell me, how can I extract the tablespace-id's from the backup image? The LIST HISTORY command lists only the tablespace names. The current [...]
11775 28 31_Concurrent copy shrlevel change11_Deb Hellard20_debmac82@HOTMAIL.COM29_Tue, 26 Sep 2000 20:22:30 GMT353_- Hi all,
According to the DB2/OS390 manuals, concurrent copy shrlevel CHANGE is NOT supported for tablespaces with pages > 4K. However, concurrent copy shrlevel REFERENCE IS supported for these tablespaces.
I also got the impression that it is not even valid to migrate a tablespace with 32K pages to a different volume using DFDSS. [...]
11804 131 47_Re: Oracle-to-DB2 and DB2-to-Oracle performance22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 26 Sep 2000 16:52:30 -0400509_iso-8859-1 It should have said
There are many options to access DB2 for OS/390 data from non-S/390 platforms.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
-----Original Message----- From: Piontkowski Michael ML Sent: Tuesday, September 26, 2000 12:51 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Oracle-to-DB2 and DB2-to-Oracle performance
Another option is IBM's Data Joiner. It's designed for 2 way updates. [...]
11936 17 25_Oracle OS390 announcement12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 26 Sep 2000 16:02:00 -0400433_- Just listened to an Oracle dog + pony...sounds like they are seriously going after the OS/390 market. They also said they will have a max of 32000 active users with their OSDI Oracle databases on OS/390. From the discussion, it seems that there is a dynamic address space capability based on workload. Sounds like automatic data sharing with multiple engines being allocated dynamically. Can someone from IBM respond to this? [...]
11954 175 42_Re: os/390 outbound request to udb for aix10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 26 Sep 2000 16:58:27 -0400345_us-ascii
Kurt I'm trying what you gave me with the following results.
-30082, ERROR: CONNECTION FAILED FOR SECURITY REASON 17 (UNSUPPORTED FUNCTION)
the version of udb for aix is DB2 v5.2.0 The version of 0s/390 is v5.
What do i need on the aix box or what version do i need in order to support the connection? [...]
12130 68 35_Re: Concurrent copy shrlevel change38_Toine Michielse/Santa Teresa/Contr/IBM18_vndobtm@US.IBM.COM31_Tue, 26 Sep 2000 23:04:55 +0100416_us-ascii Hello Deb,
The way I understand it:
The reason is to avoid possible inconsistencies.. When you use concurrent copy shrlevel change then DFdss is doing copies at tracklevel with track level serialization. With 4K pages that's not a problem. But if you have 32K pages then a page can span tracks. So track level serialization is not good enough to guarantee consistency within such a page. [...]
12199 49 35_Re: Concurrent copy shrlevel change16_Cunningham, Bill23_Bill_Cunningham@BMC.COM31_Tue, 26 Sep 2000 16:13:27 -0500426_iso-8859-1 This is just a somewhat informed guess but I believe it is because concurrent copy is implemented by calling the MVS data mover (DFDSS) under the covers. This process does not know about DB2 and reads the data straight from disk. If this occurred in the middle of a DB2 write operation they might pick up a header page block at one level with actual data blocks that are still from before the write completes. [...]
12249 94 29_Re: Oracle OS390 announcement24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Tue, 26 Sep 2000 17:33:53 -0700715_us-ascii
See the article at http://www.vnunet.com/News/1111572
Frank
On Tue, 26 Sep 2000 16:02:00 -0400, BOB JEANDRON wrote:
>Just listened to an Oracle dog + pony...sounds like they are seriously going >after the OS/390 market. They also said they will have a max of 32000 active >users with their OSDI Oracle databases on OS/390. From the discussion, it >seems that there is a dynamic address space capability based on workload. >Sounds like automatic data sharing with multiple engines being allocated >dynamically. Can someone from IBM respond to this? > >Thanks in advance. > >================================================ >To change your subscription options or to cancel [...]
12344 231 42_Re: os/390 outbound request to udb for aix13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 26 Sep 2000 16:46:21 -0500367_US-ASCII Hello Tom, I ran into this error also a while back 1) Non end-user SQLCODE returned from DBM. SQLCA is as follows: SQLCODE=-30082/ SQLERRM=17 UNSUPPORTED FUNCTION I believe I fixed a type-o error in the CDB to resolve this problem. If your still having problems contact me offline. Kurt
>>> ttaylor@CHUBB.COM 09/26/00 03:58PM >>> [...]
12576 30 29_Re: Oracle OS390 announcement11_Jon Nolting18_nolting@AMDAHL.COM31_Tue, 26 Sep 2000 14:34:26 -0700586_us-ascii Just found this article in my inbasket. http://www.wsrn.com/apps/news/art.xpl?id=786940&f=NEWS
At 04:02 PM 9/26/00 -0400, you wrote: >Just listened to an Oracle dog + pony...sounds like they are seriously going >after the OS/390 market. They also said they will have a max of 32000 active >users with their OSDI Oracle databases on OS/390. From the discussion, it >seems that there is a dynamic address space capability based on workload. >Sounds like automatic data sharing with multiple engines being allocated >dynamically. Can someone from IBM respond to this? [...]
12607 86 35_FW: Concurrent copy shrlevel change12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Tue, 26 Sep 2000 18:08:54 -0400303_iso-8859-1 Can you please elaborate on your statement "if you have 32K pages then a page can span tracks" - On a 3380 or 3390 DASD, a track exceeds 32K ... so, if insufficient free space was available in the first place, then the respective space allocation would not have been possible initially. [...]
12694 60 29_Re: Oracle OS390 announcement12_Dallas Wacha18_dwacha@NEONSYS.COM31_Tue, 26 Sep 2000 17:05:45 -0500594_us-ascii Dallas Wacha@NEON 09/26/2000 05:05 PM
After reading the article at wsrn I suspect Oracle will be throwing in a free clapper in attempt to woo potential customers!!
Jon Nolting on 09/26/2000 04:34:26 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Dallas Wacha/Dev/Neon)
Subject: Re: Oracle OS390 announcement
Just found this article in my inbasket. http://www.wsrn.com/apps/news/art.xpl?id=786940&f=NEWS [...]
12755 85 39_Re: FW: Concurrent copy shrlevel change14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Tue, 26 Sep 2000 15:15:59 -0700402_iso-8859-1 32K pages can span tracks because all DB2 I/O is done in 4K pages, so a 32K tablespace actually consists of series of 8 contiguous 4K pages. Because these 4K pages are written out individually, it is possible that the 8 pages will be on two different tracks on the device. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
12841 113 39_Re: FW: Concurrent copy shrlevel change22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 26 Sep 2000 18:20:08 -0400348_iso-8859-1 I think a 32K page is allocated as 8 4K pages. So I suppose its possible for a 32K page to be allocated on more than one track.
Do a LISTCAT on the underlying VSAM cluster of a 32K page tablespace and the CISIZE should be 4K.
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com [...]
12955 133 62_Repost: "Oracle users priced out by licence hike" (VNUnet.com)13_Morrill, John12_JohnM@VP.NET31_Tue, 26 Sep 2000 16:26:48 -0600607_- Dear DB2 Interested Parties,
Some of you might be interested in the article below that ran last week in VNUnet.com, a Web-based IT news service in the U.K., stating Oracle has come under fire by its customers for its "impossible" license fees. VNUnet.com cites GartnerGroup and META Group, independent analyst firms, saying they are now recommending DB2 UDB to clients due to the high license fees for Oracle. META Group has written that DB2 UDB is from three to five times cheaper in many enterprise environments. (Reference the bulletin I sent you on August 28 about this META Group report, [...]
13089 121 24_Repost: Fact vs. Fiction13_Morrill, John12_JohnM@VP.NET31_Tue, 26 Sep 2000 16:27:35 -0600315_- Dear DB2 Interested Parties,
There is lots of junk information out in the marketplace. Sometimes someone takes the time to provide some facts to address fictional claims that are being propagated. The set below came across my desk today, so I thought that I'd pass them on to you for what it's worth. [...]
13211 80 29_Re: Oracle OS390 announcement9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Tue, 26 Sep 2000 16:17:05 -0600456_iso-8859-1 That free clapper should come in different colors because, based on their latest pricing scheme a license for 32,000 users should be somwhere in the neighborhood of $500,000,000.00 US dollars (boy, these politics get bigger all of the time)..
-----Original Message----- From: Dallas Wacha [mailto:dwacha@NEONSYS.COM] Sent: Tuesday, September 26, 2000 3:06 PM To: DB2-L@RYCI.COM Subject: Re: Oracle OS390 announcement [...]
13292 44 78_Repost: LinuxWorld review: "IBM's DB2 Universal Database 7.1 for Linux Shines"13_Morrill, John12_JohnM@VP.NET31_Tue, 26 Sep 2000 16:31:13 -0600540_- Dear DB2 Interested Parties,
The LinuxWorld Web site contains a review that declares "IBM's DB2 Universal Database 7.1 for Linux Shines". The whole story can be found below, and at http://www.linuxworld.com/linuxworld/lw-2000-09/lw-09-db2.html.
"IBM's DB2 is probably the most mature DBMS on the market," writes reviewer Uche Ogbuji, who added that IBM provides "real, solid bases for businesses looking at Linux for critical tasks." He also praised IBM for its contributions to Linux and having the fastest Linux JDK. [...]
13337 73 29_Re: Oracle OS390 announcement12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 27 Sep 2000 09:28:30 +1100540_- Interesting article! Might have to dust off the old Oracle skills ! ;-)
BUT :-
1) Data Sharing also gives us 24 x 7 not just scalability, I believe Oracle on OS/390 is still deficient in this area. Unless they are looking and Oracle-Plexing Oracle instances across LPARS? 2) I still believe that Oracle does not have the strength of DB2's monitoring and Utility toolset. Although this is sasid with a reasonable degree of ignorance over what Oracle actually does have on the Mainframe. Anybody out there actually know? [...]
13411 39 39_FW: FW: Concurrent copy shrlevel change12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Tue, 26 Sep 2000 18:37:10 -0400554_iso-8859-1 Thanks - I've understood this process now.
-----Original Message----- From: Wayne Driscoll [mailto:Wayne.Driscoll@QUEST.COM] Sent: Tuesday, September 26, 2000 6:16 PM To: DB2-L@RYCI.COM Subject: Re: FW: Concurrent copy shrlevel change
32K pages can span tracks because all DB2 I/O is done in 4K pages, so a 32K tablespace actually consists of series of 8 contiguous 4K pages. Because these 4K pages are written out individually, it is possible that the 8 pages will be on two different tracks on the device. [...]
13451 53 17_FW: Database Copy12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Tue, 26 Sep 2000 18:54:31 -0400681_iso-8859-1 Yes, this can be readily done -I've included a small ***sample script*** below which achieves this:
db2 RESTORE DATABASE picprd FROM D:\dbt TAKEN AT 20000906011032 INTO pictst1 REPLACE EXISTING REDIRECT WITHOUT PROMPTING db2 SET TABLESPACE CONTAINERS FOR 0 USING (PATH 'C:\DB\DB2Data\pictst1\SYSCATSPACE') db2 SET TABLESPACE CONTAINERS FOR 1 USING (PATH 'C:\DB\DB2Data\pictst1\TEMPSPACE1') db2 SET TABLESPACE CONTAINERS FOR 2 USING (PATH 'C:\DB\DB2Data\pictst1\USERSPACE1') db2 SET TABLESPACE CONTAINERS FOR 3 USING (FILE 'C:\DB\DB2Data\pictst1\PI_LUK' 80000) db2 RESTORE DATABASE picprd CONTINUE db2 ROLLFORWARD DATABASE pictst1 COMPLETE db2 DISCONNECT ALL [...]
13505 38 29_Re: Oracle OS390 announcement12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 26 Sep 2000 18:20:01 -0500336_- This is my opinion, not necessarily that of my manager or my employer. We have very little information at the present time. So we start with what we know and can read. I would not be surprised to find an error later. We have an initial response or two, as noted earlier, at http://www.wsrn.com/apps/news/art.xpl?id=786940&f=NEWS [...]
13544 33 18_Re: DB2-L meeting?14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 26 Sep 2000 21:15:49 -0400519_ISO-8859-1 Jaap, I'll be in Geneva. My schedule is quite full between doing my presentation on Monday, and having to be in the vendor booth for 3 days. Hope we'll get a chance to say hello...
Regards, Joel Goldstein
Message text written by DB2 Data Base Discussion List >Will you be joining next IDUG conference in Geneva? Maybe it's nice to meet the Sunday before in the Noga Hilton or during the Conference? It would be nice to actually meet the people who are contributing to the DB2-Listserver.. [...]
13578 75 45_Re: Why should DB2 for OS/390 be so strict???11_?????? ????24_dimokap@INTERAMERICAN.GR31_Wed, 27 Sep 2000 09:26:43 +0300599_iso-8859-7 No views are being used in my program....
> ---------- > From: John Hardy[SMTP:john_j_hardy@CONSULTANT.COM] > Reply To: DB2 Data Base Discussion List > Sent: Ôñßôç, 26 Óåðôåìâñßïõ 2000 5:34 ìì > To: DB2-L@RYCI.COM > Subject: Re: Why should DB2 for OS/390 be so strict??? > > The Messages and Codes manual says that you can't issue an embedded Select > against a view including a GROUP BY or HAVING clause. I would have > expected > that this would include inline views(?) > > > On Tue, 26 Sep 2000 10:24:13 -0400, Grant Mackay > wrote: > > >The [...]
13654 122 45_Re: Why should DB2 for OS/390 be so strict???14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM31_Wed, 27 Sep 2000 17:55:47 +1100335_iso-8859-7 John was referring to inline views or Nested Table Expressions (NTEs) as proposed in Glenn's response.
Glenn is correct, this does work. The rule regarding GROUP BY & HAVING only applies to the outer query, or an NTE coded where the optimizer performs a NTE (view) merge. In Glenn's case, the NTE is not merged. [...]
13777 90 18_AW: DB2-L meeting?12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 27 Sep 2000 09:01:58 +0200619_iso-8859-1 Hi Jaap,
it might be a good idea to have a meeting point for the DB2-Listers in Geneva. Can the IDUG European Conference Planning Committee manage this ?
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Department Product Support Compentence Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ---------------------------------------------------------------------- [...]
13868 47 16_RESTORE REDIRECT29_Hamar =?iso-8859-1?Q?B=E9la?=23_bela.hamar@LHSYSTEMS.HU31_Wed, 27 Sep 2000 11:10:49 +0200561_us-ascii Hello Nadir,
thank you for your answer. But my problem is, that LIST TABLESPACES lists the current state of the database, while I need the list of the tablespace id's *in the backup image*.
Consider the following scenario:
(Database db1 has 5 tablespaces: the usual three (SYSCATSPACE, TEMPSPACE1, USERSPACE1), and TS1, TS2.)
backup db db1 to d:\backup ... connect to db1 drop tablespace ts1 drop tablespace ts2 commit ... list tablespaces --> displays SYSCATSPACE, TEMPSPACE1, USERSPACE1 and their id's disconnect db1 [...]
13916 84 45_Re: Why should DB2 for OS/390 be so strict???10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Wed, 27 Sep 2000 04:27:56 -0500641_ISO-8859-1 I know. I was addressing Grant's proposed solution to your problem, which used an inline view.
On Wed, 27 Sep 2000 09:26:43 +0300, ?????? ???? wrote:
>No views are being used in my program.... > >> ---------- >> From: John Hardy[SMTP:john_j_hardy@CONSULTANT.COM] >> Reply To: DB2 Data Base Discussion List >> Sent: Ôñßôç, 26 Óåðôåìâñßïõ 2000 5:34 ìì >> To: DB2-L@RYCI.COM >> Subject: Re: Why should DB2 for OS/390 be so strict??? >> >> The Messages and Codes manual says that you can't issue an embedded Select >> against a view including a GROUP BY or HAVING clause. I would [...]
14001 110 29_Re: Oracle OS390 announcement13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Wed, 27 Sep 2000 08:40:02 +0100713_iso-8859-1 Folks
Oracle on OS390 is like a fairy story ----- Grim(m)!!!!!!!
Ian McDonald Abbey National
-----Original Message----- From: Cianci, Nick [mailto:Nick.Cianci@TEAM.TELSTRA.COM] Sent: Tuesday 26 September 2000 11:29 PM To: DB2-L@RYCI.COM Subject: Re: Oracle OS390 announcement
Interesting article! Might have to dust off the old Oracle skills ! ;-)
BUT :-
1) Data Sharing also gives us 24 x 7 not just scalability, I believe Oracle on OS/390 is still deficient in this area. Unless they are looking and Oracle-Plexing Oracle instances across LPARS? 2) I still believe that Oracle does not have the strength of DB2's monitoring and Utility toolset. [...]
14112 32 27_Substr function in Group by13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Wed, 27 Sep 2000 08:00:37 -0400512_us-ascii Hello , I have a query which uses a 'substr' in the group by , like :
select substr(colz,5,2) , count(*) from tableA where colx = '123' and coly = 'abc' group by substr(colz,5,2)
This query is not user written , but generated by MBI ( a Hummingbird reporting tool ) and passed on to DB2 . We have moved from UDB/Unix - V5 to DB2/OS390 - V5 . On UDB , the query ran fine , but gave an error on mainframe because the 'substr' in not allowed on the group by clause . We took care of the [...]
14145 58 35_Re: Concurrent copy shrlevel change11_Deb Hellard20_debmac82@HOTMAIL.COM29_Wed, 27 Sep 2000 12:07:38 GMT645_- Thank you and everybody else who responded.
Deb
>-----Original Message----- >From: Cunningham, Bill [mailto:Bill_Cunningham@bmc.com] >Sent: Tuesday, September 26, 2000 5:13 PM >To: DB2-L@ryci.com >Subject: Re: Concurrent copy shrlevel change > > >This is just a somewhat informed guess but I believe it is because >concurrent copy is implemented by calling the MVS data mover (DFDSS) under >the covers. This process does not know about DB2 and reads the data >straight from disk. If this occurred in the middle of a DB2 write >operation >they might pick up a header page block at one level with actual data blocks >that are [...]
14204 79 20_FW: RESTORE REDIRECT12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Wed, 27 Sep 2000 09:50:52 -0400553_iso-8859-1 Please try this out (as I haven't done so) to see if this helps:
* db2 backup db tablespace ... (there's an online option too)
-----Original Message----- From: Hamar Béla [mailto:bela.hamar@LHSYSTEMS.HU] Sent: Wednesday, September 27, 2000 5:11 AM To: DB2-L@RYCI.COM Subject: RESTORE REDIRECT
Hello Nadir,
thank you for your answer. But my problem is, that LIST TABLESPACES lists the current state of the database, while I need the list of the tablespace id's *in the backup image*. [...]
14284 136 18_Re: DB2-L meeting?15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Wed, 27 Sep 2000 15:52:14 +0200485_iso-8859-1 Peter,
Last year at the IDUG in Nice there were special tables at the lunch area for DB2-L members. It wasn't very well attended, so this year the CPC decided not to repeat this service. However, if there are enough people we might 'unofficially' meet. In order to get some idea of the number of interested people is why I'm asking around this early. We can get together at the reception on Monday or in the Noga Hilton on the Sunday previous to the conference. [...]
14421 19 25_EXCP count versus DB2 IOs9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM31_Wed, 27 Sep 2000 15:05:30 +0100297_us-ascii I am trying to establish the correlation between the # of EXCPs and the # of DB2 I/Os. For example, I have a batch job with an EXCP count of 650, and an Accounting trace for the job showing 1521 Synchronous Reads and 125 Dynamic prefetch requests. Can anyone explain the difference? [...]
14441 92 29_Re: Oracle OS390 announcement17_Sanfilippo, David35_David.Sanfilippo@ANHEUSER-BUSCH.COM31_Wed, 27 Sep 2000 09:11:57 -0500667_- In addition to DB2 v5, we run Oracle v7 on OS/390 as well as several other platforms. While the performance of Oracle on the mainframe is acceptable, the monitoring, utilities, recoverability, and administration options in general are light years behind what is available for DB2.
Dave Sanfilippo david.sanfilippo@anheuser-busch.com
> -----Original Message----- > From: Cianci, Nick [SMTP:Nick.Cianci@TEAM.TELSTRA.COM] > Sent: Tuesday, September 26, 2000 5:29 PM > To: DB2-L@RYCI.COM > Subject: Re: Oracle OS390 announcement > > Interesting article! Might have to dust off the old Oracle skills ! ;-) > > BUT :- > > 1) Data Sharing also gives us [...]
14534 119 20_FW: RESTORE REDIRECT12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Wed, 27 Sep 2000 10:28:03 -0400957_iso-8859-1 I've attached a sample output when I issued the "db2 list history backup all for db " command ... We're getting the container IDs for all the tablespaces (prefixed before the name - TEMPSPACE1 is not backed up):
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID -- --- ------------------ ---- --- ------------ ------------ -------------- R D 20000917191606001 F D 20000917185211 --------------------------------------------------------------------------- Contains 8 tablespace(s): 00001 SYSCATSPACE 00002 USERSPACE1 00003 PI_FLD 00004 PI_INX1 00005 PI_INX2 00006 PI_LD 00007 PI_LUK 00008 PI_RES --------------------------------------------------------------------------- Comment: DB2 RESTORE PICPRD WITH RF Start Time: 20000917191606 End Time: 20000917191811 --------------------------------------------------------------------------- 00001 Location: F:\DB\DB2Bckup\PICPRD.0\DB2\NODE0000\CATN0000\20000917 [...]
14654 170 18_Re: DB2-L meeting?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 27 Sep 2000 10:27:02 -0400584_iso-8859-1 I am not very sure of Sunday but Monday seems better for me.
-Venkat Pillay
> -----Original Message----- > From: Slot, JP (Jaap) [SMTP:J.P.Slot@RF.RABOBANK.NL] > Sent: Wednesday, September 27, 2000 9:52 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2-L meeting? > > Peter, > > Last year at the IDUG in Nice there were special tables at the lunch area > for DB2-L members. It wasn't very well attended, so this year the CPC > decided not to repeat this service. > However, if there are enough people we might 'unofficially' meet. In > order > to get some idea [...]
14825 40 29_Re: EXCP count versus DB2 IOs20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 27 Sep 2000 10:30:03 -0400590_us-ascii Stan
There is no relation because I/O for DB2 is done by DBM1 address-space and is not done by your batch program address-space so it will never show up as EXCP on your job output. Better way to look for DB2 I/O is to use accounting traces.
Regards Venkat Pillay
> -----Original Message----- > From: Stan Hoey [SMTP:stan_hoey@CIRCLE-DL2.COM] > Sent: Wednesday, September 27, 2000 10:06 AM > To: DB2-L@RYCI.COM > Subject: EXCP count versus DB2 IOs > > I am trying to establish the correlation between the # of EXCPs and the # > of DB2 I/Os. For example, I [...]
14866 146 29_AW: Oracle OS390 announcement12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 27 Sep 2000 16:31:12 +0200370_iso-8859-1 >> monitoring, utilities, recoverability, and administration options in general are light years >> behind what is available for DB2.
David,
that and exactly that is my experience too. Only one example: The first time I saw "rollback segments" I thought that cannot be true... Fortunately we are now a pure DB2 for OS/390 company........... [...]
15013 202 18_AW: DB2-L meeting?12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 27 Sep 2000 16:33:17 +0200558_iso-8859-1 Jaap, Venkat and all other interested listers,
let's try to meet at the reception on monday.
With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Department Product Support Compentence Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ---------------------------------------------------------------------- [...]
15216 20 29_Re: EXCP count versus DB2 IOs9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM31_Wed, 27 Sep 2000 15:48:45 +0100443_us-ascii Venkat,
the SQL is processed in the MSTR address space, but the TCB time x-charged to the allied agent. Class 2 TCB time is included in Class 1 TCB. Why not the IOs as well?
Stan
================================================ 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.
15237 41 29_Re: EXCP count versus DB2 IOs20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 27 Sep 2000 11:13:26 -0400437_us-ascii A SQL is not really processed by the MSTR alone but various functions of the SQL operation are done by DBM1 / MSTR & IRLM address spaces (some times DIST & SP address-spaces).
I am not sure, what are the operational difficulties involved in charging back the I/O to allied address-space. The IBM person, who designed this may have thought of it. There are no public accessible documents available to highlight this. [...]
15279 102 29_Re: EXCP count versus DB2 IOs14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Wed, 27 Sep 2000 08:22:18 -0700423_iso-8859-1 Stan, This is a function of how MVS handles accounting information. Execution time done by a cross-memory requestor in a separate address space is charged to the requestor. However, all I/O requests get charged back to the address space driving the I/O, in this case the xxxMSTR address space. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
15382 127 29_Re: Oracle OS390 announcement23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 27 Sep 2000 16:51:10 +0100450_iso-8859-1 Yes - anybody that worked on both like I have knows that Oracle should be avoided.
I made a big decision 5 years back to go with a more reliable, scalable , interesting platform and I have never looked back!
Leslie
-----Original Message----- From: Sanfilippo, David [mailto:David.Sanfilippo@ANHEUSER-BUSCH.COM] Sent: Wednesday, September 27, 2000 3:12 PM To: DB2-L@RYCI.COM Subject: Re: Oracle OS390 announcement [...]
15510 108 46_Re: CA hosts Bonnie Baker - More free seminars13_Carol Robbins18_CJRobbins@FHSC.COM31_Wed, 27 Sep 2000 12:24:44 -0400655_US-ASCII of course, which one can I go to??? ha
>>> Phil.Grainger@CA.COM 09/22/00 08:01AM >>>
CA is hosting a series of Bonnie Baker seminars in November. Bonnie Baker a consultant, writer and educator specialising in DB2 application performance and tuning on the OS/390 platform, her award winning classes have been attended by thousands at technical conferences worldwide. Bonnie will be giving the following presentations: "The best of things I wish they'd told me eight years ago" and "Little things can make a big difference" . Both sessions are designed to help both developers and DBAs gain a better understanding of DB2 [...]
15619 57 46_DB2 Symposium - San Francisco - November 6-8th12_Susan Lawson22_lawson_susan@YAHOO.COM31_Wed, 27 Sep 2000 09:32:58 -0700467_us-ascii DB2 Symposium comes to San Francisco in November!!!
Dear DB2 Professional,
Announcing the San Francisco DB2 Symposium - November 6-8th. At the DB2 Symposium there will be three days of various one-day sessions covering on the hottest topics in DB2 and new technologies: such as XML and WAP. The sessions are taught by experienced and well-known consultants including some familar names from DB2-L such as Richard Yevich and Terry Purcell. [...]
15677 32 18_db2 sort vs dfsort9_Mark Judd19_Mark.Judd@BOTCC.COM31_Wed, 27 Sep 2000 11:22:49 -0500314_us-ascii i am new to db2
have a generic question
i have a program which joins three tables and does an order by and writes the result set (is that the correct term?) to a flat file.
i feel that we should drop the order by and do the sort using dfsort (or syncsort) against the flat file. [...]
15710 51 22_Re: db2 sort vs dfsort15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Wed, 27 Sep 2000 11:53:17 -0500446_iso-8859-1 I have experimented and found external sorts to be more efficient than within DB2. I do not know why this should be so...(wonder if it is the opposite at other sites.... with different pool allocations).
I would tend to agree with you especially if your resultant data is large. If you can avoid a program to effect the join, simply use DSNTIAUL to download joined data to a flat file. In either case sort it externally... [...]
15762 71 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Wed, 27 Sep 2000 10:29:25 -0700371_iso-8859-1 Polly - FYI on how to determine the error when it is reported like this.
The message for SQLCODE=-104 is:
ILLEGAL SYMBOL "token". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: token-list
The lower case terms in the message are the variables to be replaced by the tokens. Since TOKENS=WS-ACT-ID.: in your error, the resolved message would be: [...]
15834 20 36_Re: UDB/AIX and UDB/NT differences ?12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 27 Sep 2000 12:39:08 -0500554_- DB2 for AIX and DB2 for Windows differences are very minor, but there are environmental differences and combinations which might not be supported.
There are many possible dependencies. If the application does not have install scripts for AIX and DB2 and depends upon Windows facilities, you can be stuck. If the vendor does not want to commit to an additional combination of hardware, operating system and DBMS, then the question comes back to negotiation. You can note that their costs are probably low, but I'd suspect they are not zero. [...]
15855 19 27_Re: ASCII and CHR functions12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 27 Sep 2000 12:59:49 -0500494_- As noted in another append, there is a direct function for translation on S/390, so this can be a lot shorter. Translate is an instruction in assembler and is also in PL/I. We have the function built into DB2 V6.
Are you keeping the data in ASCII format on S/390 or are you having the translation done? You should be sure of the CCSID on the subsystem before doing coding that might not work or be needed. There is an appendix in the Installation Guide that explains the options. [...]
15875 13 30_Re: September 26 announcements12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 27 Sep 2000 13:02:53 -0500320_- I read the announcement, but I'm not sure what it means.
Roger Miller
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15889 271 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!15_Stovall, Martin16_MStovall@USG.COM31_Wed, 27 Sep 2000 13:04:50 -0500389_iso-8859-1 Polly, in version 6 a host variable must be preceded with a : - this wasn't a restriction in previous versions ; this looks to be the problem with WS-ACT-ID
-----Original Message----- From: Provenzola, Tony [SMTP:Tony.Provenzola@NIKE.COM] Sent: Wednesday, September 27, 2000 12:29 PM To: DB2-L@RYCI.COM Subject: Re: Automatic rebind causing errors in DB2 v6 - HELP! [...]
16161 23 35_SQL0987C error on UDB AIX V6 system12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Wed, 27 Sep 2000 13:07:30 -0500333_iso-8859-1 We have 8 gig real memory on one of our AIX systems and can't fully utilize it because of the SQL0987C error
We have UDB EE version 6.1 fixpak4 with one instance & AIX 4.3.3
How do other shops get around the SQL0987C error?
SQL0987C The application control shared memory set cannot be allocated. [...]
16185 107 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 27 Sep 2000 13:11:57 -0500597_ISO-8859-1 I'm glad others found this one quickly. The best description of this in in the red book, SG24-6108, V6 Technical Update, with a two page description of the situation. ibm.com/redbooks
Here is some of the text pasted from the red book.
2.1.2 Host variables must be preceded by a colon ":"
DB2 Version 6 enforces the standard that requires all host variables to be preceeded by a colon ":". All host variable references must have the leading colon. If the colon is missing, the precompiler will issue an error message or interpret the variable as a column name. [...]
16293 37 20_Datajoiner on an NT.18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Wed, 27 Sep 2000 14:42:13 -0400383_iso-8859-1 I know this may be a very broad question but does anyone know if there's any type of classroom education out there that one could take that would;
1) Help me to administor Datajoiner on an NT machine. Ie; understand all these 'heap' sizes; cache sizes etc. & learn now to manipulate them. 2) How to use the monitoring tools to monitor the Datajoiner Database. [...]
16331 52 24_Re: Datajoiner on an NT.15_Zander, Barb J.19_bzander@STATE.ND.US31_Wed, 27 Sep 2000 13:55:44 -0500442_iso-8859-1 Look at class DW212 Datajoiner admin. goes over both UNIX and NT platforms.
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Wednesday, September 27, 2000 1:42 PM To: DB2-L@RYCI.COM Subject: Datajoiner on an NT.
I know this may be a very broad question but does anyone know if there's any type of classroom education out there that one could take that would; [...]
16384 145 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 27 Sep 2000 15:08:27 -0400378_iso-8859-1 Roger said >>If you do not have the source code, the options are very limited.
This is what exactly happened with us. No source code because, it is a vendor product with no support. PL/I programs with no colon for the host-variables are the worst (as column name can have ( _ ) underscore as part of the name and can have same name as table column names. [...]
16530 273 27_Re: ASCII and CHR functions8_Lo, Mary17_mary.lo@TGSLC.ORG31_Wed, 27 Sep 2000 14:59:13 -0500336_iso-8859-1 Bill and Paul: Thank you so much for your speedy responses and information. Yes, we are moving to V6 because V5 couldn't support triggers. I could't get TRANSLATE to work for me. I am thinking about creating 2 UDFs called ASCII and CHR to do the lookup; then I don't need to mess with the trigger. Trigger calling UDF?? [...]
16804 55 7_signoff10_Wang.James24_Wang.James@AAA-CALIF.COM31_Wed, 27 Sep 2000 13:05:56 -0700172_us-ascii Sign off.
James Wang ESD-Technical Services Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com
16860 192 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 27 Sep 2000 20:07:41 GMT639_- Venkat,
Could you share the re-engineering rexx with your fellow list serv members? I perfectly understand if you do not wish to.
Regards, Rick Creech
>From: "Pillay, Venkat (PCA)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Automatic rebind causing errors in DB2 v6 - HELP! >Date: Wed, 27 Sep 2000 15:08:27 -0400 > >Roger said >>If you do not have the source code, the options are very >limited. > >This is what exactly happened with us. No source code because, it is a >vendor product with no support. PL/I programs with no colon for the [...]
17053 243 53_Re: Automatic rebind causing errors in DB2 v6 - HELP!20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 27 Sep 2000 16:24:26 -0400379_iso-8859-1 Hi Rick
I would love to. But here is a small problem, I wrote the code during the paid hours using office resources...
But I am very confident that if some one needs a similar help, I would be able to either provide guidelines on writing the same or one could contact my boss for a permission to share this code ( I don't believe, he would refuse). [...]
17297 47 4_BLOB16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM31_Wed, 27 Sep 2000 16:29:52 -0400112_iso-8859-1 Are BLOB's supported in DB2 v5? Thanks
Mike Friedlander friedlander@firstinvestors.com
17345 271 8_Re: BLOB12_Cook, Nicole19_Nicole_Cook@BMC.COM31_Wed, 27 Sep 2000 15:44:50 -0500446_iso-8859-1 Yes, most definitely for UNIX/NT. I assume for OS/390 as well. Just remember that they need to be stored in a long tablespace.
Nicole Cook Software Support Analyst bmcsoftware 800.537.1813 ncook@bmc.com
-----Original Message----- From: Mike Friedlander [mailto:friedlander@FIRSTINVESTORS.COM] Sent: Wednesday, September 27, 2000 3:30 PM To: DB2-L@RYCI.COM Subject: BLOB
Are BLOB's supported in DB2 v5? Thanks [...]
17617 301 8_Re: BLOB16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM31_Wed, 27 Sep 2000 16:53:56 -0400397_iso-8859-1 Nicole, I should have mentioned this is an OS390 environment. I cannot seem to find any doc discussing BLOB's which is why I thought it may not be available.
Mike Friedlander friedlander@firstinvestors.com
----- Original Message ----- From: Cook, Nicole Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Wednesday, September 27, 2000 04:44 PM Subject: Re: BLOB [...]
17919 77 8_Re: BLOB11_Jim Keohane19_jimkeo@LOCKSTAR.COM31_Wed, 27 Sep 2000 17:04:04 -0400627_us-ascii Mike,
You're right. BLOBs in V6 and up. VARCHARs only before V6. - Jim Keohane
Mike Friedlander wrote:
> Nicole,I should have mentioned this is an OS390 environment. I cannot > seem to find any doc discussing BLOB's which is why I thought it may > not be available. > Mike Friedlander > friedlander@firstinvestors.com > > ----- Original Message ----- > From: Cook, Nicole > Newsgroups: bit.listserv.db2-l > To: DB2-L@RYCI.COM > Sent: Wednesday, September 27, 2000 04:44 PM > Subject: Re: BLOB > > Yes, most definitely for UNIX/NT.I assume for OS/390 as > well.Just remember that they need to [...]
17997 35 8_Re: BLOB12_Susan Lawson22_lawson_susan@YAHOO.COM31_Wed, 27 Sep 2000 14:08:13 -0700698_us-ascii Mike,
BLOBs are not supported on the OS/390 until V6.
Regards,
Susan Lawson www.ylassoc.com
--- Mike Friedlander wrote: > Are BLOB's supported in DB2 v5? > Thanks > > Mike Friedlander > friedlander@firstinvestors.com > >
__________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
18033 50 27_Re: ASCII and CHR functions8_Lo, Mary17_mary.lo@TGSLC.ORG31_Wed, 27 Sep 2000 16:03:06 -0500348_iso-8859-1 We are keeping the data in EBCDIC format. When I worked on IMPORT data thru DB2 Connect I had a lot of problem with Character Set. (I used IMPORT to load data from UDB on NT to OS/390). I finally made it work with ZPARM value: Mixed Data ==> No EBCDIC CODED CHAR SET ==> 37 ASCII CODED CHAR SET ==> 0 DEF ENCODIMG SCHEME ==> EBCDIC [...]
18084 90 8_Re: BLOB10_Park, Stan17_SPark@STATE.NM.US31_Wed, 27 Sep 2000 15:10:58 -0600746_iso-8859-1 If you want a "taste" of this functionality DB2 UDB V7 on Intel platforms http://www-4.ibm.com/software/data/db2/udb/demo.html
-----Original Message----- From: Jim Keohane [mailto:jimkeo@LOCKSTAR.COM] Sent: Wednesday, September 27, 2000 3:04 PM To: DB2-L@RYCI.COM Subject: Re: BLOB
Mike,
You're right. BLOBs in V6 and up. VARCHARs only before V6. - Jim Keohane
Mike Friedlander wrote:
> Nicole,I should have mentioned this is an OS390 environment. I cannot > seem to find any doc discussing BLOB's which is why I thought it may > not be available. > Mike Friedlander > friedlander@firstinvestors.com > > ----- Original Message ----- > From: Cook, Nicole > Newsgroups: bit.listserv.db2-l [...]
18175 106 60_DB2 Connect from Unix to DB2 OS/390, maybe WEBSPHERE on UNIX16_Jerry Bustamante20_ggbusta@LANDSEND.COM31_Wed, 27 Sep 2000 15:58:31 -0500456_iso-8859-1 We are just getting into this, a little late, I know, and am interested in anyone's recent experiences with this architecture. 2 parts: DB2 Connect running on Unix connecting to DB2 Version 6 for OS/390. 2nd part is WEBSPHERE.
Very interested in any feedback on experiences, issues, problems, training, recommendations, performance, human resource requirements, and any other useful information on this topic you have time to share. [...]
18282 75 22_Re: db2 sort vs dfsort14_Theisen, Craig22_CTheisen@GUIDEMAIL.COM31_Wed, 27 Sep 2000 16:21:19 -0500339_iso-8859-1 I have not done any benchmarking, but I would also believe that normally external sorts would be the best way to go. However, I can see where if the sort key used in the "order by" is the same column(s) as the table(s) clustering index that the "order by" could actually be faster because it may not need to invoke a sort. [...]
18358 161 64_Re: DB2 Connect from Unix to DB2 OS/390, maybe WEBSPHERE on UNIX10_Park, Stan17_SPark@STATE.NM.US31_Wed, 27 Sep 2000 15:30:53 -0600587_iso-8859-1 Jerry, Did a short trial on Solaris flavor of Unix back in May at DB2UDB/Conn V6.1 with DB2 OS390 V5.1 and the main problem was my being a bit rusty in Solaris Unix. It works. Check out the unix scripts at http://people.mn.mediaone.net/scottrmcleod/eu03000.html Have not used Websphere. -Stan
-----Original Message----- From: Jerry Bustamante [mailto:ggbusta@LANDSEND.COM] Sent: Wednesday, September 27, 2000 2:59 PM To: DB2-L@RYCI.COM Subject: DB2 Connect from Unix to DB2 OS/390, maybe WEBSPHERE on UNIX [...]
18520 59 18_DB2 UDB swap usage24_LUIS ANTONIO REYES DURAN23_lreyesd@MAIL.TELCEL.COM31_Wed, 27 Sep 2000 18:01:02 -0500335_us-ascii Hi everyone,
I have some problems with the swap, when the DB2 is working all the proceses "db2sysc" are using a lot of swap space and seems to be low on RAM usage.
I want to know if there is some parameters I should setup in order to decrease the usage of physical swap space and increase the usage of RAM. [...]
18580 62 22_Re: db2 sort vs dfsort10_john clark20_pak02449@PIXIE.CO.ZA31_Thu, 28 Sep 2000 07:11:18 +0530570_iso-8859-1 In my experience, in whatever DBMS environment, there is still often great merit in sequential extracts, sorts and merges. By doing this you can take advantage of INREC,s INCLUDES OMITS etc, use huge buffers and parrellise the extract process thereby often cutting down on elapsed time.
You should however bear in mind that this will complicate the production of the data and you are taking more responsibility on yourself, should the wrong data be produced. If you are cynical, by continuing to do the JOIN with DB2, you are protecting yourself. [...]
18643 104 22_Re: DB2 UDB swap usage11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Thu, 28 Sep 2000 01:13:14 -0400351_us-ascii Luis,
What operating system? AIX, Sun, NT, ... ? DB2 Version?
DB2 uses many memory areas to improve performance. If you reduce these memory areas to alleviate swap constraints, your database will do more physical I/O.
How to configure and tune memory is very operating system dependent, so I will stop here for now. [...]
18748 19 29_Re: Oracle OS390 announcement14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 28 Sep 2000 09:05:04 +0100472_us-ascii I agrreeee Leslie, I was assigned to a new job with ORACLE & UNIX (our S390 dept was closed) but I desired to live,
so I changed company. I've never seen in DB2 a 2 month's recovery
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.
18768 20 22_Re: db2 sort vs dfsort14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 28 Sep 2000 09:35:32 +0100489_us-ascii There's an article by Chuck Hoover where there are some explanation about internal & external sort in DB2:
'Db2 access path by numbers'. I think it's a good article.
HTH
Max Scarpa All disclaimers in the galaxy apply.
================================================ 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.
18789 194 27_Re: ASCII and CHR functions14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 28 Sep 2000 20:14:06 +1100537_iso-8859-1 Mary,
A bit of advice from someone who's been-there-done-that with a one character string: write a pair of UDFs to convert from a character string to a numeric value and back again. Invoke these from the trigger.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Lo, Mary [mailto:mary.lo@TGSLC.ORG] Sent: Wednesday, September 27, 2000 2:03 AM To: DB2-L@RYCI.COM Subject: [DB2-L] ASCII and CHR functions [...]
18984 20 8_Re: BLOB13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 27 Sep 2000 16:53:19 -0400467_iso-8859-1 >Are BLOB's supported in DB2 v5?
For OS/390, No they are not.
Large objects are not available until V6.
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.
19005 60 22_Re: DB2 UDB swap usage12_Kent Collins15_kcollins@WF.NET31_Thu, 28 Sep 2000 06:32:52 -0500314_iso-8859-1 Luis,
I assume this is a Sun box because the term 'swap space' occurs in this operating system. AIX and HP use paging space. If db2 is swapping then either reduce the amount of memory being used by other applications, increase physical memory or decrease the amount of memory needed by db2. [...]
19066 83 22_Re: DB2 UDB swap usage19_Vanderbeck, Raymond29_Raymond.Vanderbeck@SCHWAB.COM31_Thu, 28 Sep 2000 04:32:56 -0700567_iso-8859-1 Can't sleep.
> -----Original Message----- > From: Kent Collins [mailto:kcollins@WF.NET] > Sent: Thursday, September 28, 2000 3:33 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 UDB swap usage > > > Luis, > > I assume this is a Sun box because the term 'swap space' > occurs in this > operating system. AIX and HP use paging space. If db2 is > swapping then > either reduce the amount of memory being used by other applications, > increase physical memory or decrease the amount of memory > needed by db2. > > There are several kernel parms to also [...]
19150 25 33_How to free Query_Heap within cli33_Christopher I Schmidt/Houston/IBM18_cschmid@US.IBM.COM31_Thu, 28 Sep 2000 07:28:32 -0500564_us-ascii Hello,
I have an application that needs to stay connected to a DB2 database as long as possible. I'm using the CLI API for the application. I've noticed that after a large amount of queries, I no longer can query anything because I get 'QUERY_HEAP is full' errors. Once this happens, I have to disconnect and then reconnect to the database. I haven't been able to determine a way to find if I'm about to fill the Query_Heap and need to reconnect BEFORE this happens. Does anyone know how to either free the Query_Heap or know when the heap is [...]
19176 40 26_Stored Procedure Debugging12_Ashwin Patel24_Ashwin.Patel@NATWEST.COM31_Thu, 28 Sep 2000 14:00:00 +0100352_ISO-8859-1 Hi,
I am using DB2 UDB 7.1 on an NT platform. Client server application consists of VB, ADO and either ODBC or OLEDB driver. Stored procedures are written using SQL language that is available with version 7. The Stored Procedure Builder (SPB) is used to develop the stored procedures. The compiler I am using Microsoft VC++ 6.0. [...]
19217 50 30_DJOINER/DPROP security problem12_Rompot, Kurt26_kurt.rompot@INGRAMBOOK.COM31_Thu, 28 Sep 2000 08:16:17 -0500353_iso-8859-1 OK, here's the scenario.
I want to use Datajoiner 2.1.1 Fixpak 6 on Windows NT to replicate data from DB2 OS/390 V5 to Oracle. I would like to connect directly from the Data Joiner server to OS/390 using TCP/IP. Finally, I need to use a different user ID and password to connect to OS/390 than I use to start Apply on Windows NT. [...]
19268 25 24_DB2 Call Level Interface15_Morris, Deborah20_DMorris@UNCH.UNC.EDU31_Thu, 28 Sep 2000 09:47:40 -0400339_iso-8859-1 I have a question pertaining to Version 6 of DB2 OS/390 with the DB2 Call Level Interface. Is the DB2CLI included in this version and what is it called, same thing or something different?
Deborah A. Morris Supervisor DataBase Administration UNC Health Care System 2nd Floor Carr Mill Mall Carrboro, NC 27510 [...]
19294 210 27_Re: ASCII and CHR functions8_Lo, Mary17_mary.lo@TGSLC.ORG31_Thu, 28 Sep 2000 08:43:17 -0500597_iso-8859-1 Thank you for your advice. That sounds like the cleanest way. I was thinking about doing it. It's encouraging to hear from someone been-there-done-that.
-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Thursday, September 28, 2000 4:14 AM To: DB2-L@RYCI.COM Subject: Re: ASCII and CHR functions
Mary,
A bit of advice from someone who's been-there-done-that with a one character string: write a pair of UDFs to convert from a character string to a numeric value and back again. Invoke these from the trigger. [...]
19505 33 35_Collating sequence (second attempt)4_R.S.30_R.Skorupka@BREMULTIBANK.COM.PL31_Thu, 28 Sep 2000 16:38:47 +0200631_iso-8859-2 (this is second attempt - first wasn't succesful) Hi everybody, I'm from Poland, and use polish national characters in my data. For proper collating sequence in SELECT ... ORDER BY char_column we must use FIELDPROC clause. This very convenient with one exception: you cannot define table (column) using both: FIELDPROC and NOT NULL WITH DEFAULT clauses. I'm wondering WHAT countries must use FIELDPROC for collating sequence ? I know about Poland, Montenegro, Ukraina, Slovenia... But I HAVE TO KNOW how it is solved in Italy, Portugal and Greece. Must they use FIELDPROC for character data ? Is there anybody from [...]
19539 89 28_Re: DB2 Call Level Interface13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 28 Sep 2000 09:41:18 -0500499_US-ASCII Deborah, look at the V6 ODBC Guide and Reference. "DB2 ODBC support is implemented as a CLI/ODBC driver/driver manager that is loaded at run time into the application address space." I believe the DB2 packages and plan are still the same. Kurt
>>> DMorris@UNCH.UNC.EDU 09/28/00 08:47AM >>> I have a question pertaining to Version 6 of DB2 OS/390 with the DB2 Call Level Interface. Is the DB2CLI included in this version and what is it called, same thing or something different? [...]
19629 20 7_DSNTIAD10_Greg Jonas21_gjonas@CP-DEMO.CP.NET31_Thu, 28 Sep 2000 07:48:55 -0700619_- Just wondering if others have experienced the following scenario and if there is any work around. We use DSNTIAD to perform CREATE's and do ALTER's of our production DB2 components. Our production environment consists of multiple sites which process against mostly identical tables.
The problem we recently encountered involved 3 ALTER's to one table, each adding a column. This worked fine in all sites except 2. One site encountered an unavailable resource error on the first alter, but the next 2 worked fine. The second site got an unavailable resource on the first 2 alters, but the third worked. In [...]
19650 35 13_Multithreaded13_Horacio Villa17_hvilla@TTI.COM.AR31_Thu, 28 Sep 2000 11:54:36 -0300593_iso-8859-1 Hi, some time ago I posted the question "does DB2 implement a multithreaded architecture in the UNIX world?", not quite knowing what that meant. There was this requirement "the DBMS must implement a multithreaded architecture" on a contract we wanted to win. As I had no clear answer, though somebody said "DB2 is intrinsecally multithreaded, but what do you really want to ask?", my company discarded DB2 and went with Oracle. Now there's an article "Made for each other: DB2 UDB 7.1 & Win 2000" on DB2 Magazine Quater 3, 2000 where we can read: "On the Windows platform, DB2 [...]
19686 54 39_Re: Collating sequence (second attempt)12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 28 Sep 2000 15:24:45 GMT715_- Have you considered performing the sort in the program rather than with an order by?
Craig Patton
>From: "R.S." >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Collating sequence (second attempt) >Date: Thu, 28 Sep 2000 16:38:47 +0200 > >(this is second attempt - first wasn't succesful) >Hi everybody, >I'm from Poland, and use polish national characters in my data. >For proper collating sequence in SELECT ... ORDER BY char_column we must >use FIELDPROC clause. This very convenient with one exception: you >cannot define table (column) using both: FIELDPROC and NOT NULL WITH >DEFAULT clauses. >I'm wondering [...]
19741 21 30_db2 connectivity supplement ??10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 28 Sep 2000 11:37:41 -0400425_us-ascii Hi all I'm reading the db2 connect connectivity supplement section about 'defining the local system(tcpip)' in chapter 2 it states under #3 that the port numbers of the 0s/390 and the remote application server must be the same. Is this correct? It also states in #4 to make tcpalver = yes Why do I need to set this to 'yes' when the parameter is for inbound reqests only and i'm trying to do a outbound request [...]
19763 51 34_Re: db2 connectivity supplement ??11_John Wallin24_john.wallin@ZURICHUS.COM31_Thu, 28 Sep 2000 10:52:02 -0500455_us-ascii Tom, The IPNAMES table on OS/390 has theIP addresses and port numbers of remote locations. The TCPIP startup parms for the OS/390 address space allocated the IP Port numbers for the DB2 DDF address spaces. The started task DB2MSTR lists the DDF ports for each addr space as it initializes . There are 2 ports for each OS/390 region TCPPORT RESPORT. The remote server must be configured as a location using the database name to the mainframe [...]
19815 19 30_SQL30081 and tcpip error 1004813_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Thu, 28 Sep 2000 10:55:04 -0500504_iso-8859-1 Hello List,
Anybody in DB2 Connect land know what causes tcpip 10048 communication errors? I see that 10048 (wsaeaddrinuse) means that "The specified address is in use", but I'm not sure exactly what the problem situation is.
Thanks Dave
================================================ 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.
19835 12 43_DB2 Connect 6.1, where can I download from?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Thu, 28 Sep 2000 10:59:18 -0500386_- Where can I have my customer download a copy of DB2 Connect PE 6.1 from? On the IBM site, I see only the current release of 7.1 available. TIA
================================================ 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.
19848 34 34_Re: SQL30081 and tcpip error 1004812_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 28 Sep 2000 11:18:37 -0500493_iso-8859-1 WSAEADDRINUSE 10048 Address already in use.
-----Original Message----- From: Shapiro, Dave [mailto:Shapiro.Dave@PRINCIPAL.COM] Sent: Thursday, September 28, 2000 10:55 AM To: DB2-L@RYCI.COM Subject: SQL30081 and tcpip error 10048
Hello List,
Anybody in DB2 Connect land know what causes tcpip 10048 communication errors? I see that 10048 (wsaeaddrinuse) means that "The specified address is in use", but I'm not sure exactly what the problem situation is. [...]
19883 54 34_Re: SQL30081 and tcpip error 1004813_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Thu, 28 Sep 2000 11:26:23 -0500430_iso-8859-1 Hi Paul,
Do you know what causes this? The errors are on the DB2 Connect servers' db2diag.log. Is it the host's address that is implied?
Thanks Dave
-----Original Message----- From: Martin, Paul [mailto:Paul.Martin@ECOLAB.COM] Sent: Thursday, September 28, 2000 11:19 AM To: DB2-L@RYCI.COM Subject: Re: SQL30081 and tcpip error 10048
WSAEADDRINUSE 10048 Address already in use. [...]
19938 24 27_DMS + Windows2000 + UDB 7.17_J. Wang32_Jizhong_Wang@EMAIL.WHIRLPOOL.COM31_Thu, 28 Sep 2000 14:47:42 -0400457_US-ASCII Hi list,
I am using DB2 UDB 7.1 with fix WR21198 on newly installed Windows2000 professional edition (with service pack 1). I can use script and control-centre to create SMS database without any problems. However, whatever I tried, I can NOT create DMS database, neither tablespaces. It always errored with "SQL0298N Bad container path. SQLSTATE=428B2". I have tried using script (script is OK with WinNT 4), as well as control_centre. [...]
19963 19 13_DB2 Timelines19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Thu, 28 Sep 2000 20:40:21 +0100418_us-ascii Can someone give me release dates for the various versions of DB2 (both OS/390 and UNO).
This for a training course I'm preparing.
TIA
Phil Nelson
================================================ 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.
19983 75 29_Locking conflict DB2 V6/OS39011_Robert Jans21_Jans.Robert@AMSTR.COM31_Thu, 28 Sep 2000 15:30:00 -0600446_- Looking for explanations or solutions for the following:
We have a Large Compressed tablespace, 32 parts, 5 NPI's, 12M rows and growing about 1.5m weekly for about 6 more months (hereafter referred to as TABLE1). We have 8 applications jobs that run in parallel using the same package against TABLE1. The SQL is set up using upper and lower bounds to limit each job to an exclusive partition range to ensure partition independence. [...]
20059 17 26_DB2/UDB/AIX Online Reorgs?14_Scott Saunders20_ssaunders@SIEBEL.COM31_Thu, 28 Sep 2000 14:02:32 -0700431_iso-8859-1 Does anyone know if there is a product for this platform that will allow at least read access to a table while it is being reorganized?
Scott Saunders Siebel Systems, INC.
================================================ 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.
20077 51 35_Re: Primary Key as Clustering Index13_Hartman, John19_JHartman@BBANDT.COM31_Thu, 28 Sep 2000 16:03:13 -0400359_- The standard disclaimer 'It depends' applies here. If you implicitly defined the clustering index and then ran a reorg, you would not get the data stored in clustering sequence unless it was stored that way to begin with. This could be causing you to do a tablespace scan to get the data. That would explain why your result set is not sorted properly. [...]
20129 35 30_Fw: DB2/UDB/AIX Online Reorgs?11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Thu, 28 Sep 2000 18:22:39 -0400356_us-ascii I've heard online reorgs are high on the list for inclusion in V8, and I'm not talking about the vegetable beverage.
BMC has a fast unload tool, but I'm not aware of any ISV Reorg tools available at this time.
Regards, Scott
Performance tools for DB2 UDB UNIX. Yeah, we've got those. http://www.database-guys.com/domore/ [...]
20165 47 37_FW: How to free Query_Heap within cli12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Thu, 28 Sep 2000 19:23:26 -0400370_iso-8859-1 You will need to increase the size of QUERY_HEAP_SZ parameter in your Database Manager Configuration. Refer to the Performance Section in the Administration Guide for more details.
This can be achieved by issuing the following commands:
* db2 update dbm cfg using * db2stop & db2start (to refresh the DB2 instance) [...]
20213 224 27_FW: ASCII and CHR functions12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Thu, 28 Sep 2000 19:28:39 -0400400_iso-8859-1 Why a trigger & not a stored procedure ?
-----Original Message----- From: Lo, Mary [mailto:mary.lo@TGSLC.ORG] Sent: Thursday, September 28, 2000 9:43 AM To: DB2-L@RYCI.COM Subject: Re: ASCII and CHR functions
Thank you for your advice. That sounds like the cleanest way. I was thinking about doing it. It's encouraging to hear from someone been-there-done-that. [...]
20438 30 30_FW: DB2/UDB/AIX Online Reorgs?12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Thu, 28 Sep 2000 19:43:35 -0400407_iso-8859-1 Well, one option is that you have this table replicated.
-----Original Message----- From: Scott Saunders [mailto:ssaunders@SIEBEL.COM] Sent: Thursday, September 28, 2000 5:03 PM To: DB2-L@RYCI.COM Subject: DB2/UDB/AIX Online Reorgs?
Does anyone know if there is a product for this platform that will allow at least read access to a table while it is being reorganized? [...]
20469 34 16_index comparison13_OConner, John26_John.OConner@COURTS.WA.GOV31_Thu, 28 Sep 2000 17:01:37 -0700443_ISO-8859-1 We are creating two indexes on a table. Both are unique. The first index has one column. The second index has two columns, and the second column is the same column as the column in the first index. Like this:
index 1 COL1
index 2 COL0 COL1
I was asked the question: Would we get better performance from index 2 if we defined it as non-unique (the uniqueness of COL1 would insure the uniqueness of index2)? [...]
20504 69 11_Re: DSNTIAD14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 29 Sep 2000 12:03:20 +1100437_iso-8859-1 Greg
Have you considered using DSNTEP2 instead? It's behaviour is to rollback after a 'really' nasty sqlcode (-904,-911 etc).
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Greg Jonas [mailto:gjonas@CP-DEMO.CP.NET] Sent: Friday, September 29, 2000 1:49 AM To: DB2-L@RYCI.COM Subject: [DB2-L] DSNTIAD [...]
20574 255 27_Re: ASCII and CHR functions14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 29 Sep 2000 12:21:50 +1100573_iso-8859-1 I'm not sure you wrote what you meant to write. The advantage of a trigger over a stored procedure, is that a trigger is executed whenever an insert/update occurs on a row - without any special coding on the client side.
However, it is possible that you really meant to write "[w]hy a _UDF_ & not a stored procedure?" If so, the answer is that, when invoked from a trigger, a stored procedure cannot update the data in the row whose update/insert fired [or should that be "pulled"] the trigger: and the trigger syntax does not provide a mechanism to [...]
20830 73 20_Re: index comparison14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM31_Fri, 29 Sep 2000 13:13:12 +1100558_- John,
Quite the opposite, you may get decreased performance if the index is defined as non-unique.
A few thoughts to support this are: - a duplicate index stores an extra 6 bytes (Not 100% sure that 6 is the exact value) for each unique value of a duplicate index. If the index is actually unique then this is 6 bytes for every row, rather than every RID chain. DB2 estimator will give a good estimation. - only a unique index can be used to avoid a sort for a SELECT DISTINCT. - non-correlated subquery transformation to a join is only [...]