Hi, I set the following when creating the database instance param_addvolume 1 SYS sys_001 F param_addvolume 1 LOG LOG_001 F 20000 param_addvolume 1 DATA DAT_001 F 20000
Now I see that the data devspace is full and I understand that I need to use db_adddevspace what size should I set for that? when I used a size of 40000. I get this error. -24916,ERR_MAXDEVCNT: max device count exceeded Can anyone please help me to solve the problem of adding db_devspace. Thanks poornima Info :when I use param_directall... ./dbmcli on gabesdb>param_directgetall OK KERNELVERSION KERNEL 7.4.3 BUILD 017-123-039-277 INSTANCE_TYPE OLTP _SERVERDB_FOR_SAP YES _UNICODE NO DEFAULT_CODE ASCII DATE_TIME_FORMAT INTERNAL CONTROLUSERID GABESUSER CONTROLPASSWORD MAXARCHIVELOGS 2 MAXDATADEVSPACES 11 LOG_BACKUP_TO_PIPE NO MAXBACKUPDEVS 2 BACKUP_BLOCK_CNT 8 LOG_MIRRORED NO LOG_MODE SINGLE _MAXDEVSPACES 14 _MULT_IO_BLOCK_CNT 8 _DELAY_LOGWRITER 0 LOG_IO_QUEUE 50 _RESTART_TIME 600 MAXCPU 1 MAXUSERTASKS 15 _TREE_RGNS 8 _TRANS_RGNS 8 _TAB_RGNS 8 _OMS_REGIONS 0 _OMS_RGNS 8 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 21 MAXSERVERTASKS 21 _MAXTRANS 152 MAXLOCKS 2500 _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 8192 _MBLOCK_STACK_SIZE 16384 _WORKSTACK_SIZE 8192 _WORKDATA_SIZE 8192 _CAT_CACHE_MINSIZE 262144 CAT_CACHE_SUPPLY 512 _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 _DW_IO_AREA_SIZE 50 _DW_IO_AREA_FLUSH 50 _FBM_DEVSP_COMPR 50 _FBM_DEVSP_BALANCE 10 _FBM_LOW_IO_RATE 10 CACHE_SIZE 10000 _DW_LRU_TAIL_FLUSH 25 XP_DATA_CACHE_RGNS 0 _DATA_CACHE_RGNS 8 CONVERTER_REGIONS 8 _MAXDATAWRITER 11 SEQUENCE_CACHE 1 _IDXFILE_LIST_SIZE 2048 _SERVER_DESC_CACHE 39 _SERVER_CMD_CACHE 22 DEVNO_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/sapdb/indep_data/wrk/GABESDB 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_AL 5 TRACE_PAGES_DW 3 TRACE_PAGES_US 10 TRACE_PAGES_UT 5 TRACE_PAGES_SV 5 TRACE_PAGES_EV 2 TRACE_PAGES_BUP 0 KERNELTRACESIZE 303 _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 _SHMCHUNK 32 _SHAREDDYNDATA 10282 _SHAREDDYNPOOL 3686 _SHMKERNEL 88828 ARCHIVE_LOG_001 LOG_001 ARCHIVE_TYPE_001 F ARCHIVE_SIZE_001 20000 DATADEV_0001 DAT_001 DATA_TYPE_0001 F DATA_SIZE_0001 20000 __PARAM_CHANGED___ 0 __PARAM_VERIFIED__ 2003-07-07 16:37:34 DIAG_HISTORY_NUM 2 DIAG_HISTORY_PATH /var/opt/sapdb/indep_data/wrk/GABESDB/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 EXPAND_COM_TRACE NO ALLOW_DEMANGLE YES USE_OPEN_DIRECT NO --- __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
