on 11-19-2014 1:14 PM
Hello,
We are building New Sandbox Landscape in our Customer’s current Enviornment using SAP Export/Import (Homogenous System Copy)
Enviornment : SLES 11 & DB2 10
Till Now we have taken export of 2 SAP systems (ERP 6 EHP 6 & PI 7.3 ) successfully & during import all packages get successfully imported
Except table DYNPSOURCE table below error
We can see below error -
DB6) INFO: Virtual Table DYNPSOURCE has been successfully converted (
ignore SQL0150N )
(DB6) Using LOAD API for table DYNPSOURCE
(DB6) ERROR: Load reported 1 deleted rows.
(DB6) ERROR: SQLRowCount returned 205792 loaded rows out of 205793
provided rows.
(DB6) Check db2diag.log entries corresponding to LOAD on table
DYNPSOURCE.
(IMP) ERROR: EndFastload: rc = 2
Thanks
Deepak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Please share error information from db2diag.log file
(DB6) Check db2diag.log entries corresponding to LOAD on table
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for response !!
There is no Error or Severe message in dB2diag log file
crhpsapappp51:db2ecr 53> db2diag -gi 'DYNPROSOURCE'
db2diag: Field name "DYNPROSOURCE" does not exist.
crhpsapappp51:db2ecr 54> db2diag -t 2014-11-19 | grep -i dynp
Starting LOAD operation (Q) (6) (I) [SAPECR .DYNPSOURCE].
Starting LOAD operation (Q) (6) (I) [SAPECR .DYNPLOAD].
Starting LOAD phase at 11/19/2014 11:10:46.603425. Table SAPECR .DYNPSOURCE
Starting LOAD phase at 11/19/2014 11:10:46.833996. Table SAPECR .DYNPLOAD
Starting LOAD operation (Q) (6) (I) [SAPECR .DYNPTXTLD].
Starting LOAD phase at 11/19/2014 11:13:23.690438. Table SAPECR .DYNPTXTLD
2014-11-18-15.24.12.765542+000 I303179007E921 LEVEL: Error
PID : 24610 TID : 139768328582944 PROC : db2gcf
INSTANCE: db2ecr NODE : 000
HOSTNAME: crhpsapappp51
FUNCTION: DB2 Common, Generic Control Facility, gcf_start, probe:180
MESSAGE : ECF=0x900002BF=-1879047489=ECF_GCF_DB2START_SERVICE_FAILED
DB2 start service failed
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007F1E56B4FC39 pdOSSeLoggingCallback + 0x219
[1] 0x00007F1E5923B0AB /home_sap/db2ecr/sqllib/lib64/libdb2osse.so.1 + 0x2070AB
[2] 0x00007F1E5923AEF7 ossLog + 0xC7
[3] 0x00007F1E50D78A5E gcf_start + 0x265E
[4] 0x00007F1E58E23B37 _ZN9GcfCaller5startEP12GCF_PartInfomP11GCF_RetInfo + 0x187
[5] 0x00000000004043C5 main + 0x16C5
[6] 0x00007F1E55211C16 __libc_start_main + 0xE6
[7] 0x0000000000402C69 __gxx_personality_v0 + 0xD9
2014-11-18-15.24.13.816906+000 I303183166E936 LEVEL: Error
PID : 24888 TID : 140661812995872 PROC : db2gcf
INSTANCE: db2ecr NODE : 000
HOSTNAME: crhpsapappp51
FUNCTION: DB2 Common, Generic Control Facility, gcf_getstate, probe:170
MESSAGE : ECF=0x900002C3=-1879047485=ECF_GCF_DB2STATUS_SERVICE_FAILED
DB2 get status service failed
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007FEE5E872C39 pdOSSeLoggingCallback + 0x219
[1] 0x00007FEE60F5E0AB /home_sap/db2ecr/sqllib/lib64/libdb2osse.so.1 + 0x2070AB
[2] 0x00007FEE60F5DEF7 ossLog + 0xC7
[3] 0x00007FEE58A9E2BD gcf_getstate + 0x249D
[4] 0x00007FEE60B47457 _ZN9GcfCaller8getStateEP12GCF_PartInfomP11GCF_RetInfo + 0x187
[5] 0x0000000000403D23 main + 0x1023
[6] 0x00007FEE5CF34C16 __libc_start_main + 0xE6
[7] 0x0000000000402C69 __gxx_personality_v0 + 0xD9
2014-11-18-16.52.42.202004+000 I303202625E350 LEVEL: Error
PID : 8560 TID : 140602008942368 PROC : db2fmp (
INSTANCE: db2ecr NODE : 000
HOSTNAME: crhpsapappp51
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.