Solved: DB2 v9.1fp4 on suse linux 10sp2 - redirect restor ...

Hi All,

First of all thank you, for valuable TIME.

issue:

My development server got crashed due to failure of dedicated SAN. in simple lost every thing. since, even DB2 backups happening to SAN.

requirement:

As we lost all the developments and configuration of development server, we need build a DEV from PRD.

Steps taken:

a. we have installed Suse 10sp2 followed by db2 v9.1 fp4 and SAP ERP6.0 sr2.

b. taken backup of db2 & sap kernel backup by tar command followed by SAP db13 backup along with logs - for newly installed Development server.

hostname - development

SID - DEV

c. I need to restore development server with sid DEV from the backup of production with sid PRD.

To get all the data {development data, transaction data & configuration etc..}

Problem

Till now i haven't worked on DB2 restore, and the current requirement is to dump data from PRD in to DEV.

i.e.. db2 redirect restore

current landscape status:

Both production and development {freshly installed} are up and working fine.

PRD with all the live data, DEV freshly installed and without data.

Need to restore data from PRD to DEV.

Database: DB2 v9.1 fp4

OS: SUSE linux 10 sp2

SAP solution: ERP 6.0 sr2

Backup of PRD: in to SAN box {backup folder}, backup triggered by DB13 with include logs option.

I request you to guide me in understanding and performing the restoration.

i.e.. the steps to be performed along with the necessary precautions to be take to avoid problems.

PRD data to DEV.

Thank you very much your time.

Harika

SAP Managed Tags:
IBM Db2 for Linux, UNIX, and Windows

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Best thing to do is just follows SAP's system copy guide, using the database restore method for DB2.

Copy guide's can be found here [https://service.sap.com/instguidesNW70|https://service.sap.com/instguidesNW70], look under the 'installation' link on the left hand side. You most likely need the NW7 EpH1 ABAP guide, direct link to it is [here.|https://websmp208.sap-ag.de/~sapidb/011000358700000171822011E]

Since you already have the DEV system running and just need the database refreshed, at a very high level the process will be a little like this;

- Stop DEV system & drop DEV database

- Do re-directed restore of your PRD backup into DEV

- Complete post processing tasks as described in SAP's system copy guide

Helpful tip -> set you number of batch processes (rdisp/wp_no_btc) to zero on the DEV system the first time you start it after doing the PRD restore. This will stop any batch jobs starting which might send emails or process interfaces, you can then goto SM37 and disable all your batch jobs, then restart DEV with some batch processes defined.

Daniel

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Guide me in creating redirect restore script from the existing BACKUP image.

The backup image file name: PRD.0.db2prd.NODE0000.CATN0000.20110505213636.001

Do i have to copy the backup image file to freshly installed DEV system, and generate the script ?

It will be better to create a REDIRECTED script during backup along with replace command {for replacing PRD to DEV & db2prd to db2dev}

i.e.. taking backup and generating script with the help of "brdb6brt" {24th patch level version 7.00}.

ex: brdb6brt u2013s PRD u2013bm RETRIEVE u2013replace PRD=QAS,db2prd=db2qas

option BOTH for backup and retrive.

help in getting the correct syntax and location of execution.

regards,

Harika

You should use brdb6brt to create the restore script as the db2prd user 'against' the PRD database, just after your backup completes.

Check SAP's DB2 admin guide for more detail on brdb6brt

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f03d5fb8-b619-2b10-c383-c6d568728...

This is what I normally do

-backup PRD database as you normally would

-generate restore script as the db2prd user, once the backup is finished, personally never used the '-replace' option so would run this;

'brdb6brt -s PRD -bm RETRIEVE -user db2prd -using <you_password_here>'

-copy the DB2 backup file and output from brdb6brt command (PRD_NODE0000.scr) to the DEV host

-adjust the PRD_NODE0000.scr file so it will do the restore into your DEV instance (looks like this is what the '-replace' option might do automatically), These are the lines you most likely need to change so they match the DEV system you are restoring into

USER db2<sid> USING <password>

FROM /path/to/backup/image/

ON /db2/<SID>/sapdata1, /dev/<SID>/sapdata2

INTO <SID>

