sybase12.5-solaris9下网络数据包的问题

a1024k

我用sp_sysmon测试的怀疑又问题的地方
Network Packet Received           0.6           7.5         179      17.0 %
    Network Packet Sent             159.5        1994.0       47857      4553 %
    Other Causes                   -156.8       -1960.6      -47054     -4477 %

我最大数据包设的是2560!max memory = 800多M，cache size = 5百多M速度很慢


急急急急急急！

chenfeng825

不一定是网络问题，large network packet不一定能够带来提升，相反可能开销更多。
可以用default packet size测试同一个应用利用select @@pack_sent的差值看是否用large packet返回的包比较少
具体用sysmon看看，并且检查os的情况

a1024k

谢谢大天使，下面是我改回默认值之后的数据，执行的是和上面相同的查询

Network Packet Received           2.6           7.8         313      19.7 %
    Network Packet Sent             542.8        1628.5       65141      4107 %
    Other Causes                   -533.9       -1601.6      -64062     -4039 %

我这里是1000M光纤->;三层交换机->;100M；

chenfeng825

楼主所说的慢到底是什么情形？怎么确定一定是网络问题？再os端确定的吗？sybase defautl的设定一般可以满足应用需求，如果使用了text或者width column或者返回数据行特别多的情况才能够从larger network packet受益。

给出的这点东西没有意义,给出的是任务切换的各部分开销而已,但最后两项确实有问题,数据库海有别的错误吗?包括os!这里看起来似乎确实是网络问题,

a1024k

谢谢 ：
在select 较大的表的时候读到2，3千条记录时要停顿一下，而且读取速度比pc机上的还慢，建库，备份，恢复以及执行存储过程的时候很快！所以我以为是在网络交换的时候有问题，

我这里是sun480的机器，问sun的人，怀疑是sybase和solaris9兼容的问题！！但是又找不到sybase的补丁

用ftp从服务器上下载的速度在10M左右（应该是正常的）

chenfeng825

应该还不是os和sybase的问题，可能同你的网络硬件有关，看看有没有办法用普通100m switch测试，以前见过因为luncent的三层交换机导致sybase奇慢的现象！
你的sybase的errorlog应该有些错误信息的！

a1024k

