472,805 Members | 825 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

DB2 7.2 restore generating system error 1326

I am running 7.2 with fixpack 10a under W2K. I got a backup from someone
else in an attempt to debug a data issue. The other person created the
database with UTF-8 (codepage 1208), so I created a new database with that
codepage, cd to the directory where the backup was located, but the restore
failed:

db2 => create database MYDB using codeset UTF-8 territory us
DB20000I The CREATE DATABASE command completed successfully.

db2 => restore database twh_md to MYDB
SQL2529W Warning! Restoring to an existing database that is different from
the backup image database, and the alias name "MYDB" of the existing
database does not match the alias name "TWH_MD" of the backup image, and the
database name "MYDB" of the existing database does not match the database
name "TWH_MD" of the backup image. The target database will be overwritten
by the backup version.
The Roll-forward recovery logs associated with the target database will be
deleted.

Do you want to continue ? (y/n) y

SQL0902C A system error (reason code = "1326") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005

See db2diag.log below. It appears it wants to put it in G:, which is where
the original database was. What gives here ? I would think db2 would know
to put it wherever it created the new database MYDB. Any ideas what is
going on here ?

Thanks,
Scott
Error acquiring container 0 (g:\db2\node0000\sql00002\sql0000.0) for tbsp 0.
Rc = FFFFB52E

2003-11-13-15.21.34.731000 Instance:DB2 Node:000

PID:1504(db2syscs.exe) TID:3316 Appid:none

buffer_pool_services sqlbAddContainersToNewPool Probe:2

DIA9999E An internal error occurred. Report the following error code :

"0xFFFFB52E".

2003-11-13-15.21.34.761000 Instance:DB2 Node:000

PID:1504(db2syscs.exe) TID:3316 Appid:none

database_utilities sqludProcessSPCS Probe:40

DiagData

2eb5 ffff 2e05 0000 .....

2003-11-13-15.21.34.771000 Instance:DB2 Node:000

PID:1504(db2syscs.exe) TID:3316 Appid:none

database_utilities sqludProcessSPCS Probe:40

2eb5 ffff 2e05 0000 .....

2003-11-13-15.21.34.791000 Instance:DB2 Node:000

PID:1504(db2syscs.exe) TID:3316 Appid:none

database_utilities sqludCheckObjHeader Probe:10

DiagData

1ef6 ffff 0000 0000 .....

2003-11-13-15.21.34.801000 Instance:DB2 Node:000

PID:1504(db2syscs.exe) TID:3316 Appid:none

database_utilities sqludCheckObjHeader Probe:10

1ef6 ffff 0000 0000 .....

2003-11-13-15.21.34.951000 Instance:DB2 Node:000

PID:1504(db2syscs.exe) TID:3016 Appid:*LOCAL.DB2.031113211649

database_utilities sqludrsa Probe:0 Database:AKER_MD

Restore terminated.

The new database I ctreated is in sql00007, not sql00002.
Nov 12 '05 #1
4 6129

You need to use the INTO option instead of the TO option.

db2 => restore database twh_md to MYDB


restore database twh_md into MYDB

Nov 12 '05 #2
Tried that, same error.

"Gert van der Kooij" <ge**@invalid.nl> wrote in message
news:MP************************@news.xs4all.nl...

You need to use the INTO option instead of the TO option.

db2 => restore database twh_md to MYDB


restore database twh_md into MYDB

Nov 12 '05 #3
From the ? on the command line:
G:\SQLLIB\BIN>db2 ? restore db
RESTORE DATABASE source-database-alias { restore-options | CONTINUE |
ABORT }

restore-options:
[USER username [USING password]] [{TABLESPACE [ONLINE] |
TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |
HISTORY FILE [ONLINE]}] [INCREMENTAL [AUTOMATIC | ABORT]]
[{USE {TSM | XBSA} [OPEN num-sess SESSIONS] [OPTIONS {options-string |
options-filename}] | FROM dir/dev [ {,dir/dev} ... ] | LOAD shared-lib
[OPEN num-sess SESSIONS] [OPTIONS {options-string | options-filename}]}]
[TAKEN AT date-time] [TO target-directory] [INTO target-database-alias]
[NEWLOGPATH directory] [WITH num-buff BUFFERS] [BUFFER buffer-size]
[DLREPORT file-name] [REPLACE EXISTING] [REDIRECT] [PARALLELISM n]
[WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]

You probably need to specify:
FROM source directory
TO target path of the new created db
INTO db alias you want to use
.....
REPLACE EXISTING
Even then I'm not sure that this woulld work because of code page
difference. Also, error 1326 means:
SQL1326N The file or directory "<name>" cannot be accessed.

