archecker not finding the table

Discussion:

(too old to reply)

Gentian Hila

2013-09-19 13:36:48 UTC

I am running archecker with IDS 11.50 to restore a table under schema isys.

Backup is done with ontape -s L 0.

When run as root - the scan works but it does not find the table. No idea
what might be wrong. I know the table is there.

We have only one dbspace that is assigned to data - called datadbs.

However, when I try to run archecker under isys user ( the user that owns
the database - a name that is the same as the schema) it simply bombs with
Unable to initialize resources but I think all the permissions look fine to
me.

Below is the schema file as well. Any suggestion is appreaciated very much.

Genti

RUN AS root USER

[***@dbserver2 ~]# archecker -tdvs -X -f /scratch/tablecmd/
cust_shp_slmn_15.cm
d
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006

AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
Restore only physical image of archive
Target table [cust_shp_slmn_15] already created
Extracting table prod_8_d:cust_shp_slmn into prod_8_d:cust_shp_slmn_15

Please put in Phys Tape 1.
Type <return> or 0 to end:

Tape type: Archive Backup Tape
OnLine version: IBM Informix Dynamic Server Version 11.50.FC6WE
Archive date: Sun Sep 15 23:01:24 2013
Archive level: 0
Tape blocksize: 1048576
Tape size: 50000000
Tape number in series: 1
........................................
........................................
........................................
........................................

Scan PASSED
Control page checks PASSED
Table checks PASSED
Table extraction commands 1
Tables found on archive 0
Tables not located on archive 1
LOADED: prod_8_d:cust_shp_slmn_15 produced 0 rows
[***@dbserver2 ~]#

RUN AS isys USER

[***@dbserver2 root]$ archecker -tdvs -X -f
/scratch/tablecmd/cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006

AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources
[***@dbserver2 root]$

Schema file

set commit to 10000;
set workspace to datadbs;

database prod_8_d;

