archecker not finding the table
Gentian Hila
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
[root@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
[root@dbserver2 ~]#
RUN AS isys USER
[isys@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
[isys@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
[isys@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_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
[isys@dbserver2 root]$
Hello.
I would suggest you to:
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
From: genti...@gmail.com
To: inform...@iiug.org
_______________________________________________ Informix-list mailing list Inform...@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
Gentian Hila
John Miller iii
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
informix-l...@iiug.org wrote on 09/19/2013 08:33:40 AM:
> From: Gentian Hila <genti...@gmail.com>
> To: Alexandre Marini <alex...@briug.org>, IIUG Informix List
> <inform...@iiug.org>,
> Date: 09/19/2013 08:34 AM
> Subject: Re: archecker not finding the table
> Sent by: informix-l...@iiug.org
>
> 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.
>
> On Thu, Sep 19, 2013 at 11:06 AM, Gentian Hila <genti...@gmail.com> wrote:
> 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.
>
>
>
> [isys@dbserver2 root]$ archecker -tdvs -X -f /scratch/tablecmd/
> cust_shp_slmn_15.cmd
> [isys@dbserver2 root]$ archecker -tdvs -X -f /scratch/tablecmd/
> cust_shp_slmn_15.cmd
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.
On Thu, Sep 19, 2013 at 11:06 AM, Gentian Hila <genti...@gmail.com> wrote:
ac_config.std file has AC_VERBOSE 1 already but I get nothing on the log file.
Date: Thu, 19 Sep 2013 09:36:48 -0400
Subject: archecker not finding the table
From: genti...@gmail.com
To: inform...@iiug.org
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
Art Kagel
Art
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.