1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2004, week 5
2 11 7_Re: UDF9_Le Nguyen20_lbnguyen@METLIFE.COM31_Sun, 29 Aug 2004 09:59:09 -0500567_- Thanks James for your reply to confirm what I thought was the constraint with UDF in DB2 z/OS.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
14 170 40_Re: PUBLIC access to DB2 catalog tables?11_James Szabo18_jim.szabo@CORE.COM31_Sun, 29 Aug 2004 12:34:48 -0400681_iso-8859-1 John,
We grant public access to the catalog, are a financial institution, and have had no problems with audit.
In my mind, the only table that might have confidential information would be SYSCOLDIST. Consider this example:
You have an employee bonus table, with unique key employee-id plus date-granted, along with non-key column bonus-amount. If you build a two-column index and collect normal runstats, SYSCOLDIST would contain the percentage of records each first key column value represented. That would show you the percentage of records each employee received, or which dates bonuses were awarded, depending on which column is decided to [...]
185 25 59_Can I explain based on catalog tables with other qualifier?0_25_huangjianh@ICBCSDC.COM.CN31_Mon, 30 Aug 2004 11:54:26 +0800615_US-ASCII Hi List, In my enterprise, production and development sites are in different location. The application developers would like to explain their programs based on production catalog tables, which is not realistics. But we can unload the production catalog tables and load them into user tables with different qualifier, such as unload SYSIBM.SYSTABLES and load into PROD.SYSTABLES with same structure. But are there any ways to explain programs based on those fake catalog tables to let the programmers to see the access path on the production? Or any available tools to implement this kind of features? [...]
211 38 40_Re: PUBLIC access to DB2 catalog tables?15_Ruppel, Richard28_Richard_Ruppel@HOMEDEPOT.COM31_Mon, 30 Aug 2004 07:42:12 -0400372_us-ascii John,
You may also want to think about the tables in the communications database. SYSIBM.USERNAMES has an AUTHID and PASSWORD column. If you do distributed processing to a server that requires authentication, you must fill in these columns. That could potential give someone the ability to log into a server that they do not otherwise have access to. [...]
250 55 19_DB2 Started Tasks!!15_Daniel Sullivan18_DSullivan@MBTA.COM31_Mon, 30 Aug 2004 08:46:34 -0400526_US-ASCII Hello, Mainline Technical Support, an IBM Business partner, is telling me that the 5 DB2 started tasks can all stay at the same Dispatching Priority of FE which IRLM runs at by default because of the WLM Service Class of SYSSTC. Everything that I have read seems to state the contrary, of having IRLM being at FE and maybe DBM1 at a FD with MSTR, DIST & SPAS at FC. They did say however that SPAS could actually run lower but the rest could stay at FE. To me it would seem that you would want the Lock manager a [...]
306 59 45_Conditional Restart Record In Data Sharing DR13_Brunner Don J21_Don.J.Brunner@IRS.GOV31_Mon, 30 Aug 2004 09:03:20 -0400445_- The DB2 Admin Guide states that when creating a conditional restart record for disaster recovery in a Data Sharing environment, the ENDLRSN should be used in lieu of ENDRBA 'if the logs are not at a single point of consistency'. Would the successful execution of a ARCHIVE LOG SCOPE(GROUP) constitute both member's logs being at a single point of consistency and allow the use of ENDRBA on the conditional restart record for each member? [...]
366 45 63_Re: Can I explain based on catalog tables with other qualifier?13_Solecki, Rohn19_Rohn.Solecki@GWL.CA31_Mon, 30 Aug 2004 08:55:20 -0500591_iso-8859-1 We used to use a brute force approach. We simply setup a job that copied the appropriate stats from production and used them to update the development catalog. The theory being, ..."who cares if development access paths are not optimum since the table sizes are so small anyway..."
Rohn Solecki
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of huangjianh@ICBCSDC.COM.CN Sent: Sunday, August 29, 2004 10:54 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Can I explain based on catalog tables with other qualifier? [...]
412 60 63_Re: Can I explain based on catalog tables with other qualifier?12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Mon, 30 Aug 2004 09:59:22 -0500336_us-ascii Jeremy:
To do what you ask would require changing DB2 code by either a dynamic hook or through re-linkage key modules. It could be made to work, but I question the costs. There are many other factors that the optimizer takes into question when deciding an access path, e.g., CPU factors, Buffer Pool settings, etc. [...]
473 19 23_Modify utility question17_Harry Vijayakumar23_harry_vijay@HOTMAIL.COM31_Mon, 30 Aug 2004 10:29:13 -0500284_- Hello,
We are a shop running DB2 for OS/390 v7.1 on a z/OS box. I want to know if there is a way to remove all references to recovery site imagecopies in the SYSCOPY table. I looked up the modify utility but did not see any flexibility there.
Please let me know. [...]
493 20 36_PUBLIC access to DB2 catalog tables?14_Mark McCormack27_mamccormack@STATESTREET.COM31_Mon, 30 Aug 2004 11:43:44 -0400326_US-ASCII John,
If you are concerned about who knows who is sysadm, or who can update a particular table, or who can bind a particular package, then you might want to restrict select access to the various sys---auth tables. I do not recommend this. I personally like select on DB2 catalog tables granted to public. [...]
514 56 27_Re: Modify utility question12_michael bell21_mbell11a1@VERIZON.NET31_Mon, 30 Aug 2004 10:53:27 -0500500_Windows-1252 Since your first step in a DR is to tell DB2 to use the recovery site image copies, using your current DB2 catalog, why would you do this? At the DR site everything would have to allocate the local copy which wouldn't exist at the DR site.
Mike
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Harry Vijayakumar Sent: Monday, August 30, 2004 10:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Modify utility question [...]
571 32 12_SQL question12_Billy Larsen19_billarsen@YAHOO.COM31_Mon, 30 Aug 2004 10:54:44 -0500396_- I have this table
ITEM STATUS COUNT 1 A 5 1 B 10 2 A 1 3 B 2
I want to have a report like this
ITEM COUNTA COUNTB 1 5 10 2 1 0 (...)
how can i achieve is ?
i feel that i can do it by a jointure of a table on itself , but can i do it with only one read pass ? (i am nearly sure that it is NO, but some of you can do impossible thing with sql ...) [...]
604 90 16_Re: SQL question0_33_armando.jorge.arranja@BANCOBPI.PT31_Mon, 30 Aug 2004 17:15:47 +0100551_us-ascii Tested!!!
SELECT A.ITEM, A.COUNTA,A.COUNTB FROM
(SELECT ITEM,
SUM(CASE STATUS WHEN 'A' THEN COUNT ELSE 0 END) AS COUNTA, SUM(CASE STATUS WHEN 'B' THEN COUNT ELSE 0 END) AS COUNTB FROM table GROUP BY ITEM) AS A
Best regards
Armando Arranja
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Billy Larsen Sent: segunda-feira, 30 de Agosto de 2004 16:55 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: SQL question [...]
695 73 16_Re: SQL question13_Charles Greer24_CGREER@SONOMA-COUNTY.ORG31_Mon, 30 Aug 2004 09:19:49 -0700460_US-ASCII If you know that you'll only have a maximum of two columns, you can do something like this:
select l.item,l.count as counta,r.count as countb from table l, table r where l.item=r.item and l.status<>r.status and r.count>l.count
Charles
Charles Greer Software Systems Analyst County of Sonoma, Geographic Information Systems 2615 Paulin Drive Santa Rosa, CA 95403 707-565-3991 FAX 707-565-2187 cgreer@sonoma-county.org [...]
769 99 23_Re: DB2 Started Tasks!!0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 30 Aug 2004 09:33:39 -0700393_- Dan, we have MSTR,IRLM,DBM1 and DIST all at SYSSTC. SPAS and the WLM tasks are set similarly to CICS regions and batch jobs. We haven't had any performance problems, then again we are a small shop. cliff:-)
-----Original Message----- From: Daniel Sullivan [mailto:DSullivan@MBTA.COM] Sent: Monday, August 30, 2004 5:47 AM To: DB2-L@www.idugdb2-l.org Subject: DB2 Started Tasks!! [...]
869 135 16_Re: SQL question14_Peter Backlund21_BacklundDB2@TELIA.COM31_Mon, 30 Aug 2004 18:36:08 +0200
1005 38 26_Dynamic SQL Cache behavior4_Gary32_databaseconsultant@SBCGLOBAL.NET31_Mon, 30 Aug 2004 11:43:50 -0500521_ISO-8859-1 I am attempting to alter an object that is used by dynamic SQL stmts and received a -904 reason 00E70081 which says that the object is referenced by a prepared dynamic SQL stmt in the DSC. I have never seen this. In fact at one time the only way to remove a prepared stmt from the cache was to alter the table. Now we can't alter the table anymore. I tried to do an alter audit all and even that received the error above. I tried runstats and that didn't free the lock. I did a display claimers and locks [...]
1044 199 23_Re: DB2 Started Tasks!!13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Mon, 30 Aug 2004 10:06:11 -0700551_us-ascii Hi Dan. We once hired Mainline to look over our shoulders, and in my opinion their specialists are every bit as good as the people who contribute to DB2-L. By the same token, whatever you read here may or may not apply to your shop, and the same goes for any "expert" recommendations you get, no matter how much you paid for them. And I have a real life experience that contradicts what Mainline is telling you. We used to run all DB2 address spaces at the same dispatching priority, until we had a problem with a certain jobstream that [...]
1244 79 30_Re: Dynamic SQL Cache behavior12_John Lendman27_lendman@PALMBEACH.K12.FL.US31_Mon, 30 Aug 2004 13:38:34 -0400499_iso-8859-1 We have been receiving this on our test system and our threads are coming from DDF. One brute force way that works for us is to stop DDF. Then restart it once the claim is dropped. Works for test, but not sure I want to do that to prod.
John C. Lendman IBM Certified Solutions Expert IBM Certified Database Administrator DB2 Universal Database V8.1 for zOS School District of Palm Beach County DBA Room B241 sub room b207 Office 561-357-7523 Email lendman@palmbeach.k12.fl.us [...]
1324 81 29_Statement Event Monitor Issue15_Jackson Reavill18_damcon2@US.IBM.COM31_Mon, 30 Aug 2004 13:54:04 -0400485_US-ASCII Hello,
I've created a statement event monitor in DB2 V8.1 FP2 on AIX, but I don't see any data being captured in the stmt table. However, the control and connheader tables have data. I've tried flushing the event monitor and I've double checked that it is enabled. There have been numerous SQL statements executed. All have been dynamic, but it's my understanding that it should capture dynamic SQL. Can someone please clue me in as to what it is I'm doing wrong? [...]
1406 115 23_Re: DB2 Started Tasks!!35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Mon, 30 Aug 2004 14:18:11 -0400524_iso-8859-1 Dan,
haven't checked the install docs for a couple of years, but the specified (decreasing) order of priorities was: IRLM MSTR DBM1 SPAS
When things are running normally, and your processor isn't maxed out, having the first three at the same priority won't hurt. But there is always that "other" situation when things may get a bit sticky. All backouts run at the priority of the MSTR address space. Then, even if something hurts, it has to more than a small pinprick to get your attention.... [...]
1522 24 32_SNAPSHOT_LOCKWAIT table function13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Mon, 30 Aug 2004 13:35:53 -0500439_iso-8859-1 Hi list,
I'm having trouble with the SNAPSHOT_LOCKWAIT table function. I got into the command line windows and issued and update against a test table with a +c to prevent the commit. I then brought up another command line window and issued the same update command. The second command obviously is waiting for the first one to commit, but when I do a SNAPSHOT_LOCKWAIT table function, I don't get any rows back. Why? [...]
1547 25 51_multiple high level qualifiers in one DB2 subsystem14_Amsden, John W27_John.Amsden@JPFINANCIAL.COM31_Mon, 30 Aug 2004 15:32:45 -0400413_iso-8859-1 Hello Listers,
We are running DB2 7.1 on Z/OS 1.04. We have a situation where it will be to our advantage to have more than one high level qualifier (VCAT)in one DB2 subsystem for our DB2 datasets. I know this can be done as we have done it. We just created a stogroup that points to the new VCAT. I'm wondering if anyone else has done it? If so what has your experience been? Any gotchas? [...]
1573 67 31_DB2 AIX: CLOB Space Utilization0_28_BILL.GALLAGHER@PHOENIXWM.COM31_Mon, 30 Aug 2004 15:34:52 -0400576_us-ascii Our environment: DB2 v7.2 fp7 on AIX 4.3.3
We have a database (designed by a vendor) which has a number of tables that contain CLOB columns. The LOB data is stored in the same tablespace as the table itself as opposed to a separate long tablespace (the vendor's design, not ours). Our users have deleted a fair amount of obsolete data via the application, and I've been trying to do some analysis to determine which tables need to be reorged in order to reclaim unused space. I ran the REORGCHK utility against the database, and have only been identify a [...]
1641 92 55_Re: multiple high level qualifiers in one DB2 subsystem0_16_khampto1@TXU.COM31_Mon, 30 Aug 2004 14:43:11 -0500539_us-ascii We have been doing that for years here, we have had as many as 8 HLQ's used by the same DB2 subsystem. No particular gotcha's that I know of.
Kirk Hampton DB2 OS/390 Sysprog IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 Capgemini Energy Dallas, Texas
"Amsden, John W" cc: Sent by: DB2 Data Subject: multiple high level qualifiers in one DB2 subsystem Base Discussion List [...]
1734 46 55_Re: multiple high level qualifiers in one DB2 subsystem14_Waterman, Fred22_FWaterman@AEGONUSA.COM31_Mon, 30 Aug 2004 15:22:43 -0500552_iso-8859-1 We've also been doing this for several years. The only issue we've run into is if you create a storage group in another subsystem, (i.e. model office or test system) with the same HLQ, and then create the same database/tablespace name, you'll have a real mess on you hands.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Amsden, John W Sent: Monday, August 30, 2004 2:33 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: multiple high level qualifiers in one DB2 subsystem [...]
1781 50 55_Re: multiple high level qualifiers in one DB2 subsystem12_Brill, Steve22_Steve.Brill@ECOLAB.COM31_Mon, 30 Aug 2004 15:24:40 -0500476_us-ascii We have a subsystem in which we have both our Test and Quality Assurance environments, with all the same tablespaces, tables, and indexes. Storage Groups have slightly different names, as do database names, but more to make it easier to manage them, and keep them unique. Different VCAT names were used in the Storage Groups, and also, we used different Creator ID across the board. No problems encountered, and have been doing it for about 10 years. Good luck! [...]
1832 20 21_UDB Lock Wait Script?13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Mon, 30 Aug 2004 15:56:59 -0500717_iso-8859-1 Hi list,
Anybody out there have a Windows script that will show lock waits in UDB?
Thanks,
Scott Hodgin, Database Administrator South Carolina Farm Bureau Insurance Company shodgin@scfbins.com
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
1853 46 63_Re: Can I explain based on catalog tables with other qualifier?12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 30 Aug 2004 14:54:42 -0700517_us-ascii Why don't you just unload the production statistics and load them into your test system where the programmers want to explain? As long as the table structures and DB2 buffers are somewhat the same, you'll see pretty similar explains as to production for almost anything the programmers will write. Minor exceptions do occur, of course. There are a lot of tools out these to compare differences between systems, plus have the capability to copy stats. EZDB2 has a number as do a number of other vendors. [...]
1900 57 25_Re: UDB Lock Wait Script?11_Grant Allen28_Grant.Allen@TOWERSOFT.COM.AU31_Tue, 31 Aug 2004 09:05:24 +1000678_iso-8859-1 Have you tried
get snapshot for locks for application all
If you're running 8.1 or Stinger, also take a look the table-typed snapshot functions ... snapshot_lock and snapshot_lockwait
Ciao Fuzzy :-)
---------------------------------- "Everything you think, do, and say was in the pill you took today." -- Zager and Evans
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On > Behalf Of Hodgin, Scott > Sent: Tuesday, 31 August 2004 06:57 > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: UDB Lock Wait Script? > > > Hi list, > > Anybody out there have a Windows script that will show lock > [...]
1958 64 36_Re: SNAPSHOT_LOCKWAIT table function11_Grant Allen28_Grant.Allen@TOWERSOFT.COM.AU31_Tue, 31 Aug 2004 09:20:46 +1000708_iso-8859-1 Scott,
Have you turned on the lock monitor?
update monitor switches using lock on
Without this, the wait time information isn't collected, so snapshot_lockwait has no data to return.
Ciao Fuzzy :-)
---------------------------------- "Everything you think, do, and say was in the pill you took today." -- Zager and Evans
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On > Behalf Of Hodgin, Scott > Sent: Tuesday, 31 August 2004 04:36 > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: SNAPSHOT_LOCKWAIT table function > > > Hi list, > > I'm having trouble with the SNAPSHOT_LOCKWAIT table function. > I got into [...]
2023 50 25_Re: UDB Lock Wait Script?17_CUTHBERTSON, John31_John.CUTHBERTSON@DOIR.WA.GOV.AU31_Tue, 31 Aug 2004 08:53:02 +0800506_iso-8859-1 Scott
I have such a script and I will send it to you offline.
If anyone else is interested, please contact me
John Cuthbertson Umbrella Consulting Group
Perth Western Australia
-----Original Message----- From: Hodgin, Scott [mailto:shodgin@SCFBINS.COM] Sent: Tuesday, 31 August 2004 4:57 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: UDB Lock Wait Script?
Hi list,
Anybody out there have a Windows script that will show lock waits in UDB? [...]
2074 28 26_DB2 V Online REORG and NPI21_Naidoo, Rama [IBM GS]28_Rama.Naidoo@TEAM.TELSTRA.COM31_Tue, 31 Aug 2004 11:48:50 +1000462_US-ASCII Hello DB2 experts on z/OS,
I have large partition TS ( I mean very large ) that takes about 26 hrs to REORG if done PART ALL. Therefore we REORG selective partitons when required.
The problem is the long outage during the BUILD2 phase of the NPI. I know that REORG populates the 'shadow' logical partition of NPI during the SORTBLD phase but updates the NPI during the BUILD2 phase. During this phase there is an outage to end users. [...]
2103 40 49_Re: Conditional Restart Record In Data Sharing DR17_Karthik Vinayagam18_vkarthik@YAHOO.COM31_Mon, 30 Aug 2004 21:05:02 -0500402_- Don,
No. this method doesn't ensure log gets truncated at a 'common point' across all the members, for it is not synchronous. you would still need to go thru the exercise of establishing common point for the purpose of CRESTART, like the earliest endlrsn among those archive logs.
HTH Karthik
On Mon, 30 Aug 2004 09:03:20 -0400, Brunner Don J wrote: [...]
2144 28 80_Why would you not use "Allow Reverse Scan" as the default when creating Indexes?17_CUTHBERTSON, John31_John.CUTHBERTSON@DOIR.WA.GOV.AU31_Tue, 31 Aug 2004 10:50:04 +0800367_iso-8859-1 I have inherited a DB2 environment that was originally built in the late 1980s on an early release of DB2 and has mutated into 600+ tables running on Windows UDB V8 FP6. (All Indexes are type 2)
As part of tuning some new tables the "explain mode recommend indexes" has recommended the use of "Allow Reverse Scan" (it seems to always do this). [...]
2173 46 27_Re: Modify utility question11_leila sadat22_golestankooh@YAHOO.COM31_Mon, 30 Aug 2004 21:15:46 -0700415_us-ascii Hi ,You can use MODIFY with current date,then all the recover refrences till now will remove.
Harry Vijayakumar wrote:Hello,
We are a shop running DB2 for OS/390 v7.1 on a z/OS box. I want to know if there is a way to remove all references to recovery site imagecopies in the SYSCOPY table. I looked up the modify utility but did not see any flexibility there. [...]
2220 47 40_Re: PUBLIC access to DB2 catalog tables?11_leila sadat22_golestankooh@YAHOO.COM31_Mon, 30 Aug 2004 21:21:27 -0700602_us-ascii Hi always this is my question too.how much can access usual users (like programmers or begginers ..) DB2 catalog.sometimes we grant select on nessacery tables but is this right or there is better way to grant PUBLIC.
Mark McCormack wrote: John,
If you are concerned about who knows who is sysadm, or who can update a particular table, or who can bind a particular package, then you might want to restrict select access to the various sys---auth tables. I do not recommend this. I personally like select on DB2 catalog tables granted to public. [...]
2268 12 16_Re: SQL question12_Billy Larsen19_billarsen@YAHOO.COM31_Tue, 31 Aug 2004 02:28:22 -0500515_- You are great !
Thank you very much
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
2281 124 28_Re: DSN3@ATH connection exit11_Zohar, Meir17_Meir.Zohar@CA.COM31_Tue, 31 Aug 2004 08:34:10 +0100490_us-ascii Roger/James
So what is the conclusion here?
Is the module loaded from the calling app's STEPLIB or DB2's?
It is possible that in a case when SDSNLOAD is common for all DB2s and is in the LNKLIST, and a CICS transaction is accessing a specific DB2 SSID (that accesses a different version of DSN3@ATH located in its SDSNEXIT), the search path may produce inconsistent results (i.e. when under CICS - from LNKLIST - when retrying under DB2 - from SDSNEXIT)? [...]
2406 16 40_Re: PUBLIC access to DB2 catalog tables?12_Billy Larsen19_billarsen@YAHOO.COM31_Tue, 31 Aug 2004 02:38:38 -0500370_- i only grant access to the tables that could be interesting to developers : SYSTABLES, SYSKEYS, SYSTABLESPACE, SYSPLAN , SYSPACKAGE , SYSPACKLIST ... it allows them to have better productivity.
it is frustrating to a programmer to "see nothing" , and i am afraid that this don't encourage them to have interests into db2 , and so , produce bad db2 codes ! [...]
2423 17 29_database administration tools16_Anja Petrikowski23_anja.petrikowski@GMX.DE31_Tue, 31 Aug 2004 05:09:26 -0500664_- Hi list, Im looking for a comparison of the different database administration tools like automation tool, dasd manager, unicenter ...
Anybody out there who can help?
thanks Anja
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
2441 275 40_Re: PUBLIC access to DB2 catalog tables?0_19_mike.holmans@BT.COM31_Tue, 31 Aug 2004 11:42:32 +0100605_iso-8859-1 Hi,
Another table you might consider securing is SYSVIEWS, as it can at least be argued that there is potentially valuable and confidential information contained in the predicate structure of views.
I lean towards leaving the permissions for the catalog PUBLIC while securing access to the DB2 load libraries and plans like the ones for SPUFI, QMF and TEP2/TIAD: the idea being that you stop people getting into the building rather than trying to work out which rooms in the building they are and are not allowed to visit. Yes, I know that a glib statement like that hides a [...]
2717 45 27_index usage of in predicate30_zg=?ISO-8859-1?Q?=FCr_=D6zen?=13_oozen@YKB.COM31_Tue, 31 Aug 2004 05:47:00 -0500441_- DECLARE CUR - WMFLG - 1 SENSITIVE STATIC SCROLL CURSOR WITH HOLD FOR SELECT FLGTSFECHORA , FLGSTOKTIP , FLGMNKOD , FLGFIRMA , FLGVADE , FLGNOMINAL , FLGIHRTERTIP , FLGDURUM , FLGMUSTNO , FLGADET , FLGFAIZ , FLGFIYAT , FLGTUTAR , FLGTIP , FLGSUBE , FLGKANAL , FLGTXCODE , FLGUSERID FROM GDBA . WMFLGA00 WHERE FLGDURUM IN ( ' ' , 'F' ) AND FLGTSFECHORA < ( CURRENT TIMESTAMP - 1 MINUTES ) ORDER BY FLGTSFECHORA FOR UPDATE OF FLGDURUM ; [...]
2763 40 30_Re: DB2 V Online REORG and NPI19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Tue, 31 Aug 2004 06:56:47 -0400415_us-ascii Reorging the NPIs prior to Reorging the tablespace partitions will improve the elapsed time during BUILD2.
| Larry Jardine | Production DBA | Aetna |
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Naidoo, Rama [IBM GS] Sent: Monday, August 30, 2004 9:49 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: DB2 V Online REORG and NPI [...]
2804 77 25_Re: UDB Lock Wait Script?13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Tue, 31 Aug 2004 06:06:56 -0500409_iso-8859-1 I have tried snapshot_lockwait, but it show no lock waits when there really are lock waits going on.
The snapshot_lock show a lock wait status, but does not seem to show WHAT the lock wait is on
-----Original Message----- From: Grant Allen [mailto:Grant.Allen@TOWERSOFT.COM.AU] Sent: Monday, August 30, 2004 7:05 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: UDB Lock Wait Script? [...]
2882 81 36_Re: SNAPSHOT_LOCKWAIT table function13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Tue, 31 Aug 2004 06:07:43 -0500527_iso-8859-1 I have turned on the lock monitor, but I still get no results from the snapshot_lockwait.
-----Original Message----- From: Grant Allen [mailto:Grant.Allen@TOWERSOFT.COM.AU] Sent: Monday, August 30, 2004 7:21 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: SNAPSHOT_LOCKWAIT table function
Scott,
Have you turned on the lock monitor?
update monitor switches using lock on
Without this, the wait time information isn't collected, so snapshot_lockwait has no data to return. [...]
2964 26 15_Fixpak6 install6_Travis21_travisb@EAC-EASCI.ORG31_Tue, 31 Aug 2004 07:34:33 -0500458_- Hello.
I installed fixpak6 on DB2v8.1 on Windows 2003 server last night. Everything seemed to go very smoothly, but now in the db2diag.log I'm getting the following message when I start Control Center:
2004-08-31-07.33.10.302000 Instance:DB2 Node:000 PID:3756(javaw.exe) TID:2980 Appid:none base sys utilities sqleDetachCtx Probe:10
DIA0001E An internal error occurred. Report the following error code : "ZRC=0x8805006C". [...]
2991 68 65_Re: multiple high level qualifiers in one DB2 subsystem - thanks!14_Amsden, John W27_John.Amsden@JPFINANCIAL.COM31_Tue, 31 Aug 2004 09:02:53 -0400682_iso-8859-1 Thanks to all the people who responded! This is a great group!
-----Original Message----- From: Brill, Steve [mailto:Steve.Brill@ECOLAB.COM] Sent: Monday, August 30, 2004 4:25 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: multiple high level qualifiers in one DB2 subsystem
We have a subsystem in which we have both our Test and Quality Assurance environments, with all the same tablespaces, tables, and indexes. Storage Groups have slightly different names, as do database names, but more to make it easier to manage them, and keep them unique. Different VCAT names were used in the Storage Groups, and also, we used different Creator ID across [...]
3060 14 46_Re: Running DB2 V6 and DB2 V8 in the same LPAR10_Lisa Bates29_lisa.bates@ROCKETSOFTWARE.COM31_Tue, 31 Aug 2004 10:14:50 -0500637_- We have v6, v7, and v8 all running on the same systems (z/os 1.4 and 1.5). The erly code used by all versions is the v8 erly code.
Lisa Bates Rocket Software
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
3075 39 26_visual explain v8 problem.0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 31 Aug 2004 08:20:12 -0700391_- Hi all,
I downloaded and installed VEv8 on my EP machine. I tried testing a simple query (select * from testdb.testab) on a ZOS table using the "Tune SQL"/"SQL text"/"explain" option and get this result;
The input SQL statement can not be executed : SQLCODE=-206 [IBM][CLI Driver][DB2] SQL0206N "TABLE_TYPE " is not valid in the context where it is used. SQLSTATE=42703 [...]
3115 34 46_Re: Running DB2 V6 and DB2 V8 in the same LPAR0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 31 Aug 2004 08:22:26 -0700425_- v6,v7,v8 ouch, I'd hate to see your license bill! cliff:-)
-----Original Message----- From: Lisa Bates [mailto:lisa.bates@ROCKETSOFTWARE.COM] Sent: Tuesday, August 31, 2004 8:15 AM To: DB2-L@www.idugdb2-l.org Subject: Re: Running DB2 V6 and DB2 V8 in the same LPAR
We have v6, v7, and v8 all running on the same systems (z/os 1.4 and 1.5). The erly code used by all versions is the v8 erly code. [...]
3150 13 30_Re: visual explain v8 problem.15_Pradeep Gunjala25_pradeep_gunjala@YAHOO.COM31_Tue, 31 Aug 2004 10:43:35 -0500751_- If you are connecting Z/os through DB2 Connect, One possiblity could be your DSN configuration on your PC is pointing to a different subsystem/ DB2 Connect instance where these tables are not existing or you might be using the wrong creater/schema name (testdb). Just a thought.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
3164 82 25_Changed Insert behaviour?13_Michael Ebert18_mebert@AMADEUS.NET31_Tue, 31 Aug 2004 18:02:11 +0200583_US-ASCII Hi List,
I'm currently trying to nail down a puzzling problem. One of our critical processes has suddenly started increasing in runtime (elapsed time only), and the TS involved has more than doubled in size. The process is something as follows:
1. We start with table T1 - about 11M rows. 2. We insert about 4M rows with column DTProcess= . The date is usually the current date. 3. We do INSERT INTO Z1 (SELECT * FROM T1 WHERE DTProcess= GROUP BY C1, C2) i.e. we summarize the just-inserted rows into a Created GTT Z1 with the same structure [...]
3247 43 46_Re: Running DB2 V6 and DB2 V8 in the same LPAR12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 31 Aug 2004 11:18:40 -0500536_US-ASCII Ditto, from HLS Technologies, Inc. If anyone wants to discuss this offline we would be happy to do so. In answer to the licensing question, if you write DB2 mainframe software you have to support V6, V7 and V8.
Gerald Hodge HLS Technologies, Inc. 281-265-3004
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lisa Bates Sent: Tuesday, August 31, 2004 10:15 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Running DB2 V6 and DB2 V8 in the same LPAR [...]
3291 47 27_Explain assistance for UDB.13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 31 Aug 2004 11:31:16 -0500573_iso-8859-1 I have what is hopefully a very basic question regarding running explains on "little db2" (If you haven't already guessed, I'm a somewhat biased mainframe DB2 person who has suddenly found himself with the opportunity to run explains against UDB v8 running on AIX). At this point I realize how to get to visual explain through control center and can run an explain against UDB and view the graphical intepretation of the access path. So far, so good. The trouble comes in when I actually have to interpret the access path -- I can see from the boxes that I [...]
3339 47 30_Re: visual explain v8 problem.0_32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 31 Aug 2004 09:35:35 -0700432_- Pradeep, I executed the query before I ran the explain and get the correct rows. I also created the plan table for the DB......
hold on, I just went to the "Enable Visual Explain" window to check the db/ts of the explain table and got a message saying it was incompatible. I recreated the plan table using the window and now the explain is working. Look like the original create plan table DDL I used was out of date. [...]
3387 46 43_Puzzling LOAD logging behavior - Any ideas?13_Pearson, Eric19_Eric.Pearson@53.COM31_Tue, 31 Aug 2004 12:46:07 -0400431_iso-8859-1 LOAD DATA SHRLEVEL CHANGE RESUME YES LOG YES
Max row length 170 bytes
Rows loaded 329697
So.... logging should be about 50-55MB ????
DB2PM shows:
LOG RECORDS WRITTEN 1742.8K - about 5.3 log records per row loaded. TOT BYTES WRITTEN 207.2M LOG RECORD SIZE 118.86
Another LOAD has a max row len 293 and LOG RECORD SIZE 526.64 Also shows about 3.6 log records per row loaded. [...]
3434 136 32_Re: SQLCODE -817 - PLEASE HELP!!7_db2sysc17_db2sysc@YAHOO.COM31_Tue, 31 Aug 2004 12:03:55 -0500349_ISO-8859-1 ALL
If I do a "COMMIT" inside the stored procedure, would it take care of the two phase commit point? Our CICS is attached to Subsystem X and not to subsystem Y and I am asking this becuase I know we shld not be issing COMMIT for a CICS thread.. not sure if issuing COMMIT in stored procedure would affect CICS thread inturn. [...]
3571 16 25_Compress on mainframe....9_Sreedhar.24_sbobbadi@DUKE-ENERGY.COM31_Tue, 31 Aug 2004 12:13:07 -0500293_- I have a huge file that I want to FTP to a AIX box, before to doing the FTP I want to compress the file, I tried TRSMAIN but the tar command on AIX would not recognize it. Is there some compression util. on z/os that will allow me to compress files that can be uncompress on a AIX box. [...]
3588 84 29_Re: Compress on mainframe....12_McKown, John26_john.mckown@UICIINSCTR.COM31_Tue, 31 Aug 2004 13:16:27 -0500543_us-ascii > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sreedhar. > Sent: Tuesday, August 31, 2004 12:13 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Compress on mainframe.... > > > I have a huge file that I want to FTP to a AIX box, before to > doing the FTP > I want to compress the file, I tried TRSMAIN but the tar > command on AIX > would not recognize it. Is there some compression util. on > z/os that will > allow me to compress files that can be uncompress on a AIX [...]
3673 17 51_Identify DB2 Subsystem Name In Application Programs13_Mark Grundigz24_markgrundigz@HOTMAIL.COM31_Tue, 31 Aug 2004 13:50:36 -0500730_- Hello Listers,
Can anyone tell if there is a way to obtain the DB2 subsystem name in a COBOL/DB2 program ?? We have used CURRENT MEMBER and CURRENT SERVER special registers, but would like to know if there is another way.
Thanks, Mark Grundigz
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
3691 62 29_Re: Compress on mainframe....0_21_BudGreenman@ONGOV.NET31_Tue, 31 Aug 2004 14:52:30 -0400413_US-ASCII We use PKZIP for os390/zos. you then have to ftp as a binary file & when you unzip it on aix (or intel) it will be ascii.
Bud Greenman Applications Programming Manager
"Sreedhar." To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Compress on mainframe....
08/31/2004 01:13 PM [...]
3754 66 55_Re: Identify DB2 Subsystem Name In Application Programs12_michael bell21_mbell11a1@VERIZON.NET31_Tue, 31 Aug 2004 14:11:49 -0500369_Windows-1252 The only way I have found is to use call attach. The CONNECT command gives you back an address of RIB and EIB. Of course this requires that you know the group id that you want to connect to. With current COBOL, you can use these to get addressability to the EIB. The field descriptions for RIB and EIB are in sdsnmacs for ASM versions of the DSECT's. [...]
3821 122 34_Rows Updated by a Stored Procedure10_Ed Gephart20_edgep@ATTACHMATE.COM31_Tue, 31 Aug 2004 12:09:13 -0700388_us-ascii Hello,
My question has to do with getting the number of rows updated by a stored procedure invoked by a C program using CLI. My Oracle version uses OCIAttrGet and the SQL Server version DBCOUNT. When I call SQLGetRowCount, it returns -1 although a row has been updated. Is there a way to get the number of rows actually updated by a stored procedure? [...]
3944 16 27_Re: Modify utility question13_Mark Grundigz24_markgrundigz@HOTMAIL.COM31_Tue, 31 Aug 2004 14:27:55 -0500651_- Harry,
If you have BMC C+/MODIFY, you can delete specific rows in SYSCOPY. I don't think there is a way to do this using IBMs MODIFY utility.
Regards, Mark Grundigz
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
3961 74 38_Re: Rows Updated by a Stored Procedure12_Norma Mullin18_mullinn@US.IBM.COM31_Tue, 31 Aug 2004 15:41:06 -0400368_US-ASCII Ed, If you are using DB2 UDB 8.1 (Linux/Unix/Windows) the GET DIAGNOSTICS statement can retrieve statement information (one of them being the row count) for a previously executed SQL statement. Syntax: GET DIAGNOSTICS v_number_of_rows = ROW_COUNT where v_number_of_rows is a declared variable. I do not recall the version that introduced this statement. [...]
4036 132 30_DB2 v7.1 triggers and MQSeries14_Schaeffer Dave25_Dave.Schaeffer@BENDIX.COM31_Tue, 31 Aug 2004 16:08:05 -0400288_iso-8859-1 Hello,
What I would like to do is from a trigger on a v7.1 mainframe table is issue a MQSeries PUT that would contain the updated row. Is there a SQL only way to accomplish this or is my best bet to create a stored procedure to do this?
Thanks for any help. [...]
4169 162 39_DB2 UDB on AIX backup & restore process13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 31 Aug 2004 15:17:08 -0500477_us-ascii Hi all,
What actually happens when I backup and restore a DB2 database on AIX. The backup takes less disk space than my database. Is it compressed? Are the indexes backed up or are they rebuilt like they are on the mainframe? When the restore happens, the DMS files seems to appear rather quickly, then there is a long time when I don't know what is happening and finally my SMS files show up. Can someone offer a clue on the process here? [...]
4332 35 34_Re: DB2 v7.1 triggers and MQSeries15_Marcel Harleman25_marcel.harleman@HCCNET.NL31_Tue, 31 Aug 2004 22:24:18 +0200534_us-ascii Dave,
if I'm not mistaken IBM did bring out a DB2 MQSeries function via APAR PQ59549 (add the new DB2 MQSeries function to DB2 for Z/OS and OS/390, ptf=UQ71197). Maybe you can have a look at that one.
Marcel.
>Hello, > > What I would like to do is from a trigger on >a v7.1 mainframe table is issue a MQSeries PUT >that would contain the updated row. Is there a >SQL only way to accomplish this or is my best >bet to create a stored procedure to do this? > > Thanks for any help. > > >Best Regards, [...]
4368 70 47_Re: Puzzling LOAD logging behavior - Any ideas?15_Marcel Harleman25_marcel.harleman@HCCNET.NL31_Tue, 31 Aug 2004 22:28:05 +0200576_us-ascii Eric,
since indexes are logged too for rollback-purposes: how many indexes does the table have?
>LOAD DATA SHRLEVEL CHANGE RESUME YES LOG YES > >Max row length 170 bytes > >Rows loaded 329697 > >So.... logging should be about 50-55MB ???? > >DB2PM shows: > >LOG RECORDS WRITTEN 1742.8K - about 5.3 log records per row loaded. >TOT BYTES WRITTEN 207.2M >LOG RECORD SIZE 118.86 > >Another LOAD has a max row len 293 >and LOG RECORD SIZE 526.64 >Also shows about 3.6 log records per row loaded. > > >Any ideas? > > >Eric Pearson >Fifth Third Bank >38 [...]
4439 83 29_Re: Compress on mainframe....16_Graeme St. Clair23_Graeme.St.Clair@HDS.COM31_Tue, 31 Aug 2004 13:33:53 -0700520_iso-8859-1 Where would one get this from? I sure could have used such a thing a few weeks ago, and maybe even now.
Rgds, G.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of BudGreenman@ONGOV.NET Sent: Tuesday, August 31, 2004 2:53 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Compress on mainframe....
We use PKZIP for os390/zos. you then have to ftp as a binary file & when you unzip it on aix (or intel) it will be ascii. [...]
4523 43 29_Re: Compress on mainframe....12_McKown, John26_john.mckown@UICIINSCTR.COM31_Tue, 31 Aug 2004 15:36:24 -0500383_us-ascii > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Graeme St. Clair > Sent: Tuesday, August 31, 2004 3:34 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: Compress on mainframe.... > > > Where would one get this from? I sure could have used such a > thing a few > weeks ago, and maybe even now. > > Rgds, G. > [...]
4567 115 27_Re: Modify utility question0_16_khampto1@TXU.COM31_Tue, 31 Aug 2004 15:40:28 -0500489_us-ascii Leila, I'm pretty sure what Harry wants to do is just pick out and delete the RECOVERSITE copies from SYSCOPY, and leave the LOCALSITE ones intact. I do not believe there is any way to do that with the MODIFY utility. Anyway, I am not sure why you would care to do that. In our production systems, we would run a weekly MODIFY to purge anything older than 30 or so days, so eventually we would get rid of all the old stuff. Harry, can you explain what you are trying to do ? [...]
4683 113 38_Re: Rows Updated by a Stored Procedure10_Ed Gephart20_edgep@ATTACHMATE.COM31_Tue, 31 Aug 2004 13:50:20 -0700319_us-ascii Norma,
This seems to return the same value returned by SQLRowCount, which in my case is -1. If I execute an update statement without using a stored procedure, the rows updated value is returned as expected. Again, if I use a stored procedure to update, then I always seem to get -1 as a row count. [...]
4797 49 30_Re: DB2 V Online REORG and NPI14_Matthews, John25_JMatthews@MEDNET.UCLA.EDU31_Tue, 31 Aug 2004 13:52:29 -0700388_- Related to this, I know that YMMV but does anyone have practical guudelines that they have found useful for estimating this BUILD2 time?
-----Original Message----- From: Naidoo, Rama [IBM GS] [mailto:Rama.Naidoo@TEAM.TELSTRA.COM] Sent: Monday, August 30, 2004 6:49 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: DB2 V Online REORG and NPI
Hello DB2 experts on z/OS, [...]
4847 91 30_Re: DB2 V Online REORG and NPI20_Friedman, Avram (IT)32_Avram.Friedman@MORGANSTANLEY.COM31_Tue, 31 Aug 2004 17:00:58 -0400331_us-ascii There is a formula in the book "Certified DB2 TECH Support" YSL 1999 I think that discusses houw to estimate the time required for a recovery ... I think this formula could be modified to handle the BULID2 case.
I do not happen to have the book in front of me so I can't reproduce the formula at this instant. [...]
4939 80 55_Re: Identify DB2 Subsystem Name In Application Programs13_Vickers, Mark22_Mark.Vickers@ANICO.COM31_Tue, 31 Aug 2004 16:21:07 -0500530_windows-1252 Mark, Try this call to the IBM Supplied SP DSNACCSS : (I have not found documentation anywhere on this, but discovered it one day while using the Stored Procedure Builder and this is all I had to go on:
Here is the code I developed and it works like a charm: 01 W10-SUB-SYSTEM PIC X(4). 01 W10-RETURN-CODE PIC S9(9) USAGE COMP. 01 W10-MESSAGE. 49 W10-MESSAGE-LEN PIC S9(4) USAGE BINARY. 49 W10-MESSAGE-TXT PIC X(120). 01 W10-IND01 PIC S9(4) COMP. 01 W10-IND02 PIC S9(4) COMP. 01 W10-IND03 PIC S9(4) COMP. [...]
5020 327 38_Re: Rows Updated by a Stored Procedure11_David Nance16_DWNance@FHSC.COM31_Tue, 31 Aug 2004 17:42:50 -0400438_US-ASCII Ed, I'm hazarding a guess that you put the get diagnostics in your program. How about putting it into your SP, and that value be returned to your program? Probably more trouble than you want to go through. Does this number being updated have to be returned to the end user or are you just trying to ensure a new process works correctly? If its the latter, you could just look at the log to see what was done by your thread. [...]
5348 99 47_Re: Puzzling LOAD logging behavior - Any ideas?12_Colleen Clow23_Colleen_Clow@BCBSIL.COM31_Tue, 31 Aug 2004 17:04:08 -0500522_us-ascii cmc
"Pearson, Eric" cc: Sent by: "DB2 Subject: Puzzling LOAD logging behavior - Any ideas? Data Base Discussion List"
08/31/2004 11:46 AM Please respond to "DB2 Database Discussion list at IDUG"
LOAD DATA SHRLEVEL CHANGE RESUME YES LOG YES
Max row length 170 bytes
Rows loaded 329697
So.... logging should be about 50-55MB ???? [...]
5448 112 47_Re: Puzzling LOAD logging behavior - Any ideas?12_Colleen Clow23_Colleen_Clow@BCBSIL.COM31_Tue, 31 Aug 2004 17:15:33 -0500546_us-ascii Guess I'll try this again. Sorry everyone.
First I would check the number of logs to see how many copies you're maintaining. I don't know that a separate log record would get counted for each copy you're maintaining, but it's possible.
The second thing I would tell you is to take a look at logging in the manuals because they explain it much better than I do, but in general just because you load a record of 170 bytes into a table does not mean that a record of 170 bytes gets written to the log. The log is keeping [...]
5561 52 34_Re: DB2 v7.1 triggers and MQSeries12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 31 Aug 2004 15:31:41 -0700329_us-ascii That's true. It's really simple to implement. And the trigger functions work really well. Some minor Igotchas about recovery and rollbacks but nothing that can't be overcome in a very very short amount of time. I can speak for experience because I've personally written a trigger to do exactly that - MQSeries PUT. [...]
5614 97 34_Re: DB2 v7.1 triggers and MQSeries33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE30_Wed, 1 Sep 2004 00:36:49 +0200638_iso-8859-1 SELECT DB2MQ2C.MQSEND('TESTING MSG 1') FROM SYSIBM.SYSDUMMY1; Look at the APAR info from Marcel
Roland
-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Schaeffer Dave Gesendet: Dienstag, 31. August 2004 22:08 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: DB2 v7.1 triggers and MQSeries
Hello,
What I would like to do is from a trigger on a v7.1 mainframe table is issue a MQSeries PUT that would contain the updated row. Is there a SQL only way to accomplish this or is my best bet to create a stored procedure to do this? [...]
5712 44 34_Re: DB2 v7.1 triggers and MQSeries33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE30_Wed, 1 Sep 2004 01:26:47 +0200700_iso-8859-1 Myron, simple to implement???? I had to fight with AMT files. I really don't like such a setup.
Roland
-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Myron Miller Gesendet: Mittwoch, 1. September 2004 00:32 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Re: DB2 v7.1 triggers and MQSeries
That's true. It's really simple to implement. And the trigger functions work really well. Some minor Igotchas about recovery and rollbacks but nothing that can't be overcome in a very very short amount of time. I can speak for experience because I've personally written a trigger to do exactly that - MQSeries [...]
5757 267 65_FREE DB2 UDB PERFORMANCE MANAGEMENT WEBCAST FROM VERITAS SOFTWARE13_Ram Narayanan25_Ram.Narayanan@VERITAS.COM31_Tue, 31 Aug 2004 19:01:57 -0700491_iso-8859-1 Title: DB2 UDB PERFORMANCE MANAGEMENT DEFINED Improving DB2 UDB Performance on UNIX, Linux and Windows with VERITAS Indepth for DB2
Date: Wednesday, September 8, 2004
Time: 11:00 AM - 12:00 PM Pacific Time
Do you want to be able to guarantee the performance of your DB2 UDB-based applications? Are you wasting valuable DBA time and IT resources trying to determine where performance problems reside within your DB2 development or production environment? [...]
6025 64 34_Re: DB2 v7.1 triggers and MQSeries12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 31 Aug 2004 19:24:35 -0700373_us-ascii Our MQ series guy understood them perfectly. He had a minor issue with some of the settings in them because the documentation wasn't as clear as perhaps it should be but once our testing showed what was happening, he was able to quickly sort out the issues. We had it up and running in just over a day from the time the PTF was actually put on to the system. [...]
6090 43 36_Re: SNAPSHOT_LOCKWAIT table function11_Grant Allen28_Grant.Allen@TOWERSOFT.COM.AU30_Wed, 1 Sep 2004 13:09:32 +1000495_iso-8859-1 Scott,
That's weird ... I get the same problem (no results) as you, using the UPDATE MONITOR SWITCHES USING LOCK ON, but I do get results if I use the UPDATE DBM CFG USING DFT_MON_LOCK ON. (should have tested my advice before mailing ;-) ).
Could be that either a) I don't understand the nuances of the UPDATE MONITOR SWITCHES ... command, or b) there's a bug. Either way, try turning on lock monitoring using the UPDATE DBM CFG method, and see if you get results. [...]