-- source table
CREATE TABLE isys.cust_shp_slmn (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;

CREATE TABLE isys.cust_shp_slmn_15 (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;

INSERT INTO isys.cust_shp_slmn_15
SELECT cust_num, ship_num, sa_item,agent_num,slmn_num,curr_slmn_num,changed
from isys.ord;

restore to current with no log;

Gentian Hila

2013-09-19 15:06:46 UTC

Permalink

ac_config.std file has AC_VERBOSE 1 already but I get nothing on the log
file.

isys is the DBA user but when I try that it says Unable to initialize
resources.

I am not sure what resources it is complaining about as all the permissions
seem fine to me.

[***@dbserver2 root]$ archecker -tdvs -X -f
/scratch/tablecmd/cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources

Hello.
1) modify your AC_CONFIG file, and change AC_VERBOSE to 1, instead of ON.
2) re-run your archecker, your schema file seems right to me. Consider
running it as informix user, or any other with DBA permissions/DBSA
permissions.
3) check your /tmp/ac_msg.log log file, in order to get a more detailed
info about whatŽs going wrong
Please post the last lines of your ac_msg.log file, if you cannot correct
your issue.
Regards.
*Alexandre Marini*
*IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10*
* IBM Information Management Informix Technical Professional*
* IBM Infosphere DataStage Technical Professional*
*Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
*
------------------------------
Date: Thu, 19 Sep 2013 09:36:48 -0400
Subject: archecker not finding the table
I am running archecker with IDS 11.50 to restore a table under schema isys.
Backup is done with ontape -s L 0.
When run as root - the scan works but it does not find the table. No idea
what might be wrong. I know the table is there.
We have only one dbspace that is assigned to data - called datadbs.
However, when I try to run archecker under isys user ( the user that owns
the database - a name that is the same as the schema) it simply bombs with
Unable to initialize resources but I think all the permissions look fine to
me.
Below is the schema file as well. Any suggestion is appreaciated very much.
Genti
RUN AS root USER
cust_shp_slmn_15.cm
d
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
Restore only physical image of archive
Target table [cust_shp_slmn_15] already created
Extracting table prod_8_d:cust_shp_slmn into prod_8_d:cust_shp_slmn_15
Please put in Phys Tape 1.
Tape type: Archive Backup Tape
OnLine version: IBM Informix Dynamic Server Version 11.50.FC6WE
Archive date: Sun Sep 15 23:01:24 2013
Archive level: 0
Tape blocksize: 1048576
Tape size: 50000000
Tape number in series: 1
........................................
........................................
........................................
........................................
Scan PASSED
Control page checks PASSED
Table checks PASSED
Table extraction commands 1
Tables found on archive 0
Tables not located on archive 1
LOADED: prod_8_d:cust_shp_slmn_15 produced 0 rows
RUN AS isys USER
/scratch/tablecmd/cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources
Schema file
set commit to 10000;
set workspace to datadbs;
database prod_8_d;
-- source table
CREATE TABLE isys.cust_shp_slmn (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;
CREATE TABLE isys.cust_shp_slmn_15 (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;
INSERT INTO isys.cust_shp_slmn_15
SELECT cust_num, ship_num, sa_item,agent_num,slmn_num,curr_slmn_num,changed
from isys.ord;
restore to current with no log;
_______________________________________________ Informix-list mailing list

Gentian Hila

2013-09-19 15:33:40 UTC

Permalink

Tried it as informix and made sure the storage permission was set properly.

It says that it loaded all the files but I do not see them in the table yet.

Thank you very very much for your suggestion.

Post by Gentian Hila
ac_config.std file has AC_VERBOSE 1 already but I get nothing on the log
file.
isys is the DBA user but when I try that it says Unable to initialize
resources.
I am not sure what resources it is complaining about as all the
permissions seem fine to me.
/scratch/tablecmd/cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources

Hello.
1) modify your AC_CONFIG file, and change AC_VERBOSE to 1, instead of ON.
2) re-run your archecker, your schema file seems right to me. Consider
running it as informix user, or any other with DBA permissions/DBSA
permissions.
3) check your /tmp/ac_msg.log log file, in order to get a more detailed
info about whatŽs going wrong
Please post the last lines of your ac_msg.log file, if you cannot correct
your issue.
Regards.
*Alexandre Marini*
*IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10*
* IBM Information Management Informix Technical Professional*
* IBM Infosphere DataStage Technical Professional*
*Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
*
------------------------------
Date: Thu, 19 Sep 2013 09:36:48 -0400
Subject: archecker not finding the table
I am running archecker with IDS 11.50 to restore a table under schema
isys.
Backup is done with ontape -s L 0.
When run as root - the scan works but it does not find the table. No idea
what might be wrong. I know the table is there.
We have only one dbspace that is assigned to data - called datadbs.
However, when I try to run archecker under isys user ( the user that owns
the database - a name that is the same as the schema) it simply bombs with
Unable to initialize resources but I think all the permissions look fine to
me.
Below is the schema file as well. Any suggestion is appreaciated very
much.
Genti
RUN AS root USER
cust_shp_slmn_15.cm
d
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
Restore only physical image of archive
Target table [cust_shp_slmn_15] already created
Extracting table prod_8_d:cust_shp_slmn into prod_8_d:cust_shp_slmn_15
Please put in Phys Tape 1.
Tape type: Archive Backup Tape
OnLine version: IBM Informix Dynamic Server Version 11.50.FC6WE
Archive date: Sun Sep 15 23:01:24 2013
Archive level: 0
Tape blocksize: 1048576
Tape size: 50000000
Tape number in series: 1
........................................
........................................
........................................
........................................
Scan PASSED
Control page checks PASSED
Table checks PASSED
Table extraction commands 1
Tables found on archive 0
Tables not located on archive 1
LOADED: prod_8_d:cust_shp_slmn_15 produced 0 rows
RUN AS isys USER
/scratch/tablecmd/cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources
Schema file
set commit to 10000;
set workspace to datadbs;
database prod_8_d;
-- source table
CREATE TABLE isys.cust_shp_slmn (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;
CREATE TABLE isys.cust_shp_slmn_15 (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;
INSERT INTO isys.cust_shp_slmn_15
SELECT cust_num, ship_num,
sa_item,agent_num,slmn_num,curr_slmn_num,changed
from isys.ord;
restore to current with no log;
_______________________________________________ Informix-list mailing
http://www.iiug.org/mailman/listinfo/informix-list

John Miller iii

2013-09-19 17:16:03 UTC

Permalink

Is the original database name and the target database name the same ( i.e.
both prod_8_d) ??

My guess is the name of the database, table, owner or dbspace might be
incorrect. Because you supplied
all of these values they must all match. Here is what I would suggest to
do.

Add the following line to you ac_config

AC_DEBUG med,acu

This will add information into the the archecker log which will include the
table name of each table/fragment which is not being processed.

Also please remove the dbspace name in the table schema for the source
table. If for some reason this table got created
in the wrong location then you will not find it.

John F. Miller III

Date: 09/19/2013 08:34 AM
Subject: Re: archecker not finding the table
Tried it as informix and made sure the storage permission was set

properly.

It says that it loaded all the files but I do not see them in the table

yet.

Thank you very very much for your suggestion.
ac_config.std file has AC_VERBOSE 1 already but I get nothing on thelog

file.

isys is the DBA user but when I try that it says Unable to
initialize resources.
I am not sure what resources it is complaining about as all the
permissions seem fine to me.
cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name:   archecker
Version:        8.0
Released:       2009-12-15 22:08:23
CSDK:           IBM Informix CSDK Version 3.50
ESQL:           IBM Informix-ESQL Version 3.50.FC4
Compiled:       12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri
Feb 24 16:56:28 EST 2006
AC_STORAGE               /tmp
AC_MSGPATH               /tmp/ac_msg.log
AC_VERBOSE               on
AC_TAPEDEV               /scratch/backup/archive.info
AC_TAPEBLOCK             1024 KB
AC_LTAPEDEV              /scratch/backup/logical.info
AC_LTAPEBLOCK            1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources
Hello.
1) modify your AC_CONFIG file, and change AC_VERBOSE to 1, instead of ON.
2) re-run your archecker, your schema file seems right to me.
Consider running it as informix user, or any other with DBA
permissions/DBSA permissions.
3) check your /tmp/ac_msg.log   log file, in order to get a more
detailed info about whatŽs going wrong
Please post the last lines of your ac_msg.log file, if you cannot
correct your issue.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
Date: Thu, 19 Sep 2013 09:36:48 -0400
Subject: archecker not finding the table
I am running archecker with IDS 11.50 to restore a table under schema

