我可以提供的资料
1. 部分源程序(VB)
AdoConn.Open ConnectString
On Error GoTo OdbcRstErr
'建立记录值
AdoRst.Open Sql, AdoConn, adOpenForwardOnly, adLockReadOnly, adCmdText
If AdoRst.EOF Then
'记录不存在 产生空文件
Open RunInput(7) For Append As #1
Close #1
OdbcCode = -308
Else
'循环读取记录,并写入文件中
Open RunInput(7) For Output As #1
LineNum = 0
Do Until AdoRst.EOF
WriteLine = ""
FieldsNum = 0
For FieldsNum = 0 To AdoRst.Fields.Count - 1
If VarType(AdoRst.Fields(FieldsNum).Value) = vbString Then
FieldContent = Trim(AdoRst.Fields(FieldsNum).Value)
Else
FieldContent = AdoRst.Fields(FieldsNum).Value
End If
If FieldsNum < AdoRst.Fields.Count - 1 Then
If RunInput( = "" Or Trim(RunInput() = 0 Then
WriteLine = WriteLine & FieldContent
Else
WriteLine = WriteLine & FieldContent & ","
End If
Else
WriteLine = WriteLine & FieldContent
End If
Next FieldsNum
Print #1, WriteLine
AdoRst.MoveNext
Loop
Close #1
End If
AdoRst.Close
Set AdoRst = Nothing
AdoConn.Close
Set AdoConn = Nothing
[Backup/Recovery]
recovery interval in minutes = 10
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 = 6000M
cache status = default data cache
cache replacement policy = relaxed LRU replacement
local cache partition number = 8
[4K I/O Buffer Pool]
pool size = 800.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[8K I/O Buffer Pool]
pool size = 200.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[16K I/O Buffer Pool]
pool size = 200.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cache:infocar_cache]
cache size = 300M
cache status = mixed cache
cache replacement policy = relaxed LRU replacement
local cache partition number = DEFAULT
[4K I/O Buffer Pool]
pool size = 100.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cache:jjkxxb_cache]
cache size = 500M
cache status = mixed cache
cache replacement policy = relaxed LRU replacement
local cache partition number = 8
[4K I/O Buffer Pool]
pool size = 100.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cache:rie_cache]
cache size = 500M
cache status = mixed cache
cache replacement policy = relaxed LRU replacement
local cache partition number = 8
[4K I/O Buffer Pool]
pool size = 100.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cacheykxxb_cache]
cache size = 500M
cache status = mixed cache
cache replacement policy = relaxed LRU replacement
local cache partition number = 8
[4K I/O Buffer Pool]
pool size = 100.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Meta-Data Caches]
number of open databases = DEFAULT
number of open objects = 1000
open object spinlock ratio = DEFAULT
number of open indexes = 1000
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 = 2048
number of large i/o buffers = 16
page utilization percent = DEFAULT
number of devices = 30
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 = 8192
remote server pre-read packets = DEFAULT
number of remote connections = 60
number of remote logins = 50
number of remote sites = 50
max number network listeners = 80
tcp no delay = 1
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 = 200
memory per worker process = 4096
max parallel degree = 3
max scan parallel degree = 3
[Physical Resources]
[Physical Memory]
max memory = 6291456
additional network memory = 2457600
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 = 8
number of engines at startup = 8
[SQL Server Administration]
procedure cache size = 500000
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 = 16
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 = 4000
i/o polling process count = 30
time slice = 500
cpu grace time = DEFAULT
number of sort buffers = DEFAULT
size of auto identity column = DEFAULT
identity grab size = DEFAULT
housekeeper free write percent = 4
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
number of histogram steps = DEFAULT
[User Environment]
number of user connections = 200
stack size = 147456
stack guard size = 8192
permission cache entries = DEFAULT
user log cache size = 4096
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
请问各位高手,是什么原因产生这中错误的,以及如何解决这个错误 谢谢了作者: szpbest1 时间: 2003-06-15 21:47 标题: 系统日志中发现错误,请问如何解决 请问:number of worker processes = 200
max online engines = 8
这两者见没有什么联系吗?这两个参数根据什么来设定?作者: 常笑 时间: 2003-06-15 22:58 标题: 系统日志中发现错误,请问如何解决 怎么说呢?应该说是没关系吧!
number of worker processes 为允许同时并发的进程数,和内存的使用有关
,过小会影响并发,过大可能会浪费内存!
max online engines 为分配给sybase的cpu数, 也是和性能有关作者: yhp 时间: 2003-06-16 09:16 标题: 系统日志中发现错误,请问如何解决 up 一下 大家帮我检查一下吧 急啊!谢谢了作者: 小无赖 时间: 2003-06-16 10:23 标题: 系统日志中发现错误,请问如何解决 number of worker processes = 200 需要这么大吗?我不太明白,谁能给讲讲?作者: yhp 时间: 2003-06-16 11:05 标题: 系统日志中发现错误,请问如何解决 继续up