NEWLOGPATH /db2/<SID>/log_dir/NODE0000/

- check the adjusted restore file as the db2dev user

'brdb6brt -bm CHECK -ip PRD_NODE0000.scr'

- if there are no problems do the restore of PRD into DEV, as db2dev user again

'db2 -tvf PRD_NODE0000.scr'

- not sure if you've got an online or offline backup but might need to rollforward and open/activate the database with 'db2 rollforward db <SID> ...' command

- from here you can start the post db restore steps as detailed in the system copy guide

EDIT - I use automatic storage, if you don't using brdb6brt will be a little different, check SAP's admin guide linked above

Edited by: Daniel Parker on May 9, 2011 3:28 PM

Hi Daniel Parker,

Thanks for your reply.

As per steps and Adminstration guide, i have taken Backup with "brdb6brt -bm BOTH ......" This is offline backup.

the above command generated Backup file along with Script {*.scr} file and .brp file.

i have copied to installed Development server (full installation is over. general standalone installation. taken backup after installation) & the script i.e.. replace steps. so, that the replace will ensure to restore backup from PRD in to DEV

i.e.. /db2/DEV .... etc.

Restoration without rollforward, restoration compleated succesful.

When i start database by "startdb" its not starting.

error as "activate database failed" & r3trans connection failed.

performed with user "db2<sid>" i.e.. db2dev.

request you to guide me for activating the Database and necessary following steps.

i.e.. steps required for SAP startup.

HI Daniel,

the restoration log as follows:-

<HOSTNAME>:db2dev 69> db2 -tvf PRD_NODE0000.scr

UPDATE COMMAND OPTIONS USING S ON Z ON PRD_NODE0000.out V ON

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

SET CLIENT ATTACH_NODE 0

DB20000I The SET CLIENT command completed successfully.

SET CLIENT CONNECT_NODE 0

DB20000I The SET CLIENT command completed successfully.

@./PRD_NODE0000.scr@

RESTORE DATABASE PRD FROM /PRD TAKEN AT 20110507011331 ON /db2/DEV/sapdata4 ,/db2/DEV/sapdata3 ,/db2/DEV/sapdata2 ,/db2/DEV/sapdata1 DBPATH ON /db2/DEV INTO DEV NEWLOGPATH /db2/DEV/log_dir/NODE0000/ WITH 2 BUFFERS BUFFER 1024 REDIRECT WITHOUT ROLLING FORWARD

SQL2528W Warning! Restoring to an existing database that is the same as the

backup image database, but the alias name "DEV" of the existing database does

not match the alias "PRD" of backup image, and the database name "DEV" of the

existing database does not match the database name "PRD" of the backup image.

The target database will be overwritten by the backup version.

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

SQL1277W A redirected restore operation is being performed. Table space

configuration can now be viewed and table spaces that do not use automatic

storage can have their containers reconfigured.

DB20000I The RESTORE DATABASE command completed successfully.

SET TABLESPACE CONTAINERS FOR 3 USING ( PATH /db2/DEV/saptemp1/NODE0000/temp16/PSAPTEMP16.container000 )

DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

SET TABLESPACE CONTAINERS FOR 4 USING ( PATH /db2/DEV/saptemp1/NODE0000/temp16/SYSTOOLSTMPSPACE.container000 )

DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

RESTORE DATABASE PRD CONTINUE

DB20000I The RESTORE DATABASE command completed successfully.

***********************************************************

THE RESTORE PROCEDURE HAS NOW FINISHED SUCCESSFULLY **

***********************************************************

After this restoration on Standalone server of Development, we are not able to start by "startdb" its giving error as Activate database failed & r3trans connection failed.

Looks like you need to complete the roll forward on your database and follow post restore instructions in SAP system copy guide to re-configure permissions and the like.

check rollforward with "db2 rollforward db DEV query status", will most likely say 'db pending', since you did an offline you just need to complete it with "db2 rollforward db DEV complete"

once that is done you MUST read instructions in the system copy guide for post restore db changes before trying to start SAP

Hi Daneil,

please check the below:-

<hostname>:db2dev 71> db2list

CORRECT>db2ilist (y|n|e|a)? yes

db2inst1

db2dev

<hostname>:db2dev 72> db2 list node directory

