sybase维护.txt
《sybase维护.txt》由会员分享,可在线阅读,更多相关《sybase维护.txt(7页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、 1. 09:12:49sybasemaster master master master1RUN_servername-T36072ASE$cd install$startserver -f RUN_servername -m3bcp out$bcp master.sysdevices out /sybase/wh/devs -Usa -P -c$bcp master.sysdatabases out /sybase/wh s -Usa -P -c$bcp master.sysusages out /sybase/wh/usages -Usa -P -c$bcp master.syslogi
2、ns out /sybase/wh/logins -Usa -P -c$bcp master.sysconfigures out /sybase/wh/configures -Usa -P -c$bcp master.syscharsets out /sybase/wh/charsets -Usa -P -c4shutdownASE5master豸$buildmaster -d -s(new_master_device_size2K)6RUN_servernamemaster豸master豸17/sybase/wh s/sybase/wh/usages(dbid=1,2,3)mastertem
3、pdbmodel8ASE$cd install$startserver -f RUN_servername -m9 bcp in(bcp outbcp in)$ bcp master.sysdevices in /sybase/wh/devs -Usa -P -b 1 -c$bcp master.sysdatabases in /sybase/wh s -Usa -P -b 1 -c$bcp master.sysusages in /sybase/wh/usages -Usa -P -b 1 -c$bcp master.syslogins in /sybase/wh/logins -Usa -
4、P -b 1 -c$bcp master.sysconfigures in /sybase/wh/configures -Usa -P -b 1 -c$bcp master.syscharsets in /sybase/wh/charsets -Usa -P -b 1 -c10ASE洢11installmaster$isql -Usa -P Cn Ci $SYBASE/scripts/installmaster master master豸load master master 1 2sysdevices,sysdatabases,sysuages,syslogins, sysconfigure
5、s, syscharsets3ASE 4 2.bcpinCTLIB Message: - L0/O0/S0/N0/0/0:blk_init(): blk layer: CT library error: Failed when CT_Lib routinect_results() called.blk_init failed.use mastergosp_dboption MBFEWKDB,bulkcopy,truegouse MBFEWKDBgoCHECKPOINTgo3.select * from mbfeghvsendlisthis where convert(VARCHAR(8),se
6、ttime,112)=200708024:reeor:692 rebuild l5.SYBASEsaServerisql -Usa -Psa_password -Sserver_name 汾汾12000 sp_configure upgrade version go 492 sp_configure upgrade version,492 go NULLsa123456 sp_password 123456,NULL,sa go 汾 sp_configure upgrade version,12000 go2.run_sybasedatabase-psa,6.lssp_dboption dbn
7、ame,option_name,ture false?trunc log on chkpt: truecheckpoint50?abort tran on log full falseture洢?allow nulls by defaultturenot nullnullANSI?dbo use onlytrue?ddl in tranture磺create tableddl in tran false?no chkpt on recoverysql servercheckpointtruecheckpoint?no free space acctgture?read onl
8、ytrue?select into/bulkcopytureselect intobcp?single usertruesp_dboptionisql CUsa CP1use MBFEWKDB2go1sp_dboption2godatabase_options - abort tran on log full allow nulls by default auto identity dbo use only ddl in tran identity in nonunique index no chkpt on recovery no free space acctg read
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- sybase 维护
限制150内