DB2 Issues - DB21061E and SQL1668N - System Copy Export DB6

i was doing SysCopy Export Sys for NW 7.4 (Solman 7.2) ABAP -  DB2 LUW 10.5

Error During db export:

(RTF) ########## WARNING ###########
    Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(EXP) ERROR: DbSlPrepare/BegRead failed
  rc = 99, table "/BI0/D0CCMVRKFP"
  (SQL error -1668)
  error message returned by DbSl:
SQL1668N  The operation failed because the operation is not supported with this environment. Reason code: "5
(DB) INFO: disconnected from DB

I updated kernel to latest,a dn updated SWPM to latest. No success

found this note: 2357018 - BW Content Activation fails in SOLMAN_SETUP for DB2

it ask to execute
db2 update dbm cfg using intra_parallel yes

but when i try it gives me this:

SOLMAN e:\>db2
DB21061E  Command line environment not initialized.

solution: http://www-01.ibm.com/support/docview.wss?uid=swg21237966

SOLMAN C:\Windows\system32>echo %DB2CLP%
DB20FADE

SOLMAN C:\Windows\system32>
SOLMAN C:\Windows\system32>
SOLMAN C:\Windows\system32>db2 update dbm cfg using intra_parallel yes
DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.

next, open services.msc, and restart the Database Instacne Servie.
re-launch SWPM, continue with previous run,
and wallah! it works now. :)


//alak

Comments

Popular posts from this blog

Check SecStore KeyPhrase of Java Stack

Windows 2003 W2k3 Getting Current MTU Size

Python: thread.error: can't start new thread