This section lists known issues encountered when installing the repository on Sybase Adaptive Server Enterprise.
General Considerations
The PowerDesigner repository database is required to process large transactions and
we recommend that it is created and maintained by an experienced DBA. You should:
- Ensure that ASE has enough CPU and Memory. The following ASE parameters must
frequently be configured higher than their default settings to optimize
check in of models:
- number of open objects
- number of open indexes
- number of locks
- max memory
- procedure cache size
- statement cache size
- Ensure you have a reasonably large log and proper log management to handle
long-running transactions .
- Use update statistics regularly to update information about
the distribution of key values. Job Scheduler should be configured for this
if the database is to be unattended.
- [15.0.2 and higher] Consider enabling literal autoparameterization
literal_autoparam
- Consider using directio to bypass the operating system
buffer cache and write directly to disk.
- Monitor and consider modifying default network packet size
from its default value of 2048 bytes.
Must declare variable '@dr_t_a0'. SQLSTATE = ZZZZZ
If you see the above error and are connecting to an ASE server via ODBC, open the ODBC Data Source Administrator, select your data source, and select the Enable Dynamic Prepare option on the Connection tab.
Truncated data on extraction
If you are seeing data truncated on extraction from the repository and are connecting to an ASE server via ODBC, open the ODBC Data Source Administrator, select your data source, and enter the value 10000000 in the Text size field on the Advanced tab.
If characters such as the ellipsis are being truncated, you should verify that the character set of your driver matches the setting for your database.
Connection Profile: "Error converting characters into server's character set"
If you receive such a conversion error when working with a connection profile, click the ellipsis button to the right of the Connection parameters field on the Connection Profile Definition dialog, add the CharSet parameter, and enter the appropriate charset value to match your repository database.