partminer
asked on
How to remove the table from set integrity pending state in db2 after load
Hi,
When I try to load the data into TableA using the below syntax
load from "H:\tab282.ixf" of ixf modified by generatedoverride insert into TableA nonrecoverable" it failed with the following error.
SQL2038N .A database system error "SQLUIIGN" occured during processing.
SQL0289N unable to locate new pages in table space "TABLESPACE_TS"
SQLSTATE=57011
After that I try to run the set integrity command but i am getting another error.
---
set integrity for tableA immediate checked;
--
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0668N Operation not allowed for reason code "3" on table
"tableA". SQLSTATE=57016
SQL0668N Operation not allowed for reason code "3" on table "TABLEA ".
1.Can you please help me how to come out of above situation.
2.If I am not sure of the exact problem how to find out effected tables after load operation or set integrity pending state tables?
Thank in advance.
When I try to load the data into TableA using the below syntax
load from "H:\tab282.ixf" of ixf modified by generatedoverride insert into TableA nonrecoverable" it failed with the following error.
SQL2038N .A database system error "SQLUIIGN" occured during processing.
SQL0289N unable to locate new pages in table space "TABLESPACE_TS"
SQLSTATE=57011
After that I try to run the set integrity command but i am getting another error.
---
set integrity for tableA immediate checked;
--
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0668N Operation not allowed for reason code "3" on table
"tableA". SQLSTATE=57016
SQL0668N Operation not allowed for reason code "3" on table "TABLEA ".
1.Can you please help me how to come out of above situation.
2.If I am not sure of the exact problem how to find out effected tables after load operation or set integrity pending state tables?
Thank in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can you please let me know how to take dummy backup in windows.I use /dev/null for linux.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I believe it should be:
backup DB dbname to NUL
Greg
backup DB dbname to NUL
Greg
ASKER
I have executed the below command
db2 backup db testdb nul
I am getting following error.
SQL30082N -security processing failed with error "3"(password missing).
db2 backup db testdb nul
I am getting following error.
SQL30082N -security processing failed with error "3"(password missing).
Hi part,
Run the same command from the DB2 instance administrator account.
Kent
Run the same command from the DB2 instance administrator account.
Kent
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear Greg, Can you please let me know how to archive the old log files.
ASKER
Hi, I am getting database is curretly in use message.How can I terminate the connected applications in windows ?Can you please let me know.
ASKER
How can I get rid of the below error.Please help me I am in big trouble.
connect to TESTDB user XXXX using
SQL1116N A connection to or activation of database "TESTDB" cannot be made
because of BACKUP PENDING. SQLSTATE=57019
SQL1116N A connection to or activation of database "TESTDB " cannot be made because of BACKUP PENDING.
Explanation:
The specified database requires a backup to be taken to provide a
starting point for roll-forward recovery.
No connection was made.
User Response:
Back up the database by calling the BACKUP routine or, if
roll-recovery is not required, set the database configuration
parameters LOGARCHMETH1 and LOGARCHMETH2 to OFF.
sqlcode : -1116
sqlstate : 57019
connect to TESTDB user XXXX using
SQL1116N A connection to or activation of database "TESTDB" cannot be made
because of BACKUP PENDING. SQLSTATE=57019
SQL1116N A connection to or activation of database "TESTDB " cannot be made because of BACKUP PENDING.
Explanation:
The specified database requires a backup to be taken to provide a
starting point for roll-forward recovery.
No connection was made.
User Response:
Back up the database by calling the BACKUP routine or, if
roll-recovery is not required, set the database configuration
parameters LOGARCHMETH1 and LOGARCHMETH2 to OFF.
sqlcode : -1116
sqlstate : 57019
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, I have taken the backup successfully using 'backup DB dbname USER username USING password to NUL '.
Can you please let me know the following.
1.Can we load the data into a table which has generated (no identity) datatype can be loaded using import option with no issues?
2.If we terminate the load process , does it impact the performance or database system?
3.What do you prefer to load data. Import or load?
Appreciate any help .Thanks so much.
Can you please let me know the following.
1.Can we load the data into a table which has generated (no identity) datatype can be loaded using import option with no issues?
2.If we terminate the load process , does it impact the performance or database system?
3.What do you prefer to load data. Import or load?
Appreciate any help .Thanks so much.
ASKER
Hi,
Even I took backup also transaction log file system (87%) did not cleared.Can you please let me know how to clean transaction log files?Please help me....
Even I took backup also transaction log file system (87%) did not cleared.Can you please let me know how to clean transaction log files?Please help me....
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear Kent/Greg,
Big thanks for all your unmeasurable help.
Can you please let me know the following.
1.I have a table that has one column defined as 'GENERATED as UCASE(xx) and GENERATED ALWAYS as DATE(xxx) '(No-identity).If I just load the data with the simple import option as below
import from \path\file.ixf of ixf insert to <tablename>
Does the table is loaded with no issues and next time when we insert the data into the tables, generated columns preserve the generated definitions?
2.If we terminate the load process , does it impact the performance or database system?
3.What do you prefer to load data. Import or load?What do you suggest?
Waiting for your response!Thanks.
Big thanks for all your unmeasurable help.
Can you please let me know the following.
1.I have a table that has one column defined as 'GENERATED as UCASE(xx) and GENERATED ALWAYS as DATE(xxx) '(No-identity).If I just load the data with the simple import option as below
import from \path\file.ixf of ixf insert to <tablename>
Does the table is loaded with no issues and next time when we insert the data into the tables, generated columns preserve the generated definitions?
2.If we terminate the load process , does it impact the performance or database system?
3.What do you prefer to load data. Import or load?What do you suggest?
Waiting for your response!Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Kent,
1.Does it mean, no extra care to be taken when we use load the tables that has generated datatypes(no-identity), using import option.Automatically import would preserve the column datatype definition.
1.Does it mean, no extra care to be taken when we use load the tables that has generated datatypes(no-identity), using import option.Automatically import would preserve the column datatype definition.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great thanks to Db2 gurus.
ASKER