DB2

error messages for key constraint violations
I have the following three tables DROP TABLE CALLTRAK.SERVICE_CODES @ CREATE TABLE CALLTRAK.SERVICE_CODES ( CODE CHAR(1) NOT NULL , CONSTRAINT SERVICE_CODES_PK PRIMARY KEY (CODE) , DESCRIPTION VARCHAR(50) NOT NULL ) @ DROP TABLE CALLTRAK.CALLS @ CREATE TABLE CALLTRAK.CALLS ( ... 28 Jun 2008 01:28

Otra vez sin news (news.tie.cl) ...
Pienip�ist� moraalia, suuret toleranssit. J�lleen kerran asiaa, jota maassamme tuskin kourallinen edes tiet��. OL-3 ty�maan mokailut on jo alansa klassikoita. Mutta jopa siin� ilmapiiriss� t�m� hakee kyll� vertaistaan minusta. Ydinvoimalan suunnittelu oli enemm�n kuin hakusessa jo startista asti ja se meinaan n�k... 25 Jun 2008 20:09

Questions to FAILARCHPATH and HADR
On Mar 31, 12:05 am, Joachim Klassen <JoKlas...(a)email.com> wrote: Hi all, Platform DB2 V9.1 FP3 on AIX V5.3,HADRis configured and running. LOGARCHMETH1 is TSM , FAILARCHPATH is set to a local filesystem. Szenario: TSM Server is unavailable for some time, DB2 primary archives its logs to FAILARCH... 25 Jun 2008 13:58

FYI: DB2 for LUW Best Practices
The DB2 development team has compiled a set of best practices for DB2 for LUW which can be found here: http://www.ibm.com/developerworks/db2/bestpractices/ Feedback (completeness, too much, too little, consumability, ...) much appreciated. Enjoy Serge -- Serge Rielau DB2 Solutions Development IBM Tor... 5 Jul 2008 11:29

MQ Functions included in DB2 Workgroup Edition?
Anyone know if MQ Functions (made available by "enable_MQFunctions" System Command) are included in DB2 Workgroup Edition, or is Enterprise Edition required? This would be for DB2 LUW 8.2 or 9.1. ... 26 Jun 2008 17:43

z10 or z9
We have the z900s in-house and would like to know if we should go with z9 or z10 ? The folks want to go z9 as z10 is a bit pricier. Do you think its a wise choice ? If not, why not ? Part of the hesitation is that z10 is also fairly new in the market. Please advice. ... 25 Jun 2008 00:39

Find the latest updates in database management of IBM
Find the latest updates on IBM database mangement and other topics related to IT such as software testing, Decoding, Flowchart prepartaion and many more... http://www.sqlserversoftware.blogspot.com ... 24 Jun 2008 21:35

Reorgchk, Reorg, Runstats not having any effect after completion.Why is this?
Okonita via DBMonster.com wrote: Hi all, I am very surprised to see that after doing a Reorgchk followed by reorg of selected tables and concluding with a runstats of the reorged tables, all of the tables continue to be identified and selected as reorg candidates in subsequent/followup reorgchk. H... 24 Jun 2008 17:28

CLOB and searching by it
Hello all, I have table with CLOB column length of ~65K. application is searching from this table by CLOB and i can not create index on it. I know IBM recommends using DB2 Net Search Extender or DB2 UDB Text Information Extender for searching CLOBS but what are the other solutions out there. can i use some othe... 25 Jun 2008 16:02

Reorgchk, Reorg, Runstats not having any effect after completion. Why is this?
Hi all, I am very surprised to see that after doing a Reorgchk followed by reorg of selected tables and concluding with a runstats of the reorged tables, all of the tables continue to be identified and selected as reorg candidates in subsequent/followup reorgchk. Has anyone had this experience? Can you share wit... 29 Jun 2008 17:16