Sorry for the misspelling:
That line should read:
db_activate dba,dba
Hope that helps, JLS
PS: I suspect that you were choosing dbm for the dba password in the wizard, too, no? This would explain the -7017 error.
JLS
Billy Willoughby wrote:
Good Morning;
Ok, I uninstalled MaxDB and reinstalled only maxdb-all-win-32bit-i386-7_5_0_8 and used the 'all' option. I'm running on WINDOWS XP Professional, all patches installed. I'm logged in as an Administrator. I have not changed any of the security on any of the created services or directories. I have the commands that I ran directly from DBMCLI below, along with all the files that I think have been requested in that past.
I find something odd however with the services. MaxDB creates the services SAPDB: .M750008* by default. If I try to run the service that ends in (omststknl.exe) I get the message "Error 2: The system cannot find the file specified." After I create the BVW database I get the same error with the SAPDB: BVW(omststknl.exe) service. The security on all the services is still the default "Local System Account". When I do a search on my computer, I can NOT find a file omststknl.exe if that's important. I apologize for the long post, I just want to get this working and I'm hoping that some information here may jump out at someone what I'm doing wrong.
Thanks for everything guys,
Billy Willoughby
COMMANDS I RAN:
I dropped the database as I was playing with options to get it running, so I wanted to start fresh before I did the post. C:\PROGRA~1\sdb\programs\pgm>dbmcli -d BVW -u dbm,dbm db_drop OK
C:\PROGRA~1\sdb\programs\pgm>edit script
C:\PROGRA~1\sdb\programs\pgm>dbmcli db_create BVW dbm,dbm OK
C:\PROGRA~1\sdb\programs\pgm>dbmcli -d BVW -u dbm,dbm -i script
param_startsessionOK
---
param_initOK
---
param_put MAXUSERTASKS 5OK
---
param_checkallOK
---
param_commitsessionOK
---
param_addvolume 1 LOG LOG_001 F 2000OK
---
param_addvolume 1 DATA DAT_001 F 10000OK
---
db_adminOK
---
db_activate dbm,dbm
ERR -24988,ERR_SQL: sql error
---
C:\PROGRA~1\sdb\programs\pgm>dbmcli -d BVW -u dbm,dbm db_offline OK
C:\PROGRA~1\sdb\programs\pgm>
ALL TEXT FROM KNLDIAG.ERR ---------------------------------------------------------------------------- ---- Date Time TID(hex) Typ MsgID Label Message-Text ---------------------------------------------------------------------------- ---- 2004-02-28 07:39:16 --- Starting GMT 2004-02-28 07:39:16 7.5.0 Build 008-123-061-548
ALL TEXT FROM KNLDIAG ---------------------------------------------------------------------------- ---- Date Time TID(hex) Typ MsgID Label Message-Text ---------------------------------------------------------------------------- ---- 2004-02-28 07:39:16 0xF70 19705 CONNECT Loading default TCPIP-DLL, ( 'sqltcp.dll') 2004-02-28 07:39:16 0xF70 19707 CONNECT WINSOCK: 2.0, SQLTCP-DLL: 7.5.0 2004-02-28 07:39:16 0xF70 19769 INFO Starting SERVERDB: 'BVW' 2004-02-28 07:39:17 0xF70 19770 INFO SERVERNODE: 'BBS-ATL-TECH-01' 2004-02-28 07:39:17 0xF70 19771 INFO Process ID: 3772 2004-02-28 07:39:17 0xF70 19773 INFO Date: 2004-02-28 2004-02-28 07:39:17 0xF70 19772 INFO Owner: 'SYSTEM' 2004-02-28 07:39:17 0xF70 19775 INFO Processors: 2 2004-02-28 07:39:17 0xF70 19782 INFO Fiber: 'YES' 2004-02-28 07:39:17 0xF70 19776 INFO Max virtual memory: 2047 MB 2004-02-28 07:39:17 0xF70 19777 INFO Total physical memory: 1023 MB 2004-02-28 07:39:17 0xF70 19778 INFO Available physical memory: 644 MB 2004-02-28 07:39:17 0xF70 202 RTE Memory allocation not limited 2004-02-28 07:39:17 0xF70 203 RTE System page cache usage enabled 2004-02-28 07:39:17 0xF70 19692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;30000*us;compress 2004-02-28 07:39:17 0xF70 19693 TCLUSTER number of 'BUP': 0 2004-02-28 07:39:17 0xF70 19693 TCLUSTER number of ' DW': 11 2004-02-28 07:39:17 0xF70 19693 TCLUSTER number of ' US': 5 2004-02-28 07:39:17 0xF70 19693 TCLUSTER number of ' SV': 21 2004-02-28 07:39:17 0xF70 19693 TCLUSTER number of ' EV': 1 2004-02-28 07:39:17 0xF70 19693 TCLUSTER number of ' GC': 0 2004-02-28 07:39:17 0xF70 19860 MEMORY RTE PageAllocator: 10000 Pages allocated 2004-02-28 07:39:17 0xF70 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages 2004-02-28 07:39:17 0xF70 19812 EVENTING Eventbuffer 100 events 1 tasks 2004-02-28 07:39:17 0xF70 19815 EVENTING No AliveEvent generation 2004-02-28 07:39:18 0xF70 19831 TRACE_IO Configured _MAX_MESSAGE_FILES:0 2004-02-28 07:39:18 0xF70 19832 TRACE_IO Disabled: No TraceMessagefiles wanted 2004-02-28 07:39:18 0x238 19688 THREAD CLOCK thread started 2004-02-28 07:39:18 0x8C0 19688 THREAD TIMER thread started 2004-02-28 07:39:18 0x648 19688 THREAD ASYNC0 thread started 2004-02-28 07:39:18 0xC68 19688 THREAD REQUESTOR thread started 2004-02-28 07:39:18 0x108 196 RTE CONSOLE thread started 2004-02-28 07:39:18 0xB90 19821 TASKING Thread 2960 starting 2004-02-28 07:39:18 0xD10 19821 TASKING Thread 3344 starting 2004-02-28 07:39:29 0xF70 19649 CONNECT Kernel threads initialization timeout 2004-02-28 07:39:29 0xD98 19821 TASKING Thread 3480 starting 2004-02-28 07:39:29 0xC64 19627 TASKING UKT started, TID:0xC64 2004-02-28 07:39:29 0xF20 19627 TASKING UKT started, TID:0xF20 2004-02-28 07:39:29 0xE18 19627 TASKING UKT started, TID:0xE18 2004-02-28 07:39:29 0xFB4 19627 TASKING UKT started, TID:0xFB4 2004-02-28 07:39:29 0x938 19627 TASKING UKT started, TID:0x938 2004-02-28 07:39:29 0x394 19627 TASKING UKT started, TID:0x394 2004-02-28 07:39:29 0x1CC 19627 TASKING UKT started, TID:0x1CC 2004-02-28 07:39:29 0x1CC 19615 VOLUMEIO Attaching volume 'knltrace' 2004-02-28 07:39:29 0xFD0 19613 DBSTATE I/O thread for 'knltrace' started 2004-02-28 07:39:29 0x1CC 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:6 2004-02-28 07:39:29 0x1CC 32 Admin Kernel state: 'ADMIN' reached 2004-02-28 07:39:29 0x1CC 54003 dynpool DYNP_A51_CACHE : 144 2004-02-28 07:39:29 0x1CC 54003 dynpool AK51SIZES user + 1 : 6 2004-02-28 07:39:29 0x1CC 54003 dynpool AK51SIZES headlist all : 24 2004-02-28 07:39:29 0x1CC 54003 dynpool AK51SIZES headlist elem: 4 2004-02-28 07:39:29 0x1CC 54003 dynpool AK51SIZES list all : 120 2004-02-28 07:39:29 0x1CC 54003 dynpool AK51SIZES list element : 20 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX FileListItemSize : 8 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX NumFileListItems : 2048 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX FileListSizeAll : 16384 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX FunnelItemSize : 8 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX QueueItemPtrSize : 4 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX QueueItemSize : 36 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX SortItemSize : 16 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX NumFunnelItems : 2048 2004-02-28 07:39:29 0x1CC 54003 dynpool INDEX FunnelSizeAll : 131072 2004-02-28 07:39:29 0x1CC 54003 dynpool DYNP_B49_IDXSIZE : 147456 2004-02-28 07:39:29 0x1CC 19600 VERSION 'Kernel 7.5.0 Build 008-123-061-548' 2004-02-28 07:39:29 0x1CC 19600 VERSION 'W32/INTEL 7.5.0 Build 008-123-061-548' 2004-02-28 07:39:29 0x1CC 54003 dynDATA DYND_K57_KB_PAGES : 11 2004-02-28 07:39:29 0x1CC 54003 dynDATA BACKUP RESTART REC (8K): 1 2004-02-28 07:39:29 0x1CC 54003 dynpool BACKUP TASK LIST : 208 2004-02-28 07:39:29 0x1CC 54003 dynpool BACKUP TAPE LIST : 688 2004-02-28 07:39:29 0x1CC 54003 dynpool BACKUP DEVSP LIST : 176 2004-02-28 07:39:29 0x1CC 54003 dynpool BACKUP SRR QUEUE : 656 2004-02-28 07:39:29 0x1CC 54003 dynpool DYNP_K38_SAVE_GLOB : 1728 2004-02-28 07:39:29 0x1CC 54003 dynDATA DYND_K38_SAVE : 217 2004-02-28 07:39:29 0x1CC 54003 dynDATA BACKUP RESTART REC (8K): 1 2004-02-28 07:39:29 0x1CC 54003 dynpool BACKUP TASK LIST : 32 2004-02-28 07:39:29 0x1CC 54003 dynpool BACKUP TAPE LIST : 688 2004-02-28 07:39:29 0x1CC 54003 dynpool BACKUP DEVSP LIST : 16 2004-02-28 07:39:29 0x1CC 54003 dynpool BACKUP SRR QUEUE : 128 2004-02-28 07:39:29 0x1CC 54003 dynpool DYNP_K38_AUTOSAVE : 864 2004-02-28 07:39:29 0x1CC 54003 dynDATA DYND_K38_AUTOSAVE : 41 2004-02-28 07:39:29 0x1CC 54003 dynpool KB50 mdesc item size : 232 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 mdesc items : 29 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 mdesc list size : 6728 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 mdesc list aligned: 6736 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 packet items : 22 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 packet desc size : 16 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 packet desc list : 352 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 packet size : 36656 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 packetsize aligned: 36656 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 packet list : 806432 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 parent list : 656 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 kbfunction_task : 28 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 parent items / 0.7: 40 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 parent desc size : 16 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 parentdesc aligned: 640 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 parent hash list : 160 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 parenthash aligned: 160 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 maxservertasks : 21 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 server desc size : 24 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 server list : 504 2004-02-28 07:39:29 0x1CC 54003 dynpool KB90 serverlist aligned: 512 2004-02-28 07:39:29 0x1CC 54003 dynpool DYNP_K90_DISTRIB : 814832 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 5 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:0 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 15 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:1 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 14 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:2 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 13 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:3 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 12 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:4 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 11 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:5 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 10 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:6 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 9 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:7 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 8 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:0 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 7 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:1 2004-02-28 07:39:29 0x1CC 14 Pager Start TaskId: 6 2004-02-28 07:39:29 0x1CC 15 Pager First DataCacheSegment:2 2004-02-28 07:39:30 0x8C0 199 RTE Kernel state changed from STARTING to ADMIN 2004-02-28 07:39:30 0x8C0 19601 DBSTATE SERVERDB is ready
============================================ begin of write cycle ==================
2004-02-28 07:39:31 0xF20 19633 CONNECT Connect req. (T4, Node:'',
PID:2120)
2004-02-28 07:39:31 0xF20 19651 CONNECT Connection released, T4
2004-02-28 07:39:31 0xF20 19633 CONNECT Connect req. (T4, Node:'',
PID:2120)
2004-02-28 07:39:31 0xF20 19651 CONNECT Connection released, T4
2004-02-28 07:39:31 0xF20 19633 CONNECT Connect req. (T4, Node:'',
PID:2120)
2004-02-28 07:39:31 0xF20 19615 VOLUMEIO Attaching volume 'LOG_001'
2004-02-28 07:39:32 0xED4 19613 DBSTATE I/O thread for 'LOG_001'
started
2004-02-28 07:39:32 0xF20 19617 VOLUMEIO Single I/O attach,
'LOG_001', UKT:3
2004-02-28 07:39:32 0xF20 19616 VOLUMEIO Detaching volume 'LOG_001'
2004-02-28 07:39:32 0xED0 19618 VOLUMEIO Single I/O detach,
'LOG_001', UKT:3
2004-02-28 07:39:32 0xED4 19614 DBSTATE I/O thread for 'LOG_001'
stopped
2004-02-28 07:39:32 0xF20 19615 VOLUMEIO Attaching volume 'LOG_001'
2004-02-28 07:39:32 0xE24 19613 DBSTATE I/O thread for 'LOG_001'
started
2004-02-28 07:39:32 0xF20 19617 VOLUMEIO Single I/O attach,
'LOG_001', UKT:3
2004-02-28 07:39:41 0xF20 19615 VOLUMEIO Attaching volume 'DAT_001'
2004-02-28 07:39:41 0xDF0 19613 DBSTATE I/O thread for 'DAT_001'
started
2004-02-28 07:39:41 0xF20 19617 VOLUMEIO Single I/O attach,
'DAT_001', UKT:3
2004-02-28 07:39:41 0xF20 19616 VOLUMEIO Detaching volume 'DAT_001'
2004-02-28 07:39:41 0xED0 19618 VOLUMEIO Single I/O detach,
'DAT_001', UKT:3
2004-02-28 07:39:41 0xDF0 19614 DBSTATE I/O thread for 'DAT_001'
stopped
2004-02-28 07:39:41 0xF20 19615 VOLUMEIO Attaching volume 'DAT_001'
2004-02-28 07:39:41 0x98C 19613 DBSTATE I/O thread for 'DAT_001'
started
2004-02-28 07:39:41 0xF20 19617 VOLUMEIO Single I/O attach,
'DAT_001', UKT:3
2004-02-28 07:39:41 0xF20 54003 dynpool DATA_CACHE_REGIONS :
8
2004-02-28 07:39:41 0xF20 54003 dynpool B20_DATACACHE_HEAD :
79784
2004-02-28 07:39:41 0xF20 54003 dynpool DATACACHE head num item:
9973
2004-02-28 07:39:41 0xF20 54003 dynpool DATACACHE head item siz:
8
2004-02-28 07:39:41 0xF20 54003 dynpool DATACACHE task queue :
720
2004-02-28 07:39:41 0xF20 54003 dynpool US + SV + DW + 8 :
45
2004-02-28 07:39:41 0xF20 54003 dynpool DATACACHE taskq elem :
16
2004-02-28 07:39:41 0xF20 54003 dynpool B20_DATACACHE_TASKQ :
80504
2004-02-28 07:39:41 0xF20 54003 dynDATA DATA_CACHE_PAGES :
1248
2004-02-28 07:39:41 0xF20 54003 dynpool B20_DATACACHE_CB :
89856
2004-02-28 07:39:41 0xF20 54003 dynpool DATACACHE num cblocks :
1248
2004-02-28 07:39:41 0xF20 54003 dynpool DATACACHE cblock size :
72
2004-02-28 07:39:41 0xF20 54003 dynpool DYNP_B20_DATACACHE
:1362880
2004-02-28 07:39:41 0xF20 54003 dynDATA DYND_B20_DATACACHE :
9984
2004-02-28 07:39:41 0xF20 53000 DATACACH Reduce Data Cache (pool):
1248
2004-02-28 07:39:41 0xF20 53000 DATACACH Reduce Data Cache (pool):
1248
2004-02-28 07:39:41 0xF20 53000 DATACACH Reduce Data Cache (pool):
1248
2004-02-28 07:39:41 0xF20 53000 DATACACH Reduce Data Cache (pool):
1248
2004-02-28 07:39:41 0xF20 4 Log Formatting from offset 1
to 1998.
2004-02-28 07:39:43 0xF20 19616 VOLUMEIO Detaching volume 'DAT_001'
2004-02-28 07:39:43 0xED0 19618 VOLUMEIO Single I/O detach,
'DAT_001', UKT:3
2004-02-28 07:39:43 0x98C 19614 DBSTATE I/O thread for 'DAT_001'
stopped
2004-02-28 07:39:43 0xF20 19616 VOLUMEIO Detaching volume 'LOG_001'
2004-02-28 07:39:43 0xED0 19618 VOLUMEIO Single I/O detach,
'LOG_001', UKT:3
2004-02-28 07:39:43 0xE24 19614 DBSTATE I/O thread for 'LOG_001'
stopped
2004-02-28 07:39:43 0xF20 19651 CONNECT Connection released, T4
2004-02-28 07:42:11 0xF70 19611 DBSTATE SERVERDB is being stopped
2004-02-28 07:42:11 0xC64 19617 VOLUMEIO Single I/O attach,
'knltrace', UKT:1
2004-02-28 07:42:11 0xF70 19684 TASKING Tracewriter termination
timeout: 1200 sec
2004-02-28 07:42:11 0xC64 19619 TASKING Releasing tracewriter
2004-02-28 07:42:11 0xF70 19600 VERSION 'Kernel 7.5.0 Build
008-123-061-548'
2004-02-28 07:42:11 0xF70 19654 DBSTATE SERVERDB 'BVW' has stopped
-------------------------------------------- current write position
----------------
<SNIP> I don't know if this is important, but I have a few THOUSAND blank
lines that
I'm cutting out between the SNIP tags.
</SNIP> =========================================== end of write cycle
===================
ALL TEXT FROM DBM.UTL
----------------------------------------------------------------------------
----
Date Time Message-Text
----------------------------------------------------------------------------
----
2004-02-28 07:39:31 40408C030001 0000 IC1 CREATE INSTANCE SYSDBA DBM
2004-02-28 07:39:43 40408C030001 0001 RET RETURNCODE -7017
-------------------------------------------- current write position
---------------- <SNIP> I don't know if this is important, but I have a few HUNDRED blank
lines that
I'm cutting out between the SNIP tags.
</SNIP> =========================================== end of write cycle
===================
ALL TEXT FROM DBMSRV.PRT
----------------------------------------------------------------------------
--
Date Time TID(hex) Typ MsgID Label Message
----------------------------------------------------------------------------
--
2004-02-28 07:24:13 0x0000034c 0 DBM command inst_reg -k
"c:\program files\sdb\7500" 2004-02-28 07:28:06 0x00000cd4 0 DBM command db_create BVW
2004-02-28 07:30:59 0x000005a8 0 DBM command
param_startsession 2004-02-28 07:30:59 0x000005a8 0 DBM command param_put
MAXUSERTASKS 5 2004-02-28 07:30:59 0x000005a8 0 DBM command
param_checkall 2004-02-28 07:30:59 0x000005a8 0 DBM command
param_commitsession 2004-02-28 07:30:59 0x000005a8 0 DBM command
param_addvolume 1 SYS sys_001 F 2004-02-28 07:30:59 0x000005a8 ERR -24996 DBM ERR_PARAM: wrong
parameters
2004-02-28 07:32:52 0x00000204 0 DBM command
param_startsession 2004-02-28 07:32:52 0x00000204 0 DBM command param_init 2004-02-28 07:32:52 0x00000204 ERR -24976 DBM ERR_PARAMEXIST: param
file of database already exists
2004-02-28 07:33:19 0x0000019c 0 DBM command db_create BVW
2004-02-28 07:33:29 0x000002b8 0 DBM command
param_startsession 2004-02-28 07:33:29 0x000002b8 0 DBM command param_put
MAXUSERTASKS 5 2004-02-28 07:33:29 0x000002b8 0 DBM command
param_checkall 2004-02-28 07:33:29 0x000002b8 0 DBM command
param_commitsession 2004-02-28 07:33:29 0x000002b8 0 DBM command
param_addvolume 1 SYS sys_001 F 2000
2004-02-28 07:33:29 0x000002b8 ERR -24996 DBM ERR_PARAM: wrong
parameters
2004-02-28 07:33:54 0x000009d4 0 DBM command db_create BVW
2004-02-28 07:34:13 0x000008e4 ERR -24977 DBM ERR_COMMAND: unknown
command "param"
2004-02-28 07:34:29 0x000008e4 ERR -24977 DBM ERR_COMMAND: unknown
command "param"
2004-02-28 07:34:34 0x000008e4 0 DBM command
param_startsession 2004-02-28 07:34:52 0x000008e4 0 DBM command param_put
MAXUSERETASK 5
2004-02-28 07:34:52 0x000008e4 ERR -24979 DBM ERR_XPNOTFOUND:
parameter not found
2004-02-28 07:35:04 0x000008e4 0 DBM command param_put
MAXUSERTASKS 5
2004-02-28 07:35:08 0x000008e4 0 DBM command
param_checkall 2004-02-28 07:35:14 0x000008e4 0 DBM command
param_commitsession 2004-02-28 07:35:30 0x000008e4 0 DBM command
param_addvolume 1 SYS sys_001 F
2004-02-28 07:35:30 0x000008e4 ERR -24996 DBM ERR_PARAM: wrong
parameters
2004-02-28 07:36:05 0x000008e4 0 DBM command
param_addvolume 1 SYS sys_001 F 2000 BVW
2004-02-28 07:36:05 0x000008e4 ERR -24946 DBM ERR_TOOMANYPARAM: too
many parameters
2004-02-28 07:36:08 0x000008e4 0 DBM command
param_addvolume 1 SYS sys_001 F 2000
2004-02-28 07:36:08 0x000008e4 ERR -24996 DBM ERR_PARAM: wrong
parameters
2004-02-28 07:36:10 0x000008e4 0 DBM command
param_addvolume 1 SYS sys_001 F BVW
2004-02-28 07:36:10 0x000008e4 ERR -24996 DBM ERR_PARAM: wrong
parameters
2004-02-28 07:36:12 0x000008e4 0 DBM command
param_addvolume 1 SYS sys_001 F 2004-02-28 07:36:12 0x000008e4 ERR -24996 DBM ERR_PARAM: wrong
parameters
2004-02-28 07:36:14 0x000008e4 0 DBM command
param_addvolume 1 SYS sys_001 2004-02-28 07:36:14 0x000008e4 ERR -24945 DBM ERR_TOOFEWPARAM: too
few parameters
2004-02-28 07:36:17 0x000008e4 0 DBM command
param_addvolume 1 SYS sys_001 File
2004-02-28 07:36:17 0x000008e4 ERR -24996 DBM ERR_PARAM: wrong
parameters
2004-02-28 07:37:18 0x000008e4 0 DBM command
param_addvolume 1 LOG LOG_001 F 2000
2004-02-28 07:37:29 0x000008e4 0 DBM command
param_addvolume 1 DATA DAT_001 F 10000
2004-02-28 07:37:32 0x000008e4 0 DBM command db_admin 2004-02-28 07:37:54 0x000008e4 0 DBM command db_activate 2004-02-28 07:37:58 0x000008e4 ERR -24988 DBM ERR_SQL: sql error
2004-02-28 07:38:12 0x000008e4 0 DBM command db_activate 2004-02-28 07:38:12 0x000008e4 ERR -24996 DBM ERR_PARAM: wrong
parameters
2004-02-28 07:38:15 0x000008e4 0 DBM command db_activate 2004-02-28 07:38:15 0x000008e4 ERR -24909 DBM ERR_DBAUNKNOWN:
SYSDBA unknown
2004-02-28 07:38:18 0x000008e4 0 DBM command db_activate 2004-02-28 07:38:20 0x000008e4 ERR -24895 DBM ERR_SHUTDOWN:
shutdown of database occured
2004-02-28 07:39:07 0x00000a9c 0 DBM command db_create BVW
2004-02-28 07:39:16 0x00000848 0 DBM command
param_startsession 2004-02-28 07:39:16 0x00000848 0 DBM command param_put
MAXUSERTASKS 5 2004-02-28 07:39:16 0x00000848 0 DBM command
param_checkall 2004-02-28 07:39:16 0x00000848 0 DBM command
param_commitsession 2004-02-28 07:39:16 0x00000848 0 DBM command
param_addvolume 1 LOG LOG_001 F 2000 2004-02-28 07:39:16 0x00000848 0 DBM command
param_addvolume 1 DATA DAT_001 F 10000 2004-02-28 07:39:16 0x00000848 0 DBM command db_admin 2004-02-28 07:39:31 0x00000848 0 DBM command db_activate 2004-02-28 07:39:43 0x00000848 ERR -24988 DBM ERR_SQL: sql error
-----Original Message-----
From: John L. Singleton [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 5:34 PM
To: Billy Willoughby
Cc: '[EMAIL PROTECTED]'
Subject: Re: Can Not Activate New Database
Billy,
So, according to the files you sent me, before the database can be created, it is throwing a -7017, or a User not allowed error.
The output of your dbmsrv file matches pretty much exactly what it should be, so in my mind that rules out some sort of protocol incompatibility.
The Solution: (I think)
This sort of error can be caused by choosing an invalid DBM username. Try this:
Do the wizard again, only accept all of the defaults in all sections. The default dbm username and password is dbm/dbm.
Let me know if that works. JLS Billy Willoughby wrote:
John;to
Here are the files you requested. Elke Zabach was kind enough to
look at some knrldiag files and they didn't show any activity. I'm going
drop the database and recreate it and re publish the knrldiag files to the group to see if they are more useful.
Thanks,
Billy Willoughby Fulton Paper Company
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
