Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a 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

  • author's profile photo Former Member
    Former Member
    Posted on 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 a 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

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2008 at 12:15 PM

    Hello

    Test output of load_sys posted in .

    Regards

    Bradley

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2008 at 01:02 PM

    Hello

    See for answer to this question.

    Regards

    Bradley

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.