Consistency check for cluster table.

[Former Member]

Hi all,

I are doing unicode conversion on solution manger 7.0 sp16. on OS windows. So i applied Note 1077403 - Cluster table check using SDBI_CLUSTER_CHECK.

and ran SDBI_CLUSTER_CHECK and create control file for my cluster table which contains incorrect cluster records.

But when I am using R3check on command line applie Note 89384

I get this massage.

C:\>R3check CDCLS_200 > CDCLS_202.txt

'R3check' is not recognized as an internal or external command, operable program or batch file.

Can some one guide us the steps for cluster table check with R3check.

Regards

[Former Member]

Hi ,

Her i a list over my tables.

Is posible to delete this tables?

07.01.2011 Check Cluster Tables: Perform New Check or Restart Cancelled Check Run 1

-

---

Finished table CDCLS

Finished table CLUSTERVER

Finished table CLUTAB

Finished table CRMDC_FIMA

Finished table CVEP1

Finished table CVEP2

Finished table CVER1

Finished table CVER2

Finished table CVER3

Finished table CVER4

Finished table CVER5

Finished table DOCCLV

Finished table DOKCL

Finished table DOKCLU

Finished table DSYCLV

Finished table DSYO1

Finished table DSYO2

Finished table DSYO3

Finished table EDI30C

Finished table EDI40

Finished table EDIDOC

Finished table J_CLU

Finished table PCDCLS

Finished table PRCD_CLUST

Finished table SFHOA

Finished table SFHYT

Finished table TERCL

Finished table TERCL2

Finished table TERCL3

Finished table TESCL

Finished table UMG_TEST_C

Finished table UMG_TEST_F

Finished table VBLOG

Finished table VERCLUSTER

Finished table VER_CLUSTR

Finished table VTEST10

Edited by: Ejersbo DavidR on Jan 8, 2011 11:31 AM

[Former Member]

Hi,

I did download R3check.exe form SMP and R3check work on command line. Whwn I run R3check CLU4_200 > outCLU4_200.txt for control file that I create by report SDBI_CLUSTER_CHECK

Her is my outclu4.

This is R3check version 6.14 (release 700 - 17.02.10 - 13:07:00).

SAP myCluster Technology (dbcheckclu - Mar 15 2010 - 20:00:54)

Current time is 07.01.2011 16:05:56,79h GMT.

R3check finished (0000).

And there create an trans.log

Her is my trans.log file.

4 ETW000 R3check version 6.14 (release 700 - 17.02.10 - 13:07:00).

4 ETW000 ===============================================

4 ETW000 date&time : 07.01.2011 - 17:05:54*

4 ETW000 control file: CLU4_200

4 ETW000 > export

4 ETW000 > file='NUL'

4 ETW000 > dumping=yes

4 ETW000 > client=200

*4 ETW000 > select * from TACOPC*

4 ETW000 R3trans was called as follows: R3check CLU4_200

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'SLM' --- SYSTEM = 'SLM'.

4 ETW690 COMMIT "0" "0"

*4 ETW000 trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 07.01.2011 - 17:05:56

4 ETW000 function : EXPORT

4 ETW000 data file : NUL

4 ETW000 buffersync : YES

4 ETW000 dumping : YES

4 ETW000 client : 200

4 ETW000 Language : ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz(),./:;& (ISO-ARHECSDEENFRELHUITJADAPLZFNLNOPTSKRUESTRFISVBGLTLVZ1SRZHTHKOROSLHRMSUKETAFISCASH????????ID??????????????????????????????????Z2Z3Z4Z5Z6Z7Z8Z9)

4 ETW000 Compression : L

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 GetDBMigrateCodePagesLangs setting any locale.

4 ETW000 GetDBMigrateCodePagesLangs uses TCP0D, TCPDB, TCP0C.

4 ETW000 0 entries from TACOPC exported (*).

4 ETW000 392 bytes written.

4 ETW000 Transport overhead 100.0 %.

4 ETW000 Data compressed to 78.4 %.

4 ETW000 Duration: 0 sec (392 bytes/sec).

4 ETW690 COMMIT "0" "0"

4 ETW000

4 ETW000 Summary:

4 ETW000

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 130438 0.130438

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 23 0.130461

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=01E3C470,usrhp=01E65C70) 549 0.131010

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=01E3C470,srvhp=01E41A74) 629 0.131639

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 1170 0.132809

4 ETW000 [dev trc ,00000] Disconnected from connection 0 86 0.132895

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=2, com_tx=1) 18 0.132913

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 15 0.132928

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 07.01.2011 - 17:05:56*

I did usr Note 89384

I can not find any <phys. cluster table>: <key1><key2><key3>... (<error number>) after run R3check.

Any I dea how can I delete this table cluster with initial records?

Regards