SQL1027N The node directory cannot be found.

<hostname>:db2dev 73> db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = DEV

Database name = DEV

Local database directory = /db2/DEV

Database release level = b.00

Comment = SAP database DEV

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

<hostname>:db2dev 74> db2ilist

db2inst1

db2dev

<hostname>:db2dev 75> GET DATABASE CONFIGURATION

GET: Command not found.

<hostname>:db2dev 76> db2tbst

Usage: db2tbst <tablespace state>

<hostname>:db2dev 77> db2level

DB21085I Instance "db2dev" uses "64" bits and DB2 code release "SQL09014" with

level identifier "01050107".

Informational tokens are "DB2 v9.1.0.4", "special_19276", "MI00215_19276", and

Fix Pack "4".

Product is installed at "/opt/ibm/db2/V9.1".

Hi Daneil,

Thanks for your reply.

The rollforwards status is as follows:-

<hostname>:db2dev 78> db2 rollforward db DEV query status

Rollforward Status

Input database alias = DEV

Number of nodes have returned status = 1

Node number = 0

Rollforward status = not pending

Next log file to be read =

Log files processed = -

Last committed transaction = 2011-05-06-21.14.35.000000 UTC

Hi,

How about trying SAP note 713524?

What is the error message written in startdb.log?

Also you may try "R3trans -d" and check the error message in trans.log.

Regards,

Masako

request you to check the following:-

<hostname>:db2dev 57> db2licm -l

Product name: "DB2 Enterprise Server Edition"

License type: "CPU"

Expiry date: "Permanent"

Product identifier: "db2ese"

Version information: "9.1"

Annotation: "-3;(_c)"

Features:

DB2 Database Partitioning: "Licensed"

DB2 Performance Optimization ESE: "Not licensed"

DB2 Storage Optimization: "Licensed"

DB2 Advanced Access Control: "Not licensed"

DB2 Geodetic Data Management: "Not licensed"

IBM Homogeneous Federation ESE: "Not licensed"

DB2 pureXML ESE: "Not licensed"

<hostname>:db2dev 58> exit

logout

<hostname>:/ # su - devadm

<hostname>:devadm 48> startsap

Checking db6 db Database

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

***********************************************************************

This is Saposcol Version COLL 20.95 700 - v2.16, AMD/Intel x86_64 with Linux, 2008/08/28
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 18927) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/DEV/SYS/exe/run/startdb

05/12/2011 21:28:20 0 0 SQL1026N The database manager is already active.

SQL1026N The database manager is already active.

Activate database failed

R3trans connect failed

DB startup failed

<hostname>:devadm 49> exit

logout

<hostname>:/ # su - db2dev

<hostname>:db2dev 51> db2 rollforward db DEV query status

SQL1035N The database is currently in use. SQLSTATE=57019

<hostname>:db2dev 52> db2stop

05/12/2011 21:37:22 0 0 SQL1064N DB2STOP processing was successful.

SQL1064N DB2STOP processing was successful.

<hostname>:db2dev 53> db2 rollforward db DEV query status

SQL1032N No start database manager command was issued. SQLSTATE=57019

<hostname>:db2dev 54> db2start

05/12/2011 21:37:37 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

<hostname>:db2dev 55> db2 rollforward db DEV query status

Rollforward Status

Input database alias = DEV

Number of nodes have returned status = 1

Node number = 0

Rollforward status = not pending

Next log file to be read =

Log files processed = -

Last committed transaction = 2011-05-06-21.14.35.000000 UTC

<hostname>:db2dev 56> startdb

05/12/2011 21:38:01 0 0 SQL1026N The database manager is already active.

SQL1026N The database manager is already active.

Database activated

R3trans connect failed

Does different password for sap<sid>, db2<sid> across 2 systems are different cause this problem ?

i.e.. master password for PRD system is differnet from master password of DEV.

Do i have to change any environment variables ?

thanks for your time.

Request you to suggest on required action.

Harika N

StartDB log

Thu May 12 21:38:01 IST 2011

LOGFILE FOR STARTING DB6 (DB2 UDB)

Thu May 12 21:38:01 IST 2011

checking required environment variables

DB2INSTANCE is >db2dev<

