ASE for Windows FAQ ASE for Windows FAQ ASE can not install window flashing and over : When faced with this problem, it is clear two points : First, the ASE version 12.5.0; Second, the hardware for PIV above. This brought the JRE from ASE 12.5.0 installation JIT (Just-In-Time) Real-time compiler in existence PIV Bug. Solution : use a command-line window : Methods, JAVA_COMPILER=NONE first set, then running the installation process; Method 2 : delete or re-named ASE shared-1_0\jre1.2.2\bin\symcjit.dll installation of the paper catalog; Method 3 : JRE 1.2.2 patch fight. Need to pay attention to is : after installation, according to the above method need to revise the system has been installed. ASE installation of the Chinese version of Windows 2000/XP/2003 Server / Client, meaningless drivel installation procedures When faced with such issues, the first of which is that you can explicitly install the ASE 12.5.0 is not 12.5.1/12.5.2/12.5.3/15. The reason is that the JDK version 12.5.0 installation procedures are too old to deal with imperfections in the culture. Solutions : 1. ASE software will be installed copy of a hard disk; 2. Shared-1_0 ASE entered the store's catalog of the 1986-1991 Judge jre catalog; 3. Font.properties.zh.NT4.0 re-named documents will be underlined version of its Windows 4.0 to Windows 2000 : Windows 2003 5.1> 5.0> 5.2> Windows XP ASE 12.5.0 installation drawings, from the "start" menu operation configuration tools being given the wrong message : "Invalid command line argument 'and'. " Solution : start syconfig command line. Windows2003, started service from ASE 12.5 Encounter this problem, apparently ASE version 12.5.0. Windows 2003 amended the service adapter, and Windows 2003 in ASE 12.5.0 first release. EFFECTS OF EBF solution : install 11,449, problems can be solved. Installation of ASE, a high signal has been installed version ASE Installation, the Windows installation catalog in the vpd.properties ASE recorded a version of the information document. The document can be deleted or renamed. Automatic backup of the database using Windows tasks For some small businesses, a limited budget, may not be able to buy back the high cost of commercial software, manual backup was too cumbersome and easily forgotten. In fact, the mission plans to use Windows can solve their own problems. OFF REMECHO REM inspection parameters IF "teir" ====== "" GOTO displayUsage IF "%2" ====== "" GOTO displayUsage IF "%3" ====== "" GOTO displayUsage IF "%4" ====== "" GOTO displayUsage REM 10 before admission system SET day=%DATE:~-10% REM take time to complete the current, changed the ̲ : : : SET currentTime=%TIME =_% SET : =0% currentTime=%currentTime REM installed backup route REM This manual backup set to be released, and prior to create good. SET localBackupDir=C:\dbbackup SET remoteBackupDir=D:\RemoteBackup REM installed backup server REM set up local log trails only at the local log! SET defaultBackupServer=SYB_BACKUP IF "%5" ====== "" ( SET backupServer= SET logDir=%defaultBackupServer% SET backupDir=%localBackupDir% ) ELSE ( SET backupServer=at %5 SET logDir=%5 SET backupDir=%remoteBackupDir% ) IF NOT EXIST %logDir% mkdir %logDir% REM installed backup file name, service name : database format. Database name. Date. Time. Dmp SET filenamePrefix=%1.%4.%day%.%currenttime% SET dmpFile=%backupDir%\%filenamePrefix%.dmp REM SQL Temporary Document SET sqlFile=%1.%4.dump.sql REM Log File SET logFile=%logDir%\%filenamePrefix%.log REM provisional document SQL Echo dump database %4 to '%dmpFile%' %backupserver% "%sqlfile% Echo go, ">%sqlfile% REM Backup Isql -S%1 -U%2 -P%3 -i%sqlfile% -o%logfile% ECHO backup completed, check log files %logFile%. GOTO finished DisplayUsage : ECHO Usage : ECHO per 1,000 service user password databasename [backupserver] ECHO service name : Sybase services ECHO user name : users ECHO password user passwords : ECHO databasename database name : ECHO backupserver : backup server, and optional ECHO ECHO manually installed backup catalog and prior to create! ECHO log catalog will be built under the current runtime ECHO backup file name format : ECHO sets the "service name" database "sets date" sets time, ".dmp Finished : BAT script above to be separate documents, and corresponding amendments to the backup catalog. To set up task, calling BAT documents, forms Call reference scenario. ASE On Linux FAQ On the note 装LINUX The issue of using kernel version 2.4.x, RH AS3, the choice to install the package should choose development kits; As regards the issue of version 2.6.x. kernel, such as RH composites, the choice to install the development packages in addition to the package, but also left to choose application development kits. For 文 should choose all packets (文 only two options). Recommends beginners choose to be fully installed. Memory allocation Linux distribution for the largest shared memory acquiescence 32M. To install Sybase ASE, it is necessary to increase the largest shared memory. For Kernel 2.4.x and above, the simplest way is editor /etc/sysctl.conf increase his kernel.shmmax, before giving effect to the operation /sbin/sysctl-p (restart automatically force). I have the following line : /etc/sysctl.conf document kernel.shmmax = 268435456 trip to 256M of shared memory largest installed. You can also order directly with the following documents : echo 268435456 /proc update "on /etc/rc.d/rc.local /proc/sys/kernel/shmmax you can order this (or your system documentation), Automatic operation so at the time. Kernel release version 2.6 (including RedHat, SuSE) Although the default kernel largest shared memory allocation for 8G (check orders through ipcs l), but still need configuration for unknown reasons. DC 5.0 and the installation process 文 directly /etc/sysctl.conf revised increase of kernel.shmmax firms, there is no need for further adjustments are necessary to complete the creation of database services. Sybase users must use sh? The answer is : No.. Sybase System installation manuals often require the creation of some users, the users of the sh shell, in fact, totally unnecessary. OS tacit bash completely satisfy. How to set up a Sybase environment? The most convenient way is to use root users to copy $SYBASE/SYBASE.sh /etc/profile.d catalog, attributes its revised to 755. Thus, the system automatically set up for each user Sybase environment. (Bash and sh) if you wish to set up individual users Sybase environment : Bash : SYBASE.sh content of the document to the expansion of the main users of the catalog. Bashrc documents. Sh : SYBASE.sh paper copy to the main catalog users, both named. Profiled documents. LANG=C must be installed? The answer is : No.. Some users will require the installation manual normally installed LANG environment variable to "C." Setting up a "C" relatively easy, but this does not mean that we can not use other values, such as zh_CN.GB18030. But attention is that when LANG=zh-CN.GB18030, the need to amend section Linux $SYBASE/locales/locale.dat document will zh-CN.gb18030 zh-CN.GB18030 changed. : ( Sybase can not activated automatically activated Ok, this question should only ASE12.5.0 (including) the following version, and the adoption of the Linux kernel version 2.4.x be able to, because since 12.5.1, Sybase no longer activated script. : (ASE script started using a revenue-generating software (not remember the specific name) to obtain a list of ASE. When there are multiple matching records, the software is only the first return to the first record, as it happens, is the installation of ASE list, but was later modified by the software to return, a return to the table. : The solution is to directly alter the script. read the actual list. :) /etc/init.d/sybase Separate document for this script, and change attributes to 755 documents. Sybase and Sybase users attention to the installation of the revised list. SYB_HOME=/opt/sybase SYB_USER=sybase then connect to a service-level operation, usually operating level 3 and 5. Automatically activated : ln ln-s-s /etc/init.d/sybase /etc/rc.d/rc3.d/S99sybase /etc/init.d/sybase /etc/rc.d/rc5.d/S99sybase Start of topic | Skip to actions Sybase ASE Common Questions and Answers Why not set up the production environment truncate log on checkpoint? Some users coveting simple, installed in a production environment truncate log on checkpoint. Their intent is nothing more than a result of operations to avoid a full log standstill. Actually, this provision may bring an irreparable disaster. Service was cut off because, according to a recent current affairs of the whole can no longer prepared to resume! If this period of problems, such as damage to disk, it would lead to massive data loss. In the production environment, through reasonable allocation strategy for the whole backup and incremental backup equipment. The whole strategy is to prepare a typical week, a daily incremental backup. According to its own users to the actual application (data, incremental data and the importance of data and other factors), a reasonable adjustment, changed twice a day incremental backup. If a large number of imported data may be a full log, it may truncate the log on temporary checkpoint, but note : The completion of data being transferred, this provision should be lifted immediately, and immediately the whole preparation. Separation of log data and how? 1, backup database, including the master, and you have to separate data and log application repository (nonsense, according to Sybase ASE Guide for routine maintenance and system administrators, this step is essential, to the extent not write down the steps); 2, a separate inspection log storage equipment, if any, went directly to Step 5; 3. Add a disk equipment : init. . . . . ; 4, alter database db_name log on new_log_device=xxx 5, sp_dropsegment logsegment, db_name. device_name 6, and check whether they have been separated from their (or sp_helplog sp_helpdb); attention is the fact that a similar message sp_helplog would suggest the following : No valid log device can be found to contain the starting logpage of 'xxxx' on database 'xxxxx'. Perhaps the segment mapping of database has changed recently. Please inspect the sysusages catalog and contact your system administrator. You do not have tensions. (Segment) is the target for how future management of distribution space, the addition and removal of the mobile segment is not already allocated space. Log at least one expansion (extend) in the previous segment (also remember, targeted distribution storage unit, based extend to the actual units. ). If the current extend be filled, we need to log allocation, ASE will be allocated in the new segment (segment constraints it had to do so). At this time, cut off the log can extend the recovery of the previously allocated. 7, therefore, if they do not want to see sp_helplog the "wrong output," you can create a temporary table, then insert sufficient data to the surface, and then cut off the log; 8, the old rule that is a very important step : Backup databases, including the master log and the application and your data separate reservoir. ASE new services or new installation, not connected backup server ASE or the installation of new services, or attempt to dump the database load is always suggested that the following information : Can 't open a connection to site' SYB_BACKUP 'See the SQL Server error log file in the boot directory. Error code = 7205 Usually, this is because ASE install / service led to the initialization procedure Bug. In the creation of services, ASE will provide a similar XXXX_BS named the backup services, the master. . Sysservers insert a corresponding record. FLYBAEN to serve the people as an example, documents and interfaces sysservers below the record : Interfaces content of the document : FLYBEAN_BS Master tcp ether FLYBEAN_LINUX 5001 Query tcp ether FLYBEAN_LINUX 5001 Sysservers records : (select srvname, srvnetname from sysservers where srvname= 'SYB_BACKUP') Srvname srvnetname          ------------------------------ -------------------------------- SYB_BACKUP FLYBEAN_BS The backup server is usually acquiescence SYB_BACKUP. In load/dump, ASE sysservers access to the backup server interfaces corresponding information, then search for the service interfaces document the actual location (IP and port). In this case, ASE through sysservers FLYBEAN_BS be entitled to the service interfaces, which then interfaces physical access to the service information. If the srvnetname sysservers ASE unable to obtain relevant information on interfaces that will be reported in the above error. Then the solution is very simple. Method 1 : The revised document interfaces, sysservers.srvnetname service name was changed to the corresponding value; Method 2 : Laws sysservers srvnetname records of the value of the corresponding document interfaces to the service members. How to configure the backup job? Since 11.9.2 (to be confirmed), the ASE site backup support, the specific method for the following two assumptions : ASE database server, A and B, respectively, as follows : SRV_A database services, SRV_A_BS; SRV_B, SRV_B_S. We should DB_1 backup B to A on the database. 1. B of the revised document interfaces, SRV_A_BS increase in the allocation, for instance : SRV_A_BS A master tcp ether BS_PORT A query tcp ether BS_PORT 2. SRV_B with isql posted to a remote service SRV_B increase SRV_A_BS sp_addserver : "SRV_A_BS" null "SRV_A_BS" 3. Test : A database DB_1 to dump in the path and file name at "SRV_A_BS" Shen Hao Tie on the so - Top about Top up Top Top, LZ continue [ Closed window ]