这是log,帮我看一下行吗，谢谢
00:00000:00020:2003/12/18 09:39:10.09 server  Configuration file '/export/home/sybase/ASE-12_5/ydgl.cfg' has been written and the previous version has been renamed to '/export/home/sybase/ASE-12_5/ydgl.072'.
00:00000:00020:2003/12/18 09:39:10.09 server  The configuration option 'recovery interval in minutes' has been changed by 'sa' from '5' to '1'.
00:00000:00020:2003/12/18 09:43:20.95 server  Configuration file '/export/home/sybase/ASE-12_5/ydgl.cfg' has been written and the previous version has been renamed to '/export/home/sybase/ASE-12_5/ydgl.073'.
00:00000:00020:2003/12/18 09:43:20.95 server  The configuration option 'disable disk mirroring' has been changed by 'sa' from '0' to '1'.
00:00000:00020:2003/12/18 09:43:21.25 server  Configuration file '/export/home/sybase/ASE-12_5/ydgl.cfg' has been written and the previous version has been renamed to '/export/home/sybase/ASE-12_5/ydgl.074'.
00:00000:00020:2003/12/18 09:43:21.26 server  The configuration option 'disk i/o structures' has been changed by 'sa' from '256' to '8192'.
00:00000:00020:2003/12/18 09:43:21.56 server  Configuration file '/export/home/sybase/ASE-12_5/ydgl.cfg' has been written and the previous version has been renamed to '/export/home/sybase/ASE-12_5/ydgl.075'.
00:00000:00020:2003/12/18 09:43:21.56 server  The configuration option 'enable rep agent threads' has been changed by 'sa' from '0' to '1'.
00:00000:00020:2003/12/18 09:43:21.90 server  Configuration file '/export/home/sybase/ASE-12_5/ydgl.cfg' has been written and the previous version has been renamed to '/export/home/sybase/ASE-12_5/ydgl.076'.
00:00000:00020:2003/12/18 09:43:21.90 server  The configuration option 'number of devices' has been changed by 'sa' from '10' to '200'.
00:00000:00020:2003/12/18 09:43:22.13 server  Configuration file '/export/home/sybase/ASE-12_5/ydgl.cfg' has been written and the previous version has been renamed to '/export/home/sybase/ASE-12_5/ydgl.077'.
00:00000:00020:2003/12/18 09:43:22.13 server  The configuration option 'user log cache size' has been changed by 'sa' from '2048' to '8192'.
00:00000:00023:2003/12/18 09:44:27.97 server  Shutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00023:2003/12/18 09:44:27.97 server  SQL Server shutdown by request.
00:00000:00023:2003/12/18 09:44:27.97 kernel  ueshutdown: exiting
00:00000:00000:2003/12/18 09:44:49.84 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2003/12/18 09:44:49.84 kernel  Max fd 65536 exceeds internal limit of 10000
00:00000:00000:2003/12/18 09:44:49.85 kernel  Using config area from primary master device.
00:00000:00000:2003/12/18 09:44:51.47 kernel  Using 10000 file descriptors.
00:00000:00000:2003/12/18 09:44:51.47 kernel  Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001
00:00000:00000:2003/12/18 09:44:51.47 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2003/12/18 09:44:51.47 kernel  Copyright 1987, 2001
00:00000:00000:2003/12/18 09:44:51.47 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2003/12/18 09:44:51.47 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/18 09:44:51.47 kernel  
00:00000:00000:2003/12/18 09:44:51.47 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/18 09:44:51.47 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/18 09:44:51.47 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2003/12/18 09:44:51.47 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2003/12/18 09:44:51.47 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2003/12/18 09:44:51.47 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/18 09:44:51.47 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/18 09:44:51.47 kernel  Using '/export/home/sybase/ASE-12_5/ydgl.cfg' for configuration information.
00:00000:00000:2003/12/18 09:44:51.47 kernel  Logging ASE messages in file '/export/home/sybase/ASE-12_5/install/ydgl.log'.
00:00000:00000:2003/12/18 09:44:51.52 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2003/12/18 09:44:51.52 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/18 09:44:51.52 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2003/12/18 09:44:51.52 kernel  Network and device connection limit is 9990.
00:00000:00000:2003/12/18 09:44:52.55 server  Number of blocks left for proc headers: 307104.
00:00000:00000:2003/12/18 09:44:53.76 server  Proc header memory allocated 153552 pages for each per engine cache
00:00000:00000:2003/12/18 09:44:54.17 server  Memory allocated for the default data cache cachelet 1: 609596 Kb
00:00000:00000:2003/12/18 09:44:54.36 server  Size of the 8K memory pool: 512000 Kb
00:00000:00000:2003/12/18 09:44:54.40 server  Size of the 2K memory pool: 97596 Kb
00:00000:00000:2003/12/18 09:44:54.40 kernel  Enabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/12/18 09:44:54.40 kernel  Initializing virtual device 0, '/export/home/sybase/master.dat' with dsync 'on'.
00:00000:00000:2003/12/18 09:44:54.40 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/18 09:44:54.40 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/18 09:44:54.40 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/18 09:44:54.40 kernel  engine 0, os pid 22683  online
00:00000:00000:2003/12/18 09:44:54.40 server  No active traceflags
00:00000:00001:2003/12/18 09:44:54.40 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001'.
00:00000:00001:2003/12/18 09:44:54.40 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/SPARC/Solaris 2.8/1/64bit/OPT/Sun Mar 25 08:30:37 2001'
00:00000:00001:2003/12/18 09:44:54.40 server  Opening Master Database ...
00:00000:00001:2003/12/18 09:44:54.42 server  Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/18 09:44:54.42 server  Loaded default Unilib conversion handle.
00:00000:00001:2003/12/18 09:44:54.43 server  Recovering database 'master'.
00:00000:00001:2003/12/18 09:44:54.43 server  Redo pass of recovery has processed 7 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 09:44:54.63 server  Checking external objects.
00:00000:00001:2003/12/18 09:44:54.64 server  Database 'master' is now online.
00:00000:00001:2003/12/18 09:44:54.64 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:44:54.82 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2003/12/18 09:44:54.82 server  server name is 'ydgl'
00:00000:00001:2003/12/18 09:44:54.82 server  Activating disk 'lfyd1'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Initializing virtual device 2, '/ydgla/lfyd1.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:44:54.82 server  Activating disk 'lfyd2'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Initializing virtual device 3, '/ydgla/lfyd2.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:44:54.82 server  Activating disk 'lfydlog'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Initializing virtual device 4, '/ydgla/lfydlog.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:44:54.82 server  Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Initializing virtual device 1, '/export/home/sybase/proc.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:44:54.82 server  Activating disk 'temp_dev'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Initializing virtual device 5, '/ydgla/temp_dev.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:44:54.82 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:44:54.83 server  Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/18 09:44:54.83 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2003/12/18 09:44:55.01 server  Boot Count: 20
00:00000:00001:2003/12/18 09:44:55.01 server  Checking external objects.
00:00000:00001:2003/12/18 09:44:55.01 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:44:55.19 server  Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/18 09:44:55.20 server  Recovering database 'model'.
00:00000:00001:2003/12/18 09:44:55.38 server  Checking external objects.
00:00000:00001:2003/12/18 09:44:55.38 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:44:55.55 server  Database 'model' is now online.
00:00000:00001:2003/12/18 09:44:55.55 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2003/12/18 09:44:55.55 server  0 dump conditions detected at boot time
00:00000:00001:2003/12/18 09:44:55.55 server  Resident Node id: c84886496e9a
00:00000:00001:2003/12/18 09:44:55.56 server  Transaction coordinator initialized.
00:00000:00001:2003/12/18 09:44:55.56 server  Clearing temp db
00:00000:00001:2003/12/18 09:44:55.80 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:44:55.98 server  Database 'tempdb' is now online.
00:00000:00001:2003/12/18 09:44:55.98 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/18 09:44:56.21 server  Checking external objects.
00:00000:00001:2003/12/18 09:44:56.21 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:44:56.39 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2003/12/18 09:44:56.39 kernel  ninit:0: listener type: master
00:00000:00002:2003/12/18 09:44:56.39 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/18 09:44:56.39 kernel  ninit:0: listener raw address: \x00021004c0a800010000000000000000
00:00000:00002:2003/12/18 09:44:56.39 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/18 09:44:56.39 server  Recovering database 'LF_YDGL'.
00:00000:00001:2003/12/18 09:44:56.40 server  Redo pass of recovery has processed 4 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 09:44:56.69 server  Checking external objects.
00:00000:00001:2003/12/18 09:44:56.69 server  The transaction log in the database 'LF_YDGL' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:44:56.87 server  Database 'LF_YDGL' is now online.
00:00000:00001:2003/12/18 09:44:56.87 server  Recovery complete.
00:00000:00001:2003/12/18 09:44:56.87 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2003/12/18 09:44:56.87 server  SQL Server's default sort order is:
00:00000:00001:2003/12/18 09:44:56.87 server          'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/18 09:44:56.87 server  on top of default character set:
00:00000:00001:2003/12/18 09:44:56.87 server          'iso_1' (ID = 1).
00:00000:00001:2003/12/18 09:44:56.87 server  Master device size: 200 megabytes, or 102400 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00009:2003/12/18 09:48:10.18 server  DBCC TRACEON 8399, SPID 9
00:00000:00013:2003/12/18 09:54:30.44 server  Shutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00013:2003/12/18 09:54:30.44 server  SQL Server shutdown by request.
00:00000:00013:2003/12/18 09:54:30.44 kernel  ueshutdown: exiting
00:00000:00000:2003/12/18 09:54:51.34 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2003/12/18 09:54:51.34 kernel  Max fd 65536 exceeds internal limit of 10000
00:00000:00000:2003/12/18 09:54:51.35 kernel  Using config area from primary master device.
00:00000:00000:2003/12/18 09:54:51.36 server  'additional network memory' has been modified from '512' to '0' by the verification routine.
00:00000:00000:2003/12/18 09:54:52.96 kernel  Using 10000 file descriptors.
00:00000:00000:2003/12/18 09:54:52.96 kernel  Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001
00:00000:00000:2003/12/18 09:54:52.96 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2003/12/18 09:54:52.96 kernel  Copyright 1987, 2001
00:00000:00000:2003/12/18 09:54:52.96 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2003/12/18 09:54:52.96 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/18 09:54:52.96 kernel  
00:00000:00000:2003/12/18 09:54:52.96 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/18 09:54:52.96 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/18 09:54:52.96 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2003/12/18 09:54:52.96 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2003/12/18 09:54:52.96 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2003/12/18 09:54:52.96 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/18 09:54:52.96 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/18 09:54:52.96 kernel  Using '/export/home/sybase/ASE-12_5/ydgl.cfg' for configuration information.
00:00000:00000:2003/12/18 09:54:52.96 kernel  Logging ASE messages in file '/export/home/sybase/ASE-12_5/install/ydgl.log'.
00:00000:00000:2003/12/18 09:54:53.01 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2003/12/18 09:54:53.01 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/18 09:54:53.01 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2003/12/18 09:54:53.01 kernel  Network and device connection limit is 9990.
00:00000:00000:2003/12/18 09:54:54.03 server  Number of blocks left for proc headers: 307104.
00:00000:00000:2003/12/18 09:54:55.25 server  Proc header memory allocated 153552 pages for each per engine cache
00:00000:00000:2003/12/18 09:54:55.66 server  Memory allocated for the default data cache cachelet 1: 609596 Kb
00:00000:00000:2003/12/18 09:54:55.85 server  Size of the 8K memory pool: 512000 Kb
00:00000:00000:2003/12/18 09:54:55.89 server  Size of the 2K memory pool: 97596 Kb
00:00000:00000:2003/12/18 09:54:55.89 kernel  Enabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/12/18 09:54:55.89 kernel  Initializing virtual device 0, '/export/home/sybase/master.dat' with dsync 'on'.
00:00000:00000:2003/12/18 09:54:55.89 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/18 09:54:55.89 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/18 09:54:55.89 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/18 09:54:55.89 kernel  engine 0, os pid 24273  online
00:00000:00000:2003/12/18 09:54:55.89 server  No active traceflags
00:00000:00001:2003/12/18 09:54:55.89 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001'.
00:00000:00001:2003/12/18 09:54:55.90 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/SPARC/Solaris 2.8/1/64bit/OPT/Sun Mar 25 08:30:37 2001'
00:00000:00001:2003/12/18 09:54:55.90 server  Opening Master Database ...
00:00000:00001:2003/12/18 09:54:55.91 server  Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/18 09:54:55.91 server  Loaded default Unilib conversion handle.
00:00000:00001:2003/12/18 09:54:55.92 server  Recovering database 'master'.
00:00000:00001:2003/12/18 09:54:55.92 server  Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 09:54:56.14 server  Checking external objects.
00:00000:00001:2003/12/18 09:54:56.15 server  Database 'master' is now online.
00:00000:00001:2003/12/18 09:54:56.15 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:54:56.31 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2003/12/18 09:54:56.32 server  server name is 'ydgl'
00:00000:00001:2003/12/18 09:54:56.32 server  Activating disk 'lfyd1'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Initializing virtual device 2, '/ydgla/lfyd1.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:54:56.32 server  Activating disk 'lfyd2'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Initializing virtual device 3, '/ydgla/lfyd2.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:54:56.32 server  Activating disk 'lfydlog'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Initializing virtual device 4, '/ydgla/lfydlog.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:54:56.32 server  Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Initializing virtual device 1, '/export/home/sybase/proc.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:54:56.32 server  Activating disk 'temp_dev'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Initializing virtual device 5, '/ydgla/temp_dev.dat' with dsync 'on'.
00:00000:00001:2003/12/18 09:54:56.32 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2003/12/18 09:54:56.33 server  Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/18 09:54:56.33 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2003/12/18 09:54:56.51 server  Boot Count: 21
00:00000:00001:2003/12/18 09:54:56.51 server  Checking external objects.
00:00000:00001:2003/12/18 09:54:56.51 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:54:56.69 server  Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/18 09:54:56.70 server  Recovering database 'model'.
00:00000:00001:2003/12/18 09:54:56.88 server  Checking external objects.
00:00000:00001:2003/12/18 09:54:56.88 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:54:57.05 server  Database 'model' is now online.
00:00000:00001:2003/12/18 09:54:57.05 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2003/12/18 09:54:57.05 server  0 dump conditions detected at boot time
00:00000:00001:2003/12/18 09:54:57.05 server  Resident Node id: c84886496e9a
00:00000:00001:2003/12/18 09:54:57.05 server  Transaction coordinator initialized.
00:00000:00001:2003/12/18 09:54:57.05 server  Clearing temp db
00:00000:00001:2003/12/18 09:54:57.34 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:54:57.51 server  Database 'tempdb' is now online.
00:00000:00001:2003/12/18 09:54:57.52 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/18 09:54:57.71 server  Checking external objects.
00:00000:00001:2003/12/18 09:54:57.71 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:54:57.90 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2003/12/18 09:54:57.90 kernel  ninit:0: listener type: master
00:00000:00002:2003/12/18 09:54:57.90 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/18 09:54:57.90 kernel  ninit:0: listener raw address: \x00021004c0a800010000000000000000
00:00000:00002:2003/12/18 09:54:57.90 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/18 09:54:57.90 server  Recovering database 'LF_YDGL'.
00:00000:00001:2003/12/18 09:54:57.91 server  Redo pass of recovery has processed 29 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 09:54:58.32 server  Checking external objects.
00:00000:00001:2003/12/18 09:54:58.32 server  The transaction log in the database 'LF_YDGL' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 09:54:58.50 server  Database 'LF_YDGL' is now online.
00:00000:00001:2003/12/18 09:54:58.50 server  Recovery complete.
00:00000:00001:2003/12/18 09:54:58.50 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2003/12/18 09:54:58.50 server  SQL Server's default sort order is:
00:00000:00001:2003/12/18 09:54:58.50 server          'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/18 09:54:58.50 server  on top of default character set:
00:00000:00001:2003/12/18 09:54:58.50 server          'iso_1' (ID = 1).
00:00000:00001:2003/12/18 09:54:58.50 server  Master device size: 200 megabytes, or 102400 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00009:2003/12/18 10:58:43.90 server  Shutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00009:2003/12/18 10:58:43.90 server  SQL Server shutdown by request.
00:00000:00009:2003/12/18 10:58:43.90 kernel  ueshutdown: exiting
00:00000:00000:2003/12/18 10:59:06.03 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2003/12/18 10:59:06.03 kernel  Max fd 65536 exceeds internal limit of 10000
00:00000:00000:2003/12/18 10:59:06.04 kernel  Using config area from primary master device.
00:00000:00000:2003/12/18 10:59:07.66 kernel  Using 10000 file descriptors.
00:00000:00000:2003/12/18 10:59:07.66 kernel  Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001
00:00000:00000:2003/12/18 10:59:07.66 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2003/12/18 10:59:07.66 kernel  Copyright 1987, 2001
00:00000:00000:2003/12/18 10:59:07.66 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2003/12/18 10:59:07.66 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/18 10:59:07.66 kernel  
00:00000:00000:2003/12/18 10:59:07.66 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/18 10:59:07.66 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/18 10:59:07.66 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2003/12/18 10:59:07.66 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2003/12/18 10:59:07.66 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2003/12/18 10:59:07.66 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/18 10:59:07.66 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/18 10:59:07.66 kernel  Using '/export/home/sybase/ASE-12_5/ydgl.cfg' for configuration information.
00:00000:00000:2003/12/18 10:59:07.66 kernel  Logging ASE messages in file '/export/home/sybase/ASE-12_5/install/ydgl.log'.
00:00000:00000:2003/12/18 10:59:07.71 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2003/12/18 10:59:07.71 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/18 10:59:07.71 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2003/12/18 10:59:07.71 kernel  Network and device connection limit is 9990.
00:00000:00000:2003/12/18 10:59:08.71 server  Number of blocks left for proc headers: 307104.
00:00000:00000:2003/12/18 10:59:09.93 server  Proc header memory allocated 153552 pages for each per engine cache
00:00000:00000:2003/12/18 10:59:10.35 server  Memory allocated for the default data cache cachelet 1: 609596 Kb
00:00000:00000:2003/12/18 10:59:10.53 server  Size of the 8K memory pool: 512000 Kb
00:00000:00000:2003/12/18 10:59:10.57 server  Size of the 2K memory pool: 97596 Kb
00:00000:00000:2003/12/18 10:59:10.57 kernel  Enabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/12/18 10:59:10.57 kernel  Initializing virtual device 0, '/export/home/sybase/master.dat' with dsync 'on'.
00:00000:00000:2003/12/18 10:59:10.57 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/18 10:59:10.57 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/18 10:59:10.57 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/18 10:59:10.57 kernel  engine 0, os pid 4360  online
00:00000:00000:2003/12/18 10:59:10.57 server  No active traceflags
00:00000:00001:2003/12/18 10:59:10.58 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001'.
00:00000:00001:2003/12/18 10:59:10.58 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/SPARC/Solaris 2.8/1/64bit/OPT/Sun Mar 25 08:30:37 2001'
00:00000:00001:2003/12/18 10:59:10.58 server  Opening Master Database ...
00:00000:00001:2003/12/18 10:59:10.60 server  Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/18 10:59:10.60 server  Loaded default Unilib conversion handle.
00:00000:00001:2003/12/18 10:59:10.60 server  Recovering database 'master'.
00:00000:00001:2003/12/18 10:59:10.60 server  Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 10:59:10.79 server  Checking external objects.
00:00000:00001:2003/12/18 10:59:10.79 server  Database 'master' is now online.
00:00000:00001:2003/12/18 10:59:10.79 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 10:59:10.97 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2003/12/18 10:59:10.97 server  server name is 'ydgl'
00:00000:00001:2003/12/18 10:59:10.97 server  Activating disk 'lfyd1'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Initializing virtual device 2, '/ydgla/lfyd1.dat' with dsync 'on'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/18 10:59:10.97 server  Activating disk 'lfyd2'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Initializing virtual device 3, '/ydgla/lfyd2.dat' with dsync 'on'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2003/12/18 10:59:10.97 server  Activating disk 'lfydlog'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Initializing virtual device 4, '/ydgla/lfydlog.dat' with dsync 'on'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2003/12/18 10:59:10.97 server  Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Initializing virtual device 1, '/export/home/sybase/proc.dat' with dsync 'on'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/18 10:59:10.97 server  Activating disk 'temp_dev'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Initializing virtual device 5, '/ydgla/temp_dev.dat' with dsync 'on'.
00:00000:00001:2003/12/18 10:59:10.97 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2003/12/18 10:59:10.98 server  Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/18 10:59:10.98 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2003/12/18 10:59:11.17 server  Boot Count: 22
00:00000:00001:2003/12/18 10:59:11.20 server  Checking external objects.
00:00000:00001:2003/12/18 10:59:11.21 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 10:59:11.38 server  Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/18 10:59:11.39 server  Recovering database 'model'.
00:00000:00001:2003/12/18 10:59:11.57 server  Checking external objects.
00:00000:00001:2003/12/18 10:59:11.57 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 10:59:11.75 server  Database 'model' is now online.
00:00000:00001:2003/12/18 10:59:11.75 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2003/12/18 10:59:11.75 server  0 dump conditions detected at boot time
00:00000:00001:2003/12/18 10:59:11.75 server  Resident Node id: c84886496e9a
00:00000:00001:2003/12/18 10:59:11.75 server  Transaction coordinator initialized.
00:00000:00001:2003/12/18 10:59:11.75 server  Clearing temp db
00:00000:00001:2003/12/18 10:59:12.01 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 10:59:12.24 server  Database 'tempdb' is now online.
00:00000:00001:2003/12/18 10:59:12.25 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/18 10:59:12.45 server  Checking external objects.
00:00000:00001:2003/12/18 10:59:12.45 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 10:59:12.63 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2003/12/18 10:59:12.63 kernel  ninit:0: listener type: master
00:00000:00002:2003/12/18 10:59:12.63 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/18 10:59:12.63 kernel  ninit:0: listener raw address: \x00021004c0a800010000000000000000
00:00000:00002:2003/12/18 10:59:12.63 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/18 10:59:12.64 server  Recovering database 'LF_YDGL'.
00:00000:00001:2003/12/18 10:59:12.93 server  Checking external objects.
00:00000:00001:2003/12/18 10:59:12.93 server  The transaction log in the database 'LF_YDGL' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 10:59:13.11 server  Database 'LF_YDGL' is now online.
00:00000:00001:2003/12/18 10:59:13.11 server  Recovery complete.
00:00000:00001:2003/12/18 10:59:13.11 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2003/12/18 10:59:13.11 server  SQL Server's default sort order is:
00:00000:00001:2003/12/18 10:59:13.11 server          'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/18 10:59:13.11 server  on top of default character set:
00:00000:00001:2003/12/18 10:59:13.11 server          'iso_1' (ID = 1).
00:00000:00001:2003/12/18 10:59:13.11 server  Master device size: 200 megabytes, or 102400 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00008:2003/12/18 11:05:09.03 server  DBCC TRACEON 8399, SPID 8
00:00000:00008:2003/12/18 11:20:06.72 server  DBCC TRACEON 8399, SPID 8
00:00000:00000:2003/12/18 12:25:52.23 kernel  ueshutdown: exiting
00:00000:00000:2003/12/18 12:25:52.23 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2003/12/18 12:29:07.39 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2003/12/18 12:29:07.50 kernel  Max fd 65536 exceeds internal limit of 10000
00:00000:00000:2003/12/18 12:29:07.61 kernel  Using config area from primary master device.
00:00000:00000:2003/12/18 12:29:09.30 kernel  Using 10000 file descriptors.
00:00000:00000:2003/12/18 12:29:09.33 kernel  Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001
00:00000:00000:2003/12/18 12:29:09.33 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2003/12/18 12:29:09.33 kernel  Copyright 1987, 2001
00:00000:00000:2003/12/18 12:29:09.33 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2003/12/18 12:29:09.33 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/18 12:29:09.33 kernel  
00:00000:00000:2003/12/18 12:29:09.33 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/18 12:29:09.33 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/18 12:29:09.33 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2003/12/18 12:29:09.33 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2003/12/18 12:29:09.33 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2003/12/18 12:29:09.33 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/18 12:29:09.33 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/18 12:29:09.33 kernel  Using '/export/home/sybase/ASE-12_5/ydgl.cfg' for configuration information.
00:00000:00000:2003/12/18 12:29:09.33 kernel  Logging ASE messages in file '/export/home/sybase/ASE-12_5/install/ydgl.log'.
00:00000:00000:2003/12/18 12:29:09.60 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2003/12/18 12:29:09.60 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/18 12:29:09.61 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2003/12/18 12:29:09.61 kernel  Network and device connection limit is 9990.
00:00000:00000:2003/12/18 12:29:10.67 server  Number of blocks left for proc headers: 307104.
00:00000:00000:2003/12/18 12:29:11.88 server  Proc header memory allocated 153552 pages for each per engine cache
00:00000:00000:2003/12/18 12:29:12.31 server  Memory allocated for the default data cache cachelet 1: 609596 Kb
00:00000:00000:2003/12/18 12:29:12.50 server  Size of the 8K memory pool: 512000 Kb
00:00000:00000:2003/12/18 12:29:12.54 server  Size of the 2K memory pool: 97596 Kb
00:00000:00000:2003/12/18 12:29:12.54 kernel  Enabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/12/18 12:29:12.54 kernel  Initializing virtual device 0, '/export/home/sybase/master.dat' with dsync 'on'.
00:00000:00000:2003/12/18 12:29:12.54 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/18 12:29:12.54 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/18 12:29:12.55 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/18 12:29:12.55 kernel  engine 0, os pid 407  online
00:00000:00000:2003/12/18 12:29:12.57 server  No active traceflags
00:00000:00001:2003/12/18 12:29:12.62 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001'.
00:00000:00001:2003/12/18 12:29:12.62 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/SPARC/Solaris 2.8/1/64bit/OPT/Sun Mar 25 08:30:37 2001'
00:00000:00001:2003/12/18 12:29:12.62 server  Opening Master Database ...
00:00000:00001:2003/12/18 12:29:12.92 server  Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/18 12:29:12.92 server  Loaded default Unilib conversion handle.
00:00000:00001:2003/12/18 12:29:12.93 server  Recovering database 'master'.
00:00000:00001:2003/12/18 12:29:12.95 server  Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 12:29:13.18 server  Checking external objects.
00:00000:00001:2003/12/18 12:29:13.21 server  Database 'master' is now online.
00:00000:00001:2003/12/18 12:29:13.21 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 12:29:13.39 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2003/12/18 12:29:13.39 server  server name is 'ydgl'
00:00000:00001:2003/12/18 12:29:13.39 server  Activating disk 'lfyd1'.
00:00000:00001:2003/12/18 12:29:13.39 kernel  Initializing virtual device 2, '/ydgla/lfyd1.dat' with dsync 'on'.
00:00000:00001:2003/12/18 12:29:13.40 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/18 12:29:13.40 server  Activating disk 'lfyd2'.
00:00000:00001:2003/12/18 12:29:13.40 kernel  Initializing virtual device 3, '/ydgla/lfyd2.dat' with dsync 'on'.
00:00000:00001:2003/12/18 12:29:13.40 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2003/12/18 12:29:13.40 server  Activating disk 'lfydlog'.
00:00000:00001:2003/12/18 12:29:13.40 kernel  Initializing virtual device 4, '/ydgla/lfydlog.dat' with dsync 'on'.
00:00000:00001:2003/12/18 12:29:13.40 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2003/12/18 12:29:13.40 server  Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/18 12:29:13.40 kernel  Initializing virtual device 1, '/export/home/sybase/proc.dat' with dsync 'on'.
00:00000:00001:2003/12/18 12:29:13.41 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/18 12:29:13.41 server  Activating disk 'temp_dev'.
00:00000:00001:2003/12/18 12:29:13.41 kernel  Initializing virtual device 5, '/ydgla/temp_dev.dat' with dsync 'on'.
00:00000:00001:2003/12/18 12:29:13.41 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2003/12/18 12:29:13.49 server  Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/18 12:29:13.49 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2003/12/18 12:29:13.67 server  Boot Count: 23
00:00000:00001:2003/12/18 12:29:13.68 server  Checking external objects.
00:00000:00001:2003/12/18 12:29:13.68 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 12:29:13.86 server  Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/18 12:29:13.91 server  Recovering database 'model'.
00:00000:00001:2003/12/18 12:29:14.28 server  Checking external objects.
00:00000:00001:2003/12/18 12:29:14.28 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 12:29:14.46 server  Database 'model' is now online.
00:00000:00001:2003/12/18 12:29:14.46 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2003/12/18 12:29:14.46 server  0 dump conditions detected at boot time
00:00000:00001:2003/12/18 12:29:14.46 server  Resident Node id: c84886496e9a
00:00000:00001:2003/12/18 12:29:14.47 server  Transaction coordinator initialized.
00:00000:00001:2003/12/18 12:29:14.48 server  Clearing temp db
00:00000:00001:2003/12/18 12:29:16.21 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 12:29:16.39 server  Database 'tempdb' is now online.
00:00000:00001:2003/12/18 12:29:16.47 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/18 12:29:18.61 server  Checking external objects.
00:00000:00001:2003/12/18 12:29:18.61 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 12:29:18.80 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2003/12/18 12:29:18.81 kernel  ninit:0: listener type: master
00:00000:00002:2003/12/18 12:29:18.81 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/18 12:29:18.81 kernel  ninit:0: listener raw address: \x00021004c0a800010000000000000000
00:00000:00002:2003/12/18 12:29:18.81 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/18 12:29:18.95 server  Recovering database 'LF_YDGL'.
00:00000:00001:2003/12/18 12:29:18.98 server  Redo pass of recovery has processed 4 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 12:29:23.51 server  Checking external objects.
00:00000:00001:2003/12/18 12:29:23.51 server  The transaction log in the database 'LF_YDGL' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 12:29:23.70 server  Database 'LF_YDGL' is now online.
00:00000:00001:2003/12/18 12:29:23.71 server  Recovery complete.
00:00000:00001:2003/12/18 12:29:23.71 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2003/12/18 12:29:23.72 server  SQL Server's default sort order is:
00:00000:00001:2003/12/18 12:29:23.72 server          'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/18 12:29:23.72 server  on top of default character set:
00:00000:00001:2003/12/18 12:29:23.72 server          'iso_1' (ID = 1).
00:00000:00001:2003/12/18 12:29:23.72 server  Master device size: 200 megabytes, or 102400 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00000:2003/12/18 13:07:52.36 kernel  ueshutdown: exiting
00:00000:00000:2003/12/18 13:07:52.36 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2003/12/18 13:11:09.03 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2003/12/18 13:11:09.09 kernel  Max fd 65536 exceeds internal limit of 10000
00:00000:00000:2003/12/18 13:11:09.16 kernel  Using config area from primary master device.
00:00000:00000:2003/12/18 13:11:10.86 kernel  Using 10000 file descriptors.
00:00000:00000:2003/12/18 13:11:10.88 kernel  Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001
00:00000:00000:2003/12/18 13:11:10.88 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2003/12/18 13:11:10.88 kernel  Copyright 1987, 2001
00:00000:00000:2003/12/18 13:11:10.88 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2003/12/18 13:11:10.88 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/18 13:11:10.88 kernel  
00:00000:00000:2003/12/18 13:11:10.88 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/18 13:11:10.88 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/18 13:11:10.88 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2003/12/18 13:11:10.88 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2003/12/18 13:11:10.88 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2003/12/18 13:11:10.88 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/18 13:11:10.88 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/18 13:11:10.88 kernel  Using '/export/home/sybase/ASE-12_5/ydgl.cfg' for configuration information.
00:00000:00000:2003/12/18 13:11:10.88 kernel  Logging ASE messages in file '/export/home/sybase/ASE-12_5/install/ydgl.log'.
00:00000:00000:2003/12/18 13:11:11.09 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2003/12/18 13:11:11.09 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/18 13:11:11.10 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2003/12/18 13:11:11.10 kernel  Network and device connection limit is 9990.
00:00000:00000:2003/12/18 13:11:12.15 server  Number of blocks left for proc headers: 307104.
00:00000:00000:2003/12/18 13:11:13.36 server  Proc header memory allocated 153552 pages for each per engine cache
00:00000:00000:2003/12/18 13:11:13.78 server  Memory allocated for the default data cache cachelet 1: 609596 Kb
00:00000:00000:2003/12/18 13:11:13.97 server  Size of the 8K memory pool: 512000 Kb
00:00000:00000:2003/12/18 13:11:14.01 server  Size of the 2K memory pool: 97596 Kb
00:00000:00000:2003/12/18 13:11:14.02 kernel  Enabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/12/18 13:11:14.02 kernel  Initializing virtual device 0, '/export/home/sybase/master.dat' with dsync 'on'.
00:00000:00000:2003/12/18 13:11:14.02 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/18 13:11:14.02 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/18 13:11:14.03 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/18 13:11:14.03 kernel  engine 0, os pid 407  online
00:00000:00000:2003/12/18 13:11:14.05 server  No active traceflags
00:00000:00001:2003/12/18 13:11:14.09 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001'.
00:00000:00001:2003/12/18 13:11:14.09 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/SPARC/Solaris 2.8/1/64bit/OPT/Sun Mar 25 08:30:37 2001'
00:00000:00001:2003/12/18 13:11:14.09 server  Opening Master Database ...
00:00000:00001:2003/12/18 13:11:14.34 server  Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/18 13:11:14.34 server  Loaded default Unilib conversion handle.
00:00000:00001:2003/12/18 13:11:14.35 server  Recovering database 'master'.
00:00000:00001:2003/12/18 13:11:14.37 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 13:11:14.60 server  Checking external objects.
00:00000:00001:2003/12/18 13:11:14.62 server  Database 'master' is now online.
00:00000:00001:2003/12/18 13:11:14.62 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:11:14.79 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2003/12/18 13:11:14.80 server  server name is 'ydgl'
00:00000:00001:2003/12/18 13:11:14.80 server  Activating disk 'lfyd1'.
00:00000:00001:2003/12/18 13:11:14.80 kernel  Initializing virtual device 2, '/ydgla/lfyd1.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:11:14.81 server  Activating disk 'lfyd2'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Initializing virtual device 3, '/ydgla/lfyd2.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:11:14.81 server  Activating disk 'lfydlog'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Initializing virtual device 4, '/ydgla/lfydlog.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:11:14.81 server  Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Initializing virtual device 1, '/export/home/sybase/proc.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:11:14.81 server  Activating disk 'temp_dev'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Initializing virtual device 5, '/ydgla/temp_dev.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:11:14.81 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:11:14.89 server  Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/18 13:11:14.90 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2003/12/18 13:11:15.08 server  Boot Count: 24
00:00000:00001:2003/12/18 13:11:15.10 server  Checking external objects.
00:00000:00001:2003/12/18 13:11:15.10 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:11:15.28 server  Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/18 13:11:15.32 server  Recovering database 'model'.
00:00000:00001:2003/12/18 13:11:15.51 server  Checking external objects.
00:00000:00001:2003/12/18 13:11:15.51 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:11:15.69 server  Database 'model' is now online.
00:00000:00001:2003/12/18 13:11:15.69 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2003/12/18 13:11:15.69 server  0 dump conditions detected at boot time
00:00000:00001:2003/12/18 13:11:15.69 server  Resident Node id: c84886496e9a
00:00000:00001:2003/12/18 13:11:15.70 server  Transaction coordinator initialized.
00:00000:00001:2003/12/18 13:11:15.70 server  Clearing temp db
00:00000:00001:2003/12/18 13:11:17.30 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:11:17.47 server  Database 'tempdb' is now online.
00:00000:00001:2003/12/18 13:11:17.54 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/18 13:11:20.62 server  Checking external objects.
00:00000:00001:2003/12/18 13:11:20.62 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:11:20.81 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2003/12/18 13:11:20.82 kernel  ninit:0: listener type: master
00:00000:00002:2003/12/18 13:11:20.82 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/18 13:11:20.82 kernel  ninit:0: listener raw address: \x00021004c0a800010000000000000000
00:00000:00002:2003/12/18 13:11:20.82 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/18 13:11:20.90 server  Recovering database 'LF_YDGL'.
00:00000:00001:2003/12/18 13:11:24.44 server  Checking external objects.
00:00000:00001:2003/12/18 13:11:24.44 server  The transaction log in the database 'LF_YDGL' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:11:24.63 server  Database 'LF_YDGL' is now online.
00:00000:00001:2003/12/18 13:11:24.64 server  Recovery complete.
00:00000:00001:2003/12/18 13:11:24.64 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2003/12/18 13:11:24.64 server  SQL Server's default sort order is:
00:00000:00001:2003/12/18 13:11:24.64 server          'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/18 13:11:24.64 server  on top of default character set:
00:00000:00001:2003/12/18 13:11:24.64 server          'iso_1' (ID = 1).
00:00000:00001:2003/12/18 13:11:24.64 server  Master device size: 200 megabytes, or 102400 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00000:2003/12/18 13:39:14.57 kernel  ueshutdown: exiting
00:00000:00000:2003/12/18 13:39:14.57 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2003/12/18 13:42:31.64 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2003/12/18 13:42:31.70 kernel  Max fd 65536 exceeds internal limit of 10000
00:00000:00000:2003/12/18 13:42:31.77 kernel  Using config area from primary master device.
00:00000:00000:2003/12/18 13:42:33.48 kernel  Using 10000 file descriptors.
00:00000:00000:2003/12/18 13:42:33.50 kernel  Adaptive Server Enterprise/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001
00:00000:00000:2003/12/18 13:42:33.50 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2003/12/18 13:42:33.50 kernel  Copyright 1987, 2001
00:00000:00000:2003/12/18 13:42:33.50 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2003/12/18 13:42:33.50 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2003/12/18 13:42:33.50 kernel  
00:00000:00000:2003/12/18 13:42:33.50 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2003/12/18 13:42:33.50 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2003/12/18 13:42:33.50 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2003/12/18 13:42:33.50 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2003/12/18 13:42:33.50 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2003/12/18 13:42:33.50 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2003/12/18 13:42:33.50 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2003/12/18 13:42:33.50 kernel  Using '/export/home/sybase/ASE-12_5/ydgl.cfg' for configuration information.
00:00000:00000:2003/12/18 13:42:33.50 kernel  Logging ASE messages in file '/export/home/sybase/ASE-12_5/install/ydgl.log'.
00:00000:00000:2003/12/18 13:42:33.71 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2003/12/18 13:42:33.71 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2003/12/18 13:42:33.72 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2003/12/18 13:42:33.72 kernel  Network and device connection limit is 9990.
00:00000:00000:2003/12/18 13:42:34.78 server  Number of blocks left for proc headers: 307104.
00:00000:00000:2003/12/18 13:42:35.98 server  Proc header memory allocated 153552 pages for each per engine cache
00:00000:00000:2003/12/18 13:42:36.42 server  Memory allocated for the default data cache cachelet 1: 609596 Kb
00:00000:00000:2003/12/18 13:42:36.61 server  Size of the 8K memory pool: 512000 Kb
00:00000:00000:2003/12/18 13:42:36.65 server  Size of the 2K memory pool: 97596 Kb
00:00000:00000:2003/12/18 13:42:36.65 kernel  Enabling Sun Kernel asynchronous disk I/O strategy
00:00000:00000:2003/12/18 13:42:36.65 kernel  Initializing virtual device 0, '/export/home/sybase/master.dat' with dsync 'on'.
00:00000:00000:2003/12/18 13:42:36.65 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2003/12/18 13:42:36.66 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2003/12/18 13:42:36.66 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2003/12/18 13:42:36.66 kernel  engine 0, os pid 407  online
00:00000:00000:2003/12/18 13:42:36.69 server  No active traceflags
00:00000:00001:2003/12/18 13:42:36.72 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9610 GA/P/Sun_svr4/OS 5.8/main/1647/64-bit/FBO/Sat Jun  2 01:55:25 2001'.
00:00000:00001:2003/12/18 13:42:36.72 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/SPARC/Solaris 2.8/1/64bit/OPT/Sun Mar 25 08:30:37 2001'
00:00000:00001:2003/12/18 13:42:36.73 server  Opening Master Database ...
00:00000:00001:2003/12/18 13:42:37.05 server  Loading SQL Server's default sort order and character set
00:00000:00001:2003/12/18 13:42:37.05 server  Loaded default Unilib conversion handle.
00:00000:00001:2003/12/18 13:42:37.06 server  Recovering database 'master'.
00:00000:00001:2003/12/18 13:42:37.10 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2003/12/18 13:42:37.34 server  Checking external objects.
00:00000:00001:2003/12/18 13:42:37.36 server  Database 'master' is now online.
00:00000:00001:2003/12/18 13:42:37.36 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:42:37.53 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2003/12/18 13:42:37.57 server  server name is 'ydgl'
00:00000:00001:2003/12/18 13:42:37.58 server  Activating disk 'lfyd1'.
00:00000:00001:2003/12/18 13:42:37.58 kernel  Initializing virtual device 2, '/ydgla/lfyd1.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:42:37.60 server  Activating disk 'lfyd2'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Initializing virtual device 3, '/ydgla/lfyd2.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:42:37.60 server  Activating disk 'lfydlog'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Initializing virtual device 4, '/ydgla/lfydlog.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:42:37.60 server  Activating disk 'sysprocsdev'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Initializing virtual device 1, '/export/home/sybase/proc.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:42:37.60 server  Activating disk 'temp_dev'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Initializing virtual device 5, '/ydgla/temp_dev.dat' with dsync 'on'.
00:00000:00001:2003/12/18 13:42:37.60 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2003/12/18 13:42:37.66 server  Recovering database 'sybsystemdb'.
00:00000:00001:2003/12/18 13:42:37.66 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2003/12/18 13:42:37.85 server  Boot Count: 25
00:00000:00001:2003/12/18 13:42:37.86 server  Checking external objects.
00:00000:00001:2003/12/18 13:42:37.87 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:42:38.05 server  Database 'sybsystemdb' is now online.
00:00000:00001:2003/12/18 13:42:38.08 server  Recovering database 'model'.
00:00000:00001:2003/12/18 13:42:38.27 server  Checking external objects.
00:00000:00001:2003/12/18 13:42:38.27 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:42:38.45 server  Database 'model' is now online.
00:00000:00001:2003/12/18 13:42:38.45 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2003/12/18 13:42:38.45 server  0 dump conditions detected at boot time
00:00000:00001:2003/12/18 13:42:38.45 server  Resident Node id: c84886496e9a
00:00000:00001:2003/12/18 13:42:38.46 server  Transaction coordinator initialized.
00:00000:00001:2003/12/18 13:42:38.47 server  Clearing temp db
00:00000:00001:2003/12/18 13:42:40.30 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:42:40.48 server  Database 'tempdb' is now online.
00:00000:00001:2003/12/18 13:42:40.55 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2003/12/18 13:42:42.38 server  Checking external objects.
00:00000:00001:2003/12/18 13:42:42.38 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:42:42.59 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2003/12/18 13:42:42.60 kernel  ninit:0: listener type: master
00:00000:00002:2003/12/18 13:42:42.60 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2003/12/18 13:42:42.60 kernel  ninit:0: listener raw address: \x00021004c0a800010000000000000000
00:00000:00002:2003/12/18 13:42:42.60 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2003/12/18 13:42:42.71 server  Recovering database 'LF_YDGL'.
00:00000:00001:2003/12/18 13:42:47.13 server  Checking external objects.
00:00000:00001:2003/12/18 13:42:47.13 server  The transaction log in the database 'LF_YDGL' will use I/O size of 2 Kb.
00:00000:00001:2003/12/18 13:42:47.32 server  Database 'LF_YDGL' is now online.
00:00000:00001:2003/12/18 13:42:47.33 server  Recovery complete.
00:00000:00001:2003/12/18 13:42:47.33 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2003/12/18 13:42:47.33 server  SQL Server's default sort order is:
00:00000:00001:2003/12/18 13:42:47.33 server          'bin_iso_1' (ID = 50)
00:00000:00001:2003/12/18 13:42:47.33 server  on top of default character set:
00:00000:00001:2003/12/18 13:42:47.33 server          'iso_1' (ID = 1).
00:00000:00001:2003/12/18 13:42:47.33 server  Master device size: 200 megabytes, or 102400 virtual pages. (A virtual page is 2048 bytes.)

