ASA User's Guide

Home

Running the server outside the current session

ASA User's Guide

Part 1 Working with Databases

Chapter 1: Running the Database Server

Troubleshooting server startup

This section describes some common problems when starting the database server.

Ensure that your transaction log file is valid

The server won't start if the existing transaction log is invalid. For example, during development you may replace a database file with a new version, without deleting the transaction log at the same time. This causes the transaction log file to be different than the database, and results in an invalid transaction log file.

Ensure that you have sufficient disk space for your temporary file

Adaptive Server Anywhere uses a temporary file to store information while running. This file is stored in the directory pointed to by the TMP or TEMP environment variable, typically c:\temp.

If you do not have sufficient disk space available to the temporary directory, you will have problems starting the server.

Ensure that network communication software is running

Appropriate network communication software must be installed and running before you run the database server. If you are running reliable network software with just one network installed, this should be straightforward. If you experience problems, if you are running non-standard software, or if you are running multiple networks, you may want to read the full discussion of network communication issues in Client/Server Communications .

You should confirm that other software requiring network communications is working properly before running the database server.

For example, if you are using NetBIOS under Windows 95, Windows for Workgroups, or Windows NT you may want to confirm that the chat or winpopup application is working properly between machines running client and database server software.

If you are running under the TCP/IP protocol, you may want to confirm that ping and telnet are working properly. The ping and telnet applications are provided with many TCP/IP protocol stacks.

Debugging network communications startup problems

If you are having problems establishing a connection across a network, you can use debugging options at both client and server to diagnose problems. On the server, you use the

-z

command-line option. The startup information appears on the server window: you can use the

-o

option to log the results to an output file.


	Expand Search