INSTHOME is >/db2/db2dev<

DB2DBDFT is >DEV<

Thu May 12 21:38:01 IST 2011

starting database manager

05/12/2011 21:38:01 0 0 SQL1026N The database manager is already active.

SQL1026N The database manager is already active.

Database Manager started

DB20000I The ACTIVATE DATABASE command completed successfully.

Database activated

Thu May 12 21:38:05 IST 2011

R3trans connect to the database

R3trans check finished with return code: 12

R3trans connect failed

Notify your SAP/database administrator

Thu May 12 21:38:07 IST 2011

/usr/sap/DEV/SYS/exe/run/startdb: Terminating with error code 2

"R3trans -d" details are below:-

<hostname>:devadm 50> R3trans -d

This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

unicode enabled version

--- Unicode interface [nlsui1.c line 2277] pid = 21752 time = 1305218752:

Cmdline : R3trans -d

Function getenvU16 :

Array cname length MAX_ENV_LN is too small.

--- Unicode interface -

End of message -

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

db call info -

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

R3trans finished (0012).

<hostname>:devadm 51>

trans.log

4 ETW000 R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 12.05.2011 - 22:15:52

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu May 12 22:15:52 2011 84 0.000084

4 ETW000 [dev trc ,00000] db_con_init called 25 0.000109

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 29 0.000138

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/DEV/SYS/exe/run/dbdb6slib.so' ... 39 0.000177

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/DEV/SYS/exe/run/dbdb6slib.so"), hdl 0

4 ETW000 491 0.000668

4 ETW000 [dev trc ,00000] Library '/usr/sap/DEV/SYS/exe/run/dbdb6slib.so' loaded 22 0.000690

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/DEV/SYS/exe/run/dbdb6slib.so

4 ETW000 32 0.000722

4 ETW000 [dev trc ,00000] Version of '/usr/sap/DEV/SYS/exe/run/dbdb6slib.so' is "700.08", patchlevel (0.297)

4 ETW000 120 0.000842

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/DEV/SYS/exe/run/dbdb6slib.so

4 ETW000 24 0.000866

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/DEV/SYS/exe/run/dbdb6slib.so

4 ETW000 31 0.000897

4 ETW000 [dev trc ,00000] New connection 0 created 21 0.000918

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 43 0.000961

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 24 0.000985

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 17 0.001002

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 39 0.001041

4 ETW000 [dev trc ,00000] RLIMIT_STACK: current=8388608, max=-1 315 0.001356

4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) UNICODE database interface 700.08 [opt] 21 0.001377

4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 23 0.001400

4 ETW000 [dev trc ,00000] (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037) 22 0.001422

4 ETW000 [dev trc ,00000] (0.8) Support of SDBUPDEXCL (note 847616) 21 0.001443

4 ETW000 [dev trc ,00000] (0.9) DB6: use export file for dbdb6slib (note 835135) 19 0.001462

4 ETW000 [dev trc ,00000] (0.9) DB6: Core in getAndBindSQLDA (note 833183) 17 0.001479

