1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2001, week 2
2 83 52_WebSphere-DB2 Connect EE Connection Pooling question18_Subbarao Mupparaju15_Msmail1@AOL.COM28_Wed, 8 Aug 2001 01:02:07 EDT564_US-ASCII Hello all,
We have setup Connection Polling from the WebSphere Application Server running on AIX to DB2 V6 on OS/390 (via DB2 Connect EE). We have servlets running under the WebSphere that CALL the stored Procedures running on OS/390. The servlet makes a connection through the Connection pool using the getConnection method with a user id XXX and password PPP. after the transaction is complete the connection is not terminated (of course, that is the purpose of connection pool). I can see the thread under OmegaMon with WAIT-REMREQ status. [...]
86 68 68_Re: Controlling column width in CLP output (DB2 UDB EEE 7.1 on AI X)13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU30_Wed, 8 Aug 2001 16:17:57 +1000558_iso-8859-1 Steve,
When you say "defined as Char(8)" where is that definition? I ask because I see SYSIBM.SYSSCHEMATA as having VARCHAR(254) for these columns and this is the table under the view SYSCAT.SCHEMATA. You could always select a SUBTR(xxx,1,8) AS HEADING to get a cutdown view.
HTH
Steve T
-----Original Message----- From: Steve.Westfall@EQUIFAX.COM [mailto:Steve.Westfall@EQUIFAX.COM] Sent: Saturday, 4 August 2001 5:20 AM To: DB2-L@RYCI.COM Subject: Controlling column width in CLP output (DB2 UDB EEE 7.1 on AIX) [...]
155 27 17_DB2 DBA's needed!11_Jason Cohen26_jason.cohen@WARNERBROS.COM30_Wed, 8 Aug 2001 01:00:35 -0500337_- Hi there, I am a recruiter with Warner Bros in Burbank, and we are in dire need of 2 DB2 DBA's for a huge SAP implementation project we've got going on. It's about a 2 to 2.5 year project and there's about 150 people involved total.
For more info, please go to wbjobs.com and click on "Common Financials Initiative" (CFI). [...]
183 188 30_Odp: Re: Index access question15_Piotr Tarnowski20_TarnowskiP@PROKOM.PL30_Wed, 8 Aug 2001 10:09:18 +0200376_iso-8859-2 Terry, Mahadevan,
What about following transformation:
select * from t where c1 between ? and ? and c2 = ?
into:
select * from t where c1 in (select distinct c1 from t where c1 between ? and ?) and c2 = ?
Which does not require building termprary table by hand. Subqury uses matching index access (index-only) Query has MC=2 [...]
372 27 54_Unload-Reload problems changing size of numeric fields14_VAN ROYEN Dirk12_dvr@CIPAL.BE30_Wed, 8 Aug 2001 11:03:49 +0200525_iso-8859-1 Dear listers,
I'm encountering problems when unloading/loading DB2 tables when in between the size of some numeric fields are changed. I'm using the standard IBM tools (DSNTIAUL for the unload and the normal LOAD utility for reloading the data). The numeric fields are being changed from NUM (13,0) to NUM(15,2). When I reload the values of the fields are being divided by 100. So a value of 12345 before the unload is changed into 123,45 after the unload. What can be the cause of this manipulation ? [...]
400 52 58_Re: Unload-Reload problems changing size of numeric fields16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Wed, 8 Aug 2001 15:04:17 +0530428_- If i understood your question correctly, you have a column COL1 with datatype DECIMAL(13,0). You are unloading this column as COL1/100 and then loading it back to the column which is defined as DECIMAL(15,2).
In this case, use DECIMAL(VALUE(COL1/100,0), 15,2) while unloading. This way you can minimize lots of loading difficulties. Create punch card with the same unload JCL using DSNTIAUL or manually modify it. [...]
453 68 33_Discarding rows in ONLINE REORG ?12_Jacob Ganzel19_jacobg@SEMECH.CO.IL30_Wed, 8 Aug 2001 13:31:39 +0300384_x-user-defined Hello list . Is there a way to discard selected rows in ONLINE REORG running in DB2 for OS/390 V7 environment? Thanks. Jacob. --------------------------------------------------------------- Jacob Ganzel Database Products SEMECH Software Marketing Ltd.
3b Netanyahu St., OR YEHUDA, ISRAEL 60376 Email: jacobg@semech.co.il Tel.: +972-3-5333144 Fax.: +972-3-5333132
522 36 37_Re: Discarding rows in ONLINE REORG ?16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Wed, 8 Aug 2001 16:50:13 +0530657_- Yes, DISCARD TABLE WHEN COLUMN condition helps you do that in V7. You can read thru' utility guide for details and restrictions.
Regards Sanjeev
> -----Original Message----- > From: Jacob Ganzel [SMTP:jacobg@SEMECH.CO.IL] > Sent: Wednesday, August 08, 2001 4:02 PM > To: DB2-L@RYCI.COM > Subject: Discarding rows in ONLINE REORG ? > > Hello list . > Is there a way to discard selected rows in ONLINE REORG running in DB2 > for OS/390 V7 environment? > Thanks. > Jacob. > --------------------------------------------------------------- > Jacob Ganzel > Database Products > SEMECH Software Marketing Ltd. > > 3b Netanyahu St., OR YEHUDA, [...]
559 129 33_Re: Attention all you UNIX gurus!17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Wed, 8 Aug 2001 07:52:31 -0500404_us-ascii Yes we are concerned about running different patch levels. We only have one box, we need to be able to have test, development and production separate. I think that I am able to find away around this requirement though.
From: Lorraine Yan @RYCI.COM on 08/07/2001 04:37 PM
Please respond to DB2 Data Base Discussion List [...]
689 37 20_DDL generation tools0_28_Roy_Bertossi@ABERCROMBIE.COM30_Wed, 8 Aug 2001 09:02:50 -0400473_us-ascii All,
My company has been searching for a reasonably priced tool that will generate the ddl for DB2 OS/390 version 6 and 7 objects and all of its dependent objects. We know that we can purchase the IBM Data Admin tool but for the amount of anticipated use of the tool, it is rather expensive. I found documentation on the version 7 control center being able to generate the DDL but it reads like we have to have the admin tool to do the ddl generation. [...]
727 66 60_Re: DDF TCPIP insert Performanace & Blocking or not blocking11_Jose' Gomez21_Jose_Gomez@WENDYS.COM30_Wed, 8 Aug 2001 09:08:47 -0400540_us-ascii Hello Alex:
I don't think you can get DB2 Connect to run as fast as any other tool running on a OS390 address space, because I think the network always plays a big part when doing DRDA. If all of the DB2 Connect parameters on your NT/2000 boxes are optimized for performance, I will look at the NIC cards on those boxes if you haven't done so. We ran into a performance issue after converting to Ethernet on the DB2 Connect servers and we had to change a hand full of parameters on the NIC cards and a registry setting [...]
794 61 24_Re: DDL generation tools26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM30_Wed, 8 Aug 2001 06:18:53 -0700525_iso-8859-1 I've used the BMC tools to do this and indeed they are not cheap. They are very good tools nonetheless, and the time and effort saved more than pays for the tools. Ditto for CA. Basically you want a Cadillac but are only willing to spend for a Cavalier??? It's easy to only look at the cost of the tool and not factor in the cost of a DBA's time and potential errors in the equation. In the long run, I think you'll find that buying the tool will actually save you money but it's hard to quantify and present [...]
856 124 33_Re: Attention all you UNIX gurus!12_tim malamphy20_timalamphy@YAHOO.COM30_Wed, 8 Aug 2001 06:20:53 -0700587_us-ascii They're called "instances".
Unless what you're really looking for is having 3 different fixpak levels of the same version. That is an abomination and I would resist implementing it at all. Kind of like "How do I run 3 different versions of ERLY code". Get two more machines or a new job if management demands it. Or, IF YOU INSIST, I guess you could apply a fixpak, update 1 instance, then apply a different fixpak, and then update a different instance. This would give you 3 copies of a given version running different fixpak levels. And you'd deserve the disaster [...]
981 77 38_Re: [Fwd: BMC to pay for v7 utilities]12_Moulder, Tom19_Tom_Moulder@BMC.COM30_Wed, 8 Aug 2001 08:24:44 -0500703_iso-8859-1 Rolling On The Floor Laughing
-----Original Message----- From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Tuesday, August 07, 2001 11:22 PM To: DB2-L@RYCI.COM Subject: Re: [Fwd: BMC to pay for v7 utilities]
ROTFL?
> -----Original Message----- > From: Moulder, Tom [SMTP:Tom_Moulder@BMC.COM] > Sent: Wednesday, August 08, 2001 1:37 PM > To: DB2-L@RYCI.COM > Subject: Re: [Fwd: BMC to pay for v7 utilities] > > ROTFL > > Tom > > -----Original Message----- > From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] > Sent: Tuesday, August 07, 2001 10:06 PM > To: DB2-L@RYCI.COM > Subject: Re: [Fwd: BMC to pay for v7 utilities] > > > [...]
1059 50 27_Re: Binding for DRDA access11_David Nance16_DWNance@FHSC.COM30_Wed, 8 Aug 2001 09:40:45 -0400576_US-ASCII In your plan bind stmt use sqlerror(continue).
Dave Nance First Health Services, Corp. (804)527-6841
>>> hvilla@TTI.COM.AR 08/07/01 06:57PM >>> Hi everybody,
I set up the CDB to access a remote database from OS/390. I can run queries from SPUFI and is working OK. But then I want to access it from a Cobol program which also access data on my local subsystem. I coded: (some sql to my local DB) ... EXEC SQL CONNECT TO SAMPLE END-EXEC ...... (select to my remote database) EXEC SQL CONNECT RESET END-EXEC ... (some other sql to my local DB) [...]
1110 93 24_Re: DDL generation tools11_John Felton22_john.felton@AMERUS.COM30_Wed, 8 Aug 2001 08:33:27 -0500681_US-ASCII We have used Compuware's DBA-Xpert tool for several years. The tool performs many useful DBA-support functions very well and it is very reasonably priced compared to BMC and CA/Platinum.
HTH,
Regards,
John Felton Sr. Database Administrator AmerUs Life
john.felton@amerus.com office: (515) 557-3018
>>> bjohnson@RUSSELLMELLON.COM 08/08/01 08:18AM >>> I've used the BMC tools to do this and indeed they are not cheap. They are very good tools nonetheless, and the time and effort saved more than pays for the tools. Ditto for CA. Basically you want a Cadillac but are only willing to spend for a Cavalier??? It's easy to only [...]
1204 40 24_Re: DDL generation tools15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA30_Wed, 8 Aug 2001 15:54:08 +0200387_us-ascii Depends what you consider expensive.
I have used PowerDesigner DataArchitect (by Sybase) with a reasonably high degree of success. (version 6.1 and 7.5). It support many dbms's (SQL Server, ORACLE, DB2, Sybase, Interbase, UDB, Informix, Teradata and odbc data sources), can reverse engineer from these (via odbc) as well forward engineer to these ( again via odbc). [...]
1245 25 36_DB2 connect EE for AIX configuration16_Blumenthal, Gary21_GBlument@UNCH.UNC.EDU30_Wed, 8 Aug 2001 10:01:22 -0400338_iso-8859-1 All,
I need to run some SQL commands (against a OS/390 DB2 6.1 database) from an AIX box. One of our UNIX administrators installed DB2 Connect Enterprise Edition (V6.1 for AIX) for me and I am struggling to configure it. I downloaded the "Quick Beginnings" documentation only to find out that it is 264 pages long! [...]
1271 71 23_Index usage ... funny ?15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA30_Wed, 8 Aug 2001 16:02:44 +0200427_us-ascii Hi there listers,
I have a query regards DB2 v6 fo OS/390. One of our DBA's is struggling to get his head around the access path reported by DB2. The detail is as follows:
Statement is:
UPDATE BEN_PMT_EVT SET EVT_END_NR = : VEVTENDNR , CHNG_END_DT = : VCHNGENDT WHERE FK_POL_NR = : VPOLNR AND FK_EVT_NR = : VEVTNR AND FK_CHNG_DT = : VCHNGDT AND PTY_ID = : VPTYID AND PTY_ROLE_CD = : VPTYROLE [...]
1343 128 24_Re: DDL generation tools0_29_sflindsey@HIGHLIGHTS-CORP.COM30_Wed, 8 Aug 2001 10:14:43 -0400801_us-ascii Ditto on DBA-Xpert. We have used it for a number of years and have not had any problems.
HTH also, Scott Lindsey Sr. DBA, Highlights for Children
John Felton on 08/08/2001 09:33:27 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Scott F Lindsey/HFC/HFC_Corp)
Subject: Re: DDL generation tools
We have used Compuware's DBA-Xpert tool for several years. The tool performs many useful DBA-support functions very well and it is very reasonably priced compared to BMC and CA/Platinum. [...]
1472 15 27_Re: Index usage ... funny ?9_Sally Mir22_Sally.Mir@WACHOVIA.COM30_Wed, 8 Aug 2001 10:20:16 -0400399_us-ascii The first thing I would check is that the host variables used in the predicates are of the same data type and length as the column.
Sally Mir
================================================ 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.
1488 174 37_Re: Discarding rows in ONLINE REORG ?14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 8 Aug 2001 15:24:28 +0100496_iso-8859-1 Except that DISCARD is ONLY valid with REORG SHRLEVEL NONE or REFERENCE and not SHRLEVEL CHANGE.
This is a GOOD thing, of course.
Your application is merrily trawling through the data, updating rows and updating OTHER tables based on what it finds in the table you are reorging. Now the reorg has ended and some of those rows that WERE there whilst the program was running are now NOT there (they have been discarded). What state does THAT leave your database in??? [...]
1663 146 33_Re: Attention all you UNIX gurus!17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Wed, 8 Aug 2001 09:29:07 -0500441_us-ascii That is exactly what I have been asked to do, thanks I will take that to those who are asking me to do it.
From: tim malamphy @RYCI.COM on 08/08/2001 08:20 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: Attention all you UNIX gurus! [...]
1810 101 27_Re: Index usage ... funny ?15_Janardhan Ragam16_sragam@YAHOO.COM30_Wed, 8 Aug 2001 07:32:11 -0700540_us-ascii Has your dba looked at the source code and verified that the column and host variable data types are exactly the same?
Sai. --- Regan Galbraith wrote: > Hi there listers, > > I have a query regards DB2 v6 fo OS/390. One of our > DBA's is struggling to > get his head around the access path reported by DB2. > The detail is as > follows: > > Statement is: > > UPDATE BEN_PMT_EVT > SET EVT_END_NR = : VEVTENDNR , > CHNG_END_DT = : VCHNGENDT > WHERE FK_POL_NR = : VPOLNR > AND FK_EVT_NR = : [...]
1912 98 27_Re: Index usage ... funny ?22_Vadavalli, Sirish B23026_Sirish.Vadavalli@CIGNA.COM30_Wed, 8 Aug 2001 10:37:43 -0400598_us-ascii I have seen many things that explain deviates in .. like the cost estimate etc. also. though it uses the index's the actual execution times are sometimes better than without the index's. why does it say 0 COLS for the second table..??
Sirish
> -----Original Message----- > From: Regan Galbraith [SMTP:Regan.Galbraith@SANLAM.CO.ZA] > Sent: Wednesday, August 08, 2001 10:03 AM > To: DB2-L@RYCI.COM > Subject: Index usage ... funny ? > > Hi there listers, > > I have a query regards DB2 v6 fo OS/390. One of our DBA's is struggling to > get his head around the access path [...]
2011 210 60_Re: DDF TCPIP insert Performanace & Blocking or not blocking14_Philip Gunning24_Philip.Gunning@QUEST.COM30_Wed, 8 Aug 2001 07:43:15 -0700567_iso-8859-1 Alex, DB2 Connect is more cpu intensive than memory so make sure the server you are running it on has enough CPU. Second, how are you controlling the enclaves on OS/390 that get created when DDF accepts a request from a remote requestor. Does it have adequate priority? Take a look in the Admin guide there is some guidance on setting up DB2 and WLM. Realize at this time you will never get the same performance coming through the network that you get running green screen on the mainframe. IF you have DB2PM there is a Distributed thread report that [...]
2222 71 24_Re: Insert Performance ?13_Daniel Turner28_daniel_turner@ALBERTSONS.COM30_Wed, 8 Aug 2001 07:43:10 -0700464_- When db2 runs out of freespace at a hot spot, it gives up trying to keep cluster order and insert performance can actually increase.
Of course pctfree and freepage install space uniformly thourghout the entire table and they work best when the inserts are done randomly across the entire table. If you try to insert a lot more than will fit in an immediate vicinity, then you are going to split a lot any way and you will need to reorg often anyway. [...]
2294 67 40_Re: DB2 connect EE for AIX configuration15_Janardhan Ragam16_sragam@YAHOO.COM30_Wed, 8 Aug 2001 07:51:26 -0700479_us-ascii Quick steps:
1) db2 "catalog tcpip node remote server "
You should be able to find the host name and port number in the db2 master log on the mainframe.
2) db2 "catalog dcs db as "
You should be able to find the location in the db2 master log on the mainframe. The location should be exactly the same name as displayed in the master log on the mainframe. [...]
2362 133 40_Re: DB2 connect EE for AIX configuration14_Philip Gunning24_Philip.Gunning@QUEST.COM30_Wed, 8 Aug 2001 07:55:01 -0700410_iso-8859-1 Gary, You need to make sure that the DB2 for OS/390 system is configured to accept requests (assuming TCPIP). Before you can catlaog the OS/390 dtabase, you will need the Location from the bootstrap dataset of the subsystem that you will be connecting to, and the port # if it is not using the default of 446. Then follow the cataloging a host database in the Quick Beginnings manual. HTH Phil [...]
2496 13 18_Snap Shot Question12_Susan Carter18_SCARTER@PANTEX.COM30_Wed, 8 Aug 2001 09:59:44 -0500308_US-ASCII Snap Shot - is anyone using it with DB2? If so how and why?
===============================================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.
2510 32 38_DB2 Systems programmers (3) positions.15_Jeff Wrightsell27_jwrightsell@RAPIDDEPLOY.COM30_Wed, 8 Aug 2001 09:59:43 -0500437_iso-8859-1 Position - DB2 Systems Programmer Type - Full-time Where - On-site/Phoenix, AZ Start Date - ASAP Pay - up to 90k for top candidates + bonus + sign-on
This is a long term client of mine that I work very closely with. Again, they move very quickly, so for those of you who are interested in opportunities, we assure prompt response from the hiring manager. Of the four positions open last week, one has been filled. [...]
2543 60 22_Re: Snap Shot Question0_20_John_Lendman@FPL.COM30_Wed, 8 Aug 2001 11:09:52 -0400459_us-ascii Your simple question calls for a very long answer, but for now I will say, yes I was using it with our SAP DB2 application. The why was because it would take to long to do image copies of the 26,000 datasets. So I used it at a volume level. The other thing is we have now moved to "Flashcopy" which is IBM's product. It does the same type of thing, only faster. If you want to talk about it offline you can call me or send me an email directly. [...]
2604 44 14_Re: One volume15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Wed, 8 Aug 2001 10:17:07 -0500511_iso-8859-1 What reasons have you outlined so far?
Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services
"Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic." - someone named Taylor, www.bookoftruths.com
-----Original Message----- From: Rowell, Dean A [mailto:dean.rowell@EDS.COM] Sent: Tuesday, August 07, 2001 4:00 PM To: DB2-L@RYCI.COM Subject: One volume [...]
2649 35 22_Re: Snap Shot Question17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Wed, 8 Aug 2001 10:24:30 -0500438_us-ascii I use it with a snapshot monitor on NT to determine bufferpool hit ratios as well as locks and a number of other things.
From: Susan Carter @RYCI.COM on 08/08/2001 09:59 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Snap Shot Question [...]
2685 96 22_Re: Snap Shot Question22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM30_Wed, 8 Aug 2001 10:24:22 -0500471_- I'm answering although we're a Datacom shop, because the reason for Susan's "Why" is similar to that of what John has stated. Because of the very small window we have for backups, we used SNAPSHOTs (RVA) earlier and we have been using Flashcopy since we migrated to ESS (SHARK) to backup all Data instead of running DB 'BACKUP' (= to IC in DB2) for each table. Works fine. If I'm not mistaken, Flashcopy can only be used at Vol level. Snapshot can be at DS level. [...]
2782 29 90_Sample Java/JDBC program performing updates in 2 databases in sam e UOW (two-phase commit)23_Scarcella, Gary V (ING)23_ScarcellaGV@ING-AFS.COM30_Wed, 8 Aug 2001 11:20:00 -0400500_iso-8859-1 Does anyone out there have a sample Java/JDBC application that connects to 2 different DB2 UNIX databases and perform updates in each database within a single unit of work (i.e. distributed unit of work / multisite update / two-phase commit)?
I know this is possible with DB2 (according to the manuals), but I'm having trouble getting a sample program to work. Also, if you can share any DB2 configuration and db2cli.ini file parameter changes needed, it would be appreciated. [...]
2812 56 22_Re: Snap Shot Question9_Jim Leask27_jim.leask@RS-COMPONENTS.COM30_Wed, 8 Aug 2001 16:36:48 +0100474_ISO-8859-1 Hi,
We use RVA snapshot for Disaster Recovery.
Why - because now the disaster recovery process does not require any DBA action, just volume recovers from tape and start DB2
How - 1. Stop DB2 - yes we have the luxury where we can stop DB2 every morning at 5am and the business only needs to recover to start of day 2. Use snapshot at the volume level for all DB2 volumes 3. Restart DB2 4. Back up the volumes at the snapped point to tape [...]
2869 73 22_Re: Snap Shot Question13_Terry McCombs20_tmccomb@SEDGWICK.GOV30_Wed, 8 Aug 2001 10:51:01 -0500380_iso-8859-1 If you're on V6 or greater, you can use SET LOG SUSPEND prior to the snapshot, instead of STOP DB2, and SET LOG RESUME after the snapshot. Allows read activity but no updates.
-----Original Message----- From: Jim Leask [mailto:jim.leask@RS-COMPONENTS.COM] Sent: Wednesday, August 08, 2001 10:37 AM To: DB2-L@RYCI.COM Subject: Re: Snap Shot Question [...]
2943 45 29_SQLEXCEPTIONS -- Need info !!10_Azam Mirza18_azam00@HOTMAIL.COM30_Wed, 8 Aug 2001 11:00:46 -0500351_- Hi, I am trying to write SQL procedures in DB2 UDB ver7.1 on NT. I am trying to put SQL Exceptions in the code to capture any exceptions during execution. THe only value I get back is a '0'. An example is as follows:
create PROCEDURE vld_usr ( IN i_user_id char(10), OUT o_msg_cd int, OUT o_msg varchar(200) ) RESULT SETS 1 LANGUAGE SQL [...]
2989 184 25_Re: Index access question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Wed, 8 Aug 2001 11:06:50 -0500436_iso-8859-2 Piotr,
Depends what you mean by work. It increases the matching index columns......But you still scan all the matching rows of the table, which is what we were trying to avoid with the matchcols 2. So this is actually worse performance than the original since now you scan the range, then materialize the result and join back to the outer table (assuming V6 or late V5). The original just scanned the range once. [...]
3174 55 19_Number of DB2 Sites10_Larry Wood18_LarryWood@SOPH.COM30_Wed, 8 Aug 2001 11:16:30 -0500103_iso-8859-1 Does anyone know how many DB2 and IMS sites there are today?
Thanks
Larry Wood
3230 21 14_Tivoli and DB212_Isaac Yassin20_yassini@BEZEQINT.NET30_Wed, 8 Aug 2001 19:29:10 +0200351_windows-1255 Has anyone implemented TIVOLI on DB2 while changing the defaults for the DB definitions ? - It comes with multi-table tablespace which I would like to change. Any other ideas will be good as well.
Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net [...]
3252 106 52_Heads up for European folks from Computer Associates14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 8 Aug 2001 17:33:57 +0100638_iso-8859-1
Just a little advance warning of a couple of things happening in Europe leading up to IDUG in Florence this year.
Firstly, Computer Associates will be running our 'traditional' DB2 Customers Day on the Sunday immediately prior to IDUG. This even is open to all existing Computer Associates DB2 tools customers. This year we will have presentations from a couple of users (well, this IS a users day!) and we will have Horacio Terrizzano as our guest speaker so here is your chance to be educated AND entertained. More detailed information will be forthcoming shortly, together with registration details, but [...]
3359 109 33_Re: SQLEXCEPTIONS -- Need info !!11_Rick Rogers21_Rick.Rogers@TELUS.COM30_Wed, 8 Aug 2001 10:49:19 -0600429_iso-8859-1 The procedure you've given below, if it is complete, will do nothing.
The SQL will not execute at all, because it is contained within your continue handler. The SQL has to be outside the handler in order for your data conditions to raise the exception for the handler to handle:
create PROCEDURE vld_usr ( IN i_user_id char(10), OUT o_msg_cd int, OUT o_msg varchar(200) ) RESULT SETS 1 LANGUAGE SQL [...]
3469 13 12_Users on DB29_Don Cross20_Don.Cross@TC.FAA.GOV30_Wed, 8 Aug 2001 13:03:36 -0400345_us-ascii Is there an easy way to display the number of users on the DB2 subsystem at any point in time?
================================================ 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.
3483 58 23_Re: Number of DB2 Sites0_20_John_Lendman@FPL.COM30_Wed, 8 Aug 2001 13:06:41 -0400463_us-ascii I have one document from IBM that talks about over 1,000,000,000 DB2 licenses.
Not sure about IMS.
John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413
"Larry Wood" cc: Sent by: "DB2 Subject: Number of DB2 Sites Data Base Discussion List"
08/08/01 12:16 PM Please respond to "DB2 Data Base Discussion List" [...]
3542 26 46_TIMESTAMP 10 bytes packed. How does that work?0_20_Jones.H@GRAINGER.COM30_Wed, 8 Aug 2001 12:08:00 -0500507_- From the doc I have, the internal format of a timestamp is 10 bytes packed decimal (if not nullable) and holds the numbers yyyymmddhhmmsstttttt. But that's 20 digits. Doesn't that take 11 bytes?
Suppose the timestamp is 1111-02-03-04-55-60-777777. That's 11110203045560777777, or in packed format displayed in hex,
01123450777 1100056777C That's 11.
Is it really packed decimal, or does DB2 cheat and get rid of the leading 0 and the trailing C ? Or am I missing something else? [...]
3569 51 16_Re: Users on DB216_Charles F Creech24_cfcreech@DUKE-ENERGY.COM30_Wed, 8 Aug 2001 13:17:10 -0400374_us-ascii The easiest way is to go to your DB2 monitor (hopefully you have one) and look at the screen that displays active threads. You can also issue a DISPLAY THREAD command.
Regards, Rick Creech
Don Cross cc: Sent by: DB2 bcc: Data Base Subject: Users on DB2 Discussion List [...]
3621 51 50_Re: TIMESTAMP 10 bytes packed. How does that work?14_Toppins, Smike21_smike.toppins@GWL.COM30_Wed, 8 Aug 2001 11:21:13 -0600667_- If memory serves me correctly, the "internal" number in the 10 byte field is an offset number from a specific point in time. Not positive though.
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
> ---------- > From: Jones.H@grainger.com[SMTP:Jones.H@grainger.com] > Reply To: DB2 Data Base Discussion List > Sent: Wednesday, August 08, 2001 11:08 AM > To: DB2-L@ryci.com > Subject: TIMESTAMP 10 bytes packed. How does that work? > > From the doc I have, the internal format of a timestamp is > 10 bytes packed decimal (if not nullable) and holds the numbers > yyyymmddhhmmsstttttt. But that's 20 digits. Doesn't [...]
3673 105 42_Re: Stored Procedure Builder & Schema Name11_Rick Rogers21_Rick.Rogers@TELUS.COM30_Wed, 8 Aug 2001 11:19:30 -0600304_iso-8859-1 Good point Kals,
We are using SQL stored procs here, so the binding happens as part of the cataloging of the procedure. If you are using one of the other stored proc languages, you may be able to manipulate the bind to set the qualifier. I'm not familiar with the other languages. [...]
3779 45 50_Re: TIMESTAMP 10 bytes packed. How does that work?19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Wed, 8 Aug 2001 17:32:59 +0100345_us-ascii Hayden,
AFAIK it's a DB2 internal format, which IBM can see fit to tinker with as they like.
Probably (I'd guess) the number of microseconds since some date in the past or something similar.
Anyway the lesson we were taught was to never mess with the internal format; only use the expanded 26 byte equivalent. [...]
3825 197 50_Re: TIMESTAMP 10 bytes packed. How does that work?9_Mark Ruhe19_Mark.Ruhe@QUEST.COM30_Wed, 8 Aug 2001 10:41:36 -0700498_iso-8859-1 Timestamps as well as Time and Dates are stored a pseudo-packed numbers. Pseudo-packed implies no ending sign nibble (nibble being 4 bits). So a timestamp of '2001-08-01-12:12:12.999999' is stored as x'20010801121212999999' hence 10 bytes of storage.
-----Original Message----- From: Toppins, Smike [mailto:smike.toppins@GWL.COM] Sent: Wednesday, August 08, 2001 12:21 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] TIMESTAMP 10 bytes packed. How does that work? [...]
4023 67 24_Re: Insert Performance ?0_19_Tim.Lowe@STPAUL.COM30_Wed, 8 Aug 2001 12:45:27 -0500659_us-ascii Bob, Does "MEMBER CLUSTER" on the create of the tablespace do what you are after?
Thanks, Tim
BOB JEANDRON cc: Sent by: DB2 Subject: Insert Performance ? Data Base Discussion List
08/07/2001 04:00 PM Please respond to DB2 Data Base Discussion List
We have a large process (selects, updates but mostly inserts) that runs for approx 10 hours. The data is partitioned/clustered by random key into 3 partitions. The input data is not sorted by this random key...Death by random synchronous I/O. [...]
4091 53 50_Re: TIMESTAMP 10 bytes packed. How does that work?13_Villa Horacio17_hvilla@TTI.COM.AR30_Wed, 8 Aug 2001 15:03:22 -0300620_iso-8859-1 It's 10 bytes "packed decimal" (but not Cobol comp-3). 1100056777 1123450777 That's 10. It gets rid of the leading 0 and the trailing C. Horacio Villa TTI S.A. Buenos Aires - Argentina > ---------- > From: Jones.H@grainger.com[SMTP:Jones.H@grainger.com] > Reply To: DB2 Data Base Discussion List > Sent: Wednesday, August 08, 2001 11:08 AM > To: DB2-L@ryci.com > Subject: TIMESTAMP 10 bytes packed. How does that work? > > From the doc I have, the internal format of a timestamp is > 10 bytes packed decimal (if not nullable) and holds the numbers > yyyymmddhhmmsstttttt. But that's 20 digits. Doesn't > [...]
4145 78 50_Re: TIMESTAMP 10 bytes packed. How does that work?12_McKown, John22_JMckown@HEALTHAXIS.COM30_Wed, 8 Aug 2001 13:19:47 -0500712_- I've always heard that called "unsigned packed decimal".
---------------------------------------------------------------------- John McKown HealthAxis
All opinions are my own and are not the opinions of my employer.
Unsolicited telephone calls from vendors are NOT appreciated and tend to upset my management.
> -----Original Message----- > From: Villa Horacio [SMTP:hvilla@TTI.COM.AR] > Sent: Wednesday, August 08, 2001 1:03 PM > To: DB2-L@RYCI.COM > Subject: Re: TIMESTAMP 10 bytes packed. How does that work? > > It's 10 bytes "packed decimal" (but not Cobol comp-3). > 1100056777 > 1123450777 That's 10. > It gets rid of the leading 0 and the trailing C. > Horacio [...]
4224 35 13_DB2 Questions22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM30_Wed, 8 Aug 2001 14:10:31 -0500734_- I'm posting this for one of my colleagues:
What is DB2 "REDIRECTED RESTORE"? Where and when is it used? Is it new? Is it Platform specific, because I had never heard of it on DB2 OS/390.
Thanks,
Venkatesh Mokshagundam
> Database Administrator > Corporate Systems > Amarillo, Texas Ph: 806-337-3374 vmokshagun@csedge.com
The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited [...]
4260 58 56_Re: WebSphere-DB2 Connect EE Connection Pooling question13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Wed, 8 Aug 2001 14:22:01 -0500367_iso-8859-1 Subbarao,
Yes, the thread will be reused with the new signon. There is a situation to be aware of however. If DB2 Connect thread pooling (not concentrating) is enabled and a PTF(not sure but try UQ38560 or UQ43679) is missing from DB2 OS/390, the new thread will use the authorization and corrid information from the previous thread. Not good. [...]
4319 239 56_Re: Heads up for European folks from Computer Associates16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Wed, 8 Aug 2001 20:53:16 +0100557_- I know this is a little late - but I really think the local Marketing people together with all of you working with DB2 should copy what we're doing in Scandinavia:
1) Send out an invitation to ALL DB2 sites - customers as well as non-customers.
2) All the customers has to do is, to fill out a form, and WE (marketing) will take care of Travel arrangements, hotel booking, IDUG registration etc. etc. We will take care of transportation from airport to the hotel. The customer is also invited to the User day and the dinner afterwards. [...]
4559 44 60_Recall: Heads up for European folks from Computer Associates16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Wed, 8 Aug 2001 20:55:36 +0100108_- Rasmussen, Steen would like to recall the message, "Heads up for European folks from Computer Associates".
4604 44 60_Recall: Heads up for European folks from Computer Associates16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Wed, 8 Aug 2001 20:55:55 +0100108_- Rasmussen, Steen would like to recall the message, "Heads up for European folks from Computer Associates".
4649 36 56_Re: Heads up for European folks from Computer Associates16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Wed, 8 Aug 2001 20:56:09 +010010_-
4686 45 18_Re: Tivoli and DB29_Wu, James13_jwu@KRAFT.COM30_Wed, 8 Aug 2001 15:14:01 -0500638_windows-1255 Do you mean Tivoli Decision Support (also called Performance Reporter)? I do use my own DB definitions instead of Tivoli supplied DDLs, which makes my life much easier.
James Wu:-) (847)646-5548 jwu@kraft.com
-----Original Message----- From: Isaac Yassin [mailto:yassini@BEZEQINT.NET] Sent: Wednesday, August 08, 2001 12:29 PM To: DB2-L@RYCI.COM Subject: Tivoli and DB2
Has anyone implemented TIVOLI on DB2 while changing the defaults for the DB definitions ? - It comes with multi-table tablespace which I would like to change. Any other ideas will be good as well. [...]
4732 79 22_Oracle gateway and DB20_23_edie.richardson@SRS.GOV30_Wed, 8 Aug 2001 16:44:39 -0400572_us-ascii We are using db2 v4 and Oracle 8i. To communicate between the two databases we use the Oracle Transparent Gateway v8. Somewhere down the line our gateway gets bogged down. I took a look at a couple of things.
First, I issue a command to display users of the gateway thru console commands. I also issue the db2 command dis threads. I may have 5 db2 active threads(using the gateway plan) and 6 gateway users, another words, they don't always match. What I think is happening is that the gateway is not cancelling the db2 threads when they are finished [...]
4812 25 12_Re: DB2 TMON15_Philippe Herman20_pherman@LANDMARK.COM30_Wed, 8 Aug 2001 16:58:13 -0400575_us-ascii Jeff,
What are the exceptions that are active in the TMON DB2
My first thought is that it looks like you are polling something every minute.
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
================================================ 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.
4838 65 18_Re: Tivoli and DB215_Janardhan Ragam16_sragam@YAHOO.COM30_Wed, 8 Aug 2001 14:13:59 -0700532_us-ascii Based on experience with tivoli inventory product on db2 udb for AIX, I can suggest the following: Avoid changing object names below tablespace level. If you have table growth/activity estimates, put the highly active tables/indexes in separate tablespaces. Most vendors, including tivoli, will send ddl which will create all tables and indexes in the same tablespace. Although it will be a tedious process for you, separate them into diffferent tablespaces. Also create separate bufferpools for table and index data. [...]
4904 16 18_DDCS IVP program ?10_Tom Taylor17_ttaylor@CHUBB.COM30_Wed, 8 Aug 2001 17:15:15 -0400345_us-ascii HI all
Does anyone know if there is an IVP program for DDCS to OS/390
Thanks tom
================================================ 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.
4921 32 14_Re: One volume15_Philippe Herman20_pherman@LANDMARK.COM30_Wed, 8 Aug 2001 17:19:14 -0400311_us-ascii Not really. The only reason left could be that you want to be sure that the object is on THAT PARTICULAR volume (for whatever reason it is). But you can also define a rule that achieve this via the ACS routines.
There is a good IBM redbooks discussing how DB2 and SMS should work together. [...]
4954 26 22_Re: Snap Shot Question15_Philippe Herman20_pherman@LANDMARK.COM30_Wed, 8 Aug 2001 17:36:43 -0400341_us-ascii DB2 may use the Snap Shot feature for Image Copy Just specify CONCURENT yes and if the DASD you are copying is snapshot enabled, then it will automatically do a snapshot image copy instead of a normal image copy. Be carefull that the image copy is not readable and useable like a normal one because the is a DFDSS dump format. [...]
4981 20 25_Re: Index access question24_Mahadevan Krishnamoorthy45_mahadevan.krishnamoorthy@FARMERSINSURANCE.COM30_Wed, 8 Aug 2001 15:30:34 -0700432_us-ascii Hi all,
we have decided to use IN instead of BETWEEN by joining with a small table having date range as suggested by Terry.
Thanks for all your suggestion.
Maha
================================================ 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.
5002 59 24_Re: DDL generation tools15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Thu, 9 Aug 2001 09:16:42 +1000331_- CDB used to do a catalog management tool called DB2 Workbench, but they sold it to !Candle. It was/is an excellent product, and is now called !DB/Workbench for DB2. Does more than just generate DDL but it might be just what you want.
Raymond (!Candle, how about a cute pen or something for the referral?) ;o) [...]
5062 30 23_Re: Number of DB2 Sites15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Thu, 9 Aug 2001 09:51:15 +1000433_- I thought DB2 licences for OS/390 recently i.e. 2-3 months ago, passed the 10,000 mark. Quite prepared to be wrong.
Raymond
> -----Original Message----- > From: Larry Wood [SMTP:LarryWood@SOPH.COM] > Sent: Thursday, August 09, 2001 2:17 AM > To: DB2-L@RYCI.COM > Subject: Number of DB2 Sites > Importance: High > > Does anyone know how many DB2 and IMS sites there are today? > > Thanks > > Larry Wood > [...]
5093 99 41_Re: Help - Partition Performance Problems9_john king24_john_king@REDIFFMAIL.COM30_Thu, 9 Aug 2001 00:00:25 -0000438_- Yes Sanjeev, We need to see the explain information and I also do have doubts. Hence when answering Marcus please include my doubts also to this queries. My doubt is on what basis you would find out from explain information that optimiser is considering it cheaper for usage of other index. Also we are waiting to see whether the queries for Marcus involves joins or not. I woould post more doubts on that. Thanks in advance. John [...]
5193 130 50_Re: TIMESTAMP 10 bytes packed. How does that work?13_BL.Tink Tysor16_tink@BLTYSOR.COM30_Wed, 8 Aug 2001 18:26:50 -0700396_us-ascii In some circles that is called BCD or Binary Coded Decimal. I haven't heard that term since I stopped working on military projects in 1990. I believe in the DB2 manuals it is referred to as just "decimal". I believe they reserve the term "packed decimal" to refer only to the true packed decimal format recognized by the hardware instructions, i.e. having the trailing sign nibble. [...]
5324 97 50_Re: TIMESTAMP 10 bytes packed. How does that work?13_BL.Tink Tysor16_tink@BLTYSOR.COM30_Wed, 8 Aug 2001 18:35:57 -0700396_us-ascii Mike,
Not really unless you consider the year 01/01/0001 midnight the specific point in time. DB2 truly stores the time stamp in yyyymmddhhssMMmmmmmm where each digit is stored in a nibble, two nibbles to a byte so 10 bytes.
I do believe that Oracle stores dates as an offset from a point in time. But their internal storage of numbers is entirely different than DB2. [...]
5422 71 58_Re: Unload-Reload problems changing size of numeric fields13_BL.Tink Tysor16_tink@BLTYSOR.COM30_Wed, 8 Aug 2001 19:17:12 -0700603_us-ascii Dirk,
If I understand you correctly, currently the numbers are being divided by 100, and you do not want them to be.
This might be because in the load control file, the field definition (i.e. NUM(15,2) describes the attributes of the input file, not the column. DB2 get the target column information from the catalog. Since the unload file was created from a column of NUM(13,0), and if you have done nothing to change the data on the unloaded file, then your load control file should also show NUM(13,0). This would explain your problem if you also had POSITION (start,end) [...]
5494 35 56_Re: WebSphere-DB2 Connect EE Connection Pooling question18_Subbarao Mupparaju15_Msmail1@AOL.COM28_Thu, 9 Aug 2001 01:15:11 EDT162_US-ASCII Dave,
Thank you very much. We are also not using the Connect Connection pooling in conjunction with Websphere Connection Pooling.
Subbarao.
5530 65 17_Re: DB2 Questions13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU30_Thu, 9 Aug 2001 14:55:54 +1000387_iso-8859-1 Its the baby DB2 versions, not os/390. It allows you to restore to database B from a backup of database A. Seems like the baby can teach granddad a thing or two. :-)
Regards,
Steve T
-----Original Message----- From: Venkatesh Mokshagundam [mailto:Vmokshagun@CSEDGE.COM] Sent: Thursday, 9 August 2001 5:11 AM To: DB2-L@RYCI.COM Subject: DB2 Questions [...]
5596 112 17_Re: DB2 Questions18_Richard Mccutcheon32_Richard_McCutcheon@HCM.HONDA.COM30_Thu, 9 Aug 2001 01:45:41 -0400446_us-ascii The redirected restore has to do with restoring db A to db B where db A has DMS tablespaces.
That means that db A has Database Managed Storage for its tablespaces. When the restore is to be done, the REDIRECT option is used. The REDIRECT clause allows you to then set the new location for all the tablespaces in the restored database (otherwise the new database will continue to use the old locations. usually not so good.). [...]
5709 71 17_Re: DB2 Questions12_tim malamphy20_timalamphy@YAHOO.COM30_Wed, 8 Aug 2001 12:42:32 -0700555_us-ascii It's a Unix thing (I'm not sure about Windows) for when you want to move a database from one group of physical disk drives to a different group of drives (or filesystems). --- Venkatesh Mokshagundam wrote: > I'm posting this for one of my colleagues: > > What is DB2 "REDIRECTED RESTORE"? Where and when is > it used? Is it new? Is > it Platform specific, because I had never heard of > it on DB2 OS/390. > > Thanks, > > Venkatesh Mokshagundam > > > Database Administrator > > Corporate Systems > > Amarillo, Texas > [...]
5781 43 37_Re: Discarding rows in ONLINE REORG ?16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Thu, 9 Aug 2001 12:36:01 +0530590_- One other restriction is DISCARD is not valid with UNLOAD ONLY and EXTERNAL reorg options. So, its better going thru' manual before really using this option. This would give you better understanding on syntax/restrictions etc
Regards Sanjeev
> > -----Original Message----- > > From: Jacob Ganzel [SMTP:jacobg@SEMECH.CO.IL] > > Sent: Wednesday, August 08, 2001 4:02 PM > > To: DB2-L@RYCI.COM > > Subject: Discarding rows in ONLINE REORG ? > > > > Hello list . > > Is there a way to discard selected rows in ONLINE REORG running in DB2 > > for OS/390 V7 environment? > > [...]
5825 27 18_DB2 V7 Online Load12_Bernd Kasper19_Bernd_Kasper@GMX.DE30_Thu, 9 Aug 2001 10:37:29 +0200239_us-ascii Hello all,
I have a question to the new online load utility in DB2 Version7.
Does anybody know if It's possibel to write checkpoints (commits) in the online load?
with kind regards Bernd Kasper
5853 82 58_Re: Unload-Reload problems changing size of numeric fields30_Pablo Gomez de la Parra Garcia14_pgp@IESPANA.ES30_Thu, 9 Aug 2001 11:09:42 +0200518_iso-8859-1 Hi listers!!
We have got a problem: How can I turn off the autocommit option in DB2? I am programing using Java and JDBC2.0, so I can't turn it off programming, I have to do it by configuring something in DB2. Do you know where?
Thanks
----- Original Message ----- From: "S, Sanjeev (CTS)" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, August 08, 2001 11:34 AM Subject: Re: Unload-Reload problems changing size of numeric fields [...]
5936 13 36_recovery involving diff tablespaces.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM30_Thu, 9 Aug 2001 04:29:13 -0500457_- Two tables TableA and TableB are bound by a RI and lie in 2 diff tablespaces,tablespaceA and tablespaceB. An aborted update of TableA (parent) causes a RECOVER of tablespaceA. Should tablespaceB also be recovered?
================================================ 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.
5950 33 40_Re: recovery involving diff tablespaces.16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Thu, 9 Aug 2001 15:31:44 +0530698_- Its better to use REPORT TABLESPACESET in this case so that all the constraints bound tablespaces are determined and then recovered all of them to a consistent state.
Regards Sanjeev
> -----Original Message----- > From: Rajendra Deshpande [SMTP:rajendra_deshpande@HOTMAIL.COM] > Sent: Thursday, August 09, 2001 2:59 PM > To: DB2-L@RYCI.COM > Subject: recovery involving diff tablespaces. > > Two tables TableA and TableB are bound by a RI and lie in 2 diff > tablespaces,tablespaceA and tablespaceB. An aborted update of TableA > (parent) causes a RECOVER of tablespaceA. Should tablespaceB also be > recovered? > > ================================================ > To change [...]
5984 24 22_Re: DB2 V7 Online Load13_Patric Becker25_Patric_Becker@SIS-WEST.DE30_Thu, 9 Aug 2001 05:19:42 -0500523_- Hi Bernd !
There was a good presentation at DB2 and IMS Tech. Conf. in Hamburg this year looking at new V7 features were Roger Miller said that "Online Load Resume had an intelligent management of commit scope to avoid lock contention with SQL" (hope that I quoted him correctly). I also asked the question about having an influence on the commit scope, but he told me that there is no possibility to change the commit scope. The presentation was called "DB2 UDB for OS/390 Version 7 : A Technical Overview". [...]
6009 46 40_Re: DB2 connect EE for AIX configuration11_Paul Turpin32_pault@ALUMMAIL.SSB.ROCHESTER.EDU30_Thu, 9 Aug 2001 05:44:13 -0500446_- This is to further clarify how to get the hostname/ip and port that was mentioned in Sai's response.
I will assume for the purpose of answering your question that you are sure that the DB2 subsystem (on OS/390) is TCP/IP-enabled. There is some "magic" that the systems programs have to work to accomplish this. They usually register the two ports for the DB2 subsystem to prevent others from using those ports for other subsystems. [...]
6056 50 12_Re: DB2 TMON12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Thu, 9 Aug 2001 07:51:40 -0400483_us-ascii We have 2 for all DB2's on BSYS. High Cpu Time and Tablespace Extend Failed.
Philippe Herman @RYCI.COM> on 08/08/2001 04:58:13 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: DB2 TMON
Jeff,
What are the exceptions that are active in the TMON DB2 [...]
6107 150 17_Re: DB2 Questions16_Michael McCarthy18_mmccarthy@DTCC.COM30_Thu, 9 Aug 2001 08:05:09 -0400452_us-ascii A redirected restore, can be done against tablespaces defined as sms. For the same reasons as with dms, you may want to alter the sms path to the data, especially if the new database to restore to is in the same machine.
-Mike.
'Richard Mccutcheon' @RYCI.COM> on 08/09/2001 01:45:41 AM
Please respond to DB2 Data Base Discussion List [...]
6258 192 17_Re: DB2 Questions0_20_John_Lendman@FPL.COM30_Thu, 9 Aug 2001 08:34:51 -0400459_us-ascii And for all you out there that are mainframe only, this restore only works on DB2 UDB on the client/server boxes.
John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413
"Michael McCarthy" To: DB2-L@RYCI.COM Subject: Re: DB2 Questions Sent by: "DB2 Data Base Discussion List"
08/09/01 08:05 AM Please respond to "DB2 Data Base Discussion List" [...]
6451 156 26_Re: Oracle gateway and DB20_19_mike.holmans@BT.COM30_Thu, 9 Aug 2001 13:52:40 +0100398_iso-8859-1 I know this isn't going to be a lot of comfort, but we have the same problems as you do. My (and several of my colleagues') opinion is that the OTG is a very irritating, not to mention inadequate, beast. We haven't found any ways of dealing with the problems other than bouncing the gateway either, so if anyone does know different, I too would be most interested to hear about it. [...]
6608 22 19_QMF modules in PLPA12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL30_Thu, 9 Aug 2001 08:06:21 -0400543_us-ascii Is anyone out there putting the QMF module listed on page 24 of QMF6.1 installation guide, in the PLPA and if so why and what changed performance wise.
Stan Goodwin IBM Senior I/T Specialist DECC MBG DB2 Support
Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6631 46 22_Re: DDCS IVP program ?12_tim malamphy20_timalamphy@YAHOO.COM30_Thu, 9 Aug 2001 06:11:32 -0700389_us-ascii Since you said "TO" OS/390, there's a button on the client configuration assistant box that says "test connection" or just "test" depending on version.... Start > Program > IBM for DB2 > Client configuration assistant > left-click on database-name and then hit the "test" button. OR Get a db2 prompt (on AIX or NT) then Connect to database-name user username using password. [...]
6678 98 23_Re: Number of DB2 Sites16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Thu, 9 Aug 2001 15:05:30 +0100407_us-ascii Thanks for the input Steve ;-)
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.
Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com
1 Archipelago Lyon Way Frimley Camberley Surrey GU16 7ER UK
* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER [...]
6777 20 40_Re: DB2 connect EE for AIX configuration13_Bob J. Hooper20_rjhooper@SHERWIN.COM30_Thu, 9 Aug 2001 10:05:37 -0400355_us-ascii Hello everyone, I am in the beginning stages of setting up DB2 Connect and ran into the following problem when trying to connect: SQL State 57017. How do you set code page for DB2 connect? Is there a CCSID issue? We have the location and the port nailed down, what can you tell me about catalog and data base name? Thanks for your help. Bob [...]
6798 58 24_Re: DDL generation tools27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Thu, 9 Aug 2001 10:13:15 -0500312_iso-8859-1 Roy,
If you search the archives for the subject "Gen DDL from DB2 Catlg V2 - Setup and Sample Output", you'll find some posts from 1999 that may help, without costing you any money. I never used it, though, so I can't verify it's accuracy or if changes are needed for your release of DB2. [...]
6857 27 29_Managing Stored Procs/Schemas11_David Nance16_DWNance@FHSC.COM30_Thu, 9 Aug 2001 11:15:29 -0400584_US-ASCII OS/390 DB2/V6 No WLM I have a question about how other sites are managing their stored procs in development/test subsystems. Our test and development tables are in the same subsystem, using different qualifiers. We use the qualifier name as the schema name to keep things simple. I have a cobol stored procedure that accesses application tables, can I use a single load module under two different schemas with the package itself being bound to each qualifier. The other day while trying to test this the only way I could get it to work was to recompile the proc under a [...]
6885 123 58_Re: Unload-Reload problems changing size of numeric fields13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Thu, 9 Aug 2001 08:28:29 -0700462_us-ascii I thought you could turn off autocommit in java. Try this code:
con = DriverManager.getConnection(url); // turn off autocommit con.setAutoCommit(false);
Thanks. Ashish.
-----Original Message----- From: Pablo Gomez de la Parra Garcia [SMTP:pgp@IESPANA.ES] Sent: Thursday, August 09, 2001 2:10 AM To: DB2-L@RYCI.COM Subject: Re: Unload-Reload problems changing size of numeric fields Importance: High
Hi listers!! [...]
7009 141 26_Re: Oracle gateway and DB217_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT30_Thu, 9 Aug 2001 17:30:22 +0100449_iso-8859-1 In our shop we run with both OTG V4 & V8 and we faced a lot of problem with V4 in the past expecially with memory problems. What I can say is "Stress the Oracle Support" to obtain a solution as soon as possible else, be sure, they'll leave you with your problem forever. I faced a lot of crash of the V4 address space with S106, S80A etc per day, and an IPL one time, and only after a long time and a lot of call I obtained the PTF. [...]
7151 99 24_Re: DDL generation tools16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Thu, 9 Aug 2001 17:11:48 +0100393_us-ascii Roy,
this is a vendor's plug :-)
Candle have a nice not-too-expensive set of tools, known as !DB/Workbench, which would help you with your DDL generation, as well as doing lots of other nice and neat things for you and your DB2.
I have been told that the next version might also make nice coffee, although I cannot vouch for the quality of said beverage ;-) [...]
7251 117 24_Re: DDL generation tools16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Thu, 9 Aug 2001 17:13:45 +0100363_us-ascii Hi Ray,
were you on holiday lately? you're back and full of beans :-)
you could also contact your friendly local Candle rep ;-) thanks for the plug. ooops referral, cheque's in the post, I'll call you tomorrow, you're the best, I'm a natural blonde...
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. [...]
7369 40 46_Loading negative values into DB2/UDB table ...15_Stephen Poulsen36_stephen.r.poulsen@CO.MULTNOMAH.OR.US30_Thu, 9 Aug 2001 12:18:35 -0500546_ISO-8859-1 We are having trouble loading a DB2 table in Unix. The load returns the error:
SQL3123W The field value in row “1” and column “30” cannot be converted to a PACKED DECIMAL value. A null was loaded.
The input file to the load originates on a mainframe and includes data fields with negative values. The load file was FTP’d to the database server (tried both binary and character formats). The load looks like this (although we have tried all kinds of other modifier variations in an attempt to get the thing to work): [...]
7410 192 56_Re: Heads up for European folks from Computer Associates15_Ronald J Mangan21_Ron_J._Mangan@FPL.COM30_Thu, 9 Aug 2001 13:35:20 -0400613_iso-8859-1 To remove foot from mouth, please use the BMC extraction tool!
"Rasmussen, Steen" To: DB2-L@RYCI.COM Subject: Re: Heads up for European folks from Sent by: "DB2 Computer Associates Data Base Discussion List"
08/08/01 03:53 PM Please respond to "DB2 Data Base Discussion List"
I know this is a little late - but I really think the local Marketing people together with all of you working with DB2 should copy what we're doing in Scandinavia: [...]
7603 77 50_Re: Loading negative values into DB2/UDB table ...12_McKown, John22_JMckown@HEALTHAXIS.COM30_Thu, 9 Aug 2001 12:47:00 -0500401_iso-8859-1 The problem, as I see it, is that the last character of the data in question is not a valid decimal digit. It is a }. This is what the mainframe produces with a COBOL description such as
VAR-NAME PIC S9(5).
The last character is contains the coded sign. My suggestion is to change the program which is unloading the information and make the COBOL declaration similar to: [...]
7681 25 36_dynamic caching of statements in EDM10_Tom Taylor17_ttaylor@CHUBB.COM30_Thu, 9 Aug 2001 13:45:32 -0400337_us-ascii Hi all
Dynamic cahing questions
1) Do the dynamic cache statements held in the EDM pool contain host varaibles or real values?
If the answer is host variables, then how can I find the auth id ?
I currently have 5 versions of the same statement ( from what i can see) in cache any ideas? [...]
7707 26 28_Utility To Update Statistics20_Nadeau, Kevin M B22522_Kevin.Nadeau@CIGNA.COM30_Thu, 9 Aug 2001 13:30:31 -0400731_us-ascii Hi Everyone,
I was wondering if anyone has written a utility, or knows of one that migrates statistics from one DB2 subsystem to another.
Thanks, Kevin Nadeau CIGNA HealthCare
------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. [...]
7734 74 27_FW: Binding for DRDA access9_Paul Gose17_pmgose@SRPNET.COM30_Thu, 9 Aug 2001 11:15:33 -0700593_iso-8859-1 We dealt with this problem by creating an alias on the local system for the remote table using its three part name (location.creator.table). We then decided to pull the explicit connection SQL (CONNECT, CONNECT RESET and SET CONNECTION) out of the program and allow DB2 to connect implicitly. We are using packages and we bound the local package with DBPROTOCOL(DRDA), but in Horacio's case I suppose that would be specified on the plan bind. The remote table was in a DB2 for NT database and we bound the package there with VALIDATE(RUN) to avoid the -204 on the local table, [...]
7809 45 32_Re: Utility To Update Statistics13_Terry McCombs20_tmccomb@SEDGWICK.GOV30_Thu, 9 Aug 2001 13:19:57 -0500436_iso-8859-1 I believe DBA-Xpert will do that, although I don't use that feature.
-----Original Message----- From: Nadeau, Kevin M B225 [mailto:Kevin.Nadeau@CIGNA.COM] Sent: Thursday, August 09, 2001 12:31 PM To: DB2-L@RYCI.COM Subject: Utility To Update Statistics
Hi Everyone,
I was wondering if anyone has written a utility, or knows of one that migrates statistics from one DB2 subsystem to another. [...]
7855 89 32_Re: Utility To Update Statistics0_26_JCameron@MSI-INSURANCE.COM30_Thu, 9 Aug 2001 13:49:36 -0500484_us-ascii There is SQL that generates output SQL in the Administration Guide for Version 5 (page 5-254) under : Modeling Your Production System.
JCameron@msi-insurance.com 651.631.7188
Terry McCombs cc: Sent by: DB2 Subject: Re: Utility To Update Statistics Data Base Discussion List
08/09/01 01:19 PM Please respond to DB2 Data Base Discussion List [...]
7945 16 19_separate subsystems11_Danny Davis16_DTDAVIS@PCMH.COM30_Thu, 9 Aug 2001 15:31:44 -0400522_US-ASCII We are getting ready to upgrade to version 8 of Peoplesoft. We are considering putting Peoplesoft on it's own subsystem as part of the upgrade. Does anyone have any thoughts on having a separate subsytem for one app? Any help you could provide would be greatly appreciated.
===============================================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.
7962 130 50_Pittsburgh DB2 User Group Agenda - Sept 7th - Free10_Cathy Peck23_cathy.peck@HIGHMARK.COM30_Thu, 9 Aug 2001 15:45:35 -0400392_iso-8859-1 Hi everyone! Attached is the agenda for the next Pittsburgh User Group Meeting on Sept 7th. There is no cost associated w/attending so please forward to any/all interested parties.
NOTE: Please RSVP to Cathy.Peck@Highmark.com if you are planning to attend so I can get an accurate head count.
For more details/directions see our webpage http://www.db2parug.org. [...]
8093 133 51_Central PA DB2 Users Group Meeting - Sept 27 - Free10_Cathy Peck23_cathy.peck@HIGHMARK.COM30_Thu, 9 Aug 2001 15:42:51 -0400358_iso-8859-1 Hi everyone! The next Central PA DB2 Users Group Meeting is scheduled for Sept 27. If you would like to register, please contact me at 717-975-7396 or Cathy.Peck@Highmark.com.
NOTE: The agenda will be posted on the http://www.db2parug.org website shortly too. For more details & directions, see our Central PA DB2 Users Group website. [...]
8227 207 106_Central PA DB2 Users Group - Sheryl Larsen, 9/28th - DB2 for OS/390 V6/V7 Transition for Developers - $17510_Cathy Peck23_cathy.peck@HIGHMARK.COM30_Thu, 9 Aug 2001 15:43:21 -0400372_iso-8859-1 Hi everyone! Back by popular demand Sheryl Larsen is returning to Central PA for a V6/V7 Transition for Developers Class. Many of you will recall that Sheryl has visited our RUG numerous times in the past. If you would like to know what's up/coming w/DB2 V6 & V7 from an application developer's standpoint, you might want to consider attending this class. [...]
8435 32 21_CARDF in SYSTABLEPART12_Hend Dwiyono16_hdwi@HOTMAIL.COM30_Thu, 9 Aug 2001 14:16:21 -0600599_- Hi all,
I would like to ask if the experts agree on this issue :
We stop running IBM RUNSTAT on one partitioned table and let BMC Copy Plus gather statistics on SYSIBM.SYSTABLEPART. Since then, we have noticed that CARD column is being updated but CARDF is no longer being updated. Based on our research, we think that CARDF will not affect access path selection. IBM's Utility Guide lists SYSTABLES.CARDF but not SYSTABLEPART.CARDF as one of the catalog table columns used by DB2 to select access paths to data during the bind process. Does anyone concur with this statement ? [...]
8468 54 25_Re: CARDF in SYSTABLEPART15_Murley, Michael22_Michael_Murley@BMC.COM30_Thu, 9 Aug 2001 16:02:42 -0500476_iso-8859-1 Hend,
That is my understanding as well, based on the DB2 documentation. Nevertheless, we should be updating this column. I've opened a change request to find out why we're not, and to try to get it corrected.
Thanks, Michael Murley BMC DB2 Backup and Recovery Development team
-----Original Message----- From: Hend Dwiyono [mailto:hdwi@HOTMAIL.COM] Sent: Thursday, August 09, 2001 3:16 PM To: DB2-L@RYCI.COM Subject: CARDF in SYSTABLEPART [...]
8523 17 46_Connection Concentration with DB2 Connect V7.222_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM30_Thu, 9 Aug 2001 14:07:12 -0700294_iso-8859-1 DB2 Gurus, Has any body tried connection concentration with DB2 Connect 7.1? I am wondering , after reading between the lines if it will work for ODBC applications. Has anybody converted ODBC to CLI ? Please let me know if you can help me with any of these topics Thanks Ramesh [...]
8541 41 38_List prefetch with high cluster ratios22_Harish Gangadharanunni24_hari_gangadhar@YAHOO.COM30_Thu, 9 Aug 2001 14:37:32 -0700572_us-ascii Hi,
I am currently perplexed by a situation wherein the optimizer chooses list-prefetch for a highly clustered table (clusterratio - 99, this table is the inner table in the join) for an inner join between two tables (EXPLAIN shows a nested loop join between the two tables). I would also assume that almost 90% of the rows qualify for the inner table for the join. The join returns on an average about 5 million rows, and all the rows are needed by the application. The OPTIMIZE FOR n rows, does not bring any succour from a performance perspective. [...]
8583 35 50_Re: Connection Concentration with DB2 Connect V7.212_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 9 Aug 2001 17:27:47 -0700589_us-ascii I've been using for some time, with several VB apps. Ran into a few problems with threads not being terminated when we stopped DDF, but other than that it works pretty good. --- Ramesh Balasubramanyan wrote: > DB2 Gurus, Has any body tried connection concentration with DB2 > Connect 7.1? > I am wondering , after reading between the lines if it will work for > ODBC > applications. Has anybody converted ODBC to CLI ? > Please let me know if you can help me with any of these topics > Thanks > Ramesh > > ================================================ > [...]
8619 16 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM30_Thu, 9 Aug 2001 20:21:29 -0500447_us-ascii I will be out of the office starting 08/09/2001 and will not return until 08/13/2001.
I will be out of the office for the remainder of the day. I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
8636 18 45_How can you tell space available on a volume?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM30_Thu, 9 Aug 2001 21:28:41 -0400
8655 32 49_Re: How can you tell space available on a volume?26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Thu, 9 Aug 2001 20:40:22 -0500536_- The IBM way is ISMF or the batch invocation Naviquest. Do you have access to these panels?
2 Generate a New List from Criteria Below Specify Source of the New List . . 2 (1 - Physical, 2 - SMS) Optionally Specify One or More: Enter "/" to select option Generate Exclusive list Type of Volume List . . . 1 (1-Online,2-Not Online,3-Either) Volume Serial Number . . 123* (fully or partially specified) Device Type . . . . . . . (fully or partially specified) Device Number . . . . . . 0800 (fully specified) To Device Number [...]
8688 20 43_DB2 & Easytrieve - Changing table qualifier8_K.Balaji19_K.Balaji@TARGET.COM30_Thu, 9 Aug 2001 21:04:40 -0500382_iso-8859-1 Hello Mainframe experts, I was trying to keep the easytrieve code independent of table qualifier (in sql includes and in sqls) like we do in cobol. My attempt didnt succeed. Searched manuals but I couldnt find any PARM parameters to control this. I am sure many of you must have tired this. If so, can you pl share your experience. Thanks Balaji Ph # (510) 727-3259 [...]
8709 62 24_Re: DDL generation tools15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Fri, 10 Aug 2001 12:04:35 +1000321_- Yo Aurora,
Yes, I've been away, but I wouldn't call it a holiday. Long story; not relevant. In lieu of a pen/mug/other useless piece of carp (deliberate spelling mistake, but the letters are correct) I'm happy to have others realise I'm the best.
Natural blonde, huh? Can't wait for that call... ;o) [...]
8772 22 19_Long Decimal Column13_Nagar, Girish14_NAGARG@ANZ.COM31_Fri, 10 Aug 2001 12:27:42 +1000349_ISO-8859-1 Dear Listers,
We have decimal value columns with total length 26 (23 + 3 decimal point).
How you have defined columns with length greater than 18? We are running under DB2 version 6 with COBOL for OS/390 & other 4GL ie CA's EZYTREVE.
Appreciate if you could share your ideas, options.
Best regards Girish [...]
8795 109 23_Re: separate subsystems14_Philip Gunning24_Philip.Gunning@QUEST.COM30_Thu, 9 Aug 2001 19:42:27 -0700649_iso-8859-1 Danny, In my opinion Peoplesoft needs it's own subsystem. There are fixes and mini-upgrades and upgrades that are done on a regular basis and this maintenance can disrupt production and degrade subsystem performance. We did it that way and it worked out real well. Additionally, testing new Peoplesoft releases,fixes, etc should be a rigorous process and could disrupt test, development and production if not separated. These are more operational and support reasons than technical, but since Peoplesoft is primarily dynamic SQL you need to set certain zparms to take advantage of dynamic caching, etc. We did look at collapsing our [...]
8905 61 33_Re: Managing Stored Procs/Schemas10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 10 Aug 2001 13:21:32 +1000367_us-ascii Dave,
We do it all the time. We have different environments on the same subsystem, (no WLM). Hence only one SP address space. We have the same load module for all the environments. We compile the SP into one environment, and just bind copy the packages into the others. This works as long as long the module can be the same for all environments. [...]
8967 30 23_Re: Long Decimal Column11_John McKown17_joarmc@SWBELL.NET30_Thu, 9 Aug 2001 22:12:18 -0500304_US-ASCII The only way that I know is to use the latest version of COBOL, 2.2, which allow for 31 decimal digits if the compile parm 'ARITH(EXTENDED)' is used. I think that's the right one - I'm at home right now without any manuals. I don't know if such is supported by the DB2 precompiler, though. [...]
8998 88 42_Re: List prefetch with high cluster ratios18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Fri, 10 Aug 2001 10:32:39 +0500458_- Harish The following is what I could gather from Admin guide about when List prefetch would be used:
5.10.5.2.2 When it is used
list prefetch is used:
Usually with a single index that has a cluster ratio lower than 80%.
Sometimes on indexes with a high cluster ratio, if the estimated amount of data to be accessed is too small to make sequential prefetch efficient, but large enough to require more than one regular read. [...]
9087 80 42_Re: List prefetch with high cluster ratios16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 10 Aug 2001 11:03:54 +0530322_- Harish,
Before commenting anything i would like to have a look at the query, explain and statistics. I had seen one of the query in past but that was genuinely doing list prefetch as number of qualifying rows were not too much for sequential prefetch. Do not use Optimize for 1 row, it will kill everything. [...]
9168 25 19_DB2 JDBC 2.0 driver10_praveen_kj19_praveen_kj@INFY.COM31_Fri, 10 Aug 2001 11:10:54 +0530436_iso-8859-1 > Hi, > > I am using IBM DB2 Connect along with its JDBC driver. > I wanted to know, whether the DB2 JDBC driver supports JDBC 2.0. > I tried using features of JDBC 2.0 but they dont seem to be supported. > Although the DB2 documentation says that DB2 JDBC 2.0 driver supports > those features, specifically the scrollable result sets and batch > updates. > > Any pointers to this would be helpful. > > Regards, Praveen [...]
9194 15 51_Chuck Bonner/Santa Teresa/IBM is out of the office.12_Chuck Bonner22_chuckbonner@US.IBM.COM31_Fri, 10 Aug 2001 00:43:15 -0600398_us-ascii I will be out of the office starting August 9, 2001 and will not return until August 13, 2001.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9210 78 25_Re: CARDF in SYSTABLEPART16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 10 Aug 2001 12:16:45 +0530329_- Hend,
I also came across this when i was exploring the option of _HIST tables in V7 for OS390. CARDF in TABLEPART is used for space stats and in TABLES used for accesspath. So, if IBM mentioned that then TABLEPART CARDF will not have any effects on performance but do you run runstats only with accesspath option ? [...]
9289 115 33_Re: Managing Stored Procs/Schemas15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Fri, 10 Aug 2001 10:47:56 +0200537_iso-8859-1 Kals, Ted,
I'm just curious what kind of environments you do have under the same subsytem. Because when a stored procedure abends it might tear down the adresspace, with all the remaining stored procedures in it. Do you have a sort of crash-procedure when not using WLM?
In telling the difference between stored procedures in different environments, you might consider different loadmodules for different environments. like: xxD000 - Development xxT000 - Test xxQ000 - Quality Assurance xxP000 - Production [...]
9405 91 24_Re: DDL generation tools14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Fri, 10 Aug 2001 06:01:19 -0500493_iso-8859-1 Use DB2 Connect, V7, run Control Center against the OS/390, and use the facility to unload the entire DDL for any object or database. Uses the DB2 Windows/Unix tool, DB2LOOK against the OS/390 Catalog to do exactly what you require. I do not have all the required notes in front of me, but those are the basics. DB2look has been doing this for years on non OS/390, but now can be used to point at the OS/390 Catalog. If I find my detailed notes on this, I will post them here. [...]
9497 31 26_Stored procedures and RRS.17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Fri, 10 Aug 2001 13:14:12 +0100554_us-ascii We're using SP in WLM mode with RRS, I'd like to know if anybody is using SP like us and if he/she's never experienced problem with RRS structure failure or similar. Any help will be appreciated.
Tnx in advance.
Massimo Biancucci Technical Engineering Mainframe Technical Support-database T-Systems Italia debis IT Services Italia S.p.A. Via degli Ontani, 25 36100 - Vicenza (VI) Phone: +39 0444558110 Fax: +39 0444558232 Mobile: +39 3482558906 e-mail: Massimo.Biancucci@t-systems.it Internet: http://www.t-systems.it [...]
9529 21 24_Re: DDL generation tools11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Fri, 10 Aug 2001 14:21:39 +0300563_- Hello List and Richard,
Is the option of extracting ddl for OS/390 DBs available through the GUI of the Control Center.I have DB2 connect v7 installed and have also cataloged OS/390 databases but that option doesn't appear.However,it's there for NT databases (generate DDL). Regards,
Popy A. Dimoka Athens
================================================ 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.
9551 141 55_Re: Central PA DB2 Users Group Meeting - Sept 27 - Free12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Fri, 10 Aug 2001 07:23:42 -0400468_us-ascii Yea, Sign me up for this one.
Stan Goodwin IBM Senior I/T Specialist DECC MBG DB2 Support
Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335
Cathy Peck cc: Sent by: DB2 Subject: Central PA DB2 Users Group Meeting - Data Base Sept 27 - Free Discussion List
08/09/01 03:42 PM Please respond to DB2 Data Base Discussion List [...]
9693 33 26_Deadlocking in DB2 Solaris11_David Hayes28_Dave.Hayes@MORGANSTANLEY.COM31_Fri, 10 Aug 2001 12:16:09 +0100622_us-ascii (Previously posted to DB2EUG)
One of our developers has a problem with deadlocking in a UDB V6.1 Solaris environment. There are 2 processes accessing a 400K row table. One process just inserts one row, the other process just updates one row (not the same row). There is row level locking on the table. Occasionally the processes deadlock and I'm curious why. There are several indexes on the table, some of which contain many duplicate entries. For example, one index contains a Status Indicator that only has 4 different values. The updating process will update this Status field. The only predicate [...]
9727 72 30_Re: Stored procedures and RRS.0_20_John_Lendman@FPL.COM31_Fri, 10 Aug 2001 07:30:54 -0400269_us-ascii We are using it indirectly with SAP 4.6C. All of SAP us RRS in order to communicate with DB2, In SAP 4.6C it also uses SP to do some of the DB2 task like runstats, etc. We also use WLM in scheduling out work.
We have not had any problems with RRS. [...]
9800 67 42_ASNNM008 - DB2 data replication error -80515_Neff, Stephen R16_NeffSR@STATE.GOV31_Fri, 10 Aug 2001 08:07:05 -0400598_iso-8859-1 Hello,
I have installed DB2 UDB personnel Edition 7.1 and DB2 connect personnel edition 7.1 on WIN NT and I am trying to use the replication function. I follow the steps from the Replication Guide and Reference Data replication scenario. When I start the Apply I receive the below error. The message seems to point to a bind being needed for ASNNM008. I have looked and cannot find this dbrm. We would like to eventually use the replication function for mainframe to pc synchronization. Has anyone done this and would you be willing to share your experience? Also has anyone [...]
9868 22 23_Re: separate subsystems11_Jose' Gomez21_Jose_Gomez@WENDYS.COM31_Fri, 10 Aug 2001 08:30:33 -04009_us-ascii
9891 55 49_Re: How can you tell space available on a volume?12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 10 Aug 2001 07:58:54 -0500413_- Carlton, I didn't see that post, but my first question is what is your host OS? Are you running DB2 under Windows? Linux? AIX? Solaris? OS/390? Something else? The answer to your question is OS dependant. At least as I interpret it.
---------------------------------------------------------------------- John McKown HealthAxis
All opinions are my own and are not the opinions of my employer. [...]
9947 17 33_Re: Managing Stored Procs/Schemas14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 10 Aug 2001 08:02:17 -0500433_- Dave,
Did you consider 'NO COLLID'? (Which doesn't really mean "there's no collid", but rather "use the caller's collid".)
Really, really, really go WLM.
James Campbell
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9965 78 40_Re: DB2 connect EE for AIX configuration23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 10 Aug 2001 14:08:48 +0100459_- you also need DDF up ... on 390 ...
unless there is an easier way of doing that I do not know of .
regards
Les
-----Original Message----- From: Paul Turpin [mailto:pault@ALUMMAIL.SSB.ROCHESTER.EDU] Sent: Thursday, August 09, 2001 11:44 AM To: DB2-L@RYCI.COM Subject: Re: DB2 connect EE for AIX configuration
This is to further clarify how to get the hostname/ip and port that was mentioned in Sai's response. [...]
10044 41 23_Re: DB2 JDBC 2.0 driver12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 10 Aug 2001 06:22:06 -0700538_us-ascii What type of DB2 are you trying to access? If OS/390, then scrollable cursors are not supported until Release 7. --- praveen_kj wrote: > > Hi, > > > > I am using IBM DB2 Connect along with its JDBC driver. > > I wanted to know, whether the DB2 JDBC driver supports JDBC 2.0. > > I tried using features of JDBC 2.0 but they dont seem to be > supported. > > Although the DB2 documentation says that DB2 JDBC 2.0 driver > supports > > those features, specifically the scrollable result sets and batch > > [...]
10086 28 46_DB2 V6 and os390 V2R10 (TCP/IP or OMVS issues)12_harbry ariza24_harbry_ariza@HOTMAIL.COM31_Fri, 10 Aug 2001 23:16:52 +1000506_- Hi Guys:
We are planning to upgrade our OS390 from v2r6 to v2r10 and I would like to hear is there any issues , fixes or any gotchas to be aware of. My major concern about this upgrade is the fact that I've heard OS390 v2r10 Comunication Server (CS) has a lot of changes and maybe because we haven't got the time to do to much testing we might end up facing problems. Please any advise , hints regarding TCP/IP or OMVS issues with OS390 v2r10 will be appreciated. We are currently on DB2 V6. [...]
10115 60 23_Re: Long Decimal Column14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 10 Aug 2001 08:39:24 -0500462_- 1) According to the Appl Prog and SQL Guide, PIC S9(31) COMP-3 is acceptable to the precompiler.
2) If however, it's not acceptable to your COBOL compiler, you could try something like:
01 HV-SIGN PIC S9 COMP-3. 01 HV-HIGH-DIGITS PIC S9(15) COMP-3. 01 HV-LOW-DIGITS PIC S9(15) COMP-3.
SELECT SIGN(BIG-DECIMAL), ABS(BIG-DECIMAL)/1000000000000000., MOD(ABS(BIG-DECIMAL),1000000000000000.) INTO :HV-SIGN, :HV-HIGH-DIGITS, :HV-LOW-DIGITS [...]
10176 49 22_Re: DB2 V7 Online Load13_Bright, Randy20_Randy_Bright@BMC.COM31_Fri, 10 Aug 2001 08:48:32 -0500353_iso-8859-1 With BMC Software, Inc. LoadPlus for DB2 Online Load feature you have control over COMMIT frequency. You may specify how many rows to be loaded into each partition or table between COMMITs.
If you want more information, you may contact me offline if you wish.
Randy Bright Architect BMC Software, Inc. Randy_Bright@BMC.COM [...]
10226 29 12_Online Reorg22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Fri, 10 Aug 2001 10:54:04 -0300329_iso-8859-1 Hello,
I'm looking for a good article on DB2 Online Reorg (DB2 OS/390 V5). I came across a good one some years ago, but I cannot remember if it was an IBM redbook or where I found it. I've searched the IBM site but I couldn't find anything really useful.
Your suggestion will be highly appreciated. [...]
10256 16 33_term utility issue with scheduler13_Don Isenstadt21_disenstadt@PARKER.COM31_Fri, 10 Aug 2001 08:55:07 -0500453_- We have a job scheduler that submits a DB2 utility job. If this job does not work correctly the utility might have to be terminated. Unfortunately the userid of the scheduler is not the same as the userid of the person that will be responsible for fixing the job and terminating the utility. The person is a member of the same racf group as the userid of the job submitter under the scheduler. We are currently using db2 internal security only.. [...]
10273 172 42_Re: List prefetch with high cluster ratios22_Harish Gangadharanunni24_hari_gangadhar@YAHOO.COM31_Fri, 10 Aug 2001 07:13:53 -0700580_us-ascii Hi,
Please find the query below.
DECLARE ABCD_CURSOR CURSOR FOR SELECT A.Col1, A.Col2, A.Col3, A.Col4, A.Col5, A.Col6,
A.Col7, A.Col8, B.Col4, CHAR(B.Col5, ISO), B.Col6, B.Col7, B.Col8, B.Col9, B.Col10, B.Col11, B.Col12, B.Col13, B.Col14, B.Col15, B.Col16, B.Col17, B.Col18, B.Col19, B.Col20, B.Col21, B.Col22, B.Col23, B.Col24, B.Col25, B.Col26 FROM TableA A, TableB B WHERE A.Col1 = B.Col1 AND A.Col2 = B.Col2 AND (A.Col3 IN ('A', 'B')) AND A.Col4 IN ('ABC', 'DEF', 'HIJ', 'KLM', 'NOP') AND A.Col5 = 'N' ORDER BY A.Col1, A.Col2, B.Col3,B.Col4 [...]
10446 72 49_Re: How can you tell space available on a volume?11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Fri, 10 Aug 2001 09:12:35 -0500574_iso-8859-1 Also, if OS/390, are you talking about DB2 STOGROUPs or SMS Storage Groups? That makes a difference too.
Tina
-----Original Message----- From: McKown, John [mailto:JMckown@HEALTHAXIS.COM] Sent: August 10, 2001 7:59 AM To: DB2-L@RYCI.COM Subject: Re: How can you tell space available on a volume?
Carlton, I didn't see that post, but my first question is what is your host OS? Are you running DB2 under Windows? Linux? AIX? Solaris? OS/390? Something else? The answer to your question is OS dependant. At least as I interpret it. [...]
10519 30 13_DB2 and HACMP14_Bill Gallagher28_BILL.GALLAGHER@PHOENIXWM.COM31_Fri, 10 Aug 2001 10:15:52 -0400355_us-ascii We're looking at potentially implementing HACMP (or HACMP/ES) on our AIX database servers to provide a high-availability for our UDB database environment. We're currently running UDB EE v7.2.
I've been looking through the HACMP chapters in the Admin Guide, and there's a lot of references to UDB EEE, which leads me to two questions: [...]
10550 59 16_Re: Online Reorg12_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Fri, 10 Aug 2001 10:23:31 -0400718_us-ascii This article should be of help. http://www-4.ibm.com/software/data/db2/os390/pdf/oreorg.pdf
Claudio Meluzzi Mendes on 08/10/2001 09:54:04 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Amit Agarwal/FIS)
Subject: Online Reorg
Hello,
I'm looking for a good article on DB2 Online Reorg (DB2 OS/390 V5). I came across a good one some years ago, but I cannot remember if it was an IBM redbook or where I found it. I've searched the IBM site but I couldn't find anything really useful. [...]
10610 18 16_Re: Online Reorg15_Claudio Sanchez20_clsanchez@BNL.COM.AR31_Fri, 10 Aug 2001 11:24:49 -0300412_us-ascii Claudio,
You can't consult in this address: http://www.redbooks.ibm.com/redbooks/SG242213.html Sometime it take information from that site.
Regards
================================================ 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.
10629 61 23_Re: Long Decimal Column0_22_Rohn.Solecki@MTS.MB.CA31_Fri, 10 Aug 2001 09:29:48 -0500338_us-ascii If you look in the "OS390 V5 or V6 Application Programming and SQL Guide" section 3.4.3.7 - Determining equivalent SQL and COBOL data types, in Table 14 in the "Decimal () or Numeric ()" row it says that if 'p', total length in DB2, is greater than 18 there is no exact COBOL equivalent data type. It suggests using COMP-2. [...]
10691 56 37_Re: term utility issue with scheduler9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Fri, 10 Aug 2001 15:25:02 +0100706_us-ascii Don,
Perhaps you could set up a terminate job in your scheduler which can be run as necessary.
Chris
Don Isenstadt cc: Sent by: DB2 Subject: [DB2-L] term utility issue with Data Base scheduler Discussion List
10/08/01 14:55 Please respond to DB2 Data Base Discussion List
We have a job scheduler that submits a DB2 utility job. If this job does not work correctly the utility might have to be terminated. Unfortunately the userid of the scheduler is not the same as the userid of the person that will be responsible for fixing the [...]
10748 51 17_Re: DB2 and HACMP19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Fri, 10 Aug 2001 15:33:49 +0100639_iso-8859-1 Bill,
We're running double-E with HACMP and have been since day 1 with AIX (V5.2 and now V6.1).
Not sure whether it's HACMP/ES or plain HACMP however.
Phil
On Fri, 10 Aug 2001 10:15:52 -0400, Bill Gallagher wrote:
>We're looking at potentially implementing HACMP (or HACMP/ES) on our AIX >database servers to provide a high-availability for our UDB database >environment. We're currently running UDB EE v7.2. > >I've been looking through the HACMP chapters in the Admin Guide, and >there's a lot of references to UDB EEE, which leads me to two questions: > >1) Can UDB EE (double-E) work [...]
10800 88 49_Re: How can you tell space available on a volume?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Fri, 10 Aug 2001 10:45:32 -0400
10889 99 23_Re: Long Decimal Column12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 10 Aug 2001 09:51:49 -0500320_- I just rummaged around in the V7 version of the manual which says:
DECIMAL(p,s) S9(p-s)V9(s) COMP-3 p is precision, s is scale. 0<=s<=p<=31. If s=0 then use S9(p)V or S9(p). If s=p, then use SV9(p). If the COBOL compiler does not support 31-digit decimal numbers, there is no exact equivalent. Use COMP-2. [...]
10989 186 42_Re: List prefetch with high cluster ratios15_Walter Verboven37_walter.verboven@STATBEL.MINECO.FED.BE31_Fri, 10 Aug 2001 17:04:44 +0200318_us-ascii Harish, The extra internal sort is perhaps to be expected, as your "order by"- columns originate from 2 different tables (i.e. 2 different indexes). DB2 can avoid a sort if order columns of 1 table are in an index sequence, but I am not sure DB2 recognizes this situation with 2 indexes. Walter Verboven [...]
11176 46 31_SQL Server to DB2 UDB on AS/40014_Philip Gunning24_Philip.Gunning@QUEST.COM31_Fri, 10 Aug 2001 08:23:46 -0700258_- A friend of mine is going to be doing a SQL server to DB2 UDB migration running on AS/400. Has anyone done this and would you be willing to share your experience? Also, if you know of white papers specific to this, that info would be helpful aslo. TIA Phil
11223 232 42_Re: List prefetch with high cluster ratios22_Harish Gangadharanunni24_hari_gangadhar@YAHOO.COM31_Fri, 10 Aug 2001 08:23:33 -0700595_us-ascii Hi Walter,
DB2 does recognize this situation with two indexes. I have experience with such before.
Thanks,
Harish.
--- Walter Verboven wrote: > Harish, > The extra internal sort is perhaps to be expected, > as your "order by"- > columns originate from 2 different tables (i.e. 2 > different indexes). DB2 > can avoid a sort if order columns of 1 table are in > an index sequence, but I > am not sure DB2 recognizes this situation with 2 > indexes. > Walter Verboven > > > Hi, > > Please find the query below. > > [...]
11456 90 24_Stored Procedure Builder14_Salvatore, Joe18_SalvatoreJ@DNB.COM31_Fri, 10 Aug 2001 11:17:45 -0400424_iso-8859-1 Hi All, We are using DB2 UDB on NT using DB2 connect to gather the Data From the Mainframe. Here is the problem:
When trying to create a Stored Procedure using Stored Procedure Builder receive the following message from SQL Assist Exception:
The Table tablename does not contain any columns. Table selectons have ben modified. Make sure that the database connection still exists and try again. [...]
11547 39 23_Re: DB2 JDBC 2.0 driver13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Fri, 10 Aug 2001 10:41:37 -0500610_iso-8859-1 Praveen,
I believe the default is JDBC 1.2. There are a pair of bat files in c:\sqllib\java12 that can be used to toggle to JDBC 2.0 or back again.
HTH Dave -----Original Message----- From: praveen_kj [mailto:praveen_kj@INFY.COM] Sent: Friday, August 10, 2001 12:41 AM To: DB2-L@RYCI.COM Subject: DB2 JDBC 2.0 driver
> Hi, > > I am using IBM DB2 Connect along with its JDBC driver. > I wanted to know, whether the DB2 JDBC driver supports JDBC 2.0. > I tried using features of JDBC 2.0 but they dont seem to be supported. > Although the DB2 documentation says that [...]
11587 43 49_Re: How can you tell space available on a volume?11_Jim Medlock24_jmedlock@ALLIANCESYS.COM31_Fri, 10 Aug 2001 10:38:06 -0500
11631 44 38_Row level Trigger w/ Transition Tables11_Suresh Sane21_data_arch@HOTMAIL.COM31_Fri, 10 Aug 2001 10:39:33 -0500577_- Dear listers,
Is anyone using a row level trigger that passes transition tables to a SP? Here is an example -
CREATE TRIGGER TRIGSTPR AFTER UPDATE ON TRNTRT.BW5 REFERENCING OLD_TABLE AS OT NEW_TABLE AS NT FOR EACH ROW MODE DB2SQL BEGIN ATOMIC CALL MFLSTPR.SPSUBTRI('Y', TABLE OT, TABLE NT); END#
When a single row is updated, the table(s) contain obe row each - old & new. No problem. But with a set update that affects (say) 10 rows, the SP is invoked 10 times and each time the table(s) contain 10 rows each. We had assumed that with the FOR EACH [...]
11676 83 0_15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Fri, 10 Aug 2001 11:40:11 -0400391_iso-8859-1 We are running PeopleSoft Financials and HR/Payroll Rel 7.5 and working on the upgrade to HR/Payroll Rel 8.0 USA only. We run DB2 V6. I am looking for good documentation/information on the CCSID that should be used with PeopleSoft. Does someone have a information or a document reference on what PeopleSoft/IBM recommends? I am looking but haven't found anything yet. Thanks [...]
11760 39 29_SAP on NT using UDB version 712_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Fri, 10 Aug 2001 10:42:16 -0500131_iso-8859-1 We are just starting to install the SAP product and was wondering if any shop has SAP running on NT with UDB V7?
11800 123 38_Fw: DB2 DBA job DALLAS - NO H1-B or F19_Sue Young20_sueyoung@AIRMAIL.NET31_Fri, 10 Aug 2001 11:28:28 -0500431_iso-8859-1 I am still looking for DB2 DBA with Cobol programming experience.
JOB OPPORTUNITY
DB2 DBA - Technical Specialist
* Develop and enhance Customer Warehouse systems in distributed MVS environment * Provide technical support for Corporate Database in a DB2 environment * Review maintenance procedures * Evaluate and determine proper technical solutions * Interface effectively with other IT groups [...]
11924 86 23_Re: DB2 JDBC 2.0 driver17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Fri, 10 Aug 2001 18:02:07 +0100408_us-ascii OK the files are here ! I'm trying (Windows NT) to start the file to toggle to version 2 but i obtain an access denied to a file !!! I think I've to stop DB2 but I don't know how :-(
tnx in advance
"Shapiro, Dave" @RYCI.COM> on 10/08/2001 16.41.37
Please respond to DB2 Data Base Discussion List [...]
12011 17 42_Re: Row level Trigger w/ Transition Tables16_sylvie Vuittenez24_sylvie.vuittenez@NOOS.FR31_Fri, 10 Aug 2001 11:02:07 -0500291_- Hello, a transition table always contains all the rows which have been updated or inserted, even for a trigger "for each row" . In your example, if you want call the SP for each row updated, with the values of that row, you must use a transition variable.
Kind regards, Sylvie [...]
12029 210 42_Re: List prefetch with high cluster ratios13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Fri, 10 Aug 2001 09:20:42 -0700323_iso-8859-1 Harish,
List sequential prefetch does NOT preserve the data ordering given by the index. As RIDs are sorted in order of 'page numbers' while accessing data pages, the data is not retrieved in any particular sequence. If the data must be ordered for an ORDER BY clause an additional sort is required. [...]
12240 14 50_Re: Loading negative values into DB2/UDB table ...15_Dominic Papania31_dominic.papania@BWC.STATE.OH.US31_Fri, 10 Aug 2001 11:14:08 -0500295_- If you have FileAID product on your mainframe you can use it to reformat the original file to give you a format that will load. Sometimes easier than getting a cobol program change. This would also add one more step that would need to be maintained each time the file format is modified. [...]
12255 107 23_Re: DB2 JDBC 2.0 driver14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Fri, 10 Aug 2001 12:32:36 -0400528_iso-8859-1 From Command window: dbstop force
Or from NT Settings ==> Control Panel ==> Services ==> select DB2 and click on Stop.
-----Original Message----- From: Massimo Biancucci [mailto:massimo.biancucci@T-SYSTEMS.IT] Sent: Friday, August 10, 2001 1:02 PM To: DB2-L@RYCI.COM Subject: Re: DB2 JDBC 2.0 driver
OK the files are here ! I'm trying (Windows NT) to start the file to toggle to version 2 but i obtain an access denied to a file !!! I think I've to stop DB2 but I don't know how :-( [...]
12363 98 23_Re: separate subsystems15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Fri, 10 Aug 2001 12:33:41 -0400594_iso-8859-1 We have peoplesoft in its own subsystem. It helped us because it is heavy dynamic SQL and our other apps were not.
-----Original Message----- From: Danny Davis [mailto:DTDAVIS@PCMH.COM] Sent: Thursday, August 09, 2001 3:32 PM To: DB2-L@RYCI.COM Subject: [DB2-L] separate subsystems
We are getting ready to upgrade to version 8 of Peoplesoft. We are considering putting Peoplesoft on it's own subsystem as part of the upgrade. Does anyone have any thoughts on having a separate subsytem for one app? Any help you could provide would be greatly appreciated. [...]
12462 57 16_Trigger question12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 10 Aug 2001 12:59:42 -0500541_- I'm trying to learn some things about DB2 (we don't have it). I'm reading the "Application Programming and SQL Guide" for version 7, which I got off of the web. I'm on page 214 where I found the following example. I know that examples are not meant to be "best practice", but I just got to wondering if anybody would actually code the first trigger, or would use one similar to the second (which is my idea of how it should be done). The example does not say what the function "LARGE_ORDER_ALERT" does, but from what little I know of [...]
12520 100 25_Re: CARDF in SYSTABLEPART12_Hend Dwiyono16_hdwi@HOTMAIL.COM31_Fri, 10 Aug 2001 12:48:06 -0500395_- Thank you for all the responses. Sanjeev, maybe I should clarify that when we still ran IBM RUNSTATS, it uses update ALL on catalog tables and only after we switched to use BMC COPY PLUS with RUNSTAT option, CARDF stops being updated. I guess if CARDF in SYSTABLEPART is used for space stats, the question is whether space stats affects system performance at all if it is not up to date. [...]
12621 97 46_Re: ASNNM008 - DB2 data replication error -80515_Neff, Stephen R16_NeffSR@STATE.GOV31_Fri, 10 Aug 2001 14:17:16 -0400482_iso-8859-1 Thks for your response. The apply and capture are running on a WIN nt machine with db2 udb v7.1 installed. I am running a generic straight replication scenario example given in the replication guide documentation. When I use the control center to view the packages bound by the example it shows packages bound with nullid. What I can't find no matter where I look is ASNNM008. I could try binding with at different collection/schema id but I don't know what to use. [...]
12719 86 25_Re: CARDF in SYSTABLEPART12_Jim Harrison12_jimh@QIS.NET31_Fri, 10 Aug 2001 14:28:51 -0400542_us-ascii We ran into the same problem with BMC stats and switched back to IBM for the time being. I'm pretty sure BMC is working on the problem and may have a fix for it. I'll try and find out Monday when I'm in the office.
At 12:48 PM 8/10/01 -0500, Hend Dwiyono said: >Thank you for all the responses. >Sanjeev, maybe I should clarify that when we still ran IBM RUNSTATS, it >uses update ALL on catalog tables and only after we switched to use BMC >COPY PLUS with RUNSTAT option, CARDF stops being updated. >I guess if CARDF in [...]
12806 105 63_IT Specialist, DB2 Database Administrator - In Portland, Oregon14_Johnson, Daryl28_Daryl.Johnson@PACIFICORP.COM31_Fri, 10 Aug 2001 11:45:53 -0700681_iso-8859-1 IT Specialist, DB2 Database Administrator @ PacifiCorp
DB2 DBA position open in Portland, Oregon. This position requires experience in mainframe data base administration, using DB2 version 6 or higher and IBM, Platinum and BMC utilities. Knowledge of and experience in buffer pool tuning, designing and building indexes and table spaces. Technical skills including JCL, programming (PL1, COBOL, REXX or other programming languages) and setup, configuration of DB2 components. The position is responsible for working with clients to design and implement a data base architecture to ensure needed information is readily available and performance is maximized. [...]
12912 30 50_Why DB2 is not using index with matching columns 115_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Fri, 10 Aug 2001 15:00:53 -0400567_iso-8859-1 I have query as follows
select b.col2 from tab1 a, tab2 b where a.col1 = 123 and b.col1 = substr(char(a.col1),1,9)
in this a.col1 is integer and b.col1 is char(9). We have index on a.col1 and b.col1. DB2 uses index on a.col1 with matching column 1, but does a index scan with zero matching column on the index with b.col1 even though b.col1 is the first column in the index. This is doing a nested loop join. Why DB2 cannot use the index on b.col1 with one match column. Since DB2 already got a.col1 from tab1 ( Tab1 is accessed first), [...]
12943 91 20_Re: Trigger question11_Suresh Sane21_data_arch@HOTMAIL.COM31_Fri, 10 Aug 2001 14:19:45 -0500355_- John,
I agree with you partially.
Re. using WHEN to limit when SP/UDF is called ==> yes, your way will eliminate unnecessary calls.
Re. statement-level v/s row-level ==> if multiple rows are inserted (via INSERT INTO ...SELECT FROM), you would invoke the SP/UDF multiple times while the original one would invoke it once only. [...]
13035 126 20_Re: Trigger question12_McKown, John22_JMckown@HEALTHAXIS.COM31_Fri, 10 Aug 2001 14:35:04 -0500279_- Suresh, I think that I understand. In the FOR STATEMENT, the procedure is only called once. And since the procedure does not change any values in the row, it is better due to less overhead. But if I needed to use a SET type operation, then the FOR ROW would be necessary. [...]
13162 135 20_Re: Trigger question13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Fri, 10 Aug 2001 12:35:07 -0700482_iso-8859-1 Suresh,
I am confused here. IBM's example says 'FOR EACH STATEMENT'. Doesn't it mean that Triggered action (in this case SELECT LARGE_ORDER_ALERT ..... ) will be executed just once for the triggering SQL operation (in this case INSERT). The way I understand it is, that the number of times the triggered action executes does not depend upon the no. of rows inserted. If that is the case, what 'unnecessary calls' are you referring to in your first statement? [...]
13298 32 42_Re: List prefetch with high cluster ratios8_Harish G24_hari_gangadhar@YAHOO.COM31_Fri, 10 Aug 2001 14:35:40 -0500546_- Hi,
The RUNSTATS has been run always, and is current. My assumption that 90% of the rows gets selected is based on my comparison of the cardinalities existing in the second table, and the distinct values of each column in the clustering index of the second table that gets selected on execution of the join. For eg:- Consider a column in the clustering index of the second table. Let the column cardinality of this column be 100. When the join is executed the no. of distinct values selected for the same column is around 90 to 95. [...]
13331 21 23_DB2 Connect help needed13_Bob J. Hooper20_rjhooper@SHERWIN.COM31_Fri, 10 Aug 2001 15:50:43 -0400515_us-ascii Hi, I am trying to use DB2 Connect into DB2 6.1 OS/390 and I get an error message stating it cannot find the remote data base. I try any data base and it cannot find it. DDF is running on tcp port 5570 and host name is hostz. Do I have to specify location somewhere in the DB2 connect setup? The location name is displayed when I look at it from the sdsf log when DDF is started. I have specified EXTSEC yes and TCPALVER yes in the ZPARM. What am I missing? Any help would be greatly appreciated! Bob [...]
13353 71 15_Re: DB2 Connect13_McHugh, Gerry21_MchughG@DIVINVEST.COM31_Fri, 10 Aug 2001 14:59:22 -0500591_ISO-8859-1 If you're using Java everything is dynamic SQL. Even SQLJ is dynamic (surprise) under the covers at this point in time.
1) Security. Use a generic RACF id and non-expiring password in an ini or db2cli.ini file. Make sure some type of encription technique is used so no one but admins know the password. This is important because this is the id that will be authenticated when the DDF calls the RACF routines. This id also needs whatever table access is being done by the app, since dynamic SQL authority is performed at runtime. Therefore, this becomes a powerful id. [...]
13425 77 11_CDB/Quiesce14_Jennifer Moody22_jmoody@CDBSOFTWARE.COM31_Fri, 10 Aug 2001 15:14:36 -0600619_ISO-8859-1 http://www.cdbsoftware.com/press-releases07.html
For Immediate Release
For Further Information Contact: Jennifer Moody 800-627-6561
CDB Software Announces a Better Quiesce Solution!
CDB Software, Inc, of Houston, Texas, announces the newest edition to its
suite of true 24X7 utility solutions, CDB/QUIESCE (R). CDB Software"s CDB/QUIESCE utility maintains read-write access to DB2(R) for OS/390(R) and z/OS(R) objects 100% of the time while running and will not cause applications to receive resource unavailable conditions (-904s) or timeouts (-911s) due to QUIESCE. [...]
13503 167 20_Re: Trigger question11_Suresh Sane21_data_arch@HOTMAIL.COM31_Fri, 10 Aug 2001 15:57:56 -0500655_- Ashish,
I think we are saying the same thing. IBM example used FOR EACH STATEMENT. John's "rewrite" changed it to FOR EACH ROW. I was simply pointing out that he would end up with a call to the SP/UDF multiple times - original IBM would call only once.
HTH
Suresh
>From: "Mohan, Ashish" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Trigger question >Date: Fri, 10 Aug 2001 12:35:07 -0700 > >Suresh, > > I am confused here. IBM's example says 'FOR EACH STATEMENT'. >Doesn't >it mean that Triggered action (in this case SELECT LARGE_ORDER_ALERT ..... [...]
13671 132 49_Re: How can you tell space available on a volume?12_Dallas Focht21_dallas.focht@PMIC.COM31_Fri, 10 Aug 2001 16:19:53 -0500689_us-ascii I would be interested in the REXX routines also. I have been using DCOLLECT and loading to a couple of DB2 tables for running queries. Also, do you know what needs to be done to enable REXX to issue SQL calls.
Thanks.
Jim Medlock wrote:
> ----------------------------------------- (on viruswall) > > email-body was scanned and no virus found > --------------------------------------------------------- > > ---------------------------------------------------------------- > > Carlton, > > > > Several years ago I developed a Rexx program that reads the output of > the IDCAMS DCOLLECT command to create a formatted space report for my > DB2 volumes. I've [...]
13804 210 42_Re: List prefetch with high cluster ratios15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Fri, 10 Aug 2001 16:34:40 -0500430_us-ascii Hari, LEAFDIST might have grown , if LEAFDIST is grater than 200 then reorg is required. So its better first you do reorg & runstats then REBIND and see what you get in plan table.
Regards Nayeem
Harish Gangadharanunni To: DB2-L@RYCI.COM Subject: Re: List prefetch with high cluster Sent by: DB2 ratios Data Base Discussion List [...]
14015 83 49_Re: How can you tell space available on a volume?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Fri, 10 Aug 2001 18:26:52 -0400
14099 126 27_Re: DB2 Connect help needed14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Fri, 10 Aug 2001 15:30:20 -0700424_iso-8859-1
Bob, I would suggest you get the Redbook, WOW! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 Universal Database, SG24-2212-00. It is a little old but still the best all encompassing manual on how to setup DB2 on OS/390 (DDF and OEMVS) and clients. HTH Phil
-----Original Message----- From: Bob J. Hooper To: DB2-L@RYCI.COM Sent: 8/10/01 12:50 PM Subject: DB2 Connect help needed [...]
14226 134 27_Re: DB2 Connect help needed19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Fri, 10 Aug 2001 23:42:32 +0100528_iso-8859-1 Phil,
The Certification Guide is pretty good as well - and probably more up to date.
Phil N
--Original Message Text--- From: Philip Gunning Date: Fri, 10 Aug 2001 15:30:20 -0700
RE: DB2 Connect help needed
Bob, I would suggest you get the Redbook, WOW! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 Universal Database, SG24-2212-00. It is a little old but still the best all encompassing manual on how to setup DB2 on OS/390 (DDF and OEMVS) and clients. HTH Phil [...]
14361 198 27_Re: DB2 Connect help needed14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Fri, 10 Aug 2001 16:01:24 -0700396_iso-8859-1 I am pretty attached to that Redbook, I would like to see it updated to include DB2 Connect, DDF, connection pooling and concentration.:) Phil
-----Original Message----- From: Philip Nelson (DBA) To: DB2-L@RYCI.COM Sent: 8/10/01 3:42 PM Subject: Re: DB2 Connect help needed
Phil,
The Certification Guide is pretty good as well - and probably more up to date. [...]
14560 53 26_Load problem - please help23_AITHA, BHEEMSEN (SBCSI)14_ba2984@SBC.COM31_Fri, 10 Aug 2001 16:10:40 -0700401_ISO-8859-1 Hi,
I was trying to load a table from its unload. The unload was taken using IBM's DSNTIAUL utility. I am loading using DSNUTILB utility. I am getting the following error.
Can some one please help on what went wrong.
When I used the same dataset to load the table using Fileaid for DB2 panels the table was loaded successfully. I could not understand the problem. [...]
14614 71 54_Re: Why DB2 is not using index with matching columns 10_24_ujjwal@LOT.TATASTEEL.COM31_Sat, 11 Aug 2001 09:17:11 +0530425_us-ascii Are u in DB2 V5 because in DB2 V5 the substr function prohibits it from using indexed access but from DB2 V6 it allows Substr funtion to be used as Indexed access.
Regards Ujjal Bhattacharya
"Philip, Sibimon" To: DB2-L@RYCI.COM Subject: Why DB2 is not using index with Sent by: DB2 matching columns 1 Data Base Discussion List [...]
14686 16 52_Jose Laserna Herraiz/Spain/IBM is out of the office.20_Jose Laserna Herraiz22_joselaserna@ES.IBM.COM31_Sat, 11 Aug 2001 08:18:18 +0200442_us-ascii I will be out of the office starting August 10, 2001 and will not return until September 3, 2001.
I will respond to your message when I return. Vuelvo de vacaciones el 3 de septiembre.
================================================ 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.
14703 33 14_UNLOAD UTILITY13_Harry William27_harry_williamtk@HOTMAIL.COM31_Sat, 11 Aug 2001 06:24:49 +0000477_- Hi Lister,
We unload data everyday between 17:30 hrs to 18:30 hrs. we use the platinum fast unload utility for this purpose.We unload data from 300 tables distributed in 7 set of jobs.Certain tables have more than 15 million records. What we noticed is whenever the unload jobs are scheduled,the response time for online users increases. Sometimes it takes more than 10 minutes to retrieve data on the screen.I am not sure what causes the delay in response time. [...]
14737 215 42_Re: List prefetch with high cluster ratios18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Sat, 11 Aug 2001 13:50:10 +0530535_- Walter,
TableA has a clustering index defined on Col1 and Col2. TableB has a clustering index defined on Col1,Col2, Col3 and Col4. If a nested loop join is being executed then the rows from outer/first(TableA) table would be returned in the order of COL1 & COL2 (99% cluster ratio) and the matching rows returned from inner/second table (TableB)would be in the order of COL1,COL2,COL3,COL4(again 99% cluster ratio). In effect we have a result set which is already in the desired order. Does this still need to be sorted. [...]
14953 237 42_Re: List prefetch with high cluster ratios14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Sat, 11 Aug 2001 04:06:51 -0500658_us-ascii FYI -- LEAFDIST greater than 200 means index reorg only applies when FREEPAGE <> 0. When FREEPAGE in index is 0, you cannot use 200 -- another old myth!!!
Richard Yevich YL&A - http://www.YLAssoc.com DB2 and Sysplex Gold Consultant Certified DB2 DBA for OS/390, z/OS Richard_Yevich@YLAssoc.com
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Mohammed Nayeem > Sent: Friday, August 10, 2001 4:35 PM > To: DB2-L@RYCI.COM > Subject: Re: List prefetch with high cluster ratios > > > Hari, > LEAFDIST might have grown , if LEAFDIST is grater than 200 > [...]
15191 143 49_Re: How can you tell space available on a volume?12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 11 Aug 2001 13:36:45 +0200558_windows-1255 Hi, I once got an assembler routine that you may cal from REXX with the disk name (or *) and get a nice report about the space on it. You'll have to compile it. As it's more then 250 lines - I can't add it to the mail. Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net ----- Original Message ----- From: Carlton Enuda Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Friday, August 10, 2001 3:28 AM Subject: How can you tell space available on a volume? [...]
15335 90 30_Re: Load problem - please help13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Sat, 11 Aug 2001 06:16:15 -0700327_us-ascii Bheemsen,
Usually this happens when the input record is shorter than the load control file specifies. Your last field in the load control file is a timestamp external which needs 26 bytes. It starts at byte 125. If the record length of your load file is less than 150 then that would explain your problem. [...]
15426 29 37_Re: term utility issue with scheduler12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Sat, 11 Aug 2001 10:48:00 -0400457_- We have people call operations where the operator can terminate the specific utility from the console. You will have to give the operators explicit instructions not to term Util(*), speaking from experience. See Command ref for authorizations necessary. DBMaint and above on the database will give auth to term a utility but only if the utility has started execution ie not in the INIT phase (it worked that way in V4.1, it may have changed by now). [...]
15456 78 54_Re: Why DB2 is not using index with matching columns 113_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sat, 11 Aug 2001 13:27:36 -0500486_us-ascii Ujjal/Sibi,
I am not aware of this feature being available in V6. However, in Akira Shibamiya's IDUG presentation he explained how this feature is available in V7. The comparison is indexable only one way though, but in this example tab1 is accessed first so this can be indexable in V7.
It is not possible currently because the column expression must be evaluated by stage 2. Unfortunately there is no predicate transitive closure with a column expression. [...]
15535 188 42_Re: List prefetch with high cluster ratios13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sat, 11 Aug 2001 14:24:31 -0500471_iso-8859-1 Harish,
I would assume List Prefetch is being chosen because each inner table access retrieves more than one page, but less than what would be beneficial for sequential prefetch. This is regardless of the fact that the entire query may return 90% of the total table rows. We are only talking about each inner table probe, which will occur as many times as there are qualifying rows in tablea. So the list prefetch limits are not really applicable. [...]
15724 96 54_Re: Why DB2 is not using index with matching columns 115_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Sat, 11 Aug 2001 18:57:31 -0400270_- Thanks to both of you. We are using V6.1 on os/390 2.9. 123 was just an example. The a.col1 is coming from another two table join. So it cannot be host variable. I just made this query to understand easily. I am glad that at least this is available in Version 7. [...]
15821 53 49_Re: How can you tell space available on a volume?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Sat, 11 Aug 2001 22:41:26 -0400
15875 19 33_Kevin Davis is out of the office.11_Kevin Davis18_kevin.davis@DB.COM31_Sun, 12 Aug 2001 03:44:50 -0600139_us-ascii I will be out of the office from 08/06/2001 until 08/13/2001.
I will respond to your message when I return.
15895 57 37_CLI vs dynamic SQL - which is faster?13_Tzachi Nissim21_tzachi@ATTUNITY.CO.IL31_Sun, 12 Aug 2001 14:11:28 +0200294_iso-8859-1 Hi listers,
We have a dynamic SQL application out there and are contemplating moving to use CLI. I would appreciate any input from the group regarding the expected performance implications of this move. Simply put - is dynamic SQL faster or slower than CLI?
TIA, Tzachi
15953 92 15_Re: DB2 Connect13_Greg Farquhar25_Greg_Farquhar@BIGFOOT.COM31_Sun, 12 Aug 2001 23:15:17 +1000458_iso-8859-1 Gerry,
I am perplexed by your claim that SQLJ is dynamic under the covers.
Greg Farquhar
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of McHugh, Gerry Sent: Saturday, August 11, 2001 5:59 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect
If you're using Java everything is dynamic SQL. Even SQLJ is dynamic (surprise) under the covers at this point in time. [...]
16046 73 50_Re: DB2 V6 and os390 V2R10 (TCP/IP or OMVS issues)0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Sun, 12 Aug 2001 08:41:20 -0500342_us-ascii We are on V6 and upgraded form OS/390 v2r8 to V2r10 back in March and it was very smooth.. No problems.
We are positioning ourselves for z/OS upgrade. Would be curious if anyone has experienced any problems with that upgrade?
Shan Leatherman
Standard disclaimer: All thoughts are mine and not of my company [...]
16120 40 23_Re: Long Decimal Column14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 12 Aug 2001 08:56:59 -0500620_- The latest versions of the V5 and V6 manuals contain the same words. Not sure which ptf(s) added the capability.
James Campbell
On Fri, 10 Aug 2001 09:51:49 -0500, McKown, John wrote:
>I just rummaged around in the V7 version of the manual which says: > >DECIMAL(p,s) S9(p-s)V9(s) COMP-3 p is precision, s is scale. >0<=s<=p<=31. If s=0 then > use S9(p)V or S9 (p). >If s=p, then use SV9(p). If the > COBOL compiler does >not support 31-digit decimal > numbers, there is no >exact equivalent. Use COMP-2. > >However, with version 2.2 of COBOL for OS/390 ..., [...]
16161 16 57_Steve Westfall/KnowledgeEng/Equifax is out of the office.0_26_Steve.Westfall@EQUIFAX.COM31_Mon, 13 Aug 2001 01:01:17 -0500366_us-ascii I will be out of the office starting 08/11/2001 and will not return until 08/20/2001.
Steve Westfall
================================================ 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.
16178 15 49_Peter Faller/HRD/Prudential is out of the office.12_Peter Faller27_peter.faller@PRUDENTIAL.COM31_Mon, 13 Aug 2001 02:07:46 -0400438_us-ascii I will be out of the office from 08/11/2001 until 08/20/2001.
If you need something during my absents please contact John O'Shea. Else 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.
16194 15 51_Vivek V Yeldandi/vyelda1/DFSI is out of the office.14_Vivek Yeldandi35_vivekyeldandi@DISCOVERFINANCIAL.COM31_Mon, 13 Aug 2001 01:06:35 -0500389_us-ascii I will be out of the office starting 08/10/2001 and will not return until 08/20/2001.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16210 64 15_Re: DB2 Connect15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Mon, 13 Aug 2001 09:05:51 +0200328_iso-8859-1 Gerry,
We are using a java application on a NT-server using JDBC / DB2 Connect EE and Stored procedures on the OS/390 DB2 v6. Maybe you're right about the call being done dynamic to the stored procedure. However the stored procedure consists of static SQL which is reguraly binded onto the DB2 on OS/390. [...]
16275 26 23_Re: DB2 JDBC 2.0 driver17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Mon, 13 Aug 2001 09:25:26 +0100594_us-ascii Tnx to everybody ! :-)
Massimo Biancucci Technical Engineering Mainframe Technical Support-database T-Systems Italia debis IT Services Italia S.p.A. Via degli Ontani, 25 36100 - Vicenza (VI) Phone: +39 0444558110 Fax: +39 0444558232 Mobile: +39 3482558906 e-mail: Massimo.Biancucci@t-systems.it Internet: http://www.t-systems.it
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16302 150 25_Re: CARDF in SYSTABLEPART16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 13 Aug 2001 13:21:37 +0530601_- Hend,
I do not think so i.e. it might not be affecting the system performance. But still this needs to be confirmed from some IBM experts.
Regards Sanjeev
> -----Original Message----- > From: Hend Dwiyono [SMTP:hdwi@HOTMAIL.COM] > Sent: Friday, August 10, 2001 11:18 PM > To: DB2-L@RYCI.COM > Subject: Re: CARDF in SYSTABLEPART > > Thank you for all the responses. > Sanjeev, maybe I should clarify that when we still ran IBM RUNSTATS, it > uses update ALL on catalog tables and only after we switched to use BMC > COPY PLUS with RUNSTAT option, CARDF stops being updated. [...]
16453 34 41_DB2 for OS/390 V5 & V6 Code Page Question12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 13 Aug 2001 10:19:26 +0200362_iso-8859-1 Hello friends,
one of our DB2 subsystems is running with code page 273 and the DBA wants to change the code page to 1141.
Short question (because I do not have the documentation available right now): What is the meaning of code page 273 and what is 1141 ?
Thanks in advance for any information you are willing to pass along. [...]
16488 69 45_AW: DB2 for OS/390 V5 & V6 Code Page Question12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Mon, 13 Aug 2001 10:33:23 +0200660_iso-8859-1 Hi Georg,
as far as I know: 273 is a CCSID without EURO symbol. It can be converted to 1141 (with EURO symbol)
HTH and best regards
Thomas
________________________________________ Thomas Weber LDS NRW Postfach 10 11 05 40002 Duesseldorf Tel.: +49 - 0211 - 9449 - 2545 e-mail: thomas.weber@lds.nrw.de
> -----Ursprüngliche Nachricht----- > Von: Peter, Georg [mailto:G.Peter@DZBW.DE] > Gesendet am: Montag, 13. August 2001 10:19 > An: DB2-L@RYCI.COM > Betreff: DB2 for OS/390 V5 & V6 Code Page Question > > Hello friends, > > one of our DB2 subsystems is running with code page 273 and > the DBA [...]
16558 120 34_SQLprocedure creation not possible9_john king24_john_king@REDIFFMAIL.COM31_Mon, 13 Aug 2001 09:01:59 -0000458_- HI All I got this error while creating a sqlprocedure through soufi. I m with version 6 and I tried for more than six hours to find out the error but could not solve it. evry time it is throwing and syntax error called -104. I chewcked most of the manuals and every manuals are same and I m getting the same error. Even though I typed again also in spufi also it gives me the same error. Could any body help me this out. I m giving the details below. [...]
16679 124 38_Re: SQLprocedure creation not possible14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Mon, 13 Aug 2001 19:16:26 +1000372_iso-8859-1 Hi John,
If you check the archives you'll find the detail - it's been discussed a couple of times in recent weeks, but in essence I believe you need to change your SQL delimiter in SPUFI to something beside ';' as that is the delimiter within the procedure declaration.
Cheers,
Greg Palgrave Database Administrator Unisys West [...]
16804 27 11_LOB problem12_Hamid Alvani22_alvani@DPI2.DPI.NET.IR31_Mon, 13 Aug 2001 13:49:32 +0330520_US-ASCII Hello listener; I have a problem with DB2 Version 6.1.0.IVP Sample job(DSNTEJ71) in step PH071S04 end with this message:
CEE3250C The system or user abend S04E R=00C90101 was issued. From entry point buildPSEGcol at compile unit offset +000006BE at address 15725246.
Source program is DSN8DLPL in DSN610.SDSNSAMP and pre-compile, compile,pre-link,link,bind performed by cc=00,but run is ended by cc=08 . Has anyone seen anythings like this before?any idea would be appreciated. THANKS; Hamid [...]
16832 131 38_Re: SQLprocedure creation not possible16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Mon, 13 Aug 2001 10:34:22 +0100456_us-ascii John,
this is due to the SQL delimiter in SPUFI being ";"
It should work fine if you change the SPUFI SQL delimiter to some other sign - refer to the manuals for help, or to a recent discussion on this list.
HTH.
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.
Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com [...]
16964 46 18_Antw: Online Reorg19_Martin Eichenberger30_Martin.Eichenberger@HELSANA.CH31_Mon, 13 Aug 2001 11:30:35 +0200488_US-ASCII Hi Claudio, hope this helps. http://www-4.ibm.com/software/data/db2/os390/pdf/oreorg.pdf
Regards,
Martin Eichenberger BOB Informatik AG Suisse
>>> p000002@BEG.COM.BR 10.08.2001 15.54 Uhr >>> Hello,
I'm looking for a good article on DB2 Online Reorg (DB2 OS/390 V5). I came across a good one some years ago, but I cannot remember if it was an IBM redbook or where I found it. I've searched the IBM site but I couldn't find anything really useful. [...]
17011 35 55_To connect to OS390 DB2 6.0 from NT or Unix application8_Madhavan17_Madhavan@INFY.COM31_Mon, 13 Aug 2001 15:14:50 +0530352_iso-8859-1 Hi,
Can you pls clarify the following?
1. If we need to directly talk to db2 6.0 in OS/390 from servlets/java application running in Unix box, a. do we need a jdbc driver to be installed in the Unix box? b. What would be the cost? Are there any free drivers available? c. Do we need to buy/install anything more in os390? [...]
17047 202 60_2nd Notice--Bonnie Baker at SIRDUG (Charlotte, NC) 8/23-8/2411_Paul Turpin32_pault@ALUMMAIL.SSB.ROCHESTER.EDU31_Mon, 13 Aug 2001 05:21:00 -0500653_- SIRDUG Southeastern Inter-Relational Database Users' Group P.O. BOX 34641 Charlotte, NC 28234
Website: http://users.vnet.net/sirdug Email: SIRDUG@VNET.NET Information/Message Line: (704) 556-6621
Educational Seminar Announcement ================================================================ WHEN? Thursday, August 23th & Friday, August 24th
WHERE? IBM Harris Blvd facility (Charlotte, NC) See directions below
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) [...]
17250 50 76_How To call a COBOL Programe From JCL which in turn Calls a Stored Procedure10_praveen_kj19_praveen_kj@INFY.COM31_Mon, 13 Aug 2001 17:15:00 +0530596_iso-8859-1 Hi all,
I am calling a COBOL Programe From JCL which in turn Calls a Stored Procedure.
JCL is as follows. I am calling a test programe whose load lib is 'OPERN.CICS3.LOADLIB'. This programme is calling a stored Procedure which is associated with Plan SMLSP.
//TR8279J JOB ,,NOTIFY=&SYSUID,CLASS=D,MSGLEVEL=(1,1),MSGCLASS=X //GO EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * PROFILE PREFIX(TR8279) DSN SYSTEM(DSNG) RETRY(0) TEST(0) RUN PROGRAM(TEST) PLAN(SMLSP) - LIB('OPERN.CICS3.LOADLIB') END /* //SYSIN DD * 111 PRAVEEN 222 /* [...]
17301 67 81_AW: How To call a COBOL Programe From JCL which in turn Calls a S tored Procedure12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 13 Aug 2001 14:03:12 +0200511_iso-8859-1 Praveen,
>> SQLCODE -430 (SQLSTATE 38503): error encountered within a user-defined function or stored procedure.. <<<<
With kind regards - mit freundlichen Grüssen, Georg(e) H. Peter ---------------------------------------------------------------------- -----Ursprüngliche Nachricht----- Von: praveen_kj [mailto:praveen_kj@INFY.COM] Gesendet am: Montag, 13. August 2001 13:45 An: DB2-L@RYCI.COM Betreff: How To call a COBOL Programe From JCL which in turn Calls a Stored Procedure [...]
17369 69 81_Re: How To call a COBOL Programe From JCL which in turn Calls a S tored Procedure18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Mon, 13 Aug 2001 18:17:25 +0500561_- I think stored procedures use CAF/RRSAF as the language interface module. So can you run a COBOL program with TSO attach facility to call a stored procedure which uses CAF/RRSAF?
> -----Original Message----- > From: praveen_kj [SMTP:praveen_kj@INFY.COM] > Sent: Monday, August 13, 2001 5:15 PM > To: DB2-L@RYCI.COM > Subject: How To call a COBOL Programe From JCL which in turn Calls a > Stored Procedure > > Hi all, > > I am calling a COBOL Programe From JCL which in turn Calls a Stored > Procedure. > > JCL is as follows. > I am calling a test [...]
17439 22 12_-805 vs -81810_Chris Kern23_Chris_Kern@VANGUARD.COM31_Mon, 13 Aug 2001 09:36:52 -0400530_us-ascii Listers, I have a questions about -805 vs -818. I have an understanding of what both of these error codes are and what they mean. My question is this: Under which circumstance do you receive one over the other? I remember with V4 (OS390), receiving a -818 was common. With V5 the -818 mismatch error seemed to be all but replaced by the con token not found -805, however in V6 I do see the -818 from time to time. This suprises me somewhat because I would expect to get a -805 (which I do most of the time), however [...]
17462 68 16_Re: -805 vs -8180_20_John_Lendman@FPL.COM31_Mon, 13 Aug 2001 09:53:17 -0400441_us-ascii At our shop the different is if we are using packages or not. We get the -818 for plans that are not using packages, and we get the -805 with plans that use packages. Most of the time.
John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413
"Chris Kern" cc: Sent by: "DB2 Subject: -805 vs -818 Data Base Discussion List" [...]
17531 21 70_Re: Upgrade Issues going from DB2/UDB 5.2 (AIX) to DB2/UDB 7.1 (AIX) ?11_Mike Fatula17_mfatula@PHEAA.ORG31_Mon, 13 Aug 2001 09:56:36 -0400517_us-ascii Hi:
Two issues I remember are:
1. The client has some issues communicating with different release. I believe lower releases can communicate with higher releases 5.2 to 7.1
2. The Using parameter on the load utility has changed to tempfiles path.
================================================ 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.
17553 55 18_Re: UNLOAD UTILITY11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Mon, 13 Aug 2001 08:57:34 -0500508_iso-8859-1 I assume Platinum has an option similar to BMC (which we use) that allows unload to use direct access to the VSAM file, rather than going through DB2. This works for simple SQL in the unload -- no functions, joins, etc. Are you using this method? If not, then you're probably blowing out the buffer pools. Maybe that, combined with I/O contention is causing or at least contributing to the online performance problem. Although 10 minutes sounds awfully bad. Have you looked at your monitors? [...]
17609 48 16_Re: -805 vs -81826_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Mon, 13 Aug 2001 07:00:49 -0700314_iso-8859-1 My understanding of the difference is that for the -805 the package or DBRM is NOT FOUND and for the -818 it is found but there is a timestamp mismatch. Two completely different causes! I can't imagine a situation where they could be substituted for one another.
Bill Johnson Russell Mellon [...]
17658 39 88_What is the easiest way to convert a SMS database to a DMS database on the UNIX platform18_Richard Mccutcheon32_Richard_McCutcheon@HCM.HONDA.COM31_Mon, 13 Aug 2001 10:01:41 -0400587_us-ascii Good Day Listers.
My question for the day is, 'What is the easiest way to convert a SMS database to a DMS database on the UNIX platform ?'
I currently have a DB2/UDB v7.2 database on AIX. This database was created as an SMS database, and now I unfortunately have to change the database to a DMS database. We have no DMS databases in our shop as we have always chosen SMS for its simplicity in Administrating. I have been informed that PeopleSoft, in its infinite wisdom, has chosen not to support SMS database configuration for PeopleTools 8.x . This [...]
17698 119 16_Re: -805 vs -81812_Troy Coleman19_Colematr@MEIJER.COM31_Mon, 13 Aug 2001 10:07:55 -0400447_US-ASCII You will receive -818 when you have a plan with only DBRMs. You do not have packages involved. With packages you will receive -805.
Cheers,
Troy Coleman Coleman Consulting, Inc.
IBM Certified Solutions Expert DB2 V7.1 Database Administration for OS/390 DB2 UDB V5 Database Administration IBM Certified Advanced Technical Expert DB2 -DRDA
Voice: (847) 722-2698 Email: troycci@colemanconsulting.com [...]
17818 89 18_Re: UNLOAD UTILITY10_CEI, Bruno20_Bruno.CEI@SEMA.CO.UK31_Mon, 13 Aug 2001 15:12:50 +0100682_iso-8859-1 Harry,
What SHRLEVEL are you using ? If it is REFERENCE you will certainly have some contention on the tables being unloaded.
Bruno
-----Original Message----- From: Tina Hilton [mailto:Tina.Hilton@BMSUS.COM] Sent: 13 August 2001 14:58 To: DB2-L@RYCI.COM Subject: Re: UNLOAD UTILITY
I assume Platinum has an option similar to BMC (which we use) that allows unload to use direct access to the VSAM file, rather than going through DB2. This works for simple SQL in the unload -- no functions, joins, etc. Are you using this method? If not, then you're probably blowing out the buffer pools. Maybe that, combined with [...]
17908 84 16_Re: -805 vs -81822_Vadavalli, Sirish B23026_Sirish.Vadavalli@CIGNA.COM31_Mon, 13 Aug 2001 10:17:42 -0400299_us-ascii -805 by defenition is PROGRAM NAME NOT FOUND IN PLAN.this could happen due to the older version of the program being accessed by the plan.we had a situation resembling this. as the corect program was not being picked up by the plan correctly it results in the -805 for all executions. [...]
17993 53 59_Re: To connect to OS390 DB2 6.0 from NT or Unix application15_Neff, Stephen R16_NeffSR@STATE.GOV31_Mon, 13 Aug 2001 10:18:51 -0400350_iso-8859-1 hello, I can't answer all you questions. However I did just connect to an OS/390 from a Win Nt box. The connection is a TCP/IP connection and I used DB2 Connect personnel edition 7.1 which was free. There was set up on the mainframe some things were had to use port 446 also needed was an IP address and ddf running. Hope this helps. [...]
18047 18 32_DB2PLI8 - where to find for V 6?20_Bustamente, Gerald G30_Gerald.Bustamente@LANDSEND.COM31_Mon, 13 Aug 2001 09:23:13 -0500313_iso-8859-1 Anyone know?
Thanks,
Jerry Bustamente Lands' End
===============================================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.
18066 18 16_Re: -805 vs -81813_Thomas Schulz20_thomas.schulz@SVI.DE31_Mon, 13 Aug 2001 09:31:12 -0500376_- Hi
-805 has a few sub codes, Subcode 03 says - similar to Sqlcode -818 - Package not bound - Version is invalid
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 DB2-L-REQUEST@RYCI.COM.
18085 29 0_10_Andy Stein22_jbak2009@AMERITECH.NET31_Sun, 12 Aug 2001 10:14:03 -0500379_us-ascii My name is Andy Stein; I am a consultant in executive search. My client develops enterprise-wide tools and utilities to support large enterprise wide IT operations. Many of the OS390 based products are sold through IBM.
My client has recently formed a new division, the Services Group to provide consulting and implementation services around their products. [...]
18115 134 54_Re: Why DB2 is not using index with matching columns 113_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 13 Aug 2001 10:01:19 -0500406_iso-8859-1 Sibi,
You can also achieve index matching access with this predicate before V7 if you first materialize the result, before the subsequent join to tablea. You must ensure however that the distinct does not remove required duplicates.
select b.col2 from (select distinct substr(char(col1),1,9) as sub_col1 from tab1 where col1 = ?) as a inner join tab2 b on b.col1 = a.sub_col1 [...]
18250 22 53_Can I copy a database to a different platform easily?14_Michele Payton18_paytonm@US.IBM.COM31_Mon, 13 Aug 2001 09:20:35 -0600402_us-ascii Hello listers,
I am fairly new to this and am wondering if I can take a DB2 UDB v7.2 database on an AIX 4.3 system and somehow restore to a new database on a Windows 2000 box for testing purposes. Does anyone know if this is possible and if so, how exactly do I do it. When I try to restore from the Control Center to a new local database on my Windows box I get an error. Thanks. [...]
18273 73 18_Re: UNLOAD UTILITY13_Villa Horacio17_hvilla@TTI.COM.AR31_Mon, 13 Aug 2001 12:19:22 -0300629_iso-8859-1 Are you running SHRLEVEL CHANGE or REFERENCE? What are your dispatching priorities set? Horacio Villa TTI S.A. Buenos Aires - Argentina
-----Mensaje original----- De: DB2 Data Base Discussion List En nombre de Tina Hilton Enviado el: Lunes 13 de Agosto de 2001 10:58 Para: DB2-L@RYCI.COM Asunto: Re: UNLOAD UTILITY
I assume Platinum has an option similar to BMC (which we use) that allows unload to use direct access to the VSAM file, rather than going through DB2. This works for simple SQL in the unload -- no functions, joins, etc. Are you using this method? If not, then you're probably [...]
18347 35 16_Re: -805 vs -81813_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 13 Aug 2001 11:29:24 -0400372_iso-8859-1 Hi Bill, Chris, Others have correctly observed that you only get -818 if you are not using packages; -805 for packages.
The reason is that packages provide support for multiple versions while plans bound directly from DBRMs allow for only one version.
So you could get either SQLcode for the same basic problem depending on your environment. [...]
18383 40 57_Re: Can I copy a database to a different platform easily?11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Mon, 13 Aug 2001 10:32:06 -0500606_iso-8859-1 db2move may be the utility to use. I haven't used it from AIX to Windows 2000 but it should work !
HTH Amit
-----Original Message----- From: Michele Payton [mailto:paytonm@US.IBM.COM] Sent: Monday, August 13, 2001 10:21 AM To: DB2-L@RYCI.COM Subject: Can I copy a database to a different platform easily?
Hello listers,
I am fairly new to this and am wondering if I can take a DB2 UDB v7.2 database on an AIX 4.3 system and somehow restore to a new database on a Windows 2000 box for testing purposes. Does anyone know if this is possible and if so, how [...]
18424 153 54_Re: Why DB2 is not using index with matching columns 115_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 13 Aug 2001 11:32:21 -0400443_iso-8859-1 Terry,
I agree with you. The problem is DBA know about it, but many programmers do not know about this and coding the way I sent because it is easy and more logical in normal view.
Thanks..sibi
-----Original Message----- From: Terry Purcell [mailto:Terry_Purcell@YLASSOC.COM] Sent: Monday, August 13, 2001 10:01 AM To: DB2-L@RYCI.COM Subject: Re: Why DB2 is not using index with matching columns 1 [...]
18578 26 42_Re: List prefetch with high cluster ratios8_Harish G24_hari_gangadhar@YAHOO.COM31_Mon, 13 Aug 2001 10:32:41 -0500548_- Hi Terry,
I ran a RUNSTATS again, but now with the KEYCARD option. Lo ! Behold ! The prefetch turns to sequential now, with nested loop join (the sequence of tables in the join remain the same. The prefetch is sequential again when I use the FREQVAL option). I wonder what was going on earlier to make DB2 choose list prefetch when I had just specified INDEX(ALL) in my RUNSTATS. But even with all these, DB2 goes for the third sort step. I wonder why it should do that, especially since the indexes give the needed order. By the by, [...]
18605 72 92_Re: What is the easiest way to convert a SMS database to a DMS database on the UNIX platform17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Mon, 13 Aug 2001 10:41:04 -0500445_us-ascii Table spaces cannot be changed that way. You will have to create your DMS tablespaces and then I would use db2look then db2move to recreate your tables in the proper tablespaces.
From: 'Richard Mccutcheon' @RYCI.COM on 08/13/2001 09:01 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
18678 47 57_Re: Can I copy a database to a different platform easily?17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Mon, 13 Aug 2001 10:46:22 -0500408_us-ascii Try using Db2look and then db2move. you will have to ftp the files to your 2000 box. If the tables are small you might try simply exporting and importing your tables, but you won't get the indexes,l triggers, views or stats.
From: Michele Payton @RYCI.COM on 08/13/2001 10:20 AM
Please respond to DB2 Data Base Discussion List [...]
18726 20 26_Access path change with v69_Chris Tee23_chris.tee@UK.ZURICH.COM31_Mon, 13 Aug 2001 16:45:28 +0100343_us-ascii Hi all,
Has anybody had problems with access path changes when rebinding after migrating from v5 to v6? We have a 6-way (all inner) join where one of the nested loop joins gets changed to a hybrid join and it's causing work file shortage problems. I haven't been able to find any APARs that seem to be related. Any ideas? [...]
18747 27 30_Re: Access path change with v615_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA31_Mon, 13 Aug 2001 18:21:36 +0200393_us-ascii I had a similar problem - after a reorg, runstats and rebind a 7-table join, with 1 table used twice, had some crazy accesses for the table joined to itself. put in a 0=1 to force it awway from the IX it wanted, and we were back to decent performance ( batch job version 5 access path = 9 min's exec time, with new access path, timed out after 2h30. After fix, time = +-8 mins). [...]
18775 28 32_DB2 UDB job position--Boston, MA13_Hopkins, John20_JMHopkins@KFORCE.COM31_Mon, 13 Aug 2001 13:08:23 -0400369_- I am recruiting for a DB2-UDB expert database administrator - with UNIX AIX and Linux Administration capabilities.
Programming experience with C, C++ and Java would be a plus.
MUST BE ABLE TO understand and contribute to the design of an object restore utility for the UBD DB2 Linux/AIX platforms and oversee the actual implementation of the tool. [...]
18804 106 30_Re: Load problem - please help23_AITHA, BHEEMSEN (SBCSI)14_ba2984@SBC.COM31_Mon, 13 Aug 2001 10:19:21 -0700632_ISO-8859-1 Thanx Tink. My load file is 150 bytes in length. Still it is a mystery to me why the load did not work.
-Bheem
-----Original Message----- From: BL.Tink Tysor [mailto:tink@BLTYSOR.COM] Sent: Saturday, August 11, 2001 6:16 AM To: DB2-L@RYCI.COM Subject: Re: Load problem - please help
Bheemsen,
Usually this happens when the input record is shorter than the load control file specifies. Your last field in the load control file is a timestamp external which needs 26 bytes. It starts at byte 125. If the record length of your load file is less than 150 then that would explain your [...]
18911 33 37_NEW JOB: DB2 UDB position--Boston, MA13_Hopkins, John20_JMHopkins@KFORCE.COM31_Mon, 13 Aug 2001 13:31:28 -0400372_- I have a second need for DB2 UDB DBA candidate located in Boston, the last position posted was in Quincy, MA. This is a new DB2 UDB position that I am recruiting for.
I am recruiting for a DB2-UDB expert database administrator - with UNIX AIX and Linux Administration capabilities.
Programming experience with C, C++ and Java would be a plus. [...]
18945 23 62_Error starting DDF with TCPIP on OS/390 - REASON CODE=12BA00C415_Armando Arranja27_Armando_Arranja@BANCOBPI.PT31_Mon, 13 Aug 2001 18:35:31 +0100572_iso-8859-1 Any ideas about this error message?
Where can I find the explanation of that reason code? I followed the manual and its links and I didn't find anything about it...
DSNL515I -DBL1 DSNLIRSY TCP/IP BIND FAILED FOR PORT 5020 WITH RETURN CODE=1115 AND REASON CODE=12BA00C4
OS/390 DB2 v5
================================================ 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.
18969 123 30_Re: Load problem - please help11_Robert Jans26_robert_jans@ALBERTSONS.COM31_Mon, 13 Aug 2001 10:35:48 -0700417_iso-8859-1 Did I add wrong? The field starts in pos 125 for a length of 26 makes 151, yes?
-----Original Message----- From: AITHA, BHEEMSEN (SBCSI) [mailto:ba2984@SBC.COM] Sent: Monday, August 13, 2001 11:19 AM To: DB2-L@RYCI.COM Subject: Re: Load problem - please help
Thanx Tink. My load file is 150 bytes in length. Still it is a mystery to me why the load did not work. [...]
19093 137 30_Re: Load problem - please help26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Mon, 13 Aug 2001 10:44:49 -0700502_iso-8859-1 150
-----Original Message----- From: Robert Jans [mailto:robert_jans@ALBERTSONS.COM] Sent: Monday, August 13, 2001 1:36 PM To: DB2-L@RYCI.COM Subject: Re: Load problem - please help
Did I add wrong? The field starts in pos 125 for a length of 26 makes 151, yes?
-----Original Message----- From: AITHA, BHEEMSEN (SBCSI) [mailto:ba2984@SBC.COM] Sent: Monday, August 13, 2001 11:19 AM To: DB2-L@RYCI.COM Subject: Re: Load problem - please help [...]
19231 39 66_Re: Error starting DDF with TCPIP on OS/390 - REASON CODE=12BA00C411_Jeff Schade21_JSCHADE@MAIL2.PCH.COM31_Mon, 13 Aug 2001 13:45:15 -0400402_US-ASCII I also cannot find the reason code but the TCP/IP REASON CODE=1115 indicates that the address is already in use.
Hope this helps.
Jeff Schade
>>> Armando_Arranja@BANCOBPI.PT 08/13/01 01:35PM >>> Any ideas about this error message?
Where can I find the explanation of that reason code? I followed the manual and its links and I didn't find anything about it... [...]
19271 150 30_Re: Load problem - please help12_McKown, John22_JMckown@HEALTHAXIS.COM31_Mon, 13 Aug 2001 12:47:43 -0500678_iso-8859-1 You added wrong. End col=Start col+length-1. So start col of 125 for 26 ends in column 150.
---------------------------------------------------------------------- John McKown HealthAxis
All opinions are my own and are not the opinions of my employer.
Unsolicited telephone calls from vendors are NOT appreciated and tend to upset my management.
> -----Original Message----- > From: Robert Jans [SMTP:robert_jans@ALBERTSONS.COM] > Sent: Monday, August 13, 2001 12:36 PM > To: DB2-L@RYCI.COM > Subject: Re: Load problem - please help > > Did I add wrong? The field starts in pos 125 for a length of 26 makes 151, > yes? > > > > [...]
19422 42 66_Re: Error starting DDF with TCPIP on OS/390 - REASON CODE=12BA00C419_José Ignacio Ossuna16_jiossuna@ATCA.ES31_Mon, 13 Aug 2001 20:22:55 +0200444_us-ascii Armando,
The REASON CODE tells during a Socket Bind request, a Reserved Port was incorrectly especified.
Change the port requested in the Socket Bind request to a non-reserved port. The reserved ports are found in the NETWORK parmlib statement in the BPXPRMxx member
Hope this helps.
Nacho Ossuna.
>>> Armando_Arranja@BANCOBPI.PT 08/13/01 01:35PM >>> Any ideas about this error message? [...]
19465 62 66_Re: Error starting DDF with TCPIP on OS/390 - REASON CODE=12BA00C411_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Mon, 13 Aug 2001 12:53:40 -0500599_us-ascii rc The return code reported by TCP/IP. The return code values are documented in OS/390 UNIX System Services Programming: Assembler Callable Services Reference.
reason The reason code reported by TCP/IP. The reason code values are documented in OS/390 UNIX System Services Programming: Assembler Callable Services Reference.
Good Luck!... : )
Armando Arranja cc: Sent by: DB2 Data Subject: Error starting DDF with TCPIP on Base Discussion OS/390 - REASON CODE=12BA00C4 List [...]
19528 16 34_How to indicate delete intention ?13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Mon, 13 Aug 2001 15:03:43 -0500307_- Hi I'm reading some data using a cursor and deleting some of the rows using 'WHERE CURRENT OF cursor". There are no UPDATE's being done. How do I tell DB2 that this cursor is not a read only cursor ? Using "FOR UPDATE OF " or "FOR UPDATE OF " or ... Thanks Mohammad [...]
19545 46 38_Re: How to indicate delete intention ?22_Vadavalli, Sirish B23026_Sirish.Vadavalli@CIGNA.COM31_Mon, 13 Aug 2001 16:34:59 -0400624_us-ascii I do not think we need to specify that FOR UPDATE OF. clause .. here Whatever rows will be selected by the predicate of your declare cursor will get deleted by your delete cursor. During delete OPERATION, the cursor-name ties all the SQL STATEMENTS TOGeTHER.
Hope this would help....
Sirish Vadavalli
> -----Original Message----- > From: Mohammad Khan [SMTP:mkkhan88@HOTMAIL.COM] > Sent: Monday, August 13, 2001 4:04 PM > To: DB2-L@RYCI.COM > Subject: How to indicate delete intention ? > > Hi > I'm reading some data using a cursor and deleting some of the rows > using 'WHERE CURRENT OF [...]
19592 18 29_Directory & Catalog Passwords14_Riedel, Marcia26_MRiedel@TUCSONELECTRIC.COM31_Mon, 13 Aug 2001 13:42:37 -0700467_- Hello.
Does anyone out there have experience in removing passwords from the DB2 for OS/390 directory and catalog? Is there any way to identify if they exist (before running the V6 CATMAINT job)?
Thanks, Marcia
================================================ 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.
19611 19 33_Peoplesoft SQR hangs using DB2 V612_Mehdi Fakhar26_mehdifakhar@WINN-DIXIE.COM31_Mon, 13 Aug 2001 15:53:02 -0500304_- PSoft HR Version 7.53 DB2 MVS Version 6.0
We just upgraded to DB2 MVS V 6.0 and when a specific HR job coded in SQR using plan of DBCALLS runs, it just hangs in DB2 with no activity (getpages). TMON shows a high number of Parallel Groups executed (432K). The plan is bound with Degree (1). [...]
19631 43 30_Re: Access path change with v624_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Mon, 13 Aug 2001 16:08:13 -0500284_- I caused some self-inflicted pain on one of our DB2 subsystems when I migrated to V6. In zparms (part of the DB2 install process), I had set STARJOIN=ENABLE (bad idea) which caused joins to be much slower and required a lot more work file space. Note: STARJOIN is new with V6. [...]
19675 25 38_Re: How to indicate delete intention ?13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Mon, 13 Aug 2001 16:17:52 -0500370_- Thank you Sirish Probably I didn't make myself clear enough. I know that leaving the cursor ambigous works fine. I'm only trying to find out if there is a way to remove the ambiguity and make my intention clear which might be helpful to the optimizer. Mohammad
On Mon, 13 Aug 2001 16:34:59 -0400, Vadavalli, Sirish B230 wrote: [...]
19701 151 30_Re: Load problem - please help13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Mon, 13 Aug 2001 14:45:53 -0700386_us-ascii Beheem,
Another thought. Have you actually looked at the load file with something like the ISPF browse? Is everything lined up like you expected, or is there some inserted character at the beginning? Is the DCB in the JCL correct in either the load or the unload.
I don't know if this helps but sometimes I think of the solution while doing stuff like that. [...]
19853 27 33_Re: Directory & Catalog Passwords12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 13 Aug 2001 17:01:00 -0400452_- There is a very important job to run before V6.1 upgrade... DSNTIJPM. It is in your SDSNSAMP. It will identify the PWs, among other things, as well as build the commands to remove the PWs.
>>> DB2-L@RYCI.COM@inter2 08/13/01 03:43PM >>> Hello.
Does anyone out there have experience in removing passwords from the DB2 for OS/390 directory and catalog? Is there any way to identify if they exist (before running the V6 CATMAINT job)? [...]
19881 172 30_Re: Load problem - please help23_AITHA, BHEEMSEN (SBCSI)14_ba2984@SBC.COM31_Mon, 13 Aug 2001 15:58:58 -0700381_ISO-8859-1 Tink,
Yes, The file is fine. I viewed it in ISPF. The load worked when the file was copied to another flat file of same LRECL(150 bytes). The original file is a version of a GDG base. The load also worked when I had increased the LRECL to 151 for the GDG. Is it something to do with the GDG ? Still it is a mystery to me. Did any one come across like this ? [...]
20054 59 33_Re: Directory & Catalog Passwords14_Riedel, Marcia26_MRiedel@TUCSONELECTRIC.COM31_Mon, 13 Aug 2001 16:09:27 -0700374_- Bob:
Thanks, but I already ran that job. The passwords on the directory and catalog are not IN the catalog, are not queryable, do not show up in a LISTCAT, are not ALTERable and are embedded in the OBD. PTF UQ53228 has been applied, which is supposed to ignore them.
Thanks, Marcia Riedel Database Administration MRiedel@tucsonelectric.com 520-884-3925 [...]
20114 35 40_UPDATE - Catalog and Directory Passwords14_Riedel, Marcia26_MRiedel@TUCSONELECTRIC.COM31_Mon, 13 Aug 2001 16:18:35 -0700595_iso-8859-1 Hello again.
I posted the following a couple of hours ago and perhaps was not explicit enough.
"Does anyone out there have experience in removing passwords from the DB2 for OS/390 directory and catalog? Is there any way to identify if they exist (before running the V6 CATMAINT job)?"
The passwords I am referring to are ON the directory and catalog objects and are not IN the catalog, therefore are not queryable. So nothing shows up in the DSNTIJPM job. They do not show up in a LISTCAT. They are embedded in the OBD. When running the DSNTIJTC job, return [...]
20150 183 30_Re: Load problem - please help10_teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 14 Aug 2001 10:38:35 +1000611_us-ascii Any possibility that the GDG's record format (recfm) is defined with an 'A' attribute ?
Cheers, Kals
-----Original Message----- From: AITHA, BHEEMSEN (SBCSI) [SMTP:ba2984@SBC.COM] Sent: Tuesday, August 14, 2001 8:59 AM To: DB2-L@RYCI.COM Subject: Re: Load problem - please help
Tink,
Yes, The file is fine. I viewed it in ISPF. The load worked when the file was copied to another flat file of same LRECL(150 bytes). The original file is a version of a GDG base. The load also worked when I had increased the LRECL to 151 for the GDG. Is it something to do with the GDG [...]
20334 84 80_Re: How To call a COBOL Programe From JCL which in turn Calls a Stored Procedure10_teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 14 Aug 2001 13:45:00 +1000433_us-ascii Praveen,
Yes, u can run thru JCL a COBOL program which calls SPs. Ur JCL looks OK. The SQLcode indicates that there is some problem in the SP.
Make sure that the SP module is in the right dataset which is concatenated in the SP address space. Ensure that the module has been linked with DSNALI included. (of course if these r not correct then u will get different SQlcodes, but still check them up again) [...]
20419 77 42_Re: List prefetch with high cluster ratios16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 14 Aug 2001 09:23:57 +0530519_- Both the options of RUNSTAT are to be specified. Index all is the default. So the corelation statistics were required for your query and that helped it choosing the desired accesspath. I would suggest you to look into the CPU and elapsed time of query with or without list prefetch because maintaining correlation stats is another set of documentation which you require to have. If the response time is better with sequential prefetch then make it sure that always you are running the runstats with this option. [...]
20497 61 38_Re: How to indicate delete intention ?16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 14 Aug 2001 09:27:49 +0530584_- Use FOR UPDATE OF the columns you want to select. Then WHERE CURRENT OF in the delete statements. This works this way. If i am not wrong, column names restriction is also removed in the latest version.
Regards Sanjeev
> -----Original Message----- > From: Mohammad Khan [SMTP:mkkhan88@HOTMAIL.COM] > Sent: Tuesday, August 14, 2001 1:34 AM > To: DB2-L@RYCI.COM > Subject: How to indicate delete intention ? > > Hi > I'm reading some data using a cursor and deleting some of the rows > using 'WHERE CURRENT OF cursor". There are no UPDATE's being done. How do > I > [...]
20559 40 35_Re: Catalog and Directory Passwords16_WOLFENDEN, Kevin26_Kevin.WOLFENDEN@SEMA.CO.UK31_Tue, 14 Aug 2001 09:17:38 +0100370_iso-8859-1 To check for passwords : DIAGNOSE DISPLAY OBD DSNDB01.DBD01 ALL then find FILE PAGESET then at offset x'1a' for 8 characters, see if there is a value To remove : STOP DB2 remove PTF maintenance ru DSNJU003 with SYSTEMDB TBLSPACE=DBD01 image copy catalog/directory install PTFs restart DB2
Kevin Wolfenden DB2 Database Group > SchlumbergerSema > > [...]
20600 30 27_SQL procedure probelm again9_john king24_john_king@REDIFFMAIL.COM31_Tue, 14 Aug 2001 09:07:30 -0000551_- Good day Aurora/Greg, this is the continuation of yesterdays probelm. I was not able to create the procedure with the help of spufi but I got it done by JCl supplied by IBM. The JCL gives me return code 4 I mean a warning but and it says only a warning.The JCL has steps like this. It pre compiles the sql procedure source,Precompile the C source generated in previous step,compile the out put from precompiler, pre link edited the object module from the compiler and link edited the out put from pre link editor. i serched the IBM manuals and [...]
20631 33 11_LOB problem12_Hamid Alvani22_alvani@DPI2.DPI.NET.IR31_Tue, 14 Aug 2001 13:44:38 +0330450_US-ASCII ______________________________ Forward Header __________________________________ Subject: LOB problem Author: alvani at dpi2 Date: 8/13/01 1:49 PM
Hello listener; I have a problem with DB2 Version 6.1.0.IVP Sample job(DSNTEJ71) in step PH071S04 end with this message:
CEE3250C The system or user abend S04E R=00C90101 was issued. From entry point buildPSEGcol at compile unit offset +000006BE at address 15725246. [...]
20665 21 25_looping utility and dumps10_Fritz Rapp21_fritzrapp@T-ONLINE.DE31_Tue, 14 Aug 2001 04:49:41 -0500553_- Hello, since we had a big crush in a production DB2 I have the honourful task to put down what our operating should do in case of...e.g. a looping utility. So i found apar II03665(which was last updated in 1999) and went to work. What is a bit puzzling to me is that if 'something loops' you should stop DB2 with mode(force) if it doesn't come down with trying to stop that DB2 normally(means mode(quiesce)). So my question is: has anybody of you already something written and given it to your operating, in which order dumps are to taken, which [...]
20687 39 67_Re: Error starting DDF with TCPIP on OS/390 - REASON CODE=12BA00C 415_Armando Arranja27_Armando_Arranja@BANCOBPI.PT31_Tue, 14 Aug 2001 13:37:03 +0100591_iso-8859-1 Thanks Jose. It solved the problem.
-----Original Message----- From: José Ignacio Ossuna [mailto:jiossuna@ATCA.ES] Sent: Monday, August 13, 2001 7:23 PM To: DB2-L@RYCI.COM Subject: Re: Error starting DDF with TCPIP on OS/390 - REASON CODE=12BA00C4
Armando,
The REASON CODE tells during a Socket Bind request, a Reserved Port was incorrectly especified.
Change the port requested in the Socket Bind request to a non-reserved port. The reserved ports are found in the NETWORK parmlib statement in the BPXPRMxx member [...]
20727 47 31_Re: SQL procedure probelm again11_David Nance16_DWNance@FHSC.COM31_Tue, 14 Aug 2001 08:57:28 -0400603_US-ASCII John, You say your JCL compiled your procedure, but you do not mention anything about after it was compiled that your job executed a create statement for the procedure and if that finished successfully or what SQL code you recieved.
Dave Nance First Health Services, Corp. (804)527-6841
>>> john_king@REDIFFMAIL.COM 08/14/01 05:07AM >>> Good day Aurora/Greg, this is the continuation of yesterdays probelm. I was not able to create the procedure with the help of spufi but I got it done by JCl supplied by IBM. The JCL gives me return code 4 I mean a warning but and it says [...]
20775 17 21_What is a drain lock.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Tue, 14 Aug 2001 08:09:12 -0500522_- Hi all,
Going thru the recent DB2MAG I came upon the term 'drain lock' in the article 'DB2 DBA'. Subsequently I went thru the admin guide on LOCKING which talks of 'processes draining claim classes.....etc' and I feel lost here. Could someone shed some light.
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.
20793 15 43_Mass deletes in Seg/partitioned tablespace.18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM31_Tue, 14 Aug 2001 08:22:00 -0500378_- Hi all,
How is Mass delete of a table in Segmented tablespace more efficient than that in a partitioned tablespace.
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.
20809 29 60_Version 7 Reference Guide for DB2 UDB for OS/390 available ?12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 14 Aug 2001 15:26:36 +0200335_iso-8859-1 Hello listers,
for a long time I've been working with CA's (former Platinum) Reference Guides for Version 4, 5 and 6 for DB2 UDB for OS/390.
This booklets are very helpful all the time.
And now I'm interested to know if this Reference Guide is available for Version 7. Any information about this ? [...]
20839 65 25_AW: What is a drain lock.12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 14 Aug 2001 15:36:04 +0200591_iso-8859-1 Rajendra,
drains are required when a resource is first accessed. A drain acquires a resource by quiescing claims against the resource. Drains can be requested by commands and utilities.
To more fully understand the concept of draining, think back to the last time that you went to a movie theater. Before anyone is permitted into the movie, the prior attendees must first be cleared out. In essence, this example illustrates the concept of draining. DB2 drains make sure that all other users of a resource are cleared out before allowing any subsequent access. [...]
20905 173 49_Re: How can you tell space available on a volume?14_William Gannon33_wgannon@EMAIL.PALMBEACH.K12.FL.US31_Tue, 14 Aug 2001 09:39:07 -0400354_us-ascii Mr. Yassin and Mr. Medlock
There appears to be interest in both of your solutions to this thread. Let me take this opportunity to remind all of the DB2-L-DOCUMENTS@RYCI.COM list, perhaps posting the source to your solutions there would be of benefit to some of our fellow members ?
Bill G.
Carlton Enuda wrote: [...]
21079 51 64_Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?13_Thomas, Janis19_Janis.Thomas@CA.COM31_Tue, 14 Aug 2001 09:42:46 -0400421_iso-8859-1 We are currently working on the V7 Reference Guide, it should be available in a couple of months.
Janis Thomas Computer Associates DB2 Product Management 630-505-6247 janis.thomas@ca.com
-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Tuesday, August 14, 2001 8:27 AM Subject: Version 7 Reference Guide for DB2 UDB for OS/390 available ? [...]
21131 68 64_AW: Version 7 Reference Guide for DB2 UDB for OS/390 available ?12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 14 Aug 2001 15:53:05 +0200451_iso-8859-1 Thanks for the information, Janis.
With kind regards - mit freundlichen Grüssen, Georg H. Peter
-----Ursprüngliche Nachricht----- Von: Thomas, Janis [mailto:Janis.Thomas@CA.COM] Gesendet am: Dienstag, 14. August 2001 15:43 An: DB2-L@RYCI.COM Betreff: Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?
We are currently working on the V7 Reference Guide, it should be available in a couple of months. [...]
21200 28 13_Mine's a half13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 14 Aug 2001 08:50:54 -0500404_- Why would changing WHERE COL1 <= :col to WHERE COL1 BETWEEN 0 AND :col halve the statement cost? Because it does in several cases I've come across this week!
Also, Mr. Yevich has said that DEGREE(ANY) has no more CPU overhead than DEGREE(1), yet an IBM performance consultant has said we can gain a 40% performance improvement from rebinding all our packages to DEGREE(1) from DEGREE(ANY). [...]
21229 41 47_Re: Mass deletes in Seg/partitioned tablespace.0_19_mike.holmans@BT.COM31_Tue, 14 Aug 2001 15:01:55 +0100687_iso-8859-1 Mass delete in a segmented tablespace is achieved by updating the space management pages, marking all the non-space-management pages as being empty. Deleting from a partitioned tablespace deletes the actual rows, which means visiting every active page.
Mike Holmans Database Consultant Computing Partners, part of Affinitis BT mike.holmans@bt.com
The opinions expressed in this post are those of the author and do not reflect the official position of BT plc -----Original Message----- From: Rajendra Deshpande [mailto:rajendra_deshpande@HOTMAIL.COM] Sent: 14 August 2001 14:22 To: DB2-L@RYCI.COM Subject: [DB2-L] Mass deletes in Seg/partitioned tablespace. [...]
21271 125 47_Re: Mass deletes in Seg/partitioned tablespace.12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 14 Aug 2001 10:07:07 -0400640_US-ASCII You can do a MASS DELETE with either a segmented or partitioned. The difference is the logging. The logging is greatly reduced for segmented tablespaces. I believe only the space map is logged.
This is a section out: Title: DB2 UDB for OS/390 V6 Administration Guide Document Number: SC26-9003-01
5.5.5.3.2 SQL
The amount of logging performed for applications depends on how much data is changed. Certain SQL statements are quite powerful, making it easy to modify a large amount of data with a single statement. These statements include: | Mass deletes and mass updates (except for deleting all rows for [...]
21397 102 68_Re: AW: Version 7 Reference Guide for DB2 UDB for OS/390 available ?12_Susan Lawson22_lawson_susan@YAHOO.COM31_Tue, 14 Aug 2001 07:06:51 -0700605_us-ascii The YL&A UDB Version 7 Family is available from either BMC or YL&A.
Regards, Susan Lawson --- "Peter, Georg" wrote: > Thanks for the information, Janis. > > With kind regards - mit freundlichen Grüssen, > Georg H. Peter > > -----Ursprüngliche Nachricht----- > Von: Thomas, Janis [mailto:Janis.Thomas@CA.COM] > Gesendet am: Dienstag, 14. August 2001 15:43 > An: DB2-L@RYCI.COM > Betreff: Re: Version 7 Reference Guide for DB2 UDB > for OS/390 available > ? > > We are currently working on the V7 Reference Guide, > it should be available > in a couple of months. > > [...]
21500 49 29_Re: looping utility and dumps0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 14 Aug 2001 09:11:48 -0500454_us-ascii Yes, it is very simple "If there are data base problems, contact on-call DBA." We expressly make sure that our operations group do NOT know what to do if there are DB2 problems, because "... a little knowledge is dangerous!" Either we fix it, or we give them explicit step by step commands that they are to follow (yes I guess it is those 'step by step instructions' you want, sorry I but we don't have that specific procedure documented). [...]
21550 207 47_Re: Mass deletes in Seg/partitioned tablespace.16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Tue, 14 Aug 2001 15:12:00 +0100392_- So very true - except when you enable Data Capture Changes on the table residing in a segmented tablespace. When this parameter is enabled, EVERY row will be logged during a MASS DELETE - so instead of a split second - it can run for hours depending on the amout of data. In these cases, I suggest that you do an ALTER TABLE xxx.xxxx DATA CAPTURE NONE prior to the unqualified delete. [...]
21758 80 64_Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 14 Aug 2001 09:10:55 -0500396_iso-8859-1 Georg,
YLA has written a single V7 Reference guide which covers OS/390 & z/OS, and also UDB on Windows/Unix/OS2. This has been printed and distributed by BMC, and has been available since May.
Regards Terry Purcell Yevich Lawson & Assoc Inc (YL&A) IBM Gold Consultant - DB2 IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 http://www.ylassoc.com [...]
21839 75 30_Re: Access path change with v613_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 14 Aug 2001 09:05:22 -0500406_iso-8859-1 Richard,
Although your site may not benefit from STAR JOIN optimization, I would not recommend that all sites disable this feature. Although there were some issues in early V6, APAR PQ43846 (May 2001) has significantly reduced the possibility of query regression; especially for those queries which do not benefit from the outside-in process applicable to a true star schema design. [...]
21915 68 17_Re: Mine's a half14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 14 Aug 2001 07:23:57 -0700638_us-ascii
Whoa there!!! Kind of a major misquote or misunderstanding. DEGREE(ANY) increases CPU for parallelism for the sake of reducing elapsed time. The amount of CPU overhead can vary. I have NEVER said what you stated. However, by turning off parallelism by using DEGREE(1) for everything is wrong. By using DEGREE(ANY) for everything is wrong. DEGREE(ANY) should only be used where parallelism is giving you decreased elapsed time with minimal increase in CPU for that single access path. Now to that 40% reduction, I would love to see the statistics and proof of that because it depends on your particular installation, [...]
21984 146 64_Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM31_Tue, 14 Aug 2001 09:34:11 -0500639_iso-8859-1 How does one get one of these guides?
Trace R. Jones
Terry Purcell cc: Sent by: DB2 Data Subject: Re: Version 7 Reference Guide for DB2 UDB for OS/390 Base Discussion available ? List
08/14/01 09:10 AM Please respond to DB2 Data Base Discussion List
Georg,
YLA has written a single V7 Reference guide which covers OS/390 & z/OS, and also UDB on Windows/Unix/OS2. This has been printed and distributed by BMC, and has been available since May. [...]
22131 65 64_Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?14_Johnson, Daryl28_Daryl.Johnson@PACIFICORP.COM31_Tue, 14 Aug 2001 07:40:11 -0700215_iso-8859-1 I am still trying to get a v6 Ref Guide from CA.
Thanks,
Daryl (DJ) Johnson DBA Work Phone: 503.813.5451 Cell Phone: 503.706.6391 Pager: 503.202.4775 Home Phone: 503.632.4719
22197 165 64_Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 14 Aug 2001 10:41:27 -0400419_iso-8859-1 Yes!! Can these be had by those whose tools come from a two-letter :=( vendor instead of a three-letter :=) vendor?
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Trace Jones [mailto:Trace_R_Jones@RELIANTENERGY.COM] Sent: Tuesday, August 14, 2001 10:34 AM To: DB2-L@RYCI.COM Subject: Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ? [...]
22363 20 17_Re: Mine's a half13_Marcus Davage29_marcus.davage@LLOYDSTSB.CO.UK31_Tue, 14 Aug 2001 09:39:26 -0500465_- Whoops! Dreadfully sorry! I read your attachment: http://jupiter.ryci.com/cgi/wa.exe?A2=ind0002C&L=db2-l&P=R4415&m=5781 and immediately misunderstood it by seeing what I wanted to see. Sorry for misquoting you, and thank you for your kind correction in this matter! :-)
With regard to the SQL, I now understand that I am using the default filter factor to massage my costs, but at the end of the day (i.e. at execution time), how much does it matter? [...]
22384 33 47_Re: Mass deletes in Seg/partitioned tablespace.24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 14 Aug 2001 07:28:50 -0700604_- A mass delete in a segmented tablespace only updates and logs information on the space map pages. It does not update any of the data pages. For a simple or partitioned tablespace, a mass delete needs to delete and log every row in the table.
> -----Original Message----- > From: Rajendra Deshpande [SMTP:rajendra_deshpande@HOTMAIL.COM] > Sent: Tuesday, August 14, 2001 6:22 AM > To: DB2-L@RYCI.COM > Subject: Mass deletes in Seg/partitioned tablespace. > > Hi all, > > How is Mass delete of a table in Segmented tablespace more efficient than > that in a partitioned tablespace. > > TIA. > [...]
22418 43 64_Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 14 Aug 2001 10:11:10 -0500560_iso-8859-1 BMC has a Version 7 Reference Guide available. Richard Yevich did the work on it.. It was first distributed at IDUG in Orlando.
Willie
"Peter, Georg" wrote:
> Hello listers, > > for a long time I've been working with CA's (former Platinum) Reference > Guides for Version 4, 5 and 6 for DB2 UDB for OS/390. > > This booklets are very helpful all the time. > > And now I'm interested to know if this Reference Guide is available for > Version 7. Any information about this ? > > Thanks in advance for any information you are [...]
22462 25 16_'SELECT AS' help11_jim keister22_jkeister@ALTAVISTA.NET31_Tue, 14 Aug 2001 23:46:43 +0800366_iso-8859-1 We have coded many stored procedures using SELECT AS. These SPs were built using SP Builder in UDB under NT where the maximun column length is 30 bytes. We are now moving to DB2 OS/390 where the maximum column length is 18 bytes.
Aside from editing column names from 30 to 18 bytes, are there other options to provide alternate column names?? [...]
22488 77 8_MQSeries16_Brookman, Gerald30_gerald.brookman@ATOSORIGIN.COM31_Tue, 14 Aug 2001 12:04:06 -0400416_iso-8859-1 Env: DB2 V6 on OS/390; OS/390 V2.9; CICS TS V1.3
We are in the process of installing MQSeries in a CICS/DB2 mainframe environment? Is there any potential and/or actual problems anyone on the list is aware of? Thanks.
Gerald R. (Garry) Brookman Atos Origin, Inc. DB2 Technician 5000 South Bowen Road Arlington, TX 76017 (817) 264-8336 Fax (817) 264-8599 E-mail: gerald.brookman@atosorigin.com
22566 185 64_Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 14 Aug 2001 09:08:03 -0700536_us-ascii
Sure - send a request to either BMC office or YL&A office. "Pearson, Eric L," wrote: Yes!! Can these be had by those whose tools come from a two-letter :=( vendor instead of a three-letter :=) vendor?
Regards, eric pearson NS ITO Database Support
-----Original Message----- From: Trace Jones [mailto:Trace_R_Jones@RELIANTENERGY.COM] Sent: Tuesday, August 14, 2001 10:34 AM To: DB2-L@RYCI.COM Subject: Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ? [...]
22752 22 16_RVA and snapshot11_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US31_Tue, 14 Aug 2001 11:10:08 -0500494_- Hello Listers:
Can anyone provide me with information on "RVA" and "snapshot? What does RVA mean?
Thanks in advance........
Tony Clark DB2 Systems Administrator Texas Workforce Commission Ph: (512) 463-3079 tclark@twc.state.tx.us
================================================ 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.
22775 109 12_Re: MQSeries16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 14 Aug 2001 12:18:58 -0400453_iso-8859-1 Garry We use MQSeries *very* heavily on three mainframe LPARs and several lesser machines. DB2 V7, OS/390 V2.9, CICS 4.1. Very few MQ problems. Make sure to have enough memory and make sure the logs respond well - sort of like DB2! You will probably have a learning curve about various thresholds, etc. but you will also probably find the product a solution which excels in terms of reliability, performance, integrity, and ease of use. [...]
22885 63 20_Re: RVA and snapshot0_20_John_Lendman@FPL.COM31_Tue, 14 Aug 2001 12:35:09 -0400423_us-ascii RVA stands for RAMAC Virtual Array. Snapshot is the program that runs on the RVA devices to "snap" the data, either a volume or DSN to another address. Under the covers this is done by using a address table. The data does not get copied, just the pointers of where the data is located. This is used to make backups of large systems like SAP in a short amount of time. I "snap" about 180GB in about 5 minutes. [...]
22949 27 20_Re: RVA and snapshot25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Tue, 14 Aug 2001 11:38:21 -0500383_iso-8859-1 Ramac Virtual Array.
Snapshot is a "feature";i.e. chargeable. It takes "quick" backups at the volume or dataset level and moves the data to internal areas for further processing. Mirroring to other LPARs or dumping to tape. Very fast.
IBM dropped Virtual array concept with ESS(Shark) and have not provide dataset copying for the Flashcopy replacement. [...]
22977 35 20_Re: RVA and snapshot9_Bob Crail15_r.crail@ATT.NET31_Tue, 14 Aug 2001 16:44:18 +0000102_- RVA Ramac Virtual Array See attached http://www.storage.ibm.com/hardsoft/products/rvax83/rvax8 3.htm
23013 73 64_Re: Version 7 Reference Guide for DB2 UDB for OS/390 available ?14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 14 Aug 2001 09:58:02 -0700604_us-ascii
Minor correction, but it was a YL&A work effort, and actually Susan Lawson is primarily responsible for it. Willie Favero wrote: BMC has a Version 7 Reference Guide available. Richard Yevich did the work on it.. It was first distributed at IDUG in Orlando.
Willie
"Peter, Georg" wrote:
> Hello listers, > > for a long time I've been working with CA's (former Platinum) Reference > Guides for Version 4, 5 and 6 for DB2 UDB for OS/390. > > This booklets are very helpful all the time. > > And now I'm interested to know if this Reference [...]
23087 64 35_Re: Catalog and Directory Passwords14_Riedel, Marcia26_MRiedel@TUCSONELECTRIC.COM31_Tue, 14 Aug 2001 10:57:56 -0700628_- Kevin:
Thank you. This is the type of thing I am looking for! I may have more questions when I get this done.
Marcia
-----Original Message----- From: WOLFENDEN, Kevin [SMTP:Kevin.WOLFENDEN@SEMA.CO.UK] Sent: Tuesday, August 14, 2001 1:18 AM To: DB2-L@RYCI.COM Subject: Re: Catalog and Directory Passwords
To check for passwords : DIAGNOSE DISPLAY OBD DSNDB01.DBD01 ALL then find FILE PAGESET then at offset x'1a' for 8 characters, see if there is a value To remove : STOP DB2 remove PTF maintenance ru DSNJU003 with SYSTEMDB TBLSPACE=DBD01 image copy catalog/directory install PTFs restart DB2 [...]
23152 68 44_Re: UPDATE - Catalog and Directory Passwords10_Alan Smith25_alancsmith@BTINTERNET.COM31_Tue, 14 Aug 2001 18:56:40 +0100578_us-ascii Catalog objects are easy - SYSINDEXES and SYSTABLESPACE have a column DSETPASS which holds any password. Run DSNTIJPM from SDSNSAMP to generate the ALTER statements for your objects. Directory objects are more difficult. I think the only way is to do a DIAGNOSE OBD dbname.tsname ALL, then, consulting the DIAGNOSIS GUIDE, look for the offset for the passwords - spaces or hex zeroes should be OK (I don't have a diagnosis guide to hand and there isn't an electronic one so I can't tell you what the offset is). I think that this is the problem that comes up when [...]
23221 32 56_regarding DSN1COPY with CHECK option.... immediate help.17_ravi kumar hassan18_ravibh@HOTMAIL.COM31_Tue, 14 Aug 2001 13:06:09 -0500512_- Hello Folks,
We are using DB2 V6 on OS/390. actually in our shop they did some fix on the database. now they are asking us to run DSN1COPY with CHECK option on the tables which are having no RI.
i went thru the utility guide to setup the jcl. but i am little bit confused with this. i am having this doubt. 1) do we need to stop the database while running this utility. 2) do we need to metion the image copy of the tablespace or do we need to use the DB2 VSAM dataset on which this utility [...]
23254 48 14_UNLOAD UTILITY10_Alan Smith25_alancsmith@BTINTERNET.COM31_Tue, 14 Aug 2001 19:11:29 +0100302_us-ascii Locking apart, this sort of I/O activity will really hammer your disks and increase the I/O response time. Your performance or DASD people should be able to tell you if this is happening during this time. Fast Unload allows you to unload from image copies which would bypass the problem. [...]
23303 153 12_Re: MQSeries15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 14 Aug 2001 14:39:02 -0400382_iso-8859-1 Which MQseries you are using? We are using v1.2 on OS/390 2.9. Very difficult to code program with MQseries. API was so bad. May be newer version must have good API. We were using MS MQ and connecting it to MQseries using FALCON bridge , since people did not know how to code in MQseries in client/server side. Mainframe I wrote many programs, but it was difficult. [...]
23457 17 60_How do we explain a SQL with declare global temporary table?15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 14 Aug 2001 14:53:55 -0400443_iso-8859-1 How do we explain a SQL statement which has a declare global temporary table using visual explain or platinum detector? In both case I am getting table not found.
thanks..sibi
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
23475 194 12_Re: MQSeries16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 14 Aug 2001 15:01:22 -0400325_iso-8859-1 Our MQ is 2.1. What API problems did you have? As for 'not knowing' - I do not have the v1.2 manuals available, but the 2.1 manuals describe the calls and the structures for at least C and Visual Basic, Java, and even (why?????) RPG in pretty good detail.
Regards, eric pearson NS ITO Database Support [...]
23670 33 64_Re: How do we explain a SQL with declare global temporary table?24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 14 Aug 2001 12:12:11 -0700623_- Excuse me, but why would you need to? Since Global Temporary Tables cannot have any indexes, they are always accessed via a tablespace scan.
> -----Original Message----- > From: Philip, Sibimon [SMTP:SPhilip@CSXLINES.COM] > Sent: Tuesday, August 14, 2001 11:54 AM > To: DB2-L@RYCI.COM > Subject: How do we explain a SQL with declare global temporary table? > > How do we explain a SQL statement which has a declare global temporary > table > using visual explain or platinum detector? In both case I am getting > table > not found. > > > thanks..sibi > > ================================================ > To [...]
23704 52 64_Re: How do we explain a SQL with declare global temporary table?15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 14 Aug 2001 15:25:15 -0400418_- Since I am joining many other tables to this DGTT (I am tired of typing the whole thing), I want to know how the join works. Also we can create index for DGTT.
thanks..sibi
-----Original Message----- From: Leblanc, Francis C - CNF [mailto:Leblanc.Francis@CNF.COM] Sent: Tuesday, August 14, 2001 02:12 PM To: DB2-L@RYCI.COM Subject: Re: How do we explain a SQL with declare global temporary table? [...]
23757 29 60_Re: regarding DSN1COPY with CHECK option.... immediate help.15_Philippe Herman20_pherman@LANDMARK.COM31_Tue, 14 Aug 2001 15:25:42 -0400320_us-ascii Hi Ravi,
DSN1COPY is run outside the control of DB2 It is your responsability to either STOP DB2 or the object or to put it in a state where nobody else can modify it while DSN1COPY is running (RO status)
You can run a check directly on the DB2 VSAM file but only one Tablespace per JCL step [...]
23787 42 64_Re: How do we explain a SQL with declare global temporary table?15_Benjamin Reches33_Benjamin.Reches@MORGANSTANLEY.COM31_Tue, 14 Aug 2001 15:28:37 -0400579_us-ascii you can create indexes on a DECLARED temporary table
"Leblanc, Francis C - CNF" wrote:
> Excuse me, but why would you need to? Since Global Temporary Tables cannot > have any indexes, they are always accessed via a tablespace scan. > > > -----Original Message----- > > From: Philip, Sibimon [SMTP:SPhilip@CSXLINES.COM] > > Sent: Tuesday, August 14, 2001 11:54 AM > > To: DB2-L@RYCI.COM > > Subject: How do we explain a SQL with declare global temporary table? > > > > How do we explain a SQL statement which has a declare global temporary > > table > [...]
23830 61 64_Re: How do we explain a SQL with declare global temporary table?13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 14 Aug 2001 14:38:09 -0500368_iso-8859-1 V6 Declared Global Temporary tables, as opposed to Created Global Temporary tables can have indexes created on them.
Remember though that any SQL accessing a declared temp table will be incrementally bound at runtime once the cardinality etc is known. Explaining these beforehand will not necessarily give you the access path chosen at runtime. [...]
23892 96 64_Re: How do we explain a SQL with declare global temporary table?16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Tue, 14 Aug 2001 15:38:41 -0400406_us-ascii I have explained them by putting the sql in spufi and wrapping EXPLAIN PLAN SET QUERYNO = nnn FOR
around the sql to be explained.
HTH,
Rick Creech
"Philip, Sibimon" To: DB2-L@RYCI.COM bcc: Sent by: DB2 Subject: Re: How do we explain a SQL with Data Base declare global temporary table? Discussion List [...]
23989 26 40_dsntep2 bind from os/390 to remote as40010_Earl Dixon19_earl_dixon@BELK.COM31_Tue, 14 Aug 2001 14:25:47 -0500583_- Can someone help me with a bind problem. I have drda connecting the os390 db2 subsys(as an AR) to the as400 db2400 (as an AS) I have bound DSNTIAUL, DSNTIAD and SPUFI to the remote location. I have been trying to bind a package for DSNTEP2 just the same as I did with the TIAUL and TIAD with the following command: bind package(location.dsntep2) member(dsntep2) act(rep) iso(cs) owner(*****) validate(bind) and I get the following error: SQLCODE = -30073 SQLSTATE = 58017 SQLERRMT = 1144:0200 SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A= UNSUCCESSFUL BIND FOR PACKAGE = [...]
24016 22 38_Enabling Parallelism in Cognos Queries11_Jeff Schade21_JSCHADE@MAIL2.PCH.COM31_Tue, 14 Aug 2001 15:52:43 -0400340_US-ASCII My company is using Cognos to access our DB2 tables and we would like to enable DEGREE=ANY for these queries. Unfortunatley when we contacted Cognos support they informed us that there is no facility available to add the 'SET CURRENT DEGREE=ANY' to our queries. Has anyone else found a solution to this lack of functionality. [...]
24039 35 49_Adding a fenced ID after an instance is installed14_Marshall Fuqua19_marcfuqua@YAHOO.COM31_Tue, 14 Aug 2001 13:05:01 -0700583_us-ascii Platform: DB2 UDB V7.1 running under AIX 4.3.3
When a DB2 instance was installed, the installer (not me) did not explicitly specify a user ID to be used for running fenced stored procedures & UDFs. My question: is it possible to add a fenced user ID for an instance after the instance is installed? I can't find anything in the DB2 documentation or the listserv archives on this subject. I'm guessing that you would create the ID & associated group under AIX & then execute the 'db2iupdt' command with the '-u' parameter to specify the user ID. Is this correct? [...]
24075 37 42_Re: Enabling Parallelism in Cognos Queries12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 14 Aug 2001 13:14:47 -0700592_us-ascii You can enable it thru DB2 Connect if you're using that. There is a parm in CCA settings for ODBC drivers that will enable you to override everything and force DEGREE=ANY. Works fine for COGNOS. --- Jeff Schade wrote: > My company is using Cognos to access our DB2 tables and we would like > to enable DEGREE=ANY for these queries. Unfortunatley when we > contacted Cognos support they informed us that there is no facility > available to add the 'SET CURRENT DEGREE=ANY' to our queries. Has > anyone else found a solution to this lack of functionality. [...]
24113 117 64_Re: How do we explain a SQL with declare global temporary table?15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 14 Aug 2001 16:17:58 -0400449_- I could do this but we do not get that nice representation of visual explain. Also platinum detector give lot of info about the tables and indexes along with readable format of the explain.
thanks..sibi
-----Original Message----- From: Charles F Creech [mailto:cfcreech@DUKE-ENERGY.COM] Sent: Tuesday, August 14, 2001 02:39 PM To: DB2-L@RYCI.COM Subject: Re: How do we explain a SQL with declare global temporary table? [...]
24231 233 12_Re: MQSeries15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 14 Aug 2001 17:18:30 -0400325_iso-8859-1 From client/server side I do not know how the API looks like, but from mainframe point view, we need to handle object handle very carefully ( we had many problem because of this), also we have lot of option in mqopen, mqget and mqput which is confusing. Also a number of copybook to put in the COBOL program. [...]
24465 69 55_Baltimore/Washington DB2 Users' Group September Meeting12_Henry Nalven25_henry.nalven@MARRIOTT.COM31_Tue, 14 Aug 2001 16:08:12 -0500752_- Baltimore/Washington DB2 Users' Group September Meeting
Meeting Date: September 12, 2001 (Wednesday) Location: Sheraton Columbia Inn, 10207 Wincopin Circle, Columbia, MD, (410) 730-3900
Meeting Schedule: 8:30 - 9:00 Registration
9:00 - 10:15 DB2 Universal Database Version 7.2 (for UNIX & Intel) Landon DelSordo, IBM
DB2 UDB 7.2 is the newest release of the distributed DB2 product line. A number of improvements and enhancements were made in the areas of e- business, business intelligence, heterogeneous access, and data management. Specific enhancements include high availability functionality, improved stored procedure deployment, overall SQL support, and a new sequence database object to make database [...]
24535 59 44_Re: dsntep2 bind from os/390 to remote as40010_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 15 Aug 2001 10:26:20 +1000386_us-ascii Earl,
Based on the SQLcode, it looks like u r trying to bind a package on the remote server with a version, and the remote server(AS/400) doesnt support versions. If u look at the error message, it mentions a version of 'V6R1'. I am not sure how the other packages r bound. Do u know where the DBRM is picked up from for the remote bind ? Have u tried a bindcopy ? [...]
24595 20 15_IBM Redbook URL0_23_adamsrob@WELLSFARGO.COM31_Tue, 14 Aug 2001 19:15:00 -0700453_iso-8859-1 SORRY to burden the list with this yet again, but will someone kindly send me the URL for the IBM redbook site?
Off-list would be fine!
Rob Adams-Kane Wells Fargo adamsrob@wellsfargo.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.
24616 68 60_Re: DDF TCPIP insert Performanace & Blocking or not blocking23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Wed, 15 Aug 2001 02:21:33 -0000486_iso-8859-1 How often are commits processed from the nt environment??. How many records per second do you need to process??. Using FTP and sending a file to be processed by an application may be an answer. You could use ftp to send the file and ftp to start the job.
-----Original Message----- From: Alex Andrade [mailto:alexdandrade@YAHOO.COM] Sent: Wednesday, 8 August 2001 10:45 To: DB2-L@RYCI.COM Subject: DDF TCPIP insert Performanace & Blocking or not blocking [...]
24685 40 19_Re: IBM Redbook URL16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Tue, 14 Aug 2001 22:34:13 -0400509_us-ascii http://www.redbooks.ibm.com/
adamsrob@WELLSFARGO.COM on 08/14/2001 10:15:00 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: IBM Redbook URL
SORRY to burden the list with this yet again, but will someone kindly send me the URL for the IBM redbook site?
Off-list would be fine!
Rob Adams-Kane Wells Fargo adamsrob@wellsfargo.com [...]
24726 40 19_Re: IBM Redbook URL14_N. Chartorisky24_nchartorisky@HOTMAIL.COM31_Wed, 15 Aug 2001 12:28:16 +1000748_iso-8859-1 This is the one I have in my immediate reach. Hopefully you can navigate from there. Regards Nick http://publib-b.boulder.ibm.com/Redbooks.nsf/Portals/S390 ----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, August 15, 2001 12:15 PM Subject: IBM Redbook URL
> SORRY to burden the list with this yet again, > but will someone kindly send me the URL for > the IBM redbook site? > > Off-list would be fine! > > Rob Adams-Kane > Wells Fargo > adamsrob@wellsfargo.com > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. [...]
24767 57 60_Re: regarding DSN1COPY with CHECK option.... immediate help.10_Praet Marc16_maseen@SKYNET.BE31_Wed, 15 Aug 2001 06:47:26 +0200491_iso-8859-1 Hi Kumar,
Yes, you need to stop the spaces involved. Why ? Simply, to flush the DB2 buffers, meaning the pages in the bufferpool to be written to disk, so that DSN1COPY can see them, if not...
Regards, Marc.
-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]Namens ravi kumar hassan Verzonden: dinsdag 14 augustus 2001 20:06 Aan: DB2-L@RYCI.COM Onderwerp: regarding DSN1COPY with CHECK option.... immediate help. [...]