Installation guide

Feature Considerations
Unicode non-
characters
If you used sp_configure to enable functionality group or permissive Unicode in
Adaptive Server 15.7 ESD #2, and also stored Unicode noncharacters (that is, u
+FFFF or u+FFFE) in a database, you may see a conversion error after you
downgrade to a version earlier 15.7 when Adaptive Server retrieves the data and
triggers a character set conversion.
To avoid such errors, search for and remove those characters from the system.
Disabled var-
binary trun-
cation
If you used sp_configure to turn on the disable varbinary truncation config-
uration in Adaptive Server 15.7, the varbinary data stored in the system may
have trailing zeros. When you downgrade to a version earlier than 15.7 ESD #2,
these trailing zeros are not removed and become part of the select output. This does
not affect query results involving comparisons.
Sharable in-
line default
If you used sp_configure to enable the sharable inline default setting in Adaptive
Server 15.7 and downgrade to a version earlier than 15.7, running the ddlgen utility
to generate data definition language can cause Adaptive Server to generate extra
create default statements. You can remove such statements before using the output
to create new schema.
Downgrading Job Scheduler
If you are downgrading to Adaptive Server versions 15.0 or 15.0.1, run installjsdb script from
the earlier version.
1.
Disable Job Scheduler:
1> sp_configure "enable job scheduler", 0
2> go
1> sybmgmtdb..sp_sjobcontrol @name=NULL, @option="stop_js"
2> go
2.
Follow the downgrade steps for your platform.
3.
After downgrading, enter this command from the earlier version of Adaptive Server:
isql –Usa –Psa_password –Sservername
–i$SYBASE/$SYBASE_ASE/scripts/installjsdb
Note: The directory with the isql executable ($SYBASE/$SYBASE_OCS/bin) must be
in your path.
4.
Enable Job Scheduler:
sp_configure "enable job scheduler", 1
5.
To start Job Scheduler, either restart the server, or enter:
1> use sybmgmtdb
2> go
1> sp_sjobcontrol @name=NULL, @option="start_js"
2> go
CHAPTER 11: Adaptive Server Downgrades
112 Adaptive Server Enterprise