Generating Indentity Columns during load on large tables in DPF 5 285 (10/28/2009 11:45:54 AM)
DB2 for Linux 9.7. Since DPF (Data Partitioning Feature) tries to do things in parallel, how much extra overhead is there is having DB2 assign values to an identity column that is used as the hash partition...
Mark

Problem installing DB2 Express-C (create database) 4 354 (11/2/2009 1:57:31 PM)
Hi, I have problems creating a database in DB2 Express-C after an initial installation on my Windows XP SP3 box. When I try to create the database from the control center I get the error message: SQL10...
OTPXDAJCSJVU (9)

DB2 9.7 Row level security 3 298 (10/27/2009 5:13:10 PM)
Is there a redbook on implementing row level security in DB2 9.7 LUW ? Can someone list the link, I can't find anything on IBM's site regarding the topic. Thanks, JD ...
dunleav1

Constraint problem 5 150 (10/29/2009 1:22:27 AM)
This is an actual problem in a manufacturing environment. An order goes to one and only one customer. An order will have products that are specified by either the customer or by us; there are no other sour...
CELKO

how many records contribute to a page. 2 168 (10/29/2009 12:21:42 AM)
Hi How to determine how many records contribute to a page in a table ( provided the structure of the table and pagesize ). ...
Sivaswami

Sql procedure Performance 0 341 (10/29/2009 9:22:54 AM)
We have moved our system from an old server to a new, faster and in all respects 'better' server. And everything performs mush better with the exception of one of our SQL PL procedures. The old system was ...
odd.andersen (2)

Oracle to DB2 Migration Problem - Triggers 1 277 (10/28/2009 4:24:29 PM)
Hi list, we are experiencing a complex migration from Oracle to DB2 9.7 in compatibility mode using DB2 DATA MOVEMENT TOOL. When migrating triggers one of the most typical errors we get is this: CREATE...
jbaron

Difference in INDEX statistics in SYSIBM.SYSINDEXES 0 600 (10/28/2009 5:37:31 PM)
Hi, I am encountering a strange problem for a Table in production vs test. The table has same number of records in both test and production. It has 5 indexes and SYSIBM.SYSINDEXES shows CLUSTERED=Y for the...
dibalok (9)

redirected restore 2 465 (10/28/2009 12:26:53 AM)
hello, have v82 backup copy of database from solaris. want to restore on v95 on aix. container paths(mount points) are obviously different. have ftp'ed the backup to aix. will redirected restore work or supp...
rnbjrnbj (11)

debug - find the network wait time 0 275 (10/28/2009 10:13:30 AM)
Hi I am using a nickname to access in my application. It is very very slow, I need to know if the process in my db si slow or if the remote db is taking so much time to do the join (pushdown is enabled). Is ...
arunrocks (9)