DB2
in [SQL]
|
Any suggestion on how to speed up large batch inserts? We are using 8.2.9 Windows 64 edtion, in one of our projects we need to recreate a few lager tables which have many millions of rows each, we have used concurrent Java threads to read from data source and do batch inserts to the target tables concurrently, to speed up the inserts we have used the following configu... 29 Jul 2008 12:38
Column order in composite index I'm pretty new to DB2 and like to know if column cardinality can play a role in choosing the column order in a composite index. In Oracle, it appears composite indexes of different column orderings perform the same regardless of column cardinality (http:// asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION... 15 Jul 2008 22:38
How to avoid 2nd trigger I am currently developing trigger based screen edit fro several 100 screens in COBOL/CICS EVIRONMENT. For every screen i have a corresponding DB2 TABLE and an edit trigger: for example: screen: MAP1 ABC INTERNATIONAL CORTPORAION 07/11/2007 ... 14 Jul 2008 14:44
Problem with IN predicate I have a query in Oracle like this: Select 1 from dual where (1,1) IN ( (1,1), (2,1) ) and want to convert it to DB2. I tried this query: Select 1 from sysibm.sysdummy1 where (1,1) IN ( (1,1), (2,1) ) I replaced "," with SPACE and ";" but got error. It will be appreciated to help me to solve this problem.... 19 Jul 2008 07:51
Special register USER Is there is a way in DB2 to update user id Special register USER ? Thank's in advance. -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200807/1 ... 12 Jul 2008 14:35
Just Click Here Get More Funny Babies immages http://www.goodwriting2.blogspot.com/ ... 11 Jul 2008 11:59
db2exfmt and missing function EXPLAIN_FORMAT_STATS Hi! when I run db2exfmt on DB2 9.1 I get this output: DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 1991, 2007 Licensed Material - Program Property of IBM IBM DATABASE 2 Explain Table Format Tool Connecting to the Database as user EMGSYS. Connect to Database Successful. Binding... 11 Jul 2008 15:05
V9 runtime client setup problems Helpful folks, We recently upgraded DB2 V7 to V8 on Windows 2003 Enterprise Edition. The plan is to migrate to V9 as soon as possible. In anticipation of that migration, IT management has decided that all our user desktop workstations (a few hundred) should be upgraded to the V9 runtime client before we migrate ... 11 Jul 2008 10:57
overflowlogpath and hadr Will a DB2 (v8.2.7) primary database find a required log for perpetuating HADR in the db cfg parameter OVERFLOWLOGPATH? TIA, Kermit Lowry kermit dot lowry (at) s1 dot com ... 15 Jul 2008 19:33
UDF Portability? I'm trying to implement an internal company provided security algorithm as a UDF within DB2. I have the provided C source code and was able to put a UDF wrapper around it and compile it using the provided bldrtn script on my development box. It appears to be working as expected there. On my QA box, there is no C... 16 Jul 2008 14:02 |