4 ETW000 [dev trc ,00000] (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

4 ETW000 42 0.001521

4 ETW000 [dev trc ,00000] (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474) 18 0.001539

4 ETW000 [dev trc ,00000] (0.15) DB6: wrong CAST for short string ABAP type (note 861905) 21 0.001560

4 ETW000 [dev trc ,00000] (0.17) DB6: special characters in sidadm passwd (note 865839) 18 0.001578

4 ETW000 [dev trc ,00000] (0.21) DB6: no SAP_INFO comments (note 873889) 19 0.001597

4 ETW000 [dev trc ,00000] (0.22) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000 32 0.001629

4 ETW000 [dev trc ,00000] (0.23) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000 24 0.001653

4 ETW000 [dev trc ,00000] (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402) 17 0.001670

4 ETW000 [dev trc ,00000] (0.27) DB6: activate value compression (note 886231) 20 0.001690

4 ETW000 [dev trc ,00000] (0.28) DB6: optimization guidelines on views part 2 (note 868888) 18 0.001708

4 ETW000 [dev trc ,00000] (0.30) DB6: no SQL trace for SQLCancel (note 892111) 17 0.001725

4 ETW000 [dev trc ,00000] (0.33) DB6: append SAP_TA comment (note 873889) 19 0.001744

4 ETW000 [dev trc ,00000] (0.34) DB6: activate value compression with quoted names (note 886231)

4 ETW000 28 0.001772

4 ETW000 [dev trc ,00000] (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

4 ETW000 30 0.001802

4 ETW000 [dev trc ,00000] (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

4 ETW000 28 0.001830

4 ETW000 [dev trc ,00000] (0.50) DB6: reread passwords for secondary connections (note 931742)

4 ETW000 27 0.001857

4 ETW000 [dev trc ,00000] (0.52) DB6: double quote table names in optguidelines (note 868888)

4 ETW000 24 0.001881

4 ETW000 [dev trc ,00000] (0.54) DB6: error handling in DBSL CLP (note 940260) 19 0.001900

4 ETW000 [dev trc ,00000] (0.69) DB6: technical support of DB2 CLI driver (note 962892) 22 0.001922

4 ETW000 [dev trc ,00000] (0.73) DB6: log table name on TRUNCATE failure (note 970743) 21 0.001943

4 ETW000 [dev trc ,00000] (0.79) DB6: column type XML in index size calculation (note 982993)

4 ETW000 32 0.001975

4 ETW000 [dev trc ,00000] (0.82) DB6: CAST for SSTRING data types (note 989568) 19 0.001994

4 ETW000 [dev trc ,00000] (0.86) DB6: long runtimes for R3szchk (note 1000847) 18 0.002012

4 ETW000 [dev trc ,00000] (0.88) DB6: patch collection Dec 06 (note 1005574) 19 0.002031

4 ETW000 [dev trc ,00000] (0.96) DB6: patch collection Jan 07 (note 1017852) 19 0.002050

4 ETW000 [dev trc ,00000] (0.97) DB6: CLP commands with DB2 CLI Driver (note 1024102) 18 0.002068

4 ETW000 [dev trc ,00000] (0.99) DB6: SUBSTITUTE VALUES with FAE statements (note 1028779) 19 0.002087

4 ETW000 [dev trc ,00000] (0.107) DB6: patch collection Apr 07 (note 1047194) 20 0.002107

4 ETW000 [dev trc ,00000] (0.110) DB6: SAP user names ending with non-ASCII char (note 1054555)

4 ETW000 49 0.002156

4 ETW000 [dev trc ,00000] (0.113) DB6: work process type in application snapshot (note 1059905)

4 ETW000 25 0.002181

4 ETW000 [dev trc ,00000] (0.114) DB6: connect using SAPDBHOST and DB2DB6_SVCENAME (note 1062049)

4 ETW000 24 0.002205

4 ETW000 [dev trc ,00000] (0.117) DB6: patch for execution of long DDL statements (note 1069658)

4 ETW000 27 0.002232

4 ETW000 [dev trc ,00000] (0.122) DB6: SNAPSHOT_TBS_CFG table function is deprecated (note 1077963)

4 ETW000 27 0.002259

4 ETW000 [dev trc ,00000] (0.123) DB6: CLP commands on Windows with V9.1 (note 1080149) 16 0.002275

4 ETW000 [dev trc ,00000] (0.124) DB6: Set DB2CODEPAGE=819 for non-Unicode (note 1084400) 18 0.002293

4 ETW000 [dev trc ,00000] (0.126) DB6: reuse optguidelines on FAE statements (note 1087375) 19 0.002312

4 ETW000 [dev trc ,00000] (0.126) DB6: Enforce DB2CODEPAGE=819 for non-Unicode environments (note 1084400)

4 ETW000 30 0.002342

4 ETW000 [dev trc ,00000] (0.128) DB6: db6_free on invalid memory area (note 1092030) 17 0.002359

4 ETW000 [dev trc ,00000] (0.133) DB6: statement cache enhancements (note 1101031) 20 0.002379

4 ETW000 [dev trc ,00000] (0.136) DB6: change for enhancement pack installer (note 1111536) 22 0.002401

4 ETW000 [dev trc ,00000] (0.138) DB6: improoved table size estimate for DB8 V8 (note 1119934)

4 ETW000 28 0.002429

4 ETW000 [dev trc ,00000] (0.144) I5/OS ldappasswd support for 5250 terminal. (note 1129573)

4 ETW000 27 0.002456

4 ETW000 [dev trc ,00000] (0.144) MSSQL: ODBC fastload on separate connection (note 1131805)

4 ETW000 24 0.002480

4 ETW000 [dev trc ,00000] (0.148) DB6: allocate new CLI env handle if PID changes (note 1141570)

4 ETW000 26 0.002506

4 ETW000 [dev trc ,00000] (0.150) DB6: USE AND KEEP EXCLUSIVE LOCKS clause lost (note 1145580)

4 ETW000 31 0.002537

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '/db2/db2dev/sqllib/lib64/libdb2.so' successfully loaded

4 ETW000 9035 0.012684

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 18 0.012702

4 ETW000 [dev trc ,00000] Running with CLI runtime client libraries. 12479 0.025181

4 ETW000 [dev trc ,00000] Thu May 12 22:15:53 2011 618752 0.643933

4 ETW000 [dev trc ,00000] DB2 client driver version '09.01.0004' 23 0.643956

4 ETW000 [dev trc ,00000] Connected to DB server type 'DB2/LINUXX8664' 37 0.643993

4 ETW000 [dev trc ,00000] Connected to DB server version '09.01.0004' 18 0.644011

4 ETW000 [dev trc ,00000] Connected to 'DEV' as 'SAPDEV' schema 'SAPDEV' o.k. 1147 0.645158

4 ETW000 [dev trc ,00000] Connected: con_hdl=0 ; appl_hdl=14; appl_id="*LOCAL.db2dev.110512164553"

4 ETW000 25 0.645183

4 ETW000 [dev trc ,00000] Database code page is ok. 16 0.645199

4 ETW000 [dev trc ,00000] Database collating sequence is ok. 27316 0.672515

4 ETW000 [dev trc ,00000] DB2_WORKLOAD=SAP is set in DB2 registry as required. 10383 0.682898

4 ETW000 [dev trc ,00000] CLI Insert Buffering is disabled on single partition databases. 4419 0.687317

4 ETW000 [dev trc ,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN' 54 0.687371

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 12 0.687383

4 ETW000 [dev trc ,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN' 2888 0.690271

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN) 922 0.691193

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SAPDEV.SVERS" is an undefined name

4 ETW000 [dev trc ,00000] &+ . SQLSTATE=42704

4 ETW000 16 0.691238

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.691254

4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM SVERS WITH UR

4 ETW000 15 0.691269

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 18 0.691287

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.691303

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.691319

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] (END) 10 0.691329

4 ETW000 [dblink ,01301] ***LOG BZA=>table SVERS does not exist on database [dblink#8 @ 1301]

4 ETW000 36 0.691365

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN) 517 0.691882

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SAPDEV.DDNTT" is an undefined name

4 ETW000 21 0.691903

4 ETW000 [dev trc ,00000] &+ . SQLSTATE=42704

4 ETW000 16 0.691919

4 ETW000 [dev trc ,00000] &+

4 ETW000 15 0.691934

4 ETW000 [dev trc ,00000] &+ SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 30 0.691964

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 18 0.691982

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.691998

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.692014

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] (END) 10 0.692024

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 15 0.692039

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN) 276 0.692315

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SAPDEV.DDNTT" is an undefined name

4 ETW000 20 0.692335

4 ETW000 [dev trc ,00000] &+ . SQLSTATE=42704

4 ETW000 15 0.692350

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.692366

4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 15 0.692381

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 18 0.692399

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.692415

4 ETW000 [dev trc ,00000] &+

4 ETW000 15 0.692430

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] (END) 10 0.692440

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 17 0.692457

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN) 256 0.692713

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SAPDEV.DDNTT" is an undefined name

