473,320 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to get out of "BACKUP PENDING. SQLSTATE=57019 on DB2" State

How do you recover from a

BACKUP PENDING. SQLSTATE=57019 on DB2 (XP O/S)?

Reason probably because I set LOGARCHMETH1 to TSM in error
Need to be LOGARCHMETH1 OFF

Current situation means I cannot connect to database because it has 'BACKUP PENDING' - so I cannot do anything with the database - need a 'get out of jail' solution.

Help please.
Mar 23 '12 #1
0 2694

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: R. Clausen | last post by:
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...
3
by: Lew | last post by:
Hi, I was wondering if there is a way to determine the tablespace id of each tablespace on a backup image. I want to perform a redirected restore pointing the tablespace containers to...
2
by: bwmiller16 | last post by:
Folks - OpSys: RH Linux, AS3 DB: UDB 8.2.0 (FP7 Stinger) HW: 2 X-series We setup a HADR pair and they went into PEER state (after we backed-up the DB on primary and restored the DB on the...
3
by: Stephen | last post by:
This is probably something simple but I've been trying for a while now and can't seem to get it. I'm loading a table from an IXF file with the following command 'load from...
3
by: Konstantin Andreev | last post by:
Hello, everybody. I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with Examples", but still unable to answer this simple...
7
by: satish mullapudi | last post by:
Hi All, I am using Db2 UDB v 8.2 on RHEL . I have performed a load operation on a table. Now that tablespace has been switched into RESTORE PENDING state. Now I can only read the data in the...
0
by: kuna | last post by:
Hello , I tried deleting a half million rows from a table with a couple of million rows. But I got an error saying Table space access is not allowed. SQLSTATE=55039. When I checked the...
0
by: bacterium | last post by:
Help me ,Please!!! I tried to use the DB2 database,but I got an error:SQL116N because of BACKUP PENDING,cannot connect or active"PBZXJK(DataBase Name)",SQLConnectAttr failured. Thanks!
1
by: balubkp | last post by:
hai can u please send me the backup pending state details and solution
0
by: normajeansebastian | last post by:
Hello, db2v9.1 fix pack 1 on sun solaris 2.10 every night we do an online backup on this system. (db2 & netbackup) last night netbackup had a problem and the process died on the netbackup...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.