Howto Dockerize SAP (formerly Sybase) Adaptive Server Enterprise (ASE) with regards to docker image size (target image is about 530mb) and some hints howto perform a scripted database server installation.
- This repo does not contain any SAP software, you may get a free "Developer" or "Express-Edition" of SAP ASE via https://scn.sap.com/community/developer-center/oltp-db
- We delete some directorys (Jconnect, diagserver, SCC, JREs) to keep the image small. You may need to edit the Dockerfile yourself if you need some of these components.
- The ASE server allocates a lot of shared memory. When running docker on 2.x Linux-Kernels you may hit a shared
memory limit (check limit via
ipcs -lm). To adjust the SHMMAX viasysctl kernel.shmmax=<value>extended privileges must be granted when the container is started (--privileged=true).
Some hints for scripted installation to get a running dataserver
Create a master device of 60 MB with 4K-pagesize. This command exits after creation.
/opt/sybase/ASE-15_0/bin/dataserver \
-d/opt/datadir/master.dat \
-b 60M \
-z 4K \
-e/opt/datadir/sybase_errorlog \
-c/opt/datadir/SYBASE.cfg \
-M/opt/datadir/ \
-sSYBASE
Startup the dataserver and wait until the server comes up (via netcat-tool)
/opt/sybase/ASE-15_0/bin/dataserver \
-d/opt/datadir/master.dat \
-e/opt/datadir/sybase_errorlog \
-c/opt/datadir/SYBASE.cfg \
-M/opt/datadir/ \
-sSYBASE
while ! echo | nc -4 localhost 5000 > /dev/null 2>&1; do sleep 1; done
isql -Usa -P --retserverror -SSYBASE << EOF
disk init name = "sysprocsdev",
physname = "/opt/datadir/sysprocsdev",
size = "180M"
go
create database sybsystemprocs on sysprocsdev = 180
go
EOF
isql -Usa -P --retserverror -SSYBASE -n -i $SYBASE/$SYBASE_ASE/scripts/installmaster
isql -Usa -P --retserverror -SSYBASE -n -i $SYBASE/$SYBASE_ASE/scripts/installmodel
isql -Usa -P --retserverror -SSYBASE -n -i $SYBASE/$SYBASE_ASE/scripts/instmsgs.ebf
isql -Usa -P --retserverror -SSYBASE -n -i $SYBASE/$SYBASE_ASE/scripts/installupgrade
isql -Usa -P -SSYBASE --retserverror -J iso_1 << EOF
exec sp_configure 'max memory', 384000 -- 750 MB
exec sp_configure 'enable console logging', 1
exec sp_configure 'send doneinproc tokens', 0
exec sp_configure 'number of user connections', 200
exec sp_configure 'max network packet size', 8192
exec sp_configure 'enable logins during recovery', 0
EOF
charset -Usa -SSYBASE -P binary.srt utf8
isql -Usa -P -SSYBASE -J iso_1 << EOF
sp_configure 'default character set', 190
go
sp_configure 'default sortorder id', 50
go
shutdown
go
EOF
Server needs to be started twice after the shutdown, because after
changing the charset the server performs a single-user start, performs translations and exits.
You may want a larger tempdb
isql -Usa -P --retserverror -SSYBASE << EOF
disk init
name = "tempdev2",
physname = "/opt/datadir/tempspace2.dat",
cntrltype = 0,
dsync = true,
size = "500M"
go
alter database tempdb on tempdev2 = 500
go
exec sp_cacheconfig 'default data cache', '200M'
go
EOF