1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2001, week 5
2 96 38_Re: Index access and effect of NLEVELS14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 29 Jul 2001 02:18:10 -0500447_- Mehdi,<br><br>Another possibility (and I cheerfully admit that it's not a fully baked suggestion) is related to the way DB2 truncates keys in non-leaf index pages - essentially the keys stored in non-leaf pages are not necessarily the entire key (**) on the page being pointed to, but can be truncated. It might be that because of the distribution of the lower order columns, the non-leaf pages in index1 have better truncation than index4 [...]
99 58 33_Re: Problem with Decimal Rounding14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 29 Jul 2001 02:37:34 -0500686_- Phil<br><br>In the past I have had success by placing a decimal point after integer divisors. ("10000" is an integer that ends up being treated as DEC (11,0); "10000." is DEC(5,0).)<br><br>James Campbell<br><br><br><br>On Fri, 27 Jul 2001 20:50:34 +0100, Philip Nelson (DBA) <teamdba@ATTGLOBAL.NET> wrote:<br><br>>We've got a problem with a query / view being affected by DEC(15) rounding. > >The fields are - > >SALES_PRICE DEC(11,2) >PERCENTAGE_FACTOR1 DEC(5,2) >PERCENTAGE_FACTOR2 DEC(5,2) > >The calculation in the view is - > >(SALES_PRICE / 10000) * (PERCENTAGE_FACTOR1 * PERCENTAGE_FACTOR2) > >The division by 10000 is because the two PERCENTAGE_FACTOR fields are percent [...]
158 15 49_Peter Faller/HRD/Prudential is out of the office.12_Peter Faller27_peter.faller@PRUDENTIAL.COM31_Mon, 30 Jul 2001 01:06:46 -0400438_us-ascii I will be out of the office from 07/28/2001 until 08/06/2001.<br><br>If you need something during my absents please contact John O'Shea. Else I will respond to your message when I return.<br><br>================================================ 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.
174 14 48_Bing Sinski/A&O/FirstUnion is out of the office.11_Bing Sinski27_bing.sinski1@FIRSTUNION.COM31_Mon, 30 Jul 2001 01:25:39 -0400365_us-ascii I will be out of the office from 07/30/2001 until 07/31/2001.<br><br>I will respond to your message when I return.<br><br>================================================ 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.
189 19 27_squaring in on locks.......18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Mon, 30 Jul 2001 01:13:36 -0500398_- Hi Friends,<br><br>I need to get some things straight about locking. Are tablespace and table lock always acquired prior to page/row locks. If so then if a prog,say PROGA, is running and it puts locks on the tablespaces it would access while running,then if another prog comes along which needs the same tablespace, would it be put on hold. Also could someone elaborate on intent locks too. [...]
209 133 26_Re: FAROFFPOS vs FARINDREF20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Mon, 30 Jul 2001 08:38:01 +0100451_iso-8859-1 Accurate, clear and concise but not an answer to the question asked: "Why isn't FAROFFPOS zero"?!<br><br>-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:rd8246@SBC.COM] Sent: 27 July 2001 17:10 To: DB2-L@RYCI.COM Subject: Re: FAROFFPOS vs FARINDREF<br><br><br><br>Hi Doc, Wow, this is the best write-up on this subject I've seen -- accurate, clear, concise! I hereby nominate you to write the IBM manuals on same subject! [...]
343 119 15_-904 / 00C9008015_Chris Van Daele33_Chris.Van.Daele@TOYOTA-EUROPE.COM31_Mon, 30 Jul 2001 10:02:53 +0200409_us-ascii Hi list,<br><br>I a on DB2 V5. Cobol program that performs insert all of the sudden gets a -904 reason 00C90080, saying tablespace is RO The strangest thing is that the program allready performed about 10.5 milj. inserts, so the TS could not have been RO before a -DIS DB show that the TS and IX's are all RW. The only action I can see before the -904 in the master log is a archive log offload [...]
463 44 58_Re: general questions about DB2 COBOL setup in CICS TS 1.313_Schulz Thomas20_thomas.schulz@SVI.DE31_Mon, 30 Jul 2001 10:16:21 +0200442_us-ascii Hey Craig<br><br>1. DB2CONN defines the global attributes of the connection to be established between CICS and DB2 as well as the attributes of pool threads and command threads to be used with the connection.<br><br>2. DB2ENTRY defines resources to be used by a specific CICS transaction, or a group of transactions, when using the CICS DB2 interface. A DB2ENTRY can specify one specific transaction or a group of transactions. [...]
508 81 38_Re: Disaster Recovery Cat/Dir Recovery0_24_ujjwal@LOT.TATASTEEL.COM31_Mon, 30 Jul 2001 14:04:39 +0530293_iso-8859-1 Hi Lee , I think you can first Recover your Catalogs and Directory Tablespaces with ur latest imagecopies and then apply a LOGONLY so that u can Recover to the Current Point in Time with your Archive Logs provided ur BSDS is updated with the Latest Archive Log at the DR site. [...]
590 17 26_Re: FAROFFPOS vs FARINDREF10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Mon, 30 Jul 2001 04:46:56 -0500445_- Gentlemen,<br><br>Thanks for all the replies - it seems to make sense now. The only "problem" left is why the clusterratio was 100%, when strictly speaking it wasn't?!<br><br>Regards,<br><br>Steve Lamb<br><br>================================================ 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.
608 142 26_Re: FAROFFPOS vs FARINDREF14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 30 Jul 2001 11:23:30 +0100343_iso-8859-1 We had some 'problems' a while ago when CA Database Analyzer was reporting different cluster rations to RUNSTATS. We were working out clustering the way we interpreted it and IBM were obviously doing it a different way.<br><br>When we tried to clarify, we were told that the clusterratio algorithm was 'proprietary' to IBM.... [...]
751 66 33_Re: V6 upgrade create index fails9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Mon, 30 Jul 2001 11:32:18 +0100331_ISO-8859-1 Hi,<br><br>I take it DB2 returned a D70025 error.<br><br>The DB2 tablespace is saying that it is SMS, but there is no ACS rule within SMS which refers to that dataset name<br><br>OR<br><br>The DB2 tablespace has a list of volumes which are not SMS volumes, but there is an ACS rule for that dataset name within SMS [...]
818 22 30_Data manipulation during load?19_José Ignacio Ossuna16_jiossuna@ATCA.ES31_Mon, 30 Jul 2001 12:50:10 +0200485_us-ascii Yes, using the SYSPUNCH card, where you have to indicate the initial and final position (9<br><br>bytes) of data inside the input file. Then DB2 will load the data correctly.<br><br><br><br>Hope this helps<br><br><br><br>Nacho Ossuna.<br><br>================================================ 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.
841 15 19_Re: -904 / 00C9008013_Patric Becker25_Patric_Becker@SIS-WEST.DE31_Mon, 30 Jul 2001 06:11:25 -0500368_- Hi Chris !<br><br>Just a question : did the application commit the inserted data after a number of UOWs/UORs ?<br><br>Patric<br><br>================================================ 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.
857 41 19_Re: -904 / 00C9008015_Chris Van Daele33_Chris.Van.Daele@TOYOTA-EUROPE.COM31_Mon, 30 Jul 2001 13:26:58 +0200479_us-ascii Hi Patric,<br><br>Yes the commit rate is every 1000 rows.<br><br><br><br><br><br><br><br><br><br>Patric Becker <Patric_Becker@SIS-WEST.DE> on 07/30/2001 01:11:25 PM<br><br>Please respond to DB2 Data Base Discussion List <DB2-L@RYCI.COM><br><br>To: DB2-L@RYCI.COM cc: (bcc: Chris Van Daele/TMME)<br><br>Subject: Re: -904 / 00C90080<br><br><br><br><br><br>Hi Chris !<br><br>Just a question : did the application commit the inserted data after a number of UOWs/UORs ? [...]
899 76 33_Re: Problem with Decimal Rounding13_Harry Woelfer27_Harry_Woelfer@MCCORMICK.COM31_Mon, 30 Jul 2001 08:03:13 -0400470_us-ascii Phil:<br><br>Try this:<br><br>SALES_PRICE DEC * PERCENTAGE_FACTOR1 * PERCENTAGE_FACTOR2 / 10000<br><br>The idea is simply to save the division for last. It is a rule of arithmetic that there is always a risk of losing precision when you divide. For example, 1 divided by 3 is APPROXIMATELY .333333333333, but without an infinite number of decimal places, you lose some precision. So it's always best, when possible, to do multiplications before divisions. [...]
976 15 34_Re: Data manipulation during load?13_Thomas Schulz20_thomas.schulz@SVI.DE31_Mon, 30 Jul 2001 07:40:01 -0500384_- hi I would append the zero to your 9 character customer number before loading the data. In this case I would use a EDIT-Macro.<br><br>Thomas<br><br>================================================ 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.
992 11 24_Oracle to DB2 connection16_Bernard Greenman27_Bud.Greenman@ONONDAGA.NY.US31_Mon, 30 Jul 2001 08:46:00 -0400343_- What products are available for connecting a DB2 to an Oracle databases and how expensive are they?<br><br>================================================ 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.
1004 32 31_Re: squaring in on locks.......13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 30 Jul 2001 08:50:54 -0400429_iso-8859-1 Hi Rajendra,<br><br>I think you'll get all your questions answered looking in the DB2 Admin guide. There's an excellent chapter on improving concurrency which defines locks and discusses them in great depth. There is a table of compatibility between page and row locks and between tablespace locks.<br><br>Here's a link to the v6 (os/390) book: http://publib.boulder.ibm.com:80/cgi-bin/bookmgr/BOOKS/DSNAG0G3/5.7 [...]
1037 37 19_Re: database files.13_Thomas Schulz20_thomas.schulz@SVI.DE31_Mon, 30 Jul 2001 07:58:08 -0500593_- HI Rajendra,<br><br>it will be done on create tablespace<br><br>the naming conventions (V5.1) are:<br><br>vsamcat.DSNDBx.dbname.spacename.I0001.Annn<br><br>vsamcat = Vsam Catalog or Alias ------- DSNDBC = Cluster DSNDBD = Data Component ------ dbname = Database ------ Spacename = tablespace or Indexspace --------- I0001 = term for normal user data S0001 = term for shadow Dataset (reorg) T0001 = term for temporary shadow dataset (will be allocated by reorg and will be used only during swich phase) ----- Annn = A0001 for first Dataset in Partion A0002 for second Dataset........... [...]
1075 43 28_link errors with sample code13_Butts, Gerald29_GeraldButts@MAIL.NEWSBANK.COM31_Mon, 30 Jul 2001 09:20:46 -0400933_iso-8859-1 Greetings,<br><br>Below are the error messages from DB2 6.1 on Red Hat Linux 7.1 when try to compile and link IBM's sample code? Any suggestions as to what might be wrong here?<br><br>thank you, Gerald Butts Software Developer gbutts@newsbank.com<br><br><br><br>[db2inst1@betasys cli]$ make adhoc cc -c samputil.c -I/home/db2inst1/sqllib/include cc -o adhoc adhoc.c samputil.o -I/home/db2inst1/sqllib/include -L/home/db2inst1/sqllib/lib -Wl,-rpa th,/home/db2inst1/sqllib/lib -ldb2 /home/db2inst1/sqllib/lib/libdb2.so: the use of `tmpnam' is dangerous, better use `mkstemp' /home/db2inst1/sqllib/lib/libdb2.so: the use of `tempnam' is dangerous, better use `mkstemp' /tmp/ccWw0zL7.o: In function `main': /tmp/ccWw0zL7.o(.text+0x95): the `gets' function is dangerous and should not be used. /home/db2inst1/sqllib/lib/libdb2.so: undefined reference to `res_init' /home/db2inst1/sqllib/lib/libdb2.so: undefined reference [...]
1119 14 46_William Mitzmacher/NYLIC is out of the office.18_William Mitzmacher34_William_Mitzmacher@NEWYORKLIFE.COM31_Mon, 30 Jul 2001 09:40:53 -0400387_us-ascii I will be out of the office from 07/30/2001 until 08/01/2001.<br><br>Please contact Lou Salesky or Richie Schmidt for any urgent matters<br><br>================================================ 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.
1134 42 34_Re: Data manipulation during load?18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Mon, 30 Jul 2001 20:14:48 +0530741_- Thomas,<br><br>Someone suggested altering the SYSPUNCH and running the load job. I hope that also would work.<br><br>thanks, Rajendra Deshpande.<br><br><br><br><br><br>>From: Thomas Schulz <thomas.schulz@SVI.DE> >Reply-To: DB2 Data Base Discussion List <DB2-L@RYCI.COM> >To: DB2-L@RYCI.COM >Subject: Re: Data manipulation during load? >Date: Mon, 30 Jul 2001 07:40:01 -0500 > >hi >I would append the zero to your 9 character customer >number before loading the data. >In this case I would use a EDIT-Macro. > >Thomas > >================================================ >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 [...]
1177 20 34_Re: Data manipulation during load?0_20_Jones.H@GRAINGER.COM31_Mon, 30 Jul 2001 10:45:00 -0500339_- My apologies. This is V5 DB2 for OS/390 using IBM load Utility<br><br>================ Original Message ========================<br><br>We want to load a 9 byte customer number into a 10 byte character field, appending a zero to the front of the number without using a program.<br><br>Is there a way to do this with the load cards? [...]
1198 42 41_Question regarding DMS space issue for NT17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Mon, 30 Jul 2001 11:15:37 -0500290_us-ascii I have the following DDL to create tablespaces. The one on the left fails with an error saying that it can't allocate space to create the pages. When I modify it to look like the one on the right it works. Is there a minimum on createing DMS tablespaces and if so what is it? [...]
1241 50 38_Data manipulation during load? (Reply)0_28_michael.d.ockenfels@WCOM.COM31_Mon, 30 Jul 2001 11:16:53 -0500567_us-ascii You might try concatenating a zero to the results o fthe DIGITs function on the unload.<br><br>Select '0'||DIGITS(CUST-NUM)<br><br><br><br><br><br><br><br><br><br><br><br>Jones.H@GRAIN GER.COM To: DB2-L@RYCI.COM cc: (bcc: Mike Ockenfels/CDR/BSM/MCI) 07/27/01 Subject: Data manipulation during load? 02:54 PM Please respond to DB2 Data Base Discussion List<br><br><br><br><br><br><br><br><br><br><br><br><br><br>We want to load a 9 byte customer number into a 10 byte character field, appending a zero to the front of the number without using a program. [...]
1292 56 38_Data manipulation during load? (Reply)14_Mike Ockenfels28_michael.d.ockenfels@WCOM.COM31_Mon, 30 Jul 2001 11:16:53 -0500630_us-ascii You might try concatenating a zero to the results o fthe DIGITs function on the unload.<br><br>Select '0'||DIGITS(CUST-NUM)<br><br><br><br><br><br><br><br><br><br>|--------+-----------------------> | | Jones.H@GRAIN| | | GER.COM | | | | | | 07/27/01 | | | 02:54 PM | | | Please | | | respond to | | | DB2 Data Base| | | Discussion | | | List | | | | |--------+-----------------------> >--------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: Mike Ockenfels/CDR/BSM/MCI) | | Subject: Data manipulation during load? | >--------------------------------------------------------| [...]
1349 16 10_DB Artisan17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Mon, 30 Jul 2001 09:19:24 -0700362_us-ascii Has anyone on the list setup DBArtisan for DB2 OS/390 and specifically the database monitor feature.<br><br>TIA<br><br>================================================ 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.
1366 59 34_Re: Data manipulation during load?15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Mon, 30 Jul 2001 11:29:30 -0500381_iso-8859-1 I can not get you the leading zeros, but if you specify the input as<br><br>DECIMAL EXTERNAL(9)<br><br>that should cause a double conversion to occur and it should store the value as a right aligned left blank padded character string.<br><br>HTH<br><br>Chris Blaicher<br><br>BMC Software, Inc. Austin Research Labs 10415 Morado Circle Austin, TX 78759 512/340-6154 [...]
1426 83 33_Re: V6 upgrade create index fails18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM31_Mon, 30 Jul 2001 13:04:05 -0400367_iso-8859-1 Thank you! You were correct. I had some volumes still in the DB2 stogroup. Replaced them with '*' and all is working well now. I really appreciate your help. Deborah<br><br>-----Original Message----- From: Jim Leask [mailto:jim.leask@RS-COMPONENTS.COM] Sent: Monday, July 30, 2001 6:32 AM To: DB2-L@RYCI.COM Subject: Re: V6 upgrade create index fails [...]
1510 43 32_db2 cluster server ? Performance15_Sangeet Khullar20_db2khullar@YAHOO.COM31_Mon, 30 Jul 2001 10:13:35 -0700571_us-ascii Hi All<br><br>We are experience a strange problem in our db2 cluster server. We have set up db2 ee 7.2 for our production recently on IBM netfinity servers and we have clustered them using Microsoft cluster service on Windows 2000 Advance Server OS .<br><br>The problem is we are using summary table and it takes a lot of time to do a refresh ( 25 mins). Where as in our staging server, it takes just 2 mins. The staging is not clustered. All the config settings ,bufferpools, data volume, indexes exactly tally. The Access plan for the summary table query [...]
1554 45 31_FW: Which indexspace is in use?16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Mon, 30 Jul 2001 14:14:44 -0400571_iso-8859-1 > -----Original Message----- > From: Cockerill, Steve > Sent: Monday, July 30, 2001 2:05 PM > To: DB2 user list (E-mail) > Subject: Which indexspace is in use? > > Good Morning > > I have 260 index datasets of the following format > *.*.DBNAME.INDEXSPACE.T0001.A001 > With an identical name ......I0001.A001 > cataloged. I believe the T0001 was created by an online reorg which was > cancelled in the past (for some reason). > I'm faced with rerunning the reorg and it returns a code of 8 due to the > indexspace name exist .T0001. > The failed reorg was [...]
1600 182 35_Re: FW: Which indexspace is in use?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 30 Jul 2001 19:55:25 +0100321_iso-8859-1 If this is DB2 version 6 or earlier DB2 will ONLY be using I0001 datasets. It is not until FASTSWITCH and DB2 V7 that datasets other than I0001 will be used (and then there'll only be J0001 alternatives).<br><br>Just to be 100% sure, use your favourite MVS monitor to see which datasets DB2 has allocated [...]
1783 166 35_Re: FW: Which indexspace is in use?16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Mon, 30 Jul 2001 15:13:25 -0400493_iso-8859-1 Thanks, I've spot checked spme and it's the I...allocated Steve<br><br>-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: Monday, July 30, 2001 2:55 PM To: DB2-L@RYCI.COM Subject: Re: FW: Which indexspace is in use?<br><br><br><br><br><br>If this is DB2 version 6 or earlier DB2 will ONLY be using I0001 datasets. It is not until FASTSWITCH and DB2 V7 that datasets other than I0001 will be used (and then there'll only be J0001 alternatives). [...]
1950 116 60_JDBC ResultSet problems after implementing ConnectionPooling12_Bill Littman24_blittman@TOMOTHERAPY.COM31_Mon, 30 Jul 2001 14:19:43 -0500440_iso-8859-1 Here is my system:<br><br>Java applications performing CRUD functions (Create, Retrieve, Update, Delete) talking CORBA. CORBA servers written in Java talking to DB2 UDB 7.1. All Java is version 1.3.1. All boxes are on WinNT 4.0 or Win2000.<br><br>My Java CORBA Servers were setup to talk over one database connection using multiple PreparedStatements. This worked fine for the most part, except for some concurrency issues. [...]
2067 59 38_Re: Disaster Recovery Cat/Dir Recovery0_24_ujjwal@LOT.TATASTEEL.COM31_Mon, 30 Jul 2001 14:04:39 +0530293_iso-8859-1 Hi Lee , I think you can first Recover your Catalogs and Directory Tablespaces with ur latest imagecopies and then apply a LOGONLY so that u can Recover to the Current Point in Time with your Archive Logs provided ur BSDS is updated with the Latest Archive Log at the DR site. [...]
2127 78 33_Re: Problem with Decimal Rounding15_Bernie O'Connor26_Bernie.OConnor@ANIXTER.COM31_Mon, 30 Jul 2001 16:47:38 -0500874_us-ascii Phil --<br><br>Late last year we ran into a rounding error that we solved by first converting decimal columns to float and then converting the whole calculated result back to decimal. The example follows. I hope this helps you with your Scottish Widows.<br><br>Bernie bernie.oconnor@anixter.com ...just my opinions...<br><br>SQL: SELECT DEPRECIATION.BUSINESS_UNIT , DEPRECIATION.BOOK , DEPRECIATION.CATEGORY , DEPRECIATION.ASSET_ID , DEPRECIATION.COST_TYPE , DEPRECIATION.TRANS_TYPE , DEPRECIATION.DEPR , DEPR_ALLOC_TBL.FISCAL_YEAR , DEPR_ALLOC_TBL.PD_ALLOC , DEPR_ALLOC_TBL.PD_ALLOC_TOTAL , DEPR_ALLOC_TBL.ACCOUNTING_PERIOD, DECIMAL ( MIN(DEPRECIATION.DEPR* (FLOAT((DEPR_ALLOC_TBL.PD_ALLOC)) /FLOAT((DEPR_ALLOC_TBL.PD_ALLOC_TOTAL)))) ,9,6) FROM FSDEV.PS_DEPR_ALLOC_TBL DEPR_ALLOC_TBL, FSDEV.PS_DEPRECIATION DEPRECIATION, FSDEV. PS_BU_AM_BOOK_VW BU_AM_BOOK_VW [...]
2206 62 45_Re: Question regarding DMS space issue for NT21_Devineni, KishoreBabu29_KishoreBabu.Devineni@NIKE.COM31_Mon, 30 Jul 2001 14:48:37 -0700640_us-ascii The formula is (extent size * n) + 1 3 extents will be used for overhead and at least 2 extents needed for storing user tables.<br><br>Kishore<br><br><br><br>-----Original Message----- From: Jeremy Schleicher [mailto:Jeremy_Schleicher@MAY-CO.COM] Sent: Monday, July 30, 2001 9:16 AM To: DB2-L@RYCI.COM Subject: Question regarding DMS space issue for NT<br><br><br><br>I have the following DDL to create tablespaces. The one on the left fails with an error saying that it can't allocate space to create the pages. When I modify it to look like the one on the right it works. Is there a minimum on createing DMS tablespaces and [...]
2269 137 64_Re: JDBC ResultSet problems after implementing ConnectionPooling13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Tue, 31 Jul 2001 08:51:03 +1000466_iso-8859-1 Bill,<br><br>I'm very much a Java novice but it sounds as though you may be running out of cursors. This should throw an exception. Where do you close the resultset and the statement.<br><br>Greg Farquhar<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Bill Littman Sent: Tuesday, July 31, 2001 5:20 AM To: DB2-L@RYCI.COM Subject: JDBC ResultSet problems after implementing ConnectionPooling [...]
2407 15 33_John Ordman is out of the office.0_29_John_Ordman@READERSDIGEST.COM31_Tue, 31 Jul 2001 01:01:40 -0400389_us-ascii I will be out of the office starting 07/30/2001 and will not return until 08/03/2001.<br><br>I will respond to your message when I return.<br><br>================================================ 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.
2423 25 39_Peoplesoft on DB2 on OS/390 Experiences13_Jodi Murawski27_Jodi.Murawski@METAVANTE.COM31_Tue, 31 Jul 2001 00:56:23 -0500570_us-ascii We are looking to acquire Peoplesoft for DB2 on OS/390. I would appreciate hearing from people off-list on their experiences. I am interested in positive as well as negative experiences.<br><br><br><br>Thank You,<br><br>Jodi Murawski Technical Support, Database Administration<br><br>Metavante Corp.<br><br>414-577-9903<br><br>================================================ 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.
2449 27 19_Re: -904 / 00C9008013_Patric Becker25_Patric_Becker@SIS-WEST.DE31_Tue, 31 Jul 2001 02:48:18 -0500357_ISO-8859-1 Hi Chris !<br><br>Just some suggestions :<br><br>- Is this a repeatable situation ? - Did any Utility run in parallel which set the TS to RO mode for a couple of seconds ? - Is the job running in TSO-Batch or IMS environment (e.g. in IMS env. DB2-Commit doesn´t work at all). - Did anyone issue a -STO DB command with ACCES(RO) (why ever) ? [...]
2477 146 26_Re: FAROFFPOS vs FARINDREF14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 31 Jul 2001 09:14:14 +0100349_iso-8859-1 Resending due to db2-l telling me this was a duplicate(!)<br><br>Apologies if it is right and I am wrong.<br><br>We had some 'problems' a while ago when CA Database Analyzer was reporting different cluster rations to RUNSTATS. We were working out clustering the way we interpreted it and IBM were obviously doing it a different way. [...]
2624 49 26_Re: FAROFFPOS vs FARINDREF15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Tue, 31 Jul 2001 03:47:04 -0500679_iso-8859-1 You are right Phil, BMC also could not figure out exactly how IBM did the calculation. The difference is not large however.<br><br>Andy Lankester bmcsoftware My opinions are just that<br><br>-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: 31 July 2001 09:14 To: DB2-L@RYCI.COM Subject: Re: FAROFFPOS vs FARINDREF<br><br><br><br>Resending due to db2-l telling me this was a duplicate(!) Apologies if it is right and I am wrong. We had some 'problems' a while ago when CA Database Analyzer was reporting different cluster rations to RUNSTATS. We were working out clustering the way we interpreted it and IBM were obviously doing [...]
2674 47 0_9_Don Cross20_Don.Cross@TC.FAA.GOV31_Tue, 31 Jul 2001 07:29:41 -0400401_us-ascii Thanks ed..we could see that we had more than the one volume that was 97% full..we pared it back to the high 80% but the problem has occurred on 5 different datasets/tablespaces and each time DB2 abends.. DIAGNOSE says the same thing for each one.. UNCOMPLETED EXTEND DETECTED.. we are fairly certain it is not space.. i'll search for a PTF but has anyone else encountered this problem? [...]
2722 33 53_BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE"12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 31 Jul 2001 14:16:24 +0200350_iso-8859-1 Hello DB2-BIND-Gurus,<br><br>one of our programmers wanted to bind 42 packages into a collection. Most of the packages came out with SUCCESSFUL BIND. But some of the DBRM's to bind failed with "DBRM IS IN AN INCONSISTENT STATE".<br><br>Someone able to give me a good advice ?<br><br>Thanks in advance for your time and consideration. [...]
2756 34 27_DB2 V7.1 + CA/EZTRIEVE Plus14_Winston Mangum26_Winston_Mangum@LABCORP.COM31_Tue, 31 Jul 2001 08:20:19 -0400338_US-ASCII I have DB2 V7.1 installed into my test LPAR. We also have CA-EZTRIEVE Plus V6.3 (PAN-SQL 2.4.B) installed. On ANY select from any table, we are getting the following:<br><br>DSNT408I SQLCODE = -302, ERROR: THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER 001 IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET VALUE [...]
2791 191 48_Bonnie Baker at SIRDUG (Charlotte, NC) 8/23-8/2411_Paul Turpin32_pault@ALUMMAIL.SSB.ROCHESTER.EDU31_Tue, 31 Jul 2001 07:19:30 -0500653_- SIRDUG Southeastern Inter-Relational Database Users' Group P.O. BOX 34641 Charlotte, NC 28234<br><br>Website: http://users.vnet.net/sirdug Email: SIRDUG@VNET.NET Information/Message Line: (704) 556-6621<br><br><br><br>Educational Seminar Announcement ================================================================ WHEN? Thursday, August 23th & Friday, August 24th<br><br>WHERE? IBM Harris Blvd facility (Charlotte, NC) See directions below<br><br>COST? $175 each day cash or check, in advance or at the door. We do not invoice and we do not accept credit cards. (The two seminars are separate so you are welcome to attend one or both seminars) [...]
2983 29 34_UDB and Archive Logging (USEREXIT)14_Bill Gallagher28_BILL.GALLAGHER@PHOENIXWM.COM31_Tue, 31 Jul 2001 08:40:34 -0400555_us-ascii We've been using archive logging and the "db2uext2" user exit for archiving our log files to TSM for quite some time with pretty good success. However, yesterday something stopped working and the db2uext2 exit started failing. We stopped and restarted the instance, which seems to have cleared up the problem as new archive logs started getting archived to TSM. But all the older log files for which the userexit failed are still residing on disk, and are not being archived to TSM. This is causing us space problems for these file systems. [...]
3013 126 57_Re: BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE"0_29_sflindsey@HIGHLIGHTS-CORP.COM31_Tue, 31 Jul 2001 08:44:40 -0400465_us-ascii <br><br><br><br>Assuming that the error message is DSNT231I, here is the information from the messages and codes manual for V5 OS/390 -------------------------------------------- DSNT231I BIND DBRM ERROR USING auth-id AUTHORITY object-type = object-name DBRM dbrm-name IS IN AN INCONSISTENT STATE<br><br>Explanation: The contents of a DBRM have been modified after the precompilation process, or the DBRM contains incorrect information in the header. [...]
3140 74 31_AW: DB2 V7.1 + CA/EZTRIEVE Plus12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 31 Jul 2001 14:50:14 +0200354_iso-8859-1 Winston,<br><br>the -302 SQLCODE has two meanings.<br><br>If SQLSTATE 22001: The value of an input variable is invalid for the specified column. IF SQLSTATE 22003: The value of an input variable is to large for the specified column.<br><br>Take a look at the column that is in doubt and another look at the variable that causes the -302. [...]
3215 26 25_Idiots assembler question10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 31 Jul 2001 07:47:14 -0500535_- Dear List,<br><br>I'm trying to write an assembler program to access DB2 data (my first one!) and I'm failing at the first hurdle :-(<br><br>The assembler puts out the following message when it comes across the statement EXEC SQL OPEN cursor<br><br>ASMA044E *** ERROR *** Undefined symbol - SQLPLLEN It also complains about various other symbols such as SQLSTNUM. It looks like I'm missing a macro or copybook, but I can't find them mentioned in the SDSNMACS or SDSNSAMP datasets. My question is, how do I define these symbols? [...]
3242 101 57_AW: BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE"12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 31 Jul 2001 14:56:47 +0200500_iso-8859-1 Scott,<br><br>thanks for the information you have provided.<br><br>I have just found out that the programs have been modified after the precompile process.<br><br>Again: Thank you.<br><br>With kind regards - mit freundlichen Grüssen, Georg<br><br>-----Ursprüngliche Nachricht----- Von: sflindsey@HIGHLIGHTS-CORP.COM [mailto:sflindsey@HIGHLIGHTS-CORP.COM] Gesendet am: Dienstag, 31. Juli 2001 14:45 An: DB2-L@RYCI.COM Betreff: Re: BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE" [...]
3344 20 23_DB2 extenders on OS/39014_Craig McKellar26_craig.mckellar@BIGPOND.COM31_Tue, 31 Jul 2001 23:03:16 +1000345_us-ascii Are people aware that extenders do not work in a data sharing environment? I notice there is an APAR that states this. Has anyone tried or found a way that works? It is a concern to our clients as we do not have a non data sharing prod environment and this will impose restrictions on the use of LOBS. Open for comments /feedback. [...]
3365 62 57_AW: BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE"4_info28_info@EDV-BERATUNG-CORSTEN.DE31_Tue, 31 Jul 2001 14:53:26 +0200518_iso-8859-1 Hi Georg, I think it might be this<br><br>DSNT231I BIND DBRM ERROR USING auth-id AUTHORITY object-type = object-name DBRM dbrm-name IS IN AN INCONSISTENT STATE Explanation: The contents of a DBRM have been modified after the precompilation process, or the DBRM contains incorrect information in the header.<br><br>Mit freundlichen Grüssen<br><br>Ernst Corsten EDV-Beratung Corsten GmbH Alexanderstr.19 D-28203 Bremen mailto:ernst.corsten@edv-beratung-corsten.de Telefon +49-421-73085 Fax +49-421-73086 [...]
3428 92 35_Re: AW: DB2 V7.1 + CA/EZTRIEVE Plus14_Winston Mangum26_Winston_Mangum@LABCORP.COM31_Tue, 31 Jul 2001 09:05:23 -0400381_ISO-8859-1 I know what the -302 means. I have tried using various combinations of the columns in the table with the same -302. CA is stumped as well. I was just asking if anyone had V7.1 working with EZTRIEVE 6.3.<br><br>Thanks, Winston<br><br>Winston L. Mangum Laboratory Corporation of America 1912 Alexander Drive RTP, North Carolina 27709 919-572-7509 mangumw@labcorp.com [...]
3521 29 22_DRS strategy for logs.14_Craig McKellar26_craig.mckellar@BIGPOND.COM31_Tue, 31 Jul 2001 23:17:48 +1000599_us-ascii I am interested to hear others comments on supporting a DRS strategy of maintaining active logs across sites. Without major expenses including introducing disk mirroring and GPDS we want to maintain maximun 2 hours data loss for recovery at a remote site. All our image copies and archives currently are stored on the remote sites shared storage. To provide further guarantee of meeting our requirement and offering more I am wondering why we couldn't maintain one set of the active logs at the remote site. This would give current point in time recovery. In the event of a failure at [...]
3551 141 53_BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE"32_Atalay Tanis (Garanti Teknoloji)22_AtalayT@GARANTI.COM.TR31_Tue, 31 Jul 2001 16:14:36 +0300272_iso-8859-1 I don't know why but DB2 requires the DBRM member name be the same with the package name that is in the DBRM body. If you browse the DBRM member you will see the package name in the 17th col of the 1st line. Could you have the DBRM module renamed somehow? [...]
3693 132 29_Re: Idiots assembler question12_David Booher22_David.Booher@QUEST.COM31_Tue, 31 Jul 2001 06:18:33 -0700499_iso-8859-1 Are you pre-processing the code? See the book: Application Programming & SQL Guide SC26-9004-00. I found this book to be very useful as it covers running SQL from various languages.<br><br>See the link: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/library<br><br>Dave Booher Quest Software<br><br><br><br>-----Original Message----- From: Steve Lamb [mailto:steve.lamb@POWERGEN.CO.UK] Sent: Tuesday, July 31, 2001 7:47 AM To: DB2-L@RYCI.COM Subject: Idiots assembler question [...]
3826 20 27_BMC to pay for v7 utilities13_Gerald Thomas23_gthomas0308@HOTMAIL.COM31_Tue, 31 Jul 2001 13:23:27 +0000564_- Well, we now know what BMC is doing about IBM's priced utilities. It appears that they are buying them for us.<br><br>http://biz.yahoo.com/bw/010730/0154.html<br><br>Gerald<br><br>_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp<br><br>================================================ 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.
3847 48 29_Re: Idiots assembler question10_Dennis Cho22_dennis.cho@MANTECH.COM31_Tue, 31 Jul 2001 09:28:25 -0400409_iso-8859-1 Steve, It has been a while since doing this but it sounds like the missing symbols should be supplied by the DB2 preprocessor. Were there any errors from the preprocessor step? Dennis<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] On Behalf Of Steve Lamb Sent: Tuesday, July 31, 2001 8:47 AM To: DB2-L@RYCI.COM Subject: Idiots assembler question [...]
3896 38 29_Re: Idiots assembler question10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 31 Jul 2001 08:27:33 -0500346_- Dave,<br><br>Yes, I am using the preprocessor (I'm running the code through the supplied JCL proc DSNHASM). I've looked at the manuals but can't find any sample programs in them. The DSNTIAUL and DSNTIAD programs are different of course, so I didn't really see how I could base my program on them. The pre- processor options I'm using are [...]
3935 31 0_22_Vadavalli, Sirish B23026_Sirish.Vadavalli@CIGNA.COM31_Tue, 31 Jul 2001 09:29:22 -0400473_us-ascii Hi All..<br><br>I have a question much to do with the referential integrity in db2. I have a parent table and 2 child tables in a RI delete restrict relationship. All the 3 are very big tables. When I do a delete on the PARENT TABLE with a particular where predicate using 2 columns which are also primary key of the table - it is ok, but as both of those columns are not keys or indexes of the 2 child tables, there is a tablespace scan on the child tables. [...]
3967 228 52_Re: Bonnie Baker at SIRDUG (Charlotte, NC) 8/23-8/2418_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Tue, 31 Jul 2001 19:11:28 +0530347_- Hi,<br><br>Wish I could fly there from my current location in India. I have been a DB2MAG reader for the last 2 years and always look forward to getting the next issue. I greatly value the 'Programmers only' section for the incisive articles by Bonnie Baker....many thanks to her. My bond with DB2 seems to increase with every passing day. [...]
4196 228 52_Re: Bonnie Baker at SIRDUG (Charlotte, NC) 8/23-8/2418_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Tue, 31 Jul 2001 19:11:50 +0530343_- Hi,<br><br>Wish I could fly there from my current location in India. I have been a DB2MAG reader for the last 2 years and always look forward to getting the next issue. I greatly value the 'Programmers only' section for the incisive articles by Bonnie Baker....many thanks to her. My bond with DB2 seems to grow with every passing day. [...]
4425 119 29_Re: Idiots assembler question32_Atalay Tanis (Garanti Teknoloji)22_AtalayT@GARANTI.COM.TR31_Tue, 31 Jul 2001 16:43:40 +0300452_iso-8859-1 Did you include the SQLCA in your program?<br><br>-----Original Message----- From: David Booher [mailto:David.Booher@QUEST.COM] Sent: Tuesday, July 31, 2001 4:19 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Idiots assembler question<br><br><br><br><br><br>Are you pre-processing the code? See the book: Application Programming & SQL Guide SC26-9004-00. I found this book to be very useful as it covers running SQL from various languages. [...]
4545 108 27_DB2 Control Center defaults15_Donnie Woodruff30_dwoodruf@CI.NEWPORT-NEWS.VA.US31_Tue, 31 Jul 2001 09:45:00 -0400587_Windows-1252 DB2L'ers:<br><br>I am currently looking at using the DB2 Control Center (part of DB2 Connect v7.1 install) with DB2 v6 of OS390 to create and administer objects within DB2.<br><br>First of all, how many of you are using the DB2 Control Center to administer your OS390 DB2's?<br><br>And finally, I would like to be able to default some of the check boxes or text boxes with values on the Create TableSpace, Index, and/or Table frames. Does anyone know if this is possible? I realize it is possible to extend the Control Center by adding JAVA apps to the toolbar, etc... [...]
4654 39 34_Re: Data manipulation during load?0_20_Jones.H@GRAINGER.COM31_Tue, 31 Jul 2001 08:47:00 -0500538_- Thanks for the ideas, but I don't think we've hit it yet. Here are the solutions proposed so far: 1. Edit the input with and edit macro. Good idea, but it's 13 million rows on tape. 2. Append the extra zero when unloading. Another good idea, but the tapes are coming from an outside source. They are not unloaded. 3. Alter the syspunch. Yes, that's what I had in mind. But I'm asking if it is possible. How would you code that? 4. Change SYSPUNCH to DECIMAL EXTERNAL(9) and DB2 will append a blank to the front. Two problems here. [...]
4694 81 22_Re: RI Tablespace Scan0_29_sflindsey@HIGHLIGHTS-CORP.COM31_Tue, 31 Jul 2001 09:55:40 -0400411_us-ascii You are correct. Putting indexes on the child table fields that are RI'd to the parent will fix the problem. I ran into the same problem within the past couple of months. I do not know of any other solution.<br><br>Scott Lindsey Sr. DBA, Highlights for Children<br><br><br><br><br><br><br><br><br><br><br><br><br><br>"Vadavalli, Sirish B230" <Sirish.Vadavalli@CIGNA.COM> on 07/31/2001 09:29:22 AM [...]
4776 75 31_Re: BMC to pay for v7 utilities16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM31_Tue, 31 Jul 2001 15:00:16 +0100408_us-ascii and to think of all the sleepless nights trying to work out which set of tools to buy.....<br><br>but has anybody read the article through? sounds more like a "pay 2 buy 3" offer... ;-)<br><br>Ciao!<br><br>Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.<br><br>Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com [...]
4852 83 29_Re: Idiots assembler question16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 31 Jul 2001 15:03:42 +0100386_us-ascii Steve,<br><br>I assume you're going through the pre-processor, so the first question that springs to mind is did you include the SQLCA in your program?<br><br>HTH.<br><br>Ciao!<br><br>Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.<br><br>Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com [...]
4936 49 47_Re: Data to be converted in Uppercase in DB2 V512_Rakesh Kumar21_rakesh457@HOTMAIL.COM31_Tue, 31 Jul 2001 14:04:53 +0000240_- I think I will take a dig at this .There is no UPPERCASE function in DB2 V5 and so there is no straight forward way.May be u will have to upgrade to DB2 V6 or DB2 V7 but then please check with Santa Teresa Labs if it is there in V6. [...]
4986 32 29_Re: Idiots assembler question10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 31 Jul 2001 08:54:47 -0500477_- Yes, I have included the SQLCA, but I don't know if I'm putting things in in the "right" order. The way I've got them is like this:<br><br>EXEC SQL INCLUDE SQLCA EXEC SQL INCLUDE SQLDA host variable declarations EXEC SQL DECLARE CURS01 CURSOR FOR xxx EXEC SQL OPEN CURS01 EXEC SQL FETCH CURS01 INTO host variables EXEC SQL WHENEVER SQLERROR GO TO EXECERR EXEC SQL WHENEVER SQLWARNING GO TO EXECWRN EXEC SQL WHENEVER NOT FOUND GO TO CLOSEIT ... EXEC SQL CLOSE CURS01 ... [...]
5019 28 37_SQL Stored Proc - Can it be unfenced?15_Sangeet Khullar20_db2khullar@YAHOO.COM31_Tue, 31 Jul 2001 07:21:57 -0700598_us-ascii Hi<br><br>I have one question. Is it possible to create an unfenced sql stored procedure in UDB V7.1 .??<br><br><br><br><br><br>Thanks<br><br>Sangeet Khullar<br><br><br><br><br><br>__________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/<br><br>================================================ 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.
5048 88 29_Re: Idiots assembler question16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 31 Jul 2001 15:22:13 +0100355_us-ascii Apart from noticing that the WHENEVERs seem to be at the bottom of the program, everything seems to be in the right order.<br><br>do you not see the SQLCA and the "missing" fields expanded in the output of the pre-processor? I'm off to get my manual, btw...<br><br>Ciao!<br><br>Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. [...]
5137 17 34_Re: Data manipulation during load?15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Tue, 31 Jul 2001 16:25:33 +0200329_us-ascii I don't suppose you want to entertain doing the load without the 0, then unloading with an appended 0 and reloading ?<br><br>Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be those of Sanlam, to whom no liability shall attach whatsoever. [...]
5155 75 34_Re: Data manipulation during load?15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Tue, 31 Jul 2001 10:28:45 -0400290_iso-8859-1 Hayden, How about a small program such as COBOL with input and output file where you can use a move corresponding from input area to output area where fields are defined the same except for the field in question is defined as: input : pic comp-3(?) s9(9) output : pic 9(10) [...]
5231 77 29_Re: Idiots assembler question19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 31 Jul 2001 09:31:12 -0500472_ISO-8859-1 Hi Steve, need table declaration, see last paragraph below . . .<br><br>DSNH050I I csectname WARNINGS HAVE BEEN SUP-PRESSED DUE TO LACK OF TABLE DECLA-RATIONS<br><br>Explanation: One or more warning messages were sup-pressed because no table declarations were found before the first SQL statement that referenced a table or column.<br><br>Severity: 0<br><br>System Action: Processing continues. Suppression is discontinued if a table declaration is found. [...]
5309 108 31_Re: BMC to pay for v7 utilities9_Ray Janes26_ray.h.janes@EXXONMOBIL.COM31_Tue, 31 Jul 2001 09:23:38 -0500421_us-ascii Agree, BMC is refunding your cost of the add-on utilities. Well, I think if you are a "Good" BMC (or CA) customer, you won't buy those anyway, as why have two of something? But it will lower your cost of ownership.<br><br><br><br><br><br>"Aurora Dell'Anno" <Aurora_DellAnno@C To: DB2-L@RYCI.COM ANDLE.COM> cc: Sent by: DB2 Data Subject: Re: BMC to pay for v7 utilities Base Discussion List <DB2-L@RYCI.COM> [...]
5418 11 25_Connecting DB2 and Oracle16_Bernard Greenman27_Bud.Greenman@ONONDAGA.NY.US31_Tue, 31 Jul 2001 10:37:00 -0400386_- Are there any other products that can be used to connect DB2 and Oracle databases other than IBM's Datajoiner or Oracle's Transparent Gateway?<br><br>================================================ 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.
5430 18 29_Re: Idiots assembler question10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 31 Jul 2001 09:31:38 -0500465_- Hi again,<br><br>I can see the expansion of the SQLCA in the output from the assemble step, but there's no mention of SQLPLLEN or SQLSTNUM in it or in the output from the precompile step,<br><br>Regards,<br><br>Steve Lamb<br><br>================================================ 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.
5449 29 29_Re: Idiots assembler question13_Harry Woelfer27_Harry_Woelfer@MCCORMICK.COM31_Tue, 31 Jul 2001 10:46:00 -0400518_us-ascii Steve:<br><br>The symbols SQLPLLEN and SQLSTNUM are part of SQLDSECT. The pre-processor is supposed to generate the SQLDSECT at the end of your program. As the name implies, it is a DSECT. You have to allocate memory for the SQLDSECT and establish addressability for it. The pre-processor inserts a field at the end of your program, as part of your CSECT, called SQLDSIZ. This tells you how much memory to allocate for the SQLDSECT. You can see examples of all this in the sample programs like DSNTIAUL. [...]
5479 90 34_Re: Data manipulation during load?0_29_sflindsey@HIGHLIGHTS-CORP.COM31_Tue, 31 Jul 2001 10:50:29 -0400372_us-ascii I cannot think of anyway to modify the load cards to take care of the situation without having another pass of the data either before the load or after the load.<br><br>Another option before the load would be to use a sort with an OUTREC control statement that would add the '0' where it belongs in the input record. The load cards would not have to change. [...]
5570 49 43_Re: Peoplesoft on DB2 on OS/390 Experiences14_Michael Vanner19_mvanner@CANTIRE.COM31_Tue, 31 Jul 2001 10:52:18 -0400522_us-ascii Although I am not directly responsible for Peoplesoft, I work closely with the people that are. We have the GL and AP components of Peoplesoft on DB2 for OS/390 V5.1. We have invested a considerable amount of time, money and effort into tuning and support. We have spent a fortune on consultants and have outsourced support to IBM Global Services (for Peoplesoft production). The outsourcing was the users idea and I don't believe they have achieved any better results than we did... just one man's opinion. [...]
5620 27 29_Re: Idiots assembler question12_Edmund Vosik22_Ed.Vosik@RELIASTAR.COM31_Tue, 31 Jul 2001 10:06:48 -0500435_us-ascii Do you have an END statement? If you don't, the precompiler won't generate these symbols.<br><br>Steve Lamb wrote:<br><br>> Dear List, > > I'm trying to write an assembler program to access DB2 data (my first one!) > and I'm failing at the first hurdle :-( > > The assembler puts out the following message when it comes across the > statement EXEC SQL OPEN cursor > > ASMA044E *** ERROR *** Undefined symbol - SQLPLLEN > [...]
5648 21 29_Re: Idiots assembler question10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 31 Jul 2001 09:52:08 -0500427_- Hi All,<br><br>Erm, I think I've now found my error (notice the word "my"!). On looking at the output from my job more thoroughly, I noticed a message saying there was no END statement. I put one in and all the ASMA044E messages disappeared as if by magic. Please accept my apologies for wasting everybody's time! Thanks for all the help and suggestions from everybody on this one and Jeff Schade for his sample pogram. [...]
5670 87 22_Amazing -204 error !!!11_Manish Lall17_db2list@YAHOO.COM31_Tue, 31 Jul 2001 08:14:59 -0700332_us-ascii Hi All,<br><br>Well i never came across such a problem before , We are on os/390 v2.6 , DB2 V 4.1 , We want to a drop a table but it gives error -204 tablename Undefined Name.The Table exist , the entry is in the catalog table , we can query the table but when we want to drop it it gives -204 . How can that happen . [...]
5758 19 41_Re: SQL Stored Proc - Can it be unfenced?11_Rick Rogers21_Rick.Rogers@TELUS.COM31_Tue, 31 Jul 2001 09:17:44 -0600523_iso-8859-1 In UDB 7.1 on AIX unfenced SPs are not supported. IBM intends to remedy this (according to the Canadian IBM Lab folks) in the future. They were, of course, still hesitant to recommend the use of unfenced SPs once supported.<br><br>Rick Rogers Software Architechnics Inc.<br><br>================================================ 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.
5778 106 64_Re: SQL in an Assembler program (was: Idiots assembler question)16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 31 Jul 2001 16:21:45 +0100413_us-ascii As I said,<br><br>I was going back to the manuals....<br><br>onto the serious questions:<br><br>have you got the precompiler set to STDSQL(YES)? If so, do not define an SQLCA or your definition will cause compile-time errors If your program is re-entrant, you must include the SQLCA within a unique data area acquired for your task (a DSECT). For example, at the beginning of your program, specify: [...]
5885 73 57_AW: BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE"4_info28_info@EDV-BERATUNG-CORSTEN.DE31_Tue, 31 Jul 2001 14:53:26 +0200518_iso-8859-1 Hi Georg, I think it might be this<br><br>DSNT231I BIND DBRM ERROR USING auth-id AUTHORITY object-type = object-name DBRM dbrm-name IS IN AN INCONSISTENT STATE Explanation: The contents of a DBRM have been modified after the precompilation process, or the DBRM contains incorrect information in the header.<br><br>Mit freundlichen Grüssen<br><br>Ernst Corsten EDV-Beratung Corsten GmbH Alexanderstr.19 D-28203 Bremen mailto:ernst.corsten@edv-beratung-corsten.de Telefon +49-421-73085 Fax +49-421-73086 [...]
5959 34 29_Re: Connecting DB2 and Oracle12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 31 Jul 2001 08:25:39 -0700600_us-ascii Check out EDA from Information Builders...the folks who brought you FOCUS. It goes to/from just about any data source/target. Tim --- Bernard Greenman <Bud.Greenman@ONONDAGA.NY.US> wrote: > Are there any other products that can be used to > connect DB2 and Oracle > databases other than IBM's Datajoiner or Oracle's > Transparent Gateway? > > ================================================ > 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. [...]
5994 77 29_Re: Idiots assembler question16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Tue, 31 Jul 2001 16:29:43 +0100419_us-ascii Plus - I am working in instalments here....<br><br>I forgot to mention, or rather quote, that "You can precede the assembler statements that define host variables with the statement BEGIN DECLARE SECTION, and follow the assembler statements with the statement END DECLARE SECTION. You must use the statements BEGIN DECLARE SECTION and END DECLARE SECTION when you use the precompiler option STDSQL(YES)". [...]
6072 54 31_Re: DB2 Control Center defaults13_Diane Bittner30_dbittner@CI.NEWPORT-NEWS.VA.US31_Tue, 31 Jul 2001 11:40:07 -0400
6127 75 26_Re: DRS strategy for logs.9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 31 Jul 2001 16:40:06 +0100347_us-ascii We use that strategy at this site. The BSDSs, Active Logs, Archive Logs are split (by version) across both sites. Disaster Recovery strategy is then to reduplex the BSDS and Active Logs and recover the Catalog/Directory to current PIT. We have tested this without any problems. Kind Regards, Andy Hunt - Scottish And Southern Energy [...]
6203 25 32_How many relations are too many?14_Greg DiGiorgio29_gdigior@CI.NEWPORT-NEWS.VA.US31_Tue, 31 Jul 2001 11:44:47 -0400563_us-ascii Assume that I have a parent table with 12 child tables using CASCADE DELETE. Each child table has 1..n (where "n" is unlimited) related rows back to a single parent row.<br><br>When is the number of child tables too many? At which point do I ask for a design review to see if this parent table can be further normalized, thereby risking a large development effort that is already underway? There would be reprecussions to redesigning at this point (it'snot necessary to tell me that we should have done a better job of design - we understand that). [...]
6229 28 31_Re: BMC to pay for v7 utilities12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Tue, 31 Jul 2001 10:50:30 -0500429_us-ascii I suggest that one read the fine print. This will give you the complete set of IBM Utilities as part of the purchase price of the BMC utilities, but... The purpose of the IBM offering was to lower the total cost of ownership as it relates to mainframe costs. With this deal your cost of ownership is still controlled by BMC! Additionally, check the fine print about how many OTHER products you are expected to buy? [...]
6258 19 32_Data from UDB(NT) to UDB(OS/390)11_jim keister22_jkeister@ALTAVISTA.NET30_Wed, 1 Aug 2001 00:01:38 +080098_iso-8859-1 Does anyone have a recommendation on how to transfer data from UDB(NT) to UDB(OS/390)??
6278 14 36_Re: How many relations are too many?11_Rick Rogers21_Rick.Rogers@TELUS.COM31_Tue, 31 Jul 2001 10:11:46 -0600385_iso-8859-1 Are you primarily concerned with the cascade delete or more generally concerned with the applications using the model you described?<br><br>================================================ 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.
6293 139 26_Re: Amazing -204 error !!!9_Ray Janes26_ray.h.janes@EXXONMOBIL.COM31_Tue, 31 Jul 2001 10:56:08 -0500567_us-ascii We used to have this on QMF work datasets (used to save off query data). Here was our problem and solution. The VSAM dataset was subject to migration and then DELETION after some period of time. Users not saving data would eventually lose their dataset. Well, DB2 didn't know HSM migrated and then deleted the dataset and BANG -204 when the poor user tried to save data. See our GOOD users (those not saving the world on every query) would get hurt. Solution? Best I remember, we could IDCAMS build a new dataset, then DROP or change the objects. Might [...]
6433 57 36_Re: How many relations are too many?13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Tue, 31 Jul 2001 11:06:19 -0600347_- It depends on the workload and number of concurrent users. It be adequate as currently designed.<br><br>Once in production, if you're hitting locking problems due to escalation or long running LUW's, these would force users to change the way they do business. But they may prefer just spreading the workload around the clock to a redesign. [...]
6491 22 36_Re: How many relations are too many?14_Greg DiGiorgio29_gdigior@CI.NEWPORT-NEWS.VA.US31_Tue, 31 Jul 2001 13:12:13 -0400418_us-ascii Rick Rogers wrote:<br><br>> Are you primarily concerned with the cascade delete or more generally > concerned with the applications using the model you described?<br><br>I am really not interested in the type of relattion - Cascade Delete, etc as much knowing where to stop with the number of child tables under a parent table, considering each child table may also be a parent to another set of tables. [...]
6514 48 36_Re: How many relations are too many?11_David Nance16_DWNance@FHSC.COM31_Tue, 31 Jul 2001 13:15:24 -0400549_US-ASCII Greg, If you will be doing deletes on the parent row you will definitely want to consider deleting the children rows first, especially if any one of the tables are high online usage. Also, make sure you have the appropriate indexes in place.<br><br>Dave Nance First Health Services, Corp. (804)527-6841<br><br>>>> gdigior@CI.NEWPORT-NEWS.VA.US 07/31/01 11:44AM >>> Assume that I have a parent table with 12 child tables using CASCADE DELETE. Each child table has 1..n (where "n" is unlimited) related rows back to a single parent row. [...]
6563 71 34_Re: Data manipulation during load?9_Wu, James13_jwu@KRAFT.COM31_Tue, 31 Jul 2001 12:23:40 -0500483_iso-8859-1 Hayden,<br><br>You can load the table first then update the table with update table set col = '0'||col<br><br>If you were in V6 you could also use triggers to do the samething in one step.<br><br><br><br><br><br>James Wu:-) (847)646-5548 jwu@kraft.com<br><br><br><br><br><br><br><br>-----Original Message----- From: Jones.H@GRAINGER.COM [mailto:Jones.H@GRAINGER.COM] Sent: Tuesday, July 31, 2001 8:47 AM To: DB2-L@RYCI.COM Subject: Re: Data manipulation during load? [...]
6635 35 25_PeopleSoft DEC31 question14_Jean W Stimmel25_jwstimmel@DUKE-ENERGY.COM31_Tue, 31 Jul 2001 13:51:06 -0400426_us-ascii We are running PeopleSoft HR/Financials on DB2 OS/390 platform and we are currently in initial stages of upgrading to PS v 8.0 (from v 7.5) for Financials.<br><br>We have run into a problem trying to create views in our PS v 8.0 Financials DMO instance. There are 80 views that won't allow themselves to be created due to getting SQL code -419 (they contain arithmetic statements including division statements). [...]
6671 81 34_Re: Data manipulation during load?16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Tue, 31 Jul 2001 10:54:24 -0700524_iso-8859-1 How about IEBENER? Copy the input file, inserting a literal '0', then change the SYSPUNCH to match the new layout.<br><br>//IEBGENER EXEC PGM=IEBGENER //SYSPRINT DD SYSOUT=* //SYSUT1 DD DATA 1234567890 /* //SYSUT2 DD SYSOUT=* //SYSIN DD DATA GENERATE MAXLITS=10,MAXNAME=10,MAXFLDS=10 RECORD FIELD=(5,1,,1), FIELD=(1,'-',,6), FIELD=(5,6,,7) /*<br><br>Output: 12345-67890<br><br>Tony Provenzola Nike Database Services BEST Consulting * Phone: 503-532-0772 * Fax: 503-532-2618 * Email: Tony.Provenzola@nike.com [...]
6753 34 24_Global temporary tables.11_Rick Rogers21_Rick.Rogers@TELUS.COM31_Tue, 31 Jul 2001 11:55:41 -0600582_iso-8859-1 Is anyone out there using mid-sized global temp tables on AIX?<br><br>Preamble on the objective: We are using them as a temporary storage location for the result sets of SQL which extracts data from our data store. We then calculate some simple statistics on the result set via the temporary table and export the result set and statistics. These two files are transfered to the data warehouse at our site, where the statistics are used to verify that what was sent is what was received and processed. A daily job extracts between 10k and 50k result set rows from up [...]
6788 24 36_Re: How many relations are too many?11_Rick Rogers21_Rick.Rogers@TELUS.COM31_Tue, 31 Jul 2001 12:09:22 -0600591_iso-8859-1 You may also want to look at the typical queries that will be used against these tables.<br><br>If the norm is that applications will be performing joins against more than one child table, the complexity of the application joins may end up being the driving concern. I'm guessing (perhaps wrongly) that the model is not a star schema, with the child tables actually being the dimensions of the parent fact table. If it is not a star schema, the data may be highly correlated between the child tables, requiring the developers to produce some fairly complex SQL just to avoid [...]
6813 190 26_Re: Amazing -204 error !!!11_Manish Lall17_db2list@YAHOO.COM31_Tue, 31 Jul 2001 11:32:31 -0700561_us-ascii I checked the VSAM datasets they are not migrated .Any more suggestion ??<br><br>Thanks, Manish --- Ray Janes <ray.h.janes@EXXONMOBIL.COM> wrote: > We used to have this on QMF work datasets (used to > save off query data). > Here was our problem and solution. The VSAM > dataset was subject to > migration and then DELETION after some period of > time. Users not saving > data would eventually lose their dataset. Well, DB2 > didn't know HSM > migrated and then deleted the dataset and BANG -204 > when the poor user > tried to save data. See our [...]
7004 24 8_DB2 Jobs10_Tim Miller17_njironman@USA.NET31_Tue, 31 Jul 2001 12:42:35 -0400429_iso-8859-1 Hello Everyone,<br><br>I am looking for a new job, my background is both in application development and Database administration (OS/390 DB2 and DB2 UDB on NT/Solaris). I have 20 years of experience, looking for jobs in the New Jersey area, anyone know of any openings, please send email to njironman@usa.net.<br><br>Thanks,<br><br>Tim Miller IBM Certified DB2 UDB Database Administrator and Application Developer [...]
7029 170 64_Re: SQL in an Assembler program (was: Idiots assembler question)12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 31 Jul 2001 21:47:40 +0200779_iso-8859-1 Hi,<br><br>Something in the line of: * ********************************************************************** * * * DECLARE VARIABLES, WORK AREAS * * * ********************************************************************** PROGAREA DSECT WORKING STORAGE FOR THE PROGRAM SAVEAREA DS 18F SAVEAREA FOR USE BY CALLED RTNS RETCODE DS H'0' RETURN CODE VALUE = 0 (DEFAULT) RETERR4 DC H'4' RETURN CODE VALUE = 4 RETERR8 DC H'8' RETURN CODE VALUE = 8 GETLENTH DS A GETMAIN LENGTH FOR THIS AREA DATAADDR DS A ADDRESS OF DATA * ********************************************************************** * * * DEFINE SQL COMMUNICATION AREA * * ********************************************************************** * EXEC SQL INCLUDE SQLCA * CNOP 0,4 * ERRM001 DC CL60' MY ERROR [...]
7200 48 29_Re: PeopleSoft DEC31 question13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 31 Jul 2001 13:59:09 -0500485_iso-8859-1 We hit a handful of -419's when installing V8 that didn't go away unless we were running with DECDIV3=YES (which has since been overridden by the MINDVSCL requirement). Short of this, you can also usually resolve -419 sqlcodes by using the DECIMAL function in the view definition.<br><br>Mike. -----Original Message----- From: Jean W Stimmel [mailto:jwstimmel@DUKE-ENERGY.COM] Sent: Tuesday, July 31, 2001 12:51 PM To: DB2-L@RYCI.COM Subject: PeopleSoft DEC31 question [...]
7249 14 26_Re: Amazing -204 error !!!0_26_truman.g.brown@VERIZON.COM31_Tue, 31 Jul 2001 14:51:50 -0400416_us-ascii If the datasets are there, make sure you're using the proper qualifiers, etc. You might want to check your catalogs and see if entries for the datasets are there ...<br><br>================================================ 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.
7264 66 34_Re: Data manipulation during load?12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 31 Jul 2001 22:05:17 +0200484_Windows-1252 Hi, Use sort to read the data from the tape while appending '0' at the correct place, output to a new file and tehn use it for the load.<br><br>Isaac Yassin DBMS & IT Consultant IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 yassini@bezeqint.net<br><br>----- Original Message ----- From: <Jones.H@GRAINGER.COM> Newsgroups: bit.listserv.db2-l To: <DB2-L@RYCI.COM> Sent: Tuesday, July 31, 2001 3:47 PM Subject: Re: Data manipulation during load? [...]
7331 15 29_Re: Binding from USS on S/39012_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 14:16:45 -0500528_- There is an old red book that describes the process a bit. It's Porting Applications to the OpenEdition MVS Platform, GG24-4473. There is also some interesting information and some tools on the web, http://www.ibm.com/servers/eserver/zseries/zos/unix/bpxa1sql.html<br><br>Roger Miller<br><br>================================================ 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.
7347 14 47_Re: Data to be converted in Uppercase in DB2 V512_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 14:50:30 -0500462_- It sounds as though you may be translating the whole file, a mix of binary, decimal and character data. If so, then you have to avoid tranlation of the numeric data or change it to character format.<br><br>Roger Miller<br><br>================================================ 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.
7362 31 57_Re: BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE"15_Philippe Herman20_pherman@LANDMARK.COM31_Tue, 31 Jul 2001 16:10:44 -0400512_us-ascii Gruess Gott Georg,<br><br>Looks like there is a desynchroniszation between what was done during the last precompile step and during the bind or rebind.<br><br>Most of the time, somebody changes the program without going back through the pre compile step.<br><br>Try to re- precompile and bind in one shot<br><br>Hope this helps<br><br><br><br>Philippe Herman Senior Consultant Landmark Systems Benelux Tel: +32 (0)3 890 46 05 Fax: +32 (0)3 890 46 05 Mobile: 32 (0)476 26 02 21 pherman@landmark.com [...]
7394 230 26_Re: Amazing -204 error !!!9_Ray Janes26_ray.h.janes@EXXONMOBIL.COM31_Tue, 31 Jul 2001 14:04:26 -0500467_us-ascii You should also have a RC or 00e79* something. Does that shed any light on it?<br><br><br><br><br><br>Manish Lall <db2list@YAHOO. To: DB2-L@RYCI.COM COM> cc: Sent by: DB2 Subject: Re: Amazing -204 error !!! Data Base Discussion List <DB2-L@RYCI.COM ><br><br><br><br><br><br>07/31/01 01:32 PM Please respond to DB2 Data Base Discussion List<br><br><br><br><br><br><br><br><br><br>I checked the VSAM datasets they are not migrated .Any more suggestion ?? [...]
7625 20 17_Re: Not Accounted12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 16:17:07 -0500591_- I liked Daniel's flavor of response. Life is not simple and slow any more. It's fast, complex, and asynchronous, with multiple parallel tasks in many situations. The complexities preclude any reasonable list of items. We don't have code for accounting in every place or a complete list of all the places. The cost for doing the accounting would sometimes be more than the cost of the work. Sometimes the operating system is in control for various kinds of interrupts, so that's more complex. There are a dozen or so kinds of serialization. For an ugly example, try to get performance [...]
7646 20 33_Re: Problem with Decimal Rounding12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 16:38:46 -0500533_- I think the base rules are in the SQL Reference, under the topic Expressions, then Arithmetic with an Integer and a Decimal Operand and Arithmetic with Two Decimal Operands. In my old paper V5 book, that's page 92.<br><br>I think your number 10000 is integer. It will probably work the same if you make the constant 10000. with a decimal point. You generally want to divide after you multiply, and you can force the arithmetic to 31 digit precision by increasing the scale of the sales price with a DECIMAL(SALES_PRICE,18,2). [...]
7667 52 38_Re: [Fwd: BMC to pay for v7 utilities]14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Tue, 31 Jul 2001 16:46:46 -0500572_iso-8859-1 The reason BMC Software is offering to help pay its customer's IBM DB2 utility bill is because many of our customers were having a hard time swallowing the baloney that IBM is reducing total cost of ownership by charging for something (utilities) that used to be free. Many of our customers wanted to maintain the status quo of having the IBM utilities but they also required the high speed and functionality they could get only with BMC solutions. The program we have put in place is to help our customers who want to have the basic IBM utilities as well [...]
7720 69 29_How do I do Date Arithmetic ?9_Mail User18_csc266@HOTMAIL.COM31_Tue, 31 Jul 2001 14:52:05 -0700381_iso-8859-1 This is probably a simple question to most of you<br><br>I need the difference between 2 timestamp fields expressed in various time units e.g days, months OR hours<br><br>e.g<br><br>select HOURS(TBL1.TIMESTAMP_COL1 - TBL2.TIMESTAMP_COL2) select HOURS(CURRENT TIMESTAMP - TBL2.TIMESTAMP_COL2) select DAYS(TBL1.TIMESTAMP_COL1 - TBL2.TIMESTAMP_COL2)<br><br><br><br><br><br>
7790 27 35_Re: SAP with DB2 on OS/390 eg. z/OS12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 16:52:20 -0500323_- There are many customers running this combination today. In addition to the prior pointers, this is a frequent topic at conferences. There are classes on the topic. There are many sources on the web. Here are a couple more:<br><br>ibm.com/redbooks 2001-05-31 SAP R/3 on DB2 for OS/390: DB2 Features That benefit SAP [...]
7818 13 14_Re: Triggers..12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 17:08:05 -0500406_- If you really want data replication to a warehouse, then I suggest looking at data replication products before rolling your own with triggers.<br><br>Roger Miller<br><br>================================================ 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.
7832 12 29_Re: Connecting DB2 and Oracle12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 17:21:39 -0500328_- DB2 Connect has an option called Relational Connect now as well.<br><br>Roger Miller<br><br>================================================ 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.
7845 15 36_Re: Data from UDB(NT) to UDB(OS/390)12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 17:24:50 -0500292_- If you are running DB2 for z/OS and OS/390 V7 with the utilities suite, there is a new option that we sometimes call the DB2 family cross loader. You LOAD from a cursor, and that cursor can go across DBRA to other DB2 family members or extended family members with Relational Connect. [...]
7861 15 43_Re: Peoplesoft on DB2 on OS/390 Experiences12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 17:52:30 -0500538_- There have been some excellent presentations by customers at various conferences like IDUG, the DB2 Technical Conference and Share. If you have those proceedigns available, I'd suggest checking a few. For Share, the past conferences are online at www.share.org<br><br>Roger Miller, DB2 for z/OS<br><br>================================================ 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.
7877 65 38_Re: [Fwd: BMC to pay for v7 utilities]12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Tue, 31 Jul 2001 18:01:37 -0500489_iso-8859-1 The cost of ownership is hardly baloney. Whether you are using BMC, CA or IBM tools the cost can be quite heavy. This cost does have an affect on upgrade decisions. The upgrade costs associated with utilities and/or tools becomes part of the business equation.<br><br>The utilities were never free. They came as part of the purchase of IBM's DB2. IBM has merely factored that cost out to allow for more customer options. If you do not need the IBM utilities, why buy them? [...]
7943 18 31_Re: DB2 V7.1 + CA/EZTRIEVE Plus12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 18:35:53 -0500486_- I think this looks like APAR PQ50494. Before V7, we did not check to see that the declared host variable length is larger than the length being passed for the PREPARE statement text. The missing check causes a problem for some customers. Having the check causes problems for others. APAR PQ50494 will take out the check for now, but please get all programs changed to use a valid declared length in the host variables, because this will probably come back with the next release. [...]
7962 58 57_Re: BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE"15_Mallett, Steven31_Steven.Mallett@TEAM.TELSTRA.COM30_Wed, 1 Aug 2001 09:56:23 +1000663_- We got this under DB2 V5 OS 390 Binding packages using DBRMs created under DB2 V6<br><br>regards, Steve Mallett Billing Technical Services<br><br>I 5/484 St Kilda Rd, Melbourne<br><br>' (03) 9865 7647 7 (03) 9866 1753 * <mailto: Steven.Mallett@team.telstra.com><br><br><br><br><br><br>> -----Original Message----- > From: Philippe Herman [SMTP:pherman@LANDMARK.COM] > Sent: Wednesday, August 01, 2001 6:11 AM > To: DB2-L@RYCI.COM > Subject: Re: BIND PACKAGE ERROR "DBRM IS IN AN INCONSISTENT STATE" > > Gruess Gott Georg, > > Looks like there is a desynchroniszation between what was done during the > last > precompile step and during the bind or rebind. [...]
8021 222 38_Re: [Fwd: BMC to pay for v7 utilities]13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 31 Jul 2001 17:02:37 -0700515_iso-8859-1 If it were true that "IBM has merely factored that cost out to allow for more customer options" then wouldn't the price of DB2 remain the same (plus the usual increase for a new version) for version 7 with all utilities included? The fact is, version 7 will be a significant price increase for us because we do not have competitor products for all the IBM utilities. If we did, we could choose one or the other; since we don't, we'll have to pay extra for image copy instead of using it for "free." [...]
8244 33 23_Performance and the web13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Tue, 31 Jul 2001 08:17:19 +1000332_iso-8859-1 I know, an oxymoron.<br><br>This is not strictly a DB2 question but I'm hoping someone on the list can help.<br><br>We are working on a browser->server->firewall->DB2 design. When it comes to performance of DB2 the tools to help are well known, but does anyone know what tools can help with the rest of the picture? [...]
8278 96 46_IDUG North America 2002 Call for Presentations14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Tue, 31 Jul 2001 18:21:33 -0700382_- Hi everyone! It's that time of the year again.....<br><br>IDUG is looking for YOU to consider putting together a presentation for next year's conference being held in San Diego on 5/12-16, 2002. If you are interested in submitting an abstract/outline for consideration, check out http://www.idug.org to complete the Call for Presentation application. The deadline is 9/3/01. [...]
8375 131 43_Re: Peoplesoft on DB2 on OS/390 Experiences14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Tue, 31 Jul 2001 18:40:18 -0700452_iso-8859-1 Jodi, At a previous employer we had Peoplesoft Financials on DB2 V4 and DB2 V5 for OS/390. I would be glad to share my experiences. I would also suggest you get on the Peoplesoft list for Db2 for OS/390. Contact janis.thomas@ca.com and she can tell you how to sign up. You can reach me through email and then we can do a phone conversation if that will help. There are many others on the list that have Peoplesoft Experiences. HTH Phil [...]
8507 14 35_DB2 Version 5 end of service coming12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jul 2001 20:38:17 -0500479_- The announcement for the end of DB2 for OS/390 V5 marketing was made today, and effective December 31, 2001, IBM will withdraw DB2 V5 from marketing. If you are running V5 or below, it's time to plan your migration.<br><br>Roger Miller<br><br>================================================ 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.
8522 128 64_Re: JDBC ResultSet problems after implementing ConnectionPooling9_Eric Kwai18_Eric_Kwai@DTCC.COM31_Tue, 31 Jul 2001 21:16:06 -0500636_- Bill: Try turning on the JDBC trace, you can find the procedure in the DB2 trouble shooting guide. Eric On Mon, 30 Jul 2001 14:19:43 -0500, Bill Littman <blittman@TOMOTHERAPY.COM> wrote:<br><br>>Here is my system: > >Java applications performing CRUD functions (Create, Retrieve, Update, >Delete) talking CORBA. >CORBA servers written in Java talking to DB2 UDB 7.1. >All Java is version 1.3.1. >All boxes are on WinNT 4.0 or Win2000. > >My Java CORBA Servers were setup to talk over one database connection using >multiple PreparedStatements. This worked fine for the most part, except for >some concurrency issues. > >To solve [...]
8651 43 26_Re: Amazing -204 error !!!11_Manish Lall17_db2list@YAHOO.COM31_Tue, 31 Jul 2001 19:46:02 -0700425_us-ascii Hi All ,<br><br>I checked everything , The VSAM Dataset is not migrated , it's there and the high level qualifier etc is correct , believe me there is no error on these aspect ,I'm having the sysadm right and that i have done the -dis db and the tablespace is in RW mode , i did select * on that table and could see all the rows .. WE all really surprised and anxious to get the solution .. Thanks, Manish Lall [...]