All Forums Database
03 Oct 2013
3556 : Database does not have a permanent journal

Hi All,
Below is my table,
 CREATE SET TABLE jedi_cly_db.zam_dum ,NO FALLBACK ,
      NO BEFORE JOURNAL,
      NO AFTER JOURNAL,
      CHECKSUM = DEFAULT
      (
       col1 VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT USER ,
       col2 INTEGER CHECK ( col2  NOT IN (1 ,4 ,5 ) ))
 UNIQUE PRIMARY INDEX ( col2 );
 
Then i execute below alter statement,
alter table jedi_cly_db.zam_dum,before journal
then i get below error,
3556 : Database does not have a permanent journal...
Please let me know the reason.

Mahesh Abbigeri
dnoeth 4628 posts Joined 11/04
03 Oct 2013

Hi Mahesh,
well, the reason is that  jedi_cly_db does not have a permanent journal :-)
You must specify another database with an already existing PJ.
Or you add a PJ to jedi_cly_db:

MODIFY DATABASE  jedi_cly_db DEFAULT JOURNAL TABLE = myjrnl;

 
Dieter

Dieter

Raja_KT 1246 posts Joined 07/09
03 Oct 2013

If developer does not have the right to modify the database, then he must request the DBA. Conventionally, PJ comes along with a table that requests it. It is usually
CREATE DATABASE xxxxx ........ DEFAULT JOURNAL TABLE = xxxxx.yyyyyy;
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

04 Oct 2013

thank you dieter and Raja for your inputs...

Mahesh Abbigeri

You must sign in to leave a comment.