a1024k

##############################################################################
#
#                Configuration File for the Sybase SQL Server
#
#                Please read the System Administration Guide (SAG)
#                before changing any of the values in this file.
#
##############################################################################



[Configuration Options]

[General Information]

[Backup/Recovery]
        recovery interval in minutes = 1
        print recovery information = DEFAULT
        tape retention in days = DEFAULT

[Cache Manager]
        number of oam trips = DEFAULT
        number of index trips = DEFAULT
        memory alignment boundary = DEFAULT
        global async prefetch limit = DEFAULT
        global cache partition number = DEFAULT

[Named Cache:default data cache]
        cache size = 609597
        cache status = default data cache
        cache replacement policy = DEFAULT
        local cache partition number = DEFAULT

[8K I/O Buffer Pool]
        pool size = 512000
        wash size = DEFAULT
        local async prefetch limit = DEFAULT

[Meta-Data Caches]
        number of open databases = DEFAULT
        number of open objects = DEFAULT
        open object spinlock ratio = DEFAULT
        number of open indexes = DEFAULT
        open index hash spinlock ratio = DEFAULT
        open index spinlock ratio = DEFAULT
        partition groups = DEFAULT
        partition spinlock ratio = DEFAULT

[Disk I/O]
        disk i/o structures = DEFAULT
        number of large i/o buffers = DEFAULT
        page utilization percent = DEFAULT
        number of devices = DEFAULT
        disable disk mirroring = DEFAULT
        allow sql server async i/o = DEFAULT

