During the night we replicate multiple tables from a production
database to a test database. Due to a server disk space full
condition occurring while replication was running, a tablespace was
left in 'Load Pending' status. This tablespace has about 20 tables in
it. I ran the load/terminate command and have now come to
understand that the message
'SQL3508N Error in accessing a file or path of type
"RESTART/TERMINATE INFO" during load or load query. Reason code: "1".
Path: "".'
is telling me that that particular table is not in an error state.
When I ran the load/terminate command on another table, the results
were
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
and the tablespace status changed from Load Pending to backup pending.
Rather then the hit and miss approach of running the Load/terminate on
each table and having to have a data file associated with that table,
is there a command or system table I can query that will tell me
exactly what table within a tablespace is in an error state? I
surmise that " a file or path of type "RESTART/TERMINATE INFO" " is
only created for a table in error. But, where can I see that outside
of running the load/terminate command?
Thank you for any assistance!
Randi
database to a test database. Due to a server disk space full
condition occurring while replication was running, a tablespace was
left in 'Load Pending' status. This tablespace has about 20 tables in
it. I ran the load/terminate command and have now come to
understand that the message
'SQL3508N Error in accessing a file or path of type
"RESTART/TERMINATE INFO" during load or load query. Reason code: "1".
Path: "".'
is telling me that that particular table is not in an error state.
When I ran the load/terminate command on another table, the results
were
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
and the tablespace status changed from Load Pending to backup pending.
Rather then the hit and miss approach of running the Load/terminate on
each table and having to have a data file associated with that table,
is there a command or system table I can query that will tell me
exactly what table within a tablespace is in an error state? I
surmise that " a file or path of type "RESTART/TERMINATE INFO" " is
only created for a table in error. But, where can I see that outside
of running the load/terminate command?
Thank you for any assistance!
Randi
Comment