Download IBM Informix Migration Guide

Transcript
Operating systems
not supported 1-5
supported 1-5
ORDER BY clause 7-2
Overview of migration process
S
1-1, 1-2, 1-3
P
PATH environment variable 6-4
Performance tuning
adjusting queries after upgrading 6-10
after upgrading 6-10
Planning
before moving data 2-1
data migration 2-1
for exporting and importing data 8-1
for migration 1-1, 3-1
for upgrading your server 3-1
Platforms, moving data between
compatible computers 2-6
post-migration steps 6-8, 7-15
Privileges 11-12, 11-13
required for onunload 13-5
Q
Queries
adjusting after upgrading
Quiescent mode 3-8
6-10
R
recompiling
client applications 6-9
Recompiling Java UDRs 7-14
Registering DataBlade modules 6-11, 7-16
Reserve pages, checking 6-9
restore points 15-1
RESTORE_POINT_DIR configuration parameter 6-6, 15-1
Reverse migration 7-1
Reversion utility 7-13
Revert to original version 7-1
Reverting
backing up before you start 7-10
before using the onmode -b command 14-1
chunk reserve pages 7-8
database schema 7-2
from the new version 7-1
from Version 12.10 7-12
limitations 7-2
remove features 7-12
restrictions for 7-2
restrictions for reverting to prior versions 7-2
using the onmode -b command 14-1
with Enterprise Replication 4-3
with HDR, RS, and SD servers 5-1, 5-10
with high-availability clusters 5-1, 5-10
ROOTOFFSET configuration parameter 6-4
ROOTPATH configuration parameter 6-4
ROOTSIZE configuration parameter 6-4
Running the reversion utility 7-13
Schema
create across a network 11-5
create for a database 11-5
display with dbschema 11-1
Screen reader
reading syntax diagrams A-1
scripts
convTovNoSQL1210.sql 6-8, 7-15
Scripts
concdr.bat 4-2
concdr.sh 4-2
SELECT triggers, disabling with dbexport 9-1
Shortcut keys
keyboard A-1
Simple large objects
moving with onload 13-10, 13-11
SKIP keyword 7-2
Slow queries
adjusting after upgrading 6-10
sm_versions file 6-8
smi_unld utility 7-9
Space
checking availability before migration 3-2
for sysmaster database 3-2
SQL keywords 18-1
SQL statements
UPDATE STATISTICS
data distributions 11-13
sqlhosts file
save a copy when migrating 3-5
sqlhosts file, UNIX
changing name or path 6-4
csm option 6-5
standards xiv
Starting
after upgrading 6-6
server after reversion 7-14
STOP_APPLY configuration parameter 9-1
Syntax diagrams
reading in a screen reader A-1
sysadmin database 19-3
sysbufpool table 19-3
syscdc database 19-2
sysdirectives table 19-3
sysmaster database
and logical logs 6-6
changes to 19-1
space required for migration 3-2
syssesappinfo database 19-2
System catalogs
changes to 19-1
checking tables 6-9
T
TAPEDEV configuration parameter, with onunload and
onload 13-11
Time series data
exporting 9-7
Transactions
checking for open ones 3-7
Truncate keyword 7-2
Index
X-5