[Languages]
        disable character set conversions = DEFAULT

[Unicode]
        enable unicode normalization = DEFAULT
        enable surrogate processing = DEFAULT
        enable unicode conversions = DEFAULT
        size of unilib cache = DEFAULT

[Network Communication]
        default network packet size = DEFAULT
        max network packet size = DEFAULT
        remote server pre-read packets = DEFAULT
        number of remote connections = DEFAULT
        number of remote logins = DEFAULT
        number of remote sites = DEFAULT
        max number network listeners = DEFAULT
        tcp no delay = DEFAULT
        allow sendmsg = DEFAULT
        syb_sendmsg port number = DEFAULT
        allow remote access = DEFAULT

[O/S Resources]
        max async i/os per engine = DEFAULT
        max async i/os per server = DEFAULT

[Parallel Query]
        number of worker processes = DEFAULT
        memory per worker process = DEFAULT
        max parallel degree = DEFAULT
        max scan parallel degree = DEFAULT

[Physical Resources]

[Physical Memory]
        max memory = 829200
        additional network memory =DEFAULT
        shared memory starting address = DEFAULT
        allocate max shared memory = DEFAULT
        dynamic allocation on demand = DEFAULT
        lock shared memory = DEFAULT
        heap memory per user = DEFAULT

[Processors]
        max online engines = DEFAULT
        number of engines at startup = DEFAULT

