Skip to content

Instantly share code, notes, and snippets.

@timoteoramos

timoteoramos/etc-sybase9-mydb.sh

Created March 29, 2018 14:06
Show Gist options
  • Save timoteoramos/4d89e6e44079fbc260953c3732d7c59e to your computer and use it in GitHub Desktop.
Save timoteoramos/4d89e6e44079fbc260953c3732d7c59e to your computer and use it in GitHub Desktop.
Download ZIP
Sybase 9 with systemd (first attempt)
Raw
etc-sybase9-mydb.sh
SVCNAME=sybase9-mydb
DBNAME=MYDB
DBPORT=2638
DBPATH=/srv/db
INITCACHE=2G
LOWCACHE=8G
UPCACHE=16G
Raw
sybase9-mydb-clearlog.sh
#!/bin/bash
source /opt/sybase/SYBSsa9/bin64/asa_config.sh
source /etc/sybase9/mydb.sh
systemctl stop $SVCNAME
/usr/local/sbin/sybase9-mydb-wrapper.sh -f
mkdir -p /tmp/sybase9/$DBNAME
mv $DBPATH/$DBNAME/DATABASE.log /tmp/sybase/$DBNAME/
systemctl start $SVCNAME
Raw
sybase9-mydb-wrapper.sh
#!/bin/bash
source /opt/sybase/SYBSsa9/bin64/asa_config.sh
source /etc/sybase9/mydb.sh
/opt/sybase/SYBSsa9/bin64/dbsrv9 -n $DBNAME -c$INITCACHE -cl$LOWCACHE -ch$UPCACHE -xTCPIP{serverport=$DBPORT} $* $DBPATH/$DBNAME/DATABASE.DB
Raw
sybase9-mydb.service
[Unit]
Description=Sybase 9 (MYDB)
[Service]
Type=simple
User=root
WorkingDirectory=/srv/db/MYDB
ExecStart=/usr/local/sbin/sybase9-mydb-wrapper.sh
Restart=on-failure
[Install]
WantedBy=multi-user.target
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment