Hello Everyone;
Sorry for my ignorance, and thank you for all your assistance,
I now have my MaxDB setup and running!
Now I can learn even more. Are there any good books on SapDB/MaxDB ? I've
acquired the .pdf manuals from the mysql website.
Thank you for everything,
Billy Willoughby
----- Original Message -----
From: "Strahl, Torsten" <[EMAIL PROTECTED]>
To: "'Billy Willoughby'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 01, 2004 3:03 AM
Subject: RE: Can Not Activate New Database
Hi Billy,
I assume that your log area is full! You have to activate the autosave log
feature!
Scan the archive for detailed informations.
Regards,
Torsten
SAP DB, SAP Labs Berlin
-----Original Message-----
From: Billy Willoughby [mailto:[EMAIL PROTECTED]
Sent: Montag, 1. M�rz 2004 03:14
To: '[EMAIL PROTECTED]'
Subject: RE: Can Not Activate New Database
Ok guys, Good Morning;
I feel the dummy. That worked, I misunderstood the example I was
reading about how to create a database. I got the database activate to work.
Now I can bring the data online it says OK. When I do the next command I
found in the example (load_systab -ud sql or I tried load_systab -ud dbm)
the system just hangs.(I've waited over an hour) It hangs there (Create
System Tables...) if I use the GUI Wizard as well. I'm soooo close I can
taste it. Any ideas?
Thank you for your time and assistance,
Billy Willoughby
-----Original Message-----
From: John L. Singleton [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 28, 2004 11:11 AM
To: Billy Willoughby; '[EMAIL PROTECTED]'
Subject: Re: Can Not Activate New Database
Billy,
Change the line
db_activate dbm,dbm
to
db_acticate dba,dba
The purpose of this command is to create the dba or system database
administrator. This command will fail, of course, if you try to grant
that privlage to yourself (DBM)
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_startsession
>>
>>
>OK
>
>---
>
>
>>param_init
>>
>>
>OK
>
>---
>
>
>>param_put MAXUSERTASKS 5
>>
>>
>OK
>
>---
>
>
>>param_checkall
>>
>>
>OK
>
>---
>
>
>>param_commitsession
>>
>>
>OK
>
>---
>
>
>>param_addvolume 1 LOG LOG_001 F 2000
>>
>>
>OK
>
>---
>
>
>>param_addvolume 1 DATA DAT_001 F 10000
>>
>>
>OK
>
>---
>
>
>>db_admin
>>
>>
>OK
>
>---
>
>
>>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;
>> 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
>>
>>
>to
>
>
>>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]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