[SQL Server Administration]
        procedure cache size = 307200
        default database size = DEFAULT
        identity burning set factor = DEFAULT
        allow nested triggers = DEFAULT
        allow updates to system tables = DEFAULT
        default fill factor percent = DEFAULT
        default exp_row_size percent = DEFAULT
        number of mailboxes = DEFAULT
        number of messages = DEFAULT
        number of alarms = DEFAULT
        number of pre-allocated extents = DEFAULT
        event buffers per engine = DEFAULT
        cpu accounting flush interval = DEFAULT
        i/o accounting flush interval = DEFAULT
        sql server clock tick length = DEFAULT
        runnable process search count = DEFAULT
        i/o polling process count = DEFAULT
        time slice = DEFAULT
        cpu grace time = DEFAULT
        number of sort buffers = DEFAULT
        size of auto identity column = DEFAULT
        identity grab size = DEFAULT
        housekeeper free write percent = DEFAULT
        enable housekeeper GC = DEFAULT
        allow resource limits = DEFAULT
        number of aux scan descriptors = DEFAULT
        SQL Perfmon Integration = DEFAULT
        allow backward scans = DEFAULT
        license information = DEFAULT
        enable sort-merge join and JTC = DEFAULT
        abstract plan load = DEFAULT
        abstract plan dump = DEFAULT
        abstract plan replace = DEFAULT
        abstract plan cache = DEFAULT
        text prefetch size = DEFAULT
        enable HA = DEFAULT

