EXTOL Business Integrator - Database Compression Utility

EXTOL Business Integrator - Database Compression Utility

TAGS: EXTOL Business Integrator / EXTOL EBI / EXTOL customization / EXTOL Utility /


EXTOL Business Integrator (EBI) provides two utilities for recovering space in the internal database.

One utility would be COMPRESS.

To call COMPRESS (Linux/Windows/iSeries):

  • From command line, type: QSH (iSeries only)
  • Type: “cd /ebi25” – install directory
  • Type: “cd database”
  • Type: “cd utils”
  • Type: “sh compress_db.sh”

Output:

Security manager installed using the Basic server security policy.

Could not listen on port 1527 on host 0.0.0.0:

java.net.BindException: The socket name is already in use.

Script variables:

EBI Home : ../..DB ClassPath : .:../../jboss/server/ebi/lib/derbynet.jar:../../jboss/server/ebi/lib/derby.jar:../../jboss/server/ebi/lib/derbytoo

ls.jar:../../jboss/server/ebi/lib/derbyclient.jar

EBI DataBase : ../../database/

Log file : ../../log/[email protected]:44:48.log

SQL file : compress_db.sql

Command : /QOpenSys/QIBM/ProdData/JavaVM/jdk60/32bit/bin/java -cp .:../../jboss/server/ebi/lib/derbynet.jar:../../jboss/server/ebi/lib/derby.jar:../../jboss/server/ebi/lib/derbytools.jar:../../jboss/server/ebi/lib/derbyclient.jar -Dij.outfile=../logs/[email protected]:44:48.log org.apache.derby.tools.ij compress_db.sql





Copyright 2013 @ www.seanhoppe.com


By: on

A free web counter provided by GoStats.