Onarchive problem on Informix-Online DSA 7.20
Posted in 1997
Hi,
I working on migration from Informix-Online DSA 7.11 UC1 to Informix-Online
DSA 7.20 UC2 running in Unisys OS SVR4 1.4.
I had installed Informix 7.20 in a new directory by setting INFORMIXDIR to
the new directory. I had also installed 7.20 to on my test server.
I have the following questions regarding the migration :-
1. After installation, I found that "Informix-connect 7.20 UC2" and
"Online-DS 7.20
UC2" are not writing their serial nos. in $INFORMIXDIR/etc/.snfile . Does
it mean
that my installation failed (but I did not get any errors during install).
2. sysmaster database is built when I go to Online mode from Quiescent mode.
But migration manual says that it will be built when I issue "oninit -s"
after
install.
3. I ran all the "oncheck" consistency checking on my database and sysmaster,
they ran fine. After that I started a Level=0 archive using On-Archive it
failed
with the following message in the oncatlgr.out.3250 :
********************* ONCATLGR ERROR ************************
Error from CAT_DBINTFC Module on : 12-MAR-1997:19:10:59
Working area number : 2
Working area status : READY
Cursor Status # -284
Error Description : Error during call to Informix statement SELECT
Function Name :CDI_CHECK_DBSET_ACTIVE
Cursor database Comment : A subquery has returned not exactly one row.
******************* END OF REPORT ************************
In my archive script I am using the following command to do the archive :-
IN_DBSPACE="rootdbs,dbspace1"
IN_LEVEL=0
VSET_NAME=archvset
./onarchive "delete/dbspaceset=alldbs"
./onarchive "define/dbspaceset=alldbs/dbspace=(${IN_DBSPACE})"
./onarchive "archive/dbspaceset=alldbs/level=$IN_LEVEL/vset=$VSET_NAME
/immediate/autovop"
I would appreciate solutions for the above said problems. Plus I would like
to
know any bugs or changes to be taken care while migrating to Informix 7.20
UC2
from Informix 7.11 UC1.
Venky