DB2
in [SQL]
|
more free space after table drop? DB2 LUW 8.1 FP14 I have a DMS tablespace that was a bit low on free space. I dropped a quite large table from the tablespace, but afterwards the free space didn't change a bit. Shouldn't it have gone up? TIA aj ... 16 Jul 2008 13:00
Latest updates in database mangement and many more Find the latest updates in SQL server tools and techniques. More details on database management, software testing, flow chart prepartation and many more http://www.sqlserversoftware.blogspot.com Find the hot jobs list in the field of Information Technology http://www.infotechjob.blogspot.com ... 15 Jul 2008 21:36
How to check SQLCODE in trigger I have an edit trigger: --#SET TERMINATOR ! CREATE TRIGGER EMPSCREDIT NO CASCADE BEFORE INSERT ON EMP_SCREEN_EDIT REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL BEGIN ATOMIC DECLARE reason VARCHAR(68); SET reason = CASE WHEN LENGTH(RTRIM(TRANSLATE(EMPNO, '*', ' 0123456789'))) <> ... 16 Jul 2008 13:00
SQLOGDIR permissions in AIX Hi community, the log files in SQLOGDIR have -rw------ as permissions. How can I change the permissions to -rw-r----, also for newly created logfiles? Thanks in advance, Axel. ... 17 Jul 2008 02:25
paypal wholesale Armani shirt (paypal accept)(www super-saler com ) paypal wholesale Armani shirt (paypal accept)(www super-saler com ) paypal wholesale Armani hat (paypal accept)(www super-saler com ) paypal wholesale Armani hoody (paypal accept)(www super-saler com ) paypal wholesale Armani jeans (paypal accept)(www super-saler com ) paypal wholesale Armani sunnglass (paypal ac... 15 Jul 2008 03:04
paypal wholesale Armani hoody (paypal accept)(www super-saler com ) paypal wholesale Armani shirt (paypal accept)(www super-saler com ) paypal wholesale Armani hat (paypal accept)(www super-saler com ) paypal wholesale Armani hoody (paypal accept)(www super-saler com ) paypal wholesale Armani jeans (paypal accept)(www super-saler com ) paypal wholesale Armani sunnglass (paypal ac... 15 Jul 2008 03:04
DB2 Express UDB 9 with db2jcc JDBC driver- Issues with Auto generated field joeNOSPAM(a)bea.com wrote: Hi. It's clearly a driver bug. The driver should nullify any of a statement's values related to an execution when the statement is re-executed. Yes, I have discussed with the JCC team and it's a known issue. If you want to ensure it's fixed in a timely fashion probably best to open... 14 Jul 2008 15:45
TCPIP problem A batch job run from an informatica server is failing with the following error when trying to connect to the prod database, but it connects the second time when a retry is issued without any problems. [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR P... 17 Jul 2008 10:37
DB2 Express UDB 9 with db2jcc JDBC driver- Issues with Auto generated field Hi All, We are testing one of our component with JDBC + DB2 using db2jcc driver. We afced a strange issue. Scenario is like this. 1. We insert 1 record to a table having IDENTITY column as the primary key and retrieve the newly inserted identity value using getGeneratedKeys() API of JDBC 3.0. It works fine 2. Im... 14 Jul 2008 10:35 |