4 ETW000 20 0.692733

4 ETW000 [dev trc ,00000] &+ . SQLSTATE=42704

4 ETW000 27 0.692760

4 ETW000 [dev trc ,00000] &+

4 ETW000 17 0.692777

4 ETW000 [dev trc ,00000] &+ SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 16 0.692793

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 17 0.692810

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.692826

4 ETW000 [dev trc ,00000] &+

4 ETW000 15 0.692841

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN) 282 0.693175

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SAPDEV.XXXXT" is an undefined name

4 ETW000 20 0.693195

4 ETW000 [dev trc ,00000] &+ . SQLSTATE=42704

4 ETW000 16 0.693211

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.693227

4 ETW000 [dev trc ,00000] &+ SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 15 0.693242

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 18 0.693260

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.693276

4 ETW000 [dev trc ,00000] &+

4 ETW000 25 0.693301

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] (END) 11 0.693312

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODE_LG FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 15 0.693327

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN) 246 0.693573

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SAPDEV.XXXXT" is an undefined name

4 ETW000 20 0.693593

4 ETW000 [dev trc ,00000] &+ . SQLSTATE=42704

4 ETW000 16 0.693609

4 ETW000 [dev trc ,00000] &+

4 ETW000 15 0.693624

4 ETW000 [dev trc ,00000] &+ SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 17 0.693641

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 17 0.693658

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.693674

