Sybase 12.4.2 User Manual
CHAPTER 1 Overview of Adaptive Server IQ System Administration
17
•
Manipulate date and time data (for example,
TODAY
,
DATEDIFF
,
DATEPART
,
MINUTES
)
•
Convert retrieved data from one format to another (
CAST
,
CONVERT
)
Message logging
A message log file exists for each database. The default name of this file is
dbname.iqmsg. The message log file is created when the database is created.
dbname.iqmsg. The message log file is created when the database is created.
By default, Adaptive Server IQ logs all messages in the message log file,
including:
including:
•
Error messages
•
Status messages
•
Insert notification messages
You can examine this file as you would any other text file. At the start of the
file you see output like the following:
file you see output like the following:
2000-03-07 17:20:50 0000 OpenDatabase Completed
2000-03-07 17:20:50 0000 IQ cmd line srv opts:
2000-03-07 17:20:50 0000 DB: r/w, Buffs=1913, Pgsz=4096/512blksz/8bpc
2000-03-07 17:20:50 0000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
2000-03-07 17:20:50 0000 DB: Versn: 12.4.2/(32bit mode)/MS Windows NT 4.0/EBF
0000/Mar 02 2000, 02:17:37 2000-03-07 17:20:50 0000 DB: Name: C:\Program
Files\Sybase\ASIQ12\scripts\asiqdemo.db
The fourth line of the file contains version information:
Figure 1-1: Version string in message log