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