讲义说明讲稿1

1、InstallationThe installation is customized and performed in two steps/ericsson/versant/bin/Extract_EXTRvrsnt.sh/ericsson/versant/bin/Configure_EXTRvrsnt.shVerification is done with/ericsson/versant/bin/Verify_EXTRvrsnt.sh These scripts are called from core.sh installation scriptEnvironmentoscp -iVer

2、sant Product Version: 6.0.1.1 Versant Root Path: /opt/versant/ODBMS Versant Runtime Path: /opt/versant/ODBMS Versant DB Directory: /export/versant/db Versant osc-dbid node name: tomas1o Versant osc-dbid path: /export/versant/dbid VERSANT_ROOT: /opt/versant/ODBMS VERSANT_DB: /export/versant/db VERSAN

3、T_DBID: /export/versant/dbid Versant ss.d Location: /opt/versant/ODBMS/bin/ss.d Database ListID = 1 DB name = PASDBtomas1o creator = nmsadm date created = Fri Jan 23 12:14:40 2004 db type = GROUP DATABASE db version = 6.0.1.1 ID = 2 DB name = AMDBtomas1o creator = nmsadm date created = Tue Jan 27 09

4、:33:20 2004 db type = GROUP DATABASE db version = 6.0.1.1 ID = 3 DB name = SMCStomas1o creator = nmsadm date created = Tue Jan 27 09:33:45 2004 db type = GROUP DATABASE db version = 6.0.1.1 ID = 4 DB name = NADBtomas1o creator = nmsadm date created = Wed Jan 28 09:42:58 2004 db type = GROUP DATABASE

5、 db version = 6.0.1.1 ID = 5DB name = NMSNADBtomas1o creator = nmsadm date created = Wed Jan 28 09:42:58 2004 db type = GROUP DATABASE db version = 6.0.1.1 ID = 6 DB name = ONRM_CStomas1o creator = nmsadm date created = Wed Jan 28 09:42:58 2004 db type = GROUP DATABASE db version = 6.0.1.1 Active da

6、tabasesdbtool -activedbList of started databases on tomas1o for VERSANT_DB /export/versant/db/:PASDBAMDBSMCSNADBNMSNADBONRM_CSHidden Dbid Optionsdbid E7012: UT_INVALID_PARAMETER: Invalid parameter Usage: dbid options options: -N Create an osc-dbid file. is not specified -c Create an entry in osc-dbi

7、d file for database -C Create an entry in osc-dbid file for database and database id as . -t Specify the type of database ( group or personal ) Must be used with -c or -C options. Default database type is group. -d Remove the database entry from the osc-dbid file -r Print the database id of the data

8、base -noprint Supress display messagesdbname: database nametype: database type 1: personal database 2: group databaseExampledbid C 10 t 2 testBackup/RestoreIs scheduled via the crontab, by default every sunday0 02 * * 0 /opt/ericsson/sck/bin/backup_versant_db.shCalls : ericsson/versant/bin/vrsnt_dbd

9、ump Calls ericsson/versant/bin/db2disk.bash Backup_versant_db.sh# VAR VRSNTDUMP=/export/dbdumps/versant KEEP=14 # days# ENV SCRIPTNAME=basename $0 SCRIPTDIR=cd dirname $0; pwd . $SCRIPTDIR/./lib/syb12.lib . $SCRIPTDIR/./lib/sck_function.lib# Databases to filesystem su - nmsadm -c /ericsson/versant/b

10、in/vrsnt_dbdump -d $VRSNTDUMP/db -l $VRSNTDUMP/log dump all /tmp/backup.$ 2&1 if $? != 0 ; then cat /tmp/backup.$ rm -f /tmp/backup.$ BAILOUT Versant database backup failed fi# Cleanup old databases/logs rm -f /tmp/backup.$ find $VRSNTDUMP -ctime +$KEEP | while read FILE; do $FILE = $VRSNTDUMP & con

11、tinue rm -rf $FILE done# Done exit 0Special Addvol procedureDescription: in Versant 6.0.1 there may be situations, where the database runs out of space and cannot be restarted to add volumesSolution:stopdbcp p logical.log logical.log.backdbtool E dbNameaddvol -n volname -p /PATH/volnameFile dbNamest

12、opdb fcp p logical.log.back logical.logstartdb dbNameNote the option is not available on all releases and must sometimes be replaced with the command .Database Schemapublic abstract class BaseModel protected String _name;public class Department extends BaseModel protected Vector _Employees; = CLASS

13、Department =superclasses: BaseModelattributes: _vj_hashCode : o_4b _name : char _vj_count_Employees : o_4b _vj_serial_Employees : o_1b _vj_increment_Employees : o_4b _Employees - (NULL_DOMAIN)* Total 10 instances of class Department *DatatypesDirectly mapped elemental typesStringintBooleanObject Ref

14、erenceDual Serialized“Vector and oder CollectionsCollection Attribute contains object loidsOutput in db2tty:charo_4bo_1bmConfiguration - (NULL_DOMAIN)Additional Versant Java (VJ) Fields _vj_count_Employees : o_4b _vj_serial_Employees : o_1b _vj_increment_Employees : o_4b _Employees - (NULL_DOMAIN)Ch

15、eck Ref Command (contribution)Usage : vrefcheck.exe -d -cursor-size -cod-threshold -v -fix -y -null -connect . -classes . -loids .Options-d: Database to be checked-cursor-size : Number of objects read per batch (default 2K)-cod-threshold : Threshold limit for COD table (default 1M)-v: Verbose output

16、-fix: Fix inconsistencies, use with caution-y: Fix inconsistencies without asking, use with extreme caution-null: Report NULL references as inconsistencies-connect: Databases that should be checked for referenced objects-classes: Classes to check, if not specified check all classes-loids: Specific o

17、bjects to check, if not specified check all instances of all classesExamplevrefcheck.exe -d vdbExamining class Department Checking instances Instance 924.0.2081 contains an invalid reference 924.0.2167 referenced by attribute _Employees is an invalid (null) object. checked 10 instances, 1 invalid references found in 1 instances.Fixing the instanceJava FixCollection vdb 924.0.2081 _Employees 924.0.2167java FixCollection vdb 924.0.2081 _Employees 924.0.2167Fixed Instance: 924.0.2081 Removed 924.0.2167 from attribute _Employees Jsql - Demo Programjava com.versant.contrib.demo.JDBCDemo vdbConn