Sybase官方技术专家CU在线答疑时间表(每周三下午)

readnie

请问我安装的数据库怎么在重启动后就无法启动
具体问题如下
首先是关于备份库的问题：在安装配置好数据库后备份的库服务老是自动当！后来在网上找到了能让备份后台运行不掉的方法。但是我现在就是想知道为什么会自动当！！
其次是：我安装好库都能运行，我在用sybase central更改共享内存后没有重启动数据库服务。过了一段时间应用就不能使用。再去把服务停了再起就提示内存不能共享？？？服务没有办法起来？？？
关于第二个问题我后面会把日志贴出来
请问有没有遇到此类的问题 又是怎么解决的！谢谢！在线等待大家帮忙中！！

dw0620

我有一张表，每次服务重启之后都要做一次：reorg rebuild不然速度特别慢。请问怎么解决

holy_sky

我建了个4G的设备，添加的数据库后，就无法备份了，请问怎么解决。

sesame2

SYBASE 对临时表表名是如何管理的？

有一个存储过程，在该存储过程中建立一个临时表，往临时表插入数据；
在应用中使用多线程同时调用存储过程，
插入的这些数据是放在不同的临时表，还是同一个临时表？
从临时表中查询数据时，只能查到自己线程插入的数据，还是能够查询到所有线程插入的数据？

sesame2

SYBASE也就这样了,还专家在线答疑呢

活动取消了就在这吼一声,不要放不下面子.

7403jeff

安装的suse9.0的版本
操作系统正常安装
但是在建立sybase服务的时候出错了，具体如下：

sybase@HBBK2:~/rs> srvbuildres -r sql.rs
The attribute 'product' must be set to 'sqlsrv', 'msrv', 'bsrv', 'xp', or 'txtsrv'.
The attribute 'new_config' must be set to 'yes' in order to build the server.
The attribute 'do_upgrade' must be set to 'no' in order to build the server.
does not exist in the 'interfaces' file.

但是我打开 sql.rs看没有问题啊，如下：

sybase@HBBK2:~/rs> more sql.rs
sybinit.release_directory: /home/sybase
sybinit.product: sqlsrv
sqlsrv.server_name: server
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: HBBK2
sqlsrv.network_port_list: 5000
sqlsrv.server_page_size: USE_DEFAULT
sqlsrv.force_buildmaster: yes
sqlsrv.master_device_physical_name: /dev/raw/raw1
sqlsrv.master_device_size: 256
sqlsrv.master_database_size: 120
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade:no
sqlsrv.sybsystemprocs_device_physical_name: /dev/raw/raw2
sqlsrv.sybsystemprocs_device_size: 512
sqlsrv.sybsystemprocs_database_size: 510
sqlsrv.default_backup_server: server_bk

请问这是什么缘故啊？哪里出问题啦？

cndong

00:00000:00108:2007/12/12 08:43:27.90 kernel  Cannot read, host process disconnected:  4076 spid: 108
00:00000:00049:2007/12/12 09:07:00.77 kernel  Cannot read, host process disconnected:  3676 spid: 49
00:00000:00049:2007/12/12 09:09:16.50 kernel  Cannot read, host process disconnected:  1504 spid: 49
00:00000:00104:2007/12/12 09:09:16.50 kernel  Cannot read, host process disconnected:  1504 spid: 104
00:00000:00069:2007/12/12 09:09:16.50 kernel  Cannot read, host process disconnected:  1504 spid: 69
00:00000:00055:2007/12/12 09:21:18.48 kernel  Cannot read, host process disconnected:  -129745 spid: 55
00:00000:00074:2007/12/12 09:36:11.18 kernel  Cannot read, host process disconnected:  1528 spid: 74
00:00000:00165:2007/12/12 09:38:20.96 kernel  Cannot read, host process disconnected:  3688 spid: 165
00:00000:00074:2007/12/12 09:38:20.96 kernel  Cannot read, host process disconnected:  3688 spid: 74
00:00000:00104:2007/12/12 09:38:20.96 kernel  Cannot read, host process disconnected:  3688 spid: 104
00:00000:00083:2007/12/12 10:22:57.41 kernel  Cannot send, host process disconnected:  -129031 spid: 83
00:00000:00000:2007/12/12 10:32:07.80 kernel  nrpacket: recv, Connection timed out
00:00000:00169:2007/12/12 10:34:14.79 kernel  Cannot read, host process disconnected:  1520 spid: 169
00:00000:00120:2007/12/12 10:34:14.79 kernel  Cannot read, host process disconnected:  1520 spid: 120
00:00000:00000:2007/12/12 10:34:31.89 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2007/12/12 10:35:00.22 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2007/12/12 10:46:59.51 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2007/12/12 10:48:15.94 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2007/12/12 10:51:49.74 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2007/12/12 10:54:02.47 kernel  nrpacket: recv, Connection timed out
00:00000:00075:2007/12/12 11:07:45.51 kernel  Cannot read, host process disconnected:  740 spid: 75
00:00000:00059:2007/12/12 11:41:00.99 kernel  Cannot read, host process disconnected:  -89565 spid: 59
00:00000:00115:2007/12/12 11:46:05.24 kernel  Cannot read, host process disconnected: WXJS-18 3772 spid: 115
00:00000:00097:2007/12/12 12:05:58.48 kernel  Cannot read, host process disconnected:  -89565 spid: 97
00:00000:00093:2007/12/12 12:17:42.92 kernel  Cannot read, host process disconnected:  320 spid: 93
00:00000:00000:2007/12/12 12:18:59.09 kernel  nrpacket: recv, Connection timed out
00:00000:00103:2007/12/12 12:23:26.62 kernel  Cannot read, host process disconnected: WXJS-11 4076 spid: 103
00:00000:00160:2007/12/12 13:40:14.20 kernel  Cannot read, host process disconnected:  -194095 spid: 160
00:00000:00161:2007/12/12 13:40:14.20 kernel  Cannot read, host process disconnected:  -194095 spid: 161
00:00000:00035:2007/12/12 13:49:47.41 kernel  Cannot read, host process disconnected:  3236 spid: 35
00:00000:00135:2007/12/12 13:49:47.41 kernel  Cannot read, host process disconnected:  3236 spid: 135
00:00000:00120:2007/12/12 13:49:47.41 kernel  Cannot read, host process disconnected:  3236 spid: 120
00:00000:00115:2007/12/12 14:11:56.11 kernel  Cannot read, host process disconnected:  1420 spid: 115
00:00000:00000:2007/12/12 14:22:16.66 kernel  nrpacket: recv, Connection timed out
00:00000:00145:2007/12/12 14:58:59.50 kernel  Cannot send, host process disconnected:  -79869 spid: 145
00:00000:00117:2007/12/12 15:58:30.69 kernel  Cannot read, host process disconnected:  912 spid: 117

cndong

sybase 数据库能不能进行整理,就象磁盘整理一样,感觉最近数据量很大,

wnpers

好事儿啊，支持