4 ETW000 [dev trc ,00000] &+

4 ETW000 15 0.693689

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] (END) 11 0.693700

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 14 0.693714

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN) 245 0.693959

4 ETW000 [dev trc ,00000] &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "SAPDEV.XXXXT" is an undefined name

4 ETW000 20 0.693979

4 ETW000 [dev trc ,00000] &+ . SQLSTATE=42704

4 ETW000 15 0.693994

4 ETW000 [dev trc ,00000] &+

4 ETW000 15 0.694009

4 ETW000 [dev trc ,00000] &+ SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS' WITH UR

4 ETW000 16 0.694025

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

4 ETW000 27 0.694052

4 ETW000 [dev trc ,00000] &+

4 ETW000 16 0.694068

4 ETW000 [dev trc ,00000] &+

4 ETW000 15 0.694083

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 13885] (END) 10 0.694093

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT DBASE FROM XXXXT WHERE TABNAME = 'SVERS' failed, dbsl_rc = 103

4 ETW000 18 0.694111

4 ETW000 [dbntab ,01273] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#12 @ 12739]

4 ETW000 18 0.694129

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

db call info -

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0) 240 0.694369

Hi,

you need to take care of the database schema. The schema name is not changed with a redirected restore, so the DEV database has to use schema sapprd instead of sapdev.

As Masako already stated, please check and implement SAP note 713524

You will also need to regenerate the login details in the /sapmnt/DEV/global/dscdb6.conf file with the dscdb6up program.

Hi Dainel,

Thanks for your reply.

i have checked the table schema owner:

TABNAME TABSCHEMA

SVERS SAPPRD

Then i have changed the "dbs_db6_schema=sapprd" & the profile parameter "dbs/db6/schema=SAPPRD" is maintained in instance parameter.

But, i'm not able to connect to startsap.

it says DB manager is Active. Activate DB failed. R3trans connect failed. DB startup failed.

I'm trying to follow your instructions about the password config file.

/sapmnt/<SID>/global/dscdb6.conf

it contains the entries like as below:

devadm 168 232 231 101 60 118 156 66 27 40 51 241 253 19 137 35 1

sapdev 168 232 231 237 60 118 156 66 27 40 51 209 255 19 137 35 2

As instructed i have changed the schema & targeted to SAPPRD instead of sapdev.

Note: there is difference in password for db2<sid> & <sid>adm for DEV and PRD.

in PRD password is "abcdef"

in DEV password is "12345"

I have question regarding; dscdb6up program.

How can i generate entry for "sapprd" instead of "sapdev" in dscdb6.conf

Create password file dscdb6.conf

Help.sap as below:

This file can be recreated any time manually using the following command:

dscdb6up u2013create <connect_userpwd> <sapsid_adm_pwd>

my connect user will be sapprd (schema) or devadm (user) ?

request you to guide me in the correct syntax and procedure to make it connect to DB and start SAP.

kind regard's

Harika N

You will need to re-create the file with details for the users 'devadm' and 'sapprd', this also means you may need to create the user 'sapprd' on your development server and a password. Once done 'R3trans -x' should work correctly and it should be possible to start the DEV sap system, but please check the system copy guide before doing so, lots more important post processing tasks to complete before doing so.

