Trouble in AIX

alfredfong · #1 (**permalink**) 12-29-03, 04:32

I would like to install sybase ASE 12.5 on AIS 5.2.
When i use "srvbuild" to build the server and the master device is created, the error message prompted out (unable to boot the <server name>

Therefore i just built up the backup server and the ASE server cannot be set up.

How cn i cater it

fadace · #2 (**permalink**) 12-29-03, 08:13

check the reason in errorlog or in init/log

alfredfong · #3 (**permalink**) 12-29-03, 09:30

00:00000:00001:2003/12/28 14:49:08.30 server Database 'model': beginning upgrade step [ID 604]: creating table (table sysroles)
00:00000:00001:2003/12/28 14:49:08.45 server Database 'model': beginning upgrade step [ID 605]: executing SQL statement (declare @rid smallint delete sysro)
00:00000:00001:2003/12/28 14:49:08.62 server Database 'model': beginning upgrade step [ID 606]: executing SQL statement (select lct_admin('lastchance', db_i)
00:00000:00001:2003/12/28 14:49:08.64 server Database 'model': beginning upgrade step [ID 1013]: creating table (table syspartitions)
00:00000:00001:2003/12/28 14:49:08.82 server Database 'model': beginning upgrade step [ID 1124]: creating table (table systabstats)
00:00000:00001:2003/12/28 14:49:09.02 server Database 'model': beginning upgrade step [ID 1125]: creating table (table sysstatistics)
00:00000:00001:2003/12/28 14:49:09.24 server Database 'model': beginning upgrade step [ID 1126]: Initialize systabstats with valid statistics
00:00000:00001:2003/12/28 14:49:09.63 server Database 'model': beginning upgrade step [ID 1131]: Creating/Updating the last chance threshold for logsegment.
00:00000:00001:2003/12/28 14:49:09.66 server Database 'model': beginning upgrade step [ID 1201]: creating table (table sysxtypes)
00:00000:00001:2003/12/28 14:49:09.92 server Database 'model': beginning upgrade step [ID 1205]: creating table (table sysjars)
00:00000:00001:2003/12/28 14:49:10.15 server Database 'model': beginning upgrade step [ID 1206]: executing SQL statement (if not exists (select 1 from systyp)
00:00000:00001:2003/12/28 14:49:10.22 server Database 'model': beginning upgrade step [ID 1240]: creating table (table sysqueryplans)
00:00000:00001:2003/12/28 14:49:10.45 server Database 'model': beginning upgrade step [ID 1241]: executing SQL statement (insert into sysattributes (class, )
00:00000:00001:2003/12/28 14:49:10.55 server Database 'model': beginning upgrade step [ID 1274]: executing SQL statement (declare @rid smallint delete sysus)
00:00000:00001:2003/12/28 14:49:10.66 server Database 'model': beginning upgrade step [ID 1340]: executing SQL statement (update systypes set length=@@maxpag)
00:00000:00001:2003/12/28 14:49:10.71 server Database 'model': beginning upgrade step [ID 1400]: noting the present database upgrade level
00:00000:00001:2003/12/28 14:49:10.76 server CREATE DATABASE: allocating 1024 logical pages (2.0 megabytes) on disk 'master'.
00:00000:00001:2003/12/28 14:49:18.91 server Database sybsystemdb successfully created.
00:00000:00001:2003/12/28 14:49:18.95 server Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/28 14:49:18.95 server Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2003/12/28 14:49:19.05 server Boot Count: 1
00:00000:00001:2003/12/28 14:49:19.06 server Checking external objects.
00:00000:00001:2003/12/28 14:49:19.06 server Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/28 14:49:19.08 server Now loading SQL Server's new default sort order and character set
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysobjects: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking systypes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysusers: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysxtypes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysjars: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysobjects: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking systypes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysusers: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysxtypes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysjars: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysobjects: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking systypes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysusers: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysreferences: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysattributes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysxtypes: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysjars: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysdatabases: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking syslogins: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysdevices: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysconfigures: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysservers: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysremotelogins: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking syslanguages: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking syslanguages: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking syscharsets: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.08 server Checking sysresourcelimits: Logical pagesize is 2048 bytes
00:00000:00001:2003/12/28 14:49:19.12 server Default Sort Order successfully changed.
00:00000:00001:2003/12/28 14:49:19.12 server SQL Server shutdown after verifying System Indexes.
00:00000:00001:2003/12/28 14:49:19.12 kernel ueshutdown: exiting
00:00000:00001:2003/12/28 14:49:19.12 kernel Unix interval timer enabled for sysclk interrupts.
Sun Dec 28 14:49:19 2003: Buildmaster return code: 0.
Sun Dec 28 14:49:19 2003: Master device complete.
Sun Dec 28 14:49:19 2003: Writing RUN_polydbase3 file...
Sun Dec 28 14:49:19 2003: RUN_polydbase3 file complete.
Sun Dec 28 14:49:19 2003: Starting server...
Sun Dec 28 14:49:19 2003: (Shell command) /u01/sybase/sybase/ASE-12_5/bin/dataserver -spolydbase3 -z2k -d/u02/sybasedb/master.dat -e/u01/sybase/sybase/ASE-12_5/install/polydbase3.log -c/u01/sybase/sybase/ASE-12_5/polydbase3.cfg -M/u01/sybase/sybase/ASE-12_5 > /dev/null 2>&1
Sun Dec 28 14:52:29 2003: Task failed
Sun Dec 28 14:52:29 2003: Unable to boot server 'polydbase3'.
Sun Dec 28 14:52:29 2003: Server 'polydbase3' was not created.
type = 2

fadace · #4 (**permalink**) 12-29-03, 09:52

This is the log file. What's about the errorlog ?
Are you sure that the ASE is not already up (check with showserver) ?
Did you configure the shmmax ?
Are you creating a new server or upgrading an old one ?

alfredfong · #5 (**permalink**) 12-29-03, 13:08

I would like to know how to config shmmax
because i cant find that file . It seems not exist in /etc/system

fadace · #6 (**permalink**) 12-30-03, 04:53

Check the Sybase release bulletin.
You must add the entry in /etc/system

FYI: http://www.isug.com/Sybase_FAQ/ASE/S...5/Q10.5.4.html

alfredfong · #7 (**permalink**) 12-30-03, 06:40

Would you mind telling me how to set the entry
because i only find the version for su solaris

Wycislo · #8 (**permalink**) 12-30-03, 20:47

your in for some fun. Getting Sybase to work on AIX 5.2 took setting up Asynchronous I/O.

The magic formula is:

lsdev | grep aio
This should show you a list of devices set for asynch i/o.

mkdev -l aio0

<aio0 is the disk device that will store sybase, so yours might be different>

IBM wrote a cool doc on setting up sybase on aix5.2. Google for the link.

Do some homework on setting up asynchronous disk i/o on the aix server. Apparently you have to tell 5.2 to use a legacy i/o system inorder to run Sybase.

Even if you call sybase they will tell you you have to set up asynch i/o but they don't know how to do it.

Good luck.

alfredfong · #9 (**permalink**) 12-30-03, 22:53

It seems that the setting is complicated.

Would you mind giving me more details
Thanks!!

Wycislo · #10 (**permalink**) 12-31-03, 12:17

Guess you will have to contact either IBM or Sybase.

Before you install the sybase software, you have to set the disk to use the legacy asynchronous io. You do this using the mkdev command.

mkdev -L <device name>

mkdev -L aio0

I suggest rebooting the unix box after executing this command to make sure it stays after you restart the unix server. Look up the mkdev -L command on the ibm support web sites.

After you enable asynchronous i/o, the sybase install will work fine. You will be able to build the sybase server and life will be good.

Good luck.

alfredfong · #11 (**permalink**) 01-02-04, 04:44

I would like to know what is the device name.
That's mean i need to install the sybase on the device "aio0"

But actually i would like to install on other device.

fadace · #12 (**permalink**) 01-02-04, 18:17

During the setup, you need to specify the 2 main devices (1 for master and several other small databases, and 1 for sybsystemprocs). These devices can be fils systems or raw devices.

alfredfong · #13 (**permalink**) 01-02-04, 23:55

what is the relationship between the device of ASE and IBM AIS?

Wycislo · #14 (**permalink**) 01-12-04, 13:38

Do a google on
Quick installation guide for Sybase 12.5.x on IBM eServer Pseries with AIX 5L.

This doc was written by IBM and you will probably find it on thier site.

Google rocks!

Wycislo · #15 (**permalink**) 01-12-04, 13:50

http://www-106.ibm.com/developerwork...se_install.pdf

Here is the link to the doc that I was describing.

Chapter 4
number3

this is what is needed to get Sybase running on Aix 5.2.