Cisco Database Compresssion

[DNATA]

Hi All,

Need some help how to use the DBUNLOAD utility to compress or reduce CSU database size.

Our version of CiscoSecure for Unix = V2.3(3)

We have old CSU installation on Solaris and running out of disk space

[didyap]

Shrinking CSUnix database:

1. Use dbunload to unload the database:

You want to create a directory where to unload the data. For example,

/export/home/cse. Let us suppose that CiscoSecure is installed in /opt/CSCOacs and /opt/CSCOacs/sybase is where SQLAnywhere database is.

- set your environment variables

export SQLANY=/opt/CSCOacs/SYBSsa50

export SATMP=$SQLANY/tmp

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$SQLANY/lib

export PATH=$PATH:$SQLANY/bin

- cd /export/home/cse

dbunload -c "UID=DBA;PWD=SQL;DBF=/opt/CSCOacs/sybase/csecure.db" /export/home/cse

(This will create reload.sql in the current directory, i.e. /export/home/cse)

2. Save current database and log files.

/etc/rc0.d/K80CiscoSecure then

i.e. /opt/CSCOacs/sybase/csecure.db and

/opt/CSCOacs/sybase/csecure.log

Copy the empty template database and remove current log file

- cp /opt/CSCOacs/SYBSsa50/database/csecure.db /opt/CSCOacs/sybase/csecure.db

- rm /opt/CSCOacs/sybase(B/csecure.log

3. Load back the data into empty database

isql -c "UID=DBA;PWD=SQL;DBF=/opt/CSCOacs/sybase/csecure.db" read reload.sql

[Jeffrey.Grace]

A simpler way to set the environment:

". /opt/CSCOacs/utils/bin/env_setup"

Was there a particular reason for using the template database? I've not yet had any problems with a: "dbinit -c csecure".