Export Preparation Error (Oracle 10g to DB2 10.1)

[mohsin_m3]

Hi,

we are doing database migration from Oracle 10g to DB2 10.1 .

while Export preparation we are getting below error .

ERROR: Select for get_tsp_name failed, rc = 24, tabart was ZXXXX

error message returned by DbSl:

ORA-01403: no data found

ERROR: couldn't generate DBSIZE.xml

ZXXXX are maintained on DARTT , ,DDART , IAORA , TAORA and DD09L

Please help me to resolve the issue .

Thanks and Regards

Mohsin

[mohsin_m3]

Hi,

I have add entries in TADB6 table and problem get resolved

[Former Member]

Dear Mr. Mohsin,

Have you run report "SMIGR_CREATE_DDL" ?

In case not then run it & let us know the status of the report.

How to run the Report :-

T-code SE38>Program>SMIGR_CREATE_DDL>Execute button>Target Database>DB>Execute

Kind rgds,

Ashwin Mane

[Former Member]

Hi,

Please advice what is your target OS.

If Linux than you need to maintain entry for DB6 Database not DB2.hence need to update TAORA & IAORA tables with this dataclass & tablespace.

Below link for your reference.

http://adarshh.com/2011/04/06/difference-between-db2-and-db6/

Note 778784 can be helpful.

Regards,

Sahil

[mohsin_m3]

HI Sahil,

OS :: AIX 6.1 , only Migration from Oracle 10g to DB2 10.1

How to maintain entry for DB6 Database and how to update TAORA & IAORA tables with this dataclass & tablespace.

Thanks and Regards

Mohsin

[Former Member]

Hi,

Are you using the latest R3* files. Please update the dbora files too.

Kindly share the kernel level you are using as well as R3load versions ???

Thanks and Regards,

Vimal

[Former Member]

Hi,

   Please check the below note also.

Note 142579 - INVALID dbms_aq_import_internal / export problems

Thanks and Regards,

Vimal

[mohsin_m3]

Hi,

we have updated the below R3* files to latest , also Oracle statistics has been updated .

/R3ldctl_316-720_UC_AIX_ORACLE.SAR  

/R3szchk_324-720_UC_AIX_ORACLE.SAR  

/lib_dbsl_327-720_UC_AIX_ORACLE.sar

/R3load_221-720_UC_AIX_ORACLE.SAR   

/R3ta_324-720_UC_AIX.SAR .

Current kernel version is 720 , ECC EHP5 .

Thanks and Regards

Mohsin

[Former Member]

Hi,

      Is R3trans -d working ??

Thanks and Regards,

Vimal

[former_member188883]

Hi Mohsin,

Please check whether the table YBMC is consistent as the note it tells

#211492 - Inconsistency between ABAP Dictionary <-> database

When you created your new dataclass you follow note

#46272 - Implement new data class in technical settings

Regards,

Deepak Kori