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

Post a Comment

Popular posts from this blog

Quick Dirty Script for Checking Oracle Data Gurad Gap and Emailing it

-
 Situation: primary DB: prd_CCC standby DB: prd_WWW file 1: gap-check.bat @echo off cls echo. echo. echo This script checks for Archive Logs at prd_ccc and Applied Logs at prd_www echo. echo Querying prd_ccc (Primary) echo select max(sequence#) "Primary" from v$archived_log where archived='YES';|sqlplus -s / as sysdba echo Querying prd_www (Standby) echo select max(sequence#) "Standby" from v$archived_log where applied='YES';|sqlplus -s / as sysdba echo. DGMGRL / "show configuration" date /t && time /t && hostname && whoami file 2: emailer.ps1 $Username      = "username" $EmailPassword = "password" $today = Get-Date $Username = $Username $EmailTo = "adam@jasabyte.com"  $EmailFrom = "server@jasabyte.com" $Body = Get-Content .\status.log -Raw $Subject = "PRIMARY/STANDBY DB GAP - $today" $SMTPServer = "mail.smtp2go.com"  $SMTPMessage = New-Object System.Net.Mai...
Read more

SAP SWPM Software Provision Manager SL Toolset 1.0 SP22 Startup Options

-
This is just a rough note on the options and properties we can set upon running apinst when installing a SAP system. Version: [root@host SWPM]# ./sapinst -v [==============================] - extracting...  done! INFO       2018-04-19 11:54:56.315 (mainThread) [sixxcreate.cpp:346] ******************************************************************************** Initial log directory: /root/.sapinst/falconheavy.vantage-intl.com/12345 ******************************************************************************** SAPinst build information: -------------------------- Version:         749.0.47 Build:           1832063 Compile time:    Mar 27 2018 - 13:22:27 Make type:       optU Codeline:        749_REL Platform:        linuxx86_64 Kernel build:    749, patch 426, changelist 1830485 SAP JRE build:   SAP...
Read more

SAP SystemCopy - Activation of TCI Notes, DigiSIgn Gone Wrong

-
Backgroud: Source was ECC6 EHP6 / Oracle 11.2 / Windows / Non-Unicode, and TCI and DigiSig and dS/4 RC Note already implemented Target: ECC6 EHP6 / Sybase ASE 16 / Windows / Unicode Issue: Post system copy, ABAP dumps all over the place, SE11, SE38, SNOTE... Related notes: 2750714 - SYNTAX_ERROR: Type "CWBCI_T_ATTR" is unknown 2861287 - Fixing syntax errors caused by missing types And below are the objects needed ABAP Debugger and activate. cutoff is at CWBNTREASON and after that can use SE11 Actuvate using SE84: Domains CWBCIATTR_ID STricture IMP_TEST_CORR_INSTRUCTION Table CWBCINSTATTR - x Table Type CWBCI_T_ATTR Structure CWBNTKEYTSTAMP Data Element CWBNTREASON -- beyond this, can remove all breakpoints and use SE11 Table CWB_FILE_NAME Table CWB_SIZE_IN_BYTE Table CWB_NOTE_URL Table CWB_DWNLD_PROC Table CWB_PROC Table CWB_T_NOTE Data Type SCWB_S_NO_PATCHLEVEL Data Type SCWB_T_NO_PATCHLEVEL Table TT_SCWB_PATCH Data Type CWBCI_S_LIFECYCLE_OBJECT Data Type CWBCI_T_LIFECYCLE_O...
Read more