1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2000, week 4
2 122 12_Re: DSNV086E17_suthep thampranee18_suthepth@SCB.CO.TH31_Tue, 22 Feb 2000 14:18:07 +0700569_Windows-874 Hi Everybody I can find the reason code.The message = DSNV086E and Reason = 00E50705 I run on DB2/OS390 Version 5.I sent this message to IBM in THAILAND but nothing feed back yet. Thanks JOE
---------- > From: Lourdes Kishi > To: DB2-L@RYCI.COM > Subject: Re: DSNV086E > Date: 17 ¡ØÁÀҾѹ¸ì 2543 18:57 > > Hello Joe, > > We received this message too! What I can tell you... is that you > are really in trouble :-) as we are, cause it is not solved yet!. > It started after we applied some PSP's to SHARK Disk. > [...]
125 784 20_reason code 00E5070517_Nagaraj Pudukotai33_nagaraj.pudukotai@HPSBLR.SOFT.NET31_Mon, 22 Feb 1999 13:03:28 +0530475_iso-8859-1 Hi Joe
This is what I got for the reason code 00E50705
Explanation: A subsystem termination was requested for one of the following reasons:
1. An agent was flagged as executing in 'must complete' mode, 2. An execution unit holds a latch, 3. An agent is marked as being on a latch waiter queue, when none of these conditions should be true. Additionally, the subsystem termination may have been preceded by an abend with this reason code. [...]
910 64 22_Re: RACF/DB2 Interface17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Tue, 22 Feb 2000 09:53:44 +0100379_us-ascii Hi Rohn, thi is much more interesting: consider lot of people moving around from project to project, so changing their requirement ... If you have to follow them in the normal-DB2 way you have to do a lot of GRANT and REVOKE job, daily ... If you work with the external RACF-DB2 security interface, all you have to do is to change the user group .... sound simple? [...]
975 30 29_DB2 to RACF: project planning10_Peter Boot22_Peter.Boot@MAIL.ING.NL31_Tue, 22 Feb 2000 10:32:09 +0000437_US-ASCII Hi,
We've seen some discussion on the list the last few days about moving from DB2 internal security to using RACF. One of our computing centres is planning such a move, and we've been asked to provide some input about the effort it will take.
Now I understand the effort will be related to the number of objects, the degree of access control one wants to establish, and the strictness of naming conventions. [...]
1006 35 21_DDF - VTAM definition14_Robert Niemiec23_rniemiec@KRAKOW.TPSA.PL31_Tue, 22 Feb 2000 11:03:45 +0100671_US-ASCII I would like to make DB2/os390 acting as AS. I made the definition as described in Installation Guide. When I start DDF, I get the following messages:
DSNL003I -KBD1 DDF IS STARTING DSNL519I -KBD1 DSNLILNR TCP/IP SERVICES AVAILABLE 421 FOR DOMAIN TKRDKBD1 AND PORT 446 DSNL519I -KBD1 DSNLIRSY TCP/IP SERVICES AVAILABLE 422 FOR DOMAIN TKRDKBD1 AND PORT 5020 DSNL015I -KBD1 VTAM SETLOGON FAILED RTNCD='10'X FDBK2='19'X DSNL004I -KBD1 DDF START COMPLETE 424 LOCATION TKRDKBD1LOC LU TPSA.TKRDKBD1 GENERICLU TPSA.KBD1LU DOMAIN TKRDKBD1 TCPPORT 446 RESPORT 5020 DSNL007I -KBD1 DDF IS ABNORMALLY TERMINATING DSNL008I -KBD1 DDF ABNORMAL TERMINATION COMPLETE [...]
1042 73 33_Re: DB2 to RACF: project planning15_Toine Michielse18_vndobtm@US.IBM.COM31_Tue, 22 Feb 2000 11:03:19 +0000358_us-ascii Hello Peter,
It should not be too bad. There is a tool available (and shipped) that will help you generate all the necessary RACF permit commands based on what's in your DB2 catalog today.
Also, you can phase this in. Meaning, if RACF is not able to grant access on a authorization request, then DB2's authorization still occurs. [...]
1116 58 33_Re: DB2 Disaster Recovery Options22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 22 Feb 2000 09:44:58 +0000473_ISO-8859-1 Marcia Cannot respond a lot of detail .. busy with Datashairng, but please do not wince at the standard DR .. I have set this all up here in a DS environment and in my honest opinion it take a short time to DR .. I expect ni a real DR test on 1TB of data to be able to get the whole thing back in less than 24 hours .. quicker if you have the mips .. we have 1600 mips .. and shed loads of storage and sort work space ... which means it will be real quick. [...]
1175 79 33_Re: DB2 Disaster Recovery Options22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 22 Feb 2000 09:46:01 +0000733_ISO-8859-1 ...oh and they can cost a fortune to implement .. :-)
Leslie Pendlebury-Bowe
______________________________ Reply Separator _________________________________ Subject: Re: DB2 Disaster Recovery Options Author: Ron Haupert at Internet Date: 2/21/00 4:13 PM
The best disaster recovery plan for DB2 may be to perform a disaster "restart" rather than perform disaster recovery. Disaster restart is based on concepts of remotely mirrored data. Data is mirrored to a restart site using remote mirroring products like IBM PPRC, IBM XRC, or EMC SRDF. Some of these products allow synchronous remote mirroring such that when a local site is lost, the database and [...]
1255 90 27_Re: Your opinion on explain0_19_mike.holmans@BT.COM31_Tue, 22 Feb 2000 10:47:37 -0000357_- Randall,
If you don't check your application's access paths before you go to production you will get grief and misery and terrible response times and daily batch programs which run for 32 hours. And I don't care what Richard Yevich says, it doesn't depend. It's an iron law.
Whether anyone will check access paths does depend, however. [...]
1346 64 25_Re: DDF - VTAM definition32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Tue, 22 Feb 2000 13:39:17 +0200413_- The explanation for return codes are
RTCD FDBK2 X'10'(16)X'19'(25)
Host is not a member of Sysplex. You issued either a INQUIRE OPTCD=SESSNAME, CHANGE OPTCD=ENDAFFIN, or a SETLOGON OPTCD=GNAMEADD/GNAMEDEL macroinstruction but the coupling facility for this host is inaccessible.
Check the registration of member to Sysplex. Did you defined DDF AS as Superuser to your security system. [...]
1411 54 27_Re: Your opinion on explain11_Hilton Tina15_HiltonT@TCE.COM31_Tue, 22 Feb 2000 07:28:50 -0500438_iso-8859-1 Unfortunately, we are one of those shops -- but we are changing. The original DBAs were against doing explains as part of the binds. It used to drive me nuts (I'm the sysprog/sys admin) when I'd look at poorly executing threads because there was no way of seeing if the access path had changed with the most recent bind. Anyway, now we have Platinum Plan Analyzer and the current DBA and app DBA are in favor of explains. [...]
1466 228 12_Re: DSNV086E19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 22 Feb 2000 06:36:45 -0600464_Windows-874 Lourdes Kishi, Explanation below.
00E50705
Explanation: A subsystem termination was requested for one of the following reasons:
1. An agent was flagged as executing in 'must complete' mode, 2. An execution unit holds a latch, 3. An agent is marked as being on a latch waiter queue, when none of these conditions should be true. Additionally, the subsystem termination may have been preceded by an abend with this reason code. [...]
1695 120 41_Re: DB2 audit - UDB 5.2 on an NT platform19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 22 Feb 2000 06:52:32 -0600587_iso-8859-1 Milorad, The cost of doing the audit you describe will be substantial and probably prohibitive. This sounds more like a paranoid or vengeful Auditor than a real request. Get with me offline if you really end up needing this level of auditing. Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in [...]
1816 62 27_Re: Your opinion on explain0_20_ddlusk@HOUSEHOLD.COM31_Tue, 22 Feb 2000 06:45:12 -0600519_us-ascii It is a standard here, where all new applications are required to have an explain done, and evaluated by the dba
We use PLATINUM's explain.... it gives the results in understandable english
Derez
Randall Barbour 02/21/2000 06:02 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Derez D. Lusk/Household International) Subject: Your opinion on explain [...]
1879 84 27_Re: Your opinion on explain14_Bistricer, Avi20_BistricerA@CONED.COM31_Tue, 22 Feb 2000 08:02:11 -0500472_- Can someone post the sql that will clean the plan table ( leave only the last (latest) 5 entries for each plan) Thanks Avi Bistricer, DBA 212.460.6695
-----Original Message----- From: ddlusk@HOUSEHOLD.COM [SMTP:ddlusk@HOUSEHOLD.COM] Sent: Tuesday, February 22, 2000 7:45 AM To: DB2-L@RYCI.COM Subject: Re: Your opinion on explain
It is a standard here, where all new applications are required to have an explain done, and evaluated by the dba [...]
1964 40 20_BIND and web threads11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Tue, 22 Feb 2000 08:16:30 -0500369_us-ascii In version 6 using DDF, connection pooling and persistent connection, we get a timeout when trying to bind a stored procedure that is in use by a web thread. How does one bind replace a stored procedure that is in use by DDF? To date, we've been cancelling the web threads, binding the stored procedure, then allowing the web threads to be reestablished. [...]
2005 86 24_Re: BIND and web threads15_Rene Hendriksen16_reh@NOTES.BEC.DK31_Tue, 22 Feb 2000 14:11:45 +0100713_iso-8859-1 Hi Joe Couldn't you do this by versioning your package. But i don't know stored procedures to well.
Regards René
Joe Luthman on 22-02-2000 14:16:30
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Rene Hendriksen/reh/usr/becint) Subject: BIND and web threads
In version 6 using DDF, connection pooling and persistent connection, we get a timeout when trying to bind a stored procedure that is in use by a web thread. How does one bind replace a stored procedure that is in use by DDF? To date, we've been cancelling the web threads, binding the stored [...]
2092 130 27_Re: Your opinion on explain15_Toine Michielse18_vndobtm@US.IBM.COM31_Tue, 22 Feb 2000 14:14:26 +0000495_us-ascii Hello Avi,
Many moons ago I worked in a shop where EXPLAIN on every bind was mandatory. Instead of just keeping the last x versions of explain output, I wrote a program that would keep the two most recent *DIFFERENT* versions. This took a little more programming effort but is much more useful. This showed us exactly when that good access path went bad..........And what it was before.. Keeping the last x number of versions does not necessarily give you that information. [...]
2223 86 24_Re: Opinons and comments13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Tue, 22 Feb 2000 08:15:38 -0500365_big5
Andrea:
I noted with interest your comment that "Image Copies ... run fine". We noticed in our PeopleSoft HR system that, indeed, the ICs run just fine; however, the Recover of the tablespaces and the Rebuild of the 1000+ indexes takes 8+ hours. This outage was deemed to be too long by our clients, so we had to come up with alternatives. [...]
2310 32 26_Update option of CATMAINT.9_Ted Pesta18_tpesta@AMQUEST.COM31_Tue, 22 Feb 2000 07:46:32 -0500544_iso-8859-1 I'm trying to apply UN99744 on a DB2 V4 system. There is an action hold that indicated that a CATMAINT utility must be run to update the catalog and directory. A part of the hold data follows
This apar fixes a clustering problem for reorg of catalog table spaces. After the ptf has been applied a utility job similar to the following must be run to update the catalog and directory: //DSNTITC EXEC DSNUPROC,SYSTEM=DSN,UID=RELODCAT //SYSPRINT DD SYSOUT=* //UPDTOUTP DD SYSOUT=* //SYSIN DD * CATMAINT UPDATE UNLDDN PN82917 [...]
2343 47 27_Re: SV: CSP V3.3 and DB2 V54_DBAS14_dbas@CWCOM.NET31_Tue, 22 Feb 2000 13:43:40 -0000341_iso-8859-1 Arne, Thanks very much for the response. Can I ask why you migrated to VAG in Nov 99. Was this a Y2K requirement ?
Paul ----- Original Message ----- From: "Arne Nilsen" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, February 16, 2000 8:09 PM Subject: SV: CSP V3.3 and DB2 V5 [...]
2391 77 30_Re: Update option of CATMAINT.9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 22 Feb 2000 13:44:29 +0000341_us-ascii The CATMAINT described carries out actions documented in APAR PN82917 for PTF UN99744. This is the normal format IBM use when they need to use CATMAINT for a specific PTF (i.e. CATMAINT UPDATE UNLDDN apar number). Just run it as documented in the HOLD and you will be ok. Kind Regards, Andy Hunt - Scottish And Southern Energy [...]
2469 67 24_Re: BIND and web threads20_Laurence M Crouch Jr24_lmcrouch@DUKE-ENERGY.COM31_Tue, 22 Feb 2000 08:51:31 -0500743_us-ascii If your packages are bound release(deallocate), try switching them to release(commit).
Joe Luthman on 02/22/2000 08:16:30 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Laurence M Crouch Jr/Corp/DukePower) Subject: BIND and web threads
In version 6 using DDF, connection pooling and persistent connection, we get a timeout when trying to bind a stored procedure that is in use by a web thread. How does one bind replace a stored procedure that is in use by DDF? To date, we've been cancelling the web threads, binding the stored procedure, then allowing the web threads [...]
2537 90 27_Re: Your opinion on explain19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 22 Feb 2000 07:52:37 -0600614_iso-8859-1 Avi, The following SQL finds all PACKAGEs older than the most recent 5:
SELECT A.COLLID, A.NAME, A.VERSION FROM SYSIBM.SYSPACKAGE A WHERE A.VERSION ^= ' ' AND 5 <= (SELECT COUNT(*) FROM SYSIBM.SYSPACKAGE B WHERE A.LOCATION = B.LOCATION AND A.COLLID - B.COLLID AND A.NAME = B.NAME AND A.VERSION < B.VERSION HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe [...]
2628 110 33_Re: DB2 to RACF: project planning0_24_lightsey@ITS.STATE.MS.US31_Tue, 22 Feb 2000 07:57:41 -0600412_us-ascii For those of getting into this particular game a bit late, what is the name/order number/??? of the tool? Sounds useful and, knowing our auditors' paranoia, will probably get used in the near future.
Thanks
Toine Michielse To: DB2-L@RYCI.COM Subject: Re: DB2 to RACF: project planning Sent by: DB2 Data Base Discussion List [...]
2739 143 33_Re: DB2 to RACF: project planning15_Toine Michielse18_vndobtm@US.IBM.COM31_Tue, 22 Feb 2000 15:01:35 +0000499_us-ascii Hello,
You can just download it from the RACF homepage. URL in previous append....
Regards
Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS
lightsey@ITS.STATE.MS.US@RYCI.COM> on 02/22/2000 01:57:41 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
2883 58 30_Re: Update option of CATMAINT.12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Tue, 22 Feb 2000 08:22:16 -0600372_iso-8859-1 I might add that I am familiar with this PYF. Not having it on, by passing the CATMAINT, is something to regret. I know of one place where the hold action was not applied an they started to loose the ability to use clustering indexes. The truth is that the Clustering Index Flag is in the Directory and not the catalog. The catalog is informational, only. [...]
2942 67 21_Re: Trapping SQL Text11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Tue, 22 Feb 2000 09:28:05 -0500466_iso-8859-1 Dave,
1. At the last shop I was at we used Omegamon to capture dynamic SQL. It worked fine with some exceptions: a. It is limited to 16k per statement. (I think this is a IBM limitation). b. There is no easy way to extract the stuff from it for additional analysis or historical purposes. c. There is no easy way to analyze the statements (explain). I think this may be possible if you run Omegamon in TSO and also have Candle's DB/Explain... [...]
3010 65 21_Re: Trapping SQL Text9_Fox, Dave16_Dave_Fox@BMC.COM31_Tue, 22 Feb 2000 08:33:36 -0600484_ISO-8859-1 Dave,
I don't know what "collector" you are referencing for these products, but as one of the authors of Apptune I can assure you that it is in no way dependent upon nor constrained by the operation of the other products you listed. Apptune provides its own data collector to obtain SQL measurements (including SQL statement text) and expensive SQL traces are NOT required. Its object usage reports can also assist you with your evaluation of existing indexes. [...]
3076 48 32_Re: db2 irlm csa inconsistencies10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 22 Feb 2000 09:40:29 -0500602_us-ascii Thomas G Taylor 02/17/2000 03:05 PM
To: db2-l@ryci.com cc:
Subject: db2 irlm csa inconsistencies
HI all
can some one clear up some inconsistencies with irlm storage.
I changed from pc=yes to pc=no with a maxcsa =6m. I then waited 4 days and issued the 'modify db2tirlm,status,stor' command with the following results.
DXR100I DX2T001 STOR STATS PC: NO MAXCSA: 6M CSA USE: ACNT: 324K AHWM: 1092K CUR: 800K HWM: 1568K ABOVE 16M: 19 795K BELOW 16M: 3 5K CLASS TYPE SEGS MEM TYPE SEGS MEM TYPE SEGS MEM ACCNT T-1 4 256K T-2 1 64K T-3 1 4K PROC WRK 5 [...]
3125 26 37_Secondary extents in DB2 V5 for OS39013_Brendan Friel18_b.friel@PECORP.COM31_Tue, 22 Feb 2000 08:49:00 -0600499_iso-8859-1 I'm currently in a location where the rule of thumb for secondary extents is 'we ignore them until a dataset goes into 15 or 20 secondary extents'.
Using STOGROUPS under DB2 V5 in an MVS environment.
This doesn't seem to be consistent with most of the documentation I've seen which strongly suggests that it is important to get rid of ANY secondary extents as soon as possible. That's always been the technique I've used with various OS390 legacy products in the past. [...]
3152 23 22_Re: RACF/DB2 Interface10_John Hardy23_john_j_hardy@UK.IBM.COM31_Tue, 22 Feb 2000 08:46:49 -0600479_- The following are sources of information re: RACF/DB2 External Security:
Ready for e-business:OS/390 Security Server Enhancements Document Number: SG24-5158-00 : See Chapter 4. OS/390 Security Server Support for Protection of DB2 Objects
OS/390 V2R8.0 Security Server (RACF) Security Administrator's Guide Document Number: SC28-1915-06 : See Chapter 11. Controlling Access to DB2 Objects Appendix D. RACF/DB2 External Security Module: Authorization Checking [...]
3176 46 41_Re: Secondary extents in DB2 V5 for OS39013_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Tue, 22 Feb 2000 15:23:00 -0000455_- Brendan we always attempt to keep extents under 5 especially the indexes(indices).
DB2 V4 using STOGROUPS on OS/390.
Ian McDonald DB2 DBA Abbey National ---------- From: Brendan Friel To: DB2-L@RYCI.COM Subject: Secondary extents in DB2 V5 for OS390 Date: 22 February 2000 14:49
I'm currently in a location where the rule of thumb for secondary extents is 'we ignore them until a dataset goes into 15 or 20 secondary extents'. [...]
3223 78 41_Re: Secondary extents in DB2 V5 for OS3900_22_BILL_GALLAGHER@PHL.COM31_Tue, 22 Feb 2000 10:24:13 -0500610_us-ascii Brendan,
I'd say that it depends on what kind of processing you are doing on the tablespaces/indexspaces that are going into secondary extents. If you are doing a lot of sequential processing (tablespace scans, index scans), then it would probably be in your best interests to have the dataset in question contained in as few extents as possible to keep the physical I/O to a minimum. Even though with sequential processing you'll be doing asynchronous I/O via prefetch, you're still going to make the physical disk read/write head do a lot more work than may be necessary if your dataset [...]
3302 116 33_Re: DB2 Disaster Recovery Options9_Don Alden26_Don.Alden@PKSIS.LEVEL3.COM31_Tue, 22 Feb 2000 08:25:46 -0700465_iso-8859-1 Howdy All,
Just in case some of you folks's companies don't have "Big Bucks" to use Restart I will offer my experience of doing it Manually (the hard way).
We had to recover a fairly large SAP system (over 500 tables). The tricky part was setting-up the DB2 Log files. For those of you who have had the privledge of doing this before, you probably remember how fun it was to syncronize the BSDS and Active log RBA's at the "hot site". [...]
3419 101 33_Re: DB2 to RACF: project planning14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Tue, 22 Feb 2000 07:51:52 -0800579_iso-8859-1 However, bear in mind that this phased in approach does have negatives. In addition, I would strongly recomend that you issue DB2 REVOKES as soon as the RACF setup has been verified. Remember that if RACF makes a decision to either allow or reject a request, the catalog tables will NOT be checked. This could get confusing if there still is data in the various authority tables, especially for people with select auth on these tables because they may say "The catalog says this will work but it doesn't." Also, I would suggest that once you get things into RACF [...]
3521 76 41_Re: Secondary extents in DB2 V5 for OS39011_Paul Mayhew15_mayhewp@CIBC.CA31_Tue, 22 Feb 2000 10:46:05 -0500596_us-ascii I have always had the contention that it doesn't matter that much any more......
I think it was more of an issue years ago becuase extents automatically meant more head movement which meant performance impacts. These days of lots of memory for bufferpool and fast dasd, for the most part I don't worry about it. It causes more headaches from a maintenance perspective than anything else.... I think you are much better off keeping the data in order (ie. clustered) than you are worrying about extents per se. The only tables I worry about for extents are very active tables. [...]
3598 43 44_REXX/DB2 Interface - Program Number 5764-0749_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 22 Feb 2000 16:03:55 +0000392_us-ascii We are currently using (and have been for years) IBM REXX-SQL Interface (Program Number 5764-074).
At V5.1 IBM have introduced a 'no-cost' feature REXX/DB2 interface (FMID JDB551H).
With a view to future support I contacted IBM to determine which interface we should be using. They responded by saying 5764-074 is unlikely to be supported for future DB2 releases. [...]
3642 103 41_Re: Secondary extents in DB2 V5 for OS39011_rick creech18_ykcirc@HOTMAIL.COM29_Tue, 22 Feb 2000 08:10:37 PST519_- Of course, no matter what the permissibe extents for your shop, everyone still must be concerned about extents from the perspective of outages if max extents are reached. When a new application is implemented, it is common that some things have not been sized properly, and some things may be on 10 extents as a result of growing in a few days and you may want to re-size and reduce the extents knowing that in a few weeks you will get a phone call at 2 a.m. if you do not take action now. So it is not just how [...]
3746 147 33_Re: DB2 to RACF: project planning0_22_BILL_GALLAGHER@PHL.COM31_Tue, 22 Feb 2000 11:15:46 -0500456_us-ascii A couple of points:
1) I believe that the tool that Toine is referring to below would be the RACF/DB2 Conversion Utility that is provided on an "as-is" basis, and can be downloaded from ftp.s390.ibm.com. However, it requires RXSQL to run, which is a separately licensed product that is an add-on for REXX/TSO. I do not know how compatable this utility is with the new free REXX/DB2 interface that recently became available for DB2 v5. [...]
3894 157 33_Re: DB2 Disaster Recovery Options13_Adrian Savory24_adrian.savory@ZURICH.COM31_Tue, 22 Feb 2000 15:54:56 +0000401_us-ascii Don,
It get's better than that (or should that be worse!). I take it you're on SAP R/3 4.0 or lower? The HR module alone in release 4.5 has over 7000 tablespaces. Backing up and recovering this many objects is a big headache - we'll be moving to Snapshot soon hopefully. For a 24*7 site I guess the answer has to be hot site (=big bucks) or take the hit on a 24 - 48 hour outage. [...]
4052 203 33_Re: DB2 to RACF: project planning15_Toine Michielse18_vndobtm@US.IBM.COM31_Tue, 22 Feb 2000 17:24:03 +0000532_us-ascii Thought I was pretty clear... 'if RACF is not ABLE to'....
Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS
BILL_GALLAGHER@PHL.COM@RYCI.COM> on 02/22/2000 04:15:46 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 to RACF: project planning [...]
4256 150 41_Re: Secondary extents in DB2 V5 for OS39013_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Tue, 22 Feb 2000 11:27:58 -0500586_us-ascii I always end up confusing myself on this. The standard 'it depends' becomes 'it depends, except Sometimes it Really Depends'. Put up with the ravings of an old man for a few paragraphs . . .
Example: You have a multi-zillion row table in a tablespace that's in (say) 100 extents. The theory: any SQL that accesses lots of rows might perform poorly because of DASD 'head movement'. The reality: If it's going to take you 10 minutes to tablespace-scan the zillion rows, does the (99 head movements) * (.02 seconds) = 2 extra seconds really make that much difference? [...]
4407 180 33_Re: DB2 Disaster Recovery Options22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 22 Feb 2000 15:35:11 +0000703_ISO-8859-1 Ade (Hi)
or multi stream your backups and then multi stream your recoveries at the DR site .. through multi members .. can speed the recovery up bigtime.
Les
______________________________ Reply Separator _________________________________ Subject: Re: DB2 Disaster Recovery Options Author: Adrian Savory at Internet Date: 2/22/00 3:54 PM
Don,
It get's better than that (or should that be worse!). I take it you're on SAP R/3 4.0 or lower? The HR module alone in release 4.5 has over 7000 tablespaces. Backing up and recovering this many objects is a big headache - we'll be moving to Snapshot soon hopefully. [...]
4588 59 41_Re: Secondary extents in DB2 V5 for OS39014_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 22 Feb 2000 12:13:01 -0500581_ISO-8859-1 While extents may not be a 'major" impact as they once were, they are still some impact - that can be avoided. Whether the extent is near or far is much less important since about 90%of the head movement time is starting/stopping the arm. In my opinion, we probably don't care too much, from a time and effort management perspective, about some number of extents. However, when the number gets into the mid-to-upper double digits, or reaches triple digits I think we should care a lot. Part of Roger Miller's response from 2/17 is below and the last paragraph puts [...]
4648 39 49_Trapping SQL Text with Omegamon- Anybody done it?13_Michalik, Ken19_kmichalik@KRAFT.COM31_Tue, 22 Feb 2000 11:23:55 -0600558_- I have been looking into the same opportunity.
Our Omegamon online historical files are large enough to carry a day or so worth activity...you can look at yesterday.
We have ad-hoc query users (10-15 range) that we are trying to improve DB design based on what they do.
Candle would not release the 'DSECT' of the history file, and I could find nothing in their standard reports that could be used to get a report of SQL only by a select user group. They did tell me to use the facility to load the history data into a DB2 table, [...]
4688 76 53_Re: Trapping SQL Text with Omegamon- Anybody done it?15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Tue, 22 Feb 2000 12:35:53 -0500558_iso-8859-1 Not sure if this is what you want or not, but if I'm trying to find a problem query text information, I will turn on the appropriate DB2 performance IFCIDS, ask the application team to work with me on timing the execution of the program and while in Omegamon, I turn on an application trace right prior to them executing the plan with the problem query. I can then review the detail reports from the application trace file produced to view statement numbers of ones doing excessive I/O's or whatever I have felt the problem to be. I can then [...]
4765 17 29_DB2 Utilities in the Linklst?11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Tue, 22 Feb 2000 11:49:16 -0600387_us-ascii Hello DB2 Land!
We have thoughts of putting our DB2 Utilities in the Linklst. Is this a good idea? What are your thoughts?... : )
================================================ 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.
4783 19 22_Dynamic Plan Selection16_Alison Pelletier30_APelletier@MOUNTAINWESTFIN.COM31_Tue, 22 Feb 2000 10:51:17 -0700297_iso-8859-1 We are DB2 for OS/390 V5. I need to convert plans that are defined in RCT as dynamic plan selection to package plans. I have alot of experience in converting DBRM plans to package plans, but really don't know much about dyn. plan sel. Are there any tricky curves to watch out for? [...]
4803 65 33_Re: DB2 Utilities in the Linklst?10_Paul Wendt14_PaulW@ENET.COM31_Tue, 22 Feb 2000 10:02:58 -0800435_us-ascii IMO, it's a very bad idea.
If software were static, and never needed any changes, it *might* not be such a bad idea.
But since software is constantly changing, and new versions are coming out, this is a very good way of causing confusion, and running a different version of software than you think you are running. ...I have seen problems caused by this at several different installations I have worked at. [...]
4869 45 33_Re: DB2 Utilities in the Linklst?12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 22 Feb 2000 10:07:58 PST396_- Jeff,
What part of the utilities are you planning on putting in the linklist?? I think you will find that many environments place the DB2 SDSNLOAD library in the linklist already. If using a 3rd party utility, I would still place the LOADLIBs in the linklist for the production systems. It is easier than changing all of your JCL when your library's names change with new releases. [...]
4915 130 23_Re: Use of Views in DB215_Philip, Sibimon19_PhilipS@SEALAND.COM31_Tue, 22 Feb 2000 13:13:49 -0500569_iso-8859-1 This I prepared long time back for our company. We use select * views for all the tables created and frankly I hate that. Due this, one minute alter table take, two hours to complete. (Good for DBA to make more money!!!!)
Disadvantage. 1. Need to Drop and re-create a view every time we alter the table. 2. Need to grant all the access and rebind all the programs using the view. 3. Create duplicate rows with column names in sysibm.syscolumns. This can be many rows. 4. Create many rows in sysibm.sysviews to keep the definition of the view. 5. [...]
5046 55 27_Re: Your opinion on explain24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 22 Feb 2000 10:15:29 -0800335_- We require EXPLAINS to be done on all DB2 programs, either new of changed. In most cases, the review can be done in just a few minutes. Quite often, though, we find significant potential performance problems. In many cases, this is due to a lack of programmer training, and we use the opportunity to pass along the information. [...]
5102 49 33_Re: DB2 Utilities in the Linklst?17_Hynes, Kenneth J.17_khynes@TRIGON.COM31_Tue, 22 Feb 2000 13:17:18 -0500605_iso-8859-1 We have been running with DB2 Utilities (Including Sample Code DSNTEP2, DSNTIAD) in the LINKLIST for over 10 years without any problems. It simplifies the process from the user perspective and keeps them from running code that is at differing levels. It also gives a "reasonable" guarantee that you are running the latest maintenance levels. While some people prefer to run "Versioned" libraries in order to be sure what is being run I have found that it tends to get somewhat cumbersome in terms of tracking each and every "issue" involved in JCL related problems. If someone wants to go [...]
5152 49 26_Re: Dynamic Plan Selection16_Michael McCarthy18_mmccarthy@DTCC.COM31_Tue, 22 Feb 2000 13:25:07 -0500399_us-ascii Alison,
All you need to do is to make sure that any package executed runs under a tranid that is associated (in the RCT) with a plan containing that package. We work extensively with Dynamic Plan Selection and packages here. Although we are eliminating it by having the programmers use EXEC CICS RETURN TRANSID IMMEDIATE. Let me know if you have any further questions, [...]
5202 75 33_Re: DB2 Utilities in the Linklst?13_John Arbogast16_jfarbo@YAHOO.COM31_Tue, 22 Feb 2000 10:22:16 -0800580_us-ascii Both our DB2 code and our 3rd party tools/utilities are in the linklist. We have an automated procedure that provides an audit trail as well. We steplib when testing new versions.
HTH
--- craig patton wrote: > Jeff, > > What part of the utilities are you planning on > putting in the linklist?? I > think you will find that many environments place the > DB2 SDSNLOAD library in > the linklist already. If using a 3rd party utility, > I would still place the > LOADLIBs in the linklist for the production systems. > It is easier [...]
5278 20 33_Re: DB2 Utilities in the Linklst?11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Tue, 22 Feb 2000 12:27:53 -0600470_us-ascii This is more correct! Hello DB2 Land!
We have thoughts of putting our DB2 Utilities in the Linklst. ie. DSNTIAUL , DSNTEP2... Is this a good idea? What are your thoughts?... : )
P.S. Thanks for your input!
================================================ 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.
5299 38 26_Mismatch Column Attributes10_Greg Jonas17_g_jonas@YAHOO.COM31_Tue, 22 Feb 2000 10:20:37 -0800301_us-ascii
We have a strange scenario here. I have a user selecting from 2 tables. Table 1 has a column which is CHAR(4) (we'll call this COL_A). Table 2 has a column which is CHAR(6) (we'll call this COL_B), but only the first 4 positions are filled (except for 1 row out of over 50,000). [...]
5338 64 27_Re: Your opinion on explain12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 22 Feb 2000 21:44:54 +0200423_x-user-defined Hi,
The algorithm is clear: 1. Get DBA approval (Explain + source follow up (for those @#$ loops)). 2. Move to prod. 3. Follow performance on prod for a few days. We use Candle's Explain extensively.
P.S - The bypass of forcing a move to prod via upper management is done from time to time but then we are really happy when the ... hits the fan. It stops the bypass route for a long time. [...]
5403 38 33_Re: DB2 Utilities in the Linklst?12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 22 Feb 2000 22:05:42 +0200538_x-user-defined Hi, LINKLIST it is. New things are with steplib till approved and then go to linklist.
Isaac Yassin
Jeff Faughn wrote: > > Hello DB2 Land! > > We have thoughts of putting our DB2 Utilities in the Linklst. > Is this a good idea? > What are your thoughts?... : ) > > ================================================ > 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.
5442 25 11_Julian date19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 22 Feb 2000 14:14:12 -0600583_iso-8859-1 Hi all and TIA, Thought I saw this in the archives but couldn't find it. How do you get Julian day of year (i.e. 053) from TIMESTAMP, or DATE?
Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from [...]
5468 176 27_Re: Your opinion on explain16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Tue, 22 Feb 2000 15:19:07 -0500354_- Unfortunately, while I agree with your opinion, we, too, do not have SQL reviewed prior to going into production. We have standards and QA requirements in place to require it, but all standards are overridable by management ------ and in most cases they are overridden because "we don't have time". Sometimes we get lucky, and sometimes we don't. [...]
5645 82 27_Re: Your opinion on explain17_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM31_Tue, 22 Feb 2000 15:24:51 -0500428_x-user-defined The other day somebody said that I was in paradise because I had a little extra CPU to throw at OLTP spikes - that's minor.
Non-pointy-haired management - now that's paradise.
Craig Snoeyenbos As always, personal opinions only and may contain humorous items not neccessarily related to current circumstances
-----Original Message----- From: Isaac Yassin [mailto:yassin@NETVISION.NET.IL] [...]
5728 52 30_Re: Mismatch Column Attributes19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 22 Feb 2000 14:40:04 -0600620_iso-8859-1 Greg, You're going to have to give us the two statements. Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
5781 209 27_Re: Your opinion on explain10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Tue, 22 Feb 2000 12:43:08 -0800474_us-ascii Andrea,
I don't know what you mean by PeopleSoft "does not allow us the opportunity to change the SQL"
We have changed PeopleSoft SQL statements both in batch jobs and online to tune a process. In addition to these "fixed" SQL statements, PeopleSoft also uses C++ to generate SQL statements out of thin air, so to speak. We have not been able to change these kind of SQL statements. Are the generated SQL statements the ones you're referring to? [...]
5991 105 30_Re: Mismatch Column Attributes10_Greg Jonas17_g_jonas@YAHOO.COM31_Tue, 22 Feb 2000 13:02:58 -0800565_us-ascii
Okay, here is the select statements that I was referring to:
SELECT S1.REGION_NO ,S1.SECTION_NO ,S1.TEAM_NO ,S1.MEMBER_ID ,S1.OFFICE_ID AS LW153_OFFICE ,S2.OFFICE_ID AS LW154_OFFICE FROM LW153 AS S1, LW154 AS S2 WHERE S1.MEMBER_ID = S2.REPAIR_ID AND S1.OFFICE_ID <> S2.OFFICE_ID WITH UR;
SELECT S1.REGION_NO ,S1.SECTION_NO ,S1.TEAM_NO ,S1.MEMBER_ID ,S2.REPAIR_ID ,S1.OFFICE_ID AS LW153_OFFICE ,S2.OFFICE_ID AS LW154_OFFICE FROM LW153 AS S1, LW154 AS S2 WHERE S1.MEMBER_ID = S2.REPAIR_ID AND S1.OFFICE_ID <> S2.OFFICE_ID WITH UR; [...]
6097 86 30_Re: Mismatch Column Attributes15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Tue, 22 Feb 2000 16:19:23 -0500551_us-ascii Just a SWAG(silly wild assumed guess). If you do an explain on both versions of the query does the access path change,i.e., possible tablespace scan on table 2 with nested loop join with table 1 when referencing COLB in result set which changes to ts scan on table 1 with nested loop join on table 2 when referencing both COLA and COLB in result set. It could be you have an index on table 1 which is may be incomplete(possibly due to a failed load where the index was not rebuilt or tablespace recovered but the index was not recovered [...]
6184 90 27_Re: Your opinion on explain18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Tue, 22 Feb 2000 15:26:57 -0500453_iso-8859-1 Andrea: I agree with you on this too. While there are probably 'standards' alot of times they are bypassed because of time constraints. We just installed an application called INDUS and I can see where this is going to turn into a 'tuning career' for someone. Since we too cannot make 'changes' to SQL its up to us (DBA's) to make this thing run more efficiently by some other method. Oh well, such is life in the DB2/DBA fast-lane. :-) [...]
6275 253 30_Re: Mismatch Column Attributes0_19_Tim.Lowe@STPAUL.COM31_Tue, 22 Feb 2000 15:29:39 -0600538_us-ascii Greg, What DB2 release are you running? There are some PTFs that might be a match for your problem. Are you using parallelism? If so, take a look at PTF UQ35934 / APAR PQ31123. It would appear to be a match to your problem. Or, perhaps UQ29792 / PQ26719 ? Unless there is a problem with your tablespace or index (run check index?), this would appear to be a maintenance problem to me. If you are current on maintenance, then you should contact IBM and report the problem. If not, then you should get as current as possible. [...]
6529 62 33_Re: DB2 Utilities in the Linklst?0_23_Mike_Levine@TEKHELP.NET31_Tue, 22 Feb 2000 16:45:06 -0500439_us-ascii Hi,
I think it would be a different story in a data sharing environment where you run test and production subsystems on the same LPAR or if you wanted to be able to move workloads around without JCL changes. LNKLST to a certain degree ties a workload to a particular LPAR. However, I've been in shops where STEPLIB/JOBLIB statements were not permitted in production jobs and also the other way around. They both work! [...]
6592 456 24_Re: Opinons and comments16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Tue, 22 Feb 2000 16:49:22 -0500510_iso-8859-1 We haven't had to recover test much and those I have have run in much less time than that. I have done considerable work at splitting my original delivered PS stuff into many more databases and tablespaces for performance. I have 32 databases with 118 tablespaces as opposed to the original 5 databases with 37 tablespaces. That may have helped some. I have to admit that in the 5 years I've been a PeopleSoft DBA I have not had to do very many recoveries, but those I did didn't take 8 hours. [...]
7049 298 27_Re: Your opinion on explain16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Tue, 22 Feb 2000 17:14:08 -0500373_- Bad statement -- sorta. Management here does not allow us to change delivered peoplesoft stuff i.e. the statements in PS_SQLSTMT_TBL and PS_AE_STMT_TBL, since that would be considered a customization. Usually, we can get Peoplesoft to fix them. Now if it is something we have added -- a bolt on to the app or a new batch process ----- that is free game for tuning!! [...]
7348 72 27_SV: SV: CSP V3.3 and DB2 V511_Arne Nilsen18_Arne.Nilsen@SDS.NO31_Tue, 22 Feb 2000 23:23:35 +0100386_- It was 2 major reasons for migrating from CSP to VAG:
Y2K-requirement and reduced CPU-cost (COBOL loadmodules was estimated to reduce CPU-cost with 25%-30% - and the migration har proved it!).
Arne Nilsen
Posten SDS AS Nydalsvn 28, Postboks 4364 Torshov, 0402 Oslo Telefon 23 14 50 00, telefaks 23 14 50 01 Direkte tlf.nr. 23 14 46 47 URL: http://www.sds.no [...]
7421 64 15_Re: Julian date0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 22 Feb 2000 16:36:25 -0600412_us-ascii I couldn't find anything explicitly about julian day in my notes, but a few days ago someone posted about the Fillmore Group DB2 SQL Expander Functions (UDF) at the website listed below. One of the the functions allows you to convert dates using a mask. Also a short while ago there was a post and discussion about new custom date formats in V6, I'm willing to bet that Julian day is in there too. [...]
7486 54 41_Re: Secondary extents in DB2 V5 for OS39015_Michael McGuire32_Michael.McGuire@COLESMYER.COM.AU31_Wed, 23 Feb 2000 09:49:09 +1100308_iso-8859-1 We used to have a similar rule about keeping extents below 20. But we replaced all our reorg jobs with IBM's online reorg (no more 2:00 AM calls!). Unless you have heaps of space, a large primary allocation cannot be duplicated when the "shadow" dataset is allocated during the online reorg. [...]
7541 21 67_More examples of using REXX code ( REXX-DB2 interface on OS/390 ) ?14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Tue, 22 Feb 2000 15:04:08 -0800416_us-ascii I would appreciate hearing of publications or, prefereably, gratis working source I can read and maybe use. IBM provides a 'REXX Language Support' document which is basically useful. I'd just like to see a few more practical examples of A. Simple cursor declaration and fetches. B. Complex varying-list arguments using the SQLDA. There is discussion of concepts in the Applic Prog & SQL Guide. TIA Roy [...]
7563 50 25_Security Policy Documents8_Gary Rue25_Gary.Rue@MAIL.STATE.KY.US31_Tue, 22 Feb 2000 18:03:21 -0500623_iso-8859-1 > We recently had an integrator install a financial application (non-OS/390 > application). We are finding things like passwords hardcoded in batch > jobs, and other freighting gaps in security. Unfortunately, I was just as > amazed to find our security policy (originally written in 1992) is more > concerned with how to get ID badges and into buildings than protecting > data. > > I would certainly appreciate seeing any generic company security policies, > specifically on how applications should be written and executed to provide > the most effective data security and integrity. Even though we have a [...]
7614 46 15_Re: Julian date14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 23 Feb 2000 10:52:26 +1000537_- DAYS(timestamp) - DAYS(SUBSTR(CHAR(timestamp,ISO),1,4)||'-01-01') + 1
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au
-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Wednesday, February 23, 2000 6:14 AM To: DB2-L@RYCI.COM Subject: Julian date
Hi all and TIA, Thought I saw this in the archives but couldn't find it. How do you get Julian day of year (i.e. 053) from TIMESTAMP, or DATE? [...]
7661 49 27_Re: Your opinion on explain13_Marcel Lepage13_iml@COLBA.NET31_Tue, 22 Feb 2000 22:51:32 -0700371_iso-8859-1 Hi Randall,
Yes, someone must be involved in explain analysis of every SQL calls the will be implemented in production. That should be a normal step to complete within the implementation plan.
Also, I recommand to use the parameter EXPLAIN(YES) when a bind is done in the production environment.
Marcel Lepage DBSYS Technologies Inc. [...]
7711 92 29_DB2 to RACF: project planning14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 23 Feb 2000 15:14:45 +1000546_- If you really wanted to check DB2's AUTH tables if RACF failed the request, you could alter the code: *---------------------------------------------------------------------- * Audit FASTAUTH failures *---------------------------------------------------------------------- LA R4,RC_FAIL CLR RTN_CODE,R4 Was accessed denied? BNE NOFAIL Access was not denied, skip audit TM FLAGS,AUDIT_SAVED Was a resource saved? @02A BNO NOFAIL No, skip audit @02A BAL R14,FASTAUTH_AUDIT Audit FASTAUTH failure NOFAIL DS 0H ELSE access was not denied (NOP) [...]
7804 49 23_Re: Use of Views in DB214_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 23 Feb 2000 08:49:42 +0100306_us-ascii I agree the use of SELECT * FROM is a big error, in my opinion (not only however....). In change
management it's to avoid like peast. We do not use this statement in any query and in my
experience it is used only by young programmers (at the beginning) or consulting people who [...]
7854 101 33_SV: DB2 Utilities in the Linklst?12_Nurmi, Seppo23_Seppo.Nurmi@RIKSBANK.SE31_Wed, 23 Feb 2000 08:59:23 +0100470_iso-8859-1 We have them in linklist in our production system, but not in the developement system where we steplib them. We think this is a good choice because we seldom change the production libraries, that is, we keep not solving problems that we do not have. Of course we do preventive service a couple of times per year, and then we also plan in an IPL. I think we have a good clue of which fix level is running. Seppo Nurmi Sveriges Riksbank, Stockholm, Sweden [...]
7956 228 12_Re: DSNV086E17_suthep thampranee18_suthepth@SCB.CO.TH31_Wed, 23 Feb 2000 15:26:20 +0700593_Windows-874 Dear all Thank you for your help.I think that could be the reason
"2. An execution unit holds a latch"
Because about 50% of TS in my LPAR use locksize row.
TIA JOE ---------- > From: DAVIS, RICK (SBCSI) > To: DB2-L@RYCI.COM > Subject: Re: DSNV086E > Date: 22 ¡ØÁÀҾѹ¸ì 2543 19:36 > > Lourdes Kishi, > Explanation below. > > 00E50705 > > Explanation: A subsystem termination was requested for one of the following > reasons: > > 1. An agent was flagged as executing in 'must complete' mode, > 2. An execution unit holds a latch, > [...]
8185 50 33_SV: DB2 Utilities in the Linklst?12_Nurmi, Seppo23_Seppo.Nurmi@RIKSBANK.SE31_Wed, 23 Feb 2000 09:18:52 +0100439_iso-8859-1 To be even more correct DSNTIAUL and DSNTEP2 are not utilities, they are saple programs, so IBM tells me. DSNUTILB is the most used utility program. IMHO, it is a good idea to have them all in linklist, mainly because then you know what version people use in they batch jobs. Tell them not to use steplib, and delete or make inaccessible all old versions of load libraries. Seppo Nurmi Sveriges Riksbank, Stockholm, Sweden [...]
8236 30 34_DB2 LOAD and UR (uncommitted read)14_Per Callerstal22_per.callerstal@MIPS.SE31_Wed, 23 Feb 2000 03:23:09 -0600544_- I have read and searched thru a number of mails and manuals but not yet clear on how the load utility and UR interact lockingwise. We have the following situation: 1. The customer wants 24 * 7 availability (well almost) and can accept uncommitted read access. 2. The problem is that some tablespaces have to be updated a couple of times / week. As updates amount to 10 - 20 mill rows at a time, rows are loaded into an "empty" partition via "LOAD DATA INDDN SYSREC00 LOG NO RESUME YES INTO TABLE xxxx PART nn REPLACE .... 3. Tablespaces [...]
8267 71 38_Re: DB2 LOAD and UR (uncommitted read)15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 23 Feb 2000 11:12:02 +0000348_us-ascii Hello
Yes, this will work. As long as you don't touch the index logical partition and/or the partition being loaded (LOAD PART will drain all classes on the LP and PP). Beware that this means that some access paths would not work. The obvious...a tablespace scan will at some point touch the physical partition being loaded... [...]
8339 48 25_Re: DDF - VTAM definition9_SrinivasG17_SRINIVASG@INF.COM31_Wed, 23 Feb 2000 16:09:20 +0530427_iso-8859-1 If you are not in sysplex, Please remove GenericLU from DSNZPARM.
-----Original Message----- From: Robert Niemiec [mailto:rniemiec@KRAKOW.TPSA.PL] Sent: Tuesday, February 22, 2000 3:34 PM To: DB2-L@RYCI.COM Subject: DDF - VTAM definition
I would like to make DB2/os390 acting as AS. I made the definition as described in Installation Guide. When I start DDF, I get the following messages: [...]
8388 33 46_DB2 UDB V5.2 (AIX), VB6 and ADO 2.1 (CLI0150E)13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Wed, 23 Feb 2000 11:20:49 +0000339_us-ascii Our developers are attempting to access DB2 UDB on AIX V5.2 FP6 from VB6 using ADO. Up until now they've used RDO without problems.
When accessing any DECIMAL fields (in our case they've tried DEC(12,0) and DEC(11,2). they get the following message -
DIAG [S1C00] [IBM] [CLI Driver] CLI0150E Driver not capable [...]
8422 111 15_Re: Julian date19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 23 Feb 2000 07:01:44 -0600446_iso-8859-1 James, Thank you very much for reply. I've tried your solution and can't see why it won't work. Get following error msg:
SELECT * FROM DBA3CBD1.NID_TABLE 00000104 ; 00000204 NID_INTEGER NID_FLOAT NID_DECIMAL TS ---------+---------+---------+---------+---------+---------+--- +0.0 E+00 222. 2000-02-09-06.31.28.179683 DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100 [...]
8534 150 15_Re: Julian date15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 23 Feb 2000 14:07:55 +0000504_us-ascii Hello,
Seems to me the CHAR function should be the DATE function.
Regards,
Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS
"DAVIS, RICK (SBCSI)" @RYCI.COM> on 02/23/2000 01:01:44 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
8685 182 15_Re: Julian date19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 23 Feb 2000 07:22:52 -0600643_iso-8859-1 Toine, Thanks very much. DAYS(TS) - DAYS(SUBSTR(DATE(TS,ISO),1,4)||'-01-01') + 1 Hmmmm, still get: SQLCODE = -170, ERROR: THE NUMBER OF ARGUMENTS SPECIFIED FOR DATE IS INVALID
Jeez, Still Stumped, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. [...]
8868 25 13_IDUG vs. Tech11_Danny Davis16_DTDAVIS@PCMH.COM31_Wed, 23 Feb 2000 08:29:07 -0500561_US-ASCII I know this question gets asked every year, but which conference is better IDUG or the DB2 Technical conference? I've never been to either and I can only go to one this year. I've seen the itinerary for IDUG and it looks pretty good. I especially like the ERP classes as we have PeopleSoft. I haven't been able to find much on the Tech conference. What are people's thoughts in general and does anyone have detail on what will be offered at the Tech conference. I believe the Tech conference has the better location for what that's worth. TIA for [...]
8894 19 22_time out in fetch sqls8_madhavan16_madhavan@INF.COM31_Wed, 23 Feb 2000 19:06:46 +0530416_- Hi,
Will we get -911 in fetch statements? Or it can happen only in open cursor statements? (sorry for asking a basic question in the forum).
regards Madhavan.
================================================ 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.
8914 40 26_Re: time out in fetch sqls15_Rene Hendriksen16_reh@NOTES.BEC.DK31_Wed, 23 Feb 2000 14:32:47 +0100478_us-ascii Yes !
madhavan on 23-02-2000 14:36:46
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Rene Hendriksen/reh/usr/becint) Subject: time out in fetch sqls
Hi,
Will we get -911 in fetch statements? Or it can happen only in open cursor statements? (sorry for asking a basic question in the forum).
regards Madhavan. [...]
8955 43 17_Re: IDUG vs. Tech11_Hilton Tina15_HiltonT@TCE.COM31_Wed, 23 Feb 2000 08:34:03 -0500303_iso-8859-1 I haven't been to IDUG, so I can't compare the technical aspects of it vs. the DB2 Tech conference. However, if you will be needing other training and have an IBM education card then the DB2 Tech conference will be covered by that and won't cost you anything other than travel & living. [...]
8999 160 15_Re: Julian date15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 23 Feb 2000 14:29:25 +0000530_us-ascii Rick,
Ignore my previous append.. It should be the CHAR function....
Sorry about the confusion.....
If the second argument is a TIMESTAMP (such as in your case) then the second operand (ISO) does not apply). Since no local date/time exits sedem to screw up your results just use CHAR(TS)......
Regards,
Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...]
9160 44 17_Re: IDUG vs. Tech13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 23 Feb 2000 08:44:44 -0500341_us-ascii Well, many of the contributors to this list are going to be speaking at IDUG so I guess that speaks volumes about the quality of the presentations at IDUG :-)
I've been to IDUG twice (and I'm hoping to go this year too!). They are fabulous, very intense. I've never been to the Tech Conference so I can't compare the 2. [...]
9205 79 26_Re: time out in fetch sqls15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 23 Feb 2000 14:44:02 +0000408_us-ascii Hello Madhaven,
It depends when the query result set is materialized. For some queries, DB2 will have to materialize the entire result at OPEN CURSOR time. A good example is queries that require a sort (check access path). In this case the -9xx could occur during OPEN CURSOR.
If the result set does not have to be 'materialized' at OPEN then the -9xx can come during fetch time. [...]
9285 88 41_Re: Secondary extents in DB2 V5 for OS39012_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 23 Feb 2000 05:48:14 PST569_- Brendon,
Are you perhaps usin one of the 'RAID' technology DASD devices?? Due to the 'Caching' method of storing data in these devices, I understand that secondary extents do NOT degrade performance as much as when using the older '3390' style devices. Thus, I too, have been told that more extents are acceptable (one IBMer stated that they aren't an issue until you run out at the 118/123 or 255 extent limit) A ceiling of 20 extents, using RAID type dasd (ok IBM SHARK too), seems to be actually reasonable. Myself, I STILL try to keep all data in the [...]
9374 86 41_Re: Secondary extents in DB2 V5 for OS39013_John Arbogast16_jfarbo@YAHOO.COM31_Wed, 23 Feb 2000 05:49:08 -0800640_us-ascii Where do you create the mapping tables needed? In their own TS or in a common mapping TS? Are the shadow DS allocated by reorg or are they preallocated?
TIA
--- Michael McGuire wrote: > We used to have a similar rule about keeping extents > below 20. But we > replaced all our reorg jobs with IBM's online reorg > (no more 2:00 AM > calls!). Unless you have heaps of space, a large > primary allocation cannot > be duplicated when the "shadow" dataset is allocated > during the online > reorg. > > Michael > ____________________________________________________________________ [...]
9461 63 15_Re: Julian date11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 23 Feb 2000 08:51:41 -0500447_iso-8859-1 Thanks James...
In DB2 for OS/390 the input to the CHAR must be a date so here is a slight modification if the input is timestamp...
SELECT DAYS(CURRENT_TIMESTAMP) - DAYS(SUBSTR( CHAR(DATE(CURRENT_TIMESTAMP),ISO),1,4)||'-01-01') + 1 FROM SYSIBM.SYSDUMMY1 ;
-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Tuesday, February 22, 2000 7:52 PM Subject: Re: Julian date [...]
9525 11 17_Re: IDUG vs. Tech10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Wed, 23 Feb 2000 09:21:04 -0500512_- I have been to both and for pure technical information from the source the tech conference is the way to go. At IDUG a lot of the DB2 developers are there giving the same presentations, but the overall quality of "all" sessions is better at the tech conference. When I attend IDUG I usually stay clear of user presentations. In a lot of cases the first 15 minutes of the user presentations are spent explaining that "my dog is bigger than your dog". On another note, the IDUG after hours stuff is better. [...]
9537 184 15_Re: Julian date13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Wed, 23 Feb 2000 14:19:00 -0000619_iso-8859-1 OK Chaps
SELECT DAYS(CURRENT_TIMESTAMP) - DAYS(SUBSTR(CHAR(CURRENT_DATE,ISO),1,4)||'-01-01') + 1 FROM TABLEX
gives 54
Ian McDonald DB2 DBA Abbey National ---------- From: Toine Michielse To: DB2-L@RYCI.COM Subject: Re: Julian date Date: 23 February 2000 14:29
Rick,
Ignore my previous append.. It should be the CHAR function....
Sorry about the confusion.....
If the second argument is a TIMESTAMP (such as in your case) then the second operand (ISO) does not apply). Since no local date/time exits sedem to screw up your results just use CHAR(TS)...... [...]
9722 32 38_Re: DB2 LOAD and UR (uncommitted read)11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 23 Feb 2000 09:23:49 -0500658_ISO-8859-1 Re the comment on tablespace scan: this is true unless Limited Partition Scan enables the partition to be skipped.
Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner
Message text written by DB2 Data Base Discussion List >Hello
Yes, this will work. As long as you don't touch the index logical partition and/or the partition being loaded (LOAD PART will drain all classes on the LP and PP). Beware that this means that some access paths would not work. The obvious...a tablespace scan will at some point touch the physical partition being loaded... [...]
9755 61 38_Re: DB2 LOAD and UR (uncommitted read)11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 23 Feb 2000 09:23:51 -0500572_ISO-8859-1 Per
I suggest a change to your LOAD control cards as follows:
LOAD DATA INDDN SYSREC00 LOG NO INTO TABLE xxxx PART nn REPLACE ....
I have omitted the RESUME YES. Your form will cause the Load to block access to all partitions because it it a Load Resume of all partitions except partition nn and a Load Replace of partition nn. My form will allow read and update access to all partitions except partition nn (which will of course be blocked), because it is a Load Replace of partition nn with no Load activity on the other partitions. [...]
9817 269 29_Re: Security Policy Documents16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Wed, 23 Feb 2000 09:30:46 -0500422_iso-8859-1 We have some pretty strict guidelines -- thought finding a written form is not really easy for me. All developers have READ ONLY access to all data unless it is deemed too sensitive -- i.e. payroll/personal data and employee health claims. Any update access is granted through our security division at the individual level. This clearence must have management approval and must include an expiration date. [...]
10087 20 29_Re: Security Policy Documents10_Ken Koleto23_kkoleto@PAINEWEBBER.COM31_Wed, 23 Feb 2000 09:38:32 -0500584_iso-8859-1 Gary,
In another life I worked with some data security. Try this link: http://www.gocsi.com/ This will point you to the Computer Security Institute. I attended one of their programs and found it very helpful. You might be able to get some 'boiler plate' security policies from them.
HTH, Ken
'my opinions only'
================================================ 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.
10108 52 17_Re: IDUG vs. Tech12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 23 Feb 2000 06:50:34 -0800385_us-ascii I went to both last year. In my opinion, its one of those "it depends" decision. If you want or need to learn about other user's experiences, see vendor presentations, and experience better "night life" etc., then IDUG is better. If you are just interested in the pure technical details and technical education/training, then the Tech conference is significantly better. [...]
10161 38 17_DB2 DASD ACTIVITY12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 23 Feb 2000 06:59:03 PST404_- Hi folks:
I want to know , if exist any rule of thumb to use when you are reading a RMF DASD REPORT and you need to detect what db2 volumes has bad response times. I know that it rely on some cases in the distribution of the db2 tablespaces and indexes but I would like to hear your advises. Here below you can see a piece of RMF DASD REPORT taken over some db2 volumes. Thanks in advances [...]
10200 60 38_Re: DB2 LOAD and UR (uncommitted read)15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 23 Feb 2000 16:04:40 +0000550_us-ascii In which case it's no longer a tablespace scan....
Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS
Mike Turner @RYCI.COM> on 02/23/2000 02:23:49 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 LOAD and UR (uncommitted read) [...]
10261 54 21_Re: DB2 DASD ACTIVITY14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 23 Feb 2000 16:35:58 +0100331_us-ascii AAARRRRGGGHHH (first comment).
Is a snapshot value or a medium value (based on a meaningful interval ) ? Is it a RAID DASD or
something else ? How busy are channels ? What kind of activity is running on your host ?
Your volume DB2SYST (DB2SYSP too) is experimenting an heavy IOSQ time with a low [...]
10316 73 21_Re: DB2 DASD ACTIVITY14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 23 Feb 2000 10:46:11 -0500378_ISO-8859-1 Every volume > 16 Ms has a response problem, so this is everything except DBP519. DBS405 is a performance disaster, and DBP409 & DBS005 are horrendous. DBS405 & DBS005 is probably caused by dataset placement. DBP409 not enough info to guess at problem - need to look at Pend & Disc times. Sorry to be so blunt, but your dasd subsystem is performing very poorly. [...]
10390 34 38_Re: DB2 LOAD and UR (uncommitted read)11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 23 Feb 2000 10:50:21 -0500417_ISO-8859-1 Tim
I do not think this is affected by LOCKPART. Sure, the SQL will take intent locks on the tablespace and turbo-lock the last partition (logically intent locking all partitions) with LOCKPART NO. Locks do not conflict with the Drain activity of the utility. Only a Claim by SQL on the same partition would cause problems and that only happens if the SQL actually tries to read the partition. [...]
10425 28 38_Re: DB2 LOAD and UR (uncommitted read)11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 23 Feb 2000 10:54:55 -0500448_ISO-8859-1 Toine
By my definition it is still a tablespace scan - i.e. ACCESSTYPE = R, just that PAGE_RANGE is now Y. Are you guys in the lab now using a different name for this type of scan?
Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner
Message text written by DB2 Data Base Discussion List >In which case it's no longer a tablespace scan.... [...]
10454 34 42_Re: IDUG vs. Tech - a matter of preference14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 23 Feb 2000 11:02:58 -0500588_ISO-8859-1 I really don't think it's a case of which is better, it's more a case of personal preference. A large number of the IBM presentations are at both conferences, so it's simply a case of getting the information in May or waiting until October. The Tech conference has every presentation at least twice, and some three times. IDUG has fewer repeats, and more total presentations to choose from. IDUG is less expensive. The conferences are about the same in size, with both well over 2000 attendees. IDUG has had, so far, a much larger representation from vendors, so you have [...]
10489 64 38_Re: DB2 LOAD and UR (uncommitted read)15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 23 Feb 2000 17:16:07 +0000460_us-ascii Mike,
My opinion and mine alone...but i like to think of a table space scan means scan everything in the tablespace.. Limited partition scan is not the same in my mind. BUt you are absolutely right, they are both represented by accesstype = 'r'.
Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...]
10554 36 38_Re: DB2 LOAD and UR (uncommitted read)11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 23 Feb 2000 11:38:10 -0500518_ISO-8859-1 Toine
Fair enough. Just a matter of terminology.
Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner
Message text written by DB2 Data Base Discussion List >Mike,
My opinion and mine alone...but i like to think of a table space scan means scan everything in the tablespace.. Limited partition scan is not the same in my mind. BUt you are absolutely right, they are both represented by accesstype = 'r'. [...]
10591 26 26_Re: extent numbers and SMS0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 23 Feb 2000 11:24:24 -0600598_us-ascii One thing to consider in managing the number of extents is that the time and effort required to reorganize all tables that exceed a certain number of extents can be completely automated. (depending on what you can use for your scheduling system and your automated tools for DB2).
By using the DCOLLECT IDCAMS command, it is very simple to extract the size and extent information of your DB2 DASD farm. Once this is done, this information can be loaded into a DB2 table. You now have a source of information both for triggering reorganizations and for resetting your PRIQTY and [...]
10618 85 42_Re: IDUG vs. Tech - a matter of preference12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Wed, 23 Feb 2000 11:36:34 -0600557_iso-8859-1 I promised myself I was not going to do this but...
I do find the two conferences to be different both in who attends and in what or how things are said.
IDUG is the more established and seems to have people who are concerned about design and development. The Technical Conference is more for people whose "feet are to the fire." At IDUG more people network and find out what each other is doing. At the Technical Conference there is more "tire kicking." Of course, this not mean that people with different interests attended. [...]
10704 37 34_Move DB2 OS/390 Data to AIX/R/60000_14_mtdage@ATT.NET31_Wed, 23 Feb 2000 17:34:25 +0000381_- Objective: To access Internet database info in a 24*7 environment.
Recommendation: (will be done in 2 parts) a) Move DB2 databases from OS/390 to AIX/R6000 environment running DB2 Universal Data Base (UDB) EE version.
b) Implement data propagation solution to keep the data synchronized with DB2 OS/390 using BMC Enterprise Data Propagation software solution. [...]
10742 83 17_DB2 DASD ACTIVITY12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 23 Feb 2000 09:38:28 PST295_- Hi Again:
I forgot mention that here in our shop almost all DASD devices that we have are Hitachi 7600 (pretty old tecnology) and now we are evaluating to changes all these volumes for Hitachi 7700-E. That is the reason why you can see a pretty bad response time on those volumes. [...]
10826 119 21_Re: DB2 DASD ACTIVITY12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 23 Feb 2000 09:51:37 -0800603_us-ascii Even with Hitachi 7600s you should have significantly better response times than the numbers you've shown. You have other problems that should be addressed. Changing DASD types won't alleviate some of the fundamental placement problems, unless as you change, you move datasets around.
--- HARBRY ARIZA wrote: > Hi Again: > > I forgot mention that here in our shop > almost all DASD devices that > we have are Hitachi 7600 (pretty old tecnology) and > now we are evaluating > to changes all these volumes for Hitachi 7700-E. > That is the reason why you > can [...]
10946 27 21_Re: DB2 DASD ACTIVITY0_19_Tim.Lowe@STPAUL.COM31_Wed, 23 Feb 2000 12:07:53 -0600379_us-ascii When I see problems with dasd I/O, I wonder if there are any underlying problems that are not dasd-related.
What are your bufferpools like? (Could the bufferpools be so small that this is causing a lot of redundant I/O?) What kind of activity does your system have? (Could there be some very large tablespace scans that are causing poor buffer utilization?) [...]
10974 27 34_MEMBER CLUSTER and 00C200C3 abend.20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 23 Feb 2000 14:26:53 -0500398_us-ascii Dear List
I am trying to implement MEMBER CLUSTER option for one of my tablespace. While I am testing this option, I encountered strange error.
When I insert few rows say 100 inserts then insert goes through. When I try to insert many rows in one unit of work (lets say 300 inserts) then my job (which is running the program to insert) abends with reason code 00C200C3. [...]
11002 13 24_Re: Foreign Key creation12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Wed, 23 Feb 2000 14:40:40 -0500339_iso-8859-1 Would anyone out there know how to create foreign keys using the BMC Software product?
================================================ 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.
11016 43 38_Re: MEMBER CLUSTER and 00C200C3 abend.13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 23 Feb 2000 13:43:39 -0600372_US-ASCII Hello Verkat, Take a look at PQ30637. With the limited information provided this was the only one I found. Regards, Kurt
>>> "Pillay, Venkat (PCA)" 02/23/00 01:26PM >>> Dear List
I am trying to implement MEMBER CLUSTER option for one of my tablespace. While I am testing this option, I encountered strange error. [...]
11060 13 33_Limit DB2 CPU a threads use. How?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Wed, 23 Feb 2000 13:42:01 -0600425_- what are the options to limit a DB2 thread for CPU usage. We are currently using the RLF, but that is by SQL statement. Is there a way to limt a thread to a CPU second limit? Thanks
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11074 60 38_Re: MEMBER CLUSTER and 00C200C3 abend.20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 23 Feb 2000 14:54:19 -0500628_us-ascii PQ30637 seems to be for the work-file. But I have this problem only when MEMBER CLUSTER option is used.
The tablespace is created with NUMPARTS 2 .... MEMBER CLUSTER.
The program which inserts in to this table, abends with 00C200C3.
> -----Original Message----- > From: Kurt Sahlberg [SMTP:Kurt.Sahlberg@EXPERIAN.COM] > Sent: Wednesday, February 23, 2000 2:44 PM > To: DB2-L@RYCI.COM > Subject: Re: MEMBER CLUSTER and 00C200C3 abend. > > Hello Verkat, > Take a look at PQ30637. > With the limited information provided this was the only one I found. > Regards, > Kurt > > > >>> "Pillay, Venkat [...]
11135 49 24_Re: Foreign Key creation0_33_Patrick.McManus@MUTUALOFOMAHA.COM31_Wed, 23 Feb 2000 14:00:08 -0600605_us-ascii In BMC Catalog Manager you can list the table then type 'create foreignkey' in the command column.
|--------+-----------------------> | | "Kalman, | | | Jeff" | | | | | | | | | 02/23/2000 | | | 01:40 PM | | | Please | | | respond to | | | DB2 Data Base| | | Discussion | | | List | | | | |--------+-----------------------> >--------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: Patrick McManus/MutualOMA) | | Subject: Re: Foreign Key creation | >--------------------------------------------------------| [...]
11185 79 38_Re: DB2 LOAD and UR (uncommitted read)39_=?ISO-8859-1?Q?=22Per_Callerst=E5l=22?=22_per.callerstal@MIPS.SE31_Wed, 23 Feb 2000 21:04:51 +0100376_ISO-8859-1 Mike
Yes, we actually did some testing today and as you say removing the RESUME YES parameter worked out and we could access the data on-line. The on-line transactions are random reads and no TS scans.
Thank Y'all for your help.
Regards / Per
*********** REPLY SEPARATOR ***********
On 2000-02-23 at 09:23 Mike Turner wrote: [...]
11265 113 15_Re: Julian date19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 23 Feb 2000 14:52:19 -0600743_iso-8859-1 Lee, James, That nailed it down, many thanks ;~).
SELECT * FROM DBA3CBD1.NID_TABLE 00000104 ; 00000204 ---------+---------+---------+---------+---------+---------+---------+------ --- NID_INTEGER NID_FLOAT NID_DECIMAL TS ---------+---------+---------+---------+---------+---------+---------+------ --- 0 +0.0 E+00 222. 2000-02-09-06.31.28.179683 DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---------+------ --- SELECT 00001000 DAYS(CURRENT_TIMESTAMP) - 00002008 DAYS(SUBSTR( 00003008 CHAR(DATE(CURRENT_TIMESTAMP),ISO),1,4)||'-01-01') + 1 00004008 FROM DBA3CBD1.NID_TABLE 00020005 ; 00030005 [...]
11379 139 15_FW: Julian date19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 23 Feb 2000 15:03:28 -0600674_iso-8859-1 OOPS, that should be:
DAYS(TS) - DAYS(SUBSTR(
CHAR(DATE(CURRENT_TIMESTAMP),ISO),1,4)||'-01-01') + 1
Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
11519 31 37_Re: Limit DB2 CPU a threads use. How?10_Paul Fegan23_Paul.Fegan@CITEC.COM.AU31_Thu, 24 Feb 2000 07:18:40 +1000288_US-ASCII What type of thread are we talking about TSO, Batch, CICS ??????. If it's from QMF use the QMF govenor, if it's from Batch you can use job classes, if it's from CICS some of the CICS monitors I've seen will terminate a transaction if it has used more than a given CPU time. [...]
11551 73 24_Re: Foreign Key creation13_Horton, Libby20_Libby_Horton@BMC.COM31_Wed, 23 Feb 2000 15:47:56 -0600320_ISO-8859-1 You can also create a foreign key in BMC Change Manager. In an Alter workid bring up the table in Specification. On the Mixed List type CFK in the Action column next to the table name. This will bring up the Create Foreign Key screen.
Best regards, Libby Horton BMC Product Support 1-800-537-1813 [...]
11625 35 38_Re: Move DB2 OS/390 Data to AIX/R/600013_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Wed, 23 Feb 2000 18:20:42 -0500427_iso-8859-1 Would be interested to know if you had contemplated using IBM's DProp for b).
Also curious as to why AIX is perceived as offering a 24*7 environment, when, by implication, OS/390 is not.
Gregg Sawyer
-----Original Message----- From: mtdage@ATT.NET [mailto:mtdage@ATT.NET] Sent: Wednesday, February 23, 2000 12:34 PM
Objective: To access Internet database info in a 24*7 environment. [...]
11661 42 26_Re: time out in fetch sqls14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 24 Feb 2000 10:40:02 +1000525_- You can get -911 from a FETCH if the open did not materialise the result set. For example, if you select without a WHERE clause, the underlying data will be read during the fetch process so you can get a deadlock/timeout then.
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au -----Original Message----- From: madhavan [mailto:madhavan@INF.COM] Sent: Wednesday, February 23, 2000 11:37 PM To: DB2-L@RYCI.COM Subject: time out in fetch sqls [...]
11704 172 41_Re: Secondary extents in DB2 V5 for OS39015_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 19 Feb 2000 00:51:08 -0600377_us-ascii Nicely said.
EX: tablespace in 100 extents All 100 extents are non-contiguous Pure tablespace scan
If you were to scan the WHOLE tablespace, you would add at MOST 100 extra cylinder seeks (when the end of each extent is reached and 1 to position to 1st extent = 100) at, let's say, 10 extra milliseconds. That amounts to 1 SECOND for the whole run. [...]
11877 55 53_Re: Trapping SQL Text with Omegamon- Anybody done it?15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 19 Feb 2000 01:02:30 -0600350_us-ascii We tried this with whatever IFCID pumps out the dynamic SQL text (and specified it go to SMF datasets? I can't remember exactly).
I even put together a REXX exec that parses all SELECT statements so you can load the info into a DB2 table for SPUFI querying so you can see which columns are used most often for which tables, etc. [...]
11933 26 25_Removing a Quiesce in UDB12_Jason Hughes20_Jason.Hughes@TRW.COM31_Wed, 23 Feb 2000 16:24:52 -0800559_US-ASCII I'm trying to assist some co-workers with a quiesce problem (the blind leading the blind) and so I'm searching for what we need to do to solve this problem. I've hit the limits of my limited knowledge in this area.
They are using UDB 5.1 (the original release it appears) on NT. They have a small database with only 6 user tables in 1 tablespace. During a LOAD/IMPORT something blew up and now a table (not sure which one) in that tablespace is in QUIESCE EXCLUSIVE mode. When trying to issue a QUIESCE ... RESET against any table in the [...]
11960 26 36_Semi-finals of SMF 42 product naming15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 19 Feb 2000 01:21:15 -0600390_us-ascii Here are the names that I would like reponses for concerning the SMF 42 product (dataset I/O reporter).
I/O SPY for DB2 (too KGBish?) I/O SURVEYOR/SURVEILLANT for DB2 (more KGB) I/O BEACON for DB2 (light-related ala SolarFlare) I/O EXPLORER for DB2 I/O MINER for DB2 (sounds minor? - data mining)
Please feel free to respond privately so we don't clog the list. [...]
11987 30 22_regarding online entry17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Wed, 23 Feb 2000 18:35:37 PST320_- Hello Everybody,
I have a question in production table updation. actually one of the request comes to me to update a production table. but i had a doubt, because in a day time there are lot of online entries will be going on in the production for the same table in that case how would i update the tables. [...]
12018 52 40_Re: Semi-finals of SMF 42 product naming16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Wed, 23 Feb 2000 22:52:44 -0500422_us-ascii Jim, Beacon, Explorer,Miner are TOO DEEP ie. windows explorer,data miner. These already exist. I think there is also another db2 Surveyor product on the market. KISS SMF FLASH I/O REPORTER would be more apporpriate. IMHO best of luck Tom
Jim Lewandowski on 02/19/2000 02:21:15 AM
Please respond to DB2 Data Base Discussion List [...]
12071 22 10_NT & OS39014_Powell, Graeme17_gpowell@OTK.CO.ZA31_Thu, 24 Feb 2000 07:34:33 +0200355_- Hello Everyone
I am busy investigating if DB2 on NT can synchronize with DB2 on OS390. I am still new to DB2 and am in the process of moving over from SQL Server. On the mainframe side we are busy moving from Adabas to DB2. Once we have DB2 on the mainframe I would like to be able to synchronize my NT DB2 with OS390 DB2. Is this possible? [...]
12094 11 0_15_Pravat Banerjee32_pravatbanerjee@LOT.TATASTEEL.COM29_Thu, 24 Feb 2000 06:05:54 GMT265_us-ascii SIGN-OFF DB2-L
================================================ 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.
12106 43 14_Re: NT & OS39010_Paul Fegan23_Paul.Fegan@CITEC.COM.AU31_Thu, 24 Feb 2000 16:06:49 +1000588_US-ASCII Graeme, Yes it is possible, BMC have a product which will do it and IBM supply Datapropagator. The BMC method of propagation is possibly the best solution (I haven't used the product so I couldn't say for sure). I believe it reads the logs and applies the changes directly to the other Database without using staging tables which is the way DPROP works. You'll need to look at both products see to which best suits your needs, they are both up to the minute replication tools. If you don't need this sort of synchronization there are cheaper alternatives like unload-reload [...]
12150 75 26_Re: regarding online entry10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 24 Feb 2000 06:48:59 GMT576_us-ascii Hi Ravi, If u are worried about ur updation not to get -911 or -904 due to online entry and ur online transaction should not get -911 or -904 due to ur updation activity then u should look at the amount of data u are updating in a single run(or may be high lock wait for online entry).It depends on transaction to transaction and tables to tables.Some transaction might update/insert/delete large amount of data or some can less.Some can even have multiple commits in a single task(in CICS term). Generally, an online should not process more than certain no. of [...]
12226 30 0_9_Jo K.Nash17_jo.k.nash@USA.NET29_Thu, 24 Feb 2000 02:16:57 EST543_US-ASCII Mark,
Thanks for the input, it worked well. Yes I agree the quantity of objects is getting out of hand. VSAM applications of the 70's now seem so simple and easy to manage.
Here's the url you wanted:
http://www.bmc.com/RightSite/getcontent/bmcdoc.html?dmw_objectid=0900320180187c84&dmw_format=html
Use cut and paste, it's easier than typing it
Jo
____________________________________________________________________ Get free email and a permanent address at http://www.amexmail.com/?A=1 [...]
12257 45 26_how to do unattended reorg12_Nurmi, Seppo23_Seppo.Nurmi@RIKSBANK.SE31_Thu, 24 Feb 2000 10:47:39 +0100416_- Hello List We run reorgs regularly on weekends (the reorg jobs are generated by running Platinum PDA jobs). We are a little OS/390 shop, and we have no operators in place until monday morning, and then all the DB2 tables must be up and running. So I as a DBA am bound to check the reorgs every sunday. No free weekend ever :-( , also my boss is unhappy for all that money he pays me for the weekend work :-). [...]
12303 72 30_Re: how to do unattended reorg12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 24 Feb 2000 10:34:00 -0000530_- You are right, but on-line reorg requires enough space to create a copy of your tablespace and its indexes, so I can't see that it would solve your real problem, which is a shortage of DASD. If you are using one or two pools of volumes, get some more DASD added and set up as QUENEW to ensure that you will find a large chunk of contiguous space when you need it. Consider having a ceiling for PRIQTY, say 1000 cyls, and check regularly that there are at least 3 contiguous chunks of that size. You can automate this quite [...]
12376 56 21_Re: DB2 DASD ACTIVITY14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 24 Feb 2000 12:21:01 +0100326_us-ascii Ok it's an hold DASD device and with a very small cache (256K cache if I remember well), but I
think they are overloaded.
We used HITACHI 7600 and we had high IOSQ and sometimes very high CONN response time
components (CONN was high when heavy prefetch queries) but not so high (<100 msec). [...]
12433 44 30_Re: how to do unattended reorg14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 24 Feb 2000 12:50:16 +0100397_us-ascii In a previous shop I had the same problem (very little DASD space to use for reorgs and DB2 V4 with no online/shrlevel reference reorg available....) and we try to resolve with:
1) A pool of 'spare' DASD, that is DASD for applications and DB but not yet assigned to an user (empty and parked somewhere). Every installation have some of that dasd unused.And it's large enough. [...]
12478 194 38_Re: DB2 V6 to DB2 V5 Fallback - Beware0_29_paul.packham@POSTOFFICE.CO.UK31_Thu, 24 Feb 2000 11:52:29 +0000436_us-ascii Hi Andy,
Sorry I didn't post an update sooner but I was on annual leave. However I do now have conformation from IBM that the changes made to sysstrings must be backed out to successfully fallback to DB2 V5. I've included their final comments below : " Please advice your customer to restore SYSSTRINGs as part of their fallback. I will be looking into putting it into the info APAR for migration hints and tips. " [...]
12673 28 30_Re: how to do unattended reorg9_Colin Fay13_cfay2@CSC.COM31_Thu, 24 Feb 2000 07:35:54 -0500534_us-ascii Hi,
In my previous job I applied most of the suggestions mentioned by Max and Colin ( and spent many hours fine-tuning this ) but the thing that finally put my space problems to rest was to partition all my large tablespaces and reorg by partition. I also cut a deal with the DASD adminstrator to maintain a cap on the average %used on the DB2 packs, I used 1 big SMS group for all DB2 volumes and set the # of partitions such that each partition was less than the maximum contiguous free space on any one of the [...]
12702 10 37_Re: Limit DB2 CPU a threads use. How?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Thu, 24 Feb 2000 07:01:44 -0600301_- It is a call attach thread coming from an IBI EDA region.
================================================ 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.
12713 22 16_DB2 on Linux/39011_Daniel Adam15_dadam@GRATEX.SK31_Thu, 24 Feb 2000 07:41:06 -0600345_- Hi, Our sysadmin recently installed Linux on S/390. 1.) I would like to know if there are currently any applications ( like DB2 ) available for Linux/390. 2.) Are there plans for porting DB2 and other applications ( Websphere, Java ... ) to Linux/390 ? 3.) Can anyone share her/his experiences with running anything at all on Linux/390 ? [...]
12736 54 14_Re: NT & OS39010_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 24 Feb 2000 13:39:35 GMT276_us-ascii Hi Graeme, I think u can synchronize this but it depends on ur requirements for e.g whether u want ur data to be replicated to DB2 on NT and ur applications on NT accessing that data or u want to access the data on DB2 OS390 directly thru ur applications on NT. [...]
12791 15 31_refresh dynamic statement cache12_Geert Placke23_Geert.Placke@MERANT.COM31_Thu, 24 Feb 2000 14:35:25 -0000403_- Is there anyone who knows how to refresh/clean up the dynamic statement cache in DB2v6, besides recycling the whole DB2 subsystem?
Thanks,
Geert.
================================================ 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.
12807 57 35_Re: refresh dynamic statement cache13_Adrian Savory24_adrian.savory@ZURICH.COM31_Thu, 24 Feb 2000 14:39:17 +0000365_us-ascii Geert,
You can do this at tablespace level by running Runstats - this will invalidate the cached statements for all tables in the tablespace. If you do not want to change your catalog statistics you can still do this by running a report-only Runstats. As far as I know there is no way of clearing the whole dynamic statement cache with DB2 v6. [...]
12865 36 20_Re: DB2 on Linux/39012_Jim Harrison12_jimh@QIS.NET31_Thu, 24 Feb 2000 09:47:43 -0500682_us-ascii Get your free evaluation copy of DB2 for Linux at
http://www6.software.ibm.com/dl/db2udbcd/db2udbcd-p
And if you go to
http://www-4.ibm.com/software/is/mp/linux/
I think you'll be suprised at IBM's commitment to Linux (I know *I* was!)
At 07:41 AM 2/24/00 -0600, you wrote: >Hi, >Our sysadmin recently installed Linux on S/390. >1.) I would like to know if there are currently any applications ( like >DB2 ) available for Linux/390. >2.) Are there plans for porting DB2 and other applications ( Websphere, >Java ... ) to Linux/390 ? >3.) Can anyone share her/his experiences with running anything at all on >Linux/390 ? > >Thank you [...]
12902 73 20_Re: DB2 on Linux/39014_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Thu, 24 Feb 2000 07:02:34 -0800366_- Daniel,
Here's a stab at a couple of answers - I'm sure someone will correct me if I lead you astray!
1. There is a version of DB2 UDB available for Linux. I have no idea whether it will work on the S/390 version of Linux, but it's an interesting thought! The software is available for download at http://www-4.ibm.com/software/data/db2/linux/. [...]
12976 248 33_Re: DB2 Utilities in the Linklst?12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Thu, 24 Feb 2000 10:04:36 -0500625_iso-8859-1 I agree with this re: make versioning references in JCL a no-no except during migration test periods, when multiple versions are necessary, or other special cases.
Regardless of whether its in the linklist or not, removing opportunities for version dependence is a good thing. Mandating removal of version-specific library references reduces the number of silly user trouble calls (Why didn't this job work??? Hmm... probably because you are referencing a V3.1 dataset that hasn't existed for years, and we're on V6) and also aids in keeping migration impact on users low when you go to a new version. [...]
13225 37 35_Re: refresh dynamic statement cache13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 24 Feb 2000 09:08:38 -0600427_iso-8859-1 If you want to force a rebind related to a specific table (perhaps new indexes added?), you can execute a ALTER TABLE ... AUDIT NONE.
I do not know of a "refresh cache" type command. I assume this is OS390 hth Glenn
-----Original Message----- From: Geert Placke [mailto:Geert.Placke@MERANT.COM] Sent: Thursday, February 24, 2000 8:35 AM To: DB2-L@RYCI.COM Subject: refresh dynamic statement cache [...]
13263 140 87_Repost: ManTech Systems Solutions Corporation Licenses Database C onversion Tool to IBM13_Morrill, John12_JohnM@VP.NET31_Thu, 24 Feb 2000 08:24:48 -0700761_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
Dear DB2 Interested Parties,
I thought this announcement may be of interest to many of you. Please contact your IBM representative for more information on this solution, as well as on the services of the IBM Software Migration Project Office (SMPO). See http://www.ibm.com/solutions/softwaremigration/ or send an e-mail to: smpo@us.ibm.com for information on the SMPO's [...]
13404 147 92_Repost: IBM DB2 OLAP Server for OS/390 Brings Analytic Capabiliti es to your Enterprise Data13_Morrill, John12_JohnM@VP.NET31_Thu, 24 Feb 2000 08:24:49 -0700586_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
Dear DB2 Interested Parties,
Today IBM announced DB2 OLAP Server for OS/390. The DB2 OLAP Server for OS/390 offers the same functionality as the workstation product, DB2 OLAP Server Version 1.1. [...]
13552 429 85_Repost: ITSO Residency Announcement: LS-N300 e-business and BI C onnectivity on S/39013_Morrill, John12_JohnM@VP.NET31_Thu, 24 Feb 2000 08:24:48 -0700770_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
Dear DB2 Interested Parties,
Below is a bulletin from International Technical Support Organization (ITSO) project leader, Vivian Anavi-Chaput, for the subject Redbook residency. This residency begins 13 Mar 2000, ends 14 Apr 2000 (5 weeks), and requires 4 residents. After reviewing the residency information, contact Vivian at viviane@us.ibm.com if interested in participating. [...]
13982 141 30_SV: how to do unattended reorg12_Nurmi, Seppo23_Seppo.Nurmi@RIKSBANK.SE31_Thu, 24 Feb 2000 16:34:03 +0100538_iso-8859-1 Additional information to my question: we use Contro/M to schedule the jobs. We have basically solved the space problem, most time nothing goes wrong, but because something still can go wrong I must continue checking the reorgs every weekend. What I need is an uncomplicated solution that CAN NOT, never ever, leave us without working tablespaces. I think online reorg is one good candidate. We can affort installing the extra DASD if we can guarantee that reorgs then can be run unattended. Can we guarantee this? /Seppo [...]
14124 84 30_Re: how to do unattended reorg10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Thu, 24 Feb 2000 07:26:32 -0800336_us-ascii If you have DB2 v6.1 or DB2 v5.1 with the appropriate PTFs, you can specify REUSE in the REORG statement so DB2 will use the existing DASD datasets to reload the tablespace and indexspaces instead of deleting them and creating new ones. We've found this helps considerably to reduce DASD problems causing a REORG to fail. [...]
14209 38 30_Re: how to do unattended reorg13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Thu, 24 Feb 2000 10:48:37 -0500329_iso-8859-1 Not a practical expectation in the real world. You might try an alternative approach - having taken all reasonable efforts to make the process itself as bullet-proof as possible (and there were good suggestions in all the responses), you might consider implementing a check job that will notify you of a failure. [...]
14248 59 34_Re: SV: how to do unattended reorg14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 24 Feb 2000 17:00:54 +0100383_us-ascii In my current shop in weekend we run 600+ reorgs (partioned & non-partitioned tablespace) +
many index reorgs. They are submitted by CONTROL-M (we use a C-M resource called
REORGDB2 to regulate the number of reorgs executed in parallel) and the jobs are all reorg
SHRLEVEL REFERENCE (with a mirror tablespace, no ONLINE REORG s.s.). There are some [...]
14308 57 35_Re: refresh dynamic statement cache22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 24 Feb 2000 15:09:56 +0000483_ISO-8859-1 ....remember when DB2 used to crash when you did this :-) (Adrian you out there)???
Les
______________________________ Reply Separator _________________________________ Subject: Re: refresh dynamic statement cache Author: "Mackey; Glenn" at Internet Date: 2/24/00 9:08 AM
If you want to force a rebind related to a specific table (perhaps new indexes added?), you can execute a ALTER TABLE ... AUDIT NONE. [...]
14366 128 30_Re: how to do unattended reorg0_19_Tim.Lowe@STPAUL.COM31_Thu, 24 Feb 2000 10:14:03 -0600866_us-ascii Bill, I am just curious. Since a REORG with REUSE does not "reclaim" allocated secondary extents, what do you do about the secondary extents?
Thanks, Tim
Bill Welch on 02/24/2000 09:26:32 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: Re: how to do unattended reorg
If you have DB2 v6.1 or DB2 v5.1 with the appropriate PTFs, you can specify REUSE in the REORG statement so DB2 will use the existing DASD datasets to reload the tablespace and indexspaces instead of deleting them and creating new ones. We've found this [...]
14495 29 17_Re: IDUG vs. Tech13_Helen Johnson25_Helen_Johnson@RAC.RAY.COM31_Thu, 24 Feb 2000 10:16:13 -0600541_us-ascii I have attended both. It really depends on where your interests are. If you are an applications programmer, you probably want to go to IDUG. If you are a system programmer, the Tech Conference would probably be your first choice. For DBAs, either depending on whether you lean toward a technical DBA or an application DBA. I am a DBA and since I spend a lot of my time helping applications, I prefer IDUG. Remember some of the same IBM sessions are held at both conferences and anyone will get excellent information from both. [...]
14525 18 9_IDUG 200116_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Thu, 24 Feb 2000 11:24:07 -0500414_iso-8859-1 Hey Folks.. Has anyone heard rumers as to where IDUG will be held in 2001 (North America)?
Michael Dempsey Data Base Administration UNC Health Care System
================================================ 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.
14544 38 29_Re: Removing a Quiesce in UDB0_23_john.lantz@ZURICHUS.COM31_Thu, 24 Feb 2000 11:21:10 -0500569_us-ascii When you look at the tablespace through the Control Center, what is the state ("quiesce exclusive" or something like that?) of the tablespace? To remove a quiesce on a table, it's user specific. In other words, the person that put the table in quiesce pending must be the person to reset the quiesce. This has gotten us in the past... Date: Wed, 23 Feb 2000 16:24:52 -0800 From: Jason Hughes Subject: Removing a Quiesce in UDB MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable [...]
14583 197 34_Re: SV: how to do unattended reorg0_19_Tim.Lowe@STPAUL.COM31_Thu, 24 Feb 2000 10:23:37 -0600318_us-ascii Seppo, Are you saying that they will not buy additional dasd if you cannot "guarantee" that no reorg problems will ever occur? Or, are they willing to buy more dasd if they do not have to pay someone (you) to monitor the reorgs? Can I assume that there are no operations people ("lights out operation")? [...]
14781 195 41_Re: Secondary extents in DB2 V5 for OS39012_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 24 Feb 2000 18:31:20 +0200573_x-user-defined Software companies LOVE upgrades.
They LIVE by upgrades.
Isaac Yassin
Jim Lewandowski wrote: > > Nicely said. > > EX: tablespace in 100 extents > All 100 extents are non-contiguous > Pure tablespace scan > > If you were to scan the WHOLE tablespace, you would add at MOST 100 > extra cylinder seeks (when the end of each extent is reached and 1 to > position to 1st extent = 100) at, let's say, 10 extra milliseconds. > That amounts to 1 SECOND for the whole run. > > As alluded to below, a lot of the [...]
14977 21 31_Entry in SYSIBM.SYSCOPY Table..18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM31_Thu, 24 Feb 2000 11:38:42 -0500331_us-ascii All,
I was actually wondering when does an entry take place in SYSIBM.SYSCOPY Table. Is it after the RELOAD Phase? Can there be a scenario when I am doing a LOAD REPLACE and in the first phase after deleteing the tablespace it fails and no loading of data is done and I still have an entry in SYSIBM.SYSCOPY?? [...]
14999 28 17_Re: IDUG vs. Tech0_19_Tim.Lowe@STPAUL.COM31_Thu, 24 Feb 2000 10:38:22 -0600609_us-ascii For my 2 cents,
I became wary of IDUG several years ago after I attended some user-presentations that were just a "rehash" of technical conference presentations. I have attended many good user presentations, but it is hard to determine which to attend, and which might be a waste of time.
Therefore, for the last 5 years I have attended the DB2 tech conference instead of IDUG. And, I have leaned heavily toward attending presentations by IBM development and support personnel. But, this may also be because I have a lot of experience with DB2, and my interests are primarily more [...]
15028 72 30_Re: how to do unattended reorg0_23_Mike_Levine@TEKHELP.NET31_Thu, 24 Feb 2000 11:41:24 -0500591_us-ascii Hi,
If you have no operators over the weekend then you must have an automated tape system. Have you thought about using tape (VTS?) for your SYSUT1, SORTOUT and SYSREC work datasets? Also, with new V5 reorg parms it's possible to eleminate the need for these work files altogether. If you specify NOSYSREC you don't need SYSREC and if you use SORTKEYS you don't need SORTOUT and SYSUT1. Keep in mind that these options improve performance but if the job abends you cannot restart it and the tablespace must be recovered. Please see the utility guide for other notes and [...]
15101 49 30_Re: how to do unattended reorg14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Thu, 24 Feb 2000 08:54:28 -0800528_us-ascii Colin, I had similar success with the approach you mention where I used to work. Partitioning was essential for managing tables of more than about 40 million rows. However, I didn't have to cut a deal with the DASD admin. REUSE helped. We also had some pretty aggressive HSM archiving for non-DB2 data. That really helped keep DASD utilization reasonable. I was skeptical about this at first but was won over by a persistent (hard-headed), but smart and energetic tech mgr who really understood SMS and HSM admin. [...]
15151 75 29_Re: Removing a Quiesce in UDB0_23_sjtoeniskoetter@AEP.COM31_Thu, 24 Feb 2000 11:53:07 -0500563_us-ascii We had the same problem recently. You can't issue the quiesce reset because another connection has exclusive control of it. Try this:
1. issue a quiesce exlusive command to get control of the tablespace 2. if step 1 worked, it means you had a phantom quiesce. Issue the quiesce reset and you're done 3. if step 1 failed with an SQL3805N, then the connection that caused the quiesce exclusive is probably still connected. Force that connection off. 4. issue a quiesce exlusive command to get control of the tablespace 5. issue a quiesce reset [...]
15227 32 52_Is DB2 V6 ODBC/CLI invocable by other than IBM C/C++11_Jim Keohane19_jimkeo@LOCKSTAR.COM31_Thu, 24 Feb 2000 12:19:02 -0800333_us-ascii DB2 V5 CLI (a DLL) could only be called/invoked from IBM C/C++. I assume it is still true for DB2 V6. Please let me know if not the case. I do not have manuals and am spelunking IBM's web pubs but I need confirmation quickly. Would like to think CLI can be invoked from assembler or other HLL's than IBM C/C++. Thanks! - Jim
15260 167 30_Re: how to do unattended reorg10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Thu, 24 Feb 2000 09:15:20 -0800506_us-ascii Once a week, we use clunky ole SDSF 3.4 option to list all the datasets in a database. Press PF11 to show the number of extents (XT), then sort by number of extents (SORT XT in the command line).
If any dataset has more than 10 extents (an arbitrary number we currently use), the DB2 on call person will set up a job to be run during "our" time on the weekend that will ALTER the object so that the PRIQTY will hold the entire dataset in one extent and REORG the object without REUSE. [...]
15428 24 16_poor performance17_Giuseppe De Donno18_dedonno@ARIADNE.IT31_Thu, 24 Feb 2000 18:19:47 +0100387_us-ascii Hi, I have a problem of performance in this stupid query:
select field1, field2...., fieldN from table
if the number of field in the select (!) is > 10 then the query is really expensive, but if the fields are < 10 the result is immediate. Have I need of an index? But the index are only on the clause of where! Ave you comment? thank you in advance giuseppe [...]
15453 45 35_Re: Entry in SYSIBM.SYSCOPY Table..14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Thu, 24 Feb 2000 09:30:35 -0800354_iso-8859-1 I believe that the SYSCOPY Entry is inserted during the UTILINIT phase, so there will be a record in SYSCOPY in the scenario you mentioned. However, Dan Coulter would be the one who can give a more definitive answer to this. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
15499 49 20_Re: poor performance22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 24 Feb 2000 16:36:47 +0000377_ISO-8859-1 Hi is the request in the select being satisfied by the indexes being used ??????????.. if one column in the query select causes you to go to the data pages you may shoot yourself in the foot performance wise... a access if using the index only to get the data .. infact, no, a good query is no query :-) I must have nicked that quote from someone somewhere ... [...]
15549 24 16_poor performance8_Giuseppe18_dedonno@ARIADNE.IT31_Thu, 24 Feb 2000 18:35:33 +0100390_us-ascii Hi, I have a problem of performance in this stupid query:
select field1, field2...., fieldN from table
if the number of field in the select (!) is > 10 then the query is really expensive, but if the fields are < 10 the result is immediate. Have I need of an index? But the index are only on the clause of where! Have you a comment? thank you in advance giuseppe [...]
15574 33 25_New Function in Version 612_Roger Miller19_millerrl@US.IBM.COM31_Thu, 24 Feb 2000 12:09:36 -0600418_- To see the substantial new function added to Version 6 through APARs, see http://www-4.ibm.com/software/data/db2/os390/v6apar.html
It includes a list of the key changes, with some guidance that I'll paste below:
This page contains information that describes IBM's preliminary plans, which are subject to change at IBM's business discretion. Do not rely on such information to make business plans. [...]
15608 20 39_Does anyone use MEMBER CLUSTER option ?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 24 Feb 2000 13:32:40 -0500470_us-ascii Dear List
I interested to know if any one in this list uses MEMBER CLUSTER option. If yes what is your opinion on this. I will summarize all the response and post if back to the list.
Thanks -Venkat Pillay
================================================ 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.
15629 24 41_Increased Column Name Length in UDB/OS3900_25_robert.hall@OCC.TREAS.GOV29_Thu, 24 Feb 2000 13:55:16 EST595_us-ascii Hi,
Does anyone know if/when the limit on column names will be increased from 18 to 30? Last time I posted this, the word was that the 30 character column names would be available about 6 months post GA for V6.
Thanks! Robert
***************************************************** Reply to: Robert.Hall@occ.treas.gov
================================================ 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.
15654 49 45_Re: Increased Column Name Length in UDB/OS39014_Richard Yevich17_ryevich@YAHOO.COM31_Thu, 24 Feb 2000 12:02:21 -0800625_us-ascii The increase in name lengths in DB2 has not been announced by IBM as to when or in what version/release it might be.
--- robert.hall@occ.treas.gov wrote: > Hi, > > Does anyone know if/when the limit on column names will be > increased from 18 to > 30? Last time I posted this, the word was that the 30 character > column names > would be available about 6 months post GA for V6. > > > Thanks! > Robert > > ***************************************************** > Reply to: > Robert.Hall@occ.treas.gov > > ================================================ > To change your subscription options or to cancel [...]
15704 35 35_Websphere/JAVA and Stored Procedure9_Wu, James13_jwu@KRAFT.COM31_Thu, 24 Feb 2000 14:25:07 -0600345_- We try to pass a character string, say string1, to a stored procedure from JAVA through Websphere, the string goes into the stored procedure but the comparison in the 'where col1 = :string1' never be true, and hence the result-set returned to JAVA is empty. If we remove the WHERE clause, the result-set contains all rows from the table. [...]
15740 53 20_Re: poor performance0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 24 Feb 2000 14:22:37 -0600441_us-ascii Since no one has tried to answer, how about some more info...
- when you say "more than 10" column, is that any 10 columns or just the first 10 - do these 10 columns match the columns in an existing index - do you have any indexes on table - are you using WHERE clauses - is this SPUFI type access or static (bound) SQL - if static provide EXPLAIN output - what enivronment: OS (390/NT/AIX ...) DB2 version (V4, V5, V6) [...]
15794 36 17_DB2 Connect error11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 24 Feb 2000 12:45:18 -0800484_iso-8859-1 I have a user who has installed DB2 Connect PE on his PC. When he runs the "TEST" from the Client Configuration Assistant it fails and I see this syslog message.
11.07.06 STC06059 DSNL032I - DSNLIRTR DRDA EXCEPTION CONDITION IN
REQUEST FROM REQUESTOR LOCATION=167.131.70.139 FOR THREAD WITH LUWID=A783468B.G481.B3A5FD5BD78E
REASON=00D3101C
ERROR ID=DSNLIRTR0001
IFCID=0192
SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000000 [...]
15831 19 23_Convert index to type 214_Bistricer, Avi20_BistricerA@CONED.COM31_Thu, 24 Feb 2000 15:58:12 -0500412_- Does IBM give way to convert indexes to TYPE 2 as part of migration to v6 (from v5.1)? If not, please suggest ways.
Thanks
Avi Bistricer, DBA 212.460.6695
================================================ 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.
15851 80 21_Re: DB2 Connect error17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Thu, 24 Feb 2000 22:06:25 +0100455_us-ascii Hi Cliff I suppose you are connecting, via TCP/Ip to your DB2 for OS/390 v 5.1. Messages and Codes GC26-8979-00, vol 2, pag 4-128: ----------------------------------------------------------------------------- 00D3101C
Explanation : DB2 has detected an error while processing a connection request from DDCS. A DB2RA connection request was received from DDCS. This reason code is issued by the following CSECT's: DSNLCRTD and DSNLIRTR. [...]
15932 57 21_Re: DB2 Connect error13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 24 Feb 2000 14:55:37 -0600300_US-ASCII Cliff, At your PC use the CLP and issue and issue the following commands. list dcs directory list node directory list db directory and verify that you get the same result at your users PC. The 00D3101C error says its most likely caused by incorrect entry in the DCS directory. HTH Kurt [...]
15990 57 27_Re: Convert index to type 20_20_John_Lendman@FPL.COM31_Thu, 24 Feb 2000 16:01:51 -0500483_us-ascii You do the following:
ALTER INDEX UJNEDB2.TIIPDOVL CONVERT TO TYPE 2 ; ALTER INDEX UJNEDB2.TIIPDOV1 CONVERT TO TYPE 2 ; ALTER INDEX UJNEDB2.TIIPWOA1 CONVERT TO TYPE 2 ; ALTER INDEX UJNEDB2.TIIHBLOB CONVERT TO TYPE 2 ; ALTER INDEX UJNEDB2.TIIPRST2 CONVERT TO TYPE 2 ; ALTER INDEX UJNEDB2.TIIDLXR CONVERT TO TYPE 2 ; ALTER INDEX UJNEDB2.TIISRXRS CONVERT TO TYPE 2 ; ALTER INDEX UJNEDB2.TIIRTAUD CONVERT TO TYPE 2 ; ALTER INDEX UJNEDB2.TIIPPAA1 CONVERT TO TYPE 2 ; [...]
16048 104 27_Re: Convert index to type 20_19_Tim.Lowe@STPAUL.COM31_Thu, 24 Feb 2000 15:09:58 -0600479_us-ascii One other option (instead of using recover/rebuild index) is to reorg the tablespace with SORTDATA. I have used this to convert many indexes to type-2 by adding the "alter index" statements in a step immediately preceding the reorg jobs that were already scheduled. Since a reorg with SORTDATA does not use the index to unload the tablespace, and the indexes are already being rebuilt at the end of the reorg, there is no additional time needed for the conversion. [...]
16153 227 20_Re: poor performance27_Radonjic, Bora (Consultant)23_BRadonjic@ACNIELSEN.COM31_Thu, 24 Feb 2000 15:12:27 -0600521_- Giuseppe Is select statement equally "expensive" if you try SELECT * or if you change order of selected columns i.e. SELECT col_5, col10, col15, col1 ... Does column ordering in the SELECT statement matches physical ordering in the table, do you have columns in the table defined with varchar and how many and if yes what is their position within table. Is it maybe that columns that you are selecting after 10th are behind varchar columns? Just my guess Bora Radonjic (consultant) (all opinion are ... and so on) [...]
16381 45 39_Re: Websphere/JAVA and Stored Procedure12_Jim Herrmann12_b3d@CUOL.NET31_Thu, 24 Feb 2000 15:16:08 -0600576_us-ascii Are you using SQLJ, or JDBC? JDBC does not support host variables, whereas SQLJ does. If you are using JDBC, you must concatenate the actual value in the query string, something like this: "where col1 = '" + string1 + "'"
Hope that helps.
"Wu, James" wrote:
> We try to pass a character string, say string1, to a stored procedure > from JAVA through Websphere, the string goes into the stored procedure but > the comparison in the 'where col1 = :string1' never be true, and hence the > result-set returned to JAVA is empty. If we remove the [...]
16427 126 27_Re: Convert index to type 211_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM31_Thu, 24 Feb 2000 15:12:05 -0600735_us-ascii We did this using Online reorg. Good results with no outage for the customers.
Tim.Lowe@STPAUL.COM on 02/24/2000 03:09:58 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Ray H Janes/C/Dallas/Mobil-Notes) Subject: Re: Convert index to type 2
One other option (instead of using recover/rebuild index) is to reorg the tablespace with SORTDATA. I have used this to convert many indexes to type-2 by adding the "alter index" statements in a step immediately preceding the reorg jobs that were already scheduled. Since a reorg with SORTDATA does not use the index to unload the tablespace, and [...]
16554 25 10_DB / EXCEL0_20_ddlusk@HOUSEHOLD.COM31_Thu, 24 Feb 2000 15:11:28 -0600580_us-ascii One of our data administration people is trying to do a DB EXCEL BATCH MIGRATION
The job abends with the following message:
IBM780I 'ONCODE' = 0003
and gives a return code of 2000 for PROGRAM DBXMIGB
could someone point me to where I can find the DB EXCEL manuals
for os/390 db2v5
t.i.a.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16580 71 21_Re: DB2 Connect error10_Marc Costa28_Marc.Costa@MUTUALOFOMAHA.COM31_Thu, 24 Feb 2000 15:20:25 -0600663_us-ascii If you have the Client Configuration Assistant, check to see if "TEST" is defined as DRDA on both machines. If this is the same problem we had, your machine will have "TEST" as DRDA and the users machine will not have DRDA specified for "TEST".
|--------+----------------------------------> | | Cliff Boley | | | | | | | | | 02/24/2000 02:45 PM | | | Please respond to DB2 | | | Data Base Discussion | | | List | | | | |--------+----------------------------------> >--------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: Marc Costa/MutualOMA) [...]
16652 171 27_Re: Convert index to type 20_19_Tim.Lowe@STPAUL.COM31_Thu, 24 Feb 2000 15:35:56 -0600571_us-ascii Ray, Once you did the ALTER INDEX, wouldn't the index be placed in reocver pending, and therefore you would have an outage (for the index) until the reorg completed?
Thanks, Tim
Ray H Janes on 02/24/2000 03:12:05 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: Re: Convert index to type 2 [...]
16824 39 27_Re: Convert index to type 214_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Thu, 24 Feb 2000 13:37:24 -0800325_us-ascii Convert ALL your indexes before even starting the migration to Version 6.
First, change your default type for indexes to TYPE 2 in DSNZPARMS. This is specified on Installation CLIST panel DSNTIPE. The title of the panel is Thread Management. The item on that panel is 9 DEFAULT THREAD TYPE. Set it to 2. [...]
16864 62 21_Re: DB2 Connect error11_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 24 Feb 2000 13:39:41 PST341_- Hi... We had this very same error yesterday for a programmer. Turned out he attempted to download the free version of DB2 connect from the internet, but did not tell anyone that he had some errors in the install saying that certain dlls were not created. Once we reinstalled from a cd-rom, the problem went away. Regards, Rick Creech [...]
16927 83 27_Re: Convert index to type 20_19_Tim.Lowe@STPAUL.COM31_Thu, 24 Feb 2000 15:43:22 -0600640_us-ascii Roy, Wouldn't REORG INDEX abend if you tried to reorg and index that was in "recover pending" status?
Thanks, Tim
Roy R Reynolds on 02/24/2000 03:37:24 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: Re: Convert index to type 2
Convert ALL your indexes before even starting the migration to Version 6. [...]
17011 19 27_Re: Convert index to type 214_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Thu, 24 Feb 2000 14:44:31 -0800379_us-ascii Quite right. I was typing too fast. The snip right out of the SQL Ref is that the index won't actually take place until: 'the index is rebuilt by a LOAD REPLACE or REORG of the entire table space, or a RECOVER or RELOAD of the whole index.' Sorry for the discrepency. I should have added "Std Disclaimers" as well. Glad you were reading it with a critical eye. Roy [...]
17031 22 28_ERwin Name Length Limitation12_Amir Sadeghi20_gomgashteh@YAHOO.COM31_Thu, 24 Feb 2000 16:51:26 -0600517_- Hi,
Does anyone know if there is a way to get ERWin to deal with table names of greater than 18 characters and newer datatypes like BIGINT (VAJava).
I have looked at Server target macros but could not see how this could be done!
Thanks.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17054 207 30_Re: how to do unattended reorg14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Fri, 25 Feb 2000 09:35:30 +1000291_us-ascii Bill, I may not be correct, but I always thought that If tablespace A is originally allocated on pack PACK01 and has 10 extents on that pack, and has then gone into a further 10 extents on PACK02, the number of extents as shown in 3.4 would be 10. Can anyone confirm or deny ? [...]
17262 568 30_Re: how to do unattended reorg14_Ravi Phanindra24_ravi.phanindra@WIPRO.COM31_Fri, 25 Feb 2000 09:54:24 +0530287_iso-8859-1
****** Message from InterScan E-Mail VirusWall NT ******
** No virus found in attached file noname.htm ** No virus found in attached file noname.htm
This message is scanned for Viruses......
***************** End of message ***************
17831 86 18_RMI - JDBC problem14_C S R Krishnan29_csr_krishna@CHENNAI.TCS.CO.IN31_Fri, 25 Feb 2000 12:01:04 +0530361_us-ascii
Hi DB2 Gurus,
Ours is an OS/390 V2R7 shop running DB2 5.1 with JDK version 1.1.6. We are trying to run a Java application on NT which talks to a Java application on mainframe using RMI. The java application on mainframe accesses DB2 using JDBC. The JDBC access to DB2 is giving the following error message
17918 45 30_Re: how to do unattended reorg12_Nurmi, Seppo23_Seppo.Nurmi@RIKSBANK.SE31_Fri, 25 Feb 2000 08:37:32 +0100409_iso-8859-1 Hello Tim! The later alternative is the more accurate description. As long as we even occassionally need a DBA to correct an error, the DBA must always be in reach. In that case it is hard to motivate for the extra DASD. We have no operations people in duty on weekends. There is no other activity going on then but reorgs and other administative batch, most of which is less critical. /Seppo [...]
17964 89 27_SV: Convert index to type 212_Nurmi, Seppo23_Seppo.Nurmi@RIKSBANK.SE31_Fri, 25 Feb 2000 09:23:43 +0100540_iso-8859-1 You can generate the alter index and recovery statements directly using sql, something like:
SELECT 'ALTER INDEX '!!STRIP(CREATOR)!!'.'!!STRIP(NAME), CONVERT TO TYPE 2' FROM SYSIBM.SYSINDEXES WHERE NOT (INDEXTYPE = '2') AND CREATOR ^= 'SYSIBM'
Be aware, if you run the alter index statements in one big batch it will cause quite a heavy logging. When I did it DB2 kept archiving logs every other minute. Better to run in batchs of no more then a couple hundred alters at a time to avoid all loggs filling upp. [...]
18054 18 31_Entry in SYSIBM.SYSCOPY Table..28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Fri, 25 Feb 2000 00:23:03 PST522_- Kartik,
Yes, LOAD REPLACE will insert a SYSCOPY record even if no records are loaded. I believe that only for LOAD LOG NO (non-replace) do we check to make sure records are added before inserting a SYSCOPY record.
Dan DB2 Utilities Developement dcourter@us.ibm.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.
18073 275 30_Re: how to do unattended reorg12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Fri, 25 Feb 2000 09:16:00 -0000513_iso-8859-1 You used to be correct, but it changed a while ago. I'm not sure which release introduced it, but it now puts a '+' next to the volume name to indicate it is the first of many and gets the total extents correct.
I used to use the same approach, but it can be very slow with a large number of datasets, so I now run an IEHLIST for all of our volumes and process the output in a REXX to sort by total extents. This takes 10 secs elapsed for 18 vols, whereas using SDSF was tea-break time. As [...]
18349 258 30_Re: how to do unattended reorg10_John Hardy23_john_j_hardy@UK.IBM.COM31_Fri, 25 Feb 2000 09:17:09 +0000427_us-ascii If you do not specify 'Volume Serial', then for each DSN you will be shown the total number of extents across all volumes. If a Table/Index space has gone multi volume, then the VOLSER of the volume holding the primary extent will be shown, and a '+' will appear next it . If you also specify 'Volume Serial' on the 3.4 entry screen, then for each DSN you will be shown only the number of extents ON THAT VOLUME. [...]
18608 117 27_Re: Convert index to type 210_John Hardy23_john_j_hardy@UK.IBM.COM31_Fri, 25 Feb 2000 09:26:13 +0000443_us-ascii If an Index is in 'Recover Pending' status, then you can successfully REORG the Tablespace for the Table on which the Index is defined, but 'REORG INDEX' will fail.
John Hardy
Tim.Lowe@STPAUL.COM on 24/02/2000 21:43:22
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: John J Hardy/UK/Contr/IBM) Subject: Re: Convert index to type 2 [...]
18726 146 24_Re: resizing active logs15_Ali OZTURK(942)27_ali.ozturk@PAMUKBANK.COM.TR31_Fri, 25 Feb 2000 12:15:24 +0200387_ISO-8859-9 Mike ,
In the 3th step, you can get the print log map and see active logs which are NOTREUSABLE status. then you repro this one only.(be sure that the last checkpoint rba is in this logs.) You don't need to repro other active logs(REUSABLE status). But first , after define the new active logs, you can do preformat to them.(DSNJLOGF stand-alone utility) Regards. [...]
18873 175 41_Re: Secondary extents in DB2 V5 for OS3900_18_mebert@AMADEUS.NET31_Fri, 25 Feb 2000 12:42:07 +0100581_us-ascii We have several (4) mapping tables created in one mapping TS so up to 4 OLR jobs can run in parallel. Since we have many "mirror" tables (different databases - one per country - having the same table/TS structure), we thought about having one mapping TS per database but chose to have only one; we didn't want to needlessly increase the number of usually unused TSs. Because only the indexes are used during the OLR process, you can keep the TS small. The indexes are defined with PRIQTY=720 (one CYL; all our Production allocations are in CYLs), SECQTY=7200 so they [...]
19049 34 12_DB2 UDB 24x717_Barbosa, Odimir J22_odimir.barbosa@EDS.COM31_Fri, 25 Feb 2000 08:48:36 -0500564_-
We have a 24x7 application on AIX using UDB, wich also has a copy of one IMS segment on the mainframe. Because of the nature of application, it requires that IMS data be refreshed on AIX copy once a day, and had to be done one instance without quiescing users activities.We believe this can be accomplished using 2 copies of the table, switched each day after the inactive table is refreshed. But we need another reference table to point to active table. The application will have to join this reference table to access the copy of IMS data on AIX. [...]
19084 25 27_Re: Convert index to type 214_Bistricer, Avi20_BistricerA@CONED.COM31_Fri, 25 Feb 2000 08:24:49 -0500513_windows-1252 Thanks to all who responded. Your input will help me!
We have BMC LoadPlus for DB2 and it has an option of ‘convert index to type 2’.
Did any one try it? If so what is your experience?
Thanks.
Avi Bistricer, DBA 212.460.6695
===============================================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.
19110 32 41_NPI and Piecesize - What's a good number?24_SC Farm Bureau Insurance21_webmaster@SCFBINS.COM31_Fri, 25 Feb 2000 08:43:30 -0500394_iso-8859-1 Dear list,
We are DB2 5.1.
I have a 32 million row NPI (10 byte key) on a LARGE tablespace. I originally let this index default to the 4 GB PIECESIZE when I defined it. Now, I'm trying to determine the optimal PIECESIZE.
I am reading that PIECESIZE determines the number of index data sets that are created. What's a good number of index data sets? 10, 20? [...]
19143 23 30_Data Modeling Tool for UDB EEE13_penny andrews19_pzandrews@YAHOO.COM31_Fri, 25 Feb 2000 05:53:23 -0800556_us-ascii Hello...
Can anyone recommend a data modeling tool that generates DDL which is compatible with DB2 UDB EEE?
Your suggestions are appreciated,
Penny __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
19167 50 32_Re: ERwin Name Length Limitation19_Lisa Westcott-Dryer29_Lisa_Westcott-Dryer@AMWAY.COM31_Fri, 25 Feb 2000 08:35:21 -0500595_us-ascii What version of Erwin are you at? Is your question strictly for DB2?
Lisa
Amir Sadeghi @RYCI.COM> on 02/24/2000 05:51:26 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: ERwin Name Length Limitation
Hi,
Does anyone know if there is a way to get ERWin to deal with table names of greater than 18 characters and newer datatypes like BIGINT (VAJava). [...]
19218 29 42_DB2 Connect Error with Password Encryption10_Ben Alford21_PA7280@UTKVM1.UTK.EDU29_Fri, 25 Feb 2000 08:53:42 EDT495_US-ASCII We are tring to get DB2 Connect PE V6 to connect to DB2 V5 for OS/390 using password encryption. We can get the Configuration Assistant to successfully TEST connect only when encryption is NOT requested.
When we request encryption, we immediately see error message about SQL1402N unable to authenticate user. Encyrption support PTF's have been installed on DB2 V5 for OS/390. DB2 Connect PE V6 fails using the code from the CD and also after downloading fixpack #2 WR21173. [...]
19248 34 27_Re: Convert index to type 29_Birk, Tim17_BirkT@DIEBOLD.COM31_Fri, 25 Feb 2000 09:31:28 -0500304_iso-8859-1 Yes, we used the convert option of LoadPlus. It got several hundred of our indexes converted with no problems. One thing to watch out for - the ID under which the load is running must have the authority to do an alter index. That bit us for our programmers who don't have that authority. [...]
19283 221 31_SQLCODE -911 in the same luw-id15_Ali OZTURK(942)27_ali.ozturk@PAMUKBANK.COM.TR31_Fri, 25 Feb 2000 16:57:01 +0200493_ISO-8859-9
Hello list;
We have encountered a problem on a batch job. It was submitted at midnight . After a few times later, it get sqlcode -911 and stop. Information for this case in db2 log as follows;
01.36.43 STC04147 DSNT376I -DBP2 PLAN=ONTAH083 WITH
CORRELATION-ID=PONTG210
CONNECTION-ID=BATCH
LUW-ID=DSNDBP0.A01PDB2.B3A3B5411211=15345
THREAD-INFO=OPERUSR:*:*:*
IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS PLAN=ONTAH083 WITH [...]
19505 85 35_Re: SQLCODE -911 in the same luw-id20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 25 Feb 2000 10:03:00 -0500588_iso-8859-9 Ali
Which version you are running at ? Check for PTFs. This is fairly known problem and it is just reporting bug. This doesn't mean the thread has timed out with itself. If you run traces you will see the correct resources but it is reported wrongly in the logs.
> -----Original Message----- > From: Ali OZTURK(942) [SMTP:ali.ozturk@PAMUKBANK.COM.TR] > Sent: Friday, February 25, 2000 9:57 AM > To: DB2-L@RYCI.COM > Subject: SQLCODE -911 in the same luw-id > > > Hello list; > > We have encountered a problem on a batch job. It was submitted at > midnight . [...]
19591 116 29_OS/390 RUNSTATS Problems (V5)10_Mark Feven19_markfeven@YAHOO.COM31_Fri, 25 Feb 2000 15:10:45 -0000399_iso-8859-1 Can anybody help me,
I cannot seem to get RUNSTATS to generate the 'correlated column' stats introduced in V5 (i.e. in Catalog columns COLGROUPCOLNO and NUMCOLUMNS).
I have tried many variations (including running RUNSTATS TABLE ALL INDEX ALL), and am currently using syntax similar to the following:
RUNSTATS INDEX CASE.XEMPL KEYCARD FREQVAL NUMCOLS 2 COUNT 15 [...]
19708 162 53_Repost: DB2 OLAP Server and IBM EIP Telecons in March13_Morrill, John12_JohnM@VP.NET31_Fri, 25 Feb 2000 08:25:52 -0700522_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
Dear DB2 Interested Parties,
Two teleconferences discussing new IBM Data Management software solutions will be presented in March: [...]
19871 88 67_Repost: New function in DB2 UDB for OS/390 Version 6 through APAR s13_Morrill, John12_JohnM@VP.NET31_Fri, 25 Feb 2000 08:25:53 -0700732_- Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
Dear DB2 Interested Parties,
For those of you who work with DB2 for OS/390, you might want to keep your eye on that product's web site, in particular a recently added web site http://www-4.ibm.com/software/data/db2/os390/v6apar.html providing information about new function available via APARs. Below is a snip from that page, but go there to follow [...]
19960 125 86_Repost: New technical report on DB2 DataJoiner and Web Applicatio n Server Integration13_Morrill, John12_JohnM@VP.NET31_Fri, 25 Feb 2000 08:30:43 -0700502_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:01 PM --------------------------- [...]
20086 119 43_Repost: New Book on DB2 UDB for Sun Solaris13_Morrill, John12_JohnM@VP.NET31_Fri, 25 Feb 2000 08:30:43 -0700493_- Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:02 PM --------------------------- [...]
20206 114 46_Repost: DB2 Zone on VisualAge Developer Domain13_Morrill, John12_JohnM@VP.NET31_Fri, 25 Feb 2000 08:30:43 -0700493_- Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:01 PM --------------------------- [...]
20321 203 28_Re: Repost: Re: -805 SQLCODE15_Ali OZTURK(942)27_ali.ozturk@PAMUKBANK.COM.TR31_Fri, 25 Feb 2000 17:34:22 +0200374_iso-8859-1 Hi Jeff,
We are encountering same problem sometimes, we are solving like this.(if problem is complex. And I understand your problem is very complex too.)
1. take cdf mode for the tran.
2. run step by step in cdf mode
3. When you get -805 sqlcode you can see the connection token on this screen,(suffix in package or program name) [...]
20525 84 28_Re: Repost: Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Fri, 25 Feb 2000 10:38:59 -0500467_iso-8859-1 Thank you for your reply.
Jeff
-----Original Message----- From: Ali OZTURK(942) [mailto:ali.ozturk@PAMUKBANK.COM.TR] Sent: Friday, February 25, 2000 10:34 AM To: DB2-L@RYCI.COM Subject: Re: Repost: Re: -805 SQLCODE
Hi Jeff,
We are encountering same problem sometimes, we are solving like this.(if problem is complex. And I understand your problem is very complex too.)
1. take cdf mode for the tran. [...]
20610 15 32_Re: ERwin Name Length Limitation12_Amir Sadeghi20_gomgashteh@YAHOO.COM31_Fri, 25 Feb 2000 10:05:42 -0600348_- Lisa,
We are using version 3.5.2. The model is going to be implemented on UDB EEE.
Thanks.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20626 13 53_Products that archive and restore DB2 historical data15_Stovall, Martin16_MStovall@USG.COM31_Fri, 25 Feb 2000 10:41:03 -0600402_iso-8859-1 Does anyone have any experience with Princeton Softtech's ARCHIVE FOR DB2 or any similar products that archive and retrieve purged (historical) rows?
================================================ 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.
20640 77 57_Re: Products that archive and restore DB2 historical data16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Fri, 25 Feb 2000 12:17:44 -0500390_iso-8859-1 Martin
Well you asked .
Compuware has a similar product called File-Aid RDX, which has the capability to archive DB2. The software can also provide the ability to extract selected rows/records and load the related information. The file structures supported by RDX include not only DB2, but VSAM, PDS, and SEQ files It can also handle related IMS databases. [...]
20718 45 21_Re: DB2 DASD ACTIVITY24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 25 Feb 2000 09:12:42 -0800375_- Hi Everyone!
We have a fairly large implementation of the PeopleSoft HRMS application on DB2 version 5 under OS/390. We are currently looking at the SEGSIZE values, and IBM makes the recommendations in the following table. (Administration Manual section 5.10.3.1.2)
Table 88. Recommendations for SEGSIZE Number of Pages SEGSIZE Recommendation 28 4 to 28 [...]
20764 34 14_visual explain15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Fri, 25 Feb 2000 12:41:57 -0500330_iso-8859-1 To all,
I was trying to use visual explain, but could not connect to DB2. We have grandview's ODBC driver connecting to mainframe DB2 version 5.1 using TCP/IP. Can I use this ODBC driver instead of DB2 connect personal edition to connect to DB2, if so how?
The is the data I put in the Add subsystem [...]
20799 227 21_Re: DB2 DASD ACTIVITY16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Fri, 25 Feb 2000 13:02:54 -0500674_- There is a very good Tuning Document written by Richard Yevich and Susan Lawson for the Peoplesoft ERP. It is on the web at:
http://www.db2mag.com/summer99/99sp_toc.shtml
The title of the article is Tuning ERP's for DB2.
Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee
> -----Original Message----- > From: Leblanc, Francis C - CNF [SMTP:Leblanc.Francis@CNF.COM] > Sent: Friday, February 25, 2000 12:13 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 DASD ACTIVITY > > Hi Everyone! > > We have a fairly large implementation of the PeopleSoft HRMS > application on DB2 version 5 under OS/390. We are currently looking at [...]
21027 75 30_Re: how to do unattended reorg19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 25 Feb 2000 12:08:30 -0600596_iso-8859-1 Seppo, Find another position! Best Wishes, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
21103 58 57_Re: Products that archive and restore DB2 historical data9_Rob Crane22_racrane@CONCENTRIC.NET31_Fri, 25 Feb 2000 11:53:59 -0700618_us-ascii You can also add CA's RC/Extract to the list.
-Rob -----------------------------------------------
"Galambos, Robert" wrote: > > Martin > > Well you asked . > > Compuware has a similar product called File-Aid RDX, which has the > capability to archive DB2. The software can also provide the ability to > extract selected rows/records and load the related information. The file > structures supported by RDX include not only DB2, but VSAM, PDS, and SEQ > files It can also handle related IMS databases. > > If you want more information, including how to use RDX in an > archiving setting [...]
21162 74 25_DB2 Connect msg SQL10007N10_Wang.James24_Wang.James@AAA-CALIF.COM31_Fri, 25 Feb 2000 10:50:10 -0800395_iso-8859-1 Did anyone have this problem like this before?
We received message "SQL10007N message '-1092' could not be retrieved . reason code 4.", when we tried to add the first database after installed DB2 Connect 5.2 on a NT server.
James Wang Sr. Systems Programmer Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com
21237 101 29_Re: DB2 Connect msg SQL10007N14_McCombs, Terry20_tmccomb@SEDGWICK.GOV31_Fri, 25 Feb 2000 12:54:02 -0600467_iso-8859-1 What the SQL10007N message means is that it doesn't know the meaning of the SQLCODE you got, which was 1092. What SQL1092N means is does not have the authority to perform the requested command. I hope that helps.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Wang.James Sent: Friday, February 25, 2000 12:50 PM To: DB2-L@RYCI.COM Subject: DB2 Connect msg SQL10007N Importance: High [...]
21339 21 31_Multiple SP addr spaces and WLM0_31_truman.g.brown@BELLATLANTIC.COM31_Fri, 25 Feb 2000 14:08:57 -0500568_us-ascii Our MVS guys are a little unclear (I'm not to clear myself) on the whats/whys/hows of multiple stored procedure address spaces using work load manager. The basics are clear enough, but what are the gotchas?
All my manuals and books don't get into this scenario.
Anybody doing this?
Thanks, George
================================================ 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.
21361 97 29_Re: DB2 Connect msg SQL10007N16_Galluzzo, Lori A21_lori.galluzzo@EDS.COM31_Fri, 25 Feb 2000 14:08:35 -0500432_iso-8859-1 We received this same msg, reason code & return code. This is how we fixed it. This problem is caused by not using the New Administrator User Id to create the database. Here is the documentation we used to do so.
index130BM__Toc446778178Create New Administration User ID
* BM__Toc444540461Needed for SEs, DB2 Connect Users and DBAs to add database in configuring DRDA Host Connections. [...]
21459 55 36_Visual Explain, Qualifier, and Owner13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Fri, 25 Feb 2000 14:27:41 -0500597_us-ascii Dear List:
We've got a connundrum that some of you may have wrassled with before.
1. We have Visual Explain v6, and we're testing it against DB2 V5 for OS/390. Our standards are to specify a constant table high-level qualifer for production tables of "SQLUSER". This used during Bind as QUALIFIER(SQLUSER).
Since we use RACF to control binds and table access, the Owner parameter of bind changes from program to program. For example, program XXX001 is bound with OWNER(XRGRP001). If we specify EXPLAIN(YES), then the Explain-ed rows go into XRGRP001.PLAN_TABLE. [...]
21515 21 26_Resident stored procedures12_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Fri, 25 Feb 2000 15:19:35 -0500501_iso-8859-1 We are in the process of moving stored procedures to our production environment. We have seen some performance problems and I'm quite sure that part of this is caused by the SPs not being resident. Our application folks are trying to find the right mix of DYNAM, RESIDENT, and REENTRANT and so far we are getting errors that say we cannot use the DYNAM option. Can anyone supply me the information as to what options are required, and is there anything else I need to warn them about. [...]
21537 21 34_DB2 Connect - Connection Scenarios17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Fri, 25 Feb 2000 14:31:30 -0600528_us-ascii How are most folks implementing DB2 Connect? Are you using a server as a gateway or going direct from a workstation to DB2? May be a dumb question considering my lack of knowledge in the area so please forgive me if that is so.
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.
21559 28 26_Re: regarding online entry13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 25 Feb 2000 15:41:25 -0500544_iso-8859-1 Hi Ravi, I think we need some clarification or more info to help you. What do you mean by "update a production table"? Are you being asked to update data rows in the table? or alter the table structure? You're asking about commits of other online work. If these are online transactions from CICS or IMS-TM, they are, unless you're doing something out of the ordinary, committed at each transaction completion. Why do you care about when that data is commited? Do you believe you need exclusive access? Please add these details. [...]
21588 35 38_Re: DB2 Connect - Connection Scenarios24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 25 Feb 2000 12:43:45 -0800603_- We use a little of both, but mostly through a server. The connect from an individual PC is limited to those clients who can't afford a server outage. Normally they access through the server, but can access directly if needed.
> -----Original Message----- > From: Gerald Bustamente [SMTP:ggbusta@LANDSEND.COM] > Sent: Friday, February 25, 2000 12:32 PM > To: DB2-L@RYCI.COM > Subject: DB2 Connect - Connection Scenarios > > How are most folks implementing DB2 Connect? Are you using a server as > a gateway or going direct from a workstation to DB2? May be a dumb > question considering my [...]
21624 24 34_MHannan's queries from the catalog13_Horacio Villa17_hvilla@TTI.COM.AR31_Fri, 25 Feb 2000 17:54:05 -0300356_iso-8859-1 Hi all,
some time ago, M. Hannan posted his queries from the catalog to generate CREATEs for objects in it. I thought I had them in my computer, but that's not true. I searched the archives but didn' find them. Can somebody help me to find them or send them to me? TIA Horacio Villa TTI SA Buenos Aires - Argentina hvilla@tti.com.ar [...]
21649 45 38_Re: DB2 Connect - Connection Scenarios17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Fri, 25 Feb 2000 15:09:45 -0600599_us-ascii Thank you for the courtesy of your prompt reply.
Jerry
Leblanc, Francis C - CNF wrote:
> We use a little of both, but mostly through a server. The connect from an > individual PC is limited to those clients who can't afford a server outage. > Normally they access through the server, but can access directly if needed. > > > -----Original Message----- > > From: Gerald Bustamente [SMTP:ggbusta@LANDSEND.COM] > > Sent: Friday, February 25, 2000 12:32 PM > > To: DB2-L@RYCI.COM > > Subject: DB2 Connect - Connection Scenarios > > > > How are most folks implementing [...]
21695 98 38_Re: DB2 Connect - Connection Scenarios11_Kurt Rompot21_RompotK@SCHNEIDER.COM31_Fri, 25 Feb 2000 15:36:48 -0600509_us-ascii Back at DB2 Tech Conference time, DB2 Connect Enterprise Edition was a requirement to exploit DRDA server list support. See the notes from Hugh Smith's presentation "Sysplex Workload Balancing in a Client Server World". Personal Edition may now support this as well, but I'm not sure.
We use Enterprise Edition here and are satisfied with it. You would probably be happiest with a mix of Personal and Enterprise. Use Personal for your really heavy users and Enterprise for everyone else. [...]
21794 78 40_Re: Visual Explain, Qualifier, and Owner9_Mark Ruhe15_mruhe@QUEST.COM31_Fri, 25 Feb 2000 13:47:00 -0800513_iso-8859-1 Generally explain products (CA Plan Analyzer DB Explain) perform this task by actually qualifying the SQL prior to the explain execution. Visual Explain (at least the NT version 6.1) does not have this ability. The rule has always been unqualified tables/views and the plan table are qualified by the current SQLID. If you want a different qualifier than you can either manually qualify the SQL or set your SQLID. The draw back is that you now need a plan table qualified with that new qualifier. [...]
21873 45 30_Re: Resident stored procedures17_Linda F. Claussen18_lindafc@NETINS.NET31_Fri, 25 Feb 2000 19:32:32 -0600746_ISO-8859-1 Andy,
Did you update the STAYRESIDENT column in the SYSPROCEDURES catalog table?
Linda F. Claussen Claussen & Associates DB2 Consulting and Training lindafc@netins.net http://www.netins.net/showcase/lclaussen/ Phone: (319) 343-3216 Office: (319) 847-1985
---------- From: Andy Wheeler To: DB2-L@RYCI.COM Subject: Resident stored procedures Date: Friday, February 25, 2000 2:19 PM
We are in the process of moving stored procedures to our production environment. We have seen some performance problems and I'm quite sure that part of this is caused by the SPs not being resident. Our application folks are trying to find the right mix of DYNAM, RESIDENT, and REENTRANT and so [...]
21919 62 30_Re: Resident stored procedures12_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Fri, 25 Feb 2000 20:49:46 -0500472_iso-8859-1 Yes I did. The problem may be that these SPs call assembler routines (date routines, etc.) and I'm not sure what affect that may have on residency.
Thanks, Andy
-----Original Message----- From: Linda F. Claussen [mailto:lindafc@NETINS.NET] Sent: Friday, February 25, 2000 7:33 PM To: DB2-L@RYCI.COM Subject: Re: Resident stored procedures
Andy,
Did you update the STAYRESIDENT column in the SYSPROCEDURES catalog table? [...]
21982 52 35_Re: Multiple SP addr spaces and WLM14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 26 Feb 2000 16:28:16 +1000452_- We are using multiple stored procedures. We have no problems.
I'm not sure if you have the same reason, but we use one for functions and procedures for a test environment, one for acceptance (since we can have an acceptance version of a function/procedure's code which has the same external name as a test version), one for production, one for test of phase 2 of the project which again has the same external names as phase 1, and so on. [...]
22035 25 13_SQLCODE -13500_15_Db2user@AOL.COM29_Sat, 26 Feb 2000 01:22:27 EST577_US-ASCII Can someone please tell me what SQLCODE -1350 means?
Platform: DB2 UDB 6.0 for AIX. I received the following error message when doing a load:
SQL3015N An SQL error "-1350" occurred during processing.
I checked the message manual and couldn't locate this particular sqlcode.
TIA.
David Taylor
================================================ 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.
22061 104 17_Re: SQLCODE -135014_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 26 Feb 2000 19:24:44 +1000766_iso-8859-1 Go to http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report Find Message Reference (grouped under Administration) select your desired format.
It seems that 1350 means:
SQL1350N The application is not in the correct state to process this request. Reason code=²².
Explanation: Corresponding to ²²:
01 The application is currently processing SQL and cannot process the utility command requested. 02 A Backup request is in progress. A warning was received from the initial utility call indicating that further requests are required before Backup can complete. 03 A Restore request is in progress. A warning was received from the initial utility call indicating that further requests are required before [...]
22166 30 10_XDB Vendor20_Ravinder Rao Machadi22_machadi_rrao@YAHOO.COM31_Sat, 26 Feb 2000 03:31:45 -0800436_us-ascii Hi Folks,
I'm looking for XDB Software to buy. Can somebody give me any vendor in or around India. Also if somebody could suggest good site for XDB, it would be highly appreciable.
Thanks Machadi
===== Thanks & Regards,
Ravinder Rao Machadi __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com [...]
22197 56 35_Re: Multiple SP addr spaces and WLM0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Sat, 26 Feb 2000 10:08:05 -0600571_us-ascii One item that we learned a couple weeks ago when we had an outage is that when you have WLM-Stored Procedures, that its very important when the system is being IPL'd, that RRS (Resource Recovery Services) comes up BEFORE DB2 comes up, otherwise your WLM-stored procedures won't work. (I'm thinking that IBM may have a fix for this now, but at the time, we didn't have it on and weren't aware this was a problem). (Probably doesn't matter if you have Multiple SP address spaces or one for this to be a problem, mainly if you are WLM-stored procedures, which [...]
22254 25 51_DB/2 5.1 to DB/2 6.1 Migration Question (on VM/ESA)11_Bill Pettit18_billp@ORMUTUAL.COM31_Sat, 26 Feb 2000 08:12:50 -0800365_iso-8859-1 Hi all,
I'm migrating a DB/2 5.1 database to DB/2 6.1 on VM/ESA.
I just realized that I ran the migration step to migrate the catalog (ARISMEX EXEC) with the DB/2 5.1 segments loaded on the machine I ran that step on.
Anyone out there today know if it is necessary to re-run that step or not? Or if I even can re-run it safely? [...]
22280 21 22_Communication database12_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Sat, 26 Feb 2000 13:26:50 -0500489_iso-8859-1 We are a DB2 5.1 shop with OS/390. We are trying to move data from one LPAR to another LPAR using the communication database and TCP/IP. I am receiving a -904, unavailable resource, reason code d31057, type of resource 1004. The error is saying the the entry in sysibm.location table can not find a corresponding linkname in the sysibm.ipnames table. I can join these two tables using the linkname and all expected rows are found. Any experience with this type of problem? [...]
22302 41 15_Machine Upgrade0_24_Ray.Price@DRESDNERKB.COM31_Sat, 26 Feb 2000 19:46:08 -0000374_- Hello.
Our system is OS/390 CICS/COBOL/DB2 (V4). We are in the process of upgrading our processor. We have one machine, but a choice of three large engines, or six smaller ones. Total power is about the same. Which is best for a CICS/DB2 system? What factors should influence our thinking?
Thanks.
Ray Price DBA Dresdner Kleinwort Benson London. [...]
22344 32 19_Re: Machine Upgrade0_17_JTonchick@AOL.COM29_Sat, 26 Feb 2000 16:29:21 EST579_US-ASCII We just went through a similar upgrade. We opted for the faster engines vs. more engines because we still have a significant batch workload. A COBOL program cannot exploit multiple engines like CICS and DB2 can. So since that was the bulk of the workload, we went that direction.
But you need to be on the lookout for looping tasks. If a programmer puts a program into a loop, there goes 1/3 your throughput until an operator notices that things are running late. With 6 engines, a looping task only "wastes" 1/6 of your throughput, so less of the scheduled [...]
22377 76 33_Re: DB2 to RACF: project planning12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Feb 2000 17:36:36 -0600393_- The customers I talk to who are happiest with the migration reduced their grants and revokes from many thousands to under 200, using patterns and RACF groups. I've never liked our secondary ids or authorities like BINDAGENT, and would push for conversion to RACF groups, but there is work to do to get the value back out, have more static authorization rules, avoid cascade revoke, ... [...]
22454 25 50_Re: Increased Column Name Length in DB2 for OS/39012_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Feb 2000 18:01:50 -0600390_- I'm sorry I missed the note last time, but longer names have never been part of the DB2 Version 6 work. The changes to the DB2 catalog would not be acceptable in an APAR to most customers. The size of the change inside DB2 is huge. It would be easy to miss one of the needed changes, so this will take us a while to get right. If you were thinking this is an easy change, it is not. [...]
22480 23 48_Re: REXX/DB2 Interface - Program Number 5764-07412_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Feb 2000 18:30:12 -0600390_- That looks like the one we called RXSQL. The syntax is quite different, but the function in the new feature has support for changes in our newer releases. For an example, you can have stored procedures in REXX. So the choices are to use the older one, with less function, no support or to convert. Since the cost is included with DB2 V5 and up, we expect almost everyone to convert. [...]
22504 29 54_Re: Differences 'tween Unix and OS/390 versions of DB212_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Feb 2000 18:56:06 -0600339_- Differences are tricky, as Craig noted. We did publish two versions of the IBM SQL Reference, SC26-8416. This was a better document than the one we called FRED. With Version 5, all of the differences from SQL 92 Entry level were removed. You can find the IBM SQL References in the CD-ROMs for DB2 family or IBMers can use Enterlib. [...]
22534 74 19_Re: Machine Upgrade10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Sat, 26 Feb 2000 20:39:53 -0800273_us-ascii You should examine your most CPU-intensive task to see if it exceeds the capacity of one CPU on the six-CPU machine. With some exceptions, tasks can only use one CPU. The machine with three larger CPUs may be a better choice in this case.
Bill Welch
22609 76 48_Platinum RCM problem - anyone else experiencing?0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Sun, 27 Feb 2000 10:39:03 -0600447_us-ascii Problem: We have been working with Platinum for the last 6 months on this problem with no resolution. We're told only one other company is experiencing this problem and unfotunately Platinum is unable to reproduce it, so I thought perhaps I could find that one other company on DB2L or perhaps (even better) another company that was experiencing it and found a solution that could help us or even any wild guesses anyone might have. [...]
22686 43 88_Loading data into DB2/UNIX via load command from DB2 OS/390 DSNTI AUL unload output file17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM31_Sun, 27 Feb 2000 12:58:16 -0500443_- I'm trying to unload data from DB2 OS/390 (via DSNTIAUL) and load into DB2 UNIX (Sun Solaris) via the load/replace command. I can get this to work when all of the columns are character data, but once I start using tables with numeric data (smallint, integer, decimal) and nullable columns, I start having problems. I've tried a variety of file type modifiers with the load command in DB2 UNIX but haven't hit the right combination yet. [...]
22730 71 91_Re: Loading data into DB2/UNIX via load command from DB2 OS/390 DSNTIAUL unload output file12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Sun, 27 Feb 2000 20:05:00 +0200356_x-user-defined Hi, Try to unload the numbers in character representation. EG: 1. select digits(number) - it is good if you don't have negative or decimal number as you loose the sign and precision. 2. select char(decimal(number,p,q)) where p & q adhere to the rules of decimal numbers. This way you get the negative sign and decimal point. Good luck, [...]
22802 133 92_Re: Loading data into DB2/UNIX via load command from DB2 OS/390 D SNTIAUL unload output file17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM31_Sun, 27 Feb 2000 14:41:40 -0500589_- I tried these suggestions, but am getting the following error message in the DB2 UNIX load command rejecting all of the rows.
SQL3118W The field value in row "1" and column "1" cannot be converted to a
SMALLINT value, but the target column is not nullable. The row was not
loaded.
The load command I'm using is: LOAD FROM QSTAFF.DATA OF ASC MODIFIED BY nullindchar=? reclen=53 METHOD L (1 5, 6 14, 16 20, 22 26, 28 32, 34 42, 44 52) NULL INDICATORS (0,15,21,27,33,43,53) REPLACE INTO GUSRT00D.QSTAFF ( ID, NAME, DEPT, JOB, YEARS, SALARY, COMM) ; [...]
22936 52 14_Re: XDB Vendor22_Lindsay, William (GES)24_WLindsay@EXCHANGE.ML.COM31_Sun, 27 Feb 2000 16:14:58 -0500292_iso-8859-1 Try http://www.merant.com
They acquired MicroFocus, and XDB a few years ago. I did a quick serach of the site, and found some support info for XDB, however you may have to contact them to find out how to acquire the product. They did not list it as far as I could see. [...]
22989 32 17_regarding loading17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Sun, 27 Feb 2000 13:17:49 PST512_- Hello Everybody,
in our shope we are using db2 v4. i need to load a data from PROD. to TEST region. but one table has a problem. the problem is
one table in PROD. has two columns. licke C1, C2. but the same table in TEST region has three columns C1, C2 and C3. while trying load a table from prod. to test i got an error saying that input data error. some body requested to add one more column in only TEST region. that is why i altered only in TEST region. but they don't want in PROD. now [...]
23022 49 14_Re: XDB Vendor22_Lindsay, William (GES)24_WLindsay@EXCHANGE.ML.COM31_Sun, 27 Feb 2000 16:17:56 -0500491_iso-8859-1 Oops found it. Its now called Mainframe Express "SQL Option for DB2"
Good Luck
Bill
-----Original Message----- From: Ravinder Rao Machadi [mailto:machadi_rrao@YAHOO.COM] Sent: Saturday, February 26, 2000 6:32 AM To: DB2-L@RYCI.COM Subject: XDB Vendor
Hi Folks,
I'm looking for XDB Software to buy. Can somebody give me any vendor in or around India. Also if somebody could suggest good site for XDB, it would be highly appreciable. [...]
23072 92 21_Re: regarding loading18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM31_Sun, 27 Feb 2000 18:01:19 -0500528_us-ascii Ravi,
Depending on the column definition for C3 in SYSIBM.SYSCOLUMNS you could LOAD the table in TEST in the following manner.
1) Column C3 is defined as NULLs as "Y" Use the PUNCH or CONTROL CARD from PRODUCTION in which the column C3 is omitted and it should work for you.
2) Column C3 is defined as NULLs as "N" and DEFAULTs as "Y" This definition ensures that the column cannot be NULL but even if you do not insert anything DB2 will insert SPACES if it is a CHAR or 0 if it is a DECIMAL. [...]
23165 27 35_Number of Locks by a single Process11_Rajakumar R19_Rajakumar_R@GAP.COM31_Sun, 27 Feb 2000 17:22:20 -0800436_us-ascii Dear LIST,
We have a process in which a single input has to be split into different records and to be given to different applications. We planned to have one table for each application, which will result in 13 to 15 tables. We feel if it is done this way, the number of concurrent locks by the same process will give a performance problem. The throughput of the system will be from 1250 to 1500 records per second. [...]
23193 40 29_Time consuming Load Processes18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM31_Sun, 27 Feb 2000 20:36:16 -0500356_us-ascii All,
I have this process that we run every weekend wherein we do the following:
1) Unload all the data from production for 327 Tables 2) Transfer all files in which data was unloaded to the Test machine by using NDM ( a software used to transfer files). 3) Load all the tables in the Test Environment with data from production. [...]
23234 54 48_Platinum RCM problem - anyone else experiencing?12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Sun, 27 Feb 2000 20:54:46 -0500541_ISO-8859-1 Hi Shan,
The first question is, on the TS's where you have the problem, is it reproduceable.
Have you tried cloning that object and then try the change again. This would isolate wether the problem is with the object or in the tool.
Now assuming both that you can reproduce it and that the problem persists with the cloned object, then you may want to take the rather unusual path that we had to on a problem, namely send the entire platinum loadlib to them along with the DDL for the object in question. [...]
23289 27 16_Porting Database30_GroupIT - Jenny Kuan Kong Lang19_jennykkl@MAS.COM.MY31_Mon, 28 Feb 2000 10:26:45 -0800603_us-ascii Hi,
We would be having applications distributed across various platforms with data stored on UDB i.e. DB2 for OS390, UDB on NT, UDB on AIX, UDB on OS/400. If we were to consolidate all our data centrally to be on a single platform i.e. OS/390, does anyone have any experience in porting UDB data from one platform e.g. NT to OS/390 or NT to AIX whilst the client application is developed using VB? Any gotchas in migrating stored procedures amicably across platforms? How much is the conversion effort/change impact to application, to databases, to stored procedure, etc. - if any. [...]
23317 90 33_Re: Time consuming Load Processes23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Mon, 28 Feb 2000 02:59:48 -0000666_iso-8859-1 can you put the data on shared disks to eliminate the copy step????
-----Original Message----- From: Kartik Subramanian [mailto:kartik.k.subramanian@BELLATLANTIC.COM] Sent: Monday, 28 February 2000 11:36 To: DB2-L@RYCI.COM Subject: Time consuming Load Processes
All,
I have this process that we run every weekend wherein we do the following:
1) Unload all the data from production for 327 Tables 2) Transfer all files in which data was unloaded to the Test machine by using NDM ( a software used to transfer files). 3) Load all the tables in the Test Environment with data from production. [...]
23408 82 33_Re: Time consuming Load Processes10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Mon, 28 Feb 2000 03:25:01 GMT524_us-ascii Kartik, Are u trying to load the data with LOG NO option ,i think LOG NO option is very much faster than LOG YES because in test machine lots of log writing may take very high time because of frequent log archiving process (may be if u have small size of the active log ).Usually we keep very small active log size and log buffers in test machine. If ur transferring of data is also taking very high time then why don't u try and keep the shared DASD for the production and test machine so that there will not [...]
23491 67 39_Re: Number of Locks by a single Process10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Mon, 28 Feb 2000 03:36:02 GMT469_us-ascii Hi Rajakumar, I think one table should be a better idea.If that table is transaction table ,i mean if the no. of records are very high then it is better to go for partitioned tablespace partitioned by applications and if that is a reference table then row level locking would be a good idea. I don't know much about the scenario which u are having now and what are the problems u are facing but this approach should be better for the maintenance purpose. [...]
23559 31 30_Re: Response to DSN1COPY Error17_suthep thampranee18_suthepth@SCB.CO.TH31_Mon, 28 Feb 2000 10:41:00 +0700622_ISO-8859-1 VICHY, I just got the same problem and error code few days ago. This following may be corrected your problem 1.Drop all index.(If you have partion index you do not have to drop it) 2.what is your tablespace? segment tablespace,simple tablespace ,partition tablespace 3.See the DB2/OS390 UTILITY AND REFERENCE about option If you have partition tablespace you should change fullcopy to numparts,' For example ; PARM='check,numparts(3)' 4.Rerun again 5.If it doesn't work.Try to change PARM until it works.(in my experience is all about PARM) 6.repair level id ( if neccessary) 7.recover index Good luck JOE [...]
23591 35 54_Re: Differences 'tween Unix and OS/390 versions of DB212_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 28 Feb 2000 14:57:24 +1300618_us-ascii Thanks for the reply, Roger. As an IBM-er (kind of, but not really) I have access to Enterlib but didn't really find what I was looking for. Partly because, as you say, it doesn't really exist yet. Mostly because I didn't know what to search for.
I appreciate the SQL will be very similar, if not identical, between the two. Personally I'm interested in environmental and administrative differences, like the term 'database' in Unix being a kind of combination of 'database' and 'subsystem' in OS/390 (I'm thinking of separate log datasets, catalog tables, etc.) and how 'instance' fits in. Maybe [...]
23627 30 33_Re: Time consuming Load Processes17_suthep thampranee18_suthepth@SCB.CO.TH31_Mon, 28 Feb 2000 10:55:41 +0700463_ISO-8859-1 Kartik In my site,we do not have to use tool to transfer file from production site to test site.How can i do? first: tell the system programmer to set up the special volume that can see production site and test site(develop site) . (can online both sites) second : unload the data from production site to the special volume third : catalog data set name in test site fourtht : load data to test site(if you want to load fast you have to buy tool) [...]
23658 35 32_SQL4411N - Administration Server0_15_Db2user@AOL.COM29_Sun, 27 Feb 2000 22:48:07 EST370_US-ASCII Hi all,
I encountered the following error when I clicked on "connection" for a database in Control Center. We are using UDB 6.1 for NT to connect to UDB 6.1 which is running on AIX. The description for the error is as follows:
"SQL4411N The requested operation is not allowed because the server instance is not the DB2 Administration Server. [...]
23694 32 48_Re: REXX/DB2 Interface - Program Number 5764-07414_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 28 Feb 2000 08:56:30 +0100321_us-ascii I'm wondering why very few programmers/administrators (may be no one as far as I know) use
DB2WWWX, a REXX/DB2 interface we use a lot since 1998.
It's a simple interface but we find it very useful for administration EXECs . Is it possible that no one knows this nice features ( and free !!) ? [...]
23727 38 28_ACS routines for SAP objects13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 28 Feb 2000 11:53:07 +0000574_us-ascii Hi folks,
I'm currently working on an HR implementation using SAP R/3 v.4.5b. At a previous site we implemented ACS routines for v.4.0 based on the database and tablespace names i.e. if the 3rd and 4th dataset qualifiers were the same, or matched a certain mask, we assumed that the object was a tablespace. 99 times out 100 this worked, and we were able to keep indexes away from tablespaces. However, with v.4.5b, this has all changed, and the database name no bears no resemblance to the tablespace name. So I am now trying to figure out how to keep [...]
23766 80 52_Re: Platinum RCM problem - anyone else experiencing?0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Mon, 28 Feb 2000 07:37:26 -0600613_us-ascii Dennis,
We hadn't thought of sending the platinum loadlib. We've told them its release P97D assuming they would resurrect ddl under that loadlib, but thats a good suggestion as there may be something different in our loadlib that causes the problem that isn't in theirs. Good idea.
We have FTP'd output and emailed DDL (multiple times for multiple objects) to Platinum to recreate the problem. We had instances where we had two objects of the exact same table (test and development) defined in their own ts and db where one worked and one didn't. While they both looked exactly alike, [...]
23847 242 62_Repost: LAWSON DELIVERS IBM DB2 UNIVERSAL DATABASE INTEGRATION13_Morrill, John12_JohnM@VP.NET31_Mon, 28 Feb 2000 06:41:39 -0700502_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:04 PM --------------------------- [...]
24090 259 63_Repost: DB2 Prentice Hall Publications Available - Updated List13_Morrill, John12_JohnM@VP.NET31_Mon, 28 Feb 2000 06:41:39 -0700502_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:03 PM --------------------------- [...]
24350 271 46_Repost: DB2 Today Issue VII and "My DB2 Today"13_Morrill, John12_JohnM@VP.NET31_Mon, 28 Feb 2000 06:41:39 -0700502_iso-8859-1 Greetings!
Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.
Cheers!
J. Michael Morrill Chief DB2-L List Owner
=================================================
---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:03 PM --------------------------- [...]
24622 68 36_Re: SQL4411N - Administration Server15_Anthony Van Zyl21_Anthony@NEURATECH.COM31_Mon, 28 Feb 2000 16:16:51 +0200627_iso-8859-1 Hello David
I had this problem when I wasn't in the group set to be System Admin on the DB2 Admin server. Check the group with
DB2 GET ADMIN CFG
and check your settings for SYSADMIN group name.
My experience is only on NT, though.
Cheers Anthony
> -----Original Message----- > From: Db2user@AOL.COM [mailto:Db2user@AOL.COM] > Sent: Monday, February 28, 2000 5:48 AM > To: DB2-L@RYCI.COM > Subject: SQL4411N - Administration Server > > > Hi all, > > I encountered the following error when I clicked on > "connection" for a database in Control Center. > We are using UDB [...]
24691 67 32_Re: ACS routines for SAP objects12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Mon, 28 Feb 2000 14:56:00 -0000413_- We use seperate VCAT's without any problems, we use an HLQ of the form xxxt.
where xxx is the application identifier and t is T for table or I for index, of course, you wouldn't want too many splits.
Colin Allen, DB2 DBA Abbey National
Colin.Allen@AbbeyNational.Co.Uk ---------- From: Adrian Savory To: DB2-L@RYCI.COM Subject: ACS routines for SAP objects Date: 28 February 2000 11:53 [...]
24759 24 14_db2-l@ryci.com12_Greg Popwell27_greg.popwell@MOTION-IND.COM31_Mon, 28 Feb 2000 09:02:33 -0600387_iso-8859-1 Hello,
I've been running IBM's version of DB2 Online Reorg (SHRLEVEL CHANGE) for OS/390 V5 for a few weeks now. Twice now I've gotten code C90101 indicating data inconsistency. The 1st time was on the Map Table Index. This past weekend it occurred on an application index. The Build Phase had just completed so I assume that the error happened in the Build Phase. [...]
24784 51 20_Re: Porting Database24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Mon, 28 Feb 2000 10:05:47 -0800593_us-ascii Jenny, If you use DB2 Connect between the NT/AIX and OS/390 platforms, the porting should be transparent.
Frank
On Mon, 28 Feb 2000 10:26:45 -0800, GroupIT - Jenny Kuan Kong Lang wrote:
>Hi, > >We would be having applications distributed across various platforms >with data stored on UDB i.e. DB2 for OS390, UDB on NT, UDB on AIX, UDB >on OS/400. If we were to consolidate all our data centrally to be on a >single platform i.e. OS/390, does anyone have any experience in porting >UDB data from one platform e.g. NT to OS/390 or NT to AIX whilst the [...]
24836 23 18_Re: db2-l@ryci.com14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 28 Feb 2000 16:08:05 +0100504_us-ascii Did the problem happen in a secondary index ? I had problems on secondary indexes
reorganizing a partitioned tablespace (with a 00C90101 error). It was a problem in secondary
indexes keys.
Just a curiosity.
Regards Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
24860 43 42_Re: db2-l@ryci.com(C90101 in Online Reorg)12_Greg Popwell27_greg.popwell@MOTION-IND.COM31_Mon, 28 Feb 2000 09:20:56 -0600430_iso-8859-1 Max,
Yes it was a secondary index(NPI) on a partitioned tablespace, but I wasn't reorging the tablespace, just the index.
Greg Popwell
-----Original Message----- From: Massimo Scarpa [mailto:mscarpa@CESVE.IT] Sent: Monday, February 28, 2000 9:08 AM To: DB2-L@RYCI.COM Subject: Re: db2-l@ryci.com
Did the problem happen in a secondary index ? I had problems on secondary indexes [...]
24904 100 33_SV: Time consuming Load Processes12_Nurmi, Seppo23_Seppo.Nurmi@RIKSBANK.SE31_Mon, 28 Feb 2000 16:23:10 +0100430_iso-8859-1 In some sites security policy forbids usage of shared dasd. It may also cause enque problems if you do not have GRS, MIM or other products that take care of the device enques.
FTP is a fast method transfering data. It is included in OS/390 but must be customized. Talk to your MVS people. I use a ISPF/Rexx freeware FTBP (FTP batch). It needs some customization, an easy task for anyone who can write Rexx. [...]
25005 54 55_Re: DB/2 5.1 to DB/2 6.1 Migration Question (on VM/ESA)24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Mon, 28 Feb 2000 10:18:39 -0800536_us-ascii Bill, I don't know if it's necessary to rerun, but the Program Directory used with VM/SES should tell you whether the step *can* be rerun. Alternatively, you can archive the database, rerun, and see what happens. Finally are you sure that the ARISMEX used the segments or did it run from the code in the virtual machine? If it's the latter you don't need to rerun as all. The choice would be governed by the startup parms the job used and I suspect it uses the code rather than the DCSSs for the very reason you describe. [...]
25060 29 23_DB2 connect w/ MS Query9_John Reid14_jreid@FBFS.COM31_Mon, 28 Feb 2000 09:47:11 -0600446_us-ascii Hi list,
Has any one had any problems with using MS QUERY retrieving DB2 OS/390 data using DB2 Connect?
We are trying to create MS EXCEL spreadsheets using some data from DB2 tables and continually get a fatal exception in app msqry32.dbg( MS EXCEL is using MS QUERY). We can get data from DB2 tables using MS ACCESS and DB2 Connect with no problems. Has any one encountered this before and if so how was it resolved. [...]
25090 87 36_Re: SQL4411N - Administration Server0_15_Db2user@AOL.COM29_Mon, 28 Feb 2000 10:44:55 EST405_US-ASCII Thanks Anthony for the quick reply.
On client: "db2 get admin cfg" showed that sysadm group was not set. So I set it up, it didn't seem to help after the client was re-started. However I also noticed this on the AIX server side, which may be related to my problem: when I did a "db2 admin get admin cfg", I got "DB2 21022E Unable to switch to administration server instance 'db2as'." [...]
25178 27 42_Re: db2-l@ryci.com(C90101 in Online Reorg)14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 28 Feb 2000 16:50:12 +0100410_us-ascii I was (almost) sure ......In our shop the reorged secondary index had many keys with no
referenced data rows (the keys were pointing somewhere outside solar system....) as it was clear running a CHECK INDEX.
I think there's some bug in reorging partitioned tablespace and/or secondary indexes with
SHRLEVEL REFERENCE (and with new features of reorg like REORG DISCARD too) . [...]
25206 18 14_EDM definition13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Mon, 28 Feb 2000 10:56:07 -0500453_us-ascii I have looked and have not found definition of EDM pool... I know what it is, and what it composed of but not what the letters mean. Not important, but would like to know definitions of acronyms. thanks
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
25225 42 18_Re: EDM definition12_Vernon, John27_John.Vernon@TWC.STATE.TX.US31_Mon, 28 Feb 2000 10:02:58 -0600691_- Environmental Descriptor Management
John Vernon DB2 System Administrator Texas WorkForce Commission 101 East 15th Street Austin, Texas 78778 Vice-President, Heart of Texas DB2 Users Group Email: john.vernon@twc.state.tx.us jvernonrr@aol.com Phone: 512-936-3170 Fax: 512-936-3190 "Ability may get you to the top, but it takes character to keep you there."
> -----Original Message----- > From: Jimmy Willett [SMTP:Jimmy.Willett@NCMAIL.NET] > Sent: Monday, February 28, 2000 9:56 AM > To: DB2-L@RYCI.COM > Subject: EDM definition > > I have looked and have not found definition of EDM pool... > I know what it is, and what it composed of but not what the letters > [...]
25268 30 18_Re: EDM definition24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Mon, 28 Feb 2000 11:01:12 -0500465_iso-8859-1 I seem to remember it being Environment Descriptor Manager
-----Original Message----- From: Jimmy Willett [mailto:Jimmy.Willett@NCMAIL.NET] Sent: Monday, February 28, 2000 10:56 AM To: DB2-L@RYCI.COM Subject: EDM definition
I have looked and have not found definition of EDM pool... I know what it is, and what it composed of but not what the letters mean. Not important, but would like to know definitions of acronyms. thanks [...]
25299 62 27_Re: DB2 connect w/ MS Query15_Craig Wahlmeier27_cwahlmeier@DATA-TRONICS.COM31_Mon, 28 Feb 2000 10:06:06 -0600324_iso-8859-1 John
What version and fixpak levels are DB2 Connect and the DB2 Client Application Enabler at? What are patch1 and patch2 set to? (Look in DB2CLI.INI on the client.) Are you trying to use the "Excel Query Wizard", (which doesn't work)? Have you tried it on another client machine?
Let us know, [...]
25362 30 37_Java applet error with JDBC - UDB 6.115_Aniruddha Garud24_Aniruddha.Garud@WCOM.COM31_Mon, 28 Feb 2000 11:21:53 -0500412_- Hi All,
I am using personal edition of UDB6.1 on Win'95. While running the sample applet from IBM through Internet explorer 5.0 I get an error - java.lang.Illegal.Access.Exception (when viewed through the 'java console'). The message at the bottom of the explorer is something like - 'not a public class'. I tried to put and run this applet via the Trustlib (trusted library) but it does not work. [...]
25393 53 18_Re: EDM definition13_Steve Spurgin37_Steve.Spurgin@SCOTTISH-SOUTHERN.CO.UK31_Mon, 28 Feb 2000 16:14:32 +0000863_us-ascii Extract below from V5 Installation Guide (EDM Pool Size Calculation)
'The environmental descriptor manager (EDM) pool contains active and skeleton application plans and packages, as well as database descriptors'.
see: http://www.s390.ibm.com:80/bookmgr-cgi/bookmgr.cmd/BOOKS/DSNIG0F5/2%2e2%2e4%2e4?SHELF=DSNSH0F5
Steve
********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and [...]
25447 23 30_Boston DB2 Symposium Next Week16_Richard A Yevich21_ryevich@BELLSOUTH.NET31_Mon, 28 Feb 2000 10:27:45 -0500516_iso-8859-1 *** Boston March 8-9-10 *** *** DB2 Family Events *** *** 12 full day seminars *** Richard Yevich Klaas Brant Joel Goldstein Rick v.d. Lans Susan Lawson Sheryl Larsen Martin Hubel
www.db2-symposium.com
Need more info, send email to: info@ylassoc.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
25471 98 30_Re: Resident stored procedures0_19_Tim.Lowe@STPAUL.COM31_Mon, 28 Feb 2000 11:32:26 -0600602_us-ascii Andy, I do not understand why you would encounter this problem "moving to production", if the problem is that you are using the DYNAM compiler option, then I would have expected that you would have seen this problem in testing.
The documented method for using the DYNAM compiler option in a DB2 stored procedure is to use the DB2 precompiler option ATTACH(CAF) so that the precompiler inserts call to DSNHLI2 instead of DSNHLI. (DSNHLI is the alias for DSNELI, the TSO attach. DSNHLI2 is the alias for DSNALI, the CAF attach.) If your stored procedures are running under WLM, then [...]
25570 39 57_Re: Products that archive and restore DB2 historical data10_Mark Labby16_mlabby@PHEAA.ORG31_Mon, 28 Feb 2000 12:36:39 -0500265_us-ascii I have a little experience with the product since we were a beta test site for it. As of now, we haven't used it in any production mode and are still evaluating the purchase of it. I'm not sure if I can answer your questions, but am willing to try... [...]
25610 106 52_Re: Platinum RCM problem - anyone else experiencing?9_Rob Crane22_racrane@CONCENTRIC.NET31_Mon, 28 Feb 2000 10:59:22 -0700570_us-ascii If you also own Log Analyzer, look for changes to SYSIBM.SYSTABLESPACE for the 20 tablespaces you mentioned you were receiving this error on. If no changes are occurring, send that output to Tech Support as well. Could another process or person be changing the tablespaces in another strategy or outside of RC/Migrator? Make sure the system where you did the analysis is the same as where it is running (I have seen cases where the an analysis was run against a copy of the catalog (ACM) but the strategy was run against the live catalog and the 2 are not [...]
25717 34 40_No. of qualifying rows at declare cursor13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM31_Mon, 28 Feb 2000 12:59:55 -0500298_us-ascii Hi All , I am declaring a curson for retrieving records based on a given last name . Chances are that for certain last names , many rows would qualify .
The query is like this :
Declare C1 cursor for Select A , B , C from Table1 where lname = ' xxx ' order by A , B , C [...]
25752 26 30_PeopleSoft Roles - Tax Updates13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 28 Feb 2000 11:56:05 -0600420_iso-8859-1 Hi, For those sites which have PeopleSoft HR running on the OS390 environment.
Who is responsible for applying Tax Updates and upgrades to the system. Is it the DBA section or does someone who specializes in PeopleSoft - PeopleSoft administrator.
I am interested how other sites handle this.
Thanks Glenn Mackey GuideOne Insurance DB2 DBA Phone: (515) 267 5767 Pager: (515) 241 1627 [...]
25779 63 33_Re: Time consuming Load Processes12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 28 Feb 2000 20:11:17 +0200551_x-user-defined Hi, IF (and it's a BIG IF) structures are the same you may try using DSN1COPY (for both data nad index).
Isaac Yassin
Kartik Subramanian wrote: > > All, > > I have this process that we run every weekend wherein we do the following: > > 1) Unload all the data from production for 327 Tables > 2) Transfer all files in which data was unloaded to the Test machine by using > NDM ( a software used to transfer files). > 3) Load all the tables in the Test Environment with data from production. > > Step 1 [...]
25843 34 15_large databases17_John Breidenstine31_JBreidenstine@LEGIS.STATE.PA.US31_Mon, 28 Feb 2000 13:18:13 -0500435_iso-8859-1 Hello everyone, We are relatively new to DB2. We have DB2 V6.1 EE. We are curious what has been done by other shops to handle the following situation.
We have 3 applications 1) Payroll - 100 tables 2) Group Accounting System - 50 tables 3) Treasury - 5 tables There are some tables that should to be shared between Treasury and Payroll and some tables that should be shared between Group Accounting and Payroll. [...]
25878 47 34_Re: PeopleSoft Roles - Tax Updates16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Mon, 28 Feb 2000 13:17:13 -0500504_iso-8859-1 Glenn, We started with the DBA but found the developer/PS admin was better suited to handle 95% of the tasks with the DBA 'on standby' to review alter or create scripts. Program uploads to MVS and server updates to production are still handled by the DBA. Steve Cockerill slcockerill@nationalgypsum.com
-----Original Message----- From: Mackey, Glenn [mailto:GMackey@GUIDEMAIL.COM] Sent: Monday, February 28, 2000 12:56 PM To: DB2-L@RYCI.COM Subject: PeopleSoft Roles - Tax Updates [...]
25926 27 8_Question7_Holup's19_rholup@MEGSINET.NET31_Mon, 28 Feb 2000 11:52:10 -0600382_iso-8859-1 With in the SELECT statement in DB2, there are 3 parts to the FROM clause
location.owner.tablename
When developing DB2 application for a distributed system, can an application program access DB2 table data from multiple locations? Can a program access data from tables in multiple DB2 sub-systems? Can sub-systems span multiple systems and/or regions? [...]
25954 53 57_Re: Products that archive and restore DB2 historical data0_24_Munwar.Malik@ACS-GSG.COM31_Mon, 28 Feb 2000 13:37:45 -0500580_US-ASCII IBM has a product call DB2 Row Archive Manager
______________________________ Reply Separator _________________________________ Subject: Re: Products that archive and restore DB2 historical data Author: DB2 Data Base Discussion List at Internet Date: 2/28/00 12:36 PM
I have a little experience with the product since we were a beta test site for it. As of now, we haven't used it in any production mode and are still evaluating the purchase of it. I'm not sure if I can answer your questions, but am willing to try... [...]
26008 106 33_Re: Time consuming Load Processes13_Brendan Friel18_b.friel@PECORP.COM31_Mon, 28 Feb 2000 12:42:13 -0600438_iso-8859-1 I successfully have used DSN1COPY to achieve a very similar refresh of test environments from production. We set up an automated stream to generate the JCL and control cards using some fairly simple REXX code.
We automatically generated SYSXLAT cards to translate the OBIDs and whatever other IDs. This is the area where you can get into major league problems if these don't match. We used REBUILD for the indexes. [...]
26115 25 25_Runstats & Catalog Access12_Kapil Mathur25_Kapil.Mathur@WACHOVIA.COM31_Mon, 28 Feb 2000 13:55:53 -0500610_us-ascii hi, I am working in a DB2 V5 on OS/390 environment and I need clarification re: Runstats utility executed against the System Catalog tables. According to the IBM Utility Guide & Reference, DB2 uses the statistics collected on the catalog to determine the access-path for user queries - but not for it's own internal access to catalog tables. Is this statement unconditionally correct? If so, does this logically imply that there is no merit to ever reorganizing the system catalog tables unless I would like to optimize execution of user SPUFIs and 3rd party tools like Platinum RC/Query and BMC [...]
26141 142 33_Re: Time consuming Load Processes14_Bistricer, Avi20_BistricerA@CONED.COM31_Mon, 28 Feb 2000 14:02:19 -0500500_- Can you post the REXX to create the translations Ids? Avi Bistricer, DBA 212.460.6695
-----Original Message----- From: Brendan Friel [SMTP:b.friel@PECORP.COM] Sent: Monday, February 28, 2000 1:42 PM To: DB2-L@RYCI.COM Subject: Re: Time consuming Load Processes
I successfully have used DSN1COPY to achieve a very similar refresh of test environments from production. We set up an automated stream to generate the JCL and control cards using some fairly simple REXX code. [...]
26284 41 29_Re: Runstats & Catalog Access13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 28 Feb 2000 13:03:18 -0600418_iso-8859-1 I cannot comment on internal access, but I think benefit could be gained by having indexes and data reorganized to support clustering efficiencies, the removal of relocated rows and honor freespace/etc. specifications.
-----Original Message----- From: Kapil Mathur [mailto:Kapil.Mathur@WACHOVIA.COM] Sent: Monday, February 28, 2000 12:56 PM To: DB2-L@RYCI.COM Subject: Runstats & Catalog Access [...]
26326 41 29_Re: Runstats & Catalog Access20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 28 Feb 2000 14:13:18 -0500628_us-ascii That is correct. Internal access is not affected by runstats or reorg. Only user query could see improvement when you reorg catalogs.
> -----Original Message----- > From: Kapil Mathur [SMTP:Kapil.Mathur@WACHOVIA.COM] > Sent: Monday, February 28, 2000 1:56 PM > To: DB2-L@RYCI.COM > Subject: Runstats & Catalog Access > > hi, > I am working in a DB2 V5 on OS/390 environment and I need > clarification re: Runstats utility executed against the System Catalog > tables. According to the IBM Utility Guide & Reference, DB2 uses the > statistics collected on the catalog to determine the access-path for user > [...]
26368 46 34_Re: PeopleSoft Roles - Tax Updates22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Mon, 28 Feb 2000 11:15:28 -0800613_- The applications folks create the scripts and pass them along to the DBA's here. We review the scripts and make any necessary changes and execute them. We do not allow alters, creates, etc to be done by anyone other than a DBA.
HTH
Marty.
> -----Original Message----- > From: Mackey, Glenn [SMTP:GMackey@GUIDEMAIL.COM] > Sent: Monday, February 28, 2000 9:56 AM > To: DB2-L@RYCI.COM > Subject: PeopleSoft Roles - Tax Updates > > Hi, > For those sites which have PeopleSoft HR running on the OS390 environment. > > Who is responsible for applying Tax Updates and upgrades to the system. [...]
26415 43 15_Job Opportunity26_Palladian Consulting, Inc.28_info@PALLADIANCONSULTING.COM31_Mon, 28 Feb 2000 10:02:49 -0700686_iso-8859-1 Palladian Consulting has a client requiring the services of one Project Manager for a 5-month contract located in Austin, Texas (USA) to perform the following:
DESCRIPTION: The client requires the services of one Project Manager. The consultant will be expected to provide project management consultation, quality assurance services, coordination, advice, support, analysis, and technical writing and assistance for the project. The project scope will include: system analysis, design, database development, Web publishing, electronic mail communications, credit card validations services, electronic direct bank deposits and management supervision applications. [...]
26459 100 33_Re: Time consuming Load Processes16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Mon, 28 Feb 2000 12:25:26 -0700583_- Kartik,
We in doing exactly the same as what as you are attempting to do. If your production and test machines are in the same relative physical location, you might want to explore the possibility of using cross-center cataloguing of the datasets. This will avoid the need to have the data transferred via NDM, which as you stated, can take quite a bit of time. I concur with Isaac Yassin in the possible use of DSN1COPY to place the data in your test environment. Things to take into consideration using this technique, is the probability of ID translation during the [...]
26560 201 92_Re: Loading data into DB2/UNIX via load command from DB2 OS/390 D SNTIAUL unload output file11_Robert Lake20_robert.lake@CONTI.DE31_Mon, 28 Feb 2000 20:34:40 +0100574_us-ascii The error is almost certainly due to the way in which the file has been FTPd.
There are a couple of things to be careful about when transferring the file:
If you FTPd in binary (image) mode then you will get the error you have mentioned using the specified load control cards. This is because you are loading data with an EBCDIC code page into an ASCII target. At load time the utility will attempt to convert the character representation of a number into the appropriate numeric. Taking column 1 row 1 of your data in hex representation we have [...]
26762 116 29_Re: Runstats & Catalog Access16_Richard A Yevich21_ryevich@BELLSOUTH.NET31_Mon, 28 Feb 2000 13:50:26 -0500660_iso-8859-1 Is it okay Pillay if I disagree? And I am sure some others will also. The catalog has many varchar columns, that if used, can cause indirect reference which cause double I/O during access (bind, rebinds, REPORT(vars), all dynamic SQL, security access, and more.
There are major documented sites that have experienced measureable increases in performance throughput by catalog reorganizations. In most companies, Runstats and reorgs on the catalog are necesary and should be part of normal maintenance. And this will only get worse, not better, with all the varchar parameter definitions for stored procedures, UDFs, tirggers, and so on. [...]
26879 40 28_CATMAINT - Generic question.0_14_dcreed@CSC.COM31_Mon, 28 Feb 2000 14:35:04 -0600562_us-ascii Is there a way to determine what CATMAINT have already been ran?
To clarify: I know the importance of CATMAINT jobs .. etc . I also know that each APAR (holddata) will identify the instructions on identification as to whether the CATMAINT needs to be run. For example, count of rows, CHECK INDEX .. etc. I also know that you would have been very careless (perhaps mildly put) to not have ran the CATMAINT at the time the maintenance was installed. I was just wondering if you were to be placed in an environment with no knowledge of who did [...]
26920 193 47_Re: Replace Into option for Simple Tablespace !23_AITHA, BHEEMSEN (SBCSI)23_B4AITHA@MSG.PACBELL.COM31_Mon, 28 Feb 2000 12:54:37 -0800617_iso-8859-1 Toine,
Can also please send me this code(if possible) to my personal email id which is below.
b4aitha@msg.pacbell.com
Thanx..
-----Original Message----- From: Toine Michielse [mailto:vndobtm@US.IBM.COM] Sent: Friday, February 18, 2000 3:20 AM To: DB2-L@RYCI.COM Subject: Re: Replace Into option for Simple Tablespace !
Hello,
Colin, thanks for jumping in and providing the URL. I checkes. It's out there undert the tile 'a safer DB2 load utility' I noticed only the code it out there. If you;re interested I should be able to digup the whole article. [...]
27114 160 29_Re: Runstats & Catalog Access20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 28 Feb 2000 16:04:42 -0500332_iso-8859-1 Richard
I didn't say that runstats / reorgs on catalogs are not useful. I only mentioned about internal accesses and thought that the internal DB2 access are not affected but user queries on catalog do.
But as you pointed out that internal accesses also have improvement and that is a good news to me. [...]
27275 48 18_Re: db2-l@ryci.com11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM31_Mon, 28 Feb 2000 09:02:57 -0600759_us-ascii Yes, When we first went to Version 5, we received these with alarming regularity. Get very current on your maintenance and they should go away.
Greg Popwell on 02/28/2000 09:02:33 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Ray H Janes/C/Dallas/Mobil-Notes) Subject: db2-l@ryci.com
Hello,
I've been running IBM's version of DB2 Online Reorg (SHRLEVEL CHANGE) for OS/390 V5 for a few weeks now. Twice now I've gotten code C90101 indicating data inconsistency. The 1st time was on the Map Table Index. This past weekend it occurred on an application index. The Build Phase [...]
27324 72 19_Re: large databases13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Mon, 28 Feb 2000 17:41:23 CST307_- Well i have a very famour answers for you ... it depends .... depends on many variables/requirements.
In general putting all eggs in one basket means, if you have to bring down the instance you have to co-ordinate with all three groups. But then again it may or may not suit your environment. [...]
27397 34 39_DB2 Enterprise Edition and perl DBD/DBI20_Stephen Andrew Misel16_smisel@EPOCH.NET31_Mon, 28 Feb 2000 17:37:42 -0800408_us-ascii Hey folks.
This is my first posting to the list.. I'm working on a project involving DB2 and Perl. I'm *really* green on the DB2 thing, although I've worked with other databases (namely Oracle and Sybase) for many years.
First, I'm having trouble understanding how to connect to a remote DB2 instance with DBD/DBI. I've tried the following recommended methods (from DBI perldoc). [...]
27432 46 43_DB2 V5, type 2 indexes and currentdata(yes)0_23_john.lantz@ZURICHUS.COM31_Mon, 28 Feb 2000 23:18:05 -0500378_us-ascii We have an interesting problem. There is an SQL statement: DECLARE BSTS CURSOR FOR SELECT * FROM YAUDBSTS O WHERE POLICY_NBR = : TAUDINVT-POLICY-NBR AND POLICY_EFF_DT = : TAUDINVT-POLICY-EFF-DT AND NOT EXISTS ( SELECT * FROM YAUDBSTS I WHERE I . POLICY_NBR = O . POLICY_NBR AND I . POLICY_EFF_DT = O . POLICY_EFF_DT AND ( I . TRANS_CD = '71' OR LOB LIKE '54%' ) ) [...]
27479 82 12_Re: Question14_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Mon, 28 Feb 2000 21:51:18 -0800519_- Roland,
Here are some brief answers to your questions;
An application program can access DB2 table data from multiple locations, either via 3 part names as in your example or via the CONNECT SQL statement. Use of CONNECT implies the use of DRDA protocols. Prior to V6 use of 3 part names implied use of private protocols - support for this is being withdrawn in the future so V6 offers a new BIND option allowing the use of DRDA with 3 part names. If you're just starting out, plan to use CONNECT. [...]