Kontakt

Ansicht
Dokumentation

05696 - Reorganization table ACCTHD

05696 - Reorganization table ACCTHD

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

Reorganization table ACCTHD


Hi Jim,

The problem was solved. I Activeted and adjusted the primary
index in transaction Se14. Thanks for our help.
Thanks for all who help me

Regards,

Mauro Valle






"Jim Doll"

<JDOLLZperrig To: <mauroZm...>

o.com> cc:

Subject: Re:
Reorganization
12/04/02 table ACCTHD

16:18








Any chance that you made a copy of the table earlier? What is the table's
status in SE14?

We also have had some problems where a partial conversion left an index
attached to the "old" table. For example:

SE14 conversion (or a transport, perhaps):

ACCTHD is renamed QCMACCTHD or some similar prefix
new ACCTHD is created
data is transferred from QCMACCTHD to new ACCTHD
QCMACCTHD is deleted

If there is a problem in the process, the index ("constraint"?) can be
still in use by the old table.

I've had problems within SAP--I don't remember ever having problems at
OS/400 level.

jdoll

>>> <mauroZm...> 04/12/02 03:11PM >>>

HI ,

I verified that no have duplicate keys and objects in lock.

What do you think if I copy the index to another name, then I delete
the index and after that I make a reorganization in this table? I never do
it. Does anything do it?

Thanks ,

Mauro Valle




"Jim Doll"

<JDOLLZperrig To: <mauroZm...>

o.com> cc:

Subject: Re:
Reorganization
12/04/02 table ACCTHD

15:17






Any other locks--WRKOBJLCK?

>>> mauroZm... 04/12/02 02:10PM >>>

Hi Jim,

I verified now the EDTRBDAT and there aren t paths being rebuilt. But
thanks for your help.



Thanks,

Mauro Valle



"Jim Doll"

<jdollZperrig To:
<DoNotReply@consolut.eu>
o.com> cc:

Subject: Re:
Reorganization
12/04/02 table ACCTHD

14:20

Please

respond to

SAP on System i






If I read it right, 7008 means that it isn't available. Is it possible
that the access paths are still being rebuilt? EDTRBDAP should show that.

We've had similar problems during a refresh: the restore is complete, so
we try to run the AS4FIXFILE and it fails because the access path for a
file is still being rebuilt.

Hope it helps...

Jim Doll, Perrigo

>>> mauroZm... 04/12/02 12:34PM >>>
Hi,

I executed the reorganization of the table ACCTHD and it s occurring
a dump with the message: SQL error -7008
occurred when accessing table ACCTHD. The code reason in the joblog is
9. I read the note 116192. This note say that I have the proccess the
reorganizatioin again and verify the joblog . I made a reorganization and
there was an error. I made reorganization again and no errors occurs. So I
started the sap, but the error is continuing.
does any people know how can I solve this problem?


Thanks,

Mauro Valle
Musashi do Brasil Ltda.



Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu

Your use of consolut is subject to http://www.consolut.net





Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu

Your use of consolut is subject to http://www.consolut.net








Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu

Your use of consolut is subject to http://www.consolut.net












 Durban Tours - Südafrika Safari

CPI1466 during Backup   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 5614 Date: 20240425 Time: 021545     sap01-206 ( 4 ms )