Explanation:

The file or directory "<name>" cannot be accessed because either
the file permissions are incorrect, the file path is incorrect,
or there is insufficient space in the directory or path.

User Response:

Verify that any path or filename specified in the command is
valid, you have the proper permissions to access the path or
filename, and there is sufficient space to contain the file.
Correct the problem and resubmit the command. If the problem
persists, contact your System Administrator.

HTYH, Pierre.
ScottH wrote:
Tried that, same error.

"Gert van der Kooij" <ge**@invalid.nl> wrote in message
news:MP************************@news.xs4all.nl...
You need to use the INTO option instead of the TO option.

db2 => restore database twh_md to MYDB


restore database twh_md into MYDB



--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #4
"P. Saint-Jacques" <p.*********@videotron.ca> wrote in message news:<3F**************@videotron.ca>...
From the ? on the command line:
G:\SQLLIB\BIN>db2 ? restore db
RESTORE DATABASE source-database-alias { restore-options | CONTINUE |
ABORT }

restore-options:
[USER username [USING password]] [{TABLESPACE [ONLINE] |
TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |
HISTORY FILE [ONLINE]}] [INCREMENTAL [AUTOMATIC | ABORT]]
[{USE {TSM | XBSA} [OPEN num-sess SESSIONS] [OPTIONS {options-string |
options-filename}] | FROM dir/dev [ {,dir/dev} ... ] | LOAD shared-lib
[OPEN num-sess SESSIONS] [OPTIONS {options-string | options-filename}]}]
[TAKEN AT date-time] [TO target-directory] [INTO target-database-alias]
[NEWLOGPATH directory] [WITH num-buff BUFFERS] [BUFFER buffer-size]
[DLREPORT file-name] [REPLACE EXISTING] [REDIRECT] [PARALLELISM n]
[WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]

You probably need to specify:
FROM source directory
TO target path of the new created db
INTO db alias you want to use
....
REPLACE EXISTING
Even then I'm not sure that this woulld work because of code page
difference. Also, error 1326 means:
SQL1326N The file or directory "<name>" cannot be accessed.

Explanation:

The file or directory "<name>" cannot be accessed because either
the file permissions are incorrect, the file path is incorrect,
or there is insufficient space in the directory or path.

User Response:

Verify that any path or filename specified in the command is
valid, you have the proper permissions to access the path or
filename, and there is sufficient space to contain the file.
Correct the problem and resubmit the command. If the problem
persists, contact your System Administrator.

HTYH, Pierre.
ScottH wrote:
Tried that, same error.

"Gert van der Kooij" <ge**@invalid.nl> wrote in message
news:MP************************@news.xs4all.nl...
You need to use the INTO option instead of the TO option.
db2 => restore database twh_md to MYDB

restore database twh_md into MYDB



I think you need to do the redirect restore or create the same
containers with the old one, then do the restore.

Check the syntax in restore command for the redirect restore.
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Shabam | last post by:
I keep getting a 500 error when going to a certain directory that's made from a virtual folder using UNC. I looked in the log file and found this: 2005-02-03 15:25:17 192.168.1.150 GET...
2
by: DMAC | last post by:
The following failed in EM (or whatever it is called now management studio I think) and I scripted it out and ran it in a query window to get more info. This works fine in SQL 2000 but not in 2005....
1
by: Hakim | last post by:
Hi there, I am a rookie in DB2. I have tried to do a database restoration on my system. Since it should not go directly to our REAL database, I tried to restore to a dummy database. Below...
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following SQL2059W A device full warning was...
13
by: Andy K | last post by:
Hi , I'm wondering what's going on with a restore I'm trying to do . My DB2 version is a 7.2 on a Linux RH ES 2.1 . I've copy a recent backup that was on NAS for a test on my machine . I...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...
3
by: Raed Sawalha | last post by:
Hello when I serialize an object an error generated using this function public string SerializeObject(object oClassObject,System.Type oClassType) { XmlSerializer oSerializer = new...
2
by: P. Adhia | last post by:
Hello All, I am trying to redirect-restore a backup of a DB2 V6.x system (AIX 4.x) on DB2 V8.2 system (AIX 5.2). I get the above error with no other details. db2diag.log has a series of error...
0
by: mitrofun63 | last post by:
Hello. On my production site i have DB2 9.1.2 database configured for archiving logs and making backup through TSM Data Protection for DB2 UDB The LOGARCHMETH1 parameter is set to ...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

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.