CATALOG ERROR

[Former Member]

hi

in the kernel dialog error file, appear this error

2008-10-17 17:33:27 31 ERR 51080 SYSERROR -9205 AK Catalog information not found:0

2008-10-17 17:33:27 31 ERR 51105 AK CACHE 000000000000087C006000010100020000000000

how can i fixed this inconvenient? or how can avoid that

[Former Member]

Hi Alexander,

it seems that a comment for a column is missing. The affected table has the table identification

0x'000000000000087C'.

Please use the following query to find out the name of the table :

SELECT TABLENAME FROM TABLES WHERE TABLEID = x'000000000000087C'

After that try to assign new comments to the table columns :

COMMENT ON COLUMN <table name>.<column name> IS '<string literal>'

Hope that helps,

Thomas

[Former Member]

hi

i check the comments on the table and is full, all the comments are there. but i have the same problem whit other table "ERR 51080 SYSERROR -9205 AK Catalog information not found:".

and other inconvenient is with cache catalog access, is in 89.46 percent. and i don't know what can do.

[Former Member]

Hi Alexander,

1. You can try to repair the affected tables via

CHECK TABLE <table name> CATALOG

This should at least remove all inconsistencies concerning comments from the table.

2. Don't worry about the cache hit ratio of 89%. This is a normal value

Regards,

Thomas

[Melanie]

Hi Alexander!

A bit more information would be good:

Which database version are you using?

How are your parameter settings? Do you use SharedSQL?

Are you an SAP customer?

Regards,

Melanie

[Former Member]

which version of SAPDB you are on.

check Note 620239 - System error -9205 AK Catalog information not found

cheers,

-Sunil

[Former Member]

hi

sorry, i forget send the information.

i have a maxdb 7.6.05.09 distribution, installed on solaris x86 version 10 and whit configurated whit this parameters

192.168.119.18:PERSEO> param_directgetall

OK

KERNELVERSION KERNEL 7.6.05 BUILD 009-123-191-997

INSTANCE_TYPE OLTP

MCOD NO

SERVERDBFOR_SAP YES

_UNICODE YES

DEFAULT_CODE ASCII

DATE_TIME_FORMAT INTERNAL

CONTROLUSERID DBM

CONTROLPASSWORD

MAXLOGVOLUMES 4

MAXDATAVOLUMES 64

LOG_VOLUME_NAME_002 /data/LOG/PERSEO/DISKL0002

LOG_VOLUME_NAME_001 /data/LOG/PERSEO/DISKL0001

LOG_VOLUME_TYPE_002 F

LOG_VOLUME_TYPE_001 F

LOG_VOLUME_SIZE_002 51200

LOG_VOLUME_SIZE_001 51200

DATA_VOLUME_NAME_0002 /data/PERSEO/DISKD0002

DATA_VOLUME_NAME_0001 /data/PERSEO/DISKD0001

DATA_VOLUME_TYPE_0002 F

DATA_VOLUME_TYPE_0001 F

DATA_VOLUME_SIZE_0002 524288

DATA_VOLUME_SIZE_0001 524288

DATA_VOLUME_MODE_0002 NORMAL

DATA_VOLUME_MODE_0001 NORMAL

DATA_VOLUME_GROUPS 1

LOG_BACKUP_TO_PIPE NO

MAXBACKUPDEVS 2

LOG_MIRRORED NO

MAXVOLUMES 69

LOG_IO_BLOCK_COUNT 8

DATA_IO_BLOCK_COUNT 64

BACKUP_BLOCK_CNT 64

DELAYLOGWRITER 0

LOG_IO_QUEUE 50

RESTARTTIME 600

MAXCPU 4

LOCAL_REDO_LOG_BUFFER_SIZE 0

MAX_LOG_QUEUE_COUNT 0

USED_MAX_LOG_QUEUE_COUNT 4

LOG_QUEUE_COUNT 0

MAXUSERTASKS 100

TRANSRGNS 8

TABRGNS 8

OMSREGIONS 0

OMSRGNS 7

LOCKMANAGERENABLED NO

LMLOCK_REGIONS 0

LMREQUEST_REGIONS 0

LMTRANS_REGIONS 0

OMS_HEAP_LIMIT 0

OMS_HEAP_COUNT 4

OMS_HEAP_BLOCKSIZE 10000

OMS_HEAP_THRESHOLD 100

OMS_VERS_THRESHOLD 2097152

HEAP_CHECK_LEVEL 0

ROWRGNS 8

RESERVEDSERVERTASKS 69

