MaxDB 7.6.05.09 Create db inst fails on 'auto_extend'

[Former Member]

Hello

I have loaded MaxDB 7.6.05.09 and DBMGUI 7.6.00.37 (148140) on Windows Server 2003 SP2.

I try and create a database instance with the DBMGUI but it fails on 'auto_extend' with return code -24805.

Here are the steps I did:

Start DBMGUI

Use the Create Intsance Wizard to created a database.

Select Desktop PC / Laptop and accept all the default values.

Fails with an auto extend error.

Here is the relevant output from dbmsrv_SUNFLOWER.prt:

2008-10-29 16:46:10 0x00001148 INF        216 DBMSrv   DBM Server client connection (established at 2008-10-29 16:46:10): PID 4276 on computer sunflower.pha.co.za
2008-10-29 16:46:10 0x00001148 INF        283 DBMSrv   Command 'db_create -a ...' is being executed.
2008-10-29 16:46:10 0x00001148 INF        419 DBMSrv   Command 'db_create' has ended with return code 0.
2008-10-29 16:46:10 0x00001148 INF        226 DBMSrv   DBM Server client disconnected: PID 4276 on computer sunflower.pha.co.za
2008-10-29 16:46:11 0x0000116c INF          4 DBMSrvLo This DBM Server does not switch its log file to file dbm.prt in the run directory.
                    0x0000116c INF         21 DBMSrv   Parameter RUNDIRECTORY not found
2008-10-29 16:46:14 0x0000116c INF        216 DBMSrv   DBM Server client connection (established at 2008-10-29 16:46:11): PID 4276 on computer sunflower.pha.co.za
2008-10-29 16:46:14 0x0000116c INF        283 DBMSrv   Command 'auto_extend show' is being executed.
2008-10-29 16:46:15 0x0000116c INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
2008-10-29 16:46:15 0x0000116c INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
2008-10-29 16:46:16 0x0000116c INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
2008-10-29 16:46:16 0x0000116c INF        283 DBMSrv   Command 'param_put SESSION_TIMEOUT "0"' is being executed.
2008-10-29 16:46:16 0x0000116c INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-29 16:46:17 0x0000116c INF        283 DBMSrv   Command 'param_directput _UNICODE "YES"' is being executed.
2008-10-29 16:46:17 0x0000116c INF        419 DBMSrv   Command 'param_directput' has ended with return code 0.
2008-10-29 16:46:17 0x0000116c INF        283 DBMSrv   Command 'param_put CACHE_SIZE "2500"' is being executed.
2008-10-29 16:46:17 0x0000116c INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-29 16:46:17 0x0000116c INF        283 DBMSrv   Command 'param_put _SERVERDB_FOR_SAP "NO"' is being executed.
2008-10-29 16:46:18 0x0000116c INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-29 16:46:18 0x0000116c INF        283 DBMSrv   Command 'param_put MAXDATAVOLUMES "64"' is being executed.
2008-10-29 16:46:19 0x0000116c INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-29 16:46:19 0x0000116c INF        283 DBMSrv   Command 'param_put XP_MAXPAGER "3"' is being executed.
2008-10-29 16:46:19 0x0000116c INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-29 16:46:19 0x0000116c INF        283 DBMSrv   Command 'param_put MAXUSERTASKS "10"' is being executed.
2008-10-29 16:46:20 0x0000116c INF        419 DBMSrv   Command 'param_put' has ended with return code 0.
2008-10-29 16:46:20 0x0000116c INF        283 DBMSrv   Command 'param_checkall EXTENDED' is being executed.
2008-10-29 16:46:20 0x0000116c INF        419 DBMSrv   Command 'param_checkall' has ended with return code 0.
2008-10-29 16:46:20 0x0000116c INF        283 DBMSrv   Command 'param_commitsession NOCLOSE' is being executed.
2008-10-29 16:46:26 0x0000116c INF        419 DBMSrv   Command 'param_commitsession' has ended with return code 0.
2008-10-29 16:46:26 0x0000116c INF        283 DBMSrv   Command 'param_addvolume 1 DATA "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB1\data\DISKD0001" F 32768' is being executed.
2008-10-29 16:46:27 0x0000116c INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
2008-10-29 16:46:28 0x0000116c INF        283 DBMSrv   Command 'param_addvolume 1 LOG "C:\Documents and Settings\All Users\Application Data\sdb\data\MAXDB1\log\DISKL001" F 6400' is being executed.
2008-10-29 16:46:30 0x0000116c INF        419 DBMSrv   Command 'param_addvolume' has ended with return code 0.
2008-10-29 16:46:30 0x0000116c INF        283 DBMSrv   Command 'db_admin -f' is being executed.
2008-10-29 16:46:38 0x0000116c INF        419 DBMSrv   Command 'db_admin' has ended with return code 0.
2008-10-29 16:46:39 0x0000116c INF        283 DBMSrv   Command 'auto_extend show' is being executed.
2008-10-29 16:46:39 0x0000116c INF        419 DBMSrv   Command 'auto_extend' has ended with return code 0.
2008-10-29 16:46:39 0x0000116c INF        283 DBMSrv   Command 'auto_update_statistics show' is being executed.
2008-10-29 16:46:39 0x0000116c INF        419 DBMSrv   Command 'auto_update_statistics' has ended with return code 0.
2008-10-29 16:46:39 0x0000116c INF        283 DBMSrv   Command 'auto_extend on 90' is being executed.
2008-10-29 16:46:40 0x0000116c ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'auto_extend' has ended and failed with return code -24805.
                    0x0000116c ERR     -24805 DBMSrv   ERR_NOAUTOEXTEND: auto extend feature not activated
                    0x0000116c ERR     -24964 DBMSrv   ERR_EXECUTE: Error in program execution
                    0x0000116c ERR     -24853 DBMSrv   ERR_NOSERVERPROCESSRUNNING: Could not start server process (used command: "dbm_execute_serverprocess 2 start -internal "C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\MAXDB1\dbmsilevt.cfg" -l "C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\MAXDB1\dbmevtdisp.prt" -d MAXDB1 -u DBM,*")
                    0x0000116c ERR     -24778 DBMSrv   -4,unknown host name