[User Environment]
        number of user connections = DEFAULT
        stack size = DEFAULT
        stack guard size = DEFAULT
        permission cache entries = DEFAULT
        user log cache size = DEFAULT
        user log cache spinlock ratio = DEFAULT

[Lock Manager]
        number of locks = DEFAULT
        deadlock checking period = DEFAULT
        lock spinlock ratio = DEFAULT
        lock address spinlock ratio = DEFAULT
        lock table spinlock ratio = DEFAULT
        lock hashtable size = DEFAULT
        lock scheme = DEFAULT
        lock wait period = DEFAULT
        read committed with lock = DEFAULT
        print deadlock information = DEFAULT
        deadlock retries = DEFAULT
        page lock promotion HWM = DEFAULT
        page lock promotion LWM = DEFAULT
        page lock promotion PCT = DEFAULT
        row lock promotion HWM = DEFAULT
        row lock promotion LWM = DEFAULT
        row lock promotion PCT = DEFAULT

[Security Related]
        systemwide password expiration = DEFAULT
        audit queue size = DEFAULT
        curread change w/ open cursors = DEFAULT
        allow procedure grouping = DEFAULT
        select on syscomments.text = DEFAULT
        auditing = DEFAULT
        current audit table = DEFAULT
        suspend audit when device full = DEFAULT
        enable row level access = DEFAULT
        check password for digit = DEFAULT
        minimum password length = DEFAULT
        maximum failed logins = DEFAULT
        enable ssl = DEFAULT
        unified login required = DEFAULT
        use security services = DEFAULT
        msg confidentiality reqd = DEFAULT
        msg integrity reqd = DEFAULT
        secure default login = DEFAULT

