How to install dbisql on Windows workstation

  • 7023804
  • 02-Apr-2019
  • 14-Jun-2019

Environment

ZENworks Configuration Management 2017 Update 4 Database

Situation

It is sometimes necessary to do a database query for appliance with embedded Sybase.  This TID discusses how to install dbisql to do database queries.

Resolution

  1. Using winscp get these files from /opt/novell/zenworks/install/downloads/msi on primary
    Note: use most current version (this is from 17)
    novell-zenworks-sybase-libs-17.0.0.26419.x86_64.msi
    sybase-asa-17.0.0.26419.x86_64.msi
  2. Copy them to some Windows workstation 64bit set up for the purpose of running DBISQL and install them.
  3. Confirm that you can launch dbisql to connect to the database.
  4. To start dbisql:  Go to c:\asa\bin64 and run dbisql
  5. On primary run this:
    zman dgc
  6. Get the user (zenadmin) and password
  7. In dbisql set the username, password, host and port like the screenshot below (using the password returned from zman above, and the host as your primary server, same port 2638)