2008-10-29 16:46:52 0x0000116c INF        226 DBMSrv   DBM Server client disconnected: PID 4276 on computer sunflower.pha.co.za

As suggested in I tried the following:

Check localhost host name.

C:\Documents and Settings\All Users\Application Data\sdb\data\wrk
#type c:\WINDOWS\system32\drivers\etc\hosts
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

127.0.0.1       localhost

And execute

C:\Documents and Settings\All Users\Application Data\sdb\data\wrk
#dbmcli -d P01 -u DBA,* -n localhost
dbmcli on localhost : P01>

(P01 was created with auto_extend off)

Any futher suggestions would be appreciated.

Regards

Bradley

[Former Member · Accepted solution]

Hi Bradley,

please try

#dbmcli -d P01 -u dbm,* auto_extend ON

and

#dbmcli -d P01 -u dbm,* -n localhost auto_extend ON

with the user accout that you run the DBMGUI with. What is the output?

Please provide output of

#echo %COMSPEC%

Regards,

Marc-Philip

Edited by: Marc-Philip Werner on Oct 29, 2008 4:20 PM

Edited by: Marc-Philip Werner on Oct 29, 2008 4:21 PM

[Former Member]

Hello

See for answer to this question.

Regards

Bradley

[Former Member]

Hello

Test output of load_sys posted in .

Regards

Bradley

[Former Member]

Hello

#set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\admin\Application Data
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SUNFLOWER
ComSpec=C:\WINDOWS\system32\cmd.exe
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\admin
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
LOGONSERVER=\\DAFFODIL
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Prog
ram Files\Windows Resource Kits\Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS
\System32\Wbem;C:\Program Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Progra
m Files\Vim\vim71;C:\Program Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program F
iles\Microsoft SQL Server\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
ProgramFiles=C:\Program Files
PROMPT=$M$P$_#
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\admin\LOCALS~1\Temp
TMP=C:\DOCUME~1\admin\LOCALS~1\Temp
USERDNSDOMAIN=PHA.CO.ZA
USERDOMAIN=SWEIDAN
USERNAME=admin
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\WINDOWS

Create dir

#md "C:\Documents and Settings\admin\WINDOWS\TEMP"

C:\Documents and Settings\admin
#dir "C:\Documents and Settings\admin\WINDOWS\TEMP"
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\Documents and Settings\admin\WINDOWS\TEMP

2008/10/31  12:37 PM    <DIR>          .
2008/10/31  12:37 PM    <DIR>          ..
               0 File(s)              0 bytes
               2 Dir(s)  51,938,512,384 bytes free

I then tried