MINSERVERTASKS 134

MAXSERVERTASKS 134

MAXGARBAGECOLL 1

_MAXTRANS 804

MAXLOCKS 8040

LOCKSUPPLY_BLOCK 100

DEADLOCK_DETECTION 4

DEADLOCK_DUMP_FILENAME

SESSION_TIMEOUT 900

OMS_STREAM_TIMEOUT 30

REQUEST_TIMEOUT 5000

IOPROCSPER_DEV 2

IOPROCSFOR_PRIO 0

IOPROCSFOR_READER 0

USEIOPROCS_ONLY NO

IOPROCSSWITCH 2

LRU_FOR_SCAN NO

PAGESIZE 8192

PACKETSIZE 131072

MINREPLYSIZE 4096

MBLOCKDATA_SIZE 32768

MBLOCKQUAL_SIZE 32768

MBLOCKSTACK_SIZE 32768

MBLOCKSTRAT_SIZE 16384

WORKSTACKSIZE 8192

WORKDATASIZE 8192

CATCACHE_MINSIZE 262144

CAT_CACHE_SUPPLY 196992

INIT_ALLOCATORSIZE 262144

ALLOW_MULTIPLE_SERVERTASK_UKTS NO

TASKCLUSTER01 tw;al;ut;2000sv,100bup;10ev,10gc;

TASKCLUSTER02 ti,100dw;25us;

TASKCLUSTER03 equalize

DYNTASK_STACK NO

MPRGN_QUEUE YES

MPRGN_DIRTY_READ DEFAULT

MPRGN_BUSY_WAIT DEFAULT

MPDISP_LOOPS 2

MPDISP_PRIO DEFAULT

MP_RGN_LOOP -1

MPRGN_PRIO DEFAULT

MAXRGN_REQUEST -1

PRIOBASE_U2U 100

PRIOBASE_IOC 80

PRIOBASE_RAV 80

PRIOBASE_REX 40

PRIOBASE_COM 10

PRIOFACTOR 80

DELAYCOMMIT NO

MAXTASKSTACK 1024

MAX_SERVERTASK_STACK 500

MAX_SPECIALTASK_STACK 500

DWIO_AREA_SIZE 50

DWIO_AREA_FLUSH 50

FBM_VOLUME_COMPRESSION 50

FBM_VOLUME_BALANCE 10

FBMLOW_IO_RATE 10

CACHE_SIZE 393984

DWLRU_TAIL_FLUSH 25

XP_DATA_CACHE_RGNS 0

DATACACHE_RGNS 64

XP_CONVERTER_REGIONS 0

CONVERTER_REGIONS 8

XP_MAXPAGER 0

MAXPAGER 64

SEQUENCE_CACHE 1

IDXFILELIST_SIZE 2048

VOLUMENO_BIT_COUNT 8

OPTIM_MAX_MERGE 500

OPTIM_INV_ONLY YES

OPTIM_CACHE NO

OPTIM_JOIN_FETCH 0

JOIN_SEARCH_LEVEL 0

JOIN_MAXTAB_LEVEL4 16

JOIN_MAXTAB_LEVEL9 5

READAHEADBLOBS 32

READAHEAD_TABLE_THRESHOLD 0

CLUSTER_WRITE_THRESHOLD 80

CLUSTERED_LOBS NO

CLUSTERCOMPRESSIONTHRESHOLD 1000

CLUSTERCOMPRESSIONFILLTHRESHOLD 10

RUNDIRECTORY /var/opt/sdb/data/wrk/PERSEO

OPMSG1 /dev/console

OPMSG2 /dev/null

_KERNELDIAGFILE knldiag

KERNELDIAGSIZE 800

_EVENTFILE knldiag.evt

_EVENTSIZE 0

_MAXEVENTTASKS 2

_MAXEVENTS 100

_KERNELTRACEFILE knltrace

TRACE_PAGES_TI 2

TRACE_PAGES_GC 20

TRACE_PAGES_LW 5

TRACE_PAGES_PG 3

TRACE_PAGES_US 10

TRACE_PAGES_UT 5

TRACE_PAGES_SV 5

TRACE_PAGES_EV 2

TRACE_PAGES_BUP 0

KERNELTRACESIZE 1899

EXTERNAL_DUMP_REQUEST NO

AKDUMP_ALLOWED YES

_KERNELDUMPFILE knldump

_RTEDUMPFILE rtedump

UTILITYPROTFILE dbm.utl

UTILITY_PROTSIZE 100

