|
Sybase ODBC 12.5 bug
|
| |
Hi All
set ansi null of is given in intitialisation string in the advanced
tab of ODBC 12.5. This set up is not working in Windows Server 2003
whereas it works in windowsxp.
set ansi null of is given in intitialisation string in the advanced
tab of ODBC 11. This set up is working in Windows Server 2003 whereas... more »
|
|
|
Replication Server
|
| |
Is anyone help me to optimize the insert operation on the WARM
standby .The million of records on the PRIMARY disturb the replication
system
|
|
|
How to improve create non-clustered index performance
|
| |
Hi Gurus,
I have an 7*24 OLTP banking system which run a purge job weekly.
The purge job simply:
a) drop all indices from a large table (10G data)
b) delete many records from the large table
c) re-create all indices
The table has 11 non-clustered indices, there's no clustered index.
Application team complained that the purge job takes too long to complete (more than 3 hours) we (DBA) identified that the bottleneck is the step c of the job -- re-create all indices... more »
|
|
|
Partitioning tables
|
| |
Hi, I'm wondering if it's necessary an extra Sybase product for partitioning tables or not.
|
|
|
Identify Table READERS without Audit in Sybase
|
| |
Hi,
We are in the process of moving an application (and its tables) out of a 11.9.2 Sybase database and found that there could be several unknown _readers_ of data from those tables (we believe we have all the writers captured). The tables here are a subset (approx 35 tables) of the entire database (approx 800 tables).... more »
|
|
|
Update image columns
|
| |
We have an urgent problem that we need to resolve and our Sybase
experience is limited. We're using Sybase ASE 15.0.3
Table structures are as follows:
Table T1:
C1 numeric(18)
C2 image
C3 int
C4 varchar
Table T2:
C1 numeric(18)
C2 image
Sequence of events are as follows:
1. Application A inserts the following record into T1 (1,null,... more »
|
|
|
sybase ldap (Active Directory 2008R2) Integration
|
| |
Hi Expert, i trying connect sybase with ldap.
Sybase Control Center show Invalid Login! but the agent.log show user
successfully logged in.
012-03-19 15:20:09,017 [INFO ]
[ldap.LDAPLoginModule ] [RMI TCP
Connection(248)-127.0.0.1] - Authentication succeeded using: LDAP SUP... more »
|
|
|
Units for Sybase Monitoring
|
| |
Hi Guys,
Could any one help me on the following:
1) sp_monitorconfig "max memory" gives values for the following
Num_free
Num_active
What is the units used here? Are thes in bytes/kilobytes.
2) In Sybase MDA tables,
monDeviceIO table has the following columns:
-Reads
-Writes
-APFReads... more »
|
|
|
dbisql output when using temporary tables in stored procedure
|
| |
Hi.
I'm trying to output results of my stored procedure to an Excel file
and calling this from a batch file to run regularly.
I'm using:
Adaptive Server Enterprise/15.0.3/EBF 16738 ESD#2/P/NT(IX86)/Windows
2003/ase1503/2708/32-bit/OPT/M on Jul 27
20:19:56 2009
Interactive SQL version 11.0.0 build 1649... more »
|
|
|