#dbmcli -d P01 -u dbm,* auto_extend ON
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000000
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\Documents and Settings\admin\WINDOWS\TEMP
TMP=C:\Documents and Settings\admin\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
ERR
-24805,ERR_NOAUTOEXTEND: auto extend feature not activated
-24964,ERR_EXECUTE: Error in program execution
-24853,ERR_NOSERVERPROCESSRUNNING: Could not start server process (used command:
 "dbm_execute_serverprocess 2 start -internal E:\ProgramFiles\MaxDB\indep_data\w
rk\P01\dbmsilevt.cfg -l E:\ProgramFiles\MaxDB\indep_data\wrk\P01\dbmevtdisp.prt
-d P01 -u DBM,*")
-4,unknown host name

and

C:\Documents and Settings\admin
#dbmcli -d P01 -u dbm,* -n localhost auto_extend ON
OK

So I don't think creating a db with all the defaults will work. If you would like me to try and create a another db with the DBGUI with all the defaults let me know and I'll give it a try.

Kind regards

Bradley

[Former Member]

Bradley,

please make sure that the "missing" directory exists. Then please create a new database with DBMGUI (can be small) and disable auto_extend. Does this work? If yes, we'd have an explantion for the failure at load_systab.

Regards,

Marc-Philip

Edited by: Marc-Philip Werner on Oct 31, 2008 11:57 AM

[Former Member]

Hello

Logged on as the usual user, user X.

I had to stop P01 before I could copy the new dbmsrv.exe.

Copy new dbmsrv.exe

#cp -p f:\brad\dbmsrv_04.exe "c:\Program Files\sdb\7605\pgm\dbmsrv.exe"

C:\Documents and Settings\admin
#dir "c:\Program Files\sdb\7605\pgm\dbmsrv.exe"
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of c:\Program Files\sdb\7605\pgm

2008/10/30  05:41 PM         2,981,888 dbmsrv.exe

Run dbmcli command

#dbmcli -d P01 -u DBA,* dbm_version
***** begin environment dump
=C:=C:\Program Files\sdb\7605
=ExitCode=00000002
ClusterLog=C:\WINDOWS\Cluster\cluster.log
ComSpec=C:\Documents and Settings\admin\WINDOWS\system32\cmd.exe
DBROOT=C:\Program Files\sdb\7605
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_04
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=C:\Program Files\sdb\7605\bin;C:\Program Files\sdb\7605\pgm;C:\Program File
s\sdb\programs\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\sdb\progra
ms\bin;C:\Program Files\sdb\programs\pgm;C:\Program Files\Windows Resource Kits\
Tools\;C:\Documents and Settings\admin\WINDOWS\system32;C:\Documents and Setting
s\admin\WINDOWS;C:\Documents and Settings\admin\WINDOWS\System32\Wbem;C:\Program
 Files\Riverbed\;E:\ProgramFiles\gnuwin32\bin;c:\Program Files\Vim\vim71;C:\Prog
ram Files\Java\j2re1.4.2_06\bin;C:\Utility;C:\Program Files\Microsoft SQL Server
\90\Tools\binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f06
PROMPT=$M$P$_#
SYSTEMDRIVE=C:
SYSTEMROOT=C:\Documents and Settings\admin\WINDOWS
TEMP=C:\Documents and Settings\admin\WINDOWS\TEMP
TMP=C:\Documents and Settings\admin\WINDOWS\TEMP
USERPROFILE=C:\Documents and Settings\admin
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\Documents and Settings\admin\WINDOWS
***** end environment dump
OK
VERSION    = 7.6.05
BUILD      = DBMServer 7.6.05   Build 009-023-000-000
OS         = WIN32
INSTROOT   = C:\Program Files\sdb\7605
LOGON      = True
CODE       = UTF8
SWAP       = full
UNICODE    = YES
INSTANCE   = OLTP
SYSNAME    = Windows Server 2003 family

I see that the TMP/ TEMP environment variables are set to the System values where as when I echo %TMP% / %TEMP% or run set they are set to the User values.

Output from set

#set
. . .
TEMP=C:\DOCUME~1\admin\LOCALS~1\Temp
TMP=C:\DOCUME~1\admin\LOCALS~1\Temp
. . .

"C:\Documents and Settings\admin\WINDOWS\TEMP" does not exist.

#dir "C:\Documents and Settings\admin\WINDOWS\TEMP"
 Volume in drive C is System
 Volume Serial Number is D819-1472

 Directory of C:\Documents and Settings\admin\WINDOWS

File Not Found

Regards

Bradley

Edited by: Bradley Patchett on Oct 31, 2008 8:29 AM

[Former Member]

Bradley,

now that's interesting. For completeness: Could you please provide the entire environment for user X? Please post output of

#set

Can you create a database with all defaults, if you create the "missing" directories first?

Regards,

Marc-Philip

[Former Member]

Hello

As requested:

#dbmcli -d P01 -u dbm,* auto_extend ON

ERR
-24805,ERR_NOAUTOEXTEND: auto extend feature not activated
-24964,ERR_EXECUTE: Error in program execution
-24853,ERR_NOSERVERPROCESSRUNNING: Could not start server process (used command: "dbm_execute_serverprocess 2 start -internal E:\ProgramFiles\MaxDB\indep_data\wrk\P01\dbmsilevt.cfg -l E:\ProgramFiles\MaxDB\indep_data\wrk\P01\dbmevtdisp.prt -d P01 -u DBM,*")
-4,unknown host name

#dbmcli -d P01 -u dbm,* -n localhost auto_extend ON
OK

#echo %COMSPEC%
C:\WINDOWS\system32\cmd.exe

Regards

Bradley

[Former Member]

Bradley,

please download a new dbmsrv.exe from [here|https://sapmats-de.sap-ag.de/download/download.cgi?id=FPQ582U6VGGJ6BT6UTUDABBPTTLKNF2FP9HSID3JF2QUHJNZ4W]. It prints its environment to stdout and is only fit for testing. Please put it to <instroot>/pgm (make a copy the exisiting dbmsrv.exe before).

Please try

dbmcli -d P01 -u DBA,* dbm_version

and post the output.

Put back the copy that you made in the beginning.

Regards,

Marc-Philip