Skip to Content
0
Former Member
Dec 19, 2007 at 08:41 AM

R3Load problem on DB2/Linux

44 Views

Hello all,

We are performing a migration from a DB2v7 DB on AIX to a DB2v9 DB on Linux. The export on the source system was successful, but now we are trying to import the data to the target system, we get a strange problem.

Everything goes fine up until the installer asks for the pagesize of the tablespaces. Possible answers are 4, 8, 16 or 32, but no matter what answer is given, the question keeps getting repeated. The log says 'For further information see HTML documentation: step: DB6CHANGETBSDATA_IND_DB6 and key: Z_SAPDATAPATH' but no help for this step is in the documentation.

The beginning of step [DB6CHANGETBSDATA_IND_DB6] in the CEDBMIG.R3S script looks like this:

[DB6CHANGETBSDATA_IND_DB6]

=4

ACTION=

CHANGELIST=SYSCATSPACE PSAPTEMP PSAPDDICD PSAPPOOLI PSAPUSER1I PSAPCLUD PSAPSOURCED PSAPBTABI PSAPLOADI PSAPCLUI PSAPDOCUI P

SAPSTABD PSAPPROTI PSAPBTABD PSAPPROTD PSAPLOADD PSAPSOURCEI PSAPUSER1D PSAPSTABI PSAPDOCUD PSAPPOOLD PSAPDDICI PSAPES46BD PS

APES46BI PSAPEL46BD PSAPEL46BI (RI_GIKY_NA_DB6_PAGESIZE)

CLASS=CDB6ChangeTablespaceData

CONFIRMATION=

CONFIRMED=CHANGELIST

MSGID=RI_GIST_DB6CHANGETBSDATA_IND_IND

PAGESIZES=4

PSAPBTABD=914;34;16;4;@Z_SAPDATAPATH=S4[etc]

I've removed the '=4' on the first line, and then the installer continues on, but then it gets stuck on 'step: GETDBSIZEKEYS_IND_IND and key: ;'

Can anyone tell me how to get the r3load working? Thanks!