BACKUPHISTFILE dbm.knl

BACKUPMED_DEF dbm.mdf

MAXMESSAGE_FILES 0

_SHMKERNEL 16747

__PARAM_CHANGED___ 0

__PARAM_VERIFIED__ 2008-10-13 02:35:17

DIAG_HISTORY_NUM 2

DIAG_HISTORY_PATH /var/opt/sdb/data/wrk/PERSEO/DIAGHISTORY

DIAGSEM 1

SHOW_MAX_STACK_USE NO

SHOW_MAX_KB_STACK_USE NO

LOG_SEGMENT_SIZE 17066

_COMMENT

SUPPRESS_CORE YES

FORMATTING_MODE PARALLEL

FORMAT_DATAVOLUME YES

OFFICIAL_NODE

LOAD_BALANCING_CHK 0

LOAD_BALANCING_DIF 10

LOAD_BALANCING_EQ 5

HS_STORAGE_DLL libhsscopy

HS_SYNC_INTERVAL 50

USE_OPEN_DIRECT NO

USE_OPEN_DIRECT_FOR_BACKUP NO

SYMBOL_DEMANGLING NO

EXPAND_COM_TRACE NO

JOIN_TABLEBUFFER 128

SET_VOLUME_LOCK YES

SHAREDSQL YES

SHAREDSQL_CLEANUPTHRESHOLD 25

SHAREDSQL_COMMANDCACHESIZE 262144

MEMORY_ALLOCATION_LIMIT 0

USE_SYSTEM_PAGE_CACHE YES

USE_COROUTINES YES

FORBID_LOAD_BALANCING NO

MIN_RETENTION_TIME 60

MAX_RETENTION_TIME 480

MAX_SINGLE_HASHTABLE_SIZE 512

MAX_HASHTABLE_MEMORY 5120

ENABLE_CHECK_INSTANCE YES

RTE_TEST_REGIONS 0

HASHED_RESULTSET YES

HASHED_RESULTSET_CACHESIZE 262144

CHECK_HASHED_RESULTSET 0

AUTO_RECREATE_BAD_INDEXES YES

AUTHENTICATION_ALLOW

AUTHENTICATION_DENY

TRACE_AK NO

TRACE_DEFAULT NO

TRACE_DELETE NO

TRACE_INDEX NO

TRACE_INSERT NO

TRACE_LOCK NO

TRACE_LONG NO

TRACE_OBJECT NO

TRACE_OBJECT_ADD NO

TRACE_OBJECT_ALTER NO

TRACE_OBJECT_FREE NO

TRACE_OBJECT_GET NO

TRACE_OPTIMIZE NO

TRACE_ORDER NO

TRACE_ORDER_STANDARD NO

TRACE_PAGES NO

TRACE_PRIMARY_TREE NO

TRACE_SELECT NO

TRACE_TIME NO

TRACE_UPDATE NO

TRACE_STOP_ERRORCODE 0

TRACE_ALLOCATOR 0

TRACE_CATALOG 0

TRACE_CLIENTKERNELCOM 0

TRACE_COMMON 0

TRACE_COMMUNICATION 0

TRACE_CONVERTER 0

TRACE_DATACHAIN 0

TRACE_DATACACHE 0

TRACE_DATAPAM 0

TRACE_DATATREE 0

TRACE_DATAINDEX 0

TRACE_DBPROC 0

TRACE_FBM 0

TRACE_FILEDIR 0

TRACE_FRAMECTRL 0

TRACE_IOMAN 0

TRACE_IPC 0

TRACE_JOIN 0

TRACE_KSQL 0

TRACE_LOGACTION 0

TRACE_LOCKMANAGER 0

TRACE_LOGHISTORY 0

TRACE_LOGPAGE 0

TRACE_LOGTRANS 0

TRACE_LOGVOLUME 0

TRACE_MEMORY 0

TRACE_MESSAGES 0

TRACE_OBJECTCONTAINER 0

TRACE_OMS_CONTAINERDIR 0

TRACE_OMS_CONTEXT 0

TRACE_OMS_ERROR 0

TRACE_OMS_FLUSHCACHE 0

TRACE_OMS_INTERFACE 0

TRACE_OMS_KEY 0

TRACE_OMS_KEYRANGE 0

TRACE_OMS_LOCK 0

TRACE_OMS_MEMORY 0

TRACE_OMS_NEWOBJ 0

TRACE_OMS_SESSION 0

TRACE_OMS_STREAM 0

TRACE_OMS_VAROBJECT 0

