Skip to Content
avatar image
Former Member

MaxDB 7.6.05.09 Create db inst fails on 'auto_extend'

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 29, 2008 at 03:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2008 at 06:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2008 at 10:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 31, 2008 at 07:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 31, 2008 at 12:15 PM

    Hello

    Test output of load_sys posted in .

    Regards

    Bradley

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2008 at 01:02 PM

    Hello

    See for answer to this question.

    Regards

    Bradley

    Add comment
    10|10000 characters needed characters exceeded