DB2

db2 sequence to reset automatically
Hi, Is there any way in db2 to reset the identity/sequence to reset automatically after some period of time?? Eg:- the ID format is <SEQ/IDENTY>/YYYY (001/2010,,,,002/2010....901/2010...) after one year i want the SEQ/IDENTY to start with 001 ie : (001/2011..002/2011).. Regards, Ram ... 1 Jul 2010 09:56

CLPPLus
I have a DB2 9.7 Enterprise Server Edition 32-bits installed on my laptop - Windows 7 64-bits, and wanted to look into the new CLPPlus tool. As I can see from the manuals there should be no extra installation required in order to run CLPPLus, and I can find the clpplus.bat file in my sqllib\bin directory. But when ... 29 Jun 2010 05:16

Replacing multiple statements with a MERGE
Here is a problem that has me stuck. This is a skeleton of an auction. We start with a simple table of bids for the items. The key is the item's identifier and sequential bid number within each time. To give the table a key when an item is put on auction, we put in a dummy bid and amount. CREATE TABLE Auctions ... 30 Jun 2010 18:41

db2 Shared CGTT(Global Temp Table) Data ploblem?
Hi I have a question about Shared CGTT(Global Temp Table). In one session you can share data Can I share data(In the SESSION.TMP_PROTESTTAB) with 2SP in one session? For example,I have 2SP(Stored Procedure) The SP code is the following: 1) SP1 CREATE OR REPLACE PROCEDURE dbo."TMP_TESTTB1" ( V_CompanySeq IN... 25 Jun 2010 08:46

db2 install questions
1. Could we move the installation path to other mount point. (from / opt/ibm/db2/V9.7 to /db2home/ibm/db2/V9.7). What is the impact of moving. 2. Can we move instance owner home path (from /home/db2stga to / db2home/db2stga) 3. Is it mandatory to install DB2 and create instances by user with Root privilege? The i... 25 Jun 2010 13:10

Rollforward after a Redirect restore
Hello , I have a scenario . consider we have a database for which we have taken a Full backup on monday. We have added tablespaces say on tuesday. Consider we want to do a redirect restore onto a different box which has compeltely different filesystems with different mount points Using the backup taken on mond... 29 Jun 2010 03:04

DB2 UDB V9.1.3, Database crash, crash recovery fail, no backup.
Is there a way to get the DDL for all the tables? Thinking to use db2dart to dump necessary sysibm table, Then recreate similar views syscat.tables syscat.views syscat.columns syscat.triggers .... Compose DDL based on those views. It is really a tedious work. Any other suggestion? ... 28 Jun 2010 19:27

CREATE DATABASE returns SQL ERROR SQL0101N
Hi folks, I just installed a fresh OpenSolaris with the latest image available (uname -a returns $ SunOS host01 5.11 snv_111b i86pc i386 i86pc Solaris) After installing OpenSolaris I set up also IBM DB2 Express C V9.7. The installation process was successful and I tried to login as db2inst1 to create my first... 26 Jun 2010 14:05

Data Studion and autocommit
Hi All; Is it possible to configure autocommit in Data Studio SQL processor? I can't find this feature anywhere... Kind of a show-stopper for us using the tool productively. Any insight greatly appreciated Pete H ... 23 Jun 2010 10:35

Missing db2tcpcm process
Where running DB2 9.1.0.4 There's no db2tcpcm process for our instance, and nobody can connect to it (makes sense). In db2diag.log I see this error. 2010-06-21-13.24.27.760177-240 E69677A687 LEVEL: Error PID : 1110090 TID : 1 PROC : db2sysc 0 INSTANCE: db2sims ... 22 Jun 2010 12:40