cancel
Showing results for 
Search instead for 
Did you mean: 

System COPY Import Error : DYNPSOURCE Table Import

0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Please check the below note.

1690281 - DB6: R3load reports deleted rows using LOAD

regards,

pavan

former_member188883
Active Contributor
0 Kudos

Hi ,

Please share error information from db2diag.log file

(DB6) Check db2diag.log entries corresponding to LOAD on table

Regards,

Deepak Kori

0 Kudos

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


former_member188883
Active Contributor
0 Kudos

Hi Deepak,

Did you check whether you have enough space on the server and DB services are up and running.

Regards,

Deepak Kori

0 Kudos

Hello Deepak ,

There is enough Disk space and all DB services are up and running

Thanks

Deepak