grow vdevno Number

devno anzeigen / ändern

 

-- In der Config Datei den Parameter ändern und Sybase Server booten.

 

$ vi /opt/sybase/V12.0/SASB.cfg

[...]

[Disk I/O]

disk i/o structures = 512

page utilization percent = DEFAULT

number of devices = 40

disable disk mirroring = DEFAULT

disable character set conversions = DEFAULT

enable unicode conversions = DEFAULT

size of unilib cache = DEFAULT

 

 

 

-- Aktuelle Status in der DB.

$ isql -Usa -SSASB -w1000

Password:

1> sp_configure devices

2> go

Parameter Name     Default     MemoryUsed     Config     Value Run Value

------------------------------ ----------- ----------- ------------ -----------

number of devices     10         #12             30         30

(1 row affected)

(return status = 0)

 

1> select distinct low/16777216 from sysdevices order by low

2> go

-----------

0

1

2

[....]

27

28

29

(29 rows affected)

1>

 

 

 

-- Reboot des Sybase Server

$ . /opt/sybase/sybtbx/stop_server

#################################

ACHTUNG - bitte ueberpruefen

Stopping dataserver SASB ...

vom Typ BACKUP

Password:

fid spid status loginame origname hostname blk_spid

dbname cmd block_xloid

------ ------ ------------ ------------ ------------ ---------- --------

---------- ---------------- -----------

0 1 running batchsa batchsa rmx114 0

master SELECT 0

0 2 sleeping NULL NULL 0

master NETWORK HANDLER 0

0 3 sleeping NULL NULL 0

master DEADLOCK TUNE 0

0 4 sleeping NULL NULL 0

master MIRROR HANDLER 0

0 5 sleeping NULL NULL 0

master ASTC HANDLER 0

0 6 sleeping NULL NULL 0

master CHECKPOINT SLEEP 0

0 7 sleeping NULL NULL 0

master HOUSEKEEPER 0

0 8 sleeping NULL NULL 0

master AUDIT PROCESS 0

0 9 sleeping NULL NULL 0

master NETWORK HANDLER 0

0 10 alarm sleep batchsa batchsa rmx114 0

master WAITFOR 0

(10 rows affected)

(return status = 0)

Backup Server: 3.48.1.1: The Backup Server will go down immediately.

Terminating sessions.

Server SHUTDOWN by request.

The SQL Server is terminating this process.

CT-LIBRARY error:

ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

UID PID PPID C STIME TTY TIME CMD

[2] + Done . /opt/sybase/sybtbx/start_server

[1] + Done . /opt/sybase/sybtbx/start_server

 

 

$ . /opt/sybase/sybtbx/start_server

Starting dataserver SASB ...

[1] 24363

Dataserver is booting ...

Dataserver is booting ...

[...]

Dataserver is booting ...

Dataserver is booting ...

Dataserver is up !

Starting Backup-Server SASB_BS ...

[2] 24561

UID PID PPID C STIME TTY TIME CMD

sybase 24364 24363 11 11:48:05 ? 0:55 /opt/sybase/V12.0/ASE-12_0/bin/dataserver -d/dev/opt/sybase/SASP/masterdevice -

sybase 24554 24364 0 11:49:39 ? 0:00 /opt/sybase/V12.0/ASE-12_0/bin/dataserver -ONLINE:1,0,0x9e969dab, e000000, 0xf0

sybase 24563 24561 0 11:49:42 pts/24 0:00 /opt/sybase/V12.0/ASE-12_0/bin/backupserver -e/var/opt/sybase/log/SASB_BS.log -

 

 

 

-- Prüfen der Parameters

$ isql -Usa -SSASB -w1000

Password:

1> sp_configure devices

2> go

Parameter Name     Default     Memory     Used Config     Value Run Value

------------------------------ ----------- ----------- ------------ -----------

number of devices     10         #16         40             40

(1 row affected)

(return status = 0)