ASE 12.5 for Linux installation procedures Please refer to the specific installation Sybase System Directory (Chinese version) Adaptive Server Enterprise 12.5 Linux/Intel. In this paper, quite a few online reference information, thank them! (A) the root is available at : Sybase System to create users and user groups (useradd, groupadd or linuxconf) Mount CDROM #mount /mnt/cdrom (#mount T iso9660 /dev/cdrom /mnt/cdrom) SYBASE installation products (1) the selection of characters form (which can cause shells) # Rpm -ivh /mnt/cdrom/RPMS/sybase-common-12.5-3.i386.rpm # Rpm -ivh /mnt/cdrom/RPMS/sybase-ase-12.5-3.i386.rpm # Rpm -ivh /mnt/cdrom/RPMS/sybase-chinese-12.5-3.i386.rpm # Rpm -ivh /mnt/cdrom/RPMS/sybase-monserver-12.5-3.i386.rpm # Rpm -ivh /mnt/cdrom/RPMS/sybase-openclient-12.5-3.i386.rpm # Rpm -ivh /mnt/cdrom/RPMS/sybase-efts-12.5-3.i386.rpm # Rpm -ivh /mnt/cdrom/RPMS/sybase-esql-12.5-3.i386.rpm # Rpm -ivh /mnt/cdrom/RPMS/sybase-sqlremote-7.0.2-1.i386.rpm (2) The authority of Sybase System users After installation, users SYBASE Sybase System account and automatically set up a good environment variables, as long as the user changes the password Sybase System; (3) amend the Sybase System Directory Access to /tmp #chmod O+wx /tmp Sybase System can be made to re-start the /var/lock/subsys/sybase Directory Access #chmod O+rwx /var/lock/subsys (4) to users of Sybase System environment variables Editor users download documents : For example : bash users, document editing bash_profile $ Vi. Bash_profile DSQUERY=www LANG=us_english Export LD_ASSUME_KERNEL=2.4.19 Export THREADS_FLAG=native Put $SYBASE/install join PATH (5) the creation of the preparatory work before ASE Server OS shared memory default values for the majority of Linux versions of 32MB. Adaptive Server, the minimum requirements for RAM. Each request must fine-tune the biggest pile The size of the shared memory, transferred /proc catalog. Check the availability of the operating system Size. # Ipcs -lm | grep 'max rules governing powers and size' Max rules governing powers and size (kbytes) = 32768 Parameters for the new operating system shared memory size. For example, it is necessary to change the Shared Memory For the 512MB, and can import : #echo '512 * 1024 * 1024' |bc " Proc/sys/kernel/shmmax The change is effective testing : # 'Pcs -lm | grep' max rules governing powers and size ' Max rules governing powers and size (kbytes) = 524288 To avoid the need for this change after each restart /etc/sysctl.conf Revised document, after his accession kernel.shmmax=128*1024*1024 (Windows) memory (for a byte). (6) the installation of Sybase, the first backup /etc/ld.so.conf : Cp /etc/ld.so.conf /etc/ld.so.conf.sybase Please reference to other reasons (7) registration SYBASE Sybase System users with landing $ /opt/Sybase-12.5/SYSAM/bin/startd.sh $SYBASE/SYSAM $ Cd /opt/Sybase-12.5/SYSAM $ Lmgr Import : ． serial number ． function name ． Count function ． Software Version ． authorization code Adaptive Server software to provide the authentication information typed in "Sybase software - Asset management certification ". Permit the importation of all, clicking on the words "complete"! (Windows2k the authentication information should also be used in sybase12.5 for Linux, we can try it) Testing software in operation : When lmgrd guardian proceedings, it will be automatically activated guard SYBASE procedures. Permission to test License management software running on the system. : $SYBASE/SYSAM-1_0/bin/lmutil Lmstat-c Continuation of the installation or start Adaptive Server, and Sybase lmgrd confirm that the operation, "Up." Note : For the purpose of ensuring activated activated SySAM (Sybase Software Asset Management) mechanism permits : /etc/init.d/rc.local Adding : /opt/Sybase-12.5/SYSAM/bin/startd.sh /opt/Sybase-12.5/SYSAM (B) install ASE12.5 Sybase System users with landing (after the machine started again) (1) the selection of characters means -- Editor source document (/init/sample_resourde_files/srvbuild.adaptive_server.rs. /init/sample_resourde_files/srvbuild.backup_server.rs) /usr/ Copy of the source document will reserve list : $cp /init/sample_resourde_files/srvbuild.adaptive_server.rs /usr/ase.rs $cp /init/sample_resourde_files/srvbuild.adaptive_server.rs /usr/backup.rs Editor ase.rs, backup.rs -- Operation source document $ Cd /opt/sybase-12.5/bin $srvbuildres R /opt/sybase-12.5 /usr/ase.rs $srvbuildres R /opt/sybase-12.5 /usr/backup.rs 　　 (2) X-Windows ASE product configuration tool used asecfg 1, with Logon X-Windows Sybase System, the implementation of Sybase System installation of Contents (/opt/sybase-12.5/bin/) #asecfg Build New Servers choice. : Asecfg operations, there may be a wrong message : Error occurred during initialization of VM Unable to load native library : /opt/Sybase-12.5/jre/lib/i386 /libjava.so Symbol _libc_wait, version GLIBC_2.0 not Defined in time reference file libc.so.6 with link To solve the problem _libc_wait symbols, download the patch from http://metalink.oracle.com/ P3006854_ 9204_LINUX.zip. To use the patch, operation : $su-Root #unzip P3006854_9204_LINUX.zip #cd 3006854 [root@www 3006854]# 1s README.txt rhel3_pre_install.sh [root@www 3006854]# sh rhel3_pre_install.sh Or #rpm -ivh Compat-libcwait-2.0-2.i386.rpm 2, in srvbuild window, select the installation of server types. I have chosen four Server. 3, named to the Server. I will be named at Adaptive Server, accordingly, named www_back Automatic Backup Server, named www_mon Monitor Server, XP Server named www_XP. Click OK button, and enter the server configuration process. 4, Adaptive Server configuration. Or options to fill the following : Master device path (main equipment Path) : $SYBASE/data/master.dat Master device size (MB) (main equipment size) : 100 Master database size (MB) (main database size) : 60 Sybsystemprocs device path (system stored equipment Path) : $SYBASE /data /systemprocs.dat Sybsystemprocs device size (MB) (system stored equipment size) : 60 Sybsystemprocs database size (MB) (system stored database size) : 60 Error log path (path error log) : /opt/sybase-12.5/install/www.log Transport type (FTP type) : tcp Host name (mainframe) : 192.168.9.1 Port number (monitor port) : 5000 Click OK button, and into the next allocation process. 5, Backup Server configuration. Or options to fill the following : Error log path:/opt/sybase-12.5/install/www_back.log Tape configuration file:/opt/sybase-12.5/backup_tape.cfg Language : (fill) Character set : (fill) Maximum number of network connections:25 Maximum number of server connections:100 Transport type:tcp Host name:192.168.9.1 Port number:5001 Click OK button, and into the next allocation process. 6, Server Configuration Monitor. Or options to fill the following : Maximum number of connections:5 Error log path:/opt/sybase-12.5/install/www_mon.log Configuration file path:/opt/sybase-12.5/install/www_mon.cfg Share memory directory:/opt/sybase-12.5 Transport type:tcp Host name:192.168.9.1 Port number:5002 Click OK button, and into the next allocation process. 7, the distribution of XP Server. Or options to fill the following : Transport type:tcp Host name:192.168.9.1 Port number:5003 Build Server hits the button to start building Server, appear at a window, you can see the whole building process. If there is a similar show the following message that the successful creation Server : …… Www Server was successfully created. Done. 8, after the success of the installation to do a few things. Sybase System in the first users to download the Linux Console mode. ① Server confirm whether the operation. $SYBASE/install/ Rc.sybase status or use of showserver orders ($SYBASE said the installation of Sybase System catalog), a system should be able to see some of Sybase System related processes. Or using the isql -Usa P -Swww $SYBASE/bin/ order to download server, we should be able to see the suggested isql "Profession" and then dialing can be withdrawn from the exit. ② installed sa account password. Server installed, the system automatically establish sa users, system administrators, the whole system has the greatest power, but this time the sa password to be empty, must immediately change. $SYBASE/bin/isql -Usa P -Swww 1>sp_password null, the new password 2>go ③ closure of the main equipment default state. Otherwise, users of the database will be installed in the main equipment. $SYBASE/bin/isql -Usa -Swww Password : (import new password) 1>sp_diskdefault master, defaultoff 2>go ④ The default storage hosts文件 antimoine the mainframe counterparts who are 127.0.0.1, Sybase System users will not have to connect to the network, the hosts need only add the first line Hostname 192.168.9.1 can remember running Sybase System can change! There is already open Sybase System attention firewall port (using setup, change iptable) ⑤ users have always said that we must bring under antimoine isql in the S parameter is not set DSQUERY caused only DSQUERY=www can be added to the export. Profile! 9, manual starter database $SYBASE/install/startserver-F $SYBASE/install/RUN_www "/dev/null $SYBASE/install/startserver-F $SYBASE/install/RUN_www_back "/dev/null Or $SYBASE/install/rc.sybase start Stop database $SYBASE/install/rc.sybase Stop State database access $SYBASE/install/rc.sybase Status RED HAT : Linux 9.0 or fedora core 4, I installed the acquiescence of Chinese (root user), the only Chinese-language zh_CN.GB18030/UTF-8, making SYBASE mountains. langue= zh_CN.GB18030 suggested that the environment variable does not exist or zh_CN.UTF-8 in $SYBASE/locales/locales.dat. I added a locales.dat his remarks, and the corresponding changes. [linux] Locale = zh_CN.GB18030, us_english, cp850 Locale = zh_CN.UTF-8, us_english, cp850 Locale = ENGLISH, us_english, cp850 Locale = en, us_english, cp850 Locale = en_US, us_english, cp850 Locale = us_EN, us_english, cp850 Locale = C, us_english, cp850 Locale=default, us_english, cp850 10, the provision of language, characters and classification Installation is completed, return to the main window sybsetup Localize choice Adaptive Server, Adaptive Server and choose names continue 按OK Us opt for the English language. Character Set Code Page 850. Altername dictionary for classification and sorting accent with case insensitivity Or Set up operations $SYBASE/bin/sqlloc Languages= "us_english" Code = "cp850" Sort order= "Altername dictionary sorting and accent with case insensitivity" Clients were also installed in c:\sybase\locales\locales.dat [linux] Top and the bottom line iso_1 into cp850 case, the client can show the Chinese. 11, edited and revised /opt/sybase-12.5/SYBSERVER.cfg (SYBSERVER for Sybase server name) Max network packet size = 2048 Default network packet size = 1024 Number of user connections = 100 Number of open indexes = 2000 Number of open objects = 1000 Number of locks = 150000 That Sybase System Configuration Landing with isql Sp_configure "max mem", 100M Go Sp_cacheconfig "default data cache," "78K" Go 12, to connect to Sybase Adaptive Server Central Sybase Central provides a graphical user interface to control the enforceability of Adaptive Server Jimmy task. Sybase Central interface very similar to Windows resources management for all services The stratified layers shown in the left table, the details of the selected message server in the right layers. Choosing a server, which Shoot layers it can be left in the mouse. To start Sybase Central : $SYBASE/sybcent32/scjview Left in layers, Shoot to connect the server. "Download" window, the input system administrator user names and password. System administrators must take to download. : Bash-3.00$ operation. /scjview Error message as follows : \nStarting Sybase Central Java Edition (displaying to). . . \n /opt/sybase-12.5/shared-1_0/jre-1_1/lib/i686/green_threads/libzip.so : Symbol errno. version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so) Unable to initialize class java/lang/Thread can not find threads : Could not create Java VM Mv : can not stat `/tmp/scj_7784.log ': No such file or directory \n The following error (s) occured while running Sybase Central ----------------------------------------------------------- Cat : /tmp/scj_error.log : No such file or directory \nError (S) have been written to the file : /tmp/scj_error.log\n Solutions : vi $SYBASE/.profile adding : # If the core is 2.6.* above, into an LD_ASSUME_KERNEL 2.4.19 Export LD_ASSUME_KERNEL=2.4.19 Export THREADS_FLAG=native Then. /scjview Follows : Plug : $SYBASE/ASEP-1_0/ASEPlugin.jar se registration procedures, we can manage the database, and create a database configuration! 13, creation of databases ① create a database of equipment (Device) : Sybase database and the log database is built on the equipment, which can be physical disk, the disk operating system or district documents. Use disk init order to build up a database of equipment, use the default database diskdefault equipment specified in the order, and may designate a number of pre-defined database of equipment. Creating a database, the database is not specified equipment, the creation of the default database device. For example, executing orders : $SYBASE/bin/isql -Usa -Swww Password : (input password) 1>disk init name = "userdev", named names for the equipment userdev 2>physname = "/db/sybsystem/userdev.dat" document, entitled : An equipment userdev.dat 3>vdevno = 3, No. 3 : An equipment 4>size = 51200, named for the size 100M (51200 blocks, one block =2k) 5>go 1>sp_diskdefault userdev, designated as a default database device, named defaulton 2>go Second, the establishment of a database (Database) examples : 1.In disk init Ver.2 name = "branch60" - 3 physname = "/opt/sybase-12.5/data/branch60.dat" 4> vdevno = 4, size = 102400 (200m) ＜ 5 ＞ go ----------------- 1.In disk init Ver.2 name = "branch60_log" - 3 physname = "/opt/sybase-12.5/data/branch60_log.dat" 4> vdevno = 5, size = 51200 (100M) ＜ 5 ＞ go --------------------------------------- 1>create database branch60 2>on branch60 = 200 3>log on branch60_log = 100 4>go CREATE DATABASE : allocating 102400 logical pages (200.0 megabytes) on disk 'Branch60'. CREATE DATABASE : allocating 51200 logical pages (100.0 megabytes) on disk 'Branch60_log'. (C) Installation of grammar database and the database example First example of the creation of a database of available databases and database equipment grammar, size 10M, and a state of default. $SYBASE/bin/isql -Usa -Swww Password : (input password) 1>disk init name = "sybsyntaxdev" 2>physname = "/db/sybsystem/sybsyntaxdev.dat" 3>vdevno = 3, size = 5120 4>go 1>sp_diskdefault sybsyntaxdev, defaulton 2>go 1, the installation sybsyntax grammar database. This is done through $SYBASE/scripts/ins_syn_sql this script file to install. But ins_syn_sql need to change it, the equipment was removed beginning of a phrase used to designate the default database, adding "create database sybsyntax" sentence, and then the following order : $SYBASE/bin/isql -Usa P password -Swww -i $SYBASE/scripts/ins_syn_sql Grammar database installed, the system availability inquiries Transact sp_syntax stored procedure language, system stored procedure, the use of tools to help Sybase. For example, select orders apply : $SYBASE/bin/isql -Usa -Swww Password : (input password) 1>sp_syntax "select" 2>go 2, installation pubs2 and pubs3 example database. Documents example is the technical examples from the database. The following order : $SYBASE/bin/isql -Usa P password -Swww -i $SYBASE/scripts/installpubs2 $SYBASE/bin/isql -Usa P password -Swww -i $SYBASE/scripts/installpubs3 (4) the installation of ASE patch According to Server, the latest EBF10492.tar.gz ASE12.5 known that the number of problems. 1, first closing Server. $SYBASE/install/rc.sybase Stop or $SYBASE/bin/isql -Usa -Swww Password : (input password) 1>shutdown www_back, named closed Backup Server 2>go 1>shutdown, named closed Adaptive Server 2>go $SYBASE/bin/isql -Usa P password -Swww_mon 1>sms_shutdown, named closure Monitor Server 2>go 2, the root user to download the Linux Console mode. #mkdir /tmp/ebf, Named in the provisional list to create a patch available #mount T iso9660 /dev/cdrom /mnt/cdrom, named Kaodao loaded on the hard drive or CD-ROM #cp /mnt/cdrom/EBF10492.tgz /tmp/ebf Patch, named to the provisional list of complex systems #cd /tmp/ebf #tar -zxf EBF10492.tar.gz #rpm -ivh /tmp/ebf/ebf10492/RPMS/sybase-SWR-10492-1.i386.rpm From the root database, Sybase System users to download. As for a patch could not be activated after the database, need to re-implement $SYBASE/install/sybinstalll.sh, relocating $SYBASE Sybase System users to read and write authority. Ebfsetup make a shell script (based on the script to do the following ebf note) #!/bin/sh #filename : Ebfsetup #echo "Sybase System ebf10492.tar.gz setup. . . " #rpm -ivh /tmp/ebf/ebf10492/RPMS/*.rpm Echo "start Sybase System" $SYBASE/install/rc.sybase Start Echo "Sybase System status" Rc.sybase status Echo "Sybase System install script. . . 1 " Isql -Usa -Ppassword -Stimes n -i$SYBASE/scripts/installmaster -o m.txt Echo "Sybase System install script. . . 2 " Isql -Usa -Ppassword -Stimes n -i$SYBASE/scripts/installcommit -o commit.txt Echo "Sybase System install script. . . 3 " Isql -Usa -Ppassword -Stimes n -i$SYBASE/scripts/installdbccdb -o db.txt Echo "Sybase System install script. . . 4 " Isql -Usa -Ppassword -Stimes n -i$SYBASE/scripts/installsecurity -o security.txt Echo "Sybase System install script. . . 5 " Isql -Usa -Ppassword -Stimes n -i$SYBASE/scripts/instmsgs.ebf -o instmsgs.txt Echo "install script.finish : Sybase System. " 3, Sybase System users to download and launch Adaptive Server. $SYBASE/install/rc.sybase Start or $SYBASE/install/startserver-F $SYBASE/install/RUN_www "/dev/null $SYBASE/install/startserver-F $SYBASE/install/RUN_www_back "/dev/null (5) 1, the realization switched automatically loaded Sybase Started to make the original Sybase SQL Server, Sybase System generally required users to download. Linux systems can start to realize Sybase functional loading in the background, we can $SYBASE/install /sybinstall.sh Sybase System on #chkconfig In /etc/rc5.d/S85sybase AR /etc/init.d/Sybase Ln -sf /etc/init.d/sybase /etc/rc5.d/S85sybase considerable : Since the service started again on the worst 2, achieving shutdown automatically unload Sybase Sybase system to ensure the normal operation of each closed at the end of first Linux systems process Sybase SQL Server service #chkconfig On Sybase System, automatically /etc/rc0.d/K15sybase AR /etc/init.d/sybase 3, Sybase Secretary backup skills General Secretary of Sybase for use tape for backup media, but there was a better way, that is, back to the hard disk via compression, copy of the tape, so easy to restore more of a backup copy, but also save the backup time. Concrete realization of the following steps : (1) To establish the disk backup equipment Operation isql to enter sa Sybase system, which is as follows : Sp_addumpdevice "disk" disk_bkupdevice, /tmp/dumpdb 2 Go Sybase on the creation of a so called "disk_bkupdevice" backup equipment, which under the Unix System /tmp/dumpdb paper counterparts. (2) Create Backup users 以root身份 into Linux, new users backupdb, and belonged to the group of Sybase System. (3) amend the relevant documents Add the following lines : in /home/backupdb/.bash_profile SYBASE=/opt/sybase -12.5 DSQUERY=www PATH=$PATH:$SYBASE/bin Export PATH SYBASE DSQUERY Rm /tmp/backupdb.Z Echo "Backup SYBASE began :" Isql -Usa -Ppassword -ibackup.sql "/tmp/dbbackup.log Echo "Backup complete hard disk, the data is compressed backup documents :" Compress /tmp/backupdb Echo "it is copyed into the data being compressed backup tapes :" Tar c8v /tmp/backupdb.Z Echo "Backup! " Among them, "PASSWORD" password for the sa user, backup.sql is a simple text document, which reads as follows : Dump database db_main to disk_bkupdevice Go Backup log recorded in the implementation /tmp/dbbackup.log, of course, system administrators can also look through $SYBASE/install/backup.log Informed backup log. This backup methods require large enough hard disk space, this point system administrator for the district to pay particular attention to building Linux. (4) There are two methods : (A) bcp Backup Backup catalogs are /export $SYBASE/bin/bcp Databasename. . Tablename -out /export/tablename.txt -Usa -Ppassword -Swww-c (B) dump Backup Isql -Usa -Ppassword -Swww -ibackup.sql "/dev/null Backup.sql : Dump databasename to tran "/export/db_log.dat" with {no_log |truncate_only|no_truncate} Go Dump database databasename to "/export/db_1.1" Stripe on "/export/db_1.2" Stripe on "/export/db_1.3" Go Exit Timed backup on Crontab can be written : 00 23 * * * /opt/Sybase-12.5/ASE-12_5/bin/DUMPDB.sh ">//opt/Sybase-12.5/ASE-12_0/install/DUMPDB.out Liberation does not matter where a dumpdb.sh examples : #rh Linux #!/bin/sh Export SYBASE_FTS=FTS Export SYBASE_OCS=OCS Export SYBASE_ASE=ASE Export SYBASE_SYSAM=SYSAM Export LM_LICENSE_FILE=${SYBASE}/${SYBASE_SYSAM}/licenses/license.dat:$LM_LICENSE_FILE Export LD_LIBRARY_PATH=${SYBASE}/${SYBASE_ASE}/lib:${SYBASE}/${SYBASE_FTS}/lib:${SYBASE}/${SYBASE_OCS}/lib : ${SYBASE}/SQLRemote/lib:$LD_LIBRARY_PATH Export PATH= "${SYBASE}/${SYBASE_ASE}/bin:${SYBASE}/${SYBASE_ASE}/install:${SYBASE}/${SYBASE_OCS}/bin : ${SYBASE}/${SYBASE_SYSAM}/bin:${SYBASE}/shared/jre/bin:$PATH " Echo "Backup SYBASE began :" Su-Sybase System-c "isql -Swww -Usa P," "<! Dump database branch60 to "/export/dump.01" Stripe on "/export/dump.02" Stripe on "/export/dump.03" Go ! Echo "Backup complete hard disk, the data is compressed backup documents :" Compress /export/dump* Echo "Backup! " Here is a typical scenario for achieving full backup! #!/bin/sh # ************************************************************************* #for Full backup operation after excuted dbcc # ************************************************************************* Export SYBASE_FTS=FTS Export SYBASE_OCS=OCS Export SYBASE_ASE=ASE Export SYBASE_SYSAM=SYSAM LM_LICENSE_FILE=${SYBASE}/${SYBASE_SYSAM}/licenses/license.dat:$LM_LICENSE_FILE Export LM_LICENSE_FILE LD_LIBRARY_PATH=${SYBASE}/${SYBASE_ASE}/lib:${SYBASE}/${SYBASE_FTS}/lib:${SYBASE}/${SYBASE_OCS}/lib : ${SYBASE}/SQLRemote/lib:$LD_LIBRARY_PATH Export LD_LIBRARY_PATH PATH= "${SYBASE}/${SYBASE_ASE}/bin:${SYBASE}/${SYBASE_ASE}/install:${SYBASE}/${SYBASE_OCS}/bin : ${SYBASE}/${SYBASE_SYSAM}/bin:${SYBASE}/shared/jre/bin:$PATH " Export PATH Dump= "www" Ymd=`date +%y%m%d` Bk_db= "branch60" Cd /export #mkdir $ymd LOG= "/export/backup/$ymd" #mkdir $LOG #touch $LOG/backup.log Echo $ymd "$LOG/backup.log Echo "\n11*************************" ">$LOG/backup.log Echo "dbcc $bk_db Check database. . . "" >$LOG/backup.log D1=`date` Su-Sybase System-c "isql -Swww -Usa P," "<DBCC" $LOG/dbcc-$ymd.log 2>&1 Go Dbcc checkdb ($bk_db) Go DBCC Echo "dbcc! " D1=`date` Echo $d1, `date` ">$LOG/backup.log Echo "\n22*************************" ">$LOG/backup.log D1=`date` Dump_file= "/export/backup/$dump-$ymd.dat" Echo "Dump database $bk_db to" $dump_file ">$LOG/backup.log Touch $LOG/dump-$ymd.log Echo "Backup SYBASE began :" Su-Sybase System-c "isql -Swww -Usa P," "<DUMP" $LOG/dump-$ymd.log 2>&1 Dump database $bk_db to "$dump_file" Go DUMP #dump Database yourdatabasename to "/export/backup/dump.01" #stripe On "/export/backup/dump.02" #stripe On "/export/backup/dump.03" Echo $d1, `date` ">$LOG/backup.log Echo "\n33*************************" ">$LOG/backup.log Echo "Backup! " Please own system, and then use debugging! As for the backup log with a similar script, Sybase System in accordance with the relevant own grammar, a little change can! (5) restore backup catalog is /export ① bcp restore $SYBASE/bin/bcp databasename. . Tablename-in-b-c /export/tablename.txt -Usa -Ppassword -Swww Second, load restoration $SYBASE/bin/isql -Usa -Ppassword -Swww -irestore.sql "/dev/null Restore.sql : Load database databasename from "/export/db_1.1" Stripe on "/export/db_1.2" Stripe on "/export/db_1.3" Go Online database databasename Go Checkpoint Go Sp_dboption databasename 'single user' false Go Use databasename Go Checkpoint Go Dbcc checkdb (databasename) Go : Script : select.sql have Bcp Set on nocount Use pubs2 Go Select "bcp" + "" +databasename+. " . "+name+" "+" -out "+" "+" /path/ "+name+." Txt "+" -Usa -Ppassword -Swww-c "from sysobjects where type= 'U' Or Select "bcp" + "" +databasename+. " . "+name+" "+" - In "+" "+" /path/ "+name+." Txt "+" -Usa -Ppassword -Swww-b-c "from sysobjects where type= 'U' Isql -Usa P -Swww-b -iselect.sql -o bcpout Chmod → bcpout Hope that we can put forward their views, the revised unreasonable! I put the information online for a moment, I felt that I could, it is invoked, part of a revision! Thank them! Yes, the top Haotie! I would like to ask the landlord to a problem. I have two machines, were initially installed on the platform Covert LINUX7.3 12.5ASE Sybase System, installed REP12.5 complex system server. Were all normal. Later procured two machines, driven by linux7.3 support, but loaded redhat Linux ES3.1. Driving this upswing, sybase12.5ASE has also been promoted, but the complicated system installed REP. sybase-repsrv-12.5-1.i386.rpm and sybase-repsrvmgr-12.5-1.i386.rpm bottles and resume into a graphical interface, the characters become very smaller impossible to read. Several display window and jumped out immediately, the specific character underestimated unclear. What could that be? Strong! Haotie, collections, which are now learning Top thank landlord! Who knows how to solve this problem ah Http://www.lslnet.com/linux/#viewthread.php?tid=678993&extra=page%3D1 Very nice! National Taiwan Normal University, she responds : 8 am, the message read landlord, and the problem of the dual solution of several problems, really Li, huh, huh [ Closed window ]