1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2009, week 5
2 37 35_Joan S Elliott is out of the office0_26_joan.s.elliott@US.HSBC.COM31_Fri, 28 Aug 2009 22:00:21 -0400582_US-ASCII I will be out of the office starting 08/28/2009 and will not return until 08/31/2009.<br><br>Please contact Victor Hedrick, Scott Holm, or Bruce Longfield<br><br>----------------------------------------- ****************************************************************** This E-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return E-mail. [...]
40 98 43_Re: Identity columns uniqueness Db2 z/os v812_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 29 Aug 2009 15:46:05 +0300574_utf-8 Hi,<br><br>I would like to elaborate a little :-)<br><br>As already said – IDENTITY is tied to a table, each row inserted gets a new identity number. The uniqueness is either guaranteed by DB2 (GENERATED ALWAYS) or by the user (GENERATED BY DEFAULT). Having a unique index defined on the IDENTITY column is always a good practice (even for GENERATED ALWAYS – if you want to search by it). Getting the new IDENTITY value can be done either by SELECT from INSERT (V8 and up) or by using the function IDENTITY_VAL_LOCAL() (V7 and up). If you need IDENTITY for a [...]
139 34 38_Re: DB2 z V9 - Who dropped the table ?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 30 Aug 2009 12:47:24 +1000407_US-ASCII documented restriction - you can't create triggers on catalog tables.<br><br>James Campbell<br><br>On 28 Aug 2009 at 16:43, Peter Vanroose wrote:<br><br>> Just a quick question related to this which came to mind: > > Did someone ever try to set up a delete trigger on SYSIBM.SYSTABLES to catch > (and log) this kind of table drop action? > > -- Peter Vanroose, > ABIS Training & Consulting. > [...]
174 305 33_SQLPRIMARYKEYS stored procedures.13_Mackey, Glenn20_GMackey@GUIDEONE.COM31_Sat, 29 Aug 2009 21:54:24 -0500463_us-ascii We have an application written in VB6 and accessing DB2 V8.1 z/os via odbc. I can see on each (most) dynamic sql statement, calls to meta data stored procedures are called - SQLPRIMARYKEYS, SYSSTATS etc. The corresponding packages seems to account for 70%+ of the cpu for the calls, especially when 1 row returned. The applicatoin is not written very well, but I want to know if there is a setting to stop these ODBC calls from invoking these Sp's. [...]
480 47 43_Re: Identity columns uniqueness Db2 z/os v814_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 30 Aug 2009 12:59:10 +1000546_US-ASCII Even before then, IDENTITY_VAL_LOCAL has been around since V6.<br><br>James Campbell<br><br>On 28 Aug 2009 at 14:29, M. Khalid Khan wrote:<br><br>> > > That's not true any more. Application can use SELECT from INSERT to get the generated value. > Khalid > > > > <snip> > > The application never knows what value is put into the primary key > column > after running the INSERT statement. If the application has to continue > to > insert rows into the child tables, it has to run a SELECT statement on > the > parent table to get the [...]
528 325 37_Re: SQLPRIMARYKEYS stored procedures.12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 29 Aug 2009 20:39:18 -0700559_utf-8 Good luck. I've had a PMR open for over two years about this issue. IBM claims that they are reviewing the code for performance changes but that was over 6 months ago. A) the code is extremely poorly written in these SPs. B) 99.9% of the time, it's totally unnecessary and should be able to be turned off entirely but cannot be easily. There are some ODBC driver settings that can partially disable them if your app can handle this. Not all apps can. C) IBM seems extremely unresponsive to resolving any issues with these SPs or admitting they are [...]
854 55 43_Re: Disallow filtering in 'where' clause...15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Sun, 30 Aug 2009 14:32:53 +0300384_us-ascii On Fri, 28 Aug 2009 15:08:45 +0100 Mike Turner <mike.turner@GMX.COM> wrote:<br><br>:>I don't know any way of preventing a search on a column. It is a basic part of the relational theory that any column can be specified in the WHERE clause.<br><br>I agree. Why don't you want to allow them to search on the column? How do you suggest that they satisfy the business need? [...]
910 36 49_AUTO: Gab Gambassi is away (returning 03/09/2009)12_Gab Gambassi20_gabriele@NZ1.IBM.COM31_Mon, 31 Aug 2009 16:01:29 +1200362_US-ASCII I am out of the office until 03/09/2009.<br><br>I am away from the office working at a customer site. I will have limited access to e-mail. For urgent matters you can ring my mobile 021 484 053, alternatively please contact: DB2 DBA, Art Balingit - ph. 09-359-8417 or 021-464958 or Manager DBA Services, Bruce Campbell ph 09-359-2594 or 021-765606 [...]
947 157 54_CDUG 2009 Tech Forum's presentations (Shanghai, China)10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 31 Aug 2009 05:48:29 -0400461_Windows-1252 <br><br>Hi DB2 user,<br><br>Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com<br><br>Last update on Monday, August 31st 2009<br><br><br><br><br><br>Here are several presentations, from CDUG 2009 Tech Forum (Shanghai, China), available on DB2 China website:<br><br><br><br><br><br>- Partitioned Table Space Usage Experience Sharing by Huang Hao<br><br><br><br><br><br>- DB2 Memory Management by Jim Teng [...]
1105 35 13_Lost password13_Steve Masters23_smasters@HEALTHPLAN.COM31_Mon, 31 Aug 2009 11:37:48 +0000401_utf-8 Hello all,<br><br>I am at a new account and they have a UDB (on windows) instance which was set up for them about a year ago by an IBM resource to handle the GUI frontend for TWS. No one knows the passwords for this instance, and they are now asking me to maintain this. Is there any way for me to determine the admin password for this instance? I know the userid. Any back door available? [...]
1141 55 17_Re: Lost password2_DJ20_dj53tx-udb@YAHOO.COM31_Mon, 31 Aug 2009 09:04:44 -0400495_utf-8 On Monday 31 August 2009 07:37:48 Steve Masters wrote: > Hello all, > > I am at a new account and they have a UDB (on windows) instance which > was set up for them about a year ago by an IBM resource to handle the GUI > frontend for TWS. No one knows the passwords for this instance, and they > are now asking me to maintain this. Is there any way for me to determine > the admin password for this instance? I know the userid. Any back door > available? > > Thanks, > > Steve Masters [...]
1197 119 43_Re: Identity columns uniqueness Db2 z/os v813_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Mon, 31 Aug 2009 10:18:33 -0400377_utf-8 You probably already have all the information you need, Art. There has been plenty of good information provided in the discussion of this question.<br><br>But I didn’t notice an explicit answer to your question. Others answered by describing the ways you can guarantee uniqueness and by providing other considerations.<br><br>The direct answer to your question is [...]
1317 47 17_Re: Lost password13_David Simpson22_dsimpson@THEMISINC.COM31_Mon, 31 Aug 2009 10:24:07 -0400593_UTF-8 Your Windows admin should be able to reset the password, right?<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DJ Sent: Monday, August 31, 2009 8:05 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Lost password<br><br>On Monday 31 August 2009 07:37:48 Steve Masters wrote: > Hello all, > > I am at a new account and they have a UDB (on windows) instance which > was set up for them about a year ago by an IBM resource to handle the GUI > frontend for TWS. No one knows the passwords for this instance, and they > [...]
1365 62 46_Re: Checkpoint/Restart Products for Batch Jobs13_Laura Rudolph23_Laura.Rudolph@CIGNA.COM31_Mon, 31 Aug 2009 14:22:39 +0000288_utf-8 Ricky,<br><br>We use Smart/Restart, and have used it since 2000. After the initial setup period, it has run fairly smoothly - to the point that no one else on my team has needed to back me up with it. Last year, over 55,000 jobs ran with the product. However, it is Expensive. [...]
1428 104 17_Re: Lost password10_Gyau, Paul15_PGyau@GEICO.COM31_Mon, 31 Aug 2009 12:04:05 -0400262_us-ascii You can also have your Windows admin add you to the admin group on that server and then you can log back on and reset the password of that instance id. They can then revoke your id later on once the DB2 instance pswd has been reset and is working. [...]
1533 62 50_DB2 DBA & DB2 System programmer or Java programmer11_Mukesh Jain21_jain.mukesh@AOINS.COM31_Mon, 31 Aug 2009 19:52:10 +0000532_utf-8 Hi, I am having 10 years of experience as DB2 DBA & System programmer. I have been responsible for performance monitoring and tuning, logical design and physical design of database, moving the objects and data from one environment to another environment, running DB2 utilities and all the DBA stuff. I have been also doing the sytem programmer work SMPE installation and DB2 upgrade, installation of other tools like BMC tools etc. recently i have upgraded DB2 v8 to v9. I have working mostly with the Banks data center. [...]
1596 104 54_Re: DB2 DBA & DB2 System programmer or Java programmer14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 31 Aug 2009 16:38:19 -0400531_us-ascii Mukesh,<br><br>First, let me say that I (at least) will miss your expertise in this forum if you go to Java.<br><br>Second, I can't make your choices for you; but as you've pointed out, there are both a lot of Java jobs and a lot of Java programmers. I'd say take the opportunity the client is offering you if you can afford the rate (is it the same, or less?), but don't completely give up on a DBA/Sysprog job search. Even if a career in Java doesn't pan out and you wind up going back to z/OS DBA, Java experience [...]
1701 737 37_Re: SQLPRIMARYKEYS stored procedures.13_Mackey, Glenn20_GMackey@GUIDEONE.COM31_Mon, 31 Aug 2009 16:41:28 -0500476_us-ascii Hi,<br><br>We found a solution. for our problem.<br><br>We set the record set object's RS.CursorType = 0 (ie ReadOnly) What was happening, was it was set to adLockBatchOptimistic 4 Optimistic batch updates. Required for batch update mode<br><br>And that made the VB/ODBC get ready for a subsequent update. VB/ODBC then went and called the meta data SP's to get the PKey so it could do an update if the recordset was subsequently updated. In our case it was not. [...]
2439 75 54_Re: DB2 DBA & DB2 System programmer or Java programmer12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Mon, 31 Aug 2009 22:37:35 +0000589_UTF-8 Hi Mukesh,<br><br>well - a difficult decision indeed! I expect all replies will be very personal opinions - as mine is.<br><br>From my personal experience, I can tell you that a few years (or even only months) experience in Java development can be an invaluable asset for mainframe people.<br><br>After 10 years of mainframe-centric work, I had the opportunity to move to our OO team and learn their stuff from scratch for a couple of years. Meanwhile back in a (cross-platform) databases team, I'm about the only one who can jump in wherever there's a need. I spend quite some [...]
2515 119 43_Re: Identity columns uniqueness Db2 z/os v815_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM31_Mon, 31 Aug 2009 17:43:10 -0600396_utf-8 Wouldn't it be nice if IDENTITY_VAL_LOCAL() was enhanced to be able to specify a particular table so that one could do something like the following (similar to how PREVIOUS VALUE for a sequence):<br><br>INSERT INTO TABLE1 (...) VALUES (...)<br><br>loop until done inserting rows in to table 2: INSERT INTO TABLE2 (foreign_key_from_table1, ...) VALUES (IDENTITY_VAL_LOCAL(TABLE1), ...) [...]