Tutorials to .com

Tutorials to .com » Database » Sybase Tutorial

Sybase Tutorial Articles


1: IPhone the most important enterprise-level Sybase solutions
The world's leading enterprise-class and mobile software company Sybase has announced that in order to increase support for iPhone, especially the introduction of the latest version of iAnywhere ® Mobile Office, the new version has been ava...

2: Sybase SQL Server logs the problem of universal
*** NOTICE: space used on the log segment is 12.87Mbytes, 64.35% *** NOTICE: space free on the log segment is 7.13Mbytes, 35.65% 1>; use database_name 2>; go 1>; select data_pgs (8, doa mpg) 2>; from sysindexes where id = 8 3>;...

3: Several Sybase database configuration issues
use master go dump transaction DATABASENAME, trunc, true go use DATABASENAME go checkpoint go use master go sp_dboption DATABASENAME, "bulkcopy", true go use DATABASENAME go checkpoint go use DATABASENAME go sp_dropsegmen...

4: Sybase data back-up use of BCP Profile
bcp dbname..tablename out c:tempfilename -Usa -Ppassword –Sservername –c ...

5: How do I clear all of the SYBASE RSP outbound or inbound data queue?
1, Replication Server in standalone mode start (to batch add "-M" parameter to start); ...

6: Data in a multi-node environment to data collection to the Headquarters Division database
Copy the server to support one-on-one and many-to-one copy mode, usually corresponds to the number of actual work site to its superior grass-roots site data management, all aspects of primary source data collection and aggregation in time to the man...

7: Sybase Hot achieve
Under normal circumstances, when the system can not function properly, we need to use artificial methods of fault identification, analysis, recovery and testing. These will need to spend a long time. During this time, the system must come to a halt ...

8: Sybase replication server with dual-drive backup Sybase
Operating system requirements Item Request CPU Pentium processor RAM Minimum 32MB RAM Disk space At least 150MB of available hard disk space Operating system Windows NT4.0 Service Pack 3, Windows2000 Service Pack 1 Other hardware Recomme...

9: Data nodes in a multi-environment data willDivision headquarters site
Copy the server to support one-on-one and one-to-many mode of reproduction, usually correspond to the actual work site from a grass-roots level to one or more data management site, will be the source of grass-roots data collection and timely transmi...

10: Data replication through the realization of heterogeneous database and Sybase databases and integration of data replication
Sybase replication server support and non-Sybase database replication between the data model, such as through the use of Sybase replication agent, for access to IBM mainframe DB2 database update services, and copy to a copy of ASE server for use in ...

11: In two separate inter-server database by copying the Hot Standby
Copy the server to support one-to-one copy mode, copy Warm standby server for the Adaptive Server or SQL Server database to maintain a double, one of the other activities as a warm backup database. When the user modify the activities of the database...

12: Sybase-Oracle heterogeneous database connectivity and database replication
Sybase-Sybase replication server work ...

13: Summary: How do I restrict sa login Sybase ASE
Sybase ASE characteristics of the use of stored procedures to provide sp_modifylogin, on the registry to verify the legitimacy of. usemaster go dropproceduresp_bindlogin go createproceduresp_bindlogin as begin declare @ hostnamevarchar (100)...

14: Qiao SYBASE database to restore the password field
A, Sybase database management account and password Overview: ...

15: Understanding of the availability of Sybase cursor and attributes
Not all of the interface for all the cursor types of support. ...

16: Sybase database to restore common catastrophic
no% Jx ^, UNIX: O; PA p 11.0 *: $ SYBASE / install / errorlog ^ r a> pf0 11.5 * or 11.9 *: $ SYBASE / install / <server_name>. Log lx l *. m [ 12.0 * SYBASE / $ SYBASE_ASE / install / <server_name>. Log) 5A "H Povx NT: $? W ...

17: From three areas on how to properly optimize the "SQL"
SAN FRANCISCO-IT technical reports on how to properly optimize】 SQL? Many people in the use of SQL often fall into the fallacy that is too much focus on the results is correct, the neglect of different methods that may exist between the achieveme...

18: ASE lock mode: AllPages DataPages DataRows
SAN FRANCISCO-IT technical reports Sybase ASE】 There are three lock modes: AllPages, DataPages, DataRows Sybase's data table pages and index pages, the minimum allocation unit of pages, the lock mode for a different table pages and index page...

19: Personal experience: Sybase database backup program-wide
SAN FRANCISCO-IT technical reports】 Sybase database products since its inception in 1987, its client / server (client / server) mode, the basis of distributed processing architecture, a comprehensive security performance, high-speed and efficient ...

20: Modify Sybase database on practical methods sa password
SAN FRANCISCO-IT technology issues reported】 Description: And some in the UNIX system can not start the Sybase Center, then under such circumstances how to modify it sa password, but if we do not have the password can also use this method to buy ...


Page 1 of 18
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]