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.
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;
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;