IDS Forum

Re: RE: Archecker single table restore compressed

Posted By: ALEKSANDAR IVANOVSKI
Date: Friday, 22 September 2017, at 12:49 p.m.

In Response To: RE: Archecker single table restore compressed onta (Mike Walker)

Hi,

The archecker itself and the ontape is probably working but I have additional problems getting the log info:

ERROR: Unable to convert page(27_603909) for partnum 2099394
ERROR: "PUT CURSOR" failed
ERROR: -1226: Decimal or money value exceeds maximum precision.

So i dig a little bit on the net trying to implement external table http://www-01.ibm.com/support/docview.wss?uid=swg21655476 and using ("/tmp/tlr.unl", delimited ); but no luck. I got a file in the tmp directory with few thousand more lines than the actual row count should be, on the other hand the rows were unusable so the problem persists.
I also tried to change insert into new_table
select * from real_table (insert into A,B,C select A,B,C from ...)
with the actual rows from both tables again no luck

AFAIS the environments between the backup server and restore server are all the same, maybe something in the onconfigs that I am not aware of regarding decimal and money precision and scale???

Do you have any idea what this can be caused from?

Is there and way I can implement SQLCA.SQLCODE within the scope of conf file of the archecker so that I can get the error???

Other than this here is the conf file:

database db;

create table xxx
(

sektor char(9),

godina char(4),

partija char(8),

stavka smallint,

glavnica decimal(16,2),

kamata decimal(16,2),

dospeanost date,

f_prefrlena char(1),

eks_kamata decimal(16,2),

int_kamata decimal(16,2),

stapka decimal(8,5),

stapka_eks decimal(20,8)
) in datadbs ;
create table xxx_restore
(

sektor char(9),

godina char(4),

partija char(8),

stavka smallint,

glavnica decimal(16,2),

kamata decimal(16,2),

dospeanost date,

f_prefrlena char(1),

eks_kamata decimal(16,2),

int_kamata decimal(16,2),

stapka decimal(8,5),

stapka_eks decimal(20,8)
) in datadbs ;

insert into xxx_restore
select * from xxx ;

restore to current with no log;

So I guess the problem is somewhere within the decimal fields. The original table has not been altered for years ....

Am I missing something, maybe the extend sizes in the conf file ... lock mode or something??

Any help?
Thank you
Aleksandar

Messages In This Thread

• Archecker single table restore compressed ontape
  ALEKSANDAR IVANOVSKI -- Thursday, 21 September 2017, at 2:34 p.m.
  • RE: Archecker single table restore compressed onta
    Mike Walker -- Thursday, 21 September 2017, at 2:45 p.m.
    • Re: RE: Archecker single table restore compressed
      ALEKSANDAR IVANOVSKI -- Thursday, 21 September 2017, at 2:56 p.m.
  • Re: Archecker single table restore compressed onta
    Andreas Legner1 -- Thursday, 21 September 2017, at 5:58 p.m.
    • Re: Archecker single table restore compressed onta
      ALEKSANDAR IVANOVSKI -- Friday, 22 September 2017, at 1:05 a.m.
      • RE: Archecker single table restore compressed onta
        Mike Walker -- Friday, 22 September 2017, at 8:19 a.m.
        • Re: RE: Archecker single table restore compressed
          ALEKSANDAR IVANOVSKI -- Friday, 22 September 2017, at 12:49 p.m.
          • Re: RE: Archecker single table restore compressed
            ALEKSANDAR IVANOVSKI -- Tuesday, 26 September 2017, at 6:41 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.