Skip to Content
avatar image
Former Member

MaxDB 7.5.00.26: Tables and fields cannot be removed. How to solve?

Hi,

first of all, though it sounds similar this question is completely different to and independent from the "former question" () I posted a few hours ago. The "former question" refers to another MaxDB installation and computer where the problem mentioned below does not occur.

We have a MaxDB instance where some features do not work,

- Tables cannot be removed

- Fields of a table cannot be removed

- MaxDB odbc driver 7.5.00.26 does not work

besides of this the rest seems to be ok.

History: Originally MaxDB was installed as version 7.4. Then we migrated it to 7.5.00.26. Since (for now) some of the clients work with Win98 we use the MaxDB odbc driver 7.3 to make it possible. Unfortunately, MaxDB odbc driver 7.5.00.26 does not work on WinXP clients.

Perhaps the migration from 7.4 to 7.5.00.26 has not been done completely. Can you please point me to a info about this migration. Cannot find it any more. Perhaps something else is wrong. What can I do to solve the above mentioned "restrictions"?

Hints are very much appreciated. -- Thanks in advance.

Michael

-


All db params given by

dbmcli -d myDB -u dbm,dbm param_directgetall > maxdb_params.txt

are

OK
KERNELVERSION                    	KERNEL    7.5.0    BUILD 026-121-094-430
INSTANCE_TYPE                    	OLTP
MCOD                             	NO
_SERVERDB_FOR_SAP                	YES
_UNICODE                         	NO
DEFAULT_CODE                     	ASCII
DATE_TIME_FORMAT                 	INTERNAL
CONTROLUSERID                    	DBM
CONTROLPASSWORD                  	
MAXLOGVOLUMES                    	2
MAXDATAVOLUMES                   	11
LOG_VOLUME_NAME_001              	LOG_001
LOG_VOLUME_TYPE_001              	F
LOG_VOLUME_SIZE_001              	20000
DATA_VOLUME_NAME_0002            	DAT_0002
DATA_VOLUME_NAME_0001            	DAT_0001
DATA_VOLUME_TYPE_0002            	F
DATA_VOLUME_TYPE_0001            	F
DATA_VOLUME_SIZE_0002            	20000
DATA_VOLUME_SIZE_0001            	20000
DATA_VOLUME_MODE_0002            	NORMAL
DATA_VOLUME_MODE_0001            	NORMAL
DATA_VOLUME_GROUPS               	1
LOG_BACKUP_TO_PIPE               	NO
MAXBACKUPDEVS                    	2
BACKUP_BLOCK_CNT                 	8
LOG_MIRRORED                     	NO
MAXVOLUMES                       	14
_MULT_IO_BLOCK_CNT               	8
_DELAY_LOGWRITER                 	0
LOG_IO_QUEUE                     	50
_RESTART_TIME                    	600
MAXCPU                           	1
MAXUSERTASKS                     	50
_TRANS_RGNS                      	8
_TAB_RGNS                        	8
_OMS_REGIONS                     	0
_OMS_RGNS                        	25
OMS_HEAP_LIMIT                   	0
OMS_HEAP_COUNT                   	1
OMS_HEAP_BLOCKSIZE               	10000
OMS_HEAP_THRESHOLD               	100
OMS_VERS_THRESHOLD               	2097152
HEAP_CHECK_LEVEL                 	0
_ROW_RGNS                        	8
_MIN_SERVER_DESC                 	16
MAXSERVERTASKS                   	21
_MAXTRANS                        	292
MAXLOCKS                         	2920
_LOCK_SUPPLY_BLOCK               	100
DEADLOCK_DETECTION               	4
SESSION_TIMEOUT                  	900
OMS_STREAM_TIMEOUT               	30
REQUEST_TIMEOUT                  	5000
_IOPROCS_PER_DEV                 	2
_IOPROCS_FOR_PRIO                	0
_USE_IOPROCS_ONLY                	NO
_IOPROCS_SWITCH                  	2
LRU_FOR_SCAN                     	NO
_PAGE_SIZE                       	8192
_PACKET_SIZE                     	36864
_MINREPLY_SIZE                   	4096
_MBLOCK_DATA_SIZE                	32768
_MBLOCK_QUAL_SIZE                	16384
_MBLOCK_STACK_SIZE               	16384
_MBLOCK_STRAT_SIZE               	8192
_WORKSTACK_SIZE                  	8192
_WORKDATA_SIZE                   	8192
_CAT_CACHE_MINSIZE               	262144
CAT_CACHE_SUPPLY                 	1632
INIT_ALLOCATORSIZE               	221184
ALLOW_MULTIPLE_SERVERTASK_UKTS   	NO
_TASKCLUSTER_01                  	tw;al;ut;2000*sv,100*bup;10*ev,10*gc;
_TASKCLUSTER_02                  	ti,100*dw;30000*us;
_TASKCLUSTER_03                  	compress
_DYN_TASK_STACK                  	NO
_MP_RGN_QUEUE                    	YES
_MP_RGN_DIRTY_READ               	NO
_MP_RGN_BUSY_WAIT                	NO
_MP_DISP_LOOPS                   	2
_MP_DISP_PRIO                    	NO
XP_MP_RGN_LOOP                   	0
MP_RGN_LOOP                      	0
_MP_RGN_PRIO                     	NO
MAXRGN_REQUEST                   	300
_PRIO_BASE_U2U                   	100
_PRIO_BASE_IOC                   	80
_PRIO_BASE_RAV                   	80
_PRIO_BASE_REX                   	40
_PRIO_BASE_COM                   	10
_PRIO_FACTOR                     	80
_DELAY_COMMIT                    	NO
_SVP_1_CONV_FLUSH                	NO
_MAXGARBAGE_COLL                 	0
_MAXTASK_STACK                   	400
MAX_SERVERTASK_STACK             	100
MAX_SPECIALTASK_STACK            	100
_DW_IO_AREA_SIZE                 	50
_DW_IO_AREA_FLUSH                	50
FBM_VOLUME_COMPRESSION           	50
FBM_VOLUME_BALANCE               	10
_FBM_LOW_IO_RATE                 	10
CACHE_SIZE                       	10000
_DW_LRU_TAIL_FLUSH               	25
XP_DATA_CACHE_RGNS               	0
_DATA_CACHE_RGNS                 	8
XP_CONVERTER_REGIONS             	0
CONVERTER_REGIONS                	8
XP_MAXPAGER                      	0
MAXPAGER                         	11
SEQUENCE_CACHE                   	1
_IDXFILE_LIST_SIZE               	2048
_SERVER_DESC_CACHE               	74
_SERVER_CMD_CACHE                	22
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
_READAHEAD_BLOBS                 	25
RUNDIRECTORY                     	/var/opt/sdb/data/wrk/EVERW_B6
OPMSG1                           	/dev/console
OPMSG2                           	/dev/null
_KERNELDIAGFILE                  	knldiag
KERNELDIAGSIZE                   	800
_EVENTFILE                       	knldiag.evt
_EVENTSIZE                       	0
_MAXEVENTTASKS                   	1
_MAXEVENTS                       	100
_KERNELTRACEFILE                 	knltrace
TRACE_PAGES_TI                   	2
TRACE_PAGES_GC                   	0
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                  	653
EXTERNAL_DUMP_REQUEST            	NO
_AK_DUMP_ALLOWED                 	YES
_KERNELDUMPFILE                  	knldump
_RTEDUMPFILE                     	rtedump
_UTILITY_PROTFILE                	dbm.utl
UTILITY_PROTSIZE                 	100
_BACKUP_HISTFILE                 	dbm.knl
_BACKUP_MED_DEF                  	dbm.mdf
_MAX_MESSAGE_FILES               	0
_EVENT_ALIVE_CYCLE               	0
_SHAREDDYNDATA                   	10280
_SHAREDDYNPOOL                   	3658
_SHMKERNEL                       	91663
DIAG_HISTORY_NUM                 	2
DIAG_HISTORY_PATH                	/var/opt/sdb/data/wrk/EVERW_B6/DIAGHISTORY
_DIAG_SEM                        	1
SHOW_MAX_STACK_USE               	NO
LOG_SEGMENT_SIZE                 	6666
SUPPRESS_CORE                    	YES
FORMATTING_MODE                  	PARALLEL
FORMAT_DATAVOLUME                	YES
LOAD_BALANCING_CHK               	0
LOAD_BALANCING_DIF               	10
LOAD_BALANCING_EQ                	5
HS_STORAGE_DLL                   	libhsscopy
HS_SYNC_INTERVAL                 	50
USE_OPEN_DIRECT                  	NO
SYMBOL_DEMANGLING                	NO
EXPAND_COM_TRACE                 	NO
OPTIMIZE_OPERATOR_JOIN_COSTFUNC  	YES
OPTIMIZE_JOIN_PARALLEL_SERVERS   	0
OPTIMIZE_JOIN_OPERATOR_SORT      	YES
OPTIMIZE_JOIN_OUTER              	YES
JOIN_OPERATOR_IMPLEMENTATION     	IMPROVED
JOIN_TABLEBUFFER                 	128
OPTIMIZE_FETCH_REVERSE           	YES
SET_VOLUME_LOCK                  	YES
SHAREDSQL                        	NO
SHAREDSQL_EXPECTEDSTATEMENTCOUNT 	1500
SHAREDSQL_COMMANDCACHESIZE       	32768
MEMORY_ALLOCATION_LIMIT          	0
USE_SYSTEM_PAGE_CACHE            	YES
USE_COROUTINES                   	YES
USE_STACK_ON_STACK               	YES
USE_UCONTEXT                     	YES
MIN_RETENTION_TIME               	60
MAX_RETENTION_TIME               	480
MAX_SINGLE_HASHTABLE_SIZE        	512
MAX_HASHTABLE_MEMORY             	5120
HASHED_RESULTSET                 	NO
HASHED_RESULTSET_CACHESIZE       	262144
AUTO_RECREATE_BAD_INDEXES        	NO
LOCAL_REDO_LOG_BUFFER_SIZE       	0
FORBID_LOAD_BALANCING            	YES
SIMULATE_VECTORIO                	IF_OPEN_DIRECT_OR_RAW_DEVICE

Edited by: Michael Poetzsch on May 29, 2008 9:23 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 29, 2008 at 08:24 AM

    Hi Michael,

    how did you do the Migration?

    Did you use SDBUPD? If so, are there any errors in the logfile SDBUPD wrote (look into /sapdb/data/wrk)

    Had the systemtables been reloaded afterwards via load_systab?

    What are the error messages you see when you try to drop a table/column?

    What exactly is the problem with the ODBC driver?

    KR Lars

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Lars Breddemann

      >

      > The next step I would try is: perform a load_systab.

      >

      Hi Lars,

      I performed a load_systab yesterday and it solved the problem.

      Thanks a lot and kind regards.

      Michael