isys.

Backup is done with ontape -s L 0.
When run as root - the scan works but it does not find the table. No
idea what might be wrong. I know the table is there.
We have only one dbspace that is assigned to data - called datadbs.
However, when I try to run archecker under isys user ( the user that
owns the database - a name that is the same as the schema) it simply
bombs with Unable to initialize resources but I think all the
permissions look fine to me.
Below is the schema file as well. Any suggestion is appreaciated very

much.

Genti
RUN AS root USER
cust_shp_slmn_15.cm
d
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name:   archecker
Version:        8.0
Released:       2009-12-15 22:08:23
CSDK:           IBM Informix CSDK Version 3.50
ESQL:           IBM Informix-ESQL Version 3.50.FC4
Compiled:       12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri
Feb 24 16:56:28 EST 2006
AC_STORAGE               /tmp
AC_MSGPATH               /tmp/ac_msg.log
AC_VERBOSE               on
AC_TAPEDEV               /scratch/backup/archive.info
AC_TAPEBLOCK             1024 KB
AC_LTAPEDEV              /scratch/backup/logical.info
AC_LTAPEBLOCK            1024 KB
Dropping old log control tables
Restore only physical image of archive
Target table [cust_shp_slmn_15] already created
Extracting table prod_8_d:cust_shp_slmn into prod_8_d:cust_shp_slmn_15
Please put in Phys Tape 1.
Tape type:      Archive Backup Tape
OnLine version: IBM Informix Dynamic Server Version 11.50.FC6WE
Archive date:   Sun Sep 15 23:01:24 2013
Archive level: 0
Tape blocksize: 1048576
Tape size: 50000000
Tape number in series: 1
........................................
........................................
........................................
........................................
Scan PASSED
Control page checks PASSED
Table checks PASSED
Table extraction commands 1
Tables found on archive 0
Tables not located on archive 1
LOADED: prod_8_d:cust_shp_slmn_15 produced 0 rows
RUN AS isys USER
cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name:   archecker
Version:        8.0
Released:       2009-12-15 22:08:23
CSDK:           IBM Informix CSDK Version 3.50
ESQL:           IBM Informix-ESQL Version 3.50.FC4
Compiled:       12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri
Feb 24 16:56:28 EST 2006
AC_STORAGE               /tmp
AC_MSGPATH               /tmp/ac_msg.log
AC_VERBOSE               on
AC_TAPEDEV               /scratch/backup/archive.info
AC_TAPEBLOCK             1024 KB
AC_LTAPEDEV              /scratch/backup/logical.info
AC_LTAPEBLOCK            1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources
Schema file
set commit to 10000;
set workspace to datadbs;
database prod_8_d;
-- source table
CREATE TABLE isys.cust_shp_slmn (
        cust_num             CHAR(10),
        ship_num             CHAR(10),
        sa_item              CHAR(4),
        agent_num            CHAR(10),
        slmn_num             CHAR(4),
        curr_slmn_num        CHAR(4),
        changed              DATE
) in datadbs;
CREATE TABLE isys.cust_shp_slmn_15 (
        cust_num             CHAR(10),
        ship_num             CHAR(10),
        sa_item              CHAR(4),
        agent_num            CHAR(10),
        slmn_num             CHAR(4),
        curr_slmn_num        CHAR(4),
        changed              DATE
) in datadbs;
INSERT INTO isys.cust_shp_slmn_15
SELECT cust_num, ship_num,

