用ftp从服务器上下载的速度在10M左右(应该是正常的)作者: chenfeng825 时间: 2003-12-18 13:59 标题: sybase12.5-solaris9下网络数据包的问题 应该还不是os和sybase的问题,可能同你的网络硬件有关,看看有没有办法用普通100m switch测试,以前见过因为luncent的三层交换机导致sybase奇慢的现象!
你的sybase的errorlog应该有些错误信息的!作者: a1024k 时间: 2003-12-18 14:33 标题: sybase12.5-solaris9下网络数据包的问题 这是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 时间: 2003-12-18 14:44 标题: sybase12.5-solaris9下网络数据包的问题 ##############################################################################
#
# 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
[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
[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 时间: 2003-12-18 14:54 标题: sybase12.5-solaris9下网络数据包的问题 没有问题,有几个地方最好改善:
1。 kernel Max fd 65536 exceeds internal limit of 10000
2.default data cache的8k pool 相对2k来说是否过大
3.没有打sybase 任何ebf,什么问题都可能发生作者: a1024k 时间: 2003-12-18 14:59 标题: sybase12.5-solaris9下网络数据包的问题 哦,非常感谢