TRACE_OMS_VERSION 0

TRACE_PAGER 0

TRACE_RUNTIME 0

TRACE_SHAREDSQL 0

TRACE_SQLMANAGER 0

TRACE_SRVTASKS 0

TRACE_SYNCHRONISATION 0

TRACE_SYSVIEW 0

TRACE_TABLE 0

TRACE_VOLUME 0

CHECK_BACKUP NO

CHECK_DATACACHE NO

CHECK_KB_REGIONS NO

CHECK_LOCK NO

CHECK_LOCK_SUPPLY NO

CHECK_REGIONS NO

CHECK_TASK_SPECIFIC_CATALOGCACHE NO

CHECK_TRANSLIST NO

CHECK_TREE NO

CHECK_TREE_LOCKS NO

CHECK_COMMON 0

CHECK_CONVERTER 0

CHECK_DATAPAGELOG 0

CHECK_DATAINDEX 0

CHECK_FBM 0

CHECK_IOMAN 0

CHECK_LOGHISTORY 0

CHECK_LOGPAGE 0

CHECK_LOGTRANS 0

CHECK_LOGVOLUME 0

CHECK_SRVTASKS 0

OPTIMIZE_AGGREGATION YES

OPTIMIZE_FETCH_REVERSE YES

OPTIMIZE_STAR_JOIN YES

OPTIMIZE_JOIN_ONEPHASE YES

OPTIMIZE_JOIN_OUTER YES

OPTIMIZE_MIN_MAX YES

OPTIMIZE_FIRST_ROWS YES

OPTIMIZE_OPERATOR_JOIN YES

OPTIMIZE_JOIN_HASHTABLE YES

OPTIMIZE_JOIN_HASH_MINIMAL_RATIO 1

OPTIMIZE_OPERATOR_JOIN_COSTFUNC YES

OPTIMIZE_JOIN_PARALLEL_MINSIZE 1000000

OPTIMIZE_JOIN_PARALLEL_SERVERS 0

OPTIMIZE_JOIN_OPERATOR_SORT YES

OPTIMIZE_QUAL_ON_INDEX YES

DDLTRIGGER YES

SUBTREE_LOCKS NO

MONITOR_READ 2147483647

MONITOR_TIME 2147483647

MONITOR_SELECTIVITY 0

MONITOR_ROWNO 0

CALLSTACKLEVEL 0

OMS_RUN_IN_UDE_SERVER NO

OPTIMIZE_QUERYREWRITE OPERATOR

TRACE_QUERYREWRITE 0

CHECK_QUERYREWRITE 0

PROTECT_DATACACHE_MEMORY NO

FILEDIR_SPINLOCKPOOL_SIZE 10

TRANS_HISTORY_SIZE 0

TRANS_THRESHOLD_VALUE 60

ENABLE_SYSTEM_TRIGGERS YES

DBFILLINGABOVELIMIT 70L80M85M90H95H96H97H98H99H

DBFILLINGBELOWLIMIT 70L80L85L90L95L

LOGABOVELIMIT 50L75L90M95M96H97H98H99H

AUTOSAVE 1

BACKUPRESULT 1

CHECKDATA 1

EVENT 1

ADMIN 1

ONLINE 1

UPDSTATWANTED 1

OUTOFSESSIONS 3

ERROR 3

SYSTEMERROR 3

DATABASEFULL 1

LOGFULL 1

LOGSEGMENTFULL 1

STANDBY 1

USESELECTFETCH YES

USEVARIABLEINPUT NO

UPDATESTAT_PARALLEL_SERVERS 0

UPDATESTAT_SAMPLE_ALGO 1

SIMULATE_VECTORIO NEVER

COLUMNCOMPRESSION YES

TIME_MEASUREMENT NO

CHECK_TABLE_WIDTH NO

MAX_MESSAGE_LIST_LENGTH 100

SYMBOL_RESOLUTION YES

PREALLOCATE_IOWORKER NO

CACHE_IN_SHARED_MEMORY NO

INDEX_LEAF_CACHING 2

NO_SYNC_TO_DISK_WANTED NO

SPINLOCK_LOOP_COUNT 30000

SPINLOCK_BACKOFF_BASE 1

SPINLOCK_BACKOFF_FACTOR 2

SPINLOCK_BACKOFF_MAXIMUM 64

ROW_LOCKS_PER_TRANSACTION 50

USEUNICODECOLUMNCOMPRESSION NO

FBM_CLUSTER_MODE MIXED

i really preciated any helpful.