example command, suggest you use the '-create' flag so that the os passwords are not changed

 dscdb6up -create <sapprd's password> <devadm's password>

dscdb6up usage;

devhost:devadm 1> dscdb6up
Usage: (1) dscdb6up <username> <password>
       (2) dscdb6up -create <connect_user password> <sidadm password>
       (3) dscdb6up -rewrite

CAUTION: option '-create ' does NOT change OS level passwords
         and will overwrite the existing password file !

if you still have trouble double check that the dscdb6up program has correct permissions/ownership;

devhost:devadm 3> ls -l /usr/sap/DEV/SYS/exe/run/dscdb6up
-rwsr-x---    1 root     dbcructl      51926 Nov 01 2010  /usr/sap/DEV/SYS/exe/run/dscdb6up

i'm not able to set environment variable of dbs_db6_schema=sap<sourcesid>

i.e.. sapprd since, the schema is same as PRD server after restoration.

not able to find or edit .dbenv_<host>.csh and .dbenv_<host>.sh

Where can i find and How to edit these variable ?

so that while connecting it should take user "sapprd" instead of "sapdev"

I have a problem in editing /usr/sap/<SID>/SYS/global/*dscdb6.conf*

when i use the command in <sid>adm user:--

dscdb6up -create <sapconnt user> <password>

i.e.. dscdb6up -create sapprd 123456

i'm getting message as "password file... successfully written"

The entries are as follows:--

/sapmnt/DEV/global dscdb6.conf

devadm 168 232 231 101 60 118 156 66 27 40 51 241 253 19 137 35 1

sapdev 168 232 231 237 60 118 156 66 27 40 51 209 255 19 137 35 2

the user sapdev is not changing to sapprd.

TRANS.log

4 ETW000 [dev trc ,00000] Supported features: 17 0.003336

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 15 0.003351

4 ETW000 [dev trc ,00000] ..done 96 0.003447

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '/db2/db2dev/sqllib/lib64/libdb2.so' successfully loaded

4 ETW000 10062 0.013509

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 18 0.013527

4 ETW000 [dev trc ,00000] Running with CLI runtime client libraries. 12225 0.025752

4 ETW000 [dev trc ,00000] Tue May 17 13:42:09 2011 619064 0.644816

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1791] CON = 0 (BEGIN) 18 0.644834

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME

4 ETW000 22 0.644856

4 ETW000 [dev trc ,00000] &+ AND/OR PASSWORD INVALID"). SQLSTATE=08001

4 ETW000 16 0.644872

4 ETW000 [dev trc ,00000] &+

4 ETW000 14 0.644886

4 ETW000 [dev trc ,00000] &+

4 ETW000 29 0.644915

4 ETW000 [dev trc ,00000] &+

4 ETW000 15 0.644930

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1791] (END) 10 0.644940

4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'DEV' as 'sapdev' failed 43 0.644983

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'DEV'"

I have tried CLP command to connect to DEV:

<host>:db2dev 54> db2 connect to DEV user sapprd using 123456

Database Connection Information

Database server = DB2/LINUXX8664 9.1.4

SQL authorization ID = SAPPRD

Local database alias = DEV

<host>:db2dev 55

the user "sapprd" created and avaliable.

kind regard's

Harika

I have edited the .csh & .sh profile and maintained correct schema.

followed by dscdb6up

i'm not able to connect to DB.

dscdb6up syntax is wrong, simply provide the two passwords, no need to give usernames, these are determined from your environment settings.

dscdb6up -create <sapprd password> <sidadm password>

Might also want to move the current dscdb6.conf file so that a new one is created, might help highlight any other problems

mv /sapmnt/DEV/global/dscdb6.conf /sapmnt/DEV/global/dscdb6.conf.old

Edited by: Daniel Parker on May 18, 2011 10:04 AM

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

DB2 v9.1fp4 on suse linux 10sp2 - redirect restor PRD to DEV

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Iterating through JSONModel with multiple nested a...

Re: Connecting SAP CAP with SAP Cloud ALM

How to use CopyProvider on Table created by TypeSc...

How to execute/fire onPost when user press enter o...

Re: Connecting SAP CAP with SAP Cloud ALM