sa_item,agent_num,slmn_num,curr_slmn_num,changed

from isys.ord;
restore to current with no log;
_______________________________________________ Informix-list mailing

list

_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Gentian Hila

2013-09-19 17:44:42 UTC

Permalink

Every thing is working fine now. Thank you everyone.

I was looking in the wrong db. :) Ugh.

Post by Gentian Hila
Tried it as informix and made sure the storage permission was set properly.
It says that it loaded all the files but I do not see them in the table
yet.
Thank you very very much for your suggestion.

Hello.
1) modify your AC_CONFIG file, and change AC_VERBOSE to 1, instead of ON.
2) re-run your archecker, your schema file seems right to me. Consider
running it as informix user, or any other with DBA permissions/DBSA
permissions.
3) check your /tmp/ac_msg.log log file, in order to get a more
detailed info about whatŽs going wrong
Please post the last lines of your ac_msg.log file, if you cannot
correct your issue.
Regards.
*Alexandre Marini*
*IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10*
* IBM Information Management Informix Technical Professional*
* IBM Infosphere DataStage Technical Professional*
*Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
*
------------------------------
Date: Thu, 19 Sep 2013 09:36:48 -0400
Subject: archecker not finding the table
I am running archecker with IDS 11.50 to restore a table under schema
isys.
Backup is done with ontape -s L 0.
When run as root - the scan works but it does not find the table. No
idea what might be wrong. I know the table is there.
We have only one dbspace that is assigned to data - called datadbs.
However, when I try to run archecker under isys user ( the user that
owns the database - a name that is the same as the schema) it simply bombs
with Unable to initialize resources but I think all the permissions look
fine to me.
Below is the schema file as well. Any suggestion is appreaciated very
much.
Genti
RUN AS root USER
cust_shp_slmn_15.cm
d
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb
24 16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
Restore only physical image of archive
Target table [cust_shp_slmn_15] already created
Extracting table prod_8_d:cust_shp_slmn into prod_8_d:cust_shp_slmn_15
Please put in Phys Tape 1.
Tape type: Archive Backup Tape
OnLine version: IBM Informix Dynamic Server Version 11.50.FC6WE
Archive date: Sun Sep 15 23:01:24 2013
Archive level: 0
Tape blocksize: 1048576
Tape size: 50000000
Tape number in series: 1
........................................
........................................
........................................
........................................
Scan PASSED
Control page checks PASSED
Table checks PASSED
Table extraction commands 1
Tables found on archive 0
Tables not located on archive 1
LOADED: prod_8_d:cust_shp_slmn_15 produced 0 rows
RUN AS isys USER
/scratch/tablecmd/cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb
24 16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources
Schema file
set commit to 10000;
set workspace to datadbs;
database prod_8_d;
-- source table
CREATE TABLE isys.cust_shp_slmn (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;
CREATE TABLE isys.cust_shp_slmn_15 (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;
INSERT INTO isys.cust_shp_slmn_15
SELECT cust_num, ship_num,
sa_item,agent_num,slmn_num,curr_slmn_num,changed
from isys.ord;
restore to current with no log;
_______________________________________________ Informix-list mailing
http://www.iiug.org/mailman/listinfo/informix-list

Art Kagel

2013-09-22 00:43:57 UTC

Permalink

Have you tried running archecker as user informix?

Art

Art S. Kagel, Principal Consultant

Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

Post by Gentian Hila
I am running archecker with IDS 11.50 to restore a table under schema isys.
Backup is done with ontape -s L 0.
When run as root - the scan works but it does not find the table. No idea
what might be wrong. I know the table is there.
We have only one dbspace that is assigned to data - called datadbs.
However, when I try to run archecker under isys user ( the user that owns
the database - a name that is the same as the schema) it simply bombs with
Unable to initialize resources but I think all the permissions look fine to
me.
Below is the schema file as well. Any suggestion is appreaciated very much.
Genti
RUN AS root USER
cust_shp_slmn_15.cm
d
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
Restore only physical image of archive
Target table [cust_shp_slmn_15] already created
Extracting table prod_8_d:cust_shp_slmn into prod_8_d:cust_shp_slmn_15
Please put in Phys Tape 1.
Tape type: Archive Backup Tape
OnLine version: IBM Informix Dynamic Server Version 11.50.FC6WE
Archive date: Sun Sep 15 23:01:24 2013
Archive level: 0
Tape blocksize: 1048576
Tape size: 50000000
Tape number in series: 1
........................................
........................................
........................................
........................................
Scan PASSED
Control page checks PASSED
Table checks PASSED
Table extraction commands 1
Tables found on archive 0
Tables not located on archive 1
LOADED: prod_8_d:cust_shp_slmn_15 produced 0 rows
RUN AS isys USER
/scratch/tablecmd/cust_shp_slmn_15.cmd
IBM Informix Dynamic Server Version 11.50.FC6WE
Program Name: archecker
Version: 8.0
Released: 2009-12-15 22:08:23
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FC4
Compiled: 12/15/09 22:08 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24
16:56:28 EST 2006
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /scratch/backup/archive.info
AC_TAPEBLOCK 1024 KB
AC_LTAPEDEV /scratch/backup/logical.info
AC_LTAPEBLOCK 1024 KB
Dropping old log control tables
CRITICAL ERROR: Unable to initialize resources
Schema file
set commit to 10000;
set workspace to datadbs;
database prod_8_d;
-- source table
CREATE TABLE isys.cust_shp_slmn (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;
CREATE TABLE isys.cust_shp_slmn_15 (
cust_num CHAR(10),
ship_num CHAR(10),
sa_item CHAR(4),
agent_num CHAR(10),
slmn_num CHAR(4),
curr_slmn_num CHAR(4),
changed DATE
) in datadbs;
INSERT INTO isys.cust_shp_slmn_15
SELECT cust_num, ship_num, sa_item,agent_num,slmn_num,curr_slmn_num,changed
from isys.ord;
restore to current with no log;
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list