3556 : Database does not have a permanent journal

Database
Enthusiast

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.

3 REPLIES
Junior Contributor

Re: 3556 : Database does not have a permanent journal

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

Enthusiast

Re: 3556 : Database does not have a permanent journal

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

Enthusiast

Re: 3556 : Database does not have a permanent journal

thank you dieter and Raja for your inputs...