[Extended Stored Procedure]
        esp unload dll = DEFAULT
        esp execution priority = DEFAULT
        esp execution stacksize = DEFAULT
        xp_cmdshell context = DEFAULT
        start mail session = DEFAULT

[Error Log]
        event logging = DEFAULT
        log audit logon success = DEFAULT
        log audit logon failure = DEFAULT
        event log computer name = DEFAULT

[Rep Agent Thread Administration]
        enable rep agent threads = DEFAULT

[Component Integration Services]
        enable cis = DEFAULT
        cis connect timeout = DEFAULT
        cis bulk insert batch size = DEFAULT
        max cis remote connections = DEFAULT
        cis packet size = DEFAULT
        cis cursor rows = DEFAULT
        enable file access = DEFAULT
        cis bulk insert array size = DEFAULT
        enable full-text search = DEFAULT
        cis rpc handling = DEFAULT

[Java Services]
        enable java = DEFAULT
        size of process object heap = DEFAULT
        size of shared class heap = DEFAULT
        size of global fixed heap = DEFAULT
        number of java sockets = DEFAULT
        enable enterprise java beans = DEFAULT

[DTM Administration]
        enable DTM = DEFAULT
        enable xact coordination = DEFAULT
        xact coordination interval = DEFAULT
        number of dtx participants = DEFAULT
        strict dtm enforcement = DEFAULT
        txn to pss ratio = DEFAULT
        dtm lock timeout period = DEFAULT
        dtm detach timeout period = DEFAULT

[Diagnostics]
        dump on conditions = DEFAULT
        maximum dump conditions = DEFAULT
        number of ccbs = DEFAULT
        caps per ccb = DEFAULT
        average cap size = DEFAULT

[Monitoring]
        enable monitoring = DEFAULT
        sql text pipe active = DEFAULT
        sql text pipe max messages = DEFAULT
        plan text pipe active = DEFAULT
        plan text pipe max messages = DEFAULT
        statement pipe active = DEFAULT
        statement pipe max messages = DEFAULT
        errorlog pipe active = DEFAULT
        errorlog pipe max messages = DEFAULT
        deadlock pipe active = DEFAULT
        deadlock pipe max messages = DEFAULT
        wait event timing = DEFAULT
        process wait events = DEFAULT
        object lockwait timing = DEFAULT
        SQL batch capture = DEFAULT
        statement statistics active = DEFAULT
        per object statistics active = DEFAULT
        max SQL text monitored = DEFAULT

chenfeng825

没有问题，有几个地方最好改善：
1。 kernel Max fd 65536 exceeds internal limit of 10000
2.default data cache的8k pool 相对2k来说是否过大
3.没有打sybase 任何ebf，什么问题都可能发生

a1024k

哦，非常感谢