DB2

When will LOAD utility check consistaint
The following is a question of LOAD utility. Question: How does the DB2 enforce table check constraints for data added to table with the LOAD utility? A. With the BUILD phase of LOAD B. With the SET INTEGRITY statement C. With the DELETE phase of the LOAD D. With the UPDATE CONSTRAINTS statement Answer is A ... 18 Sep 2006 14:54

Help regarding INDEX
Hi group, I have a table say with 10000 records and 10 columns initially, I created an index say i1, after few days I altered the table by adding 10 new columns and 90000 rows of records summing up to 100000 records. My doubt is regarding the index is Do I have to create a new index ? or can I use the same index... 13 Sep 2006 14:20

Instance Crash
we have a weird issue.. When we try to do select count(*) from a table..say tab_a.. we get back the count. but the moment we try to do "select * from tab_a" ...the instance crashes and has to be restarted... The tablespace and table states are normal and count is very small ..(i.e. 150 recs) ..also there are n... 14 Sep 2006 05:47

DB2MOVE QUESTIONS
Guys, Got a DB2 ver. 8.2 on Windows 2003 with four tablespaces (some field size around varchar(2000 on it) define on it. Try to create another database on another Windows 2003 server using db2move export/import, and I got this message. SQL0286N A default table space could not be found with a page size of at ... 12 Sep 2006 13:21

Reduce High water mark
How can you reduce high water mark of a DMS tablespace? I have tablespace quite huge, but I dont need it thatt size anymore. There is no way though to reduce the ts size as the highwater mark is close to the max TS size. If nybody knows how let me know. Thanks ... 11 Sep 2006 19:16

Problem with DB2_USE_ALTERNATE_PAGE_CLEANING
Folks, I spent better part of morning debugging a problem and it turned out to be DB2_USE_ALTERNATE_PAGE_CLEANING registry variable. I am running DB2 8.2 on AIX 5.3 system: # oslevel 5.3.0.0 # db2level DB21085I Instance "db2test" uses "32" bits and DB2 code release "SQL08023" with level identi... 27 Sep 2006 13:35

Choosing primary key / Unique Index
I have a Parts Table with the following structure.. I need to decide which makes the primary key of the table. I cant have any sequences nor can I add any new fields in this Table. Table Structure :: Create table Parts (Parts_desig char(10), Sequence_no integer, Effective_Date Date, Amount integer, ... 14 Sep 2006 05:47

Perl DBD DB2
I'm attempting to connect to a DB2 database using perl DBD::DB2. I'm consistently getting the following error: [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004 What I have done: Installed the DB2 client, registered the database and verified connectivity using the db2 command... 14 Sep 2006 17:27

Error SQLCODE "-811", SQLSTATE "21000"
Our web programmer was looking in his application log an found the following error: 2006-08-31 16:33:35,129 ERROR org.hibernate.util.JDBCExceptionReporter - <[IBM][CLI Driver][DB2/6000] SQL0723N An error occurred in a triggered SQL statement in trigger "OLGCWEB.TBLPROPS_INS_TRG". Information returned for the er... 1 Sep 2006 09:04

DB2 Length Script
I'm writting a script that needs to deterimine the length of a char value...its easy enough to put length ('my data value') which evalulates to 13, but when I concatonate it, it says... SQL0440N No authorized routine named "||" of "FUNCTION" having compatible arguments was found.... How can I get this to wo... 30 Aug 2006 14:29