Chapter 7: Log and Trace Files

Sample log records

The example in this section shows log records from a server start-up attempt. The example uses the following conventions:

The first six columns of each record are omitted because these columns are virtually identical from record to record.
All of the records are of type LogHeader, except the last, which is of type LogEndHeader.
The line numbers are for the explanations that follow the example. The numbers do not appear in an actual log file.

The sample log file is as follows:

1 --------------------------------
2 DirectConnect 12.6 B
3 Copyright(c)2000, Sybase, Inc.
4 INTEL x386 Windows 4.1 (807)
5 (CRS 85.0) OPT 17-Mar-1997912:00:00
6--------------------------------
7 *** Initial configuration for: [SRVNAME] ***
8 --- MaxConnections = 2
9 --- RemoteSites = 3
10--- DefQueueSize = 1024
11--- CtlibPacketSize = 512
12--- OpenServerTraceFlags = 0
13--- ServiceRedirectionFile = snrf.tbl
14--- Description = The DirectConnect server.
15--- LogFileName = 
16--- LogFileSize = 500000
17--- LogWrap = yes
18--- LogFlush = no
19--- LogToScreen = no
20--- LogClientLogin = yes
21--- LogClientMessages = 0
22--- TraceFileName = 
23--- TraceLogMessages = yes
24--- TraceEntryExit = yes
25--- TraceAsync = yes
26--- TraceOther = yes
27--- TraceToScreen = no
28 Service Name Redirection enabled: C:\SQL10\
DC-12_6\SRVNAME\cfg\snrf.tbl
29*** The following localized message files are \ supported:
30--- C:\SQL10\DC-12_6\SRVNAME\locales\ us_english\cp850\server.loc
31 Loading service library file: C:\SQL10\
DC-12_6\SRVNAME\svclib\shutdown.dll
32***Initial configuration for: [Shutdown] ***
33***Initial configuration for: [shutdown] ***
34--- EnableAtStartup = yes
35 Service loaded: [shutdown]
36*** The following localized message files are \ supported:
37--- C:\SQL10\DC-12_6\SRVNAME\locales\ us_english\cp850\shutdown.loc
38 Successfully initialized service library: \ Shutdown
39 Loading service library file: C:\SQL10\ 
DC-12_6\SRVNAME\svclib\smtest1.dll
40*** Initial configuration for: [smtest1] ***
41---UserExitFileName = userexit
42*** Initial configuration for: [ServiceA] ***
43--- MaxClients = 10
44--- EnableAtStartup = yes
45--- StopCondition = error
46--- MaxRowCount = 1000
47--- LogReceivedSQL = yes
48 Service loaded: [ServiceA]
49 Service loaded: [ServiceB]
50*** The following localized message files are \ supported:
51--- C:\SQL10\DC-12_6\SRVNAME\ locales\us_english\cp850\smtest1.loc
52 Successfully initialized service library: \ smtest1
53 !READY! Waiting for connections.

Following are explanations of the log record entries, by line number:

5: A mnemonic indicates the build or version of the library that was linked with the executable.

7: The server name appears in the brackets.

8-27: The start-up values for the server configuration properties are listed.

19: The system sends log records to the log file but not to the current window.

28: An indication whether service name redirection is to be used, and if so, the path to the file that was loaded.

29-30: The localized message files found for the server and the supported locales are shown.

31, 39: Each access service library module installed in the \DC-12_6\ServerName\svclib subdirectory is loaded in turn.

32: The access service library properties are listed. In this example, the [Shutdown] access service library does not have configurable properties.

33-34: The initial configurations of the enabled access services associated with the access service library are listed. In this example, the [shutdown] access service defines one configuration property: EnableAtStartup.

35: An indication that initialization for the specified access service is complete.

36-37, 50-51: The localized message files found for the associated access service library and the supported locales are listed.

38: An indication that initialization for the specified access service library is complete.

49: In this example, [ServiceB] was loaded but not enabled, nor is it able to receive connections. This is noted by the lack of an initial configuration listing (initial access service configuration is always output when the access service becomes enabled). Because this access service was not enabled at start-up, you can enable it only with DirectConnect Manager tool.

53: An indication that server initialization is complete. Clients can now connect to any enabled access service.

View this book as PDF