Failed to start SAPDB instance

[Former Member]

Hi experts,

I just installed MaxDB 7.6 in AIX 5.3. During the installation, I created the user "sdb", instance name "TST".

Under this sdb user, I ran this "./x_server start" to start the db server.

After that I used the command "./x_start TST "

Then I hit the follow error:

--- Starting GMT 2008-11-28 10:08:33 7.6.03 Build 009-123-163-622

2008-11-28 18:08:37 1 ERR 8 RTEMem No more system pages for 12288 bytes available,BYTE_SIZE=4096,DESCRIPTION=valloc,ERRORTEXT=ENOMEM ? out of memory

2008-11-28 18:08:37 1 ERR 11 RTEMem + Used 130277376 bytes from system heap with a limit of system imposed limitation bytes,ALLOC_COUNT=22,FREE_COUN

2008-11-28 18:08:37 1 ERR 11 RTEMem + T=0,ERROR_COUNT=275,BYTES_MAX_USED=13604741120

2008-11-28 18:08:37 1 ERR 11872 MEMORY Not enough memory for I/O buffer cache wanted : 13282304 kB!

2008-11-28 18:08:37 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x200

2008-11-28 18:08:37 0 ERR 12010 DBCRASH Kernel exited exit code 2

2008-11-28 18:08:37 ___ Stopping GMT 2008-11-28 10:08:37 7.6.03 Build 009-123-163-622

The interesting thing is that I am able to start the db instance from Database Manager.

Can anyone please help me to take a look at this issue? Is it the system memory problem? Or is it becasue the way I start db instance by unix command is wrong?

Thanks in advance!!

Regards,

Li Bin

[lbreddemann · Accepted solution]

Hi Li,

why do you use 'x_start' ?

AFAIK this is a long-gone now unsupported tool.

If I would have to guess, then I'd say that 'x_start' starts the kernel directly with a different environment and thus different process limits (ulimit).

When started via DBMGUI or DBMCLI the DBMServer starts the kernel in the right manner - thus avoiding the problem.

best regards,

Lars

[Former Member · Accepted solution]

Hi Lars,

Thanks for your reply!

Is DBMGUI the only way to start SAPDB? The DBMGUI is installed in our Windows PC. Now my boss want to know a way to start the DB instance by Unix command. If "x_start" is expired already, is there any other command I can use to start the instance without launch the GUI?

Thanks&Regards,

Li Bin

[lbreddemann · Accepted solution]

Hi Lin,

would you mind to check the documentation from time to time ? [http://maxdb.sap.com/documentation]

DBMGUI is not the only way (as I already indicated).

You may use dbmcli as well:

dbmcli -n <dbhostname> -d <DBSID> -u control,<pw> db_online

or, if you already setup the XUSER data correctly you may simply use:

dbmcli -U c db_online

By the way: SAP offers trainings on MaxDB (ADM515) - so your boss may want to book some of those...

regards,

Lars

[Former Member · Accepted solution]

Hi Lars,

Thanks for your reply!

I have solved this problem with the information you provide.

Regards,

Li Bin