Running the Pack Tool Utility

As part of a regular administrative procedure, run the Pack Tool utility to defragment and reclaim unused space within tables and memo files that the Advantage Database Server® (ADS) data file uses. This will ensure that Unwired Server continues to run in the proper state.

Prerequisites

Contact Technical Support for the latest version of the packtool.exe utility. You need the packtool.exe utility for Sybase Unwired Platform 2.1 ESD#2 or later.

Ensure that you have sufficient free disk space for the packing process. The free disk space must be at least the size of the largest table.
  • Single node installations – check in UnwiredPlatform_InstallDir\UnwiredPlatform\Servers\MessagingServer\Data\OBR
  • Cluster installations – check in UnwiredPlatform_InstallDir\UnwiredPlatform\Data\Messaging\OBR
You need to look for the largest table, including the sum of all three table files with the extensions .adt, .adi, and .adm. Not all tables have corresponding .adi and .adm files.
Task
  1. Stop all Sybase Unwired Platform services including the Advantage Database Server service.
    In a clustered installation, make sure services on all the nodes are stopped.
  2. Back up your ADS database files (all the files in the OBR folder).
  3. Start the Advantage Database Server service only.
    All Sybase Unwired Platform services except Advantage Database Server service must remain stopped until the pack is complete.
  4. Open a command prompt window.
    If this is a cluster installation, do this in any of the application server nodes.

    If you are running Vista, Windows 7, or Windows 2008, make sure you run the command prompt as the Administrator.

  5. Navigate to UnwiredPlatform_InstallDir\UnwiredPlatform\Servers\MessagingServer\Bin.
  6. Run packtool.exe, with no arguments.
After running packtool.exe, a new log file is created in UnwiredPlatform_InstallDir\UnwiredPlatform\Servers\MessagingServer\Bin in the format yyyyMMddTHHmmssPackTable.log.